Example usage for org.hibernate.criterion Restrictions gt

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

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

Introduction

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

Prototype

public static SimpleExpression gt(String propertyName, Object value)

Source Link

Document

Apply a "greater than" constraint to the named property

Usage

From source file:com.inkubator.hrm.dao.impl.EmpDataDaoImpl.java

@Override
public Long getTotalByAgeBetween(Date startDate, Date endDate) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    /**//w  w w  .ja  v a  2s  .  c om
     * automatically get relations of jabatanByJabatanId, department,
     * company don't create alias for that entity, or will get error :
     * duplicate association path
     */
    criteria = this.addJoinRelationsOfCompanyId(criteria, HrmUserInfoUtil.getCompanyId());
    criteria.add(Restrictions.neOrIsNotNull("status", HRMConstant.EMP_TERMINATION));

    criteria.createAlias("bioData", "bioData", JoinType.INNER_JOIN);
    criteria.add(Restrictions.gt("bioData.dateOfBirth", startDate));
    criteria.add(Restrictions.lt("bioData.dateOfBirth", endDate));
    return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
}

From source file:com.inkubator.hrm.dao.impl.EmpDataDaoImpl.java

@Override
public Long getTotalByAgeMoreThan(Date date) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    /**//from   w ww .j  a  va2 s  .c  o m
     * automatically get relations of jabatanByJabatanId, department,
     * company don't create alias for that entity, or will get error :
     * duplicate association path
     */
    criteria = this.addJoinRelationsOfCompanyId(criteria, HrmUserInfoUtil.getCompanyId());
    criteria.add(Restrictions.neOrIsNotNull("status", HRMConstant.EMP_TERMINATION));

    criteria.createAlias("bioData", "bioData", JoinType.INNER_JOIN);
    criteria.add(Restrictions.gt("bioData.dateOfBirth", date));
    return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
}

From source file:com.inkubator.hrm.dao.impl.SystemScoringIndexDaoImpl.java

@Override
public List<SystemScoringIndex> getAllDataBySystemScoringIdAndGreaterOrderScala(Long systemScoringId,
        int orderScala) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.add(Restrictions.eq("systemScoring.id", systemScoringId));
    criteria.add(Restrictions.gt("orderScala", orderScala));
    return criteria.list();
}

From source file:com.isotrol.impe3.oi.dao.impl.OIDAOImpl.java

License:Open Source License

private Criteria getInterviewCountCriteria(PageFilter<InterviewFilterDTO> filter) {
    Criteria c = newCriteria(InterviewEntity.class);
    c.add(Restrictions.eq("deleted", Boolean.FALSE));

    c = FilterSupport.or(c, "title", filter.getFilter().getTitle(), "author", filter.getFilter().getAuthor(),
            "interviewee", filter.getFilter().getInterviewee(), "description",
            filter.getFilter().getDescription());

    if (filter.getFilter().isActive() == null) {
        // nothing to do.
    } else if (filter.getFilter().isActive().intValue() < 0) {
        // released
    } else if (filter.getFilter().isActive() == 0) {
        // true released and not expired
        c.add(Restrictions.or(Restrictions.isNull("expiration"),
                Restrictions.gt("expiration", Calendar.getInstance())));
        c.add(Restrictions.le("release", Calendar.getInstance()));
    } else {//  w  ww.j  a  va2 s. c o  m
        // expired
        c.add(Restrictions.or(
                Restrictions.or(Restrictions.isNull("release"),
                        Restrictions.gt("release", Calendar.getInstance())),
                Restrictions.le("expiration", Calendar.getInstance())));
    }

    c.createAlias("classes", "c", Criteria.LEFT_JOIN);

    return c;
}

From source file:com.isotrol.impe3.web20.dao.impl.DAOImpl.java

License:Open Source License

/**
 * Create a new criteria for community notices
 * @param filter Community notices filter.
 * @return The created criteria./*w ww .jav a2 s  .c  om*/
 */
private Criteria getNoticeCriteria(NoticeFilterDTO filter) {
    Criteria c = newCriteria(NoticeEntity.class);
    c.add(Restrictions.eq("community.id", filter.getCommunityId()));
    c.add(Restrictions.eq("deleted", false));

    if (filter.getTitle() != null && filter.getDescription() != null) {
        c.add(Restrictions.or(FilterSupport.criterion("title", filter.getTitle()),
                FilterSupport.criterion("description", filter.getDescription())));
    } else if (filter.getTitle() != null || filter.getDescription() != null) {
        FilterSupport.add(c, "title", filter.getTitle());
        FilterSupport.add(c, "description", filter.getDescription());
    }

    if (filter.isActive() == null) {
        // nothing, return all.
    } else if (filter.isActive()) {
        // true released and not expired
        c.add(Restrictions.or(Restrictions.isNull("expiration"),
                Restrictions.gt("expiration", Calendar.getInstance())));
        c.add(Restrictions.le("release", Calendar.getInstance()));
    } else {
        // false not released or expired
        c.add(Restrictions.or(
                Restrictions.or(Restrictions.isNull("release"),
                        Restrictions.gt("release", Calendar.getInstance())),
                Restrictions.le("expiration", Calendar.getInstance())));
    }
    return c;
}

From source file:com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateFilter.java

License:Open Source License

public void applyPropertyFilter(PropertyFilter filter) {
    Criterion propCriterion;/*  w  ww . j a va 2  s.c  o  m*/
    switch (filter.getOp()) {
    case PropertyFilter.EQ:
        propCriterion = Restrictions.eq(filter.getProperty(), filter.getValue());
        break;
    case PropertyFilter.LIKE:
        propCriterion = Restrictions.like(filter.getProperty(), filter.getValue());
        break;
    case PropertyFilter.GT:
        propCriterion = Restrictions.gt(filter.getProperty(), filter.getValue());
        break;
    case PropertyFilter.LT:
        propCriterion = Restrictions.lt(filter.getProperty(), filter.getValue());
        break;
    case PropertyFilter.BETWEEN:
        propCriterion = Restrictions.between(filter.getProperty(), filter.getLowValue(), filter.getHighValue());
        break;
    case PropertyFilter.IN:
        propCriterion = Restrictions.in(filter.getProperty(), filter.getValues());
        break;
    default:
        throw new JSException("jsexception.hibernate.unknown.property.filter.operation",
                new Object[] { new Byte(filter.getOp()) });
    }
    add(propCriterion);
}

From source file:com.jaspersoft.jasperserver.search.filter.TimeFilter.java

License:Open Source License

public void applyRestrictions(String type, ExecutionContext context, SearchCriteria criteria) {
    SearchAttributes searchAttributes = getSearchAttributes(context);

    if (searchAttributes != null && searchAttributes.getState() != null) {
        String timeFilter = searchAttributes.getState().getCustomFiltersMap().get("timeFilter");
        if (timeFilter != null && !timeFilter.equals("timeFilter-anyTime")) {
            Calendar cal = Calendar.getInstance();

            if (timeFilter.equals("timeFilter-today")) {
                cal.setTime(new Date());
                resetDateTime(cal);//from   w  w  w .j a  v  a2 s .com
                Date startDate = cal.getTime();

                criteria.add(Restrictions.gt("updateDate", startDate));
            } else if (timeFilter.equals("timeFilter-yesterday")) {
                cal.setTime(new Date());
                resetDateTime(cal);
                Date endDate = cal.getTime();

                cal.setTime(rollDay(new Date(), -1));
                resetDateTime(cal);
                Date startDate = cal.getTime();

                criteria.add(Restrictions.between("updateDate", startDate, endDate));
            } else if (timeFilter.equals("timeFilter-pastWeek")) {
                cal.setTime(new Date());
                cal.setTime(rollDay(new Date(), -7));
                resetDateTime(cal);
                Date startDate = cal.getTime();

                criteria.add(Restrictions.gt("updateDate", startDate));
            } else if (timeFilter.equals("timeFilter-pastMonth")) {
                cal.setTime(new Date());
                cal.setTime(rollDay(new Date(), -30));
                resetDateTime(cal);
                Date startDate = cal.getTime();

                criteria.add(Restrictions.gt("updateDate", startDate));
            }
        }
    }
}

From source file:com.jeroensteenbeeke.hyperion.data.Expression.java

License:Open Source License

public static <T extends Comparable<T> & Serializable> Expression<T> greaterThan(final String property,
        T value) {//from  w  w w . j  a v  a2s .com
    return new Expression<T>(value) {
        private static final long serialVersionUID = 1L;

        @Override
        public void decorateCriteria(Criteria criteria) {
            criteria.add(Restrictions.gt(property, getValue()));
        }

        @SuppressWarnings("unchecked")
        @Override
        public boolean retain(Object object) {
            T objectValue = (T) Reflector.invokeGetter(object, property);

            return objectValue.compareTo(getValue()) > 0;
        }
    };
}

From source file:com.jeysan.modules.orm.hibernate.HibernateDao.java

License:Apache License

/**
 * ??Criterion,.//from w w  w  .  j  a  v  a 2s  .  co  m
 */
protected Criterion buildCriterion(final String propertyName, final Object propertyValue,
        final MatchType matchType) {
    Assert.hasText(propertyName, "propertyName?");
    Criterion criterion = null;
    //?MatchTypecriterion
    switch (matchType) {
    case EQ:
        criterion = Restrictions.eq(propertyName, propertyValue);
        break;
    case NEQ:
        if (propertyValue == null)
            criterion = Restrictions.isNotNull(propertyName);
        else
            criterion = Restrictions.not(Restrictions.eq(propertyName, propertyValue));
        break;
    case NULL:
        criterion = Restrictions.isNull(propertyName);
        break;
    case LIKE:
        criterion = Restrictions.like(propertyName, (String) propertyValue, MatchMode.ANYWHERE);
        break;

    case LE:
        criterion = Restrictions.le(propertyName, propertyValue);
        break;
    case LT:
        criterion = Restrictions.lt(propertyName, propertyValue);
        break;
    case GE:
        criterion = Restrictions.ge(propertyName, propertyValue);
        break;
    case GT:
        criterion = Restrictions.gt(propertyName, propertyValue);
    }
    return criterion;
}

From source file:com.jfootball.dao.hibernate.DivisionDaoImpl.java

License:Open Source License

/**
 * hibernateTemplate.find("from Division d order by d.id").list()
 * //from  ww  w .  ja  v a  2 s .  c o m
 * @see com.jfootball.dao.DivisionDao#listDivisions()
 */
@SuppressWarnings("unchecked")
public List<Division> listDivisions() {
    Session session = hibernateTemplate.getSessionFactory().getCurrentSession();
    Criteria criteria = session.createCriteria(Division.class);
    criteria.add(Restrictions.gt("level", new Long(0)));
    criteria.addOrder(Order.asc("id"));
    return criteria.list();
}