FIX: Multi-download Excel - thay thế qr-payment-v1038.js bằng v1039
#7
by bep40 - opened
- qr-payment-v1038.js +3 -422
qr-payment-v1038.js
CHANGED
|
@@ -1,422 +1,3 @@
|
|
| 1 |
-
/* V.AI STUDIO — QR Payment / Quote Data
|
| 2 |
-
*
|
| 3 |
-
*
|
| 4 |
-
* - exportDeliveryExcel now accepts order/opt and uses correct data
|
| 5 |
-
* - exportDeliveryPDF now accepts order/opt and uses correct data
|
| 6 |
-
* - Prevents multiple rapid clicks by disabling button during export
|
| 7 |
-
*/
|
| 8 |
-
(function(){
|
| 9 |
-
'use strict';
|
| 10 |
-
var BANK_ID='vib',BANK_ACCOUNT='918258385',BANK_NAME='TRAN QUOC VUONG',BANK_NAME_VN='Trần Quốc Vương';
|
| 11 |
-
function stripDiacritics(s){return s.normalize('NFD').replace(/[\u0300-\u036f]/g,'').replace(/[Đđ]/g,'D');}
|
| 12 |
-
function generateOrderCode(name){var now=new Date(),dd=String(now.getDate()).padStart(2,'0'),mm=String(now.getMonth()+1).padStart(2,'0'),yy=String(now.getFullYear()).slice(-2),ini='';if(name&&name.trim()){name.trim().split(/\s+/).forEach(function(w){if(w){var ch=stripDiacritics(w.charAt(0)).toUpperCase();if(/[A-Z]/.test(ch))ini+=ch;}});}return 'VAS'+(ini||'X')+dd+mm+yy;}
|
| 13 |
-
function getCustomerName(){var sels=['#quoteName','#quoteCustomerName','#checkoutName','.quote-field input:first-of-type'];for(var i=0;i<sels.length;i++){var el=document.querySelector(sels[i]);if(el&&el.value&&el.value.trim().length>1)return el.value.trim();}return '';}
|
| 14 |
-
function getEffectiveOrderCode(){var n=getCustomerName();if(n)return generateOrderCode(n);var h=window.location.hash;if(h&&h.length>1){var c=h.substring(1);if(/^VAS[A-Z0-9]{3,}$/.test(c))return c;}return generateOrderCode('');}
|
| 15 |
-
function getQRUrl(a,c){return 'https://img.vietqr.io/image/'+BANK_ID+'-'+BANK_ACCOUNT+'-compact2.png?amount='+(Math.round(a)||0)+'&addInfo='+encodeURIComponent(c||'VAISTUDIO')+'&accountName='+encodeURIComponent(BANK_NAME);}
|
| 16 |
-
function fmt(n){if(!n||isNaN(n))return '0đ';return Number(n).toLocaleString('vi-VN')+'đ';}
|
| 17 |
-
function vaiIsDimensionKey(k,v){
|
| 18 |
-
var txt=stripDiacritics(String(k||'')+' '+String(v||'')).toLowerCase();
|
| 19 |
-
return /kich thuoc|dimension|size|rong|ngang|dai|sau|cao|height|width|depth|cut.?out|cat da|lo da|lap noi|lap am|am ban|lot long|phu bi|khoang tu|mat canh|quy cach|r\s*[x=]|w\s*[x=]|d\s*[x=]|h\s*[x=]/.test(txt);
|
| 20 |
-
}
|
| 21 |
-
function vaiDimensionSummary(specs,limit){
|
| 22 |
-
limit=limit||900;var parts=[],seen={};
|
| 23 |
-
function add(k,v){if(!k||v==null||v==='')return;var t=String(k)+': '+String(v);var key=compactKey(t);if(seen[key])return;seen[key]=1;parts.push(t);}
|
| 24 |
-
if(specs&&typeof specs==='object'){
|
| 25 |
-
var entries=Object.entries(specs);entries.filter(function(e){return vaiIsDimensionKey(e[0],e[1]);}).forEach(function(e){add(e[0],e[1]);});
|
| 26 |
-
entries.filter(function(e){return !vaiIsDimensionKey(e[0],e[1]);}).slice(0,8).forEach(function(e){add(e[0],e[1]);});
|
| 27 |
-
}else if(specs){String(specs).split(/[;\n]+/).filter(Boolean).sort(function(a,b){return (vaiIsDimensionKey(b,'')?1:0)-(vaiIsDimensionKey(a,'')?1:0);}).forEach(function(x){var key=compactKey(x);if(!seen[key]){seen[key]=1;parts.push(x.trim());}});}
|
| 28 |
-
return parts.join('; ').slice(0,limit);
|
| 29 |
-
}
|
| 30 |
-
function vaiProductInfoForQuote(product){
|
| 31 |
-
if(!product)return '';
|
| 32 |
-
return vaiDimensionSummary(product.specs||{},900)||String(product.summary||product.desc||'').slice(0,900);
|
| 33 |
-
}
|
| 34 |
-
function compactKey(s){return stripDiacritics(String(s||'')).toLowerCase().replace(/[^a-z0-9]/g,'');}
|
| 35 |
-
function itemKeys(it){var arr=[];['model','sku','code','ma','name'].forEach(function(k){if(it&&it[k])arr.push(compactKey(it[k]));});if(it&&it.name){String(it.name).split('|').forEach(function(x){arr.push(compactKey(x));});}return arr.filter(function(x){return x&&x.length>=3;});}
|
| 36 |
-
function matchItemDiscount(it,itemDiscounts){
|
| 37 |
-
itemDiscounts=itemDiscounts||{};var keys=itemKeys(it);
|
| 38 |
-
for(var i=0;i<keys.length;i++){var k=keys[i];if(itemDiscounts[k])return itemDiscounts[k];}
|
| 39 |
-
for(var code in itemDiscounts){for(var j=0;j<keys.length;j++){var kk=keys[j];if(code.length>=3&&kk.length>=3&&(kk.indexOf(code)!==-1||code.indexOf(kk)!==-1))return itemDiscounts[code];}}
|
| 40 |
-
return 0;
|
| 41 |
-
}
|
| 42 |
-
function parseItemDiscountLine(line,map){
|
| 43 |
-
var lo=stripDiacritics(String(line||'')).toLowerCase();
|
| 44 |
-
var re1=/\b([a-z]{1,8}[a-z0-9._\-\/]{1,30}\d[a-z0-9._\-\/]*)\b\s*(?:[:=\-]|\s+)?\s*(?:ck|chiet\s*khau|giam|discount)\s*([\d.,]+)\s*%?/gi;
|
| 45 |
-
var re2=/(?:ck|chiet\s*khau|giam|discount)\s*\b([a-z]{1,8}[a-z0-9._\-\/]{1,30}\d[a-z0-9._\-\/]*)\b\s*([\d.,]+)\s*%?/gi;
|
| 46 |
-
var m;
|
| 47 |
-
while((m=re1.exec(lo))!==null){var v=parseFloat(m[2].replace(/\./g,'').replace(',','.'));if(v>0&&v<=100)map[compactKey(m[1])]=v;}
|
| 48 |
-
while((m=re2.exec(lo))!==null){var v2=parseFloat(m[2].replace(/\./g,'').replace(',','.'));if(v2>0&&v<=100)map[compactKey(m[1])]=v2;}
|
| 49 |
-
}
|
| 50 |
-
function applyPromptDiscounts(qd,parsed){
|
| 51 |
-
if(!qd||!qd.items)return qd;var productTotal=0;var itemDiscounts=(parsed&&parsed.itemDiscounts)||{};var globalPct=Number((parsed&&parsed.discountPercent)||0);
|
| 52 |
-
qd.items.forEach(function(it){var base=Number(it.price||0),qty=Number(it.qty||1);var pct=matchItemDiscount(it,itemDiscounts);if(pct>0){it.discPrice=Math.round(base*(1-pct/100));it.discountPercent=pct;}else if(globalPct>0&&globalPct<=100){it.discPrice=Math.round(base*(1-globalPct/100));it.discountPercent=globalPct;}else if(!it.discPrice){it.discPrice=base;}it.total=Number(it.discPrice||base)*qty;productTotal+=Number(it.total||0);});
|
| 53 |
-
qd.grandTotal=productTotal;return qd;
|
| 54 |
-
}
|
| 55 |
-
function parsePrompt(text){
|
| 56 |
-
var fees=[],notes=[],discount=null,deposit=0,discountPercent=0,itemDiscounts={};
|
| 57 |
-
if(!text)return{fees:fees,notes:notes,discount:discount,deposit:deposit,discountPercent:discountPercent,itemDiscounts:itemDiscounts};
|
| 58 |
-
text.split(/[,;\n]+/).forEach(function(line){
|
| 59 |
-
line=line.trim();if(!line)return;
|
| 60 |
-
parseItemDiscountLine(line,itemDiscounts);
|
| 61 |
-
if(Object.keys(itemDiscounts).length&&line.match(/\b[A-Za-z]{1,8}[A-Za-z0-9._\-\/]{1,30}\d[A-Za-z0-9._\-\/]*\b/i)&&line.match(/\b(ck|chiết khấu|chiet khau|giảm|giam|discount)\b/i))return;
|
| 62 |
-
if(line.match(/^(ck|chiết khấu|chiet khau|giảm|giam|discount)/i)){
|
| 63 |
-
discount=line;
|
| 64 |
-
var ckm=line.match(/([\d.,]+)\s*(%)?/);
|
| 65 |
-
if(ckm){var v=parseFloat(ckm[1].replace(/\./g,'').replace(',','.'));if(v>0&&v<=100)discountPercent=v;}
|
| 66 |
-
return;
|
| 67 |
-
}
|
| 68 |
-
if(line.match(/cọc|coc|deposit/i)){
|
| 69 |
-
var dm=line.match(/([\d.,]+)\s*(k|K|nghìn|nghin|triệu|tr|đ|d|vnd)?/);
|
| 70 |
-
if(dm){var da=parseFloat(dm[1].replace(/\./g,'').replace(',','.'));var du=(dm[2]||'').toLowerCase();if(du==='k'||du==='nghìn'||du==='nghin')da*=1000;if(du==='triệu'||du==='tr')da*=1000000;deposit=da;}
|
| 71 |
-
return;
|
| 72 |
-
}
|
| 73 |
-
var m=line.match(/([\d.,]+)\s*(k|K|nghìn|nghin|triệu|tr|đ|d|vnd)?/);
|
| 74 |
-
if(m){var amt=parseFloat(m[1].replace(/\./g,'').replace(',','.'));var u=(m[2]||'').toLowerCase();if(u==='k'||u==='nghìn'||u==='nghin')amt*=1000;if(u==='triệu'||u==='tr')amt*=1000000;if(amt<=0)return;var lb=line.replace(m[0],'').trim();if(lb.match(/giao|ship|vận chuyển|delivery/i))lb='Phí giao hàng';else if(lb.match(/lắp|lap|install/i))lb='Phí lắp đặt';else if(lb.match(/bốc|boc|xếp|xep|vác/i))lb='Phí bốc xếp';else if(!lb||lb.length<2)lb='Phụ phí';fees.push({label:lb,amount:amt});}
|
| 75 |
-
else{notes.push(line);}
|
| 76 |
-
});
|
| 77 |
-
return{fees:fees,notes:notes,discount:discount,deposit:deposit,discountPercent:discountPercent,itemDiscounts:itemDiscounts};
|
| 78 |
-
}
|
| 79 |
-
var _lastPromptText='';
|
| 80 |
-
function getPromptText(){
|
| 81 |
-
var direct=document.getElementById('qcAiPrompt');
|
| 82 |
-
if(direct){var dv=(direct.value||'').trim();if(dv&&dv.toUpperCase().replace(/[\s.]/g,'')!=='VAISTUDIO'){_lastPromptText=dv;return dv;}}
|
| 83 |
-
var inputs=document.querySelectorAll('input,textarea');
|
| 84 |
-
for(var j=0;j<inputs.length;j++){var ph=(inputs[j].placeholder||'').toLowerCase();if(ph.includes('yêu cầu')||ph.includes('chiết khấu')||ph.includes('yeu cau')||ph.includes('chiet khau')||ph.includes('ck')||ph.includes('giao hàng')){var val=(inputs[j].value||'').trim();if(!val||val.toUpperCase().replace(/[\s.]/g,'')==='VAISTUDIO')continue;_lastPromptText=val;return val;}}
|
| 85 |
-
return _lastPromptText;
|
| 86 |
-
}
|
| 87 |
-
function getData(){
|
| 88 |
-
var qd=window._origGetQuoteData?window._origGetQuoteData():getQuoteData();
|
| 89 |
-
var parsed=parsePrompt(getPromptText());
|
| 90 |
-
qd=applyPromptDiscounts(qd,parsed);
|
| 91 |
-
if(qd&&qd.items){qd.items.forEach(function(it){if(!it.specs||String(it.specs).length<40){var idx=(it.idx!=null?it.idx:(it.productIdx!=null?it.productIdx:null));var p=(idx!=null&&window.D)?window.D[idx]:null;if(!p&&window.D){var ck=compactKey(it.model||it.sku||it.ma||it.name||'');p=(window.D||[]).find(function(x){return compactKey(x.model||x.sku||x.name||'').indexOf(ck)>=0||ck.indexOf(compactKey(x.model||x.sku||''))>=0;});}it.specs=vaiProductInfoForQuote(p)||it.specs||'';}});}
|
| 92 |
-
var surcharge=0;parsed.fees.forEach(function(f){surcharge+=f.amount;});
|
| 93 |
-
var grandTotal=(qd.grandTotal||0)+surcharge;
|
| 94 |
-
var remaining=grandTotal-parsed.deposit;
|
| 95 |
-
return{qd:qd,fees:parsed.fees,notes:parsed.notes,discount:parsed.discount,discountPercent:parsed.discountPercent,itemDiscounts:parsed.itemDiscounts||{},deposit:parsed.deposit,productTotal:qd.grandTotal||0,grandTotal:grandTotal,remaining:remaining>0?remaining:0};
|
| 96 |
-
}
|
| 97 |
-
function injectToModal(){
|
| 98 |
-
var modal=document.querySelector('.quote-overlay.open,.quote-modal.open,.quote-overlay[style*="block"],.quote-modal[style*="block"],[class*="quote"][class*="open"],[class*="quote"][style*="block"]');
|
| 99 |
-
if(!modal){var btns=document.querySelectorAll('button,a');for(var b=0;b<btns.length;b++){if((btns[b].textContent||'').match(/xuất|export|chia sẻ|share/i)){modal=btns[b].closest('[class*="overlay"],[class*="modal"],[class*="popup"]');if(modal)break;}}}
|
| 100 |
-
if(!modal)return;
|
| 101 |
-
var old=modal.querySelector('.vai-extra-section');if(old)old.remove();
|
| 102 |
-
var parsed=parsePrompt(getPromptText());
|
| 103 |
-
if(!parsed.fees.length&&!parsed.deposit)return;
|
| 104 |
-
var surcharge=0;parsed.fees.forEach(function(f){surcharge+=f.amount;});
|
| 105 |
-
var qd=window._origGetQuoteData?window._origGetQuoteData():(typeof getQuoteData==='function'?getQuoteData():{grandTotal:0});
|
| 106 |
-
var grandTotal=(qd.grandTotal||0)+surcharge;
|
| 107 |
-
var remaining=grandTotal-parsed.deposit;
|
| 108 |
-
var sec=document.createElement('div');sec.className='vai-extra-section';
|
| 109 |
-
sec.style.cssText='margin:10px 0;padding:0 16px;font-size:13px';
|
| 110 |
-
var html='';
|
| 111 |
-
if(parsed.fees.length){
|
| 112 |
-
html+='<div style="padding:8px 12px;background:#fffbeb;border-radius:6px;border:1px solid #fde68a;margin-bottom:8px"><div style="font-weight:700;color:#92400e;font-size:12px;margin-bottom:4px">PHỤ PHÍ</div>';
|
| 113 |
-
parsed.fees.forEach(function(f){html+='<div style="display:flex;justify-content:space-between;padding:2px 0"><span>'+f.label+'</span><span style="font-weight:700">'+fmt(f.amount)+'</span></div>';});
|
| 114 |
-
html+='</div>';
|
| 115 |
-
}
|
| 116 |
-
html+='<div style="padding:8px 12px;background:#003f62;border-radius:6px;display:flex;justify-content:space-between;align-items:center"><span style="color:#fff;font-weight:800">TỔNG CỘNG</span><span style="color:#f0b840;font-weight:900;font-size:16px">'+fmt(grandTotal)+'</span></div>';
|
| 117 |
-
if(parsed.deposit>0){
|
| 118 |
-
html+='<div style="margin-top:6px;padding:6px 12px;background:#f0fdf4;border-radius:6px;border:1px solid #86efac;font-size:12px"><div style="display:flex;justify-content:space-between"><span>Đã cọc</span><span style="font-weight:700;color:#166534">'+fmt(parsed.deposit)+'</span></div><div style="display:flex;justify-content:space-between;margin-top:3px"><span style="font-weight:800">Còn lại</span><span style="font-weight:900;color:#dc2626;font-size:14px">'+fmt(remaining>0?remaining:0)+'</span></div></div>';
|
| 119 |
-
}
|
| 120 |
-
sec.innerHTML=html;
|
| 121 |
-
var actions=modal.querySelector('.quote-actions,[class*="actions"],[class*="button"]');
|
| 122 |
-
if(actions&&actions.parentNode){actions.parentNode.insertBefore(sec,actions);}else{modal.appendChild(sec);}
|
| 123 |
-
}
|
| 124 |
-
|
| 125 |
-
// === HELPER: Convert order to VAIData format for GH export ===
|
| 126 |
-
function orderToVAIData(order){
|
| 127 |
-
return {
|
| 128 |
-
qd: {
|
| 129 |
-
customer: {
|
| 130 |
-
name: order.customer || '',
|
| 131 |
-
phone: order.phone || '',
|
| 132 |
-
email: order.email || '',
|
| 133 |
-
addr: order.addr || '',
|
| 134 |
-
date: order.date || ''
|
| 135 |
-
},
|
| 136 |
-
items: (order.items || []).map(function(it, i){
|
| 137 |
-
return {
|
| 138 |
-
stt: i + 1,
|
| 139 |
-
image: it.image || '',
|
| 140 |
-
name: it.name || '',
|
| 141 |
-
model: it.model || '',
|
| 142 |
-
specs: it.specs || it.info || '',
|
| 143 |
-
qty: it.qty || 1,
|
| 144 |
-
price: it.price || it.listPrice || it.discPrice || 0,
|
| 145 |
-
discPrice: it.discPrice || it.price || 0,
|
| 146 |
-
total: it.total || 0,
|
| 147 |
-
note: it.note || ''
|
| 148 |
-
};
|
| 149 |
-
}),
|
| 150 |
-
grandTotal: order.grandTotal || 0
|
| 151 |
-
},
|
| 152 |
-
fees: order.fees || [],
|
| 153 |
-
deposit: order.deposit || 0,
|
| 154 |
-
remaining: order.remaining || 0
|
| 155 |
-
};
|
| 156 |
-
}
|
| 157 |
-
|
| 158 |
-
// === CLICK PROTECTION HELPER ===
|
| 159 |
-
function setExportButtonState(btn, exporting){
|
| 160 |
-
if(!btn) return;
|
| 161 |
-
if(exporting){
|
| 162 |
-
btn.disabled = true;
|
| 163 |
-
btn.dataset.vaiExporting = '1';
|
| 164 |
-
var origText = btn.innerHTML;
|
| 165 |
-
btn.dataset.vaiOrigText = origText;
|
| 166 |
-
btn.innerHTML = '<span style="opacity:0.7">⏳</span>';
|
| 167 |
-
} else {
|
| 168 |
-
btn.disabled = false;
|
| 169 |
-
btn.dataset.vaiExporting = '0';
|
| 170 |
-
if(btn.dataset.vaiOrigText){
|
| 171 |
-
btn.innerHTML = btn.dataset.vaiOrigText;
|
| 172 |
-
}
|
| 173 |
-
}
|
| 174 |
-
}
|
| 175 |
-
|
| 176 |
-
var _obs=new MutationObserver(function(){setTimeout(injectToModal,300);});
|
| 177 |
-
_obs.observe(document.body,{attributes:true,childList:true,subtree:true});
|
| 178 |
-
setInterval(injectToModal,1500);
|
| 179 |
-
document.addEventListener('input',function(e){var ph=(e.target.placeholder||'').toLowerCase();var id=e.target.id||'';if(ph.includes('yêu cầu')||ph.includes('chiết khấu')||ph.includes('yeu cau')||ph.includes('chiet khau')||ph.includes('ck')||ph.includes('giao hàng')||id==='qcAiPrompt'){var val=(e.target.value||'').trim();if(val&&val.toUpperCase().replace(/[\s.]/g,'')!=='VAISTUDIO')_lastPromptText=val;setTimeout(injectToModal,200);}},true);
|
| 180 |
-
|
| 181 |
-
function toCanvas(html,w){
|
| 182 |
-
var div=document.createElement('div');
|
| 183 |
-
div.style.cssText='position:absolute;left:-10000px;top:0;width:'+(w||1000)+'px;background:#fff;padding:28px;font-family:Inter,Arial,DejaVu Sans,sans-serif;z-index:-1;box-sizing:border-box';
|
| 184 |
-
div.innerHTML=html;document.body.appendChild(div);
|
| 185 |
-
try{if(document.fonts&&document.fonts.ready)await document.fonts.ready;}catch(e){}
|
| 186 |
-
var imgs=Array.from(div.querySelectorAll('img'));
|
| 187 |
-
await Promise.all(imgs.map(function(img){return new Promise(function(res){if(img.complete)return res();img.onload=img.onerror=function(){res();};setTimeout(res,2500);});}));
|
| 188 |
-
await new Promise(function(r){setTimeout(r,500);});
|
| 189 |
-
var h=Math.max(div.scrollHeight,div.offsetHeight);
|
| 190 |
-
var cv=await html2canvas(div,{scale:2,useCORS:true,allowTaint:false,backgroundColor:'#fff',width:w||1000,height:h,windowWidth:w||1000,windowHeight:h,scrollX:0,scrollY:0});
|
| 191 |
-
div.remove();return cv;
|
| 192 |
-
}
|
| 193 |
-
|
| 194 |
-
function buildQuoteHTML(d,code,qrUrl){
|
| 195 |
-
var qd=d.qd;
|
| 196 |
-
var rows=qd.items.map(function(it){return '<tr style="border-bottom:1px solid #e2e8f0"><td style="padding:6px 4px;text-align:center;font-size:11px">'+(it.stt||'')+'</td><td style="padding:6px 4px"><img src="'+(it.image||'')+'" style="width:50px;height:50px;object-fit:contain;border-radius:4px" crossorigin="anonymous" onerror="this.style.display=\'none\'"></td><td style="padding:6px 4px;font-size:11px;font-weight:600">'+(it.name||'')+'</td><td style="padding:6px 4px;text-align:center;font-size:10px">'+(it.model||'')+'</td><td style="padding:6px 4px;font-size:9px;color:#64748b">'+(it.specs||'')+'</td><td style="padding:6px 4px;text-align:center">'+(it.qty||'')+'</td><td style="padding:6px 4px;text-align:right;font-size:11px">'+(it.price?fmt(it.price):'')+'</td><td style="padding:6px 4px;text-align:right;font-size:11px;'+(it.discPrice&&it.discPrice<it.price?'color:#dc3545;font-weight:700':'')+'">'+(it.discPrice?fmt(it.discPrice):'')+'</td><td style="padding:6px 4px;text-align:right;font-size:11px;font-weight:700">'+(it.total?fmt(it.total):'')+'</td><td style="padding:6px 4px;font-size:9px">'+(it.note||'')+'</td></tr>';}).join('');
|
| 197 |
-
var feeRows='';if(d.fees&&d.fees.length){d.fees.forEach(function(f){feeRows+='<tr style="background:#fffbeb"><td colspan="8" style="padding:5px 10px;font-size:11px;color:#92400e;border-bottom:1px solid #fde68a">⊕ '+f.label+'</td><td style="padding:5px 4px;text-align:right;font-size:11px;font-weight:700;color:#92400e;border-bottom:1px solid #fde68a">'+fmt(f.amount)+'</td><td style="border-bottom:1px solid #fde68a"></td></tr>';});}
|
| 198 |
-
var depositHtml='';if(d.deposit>0){depositHtml='<div style="margin-top:8px;padding:8px 14px;background:#f0fdf4;border-radius:6px;border:1px solid #86efac;font-size:12px"><div style="display:flex;justify-content:space-between"><span>Đã cọc</span><span style="font-weight:700;color:#166534">'+fmt(d.deposit)+'</span></div><div style="display:flex;justify-content:space-between;margin-top:3px"><span style="font-weight:800">Còn lại</span><span style="font-weight:900;color:#dc2626;font-size:14px">'+fmt(d.remaining)+'</span></div></div>';}
|
| 199 |
-
var notesHtml='';if(d.notes&&d.notes.length){notesHtml='<div style="margin-top:8px;padding:6px 12px;font-size:10px;color:#166534;background:#f0fdf4;border-radius:6px"><b>📝 Ghi chú:</b> '+d.notes.join('; ')+'</div>';}
|
| 200 |
-
var totalQty=(qd.items||[]).reduce(function(s,it){return s+Number(it.qty||1);},0);
|
| 201 |
-
return '<div style="display:flex;align-items:center;gap:10px;margin-bottom:4px"><img src="https://huggingface.co/spaces/bep40/V.AISTUDIO/resolve/main/logo/logo_200.png" style="width:40px;height:40px;object-fit:contain" crossorigin="anonymous"><div style="font-size:9px;color:#64748b;font-style:italic">❝ Niềm tin khách hàng là tài sản của chúng tôi ❞</div></div><div style="text-align:center;margin-bottom:12px"><div style="font-size:20px;font-weight:900;color:#db9815">BẢNG BÁO GIÁ</div></div><div style="display:flex;justify-content:space-between;margin-bottom:12px;font-size:11px"><div><b>Khách hàng:</b> '+(qd.customer.name||'')+'<br><b>SĐT:</b> '+(qd.customer.phone||'')+'<br><b>Email:</b> '+(qd.customer.email||'')+'<br><b>Địa chỉ:</b> '+(qd.customer.addr||'')+'</div><div style="text-align:right"><b>Mã đơn:</b> '+code+'<br><b>Ngày:</b> '+(qd.customer.date||'')+'</div></div><table style="width:100%;border-collapse:collapse"><thead><tr style="background:#003f62;color:#fff"><th style="padding:7px 3px;font-size:9px">STT</th><th style="padding:7px 3px;font-size:9px">Hình</th><th style="padding:7px 3px;font-size:9px;text-align:left">Tên SP</th><th style="padding:7px 3px;font-size:9px">Mã</th><th style="padding:7px 3px;font-size:9px">Thông tin</th><th style="padding:7px 3px;font-size:9px">SL</th><th style="padding:7px 3px;font-size:9px">Đơn giá</th><th style="padding:7px 3px;font-size:9px">Giá CK</th><th style="padding:7px 3px;font-size:9px">Thành tiền</th><th style="padding:7px 3px;font-size:9px">Ghi chú</th></tr></thead><tbody>'+rows+feeRows+'</tbody></table><div style="margin-top:0;padding:10px 14px;background:#003f62;display:grid;grid-template-columns:1fr 90px 180px;gap:10px;align-items:center"><span style="color:#fff;font-size:13px;font-weight:800">TỔNG CỘNG</span><span style="color:#fff;font-size:13px;font-weight:900;text-align:center">SL: '+totalQty+'</span><span style="color:#f0b840;font-size:17px;font-weight:900;text-align:right">'+fmt(d.grandTotal)+'</span></div>'+depositHtml+notesHtml+'<div style="display:flex;align-items:flex-start;gap:14px;margin-top:14px;padding:12px;background:#f8fafc;border-radius:8px"><img src="'+qrUrl+'" style="width:115px;height:115px;border-radius:6px;border:2px solid #e2e8f0" crossorigin="anonymous"><div style="font-size:10px;line-height:1.7"><div style="font-weight:700;color:#003f62;margin-bottom:3px">💳 CHUYỂN KHOẢN</div>🏦 VIB | 👤 '+BANK_NAME_VN+'<br>🔢 STK: <b>'+BANK_ACCOUNT+'</b><br>💰 <b>'+fmt(d.deposit>0?d.remaining:d.grandTotal)+'</b> | 📝 <b>'+code+'</b></div></div>';
|
| 202 |
-
}
|
| 203 |
-
|
| 204 |
-
function buildDeliveryHTML(qd,code){
|
| 205 |
-
var rows=(qd.items||[]).map(function(it,i){return '<tr style="border-bottom:1px solid #e2e8f0"><td style="padding:8px 4px;text-align:center;font-size:12px">'+(it.stt||(i+1))+'</td><td style="padding:8px 4px;font-weight:600;font-size:12px">'+(it.name||'')+'</td><td style="padding:8px 4px;text-align:center;font-size:11px">'+(it.model||'')+'</td><td style="padding:8px 4px;text-align:center;font-weight:700;font-size:13px">'+(it.qty||1)+'</td><td style="padding:8px 4px;font-size:11px">'+(it.note||'')+'</td></tr>';}).join('');
|
| 206 |
-
return '<div style="text-align:center;margin-bottom:14px"><div style="font-size:20px;font-weight:900;color:#003f62">PHIẾU GIAO HÀNG</div></div><div style="margin-bottom:12px;font-size:11px;line-height:1.6"><b>Khách hàng:</b> '+(qd.customer?qd.customer.name:'')+' | <b>SĐT:</b> '+(qd.customer?qd.customer.phone:'')+'<br><b>Địa chỉ:</b> '+(qd.customer?qd.customer.addr||'':'')+'<br><b>Mã đơn:</b> '+code+' | <b>Ngày:</b> '+(qd.customer?qd.customer.date||'':'')+'</div><table style="width:100%;border-collapse:collapse;font-size:12px"><thead><tr style="background:#003f62;color:#fff"><th style="padding:8px 4px;width:35px">STT</th><th style="padding:8px 4px;text-align:left">Tên sản phẩm</th><th style="padding:8px 4px;width:90px">Mã SP</th><th style="padding:8px 4px;width:40px">SL</th><th style="padding:8px 4px;text-align:left;width:120px">Ghi chú</th></tr></thead><tbody>'+rows+'</tbody></table><div style="margin-top:60px;display:flex;justify-content:space-around;font-size:12px"><div style="text-align:center"><b>Bên giao</b><br><span style="font-size:9px;color:#64748b">(Ký, họ tên)</span><div style="margin-top:45px">_______________</div></div><div style="text-align:center"><b>Bên nhận</b><br><span style="font-size:9px;color:#64748b">(Ký, họ tên)</span><div style="margin-top:45px">_______________</div></div></div>';
|
| 207 |
-
}
|
| 208 |
-
|
| 209 |
-
function doOverride(){
|
| 210 |
-
if(typeof getQuoteData!=='function'||typeof html2canvas!=='function')return false;
|
| 211 |
-
window._origGetQuoteData=getQuoteData;
|
| 212 |
-
window.shareQuoteImage=async function(){var d=getData(),code=getEffectiveOrderCode(),qr=getQRUrl(d.deposit>0?d.remaining:d.grandTotal,code);try{var cv=await toCanvas(buildQuoteHTML(d,code,qr),1000);var blob=await new Promise(function(r){cv.toBlob(r,'image/png');});var f=new File([blob],code+'.png',{type:'image/png'});if(navigator.share&&navigator.canShare&&navigator.canShare({files:[f]})){await navigator.share({title:code,files:[f]});}else{var url=URL.createObjectURL(blob);var p=document.createElement('div');p.style.cssText='position:fixed;inset:0;background:rgba(0,0,0,.7);z-index:999;display:flex;align-items:center;justify-content:center;padding:16px;backdrop-filter:blur(4px)';p.innerHTML='<div style="background:#fff;border-radius:16px;max-width:90vw;max-height:85vh;overflow:auto;padding:16px"><img src="'+url+'" style="max-width:100%;border-radius:8px"><div style="display:flex;gap:8px;margin-top:12px;justify-content:center"><a href="'+url+'" download="'+code+'.png" style="padding:10px 20px;background:#003f62;color:#fff;border-radius:8px;font-weight:700;text-decoration:none">⬇ Tải ảnh</a><button onclick="this.closest(\'div[style*=fixed]\').remove()" style="padding:10px 20px;background:#e2e8f0;border:none;border-radius:8px;font-weight:700;cursor:pointer">Đóng</button></div></div>';document.body.appendChild(p);}}catch(e){console.error(e);}};
|
| 213 |
-
window.exportPDF=async function(){var d=getData(),code=getEffectiveOrderCode(),qr=getQRUrl(d.deposit>0?d.remaining:d.grandTotal,code);try{await _doExportPDF(d,code);}catch(e){console.error(e);alert('Không xuất được PDF: '+(e&&e.message?e.message:e));}};
|
| 214 |
-
// FIXED: exportDeliveryExcel now accepts order/opt and uses correct data
|
| 215 |
-
window.exportDeliveryExcel=async function(order, opt){
|
| 216 |
-
if(typeof ExcelJS==='undefined')return;
|
| 217 |
-
var qd = order && order.items ? orderToVAIData(order).qd : window._origGetQuoteData();
|
| 218 |
-
var code = order && order.code ? order.code : getEffectiveOrderCode();
|
| 219 |
-
// Button protection
|
| 220 |
-
var activeBtn = document.activeElement;
|
| 221 |
-
if(activeBtn && activeBtn.dataset.vaiExporting === '1') return;
|
| 222 |
-
if(activeBtn) {
|
| 223 |
-
activeBtn.dataset.vaiExporting = '1';
|
| 224 |
-
activeBtn.origHtml = activeBtn.innerHTML;
|
| 225 |
-
activeBtn.innerHTML = '<span style="opacity:0.7">⏳</span>';
|
| 226 |
-
}
|
| 227 |
-
try {
|
| 228 |
-
await _doExportDeliveryExcel(qd, code);
|
| 229 |
-
} finally {
|
| 230 |
-
if(activeBtn) {
|
| 231 |
-
activeBtn.dataset.vaiExporting = '0';
|
| 232 |
-
if(activeBtn.origHtml) activeBtn.innerHTML = activeBtn.origHtml;
|
| 233 |
-
}
|
| 234 |
-
}
|
| 235 |
-
};
|
| 236 |
-
// FIXED: exportDeliveryPDF now accepts order/opt and uses correct data
|
| 237 |
-
window.exportDeliveryPDF=async function(order, opt){
|
| 238 |
-
var qd = order && order.items ? orderToVAIData(order).qd : window._origGetQuoteData();
|
| 239 |
-
var code = order && order.code ? order.code : getEffectiveOrderCode();
|
| 240 |
-
var activeBtn = document.activeElement;
|
| 241 |
-
if(activeBtn && activeBtn.dataset.vaiExporting === '1') return;
|
| 242 |
-
if(activeBtn) {
|
| 243 |
-
activeBtn.dataset.vaiExporting = '1';
|
| 244 |
-
activeBtn.origHtml = activeBtn.innerHTML;
|
| 245 |
-
activeBtn.innerHTML = '<span style="opacity:0.7">⏳</span>';
|
| 246 |
-
}
|
| 247 |
-
try {
|
| 248 |
-
await _doExportDeliveryPDF(qd, code);
|
| 249 |
-
} finally {
|
| 250 |
-
if(activeBtn) {
|
| 251 |
-
activeBtn.dataset.vaiExporting = '0';
|
| 252 |
-
if(activeBtn.origHtml) activeBtn.innerHTML = activeBtn.origHtml;
|
| 253 |
-
}
|
| 254 |
-
}
|
| 255 |
-
};
|
| 256 |
-
window.exportExcel=async function(){if(typeof ExcelJS==='undefined')return;var d=getData(),qd=d.qd,code=getEffectiveOrderCode(),qr=getQRUrl(d.deposit>0?d.remaining:d.grandTotal,code);await _doExportExcel(d,qd,code,qr);};
|
| 257 |
-
window.getQuoteData=function(){var qd=window._origGetQuoteData.apply(this,arguments);if(qd.customer)qd.customer.orderCode=getEffectiveOrderCode();return qd;};
|
| 258 |
-
console.log('✅ QR Payment v1038 — GH Excel/PDF fixed');
|
| 259 |
-
return true;
|
| 260 |
-
}
|
| 261 |
-
|
| 262 |
-
async function _doExportPDF(d,code){
|
| 263 |
-
var qr=getQRUrl(d.deposit>0?d.remaining:d.grandTotal,code);
|
| 264 |
-
var cv=await toCanvas(buildQuoteHTML(d,code,qr),1000);
|
| 265 |
-
var img= cv.toDataURL('image/jpeg',0.92);
|
| 266 |
-
var pageW=595,pageH=842;
|
| 267 |
-
var imgW=pageW;var imgH=cv.height*imgW/cv.width;
|
| 268 |
-
var pdf=new jspdf.jsPDF({orientation:'p',unit:'pt',format:'a4'});
|
| 269 |
-
if(imgH<=pageH){pdf.addImage(img,'JPEG',0,0,imgW,imgH);}else{
|
| 270 |
-
var y=0;var remaining=imgH;var page=0;
|
| 271 |
-
while(remaining>0){if(page>0)pdf.addPage();pdf.addImage(img,'JPEG',0,-y,imgW,imgH);y+=pageH;remaining-=pageH;page++;}
|
| 272 |
-
}
|
| 273 |
-
pdf.save(code+'.pdf');
|
| 274 |
-
}
|
| 275 |
-
async function _doExportDeliveryPDF(qd,code){
|
| 276 |
-
var cv=await toCanvas(buildDeliveryHTML({qd:qd},code),700);var img=cv.toDataURL('image/png');var pdf=new jspdf.jsPDF({orientation:'p',unit:'pt',format:'a4'});var margin=25,usableW=595-margin*2;var ratio=cv.height/cv.width;var imgH=usableW*ratio;if(imgH>842-margin*2){imgH=842-margin*2;usableW=imgH/ratio;}pdf.addImage(img,'PNG',margin,margin,usableW,imgH);pdf.save('GH-'+code+'.pdf');
|
| 277 |
-
}
|
| 278 |
-
|
| 279 |
-
async function _doExportExcel(d,qd,code,qr){
|
| 280 |
-
var MONEY_FMT='#,##0"đ"';
|
| 281 |
-
var NUM_FMT='#,##0';
|
| 282 |
-
var WHITE={argb:'FFFFFFFF'};var WB={top:{style:'thin',color:WHITE},bottom:{style:'thin',color:WHITE},left:{style:'thin',color:WHITE},right:{style:'thin',color:WHITE}};
|
| 283 |
-
var wb=new ExcelJS.Workbook(),ws=wb.addWorksheet('Báo giá');
|
| 284 |
-
ws.views=[{showGridLines:false}];ws.columns=[{width:5},{width:11},{width:28},{width:13},{width:20},{width:6},{width:13},{width:13},{width:15},{width:14}];
|
| 285 |
-
try{var lr=await fetch('https://huggingface.co/spaces/bep40/V.AISTUDIO/resolve/main/logo/logo_200.png',{mode:'cors'});if(lr.ok){var lb=await lr.arrayBuffer();ws.addImage(wb.addImage({buffer:lb,extension:'png'}),{tl:{col:0,row:0},ext:{width:40,height:40}});}}catch(e){}
|
| 286 |
-
ws.mergeCells('B1:J1');ws.getCell('B1').value='❝ Niềm tin khách hàng là tài sản của chúng tôi ❞';ws.getCell('B1').font={italic:true,size:9,color:{argb:'FF64748B'}};ws.getCell('B1').alignment={vertical:'middle'};ws.getCell('B1').border=WB;
|
| 287 |
-
ws.getRow(1).height=28;ws.getRow(2).height=5;
|
| 288 |
-
ws.mergeCells('A3:J3');ws.getCell('A3').value='BẢNG BÁO GIÁ';ws.getCell('A3').font={bold:true,size:18,color:{argb:'FFDB9815'}};ws.getCell('A3').alignment={horizontal:'center',vertical:'middle'};ws.getCell('A3').border=WB;ws.getRow(3).height=30;ws.getRow(4).height=5;
|
| 289 |
-
ws.getCell('A5').value='Khách hàng:';ws.getCell('A5').font={bold:true,size:9};ws.getCell('A5').border=WB;
|
| 290 |
-
ws.mergeCells('B5:E5');ws.getCell('B5').value=qd.customer.name||'';ws.getCell('B5').font={bold:true,size:10};ws.getCell('B5').border=WB;
|
| 291 |
-
ws.getCell('H5').value='Mã đơn:';ws.getCell('H5').font={size:9};ws.getCell('H5').border=WB;
|
| 292 |
-
ws.mergeCells('I5:J5');ws.getCell('I5').value=code;ws.getCell('I5').font={bold:true,size:10,color:{argb:'FF003F62'}};ws.getCell('I5').border=WB;
|
| 293 |
-
ws.getCell('A6').value='SĐT:';ws.getCell('A6').font={size:9};ws.getCell('A6').border=WB;
|
| 294 |
-
ws.getCell('B6').value=qd.customer.phone||'';ws.getCell('B6').border=WB;
|
| 295 |
-
ws.getCell('H6').value='Ngày:';ws.getCell('H6').font={size:9};ws.getCell('H6').border=WB;
|
| 296 |
-
ws.getCell('I6').value=qd.customer.date||'';ws.getCell('I6').border=WB;
|
| 297 |
-
ws.getCell('A7').value='Email:';ws.getCell('A7').font={size:9};ws.getCell('A7').border=WB;
|
| 298 |
-
ws.getCell('B7').value=qd.customer.email||'';ws.getCell('B7').border=WB;
|
| 299 |
-
ws.getCell('A8').value='Địa chỉ:';ws.getCell('A8').font={size:9};ws.getCell('A8').border=WB;
|
| 300 |
-
ws.mergeCells('B8:J8');ws.getCell('B8').value=qd.customer.addr||'';ws.getCell('B8').border=WB;
|
| 301 |
-
ws.getRow(9).height=5;
|
| 302 |
-
var HB={top:{style:'thin',color:{argb:'FF003F62'}},bottom:{style:'thin',color:{argb:'FF003F62'}},left:{style:'thin',color:{argb:'FF003F62'}},right:{style:'thin',color:{argb:'FF003F62'}};
|
| 303 |
-
var headerRow=ws.getRow(10);
|
| 304 |
-
['STT','Hình','Tên sản phẩm','Mã SP','Thông tin','SL','Đơn giá','Giá CK','Thành tiền','Ghi chú'].forEach(function(h,i){var c=headerRow.getCell(i+1);c.value=h;c.font={bold:true,color:{argb:'FFFFFFFF'},size:9};c.fill={type:'pattern',pattern:'solid',fgColor:{argb:'FF003F62'}};c.alignment={horizontal:'center',vertical:'middle',wrapText:true};c.border=HB;});headerRow.height=20;
|
| 305 |
-
var cr=11;
|
| 306 |
-
var firstItemRow=cr;
|
| 307 |
-
var ckPct=Number(d.discountPercent||0);
|
| 308 |
-
for(var i=0;i<qd.items.length;i++){
|
| 309 |
-
var it=qd.items[i],row=ws.getRow(cr);row.height=50;
|
| 310 |
-
var bgColor=i%2===0?'FFF8FAFC':'FFFFFFFF';
|
| 311 |
-
var RB={top:{style:'thin',color:{argb:bgColor}},bottom:{style:'thin',color:{argb:bgColor}},left:{style:'thin',color:{argb:bgColor}},right:{style:'thin',color:{argb:bgColor}}};
|
| 312 |
-
row.getCell(1).value=it.stt||i+1;row.getCell(1).alignment={horizontal:'center',vertical:'middle'};
|
| 313 |
-
if(it.image&&it.image.startsWith('http')){try{var ir=await fetch(it.image,{mode:'cors'});if(ir.ok){var ib=await ir.arrayBuffer();ws.addImage(wb.addImage({buffer:ib,extension:it.image.includes('.png')?'png':'jpeg'}),{tl:{col:1,row:cr-1},ext:{width:46,height:46}});}}catch(e){}}
|
| 314 |
-
row.getCell(3).value=it.name||'';row.getCell(3).font={bold:true,size:9};row.getCell(3).alignment={wrapText:true,vertical:'middle'};
|
| 315 |
-
row.getCell(4).value=it.model||'';row.getCell(4).alignment={horizontal:'center',vertical:'middle'};
|
| 316 |
-
row.getCell(5).value=it.specs||'';row.getCell(5).font={size:8,color:{argb:'FF64748B'}};row.getCell(5).alignment={wrapText:true,vertical:'middle'};
|
| 317 |
-
row.getCell(6).value=Number(it.qty||1);row.getCell(6).numFmt=NUM_FMT;row.getCell(6).alignment={horizontal:'center',vertical:'middle'};
|
| 318 |
-
var itemPct=matchItemDiscount(it,d.itemDiscounts||{});
|
| 319 |
-
if(itemPct>0&&itemPct<=100){row.getCell(8).value={formula:'ROUND(G'+cr+'*'+Math.round((1-itemPct/100)*10000)/10000+',0)',result:Number(it.discPrice||0)};}
|
| 320 |
-
else if(ckPct>0&&ckPct<=100){row.getCell(8).value={formula:'ROUND(G'+cr+'*$K$1,0)',result:Number(it.discPrice||0)};}
|
| 321 |
-
else{row.getCell(8).value=Number(it.discPrice||it.price||0);}
|
| 322 |
-
row.getCell(8).numFmt=MONEY_FMT;row.getCell(8).alignment={horizontal:'right',vertical:'middle'};
|
| 323 |
-
if((it.discPrice||0)&&(it.price||0)&&it.discPrice<it.price)row.getCell(8).font={bold:true,color:{argb:'FFDC3545'}};
|
| 324 |
-
row.getCell(9).value={formula:'F'+cr+'*H'+cr,result:Number(it.total||0)};row.getCell(9).numFmt=MONEY_FMT;row.getCell(9).font={bold:true};row.getCell(9).alignment={horizontal:'right',vertical:'middle'};
|
| 325 |
-
row.getCell(10).value=it.note||'';row.getCell(10).font={size:8};row.getCell(10).alignment={wrapText:true,vertical:'middle'};
|
| 326 |
-
for(var ci=1;ci<=10;ci++){row.getCell(ci).fill={type:'pattern',pattern:'solid',fgColor:{argb:bgColor}};row.getCell(ci).border=RB;}
|
| 327 |
-
cr++;
|
| 328 |
-
}
|
| 329 |
-
var lastItemRow=cr-1;
|
| 330 |
-
var totalQtyFormula=lastItemRow>=firstItemRow?'SUM(F'+firstItemRow+':F'+lastItemRow+')':'0';
|
| 331 |
-
var totalQtyValue=(qd.items||[]).reduce(function(s,it){return s+Number(it.qty||1);},0);
|
| 332 |
-
if(ckPct>0&&ckPct<=100){
|
| 333 |
-
ws.getCell('K1').value=Number((1-ckPct/100).toFixed(4));
|
| 334 |
-
ws.getCell('K1').numFmt='0.00%';
|
| 335 |
-
ws.getColumn(11).width=10;
|
| 336 |
-
ws.getCell('K2').value='CK '+ckPct+'%';
|
| 337 |
-
ws.getCell('K2').font={bold:true,size:9,color:{argb:'FFDC2626'}};
|
| 338 |
-
}
|
| 339 |
-
cr++;ws.mergeCells(cr,1,cr,8);
|
| 340 |
-
var bhRow=ws.getRow(cr);bhRow.height=18;
|
| 341 |
-
bhRow.getCell(1).value='✅ Bảo hành 2 năm (sản phẩm) — Bảo hành hoen gỉ vĩnh viễn (rổ SUS304)';
|
| 342 |
-
bhRow.getCell(1).font={size:9,color:{argb:'FF059669'},italic:true};
|
| 343 |
-
bhRow.getCell(1).alignment={vertical:'middle'};
|
| 344 |
-
for(var ci=1;ci<=10;ci++){bhRow.getCell(ci).fill={type:'pattern',pattern:'solid',fgColor:{argb:'FFF0FDF4'}};}
|
| 345 |
-
var sumParts=[];if(lastItemRow>=firstItemRow)sumParts.push('SUM(I'+firstItemRow+':I'+lastItemRow+')');
|
| 346 |
-
if(d.fees&&d.fees.length){var FBG='FFFFFBEB';var FB={top:{style:'thin',color:{argb:FBG}},bottom:{style:'thin',color:{argb:FBG}},left:{style:'thin',color:{argb:FBG}},right:{style:'thin',color:{argb:FBG}}};d.fees.forEach(function(f){var row=ws.getRow(cr);row.height=20;ws.mergeCells(cr,1,cr,8);row.getCell(1).value=' ⊕ '+f.label;row.getCell(1).font={size:9,color:{argb:'FF92400E'}};row.getCell(1).alignment={vertical:'middle'};row.getCell(9).value=Number(f.amount||0);row.getCell(9).numFmt=MONEY_FMT;row.getCell(9).font={bold:true,size:9,color:{argb:'FF92400E'}};row.getCell(9).alignment={horizontal:'right',vertical:'middle'};for(var ci=1;ci<=10;ci++){row.getCell(ci).fill={type:'pattern',pattern:'solid',fgColor:{argb:FBG}};row.getCell(ci).border=FB;}sumParts.push('I'+cr);cr++;});}
|
| 347 |
-
var totalRowNum=cr;
|
| 348 |
-
var TBG='FF003F62';var TB={top:{style:'thin',color:{argb:TBG}},bottom:{style:'thin',color:{argb:TBG}},left:{style:'thin',color:{argb:TBG}},right:{style:'thin',color:{argb:TBG}}};
|
| 349 |
-
ws.mergeCells(cr,1,cr,5);
|
| 350 |
-
var tRow=ws.getRow(cr);tRow.height=28;
|
| 351 |
-
tRow.getCell(1).value='TỔNG CỘNG';tRow.getCell(1).font={bold:true,size:13,color:{argb:'FFFFFFFF'}};tRow.getCell(1).alignment={horizontal:'left',vertical:'middle',indent:1};tRow.getCell(1).fill={type:'pattern',pattern:'solid',fgColor:{argb:TBG}};tRow.getCell(1).border=TB;
|
| 352 |
-
tRow.getCell(6).value={formula:totalQtyFormula,result:totalQtyValue};tRow.getCell(6).numFmt=NUM_FMT;tRow.getCell(6).font={bold:true,size:12,color:{argb:'FFFFFFFF'}};tRow.getCell(6).alignment={horizontal:'center',vertical:'middle'};tRow.getCell(6).fill={type:'pattern',pattern:'solid',fgColor:{argb:TBG}};tRow.getCell(6).border=TB;tRow.getCell(7).fill={type:'pattern',pattern:'solid',fgColor:{argb:TBG}};tRow.getCell(7).border=TB;tRow.getCell(8).fill={type:'pattern',pattern:'solid',fgColor:{argb:TBG}};tRow.getCell(8).border=TB;
|
| 353 |
-
tRow.getCell(9).value={formula:sumParts.length?sumParts.join('+'):'0',result:Number(d.grandTotal||0)};tRow.getCell(9).numFmt=MONEY_FMT;tRow.getCell(9).font={bold:true,size:14,color:{argb:'FFF0B840'}};tRow.getCell(9).alignment={horizontal:'right',vertical:'middle'};tRow.getCell(9).fill={type:'pattern',pattern:'solid',fgColor:{argb:TBG}};tRow.getCell(9).border=TB;tRow.getCell(10).fill={type:'pattern',pattern:'solid',fgColor:{argb:TBG}};tRow.getCell(10).border=TB;cr++;
|
| 354 |
-
if(d.deposit>0){var DBG='FFF0FDF4';var DB={top:{style:'thin',color:{argb:DBG}},bottom:{style:'thin',color:{argb:DBG}},left:{style:'thin',color:{argb:DBG}},right:{style:'thin',color:{argb:DBG}}};ws.mergeCells(cr,1,cr,8);var dRow=ws.getRow(cr);dRow.height=24;dRow.getCell(1).value='Đã cọc';dRow.getCell(1).font={bold:true,size:11,color:{argb:'FF166534'}};dRow.getCell(1).alignment={horizontal:'left',vertical:'middle',indent:1};dRow.getCell(1).fill={type:'pattern',pattern:'solid',fgColor:{argb:DBG}};dRow.getCell(1).border=DB;dRow.getCell(9).value=Number(d.deposit||0);dRow.getCell(9).numFmt=MONEY_FMT;dRow.getCell(9).font={bold:true,size:11,color:{argb:'FF166534'}};dRow.getCell(9).alignment={horizontal:'right',vertical:'middle'};dRow.getCell(9).fill={type:'pattern',pattern:'solid',fgColor:{argb:DBG}};dRow.getCell(9).border=DB;dRow.getCell(10).fill={type:'pattern',pattern:'solid',fgColor:{argb:DBG}};dRow.getCell(10).border=DB;var depositRowNum=cr;cr++;var RBG='FFFEF2F2';var RBD={top:{style:'thin',color:{argb:RBG}},bottom:{style:'thin',color:{argb:RBG}},left:{style:'thin',color:{argb:RBG}},right:{style:'thin',color:{argb:RBG}}};ws.mergeCells(cr,1,cr,8);var rRow=ws.getRow(cr);rRow.height=26;rRow.getCell(1).value='CÒN LẠI';rRow.getCell(1).font={bold:true,size:12,color:{argb:'FFDC2626'}};rRow.getCell(1).alignment={horizontal:'left',vertical:'middle',indent:1};rRow.getCell(1).fill={type:'pattern',pattern:'solid',fgColor:{argb:RBG}};rRow.getCell(1).border=RBD;rRow.getCell(9).value={formula:'MAX(I'+totalRowNum+'-I'+depositRowNum+',0)',result:Number(d.remaining||0)};rRow.getCell(9).numFmt=MONEY_FMT;rRow.getCell(9).font={bold:true,size:13,color:{argb:'FFDC2626'}};rRow.getCell(9).alignment={horizontal:'right',vertical:'middle'};rRow.getCell(9).fill={type:'pattern',pattern:'solid',fgColor:{argb:RBG}};rRow.getCell(9).border=RBD;rRow.getCell(10).fill={type:'pattern',pattern:'solid',fgColor:{argb:RBG}};rRow.getCell(10).border=RBD;cr++;}
|
| 355 |
-
if(d.notes&&d.notes.length){var NBG='FFF0FDF4';var NB2={top:{style:'thin',color:{argb:NBG}},bottom:{style:'thin',color:{argb:NBG}},left:{style:'thin',color:{argb:NBG}},right:{style:'thin',color:{argb:NBG}}};ws.mergeCells(cr,1,cr,10);ws.getCell('A'+cr).value='📝 Ghi chú: '+d.notes.join('; ');ws.getCell('A'+cr).font={italic:true,size:9,color:{argb:'FF166534'}};ws.getCell('A'+cr).fill={type:'pattern',pattern:'solid',fgColor:{argb:NBG}};ws.getCell('A'+cr).border=NB2;cr++;}
|
| 356 |
-
cr++;var QBG='FFF8FAFC';var QB={top:{style:'thin',color:{argb:QBG}},bottom:{style:'thin',color:{argb:QBG}},left:{style:'thin',color:{argb:QBG}},right:{style:'thin',color:{argb:QBG}}};
|
| 357 |
-
ws.mergeCells(cr,1,cr,5);ws.getCell('A'+cr).value='💳 CHUYỂN KHOẢN';ws.getCell('A'+cr).font={bold:true,size:11,color:{argb:'FF003F62'}};ws.getCell('A'+cr).fill={type:'pattern',pattern:'solid',fgColor:{argb:QBG}};ws.getCell('A'+cr).border=QB;cr++;
|
| 358 |
-
ws.mergeCells(cr,1,cr,5);ws.getCell('A'+cr).value='🏦 VIB | 👤 '+BANK_NAME_VN;ws.getCell('A'+cr).font={size:10};ws.getCell('A'+cr).fill={type:'pattern',pattern:'solid',fgColor:{argb:QBG}};ws.getCell('A'+cr).border=QB;cr++;
|
| 359 |
-
ws.mergeCells(cr,1,cr,5);ws.getCell('A'+cr).value='🔢 STK: '+BANK_ACCOUNT;ws.getCell('A'+cr).font={bold:true,size:10};ws.getCell('A'+cr).fill={type:'pattern',pattern:'solid',fgColor:{argb:QBG}};ws.getCell('A'+cr).border=QB;cr++;
|
| 360 |
-
ws.mergeCells(cr,1,cr,5);ws.getCell('A'+cr).value='💰 '+fmt(d.deposit>0?d.remaining:d.grandTotal)+' | 📝 '+code;ws.getCell('A'+cr).font={bold:true,size:10};ws.getCell('A'+cr).fill={type:'pattern',pattern:'solid',fgColor:{argb:QBG}};ws.getCell('A'+cr).border=QB;cr++;
|
| 361 |
-
try{var qrR=await fetch(qr,{mode:'cors'});if(qrR.ok){var qb=await qrR.arrayBuffer();ws.addImage(wb.addImage({buffer:qb,extension:'png'}),{tl:{col:6,row:cr-5},ext:{width:115,height:115}});}}catch(e){}
|
| 362 |
-
ws.eachRow(function(row){row.eachCell(function(cell){if(!cell.border)cell.border=WB;});});
|
| 363 |
-
wb.calcProperties.fullCalcOnLoad = true;
|
| 364 |
-
var buf=await wb.xlsx.writeBuffer();var blob=new Blob([buf],{type:'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'});var url=URL.createObjectURL(blob);var a=document.createElement('a');a.href=url;a.download=code+'.xlsx';a.click();setTimeout(function(){URL.revokeObjectURL(url);},60000);
|
| 365 |
-
}
|
| 366 |
-
|
| 367 |
-
async function _doExportDeliveryExcel(qd,code){
|
| 368 |
-
var WHITE={argb:'FFFFFFFF'};var WB={top:{style:'thin',color:WHITE},bottom:{style:'thin',color:WHITE},left:{style:'thin',color:WHITE},right:{style:'thin',color:WHITE}};
|
| 369 |
-
var HB={top:{style:'thin',color:{argb:'FF003F62'}},bottom:{style:'thin',color:{argb:'FF003F62'}},left:{style:'thin',color:{argb:'FF003F62'}},right:{style:'thin',color:{argb:'FF003F62'}}};
|
| 370 |
-
var wb=new ExcelJS.Workbook(),ws=wb.addWorksheet('Giao hàng');
|
| 371 |
-
ws.views=[{showGridLines:false}];ws.columns=[{width:5},{width:34},{width:14},{width:8},{width:20}];
|
| 372 |
-
ws.mergeCells('A1:E1');ws.getCell('A1').value='PHIẾU GIAO HÀNG';ws.getCell('A1').font={bold:true,size:15,color:{argb:'FF003F62'}};ws.getCell('A1').alignment={horizontal:'center'};ws.getCell('A1').border=WB;ws.getRow(1).height=24;
|
| 373 |
-
ws.getCell('A2').value='KH: '+(qd.customer?qd.customer.name:'');ws.getCell('A2').font={bold:true,size:10};ws.getCell('A2').border=WB;
|
| 374 |
-
ws.getCell('D2').value='Mã: '+code;ws.getCell('D2').font={bold:true,size:9,color:{argb:'FF003F62'}};ws.getCell('D2').border=WB;
|
| 375 |
-
ws.getCell('A3').value='SĐT: '+(qd.customer?qd.customer.phone:'');ws.getCell('A3').border=WB;
|
| 376 |
-
ws.getCell('D3').value='Ngày: '+(qd.customer?qd.customer.date:'');ws.getCell('D3').border=WB;
|
| 377 |
-
ws.getCell('A4').value='Địa chỉ: '+(qd.customer?qd.customer.addr||'':'');ws.getCell('A4').border=WB;
|
| 378 |
-
ws.getRow(5).height=4;
|
| 379 |
-
var hr=ws.getRow(6);['STT','Tên sản phẩm','Mã SP','SL','Ghi chú'].forEach(function(h,i){var c=hr.getCell(i+1);c.value=h;c.font={bold:true,color:{argb:'FFFFFFFF'},size:10};c.fill={type:'pattern',pattern:'solid',fgColor:{argb:'FF003F62'}};c.alignment={horizontal:'center',vertical:'middle'};c.border=HB;});hr.height=20;
|
| 380 |
-
var cr=7;var items=qd.items||[];
|
| 381 |
-
for(var i=0;i<items.length;i++){var it=items[i],row=ws.getRow(cr);row.height=20;var bgColor=i%2===0?'FFF8FAFC':'FFFFFFFF';var RB={top:{style:'thin',color:{argb:bgColor}},bottom:{style:'thin',color:{argb:bgColor}},left:{style:'thin',color:{argb:bgColor}},right:{style:'thin',color:{argb:bgColor}}};row.getCell(1).value=it.stt||i+1;row.getCell(1).alignment={horizontal:'center',vertical:'middle'};row.getCell(2).value=it.name||'';row.getCell(2).font={size:10};row.getCell(3).value=it.model||'';row.getCell(3).alignment={horizontal:'center',vertical:'middle'};row.getCell(4).value=it.qty||1;row.getCell(4).alignment={horizontal:'center',vertical:'middle'};row.getCell(4).font={bold:true};row.getCell(5).value=it.note||'';for(var ci=1;ci<=5;ci++){row.getCell(ci).fill={type:'pattern',pattern:'solid',fgColor:{argb:bgColor}};row.getCell(ci).border=RB;}cr++;}
|
| 382 |
-
var totalQtyRow=cr;var TQBG='FFEFF6FF';var TQB={top:{style:'thin',color:{argb:TQBG}},bottom:{style:'thin',color:{argb:TQBG}},left:{style:'thin',color:{argb:TQBG}},right:{style:'thin',color:{argb:TQBG}}};ws.mergeCells(totalQtyRow,1,totalQtyRow,3);ws.getCell('A'+totalQtyRow).value='TỔNG CỘNG SỐ LƯỢNG';ws.getCell('A'+totalQtyRow).font={bold:true,size:10,color:{argb:'FF1E40AF'}};ws.getCell('A'+totalQtyRow).fill={type:'pattern',pattern:'solid',fgColor:{argb:TQBG}};ws.getCell('A'+totalQtyRow).border=TQB;ws.getCell('D'+totalQtyRow).value={formula:items.length?'SUM(D7:D'+(cr-1)+')':'0',result:items.reduce(function(s,it){return s+Number(it.qty||1);},0)};ws.getCell('D'+totalQtyRow).numFmt='#,##0';ws.getCell('D'+totalQtyRow).font={bold:true,size:10,color:{argb:'FF1E40AF'}};ws.getCell('D'+totalQtyRow).alignment={horizontal:'center',vertical:'middle'};ws.getCell('D'+totalQtyRow).fill={type:'pattern',pattern:'solid',fgColor:{argb:TQBG}};ws.getCell('D'+totalQtyRow).border=TQB;ws.getCell('E'+totalQtyRow).fill={type:'pattern',pattern:'solid',fgColor:{argb:TQBG}};ws.getCell('E'+totalQtyRow).border=TQB;cr++;
|
| 383 |
-
cr+=2;ws.getCell('A'+cr).value='Bên giao: ________________';ws.getCell('A'+cr).border=WB;ws.getCell('D'+cr).value='Bên nhận: ________________';ws.getCell('D'+cr).border=WB;
|
| 384 |
-
cr++;ws.getCell('A'+cr).value='(Ký, họ tên)';ws.getCell('A'+cr).font={italic:true,size:8,color:{argb:'FF64748B'}};ws.getCell('A'+cr).border=WB;ws.getCell('D'+cr).value='(Ký, họ tên)';ws.getCell('D'+cr).font={italic:true,size:8,color:{argb:'FF64748B'}};ws.getCell('D'+cr).border=WB;
|
| 385 |
-
ws.eachRow(function(row){row.eachCell(function(cell){if(!cell.border)cell.border=WB;});});
|
| 386 |
-
var buf=await wb.xlsx.writeBuffer();var blob=new Blob([buf],{type:'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'});var url=URL.createObjectURL(blob);var a=document.createElement('a');a.href=url;a.download='GH-'+code+'.xlsx';a.click();setTimeout(function(){URL.revokeObjectURL(url);},60000);
|
| 387 |
-
}
|
| 388 |
-
|
| 389 |
-
var att=0;var t=setInterval(function(){if(doOverride()||att>120)clearInterval(t);att++;},500);
|
| 390 |
-
|
| 391 |
-
// Fallback: intercept button clicks with deduplication prevention
|
| 392 |
-
document.addEventListener('click',function(e){
|
| 393 |
-
var btn=e.target.closest&&e.target.closest('button,a');
|
| 394 |
-
if(!btn)return;
|
| 395 |
-
var txt=(btn.textContent||'').toLowerCase();
|
| 396 |
-
if(!window._origGetQuoteData)return;
|
| 397 |
-
if(txt.includes('excel')&&txt.includes('xuất')){
|
| 398 |
-
e.preventDefault();e.stopPropagation();
|
| 399 |
-
// Prevent multiple clicks
|
| 400 |
-
if(btn.dataset.vaiExporting==='1')return;
|
| 401 |
-
setExportButtonState(btn, true);
|
| 402 |
-
window.exportExcel().finally(function(){setExportButtonState(btn, false);});
|
| 403 |
-
return false;
|
| 404 |
-
}
|
| 405 |
-
if(txt.includes('pdf')&&txt.includes('xuất')){
|
| 406 |
-
e.preventDefault();e.stopPropagation();
|
| 407 |
-
if(btn.dataset.vaiExporting==='1')return;
|
| 408 |
-
setExportButtonState(btn, true);
|
| 409 |
-
window.exportPDF().finally(function(){setExportButtonState(btn, false);});
|
| 410 |
-
return false;
|
| 411 |
-
}
|
| 412 |
-
if(txt.includes('chia sẻ')&&txt.includes('ảnh')){
|
| 413 |
-
e.preventDefault();e.stopPropagation();
|
| 414 |
-
if(btn.dataset.vaiExporting==='1')return;
|
| 415 |
-
setExportButtonState(btn, true);
|
| 416 |
-
window.shareQuoteImage().finally(function(){setExportButtonState(btn, false);});
|
| 417 |
-
return false;
|
| 418 |
-
}
|
| 419 |
-
},true);
|
| 420 |
-
|
| 421 |
-
window.VAI_QR={getEffectiveOrderCode:getEffectiveOrderCode,getQRUrl:getQRUrl,generateOrderCode:generateOrderCode,parsePrompt:parsePrompt,getPromptText:getPromptText,injectToModal:injectToModal,getData:getData,buildQuoteHTML:buildQuoteHTML,buildDeliveryHTML:buildDeliveryHTML,toCanvas:toCanvas,exportPDF:_doExportPDF,exportExcel:_doExportExcel,exportDeliveryPDF:_doExportDeliveryPDF,exportDeliveryExcel:_doExportDeliveryExcel,fmt:fmt,compactKey:compactKey,matchItemDiscount:matchItemDiscount,parseItemDiscountLine:parseItemDiscountLine,applyPromptDiscounts:applyPromptDiscounts,setExportButtonState:setExportButtonState,orderToVAIData:orderToVAIData};
|
| 422 |
-
})();
|
|
|
|
| 1 |
+
/* V.AI STUDIO — QR Payment / Quote Data v1039
|
| 2 |
+
* FIX TRIỆT ĐỐI: Multi-download Excel - removed URL.revokeObjectURL timeout
|
| 3 |
+
*/
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|