@extends('layouts.finance')

@section('title', 'Inventory')
@section('subtitle', 'Voucher stock, costs and margins')

@section('content')
    @php
        $dateFilter = $dateFilter ?? ['active' => false, 'from' => null, 'to' => null, 'label' => null];
        $activeTab = $activeTab ?? request('tab', 'available');
        $rangeParams = ($dateFilter['active'] ?? false) ? ['from' => $dateFilter['from'], 'to' => $dateFilter['to']] : [];
        $soldVouchers = $soldVouchers ?? collect();
        $soldVoucherError = $soldVoucherError ?? null;
        $soldVoucherRange = $soldVoucherRange ?? ['label' => now()->startOfMonth()->format('d M Y').' to '.now()->endOfMonth()->format('d M Y')];
        $totalUnits = $products->sum(fn($p) => $p->stock);
        $totalValuePkr = $products->sum(fn($p) => (float) ($p->total_cost ?? ($p->stock * (float) $p->cost_price)));
        $soldQty = $soldVouchers->sum(fn($row) => (int) ($row['sold_qty'] ?? 0));
        $soldRevenue = $soldVouchers->sum(fn($row) => (float) ($row['revenue'] ?? 0));
        $soldProfit = $soldVouchers->sum(fn($row) => (float) ($row['profit'] ?? 0));
    @endphp
    @include('dashboard.cards._date-filter', [
        'dateFilter' => $dateFilter,
        'filterRoute' => 'finance.inventory',
        'filterHidden' => ['tab' => $activeTab],
    ])

    <div class="card mb" style="padding:8px;display:inline-flex;gap:8px;align-items:center">
        <a class="btn {{ $activeTab === 'available' ? 'btn-primary' : '' }}"
           href="{{ route('finance.inventory', array_merge($rangeParams, ['tab' => 'available'])) }}">
            Available Vouchers
        </a>
        <a class="btn {{ $activeTab === 'sold' ? 'btn-primary' : '' }}"
           href="{{ route('finance.inventory', array_merge($rangeParams, ['tab' => 'sold'])) }}">
            Sold Vouchers
        </a>
    </div>

    @if($activeTab === 'available')
        <div class="grid grid-3 mb">
            @include('partials.kpi', ['label' => 'SKUs', 'value' => $products->count()])
            @include('partials.kpi', ['label' => 'Total Units', 'value' => number_format($totalUnits)])
            @include('partials.kpi', ['label' => 'Total Value', 'value' => 'PKR '.number_format($totalValuePkr, 2)])
        </div>

        <section class="card">
            <div class="section-head">
                <h2>Available Voucher Inventory</h2>
                <div class="flex items-center gap-2">
                    <a href="{{ route('finance.inventory.expiry-priority.index') }}" class="btn btn-sm">Expiry Priority</a>
                    <span class="pill">{{ $inventorySource ?? 'examism_v3' }}</span>
                </div>
            </div>
            @if($inventoryError)
                <div class="card-pad">
                    <div class="muted">{{ $inventoryError }}</div>
                </div>
            @endif
            <table>
                <thead><tr><th>SKU</th><th>Name</th><th>Source</th><th>Available Qty</th><th>Avg Cost</th><th>Total Cost</th><th>Sell</th><th>Cur.</th></tr></thead>
                <tbody>
                @forelse($products as $product)
                    <tr>
                        <td>{{ $product->sku }}</td>
                        <td>{{ $product->name }}</td>
                        <td>{{ $product->category }}</td>
                        <td>{{ number_format($product->stock) }}</td>
                        <td>{{ $metrics->money($product->cost_price, $product->currency) }}</td>
                        <td>{{ $metrics->money($product->total_cost ?? ($product->stock * (float) $product->cost_price), $product->currency) }}</td>
                        <td>{{ $metrics->money($product->selling_price, $product->currency) }}</td>
                        <td>{{ $product->currency }}</td>
                    </tr>
                @empty
                    <tr><td colspan="8" class="muted">No available inventory found in examism_v3.</td></tr>
                @endforelse
                </tbody>
            </table>
        </section>
    @else

    <section class="card">
        <div class="section-head">
            <div>
                <h2>Sold Vouchers</h2>
                <div class="muted text-sm">Sale price and profit for {{ $soldVoucherRange['label'] }}</div>
            </div>
            <span class="pill">{{ number_format($soldQty) }} sold</span>
        </div>
        @if($soldVoucherError)
            <div class="card-pad">
                <div class="muted">{{ $soldVoucherError }}</div>
            </div>
        @endif
        <div class="grid grid-3 card-pad" style="gap:12px;padding-top:0">
            @include('partials.kpi', ['label' => 'Sold Qty', 'value' => number_format($soldQty)])
            @include('partials.kpi', ['label' => 'Sale Amount', 'value' => $metrics->money($soldRevenue, 'PKR'), 'color' => '#10b981'])
            @include('partials.kpi', ['label' => 'Profit', 'value' => $metrics->money($soldProfit, 'PKR'), 'color' => $soldProfit >= 0 ? '#10b981' : '#ef4444'])
        </div>
        <table>
            <thead>
                <tr>
                    <th>Voucher</th>
                    <th style="width:120px">Sold Qty</th>
                    <th style="width:150px">Avg Sale Price</th>
                    <th style="width:150px">Total Sale</th>
                    <th style="width:150px">Avg Buying</th>
                    <th style="width:150px">Total Cost</th>
                    <th style="width:150px">Profit</th>
                    <th style="width:110px">Margin</th>
                </tr>
            </thead>
            <tbody>
            @forelse($soldVouchers as $row)
                <tr>
                    <td>{{ $row['title'] ?? '-' }}</td>
                    <td>{{ number_format((int) ($row['sold_qty'] ?? 0)) }}</td>
                    <td>{{ $metrics->money((float) ($row['sale_price_per_voucher'] ?? 0), 'PKR') }}</td>
                    <td>{{ $metrics->money((float) ($row['revenue'] ?? 0), 'PKR') }}</td>
                    <td>{{ $metrics->money((float) ($row['buying_price_per_voucher'] ?? 0), 'PKR') }}</td>
                    <td>{{ $metrics->money((float) ($row['cogs'] ?? 0), 'PKR') }}</td>
                    <td style="color:{{ ((float) ($row['profit'] ?? 0)) >= 0 ? '#10b981' : '#ef4444' }};font-weight:700">
                        {{ $metrics->money((float) ($row['profit'] ?? 0), 'PKR') }}
                    </td>
                    <td>{{ number_format((float) ($row['margin'] ?? 0), 1) }}%</td>
                </tr>
            @empty
                <tr><td colspan="8" class="muted">No sold vouchers found for this date range.</td></tr>
            @endforelse
            </tbody>
        </table>
    </section>
    @endif
@endsection