Example usage for org.hibernate.criterion Restrictions le

Introduction

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

Prototype

public static SimpleExpression le(String propertyName, Object value) 

Source Link

Document

Apply a "less than or equal" constraint to the named property

Usage

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

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<RelatorioTutoria> listarTutoriaAlunoAno(int tutoria, int aluno, int ano) {
    Criteria criteria = getSession().createCriteria(RelatorioTutoria.class);
    Calendar calInicio = Calendar.getInstance();
    calInicio.set(Calendar.YEAR, ano);
    calInicio.set(Calendar.DAY_OF_YEAR, 1);
    Calendar calFim = Calendar.getInstance();
    calFim.set(Calendar.YEAR, ano);
    calFim.set(Calendar.DAY_OF_YEAR, calFim.getActualMaximum(Calendar.DAY_OF_YEAR));
    criteria.add(Restrictions.ge("data", calInicio.getTime()));
    criteria.add(Restrictions.le("data", calFim.getTime()));
    criteria.createAlias("aluno", "aluno");
    criteria.add(Restrictions.eq("aluno.idAluno", aluno));
    criteria.createAlias("tutoria", "tutoria");
    criteria.add(Restrictions.eq("tutoria.idtutoria", tutoria));
    List<RelatorioTutoria> result = criteria.list();
    return result;
}

---

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

public List<Reserva> pegarPorQuartoInicioFim(Quarto quarto, Date inicio, Date fim) {
    entitys = criteria.add(Restrictions.eq("quarto", quarto))
            .add(Restrictions.or(//from w  w  w  .  j  a  va2s .c o m
                    Restrictions.and(Restrictions.le("inicio", inicio), Restrictions.ge("fim", inicio)),
                    Restrictions.between("inicio", inicio, fim), Restrictions.between("fim", inicio, fim)))
            .list();
    closeSession();
    return entitys;
}

---

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

public boolean validar(Evento evento) {
    entitys = criteria.add(Restrictions.eq("salao", evento.getSalao()))
            .add(Restrictions.or(Restrictions.between("inicio", evento.getInicio(), evento.getFim()),
                    Restrictions.between("fim", evento.getInicio(), evento.getFim()),
                    Restrictions.or(//from w  w  w . j av a2 s  . com
                            Restrictions.and(Restrictions.ge("inicio", evento.getInicio()),
                                    Restrictions.le("fim", evento.getInicio())),
                            Restrictions.and(Restrictions.le("inicio", evento.getFim()),
                                    Restrictions.ge("fim", evento.getFim())))))
            .list();
    session.close();
    return entitys.isEmpty();
}

---

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

public Evento pegarPorSalaoDia(Salao salao, Date time) {
    entity = (Evento) criteria.add(Restrictions.eq("salao", salao))
            .add(Restrictions.and(Restrictions.le("inicio", time), Restrictions.ge("fim", time)))
            .uniqueResult();//  ww w  .  j  a va 2s  .co  m
    session.close();
    return entity;
}

---

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

public List<Hospedagem> pegarEntreODia(Date data) {
    entitys = criteria.add(Restrictions.le("entrada", data)).add(Restrictions.ge("saida", data)).list();
    session.close();//from   w  w  w  . ja v a 2s. com
    return entitys;
}

---

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

public List<Hospedagem> pegarEntreODia(Date data, int apartamento) {
    entitys = criteria.add(Restrictions.eq("apartamento", apartamento)).add(Restrictions.le("entrada", data))
            .add(Restrictions.ge("saida", data)).list();
    session.close();/*w  ww .j a v  a2 s .c o m*/
    return entitys;
}

---

From source file:br.com.webbudget.domain.model.repository.financial.MovementRepository.java

License:Open Source License

/**
 *
 * @param dueDate//from  w  ww .  j  a va  2s .  c o  m
 * @param showOverdue
 * @return
 */
@Override
public List<Movement> listByDueDate(LocalDate dueDate, boolean showOverdue) {

    final Criteria criteria = this.createCriteria();

    if (showOverdue) {
        criteria.add(Restrictions.le("dueDate", dueDate));
        criteria.add(Restrictions.eq("movementStateType", MovementStateType.OPEN));
    } else {
        criteria.add(Restrictions.eq("dueDate", dueDate));
    }

    criteria.addOrder(Order.asc("dueDate"));

    return criteria.list();
}

---

From source file:br.com.webbudget.domain.repository.movement.MovementRepository.java

License:Open Source License

/**
 *
 * @param dueDate/*w ww. ja  v  a  2  s.  co m*/
 * @param showOverdue
 * @return
 */
@Override
public List<Movement> listByDueDate(Date dueDate, boolean showOverdue) {

    final Criteria criteria = this.getSession().createCriteria(this.getPersistentClass());

    if (showOverdue) {
        criteria.add(Restrictions.le("dueDate", dueDate));
        criteria.add(Restrictions.eq("movementStateType", MovementStateType.OPEN));
    } else {
        criteria.add(Restrictions.eq("dueDate", dueDate));
    }

    criteria.addOrder(Order.asc("dueDate"));

    return criteria.list();
}

---

From source file:br.endemics.dao.CycleDAO.java

public List<Cycle> listCyclesByCity(City c, Date data) {
    List<Cycle> cycles = null;
    try {//from  w w  w.j  a  v a  2 s .  co m
        this.setSessao(HibernateUtil.getSessionFactory().openSession());
        setTransacao(getSessao().beginTransaction());
        cycles = this.getSessao().createCriteria(Cycle.class).add(Restrictions.le("startDate", data))
                .add(Restrictions.ge("endDate", data)).add(Restrictions.eq("city", c)).list();
    } catch (Exception e) {
        System.out.println(e.getMessage());
    }

    return cycles;
}

---

From source file:br.gov.jfrj.siga.ex.bl.ExBL.java

License:Open Source License

public void marcarTudo(int primeiro, int ultimo, boolean efetivar, boolean apenasTemporalidade,
        PrintWriter out) {/* w ww .j av  a2  s. com*/

    List<ExDocumento> list = new ArrayList<ExDocumento>();

    final Criteria countCrit = dao().getSessao().createCriteria(ExDocumento.class)
            .add(Restrictions.ge("idDoc", new Long(primeiro)));
    if (ultimo != 0)
        countCrit.add(Restrictions.le("idDoc", new Long(ultimo)));
    countCrit.setProjection(Projections.rowCount());

    final Criteria crit = dao().getSessao().createCriteria(ExDocumento.class)
            .add(Restrictions.ge("idDoc", new Long(primeiro)));
    if (ultimo != 0)
        crit.add(Restrictions.le("idDoc", new Long(ultimo)));
    crit.setMaxResults(5);
    crit.addOrder(Order.asc("idDoc"));

    out.println("-----------------------------------------------");
    out.print(new SimpleDateFormat("HH:mm:ss").format(new Date()));
    out.print(" - Remarcando documentos.");
    out.print(" Primeiro: ");
    out.println(primeiro);
    if (ultimo != 0) {
        out.print(" Ultimo: ");
        out.println(ultimo);
    }
    if (efetivar)
        out.println("***EFETIVAR!!***");
    out.println("-----------------------------------------------");

    int index = 0;

    do {
        long inicio = System.currentTimeMillis();
        if (efetivar)
            iniciarAlteracao();
        crit.setFirstResult(index);
        list = crit.list();
        for (ExDocumento doc : list) {
            index++;
            StringBuilder msg = new StringBuilder();
            try {

                StringBuilder marcasAnteriores = new StringBuilder();
                for (ExMobil mob : doc.getExMobilSet()) {
                    marcasAnteriores.append(mob.isGeral() ? "0" : mob.getNumSequencia());
                    marcasAnteriores.append(" - ");
                    marcasAnteriores.append(mob.getMarcadoresDescrCompleta(apenasTemporalidade));
                }
                atualizarMarcasTemporalidade(doc);
                StringBuilder marcasPosteriores = new StringBuilder();
                for (ExMobil mob : doc.getExMobilSet()) {
                    marcasPosteriores.append(mob.isGeral() ? "0" : mob.getNumSequencia());
                    marcasPosteriores.append(" - ");
                    marcasPosteriores.append(mob.getMarcadoresDescrCompleta(apenasTemporalidade));
                }

                if (!marcasAnteriores.toString().equals(marcasPosteriores.toString())) {
                    msg.append("Marcas:");
                    msg.append("\n\tAntes: ");
                    msg.append(marcasAnteriores);
                    msg.append("\n\tDepois: ");
                    msg.append(marcasPosteriores);
                }

            } catch (Throwable e) {
                msg.append("ERRO: ");
                msg.append(e.getMessage());
                e.printStackTrace(out);
            }

            if (msg.length() > 0) {
                msg.insert(0, "\n");
                msg.insert(0, doc.getCodigo());
                msg.insert(0, " - ");
                msg.insert(0, new SimpleDateFormat("HH:mm:ss").format(new Date()));
                msg.insert(0, "\n");
                out.println(msg);
            }

        }
        if (efetivar) {
            ExDao.commitTransacao();
            //System.gc();
        }
        dao().getSessao().clear();
    } while (list.size() > 0);

    out.println("\n-----------------------------------------------");
    out.print(new SimpleDateFormat("HH:mm:ss").format(new Date()));
    out.println(" - Fim");
    out.println("-----------------------------------------------");

    //System.gc();
}

---

• «
• 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
• 47
• 48
• 49
• 50
• »