Example usage for org.hibernate.criterion Restrictions ne

Introduction

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

Prototype

public static SimpleExpression ne(String propertyName, Object value)

Source Link

Document

Apply a "not equal" constraint to the named property

Usage

From source file:org.gaixie.micrite.river.dao.hibernate.RiverDAOImpl.java

@SuppressWarnings("unchecked")
public List<River> advancedFindByPerPage(SearchBean[] queryBean, int start, int limit) {
    DetachedCriteria criteria = SearchFactory.generateCriteria(River.class, queryBean);
    criteria.add(Restrictions.ne("id", SYS_RECORD_ID));
    criteria.add(Expression.eq("status", IRiverService.STATUS_NORMAL));
    criteria.addOrder(Order.desc("modifydate"));
    return getHibernateTemplate().findByCriteria(criteria, start, limit);
}

From source file:org.gaixie.micrite.river.dao.hibernate.RiverDAOImpl.java

public int advancedFindCount(SearchBean[] queryBean) {
    DetachedCriteria criteria = SearchFactory.generateCriteria(River.class, queryBean);
    criteria.add(Restrictions.ne("id", SYS_RECORD_ID));
    criteria.add(Expression.eq("State", IRiverService.STATUS_NORMAL));
    criteria.setProjection(Projections.rowCount());
    return (Integer) getHibernateTemplate().findByCriteria(criteria).get(0);
}

From source file:org.gaixie.micrite.river.dao.hibernate.RiverDAOImpl.java

public int findByCreateDateSpacingCount(Date startDate, Date endDate, int RiverSourceType) {
    DetachedCriteria criteria = DetachedCriteria.forClass(River.class);
    //        criteria.createAlias("riverSource8", "cs");
    //        if(0!=RiverSourceType){
    //            criteria.add(Expression.eq("cs.id", RiverSourceType));
    //        }/* www.j  a va 2  s  .c  o m*/
    criteria.add(Expression.between("begindate", startDate, endDate));
    criteria.add(Restrictions.ne("id", 1));
    criteria.setProjection(Projections.rowCount());
    return (Integer) getHibernateTemplate().findByCriteria(criteria).get(0);
}

From source file:org.gaixie.micrite.river.dao.hibernate.RiverDAOImpl.java

@SuppressWarnings("unchecked")
public List findCSGroupByTelVague(SearchBean[] queryBean) {
    DetachedCriteria criteria = SearchFactory.generateCriteria(River.class, queryBean);
    criteria.add(Restrictions.ne("id", SYS_RECORD_ID));
    criteria.createAlias("village", "cs");
    criteria.setProjection(Projections.projectionList().add(Projections.count("cs.vname"))
            .add(Projections.groupProperty("cs.vname")));
    return getHibernateTemplate().findByCriteria(criteria);
}

From source file:org.gaixie.micrite.river.dao.hibernate.RiverDAOImpl.java

@Override
public boolean existRiver(Integer id, String license) {
    // TODO Auto-generated method stub
    DetachedCriteria criteria = DetachedCriteria.forClass(River.class);
    criteria.add(Expression.eq("State", IRiverService.STATUS_NORMAL));
    criteria.setProjection(Projections.rowCount());
    criteria.add(Restrictions.ne("id", SYS_RECORD_ID));
    criteria.add(Expression.eq("rid", license));
    if (id != null) {
        criteria.add(Expression.ne("id", id));
    }/*ww w  .j  av  a  2s .  c  o  m*/
    return ((Integer) getHibernateTemplate().findByCriteria(criteria).get(0)) > 0;
}

From source file:org.generationcp.middleware.dao.dms.DmsProjectDao.java

License:Open Source License

private Criteria buildCoreCriteria(final Map<StudyFilters, String> parameters, final Order orderBy) {
    final Criteria criteria = this.getSession().createCriteria(this.getPersistentClass());
    criteria.add(Restrictions.isNotNull("studyType"));

    criteria.add(Restrictions.ne(DmsProjectDao.DELETED, true));

    if (parameters.containsKey(StudyFilters.PROGRAM_ID)) {
        criteria.add(Restrictions.eq(StudyFilters.PROGRAM_ID.getParameter(),
                parameters.get(StudyFilters.PROGRAM_ID)));
    } else {//from   www  .  j a v  a2 s  . co  m
        criteria.add(Restrictions.isNotNull(StudyFilters.PROGRAM_ID.getParameter()));
    }

    if (parameters.containsKey(StudyFilters.LOCATION_ID)) {
        // Find environments with specified location (saved in GeolocationProperty)
        final DetachedCriteria locationCriteria = DetachedCriteria.forClass(ExperimentModel.class);
        locationCriteria.add(Restrictions.eq("typeId", TermId.TRIAL_ENVIRONMENT_EXPERIMENT.getId()));
        locationCriteria.createAlias("geoLocation", "g");
        locationCriteria.createAlias("g.properties", "gp");
        locationCriteria.createAlias("project", "p");
        locationCriteria.createAlias("p.study", "st");
        locationCriteria.add(Restrictions.and(Restrictions.eq("gp.typeId", DmsProjectDao.LOCATION_ID),
                Restrictions.eq("gp.value", parameters.get(StudyFilters.LOCATION_ID))));
        locationCriteria.setProjection(Projections.property("st.projectId"));
        criteria.add(Property.forName("projectId").in(locationCriteria));
    }

    criteria.addOrder(orderBy);
    return criteria;
}

From source file:org.generationcp.middleware.dao.GermplasmDAO.java

License:Open Source License

public List<Germplasm> getPreviousCrosses(final Germplasm currentCross, final Germplasm female,
        final Germplasm male) {
    try {/* w  w w  . j  a v  a 2 s .  co  m*/
        final DetachedCriteria criteria = DetachedCriteria.forClass(Germplasm.class);

        // (female x male) is not the same as (male x female) so the order is important.
        criteria.add(Restrictions.eq("gpid1", female.getGid()));
        criteria.add(Restrictions.eq("gpid2", male.getGid()));
        // Restrict to cases where two parents are involved.
        criteria.add(Restrictions.eq("gnpgs", 2));
        // = Record is unchanged.
        criteria.add(Restrictions.eq(GermplasmDAO.GRPLCE, 0));
        // Exclude current cross. We are finding "previous" crosses.
        criteria.add(Restrictions.ne("gid", currentCross.getGid()));
        // = Record is not or replaced.
        criteria.add(Restrictions.eq(GermplasmDAO.DELETED, Boolean.FALSE));
        // Oldest created cross will be first in list.
        criteria.addOrder(Order.asc("gid"));

        @SuppressWarnings("unchecked")
        final List<Germplasm> previousCrosses = criteria.getExecutableCriteria(this.getSession()).list();
        return previousCrosses;
    } catch (final HibernateException e) {
        final String message = "Error executing GermplasmDAO.getPreviousCrosses(female = {}, male = {}): {}";
        GermplasmDAO.LOG.error(message, female, male, e.getMessage());
        throw new MiddlewareQueryException(message, e);
    }
}

From source file:org.generationcp.middleware.dao.GermplasmListDAO.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<GermplasmList> getAllExceptDeleted(final int start, final int numOfRows) {
    try {//from  ww w.  jav  a 2s  .c  o  m
        final Criteria criteria = this.getSession().createCriteria(GermplasmList.class);
        criteria.add(Restrictions.ne(GermplasmListDAO.STATUS, GermplasmListDAO.STATUS_DELETED));

        this.hideSnapshotListTypes(criteria);

        criteria.setFirstResult(start);
        criteria.setMaxResults(numOfRows);
        return criteria.list();
    } catch (final HibernateException e) {
        final String errorMessage = "Error with getAllExceptDeleted() query from GermplasmList: "
                + e.getMessage();
        GermplasmListDAO.LOG.error(errorMessage);
        throw new MiddlewareQueryException(errorMessage, e);
    }
}

From source file:org.generationcp.middleware.dao.GermplasmListDAO.java

License:Open Source License

public long countAllExceptDeleted() {
    try {//from  ww w.  ja v a 2s .  c o  m
        final Criteria criteria = this.getSession().createCriteria(GermplasmList.class);
        criteria.add(Restrictions.ne(GermplasmListDAO.STATUS, GermplasmListDAO.STATUS_DELETED));

        this.hideSnapshotListTypes(criteria);

        criteria.setProjection(Projections.rowCount());
        final Long count = (Long) criteria.uniqueResult();

        if (count == null) {
            return 0;
        }
        return count.longValue();
    } catch (final HibernateException e) {
        final String errorMessage = "Error with countAllExceptDeleted() query from GermplasmList: "
                + e.getMessage();
        GermplasmListDAO.LOG.error(errorMessage);
        throw new MiddlewareQueryException(errorMessage, e);
    }
}

From source file:org.generationcp.middleware.dao.GermplasmListDAO.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<GermplasmList> getByGID(final Integer gid, final int start, final int numOfRows) {
    try {/*from w w  w  .  j  a v a2  s . com*/
        if (gid != null) {
            final Criteria criteria = this.getSession().createCriteria(GermplasmListData.class);
            criteria.createAlias("list", "l");
            criteria.setProjection(Projections.distinct(Projections.property("list")));
            criteria.add(Restrictions.eq("gid", gid));
            criteria.add(Restrictions.ne("l.status", GermplasmListDAO.STATUS_DELETED));

            criteria.setFirstResult(start);
            criteria.setMaxResults(numOfRows);
            criteria.addOrder(Order.asc("l.id"));
            criteria.addOrder(Order.asc("entryId"));
            return criteria.list();
        }
    } catch (final HibernateException e) {
        final String errorMessage = "Error with getByGid(gid=" + gid + ") query from GermplasmList: "
                + e.getMessage();
        GermplasmListDAO.LOG.error(errorMessage);
        throw new MiddlewareQueryException(errorMessage, e);
    }
    return new ArrayList<>();
}