Route::post('/admin/user/new/schedule/', array('as' => 'adminProcessUserNewSchedule', 'uses' => function () { $data = Input::all(); $rules = array('start_time' => 'required', 'end_time' => 'required', 'rest_day' => 'required'); $validator = Validator::make($data, $rules); if ($validator->fails()) { $messages = $validator->messages(); return Redirect::to('/admin/user/new/' . $data['new_employee_id'] . '/schedule/')->withErrors($validator); //return Redirect::route('adminProcessUserNewSchedule')->withErrors($validator); } else { echo $startTime = date('H:i:s', strtotime(Input::get('start_time') . ' ' . Input::get('start_ampm'))); echo $endTime = date('H:i:s', strtotime(Input::get('end_time') . ' ' . Input::get('end_ampm'))); $interval = getDateTimeDiffInterval($startTime, $endTime); $hh = (int) $interval->format('%h'); $mm = (int) $interval->format('%i'); $ss = (int) $interval->format('%s'); echo $hoursPerDay = (double) getTimeToDecimalHours($hh, $mm, $ss); DB::table('work_shift')->insert(array('employee_id' => (int) $data['new_employee_id'], 'rest_day' => strtolower($data["rest_day"]), 'hours_per_day' => $hoursPerDay, 'start_time' => $startTime, 'end_time' => $endTime)); //return Redirect::to('/admin/user/new/schedule/'); return Redirect::route('adminDashboard'); } })); Route::get('/admin/user/{employeeId}/edit', array('as' => 'adminUserDelete', 'uses' => function ($employeeId) { //return $employeeId; /* //$employeeId = Auth::user()->employee_id; //$employeeId = Session::get('userEmployeeId'); //$userId = Session::get('userId'); */ $employee = new Employee(); $employeeInfo = $employee->getEmployeeInfoById($employeeId); $user = DB::table('users')->where('employee_id', $employeeId)->first();
function getUnderTimeHours($clockingIn, $clockingOut, $shiftStart, $shiftEnd) { $employeeId = Session::get('userEmployeeId'); $userId = Session::get('userId'); $setting = new Setting(); $employeeSetting = $setting->getEmployeeSettingByEmployeeId($employeeId); //$interval = getDateTimeDiffInterval($clockingOut, $shiftStart); $interval = getDateTimeDiffInterval($clockingOut, $clockingIn); $hh = (int) $interval->format('%h'); $mm = (int) $interval->format('%i'); $ss = (int) $interval->format('%s'); $underTimeHours = getTimeToDecimalHours($hh, $mm, $ss); //number_format($hours, 2); return number_format($underTimeHours, 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'); } //} }
<?php $scheduled['start_time'] = $getWorkShiftByDayOfTheWeek[0]->start_time; $scheduled['end_time'] = $getWorkShiftByDayOfTheWeek[0]->end_time; $interval = getDateTimeDiffInterval($scheduled['start_time'], $scheduled['end_time']); $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 = number_format(getTimeToDecimalHours($hh, $mm, $ss) - $breakTime, 2); //number_format($hours, 2); ?> <tr> <td><?php echo $employee->firstname . ', ' . $employee->lastname; ?> </td> <td><?php echo $scheduled['start_time'] . ' - ' . $scheduled['end_time']; ?> </td> <td><?php echo $clockingStatus; ?>
function getWorkHours($clockingIn, $clockingOut, $shiftEnd) { if (!empty(Session::get('searchEmployeeId'))) { $employeeId = Session::get('searchEmployeeId'); } else { $employeeId = Session::get('userEmployeeId'); //userId = Session::get('userId'); } $schedule = new Schedule(); $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; $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['has_break'] = $employeeSetting->has_break; $setting['break_time'] = $employeeSetting->break_time; } //$interval = getDateTimeDiffInterval($clockingIn, $shiftEnd); $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'); if ($setting['has_break'] === 1) { list($breakTimeHh, $breakTimeMm, $breakTimeSs) = explode(':', $setting['break_time']); //$breakTimeArr = explode(':', $setting['break_time']); $breakTime = getTimeToDecimalHours($breakTimeHh, $breakTimeMm, $breakTimeSs); //$breakTime = getTimeToDecimalHours($breakTimeArr[0], $breakTimeArr[1], $breakTimeArr[2]); $workHours = getTimeToDecimalHours($hh, $mm, $ss); //number_format($hours, 2); if ($workHours > $halfOfhoursPerDay) { //return $breakTime; $workHours = $workHours - $breakTime; return number_format($workHours, 2); } else { $workHours = getTimeToDecimalHours($hh, $mm, $ss); return number_format($workHours, 2); } } else { $workHours = getTimeToDecimalHours($hh, $mm, $ss); //number_format($hours, 2); return number_format($workHours, 2); } //return number_format($workHours, 2); }