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

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

Athena Loans Collection Report

Teller: {{ strtoupper($teller_name) }}

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


@foreach($data AS $d) @endforeach
Customer Name Account No. PR Number Terms Bills Materials Services GDeposit Principal Interest Net Amt Penalty Past Due Int Amount Paid Date Collected
{{ strtoupper($d->customer_name) }} {{ $d->acct_number }} {{ $d->pr_number }} {{ $d->term_count }} ({{ $d->terms_paid }}) {{ 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,".",",") }} {{ 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,".",",") }} {{ date('M d, Y', strtotime($d->created_at)) }}
Total Number of Customers: {{ $data->count('id') }} {{ $data->sum('term_count') }} {{ number_format((float)$data->sum('bills_amt'), 2,".",",") }} {{ number_format((float)$data->sum('materials_amt'), 2,".",",") }} {{ number_format((float)$data->sum('services_amt'), 2,".",",") }} {{ number_format((float)$data->sum('gdeposit_amt'), 2,".",",") }} {{ number_format((float)$data->sum('principal_amt'), 2,".",",") }} {{ number_format((float)$data->sum('interest_amt'), 2,".",",") }} {{ number_format((float)$data->sum('net_amt'), 2,".",",") }} {{ number_format((float)$data->sum('penalty_amt'), 2,".",",") }} {{ number_format((float)$data->sum('past_due_int_amt'), 2,".",",") }} {{ number_format((float)$data->sum('amt_paid'), 2,".",",") }}