@php
    $peakMonth = $monthly->sortByDesc('total_amount')->first();
    $maxAmt    = $monthly->max('total_amount');

    // Build pivot matrix for category breakdown
    $months    = $monthlyByItem->pluck('month')->unique()->sort()->values();
    $itemNames = $monthlyByItem->pluck('expense_item_name')->unique()->values();
    $matrix    = [];
    foreach ($monthlyByItem as $row) {
        $matrix[$row->month][$row->expense_item_name] = $row->total_amount;
    }
@endphp

{{-- Stat cards --}}
<div class="row g-3 mb-3">
    <div class="col-6 col-lg-3">
        <div class="card text-bg-primary">
            <div class="card-body py-3">
                <div class="small fw-semibold text-white-50 mb-1">Grand Total</div>
                <div class="fs-5 fw-bold">{{ number_format($totals['grand_total'], 2) }}</div>
                <div class="small text-white-50">{{ $totals['total_months'] }} months</div>
            </div>
        </div>
    </div>
    <div class="col-6 col-lg-3">
        <div class="card text-bg-success">
            <div class="card-body py-3">
                <div class="small fw-semibold text-white-50 mb-1">Avg Monthly</div>
                <div class="fs-5 fw-bold">{{ number_format($totals['avg_monthly'], 2) }}</div>
                <div class="small text-white-50">per month</div>
            </div>
        </div>
    </div>
    <div class="col-6 col-lg-3">
        <div class="card text-bg-warning">
            <div class="card-body py-3">
                <div class="small fw-semibold text-white-50 mb-1">Peak Month</div>
                <div class="fw-bold">{{ $peakMonth?->month ?? '—' }}</div>
                <div class="small text-white-50">{{ number_format($peakMonth?->total_amount ?? 0, 2) }}</div>
            </div>
        </div>
    </div>
    <div class="col-6 col-lg-3">
        <div class="card text-bg-secondary">
            <div class="card-body py-3">
                <div class="small fw-semibold text-white-50 mb-1">Months Recorded</div>
                <div class="fs-5 fw-bold">{{ $totals['total_months'] }}</div>
                <div class="small text-white-50">in range</div>
            </div>
        </div>
    </div>
</div>

{{-- Monthly totals --}}
<div class="card mb-3">
    <div class="card-header d-flex justify-content-between align-items-center py-2">
        <span class="fw-semibold small">Monthly Totals</span>
        <span class="badge bg-secondary">{{ $monthly->count() }} months</span>
    </div>
    <div class="table-responsive">
        @if($monthly->isEmpty())
            <div class="text-center text-muted py-5">No monthly data found.</div>
        @else
        <table class="table table-hover table-sm align-middle mb-0">
            <thead class="table-light">
                <tr>
                    <th>Month</th>
                    <th class="text-end">Entries</th>
                    <th class="text-end">Branches</th>
                    <th class="text-end">Total Amount</th>
                    <th class="text-end">vs Avg</th>
                    <th>Volume</th>
                </tr>
            </thead>
            <tbody>
                @foreach($monthly as $row)
                @php
                    $pct  = $maxAmt > 0 ? round($row->total_amount / $maxAmt * 100) : 0;
                    $diff = $row->total_amount - $totals['avg_monthly'];
                @endphp
                <tr>
                    <td class="fw-semibold small">{{ $row->month }}</td>
                    <td class="text-end">{{ number_format($row->entry_count) }}</td>
                    <td class="text-end">{{ number_format($row->branch_count) }}</td>
                    <td class="text-end fw-semibold">{{ number_format($row->total_amount, 2) }}</td>
                    <td class="text-end">
                        <span class="badge {{ $diff > 0 ? 'bg-danger' : 'bg-success' }}">
                            {{ $diff > 0 ? '+' : '' }}{{ number_format($diff, 2) }}
                        </span>
                    </td>
                    <td style="min-width:140px">
                        <div class="d-flex align-items-center gap-2">
                            <div class="progress flex-grow-1" style="height:6px">
                                <div class="progress-bar" style="width:{{ $pct }}%"></div>
                            </div>
                            <small class="text-muted text-nowrap">{{ $pct }}%</small>
                        </div>
                    </td>
                </tr>
                @endforeach
            </tbody>
            <tfoot class="table-light fw-semibold">
                <tr>
                    <td colspan="3">Total</td>
                    <td class="text-end">{{ number_format($totals['grand_total'], 2) }}</td>
                    <td colspan="2"></td>
                </tr>
            </tfoot>
        </table>
        @endif
    </div>
</div>

{{-- Category pivot --}}
@if($monthlyByItem->isNotEmpty())
<div class="card">
    <div class="card-header d-flex justify-content-between align-items-center py-2">
        <span class="fw-semibold small">Category Breakdown by Month</span>
        <span class="badge bg-secondary">{{ $itemNames->count() }} categories</span>
    </div>
    <div class="table-responsive">
        <table class="table table-hover table-sm align-middle mb-0">
            <thead class="table-light">
                <tr>
                    <th>Month</th>
                    @foreach($itemNames as $name)
                        <th class="text-end text-nowrap">{{ $name }}</th>
                    @endforeach
                    <th class="text-end">Row Total</th>
                </tr>
            </thead>
            <tbody>
                @foreach($months as $month)
                @php $rowTotal = array_sum($matrix[$month] ?? []); @endphp
                <tr>
                    <td class="fw-semibold small">{{ $month }}</td>
                    @foreach($itemNames as $name)
                        <td class="text-end">
                            @if(!empty($matrix[$month][$name]))
                                {{ number_format($matrix[$month][$name], 2) }}
                            @else
                                <span class="text-muted">—</span>
                            @endif
                        </td>
                    @endforeach
                    <td class="text-end fw-semibold">{{ number_format($rowTotal, 2) }}</td>
                </tr>
                @endforeach
            </tbody>
            <tfoot class="table-light fw-semibold">
                <tr>
                    <td>Column Total</td>
                    @foreach($itemNames as $name)
                        <td class="text-end">
                            {{ number_format($monthlyByItem->where('expense_item_name', $name)->sum('total_amount'), 2) }}
                        </td>
                    @endforeach
                    <td class="text-end">{{ number_format($totals['grand_total'], 2) }}</td>
                </tr>
            </tfoot>
        </table>
    </div>
</div>
@endif