<%= t('admin.reports.total_revenue_year', 'Total Pendapatan') %> <%= filterYear %>
Rp <%= totalRevenue.toLocaleString('id-ID') %>
<%= t('admin.reports.this_month', 'Bulan Ini') %>
Rp <%= thisMonth.toLocaleString('id-ID') %>
<%= t('admin.reports.pending_receivable', 'Piutang Belum Bayar') %>
Rp <%= pendingAmount.toLocaleString('id-ID') %>
<%= t('admin.reports.active_customers_total', 'Total Pelanggan Aktif') %>
<%= activeCustomers %>
<%= t('admin.reports.revenue_via_agent_year', 'Pendapatan Via Agent') %> <%= filterYear %>
Rp <%= (revenueYearAgent || 0).toLocaleString('id-ID') %>
<%= t('admin.reports.this_month_prefix', 'Bulan ini:') %> Rp <%= (revenueThisMonthAgent || 0).toLocaleString('id-ID') %>
<%= t('admin.reports.agent_deposit_year', 'Deposit Agent Masuk') %> <%= filterYear %>
Rp <%= (agentDepositYear || 0).toLocaleString('id-ID') %>
<%= t('admin.reports.this_month_prefix', 'Bulan ini:') %> Rp <%= (agentDepositThisMonth || 0).toLocaleString('id-ID') %>
<%= t('admin.reports.cash_in_year', 'Kas Masuk (Tanpa Double)') %> <%= filterYear %>
Rp <%= (cashInYear || 0).toLocaleString('id-ID') %>
<%= t('admin.reports.this_month_prefix', 'Bulan ini:') %> Rp <%= (cashInThisMonth || 0).toLocaleString('id-ID') %>
<%= t('admin.reports.monthly_revenue', 'Pendapatan Bulanan') %> <%= filterYear %>
<%= t('admin.reports.top_unpaid', 'Piutang Tertinggi') %>
<% if (topUnpaid.length===0) { %>
<%= t('admin.reports.all_paid', 'Semua pelanggan sudah lunas') %>
<% } %>
<% topUnpaid.forEach(u=>{ %>
<%= u.name %>
<%= u.phone %> • <%= u.unpaid_count %> <%= t('admin.reports.invoices_suffix', 'tagihan') %>
Rp <%= u.total_unpaid.toLocaleString('id-ID') %>
<% }) %>
<%= t('admin.reports.monthly_breakdown', 'Rincian Per Bulan') %> <%= filterYear %>
| <%= t('admin.reports.table.month', 'Bulan') %> |
<%= t('admin.reports.table.total_invoices', 'Total Tagihan') %> |
<%= t('admin.reports.table.paid', 'Sudah Bayar') %> |
<%= t('admin.reports.table.unpaid', 'Belum Bayar') %> |
<%= t('admin.reports.table.revenue', 'Pendapatan') %> |
<%= t('admin.reports.table.pct', 'Persentase') %> |
<% const mns = (lang === 'en')
? ['January','February','March','April','May','June','July','August','September','October','November','December']
: ['Januari','Februari','Maret','April','Mei','Juni','Juli','Agustus','September','Oktober','November','Desember'];
let grandTotal=0, grandPaid=0;
monthlyData.forEach(m=>{ grandTotal+=m.total_invoices; grandPaid+=m.paid_count; }); %>
<% if(monthlyData.length===0){ %>
| <%= t('admin.reports.no_data_year_prefix', 'Belum ada data untuk tahun') %> <%= filterYear %> |
<% } %>
<% monthlyData.forEach(m=>{ const pct=m.total_invoices>0?Math.round(m.paid_count/m.total_invoices*100):0; %>
| <%= mns[m.month-1] %> |
<%= m.total_invoices %> |
<%= m.paid_count %> |
<%= m.unpaid_count %> |
Rp <%= m.revenue.toLocaleString('id-ID') %> |
|
<% }) %>
<%= t('admin.reports.recent_payments', 'Pembayaran Terakhir') %>
| <%= t('admin.reports.table.customer', 'Pelanggan') %> |
<%= t('admin.reports.table.period', 'Periode') %> |
<%= t('admin.reports.table.amount', 'Jumlah') %> |
<%= t('admin.reports.table.recorded_by', 'Dicatat Oleh') %> |
<%= t('admin.reports.table.time', 'Waktu') %> |
<% const mn2 = (lang === 'en')
? ['Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec']
: ['Jan','Feb','Mar','Apr','Mei','Jun','Jul','Agt','Sep','Okt','Nov','Des']; %>
<% if(recentPayments.length===0){%>| <%= t('admin.reports.no_payments', 'Belum ada pembayaran') %> |
<%}%>
<% recentPayments.forEach(p=>{ %>
| <%= p.customer_name %> |
<%= mn2[p.period_month-1] %> <%= p.period_year %> |
Rp <%= p.amount.toLocaleString('id-ID') %> |
<%= p.paid_by_name||'-' %> |
<%= p.paid_at ? new Date(p.paid_at).toLocaleString('id-ID',{day:'2-digit',month:'short',hour:'2-digit',minute:'2-digit'}) : '-' %> |
<% }) %>