{{-- Account Ledger Report - Data Table partial (loaded via AJAX) --}}

<div class="d-flex justify-content-between align-items-center mb-2">
    <h6 class="mb-0">
        <strong>{{ $ledger->ledger_name }}</strong>
        @if($ledger->accountGroup)
        <small class="text-muted">({{ $ledger->accountGroup->a_group_name }})</small>
        @endif
    </h6>
    <small class="text-muted">
        {{ date('d-M-Y', strtotime($fromDate)) }} to {{ date('d-M-Y', strtotime($toDate)) }}
    </small>
</div>

<div class="table-responsive">
    <table class="table table-bordered mb-0" style="font-size:13px;">
        <thead>
            <tr>
                <th>S. No.</th>
                <th>Date</th>
                <th>Particulars</th>
                <th>Supplier Invoice No.</th>
                <th>Narration</th>
                <th>Voucher Number</th>
                <th>Voucher Type</th>
                <th>Debit</th>
                <th>Credit</th>
                <th>Balance</th>
            </tr>
        </thead>
        <tbody>
            {{-- OPENING BALANCE ROW --}}
            <tr style="font-weight:bold;">
                <td></td>
                <td></td>
                <td>Opening Balance</td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td class="text-end">
                    {{ number_format(abs($openingBalance), 2) }}
                    {{ $openingBalance >= 0 ? 'Dr' : 'Cr' }}
                </td>
            </tr>

            @php
            $runningBalance = $openingBalance;
            $totalDebit = 0;
            $totalCredit = 0;
            @endphp

            @forelse ($transactionsWithParticulars as $index => $txn)
            @php
            $debit = $txn['debit'] ?? 0;
            $credit = $txn['credit'] ?? 0;
            $runningBalance += ($debit - $credit);
            $totalDebit += $debit;
            $totalCredit += $credit;
            @endphp
            <tr>
                <td class="text-center">{{ $index + 1 }}</td>
                <td>{{ date('d-M-Y', strtotime($txn['date'])) }}</td>
                <td>{{ $txn['particulars'] }}</td>
                <td>{{ $txn['supplier_invoice_no'] }}</td>
                <td>{{ $txn['narration'] }}</td>
                <td class="text-center">
                    <a href="{{ route('journal-voucher.edit', $txn['journal_voucher_id']) }}" target="_blank" title="View Voucher">
                        {{ $txn['voucher_no'] }}
                    </a>
                </td>
                <td class="text-center">
                    @if($txn['source_link'])
                    <a href="{{ $txn['source_link'] }}" target="_blank" title="View Source Invoice/Voucher">
                        {{ $txn['voucher_type'] }}
                    </a>
                    @else
                    {{ $txn['voucher_type'] }}
                    @endif
                </td>
                <td class="text-end">{{ $debit > 0 ? number_format($debit, 2) : '' }}</td>
                <td class="text-end">{{ $credit > 0 ? number_format($credit, 2) : '' }}</td>
                <td class="text-end">
                    {{ number_format(abs($runningBalance), 2) }}
                    {{ $runningBalance >= 0 ? 'Dr' : 'Cr' }}
                </td>
            </tr>
            @empty
            <tr>
                <td colspan="10" class="text-center text-muted">No transactions found in this date range.</td>
            </tr>
            @endforelse

            {{-- CLOSING BALANCE / TOTALS ROW --}}
            <tr style="font-weight:bold;">
                <td></td>
                <td></td>
                <td>Total Balance</td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td class="text-end">{{ number_format($totalDebit, 2) }}</td>
                <td class="text-end">{{ number_format($totalCredit, 2) }}</td>
                <td class="text-end">
                    {{ number_format(abs($runningBalance), 2) }}
                    {{ $runningBalance >= 0 ? 'Dr' : 'Cr' }}
                </td>
            </tr>
        </tbody>
    </table>
</div>