Sàn Đá Thạch Anh Kobler Xương Cá V10R K88

ƯỚC TÍNH CHI PHÍ HOÀN THIỆN '); printWin.document.close(); setTimeout(function(){ printWin.focus(); printWin.print(); }, 500); } // ===== Helper: escape HTML chống XSS khi import ===== function hpqfEscapeHtml(s){ return String(s||'').replace(/[&<>"']/g, function(ch){ return {'&':'&','<':'<','>':'>','"':'"',"'":'''}[ch]; }); } function hpqfCleanClientText(s, max){ s = String(s || '').replace(/[\u0000-\u001F\u007F]/g, '').replace(/\s+/g, ' ').trim(); max = max || 500; return s.length > max ? s.slice(0, max) : s; } // ===== Helper: lọc URL ảnh an toàn ===== function hpqfSafeImageUrl(u){ const s = String(u||'').trim(); if(!s) return ''; if(/^https?:\/\//i.test(s)) return s; // Cho phép ảnh base64 từ clipboard/import, nhưng chỉ đúng MIME ảnh phổ biến và giới hạn kích thước chuỗi. if(/^data:image\/(png|jpe?g|webp|gif);base64,[a-z0-9+/=]+$/i.test(s) && s.length <= 5 * 1024 * 1024) return s; return ''; } // ===== Helper: chuyển chuỗi tiếng Việt → Title Case không dấu ===== function hpqfTitleCase(s){ return String(s||'') .normalize('NFD').replace(/[\u0300-\u036f]/g,'') .replace(/đ/g,'d').replace(/Đ/g,'D') .replace(/[^a-zA-Z0-9]+/g,' ') .trim() .split(/\s+/) .filter(Boolean) .map(w => w.charAt(0).toUpperCase() + w.slice(1).toLowerCase()) .join(' '); } // ===== Helper: slug lowercase liền (dùng cho đơn vị m2/cm/...) ===== function hpqfUnitSlug(s){ return String(s||'') .normalize('NFD').replace(/[\u0300-\u036f]/g,'') .replace(/đ/g,'d').replace(/Đ/g,'D') .toLowerCase() .replace(/[^a-z0-9]+/g,'') || ''; } // ===== Helper: tạo filename giống logic JSON ===== function hpqfMakeFilename(ext){ const titleEl = comp.querySelector('.hpqf-title'); const titleText = titleEl ? titleEl.textContent.trim() : 'Bang Bao Gia'; const partTitle = hpqfTitleCase(titleText) || 'Bang Bao Gia'; const partCust = hpqfTitleCase(inpCustomerName.value) || 'Khach'; const row1 = comp.querySelector('.hpqf-search-row[data-row="1"]'); const r1Name = row1 ? (row1.querySelector('.hpqf-search-name').value || '') : ''; const r1Qty = row1 ? (row1.querySelector('.hpqf-search-qty').value || '') : ''; const r1Unit = row1 ? (row1.querySelector('.hpqf-search-unit').value || '') : ''; const partProd = (hpqfTitleCase(r1Name) || 'San Pham').slice(0, 60).trim(); let areaPart = ''; if(r1Qty !== ''){ const q = parseFloat(r1Qty); if(isFinite(q) && q > 0){ const u = hpqfUnitSlug(r1Unit) || 'm2'; const qStr = (Math.abs(q - Math.round(q)) < 0.001) ? String(Math.round(q)) : q.toFixed(2).replace(/\.?0+$/,''); areaPart = '_' + qStr + u; } } return partTitle + '_' + partCust + '_' + partProd + areaPart + '.' + ext; } // ===== LƯU FILE JSON ===== function hpqfSaveJSON(){ const data = { version: '1.1', savedAt: new Date().toISOString(), orderDate: (comp.querySelector('.js-date-now') ? comp.querySelector('.js-date-now').textContent : '').trim(), orderCode: (comp.querySelector('.js-quote-code') ? comp.querySelector('.js-quote-code').textContent : '').trim(), completeChecked: !!(chkComplete && chkComplete.checked), code: (comp.querySelector('.js-quote-code')?.textContent || '').trim(), docType: selDocType ? selDocType.value : 'BẢNG BÁO GIÁ', paymentType: selPaymentType ? selPaymentType.value : 'vat-tu', vatRate: hpqfGetVatRate(), vat10Note: vat10NoteEl ? hpqfCleanClientText(vat10NoteEl.textContent || '', 160) : '', discountPercent: parseFloat((inpDiscountPct && inpDiscountPct.value) ? inpDiscountPct.value : 0) || 0, discountLines: parseInt((inpDiscountRows && inpDiscountRows.value) ? inpDiscountRows.value : 0, 10) || 0, deposit: hpqfParseMoneyInput(inpDeposit), deposit2: hpqfParseMoneyInput(inpDeposit2), deposit3: hpqfParseMoneyInput(inpDeposit3), customDot1: parseFloat((inpCustomDot1 && inpCustomDot1.value) || 0) || 0, customDot2: parseFloat((inpCustomDot2 && inpCustomDot2.value) || 0) || 0, customDot3: parseFloat((inpCustomDot3 && inpCustomDot3.value) || 0) || 0, customer: { name: inpCustomerName.value || '', phone: inpCustomerPhone.value || '', address: inpCustomerAddr.value || '', tax: inpCustomerTax.value || '' }, project: inpProject.value || '', guiChanhXe: inpGuiChanhXe ? (inpGuiChanhXe.value || '') : '', extraNote: inpExtraNote ? (inpExtraNote.value || '') : '', rows: [] }; const searchRows = comp.querySelectorAll('.hpqf-search-row'); searchRows.forEach(row => { const rowNum = parseInt(row.dataset.row); const kw = row.querySelector('.hpqf-search-keyword').value || ''; const name = row.querySelector('.hpqf-search-name').value || ''; const price = row.querySelector('.hpqf-search-price').value || ''; const unit = row.querySelector('.hpqf-search-unit').value || ''; const qty = row.querySelector('.hpqf-search-qty').value || ''; if(!kw && !name && !price) return; const imgEl = comp.querySelector('.js-row'+rowNum+'-img'); let imgSrc = ''; if (rowData[rowNum] && rowData[rowNum].customImage) { // Ảnh dán clipboard — ưu tiên lấy từ rowData imgSrc = rowData[rowNum].customImage; } else if (imgEl && imgEl.src && imgEl.style.display !== 'none') { // Ảnh URL bình thường từ WooCommerce imgSrc = imgEl.src; } data.rows.push({ keyword: kw, name: name, price: parseFloat(price) || 0, unit: unit, qty: qty === '' ? null : (parseFloat(qty) || 0), kt: (rowData[rowNum] && rowData[rowNum].kt) ? rowData[rowNum].kt : '', image: imgSrc, natural: (rowData[rowNum] && rowData[rowNum].natural) ? 1 : 0, bamboo: (rowData[rowNum] && rowData[rowNum].bamboo) ? 1 : 0, accessory: (rowData[rowNum] && rowData[rowNum].accessory) ? 1 : 0, completionBase: (rowData[rowNum] && rowData[rowNum].completionBase) ? 1 : 0, completeLtSku: (rowData[rowNum] && rowData[rowNum].completeLtSku) ? rowData[rowNum].completeLtSku : '', autoComplete: (rowData[rowNum] && rowData[rowNum].autoComplete) ? 1 : 0, autoRole: (rowData[rowNum] && rowData[rowNum].autoRole) ? rowData[rowNum].autoRole : '', autoSku: (rowData[rowNum] && rowData[rowNum].autoSku) ? rowData[rowNum].autoSku : '', autoQtyManual: (rowData[rowNum] && rowData[rowNum].autoQtyManual) ? 1 : 0, vat10: (rowData[rowNum] && rowData[rowNum].vat10) ? 1 : 0, manualNote: (rowData[rowNum] && rowData[rowNum].manualNote) ? hpqfCleanClientText(rowData[rowNum].manualNote, 300) : '' }); }); if(data.rows.length === 0){ alert('Chưa có sản phẩm nào để lưu.'); return; } const json = JSON.stringify(data, null, 2); const blob = new Blob([json], { type: 'application/json' }); const url = URL.createObjectURL(blob); const titleEl = comp.querySelector('.hpqf-title'); const titleText = titleEl ? titleEl.textContent.trim() : 'Bang Bao Gia'; const partTitle = hpqfTitleCase(titleText) || 'Bang Bao Gia'; const partCust = hpqfTitleCase(inpCustomerName.value) || 'Khach'; const firstRow = data.rows[0] || {}; const partProd = (hpqfTitleCase(firstRow.name) || 'San Pham').slice(0, 60).trim(); let areaPart = ''; if(firstRow.qty !== null && firstRow.qty !== undefined && firstRow.qty !== ''){ const q = parseFloat(firstRow.qty); if(isFinite(q) && q > 0){ const unit = hpqfUnitSlug(firstRow.unit) || 'm2'; const qStr = (Math.abs(q - Math.round(q)) < 0.001) ? String(Math.round(q)) : q.toFixed(2).replace(/\.?0+$/,''); areaPart = '_' + qStr + unit; } } const filename = partTitle + '_' + partCust + '_' + partProd + areaPart + '.json'; const a = document.createElement('a'); a.href = url; a.download = filename; document.body.appendChild(a); a.click(); a.remove(); URL.revokeObjectURL(url); } // ===== MỞ FILE JSON ===== function hpqfLoadJSON(file){ if(!file) return; if(file.size > 2 * 1024 * 1024){ alert('File quá lớn (>2MB). Có thể không phải file báo giá hợp lệ.'); return; } const reader = new FileReader(); reader.onload = function(e){ let data; try { data = JSON.parse(e.target.result); } catch(err){ alert('File JSON không hợp lệ.'); return; } if(!data || typeof data !== 'object' || !Array.isArray(data.rows)){ alert('File không đúng định dạng báo giá Hoàng Phát.'); return; } if(!confirm('Mở file này sẽ ghi đè dữ liệu hiện tại. Tiếp tục?')) return; const safeStr = (v, max) => (typeof v === 'string') ? v.slice(0, max||500) : ''; const safeNum = (v) => { const n = parseFloat(v); return isFinite(n) ? n : 0; }; // Khôi phục đúng ngày/mã đơn đã lưu trong JSON, không lấy ngày hôm nay. let loadedDate = safeStr(data.orderDate, 20); let loadedCode = safeStr(data.orderCode || data.code, 40); const metaSource = safeStr(data.orderDate || data.orderCode || data.code || data.savedAt, 80); if(!loadedDate && metaSource){ const m = metaSource.match(/(\d{4})-(\d{1,2})-(\d{1,2})/); if(m){ loadedDate = String(m[3]).padStart(2,'0') + '/' + String(m[2]).padStart(2,'0') + '/' + m[1]; } } if(!loadedCode && loadedDate){ const p = loadedDate.match(/^(\d{1,2})\/(\d{1,2})\/(\d{4})$/); if(p) loadedCode = 'HP' + p[3] + '-' + String(p[2]).padStart(2,'0') + '-' + String(p[1]).padStart(2,'0'); } if(loadedDate) comp.dataset.hpqfOrderDate = loadedDate; else delete comp.dataset.hpqfOrderDate; if(loadedCode) comp.dataset.hpqfOrderCode = loadedCode; else delete comp.dataset.hpqfOrderCode; if(chkComplete) chkComplete.checked = !!data.completeChecked; if(data.customer && typeof data.customer === 'object'){ inpCustomerName.value = safeStr(data.customer.name, 200); inpCustomerPhone.value = safeStr(data.customer.phone, 50); inpCustomerAddr.value = safeStr(data.customer.address, 500); inpCustomerTax.value = safeStr(data.customer.tax, 50); } inpProject.value = safeStr(data.project, 500); if(inpGuiChanhXe) inpGuiChanhXe.value = safeStr(data.guiChanhXe, 500); if(inpExtraNote) inpExtraNote.value = safeStr(data.extraNote, 500); hpqfUpdateExtraNote(); // ===== Khôi phục loại văn bản ===== if(selDocType && data.docType){ const allowed = ['BẢNG BÁO GIÁ', 'ĐƠN ĐẶT HÀNG', 'QUYẾT TOÁN', 'PHIẾU XUẤT KHO']; const dt = safeStr(data.docType, 50); if(allowed.indexOf(dt) !== -1){ selDocType.value = dt; hpqfApplyDocType(dt); } } // ===== Khôi phục loại thanh toán ===== if(selPaymentType && data.paymentType){ const allowedPay = ['vat-tu', 'cong-trinh', 'giao-chanh', 'thanh-toan-100', 'thanh-toan-50-50', 'form-chiet-khau', 'tuy-chinh']; const pt = safeStr(data.paymentType, 50); if(allowedPay.indexOf(pt) !== -1){ selPaymentType.value = pt; } } // ===== Khôi phục ghi chú VAT 10% ===== if(vat10NoteEl){ vat10NoteEl.textContent = safeStr(data.vat10Note, 160); } // ===== Khôi phục % VAT ===== if(vatRateEl){ let loadedVatRate = 8; if(data.vatRate !== undefined && data.vatRate !== null && data.vatRate !== ''){ loadedVatRate = safeNum(data.vatRate); } loadedVatRate = Math.max(0, Math.min(100, loadedVatRate)); vatRateEl.textContent = hpqfFormatVatRate(loadedVatRate); } // ===== Khôi phục chiết khấu ===== if(inpDiscountPct){ const v = safeNum(data.discountPercent); inpDiscountPct.value = v > 0 ? v : ''; } if(inpDiscountRows){ const v = parseInt(data.discountLines || 0, 10) || 0; inpDiscountRows.value = v > 0 ? v : ''; } // ===== Khôi phục số tiền tạm ứng ===== if(inpDeposit){ const dep = safeNum(data.deposit); inpDeposit.value = dep !== 0 ? dep : ''; } if(inpDeposit2){ const dep2 = safeNum(data.deposit2); inpDeposit2.value = dep2 !== 0 ? dep2 : ''; } if(inpDeposit3){ const dep3 = safeNum(data.deposit3); inpDeposit3.value = dep3 !== 0 ? dep3 : ''; } // ===== Khôi phục 3 ô tùy chỉnh ===== if(inpCustomDot1){ const v = safeNum(data.customDot1); inpCustomDot1.value = v > 0 ? v : ''; } if(inpCustomDot2){ const v = safeNum(data.customDot2); inpCustomDot2.value = v > 0 ? v : ''; } if(inpCustomDot3){ const v = safeNum(data.customDot3); inpCustomDot3.value = v > 0 ? v : ''; } // ===== Reset toàn bộ dòng ===== comp.querySelectorAll('.hpqf-search-row').forEach((row, idx) => { if(idx > 0) row.remove(); }); comp.querySelectorAll('.hpqf-data-row').forEach((row, idx) => { if(idx > 0) row.remove(); }); Object.keys(rowData).forEach(k => { if(k !== '1') delete rowData[k]; }); totalRows = 1; rowData[1] = { price: 0, unit: '', qty: null, kt: '', natural: false, bamboo: false, accessory: false, completionBase: false, completeLtSku: '', autoComplete: false, autoRole: '', autoSku: '', autoQtyManual: false, vat10: false, manualNote: '' }; const row1 = comp.querySelector('.hpqf-search-row[data-row="1"]'); if(row1){ row1.querySelector('.hpqf-search-keyword').value = ''; row1.querySelector('.hpqf-search-name').value = ''; row1.querySelector('.hpqf-search-price').value = ''; row1.querySelector('.hpqf-search-unit').value = ''; row1.querySelector('.hpqf-search-qty').value = ''; } setText('.js-row1-name',''); setText('.js-row1-unit',''); const r1kt = comp.querySelector('.js-row1-kt'); if(r1kt){ r1kt.innerHTML=''; r1kt.style.display='none'; r1kt.classList.remove('hpqf-kt-empty'); } const r1img = comp.querySelector('.js-row1-img'); if(r1img){ r1img.src=''; r1img.style.display='none'; } const rows = data.rows.slice(0, 50); rows.forEach((item, idx) => { if(!item || typeof item !== 'object') return; const targetNum = idx + 1; if(targetNum > totalRows) addNewRow(); const targetRow = comp.querySelector('.hpqf-search-row[data-row="'+targetNum+'"]'); if(!targetRow) return; const cKw = safeStr(item.keyword, 300); const cName = safeStr(item.name, 300); const cPrice = safeNum(item.price); const cUnit = safeStr(item.unit, 30); const cQty = (item.qty === null || item.qty === undefined || item.qty === '') ? null : safeNum(item.qty); const cKt = safeStr(item.kt, 500); const cImg = hpqfSafeImageUrl(item.image); targetRow.querySelector('.hpqf-search-keyword').value = cKw; targetRow.querySelector('.hpqf-search-name').value = cName; targetRow.querySelector('.hpqf-search-price').value = cPrice; targetRow.querySelector('.hpqf-search-unit').value = cUnit; targetRow.querySelector('.hpqf-search-unit').dataset.hpqfUnit = hpqfNormUnitText(cUnit); targetRow.querySelector('.hpqf-search-qty').value = (cQty === null ? '' : cQty); const vat10Check = targetRow.querySelector('.hpqf-vat10-check'); if(vat10Check) vat10Check.checked = !!item.vat10; rowData[targetNum] = { price: cPrice, unit: cUnit, qty: cQty, kt: cKt, natural: !!item.natural, bamboo: !!item.bamboo, accessory: !!item.accessory, completionBase: !!item.completionBase, completeLtSku: item.completeLtSku === 'LT75' ? 'LT75' : (item.completeLtSku === 'LT79' ? 'LT79' : ''), autoComplete: !!item.autoComplete, autoRole: safeStr(item.autoRole, 30), autoSku: safeStr(item.autoSku, 30), autoQtyManual: !!item.autoQtyManual || !!item.autoComplete, vat10: !!item.vat10, manualNote: safeStr(item.manualNote, 300) }; if(rowData[targetNum].autoComplete){ targetRow.classList.add('hpqf-auto-complete-row'); targetRow.dataset.autoRole = rowData[targetNum].autoRole || ''; } else { targetRow.classList.remove('hpqf-auto-complete-row'); delete targetRow.dataset.autoRole; } const nameEl = comp.querySelector('.js-row'+targetNum+'-name'); const unitEl = comp.querySelector('.js-row'+targetNum+'-unit'); const ktEl = comp.querySelector('.js-row'+targetNum+'-kt'); const imgEl = comp.querySelector('.js-row'+targetNum+'-img'); if(nameEl) nameEl.textContent = cName; if(unitEl) unitEl.textContent = cUnit; if(ktEl){ hpqfRenderKt(targetNum, cKt || '', true); } if(imgEl){ if(cImg){ imgEl.src = cImg; imgEl.style.display = 'block'; // Nếu là ảnh base64 clipboard, lưu lại vào rowData if(/^data:image\//i.test(cImg)){ rowData[targetNum].customImage = cImg; } } else { imgEl.src = ''; imgEl.style.display = 'none'; } } // Sàn gỗ tự nhiên: tách quy cách khỏi tên hiển thị trong bảng if(item.natural) hpqfApplyName(targetNum, cName, true); }); addNewRow(); calc(); hpqfUpdateDepositRows(); hpqfUpdatePaymentMethod(); alert('✅ Đã mở báo giá thành công!'); }; reader.onerror = function(){ alert('Đọc file thất bại.'); }; reader.readAsText(file); } // ===== Gắn sự kiện cho 2 nút ===== const btnSaveJSON = comp.querySelector('.hpqf-save-json'); const btnLoadJSON = comp.querySelector('.hpqf-load-json'); const fileInput = comp.querySelector('.hpqf-file-input'); if(btnSaveJSON) btnSaveJSON.addEventListener('click', hpqfSaveJSON); if(btnLoadJSON && fileInput){ btnLoadJSON.addEventListener('click', () => fileInput.click()); fileInput.addEventListener('change', function(e){ const f = e.target.files[0]; hpqfLoadJSON(f); e.target.value = ''; }); } if(btnExportPNG) btnExportPNG.addEventListener('click', hpqfExportPNG); if(btnExportPDF) btnExportPDF.addEventListener('click', hpqfPrintPDF); hpqfBindModalEvents(); [inpCustomerName,inpCustomerPhone,inpCustomerAddr,inpCustomerTax,inpGuiChanhXe,inpProject, inpArea,inpWastage,inpLenQty,inpNepQty,inpVanQty,inpDiscountPct,inpDiscountRows] .filter(Boolean) .forEach(el=>{ el.addEventListener('input', calc); el.addEventListener('change', calc); }); if(inpExtraNote){ inpExtraNote.addEventListener('input', hpqfUpdateExtraNote); } // ===== Apply doc type (bao gồm PHIẾU XUẤT KHO) ===== function hpqfApplyDocType(type){ const paper = comp.querySelector('.hpqf-paper'); const titleEl = comp.querySelector('.hpqf-title'); const isPXK = (type === 'PHIẾU XUẤT KHO'); const isBBG = (type === 'BẢNG BÁO GIÁ'); if(titleEl) titleEl.textContent = type; if(paper) paper.classList.toggle('hpqf-pxk-mode', isPXK); hpqfToggleDiscountMode(); const noteHeader = comp.querySelector('.hpqf-table th.col-note'); if(noteHeader) noteHeader.innerHTML = isPXK ? 'ĐÓNG GÓI' : 'GHI CHÚ'; // SỐ LƯỢNG TẠM TÍNH chỉ dùng cho BẢNG BÁO GIÁ const qtyHeader = comp.querySelector('.hpqf-table th.col-qty'); if(qtyHeader) qtyHeader.innerHTML = isBBG ? 'SỐ LƯỢNG
TẠM TÍNH' : 'SỐ LƯỢNG'; const payTitle = comp.querySelector('.hpqf-payment-title'); const payList = comp.querySelector('.js-payment-list'); const amtText = comp.querySelector('.hpqf-amount-text'); const vatNote = comp.querySelector('.js-vat-note'); if(payTitle) payTitle.style.display = isPXK ? 'none' : ''; if(payList) payList.style.display = isPXK ? 'none' : ''; if(amtText) amtText.style.display = isPXK ? 'none' : ''; if(vatNote) vatNote.style.display = isPXK ? 'none' : ''; if(!isPXK) calc(); } // ===== Lắng nghe dropdown loại văn bản ===== if(selDocType){ selDocType.addEventListener('change', function(){ hpqfApplyDocType(this.value); }); } if(selPaymentType){ selPaymentType.addEventListener('change', function(){ calc(); hpqfUpdatePaymentMethod(); }); } // ===== Lắng nghe checkbox Chữ Ký ===== const chkStamp = comp.querySelector('.hpqf-stamp-check'); function hpqfToggleStamp(){ const stampImg = comp.querySelector('.hpqf-stamp-image'); if(!stampImg) return; stampImg.style.display = (chkStamp && chkStamp.checked) ? '' : 'none'; } if(chkStamp){ chkStamp.addEventListener('change', hpqfToggleStamp); hpqfToggleStamp(); } // ===== Lắng nghe checkbox Thi công hoàn thiện ===== if(chkComplete){ chkComplete.addEventListener('change', function(){ if(this.checked) hpqfApplyCompleteRows(); else hpqfRemoveCompleteRows(); }); } comp.addEventListener('input', function(){ setTimeout(function(){ hpqfUpdateDepositRows(); hpqfUpdatePaymentMethod(); }, 50); }); comp.addEventListener('change', function(){ setTimeout(function(){ hpqfUpdateDepositRows(); }, 50); }); hpqfBindEditableMeta(); hpqfBindVatRate(); hpqfBindVat10Note(); hpqfBindEditableRowNotes(); calc(); hpqfUpdatePaymentMethod(); }));