Example usage for org.hibernate.criterion Restrictions 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:au.org.theark.study.model.dao.StudyDao.java

License:Open Source License

@Override
public List<CustomField> getFamilyUIdCustomFieldsForPedigreeRelativesList(Long studyId) {
    List<CustomField> pedigreeCustomFields = null;
    Criteria criteria = getSession().createCriteria(CustomField.class, "cf");
    criteria.createAlias("study", "st", JoinType.INNER_JOIN);
    criteria.createAlias("arkFunction", "af", JoinType.INNER_JOIN);
    criteria.createAlias("fieldType", "ft", JoinType.INNER_JOIN);
    criteria.createAlias("customFieldType", "cft", JoinType.LEFT_OUTER_JOIN);
    criteria.add(Restrictions.eq("st.id", studyId));
    criteria.add(//from w  w  w. j a  va2 s  .c  o m
            Restrictions.eq("af.name", au.org.theark.core.Constants.FUNCTION_KEY_VALUE_SUBJECT_CUSTOM_FIELD));
    criteria.add(Restrictions.isNull("cf.encodedValues"));
    criteria.add(Restrictions.eq("ft.name", au.org.theark.core.Constants.FIELD_TYPE_CHARACTER));
    criteria.add(Restrictions.or(Restrictions.isNull("cft.id"),
            Restrictions.eq("cft.name", au.org.theark.core.Constants.SUBJECT)));

    pedigreeCustomFields = criteria.list();

    return pedigreeCustomFields;
}

From source file:be.wolkmaan.klimtoren.party.PartyRepositoryImpl.java

@Override
public List<PartyToPartyRelationship> listRelations(Party context) {
    return (List<PartyToPartyRelationship>) getSession().createCriteria(PartyToPartyRelationship.class)
            .add(Restrictions.eq("context", context)).add(Restrictions.isNull("end")).list();
}

From source file:be.wolkmaan.klimtoren.party.PartyRepositoryImpl.java

@Override
public List<PartyToPartyRelationship> listRelations() {
    return (List<PartyToPartyRelationship>) getSession().createCriteria(PartyToPartyRelationship.class)
            .add(Restrictions.isNull("end")).list();
}

From source file:be.wolkmaan.klimtoren.party.PartyRepositoryImpl.java

@Override
public List<PartyToPartyRelationship> findRelationsForReference(Party reference, Kind kind) {
    Criteria crit = getSession().createCriteria(PartyToPartyRelationship.class)
            .add(Restrictions.eq("reference", reference)).add(Restrictions.eq("kind", kind))
            .add(Restrictions.isNull("end"));
    return crit.list();
}

From source file:be.wolkmaan.klimtoren.party.PartyRepositoryImpl.java

private Criteria createBidirectional(Party context, Party reference) {
    Criteria crit = getSession().createCriteria(PartyToPartyRelationship.class).add(Restrictions.or(
            Restrictions.and(Restrictions.eq("context", context), Restrictions.eq("reference", reference)),
            Restrictions.and(Restrictions.eq("context", reference), Restrictions.eq("reference", context))))
            .add(Restrictions.isNull("end")); //for now only search live relations
    return crit;//from  w w w  . j a va 2 s .  c o  m
}

From source file:be.wolkmaan.klimtoren.party.PartyRepositoryImpl.java

private Criteria createUnidirectional(Party context, Party reference) {
    Criteria crit = getSession().createCriteria(PartyToPartyRelationship.class)
            .add(Restrictions.and(Restrictions.eq("context", context), Restrictions.eq("reference", reference)))
            .add(Restrictions.isNull("end")); //for now only search live relations
    return crit;/*from   w  w  w . ja v  a  2s .com*/
}

From source file:br.com.hslife.imobiliaria.dao.impl.AluguelDao.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override/*from w w w .j av a 2 s.  c om*/
public List<Aluguel> listByContratoOrPeriodoOrAnoBeforeDataAndPago(Long idContrato, Integer periodo,
        Integer ano, Date data, Boolean pago) {
    List<Criterion> criterios = new ArrayList<Criterion>();
    if (idContrato != null) {
        criterios.add(Restrictions.eq("contrato.id", idContrato));
    }
    if (periodo != null) {
        criterios.add(Restrictions.eq("periodo", periodo));
    }
    if (ano != null) {
        criterios.add(Restrictions.eq("ano", ano));
    }
    if (data != null) {
        criterios.add(Restrictions.le("vencimento", data));
    }
    if (pago != null) {
        if (pago) {
            criterios.add(Restrictions.isNotNull("pagamento"));
        } else {
            criterios.add(Restrictions.isNull("pagamento"));
        }
    }
    return listByCriteria(Aluguel.class, criterios);
}

From source file:br.com.hslife.imobiliaria.dao.impl.AluguelDao.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override/*from  w w w .  ja v a2s . c  o  m*/
public List<Aluguel> listByNomeLocatarioOrContratoOrPeriodoOrAnoBeforeDataAndPago(String nomeLocatario,
        Long idContrato, Integer periodo, Integer ano, Date data, Boolean pago) {
    Criteria criteria = HibernateUtility.getSession().createCriteria(Aluguel.class, "aluguel")
            .createAlias("aluguel.contrato", "contrato").createAlias("contrato.locatario", "locatario");
    if (nomeLocatario != null && !nomeLocatario.trim().isEmpty()) {
        criteria.add(Restrictions.ilike("locatario.nome", nomeLocatario, MatchMode.ANYWHERE));
    }
    if (idContrato != null) {
        criteria.add(Restrictions.eq("contrato.id", idContrato));
    }
    if (periodo != null) {
        criteria.add(Restrictions.eq("aluguel.periodo", periodo));
    }
    if (ano != null) {
        criteria.add(Restrictions.eq("aluguel.ano", ano));
    }
    if (data != null) {
        criteria.add(Restrictions.le("aluguel.vencimento", data));
    }
    if (pago != null) {
        if (pago) {
            criteria.add(Restrictions.isNotNull("aluguel.pagamento"));
        } else {
            criteria.add(Restrictions.isNull("aluguel.pagamento"));
        }
    }
    criteria.addOrder(Order.asc("aluguel.vencimento"));
    return criteria.list();
}

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

License:Open Source License

@SuppressWarnings("unchecked")
public List<CartaoCredito> findOnlyCartaoTipoCreditoByUsuario(Usuario usuario) {
    Criteria criteria = getSession().createCriteria(CartaoCredito.class);
    criteria.add(Restrictions.eq("usuario.id", usuario.getId()));
    criteria.add(Restrictions.eq("tipoCartao", TipoCartao.CREDITO));
    criteria.add(Restrictions.isNull("cartaoSubstituto"));
    return criteria.addOrder(Order.asc("descricao")).list();
}

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

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<AlunoVariavel> ListarCicloAnoPeriodoSemGrupo(List<Integer> anos, 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("anoEstudo", "anoEstudo");
    criteria.add(Restrictions.in("anoEstudo.idanoEstudo", anos));
    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.addOrder(Order.asc("anoEstudo.ano"));
    criteria.createAlias("aluno", "aluno");
    criteria.addOrder(Order.asc("aluno.nome"));
    criteria.setFirstResult(primeiro);//w w w .  j av a 2  s .com
    criteria.setMaxResults(ultimo);
    List<AlunoVariavel> result = criteria.list();
    return result;
}