Example usage for org.hibernate.criterion Restrictions ge

List of usage examples for org.hibernate.criterion Restrictions ge

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. Restrictions
  6. ge

Introduction

In this page you can find the example usage for org.hibernate.criterion Restrictions ge.

Prototype

public static SimpleExpression ge(String propertyName, Object value)

Source Link

Document

Apply a "greater than or equal" constraint to the named property

Usage

From source file:com.floreantpos.model.dao.TableBookingInfoDAO.java

License:Open Source License

public List getTodaysBooking() {

    Session session = null;/*from w w w.  jav  a 2s.c  o  m*/
    try {

        Calendar startDate = Calendar.getInstance();
        startDate.setLenient(false);
        startDate.setTime(new Date());
        startDate.set(Calendar.HOUR_OF_DAY, 0);
        startDate.set(Calendar.MINUTE, 0);
        startDate.set(Calendar.SECOND, 0);
        startDate.set(Calendar.MILLISECOND, 0);

        Calendar endDate = Calendar.getInstance();
        endDate.setLenient(false);
        endDate.setTime(new Date());
        endDate.set(Calendar.HOUR_OF_DAY, 23);
        endDate.set(Calendar.MINUTE, 59);
        endDate.set(Calendar.SECOND, 59);

        session = createNewSession();

        Criteria criteria = session.createCriteria(TableBookingInfo.class);

        criteria.add(Restrictions.ge(TableBookingInfo.PROP_FROM_DATE, startDate.getTime()))
                .add(Restrictions.le(TableBookingInfo.PROP_FROM_DATE, endDate.getTime()))
                .add(Restrictions.eq(TableBookingInfo.PROP_STATUS, TableBookingInfo.STATUS_OPEN));
        List list = criteria.list();

        return list;
    } catch (Exception e) {
        PosLog.error(getClass(), e);
    } finally {
        session.close();
    }
    return null;
}

From source file:com.floreantpos.model.dao.TableBookingInfoDAO.java

License:Open Source License

public List getAllBookingByDate(Date startDate, Date endDate) {

    Session session = null;//from www. ja v  a  2s .  co m
    try {
        session = createNewSession();
        Criteria criteria = session.createCriteria(TableBookingInfo.class);

        criteria.add(Restrictions.ge(TableBookingInfo.PROP_FROM_DATE, startDate))
                .add(Restrictions.le(TableBookingInfo.PROP_FROM_DATE, endDate))
                .add(Restrictions.ne(TableBookingInfo.PROP_STATUS, TableBookingInfo.STATUS_CLOSE));

        List list = criteria.list();

        return list;
    } catch (Exception e) {
        PosLog.error(getClass(), e);
    } finally {
        session.close();
    }
    return null;
}

From source file:com.floreantpos.model.dao.TicketDAO.java

License:Open Source License

public List<Ticket> findTicketsForUser(PaymentStatusFilter psFilter, String otFilter, User user) {
    Session session = null;//w  w  w  .  ja  v a 2 s. c  om

    try {
        session = getSession();
        Criteria criteria = session.createCriteria(getReferenceClass());

        if (psFilter == PaymentStatusFilter.OPEN) {
            criteria.add(Restrictions.eq(Ticket.PROP_PAID, Boolean.FALSE));
            criteria.add(Restrictions.eq(Ticket.PROP_CLOSED, Boolean.FALSE));
        } else if (psFilter == PaymentStatusFilter.PAID) {
            criteria.add(Restrictions.eq(Ticket.PROP_PAID, Boolean.TRUE));
            criteria.add(Restrictions.eq(Ticket.PROP_CLOSED, Boolean.FALSE));
        } else if (psFilter == PaymentStatusFilter.CLOSED) {
            criteria.add(Restrictions.eq(Ticket.PROP_DRAWER_RESETTED, Boolean.FALSE));
            criteria.add(Restrictions.eq(Ticket.PROP_CLOSED, Boolean.TRUE));

            Calendar currentTime = Calendar.getInstance();
            currentTime.add(Calendar.HOUR_OF_DAY, -24);

            criteria.add(Restrictions.ge(Ticket.PROP_CLOSING_DATE, currentTime.getTime()));
        }

        if (otFilter != POSConstants.ALL) {
            criteria.add(Restrictions.eq(Ticket.PROP_TICKET_TYPE, otFilter));
        }

        if (user != null) {
            criteria.add(Restrictions.eq(Ticket.PROP_OWNER, user));
        }

        List list = criteria.list();
        return list;
    } finally {
        closeSession(session);
    }
}

From source file:com.floreantpos.model.dao.TicketDAO.java

License:Open Source License

public List<Ticket> findOpenTickets(Date startDate, Date endDate) {
    Session session = null;/*from  ww  w. j  a va 2  s  .  co m*/

    try {
        session = getSession();
        Criteria criteria = session.createCriteria(getReferenceClass());
        criteria.add(Restrictions.eq(Ticket.PROP_CLOSED, Boolean.FALSE));
        criteria.add(Restrictions.ge(Ticket.PROP_CREATE_DATE, startDate));
        criteria.add(Restrictions.le(Ticket.PROP_CREATE_DATE, endDate));
        List list = criteria.list();
        return list;
    } finally {
        closeSession(session);
    }
}

From source file:com.floreantpos.model.dao.TicketDAO.java

License:Open Source License

public List<Ticket> findClosedTickets(Date startDate, Date endDate) {
    Session session = null;/*from   w  w  w.  j  a  v a  2 s .  c o  m*/

    try {
        session = createNewSession();
        Criteria criteria = session.createCriteria(getReferenceClass());
        criteria.add(Restrictions.eq(Ticket.PROP_CLOSED, Boolean.TRUE));
        if (startDate != null && endDate != null) {
            criteria.add(Restrictions.ge(Ticket.PROP_CREATE_DATE, startDate));
            criteria.add(Restrictions.le(Ticket.PROP_CREATE_DATE, endDate));
        }
        List list = criteria.list();
        return list;
    } finally {
        closeSession(session);
    }
}

From source file:com.floreantpos.model.dao.TicketDAO.java

License:Open Source License

public List<Ticket> findTickets(Date startDate, Date endDate, boolean closed) {
    Session session = null;//from   w  w w. j a  v  a  2  s.  c o m
    try {
        session = getSession();
        Criteria criteria = session.createCriteria(getReferenceClass());
        criteria.add(Restrictions.ge(Ticket.PROP_CREATE_DATE, startDate));
        criteria.add(Restrictions.le(Ticket.PROP_CREATE_DATE, endDate));
        //criteria.add(Restrictions.eq(Ticket.PROP_CLOSED, Boolean.TRUE));
        criteria.add(Restrictions.eq(Ticket.PROP_VOIDED, Boolean.FALSE));
        criteria.add(Restrictions.eq(Ticket.PROP_REFUNDED, Boolean.FALSE));
        criteria.add(Restrictions.eq(Ticket.PROP_DRAWER_RESETTED, Boolean.valueOf(closed)));

        return criteria.list();
    } finally {
        closeSession(session);
    }
}

From source file:com.floreantpos.model.dao.TicketDAO.java

License:Open Source License

public List<Ticket> findTickets(Date startDate, Date endDate, boolean closed, Terminal terminal) {
    Session session = null;//from w  w  w .ja va 2  s  .c  o  m
    try {
        session = getSession();
        Criteria criteria = session.createCriteria(getReferenceClass());
        criteria.add(Restrictions.ge(Ticket.PROP_CREATE_DATE, startDate));
        criteria.add(Restrictions.le(Ticket.PROP_CREATE_DATE, endDate));
        criteria.add(Restrictions.eq(Ticket.PROP_CLOSED, Boolean.TRUE));
        criteria.add(Restrictions.eq(Ticket.PROP_VOIDED, Boolean.FALSE));
        criteria.add(Restrictions.eq(Ticket.PROP_REFUNDED, Boolean.FALSE));
        criteria.add(Restrictions.eq(Ticket.PROP_DRAWER_RESETTED, Boolean.valueOf(closed)));

        if (terminal != null) {
            criteria.add(Restrictions.eq(Ticket.PROP_TERMINAL, terminal));
        }

        return criteria.list();
    } finally {
        closeSession(session);
    }
}

From source file:com.floreantpos.model.dao.TicketDAO.java

License:Open Source License

public List<Ticket> findTicketsForLaborHour(Date startDate, Date endDate, int hour, UserType userType,
        Terminal terminal) {/* w w  w  .  ja  v  a2 s  .co m*/
    Session session = null;
    try {
        session = getSession();
        Criteria criteria = session.createCriteria(getReferenceClass());
        criteria.add(Restrictions.ge(Ticket.PROP_ACTIVE_DATE, startDate));
        criteria.add(Restrictions.le(Ticket.PROP_ACTIVE_DATE, endDate));
        criteria.add(Restrictions.eq(Ticket.PROP_CREATION_HOUR, Integer.valueOf(hour)));
        //criteria.add(Restrictions.eq(Ticket.PROP_CLOSED, Boolean.TRUE));
        //criteria.add(Restrictions.eq(Ticket.PROP_VOIDED, Boolean.FALSE));

        if (userType != null) {
            criteria.createAlias(Ticket.PROP_OWNER, "u"); //$NON-NLS-1$
            criteria.add(Restrictions.eq("u.type", userType)); //$NON-NLS-1$
        }
        if (terminal != null) {
            criteria.add(Restrictions.eq(Ticket.PROP_TERMINAL, terminal));
        }

        return criteria.list();
    } finally {
        closeSession(session);
    }
}

From source file:com.floreantpos.model.dao.TicketDAO.java

License:Open Source License

public List<Ticket> findTicketsForShift(Date startDate, Date endDate, Shift shit, UserType userType,
        Terminal terminal) {/*from  w w w.ja v a 2s.com*/
    Session session = null;
    try {
        session = getSession();
        Criteria criteria = session.createCriteria(getReferenceClass());
        criteria.add(Restrictions.ge(Ticket.PROP_CREATE_DATE, startDate));
        criteria.add(Restrictions.le(Ticket.PROP_CREATE_DATE, endDate));
        criteria.add(Restrictions.eq(Ticket.PROP_SHIFT, shit));
        criteria.add(Restrictions.eq(Ticket.PROP_CLOSED, Boolean.TRUE));
        criteria.add(Restrictions.eq(Ticket.PROP_VOIDED, Boolean.FALSE));
        criteria.add(Restrictions.eq(Ticket.PROP_REFUNDED, Boolean.FALSE));

        if (userType != null) {
            criteria.createAlias(Ticket.PROP_OWNER, "u"); //$NON-NLS-1$
            criteria.add(Restrictions.eq("u.type", userType)); //$NON-NLS-1$
        }
        if (terminal != null) {
            criteria.add(Restrictions.eq(Ticket.PROP_TERMINAL, terminal));
        }

        return criteria.list();
    } finally {
        closeSession(session);
    }
}

From source file:com.floreantpos.model.dao.TicketDAO.java

License:Open Source License

public List<Ticket> findTickets(PaginatedTableModel tableModel, Date start, Date end, boolean filter) {
    Session session = null;//from w w  w  .j a  va  2s .co m
    Criteria criteria = null;

    try {
        session = createNewSession();
        criteria = session.createCriteria(getReferenceClass());

        if (filter) {
            updateCriteriaFilters(criteria);
        }

        criteria.setFirstResult(0);
        criteria.setMaxResults(tableModel.getPageSize());
        if (start != null)
            criteria.add(Restrictions.ge(Ticket.PROP_DELIVERY_DATE, start));

        if (end != null)
            criteria.add(Restrictions.le(Ticket.PROP_DELIVERY_DATE, end));

        List ticketList = criteria.list();

        criteria.setProjection(Projections.rowCount());
        Integer rowCount = (Integer) criteria.uniqueResult();
        if (rowCount != null) {
            tableModel.setNumRows(rowCount);

        }

        tableModel.setCurrentRowIndex(0);

        return ticketList;

    } finally {
        closeSession(session);
    }
}