Example usage for org.hibernate.criterion Restrictions ge

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

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. Restrictions
  6. ge

Introduction

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

Prototype

public static SimpleExpression ge(String propertyName, Object value)

Source Link

Document

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

Usage

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.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(/*from   w ww.j a v a  2 s . c  om*/
            (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.muranodesign.dao.impl.ChamadaDAOImpl.java

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<Chamada> listaPrecenca(Aluno aluno, int precenca) {

    Criteria criteria = getSession().createCriteria(Chamada.class);
    Calendar cal = Calendar.getInstance();
    cal.set(Calendar.DAY_OF_YEAR, 1);
    criteria.add(Restrictions.ge("data", cal.getTime()));

    short shortPrecenca;
    shortPrecenca = (short) precenca;

    criteria.add(Restrictions.eq("aluno", aluno));
    criteria.add(Restrictions.eq("presenca", shortPrecenca));

    List<Chamada> 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 a  v  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.ForumQuestaoDAOImpl.java

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<ForumQuestao> Range(String data2, String data) {

    StringUtil stringUtil = new StringUtil();

    Criteria criteria = getSession().createCriteria(ForumQuestao.class);
    criteria.add(Restrictions.ge("data", stringUtil.converteStringData(data2)));
    criteria.add(Restrictions.lt("data", stringUtil.converteStringData(data)));
    List<ForumQuestao> result = criteria.list();

    return result;
}

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

License:Creative Commons License

public long listarAlunoTotal(int id) {
    Criteria criteria = getSession().createCriteria(PlanejamentoRoteiro.class);
    Calendar cal = Calendar.getInstance();
    cal.set(Calendar.DAY_OF_YEAR, 1);
    criteria.add(Restrictions.ge("dataStatusPlanejado", cal.getTime()));
    criteria.add(Restrictions.eq("idAluno", id));
    criteria.add(Restrictions.isNotNull("objetivo"));
    criteria.setProjection(Projections.count("idAluno"));

    long result = (Long) criteria.list().get(0);
    return result;
}

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

License:Creative Commons License

public /*List<PlanejamentoRoteiro>*/long listarAlunoCompletos(int id) {
    Criteria criteria = getSession().createCriteria(PlanejamentoRoteiro.class);
    Calendar cal = Calendar.getInstance();
    cal.set(Calendar.DAY_OF_YEAR, 1);
    criteria.add(Restrictions.ge("dataStatusPlanejado", cal.getTime()));
    criteria.add(Restrictions.eq("idAluno", id));
    criteria.add(Restrictions.isNotNull("objetivo"));
    criteria.add(Restrictions.eq("status", "2"));
    criteria.setProjection(Projections.count("idAluno"));
    //List<PlanejamentoRoteiro> result = criteria.list();
    long result = (Long) criteria.list().get(0);
    return result;
}