@php // Group data by labor_id to get summary per person $groupedByLabor = $data->groupBy('labor_id'); @endphp @forelse($groupedByLabor as $laborId => $absences) @php $laborName = $absences->first()->labor->name ?? 'Unknown'; $totalCount = $absences->count(); $informedCount = $absences->filter(function($item) { $approval = $item->approvals()->latest()->first(); return $approval && $approval->informed === 'informed'; })->count(); $uninformedCount = $absences->filter(function($item) { $approval = $item->approvals()->latest()->first(); return $approval && $approval->informed === 'uninformed'; })->count(); @endphp @empty @endforelse

Employee Name	Total Absences in Period	Approved & Informed	Approved & Uninformed
{{ $laborName }}	{{ $totalCount }}	{{ $informedCount }}	{{ $uninformedCount }}
No approved absences found

@if($data->count() > 0) @endif

Summary Statistics
Total Absence Records:	{{ $data->count() }}
Total Unique Employees:	{{ $data->groupBy('labor_id')->count() }}
Informed Cases:	{{ $data->filter(function($item) { $approval = $item->approvals()->latest()->first(); return $approval && $approval->informed === 'informed'; })->count() }}
Uninformed Cases:	{{ $data->filter(function($item) { $approval = $item->approvals()->latest()->first(); return $approval && $approval->informed === 'uninformed'; })->count() }}

@if(!empty($filters)) @if(!empty($filters['date_from'])) @endif @if(!empty($filters['date_to'])) @endif @if(!empty($filters['labor_name'])) @endif @if(!empty($filters['status'])) @endif @if(!empty($filters['informed'])) @endif

Report Filters Applied:

Date From: {{ \Carbon\Carbon::createFromFormat('Y-m-d', $filters['date_from'])->format('M d, Y') }}

Date To: {{ \Carbon\Carbon::createFromFormat('Y-m-d', $filters['date_to'])->format('M d, Y') }}

Labor Name: {{ $filters['labor_name'] }}

Status: {{ ucfirst($filters['status']) }}

Informed Status: {{ ucfirst($filters['informed']) }}

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

@endif