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

@Override
public List<EmpData> getAllDataByNameOrNik(String param, Long companyId) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    /**//from   w  w w . ja v  a2 s.  c  o  m
     * automatically get relations of jabatanByJabatanId, department,
     * company don't create alias for that entity, or will get error :
     * duplicate association path
     */
    criteria = this.addJoinRelationsOfCompanyId(criteria, companyId);
    //criteria.add(Restrictions.neOrIsNotNull("status", HRMConstant.EMP_TERMINATION));
    criteria.add(Restrictions.isNotNull("status"));
    criteria.add(Restrictions
            .not(Restrictions.in("status", Arrays.asList(HRMConstant.EMP_TERMINATION, HRMConstant.EMP_DISCHAGED,
                    HRMConstant.EMP_LAID_OFF, HRMConstant.EMP_STOP_CONTRACT, HRMConstant.EMP_PENSION))));

    criteria.createAlias("bioData", "bioData", JoinType.INNER_JOIN);
    Disjunction disjunction = Restrictions.disjunction();
    disjunction.add(Restrictions.like("bioData.firstName", param, MatchMode.ANYWHERE));
    disjunction.add(Restrictions.like("bioData.lastName", param, MatchMode.ANYWHERE));
    disjunction.add(Restrictions.like("nik", param, MatchMode.ANYWHERE));
    criteria.add(disjunction);
    criteria.setMaxResults(20);
    return criteria.list();
}

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

@Override
public List<EmpData> getAllDataByNameOrNik(String param) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    //criteria.add(Restrictions.neOrIsNotNull("status", HRMConstant.EMP_TERMINATION));
    criteria.add(Restrictions.isNotNull("status"));
    criteria.add(Restrictions//from   w w w. j ava  2 s  . com
            .not(Restrictions.in("status", Arrays.asList(HRMConstant.EMP_TERMINATION, HRMConstant.EMP_DISCHAGED,
                    HRMConstant.EMP_LAID_OFF, HRMConstant.EMP_STOP_CONTRACT, HRMConstant.EMP_PENSION))));

    criteria.createAlias("bioData", "bioData", JoinType.INNER_JOIN);
    Disjunction disjunction = Restrictions.disjunction();
    disjunction.add(Restrictions.like("bioData.firstName", param, MatchMode.ANYWHERE));
    disjunction.add(Restrictions.like("bioData.lastName", param, MatchMode.ANYWHERE));
    disjunction.add(Restrictions.like("nik", param, MatchMode.ANYWHERE));
    criteria.add(disjunction);
    criteria.setMaxResults(20);
    return criteria.list();
}

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

private void doSearchEmpRotasiByParam(EmpRotasiSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getNIK() != null) {
        criteria.createAlias("empData", "ep", JoinType.INNER_JOIN);
        criteria.add(Restrictions.like("ep.nik", searchParameter.getNIK(), MatchMode.START));
    }//from w  w w . j  a v  a  2  s. c o m

    if (searchParameter.getName() != null) {
        criteria.createAlias("empData", "ep", JoinType.INNER_JOIN);
        criteria.createAlias("ep.bioData", "bio", JoinType.INNER_JOIN);
        criteria.add(Restrictions.like("bio.firstName", searchParameter.getName(), MatchMode.START));
    }
    if (searchParameter.getJabatanLama() != null) {
        criteria.createAlias("jabatanByOldFunctionId", "jbo", JoinType.INNER_JOIN);
        criteria.add(Restrictions.eq("jbo.name", searchParameter.getJabatanLama()));
    }

    if (searchParameter.getJabatanBaru() != null) {
        criteria.createAlias("jabatanByNewFunctionId", "jbn", JoinType.INNER_JOIN);
        criteria.add(Restrictions.eq("jbn.name", searchParameter.getJabatanBaru()));
    }

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

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

private void doSearchFamilyRelationByParam(FamilyRelationSearchParameter parameter, Criteria criteria) {
    if (parameter.getRelasiName() != null) {
        criteria.add(Restrictions.like("relasiName", parameter.getRelasiName(), MatchMode.ANYWHERE));
    }//from w  w w .  ja va 2  s  . c o  m
    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.GolonganJabatanDaoImpl.java

private void doSearchByParam(GolonganJabatanSearchParameter parameter, Criteria criteria) {
    criteria.createAlias("pangkat", "pangkat", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("paySalaryGrade", "paySalaryGrade", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("paySalaryGrade.currency", "currency", JoinType.LEFT_OUTER_JOIN);
    if (StringUtils.isNotEmpty(parameter.getCode())) {
        criteria.add(Restrictions.like("code", parameter.getCode(), MatchMode.ANYWHERE));
    }//from   w w  w  .ja v a  2s.  co  m
    if (StringUtils.isNotEmpty(parameter.getPangkatName())) {
        criteria.add(Restrictions.like("pangkat.pangkatName", parameter.getPangkatName(), MatchMode.ANYWHERE));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchLHrmRoleByParam(HrmRoleSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getRoleName() != null) {
        criteria.add(Restrictions.like("roleName", searchParameter.getRoleName(), MatchMode.START));
    }/*  w ww. j a  va 2  s.c  om*/
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchSpiUserByParam(HrmUserSearchParameter parameter, Criteria criteria) {
    if (parameter.getUserName() != null) {
        criteria.add(Restrictions.like("userId", parameter.getUserName(), MatchMode.ANYWHERE));

    }//from w  w w  . j a v  a 2  s .  co  m

    if (parameter.getRealName() != null) {
        criteria.add(Restrictions.like("realName", parameter.getRealName(), MatchMode.ANYWHERE));
    }

    if (parameter.getRoleName() != null) {
        criteria.createAlias("hrmUserRoles", "h");
        criteria.createAlias("h.hrmRole", "hrmRole");
        criteria.add(Restrictions.like("hrmRole.roleName", parameter.getRoleName(), MatchMode.ANYWHERE));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchByParam(String parameter, Criteria criteria,
        InclusionReimbursmentModel inclusionReimbursmentModel) {
    criteria.createAlias("reimbursmentSchema", "reimbursmentSchema", JoinType.INNER_JOIN);
    criteria.createAlias("empData", "empData", JoinType.INNER_JOIN);
    criteria.createAlias("empData.bioData", "bioData", JoinType.INNER_JOIN);
    criteria.add(Restrictions.eq("reimbursmentSchema.payrollComponent", Boolean.TRUE));
    criteria.add(Restrictions.ge("claimDate", inclusionReimbursmentModel.getStartDate()));
    criteria.add(Restrictions.lt("claimDate", inclusionReimbursmentModel.getEndDate()));
    if (StringUtils.isNotEmpty(parameter)) {
        Disjunction disjunction = Restrictions.disjunction();
        disjunction.add(Restrictions.like("empData.nik", parameter, MatchMode.ANYWHERE));
        disjunction.add(Restrictions.like("bioData.firstName", parameter, MatchMode.ANYWHERE));
        disjunction.add(Restrictions.like("bioData.lastName", parameter, MatchMode.ANYWHERE));
        criteria.add(disjunction);//from ww  w . j a v  a2  s  .  co  m
        //            criteria.add(Restrictions.like("bioData.firstName", parameter, MatchMode.ANYWHERE));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchByParam(InsuranceSearchParameter parameter, Criteria criteria) {
    if (parameter.getCode() != null) {
        criteria.add(Restrictions.like("code", parameter.getCode(), MatchMode.ANYWHERE));
    }//from  w ww . j a va 2  s  . co m

    if (parameter.getName() != null) {
        criteria.add(Restrictions.like("name", parameter.getName(), MatchMode.ANYWHERE));
    }
    if (parameter.getInsuranceProduct() != null) {
        criteria.add(
                Restrictions.like("insuranceProduct", parameter.getInsuranceProduct(), MatchMode.ANYWHERE));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchMaritalStatusByParam(IpPermitSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getLokasi() != null) {
        criteria.add(Restrictions.like("lokasi", searchParameter.getLokasi(), MatchMode.START));
    }/*ww  w  .j av  a 2 s .  c  o  m*/
    if (searchParameter.getFrom() != null) {
        criteria.add(Restrictions.like("ipAddressFromView", searchParameter.getFrom(), MatchMode.START));
    }
    if (searchParameter.getUntil() != null) {
        criteria.add(Restrictions.like("ipAddressUntilView", searchParameter.getUntil(), MatchMode.START));
    }
    criteria.add(Restrictions.isNotNull("id"));
}