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, String value, MatchMode matchMode)

Source Link

Document

A case-insensitive "like" (similar to Postgres ilike operator) using the provided match mode

Usage

From source file:br.com.hslife.orcamento.repository.DocumentoRepository.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Documento> findByNomeAndUsuario(String nome, Usuario usuario) {
    Criteria criteria = getSession().createCriteria(Documento.class, "documento")
            .createAlias("documento.categoriaDocumento", "categoria", JoinType.INNER_JOIN);
    criteria.add(Restrictions.ilike("documento.nome", nome, MatchMode.ANYWHERE));
    criteria.add(Restrictions.eq("categoria.usuario.id", usuario.getId()));
    return criteria.addOrder(Order.asc("documento.nome")).list();
}

From source file:br.com.hslife.orcamento.repository.FavorecidoRepository.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Favorecido> findByNomeAndUsuario(String nome, Usuario usuario) {
    Criteria criteria = getSession().createCriteria(Favorecido.class);
    criteria.add(Restrictions.ilike("nome", nome, MatchMode.ANYWHERE));
    criteria.add(Restrictions.eq("usuario.id", usuario.getId()));
    return criteria.addOrder(Order.asc("nome")).list();
}

From source file:br.com.hslife.orcamento.repository.MeioPagamentoRepository.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<MeioPagamento> findByDescricaoAndUsuario(String descricao, Usuario usuario) {
    Criteria criteria = getSession().createCriteria(MeioPagamento.class);
    criteria.add(Restrictions.ilike("descricao", descricao, MatchMode.ANYWHERE));
    criteria.add(Restrictions.eq("usuario.id", usuario.getId()));
    return criteria.addOrder(Order.asc("descricao")).list();
}

From source file:br.com.hslife.orcamento.repository.MoedaRepository.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Moeda> findByNomeAndUsuario(String nome, Usuario usuario) {
    Criteria criteria = getSession().createCriteria(Moeda.class);
    criteria.add(Restrictions.ilike("nome", nome, MatchMode.ANYWHERE));
    criteria.add(Restrictions.eq("usuario.id", usuario.getId()));
    return criteria.list();
}

From source file:br.com.hslife.orcamento.repository.UnidadeMedidaRepository.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<UnidadeMedida> findByDescricaoAndUsuario(String descricao, Usuario usuario) {
    Criteria criteria = getSession().createCriteria(UnidadeMedida.class);
    criteria.add(Restrictions.ilike("descricao", descricao, MatchMode.ANYWHERE));
    criteria.add(Restrictions.eq("usuario.id", usuario.getId()));
    return criteria.addOrder(Order.asc("descricao")).list();
}

From source file:br.com.hslife.orcamento.repository.UsuarioRepository.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Usuario> findAllByLogin(String login) {
    Criteria criteria = getSession().createCriteria(Usuario.class);
    criteria.add(Restrictions.ilike("login", login, MatchMode.ANYWHERE));
    return criteria.addOrder(Order.asc("nome")).list();
}

From source file:br.com.itw.qopsearch.api.persistence.core.FeatureRepositoryImpl.java

License:Apache License

@Override
public Page<Feature> searchText(String text, Pageable pageable) {
    if (pageable == null) {
        pageable = PageableHelper.deafultPageable();
    }/*from   ww w.jav a2s  .  c  om*/
    Session session = (Session) entityManager.getDelegate();
    Criteria criteria = session.createCriteria(Feature.class);
    criteria.add(Restrictions.disjunction().add(Restrictions.ilike("name", text, MatchMode.ANYWHERE)));
    return (Page<Feature>) PageableHelper.getPage(criteria, pageable);
}

From source file:br.com.itw.qopsearch.api.persistence.core.ProductRepositoryImpl.java

License:Apache License

@Override
public Page<Product> searchText(String text, Pageable pageable) {
    if (pageable == null) {
        pageable = PageableHelper.deafultPageable();
    }/*from w  ww.  java 2  s . co  m*/
    Session session = (Session) entityManager.getDelegate();
    Criteria criteria = session.createCriteria(Product.class);
    criteria.add(Restrictions.disjunction().add(Restrictions.ilike("description", text, MatchMode.ANYWHERE))
            .add(Restrictions.ilike("image", text, MatchMode.ANYWHERE)));
    return (Page<Product>) PageableHelper.getPage(criteria, pageable);
}

From source file:br.com.moises.suport.ClienteSuport.java

public List<Cliente> clientePorNome(String valor) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Cliente.class)
            .add(Restrictions.or(Restrictions.ilike("nome", valor, MatchMode.START),
                    Restrictions.ilike("documento", valor, MatchMode.START)));

    return Dao().getEntitiesByDetachetCriteria(criteria);
}

From source file:br.com.moises.suport.MotoristaSuport.java

public List<Motorista> veiculosPorPlaca(String valor) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Motorista.class)
            .add(Restrictions.ilike("nome", valor, MatchMode.START));
    return Dao().getEntitiesByDetachetCriteria(criteria);
}