Example usage for org.hibernate.criterion Restrictions le

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

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

Introduction

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

Prototype

public static SimpleExpression le(String propertyName, Object value)

Source Link

Document

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

Usage

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

@Override
public List<TempJadwalKaryawan> getAllDataByEmpIdAndPeriodDate(Long empDataId, Date startDate, Date endDate) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.add(Restrictions.eq("empData.id", empDataId));
    criteria.add(Restrictions.ge("tanggalWaktuKerja", startDate));
    criteria.add(Restrictions.le("tanggalWaktuKerja", endDate));
    return criteria.list();
}

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

@Override
public List<TempJadwalKaryawan> getAllDataByEmpIdAndPeriodDateAndNotOffDay(Long empDataId, Date startDate,
        Date endDate) {//from w  w w .  ja  v a 2  s  . com

    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) {/*  w w w .  j a v a  2s  .  c  o m*/
    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 ww .ja va 2 s  .co  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.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) {/*  w  w  w  .j  av a2  s. c o m*/
    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.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 {//from w ww  .  j a  va 2s .co  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

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 {//from ww  w.jav a 2s .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.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.//from w ww .j a  v a 2  s.c  o  m
 */
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;
}