Example usage for org.hibernate.criterion DetachedCriteria add

Introduction

In this page you can find the example usage for org.hibernate.criterion DetachedCriteria add.

Prototype

public DetachedCriteria add(Criterion criterion)

Source Link

Document

Add a restriction

Usage

From source file:chiron.maxscore.service.impl.CourseServiceImpl.java

private DetachedCriteria makeCriteria(Map<String, Object> condition) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Course.class);

    if (condition == null) {
        return criteria;
    }//from  w w w .j  a v a  2  s .  c o m

    if (condition.containsKey("course_name")) {
        criteria.add(
                Restrictions.ilike("courseName", condition.get("course_name").toString(), MatchMode.ANYWHERE));
    }

    return criteria;
}

From source file:chiron.maxscore.service.impl.GradeServiceImpl.java

private DetachedCriteria makeCriteria(Map<String, Object> condition) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Grade.class);

    if (condition == null) {
        return criteria;
    }// w w w .j  a v a2 s .  c  o  m

    criteria.createAlias("specialty", "s");
    criteria.createAlias("s.college", "c");

    if (condition.containsKey("college_id")) {
        criteria.add(Restrictions.eq("c.id", condition.get("college_id")));
    } else if (condition.containsKey("specialty_id")) {
        criteria.add(Restrictions.eq("s.id", condition.get("specialty_id")));
    }

    if (condition.containsKey("grade_name")) {
        criteria.add(
                Restrictions.ilike("gradeName", condition.get("grade_name").toString(), MatchMode.ANYWHERE));
    }

    return criteria;
}

From source file:chiron.maxscore.service.impl.MenuServiceImpl.java

private DetachedCriteria makeCriteria(Map<String, Object> condition) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Menu.class);

    if (condition == null) {
        return criteria;
    }//w ww  .j a  va2  s .  c  o  m
    if (condition.containsKey("menu_title")) {
        criteria.add(
                Restrictions.ilike("menuTitle", condition.get("menu_title").toString(), MatchMode.ANYWHERE));
    }

    return criteria;
}

From source file:chiron.maxscore.service.impl.MenuServiceImpl.java

@Override
public Menu getRoot() {
    DetachedCriteria criteria = DetachedCriteria.forClass(Menu.class);

    criteria.add(Restrictions.isNull("menuParent"));
    List<Menu> list = menuDAO.search(0, 1, criteria);
    return list.size() > 0 ? list.get(0) : null;
}

From source file:chiron.maxscore.service.impl.MenuServiceImpl.java

@Override
public List<Menu> getByLevel(int level) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Menu.class);

    criteria.add(Restrictions.eq("menuLevel", level));
    List<Menu> list = menuDAO.search(0, 1000, criteria);
    return list;/*from   w w  w . j a  v a 2s .c  o m*/
}

From source file:chiron.maxscore.service.impl.ModuleServiceImpl.java

private DetachedCriteria makeCriteria(Map<String, Object> condition) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Module.class);

    if (condition == null) {
        return criteria;
    }/*w w w .j  a v  a2 s.  c om*/

    if (condition.containsKey("module_type")) {
        criteria.add(Restrictions.eq("moduleType", condition.get("module_type")));
    }

    if (condition.containsKey("module_name")) {
        criteria.add(
                Restrictions.ilike("moduleName", condition.get("module_name").toString(), MatchMode.ANYWHERE));
    }

    return criteria;
}

From source file:chiron.maxscore.service.impl.ModuleServiceImpl.java

@Override
public List<Module> getByType(int type) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Module.class);
    criteria.add(Restrictions.eq("moduleType", type));
    return moduleDAO.search(0, Integer.MAX_VALUE, criteria);
}

From source file:chiron.maxscore.service.impl.OptionServiceImpl.java

private DetachedCriteria makeCriteria(Map<String, Object> condition) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Option.class);

    if (condition == null) {
        return criteria;
    }//w w  w  . ja v  a  2 s . c  om

    if (condition.containsKey("option_name")) {
        criteria.add(
                Restrictions.ilike("optionName", condition.get("option_name").toString(), MatchMode.ANYWHERE));
    }

    return criteria;
}

From source file:chiron.maxscore.service.impl.OptionServiceImpl.java

@Override
public List<Option> getRootOptionsByCidAndVer(int cid, int ver) {
    DetachedCriteria criteria = DetachedCriteria.forClass(OptionMapping.class);

    criteria.createAlias("course", "c");
    criteria.createAlias("option", "o");
    criteria.createAlias("parentOption", "p");

    criteria.add(Restrictions.isNull("p"));
    criteria.add(Restrictions.eq("c.id", cid));
    criteria.add(Restrictions.eq("optionVer", ver));

    //        criteria.setProjection(Projections.groupProperty("o.optionGroupId"));
    //        criteria.setProjection(Projections.max("optionVer"));
    List<OptionMapping> oms = optionMappingDAO.search(0, Integer.MAX_VALUE, criteria);
    List<Option> options = new ArrayList<>();
    for (OptionMapping om : oms) {
        options.add(om.getOption());//w ww .  j a v a  2 s  .c  om
    }
    return options;
}

From source file:chiron.maxscore.service.impl.OptionServiceImpl.java

@Override
public List<Option> getOptionsByCidAndVer(int cid, int ver) {
    DetachedCriteria criteria = DetachedCriteria.forClass(OptionMapping.class);

    criteria.createAlias("course", "c");
    criteria.createAlias("option", "o");

    criteria.add(Restrictions.eq("c.id", cid));
    criteria.add(Restrictions.eq("optionVer", ver));

    //        criteria.setProjection(Projections.groupProperty("o.optionGroupId"));
    //        criteria.setProjection(Projections.max("optionVer"));
    List<OptionMapping> oms = optionMappingDAO.search(0, Integer.MAX_VALUE, criteria);
    List<Option> options = new ArrayList<>();
    for (OptionMapping om : oms) {
        options.add(om.getOption());/*from  w  w w . j  av  a 2  s  .c o  m*/
    }
    return options;
}