Subversion Repositories bacoAlunos

<%@ page import="jomm.dao.impl.AbstractDao" %>

<%@ page import="org.hibernate.Criteria" %>

<%@ page import="org.hibernate.criterion.Order" %>

<%@ page import="org.hibernate.criterion.Projections" %>

<%@ page import="pt.estgp.estgweb.domain.Course" %>

<%@ page import="pt.estgp.estgweb.domain.CourseUnit" %>

<%@ page import="pt.estgp.estgweb.domain.TeacherImpl" %>

<%@ page import="pt.estgp.estgweb.domain.dao.DaoFactory" %>

<%@ page import="static org.hibernate.criterion.Restrictions.eq" %>

<%@ page import="java.util.List" %>

<%@ 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" %>

<%@ page contentType="text/html;charset=UTF-8" language="java" %>

<jsp:useBean id="UserSession" type="pt.estgp.estgweb.domain.UserSessionImpl" scope="request"/>

<%

    Long courseId = Long.parseLong(request.getParameter("courseId"));

    String importYear = request.getParameter("importYear");

    AbstractDao.getCurrentSession().beginTransaction();

    TeacherImpl tImpl = (TeacherImpl) DaoFactory.getTeacherDaoImpl().get(UserSession.getUser().getId());

    Course courseImpl = DaoFactory.getCourseDaoImpl().get(courseId);

    request.setAttribute("course",courseImpl);

%>

<div class="panel panel-default">

    <div class="panel-heading"><span class="glyphicon glyphicon-wrench"></span> ${course.code} - <bean:message key="course.${course.degree}"/> - ${course.name}</div>

    <div class="panel-body">

        <h2>DTP</h2>

        <table class="tablesorter tablesorterfiltered">

            <thead>

            <tr>

                <th>Cod.</th>

                <th class="filter-name filter-select">Sem.</th>

                <th>Nome</th>

                <th>Sums</th>

                <th>Sums Pre</th>

                <th>Sums Falt</th>

                <th>Plan</th>

                <th class="filter-name filter-select">Ficha</th>

                <th>Aval.Enu</th>

                <th>Aval.Paut</th>

                <th class="filter-name filter-select">Relat.</th>

                <th class="filter-name filter-select">Pedag.</th>

                <th class="filter-name filter-select">Detalhes</th>

            </tr>

            </thead>

            <tbody>

            <%

                Criteria c = AbstractDao.getCurrentSession().createCriteria(CourseUnit.class)

                .setProjection(Projections.distinct(Projections.property("id")))

                .createAlias("course", "c")

                .add(eq("importYear", importYear))

                .add(eq("c.id", courseId));

                c.addOrder(Order.asc("name"));

                List<Long> courseUnits = c.list();

                for(Long unit: courseUnits)

                {

                        Long unitId =  unit;

                        CourseUnit cu = DaoFactory.getCourseUnitDaoImpl().load(unitId);

                        request.setAttribute("cu",cu);

                    %>

                    <tr>

                        <td>${cu.code}</td>

                        <td>${cu.semestre}</td>

                        <td><html:link target="_blank" action="/user/startLoadCourseUnitFromHome?id=${cu.id}"> ${cu.name}</html:link></td>

                        <td>${cu.statdtpSumaries}</td>

                        <td>${cu.statdtpSumariesPrelancados}</td>

                        <td>${cu.statdtpSumariesMissing}</td>

                        <td>${cu.statdtpPlaneamentoFiles}</td>

                        <td><bean:message key="yes.no.${cu.statdtpFichaCurricularValid}"/></td>

                        <td>${cu.statdtpAvaliacaoEnunciadosFiles}</td>

                        <td>${cu.statdtpAvaliacaoPautasFiles}</td>

                        <td>${cu.statdtpEvaluationReportState}</td>

                        <td>${cu.statdtpInqueritoPedagogicoFiles}</td>

                        <td><button class="btn btn-default" data-href="<%=request.getContextPath()%>/user/courseunits/statsAjax.jsp?courseUnitId=${cu.id}" data-title="Estatisticas da Unidade ${cu.name} (${cu.code})" data-toggle="modal" data-target="#modalAjaxRequest"><span class="glyphicon glyphicon-zoom-in"/></button> </td>

                    </tr>

                    <%

                }

                %>

            </tbody>

        </table>

        <h2>Tabela de Aproveitamento baseada nos Relatorios de Unidades</h2>

        <table class="tablesorter tablesorterfiltered">

            <thead>

                <tr>

                    <th>Cod.</th>

                    <th class="filter-name filter-select">Sem.</th>

                    <th>Nome</th>

                    <td> Estado </td>

                    <td> Insc. </td>

                    <td> s/elem </td>

                    <td> aprov. freq. </td>

                    <td> aprov. norm. </td>

                    <td> aprov. recu. </td>

                    <td> aprov. espe. </td>

                    <td> aprov. total </td>

                    <td> 10-13 </td>

                    <td> 14-16 </td>

                    <td> 17-20 </td>

                </tr>

            </thead>

            <tbody>

<%

    for(Long unit: courseUnits)

    {

        Long unitId =  unit;

        CourseUnit cu = DaoFactory.getCourseUnitDaoImpl().load(unitId);

        request.setAttribute("cu",cu);

    %>

        <tr>

        <%

        if(cu.getCourseUnitEvaluation() != null)

        {

                String estado;

                if(cu.getCourseUnitEvaluation().isClosed())

                {

                    estado = "COMPLETO";

                }else if(cu.getCourseUnitEvaluation().isTeacherComplete())

                {

                    estado = "ENTREGUE";

                }else

                {

                    estado = "NÃO TERMINADO";

                }

                %>

                <td> ${cu.code} </td>

                <td> ${cu.semestre} </td>

                <%--<td><html:link target="_blank" action="/user/startLoadCourseUnitFromHome?id=${cu.id}"> ${cu.name}</html:link></td>--%>

                <td><a href="#cu${cu.id}"> ${cu.name}</a></td>

                <td> <%=estado%> </td>

                <td> ${cu.courseUnitEvaluation.numAlunosInscritos} </td>

                <td> ${cu.courseUnitEvaluation.numAlunosSemElementosAvaliacao} </td>

                <td> ${cu.courseUnitEvaluation.numAlunosAprovFrequencia} </td>

                <td> ${cu.courseUnitEvaluation.numAlunosAprovNormal} </td>

                <td> ${cu.courseUnitEvaluation.numAlunosAprovRecurso} </td>

                <td> ${cu.courseUnitEvaluation.numAlunosAprovEspecial} </td>

                <td> ${cu.courseUnitEvaluation.numAlunosAprovTotal} </td>

                <td> ${cu.courseUnitEvaluation.numAlunosAprov1013} </td>

                <td> ${cu.courseUnitEvaluation.numAlunosAprov1416} </td>

                <td> ${cu.courseUnitEvaluation.numAlunosAprov1720} </td>

                <%

        }

        else

        {

                %>

                    <td> ${cu.code} </td>

                    <td> ${cu.semestre} </td>

                    <td> ${cu.name} </td>

                    <td class="danger" colspan="11">INEXISTENTE</td>

                <%

        }

        %>

        </tr>

        <%

    }

%>

           </tbody>

        </table>

        <h2>Relatórios das Unidades</h2>

        <%

            for(Long unit: courseUnits)

            {

                Long unitId =  unit;

                CourseUnit cu = DaoFactory.getCourseUnitDaoImpl().load(unitId);

                request.setAttribute("cu",cu);

         %>

                <a name="cu${cu.id}"> </a>

        <div class="panel panel-info">

            <div class="panel-heading">${cu.name} (${cu.semestre})</div>

            <div class="panel-body">

                <%

                if(cu.getCourseUnitEvaluation() != null)

                {

                    String estado;

                    if(cu.getCourseUnitEvaluation().isClosed())

                    {

                        estado = "COMPLETO";

                    }

                    else if(cu.getCourseUnitEvaluation().isTeacherComplete())

                    {

                        estado = "ENTREGUE";

                    }

                    else

                    {

                        estado = "NÃO TERMINADO";

                    }

                    %>

                    <p>Estado: <%=estado%></p>

                    <h4>Apreciação dos resultados quantitativos obtidos pelos estudantes</h4>

                    <pre>

                        ${cu.courseUnitEvaluation.qualApreciacaoQuantitivos}

                    </pre>

                    <h4>Apreciação do funcionamento da UC

                        (Condições de funcionamento da UC; problemas detetados; identificação de práticas pedagógicas de mérito ou deficientes; etc.)	</h4>

                    <pre>

                        ${cu.courseUnitEvaluation.qualApreciacaoUC}

                    </pre>

                    <h4>Apreciação do cumprimento do programa da UC

                        (Adequação das metodologias de ensino/aprendizagem utilizadas; competências efetivamente adquiridas e cumprimento dos conteúdos planificados)	</h4>

                    <pre>

                        ${cu.courseUnitEvaluation.qualApreciacaoCumprimentoPrograma}

                    </pre>

                    <h4>Conclusões

                        (Pontos fortes e fracos; sugestões de melhoria e respetivo plano de ação para a sua concretização)	</h4>

                    <pre>

                        ${cu.courseUnitEvaluation.qualConclusoes}

                    </pre>

                    <%

                }

                else

                {

                    %>

                    <p>Estado: INEXISTENTE</p>

                    <%

                }

                %>

            </div>

        </div>

                <%

            }

         %>

    </div>

</div>

<%

    AbstractDao.getCurrentSession().getTransaction().commit();

%>