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.datacore.dao.impl.IDAOImpl.java

/**
 * Get All data for specific Entity (T). Note this method only return data
 * that have primary key, page able, Sorting, and isActive condition
 *
 * @param firstResult is int type and begin from 0
 * @param maxResults is int type//from  w w  w .j ava2  s . c om
 * @param order is Hibernate Order
 * @param isActive is Integer condition 0 or 1
 * @return List of entity
 */
public List<T> getAllDataPageAbleIsActive(int firstResult, int maxResults, Order order, Integer isActive) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.addOrder(order);
    criteria.add(Restrictions.isNotNull("id"));
    cekIsActive(criteria, isActive);
    criteria.setFirstResult(firstResult);
    criteria.setMaxResults(maxResults);
    return (List<T>) criteria.list();
}

From source file:com.inkubator.datacore.dao.impl.IDAOImpl.java

/**
 * Get All data for specific Entity (T). Note this method only return data
 * that have primary key, page able, Sorting, and isActive condition
 *
 * @param firstResult is int type and begin from 0
 * @param maxResults is int type//from   ww w .j a v  a2  s . c o m
 * @param order is Hibernate Order
 * @param isActive is Byte condition -127 or 127
 * @return List of entity
 */
public List<T> getAllDataPageAbleIsActive(int firstResult, int maxResults, Order order, Byte isActive) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.addOrder(order);
    criteria.add(Restrictions.isNotNull("id"));
    cekIsActive(criteria, isActive);
    criteria.setFirstResult(firstResult);
    criteria.setMaxResults(maxResults);
    return (List<T>) criteria.list();
}

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

private void doSearchApprovalDefinitionByParam(ApprovalDefinitionSearchParameter searchParameter,
        Criteria criteria) {//from ww w  .ja  va 2s  . c om
    if (searchParameter.getApprovalName() != null) {
        criteria.add(Restrictions.like("name", searchParameter.getApprovalName(), MatchMode.START));
    }
    if (searchParameter.getProcessName() != null) {

        criteria.add(Restrictions.like("processType", searchParameter.getProcessName(), MatchMode.START));
    }
    if (searchParameter.getApproverPosition() != null) {
        criteria.createAlias("jabatanByApproverPosition", "ap", JoinType.INNER_JOIN);
        criteria.add(Restrictions.like("ap.name", searchParameter.getApproverPosition(), MatchMode.START));
    }
    if (searchParameter.getApproverIndividual() != null) {
        criteria.createAlias("hrmUserByApproverIndividual", "au", JoinType.INNER_JOIN);
        criteria.add(
                Restrictions.like("au.realName", searchParameter.getApproverIndividual(), MatchMode.START));
    }

    if (searchParameter.getOnBehalfApproverPosition() != null) {
        criteria.createAlias("jabatanByOnBehalfPosition", "ap", JoinType.INNER_JOIN);
        criteria.add(Restrictions.like("ap.name", searchParameter.getApproverPosition(), MatchMode.START));
    }
    if (searchParameter.getOnBehaltAppriverIndividual() != null) {
        criteria.createAlias("hrmUserByOnBehalfIndividual", "au", JoinType.INNER_JOIN);
        criteria.add(
                Restrictions.like("au.realName", searchParameter.getApproverIndividual(), MatchMode.START));
    }
    if (searchParameter.getApproverType() != null) {
        criteria.add(Restrictions.like("approverType", searchParameter.getApproverType(), MatchMode.START));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchAttendanceStatusByParam(AttendanceStatusSearchParamater searchParamater,
        Criteria criteria) {/*from w  w w .  j  av a2 s. c  o  m*/
    if (searchParamater.getCodeStatus() != null && !searchParamater.getCodeStatus().isEmpty()) {
        criteria.add(Restrictions.like("code", searchParamater.getCodeStatus(), MatchMode.START));
    }

    if (searchParamater.getStatusName() != null && !searchParamater.getStatusName().isEmpty()) {
        criteria.add(Restrictions.like("statusKehadrian", searchParamater.getStatusName(), MatchMode.START));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

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

private void doSearchBioDataByParam(BioDataSearchParameter parameter, Criteria criteria) {
    if (parameter.getName() != null) {
        //            criteria.add(Restrictions.like("firstName", parameter.getParameter(), MatchMode.ANYWHERE));
        //            Disjunction disjunction = Restrictions.disjunction();
        //            disjunction.add(Restrictions.like("firstName", parameter.getName(), MatchMode.ANYWHERE));
        //            disjunction.add(Restrictions.like("lastName", parameter.getName(), MatchMode.ANYWHERE));
        //            criteria.add(disjunction);

        criteria.createAlias("religion", "religion", JoinType.INNER_JOIN);
        criteria.createAlias("maritalStatus", "maritalStatus", JoinType.INNER_JOIN);
        criteria.add(Restrictions.ilike("combineName", parameter.getName().toLowerCase(), MatchMode.ANYWHERE));
    }/*from   w w  w . j av a 2 s.c  o m*/

    if (parameter.getEmailAddress() != null) {
        criteria.add(Restrictions.like("personalEmail", parameter.getEmailAddress(), MatchMode.ANYWHERE));
    }
    if (parameter.getNickName() != null) {
        criteria.add(Restrictions.like("nickname", parameter.getNickName(), MatchMode.ANYWHERE));
    }
    criteria.add(Restrictions.isNotNull("id"));

}

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

public void doSearchByParam(BioPotensiSwotSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getName() != null) {
        criteria.createAlias("bioData", "bio", JoinType.INNER_JOIN);
        Disjunction disjunction = Restrictions.disjunction();
        disjunction.add(Restrictions.like("bio.firstName", searchParameter.getName(), MatchMode.START));
        disjunction.add(Restrictions.like("bio.lastName", searchParameter.getName(), MatchMode.START));
        criteria.add(disjunction);//from   ww  w .j ava 2s .  co m
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

public void doSearchByParam(BioRelasiPerusahaanSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getName() != null) {
        criteria.createAlias("bioData", "bio", JoinType.INNER_JOIN);
        Disjunction disjunction = Restrictions.disjunction();
        disjunction.add(Restrictions.like("bio.firstName", searchParameter.getName(), MatchMode.START));
        disjunction.add(Restrictions.like("bio.lastName", searchParameter.getName(), MatchMode.START));
        criteria.add(disjunction);/*from  w w w . j  av a 2  s . c o  m*/
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchTerminationTypeByParam(CareerTerminationTypeSearchParameter searchParameter,
        Criteria criteria) {/* w w  w . j  a va2  s . c o m*/
    criteria.createAlias("systemLetterReference", "systemLetterReference", JoinType.INNER_JOIN);
    criteria.createAlias("systemCareerConst", "systemCareerConst", JoinType.INNER_JOIN);
    if (StringUtils.isNotBlank(searchParameter.getCode())) {
        criteria.add(Restrictions.like("code", searchParameter.getCode(), MatchMode.ANYWHERE));
    }

    if (StringUtils.isNotBlank(searchParameter.getName())) {
        criteria.add(Restrictions.like("name", searchParameter.getName(), MatchMode.ANYWHERE));
    }
    criteria.add(Restrictions.isNotNull("id"));
}

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

private void doSearchByParam(DivisiSearchParameter searchParameter, Criteria criteria) {
    if (searchParameter.getName() != null) {
        criteria.add(Restrictions.like("name", searchParameter.getName(), MatchMode.START));
    }/*from  w  w w .j av a  2s  . c  o m*/
    if (searchParameter.getCode() != null) {
        criteria.add(Restrictions.like("code", searchParameter.getCode(), MatchMode.START));
    }
    criteria.add(Restrictions.isNotNull("id"));
}