@extends('layouts.app')
@section('title','Expenditures')
@section('page-title','Expenditures')
@section('content')
<div class="page-header d-flex justify-content-between align-items-center">
  <h5 class="mb-0"><i class="bi bi-cash-coin me-2"></i>Expenditures</h5>
  <a href="{{ route('expenditures.create') }}" class="btn btn-primary btn-sm"><i class="bi bi-plus-lg me-1"></i>Add Expenditure</a>
</div>
<div class="card stat-card mb-3">
  <div class="card-body py-2">
    <form class="row g-2 align-items-end" method="GET">
      <div class="col-md-2"><label class="form-label small mb-1">Project</label><select name="project_id" class="form-select form-select-sm"><option value="">All Projects</option>@foreach($projects as $p)<option value="{{ $p->id }}" {{ request('project_id')==$p->id?'selected':'' }}>{{ $p->name }}</option>@endforeach</select></div>
      <div class="col-md-2"><label class="form-label small mb-1">Category</label><select name="category_id" class="form-select form-select-sm"><option value="">All Categories</option>@foreach($categories as $c)<option value="{{ $c->id }}" {{ request('category_id')==$c->id?'selected':'' }}>{{ $c->name }}</option>@endforeach</select></div>
      <div class="col-md-2"><label class="form-label small mb-1">From</label><input name="date_from" type="date" class="form-control form-control-sm" value="{{ request('date_from') }}"></div>
      <div class="col-md-2"><label class="form-label small mb-1">To</label><input name="date_to" type="date" class="form-control form-control-sm" value="{{ request('date_to') }}"></div>
      <div class="col-md-2"><label class="form-label small mb-1">Status</label><select name="is_paid" class="form-select form-select-sm"><option value="">All</option><option value="1" {{ request('is_paid')==='1'?'selected':'' }}>Paid</option><option value="0" {{ request('is_paid')==='0'?'selected':'' }}>Pending</option></select></div>
      <div class="col-md-2"><button class="btn btn-primary btn-sm w-100" type="submit"><i class="bi bi-search me-1"></i>Filter</button></div>
    </form>
  </div>
</div>
<div class="card stat-card">
  <div class="card-header bg-white border-0 d-flex justify-content-between pt-3 px-3">
    <span class="fw-semibold">{{ $expenditures->total() }} records</span>
    <span class="fw-bold text-primary">Total: GH₵ {{ number_format($totalShown,2) }}</span>
  </div>
  <div class="table-responsive">
    <table class="table table-hover mb-0">
      <thead><tr><th>Date</th><th>Project</th><th>Description</th><th>Category</th><th>Qty</th><th class="text-end">Amount</th><th>Payment</th><th>Status</th><th></th></tr></thead>
      <tbody>
        @forelse($expenditures as $exp)
        <tr>
          <td class="small">{{ $exp->date->format('d/m/Y') }}</td>
          <td class="small">{{ $exp->project->name ?? '-' }}</td>
          <td class="small">{{ Str::limit($exp->description,45) }}</td>
          <td><span class="badge" style="background:{{ $exp->category->color??'#6c757d' }}">{{ $exp->category->code??'-' }}</span></td>
          <td class="small">{{ $exp->quantity ? $exp->quantity.' '.$exp->unit : '-' }}</td>
          <td class="text-end fw-semibold small">GH₵ {{ number_format($exp->amount,2) }}</td>
          <td class="small">{{ $exp->payment_mode }}</td>
          <td><span class="badge {{ $exp->is_paid?'bg-success':'bg-warning text-dark' }}">{{ $exp->is_paid?'Paid':'Pending' }}</span></td>
          <td><a href="{{ route('expenditures.edit',$exp) }}" class="btn btn-xs btn-outline-secondary" style="font-size:.75rem;padding:.15rem .4rem"><i class="bi bi-pencil"></i></a></td>
        </tr>
        @empty<tr><td colspan="9" class="text-center py-4 text-muted">No expenditures found.</td></tr>
        @endforelse
      </tbody>
    </table>
  </div>
  <div class="card-footer bg-white">{{ $expenditures->links() }}</div>
</div>
@endsection