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:com.joey.Fujikom.modules.sys.utils.UserUtils.java

License:Open Source License

public static List<Office> getOfficeList() {
    @SuppressWarnings("unchecked")
    List<Office> officeList = (List<Office>) getCache(CACHE_OFFICE_LIST);
    if (officeList == null) {
        User user = getUser();//from  w  ww. j a  va 2  s. c  o  m
        //         if (user.isAdmin()){
        //            officeList = officeDao.findAllList();
        //         }else{
        //            officeList = officeDao.findAllChild(user.getOffice().getId(), "%,"+user.getOffice().getId()+",%");
        //         }
        DetachedCriteria dc = officeDao.createDetachedCriteria();
        dc.add(dataScopeFilter(user, dc.getAlias(), ""));
        dc.add(Restrictions.eq(Office.FIELD_DEL_FLAG, Office.DEL_FLAG_NORMAL));
        dc.addOrder(Order.asc("code"));
        officeList = officeDao.find(dc);
        putCache(CACHE_OFFICE_LIST, officeList);
    }
    return officeList;
}

From source file:com.jsilvamoises.controller.MBPessoa.java

public List<Pessoa> listByNomeLike(String nome) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Pessoa.class);
    criteria.add(Restrictions.ilike("nome", nome, MatchMode.ANYWHERE));
    return pessoaDAO().getEntitiesByDetachedCriteria(criteria);
}

From source file:com.kingen.repository.org.OrgDao.java

License:Apache License

public SysOrg findByPK(String pk) {

    DetachedCriteria detachedCriteria = DetachedCriteria.forClass(SysOrg.class);
    detachedCriteria.add(Restrictions.eq("id", pk));
    List<SysOrg> result = find(detachedCriteria);
    return CollectionUtils.isEmpty(result) ? null : result.get(0);

}

From source file:com.krawler.common.util.BuildCriteria.java

License:Open Source License

private static void pushCriteriaValue(Object value, Integer conditionval, DetachedCriteria crit,
        String propertyname) {/*from w w  w.  ja v  a  2 s . c  o  m*/
    switch (conditionval) {
    case ORDER:
        crit.addOrder(getOrderByCondition(value, propertyname));
        break;
    default:
        crit.add(getCriteriaByCondition(value, conditionval, propertyname));
        break;
    }
}

From source file:com.krawler.spring.comments.commentDAOImpl.java

License:Open Source License

public void CreateDuplicateComments(String recordId, String newRecordId) {
    List<Comment> ll = null;
    DetachedCriteria crit = DetachedCriteria.forClass(Comment.class);
    crit.add(Restrictions.eq("leadid", recordId));
    crit.add(Restrictions.eq("deleted", false));
    ll = findByCriteria(crit);/*w ww .  jav  a2  s.co  m*/
    for (Comment commentObj : ll) {
        Comment commentObj1 = new Comment();
        commentObj1.setId(java.util.UUID.randomUUID().toString());
        commentObj1.setComment(commentObj.getComment());
        commentObj1.setleadid(newRecordId);
        commentObj1.setuserId(commentObj.getuserId());
        commentObj1.setRelatedto(commentObj.getRelatedto());
        commentObj1.setPostedon(commentObj.getPostedon());
        save(commentObj1);
    }
}

From source file:com.lcw.one.modules.sys.service.OfficeService.java

License:Open Source License

public List<Office> findAll() {
    DetachedCriteria dc = officeDao.createDetachedCriteria();
    dc.add(dataScopeFilter(UserUtils.getUser(), dc.getAlias(), ""));
    dc.add(Restrictions.eq(Office.FIELD_DEL_FLAG, Office.DEL_FLAG_NORMAL));
    dc.addOrder(Order.asc("code"));
    List<Office> officeList = officeDao.find(dc);
    return officeList;
}

From source file:com.liveneo.plat.web.action.JobmsgAction.java

private DetachedCriteria getDetachedCriteria() {
    DetachedCriteria detachedCriteria = DetachedCriteria.forClass(BdJobmsg.class);
    if (StringUtils.isNotEmpty(queryjobname)) {
        detachedCriteria.add(Restrictions.ilike(BdJobmsg.PROP_JOB_NAME, queryjobname, MatchMode.ANYWHERE));
    }/*from www. j a v  a2 s.  com*/
    if (StringUtils.isNotEmpty(queryjobstate)) {
        detachedCriteria.add(Restrictions.eq(BdJobmsg.PROP_JOB_STATE, queryjobstate));
    }
    return detachedCriteria;
}

From source file:com.lohika.alp.reporter.fe.dao.TestDAOImpl.java

License:Open Source License

private DetachedCriteria getFilteredCriteria(TestFilter filter) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Test.class);

    criteria.createAlias("suite", "suite");

    if (filter.getFrom() != null && filter.getTill() != null) {
        Calendar c = Calendar.getInstance();

        c.setTime(filter.getFrom());//from w  w  w  . j  av a 2 s . c  om
        c.set(Calendar.HOUR_OF_DAY, c.getActualMinimum(Calendar.HOUR_OF_DAY));
        c.set(Calendar.MINUTE, c.getActualMinimum(Calendar.MINUTE));
        c.set(Calendar.SECOND, c.getActualMinimum(Calendar.SECOND));
        c.set(Calendar.MILLISECOND, c.getActualMinimum(Calendar.MILLISECOND));
        Date from = c.getTime();

        c.setTime(filter.getTill());
        c.set(Calendar.HOUR_OF_DAY, c.getActualMaximum(Calendar.HOUR_OF_DAY));
        c.set(Calendar.MINUTE, c.getActualMaximum(Calendar.MINUTE));
        c.set(Calendar.SECOND, c.getActualMaximum(Calendar.SECOND));
        c.set(Calendar.MILLISECOND, c.getActualMaximum(Calendar.MILLISECOND));
        Date till = c.getTime();

        criteria.add(Restrictions.between("startDate", from, till));
    }

    if (filter.getTest() != "" && filter.getTest() != null) {
        try {
            criteria.add(querytr.translate("name", filter.getTest()));
        } catch (QueryTranslatorException e) {
            // TODO Put QueryTranslatorException into log
            e.printStackTrace();
        }
    }

    if (filter.getSuite() != "" && filter.getSuite() != null) {
        try {
            criteria.add(querytr.translate("suite.name", filter.getSuite()));
        } catch (QueryTranslatorException e) {
            // TODO Put QueryTranslatorException into log
            e.printStackTrace();
        }
    }
    return criteria;
}

From source file:com.lohika.alp.reporter.fe.dao.TestDAOImpl.java

License:Open Source License

@Override
public List<Test> listTest(TestFilter filter, Suite suite) {
    DetachedCriteria criteria = getFilteredCriteria(filter);

    criteria.add(Expression.eq("suite", suite));
    return hibernateTemplate.findByCriteria(criteria);
}

From source file:com.lohika.alp.reporter.fe.dao.TestMethodDAOImpl.java

License:Open Source License

private DetachedCriteria getFilteredCriteria(TestMethodFilter filter) {
    DetachedCriteria criteria = DetachedCriteria.forClass(TestMethod.class);

    criteria.createAlias("testInstance", "testInstance").createAlias("testInstance.testClass", "testClass")
            .createAlias("testInstance.test", "test");

    if (filter.getFrom() != null && filter.getTill() != null) {
        Calendar c = Calendar.getInstance();

        c.setTime(filter.getFrom());//from  w  w  w  . j  a  v a  2 s.  c  o  m
        c.set(Calendar.HOUR_OF_DAY, c.getActualMinimum(Calendar.HOUR_OF_DAY));
        c.set(Calendar.MINUTE, c.getActualMinimum(Calendar.MINUTE));
        c.set(Calendar.SECOND, c.getActualMinimum(Calendar.SECOND));
        c.set(Calendar.MILLISECOND, c.getActualMinimum(Calendar.MILLISECOND));
        Date from = c.getTime();

        c.setTime(filter.getTill());
        c.set(Calendar.HOUR_OF_DAY, c.getActualMaximum(Calendar.HOUR_OF_DAY));
        c.set(Calendar.MINUTE, c.getActualMaximum(Calendar.MINUTE));
        c.set(Calendar.SECOND, c.getActualMaximum(Calendar.SECOND));
        c.set(Calendar.MILLISECOND, c.getActualMaximum(Calendar.MILLISECOND));
        Date till = c.getTime();

        criteria.add(Restrictions.between("startDate", from.getTime(), till.getTime()));
    }

    if (filter.getCl() != "" && filter.getCl() != null) {
        try {
            criteria.add(querytr.translate("testClass.name", filter.getCl()));
        } catch (QueryTranslatorException e) {
            // TODO Put QueryTranslatorException into log
            e.printStackTrace();
        }
    }

    if (filter.getGr() != "" && filter.getGr() != null) {
        criteria.createAlias("groups", "groups");

        try {
            criteria.add(querytr.translate("groups.name", filter.getGr()));
        } catch (QueryTranslatorException e) {
            // TODO Put QueryTranslatorException into log
            e.printStackTrace();
        }
    }

    return criteria;
}