 }})
{{ getAuthCompanyName() }} - {{$cur_year}}
Driver Expense Report
Grand Total - ${{ number_format($gtotal, 2) }}
| Driver Name |
@for ($month = 1; $month <= 12; $month++)
{{ \Carbon\Carbon::createFromDate($cur_year, $month, 1)->format('M-Y') }} |
@endfor
@php
$monthlyTotals = array_fill(1, 12, 0);
@endphp
@foreach ($drivers as $driver)
| {{ strtoupper($driver->FIRST_NAME) }} {{ strtoupper($driver->LAST_NAME) }} |
@for ($month = 1; $month <= 12; $month++)
@php
$expenseAmount = $expenseAmounts[$driver->DRIVER_ID][$month] ?? 0;
$monthlyTotals[$month] += $expenseAmount;
$color = $expenseAmount > 0 ? 'green' : ($expenseAmount < 0 ? 'red' : '#000');
@endphp
${{ number_format($expenseAmount, 2) }}
|
@endfor
@endforeach
| Total |
@for ($month = 1; $month <= 12; $month++)
${{ number_format($monthlyTotals[$month], 2) }}
|
@endfor
| Grand Total |
${{ number_format($gtotal, 2) }}
|