Example usage for org.hibernate.criterion Restrictions ge

Introduction

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

Prototype

public static SimpleExpression ge(String propertyName, Object value) 

Source Link

Document

Apply a "greater than or equal" constraint to the named property

Usage

From source file:com.selfsoft.business.service.impl.TbFixEntrustServiceImpl.java

public List<TbFixEntrust> findInsuranceCarFixEntrust() {

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

    detachedCriteria.add(Restrictions.ge("remindInsuranceDate", CommonMethod.addDate(new Date(),
            0 - tmInsuranceAlertDayService.findAll().get(0).getContinueDay())));

    detachedCriteria.add(Restrictions.le("remindInsuranceDate",
            CommonMethod.addDate(new Date(), (0 + tmInsuranceAlertDayService.findAll().get(0).getAlertDay()))));

    return tbFixEntrustDao.findByCriteria(detachedCriteria, null);
}

---

From source file:com.selfsoft.business.service.impl.TbFixShareServiceImpl.java

public List<TbFixShare> findByEntity(TbFixShare tbFixShare) {
    DetachedCriteria detachedCriteria = DetachedCriteria.forClass(TbFixShare.class);
    if (null != tbFixShare) {
        if (null != tbFixShare.getId()) {
            detachedCriteria.add(Restrictions.eq("id", tbFixShare.getId()));
        }//www. j  a v  a2 s.  c o m
        if (tbFixShare.getTmUser() != null) {
            detachedCriteria.createAlias("tmUser", "tmUser");
            if (StringUtils.isNotBlank(tbFixShare.getTmUser().getUserRealName())) {
                detachedCriteria.add(Restrictions.like("tmUser.userRealName",
                        "%" + tbFixShare.getTmUser().getUserRealName() + "%"));
            }

            if (tbFixShare.getTmUser().getId() != null) {
                detachedCriteria.add(Restrictions.eq("tmUser.id", tbFixShare.getTmUser().getId()));
            }
        }

        if (tbFixShare.getTbFixEntrustContent() != null) {

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

            if (tbFixShare.getTbFixEntrustContent().getTbWorkingInfo() != null) {

                detachedCriteria.createAlias("tbFixEntrustContent.tbWorkingInfo", "tbWorkingInfo");

                if (StringUtils
                        .isNotBlank(tbFixShare.getTbFixEntrustContent().getTbWorkingInfo().getStationCode())) {
                    detachedCriteria.add(Restrictions.like("tbWorkingInfo.stationCode", "%"
                            + tbFixShare.getTbFixEntrustContent().getTbWorkingInfo().getStationCode() + "%"));
                }

                if (StringUtils
                        .isNotBlank(tbFixShare.getTbFixEntrustContent().getTbWorkingInfo().getStationName())) {
                    detachedCriteria.add(Restrictions.like("tbWorkingInfo.stationName", "%"
                            + tbFixShare.getTbFixEntrustContent().getTbWorkingInfo().getStationName() + "%"));
                }

            }

            if (tbFixShare.getTbFixEntrustContent().getTbFixEntrust() != null) {
                detachedCriteria.createAlias("tbFixEntrustContent.tbFixEntrust", "tbFixEntrust");
                detachedCriteria.add(Restrictions.ne("tbFixEntrust.isvalid", 0L));
                if (StringUtils
                        .isNotBlank(tbFixShare.getTbFixEntrustContent().getTbFixEntrust().getEntrustCode())) {
                    detachedCriteria.add(Restrictions.like("tbFixEntrust.entrustCode", "%"
                            + tbFixShare.getTbFixEntrustContent().getTbFixEntrust().getEntrustCode() + "%"));
                }

                if (null != tbFixShare.getTbFixEntrustContent().getTbFixEntrust().getFixDateStart()) {
                    detachedCriteria.add(Restrictions.ge("tbFixEntrust.fixDate",
                            tbFixShare.getTbFixEntrustContent().getTbFixEntrust().getFixDateStart()));
                }
                if (null != tbFixShare.getTbFixEntrustContent().getTbFixEntrust().getFixDateEnd()) {
                    detachedCriteria.add(Restrictions.le("tbFixEntrust.fixDate", CommonMethod.addDate(
                            tbFixShare.getTbFixEntrustContent().getTbFixEntrust().getFixDateEnd(), 1)));
                }

                if (tbFixShare.getTbFixEntrustContent().getTbFixEntrust().getTbCarInfo() != null) {
                    detachedCriteria.createAlias("tbFixEntrustContent.tbFixEntrust.tbCarInfo", "tbCarInfo");

                    if (StringUtils.isNotBlank(tbFixShare.getTbFixEntrustContent().getTbFixEntrust()
                            .getTbCarInfo().getLicenseCode())) {
                        detachedCriteria.add(Restrictions.like("tbCarInfo.licenseCode",
                                "%" + tbFixShare.getTbFixEntrustContent().getTbFixEntrust().getTbCarInfo()
                                        .getLicenseCode() + "%"));
                    }
                }

                /*  */
                if (tbFixShare.getTbFixEntrustContent().getTbFixEntrust().getBalanceDateBegin() != null
                        || tbFixShare.getTbFixEntrustContent().getTbFixEntrust().getBalanceDateEnd() != null) {
                    List entrustIdList = tbBusinessBalanceDao
                            .getTbEntrustByBalanceDate(tbFixShare.getTbFixEntrustContent().getTbFixEntrust());
                    if (entrustIdList != null && entrustIdList.size() == 0) {
                        return null;
                    }
                    detachedCriteria.add(Restrictions.in("tbFixEntrust.id", entrustIdList));
                }
                /*  */
            }
        }
    } else {
        detachedCriteria.createAlias("tbFixEntrustContent", "tbFixEntrustContent");
        detachedCriteria.createAlias("tbFixEntrustContent.tbFixEntrust", "tbFixEntrust");
        detachedCriteria.add(Restrictions.ne("tbFixEntrust.isvalid", 0L));

    }
    detachedCriteria.addOrder(Order.asc("tmUser.id"));
    return tbFixShareDao.findByCriteria(detachedCriteria, tbFixShare);
}

---

From source file:com.selfsoft.business.service.impl.TbReturnVisitServiceImpl.java

public List<TbReturnVisit> findByTbReturnVisit(TbReturnVisit tbReturnVisit) {

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

    if (null != tbReturnVisit) {

        if (null != tbReturnVisit.getTbCarInfo()) {

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

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

                detachedCriteria.add(Restrictions.like("tbCarInfo.licenseCode",
                        "%" + tbReturnVisit.getTbCarInfo().getLicenseCode() + "%"));

            }//w ww  .j a  v a2 s . c o  m
        }

        if (null != tbReturnVisit.getVisitDateFrom()) {

            detachedCriteria.add(Restrictions.ge("visitDate", tbReturnVisit.getVisitDateFrom()));

        }

        if (null != tbReturnVisit.getVisitDateTo()) {

            detachedCriteria
                    .add(Restrictions.le("visitDate", CommonMethod.addDate(tbReturnVisit.getVisitDateTo(), 1)));

        }

        if (null != tbReturnVisit.getReturnType() && !"".equals(tbReturnVisit.getReturnType())) {

            detachedCriteria.add(Restrictions.eq("returnType", tbReturnVisit.getReturnType()));
        }
    }

    return tbReturnVisitDao.findByCriteria(detachedCriteria, tbReturnVisit);
}

---

From source file:com.square.core.dao.implementations.CampagneDaoImplementation.java

License:Open Source License

/**
 * Construit la requete de recherche.//from   ww w .  j  a  va 2  s. c om
 * @param criteres les critres de recherche
 * @param criteria le criteria
 * @return la requete forme
 */
private Criteria requeteRecherche(RemotePagingCriteriasDto<CampagneCriteresRechercheDto> criteres,
        Criteria criteria) {

    final CampagneCriteresRechercheDto campagneCriteresRechercheDto = criteres.getCriterias();

    final Long idCampagne = campagneCriteresRechercheDto.getId();
    if (idCampagne != null) {
        criteria.add(Restrictions.eq("id", idCampagne));
    }

    // Critre sur le code
    if (campagneCriteresRechercheDto.getCode() != null
            && !("".equals(campagneCriteresRechercheDto.getCode()))) {
        criteria.add(Restrictions.ilike("code", campagneCriteresRechercheDto.getCode().toLowerCase() + "%"));
    }

    // Critre sur le libelle
    if (campagneCriteresRechercheDto.getLibelle() != null
            && !("".equals(campagneCriteresRechercheDto.getLibelle()))) {
        String critereLibelleCampagne = campagneCriteresRechercheDto.getLibelle();
        if (critereLibelleCampagne.indexOf("*") > -1) {
            critereLibelleCampagne = critereLibelleCampagne.replaceAll("\\*", "%");
        }
        criteria.add(Restrictions.ilike("libelle", critereLibelleCampagne.toLowerCase() + "%"));
    }

    // Critre sur le statut
    if (campagneCriteresRechercheDto.getListeStatuts() != null
            && !campagneCriteresRechercheDto.getListeStatuts().isEmpty()) {
        criteria.add(Restrictions.in("statut.id", campagneCriteresRechercheDto.getListeStatuts()));
    }

    // Critre sur le type
    if (campagneCriteresRechercheDto.getListeTypes() != null
            && !campagneCriteresRechercheDto.getListeTypes().isEmpty()) {
        criteria.add(Restrictions.in("type.id", campagneCriteresRechercheDto.getListeTypes()));
    }

    // Critres sur la borne infrieur de la date de dbut
    if (campagneCriteresRechercheDto.getDateDebutBorneInf() != null) {
        criteria.add(Restrictions.ge("dateDebut", campagneCriteresRechercheDto.getDateDebutBorneInf()));
    }
    // Critre sur la borne suprieur de la date de dbut
    if (campagneCriteresRechercheDto.getDateDebutBorneSup() != null) {
        criteria.add(Restrictions.le("dateDebut", campagneCriteresRechercheDto.getDateDebutBorneSup()));
    }
    // Criteres sur la borne infrieur de la date de fin
    if (campagneCriteresRechercheDto.getDateFinBorneInf() != null) {
        criteria.add(Restrictions.ge("dateFin", campagneCriteresRechercheDto.getDateFinBorneInf()));
    }
    // Critres sur la borne suprieur de la date de fin
    if (campagneCriteresRechercheDto.getDateFinBorneSup() != null) {
        criteria.add(Restrictions.le("dateFin", campagneCriteresRechercheDto.getDateFinBorneSup()));
    }
    // Critre sur le crateur de la campagne
    if (campagneCriteresRechercheDto.getIdCreateur() != null) {
        criteria.add(Restrictions.eq("ressource.id", campagneCriteresRechercheDto.getIdCreateur()));
    }

    criteria.add(Restrictions.eq("supprime", false));
    return criteria;
}

---

From source file:com.square.tarificateur.noyau.dao.implementations.OpportuniteDaoImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override//from  ww w. ja  v a2  s .  c  o m
public List<Opportunite> rechercherOpportunitesByCritere(CriteresRechercheOpportuniteDto criteres) {
    final Criteria crit = createCriteria(Opportunite.class);
    if (criteres.getListeEids() != null && criteres.getListeEids().size() > 0) {
        crit.add(Restrictions.in("eidOpportunite", criteres.getListeEids()));
    }
    if (criteres.getIdFinalite() != null) {
        crit.add(Restrictions.eq("finalite.id", criteres.getIdFinalite()));
    }
    if (criteres.getDebutDateCloture() != null) {
        crit.add(Restrictions.ge("dateCloture", criteres.getDebutDateCloture()));
    }
    if (criteres.getFinDateCloture() != null) {
        crit.add(Restrictions.lt("dateCloture", criteres.getFinDateCloture()));
    }
    if (criteres.getListeEidsNaturePersonneExclure() != null
            && criteres.getListeEidsNaturePersonneExclure().size() > 0) {
        crit.add(Restrictions.or(Restrictions.isNull("eidNaturePersonne"), Restrictions
                .not(Restrictions.in("eidNaturePersonne", criteres.getListeEidsNaturePersonneExclure()))));
    }
    return (List<Opportunite>) crit.list();
}

---

From source file:com.sunesoft.ancon.core.saleContract.application.SaleContractServiceImpl.java

public PagedResult<SaleContractDto> findPagesBySaleContract_echarts(SaleContractCriteria contractCriteria) {
    Criteria criteria = dbSupport.getSession().createCriteria(SaleContract.class);
    criteria.add(Restrictions.eq("isActive", true));

    if (contractCriteria.getBeginTime() != null)
        criteria.add(Restrictions.ge("contractBeginTime", contractCriteria.getBeginTime()));
    if (contractCriteria.getEndTime() != null)
        criteria.add(Restrictions.le("contractBeginTime", contractCriteria.getEndTime()));
    if (!StringUtils.isNullOrWhiteSpace(contractCriteria.getBranchCompany()))
        criteria.add(Restrictions.eq("branchCompany", contractCriteria.getBranchCompany()));
    if (!StringUtils.isNullOrWhiteSpace(contractCriteria.getJiaFangName()))
        criteria.add(Restrictions.eq("jiaFangName", contractCriteria.getJiaFangName()));
    if (!StringUtils.isNullOrWhiteSpace(contractCriteria.getContractType()))
        criteria.add(Restrictions.eq("contractType", contractCriteria.getContractType()));
    if (!StringUtils.isNullOrWhiteSpace(contractCriteria.getProjectMajor()))
        criteria.add(Restrictions.eq("projectMajor", contractCriteria.getProjectMajor()));
    if (!StringUtils.isNullOrWhiteSpace(contractCriteria.getContractStatus()))
        criteria.add(Restrictions.eq("contractStatus", contractCriteria.getContractStatus()));

    //?//w  w  w  .  j a  v a2 s.  c om
    int totalCount = ((Long) criteria.setProjection(Projections.rowCount()).uniqueResult()).intValue();
    criteria.setProjection(null);

    criteria.addOrder(Order.asc("contractBeginTime"));

    criteria.setFirstResult((contractCriteria.getPageNumber() - 1) * contractCriteria.getPageSize())
            .setMaxResults(contractCriteria.getPageSize());
    List<SaleContract> saleContracts = criteria.list();
    List<SaleContractDto> list = new ArrayList<>();
    for (SaleContract sale : saleContracts) {
        SaleContractDto dto = DtoFactory.convert(sale, new SaleContractDto());
        list.add(dto);
    }
    return new PagedResult<SaleContractDto>(list, contractCriteria.getPageNumber(),
            contractCriteria.getPageSize(), totalCount);
}

---

From source file:com.telefonica.euro_iaas.paasmanager.dao.impl.TaskDaoJpaImpl.java

License:Apache License

/**
 * {@inheritDoc}/*w w  w  .j a  v  a  2  s  . c om*/
 */
@SuppressWarnings("unchecked")
public List<Task> findByCriteria(TaskSearchCriteria criteria) {
    Session session = (Session) getEntityManager().getDelegate();
    Criteria baseCriteria = session.createCriteria(Task.class);

    if (!StringUtils.isEmpty(criteria.getVdc())) {
        baseCriteria.add(Restrictions.eq("vdc", criteria.getVdc()));
    }

    if (!StringUtils.isEmpty(criteria.getTier())) {
        baseCriteria.add(Restrictions.eq("tier", criteria.getTier()));
    }

    if (!StringUtils.isEmpty(criteria.getEnvironment())) {
        baseCriteria.add(Restrictions.eq("environment", criteria.getEnvironment()));
    }

    if (criteria.getStates() != null && !criteria.getStates().isEmpty()) {
        Criterion statusCr = null;
        for (TaskStates states : criteria.getStates()) {
            statusCr = addStatus(statusCr, states);
        }
        baseCriteria.add(statusCr);
    }
    if (criteria.getFromDate() != null) {
        baseCriteria.add(Restrictions.ge("startTime", criteria.getFromDate()));
    }
    if (criteria.getToDate() != null) {
        baseCriteria.add(Restrictions.le("startTime", criteria.getToDate()));
    }
    if (!StringUtils.isEmpty(criteria.getResource())) {
        baseCriteria.add(Restrictions.eq("result.href", criteria.getResource()));
    }
    if (!StringUtils.isEmpty(criteria.getOwner())) {
        baseCriteria.add(Restrictions.eq("owner.href", criteria.getOwner()));
    }
    return setOptionalPagination(criteria, baseCriteria).list();
}

---

From source file:com.telefonica.euro_iaas.sdc.dao.impl.TaskDaoJpaImpl.java

License:Apache License

/**
 * {@inheritDoc}/* w ww.  j  a v  a 2  s. c o m*/
 */
@SuppressWarnings("unchecked")
@Override
public List<Task> findByCriteria(TaskSearchCriteria criteria) {
    Session session = (Session) getEntityManager().getDelegate();
    Criteria baseCriteria = session.createCriteria(Task.class);

    if (!StringUtils.isEmpty(criteria.getVdc())) {
        baseCriteria.add(Restrictions.eq("vdc", criteria.getVdc()));
    }

    if (criteria.getStates() != null && !criteria.getStates().isEmpty()) {
        Criterion statusCr = null;
        for (TaskStates states : criteria.getStates()) {
            statusCr = addStatus(statusCr, states);
        }
        baseCriteria.add(statusCr);
    }
    if (criteria.getFromDate() != null) {
        baseCriteria.add(Restrictions.ge("startTime", criteria.getFromDate()));
    }
    if (criteria.getToDate() != null) {
        baseCriteria.add(Restrictions.le("startTime", criteria.getToDate()));
    }
    if (!StringUtils.isEmpty(criteria.getResource())) {
        baseCriteria.add(Restrictions.eq("result.href", criteria.getResource()));
    }
    if (!StringUtils.isEmpty(criteria.getOwner())) {
        baseCriteria.add(Restrictions.eq("owner.href", criteria.getOwner()));
    }
    return setOptionalPagination(criteria, baseCriteria).list();
}

---

From source file:com.thinkmore.framework.orm.hibernate.HibernateDao.java

License:Apache License

/**
 * ??Criterion,./*from ww w  . ja  v a  2  s . c  o  m*/
 */
protected Criterion buildPropertyFilterCriterion(final String propertyName, final Object propertyValue,
        final MatchType matchType) {
    Assert.hasText(propertyName, "propertyName?");
    Criterion criterion = null;
    try {
        // ?MatchTypecriterion
        if (MatchType.EQ.equals(matchType)) {
            criterion = Restrictions.eq(propertyName, propertyValue);
        } else if (MatchType.LIKE.equals(matchType)) {
            criterion = Restrictions.like(propertyName, (String) propertyValue, MatchMode.ANYWHERE);
        } else if (MatchType.LE.equals(matchType)) {
            criterion = Restrictions.le(propertyName, propertyValue);
        } else if (MatchType.LT.equals(matchType)) {
            criterion = Restrictions.lt(propertyName, propertyValue);
        } else if (MatchType.GE.equals(matchType)) {
            criterion = Restrictions.ge(propertyName, propertyValue);
        } else if (MatchType.GT.equals(matchType)) {
            criterion = Restrictions.gt(propertyName, propertyValue);
        }
    } catch (Exception e) {
        throw ReflectionUtil.convertReflectionExceptionToUnchecked(e);
    }
    return criterion;
}

---

From source file:com.tysanclan.site.projectewok.entities.dao.hibernate.ChancellorElectionDAOImpl.java

License:Open Source License

@Override
protected Criteria createCriteria(SearchFilter<ChancellorElection> filter) {
    Criteria criteria = getSession().createCriteria(ChancellorElection.class);

    if (filter instanceof ChancellorElectionFilter) {
        ChancellorElectionFilter f = (ChancellorElectionFilter) filter;

        if (f.getStartAfter() != null) {
            criteria.add(Restrictions.ge("start", f.getStartAfter()));
        }// w  w  w .  j  av  a  2s  .co  m
        if (f.getStartBefore() != null) {
            criteria.add(Restrictions.le("start", f.getStartBefore()));
        }
        if (f.getWinner() != null) {
            criteria.add(Restrictions.eq("winner", f.getWinner()));
        } else if (f.isNoWinner()) {
            criteria.add(Restrictions.isNull("winner"));
        }
    }

    return 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
• 50
• »