|
|
@foreach ($dates as $date)
{{$date}} |
@endforeach
| Department |
Designation |
@foreach ($dates as $date)
Sanctioned Employees |
@foreach ($shifts as $shift)
{{$shift->name}} | {{$date}} |
@endforeach
@endforeach
@foreach ($departments as $department)
@foreach ($designations as $designation)
@php
$membersCount = App\Models\RoasterDesignationWiseSanctionShift::where('department_id', $department->id)
->where('designation_id', $designation->id)
->where('organization_id', $organization_id)
->where('contractor_id', $contractor_id)
->whereIn('date', $dates)
->get();
@endphp
@if(count($membersCount))
| {{$department->name}} |
{{$designation->name}} |
@foreach ($dates as $date)
@php
$memberCount = @$membersCount->where('date', $date)->first()->no_of_employees ?? 0;
@endphp
{{$memberCount}} |
@foreach ($shifts as $shift)
|
@endforeach
@endforeach
@endif
@endforeach
@endforeach