/** * Run the database seeds. * * @return void */ public function run() { $entry = new Logs(); $entry->user = 1; $entry->action = "Deployed accounting system."; $entry->ip = "127.0.0.1"; $entry->save(); }
public function store_log(Request $request) { $valid = Validator::make($request->all(), ['file' => 'required|mimes:txt']); if ($valid->fails()) { $error = $valid->errors()->all(); return $error; } if ($request->hasFile('file')) { $files = $request->file('file'); $mime = $files->getClientMimeType(); $path = $files->getRealPath(); $room = $request->input('room'); if ($room == 1) { if ($mime == "text/plain") { $contents = file($files->getRealPath()); for ($i = 1; $i < count($contents); $i++) { $tmp = preg_split("/\\s+/", $contents[$i]); $date = $tmp[3] . " " . $tmp[4]; $date = str_replace('/', '-', $date); $date = date("Y-m-d H:i:s", strtotime($date)); $log = Logs::where('access', '=', $date)->get(); if ($log->isEmpty()) { $query = Cards::where('card_id', '=', $tmp[2])->where('room_id', '=', $room)->get(); $log = new Logs(); $log->card_id = $query[0]->id; $log->room_id = $room; $log->date = date("d-m-Y", strtotime($date)); $log->access = $date; $log->save(); } } return "true"; } else { if ($mime == "text/csv") { $open = fopen($path, "r"); $tmp = 0; while (!empty($data = fgetcsv($open))) { if ($tmp != 0) { $data[3] = str_replace('/', '-', $data[3]); $date = date("Y-m-d H:i:s", strtotime($data[3])); $log = Logs::where('access', '=', $date)->get(); if ($log->isEmpty()) { $query = Cards::where('card_id', '=', $data[2])->where('room_id', '=', $room)->get(); $log = new Logs(); $log->card_id = $query[0]->id; $log->room_id = $room; $log->date = date("d-m-Y", strtotime($data[3])); $log->access = $date; $log->save(); } } $tmp = 1; } fclose($open); return "true"; } } } else { if ($room == 2) { $contents = file($files->getRealPath()); for ($i = 1; $i < count($contents); $i++) { $tmp = explode("\t", $contents[$i]); $log = Logs::where('access', '=', $tmp[9])->get(); if ($log->isEmpty()) { if ($tmp[2] != '00000000') { $query = Cards::where('card_id', '=', $tmp[2])->where('room_id', '=', $room)->get(); $log = new Logs(); $log->card_id = $query[0]->id; $log->room_id = $room; $log->date = date("d-m-Y", strtotime($tmp[9])); $log->access = $tmp[9]; $log->save(); } } } return "true"; } } } return "Error"; }