Example usage for org.hibernate.criterion Restrictions ge

Introduction

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

Prototype

public static SimpleExpression ge(String propertyName, Object value)

Source Link

Document

Apply a "greater than or equal" constraint to the named property

Usage

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

@Override
public List<TempJadwalKaryawan> getAllDataByEmpIdAndPeriodDateAndNotOffDay(Long empDataId, Date startDate,
        Date endDate) {//  w  ww. ja  v  a2s. c o m

    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.add(Restrictions.eq("empData.id", empDataId));
    criteria.add(Restrictions.ge("tanggalWaktuKerja", startDate));
    criteria.add(Restrictions.le("tanggalWaktuKerja", endDate));
    criteria.createAlias("wtWorkingHour", "wtWorkingHour", JoinType.INNER_JOIN);
    criteria.add(Restrictions.ne("wtWorkingHour.code", "OFF"));
    return criteria.list();
}

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

@Override
public List<TempJadwalKaryawan> getAllByEmpIdWithDetailWithFromAndUntilPeriod(long empId, Date from,
        Date until) {//from w ww  .j  a  va  2 s . com
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.createAlias("empData", "e", JoinType.INNER_JOIN);
    criteria.add(Restrictions.eq("e.id", empId));
    criteria.add(Restrictions.ge("tanggalWaktuKerja", from));
    criteria.add(Restrictions.le("tanggalWaktuKerja", until));
    criteria.setFetchMode("wtWorkingHour.attendanceStatus", FetchMode.JOIN);
    criteria.setFetchMode("wtWorkingHour", FetchMode.JOIN);
    criteria.addOrder(Order.asc("tanggalWaktuKerja"));
    return criteria.list();
}

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

@Override
public List<TempJadwalKaryawan> getAllDataByEmpIdAndPeriodDateAndOffDay(Long empDataid, Date startDate,
        Date endDate) {//w  w w . j  a  v  a 2  s. c om
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.add(Restrictions.eq("empData.id", empDataid));
    criteria.add(Restrictions.ge("tanggalWaktuKerja", startDate));
    criteria.add(Restrictions.le("tanggalWaktuKerja", endDate));
    criteria.createAlias("wtWorkingHour", "wtWorkingHour", JoinType.INNER_JOIN);
    criteria.add(Restrictions.eq("wtWorkingHour.code", "OFF"));
    return criteria.list();
}

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

@Override
public List<WtHoliday> getListPublicNonReligionHolidayBetweenDate(Date start, Date end) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.setFetchMode("religion", FetchMode.JOIN);
    criteria.add(Restrictions.ge("holidayDate", start));
    criteria.add(Restrictions.le("holidayDate", end));
    criteria.add(Restrictions.isNull("religion"));

    return criteria.list();
}

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

@Override
public List<WtHoliday> getListPublicReligionHolidayByReligionCodeAndBetweenDate(Date start, Date end,
        String religionCode) {//from   ww  w. j a v  a 2  s . c om
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    //criteria.setFetchMode("religion", FetchMode.JOIN);
    criteria.createAlias("religion", "religion", JoinType.INNER_JOIN);
    criteria.add(Restrictions.isNotNull("religion"));
    criteria.add(Restrictions.ge("holidayDate", start));
    criteria.add(Restrictions.le("holidayDate", end));
    criteria.add(Restrictions.eq("religion.code", religionCode));

    return criteria.list();
}

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

@Override
public WtPeriode getEntityByDateBetween(Date date) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.add(Restrictions.le("fromPeriode", date));
    criteria.add(Restrictions.ge("untilPeriode", date));
    return (WtPeriode) criteria.uniqueResult();
}

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

License:Open Source License

private Criteria getCommentCriteria(CommentInternalFilterDTO filter) {
    Criteria c = newCriteria(CommentEntity.class);
    c.add(Restrictions.eq("deleted", Boolean.FALSE));

    if (filter.isValid() != null) {
        if (filter.isValid()) {
            c.add(Restrictions.eq("valid", Boolean.TRUE));
        } else {/* w w w .  j  a va2  s.  com*/
            c.add(Restrictions.eq("valid", Boolean.FALSE));
        }
    }

    if (filter.isModerated() != null) {
        if (filter.isModerated()) {
            c.add(Restrictions.isNotNull("lastModeration"));
        } else {
            c.add(Restrictions.isNull("lastModeration"));
        }
    }

    if (filter.getRelationship() != null) {
        c.createAlias("relationship", "rs", Criteria.LEFT_JOIN);
        c.add(Restrictions.eq("rs.id", filter.getRelationship()));
    }

    final Calendar dateInit = Calendar.getInstance();
    final Calendar dateEnd = Calendar.getInstance();

    if (filter.getLowDate() != null && filter.getHighDate() != null) {
        dateInit.setTime(filter.getLowDate());
        dateEnd.setTime(filter.getHighDate());
        c.add(Restrictions.between("date", dateInit, dateEnd));
    } else if (filter.getLowDate() != null) {
        dateInit.setTime(filter.getLowDate());
        c.add(Restrictions.ge("date", dateInit));
    } else if (filter.getHighDate() != null) {
        dateEnd.setTime(filter.getHighDate());
        c.add(Restrictions.le("date", dateEnd));
    }

    return c;
}

From source file:com.ivanbiz.dao.impl.KelasDAOImpl.java

@Override
public List getData(Date start, Date end) throws Exception {
    List list = null;// www  .  ja v a  2s.  com
    try {
        Session session = HibernateUtil.getSession();
        HibernateUtil.beginTransaction();
        start.setHours(0);
        start.setMinutes(0);
        start.setSeconds(0);
        end.setHours(0);
        end.setMinutes(0);
        end.setSeconds(0);
        Criteria crit = session.createCriteria(Kelas.class).add(Restrictions.ge("tanggalKelas", start))
                .add(Restrictions.le("tanggalKelas", end)).addOrder(Order.asc("pengajar.id"))
                .addOrder(Order.asc("tanggalKelas"));
        list = crit.list();
        HibernateUtil.commitTransaction();
    } catch (Exception e) {
        HibernateUtil.rollbackTransaction();
        throw e;
    } finally {
        HibernateUtil.closeSession();
    }
    return list;
}

From source file:com.ivanbiz.dao.impl.KelasDAOImpl.java

@Override
public List getData(Pengajar pengajar, Date start, Date end) throws Exception {
    List list = null;/* ww w  .  ja v a  2 s .  co m*/
    try {
        Session session = HibernateUtil.getSession();
        HibernateUtil.beginTransaction();
        start.setHours(0);
        start.setMinutes(0);
        start.setSeconds(0);
        end.setHours(0);
        end.setMinutes(0);
        end.setSeconds(0);
        Criteria crit = session.createCriteria(Kelas.class)
                .add(Restrictions.eq("pengajar.id", pengajar.getId()))
                .add(Restrictions.ge("tanggalKelas", start)).add(Restrictions.le("tanggalKelas", end));
        list = crit.list();
        HibernateUtil.commitTransaction();
    } catch (Exception e) {
        HibernateUtil.rollbackTransaction();
        throw e;
    } finally {
        HibernateUtil.closeSession();
    }
    return list;
}

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

License:Open Source License

public static <T extends Comparable<T> & Serializable> Expression<T> greaterThanOrEquals(final String property,
        T value) {//from  w w  w  .  ja va 2s. c  om
    return new Expression<T>() {
        private static final long serialVersionUID = 1L;

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

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

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

    };
}