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.Monopoly.control.dao.AmigoDAO.java

public Amigo buscarAmizade(Usuario usuario1, Usuario usuario2) {
    entity = (Amigo) criteria.add(Restrictions.or(
            Restrictions.and(Restrictions.eq("id.remetente", usuario1),
                    Restrictions.eq("id.convidado", usuario2)),
            Restrictions.and(Restrictions.eq("id.remetente", usuario2),
                    Restrictions.eq("id.convidado", usuario1))))
            .uniqueResult();//from   w  w w.j  a  v a 2  s .  co m
    closeSession();
    return entity;
}

---

From source file:br.com.muranodesign.dao.impl.AlunoVariavelDAOImpl.java

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<AlunoVariavel> ListarCicloAnoPeriodoSemGrupo(List<Integer> anos, int idPeriodo, int primeiro,
        int ultimo) {
    Criteria criteria = getSession().createCriteria(AlunoVariavel.class);
    String ano = Integer.toString(Calendar.getInstance().get(Calendar.YEAR));
    AnoLetivo anoLetivo = new AnoLetivoService().listarAnoLetivo(ano).get(0);
    criteria.add(Restrictions.eq("anoLetivo", anoLetivo));
    criteria.add(Restrictions.eq("ativo", 1));
    criteria.createAlias("anoEstudo", "anoEstudo");
    criteria.add(Restrictions.in("anoEstudo.idanoEstudo", anos));
    criteria.createAlias("periodo", "periodo");
    criteria.add(Restrictions.eq("periodo.idperiodo", idPeriodo));
    criteria.createAlias("grupo", "grupo", Criteria.LEFT_JOIN);
    criteria.add(Restrictions.or(Restrictions.isNull("grupo"), Restrictions.eq("grupo.status", "1")));
    criteria.addOrder(Order.asc("anoEstudo.ano"));
    criteria.createAlias("aluno", "aluno");
    criteria.addOrder(Order.asc("aluno.nome"));
    criteria.setFirstResult(primeiro);// w w w. j  a va2s . co m
    criteria.setMaxResults(ultimo);
    List<AlunoVariavel> result = criteria.list();
    return result;
}

---

From source file:br.com.muranodesign.dao.impl.AlunoVariavelDAOImpl.java

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<AlunoVariavel> ListarCicloAnoSemGrupo(List<Integer> anos, int primeiro, int ultimo) {
    Criteria criteria = getSession().createCriteria(AlunoVariavel.class);
    String ano = Integer.toString(Calendar.getInstance().get(Calendar.YEAR));
    AnoLetivo anoLetivo = new AnoLetivoService().listarAnoLetivo(ano).get(0);
    criteria.add(Restrictions.eq("anoLetivo", anoLetivo));
    criteria.add(Restrictions.eq("ativo", 1));
    criteria.createAlias("anoEstudo", "anoEstudo");
    criteria.add(Restrictions.in("anoEstudo.idanoEstudo", anos));
    criteria.createAlias("grupo", "grupo", Criteria.LEFT_JOIN);
    criteria.add(Restrictions.or(Restrictions.isNull("grupo"), Restrictions.eq("grupo.status", "1")));
    criteria.addOrder(Order.asc("anoEstudo.ano"));
    criteria.createAlias("aluno", "aluno");
    criteria.addOrder(Order.asc("aluno.nome"));
    criteria.setFirstResult(primeiro);/*w  w w .  ja  va2s .c om*/
    criteria.setMaxResults(ultimo);
    List<AlunoVariavel> result = criteria.list();
    return result;
}

---

From source file:br.com.muranodesign.dao.impl.AlunoVariavelDAOImpl.java

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<AlunoVariavel> ListarRangePeriodoSemGrupo(int idPeriodo, int primeiro, int ultimo) {
    Criteria criteria = getSession().createCriteria(AlunoVariavel.class);
    String ano = Integer.toString(Calendar.getInstance().get(Calendar.YEAR));
    AnoLetivo anoLetivo = new AnoLetivoService().listarAnoLetivo(ano).get(0);
    criteria.add(Restrictions.eq("anoLetivo", anoLetivo));
    criteria.add(Restrictions.eq("ativo", 1));
    criteria.createAlias("periodo", "periodo");
    criteria.add(Restrictions.eq("periodo.idperiodo", idPeriodo));
    criteria.createAlias("grupo", "grupo", Criteria.LEFT_JOIN);
    criteria.add(Restrictions.or(Restrictions.isNull("grupo"), Restrictions.eq("grupo.status", "1")));
    criteria.createAlias("anoEstudo", "anoEstudo");
    criteria.addOrder(Order.asc("anoEstudo.ano"));
    criteria.createAlias("aluno", "aluno");
    criteria.addOrder(Order.asc("aluno.nome"));
    criteria.setFirstResult(primeiro);/*from   ww w.j  a  v  a2  s . co m*/
    criteria.setMaxResults(ultimo);
    List<AlunoVariavel> result = criteria.list();
    return result;
}

---

From source file:br.com.muranodesign.dao.impl.AlunoVariavelDAOImpl.java

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<AlunoVariavel> ListarNomeSemGrupo(String nome, int idPeriodo, List<Integer> anos) {
    Criteria criteria = getSession().createCriteria(AlunoVariavel.class);

    String ano = Integer.toString(Calendar.getInstance().get(Calendar.YEAR));
    AnoLetivo anoLetivo = new AnoLetivoService().listarAnoLetivo(ano).get(0);
    criteria.add(Restrictions.eq("anoLetivo", anoLetivo));
    criteria.add(Restrictions.eq("ativo", 1));

    criteria.createAlias("aluno", "aluno");
    if (idPeriodo != 0) {
        criteria.createAlias("periodo", "periodo");
        criteria.add(Restrictions.eq("periodo.idperiodo", idPeriodo));
    }/*from  w ww. j a  va2s.  c o  m*/
    if (!anos.isEmpty()) {
        criteria.createAlias("anoEstudo", "anoEstudo");
        criteria.add(Restrictions.in("anoEstudo.idanoEstudo", anos));
    }
    criteria.add(Restrictions.like("aluno.nome", nome, MatchMode.ANYWHERE));
    criteria.createAlias("grupo", "grupo", Criteria.LEFT_JOIN);
    criteria.add(Restrictions.or(Restrictions.isNull("grupo"), Restrictions.eq("grupo.status", "1")));
    List<AlunoVariavel> result = criteria.list();
    return result;
}

---

From source file:br.com.muranodesign.dao.impl.CalendarioDAOImpl.java

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<Calendario> listFeriados(int ano) {

    Criteria criteria = getSession().createCriteria(Calendario.class);

    criteria.add(Restrictions.or(Restrictions.ge("feriado", 1), Restrictions.eq("aula", 0)));
    criteria.add(Restrictions.eq("ano", ano));
    criteria.addOrder(Order.asc("dataInicio"));

    List<Calendario> result = criteria.list();

    return result;
}

---

From source file:br.com.muranodesign.dao.impl.CalendarioDAOImpl.java

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<Calendario> listFeriados(Calendar dataInicio, Calendar dataFim) {
    Criteria criteria = getSession().createCriteria(Calendario.class);
    criteria.add(Restrictions.or(Restrictions.ge("feriado", 1), Restrictions.eq("aula", 0)));
    criteria.add(Restrictions.eq("ano", dataInicio.get(Calendar.YEAR)));
    criteria.add(Restrictions.ge("dataInicio", dataInicio.getTime()));
    criteria.add(Restrictions.le("dataInicio", dataFim.getTime()));
    criteria.addOrder(Order.asc("dataInicio"));
    List<Calendario> result = criteria.list();
    return result;
}

---

From source file:br.com.muranodesign.dao.impl.CalendarioDAOImpl.java

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<Calendario> listarFeriadosSemana(int dia, int mes) {
    Criteria criteria = getSession().createCriteria(Calendario.class);

    Calendar dataInicio = Calendar.getInstance();
    dataInicio.set(Calendar.MONTH, mes);
    dataInicio.set(Calendar.DATE, dia);
    dataInicio.set(Calendar.WEEK_OF_MONTH, dataInicio.get(Calendar.WEEK_OF_MONTH));
    dataInicio.set(Calendar.DAY_OF_WEEK, dataInicio.getFirstDayOfWeek());
    Calendar dataFim = Calendar.getInstance();
    dataFim.set(Calendar.MONTH, mes);
    dataFim.set(Calendar.DATE, dataInicio.get(Calendar.DATE) + 6);

    criteria.add(Restrictions.or(Restrictions.ge("feriado", 1), Restrictions.eq("aula", 0)));

    criteria.add(Restrictions.or(/* w w w.  java  2s  .  c  o m*/
            (Restrictions.or(Restrictions.between("dataInicio", dataInicio.getTime(), dataFim.getTime()),
                    Restrictions.between("dataFim", dataInicio.getTime(), dataFim.getTime()))),
            Restrictions.and(Restrictions.lt("dataInicio", dataInicio.getTime()),
                    Restrictions.gt("dataFim", dataFim.getTime()))));
    criteria.addOrder(Order.asc("dataInicio"));

    List<Calendario> result = criteria.list();

    return result;

}

---

From source file:br.com.OCTur.control.DAO.PacoteDAO.java

public List<Pacote> pegarPorCidade(Cidade cidade, Date inicio, Date fim, boolean e) {
    List<Hotel> hoteis = new HotelDAO().pegarPorCidade(cidade);
    List<Voo> voos = new VooDAO().pegarPorDestino(cidade);
    Criterion[] criterios = new Criterion[2];
    if (!hoteis.isEmpty()) {
        criterios[0] = Restrictions.in("hotel", hoteis);
    }/* www .ja  v  a 2s  .c om*/
    if (!voos.isEmpty()) {
        criterios[1] = Restrictions.in("voo", voos);
    }
    if (hoteis.isEmpty() && voos.isEmpty()) {
        closeSession();
        return entitys;
    }
    if (e) {
        criteria.add(Restrictions.and(Restrictions.eq("inicio", inicio), Restrictions.eq("fim", fim)));
    } else {
        criteria.add(Restrictions.or(Restrictions.eq("inicio", inicio), Restrictions.eq("fim", fim)));
    }
    entitys = criteria.add(Restrictions.or(criterios)).list();
    closeSession();
    return entitys;
}

---

From source file:br.com.OCTur.control.DAO.PacoteDAO.java

public List<Pacote> pegarPorInicioFim(Date inicio, Date fim, boolean selected) {
    if (selected) {
        criteria.add(Restrictions.and(Restrictions.eq("inicio", inicio), Restrictions.eq("fim", fim)));
    } else {//from  w w w. ja v  a 2 s  .  c o  m
        criteria.add(Restrictions.or(Restrictions.eq("inicio", inicio), Restrictions.eq("fim", fim)));
    }
    entitys = criteria.list();
    closeSession();
    return entitys;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• »