{{ session('company_name') }}

@foreach($data as $d) {{-- --}} {{-- --}} @endforeach

No.	Customer Name	Account No.	OR Number	No. Of Bills	Total Amount	Datetime Cancelled	Teller	Reason of Cancel
{{ $num_cust }}	{{ strtoupper($d->customer_name) }}	@php if($d->acct_number == ''){ echo 'Service Application'; } else { echo $d->acct_number; } @endphp	{{ $d->or_number }}	{{ $d->number_of_bills }}	@php $reference = strtolower($d->reference); switch ( $reference ) { case 'bill': echo 'Water Bill'; break; case 'bill promissory': echo 'Promissory Note'; break; case 'ciap': echo 'Advance Payment'; break; case ($reference=='application - guarantee deposit' \|\| $reference=='application - service fee' \|\| $reference=='application - materials'): echo 'New Connection'; break; case ($reference == 'jo services'): echo 'JO Services'; break; case ($reference == 'jo materials'): echo 'JO Materials'; break; case ($reference == 'jo illegal'): echo 'JO Illegal'; break; case ($reference=='net payable' \|\| $reference=='net refund'): echo 'RS Deficit'; break; case 'other-transactions': echo 'Other Transactions'; break; default: echo 'Others'; } @endphp	{{ $d->amt_total }}	{{ date('m/d/Y h:i a', strtotime($d->cancelled_at)) }} {{-- @php $payable = 0; if($d->total_cum <= 10){ $payable = 20.00; echo number_format((float)$payable, 2,".",","); } else { $payable = $d->total_cum * 2; echo number_format((float)$payable, 2,".",","); } @endphp --}}	{{ strtoupper($d->name) }}	{{ strtoupper($d->reason_of_cancel) }}	{{ date("m/d/Y", strtotime($d->collection_date)) }}