Subversion Repositories bacoAlunos

package pt.estgp.estgweb.domain.dao.impl;

import org.apache.log4j.Logger;

import org.hibernate.Criteria;

import org.hibernate.Query;

import org.hibernate.criterion.Criterion;

import org.hibernate.criterion.Order;

import org.hibernate.criterion.Projections;

import org.hibernate.sql.JoinFragment;

import pt.estgp.estgweb.Globals;

import pt.estgp.estgweb.domain.*;

import pt.estgp.estgweb.domain.dao.DaoFactory;

import pt.estgp.estgweb.domain.dao.DaoUtils;

import pt.estgp.estgweb.services.common.SearchTypeEnum;

import pt.estgp.estgweb.utils.DatesUtils;

import java.util.ArrayList;

import java.util.List;

import static org.hibernate.criterion.Restrictions.*;

/**

 * @author Jorge Machado

 * @date 28/Fev/2008

 * @time 2:51:06

 * @see pt.estgp.estgweb.domain.dao.impl

 */

public class CourseUnitDaoImpl extends CourseUnitDao

{

    private static final 1.5.0/docs/api/java/util/logging/Logger.html">Logger logger = 1.5.0/docs/api/java/util/logging/Logger.html">Logger.getLogger(CourseUnitDaoImpl.class);

    private CourseUnitDaoImpl()

    {

    }

    public static CourseUnitDaoImpl getInstance()

    {

        if (myInstance == null)

            myInstance = new CourseUnitDaoImpl();

        return (CourseUnitDaoImpl) myInstance;

    }

    public List<CourseUnit> loadBySigesCode(1.5.0/docs/api/java/lang/String.html">String sigesCode)

    {

        return createCriteria().add(eq("code", sigesCode)).list();

    }

    public List<CourseUnit> loadByCourse(long course, 1.5.0/docs/api/java/lang/String.html">String importYear)

    {

        return createCriteria().add(eq("importYear", importYear)).add(eq("course.id", course)).list();

    }

    public List<CourseUnit> loadByCourseTurma(long courseId, 1.5.0/docs/api/java/lang/String.html">String importYear, 1.5.0/docs/api/java/lang/String.html">String turma) {

        5+0%2Fdocs%2Fapi+List">List o =  createCriteria()

                .setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY)

                .createAlias("turmas", "turma")

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

                .add(eq("course.id", courseId))

                .add(eq("turma.turma", turma))

                .list();

        return o;

    }

    public List<CourseUnit> load(1.5.0/docs/api/java/lang/String.html">String importYear, 1.5.0/docs/api/java/lang/String.html">String semestre)

    {

        return createCriteria().add(eq("importYear", importYear)).add(eq("semestre", semestre)).list();

    }

    public List<Long> loadByYearInstitutionCode(1.5.0/docs/api/java/lang/String.html">String importYear, int institutionCode)

    {

        return createCriteria()

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

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

                .add(eq("institutionCode", institutionCode+""))

                .list();

    }

    public List<CourseUnit> loadYear(1.5.0/docs/api/java/lang/String.html">String importYear)

    {

        return createCriteria().add(eq("importYear", importYear)).list();

    }

    public List<Long> loadIds(1.5.0/docs/api/java/lang/String.html">String importYear, 1.5.0/docs/api/java/lang/String.html">String semestre)

    {

        if(semestre == null || semestre.trim().length() == 0)

            return loadIds(importYear);

        1.5.0/docs/api/javax/management/Query.html">Query q = createQuery("select c.id from c in class " + CourseUnit.class.getName() + " where c.importYear = ? and c.semestre = ?");

        q.setString(0, importYear);

        q.setString(1, semestre);

        return q.list();

    }

    public List<Long> loadIds(1.5.0/docs/api/java/lang/String.html">String importYear)

    {

        1.5.0/docs/api/javax/management/Query.html">Query q = createQuery("select c.id from c in class " + CourseUnit.class.getName() + " where c.importYear = ?");

        q.setString(0, importYear);

        //q.setString(1, semestre);

        return q.list();

    }

    public List<CourseUnit> loadSubscribedImportYearUnits(long studentId, 1.5.0/docs/api/java/lang/String.html">String importYear)

    {

        return createCriteria()

                .createAlias("students", "st")

                .add(eq("st.id", studentId))

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

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

                                .list();

    }

    public List<CourseUnit> loadSubscribedImportYearSemestreUnits(long studentId, 1.5.0/docs/api/java/lang/String.html">String importYear, 1.5.0/docs/api/java/lang/String.html">String semestre)

    {

        Criteria c  =createCriteria()

                                .createAlias("students", "st")

                                .add(eq("st.id", studentId))

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

        if(semestre != null)

            c.add(eq("semestre", semestre));

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

    }

    public List<CourseUnit> loadSubscribedOtherImportYearUnits(long studentId, 1.5.0/docs/api/java/lang/String.html">String importYear)

    {

        return createCriteria().add(not(eq("importYear", importYear)))

                .createAlias("students", "st")

                .add(eq("st.id", studentId)).addOrder(Order.asc("name")).list();

    }

    public List<CourseUnitImpl> loadTeachedImportYearUnits(long teacherId, 1.5.0/docs/api/java/lang/String.html">String importYear)

    {

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

                .createAlias("teachers", "st")

                .add(eq("st.id", teacherId)).addOrder(Order.asc("importYear")).addOrder(Order.asc("name")).list();

    }

    public List<CourseUnitImpl> loadResponsableImportYearUnits(long teacherId, 1.5.0/docs/api/java/lang/String.html">String importYear)

    {

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

                .add(eq("responsableTeacher.id", teacherId)).addOrder(Order.asc("importYear")).addOrder(Order.asc("name")).list();

    }

    public List<CourseUnit> loadTeachedImportYearSemestreUnits(long teacherId, 1.5.0/docs/api/java/lang/String.html">String importYear, 1.5.0/docs/api/java/lang/String.html">String semestre)

    {

        Criteria c  =createCriteria()

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

                .createAlias("teachers", "st")

                .add(eq("st.id", teacherId))

                .add(eq("st.id", teacherId));

        if(semestre != null)

            c.add(eq("semestre", semestre));

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

    }

    public CourseUnit loadBySigesCodeUnique(1.5.0/docs/api/java/lang/String.html">String sigesCode)

    {

        return (CourseUnit) createCriteria().add(eq("code", sigesCode)).uniqueResult();

    }

    public CourseUnit loadBySigesCodeUnique(1.5.0/docs/api/java/lang/String.html">String sigesCode, 1.5.0/docs/api/java/lang/String.html">String courseCode)

    {

        return (CourseUnit) createCriteria().add(eq("code", sigesCode)).add(eq("courseCode", courseCode)).uniqueResult();

    }

    public CourseUnit loadBySigesCodeUniqueSubscribed(1.5.0/docs/api/java/lang/String.html">String sigesCode, 1.5.0/docs/api/java/lang/String.html">String year, 1.5.0/docs/api/java/lang/String.html">String courseCode, long studentId, 1.5.0/docs/api/java/lang/String.html">String semestre)

    {

        List<CourseUnit> cus = createCriteria()

                .add(eq("code", sigesCode))

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

                .add(eq("courseCode", courseCode))

                .add(eq("semestre", semestre))

                .createAlias("students", "st")

                .add(eq("st.id", studentId))

                .list();

        if (cus.size() > 1)

        {

            CourseUnit cu1 = cus.get(0);

            CourseUnit cu2 = cus.get(1);

            if (cus.size() > 2)

            {

                logger.error("CourseUnit in more than two places in a course:" + cu1.getCode());

            }

            else

            {

                if (cu1.getSemestre().equals("S1"))

                {

                    if (cu2.getSemestre().equals("S1"))

                        logger.error("CourseUnit in more than two places in a semestre:" + cu1.getCode());

                    else

                    {

                        return cu2;

                    }

                }

                else

                {

                    if (cu2.getSemestre().equals("S2"))

                        logger.error("CourseUnit in more than two places in a semestre:" + cu1.getCode());

                    else

                    {

                        return cu1;

                    }

                }

            }

        }

        else if (cus.size() == 1)

            return cus.get(0);

        return null;

    }

    public void consistCourseUnitCourseCodes(1.5.0/docs/api/java/lang/String.html">String importYear)

    {

           List<CourseUnit> courseUnit =  createCriteria()

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

        for(CourseUnit cu: courseUnit)

        {

            if(cu.getCourse() != null)

            {

                if(cu.getCourseCode() == null || (cu.getCourseCode() != null && !cu.getCourseCode().equals(cu.getCourse().getCode())))

                {

                    1.5.0/docs/api/java/lang/System.html">System.out.println("Course code wrong: " + cu.getId() + " - " + cu.getName() + " old CourseCode " + cu.getCourseCode() + " now:" + cu.getCourse().getCode() );

                }

                if(cu.getCourseName() == null || (cu.getCourseName() != null && !cu.getCourseName().equals(cu.getCourse().getName())))

                {

                    1.5.0/docs/api/java/lang/System.html">System.out.println("Course name wrong: " + cu.getId() + " - " + cu.getName() + " old CourseCode " + cu.getCourseName() + " now:" + cu.getCourse().getName() );

                }

                cu.setCourseCode(cu.getCourse().getCode());

                cu.setCourseName(cu.getCourse().getName());

            }

            else

            {

                cu.setCourseCode("");

                cu.setCourseName("");

            }

        }

    }

    //TODO Na actualizacao de uma cadeira para o curso de TESTE mudar o coursecode para o o coursecode desse curso para nao deixar os dados duplicados e mal

    //se nao a carregar unidades vai buscar a errada

    /**

     * Turma required to be unique in BACO Model

     * @param sigesCode

     * @param courseCode

     * @param semestre

     * @param year

     * @return

     */

    public List<CourseUnit> loadBySigesCode(1.5.0/docs/api/java/lang/String.html">String sigesCode, 1.5.0/docs/api/java/lang/String.html">String courseCode, 1.5.0/docs/api/java/lang/String.html">String semestre, 1.5.0/docs/api/java/lang/String.html">String year)

    {

        return

                createCriteria()

                        .add(eq("code", sigesCode))

                        .add(eq("courseCode", courseCode))

                        .add(eq("semestre", semestre))

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

                        .list();

    }

    /**

     * Metodo especial para a fase de transicao para terem código de turma

     * @param sigesCode

     * @param courseCode

     * @param semestre

     * @param year

     * @return

     */

    public List<CourseUnit> loadBySigesCodeTurmaNull(1.5.0/docs/api/java/lang/String.html">String sigesCode, 1.5.0/docs/api/java/lang/String.html">String courseCode, 1.5.0/docs/api/java/lang/String.html">String semestre, 1.5.0/docs/api/java/lang/String.html">String year)

    {

        //todo cdTurma Rollback

        return (List<CourseUnit>)

                createCriteria()

                        .add(eq("code", sigesCode))

                        .add(eq("courseCode", courseCode))

                        .add(eq("semestre", semestre))

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

                        .add(isNull("cdTurma"))

                        .list();

    }

    public List<CourseUnit> loadBySigesCodeUniqueIgnoreCourse(1.5.0/docs/api/java/lang/String.html">String sigesCode, 1.5.0/docs/api/java/lang/String.html">String semestre, 1.5.0/docs/api/java/lang/String.html">String year)

    {

        return loadBySigesCodeUnique(sigesCode,null,semestre,year);

    }

    //TODO Na actualizacao de uma cadeira para o curso de TESTE mudar o coursecode para o o coursecode desse curso para nao deixar os dados duplicados e mal

    //se nao a carregar unidades vai buscar a errada

    public List<CourseUnit> loadBySigesCodeUnique(1.5.0/docs/api/java/lang/String.html">String sigesCode, 1.5.0/docs/api/java/lang/String.html">String courseCode, 1.5.0/docs/api/java/lang/String.html">String semestre, 1.5.0/docs/api/java/lang/String.html">String year)

    {

        Criteria c =  createCriteria();

        if(courseCode != null)

            c.add(eq("courseCode", courseCode));

        c.add(eq("code", sigesCode))

         .add(eq("semestre", semestre))

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

                //not any more .add(eq("cdTurma", turma))

        List<CourseUnit> cus = c.list();

        if(cus.size() > 1)

        {

            logger.warn("WARNING WARNING ####Two units found for: ");

            logger.warn("WARNING WARNING ####String sigesCode, String courseCode, String semestre, String year = " + sigesCode + ", " + courseCode + "," + semestre + "," + year);

            logger.warn("WARNING WARNING ####returning first one, this could be a case of units spared because of TURMAS split used in 201516: ");

        }

        return cus;

    }

    public List<CourseUnit> loadBySigesCodeUniqueWithTurmaIgnoreCourse(1.5.0/docs/api/java/lang/String.html">String sigesCode, 1.5.0/docs/api/java/lang/String.html">String semestre, 1.5.0/docs/api/java/lang/String.html">String year,1.5.0/docs/api/java/lang/String.html">String turma){

        return loadBySigesCodeUniqueWithTurma(sigesCode,null,semestre,year,turma);

    }

    public List<CourseUnit> loadBySigesCodeUniqueWithTurma(1.5.0/docs/api/java/lang/String.html">String sigesCode, 1.5.0/docs/api/java/lang/String.html">String courseCode, 1.5.0/docs/api/java/lang/String.html">String semestre, 1.5.0/docs/api/java/lang/String.html">String year,1.5.0/docs/api/java/lang/String.html">String turma)

    {

        Criteria c =  createCriteria();

        if(courseCode != null)

            c.add(eq("courseCode", courseCode));

        c.add(eq("code", sigesCode))

            .add(eq("semestre", semestre))

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

            .add(eq("cdTurma", turma));

        List<CourseUnit> cus = c.list();

        if(cus.size() > 1)

        {

            logger.warn("WARNING WARNING ####Two units found for: ");

            logger.warn("WARNING WARNING ####String sigesCode, String courseCode, String semestre, String year = " + sigesCode + ", " + courseCode + "," + semestre + "," + year);

            logger.warn("WARNING WARNING ####returning first one, this could be a case of units spared because of TURMAS split used in 201516: ");

        }

        return cus;

    }

    public List<CourseUnit> loadBySigesCodeUniqueAllCourses(1.5.0/docs/api/java/lang/String.html">String sigesCode, 1.5.0/docs/api/java/lang/String.html">String semestre, 1.5.0/docs/api/java/lang/String.html">String year)

    {

        //todo cdTurma Rollback

        return

                createCriteria()

                        .add(eq("code", sigesCode))

                        // REMOVED TO LET BE ALL COURSES .add(eq("courseCode", courseCode))

                        .add(eq("semestre", semestre))

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

                        //not anymore .add(eq("cdTurma", turma))

                        .list();

    }

    public CourseUnit loadBySigesCodeUniqueMostRecent(1.5.0/docs/api/java/lang/String.html">String sigesCode, 1.5.0/docs/api/java/lang/String.html">String courseCode, 1.5.0/docs/api/java/lang/String.html">String semestre)

    {

        List<CourseUnit> cus;

        Criteria cr = createCriteria()

                        .add(eq("code", sigesCode))

                        .add(eq("courseCode", courseCode));

        if(semestre != null)

            cr.add(eq("semestre", semestre));

        cr.addOrder(Order.desc("importYear")).setMaxResults(1);

        cus = cr.list();

        if(cus.size() > 0)

            return cus.get(0);

        logger.warn("Accessing unit not existent with siges code " + sigesCode + " course code: " + courseCode + " semestre: " + semestre);

        return null;

    }

    public CourseUnit loadBySigesCodeUniqueLastYear(1.5.0/docs/api/java/lang/String.html">String sigesCode, 1.5.0/docs/api/java/lang/String.html">String courseCode, 1.5.0/docs/api/java/lang/String.html">String semestre)

    {

        return loadBySigesCodeUniqueMostRecent(sigesCode,courseCode,semestre);

    }

    public List<CourseUnit> loadBySigesCodeUnique(1.5.0/docs/api/java/lang/String.html">String sigesCode, 1.5.0/docs/api/java/lang/String.html">String courseCode, 1.5.0/docs/api/java/lang/String.html">String year)

    {

        return createCriteria()

                .add(eq("code", sigesCode))

                .add(eq("courseCode", courseCode))

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

                .addOrder(Order.desc("id"))

                .list();        

    }

    public List<CourseUnit> loadBySigesCodes(1.5.0/docs/api/java/lang/String.html">String sigesCode, 1.5.0/docs/api/java/lang/String.html">String courseCode)

    {

        return (List<CourseUnit>) createCriteria()

                .add(eq("code", sigesCode))

                .add(eq("courseCode", courseCode))

                .addOrder(Order.desc("importYear"))

                .list();

    }

    /**

     * Metodo usado para carregar unidades de anos anteriores que possam estar em edição

     * para mostrar na página da unidade

     *

     * Este metodo nao serve para mais nada, nao é usado nas Tarefas da Home

     * @param sigesCode

     * @param courseCode

     * @return

     */

    public CourseUnit loadUnitInEvaluationBySigesCodes(1.5.0/docs/api/java/lang/String.html">String sigesCode, 1.5.0/docs/api/java/lang/String.html">String courseCode)

    {

        1.5.0/docs/api/java/lang/String.html">String activeImportYear = DaoFactory.getConfigurationDaoImpl().getCourseUnitEvaluationActiveYear();

        Criterion crtDegrees = getCourseUnitActiveDegreeCourseIdsCriterion(activeImportYear);

        if(crtDegrees == null)

        {

            //Nao ha graus nem cursos portanto o ano não interessa

            //o ano deve ser usado para abrir graus ou cursos senao nao

            //abre nada

            crtDegrees = eq("evaluationOpenByAdmin",true);

        }

        else

        {

            crtDegrees = and(eq("importYear", activeImportYear),crtDegrees);

            crtDegrees = or(eq("evaluationOpenByAdmin",true),crtDegrees);

        }

        List<CourseUnit> cus = (List<CourseUnit>) createCriteria()

                .createAlias("course","c")

                .createAlias("courseUnitEvaluation","ce")

                .add(eq("code", sigesCode))

                .add(eq("courseCode", courseCode))

                .add(crtDegrees)

                .add(eq("ce.closed",false))

                .list();

        List<CourseUnit> cusNull = (List<CourseUnit>) createCriteria()

                .createAlias("course","c")

                .add(eq("code", sigesCode))

                .add(eq("courseCode", courseCode))

                .add(crtDegrees)

                .add(isNull("courseUnitEvaluation"))

                .list();

        cus.addAll(cusNull);

        if(cus != null && cus.size() > 1)

        {

            logger.warn("Mais do que uma unidade do mesmo codigo em avaliacao curricular, e suposto haver apenas uma, verificar logica aplicacional");

        }

        else if(cus != null && cus.size() > 0)

        {

            return cus.get(0);

        }

        return null;

    }

    public List<CourseUnit> loadCourseUnits(long courseId, 1.5.0/docs/api/java/lang/String.html">String semestre, 1.5.0/docs/api/java/lang/String.html">String year, boolean withTeacher, boolean withNoTeacher)

    {

        return loadCourseUnits( courseId,  semestre,  year,  withTeacher,  withNoTeacher,null);

    }

    public List<CourseUnit> loadCourseUnits(long courseId, 1.5.0/docs/api/java/lang/String.html">String semestre, 1.5.0/docs/api/java/lang/String.html">String year, boolean withTeacher, boolean withNoTeacher,1.5.0/docs/api/java/lang/String.html">String institutionCode)

    {

        Criteria c = createCriteria();

        if(courseId > 0)

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

        if(semestre != null && semestre.trim().length() > 0)

            c.add(eq("semestre", semestre));

        if(year != null  && year.trim().length() > 0)

            c.add(eq("importYear", year));

        if(institutionCode != null && institutionCode.trim().length() > 0)

            c.add(eq("institutionCode", institutionCode));

        if(withTeacher && !withNoTeacher)

        {

            c.createAlias("teachers", "th");

            c.add(isNotNull("th.id"));

        }

        else if(!withTeacher && withNoTeacher)

        {

            c.createAlias("teachers", "th", JoinFragment.LEFT_OUTER_JOIN);

            c.add(isNull("th.id"));

        }

        return c.list();

    }

    public static class CourseUnitResult

    {

        public long id = 0;

        public int students = 0;

        public int teachers = 0;

        public int turmas = 0;

    }

    /**

     *

     * @param courseId

     * @param semestre

     * @param year

     * @return List<CourseUnitResult>

     */

    public List<CourseUnitResult> loadCourseUnits(long courseId, 1.5.0/docs/api/java/lang/String.html">String semestre, 1.5.0/docs/api/java/lang/String.html">String year)

    {

        Criteria c = createCriteria();

       c.setProjection(Projections.projectionList()

                .add(Projections.groupProperty("id"))

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

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

                .add(Projections.countDistinct("turma.id")));

        c.createAlias("students","student");

        c.createAlias("teachers","teacher");

        c.createAlias("turmas","turma");

        c.createAlias("turma.students","ts");//obrigar a entrar apenas turmas com alunos

        if(courseId > 0)

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

        if(semestre != null && semestre.trim().length() > 0)

            c.add(eq("semestre", semestre));

        if(year != null  && year.trim().length() > 0)

            c.add(eq("importYear", year));

        List<CourseUnitResult> results = new ArrayList<CourseUnitResult>();

        List<Object[]> result = c.list();

        for(5+0%2Fdocs%2Fapi+Object">Object[] r:result)

        {

            CourseUnitResult cur = new CourseUnitResult();

            cur.id = (1.5.0/docs/api/java/lang/Long.html">Long) r[0];

            cur.students = (1.5.0/docs/api/java/lang/Integer.html">Integer) r[1];

            cur.teachers = (1.5.0/docs/api/java/lang/Integer.html">Integer) r[2];

            cur.turmas = (1.5.0/docs/api/java/lang/Integer.html">Integer) r[3];

            results.add(cur);

        }

        return results;

    }

    public int countCourseUnits(1.5.0/docs/api/java/lang/String.html">String query, SearchTypeEnum searchType)

    {

        Criterion c = DaoUtils.createSearchQuery(query, searchType, "objectives", "name","code");

        return createCriteria().add(c).list().size();

    }

    public List<CourseUnit> search(1.5.0/docs/api/java/lang/String.html">String query, SearchTypeEnum searchTypeEnum, int maxUnits, int page)

    {

        Criterion c = DaoUtils.createSearchQuery(query, searchTypeEnum, "objectives", "name","code");

        Criteria criteria = createCriteria();

        criteria.add(c)

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

                .setMaxResults(maxUnits)

                .setFirstResult(page * maxUnits);

        return criteria.list();

    }

    public int countCourseUnitsActualYear(1.5.0/docs/api/java/lang/String.html">String query, SearchTypeEnum searchType)

    {

        Criterion c = DaoUtils.createSearchQuery(query, searchType, "objectives", "name");

        return createCriteria()

                .add(c)

                .add(eq("importYear", DaoFactory.getConfigurationDaoImpl().getInterfaceImportYear()))

                .list().size();

    }

    public List<CourseUnit> searchActualYear(1.5.0/docs/api/java/lang/String.html">String query, SearchTypeEnum searchTypeEnum, int maxUnits, int page)

    {

        Criterion c = DaoUtils.createSearchQuery(query, searchTypeEnum, "objectives", "name");

        Criteria criteria = createCriteria();

        criteria.add(c)

                .add(eq("importYear", DaoFactory.getConfigurationDaoImpl().getInterfaceImportYear()))

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

                .setMaxResults(maxUnits)

                .setFirstResult(page * maxUnits);

        return criteria.list();

    }

    public List<CourseUnit> loadMissingObjectives(long teacherId)

    {

        //todo falta a projeccao do teacher id

        return createCriteria()

                .add(eq("importYear", DaoFactory.getConfigurationDaoImpl().getInterfaceImportYear()))

                .add((or(isNull("objectives"), eq("objectives", ""))))

                .createAlias("teachers", "th")

                .add(eq("semestre", DatesUtils.getSemestre()))

                .add(eq("th.id", teacherId))

                .list();

    }

    public List<CourseUnit> loadMissingPrograms(long teacherId)

    {

        //todo falta a projeccao do teacher id

        return createCriteria()

                .createAlias("course","c")

                .add(eq("c.status", true))

                .add(eq("importYear", DaoFactory.getConfigurationDaoImpl().getInterfaceImportYear()))

                .add((or(isNull("programStreamId"), eq("programStreamId", ""))))

                .createAlias("teachers", "th")

                .add(eq("semestre", DatesUtils.getSemestre()))

                .add(eq("th.id", teacherId))

                .list();

    }

    public List<CourseUnit> loadMissingObjectivesOrPrograms(long teacherId)

    {

        //todo falta a projeccao do teacher id

        Criteria c = createCriteria()

                .add(eq("importYear", DaoFactory.getConfigurationDaoImpl().getInterfaceImportYear()))

                .add(or(or(isNull("objectives"), eq("objectives", "")), or(isNull("programStreamId"), eq("programStreamId", ""))));

        DatesUtils.SemestreModerate semestreModerate = DatesUtils.getSemestreModerate();

        if (semestreModerate == DatesUtils.SemestreModerate.S1)

            c.add(eq("semestre", "S1"));

        else if (semestreModerate == DatesUtils.SemestreModerate.S2)

            c.add(eq("semestre", "S2"));

        else

            c.add(or(eq("semestre", "S1"), eq("semestre", "S2")));

        return c.createAlias("teachers", "th")

                .add(eq("th.id", teacherId))

                .list();

    }

    public List<CourseUnit> loadMissingObjectivesGivenCourse(long courseId)

    {

        return createCriteria()

                .createAlias("course", "c")

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

                .add(eq("importYear", DaoFactory.getConfigurationDaoImpl().getInterfaceImportYear()))

                .add(eq("semestre", DatesUtils.getSemestre()))

                .add((or(isNull("objectives"), eq("objectives", ""))))

                .list();

    }

    public List<CourseUnit> loadMissingProgramGivenCourse(long courseId)

    {

        return createCriteria()

                .createAlias("course", "c")

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

                .add(eq("importYear", DaoFactory.getConfigurationDaoImpl().getInterfaceImportYear()))

                .add(eq("semestre", DatesUtils.getSemestre()))

                .add((or(isNull("programStreamId"), eq("programStreamId", ""))))

                .list();

    }

    public List<CourseUnit> loadMissingProgramValidateGivenCourse(long courseId)

    {

        return createCriteria()

                .createAlias("course", "c")

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

                .add(eq("importYear", DaoFactory.getConfigurationDaoImpl().getInterfaceImportYear()))

                .add(eq("semestre", DatesUtils.getSemestre()))

                .add((and(isNotNull("programStreamId"), not(eq("programStreamId", "")))))

                .add((eq("validProgram", false)))

                .list();

    }

    public List<CourseUnit> loadMissingObjectivesOrProgramGivenCourse(long courseId)

    {

        return createCriteria()

                .createAlias("course", "c")

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

                .add(eq("importYear", DaoFactory.getConfigurationDaoImpl().getInterfaceImportYear()))

                .add(eq("semestre", DatesUtils.getSemestre()))

                .add((or(or(isNull("objectives"), eq("objectives", "")), or(isNull("programStreamId"), eq("programStreamId", "")))))

                .list();

    }

    public int countMissingProgramGivenCourse(long courseId)

    {

        return loadMissingProgramGivenCourse(courseId).size();

    }

    public int countMissingProgramValidateCourse(long courseId)

    {

        return loadMissingProgramValidateGivenCourse(courseId).size();

    }

    public List<String> getTeachersEmails(long unit) {