Example usage for org.hibernate.criterion DetachedCriteria addOrder

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

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. DetachedCriteria
  6. addOrder

Introduction

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

Prototype

public DetachedCriteria addOrder(Order order)

Source Link

Document

Adds an ordering

Usage

From source file:com.sapienter.jbilling.server.metafields.db.MetaFieldGroupDAS.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<MetaFieldGroup> getAvailableFieldGroups(Integer entityId, EntityType entityType) {
    DetachedCriteria query = DetachedCriteria.forClass(MetaFieldGroup.class);
    query.add(Restrictions.eq("entityId", entityId));
    query.add(Restrictions.eq("entityType", entityType));
    query.add(Restrictions.eq("class", MetaFieldGroup.class));
    query.addOrder(Order.asc("displayOrder"));
    return (List<MetaFieldGroup>) getHibernateTemplate().findByCriteria(query);
}

From source file:com.sapienter.jbilling.server.metafields.db.MetaFieldGroupDAS.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<MetaFieldGroup> getAllAvailableFieldGroups(Integer entityId) {
    DetachedCriteria query = DetachedCriteria.forClass(MetaFieldGroup.class);
    query.add(Restrictions.eq("entityId", entityId));
    query.addOrder(Order.asc("displayOrder"));
    return (List<MetaFieldGroup>) getHibernateTemplate().findByCriteria(query);
}

From source file:com.sccl.attech.modules.mobile.service.UpdateFileService.java

License:Open Source License

public Page<UpdateFile> find(Page<UpdateFile> page, UpdateFile updateFile) {
    if (logger.isDebugEnabled()) {
        logger.debug("find(Page<UpdateFile>=" + page + ", UpdateFile=" + updateFile + ") - ");
    }// ww  w .j a va 2  s.  c o m

    DetachedCriteria dc = updateFileDao.createDetachedCriteria();
    if (StringUtils.isNotEmpty(updateFile.getName())) {
        dc.add(Restrictions.eq("name", updateFile.getName()));
    }
    if (StringUtils.isNotEmpty(updateFile.getVersion())) {
        dc.add(Restrictions.eq("version", updateFile.getVersion()));
    }
    if (StringUtils.isNotEmpty(updateFile.getType())) {
        dc.add(Restrictions.eq("type", updateFile.getType()));
    }
    if (StringUtils.isNotEmpty(updateFile.getPath())) {
        dc.add(Restrictions.eq("path", updateFile.getPath()));
    }
    if (StringUtils.isNotEmpty(updateFile.getUrl())) {
        dc.add(Restrictions.eq("url", updateFile.getUrl()));
    }
    dc.add(Restrictions.eq(UpdateFile.FIELD_DEL_FLAG, UpdateFile.DEL_FLAG_NORMAL));
    dc.addOrder(Order.desc("updateDate"));
    Page<UpdateFile> returnPage = updateFileDao.find(page, dc);

    if (logger.isDebugEnabled()) {
        logger.debug("find(Page<UpdateFile>=" + page + ", UpdateFile=" + updateFile + ") - ? - ="
                + page);
    }
    return returnPage;
}

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

License:Open Source License

/**
 * ?//from ww w .  ja v a2s.c  o m
 * @param area
 * @return
 */
public List<Area> getList(Area area) {
    DetachedCriteria dc = areaDao.createDetachedCriteria();
    if (StringUtils.isNotEmpty(area.getName())) {
        dc.add(Restrictions.like("name", "%" + area.getName() + "%"));
    }
    dc.add(Restrictions.eq(Area.FIELD_DEL_FLAG, Area.DEL_FLAG_NORMAL));
    dc.addOrder(Order.asc("code"));
    return areaDao.find(dc);
}

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

License:Open Source License

/**
 * ?/*w  w  w .j av a2s  .c o  m*/
 * @param dict
 * @return
 */
public List<Dict> getDicts(Dict dict) {
    DetachedCriteria dc = dictDao.createDetachedCriteria();
    if (StringUtils.isNotEmpty(dict.getLabel())) {
        dc.add(Restrictions.like("label", "%" + dict.getLabel() + "%"));
    }
    if (StringUtils.isNotEmpty(dict.getType())) {
        dc.add(Restrictions.like("type", "%" + dict.getType() + "%"));
    }
    if (StringUtils.isNotEmpty(dict.getDescription())) {
        dc.add(Restrictions.like("description", "%" + dict.getDescription() + "%"));
    }
    dc.add(Restrictions.eq(Dict.FIELD_DEL_FLAG, Dict.DEL_FLAG_NORMAL));
    dc.addOrder(Order.asc("type")).addOrder(Order.asc("sort"));
    return dictDao.find(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   w ww.  j av  a 2s  .  c o  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

/**
 * ?/*from  w  ww .j a v a 2  s.  com*/
 * @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/*from  www .  j  a v  a  2  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 w  w  w  .  j av a2s . 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

/**
 * //www .j  a  va  2  s .com
 * @param vote
 * @return
 */
public Page<Vote> find(Page<Vote> page, Vote vote, int type) {
    //System.out.println(page.getPageNo() + "---------------- ?count");
    //System.out.println(page.getPageSize() + "----------------?size");
    DetachedCriteria dc = voteDao.createDetachedCriteria();

    //      dc.createAlias("createBy.office", "office");
    //      dc.add(dataScopeFilter(user, "office", "createBy"));
    if (type == 0) {//
        if (StringUtils.isNotEmpty(vote.getVotingContent())) {
            dc.add(Restrictions.like("votingContent", "%" + vote.getVotingContent() + "%"));
        }
        dc.add(Restrictions.eq(Vote.FIELD_DEL_FLAG, Vote.DEL_FLAG_NORMAL));
        System.out.println("0");
    } else if (type == 1) {//
        dc.add(Restrictions.eq(Vote.SEL_ISEND, Vote.IS_END_NO));
        dc.add(Restrictions.ge(Vote.SEL_DEADLINE, Vote.SEl_DATE));
        System.out.println("1");
    } else if (type == 2) {//
        dc.add(Restrictions.eq(Vote.SEL_ISEND, Vote.IS_END_YES));
        System.out.println("2");
    } else if (type == 3) {//?
        dc.add(Restrictions.lt(Vote.SEL_DEADLINE, Vote.SEl_DATE));
        System.out.println("3");
    } else if (type == 4) {//?
        if (StringUtils.isNotEmpty(vote.getVotingContent())) {
            dc.add(Restrictions.like("votingContent", "%" + vote.getVotingContent() + "%"));
        }
        dc.add(Restrictions.eq(Vote.SEL_ISEND, Vote.IS_END_NO));
        dc.add(Restrictions.ge(Vote.SEL_DEADLINE, Vote.SEl_DATE));
        //??
        User user = UserUtils.getUser();
        DetachedCriteria dc2 = userVoteDao.createDetachedCriteria();
        dc2.add(Restrictions.eq(UserVote.USER_VOTE_USER_ID, user.getId()));
        List<UserVote> list = userVoteDao.find(dc2);
        //?
        for (UserVote ut : list) {
            dc.add(Restrictions.ne(Vote.VOTE_ID, ut.getVoteId()));
        }
    } else if (type == 5) {//??
        if (StringUtils.isNotEmpty(vote.getVotingContent())) {
            dc.add(Restrictions.like("votingContent", "%" + vote.getVotingContent() + "%"));
        }
        User user = UserUtils.getUser();
        DetachedCriteria dc2 = userVoteDao.createDetachedCriteria();
        dc2.add(Restrictions.eq(UserVote.USER_VOTE_USER_ID, user.getId()));
        List<UserVote> list = userVoteDao.find(dc2);
        List<String> list1 = new ArrayList();
        for (UserVote uVote : list) {
            list1.add(uVote.getVoteId());
        }
        dc.add(Restrictions.in(Vote.VOTE_ID, list1));
    }
    dc.addOrder(Order.desc("createDate"));
    return voteDao.find(page, dc);
}