public function enviar(Request $request)
{
if (Auth::guest()) {
return view('login');
} else {
if (isset($_GET['aplicar'])) {
//$tipo = Request::input('destinatarios');
if ($request['destinatarios'] == 0) {
//seleccionamos lista de stakeholders
$dest = \Ermtool\Stakeholder::select('id', DB::raw('CONCAT(name, " ", surnames) AS full_name'))->orderBy('name')->lists('full_name', 'id');
} else {
if ($request['destinatarios'] == 1) {
$dest = \Ermtool\Organization::lists('name', 'id');
} else {
if ($request['destinatarios'] == 2) {
$dest = \Ermtool\Role::lists('name', 'id');
}
}
}
$encuesta = \Ermtool\Poll::find($request['encuesta']);
//obtenemos preguntas
$preguntas = DB::table('questions')->where('poll_id', '=', $encuesta['id'])->get();
$answers = array();
//almacenaremos aquí respuestas posibles para las preguntas
$i = 0;
//contador de respuestas
foreach ($preguntas as $pregunta) {
if ($pregunta->answers_type != 0) {
$posible_answers = DB::table('posible_answers')->where('question_id', $pregunta->id)->get();
foreach ($posible_answers as $posible_answer) {
$answers[$i] = array('id' => $posible_answer->id, 'respuesta' => $posible_answer->answer, 'question_id' => $posible_answer->question_id);
$i += 1;
}
}
}
if (Session::get('languaje') == 'en') {
return view('en.identificacion_eventos_riesgos.enviarencuesta2', ['tipo' => $request['destinatarios'], 'dest' => $dest, 'encuesta' => $encuesta, 'preguntas' => $preguntas, 'respuestas' => $answers, 'mensaje' => $this->mensaje($encuesta['id'])]);
} else {
return view('identificacion_eventos_riesgos.enviarencuesta2', ['tipo' => $request['destinatarios'], 'dest' => $dest, 'encuesta' => $encuesta, 'preguntas' => $preguntas, 'respuestas' => $answers, 'mensaje' => $this->mensaje($encuesta['id'])]);
}
} else {
if (isset($_GET['volver'])) {
$polls = \Ermtool\Poll::lists('name', 'id');
if (Session::get('languaje') == 'en') {
return view('en.identificacion_eventos_riesgos.enviarencuesta', ['polls' => $polls]);
} else {
return view('identificacion_eventos_riesgos.enviarencuesta', ['polls' => $polls]);
}
} else {
$polls = \Ermtool\Poll::lists('name', 'id');
if (Session::get('languaje') == 'en') {
return view('en.identificacion_eventos_riesgos.enviarencuesta', ['polls' => $polls]);
} else {
return view('identificacion_eventos_riesgos.enviarencuesta', ['polls' => $polls]);
}
}
}
}
}
/**
* 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 {
$risks_selected = array();
//array de riesgos seleccionados previamente
$control = \Ermtool\Control::find($id);
$stakeholders = \Ermtool\Stakeholder::select('id', DB::raw('CONCAT(name, " ", surnames) AS full_name'))->orderBy('name')->lists('full_name', 'id');
//seleccionamos riesgos de proceso u objetivo que fueron seleccionados previamente (según corresponda)
if ($control->type2 == 0) {
//seleccionamos riesgos de proceso seleccionados previamente
$risks = DB::table('control_risk_subprocess')->where('control_risk_subprocess.control_id', '=', $control->id)->select('risk_subprocess_id as id')->get();
} else {
if ($control->type2 == 1) {
//seleccionamos riesgo de negocio
$risks = DB::table('control_objective_risk')->where('control_objective_risk.control_id', '=', $control->id)->select('objective_risk_id as id')->get();
}
}
$i = 0;
foreach ($risks as $risk) {
$risks_selected[$i] = $risk->id;
$i += 1;
}
if (Session::get('languaje') == 'en') {
return view('en.controles.edit', ['control' => $control, 'stakeholders' => $stakeholders, 'risks_selected' => json_encode($risks_selected)]);
} else {
return view('controles.edit', ['control' => $control, 'stakeholders' => $stakeholders, 'risks_selected' => json_encode($risks_selected)]);
}
}
}
public function enviar($id)
{
if (Auth::guest()) {
return view('login');
} else {
//Se debe inicializar en caso de que no haya sido ingresado ningún stakeholder aun
//$stakeholders = \Ermtool\Stakeholder::lists('CONCAT(nombre, " ", apellidos)','id');
$stakeholders = \Ermtool\Stakeholder::select('id', DB::raw('CONCAT(name, " ", surnames) AS full_name'))->orderBy('name')->lists('full_name', 'id');
if (Session::get('languaje') == 'en') {
return view('en.evaluacion.enviar', ['encuesta_id' => $id, 'stakeholders' => $stakeholders, 'mensaje' => $this->mensaje($id)]);
} else {
return view('evaluacion.enviar', ['encuesta_id' => $id, 'stakeholders' => $stakeholders, 'mensaje' => $this->mensaje($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 {
$riesgos_proc = array();
$riesgos_neg = array();
$audits_selected = array();
$stakeholder_team = array();
//obtenemos lista de stakeholders
$stakeholders = \Ermtool\Stakeholder::select('id', DB::raw('CONCAT(name, " ", surnames) AS full_name'))->orderBy('name')->lists('full_name', 'id');
//obtenemos lista de organizaciones
$organizations = \Ermtool\Organization::where('status', 0)->lists('name', 'id');
//obtenemos universo de auditorias
$audits = \Ermtool\Audit::lists('name', 'id');
//obtenemos universo de auditorías seleccionadas
$auditorias = DB::table('audit_audit_plan')->where('audit_plan_id', '=', $id)->select('audit_audit_plan.audit_id as id')->get();
//cada una de las auditorías pertenecientes al plan
$i = 0;
foreach ($auditorias as $audit) {
$audits_selected[$i] = $audit->id;
$i += 1;
}
//obtenemos riesgos de procesos que ya fueron seleccionados
$riesgos_selected = DB::table('audit_plan_risk')->join('risk_subprocess', 'risk_subprocess.id', '=', 'audit_plan_risk.risk_subprocess_id')->join('risks', 'risks.id', '=', 'risk_subprocess.risk_id')->where('audit_plan_risk.audit_plan_id', '=', $id)->whereNotNull('audit_plan_risk.risk_subprocess_id')->select('risk_subprocess.id')->get();
$i = 0;
foreach ($riesgos_selected as $risk) {
$riesgos_proc[$i] = $risk->id;
$i += 1;
}
//obtenemos riesgos de negocio que ya fueron seleccionados
$riesgos_selected = DB::table('audit_plan_risk')->join('objective_risk', 'objective_risk.id', '=', 'audit_plan_risk.objective_risk_id')->join('risks', 'risks.id', '=', 'objective_risk.risk_id')->where('audit_plan_risk.audit_plan_id', '=', $id)->whereNotNull('audit_plan_risk.objective_risk_id')->select('objective_risk.id')->get();
$i = 0;
foreach ($riesgos_selected as $risk) {
$riesgos_neg[$i] = $risk->id;
$i += 1;
}
//obtenemos stakeholder responsable
$stakeholder1 = DB::table('audit_plan_stakeholder')->where('audit_plan_id', '=', $id)->where('role', '=', 0)->select('stakeholder_id')->first();
//obtenemos equipo de auditores
$stakeholders2 = DB::table('audit_plan_stakeholder')->where('audit_plan_id', '=', $id)->where('role', '=', 1)->select('stakeholder_id')->get();
$i = 0;
foreach ($stakeholders2 as $stakeholder) {
$stakeholder_team[$i] = $stakeholder->stakeholder_id;
$i += 1;
}
//enviamos id de org seleccionada
$idorg = $id;
$audit_plan = \Ermtool\Audit_plan::find($id);
if (Session::get('languaje') == 'en') {
return view('en.auditorias.edit', ['stakeholders' => $stakeholders, 'organizations' => $organizations, 'audits' => $audits, 'riesgos_neg' => json_encode($riesgos_neg), 'riesgos_proc' => json_encode($riesgos_proc), 'audits_selected' => json_encode($audits_selected), 'stakeholder' => $stakeholder1, 'stakeholder_team' => json_encode($stakeholder_team), 'id' => $idorg, 'audit_plan' => $audit_plan]);
} else {
return view('auditorias.edit', ['stakeholders' => $stakeholders, 'organizations' => $organizations, 'audits' => $audits, 'riesgos_neg' => json_encode($riesgos_neg), 'riesgos_proc' => json_encode($riesgos_proc), 'audits_selected' => json_encode($audits_selected), 'stakeholder' => $stakeholder1, 'stakeholder_team' => json_encode($stakeholder_team), 'id' => $idorg, 'audit_plan' => $audit_plan]);
}
}
}
