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();
%>