@php
    $activeExpenseCategory = isset($filters['expense_category_id']) && $filters['expense_category_id'] !== ''
        ? (int) $filters['expense_category_id']
        : null;
    $reportLinkParams = request()->only(['from_date','to_date','from','to','search','sales_basis','result_filter','approved_by','payment_method','courier_type','district','order_source']);
@endphp

@if(isset($expenseCategoryBreakdown) && $expenseCategoryBreakdown->isNotEmpty())
<div class="rp-filter-card mb-3">
    <div class="d-flex justify-content-between align-items-center flex-wrap gap-2 mb-2">
        <h6 class="fw-bold mb-0"><i class="fas fa-tags me-1"></i> Expense by Category</h6>
        @if($activeExpenseCategory !== null)
            <small class="text-muted">Filtered — profit/loss uses selected category only</small>
        @endif
    </div>
    <div class="rp-exp-cat-breakdown">
        <a href="{{ route('admin.reports.sales', array_merge($reportLinkParams, ['from_date' => $from, 'to_date' => $to])) }}"
           class="rp-exp-cat-chip {{ $activeExpenseCategory === null ? 'is-active' : '' }}">All</a>
        @foreach($expenseCategoryBreakdown as $row)
            @php
                $catKey = $row->expense_category_id === null ? 0 : (int) $row->expense_category_id;
            @endphp
            <a href="{{ route('admin.reports.sales', array_merge($reportLinkParams, ['from_date' => $from, 'to_date' => $to, 'expense_category_id' => $catKey])) }}"
               class="rp-exp-cat-chip {{ $activeExpenseCategory === $catKey ? 'is-active' : '' }}">
                {{ $row->category_name }}
                <span class="text-muted">{{ $row->total_count }}</span>
                <strong>৳{{ number_format($row->total_amount, 0) }}</strong>
            </a>
        @endforeach
    </div>
</div>
@endif

<div class="row g-3 mb-3">
    <div class="col-6 col-md-4 col-lg-2">
        <div class="rp-stat-card rp-stat-blue">
            <div class="label">Total Sales</div>
            <div class="value">{{ number_format($summary['total_sales'], 2) }} ৳</div>
        </div>
    </div>
    <div class="col-6 col-md-4 col-lg-2">
        <div class="rp-stat-card rp-stat-green">
            <div class="label">Total Profit</div>
            <div class="value">{{ number_format($summary['total_profit'], 2) }} ৳</div>
        </div>
    </div>
    <div class="col-6 col-md-4 col-lg-2">
        <div class="rp-stat-card rp-stat-teal">
            <div class="label">Profit Margin</div>
            <div class="value">{{ number_format($summary['profit_margin'], 1) }}%</div>
        </div>
    </div>
    <div class="col-6 col-md-4 col-lg-2">
        <div class="rp-stat-card rp-stat-yellow">
            <div class="label">Cost Price</div>
            <div class="value">{{ number_format($summary['cost_price'], 2) }} ৳</div>
        </div>
    </div>
    <div class="col-6 col-md-4 col-lg-2">
        <div class="rp-stat-card rp-stat-red">
            <div class="label">Other Expenses</div>
            <div class="value">{{ number_format($summary['other_expenses'], 2) }} ৳</div>
        </div>
    </div>
    <div class="col-6 col-md-4 col-lg-2">
        <div class="rp-stat-card rp-stat-dark">
            <div class="label">Total Orders</div>
            <div class="value">{{ number_format($summary['total_orders']) }}</div>
        </div>
    </div>
    <div class="col-6 col-md-4 col-lg-2">
        <div class="rp-stat-card rp-stat-green">
            <div class="label">Delivered</div>
            <div class="value">{{ number_format($summary['delivered_count']) }}</div>
        </div>
    </div>
    <div class="col-6 col-md-4 col-lg-2">
        <div class="rp-stat-card rp-stat-blue">
            <div class="label">Avg Order Value</div>
            <div class="value">{{ number_format($summary['avg_order_value'], 0) }} ৳</div>
        </div>
    </div>
    <div class="col-6 col-md-4 col-lg-2">
        <div class="rp-stat-card rp-stat-teal">
            <div class="label">Profit Days</div>
            <div class="value">{{ number_format($summary['profit_days']) }}</div>
        </div>
    </div>
    <div class="col-6 col-md-4 col-lg-2">
        <div class="rp-stat-card rp-stat-red">
            <div class="label">Loss Days</div>
            <div class="value">{{ number_format($summary['loss_days']) }}</div>
        </div>
    </div>
</div>

<div class="rp-panel">
    <div class="table-responsive">
        <table class="rp-table">
            <thead>
                <tr>
                    <th>Date</th>
                    <th class="text-end">Total Sales</th>
                    <th class="text-center">Orders</th>
                    <th class="text-center">Delivered</th>
                    <th class="text-end">Avg Order</th>
                    <th class="text-end">Cost Price</th>
                    <th class="text-end">Other Exp.</th>
                    <th class="text-end">Total Exp.</th>
                    <th class="text-end">Profit/Loss</th>
                    <th class="text-end">Margin</th>
                    <th class="text-center">Status</th>
                </tr>
            </thead>
            <tbody>
                @forelse($rows as $row)
                <tr>
                    <td class="fw-semibold">{{ $row['date_label'] }}</td>
                    <td class="text-end rp-text-sales">{{ number_format($row['total_sales'], 2) }} ৳</td>
                    <td class="text-center fw-semibold">{{ number_format($row['total_orders']) }}</td>
                    <td class="text-center">{{ number_format($row['delivered_count']) }}</td>
                    <td class="text-end">{{ number_format($row['avg_order_value'], 0) }} ৳</td>
                    <td class="text-end rp-text-cost">{{ number_format($row['cost_price'], 2) }} ৳</td>
                    <td class="text-end rp-text-expense">{{ number_format($row['other_expenses'], 2) }} ৳</td>
                    <td class="text-end rp-text-dark">{{ number_format($row['total_expenses'], 2) }} ৳</td>
                    <td class="text-end {{ $row['profit'] >= 0 ? 'rp-text-profit' : 'rp-text-loss' }}">
                        {{ number_format($row['profit'], 2) }} ৳
                    </td>
                    <td class="text-end {{ ($row['margin_pct'] ?? 0) >= 0 ? 'rp-text-profit' : 'rp-text-loss' }}">
                        {{ number_format($row['margin_pct'], 1) }}%
                    </td>
                    <td class="text-center">
                        <span class="rp-badge {{ $row['status']['class'] }}">{{ $row['status']['label'] }}</span>
                    </td>
                </tr>
                @empty
                <tr>
                    <td colspan="11" class="text-center py-5 text-muted">
                        No report data for this period{{ ($filters['search'] ?? '') ? ' / filter' : '' }}.
                    </td>
                </tr>
                @endforelse
            </tbody>
        </table>
    </div>
</div>