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

private void doSearchByParam(JabatanSearchParameter parameter, Criteria criteria) {
    /** automatically get relations of department, company 
      *  don't create alias for that entity, or will get error : duplicate association path */
    // criteria = this.addJoinRelationsOfCompanyId(criteria, HrmUserInfoUtil.getCompanyId());
    criteria.createAlias("department.company", "company", JoinType.INNER_JOIN);
    criteria.add(Restrictions.eq("company.id", HrmUserInfoUtil.getCompanyId()));
    if (StringUtils.isNotEmpty(parameter.getCode())) {
        criteria.add(Restrictions.like("code", parameter.getCode(), MatchMode.ANYWHERE));
    }//from   w  w w . jav a2 s  . c  o m

    if (StringUtils.isNotEmpty(parameter.getGolJab())) {
        criteria.add(Restrictions.like("golonganJabatan.code", parameter.getGolJab(), MatchMode.ANYWHERE));
    }
    if (StringUtils.isNotEmpty(parameter.getName())) {
        criteria.add(Restrictions.like("name", parameter.getName(), MatchMode.ANYWHERE));
    }

    if (StringUtils.isNotEmpty(parameter.getCostCenterName())) {
        criteria.add(Restrictions.like("costCenter.name", parameter.getCostCenterName(), MatchMode.ANYWHERE));
    }

    if (StringUtils.isNotEmpty(parameter.getDepartementName())) {
        criteria.add(Restrictions.like("department.departmentName", parameter.getDepartementName(),
                MatchMode.ANYWHERE));
    }

    if (StringUtils.isNotEmpty(parameter.getJabatan())) {
        criteria.add(Restrictions.like("pangkat.pangkatName", parameter.getJabatan(), MatchMode.ANYWHERE));
    }

    if (StringUtils.isNotEmpty(parameter.getUnitKerjaName())) {
        criteria.add(Restrictions.like("unitKerja.name", parameter.getUnitKerjaName(), MatchMode.ANYWHERE));
    }

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

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

private void doSearchByParam(KlasifikasiKerjaLevelSearchParameter 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 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.LoanCanceledDaoImpl.java

private void doSearchByParam(LoanCanceledSearchParameter searchParameter, Criteria criteria) {

    if (StringUtils.isNotEmpty(searchParameter.getLoanSchema())) {
        criteria.createAlias("loanSchema", "loanSchema", JoinType.INNER_JOIN);
        criteria.add(Restrictions.like("loanSchema.name", searchParameter.getLoanSchema(), MatchMode.ANYWHERE));
    }/* w  w  w .  j  a v  a  2s . c om*/
    if (StringUtils.isNotEmpty(searchParameter.getEmployee())) {
        criteria.createAlias("empData", "empData", JoinType.INNER_JOIN);
        criteria.createAlias("empData.bioData", "bioData", JoinType.INNER_JOIN);

        Disjunction disjunction = Restrictions.disjunction();
        disjunction.add(Restrictions.like("empData.nik", searchParameter.getEmployee(), MatchMode.ANYWHERE));
        disjunction
                .add(Restrictions.like("bioData.firstName", searchParameter.getEmployee(), MatchMode.ANYWHERE));
        disjunction
                .add(Restrictions.like("bioData.lastName", searchParameter.getEmployee(), MatchMode.ANYWHERE));
        criteria.add(disjunction);
    }

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

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

private void doSearchByParam(LoanNewSearchParameter parameter, Criteria criteria) {

    if (StringUtils.isNotEmpty(parameter.getLoanType())) {
        criteria.createAlias("loanNewType", "loanNewType", JoinType.INNER_JOIN);
        criteria.add(/*from   w w w  .j  a  v  a  2 s.c o m*/
                Restrictions.like("loanNewType.loanTypeName", parameter.getLoanType(), MatchMode.ANYWHERE));
    }
    if (StringUtils.isNotEmpty(parameter.getEmployee())) {
        criteria.createAlias("empData", "empData", JoinType.INNER_JOIN);
        criteria.createAlias("empData.bioData", "bioData", JoinType.INNER_JOIN);

        Disjunction disjunction = Restrictions.disjunction();
        disjunction.add(Restrictions.like("empData.nik", parameter.getEmployee(), MatchMode.ANYWHERE));
        disjunction.add(Restrictions.like("bioData.firstName", parameter.getEmployee(), MatchMode.ANYWHERE));
        disjunction.add(Restrictions.like("bioData.lastName", parameter.getEmployee(), MatchMode.ANYWHERE));
        criteria.add(disjunction);
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

public void doSearchByParam(LoanNewSchemaSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getName() != null) {
        criteria.add(Restrictions.like("loanSchemaName", searchParameter.getName(), MatchMode.ANYWHERE));
    }// w  ww  . j av  a  2 s  .  c om
    if (searchParameter.getCode() != null) {
        criteria.add(Restrictions.like("loanSchemaCode", searchParameter.getCode(), MatchMode.START));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchLoanTypeByParam(LoanNewTypeSearchParameter parameter, Criteria criteria) {
    if (parameter.getLoanTypeCode() != null) {
        criteria.add(Restrictions.like("loanTypeCode", parameter.getLoanTypeCode(), MatchMode.ANYWHERE));
    }//from   ww  w  .j a va 2  s . c o  m

    if (parameter.getLoanTypeName() != null) {
        criteria.add(Restrictions.like("loanTypeName", parameter.getLoanTypeName(), MatchMode.ANYWHERE));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchLoanTypeByParam(LoanTypeSearchParameter parameter, Criteria criteria) {
    if (parameter.getLoanTypeCode() != null) {
        criteria.add(Restrictions.like("loanTypeCode", parameter.getLoanTypeCode(), MatchMode.ANYWHERE));
    }//from   ww w .  jav a 2s .  co m

    if (parameter.getLoanTypeName() != null) {
        criteria.add(Restrictions.like("loanTypeName", parameter.getLoanTypeName(), MatchMode.ANYWHERE));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchLoginHistByParam(LoginHistorySearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getUserId() != null) {
        criteria.add(Restrictions.like("hrmUser.userId", searchParameter.getUserId(), MatchMode.START));
    }//from   ww  w  .  j  a v  a 2 s  .  c om
    if (searchParameter.getIpAddress() != null) {
        criteria.add(Restrictions.like("ipAddress", searchParameter.getIpAddress(), MatchMode.START));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchMecineFingerByParam(MecineFingerSearchParameter parameter, Criteria criteria) {

    if (parameter.getCode() != null) {
        criteria.add(Restrictions.like("code", parameter.getCode(), MatchMode.ANYWHERE));
    }//from w  ww  . j a  va  2  s.c o  m
    if (parameter.getName() != null) {
        criteria.add(Restrictions.like("name", parameter.getName(), MatchMode.ANYWHERE));
    }

    if (parameter.getMethodType() != null) {
        criteria.add(Restrictions.eq("mecineMethode", Integer.parseInt(parameter.getMethodType())));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

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