@extends('documents.inventory._layout', [
    'documentTitle' => 'Lot Detail Sheet',
    'reference'     => $lot->lot_number,
    'documentDate'  => now()->format('d M Y'),
])

@section('header-meta')
    <div class="text-sm" style="color:#444;margin-top:4px;">
        Source: <strong>{{ ucwords(str_replace('_', ' ', $lot->source_type)) }}</strong>
    </div>
    <div class="text-sm" style="color:#444;">
        Received: <strong>{{ $lot->received_date ? \Carbon\Carbon::parse($lot->received_date)->format('d M Y') : '—' }}</strong>
    </div>
@endsection

@section('content')

    {{-- Product & lot summary --}}
    <table style="margin-bottom:20px;border:none;">
        <tbody>
            <tr>
                <td style="border:none;padding:4px 8px 4px 0;font-weight:bold;width:200px;">Product</td>
                <td style="border:none;padding:4px 0;">
                    {{ $lot->product?->name ?? '—' }}
                    @if($lot->product?->sku) <span class="font-mono text-sm text-gray">({{ $lot->product->sku }})</span>@endif
                </td>
            </tr>
            <tr>
                <td style="border:none;padding:4px 8px 4px 0;font-weight:bold;">Received Location</td>
                <td style="border:none;padding:4px 0;">{{ $lot->receivedLocation?->name ?? '—' }} ({{ $lot->receivedLocation?->type ?? '' }})</td>
            </tr>
            <tr>
                <td style="border:none;padding:4px 8px 4px 0;font-weight:bold;">Qty Received</td>
                <td style="border:none;padding:4px 0;" class="font-mono">{{ number_format($lot->quantity_received) }} {{ $lot->quantity_uom ?? $lot->product?->uom ?? '' }}</td>
            </tr>
            <tr>
                <td style="border:none;padding:4px 8px 4px 0;font-weight:bold;">Current On Hand</td>
                <td style="border:none;padding:4px 0;" class="font-mono">
                    <strong>{{ number_format($currentStock) }}</strong>
                    @if($currentStock < $lot->quantity_received)
                        <span class="text-sm" style="color:#d97706;"> ({{ number_format($lot->quantity_received - $currentStock) }} issued/adjusted)</span>
                    @endif
                </td>
            </tr>
            @if($lot->batch_number)
            <tr>
                <td style="border:none;padding:4px 8px 4px 0;font-weight:bold;">Batch Number</td>
                <td style="border:none;padding:4px 0;" class="font-mono">{{ $lot->batch_number }}</td>
            </tr>
            @endif
            @if($lot->expiry_date)
            @php $expired = \Carbon\Carbon::parse($lot->expiry_date)->isPast(); @endphp
            <tr>
                <td style="border:none;padding:4px 8px 4px 0;font-weight:bold;">Expiry Date</td>
                <td style="border:none;padding:4px 0;" class="{{ $expired ? 'bg-red font-bold' : '' }}">
                    {{ \Carbon\Carbon::parse($lot->expiry_date)->format('d M Y') }}
                    {{ $expired ? ' ⚠ EXPIRED' : '' }}
                </td>
            </tr>
            @endif
            <tr>
                <td style="border:none;padding:4px 8px 4px 0;font-weight:bold;">Costing Method</td>
                <td style="border:none;padding:4px 0;">{{ strtoupper($lot->costing_method) }}</td>
            </tr>
        </tbody>
    </table>

    {{-- Pricing --}}
    <h2>Pricing</h2>
    <table style="margin-bottom:20px;">
        <thead>
            <tr class="bg-header">
                <th style="color:#fff;">Price Type</th>
                <th style="color:#fff;text-align:right;">Amount</th>
                <th style="color:#fff;">Details (snapshot at receipt)</th>
            </tr>
        </thead>
        <tbody>
            <tr>
                <td><strong>Landed Cost</strong></td>
                <td class="text-right font-mono">{{ $lot->landed_cost_per_unit ? number_format($lot->landed_cost_per_unit, 4) : '—' }}</td>
                <td class="text-sm text-gray">Per unit — batch-specific</td>
            </tr>
            @if($lot->selling_price)
            <tr class="bg-green">
                <td><strong>Selling Price</strong></td>
                <td class="text-right font-mono">{{ number_format($lot->selling_price, 2) }}</td>
                <td class="text-sm text-gray">
                    {{ $lot->selling_price_method ? ucwords(str_replace('_', ' ', $lot->selling_price_method)) : '' }}
                    @if($lot->margin_pct) · Margin: {{ $lot->margin_pct }}%@endif
                    @if($lot->markup_amount) · Markup: {{ number_format($lot->markup_amount, 2) }}@endif
                </td>
            </tr>
            @endif
            @if($lot->outlet_price)
            <tr>
                <td>Outlet Price</td>
                <td class="text-right font-mono">{{ number_format($lot->outlet_price, 2) }}</td>
                <td class="text-sm text-gray">{{ $lot->outlet_price_method ? ucwords(str_replace('_', ' ', $lot->outlet_price_method)) : '' }}</td>
            </tr>
            @endif
            @if($lot->discount_cap)
            <tr>
                <td>Discount Floor</td>
                <td class="text-right font-mono">{{ number_format($lot->discount_cap, 2) }}</td>
                <td class="text-sm text-gray">Minimum sale price</td>
            </tr>
            @endif
        </tbody>
    </table>

    {{-- Stock Movements --}}
    @if($lot->stockMovements->isNotEmpty())
    <h2>Stock Movements</h2>
    <table class="table-compact">
        <thead>
            <tr class="bg-header">
                <th style="color:#fff;">Date</th>
                <th style="color:#fff;">Type</th>
                <th style="color:#fff;text-align:right;">Qty</th>
                <th style="color:#fff;">From</th>
                <th style="color:#fff;">To</th>
                <th style="color:#fff;">Reason</th>
            </tr>
        </thead>
        <tbody>
            @foreach($lot->stockMovements as $m)
            <tr class="avoid-break-inside">
                <td>{{ \Carbon\Carbon::parse($m->moved_at)->format('d M Y') }}</td>
                <td>{{ ucwords(str_replace('_', ' ', $m->movement_type)) }}</td>
                <td class="text-right font-mono">{{ number_format($m->quantity) }}</td>
                <td class="text-sm">{{ $m->fromLocation?->name ?? '—' }}</td>
                <td class="text-sm">{{ $m->toLocation?->name ?? '—' }}</td>
                <td class="text-sm">{{ $m->adjustment_reason ?? '—' }}</td>
            </tr>
            @endforeach
        </tbody>
    </table>
    @endif

    {{-- Serial Numbers --}}
    @if($lot->product?->is_serialised && $lot->serialNumbers->isNotEmpty())
    <h2 class="page-break-before">Serial Numbers ({{ $lot->serialNumbers->count() }})</h2>
    @php
        $statusGroups = $lot->serialNumbers->groupBy('status');
        $statusColors = ['in_stock' => 'bg-green', 'reserved' => 'bg-amber', 'sold' => '', 'transferred' => 'bg-blue', 'written_off' => 'bg-red'];
    @endphp
    <table class="table-compact">
        <thead>
            <tr class="bg-header">
                <th style="color:#fff;width:30px;">#</th>
                <th style="color:#fff;">Serial Number</th>
                <th style="color:#fff;">Status</th>
            </tr>
        </thead>
        <tbody>
            @foreach($lot->serialNumbers->sortBy('serial_number') as $i => $sn)
            <tr class="avoid-break-inside {{ $statusColors[$sn->status] ?? '' }}">
                <td>{{ $i + 1 }}</td>
                <td class="font-mono">{{ $sn->serial_number }}</td>
                <td>{{ ucwords(str_replace('_', ' ', $sn->status)) }}</td>
            </tr>
            @endforeach
        </tbody>
    </table>
    @php
        $statusSummary = $lot->serialNumbers->groupBy('status')->map->count();
    @endphp
    <p class="text-sm text-gray" style="margin-top:8px;">
        @foreach($statusSummary as $status => $count)
            <strong>{{ ucwords(str_replace('_', ' ', $status)) }}</strong>: {{ $count }}{{ !$loop->last ? ' · ' : '' }}
        @endforeach
    </p>
    @endif

@endsection