Subversion Repositories bacoAlunos

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

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

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

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

<%

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

    AbstractDao.getCurrentSession().beginTransaction();

    List<Object[]> turmas = DaoFactory.getCourseUnitTurmaDaoImpl().loadByCourseUnit(courseUnitId);

        /**

         *  .add(Projections.groupProperty("turma"))

         .add(Projections.groupProperty("courseUnit.importYear"))

         .add(Projections.groupProperty("courseUnit.name"))

         .add(Projections.groupProperty("courseUnit.courseName"))

         .add(Projections.groupProperty("courseUnit.courseCode"))

         .add(Projections.countDistinct("student.id"))

         .add(Projections.countDistinct("courseUnit.course.id")))

         */

%>

<table class="tablesorterfiltered">

    <thead>

        <tr>

            <th>Turma</th>

            <th>Ano</th>

            <th>Students</th>

        </tr>

    </thead>

    <tbody>

        <%

            for(Object[] cturma : turmas)

            {

                String turma = (String) cturma[0];

                String importYear = (String) cturma[1];

                String unidade = (String) cturma[2];

                String courseName = (String) cturma[3];

                String courseCode = (String) cturma[4];

                Integer students = (Integer) cturma[5];

                Long courseId = (Long) cturma[6];

        %>

            <tr>

                <td>

                    <a href="#" class="reloadAjaxRequestModal" data-href="<%=request.getContextPath()%>/user/questionarios/pedagogicoEstudante/listTurmasCourseUnits.jsp?importYear=<%=importYear%>&courseId=<%=courseId%>&turma=<%=turma%>" data-title="Unidades com a turma <%=turma%> do Curso de <%=courseName%> (<%=courseCode%>)">

                        <%=turma%>

                    </a>

                </td>

                <td><%=importYear%></td>

                <td><%=students%></td>

            </tr>

        <%

            }

        %>

    </tbody>

</table>

<%

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

%>