@extends('layouts.app')
@section('title','Expenses Report')
@section('styles')<style>@media print{.no-print{display:none!important}body{background:#fff}}</style>@endsection
@section('content')
<h1 class="text-lg font-bold text-gray-900 mb-1">Expenses Report</h1>
@include('reports._date-filter')
<div class="grid grid-cols-3 gap-3 mb-4"><div class="stat-card"><p class="text-xs text-gray-400 uppercase">Total Amount</p><p class="text-xl font-bold">KES {{ number_format($totals['amount']) }}</p></div><div class="stat-card"><p class="text-xs text-gray-400 uppercase">Paid</p><p class="text-xl font-bold text-green-600">KES {{ number_format($totals['paid']) }}</p></div><div class="stat-card"><p class="text-xs text-gray-400 uppercase">Pending</p><p class="text-xl font-bold text-red-600">KES {{ number_format($totals['balance']) }}</p></div></div>
<div class="bg-white rounded-xl border shadow-sm mb-4"><div class="px-5 py-3 border-b"><h3 class="text-sm font-bold">By Category</h3></div>
<table class="w-full"><thead><tr class="bg-gray-50"><th class="table-header">Category</th><th class="table-header text-right">Count</th><th class="table-header text-right">Amount</th><th class="table-header text-right">Paid</th><th class="table-header text-right">Balance</th></tr></thead>
<tbody>@foreach($byCategory as $cat => $v)<tr class="border-b border-gray-50"><td class="table-cell font-medium text-xs">{{ $cat }}</td><td class="table-cell text-right text-xs">{{ $v['count'] }}</td><td class="table-cell text-right text-xs">{{ number_format($v['amount']) }}</td><td class="table-cell text-right text-xs text-green-600">{{ number_format($v['paid']) }}</td><td class="table-cell text-right text-xs text-red-600">{{ number_format($v['balance']) }}</td></tr>@endforeach</tbody></table></div>
@endsection