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.gaixie.micrite.patrolRiverSummary.dao.hibernate.PatrolRiverSummaryDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
public List findCSGroupByTelVague(SearchBean[] queryBean) {
    DetachedCriteria criteria = SearchFactory.generateCriteria(PatrolRiverSummary.class, queryBean);
    criteria.add(Expression.eq("approveStatus", IPatrolRiverSummaryService.STATUS_NORMAL));
    criteria.addOrder(Order.desc("editDate"));
    criteria.createAlias("carType", "cs");
    criteria.setProjection(Projections.projectionList().add(Projections.count("cs.name"))
            .add(Projections.groupProperty("cs.name")));
    List<PatrolRiverSummary> list = getHibernateTemplate().findByCriteria(criteria);
    //        desidedExpiredFlag(list);
    return list;/*from   w  w  w  .  j  a v a  2  s  .c  o m*/
}

From source file:org.gaixie.micrite.river.dao.hibernate.RiverDAOImpl.java

@SuppressWarnings("unchecked")
public List<River> advancedFindByPerPage(SearchBean[] queryBean, int start, int limit) {
    DetachedCriteria criteria = SearchFactory.generateCriteria(River.class, queryBean);
    criteria.add(Restrictions.ne("id", SYS_RECORD_ID));
    criteria.add(Expression.eq("status", IRiverService.STATUS_NORMAL));
    criteria.addOrder(Order.desc("modifydate"));
    return getHibernateTemplate().findByCriteria(criteria, start, limit);
}

From source file:org.gaixie.micrite.security.dao.hibernate.AuthorityDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Authority> findByRoleId(int roleId) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Authority.class);
    criteria.createCriteria("roles", "r").add(Expression.eq("r.id", roleId));

    criteria.addOrder(Order.asc("order1"));
    criteria.addOrder(Order.asc("order2"));

    return getHibernateTemplate().findByCriteria(criteria);
}

From source file:org.gaixie.micrite.security.dao.hibernate.AuthorityDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Authority> findByType(String type) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Authority.class);
    criteria.add(Expression.eq("type", type));
    criteria.addOrder(Order.desc("value"));
    return getHibernateTemplate().findByCriteria(criteria);
}

From source file:org.generationcp.middleware.dao.GermplasmDAO.java

License:Open Source License

public List<Germplasm> getPreviousCrosses(final Germplasm currentCross, final Germplasm female,
        final Germplasm male) {
    try {//from ww w .j  a va2  s. com
        final DetachedCriteria criteria = DetachedCriteria.forClass(Germplasm.class);

        // (female x male) is not the same as (male x female) so the order is important.
        criteria.add(Restrictions.eq("gpid1", female.getGid()));
        criteria.add(Restrictions.eq("gpid2", male.getGid()));
        // Restrict to cases where two parents are involved.
        criteria.add(Restrictions.eq("gnpgs", 2));
        // = Record is unchanged.
        criteria.add(Restrictions.eq(GermplasmDAO.GRPLCE, 0));
        // Exclude current cross. We are finding "previous" crosses.
        criteria.add(Restrictions.ne("gid", currentCross.getGid()));
        // = Record is not or replaced.
        criteria.add(Restrictions.eq(GermplasmDAO.DELETED, Boolean.FALSE));
        // Oldest created cross will be first in list.
        criteria.addOrder(Order.asc("gid"));

        @SuppressWarnings("unchecked")
        final List<Germplasm> previousCrosses = criteria.getExecutableCriteria(this.getSession()).list();
        return previousCrosses;
    } catch (final HibernateException e) {
        final String message = "Error executing GermplasmDAO.getPreviousCrosses(female = {}, male = {}): {}";
        GermplasmDAO.LOG.error(message, female, male, e.getMessage());
        throw new MiddlewareQueryException(message, e);
    }
}

From source file:org.grails.orm.hibernate.query.AbstractHibernateQuery.java

License:Apache License

private void addOrderToDetachedCriteria(DetachedCriteria dc, String property, Order order) {
    if (dc != null) {
        org.hibernate.criterion.Order hibernateOrder = order.getDirection() == Order.Direction.ASC
                ? org.hibernate.criterion.Order.asc(calculatePropertyName(property))
                : org.hibernate.criterion.Order.desc(calculatePropertyName(property));
        dc.addOrder(order.isIgnoreCase() ? hibernateOrder.ignoreCase() : hibernateOrder);

    }//  w ww.j av  a 2  s.co m
}

From source file:org.ikasan.error.reporting.dao.HibernateErrorReportingServiceDao.java

License:BSD License

@Override
public List<ErrorOccurrence<byte[]>> find(List<String> moduleName, List<String> flowName,
        List<String> flowElementname, Date startDate, Date endDate) {
    DetachedCriteria criteria = DetachedCriteria.forClass(ErrorOccurrence.class);

    if (moduleName != null && moduleName.size() > 0) {
        criteria.add(Restrictions.in("moduleName", moduleName));
    }/*from   w  w  w.  j  a  va2  s .com*/

    if (flowName != null && flowName.size() > 0) {
        criteria.add(Restrictions.in("flowName", flowName));
    }

    if (flowElementname != null && flowElementname.size() > 0) {
        criteria.add(Restrictions.in("flowElementName", flowElementname));
    }

    if (startDate != null) {
        criteria.add(Restrictions.gt("timestamp", startDate.getTime()));
    }

    if (endDate != null) {
        criteria.add(Restrictions.lt("timestamp", endDate.getTime()));
    }

    criteria.addOrder(Order.desc("expiry"));

    return (List<ErrorOccurrence<byte[]>>) this.getHibernateTemplate().findByCriteria(criteria);
}

From source file:org.ikasan.exclusion.dao.HibernateExclusionEventDao.java

License:BSD License

@Override
public List<ExclusionEvent> findAll() {
    DetachedCriteria criteria = DetachedCriteria.forClass(ExclusionEvent.class);
    criteria.addOrder(Order.desc("timestamp"));

    return (List<ExclusionEvent>) this.getHibernateTemplate().findByCriteria(criteria);
}

From source file:org.ikasan.exclusion.dao.HibernateExclusionEventDao.java

License:BSD License

@Override
public List<ExclusionEvent> find(List<String> moduleName, List<String> flowName, Date startDate, Date endDate,
        String identifier) {//from   www.j  a v  a  2 s .c o m
    DetachedCriteria criteria = DetachedCriteria.forClass(ExclusionEvent.class);

    if (moduleName != null && moduleName.size() > 0) {
        criteria.add(Restrictions.in("moduleName", moduleName));
    }

    if (flowName != null && flowName.size() > 0) {
        criteria.add(Restrictions.in("flowName", flowName));
    }

    if (identifier != null && identifier.length() > 0) {
        criteria.add(Restrictions.eq("identifier", identifier));
    }

    if (startDate != null) {
        criteria.add(Restrictions.gt("timestamp", startDate.getTime()));
    }

    if (endDate != null) {
        criteria.add(Restrictions.lt("timestamp", endDate.getTime()));
    }

    criteria.addOrder(Order.desc("timestamp"));

    return (List<ExclusionEvent>) this.getHibernateTemplate().findByCriteria(criteria);
}

From source file:org.ikasan.security.dao.HibernateSecurityDao.java

License:BSD License

@SuppressWarnings("unchecked")
@Override//from w  ww .j  a va  2  s.c  o m
public List<AuthenticationMethod> getAuthenticationMethods() {
    DetachedCriteria criteria = DetachedCriteria.forClass(AuthenticationMethod.class);
    criteria.addOrder(Order.asc("order"));

    return (List<AuthenticationMethod>) this.getHibernateTemplate().findByCriteria(criteria);
}