'+ ''+ ''+ ''+ ''+ ''+rows+'

Month	Type	Installment	Principal	Profit	Balance

'+ ''+ ' '; var w=window.open('','_blank'); if(!w){alert('Popup blocked. Please allow popups for this site to save PDF.');return;} w.document.open();w.document.write(html);w.document.close(); setTimeout(function(){try{w.focus();w.print();}catch(e){}},400); } function doWA(){ var n=(gid('cname')||{}).value||'Customer',wa=((gid('cwa')||{}).value||'').replace(/[^0-9+]/g,''); var P=parseFloat(gid('amt').value)||0,r=getRate()||0,ten=gid('ten').value+' '+(tuIdx===1?'Yrs':'Mo'); var msg='Personal Finance Illustration - DIB\nCustomer: '+n+'\nFinance: AED '+Math.round(P).toLocaleString()+'\nProfit Rate: '+r.toFixed(2)+'% p.a.\nTenure: '+ten+'\nInstallment: '+(gid('rEMI').textContent||'--')+'\nSale Price: '+(gid('rSAL').textContent||'--')+'\nInnoventure Financing Broker Co. LLC - An Authorised Channel Partner of Dubai Islamic Bank, UAE'; window.open((wa?'https://wa.me/'+wa.replace('+',''):'https://wa.me/')+'?text='+encodeURIComponent(msg),'_blank'); } function doEM(){ var n=(gid('cname')||{}).value||'Customer',em=(gid('cemail')||{}).value||'',P=parseFloat(gid('amt').value)||0; var sub='Personal Finance Illustration - '+n; var body='Dear '+n+',\n\nFinance: AED '+Math.round(P).toLocaleString()+'\nInstallment: '+(gid('rEMI').textContent||'--')+'\nSale Price: '+(gid('rSAL').textContent||'--')+'\n\nInnoventure Financing Broker Co. LLC - An Authorised Channel Partner of Dubai Islamic Bank, UAE'; window.location.href='mailto:'+em+'?subject='+encodeURIComponent(sub)+'&body='+encodeURIComponent(body); } function init(){ try{ var yr=gid('yr');if(yr)yr.textContent=new Date().getFullYear(); applyAccess(); updSal(); doCalc(); }catch(e){ } } window.pfx={ show:show, applyAccess:applyAccess, hasAccess:hasAccess, showTab:showTab, setCT:setCT, setTU:setTU, updSal:updSal, updRate:updRate, syncS:syncS, syncR:syncR, doCalc:doCalc, addCC:addCC, calcDBR:calcDBR, calcAb:calcAb, goP:goP, doPDF:doPDF, doWA:doWA, doEM:doEM }; document.addEventListener('DOMContentLoaded',init); })();

'+rowsHTML+'

BDE	TL/Manager	CBD (T/Booked)	DIB Card (T/Booked)	DIB PF Vol (T/Booked)	Status

'; var w=window.open('','_blank'); if(!w){ _stToast('Allow popups to export PDF.','error'); return; } w.document.open(); w.document.write(html); w.document.close(); setTimeout(function(){try{w.focus();w.print();}catch(e){}},450); }; window.lbInit = function(vertical) { lbVertical = vertical || "CC"; var titleEl = document.getElementById("lb-title"); var subEl = document.getElementById("lb-subtitle"); if (titleEl) titleEl.textContent = lbVertical + " Leaderboard"; if (subEl) subEl.textContent = lbVertical === "CC" ? "Credit Cards \\u2014 Ranked by performance" : "Personal Finance \\u2014 Ranked by bookings"; lbRevenueAllowed = !!(CRM && CRM.user && ["Admin","VerticalHead"].indexOf(CRM.user.role) >= 0); lbBuildBoards(); lbLoadAll(); }; function lbBuildBoards() { var mount = document.getElementById("lb-revenue-board-mount"); var bookedMount = document.getElementById("lb-booked-board-mount"); if (lbVertical === "PF") { if (bookedMount) { bookedMount.innerHTML = ''; } if (mount) { mount.innerHTML = lbRevenueAllowed ? '' : ''; } } else { if (mount) { mount.innerHTML = lbRevenueAllowed ? '' : ''; } if (bookedMount) bookedMount.innerHTML = ''; } } window.lbSetPeriod = function(period, btn) { lbPeriod = period; document.querySelectorAll(".lb-ptab").forEach(function(b){ b.classList.remove("active"); }); btn.classList.add("active"); var banner = document.getElementById("lb-period-banner"); if (banner) banner.textContent = PERIOD_LABELS[period] + " - " + period + " Rankings"; lbLoadAll(); }; window.lbLoadAll = function() { if (lbVertical === "PF") { lbLoadPFBoard("submitted"); lbLoadPFBoard("approved"); lbLoadPFBoard("booked"); if (lbRevenueAllowed) lbLoadPFBoard("revenue"); } else { loadBoard("approvals"); loadBoard("submitted"); if (lbRevenueAllowed) loadBoard("revenue"); } }; function lbLoadPFBoard(metric) { var boardId = metric === "booked" ? "lb-booked-board" : metric === "revenue" ? "lb-revenue-board" : metric === "approved" ? "lb-approvals-board" : "lb-submitted-board"; var el = document.getElementById(boardId); if (!el) return; el.innerHTML = ''; call('getPFRoleScopedSummary', [{from:'', to:''}, CRM.user], function(err, res) { if (err || !res || !res.success) { el.innerHTML = ''; return; } var byBde = res.byBde || []; if (!byBde.length) { el.innerHTML = ''; return; } var sorted = byBde.slice().sort(function(a,b){ if (metric==='booked') return (b.booked||0)-(a.booked||0); if (metric==='approved') return (b.approved||0)-(a.approved||0); if (metric==='revenue') return (b.approvedAmt||0)-(a.approvedAmt||0); return (b.submitted||0)-(a.submitted||0); }).filter(function(b){ if (metric==='booked') return (b.booked||0)>0; if (metric==='approved') return (b.approved||0)>0; return (b.submitted||0)>0; }); if (!sorted.length) { el.innerHTML = ''; return; } var medals = ["🥇","🥈","🥉"]; el.innerHTML = sorted.slice(0,10).map(function(b, i) { var rank = i+1; var isTop3 = rank <= 3; var rankCls = rank===1?"lb-rank-1":rank===2?"lb-rank-2":rank===3?"lb-rank-3":"lb-rank-n"; var val, valSub; if (metric==='booked') { val = (b.booked||0)+' Booked'; valSub = 'AED '+(b.approvedAmt||0).toLocaleString(); } else if (metric==='approved') { val = (b.approved||0)+' Approved'; valSub = (b.submitted||0)+' submitted'; } else if (metric==='revenue') { val = 'AED '+(b.approvedAmt||0).toLocaleString(); valSub = (b.booked||0)+' booked'; } else { val = (b.submitted||0)+' Cases'; valSub = (b.approved||0)+' approved'; } return ''; }).join(""); }, true); } function loadBoard(metric) { var el = document.getElementById("lb-"+metric+"-board"); if (!el) return; el.innerHTML = ''; google.script.run .withSuccessHandler(function(res){ renderBoard(metric,res); }) .withFailureHandler(function(err){ if(el) el.innerHTML=''; }) .handleLeaderboardAction("getLeaderboard",{metric:metric,period:lbPeriod,vertical:lbVertical},CRM.user); } function renderBoard(metric, res) { var el = document.getElementById("lb-"+metric+"-board"); if (!el) return; if (!res.success) { el.innerHTML=''; return; } if (!res.board||!res.board.length) { el.innerHTML=''; return; } var medals = ["🥇","🥈","🥉"]; el.innerHTML = res.board.map(function(r) { var isTop3 = r.rank <= 3; var rankCls = r.rank===1?"lb-rank-1":r.rank===2?"lb-rank-2":r.rank===3?"lb-rank-3":"lb-rank-n"; var val,valSub; if (metric==="revenue") { val="AED "+(r.revenue||0).toLocaleString(); valSub=r.approvals+" approvals"; } else if (metric==="submitted") { val=r.submitted.toLocaleString(); valSub=r.approvals+" approved"; } else { val=r.approvals.toLocaleString(); valSub=r.submitted+" submitted"; } return ''; }).join(""); } window.lbExportSheet = function(metric) { var m = metric||"approvals"; showLbMsg("info","Exporting..."); google.script.run .withSuccessHandler(function(res){ showLbMsg(res.success?"ok":"err",res.message||res.error); }) .withFailureHandler(function(err){ showLbMsg("err",err.message); }) .handleLeaderboardAction("exportLeaderboardToSheet",{metric:m,period:lbPeriod,vertical:lbVertical},CRM.user); }; window.lbExportToSheet = function() { var period = document.getElementById("lb-report-period").value; showLbMsg("info","Exporting report..."); google.script.run .withSuccessHandler(function(res){ showLbMsg(res.success?"ok":"err",res.message||res.error); }) .withFailureHandler(function(err){ showLbMsg("err",err.message); }) .handleLeaderboardAction("exportSalesTrackerReport",{period:period},CRM.user); }; window.lbDownloadCSV = function() { var period = document.getElementById("lb-report-period").value; showLbMsg("info","Preparing CSV..."); google.script.run .withSuccessHandler(function(res) { if (!res.success) { showLbMsg("err",res.error); return; } var appRes = res.approvals; var NL = String.fromCharCode(10); var csv = lbVertical+" Leaderboard - "+period+NL; csv += "APPROVALS BOARD"+NL+"Rank,Agent,Approvals,Submitted,WIP"+NL; (appRes.board||[]).forEach(function(r){ csv+=r.rank+","+r.agent+","+r.approvals+","+r.submitted+","+r.wip+NL; }); var blob=new Blob([csv],{type:"text/csv"}); var url=URL.createObjectURL(blob); var a=document.getElementById("lb-csv-link"); a.href=url; a.download=lbVertical+"_Leaderboard_"+period+"_"+new Date().toISOString().slice(0,10)+".csv"; a.click(); URL.revokeObjectURL(url); showLbMsg("ok","CSV downloaded!"); }) .withFailureHandler(function(err){ showLbMsg("err",err.message); }) .handleLeaderboardAction("getBothBoards",{period:period,vertical:lbVertical},CRM.user); }; function showLbMsg(type,text) { var el=document.getElementById("lb-report-msg"); el.textContent=text; el.className="lb-msg "+type; el.style.display="block"; if (type==="ok") setTimeout(function(){ el.style.display="none"; },3000); } document.addEventListener("DOMContentLoaded",function(){ if (window.CRM && CRM.user) stInit(); }); })();

'+ ''+ ''+ ''+ (opts.summaryHTML||'')+ opts.tableHTML+ ''+ ' '; var w = window.open('', '_blank'); if (!w) { toast('Popup blocked. Please allow popups to export PDF.','error'); return; } w.document.open(); w.document.write(html); w.document.close(); setTimeout(function(){ try{ w.focus(); w.print(); }catch(e){} }, 450); } window.rptExportPFExcel = function() { if (!_rptPFAllCases.length) { toast('Generate the report first.','error'); return; } _rptEnsureXLSX(function() { var rows = _rptPFAllCases.map(function(c) { return { 'APP ID': c["APP ID"]||c["Case ID"]||'', 'Customer': c["Customer Name"]||'', 'BDE': c["BDE Name"]||'', 'TL/Manager': c["TL Name"]||'', 'Bank': c["Bank"]||'', 'PF Type': c["PF Type"]||'', 'Proposed Amt': Number(c["Proposed PF Amount"]||0), 'Approved Amt': Number(c["Approved PF Amount"]||0), 'IFB Status': c["IFB Status"]||'', 'Booking Status': c["Booking Status"]||'', 'Month': (c["IFB Submission Date"]||'').slice(0,7) }; }); var ws = XLSX.utils.json_to_sheet(rows); ws["!cols"] = [{wch:12},{wch:24},{wch:18},{wch:18},{wch:12},{wch:18},{wch:13},{wch:13},{wch:12},{wch:18},{wch:9}]; var wb = XLSX.utils.book_new(); XLSX.utils.book_append_sheet(wb, ws, 'PF Report'); XLSX.writeFile(wb, 'PF_Report_'+new Date().toISOString().slice(0,10)+'.xlsx'); toast(rows.length+' records exported to Excel.','success'); }); }; window.rptExportPFPDF = function() { if (!_rptPFAllCases.length) { toast('Generate the report first.','error'); return; } var g = function(id){ return (document.getElementById(id)||{}).value||''; }; var filters = _rptFilterLine([ ['Bank', g('rpt-pf-bank')], ['BDE', g('rpt-pf-bde')], ['Manager/TL', g('rpt-pf-tl')], ['PF Type', g('rpt-pf-type')], ['Month', _RPT_MONTHS[g('rpt-pf-month')]||''], ['Year', g('rpt-pf-year')], ['IFB Status', g('rpt-pf-status')] ]); var totalProp = 0, totalAppr = 0, booked = 0; var rowsHTML = ''; _rptPFAllCases.forEach(function(c) { totalProp += Number(c["Proposed PF Amount"]||0); totalAppr += Number(c["Approved PF Amount"]||0); if ((c["IFB Status"]||'') === 'Booked') booked++; rowsHTML += ''+ ''+_rptEsc(c["APP ID"]||c["Case ID"]||'-')+''+ ''+_rptEsc(c["Customer Name"]||'-')+''+ ''+_rptEsc(c["BDE Name"]||'-')+''+ ''+_rptEsc(c["TL Name"]||'-')+''+ ''+_rptEsc(c["PF Type"]||c["Bank"]||'-')+''+ ''+Number(c["Proposed PF Amount"]||0).toLocaleString()+''+ ''+(c["Approved PF Amount"]?Number(c["Approved PF Amount"]).toLocaleString():'-')+''+ ''+_rptEsc(c["IFB Status"]||'-')+''+ ''+_rptEsc(c["Booking Status"]||'-')+''+ ''+_rptEsc((c["IFB Submission Date"]||'-').slice(0,7))+''+ ''; }); var summary = ''; var table = ''+ ''+ ''+rowsHTML+'

APP ID	Customer	BDE	TL/Manager	PF Type	Proposed (AED)	Approved (AED)	IFB Status	Booking Status	Month

'; _rptPrintPDF({ title:'PF Report', landscape:true, filters:filters, summaryHTML:summary, tableHTML:table, count:_rptPFAllCases.length }); }; function _rptBSAggregate() { var byBde = {}, withLL = 0, withoutLL = 0, other = 0; _rptBSCases.forEach(function(c) { var name = c["BDE Name"]||'Unknown'; if (!byBde[name]) byBde[name] = {name:name, tl:c["TL Name"]||'-', withLL:0, withoutLL:0, other:0, total:0}; var bs = String(c["Booking Status"]||'').trim(); if (bs === 'Booking with LL') { byBde[name].withLL++; withLL++; } else if (bs === 'Booking without LL') { byBde[name].withoutLL++; withoutLL++; } else { byBde[name].other++; other++; } byBde[name].total++; }); var list = Object.keys(byBde).map(function(k){ return byBde[k]; }) .sort(function(a,b){ return b.total - a.total || String(a.name).localeCompare(String(b.name)); }); return { list:list, withLL:withLL, withoutLL:withoutLL, other:other, total:_rptBSCases.length }; } window.rptExportBSExcel = function() { if (!_rptBSCases.length) { toast('Generate the report first.','error'); return; } _rptEnsureXLSX(function() { var agg = _rptBSAggregate(); var sumRows = agg.list.map(function(e) { return { 'BDE': e.name, 'TL/Manager': e.tl, 'Booking with LL': e.withLL, 'Booking without LL': e.withoutLL, 'Total': e.total, '% with LL': e.total>0 ? Math.round(e.withLL/e.total*100)+'%' : '0%' }; }); sumRows.push({ 'BDE':'TOTAL', 'TL/Manager':'', 'Booking with LL':agg.withLL, 'Booking without LL':agg.withoutLL, 'Total':agg.total, '% with LL': agg.total>0 ? Math.round(agg.withLL/agg.total*100)+'%' : '0%' }); var ws1 = XLSX.utils.json_to_sheet(sumRows); ws1["!cols"] = [{wch:22},{wch:20},{wch:16},{wch:18},{wch:9},{wch:11}]; var caseRows = _rptBSCases.map(function(c) { return { 'APP ID': c["APP ID"]||c["Case ID"]||'', 'Customer': c["Customer Name"]||'', 'BDE': c["BDE Name"]||'', 'TL/Manager': c["TL Name"]||'', 'Bank': c["Bank"]||'', 'Booking Status': c["Booking Status"]||'', 'Booking Date': (c["Booking Date"]||'').slice(0,10), 'Month': (c["IFB Submission Date"]||'').slice(0,7) }; }); var ws2 = XLSX.utils.json_to_sheet(caseRows); ws2["!cols"] = [{wch:12},{wch:24},{wch:18},{wch:18},{wch:12},{wch:18},{wch:12},{wch:9}]; var wb = XLSX.utils.book_new(); XLSX.utils.book_append_sheet(wb, ws1, 'BDE Summary'); XLSX.utils.book_append_sheet(wb, ws2, 'Case Details'); XLSX.writeFile(wb, 'Booking_Status_Report_'+new Date().toISOString().slice(0,10)+'.xlsx'); toast(caseRows.length+' records exported to Excel.','success'); }); }; window.rptExportBSPDF = function() { if (!_rptBSCases.length) { toast('Generate the report first.','error'); return; } var g = function(id){ return (document.getElementById(id)||{}).value||''; }; var filters = _rptFilterLine([ ['Bank', g('rpt-bs-bank')], ['BDE', g('rpt-bs-bde')], ['Manager/TL', g('rpt-bs-tl')], ['Month', _RPT_MONTHS[g('rpt-bs-month')]||''], ['Year', g('rpt-bs-year')] ]); var agg = _rptBSAggregate(); var hasOther = agg.other > 0; var summary = ''; var rowsHTML = ''; agg.list.forEach(function(e) { var pct = e.total>0 ? Math.round(e.withLL/e.total*100) : 0; rowsHTML += ''+ ''+_rptEsc(e.name)+''+_rptEsc(e.tl)+''+ ''+e.withLL+''+ ''+e.withoutLL+''+ (hasOther ? ''+e.other+'' : '')+ ''+e.total+''+ ''+pct+'%'+ ''; }); rowsHTML += 'TOTAL ('+agg.list.length+' BDEs)'+ ''+agg.withLL+''+ ''+agg.withoutLL+''+ (hasOther ? ''+agg.other+'' : '')+ ''+agg.total+''+ ''+(agg.total>0?Math.round(agg.withLL/agg.total*100):0)+'%'; var table = ''+ ''+ (hasOther ? '' : '')+ ''+rowsHTML+'

BDE	TL/Manager	Booking with LL	Booking without LL	Other	Total	% with LL

'; _rptPrintPDF({ title:'Booking Status Report', landscape:false, filters:filters, summaryHTML:summary, tableHTML:table, count:_rptBSCases.length }); }; window.rptLoadPay = function() { var month = (document.getElementById('rpt-pay-month')||{}).value||''; var vert = (document.getElementById('rpt-pay-vertical')||{}).value||''; var out = document.getElementById('rpt-pay-out'); if (!month) { toast('Select a month.','error'); return; } _rptGenerated.pay = true; if(out) out.innerHTML=''; call('getPayrollSummaryCRM', [month, CRM.user], function(err, res) { if (err||!res||!res.success) { if(out) out.innerHTML=''; return; } _rptPayData = res; _rptRenderPay(res, vert); }, true); }; function _rptRenderPay(res, vertFilter) { var out = document.getElementById('rpt-pay-out'); if (!out) return; var s = res.summary||{}; function ss(id,v){ var el=document.getElementById(id); if(el) el.textContent=v; } ss('rpt-pay-total', s.total||0); ss('rpt-pay-netpay', 'AED '+(Number(s.totalNetPay||0)).toLocaleString()); ss('rpt-pay-comm', 'AED '+(Number(s.totalCommission||0)).toLocaleString()); ss('rpt-pay-ack', (s.acknowledged||0)+'/'+(s.total||0)); var records = (res.records||[]).filter(function(r){ return !vertFilter || r.Vertical===vertFilter; }); if (!records.length) { out.innerHTML=''; return; } var html = ''; out.innerHTML = html; } window.rptExportPay = function() { var month = (document.getElementById('rpt-pay-month')||{}).value||''; if (!month) { toast('Select a month first.','error'); return; } call('exportPayrollCRM', [month, CRM.user], function(err, res) { if (err||!res||!res.success) { toast('Export failed.','error'); return; } _rptDownloadCSV(res.csv, res.filename||('Payroll_'+month+'.csv')); toast(res.count+' records exported.','success'); }); }; function _rptDownloadCSV(csv, filename) { var blob = new Blob([csv], {type:'text/csv;charset=utf-8;'}); var a = document.createElement('a'); a.href = URL.createObjectURL(blob); a.download = filename; document.body.appendChild(a); a.click(); document.body.removeChild(a); } })();