Subversion Repositories bacoAlunos

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

import org.hibernate.Criteria;
import org.hibernate.Query;
import org.hibernate.criterion.Criterion;
import org.hibernate.criterion.Expression;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Projections;
import pt.estgp.estgweb.domain.Course;
import pt.estgp.estgweb.domain.CourseImpl;
import pt.estgp.estgweb.domain.CourseUnit;
import pt.estgp.estgweb.domain.CourseUnitTurma;
import pt.estgp.estgweb.domain.dao.DaoFactory;
import pt.estgp.estgweb.domain.dao.DaoUtils;
import pt.estgp.estgweb.services.common.SearchTypeEnum;

import java.util.List;

import static org.hibernate.criterion.Restrictions.eq;
import static org.hibernate.criterion.Restrictions.not;

/**
 * @author Jorge Machado
 * @date 28/Fev/2008
 * @time 2:51:06
 * @see pt.estgp.estgweb.domain.dao.impl
 */
public class CourseDaoImpl extends CourseDao
{
    public static CourseDaoImpl getInstance()
    {
        if (myInstance == null)
            myInstance = new CourseDaoImpl();
        return (CourseDaoImpl) myInstance;
    }

    public CourseImpl findCourseByCode(1.5.0/docs/api/java/lang/String.html">String code)
    {
        return (CourseImpl) createCriteria().add(eq("code", code)).uniqueResult();
    }

    public CourseImpl findCourseByCodeAndYear(1.5.0/docs/api/java/lang/String.html">String code, 1.5.0/docs/api/java/lang/String.html">String year)
    {
        return (CourseImpl) createCriteria().add(eq("code", code)).add(eq("importYear", year)).uniqueResult();
    }


    public int countCoursesActualYear(1.5.0/docs/api/java/lang/String.html">String query, SearchTypeEnum searchType)
    {
        Criterion c = DaoUtils.createSearchQuery(query, searchType, "name", "description");
        return createCriteria()
                .add(c)
                .add(eq("importYear", DaoFactory.getConfigurationDaoImpl().getInterfaceImportYear()))
                .list().size();
    }

    public int countCoursesUnits(1.5.0/docs/api/java/lang/String.html">String importYear,long courseId)
    {
  /*      return createCriteria()
                .createAlias("courseUnits", "c")
                .setProjection(Projections.property("c.id"))
                .add(eq("c.importYear", importYear))
                .add(eq("id", courseId))
                .list().size();
*/
        return (1.5.0/docs/api/java/lang/Integer.html">Integer) createCriteria(CourseUnit.class)
                .setProjection(Projections.rowCount())
                .add(eq("importYear",importYear))
                .add(eq("course.id",courseId))
                .uniqueResult();
    }

    public int countCoursesUnits(1.5.0/docs/api/java/lang/String.html">String importYear,long courseId,1.5.0/docs/api/java/lang/String.html">String semestre)
    {
  /*      return createCriteria()
                .createAlias("courseUnits", "c")
                .setProjection(Projections.property("c.id"))
                .add(eq("c.importYear", importYear))
                .add(eq("id", courseId))
                .list().size();
*/
        return (1.5.0/docs/api/java/lang/Integer.html">Integer) createCriteria(CourseUnit.class)
                .setProjection(Projections.rowCount())
                .add(eq("importYear",importYear))
                .add(eq("semestre",semestre))
                .add(eq("course.id",courseId))
                .uniqueResult();
    }


    public int countCoursesUnitsTurmas(1.5.0/docs/api/java/lang/String.html">String importYear,long courseId)
    {
        return (1.5.0/docs/api/java/lang/Integer.html">Integer) createCriteria(CourseUnitTurma.class)
                .setProjection(Projections.countDistinct("turma"))
                .createAlias("courseUnit", "courseUnit")
                .createAlias("students", "student")
                .add(eq("courseUnit.importYear",importYear))
                .add(eq("courseUnit.course.id",courseId))
                .uniqueResult();
    }

    public int countCoursesUnitsNot(1.5.0/docs/api/java/lang/String.html">String importYear,long courseId)
    {
        return createCriteria()
                .createAlias("courseUnits", "c")
                .setProjection(Projections.property("c.id"))
                .add(not(eq("c.importYear", importYear)))
                .add(eq("id", courseId))
                .list().size();
    }

    public List<Long> findCoursesUnitsIds(1.5.0/docs/api/java/lang/String.html">String importYear,long courseId)
    {
        return createCriteria()
                .createAlias("courseUnits", "c")
                .setProjection(Projections.property("c.id"))
                .add(eq("id", courseId))
                .add(eq("c.importYear", importYear))
                .addOrder(Order.asc("c.name"))
                .list();
    }

    public List<Long> findCoursesUnitsIds(long courseId)
    {
        return createCriteria()
                .createAlias("courseUnits","c")
                .setProjection(Projections.property("c.id"))
                .add(eq("id", courseId))
                .addOrder(Order.asc("c.importYear"))
                .addOrder(Order.asc("c.name"))
                .list();
    }

    public List<Course> searchActualYear(1.5.0/docs/api/java/lang/String.html">String query, SearchTypeEnum searchTypeEnum, int max, int page)
    {
        Criterion c = DaoUtils.createSearchQuery(query, searchTypeEnum, "name", "description");
        Criteria criteria = createCriteria();
        criteria.add(c)
                .add(eq("importYear", DaoFactory.getConfigurationDaoImpl().getInterfaceImportYear()))
                .addOrder(Order.asc("name"))
                .setMaxResults(max)
                .setFirstResult(page * max);
        return criteria.list();
    }


    public List<Course> findAllOrderByName()
    {
        return createCriteria()
                .addOrder(Order.asc("name"))
                .list();
    }

    public List<Course> findAllImportYearOrderByName(1.5.0/docs/api/java/lang/String.html">String importYear, 1.5.0/docs/api/java/lang/String.html">String area)
    {
        Criteria c = createCriteria();
        if (importYear != null && importYear.length() > 0)
        {
            c.add(eq("importYear", importYear));
        }
        if (area != null && area.length() > 0)
        {
            c.add(eq("area", area));
        }
        return c.addOrder(Order.asc("name"))
                .list();
    }

    public List<Course> findAllOrderByName(1.5.0/docs/api/java/lang/String.html">String importYear)
    {
        return createCriteria()
                .add(eq("cu.importYear", importYear))
                .addOrder(Order.asc("name"))
                .list();
    }

    public List<Course> findAllOrderByNameEvenWithoutCourseUnit(1.5.0/docs/api/java/lang/String.html">String importYear, 1.5.0/docs/api/java/lang/String.html">String area, 1.5.0/docs/api/java/lang/String.html">String type)
    {
        Criteria c = createCriteria();

       /* c.setProjection(Projections.projectionList()
                            .add(Projections.distinct(Projections.id())));*/
        if (importYear != null && importYear.length() > 0)
            c.add(eq("importYear", importYear));
        if (area != null && area.length() > 0)
            c.add(eq("area", area));
        if (type != null && type.length() > 0)
            c.add(eq("degree", type));
        return c.addOrder(Order.asc("name"))
                .list();
    }

    public List<Course> findAllActiveOrderByNameEvenWithoutCourseUnit()
    {
        Criteria c = createCriteria();

         /* c.setProjection(Projections.projectionList()
                              .add(Projections.distinct(Projections.id())));*/
        c.add(eq("status", true));
        return c.addOrder(Order.asc("name"))
                .list();
    }

    public List<Course> findAllActiveOrderByNameEvenWithoutCourseUnit(1.5.0/docs/api/java/lang/String.html">String institutionalCode, 1.5.0/docs/api/java/lang/String.html">String degree)
    {
        Criteria c = createCriteria();

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

        if (degree != null && degree.length() > 0)
            c.add(eq("degree", degree));

        if (institutionalCode != null && institutionalCode.length() > 0)
            c.add(eq("institutionalCode", institutionalCode));

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

    public List<Course> findAllActiveOrderByNameEvenWithoutCourseUnit(1.5.0/docs/api/java/lang/String.html">String importYear, 1.5.0/docs/api/java/lang/String.html">String area, 1.5.0/docs/api/java/lang/String.html">String type)
      {
          Criteria c = createCriteria();

         /* c.setProjection(Projections.projectionList()
                              .add(Projections.distinct(Projections.id())));*/
          if (importYear != null && importYear.length() > 0)
              c.add(eq("status", true));
          if (area != null && area.length() > 0)
              c.add(eq("area", area));
          if (type != null && type.length() > 0)
              c.add(eq("degree", type));
          return c.addOrder(Order.asc("name"))
                  .list();
      }

    public List<Course> findCoursesWithUnitsIn(1.5.0/docs/api/java/lang/String.html">String importYear)
    {
        return findAllOrderByName(importYear,null,null,null);
    }

    public List<String> loadInstitutionCodes(1.5.0/docs/api/java/lang/String.html">String importYear)
    {
        return
                createCriteria()
                        .setProjection(Projections
                                .distinct(Projections.projectionList()
                                        .add(Projections.property("institutionCode"))))
                        .add(1.5.0/docs/api/java/beans/Expression.html">Expression.isNotNull("institutionCode"))
                        .list();
    }
    public List<Course> findCoursesWithUnitsIn(1.5.0/docs/api/java/lang/String.html">String importYear,1.5.0/docs/api/java/lang/String.html">String institutionCode, 1.5.0/docs/api/java/lang/String.html">String semestre)
    {
        return findAllOrderByName(importYear,null,null,institutionCode,semestre);
    }
    public List<Course> findCoursesWithUnitsIn(1.5.0/docs/api/java/lang/String.html">String importYear,1.5.0/docs/api/java/lang/String.html">String institutionCode)
    {
        return findAllOrderByName(importYear,null,null,institutionCode);
    }

    public List<Course> findAllOrderByName(1.5.0/docs/api/java/lang/String.html">String importYear, 1.5.0/docs/api/java/lang/String.html">String area, 1.5.0/docs/api/java/lang/String.html">String type)
    {
        return findAllOrderByName(importYear,area,type,null);
    }

    public List<Course> findAllOrderByName(1.5.0/docs/api/java/lang/String.html">String importYear, 1.5.0/docs/api/java/lang/String.html">String area, 1.5.0/docs/api/java/lang/String.html">String type,1.5.0/docs/api/java/lang/String.html">String institutionCode)
    {
        return findAllOrderByName(importYear,area,type,institutionCode,null);
    }
    public List<Course> findAllOrderByName(1.5.0/docs/api/java/lang/String.html">String importYear, 1.5.0/docs/api/java/lang/String.html">String area, 1.5.0/docs/api/java/lang/String.html">String type,1.5.0/docs/api/java/lang/String.html">String institutionCode, 1.5.0/docs/api/java/lang/String.html">String semestre)
    {

        1.5.0/docs/api/java/lang/String.html">String query = "select distinct c from c in class Course join c.courseUnits cu where ";
        1.5.0/docs/api/java/lang/String.html">String logic = " ";
        if (importYear != null && importYear.length() > 0)
        {
            query += logic + "cu.importYear = :importYear ";
            logic = " and ";
        }
        if (institutionCode != null && institutionCode.trim().length() > 0)
        {
            query += logic + "c.institutionalCode = :institutionCode ";
            logic = " and ";
        }
        if (area != null && area.length() > 0)
        {
            query += logic + "c.area = :area ";
            logic = " and ";
        }
        if (type != null && type.length() > 0)
        {
            query += logic + "c.degree = :degree ";
            logic = " and ";
        }
        if (semestre != null && semestre.length() > 0)
        {
            query += logic + "cu.semestre = :semestre ";
            logic = " and ";
        }
        query += " order by c.name asc";

        1.5.0/docs/api/javax/management/Query.html">Query q = getCurrentSession().createQuery(query);
        if (importYear != null && importYear.length() > 0)
        {
            q.setString("importYear",importYear);
        }
        if (institutionCode != null && institutionCode.trim().length() > 0)
        {
            q.setString("institutionCode",institutionCode);
        }
        if (area != null && area.length() > 0)
        {
            q.setString("area",area);
        }
        if (type != null && type.length() > 0)
        {
            q.setString("degree",type);
        }
        if (semestre != null && semestre.length() > 0)
        {
            q.setString("semestre",semestre);
        }
       /* c.setProjection(Projections.projectionList()
                            .add(Projections.distinct(Projections.id())));*/
        return q.list();
    }



    public List<String> loadImportYears()
    {
        1.5.0/docs/api/javax/management/Query.html">Query q = createQuery("select distinct c.importYear from c in class " + CourseUnit.class.getName() + " order by c.importYear desc");
        return q.list();
    }

    public List<Course> loadAllCourses(long teacherId, 1.5.0/docs/api/java/lang/String.html">String importYear)
    {
        return
                createCriteria()
                        .add(eq("importYear", importYear))
                        .list();
    }

    public List<Course> loadCoordinatedCourses(long teacherId, 1.5.0/docs/api/java/lang/String.html">String importYear)
    {
        return
                createCriteria()
                        .add(eq("coordinator.id", teacherId))
                        .add(eq("importYear", importYear))
                        .list();
    }

    public List<Course> loadDirectorCourses(long teacherId, 1.5.0/docs/api/java/lang/String.html">String importYear)
    {
        return
                createCriteria()
                        .add(eq("director.id", teacherId))
                        .add(eq("importYear", importYear))
                        .list();
    }

    public List<Course> findAll(1.5.0/docs/api/java/lang/String.html">String importYear)
    {
        return createCriteria().add(eq("importYear", importYear)).addOrder(Order.asc("name"))
                .list();
    }

    public List<Course> findAllStatus(1.5.0/docs/api/java/lang/String.html">String importYear,boolean status)
    {
        return createCriteria()
                .add(eq("importYear", importYear))
                .add(eq("status", status))
                .addOrder(Order.asc("name"))
                .list();
    }

    public List<Course> findActiveCourses(1.5.0/docs/api/java/lang/String.html">String importYear)
    {
        return findAllStatus(importYear,true);
    }

    public List<Course> findAllNotIn(1.5.0/docs/api/java/lang/String.html">String importYear)
    {
        return createCriteria().add(not(eq("importYear", importYear)))
                .list();
    }

   

     // Duarte Santos
    public List<String> loadAreas()
    {
        return
                createCriteria()
                    .setProjection(Projections
                            .distinct(Projections.projectionList()
                                    .add(Projections.property("area"))))
                    .add(1.5.0/docs/api/java/beans/Expression.html">Expression.isNotNull("area"))
                    .list();
    }


}