@php
    $org = auth()->user()->organization ?? \App\Models\System\Organization::find(auth()->user()->organization_id);
@endphp
@extends('documents.procurement._layout', [
    'documentTitle' => 'Aged Creditors Report',
    'reference'     => null,
    'documentDate'  => $reportDate,
    'noAutoPrint'   => true,
])

@section('header-meta')
    <div style="font-size:9pt; color:#444; margin-top:4px;">
        As of: <strong>{{ $asOf->format('d M Y') }}</strong>
    </div>
    <div style="font-size:9pt; color:#444; margin-top:2px;">
        Currency: <strong>{{ $currency }}</strong>
    </div>
@endsection

@section('content')

@php
    $totalCurrent  = $buckets['current']->sum(fn($i)  => (float)$i->total_amount - (float)$i->amount_paid_base);
    $total1_30     = $buckets['1_30']->sum(fn($i)     => (float)$i->total_amount - (float)$i->amount_paid_base);
    $total31_60    = $buckets['31_60']->sum(fn($i)    => (float)$i->total_amount - (float)$i->amount_paid_base);
    $total61_90    = $buckets['61_90']->sum(fn($i)    => (float)$i->total_amount - (float)$i->amount_paid_base);
    $totalOver90   = $buckets['over_90']->sum(fn($i)  => (float)$i->total_amount - (float)$i->amount_paid_base);
    $grandTotal    = $totalCurrent + $total1_30 + $total31_60 + $total61_90 + $totalOver90;
@endphp

{{-- Age Summary --}}
<table style="margin-bottom:20px; border:none; width:auto;">
    <tr>
        <td style="border:none; padding:8px 14px; background:#d1fae5; text-align:center; font-weight:bold;">
            Current<br><span style="font-size:16pt;">{{ number_format($totalCurrent, 0) }}</span>
        </td>
        <td style="border:none; padding:8px 14px; background:#fef3c7; text-align:center; font-weight:bold;">
            1–30 Days<br><span style="font-size:16pt;">{{ number_format($total1_30, 0) }}</span>
        </td>
        <td style="border:none; padding:8px 14px; background:#fed7aa; text-align:center; font-weight:bold;">
            31–60 Days<br><span style="font-size:16pt;">{{ number_format($total31_60, 0) }}</span>
        </td>
        <td style="border:none; padding:8px 14px; background:#fecaca; text-align:center; font-weight:bold;">
            61–90 Days<br><span style="font-size:16pt;">{{ number_format($total61_90, 0) }}</span>
        </td>
        <td style="border:none; padding:8px 14px; background:#fee2e2; text-align:center; font-weight:bold; color:#dc2626;">
            Over 90 Days<br><span style="font-size:16pt;">{{ number_format($totalOver90, 0) }}</span>
        </td>
        <td style="border:none; padding:8px 14px; background:#dbeafe; text-align:center; font-weight:bold;">
            Total Outstanding<br><span style="font-size:16pt;">{{ number_format($grandTotal, 0) }}</span>
        </td>
    </tr>
</table>

@if($bySupplier->isEmpty())
    <p style="color:#666; font-style:italic;">No outstanding balances as of {{ $asOf->format('d M Y') }}.</p>
@else
    {{-- By Supplier --}}
    @foreach($bySupplier as $supplierId => $supplierInvoices)
        @php
            $supplierName = $supplierInvoices->first()->supplier?->name ?? '—';
            $supplierTotal = $supplierInvoices->sum(fn($i) => (float)$i->total_amount - (float)$i->amount_paid_base);
        @endphp
        <h2>{{ $supplierName }} — {{ $currency }} {{ number_format($supplierTotal, 2) }} outstanding</h2>
        <table class="table-compact avoid-break-inside">
            <thead>
                <tr>
                    <th>Invoice Ref</th>
                    <th>Invoice Date</th>
                    <th>Due Date</th>
                    <th style="text-align:right;">Total ({{ $currency }})</th>
                    <th style="text-align:right;">Paid</th>
                    <th style="text-align:right;">Balance</th>
                    <th>Age</th>
                </tr>
            </thead>
            <tbody>
                @foreach($supplierInvoices as $inv)
                    @php
                        $balance = (float)$inv->total_amount - (float)$inv->amount_paid_base;
                        if ($balance <= 0) continue;
                        $days = $inv->due_date ? $inv->due_date->diffInDays($asOf, false) : null;
                        $ageLabel = $days === null ? 'No due date' : ($days <= 0 ? 'Current' : $days . ' days');
                        $rowClass = $days === null || $days <= 0 ? 'bg-green' : ($days <= 30 ? 'bg-amber' : 'bg-red');
                    @endphp
                    <tr class="avoid-break-inside {{ $rowClass }}">
                        <td class="font-mono" style="font-size:9pt;">{{ $inv->invoice_reference }}</td>
                        <td style="font-size:9pt;">{{ \Carbon\Carbon::parse($inv->invoice_date)->format('d M Y') }}</td>
                        <td style="font-size:9pt;">{{ $inv->due_date ? $inv->due_date->format('d M Y') : '—' }}</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">{{ number_format((float)$inv->amount_paid_base, 2) }}</td>
                        <td style="text-align:right; font-weight:bold;" class="font-mono">{{ number_format($balance, 2) }}</td>
                        <td style="font-size:9pt;">{{ $ageLabel }}</td>
                    </tr>
                @endforeach
            </tbody>
        </table>
    @endforeach
@endif

@endsection