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.sccl.attech.modules.sys.service.GroupService.java

License:Open Source License

public Page<Grouping> findGroup(Page<Grouping> page, Grouping group) {

    DetachedCriteria dc = groupDao.createDetachedCriteria();
    dc.add(Restrictions.sqlRestriction("del_flag=0"));
    return groupDao.find(page, dc);
}

From source file:com.sccl.attech.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 ww  w  .  ja  v  a 2 s  . co m*/
    String type = ObjectUtils.toString(paramMap.get("type"));
    if ("0".equals(type)) {//???
        dc.add(Restrictions.eq("type", type));
    } else {
        String manageName = ObjectUtils.toString(paramMap.get("manageName"));
        if (StringUtils.isNotBlank(manageName)) {
            dc.createAlias("createBy", "createBy");
            dc.add(Restrictions.like("createBy.name", "%" + EncodedUtil.decodeValue(manageName) + "%"));
        }
        dc.createAlias("company", "company");
        String companyId = ObjectUtils.toString(paramMap.get("companyId"));
        if (StringUtils.isNotBlank(companyId)) {

            dc.add(Restrictions.eq("company.id", companyId));
        }

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

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

        if (StringUtils.isNotBlank(type)) {
            dc.add(Restrictions.eq("type", type));
        }

        Date beginDate = DateUtils.parseDate(paramMap.get("start"));
        if (beginDate == null) {
            beginDate = DateUtils.setDays(new Date(), 1);
            paramMap.put("beginDate", DateUtils.formatDate(beginDate, "yyyy-MM-dd"));
        }
        Date endDate = DateUtils.parseDate(paramMap.get("end"));
        if (endDate == null) {
            endDate = DateUtils.addDays(DateUtils.addMonths(beginDate, 1), -1);
            paramMap.put("endDate", DateUtils.formatDate(endDate, "yyyy-MM-dd"));
        }
        dc.createAlias("office", "office");
        User currentUser = UserUtils.getUser();
        dc.add(Restrictions.or(dataScopeFilter(currentUser, "office", "createBy"),
                Restrictions.eq("type", "0")));
        dc.add(Restrictions.between("createDate", beginDate, endDate));
    }
    dc.addOrder(Order.desc("createDate"));
    return logDao.find(page, dc);
}

From source file:com.sccl.attech.modules.sys.service.LogService.java

License:Open Source License

/**
 * ?/*w ww.  j a v a  2s  .  c o m*/
 * @param paramMap
 * @return
 */
public List<Log> getList(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));
    }
    String manageName = ObjectUtils.toString(paramMap.get("manageName"));
    if (StringUtils.isNotBlank(manageName)) {
        dc.createAlias("createBy", "createBy");
        dc.add(Restrictions.like("createBy.name", EncodedUtil.decodeValue(manageName)));
    }

    String requestUri = ObjectUtils.toString(paramMap.get("requestUri"));
    if (StringUtils.isNotBlank(requestUri)) {
        dc.add(Restrictions.like("requestUri", "%" + 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("start"));
    if (beginDate == null) {
        beginDate = DateUtils.setDays(new Date(), 1);
        paramMap.put("beginDate", DateUtils.formatDate(beginDate, "yyyy-MM-dd"));
    }
    Date endDate = DateUtils.parseDate(paramMap.get("end"));
    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("createDate"));
    return logDao.find(dc);
}

From source file:com.sccl.attech.modules.sys.service.OfficeService.java

License:Open Source License

/**
 * ? office//  www . j  a  v  a2  s  .c  o  m
 * @author luoyang
 * @param type 1?23?
 * @return office?
 */
public List<Office> findAllByType(String type) {
    DetachedCriteria dc = officeDao.createDetachedCriteria();
    if (StringUtils.isNotBlank(type)) {
        dc.add(Restrictions.eq("type", type));
    }
    dc.add(Restrictions.eq(Office.FIELD_DEL_FLAG, Office.DEL_FLAG_NORMAL));
    dc.addOrder(Order.asc("sort"));

    return officeDao.find(dc);
}

From source file:com.sccl.attech.modules.sys.service.OfficeService.java

License:Open Source License

public Page<Office> find(Page<Office> page, Office office) {
    User user = UserUtils.getUser();//from  www .j a va2  s. c om
    //      if (user.isAdmin()){
    //         officeList = officeDao.findAllList();
    //      }else{
    //         officeList = officeDao.findAllChild(user.getOffice().getId(), "%,"+user.getOffice().getId()+",%");
    //      }

    DetachedCriteria dc = officeDao.createDetachedCriteria();
    //      if (StringUtils.isNotEmpty(office.getName())){
    //         dc.add(Restrictions.like("name", "%"+office.getName()+"%"));
    //      }
    dc.add(dataScopeFilter(user, "office", "createBy"));//??
    dc.add(Restrictions.eq(Office.FIELD_DEL_FLAG, Office.DEL_FLAG_NORMAL));
    dc.addOrder(Order.desc("id"));
    return officeDao.find(page, dc);
}

From source file:com.sccl.attech.modules.sys.service.SystemService.java

License:Open Source License

/**
 * ?ids/* w ww  .ja va 2 s . com*/
 * @param ids 
 * @return
 */
public List<User> findShowAddress(String ids) {

    ids = ids.substring(0, ids.lastIndexOf(","));
    String[] array = ids.split(",");
    DetachedCriteria dc = userDao.createDetachedCriteria();
    dc.add(Restrictions.in("id", array));
    dc.add(Restrictions.eq(User.FIELD_DEL_FLAG, User.DEL_FLAG_NORMAL));
    List<User> list = userDao.find(dc);

    return list;
}

From source file:com.sccl.attech.modules.sys.service.SystemService.java

License:Open Source License

/**
 * ??/*from ww w.ja  va 2  s .  co m*/
 * @param user
 * @return
 */
public List<User> findAllUserConditon(User user) {

    DetachedCriteria dc = userDao.createDetachedCriteria();
    dc.add(Restrictions.eq("userType", "2"));
    User currentUser = UserUtils.getUser();
    dc.createAlias("office", "office");
    dc.add(dataScopeFilter(currentUser, "office", "createBy"));
    dc.add(Restrictions.eq(User.FIELD_DEL_FLAG, User.DEL_FLAG_NORMAL));

    return userDao.find(dc);
}

From source file:com.sccl.attech.modules.sys.service.SystemService.java

License:Open Source License

/**
 * ??// w  w w .j  av a  2  s.co m
 * @param user
 * @return
 */
public List<User> findAllUserConditonAll(User user) {

    DetachedCriteria dc = userDao.createDetachedCriteria();
    //dc.add(Restrictions.eq("userType", "2"));
    User currentUser = UserUtils.getUser();
    dc.createAlias("office", "office");
    dc.add(dataScopeFilter(currentUser, "office", "createBy"));
    dc.add(Restrictions.eq(User.FIELD_DEL_FLAG, User.DEL_FLAG_NORMAL));

    return userDao.find(dc);
}

From source file:com.sccl.attech.modules.sys.service.SystemService.java

License:Open Source License

/**
 * ?/* w  w  w  . j  av a2 s .  c  om*/
 * @return
 * /
        
/**
 * ??
 * @return
 */
public List<User> getListByCompany() {
    User user = UserUtils.getUser();
    DetachedCriteria dc = userDao.createDetachedCriteria();
    dc.createAlias("company", "company");
    if (user.getCompany() != null && StringUtils.isNotBlank(user.getCompany().getId())) {
        dc.add(Restrictions.eq("company.id", user.getCompany().getId()));
    }
    dc.add(Restrictions.eq(User.FIELD_DEL_FLAG, User.DEL_FLAG_NORMAL));
    return userDao.find(dc);
}