$overTime2 = '01:00:00';*/
/*$emplooyeeSetting = new Setting;
$getEmployeeSettingByEmployeeId = $emplooyeeSetting->getEmployeeSettingByEmployeeId();
return dd($getEmployeeSettingByEmployeeId); //If no setting found the result will be NULL
break;*/
//Todo: Refactoring the code
//Find the employee timesheet record for this day
$employeeClocking = Timesheet::where('employee_id', '=', $employeeId)->where('daydate', '=', date('Y-m-d'))->first();
$otherDayDate = date("Y-m-d", strtotime('-2 days'));
$getOtherDayDate = DB::table('employee_timesheet')->where('employee_id', $employeeId)->where('daydate', $otherDayDate)->get();
$yesterDayDate = date("Y-m-d", strtotime('yesterday'));
$getYesterDayDate = DB::table('employee_timesheet')->where('employee_id', $employeeId)->where('daydate', $yesterDayDate)->get();
$employeeNightDiffClocking = Timesheet::where('employee_id', '=', $employeeId)->where('daydate', '=', $yesterDayDate)->first();
$employeeSummary = Summary::where('employee_id', '=', $employeeId)->where('daydate', '=', date('Y-m-d'))->first();
$employeeSummaryNightDiffClocking = Summary::where('employee_id', '=', $employeeId)->where('daydate', '=', $yesterDayDate)->first();
//Get Other day clocking
if (!empty($getOtherDayDate[0])) {
$otherday['time_in_1'] = $getOtherDayDate[0]->time_in_1;
$otherday['time_in_2'] = $getOtherDayDate[0]->time_in_2;
$otherday['time_in_3'] = $getOtherDayDate[0]->time_in_3;
$otherday['time_out_1'] = $getOtherDayDate[0]->time_out_1;
$otherday['time_out_2'] = $getOtherDayDate[0]->time_out_2;
$otherday['time_out_3'] = $getOtherDayDate[0]->time_out_3;
}
if (!empty($getYesterDayDate[0])) {
//Get Yesterday clocking
$yesterday['time_in_1'] = $getYesterDayDate[0]->time_in_1;
$yesterday['time_in_2'] = $getYesterDayDate[0]->time_in_2;
$yesterday['time_in_3'] = $getYesterDayDate[0]->time_in_3;
$yesterday['time_out_1'] = $getYesterDayDate[0]->time_out_1;
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');
}
//}
}
