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.egov.mrs.application.reports.service.MarriageRegistrationReportsService.java

License:Open Source License

@ReadOnly
@SuppressWarnings("unchecked")
public List<MarriageRegistration> searchRegistrationBymonth(final MarriageRegistration registration,
        final String month, final String registrationUnit) {
    final Criteria criteria = getCurrentSession()
            .createCriteria(MarriageRegistration.class, MARRIAGE_REGISTRATION)
            .createAlias(MARRIAGE_REGISTRATION_STATUS, STATUS);
    if (month != null)
        criteria.add(Restrictions.between(MARRIAGE_REGISTRATION_APPLICATION_DATE, getMonthStartday(month),
                getMonthEndday(month)));
    if (registration.getZone() != null)
        criteria.createAlias(MARRIAGE_REGISTRATION + ".zone", "zone")
                .add(Restrictions.eq(ZONE_ID, registration.getZone().getId().toString()));

    if (registrationUnit != null)
        criteria.createAlias(MARRIAGE_REGISTRATION + DOT_MARRIAGE_REGISTRATION_UNIT, REGUNIT)
                .add(Restrictions.eq("regunit.name", registrationUnit));
    criteria.add(Restrictions.in(STATUS_DOT_CODE, MarriageRegistration.RegistrationStatus.REGISTERED.name()));
    return criteria.list();
}

---

From source file:org.egov.mrs.application.reports.service.MarriageRegistrationReportsService.java

License:Open Source License

@ReadOnly
@SuppressWarnings("unchecked")
public List<ReIssue> searchReissueBymonth(final MarriageRegistration registration, final String month,
        final String registrationUnit) {
    final Criteria criteria = getCurrentSession().createCriteria(ReIssue.class, "reissue")
            .createAlias("reissue.status", STATUS);

    if (month != null)
        criteria.add(Restrictions.between("reissue.applicationDate", getMonthStartday(month),
                getMonthEndday(month)));
    if (registration.getZone() != null)
        criteria.createAlias(MARRIAGE_REGISTRATION + ".zone", "zone")
                .add(Restrictions.eq(ZONE_ID, registration.getZone().getId().toString()));
    if (registrationUnit != null)
        criteria.createAlias("reissue.marriageRegistrationUnit", REGUNIT)
                .add(Restrictions.eq("regunit.name", registrationUnit));
    criteria.add(Restrictions.in(STATUS_DOT_CODE, "CERTIFICATEREISSUED"));
    return criteria.list();
}

---

From source file:org.egov.mrs.application.reports.service.MarriageRegistrationReportsService.java

License:Open Source License

@ReadOnly
@SuppressWarnings("unchecked")
public List<MarriageRegistration> getmonthWiseActDetails(final int year, final int month, final Long actid) {
    final Criteria criteria = getCurrentSession()
            .createCriteria(MarriageRegistration.class, MARRIAGE_REGISTRATION)
            .createAlias(MARRIAGE_REGISTRATION_STATUS, STATUS);
    final String monthYear = month + "/" + year;
    if (actid != null)
        criteria.createAlias("marriageRegistration.marriageAct", "marriageAct")
                .add(Restrictions.eq("marriageAct.id", actid));
    if (StringUtils.isNotBlank(monthYear))
        criteria.add(Restrictions.between(MARRIAGE_REGISTRATION_APPLICATION_DATE, getMonthStartday(monthYear),
                getMonthEndday(monthYear)));

    criteria.add(Restrictions.in(STATUS_DOT_CODE, MarriageRegistration.RegistrationStatus.APPROVED.name()));
    return criteria.list();
}

---

From source file:org.egov.mrs.domain.service.MarriageRegistrationService.java

License:Open Source License

private void buildReIssueSearchCriteria(final MarriageRegistrationSearchFilter mrSearchFilter,
        final Criteria criteria) {
    criteria.createAlias("reIssue.registration", "registration");
    if (mrSearchFilter.getRegistrationNo() != null)
        criteria.add(Restrictions.ilike("registration.registrationNo", mrSearchFilter.getRegistrationNo(),
                MatchMode.ANYWHERE));// w  ww .  j  a  v  a  2  s .c om
    if (mrSearchFilter.getApplicationNo() != null)
        criteria.add(Restrictions.ilike("reIssue.applicationNo", mrSearchFilter.getApplicationNo(),
                MatchMode.ANYWHERE));
    if (mrSearchFilter.getHusbandName() != null)
        criteria.createAlias("registration.husband", "husband").add(Restrictions.ilike("husband.name.fullname",
                mrSearchFilter.getHusbandName(), MatchMode.ANYWHERE));
    if (mrSearchFilter.getWifeName() != null)
        criteria.createAlias("registration.wife", "wife").add(
                Restrictions.ilike("wife.name.fullname", mrSearchFilter.getWifeName(), MatchMode.ANYWHERE));
    if (mrSearchFilter.getApplicationDate() != null)
        criteria.add(Restrictions.between(RE_ISSUE_APPLICATION_DATE,
                toDateUsingDefaultPattern(mrSearchFilter.getApplicationDate()),
                org.apache.commons.lang3.time.DateUtils
                        .addDays(toDateUsingDefaultPattern(mrSearchFilter.getApplicationDate()), 1)));
    if (mrSearchFilter.getDateOfMarriage() != null)
        criteria.add(Restrictions.between("registration.dateOfMarriage",
                toDateUsingDefaultPattern(mrSearchFilter.getDateOfMarriage()),
                org.apache.commons.lang3.time.DateUtils
                        .addDays(toDateUsingDefaultPattern(mrSearchFilter.getDateOfMarriage()), 0)));
    if (mrSearchFilter.getFromDate() != null)
        criteria.add(Restrictions.ge(RE_ISSUE_APPLICATION_DATE,
                marriageRegistrationReportsService.resetFromDateTimeStamp(mrSearchFilter.getFromDate())));
    if (mrSearchFilter.getToDate() != null)
        criteria.add(Restrictions.le(RE_ISSUE_APPLICATION_DATE,
                marriageRegistrationReportsService.resetToDateTimeStamp(mrSearchFilter.getToDate())));
    if (mrSearchFilter.getMarriageRegistrationUnit() != null)
        criteria.add(
                Restrictions.eq("marriageRegistrationUnit.id", mrSearchFilter.getMarriageRegistrationUnit()));
}

---

From source file:org.egov.mrs.domain.service.MarriageRegistrationService.java

License:Open Source License

private void buildMarriageRegistrationSearchCriteria(final MarriageRegistration registration,
        final Criteria criteria) {
    if (registration.getRegistrationNo() != null)
        criteria.add(Restrictions.ilike("marriageRegistration.registrationNo", registration.getRegistrationNo(),
                MatchMode.ANYWHERE));// w  w w . ja va2 s  .c  o m
    if (registration.getApplicationNo() != null)
        criteria.add(Restrictions.ilike("marriageRegistration.applicationNo", registration.getApplicationNo(),
                MatchMode.ANYWHERE));
    if (registration.getHusband() != null && registration.getHusband().getName() != null
            && !"null".equals(registration.getHusband().getFullName())
            && registration.getHusband().getFullName() != null)
        criteria.createAlias("marriageRegistration.husband", "husband").add(Restrictions
                .ilike("husband.name.fullname", registration.getHusband().getFullName(), MatchMode.ANYWHERE));
    if (registration.getWife() != null && registration.getWife().getName() != null
            && !"null".equals(registration.getWife().getFullName())
            && registration.getWife().getFullName() != null)
        criteria.createAlias("marriageRegistration.wife", "wife").add(Restrictions.ilike("wife.name.fullname",
                registration.getWife().getFullName(), MatchMode.ANYWHERE));
    if (registration.getApplicationDate() != null)
        criteria.add(Restrictions.between(MARRIAGE_REGISTRATION_DOT_APPLICATION_DATE,
                registration.getApplicationDate(),
                org.apache.commons.lang3.time.DateUtils.addDays(registration.getApplicationDate(), 1)));
    if (registration.getDateOfMarriage() != null)
        criteria.add(
                Restrictions.between("marriageRegistration.dateOfMarriage", registration.getDateOfMarriage(),
                        org.apache.commons.lang3.time.DateUtils.addDays(registration.getDateOfMarriage(), 0)));
    if (registration.getFromDate() != null)
        criteria.add(Restrictions.ge(MARRIAGE_REGISTRATION_DOT_APPLICATION_DATE,
                marriageRegistrationReportsService.resetFromDateTimeStamp(registration.getFromDate())));
    if (registration.getToDate() != null)
        criteria.add(Restrictions.le(MARRIAGE_REGISTRATION_DOT_APPLICATION_DATE,
                marriageRegistrationReportsService.resetToDateTimeStamp(registration.getToDate())));
    if (null != registration.getMarriageRegistrationUnit()
            && registration.getMarriageRegistrationUnit().getId() != null)
        criteria.add(Restrictions.eq("marriageRegistrationUnit.id",
                registration.getMarriageRegistrationUnit().getId()));
}

---

From source file:org.egov.pgr.service.ComplaintTypeService.java

License:Open Source License

/**
 * List top 5 complaint types filed in last one month
 *
 * @return complaint Type list//from w ww  .j a  va2s . co  m
 */
@ReadOnly
public List<ComplaintType> getFrequentlyFiledComplaints() {

    DateTime previousDate = new DateTime();
    DateTime currentDate = new DateTime();
    previousDate = previousDate.minusMonths(1);

    Criteria criteria = entityManager.unwrap(Session.class).createCriteria(Complaint.class, "complaint");
    criteria.createAlias(COMPLAINT_COMPLAINT_TYPE, "compType");
    criteria.setProjection(Projections.projectionList().add(Projections.property(COMPLAINT_COMPLAINT_TYPE))
            .add(Projections.count(COMPLAINT_COMPLAINT_TYPE).as("count"))
            .add(Projections.groupProperty(COMPLAINT_COMPLAINT_TYPE)));
    criteria.add(Restrictions.between("complaint.createdDate", previousDate.toDate(), currentDate.toDate()));
    criteria.add(Restrictions.eq("compType.isActive", Boolean.TRUE));
    criteria.setMaxResults(5).addOrder(Order.desc("count"));
    List<Object> resultList = criteria.list();
    List<ComplaintType> complaintTypeList = new ArrayList<>();

    for (Object row : resultList) {
        Object[] columns = (Object[]) row;
        complaintTypeList.add((ComplaintType) columns[0]);
    }
    return complaintTypeList;

}

---

From source file:org.egov.pims.service.PersonalInformationService.java

License:Open Source License

private Criteria getCriteriaForEmpSearchByStatus(Integer statusid, Date fromDate, Date toDate) {
    EgwStatus egwStatus = egwStatusHibernateDAO.findById(statusid, false);
    DetachedCriteria detachCriteriaPersonalInfo = DetachedCriteria.forClass(PersonalInformation.class, "emp");
    if (egwStatus.getModuletype().equals("Employee")
            && egwStatus.getDescription().equalsIgnoreCase("Employed")) {
        detachCriteriaPersonalInfo.createAlias("emp.egpimsAssignment", "assPrd")
                .add(Restrictions.and(Restrictions.le("assPrd.fromDate", toDate), Restrictions
                        .or(Restrictions.ge("assPrd.toDate", toDate), Restrictions.isNull("assPrd.toDate"))));

    } else if (egwStatus.getModuletype().equals("Employee")
            && egwStatus.getDescription().equalsIgnoreCase("Retired")) {
        detachCriteriaPersonalInfo.add(Restrictions.between("emp.retirementDate", fromDate, toDate));

    } else if (egwStatus.getModuletype().equals("Employee")
            && egwStatus.getDescription().equalsIgnoreCase("Deceased")) {
        detachCriteriaPersonalInfo.add(Restrictions.between("emp.deathDate", fromDate, toDate));
    }/*from w  w  w  . j a v a2 s.c  o  m*/
    return detachCriteriaPersonalInfo.getExecutableCriteria(getCurrentSession());
}

---

From source file:org.egov.ptis.domain.dao.property.SearchPropertyHibernateDAO.java

License:Open Source License

/**
 * either objectionNumber or any of the date fields are mandatory
 * //www. j  ava 2  s  .com
 * @param propertyTypeMasterId
 * @param objectionNumber
 * @param fromObjection
 * @param toObjection
 * @return
 * @throws ValidationException
 *             when mandatory fields not passed
 */
@Override
public List<Property> getPropertyByObjectionDetails(Long propertyTypeMasterId, String objectionNumber,
        Date fromObjection, Date toObjection) throws ValidationException {
    if ((objectionNumber == null || objectionNumber.trim().isEmpty())
            && (fromObjection == null && toObjection == null))
        throw new ValidationException("ObjectioNumber or ObjectionDate is mandatory",
                "ObjectioNumber or ObjectionDate is mandatory");
    Criteria propertyCriteria = getCurrentSession().createCriteria(PropertyImpl.class, "propertyImpl")
            .add(Restrictions.eq("status", PropertyTaxConstants.STATUS_ISACTIVE));
    DetachedCriteria detachCrtObjection = DetachedCriteria.forClass(RevisionPetition.class);
    detachCrtObjection.setProjection(Projections.projectionList().add(Projections.property("basicProperty")));
    if (propertyTypeMasterId != null && propertyTypeMasterId > 0) {
        propertyCriteria.createAlias("propertyDetail", "propertyDetail");
        propertyCriteria.createAlias("propertyDetail.propertyTypeMaster", "propertyTypeMaster");
        propertyCriteria.add(Restrictions.eq("propertyTypeMaster.id", propertyTypeMasterId));
    }
    if (objectionNumber != null && !objectionNumber.trim().isEmpty()) {
        detachCrtObjection.add(Restrictions.ilike("objectionNumber", objectionNumber));
    }
    if (fromObjection != null && toObjection != null) {
        detachCrtObjection.add(Restrictions.between("recievedOn", fromObjection, toObjection));
    } else if (fromObjection != null) {
        detachCrtObjection.add(Restrictions.ge("recievedOn", fromObjection));
    } else if (toObjection != null) {
        detachCrtObjection.add(Restrictions.le("recievedOn", toObjection));
    }
    propertyCriteria.add(Subqueries.propertyIn("basicProperty", detachCrtObjection));
    return propertyCriteria.list();
}

---

From source file:org.encuestame.persistence.dao.imp.AbstractHibernateDaoSupport.java

License:Apache License

/**
 * Set a Criteria between date calculating start and end date.
 * @param searchPeriods {@link SearchPeriods}.
 * @param criteria DetachedCriteria/*w  ww. j  a v a2 s. c o  m*/
 */
protected void calculateSearchPeriodsDates(final SearchPeriods searchPeriods, final DetachedCriteria criteria,
        final String dateProperty) {
    if (searchPeriods != null) {
        final DateTime endDateTime = new DateTime();
        final DateTime startDateTime = endDateTime.minusDays(searchPeriods.toDays());
        if (endDateTime.isAfter(startDateTime)) {
            criteria.add(Restrictions.between(dateProperty, startDateTime.toDate(), endDateTime.toDate()));
        }
    }
}

---

From source file:org.encuestame.persistence.dao.imp.AccountDaoImp.java

License:Apache License

/**
 * Get user accounts by status./*from ww w .ja  v a  2 s.c o m*/
 * @param status
 * @return
 */
public List<UserAccount> getUserAccountsbyStatus(final Boolean status, final Date beforeDate,
        final Date afterDate) {
    final DetachedCriteria criteria = DetachedCriteria.forClass(UserAccount.class);
    criteria.add(Restrictions.eq("userStatus", status));
    criteria.add(Restrictions.between("enjoyDate", beforeDate, afterDate));
    return (List<UserAccount>) getHibernateTemplate().findByCriteria(criteria);
}

---

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