@extends('documents.procurement._layout', [
    'documentTitle' => 'Production Completion Certificate',
    'reference'     => $order->production_reference,
    'documentDate'  => $order->completion_date ? \Carbon\Carbon::parse($order->completion_date)->format('d M Y') : now()->format('d M Y'),
])

@section('header-meta')
    <div style="font-size:9pt; margin-top:4px; padding:2px 8px; display:inline-block; background:#d1fae5; border:1px solid #059669; font-weight:bold; color:#065f46;">
        COMPLETED
    </div>
    @if($order->outputLot)
        <div style="font-size:9pt; color:#444; margin-top:4px;">
            Output Lot: <strong style="font-family:monospace;">{{ $order->outputLot->lot_number }}</strong>
        </div>
    @endif
@endsection

@section('content')

@php
    $src  = $order->source_currency_code;
    $base = auth()->user()->organization?->currency_code ?? 'UGX';
    $isForeign = $src !== $base;
    $netProduced = ($order->produced_quantity ?? 0) - ($order->rejected_quantity ?? 0);
    $costLines = $order->costLines->keyBy('cost_type');
    $types = ['material', 'labour', 'overhead', 'other'];
@endphp

{{-- Production Summary block --}}
<table style="margin-bottom:20px; border:none;">
    <tr>
        <td style="border:none; width:50%; vertical-align:top; padding:0 20px 0 0;">
            <strong style="font-size:10pt;">Production Details:</strong><br>
            Product: <strong>{{ $order->product?->name ?? '—' }}</strong><br>
            @if($order->product?->sku)
                SKU: <span style="font-family:monospace;">{{ $order->product->sku }}</span><br>
            @endif
            Production Location: <strong>{{ $order->location?->name ?? '—' }}</strong><br>
            Output Location: <strong>{{ $order->outputLocation?->name ?? $order->location?->name ?? '—' }}</strong><br>
        </td>
        <td style="border:none; width:50%; vertical-align:top;">
            <strong style="font-size:10pt;">Output Inventory Lot:</strong><br>
            @if($order->outputLot)
                Lot Number: <strong style="font-family:monospace;">{{ $order->outputLot->lot_number }}</strong><br>
                Qty Received: <strong>{{ number_format((float) $order->outputLot->quantity_received, 0) }}</strong>
                {{ $order->quantity_uom ?? $order->product?->uom ?? '' }}<br>
            @else
                — No output lot recorded —<br>
            @endif
            @if($order->bom)
                BOM: <span style="font-family:monospace;">{{ $order->bom->bom_reference }}</span>
                (v{{ $order->bom->version }})<br>
            @endif
        </td>
    </tr>
</table>

{{-- Quantities table --}}
<h2>Production Quantities</h2>
<table style="width:60%;" class="table-compact">
    <tbody>
        <tr>
            <td style="background:#f3f4f6; font-weight:bold;">Planned Quantity</td>
            <td style="text-align:right;" class="font-mono">{{ number_format($order->planned_quantity) }}</td>
            <td>{{ $order->quantity_uom ?? $order->product?->uom ?? '' }}</td>
        </tr>
        <tr>
            <td style="font-weight:bold;">Produced Quantity</td>
            <td style="text-align:right;" class="font-mono"><strong>{{ number_format($order->produced_quantity ?? 0) }}</strong></td>
            <td>{{ $order->quantity_uom ?? $order->product?->uom ?? '' }}</td>
        </tr>
        @if(($order->rejected_quantity ?? 0) > 0)
        <tr>
            <td style="color:#b91c1c;">Rejected (QC Fail)</td>
            <td style="text-align:right; color:#b91c1c;" class="font-mono">{{ number_format($order->rejected_quantity ?? 0) }}</td>
            <td>{{ $order->quantity_uom ?? $order->product?->uom ?? '' }}</td>
        </tr>
        @endif
        <tr style="background:#d1fae5; font-weight:bold;">
            <td>Net Quantity to Inventory</td>
            <td style="text-align:right;" class="font-mono"><strong>{{ number_format($netProduced) }}</strong></td>
            <td>{{ $order->quantity_uom ?? $order->product?->uom ?? '' }}</td>
        </tr>
    </tbody>
</table>

{{-- Rejection notes --}}
@if($order->rejection_notes)
    <p style="font-size:9pt; margin-top:8px;"><strong>QC Rejection Notes:</strong> {{ $order->rejection_notes }}</p>
@endif

{{-- Cost Breakdown (Estimated vs Actual) --}}
<h2>Production Cost Breakdown</h2>
<table class="table-compact">
    <thead>
        <tr>
            <th>Cost Type</th>
            <th style="text-align:right;">Estimated ({{ $src }})</th>
            <th style="text-align:right;">Actual ({{ $src }})</th>
            <th style="text-align:right;">Variance ({{ $src }})</th>
            @if($isForeign)
                <th style="text-align:right;">Actual ({{ $base }})</th>
            @endif
        </tr>
    </thead>
    <tbody>
        @php $totalEstSrc = 0; $totalActSrc = 0; $totalActBase = 0; @endphp
        @foreach($types as $type)
            @if(isset($costLines[$type]))
                @php
                    $line = $costLines[$type];
                    $est  = (float) $line->estimated_amount_source;
                    $act  = (float) $line->amount_source;
                    $var  = $act - $est;
                    $totalEstSrc  += $est;
                    $totalActSrc  += $act;
                    $totalActBase += (float) $line->amount_base;
                @endphp
                <tr class="avoid-break-inside">
                    <td><strong>{{ ucfirst($type) }}</strong></td>
                    <td style="text-align:right;" class="font-mono">{{ number_format($est, 2) }}</td>
                    <td style="text-align:right;" class="font-mono"><strong>{{ number_format($act, 2) }}</strong></td>
                    <td style="text-align:right; {{ $var > 0 ? 'color:#b91c1c;' : ($var < 0 ? 'color:#065f46;' : '') }}" class="font-mono">
                        {{ $var >= 0 ? '+' : '' }}{{ number_format($var, 2) }}
                    </td>
                    @if($isForeign)
                        <td style="text-align:right;" class="font-mono">{{ number_format((float) $line->amount_base, 2) }}</td>
                    @endif
                </tr>
            @endif
        @endforeach
    </tbody>
    <tfoot>
        @php $totalVar = $totalActSrc - $totalEstSrc; @endphp
        <tr style="font-weight:bold; border-top:2px solid #000;">
            <td>Total Production Cost</td>
            <td style="text-align:right;" class="font-mono">{{ $src }} {{ number_format($totalEstSrc, 2) }}</td>
            <td style="text-align:right;" class="font-mono">{{ $src }} {{ number_format($totalActSrc, 2) }}</td>
            <td style="text-align:right; {{ $totalVar > 0 ? 'color:#b91c1c;' : ($totalVar < 0 ? 'color:#065f46;' : '') }}" class="font-mono">
                {{ $totalVar >= 0 ? '+' : '' }}{{ $src }} {{ number_format($totalVar, 2) }}
            </td>
            @if($isForeign)
                <td style="text-align:right;" class="font-mono">{{ $base }} {{ number_format($totalActBase, 2) }}</td>
            @endif
        </tr>
        @if($netProduced > 0)
            @php $costPerUnit = $netProduced > 0 ? $totalActSrc / $netProduced : 0; @endphp
            <tr>
                <td colspan="{{ $isForeign ? 5 : 4 }}" style="text-align:right; font-size:9pt; color:#444; border:none;">
                    Cost per net unit: <strong class="font-mono">{{ $src }} {{ number_format($costPerUnit, 4) }}</strong>
                </td>
            </tr>
        @endif
    </tfoot>
</table>

{{-- Material Consumptions --}}
@php $confirmed = $order->materialConsumptions->filter(fn ($c) => $c->consumed_at !== null); @endphp
@if($confirmed->isNotEmpty())
<h2>Confirmed Material Consumptions</h2>
<table class="table-compact">
    <thead>
        <tr>
            <th>#</th>
            <th>Raw Material</th>
            <th>Lot</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($confirmed->values() as $i => $c)
            <tr class="avoid-break-inside">
                <td>{{ $i + 1 }}</td>
                <td><strong>{{ $c->product?->name ?? '—' }}</strong></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>{{ $c->quantity_uom ?? $c->product?->uom ?? '—' }}</td>
                <td style="text-align:right;" class="font-mono">{{ number_format((float) $c->unit_cost_snapshot_source, 4) }}</td>
                <td style="text-align:right;" class="font-mono">{{ number_format((float) $c->total_cost_source, 2) }}</td>
            </tr>
        @endforeach
    </tbody>
</table>
@endif

{{-- Notes --}}
@if($order->notes)
    <h2>Production Notes</h2>
    <p>{{ $order->notes }}</p>
@endif

{{-- Approval trail --}}
<h2>Approval Trail</h2>
<table class="table-compact" style="width:70%;">
    <tr>
        <td class="font-bold">Prepared by</td>
        <td>{{ $order->submittedBy?->name ?? '—' }}</td>
        <td>{{ $order->submitted_at ? \Carbon\Carbon::parse($order->submitted_at)->format('d M Y') : '—' }}</td>
    </tr>
    <tr>
        <td class="font-bold">Approved by</td>
        <td>{{ $order->approvedBy?->name ?? '—' }}</td>
        <td>{{ $order->approved_at ? \Carbon\Carbon::parse($order->approved_at)->format('d M Y') : '—' }}</td>
    </tr>
</table>

{{-- Signatures --}}
<table style="margin-top:40px; border:none;">
    <tr>
        <td style="border:none; width:33%; vertical-align:bottom; padding:0 20px 0 0; text-align:center;">
            <div style="border-top:1px solid #000; padding-top:4px; margin-top:40px;">
                Production Supervisor<br>
                <span style="font-size:9pt; color:#666;">Signature &amp; Date</span>
            </div>
        </td>
        <td style="border:none; width:33%; vertical-align:bottom; padding:0 20px; text-align:center;">
            <div style="border-top:1px solid #000; padding-top:4px; margin-top:40px;">
                Quality Control<br>
                <span style="font-size:9pt; color:#666;">Signature &amp; Date</span>
            </div>
        </td>
        <td style="border:none; width:33%; vertical-align:bottom; text-align:center;">
            <div style="border-top:1px solid #000; padding-top:4px; margin-top:40px;">
                Finance / Costing<br>
                <span style="font-size:9pt; color:#666;">Signature &amp; Date</span>
            </div>
        </td>
    </tr>
</table>

@endsection