@extends('admin.layouts.app')

@section('title', 'Party Ledger Details')

@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>Sales</th>
                    <th>Discount</th>
                    <th>TDS</th>
                    <th>VDS</th>
                    <th>Sales Return</th>
                    <th>Payment</th>
                    <th>Balance</th>
                </tr>
            </thead>
            <tbody>
                @php
                    $balance = $customer->opening_balance ?? 0;
                @endphp
                
                @foreach($ledgers as $entry)
                    @php
                        $salesAmount = 0;
                        $salesReturnAmount = 0;
                        $paymentAmount = 0;
                        $discount = 0;
                        $tds = 0;
                        $vds = 0;
                        
                        if($entry->reference_type == 'Sale') {
                            $salesAmount = (float)$entry->debit;
                            if(isset($sales[$entry->reference_id])) {
                                $discount = (float)($sales[$entry->reference_id]->discount ?? 0);
                                $tds = (float)($sales[$entry->reference_id]->tds ?? 0);
                                $vds = (float)($sales[$entry->reference_id]->vds ?? 0);
                            }
                            $balance += $salesAmount - $discount - $tds - $vds;
                        } elseif($entry->reference_type == 'SaleReturn') {
                            $salesReturnAmount = (float)$entry->credit;
                            $balance -= $salesReturnAmount;
                        } elseif($entry->reference_type == 'Voucher') {
                            $paymentAmount = (float)$entry->credit;
                            $voucher = $vouchers[$entry->reference_id] ?? null;
                            if($voucher) {
                                $discount = (float)($voucher->discount ?? 0);
                                $tds = (float)($voucher->tds ?? 0);
                                $vds = (float)($voucher->vds ?? 0);
                            }
                            $balance -= $paymentAmount + $discount + $tds + $vds;
                        }
                    @endphp
                    <tr>
                        <td>{{ $entry->date }}</td>
                        <td>{{ $entry->invoice_no ?: $entry->reference_id }}</td>
                        <td class="text-end">{{ number_format($salesAmount, 2) }}</td>
                        <td class="text-end">{{ number_format($discount, 2) }}</td>
                        <td class="text-end">{{ number_format($tds, 2) }}</td>
                        <td class="text-end">{{ number_format($vds, 2) }}</td>
                        <td class="text-end">{{ number_format($salesReturnAmount, 2) }}</td>
                        <td class="text-end">{{ number_format($paymentAmount, 2) }}</td>
                        <td class="text-end">{{ number_format($balance, 2) }}</td>
                    </tr>
                @empty
                    <tr><td colspan="9">No transactions found</td></tr>
                @endforeach
            </tbody>
        </table>
    </div>
</div>
@endsection