Example usage for org.hibernate.criterion Restrictions not

Introduction

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

Prototype

public static Criterion not(Criterion expression)

Source Link

Document

Return the negation of an expression

Usage

From source file:org.libreplan.business.common.daos.EntitySequenceDAO.java

License:Open Source License

@Override
@SuppressWarnings("unchecked")
public List<EntitySequence> findEntitySequencesNotIn(List<EntitySequence> entitySequences) {
    List<Long> entitySequenceIds = new ArrayList<>();
    for (EntitySequence entitySequence : entitySequences) {
        if (!entitySequence.isNewObject()) {
            entitySequenceIds.add(entitySequence.getId());
        }/*ww  w  . j av a  2  s  .  co  m*/
    }

    return getSession().createCriteria(EntitySequence.class)
            .add(Restrictions.not(Restrictions.in("id", entitySequenceIds))).list();
}

From source file:org.libreplan.business.documents.daos.DocumentDAO.java

License:Open Source License

@Override
@Transactional(readOnly = true)//w  ww .  ja  v a  2s.  c  o  m
public List<Document> findWorkDocumentBetween(Date from, Date to) {
    Criteria c = getSession().createCriteria(Document.class);
    c.add(Restrictions.eq("docType", DocumentTypeEnum.WORK))
            .add(Restrictions.not(Restrictions.like("docTitle", "WorkRoot-", MatchMode.START)))
            .createCriteria("work").add(Restrictions.ge("fromTime", from)).add(Restrictions.lt("toTime", to));

    return c.list();
}

From source file:org.libreplan.business.documents.daos.DocumentDAO.java

License:Open Source License

@Override
@Transactional(readOnly = true)//from  ww w .jav a  2 s.  c  o  m
public List<Document> findWorkDocumentBetween(Date from, Date to, boolean folder) {
    Criteria c = getSession().createCriteria(Document.class);
    c.add(Restrictions.eq("docType", DocumentTypeEnum.WORK)).add(Restrictions.eq("isFolder", folder))
            .add(Restrictions.not(Restrictions.like("docTitle", "WorkRoot-", MatchMode.START)))
            .createCriteria("work").add(Restrictions.ge("fromTime", from)).add(Restrictions.lt("toTime", to));

    return c.list();
}

From source file:org.libreplan.business.orders.daos.OrderDAO.java

License:Open Source License

@Override
@SuppressWarnings("unchecked")
public List<Order> getActiveOrders() {
    Criteria criteria = getSession().createCriteria(getEntityClass());
    criteria.add(Restrictions.not(Restrictions.eq(STATE_PARAMETER, OrderStatusEnum.CANCELLED)));
    criteria.add(Restrictions.not(Restrictions.eq(STATE_PARAMETER, OrderStatusEnum.STORED)));

    return criteria.list();
}

From source file:org.motechproject.server.model.db.hibernate.HibernateMotechDAO.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Facility> getAllFacilities() {
    Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Facility.class, "f");
    criteria.createAlias("f.location", "location");
    criteria.add(Restrictions.not(Restrictions.eq("facilityId", 9999)));

    criteria.addOrder(Order.asc("location.name"));

    return (List<Facility>) criteria.list();
}

From source file:org.mzd.shap.domain.dao.FeatureDaoSpringHibernate.java

License:Open Source License

public List<Feature> pageBySample(final int firstElement, final int maxResults, final Sample sample,
        final FeatureType type, final Collection<Taxonomy> excludedTaxa) {
    return getHibernateTemplate().execute(new HibernateCallback<List<Feature>>() {
        @SuppressWarnings("unchecked")
        public List<Feature> doInHibernate(Session session) throws HibernateException, SQLException {
            Criteria crit = session.createCriteria(getPersistentClass()).setFirstResult(firstElement)
                    .setMaxResults(maxResults).addOrder(Order.asc("id")).add(Restrictions.eq("type", type))
                    .createAlias("sequence", "seq").add(Restrictions.eq("seq.sample", sample));

            if (excludedTaxa != null && excludedTaxa.size() > 0) {
                crit.add(Restrictions.not(Restrictions.in("seq.taxonomy", excludedTaxa)));
            }/* w  w  w. j a v  a 2  s .c  om*/
            return crit.list();
        }
    });
}

From source file:org.mzd.shap.domain.dao.FeatureDaoSpringHibernate.java

License:Open Source License

public Long countBySample(final Sample sample, final FeatureType type,
        final Collection<Taxonomy> excludedTaxa) {
    return getHibernateTemplate().execute(new HibernateCallback<Long>() {
        public Long doInHibernate(Session session) throws HibernateException, SQLException {
            Criteria crit = session.createCriteria(getPersistentClass()).setProjection(Projections.rowCount())
                    .add(Restrictions.eq("type", type)).createCriteria("sequence")
                    .add(Restrictions.eq("sample", sample));

            if (excludedTaxa != null && excludedTaxa.size() > 0) {
                crit.add(Restrictions.not(Restrictions.in("taxonomy", excludedTaxa)));
            }//from   w  ww  .j av a  2  s.c  o  m
            return (Long) crit.uniqueResult();
        }
    });
}

From source file:org.n52.server.ses.hibernate.HibernateUtil.java

License:Open Source License

@SuppressWarnings("unchecked")
public static List<BasicRule> getAllOtherBasicRules(String userID) {
    Session session = getSessionFactory().getCurrentSession();
    session.beginTransaction();//from   w w w  .ja  v a  2  s .c  om
    Criteria crit = session.createCriteria(BasicRule.class);
    Criterion restriction = Restrictions.not(Restrictions.eq(OWNER_ID, Integer.valueOf(userID)));
    List<BasicRule> rules = crit.add(restriction).list();
    session.getTransaction().commit();
    return rules;
}

From source file:org.n52.server.ses.hibernate.HibernateUtil.java

License:Open Source License

@SuppressWarnings("unchecked")
public static List<BasicRule> getAllOtherPublishedBasicRules(String userID) {
    Session session = getSessionFactory().getCurrentSession();
    session.beginTransaction();/*ww  w .j a  v  a 2s  .  c o m*/
    Criteria crit = session.createCriteria(BasicRule.class);
    Criterion isOwner = Restrictions.not(Restrictions.eq(OWNER_ID, valueOf(userID)));
    SimpleExpression isPublished = Restrictions.eq(PUBLISHED, true);
    List<BasicRule> rules = crit.add(Restrictions.and(isOwner, isPublished)).list();
    session.getTransaction().commit();
    return rules;
}

From source file:org.n52.server.ses.hibernate.HibernateUtil.java

License:Open Source License

@Deprecated
@SuppressWarnings("unchecked")
public static List<ComplexRule> getAllOtherPublishedComplexRules(String userID) {
    Session session = getSessionFactory().getCurrentSession();
    session.beginTransaction();/*from   ww  w .  j  ava2s .co  m*/
    Criteria crit = session.createCriteria(ComplexRule.class);
    Criterion isOwner = Restrictions.not(Restrictions.eq(OWNER_ID, valueOf(userID)));
    SimpleExpression isPublished = Restrictions.eq(PUBLISHED, true);
    List<ComplexRule> rules = crit.add(Restrictions.and(isOwner, isPublished)).list();
    session.getTransaction().commit();
    return rules;
}