Example usage for org.hibernate.criterion Restrictions 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.hslife.orcamento.model.CriterioAuditoria.java

License:Open Source License

public void setInicio(Date inicio) {
    this.inicio = inicio;

    hibernateCriterions.remove("inicio");

    if (inicio != null) {
        hibernateCriterions.put("inicio", Restrictions.ge("data", inicio));
    }/*ww  w  . j a v  a2  s . c om*/
}

From source file:br.com.hslife.orcamento.model.CriterioBuscaLancamentoConta.java

License:Open Source License

public void setDataInicio(Date dataInicio) {
    this.dataInicio = dataInicio;

    // Remove a data de incio anteriormente setada
    hibernateCriterions.remove("dataInicio");

    if (dataInicio != null)
        hibernateCriterions.put("dataInicio", Restrictions.ge("lancamento.dataPagamento", dataInicio));
}

From source file:br.com.hslife.orcamento.model.CriterioLog.java

License:Open Source License

@SuppressWarnings("deprecation")
public void setInicio(Date inicio) {
    this.inicio = inicio;

    hibernateCriterions.remove("inicio");

    if (inicio != null) {
        // Seta a data de incio para 00:00:00 do dia
        inicio.setHours(0);//from   ww  w .j a  v a2  s .c  o m
        inicio.setMinutes(0);
        inicio.setSeconds(0);

        hibernateCriterions.put("inicio", Restrictions.ge("logDate", inicio));
    }
}

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

License:Open Source License

@SuppressWarnings("unchecked")
public List<Agenda> findByCriterioAgendamento(CriterioAgendamento criterioBusca) {
    Criteria criteria = getSession().createCriteria(Agenda.class);

    if (criterioBusca.getDescricao() != null && !criterioBusca.getDescricao().trim().isEmpty()) {
        criteria.add(Restrictions.ilike("descricao", criterioBusca.getDescricao(), MatchMode.ANYWHERE));
    }//from  www  .j  a  v  a 2s  . c  o  m

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

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

    if (criterioBusca.getTipo() != null) {
        criteria.add(Restrictions.eq("tipoAgendamento", criterioBusca.getTipo()));
    }

    if (criterioBusca.getUsuario() != null) {
        criteria.add(Restrictions.eq("usuario.id", criterioBusca.getUsuario().getId()));
    }

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

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));
    }// www.  ja  v  a2s  .  co  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.FechamentoPeriodoRepository.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<FechamentoPeriodo> findFechamentosPosteriores(FechamentoPeriodo fechamento) {
    Criteria criteria = getSession().createCriteria(FechamentoPeriodo.class);
    criteria.add(Restrictions.eq("conta.id", fechamento.getConta().getId()));
    criteria.add(Restrictions.eq("operacao", OperacaoConta.FECHAMENTO));
    criteria.add(Restrictions.ge("data", fechamento.getData()));
    return criteria.list();
}

From source file:br.com.jn.dao.CandidatoDAO.java

public List<Candidato> listar() {
    Authentication a = SecurityContextHolder.getContext().getAuthentication();
    //Authentication authentication = context.getAuthentication();
    Object principal = a.getPrincipal();
    String username = "";
    username = (((User) a.getPrincipal()).getUsername());
    //username = ((UserDetails) principal).getUsername();
    System.out.println("login selecionado:" + username);

    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
    session.beginTransaction();//  ww w .ja  va2s .  c  om

    String sql = "select * from users where username = :username";
    SQLQuery query = session.createSQLQuery(sql);
    query.addEntity(Users.class);
    query.setParameter("username", username);
    //Users usuario = (Users) query.uniqueResult();
    List logado = query.list();
    //List<Users> results = query.getResultList();

    String UserId = logado.get(0).toString();
    String usuario = "4";
    //System.out.println("Id do usuario selecionado:" + usuario.getUserId());
    //System.out.println("Id do usuario selecionado:" + usuario.getNome());

    //Integer UserId = usuario.getUserId();
    System.out.println("Id do usuario selecionado:" + UserId);

    Criteria crit = session.createCriteria(Candidato.class);
    crit.add(Restrictions.ge("notaEliminatoria", (5.0)));
    crit.add(Restrictions.eq("orientador1", username));
    crit.addOrder(Order.asc("nome"));

    List<Candidato> lista = crit.list();
    session.close();
    return lista;
}

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

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<Calendario> listVisivel() {
    Criteria criteria = getSession().createCriteria(Calendario.class);
    criteria.add(Restrictions.ge("visivel", 1));
    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> 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> 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;
}