//LEGAL Holiday OT/RD SPL Holiday OT //Exceed the first 8 hours if (strtotime($employeeNightDiffClocking->total_hours_1) > $todayTotalWorkHours) { if (!empty($getHolidayByDate[0]->holiday_type)) { if ('Regular holiday' === $getHolidayByDate[0]->holiday_type) { //echo 'Regular holiday'; $employeeNightDiffClocking->total_overtime_1 = getOvertimeHours($clockingIn, $clockingOut, $getWorkShift[0]->start_time, $getWorkShift[0]->end_time); $employeeSummaryNightDiffClocking->rest_day_legal_holiday_overtime = getOvertimeHours($clockingIn, $clockingOut, $getWorkShift[0]->start_time, $getWorkShift[0]->end_time); } elseif ('Special non-working day' === $getHolidayByDate[0]->holiday_type) { //echo 'Special non-working day'; $employeeNightDiffClocking->total_overtime_1 = getOvertimeHours($clockingIn, $clockingOut, $getWorkShift[0]->start_time, $getWorkShift[0]->end_time); $employeeSummaryNightDiffClocking->rest_day_special_holiday_overtime = getOvertimeHours($clockingIn, $clockingOut, $getWorkShift[0]->start_time, $getWorkShift[0]->end_time); } } else { $employeeNightDiffClocking->total_overtime_1 = getOvertimeHours($clockingIn, $clockingOut, $getWorkShift[0]->start_time, $getWorkShift[0]->end_time); $employeeSummaryNightDiffClocking->rest_day_overtime = getOvertimeHours($clockingIn, $clockingOut, $getWorkShift[0]->start_time, $getWorkShift[0]->end_time); } } } } else { //Clocking out early/undertime //Todo: add a reason form } } else { //Code for the employee with schedule assign } if ($employeeNightDiffClocking->save()) { $employeeSummaryNightDiffClocking->save(); return Redirect::to('/redraw/timesheet'); } } else {
public function adminTimesheetSave() { //value, id, row_id, column $data = Input::all(); // return dd($data); if (Request::ajax()) { //General Settings $nightDiff['from'] = strtotime('22:00'); $nightDiff['to'] = strtotime('06:00'); $hasNightDiff = false; //$dayOfTheWeek = date('l'); $breakTime = date('H:i:s', strtotime('01:00:00')); $getTimesheet = Timesheet::where('id', (int) trim($data["row_id"]))->first(); //in-out 1 if ((int) $data["column"] === 3) { //var_dump($data["value"]); if (!empty($data["value"])) { $dataValueArr = explode('-', $data["value"]); /*return dd(getTardinessTime($clockingIn, $shiftStart)); exit;*/ if (!empty($dataValueArr)) { //UPDARTED TIME IN AND TIME OUT $clockingIn = trim($dataValueArr[0]); $clockingOut = trim($dataValueArr[1]); $timesheetId = $getTimesheet->id; $employeeId = $getTimesheet->employee_id; $clockingStatus = $getTimesheet->clocking_status; $shiftStart = $getTimesheet->schedule_in; $shiftEnd = $getTimesheet->schedule_out; //$scheduleIn = $getTimesheet->schedule_in; //$scheduleOut = $getTimesheet->schedule_out; $dayDate = $getTimesheet->daydate; $tardiness = $getTimesheet->tardiness_1; //don't forget clocking status //check schedule //General Settings //$nightDiff['from'] = strtotime('22:00:00'); //$nightDiff['to'] = strtotime('06:00:00'); $timeInDateTime = date('G', strtotime($clockingIn)); $timeOutDateTime = date('G', strtotime($clockingOut)); //$clockingIn = date( 'Y-m-d', strtotime($dayDate) ).' '.date( 'H:i:s', strtotime($clockingIn) ); //$clockingOut = date( 'Y-m-d', strtotime($dayDate) ).' '.date( 'H:i:s', strtotime($clockingOut) ); //e.g clockingIn result should be: 2015-05-15 15:30:13 //$hour >= 21 && $hour <= 4 //date('G', strtotime($nightDiff['from'])) //$clockingIn = date( 'Y-m-d', strtotime($dayDate) ).' '.date( 'H:i:s', strtotime($clockingIn) ); //$clockingOut = date( 'Y-m-d', strtotime($dayDate) ).' '.date( 'H:i:s', strtotime($clockingOut) ); //CHECK IF NIGHT DIFF TRUE if (date('G', strtotime($shiftStart)) >= date('G', strtotime($nightDiff['from'])) && date('G', strtotime($shiftEnd)) <= date('G', strtotime($nightDiff['to']))) { //echo 'DEBUG.IO'; if ($timeInDateTime < 24 && $timeInDateTime < date('G', strtotime($nightDiff['from']))) { $clockingIn = date('Y-m-d', strtotime($dayDate)) . ' ' . date('H:i:s', strtotime($clockingIn)); //$clockingIn = date( 'Y-m-d', strtotime($dayDate) ).' '.date( 'H:i:s', strtotime($clockingIn) ); } else { $clockingIn = date('Y-m-d', strtotime($dayDate)) . ' ' . date('H:i:s', strtotime($clockingIn)); } if ($timeOutDateTime < 24 && $timeOutDateTime < date('G', strtotime($nightDiff['to']))) { $clockingOut = date('Y-m-d', strtotime($dayDate . '1 day')) . ' ' . date('H:i:s', strtotime($clockingOut)); } else { $clockingOut = date('Y-m-d', strtotime($dayDate)) . ' ' . date('H:i:s', strtotime($clockingOut)); } } else { $clockingIn = date('Y-m-d', strtotime($dayDate)) . ' ' . date('H:i:s', strtotime($clockingIn)); $clockingOut = date('Y-m-d', strtotime($dayDate)) . ' ' . date('H:i:s', strtotime($clockingOut)); } $dayOfTheWeek = date('l', strtotime($dayDate)); $shift = 1; $schedule = new Schedule(); //$getSchedule = $schedule->getSchedule($employeeId, $employeeClocking->daydate); $getSchedule = DB::table('employee_schedule')->where('employee_id', $employeeId)->where('schedule_date', trim($dayDate))->first(); $workShift = new Workshift(); //$getWorkShiftByDayOfTheWeek = $workShift->getWorkShiftByDayOfTheWeek($employeeId, date('l', strtotime($employeeClocking->daydate)), $overtime->shift); $getWorkShiftByDayOfTheWeek = DB::table('work_shift')->where('employee_id', $employeeId)->where('name_of_day', date('l', strtotime($dayDate)))->where('shift', $shift)->first(); if (!empty($getSchedule)) { //$scheduled['start_time'] = $getSchedule[0]->start_time; //$scheduled['end_time'] = $getSchedule[0]->end_time; $scheduled['rest_day'] = $getSchedule->rest_day; } elseif (!empty($getWorkShiftByDayOfTheWeek)) { // From 01:00:00 change to 2015-04-30 09:00:00 //$scheduled['start_time'] = date( 'Y-m-d', strtotime($employeeClocking[0]->time_in_1) ).' '. // From 01:00:00 change to 2015-04-30 01:00:00 //$scheduled['end_time'] = date( 'Y-m-d', strtotime($clockingDateTime) ).' '. $scheduled['rest_day'] = $getWorkShiftByDayOfTheWeek->rest_day; } $holiday = DB::table('holiday')->where('date', trim($dayDate))->first(); //dd($holiday); $overtime = DB::table('overtime')->where('employee_id', $employeeId)->where('timesheet_id', $timesheetId)->where('seq_no', 1)->where('shift', 1)->where('overtime_status', 1)->get(); //dd($overtime); //CHECK IF HAS NIGHTDIFF if (strtotime($clockingIn) >= $nightDiff['from'] || strtotime($clockingOut) <= $nightDiff['to']) { $hasNightDiff = true; } if (strtotime(date('H:i', strtotime($clockingIn))) === strtotime(date('H:i', strtotime($shiftStart))) && strtotime(date('H:i', strtotime($clockingOut))) === strtotime(date('H:i', strtotime($shiftEnd)))) { DB::table('employee_timesheet')->where('id', $timesheetId)->update(array('time_in_1' => trim($clockingIn), 'time_out_1' => trim($clockingOut), 'tardiness_1' => '', 'undertime_1' => '', 'total_overtime_1' => '', 'overtime_status_1' => 'NULL')); //Todo: update overtime table DB::table('overtime')->where('employee_id', $employeeId)->where('timesheet_id', $timesheetId)->where('seq_no', 1)->where('shift', 1)->update(array('overtime_status' => 'NULL')); } //TARDINESS/LATES if (strtotime($clockingIn) > strtotime($shiftStart)) { $tardinessTime = getTardinessTime($clockingIn, $shiftStart); DB::table('employee_timesheet')->where('id', $timesheetId)->update(array('time_in_1' => trim($clockingIn), 'time_out_1' => trim($clockingOut), 'tardiness_1' => $tardinessTime, 'total_overtime_1' => '', 'overtime_status_1' => 'NULL')); //Todo: update overtime table DB::table('overtime')->where('employee_id', $employeeId)->where('timesheet_id', $timesheetId)->where('seq_no', 1)->where('shift', 1)->update(array('overtime_status' => 'NULL')); DB::table('employee_summary')->where('employee_id', $employeeId)->where('daydate', $dayDate)->update(array('lates' => $tardinessTime)); $getUpdatedTimesheet = Timesheet::where('id', (int) trim($timesheetId))->first(); } else { DB::table('employee_timesheet')->where('id', $timesheetId)->update(array('time_in_1' => trim($clockingIn), 'time_out_1' => trim($clockingOut), 'tardiness_1' => '')); DB::table('employee_summary')->where('employee_id', $employeeId)->where('daydate', $dayDate)->update(array('lates' => '')); } //dd($getUpdatedTimesheet); if (!empty($getUpdatedTimesheet)) { //LATE/TARDINESS: TRUE if (!empty($getUpdatedTimesheet->tardiness_1)) { //echo "LATE/TARDINESS: TRUE \n"; //TODO: check employee setting if has_break is true and break time is set. - function getWorkHours $workHours = getWorkHours($clockingIn, $clockingOut, $shiftEnd); //TODO: Compute total hours with out overtime - getTotalHours $totalHours = getTotalHours($clockingIn, $clockingOut, $shiftEnd); DB::table('employee_timesheet')->where('id', $timesheetId)->update(array('time_in_1' => trim($clockingIn), 'time_out_1' => trim($clockingOut), 'work_hours_1' => $workHours, 'total_hours_1' => $totalHours)); //Todo: update overtime table DB::table('overtime')->where('employee_id', $employeeId)->where('timesheet_id', $timesheetId)->where('seq_no', 1)->where('shift', 1)->update(array('overtime_status' => 'NULL')); } } else { //echo "LATE/TARDINESS: FALSE \n"; //TODO: check employee setting if has_break is true and break time is set. - function getWorkHours $workHours = getWorkHours($clockingIn, $clockingOut, $shiftEnd); //TODO: Compute total hours with overtime - getTotalHours $totalHours = getTotalHours($clockingIn, $clockingOut, $shiftEnd); DB::table('employee_timesheet')->where('id', $timesheetId)->update(array('time_in_1' => trim($clockingIn), 'time_out_1' => trim($clockingOut), 'work_hours_1' => $workHours, 'total_hours_1' => $totalHours)); } //UNDERTIME: TRUE if (strtotime($clockingOut) < strtotime($shiftEnd)) { //echo "UNDERTIME: TRUE \n"; $undertime = getUnderTimeHours($clockingIn, $clockingOut, $shiftStart, $shiftEnd); DB::table('employee_timesheet')->where('id', $timesheetId)->update(array('time_in_1' => trim($clockingIn), 'time_out_1' => trim($clockingOut), 'undertime_1' => $undertime, 'total_overtime_1' => '', 'overtime_status_1' => 'NULL')); //Todo: update overtime table DB::table('overtime')->where('employee_id', $employeeId)->where('timesheet_id', $timesheetId)->where('seq_no', 1)->where('shift', 1)->update(array('overtime_status' => 'NULL')); DB::table('employee_summary')->where('employee_id', $employeeId)->where('daydate', $dayDate)->update(array('undertime' => $undertime)); } else { DB::table('employee_timesheet')->where('id', $timesheetId)->update(array('time_in_1' => trim($clockingIn), 'time_out_1' => trim($clockingOut), 'undertime_1' => '')); DB::table('employee_summary')->where('employee_id', $employeeId)->where('daydate', $dayDate)->update(array('undertime' => '')); } //OVERTIME: TRUE $isOvertime = false; /*if ( date('H:i', strtotime($clockingIn)) <= date('H:i', strtotime($shiftStart)) && date('H:i', strtotime($clockingOut)) > date('H:i', strtotime($shiftEnd)) ) {*/ if (strtotime($clockingIn) <= strtotime($shiftStart) && strtotime($clockingOut) > strtotime($shiftEnd)) { //echo "OVERTIME: TRUE \n"; $isOvertime = true; $totalOvertime = getOvertimeHours($clockingOut, $shiftEnd); DB::table('employee_timesheet')->where('id', $timesheetId)->update(array('total_overtime_1' => $totalOvertime, 'time_in_1' => trim($clockingIn), 'time_out_1' => trim($clockingOut), 'tardiness_1' => '', 'undertime_1' => '', 'overtime_status_1' => 'NULL')); //Todo: update overtime table DB::table('overtime')->where('employee_id', $employeeId)->where('timesheet_id', $timesheetId)->where('seq_no', 1)->where('shift', 1)->update(array('overtime_status' => 'NULL')); } //dd($holiday); //REST DAY: FALSE if ($scheduled['rest_day'] !== 1) { //HOLIDAY: TRUE if (!empty($holiday)) { if ('Regular holiday' === $holiday->holiday_type) { //Regular holiday //echo "Regular holiday \n"; $totalHours = getTotalHours($clockingIn, $clockingOut, $shiftEnd); if (!$isOvertime) { //ISOVERTIME: FALSE DB::table('employee_summary')->where('employee_id', $employeeId)->where('daydate', $dayDate)->update(array('legal_holiday_night_diff' => $totalHours)); } } elseif ('Special non-working day' === $holiday->holiday_type) { //Special non-working day //echo "Special non-working day \n"; $totalHours = getTotalHours($clockingIn, $clockingOut, $shiftEnd); if (!$isOvertime) { //ISOVERTIME: FALSE DB::table('employee_summary')->where('employee_id', $employeeId)->where('daydate', $dayDate)->update(array('special_holiday_night_diff' => $totalHours)); } } //HOLIDAY: FALSE } else { //Regular Day //echo "HOLIDAY: FALSE \n"; //echo "Regular Day \n"; $totalHours = getTotalHours($clockingIn, $clockingOut, $shiftEnd); if (!$isOvertime) { //ISOVERTIME: FALSE DB::table('employee_summary')->where('employee_id', $employeeId)->where('daydate', $dayDate)->update(array('regular_night_differential' => $totalHours)); } } //REST DAY: TRUE } elseif ($scheduled['rest_day'] === 1) { //HOLIDAY: TRUE if (!empty($holiday)) { if ('Regular holiday' === $holiday->holiday_type) { //Regular holiday //echo "Regular holiday \n"; $totalHours = getTotalHours($clockingIn, $clockingOut, $shiftEnd); if (!$isOvertime) { //ISOVERTIME: FALSE DB::table('employee_summary')->where('employee_id', $employeeId)->where('daydate', $dayDate)->update(array('rest_day_legal_holiday_night_diff' => $totalHours)); } } elseif ('Special non-working day' === $holiday->holiday_type) { //Special non-working day //echo "Special non-working day \n"; $totalHours = getTotalHours($clockingIn, $clockingOut, $shiftEnd); if (!$isOvertime) { //ISOVERTIME: FALSE DB::table('employee_summary')->where('employee_id', $employeeId)->where('daydate', $dayDate)->update(array('rest_day_special_holiday_night_diff' => $totalHours)); } } //HOLIDAY: FALSE } else { //Regular Day //echo "HOLIDAY: FALSE \n"; //echo "Regular Day \n"; $totalHours = getTotalHours($clockingIn, $clockingOut, $shiftEnd); if (!$isOvertime) { //ISOVERTIME: FALSE DB::table('employee_summary')->where('employee_id', $employeeId)->where('daydate', $dayDate)->update(array('rest_day_night_differential' => $totalHours)); } } } //OVERTIME TRUE if (!empty($overtime)) { //REST DAY: FALSE if ($scheduled['rest_day'] !== 1) { //HOLIDAY: TRUE if (!empty($holiday)) { if ('Regular holiday' === $holiday->holiday_type) { //Regular holiday if (!$hasNightDiff) { $update = array('legal_holiday_overtime' => $totalOvertime); } elseif ($hasNightDiff) { $update = array('legal_holiday_overtime_night_diff' => $totalOvertime); } DB::table('employee_summary')->where('employee_id', $employeeId)->where('daydate', $dayDate)->update($update); } elseif ('Special non-working day' === $holiday->holiday_type) { //Special non-working day if (!$hasNightDiff) { $update = array('legal_holiday_overtime' => $totalOvertime); } elseif ($hasNightDiff) { $update = array('legal_holiday_overtime_night_diff' => $totalOvertime); } DB::table('employee_summary')->where('employee_id', $employeeId)->where('daydate', $dayDate)->update($update); } //HOLIDAY: FALSE } else { //Regular Day //echo "HOLIDAY: FALSE \n"; if (!$hasNightDiff) { $update = array('regular_overtime' => $totalOvertime); } elseif ($hasNightDiff) { $update = array('regular_overtime_night_diff' => $totalOvertime); } DB::table('employee_summary')->where('employee_id', $employeeId)->where('daydate', $dayDate)->update($update); } //REST DAY: TRUE } elseif ($scheduled['rest_day'] === 1) { //HOLIDAY: TRUE if (!empty($holiday)) { if ('Regular holiday' === $holiday->holiday_type) { //Regular holiday if (!$hasNightDiff) { $update = array('rest_day_legal_holiday_overtime' => $totalOvertime); } elseif ($hasNightDiff) { $update = array('rest_day_legal_holiday_overtime_night_diff' => $totalOvertime); } DB::table('employee_summary')->where('employee_id', $employeeId)->where('daydate', $dayDate)->update($update); } elseif ('Special non-working day' === $holiday->holiday_type) { //Special non-working day if (!$hasNightDiff) { $update = array('rest_day_legal_holiday_overtime' => $totalOvertime); } elseif ($hasNightDiff) { $update = array('rest_day_legal_holiday_overtime_night_diff' => $totalOvertime); } DB::table('employee_summary')->where('employee_id', $employeeId)->where('daydate', $dayDate)->update($update); } //HOLIDAY: FALSE } else { //Regular Day //echo "HOLIDAY: FALSE \n"; if (!$hasNightDiff) { $update = array('rest_day_overtime' => $totalOvertime); } elseif ($hasNightDiff) { $update = array('rest_day_overtime_night_diff' => $totalOvertime); } DB::table('employee_summary')->where('employee_id', $employeeId)->where('daydate', $dayDate)->update($update); } } } else { } } else { return "Not Allowed"; } } else { return "Not Allowed"; } } //in-out 2 if ((int) $data["column"] === 4) { if (!empty($data["value"])) { $dataValueArr = explode('-', $data["value"]); return DB::table('employee_timesheet')->where('id', (int) $data["row_id"])->update(array('time_in_2' => trim($dataValueArr[0]), 'time_out_2' => trim($dataValueArr[1]))); } } //in-out 3 if ((int) $data["column"] === 5) { if (!empty($data["value"])) { $dataValueArr = explode('-', $data["value"]); return DB::table('employee_timesheet')->where('id', (int) $data["row_id"])->update(array('time_in_3' => trim($dataValueArr[0]), 'time_out_3' => trim($dataValueArr[1]))); } } //return Redirect::to('/redraw/timesheet'); } }
function getTotalHoursYesterday($clockingIn, $clockingOut, $shiftEnd) { $yesterDayDate = date("Y-m-d", strtotime('yesterday')); $schedule = new Schedule(); $getSchedule = $schedule->getSchedule($employeeId, $yesterDayDate); //$getSchedule = $schedule->getSchedule($employeeId, date('Y-m-d')); $workShift = new Workshift(); $getWorkShiftByEmployeeId = $workShift->getWorkShiftByEmployeeId($employeeId); $setting = new Setting(); $employeeSetting = $setting->getEmployeeSettingByEmployeeId($employeeId); if (!empty($getSchedule)) { $schedule['start_time'] = $getSchedule[0]->start_time; $schedule['end_time'] = $getSchedule[0]->end_time; $schedule['hours_per_day'] = $getSchedule[0]->hours_per_day; $halfOfhoursPerDay = $schedule['hours_per_day'] / 2; // e.g 8.00 without break } elseif (!empty($getWorkShiftByEmployeeId)) { /*$workShift['start_time'] = $getWorkShiftByEmployeeId[0]->start_time; $workShift['end_time'] = $getWorkShiftByEmployeeId[0]->end_time; $workShift['hours_per_day'] = $getWorkShiftByEmployeeId[0]->hours_per_day;*/ $workShift['start_time'] = date('Y-m-d', strtotime($clockingIn)) . ' ' . $getWorkShiftByEmployeeId[0]->start_time; $workShift['end_time'] = date('Y-m-d', strtotime('-1 day')) . ' ' . $getWorkShiftByEmployeeId[0]->end_time; //$workShift['rest_day'] = explode(', ', $getWorkShiftByEmployeeId[0]->rest_day); $workShift['hours_per_day'] = $getWorkShiftByEmployeeId[0]->hours_per_day; $halfOfhoursPerDay = $workShift['hours_per_day'] / 2; // e.g 8.00 without break } if (!empty($employeeSetting->hours_per_day)) { $halfOfhoursPerDay = $employeeSetting->hours_per_day / 2; // e.g 8.00 without break $setting['break_time'] = $employeeSetting->break_time; } $interval = getDateTimeDiffInterval($clockingIn, $clockingOut); $days = $interval->format('%a'); $days = (int) $days; if ($days !== 0) { $hhToDays = $days * 24; $hh = (int) $hhToDays; } else { $hh = (int) $interval->format('%h'); } $mm = (int) $interval->format('%i'); $ss = (int) $interval->format('%s'); $totalHours = getTimeToDecimalHours($hh, $mm, $ss); //number_format($hours, 2); $overtimeHours = getOvertimeHours($clockingOut, $shiftEnd); if ($employeeSetting->has_break === 1) { list($breakTimeHh, $breakTimeMm, $breakTimeSs) = explode(':', $setting['break_time']); $breakTime = getTimeToDecimalHours($breakTimeHh, $breakTimeMm, $breakTimeSs); } //$clockingOut = date('Y-m-d', strtotime($shiftEnd)).' '.$clockingOut; if (strtotime(date('H:i', strtotime($clockingOut))) > strtotime(date('H:i', strtotime($shiftEnd)))) { if ($employeeSetting->has_break === 1) { if ($totalHours > $halfOfhoursPerDay) { return number_format($totalHours, 2) + number_format($overtimeHours, 2) - $breakTime; } else { return number_format($totalHours, 2) + number_format($overtimeHours, 2); } } else { return number_format($totalHours, 2) + number_format($overtimeHours, 2); } } else { if ($employeeSetting->has_break === 1) { if ($totalHours > $halfOfhoursPerDay) { return number_format($totalHours, 2) - $breakTime; } else { return number_format($totalHours, 2); } } else { return number_format($totalHours, 2); } } }
public function updateTimesheetTimeOut3($data = '', $column = NULL) { //Settings $nightDiff['from'] = strtotime('22:00:00'); $nightDiff['to'] = strtotime('06:00:00'); $breakTime = date('H:i:s', strtotime('01:00:00')); $shift = 2; $hasNightDiff = false; $getTimesheet = Timesheet::where('id', (int) trim($data["row_id"]))->first(); $clockingIn = $getTimesheet->time_in_3; $clockingOut = $getTimesheet->time_out_3; $timeInHour = date('G', strtotime($clockingIn)); //24-hour format of an hour without leading zeros $timeOutHour = date('G', strtotime($clockingOut)); //24-hour format of an hour without leading zeros $timesheetId = $getTimesheet->id; $employeeId = $getTimesheet->employee_id; $clockingStatus = $getTimesheet->clocking_status; //$shiftStart = $getTimesheet->schedule_in; //$shiftEnd = $getTimesheet->schedule_out; $dayDate = $getTimesheet->daydate; $tardiness = $getTimesheet->tardiness_3; $dayOfTheWeek = date('l', strtotime($dayDate)); $getSummary = Summary::where('employee_id', $employeeId)->where('daydate', trim($dayDate))->first(); $hourNeedle = date('G', strtotime(trim($data['value']))); $hourHaystack = array(0, 1, 2, 3, 4, 5, 6); if (in_array($hourNeedle, $hourHaystack)) { $nightdiff = true; } else { $nightdiff = false; } $dayDateModify = new DateTime($dayDate); //Todo Add a condition here if (!empty($data['value']) && !empty($getTimesheet->time_in_3)) { if (!$nightdiff) { $clockingDateTime = date('Y-m-d', strtotime($dayDate)) . ' ' . date('H:i:s', strtotime($data['value'])); } else { //$dayDateModify = new DateTime($dayDate); $dayDateModify->modify('+1 day'); //$dayDateModify->format('Y-m-d'); $clockingDateTime = date('Y-m-d', strtotime($dayDateModify->format('Y-m-d'))) . ' ' . date('H:i:s', strtotime($data['value'])); } $getTimesheet->time_out_3 = $clockingDateTime; $getTimesheet->clocking_status = 'clock_out_3'; } elseif (!empty($data['value']) && empty($getTimesheet->time_in_3)) { if (!$nightdiff) { $clockingDateTime = date('Y-m-d', strtotime($dayDate)) . ' ' . date('H:i:s', strtotime($data['value'])); } else { //$dayDateModify = new DateTime($dayDate); $dayDateModify->modify('+1 day'); //$dayDateModify->format('Y-m-d'); $clockingDateTime = date('Y-m-d', strtotime($dayDateModify->format('Y-m-d'))) . ' ' . date('H:i:s', strtotime($data['value'])); } $getTimesheet->time_out_3 = $clockingDateTime; $getTimesheet->clocking_status = 'clock_out_3'; //close } elseif (empty($data['value']) && !empty($getTimesheet->time_in_3)) { $clockingDateTime = ''; $getTimesheet->time_out_3 = $clockingDateTime; $getTimesheet->clocking_status = 'clock_in_3'; } elseif (empty($data['value']) && empty($getTimesheet->time_in_3)) { $clockingDateTime = date('Y-m-d', strtotime($dayDate)) . ' ' . date('H:i:s', strtotime($data['value'])); if (!$nightdiff) { $clockingDateTime = date('Y-m-d', strtotime($dayDate)) . ' ' . date('H:i:s', strtotime($data['value'])); } else { //$dayDateModify = new DateTime($dayDate); $dayDateModify->modify('+1 day'); //$dayDateModify->format('Y-m-d'); $clockingDateTime = date('Y-m-d', strtotime($dayDateModify->format('Y-m-d'))) . ' ' . date('H:i:s', strtotime($data['value'])); } $getTimesheet->time_out_3 = ''; $getTimesheet->clocking_status = 'close'; } $schedule = new Schedule(); $getSchedule = DB::table('employee_schedule')->where('employee_id', $employeeId)->where('schedule_date', trim($dayDate))->first(); $workShift = new Workshift(); $getWorkShiftByDayOfTheWeek = DB::table('work_shift')->where('employee_id', $employeeId)->where('name_of_day', date('l', strtotime($dayDate)))->where('shift', $shift)->first(); $holiday = new Holiday(); $getHolidayByDate = DB::table('holiday')->where('date', trim($dayDate))->first(); if (!empty($getSchedule)) { $scheduled['start_time'] = $getSchedule->start_time; $scheduled['end_time'] = $getSchedule->end_time; $scheduled['rest_day'] = $getSchedule->rest_day; $startTime = date('H:i:s', strtotime($scheduled['start_time'])); } elseif (!empty($getWorkShiftByDayOfTheWeek)) { //$scheduled['start_time'] = $getWorkShiftByDayOfTheWeek->start_time; //$scheduled['end_time'] = $getWorkShiftByDayOfTheWeek->end_time; // From 01:00:00 change to 2015-04-30 09:00:00 $scheduled['start_time'] = date('Y-m-d', strtotime($getTimesheet->time_out_3)) . ' ' . $getWorkShiftByDayOfTheWeek->start_time; // From 01:00:00 change to 2015-04-30 01:00:00 $scheduled['end_time'] = date('Y-m-d', strtotime($clockingDateTime)) . ' ' . $getWorkShiftByDayOfTheWeek->end_time; $scheduled['rest_day'] = $getWorkShiftByDayOfTheWeek->rest_day; $startTime = $scheduled['start_time']; } //return dd($clockingDateTime); //SCHEDULED : TRUE if ((!empty($scheduled['start_time']) || $scheduled['start_time'] !== '00:00:00' || $scheduled['start_time'] !== '') && (!empty($scheduled['end_time']) || $scheduled['end_time'] !== '00:00:00' || $scheduled['end_time'] !== '')) { //REST DAY: FALSE if ($scheduled['rest_day'] !== 1) { $datetime1 = $getTimesheet->time_in_3; $datetime2 = $clockingDateTime; //$interval = getDateTimeDiffInterval($getTimesheet->time_in_3, $getTimesheet->time_out_3) { //Used $datetime1 = new DateTime($datetime1); $datetime2 = new DateTime($datetime2); $interval = $datetime1->diff($datetime2); $hh = $interval->format('%H'); $mm = $interval->format('%I'); $ss = $interval->format('%S'); $overtime = getTimeToDecimalHours($hh, $mm, $ss); //number_format($hours, 2);*/ //OVERTIME: TRUE $isOvertime = true; $getTimesheet->total_overtime_3 = $overtime; $getTimesheet->total_hours_3 = $overtime; /* //echo "LATE/TARDINESS: TRUE \n"; //TODO: check employee setting if has_break is true and break time is set. - function getWorkHours $workHours = $getTimesheet->total_overtime_3; if ( $workHours >= 8 || $workHours >= 8.00 || $workHours >= 8.0 ) { $getTimesheet->work_hours_3 = 8.00; } else { $getTimesheet->work_hours_3 = $workHours; } */ //TODO: Compute total hours with out overtime - getTotalHours $getTimesheet->total_hours_3 = $getTimesheet->total_overtime_3; //GET NIGHTDIFF $timeInArr = array(); $timeOutArr = array(); $timeInArr = explode(' ', $getTimesheet->time_in_3); $timeOutArr = explode(' ', $clockingDateTime); $nightDiff['from'] = strtotime(date('Y-m-d H:i', strtotime($timeInArr[0] . ' ' . '22:00:00'))); $nightDiff['to'] = strtotime(date('Y-m-d H:i', strtotime($timeOutArr[0] . ' ' . '06:00:00'))); $timesheet['timeIn'] = strtotime(date('Y-m-d H:i', strtotime($getTimesheet->time_in_3))); $timesheet['timeOut'] = strtotime(date('Y-m-d H:i', strtotime($clockingDateTime))); if ($timesheet['timeIn'] >= $nightDiff['from'] && $timesheet['timeIn'] <= $nightDiff['to']) { if ($timesheet['timeOut'] >= $nightDiff['to']) { // SET IT TO 8.00 //$getTimesheet->night_differential_3 = 8.00; $getTimesheet->night_differential_3 = ($nightDiff['to'] - $timesheet['timeIn']) / 3600; } else { //$getTimesheet->night_differential_3 = $overtime; $getTimesheet->night_differential_3 = ($timesheet['timeOut'] - $timesheet['timeIn']) / 3600; } } elseif ($timesheet['timeOut'] >= $nightDiff['from'] && $timesheet['timeOut'] <= $nightDiff['to']) { if ($timesheet['timeIn'] <= $nightDiff['from']) { //$getTimesheet->night_differential_3 = 8.00; $getTimesheet->night_differential_3 = ($timesheet['timeOut'] - $nightDiff['from']) / 3600; } else { //$getTimesheet->night_differential_3 = $overtime; $getTimesheet->night_differential_3 = ($timesheet['timeOut'] - $timesheet['timeIn']) / 3600; } } /*else { if($timesheet['timeIn'] < $nightDiff['from'] && $timesheet['timeOut'] > $nightDiff['to']) { //$getTimesheet->night_differential_3 = 8.00; $getTimesheet->night_differential_3 = ($nightDiff['from'] - $nightDiff['to']) / 3600; } }*/ //HOLIDAY: TRUE if (hasHoliday($dayDate)) { ////echo "HOLIDAY: TRUE \n"; if ('Regular holiday' === $getHolidayByDate->holiday_type) { //Regular holiday //echo "Regular holiday \n"; if (!$isOvertime) { //ISOVERTIME: FALSE $getSummary->legal_holiday = getTotalHours($getTimesheet->time_in_3, $clockingDateTime, $scheduled['end_time']); $getSummary->legal_holiday_overtime = ''; } else { //ISOVERTIME: TRUE $getSummary->legal_holiday_overtime = getOvertimeHours($clockingDateTime, $scheduled['end_time']); $getSummary->legal_holiday = ''; } } elseif ('Special non-working day' === $getHolidayByDate->holiday_type) { //Special non-working day //echo "Special non-working day \n"; if (!$isOvertime) { //ISOVERTIME: FALSE $getSummary->special_holiday = getTotalHours($getTimesheet->time_in_3, $clockingDateTime, $scheduled['end_time']); $getSummary->special_holiday_overtime = ''; } else { //ISOVERTIME: TRUE $getSummary->special_holiday_overtime = getOvertimeHours($clockingDateTime, $scheduled['end_time']); $getSummary->special_holiday = ''; } } //HOLIDAY: FALSE } else { //Regular Day //echo "HOLIDAY: FALSE \n"; //echo "Regular Day \n"; if (!$isOvertime) { //ISOVERTIME: FALSE $getSummary->regular = getTotalHours($getTimesheet->time_in_3, $clockingDateTime, $scheduled['end_time']); $getSummary->regular_overtime = ''; $getSummary->legal_holiday = ''; $getSummary->special_holiday = ''; } else { //ISOVERTIME: TRUE $getSummary->regular_overtime = getOvertimeHours($clockingDateTime, $scheduled['end_time']); $getSummary->regular = ''; $getSummary->legal_holiday_overtime = ''; $getSummary->special_holiday_overtime = ''; } } //REST DAY: TRUE } elseif ($scheduled['rest_day'] === 1) { $datetime1 = $getTimesheet->time_in_3; $datetime2 = $clockingDateTime; //$interval = getDateTimeDiffInterval($getTimesheet->time_in_3, $getTimesheet->time_out_3) { //Used $datetime1 = new DateTime($datetime1); $datetime2 = new DateTime($datetime2); $interval = $datetime1->diff($datetime2); $hh = $interval->format('%H'); $mm = $interval->format('%I'); $ss = $interval->format('%S'); $overtime = getTimeToDecimalHours($hh, $mm, $ss); //number_format($hours, 2);*/ //OVERTIME: TRUE $isOvertime = true; $getTimesheet->total_overtime_3 = $overtime; $getTimesheet->total_hours_3 = $overtime; /* //echo "LATE/TARDINESS: TRUE \n"; //TODO: check employee setting if has_break is true and break time is set. - function getWorkHours $workHours = $getTimesheet->total_overtime_3; if ( $workHours >= 8 || $workHours >= 8.00 || $workHours >= 8.0 ) { $getTimesheet->work_hours_3 = 8.00; } else { $getTimesheet->work_hours_3 = $workHours; } */ //TODO: Compute total hours with out overtime - getTotalHours $getTimesheet->total_hours_3 = $getTimesheet->total_overtime_3; //GET NIGHTDIFF $timeInArr = array(); $timeOutArr = array(); $timeInArr = explode(' ', $getTimesheet->time_in_3); $timeOutArr = explode(' ', $clockingDateTime); $nightDiff['from'] = strtotime(date('Y-m-d H:i', strtotime($timeInArr[0] . ' ' . '22:00:00'))); $nightDiff['to'] = strtotime(date('Y-m-d H:i', strtotime($timeOutArr[0] . ' ' . '06:00:00'))); $timesheet['timeIn'] = strtotime(date('Y-m-d H:i', strtotime($getTimesheet->time_in_3))); $timesheet['timeOut'] = strtotime(date('Y-m-d H:i', strtotime($clockingDateTime))); if ($timesheet['timeIn'] >= $nightDiff['from'] && $timesheet['timeIn'] <= $nightDiff['to']) { if ($timesheet['timeOut'] >= $nightDiff['to']) { // SET IT TO 8.00 $getTimesheet->night_differential_3 = 8.0; } else { $getTimesheet->night_differential_3 = $overtime; } } elseif ($timesheet['timeOut'] >= $nightDiff['from'] && $timesheet['timeOut'] <= $nightDiff['to']) { if ($timesheet['timeIn'] <= $nightDiff['from']) { $getTimesheet->night_differential_3 = 8.0; } else { $getTimesheet->night_differential_3 = $overtime; } } /*else { if($timesheet['timeIn'] < $nightDiff['from'] && $timesheet['timeOut'] > $nightDiff['to']) { $getTimesheet->night_differential_3 = 8.00; } }*/ //HOLIDAY: TRUE if (hasHoliday($dayDate)) { ////echo "HOLIDAY: TRUE \n"; if ('Regular holiday' === $getHolidayByDate->holiday_type) { //Regular holiday //echo "Regular holiday \n"; if (!$isOvertime) { //ISOVERTIME: FALSE $getSummary->rest_day_legal_holiday = getTotalHours($getTimesheet->time_in_3, $clockingDateTime, $scheduled['end_time']); $getSummary->rest_day_legal_holiday_overtime = ''; } else { //ISOVERTIME: TRUE $getSummary->rest_day_legal_holiday_overtime = getOvertimeHours($clockingDateTime, $scheduled['end_time']); $getSummary->rest_day_legal_holiday = ''; } } elseif ('Special non-working day' === $getHolidayByDate->holiday_type) { //Special non-working day //echo "Special non-working day \n"; if (!$isOvertime) { //ISOVERTIME: FALSE $getSummary->rest_day_special_holiday = getTotalHours($getTimesheet->time_in_3, $clockingDateTime, $scheduled['end_time']); $getSummary->rest_day_special_holiday_overtime = ''; } else { //ISOVERTIME: TRUE $getSummary->rest_day_special_holiday_overtime = getOvertimeHours($clockingDateTime, $scheduled['end_time']); $getSummary->rest_day_special_holiday = ''; } } //HOLIDAY: FALSE } else { //Regular Day //echo "HOLIDAY: FALSE \n"; //echo "Regular Day \n"; if (!$isOvertime) { //ISOVERTIME: FALSE $getSummary->rest_day = getTotalHours($getTimesheet->time_in_3, $clockingDateTime, $scheduled['end_time']); $getSummary->rest_day_overtime = ''; $getSummary->rest_day_legal_holiday = ''; $getSummary->rest_day_special_holiday = ''; } else { //ISOVERTIME: TRUE $getSummary->rest_day_overtime = getOvertimeHours($clockingDateTime, $scheduled['end_time']); $getSummary->rest_day = ''; $getSummary->rest_day_legal_holiday_overtime = ''; $getSummary->rest_day_special_holiday_overtime = ''; } } } } if ($getTimesheet->save()) { $getSummary->save(); return Redirect::to('/redraw/timesheet'); } //} }