<%- include('../partials/header') %>
<div class="flex ic jb mb24"><div><h2 style="font-size:20px;font-weight:700">Outstanding Report</h2></div><button onclick="window.print()" class="btn btn-outline btn-sm no-print"><i class="fa fa-print"></i> Print</button></div>
<div class="tbl-wrap mb20">
  <div class="tbl-hdr"><span class="tbl-title" style="color:var(--green)"><i class="fa fa-arrow-down"></i> Sales Receivables</span></div>
  <%if(!salesOutstanding.length){%><div class="empty" style="padding:24px"><p>No outstanding sales</p></div>
  <%}else{%><table><thead><tr><th>Invoice No.</th><th>Date</th><th>Client</th><th class="tr">Invoice Amt</th><th class="tr">Paid</th><th class="tr">Balance Due</th><th>Status</th><th>Aging</th></tr></thead>
  <tbody><%salesOutstanding.forEach(s=>{%><tr>
    <td><a href="/sales-bills/<%=s.id%>" class="cacc" style="font-family:var(--mono);font-size:12px"><%=s.invoiceNo%></a></td>
    <td class="muted sm"><%=moment(s.invoiceDate).format('DD/MM/YYYY')%></td>
    <td class="fw6"><%=s.clientName%></td>
    <td class="mono tr">₹<%=(s.netPayable||0).toFixed(2)%></td>
    <td class="mono tr cg">₹<%=(s.paidAmount||0).toFixed(2)%></td>
    <td class="mono fw6 tr cr">₹<%=(s.balance||0).toFixed(2)%></td>
    <td><span class="badge badge-<%=s.status.toLowerCase()%>"><%=s.status%></span></td>
    <td class="sm"><%= moment().diff(moment(s.invoiceDate),'days') %> days</td>
  </tr><%})%></tbody>
  <tfoot><tr style="font-weight:700;background:var(--bg3)"><td colspan="5" style="padding:10px 14px">TOTAL RECEIVABLE</td><td class="mono fw6 tr cr" style="padding:10px 14px">₹<%=salesOutstanding.reduce((s,b)=>s+(b.balance||0),0).toFixed(2)%></td><td colspan="2"></td></tr></tfoot>
  <%}%>
</div>
<div class="tbl-wrap">
  <div class="tbl-hdr"><span class="tbl-title" style="color:var(--amber)"><i class="fa fa-arrow-up"></i> Purchase Payables</span></div>
  <%if(!purchaseOutstanding.length){%><div class="empty" style="padding:24px"><p>No outstanding purchases</p></div>
  <%}else{%><table><thead><tr><th>Bill No.</th><th>Date</th><th>Vendor</th><th class="tr">Bill Amt</th><th class="tr">Paid</th><th class="tr">Balance Due</th><th>Status</th><th>Aging</th></tr></thead>
  <tbody><%purchaseOutstanding.forEach(p=>{%><tr>
    <td><a href="/purchase-bills/<%=p.id%>" class="cacc" style="font-family:var(--mono);font-size:12px"><%=p.billNo%></a></td>
    <td class="muted sm"><%=moment(p.billDate).format('DD/MM/YYYY')%></td>
    <td class="fw6"><%=p.vendorName%></td>
    <td class="mono tr">₹<%=(p.netPayable||0).toFixed(2)%></td>
    <td class="mono tr cg">₹<%=(p.paidAmount||0).toFixed(2)%></td>
    <td class="mono fw6 tr ca">₹<%=(p.balance||0).toFixed(2)%></td>
    <td><span class="badge badge-<%=p.status.toLowerCase()%>"><%=p.status%></span></td>
    <td class="sm"><%= moment().diff(moment(p.billDate),'days') %> days</td>
  </tr><%})%></tbody>
  <tfoot><tr style="font-weight:700;background:var(--bg3)"><td colspan="5" style="padding:10px 14px">TOTAL PAYABLE</td><td class="mono fw6 tr ca" style="padding:10px 14px">₹<%=purchaseOutstanding.reduce((s,b)=>s+(b.balance||0),0).toFixed(2)%></td><td colspan="2"></td></tr></tfoot>
  <%}%>
</div>
<%- include('../partials/footer') %>
