public function index()
{
$user = User::fromToken();
$votacion = VtVotacion::where('actual', '=', true)->where('user_id', $user->id)->where('year_id', $user->year_id)->first();
$aspiraciones = VtAspiracion::where('votacion_id', $votacion->id)->get();
return $aspiraciones;
}
public function getIndex()
{
$user = User::fromToken();
$votacion = VtVotacion::where('in_action', '=', true)->first();
$hayVotacion = false;
$signed = false;
$voted = false;
$rutear = false;
if ($votacion) {
$hayVotacion = true;
$signed = VtParticipante::isSigned($user->user_id, $votacion->id);
if ($signed) {
$voted = VtVoto::hasVoted($votacion->id, $signed->id);
$rutear = true;
}
$eventos = array('votaciones' => array('hay' => $hayVotacion, 'signed' => $signed, 'voted' => $voted, 'rutear' => $rutear, 'state' => 'votaciones.votar'));
return $eventos;
} else {
$eventos = array('votaciones' => array('hay' => false, 'signed' => false, 'voted' => false, 'rutear' => false, 'state' => ''));
return $eventos;
}
}
public function putSetPermisoVerResults()
{
$user = User::fromToken();
$id = Request::input('id');
$can_see_results = Request::input('can_see_results', false);
$vot = VtVotacion::where('id', $id)->update(['can_see_results' => $can_see_results]);
return 'Cambiado';
}
public function getAllinscritos()
{
$votacion = VtVotacion::where('actual', '=', true)->first();
$consulta = 'SELECT usus.persona_id, vp.id as participante_id, usus.nombres, usus.apellidos, usus.user_id, usus.username, usus.tipo from
(select p.id as persona_id, p.nombres, p.apellidos, p.user_id, u.username, ("Pr") as tipo from profesores p inner join users u on p.user_id=u.id
union
select a.id as persona_id, a.nombres, a.apellidos, a.user_id, u.username, ("Al") as tipo from alumnos a
inner join users u on a.user_id=u.id
inner join matriculas m on m.alumno_id=a.id and m.matriculado=true
)usus
inner join vt_participantes vp on vp.user_id=usus.user_id and vp.votacion_id = :votacion_id';
$participantes = DB::select(DB::raw($consulta), array('votacion_id' => $votacion->id));
return $participantes;
}
public function actualInAction($user)
{
return VtVotacion::where('actual', true)->where('user_id', $user->id)->where('in_action', true)->where('year_id', $user->year_id)->first();
}
