/** * @Get("sandbox") * @author Bertrand Kintanar */ public function sandbox() { // Show attendance of a given employee $employee = Employee::whereId(3)->first(); $timelog = TimeLog::where('swipe_date', '>=', '2015-01-01')->where('swipe_date', '<=', '2015-01-31')->whereFaceId($employee->face_id)->get(); dd($timelog); $this->data['pageTitle'] = 'Dashboard'; return $this->template('pages.home'); }
/** * Execute the console command. * * @author Bertrand Kintanar */ public function handle() { $csv = Reader::createFromPath(storage_path() . '/attendance.csv'); $csv->setOffset(1); $data = $csv->query(); foreach ($data as $lineIndex => $row) { $times = array_slice($row, 4, count($row) - 1); foreach ($times as $time) { if (empty($time)) { continue; } $data = ['face_id' => $row[0], 'swipe_date' => $row[3], 'swipe_time' => $time, 'swipe_datetime' => Carbon::parse($row[3] . ' ' . $time)]; $timelog = TimeLog::create($data); $this->info($timelog); Log::info($timelog); } } }