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:org.linagora.linshare.core.repository.hibernate.RecipientFavouriteRepositoryImpl.java

License:Open Source License

public String getElementWithMaxWeight(User u) throws LinShareNotSuchElementException {

    DetachedCriteria det = DetachedCriteria.forClass(RecipientFavourite.class);
    det.add(Restrictions.eq("owner", u));
    det.addOrder(Order.desc("weight"));
    List<RecipientFavourite> listElement = findByCriteria(det);

    if (listElement == null || listElement.isEmpty()) {
        throw new LinShareNotSuchElementException("the owner has no recipient associated ");
    }//  w w  w .j a  v  a  2s  .c  o  m

    return listElement.get(0).getRecipient();
}

From source file:org.linagora.linshare.core.repository.hibernate.RecipientFavouriteRepositoryImpl.java

License:Open Source License

public List<String> getElementsOrderByWeight(User u) {
    DetachedCriteria det = DetachedCriteria.forClass(RecipientFavourite.class);
    det.add(Restrictions.eq("owner", u));
    det.addOrder(Order.asc("weight"));
    List<RecipientFavourite> listElement = findByCriteria(det);

    return transformRecipientFavouriteToRecipient(listElement);
}

From source file:org.linagora.linshare.core.repository.hibernate.RecipientFavouriteRepositoryImpl.java

License:Open Source License

public List<String> getElementsOrderByWeightDesc(User u) {
    DetachedCriteria det = DetachedCriteria.forClass(RecipientFavourite.class);
    det.add(Restrictions.eq("owner", u));
    det.addOrder(Order.desc("weight"));

    List<RecipientFavourite> listElement = findByCriteria(det);

    return transformRecipientFavouriteToRecipient(listElement);
}

From source file:org.linagora.linshare.core.repository.hibernate.RecipientFavouriteRepositoryImpl.java

License:Open Source License

public List<String> reorderElementsByWeightDesc(List<String> elements, User owner) {
    DetachedCriteria det = DetachedCriteria.forClass(RecipientFavourite.class);
    det.add(Restrictions.eq("owner", owner));
    det.add(Restrictions.in("recipient", elements));
    det.addOrder(Order.desc("weight"));
    List<RecipientFavourite> recipients = findByCriteria(det);

    return reorderElement(elements, recipients);

}

From source file:org.linagora.linshare.core.repository.hibernate.RecipientFavouriteRepositoryImpl.java

License:Open Source License

public List<String> findMatchElementsOrderByWeight(String matchStartWith, User owner) {
    DetachedCriteria det = DetachedCriteria.forClass(RecipientFavourite.class);
    det.add(Restrictions.eq("owner", owner));
    det.add(Restrictions.ilike("recipient", matchStartWith, MatchMode.ANYWHERE));
    det.addOrder(Order.desc("weight"));
    List<RecipientFavourite> recipients = findByCriteria(det);

    ArrayList<String> mails = new ArrayList<String>();

    for (RecipientFavourite recipientFavour : recipients) {
        mails.add(recipientFavour.getRecipient());
    }/*from   ww  w  . j  a  va2  s.c om*/
    return mails;
}

From source file:org.linagora.linshare.core.repository.hibernate.ThreadRepositoryImpl.java

License:Open Source License

@Override
public List<Thread> findLatestWhereMember(User actor, int limit) {
    DetachedCriteria det = DetachedCriteria.forClass(Thread.class);
    det.add(Restrictions.eq("destroyed", false));

    if (limit < 1)
        limit = 1;/*www .ja  v  a 2s  .c  om*/
    // query
    det.createAlias("myMembers", "member");
    det.add(Restrictions.eq("member.user", actor));
    det.addOrder(Order.desc("modificationDate"));
    return findByCriteria(det, limit);
}

From source file:org.linagora.linshare.core.repository.hibernate.ThreadRepositoryImpl.java

License:Open Source License

@Override
public List<Thread> searchByName(User actor, String pattern) {
    DetachedCriteria det = DetachedCriteria.forClass(Thread.class);
    det.add(Restrictions.eq("destroyed", false));

    // query//w  ww.j av a 2  s.c  o m
    det.createAlias("myMembers", "member");
    if (!actor.isSuperAdmin())
        det.add(Restrictions.eq("member.user", actor));
    det.addOrder(Order.desc("modificationDate"));
    det.add(Restrictions.ilike("name", pattern, ANYWHERE));
    return findByCriteria(det);
}

From source file:org.molasdin.wbase.hibernate.cursor.BasicHibernateCursor.java

License:Apache License

@Override
@SuppressWarnings("unchecked")
public List<T> dataCallback(Session session) {
    DetachedCriteria criteria = searchSpecification().query();
    List<Pair<String, org.molasdin.wbase.storage.Order>> orders = orders();
    if (!orders.isEmpty()) {
        for (Pair<String, org.molasdin.wbase.storage.Order> order : orders) {
            String prop = translateProperty(order.getLeft());
            criteria.addOrder(org.molasdin.wbase.storage.Order.ASC.equals(order.getRight())
                    ? org.hibernate.criterion.Order.asc(prop)
                    : org.hibernate.criterion.Order.desc(prop));
        }/*www . j av  a 2 s.  com*/
    }

    criteria.add(populateFilters(searchSpecification().filterModes()));
    return postProcessData((List<T>) criteria.getExecutableCriteria(session)
            .setFirstResult(calculatedRowOffset()).setMaxResults(pageSize()).list());
}

From source file:org.mvnsearch.snippet.domain.Category.java

License:Open Source License

/**
 * get all category in current category, recursive not support
 *
 * @return snippet list//from w  ww .jav  a 2  s .  c om
 */
@SuppressWarnings({ "unchecked" })
public List<Snippet> findSnippets() {
    DetachedCriteria criteria = DetachedCriteria.forClass(Snippet.class);
    criteria.add(Restrictions.eq("categoryId", id));
    criteria.addOrder(Order.desc("createdAt"));
    return getHibernateTemplate().findByCriteria(criteria);
}

From source file:org.mvnsearch.snippet.domain.Category.java

License:Open Source License

/**
 * get children categories//from w  w w . j ava 2s .com
 *
 * @return category list
 */
@SuppressWarnings({ "unchecked" })
public List<Category> getChildrenCategories() {
    DetachedCriteria criteria = DetachedCriteria.forClass(Category.class);
    criteria.add(Restrictions.eq("parentId", id));
    criteria.addOrder(Order.asc("name"));
    return getHibernateTemplate().findByCriteria(criteria);
}