public function check_exact($start) { $query = new Query('CHECKEXACT', $this->dbh); $query->where('EXACTID', '>', $start); $query->order('EXACTID'); $result = $query->get('EXACTID,USERID,CHECKTIME,CHECKTYPE'); $result_array = []; foreach ($result as $row) { $result_array[] = ['date_time' => $row['CHECKTIME'], 'is_in' => $row['CHECKTYPE'] == 'I' ? 1 : 0, 'employee_id' => $row['USERID']]; } $manual_check = array_chunk($result_array, 1000); foreach ($manual_check as $value) { ManualCheck::insert($value); } $size = count($result); $this->num_data += $size; return $size > 0 ? $result[$size - 1]['EXACTID'] : $start; }
/** * Run the database seeds. * * @return void */ public function run() { DB::table('manual_checks')->delete(); $db = App::make('AccessDB'); $query = new Query('CHECKEXACT', $db->get_dbh()); $query->where('EXACTID', '>=', 1455); $query->order('EXACTID'); $result = $query->get('EXACTID,USERID,CHECKTIME,CHECKTYPE'); $result_array = []; foreach ($result as $row) { $result_array[] = ['date_time' => $row['CHECKTIME'], 'is_in' => $row['CHECKTYPE'] == 'I' ? 1 : 0, 'employee_id' => $row['USERID']]; } $manual_check = array_chunk($result_array, 1000); foreach ($manual_check as $value) { ManualCheck::insert($value); } $convert_file = public_path() . '\\Last Convert.txt'; $record = explode(';', file_get_contents($convert_file)); $record[0] = $result[count($result) - 1]['EXACTID']; $file = fopen($convert_file, 'w'); fwrite($file, implode(';', $record)); fclose($file); }