@extends('admin.layouts.app')

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

@section('content')
<div class="card">
    <div class="card-header">
        <h5 class="mb-0">Party Ledger Report</h5>
    </div>
    <div class="card-body">
        <form method="GET" action="{{ route('party-ledger.index') }}" class="mb-4">
            <div class="row g-2">
                <div class="col-md-3">
                    <label class="form-label">Customer</label>
                    <select name="customer_id" class="form-select form-select-sm">
                        <option value="">All Customers</option>
                        @foreach($customers as $customer)
                            <option value="{{ $customer->id }}" {{ request('customer_id') == $customer->id ? 'selected' : '' }}>{{ $customer->name }}</option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-2">
                    <label class="form-label">Start Date</label>
                    <input type="date" name="start_date" class="form-control form-control-sm" value="{{ request('start_date', date('Y-m-01')) }}">
                </div>
                <div class="col-md-2">
                    <label class="form-label">End Date</label>
                    <input type="date" name="end_date" class="form-control form-control-sm" value="{{ request('end_date', date('Y-m-d')) }}">
                </div>
                <div class="col-md-2">
                    <label class="form-label">Sort By</label>
                    <select name="sort_by" class="form-select form-select-sm">
                        <option value="date" {{ request('sort_by') == 'date' ? 'selected' : '' }}>Date</option>
                        <option value="invoice" {{ request('sort_by') == 'invoice' ? 'selected' : '' }}>Invoice No</option>
                    </select>
                </div>
                <div class="col-md-3 d-flex align-items-end">
                    <button type="submit" class="btn btn-primary btn-sm w-100">Search</button>
                </div>
            </div>
        </form>
        
        <div class="row mb-3">
            <div class="col-6">
                <h6 class="mb-0">Party Ledger @if($selectedCustomer) - {{ $selectedCustomer->name }} @else (All Customers) @endif</h6>
            </div>
            <div class="col-6 text-end">
                <a href="{{ route('party-ledger.print') }}?customer_id={{ request('customer_id') }}&start_date={{ request('start_date') }}&end_date={{ request('end_date') }}&sort_by={{ request('sort_by') }}" class="btn btn-sm btn-info" target="_blank">
                    <i class="fas fa-print"></i> Print
                </a>
            </div>
        </div>
        
        <div class="table-responsive">
            <table class="table table-bordered table-striped table-hover small" style="font-size: 12px;">
                <thead class="table-dark">
                    <tr>
                        <th class="text-nowrap" style="min-width: 100px;">Date</th>
                        <th class="text-nowrap">Shipment No</th>
                        <th class="text-nowrap">Invoice No</th>
                        <th class="text-nowrap" style="min-width: 150px;">Customer</th>
                        <th class="text-nowrap">Branch</th>
                        <th class="text-end text-nowrap">Sales</th>
                        <th class="text-end text-nowrap">Discount</th>
                        <th class="text-end text-nowrap">TDS</th>
                        <th class="text-end text-nowrap">VDS</th>
                        <th class="text-end text-nowrap">Sales Return</th>
                        <th class="text-end text-nowrap">Payment Received</th>
                        <th class="text-end text-nowrap">Balance</th>
                        <th class="text-nowrap">Payment Method</th>
                    </tr>
                </thead>
                <tbody>
                    @php
                        $balance = 0;
                        $totalSales = 0;
                        $totalSalesReturn = 0;
                        $totalDiscount = 0;
                        $totalTDS = 0;
                        $totalVDS = 0;
                        $totalNetReceivable = 0;
                        $totalPaymentReceived = 0;
                        $totalDue = 0;
                    @endphp
                    
                    @forelse($ledgers as $entry)
                        @php
                            $sale = $entry->reference_type == 'Sale' && isset($sales[$entry->reference_id]) ? $sales[$entry->reference_id] : null;
                            $saleReturn = $entry->reference_type == 'SaleReturn' && isset($saleReturns[$entry->reference_id]) ? $saleReturns[$entry->reference_id] : null;
                            
                            $salesAmount = 0;
                            $salesReturnAmount = 0;
                            $paymentAmount = 0;
                            $discount = 0;
                            $tds = 0;
                            $vds = 0;
                            
                            // Balance = +Sales - Discount - TDS - VDS - Sales Return - Payment Received
                            if($entry->reference_type == 'Sale') {
                                $debit = (float)$entry->debit;
                                if($debit > 0 && $sale) {
                                    // Original sale entry: debit = total, but show subtotal in Sales column
                                    $salesAmount = (float)$sale->subtotal;
                                    // Discount/TDS/VDS show only on voucher rows, not on sale row
                                    $discount = 0;
                                    $tds = 0;
                                    $vds = 0;
                                    $balance += $salesAmount;
                                    $totalSales += $salesAmount;
                                } elseif($sale) {
                                    // payDue payment entry (debit = 0, credit = received)
                                    $paymentAmount = (float)$entry->credit;
                                    $balance -= $paymentAmount;
                                    $totalPaymentReceived += $paymentAmount;
                                } else {
                                    $salesAmount = $debit;
                                    $balance += $salesAmount;
                                    $totalSales += $salesAmount;
                                }
                             
                            } elseif($entry->reference_type == 'SaleReturn') {
                                $salesReturnAmount = (float)($entry->credit ?: $entry->debit);
                                $balance -= $salesReturnAmount;
                                $totalSalesReturn += $salesReturnAmount;
                             
                            } else {
                                $paymentAmount = (float)$entry->credit;
                                $balance -= $paymentAmount;
                                $totalPaymentReceived += $paymentAmount;
                                
                                // Get discount/TDS/VDS from voucher model (not regex)
                                $voucher = $vouchers[$entry->reference_id] ?? null;
                                if($voucher) {
                                    $discount = (float)($voucher->discount ?? 0);
                                    $tds = (float)($voucher->tds ?? 0);
                                    $vds = (float)($voucher->vds ?? 0);
                                }
                                
                                // Subtract discount/TDS/VDS for all vouchers
                                 $balance -= $discount + $tds + $vds;
                            }
                            
                            $shipmentNumbers = null;
                            if($sale) {
                                $itemsShipments = $sale->items ? $sale->items->pluck('shipment_number')->filter()->unique()->values()->toArray() : [];
                                $saleShipment = $sale->shipment_number;
                                $allShipments = array_filter(array_merge($itemsShipments, $saleShipment ? [$saleShipment] : []));
                                $shipmentNumbers = implode(', ', $allShipments) ?: null;
                            } elseif($saleReturn) {
                                $shipmentNumbers = $saleReturn->shipment_number ?? $entry->shipment_number;
                            } else {
                                $shipmentNumbers = $entry->shipment_number;
                            }
                            
                            $paymentMethod = '-';
                            if($entry->reference_type == 'Voucher' && $voucher) {
                                if(preg_match('/\(([^)]+)\)/', $voucher->description ?? '', $m)) {
                                    $paymentMethod = $m[1];
                                }
                            } else {
                                $desc = $entry->description ?? '';
                                if(preg_match('/Method:\s*([^,]+)/', $desc, $methodMatch)) {
                                    $paymentMethod = trim($methodMatch[1]);
                                } elseif(preg_match_all('/\(([^)]+)\)/', $desc, $methodMatches)) {
                                    $last = end($methodMatches[1]);
                                    if(!preg_match('/^(Disc|TDS|VDS)/', $last)) {
                                        $paymentMethod = $last;
                                    }
                                }
                            }
                            
                            $totalDiscount += $discount;
                            $totalTDS += $tds;
                            $totalVDS += $vds;
                            $netReceivable = $entry->reference_type == 'Sale' && (float)$entry->debit > 0 ? $salesAmount - $discount - $tds - $vds : 0;
                            $totalNetReceivable += $netReceivable;
                            $due = $netReceivable - $salesReturnAmount - $paymentAmount;
                            $totalDue += $due;
                        @endphp
                        <tr>
                            <td>{{ date('d-m-Y', strtotime($entry->date)) }}</td>
                            <td>{{ $entry->shipment_number ?? $shipmentNumbers ?? '-' }}</td>
                            <td>{{ $entry->invoice_no ?: $entry->reference_id }}</td>
                            <td>{{ $entry->customer->name ?? 'N/A' }}</td>
                            <td>{{ $entry->branch->name ?? '-' }}</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 {{ $balance < 0 ? 'text-danger' : '' }}">{{ number_format($balance, 2) }}</td>
                            <td>{{ $paymentMethod }}</td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="13" class="text-center">No records found</td>
                        </tr>
                    @endforelse
                </tbody>
                <tfoot class="table-secondary">
                    <tr>
                        <td colspan="5" class="text-end"><strong>Total:</strong></td>
                        <td class="text-end"><strong>{{ number_format($totalSales, 2) }}</strong></td>
                        <td class="text-end"><strong>{{ number_format($totalDiscount, 2) }}</strong></td>
                        <td class="text-end"><strong>{{ number_format($totalTDS, 2) }}</strong></td>
                        <td class="text-end"><strong>{{ number_format($totalVDS, 2) }}</strong></td>
                        <td class="text-end"><strong>{{ number_format($totalSalesReturn, 2) }}</strong></td>
                        <td class="text-end"><strong>{{ number_format($totalPaymentReceived, 2) }}</strong></td>
                        <td></td>
                        <td></td>
                    </tr>
                </tfoot>
            </table>
        </div>
    </div>
</div>
@endsection