@extends('documents.procurement._layout', [
    'documentTitle' => 'Item Sourcing Report',
    'reference'     => $sourcingTrip->trip_reference,
    'documentDate'  => now()->format('d M Y'),
])

@section('header-meta')
    <div style="font-size: 9pt; color: #444; margin-top: 4px;">
        Status: <strong>{{ ucwords(str_replace('_', ' ', $sourcingTrip->status)) }}</strong>
    </div>
    @if($sourcingTrip->return_date)
        <div style="font-size: 9pt; color: #444;">
            Returned: {{ \Carbon\Carbon::parse($sourcingTrip->return_date)->format('d M Y') }}
        </div>
    @endif
@endsection

@section('content')

    @php
        $currency      = $sourcingTrip->source_currency_code ?? '';
        $items         = $sourcingTrip->items;
        $totalEstQty   = $items->sum('planned_quantity');
        $totalSrcQty   = $items->sum('sourced_quantity');
        $totalEstCost  = $items->sum(fn($i) => (float)($i->estimated_total_source_cost ?? 0));
        $totalActCost  = $items->sum(fn($i) => isset($i->unit_source_price, $i->sourced_quantity)
            ? $i->unit_source_price * $i->sourced_quantity : 0);
        $unavailableItems = $items->where('status', 'unavailable');
        $sourcedItems     = $items->where('status', '!=', 'unavailable');
    @endphp

    {{-- Summary block --}}
    <table style="margin-bottom: 20px; border: none;">
        <tbody>
            <tr>
                <td style="border:none; padding:4px 8px 4px 0; font-weight:bold; width:200px;">Destination Countries</td>
                <td style="border:none; padding:4px 0;">{{ implode(', ', $sourcingTrip->destination_countries ?? []) ?: '—' }}</td>
            </tr>
            @if($sourcingTrip->actual_departure)
                <tr>
                    <td style="border:none; padding:4px 8px 4px 0; font-weight:bold;">Departed</td>
                    <td style="border:none; padding:4px 0;">{{ \Carbon\Carbon::parse($sourcingTrip->actual_departure)->format('d M Y') }}</td>
                </tr>
            @endif
            @if($sourcingTrip->return_date)
                <tr>
                    <td style="border:none; padding:4px 8px 4px 0; font-weight:bold;">Returned</td>
                    <td style="border:none; padding:4px 0;">{{ \Carbon\Carbon::parse($sourcingTrip->return_date)->format('d M Y') }}</td>
                </tr>
            @endif
            <tr>
                <td style="border:none; padding:4px 8px 4px 0; font-weight:bold;">Source Currency</td>
                <td style="border:none; padding:4px 0;">{{ $currency }} @ {{ number_format($sourcingTrip->exchange_rate ?? 0, 4) }} to base</td>
            </tr>
        </tbody>
    </table>

    {{-- Cost summary cards --}}
    <table style="margin-bottom: 24px;">
        <thead>
            <tr>
                <th>Items Planned</th>
                <th>Items Sourced / Partial</th>
                <th>Items Unavailable</th>
                <th style="text-align:right;">Total Est. Cost ({{ $currency }})</th>
                <th style="text-align:right;">Total Actual Cost ({{ $currency }})</th>
                <th style="text-align:right;">Variance ({{ $currency }})</th>
            </tr>
        </thead>
        <tbody>
            <tr style="font-weight:bold;">
                <td>{{ $items->count() }}</td>
                <td>{{ $sourcedItems->count() }}</td>
                <td>{{ $unavailableItems->count() }}</td>
                <td style="text-align:right;" class="font-mono">{{ $totalEstCost > 0 ? number_format($totalEstCost, 2) : '—' }}</td>
                <td style="text-align:right;" class="font-mono">{{ $totalActCost > 0 ? number_format($totalActCost, 2) : '—' }}</td>
                <td style="text-align:right;" class="font-mono">
                    @if($totalEstCost > 0 && $totalActCost > 0)
                        {{ ($totalActCost <= $totalEstCost ? '−' : '+') . number_format(abs($totalActCost - $totalEstCost), 2) }}
                    @else
                        —
                    @endif
                </td>
            </tr>
        </tbody>
    </table>

    {{-- Detailed items --}}
    <h2>Item-by-Item Comparison</h2>
    <table class="table-compact">
        <colgroup>
            <col style="width:4%">
            <col style="width:22%">
            <col style="width:14%">
            <col style="width:8%">
            <col style="width:8%">
            <col style="width:7%">
            <col style="width:9%">
            <col style="width:9%">
            <col style="width:7%">
            <col style="width:9%">
            <col style="width:8%">{{-- status --}}
        </colgroup>
        <thead>
            <tr>
                <th>#</th>
                <th>Product</th>
                <th>Supplier</th>
                <th style="text-align:right;">Planned Qty</th>
                <th style="text-align:right;">Sourced Qty</th>
                <th style="text-align:right;">Δ Qty</th>
                <th style="text-align:right;">Est. Unit Price</th>
                <th style="text-align:right;">Act. Unit Price</th>
                <th style="text-align:right;">Δ Price</th>
                <th style="text-align:right;">Act. Total</th>
                <th>Status</th>
            </tr>
        </thead>
        <tbody>
            @foreach($items as $i => $item)
                @php
                    $dQty   = ($item->sourced_quantity ?? 0) - $item->planned_quantity;
                    $dPrice = isset($item->unit_source_price, $item->estimated_unit_source_price)
                        ? $item->unit_source_price - $item->estimated_unit_source_price
                        : null;
                    $actTotal = isset($item->unit_source_price, $item->sourced_quantity)
                        ? $item->unit_source_price * $item->sourced_quantity : null;
                @endphp
                <tr class="avoid-break-inside" @if($item->status === 'unavailable') style="background:#fef2f2;" @endif>
                    <td>{{ $i + 1 }}</td>
                    <td>{{ $item->product?->name ?? '—' }}</td>
                    <td>{{ $item->supplier?->name ?? '—' }}</td>
                    <td style="text-align:right;" class="font-mono">{{ number_format($item->planned_quantity, 0) }}</td>
                    <td style="text-align:right;" class="font-mono">{{ $item->sourced_quantity !== null ? number_format($item->sourced_quantity, 0) : '—' }}</td>
                    <td style="text-align:right;" class="font-mono">
                        @if($item->sourced_quantity !== null)
                            {{ ($dQty >= 0 ? '+' : '') . number_format($dQty, 0) }}
                        @else
                            —
                        @endif
                    </td>
                    <td style="text-align:right;" class="font-mono">{{ $item->estimated_unit_source_price ? number_format($item->estimated_unit_source_price, 2) : '—' }}</td>
                    <td style="text-align:right;" class="font-mono">{{ $item->unit_source_price ? number_format($item->unit_source_price, 2) : '—' }}</td>
                    <td style="text-align:right;" class="font-mono">
                        {{ $dPrice !== null ? (($dPrice >= 0 ? '+' : '') . number_format($dPrice, 2)) : '—' }}
                    </td>
                    <td style="text-align:right;" class="font-mono">{{ $actTotal !== null ? number_format($actTotal, 2) : '—' }}</td>
                    <td style="font-size:9pt;">{{ ucwords(str_replace('_', ' ', $item->status)) }}</td>
                </tr>
            @endforeach
        </tbody>
    </table>

    {{-- Unavailable items --}}
    @if($unavailableItems->count())
        <h2 class="page-break-before">Unavailable Items</h2>
        <table>
            <thead>
                <tr>
                    <th>Product</th>
                    <th>Planned Qty</th>
                    <th>Reason</th>
                </tr>
            </thead>
            <tbody>
                @foreach($unavailableItems as $item)
                    <tr class="avoid-break-inside">
                        <td>{{ $item->product?->name ?? '—' }}</td>
                        <td class="font-mono">{{ number_format($item->planned_quantity, 0) }}</td>
                        <td>{{ $item->unavailability_reason ?? '—' }}</td>
                    </tr>
                @endforeach
            </tbody>
        </table>
    @endif

@endsection