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

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<PlanejamentoRoteiro> countRoteiroCompletos(Integer idroteiro, int idAluno, int ano) {
    Criteria criteria = getSession().createCriteria(PlanejamentoRoteiro.class);
    Calendar cal = Calendar.getInstance();
    cal.set(Calendar.YEAR, ano);/*from  ww w.  jav a  2s.  c o  m*/
    cal.set(Calendar.DAY_OF_YEAR, 1);
    Calendar calFim = Calendar.getInstance();
    calFim.set(Calendar.YEAR, ano + 1);
    calFim.set(Calendar.DAY_OF_YEAR, 1);
    criteria.add(Restrictions.ge("dataStatusPlanejado", cal.getTime()));
    criteria.add(Restrictions.lt("dataStatusPlanejado", calFim.getTime()));
    criteria.add(Restrictions.eq("idAluno", idAluno));
    criteria.createAlias("objetivo", "objetivo");
    criteria.createAlias("objetivo.roteiro", "roteiro");
    criteria.add(Restrictions.isNotNull("objetivo"));
    criteria.add(Restrictions.eq("roteiro.idroteiro", idroteiro));
    criteria.add(Restrictions.ge("status", "2"));
    List<PlanejamentoRoteiro> result = criteria.list();
    return result;
}

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

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<PlanejamentoRoteiro> countRoteiroCorrigidos(Integer idroteiro, int idAluno, int ano) {
    Criteria criteria = getSession().createCriteria(PlanejamentoRoteiro.class);
    Calendar cal = Calendar.getInstance();
    cal.set(Calendar.YEAR, ano);//from w w  w . j av  a  2 s .c  om
    cal.set(Calendar.DAY_OF_YEAR, 1);
    Calendar calFim = Calendar.getInstance();
    calFim.set(Calendar.YEAR, ano + 1);
    calFim.set(Calendar.DAY_OF_YEAR, 1);
    criteria.add(Restrictions.ge("dataStatusPlanejado", cal.getTime()));
    criteria.add(Restrictions.lt("dataStatusPlanejado", calFim.getTime()));
    criteria.add(Restrictions.eq("idAluno", idAluno));
    criteria.createAlias("objetivo", "objetivo");
    criteria.createAlias("objetivo.roteiro", "roteiro");
    criteria.add(Restrictions.isNotNull("objetivo"));
    criteria.add(Restrictions.eq("roteiro.idroteiro", idroteiro));
    criteria.add(Restrictions.eq("status", "3"));
    List<PlanejamentoRoteiro> result = criteria.list();
    return result;
}

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

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<PresencaProfessor> listarFaltas(int id) {
    Criteria criteria = getSession().createCriteria(PresencaProfessor.class);
    Calendar cal = Calendar.getInstance();
    cal.set(Calendar.DAY_OF_YEAR, 1);
    criteria.add(Restrictions.ge("data", cal.getTime()));
    criteria.createAlias("professor", "professor");
    criteria.add(Restrictions.eq("professor.idprofessorFuncionarioVariavel", id));
    criteria.add(Restrictions.eq("presenca", 0));
    List<PresencaProfessor> result = criteria.list();
    return result;

}

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

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<PresencaProfessor> listarPresencas(Integer id) {
    Criteria criteria = getSession().createCriteria(PresencaProfessor.class);
    Calendar cal = Calendar.getInstance();
    cal.set(Calendar.DAY_OF_YEAR, 1);
    criteria.add(Restrictions.ge("data", cal.getTime()));
    criteria.createAlias("professor", "professor");
    criteria.add(Restrictions.eq("professor.idprofessorFuncionarioVariavel", id));
    criteria.add(Restrictions.eq("presenca", 1));
    List<PresencaProfessor> result = criteria.list();
    return result;
}

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  .jav a  2s.  c  om
                    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 a  v a2s .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();// w w w. j a  v  a  2 s.c om
    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   ww  w .ja va2 s .co m
    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();/*www  .ja  v  a  2  s .c  o  m*/
    return entitys;
}