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.aistor.modules.cms.service.CategoryService.java

License:Open Source License

public Page<Category> find(Page<Category> page, Category category) {
    DetachedCriteria dc = categoryDao.createDetachedCriteria();
    if (category.getSite() != null && category.getSite().getId() != null) {
        dc.createAlias("site", "site");
        dc.add(Restrictions.eq("site.id", category.getSite().getId()));
    }/*from w ww  .  j  a va  2s  .  c om*/
    if (category.getParent() != null && category.getParent().getId() != null) {
        dc.createAlias("parent", "parent");
        dc.add(Restrictions.eq("parent.id", category.getParent().getId()));
    }
    if (StringUtils.isNotBlank(category.getInMenu())) {
        dc.add(Restrictions.eq("inMenu", category.getInMenu()));
    }
    dc.add(Restrictions.eq("delFlag", Category.DEL_FLAG_NORMAL));
    dc.addOrder(Order.asc("site.id")).addOrder(Order.asc("sort"));
    return categoryDao.find(page, dc);
    //      page.setSpringPage(categoryDao.findByParentId(category.getParent().getId(), page.getSpringPage()));
    //      return page;
}

---

From source file:com.aistor.modules.cms.service.CommentService.java

License:Open Source License

public Page<Comment> find(Page<Comment> page, Comment comment) {
    DetachedCriteria dc = commentDao.createDetachedCriteria();
    if (StringUtils.isNotEmpty(comment.getModule())) {
        dc.add(Restrictions.eq("module", comment.getModule()));
    }//from   w  w w .  ja  v  a 2 s  .  co m
    if (comment.getContentId() != null && comment.getContentId() > 0) {
        dc.add(Restrictions.eq("contentId", comment.getContentId()));
    }
    if (StringUtils.isNotEmpty(comment.getTitle())) {
        dc.add(Restrictions.like("title", "%" + comment.getTitle() + "%"));
    }
    dc.add(Restrictions.eq("status", comment.getStatus()));
    dc.addOrder(Order.desc("id"));
    return commentDao.find(page, dc);
}

---

From source file:com.aistor.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 w w w. j ava 2  s.  c o m*/
    if (StringUtils.isNotEmpty(guestbook.getContent())) {
        dc.add(Restrictions.like("content", "%" + guestbook.getContent() + "%"));
    }
    dc.add(Restrictions.eq("status", guestbook.getStatus()));
    dc.addOrder(Order.desc("id"));
    return guestbookDao.find(page, dc);
}

---

From source file:com.aistor.modules.cms.service.LinkService.java

License:Open Source License

public Page<Link> find(Page<Link> page, Link link) {
    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.eq("category.parent.id", category.getId()),
                    Restrictions.like("category.parentIds", "%," + category.getId() + ",%")));
            dc.add(Restrictions.eq("category.site.id", category.getSite().getId()));
            link.setCategory(category);//from w  w w  .j ava 2 s. com
        } 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", "%" + link.getTitle() + "%"));
    }
    if (link.getUser() != null && link.getUser().getId() > 0) {
        dc.add(Restrictions.eq("user.id", link.getUser().getId()));
    }
    dc.add(Restrictions.eq("status", link.getStatus()));
    dc.addOrder(Order.desc("weight"));
    dc.addOrder(Order.desc("updateDate"));
    return linkDao.find(page, dc);
}

---

From source file:com.aistor.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()));
    }//  w ww .j  a v  a 2  s . co m
    if (StringUtils.isNotEmpty(dict.getDesciption())) {
        dc.add(Restrictions.like("desciption", "%" + dict.getDesciption() + "%"));
    }
    dc.add(Restrictions.eq("delFlag", Dict.DEL_FLAG_NORMAL));
    dc.addOrder(Order.asc("type")).addOrder(Order.asc("sort"));
    return dictDao.find(page, dc);
}

---

From source file:com.aistor.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();
    if (!currentUser.isAdmin()) {
        if (user.getArea() == null || user.getArea().getId() == null) {
            user.setArea(currentUser.getArea());
        }//  ww w  .j  a v  a2 s  .c  om
        if (user.getOffice() == null || user.getOffice().getId() == null) {
            user.setOffice(currentUser.getOffice());
        }
    }
    dc.createAlias("area", "area");
    if (user.getArea() != null && user.getArea().getId() != null) {
        dc.add(Restrictions.or(Restrictions.eq("area.id", user.getArea().getId()),
                Restrictions.eq("area.parent.id", user.getArea().getId()),
                Restrictions.like("area.parentIds", "%," + user.getArea().getId() + ",%")));
    }
    dc.createAlias("office", "office");
    if (user.getOffice() != null && user.getOffice().getId() != null) {
        dc.add(Restrictions.or(Restrictions.eq("office.id", user.getOffice().getId()),
                Restrictions.eq("office.parent.id", user.getOffice().getId()),
                Restrictions.like("office.parentIds", "%," + user.getOffice().getId() + ",%")));
    }
    if (StringUtils.isNotEmpty(user.getLoginName())) {
        dc.add(Restrictions.like("loginName", "%" + user.getLoginName() + "%"));
    }
    if (StringUtils.isNotEmpty(user.getName())) {
        dc.add(Restrictions.like("name", "%" + user.getName() + "%"));
    }
    dc.add(Restrictions.eq("delFlag", User.DEL_FLAG_NORMAL));
    if (!StringUtils.isNotEmpty(page.getOrderBy())) {
        dc.addOrder(Order.asc("area.code")).addOrder(Order.asc("office.code"));
    }
    return userDao.find(page, dc);
}

---

From source file:com.benfante.minimark.blo.QuestionBo.java

License:Apache License

/**
 * Search questions by example./*from w  ww .  j a v a2s.c  o  m*/
 * 
 * @param questionBean The values for searching questions.
 * @return The list of questions matching the questionBean values.
 */
public List<Question> search(QuestionBean questionBean) {
    DetachedCriteria crit = null;
    if (StringUtils.isBlank(questionBean.getType())) {
        crit = DetachedCriteria.forClass(Question.class);
    } else {
        if ("open".equals(questionBean.getType())) {
            crit = DetachedCriteria.forClass(OpenQuestion.class);
            if (StringUtils.isNotBlank(questionBean.getVisualization())) {
                crit.add(Restrictions.eq("visualization", questionBean.getVisualization()));
            }
        } else if ("closed".equals(questionBean.getType())) {
            crit = DetachedCriteria.forClass(ClosedQuestion.class);
        } else {
            throw new IllegalArgumentException("Unknown question type (" + questionBean.getType() + ")");
        }
    }
    if (StringUtils.isNotBlank(questionBean.getTitle())) {
        crit.add(Restrictions.ilike("title", questionBean.getTitle(), MatchMode.ANYWHERE));
    }
    if (questionBean.getWeight() != null) {
        crit.add(Restrictions.eq("weight", questionBean.getWeight()));
    }
    if (questionBean.getCourse() != null && questionBean.getCourse().getId() != null) {
        crit.add(Restrictions.eq("course.id", questionBean.getCourse().getId()));
    }
    crit.addOrder(Order.asc("title"));
    crit.addOrder(Order.asc("content"));
    if (StringUtils.isNotBlank(questionBean.getTags())) {
        crit.createAlias("tags", "tags");
        crit.createAlias("tags.tag", "tag");
        crit.add(Restrictions.in("tag.name", questionBean.getTagList()));
    }
    crit.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
    return questionDao.searchByCriteria(crit);
}

---

From source file:com.benfante.minimark.blo.UserProfileBo.java

License:Apache License

/**
 * Search all users associated with at least one course.
 *
 * @return The list of all teachers/*from ww  w . j  a va2s  .c  o m*/
 */
public List<UserProfile> searchAllTeachers() {
    DetachedCriteria crit = DetachedCriteria.forClass(UserProfile.class);
    crit.add(Restrictions.isNotEmpty("courseTeachers"));
    crit.addOrder(Order.asc("name"));
    return userProfileDao.searchByCriteria(crit);
}

---

From source file:com.cai310.lottery.service.lottery.keno.impl.KenoServiceImpl.java

@Transactional(readOnly = true)
public List<I> getCanOpenResults() {
    DetachedCriteria criteria = DetachedCriteria.forClass(issueDataDao.getEntityClass());
    criteria.add(Restrictions.lt("endedTime", new Date()));
    criteria.add(Restrictions.gt("endedTime", DateUtils.addDays(new Date(), -1)));
    criteria.add(Restrictions.eq("state", IssueState.ISSUE_SATE_END));
    criteria.addOrder(Order.desc("id"));
    return issueDataDao.findByDetachedCriteria(criteria, true);
}

---

From source file:com.cai310.lottery.service.lottery.keno.impl.KenoServiceImpl.java

@Transactional(readOnly = true)
public S getLastChaseScheme(long chaseId) {
    DetachedCriteria detachedCriteria = DetachedCriteria.forClass(this.schemeDao.getEntityClass());
    detachedCriteria.add(Restrictions.eq("chaseId", chaseId));
    detachedCriteria.addOrder(Order.desc("id"));
    List<S> schemeList = this.schemeDao.findByDetachedCriteria(detachedCriteria, 0, 1, true);
    if (schemeList != null && schemeList.size() > 0) {
        return schemeList.get(0);
    }/*from  w  w  w  .j a v a  2  s .c om*/
    return null;
}

---

• «
• 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
• »