Example usage for org.hibernate.criterion Restrictions le

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

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

Introduction

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

Prototype

public static SimpleExpression le(String propertyName, Object value)

Source Link

Document

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

Usage

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 2s .c  o 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;//  w  w w. j  a v a2 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 ava  2s.co 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  . j a  va2  s. co 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) {/*from   w  ww.ja  v a 2s .  c o  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) {/*ww w  . ja v  a2s .c  o  m*/
    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  av  a2 s . c  o 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);
    }
}

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

License:Open Source License

public List<Ticket> findNextTickets(PaginatedTableModel tableModel, Date start, Date end, boolean filter) {
    Session session = null;/*from  ww  w  . ja va2s  . co  m*/
    Criteria criteria = null;

    try {
        int nextIndex = tableModel.getNextRowIndex();

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

        if (filter) {
            updateCriteriaFilters(criteria);
        }

        criteria.setFirstResult(nextIndex);
        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(nextIndex);

        return ticketList;

    } finally {
        closeSession(session);
    }
}

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

License:Open Source License

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

        int previousIndex = tableModel.getPreviousRowIndex();

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

        if (filter) {
            updateCriteriaFilters(criteria);
        }

        criteria.setFirstResult(previousIndex);
        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(previousIndex);

        return ticketList;

    } finally {
        closeSession(session);
    }
}

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

License:Open Source License

public int getNumTickets(Date start, Date end) {
    Session session = null;//www  .j  a v a  2 s. c o m
    Criteria criteria = null;
    try {
        session = createNewSession();
        criteria = session.createCriteria(getReferenceClass());
        criteria.add(Restrictions.eq(Ticket.PROP_CLOSED, Boolean.FALSE));
        if (start != null)
            criteria.add(Restrictions.ge(Ticket.PROP_DELIVERY_DATE, start));

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

        criteria.add(Restrictions.isNotNull(Ticket.PROP_DELIVERY_DATE));
        criteria.setProjection(Projections.rowCount());
        Number rowCount = (Number) criteria.uniqueResult();
        if (rowCount != null) {
            return rowCount.intValue();
        }
        return 0;
    } finally {
        closeSession(session);
    }
}