Example usage for org.hibernate.criterion Restrictions 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.square.core.dao.implementations.ActionDaoImplementation.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override/*from w  w  w  .j a  v  a2s.  com*/
public List<Action> rechercherActionsSources(CritereActionSyntheseDto critereActionSyntheseDto) {
    final Criteria criteria = createCriteria(Action.class);

    // Critere de la personne
    criteria.createAlias("actionAffectation", "actionAffectationAlias");
    criteria.add(
            Restrictions.eq("actionAffectationAlias.personne.id", critereActionSyntheseDto.getIdPersonne()));
    // Critere action source : l'action source doit etre null ou rattache  une autre personne
    // (pb des actions sur personnes morales dont la source est une action sur personne physique)
    criteria.createAlias("actionSource", "actionSourceAlias", CriteriaSpecification.LEFT_JOIN);
    criteria.createAlias("actionSourceAlias.actionAffectation", "actionSourceAffectationAlias",
            CriteriaSpecification.LEFT_JOIN);
    final Junction disjunction = Restrictions.disjunction();
    disjunction.add(Restrictions.isNull("actionSource"));
    disjunction.add(Restrictions.not(Restrictions.eqProperty("actionSourceAffectationAlias.personne.id",
            "actionAffectationAlias.personne.id")));
    criteria.add(disjunction);
    // Critere sur les opportunits
    if (critereActionSyntheseDto.getIdOpportunite() != null) {
        criteria.add(Restrictions.eq("actionAffectationAlias.opportunite.id",
                critereActionSyntheseDto.getIdOpportunite()));
    }
    // Critre sur la date d'effet
    if (critereActionSyntheseDto.getFiltrerDateCreation() != null
            && critereActionSyntheseDto.getFiltrerDateCreation()) {
        criteria.add(Restrictions.le("dateCreation", Calendar.getInstance()));
    }
    criteria.add(Restrictions.eq("supprime", false));
    // Ordre
    criteria.addOrder(Order.desc(CHAMP_DATE));

    return criteria.list();
}

---

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

License:Open Source License

@SuppressWarnings("unchecked")
@Override//www .j a v  a2  s .co  m
public List<Action> rechercherActionsLiees(Long idActionSource, Long idOpportunite,
        Boolean filtrerDateCreation) {
    final Criteria criteria = createCriteria(Action.class);
    criteria.add(Restrictions.eq("actionSource.id", idActionSource));
    if (idOpportunite != null) {
        criteria.createAlias("actionAffectation", "actionAffectationAlias");
        criteria.add(Restrictions.eq("actionAffectationAlias.opportunite.id", idOpportunite));
    }
    if (filtrerDateCreation != null && filtrerDateCreation) {
        criteria.add(Restrictions.le("dateCreation", Calendar.getInstance()));
    }
    criteria.add(Restrictions.eq("supprime", false));
    criteria.addOrder(Order.asc(CHAMP_DATE));
    return criteria.list();
}

---

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

License:Open Source License

/**
 * Construit la requete de recherche.// w w w.  j a va  2  s.c o m
 * @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.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()));

    //?//from   w  w  w.  ja  va 2  s  . c  o m
    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.tegik.almac.module.actionHandler.ChangeSize.java

License:Open Source License

public void doExecute(ProcessBundle bundle) throws Exception {
    try {/*from   w  ww  .ja v a 2s  .  c  om*/

        //Imprime todos los parametros
        almac_sizechange header = obdal.get(almac_sizechange.class,
                (String) bundle.getParams().get("Almac_Sizechange_ID"));

        //Query para verificar que ninguno tenga medidas en 0
        OBCriteria<almac_sizechangeline> pQ = obdal.createCriteria(almac_sizechangeline.class);
        pQ.add(Restrictions.eq(almac_sizechangeline.PROPERTY_ALMACSIZECHANGE, header));
        pQ.add(Restrictions.or(Restrictions.isNull(almac_sizechangeline.PROPERTY_ALMACRAZONAJUSTE),
                Restrictions.or(Restrictions.le(almac_sizechangeline.PROPERTY_HEIGHT, BigDecimal.ZERO),
                        Restrictions.le(almac_sizechangeline.PROPERTY_WIDTH, BigDecimal.ZERO))));
        List<almac_sizechangeline> sizeList = pQ.list();

        //Verifica que ningun producto tenga tamano menor a 0
        if (!sizeList.isEmpty()) {
            final OBError msg = new OBError();
            msg.setType("Error");
            msg.setTitle("Error en las piezas.");
            msg.setMessage("Hay piezas con medidas menores o igual a cero o sin una razn de cambio.");
            bundle.setResult(msg);
            return;
        }

        //Verifica que el inventario del producto no este en 0
        //Query para verificar que ninguno tenga medidas en 0
        pQ = obdal.createCriteria(almac_sizechangeline.class);
        pQ.add(Restrictions.eq(almac_sizechangeline.PROPERTY_QTYM2, BigDecimal.ZERO));
        sizeList = pQ.list();

        //Verifica que ningun producto tenga tamano menor a 0
        if (!sizeList.isEmpty()) {
            final OBError msg = new OBError();
            msg.setType("Error");
            msg.setTitle("Error en inventario de productos.");
            msg.setMessage(
                    "Hay piezas con que no tienen inventario y no se les puede hacer el cambio de tamao.");
            bundle.setResult(msg);
            return;
        }

        //Query para traer todas la spiezas
        pQ = obdal.createCriteria(almac_sizechangeline.class);
        pQ.add(Restrictions.eq(almac_sizechangeline.PROPERTY_ALMACSIZECHANGE, header));
        sizeList = pQ.list();

        //Modifica el inventario por medio de Physical Inventory 
        InventoryCount inv = OBProvider.getInstance().get(InventoryCount.class);
        inv.setName(header.getCommercialName() + " " + header.getCreationDate().toString());
        inv.setDescription("Ajuste de Tamao de Piezas  Ajuste:" + header.getCommercialName());
        inv.setMovementDate(new Date());
        inv.setUpdateQuantities(false);
        inv.setOrganization(header.getOrganization());
        inv.setWarehouse(header.getWarehouse());
        obdal.save(inv);
        //Ve4rifica que la lista no este vaca

        //Inicializacion de Variables 
        InventoryCountLine invline = null;
        BigDecimal qtyonhand = BigDecimal.ZERO;
        OBCriteria<StorageDetail> sdqty;
        List<StorageDetail> sdList;

        if (sizeList.isEmpty()) {
            final OBError msg = new OBError();
            msg.setType("Error");
            msg.setTitle("Lista vaca.");
            msg.setMessage("No hay piezas asignadas al documento.");
            bundle.setResult(msg);
            return;
        }

        for (almac_sizechangeline x : sizeList) {
            //Busca la cantidad actual en el sistema y si ya ha cambaido lanza un error.
            sdqty = obdal.createCriteria(StorageDetail.class);
            sdqty.add(Restrictions.eq(StorageDetail.PROPERTY_PRODUCT, x.getProduct()));
            sdqty.add(Restrictions.eq(StorageDetail.PROPERTY_ATTRIBUTESETVALUE, x.getAttributeSetValue()));
            sdList = sdqty.list();

            invline = OBProvider.getInstance().get(InventoryCountLine.class);
            invline.setOrganization(inv.getOrganization());
            invline.setPhysInventory(inv);
            invline.setLineNo(x.getLineNo());
            invline.setProduct(x.getProduct());
            invline.setStorageBin(x.getStorageBin());
            invline.setQuantityCount(((x.getHeight().divide(new BigDecimal("100"), 5, BigDecimal.ROUND_CEILING))
                    .multiply(x.getWidth().divide(new BigDecimal("100"), 5, BigDecimal.ROUND_CEILING))));
            //Pone la nueva cantidad en el sistema
            invline.setBookQuantity(sdList.get(0).getQuantityOnHand());
            invline.setUOM(x.getUOM());
            invline.setAttributeSetValue(x.getAttributeSetValue());
            obdal.save(invline);
        }
        //Se enva todo a la bsae de datos
        obdal.flush();
        obdal.refresh(inv);
        //Crea el proceso de Inventario
        InventoryCountProcess process = new InventoryCountProcess();
        //Se agrega como parametro el Id del Inventario
        Map<String, Object> param = bundle.getParams();
        param.put("M_Inventory_ID", (Object) inv.getId());
        bundle.setParams(param);

        //Se ejecuta el proceso
        process.execute(bundle);

        //Si no hay error continuar normalmente por lo que hay que cambiar de tamao las piezas
        AttributeSetInstance y = null;
        //El documento fue modificado y ya nodeberia poder modificarse nuevamente
        header.setPosted(true);
        header.setPhysInventory(inv);
        //Cambia el tamao de las piezas
        pQ = obdal.createCriteria(almac_sizechangeline.class);
        pQ.add(Restrictions.eq(almac_sizechangeline.PROPERTY_ALMACSIZECHANGE, header));
        sizeList = pQ.list();
        for (almac_sizechangeline x : sizeList) {
            y = x.getAttributeSetValue();
            y.setAlmacAlto(x.getHeight());
            y.setAlmacAncho(x.getWidth());
            y.setAlmacDescriptionmedidas(y.getAlmacAlto().toString() + " X " + y.getAlmacAncho().toString());
            obdal.save(y);
        }
        obdal.save(header);
        obdal.flush();

        // OBError is also used for successful results
        final OBError msg = new OBError();
        msg.setType("Success");
        msg.setTitle("Se ha cambiado de tamao a las piezas.");
        msg.setMessage("Se cre el Documento <" + header.getCommercialName() + " "
                + header.getCreationDate().toString() + "> en Inventaro Fsico");
        bundle.setResult(msg);

    } catch (final Exception e) {
        e.printStackTrace(System.err);
        final OBError msg = new OBError();
        msg.setType("Error");
        msg.setMessage(e.getMessage());
        msg.setTitle("Error occurred");
        bundle.setResult(msg);
    }
}

---

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

License:Apache License

/**
 * {@inheritDoc}//  w w w . ja  v  a 2 s.  co  m
 */
@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}/*from   w  w  w .  j av a 2  s  .  co 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 w  ww  .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.AcceptanceVoteDAOImpl.java

License:Open Source License

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

    if (filter instanceof AcceptanceVoteFilter) {
        AcceptanceVoteFilter cf = (AcceptanceVoteFilter) filter;

        if (cf.getStartBefore() != null) {
            criteria.add(Restrictions.le("start", cf.getStartBefore()));
        }//  w  w  w .  j a  v a2  s.co m
        if (cf.getTrialMember() != null) {
            criteria.add(Restrictions.eq("trialMember", cf.getTrialMember()));
        }
    }

    return criteria;
}

---

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

License:Open Source License

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

    if (filter instanceof AchievementProposalFilter) {
        AchievementProposalFilter cf = (AchievementProposalFilter) filter;

        if (cf.getSuggestor() != null) {
            criteria.add(Restrictions.eq("suggestor", cf.getSuggestor()));
        }//from w  ww.j av a 2 s.  co  m

        if (cf.getStartsBefore() != null) {
            criteria.add(Restrictions.le("startDate", cf.getStartsBefore()));
        }
        if (cf.getTruthsayerReviewed() != null) {
            criteria.add(Restrictions.eq("truthsayerReviewed", cf.getTruthsayerReviewed()));
        }
        if (cf.isVetoUndecided()) {
            criteria.add(Restrictions.isNull("chancellorVeto"));
        }
    }

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