Example usage for org.hibernate.criterion DetachedCriteria add

List of usage examples for org.hibernate.criterion DetachedCriteria add

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. DetachedCriteria
  6. 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.itrus.ca.modules.cms.service.LinkService.java

License:Open Source License

public Page<Link> find(Page<Link> page, Link link, boolean isDataScopeFilter) {
    // ??6??/*from   w ww  .ja v  a  2  s . com*/
    Date updateExpiredWeightDate = (Date) CacheUtils.get("updateExpiredWeightDateByLink");
    if (updateExpiredWeightDate == null
            || (updateExpiredWeightDate != null && updateExpiredWeightDate.getTime() < new Date().getTime())) {
        linkDao.updateExpiredWeight();
        CacheUtils.put("updateExpiredWeightDateByLink", DateUtils.addHours(new Date(), 6));
    }
    DetachedCriteria dc = linkDao.createDetachedCriteria();
    dc.createAlias("category", "category");
    dc.createAlias("category.site", "category.site");
    if (link.getCategory() != null && link.getCategory().getId() != null
            && !Category.isRoot(link.getCategory().getId())) {
        Category category = categoryDao.findOne(link.getCategory().getId());
        if (category != null) {
            dc.add(Restrictions.or(Restrictions.eq("category.id", category.getId()),
                    Restrictions.like("category.parentIds", "%," + category.getId() + ",%")));
            dc.add(Restrictions.eq("category.site.id", category.getSite().getId()));
            link.setCategory(category);
        } else {
            dc.add(Restrictions.eq("category.site.id", Site.getCurrentSiteId()));
        }
    } else {
        dc.add(Restrictions.eq("category.site.id", Site.getCurrentSiteId()));
    }
    if (StringUtils.isNotEmpty(link.getTitle())) {
        dc.add(Restrictions.like("title", "%" + EscapeUtil.escapeLike(link.getTitle()) + "%"));
    }
    if (link.getCreateBy() != null && link.getCreateBy().getId() > 0) {
        dc.add(Restrictions.eq("createBy.id", link.getCreateBy().getId()));
    }
    if (isDataScopeFilter) {
        dc.createAlias("category.office", "categoryOffice").createAlias("createBy", "createBy");
        dc.add(dataScopeFilter(UserUtils.getUser(), "categoryOffice", "createBy"));
    }
    dc.add(Restrictions.eq(Link.DEL_FLAG, link.getDelFlag()));
    dc.addOrder(Order.desc("weight"));
    dc.addOrder(Order.desc("updateDate"));
    return linkDao.find(page, dc);
}

From source file:com.itrus.ca.modules.cms.service.SiteService.java

License:Open Source License

public Page<Site> find(Page<Site> page, Site site) {
    DetachedCriteria dc = siteDao.createDetachedCriteria();
    if (StringUtils.isNotEmpty(site.getName())) {
        dc.add(Restrictions.like("name", "%" + EscapeUtil.escapeLike(site.getName()) + "%"));
    }//from  w  w  w.j a  va 2 s.  com
    dc.add(Restrictions.eq(Site.DEL_FLAG, site.getDelFlag()));
    //dc.addOrder(Order.asc("id"));
    return siteDao.find(page, dc);
}

From source file:com.itrus.ca.modules.sys.service.DictService.java

License:Open Source License

public Page<Dict> find(Page<Dict> page, Dict dict) {
    DetachedCriteria dc = dictDao.createDetachedCriteria();
    if (StringUtils.isNotEmpty(dict.getType())) {
        dc.add(Restrictions.eq("type", dict.getType()));
    }/*from w  ww . j av  a 2 s  .c om*/
    if (StringUtils.isNotEmpty(dict.getDescription())) {
        dc.add(Restrictions.like("description", "%" + EscapeUtil.escapeLike(dict.getDescription()) + "%"));
    }
    dc.add(Restrictions.eq(Dict.DEL_FLAG, Dict.DEL_FLAG_NORMAL));
    dc.addOrder(Order.asc("type")).addOrder(Order.asc("sort")).addOrder(Order.desc("id"));
    return dictDao.find(page, dc);
}

From source file:com.itrus.ca.modules.sys.service.LogService.java

License:Open Source License

public Page<Log> find(Page<Log> page, Map<String, Object> paramMap) {
    DetachedCriteria dc = logDao.createDetachedCriteria();

    Long createById = StringUtils.toLong(paramMap.get("createById"));
    if (createById > 0) {
        dc.add(Restrictions.eq("createBy.id", createById));
    }//from   w ww .  j  a  va  2  s  .com

    String requestUri = ObjectUtils.toString(paramMap.get("requestUri"));
    if (StringUtils.isNotBlank(requestUri)) {
        dc.add(Restrictions.like("requestUri", "%" + EscapeUtil.escapeLike(requestUri) + "%"));
    }

    String exception = ObjectUtils.toString(paramMap.get("exception"));
    if (StringUtils.isNotBlank(exception)) {
        dc.add(Restrictions.eq("type", Log.TYPE_EXCEPTION));
    }

    Date beginDate = DateUtils.parseDate(paramMap.get("beginDate"));
    if (beginDate == null) {
        beginDate = DateUtils.setDays(new Date(), 1);
        paramMap.put("beginDate", DateUtils.formatDate(beginDate, "yyyy-MM-dd"));
    }
    Date endDate = DateUtils.parseDate(paramMap.get("endDate"));
    if (endDate == null) {
        endDate = DateUtils.addDays(DateUtils.addMonths(beginDate, 1), -1);
        paramMap.put("endDate", DateUtils.formatDate(endDate, "yyyy-MM-dd"));
    }
    dc.add(Restrictions.between("createDate", beginDate, endDate));

    dc.addOrder(Order.desc("id"));
    return logDao.find(page, dc);
}

From source file:com.itrus.ca.modules.sys.service.OfficeService.java

License:Open Source License

/**
 *  ??//from   w  w  w.  j a  va 2s. c  o  m
* @Title: find
* @Description: TODO(????)
* @param @param page
* @param @param office
* @param @return    
* @return Page<Office>    
* @throws
 */
public Page<Office> find(Page<Office> page, Office office) {
    User user = UserUtils.getUser();
    DetachedCriteria dc = officeDao.createDetachedCriteria();
    if (StringUtils.isNotEmpty(office.getName())) {
        dc.add(Restrictions.like("name", "%" + EscapeUtil.escapeLike(office.getName()) + "%"));
    }

    dc.add(Restrictions.eq("delFlag", DataEntity.DEL_FLAG_NORMAL));
    Office off = new Office();
    off.setId(1L);
    dc.add(Restrictions.eq("parent", off));
    //dc.add(Restrictions.eq("delFlag", Office.DEL_FLAG_NORMAL));
    dc.add(Restrictions.ne("id", 34L));
    dc.addOrder(Order.asc("code"));
    dc.addOrder(Order.desc("id"));
    return officeDao.find(page, dc);
}

From source file:com.itrus.ca.modules.sys.service.OfficeService.java

License:Open Source License

/**
 * ?//from   w  ww .  j  a  v  a  2s  .co  m
 * ?del
* @Title: findByDel
* @Description: TODO(????)
* @param @param page
* @param @param office
* @param @return    
* @return Page<Office>    
* @throws
 */
public Page<Office> findByDel(Page<Office> page, Office office) {
    User user = UserUtils.getUser();
    DetachedCriteria dc = officeDao.createDetachedCriteria();
    if (StringUtils.isNotEmpty(office.getName())) {
        dc.add(Restrictions.like("name", "%" + EscapeUtil.escapeLike(office.getName()) + "%"));
    }
    Office off = new Office();
    off.setId(1L);
    dc.add(Restrictions.ne("parent", off));
    dc.add(Restrictions.eq("delFlag", Office.DEL_FLAG_NORMAL));
    dc.add(Restrictions.ne("id", 34L));
    dc.addOrder(Order.asc("code"));
    dc.addOrder(Order.desc("id"));
    return officeDao.find(page, dc);
}

From source file:com.itrus.ca.modules.sys.service.OfficeService.java

License:Open Source License

/**
 * /*from   www  .  j a  va 2  s .co  m*/
 * @param office
 * @return
 */
public List<Office> findAllByDel(Office office) {
    User user = UserUtils.getUser();
    DetachedCriteria dc = officeDao.createDetachedCriteria();
    if (StringUtils.isNotEmpty(office.getName())) {
        dc.add(Restrictions.like("name", "%" + EscapeUtil.escapeLike(office.getName()) + "%"));
    }
    Office off = new Office();
    off.setId(1L);
    dc.add(Restrictions.ne("parent", off));
    dc.add(Restrictions.eq("delFlag", Office.DEL_FLAG_NORMAL));
    dc.add(Restrictions.ne("id", 34L));
    dc.addOrder(Order.asc("code"));
    dc.addOrder(Order.desc("id"));
    return officeDao.find(dc);
}

From source file:com.itrus.ca.modules.sys.service.OfficeService.java

License:Open Source License

public Page<Office> findOffice(Page<Office> page, Office office) {
    User user = UserUtils.getUser();/*ww  w  .  j av  a 2  s .com*/
    DetachedCriteria dc = officeDao.createDetachedCriteria();
    //      if (StringUtils.isNotEmpty(office.getName())){
    //         dc.add(Restrictions.like("name", "%"+EscapeUtil.escapeLike(office.getName())+"%"));
    //      }
    dc.add(Restrictions.eq("areaName", office.getName()));
    dc.add(Restrictions.eq("parent", office));
    //dc.add(Restrictions.eq("delFlag", Office.DEL_FLAG_NORMAL));
    dc.add(Restrictions.ne("id", 34L));
    dc.addOrder(Order.asc("code"));
    dc.addOrder(Order.desc("id"));
    return officeDao.find(page, dc);
}

From source file:com.itrus.ca.modules.sys.service.OfficeService.java

License:Open Source License

public List<Office> find(Long areaId) {
    User user = UserUtils.getUser();//from   ww  w.j  a  v a  2 s  .c o m
    DetachedCriteria dc = officeDao.createDetachedCriteria();
    if (StringUtils.isNotEmpty(areaId.toString())) {
        dc.add(Restrictions.eq("area.id", areaId));
    }
    dc.add(dataScopeFilter(user, dc.getAlias(), ""));
    dc.add(Restrictions.eq("delFlag", Office.DEL_FLAG_NORMAL));
    dc.addOrder(Order.asc("code"));
    dc.addOrder(Order.desc("id"));
    return officeDao.find(dc);
}

From source file:com.itrus.ca.modules.sys.service.OfficeService.java

License:Open Source License

public List<Office> findByParentId(Long areaId) {
    DetachedCriteria dc = officeDao.createDetachedCriteria();
    if (areaId == null) {
        return null;
    }/* w ww  .j av a  2  s .  c  o  m*/
    if (areaId != null) {

        if (StringUtils.isNotEmpty(areaId.toString())) {
            dc.add(Restrictions.eq("parent.id", areaId));
        } else {
            return null;
        }
    }
    dc.add(Restrictions.neOrIsNotNull("type", "1"));
    dc.add(Restrictions.eq("delFlag", Office.DEL_FLAG_NORMAL));
    dc.addOrder(Order.asc("code"));
    dc.addOrder(Order.desc("id"));
    return officeDao.find(dc);
}