@foreach($bills AS $b) @endforeach @if($fbill) @endif @if($promos->count() > 0) @foreach($promos AS $p) @endforeach @endif @if($others->count() > 0) @foreach($others AS $o) @endforeach @endif

Unpaid Water Bills			Bill Amount	Penalty	Total Due	Senior	Amount Paid	Balance
{{ $b->bill_number }} {{ $b->bill_type }} ({{ sprintf('%02d', $b->bill_month) }}-{{ $b->bill_year }})			{{ number_format($b->total_due,2,".",",") }}	{{ number_format($b->penalty,2,".",",") }}	{{ number_format($b->total_due + $b->penalty,2,".",",") }}	({{ number_format($b->senior,2,".",",") }})	({{ number_format($b->advance + $b->amount_paid,2,".",",") }})	{{ number_format($b->balance,2,".",",") }}
0000000 FB ({{ sprintf('%02d', $fbill->bill_month) }}-{{ $fbill->bill_year }})			{{ number_format($fbill->total_due,2,".",",") }}	{{ number_format($fbill->penalty,2,".",",") }}	{{ number_format($fbill->total_due + $fbill->penalty,2,".",",") }}	({{ number_format($fbill->senior,2,".",",") }})	({{ number_format($fbill->advance + $fbill->amount_paid,2,".",",") }})	{{ number_format($fbill->balance + $fbill->penalty,2,".",",") }}
{{ number_format($total_bills,2,".",",") }}
Promo Payables
{{ ucwords($p->reference == 'Others' ? $p->reference_others : $p->reference) }}					{{ number_format($p->amt_net,2,".",",") }}	({{ number_format($p->amt_paid,2,".",",") }})		{{ number_format($p->amt_remaining,2,".",",") }}
{{ number_format($total_promo,2,".",",") }}
Other Payables
{{ ucwords($o->reference =='Others' ? $o->reference_others : $o->reference) }}					{{ number_format($o->amt_net,2,".",",") }}	({{ number_format($o->amt_paid,2,".",",") }})		{{ number_format($o->amt_remaining,2,".",",") }}
{{ number_format($total_others,2,".",",") }}
Total Payables			{{ number_format($total_balance,2,".",",") }}
Less Remaining Advances			{{ number_format($account->adv_payment,2,".",",") }}
Less Guarantee Deposit			{{ number_format($account->gdeposit,2,".",",") }}
{{ $total_net < 0 ? 'Net Refund' : 'Net Payable' }}			{{ number_format(abs($total_net),2,".",",") }}