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

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

@section('content')

@php
    $totalCost   = $levels->sum(fn($l) => ($l->quantity_on_hand ?? 0) * (float)($l->lot?->landed_cost_per_unit ?? $l->average_cost ?? 0));
    $totalSell   = $levels->sum(fn($l) => ($l->quantity_on_hand ?? 0) * (float)($l->lot?->selling_price ?? 0));
    $totalOutlet = $levels->sum(fn($l) => ($l->quantity_on_hand ?? 0) * (float)($l->lot?->outlet_price ?? 0));
    $totalFloor  = $levels->sum(fn($l) => ($l->quantity_on_hand ?? 0) * (float)($l->lot?->discount_cap ?? 0));
@endphp

    {{-- Summary cards --}}
    <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 at Cost<br><span style="font-size:14pt;" class="font-mono">{{ $currency }} {{ number_format($totalCost, 0) }}</span>
            </td>
            <td style="border:none;padding:8px 16px;background:#d1fae5;text-align:center;font-weight:bold;">
                Total at Selling<br><span style="font-size:14pt;" class="font-mono">{{ $currency }} {{ number_format($totalSell, 0) }}</span>
            </td>
            <td style="border:none;padding:8px 16px;background:#fef3c7;text-align:center;font-weight:bold;">
                Total at Outlet<br><span style="font-size:14pt;" class="font-mono">{{ $currency }} {{ number_format($totalOutlet, 0) }}</span>
            </td>
            <td style="border:none;padding:8px 16px;background:#f3f4f6;text-align:center;font-weight:bold;">
                Discount Floor<br><span style="font-size:14pt;" class="font-mono">{{ $currency }} {{ number_format($totalFloor, 0) }}</span>
            </td>
        </tr>
    </table>

    {{-- Detail table grouped by location --}}
    @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;">Lot</th>
                    <th style="color:#fff;text-align:right;">Qty</th>
                    <th style="color:#fff;text-align:right;">Cost/Unit</th>
                    <th style="color:#fff;text-align:right;">Total at Cost</th>
                    <th style="color:#fff;text-align:right;">Selling Price</th>
                    <th style="color:#fff;text-align:right;">Total at Selling</th>
                    <th style="color:#fff;text-align:right;">Margin %</th>
                </tr>
            </thead>
            <tbody>
                @foreach($locationLevels as $i => $level)
                @php
                    $qty    = $level->quantity_on_hand ?? 0;
                    $cost   = (float)($level->lot?->landed_cost_per_unit ?? $level->average_cost ?? 0);
                    $sell   = (float)($level->lot?->selling_price ?? 0);
                    $margin = $sell > 0 && $cost > 0 ? round((($sell - $cost) / $sell) * 100, 1) : null;
                    $lowMargin = $margin !== null && $margin < 0;
                    $highMargin = $margin !== null && $margin > 30;
                    $rowClass = $lowMargin ? 'bg-red' : ($highMargin ? 'bg-green' : '');
                @endphp
                <tr class="avoid-break-inside {{ $rowClass }}">
                    <td>{{ $i + 1 }}</td>
                    <td>{{ $level->product?->name ?? '—' }}
                        @if($level->product?->sku)<br><span class="font-mono text-sm text-gray">{{ $level->product->sku }}</span>@endif
                    </td>
                    <td class="font-mono text-sm">{{ $level->lot?->lot_number ?? '—' }}</td>
                    <td class="text-right font-mono">{{ number_format($qty) }}</td>
                    <td class="text-right font-mono">{{ $cost > 0 ? number_format($cost, 4) : '—' }}</td>
                    <td class="text-right font-mono">{{ number_format($qty * $cost, 0) }}</td>
                    <td class="text-right font-mono">{{ $sell > 0 ? number_format($sell, 2) : '—' }}</td>
                    <td class="text-right font-mono">{{ $sell > 0 ? number_format($qty * $sell, 0) : '—' }}</td>
                    <td class="text-right font-mono {{ $lowMargin ? 'font-bold' : '' }}">
                        {{ $margin !== null ? $margin.'%' : '—' }}
                    </td>
                </tr>
                @endforeach
                @php
                    $locCost = $locationLevels->sum(fn($l) => ($l->quantity_on_hand ?? 0) * (float)($l->lot?->landed_cost_per_unit ?? $l->average_cost ?? 0));
                    $locSell = $locationLevels->sum(fn($l) => ($l->quantity_on_hand ?? 0) * (float)($l->lot?->selling_price ?? 0));
                @endphp
                <tr class="bg-subhdr">
                    <td colspan="5" class="text-right font-bold">{{ $locationName }} Subtotal</td>
                    <td class="text-right font-mono font-bold">{{ number_format($locCost, 0) }}</td>
                    <td></td>
                    <td class="text-right font-mono font-bold">{{ $locSell > 0 ? number_format($locSell, 0) : '—' }}</td>
                    <td></td>
                </tr>
            </tbody>
        </table>
    @endforeach

    {{-- Grand totals --}}
    <table style="margin-top:16px;width:auto;margin-left:auto;">
        <tr class="bg-header">
            <td style="color:#fff;padding:8px 16px;font-weight:bold;">Grand Total — At Cost</td>
            <td style="color:#fff;padding:8px 24px;text-align:right;" class="font-mono font-bold">{{ $currency }} {{ number_format($totalCost, 0) }}</td>
        </tr>
        <tr>
            <td style="padding:6px 16px;font-weight:bold;">Grand Total — At Selling</td>
            <td style="padding:6px 24px;text-align:right;" class="font-mono">{{ $currency }} {{ number_format($totalSell, 0) }}</td>
        </tr>
    </table>

    {{-- 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 = Margin &lt; 0% (selling below cost)</span>
        <span style="background:#d1fae5;padding:2px 6px;margin-left:8px;">Green = Margin &gt; 30%</span>
    </div>

@endsection