public function indexGraficos($value)
{
if (Auth::guest()) {
return view('login');
} else {
//datos para gráfico de hallazgos
$issues_om = array();
$issues_def = array();
$issues_deb = array();
$op_mejora = 0;
$deficiencia = 0;
$deb_significativa = 0;
$issues_all = \Ermtool\Issue::all(['id', 'name', 'description', 'recommendations', 'classification', 'updated_at']);
$i = 0;
foreach ($issues_all as $issue) {
//debemos obtener datos de plan de acción y responsable de plan de acción (si es que hay)
$action_plan = NULL;
$action_plan = DB::table('action_plans')->where('issue_id', '=', $issue->id)->first(['id', 'description', 'final_date', 'status', 'stakeholder_id', 'updated_at']);
if ($action_plan != NULL) {
if ($action_plan->stakeholder_id == NULL) {
$user->name = "No definido";
$user->surnames = "";
} else {
//obtenemos nombre de responsable
$user = DB::table('stakeholders')->where('id', '=', $action_plan->stakeholder_id)->first(['name', 'surnames']);
}
if (Session::get('languaje') == 'en') {
//seteamos status
if ($action_plan->status == 0) {
$status = "In progress";
} else {
if ($action_plan->status == 1) {
$status = "Closed";
}
}
if ($action_plan->final_date == '0000-00-00') {
$final_date = "Error storing plan deadline";
} else {
//seteamos fecha final
$final_date_tmp = new DateTime($action_plan->final_date);
$final_date = date_format($final_date_tmp, 'd-m-Y');
}
} else {
//seteamos status
if ($action_plan->status == 0) {
$status = "En progreso";
} else {
if ($action_plan->status == 1) {
$status = "Cerrado";
}
}
if ($action_plan->final_date == '0000-00-00') {
$final_date = "Error al registrar fecha final";
} else {
//seteamos fecha final
$final_date_tmp = new DateTime($action_plan->final_date);
$final_date = date_format($final_date_tmp, 'd-m-Y');
}
}
$updated_at_tmp = new DateTime($action_plan->updated_at);
$updated_at = date_format($updated_at_tmp, 'd-m-Y');
$act_plan = ['id' => $action_plan->id, 'description' => $action_plan->description, 'final_date' => $final_date, 'stakeholder' => $user->name . ' ' . $user->surnames, 'status' => $status];
} else {
$act_plan = NULL;
}
if (Session::get('languaje') == 'en') {
if ($issue->description == "") {
$issue->description = "Without description";
}
if ($issue->recommendations == "") {
$issue->recommendations = "Without recommendations";
}
} else {
if ($issue->description == "") {
$issue->description = "Sin descripción";
}
if ($issue->recommendations == "") {
$issue->recommendations = "Sin recomendaciones";
}
}
//determinamos clasificación
if ($issue->classification == 0) {
$op_mejora += 1;
$issues_om[$i] = ['id' => $issue->id, 'name' => $issue->name, 'description' => $issue->description, 'recommendations' => $issue->recommendations, 'classification' => $issue->classification, 'updated_at' => $updated_at, 'action_plan' => $act_plan];
} else {
if ($issue->classification == 1) {
$deficiencia += 1;
$issues_def[$i] = ['id' => $issue->id, 'name' => $issue->name, 'description' => $issue->description, 'recommendations' => $issue->recommendations, 'classification' => $issue->classification, 'updated_at' => $updated_at, 'action_plan' => $act_plan];
} else {
if ($issue->classification == 2) {
$deb_significativa += 1;
$issues_deb[$i] = ['id' => $issue->id, 'name' => $issue->name, 'description' => $issue->description, 'recommendations' => $issue->recommendations, 'classification' => $issue->classification, 'updated_at' => $updated_at, 'action_plan' => $act_plan];
}
}
}
$i += 1;
}
$planes_ejec = 0;
//planes en ejecución
$planes_cerrados = 0;
//plan sin pruebas abiertas ni en ejecución, pero si cerradas
//para un gráfico separaremos 3 tipos de planes de acción: planes en planes de auditoria, planes en eval. de controles, y otros: cuando se agreguen genericamente (quizas)
$action_plans_ctrl = array();
$action_plans_audit = array();
$action_plans_others = array();
$action_plans_closed = array();
//planes de acción cerrados
$action_plans_warning = array();
//planes de acción próximos a cerrar
$action_plans_danger = array();
//planes de acción pasados en fecha y aun abiertos
$action_plans_open = array();
//planes de acción en los que la fecha de cierre es mayor a 2 meses
$cont_open = 0;
$cont_danger = 0;
$cont_warning = 0;
$cont_closed = 0;
$cont_ctrl = 0;
$cont_audit = 0;
$others = 0;
//primero los controlados
$action_plans = DB::table('action_plans')->join('issues', 'issues.id', '=', 'action_plans.issue_id')->join('control_evaluation', 'control_evaluation.issue_id', '=', 'issues.id')->join('controls', 'controls.id', '=', 'control_evaluation.control_id')->join('stakeholders', 'stakeholders.id', '=', 'action_plans.stakeholder_id')->whereNotNull('control_evaluation.issue_id')->select('action_plans.id', 'action_plans.description', 'action_plans.status', 'action_plans.final_date', 'action_plans.updated_at', 'controls.name as control', 'stakeholders.name as user_name', 'stakeholders.surnames as user_surnames', 'issues.description as issue', 'issues.recommendations')->get();
$i = 0;
foreach ($action_plans as $plan) {
$cont_ctrl += 1;
if (Session::get('languaje') == 'en') {
if ($plan->status == 0) {
$status = "In progress";
} else {
if ($plan->status == 1) {
$status = "Closed plan";
}
}
if ($plan->final_date == '0000-00-00') {
$final_date = "Error storing plan deadline";
} else {
//seteamos fecha final
$final_date_tmp = new DateTime($plan->final_date);
$final_date = date_format($final_date_tmp, 'd-m-Y');
}
} else {
if ($plan->status == 0) {
$status = "En progreso";
} else {
if ($plan->status == 1) {
$status = "Plan cerrado";
}
}
if ($plan->final_date == '0000-00-00') {
$final_date = "Error al registrar fecha final";
} else {
//seteamos fecha final
$final_date_tmp = new DateTime($plan->final_date);
$final_date = date_format($final_date_tmp, 'd-m-Y');
}
}
$updated_at_tmp = new DateTime($plan->updated_at);
$updated_at = date_format($updated_at_tmp, 'd-m-Y');
if (Session::get('languaje') == 'en') {
if ($plan->description == "") {
$plan->description = "Without description";
}
if ($plan->recommendations == "") {
$plan->recommendations = "Without recommendations";
}
} else {
if ($plan->description == "") {
$plan->description = "Sin descripción";
}
if ($plan->recommendations == "") {
$plan->recommendations = "Sin recomendaciones";
}
}
$action_plans_ctrl[$i] = ['id' => $plan->id, 'description' => $plan->description, 'status' => $status, 'final_date' => $final_date, 'updated_at' => $updated_at, 'control' => $plan->control, 'stakeholder' => $plan->user_name . ' ' . $plan->user_surnames, 'issue' => $plan->issue, 'recommendations' => $plan->recommendations];
//verificamos para tercer gráfico el tipo de control (abierto, proximo a cerrar, cerrado, falta mucho para que cierre...)
if ($plan->final_date != NULL) {
$fecha_temp = explode('-', $plan->final_date);
//obtenemos solo mes y año
$fecha_ano = (int) $fecha_temp[0] - (int) date('Y');
//obtenemos solo año
$fecha = (int) $fecha_temp[1] - (int) date('m');
//solo mes
$fecha_dia = (int) $fecha_temp[2] - (int) date('d');
//solo día
} else {
$fecha_ano = 9999 - (int) date('Y');
//año
$fecha = 12 - (int) date('m');
//mes
$fecha_dia = 31 - (int) date('d');
//día
}
if ($fecha_ano > 0) {
if ($plan->status == 1) {
$cont_closed += 1;
$action_plans_closed[$i] = ['id' => $plan->id, 'description' => $plan->description, 'status' => $status, 'final_date' => $final_date, 'updated_at' => $updated_at, 'stakeholder' => $plan->user_name . ' ' . $plan->user_surnames, 'issue' => $plan->issue, 'recommendations' => $plan->recommendations];
} else {
$cont_open += 1;
$action_plans_open[$i] = ['id' => $plan->id, 'description' => $plan->description, 'status' => $status, 'final_date' => $final_date, 'updated_at' => $updated_at, 'stakeholder' => $plan->user_name . ' ' . $plan->user_surnames, 'issue' => $plan->issue, 'recommendations' => $plan->recommendations];
}
} else {
if ($fecha_ano == 0) {
if ($fecha >= 2 && $plan->status == 0) {
$cont_open += 1;
$action_plans_open[$i] = ['id' => $plan->id, 'description' => $plan->description, 'status' => $status, 'final_date' => $final_date, 'updated_at' => $updated_at, 'stakeholder' => $plan->user_name . ' ' . $plan->user_surnames, 'issue' => $plan->issue, 'recommendations' => $plan->recommendations];
} else {
if ($fecha < 2 && $fecha >= 0 && $plan->status == 0) {
//verificamos día
if ($fecha_dia <= 0) {
$cont_danger += 1;
$action_plans_danger[$i] = ['id' => $plan->id, 'description' => $plan->description, 'status' => $status, 'final_date' => $final_date, 'updated_at' => $updated_at, 'stakeholder' => $plan->user_name . ' ' . $plan->user_surnames, 'issue' => $plan->issue, 'recommendations' => $plan->recommendations];
} else {
$cont_warning += 1;
$action_plans_warning[$i] = ['id' => $plan->id, 'description' => $plan->description, 'status' => $status, 'final_date' => $final_date, 'updated_at' => $updated_at, 'stakeholder' => $plan->user_name . ' ' . $plan->user_surnames, 'issue' => $plan->issue, 'recommendations' => $plan->recommendations];
}
} else {
if ($fecha < 0 && $plan->status == 0) {
$cont_danger += 1;
$action_plans_danger[$i] = ['id' => $plan->id, 'description' => $plan->description, 'status' => $status, 'final_date' => $final_date, 'updated_at' => $updated_at, 'stakeholder' => $plan->user_name . ' ' . $plan->user_surnames, 'issue' => $plan->issue, 'recommendations' => $plan->recommendations];
} else {
if ($plan->status == 1) {
$cont_closed += 1;
$action_plans_closed[$i] = ['id' => $plan->id, 'description' => $plan->description, 'status' => $status, 'final_date' => $final_date, 'updated_at' => $updated_at, 'stakeholder' => $plan->user_name . ' ' . $plan->user_surnames, 'issue' => $plan->issue, 'recommendations' => $plan->recommendations];
}
}
}
}
} else {
if ($plan->status == 1) {
$cont_closed += 1;
$action_plans_closed[$i] = ['id' => $plan->id, 'description' => $plan->description, 'status' => $status, 'final_date' => $final_date, 'updated_at' => $updated_at, 'stakeholder' => $plan->user_name . ' ' . $plan->user_surnames, 'issue' => $plan->issue, 'recommendations' => $plan->recommendations];
} else {
$cont_danger += 1;
$action_plans_danger[$i] = ['id' => $plan->id, 'description' => $plan->description, 'status' => $status, 'final_date' => $final_date, 'updated_at' => $updated_at, 'stakeholder' => $plan->user_name . ' ' . $plan->user_surnames, 'issue' => $plan->issue, 'recommendations' => $plan->recommendations];
}
}
}
$i += 1;
}
//ahora para action plans de auditoría
$action_plans = $this->getActionPlanAudit(NULL);
$i = 0;
foreach ($action_plans as $plan) {
$cont_audit += 1;
if (Session::get('languaje') == 'en') {
if ($plan->status == 0) {
$status = "In progress";
} else {
if ($plan->status == 1) {
$status = "Closed plan";
}
}
if ($plan->final_date == '0000-00-00') {
$final_date = "Error storing plan deadline";
} else {
//seteamos fecha final
$final_date_tmp = new DateTime($plan->final_date);
$final_date = date_format($final_date_tmp, 'd-m-Y');
}
if ($plan->description == "") {
$plan->description = "Without description";
}
if ($plan->recommendations == "") {
$plan->recommendations = "Without recommendations";
}
} else {
if ($plan->status == 0) {
$status = "En progreso";
} else {
if ($plan->status == 1) {
$status = "Plan cerrado";
}
}
if ($plan->final_date == '0000-00-00') {
$final_date = "Error al registrar fecha final";
} else {
//seteamos fecha final
$final_date_tmp = new DateTime($plan->final_date);
$final_date = date_format($final_date_tmp, 'd-m-Y');
}
if ($plan->description == "") {
$plan->description = "Sin descripción";
}
if ($plan->recommendations == "") {
$plan->recommendations = "Sin recomendaciones";
}
}
$updated_at_tmp = new DateTime($plan->updated_at);
$updated_at = date_format($updated_at_tmp, 'd-m-Y');
$action_plans_audit[$i] = ['id' => $plan->id, 'description' => $plan->description, 'status' => $status, 'final_date' => $final_date, 'audit_plan' => $plan->audit_plan_name, 'audit' => $plan->audit_name, 'program' => $plan->program_name, 'test' => $plan->test_name, 'stakeholder' => $plan->user_name . ' ' . $plan->user_surnames, 'issue' => $plan->issue_name, 'recommendations' => $plan->recommendations];
//verificamos para tercer gráfico el tipo de control (abierto, proximo a cerrar, cerrado, falta mucho para que cierre...)
$fecha_temp = explode('-', $plan->final_date);
//obtenemos solo mes y año
$fecha_ano = (int) $fecha_temp[0] - (int) date('Y');
//obtenemos solo año
$fecha = (int) $fecha_temp[1] - (int) date('m');
//solo mes
$fecha_dia = (int) $fecha_temp[2] - (int) date('d');
//solo día
if ($fecha_ano > 0) {
if ($plan->status == 1) {
$cont_closed += 1;
$action_plans_closed[$i] = ['id' => $plan->id, 'description' => $plan->description, 'status' => $status, 'final_date' => $final_date, 'updated_at' => $updated_at, 'stakeholder' => $plan->user_name . ' ' . $plan->user_surnames, 'issue' => $plan->issue_name, 'recommendations' => $plan->recommendations];
} else {
$cont_open += 1;
$action_plans_open[$i] = ['id' => $plan->id, 'description' => $plan->description, 'status' => $status, 'final_date' => $final_date, 'updated_at' => $updated_at, 'stakeholder' => $plan->user_name . ' ' . $plan->user_surnames, 'issue' => $plan->issue_name, 'recommendations' => $plan->recommendations];
}
} else {
if ($fecha_ano == 0) {
if ($fecha >= 2 && $plan->status == 0) {
$cont_open += 1;
$action_plans_open[$i] = ['id' => $plan->id, 'description' => $plan->description, 'status' => $status, 'final_date' => $final_date, 'updated_at' => $updated_at, 'stakeholder' => $plan->user_name . ' ' . $plan->user_surnames, 'issue' => $plan->issue_name, 'recommendations' => $plan->recommendations];
} else {
if ($fecha < 2 && $fecha >= 0 && $plan->status == 0) {
//verificamos día
if ($fecha_dia <= 0) {
$cont_danger += 1;
$action_plans_danger[$i] = ['id' => $plan->id, 'description' => $plan->description, 'status' => $status, 'final_date' => $final_date, 'updated_at' => $updated_at, 'stakeholder' => $plan->user_name . ' ' . $plan->user_surnames, 'issue' => $plan->issue_name, 'recommendations' => $plan->recommendations];
} else {
$cont_warning += 1;
$action_plans_warning[$i] = ['id' => $plan->id, 'description' => $plan->description, 'status' => $status, 'final_date' => $final_date, 'updated_at' => $updated_at, 'stakeholder' => $plan->user_name . ' ' . $plan->user_surnames, 'issue' => $plan->issue_name, 'recommendations' => $plan->recommendations];
}
} else {
if ($fecha < 0 && $plan->status == 0) {
$cont_danger += 1;
$action_plans_danger[$i] = ['id' => $plan->id, 'description' => $plan->description, 'status' => $status, 'final_date' => $final_date, 'updated_at' => $updated_at, 'stakeholder' => $plan->user_name . ' ' . $plan->user_surnames, 'issue' => $plan->issue_name, 'recommendations' => $plan->recommendations];
} else {
if ($plan->status == 1) {
$cont_closed += 1;
$action_plans_closed[$i] = ['id' => $plan->id, 'description' => $plan->description, 'status' => $status, 'final_date' => $final_date, 'updated_at' => $updated_at, 'stakeholder' => $plan->user_name . ' ' . $plan->user_surnames, 'issue' => $plan->issue_name, 'recommendations' => $plan->recommendations];
}
}
}
}
} else {
if ($plan->status == 1) {
$cont_closed += 1;
$action_plans_closed[$i] = ['id' => $plan->id, 'description' => $plan->description, 'status' => $status, 'final_date' => $final_date, 'updated_at' => $updated_at, 'stakeholder' => $plan->user_name . ' ' . $plan->user_surnames, 'issue' => $plan->issue_name, 'recommendations' => $plan->recommendations];
} else {
$cont_danger += 1;
$action_plans_danger[$i] = ['id' => $plan->id, 'description' => $plan->description, 'status' => $status, 'final_date' => $final_date, 'updated_at' => $updated_at, 'stakeholder' => $plan->user_name . ' ' . $plan->user_surnames, 'issue' => $plan->issue_name, 'recommendations' => $plan->recommendations];
}
}
}
$i += 1;
}
if (Session::get('languaje') == 'en') {
if (strstr($_SERVER["REQUEST_URI"], 'genexcelgraficos')) {
if ($value == 8) {
//damos formato en español y orden
$i = 0;
$plans = array();
foreach ($action_plans_ctrl as $plan) {
$plans[$i] = ['Control' => $plan['control'], 'Issue' => $plan['issue'], 'Recommendations' => $plan['recommendations'], 'Action Plan' => $plan['description'], 'Status' => $plan['status'], 'Final date' => $plan['final_date'], 'Responsable' => $plan['stakeholder']];
$i += 1;
}
return $plans;
} else {
if ($value == 9) {
$i = 0;
$plans = array();
foreach ($action_plans_audit as $plan) {
$plans[$i] = ['Audit plan' => $plan['audit_plan'], 'Audit' => $plan['audit'], 'Program' => $plan['program'], 'Test' => $plan['test'], 'Issue' => $plan['issue'], 'Recommendations' => $plan['recommendations'], 'Action plan' => $plan['description'], 'Status' => $plan['status'], 'Final date' => $plan['final_date'], 'Responsable' => $plan['stakeholder']];
$i += 1;
}
return $plans;
} else {
if ($value == 10) {
$i = 0;
$plans = array();
foreach ($issues_om as $plan) {
$plans[$i] = ['Issue' => $plan['name'], 'Description' => $plan['description'], 'Recommendations' => $plan['recommendations'], 'Classification' => $plan['classification'], 'Last updated' => $plan['updated_at'], 'Action plan' => $plan['action_plan']['description'], 'Plan final date' => $plan['action_plan']['final_date'], 'Plan status' => $plan['action_plan']['status'], 'Responsable' => $plan['action_plan']['stakeholder']];
$i += 1;
}
return $plans;
} else {
if ($value == 11) {
$i = 0;
$plans = array();
foreach ($issues_def as $plan) {
$plans[$i] = ['Issue' => $plan['name'], 'Description' => $plan['description'], 'Recommendations' => $plan['recommendations'], 'Classification' => $plan['classification'], 'Last updated' => $plan['updated_at'], 'Action plan' => $plan['action_plan']['description'], 'Plan final date' => $plan['action_plan']['final_date'], 'Plan status' => $plan['action_plan']['status'], 'Responsable' => $plan['action_plan']['stakeholder']];
$i += 1;
}
return $plans;
} else {
if ($value == 12) {
$i = 0;
$plans = array();
foreach ($issues_deb as $plan) {
$plans[$i] = ['Issue' => $plan['name'], 'Description' => $plan['description'], 'Recommendations' => $plan['recommendations'], 'Classification' => $plan['classification'], 'Last updated' => $plan['updated_at'], 'Action plan' => $plan['action_plan']['description'], 'Plan final date' => $plan['action_plan']['final_date'], 'Plan status' => $plan['action_plan']['status'], 'Responsable' => $plan['action_plan']['stakeholder']];
$i += 1;
}
return $plans;
} else {
if ($value == 13) {
$i = 0;
$plans = array();
foreach ($action_plans_open as $plan) {
$plans[$i] = ['Issue' => $plan['issue'], 'Recommendations' => $plan['recommendations'], 'Action plan' => $plan['description'], 'Status' => $plan['status'], 'Last updated' => $plan['updated_at'], 'Plan final date' => $plan['final_date'], 'Responsable' => $plan['stakeholder']];
$i += 1;
}
return $plans;
} else {
if ($value == 14) {
$i = 0;
$plans = array();
foreach ($action_plans_warning as $plan) {
$plans[$i] = ['Issue' => $plan['issue'], 'Recommendations' => $plan['recommendations'], 'Action plan' => $plan['description'], 'Status' => $plan['status'], 'Last updated' => $plan['updated_at'], 'Plan final date' => $plan['final_date'], 'Responsable' => $plan['stakeholder']];
$i += 1;
}
return $plans;
} else {
if ($value == 15) {
$i = 0;
$plans = array();
foreach ($action_plans_danger as $plan) {
$plans[$i] = ['Issue' => $plan['issue'], 'Recommendations' => $plan['recommendations'], 'Action plan' => $plan['description'], 'Status' => $plan['status'], 'Last updated' => $plan['updated_at'], 'Plan final date' => $plan['final_date'], 'Responsable' => $plan['stakeholder']];
$i += 1;
}
return $plans;
} else {
if ($value == 16) {
$i = 0;
$plans = array();
foreach ($action_plans_closed as $plan) {
$plans[$i] = ['Issue' => $plan['issue'], 'Recommendations' => $plan['recommendations'], 'Action plan' => $plan['description'], 'Status' => $plan['status'], 'Last updated' => $plan['updated_at'], 'Plan final date' => $plan['final_date'], 'Responsable' => $plan['stakeholder']];
$i += 1;
}
return $plans;
}
}
}
}
}
}
}
}
}
} else {
return view('en.reportes.planes_accion_graficos', ['issues_om' => $issues_om, 'issues_def' => $issues_def, 'issues_deb' => $issues_deb, 'op_mejora' => $op_mejora, 'deficiencia' => $deficiencia, 'deb_significativa' => $deb_significativa, 'cont_ctrl' => $cont_ctrl, 'cont_audit' => $cont_audit, 'others' => $others, 'action_plans_ctrl' => $action_plans_ctrl, 'action_plans_audit' => $action_plans_audit, 'action_plans_open' => $action_plans_open, 'action_plans_warning' => $action_plans_warning, 'action_plans_danger' => $action_plans_danger, 'action_plans_closed' => $action_plans_closed, 'cont_open' => $cont_open, 'cont_warning' => $cont_warning, 'cont_danger' => $cont_danger, 'cont_closed' => $cont_closed]);
}
} else {
if (strstr($_SERVER["REQUEST_URI"], 'genexcelgraficos')) {
if ($value == 8) {
//damos formato en español y orden
$i = 0;
$plans = array();
foreach ($action_plans_ctrl as $plan) {
$plans[$i] = ['Control' => $plan['control'], 'Hallazgo' => $plan['issue'], 'Recomendaciones' => $plan['recommendations'], 'Plan de acción' => $plan['description'], 'Estado' => $plan['status'], 'Fecha final' => $plan['final_date'], 'Responsable' => $plan['stakeholder']];
$i += 1;
}
return $plans;
} else {
if ($value == 9) {
$i = 0;
$plans = array();
foreach ($action_plans_audit as $plan) {
$plans[$i] = ['Plan de auditoría' => $plan['audit_plan'], 'Auditoría' => $plan['audit'], 'Programa' => $plan['program'], 'Prueba' => $plan['test'], 'Hallazgo' => $plan['issue'], 'Recomendaciones' => $plan['recommendations'], 'Plan de acción' => $plan['description'], 'Estado' => $plan['status'], 'Fecha final' => $plan['final_date'], 'Responsable' => $plan['stakeholder']];
$i += 1;
}
return $plans;
} else {
if ($value == 10) {
$i = 0;
$plans = array();
foreach ($issues_om as $plan) {
$plans[$i] = ['Hallazgo' => $plan['name'], 'Descripción' => $plan['description'], 'Recomendaciones' => $plan['recommendations'], 'Clasificación' => $plan['classification'], 'Última actualización' => $plan['updated_at'], 'Plan de acción' => $plan['action_plan']['description'], 'Fecha final plan' => $plan['action_plan']['final_date'], 'Estado del plan' => $plan['action_plan']['status'], 'Responsable' => $plan['action_plan']['stakeholder']];
$i += 1;
}
return $plans;
} else {
if ($value == 11) {
$i = 0;
$plans = array();
foreach ($issues_def as $plan) {
$plans[$i] = ['Hallazgo' => $plan['name'], 'Descripción' => $plan['description'], 'Recomendaciones' => $plan['recommendations'], 'Clasificación' => $plan['classification'], 'Última actualización' => $plan['updated_at'], 'Plan de acción' => $plan['action_plan']['description'], 'Fecha final plan' => $plan['action_plan']['final_date'], 'Estado del plan' => $plan['action_plan']['status'], 'Responsable' => $plan['action_plan']['stakeholder']];
$i += 1;
}
return $plans;
} else {
if ($value == 12) {
$i = 0;
$plans = array();
foreach ($issues_deb as $plan) {
$plans[$i] = ['Hallazgo' => $plan['name'], 'Descripción' => $plan['description'], 'Recomendaciones' => $plan['recommendations'], 'Clasificación' => $plan['classification'], 'Última actualización' => $plan['updated_at'], 'Plan de acción' => $plan['action_plan']['description'], 'Fecha final plan' => $plan['action_plan']['final_date'], 'Estado del plan' => $plan['action_plan']['status'], 'Responsable' => $plan['action_plan']['stakeholder']];
$i += 1;
}
return $plans;
} else {
if ($value == 13) {
$i = 0;
$plans = array();
foreach ($action_plans_open as $plan) {
$plans[$i] = ['Hallazgo' => $plan['issue'], 'Recomendaciones' => $plan['recommendations'], 'Plan de acción' => $plan['description'], 'Estado' => $plan['status'], 'Fecha actualizado' => $plan['updated_at'], 'Fecha final plan' => $plan['final_date'], 'Responsable' => $plan['stakeholder']];
$i += 1;
}
return $plans;
} else {
if ($value == 14) {
$i = 0;
$plans = array();
foreach ($action_plans_warning as $plan) {
$plans[$i] = ['Hallazgo' => $plan['issue'], 'Recomendaciones' => $plan['recommendations'], 'Plan de acción' => $plan['description'], 'Estado' => $plan['status'], 'Fecha actualizado' => $plan['updated_at'], 'Fecha final plan' => $plan['final_date'], 'Responsable' => $plan['stakeholder']];
$i += 1;
}
return $plans;
} else {
if ($value == 15) {
$i = 0;
$plans = array();
foreach ($action_plans_danger as $plan) {
$plans[$i] = ['Hallazgo' => $plan['issue'], 'Recomendaciones' => $plan['recommendations'], 'Plan de acción' => $plan['description'], 'Estado' => $plan['status'], 'Fecha actualizado' => $plan['updated_at'], 'Fecha final plan' => $plan['final_date'], 'Responsable' => $plan['stakeholder']];
$i += 1;
}
return $plans;
} else {
if ($value == 16) {
$i = 0;
$plans = array();
foreach ($action_plans_closed as $plan) {
$plans[$i] = ['Hallazgo' => $plan['issue'], 'Recomendaciones' => $plan['recommendations'], 'Plan de acción' => $plan['description'], 'Estado' => $plan['status'], 'Fecha actualizado' => $plan['updated_at'], 'Fecha final plan' => $plan['final_date'], 'Responsable' => $plan['stakeholder']];
$i += 1;
}
return $plans;
}
}
}
}
}
}
}
}
}
}
return view('reportes.planes_accion_graficos', ['issues_om' => $issues_om, 'issues_def' => $issues_def, 'issues_deb' => $issues_deb, 'op_mejora' => $op_mejora, 'deficiencia' => $deficiencia, 'deb_significativa' => $deb_significativa, 'cont_ctrl' => $cont_ctrl, 'cont_audit' => $cont_audit, 'others' => $others, 'action_plans_ctrl' => $action_plans_ctrl, 'action_plans_audit' => $action_plans_audit, 'action_plans_open' => $action_plans_open, 'action_plans_warning' => $action_plans_warning, 'action_plans_danger' => $action_plans_danger, 'action_plans_closed' => $action_plans_closed, 'cont_open' => $cont_open, 'cont_warning' => $cont_warning, 'cont_danger' => $cont_danger, 'cont_closed' => $cont_closed]);
}
}
}
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]);
}
}
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit()
{
if (Auth::guest()) {
return view('login');
} else {
if (isset($_GET['test_id'])) {
$test_id = $_GET['test_id'];
$eval_id = NULL;
} else {
if (isset($_GET['evaluation'])) {
$eval_id = $_GET['evaluation'];
$test_id = NULL;
} else {
$test_id = NULL;
$eval_id = NULL;
}
}
$org = \Ermtool\Organization::where('id', $_GET['org'])->value('name');
$org_id = \Ermtool\Organization::where('id', $_GET['org'])->value('id');
//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');
$issue = \Ermtool\Issue::find($_GET['id']);
//vemos si es que tiene plan de accion
$action_plan = NULL;
$action_plan = DB::table('action_plans')->where('issue_id', '=', $_GET['id'])->select('id', 'stakeholder_id', 'description', 'final_date', 'status')->first();
//vemos si es hallazgo de proceso, organización, u otro
if ($issue['process_id'] != NULL) {
$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');
$process_selected = $issue->process_id;
if (Session::get('languaje') == 'en') {
return view('en.hallazgos.edit', ['org' => $org, 'org_id' => $org_id, 'issue' => $issue, 'stakeholders' => $stakes, 'processes' => $processes, 'process_selected' => $process_selected, 'action_plan' => $action_plan, 'test_id' => $test_id, 'kind' => $_GET['kind']]);
} else {
return view('hallazgos.edit', ['org' => $org, 'org_id' => $org_id, 'issue' => $issue, 'stakeholders' => $stakes, 'processes' => $processes, 'process_selected' => $process_selected, 'action_plan' => $action_plan, 'test_id' => $test_id, 'kind' => $_GET['kind']]);
}
} else {
if ($issue['organization_id'] != NULL) {
if (Session::get('languaje') == 'en') {
return view('en.hallazgos.edit', ['org' => $org, 'org_id' => $org_id, 'issue' => $issue, 'stakeholders' => $stakes, 'org_id' => $_GET['org'], 'action_plan' => $action_plan, 'test_id' => $test_id, 'eval_id' => $eval_id, 'kind' => $_GET['kind']]);
} else {
return view('hallazgos.edit', ['org' => $org, 'org_id' => $org_id, 'issue' => $issue, 'stakeholders' => $stakes, 'org_id' => $_GET['org'], 'action_plan' => $action_plan, 'test_id' => $test_id, 'eval_id' => $eval_id, 'kind' => $_GET['kind']]);
}
} else {
if (!isset($_GET['kind'])) {
if (Session::get('languaje') == 'en') {
return view('en.hallazgos.edit', ['org' => $org, 'org_id' => $org_id, 'issue' => $issue, 'stakeholders' => $stakes, 'action_plan' => $action_plan, 'test_id' => $test_id, 'eval_id' => $eval_id, 'kind' => NULL]);
} else {
return view('hallazgos.edit', ['org' => $org, 'org_id' => $org_id, 'issue' => $issue, 'stakeholders' => $stakes, 'action_plan' => $action_plan, 'test_id' => $test_id, 'eval_id' => $eval_id, 'kind' => NULL]);
}
}
if (Session::get('languaje') == 'en') {
return view('en.hallazgos.edit', ['org' => $org, 'org_id' => $org_id, 'issue' => $issue, 'stakeholders' => $stakes, 'action_plan' => $action_plan, 'test_id' => $test_id, 'eval_id' => $eval_id, 'kind' => $_GET['kind']]);
} else {
return view('hallazgos.edit', ['org' => $org, 'org_id' => $org_id, 'issue' => $issue, 'stakeholders' => $stakes, 'action_plan' => $action_plan, 'test_id' => $test_id, 'eval_id' => $eval_id, 'kind' => $_GET['kind']]);
}
}
}
}
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
//print_r($_GET);
switch ($_GET['kind']) {
case 1:
//archivos de controles
if ($_GET['control_type'] == 0) {
$controls = \Ermtool\Control::getProcessesControls($_GET['organization_id']);
} else {
if ($_GET['control_type'] == 1) {
$controls = \Ermtool\Control::getBussinessControls($_GET['organization_id']);
}
}
$i = 0;
$org_name = \Ermtool\Organization::name($_GET['organization_id']);
//recorremos los controles para ver cuales tienen archivos
$controls2 = array();
foreach ($controls as $control) {
$files = Storage::files('controles/' . $control->id);
//vemos si existe la carpeta (si existe es porque tiene archivos)
if ($files != NULL) {
//obtenemos los riesgos asociados a este control
$risks = \Ermtool\Risk::getRisksFromControl($control->id, $_GET['control_type']);
$controls2[$i] = ['name' => $control->name, 'description' => $control->description, 'risks' => $risks, 'files' => $files];
$i += 1;
}
}
if (Session::get('languaje') == 'en') {
return view('en.documentos.show', ['elements' => $controls2, 'kind' => $_GET['kind'], 'control_type' => $_GET['control_type'], 'org_name' => $org_name]);
} else {
return view('documentos.show', ['elements' => $controls2, 'kind' => $_GET['kind'], 'control_type' => $_GET['control_type'], 'org_name' => $org_name]);
}
break;
case 2:
//hallazgos
//$files = Storage::files('evidencias_hallazgos');
//obtenemos id de los issues que son del tipo "kind_issue"
switch ($_GET['kind_issue']) {
case 0:
//obtenemos issues de proceso
$processes = \Ermtool\Process::getProcessFromIssues($_GET['organization_id']);
$process_issues = array();
//se guardaran los procesos que tienen issues que además tienen documentos
$i = 0;
foreach ($processes as $process) {
//obtenemos issues del proceso
$issues = \Ermtool\Issue::getProcessIssues($process->id);
$issues2 = array();
//array donde se guardaran los issues que tienen documentos
//recorremos los issues para ver por cada uno si posee archivos
$j = 0;
foreach ($issues as $issue) {
$files = Storage::files('evidencias_hallazgos/' . $issue->id);
//vemos si existe la carpeta (si existe es porque tiene archivos)
if ($files != NULL) {
$issues2[$j] = ['name' => $issue->name, 'description' => $issue->description, 'classification' => $issue->classification, 'recommendations' => $issue->recommendations, 'files' => $files];
$j += 1;
}
//else
//{
// echo 'el issue ' . $issue->id . ' no tiene evidencia<br>';
//}
}
//ahora guardamos solo aquellos procesos que tienen documentos asociados
if (!empty($issues2)) {
$process_issues[$i] = ['name' => $process->name, 'description' => $process->description, 'issues' => $issues2];
$i += 1;
}
}
if (Session::get('languaje') == 'en') {
return view('en.documentos.show', ['elements' => $process_issues, 'kind2' => $_GET['kind_issue']]);
} else {
return view('documentos.show', ['elements' => $process_issues, 'kind2' => $_GET['kind_issue']]);
}
break;
case 1:
//issues de subprocesos
$subprocesses = \Ermtool\Subprocess::getSubprocessFromIssues($_GET['organization_id']);
$subprocess_issues = array();
//se guardaran los subprocesos que tienen issues que además tienen documentos
$i = 0;
foreach ($subprocesses as $subprocess) {
//obtenemos issues del proceso
$issues = \Ermtool\Issue::getSubprocessIssuesBySubprocess($subprocess->id);
$issues2 = array();
//array donde se guardaran los issues que tienen documentos
//recorremos los issues para ver por cada uno si posee archivos
$j = 0;
foreach ($issues as $issue) {
$files = Storage::files('evidencias_hallazgos/' . $issue->id);
//vemos si existe la carpeta (si existe es porque tiene archivos)
if ($files != NULL) {
$issues2[$j] = ['name' => $issue->name, 'description' => $issue->description, 'classification' => $issue->classification, 'recommendations' => $issue->recommendations, 'files' => $files];
$j += 1;
}
}
//ahora guardamos solo aquellos subprocesos que tienen documentos asociados
if (!empty($issues2)) {
$subprocess_issues[$i] = ['name' => $subprocess->name, 'description' => $subprocess->description, 'issues' => $issues2, 'process' => $subprocess->process_name];
$i += 1;
}
}
if (Session::get('languaje') == 'en') {
return view('en.documentos.show', ['elements' => $subprocess_issues, 'kind2' => $_GET['kind_issue']]);
} else {
return view('documentos.show', ['elements' => $subprocess_issues, 'kind2' => $_GET['kind_issue']]);
}
break;
case 2:
//issues de organización
$issues = \Ermtool\Organization::find($_GET['organization_id'])->issues;
$org_name = \Ermtool\Organization::name($_GET['organization_id']);
$org_description = \Ermtool\Organization::description($_GET['organization_id']);
$issues2 = array();
//array donde se guardaran los issues que tienen documentos
//recorremos los issues para ver por cada uno si posee archivos
$j = 0;
foreach ($issues as $issue) {
$files = Storage::files('evidencias_hallazgos/' . $issue->id);
//vemos si existe la carpeta (si existe es porque tiene archivos)
if ($files != NULL) {
$issues2[$j] = ['name' => $issue['name'], 'description' => $issue['description'], 'classification' => $issue['classification'], 'recommendations' => $issue['recommendations'], 'files' => $files];
$j += 1;
}
}
if (Session::get('languaje') == 'en') {
return view('en.documentos.show', ['issues' => $issues2, 'org_name' => $org_name, 'org_description' => $org_description, 'kind2' => $_GET['kind_issue']]);
} else {
return view('documentos.show', ['issues' => $issues2, 'org_name' => $org_name, 'org_description' => $org_description, 'kind2' => $_GET['kind_issue']]);
}
break;
case 3:
//issues de control de proceso
$controls = \Ermtool\Control::getProcessesControlsFromIssues($_GET['organization_id']);
$controls_issues = array();
//se guardaran los controles que tienen issues que además tienen documentos
$i = 0;
foreach ($controls as $control) {
//obtenemos issues del control
$issues = \Ermtool\Issue::getControlIssues($control->id);
$issues2 = array();
//array donde se guardaran los issues que tienen documentos
//recorremos los issues para ver por cada uno si posee archivos
$j = 0;
foreach ($issues as $issue) {
$files = Storage::files('evidencias_hallazgos/' . $issue->id);
//vemos si existe la carpeta (si existe es porque tiene archivos)
if ($files != NULL) {
$issues2[$j] = ['name' => $issue->name, 'description' => $issue->description, 'classification' => $issue->classification, 'recommendations' => $issue->recommendations, 'files' => $files];
$j += 1;
}
}
//ahora guardamos solo aquellos controles que tienen documentos asociados
if (!empty($issues2)) {
$control_issues[$i] = ['name' => $control->name, 'description' => $control->description, 'issues' => $issues2];
$i += 1;
}
}
if (Session::get('languaje') == 'en') {
return view('en.documentos.show', ['elements' => $control_issues, 'kind2' => $_GET['kind_issue']]);
} else {
return view('documentos.show', ['elements' => $control_issues, 'kind2' => $_GET['kind_issue']]);
}
break;
case 4:
//issues de control de entidad
$controls = \Ermtool\Control::getObjectivesControlsFromIssues($_GET['organization_id']);
$control_issues = array();
//se guardaran los controles que tienen issues que además tienen documentos
$i = 0;
foreach ($controls as $control) {
//obtenemos issues del control
$issues = \Ermtool\Issue::getControlIssues($control->id);
$issues2 = array();
//array donde se guardaran los issues que tienen documentos
//recorremos los issues para ver por cada uno si posee archivos
$j = 0;
foreach ($issues as $issue) {
$files = Storage::files('evidencias_hallazgos/' . $issue->id);
//vemos si existe la carpeta (si existe es porque tiene archivos)
if ($files != NULL) {
$issues2[$j] = ['name' => $issue->name, 'description' => $issue->description, 'classification' => $issue->classification, 'recommendations' => $issue->recommendations, 'files' => $files];
$j += 1;
}
}
//ahora guardamos solo aquellos controles que tienen documentos asociados
if (!empty($issues2)) {
$control_issues[$i] = ['name' => $control->name, 'description' => $control->description, 'issues' => $issues2];
$i += 1;
}
}
if (Session::get('languaje') == 'en') {
return view('en.documentos.show', ['elements' => $control_issues, 'kind2' => $_GET['kind_issue']]);
} else {
return view('documentos.show', ['elements' => $control_issues, 'kind2' => $_GET['kind_issue']]);
}
break;
case 5:
//issues de programas de auditoría
//(audit_audit_plan_audit_program)
$audit_programs = \Ermtool\Audit_program::getProgramsFromIssues($_GET['organization_id']);
$audit_program_issues = array();
//se guardaran los programas que tienen issues que además tienen documentos
$i = 0;
foreach ($audit_programs as $audit_program) {
//obtenemos issues del programa
$issues = \Ermtool\Issue::getAuditProgramIssues($audit_program->id);
$issues2 = array();
//array donde se guardaran los issues que tienen documentos
//recorremos los issues para ver por cada uno si posee archivos
$j = 0;
foreach ($issues as $issue) {
$files = Storage::files('evidencias_hallazgos/' . $issue->id);
//vemos si existe la carpeta (si existe es porque tiene archivos)
if ($files != NULL) {
$issues2[$j] = ['name' => $issue->name, 'description' => $issue->description, 'classification' => $issue->classification, 'recommendations' => $issue->recommendations, 'files' => $files];
$j += 1;
}
}
//ahora guardamos solo aquellos controles que tienen documentos asociados
if (!empty($issues2)) {
$audit_program_issues[$i] = ['name' => $audit_program->name, 'description' => $audit_program->description, 'issues' => $issues2];
$i += 1;
}
}
if (Session::get('languaje') == 'en') {
return view('en.documentos.show', ['elements' => $audit_program_issues, 'kind2' => $_GET['kind_issue']]);
} else {
return view('documentos.show', ['elements' => $audit_program_issues, 'kind2' => $_GET['kind_issue']]);
}
break;
case 6:
//issues de auditoría
//(audit_audit_plan)
$audits = \Ermtool\Audit::getAuditsFromIssues($_GET['organization_id']);
$audit_issues = array();
//se guardaran las auditorías que tienen issues que además tienen documentos
$i = 0;
foreach ($audits as $audit) {
//obtenemos issues de la auditoría
$issues = \Ermtool\Issue::getAuditIssues($audit->id);
$issues2 = array();
//array donde se guardaran los issues que tienen documentos
//recorremos los issues para ver por cada uno si posee archivos
$j = 0;
foreach ($issues as $issue) {
$files = Storage::files('evidencias_hallazgos/' . $issue->id);
//vemos si existe la carpeta (si existe es porque tiene archivos)
if ($files != NULL) {
$issues2[$j] = ['name' => $issue->name, 'description' => $issue->description, 'classification' => $issue->classification, 'recommendations' => $issue->recommendations, 'files' => $files];
$j += 1;
}
}
//ahora guardamos solo aquellos controles que tienen documentos asociados
if (!empty($issues2)) {
$audit_issues[$i] = ['audit_plan' => $audit->audit_plan, 'name' => $audit->name, 'description' => $audit->description, 'issues' => $issues2];
$i += 1;
}
}
if (Session::get('languaje') == 'en') {
return view('en.documentos.show', ['elements' => $audit_issues, 'kind2' => $_GET['kind_issue']]);
} else {
return view('documentos.show', ['elements' => $audit_issues, 'kind2' => $_GET['kind_issue']]);
}
break;
default:
# code...
break;
}
break;
case 3:
//notas
$notes = \Ermtool\Note::getNotes($_GET['organization_id'], $_GET['audit_plan_id']);
$i = 0;
//recorremos las notas para ver cuales tienen archivos
$notes2 = array();
foreach ($notes as $note) {
//obtenemos posibles respuestas
$answers = \Ermtool\Note::find($note->id)->notes_answers;
$j = 0;
$answers2 = array();
foreach ($answers as $ans) {
$files1 = Storage::files('evidencias_resp_notas/' . $ans->id);
if ($files1 != NULL) {
//seteamos fecha
$created_at = date_format($ans['created_at'], 'd-m-Y');
$answers2[$j] = ['answer' => $ans['answer'], 'created_at' => $created_at, 'files' => $files1];
$j += 1;
}
}
$files = Storage::files('evidencias_notas/' . $note->id);
//vemos si existe la carpeta (si existe es porque tiene archivos)
if ($files != NULL) {
$notes2[$j] = ['name' => $note->name, 'description' => $note->description, 'files' => $files, 'answers' => $answers2];
$i += 1;
}
//puede ser que la respuesta tenga archivos
}
if (Session::get('languaje') == 'en') {
return view('en.documentos.show', ['elements' => $notes2, 'kind' => $_GET['kind']]);
} else {
return view('documentos.show', ['elements' => $notes2, 'kind' => $_GET['kind']]);
}
break;
case 4:
//programas
$programs = \Ermtool\Audit_program::getPrograms($_GET['organization_id'], $_GET['audit_plan_id']);
$plan = \Ermtool\Audit_plan::name($_GET['audit_plan_id']);
$i = 0;
//recorremos los programas para ver cuales tienen archivos
$programs2 = array();
foreach ($programs as $program) {
$files = Storage::files('programas_auditoria/' . $program->id);
//vemos si existe la carpeta (si existe es porque tiene archivos)
if ($files != NULL) {
$programs2[$i] = ['audit' => $program->audit, 'name' => $program->name, 'description' => $program->description, 'files' => $files];
$i += 1;
}
}
if (Session::get('languaje') == 'en') {
return view('en.documentos.show', ['elements' => $programs2, 'kind' => $_GET['kind'], 'audit_plan' => $plan]);
} else {
return view('documentos.show', ['elements' => $programs2, 'kind' => $_GET['kind'], 'audit_plan' => $plan]);
}
break;
case 5:
//pruebas
$tests = \Ermtool\Audit_test::getTests($_GET['organization_id'], $_GET['audit_plan_id']);
$plan = \Ermtool\Audit_plan::name($_GET['audit_plan_id']);
$i = 0;
//recorremos los programas para ver cuales tienen archivos
$tests2 = array();
foreach ($tests as $test) {
$files = Storage::files('pruebas_auditoria/' . $test->id);
//vemos si existe la carpeta (si existe es porque tiene archivos)
if ($files != NULL) {
$tests2[$i] = ['audit' => $test->audit, 'program' => $test->program, 'name' => $test->name, 'description' => $test->description, 'files' => $files];
$i += 1;
}
}
if (Session::get('languaje') == 'en') {
return view('en.documentos.show', ['elements' => $tests2, 'kind' => $_GET['kind'], 'audit_plan' => $plan]);
} else {
return view('documentos.show', ['elements' => $tests2, 'kind' => $_GET['kind'], 'audit_plan' => $plan]);
}
break;
default:
break;
}
}
public function getIssue($eval_id)
{
$issue = NULL;
$eval = DB::table('control_evaluation')->where('id', '=', $eval_id)->where('status', '=', 1)->select('issue_id')->first();
$evidence = getEvidences(3, $eval_id);
if ($eval) {
$issue = \Ermtool\Issue::find($eval->issue_id);
$issue = ['issue' => $issue, 'evidence' => $evidence];
}
return json_encode($issue);
}
