Example usage for org.hibernate.criterion Restrictions not

Introduction

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

Prototype

public static Criterion not(Criterion expression) 

Source Link

Document

Return the negation of an expression

Usage

From source file:com.qcadoo.model.api.search.SearchRestrictions.java

License:Open Source License

/**
 * Creates criterion which checks if id isn't equal to given value.
 * /*from  ww w  .  jav a 2s .  c  om*/
 * @param value
 *            value
 * @return criterion
 */
public static SearchCriterion idNe(final long value) {
    return new SearchCriterionImpl(Restrictions.not(Restrictions.idEq(value)));
}

---

From source file:com.qcadoo.model.internal.PriorityServiceImpl.java

License:Open Source License

private void setPriorityIfNotPresent(final InternalDataDefinition dataDefinition,
        final FieldDefinition fieldDefinition, final Object databaseEntity, int currentPriority) {
    Criteria criteria = getCriteria(dataDefinition, fieldDefinition, databaseEntity)
            .add(Restrictions.isNull(fieldDefinition.getName()))
            .add(Restrictions.not(Restrictions.idEq(entityService.getId(databaseEntity))));

    List<Object> entitiesToDecrement = criteria.list();

    int index = currentPriority + 1;
    for (Object entity : entitiesToDecrement) {
        Integer priorityInteger = (Integer) entityService.getField(entity, fieldDefinition);
        int priority = priorityInteger != null ? priorityInteger.intValue() : index;

        entityService.setField(entity, fieldDefinition, priority);
        hibernateService.getCurrentSession().update(entity);
        index++;/*from   w  w  w.java2 s . co m*/
    }
}

---

From source file:com.reignite.parser.QueryParser.java

License:Open Source License

private Criterion processField(JSONObject where) throws ParserException {
    String field = JSONObject.getNames(where)[0];
    JSONObject exp;//w  ww  .  jav a  2  s. c o  m
    try {
        exp = where.getJSONObject(field);
    } catch (JSONException e) {
        throw new ParserException("field expressions must be JSON Object: " + field);
    }
    ExpressionType type = ExpressionType.get(JSONObject.getNames(exp)[0]);
    Object value = null;
    // if the field is a join
    if (field.indexOf(".") > -1) {
        String join = field.substring(0, field.indexOf("."));
        query.createJoin(join);
    }
    switch (type) {
    case IN:
    case NOT_IN:
        try {
            value = createArray(exp.getJSONArray(type.getName()));
        } catch (JSONException e) {
            throw new ParserException("in and not in expressions must be arrays: " + exp);
        }
        break;
    default:
        try {
            value = createValue(exp.get(type.getName()));
        } catch (JSONException e) {
            throw new ParserException("expressions must have a value: " + exp);
        }
    }

    switch (type) {
    case GREATER_THAN:
        return Restrictions.gt(field, value);
    case IN:
        return Restrictions.in(field, (Object[]) value);
    case LESS_THAN:
        return Restrictions.lt(field, value);
    case LIKE:
        MatchMode match = MatchMode.EXACT;
        String toMatch = value.toString();
        if (value.toString().startsWith("%")) {
            match = MatchMode.END;
            toMatch = toMatch.substring(1);
        }
        if (value.toString().endsWith("%")) {
            toMatch = toMatch.substring(0, toMatch.length() - 1);
            if (match == MatchMode.END) {
                match = MatchMode.ANYWHERE;
            } else {
                match = MatchMode.START;
            }
        }
        return Restrictions.ilike(field, toMatch, match);
    case NOT_EQUAL:
        if (value == null) {
            return Restrictions.isNotNull(field);
        }
        return Restrictions.ne(field, value);
    case NOT_IN:
        return Restrictions.not(Restrictions.in(field, (Object[]) value));
    case EQUAL:
    default:
        if (value == null) {
            return Restrictions.isNull(field);
        }
        return Restrictions.eq(field, value);
    }

}

---

From source file:com.scopix.periscope.businesswarehouse.transfer.dao.TransferHibernateDAO.java

License:Open Source License

public List<EvidenceProvider> getEvidenceProviderListNotInIds(List<Integer> evidenceProviderIdListBW) {
    List<EvidenceProvider> list = null;

    Session session = this.getSession();
    Criteria criteria = session.createCriteria(EvidenceProvider.class);

    if (evidenceProviderIdListBW != null && evidenceProviderIdListBW.size() > 0) {
        criteria.add(Restrictions.not(Restrictions.in("id", evidenceProviderIdListBW)));
    }/*from  w  ww  .  j a v a 2  s .c o m*/

    list = criteria.list();

    return list;
}

---

From source file:com.silverpeas.mailinglist.service.model.dao.MessageDaoImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
protected Attachment findAlreadyExistingAttachment(final String md5Hash, final long size, final String fileName,
        final String attachmentId) {
    Criteria criteria = getSession().createCriteria(Attachment.class);
    criteria.add(Restrictions.eq("md5Signature", md5Hash));
    criteria.add(Restrictions.eq("size", size));
    criteria.add(Restrictions.eq("fileName", fileName));
    if (attachmentId != null) {
        criteria.add(Restrictions.not(Restrictions.eq("id", attachmentId)));
    }//from   www  . j  a  v  a 2 s.  co m
    List<Attachment> result = criteria.list();
    if (result != null && !result.isEmpty()) {
        return result.iterator().next();
    }
    return null;
}

---

From source file:com.smartitengineering.dao.impl.hibernate.AbstractDAO.java

License:Open Source License

private Criterion getCriterion(String element, QueryParameter queryParamemter) {
    OperatorType operator = getOperator(queryParamemter);
    Object parameter = getValue(queryParamemter);
    switch (operator) {
    case OPERATOR_EQUAL: {
        return Expression.eq(element, parameter);
    }/*from  w ww . ja  v  a  2  s  . c  om*/
    case OPERATOR_LESSER: {
        return Expression.lt(element, parameter);
    }
    case OPERATOR_LESSER_EQUAL: {
        return Expression.le(element, parameter);
    }
    case OPERATOR_GREATER: {
        return Expression.gt(element, parameter);
    }
    case OPERATOR_GREATER_EQUAL: {
        return Expression.ge(element, parameter);
    }
    case OPERATOR_NOT_EQUAL: {
        return Expression.ne(element, parameter);
    }
    case OPERATOR_IS_NULL: {
        return Expression.isNull(element);
    }
    case OPERATOR_IS_NOT_NULL: {
        return Expression.isNotNull(element);
    }
    case OPERATOR_IS_EMPTY: {
        return Expression.isEmpty(element);
    }
    case OPERATOR_IS_NOT_EMPTY: {
        return Expression.isNotEmpty(element);
    }
    case OPERATOR_STRING_LIKE: {
        MatchMode hibernateMatchMode;
        com.smartitengineering.dao.common.queryparam.MatchMode matchMode = getMatchMode(queryParamemter);
        if (matchMode == null) {
            matchMode = com.smartitengineering.dao.common.queryparam.MatchMode.EXACT;
        }
        switch (matchMode) {
        case END:
            hibernateMatchMode = MatchMode.END;
            break;
        case EXACT:
            hibernateMatchMode = MatchMode.EXACT;
            break;
        case START:
            hibernateMatchMode = MatchMode.START;
            break;
        default:
        case ANYWHERE:
            hibernateMatchMode = MatchMode.ANYWHERE;
            break;
        }
        return Expression.like(element, parameter.toString(), hibernateMatchMode);
    }
    case OPERATOR_BETWEEN: {
        parameter = getFirstParameter(queryParamemter);
        Object parameter2 = getSecondParameter(queryParamemter);
        return Expression.between(element, parameter, parameter2);
    }
    case OPERATOR_IS_IN: {
        Collection inCollectin = QueryParameterCastHelper.MULTI_OPERAND_PARAM_HELPER.cast(queryParamemter)
                .getValues();
        return Restrictions.in(element, inCollectin);
    }
    case OPERATOR_IS_NOT_IN: {
        Collection inCollectin = QueryParameterCastHelper.MULTI_OPERAND_PARAM_HELPER.cast(queryParamemter)
                .getValues();
        return Restrictions.not(Restrictions.in(element, inCollectin));
    }
    }
    return null;
}

---

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

License:Open Source License

@SuppressWarnings("unchecked")
@Override/*from   w ww . ja  va 2  s .  c  o  m*/
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.ActionResultatDaoImplementation.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override//from w ww . j  a  v  a 2s .co m
public List<ActionResultat> rechercherResultatActionParCritere(
        DimensionCritereRechercheResultatActionDto criteres) {

    if (criteres.getDimensionCriteres() == null) {
        criteres.setDimensionCriteres(new DimensionCriteresRechercheDto());
    }

    final Criteria criteria = createCriteria(ActionResultat.class);

    // Critre sur l'identifiant
    if (criteres.getDimensionCriteres().getId() != null) {
        criteria.add(Restrictions.eq("id", criteres.getDimensionCriteres().getId()));
    }

    // Critre sur le libell
    if (criteres.getDimensionCriteres().getLibelle() != null
            && !criteres.getDimensionCriteres().getLibelle().equals("")) {
        criteria.add(Restrictions.ilike("libelle",
                criteres.getDimensionCriteres().getLibelle().toLowerCase() + "%"));
    }

    // Critre sur la visibilit
    if (criteres.getDimensionCriteres().getVisible() != null) {
        criteria.add(Restrictions.eq("visible", criteres.getDimensionCriteres().getVisible()));
    }
    // Maxresults
    if (criteres.getDimensionCriteres().getMaxResults() != null) {
        criteria.setFirstResult(0);
        criteria.setMaxResults(criteres.getDimensionCriteres().getMaxResults());
    }
    // Critre sur l'opportunite
    if (criteres.getRecuperationOpportunite() != null && !criteres.getRecuperationOpportunite()) {
        criteria.add(Restrictions.not(Restrictions.eq("id", squareMappingService.getIdResultatOpportunite())));
    }

    criteria.addOrder(Order.asc("ordre"));
    criteria.addOrder(Order.asc("libelle"));

    return criteria.list();
}

---

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

License:Open Source License

@SuppressWarnings("unchecked")
@Override//w  w w.  ja  va 2 s .c o m
public List<RelationType> rechercherRelationTypeParCriteres(DimensionCritereRechercheTypeRelationDto criteres) {

    final Criteria criteria = createCriteria(RelationType.class);

    // Critre sur l'identifiant
    if (criteres.getId() != null) {
        criteria.add(Restrictions.eq("id", criteres.getId()));
    }
    // Critre sur la liste d'identifiants
    if (criteres.getListeIds() != null && criteres.getListeIds().size() > 0) {
        criteria.add(Restrictions.in("id", criteres.getListeIds()));
    }
    // Critre sur la visibilit
    if (criteres.getVisible() != null) {
        criteria.add(Restrictions.eq("visible", criteres.getVisible()));
    }
    // Critre sur le groupement
    if (criteres.getGroupements() != null && criteres.getGroupements().length > 0) {
        criteria.add(Restrictions.in("relationGroupement.id", criteres.getGroupements()));
    }
    // Critre sur le groupement
    if (criteres.getPasDansGroupements() != null && criteres.getPasDansGroupements().length > 0) {
        criteria.add(
                Restrictions.not(Restrictions.in("relationGroupement.id", criteres.getPasDansGroupements())));
    }
    // Critre sur le libelle ou libelle inverse
    if (criteres.getLibelle() != null && !("".equals(criteres.getLibelle()))) {
        criteria.add(Restrictions.or(Restrictions.ilike("libelle", criteres.getLibelle().toLowerCase() + "%"),
                Restrictions.ilike("inverse", criteres.getLibelle().toLowerCase() + "%")));
    }
    // Ordonner les lments
    criteria.addOrder(Order.asc("ordre"));
    criteria.addOrder(Order.asc("libelle"));
    return criteria.list();
}

---

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

License:Open Source License

@SuppressWarnings("unchecked")
@Override/*from  w  w w . j  a va 2 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();
}

---

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