Subversion Repositories bacoAlunos

<%@ page import="jomm.dao.impl.AbstractDao" %>
<%@ page import="pt.estgp.estgweb.Globals" %>
<%@ page import="pt.estgp.estgweb.domain.Student" %>
<%@ page import="pt.estgp.estgweb.domain.dao.DaoFactory" %>
<%@ page import="java.util.ArrayList" %>
<%@ page import="java.util.List" %>
<%@ page import="org.hibernate.Criteria" %>
<%@ page import="static org.hibernate.criterion.Restrictions.eq" %>
<%@ page import="org.hibernate.criterion.Criterion" %>
<%@ page import="static org.hibernate.criterion.Restrictions.eq" %>
<%@ page import="static org.hibernate.criterion.Restrictions.or" %>
<%@ page import="static org.hibernate.criterion.Restrictions.*" %>
<%@ page import="org.hibernate.criterion.Order" %>
<%@ page import="org.hibernate.criterion.Projections" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib uri="/WEB-INF/baco.tld" prefix="baco" %>
<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" %>
<%@ taglib uri="/WEB-INF/struts-nested.tld" prefix="nested" %>
<%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic" %>
<%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %>
<%@ taglib uri="/WEB-INF/struts-tiles.tld" prefix="tiles" %>
<jsp:useBean id="UserSession" type="pt.estgp.estgweb.domain.UserSessionImpl" scope="request"/>

<div class="panel panel-default">
    <div class="panel-heading">
        Listagem de alunos das comissões de curso
    </div>
    <div class="panel-body">

<%
    UserSession.getUser().getRolesList();
    List<String> comissionsRoles = new ArrayList<String>();
    for(String role: UserSession.getUser().getRolesList())
    {
        if(role.startsWith(Globals.COURSE_COMMISSION_PROGRAMS_ROLES_PREFIX))
            comissionsRoles.add(role);
    }
    if(comissionsRoles.size() == 0)
    {
%>
    <div class="alert alert-warning">
        Lamentamos mas não têm qualquer comissão de curso associada
    </div>
<%
    }
    else
    {
    AbstractDao.getCurrentSession().beginTransaction();

    for(String roleCourse: comissionsRoles)
    {

        request.setAttribute("roleCourse",roleCourse);

    Criteria c = AbstractDao.getCurrentSession().createCriteria(Student.class)
            .setProjection(Projections.projectionList()
                    .add(Projections.groupProperty("id"))
                    .add(Projections.countDistinct("su.id"))
                    .add(Projections.property("course.name"))
                    .add(Projections.property("course.id"))
                    .add(Projections.property("course.code")))
            .createAlias("subscribedUnits", "su")
            .createAlias("su.course", "course")
            .add(eq("su.importYear", "201516"))
            .add(eq("course.validationRole", roleCourse))
           ;
    c.addOrder(Order.asc("name"));
    List<Object[]> students = c.list();
    if(students.size() == 0)
    {
        %>
            <h2><bean:message key="user.role.${roleCourse}"/> </h2>
            <div class="alert alert-info alert-small">
               Não foram encontrados <%=students.size()%> alunos, inscritos no ano ${UserSession.nowConfiguration.interfaceImportYear}
            </div>
        <%
    }
    else
    {
    //
    // List<Student> students = DaoFactory.getStudentDaoImpl().loadFromCoursesWithValidationRoles(comissionsRoles,UserSession.getNowConfiguration().getInterfaceImportYear());
    %>
        <h2><bean:message key="user.role.${roleCourse}"/></h2>
        <div class="alert alert-info alert-small">
            Foram encontrados <%=students.size()%> alunos, inscritos no ano ${UserSession.nowConfiguration.interfaceImportYear}
        </div>

        <table class="tablesorterfiltered">
            <thead>
                <tr>
                    <th>Número</th>
                    <th>Nome</th>
                    <th>Email</th>
                    <th>Telefone</th>
                    <th class="filter-name filter-select">Situação de Propinas</th>
                    <th>Cadeiras Inscrito em ${UserSession.nowConfiguration.interfaceImportYear}</th>
                    <th>Notas</th>
                </tr>
            </thead>
            <tbody>
            <%
                for(Object[] student: students)
                { 
                    Long studentId = (Long) student[0];
                    Integer cadeirasInscrito = (Integer) student[1];
                    String courseName = (String) student[2];
                    Long courseId = (Long) student[3];
                    String courseCode = (String) student[4];
                    Student s = DaoFactory.getStudentDaoImpl().load(studentId);
                    request.setAttribute("student",s);
            %>
                <tr>
                    <td>${student.sigesCode}</td>
                    <td>${student.name}</td>
                    <td>${student.email}</td>
                    <td>${student.phonenumber}</td>
                    <td><bean:message key="yes.no.${student.propinasEmDia}"/></td>
                    <td>
                        <a class="btn btn-default" href="#" data-href="<%=request.getContextPath()%>/public/profile/profileHomeAjax.jsp?userId=${student.id}" data-title="Notas do aluno ${student.name} (${student.sigesCode})" data-toggle="modal" data-target="#modalAjaxRequest">
                            <%=cadeirasInscrito%>
                        </a>
                    <td>
                        <a class="btn btn-default" href="#" data-href="<%=request.getContextPath()%>/public/profile/profileGradesAjax.jsp?userId=${student.id}" data-title="Notas do aluno ${student.name} (${student.sigesCode})" data-toggle="modal" data-target="#modalAjaxRequest">
                            Notas
                        </a>
                    </td>

                </tr>
            <%
                }
            %>
            </tbody>
        </table>

<%
            }
        }
        AbstractDao.getCurrentSession().getTransaction().commit();
    }
%>

    </div>
</div>