public function hallazgos($id) { if (Auth::guest()) { return view('login'); } else { //datos de evaluación de control $evaluation = \Ermtool\Control_evaluation::find($id); $issues = array(); $issues1 = \Ermtool\Issue::getIssueByControlEvaluation($id); $control_name = \Ermtool\Control::name($evaluation->control_id); $iss = new IssuesController(); //print_r($_POST); $i = 0; foreach ($issues1 as $issue) { if ($issue['plan_description'] != NULL) { $temp = $iss->formatearIssue($issue['id'], $issue['name'], $issue['classification'], $issue['recommendations'], $issue['plan_description'], $issue['plan_status'], $issue['plan_final_date']); } else { $temp = $iss->formatearIssue($issue['id'], $issue['name'], $issue['classification'], $issue['recommendations'], NULL, NULL, NULL); } $issues[$i] = ['id' => $temp['id'], 'name' => $temp['name'], 'classification' => $temp['classification'], 'recommendations' => $temp['recommendations'], 'plan' => $temp['plan'], 'status' => $temp['status'], 'status_origin' => $temp['status_origin'], 'final_date' => $temp['final_date'], 'evidence' => $issue['evidences']]; $i += 1; } $org_id = \Ermtool\Organization::getOrganizationIdFromControl($evaluation->control_id); if (Session::get('languaje') == 'en') { switch ($evaluation->kind) { case 0: $kind = 'Design test'; break; case 1: $kind = 'Operational effectiveness test'; break; case 2: $kind = 'Sustantive test'; break; case 3: $kind = 'Compliance test'; break; default: # code... break; } return view('en.hallazgos.index3', ['issues' => $issues, 'evaluation' => $evaluation, 'org_id' => $org_id, 'kind' => $kind]); } else { switch ($evaluation->kind) { case 0: $kind = 'Prueba de diseño'; break; case 1: $kind = 'Prueba de efectividad operativa'; break; case 2: $kind = 'Prueba sustantiva'; break; case 3: $kind = 'Prueba de cumplimiento'; break; default: # code... break; } return view('hallazgos.index3', ['issues' => $issues, 'evaluation' => $evaluation, 'control_name' => $control_name, 'org_id' => $org_id, 'kind' => $kind]); } } }
public function generarExcelIssue($type, $org) { //generamos variable global para usarla en la función excel global $id; global $org2; $id = $type; $org2 = $org; Excel::create('Reporte de hallazgos ' . date("d-m-Y"), function ($excel) { // título excel $excel->setTitle('Hallazgos'); //creador y compañia $excel->setCreator('Administrador B-GRC')->setCompany('B-GRC - IXUS Consulting'); //descripción $excel->setDescription('Reporte de hallazgos'); $excel->sheet('Auditorías', function ($sheet) { $issue = new Issues(); $datos = $issue->generarReporteIssuesExcel($GLOBALS['id'], $GLOBALS['org2']); //$datos2 = json_decode($datos); $sheet->fromArray($datos); //editamos formato de salida de celdas $sheet->cells('A1:J1', function ($cells) { $cells->setBackground('#013ADF'); $cells->setFontColor('#ffffff'); $cells->setFontFamily('Calibri'); $cells->setFontWeight('bold'); $cells->setFontSize(16); }); $sheet->freezeFirstRow(); }); })->export('xls'); }