@extends('documents.inventory._layout', [
    'documentTitle' => 'Stock Take Variance Report',
    'reference'     => $take->reference,
    'documentDate'  => $take->completed_date ? \Carbon\Carbon::parse($take->completed_date)->format('d M Y') : now()->format('d M Y'),
])

@section('header-meta')
    <div class="text-sm" style="color:#444;margin-top:4px;">
        Location: <strong>{{ $take->location?->name ?? '—' }}</strong>
    </div>
    <div class="text-sm" style="color:#444;">
        Status: <strong>{{ ucwords(str_replace('_', ' ', $take->status)) }}</strong>
    </div>
@endsection

@section('content')

@php
    $itemsWithVariance = $take->items->filter(fn($i) => $i->variance !== 0 && $i->variance !== null);
    $surplus   = $take->items->filter(fn($i) => ($i->variance ?? 0) > 0);
    $shortage  = $take->items->filter(fn($i) => ($i->variance ?? 0) < 0);
    $matched   = $take->items->filter(fn($i) => ($i->variance ?? 0) === 0);
    $totalSystem  = $take->items->sum('system_quantity');
    $totalCounted = $take->items->sum('counted_quantity');
    $totalVariance = $totalCounted - $totalSystem;
@endphp

    {{-- Summary --}}
    <table style="margin-bottom:20px;border:none;width:auto;">
        <tr>
            <td style="border:none;padding:8px 16px;background:#d1fae5;font-weight:bold;text-align:center;">
                ✓ Matched<br><span style="font-size:18pt;">{{ $matched->count() }}</span>
            </td>
            <td style="border:none;padding:8px 16px;background:#dbeafe;font-weight:bold;text-align:center;">
                ↑ Surplus<br><span style="font-size:18pt;">{{ $surplus->count() }}</span>
            </td>
            <td style="border:none;padding:8px 16px;background:#fef3c7;font-weight:bold;text-align:center;">
                ↓ Shortage<br><span style="font-size:18pt;">{{ $shortage->count() }}</span>
            </td>
            <td style="border:none;padding:8px 16px;background:#f3f4f6;font-weight:bold;text-align:center;">
                Total Lines<br><span style="font-size:18pt;">{{ $take->items->count() }}</span>
            </td>
            <td style="border:none;padding:8px 16px;background:{{ $totalVariance < 0 ? '#fef3c7' : '#d1fae5' }};font-weight:bold;text-align:center;">
                Net Variance<br><span style="font-size:18pt;">{{ $totalVariance >= 0 ? '+' : '' }}{{ number_format($totalVariance) }}</span>
            </td>
        </tr>
    </table>

    <table style="margin-bottom:16px;border:none;">
        <tr>
            <td style="border:none;width:180px;font-weight:bold;padding:3px 8px 3px 0;">Initiated By</td>
            <td style="border:none;padding:3px 20px 3px 0;">{{ $take->initiatedBy?->name ?? '—' }}</td>
            <td style="border:none;width:180px;font-weight:bold;padding:3px 8px 3px 0;">Initiated Date</td>
            <td style="border:none;">{{ $take->initiated_date ? \Carbon\Carbon::parse($take->initiated_date)->format('d M Y') : '—' }}</td>
        </tr>
        @if($take->approvedBy)
        <tr>
            <td style="border:none;font-weight:bold;padding:3px 8px 3px 0;">Approved / Posted By</td>
            <td style="border:none;padding:3px 20px 3px 0;">{{ $take->approvedBy->name }}</td>
            <td style="border:none;font-weight:bold;padding:3px 8px 3px 0;">Posted Date</td>
            <td style="border:none;">{{ $take->posted_date ? \Carbon\Carbon::parse($take->posted_date)->format('d M Y') : '—' }}</td>
        </tr>
        @endif
    </table>

    {{-- All items table --}}
    <h2>Count Results</h2>
    <table class="table-compact">
        <thead>
            <tr class="bg-header">
                <th style="color:#fff;width:30px;">#</th>
                <th style="color:#fff;">Product</th>
                <th style="color:#fff;">Lot</th>
                <th style="color:#fff;text-align:right;">System Qty</th>
                <th style="color:#fff;text-align:right;">Counted Qty</th>
                <th style="color:#fff;text-align:right;">Variance</th>
                <th style="color:#fff;">Variance Reason</th>
                <th style="color:#fff;">Counted By</th>
            </tr>
        </thead>
        <tbody>
            @foreach($take->items as $i => $item)
            @php
                $v = $item->variance ?? 0;
                $rowClass = $v > 0 ? 'bg-blue' : ($v < 0 ? 'bg-amber' : '');
            @endphp
            <tr class="avoid-break-inside {{ $rowClass }}">
                <td>{{ $i + 1 }}</td>
                <td>
                    {{ $item->product?->name ?? '—' }}
                    @if($item->product?->sku)<br><span class="font-mono text-sm text-gray">{{ $item->product->sku }}</span>@endif
                </td>
                <td class="font-mono text-sm">{{ $item->lot?->lot_number ?? '—' }}</td>
                <td class="text-right font-mono">{{ number_format($item->system_quantity) }}</td>
                <td class="text-right font-mono">{{ $item->counted_quantity !== null ? number_format($item->counted_quantity) : '—' }}</td>
                <td class="text-right font-mono {{ $v !== 0 ? 'font-bold' : '' }}">
                    @if($v !== 0){{ $v > 0 ? '+' : '' }}{{ number_format($v) }}@else —@endif
                </td>
                <td class="text-sm">{{ $item->variance_reason ?? ($v === 0 ? '—' : 'Not specified') }}</td>
                <td class="text-sm">{{ $item->countedBy?->name ?? '—' }}</td>
            </tr>
            @endforeach
        </tbody>
        <tfoot>
            <tr style="font-weight:bold;">
                <td colspan="3" class="text-right">Totals</td>
                <td class="text-right font-mono">{{ number_format($totalSystem) }}</td>
                <td class="text-right font-mono">{{ number_format($totalCounted) }}</td>
                <td class="text-right font-mono">{{ $totalVariance >= 0 ? '+' : '' }}{{ number_format($totalVariance) }}</td>
                <td colspan="2"></td>
            </tr>
        </tfoot>
    </table>

    @if($take->status === 'posted')
    <p class="text-sm text-gray" style="margin-top:8px;">
        ✓ Adjustment movements have been posted for all non-zero variances.
    </p>
    @endif

@endsection