public function getObjectives($org)
{
$results = array();
//obtenemos objetivos
$objectives = \Ermtool\Objective::where('status', 0)->where('organization_id', (int) $org)->select('name', 'id')->groupBy('id')->get();
$i = 0;
foreach ($objectives as $objective) {
$results[$i] = ['id' => $objective->id, 'name' => $objective->name];
$i += 1;
}
return json_encode($results);
}
public function getObjetivos($org)
{
if (Auth::guest()) {
return view('login');
} else {
$results = array();
$objectives = \Ermtool\Objective::where('organization_id', (int) $org)->get();
$i = 0;
//contador de objetivos
foreach ($objectives as $objective) {
$results[$i] = ['name' => $objective['name'], 'id' => $objective['id']];
$i += 1;
}
return json_encode($results);
}
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function kpiEdit($id)
{
if (Auth::guest()) {
return view('login');
} else {
$obj_selected = array();
$kpi = \Ermtool\kpi::find($id);
//obtenemos todos los objetivos de la organización
$objectives = \Ermtool\Objective::where('organization_id', '=', $_GET['org_id'])->where('status', 0)->lists('name', 'id');
$org_selected = \Ermtool\Organization::name($_GET['org_id']);
$stakeholders = \Ermtool\Stakeholder::where('status', 0)->select('id', DB::raw('CONCAT(name, " ", surnames) AS full_name'))->orderBy('name')->lists('full_name', 'id');
//obtenemos los objetivos relacionados al kpi
$objs = DB::table('kpi_objective')->where('kpi_id', '=', $kpi->id)->select('objective_id')->get();
$i = 0;
foreach ($objs as $obj) {
$obj_selected[$i] = $obj->objective_id;
$i += 1;
}
if (Session::get('languaje') == 'en') {
return view('en.gestion_estrategica.editkpi', ['objectives' => $objectives, 'org_selected' => $org_selected, 'org_id' => $_GET['org_id'], 'stakeholders' => $stakeholders, 'obj_selected' => $obj_selected, 'kpi' => $kpi]);
} else {
return view('gestion_estrategica.editkpi', ['objectives' => $objectives, 'org_selected' => $org_selected, 'org_id' => $_GET['org_id'], 'stakeholders' => $stakeholders, 'obj_selected' => $obj_selected, 'kpi' => $kpi]);
}
}
}
