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.imobiliaria.dao.impl.AluguelDao.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override// w  w  w.j ava  2s  .  co  m
public List<Aluguel> listByNomeLocatarioOrContratoOrPeriodoOrAnoBeforeDataAndPago(String nomeLocatario,
        Long idContrato, Integer periodo, Integer ano, Date data, Boolean pago) {
    Criteria criteria = HibernateUtility.getSession().createCriteria(Aluguel.class, "aluguel")
            .createAlias("aluguel.contrato", "contrato").createAlias("contrato.locatario", "locatario");
    if (nomeLocatario != null && !nomeLocatario.trim().isEmpty()) {
        criteria.add(Restrictions.ilike("locatario.nome", nomeLocatario, MatchMode.ANYWHERE));
    }
    if (idContrato != null) {
        criteria.add(Restrictions.eq("contrato.id", idContrato));
    }
    if (periodo != null) {
        criteria.add(Restrictions.eq("aluguel.periodo", periodo));
    }
    if (ano != null) {
        criteria.add(Restrictions.eq("aluguel.ano", ano));
    }
    if (data != null) {
        criteria.add(Restrictions.le("aluguel.vencimento", data));
    }
    if (pago != null) {
        if (pago) {
            criteria.add(Restrictions.isNotNull("aluguel.pagamento"));
        } else {
            criteria.add(Restrictions.isNull("aluguel.pagamento"));
        }
    }
    criteria.addOrder(Order.asc("aluguel.vencimento"));
    return criteria.list();
}

From source file:br.com.hslife.imobiliaria.dao.impl.ContratoDao.java

License:Open Source License

@Override
public List listByExample(Object example) {
    Contrato c = (Contrato) example;//from ww  w .  j  a  v a 2 s .  c  om
    List<Criterion> restricoes = new ArrayList<Criterion>();
    if (c.getNumContrato() != null && !c.getNumContrato().isEmpty()) {
        restricoes.add(Restrictions.ilike("numContrato", c.getNumContrato(), MatchMode.ANYWHERE));
    }
    if (c.getInicioContrato() != null) {
        restricoes.add(Restrictions.ge("inicioContrato", c.getInicioContrato()));
    }
    if (c.getTerminoContrato() != null) {
        restricoes.add(Restrictions.le("terminoContrato", c.getTerminoContrato()));
    }
    if (c.getImovel() != null && c.getImovel().getId() != null && c.getImovel().getId() > 0) {
        restricoes.add(Restrictions.eq("imovel.id", c.getImovel().getId()));
    }
    if (c.getLocatario() != null && c.getLocatario().getId() != null && c.getLocatario().getId() > 0) {
        restricoes.add(Restrictions.eq("locatario.id", c.getLocatario().getId()));
    }
    if (c.getLocatarioPJ() != null && c.getLocatarioPJ().getId() != null && c.getLocatarioPJ().getId() > 0) {
        restricoes.add(Restrictions.eq("locatarioPJ.id", c.getLocatarioPJ().getId()));
    }
    if (c.getFiador() != null && c.getFiador().getId() != null && c.getFiador().getId() > 0) {
        restricoes.add(Restrictions.eq("fiador.id", c.getFiador().getId()));
    }
    if (c.getSituacao() != null && c.getSituacao() > 0) {
        restricoes.add(Restrictions.eq("situacao", c.getSituacao()));
    }
    return super.listByCriteria(Contrato.class, restricoes);
}

From source file:br.com.hslife.imobiliaria.dao.impl.GrupoDao.java

License:Open Source License

public List<Grupo> findByDescricao(String descricao) {
    Criteria criteria = HibernateUtility.getSession().createCriteria(Grupo.class);
    criteria.add(Restrictions.ilike("descricao", descricao, MatchMode.ANYWHERE));
    return criteria.list();
}

From source file:br.com.hslife.imobiliaria.dao.impl.ImovelDao.java

License:Open Source License

@Override
public List listByExample(Object example) {
    Imovel i = (Imovel) example;//from   w ww  . jav a  2  s.  c o  m
    List<Criterion> restricoes = new ArrayList<Criterion>();
    if (i.getNumRegistro() != null && !i.getNumRegistro().isEmpty()) {
        restricoes.add(Restrictions.ilike("numRegistro", i.getNumRegistro(), MatchMode.ANYWHERE));
    }
    if (i.getLocador() != null && i.getLocador().getId() != null && i.getLocador().getId() > 0) {
        restricoes.add(Restrictions.eq("locador.id", i.getLocador().getId()));
    }
    if (i.getValor() != null) {
        restricoes.add(Restrictions.ge("valor", i.getValor()));
    }
    if (i.getTipoImovel() != null && !i.getTipoImovel().isEmpty()) {
        restricoes.add(Restrictions.ilike("tipoImovel", i.getTipoImovel(), MatchMode.ANYWHERE));
    }
    if (i.getSituacaoImovel() != null && !i.getSituacaoImovel().isEmpty()) {
        restricoes.add(Restrictions.ilike("situacaoImovel", i.getSituacaoImovel(), MatchMode.ANYWHERE));
    }
    if (i.getSite() != null) {
        restricoes.add(Restrictions.eq("site", i.getSite()));
    }
    if (i.getAtivo() != null) {
        restricoes.add(Restrictions.eq("ativo", i.getAtivo()));
    }
    return super.listByCriteria(Imovel.class, restricoes);
}

From source file:br.com.hslife.imobiliaria.dao.impl.UsuarioDao.java

License:Open Source License

public List<Usuario> findAllByLogin(String login) {
    Criteria criteria = HibernateUtility.getSession().createCriteria(Usuario.class);
    criteria.add(Restrictions.ilike("login", login, MatchMode.ANYWHERE));
    return criteria.list();
}

From source file:br.com.hslife.imobiliaria.repository.FormaPagamentoRepository.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<FormaPagamento> findByDescricao(String descricao) {
    Criteria criteria = getSession().createCriteria(FormaPagamento.class);
    criteria.add(Restrictions.ilike("descricao", descricao, MatchMode.ANYWHERE));
    return criteria.list();
}

From source file:br.com.hslife.imobiliaria.repository.ModeloContratoRepository.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<ModeloContrato> findByDescricao(String descricao) {
    Criteria criteria = getSession().createCriteria(ModeloContrato.class);
    criteria.add(Restrictions.ilike("descricao", descricao, MatchMode.ANYWHERE));
    return criteria.list();
}

From source file:br.com.hslife.imobiliaria.repository.SeguradoraRepository.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Seguradora> findByDescricao(String descricao) {
    Criteria criteria = getSession().createCriteria(Seguradora.class);
    criteria.add(Restrictions.ilike("descricao", descricao, MatchMode.ANYWHERE));
    return criteria.list();
}

From source file:br.com.hslife.imobiliaria.repository.ServicoManutencaoRepository.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<ServicoManutencao> findByDescricao(String descricao) {
    Criteria criteria = getSession().createCriteria(ServicoManutencao.class);
    criteria.add(Restrictions.ilike("descricao", descricao, MatchMode.ANYWHERE));
    return criteria.list();
}

From source file:br.com.hslife.orcamento.model.CriterioBuscaLancamentoConta.java

License:Open Source License

public void setDescricao(String descricao) {
    this.descricao = descricao;

    // Remove a descrio anteriormente setada
    hibernateCriterions.remove("descricao");

    if (descricao != null && !descricao.isEmpty())
        hibernateCriterions.put("descricao",
                Restrictions.ilike("lancamento.descricao", descricao, MatchMode.ANYWHERE));
}