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

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

Account Deactivation Summary

{{ date_format(date_create($from), 'M d, Y') }} to {{ date_format(date_create($to), 'M d, Y') }}


{{-- --}} @if (session("septage_fee") == 1) @endif @if (session("meter_charges") == 1) @endif @if (session("franchise_tax") == 1) @endif @foreach($data AS $d) {{-- --}} {{-- --}} @if (session("septage_fee") == 1) @endif @if (session("meter_charges") == 1) @endif @if (session("franchise_tax") == 1) @endif @endforeach {{-- --}} @if (session("septage_fee") == 1) @endif @if (session("meter_charges") == 1) @endif @if (session("franchise_tax") == 1) @endif
Date ReferenceJO No JO DateBook Account No Customer's Name Class Contract (-)Deposit (-)Advances (+)Water Bills (+)ATB (+)Other Payables (+)Promo Payables (-)Partials(+)Septage(+)M. Charges(+)F. Tax(-)Senior (+)Penalty (=)Net Amount
{{ date_format(date_create($d->created_at), 'm/d/Y') }} {{ $d->reference_no }}{{ $d->jo_number }} {{ date_format(date_create($d->jo_date), 'm/d/Y') }}{{ $d->book }} {{ $d->acct_number }} {{ ucwords(strtolower($d->cust_name)) }} {{ $d->acct_class }} - {{ $d->acct_subclass }} {{ $d->contract_no ? strtoupper($d->contract_no) : 'N/A'}} {{ number_format($d->gdeposit,2,".",",") }} {{ number_format($d->advances,2,".",",") }} {{ number_format($d->wbills,2,".",",") }} {{ number_format($d->atb,2,".",",") }} {{ number_format($d->other_payables,2,".",",") }} {{ number_format($d->promo_payables,2,".",",") }} {{ number_format($d->partials,2,".",",") }}{{ number_format($d->atb+$d->other_payables+$d->promo_payables,2,".",",") }}{{ number_format($d->septage_fee,2,".",",") }}{{ number_format($d->meter_charges,2,".",",") }}{{ number_format($d->franchise_tax,2,".",",") }}{{ number_format($d->senior,2,".",",") }} {{ number_format($d->penalty,2,".",",") }} {{ number_format($d->net_amount,2,".",",") }}
Total Number of Accounts: {{ $data->count() }} {{ number_format($data->sum('gdeposit'),2,".",",") }} {{ number_format($data->sum('advances'),2,".",",") }} {{ number_format($data->sum('wbills'),2,".",",") }} {{ number_format($data->sum('atb'),2,".",",") }} {{ number_format($data->sum('others_payables'),2,".",",") }} {{ number_format($data->sum('promo_payables'),2,".",",") }} {{ number_format($data->sum('advances')+$data->sum('partials'),2,".",",") }}{{ number_format($data->sum('other_payables')+$data->sum('promo_payables'),2,".",",") }}{{ number_format($data->sum('septage_fee'),2,".",",") }}{{ number_format($data->sum('meter_charges'),2,".",",") }}{{ number_format($data->sum('franchise_tax'),2,".",",") }}{{ number_format($data->sum('senior'),2,".",",") }} {{ number_format($data->sum('penalty'),2,".",",") }} {{ number_format($data->sum('net_amount'),2,".",",") }}