@extends('layouts.finance')

@section('title', ($selectedProduct['title'] ?? 'Item').' Profit')
@section('subtitle', 'Filtered sold voucher profit after redeemed quarterly and yearly points')

@section('content')
@php
    $displayCurrency = 'PKR';
    $fmt = fn($usd) => $metrics->moneyIn($usd, 'USD', $displayCurrency);
    $profitDetails = $profitDetails ?? ['summary' => [], 'products' => collect(), 'recent_orders' => collect(), 'point_details' => []];
    $summary = $profitDetails['summary'] ?? [];
    $productRows = collect($profitDetails['products'] ?? []);
    $row = $productRows->first() ?? [
        'item_id' => $selectedProduct['item_id'] ?? $filters['product_id'],
        'title' => $selectedProduct['title'] ?? 'Item #'.$filters['product_id'],
        'sold_qty' => 0,
        'orders_count' => 0,
        'revenue' => 0,
        'cogs' => 0,
        'issued_points' => 0,
        'issued_points_breakdown' => ['quarterly' => 0, 'yearly' => 0],
        'points' => 0,
        'points_breakdown' => ['quarterly' => 0, 'yearly' => 0],
        'profit' => 0,
        'margin' => 0,
    ];
    $recentOrders = collect($profitDetails['recent_orders'] ?? []);
    $pointDetails = $profitDetails['point_details'] ?? ['summary' => [], 'by_item_user' => collect(), 'recent' => collect(), 'source' => null];
    $pointRows = collect($pointDetails['by_item_user'] ?? []);
    $sourceCurrency = $summary['currency'] ?? 'PKR';
    $revenueUsd = $metrics->usd((float) ($row['revenue'] ?? 0), 'PKR');
    $cogsUsd = $metrics->usd((float) ($row['cogs'] ?? 0), 'PKR');
    $issuedUsd = $metrics->usd((float) ($row['issued_points'] ?? 0), 'PKR');
    $usedUsd = $metrics->usd((float) ($row['points'] ?? 0), 'PKR');
    $profitUsd = $metrics->usd((float) ($row['profit'] ?? 0), 'PKR');
    $grossUsd = $revenueUsd - $cogsUsd;
    $soldQty = (float) ($row['sold_qty'] ?? 0);
    $avgBuying = (float) ($row['buying_price_per_voucher'] ?? ($soldQty > 0 ? ((float) ($row['cogs'] ?? 0) / $soldQty) : 0));
    $saleAfterPoints = (float) ($row['sale_after_points_per_voucher'] ?? ($soldQty > 0 ? (((float) ($row['revenue'] ?? 0) - (float) ($row['points'] ?? 0)) / $soldQty) : 0));
    $avgBuyingUsd = $metrics->usd($avgBuying, 'PKR');
    $saleAfterPointsUsd = $metrics->usd($saleAfterPoints, 'PKR');
    $issuedBreakdown = collect($row['issued_points_breakdown'] ?? []);
    $usedBreakdown = collect($row['points_breakdown'] ?? []);
    $isPositive = ((float) ($row['profit'] ?? 0)) >= 0;
@endphp

<div class="mb-4 flex items-center gap-2">
    <a href="{{ route('dashboard.cards.profit', array_filter(['from' => $filters['from'] ?? null, 'to' => $filters['to'] ?? null, 'mode' => 'date'])) }}" 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 Profit
    </a>
    <a href="{{ route('dashboard', array_filter(['from' => $filters['from'] ?? null, 'to' => $filters['to'] ?? null])) }}" class="btn btn-ghost" style="font-size:13px">Dashboard</a>
</div>

<section class="card mb-6">
    <div class="section-head">
        <h2>Filters</h2>
        <span class="pill">{{ $filters['mode'] === 'date' ? 'Date wise' : 'Monthly' }}</span>
    </div>
    <div class="card-pad">
        <form method="GET" action="{{ route('dashboard.cards.profit.item', ['item' => $filters['product_id']]) }}" 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.item', ['item' => $filters['product_id']]) }}" class="btn">Reset</a>
        </form>
    </div>
</section>

<section class="grid kpi-grid gap-3 mb-6">
    <div class="card kpi-card">
        <div class="kpi-label">Sold Voucher</div>
        <div class="kpi-value">{{ number_format((float) ($row['sold_qty'] ?? 0)) }}</div>
        <div class="kpi-sub">{{ number_format((float) ($row['orders_count'] ?? 0)) }} paid orders</div>
    </div>
    <div class="card kpi-card">
        <div class="kpi-label">Sale Price</div>
        <div class="kpi-value" style="color:#10b981">{{ $fmt($revenueUsd) }}</div>
        <div class="kpi-sub">Filtered revenue</div>
    </div>
    <div class="card kpi-card">
        <div class="kpi-label">Buying Price</div>
        <div class="kpi-value" style="color:#ef4444">{{ $fmt($cogsUsd) }}</div>
        <div class="kpi-sub">Sold voucher cost</div>
    </div>
    <div class="card kpi-card">
        <div class="kpi-label">Buying / Voucher</div>
        <div class="kpi-value" style="color:#ef4444">{{ $fmt($avgBuyingUsd) }}</div>
        <div class="kpi-sub">Average cost</div>
    </div>
    <div class="card kpi-card">
        <div class="kpi-label">Sale After Points / Voucher</div>
        <div class="kpi-value" style="color:#10b981">{{ $fmt($saleAfterPointsUsd) }}</div>
        <div class="kpi-sub">After redeemed points</div>
    </div>
    <div class="card kpi-card">
        <div class="kpi-label">Redeemed Points</div>
        <div class="kpi-value" style="color:#ef4444">{{ $fmt($usedUsd) }}</div>
        <div class="kpi-sub">Quarterly/yearly only</div>
    </div>
    <div class="card kpi-card" style="background:{{ $isPositive ? 'var(--green-soft)' : 'var(--red-soft)' }};border-color:{{ $isPositive ? '#a7f3d0' : '#fecaca' }}">
        <div class="kpi-label">Profit</div>
        <div class="kpi-value" style="color:{{ $isPositive ? '#065f46' : '#991b1b' }}">{{ $fmt($profitUsd) }}</div>
        <div class="kpi-sub">After redeemed points</div>
    </div>
</section>

<section class="card mb-6">
    <div class="section-head">
        <h2>{{ $row['title'] ?? $selectedProduct['title'] }} Profit Detail</h2>
        <span class="pill">{{ $filters['from'] }} to {{ $filters['to'] }}</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">Buying / Voucher</th>
                <th class="right">Sale After Points / Voucher</th>
                <th class="right">Q Issued</th>
                <th class="right">Y Issued</th>
                <th class="right">Issued Total</th>
                <th class="right">Q Redeemed</th>
                <th class="right">Y Redeemed</th>
                <th class="right">Redeemed Total</th>
                <th class="right">Profit</th>
            </tr>
        </thead>
        <tbody>
            <tr class="row-hover">
                <td>{{ $row['title'] ?? $selectedProduct['title'] }}</td>
                <td class="right">{{ number_format((float) ($row['sold_qty'] ?? 0)) }}</td>
                <td class="right" style="color:#ef4444">{{ $fmt($cogsUsd) }}</td>
                <td class="right" style="color:#10b981">{{ $fmt($revenueUsd) }}</td>
                <td class="right" style="color:#ef4444">{{ $fmt($avgBuyingUsd) }}</td>
                <td class="right" style="color:#10b981">{{ $fmt($saleAfterPointsUsd) }}</td>
                <td class="right">{{ $fmt($metrics->usd((float) ($issuedBreakdown['quarterly'] ?? 0), 'PKR')) }}</td>
                <td class="right">{{ $fmt($metrics->usd((float) ($issuedBreakdown['yearly'] ?? 0), 'PKR')) }}</td>
                <td class="right">{{ $fmt($issuedUsd) }}</td>
                <td class="right" style="color:#ef4444">{{ $fmt($metrics->usd((float) ($usedBreakdown['quarterly'] ?? 0), 'PKR')) }}</td>
                <td class="right" style="color:#ef4444">{{ $fmt($metrics->usd((float) ($usedBreakdown['yearly'] ?? 0), 'PKR')) }}</td>
                <td class="right" style="color:#ef4444">{{ $fmt($usedUsd) }}</td>
                <td class="right" style="font-weight:700;color:{{ $isPositive ? '#10b981' : '#ef4444' }}">{{ $fmt($profitUsd) }}</td>
            </tr>
        </tbody>
    </table>
</section>

<section class="card mb-6">
    <div class="section-head">
        <h2>Formula</h2>
        <span class="pill">{{ $summary['source'] ?? 'examism_v3' }}</span>
    </div>
    <div class="card-pad text-sm" style="line-height:1.9">
        <div class="flex justify-between"><span class="muted">Sale price</span><strong>{{ $fmt($revenueUsd) }}</strong></div>
        <div class="flex justify-between"><span class="muted">Buying price</span><strong>-{{ $fmt($cogsUsd) }}</strong></div>
        <div class="flex justify-between"><span class="muted">Gross profit before points</span><strong>{{ $fmt($grossUsd) }}</strong></div>
        <div class="flex justify-between"><span class="muted">Issued points shown only</span><strong>{{ $fmt($issuedUsd) }}</strong></div>
        <div class="flex justify-between"><span class="muted">Redeemed points deducted</span><strong>-{{ $fmt($usedUsd) }}</strong></div>
        <div class="flex justify-between"><span class="muted">Profit</span><strong>{{ $fmt($profitUsd) }}</strong></div>
    </div>
</section>

<section class="card mb-6">
    <div class="section-head">
        <h2>Point Detail by User</h2>
        <span class="pill">{{ $pointDetails['source'] ?? 'No point ledger' }}</span>
    </div>
    <table>
        <thead>
            <tr>
                <th>User</th>
                <th>Business</th>
                <th class="right">Q Issued</th>
                <th class="right">Q Redeemed</th>
                <th class="right">Y Issued</th>
                <th class="right">Y Redeemed</th>
                <th class="right">Total Issued</th>
                <th class="right">Total Used</th>
            </tr>
        </thead>
        <tbody>
            @forelse($pointRows as $pointRow)
                @php
                    $points = $pointRow['points'] ?? [];
                    $quarterly = $points['quarterly'] ?? [];
                    $yearly = $points['yearly'] ?? [];
                    $total = $points['total'] ?? [];
                @endphp
                <tr class="row-hover">
                    <td>
                        <div style="font-weight:600">{{ $pointRow['agent_name'] }}</div>
                        <div class="muted text-xs">{{ $pointRow['agent_email'] ?: 'No email' }}</div>
                    </td>
                    <td>{{ $pointRow['agent_business_name'] ?: '-' }}</td>
                    <td class="right">{{ number_format((float) ($quarterly['issued'] ?? 0), 2) }}</td>
                    <td class="right" style="color:#ef4444">{{ number_format((float) ($quarterly['used'] ?? 0), 2) }}</td>
                    <td class="right">{{ number_format((float) ($yearly['issued'] ?? 0), 2) }}</td>
                    <td class="right" style="color:#ef4444">{{ number_format((float) ($yearly['used'] ?? 0), 2) }}</td>
                    <td class="right" style="font-weight:700">{{ number_format((float) ($total['issued'] ?? 0), 2) }}</td>
                    <td class="right" style="font-weight:700;color:#ef4444">{{ number_format((float) ($total['used'] ?? 0), 2) }}</td>
                </tr>
            @empty
                <tr><td colspan="8" class="muted">No quarterly or yearly redeemed point detail found for this item and date range.</td></tr>
            @endforelse
        </tbody>
    </table>
</section>

<section class="card mb-6">
    <div class="section-head">
        <h2>Sold Voucher Orders</h2>
        <span class="pill">Latest {{ number_format($recentOrders->count()) }}</span>
    </div>
    <table>
        <thead>
            <tr>
                <th>Order</th>
                <th>Date</th>
                <th class="right">Sold Voucher</th>
                <th class="right">Sale Price</th>
                <th class="right">Buying Price</th>
                <th class="right">Sale After Points / Voucher</th>
                <th class="right">Buying / Voucher</th>
                <th class="right">Redeemed Points</th>
                <th class="right">Profit</th>
            </tr>
        </thead>
        <tbody>
            @forelse($recentOrders as $order)
                @php
                    $orderProfit = $metrics->usd((float) ($order['profit'] ?? 0), 'PKR');
                    $orderQty = (float) ($order['qty'] ?? 0);
                    $orderSaleAfterPoints = (float) ($order['sale_after_points_per_voucher'] ?? ($orderQty > 0 ? (((float) ($order['revenue'] ?? 0) - (float) ($order['points'] ?? 0)) / $orderQty) : 0));
                    $orderAvgBuying = (float) ($order['buying_price_per_voucher'] ?? ($orderQty > 0 ? ((float) ($order['cogs'] ?? 0) / $orderQty) : 0));
                    $orderPositive = ((float) ($order['profit'] ?? 0)) >= 0;
                @endphp
                <tr class="row-hover">
                    <td>#{{ $order['id'] }}</td>
                    <td>{{ $order['date'] ?: '-' }}</td>
                    <td class="right">{{ number_format((float) ($order['qty'] ?? 0)) }}</td>
                    <td class="right" style="color:#10b981">{{ $fmt($metrics->usd((float) ($order['revenue'] ?? 0), 'PKR')) }}</td>
                    <td class="right" style="color:#ef4444">{{ $fmt($metrics->usd((float) ($order['cogs'] ?? 0), 'PKR')) }}</td>
                    <td class="right" style="color:#10b981">{{ $fmt($metrics->usd($orderSaleAfterPoints, 'PKR')) }}</td>
                    <td class="right" style="color:#ef4444">{{ $fmt($metrics->usd($orderAvgBuying, 'PKR')) }}</td>
                    <td class="right" style="color:#ef4444">{{ $fmt($metrics->usd((float) ($order['points'] ?? 0), 'PKR')) }}</td>
                    <td class="right" style="font-weight:700;color:{{ $orderPositive ? '#10b981' : '#ef4444' }}">{{ $fmt($orderProfit) }}</td>
                </tr>
            @empty
                <tr><td colspan="9" class="muted">No sold voucher orders found for this item and date range.</td></tr>
            @endforelse
        </tbody>
    </table>
</section>
@endsection