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

private void doSearchByParam(OhsaIncidentSearchParameter parameter, Criteria criteria) {

    criteria.createAlias("ohsaCategory", "ohsaCategory", JoinType.INNER_JOIN);
    if (StringUtils.isNotEmpty(parameter.getKategori())) {
        criteria.add(Restrictions.like("ohsaCategory.name", parameter.getKategori(), MatchMode.ANYWHERE));
    }//from w  w w.  jav  a  2s  . com
    if (StringUtils.isNotEmpty(parameter.getSubjek())) {
        criteria.add(Restrictions.like("subject", parameter.getSubjek(), MatchMode.ANYWHERE));
    }
    if (StringUtils.isNotEmpty(parameter.getLokasi())) {
        criteria.add(Restrictions.like("location", parameter.getLokasi(), MatchMode.ANYWHERE));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

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

private void doSearch(OverTimeDistributionSearchParameter searchParameter, Criteria criteria) {
    criteria.createAlias("empData", "empData", JoinType.INNER_JOIN);
    criteria.createAlias("empData.bioData", "bioData", JoinType.INNER_JOIN);
    criteria.createAlias("wtOverTime", "wtOverTime", JoinType.INNER_JOIN);
    if (searchParameter.getEmpData() != null) {

        //            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);
        criteria.add(Restrictions.ilike("bioData.combineName", searchParameter.getEmpData().toLowerCase(),
                MatchMode.ANYWHERE));//  w  w  w .  j  a  va 2s.c o  m
    }
    if (searchParameter.getNik() != null) {
        criteria.add(Restrictions.like("empData.nik", searchParameter.getNik(), MatchMode.START));
    }
    if (StringUtils.isNotEmpty(searchParameter.getWtOverTime())) {

        criteria.add(Restrictions.like("wtOverTime.name", searchParameter.getWtOverTime(), MatchMode.ANYWHERE));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchPasswordHistByParam(PasswordHistorySearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getUsername() != null) {
        criteria.add(Restrictions.like("userName", searchParameter.getUsername(), MatchMode.START));
    }/*from   w ww  .j a v  a2  s .  co  m*/
    if (searchParameter.getRealname() != null) {
        criteria.add(Restrictions.like("realName", searchParameter.getRealname(), MatchMode.START));
    }
    if (searchParameter.getEmailAddress() != null) {
        criteria.add(Restrictions.like("emailAddress", searchParameter.getEmailAddress(), MatchMode.START));
    }
    if (searchParameter.getPhoneNumber() != null) {
        criteria.add(Restrictions.like("phoneNumber", searchParameter.getPhoneNumber(), MatchMode.START));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchByParam(PayComponentDataExceptionSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getPaySalaryComponent() != null) {
        criteria.createAlias("paySalaryComponent", "paySalaryComponent", JoinType.INNER_JOIN);
        criteria.add(Restrictions.like("paySalaryComponent.name", searchParameter.getPaySalaryComponent(),
                MatchMode.START));/* www . ja v a 2s. co m*/
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchByParamForDetail(String searchParameter, Criteria criteria) {
    criteria.createAlias("empData", "empData", JoinType.INNER_JOIN);
    criteria.createAlias("empData.bioData", "bioData", JoinType.INNER_JOIN);
    criteria.createAlias("paySalaryComponent", "paySalaryComponent", JoinType.INNER_JOIN);
    if (StringUtils.isNotEmpty(searchParameter)) {
        Disjunction disjunction = Restrictions.disjunction();
        disjunction.add(Restrictions.like("empData.nik", searchParameter, MatchMode.START));
        disjunction.add(Restrictions.like("bioData.firstName", searchParameter, MatchMode.START));
        disjunction.add(Restrictions.like("bioData.lastName", searchParameter, MatchMode.START));
        criteria.add(disjunction);// w  w w .  j  ava  2s .c o m
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchByParam(PaySalaryComponentSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getName() != null) {
        criteria.add(Restrictions.like("name", searchParameter.getName(), MatchMode.ANYWHERE));
    }//from   www  .  ja v  a2s  .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.PaySalaryComponentDaoImpl.java

private void doSearchComponentUploadByParam(PaySalaryComponentSearchParameter searchParameter,
        Criteria criteria) {/*from   w w  w .  j  a va 2s.com*/
    if (StringUtils.isNotEmpty(searchParameter.getName())) {
        criteria.add(Restrictions.like("name", searchParameter.getName(), MatchMode.ANYWHERE));
    }
    if (StringUtils.isNotEmpty(searchParameter.getCode())) {
        criteria.add(Restrictions.like("code", searchParameter.getCode(), MatchMode.START));
    }
    criteria.add(Restrictions.isNotNull("id"));
    criteria.createAlias("modelComponent", "modelComponent");
    criteria.add(Restrictions.eq("modelComponent.spesific", HRMConstant.MODEL_COMP_UPLOAD));
}

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

private void doSearchByParam(PayTempKalkulasiSearchParameter parameter, Criteria criteria) {
    criteria.createAlias("paySalaryComponent", "paySalaryComponent", JoinType.INNER_JOIN);
    criteria.createAlias("empData", "empData", JoinType.INNER_JOIN);
    criteria.createAlias("empData.bioData", "bioData", JoinType.INNER_JOIN);
    if (StringUtils.isNotEmpty(parameter.getEmpData())) {
        Disjunction disjunction = Restrictions.disjunction();
        disjunction.add(Restrictions.like("bioData.firstName", parameter.getEmpData(), MatchMode.ANYWHERE));
        disjunction.add(Restrictions.like("bioData.lastName", parameter.getEmpData(), MatchMode.ANYWHERE));
        criteria.add(disjunction);/*  w  w  w  .  j a  v a  2s.c o  m*/
    }
    if (StringUtils.isNotEmpty(parameter.getPaySalaryComponent())) {
        criteria.add(
                Restrictions.like("bioData.firstName", parameter.getPaySalaryComponent(), MatchMode.ANYWHERE));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

public void doSearchByParam(String searchParameter, Criteria criteria, Long paySalaryComponentId) {
    criteria.createAlias("paySalaryComponent", "paySalaryComponent", JoinType.INNER_JOIN);
    criteria.createAlias("empData", "empData", JoinType.INNER_JOIN);
    criteria.createAlias("empData.bioData", "bioData", JoinType.INNER_JOIN);
    criteria.add(Restrictions.eq("paySalaryComponent.id", paySalaryComponentId));
    if (StringUtils.isNotEmpty(searchParameter)) {
        Disjunction disjunction = Restrictions.disjunction();
        disjunction.add(Restrictions.like("empData.nik", searchParameter, MatchMode.START));
        disjunction.add(Restrictions.like("bioData.firstName", searchParameter, MatchMode.START));
        disjunction.add(Restrictions.like("bioData.lastName", searchParameter, MatchMode.START));
        criteria.add(disjunction);//  w  w  w  . ja v a2s .  co m
        //            criteria.add(Restrictions.like("bioData.firstName", parameter, MatchMode.ANYWHERE));
    }
    criteria.add(Restrictions.isNotNull("id"));
}