@if($Sick_Request->count() > 0)
@php
$sickRequests_years = $Sick_Request->where('is_deleted', 0)->groupBy(function ($request) {
return Carbon\Carbon::parse($request->date_from)->format('Y');
});
@endphp
| Jahr |
Mitarbeiter |
Krankheitstage gesamt |
@foreach($sickRequests_years as $year => $requests)
|
{{ $year }}
|
@php
$grouped = $requests->groupBy('fk_employee_id')->map(function ($r) {
return [
'employee_name' => $r->first()->get_employee->first_name . ' ' . $r->first()->get_employee->last_name,
'total_days' => $r->sum('days_number'),
];
});
@endphp
@foreach($grouped as $emp)
|
{{ $emp['employee_name'] }} |
{{ $emp['total_days'] }} Tage
|
@endforeach
@endforeach
@else
Keine Daten vorhanden
@endif