@extends('layouts.app')

@section('title', 'Expenses')
@section('page', 'expenses')
@section('expensesNav', 'expenses')

@php
  $statusVariant = fn ($s) => $s === 'Active' ? 'success' : 'danger';
@endphp

@section('content')
  @include('partials.account-expenses-nav')

  @if (session('success'))
    <x-alert class="mb-3" variant="success" icon="bi-check-circle">{{ session('success') }}</x-alert>
  @endif

  @if ($errors->any())
    <x-alert class="mb-3" variant="danger" icon="bi-exclamation-triangle">{{ $errors->first() }}</x-alert>
  @endif

  <x-data-table
    id="expenses-table"
    class="catalog-table"
    title="Expenses"
    subtitle="Record expenses and post them to cash book or bank book. Showing {{ $dateFrom }} to {{ $dateTo }}."
    search-placeholder="Search expenses..."
    :selectable="false"
    :page-size="15"
  >
    <x-slot:toolbarActions>
      @if ($canManage ?? false)
        <button type="button" class="btn btn-primary" data-bs-toggle="modal" data-bs-target="#expenseModal" data-expense-add @disabled($categories->isEmpty())>
          <i class="bi bi-plus-lg"></i> Add Expense
        </button>
      @endif
    </x-slot:toolbarActions>
    <x-slot:filters>
      <x-date-range-filter
        :action="route('account.expenses')"
        :date-from="$dateFrom"
        :date-to="$dateTo"
        :filter-month="$filterMonth"
        :show-month="false"
      />
      <select class="form-select form-select-sm" data-edt-col-filter="category" aria-label="Category">
        <option value="">All Categories</option>
        @foreach ($categories as $category)
          <option>{{ $category->name }}</option>
        @endforeach
      </select>
      <select class="form-select form-select-sm" data-edt-col-filter="status" aria-label="Status">
        <option value="">All Statuses</option>
        <option>Active</option>
        <option>Cancel</option>
      </select>
    </x-slot:filters>
    <x-slot:afterToolbar>
      <div class="product-stats-panel">
        <div class="row g-3 product-stats product-stats--4 justify-content-start">
          <div class="col-6 col-md-3 product-stat-col">
            <div class="product-kpi product-kpi--warning">
              <span class="product-kpi__icon" aria-hidden="true">
                <span class="product-kpi__glyph"><i class="bi bi-receipt"></i></span>
              </span>
              <div class="product-kpi__body">
                <p class="product-kpi__label">Total Expenses</p>
                <p class="product-kpi__value">{{ money($totalExpenses) }}</p>
                <p class="product-kpi__meta">Active in period</p>
              </div>
            </div>
          </div>
          <div class="col-6 col-md-3 product-stat-col">
            <div class="product-kpi product-kpi--primary">
              <span class="product-kpi__icon" aria-hidden="true">
                <span class="product-kpi__glyph"><i class="bi bi-list-ul"></i></span>
              </span>
              <div class="product-kpi__body">
                <p class="product-kpi__label">Records</p>
                <p class="product-kpi__value">{{ $entryCount }}</p>
                <p class="product-kpi__meta">In selected period</p>
              </div>
            </div>
          </div>
        </div>
      </div>
    </x-slot:afterToolbar>
    <x-slot:head>
      <x-data-table-th label="Date" col="date" />
      <x-data-table-th label="Account" col="account" />
      <x-data-table-th label="Category" col="category" />
      <x-data-table-th label="Notes" col="notes" />
      <x-data-table-th label="In" col="amount_in" sort-type="number" />
      <x-data-table-th label="Out" col="amount_out" sort-type="number" />
      <x-data-table-th label="Balance" col="balance" sort-type="number" />
      <x-data-table-th label="Status" col="status" />
    </x-slot:head>
    <x-slot:body>
      @forelse ($expenses as $row)
        <tr data-id="{{ $row->id }}">
          <td data-col="date">{{ $row->expense_date?->format('Y-m-d') ?? '—' }}</td>
          <td data-col="account">
            @if ($row->pay_from === 'cash_book')
              {{ $row->cashBook?->name ?? '—' }}
            @else
              {{ $row->bankAccount?->name ?? '—' }}
            @endif
          </td>
          <td data-col="category" class="cell-primary">{{ $row->category?->name ?? '—' }}</td>
          <td data-col="notes">{{ $row->notes ?: '—' }}</td>
          <td data-col="amount_in">—</td>
          <td data-col="amount_out" data-sort-value="{{ $row->amount }}">{{ money((float) $row->amount) }}</td>
          <td data-col="balance">—</td>
          <td data-col="status"><x-badge :variant="$statusVariant($row->status)">{{ $row->status }}</x-badge></td>
          <td data-edt-actions>
            <div class="edt-row-actions product-actions">
              @if ($canManage ?? false)
              <button
                type="button"
                class="btn btn-sm btn-icon product-action product-action--edit"
                title="Edit"
                aria-label="Edit"
                data-expense-edit
                data-id="{{ $row->id }}"
                data-category-id="{{ $row->expense_category_id }}"
                data-date="{{ $row->expense_date?->format('Y-m-d') }}"
                data-amount="{{ number_format((float) $row->amount, 2, '.', '') }}"
                data-pay-from="{{ $row->pay_from }}"
                data-cash-book-id="{{ $row->cash_book_id }}"
                data-bank-account-id="{{ $row->bank_account_id }}"
                data-notes="{{ $row->notes }}"
                data-status="{{ $row->status }}"
                data-update-url="{{ route('account.expenses.update', $row) }}"
              >
                <i class="bi bi-pencil" aria-hidden="true"></i>
              </button>
              <button
                type="button"
                class="btn btn-sm btn-icon product-action product-action--delete"
                title="Delete"
                aria-label="Delete"
                data-delete-open
                data-delete-type="expense"
                data-delete-label="{{ $row->category?->name ?? 'this expense' }} ({{ money((float) $row->amount) }})"
                data-delete-url="{{ route('account.expenses.destroy', $row) }}"
              >
                <i class="bi bi-trash" aria-hidden="true"></i>
              </button>
              @endif
            </div>
          </td>
        </tr>
      @empty
        <tr data-edt-empty-row>
          <td colspan="9" class="text-center text-muted py-4">No expenses yet. Add an expense category first, then record expenses.</td>
        </tr>
      @endforelse
    </x-slot:body>
  </x-data-table>

  @if ($canManage ?? false)
  <div class="modal fade" id="expenseModal" tabindex="-1" aria-labelledby="expenseModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-dialog-centered modal-lg">
      <div class="modal-content edt-modal">
        <form id="expense-form" method="post" action="{{ route('account.expenses.store') }}" data-store-url="{{ route('account.expenses.store') }}">
          @csrf
          <input type="hidden" name="_method" id="expense_form_method" value="POST">
          <input type="hidden" name="filter_date_from" value="{{ $dateFrom }}">
          <input type="hidden" name="filter_date_to" value="{{ $dateTo }}">
          @if ($filterMonth)
            <input type="hidden" name="filter_month" value="{{ $filterMonth }}">
          @endif
          <div class="modal-header">
            <h2 class="modal-title fs-5" id="expenseModalLabel">Add expense</h2>
            <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
          </div>
          <div class="modal-body">
            <div class="row g-3">
              <div class="col-md-4">
                <label class="form-label" for="expense_date">Date</label>
                <input type="date" class="form-control" id="expense_date" name="expense_date" required value="{{ old('expense_date', now()->toDateString()) }}">
              </div>
              <div class="col-md-4">
                <label class="form-label" for="expense_category_id">Category</label>
                <select class="form-select" id="expense_category_id" name="expense_category_id" required>
                  @forelse ($categories as $category)
                    <option value="{{ $category->id }}" @selected((string) old('expense_category_id') === (string) $category->id)>{{ $category->name }}</option>
                  @empty
                    <option value="">No categories — add one first</option>
                  @endforelse
                </select>
              </div>
              <div class="col-md-4">
                <label class="form-label" for="expense_amount">Amount</label>
                <input type="number" step="0.01" min="0.01" class="form-control" id="expense_amount" name="amount" required value="{{ old('amount') }}">
              </div>
              <div class="col-md-4">
                <label class="form-label" for="expense_pay_from">Pay from</label>
                <select class="form-select" id="expense_pay_from" name="pay_from" required>
                  <option value="cash_book" @selected(old('pay_from', 'cash_book') === 'cash_book')>Cash Book</option>
                  <option value="bank_account" @selected(old('pay_from') === 'bank_account')>Bank Account</option>
                </select>
              </div>
              <div class="col-md-4" data-pay-source="cash_book">
                <label class="form-label" for="expense_cash_book_id">Cash Book</label>
                <select class="form-select" id="expense_cash_book_id" name="cash_book_id">
                  @forelse ($cashBooks as $book)
                    <option value="{{ $book->id }}" @selected((string) old('cash_book_id') === (string) $book->id)>{{ $book->name }}</option>
                  @empty
                    <option value="">No cash books</option>
                  @endforelse
                </select>
              </div>
              <div class="col-md-4 d-none" data-pay-source="bank_account">
                <label class="form-label" for="expense_bank_account_id">Bank Account</label>
                <select class="form-select" id="expense_bank_account_id" name="bank_account_id">
                  @forelse ($bankAccounts as $account)
                    <option value="{{ $account->id }}" @selected((string) old('bank_account_id') === (string) $account->id)>{{ $account->name }}</option>
                  @empty
                    <option value="">No bank accounts</option>
                  @endforelse
                </select>
              </div>
              <div class="col-md-4">
                <label class="form-label" for="expense_status">Status</label>
                <select class="form-select" id="expense_status" name="status" required>
                  <option value="Active" @selected(old('status', 'Active') === 'Active')>Active</option>
                  <option value="Cancel" @selected(old('status') === 'Cancel')>Cancel</option>
                </select>
              </div>
              <div class="col-12">
                <label class="form-label" for="expense_notes">Notes</label>
                <input type="text" class="form-control" id="expense_notes" name="notes" maxlength="1000" value="{{ old('notes') }}" placeholder="Optional note">
              </div>
            </div>
          </div>
          <div class="modal-footer">
            <button type="button" class="btn btn-outline-secondary" data-bs-dismiss="modal">Cancel</button>
            <button type="submit" class="btn btn-primary">Save</button>
          </div>
        </form>
      </div>
    </div>
  </div>

  <div class="modal fade" id="deleteConfirmModal" tabindex="-1" aria-labelledby="deleteConfirmModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-dialog-centered">
      <div class="modal-content edt-modal">
        <form id="delete-confirm-form" method="post" action="#">
          @csrf
          @method('DELETE')
          <input type="hidden" name="filter_date_from" value="{{ $dateFrom }}">
          <input type="hidden" name="filter_date_to" value="{{ $dateTo }}">
          @if ($filterMonth)
            <input type="hidden" name="filter_month" value="{{ $filterMonth }}">
          @endif
          <div class="modal-header">
            <h2 class="modal-title fs-5" id="deleteConfirmModalLabel">Delete expense</h2>
            <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
          </div>
          <div class="modal-body">
            <p class="mb-0">Are you sure you want to delete <strong id="delete-confirm-name">this expense</strong>? The linked cash/bank book entry will also be removed.</p>
          </div>
          <div class="modal-footer">
            <button type="button" class="btn btn-outline-secondary" data-bs-dismiss="modal">Cancel</button>
            <button type="submit" class="btn btn-danger"><i class="bi bi-trash"></i> Delete</button>
          </div>
        </form>
      </div>
    </div>
  </div>
  @endif
@endsection

@push('styles')
  <link href="{{ asset('assets/css/pages/products.css') }}" rel="stylesheet">
@endpush

@push('scripts')
  <script src="{{ asset('assets/js/pages/expenses.js') }}"></script>
@endpush