@php header("Content-type: application/vnd.ms-excel"); header("Content-Disposition: attachment; filename=staff-performance.xls"); @endphp @if( isset($entities) && count($entities) > 0) @foreach($entities as $key => $value) @php $step_a_start_datetime = isset($value->step_a_start_datetime) ? new DateTime($value->step_a_start_datetime) : ''; $step_b_start_datetime = isset($value->step_b_start_datetime) ? new DateTime($value->step_b_start_datetime) : ''; $step_c_start_datetime = isset($value->step_c_start_datetime) ? new DateTime($value->step_c_start_datetime) : ''; $step_d_start_datetime = isset($value->step_d_start_datetime) ? new DateTime($value->step_d_start_datetime) : ''; $step_e_start_datetime = isset($value->step_e_start_datetime) ? new DateTime($value->step_e_start_datetime) : ''; $step_f_start_datetime = isset($value->step_f_start_datetime) ? new DateTime($value->step_f_start_datetime) : ''; $step_g_start_datetime = isset($value->step_g_start_datetime) ? new DateTime($value->step_g_start_datetime) : ''; if(!is_null($value->step_a_start_datetime) && !is_null($value->step_b_start_datetime)){ $step_a_days = ''; $interval_step_a = ''; $interval_step_a = $step_a_start_datetime->diff($step_b_start_datetime); $datetimediff_step_a = $interval_step_a->format('%h h %i m'); $step_a_days = $interval_step_a->format('%a'); $total_min_step_a = ($step_a_days * 24 * 60) + ($interval_step_a->h * 60) + $interval_step_a->i; } if(!is_null($value->step_b_start_datetime) && !is_null($value->step_c_start_datetime)){ $step_b_days = ''; $interval_step_b = ''; $interval_step_b = $step_b_start_datetime->diff($step_c_start_datetime); $datetimediff_step_b = $interval_step_b->format('%h h %i m'); $step_b_days = $interval_step_b->format('%a'); $total_min_step_b = ($step_b_days * 24 * 60) + ($interval_step_b->h * 60) + $interval_step_b->i; } if(!is_null($value->step_c_start_datetime) && !is_null($value->step_d_start_datetime)){ $step_c_days = ''; $interval_step_c = ''; $interval_step_c = $step_c_start_datetime->diff($step_d_start_datetime); $datetimediff_step_c = $interval_step_c->format('%h h %i m'); $step_c_days = $interval_step_c->format('%a'); $total_min_step_c = ($step_c_days * 24 * 60) + ($interval_step_c->h * 60) + $interval_step_c->i; } if(!is_null($value->step_d_start_datetime) && !is_null($value->step_e_start_datetime)){ $step_d_days = ''; $interval_step_d = ''; $interval_step_d = $step_d_start_datetime->diff($step_e_start_datetime); $datetimediff_step_d = $interval_step_d->format('%h h %i m'); $step_d_days = $interval_step_d->format('%a'); $total_min_step_d = ($step_d_days * 24 * 60) + ($interval_step_d->h * 60) + $interval_step_d->i; } if(!is_null($value->step_e_start_datetime) && !is_null($value->step_f_start_datetime)){ $step_e_days = ''; $interval_step_e = ''; $interval_step_e = $step_e_start_datetime->diff($step_f_start_datetime); $datetimediff_step_e = $interval_step_e->format('%h h %i m'); $step_e_days = $interval_step_e->format('%a'); $total_min_step_e = ($step_e_days * 24 * 60) + ($interval_step_e->h * 60) + $interval_step_e->i; } if(!is_null($value->step_g_start_datetime) && !is_null($value->step_g_start_datetime)){ $step_f_days = ''; $interval_step_f = ''; $interval_step_f = $step_f_start_datetime->diff($step_g_start_datetime); $datetimediff_step_f = $interval_step_f->format('%h h %i m'); $step_f_days = $interval_step_f->format('%a'); $total_min_step_f = ($step_f_days * 24 * 60) + ($interval_step_f->h * 60) + $interval_step_f->i; } if(!is_null($value->step_a_start_datetime) && !is_null($value->step_g_start_datetime)){ $ttt_days = ''; $interval_step_g = ''; $interval_step_g = $step_a_start_datetime->diff($step_g_start_datetime); $datetimediff_ttt = $interval_step_g->format('%h h %i m'); $ttt_days = $interval_step_g->format('%a'); $total_min_ttt = ($ttt_days * 24 * 60) + ($interval_step_g->h * 60) + $interval_step_g->i; } @endphp @endforeach @endif

Case	SA	Mech	A	B-A	B	C-B	C	D-C	D	E-D	E	F-E	F	G-F	G	PT	TTT	Star
{{ isset($value->case_no) ? $value->case_no : '' }}	{{ isset($value->step_b_pic) ? $value->step_b_pic : '' }}	{{ isset($value->step_d_pic) ? $value->step_d_pic : '' }}	{{ isset($value->step_a_start_datetime) ? date('H:i a', strtotime($value->step_a_start_datetime)) : '' }}	{{ isset($value->step_b_start_datetime) ? $datetimediff_step_a : '' }} @if(isset($value->step_b_start_datetime) && !is_null($value->step_b_start_datetime)) @if(isset($total_min_step_a) && $total_min_step_a >= '5' && $total_min_step_a < '10') {{----}} 1 Star @elseif(isset($total_min_step_a) && $total_min_step_a >= '10' && $total_min_step_a < '15') {{-- --}} 2 Stars @elseif(isset($total_min_step_a) && $total_min_step_a >= '15') {{-- --}} 3 Stars @else @endif @endif	{{ isset($value->step_b_start_datetime) ? date('H:i a', strtotime($value->step_b_start_datetime)) : '' }}	{{ isset($value->step_c_start_datetime) ? $datetimediff_step_b : '' }} @if(isset($value->step_c_start_datetime) && !is_null($value->step_c_start_datetime)) @if(isset($total_min_step_b) && $total_min_step_b >= '13' && $total_min_step_b < '17') {{----}} 1 Star @elseif(isset($total_min_step_b) && $total_min_step_b >= '17' && $total_min_step_b < '20') {{-- --}} 2 Stars @elseif(isset($total_min_step_b) && $total_min_step_b >= '20') {{-- --}} 3 Stars @else @endif @endif	{{ isset($value->step_c_start_datetime) ? date('H:i a', strtotime($value->step_c_start_datetime)) : '' }}	{{ isset($value->step_d_start_datetime) ? $datetimediff_step_c : '' }} @if(isset($value->step_d_start_datetime) && !is_null($value->step_d_start_datetime)) @if(isset($total_min_step_c) && $total_min_step_c >= '10' && $total_min_step_c < '15') {{----}} 1 Star @elseif(isset($total_min_step_c) && $total_min_step_c >= '15' && $total_min_step_c < '20') {{-- --}} 2 Stars @elseif(isset($total_min_step_c) && $total_min_step_c >= '20') {{-- --}} 3 Stars @else @endif @endif	{{ isset($value->step_d_start_datetime) ? date('H:i a', strtotime($value->step_d_start_datetime)) : '' }}	{{ isset($value->step_e_start_datetime) ? $datetimediff_step_d : '' }}	{{ isset($value->step_e_start_datetime) ? date('H:i a', strtotime($value->step_e_start_datetime)) : '' }}	{{ isset($value->step_f_start_datetime) ? $datetimediff_step_e : '' }}	{{ isset($value->step_f_start_datetime) ? date('H:i a', strtotime($value->step_f_start_datetime)) : '' }}	{{ isset($value->step_g_start_datetime) ? $datetimediff_step_f : '' }}	{{ isset($value->step_g_start_datetime) ? date('H:i a', strtotime($value->step_g_start_datetime)) : '' }}	{{ isset($value->promised_time) ? date('H:i a', strtotime($value->promised_time)) : '' }}	{{ isset($datetimediff_ttt) && isset($value->step_g_start_datetime) ? $datetimediff_ttt : '' }}	@if($value->star == '1') {{----}} 1 Star @endif