@extends('admin.layouts.app')

@section('title', 'Payment Received List')
@section('page_title', 'Payment Received List')

@section('content')
<div class="card">
    <div class="card-header">
        <div class="d-flex justify-content-between align-items-center">
            <h5 class="mb-0">Payment Received List</h5>
            <a href="{{ route('sales.paymentReceived.print') }}?{{ http_build_query(request()->all()) }}" class="btn btn-secondary btn-sm" target="_blank">
                <i class="fas fa-print"></i> Print Report
            </a>
        </div>
    </div>
    <div class="card-body p-2">
        <form method="GET" action="{{ route('sales.paymentReceived') }}" 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">
                    @php $_pmList = explode(',', App\Models\Setting::where('key', 'payment_methods')->value('value') ?? 'Cash,Bank,Cheque,Mobile Banking'); @endphp
                    <select name="payment_method" class="form-select form-select-sm">
                        <option value="">All Methods</option>
                        @foreach($_pmList as $_pm)
                            <option value="{{ trim($_pm) }}" {{ request('payment_method') == trim($_pm) ? 'selected' : '' }}>{{ trim($_pm) }}</option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-2">
                    <button type="submit" class="btn btn-primary btn-sm w-100">Filter</button>
                </div>
                <div class="col-md-1">
                    <a href="{{ route('sales.paymentReceived') }}" class="btn btn-secondary btn-sm w-100">Reset</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">Date</th>
                        <th class="text-nowrap">Customer</th>
                        <th class="text-nowrap">Branch</th>
                        <th class="text-nowrap">Shipment No</th>
                        <th class="text-nowrap">Invoice No</th>
                        <th class="text-nowrap">Description</th>
                        <th class="text-nowrap">Payment Method</th>
                        <th class="text-end text-nowrap">Amount Received</th>
                        <th class="text-nowrap">Actions</th>
                    </tr>
                </thead>
                <tbody>
                    @php
                        $totalReceived = 0;
                    @endphp
                    @forelse($payments as $payment)
                        @php
                             $totalReceived += $payment->credit;
                             
                             // Get sale from voucher or direct reference
                             $sale = null;
                             if($payment->reference_type === 'Sale' && $payment->reference_id) {
                                 $sale = $payment->sale;
                             } elseif($payment->reference_type === 'Voucher' && $payment->reference_id) {
                                 $voucher = $payment->voucher;
                                 if($voucher && $voucher->sale_id) {
                                     $sale = \App\Models\Sale::with('branch', 'items')->find($voucher->sale_id);
                                 }
                             }
                             
                             // Get invoice
                             $invoiceNo = $sale ? $sale->invoice_no : '-';
                             if($invoiceNo === '-') {
                                 preg_match('/Invoice:\s*([A-Z0-9-]+)/', $payment->description ?? '', $invoiceMatch);
                                 $invoiceNo = $invoiceMatch[1] ?? '-';
                             }
                             
                             // Get branch
                             $branchName = $payment->branch->name ?? '-';
                             if($branchName === '-' && $sale) {
                                 $branchName = $sale->branch->name ?? '-';
                             }
                             
                             // Get shipment numbers
                             $shipmentNo = $payment->shipment_number ?? '-';
                             if($shipmentNo === '-' && $sale) {
                                 $shipmentNo = $sale->items->pluck('shipment_number')->filter()->unique()->implode(', ') ?: '-';
                             }
                             
                              $paymentMethod = '-';
                              if($payment->voucher && preg_match('/\(([^)]+)\)/', $payment->voucher->description ?? '', $vm)) {
                                  $paymentMethod = $vm[1];
                              } elseif(preg_match('/Method:\s*([^,]+)/', $payment->description ?? '', $methodMatch)) {
                                  $paymentMethod = trim($methodMatch[1]);
                              } elseif(preg_match_all('/\(([^)]+)\)/', $payment->description ?? '', $methodMatches)) {
                                  $last = end($methodMatches[1]);
                                  if(!preg_match('/^(Disc|TDS|VDS)/', $last)) {
                                      $paymentMethod = $last;
                                  }
                              }
                         @endphp
                         <tr>
                             <td class="text-nowrap">{{ date('d-m-Y', strtotime($payment->date)) }}</td>
                             <td class="text-nowrap">{{ $payment->customer->name ?? 'N/A' }}</td>
                             <td class="text-nowrap">{{ $branchName }}</td>
                             <td class="text-nowrap">{{ $shipmentNo }}</td>
                             <td class="text-nowrap">{{ $invoiceNo }}</td>
                             <td class="text-nowrap">{{ $payment->description ?? '-' }}</td>
                             <td class="text-nowrap">{{ $paymentMethod }}</td>
                             <td class="text-end text-success fw-bold">{{ number_format($payment->credit, 2) }}</td>
                              <td>
                                  @if($sale)
                                      <a href="{{ route('sales.show', $sale->id) }}" class="btn btn-sm btn-info" title="View Sale" target="_blank">
                                          <i class="fas fa-eye"></i>
                                      </a>
                                  @endif
                              </td>
                         </tr>
                    @empty
                        <tr>
                            <td colspan="8" class="text-center">No payments received found</td>
                        </tr>
                    @endforelse
                </tbody>
                <tfoot class="table-secondary">
                    <tr>
                        <td colspan="7" class="text-end fw-bold">Total Received:</td>
                        <td class="text-end fw-bold text-success">{{ number_format($totalReceived, 2) }}</td>
                    </tr>
                </tfoot>
            </table>
        </div>
        <div class="mt-3">
            {{ $payments->links('pagination::bootstrap-5') }}
        </div>
    </div>
</div>
@endsection