@if(request('supplier_id'))
Filtered by Supplier:
{{ $suppliers->where('id', request('supplier_id'))->first()?->name ?? 'Unknown' }}
@endif
@if($reportData->isNotEmpty())
| INV Number |
Supplier |
Net Payout |
Paid At |
Invoice Status |
Action |
@foreach($reportData as $invoice)
@php
$bookings = $invoice->bookings;
$dutyTypes = $bookings->pluck('dutyType.name')->unique()->count();
$vehicles = $bookings->pluck('vehicle.vehicle_number')->unique()->count();
$customers = $bookings->pluck('customer.name')->unique()->count();
$drivers = $bookings->pluck('driver.name')->unique()->count();
$vehicleGroups = $bookings->pluck('vehicle.vehicleGroup.name')->unique()->count();
@endphp
| {{ $invoice->invoice_number }}
|
{{ $invoice->supplier->name ?? 'N/A' }} |
{{ $invoice->net_payout }}
|
{{ \Carbon\Carbon::parse($invoice->paid_at)->format('d M Y') }} |
@if($invoice->status === 'Paid')
{{ $invoice->status }}
@else
{{ $invoice->status }}
@endif
|
@if ($invoice->status == 'Partially Paid')
@endif
|
@endforeach
@else
No bookings found.
@endif