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

@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>
    <div style="font-size:9pt; color:#444; margin-top:2px;">Currency: <strong>{{ $currency }}</strong></div>
@endsection

@section('content')

@php
    $grandInvoiced = $rows->sum('total_invoiced');
    $grandPaid     = $rows->sum('total_paid');
    $grandBalance  = $grandInvoiced - $grandPaid;
@endphp

{{-- Summary strip --}}
<table style="margin-bottom:20px; border:none; width:auto;">
    <tr>
        <td style="border:none; padding:8px 14px; background:#dbeafe; text-align:center; font-weight:bold;">
            Suppliers<br><span style="font-size:18pt;">{{ $rows->count() }}</span>
        </td>
        <td style="border:none; padding:8px 14px; background:#ede9fe; text-align:center; font-weight:bold;">
            Total Invoiced<br><span style="font-size:16pt;">{{ number_format($grandInvoiced, 0) }}</span>
        </td>
        <td style="border:none; padding:8px 14px; background:#d1fae5; text-align:center; font-weight:bold;">
            Total Paid<br><span style="font-size:16pt;">{{ number_format($grandPaid, 0) }}</span>
        </td>
        <td style="border:none; padding:8px 14px; background:{{ $grandBalance > 0 ? '#fee2e2' : '#d1fae5' }}; text-align:center; font-weight:bold; {{ $grandBalance > 0 ? 'color:#dc2626;' : '' }}">
            Outstanding<br><span style="font-size:16pt;">{{ number_format($grandBalance, 0) }}</span>
        </td>
    </tr>
</table>

@if($rows->isEmpty())
    <p style="color:#666; font-style:italic;">No invoices found for this period.</p>
@else
    <table>
        <thead>
            <tr>
                <th>Supplier</th>
                <th style="text-align:right;">Invoices</th>
                <th style="text-align:right;">Total Invoiced ({{ $currency }})</th>
                <th style="text-align:right;">Total Paid ({{ $currency }})</th>
                <th style="text-align:right;">Outstanding ({{ $currency }})</th>
                <th style="text-align:right;">% Paid</th>
            </tr>
        </thead>
        <tbody>
            @foreach($rows as $row)
                @php
                    $balance = (float)$row->total_invoiced - (float)$row->total_paid;
                    $pct = (float)$row->total_invoiced > 0
                        ? round((float)$row->total_paid / (float)$row->total_invoiced * 100, 1)
                        : 0;
                    $rowClass = $balance > 0 ? 'bg-amber' : 'bg-green';
                @endphp
                <tr class="avoid-break-inside {{ $rowClass }}">
                    <td><strong>{{ $row->supplier?->name ?? '—' }}</strong></td>
                    <td style="text-align:right;" class="font-mono">{{ $row->invoice_count }}</td>
                    <td style="text-align:right;" class="font-mono">{{ number_format((float)$row->total_invoiced, 2) }}</td>
                    <td style="text-align:right;" class="font-mono">{{ number_format((float)$row->total_paid, 2) }}</td>
                    <td style="text-align:right; font-weight:bold;" class="font-mono">{{ number_format($balance, 2) }}</td>
                    <td style="text-align:right;" class="font-mono">{{ $pct }}%</td>
                </tr>
            @endforeach
        </tbody>
        <tfoot>
            <tr style="border-top:2px solid #000;">
                <td style="font-weight:bold;">TOTAL</td>
                <td style="text-align:right; font-weight:bold;" class="font-mono">{{ $rows->sum('invoice_count') }}</td>
                <td style="text-align:right; font-weight:bold;" class="font-mono">{{ number_format($grandInvoiced, 2) }}</td>
                <td style="text-align:right; font-weight:bold;" class="font-mono">{{ number_format($grandPaid, 2) }}</td>
                <td style="text-align:right; font-weight:bold;" class="font-mono">{{ number_format($grandBalance, 2) }}</td>
                <td></td>
            </tr>
        </tfoot>
    </table>
@endif

@endsection