const REPORT_API='./api/index.php';
const reportCtx={csrf:'',user:null,data:null,type:'asset-trace',selectedAsset:null,filters:{search:'',kind:'All',status:'All',condition:'All',vendor:'All'}};
const reportTypes=[['asset-trace','Asset trace / item history'],['movements','Issues, returns & transfers'],['vendor','Vendor analysis'],['purchases','Purchase & payment report'],['status','Asset status & condition'],['office','Office allocation']];
const reportEsc=v=>String(v??'').replace(/[&<>"']/g,c=>({'&':'&','<':'<','>':'>','"':'"',"'":'''}[c]));
const activeReport=r=>Number(r?.active)!==0;
const reportPage=()=>document.querySelector('.breadcrumb strong')?.textContent.trim()||'';
const reportMoney=v=>new Intl.NumberFormat('en-PK',{style:'currency',currency:'PKR',maximumFractionDigits:2}).format(Number(v||0));
const reportDate=v=>v||'—';
async function reportApi(action){const r=await fetch(`${REPORT_API}?action=${action}`,{credentials:'same-origin'});const j=await r.json().catch(()=>({error:'Server returned an invalid response.'}));if(!r.ok)throw Error(j.error||'Request failed');return j;}
async function reportLoad(){const s=await reportApi('session');reportCtx.user=s.user;if(!reportCtx.user||reportCtx.user.role==='office')return false;reportCtx.data=(await reportApi('data')).data;return true;}
function officeName(id){return (reportCtx.data?.offices||[]).find(o=>Number(o.id)===Number(id))?.name||'Central store';}
function vendorName(id){return (reportCtx.data?.vendors||[]).find(v=>Number(v.id)===Number(id))?.name||'Unknown vendor';}
function assetFor(id){return (reportCtx.data?.assets||[]).find(a=>Number(a.id)===Number(id));}
function reportShell(){return `OPERATIONS INTELLIGENCE
Reports & asset trace Vendor costs, movement history, office allocation aur asset condition ek jagah.
Print report Export CSV
${reportTypes.map(([key,label])=>`${label} `).join('')}
${items.map(([label,value,detail])=>`
${label} ${value} ${detail||''}
`).join('')}
${headers.map(h=>`${h} `).join('')} ${rows||`${empty}
Search item, tag, serial or category `;if(reportCtx.type==='movements')return `Search movement or item Movement typeAll ${['Issue','Transfer','Return','Stock Issue','Stock Receive'].map(x=>`${x} `).join('')} `;if(reportCtx.type==='vendor')return `VendorAll vendors ${vendors.map(v=>`${reportEsc(v.name)} `).join('')} Search vendor `;if(reportCtx.type==='status')return `StatusAll ${['In store','Issued','Maintenance'].map(x=>`${x} `).join('')} ConditionAll ${['New','Good','Fair','Needs repair'].map(x=>`${x} `).join('')} Search category/item `;return `Search invoice, item or vendor `;}
function assetTrace(){const assets=(reportCtx.data?.assets||[]).filter(activeReport).filter(a=>{const q=reportCtx.filters.search.toLowerCase();return !q||`${a.name} ${a.tag} ${a.serial} ${a.category}`.toLowerCase().includes(q)});const rows=assets.map(a=>`${reportEsc(a.tag)} ${reportEsc(a.serial||'No serial')} ${reportEsc(a.name)} ${reportEsc(a.category)} ${reportEsc(a.status)} ${reportEsc(officeName(a.office_id))} ${reportEsc(a.condition)} ${reportDate(a.since)} SELECTED ASSET
${reportEsc(selected.name)} ${reportEsc(selected.tag)} ${reportEsc(selected.status)} Current office ${reportEsc(officeName(selected.office_id))}
Condition ${reportEsc(selected.condition)}
Category ${reportEsc(selected.category)}
Since ${reportDate(selected.since)}
Serial ${reportEsc(selected.serial||'Not recorded')}
Warranty ${reportDate(selected.warranty)}
Movement history — kis ko aur kab diya ${table(['DATE','MOVEMENT','FROM','TO','RECEIVED BY','NOTES'],movements.map(m=>`
${reportDate(m.date)} ${reportEsc(m.kind)}${reportEsc(m.reference)} ${reportEsc(officeName(m.from_office_id))} ${reportEsc(officeName(m.office_id))} ${reportEsc(m.receiver)} ${reportEsc(m.notes||'—')} `).join(''),'No issue, transfer ya return history recorded.')}
Asset register ${table(['TAG','ITEM','CATEGORY','STATUS','CURRENT OFFICE','CONDITION','SINCE'],rows,'No matching assets.')}
Row select karein taa-ke complete custody trail, receiver aur dates nazar aayen.
Issues, returns & transfers ${table(['REFERENCE','DATE','MOVEMENT','ASSET','FROM','TO','RECEIVED BY','NOTES'],rows.map(m=>`${reportEsc(m.reference)} ${reportDate(m.date)} ${reportEsc(m.kind)} ${reportEsc(assetFor(m.asset_id)?.tag||m.notes)}${reportEsc(assetFor(m.asset_id)?.name||'Stock movement')} ${reportEsc(officeName(m.from_office_id))} ${reportEsc(officeName(m.office_id))} ${reportEsc(m.receiver)} ${reportEsc(m.notes||'—')} ${reportEsc(v.name)} ${reportEsc(v.contact||'')} · ${reportEsc(v.phone||'')} ${ps.length} ${q} ${assets.length} ${reportMoney(value)} ${reportMoney(p)} ${reportMoney(value-p)}
Vendor analysis ${table(['VENDOR','PURCHASES','UNITS','ASSETS','TOTAL','PAID','BALANCE'],rows)}`;}
function purchaseReport(){const q=reportCtx.filters.search.toLowerCase();const rows=(reportCtx.data?.purchases||[]).filter(p=>!q||`${p.invoice} ${p.name} ${vendorName(p.vendor_id)} ${p.reference}`.toLowerCase().includes(q));const total=rows.reduce((s,p)=>s+Number(p.total),0),paid=rows.reduce((s,p)=>s+Number(p.paid),0),tax=rows.reduce((s,p)=>s+Number(p.tax),0);reportCtx.csv=[['Reference','Invoice','Date','Item','Vendor','Quantity','Tax %','Discount','Total','Paid','Balance'],...rows.map(p=>[p.reference,p.invoice,p.date,p.name,vendorName(p.vendor_id),p.quantity,p.tax,p.discount,p.total,p.paid,Number(p.total)-Number(p.paid)])];return summaryCards([['Invoices',rows.length,'Matching purchases'],['Total',reportMoney(total),'Purchase value'],['Paid',reportMoney(paid),'Recorded payments'],['Balance',reportMoney(total-paid),'Outstanding'],['Tax rates',tax.toFixed(2)+'%','Recorded invoice rates']])+`
Purchase & payment report ${table(['REFERENCE','INVOICE','DATE','ITEM','VENDOR','QTY','TOTAL','PAID','BALANCE'],rows.map(p=>`${reportEsc(p.reference)} ${reportEsc(p.invoice)} ${reportDate(p.date)} ${reportEsc(p.name)} ${reportEsc(p.category)} ${reportEsc(vendorName(p.vendor_id))} ${p.quantity} ${reportMoney(p.total)} ${reportMoney(p.paid)} ${reportMoney(Number(p.total)-Number(p.paid))}
Asset status & condition ${table(['TAG','ITEM','CATEGORY','STATUS','CONDITION','OFFICE','VALUE'],assets.map(a=>`${reportEsc(a.tag)} ${reportEsc(a.name)} ${reportEsc(a.serial||'No serial')} ${reportEsc(a.category)} ${reportEsc(a.status)} ${reportEsc(a.condition)} ${reportEsc(officeName(a.office_id))} ${reportMoney(a.cost)} ${reportEsc(o.name)} ${reportEsc(o.code)} · ${reportEsc(o.city)} ${assets.length} ${assets.filter(a=>a.status==='Issued').length} ${assets.filter(a=>a.condition==='Needs repair').length} ${reportMoney(value)}
Office allocation ${table(['OFFICE','ASSETS','ISSUED','NEEDS REPAIR','VALUE'],rows.join(''))}`;}
function renderReport(panel){panel.querySelectorAll('.report-type-tabs button').forEach(b=>b.classList.toggle('active',b.dataset.reportType===reportCtx.type));panel.querySelector('[data-report-filters]').innerHTML=filtersFor();const renderers={'asset-trace':assetTrace,movements:movementReport,vendor:vendorReport,purchases:purchaseReport,status:statusReport,office:officeReport};panel.querySelector('[data-report-content]').innerHTML=renderers[reportCtx.type]();panel.querySelector('[data-report-summary]').innerHTML='';const summary=panel.querySelector('[data-report-content] .report-summary-grid');if(summary){panel.querySelector('[data-report-summary]').append(summary);summary.closest('.report-content')?.removeChild(summary);}}
function exportReport(){if(!reportCtx.csv?.length)return;const csv=reportCtx.csv.map(row=>row.map(v=>'"'+String(v??'').replaceAll('"','""')+'"').join(',')).join('\r\n');const a=document.createElement('a');a.href=URL.createObjectURL(new Blob(['\ufeff'+csv],{type:'text/csv;charset=utf-8'}));a.download=`assetdesk-${reportCtx.type}.csv`;a.click();setTimeout(()=>URL.revokeObjectURL(a.href),500);}
function wireReports(panel){panel.querySelector('[data-report-print]').onclick=()=>window.print();panel.querySelector('[data-report-export]').onclick=exportReport;panel.addEventListener('click',e=>{const type=e.target.closest('[data-report-type]');if(type){reportCtx.type=type.dataset.reportType;reportCtx.selectedAsset=null;renderReport(panel);return}const asset=e.target.closest('[data-report-asset]');if(asset){reportCtx.selectedAsset=asset.dataset.reportAsset;renderReport(panel);}});panel.addEventListener('input',e=>{const field=e.target.closest('[data-report-filter]');if(!field)return;reportCtx.filters[field.dataset.reportFilter]=field.value;renderReport(panel);});panel.addEventListener('change',e=>{const field=e.target.closest('[data-report-filter]');if(!field)return;reportCtx.filters[field.dataset.reportFilter]=field.value;renderReport(panel);});renderReport(panel);}
function enhanceReports(){if(!reportCtx.user||reportCtx.user.role==='office'||reportPage()!=='Reports')return;let panel=document.querySelector('[data-report-center]');if(panel)return;const old=[...document.querySelectorAll('section.card')].find(s=>s.textContent.includes('Office allocation report'));if(!old)return;document.querySelector('main > .stats')?.remove();const holder=document.createElement('div');holder.innerHTML=reportShell();panel=holder.firstElementChild;old.replaceWith(panel);wireReports(panel);}
const reportObserver=new MutationObserver(()=>requestAnimationFrame(enhanceReports));reportObserver.observe(document.body,{childList:true,subtree:true});setInterval(async()=>{if(!reportCtx.user){if(await reportLoad())enhanceReports();}else enhanceReports();},1500);reportLoad().then(enhanceReports).catch(()=>{});