@php
    $org = auth()->user()->organization ?? \App\Models\System\Organization::find(auth()->user()->organization_id);
@endphp
@extends('documents.procurement._layout', [
    'documentTitle' => 'Production Cost Analysis',
    'reference'     => null,
    'documentDate'  => $reportDate,
    'noAutoPrint'   => true,
])

@section('header-meta')
    <div style="font-size:9pt; color:#444; margin-top:4px;">
        Completion 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) · Completed orders only</div>
@endsection

@section('content')

@php
    $types = ['material', 'labour', 'overhead', 'other'];
@endphp

@if($orders->isEmpty())
    <p style="color:#666; font-style:italic;">No completed production orders found for this period.</p>
@else
<table class="table-compact">
    <thead>
        <tr>
            <th rowspan="2">Reference</th>
            <th rowspan="2">Product</th>
            <th colspan="2" style="text-align:center;">Material</th>
            <th colspan="2" style="text-align:center;">Labour</th>
            <th colspan="2" style="text-align:center;">Overhead</th>
            <th colspan="2" style="text-align:center;">Other</th>
            <th colspan="3" style="text-align:center;">Total ({{ $currency }})</th>
        </tr>
        <tr>
            <th style="text-align:right; font-size:7pt;">Est.</th>
            <th style="text-align:right; font-size:7pt;">Act.</th>
            <th style="text-align:right; font-size:7pt;">Est.</th>
            <th style="text-align:right; font-size:7pt;">Act.</th>
            <th style="text-align:right; font-size:7pt;">Est.</th>
            <th style="text-align:right; font-size:7pt;">Act.</th>
            <th style="text-align:right; font-size:7pt;">Est.</th>
            <th style="text-align:right; font-size:7pt;">Act.</th>
            <th style="text-align:right; font-size:7pt;">Est.</th>
            <th style="text-align:right; font-size:7pt;">Act.</th>
            <th style="text-align:right; font-size:7pt;">Var.</th>
        </tr>
    </thead>
    <tbody>
        @php $grandEst = 0; $grandAct = 0; @endphp
        @foreach($orders as $order)
            @php
                $lines = $order->costLines->keyBy('cost_type');
                $totalEst = 0;
                $totalAct = 0;
                foreach ($types as $t) {
                    $totalEst += (float) ($lines[$t]?->estimated_amount_base ?? 0);
                    $totalAct += (float) ($lines[$t]?->amount_base ?? 0);
                }
                $variance = $totalAct - $totalEst;
                $grandEst += $totalEst;
                $grandAct += $totalAct;
            @endphp
            <tr class="avoid-break-inside">
                <td class="font-mono" style="font-size:8pt;">{{ $order->production_reference }}</td>
                <td style="font-size:8pt;">{{ $order->product?->name ?? '—' }}</td>
                @foreach($types as $type)
                    @php $line = $lines[$type] ?? null; @endphp
                    <td style="text-align:right; font-size:8pt;" class="font-mono">{{ number_format((float)($line?->estimated_amount_base ?? 0), 0) }}</td>
                    <td style="text-align:right; font-size:8pt;" class="font-mono">{{ number_format((float)($line?->amount_base ?? 0), 0) }}</td>
                @endforeach
                <td style="text-align:right;" class="font-mono font-bold">{{ number_format($totalEst, 0) }}</td>
                <td style="text-align:right;" class="font-mono font-bold">{{ number_format($totalAct, 0) }}</td>
                <td style="text-align:right; {{ $variance > 0 ? 'color:#b91c1c;' : ($variance < 0 ? 'color:#065f46;' : '') }}" class="font-mono font-bold">
                    {{ $variance >= 0 ? '+' : '' }}{{ number_format($variance, 0) }}
                </td>
            </tr>
        @endforeach
    </tbody>
    <tfoot>
        @php $grandVar = $grandAct - $grandEst; @endphp
        <tr style="font-weight:bold; border-top:2px solid #000;">
            <td colspan="2">Grand Totals</td>
            @foreach($types as $type)
                @php
                    $estSum = $orders->sum(fn($o) => (float)($o->costLines->firstWhere('cost_type', $type)?->estimated_amount_base ?? 0));
                    $actSum = $orders->sum(fn($o) => (float)($o->costLines->firstWhere('cost_type', $type)?->amount_base ?? 0));
                @endphp
                <td style="text-align:right;" class="font-mono">{{ number_format($estSum, 0) }}</td>
                <td style="text-align:right;" class="font-mono">{{ number_format($actSum, 0) }}</td>
            @endforeach
            <td style="text-align:right;" class="font-mono">{{ number_format($grandEst, 0) }}</td>
            <td style="text-align:right;" class="font-mono">{{ number_format($grandAct, 0) }}</td>
            <td style="text-align:right; {{ $grandVar > 0 ? 'color:#b91c1c;' : ($grandVar < 0 ? 'color:#065f46;' : '') }}" class="font-mono">
                {{ $grandVar >= 0 ? '+' : '' }}{{ number_format($grandVar, 0) }}
            </td>
        </tr>
    </tfoot>
</table>

<p style="font-size:8pt; color:#666; margin-top:10px;">
    Variance = Actual − Estimated. <span style="color:#b91c1c;">Red = over budget</span>. <span style="color:#065f46;">Green = under budget</span>.
</p>
@endif

@endsection