Example usage for org.hibernate.criterion DetachedCriteria addOrder

List of usage examples for org.hibernate.criterion DetachedCriteria addOrder

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. DetachedCriteria
  6. 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:dk.teachus.backend.dao.hibernate.HibernateBookingDAO.java

License:Apache License

@SuppressWarnings("unchecked")
@Transactional(readOnly = true)//from   ww  w  .  j a va  2s  . c  om
public List<PupilBooking> getUnPaidBookings(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", false));
    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);
}

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

License:Apache License

@SuppressWarnings("unchecked")
@Transactional(readOnly = true)/*from w ww  . j  av  a2 s. c o m*/
public DateTime getLastBookingDate(Period period) {
    DetachedCriteria c = DetachedCriteria.forClass(BookingImpl.class);
    c.createCriteria("pupil").add(Restrictions.eq("active", true));
    c.add(Restrictions.eq("period", period));
    c.add(Restrictions.eq("active", true));
    c.addOrder(Order.desc("date"));

    List<Booking> list = getHibernateTemplate().findByCriteria(c, 0, 1);

    DateTime lastBookingDate = null;
    if (list.size() == 1) {
        Booking booking = list.get(0);
        lastBookingDate = booking.getDate();
    }

    return lastBookingDate;
}

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

License:Apache License

@SuppressWarnings("unchecked")
@Transactional(readOnly = true)//from  www  . jav a 2s .  c  o  m
public <P extends Person> List<P> getPersons(Class<P> personClass) {
    Class<? extends Person> clazz = null;

    if (Admin.class.equals(personClass)) {
        clazz = AdminImpl.class;
    } else if (Teacher.class.equals(personClass)) {
        clazz = TeacherImpl.class;
    } else if (Pupil.class.equals(personClass)) {
        clazz = PupilImpl.class;
    }

    DetachedCriteria c = DetachedCriteria.forClass(clazz);

    c.addOrder(Order.asc("name"));
    if (Pupil.class.equals(personClass)) {
        c.add(Restrictions.eq("active", true));
    }

    c.setResultTransformer(DistinctRootEntityResultTransformer.INSTANCE);

    return getHibernateTemplate().findByCriteria(c);
}

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

License:Apache License

@SuppressWarnings("unchecked")
@Transactional(readOnly = true)//  www.  j  a va  2s.  c  o  m
public List<Pupil> getPupils(Teacher teacher) {
    DetachedCriteria c = DetachedCriteria.forClass(PupilImpl.class);

    c.add(Restrictions.eq("active", true));
    c.createCriteria("teacher").add(Restrictions.eq("active", true));
    c.add(Restrictions.eq("teacher", teacher));

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

    c.setResultTransformer(DistinctRootEntityResultTransformer.INSTANCE);

    return getHibernateTemplate().findByCriteria(c);
}

From source file:dz.alkhwarizmix.framework.java.dao.impl.RecordDAOTest.java

License:Open Source License

@Test
public void test07_getList() throws AlKhwarizmixException {
    // Setup/*  ww w. j  a v a  2s.  c o  m*/
    final String data1 = getStringOfSize(128 * 3);
    final AlKhwarizmixDomainObject owner1 = insertNewOwner();
    final Record record1 = insertNewRecord(1, owner1, data1);
    insertNewRecord(2, insertNewOwner(), getStringOfSize(128 * 5));
    // Setup Criteria
    final Record tableRecord = utRecordDAO.getRecord(record1.getTableRecord());
    final DetachedCriteria criteria = DetachedCriteria.forClass(Record.class);
    criteria.addOrder(Order.asc(Record.RECORDID));
    criteria.add(Restrictions.eq(Record.PARENT_ID, tableRecord.getId()));
    criteria.add(Restrictions.eq(Record.OWNER_ID, owner1.getId()));
    // Test
    @SuppressWarnings("unchecked")
    final List<Record> listOfRecords = utRecordDAO.getList(criteria, 0, 1000);
    // Asserts
    Assert.assertNotNull(listOfRecords);
    Assert.assertEquals(1, listOfRecords.size());
    Assert.assertEquals(record1.getRecordId(), listOfRecords.get(0).getRecordId());
    Assert.assertEquals(data1, listOfRecords.get(0).getData());
}

From source file:dz.alkhwarizmix.framework.java.dao.impl.UserDAOTest.java

License:Open Source License

@Test
public void test02_default_users_were_created() throws AlKhwarizmixException {

    final DetachedCriteria criteriaToUse = DetachedCriteria.forClass(User.class);
    criteriaToUse.addOrder(Order.asc(User.USERID));
    assertDefaultUser("fbelhaouas@icloud.com", "? ");
    assertDefaultUser("fares@dz.moqawalati.com", "Fares @ Moqawalati");
}

From source file:dz.alkhwarizmix.framework.java.services.impl.RecordService.java

License:Open Source License

/**
 * {@inheritDoc}/*from  ww w .  java  2s.c  om*/
 */
@Override
public RecordList getRecordList(final String schema, final String table, DetachedCriteria criteriaToUse,
        final int firstResult, final int maxResult, final boolean validateObjectToPublish)
        throws AlKhwarizmixException {
    getLogger().trace("getRecordList");
    List<Record> listOfRecords = null;
    Record tableRecord = new Record(null, schema, table).getTableRecord();
    tableRecord = getRecordDAO().getRecord(tableRecord);
    if (tableRecord != null) {
        if (criteriaToUse == null) {
            criteriaToUse = DetachedCriteria.forClass(Record.class);
            criteriaToUse.addOrder(Order.asc(Record.RECORDID));
        }
        addHaveAccessCriteria(criteriaToUse);
        criteriaToUse.add(Restrictions.eq(Record.PARENT_ID, tableRecord.getId()));
        listOfRecords = extracted(criteriaToUse, firstResult, maxResult, validateObjectToPublish);
    }
    return new RecordList(listOfRecords);
}

From source file:dz.alkhwarizmix.framework.java.services.impl.UserService.java

License:Open Source License

/**
 * TODO: JAVADOC/*from  w  ww  . j a  v a  2 s.c  o  m*/
 */
@SuppressWarnings("unchecked")
public List<User> getUserList(DetachedCriteria criteriaToUse, final int firstResult, final int maxResult)
        throws AlKhwarizmixException {
    getLogger().trace("getUserList");
    if (criteriaToUse == null) {
        criteriaToUse = DetachedCriteria.forClass(User.class);
        criteriaToUse.addOrder(Order.asc(User.USERID));
    }

    final List<User> result = (List<User>) (List<?>) getObjectList(criteriaToUse, firstResult, maxResult, true);
    return result;
}

From source file:dz.alkhwarizmix.moqawalati.java.services.impl.ClientService.java

License:Open Source License

/**
 * {@inheritDoc}/* w ww.  j  a va  2s .  co m*/
 */
@SuppressWarnings("unchecked")
@Override
public List<Client> getClientList(DetachedCriteria criteriaToUse, final int firstResult, final int maxResult,
        final boolean validateObjectToPublish) throws MoqawalatiException {
    getLogger().trace("getClientList");

    if (criteriaToUse == null) {
        criteriaToUse = DetachedCriteria.forClass(Client.class);
        criteriaToUse.addOrder(Order.asc(Client.CLIENTID));
    }

    try {
        final List<Client> result = (List<Client>) (List<?>) getObjectList(criteriaToUse, firstResult,
                maxResult, validateObjectToPublish);
        return result;
    } catch (final AlKhwarizmixException e) {
        throw new MoqawalatiException(e);
    }
}

From source file:edu.ur.hibernate.file.db.HbDefaultFileDatabaseDAO.java

License:Apache License

/**
 * Return all file databases orderd by Name.  This list 
 * can be extreamly large and it is recomened that
 * paging is used instead/*  w  w  w  . ja v  a 2 s.  c o  m*/
 * 
 * @return
 */
@SuppressWarnings("unchecked")
public List<DefaultFileDatabase> getAllNameOrder() {
    DetachedCriteria dc = DetachedCriteria.forClass(DefaultFileDatabase.class);
    dc.addOrder(Order.asc("name"));
    return (List<DefaultFileDatabase>) hbCrudDAO.getHibernateTemplate().findByCriteria(dc);
}