Example usage for org.hibernate.criterion Restrictions lt

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

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

Introduction

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

Prototype

public static SimpleExpression lt(String propertyName, Object value)

Source Link

Document

Apply a "less than" constraint to the named property

Usage

From source file:org.openmrs.module.openhmis.commons.api.entity.search.BaseObjectTemplateSearch.java

License:Open Source License

protected Criterion createCriterion(String field, Date value, DateComparisonType comparisonType) {
    DateComparisonType comparison = comparisonType == null ? DateComparisonType.EQUAL : comparisonType;

    Criterion result;// ww w . ja v  a2 s  . co  m
    switch (comparison) {
    case EQUAL:
        result = Restrictions.eq(field, value);
        break;
    case NOT_EQUAL:
        result = Restrictions.ne(field, value);
        break;
    case IS_NULL:
        result = Restrictions.isNull(field);
        break;
    case IS_NOT_NULL:
        result = Restrictions.isNotNull(field);
        break;
    case GREATER_THAN:
        result = Restrictions.gt(field, value);
        break;
    case GREATER_THAN_EQUAL:
        result = Restrictions.ge(field, value);
        break;
    case LESS_THAN:
        result = Restrictions.lt(field, value);
        break;
    case LESS_THAN_EQUAL:
        result = Restrictions.le(field, value);
        break;
    default:
        throw new IllegalArgumentException();
    }

    return result;
}

From source file:org.openmrs.module.orderextension.api.db.HibernateOrderExtensionDAO.java

License:Open Source License

/**
  * @see org.openmrs.module.orderextension.api.db.OrderExtensionDAO#getExtendedDrugOrdersForPatient(Patient patient)
  *//*from   ww  w .j a  va  2  s .  c o m*/
@Override
public List<ExtendedDrugOrder> getExtendedDrugOrdersForPatient(Patient patient, Concept indication,
        Date startDateAfter, Date startDateBefore) {
    Criteria criteria = getCurrentSession().createCriteria(ExtendedDrugOrder.class);

    if (patient != null) {
        criteria.add(Restrictions.eq("patient", patient));
    }

    if (indication != null) {
        criteria.add(Restrictions.eq("indication", indication));
    }
    if (startDateAfter != null && startDateBefore != null) {
        criteria.add(Restrictions.between("startDate", startDateAfter, startDateBefore));
    } else if (startDateAfter != null) {
        criteria.add(Restrictions.ge("startDate", startDateAfter));
    } else if (startDateBefore != null) {
        criteria.add(Restrictions.lt("startDate", startDateBefore));
    }
    criteria.add(Restrictions.eq("voided", false));
    return criteria.list();
}

From source file:org.openmrs.module.sync.api.db.hibernate.HibernateSyncDAO.java

License:Open Source License

/**
 * @see org.openmrs.module.sync.api.SyncService#getPreviousRecord(SyncRecord)
 *//*  www.ja va 2s.co m*/
public SyncRecord getPreviousRecord(SyncRecord record) {
    Criteria criteria = sessionFactory.getCurrentSession().createCriteria(SyncRecord.class);
    criteria.setProjection(Projections.max("recordId"));
    criteria.add(Restrictions.lt("recordId", record.getRecordId()));
    Object prevRecordId = criteria.uniqueResult();
    if (prevRecordId == null) {
        return null;
    }
    return getSyncRecord((Integer) prevRecordId);
}

From source file:org.openmrs.module.sync.api.db.hibernate.HibernateSyncDAO.java

License:Open Source License

/**
 * @see org.openmrs.module.sync.api.db.SyncDAO#getOlderSyncRecordInState(org.openmrs.module.sync.SyncRecord,
 *      java.util.EnumSet)//from ww  w  .  j a v  a2  s . c om
 */
public SyncRecord getOlderSyncRecordInState(SyncRecord syncRecord, EnumSet<SyncRecordState> states) {
    Criteria criteria = sessionFactory.getCurrentSession().createCriteria(SyncRecord.class);
    criteria.createAlias("serverRecords", "serverRecord", Criteria.LEFT_JOIN);
    criteria.add(Restrictions.le("timestamp", syncRecord.getTimestamp()));
    // We need to look for a lower recordId since some may have the same timestamp.
    criteria.add(Restrictions.lt("recordId", syncRecord.getRecordId()));
    // We need to look for errors in both SyncRecord and SyncRecordServer.
    criteria.add(
            Restrictions.or(Restrictions.in("state", states), Restrictions.in("serverRecord.state", states)));
    criteria.addOrder(Order.desc("timestamp"));
    criteria.addOrder(Order.desc("recordId"));
    criteria.setMaxResults(1);
    return (SyncRecord) criteria.uniqueResult();
}

From source file:org.opennms.netmgt.dao.hibernate.AtInterfaceDaoHibernate.java

License:Open Source License

@Override
public void deactivateForSourceNodeIdIfOlderThan(final int nodeid, final Date scanTime) {
    OnmsCriteria criteria = new OnmsCriteria(OnmsAtInterface.class);
    criteria.add(Restrictions.eq("sourceNodeId", nodeid));
    criteria.add(Restrictions.lt("lastPollTime", scanTime));
    criteria.add(Restrictions.eq("status", StatusType.ACTIVE));

    for (final OnmsAtInterface iface : findMatching(criteria)) {
        iface.setStatus(StatusType.INACTIVE);
        saveOrUpdate(iface);//ww w.j  a v a 2 s.  co  m
    }
}

From source file:org.opennms.netmgt.dao.hibernate.AtInterfaceDaoHibernate.java

License:Open Source License

@Override
public void deleteForNodeSourceIdIfOlderThan(final int nodeid, final Date scanTime) {
    OnmsCriteria criteria = new OnmsCriteria(OnmsAtInterface.class);
    criteria.add(Restrictions.eq("sourceNodeId", nodeid));
    criteria.add(Restrictions.lt("lastPollTime", scanTime));
    criteria.add(Restrictions.not(Restrictions.eq("status", StatusType.ACTIVE)));

    for (final OnmsAtInterface iface : findMatching(criteria)) {
        delete(iface);/*ww  w.j  a v  a2  s  . c o  m*/
    }
}

From source file:org.opennms.netmgt.dao.hibernate.IpRouteInterfaceDaoHibernate.java

License:Open Source License

@Override
public void deactivateForNodeIdIfOlderThan(final int nodeid, final Date scanTime) {
    final OnmsCriteria criteria = new OnmsCriteria(OnmsIpRouteInterface.class);
    criteria.createAlias("node", "node", OnmsCriteria.LEFT_JOIN);
    criteria.add(Restrictions.eq("node.id", nodeid));
    criteria.add(Restrictions.lt("lastPollTime", scanTime));
    criteria.add(Restrictions.eq("status", StatusType.ACTIVE));

    for (final OnmsIpRouteInterface item : findMatching(criteria)) {
        item.setStatus(StatusType.INACTIVE);
        saveOrUpdate(item);//from  w w  w  .j a  v a 2s.  c om
    }
}

From source file:org.opennms.netmgt.dao.hibernate.IpRouteInterfaceDaoHibernate.java

License:Open Source License

@Override
public void deleteForNodeIdIfOlderThan(final int nodeid, final Date scanTime) {
    final OnmsCriteria criteria = new OnmsCriteria(OnmsIpRouteInterface.class);
    criteria.createAlias("node", "node", OnmsCriteria.LEFT_JOIN);
    criteria.add(Restrictions.eq("node.id", nodeid));
    criteria.add(Restrictions.lt("lastPollTime", scanTime));
    criteria.add(Restrictions.not(Restrictions.eq("status", StatusType.ACTIVE)));

    for (final OnmsIpRouteInterface item : findMatching(criteria)) {
        delete(item);/*from   w w  w  .  j  av a  2  s.  c  o m*/
    }
}

From source file:org.opennms.netmgt.dao.hibernate.StpInterfaceDaoHibernate.java

License:Open Source License

@Override
public void deactivateForNodeIdIfOlderThan(final int nodeid, final Date scanTime) {
    final OnmsCriteria criteria = new OnmsCriteria(OnmsStpInterface.class);
    criteria.createAlias("node", "node", OnmsCriteria.LEFT_JOIN);
    criteria.add(Restrictions.eq("node.id", nodeid));
    criteria.add(Restrictions.lt("lastPollTime", scanTime));
    criteria.add(Restrictions.eq("status", StatusType.ACTIVE));

    for (final OnmsStpInterface item : findMatching(criteria)) {
        item.setStatus(StatusType.INACTIVE);
        saveOrUpdate(item);/*www . j av a  2  s  .c om*/
    }
}

From source file:org.opennms.netmgt.dao.hibernate.StpInterfaceDaoHibernate.java

License:Open Source License

@Override
public void deleteForNodeIdIfOlderThan(final int nodeid, final Date scanTime) {
    final OnmsCriteria criteria = new OnmsCriteria(OnmsStpInterface.class);
    criteria.createAlias("node", "node", OnmsCriteria.LEFT_JOIN);
    criteria.add(Restrictions.eq("node.id", nodeid));
    criteria.add(Restrictions.lt("lastPollTime", scanTime));
    criteria.add(Restrictions.not(Restrictions.eq("status", StatusType.ACTIVE)));

    for (final OnmsStpInterface item : findMatching(criteria)) {
        delete(item);/*from   w ww  .  ja v a  2 s  . c  o m*/
    }
}