{/* Chart area */}

{/* Hairline grid */} {[0,.25,.5,.75,1].map((t,gi) => (

))} {/* Bar groups */}

{data.map((d, i) => { const pPct = (d.purchased||0) / maxV; const sPct = (d.sold||0) / maxV; const isHov = hovered === i; const isSel = selected === i; const isDim = (hovered !== null && !isHov) || (selected !== null && !isSel); const delay = `${i * 65}ms`; const lift = isHov || isSel ? 'translateY(-3px)' : 'translateY(0)'; return (

handleEnter(i,d,e)} onMouseMove={e=>handleMove(i,d,e)} onMouseLeave={handleLeave} onClick={()=>handleClick(i,d)} >

{/* Purchase bar */}

{pPct > 0 &&

}

{/* Sale bar */}

{sPct > 0 &&

}

); })}

{/* X-axis labels */}

{data.map((d,i) => (

handleClick(i,d)} onMouseEnter={e=>handleEnter(i,d,e)} onMouseLeave={handleLeave} >{d.name}

))}

{/* Premium tooltip */} {tooltip && hovered !== null && (() => { const cW = containerRef.current ? containerRef.current.offsetWidth : 300; const tipW = 172; const tx = Math.min(Math.max(tooltip.x - tipW/2, 4), cW - tipW - 4); const ty = Math.max(tooltip.y - 110, 2); const td = tooltip.d; const contrib = totalQty > 0 ? (((td.purchased||0)+(td.sold||0))/totalQty*100).toFixed(1) : '0.0'; return (

{td.name}

Purchase {window.formatQuantity((td.purchased||0))} T

Sale {window.formatQuantity((td.sold||0))} T

Contribution {contrib}%

); })()}

); } // ── Clickable KPI Card ──────────────────────────────────── function DKPICard({ label, value, sub, color, onClick }) { const accentColor = color || 'var(--or)'; const iconName = window.KPI_ICON_MAP && window.KPI_ICON_MAP[label]; const bgTint = window.getIconBg ? window.getIconBg(accentColor) : 'rgba(249,115,22,0.07)'; return (

{window.LucideIcon && iconName && (

)}

{label}

{value}

{sub &&

{sub}

}

); } // ── Mini Progress Bar ───────────────────────────────────── function DashMiniBar({ value, max, color }) { const pct = max > 0 ? Math.min(100, Math.max(0, (value / max) * 100)) : 0; return ( ); } // ── Material Analytics Modal ────────────────────────────── function MaterialAnalyticsModal({ mat, purchases, sales, onClose }) { const C = window.fmtCur, fmt = n => Number(n||0).toFixed(3); const [tab, setTab] = dSt('overview'); const matP = dMemo(() => purchases.filter(p => (p.items||[]).some(i => i.materialId === mat.id)), [purchases, mat.id]); const matS = dMemo(() => sales.filter(s => s.materialId === mat.id), [sales, mat.id]); const pQty = matP.reduce((s,p) => s + (p.items||[]).filter(i=>i.materialId===mat.id).reduce((a,i)=>a+(parseFloat(i.quantity)||0),0), 0); const sQty = matS.reduce((s,o) => s + (parseFloat(o.quantity)||0), 0); const rev = matS.reduce((s,o) => s + (window.gAmt(o)), 0); const cost = matP.reduce((s,p) => s + (p.items||[]).filter(i=>i.materialId===mat.id).reduce((a,i)=>a+(parseFloat(i.quantity)||0)*(parseFloat(i.ratePerTon)||0),0), 0); const profit = rev - cost; const ppt = sQty > 0 ? Math.round(profit / sQty) : 0; const byCust = dMemo(() => { const m={}; matS.forEach(s=>{ const k=Store.name('customers',s.customerId)||'Unknown'; if(!m[k])m[k]={name:k,qty:0,rev:0,orders:0}; m[k].qty+=parseFloat(s.quantity)||0; m[k].rev+=window.gAmt(s); m[k].orders++; }); return Object.values(m).sort((a,b)=>b.qty-a.qty); }, [matS]); const byVend = dMemo(() => { const m={}; matP.forEach(p=>{ const k=Store.name('vendors',p.vendorId)||'Unknown'; if(!m[k])m[k]={name:k,qty:0,orders:0}; (p.items||[]).filter(i=>i.materialId===mat.id).forEach(i=>{m[k].qty+=parseFloat(i.quantity)||0;m[k].orders++;}); }); return Object.values(m).sort((a,b)=>b.qty-a.qty); }, [matP]); const byVeh = dMemo(() => { const m={}; [...matP,...matS].forEach(r=>{ const k=r.vehicleFull||''; if(!k) return; if(!m[k])m[k]={name:k,trips:0,qty:0}; m[k].trips++; m[k].qty += r.items ? (r.items||[]).filter(i=>i.materialId===mat.id).reduce((s,i)=>s+(parseFloat(i.quantity)||0),0) : (parseFloat(r.quantity)||0); }); return Object.values(m).sort((a,b)=>b.trips-a.trips); }, [matP, matS]); const trend = dMemo(() => { const m={}; matP.forEach(p=>{ const mo=(p.date||'').slice(0,7); if(!mo) return; if(!m[mo])m[mo]={month:mo,purchased:0,sold:0}; m[mo].purchased+=(p.items||[]).filter(i=>i.materialId===mat.id).reduce((s,i)=>s+(parseFloat(i.quantity)||0),0); }); matS.forEach(s=>{ const mo=(s.date||'').slice(0,7); if(!mo) return; if(!m[mo])m[mo]={month:mo,purchased:0,sold:0}; m[mo].sold+=parseFloat(s.quantity)||0; }); return Object.values(m).sort((a,b)=>a.month.localeCompare(b.month)); }, [matP, matS]); const challans = dMemo(() => { const rows=[]; matP.forEach(p=>rows.push({date:p.date,type:'Purchase',challan:p.challanNumber||'—',vehicle:p.vehicleFull||'—',party:Store.name('vendors',p.vendorId)||'—',qty:(p.items||[]).filter(i=>i.materialId===mat.id).reduce((s,i)=>s+(parseFloat(i.quantity)||0),0)})); matS.forEach(s=>rows.push({date:s.date,type:'Sale',challan:s.challanNumber||'—',vehicle:s.vehicleFull||'—',party:Store.name('customers',s.customerId)||'—',qty:parseFloat(s.quantity)||0})); return rows.sort((a,b)=>(b.date||'').localeCompare(a.date||'')); }, [matP, matS]); const TABS = ['overview','customers','vendors','vehicles','challans','trend']; return ( =0?'var(--ok)':'var(--err)'],['Revenue',C(rev),'var(--ok)'],['Gross Profit',C(profit),profit>=0?'var(--ok)':'var(--err)'],['₹/Ton',C(ppt),ppt>=0?'var(--ok)':'var(--err)']]}/>

{TABS.map(t => )}

{tab === 'overview' &&

v.toFixed(3)},{k:'rev',h:'Revenue',r:true,cl:'var(--ok)',f:v=>C(v)},{k:'orders',h:'Orders',r:true}]}/>v.toFixed(3)},{k:'orders',h:'Orders',r:true}]}/>

} {tab === 'customers' && v.toFixed(3)},{k:'rev',h:'Revenue',r:true,cl:'var(--ok)',f:v=>C(v)},{k:'orders',h:'Orders',r:true}]} maxH={420}/>} {tab === 'vendors' && v.toFixed(3)},{k:'orders',h:'Orders',r:true}]} maxH={420}/>} {tab === 'vehicles' && v.toFixed(3)}]} maxH={420}/>} {tab === 'challans' && window.fmtDate(v)},{k:'type',h:'Type'},{k:'challan',h:'Challan No.',mono:true},{k:'vehicle',h:'Vehicle',mono:true},{k:'party',h:'Party'},{k:'qty',h:'Qty (T)',r:true,b:true,f:v=>v.toFixed(3)}]} maxH={420}/>} {tab === 'trend' && v.toFixed(3)},{k:'sold',h:'Sold (T)',r:true,cl:'var(--info)',f:v=>v.toFixed(3)}]}/>} ); } // ── Balance Drill Modal ─────────────────────────────────── function BalanceDrillModal({ materials, purchases, sales, onClose }) { const fmt = n => Number(n||0).toFixed(3); const rows = dMemo(() => materials.map(m => { const pQty = purchases.reduce((s,p) => s+(p.items||[]).filter(i=>i.materialId===m.id).reduce((a,i)=>a+(parseFloat(i.quantity)||0),0), 0); const sQty = sales.filter(s=>s.materialId===m.id).reduce((s,o)=>s+(parseFloat(o.quantity)||0), 0); return { name: m.name, purchased: pQty, sold: sQty, balance: pQty-sQty }; }).filter(r => r.purchased > 0 || r.sold > 0).sort((a,b) => b.balance - a.balance), [materials, purchases, sales]); return ( s+r.purchased,0))+' T','var(--info)'],['Total Sold',fmt(rows.reduce((s,r)=>s+r.sold,0))+' T','var(--ok)'],['Net Balance',fmt(rows.reduce((s,r)=>s+r.balance,0))+' T','var(--txt)']]}/> v.toFixed(3)},{k:'sold',h:'Sold (T)',r:true,cl:'var(--info)',f:v=>v.toFixed(3)},{k:'balance',h:'Balance (T)',r:true,b:true,f:v=>v.toFixed(3)}]} maxH={360}/> ); } // ── Customer Intel Card ─────────────────────────────────── function CustomerIntelCard({ sales, onCustomerClick }) { const C = window.fmtCur; const rows = dMemo(() => { const m={}; sales.forEach(s=>{ const k=s.customerId; if(!k) return; if(!m[k])m[k]={id:k,name:Store.name('customers',k)||k,rev:0,qty:0,orders:0,lastDate:''}; m[k].rev+=window.gAmt(s); m[k].qty+=parseFloat(s.quantity)||0; m[k].orders++; if(!m[k].lastDate||(s.date||'')>m[k].lastDate)m[k].lastDate=s.date||''; }); return Object.values(m).sort((a,b)=>b.rev-a.rev); }, [sales]); const totalRev = rows.reduce((s,r)=>s+r.rev, 0); return (

Customer Intelligence

onCustomerClick('all')}>All {rows.length} →

{rows.length === 0 ?

No sales data in period

: rows.slice(0,6).map(cu => { const pct = totalRev > 0 ? cu.rev/totalRev*100 : 0; return (

onCustomerClick(cu)} onMouseEnter={e=>e.currentTarget.style.background='#F5F3FF'} onMouseLeave={e=>e.currentTarget.style.background=''}>

{cu.name} {pct.toFixed(1)}%

{C(cu.rev)} · {window.formatQuantity(cu.qty)} T · {cu.orders} orders

); }) }

); } // ── Customer Full Drill Modal ───────────────────────────── function CustomerFullModal({ customer, sales, onClose }) { const C = window.fmtCur; const cuSales = customer === 'all' ? sales : sales.filter(s => s.customerId === customer.id); const byMat = dMemo(() => { const m={}; cuSales.forEach(s=>{ const k=Store.name('materials',s.materialId)||'Unknown'; if(!m[k])m[k]={name:k,qty:0,rev:0,orders:0}; m[k].qty+=parseFloat(s.quantity)||0; m[k].rev+=window.gAmt(s); m[k].orders++; }); return Object.values(m).sort((a,b)=>b.rev-a.rev); }, [cuSales]); const rows = dMemo(() => [...cuSales].sort((a,b)=>(b.date||'').localeCompare(a.date||'')).map(s=>({date:s.date,customer:Store.name('customers',s.customerId)||'—',material:Store.name('materials',s.materialId)||'—',vehicle:s.vehicleFull||'—',transporter:s.transporter||'—',challan:s.challanNumber||'—',qty:parseFloat(s.quantity)||0,rate:s.ratePerTon||s.rate||0,total:window.gAmt(s)})), [cuSales]); const totalRev = cuSales.reduce((s,o)=>s+(window.gAmt(o)),0), totalQty = cuSales.reduce((s,o)=>s+(parseFloat(o.quantity)||0),0); return ( 0?C(Math.round(totalRev/cuSales.length)):'—','var(--txt)']]}/> v.toFixed(3)},{k:'rev',h:'Revenue',r:true,cl:'#7C3AED',f:v=>C(v)},{k:'orders',h:'Orders',r:true}]}/> window.fmtDate(v)},{k:'customer',h:'Customer'},{k:'material',h:'Material'},{k:'vehicle',h:'Vehicle',mono:true},{k:'transporter',h:'Transporter'},{k:'challan',h:'Challan',mono:true},{k:'qty',h:'Qty (T)',r:true,f:v=>v.toFixed(3)},{k:'rate',h:'Rate/T',r:true,f:v=>C(v)},{k:'total',h:'Amount',r:true,b:true,cl:'#7C3AED',f:v=>C(v)}]} maxH={360}/> ); } // ── Vendor Intel Card ───────────────────────────────────── function VendorIntelCard({ purchases, onVendorClick }) { const C = window.fmtCur; const rows = dMemo(() => { const m={}; purchases.forEach(p=>{ const k=p.vendorId; if(!k) return; if(!m[k])m[k]={id:k,name:Store.name('vendors',k)||k,cost:0,qty:0,orders:0}; m[k].cost+=window.gAmt(p); m[k].qty+=(p.items||[]).reduce((s,i)=>s+(parseFloat(i.quantity)||0),0); m[k].orders++; }); return Object.values(m).sort((a,b)=>b.qty-a.qty); }, [purchases]); const totalQty = rows.reduce((s,r)=>s+r.qty, 0); return (

Vendor Intelligence

onVendorClick('all')}>All {rows.length} →

{rows.length === 0 ?

No purchase data in period

: rows.slice(0,6).map(v => { const pct = totalQty > 0 ? v.qty/totalQty*100 : 0; return (

onVendorClick(v)} onMouseEnter={e=>e.currentTarget.style.background='#FFFBEB'} onMouseLeave={e=>e.currentTarget.style.background=''}>

{v.name} {pct.toFixed(1)}%

{window.formatQuantity(v.qty)} T · {C(v.cost)} · {v.orders} orders

); }) }

); } // ── Vendor Full Drill Modal ─────────────────────────────── function VendorFullModal({ vendor, purchases, onClose }) { const C = window.fmtCur; const vP = vendor === 'all' ? purchases : purchases.filter(p => p.vendorId === vendor.id); const byMat = dMemo(() => { const m={}; vP.forEach(p=>(p.items||[]).forEach(i=>{ const k=Store.name('materials',i.materialId)||'Unknown'; if(!m[k])m[k]={name:k,qty:0,cost:0}; m[k].qty+=parseFloat(i.quantity)||0; m[k].cost+=(parseFloat(i.quantity)||0)*(parseFloat(i.ratePerTon)||0); })); return Object.values(m).sort((a,b)=>b.qty-a.qty); }, [vP]); const rows = dMemo(() => [...vP].sort((a,b)=>(b.date||'').localeCompare(a.date||'')).map(p=>({date:p.date,vendor:Store.name('vendors',p.vendorId)||'—',vehicle:p.vehicleFull||'—',challan:p.challanNumber||'—',qty:(p.items||[]).reduce((s,i)=>s+(parseFloat(i.quantity)||0),0),total:window.gAmt(p)})), [vP]); const totalQty = rows.reduce((s,r)=>s+r.qty,0), totalCost = rows.reduce((s,r)=>s+r.total,0); return ( v.toFixed(3)},{k:'cost',h:'Est. Cost',r:true,cl:'#B45309',f:v=>C(v)}]}/> window.fmtDate(v)},{k:'vendor',h:'Vendor'},{k:'vehicle',h:'Vehicle',mono:true},{k:'challan',h:'Challan',mono:true},{k:'qty',h:'Qty (T)',r:true,f:v=>v.toFixed(3)},{k:'total',h:'Amount',r:true,b:true,cl:'#B45309',f:v=>C(v)}]} maxH={360}/> ); } // ── Transport Intel Card ────────────────────────────────── function TransportIntelCard({ purchases, sales, onVehicleClick, onTransporterClick }) { const { vehRows, transRows, totalTrips } = dMemo(() => { const vehs = {}, trans = {}; const _rt = r => { const tId = r.transporterId || r.transporterMasterId || null; const tDisp = (r.transporter && r.transporter !== '—') ? r.transporter : (r.transporterName && r.transporterName !== '—') ? r.transporterName : null; const tKey = tId || tDisp; if (!tKey) return null; return tDisp || (tId ? (Store.name('transportersList', tId)||tId) : tKey); }; [...purchases, ...sales].forEach(r => { if (r.vehicleFull) { if(!vehs[r.vehicleFull])vehs[r.vehicleFull]={name:r.vehicleFull,trips:0,qty:0}; vehs[r.vehicleFull].trips++; vehs[r.vehicleFull].qty += r.items?(r.items||[]).reduce((s,i)=>s+(parseFloat(i.quantity)||0),0):(parseFloat(r.quantity)||0); } const _tName2 = _rt(r); if (_tName2) { if(!trans[_tName2])trans[_tName2]={name:_tName2,trips:0,qty:0,vehs:new Set()}; trans[_tName2].trips++; trans[_tName2].qty += r.items?(r.items||[]).reduce((s,i)=>s+(parseFloat(i.quantity)||0),0):(parseFloat(r.quantity)||0); if(r.vehicleFull)trans[_tName2].vehs.add(r.vehicleFull); } }); return { vehRows: Object.values(vehs).sort((a,b)=>b.trips-a.trips), transRows: Object.values(trans).map(r=>({...r,vehs:r.vehs.size})).sort((a,b)=>b.trips-a.trips), totalTrips: purchases.length+sales.length }; }, [purchases, sales]); return (

Transport Intelligence

{totalTrips} total trips

onVehicleClick('all')}>

Active Vehicles

{vehRows.length}

{vehRows[0]&&

Top: {vehRows[0].name}

}

onTransporterClick('all')}>

Transporters

{transRows.length}

{transRows[0]&&

Top: {transRows[0].name}

}

TOP VEHICLES

{vehRows.slice(0,5).map(v => (

onVehicleClick(v)} onMouseEnter={e=>e.currentTarget.style.background='#EFF6FF'} onMouseLeave={e=>e.currentTarget.style.background=''}> {v.name} {v.trips} trips · {window.formatQuantity(v.qty)} T

))} {vehRows.length === 0 &&

No transport data in period

}

); } // ── Transport Full Drill Modal ──────────────────────────── function TransportFullModal({ mode, filter, purchases, sales, onClose }) { const C = window.fmtCur; const allRecs = dMemo(() => { const rows = []; const _resolveT = r => { if (r.transporter && r.transporter !== '—') return r.transporter; if (r.transporterName && r.transporterName !== '—') return r.transporterName; if (r.transporterId) return Store.name('transportersList', r.transporterId) || r.transporterId; if (r.transporterMasterId) return Store.name('transportersList', r.transporterMasterId) || r.transporterMasterId; return '—'; }; purchases.forEach(p => (p.items||[]).forEach(i => rows.push({date:p.date,type:'Purchase',vehicle:p.vehicleFull||'—',transporter:_resolveT(p),material:Store.name('materials',i.materialId)||'—',challan:p.challanNumber||'—',party:Store.name('vendors',p.vendorId)||'—',qty:parseFloat(i.quantity)||0}))); sales.forEach(s => rows.push({date:s.date,type:'Sale',vehicle:s.vehicleFull||'—',transporter:_resolveT(s),material:Store.name('materials',s.materialId)||'—',challan:s.challanNumber||'—',party:Store.name('customers',s.customerId)||'—',qty:parseFloat(s.quantity)||0})); if (mode === 'vehicle' && filter !== 'all') return rows.filter(r => r.vehicle === filter.name); if (mode === 'transporter' && filter !== 'all') return rows.filter(r => r.transporter === filter.name); return rows; }, [purchases, sales, mode, filter]); const sorted = dMemo(() => [...allRecs].sort((a,b)=>(b.date||'').localeCompare(a.date||'')), [allRecs]); const vehSum = dMemo(() => { const m={}; allRecs.forEach(r=>{ if(r.vehicle==='—') return; if(!m[r.vehicle])m[r.vehicle]={name:r.vehicle,trips:0,qty:0}; m[r.vehicle].trips++; m[r.vehicle].qty+=r.qty; }); return Object.values(m).sort((a,b)=>b.trips-a.trips); }, [allRecs]); const totalQty = allRecs.reduce((s,r)=>s+r.qty,0); const title = mode==='vehicle'?(filter==='all'?'All Vehicles':`${filter.name}`):mode==='transporter'?(filter==='all'?'All Transporters':`${filter.name}`):'Transport Overview'; return ( 0?(totalQty/allRecs.length).toFixed(3)+' T':'—','var(--txt)']]}/> {(mode==='all'||(mode==='vehicle'&&filter==='all')) && v.toFixed(3)}]} maxH={180}/>} window.fmtDate(v)},{k:'type',h:'Type'},{k:'vehicle',h:'Vehicle',mono:true},{k:'transporter',h:'Transporter'},{k:'material',h:'Material'},{k:'party',h:'Party'},{k:'challan',h:'Challan',mono:true},{k:'qty',h:'Qty (T)',r:true,f:v=>v.toFixed(3)}]} maxH={380}/> ); } // ── Expandable Activity Row ─────────────────────────────── function ExpandableRow({ item, type, cols }) { const [open, setOpen] = dSt(false); return ( <> setOpen(o => !o)} onMouseEnter={e=>e.currentTarget.style.background='#FAFAFA'} onMouseLeave={e=>e.currentTarget.style.background=''}> {cols.map((col, ci) => ( {col.render ? col.render(item) : (item[col.key]||'—')} ))} {open ? '▲' : '▼'} {open && ( )} ); } // ── Main Dashboard Page ─────────────────────────────────── function DashboardPage() { const { companyId, navigate } = dCtx(window.AppCtx); const [preset, setPreset] = dSt('month'); const [cFrom, setCFrom] = dSt(''); const [cTo, setCTo] = dSt(''); const [tab, setTab] = dSt('purchase'); const [drill, setDrill] = dSt(null); const [, setTick] = dSt(0); dEf(() => { const unsub = Store.on(() => setTick(t => t+1)); return unsub; }, []); const range = dMemo(() => getRange(preset, cFrom, cTo), [preset, cFrom, cTo]); const allPurchases = Store.all('purchases', companyId); const allSales = Store.all('salesOrders', companyId); const allMaterials = Store.all('materials', companyId); const purchases = dMemo(() => allPurchases.filter(p => inRange(p.date, range.from, range.to)), [allPurchases, range]); const sales = dMemo(() => allSales.filter(s => inRange(s.date, range.from, range.to)), [allSales, range]); const allTransport = Store.all('transportEntries', companyId); const allDiesel = Store.all('dieselRecords', companyId); const allDebris = Store.all('debrisMovements', companyId); const transport = dMemo(() => allTransport.filter(t => inRange(t.date, range.from, range.to)), [allTransport, range]); const diesel = dMemo(() => allDiesel.filter(d => inRange(d.date || d.periodStart, range.from, range.to)), [allDiesel, range]); // Debris Movement is a genuine commercial sale — Smart Revenue Engine (profit-engine.js) // folds it into every Revenue figure below via PE.revenue()/PE.method1()/PE.method2(). const debris = dMemo(() => allDebris.filter(d => inRange(d.date, range.from, range.to)), [allDebris, range]); // ── Data-health gate: a load failure on `purchases` must never be presented // as "0 purchases" — Store already quarantines/locks the collection instead // of deleting it (see erp/store.js), but every KPI below still read the // resulting empty array with no check. That silent conversion — read error // → [] → ₹0 — is the defect: this flag and the uv()/uvSub() helpers stop it // from reaching the screen. const purchLoadState = (Store.loadState && Store.loadState('purchases')) || { state: 'OK' }; const purchasesUnavailable = purchLoadState.state === 'ERROR' || purchLoadState.state === 'BLOCKED'; // Phase 6 (REPORTS/27): purchases now hydrates in the background in // staging — distinct from ERROR/BLOCKED, this resolves itself within // moments via the existing Store.on() re-render, so it must not say // "UNAVAILABLE" (which implies Data Health recovery is needed). const purchasesLoading = purchLoadState.state === 'LOADING'; const uv = (v) => purchasesUnavailable ? 'UNAVAILABLE' : purchasesLoading ? 'Loading…' : v; const uvSub = (s) => purchasesUnavailable ? 'Recovery required — see Data Health' : purchasesLoading ? 'Purchase data is still loading' : s; // ── Qty KPIs ───────────────────────────────────────────── const totalPQty = dMemo(() => purchases.reduce((s,p) => s+(p.items||[]).reduce((a,i)=>a+(parseFloat(i.quantity)||0),0), 0), [purchases]); const totalSQty = dMemo(() => sales.reduce((s,o) => s+(parseFloat(o.quantity)||0), 0), [sales]); const balance = totalPQty - totalSQty; const variance = totalPQty > 0 ? ((balance/totalPQty)*100).toFixed(2) : '0.00'; // ── Financial KPIs ──────────────────────────────────────── // Single Source of Truth: routed through window.ProfitEngine — the same // engine every other dashboard/report in the ERP reads. "Gross Profit" // (Revenue − Purchase Cost) is a simple sub-metric; "Net Profit" is the // one authoritative bottom-line figure (Method 1, GST-incl.) and matches // the Group Dashboard / Executive Dashboard exactly for this company. const PE = window.ProfitEngine; const totalRev = dMemo(() => PE.revenue({ sales, debris }, 'incl'), [sales, debris]); const totalCost = dMemo(() => PE.purchAmt(purchases, 'incl'), [purchases]); const grossProfit = totalRev - totalCost; const margin = totalRev > 0 ? (grossProfit/totalRev*100).toFixed(1) : '0.0'; const peM1 = dMemo(() => PE.method1({ sales, purchases, transport, diesel, debris, gstMode: 'incl' }), [sales, purchases, transport, diesel, debris]); const netProfit = peM1.netProfit; const ppt = totalSQty > 0 ? Math.round(netProfit/totalSQty) : 0; // ── NEW: Material Turnover Rate ────────────────────────────────────────── const matTurnoverRate = totalPQty > 0 ? (totalSQty/totalPQty*100).toFixed(1) : '0.0'; // ── Transporter resolver — handles both field-name conventions: // purchases use: transporterMasterId (ID) + transporterName (display) // sales / transport entries use: transporterId (ID) + transporter (display) // Returns { tKey, tName } — tKey is null if no transporter info found. function _resolveTransporter(r) { const tId = r.transporterId || r.transporterMasterId || null; const tDisp = (r.transporter && r.transporter !== '—') ? r.transporter : (r.transporterName && r.transporterName !== '—') ? r.transporterName : null; const tKey = tId || tDisp; if (!tKey) return { tKey: null, tName: null }; const tName = tDisp || (tId ? (Store.name('transportersList', tId) || tId) : tKey); return { tKey, tName }; } // ── Operational KPIs ────────────────────────────────────── const { totalTrips, activeVehicles, activeTransporters, topVehicle, topTransporter, avgTripSize, _dbgTrips } = dMemo(() => { const vehs = {}, trans = {}; const dbg = []; [...purchases, ...sales].forEach(r => { const src = r.items ? 'Purchase' : 'Sale'; if (r.vehicleFull) vehs[r.vehicleFull] = (vehs[r.vehicleFull]||0)+1; const { tKey, tName } = _resolveTransporter(r); if (tKey && tName) trans[tName] = (trans[tName]||0)+1; dbg.push({ id: r.id||'?', co: r.companyId||'?', src, veh: r.vehicleFull||'—', tId: r.transporterId||r.transporterMasterId||'—', tRaw: r.transporter||r.transporterName||'—', tResolved: tName||'—', countsTrip: true, countsVeh: !!r.vehicleFull, countsTrans: !!(tKey && tName), }); }); const vA = Object.entries(vehs).sort((a,b)=>b[1]-a[1]); const tA = Object.entries(trans).sort((a,b)=>b[1]-a[1]); return { totalTrips: purchases.length + sales.length, activeVehicles: vA.length, activeTransporters: tA.length, topVehicle: vA[0]?.[0]||'—', topTransporter: tA[0]?.[0]||'—', avgTripSize: sales.length > 0 ? totalSQty/sales.length : 0, _dbgTrips: dbg, }; }, [purchases, sales, totalSQty]); // ── Revenue per Trip (computed AFTER totalTrips is defined) ─────────── const revPerTrip = totalTrips > 0 ? totalRev/totalTrips : 0; // ── Top Material ────────────────────────────────────────── const topMat = dMemo(() => { const m={}; sales.forEach(s=>{ if(s.materialId) m[s.materialId]=(m[s.materialId]||0)+(parseFloat(s.quantity)||0); }); const top = Object.entries(m).sort((a,b)=>b[1]-a[1])[0]; if (!top) return null; const mat = Store.byId('materials', top[0]); return { id:top[0], name:mat?.name||top[0], qty:top[1] }; }, [sales]); // ── Top 5 Materials by Revenue ──────────────────────────── const top5Mats = dMemo(() => { const m={}; sales.forEach(s=>{ if(!s.materialId) return; if(!m[s.materialId])m[s.materialId]={id:s.materialId,name:Store.name('materials',s.materialId)||s.materialId,qty:0,rev:0}; m[s.materialId].qty+=parseFloat(s.quantity)||0; m[s.materialId].rev+=window.gAmt(s); }); return Object.values(m).sort((a,b)=>b.rev-a.rev).slice(0,5); }, [sales]); // ── Chart Data ──────────────────────────────────────────── const matChartData = dMemo(() => allMaterials.map(m => { const pQ = purchases.reduce((s,p) => s+(p.items||[]).filter(i=>i.materialId===m.id).reduce((a,i)=>a+(parseFloat(i.quantity)||0),0), 0); const sQ = sales.filter(s=>s.materialId===m.id).reduce((s,o)=>s+(parseFloat(o.quantity)||0), 0); return { id:m.id, name:m.name, purchased:pQ, sold:sQ }; }).filter(d => d.purchased>0 || d.sold>0), [allMaterials, purchases, sales]); // ── Recent Activity ─────────────────────────────────────── const recentP = purchases.slice().sort((a,b)=>b.date.localeCompare(a.date)).slice(0,15); const recentS = sales.slice().sort((a,b)=>b.date.localeCompare(a.date)).slice(0,15); const C = window.fmtCur; const fmt = n => Number(n||0).toFixed(3); const openDrill = (type, data) => setDrill({ type, data }); const closeDrill = () => setDrill(null); const PRESETS = [ {id:'today',label:'Today'},{id:'yesterday',label:'Yesterday'}, {id:'week',label:'This Week'},{id:'month',label:'This Month'},{id:'custom',label:'Custom'}, ]; const pCols = [ {key:'sr', render:(p,i)=>{i+1}}, {key:'ch', render:p=>{p.challanNumber||'—'}}, {key:'veh', render:p=>{p.vehicleFull||'—'}}, {key:'mat', render:p=>{(p.items?.[0]?.materialId)?Store.name('materials',p.items[0].materialId):Store.name('materials',p.materialId)}}, {key:'vnd', render:p=>{Store.name('vendors',p.vendorId)||'—'}}, {key:'dt', render:p=>{window.fmtDate(p.date)}}, {key:'qty', render:p=>{fmt((p.items||[]).reduce((s,i)=>s+(parseFloat(i.quantity)||0),0))} MT}, {key:'amt', render:p=>{C(window.gAmt(p))}}, ]; const sCols = [ {key:'sr', render:(s,i)=>{i+1}}, {key:'ch', render:s=>{s.challanNumber||'—'}}, {key:'veh', render:s=>{s.vehicleFull||'—'}}, {key:'mat', render:s=>{Store.name('materials',s.materialId)||'—'}}, {key:'cust', render:s=>{Store.name('customers',s.customerId)||'—'}}, {key:'dt', render:s=>{window.fmtDate(s.date)}}, {key:'qty', render:s=>{fmt(s.quantity)} {s.uom||'MT'}}, {key:'amt', render:s=>{C(window.gAmt(s))}}, ]; return (

{/* Header */}

{Store.currentCompany?.name} Dashboard

Operational Intelligence — {Store.currentCompany?.name}

{/* Date Filter */}

{PRESETS.map(p => ( ))} {preset==='custom' && <> setCFrom(e.target.value)} style={{height:28,fontSize:11.5,width:130,padding:'3px 7px'}}/> to setCTo(e.target.value)} style={{height:28,fontSize:11.5,width:130,padding:'3px 7px'}}/> }

{range.from && {window.fmtDate(range.from)}{range.from!==range.to?` — ${window.fmtDate(range.to)}`:''}}

{purchasesUnavailable && (

Purchase data unavailable — recovery required. Storage could not load the purchases collection ({(purchLoadState.detail && purchLoadState.detail.reason) || 'write blocked by fail-safe'}). Nothing has been deleted — the records are locked against overwriting. Purchase Cost, Gross Profit, Net Profit and Purchased tonnage below exclude purchases and are not shown as ₹0/zero.

)} {/* ── Material Intelligence KPI Cards ── */}

Material Intelligence

=0?'var(--ok)':'var(--err)')} onClick={()=>openDrill('balance',null)}/> openDrill('purchased',null)}/> openDrill('sold',null)}/> =0?'var(--ok)':'var(--err)')} onClick={()=>openDrill('balance',null)}/> topMat&&openDrill('material',{matId:topMat.id})}/> openDrill('matTurnover',null)}/>

{/* ── Business Intelligence ── */}

Business Intelligence

{/* Financial KPIs */}

openDrill('sold',null)}/> openDrill('purchased',null)}/> =0?'var(--ok)':'var(--err)')} onClick={()=>openDrill('profit',null)}/> =0?'var(--ok)':'var(--err)')} onClick={()=>openDrill('netProfit',null)}/> =10?'var(--ok)':'var(--err)'} onClick={()=>openDrill('profit',null)}/> =0?'var(--ok)':'var(--err)'} onClick={()=>openDrill('profitPerTon',null)}/> openDrill('revPerTrip',null)}/>

{/* Operational KPIs */}

openDrill('transport',{mode:'all',filter:'all'})}/> openDrill('transport',{mode:'vehicle',filter:'all'})}/> openDrill('transport',{mode:'transporter',filter:'all'})}/> openDrill('transport',{mode:'vehicle',filter:{name:topVehicle}}):undefined}/> openDrill('transport',{mode:'transporter',filter:{name:topTransporter}}):undefined}/>

{/* ── Material Chart + Customer + Vendor Intel ── */}

{/* Chart + Top Materials */}

Material Qty Comparison

Purchase

Sale

openDrill('material',{matId:d.id})}/>

Click any bar to drill into material analytics

Top Materials by Revenue

{top5Mats.length === 0 ?

No sales data

: top5Mats.map((m,i)=>(

openDrill('material',{matId:m.id})} onMouseEnter={e=>e.currentTarget.style.background='var(--or-lt)'} onMouseLeave={e=>e.currentTarget.style.background=''}> {i+1} {m.name} {C(m.rev)} {window.formatQuantity(m.qty)}T

))}

openDrill('customer',cu)}/> openDrill('vendor',v)}/>

{/* ── Transport Intelligence ── */}

openDrill('transport',{mode:'vehicle',filter:v})} onTransporterClick={t=>openDrill('transport',{mode:'transporter',filter:t})}/>

{/* ── Executive Analytics ── */} {window.ExecutiveAnalyticsSection && ( )} {/* ── Recent Activity ── */}

{tab==='purchase'?recentP.length:recentS.length} entries · click row to expand

{tab === 'purchase' ? ( {recentP.length === 0 ? : recentP.map((p,i) => ({...c,render:()=>c.render(p,i)}))}/>)}

SR	CHALLAN	VEHICLE	MATERIAL	VENDOR	DATE	QTY	AMOUNT
No purchase activity in selected period

) : ( {recentS.length === 0 ? : recentS.map((s,i) => ({...c,render:()=>c.render(s,i)}))}/>)}

SR	CHALLAN	VEHICLE	MATERIAL	CUSTOMER	DATE	QTY	AMOUNT
No sales activity in selected period

)}

{/* ── Drill-Down Modals ── */} {drill && {drill?.type === 'balance' && } {drill?.type === 'purchased' && ( )} {drill?.type === 'sold' && ( )} {drill?.type === 'profit' && ( )} {drill?.type === 'profitPerTon' && ( )} {drill?.type === 'netProfit' && ( =0?'var(--ok)':'var(--err)'} onClose={closeDrill} width={1080}> )} {drill?.type === 'material' && (() => { const mat = Store.byId('materials', drill.data.matId); return mat ? : null; })()} {drill?.type === 'customer' && } {drill?.type === 'vendor' && } {drill?.type === 'transport' && } {drill?.type === 'matTurnover' && (()=>{ const mtRows=allMaterials.map(m=>{ const pQty=purchases.reduce((s,p)=>s+(p.items||[]).filter(i=>i.materialId===m.id).reduce((a,i)=>a+(parseFloat(i.quantity)||0),0),0); const sQty=sales.filter(s=>s.materialId===m.id).reduce((s,o)=>s+(parseFloat(o.quantity)||0),0); const rate=pQty>0?(sQty/pQty*100).toFixed(1):'0.0'; return {name:m.name,purchased:pQty,sold:sQty,rate:parseFloat(rate),rateDisp:rate+'%',balance:pQty-sQty}; }).filter(r=>r.purchased>0||r.sold>0).sort((a,b)=>b.rate-a.rate); const fast=mtRows.filter(r=>r.rate>=80); const slow=mtRows.filter(r=>r.rate<30); return ( =0?'var(--ok)':'var(--err)'],['Fast-Moving',fast.length,'var(--ok)'],['Slow-Moving',slow.length,'var(--warn)']]}/>

v.toFixed(3)},{k:'sold',h:'Sold (T)',r:true,f:v=>v.toFixed(3)}]}/> a.rate-b.rate)} cols={[{k:'name',h:'Material'},{k:'rateDisp',h:'Turnover %',r:true,b:true,cl:'var(--warn)'},{k:'purchased',h:'Purchased (T)',r:true,f:v=>v.toFixed(3)},{k:'sold',h:'Sold (T)',r:true,f:v=>v.toFixed(3)}]}/>

v.toFixed(3)},{k:'sold',h:'Sold (T)',r:true,f:v=>v.toFixed(3)},{k:'balance',h:'Balance (T)',r:true,f:v=>v.toFixed(3)}]} maxH={340}/> ); })()} {drill?.type === 'revPerTrip' && (()=>{ const rptAllRecs=[]; purchases.forEach(p=>(p.items||[]).forEach(i=>rptAllRecs.push({date:p.date,type:'Purchase',vehicle:p.vehicleFull||'—',transporter:p.transporter||'—',material:Store.name('materials',i.materialId)||'—',challan:p.challanNumber||'—',party:Store.name('vendors',p.vendorId)||'—',qty:parseFloat(i.quantity)||0,revenue:0}))); sales.forEach(s=>rptAllRecs.push({date:s.date,type:'Sale',vehicle:s.vehicleFull||'—',transporter:s.transporter||'—',material:Store.name('materials',s.materialId)||'—',challan:s.challanNumber||'—',party:Store.name('customers',s.customerId)||'—',qty:parseFloat(s.quantity)||0,revenue:window.gAmt(s)})); const rptByVeh=(()=>{const m={};rptAllRecs.forEach(r=>{if(r.vehicle==='—')return;if(!m[r.vehicle])m[r.vehicle]={name:r.vehicle,trips:0,qty:0,revenue:0};m[r.vehicle].trips++;m[r.vehicle].qty+=r.qty;m[r.vehicle].revenue+=r.revenue;});return Object.values(m).sort((a,b)=>b.revenue-a.revenue).map(r=>({...r,revPerTrip:r.trips>0?Math.round(r.revenue/r.trips):0}));})(); const rptByCust=(()=>{const m={};sales.forEach(s=>{const k=Store.name('customers',s.customerId)||'Unknown';if(!m[k])m[k]={name:k,trips:0,revenue:0};m[k].trips++;m[k].revenue+=window.gAmt(s);});return Object.values(m).sort((a,b)=>b.revenue-a.revenue).map(r=>({...r,revPerTrip:r.trips>0?Math.round(r.revenue/r.trips):0}));})(); const rptByMat=(()=>{const m={};sales.forEach(s=>{const k=Store.name('materials',s.materialId)||'Unknown';if(!m[k])m[k]={name:k,trips:0,revenue:0,qty:0};m[k].trips++;m[k].revenue+=window.gAmt(s);m[k].qty+=parseFloat(s.quantity)||0;});return Object.values(m).sort((a,b)=>b.revenue-a.revenue).map(r=>({...r,revPerTrip:r.trips>0?Math.round(r.revenue/r.trips):0}));})(); const rptSorted=[...rptAllRecs].sort((a,b)=>(b.date||'').localeCompare(a.date||'')); return (

C(v)},{k:'revPerTrip',h:'Rev/Trip',r:true,b:true,cl:'var(--ok)',f:v=>C(v)}]}/> C(v)},{k:'revPerTrip',h:'Rev/Trip',r:true,b:true,cl:'var(--ok)',f:v=>C(v)}]}/>

window.formatQuantity(v)},{k:'revenue',h:'Revenue',r:true,cl:'var(--ok)',f:v=>C(v)},{k:'revPerTrip',h:'Rev/Trip',r:true,b:true,cl:'var(--ok)',f:v=>C(v)}]} maxH={160}/> window.fmtDate(v)},{k:'type',h:'Type'},{k:'vehicle',h:'Vehicle',mono:true},{k:'transporter',h:'Transporter'},{k:'material',h:'Material'},{k:'party',h:'Party'},{k:'challan',h:'Challan',mono:true},{k:'qty',h:'Qty (T)',r:true,f:v=>v.toFixed(3)},{k:'revenue',h:'Revenue',r:true,b:true,cl:'var(--ok)',f:v=>C(v)}]} maxH={280}/> ); })()} }

); } window.DashboardPage = DashboardPage;