@extends('documents.procurement._layout', [
    'documentTitle' => 'Landed Cost Report',
    'reference'     => $shipment->shipment_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('_', ' ', $shipment->status)) }}</strong>
    </div>
    @if($shipment->actual_arrival)
        <div style="font-size: 9pt; color: #444;">
            Arrived: {{ \Carbon\Carbon::parse($shipment->actual_arrival)->format('d M Y') }}
        </div>
    @endif
@endsection

@section('content')

    @php
        $items = $shipment->items;

        // Build a lookup: sourcingTripItemId → allocations keyed by type
        $allocsByItemType = [];
        foreach ($items as $item) {
            $id = $item->sourcing_trip_item_id;
            $allocsByItemType[$id] = [];
            foreach ($item->costAllocations as $alloc) {
                $allocsByItemType[$id][$alloc->allocation_type] = (float)($alloc->allocated_per_unit_base ?? 0);
            }
        }

        $types = ['freight', 'insurance', 'clearing_fee', 'haulage', 'tax', 'other_charge'];
        $typeLabels = [
            'freight'      => 'Freight',
            'insurance'    => 'Insurance',
            'clearing_fee' => 'CFA Fee',
            'haulage'      => 'Haulage',
            'tax'          => 'Tax',
            'other_charge' => 'Other',
        ];

        $colTotals = array_fill_keys($types, 0);
        $colTotals['source_cost']  = 0;
        $colTotals['landed_total'] = 0;
        $colTotals['landed_unit']  = 0;
    @endphp

    {{-- Cost allocation method key --}}
    @if($items->isNotEmpty() && $items->first()->costAllocations->isNotEmpty())
        @php
            $methodKey = collect($items->flatMap->costAllocations)
                ->pluck('method_used')
                ->unique()
                ->filter()
                ->values();
        @endphp
        @if($methodKey->count())
            <p style="font-size:9pt; color:#666; margin-bottom:12px;">
                Allocation method(s): {{ $methodKey->map(fn($m) => ucwords(str_replace('_', ' ', $m)))->join(', ') }}
            </p>
        @endif
    @endif

    <table class="table-compact">
        <colgroup>
            <col style="width:4%">
            <col style="width:18%">
            <col style="width:5%">
            <col style="width:10%">
            <col style="width:7%">{{-- freight --}}
            <col style="width:7%">{{-- insurance --}}
            <col style="width:7%">{{-- clearing_fee --}}
            <col style="width:7%">{{-- haulage --}}
            <col style="width:5%">{{-- tax --}}
            <col style="width:6%">{{-- other --}}
            <col style="width:10%">{{-- landed total --}}
            <col style="width:10%">{{-- landed/unit --}}
        </colgroup>
        <thead>
            <tr>
                <th>#</th>
                <th>Product</th>
                <th style="text-align:right;">Qty</th>
                <th style="text-align:right;">Src Cost/Unit</th>
                @foreach($types as $type)
                    <th style="text-align:right;">{{ $typeLabels[$type] }}/u</th>
                @endforeach
                <th style="text-align:right;">Landed Total</th>
                <th style="text-align:right;">Landed/Unit</th>
            </tr>
        </thead>
        <tbody>
            @foreach($items as $i => $item)
                @php
                    $tripItem = $item->sourcingTripItem;
                    $id       = $item->sourcing_trip_item_id;
                    $allocs   = $allocsByItemType[$id] ?? [];

                    $sourceCostPerUnit = $tripItem?->unit_source_price_base
                        ? (float)$tripItem->unit_source_price_base
                        : 0;

                    $allocSum = array_sum($allocs);
                    $landedPerUnit  = $sourceCostPerUnit + $allocSum;
                    $landedTotal    = $landedPerUnit * $item->quantity_shipped;

                    $colTotals['source_cost']  += $sourceCostPerUnit * $item->quantity_shipped;
                    $colTotals['landed_total'] += $landedTotal;
                    foreach ($types as $t) {
                        $colTotals[$t] += ($allocs[$t] ?? 0) * $item->quantity_shipped;
                    }
                @endphp
                <tr class="avoid-break-inside">
                    <td>{{ $i + 1 }}</td>
                    <td>{{ $tripItem?->product?->name ?? '—' }}</td>
                    <td style="text-align:right;" class="font-mono">{{ number_format($item->quantity_shipped, 0) }}</td>
                    <td style="text-align:right;" class="font-mono">{{ $sourceCostPerUnit > 0 ? number_format($sourceCostPerUnit, 4) : '—' }}</td>
                    @foreach($types as $type)
                        <td style="text-align:right;" class="font-mono">
                            {{ isset($allocs[$type]) && $allocs[$type] > 0 ? number_format($allocs[$type], 4) : '—' }}
                        </td>
                    @endforeach
                    <td style="text-align:right; font-weight:bold;" class="font-mono">{{ $landedTotal > 0 ? number_format($landedTotal, 2) : '—' }}</td>
                    <td style="text-align:right; font-weight:bold;" class="font-mono">{{ $landedPerUnit > 0 ? number_format($landedPerUnit, 4) : '—' }}</td>
                </tr>
            @endforeach
        </tbody>
        <tfoot>
            <tr style="font-weight:bold; border-top: 2px solid #000;">
                <td colspan="2">Totals (base currency)</td>
                <td></td>
                <td style="text-align:right;" class="font-mono">{{ $colTotals['source_cost'] > 0 ? number_format($colTotals['source_cost'], 2) : '—' }}</td>
                @foreach($types as $type)
                    <td style="text-align:right;" class="font-mono">{{ $colTotals[$type] > 0 ? number_format($colTotals[$type], 2) : '—' }}</td>
                @endforeach
                <td style="text-align:right;" class="font-mono">{{ $colTotals['landed_total'] > 0 ? number_format($colTotals['landed_total'], 2) : '—' }}</td>
                <td></td>
            </tr>
        </tfoot>
    </table>

    <p style="font-size:9pt; color:#666; margin-top:16px;">
        All figures are in the organisation's base currency.
        Source cost per unit converted at the trip's exchange rate.
    </p>

@endsection