@extends('layouts.app')
@section('title', 'Expense Entry')
@section('content')
<div class="container-fluid">
    <div class="d-flex justify-content-between align-items-center mb-4">
        <h1 class="h3 mb-0 text-gray-800">Expense Entries</h1>
        <a href="{{ route('accounting.expense.create') }}" class="btn btn-primary"><i class="bi bi-plus-lg"></i> Add Expense</a>
    </div>

    <!-- Filter Form -->
    <div class="card mb-4">
        <div class="card-body">
            <form method="GET" action="{{ route('accounting.expense.index') }}" class="row g-3 align-items-end">
                <div class="col-md-3">
                    <label class="form-label">Project</label>
                    <select name="project_id" class="form-select">
                        <option value="">All Projects</option>
                        @foreach($projects as $id => $name)
                            <option value="{{ $id }}" {{ request('project_id') == $id ? 'selected' : '' }}>{{ $name }}</option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-2">
                    <label class="form-label">Date From</label>
                    <input type="date" name="date_from" class="form-control" value="{{ request('date_from') }}">
                </div>
                <div class="col-md-2">
                    <label class="form-label">Date To</label>
                    <input type="date" name="date_to" class="form-control" value="{{ request('date_to') }}">
                </div>
                <div class="col-md-2">
                    <label class="form-label">Payment Method</label>
                    <select name="payment_method" class="form-select">
                        <option value="">All Methods</option>
                        <option value="Cash" {{ request('payment_method') == 'Cash' ? 'selected' : '' }}>Cash</option>
                        <option value="Bank" {{ request('payment_method') == 'Bank' ? 'selected' : '' }}>Bank</option>
                        <option value="Mobile Banking" {{ request('payment_method') == 'Mobile Banking' ? 'selected' : '' }}>Mobile Banking</option>
                    </select>
                </div>
                <div class="col-md-2">
                    <label class="form-label">Status</label>
                    <select name="status" class="form-select">
                        <option value="all" {{ request('status') == 'all' ? 'selected' : '' }}>All</option>
                        <option value="approved" {{ request('status', 'approved') == 'approved' ? 'selected' : '' }}>Approved</option>
                        <option value="pending" {{ request('status') == 'pending' ? 'selected' : '' }}>Pending</option>
                        <option value="rejected" {{ request('status') == 'rejected' ? 'selected' : '' }}>Rejected</option>
                    </select>
                </div>
                <div class="col-md-1">
                    <button type="submit" class="btn btn-primary w-100">Filter</button>
                </div>
            </form>
        </div>
    </div>

    <!-- Total Expense -->
    <div class="alert alert-danger fw-bold">
        Total Expense for filtered period: Tk {{ number_format($totalAmount, 2) }}
    </div>

    <!-- Data Table -->
    <div class="card shadow-sm">
        <div class="card-body p-0">
            <div class="table-responsive">
                <table class="table table-hover mb-0">
                    <thead class="table-light">
                        <tr>
                            <th>Date</th>
                            <th>Project</th>
                            <th>Voucher No</th>
                            <th>Expense Head</th>
                            <th>Method</th>
                            <th>Amount</th>
                            <th>Status</th>
                            <th class="text-end">Actions</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($expenses as $expense)
                        <tr>
                            <td>{{ $expense->entry_date->format('d M, Y') }}</td>
                            <td>{{ $expense->project->project_name ?? 'N/A' }}</td>
                            <td>{{ $expense->voucher_no }}</td>
                            <td>{{ $expense->expense_head }}</td>
                            <td>{{ $expense->payment_method }}</td>
                            <td class="fw-bold">Tk {{ number_format($expense->amount, 2) }}</td>
                            <td>
                                @if($expense->approval_status === 'approved')
                                    <span class="badge bg-success">Approved</span>
                                @elseif($expense->approval_status === 'pending')
                                    <span class="badge bg-warning text-dark">Pending</span>
                                @else
                                    <span class="badge bg-danger">Rejected</span>
                                @endif
                            </td>
                            <td class="text-end">
                                @if($expense->approval_status !== 'approved')
                                    <a href="{{ route('accounting.expense.edit', $expense) }}" class="btn btn-sm btn-outline-primary">Edit</a>
                                    <form action="{{ route('accounting.expense.destroy', $expense) }}" method="POST" class="d-inline" onsubmit="return confirm('Are you sure?')">
                                        @csrf @method('DELETE')
                                        <button class="btn btn-sm btn-outline-danger">Del</button>
                                    </form>
                                @else
                                    <span class="text-muted small">Locked</span>
                                @endif
                            </td>
                        </tr>
                        @empty
                        <tr><td colspan="7" class="text-center py-3">No expense entries found.</td></tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
            <div class="p-3">{{ $expenses->links() }}</div>
        </div>
    </div>
</div>
@endsection