| Unpaid Water Bills | Bill Amount | ATB | @if (session('meter_charges'))M.Charges | @endif @if (session('franchise_tax'))F.Tax | @endif @if (session('septage_fee'))Septage | @endifPenalty | 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,".",",") }} | @if (session('meter_charges')){{ number_format($b->meter_charges,2,".",",") }} | @endif @if (session('franchise_tax')){{ number_format($b->franchise_tax,2,".",",") }} | @endif @if (session('septage_fee')){{ number_format($b->septage_fee,2,".",",") }} | @endif{{ 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,".",",") }} | @if (session('meter_charges')){{ number_format($fbill->meter_charges,2,".",",") }} | @endif @if (session('franchise_tax')){{ number_format($fbill->franchise_tax,2,".",",") }} | @endif @if (session('septage_fee')){{ number_format($fbill->septage_fee,2,".",",") }} | @endif{{ 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,".",",") }} | ||
| @endif @if (session('franchise_tax')) | @endif @if (session('septage_fee')) | @endif | {{ number_format($total_bills,2,".",",") }} | |||||||||
| Promo Payables | @if (session('meter_charges'))@endif @if (session('franchise_tax')) | @endif @if (session('septage_fee')) | @endif | |||||||||
| {{ ucwords($p->reference == 'Others' ? $p->reference_others : $p->reference) }} | @if (session('meter_charges'))@endif @if (session('franchise_tax')) | @endif @if (session('septage_fee')) | @endif | {{ number_format($p->amt_net,2,".",",") }} | ({{ number_format($p->amt_paid,2,".",",") }}) | {{ number_format($p->amt_remaining,2,".",",") }} | ||||||
| @endif @if (session('franchise_tax')) | @endif @if (session('septage_fee')) | @endif | {{ number_format($total_promo,2,".",",") }} | |||||||||
| Other Payables | @if (session('meter_charges'))@endif @if (session('franchise_tax')) | @endif @if (session('septage_fee')) | @endif | |||||||||
| {{ ucwords($o->reference =='Others' ? $o->reference_others : $o->reference) }} | @if (session('meter_charges'))@endif @if (session('franchise_tax')) | @endif @if (session('septage_fee')) | @endif | {{ number_format($o->amt_net,2,".",",") }} | ({{ number_format($o->amt_paid,2,".",",") }}) | {{ number_format($o->amt_remaining,2,".",",") }} | ||||||
| @endif @if (session('franchise_tax')) | @endif @if (session('septage_fee')) | @endif | {{ number_format($total_others,2,".",",") }} | |||||||||
| Total Payables | @if (session('meter_charges'))@endif @if (session('franchise_tax')) | @endif @if (session('septage_fee')) | @endif | {{ number_format($total_balance,2,".",",") }} | ||||||||
| Less Remaining Advances | @if (session('meter_charges'))@endif @if (session('franchise_tax')) | @endif @if (session('septage_fee')) | @endif | {{ number_format($account->adv_payment,2,".",",") }} | ||||||||
| Less Guarantee Deposit | @if (session('meter_charges'))@endif @if (session('franchise_tax')) | @endif @if (session('septage_fee')) | @endif | {{ number_format($account->gdeposit,2,".",",") }} | ||||||||
| {{ $total_net < 0 ? 'Net Refund' : 'Net Payable' }} | @if (session('meter_charges'))@endif @if (session('franchise_tax')) | @endif @if (session('septage_fee')) | @endif | {{ number_format(abs($total_net),2,".",",") }} | ||||||||
| Athena Loan | @if (session('meter_charges'))@endif @if (session('franchise_tax')) | @endif @if (session('septage_fee')) | @endif | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Principal Balance @if (session('meter_charges')) @endif @if (session('franchise_tax')) | @endif @if (session('septage_fee')) | @endif {{-- | {{ number_format($athena['loan'],2,".",",") }} | --}} {{--({{ number_format($athena['payments'],2,".",",") }}) | --}}{{ number_format($athena['principal_bal'],2,".",",") }} | |||||||||
| Guarantee Deposit will not be applied on Athena Loans* | @if (session('meter_charges'))@endif @if (session('franchise_tax')) | @endif @if (session('septage_fee')) | @endif | |||||||||||