public function postAddset(Request $request) { $this->validate($request, ['setid' => 'integer']); $setid = $request->input('setid'); $set = new Set(); if (!empty($setid)) { $set = Set::find($setid); } $set->name = $request->input('setname'); $set->drivertype = 0; if ($request->input('drivertype') == 1) { $set->drivertype = 1; } $set->datatype = $request->input('datatype'); $set->save(); $ids = explode(',', $request->input('requests')); Runner::where("setid", "=", $setid)->where("state", "=", "static")->delete(); for ($i = 1; $i < count($ids) - 1; $i++) { $runner = new Runner(); $runner->setid = $set->id; $runner->requestid = $ids[$i]; $runner->state = "static"; $runner->checkid = 1; $runner->checkstate = 0; $runner->save(); } return view("work.autotest.set.showset")->withSet($set); }
public function getLogs(Request $request) { $type = $request->input('type'); $id = $request->input('id'); $content = ""; if ($type == "debug") { $content = file_get_contents("/data1/www/autotest/logs/debug.log"); } else { if ($type == "error") { $content = file_get_contents("/data1/www/autotest/logs/error.log"); } else { if ($type == "info") { $content = file_get_contents("/data1/www/autotest/logs/info.log"); } } } foreach (Runner::where("setid", "=", $id)->where("state", "=", "static")->get() as $runner) { $runner->state = "wait"; $runner->save(); } return $content; }
public function export(Request $request, $race_id) { $race = Race::find($race_id); if ($request->has('format')) { $runners = Runner::where([['race_id', $race_id], ['status', 1]])->get(); $csv = Writer::createFromFileObject(new \SplTempFileObject()); if ($request->get('format') == 'excel_win') { $csv->setDelimiter(';'); $csv->setOutputBOM(Writer::BOM_UTF8); } $csv->insertOne(\Schema::getColumnListing('runners')); foreach ($runners as $runner) { $csv->insertOne($runner->toArray()); } $csv->output($race->prefix . '_runners.csv'); die; } return view('admin.export'); }
public function search(Requests\VerifyInputRequest $request, $prefix) { $race = Race::where('prefix', $prefix)->first(); $doc_num = $request->get('doc_num'); $mail = $request->get('mail'); $runner = Runner::where([['doc_num', $doc_num], ['mail', $mail], ['race_id', $race->id], ['status', 1], ['bib', '>', 0]])->first(); if (is_null($runner)) { return redirect($prefix . '/error')->with('verify', 'Lo sentimos, no existe ninguna inscripción registrada para el documento ' . $doc_num . ' y el correo ' . $mail); } else { return redirect($race->prefix . '/manifest')->with(['runner_id' => $runner->id]); } }