@extends('layouts.app')

@section('title', 'Cash Book')
@section('page', 'cash-book')
@section('cashNav', 'entries')

@php
  $typeVariant = fn ($t) => $t === 'In' ? 'success' : 'danger';
  $statusVariant = fn ($s) => $s === 'Active' ? 'success' : 'danger';
  $presetCategories = [
    'Opening Balance',
    'Sales',
    'Transfer',
  ];
  $categoryOptions = collect($presetCategories)
    ->merge($expenseCategories ?? [])
    ->merge($categories ?? [])
    ->unique()
    ->sort()
    ->values();
  $defaultCashBookId = $selectedCashBookId
    ?: ($cashBooks->first()?->id);
@endphp

@section('content')
  @include('partials.account-cash-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="cash-book-table"
    class="catalog-table cash-book-table"
    title="Cash Book"
    subtitle="Track cash in, cash out, and running balance by cash book."
    search-placeholder="Search cash book..."
    :selectable="false"
    :page-size="15"
  >
    <x-slot:toolbarActions>
      <button type="button" class="btn btn-primary" data-bs-toggle="modal" data-bs-target="#cashBookModal" data-cash-book-add>
        <i class="bi bi-plus-lg"></i> Add Entry
      </button>
    </x-slot:toolbarActions>
    <x-slot:filters>
      <x-date-range-filter
        :action="route('account.cash-book')"
        :date-from="$dateFrom"
        :date-to="$dateTo"
        :filter-month="$filterMonth"
        :show-month="false"
      >
        <x-slot:before>
          @if ($selectedCashBookId)
            <input type="hidden" name="cash_book_id" value="{{ $selectedCashBookId }}">
          @endif
        </x-slot:before>
      </x-date-range-filter>
      <select class="form-select form-select-sm" aria-label="Cash Book" data-cash-book-filter>
        <option value="">All Cash Books</option>
        @foreach ($cashBooks as $book)
          <option value="{{ $book->id }}" @selected((int) $selectedCashBookId === (int) $book->id)>{{ $book->name }}</option>
        @endforeach
      </select>
      <select class="form-select form-select-sm" data-edt-col-filter="category" aria-label="Category">
        <option value="">All Categories</option>
        @foreach ($categoryOptions as $category)
          <option>{{ $category }}</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-sunrise"></i></span>
              </span>
              <div class="product-kpi__body">
                <p class="product-kpi__label">Opening Balance</p>
                <p class="product-kpi__value">{{ money($openingBalance) }}</p>
                <p class="product-kpi__meta">Balance before {{ $dateFrom }}</p>
              </div>
            </div>
          </div>
          <div class="col-6 col-md-3 product-stat-col">
            <div class="product-kpi product-kpi--success">
              <span class="product-kpi__icon" aria-hidden="true">
                <span class="product-kpi__glyph"><i class="bi bi-arrow-down-left"></i></span>
              </span>
              <div class="product-kpi__body">
                <p class="product-kpi__label">Total In</p>
                <p class="product-kpi__value">{{ money($totalIn) }}</p>
                <p class="product-kpi__meta">Cash received</p>
              </div>
            </div>
          </div>
          <div class="col-6 col-md-3 product-stat-col">
            <div class="product-kpi product-kpi--danger">
              <span class="product-kpi__icon" aria-hidden="true">
                <span class="product-kpi__glyph"><i class="bi bi-arrow-up-right"></i></span>
              </span>
              <div class="product-kpi__body">
                <p class="product-kpi__label">Total Out</p>
                <p class="product-kpi__value">{{ money($totalOut) }}</p>
                <p class="product-kpi__meta">Cash paid</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-wallet2"></i></span>
              </span>
              <div class="product-kpi__body">
                <p class="product-kpi__label">Closing Balance</p>
                <p class="product-kpi__value">{{ money($currentBalance) }}</p>
                <p class="product-kpi__meta">As of {{ $dateTo }}</p>
              </div>
            </div>
          </div>
        </div>
      </div>
    </x-slot:afterToolbar>
    <x-slot:head>
      <x-data-table-th label="Date" col="entry_date" />
      <x-data-table-th label="Account" col="cash_book" />
      <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 ($entries as $row)
        <tr data-id="{{ $row->id }}">
          <td data-col="entry_date">{{ $row->entry_date->format('Y-m-d') }}</td>
          <td data-col="cash_book">{{ $row->cashBook?->name ?? ($selectedCashBookName ?? '—') }}</td>
          <td data-col="category" class="cell-primary">{{ $row->category }}</td>
          <td data-col="notes">{{ preg_match('/^(Bill No\s+\d+)/i', (string) $row->notes, $m) ? $m[1] : ($row->notes ?: '—') }}</td>
          <td data-col="amount_in">{{ $row->type === 'In' ? money((float) $row->amount) : '—' }}</td>
          <td data-col="amount_out">{{ $row->type === 'Out' ? money((float) $row->amount) : '—' }}</td>
          <td data-col="balance" class="fw-semibold">{{ money((float) $row->running_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">
              <button
                type="button"
                class="btn btn-sm btn-icon product-action product-action--edit"
                title="Edit"
                aria-label="Edit"
                data-edt-action="edit"
                data-backend
                data-cash-book-edit
                data-id="{{ $row->id }}"
                data-cash-book-id="{{ $row->cash_book_id }}"
                data-entry-date="{{ $row->entry_date->format('Y-m-d') }}"
                data-type="{{ $row->type }}"
                data-category="{{ $row->category }}"
                data-amount="{{ $row->amount }}"
                data-notes="{{ $row->notes }}"
                data-status="{{ $row->status }}"
                data-update-url="{{ route('account.cash-book.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-edt-action="delete"
                data-backend
                data-delete-open
                data-delete-url="{{ route('account.cash-book.destroy', $row) }}"
                data-delete-label="{{ $row->entry_date->format('Y-m-d') }} · {{ $row->category }} ({{ $row->type }} {{ number_format((float) $row->amount, 2) }})"
                data-delete-type="cash book entry"
              >
                <i class="bi bi-trash" aria-hidden="true"></i>
              </button>
            </div>
          </td>
        </tr>
      @empty
        <tr data-edt-empty-row>
          <td colspan="9" class="text-center text-muted py-4">No cash book entries yet. Add your first entry.</td>
        </tr>
      @endforelse
    </x-slot:body>
  </x-data-table>

  <div class="modal fade" id="cashBookModal" tabindex="-1" aria-labelledby="cashBookModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-dialog-centered modal-lg">
      <div class="modal-content edt-modal">
        <form id="cash-book-form" method="post" action="{{ route('account.cash-book.store') }}" data-store-url="{{ route('account.cash-book.store') }}" data-filter-date-from="{{ $dateFrom }}" data-filter-date-to="{{ $dateTo }}" data-filter-cash-book-id="{{ $selectedCashBookId }}">
          @csrf
          <input type="hidden" name="_method" id="cash_book_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
          @if ($selectedCashBookId)
            <input type="hidden" name="filter_cash_book_id" value="{{ $selectedCashBookId }}">
          @endif
          <div class="modal-header">
            <h2 class="modal-title fs-5" id="cashBookModalLabel">Add cash book entry</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="cash_book_id">Cash Book</label>
                <select class="form-select" id="cash_book_id" name="cash_book_id" required>
                  @forelse ($cashBooks as $book)
                    <option value="{{ $book->id }}" @selected((string) old('cash_book_id', $defaultCashBookId) === (string) $book->id)>{{ $book->name }}</option>
                  @empty
                    <option value="">No cash books — add one first</option>
                  @endforelse
                </select>
              </div>
              <div class="col-md-4">
                <label class="form-label" for="cash_entry_date">Date</label>
                <input type="date" class="form-control" id="cash_entry_date" name="entry_date" required value="{{ old('entry_date', now()->toDateString()) }}">
              </div>
              <div class="col-md-4">
                <label class="form-label" for="cash_type">Type</label>
                <select class="form-select" id="cash_type" name="type" required>
                  <option value="In" @selected(old('type', 'In') === 'In')>In</option>
                  <option value="Out" @selected(old('type') === 'Out')>Out</option>
                </select>
              </div>
              <div class="col-md-4">
                <label class="form-label" for="cash_amount">Amount</label>
                <input type="number" step="0.01" min="0.01" class="form-control" id="cash_amount" name="amount" required value="{{ old('amount') }}">
              </div>
              <div class="col-md-4">
                <label class="form-label" for="cash_category">Category</label>
                <input
                  type="text"
                  class="form-control"
                  id="cash_category"
                  name="category"
                  list="cash-category-list"
                  required
                  maxlength="100"
                  placeholder="e.g. Sales, Purchase, Salary"
                  value="{{ old('category') }}"
                >
                <datalist id="cash-category-list">
                  @foreach ($categoryOptions as $category)
                    <option value="{{ $category }}"></option>
                  @endforeach
                </datalist>
              </div>
              <div class="col-md-4">
                <label class="form-label" for="cash_status">Status</label>
                <select class="form-select" id="cash_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="cash_notes">Notes</label>
                <input type="text" class="form-control" id="cash_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" id="cash-book-form-submit">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
          @if ($selectedCashBookId)
            <input type="hidden" name="filter_cash_book_id" value="{{ $selectedCashBookId }}">
          @endif
          <div class="modal-header">
            <h2 class="modal-title fs-5" id="deleteConfirmModalLabel">Delete cash book entry</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 entry</strong>? This action cannot be undone.</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>
@endsection

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

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