Example usage for org.hibernate.criterion Restrictions or

Introduction

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

Prototype

public static LogicalExpression or(Criterion lhs, Criterion rhs)

Source Link

Document

Return the disjuction of two expressions

Usage

From source file:br.com.SistemaOCTur.dao.EventoDAO.java

public List<Evento> pegarEntreData(Date inicio, Date fim) {
    entitys = criteria.add(Restrictions.or(Restrictions.between("inicio", inicio, fim),
            Restrictions.between("fim", inicio, fim))).addOrder(Order.asc("salao")).list();
    session.close();//from  ww w . j  a  va  2  s .co  m
    return entitys;
}

From source file:br.com.SistemaOCTur.dao.HospedagemDAO.java

public List<Hospedagem> pegarTodosEntre(Date inicio, Date fim) {
    entitys = criteria.add(Restrictions.or(Restrictions.between("entrada", inicio, fim),
            Restrictions.between("saida", inicio, fim))).list();
    session.close();/* w ww .ja  v a2 s. co  m*/
    return entitys;
}

From source file:br.com.SistemaOCTur.dao.HospedagemDAO.java

public List<Hospedagem> pegarPorTipoApartamento(TipoApartamento tipoApartamento, Date inicio, Date fim) {
    entitys = criteria.add(Restrictions.eq("tipoApartamento", tipoApartamento.getNome())).add(Restrictions
            .or(Restrictions.between("entrada", inicio, fim), Restrictions.between("saida", inicio, fim)))
            .list();/*from   www  . j  a  v a 2s  . c o m*/
    session.close();
    return entitys;
}

From source file:br.com.una.pa.condominio.mobile.dao.impl.PessoaDAOImpl.java

public Pessoa login(Usuario usuario) throws DAOException {
    HashMap<String, String> hash = new HashMap();
    hash.put("usuario", "user");
    hash.put("perfil", "perf");
    List<Object[]> lista = this.consultarPorRestricoes(0, 0, null, hash,
            getProjectList("id", "nome", "perf.id", "perf.descricao", "perf.sindico", "perf.reponsavel",
                    "perf.proprietario"),
            Restrictions.or(Restrictions.eq("user.email", usuario.getUsuario()),
                    Restrictions.eq("user.cpf", usuario.getUsuario())),
            Restrictions.eq("user.senha", usuario.getSenha()));
    //        List<Pessoa> retorno = null;
    if (lista != null) {
        //            retorno = new ArrayList();
        for (Object[] obj : lista) {
            Pessoa uni = new Pessoa(Long.valueOf(obj[0].toString()));
            uni.setNome(obj[1].toString());
            uni.setPerfil(new Perfil(Long.valueOf(obj[2].toString())));
            uni.getPerfil().setDescricao(obj[3].toString());
            uni.getPerfil().setSindico((Boolean) obj[4]);
            uni.getPerfil().setReponsavel((Boolean) obj[5]);
            uni.getPerfil().setProprietario((Boolean) obj[6]);
            //                retorno.add(uni);
            lista = null;/*from  w  w w.  j  a  va2s  .c om*/
            return uni;
        }
    }

    return null;
}

From source file:br.com.una.pa.condominio.mobile.dao.impl.UsuarioDAOImpl.java

public Boolean verificarSeJaExiste(Usuario usuario) throws DAOException {
    List<Usuario> lista = this.findByRestrictions(0, Restrictions
            .or(Restrictions.eq("email", usuario.getEmail()), Restrictions.eq("cpf", usuario.getCpf())));

    return lista != null && lista.size() > 0;
}

From source file:br.com.una.pa.condominio.mobile.dao.impl.UsuarioDAOImpl.java

public Usuario login(Usuario usuario) throws DAOException {
    List<Usuario> lista = this.findByRestrictions(0,
            Restrictions.or(Restrictions.eq("email", usuario.getUsuario()),
                    Restrictions.eq("cpf", usuario.getUsuario())),
            Restrictions.eq("senha", usuario.getSenha()));

    if (lista != null && lista.size() == 1) {
        return lista.get(0);
    }/*from  ww w  . ja  va 2  s  .com*/
    return null;
}

From source file:br.com.una.pa.condominio.mobile.dao.impl.UsuarioDAOImpl.java

public Usuario retornarUsuario(Usuario usuario) throws DAOException {
    List<Usuario> lista = this.findByRestrictions(0, Restrictions
            .or(Restrictions.eq("email", usuario.getUsuario()), Restrictions.eq("cpf", usuario.getUsuario())));

    if (lista != null && lista.size() > 0) {
        return lista.get(0);
    }//w  w w  .java  2 s. co  m
    return null;
}

From source file:br.com.webbudget.domain.model.repository.tools.MessageRepository.java

License:Open Source License

/**
 * /*from   www  .ja  v a 2 s.  c  o m*/
 * @param sender
 * @param filter
 * @param pageRequest
 * @return 
 */
@Override
public Page<Message> listSent(User sender, String filter, PageRequest pageRequest) {

    final Criteria criteria = this.createCriteria();

    if (filter != null) {
        criteria.add(Restrictions.or(Restrictions.ilike("title", "%" + filter + "%"),
                Restrictions.ilike("content", "%" + filter + "%")));
    }

    criteria.add(Restrictions.eq("deleted", false));
    criteria.add(Restrictions.eq("sender", sender));

    // projetamos para pegar o total de paginas possiveis
    criteria.setProjection(Projections.count("id"));

    final Long totalRows = (Long) criteria.uniqueResult();

    // limpamos a projection para que a criteria seja reusada
    criteria.setProjection(null);
    criteria.setResultTransformer(Criteria.ROOT_ENTITY);

    // paginamos
    criteria.setFirstResult(pageRequest.getFirstResult());
    criteria.setMaxResults(pageRequest.getPageSize());

    if (pageRequest.getSortDirection() == PageRequest.SortDirection.ASC) {
        criteria.addOrder(Order.asc(pageRequest.getSortField()));
    } else if (pageRequest.getSortDirection() == PageRequest.SortDirection.DESC) {
        criteria.addOrder(Order.desc(pageRequest.getSortField()));
    }

    // montamos o resultado paginado
    return new Page<>(criteria.list(), totalRows);
}

From source file:br.com.webbudget.domain.model.repository.tools.UserMessageRepository.java

License:Open Source License

/**
 * /*from  ww  w .j a va2s .com*/
 * @param recipient
 * @param filter
 * @param pageRequest
 * @return 
 */
@Override
public Page<UserMessage> listReceived(User recipient, String filter, PageRequest pageRequest) {

    final Criteria criteria = this.createCriteria();

    if (filter != null) {
        criteria.createAlias("message", "ms");
        criteria.add(Restrictions.or(Restrictions.ilike("ms.title", "%" + filter + "%"),
                Restrictions.ilike("ms.content", "%" + filter + "%")));
    }

    criteria.add(Restrictions.eq("deleted", false));
    criteria.add(Restrictions.eq("recipient", recipient));

    // projetamos para pegar o total de paginas possiveis
    criteria.setProjection(Projections.count("id"));

    final Long totalRows = (Long) criteria.uniqueResult();

    // limpamos a projection para que a criteria seja reusada
    criteria.setProjection(null);
    criteria.setResultTransformer(Criteria.ROOT_ENTITY);

    // paginamos
    criteria.setFirstResult(pageRequest.getFirstResult());
    criteria.setMaxResults(pageRequest.getPageSize());

    if (pageRequest.getSortDirection() == PageRequest.SortDirection.ASC) {
        criteria.addOrder(Order.asc(pageRequest.getSortField()));
    } else if (pageRequest.getSortDirection() == PageRequest.SortDirection.DESC) {
        criteria.addOrder(Order.desc(pageRequest.getSortField()));
    }

    // montamos o resultado paginado
    return new Page<>(criteria.list(), totalRows);
}

From source file:br.gov.jfrj.siga.dp.dao.CpDao.java

License:Open Source License

public List<CpConfiguracao> consultarConfiguracoesDesde(Date desde) {
    Criteria c = HibernateUtil.getSessao().createCriteria(CpConfiguracao.class);
    LogicalExpression confsAtivas = Restrictions.and(Restrictions.ge("hisDtIni", desde),
            Restrictions.isNull("hisDtFim"));
    LogicalExpression confsInativas = Restrictions.and(Restrictions.ge("hisDtFim", desde),
            Restrictions.isNotNull("hisDtFim"));
    c.add(Restrictions.or(confsAtivas, confsInativas));
    return c.list();
}