@if($company)

{{ $company->name }}

{{ $company->address_1 }}{{ $company->address_2 ? ', ' . $company->address_2 : '' }}

@endif

Site Margin Report

Type: {{ ucfirst($reportType ?? 'Actual') }} Hours

Period: {{ \Carbon\Carbon::parse($startDate)->format('M d, Y') }} - {{ \Carbon\Carbon::parse($endDate)->format('M d, Y') }}

Generated By: {{ auth()->user()->name }}

Date Generated: {{ now()->format('M d, Y H:i') }}

@foreach($groupedMargins as $siteName => $group)
{{ $siteName }}
@foreach($group['items'] as $row) @php $wageTypes = json_decode($row->wage_types, true) ?: []; $gasRate = $row->gas_rate > 0 ? $row->gas_rate : 0; $rowTotal = 0; @endphp @php $margin = $row->total_income - $rowTotal; @endphp @endforeach @php $totalMargin = $group['total_income'] - $group['total_expense']; @endphp
Duty ID Guard From To Hrs Site Rate Income Wage Components Expense Margin
{{ $row->duty_number }} @if(isset($row->stat_multiplier) && $row->stat_multiplier > 1) STAT @endif {{ $row->first_name }} {{ $row->last_name }} {{ \Carbon\Carbon::parse($row->view_start)->format('m/d h:i A') }} {{ \Carbon\Carbon::parse($row->view_end)->format('m/d h:i A') }} {{ number_format($row->view_hours, 2) }} ${{ number_format($row->bill_rate, 2) }} ${{ number_format($row->total_income, 2) }} @if(!empty($wageTypes) || $gasRate > 0) @foreach($wageTypes as $wageType) @php $componentHours = $wageType['allocated_hours'] ?? 0; $componentRate = $wageType['rate'] ?? 0; $componentPay = $componentHours * $componentRate; $rowTotal += $componentPay; @endphp
{{ $wageType['name'] ?? 'Wage' }}
{{ number_format($componentHours, 2) }} hrs × ${{ number_format($componentRate, 2) }} = ${{ number_format($componentPay, 2) }}
@endforeach @if($gasRate > 0) @php $rowTotal += $gasRate; @endphp
GAS/CASH
${{ number_format($gasRate, 2) }}
@endif @else No wage data @endif 		${{ number_format($rowTotal, 2) }} ${{ number_format($margin, 2) }}
Total {{ number_format($group['total_hours'], 2) }} ${{ number_format($group['total_income'], 2) }} ${{ number_format($group['total_expense'], 2) }} ${{ number_format($totalMargin, 2) }}
@endforeach