Example usage for org.hibernate.criterion Restrictions in

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

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

Introduction

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

Prototype

public static Criterion in(String propertyName, Collection values)

Source Link

Document

Apply an "in" constraint to the named property.

Usage

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

@Override
public List<EmpData> getAllDataByEmployeeTypeOrGolonganJabatanOrUnitKerja(List<Long> empTypeId,
        List<Long> golJabId, List<Long> unitKerjaId, int firstResult, int maxResults, Order order) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    /**//from  ww  w .  j a  v  a  2  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, HrmUserInfoUtil.getCompanyId());
    criteria.add(Restrictions.not(Restrictions.eq("status", HRMConstant.EMP_TERMINATION)));

    criteria.createAlias("jabatanByJabatanId.unitKerja", "unitKerja", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("jabatanByJabatanId.golonganJabatan", "goljab", JoinType.LEFT_OUTER_JOIN);
    //        criteria.createAlias("department.company", "company", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("employeeType", "employeeType", JoinType.LEFT_OUTER_JOIN);
    criteria.setFetchMode("bioData", FetchMode.JOIN);
    if (!empTypeId.isEmpty()) {
        criteria.add(Restrictions.in("employeeType.id", empTypeId));
    }
    if (!golJabId.isEmpty()) {
        criteria.add(Restrictions.in("goljab.id", golJabId));
    }
    if (!unitKerjaId.isEmpty()) {
        criteria.add(Restrictions.in("unitKerja.id", unitKerjaId));
    }
    criteria.addOrder(order);
    criteria.setFirstResult(firstResult);
    criteria.setMaxResults(maxResults);
    return criteria.list();
}

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

@Override
public Long getTotalDataByEmployeeTypeOrGolonganJabatanOrUnitKerja(List<Long> empTypeId, List<Long> golJabId,
        List<Long> unitKerjaId) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    /**//w ww. ja va  2  s .  c om
     * 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, HrmUserInfoUtil.getCompanyId());
    criteria.add(Restrictions.not(Restrictions.eq("status", HRMConstant.EMP_TERMINATION)));

    criteria.createAlias("jabatanByJabatanId.unitKerja", "unitKerja", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("jabatanByJabatanId.golonganJabatan", "goljab", JoinType.LEFT_OUTER_JOIN);
    //        criteria.createAlias("department.company", "company", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("employeeType", "employeeType", JoinType.LEFT_OUTER_JOIN);
    if (!empTypeId.isEmpty()) {
        criteria.add(Restrictions.in("employeeType.id", empTypeId));
    }
    if (!golJabId.isEmpty()) {
        criteria.add(Restrictions.in("goljab.id", golJabId));
    }
    if (!unitKerjaId.isEmpty()) {
        criteria.add(Restrictions.in("unitKerja.id", unitKerjaId));
    }

    return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
}

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

@Override
public List<LogWtAttendanceRealization> getAllDataByParam(LogWtAttendanceRealizationModel model,
        int firstResult, int maxResults, Order orderable) {

    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    //      criteria.add(Restrictions.ge("periodeDateStart", model.getStartPeriod()));
    //      criteria.add(Restrictions.lt("periodeDateEnd", model.getEndPeriod()));
    if (model.getWtPeriodeId() != null) {
        criteria.add(Restrictions.eq("wtPeriodeId", model.getWtPeriodeId()));
    }//ww  w  .j a  va2  s.co  m

    if (model.getListDeptName() != null && model.getListDeptName().size() > 0) {
        criteria.add(Restrictions.in("empDepartementName", model.getListDeptName()));
    }

    if (model.getListGolJabName() != null && model.getListGolJabName().size() > 0) {
        criteria.add(Restrictions.in("empGolJab", model.getListGolJabName()));
    }
    //        if (model.getListGolJabName() != null) {
    //            criteria.add(Restrictions.in("empGolJab", model.getListGolJabName()));
    //        }
    criteria.addOrder(orderable);
    criteria.setFirstResult(firstResult);
    criteria.setMaxResults(maxResults);
    return criteria.list();
}

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

@Override
public Long getTotalDataByParam(LogWtAttendanceRealizationModel model) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    //        criteria.add(Restrictions.ge("periodeDateStart", model.getStartPeriod()));
    //        criteria.add(Restrictions.lt("periodeDateEnd", model.getEndPeriod()));
    //        criteria.add(Restrictions.eq("wtPeriodeId", model.getWtPeriodeId()));

    if (model.getWtPeriodeId() != null) {
        criteria.add(Restrictions.eq("wtPeriodeId", model.getWtPeriodeId()));
    }/*from   w w w  . j  av  a2  s  .  c  o  m*/

    if (model.getListDeptName() != null && model.getListDeptName().size() > 0) {
        criteria.add(Restrictions.in("empDepartementName", model.getListDeptName()));
    }
    if (model.getListDeptName() != null && model.getListGolJabName().size() > 0) {
        criteria.add(Restrictions.in("empGolJab", model.getListGolJabName()));
    }
    //        if (model.getListGolJabName() != null) {
    //            criteria.add(Restrictions.in("empGolJab", model.getListGolJabName()));
    //        }
    return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
}

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

@Override
public List<PaySalaryComponent> getAllDataByEmpTypeIdAndActiveFromTmAndIdNotIn(Long empTypeId, int fromTbm,
        List<Long> componentIds) {
    Criteria criteria = getCurrentSession().createCriteria(getEntityClass());
    criteria.createAlias("paySalaryEmpTypes", "payType");
    criteria.createAlias("payType.employeeType", "employeeType");
    criteria.add(Restrictions.eq("employeeType.id", empTypeId));
    criteria.add(Restrictions.le("activeFromTmb", fromTbm));
    if (!componentIds.isEmpty()) {
        criteria.add(Restrictions.not(Restrictions.in("id", componentIds)));
    }//from w ww. j a  va  2 s  .c  o m
    return criteria.list();
}

From source file:com.ipn.escom.ageinnn.documento.service.DocumentoServiceImpl.java

public List<DocumentoRequerido> findAllDocumentosPendientesByUsuario(Aspirante usuario) {
    List<Integer> documentosId = new ArrayList<>();
    documentosId.add(0);//from   www .j  a v  a2  s  .c om
    for (DocumentoEntregado de : usuario.getDocumentos()) {
        documentosId.add(de.getDocumentoId());
    }
    SimpleExpression nacional;
    if (usuario.getMedico().isNacional()) {
        nacional = Restrictions.eq("nacional", true);
    } else {
        nacional = Restrictions.eq("extranjero", true);
    }

    List<DocumentoRequerido> documentosPendientes = new ArrayList<>();

    try {
        session = Service.getSessionFactory().getCurrentSession();
        session.beginTransaction();
        documentosPendientes = session.createCriteria(DocumentoRequerido.class).add(nacional)
                .add(Restrictions.not(Restrictions.in("id", documentosId))).list();

        session.getTransaction().commit();
    } catch (Exception e) {
        session.getTransaction().rollback();
        throw e;
    }

    return documentosPendientes;

}

From source file:com.iti.fashny.daos.AbstractFacade.java

protected void addTagConditionOnExample(Criteria c, List<Tag> tags, String listVariableNameInEntity) {

    List<Integer> wrappedParameter;
    wrappedParameter = new ArrayList<>();
    c.createAlias(listVariableNameInEntity, "tag");
    for (Tag tag : tags) {
        wrappedParameter.add(tag.getId());
    }/*from w  ww. j av  a2s . c  om*/
    c.add(Restrictions.in("tag.id", wrappedParameter));
}

From source file:com.iti.fashny.daos.AbstractFacade.java

protected void addPlaceConditionOnExample(Criteria c, List<Place> places, String listVariableNameInEntity) {

    List<Integer> wrappedParameter;
    wrappedParameter = new ArrayList<>();
    c.createAlias(listVariableNameInEntity, "place");
    for (Place place : places) {
        wrappedParameter.add(place.getId());
    }//from   w w  w. j  a va  2 s  .  c o  m
    c.add(Restrictions.in("place.id", wrappedParameter));
}

From source file:com.itrus.ca.common.service.BaseService.java

License:Open Source License

protected static Junction dataScopeFilterByWorkDealInfo(User user, String Alias, String office) {

    // ????//  w  ww .ja v a2s  . c  om
    List<String> dataScope = Lists.newArrayList();
    Junction junction = Restrictions.disjunction();
    // ???
    if (!user.isAdmin()) {
        for (Role r : user.getRoleList()) {
            if (!dataScope.contains(r.getDataScope()) && StringUtils.isNotBlank(Alias)) {
                boolean isDataScopeAll = false;
                if (Role.DATA_SCOPE_ALL.equals(r.getDataScope())) {
                    isDataScopeAll = true;
                } else if (Role.DATA_SCOPE_COMPANY_AND_CHILD.equals(r.getDataScope())) {
                    junction.add(Restrictions.eq(office, user.getCompany().getId()));
                    junction.add(Restrictions.like(Alias,
                            user.getCompany().getParentIds() + user.getCompany().getId() + ",%"));
                } else if (Role.DATA_SCOPE_COMPANY.equals(r.getDataScope())) {
                    junction.add(Restrictions.eq(Alias, user.getCompany().getId()));
                    //                  junction.add(Restrictions.and(Restrictions.eq(Alias+".parent.id", user.getCompany().getId()),
                    //                        Restrictions.eq(Alias+".type", "2"))); // ?
                } else if (Role.DATA_SCOPE_OFFICE_AND_CHILD.equals(r.getDataScope())) {
                    junction.add(Restrictions.eq(office, user.getOffice().getId()));
                    junction.add(Restrictions.like(Alias,
                            user.getOffice().getParentIds() + user.getOffice().getId() + ",%"));
                } else if (Role.DATA_SCOPE_OFFICE.equals(r.getDataScope())) {
                    junction.add(Restrictions.eq(office, user.getOffice().getId()));
                } else if (Role.DATA_SCOPE_CUSTOM.equals(r.getDataScope())) {
                    junction.add(Restrictions.in(office, r.getOfficeIdList()));
                }
                //else if (Role.DATA_SCOPE_SELF.equals(r.getDataScope())){
                if (isDataScopeAll) {
                    // ?????
                    junction = Restrictions.disjunction();
                    break;
                }
                dataScope.add(r.getDataScope());
            }
        }
    }
    return junction;
}

From source file:com.itrus.ca.modules.sys.service.OfficeService.java

License:Open Source License

public List<Office> findByParentIds(List<Long> areaIds) {
    DetachedCriteria dc = officeDao.createDetachedCriteria();
    if (areaIds == null) {
        return null;
    }/*from   w  w w.jav a2 s .  c o  m*/
    if (areaIds != null) {

        if (StringUtils.isNotEmpty(areaIds.toString())) {
            dc.add(Restrictions.in("parent.id", areaIds));
        } else {
            return null;
        }
    }
    dc.add(Restrictions.neOrIsNotNull("type", "1"));
    dc.add(Restrictions.eq("delFlag", Office.DEL_FLAG_NORMAL));
    dc.addOrder(Order.asc("code"));
    dc.addOrder(Order.desc("id"));
    return officeDao.find(dc);
}