public function run() { $faker = Faker::create(); foreach (range(1, 10) as $index) { Overtime::create([]); } }
} elseif (0 === (int) $data["action"]) { $totalOvertime = ''; 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', $employeeClocking->daydate)->update($update); } } } } return Redirect::route('adminTimeClock'); } else { foreach ($data["check"] as $check) { $overtimeById = Overtime::whereIn('id', $data["check"])->first(); $employeeId = $overtimeById->employee_id; if ($overtimeById->seq_no === 1 || $overtimeById->seq_no === 2) { $shift = 1; } elseif ($overtimeById->seq_no === 3) { $shift = 2; } $timesheet = new Timesheet(); $employeeClocking = Timesheet::where('id', $overtimeById->timesheet_id)->first(); $schedule = new Schedule(); //$getSchedule = $schedule->getSchedule($employeeId, $employeeClocking->daydate); $getSchedule = DB::table('employee_schedule')->where('employee_id', $employeeId)->where('schedule_date', trim($employeeClocking->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($employeeClocking->daydate)))->where('shift', $shift)->first(); //return dd($getWorkshiftByDayOfTheWeek);
/** * Remove the specified branch from storage. * * @param int $id * @return Response */ public function destroy($id) { $overtime = Overtime::findOrFail($id); Overtime::destroy($id); Audit::logaudit('Overtimes', 'delete', 'deleted: ' . $overtime->type); return Redirect::route('overtimes.index')->withDeleteMessage('Employee Overtime successfully deleted!'); }