Example usage for org.hibernate.criterion Restrictions ilike

Introduction

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

Prototype

public static Criterion ilike(String propertyName, Object value) 

Source Link

Document

A case-insensitive "like" (similar to Postgres ilike operator)

Usage

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

License:Open Source License

/**
 * Creates criterion which checks if field is equal (using case-insensitive "like" operator) to given value.
 * /*from  w ww . ja v a 2s  .com*/
 * @param field
 *            field
 * @param value
 *            value
 * @return criterion
 */
public static SearchCriterion ilike(final String field, final String value) {
    if (value == null) {
        return isNull(field);
    }
    return new SearchCriterionImpl(Restrictions.ilike(field, convertWildcards(value)));
}

---

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);//from  w ww. j a  v  a 2 s.  co  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.square.adherent.noyau.dao.implementations.contrat.ContratDaoImpl.java

License:Open Source License

private Criteria createCriteriaByCriteres(CritereRechercheContratDto criteres) {
    final Criteria crit = createCriteria(Contrat.class);
    crit.createAlias("statut", "statut");
    if (criteres != null && criteres.getIdAssure() != null) {
        crit.add(Restrictions.eq("uidAssure", criteres.getIdAssure()));
    }//from   w  w  w .  j a va2 s  .  co m
    if (criteres != null && criteres.getIdSouscripteur() != null) {
        crit.add(Restrictions.eq("uidSouscripteur", criteres.getIdSouscripteur()));
    }
    if (criteres != null && criteres.isIdAssureNull()) {
        crit.add(Restrictions.isNull("uidAssure"));
    }
    if (criteres != null && StringUtils.isNotBlank(criteres.getNumeroContrat())) {
        crit.add(Restrictions.ilike("numeroContrat", criteres.getNumeroContrat() + "%"));
    }
    if (criteres != null && criteres.getHasContratEnCours() != null && criteres.getHasContratEnCours()) {
        crit.add(Restrictions.eq("statut.id", adherentMappingService.getIdStatutContratEnCours()));
    }
    if (criteres != null && criteres.getContratEid() != null
            && StringUtils.isNotBlank(criteres.getContratEid())) {
        crit.add(Restrictions.like("identifiantExterieur", "%" + criteres.getContratEid() + "%"));
    }
    crit.add(Restrictions.eq("isVisible", true));
    return crit;
}

---

From source file:com.square.adherent.noyau.dao.implementations.contrat.ContratDaoImpl.java

License:Open Source License

@Override
@SuppressWarnings("unchecked")
public List<String> getListeContratsCollectifsByCriteres(ContratCollectifCriteresDto criteres) {
    // Cration du critre
    final Criteria crit = createCriteria(Contrat.class);
    // Projection sur la colonne contrat
    crit.setProjection(Projections.groupProperty("numeroContrat"));
    // Critres de recherche
    if (criteres.getUidEntreprise() != null) {
        crit.add(Restrictions.eq("uidSouscripteur", criteres.getUidEntreprise()));
    }//from w w  w  .  j a va  2  s .  c o  m
    crit.add(Restrictions.ilike("identifiantExterieur", "%groupe%"));
    // Tri sur le contrat
    crit.addOrder(Order.asc("numeroContrat"));
    return (ArrayList<String>) crit.list();
}

---

From source file:com.square.adherent.noyau.dao.implementations.contrat.ContratMoyenPaiementDaoImpl.java

License:Open Source License

@Override
@SuppressWarnings("unchecked")
public List<ContratMoyenPaiement> getMoyensPaiementContratByCriteres(
        DimensionAdherentCriteresRechercheDto criteres) {
    final Criteria criteria = createCriteria(ContratMoyenPaiement.class);
    if (criteres != null) {
        if (criteres.getId() != null) {
            criteria.add(Restrictions.eq("id", criteres.getId()));
        }//from   w  ww .  j a va  2 s. c  o  m
        if (criteres.getIdentifiantExterieur() != null) {
            criteria.add(Restrictions.eq("identifiantExterieur", criteres.getIdentifiantExterieur()));
        }
        if (criteres.getLibelle() != null) {
            criteria.add(Restrictions.ilike("libelle", criteres.getLibelle() + "%"));
        }
        if (criteres.getVisible() != null) {
            criteria.add(Restrictions.eq("visible", criteres.getVisible()));
        }
        if (criteres.getMaxResults() != null) {
            criteria.setMaxResults(criteres.getMaxResults());
        }
    }
    criteria.addOrder(Order.asc("ordre")).addOrder(Order.asc("libelle"))
            .addOrder(Order.asc("identifiantExterieur"));
    return (List<ContratMoyenPaiement>) criteria.list();
}

---

From source file:com.square.adherent.noyau.dao.implementations.contrat.GarantieDaoImpl.java

License:Open Source License

@Override
@SuppressWarnings("unchecked")
public List<Garantie> getListeGarantiesContratPersonneMorale(String eidContrat) {
    final int nbCaractere = 13;
    final Criteria crit = createCriteria(Garantie.class);
    crit.createAlias("contrat", "contrat");
    crit.add(Restrictions.isNotNull("uidAssure"));
    crit.add(Restrictions.ilike("contrat.identifiantExterieur", eidContrat.substring(0, nbCaractere) + "%"));
    return crit.list();
}

---

From source file:com.square.adherent.noyau.dao.implementations.prestation.DecompteActeDaoImpl.java

License:Open Source License

@Override
@SuppressWarnings("unchecked")
public List<DecompteActe> rechercherActesDecompteParCriteres(DimensionAdherentCriteresRechercheDto criteres) {
    final Criteria criteria = createCriteria(DecompteActe.class);
    if (criteres != null) {
        if (criteres.getId() != null) {
            criteria.add(Restrictions.eq("id", criteres.getId()));
        }/* ww  w.  j ava  2 s. c om*/
        if (criteres.getIdentifiantExterieur() != null) {
            criteria.add(Restrictions.eq("eid", criteres.getIdentifiantExterieur()));
        }
        if (criteres.getLibelle() != null) {
            criteria.add(Restrictions.ilike("libelle", criteres.getLibelle() + "%"));
        }
        if (criteres.getVisible() != null) {
            criteria.add(Restrictions.eq("visible", criteres.getVisible()));
        }
        if (criteres.getMaxResults() != null) {
            criteria.setMaxResults(criteres.getMaxResults());
        }
    }
    criteria.addOrder(Order.asc("ordre")).addOrder(Order.asc("libelle")).addOrder(Order.asc("eid"));
    return (List<DecompteActe>) criteria.list();
}

---

From source file:com.square.adherent.noyau.dao.implementations.prestation.DecompteOrigineDaoImpl.java

License:Open Source License

@Override
@SuppressWarnings("unchecked")
public List<DecompteOrigine> rechercherOriginesDecompteParCriteres(
        DimensionAdherentCriteresRechercheDto criteres) {
    final Criteria criteria = createCriteria(DecompteOrigine.class);
    if (criteres != null) {
        if (criteres.getId() != null) {
            criteria.add(Restrictions.eq("id", criteres.getId()));
        }//  w  w  w  .j  av  a  2s. c  o m
        if (criteres.getIdentifiantExterieur() != null) {
            criteria.add(Restrictions.eq("eid", criteres.getIdentifiantExterieur()));
        }
        if (criteres.getLibelle() != null) {
            criteria.add(Restrictions.ilike("libelle", criteres.getLibelle() + "%"));
        }
        if (criteres.getVisible() != null) {
            criteria.add(Restrictions.eq("visible", criteres.getVisible()));
        }
        if (criteres.getMaxResults() != null) {
            criteria.setMaxResults(criteres.getMaxResults());
        }
    }
    criteria.addOrder(Order.asc("ordre")).addOrder(Order.asc("libelle")).addOrder(Order.asc("id"));
    return (List<DecompteOrigine>) criteria.list();
}

---

From source file:com.square.adherent.noyau.dao.implementations.prestation.RelevePrestationDaoImpl.java

License:Open Source License

@Override
public RelevePrestationMoyenPaiement getMoyenPaiementByEid(String eid) {
    final Criteria criteria = createCriteria(RelevePrestationMoyenPaiement.class);
    criteria.add(Restrictions.ilike("identifiantExterieur", eid));
    return (RelevePrestationMoyenPaiement) criteria.uniqueResult();
}

---

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

License:Open Source License

@SuppressWarnings("unchecked")
@Override//  w ww .j a  va 2 s  .  com
public List<ActionDuree> rechercherDureeActionParCriteres(DimensionCriteresRechercheDto criteres) {
    final Criteria criteria = createCriteria(ActionDuree.class);

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

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

    // Critre sur la visibilit
    if (criteres.getVisible() != null) {
        criteria.add(Restrictions.eq("visible", criteres.getVisible()));
    }
    // Maxresults
    if (criteres.getMaxResults() != null) {
        criteria.setFirstResult(0);
        criteria.setMaxResults(criteres.getMaxResults());
    }

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

    return criteria.list();
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• »