@if (!empty($profiles)) @php $shiftNameCounts['mon']=[]; $shiftNameCounts['tues']=[]; $shiftNameCounts['wed']=[]; $shiftNameCounts['thus']=[]; $shiftNameCounts['fri']=[]; $shiftNameCounts['sat']=[]; $shiftNameCounts['sun']=[]; $mondayDateYmd = date("Y-m-d", strtotime($schedule->start)); $tuesdayDateYmd = date('Y-m-d',strtotime('+1 day', strtotime($mondayDateYmd))); $wedDateYmd = date('Y-m-d',strtotime('+2 days', strtotime($mondayDateYmd))); $thursDateYmd = date('Y-m-d',strtotime('+3 days', strtotime($mondayDateYmd))); $friDateYmd = date('Y-m-d',strtotime('+4 days', strtotime($mondayDateYmd))); $saturdayDateYmd = date('Y-m-d',strtotime('+5 days', strtotime($mondayDateYmd))); $sundayDateYmd = date('Y-m-d',strtotime('+6 days', strtotime($mondayDateYmd))); @endphp @foreach ($profiles as $profile) @php $totalshifts=(isset($profile->scheduleDetails[$mondayDate]['shift_duration_in_minutes']) ? 1 : 0) + (isset($profile->scheduleDetails[$tuesdayDate]['shift_duration_in_minutes']) ? 1 : 0) + (isset($profile->scheduleDetails[$wedDate]['shift_duration_in_minutes']) ? 1 : 0) + (isset($profile->scheduleDetails[$thursDate]['shift_duration_in_minutes']) ? 1 : 0) + (isset($profile->scheduleDetails[$friDate]['shift_duration_in_minutes']) ? 1 : 0) + (isset($profile->scheduleDetails[$saturdayDate]['shift_duration_in_minutes']) ? 1 : 0) + (isset($profile->scheduleDetails[$sundayDate]['shift_duration_in_minutes']) ? 1 : 0) ; //$hours=round($totalMinutes/60,2); $colour="transparent"; if($totalshifts==5){ $colour="green"; }else if($totalshifts<5 && $totalshifts>=1){ $colour="yellow"; }else if($totalshifts>5){ $colour="red"; } @endphp @php if(isset($profile->scheduleDetails[$mondayDate]['shift_duration_in_minutes'])){ if(!isset($shiftNameCounts['mon'][$profile->scheduleDetails[$mondayDate]['shift_name']])){ $shiftNameCounts['mon'][$profile->scheduleDetails[$mondayDate]['shift_name']]=0; } $shiftNameCounts['mon'][$profile->scheduleDetails[$mondayDate]['shift_name']]++; } if(isset($profile->scheduleDetails[$tuesdayDate]['shift_duration_in_minutes'])){ if(!isset($shiftNameCounts['tues'][$profile->scheduleDetails[$tuesdayDate]['shift_name']])){ $shiftNameCounts['tues'][$profile->scheduleDetails[$tuesdayDate]['shift_name']]=0; } $shiftNameCounts['tues'][$profile->scheduleDetails[$tuesdayDate]['shift_name']]++; } if(isset($profile->scheduleDetails[$wedDate]['shift_duration_in_minutes'])){ if(!isset($shiftNameCounts['wed'][$profile->scheduleDetails[$wedDate]['shift_name']])){ $shiftNameCounts['wed'][$profile->scheduleDetails[$wedDate]['shift_name']]=0; } $shiftNameCounts['wed'][$profile->scheduleDetails[$wedDate]['shift_name']]++; } if(isset($profile->scheduleDetails[$thursDate]['shift_duration_in_minutes'])){ if(!isset($shiftNameCounts['thus'][$profile->scheduleDetails[$thursDate]['shift_name']])){ $shiftNameCounts['thus'][$profile->scheduleDetails[$thursDate]['shift_name']]=0; } $shiftNameCounts['thus'][$profile->scheduleDetails[$thursDate]['shift_name']]++; } if(isset($profile->scheduleDetails[$friDate]['shift_duration_in_minutes'])){ if(!isset($shiftNameCounts['fri'][$profile->scheduleDetails[$friDate]['shift_name']])){ $shiftNameCounts['fri'][$profile->scheduleDetails[$friDate]['shift_name']]=0; } $shiftNameCounts['fri'][$profile->scheduleDetails[$friDate]['shift_name']]++; } if(isset($profile->scheduleDetails[$saturdayDate]['shift_duration_in_minutes'])){ if(!isset($shiftNameCounts['sat'][$profile->scheduleDetails[$saturdayDate]['shift_name']])){ $shiftNameCounts['sat'][$profile->scheduleDetails[$saturdayDate]['shift_name']]=0; } $shiftNameCounts['sat'][$profile->scheduleDetails[$saturdayDate]['shift_name']]++; } if(isset($profile->scheduleDetails[$sundayDate]['shift_duration_in_minutes'])){ if(!isset($shiftNameCounts['sun'][$profile->scheduleDetails[$sundayDate]['shift_name']])){ $shiftNameCounts['sun'][$profile->scheduleDetails[$sundayDate]['shift_name']]=0; } $shiftNameCounts['sun'][$profile->scheduleDetails[$sundayDate]['shift_name']]++; } @endphp @endforeach @endif

Names	LN	FN	CareerPath	{{date('l', strtotime($mondayDate))}}	{{date('l', strtotime($tuesdayDate))}}	{{date('l', strtotime($wedDate))}}	{{date('l', strtotime($thursDate))}}	{{date('l', strtotime($friDate))}}	{{date('l', strtotime($saturdayDate))}}	{{date('l', strtotime($sundayDate))}}	Total Shifts
{{ $profile->profile_first_name}} {{$profile->profile_last_name}} @if($profile->is_dot==1) @endif @if($profile->is_trainer==1) @endif @if($profile->is_ops==1) @endif {{-- {{ $profile->profile_first_name}} {{$profile->profile_last_name}} @if($profile->is_dot==1) @endif --}} {{-- {{ isset($profile->profileDesignation->name) ? $profile->profileDesignation->name : ''}} --}}	{{ $profile->profile_last_name}}	{{ $profile->profile_first_name}}	{{ $profile->profileDesignation->id}}	scheduleDetails[$mondayDate]['shiftId'] !='') style="background-color:{{$profile->scheduleDetails[$mondayDate]['color']}} ;" @endif> scheduleOffDetails[$mondayDate] == 1)? $profile->scheduleOffDetails[$mondayDate.'_isdisable'] :''}} > Select Shift @foreach ($shifts as $shift) scheduleDetails[$mondayDate]['shiftId'] == $shift->id) ? 'selected' : ''}} data-color="{{$shift->color}}" >{{$shift->name}} @endforeach Remove Shift scheduleDetails[$mondayDate]['shiftId'] == '')? 'style=display:none;' :''}}> @if($profile->scheduleDetails[$mondayDate]['shiftId'] != '' && $profile->scheduleDetails[$mondayDate]['is_admin_note']) @endif @if($profile->scheduleOffDetails[$mondayDate] == 1) @endif @if(!empty($profile->timeCardProfile)) @foreach ($profile->timeCardProfile as $timeP) @if($timeP->day==$mondayDateYmd) Total Hrs : {{ $timeP->total_hours }} @endif @endforeach @endif	scheduleDetails[$tuesdayDate]['shiftId'] !='') style="background-color:{{$profile->scheduleDetails[$tuesdayDate]['color']}} ;" @endif> scheduleOffDetails[$tuesdayDate] == 1)? $profile->scheduleOffDetails[$tuesdayDate.'_isdisable'] :''}}> Select Shift @foreach ($shifts as $shift) scheduleDetails[$tuesdayDate]['shiftId'] == $shift->id) ? 'selected' : ''}} data-color="{{$shift->color}}">{{$shift->name}} @endforeach Remove Shift scheduleDetails[$tuesdayDate]['shiftId'] == '')? 'style=display:none;' :''}}> @if($profile->scheduleDetails[$tuesdayDate]['shiftId'] != '' && $profile->scheduleDetails[$tuesdayDate]['is_admin_note']) @endif @if($profile->scheduleOffDetails[$tuesdayDate] == 1) @endif @if(!empty($profile->timeCardProfile)) @foreach ($profile->timeCardProfile as $timeP) @if($timeP->day==$tuesdayDateYmd) Total Hrs : {{ $timeP->total_hours }} @endif @endforeach @endif	scheduleDetails[$wedDate]['shiftId'] !='') style="background-color:{{$profile->scheduleDetails[$wedDate]['color']}} ;" @endif> scheduleOffDetails[$wedDate] == 1)? $profile->scheduleOffDetails[$wedDate.'_isdisable'] :''}}> Select Shift @foreach ($shifts as $shift) scheduleDetails[$wedDate]['shiftId'] == $shift->id) ? 'selected' : ''}} data-color="{{$shift->color}}">{{$shift->name}} @endforeach Remove Shift scheduleDetails[$wedDate]['shiftId'] == '')? 'style=display:none;' :''}}> @if($profile->scheduleDetails[$wedDate]['shiftId'] != '' && $profile->scheduleDetails[$wedDate]['is_admin_note']) @endif @if($profile->scheduleOffDetails[$wedDate] == 1) @endif @if(!empty($profile->timeCardProfile)) @foreach ($profile->timeCardProfile as $timeP) @if($timeP->day==$wedDateYmd) Total Hrs : {{ $timeP->total_hours }} @endif @endforeach @endif	scheduleDetails[$thursDate]['shiftId'] !='') style="background-color:{{$profile->scheduleDetails[$thursDate]['color']}} ;" @endif> scheduleOffDetails[$thursDate] == 1)? $profile->scheduleOffDetails[$thursDate.'_isdisable'] :''}}> Select Shift @foreach ($shifts as $shift) scheduleDetails[$thursDate]['shiftId'] == $shift->id) ? 'selected' : ''}} data-color="{{$shift->color}}">{{$shift->name}} @endforeach Remove Shift scheduleDetails[$thursDate]['shiftId'] == '')? 'style=display:none;' :''}}> @if($profile->scheduleDetails[$thursDate]['shiftId'] != '' && $profile->scheduleDetails[$thursDate]['is_admin_note']) @endif @if($profile->scheduleOffDetails[$thursDate] == 1) @endif @if(!empty($profile->timeCardProfile)) @foreach ($profile->timeCardProfile as $timeP) @if($timeP->day==$thursDateYmd) Total Hrs : {{ $timeP->total_hours }} @endif @endforeach @endif	scheduleDetails[$friDate]['shiftId'] !='') style="background-color:{{$profile->scheduleDetails[$friDate]['color']}} ;" @endif> scheduleOffDetails[$friDate] == 1)? $profile->scheduleOffDetails[$friDate.'_isdisable'] :''}}> Select Shift @foreach ($shifts as $shift) scheduleDetails[$friDate]['shiftId'] == $shift->id) ? 'selected' : ''}} data-color="{{$shift->color}}">{{$shift->name}} @endforeach Remove Shift scheduleDetails[$friDate]['shiftId'] == '')? 'style=display:none;' :''}}> @if($profile->scheduleDetails[$friDate]['shiftId'] != '' && $profile->scheduleDetails[$friDate]['is_admin_note']) @endif @if($profile->scheduleOffDetails[$friDate] == 1) @endif @if(!empty($profile->timeCardProfile)) @foreach ($profile->timeCardProfile as $timeP) @if($timeP->day==$friDateYmd) Total Hrs : {{ $timeP->total_hours }} @endif @endforeach @endif	scheduleDetails[$saturdayDate]['shiftId'] !='') style="background-color:{{$profile->scheduleDetails[$saturdayDate]['color']}} ;" @endif> scheduleOffDetails[$saturdayDate] == 1) ? $profile->scheduleOffDetails[$saturdayDate.'_isdisable'] :''}}> Select Shift @foreach ($shifts as $shift) scheduleDetails[$saturdayDate]['shiftId'] == $shift->id) ? 'selected' : ''}} data-color="{{$shift->color}}">{{$shift->name}} @endforeach Remove Shift scheduleDetails[$saturdayDate]['shiftId'] == '')? 'style=display:none;' :''}}> @if($profile->scheduleDetails[$saturdayDate]['shiftId'] != '' && $profile->scheduleDetails[$saturdayDate]['is_admin_note']) @endif @if($profile->scheduleOffDetails[$saturdayDate] == 1) @endif @if(!empty($profile->timeCardProfile)) @foreach ($profile->timeCardProfile as $timeP) @if($timeP->day==$saturdayDateYmd) Total Hrs : {{ $timeP->total_hours }} @endif @endforeach @endif	scheduleDetails[$sundayDate]['shiftId'] !='') style="background-color:{{$profile->scheduleDetails[$sundayDate]['color']}} ;" @endif> scheduleOffDetails[$sundayDate] == 1)? $profile->scheduleOffDetails[$sundayDate.'_isdisable'] :''}}> Select Shift @foreach ($shifts as $shift) scheduleDetails[$sundayDate]['shiftId'] == $shift->id) ? 'selected' : ''}} data-color="{{$shift->color}}">{{$shift->name}} @endforeach Remove Shift scheduleDetails[$sundayDate]['shiftId'] == '')? 'style=display:none;' :''}}> @if($profile->scheduleDetails[$sundayDate]['shiftId'] != '' && $profile->scheduleDetails[$sundayDate]['is_admin_note']) @endif @if($profile->scheduleOffDetails[$sundayDate] == 1) @endif @if(!empty($profile->timeCardProfile)) @foreach ($profile->timeCardProfile as $timeP) @if($timeP->day==$sundayDateYmd) Total Hrs : {{ $timeP->total_hours }} @endif @endforeach @endif	{{ $totalshifts }}
				@foreach ($shiftNameCounts['mon'] as $shiftNameCountName=>$shiftNameCountNumber) {{ $shiftNameCountName }} : {{ $shiftNameCountNumber }} @endforeach	@foreach ($shiftNameCounts['tues'] as $shiftNameCountName=>$shiftNameCountNumber) {{ $shiftNameCountName }} : {{ $shiftNameCountNumber }} @endforeach	@foreach ($shiftNameCounts['wed'] as $shiftNameCountName=>$shiftNameCountNumber) {{ $shiftNameCountName }} : {{ $shiftNameCountNumber }} @endforeach	@foreach ($shiftNameCounts['thus'] as $shiftNameCountName=>$shiftNameCountNumber) {{ $shiftNameCountName }} : {{ $shiftNameCountNumber }} @endforeach	@foreach ($shiftNameCounts['fri'] as $shiftNameCountName=>$shiftNameCountNumber) {{ $shiftNameCountName }} : {{ $shiftNameCountNumber }} @endforeach	@foreach ($shiftNameCounts['sat'] as $shiftNameCountName=>$shiftNameCountNumber) {{ $shiftNameCountName }} : {{ $shiftNameCountNumber }} @endforeach	@foreach ($shiftNameCounts['sun'] as $shiftNameCountName=>$shiftNameCountNumber) {{ $shiftNameCountName }} : {{ $shiftNameCountNumber }} @endforeach