@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	Car Plate Number	SA	Mech	Customer Enter	Waiting Time	SA Register	Registration Time	SA Finish Reg	Gantung Time	Taken By Mechanic	Repair Time	Returned To SA	SA Start Inv	Payment Made	Delivery Time	SA Finish Deliver	Promised Time	Total Time Taken
{{ isset($value->case_no) ? $value->case_no : '' }}	{{ isset($value->car_plate_number) ? $value->car_plate_number : '' }}	{{ 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', strtotime($value->step_a_start_datetime)) : '' }}	{{ isset($value->step_b_start_datetime) ? $datetimediff_step_a : '' }}	{{ isset($value->step_b_start_datetime) ? date('H:i', strtotime($value->step_b_start_datetime)) : '' }}	{{ isset($value->step_c_start_datetime) ? $datetimediff_step_b : '' }}	{{ isset($value->step_c_start_datetime) ? date('H:i', strtotime($value->step_c_start_datetime)) : '' }}	{{ isset($value->step_d_start_datetime) ? $datetimediff_step_c : '' }}	{{ isset($value->step_d_start_datetime) ? date('H:i', strtotime($value->step_d_start_datetime)) : '' }}	{{ isset($value->step_e_start_datetime) ? $datetimediff_step_d : '' }}	{{ isset($value->step_e_start_datetime) ? date('H:i', strtotime($value->step_e_start_datetime)) : '' }}	{{ isset($value->step_f_start_datetime) ? $datetimediff_step_e : '' }}	{{ isset($value->step_f_start_datetime) ? date('H:i', strtotime($value->step_f_start_datetime)) : '' }}	{{ isset($value->step_g_start_datetime) ? $datetimediff_step_f : '' }}	{{ isset($value->step_g_start_datetime) ? date('H:i', strtotime($value->step_g_start_datetime)) : '' }}	{{ isset($value->promised_time) ? date('H:i', strtotime($value->promised_time)) : '' }}	{{ isset($datetimediff_ttt) && isset($value->step_g_start_datetime) ? $datetimediff_ttt : '' }}