@php
    $gt_atb_total = 0;
@endphp

<!-- <style type="text/css">
	@media print {    
        #table-report {
            font-size: 8px;
        }
    }
</style>

<style type="text/css">
    #report {
        width: 100%;
        height:100%;
        position:absolute;
        top:0px;
        bottom:0px;
        margin: auto;
        margin-top: 0px !important;
        border: 1px solid;
    }
</style> -->

<section class="invoice" style="font-size:8pt">
    <style type="text/css">
        .table > tbody > tr > td {
            padding-left: 3pt;
            padding-top: 1pt;
            padding-right: 2pt;
            padding-bottom: 4pt;
        }
    </style>

    <p class="text-center" style="margin-bottom:0px"><b>{{ session('company_name') }}</b></p>
    <p class="text-center text-muted">{{ strtoupper(session('branch_name')) }}</p>
    <p class="text-center" style="margin-bottom:0px"><b>ADD TO BILL SUMMARY REPORT</b></p>
    <p class="text-center text-muted">BILL PERIOD: {{ $year }}-{{ sprintf("%02d", $month) }}</p>

    <table class="table table-hover table-condensed table-dt">
        <thead class="table-header-bg">
          	<tr>
                <th width="8%">ACCOUNT NO</th>
                <th width="4%">CLASS</th>
                <th width="4%">BOOK</th>
                <th width="18%">CUSTOMER'S NAME</th>
                <th width="28%">ADDRESS</th>
                <th width="6%">METER NO</th>
                <th width="6%">BILL NO</th>
                <th width="20%">REFERENCE</th>
                <th width="6%" style="text-align: right;">AMOUNT</th>
          	</tr>
    	</thead>
    	<tbody>
    		@foreach($data AS $d)
                @if(count($d->details) > 1)
                    @foreach($d->details AS $i => $r)
                        @if($i == 0)
                            <tr>
                                <td>{{ $d->acct_number }}</td>
                                <td>{{ $d->acct_class }}</td>
                                <td>{{ $d->book }}</td>
                                <td>{{ strtoupper($d->cust_name) }}</td>
                                <td>{{ strtoupper(substr($d->complete_address, 0, 60)) }}</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>
                           
                        @else
                            <tr>
                                <td colspan="7"></td>
                                <td>{{ $d->details[$i]['reference'] }}</td>
                                <td style="text-align: right;">{{ number_format($d->details[$i]['atb'],2,".",",") }}</td>
                            </tr>
                        @endif
                    @endforeach
                @else
                <tr>
                    <td>{{ $d->acct_number }}</td>
                    <td>{{ $d->acct_class }}</td>
                    <td>{{ $d->book }}</td>
                    <td>{{ strtoupper($d->cust_name) }}</td>
                    <td>{{ strtoupper(substr($d->complete_address, 0, 60)) }}</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
            
            <tr style='font-weight:bold;' class='table-header-bg'>
                <td colspan="8">GRAND TOTAL</td>
                <td style="text-align: right;">{{ number_format((float)$gt_atb_total, 2,".",",") }}</td>
            </tr>
    	</tbody>
    </table>
</section>