Daily Fuel Transaction Report

Report Date: {{ $reportDate }}

Generated: {{ now()->format('d F Y H:i') }}

Summary

@foreach ($reportData as $station) @endforeach
Fuel Station Opening Stock (L) Purchases (L) Consumption (L) Closing Stock (L) Total Cost (KES)
{{ $station['station_name'] }} {{ number_format($station['opening_stock'], 2) }} {{ number_format($station['purchases'], 2) }} {{ number_format($station['consumption'], 2) }} {{ number_format($station['closing_stock'], 2) }} {{ number_format($station['total_cost'], 2) }}
TOTAL {{ number_format(collect($reportData)->sum('opening_stock'), 2) }} {{ number_format(collect($reportData)->sum('purchases'), 2) }} {{ number_format(collect($reportData)->sum('consumption'), 2) }} {{ number_format(collect($reportData)->sum('closing_stock'), 2) }} {{ number_format(collect($reportData)->sum('total_cost'), 2) }}

Detailed Transactions by Fuel Station

@foreach ($reportData as $index => $station)

{{ $station['station_name'] }}

Opening Stock: {{ number_format($station['opening_stock'], 2) }} L
Purchases: {{ number_format($station['purchases'], 2) }} L
Consumption: {{ number_format($station['consumption'], 2) }} L
Closing Stock: {{ number_format($station['closing_stock'], 2) }} L
@if (count($station['transactions']) > 0) @foreach ($station['transactions'] as $transaction) @endforeach
Time Vehicle Driver Quantity (L) Odometer Cost (KES) Notes
{{ \Carbon\Carbon::parse($transaction['transaction_date'])->format('H:i') }} {{ $transaction['vehicle_registration'] }} {{ $transaction['driver_name'] }} {{ number_format($transaction['quantity_liters'], 2) }} {{ number_format($transaction['odometer_reading'], 2) }} {{ number_format($transaction['calculated_cost'], 2) }} {{ $transaction['notes'] ?? '-' }}
@else

No transactions recorded for this station on this date.

@endif
@if ($index < count($reportData) - 1)
@endif @endforeach

JSML Garage - Daily Fuel Report - Page