Example usage for org.hibernate.criterion Restrictions le

List of usage examples for org.hibernate.criterion Restrictions le

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. Restrictions
  6. 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.hslife.orcamento.repository.ArquivoRepository.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Arquivo> findByCriterioArquivo(CriterioArquivo criterio) {
    Criteria criteria = getSession().createCriteria(Arquivo.class);

    if (criterio.getNome() != null && !criterio.getNome().isEmpty()) {
        criteria.add(Restrictions.ilike("nomeArquivo", criterio.getNome(), MatchMode.ANYWHERE));
    }//from  w ww .  ja  v  a  2s .c  o m

    if (criterio.getInicio() != null) {
        criteria.add(Restrictions.ge("dataCriacao", criterio.getInicio()));
    }

    if (criterio.getFim() != null) {
        criteria.add(Restrictions.le("dataCriacao", criterio.getFim()));
    }

    if (criterio.getContainer() != null) {
        criteria.add(Restrictions.eq("container", criterio.getContainer()));
    }

    criteria.add(Restrictions.eq("usuario.id", criterio.getUsuario().getId()));

    return criteria.addOrder(Order.asc("nomeArquivo")).list();
}

From source file:br.com.hslife.orcamento.repository.CartaoCreditoRepository.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<CartaoCredito> findByDataValidade(Date data) {
    Criteria criteria = getSession().createCriteria(CartaoCredito.class);
    criteria.add(Restrictions.le("validade", data));
    return criteria.list();
}

From source file:br.com.hslife.orcamento.repository.FechamentoPeriodoRepository.java

License:Open Source License

@SuppressWarnings("unchecked")
public FechamentoPeriodo findLastFechamentoPeriodoBeforeDateByContaAndOperacao(Conta conta, Date data,
        OperacaoConta operacao) {/*from w w  w.  jav a 2  s . com*/
    Criteria criteria = getSession().createCriteria(FechamentoPeriodo.class);
    criteria.add(Restrictions.le("data", data));
    criteria.add(Restrictions.eq("operacao", operacao));
    criteria.add(Restrictions.eq("conta.id", conta.getId()));
    List<FechamentoPeriodo> resultado = criteria.addOrder(Order.desc("id")).setMaxResults(1).list();
    if (resultado == null || resultado.size() != 1) {
        return null;
    } else {
        return resultado.get(0);
    }
}

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

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<Calendario> listFiltroData(Date dataInicio, Date dataFim) {

    Criteria criteria = getSession().createCriteria(Calendario.class);
    criteria.add(Restrictions.ge("dataInicio", dataInicio));
    criteria.add(Restrictions.le("dataFim", dataFim));
    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> listarRange() {
    Criteria criteria = getSession().createCriteria(Calendario.class);

    StringUtil stringUtil = new StringUtil();

    Calendar cal = Calendar.getInstance();

    int anomenos = cal.get(Calendar.YEAR) - 1;
    int anomais = cal.get(Calendar.YEAR) + 1;

    String ini = Integer.toString(anomenos - 2000) + "-01-01";
    String fim = Integer.toString(anomais - 2000) + "-01-01";

    criteria.add(Restrictions.ge("dataFim", stringUtil.converteStringData(ini)));
    criteria.add(Restrictions.le("dataFim", stringUtil.converteStringData(fim)));
    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> listarGeralMes(int mes, int ano) {
    Criteria criteria = getSession().createCriteria(Calendario.class);
    Calendar primeiroDia = Calendar.getInstance();
    primeiroDia.set(Calendar.YEAR, ano);
    primeiroDia.set(Calendar.MONTH, mes - 1);
    primeiroDia.set(Calendar.DAY_OF_MONTH, 1);
    Calendar ultimoDia = Calendar.getInstance();
    ultimoDia.set(Calendar.YEAR, ano);
    ultimoDia.set(Calendar.MONTH, mes - 1);
    ultimoDia.set(Calendar.DAY_OF_MONTH, ultimoDia.getActualMaximum(Calendar.DAY_OF_MONTH));
    criteria.createAlias("tipoEvento", "tipoEvento");
    criteria.add(Restrictions.eq("tipoEvento.idtipoEvento", 46));
    criteria.add(Restrictions.ge("dataInicio", primeiroDia.getTime()));
    criteria.add(Restrictions.le("dataInicio", ultimoDia.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> 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.ChamadaDAOImpl.java

License:Creative Commons License

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

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

    criteria.createAlias("aluno", "aluno");
    criteria.add(Restrictions.eq("aluno.idAluno", idAluno));

    //criteria.add(Restrictions.eq("presenca", (short)0));

    criteria.add(Restrictions.ge("data", primeiroDia.getTime()));
    criteria.add(Restrictions.le("data", ultimoDia.getTime()));
    criteria.addOrder(Order.asc("data"));

    List<Chamada> result = criteria.list();
    return result;

}

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

License:Creative Commons License

@SuppressWarnings("unchecked")
public long countFaltasAno(int idAluno, int ano) {
    short t = 0;/*from   w w  w.  j av  a  2  s  .  c o  m*/
    Criteria criteria = getSession().createCriteria(Chamada.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", idAluno));
    criteria.add(Restrictions.eq("presenca", t));
    List<Chamada> result = criteria.list();
    long r = result.size();
    return r;
}

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

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<PlanejamentoRoteiro> listarAlunoAno(int idAluno, int ano) {
    Criteria criteria = getSession().createCriteria(PlanejamentoRoteiro.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.eq("idAluno", idAluno));
    criteria.add(Restrictions.ge("dataStatusPlanejado", calInicio.getTime()));
    criteria.add(Restrictions.le("dataStatusPlanejado", calFim.getTime()));
    List<PlanejamentoRoteiro> result = criteria.list();
    return result;
}