Example usage for org.hibernate.criterion Restrictions in

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

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

Introduction

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

Prototype

public static Criterion in(String propertyName, Collection values)

Source Link

Document

Apply an "in" constraint to the named property.

Usage

From source file:br.com.webbudget.domain.misc.filter.MovementFilter.java

License:Open Source License

/**
 * @return /*from  www.java 2s . c  o m*/
 */
private Criterion getPeriodsCriterion() {

    final Object[] values = this.periods.stream().map(FinancialPeriod::getId).collect(Collectors.toList())
            .stream().toArray(Object[]::new);

    return values.length > 0 ? Restrictions.in("fp.id", values) : null;
}

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

License:Open Source License

/**
 * /*from   ww  w.j a  va  2  s . c  o  m*/
 * @param period
 * @param movementClass
 * @return 
 */
@Override
public BigDecimal totalMovementsPerClassAndPeriod(FinancialPeriod period, MovementClass movementClass) {

    final Criteria criteria = this.createCriteria();

    criteria.createAlias("movement", "mv");
    criteria.createAlias("mv.financialPeriod", "fp");

    criteria.add(Restrictions.eq("fp.id", period.getId()));
    criteria.add(Restrictions.in("mv.movementStateType",
            new Object[] { MovementStateType.PAID, MovementStateType.CALCULATED }));
    criteria.add(Restrictions.eq("movementClass", movementClass));

    criteria.setProjection(Projections.sum("value"));

    return (BigDecimal) criteria.uniqueResult();
}

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

public List<Sample> list(Cycle cycle) {
    List<Sample> lista = null;
    try {//from   w  w w  . j a v a  2s  .c  o m
        VisitDAO vDAo = new VisitDAO();
        List<Visit> lVisit = vDAo.list(cycle);

        this.setSessao(HibernateUtil.getSessionFactory().openSession());
        setTransacao(getSessao().beginTransaction());
        lista = this.getSessao().createCriteria(Sample.class).add(Restrictions.in("visit", lVisit))
                .addOrder(Order.desc("id")).list();

    } catch (Throwable e) {
        if (getTransacao().isActive()) {
            getTransacao().rollback();
        }
        System.out.println("No foi possvel listar: " + e.getMessage());
    } finally {
        getSessao().close();
    }
    return lista;

}

From source file:br.gov.jfrj.siga.dp.dao.CpDao.java

License:Open Source License

public List<DpPessoa> pessoasPorLotacao(Long id, Boolean incluirSublotacoes, Boolean somenteServidor,
        SituacaoFuncionalEnum situacoesFuncionais) throws AplicacaoException {
    if (id == null || id == 0)
        return null;

    DpLotacao lotacao = consultar(id, DpLotacao.class, false);

    List<DpLotacao> sublotacoes = new ArrayList<DpLotacao>();
    sublotacoes.add(lotacao);//from w  w  w  .  j  a v a  2s  . co m
    if (incluirSublotacoes) {
        List<DpLotacao> lotacoes = listarLotacoes();
        boolean continuar = true;
        while (continuar) {
            continuar = false;
            for (DpLotacao lot : lotacoes) {
                if (sublotacoes.contains(lot))
                    continue;
                if (sublotacoes.contains(lot.getLotacaoPai())) {
                    if (!lot.isSubsecretaria()) {
                        sublotacoes.add(lot);
                        continuar = true;
                    }
                }
            }
        }
    }

    List<DpPessoa> lstCompleta = new ArrayList<DpPessoa>();
    for (DpLotacao lot : sublotacoes) {

        Criteria c = HibernateUtil.getSessao().createCriteria(DpPessoa.class);
        c.createAlias("cargo", "c");

        c.add(Restrictions.eq("lotacao.id", lot.getId()));
        if (somenteServidor) {
            c.add(Restrictions.not(Restrictions.in("c.nomeCargo",
                    new String[] { "ESTAGIARIO", "JUIZ SUBSTITUTO", "JUIZ FEDERAL" })));
        }

        c.add(Restrictions.in("situacaoFuncionalPessoa", situacoesFuncionais.getValor()));

        c.add(Restrictions.isNull("dataFimPessoa"));

        c.addOrder(Order.asc("nomePessoa"));

        lstCompleta.addAll((List<DpPessoa>) c.list());

    }
    return lstCompleta;
}

From source file:br.os.rh.disciplina.DisciplinaDAO.java

public List<Disciplina> listarPorCurso() {
    List<Disciplina> lista = null;

    SemestreDAO sDAO = new SemestreDAO();

    try {//w  ww. j a  v  a  2  s  .  c  o m
        this.setSessao(HibernateUtil.getSessionFactory().openSession());
        setTransacao(getSessao().beginTransaction());
        lista = this.getSessao().createCriteria(Disciplina.class)
                .add(Restrictions.in("semestre", sDAO.listarPorCurso())).list();
        //sessao.close();
    } catch (Throwable e) {
        if (getTransacao().isActive()) {
            getTransacao().rollback();
        }
        JOptionPane.showMessageDialog(null, "No foi possvel listar: " + e.getMessage());
    }
    return lista;
}

From source file:br.os.rh.lotacao.LotacaoDAO.java

public List<Lotacao> pesquisaDisciplinaPeriodo(Disciplina d, Periodo periodo) {
    setSessao(HibernateUtil.getSessionFactory().openSession());
    setTransacao(getSessao().beginTransaction());

    List<Lotacao> lotacoes = (List<Lotacao>) getSessao().createCriteria(Lotacao.class)
            .add(Restrictions.eq("periodo", periodo)).list();

    List<LotacaoDisciplina> listaSalaDis = new ArrayList<>();
    if (lotacoes.size() > 0) {
        listaSalaDis = (List<LotacaoDisciplina>) getSessao().createCriteria(LotacaoDisciplina.class)
                .add(Restrictions.in("lotacao", lotacoes)).add(Restrictions.eq("disciplina", d)).list();
    }//from   w w  w.ja v  a2s . co m

    List<Lotacao> lotacaoReturn = new ArrayList<Lotacao>();
    for (int i = 0; i < listaSalaDis.size(); i++) {
        lotacaoReturn.add(listaSalaDis.get(i).getLotacao());
    }

    getSessao().close();
    return lotacaoReturn;
}

From source file:br.os.rh.lotacao.LotacaoDAO.java

public List<Lotacao> listarPorCoordenador() {

    setSessao(HibernateUtil.getSessionFactory().openSession());
    setTransacao(getSessao().beginTransaction());

    LotacaoDisciplinaDAO sdDAO = new LotacaoDisciplinaDAO();
    List<LotacaoDisciplina> lSalDisc = new ArrayList(new HashSet(sdDAO.pesquisaPorCurso()));

    List<Integer> lIds = new ArrayList<>();
    for (LotacaoDisciplina s : lSalDisc) {
        lIds.add(s.getLotacao().getId());
    }/*from   w ww .  j  a v  a  2 s.co m*/

    List<Lotacao> lotacoes = (List<Lotacao>) getSessao().createCriteria(Lotacao.class)
            .add(Restrictions.in("id", lIds)).add(Restrictions.eq("periodo", Ativo.getPeriodo())).list();

    getSessao().close();
    return lotacoes;
}

From source file:br.os.rh.lotacaodisciplinahorario.LotacaoDisciplinaHorarioDAO.java

public boolean pesquisaChoqueHorario(Funcionario f, Horario h, String ds, Periodo p) {
    setSessao(HibernateUtil.getSessionFactory().openSession());
    setTransacao(getSessao().beginTransaction());

    List<Salario> salarios = (List<Salario>) getSessao().createCriteria(Salario.class)
            .add(Restrictions.eq("funcionario", f)).add(Restrictions.eq("periodo", p)).list();

    List<LotacaoDisciplina> sdLista = new ArrayList<LotacaoDisciplina>(new HashSet(getSessao()
            .createCriteria(LotacaoDisciplina.class).add(Restrictions.in("salario", salarios)).list()));

    List<LotacaoDisciplinaHorario> sdhLista = (List<LotacaoDisciplinaHorario>) getSessao()
            .createCriteria(LotacaoDisciplina.class).add(Restrictions.in("salarioDisciplina", sdLista))
            .add(Restrictions.eq("horario", h)).add(Restrictions.eq("diaSemana", ds)).list();

    getSessao().close();//  w ww.  jav  a2 s. c  o m
    return sdhLista.size() > 0;
}

From source file:br.os.rh.lotacaodisciplinahorario.LotacaoDisciplinaHorarioDAO.java

public List<LotacaoDisciplinaHorario> pesquisaDisciplinasFuncionario(Funcionario f, String ds, Periodo p) {
    setSessao(HibernateUtil.getSessionFactory().openSession());
    setTransacao(getSessao().beginTransaction());

    List<Lotacao> lotacoes = (List<Lotacao>) getSessao().createCriteria(Lotacao.class)
            .add(Restrictions.eq("professor", f)).add(Restrictions.eq("periodo", p)).list();

    List<LotacaoDisciplina> sdLista = new ArrayList<LotacaoDisciplina>(new HashSet(getSessao()
            .createCriteria(LotacaoDisciplina.class).add(Restrictions.in("lotacao", lotacoes)).list()));

    List<LotacaoDisciplinaHorario> sdhLista = (List<LotacaoDisciplinaHorario>) getSessao()
            .createCriteria(LotacaoDisciplinaHorario.class).add(Restrictions.in("salarioDisciplina", sdLista))
            .add(Restrictions.eq("diaSemana", ds)).list();

    getSessao().close();//from  ww w  . j  a  v a 2  s.c o  m
    return sdhLista;
}

From source file:br.os.rh.lotacaodiscplinas.LotacaoDisciplinaDAO.java

public List<LotacaoDisciplina> pesquisaPorCurso() {
    setSessao(HibernateUtil.getSessionFactory().openSession());
    setTransacao(getSessao().beginTransaction());

    DisciplinaDAO dDAO = new DisciplinaDAO();
    List<Disciplina> disciplinas = dDAO.listarPorCurso();

    List<LotacaoDisciplina> sDisciplinas = (List<LotacaoDisciplina>) getSessao()
            .createCriteria(LotacaoDisciplina.class).add(Restrictions.in("disciplina", disciplinas)).list();

    getSessao().close();/*from  ww w .  j ava  2  s .  c  om*/
    return sDisciplinas;
}