Example usage for org.hibernate.criterion Restrictions isNull

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

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

Introduction

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

Prototype

public static Criterion isNull(String propertyName)

Source Link

Document

Apply an "is null" constraint to the named property

Usage

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

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<AlunoVariavel> ListarCicloAnoSemGrupo(List<Integer> anos, int primeiro, int ultimo) {
    Criteria criteria = getSession().createCriteria(AlunoVariavel.class);
    String ano = Integer.toString(Calendar.getInstance().get(Calendar.YEAR));
    AnoLetivo anoLetivo = new AnoLetivoService().listarAnoLetivo(ano).get(0);
    criteria.add(Restrictions.eq("anoLetivo", anoLetivo));
    criteria.add(Restrictions.eq("ativo", 1));
    criteria.createAlias("anoEstudo", "anoEstudo");
    criteria.add(Restrictions.in("anoEstudo.idanoEstudo", anos));
    criteria.createAlias("grupo", "grupo", Criteria.LEFT_JOIN);
    criteria.add(Restrictions.or(Restrictions.isNull("grupo"), Restrictions.eq("grupo.status", "1")));
    criteria.addOrder(Order.asc("anoEstudo.ano"));
    criteria.createAlias("aluno", "aluno");
    criteria.addOrder(Order.asc("aluno.nome"));
    criteria.setFirstResult(primeiro);/*from  w  w w  .  j  a  va2  s  . co  m*/
    criteria.setMaxResults(ultimo);
    List<AlunoVariavel> result = criteria.list();
    return result;
}

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

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<AlunoVariavel> ListarRangePeriodoSemGrupo(int idPeriodo, int primeiro, int ultimo) {
    Criteria criteria = getSession().createCriteria(AlunoVariavel.class);
    String ano = Integer.toString(Calendar.getInstance().get(Calendar.YEAR));
    AnoLetivo anoLetivo = new AnoLetivoService().listarAnoLetivo(ano).get(0);
    criteria.add(Restrictions.eq("anoLetivo", anoLetivo));
    criteria.add(Restrictions.eq("ativo", 1));
    criteria.createAlias("periodo", "periodo");
    criteria.add(Restrictions.eq("periodo.idperiodo", idPeriodo));
    criteria.createAlias("grupo", "grupo", Criteria.LEFT_JOIN);
    criteria.add(Restrictions.or(Restrictions.isNull("grupo"), Restrictions.eq("grupo.status", "1")));
    criteria.createAlias("anoEstudo", "anoEstudo");
    criteria.addOrder(Order.asc("anoEstudo.ano"));
    criteria.createAlias("aluno", "aluno");
    criteria.addOrder(Order.asc("aluno.nome"));
    criteria.setFirstResult(primeiro);/*from  ww w  .  j  a  va  2  s. c o  m*/
    criteria.setMaxResults(ultimo);
    List<AlunoVariavel> result = criteria.list();
    return result;
}

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

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<AlunoVariavel> ListarNomeSemGrupo(String nome, int idPeriodo, List<Integer> anos) {
    Criteria criteria = getSession().createCriteria(AlunoVariavel.class);

    String ano = Integer.toString(Calendar.getInstance().get(Calendar.YEAR));
    AnoLetivo anoLetivo = new AnoLetivoService().listarAnoLetivo(ano).get(0);
    criteria.add(Restrictions.eq("anoLetivo", anoLetivo));
    criteria.add(Restrictions.eq("ativo", 1));

    criteria.createAlias("aluno", "aluno");
    if (idPeriodo != 0) {
        criteria.createAlias("periodo", "periodo");
        criteria.add(Restrictions.eq("periodo.idperiodo", idPeriodo));
    }/* ww  w  . jav  a 2 s . c  om*/
    if (!anos.isEmpty()) {
        criteria.createAlias("anoEstudo", "anoEstudo");
        criteria.add(Restrictions.in("anoEstudo.idanoEstudo", anos));
    }
    criteria.add(Restrictions.like("aluno.nome", nome, MatchMode.ANYWHERE));
    criteria.createAlias("grupo", "grupo", Criteria.LEFT_JOIN);
    criteria.add(Restrictions.or(Restrictions.isNull("grupo"), Restrictions.eq("grupo.status", "1")));
    List<AlunoVariavel> result = criteria.list();
    return result;
}

From source file:br.com.OCTur.control.DAO.PessoaDAO.java

public List<Pessoa> pegarSemEmpresa() {
    entitys = criteria.add(Restrictions.isNull("empresa")).list();
    closeSession();
    return entitys;
}

From source file:br.com.pfood.dao.imp.GenericDAOImp.java

/**
 * Metodo criado inicialmente para busca de item_tabela_preco. Voce deve
 * preencher o objeto com os atributos a ser buscado. Vai executar uma busca
 * apartir de todos os atributos COM VALOR, onde on valor for igual ao
 * informado ou entao esta null no banco. A busca  apenas pelos atributos
 * que possuem valor, nao em todo os atributos do objeto.
 *
 * @param <T>/*from  ww w  .  j  a va 2 s. c  o  m*/
 * @param obj
 * @param order
 * @return
 * @throws Exception
 */
@Override
public <T> List<T> getPorAtributosIguaisOuNull(T obj, Order order) throws Exception {
    Criteria c = session.createCriteria(obj.getClass());

    Field[] fields = obj.getClass().getDeclaredFields();
    for (Field f : fields) {
        f.setAccessible(true);
        if ((f.isAnnotationPresent(Column.class) || f.isAnnotationPresent(ManyToOne.class)
                || f.isAnnotationPresent(OneToOne.class)) && !f.getType().isPrimitive()) {
            try {
                Object valor = f.get(obj);
                if (valor != null) {
                    c.add(Restrictions.or(Restrictions.eq(f.getName(), valor),
                            Restrictions.isNull(f.getName())));
                }
            } catch (IllegalAccessException ex) {
                ex.printStackTrace();
            }
        }
    }
    c.setResultTransformer(c.DISTINCT_ROOT_ENTITY);
    if (order != null) {
        c.addOrder(order);
    }
    return (ArrayList<T>) c.list();
}

From source file:br.com.webbudget.domain.model.repository.entries.CostCenterRepository.java

License:Open Source License

/**
 *
 * @param name/*from  w w  w  .  j a va2s . c  om*/
 * @param parent
 * @return
 */
@Override
public CostCenter findByNameAndParent(String name, CostCenter parent) {

    final Criteria criteria = this.getSession().createCriteria(this.getPersistentClass());

    if (parent != null) {
        criteria.createAlias("parentCostCenter", "pcc");
        criteria.add(Restrictions.eq("pcc.name", parent.getName()));
    } else {
        criteria.add(Restrictions.isNull("parentCostCenter"));
    }

    criteria.add(Restrictions.eq("name", name));

    return (CostCenter) criteria.uniqueResult();
}

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

License:Open Source License

/**
 *
 * @return//from w  w w . j  a v  a 2  s  .  co  m
 */
@Override
public List<Movement> listByActiveFinancialPeriod() {

    final Criteria criteria = this.getSession().createCriteria(this.getPersistentClass());

    criteria.createAlias("financialPeriod", "fp");
    criteria.add(Restrictions.eq("fp.closed", false));
    criteria.add(Restrictions.isNull("fp.closing"));

    criteria.addOrder(Order.desc("inclusion"));

    return criteria.list();
}

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

License:Open Source License

/**
 *
 * @param financialPeriod// w w w. ja v a 2s  . com
 * @param card
 * @return
 */
@Override
public List<Movement> listPaidWithoutInvoiceByPeriodAndCard(FinancialPeriod financialPeriod, Card card) {

    final Criteria criteria = this.getSession().createCriteria(this.getPersistentClass());

    criteria.add(Restrictions.isNull("cardInvoice"));
    criteria.add(Restrictions.eq("cardInvoicePaid", Boolean.FALSE));
    criteria.add(Restrictions.eq("movementStateType", MovementStateType.PAID));

    criteria.createAlias("financialPeriod", "fp");
    criteria.add(Restrictions.eq("fp.id", financialPeriod.getId()));

    criteria.createAlias("payment", "py").createAlias("py.card", "cc");
    criteria.add(Restrictions.eq("cc.id", card.getId()));

    criteria.addOrder(Order.asc("py.paymentDate"));

    return criteria.list();
}

From source file:br.com.webbudget.domain.model.repository.miscellany.FinancialPeriodRepository.java

License:Open Source License

/**
 *
 * @return/*w w  w  .j ava 2s  .co m*/
 */
@Override
public List<FinancialPeriod> listOpen() {

    final Criteria criteria = this.getSession().createCriteria(this.getPersistentClass());

    criteria.add(Restrictions.eq("closed", false));
    criteria.add(Restrictions.isNull("closing"));

    criteria.addOrder(Order.asc("end"));

    return criteria.list();
}

From source file:br.com.webbudget.domain.repository.movement.MovementRepository.java

License:Open Source License

/**
 *
 * @param financialPeriod//from w w w .  j a  v  a2s  .  c  om
 * @param card
 * @return
 */
@Override
public List<Movement> listPaidWithoutInvoiceByPeriodAndCard(FinancialPeriod financialPeriod, Card card) {

    final Criteria criteria = this.getSession().createCriteria(this.getPersistentClass());

    criteria.add(Restrictions.isNull("cardInvoice"));
    criteria.add(Restrictions.eq("cardInvoicePaid", Boolean.FALSE));
    criteria.add(Restrictions.eq("movementStateType", MovementStateType.PAID));

    criteria.createAlias("financialPeriod", "fp");
    criteria.add(Restrictions.eq("fp.id", financialPeriod.getId()));

    criteria.createAlias("payment", "py").createAlias("py.card", "cc");
    criteria.add(Restrictions.eq("cc.id", card.getId()));

    return criteria.list();
}