Subversion Repositories bacoAlunos

<%@ page import="jomm.dao.impl.AbstractDao" %>
<%@ page import="org.hibernate.Query" %>
<%@ page import="pt.estgp.estgweb.domain.Questionario" %>
<%@ page import="pt.estgp.estgweb.domain.QuestionarioImpl" %>
<%@ page import="pt.estgp.estgweb.domain.QuestionarioPedagogicoCursoAfeto" %>
<%@ page import="pt.estgp.estgweb.domain.QuestionarioPedagogicoUnidadeCurricularAfeta" %>
<%@ page import="pt.estgp.estgweb.domain.dao.DaoFactory" %>
<%@ page import="java.net.URLEncoder" %>
<%@ page import="java.util.List" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib uri="/WEB-INF/tlds/struts-html.tld" prefix="html" %>
<%@ taglib uri="/WEB-INF/tlds/struts-nested.tld" prefix="nested" %>
<%@ taglib uri="/WEB-INF/tlds/struts-logic.tld" prefix="logic" %>
<%@ taglib uri="/WEB-INF/tlds/struts-bean.tld" prefix="bean" %>
<%@ taglib uri="/WEB-INF/tlds/struts-tiles.tld" prefix="tiles" %>
<%@ taglib uri="/WEB-INF/tlds/baco.tld" prefix="baco" %>
<%@ taglib uri="/WEB-INF/tlds/jomm.tld" prefix="jomm" %>
<jsp:useBean id="UserSession" type="pt.estgp.estgweb.domain.UserSessionImpl" scope="request"/>

<%
    String cursoAfetoId = request.getParameter("cursoAfetoId");


    AbstractDao.getCurrentSession().beginTransaction();

    QuestionarioPedagogicoCursoAfeto cursoAfeto = DaoFactory.getQuestionarioPedagogicoCursoAfetoDaoImpl().load(Long.parseLong(cursoAfetoId));
    Questionario questionarioV = cursoAfeto.getQuestionario();

    QuestionarioImpl questionario = (QuestionarioImpl) DaoFactory.getQuestionarioDaoImpl().narrow(questionarioV);
    questionario.initClearances(UserSession,true);
    request.setAttribute("Questionario",questionario);

    if(!questionario.isClear(UserSession,QuestionarioImpl.QuestionarioClearancesOperation.QUESTIONARIO_SEE_DASHBOARD.name()))
    {
        return; //NAO PODE VER O PAINEL
    }
    else
    {
        Query q = AbstractDao.getCurrentSession().createQuery(
                "select " +
                        " u.codigoUnidade " +
                        ",u.nome " +
                        ",t.cdDocente " +
                        ",t.nomeDocente " +
                        ",t.dsTipologia " +
                        ",t.cdTurma " +
                        ",sum (case when u.usar = true AND rR.resposta is null then 1 else 0 end) AS porResponder " +
                        ",sum (case when u.usar = true AND rR.resposta is null then 0 else 1 end) AS respostasObtidas " +
                        ",count(distinct a.aluno)" +
                        ",u.id" +
                        " from u in class " + QuestionarioPedagogicoUnidadeCurricularAfeta.class.getName() + " " +
                        " join u.cursoAfeto c " +
                        " join u.tipologiasRequisitadas t " +
                        " join t.alunosRequisitados a " +
                        " join a.respostaRequisitada rR " +
                        " left join rR.resposta r " +

                        " where c.id = :id group by t.id order by u.nome asc");
        q.setLong("id",cursoAfeto.getId());

        List<Object[]> tipologias = q.list();
%>

<div class="col-sm-12">
    <table class="tablesorterfiltered">
        <thead>
            <th>Código</th>
            <th>Unidade</th>
            <th>Código Docente</th>
            <th class="filter-name filter-select">Docente</th>
            <th>Tipologia</th>
            <th>Turma</th>
            <th>Alunos com Respos. %</th>
            <th>Alunos com Respos.</th>
            <th>Alunos</th>
            <th></th>
        </thead>
        <tbody>
    <%

        for(Object[] tipologia: tipologias)
        {
            if(((Long)tipologia[8]).longValue() > 0)
            {
    %>
        <tr>
            <td><%=tipologia[0]%></td>
            <td><%=tipologia[1]%></td>
            <td><%=tipologia[2]%></td>
            <td><%=tipologia[3]%></td>
            <td><%=tipologia[4]%></td>
            <td><%=tipologia[5]%></td>
            <td>
                <%
                    int percentage = (int) (100.0 * ( ((float)((Long)tipologia[7]).longValue()/((float)((Long)tipologia[8]).longValue()))));
                    String percentageColor = "danger";
                    if(percentage < 20)
                        percentageColor = "danger";
                    else if(percentage < 40)
                        percentageColor = "warning";
                    else if(percentage < 60)
                        percentageColor = "info";
                    else
                        percentageColor = "success";
                %>
                <div class="progress">
                    <div class="progress-bar progress-bar-<%=percentageColor%>" role="progressbar" aria-valuenow="<%=percentage%>"
                         aria-valuemin="0" aria-valuemax="100" style="width:<%=percentage%>%">
                        <%=percentage%>%
                    </div>
                </div>

            </td>
            <td><label class="label label-<%=percentageColor%>" style="font-size: 1em"><%=tipologia[7]%></label></td>
            <td><label class="label label-info" style="font-size: 1em"><%=tipologia[8]%></label></td>
            <td>
                <%
                    Long unidadeId = (Long) tipologia[9];
                    request.setAttribute("unidadeId",unidadeId);
                %>
                <%
                    String nomeCursoEncoded = URLEncoder.encode(tipologia[1] + "(" + tipologia[0] + ")", "ISO-8859-1");
                    request.setAttribute("nomeUnidadeEncoded",nomeCursoEncoded);
                %>
                <html:link styleClass="btn btn-default" action="/user/startQuestionariosPaeMessagePedagogico.do?questionarioId=${Questionario.id}&formDescription=Mensagem para os alunos: ${nomeUnidadeEncoded}&targetDispatch=sendEmailQuestionarioUnidadeAfeta&cursoAfetoOrUnidadeAfetaOrQuestionarioAfetoId=${unidadeId}">
                    <span class="glyphicon glyphicon-envelope"> </span>
                </html:link>
            </td>
        </tr>
    <%
            }
        }
    %>
        </tbody>
    </table>

</div>
<%
        AbstractDao.getCurrentSession().getTransaction().commit();
    }//FIM DE PAINEL CLEARED
%>