Example usage for org.hibernate.criterion DetachedCriteria 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.isdemu.dao.impl.TB_InventarioDaoImpl.java

@Override
public List LastCodInventario(Serializable id) {
    DetachedCriteria dc = DetachedCriteria.forClass(TbInventario.class, "inv");
    dc.createAlias("inv.tbcClaseActivo", "clase");
    dc.add(Restrictions.eq("clase.idClaseActivo", id));
    dc.addOrder(Order.desc("idInventario"));

    return dc.getExecutableCriteria(sessionFactory.getCurrentSession()).list();
}

---

From source file:com.isdemu.dao.impl.TB_MovimientoDaoImp.java

@Override
public List LastIdMovimiento() {
    DetachedCriteria dc = DetachedCriteria.forClass(TbMovimiento.class, "mov");

    dc.addOrder(Order.desc("idMovimiento"));

    return dc.getExecutableCriteria(sessionFactory.getCurrentSession()).list();
}

---

From source file:com.isdemu.dao.impl.TB_PrestamoDaoImpl.java

@Override
public List LastIdPrestamo() {
    DetachedCriteria dc = DetachedCriteria.forClass(TbPrestamoEquipo.class, "pre");

    dc.addOrder(Order.desc("idPrestamoEquipo"));

    return dc.getExecutableCriteria(sessionFactory.getCurrentSession()).list();
}

---

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

License:Open Source License

public Page<Article> find(Page<Article> page, Article article, boolean isDataScopeFilter) {
    // ??6??//from   w  ww  . ja  va2 s  .  c  o  m
    Date updateExpiredWeightDate = (Date) CacheUtils.get("updateExpiredWeightDateByArticle");
    if (updateExpiredWeightDate == null
            || (updateExpiredWeightDate != null && updateExpiredWeightDate.getTime() < new Date().getTime())) {
        articleDao.updateExpiredWeight();
        CacheUtils.put("updateExpiredWeightDateByArticle", DateUtils.addHours(new Date(), 6));
    }
    DetachedCriteria dc = articleDao.createDetachedCriteria();
    dc.createAlias("category", "category");
    dc.createAlias("category.site", "category.site");
    if (article.getCategory() != null && article.getCategory().getId() != null
            && !Category.isRoot(article.getCategory().getId())) {
        Category category = categoryDao.findOne(article.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()));
            article.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(article.getTitle())) {
        dc.add(Restrictions.like("title", "%" + EscapeUtil.escapeLike(article.getTitle()) + "%"));
    }
    if (StringUtils.isNotEmpty(article.getPosid())) {
        dc.add(Restrictions.like("posid", "%," + article.getPosid() + ",%"));
    }
    if (StringUtils.isNotEmpty(article.getImage()) && Article.YES.equals(article.getImage())) {
        dc.add(Restrictions.and(Restrictions.isNotNull("image"), Restrictions.ne("image", "")));
    }
    if (article.getCreateBy() != null && article.getCreateBy().getId() > 0) {
        dc.add(Restrictions.eq("createBy.id", article.getCreateBy().getId()));
    }
    if (isDataScopeFilter) {
        dc.createAlias("category.office", "categoryOffice").createAlias("createBy", "createBy");
        dc.add(dataScopeFilter(UserUtils.getUser(), "categoryOffice", "createBy"));
    }
    dc.add(Restrictions.eq(Article.DEL_FLAG, article.getDelFlag()));
    if (StringUtils.isBlank(page.getOrderBy())) {
        dc.addOrder(Order.desc("weight"));
        dc.addOrder(Order.desc("updateDate"));
    }
    return articleDao.find(page, dc);
}

---

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

License:Open Source License

public Page<Comment> find(Page<Comment> page, Comment comment) {
    DetachedCriteria dc = commentDao.createDetachedCriteria();
    if (comment.getContentId() != null && comment.getContentId() > 0) {
        dc.add(Restrictions.eq("contentId", comment.getContentId()));
    }//from w w w  .  j a  v  a 2s.  com
    if (StringUtils.isNotEmpty(comment.getTitle())) {
        dc.add(Restrictions.like("title", "%" + EscapeUtil.escapeLike(comment.getTitle()) + "%"));
    }
    dc.add(Restrictions.eq(Comment.DEL_FLAG, comment.getDelFlag()));
    dc.addOrder(Order.desc("id"));
    return commentDao.find(page, dc);
}

---

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

License:Open Source License

public Page<Guestbook> find(Page<Guestbook> page, Guestbook guestbook) {
    DetachedCriteria dc = guestbookDao.createDetachedCriteria();
    if (StringUtils.isNotEmpty(guestbook.getType())) {
        dc.add(Restrictions.eq("type", guestbook.getType()));
    }/*from  ww w .  ja  v  a  2 s . c  om*/
    if (StringUtils.isNotEmpty(guestbook.getContent())) {
        dc.add(Restrictions.like("content", "%" + EscapeUtil.escapeLike(guestbook.getContent()) + "%"));
    }
    dc.add(Restrictions.eq(Guestbook.DEL_FLAG, guestbook.getDelFlag()));
    dc.addOrder(Order.desc("id"));
    return guestbookDao.find(page, dc);
}

---

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 w  w .j av a  2  s. c  om*/
    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.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  www . j  ava 2  s .c  o  m
    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   www  .j  av  a  2s. co m*/

    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   www. j ava  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);
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »