@extends('admin.layouts.app')

@section('title', 'Sales Due')
@section('page_title', 'Sales Due List')

@section('content')
<div class="card">
    <div class="card-header">
        <h5 class="mb-0">Sales Due List</h5>
    </div>
    <div class="card-body p-2">
        <form method="GET" action="{{ route('sales.saleDue') }}" class="mb-3">
            <div class="row g-2">
                <div class="col-md-3">
                    <select name="customer_id" class="form-select form-select-sm">
                        <option value="">All Customers</option>
                        @foreach(App\Models\Customer::where('status', 1)->get() as $customer)
                            <option value="{{ $customer->id }}" {{ request('customer_id') == $customer->id ? 'selected' : '' }}>{{ $customer->name }}</option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-2">
                    <input type="date" name="from_date" class="form-control form-control-sm" value="{{ request('from_date') }}">
                </div>
                <div class="col-md-2">
                    <input type="date" name="to_date" class="form-control form-control-sm" value="{{ request('to_date') }}">
                </div>
                <div class="col-md-2">
                    <button type="submit" class="btn btn-primary btn-sm w-100">Filter</button>
                </div>
                <div class="col-md-2">
                    <a href="{{ route('sales.due.print', request()->query()) }}" class="btn btn-info btn-sm w-100">
                        <i class="fas fa-print"></i> Print
                    </a>
                </div>
            </div>
        </form>
        <div class="table-responsive">
            <table class="table table-bordered table-striped table-sm mb-0" style="font-size: 12px;">
                <thead class="table-dark">
                    <tr>
                        <th class="text-nowrap">Shipment Number</th>
                        <th class="text-nowrap">Date</th>
                        <th class="text-nowrap">Invoice No</th>
                        <th class="text-nowrap">Customer</th>
                        <th class="text-nowrap">Branch</th>
                        <th class="text-end text-nowrap">Bill Amount</th>
                        <th class="text-end text-nowrap">Sales Return</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">Net Payable</th>
                        <th class="text-end text-nowrap">Payment Received</th>
                        <th class="text-nowrap">Payment Method</th>
                        <th class="text-end text-nowrap">Due</th>
                    </tr>
                </thead>
                <tbody>
                    @php
                        $totalBill = 0;
                        $totalSalesReturn = 0;
                        $totalDiscount = 0;
                        $totalTDS = 0;
                        $totalVDS = 0;
                        $totalNetPayable = 0;
                        $totalPaymentReceived = 0;
                        $totalDue = 0;
                    @endphp
                    @forelse($sales as $sale)
                        @php
                            $shipmentNumbers = $sale->items->pluck('shipment_number')->filter()->unique()->values()->toArray();
                            $shipmentDisplay = implode(', ', $shipmentNumbers) ?: '-';
                            
                            // Calculate actual due
                            $saleReturnsAmount = (float)($sale->saleReturns->sum('total') ?? 0);
                            $totalPaid = (float)$sale->paid;
                            $totalDiscount = (float)($sale->discount ?? 0);
                            $netPayable = (float)$sale->total - $saleReturnsAmount - $totalDiscount;
                            $due = max(0, $netPayable - $totalPaid);
                            
                            $totalBill += (float)$sale->total;
                            $totalSalesReturn += $saleReturnsAmount;
                            $totalDiscount += $totalDiscount;
                            $totalTDS += 0;
                            $totalVDS += 0;
                            $totalNetPayable += max(0, $netPayable);
                            $totalPaymentReceived += $totalPaid;
                            $totalDue += $due;
                        @endphp
                        @php
                            $_v = $vouchers[$sale->id] ?? null;
                            $_pm = '-';
                            if($_v && preg_match('/\(([^)]+)\)/', $_v->description ?? '', $_m)) {
                                $_pm = $_m[1];
                            }
                        @endphp
                        <tr>
                            <td class="text-nowrap">{{ $shipmentDisplay }}</td>
                            <td class="text-nowrap">{{ date('d-m-Y', strtotime($sale->date)) }}</td>
                            <td class="text-nowrap">{{ $sale->invoice_no }}</td>
                            <td class="text-nowrap">{{ $sale->customer->name ?? 'N/A' }}</td>
                            <td class="text-nowrap">{{ $sale->branch->name ?? '-' }}</td>
                            <td class="text-end">{{ number_format($sale->total, 2) }}</td>
                            <td class="text-end">{{ number_format($saleReturnsAmount, 2) }}</td>
                            <td class="text-end">{{ number_format($totalDiscount, 2) }}</td>
                            <td class="text-end">{{ number_format(0, 2) }}</td>
                            <td class="text-end">{{ number_format(0, 2) }}</td>
                            <td class="text-end">{{ number_format($netPayable, 2) }}</td>
                            <td class="text-end">{{ number_format($totalPaid, 2) }}</td>
                            <td>{{ $_pm }}</td>
                             <td class="text-end fw-bold {{ $due > 0 ? 'text-danger' : 'text-success' }}">{{ number_format($due, 2) }}</td>
                        </tr>
                        

                    @empty
                        <tr>
                            <td colspan="14" class="text-center">No due sales found</td>
                        </tr>
                    @endforelse
                </tbody>
                <tfoot class="table-secondary">
                    <tr>
                        <td colspan="5" class="text-end fw-bold">Total:</td>
                        <td class="text-end fw-bold">{{ number_format($totalBill, 2) }}</td>
                        <td class="text-end fw-bold">{{ number_format($totalSalesReturn, 2) }}</td>
                        <td class="text-end fw-bold">{{ number_format($totalDiscount, 2) }}</td>
                        <td class="text-end fw-bold">{{ number_format($totalTDS, 2) }}</td>
                        <td class="text-end fw-bold">{{ number_format($totalVDS, 2) }}</td>
                        <td class="text-end fw-bold">{{ number_format($totalNetPayable, 2) }}</td>
                        <td class="text-end fw-bold">{{ number_format($totalPaymentReceived, 2) }}</td>
                        <td></td>
                        <td class="text-end fw-bold text-danger">{{ number_format($totalDue, 2) }}</td>
                    </tr>
                </tfoot>
            </table>
        </div>
        <div class="mt-3">
            {{ $sales->links('pagination::bootstrap-5') }}
        </div>
    </div>
</div>
@endsection