public function questions(Request $request)
{
// [1] validate the title and the CSV
$messages = ['title.required' => 'El título es requerido', 'the-csv.required' => 'El archivo de excel es requerido', 'the-csv.mimetypes' => 'El archivo debe ser excel'];
$this->validate($request, ['title' => 'bail|required|max:255', 'the-csv' => 'required|mimetypes:application/excel,application/vnd.ms-excel,application/x-excel,application/x-msexcel,application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'], $messages);
// [2] save the quiz blueprint
$user = Auth::user();
$blueprint = new Blueprint();
$blueprint->title = $request->input("title");
$blueprint->user_id = $user->id;
$blueprint->is_closed = 0;
$blueprint->is_public = 0;
$blueprint->is_visible = 0;
$blueprint->type = "generated";
$blueprint->save();
// [3] add the questions
$file = $request->file("the-csv");
$temp = $file->getPathName();
Excel::load($temp, function ($reader) use($blueprint) {
$reader->each(function ($row) use($blueprint) {
if (trim($row->pregunta) != "") {
$question = new Question();
//$options = !empty($row->seccion) ? (int)$row->seccion : 1;
$question->blueprint_id = $blueprint->id;
$question->question = $row->pregunta;
$question->section_id = !empty($row->seccion) ? (int) $row->seccion : 1;
$type = strtr(strtolower($row->tipo), "áéíóú", "aeiou");
if (in_array($type, ['numero', 'numerico', 'numerica', 'cantidad', 'cifra'])) {
$question->type = "number";
} elseif ($type == "estado") {
$question->type = "location-a";
} elseif ($type == "municipio") {
$question->type = "location-b";
} elseif ($type == "localidad") {
$question->type = "location-c";
} elseif ($type == "multiple" || $type == "opcion multiple") {
$question->type = "multiple";
} elseif ($type == "multiple multiple" || $type == "multiple-multiple") {
$question->type = "multiple-multiple";
} else {
$question->type = "text";
}
$question->save();
if (!empty($row->opciones) && ($question->type == "multiple" || $question->type == "multiple-multiple")) {
$options = explode("|", $row->opciones);
for ($i = 0; $i < count($options); $i++) {
$option = new Option();
$option->question_id = $question->id;
$option->blueprint_id = $blueprint->id;
$option->description = $options[$i];
$option->value = $i + 1;
//$options[$i];//$i+1;
$option->name = uniqid();
$option->order_num = $i;
$option->save();
}
// for
}
// if
}
});
})->first();
$request->session()->flash('status', ['type' => 'create', 'name' => $blueprint->title]);
return redirect("dashboard/encuestas");
}
public function createResultsOnly(Request $request)
{
$messages = ['title.required' => 'El título del formulario es un campo necesario', 'the-results-file.required' => 'Es necesario subir el archivo con los resultados', 'the-results-file.mimetypes' => 'El archivo debe ser CSV o Excel'];
// validate the title && file type
$this->validate($request, ['title' => 'required', 'the-results-file' => 'required|mimetypes:application/excel,application/vnd.ms-excel,application/x-excel,application/x-msexcel,application/vnd.openxmlformats-officedocument.spreadsheetml.sheet,text/csv'], $messages);
//
if ($request->file('the-results-file')->isValid()) {
$user = Auth::user();
$name = uniqid() . "." . $request->file("the-results-file")->guessExtension();
$path = "/csv/";
$request->file('the-results-file')->move(public_path() . $path, $name);
$blueprint = new Blueprint();
$blueprint->user_id = $user->id;
$blueprint->title = $request->input('title');
$blueprint->is_public = 0;
$blueprint->is_visible = 0;
$blueprint->is_closed = 1;
$blueprint->type = "results";
$blueprint->csv_file = $name;
$blueprint->save();
$request->session()->flash('status', ['type' => 'create', 'name' => $blueprint->title]);
return redirect('dashboard/encuesta/' . $blueprint->id);
} else {
$request->session()->flash('status', ['type' => 'create-fail', 'name' => $request->input('title')]);
return redirect("dashboard/encuestas");
}
}
