@php
    $org = auth()->user()->organization ?? \App\Models\System\Organization::find(auth()->user()->organization_id);
    $documentTitle = 'Stock Position Report';
    $isPdf = false;
@endphp
@extends('documents.inventory._layout', [
    'documentTitle' => 'Stock Position Report',
    'reference'     => null,
    'documentDate'  => $reportDate,
])

@section('header-meta')
    <div class="text-sm" style="color:#444;margin-top:4px;">Generated: {{ $reportDate }}</div>
@endsection

@section('styles')
@php
    $totalOnHand  = $levels->sum('quantity_on_hand');
    $totalReserved = $levels->sum('quantity_reserved');
    $totalAvailable = $levels->sum(fn($l) => ($l->quantity_on_hand ?? 0) - ($l->quantity_reserved ?? 0));
    $belowMinCount = $levels->filter(fn($l) => ($l->quantity_on_hand ?? 0) < ($l->product?->minimum_stock_level ?? 0))->count();
    $mismatchCount = $levels->filter(fn($l) => ($l->active_serial_count ?? 0) !== ($l->quantity_on_hand ?? 0))->count();
@endphp
@endsection

@section('content')

    {{-- Summary strip --}}
    <table style="margin-bottom:20px;border:none;width:auto;">
        <tr>
            <td style="border:none;padding:8px 16px;background:#dbeafe;text-align:center;font-weight:bold;">
                Total Lines<br><span style="font-size:18pt;">{{ $levels->count() }}</span>
            </td>
            <td style="border:none;padding:8px 16px;background:#d1fae5;text-align:center;font-weight:bold;">
                On Hand<br><span style="font-size:18pt;">{{ number_format($totalOnHand) }}</span>
            </td>
            <td style="border:none;padding:8px 16px;background:#fef3c7;text-align:center;font-weight:bold;">
                Reserved<br><span style="font-size:18pt;">{{ number_format($totalReserved) }}</span>
            </td>
            <td style="border:none;padding:8px 16px;background:#d1fae5;text-align:center;font-weight:bold;">
                Available<br><span style="font-size:18pt;">{{ number_format($totalAvailable) }}</span>
            </td>
            @if($belowMinCount > 0)
            <td style="border:none;padding:8px 16px;background:#fee2e2;text-align:center;font-weight:bold;">
                ⚠ Below Minimum<br><span style="font-size:18pt;">{{ $belowMinCount }}</span>
            </td>
            @endif
            @if($mismatchCount > 0)
            <td style="border:none;padding:8px 16px;background:#fef3c7;text-align:center;font-weight:bold;">
                ⚠ Serial Mismatch<br><span style="font-size:18pt;">{{ $mismatchCount }}</span>
            </td>
            @endif
        </tr>
    </table>

    {{-- Main table --}}
    @php $byLocation = $levels->groupBy(fn($l) => $l->location?->name ?? 'Unknown'); @endphp
    @foreach($byLocation as $locationName => $locationLevels)
        <h2>{{ $locationName }}</h2>
        <table class="table-compact">
            <thead>
                <tr class="bg-header">
                    <th style="color:#fff;">#</th>
                    <th style="color:#fff;">Product</th>
                    <th style="color:#fff;">SKU</th>
                    <th style="color:#fff;">Lot</th>
                    <th style="color:#fff;text-align:right;">On Hand</th>
                    <th style="color:#fff;text-align:right;">Reserved</th>
                    <th style="color:#fff;text-align:right;">Available</th>
                    <th style="color:#fff;text-align:right;">Serial Records</th>
                    <th style="color:#fff;">Last Updated</th>
                </tr>
            </thead>
            <tbody>
                @foreach($locationLevels as $i => $level)
                @php
                    $avail   = ($level->quantity_on_hand ?? 0) - ($level->quantity_reserved ?? 0);
                    $belowMin = ($level->quantity_on_hand ?? 0) < ($level->product?->minimum_stock_level ?? 0);
                    $mismatch = ($level->active_serial_count ?? 0) !== ($level->quantity_on_hand ?? 0);
                    $rowClass = $belowMin ? 'bg-red' : ($mismatch ? 'bg-amber' : '');
                @endphp
                <tr class="avoid-break-inside {{ $rowClass }}">
                    <td>{{ $i + 1 }}</td>
                    <td>{{ $level->product?->name ?? '—' }}</td>
                    <td class="font-mono text-sm">{{ $level->product?->sku ?? '—' }}</td>
                    <td class="font-mono text-sm">{{ $level->lot?->lot_number ?? '—' }}</td>
                    <td class="text-right font-mono">{{ number_format($level->quantity_on_hand ?? 0) }}</td>
                    <td class="text-right font-mono">{{ number_format($level->quantity_reserved ?? 0) }}</td>
                    <td class="text-right font-mono {{ $avail <= 0 ? 'font-bold' : '' }}">{{ number_format($avail) }}</td>
                    <td class="text-right font-mono {{ $mismatch ? 'font-bold' : '' }}">{{ $level->active_serial_count ?? 0 }}</td>
                    <td class="text-sm">{{ $level->last_updated ? \Carbon\Carbon::parse($level->last_updated)->format('d M Y') : '—' }}</td>
                </tr>
                @endforeach
                <tr style="font-weight:bold;background:#f3f4f6;">
                    <td colspan="4" class="text-right">{{ $locationName }} Totals</td>
                    <td class="text-right font-mono">{{ number_format($locationLevels->sum('quantity_on_hand')) }}</td>
                    <td class="text-right font-mono">{{ number_format($locationLevels->sum('quantity_reserved')) }}</td>
                    <td class="text-right font-mono">{{ number_format($locationLevels->sum(fn($l) => ($l->quantity_on_hand ?? 0) - ($l->quantity_reserved ?? 0))) }}</td>
                    <td></td><td></td>
                </tr>
            </tbody>
        </table>
    @endforeach

    {{-- Legend --}}
    <div style="margin-top:16px;" class="text-sm text-gray">
        <strong>Legend:</strong>
        <span style="background:#fee2e2;padding:2px 6px;margin-left:8px;">Red = Below minimum stock level</span>
        <span style="background:#fef3c7;padding:2px 6px;margin-left:8px;">Amber = Serial records don't match on-hand qty</span>
    </div>

@endsection