Example usage for org.hibernate.criterion Restrictions between

Introduction

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

Prototype

public static Criterion between(String propertyName, Object low, Object high) 

Source Link

Document

Apply a "between" constraint to the named property

Usage

From source file:com.inventory.system.dao.StaffDAOImpl.java

@Override
public List<Teacher> fetchTeacherByDateRange(Date fromDate, Date toDate) {
    Session session = HibernateBDUtil.getSessionFactory().openSession();
    List<Teacher> list;/* w  ww . j  a  va  2s  .c o  m*/

    Criteria criteria = session.createCriteria(Teacher.class);
    criteria.add(Restrictions.between("registeredDate", fromDate, toDate));
    criteria.setFirstResult(0);
    criteria.setMaxResults(500);
    criteria.addOrder(Order.desc("id"));
    list = criteria.list();

    return list;
}

---

From source file:com.inventory.system.dao.StaffDAOImpl.java

@Override
public List<NonTeachingStaff> fetchByDateRange(Date fromDate, Date toDate) {
    Session session = HibernateBDUtil.getSessionFactory().openSession();
    List<NonTeachingStaff> list;

    Criteria criteria = session.createCriteria(NonTeachingStaff.class);
    criteria.add(Restrictions.between("registeredDate", fromDate, toDate));
    criteria.setFirstResult(0);/*w  w  w  .java  2s  .  c om*/
    criteria.setMaxResults(500);
    criteria.addOrder(Order.desc("id"));
    list = criteria.list();

    return list;
}

---

From source file:com.inventory.system.dao.StudentRegistrationDAOImpl.java

@Override
public List<StudentRegistration> fetchStudentsByDateRange(Date fromDate, Date toDate) {
    Session session = HibernateBDUtil.getSessionFactory().openSession();
    List<StudentRegistration> list;

    Criteria criteria = session.createCriteria(StudentRegistration.class);
    criteria.add(Restrictions.between("registeredDate", fromDate, toDate));
    criteria.setFirstResult(0);//  ww w .jav  a  2 s  .co m
    criteria.setMaxResults(500);
    criteria.addOrder(Order.desc("id"));
    list = criteria.list();

    return list;
}

---

From source file:com.isdemu.dao.impl.TB_DescargoDaoImp.java

@Override
public List getTop() {
    DetachedCriteria dc = DetachedCriteria.forClass(TbDescargo.class);
    Date fecha_finalHoy = new Date();
    Date fecha_inicial = new Date();

    //restar dias a la fecha
    Calendar calendar = Calendar.getInstance();
    calendar.setTime(fecha_finalHoy);/*from  w  w w  .  jav  a 2s .  c o m*/
    calendar.add(Calendar.DAY_OF_YEAR, -7); // numero de das a aadir, o restar en caso de das<0
    fecha_inicial = calendar.getTime();

    dc.add(Restrictions.between("fecha", fecha_inicial, fecha_finalHoy));
    System.out.println("fecha inicial:" + fecha_inicial + "fecha final:" + fecha_finalHoy);

    return dc.getExecutableCriteria(sessionFactory.getCurrentSession()).list();
}

---

From source file:com.isdemu.dao.impl.TB_InventarioDaoImpl.java

@Override
public List getTop() {
    // TODO Auto-generated method stub
    DetachedCriteria dc = DetachedCriteria.forClass(TbInventario.class);
    dc.addOrder(Order.asc("idInventario"));

    Date fecha_finalHoy = new Date();
    Date fecha_inicial = new Date();

    //restar dias a la fecha
    Calendar calendar = Calendar.getInstance();
    calendar.setTime(fecha_finalHoy);//from   w  w w  . ja v  a 2s  .  co m
    calendar.add(Calendar.DAY_OF_YEAR, -7); // numero de das a aadir, o restar en caso de das<0
    fecha_inicial = calendar.getTime();

    dc.add(Restrictions.between("fechaInsert", fecha_inicial, fecha_finalHoy));
    System.out.println("fecha inicial:" + fecha_inicial + "fecha final:" + fecha_finalHoy);

    return dc.getExecutableCriteria(sessionFactory.getCurrentSession()).list();
}

---

From source file:com.isdemu.dao.impl.TB_MovimientoDaoImp.java

@Override
public List getTop() {
    // TODO Auto-generated method stub
    DetachedCriteria dc = DetachedCriteria.forClass(TbMovimiento.class, "movimiento");
    //dc.setFetchMode("TbrMovimientoInventario", FetchMode.JOIN);

    Date fecha_finalHoy = new Date();
    Date fecha_inicial = new Date();

    //restar dias a la fecha
    Calendar calendar = Calendar.getInstance();
    calendar.setTime(fecha_finalHoy);/*  ww  w  . j  a  v a2 s .  c  o m*/
    calendar.add(Calendar.DAY_OF_YEAR, -7); // numero de das a aadir, o restar en caso de das<0
    fecha_inicial = calendar.getTime();

    dc.add(Restrictions.between("fechaMovimiento", fecha_inicial, fecha_finalHoy));
    System.out.println("fecha inicial:" + fecha_inicial + "fecha final:" + fecha_finalHoy);

    // dc.add(Restrictions.ge("fechaMovimiento", highestDate));
    // dc.add(Restrictions.lt("fechaMovimiento", highestDate));

    return dc.getExecutableCriteria(sessionFactory.getCurrentSession()).list();

}

---

From source file:com.isotrol.impe3.web20.dao.impl.DAOImpl.java

License:Open Source License

private Criteria getCommentCriteria(CommentInternalFilterDTO filter) {
    Criteria c = newCriteria(CommentEntity.class);
    c.add(Restrictions.eq("deleted", Boolean.FALSE));

    if (filter.isValid() != null) {
        if (filter.isValid()) {
            c.add(Restrictions.eq("valid", Boolean.TRUE));
        } else {//from w  ww .j  a v a  2  s .c  o m
            c.add(Restrictions.eq("valid", Boolean.FALSE));
        }
    }

    if (filter.isModerated() != null) {
        if (filter.isModerated()) {
            c.add(Restrictions.isNotNull("lastModeration"));
        } else {
            c.add(Restrictions.isNull("lastModeration"));
        }
    }

    if (filter.getRelationship() != null) {
        c.createAlias("relationship", "rs", Criteria.LEFT_JOIN);
        c.add(Restrictions.eq("rs.id", filter.getRelationship()));
    }

    final Calendar dateInit = Calendar.getInstance();
    final Calendar dateEnd = Calendar.getInstance();

    if (filter.getLowDate() != null && filter.getHighDate() != null) {
        dateInit.setTime(filter.getLowDate());
        dateEnd.setTime(filter.getHighDate());
        c.add(Restrictions.between("date", dateInit, dateEnd));
    } else if (filter.getLowDate() != null) {
        dateInit.setTime(filter.getLowDate());
        c.add(Restrictions.ge("date", dateInit));
    } else if (filter.getHighDate() != null) {
        dateEnd.setTime(filter.getHighDate());
        c.add(Restrictions.le("date", dateEnd));
    }

    return c;
}

---

From source file:com.itrus.ca.modules.sys.service.LogService.java

License:Open Source License

public Page<Log> find(Page<Log> page, Map<String, Object> paramMap) {
    DetachedCriteria dc = logDao.createDetachedCriteria();

    Long createById = StringUtils.toLong(paramMap.get("createById"));
    if (createById > 0) {
        dc.add(Restrictions.eq("createBy.id", createById));
    }//  ww  w  .ja v  a  2 s  . c  o m

    String requestUri = ObjectUtils.toString(paramMap.get("requestUri"));
    if (StringUtils.isNotBlank(requestUri)) {
        dc.add(Restrictions.like("requestUri", "%" + EscapeUtil.escapeLike(requestUri) + "%"));
    }

    String exception = ObjectUtils.toString(paramMap.get("exception"));
    if (StringUtils.isNotBlank(exception)) {
        dc.add(Restrictions.eq("type", Log.TYPE_EXCEPTION));
    }

    Date beginDate = DateUtils.parseDate(paramMap.get("beginDate"));
    if (beginDate == null) {
        beginDate = DateUtils.setDays(new Date(), 1);
        paramMap.put("beginDate", DateUtils.formatDate(beginDate, "yyyy-MM-dd"));
    }
    Date endDate = DateUtils.parseDate(paramMap.get("endDate"));
    if (endDate == null) {
        endDate = DateUtils.addDays(DateUtils.addMonths(beginDate, 1), -1);
        paramMap.put("endDate", DateUtils.formatDate(endDate, "yyyy-MM-dd"));
    }
    dc.add(Restrictions.between("createDate", beginDate, endDate));

    dc.addOrder(Order.desc("id"));
    return logDao.find(page, dc);
}

---

From source file:com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateFilter.java

License:Open Source License

public void applyPropertyFilter(PropertyFilter filter) {
    Criterion propCriterion;/* w  ww .  j a v a 2 s.co m*/
    switch (filter.getOp()) {
    case PropertyFilter.EQ:
        propCriterion = Restrictions.eq(filter.getProperty(), filter.getValue());
        break;
    case PropertyFilter.LIKE:
        propCriterion = Restrictions.like(filter.getProperty(), filter.getValue());
        break;
    case PropertyFilter.GT:
        propCriterion = Restrictions.gt(filter.getProperty(), filter.getValue());
        break;
    case PropertyFilter.LT:
        propCriterion = Restrictions.lt(filter.getProperty(), filter.getValue());
        break;
    case PropertyFilter.BETWEEN:
        propCriterion = Restrictions.between(filter.getProperty(), filter.getLowValue(), filter.getHighValue());
        break;
    case PropertyFilter.IN:
        propCriterion = Restrictions.in(filter.getProperty(), filter.getValues());
        break;
    default:
        throw new JSException("jsexception.hibernate.unknown.property.filter.operation",
                new Object[] { new Byte(filter.getOp()) });
    }
    add(propCriterion);
}

---

From source file:com.jaspersoft.jasperserver.search.filter.TimeFilter.java

License:Open Source License

public void applyRestrictions(String type, ExecutionContext context, SearchCriteria criteria) {
    SearchAttributes searchAttributes = getSearchAttributes(context);

    if (searchAttributes != null && searchAttributes.getState() != null) {
        String timeFilter = searchAttributes.getState().getCustomFiltersMap().get("timeFilter");
        if (timeFilter != null && !timeFilter.equals("timeFilter-anyTime")) {
            Calendar cal = Calendar.getInstance();

            if (timeFilter.equals("timeFilter-today")) {
                cal.setTime(new Date());
                resetDateTime(cal);//from  w w  w  . j a v  a  2 s  .c  o m
                Date startDate = cal.getTime();

                criteria.add(Restrictions.gt("updateDate", startDate));
            } else if (timeFilter.equals("timeFilter-yesterday")) {
                cal.setTime(new Date());
                resetDateTime(cal);
                Date endDate = cal.getTime();

                cal.setTime(rollDay(new Date(), -1));
                resetDateTime(cal);
                Date startDate = cal.getTime();

                criteria.add(Restrictions.between("updateDate", startDate, endDate));
            } else if (timeFilter.equals("timeFilter-pastWeek")) {
                cal.setTime(new Date());
                cal.setTime(rollDay(new Date(), -7));
                resetDateTime(cal);
                Date startDate = cal.getTime();

                criteria.add(Restrictions.gt("updateDate", startDate));
            } else if (timeFilter.equals("timeFilter-pastMonth")) {
                cal.setTime(new Date());
                cal.setTime(rollDay(new Date(), -30));
                resetDateTime(cal);
                Date startDate = cal.getTime();

                criteria.add(Restrictions.gt("updateDate", startDate));
            }
        }
    }
}

---

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