Example usage for org.hibernate.criterion Restrictions disjunction

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

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

Introduction

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

Prototype

public static Disjunction disjunction()

Source Link

Document

Group expressions together in a single disjunction (A or B or C...).

Usage

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

@Override
public List<Jabatan> getAllDataByCodeOrName(String param) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    /** 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());

    Disjunction disjunction = Restrictions.disjunction();
    disjunction.add(Restrictions.like("code", param, MatchMode.ANYWHERE));
    disjunction.add(Restrictions.like("name", param, MatchMode.ANYWHERE));
    criteria.add(disjunction);/*from ww  w.  j a  v a 2  s .c  o  m*/
    return criteria.list();
}

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 a2 s . com
    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

@Override
public List<LoanNewApplication> getListLoanDisbursedOrPaidByEmpDataIdAndLoanNewSchemaId(Long empDataId,
        Long loanNewSchemaId) {/*from  w w  w  .ja v a 2 s  .  c  om*/
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());

    criteria.setFetchMode("empData", FetchMode.JOIN);
    criteria.setFetchMode("loanNewSchema", FetchMode.JOIN);
    criteria.add(Restrictions.eq("empData.id", empDataId));
    criteria.add(Restrictions.eq("loanNewSchema.id", loanNewSchemaId));

    Disjunction disjunction = Restrictions.disjunction();
    disjunction.add(Restrictions.eq("loanStatus", HRMConstant.LOAN_DISBURSED));
    disjunction.add(Restrictions.eq("loanStatus", HRMConstant.LOAN_PAID));
    criteria.add(disjunction);

    return criteria.list();
}

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(//w  ww. ja va 2s . 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.LoanNewApplicationDaoImpl.java

@Override
public List<LoanNewApplication> getListLoanDisbursedOrPaidByEmpDataIdAndLoanNewTypeId(Long empDataId,
        Long loanNewTypeId) {//from  w w w  .jav a  2  s . com
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());

    criteria.setFetchMode("empData", FetchMode.JOIN);
    criteria.setFetchMode("loanNewType", FetchMode.JOIN);
    criteria.add(Restrictions.eq("empData.id", empDataId));
    criteria.add(Restrictions.eq("loanNewType.id", loanNewTypeId));

    Disjunction disjunction = Restrictions.disjunction();
    disjunction.add(Restrictions.eq("loanStatus", HRMConstant.LOAN_DISBURSED));
    disjunction.add(Restrictions.eq("loanStatus", HRMConstant.LOAN_PAID));
    criteria.add(disjunction);

    return criteria.list();
}

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);/*from  w  ww. j  av  a 2  s  . c  o  m*/
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

@Override
public List<PaySalaryComponent> getAllDataByComponentCategoryZeroOrOne() {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    Disjunction disjunction = Restrictions.disjunction();
    disjunction.add(Restrictions.eq("componentCategory", 0));
    disjunction.add(Restrictions.eq("componentCategory", 1));
    criteria.add(disjunction);//from w w  w .j  a v  a  2  s. co m
    return criteria.list();
}

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

@Override
public List<PaySalaryComponent> getAllDataRenumerationByEmployeeTypeId(Long empTypeId) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.createAlias("modelComponent", "modelComponent", JoinType.INNER_JOIN);
    criteria.createAlias("paySalaryEmpTypes", "paySalaryEmpTypes", JoinType.INNER_JOIN);
    criteria.createAlias("paySalaryEmpTypes.employeeType", "employeeType", JoinType.INNER_JOIN);
    criteria.add(Restrictions.eq("employeeType.id", empTypeId));

    Disjunction renumerationComp = Restrictions.disjunction();
    renumerationComp.add(Restrictions.eq("modelComponent.spesific", HRMConstant.MODEL_COMP_BENEFIT_TABLE));
    renumerationComp.add(Restrictions.eq("modelComponent.spesific", HRMConstant.MODEL_COMP_BASIC_SALARY));
    criteria.add(renumerationComp);//from   www.ja v  a 2  s .  c o m

    return criteria.list();
}

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);//  www . j  av 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);/*from w ww  . j  a  v  a 2 s . c  o m*/
        //            criteria.add(Restrictions.like("bioData.firstName", parameter, MatchMode.ANYWHERE));
    }
    criteria.add(Restrictions.isNotNull("id"));
}