/** * Execute the console command. * * @author Bertrand Kintanar */ public function handle() { $employee_ids = [2, 3, 4, 5, 6, 7, 8, 10, 11, 19]; foreach ($employee_ids as $employee_id) { $start = Carbon::parse('2015-01-01'); $end = Carbon::parse('2015-01-31'); while ($start <= $end) { $employee = Employee::whereId($employee_id)->first(); $timelog = $employee->getTimeLog($start->toDateString()); $next_day = $employee->getTimeLog(Carbon::parse($start)->addDay()->toDateString()); if ($next_day['in_time'] == null and $next_day['out_time'] == null or $timelog['in_time'] == null and $timelog['out_time'] == null) { $start = $start->addDay(1); continue; } $data = ['employee_id' => $employee->id, 'work_date' => $start->toDateString(), 'in_time' => $timelog['in_time'], 'out_time' => $timelog['out_time']]; $attendance = Attendance::updateOrCreate($data); $this->info($attendance); Log::info($attendance); $start = $start->addDay(1); } } }