@extends('admin.layouts.app')

@section('content')
<div class="card">
    <div class="card-body">
        <h5>Party Ledger - {{ $customer->name }}</h5>
        <p>Date Range: {{ $startDate }} to {{ $endDate }}</p>
        
        <table class="table table-bordered">
            <thead>
                <tr>
                    <th>Date</th>
                    <th>Invoice No</th>
                    <th class="text-end">Sales</th>
                    <th class="text-end">Discount</th>
                    <th class="text-end">TDS</th>
                    <th class="text-end">VDS</th>
                    <th class="text-end">Sales Return</th>
                    <th class="text-end">Payment</th>
                    <th class="text-end">Balance</th>
                    <th>Payment Method</th>
                </tr>
            </thead>
            <tbody>
                @forelse($ledgers as $entry)
                    @php
                        $_pm = '-';
                        $_voucher = $vouchers[$entry->reference_id] ?? null;
                        if($entry->reference_type == 'Voucher' && $_voucher) {
                            if(preg_match('/\(([^)]+)\)/', $_voucher->description ?? '', $_m)) {
                                $_pm = $_m[1];
                            }
                        } else {
                            $_pd = $entry->description ?? '';
                            if(preg_match('/Method:\s*([^,]+)/', $_pd, $_m)) {
                                $_pm = trim($_m[1]);
                            } elseif(preg_match_all('/\(([^)]+)\)/', $_pd, $_ms)) {
                                $_last = end($_ms[1]);
                                if(!preg_match('/^(Disc|TDS|VDS)/', $_last)) {
                                    $_pm = $_last;
                                }
                            }
                        }
                    @endphp
                    <tr>
                        <td>{{ $entry->date }}</td>
                        <td>{{ $entry->invoice_no ?: $entry->reference_id }}</td>
                        <td class="text-end">{{ number_format($entry->sales_amount, 2) }}</td>
                        <td class="text-end">{{ number_format($entry->discount_val, 2) }}</td>
                        <td class="text-end">{{ number_format($entry->tds_val, 2) }}</td>
                        <td class="text-end">{{ number_format($entry->vds_val, 2) }}</td>
                        <td class="text-end">{{ number_format($entry->sales_return_amount, 2) }}</td>
                        <td class="text-end">{{ number_format($entry->payment_amount, 2) }}</td>
                        <td class="text-end {{ $entry->running_balance < 0 ? 'text-danger' : '' }}">{{ number_format($entry->running_balance, 2) }}</td>
                        <td>{{ $_pm }}</td>
                    </tr>
                @empty
                    <tr>
                        <td colspan="10" class="text-center">No transactions found</td>
                    </tr>
                @endforelse
            </tbody>
        </table>
    </div>
</div>
@endsection