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