/**
* 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);
}
}
}
