Divisionwise Fuel Consumption Report
Period: {{ \Carbon\Carbon::parse($dateFrom)->format('d-m-Y') }} — {{ \Carbon\Carbon::parse($dateTo)->format('d-m-Y') }}
@forelse ($divisionData as $division)
{{ $division['division_name'] }}
Vehicles: {{ $division['vehicle_count'] }}  |  Total Fuel: {{ number_format((float) $division['total_liters'], 2) }} L  |  Total Cost: KES {{ number_format((float) $division['total_cost'], 2) }}
@foreach ($division['vehicles'] as $index => $vehicle) @endforeach
No. Registration No. Make / Model Total Fuel (L) Total Cost (KES) Transactions
{{ $index + 1 }} {{ $vehicle['registration_number'] }} {{ trim($vehicle['make'] . ' ' . $vehicle['model']) }} {{ number_format((float) $vehicle['total_liters'], 2) }} {{ number_format((float) $vehicle['total_cost'], 2) }} {{ $vehicle['transaction_count'] }}
Division Total {{ number_format((float) $division['total_liters'], 2) }} {{ number_format((float) $division['total_cost'], 2) }} {{ array_sum(array_column($division['vehicles'], 'transaction_count')) }}
@if (!$loop->last)
@endif @empty

No fuel consumption records found for the selected period.

@endforelse @if (count($divisionData) > 0)
Grand Total Fuel (L) {{ number_format((float) $summary['grand_total_liters'], 2) }}
Grand Total Cost (KES) {{ number_format((float) $summary['grand_total_cost'], 2) }}
Divisions {{ $summary['division_count'] }}
Total Transactions {{ $summary['transaction_count'] }}
@endif