public function auditPrograms()
{
if (Auth::guest()) {
return view('login');
} else {
$programas = array();
$org_name = \Ermtool\Organization::getNameByAuditAuditPlan($_GET['audit_id']);
$audit_plan_name = \Ermtool\Audit_plan::getNameByAuditAuditPlan($_GET['audit_id']);
$audit_name = \Ermtool\Audit::name($_GET['audit_id']);
$programs = \Ermtool\Audit_program::getProgramsByAudit($_GET['audit_id']);
$i = 0;
//contador de planes
foreach ($programs as $program) {
//AGREGADO 17-08: Obtenemos plan de auditoría y auditoría asociados
$audit_plan = DB::table('audit_plans')->join('audit_audit_plan', 'audit_audit_plan.audit_plan_id', '=', 'audit_plans.id')->where('audit_audit_plan.id', '=', $program->audit_audit_plan_id)->select('audit_plans.name')->first();
$audit = DB::table('audits')->join('audit_audit_plan', 'audit_audit_plan.audit_id', '=', 'audits.id')->where('audit_audit_plan.id', '=', $program->audit_audit_plan_id)->select('audits.name')->first();
//damos formato a fecha de creación (se verifica si no es NULL en caso de algún error en la creación)
if ($program->created_at == NULL or $program->created_at == "0000-00-00" or $program->created_at == "") {
$fecha_creacion = NULL;
} else {
//damos formato a fecha inicial
$fecha_creacion = date('d-m-Y', strtotime($program->created_at));
}
//damos formato a fecha de actualización
if ($program->updated_at != NULL) {
//damos formato a fecha final
$fecha_act = date('d-m-Y', strtotime($program->updated_at));
} else {
$fecha_act = NULL;
}
//formato a fecha expiración
if ($program->expiration_date) {
$fecha_exp = date('d-m-Y', strtotime($program->expiration_date));
} else {
$fecha_exp = NULL;
}
$programas[$i] = ['id' => $program->id, 'name' => $program->name, 'description' => $program->description, 'created_at' => $fecha_creacion, 'updated_at' => $fecha_act, 'expiration_date' => $fecha_exp, 'audit_plan' => $audit_plan->name, 'audit' => $audit->name];
$i += 1;
}
if (Session::get('languaje') == 'en') {
return view('en.auditorias.programas', ['programs' => $programas, 'org_name' => $org_name, 'audit_plan_name' => $audit_plan_name, 'audit_name' => $audit_name, 'audit_id' => $_GET['audit_id']]);
} else {
return view('auditorias.programas', ['programs' => $programas, 'org_name' => $org_name, 'audit_plan_name' => $audit_plan_name, 'audit_name' => $audit_name, 'audit_id' => $_GET['audit_id']]);
}
}
}
