Exemple #1
0
 /**
  * Show the form for creating a new resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function create()
 {
     if (Auth::guest()) {
         return view('login');
     } else {
         if (isset($_GET['org'])) {
             $org = \Ermtool\Organization::where('id', $_GET['org'])->value('name');
             //obtenemos stakeholders de la misma organización
             $stakes = DB::table('stakeholders')->join('organization_stakeholder', 'organization_stakeholder.stakeholder_id', '=', 'stakeholders.id')->where('organization_stakeholder.organization_id', '=', $_GET['org'])->select('stakeholders.id', DB::raw('CONCAT(name, " ", surnames) AS full_name'))->orderBy('name')->lists('full_name', 'id');
             if ($_GET['kind'] == 0) {
                 $processes = \Ermtool\Process::where('processes.status', 0)->join('subprocesses', 'subprocesses.process_id', '=', 'processes.id')->join('organization_subprocess', 'organization_subprocess.subprocess_id', '=', 'subprocesses.id')->where('organization_subprocess.organization_id', '=', $_GET['org'])->lists('processes.name', 'processes.id');
                 if (Session::get('languaje') == 'en') {
                     return view('en.hallazgos.create', ['org' => $org, 'processes' => $processes, 'kind' => $_GET['kind'], 'stakeholders' => $stakes, 'org_id' => $_GET['org']]);
                 } else {
                     return view('hallazgos.create', ['org' => $org, 'processes' => $processes, 'kind' => $_GET['kind'], 'stakeholders' => $stakes, 'org_id' => $_GET['org']]);
                 }
             } else {
                 if ($_GET['kind'] == 1) {
                     $subprocesses = \Ermtool\Subprocess::where('subprocesses.status', 0)->join('organization_subprocess', 'organization_subprocess.subprocess_id', '=', 'subprocesses.id')->where('organization_subprocess.organization_id', '=', $_GET['org'])->lists('subprocesses.name', 'subprocesses.id');
                     if (Session::get('languaje') == 'en') {
                         return view('en.hallazgos.create', ['org' => $org, 'subprocesses' => $subprocesses, 'kind' => $_GET['kind'], 'stakeholders' => $stakes, 'org_id' => $_GET['org']]);
                     } else {
                         return view('hallazgos.create', ['org' => $org, 'subprocesses' => $subprocesses, 'kind' => $_GET['kind'], 'stakeholders' => $stakes, 'org_id' => $_GET['org']]);
                     }
                 } else {
                     if ($_GET['kind'] == 2) {
                         if (Session::get('languaje') == 'en') {
                             return view('en.hallazgos.create', ['org' => $org, 'kind' => $_GET['kind'], 'org_id' => $_GET['org'], 'stakeholders' => $stakes, 'org_id' => $_GET['org']]);
                         } else {
                             return view('hallazgos.create', ['org' => $org, 'kind' => $_GET['kind'], 'org_id' => $_GET['org'], 'stakeholders' => $stakes, 'org_id' => $_GET['org']]);
                         }
                     } else {
                         if ($_GET['kind'] == 3) {
                             $controls = DB::table('controls')->join('control_risk_subprocess', 'control_risk_subprocess.control_id', '=', 'controls.id')->join('risk_subprocess', 'risk_subprocess.id', '=', 'control_risk_subprocess.risk_subprocess_id')->join('organization_subprocess', 'organization_subprocess.subprocess_id', '=', 'risk_subprocess.subprocess_id')->where('organization_subprocess.organization_id', '=', $_GET['org'])->lists('controls.name', 'controls.id');
                             if (Session::get('languaje') == 'en') {
                                 return view('en.hallazgos.create', ['org' => $org, 'controls' => $controls, 'kind' => $_GET['kind'], 'stakeholders' => $stakes, 'org_id' => $_GET['org']]);
                             } else {
                                 return view('hallazgos.create', ['org' => $org, 'controls' => $controls, 'kind' => $_GET['kind'], 'stakeholders' => $stakes, 'org_id' => $_GET['org']]);
                             }
                         } else {
                             if ($_GET['kind'] == 4) {
                                 $controls = DB::table('controls')->join('control_objective_risk', 'control_objective_risk.control_id', '=', 'controls.id')->join('objective_risk', 'objective_risk.id', '=', 'control_objective_risk.objective_risk_id')->join('objectives', 'objectives.id', '=', 'objective_risk.objective_id')->where('objectives.organization_id', '=', $_GET['org'])->select('controls.*')->lists('controls.name', 'controls.id');
                                 if (Session::get('languaje') == 'en') {
                                     return view('en.hallazgos.create', ['org' => $org, 'controls' => $controls, 'kind' => $_GET['kind'], 'stakeholders' => $stakes, 'org_id' => $_GET['org']]);
                                 } else {
                                     return view('hallazgos.create', ['org' => $org, 'controls' => $controls, 'kind' => $_GET['kind'], 'stakeholders' => $stakes, 'org_id' => $_GET['org']]);
                                 }
                             } else {
                                 if ($_GET['kind'] == 5) {
                                     $audit_programs = DB::table('audit_programs')->join('audit_audit_plan_audit_program', 'audit_audit_plan_audit_program.audit_program_id', '=', 'audit_programs.id')->join('audit_audit_plan', 'audit_audit_plan.id', '=', 'audit_audit_plan_audit_program.audit_audit_plan_id')->join('audit_plans', 'audit_plans.id', '=', 'audit_audit_plan.audit_plan_id')->where('audit_plans.organization_id', '=', $_GET['org'])->lists('audit_programs.name', 'audit_audit_plan_audit_program.id');
                                     if (Session::get('languaje') == 'en') {
                                         return view('en.hallazgos.create', ['org' => $org, 'audit_programs' => $audit_programs, 'kind' => $_GET['kind'], 'stakeholders' => $stakes, 'org_id' => $_GET['org']]);
                                     } else {
                                         return view('hallazgos.create', ['org' => $org, 'audit_programs' => $audit_programs, 'kind' => $_GET['kind'], 'stakeholders' => $stakes, 'org_id' => $_GET['org']]);
                                     }
                                 } else {
                                     if ($_GET['kind'] == 6) {
                                         $audits = DB::table('audit_audit_plan')->join('audits', 'audits.id', '=', 'audit_audit_plan.audit_id')->join('audit_plans', 'audit_plans.id', '=', 'audit_audit_plan.audit_plan_id')->where('audit_plans.organization_id', '=', $_GET['org'])->select('audit_audit_plan.id', DB::raw('CONCAT(audit_plans.name, " - ", audits.name) AS audit_name'))->lists('audit_name', 'audit_audit_plan.id');
                                         if (Session::get('languaje') == 'en') {
                                             return view('en.hallazgos.create', ['org' => $org, 'audits' => $audits, 'kind' => $_GET['kind'], 'stakeholders' => $stakes, 'org_id' => $_GET['org']]);
                                         } else {
                                             return view('hallazgos.create', ['org' => $org, 'audits' => $audits, 'kind' => $_GET['kind'], 'stakeholders' => $stakes, 'org_id' => $_GET['org']]);
                                         }
                                     }
                                 }
                             }
                         }
                     }
                 }
             }
         } else {
             if (isset($_GET['test'])) {
                 $org = \Ermtool\Organization::getOrgIdByTestId($_GET['test']);
                 //obtenemos stakeholders de la misma organización
                 $stakes = \Ermtool\Stakeholder::listStakeholders($org);
                 $test = \Ermtool\Audit_test::getTestNameById($_GET['test']);
                 if (Session::get('languaje') == 'en') {
                     return view('en.hallazgos.create', ['test' => $test, 'test_id' => $_GET['test'], 'stakeholders' => $stakes]);
                 } else {
                     return view('hallazgos.create', ['test' => $test, 'test_id' => $_GET['test'], 'stakeholders' => $stakes]);
                 }
             } else {
                 if (isset($_GET['evaluation'])) {
                     $evaluation = \Ermtool\Control_evaluation::find($_GET['evaluation']);
                     $org = \Ermtool\Organization::getOrganizationIdFromControl($evaluation->control_id);
                     //obtenemos stakeholders de la misma organización
                     $stakes = \Ermtool\Stakeholder::listStakeholders($org->id);
                     $control = \Ermtool\Control::name($evaluation->control_id);
                     if (Session::get('languaje') == 'en') {
                         return view('en.hallazgos.create', ['control' => $control, 'evaluation_id' => $_GET['evaluation'], 'stakeholders' => $stakes]);
                     } else {
                         return view('hallazgos.create', ['control' => $control, 'evaluation_id' => $_GET['evaluation'], 'stakeholders' => $stakes]);
                     }
                 }
             }
         }
     }
 }
Exemple #2
0
 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 closeEvaluation($id)
 {
     global $id1;
     $id1 = $id;
     DB::transaction(function () {
         //primero que todo, cerramos el estado de la prueba de id = $id
         $eval = \Ermtool\Control_evaluation::find($GLOBALS['id1']);
         $eval->status = 2;
         $eval->save();
         //ahora calcularemos el resultado del control
         $control = \Ermtool\Control::calcControlValue($eval->control_id);
     });
 }