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.quakearts.webapp.hibernate.HibernateBean.java

License:Open Source License

private Criterion createCriterion(String key, Serializable value, QueryContext context) {
    key = handleKey(key, context);/*  ww w  . jav  a  2s .c  o  m*/
    if (value instanceof Range) {
        Range range = (Range) value;
        if (range.getFrom() != null && range.getTo() == null)
            return Restrictions.ge(key, ((Range) value).getFrom());
        else if (range.getFrom() == null && range.getTo() != null)
            return Restrictions.le(key, ((Range) value).getTo());

        return Restrictions.between(key, range.getFrom(), range.getTo());
    } else if (value instanceof VariableString) {
        return Restrictions.ilike(key, ((VariableString) value).getValue());
    } else {
        return Restrictions.eq(key, value);
    }
}

From source file:com.salesmanager.core.service.order.impl.dao.OrderDao.java

License:Open Source License

public SearchOrderResponse searchInvoice(SearchOrdersCriteria searchCriteria) {

    Criteria criteria = super.getSession().createCriteria(Order.class)
            .add(Restrictions.eq("merchantId", searchCriteria.getMerchantId()))
            .add(Restrictions.eq("channel", OrderConstants.INVOICE_CHANNEL))
            .add(Restrictions.eq("orderStatus", OrderConstants.STATUSINVOICED))
            .addOrder(org.hibernate.criterion.Order.desc("orderId"))
            .setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);

    StringBuffer q = new StringBuffer();

    q.append(" select o from Order o where o.merchantId=:mId");
    q.append(" and channel=:channel and orderStatus=:status");

    if (searchCriteria != null) {

        if (!StringUtils.isBlank(searchCriteria.getCustomerName())) {
            q.append(" and o.customerName like %:cName%");
        }/*from   w  w  w. j a v a  2s.c o  m*/

        if (searchCriteria.getOrderId() != -1) {
            q.append(" and o.orderId=:oId");
        }

        if (searchCriteria.getEdate() != null || searchCriteria.getSdate() != null) {
            if (searchCriteria.getSdate() != null) {
                q.append(" and o.datePurchased > :sDate");
            } else {
                q.append(" and o.datePurchased > :sDate");
            }
            if (searchCriteria.getEdate() != null) {
                q.append(" and o.datePurchased < :eDate");
            } else {
                q.append(" and o.datePurchased < :eDate");
            }
        }
    }
    q.append(" order by o.orderId desc");

    Query c = super.getSession().createQuery(q.toString());
    c.setInteger("channel", OrderConstants.INVOICE_CHANNEL);
    c.setInteger("status", OrderConstants.STATUSINVOICED);
    c.setInteger("mId", searchCriteria.getMerchantId());

    if (searchCriteria != null) {

        if (!StringUtils.isBlank(searchCriteria.getCustomerName())) {
            criteria.add(Restrictions.like("customerName", "%" + searchCriteria.getCustomerName() + "%"));
            c.setString("cName", "%" + searchCriteria.getCustomerName() + "%");
        }

        if (searchCriteria.getOrderId() != -1) {
            criteria.add(Restrictions.eq("orderId", searchCriteria.getOrderId()));
            c.setLong("oId", searchCriteria.getOrderId());
        }

        if (searchCriteria.getEdate() != null || searchCriteria.getSdate() != null) {
            if (searchCriteria.getSdate() != null) {
                criteria.add(Restrictions.ge("datePurchased", searchCriteria.getSdate()));
                c.setDate("sDate", searchCriteria.getSdate());
            } else {
                criteria.add(Restrictions.ge("datePurchased", DateUtils.addDays(new Date(), -1)));
                c.setDate("sDate", DateUtils.addDays(new Date(), -1));
            }
            if (searchCriteria.getEdate() != null) {
                criteria.add(Restrictions.le("datePurchased", searchCriteria.getEdate()));
                c.setDate("eDate", searchCriteria.getEdate());
            } else {
                criteria.add(Restrictions.ge("datePurchased", DateUtils.addDays(new Date(), +1)));
                c.setDate("eDate", DateUtils.addDays(new Date(), +1));
            }
        }
    }

    criteria.setProjection(Projections.rowCount());
    Integer count = (Integer) criteria.uniqueResult();

    criteria.setProjection(null);

    int max = searchCriteria.getQuantity();

    List list = null;
    if (max != -1 && count > 0) {
        list = c.setMaxResults(searchCriteria.getUpperLimit(count))
                .setFirstResult(searchCriteria.getLowerLimit()).list();
    } else {
        list = c.list();
    }

    SearchOrderResponse response = new SearchOrderResponse();
    response.setCount(count);
    response.setOrders(list);

    return response;

}

From source file:com.salesmanager.core.service.order.impl.dao.OrderDao.java

License:Open Source License

public SearchOrderResponse searchOrder(SearchOrdersCriteria searchCriteria) {

    Criteria criteria = super.getSession().createCriteria(Order.class)
            .add(Restrictions.eq("merchantId", searchCriteria.getMerchantId()))
            .add(Restrictions.eq("channel", OrderConstants.ONLINE_CHANNEL))
            .addOrder(org.hibernate.criterion.Order.desc("orderId"))
            .setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);

    StringBuffer q = new StringBuffer();

    q.append(" select o from Order o where o.merchantId=:mId");
    q.append(" and channel=:channel");

    if (searchCriteria != null) {

        if (!StringUtils.isBlank(searchCriteria.getCustomerName())) {
            q.append(" and o.customerName like :cName");
        }//www.  j  a v  a 2s  . c  o  m

        if (searchCriteria.getOrderId() != -1) {
            q.append(" and o.orderId= :oId");
        }

        if (searchCriteria.getEdate() != null || searchCriteria.getSdate() != null) {
            if (searchCriteria.getSdate() != null) {
                q.append(" and o.datePurchased > :sDate");
            } else {
                q.append(" and o.datePurchased > :sDate");
            }
            if (searchCriteria.getEdate() != null) {
                q.append(" and o.datePurchased < :eDate");
            } else {
                q.append(" and o.datePurchased < :eDate");
            }
        }
    }
    q.append(" order by o.orderId desc");

    Query c = super.getSession().createQuery(q.toString());
    c.setInteger("channel", OrderConstants.ONLINE_CHANNEL);
    c.setInteger("mId", searchCriteria.getMerchantId());

    if (searchCriteria != null) {

        if (!StringUtils.isBlank(searchCriteria.getCustomerName())) {
            criteria.add(Restrictions.like("customerName", "%" + searchCriteria.getCustomerName() + "%"));
            c.setString("cName", "%" + searchCriteria.getCustomerName() + "%");
        }

        if (searchCriteria.getOrderId() != -1) {
            criteria.add(Restrictions.eq("orderId", searchCriteria.getOrderId()));
            c.setLong("oId", searchCriteria.getOrderId());
        }

        if (searchCriteria.getEdate() != null || searchCriteria.getSdate() != null) {
            if (searchCriteria.getSdate() != null) {
                criteria.add(Restrictions.ge("datePurchased", searchCriteria.getSdate()));
                c.setDate("sDate", searchCriteria.getSdate());
            } else {
                criteria.add(Restrictions.ge("datePurchased", DateUtils.addDays(new Date(), -1)));
                c.setDate("sDate", DateUtils.addDays(new Date(), -1));
            }
            if (searchCriteria.getEdate() != null) {
                criteria.add(Restrictions.le("datePurchased", searchCriteria.getEdate()));
                c.setDate("eDate", searchCriteria.getEdate());
            } else {
                criteria.add(Restrictions.ge("datePurchased", DateUtils.addDays(new Date(), +1)));
                c.setDate("eDate", DateUtils.addDays(new Date(), +1));
            }
        }
    }

    criteria.setProjection(Projections.rowCount());
    Integer count = (Integer) criteria.uniqueResult();

    criteria.setProjection(null);

    int max = searchCriteria.getQuantity();

    List list = null;
    if (max != -1 && count > 0) {
        c.setMaxResults(searchCriteria.getUpperLimit(count));
        c.setFirstResult(searchCriteria.getLowerLimit());
        list = c.list();
    } else {
        list = c.list();
    }

    SearchOrderResponse response = new SearchOrderResponse();
    response.setCount(count);
    response.setOrders(list);

    return response;

}

From source file:com.sapienter.jbilling.server.payment.db.PaymentAuthorizationDAS.java

License:Open Source License

public Collection<PaymentAuthorizationDTO> findByDateAndCode(String approvalCode, Date createDatetime,
        String dateTimeComparator, Integer entityId) {
    /*TODO should add some form of restriction maybe for entities and/or users?
     * //from ww w.  j  a v  a  2s. com
     */
    Criteria criteria = getSession().createCriteria(PaymentAuthorizationDTO.class);
    criteria.add(Restrictions.eq("approvalCode", approvalCode));
    if (dateTimeComparator.equalsIgnoreCase(">=")) {
        criteria.add(Restrictions.ge("createDate", createDatetime));
    } else if (dateTimeComparator.equalsIgnoreCase("<=")) {
        criteria.add(Restrictions.le("createDate", createDatetime));
    }

    return criteria.list();
}

From source file:com.sccl.attech.modules.sys.utils.CriteriaUtil.java

License:Open Source License

public static void createDateCond(DetachedCriteria dc, DataEntity<?> entity) {
    if (null == entity)
        return;/* w ww.ja v a  2s .  c o  m*/
    if (null != entity.getUpdateDateStart())
        dc.add(Restrictions.ge("updateDate", entity.getUpdateDateStart()));
    if (null != entity.getUpdateDateEnd())
        dc.add(Restrictions.le("updateDate", entity.getUpdateDateEnd()));
}

From source file:com.scopix.periscope.extractionplanmanagement.dao.ExtractionPlanCustomizingDAOImpl.java

License:Open Source License

@Override
public List<EvidenceRequest> getEvidenceRequestList(EvidenceRequest evidenceRequest, Date init, Date end) {
    List<EvidenceRequest> list = null;
    Session session = this.getSession();
    try {//from w ww  . j  a  v a  2 s .co m
        Criteria criteria = session.createCriteria(EvidenceRequest.class);
        criteria.addOrder(Order.asc("id"));
        if (evidenceRequest != null) {
            if (init != null && end != null) {
                criteria.add(Restrictions.ge("evidenceTime", init));
                criteria.add(Restrictions.le("evidenceTime", end));
            } else if (init != null) {
                criteria.add(Restrictions.ge("evidenceTime", init));
            } else if (end != null) {
                criteria.add(Restrictions.le("evidenceTime", end));
            } else if (evidenceRequest.getEvidenceTime() != null) {
                criteria.add(Restrictions.eq("evidenceTime", evidenceRequest.getEvidenceTime()));
            }
            if (evidenceRequest.getType() != null) {
                criteria.add(Restrictions.eq("type", evidenceRequest.getType()));
            }
            if (evidenceRequest.getEvidenceProvider() != null
                    && evidenceRequest.getEvidenceProvider().getId() != null
                    && evidenceRequest.getEvidenceProvider().getId() > 0) {
                criteria.add(
                        Restrictions.eq("evidenceProvider.id", evidenceRequest.getEvidenceProvider().getId()));
            }

            ExtractionPlanMetric epm = evidenceRequest.getMetric().getExtractionPlanMetric();
            if (evidenceRequest.getMetric() != null && epm != null && epm.getExtractionPlanCustomizing() != null
                    && epm.getExtractionPlanCustomizing().isActive() != null) {
                criteria.createCriteria("metric").createCriteria("extractionPlanCustomizing")
                        .add(Restrictions.eq("active", epm.getExtractionPlanCustomizing().isActive()));
            }
        }
        list = criteria.list();
    } catch (HibernateException e) {
        log.error(e, e);
    } finally {
        this.releaseSession(session);
    }
    return list;
}

From source file:com.scopix.periscope.extractionplanmanagement.dao.ExtractionPlanCustomizingDAOImpl.java

License:Open Source License

@Override
public List<EvidenceRequest> getFreeEvidenceRequestList(EvidenceRequest evidenceRequest, Date init, Date end) {
    List<EvidenceRequest> list = null;
    Session session = this.getSession();
    try {//www  .  j a v  a 2s  .c  om
        Criteria criteria = session.createCriteria(EvidenceRequest.class);
        criteria.addOrder(Order.asc("id"));
        if (evidenceRequest != null) {
            if (init != null && end != null) {
                criteria.add(Restrictions.ge("evidenceTime", init));
                criteria.add(Restrictions.le("evidenceTime", end));
            } else if (init != null) {
                criteria.add(Restrictions.ge("evidenceTime", init));
            } else if (end != null) {
                criteria.add(Restrictions.le("evidenceTime", end));
            } else if (evidenceRequest.getEvidenceTime() != null) {
                criteria.add(Restrictions.eq("evidenceTime", evidenceRequest.getEvidenceTime()));
            }
            if (evidenceRequest.getType() != null) {
                criteria.add(Restrictions.eq("type", evidenceRequest.getType()));
            }
            if (evidenceRequest.getEvidenceProvider() != null
                    && evidenceRequest.getEvidenceProvider().getId() != null
                    && evidenceRequest.getEvidenceProvider().getId() > 0) {
                criteria.add(
                        Restrictions.eq("evidenceProvider.id", evidenceRequest.getEvidenceProvider().getId()));
            }
        }
        criteria.add(Restrictions.isNull("metric.id"));
        list = criteria.list();
    } catch (HibernateException e) {
        log.error(e, e);
    } finally {
        this.releaseSession(session);
    }
    return list;
}

From source file:com.segundo.piso.daos.impl.DAOReportImpl.java

@Override
@Transactional/*from www .  j av  a 2 s.  com*/
public ReporteMovimientosAlumno movementsReport(Filters filters) {
    ReporteMovimientosAlumno reporte = null;
    Criteria criteria = this.sessionFactory.getCurrentSession().createCriteria(Movimiento.class, "movimiento")
            .createAlias("movimiento.idEvento", "evento").setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY)
            .addOrder(Order.desc("fechaInicio"));

    if (filters.getEvento() > 0) {
        criteria.add(Restrictions.eq("idEvento.id", filters.getEvento()));
    } else {
        criteria.add(Restrictions.ge("evento.diasMes", 1));
    }

    if (filters.getFechaInicio() != null) {
        criteria.add(Restrictions.ge("fechaInicio", filters.getFechaInicio()));
    }

    if (filters.getFechaFin() != null) {
        criteria.add(Restrictions.le("fechaInicio", filters.getFechaFin()));
    }

    List<Movimiento> movements = criteria.list();
    if (movements != null && !movements.isEmpty()) {
        for (Movimiento movement : movements) {
            if (movement.getPorcentaje()) {
                double percentage = movement.getDescuento() / 100;
                double discount = movement.getCosto() * percentage;
                movement.setDescuento((int) discount);
            }
        }

        reporte = totalMovements(criteria);
        reporte.setMovimientos(movements);
    }

    return reporte;
}

From source file:com.selfsoft.baseinformation.service.impl.TbCardHisServiceImpl.java

public List<TbCardHis> findByTbCardHis(TbCardHis tbCardHis) {

    DetachedCriteria detachedCriteria = DetachedCriteria.forClass(TbCardHis.class);

    if (null != tbCardHis) {

        if (null != tbCardHis.getCardNo() && !"".equals(tbCardHis.getCardNo())) {

            detachedCriteria.add(Restrictions.like("cardNo", "%" + tbCardHis.getCardNo() + "%"));

        }/* ww  w  .  j  a  v a2 s. com*/

        if (null != tbCardHis.getOperationDateFrom()) {

            detachedCriteria.add(Restrictions.ge("operationDate", tbCardHis.getOperationDateFrom()));

        }

        if (null != tbCardHis.getOperationDateTo()) {

            detachedCriteria.add(
                    Restrictions.le("operationDate", CommonMethod.addDate(tbCardHis.getOperationDateTo(), 1)));

        }

        if (null != tbCardHis.getLicenseCode() && !"".equals(tbCardHis.getLicenseCode())) {

            detachedCriteria.add(Restrictions.like("licenseCode", "%" + tbCardHis.getLicenseCode() + "%"));

        }

        if (null != tbCardHis.getOperationType() && !"".equals(tbCardHis.getOperationType())) {

            detachedCriteria.add(Restrictions.eq("operationType", tbCardHis.getOperationType()));

        }

        if (null != tbCardHis.getBalanceCode() && !"".equals(tbCardHis.getBalanceCode())) {
            detachedCriteria.add(Restrictions.like("balanceCode", "%" + tbCardHis.getBalanceCode() + "%"));
        }

        if (null != tbCardHis.getCustomerCode() && !"".equals(tbCardHis.getCustomerCode())) {

            detachedCriteria.add(Restrictions.eq("customerCode", tbCardHis.getCustomerCode()));

        }

        if (null != tbCardHis.getCustomerName() && !"".equals(tbCardHis.getCustomerName())) {

            detachedCriteria.add(Restrictions.eq("customerName", tbCardHis.getCustomerName()));

        }

    }

    else {

        return null;

    }

    /*List<TbCardHis> list = tbCardHisDao.findByCriteria(detachedCriteria, tbCardHis);
            
    List<TbCardHis> tbCardHisList = null;
            
    if(null != list && list.size() > 0){
               
       tbCardHisList = new ArrayList<TbCardHis>();
               
       for(TbCardHis _tbCardHis : list){
            
    TmUser tmUser = tmUserService.findById(_tbCardHis.getUserId());
            
    _tbCardHis.setTmUser(tmUser);
            
    tbCardHisList.add(_tbCardHis);
            
       }
               
    }*/

    return tbCardHisDao.findByCriteria(detachedCriteria, tbCardHis);
}

From source file:com.selfsoft.baseinformation.service.impl.TbCarInfoServiceImpl.java

public List<TbCarInfo> findByTbCarInfo(TbCarInfo tbCarInfo) {

    DetachedCriteria detachedCriteria = DetachedCriteria.forClass(TbCarInfo.class);

    if (null != tbCarInfo) {
        if (null != tbCarInfo.getId()) {
            detachedCriteria.add(Restrictions.eq("id", tbCarInfo.getId()));
        }/*from   ww w  .  jav a  2 s  .  c  o  m*/
        if (null != tbCarInfo.getLicenseCode() && !"".equals(tbCarInfo.getLicenseCode())) {
            //?
            detachedCriteria.add(Restrictions.like("licenseCode", "%" + tbCarInfo.getLicenseCode() + "%"));
        }
        if (null != tbCarInfo.getInsureCardCode() && !"".equals(tbCarInfo.getInsureCardCode())) {
            detachedCriteria
                    .add(Restrictions.like("insureCardCode", "%" + tbCarInfo.getInsureCardCode() + "%"));
        }
        if (null != tbCarInfo.getTmCarModelType()) {

            detachedCriteria.createAlias("tmCarModelType", "tmCarModelType");

            if (null != tbCarInfo.getTmCarModelType().getId()) {
                detachedCriteria
                        .add(Restrictions.eq("tmCarModelType.id", tbCarInfo.getTmCarModelType().getId()));
            }
        }
        if (null != tbCarInfo.getTbCustomer()) {

            detachedCriteria.createAlias("tbCustomer", "tbCustomer");

            if (null != tbCarInfo.getTbCustomer().getId()) {
                detachedCriteria.add(Restrictions.eq("tbCustomer.id", tbCarInfo.getTbCustomer().getId()));
            }
            if (null != tbCarInfo.getTbCustomer().getCustomerCode()) {
                detachedCriteria.add(Restrictions.like("tbCustomer.customerCode",
                        "%" + tbCarInfo.getTbCustomer().getCustomerCode() + "%"));
            }
            if (null != tbCarInfo.getTbCustomer().getCustomerName()) {
                detachedCriteria.add(Restrictions.like("tbCustomer.customerName",
                        "%" + tbCarInfo.getTbCustomer().getCustomerName() + "%"));
            }
            if (null != tbCarInfo.getTbCustomer().getTelephone()) {
                detachedCriteria.add(Restrictions.like("tbCustomer.telephone",
                        "%" + tbCarInfo.getTbCustomer().getTelephone() + "%"));
            }
        }

        if (StringUtils.isNotBlank(tbCarInfo.getBeginLicenseDate())) {
            detachedCriteria.add(Restrictions.ge("licenseDate", Date.valueOf(tbCarInfo.getBeginLicenseDate())));
        }

        if (StringUtils.isNotBlank(tbCarInfo.getEndLicenseDate())) {
            detachedCriteria.add(Restrictions.le("licenseDate", Date.valueOf(tbCarInfo.getEndLicenseDate())));
        }

        if (StringUtils.isNotBlank(tbCarInfo.getBeginPurchaseDate())) {
            detachedCriteria
                    .add(Restrictions.ge("purchaseDate", Date.valueOf(tbCarInfo.getBeginPurchaseDate())));
        }

        if (StringUtils.isNotBlank(tbCarInfo.getEndPurchaseDate())) {
            detachedCriteria.add(Restrictions.le("purchaseDate", Date.valueOf(tbCarInfo.getEndPurchaseDate())));
        }
        if (StringUtils.isNotBlank(tbCarInfo.getChassisCode())) {
            detachedCriteria.add(Restrictions.like("chassisCode", "%" + tbCarInfo.getChassisCode() + "%"));
        }

        if (tbCarInfo.getCarProperty() != null) {
            detachedCriteria.add(Restrictions.eq("carProperty", tbCarInfo.getCarProperty()));
        }

        if (StringUtils.isNotBlank(tbCarInfo.getLicenseMonth())) {
            detachedCriteria
                    .add(Restrictions.sqlRestriction("month(LICENSE_DATE)=" + tbCarInfo.getLicenseMonth()));
        }
        if (tbCarInfo.getMaxKilo() != null && tbCarInfo.getMinKilo() != null) {
            detachedCriteria.add(Restrictions.between("kilo", tbCarInfo.getMinKilo(), tbCarInfo.getMaxKilo()));
        }
    }

    return tbCarInfoDao.findByCriteria(detachedCriteria, tbCarInfo);
}