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:de.forsthaus.backend.dao.impl.SecRightDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override//from  ww  w  . j  a  v a  2  s  . c o  m
public List<SecRight> getRightsLikeRightNameAndTypes(String aRightName, List<Integer> listOfRightTyps) {

    final DetachedCriteria criteria = DetachedCriteria.forClass(SecRight.class);
    criteria.addOrder(Order.asc("rigName"));

    List<SecRight> result = null; // init

    String hqlFrom = "";
    String hqlWhere = "";
    String hqlAdd = "";

    // check if value is '-1'. it means 'all', no filtering
    // only if value is empty
    for (final Integer integer : listOfRightTyps) {
        if (integer.equals(new Integer(-1))) {
            if (aRightName.isEmpty()) {
                return getAllRights(integer.intValue());
            } else if (!aRightName.isEmpty()) {

                hqlFrom = " from SecRight as secRight where ";
                hqlWhere = " secRight.rigName like '%" + aRightName + "%'";
                final String hqlQuery = hqlFrom + hqlWhere;

                // System.out.println(hqlQuery);

                return getHibernateTemplate().find(hqlQuery);
            }
        }
    }

    // check if only 1 type and value is empty
    if (listOfRightTyps.size() == 1) {
        final int i = listOfRightTyps.get(0).intValue();
        if (aRightName.isEmpty()) {
            return getAllRights(i);
        }
    }

    // if more than one type than construct the hql query
    hqlFrom = " from SecRight as secRight where ";
    // get the first value
    hqlWhere = " secRight.rigType = " + listOfRightTyps.get(0);

    for (int i = 1; i < listOfRightTyps.size(); i++) {
        hqlWhere = hqlWhere + " or secRight.rigType = " + listOfRightTyps.get(i);
    }

    String hqlQuery = hqlFrom + hqlWhere;

    if (!aRightName.isEmpty()) {
        // add the right name
        hqlAdd = " and secRight.rigName like '%" + aRightName + "%'";
        hqlQuery = hqlQuery + hqlAdd;
    }

    // System.out.println(hqlQuery);

    result = getHibernateTemplate().find(hqlQuery);

    return result;
}

---

From source file:de.forsthaus.backend.dao.impl.YoutubeLinkDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override/*from   ww  w.  ja v  a2  s . co  m*/
public List<YoutubeLink> getAllYoutubeLinks() {
    DetachedCriteria criteria = DetachedCriteria.forClass(YoutubeLink.class);
    criteria.addOrder(Order.asc("interpret"));

    return getHibernateTemplate().findByCriteria(criteria);
}

---

From source file:de.forsthaus.backend.dao.impl.YoutubeLinkDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override//from   w  ww  . j a  v  a  2 s.  com
public ResultObject getAllYoutubeLinks(int start, int pageSize) {
    DetachedCriteria criteria = DetachedCriteria.forClass(YoutubeLink.class);
    criteria.addOrder(Order.asc("interpret"));

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

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

    return new ResultObject(list, totalCount);
}

---

From source file:de.iteratec.iteraplan.businesslogic.service.UserEntityServiceImpl.java

License:Open Source License

/** {@inheritDoc} */
public List<UserEntity> getUserEntityBySearch(UserEntity userEntity) {
    //FIXME push this down to DAO and additionally escape T-SQL control characters
    DetachedCriteria crit = DetachedCriteria.forClass(UserEntity.class);

    if (userEntity != null && !StringUtils.isEmpty(userEntity.getIdentityString())) {
        String sqlSearchTerm = SqlHqlStringUtils.processGuiFilterForSql(userEntity.getIdentityString());

        crit.add(Restrictions.or(new IteraplanLikeExpression("name", sqlSearchTerm, true),
                new IteraplanLikeExpression("loginName", sqlSearchTerm, true)));
    }// w  w  w.j a v a 2s .  co  m
    // don't add order constraint to count criteria!
    crit.addOrder(Order.asc("loginName"));
    crit.addOrder(Order.asc("name"));

    return this.userEntityDAO.findByCriteria(crit);
}

---

From source file:de.iteratec.iteraplan.businesslogic.service.UserServiceImpl.java

License:Open Source License

/** {@inheritDoc}. */
public List<User> getUserBySearch(User user) {
    //FIXME push this down into DAO and additionally escape T-SQL control characters within like criteria 
    DetachedCriteria crit = DetachedCriteria.forClass(User.class);

    if (user != null) {
        if (!StringUtils.isEmpty(user.getFirstName())) {
            String sqlSearchTerm = SqlHqlStringUtils.processGuiFilterForSql(user.getFirstName());
            crit.add(new IteraplanLikeExpression("firstName", sqlSearchTerm, true));
        }//from  w w  w. java  2 s . com

        if (!StringUtils.isEmpty(user.getLastName())) {
            String sqlSearchTerm = SqlHqlStringUtils.processGuiFilterForSql(user.getLastName());
            crit.add(new IteraplanLikeExpression("lastName", sqlSearchTerm, true));
        }
    }
    crit.addOrder(Order.asc("lastName"));
    // don't add order constraint to count criteria!

    return this.userDAO.findByCriteria(crit);
}

---

From source file:debop4k.data.orm.hibernate.CriteriaEx.java

License:Apache License

public static DetachedCriteria addOrders(DetachedCriteria dc, Iterable<Order> orders) {
    for (Order order : orders) {
        dc.addOrder(order);
    }/* ww w  .  j  a va  2 s.  c  om*/
    return dc;
}

---

From source file:dk.teachus.backend.dao.hibernate.HibernateBookingDAO.java

License:Apache License

@SuppressWarnings("unchecked")
@Transactional(readOnly = true)/*  w w w.java 2 s .co m*/
public List<PupilBooking> getFutureBookingsForTeacher(Teacher teacher) {
    DetachedCriteria c = DetachedCriteria.forClass(PupilBookingImpl.class);

    DateTime end = new DateTime().minusDays(1).withHourOfDay(23).withMinuteOfHour(59).withSecondOfMinute(59)
            .withMillisOfSecond(999);

    c.createCriteria("period").add(Restrictions.eq("status", Status.FINAL));
    c.createCriteria("pupil").add(Restrictions.eq("teacher", teacher)).add(Restrictions.eq("active", true))
            .createCriteria("teacher").add(Restrictions.eq("active", true));
    c.add(Restrictions.gt("date", end));
    c.add(Restrictions.eq("active", true));

    c.addOrder(Order.asc("date"));

    c.setResultTransformer(DistinctRootEntityResultTransformer.INSTANCE);

    return getHibernateTemplate().findByCriteria(c);
}

---

From source file:dk.teachus.backend.dao.hibernate.HibernateBookingDAO.java

License:Apache License

@SuppressWarnings("unchecked")
@Transactional(readOnly = true)/*from w w  w  . java 2s . c o  m*/
public List<PupilBooking> getUnpaidBookings(Pupil pupil) {
    DetachedCriteria c = DetachedCriteria.forClass(PupilBookingImpl.class);

    c.createCriteria("period").add(Restrictions.eq("status", Status.FINAL));
    c.createCriteria("pupil").add(Restrictions.eq("active", true)).createCriteria("teacher")
            .add(Restrictions.eq("active", true));
    c.add(Restrictions.eq("pupil", pupil));
    c.add(Restrictions.lt("date", new DateTime()));
    c.add(Restrictions.eq("paid", false));
    c.add(Restrictions.eq("active", true));

    c.addOrder(Order.asc("date"));

    return getHibernateTemplate().findByCriteria(c);
}

---

From source file:dk.teachus.backend.dao.hibernate.HibernateBookingDAO.java

License:Apache License

@SuppressWarnings("unchecked")
@Transactional(readOnly = true)/*from  www. ja va2 s  . c om*/
public List<PupilBooking> getUnpaidBookings(Teacher teacher) {
    DetachedCriteria c = DetachedCriteria.forClass(PupilBookingImpl.class);

    c.createCriteria("period").add(Restrictions.eq("status", Status.FINAL));
    c.createCriteria("pupil").add(Restrictions.eq("teacher", teacher)).add(Restrictions.eq("active", true))
            .createCriteria("teacher").add(Restrictions.eq("active", true));
    c.add(Restrictions.lt("date", new DateTime()));
    c.add(Restrictions.eq("paid", false));
    c.add(Restrictions.eq("active", true));

    c.addOrder(Order.asc("date"));

    return getHibernateTemplate().findByCriteria(c);
}

---

From source file:dk.teachus.backend.dao.hibernate.HibernateBookingDAO.java

License:Apache License

@SuppressWarnings("unchecked")
@Transactional(readOnly = true)/*from   www . j  av  a 2s  .co m*/
public List<PupilBooking> getPaidBookings(Teacher teacher, DateMidnight startDate, DateMidnight endDate) {
    DetachedCriteria c = DetachedCriteria.forClass(PupilBookingImpl.class);

    c.createCriteria("period").add(Restrictions.eq("status", Status.FINAL));
    c.createCriteria("pupil").add(Restrictions.eq("teacher", teacher)).add(Restrictions.eq("active", true))
            .createCriteria("teacher").add(Restrictions.eq("active", true));
    c.add(Restrictions.eq("paid", true));
    c.add(Restrictions.eq("active", true));

    if (startDate != null && endDate != null) {
        c.add(Restrictions.between("date", startDate.toDateTime(), endDate.toDateTime()));
    } else if (startDate != null) {
        c.add(Restrictions.gt("date", startDate.toDateTime()));
    } else if (endDate != null) {
        c.add(Restrictions.lt("date", endDate.toDateTime()));
    }

    c.addOrder(Order.asc("date"));

    return getHibernateTemplate().findByCriteria(c);
}

---

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