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

%>