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.hrstatus.dao.impl.ServersDAO.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Servidores> getServersNOK() {

    log.fine("[ " + userInfo.getLoggedUsername() + " ] getServersNOK()");

    try {// w  ww.  j  a  v a2  s  . c  o m
        final Criteria criteria = session().createCriteria(Servidores.class);
        criteria.add(Restrictions.or(Restrictions.eq("trClass", "error"), Restrictions.eq("status", "NOK")));
        criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
        return criteria.list();

    } catch (Exception e) {
        log.severe("[ " + userInfo.getLoggedUsername() + " ] Error: " + e);
        return new ArrayList<Servidores>();
    }
}

From source file:br.com.hrstatus.dao.impl.ServersDAO.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Servidores> getServersNOKVerActive() {

    log.fine("[ " + userInfo.getLoggedUsername() + " ] getServersNOKVerActive()");

    try {//from  w w  w.  j ava2 s. c  o  m
        final Criteria criteria = session().createCriteria(Servidores.class);
        criteria.add(Restrictions.or(Restrictions.eq("trClass", "Error"), Restrictions.eq("status", "NOK")));
        criteria.add(Restrictions.eq("verify", "SIM"));
        criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
        return criteria.list();

    } catch (Exception e) {
        log.severe("[ " + userInfo.getLoggedUsername() + " ] Error: " + e);
        return new ArrayList<Servidores>();
    }
}

From source file:br.com.hrstatus.dao.impl.ServersDAO.java

License:Open Source License

public int countServersNOK() {

    log.fine("Invoking countServersNOK()");

    try {//from w  w w  .j  a  v a2s  .c o  m
        final Criteria criteria = session().createCriteria(Servidores.class);
        criteria.add(Restrictions.or(Restrictions.eq("trClass", "Error"), Restrictions.eq("status", "NOK")));
        criteria.setProjection(Projections.rowCount());
        final int count = ((Long) criteria.uniqueResult()).intValue();
        return count;

    } catch (Exception e) {
        log.severe("[ " + userInfo.getLoggedUsername() + " ] Error: " + e);
        return 0;
    }
}

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.EmbarqueSuport.java

public List<Embarque> getEmbarquesEmAberto() {
    DetachedCriteria criteria = DetachedCriteria.forClass(Embarque.class)
            .add(Restrictions.or(Restrictions.eq("status", StatusEmbarque.CARREGANDO),
                    Restrictions.eq("status", StatusEmbarque.VAZIO)));
    return Dao().getEntitiesByDetachetCriteria(criteria);
}

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

public List<Motorista> getPessoasByPlaca(String valor) {
    System.out.print(valor + " ->suport");
    DetachedCriteria criteria = DetachedCriteria.forClass(Motorista.class)
            .add(Restrictions.or(Restrictions.ilike("nome", valor, MatchMode.START),
                    Restrictions.ilike("placa", valor, MatchMode.START)));
    return Dao().getEntitiesByDetachetCriteria(criteria);
}

From source file:br.com.Monopoly.control.dao.AmigoDAO.java

public List<Amigo> buscarAmizades(Usuario user) {
    entitys = criteria/* w  w  w.ja va 2  s. c o m*/
            .add(Restrictions.or(Restrictions.eq("id.remetente", user), Restrictions.eq("id.convidado", user)))
            .list();
    closeSession();
    return entitys;
}

From source file:br.com.Monopoly.control.dao.AmigoDAO.java

public List<Amigo> buscarAmigosAceitos(Usuario user) {
    entitys = criteria.add(Restrictions.and(
            Restrictions.or(Restrictions.eq("id.remetente", user), Restrictions.eq("id.convidado", user)),
            Restrictions.eq("aceito", true), Restrictions.eq("del", false))).list();
    closeSession();//from ww w.  j  a  v a2s  .  com
    return entitys;
}

From source file:br.com.Monopoly.control.dao.AmigoDAO.java

public List<Amigo> buscarAmigosPendentes(Usuario user) {
    entitys = criteria.add(Restrictions.and(
            Restrictions.or(Restrictions.eq("id.remetente", user), Restrictions.eq("id.convidado", user)),
            Restrictions.eq("aceito", false), Restrictions.eq("del", false))).list();
    closeSession();//from   ww  w . jav  a  2 s  .  co  m
    return entitys;
}

From source file:br.com.Monopoly.control.dao.AmigoDAO.java

public List<Amigo> buscarAmizadesRecusadas(Usuario user) {
    entitys = criteria.add(Restrictions.and(
            Restrictions.or(Restrictions.eq("id.remetente", user), Restrictions.eq("id.convidado", user)),
            Restrictions.eq("aceito", false), Restrictions.eq("del", true))).list();
    closeSession();/*from w  w w .  j  a  v  a 2 s .c om*/
    return entitys;
}