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

Unpaid Water Bills		Bill Amount	ATB	M.Charges	F.Tax	Penalty	Total Due	Senior	Amount Paid	Balance
{{ $b->bill_number }} {{ $b->bill_type }} ({{ sprintf('%02d', $b->bill_month) }}-{{ $b->bill_year }})		{{ number_format($b->bill_amount,2,".",",") }}	{{ number_format($b->others,2,".",",") }}	{{ number_format($b->meter_charges,2,".",",") }}	{{ number_format($b->franchise_tax,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->bill_amount,2,".",",") }}	{{ number_format($fbill->others,2,".",",") }}	{{ number_format($fbill->meter_charges,2,".",",") }}	{{ number_format($fbill->franchise_tax,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,".",",") }}
Total Septage Fee					{{ number_format(abs($total_septage),2,".",",") }}