@php
    $org = auth()->user()->organization ?? \App\Models\System\Organization::find(auth()->user()->organization_id);
@endphp
@extends('documents.procurement._layout', [
    'documentTitle' => 'Purchase History by Product',
    '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> (base)</div>
@endsection

@section('content')

<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;">
            Products<br><span style="font-size:18pt;">{{ $byProduct->count() }}</span>
        </td>
        <td style="border:none; padding:8px 14px; background:#ede9fe; text-align:center; font-weight:bold;">
            Total Lines<br><span style="font-size:18pt;">{{ $items->count() }}</span>
        </td>
        <td style="border:none; padding:8px 14px; background:#d1fae5; text-align:center; font-weight:bold;">
            Total Qty Ordered<br><span style="font-size:18pt;">{{ number_format($items->sum('quantity')) }}</span>
        </td>
    </tr>
</table>

@if($byProduct->isEmpty())
    <p style="color:#666; font-style:italic;">No purchase history found for this period.</p>
@else
    @foreach($byProduct as $productId => $productItems)
        @php
            $product = $productItems->first()->product;
            $totalQty = $productItems->sum('quantity');
            $totalCost = $productItems->sum('total_cost_source');
            $avgUnit = $totalQty > 0 ? $totalCost / $totalQty : 0;
        @endphp
        <h2 class="avoid-break-inside">
            {{ $product?->name ?? '—' }}
            @if($product?->sku) <span style="font-size:9pt; font-weight:normal; color:#666; font-family:monospace;">{{ $product->sku }}</span> @endif
        </h2>
        <p style="font-size:9pt; color:#666; margin-bottom:6px;">
            Total ordered: <strong>{{ number_format($totalQty) }} {{ $product?->uom ?? '' }}</strong>
            · Total cost: <strong>{{ number_format($totalCost, 2) }}</strong>
            · Avg unit cost: <strong>{{ number_format($avgUnit, 4) }}</strong>
        </p>
        <table class="table-compact avoid-break-inside">
            <thead>
                <tr>
                    <th>LPO Ref</th>
                    <th>Supplier</th>
                    <th>Date</th>
                    <th>Status</th>
                    <th style="text-align:right;">Qty</th>
                    <th>UoM</th>
                    <th style="text-align:right;">Unit Cost (src)</th>
                    <th style="text-align:right;">Total Cost (src)</th>
                </tr>
            </thead>
            <tbody>
                @foreach($productItems as $item)
                    <tr class="avoid-break-inside">
                        <td class="font-mono" style="font-size:9pt;">{{ $item->lpo?->lpo_reference ?? '—' }}</td>
                        <td style="font-size:9pt;">{{ $item->lpo?->supplier?->name ?? '—' }}</td>
                        <td style="font-size:9pt;">{{ $item->lpo?->purchase_date ? \Carbon\Carbon::parse($item->lpo->purchase_date)->format('d M Y') : '—' }}</td>
                        <td style="font-size:9pt;">{{ $item->lpo?->status ? ucwords(str_replace('_',' ',$item->lpo->status)) : '—' }}</td>
                        <td style="text-align:right;" class="font-mono">{{ number_format((float)$item->quantity, 0) }}</td>
                        <td style="font-size:9pt;">{{ $item->quantity_uom ?? $product?->uom ?? '—' }}</td>
                        <td style="text-align:right;" class="font-mono">{{ number_format((float)$item->unit_cost_source, 4) }}</td>
                        <td style="text-align:right;" class="font-mono">{{ number_format((float)$item->total_cost_source, 2) }}</td>
                    </tr>
                @endforeach
            </tbody>
        </table>
    @endforeach
@endif

@endsection