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:org.openmrs.module.accessmonitor.api.db.hibernate.HibernatePersonAccessDAO.java

License:Open Source License

public List<PersonServiceAccess> getPersonServiceAccessesByPersonId(Integer personId, Date from, Date to) {
    Criteria crit = sessionFactory.getCurrentSession().createCriteria(PersonServiceAccess.class);
    crit.add(Restrictions.eq("personId", personId));
    if (from != null || to != null) {
        if (from == null) {
            crit.add(Restrictions.le("accessDate", to));
        } else if (to == null) {
            crit.add(Restrictions.ge("accessDate", from));
        } else {//ww w  . jav a  2s  .  c  o  m
            crit.add(Restrictions.between("accessDate", from, to));
        }
    }
    return crit.list();
}

---

From source file:org.openmrs.module.accessmonitor.api.db.hibernate.HibernatePersonAccessDAO.java

License:Open Source License

public List<PersonServiceAccess> getPersonServiceAccessesByPersonUuid(String personUuid, Date from, Date to) {
    Criteria crit = sessionFactory.getCurrentSession().createCriteria(PersonServiceAccess.class);
    crit.add(Restrictions.eq("personUuid", personUuid));
    if (from != null || to != null) {
        if (from == null) {
            crit.add(Restrictions.le("accessDate", to));
        } else if (to == null) {
            crit.add(Restrictions.ge("accessDate", from));
        } else {//from   w ww .ja  v a 2  s .com
            crit.add(Restrictions.between("accessDate", from, to));
        }
    }
    return crit.list();
}

---

From source file:org.openmrs.module.accessmonitor.api.db.hibernate.HibernatePersonAccessDAO.java

License:Open Source License

public List<PersonServiceAccess> getPersonServiceAccessesByAccessType(String accessType, Date from, Date to) {
    Criteria crit = sessionFactory.getCurrentSession().createCriteria(PersonServiceAccess.class);
    crit.add(Restrictions.eq("accessType", accessType));
    if (from != null || to != null) {
        if (from == null) {
            crit.add(Restrictions.le("accessDate", to));
        } else if (to == null) {
            crit.add(Restrictions.ge("accessDate", from));
        } else {//w w  w  .  j a v a2s .  c  o m
            crit.add(Restrictions.between("accessDate", from, to));
        }
    }
    return crit.list();
}

---

From source file:org.openmrs.module.accessmonitor.api.db.hibernate.HibernatePersonAccessDAO.java

License:Open Source License

public List<PersonServiceAccess> getPersonServiceAccessesByVoidReason(String voidReason, Date from, Date to) {
    Criteria crit = sessionFactory.getCurrentSession().createCriteria(PersonServiceAccess.class);
    crit.add(Restrictions.eq("voidReason", voidReason));
    if (from != null || to != null) {
        if (from == null) {
            crit.add(Restrictions.le("accessDate", to));
        } else if (to == null) {
            crit.add(Restrictions.ge("accessDate", from));
        } else {/*from  ww  w . j  ava  2 s.co  m*/
            crit.add(Restrictions.between("accessDate", from, to));
        }
    }
    return crit.list();
}

---

From source file:org.openmrs.module.accessmonitor.api.db.hibernate.HibernateVisitAccessDAO.java

public List<VisitServiceAccess> getVisitAccessesByAccessDateOrderByPatientId(Date from, Date to) {
    Criteria crit = sessionFactory.getCurrentSession().createCriteria(VisitServiceAccess.class);
    crit.addOrder(Order.asc("patientId"));
    if (from != null || to != null) {
        if (from == null) {
            crit.add(Restrictions.le("accessDate", to));
        } else if (to == null) {
            crit.add(Restrictions.ge("accessDate", from));
        } else {//from w w w . j av a2s.  c o m
            crit.add(Restrictions.between("accessDate", from, to));
        }
    }
    return crit.list();
}

---

From source file:org.openmrs.module.accessmonitor.api.db.hibernate.HibernateVisitAccessDAO.java

public List<VisitServiceAccess> getVisitServiceAccessesByAccessorId(Integer accessorId, Date from, Date to) {
    Criteria crit = sessionFactory.getCurrentSession().createCriteria(VisitServiceAccess.class);
    crit.add(Restrictions.eq("accessorId", accessorId));
    if (from != null || to != null) {
        if (from == null) {
            crit.add(Restrictions.le("accessDate", to));
        } else if (to == null) {
            crit.add(Restrictions.ge("accessDate", from));
        } else {//www  . ja  va  2 s. com
            crit.add(Restrictions.between("accessDate", from, to));
        }
    }
    return crit.list();
}

---

From source file:org.openmrs.module.accessmonitor.api.db.hibernate.HibernateVisitAccessDAO.java

public List<VisitServiceAccess> getVisitServiceAccessesByPatientId(Integer patientId, Date from, Date to) {
    Criteria crit = sessionFactory.getCurrentSession().createCriteria(VisitServiceAccess.class);
    crit.add(Restrictions.eq("patientId", patientId));
    if (from != null || to != null) {
        if (from == null) {
            crit.add(Restrictions.le("accessDate", to));
        } else if (to == null) {
            crit.add(Restrictions.ge("accessDate", from));
        } else {/*from   ww w .jav  a 2 s.c o m*/
            crit.add(Restrictions.between("accessDate", from, to));
        }
    }
    return crit.list();
}

---

From source file:org.openmrs.module.accessmonitor.api.db.hibernate.HibernateVisitAccessDAO.java

public List<VisitServiceAccess> getVisitServiceAccessesByVisitId(Integer visitId, Date from, Date to) {
    Criteria crit = sessionFactory.getCurrentSession().createCriteria(VisitServiceAccess.class);
    crit.add(Restrictions.eq("visitId", visitId));
    if (from != null || to != null) {
        if (from == null) {
            crit.add(Restrictions.le("accessDate", to));
        } else if (to == null) {
            crit.add(Restrictions.ge("accessDate", from));
        } else {/*from  w  w w  . j  av  a2 s .c o  m*/
            crit.add(Restrictions.between("accessDate", from, to));
        }
    }
    return crit.list();
}

---

From source file:org.openmrs.module.accessmonitor.api.db.hibernate.HibernateVisitAccessDAO.java

public List<VisitServiceAccess> getVisitServiceAccessesByVisitType(String visitType, Date from, Date to) {
    Criteria crit = sessionFactory.getCurrentSession().createCriteria(VisitServiceAccess.class);
    crit.add(Restrictions.eq("visitType", visitType));
    if (from != null || to != null) {
        if (from == null) {
            crit.add(Restrictions.le("accessDate", to));
        } else if (to == null) {
            crit.add(Restrictions.ge("accessDate", from));
        } else {/*from  w ww  .  jav  a 2s  . co  m*/
            crit.add(Restrictions.between("accessDate", from, to));
        }
    }
    return crit.list();
}

---

From source file:org.openmrs.module.accessmonitor.api.db.hibernate.HibernateVisitAccessDAO.java

public List<VisitServiceAccess> getVisitServiceAccessesByAccessType(String accessType, Date from, Date to) {
    Criteria crit = sessionFactory.getCurrentSession().createCriteria(VisitServiceAccess.class);
    crit.add(Restrictions.eq("accessType", accessType));
    if (from != null || to != null) {
        if (from == null) {
            crit.add(Restrictions.le("accessDate", to));
        } else if (to == null) {
            crit.add(Restrictions.ge("accessDate", from));
        } else {//from  ww w.  ja v  a2 s  . c  o  m
            crit.add(Restrictions.between("accessDate", from, to));
        }
    }
    return crit.list();
}

---

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