@extends('backend.layouts.app')
@section('content')
    <h4 class="mb-4">Expense Report</h4>

    {{-- Filters --}}
    <form method="GET" class="row g-3 mb-4">
        <div class="col-md-2">
            <label>Start Date</label>
            <input type="date" name="start_date" class="form-control" value="{{ request('start_date') }}">
        </div>
        <div class="col-md-2">
            <label>End Date</label>
            <input type="date" name="end_date" class="form-control" value="{{ request('end_date') }}">
        </div>
        <div class="col-md-2">
            <label>Payment Status</label>
            <select name="payment_status" class="form-select">
                <option value="">-- All --</option>
                <option value="paid" {{ request('payment_status') == 'paid' ? 'selected' : '' }}>Paid</option>
                <option value="unpaid" {{ request('payment_status') == 'unpaid' ? 'selected' : '' }}>Unpaid</option>
            </select>
        </div>
        <div class="col-md-2">
            <label>Expense Type</label>
            <select name="expense_type_id" class="form-select">
                <option value="">-- All Types --</option>
                @foreach($expenseTypes as $type)
                    <option value="{{ $type->id }}" {{ request('expense_type_id') == $type->id ? 'selected' : '' }}>
                        {{ $type->name }}
                    </option>
                @endforeach
            </select>
        </div>
        <div class="col-md-2 d-flex align-items-end">
            <button type="submit" class="btn btn-primary w-100">Filter</button>
        </div>
    </form>

    {{-- Summary --}}
    <div class="row mb-4">
        <div class="col-md-4">
            <div class="card bg-primary text-white p-3">
                <div>Total Expense</div>
                <h5>{{ number_format($totalExpense, 2) }}</h5>
            </div>
        </div>
        <div class="col-md-4">
            <div class="card bg-success text-white p-3">
                <div>Paid</div>
                <h5>{{ number_format($totalPaid, 2) }}</h5>
            </div>
        </div>
        <div class="col-md-4">
            <div class="card bg-danger text-white p-3">
                <div>Unpaid</div>
                <h5>{{ number_format($totalUnpaid, 2) }}</h5>
            </div>
        </div>
    </div>

    {{-- Table --}}
    <div class="table-responsive">
        <table class="table table-bordered table-striped align-middle">
            <thead>
                <tr>
                    <th>#</th>
                    <th>Date</th>
                    <th>Expense Type</th>
                    <th>Amount</th>
                    <th>Voucher No</th>
                    <th>Status</th>
                    <th>Payment By</th>
                    <th>Remark</th>
                </tr>
            </thead>
            <tbody>
                @forelse($expenses as $key => $item)
                    <tr>
                        <td>{{ $expenses->firstItem() + $key }}</td>
                        <td>{{ $item->date }}</td>
                        <td>{{ $item->expenseType->name ?? '-' }}</td>
                        <td>{{ number_format($item->amount, 2) }}</td>
                        <td>{{ $item->vouche_no ?? '-' }}</td>
                        <td>
                            <span class="badge bg-{{ $item->payment_status == 'paid' ? 'success' : 'danger' }}">
                                {{ ucfirst($item->payment_status) }}
                            </span>
                        </td>
                        <td>{{ ucfirst($item->payment_by ?? '-') }}</td>
                        <td>{{ $item->remark ?? '-' }}</td>
                    </tr>
                @empty
                    <tr>
                        <td colspan="8" class="text-center text-muted">No expenses found.</td>
                    </tr>
                @endforelse
            </tbody>
        </table>
    </div>

    {{-- Pagination --}}
    @if ($expenses instanceof \Illuminate\Pagination\LengthAwarePaginator)
        <div class="mt-3">
            {{ $expenses->links('backend.layouts.paginate') }}
        </div>
    @endif
@endsection