Generate, inspect, and export multi-day consolidated shift & vehicle operational reports for municipal submission & fleet auditing.
| Shift Name | Timing Window | Operating Days | Active Machinery | Total Shifts | Distance Swept | Operating Time | Avg KM / Shift |
|---|---|---|---|---|---|---|---|
|
{{ $row['shift_name'] }}
|
{{ $row['shift_window'] }} | {{ $row['operating_days'] }} | {{ $row['vehicles_count'] }} | {{ $row['shifts_run'] }} | {{ number_format($row['total_distance_km'], 2) }} KM | {{ $row['formatted_duration'] }} | {{ number_format($row['avg_km_per_tour'], 2) }} KM |
| No shift tour records found for selected criteria. | |||||||
| GRAND CONSOLIDATED TOTALS | {{ $data['grandTotals']['unique_dates_count'] ?? '-' }} | {{ $data['grandTotals']['unique_vehicles_count'] ?? '-' }} | {{ $data['grandTotals']['total_tours'] ?? '-' }} | {{ number_format($data['grandTotals']['total_distance_km'] ?? 0, 2) }} KM | {{ $data['grandTotals']['formatted_duration'] ?? '-' }} | {{ number_format($data['grandTotals']['avg_km_per_tour'] ?? 0, 2) }} KM | |
Individual tour records grouped under each municipal operational shift
| Tour / Duty Ref | Date | Machinery | Driver / Operator | Assigned Route | Duration | Distance Swept | Status |
Certificate
All
|
|---|---|---|---|---|---|---|---|---|
| {{ $tour->driverDuty?->duty_code ?? ('#TOUR-'.str_pad((string) $tour->id, 5, '0', STR_PAD_LEFT)) }} |
{{ $tour->start_time ? $tour->start_time->format('d M Y') : 'N/A' }}
{{ $tour->start_time ? $tour->start_time->format('h:i A') : '' }} - {{ $tour->end_time ? $tour->end_time->format('h:i A') : 'Active' }}
|
{{ $tour->vehicle?->vehicle_number ?? 'N/A' }}
{{ $tour->vehicle?->category?->name ?? 'Sweeper' }}
|
{{ $tour->employee?->full_name ?? ($tour->user?->name ?? 'N/A') }}
{{ $tour->employee?->employee_code ?? 'EMP' }}
|
{{ $tour->route?->name ?? ($tour->driverDuty?->route?->name ?? 'N/A') }}
|
{{ $tour->formatted_duration }} | {{ number_format($tour->total_distance_km, 3) }} KM | @php $statusClasses = match(strtolower($tour->status)) { 'completed' => 'bg-emerald-100 text-emerald-800', 'in_progress' => 'bg-amber-100 text-amber-800', 'cancelled' => 'bg-rose-100 text-rose-800', default => 'bg-slate-100 text-slate-700', }; @endphp {{ ucfirst($tour->status) }} |
|
| Subtotal for {{ $group['shift_name'] }}: | {{ $group['operating_days_count'] ?? 1 }} Days Run | {{ $group['formatted_duration'] }} | {{ number_format($group['total_distance_km'], 3) }} KM | Verified |
|
|||
| Vehicle Number | Category | Assigned Operators | Operating Days | Total Shifts | Distance Swept | Operating Time | Avg KM / Day |
|---|---|---|---|---|---|---|---|
|
|
{{ $row['category_name'] }} | {{ $row['drivers'] ?: 'Unassigned' }} | {{ $row['operating_days'] }} | {{ $row['shifts_worked'] }} | {{ number_format($row['total_distance_km'], 2) }} KM | {{ $row['formatted_duration'] }} | {{ number_format($row['avg_km_per_day'], 2) }} KM |
| No fleet vehicle tour records found for selected criteria. | |||||||
| GRAND CONSOLIDATED TOTALS ({{ $data['grandTotals']['total_vehicles'] ?? '-' }} Units) | {{ $data['grandTotals']['unique_dates_count'] ?? '-' }} | {{ $data['grandTotals']['total_tours'] ?? '-' }} | {{ number_format($data['grandTotals']['total_distance_km'] ?? 0, 2) }} KM | {{ $data['grandTotals']['formatted_duration'] ?? '-' }} | {{ number_format($data['grandTotals']['avg_km_per_vehicle'] ?? 0, 2) }} KM | ||
Individual tour records grouped under each fleet vehicle
| Tour / Duty Ref | Date | Driver / Operator | Assigned Route | Shift Timing | Duration | Distance Swept | Status |
Certificate
All
|
|---|---|---|---|---|---|---|---|---|
| {{ $tour->driverDuty?->duty_code ?? ('#TOUR-'.str_pad((string) $tour->id, 5, '0', STR_PAD_LEFT)) }} |
{{ $tour->start_time ? $tour->start_time->format('d M Y') : 'N/A' }}
{{ $tour->start_time ? $tour->start_time->format('h:i A') : '' }} - {{ $tour->end_time ? $tour->end_time->format('h:i A') : 'Active' }}
|
{{ $tour->employee?->full_name ?? ($tour->user?->name ?? 'N/A') }}
{{ $tour->employee?->employee_code ?? 'EMP' }}
|
{{ $tour->route?->name ?? ($tour->driverDuty?->route?->name ?? 'N/A') }}
|
{{ $shiftInfo['name'] }}
{{ $shiftInfo['window'] }}
|
{{ $tour->formatted_duration }} | {{ number_format($tour->total_distance_km, 3) }} KM | @php $statusClasses = match(strtolower($tour->status)) { 'completed' => 'bg-emerald-100 text-emerald-800', 'in_progress' => 'bg-amber-100 text-amber-800', 'cancelled' => 'bg-rose-100 text-rose-800', default => 'bg-slate-100 text-slate-700', }; @endphp {{ ucfirst($tour->status) }} |
|
| Subtotal for {{ $group['vehicle_number'] }}: | {{ $group['operating_days_count'] }} Days Run | {{ $group['formatted_duration'] }} | {{ number_format($group['total_distance_km'], 3) }} KM | Verified |
|
|||