Example usage for org.hibernate.criterion Restrictions isNotNull

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

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

Introduction

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

Prototype

public static Criterion isNotNull(String propertyName)

Source Link

Document

Apply an "is not null" constraint to the named property

Usage

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

private void doSearchByParam(SchedulerLogSearchParameter searchParameter, Criteria criteria) {
    criteria.createAlias("schedulerConfig", "schedulerConfig", JoinType.INNER_JOIN);
    if (StringUtils.isNotEmpty(searchParameter.getName())) {
        criteria.add(Restrictions.eq("schedulerConfig.name", searchParameter.getName()));
    }/*from   ww  w. j  a v a2 s.  c o m*/
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchSystemLetterReferenceByParam(SystemLetterReferenceSearchParameter parameter,
        Criteria criteria) {//  ww  w .ja v a2s. c o m
    if (parameter.getLetterSumary() != null) {
        criteria.add(Restrictions.like("letterSumary", parameter.getLetterSumary(), MatchMode.ANYWHERE));
    }
    if (parameter.getName() != null) {
        criteria.add(Restrictions.like("name", parameter.getName(), MatchMode.ANYWHERE));
    }
    if (parameter.getCode() != null) {
        criteria.add(Restrictions.like("code", parameter.getCode(), MatchMode.ANYWHERE));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchByParam(SystemScoringSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getName() != null) {
        criteria.add(Restrictions.like("name", searchParameter.getName(), MatchMode.START));
    }/*from  ww  w  . j  av a2 s  . c  o m*/
    if (searchParameter.getCode() != null) {
        criteria.add(Restrictions.like("code", searchParameter.getCode(), MatchMode.START));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchTempAttendanceRealizationByParam(TempAttendanceRealizationSearchParameter parameter,
        Criteria criteria) {//w  ww . ja  v a 2  s . c o  m
    if (parameter.getJabatan() != null) {
        criteria.createAlias("empData", "ce", JoinType.INNER_JOIN);
        criteria.createAlias("ce.jabatanByJabatanId", "jb", JoinType.INNER_JOIN);
        criteria.add(Restrictions.like("jb.name", parameter.getJabatan(), MatchMode.ANYWHERE));
    }

    if (parameter.getName() != null) {
        criteria.createAlias("empData", "ce", JoinType.INNER_JOIN);
        criteria.createAlias("ce.bioData", "bio", JoinType.INNER_JOIN);
        criteria.add(
                Restrictions.ilike("bio.combineName", parameter.getName().toLowerCase(), MatchMode.ANYWHERE));
    }
    if (parameter.getNik() != null) {
        criteria.createAlias("empData", "ce", JoinType.INNER_JOIN);
        criteria.add(Restrictions.like("ce.nik", parameter.getNik(), MatchMode.ANYWHERE));

    }
    if (parameter.getNoJab() != null) {
        criteria.createAlias("empData", "ce", JoinType.INNER_JOIN);
        criteria.createAlias("ce.jabatanByJabatanId", "jb", JoinType.INNER_JOIN);
        criteria.add(Restrictions.like("jb.code", parameter.getNoJab(), MatchMode.ANYWHERE));

    }
    criteria.add(Restrictions.isNotNull("id"));

}

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

private void doSearchPaidOvertimeByParam(PaidOvertimeSearchParameter searchParameter, Criteria criteria) {
    criteria.createAlias("empData", "empData", JoinType.INNER_JOIN);
    criteria.createAlias("empData.bioData", "bioData", JoinType.INNER_JOIN);

    if (StringUtils.isNotBlank(searchParameter.getEmpName())) {
        Disjunction disjunctionName = Restrictions.disjunction();
        disjunctionName/*  ww  w. j  a va  2s. c om*/
                .add(Restrictions.like("bioData.firstName", searchParameter.getEmpName(), MatchMode.ANYWHERE));
        disjunctionName
                .add(Restrictions.like("bioData.middleName", searchParameter.getEmpName(), MatchMode.ANYWHERE));
        disjunctionName
                .add(Restrictions.like("bioData.lastName", searchParameter.getEmpName(), MatchMode.ANYWHERE));
        criteria.add(disjunctionName);
    }

    if (StringUtils.isNotBlank(searchParameter.getNik())) {
        criteria.add(Restrictions.like("empData.nik", searchParameter.getNik(), MatchMode.ANYWHERE));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchByParam(UnregSalarySearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getName() != null) {
        criteria.add(Restrictions.like("name", searchParameter.getName(), MatchMode.ANYWHERE));
    }/*from  w ww.j  a va 2s  . c om*/
    if (searchParameter.getCode() != null) {
        criteria.add(Restrictions.like("code", searchParameter.getCode(), MatchMode.ANYWHERE));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearch(WtFingerExceptionSearchParameter searchParameter, Criteria criteria) {
    criteria.createAlias("empData", "empData", JoinType.INNER_JOIN);
    criteria.createAlias("empData.bioData", "bioData", JoinType.INNER_JOIN);
    criteria.createAlias("empData.jabatanByJabatanId", "jabatanByJabatanId", JoinType.INNER_JOIN);

    if (StringUtils.isNotEmpty(searchParameter.getEmpData())) {
        Disjunction disjunction = Restrictions.disjunction();
        disjunction.add(Restrictions.like("bioData.firstName", searchParameter.getEmpData(), MatchMode.START));
        disjunction.add(Restrictions.like("bioData.lastName", searchParameter.getEmpData(), MatchMode.START));
        criteria.add(disjunction);/*from  w  w  w .ja v a 2s.  c  o  m*/
    }
    if (searchParameter.getNik() != null) {
        criteria.add(Restrictions.like("empData.nik", searchParameter.getNik(), MatchMode.START));
    }
    if (searchParameter.getNamaJabatan() != null) {
        criteria.add(Restrictions.like("jabatanByJabatanId.name", searchParameter.getNamaJabatan(),
                MatchMode.ANYWHERE));
    }
    if (searchParameter.getCodeJabatan() != null) {
        criteria.add(Restrictions.like("jabatanByJabatanId.code", searchParameter.getCodeJabatan(),
                MatchMode.START));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchWtHolidayByParam(HolidaySearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getReligionName() != null && !searchParameter.getReligionName().isEmpty()) {
        criteria.createAlias("religion", "r");
        criteria.add(Restrictions.like("r.name", searchParameter.getReligionName(), MatchMode.START));
    }//from ww w  .  ja v  a2 s .  c o  m

    if (searchParameter.getHolidayName() != null && !searchParameter.getHolidayName().isEmpty()) {
        criteria.add(Restrictions.like("holidayName", searchParameter.getHolidayName(), MatchMode.START));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

@Override
public List<WtHoliday> getListPublicReligionHolidayByReligionCodeAndBetweenDate(Date start, Date end,
        String religionCode) {//from  w  ww . j  av a  2 s  . co  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

private void doSearchWtPeriodeByParam(WtPeriodeSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getTahun() != null) {
        criteria.add(Restrictions.like("tahun", searchParameter.getTahun(), MatchMode.START));
    }/*www .j a  v a 2s  .co m*/

    if (searchParameter.getBulan() != null && searchParameter.getBulan() != 0) {
        criteria.add(Restrictions.eq("bulan", searchParameter.getBulan()));
    }
    criteria.add(Restrictions.isNotNull("id"));
}