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]);
}
}
