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