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.PayTempKalkulasiDaoImpl.java

@Override
public List<PayTempKalkulasi> getAllDataByEmpDataIdAndTaxNotNull(Long empDataId) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.createAlias("paySalaryComponent", "paySalaryComponent", JoinType.INNER_JOIN);
    criteria.createAlias("paySalaryComponent.taxComponent", "taxComponent", JoinType.INNER_JOIN);
    criteria.add(Restrictions.eq("empData.id", empDataId));
    criteria.add(Restrictions.isNotNull("paySalaryComponent.taxComponent"));
    criteria.addOrder(Order.desc("taxComponent.id"));
    return criteria.list();
}

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

public void doSearchByParam(String searchParameter, Criteria criteria, Long taxComponentId) {
    criteria.createAlias("taxComponent", "taxComponent", JoinType.INNER_JOIN);
    criteria.createAlias("empData", "empData", JoinType.INNER_JOIN);
    criteria.createAlias("empData.bioData", "bioData", JoinType.INNER_JOIN);
    criteria.add(Restrictions.eq("taxComponent.id", taxComponentId));
    if (StringUtils.isNotEmpty(searchParameter)) {
        Disjunction disjunction = Restrictions.disjunction();
        disjunction.add(Restrictions.like("empData.nik", searchParameter, MatchMode.ANYWHERE));
        disjunction.add(Restrictions.like("bioData.firstName", searchParameter, MatchMode.ANYWHERE));
        disjunction.add(Restrictions.like("bioData.lastName", searchParameter, MatchMode.ANYWHERE));
        criteria.add(disjunction);/*from w  w  w . j  a  va2s. co  m*/
        //            criteria.add(Restrictions.like("bioData.firstName", parameter, MatchMode.ANYWHERE));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchByParam(PayTempOvertimeSearchParameter searchParameter, Criteria criteria) {
    criteria.createAlias("empData", "empData", JoinType.INNER_JOIN);
    criteria.createAlias("empData.bioData", "bioData", JoinType.INNER_JOIN);
    if (searchParameter.getEmployeeName() != null) {
        //            criteria.add(Restrictions.like("bioData.firstName", searchParameter.getEmployeeName(), MatchMode.ANYWHERE));
        criteria.add(Restrictions.ilike("bioData.combineName", searchParameter.getEmployeeName().toLowerCase(),
                MatchMode.ANYWHERE));//from   ww w . ja v  a2 s  .c  o m
    }
    if (searchParameter.getNim() != null) {
        criteria.add(Restrictions.like("empData.nik", searchParameter.getNim(), MatchMode.START));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchByParam(RecruitAdvertisementCategorySearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getName() != null) {
        criteria.add(Restrictions.like("name", searchParameter.getName(), MatchMode.START));
    }//from www  .j  av a  2 s.co 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.RecruitAdvertisementMediaDaoImpl.java

private void doSearchByParam(RecruitAdvertisementMediaSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getName() != null) {
        criteria.add(Restrictions.like("name", searchParameter.getName(), MatchMode.START));
    }//from  ww w .  j  a  va2 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.RecruitLettersDaoImpl.java

private void doSearchRecruitLettersByParam(RecrutimentLetterSearchParameter parameter, Criteria criteria) {
    if (StringUtils.isNotEmpty(parameter.getSelectionType())) {
        criteria.createAlias("recruitLetterSelections", "rs", JoinType.INNER_JOIN);
        criteria.createAlias("rs.recruitSelectionType", "se", JoinType.INNER_JOIN);
        criteria.add(Restrictions.like("se.name", parameter.getSelectionType(), MatchMode.ANYWHERE));

    }/*from w  w w . j  a va 2s . co  m*/
    if (StringUtils.isNotEmpty(parameter.getLetterType())) {
        criteria.add(Restrictions.eq("leterTypeId", Integer.parseInt(parameter.getLetterType())));
    }
    if (StringUtils.isNotEmpty(parameter.getSenderBy())) {
        criteria.createAlias("recruitLetterComChannels", "rc", JoinType.INNER_JOIN);
        criteria.createAlias("rc.recruitCommChannels", "rcom", JoinType.INNER_JOIN);
        criteria.add(Restrictions.like("rcom.channelName", parameter.getSenderBy(), MatchMode.ANYWHERE));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchByParam(RecruitmenSelectionSeriesSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getName() != null) {
        criteria.add(Restrictions.like("name", searchParameter.getName(), MatchMode.START));
    }//from   w  w w . j  a  v  a 2  s  .c  om
    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.RecruitSelectionTypeDaoImpl.java

private void doSearchByParam(RecruitSelectionTypeSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getName() != null) {
        criteria.add(Restrictions.like("name", searchParameter.getName(), MatchMode.START));
    }/*from   w w  w . ja  v a  2  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.RecruitVacancySelectionDaoImpl.java

private void doSearchByParam(RecruitVacancySelectionSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getCode() != null) {
        criteria.add(Restrictions.like("code", searchParameter.getCode(), MatchMode.START));
    }/*from  www  .j  a va  2s .c  o  m*/
    if (searchParameter.getRecruitment() != null) {
        criteria.createAlias("recruitHireApply", "recruitHireApply", JoinType.INNER_JOIN);
        criteria.add(Restrictions.like("recruitHireApply.reqHireCode", searchParameter.getRecruitment(),
                MatchMode.START));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchByParam(SchedulerConfigSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getName() != null) {
        criteria.add(Restrictions.like("name", searchParameter.getName(), MatchMode.START));
    }/*from  w  ww.j  ava 2  s .  co m*/
    criteria.add(Restrictions.isNotNull("id"));
}