/** * 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"); }