Reports

Get a report about graph scheduling
Account :   {{ $account_filter }}
Skill :   @if ($skill_filter_name != null) {{ $skill_filter_name }} @endif

@for ($hour = 0; $hour < 24; $hour++) @endfor @forelse($schedules as $schedule) @php $shiftStart = \Carbon\Carbon::parse($schedule->Shift->from)->subHour(); $shiftEnd = \Carbon\Carbon::parse($schedule->Shift->to); $date_from_0 = \Carbon\Carbon::parse("00:00:00")->subHour(); $date_to_23 = \Carbon\Carbon::parse("23:00:00"); if ($shiftEnd < $shiftStart) { $shiftEnd->addDay(); } $currentShiftStart = clone $shiftStart; @endphp @while ($currentShiftStart < $shiftEnd) @if($currentShiftStart->format('H:i') == $date_from_0->format('H:i')) @php($currentShiftStart->addHour()) @else @endif @if ($currentShiftStart->format('H:i') == $date_to_23->format('H:i')) @php($empty_td = $date_to_23->diffInHours($currentShiftStart)) @for ($i = 0; $i < $empty_td; $i++) @endfor @break @endif @php($date_from_0->addHour()) @endwhile @empty {{-- Handle the case when there are no schedules --}} @endforelse
Date Name User ID{{ str_pad($hour, 2, '0', STR_PAD_LEFT) }}:00
{{ $schedule->date->format('Y-m-d') }} {{ $schedule->user?->first_name }} #{{ $schedule->user?->username }}
@php($currentShiftStart->format('H:i'))
{{ $schedules->links() }}
@for ($hour = 0; $hour < 24; $hour++) @endfor @forelse($schedules as $schedule) @php $shiftStart = \Carbon\Carbon::parse($schedule->Shift->from)->subHour(); $shiftEnd = \Carbon\Carbon::parse($schedule->Shift->to); $date_from_0 = \Carbon\Carbon::parse('00:00:00')->subHour(); $date_to_23 = \Carbon\Carbon::parse('23:00:00'); if ($shiftEnd < $shiftStart) { $shiftEnd->addDay(); } $currentShiftStart = clone $shiftStart; @endphp @while ($currentShiftStart < $shiftEnd) @if ($currentShiftStart->format('H:i') == $date_from_0->format('H:i')) @php $shiftFrom = \Carbon\Carbon::parse($schedule->Shift->from)->subHours('1'); $shiftTo = \Carbon\Carbon::parse($schedule->Shift->to); $emptyTdCount = $shiftFrom->diffInHours($shiftTo); $date_from_0 = \Carbon\Carbon::parse('00:00:00')->subHour(); $date_to_23 = \Carbon\Carbon::parse('23:00:00'); @endphp @while ($shiftFrom < $shiftTo) @while ($date_from_0 < $date_to_23) @if ($shiftFrom->format('H:i') == $date_from_0->format('H:i')) @else @endif @if ($shiftTo == $shiftFrom) @php $empty_td = $date_to_23->diffInHours($shiftTo); @endphp @for ($i = 0; $i < $empty_td; $i++) @endfor @break @endif @endwhile @endwhile @php $date_from_0->addHour(); @endphp @endif @endwhile @empty {{-- Handle the case when there are no schedules --}} @endforelse
DATE AGENT USER NAME{{ str_pad($hour, 2, '0', STR_PAD_LEFT) }}:00
{{ $schedule->date->format('Y-m-d') }} {{ Str::title($schedule->user?->first_name) }} #{{ $schedule->user?->username }}
@php($currentShiftStart->format('H:i'))
{{ $schedule->user?->first_name }} #{{ $schedule->user?->username }}
@php $shiftFrom->addHour()->format('H'); @endphp
{{ $schedules->links() }}
Type OF Assignment