@extends('admin.admin_dashboard')
@section('admin')

<div class="page-content">
  <div class="container-fluid">
    <h4 class="mb-4 fw-bold">Bank Statement</h4>

    {{-- Filter Form --}}
    <form method="GET" action="{{ route('bank.reconciliation.index') }}" class="card p-3 shadow-sm mb-4">
      <div class="row g-3 align-items-end">
        <div class="col-md-4">
          <label for="bank_account_id" class="form-label">Bank Account</label>
          <select name="bank_account_id" id="bank_account_id" class="form-select">
            @foreach ($accounts as $account)
              <option value="{{ $account->id }}" {{ $account->id == $bankAccountId ? 'selected' : '' }}>
                {{ $account->code }} - {{ $account->name }}
              </option>
            @endforeach
          </select>
        </div>

        <div class="col-md-3">
          <label for="month" class="form-label">Select Month</label>
          <input type="month" name="month" id="month" class="form-control" value="{{ $month }}">
        </div>

        <div class="col-md-2">
          <label for="year" class="form-label">Or Select Year</label>
          <select name="year" id="year" class="form-select">
            <option value="">--</option>
            @for ($y = 2025; $y <= now()->year; $y++)
              <option value="{{ $y }}" {{ $year == $y ? 'selected' : '' }}>{{ $y }}</option>
            @endfor
          </select>
        </div>

        <div class="col-md-2">
          <button type="submit" class="btn btn-primary w-100">
            <i class="bx bx-search-alt me-1"></i> View
          </button>
        </div>
      </div>
    </form>

    <div class="card shadow-sm">
      <div class="card-body">
        <h5 class="card-title">Statement for {{ $label }}</h5>

        <div class="mb-3">
          <strong>Opening Balance:</strong> UGX {{ number_format($openingBalance ?? 0, 0) }} <br>
          <strong>Closing Balance:</strong> UGX {{ number_format($closingBalance ?? 0, 0) }}
        </div>

        {{-- Transaction Search --}}
        <div class="mb-3">
          <input type="text" id="transactionSearch" class="form-control" placeholder="Search transactions...">
        </div>

        <div class="d-flex justify-content-between align-items-center mb-3">
          <form method="GET" action="{{ route('bank.reconciliation.pdf') }}" target="_blank">
            <input type="hidden" name="bank_account_id" value="{{ $bankAccountId }}">
            <input type="hidden" name="month" value="{{ $month }}">
            <input type="hidden" name="year" value="{{ $year }}">
            <button type="submit" class="btn btn-sm btn-outline-secondary">
              <i class="bx bx-download me-1"></i> Download PDF
            </button>
          </form>
        </div>

        {{-- Transactions Table --}}
        @if ($transactions->count())
          <div class="table-responsive">
            <table id="transactionsTable" class="table table-hover table-bordered align-middle">
              <thead class="table-light text-center">
                <tr>
                  <th>Date</th>
                  <th>Description</th>
                  <th>Reference</th>
                  <th>Debit</th>
                  <th>Credit</th>
                  <th>Closing Balance</th>
                </tr>
              </thead>
              <tbody>
                @php 
                  $runningBalance = $openingBalance ?? 0;
                  $totalDebit = 0;
                  $totalCredit = 0;
                @endphp

                @foreach ($transactions as $index => $tx)
                  @php
                    $runningBalance += (float) $tx->debit - (float) $tx->credit;
                    $totalDebit += (float) $tx->debit;
                    $totalCredit += (float) $tx->credit;

                    $lines = \DB::table('journal_entry_lines as l')
                        ->join('accounts as a', 'a.id', '=', 'l.account_id')
                        ->where('l.journal_entry_id', $tx->journal_entry_id)
                        ->select('a.id as account_id', 'a.name as account_name', 'l.debit', 'l.credit', 'l.memo')
                        ->get();
                  @endphp

                 <tr class="journal-row"
    id="journal-row-{{ $tx->journal_entry_id }}"
    data-id="{{ $tx->journal_entry_id }}"
    data-date="{{ $tx->entry_date ? \Carbon\Carbon::parse($tx->entry_date)->format('Y-m-d') : '' }}"
    data-reference="{{ $tx->reference }}"
    data-description="{{ $tx->memo ?? '' }}"
    data-lines='@json($lines)'>
  <td class="entry-date">{{ \Carbon\Carbon::parse($tx->entry_date)->format('F j, Y') }}</td>
  <td class="entry-memo">{{ $tx->memo ?? 'N/A' }}</td>
  <td class="entry-ref">{{ $tx->reference ?? '—' }}</td>
  <td class="entry-debit text-end fw-bold">{{ $tx->debit ? number_format($tx->debit, 0) : '-' }}</td>
  <td class="entry-credit text-end fw-bold">{{ $tx->credit ? number_format($tx->credit, 0) : '-' }}</td>
  <td class="entry-balance text-end fw-bold">{{ number_format($runningBalance, 0) }}</td>
</tr>

                @endforeach
              </tbody>

              <tfoot>
                <tr class="table-light fw-bold text-end">
                  <td colspan="3" class="text-center">Totals</td>
                  <td>{{ number_format($totalDebit, 0) }}</td>
                  <td>{{ number_format($totalCredit, 0) }}</td>
                  <td></td>
                </tr>
              </tfoot>
            </table>
          </div>
        @else
          <div class="alert alert-info">No transactions found for this period.</div>
        @endif
      </div>
    </div>

    {{-- Journal Modal (from Account Details page) --}}
    @include('accounting.modal.journal_modal', ['accounts' => $accounts])

  </div>
</div>

{{-- Search Filter Script --}}
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet"/>
<script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/sweetalert2@11"></script>

<script>
$(function(){
  $('#transactionSearch').on('keyup', function(){
    const val = $(this).val().toLowerCase();
    $('#transactionsTable tbody tr').filter(function(){
      $(this).toggle($(this).text().toLowerCase().indexOf(val) > -1);
    });
  });

  // ✅ Attach the same modal handling as the Account Details version
  const opts = {
    theme: 'bootstrap-5',
    width: '100%',
    dropdownParent: $('#journalModal')
  };

  function fmt(n){ 
    if(n === '' || n === null || isNaN(n)) return '0';
    n = parseFloat(n.toString().replace(/,/g,''));
    return (n % 1 === 0) ? n.toLocaleString('en-US') : n.toLocaleString('en-US',{minimumFractionDigits:2, maximumFractionDigits:2});
  }

  function num(n){ return parseFloat(n.toString().replace(/,/g,''))||0; }

  const $tbody = $('#linesTable tbody');
  let idx = 0, currentRow = null;

  function calcTotals(){
    let td=0, tc=0;
    $tbody.find('.debit').each(function(){ td+=num($(this).val()); });
    $tbody.find('.credit').each(function(){ tc+=num($(this).val()); });
    $('#totalDebit').text(fmt(td)); 
    $('#totalCredit').text(fmt(tc));
    if(td===tc && td>0){ 
      $('#balanceWarning').addClass('d-none'); 
      $('#saveChanges').prop('disabled', false); 
    } else { 
      $('#balanceWarning').removeClass('d-none'); 
      $('#saveChanges').prop('disabled', true); 
    }
  }

  function renderLine(line={}, editable=false){
    const tpl = $('#line-template').html().replace(/__INDEX__/g, idx++);
    const $row = $(tpl);
    $row.find('select.account-select')
        .val(line.account_id || '')
        .prop('disabled', !editable)
        .select2(opts);
    $row.find('.debit').val(fmt(line.debit||0)).prop('readonly', !editable);
    $row.find('.credit').val(fmt(line.credit||0)).prop('readonly', !editable);
    $row.find('input[name$="[memo]"]').val(line.memo||'').prop('readonly', !editable);
    $row.find('.remove-line-btn').prop('disabled', !editable);
    $tbody.append($row);
    return $row;
  }

  $('.journal-row').on('click', function(){
    currentRow = $(this);
    const d = currentRow.data();
    idx=0;
    $tbody.empty();

    $('#entry_id').val(d.id);
    $('#entry_date').val(d.date);
    $('#reference').val(d.reference);
    $('#description').val(d.description);

    const lines = Array.isArray(d.lines) ? d.lines : [];
    lines.forEach(l=>renderLine(l));
    calcTotals();

    $('#enableEdit').removeClass('d-none');
    $('#saveChanges').addClass('d-none');
    $('#journalModal').modal('show');
  });
});
</script>

@endsection