@php
    $gt_atb_total = 0;
@endphp

<div class="col-xs-12">
	<section id="report-printable">
		<p class="text-center text-bold" style="margin-bottom:0px">{{ strtoupper(session('company_name')) }}</p>
		<p class="text-center" style="margin-bottom:0px">{{ strtoupper(session('branch_name')) }}</p>
	    <p class="text-center text-bold" style="margin-bottom:0px">ADD TO BILL SUMMARY REPORT{{ session('report_exception') == "0" ? " ACCTG" : "" }}</p>
	    <p class="text-center">Bill Period {{ sprintf("%02d", $month) }}-{{ $year }}</p>
	    <br>
	    <table class="table table-bordered table-condensed table-atb">
	    	<thead class="table-header-bg">
	    		<tr>
	                <th width="20%">Customer Name</th>
	                <th width="10%">Account No.</th>
	                <th width="6%">Class</th>
	                <th width="6%">Book</th>
	                <th width="6%">Meter No</th>
	                <th width="6%">Bill No.</th>
	                <th width="38%">Reference</th>
	                <th width="8%" style="text-align: right;">Amount</th>
	          	</tr>
	    	</thead>
	    	<tbody>
				@foreach($data AS $d)
	                @if(count($d->details) > 1)
	                    @foreach($d->details AS $i => $r)
                            <tr>
                                <td>{{ strtoupper($d->cust_name) }}</td>
                                <td>{{ $d->acct_number }}</td>
                                {{-- <td>{{ strtoupper(substr($d->complete_address, 0, 60)) }}</td> --}}
                                <td>{{ $d->acct_class }}</td>
                                <td>{{ $d->book }}</td>
                                <td>{{ $d->meter_no }}</td>
                                <td>{{ $d->bill_number }}</td>
                                <td>{{ $d->details[$i]['reference'] }}</td>
                                <td style="text-align: right;">{{ number_format($d->details[$i]['atb'],2,".",",") }}</td>
                            </tr>
	                    @endforeach
	                @else
	                <tr>
	                    <td>{{ strtoupper($d->cust_name) }}</td>
	                    <td>{{ $d->acct_number }}</td>
	                    {{-- <td>{{ strtoupper(substr($d->complete_address, 0, 60)) }}</td> --}}
	                    <td>{{ $d->acct_class }}</td>
	                    <td>{{ $d->book }}</td>
	                    <td>{{ $d->meter_no }}</td>
	                    <td>{{ $d->bill_number }}</td>
	                    <td>{{ $d->details[0]['reference'] }}</td>
	                    <td style="text-align: right;">{{ number_format($d->details[0]['atb'],2,".",",") }}</td>
	                </tr>
	                @endif    
		            @php
		                $gt_atb_total += $d->others;
		            @endphp
	            @endforeach
	    	</tbody>
	    	<tfoot>
            	<tr>
            		<th colspan="7">Total Number of Customers: {{ $grand_total['total_count'] }}</th>
            		<th class="text-right">{{ number_format((float)$gt_atb_total, 2,".",",") }}</th>
            	</tr>
            </tfoot>
	    </table>
	</section>
</div>