@extends('admin.layouts.app')

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

@section('content')
<div class="card">
    <div class="card-header">
        <div class="d-flex justify-content-between align-items-center">
            <h5 class="mb-0">Party Ledger - {{ $customer->name }}</h5>
            <div>
                <button onclick="window.print()" class="btn btn-secondary">
                    <i class="fas fa-print"></i> Print
                </button>
                <a href="{{ route('party-ledger.index') }}" class="btn btn-secondary">
                    <i class="fas fa-arrow-left"></i> Back
                </a>
            </div>
        </div>
    </div>
    <div class="card-body">
        <div class="row mb-4">
            <div class="col-md-6">
                <h6>Customer Details</h6>
                <p class="mb-0"><strong>Name:</strong> {{ $customer->name }}</p>
                <p class="mb-0"><strong>Phone:</strong> {{ $customer->phone ?? 'N/A' }}</p>
                <p class="mb-0"><strong>Address:</strong> {{ $customer->address ?? 'N/A' }}</p>
                <p class="mb-0"><strong>Opening Balance:</strong> {{ number_format($customer->opening_balance ?? 0, 2) }}</p>
            </div>
            <div class="col-md-6 text-end">
                <p class="mb-0"><strong>Date Range:</strong></p>
                <p class="mb-0">{{ date('d-m-Y', strtotime($startDate)) }} to {{ date('d-m-Y', strtotime($endDate)) }}</p>
            </div>
        </div>
    
        <div class="table-responsive">
            <table class="table table-bordered table-striped">
                <thead>
                    <tr>
                        <th>Date</th>
                        <th>Shipment No</th>
                        <th>Invoice No</th>
                        <th>Sales</th>
                        <th>Discount</th>
                        <th>TDS</th>
                        <th>VDS</th>
                        <th>Sales Return</th>
                        <th>Payment Received</th>
                        <th>Balance</th>
                    </tr>
                </thead>
                <tbody>
                    @php
                        $balance = $customer->opening_balance ?? 0;
                        $totalSales = 0;
                        $totalSalesReturn = 0;
                        $totalPayment = 0;
                        $totalDiscount = 0;
                        $totalTDS = 0;
                        $totalVDS = 0;
                    @endphp
                
                    @if($customer->opening_balance != 0)
                    <tr>
                        <td>-</td>
                        <td>-</td>
                        <td>Opening Balance</td>
                        <td class="text-end">0.00</td>
                        <td class="text-end">0.00</td>
                        <td class="text-end">0.00</td>
                        <td class="text-end">0.00</td>
                        <td class="text-end">0.00</td>
                        <td class="text-end">0.00</td>
                        <td class="text-end">{{ number_format($balance, 2) }}</td>
                    </tr>
                    @endif
                
                    @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;
                                
                            } else {
                                if($entry->debit > 0) {
                                    $balance += $entry->debit;
                                } else {
                                    $balance -= $entry->credit;
                                }
                            }
                            
                            $totalSales += $salesAmount;
                            $totalSalesReturn += $salesReturnAmount;
                            $totalPayment += $paymentAmount;
                            $totalDiscount += $discount;
                            $totalTDS += $tds;
                            $totalVDS += $vds;
                            
                            // Get shipment number
                            $shipmentNo = $entry->shipment_number ?? '-';
                            if($shipmentNo == '-') {
                                if($entry->reference_type == 'Sale' && isset($sales[$entry->reference_id])) {
                                    $sale = $sales[$entry->reference_id];
                                    if($sale && $sale->items) {
                                        $shipmentNo = $sale->items->pluck('shipment_number')->filter()->unique()->implode(', ') ?: '-';
                                    }
                                } elseif($entry->reference_type == 'SaleReturn' && isset($saleReturns[$entry->reference_id])) {
                                    $sr = $saleReturns[$entry->reference_id];
                                    if($sr && $sr->items) {
                                        $shipmentNo = $sr->items->pluck('shipment_number')->filter()->unique()->implode(', ') ?: '-';
                                    }
                                }
                            }
                        @endphp
                        <tr>
                            <td>{{ date('d-m-Y', strtotime($entry->date)) }}</td>
                            <td>{{ $shipmentNo }}</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 {{ $balance < 0 ? 'text-danger' : '' }}">{{ number_format($balance, 2) }}</td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="10" class="text-center">No transactions found</td>
                        </tr>
                    @endforeach
                </tbody>
                <tfoot>
                    <tr class="table-secondary">
                        <td colspan="3" 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($totalPayment, 2) }}</strong></td>
                        <td></td>
                    </tr>
                </tfoot>
            </table>
        </div>
    </div>
</div>
@endsection