@extends('layouts.pdf.base')

@section('pdf-title', 'AR Aging Report')
@section('pdf-subtitle')
    As of {{ \Carbon\Carbon::today()->format('d M Y') }}
@endsection

@section('pdf-content')
<table class="chm-pdf-table">
    <thead>
        <tr>
            <th>#</th>
            <th>Customer</th>
            <th>Ref</th>
            <th>Due Date</th>
            <th class="text-right">Current</th>
            <th class="text-right">1–30</th>
            <th class="text-right">31–60</th>
            <th class="text-right">61–90</th>
            <th class="text-right">&gt;90</th>
            <th class="text-right">Total</th>
        </tr>
    </thead>
    <tbody>
        @php
            $tot = ['current' => 0, 'b1' => 0, 'b2' => 0, 'b3' => 0, 'b4' => 0, 'total' => 0];
        @endphp
        @foreach($rows as $i => $r)
            @foreach(['current', 'b1', 'b2', 'b3', 'b4', 'total'] as $k)
                @php $tot[$k] += $r->$k; @endphp
            @endforeach
            <tr>
                <td>{{ $i + 1 }}</td>
                <td>{{ $r->party }}</td>
                <td>{{ $r->reference }}</td>
                <td>{{ $r->due_date }}</td>
                <td class="text-right">{{ number_format($r->current, 2) }}</td>
                <td class="text-right">{{ number_format($r->b1, 2) }}</td>
                <td class="text-right">{{ number_format($r->b2, 2) }}</td>
                <td class="text-right">{{ number_format($r->b3, 2) }}</td>
                <td class="text-right">{{ number_format($r->b4, 2) }}</td>
                <td class="text-right">{{ number_format($r->total, 2) }}</td>
            </tr>
        @endforeach
    </tbody>
    <tfoot>
        <tr>
            <td colspan="4" class="text-right">Grand Total</td>
            <td class="text-right">{{ number_format($tot['current'], 2) }}</td>
            <td class="text-right">{{ number_format($tot['b1'], 2) }}</td>
            <td class="text-right">{{ number_format($tot['b2'], 2) }}</td>
            <td class="text-right">{{ number_format($tot['b3'], 2) }}</td>
            <td class="text-right">{{ number_format($tot['b4'], 2) }}</td>
            <td class="text-right">{{ number_format($tot['total'], 2) }}</td>
        </tr>
    </tfoot>
</table>
@endsection