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