@php
    $org = auth()->user()->organization ?? \App\Models\System\Organization::find(auth()->user()->organization_id);
@endphp
@extends('documents.procurement._layout', [
    'documentTitle' => 'Material Consumption',
    '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) · Confirmed consumptions only</div>
@endsection

@section('content')

@php
    $byProduct = $consumptions->groupBy('product_id');
    $totalQty  = $consumptions->sum('quantity_consumed');
    $totalCost = $consumptions->sum('total_cost_base');
@endphp

{{-- KPI 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;">
            Records<br><span style="font-size:18pt;">{{ $consumptions->count() }}</span>
        </td>
        <td style="border:none; padding:8px 14px; background:#ede9fe; text-align:center; font-weight:bold;">
            Raw Materials<br><span style="font-size:18pt;">{{ $byProduct->count() }}</span>
        </td>
        <td style="border:none; padding:8px 14px; background:#fef3c7; text-align:center; font-weight:bold;">
            Total Cost ({{ $currency }})<br><span style="font-size:18pt;">{{ number_format($totalCost, 0) }}</span>
        </td>
    </tr>
</table>

@if($consumptions->isEmpty())
    <p style="color:#666; font-style:italic;">No confirmed material consumptions found for this period.</p>
@else
    @foreach($byProduct as $productId => $productRows)
        @php
            $product    = $productRows->first()->product;
            $totalPQty  = $productRows->sum('quantity_consumed');
            $totalPCost = $productRows->sum('total_cost_base');
        @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 consumed: <strong>{{ number_format($totalPQty, 4) }} {{ $product?->uom ?? '' }}</strong>
            · Total cost: <strong>{{ $currency }} {{ number_format($totalPCost, 2) }}</strong>
        </p>
        <table class="table-compact avoid-break-inside">
            <thead>
                <tr>
                    <th>Production Order</th>
                    <th>Finished Product</th>
                    <th>Lot</th>
                    <th style="text-align:right;">Qty Consumed</th>
                    <th>UoM</th>
                    <th style="text-align:right;">Unit Cost ({{ $currency }})</th>
                    <th style="text-align:right;">Total Cost ({{ $currency }})</th>
                    <th>Confirmed</th>
                </tr>
            </thead>
            <tbody>
                @foreach($productRows as $c)
                    <tr class="avoid-break-inside">
                        <td class="font-mono" style="font-size:8pt;">{{ $c->productionOrder?->production_reference ?? '—' }}</td>
                        <td style="font-size:8pt;">{{ $c->productionOrder?->product?->name ?? '—' }}</td>
                        <td class="font-mono" style="font-size:8pt;">{{ $c->lot?->lot_number ?? '—' }}</td>
                        <td style="text-align:right;" class="font-mono">{{ number_format((float) ($c->quantity_consumed ?? 0), 4) }}</td>
                        <td style="font-size:8pt;">{{ $c->quantity_uom ?? $product?->uom ?? '—' }}</td>
                        <td style="text-align:right;" class="font-mono">{{ number_format((float) $c->unit_cost_snapshot_base, 4) }}</td>
                        <td style="text-align:right;" class="font-mono">{{ number_format((float) $c->total_cost_base, 2) }}</td>
                        <td style="font-size:8pt;">{{ $c->consumed_at ? \Carbon\Carbon::parse($c->consumed_at)->format('d M Y') : '—' }}</td>
                    </tr>
                @endforeach
            </tbody>
        </table>
    @endforeach

    {{-- Grand total --}}
    <table style="margin-top:16px; width:40%; margin-left:auto; border:none;">
        <tr style="border-top:2px solid #000;">
            <td style="border:none; padding:6px 8px; text-align:right; font-weight:bold;">Grand Total Cost ({{ $currency }})</td>
            <td style="border:none; padding:6px 8px; text-align:right; font-weight:bold;" class="font-mono">{{ number_format($totalCost, 2) }}</td>
        </tr>
    </table>
@endif

@endsection