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:gr.abiss.calipso.domain.PageDictionarySearch.java

License:Open Source License

@Override
public DetachedCriteria getDetachedCriteria() {
    DetachedCriteria criteria = DetachedCriteria.forClass(PageDictionary.class);

    if (this.pageDictionary.getPageDescription() != null) {
        criteria.add(Restrictions.ilike("pageDescription", this.pageDictionary.getPageDescription(),
                MatchMode.START));//from   w ww .jav  a  2s  .  c  o  m
    }

    if (this.pageDictionary.getPageClassName() != null) {
        criteria.add(
                Restrictions.ilike("pageClassName", this.pageDictionary.getPageClassName(), MatchMode.START));
    }

    if (this.pageDictionary.getPageClassName() != null) {
        criteria.add(
                Restrictions.ilike("localizedKey", this.pageDictionary.getLocalizedKey(), MatchMode.START));
    }

    if (isSortDescending()) {
        criteria.addOrder(Order.desc(this.sortFieldName));
    } // if
    else {
        criteria.addOrder(Order.asc(this.sortFieldName));
    } // else

    return criteria;
}

---

From source file:gr.abiss.calipso.domain.PageInforamaDocumentSearch.java

License:Open Source License

@Override
public DetachedCriteria getDetachedCriteria() {
    DetachedCriteria criteria = DetachedCriteria.forClass(PageInforamaDocument.class);

    if (this.pageInforamaDocument.getPageDictionary() != null) {
        criteria.add(Restrictions.eq("pageDictionary", this.pageInforamaDocument.getPageDictionary()));
    }//  w ww. jav  a 2s.c o m

    if (this.pageInforamaDocument.getInforamaDocument() != null) {
        criteria.add(Restrictions.eq("inforamaDocument", this.pageInforamaDocument.getPageDictionary()));
    }

    if (this.pageInforamaDocument.getCommandDescription() != null) {
        criteria.add(Restrictions.ilike("commandDescription", this.pageInforamaDocument.getCommandDescription(),
                MatchMode.START));
    }

    if (isSortDescending()) {
        criteria.addOrder(Order.desc(this.sortFieldName));
    } // if
    else {
        criteria.addOrder(Order.asc(this.sortFieldName));
    } // else

    return criteria;
}

---

From source file:gr.abiss.calipso.dto.ValidationExpressionSearch.java

License:Open Source License

@Override
public DetachedCriteria getDetachedCriteria() {
    DetachedCriteria criteria = DetachedCriteria.forClass(ValidationExpression.class);

    if (this.validationExpression.getName() != null) {
        criteria.add(Restrictions.ilike("name", this.validationExpression.getName(), MatchMode.START));
    }/*w  w w  .  j  a va2 s .c o  m*/
    if (this.validationExpression.getDescription() != null) {
        criteria.add(
                Restrictions.ilike("description", this.validationExpression.getDescription(), MatchMode.START));
    }
    if (isSortDescending()) {
        criteria.addOrder(Order.desc(this.sortFieldName));
    } // if
    else {
        criteria.addOrder(Order.asc(this.sortFieldName));
    } // else

    return criteria;
}

---

From source file:id.ac.idu.administrasi.dao.impl.FasilitasDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override/*from   www .  ja  v  a 2  s.co  m*/
public ResultObject getAllMfasilitasLikeText(String text, int start, int pageSize) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Mfasilitas.class);

    if (!StringUtils.isEmpty(text)) {
        criteria.add(Restrictions.ilike("cnamaFasilitas", text, MatchMode.ANYWHERE));
    }

    criteria.addOrder(Order.asc("cnamaFasilitas"));

    int totalCount = getHibernateTemplate().findByCriteria(criteria).size();

    List<Branche> list = getHibernateTemplate().findByCriteria(criteria, start, pageSize);

    return new ResultObject(list, totalCount);
}

---

From source file:info.bluefoot.componentsexample.dao.support.HeroDao.java

License:Apache License

@Override
public List<Hero> findAll(Integer firstResult, Integer pageSize, String sortField, Boolean sortOrder,
        Map<String, String> filter) {
    List<Hero> result = new ArrayList<Hero>();

    DetachedCriteria criteria = DetachedCriteria.forClass(Hero.class);
    if (sortField != null) {
        if (sortOrder) {
            criteria.addOrder(Order.asc(sortField));
        } else {//from  w  ww.jav  a2  s  .co m
            criteria.addOrder(Order.desc(sortField));
        }
    }

    if (filter != null) {
        for (String key : filter.keySet()) {
            criteria.add(Restrictions.ilike(key, filter.get(key)));
        }
    }

    result.addAll(ht.findByCriteria(criteria, firstResult, pageSize));

    return result;
}

---

From source file:info.jtrac.domain.ItemSearch.java

License:Apache License

public DetachedCriteria getCriteria() {
    DetachedCriteria criteria = getCriteriaForCount();
    if (sortFieldName == null) { // can happen only for multi-space search
        sortFieldName = "id"; // effectively is a sort on created date
    }/*from  w w  w  .jav  a2 s.com*/
    if (sortFieldName.equals("id") || sortFieldName.equals("space")) {
        if (showHistory) {
            // if showHistory: sort by item.id and then history.id
            if (sortDescending) {
                if (space == null) {
                    DetachedCriteria parentSpace = parent.createCriteria("space");
                    parentSpace.addOrder(Order.desc("name"));
                }
                criteria.addOrder(Order.desc("parent.id"));
                criteria.addOrder(Order.desc("id"));
            } else {
                if (space == null) {
                    DetachedCriteria parentSpace = parent.createCriteria("space");
                    parentSpace.addOrder(Order.asc("name"));
                }
                criteria.addOrder(Order.asc("parent.id"));
                criteria.addOrder(Order.asc("id"));
            }
        } else {
            if (sortDescending) {
                if (space == null) {
                    DetachedCriteria parentSpace = criteria.createCriteria("space");
                    parentSpace.addOrder(Order.desc("name"));
                }
                criteria.addOrder(Order.desc("id"));
            } else {
                if (space == null) {
                    DetachedCriteria parentSpace = criteria.createCriteria("space");
                    parentSpace.addOrder(Order.asc("name"));
                }
                criteria.addOrder(Order.asc("id"));
            }
        }
    } else {
        if (sortDescending) {
            criteria.addOrder(Order.desc(sortFieldName));
        } else {
            criteria.addOrder(Order.asc(sortFieldName));
        }
    }
    return criteria;
}

---

From source file:info.jtrac.repository.HibernateJtracDao.java

License:Apache License

private DetachedCriteria getCriteria(ItemSearch itemSearch) {
    SearchCriteria searchCriteria = getCriteriaForCount(itemSearch);
    DetachedCriteria criteria = searchCriteria.criteria;
    DetachedCriteria parent = searchCriteria.parentCriteria;
    if (itemSearch.getSortFieldName() == null) { // can happen only for multi-space search
        itemSearch.setSortFieldName("id"); // effectively is a sort on created date
    }/*from  w ww  .  ja  v a  2  s .co  m*/
    String sortFieldName = itemSearch.getSortFieldName();
    Space space = itemSearch.getSpace();
    if (sortFieldName.equals("id") || sortFieldName.equals("space")) {
        if (itemSearch.isShowHistory()) {
            // if showHistory: sort by item.id and then history.id
            if (itemSearch.isSortDescending()) {
                if (space == null) {
                    DetachedCriteria parentSpace = parent.createCriteria("space");
                    parentSpace.addOrder(Order.desc("name"));
                }
                criteria.addOrder(Order.desc("parent.id"));
                criteria.addOrder(Order.desc("id"));
            } else {
                if (space == null) {
                    DetachedCriteria parentSpace = parent.createCriteria("space");
                    parentSpace.addOrder(Order.asc("name"));
                }
                criteria.addOrder(Order.asc("parent.id"));
                criteria.addOrder(Order.asc("id"));
            }
        } else {
            if (itemSearch.isSortDescending()) {
                if (space == null) {
                    DetachedCriteria parentSpace = criteria.createCriteria("space");
                    parentSpace.addOrder(Order.desc("name"));
                }
                criteria.addOrder(Order.desc("id"));
            } else {
                if (space == null) {
                    DetachedCriteria parentSpace = criteria.createCriteria("space");
                    parentSpace.addOrder(Order.asc("name"));
                }
                criteria.addOrder(Order.asc("id"));
            }
        }
    } else {
        if (itemSearch.isSortDescending()) {
            criteria.addOrder(Order.desc(sortFieldName));
        } else {
            criteria.addOrder(Order.asc(sortFieldName));
        }
    }
    return criteria;
}

---

From source file:it.jugpadova.blo.EventBo.java

License:Apache License

public List<Event> search(EventSearch eventSearch) {
    List<Event> events = new LinkedList<Event>();
    try {/*from   w  ww.j a  va 2s  .  c o m*/
        DetachedCriteria eventCriteria = DetachedCriteria.forClass(Event.class);
        if (StringUtils.isNotBlank(eventSearch.getJugName())
                || StringUtils.isNotBlank(eventSearch.getFriendlyName())
                || StringUtils.isNotBlank(eventSearch.getCountry())
                || StringUtils.isNotBlank(eventSearch.getContinent())) {
            DetachedCriteria ownerCriteria = eventCriteria.createCriteria("owner.jug");
            if (StringUtils.isNotBlank(eventSearch.getJugName())) {
                ownerCriteria.add(Restrictions.ilike("name", eventSearch.getJugName(), MatchMode.ANYWHERE));
            }
            if (StringUtils.isNotBlank(eventSearch.getFriendlyName())) {
                ownerCriteria.add(Restrictions.or(Restrictions.eq("name", eventSearch.getFriendlyName()),
                        Restrictions.eq("internalFriendlyName", eventSearch.getFriendlyName())));
            }
            if (StringUtils.isNotBlank(eventSearch.getCountry())
                    || StringUtils.isNotBlank(eventSearch.getContinent())) {
                DetachedCriteria countryCriteria = ownerCriteria.createCriteria("country");
                if (StringUtils.isNotBlank(eventSearch.getCountry())) {
                    countryCriteria.add(Restrictions.or(
                            Restrictions.ilike("englishName", eventSearch.getCountry(), MatchMode.ANYWHERE),
                            Restrictions.ilike("localName", eventSearch.getCountry(), MatchMode.ANYWHERE)));
                }
                if (StringUtils.isNotBlank(eventSearch.getContinent())) {
                    DetachedCriteria continentCriteria = countryCriteria.createCriteria("continent");
                    continentCriteria
                            .add(Restrictions.ilike("name", eventSearch.getContinent(), MatchMode.ANYWHERE));
                }
            }
        }
        if (!eventSearch.isPastEvents()) {
            eventCriteria.add(Restrictions.ge("startDate", new Date()));
        }
        if (eventSearch.getStartDate() != null) {
            eventCriteria.add(Restrictions.ge("startDate", eventSearch.getStartDate()));
        }
        if (eventSearch.getEndDate() != null) {
            eventCriteria.add(Restrictions.le("endDate", eventSearch.getEndDate()));
        }
        if ("desc".equals(eventSearch.getOrderByDate())) {
            eventCriteria.addOrder(Order.desc("startDate"));
            eventCriteria.addOrder(Order.desc("creationDate"));
        } else {
            eventCriteria.addOrder(Order.asc("startDate"));
            eventCriteria.addOrder(Order.asc("creationDate"));
        }
        if (eventSearch.getMaxResults() == null) {
            events = eventDao.searchByCriteria(eventCriteria);
        } else {
            events = eventDao.searchByCriteria(eventCriteria, 0, eventSearch.getMaxResults().intValue());
        }
        for (Event event : events) {
            event.getParticipants().size();
        }
    } catch (Exception e) {
        logger.error("Error searching events", e);
    }

    return events;
}

---

From source file:kr.debop4j.data.hibernate.tools.HibernateTool.java

License:Apache License

/**
 * Add orders./*from   w w  w  . j  ava 2 s . c  o  m*/
 *
 * @param dc     the dc
 * @param orders the orders
 * @return the detached criteria
 */
public static DetachedCriteria addOrders(DetachedCriteria dc, Order... orders) {
    shouldNotBeNull(dc, "dc");

    for (Order order : orders) {
        dc.addOrder(order);
    }
    return dc;
}

---

From source file:kr.debop4j.data.hibernate.tools.HibernateTool.java

License:Apache License

/**
 * Add orders.//from  w w  w.ja va2  s.  c  o m
 *
 * @param dc     the dc
 * @param orders the orders
 * @return the detached criteria
 */
public static DetachedCriteria addOrders(DetachedCriteria dc, Iterable<Order> orders) {
    shouldNotBeNull(dc, "dc");

    for (Order order : orders)
        dc.addOrder(order);

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