{{ strtoupper(session('company_name')) }}

{{ strtoupper(session('branch_name')) }}

Athena Loans Summary

@if ($date_type == 'date range')

{{ date('M d, Y', strtotime($date_from)) . ' - ' . date('M d, Y', strtotime($date_to)) }}

@else

As of {{ date_format(date_create($date), 'M d, Y') }}

@endif
@foreach($data AS $d) @endforeach
AcctNo AcctName Bills Materials Services GDeposit Principal IntRate IntAmt NetAmt Penalty PastDueInt AmtPaid Balance Status LoanPosted
{{ $d->acct_number }} {{ strtoupper($d->customer_name) }} {{ number_format((float)$d->bills_amt, 2,".",",") }} {{ number_format((float)$d->materials_amt, 2,".",",") }} {{ number_format((float)$d->services_amt, 2,".",",") }} {{ number_format((float)$d->gdeposit_amt, 2,".",",") }} {{ number_format((float)$d->principal_amt, 2,".",",") }} {{ $d->interest_rate }}% {{ number_format((float)$d->interest_amt, 2,".",",") }} {{ number_format((float)$d->net_amt, 2,".",",") }} {{ number_format((float)$d->penalty_amt, 2,".",",") }} {{ number_format((float)$d->past_due_int_amt, 2,".",",") }} {{ number_format((float)$d->amt_paid, 2,".",",") }} {{ number_format((float)$d->amt_remaining, 2,".",",") }} {{ ($d->status == 'p' || $d->status == 'paid') ? 'PAID' : 'UNPAID' }} {{ date('M d, Y', strtotime($d->date_posted)) }}
Total Number of Customers: {{ $grand_total['total_count'] }} {{ number_format((float)$grand_total['total_bills'], 2,".",",") }} {{ number_format((float)$grand_total['total_materials'], 2,".",",") }} {{ number_format((float)$grand_total['total_services'], 2,".",",") }} {{ number_format((float)$grand_total['total_gdeposit'], 2,".",",") }} {{ number_format((float)$grand_total['total_principal'], 2,".",",") }} {{ number_format((float)$grand_total['total_interest'], 2,".",",") }} {{ number_format((float)$grand_total['total_net_amt'], 2,".",",") }} {{ number_format((float)$grand_total['total_penalty'], 2,".",",") }} {{ number_format((float)$grand_total['total_past_due_int'], 2,".",",") }} {{ number_format((float)$grand_total['total_amt_paid'], 2,".",",") }} {{ number_format((float)$grand_total['total_balance'], 2,".",",") }}