@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
    <tr>
        <td><a
                href="{{ route('admin.purchase_invoice.details', ['type' => 'duty', 'id' => $invoice->id]) }}">{{ $invoice->invoice_number }}</a>
        </td>
        <td>{{ $invoice->supplier->name ?? 'N/A' }}</td>
        <td><a
                href="{{ route('admin.purchase_invoice.details', ['type' => 'duty', 'id' => $invoice->id]) }}">{{ $invoice->net_payout }}</a>
        </td>
        <!-- <td><a href="{{ route('admin.purchase_invoice.details', ['type' => 'duty', 'id' => $invoice->id]) }}">{{ $dutyTypes }}</a></td>
            <td><a href="{{ route('admin.purchase_invoice.details', ['type' => 'vehicle', 'id' => $invoice->id]) }}">{{ $vehicles }}</a></td>
            <td><a href="{{ route('admin.purchase_invoice.details', ['type' => 'customer', 'id' => $invoice->id]) }}">{{ $customers }}</a></td>
            <td><a href="{{ route('admin.purchase_invoice.details', ['type' => 'driver', 'id' => $invoice->id]) }}">{{ $drivers }}</a></td>
            <td><a href="{{ route('admin.purchase_invoice.details', ['type' => 'group', 'id' => $invoice->id]) }}">{{ $vehicleGroups }}</a></td> -->
        <td>{{ \Carbon\Carbon::parse($invoice->paid_at)->format('d M Y') }}</td>
        <td>
            @if($invoice->status === 'Paid')
                <span class="badge bg-success">{{ $invoice->status }}</span>
            @else
                <span class="badge bg-secondary">{{ $invoice->status }}</span>
            @endif
        </td>
    </tr>
@endforeach