/**
* Show the application dashboard.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$user = Auth::user();
$data['title'] = 'Dashboard Tú Evalúas';
$data['description'] = '';
$data['body_class'] = 'dash';
$data['user'] = $user;
$data['admins'] = $user->level == 3 ? User::all() : [];
$data['surveys'] = $user->level == 3 ? Blueprint::all() : $user->blueprints;
return view('dashboard')->with($data);
}
public function exportXLSX()
{
$user = Auth::user();
$surveys = $user->level == 3 ? Blueprint::all() : $user->blueprints;
Excel::create('encuestas', function ($excel) use($surveys, $user) {
$excel->setTitle("encuestas: datos");
$excel->setCreator('Tú Evalúas');
$excel->setDescription("Estadísticas de encuestas");
$excel->sheet("encuestas", function ($sheet) use($surveys, $user) {
$sheet->appendRow(["título", "ha concluido", "es pública", "es visible", "etiquetas", "categoría", "subcategorías", "está en proceso de autorización", "tipo", "ptp", "ramo", "programa", "descripción", "visitas", "envíos", "correos generados", "usuario: email", "usuario: tipo", "usuario: unidad", "usuario: ramo"]);
foreach ($surveys as $blueprint) {
$_user = $blueprint->user;
$sheet->appendRow([$blueprint->title, $blueprint->is_closed == 1 ? "sí" : "no", $blueprint->is_public == 1 ? "sí" : "no", $blueprint->is_visible == 1 ? "sí" : "no", $blueprint->tags, $blueprint->category, $blueprint->subcategory, $blueprint->pending == 1 ? "sí" : "no", $blueprint->type, $blueprint->ptp, $blueprint->branch, $blueprint->program, $blueprint->description, $blueprint->applicants()->has('answers')->count(), $blueprint->emails()->sum("emails"), $blueprint->applicants()->count(), $_user->email, $_user->level == 3 ? "administrador" : "funcionario público", $_user->unit, $_user->branch]);
}
});
})->export("xlsx");
}
