public static function listStakeholders($org) { //para los casos en que sea muy difícil especificar la org, dejaremos momentáneamente la opción de NULL if ($org == NULL) { $stakeholders = \Ermtool\Stakeholder::where('status', 0)->select('id', DB::raw('CONCAT(name, " ", surnames) AS full_name'))->orderBy('name')->lists('full_name', 'id'); } else { $stakeholders = \Ermtool\Stakeholder::where('status', 0)->join('organization_stakeholder', 'organization_stakeholder.stakeholder_id', '=', 'stakeholders.id')->where('organization_stakeholder.organization_id', '=', $org)->select('stakeholders.id', DB::raw('CONCAT(name, " ", surnames) AS full_name'))->orderBy('name')->lists('full_name', 'id'); } return $stakeholders; }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { if (Auth::guest()) { return view('login'); } else { //definimos por si no hay $stakeholder = array(); $organizaciones = array(); $roles = array(); if (isset($_GET['verbloqueados'])) { $stakeholders = \Ermtool\Stakeholder::where('status', 1)->get(); //select stakeholders bloqueadas } else { $stakeholders = \Ermtool\Stakeholder::where('status', 0)->get(); //select stakeholders desbloqueadas } $i = 0; $j = 0; //contador de organizaciones relacionadas $k = 0; //contador de roles // ---recorremos todas los stakeholders para asignar formato de datos correspondientes--- // foreach ($stakeholders as $persona) { //ahora obtenemos todas las organizaciones a las que pertenece cada persona $orgs = \Ermtool\Stakeholder::find($persona['id'])->organizations; foreach ($orgs as $organization) { $organizaciones[$j] = array('stakeholder_id' => $persona['id'], 'id' => $organization['id'], 'nombre' => $organization['name']); $j += 1; } //obtenemos todos los roles a los que pertenece una persona $roles_temp = \Ermtool\Stakeholder::find($persona['id'])->roles; foreach ($roles_temp as $role) { $roles[$k] = array('stakeholder_id' => $persona['id'], 'id' => $role['id'], 'nombre' => $role['name']); $k += 1; } if ($persona['position'] == NULL) { $cargo = NULL; } else { $cargo = $persona['position']; } //damos formato a fecha creación if ($persona['created_at'] != NULL) { $fecha_creacion = date_format($persona['created_at'], "d-m-Y"); } else { $fecha_creacion = NULL; } //damos formato a fecha de actualización if ($persona['updated_at'] != NULL) { $fecha_act = date_format($persona['updated_at'], "d-m-Y"); } else { $fecha_act = NULL; } $stakeholder[$i] = array('id' => $persona['id'], 'dv' => $persona['dv'], 'nombre' => $persona['name'], 'apellidos' => $persona['surnames'], 'fecha_creacion' => $fecha_creacion, 'fecha_act' => $fecha_act, 'cargo' => $cargo, 'correo' => $persona['mail'], 'estado' => $persona['status']); $i += 1; } if (Session::get('languaje') == 'en') { return view('en.datos_maestros.stakeholders.index', ['stakeholders' => $stakeholder, 'organizaciones' => $organizaciones, 'roles' => $roles]); } else { return view('datos_maestros.stakeholders.index', ['stakeholders' => $stakeholder, 'organizaciones' => $organizaciones, 'roles' => $roles]); } } }
public function kpiEditFromObjective($id) { if (Auth::guest()) { return view('login'); } else { $kpi = \Ermtool\kpi::find($id); $stakeholders = \Ermtool\Stakeholder::where('status', 0)->select('id', DB::raw('CONCAT(name, " ", surnames) AS full_name'))->orderBy('name')->lists('full_name', 'id'); if (Session::get('languaje') == 'en') { return view('en.gestion_estrategica.editkpi2', ['stakeholders' => $stakeholders, 'kpi' => $kpi, 'obj_id' => $_GET['obj_id']]); } else { return view('gestion_estrategica.editkpi2', ['stakeholders' => $stakeholders, 'kpi' => $kpi, 'obj_id' => $_GET['obj_id']]); } } }
public function createPruebas($audit_id) { if (Auth::guest()) { return view('login'); } else { //plan de auditoría $audit_plans = \Ermtool\Audit_plan::where('status', 0)->lists('name', 'id'); $audit_programs = \Ermtool\Audit_program::lists('name', 'id'); //obtenemos lista de stakeholders $stakeholders = \Ermtool\Stakeholder::where('status', 0)->select('id', DB::raw('CONCAT(name, " ", surnames) AS full_name'))->orderBy('name')->lists('full_name', 'id'); //echo $audit_tests; if (Session::get('languaje') == 'en') { return view('en.auditorias.create_test', ['audit_plans' => $audit_plans, 'audit_programs' => $audit_programs, 'stakeholders' => $stakeholders, 'audit_id' => $audit_id]); } else { return view('auditorias.create_test', ['audit_plans' => $audit_plans, 'audit_programs' => $audit_programs, 'stakeholders' => $stakeholders, 'audit_id' => $audit_id]); } } }
/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { if (Auth::guest()) { return view('login'); } else { //obtenemos riesgo $risk = \Ermtool\Risk::find($id); if ($risk->type == 0) { $subprocesos = DB::table('subprocesses')->join('organization_subprocess', 'organization_subprocess.subprocess_id', '=', 'subprocesses.id')->where('organization_subprocess.organization_id', '=', $_GET['org'])->where('subprocesses.status', '=', 0)->lists('subprocesses.name', 'subprocesses.id'); $sub_selected = array(); $subs = DB::table('risk_subprocess')->where('risk_subprocess.risk_id', '=', $id)->select('risk_subprocess.subprocess_id')->get(); $i = 0; foreach ($subs as $sub) { $sub_selected[$i] = $sub->subprocess_id; $i += 1; } } else { if ($risk->type == 1) { $objectives = DB::table('objectives')->where('organization_id', '=', $_GET['org'])->where('status', '=', 0)->lists('name', 'id'); $obj_selected = array(); $orgs = DB::table('objective_risk')->where('objective_risk.risk_id', '=', $id)->select('objective_risk.objective_id')->get(); $i = 0; foreach ($subs as $sub) { $obj_selected[$i] = $obj->objective_id; $i += 1; } } } //categorias de riesgo $categorias = \Ermtool\Risk_category::where('status', 0)->lists('name', 'id'); //causas $causas = \Ermtool\Cause::where('status', 0)->lists('name', 'id'); //efectos $efectos = \Ermtool\Effect::where('status', 0)->lists('name', 'id'); $causes_selected = array(); $effects_selected = array(); //obtenemos causas seleccionadas $causes = DB::table('cause_risk')->where('risk_id', '=', $id)->select('cause_risk.cause_id')->get(); $i = 0; foreach ($causes as $cause) { $causes_selected[$i] = $cause->cause_id; $i += 1; } //obtenemos efectos seleccionados $effects = DB::table('effect_risk')->where('risk_id', '=', $id)->select('effect_risk.effect_id')->get(); $i = 0; foreach ($effects as $effect) { $effects_selected[$i] = $effect->effect_id; $i += 1; } //riesgos tipo $riesgos_tipo = \Ermtool\Risk::where('status', 0)->where('type2', 0)->lists('name', 'id'); //obtenemos lista de stakeholders $stakeholders = \Ermtool\Stakeholder::where('status', 0)->select('id', DB::raw('CONCAT(name, " ", surnames) AS full_name'))->orderBy('name')->lists('full_name', 'id'); if (Session::get('languaje') == 'en') { if ($risk->type == 0) { return view('en.riesgos.edit', ['risk' => $risk, 'riesgos_tipo' => $riesgos_tipo, 'causas' => $causas, 'categorias' => $categorias, 'efectos' => $efectos, 'stakeholders' => $stakeholders, 'causes_selected' => $causes_selected, 'effects_selected' => $effects_selected, 'subprocesos' => $subprocesos, 'sub_selected' => $sub_selected, 'org_id' => $_GET['org']]); } else { return view('en.riesgos.edit', ['risk' => $risk, 'riesgos_tipo' => $riesgos_tipo, 'causas' => $causas, 'categorias' => $categorias, 'efectos' => $efectos, 'stakeholders' => $stakeholders, 'causes_selected' => $causes_selected, 'effects_selected' => $effects_selected, 'objetivos' => $objetivos, 'obj_selected' => $obj_selected, 'org_id' => $_GET['org']]); } } else { if ($risk->type == 0) { return view('riesgos.edit', ['risk' => $risk, 'riesgos_tipo' => $riesgos_tipo, 'causas' => $causas, 'categorias' => $categorias, 'efectos' => $efectos, 'stakeholders' => $stakeholders, 'causes_selected' => $causes_selected, 'effects_selected' => $effects_selected, 'subprocesos' => $subprocesos, 'sub_selected' => $sub_selected, 'org_id' => $_GET['org']]); } else { return view('riesgos.edit', ['risk' => $risk, 'riesgos_tipo' => $riesgos_tipo, 'causas' => $causas, 'categorias' => $categorias, 'efectos' => $efectos, 'stakeholders' => $stakeholders, 'causes_selected' => $causes_selected, 'effects_selected' => $effects_selected, 'objetivos' => $objetivos, 'obj_selected' => $obj_selected, 'org_id' => $_GET['org']]); } } } }