@extends('documents.procurement._layout', [
    'documentTitle' => 'Statement of Account',
    'reference'     => $supplier->name,
    'documentDate'  => $today->format('d M Y'),
])

@section('header-meta')
    <div style="font-size:9pt; color:#444; margin-top:4px;">
        Period: <strong>{{ $from->format('d M Y') }}</strong> — <strong>{{ $until->format('d M Y') }}</strong>
    </div>
@endsection

@section('content')

@php
    $totalInvoiced = $invoices->sum(fn($i) => (float) $i->total_amount);
    $totalPaid     = $invoices->sum(fn($i) => (float) $i->amount_paid_base);
    $totalBalance  = $totalInvoiced - $totalPaid;
    $runningBalance = 0;
@endphp

{{-- Supplier block --}}
<table style="margin-bottom:20px; border:none;">
    <tr>
        <td style="border:none; width:50%; vertical-align:top;">
            <strong style="font-size:10pt;">Supplier:</strong><br>
            <strong>{{ $supplier->name }}</strong><br>
            @if($supplier->contact_email) {{ $supplier->contact_email }}<br> @endif
            @if($supplier->contact_phone) {{ $supplier->contact_phone }}<br> @endif
            @if($supplier->city) {{ $supplier->city }} @endif
        </td>
    </tr>
</table>

{{-- Transactions --}}
<table>
    <thead>
        <tr>
            <th>Date</th>
            <th>Reference</th>
            <th>Description</th>
            <th style="text-align:right;">Invoiced</th>
            <th style="text-align:right;">Paid</th>
            <th style="text-align:right;">Balance</th>
        </tr>
    </thead>
    <tbody>
        @foreach($invoices as $inv)
            @php
                $runningBalance += (float) $inv->total_amount;
                $paidSoFar = $inv->payments->sortBy('payment_date');
            @endphp
            <tr class="avoid-break-inside">
                <td style="font-size:9pt;">{{ \Carbon\Carbon::parse($inv->invoice_date)->format('d M Y') }}</td>
                <td class="font-mono" style="font-size:9pt;">{{ $inv->invoice_reference }}</td>
                <td style="font-size:9pt;">Invoice — {{ ucwords(str_replace('_', ' ', $inv->invoice_type)) }}</td>
                <td style="text-align:right;" class="font-mono">{{ number_format((float) $inv->total_amount, 2) }}</td>
                <td style="text-align:right;" class="font-mono">—</td>
                <td style="text-align:right;" class="font-mono">{{ number_format($runningBalance, 2) }}</td>
            </tr>
            @foreach($paidSoFar as $pmt)
                @php $runningBalance -= (float) $pmt->amount_base; @endphp
                <tr class="avoid-break-inside bg-green">
                    <td style="font-size:9pt;">{{ \Carbon\Carbon::parse($pmt->payment_date)->format('d M Y') }}</td>
                    <td class="font-mono" style="font-size:9pt;">{{ $pmt->payment_reference }}</td>
                    <td style="font-size:9pt;">Payment — {{ ucwords(str_replace('_', ' ', $pmt->payment_method)) }}</td>
                    <td style="text-align:right;" class="font-mono">—</td>
                    <td style="text-align:right;" class="font-mono">({{ number_format((float) $pmt->amount_base, 2) }})</td>
                    <td style="text-align:right;" class="font-mono">{{ number_format($runningBalance, 2) }}</td>
                </tr>
            @endforeach
        @endforeach
    </tbody>
</table>

{{-- Summary --}}
<table style="margin-top:16px; width:50%; margin-left:auto; border:none;">
    <tr>
        <td style="border:none; padding:4px 8px; text-align:right; color:#666;">Total Invoiced</td>
        <td style="border:none; padding:4px 8px; text-align:right;" class="font-mono">{{ number_format($totalInvoiced, 2) }}</td>
    </tr>
    <tr>
        <td style="border:none; padding:4px 8px; text-align:right; color:#16a34a;">Total Paid</td>
        <td style="border:none; padding:4px 8px; text-align:right; color:#16a34a;" class="font-mono">({{ number_format($totalPaid, 2) }})</td>
    </tr>
    <tr style="border-top:2px solid #000;">
        <td style="border:none; padding:8px 8px 4px; font-weight:bold; text-align:right; {{ $totalBalance > 0 ? 'color:#dc2626;' : 'color:#16a34a;' }}">Outstanding Balance</td>
        <td style="border:none; padding:8px 8px 4px; text-align:right; {{ $totalBalance > 0 ? 'color:#dc2626;' : 'color:#16a34a;' }}" class="font-mono">
            <strong>{{ number_format($totalBalance, 2) }}</strong>
        </td>
    </tr>
</table>

{{-- Age analysis --}}
@if(array_sum($ageBuckets) > 0)
    <h2 style="margin-top:30px;">Aged Analysis (Outstanding)</h2>
    <table>
        <thead>
            <tr>
                <th>Current (Not Due)</th>
                <th style="text-align:right;">1–30 Days</th>
                <th style="text-align:right;">31–60 Days</th>
                <th style="text-align:right;">61–90 Days</th>
                <th style="text-align:right;">Over 90 Days</th>
                <th style="text-align:right;">Total</th>
            </tr>
        </thead>
        <tbody>
            <tr>
                <td class="font-mono">{{ number_format($ageBuckets['current'], 2) }}</td>
                <td style="text-align:right;" class="font-mono {{ $ageBuckets['1_30'] > 0 ? 'bg-amber' : '' }}">{{ number_format($ageBuckets['1_30'], 2) }}</td>
                <td style="text-align:right;" class="font-mono {{ $ageBuckets['31_60'] > 0 ? 'bg-amber' : '' }}">{{ number_format($ageBuckets['31_60'], 2) }}</td>
                <td style="text-align:right;" class="font-mono {{ $ageBuckets['61_90'] > 0 ? 'bg-red' : '' }}">{{ number_format($ageBuckets['61_90'], 2) }}</td>
                <td style="text-align:right;" class="font-mono {{ $ageBuckets['over_90'] > 0 ? 'bg-red' : '' }}">{{ number_format($ageBuckets['over_90'], 2) }}</td>
                <td style="text-align:right; font-weight:bold;" class="font-mono">{{ number_format(array_sum($ageBuckets), 2) }}</td>
            </tr>
        </tbody>
    </table>
@endif

@endsection