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.itrus.ca.modules.sys.service.OfficeService.java

License:Open Source License

public List<Office> findByParentIds(List<Long> areaIds) {
    DetachedCriteria dc = officeDao.createDetachedCriteria();
    if (areaIds == null) {
        return null;
    }//from   ww  w.  java  2  s  .  com
    if (areaIds != null) {

        if (StringUtils.isNotEmpty(areaIds.toString())) {
            dc.add(Restrictions.in("parent.id", areaIds));
        } 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);
}

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

License:Open Source License

/**
 * ?/*from  w  w  w  .  jav a 2 s.c o m*/
* @Title: findOfficesByParentId
* @Description: TODO(????)
* @param @param areaId
* @param @return    
* @return List<Office>    
* @throws
 */
public List<Office> findOfficesByParentId(Long areaId) {
    DetachedCriteria dc = officeDao.createDetachedCriteria();
    if (StringUtils.isNotEmpty(areaId.toString())) {
        dc.add(Restrictions.eq("parent.id", areaId));
    }
    dc.add(Restrictions.eq("type", "2"));
    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, Integer type) {
    DetachedCriteria dc = officeDao.createDetachedCriteria();
    if (StringUtils.isNotEmpty(areaId.toString())) {
        dc.add(Restrictions.eq("parent.id", areaId));
    }/*from w w  w . j a v  a  2  s.  com*/
    dc.add(Restrictions.eq("type", String.valueOf(type)));
    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> findByIds(Page<Office> page, List<Long> officeIds) {
    DetachedCriteria dc = officeDao.createDetachedCriteria();
    if (officeIds.size() > 0) {
        dc.add(Restrictions.in("id", officeIds));
    }/*from  w  w  w  .ja va2 s  .  c o m*/
    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> selectArea(String areaName) {
    DetachedCriteria dc = officeDao.createDetachedCriteria();
    dc.add(Restrictions.eq("name", areaName));
    dc.add(Restrictions.eq(Office.DEL_FLAG, Office.DEL_FLAG_NORMAL));
    return officeDao.find(dc);
}

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

License:Open Source License

@Transactional(readOnly = false)
public List<Office> getOfficeList(Integer type) {
    List<Office> officeList = null;
    //User user = getUser();
    DetachedCriteria dc = officeDao.createDetachedCriteria();
    //dc.add(dataScopeFilter(user, dc.getAlias(), ""));
    dc.add(Restrictions.eq("delFlag", Office.DEL_FLAG_NORMAL));
    dc.add(Restrictions.eq("type", type.toString()));
    dc.addOrder(Order.asc("code"));
    officeList = officeDao.find(dc);/*  ww  w .j  a  va2s  .c  om*/
    return officeList;
}

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

License:Open Source License

public Page<User> findUser(Page<User> page, User user) {
    DetachedCriteria dc = userDao.createDetachedCriteria();
    User currentUser = UserUtils.getUser();
    dc.createAlias("company", "company");
    if (user.getCompany() != null && user.getCompany().getId() != null) {
        dc.add(Restrictions.or(Restrictions.eq("company.id", user.getCompany().getId()),
                Restrictions.like("company.parentIds", "%," + user.getCompany().getId() + ",%")));
    }//  www  .j  av a  2  s. c  o m
    dc.createAlias("office", "office");
    if (user.getOffice() != null && user.getOffice().getId() != null) {
        dc.add(Restrictions.or(Restrictions.eq("office.id", user.getOffice().getId()),
                Restrictions.like("office.parentIds", "%," + user.getOffice().getId() + ",%")));
    }
    // ????
    if (!currentUser.isAdmin()) {
        dc.add(Restrictions.ne("id", 1L));
    }
    dc.add(dataScopeFilter(currentUser, "office", ""));
    //System.out.println(dataScopeFilterString(currentUser, "office", ""));
    if (StringUtils.isNotEmpty(user.getLoginName())) {
        dc.add(Restrictions.like("loginName", "%" + EscapeUtil.escapeLike(user.getLoginName()) + "%"));
    }
    if (StringUtils.isNotEmpty(user.getName())) {
        dc.add(Restrictions.like("name", "%" + EscapeUtil.escapeLike(user.getName()) + "%"));
    }
    dc.add(Restrictions.eq(User.DEL_FLAG, User.DEL_FLAG_NORMAL));
    //      if (!StringUtils.isNotEmpty(page.getOrderBy())){
    //         dc.addOrder(Order.asc("company.code")).addOrder(Order.asc("office.code")).addOrder(Order.desc("id"));
    //      }
    return userDao.find(page, dc);
}

From source file:com.itrus.ca.modules.sys.utils.UserUtils.java

License:Open Source License

public static List<Office> getOfficeList() {
    @SuppressWarnings("unchecked")
    List<Office> officeList = null;
    if (officeList == null) {
        User user = getUser();//from   w  ww  .  j a v a  2  s.  co m
        DetachedCriteria dc = officeDao.createDetachedCriteria();
        dc.add(dataScopeFilter(user, dc.getAlias(), ""));
        dc.add(Restrictions.eq("delFlag", Office.DEL_FLAG_NORMAL));
        dc.addOrder(Order.asc("code"));
        officeList = officeDao.find(dc);
        putCache(CACHE_OFFICE_LIST, officeList);
    }
    return officeList;
}

From source file:com.itrus.ca.modules.sys.utils.UserUtils.java

License:Open Source License

public static List<Office> getOfficeList(Integer type) {
    @SuppressWarnings("unchecked")
    List<Office> officeList = null;
    DetachedCriteria dc = officeDao.createDetachedCriteria();
    dc.add(Restrictions.eq("delFlag", Office.DEL_FLAG_NORMAL));
    dc.add(Restrictions.eq("type", type.toString()));
    dc.addOrder(Order.asc("code"));
    officeList = officeDao.find(dc);//from  w  w  w  . j  a va 2s . co  m
    putCache(CACHE_OFFICE_LIST, officeList);
    return officeList;
}

From source file:com.jaspersoft.jasperserver.api.engine.common.service.impl.HibernateLoggingService.java

License:Open Source License

@Transactional(propagation = Propagation.REQUIRED)
public List getUserEvents(ExecutionContext context) {
    List<RepoLogEvent> events;
    RepoUser user = userHandler.getPersistentUserFromContext();
    if (user != null) {
        DetachedCriteria criteria = DetachedCriteria.forClass(RepoLogEvent.class);
        criteria.add(Restrictions.eq("user", user));
        criteria.addOrder(Order.desc("occurrenceDate"));

        //noinspection unchecked
        events = getHibernateTemplate().findByCriteria(criteria);
    } else {//  w  w  w .j  a v a2s.  c  o  m
        events = Collections.emptyList();
    }

    return getClientEvents(events);
}