Blame | Last modification | View Log | RSS feed
<%@ page import="jomm.dao.impl.AbstractDao" %>
<%@ page import="org.hibernate.Query" %>
<%@ page import="pt.estgp.estgweb.domain.QuestionarioPedagogicoTipologiaRequisitada" %>
<%@ page import="pt.estgp.estgweb.domain.Student" %>
<%@ page import="pt.ipportalegre.siges.web.services.Aluno" %>
<%@ page import="java.util.List" %>
<%@ page import="pt.estgp.estgweb.domain.QuestionarioPedagogicoAlunoRequisitado" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<jsp:useBean id="UserSession" type="pt.estgp.estgweb.domain.UserSessionImpl" scope="request"/>
<%
if(UserSession.getUser().isSuperuser())
{
String id = request.getParameter("id");
AbstractDao.getCurrentSession().beginTransaction();
Query qNaoResponderam = AbstractDao.getCurrentSession().createQuery("" +
"select a from t in class " + QuestionarioPedagogicoTipologiaRequisitada.class.getName() + " " +
" join t.alunosRequisitados a " +
" join a.respostaRequisitada rR " +
" where t.id = :id and rR.resposta is null group by a.id "
);
qNaoResponderam.setLong("id",Long.parseLong(id));
List<QuestionarioPedagogicoAlunoRequisitado> alunosSemResposta = qNaoResponderam.list();
if(alunosSemResposta.size() == 0)
{
%>
<h3>Todos os Alunos Responderam</h3>
<%
}
else
{
%>
<h3><%=alunosSemResposta.size()%> Alunos sem resposta</h3>
<table class="tablesorterfiltered">
<thead>
<tr>
<th>Número</th>
<th>Nome</th>
<th>Email</th>
<th>Telemóvel</th>
<th>Turma</th>
</tr>
</thead>
<tbody>
<%
for(QuestionarioPedagogicoAlunoRequisitado aSemResposta: alunosSemResposta)
{
%>
<tr>
<td><%=aSemResposta.getAluno().getSigesCode()%></td>
<td><%=aSemResposta.getAluno().getName()%></td>
<td><%=aSemResposta.getAluno().getEmail()%></td>
<td><%=aSemResposta.getAluno().getPhonenumber()%></td>
<td><%=aSemResposta.getTipologiaRequisitada().getCdTurma()%></td>
</tr>
<%
}
}
AbstractDao.getCurrentSession().getTransaction().commit();
%>
</tbody>
</table>
<%
}
%>
Generated by GNU Enscript 1.6.5.2.