@extends('layouts.finance')

@section('title', 'Net Profit Detail')
@section('subtitle', 'Filtered P&L after voucher cost, redeemed point deductions, and expenses')

@section('content')
 @php
    $displayCurrency = 'PKR';
    $fmt = fn($usd) => $metrics->moneyIn($usd, 'USD', $displayCurrency);
    $filters = $filters ?? ['mode' => 'month', 'month' => now()->format('Y-m'), 'from' => now()->startOfMonth()->toDateString(), 'to' => now()->endOfMonth()->toDateString()];
    $rangeLabel = $filters['mode'] === 'date' ? $filters['from'].' to '.$filters['to'] : \Illuminate\Support\Carbon::createFromFormat('Y-m', $filters['month'])->format('F Y');
    $itemFilterParams = [
        'mode' => $filters['mode'],
        'month' => $filters['month'],
        'from' => $filters['from'],
        'to' => $filters['to'],
    ];
    $profit  = $kpis['profit'];
    $revenue = $kpis['revenue'];
    $expenses = $kpis['expenses'];
    $margin  = $kpis['margin'];
    $isPositive = $profit >= 0;
    $profitDetails = $profitDetails ?? ['summary' => [], 'products' => collect(), 'recent_orders' => collect()];
    $profitSummary = $profitDetails['summary'] ?? [];
    $productProfitRows = collect($profitDetails['products'] ?? []);
    $recentProfitOrders = collect($profitDetails['recent_orders'] ?? []);
    $pointDetails = $profitDetails['point_details'] ?? ['summary' => [], 'by_item_user' => collect(), 'recent' => collect(), 'source' => null];
    $pointSummary = $pointDetails['summary'] ?? [];
    $recentPointRows = collect($pointDetails['recent'] ?? []);
    $pointValue = fn($origin, $kind) => (float) ($pointSummary[$origin][$kind] ?? 0);
    $sourceCurrency = $profitSummary['currency'] ?? 'PKR';
    $voucherCogsUsd = $metrics->usd((float)($profitSummary['cogs'] ?? 0), $sourceCurrency);
    $issuedPointsUsd = $metrics->usd((float)($profitSummary['issued_points'] ?? 0), $sourceCurrency);
    $pointsUsd = $metrics->usd((float)($profitSummary['points'] ?? 0), $sourceCurrency);
    $issuedPointsBreakdown = collect($profitSummary['issued_points_breakdown'] ?? [])
        ->map(fn ($amount) => $metrics->usd((float) $amount, $sourceCurrency));
    $pointsBreakdown = collect($profitSummary['points_breakdown'] ?? [])
        ->map(fn ($amount) => $metrics->usd((float) $amount, $sourceCurrency));
    $quarterlyIssuedPointsUsd = (float) ($issuedPointsBreakdown['quarterly'] ?? 0);
    $yearlyIssuedPointsUsd = (float) ($issuedPointsBreakdown['yearly'] ?? 0);
    $quarterlyPointsUsd = (float) ($pointsBreakdown['quarterly'] ?? 0);
    $yearlyPointsUsd = (float) ($pointsBreakdown['yearly'] ?? 0);
    $grossProfitBeforePoints = $revenue - $voucherCogsUsd;
    $profitAfterPoints = $grossProfitBeforePoints - $pointsUsd;

    $expCatLabels = $expByCategory->keys()->toArray();
    $expCatValues = $expByCategory->values()->toArray();
@endphp

{{-- Back link --}}
<div class="mb-4">
    <a href="{{ route('dashboard', array_filter(['from' => $filters['from'] ?? null, 'to' => $filters['to'] ?? null])) }}" class="btn btn-ghost" style="font-size:13px">
        <svg width="14" height="14" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2"><polyline points="15 18 9 12 15 6"/></svg>
        Back to Dashboard
    </a>
</div>

<section class="card mb-6">
    <div class="section-head">
        <h2>Filters</h2>
        <span class="pill">{{ $rangeLabel }}</span>
    </div>
    <div class="card-pad">
        <form method="GET" action="{{ route('dashboard.cards.profit') }}" class="grid gap-3" style="grid-template-columns:1fr 1fr 1fr 1fr auto auto;align-items:end">
            <div>
                <label class="label">View</label>
                <select class="field" name="mode">
                    <option value="month" @selected($filters['mode'] === 'month')>Monthly</option>
                    <option value="date" @selected($filters['mode'] === 'date')>Date wise</option>
                </select>
            </div>
            <div>
                <label class="label">Month</label>
                <input class="field" type="month" name="month" value="{{ $filters['month'] }}">
            </div>
            <div>
                <label class="label">From</label>
                <input class="field" type="date" name="from" value="{{ $filters['from'] }}">
            </div>
            <div>
                <label class="label">To</label>
                <input class="field" type="date" name="to" value="{{ $filters['to'] }}">
            </div>
            <button class="btn btn-primary">Apply</button>
            <a href="{{ route('dashboard.cards.profit') }}" class="btn">Reset</a>
        </form>
    </div>
</section>

<section class="card mb-6">
    <div class="section-head">
        <h2>Profit by Item</h2>
        <span class="pill">{{ $rangeLabel }}</span>
    </div>
    <table>
        <thead>
            <tr>
                <th>Item</th>
                <th class="right">Sold Voucher</th>
                <th class="right">Buying Price</th>
                <th class="right">Sale Price</th>
                <th class="right">Conversion Rate</th>
                <th class="right">Buying / Voucher</th>
                <th class="right">Sale After Points / Voucher</th>
                <th class="right">Issued Points</th>
                <th class="right">Redeemed Points</th>
                <th class="right">Profit</th>
            </tr>
        </thead>
        <tbody>
            @forelse($productProfitRows as $row)
                @php
                    $rowSoldQty = (float) ($row['sold_qty'] ?? 0);
                    $rowAvgBuying = (float) ($row['buying_price_per_voucher'] ?? ($rowSoldQty > 0 ? ((float) ($row['cogs'] ?? 0) / $rowSoldQty) : 0));
                    $rowSaleAfterPoints = (float) ($row['sale_after_points_per_voucher'] ?? ($rowSoldQty > 0 ? (((float) ($row['revenue'] ?? 0) - (float) ($row['points'] ?? 0)) / $rowSoldQty) : 0));
                    $rowRevenue = $metrics->usd($row['revenue'], 'PKR');
                    $rowCogs = $metrics->usd($row['cogs'], 'PKR');
                    $rowConversionRate = (float) ($row['conversion_rate'] ?? 0);
                    $rowAvgBuyingUsd = $metrics->usd($rowAvgBuying, 'PKR');
                    $rowSaleAfterPointsUsd = $metrics->usd($rowSaleAfterPoints, 'PKR');
                    $rowIssuedPoints = $metrics->usd((float) ($row['issued_points'] ?? 0), 'PKR');
                    $rowUsedPoints = $metrics->usd((float) ($row['points'] ?? 0), 'PKR');
                    $rowProfit = $metrics->usd($row['profit'], 'PKR');
                    $rowPositive = $row['profit'] >= 0;
                @endphp
                <tr class="row-hover" onclick="window.location='{{ route('dashboard.cards.profit.item', array_merge(['item' => $row['item_id']], $itemFilterParams)) }}'" style="cursor:pointer">
                    <td style="font-weight:700">{{ $row['title'] }}</td>
                    <td class="right">{{ number_format($row['sold_qty']) }}</td>
                    <td class="right" style="color:#ef4444">{{ $fmt($rowCogs) }}</td>
                    <td class="right" style="color:#10b981">{{ $fmt($rowRevenue) }}</td>
                    <td class="right">{{ $rowConversionRate > 0 ? number_format($rowConversionRate, 4) : '—' }}</td>
                    <td class="right" style="color:#ef4444">{{ $fmt($rowAvgBuyingUsd) }}</td>
                    <td class="right" style="color:#10b981">{{ $fmt($rowSaleAfterPointsUsd) }}</td>
                    <td class="right">{{ $fmt($rowIssuedPoints) }}</td>
                    <td class="right" style="color:#ef4444">{{ $fmt($rowUsedPoints) }}</td>
                    <td class="right" style="font-weight:700;color:{{ $rowPositive ? '#10b981' : '#ef4444' }}">{{ $fmt($rowProfit) }}</td>
                </tr>
            @empty
                <tr><td colspan="10" class="muted">No paid voucher profit detail found for this range.</td></tr>
            @endforelse
        </tbody>
    </table>
</section>


<section class="grid kpi-grid gap-3 mb-6">
    <div class="card kpi-card" style="background:{{ $isPositive ? 'var(--green-soft)' : 'var(--red-soft)' }};border-color:{{ $isPositive ? '#a7f3d0' : '#fecaca' }}">
        <div class="kpi-icon {{ $isPositive ? 'ico-bg-green' : 'ico-bg-red' }}">
            <svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2"><path d="M12 2v20M5 9l7-7 7 7M5 15l7 7 7-7"/></svg>
        </div>
        <div class="kpi-label">Net Profit</div>
        <div class="kpi-value" style="color:{{ $isPositive ? '#065f46' : '#991b1b' }}">{{ $fmt($profit) }}</div>
        <div class="kpi-sub">{{ number_format($margin, 1) }}% margin</div>
    </div>
    <div class="card kpi-card">
        <div class="kpi-icon ico-bg-green"><svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2"><polyline points="23 6 13.5 15.5 8.5 10.5 1 18"/></svg></div>
        <div class="kpi-label">Revenue</div>
        <div class="kpi-value" style="color:#10b981">{{ $fmt($revenue) }}</div>
        <div class="kpi-sub">{{ $rangeLabel }}</div>
    </div>
    <div class="card kpi-card">
        <div class="kpi-icon ico-bg-red"><svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2"><polyline points="23 18 13.5 8.5 8.5 13.5 1 6"/></svg></div>
        <div class="kpi-label">Expenses</div>
        <div class="kpi-value" style="color:#ef4444">{{ $fmt($expenses) }}</div>
        <div class="kpi-sub">All running costs</div>
    </div>
    <div class="card kpi-card">
        <div class="kpi-icon ico-bg-amber"><svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2"><path d="M21 16V8l-9-5-9 5v8l9 5z"/></svg></div>
        <div class="kpi-label">COGS</div>
        <div class="kpi-value">{{ $fmt($voucherCogsUsd) }}</div>
        <div class="kpi-sub">Inventory consumed</div>
    </div>
    <div class="card kpi-card">
        <div class="kpi-icon ico-bg-purple"><svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2"><path d="M20 12v7a2 2 0 0 1-2 2H6a2 2 0 0 1-2-2v-7"/><path d="M2 7h20v5H2z"/><path d="M12 22V7"/><path d="M12 7H7.5a2.5 2.5 0 0 1 0-5C11 2 12 7 12 7z"/><path d="M12 7h4.5a2.5 2.5 0 0 0 0-5C13 2 12 7 12 7z"/></svg></div>
        <div class="kpi-label">Redeemed Points</div>
        <div class="kpi-value">{{ $fmt($pointsUsd) }}</div>
        <div class="kpi-sub">Deducted from profit</div>
    </div>
</section>

{{-- Detailed formula --}}
<section class="grid gap-4 mb-6" style="grid-template-columns:1.2fr 1fr">
    <div class="card mb-0">
        <div class="section-head">
            <h2>Profit Formula</h2>
            <span class="pill">Source: {{ $profitSummary['source'] ?? 'examism_v3' }}</span>
        </div>
        <div class="card-pad">
            <div class="grid gap-3" style="grid-template-columns:repeat(auto-fit,minmax(130px,1fr))">
                <div style="padding:12px;border-radius:10px;background:var(--green-soft);border:1px solid #a7f3d0">
                    <div class="kpi-label">Paid order revenue</div>
                    <div style="font-size:18px;font-weight:800;color:#065f46">{{ $fmt($revenue) }}</div>
                </div>
                <div style="padding:12px;border-radius:10px;background:var(--yellow-soft);border:1px solid #fde68a">
                    <div class="kpi-label">Sold voucher cost</div>
                    <div style="font-size:18px;font-weight:800;color:#92400e">-{{ $fmt($voucherCogsUsd) }}</div>
                </div>
                <div style="padding:12px;border-radius:10px;background:#eef2ff;border:1px solid #c7d2fe">
                    <div class="kpi-label">Gross profit</div>
                    <div style="font-size:18px;font-weight:800;color:#3730a3">{{ $fmt($grossProfitBeforePoints) }}</div>
                </div>
                <div style="padding:12px;border-radius:10px;background:#f5f3ff;border:1px solid #ddd6fe">
                    <div class="kpi-label">Redeemed points</div>
                    <div style="font-size:18px;font-weight:800;color:#6d28d9">-{{ $fmt($pointsUsd) }}</div>
                </div>
                <div style="padding:12px;border-radius:10px;background:var(--red-soft);border:1px solid #fecaca">
                    <div class="kpi-label">Operating expenses</div>
                    <div style="font-size:18px;font-weight:800;color:#991b1b">-{{ $fmt($expenses) }}</div>
                </div>
                <div style="padding:12px;border-radius:10px;background:{{ $isPositive ? 'var(--green-soft)' : 'var(--red-soft)' }};border:1px solid {{ $isPositive ? '#a7f3d0' : '#fecaca' }}">
                    <div class="kpi-label">Net profit</div>
                    <div style="font-size:18px;font-weight:800;color:{{ $isPositive ? '#065f46' : '#991b1b' }}">{{ $fmt($profit) }}</div>
                </div>
            </div>
        </div>
    </div>
    <div class="card mb-0">
        <div class="section-head"><h2>Month Detail</h2></div>
        <div class="card-pad text-sm" style="line-height:1.9">
            <div class="flex justify-between"><span class="muted">Products sold</span><strong>{{ number_format($productProfitRows->sum('sold_qty')) }}</strong></div>
            <div class="flex justify-between"><span class="muted">Paid orders counted</span><strong>{{ number_format($productProfitRows->sum('orders_count')) }}</strong></div>
            <div class="flex justify-between"><span class="muted">Gross profit before points</span><strong>{{ $fmt($grossProfitBeforePoints) }}</strong></div>
            <div class="flex justify-between"><span class="muted">Profit after redeemed points</span><strong>{{ $fmt($profitAfterPoints) }}</strong></div>
            <div class="flex justify-between"><span class="muted">Final margin</span><strong>{{ number_format($margin, 2) }}%</strong></div>
        </div>
    </div>
</section>

{{-- Point deduction detail --}}
<section class="grid gap-3 mb-6" style="grid-template-columns:repeat(auto-fit,minmax(180px,1fr))">
    <div class="card kpi-card">
        <div class="kpi-label">Quarterly Redeemed Points</div>
        <div class="kpi-value" style="color:#6d28d9">-{{ $fmt($quarterlyPointsUsd) }}</div>
        <div class="kpi-sub">Deducted from gross profit</div>
    </div>
    <div class="card kpi-card">
        <div class="kpi-label">Yearly Redeemed Points</div>
        <div class="kpi-value" style="color:#6d28d9">-{{ $fmt($yearlyPointsUsd) }}</div>
        <div class="kpi-sub">Deducted from gross profit</div>
    </div>
    <div class="card kpi-card" style="background:#f5f3ff;border-color:#ddd6fe">
        <div class="kpi-label">Profit After Redeemed Points</div>
        <div class="kpi-value" style="color:#5b21b6">{{ $fmt($profitAfterPoints) }}</div>
        <div class="kpi-sub">Before operating expenses</div>
    </div>
</section>

{{-- Issued, redeemed, and available point detail --}}
<section class="card mb-6">
    <div class="section-head">
        <div>
            <h2>Quarterly & Yearly Point Ledger</h2>
            <div class="muted text-xs">Issued, redeemed, and available points by origin</div>
        </div>
        <span class="pill">{{ $pointDetails['source'] ?? 'No point ledger' }}</span>
    </div>
    <div class="card-pad">
        <div class="grid gap-3" style="grid-template-columns:repeat(auto-fit,minmax(150px,1fr))">
            <div style="padding:12px;border-radius:10px;background:#eef2ff;border:1px solid #c7d2fe">
                <div class="kpi-label">Quarterly Issued</div>
                <div style="font-size:20px;font-weight:800;color:#3730a3">{{ number_format($pointValue('quarterly', 'issued'), 2) }}</div>
            </div>
            <div style="padding:12px;border-radius:10px;background:#fef2f2;border:1px solid #fecaca">
                <div class="kpi-label">Quarterly Redeemed</div>
                <div style="font-size:20px;font-weight:800;color:#991b1b">{{ number_format($pointValue('quarterly', 'used'), 2) }}</div>
            </div>
            <div style="padding:12px;border-radius:10px;background:var(--green-soft);border:1px solid #a7f3d0">
                <div class="kpi-label">Quarterly Available</div>
                <div style="font-size:20px;font-weight:800;color:#065f46">{{ number_format($pointValue('quarterly', 'available'), 2) }}</div>
            </div>
            <div style="padding:12px;border-radius:10px;background:#eef2ff;border:1px solid #c7d2fe">
                <div class="kpi-label">Yearly Issued</div>
                <div style="font-size:20px;font-weight:800;color:#3730a3">{{ number_format($pointValue('yearly', 'issued'), 2) }}</div>
            </div>
            <div style="padding:12px;border-radius:10px;background:#fef2f2;border:1px solid #fecaca">
                <div class="kpi-label">Yearly Redeemed</div>
                <div style="font-size:20px;font-weight:800;color:#991b1b">{{ number_format($pointValue('yearly', 'used'), 2) }}</div>
            </div>
            <div style="padding:12px;border-radius:10px;background:var(--green-soft);border:1px solid #a7f3d0">
                <div class="kpi-label">Yearly Available</div>
                <div style="font-size:20px;font-weight:800;color:#065f46">{{ number_format($pointValue('yearly', 'available'), 2) }}</div>
            </div>
        </div>
    </div>
</section>

<section class="card mb-6">
    <div class="section-head">
        <h2>Recent Point Activity</h2>
        <span class="pill">Latest {{ number_format($recentPointRows->count()) }}</span>
    </div>
    <table>
        <thead>
            <tr>
                <th>Type</th>
                <th>Product</th>
                <th>User</th>
                <th>Order</th>
                <th>Date</th>
                <th class="right">Issued</th>
                <th class="right">Redeemed</th>
                <th class="right">Available</th>
            </tr>
        </thead>
        <tbody>
            @forelse($recentPointRows as $row)
                <tr class="row-hover">
                    <td><span class="pill">{{ $row['origin'] }}</span></td>
                    <td>{{ $row['product_name'] }}</td>
                    <td>
                        <div style="font-weight:600">{{ $row['agent_name'] }}</div>
                        <div class="muted text-xs">{{ $row['agent_business_name'] ?: ($row['agent_email'] ?: 'No user detail') }}</div>
                    </td>
                    <td>{{ $row['order_id'] ? '#'.$row['order_id'] : '—' }}</td>
                    <td>{{ $row['activity_date'] ?: '—' }}</td>
                    <td class="right">{{ number_format((float)$row['issued'], 2) }}</td>
                    <td class="right" style="color:#ef4444">{{ number_format((float)$row['used'], 2) }}</td>
                    <td class="right" style="color:#10b981">{{ number_format((float)$row['available'], 2) }}</td>
                </tr>
            @empty
                <tr><td colspan="8" class="muted">No recent point activity found for this range.</td></tr>
            @endforelse
        </tbody>
    </table>
</section>

{{-- Charts --}}
<section class="grid gap-4 mb-6" style="grid-template-columns:2fr 1fr">
    <div class="card p-5">
        <div class="flex items-center justify-between mb-3">
            <h3 class="font-semibold">Revenue vs. Expenses — 6 Months</h3>
            <span class="pill">USD</span>
        </div>
        <div style="height:260px;position:relative"><canvas id="trendChart"></canvas></div>
    </div>
    <div class="card p-5">
        <div class="flex items-center justify-between mb-3">
            <h3 class="font-semibold">Expense Categories</h3>
            <span class="pill">This month</span>
        </div>
        @if(count($expCatLabels) > 0)
            <div style="height:260px;position:relative"><canvas id="expCatChart"></canvas></div>
        @else
            <div style="height:260px;display:flex;align-items:center;justify-content:center;color:var(--muted);background:var(--bg-2);border-radius:12px;font-size:13px">No expenses found for this range.</div>
        @endif
    </div>
</section>

{{-- Profit trend line --}}
<section class="card p-5 mb-6">
    <div class="flex items-center justify-between mb-3">
        <h3 class="font-semibold">Net Profit Trend — 6 Months</h3>
        <span class="pill">USD</span>
    </div>
    <div style="height:220px;position:relative"><canvas id="profitLineChart"></canvas></div>
</section>

{{-- P&L Table --}}
<section class="card mb-6">
    <div class="section-head"><h2>Profit & Loss</h2><span class="pill">{{ $rangeLabel }}</span></div>
    <table>
        <thead>
            <tr>
                <th>Line Item</th>
                <th class="right">USD Value</th>
                <th class="right">PKR Equivalent</th>
            </tr>
        </thead>
        <tbody>
            <tr class="row-hover">
                <td style="color:#10b981;font-weight:600">Revenue</td>
                <td class="right" style="color:#10b981">{{ $metrics->money($revenue) }}</td>
                <td class="right" style="color:#10b981">{{ $fmt($revenue) }}</td>
            </tr>
            <tr class="row-hover">
                <td style="color:var(--muted)">— COGS</td>
                <td class="right" style="color:#ef4444">-{{ $metrics->money($voucherCogsUsd) }}</td>
                <td class="right" style="color:#ef4444">-{{ $fmt($voucherCogsUsd) }}</td>
            </tr>
            <tr class="row-hover" style="font-weight:600">
                <td>Gross Profit Before Points</td>
                <td class="right">{{ $metrics->money($grossProfitBeforePoints) }}</td>
                <td class="right">{{ $fmt($grossProfitBeforePoints) }}</td>
            </tr>
            <tr class="row-hover">
                <td style="color:var(--muted)">— Redeemed Points</td>
                <td class="right" style="color:#8b5cf6">-{{ $metrics->money($pointsUsd) }}</td>
                <td class="right" style="color:#8b5cf6">-{{ $fmt($pointsUsd) }}</td>
            </tr>
            <tr class="row-hover" style="font-weight:600">
                <td>Profit After Redeemed Points</td>
                <td class="right">{{ $metrics->money($profitAfterPoints) }}</td>
                <td class="right">{{ $fmt($profitAfterPoints) }}</td>
            </tr>
            <tr class="row-hover">
                <td style="color:var(--muted)">— Operating Expenses</td>
                <td class="right" style="color:#ef4444">-{{ $metrics->money($expenses) }}</td>
                <td class="right" style="color:#ef4444">-{{ $fmt($expenses) }}</td>
            </tr>
            <tr style="font-weight:700;background:var(--bg-2)">
                <td>Net Profit</td>
                <td class="right" style="color:{{ $isPositive ? '#10b981' : '#ef4444' }}">{{ $metrics->money($profit) }}</td>
                <td class="right" style="color:{{ $isPositive ? '#10b981' : '#ef4444' }}">{{ $fmt($profit) }}</td>
            </tr>
        </tbody>
    </table>
</section>

{{-- Product profit detail --}}
<section class="card mb-6">
    <div class="section-head">
        <h2>Profit by Product</h2>
        <span class="pill">{{ $rangeLabel }}</span>
    </div>
    <table>
        <thead>
            <tr>
                <th>Product</th>
                <th class="right">Qty</th>
                <th class="right">Orders</th>
                <th class="right">Revenue</th>
                <th class="right">COGS</th>
                <th class="right">Avg. Buying</th>
                <th class="right">Avg. Sale</th>
                <th class="right">Quarterly Issued</th>
                <th class="right">Yearly Issued</th>
                <th class="right">Redeemed Total</th>
                <th class="right">Net Profit</th>
                <th class="right">Margin</th>
            </tr>
        </thead>
        <tbody>
            @forelse($productProfitRows as $row)
                @php
                    $rowSoldQty = (float) ($row['sold_qty'] ?? 0);
                    $rowAvgBuying = (float) ($row['buying_price_per_voucher'] ?? ($rowSoldQty > 0 ? ((float) ($row['cogs'] ?? 0) / $rowSoldQty) : 0));
                    $rowSaleAfterPoints = (float) ($row['sale_after_points_per_voucher'] ?? ($rowSoldQty > 0 ? (((float) ($row['revenue'] ?? 0) - (float) ($row['points'] ?? 0)) / $rowSoldQty) : 0));
                    $rowRevenue = $metrics->usd($row['revenue'], 'PKR');
                    $rowCogs = $metrics->usd($row['cogs'], 'PKR');
                    $rowAvgBuyingUsd = $metrics->usd($rowAvgBuying, 'PKR');
                    $rowSaleAfterPointsUsd = $metrics->usd($rowSaleAfterPoints, 'PKR');
                    $rowPoints = $metrics->usd($row['points'], 'PKR');
                    $rowPointBreakdown = collect($row['points_breakdown'] ?? [])->map(fn ($amount) => $metrics->usd((float) $amount, 'PKR'));
                    $rowIssuedPointBreakdown = collect($row['issued_points_breakdown'] ?? [])->map(fn ($amount) => $metrics->usd((float) $amount, 'PKR'));
                    $rowProfit = $metrics->usd($row['profit'], 'PKR');
                    $rowPositive = $row['profit'] >= 0;
                @endphp
                <tr class="row-hover">
                    <td>{{ $row['title'] }}</td>
                    <td class="right">{{ number_format($row['sold_qty']) }}</td>
                    <td class="right">{{ number_format($row['orders_count']) }}</td>
                    <td class="right" style="color:#10b981">{{ $fmt($rowRevenue) }}</td>
                    <td class="right" style="color:#ef4444">-{{ $fmt($rowCogs) }}</td>
                    <td class="right" style="color:#ef4444">{{ $fmt($rowAvgBuyingUsd) }}</td>
                    <td class="right" style="color:#10b981">{{ $fmt($rowSaleAfterPointsUsd) }}</td>
                    <td class="right">{{ $fmt((float) ($rowIssuedPointBreakdown['quarterly'] ?? 0)) }}</td>
                    <td class="right">{{ $fmt((float) ($rowIssuedPointBreakdown['yearly'] ?? 0)) }}</td>
                    <td class="right" style="color:#8b5cf6">-{{ $fmt($rowPoints) }}</td>
                    <td class="right" style="font-weight:700;color:{{ $rowPositive ? '#10b981' : '#ef4444' }}">{{ $fmt($rowProfit) }}</td>
                    <td class="right">{{ number_format($row['margin'], 1) }}%</td>
                </tr>
            @empty
                <tr><td colspan="12" class="muted">No paid voucher profit detail found for this range.</td></tr>
            @endforelse
        </tbody>
    </table>
</section>

{{-- Recent paid order detail --}}
<section class="card mb-6">
    <div class="section-head">
        <h2>Recent Paid Orders</h2>
        <span class="pill">Latest 20</span>
    </div>
    <table>
        <thead>
            <tr>
                <th>Order</th>
                <th>Date</th>
                <th class="right">Qty</th>
                <th class="right">Revenue</th>
                <th class="right">COGS</th>
                <th class="right">Quarterly Issued</th>
                <th class="right">Yearly Issued</th>
                <th class="right">Redeemed Total</th>
                <th class="right">Profit</th>
            </tr>
        </thead>
        <tbody>
            @forelse($recentProfitOrders as $order)
                @php
                    $orderRevenue = $metrics->usd($order['revenue'], 'PKR');
                    $orderCogs = $metrics->usd($order['cogs'], 'PKR');
                    $orderPoints = $metrics->usd($order['points'], 'PKR');
                    $orderPointBreakdown = collect($order['points_breakdown'] ?? [])->map(fn ($amount) => $metrics->usd((float) $amount, 'PKR'));
                    $orderIssuedPointBreakdown = collect($order['issued_points_breakdown'] ?? [])->map(fn ($amount) => $metrics->usd((float) $amount, 'PKR'));
                    $orderProfit = $metrics->usd($order['profit'], 'PKR');
                    $orderPositive = $order['profit'] >= 0;
                @endphp
                <tr class="row-hover">
                    <td>#{{ $order['id'] }}</td>
                    <td>{{ $order['date'] ?: '—' }}</td>
                    <td class="right">{{ number_format($order['qty']) }}</td>
                    <td class="right" style="color:#10b981">{{ $fmt($orderRevenue) }}</td>
                    <td class="right" style="color:#ef4444">-{{ $fmt($orderCogs) }}</td>
                    <td class="right">{{ $fmt((float) ($orderIssuedPointBreakdown['quarterly'] ?? 0)) }}</td>
                    <td class="right">{{ $fmt((float) ($orderIssuedPointBreakdown['yearly'] ?? 0)) }}</td>
                    <td class="right" style="color:#8b5cf6">-{{ $fmt($orderPoints) }}</td>
                    <td class="right" style="font-weight:700;color:{{ $orderPositive ? '#10b981' : '#ef4444' }}">{{ $fmt($orderProfit) }}</td>
                </tr>
            @empty
                <tr><td colspan="9" class="muted">No recent paid orders found for this range.</td></tr>
            @endforelse
        </tbody>
    </table>
</section>

{{-- Expense category detail --}}
@if($expByCategory->count() > 0)
<section class="card mb-6">
    <div class="section-head"><h2>Expense Breakdown by Category</h2></div>
    <table>
        <thead><tr><th>Category</th><th class="right">USD</th><th class="right">PKR</th><th class="right">% of Expenses</th></tr></thead>
        <tbody>
            @foreach($expByCategory as $cat => $usdVal)
            <tr class="row-hover">
                <td>{{ $cat }}</td>
                <td class="right">{{ $metrics->money($usdVal) }}</td>
                <td class="right">{{ $fmt($usdVal) }}</td>
                <td class="right">{{ $expenses > 0 ? number_format(($usdVal / $expenses) * 100, 1) : '0.0' }}%</td>
            </tr>
            @endforeach
        </tbody>
    </table>
</section>
@endif

@push('scripts')
<script src="{{ asset('chart.umd.min.js') }}"></script>
<script>
(function () {
    'use strict';
    var palette = ['#6366f1','#10b981','#f59e0b','#06b6d4','#ec4899','#ef4444','#8b5cf6','#0d9488'];
    function sliceColors(n) { var o=[]; for(var i=0;i<n;i++) o.push(palette[i%palette.length]); return o; }
    Chart.defaults.font.family = 'Inter, system-ui, sans-serif';
    Chart.defaults.font.size   = 12;

    var trendLabels = @json($trend['labels']);
    var trendRev    = @json($trend['revenue']);
    var trendExp    = @json($trend['expenses']);
    var profitArr   = @json($profitTrend);

    // Revenue vs Expenses bar
    new Chart(document.getElementById('trendChart'), {
        type: 'bar',
        data: {
            labels: trendLabels,
            datasets: [
                { label: 'Revenue', data: trendRev, backgroundColor: 'rgba(16,185,129,.8)', borderRadius: 5 },
                { label: 'Expenses', data: trendExp, backgroundColor: 'rgba(239,68,68,.8)', borderRadius: 5 }
            ]
        },
        options: {
            responsive: true, maintainAspectRatio: false,
            interaction: { mode: 'index', intersect: false },
            plugins: {
                legend: { position: 'bottom', labels: { boxWidth: 10, padding: 10, font: { size: 11 } } },
                tooltip: { callbacks: { label: function(c) { return ' '+c.dataset.label+': $'+c.raw.toLocaleString('en-US',{maximumFractionDigits:0}); } } }
            },
            scales: {
                x: { grid: { display: false } },
                y: { grid: { color: 'rgba(0,0,0,.05)' }, ticks: { callback: function(v) { return '$'+(v>=1000?(v/1000).toFixed(0)+'k':v); } } }
            }
        }
    });

    // Expense category donut
    var expEl = document.getElementById('expCatChart');
    if (expEl && @json(count($expCatLabels)) > 0) {
        new Chart(expEl, {
            type: 'doughnut',
            data: {
                labels: @json($expCatLabels),
                datasets: [{ data: @json($expCatValues), backgroundColor: sliceColors(@json(count($expCatLabels))), borderWidth: 2, borderColor: '#fff' }]
            },
            options: {
                responsive: true, maintainAspectRatio: false,
                plugins: {
                    legend: { position: 'bottom', labels: { boxWidth: 10, padding: 10, font: { size: 11 } } },
                    tooltip: { callbacks: { label: function(c) { return ' $' + c.raw.toLocaleString('en-US',{maximumFractionDigits:0}); } } }
                }
            }
        });
    }

    // Profit line chart
    new Chart(document.getElementById('profitLineChart'), {
        type: 'line',
        data: {
            labels: trendLabels,
            datasets: [{
                label: 'Net Profit',
                data: profitArr,
                borderColor: '#6366f1',
                backgroundColor: 'rgba(99,102,241,.1)',
                borderWidth: 2,
                pointBackgroundColor: '#6366f1',
                pointRadius: 4,
                tension: 0.3,
                fill: true
            }]
        },
        options: {
            responsive: true, maintainAspectRatio: false,
            plugins: {
                legend: { display: false },
                tooltip: { callbacks: { label: function(c) { return ' $' + c.raw.toLocaleString('en-US',{maximumFractionDigits:0}); } } }
            },
            scales: {
                x: { grid: { display: false } },
                y: {
                    grid: { color: 'rgba(0,0,0,.05)' },
                    ticks: { callback: function(v) { return '$'+(v>=1000?(v/1000).toFixed(0)+'k':v); } }
                }
            }
        }
    });
}());
</script>
@endpush
@endsection