Example usage for org.hibernate.criterion Restrictions isNull

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

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

Introduction

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

Prototype

public static Criterion isNull(String propertyName)

Source Link

Document

Apply an "is null" constraint to the named property

Usage

From source file:com.sccl.attech.modules.sys.service.DictService.java

License:Open Source License

/**
 * //from  w w w  .j  ava  2s  . c  o  m
 * param dictID?
 * dict  type?
 */
public List<AllTreeVo> getTreeList(Dict dict, String companyId) {
    List<Dict> list = null;
    DetachedCriteria dc = dictDao.createDetachedCriteria();
    if (!"".equals(StrUtils.null2String(dict.getType()))) {
        dc.add(Restrictions.eq("type", dict.getType()));
    }
    if (!"".equals(StrUtils.null2String(dict.getId()))) {
        //         dc.add(Restrictions.eq("parent", dict));
        dc.add(Restrictions.sqlRestriction("parent_id = '" + dict.getId() + "'"));
    } else {
        //         dc.add(Restrictions.isNull("parent"));
        dc.add(Restrictions.sqlRestriction("parent_id is null"));
    }
    dc.add(Restrictions.or(Restrictions.isNull("companyId"), Restrictions.eq("companyId", "0"),
            Restrictions.eq("companyId", StrUtils.null2String(companyId))));
    dc.add(Restrictions.eq("delFlag", "0"));
    list = dictDao.find(dc);
    List<AllTreeVo> listAllTreeVos = new ArrayList<AllTreeVo>();
    if (null != list && list.size() > 0) {
        for (Dict dicts : list) {
            AllTreeVo allTreeVo = new AllTreeVo();
            allTreeVo.setLabel(dicts.getLabel());
            allTreeVo.setId(dicts.getId());
            //??
            List<Dict> dictChildren = findChildren(dicts.getId());//?id?
            //            if(null != dicts.getChildren() && dicts.getChildren().size() > 0){
            //               allTreeVo.setHasChild(true);
            //            }
            if (null != dictChildren && dictChildren.size() > 0) {//?????
                allTreeVo.setHasChild(true);
            }
            listAllTreeVos.add(allTreeVo);
        }
    }
    return listAllTreeVos;
}

From source file:com.sccl.attech.modules.sys.service.DictService.java

License:Open Source License

/**
 * ????/*w  w w. j av  a 2s  .  c  om*/
 */
public List<AllTreeVo> getAllChildTreeList(Dict dicts, String companyId, String name) {
    DetachedCriteria dc = dictDao.createDetachedCriteria();
    if (!"".equals(StrUtils.null2String(dicts.getType()))) {
        dc.add(Restrictions.eq("type", dicts.getType()));
    }

    if (name != null && !name.equals("")) {
        dc.add(Restrictions.like("label", "%" + name.trim() + "%"));
    }
    dc.add(Restrictions.eq("delFlag", "0"));
    dc.add(Restrictions.or(Restrictions.isNull("companyId"), Restrictions.eq("companyId", "0"),
            Restrictions.eq("companyId", StrUtils.null2String(companyId))));
    List<Dict> list = dictDao.find(dc);
    List<AllTreeVo> listAllTreeVo = new ArrayList<AllTreeVo>();
    if (null != list && list.size() > 0) {
        for (Dict dict : list) {

            List<Dict> dictChildren = findChildren(dict.getId());//?id?

            //            if(null == dict.getChildren() || dict.getChildren().size() <= 0){
            if (null == dictChildren || dictChildren.size() <= 0) {//?????
                AllTreeVo allTreeVo = new AllTreeVo();
                allTreeVo.setId(dict.getId());
                allTreeVo.setLabel(dict.getLabel());
                listAllTreeVo.add(allTreeVo);
            }
        }
    }
    return listAllTreeVo;
}

From source file:com.scopix.periscope.extractionmanagement.dao.EvidenceExtractionDAOImpl.java

License:Open Source License

/**
 * Obtiene las situaciones a partir del ID del sensor.
 *
 * @param camId ID del sensor/*from w  w w. j a  va 2  s  .  co  m*/
 * @return Lista de situaciones
 * @throws com.scopix.periscope.periscopefoundation.exception.PeriscopeException
 */
@Override
public List<SituationRequest> findSituationsForASensor(String sensorId) throws ScopixException {
    List<SituationRequest> listSituations = null;
    try {
        Criteria criteria = this.getSession().createCriteria(SituationRequest.class);
        criteria.createCriteria("situationSensors").add(Restrictions.eq("name", sensorId));
        criteria.createCriteria("extractionPlan").add(Restrictions.isNull("expirationDate"));
        //.add(Restrictions.eq("storeName", storeName));
        listSituations = criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY).list();

    } catch (Exception e) {
        throw new ScopixException(e);
    }

    return listSituations;
}

From source file:com.scopix.periscope.extractionmanagement.dao.EvidenceExtractionDAOImpl.java

License:Open Source License

/**
 * Obtiene las situaciones a partir del ID de la camara.
 *
 * @param camId ID de la camara/*ww  w.  j a v a 2 s.c o m*/
 * @return Lista de situaciones
 * @throws com.scopix.periscope.periscopefoundation.exception.PeriscopeException
 */
@Override
public List<SituationRequest> findSituationsForAEvidenceProvider(String camId) throws ScopixException {
    List<SituationRequest> listSituations = null;
    try {
        Criteria criteria = this.getSession().createCriteria(SituationRequest.class);
        criteria.createCriteria("metricRequests").createCriteria("evidenceProviderRequests")
                .add(Restrictions.eq("uniqueDeviceId", camId));
        criteria.createCriteria("extractionPlan").add(Restrictions.isNull("expirationDate"));
        //.add(Restrictions.eq("storeName", storeName));
        listSituations = criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY).list();

    } catch (Exception e) {
        throw new ScopixException(e);
    }

    return listSituations;
}

From source file:com.scopix.periscope.extractionmanagement.dao.EvidenceFileDAO.java

License:Open Source License

public List<EvidenceFile> findEvidenceFileByAlternativeName(String fileNameNextLevel) {
    Criteria criteria = this.getSession().createCriteria(EvidenceFile.class);
    criteria.add(Restrictions.eq("alternativeFileName", fileNameNextLevel));
    criteria.add(Restrictions.isNull("fileCreationDate"));
    List<EvidenceFile> evidenceFiles = criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY).list();
    return evidenceFiles;
}

From source file:com.scopix.periscope.extractionplanmanagement.dao.ExtractionPlanCustomizingDAOImpl.java

License:Open Source License

/**
 * Retorna una lista ExtractionPlanCustomizing unicos que esten activos o nulos
 *///from w w w .  j a v a 2s . c  o  m
@Override
public List<ExtractionPlanCustomizing> getExtractionPlanCustomizingActiveOrNullList(
        ExtractionPlanCustomizing epcFilter) {
    List<ExtractionPlanCustomizing> result = new ArrayList<ExtractionPlanCustomizing>();
    Session session = this.getSession();
    try {
        Criteria criteria = session.createCriteria(ExtractionPlanCustomizing.class);
        //criteria.addOrder(Order.asc("evaluationOrder"));
        if (epcFilter != null) {
            if (epcFilter.getSituationTemplate() != null && epcFilter.getSituationTemplate().getId() != null
                    && epcFilter.getSituationTemplate().getId() > 0) {
                criteria.add(Restrictions.eq("situationTemplate.id", epcFilter.getSituationTemplate().getId()));
            }

            if (epcFilter.getStore() != null && epcFilter.getStore().getId() != null
                    && epcFilter.getStore().getId() > 0) {
                criteria.add(Restrictions.eq("store.id", epcFilter.getStore().getId()));
            }
        }

        criteria.add(Restrictions.or(Restrictions.eq("active", true), Restrictions.isNull("active")));

        result = criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY).list();
    } catch (HibernateException e) {
        log.error(e, e);
    } finally {
        this.releaseSession(session);
    }
    return result;
}

From source file:com.scopix.periscope.extractionplanmanagement.dao.ExtractionPlanCustomizingDAOImpl.java

License:Open Source License

/**
 * Retorna una lista ExtractionPlanCustomizing unicos que esten null para un store, stituation template si llegan
 *///  w  w  w  .java 2s .  co m
@Override
public List<ExtractionPlanCustomizing> getExtractionPlanCustomizingNullList(
        ExtractionPlanCustomizing epcFilter) {
    List<ExtractionPlanCustomizing> result = new ArrayList<ExtractionPlanCustomizing>();
    Session session = this.getSession();
    try {
        Criteria criteria = session.createCriteria(ExtractionPlanCustomizing.class);
        //criteria.addOrder(Order.asc("evaluationOrder"));
        if (epcFilter != null) {
            if (epcFilter.getSituationTemplate() != null && epcFilter.getSituationTemplate().getId() != null
                    && epcFilter.getSituationTemplate().getId() > 0) {
                criteria.add(Restrictions.eq("situationTemplate.id", epcFilter.getSituationTemplate().getId()));
            }

            if (epcFilter.getStore() != null && epcFilter.getStore().getId() != null
                    && epcFilter.getStore().getId() > 0) {
                criteria.add(Restrictions.eq("store.id", epcFilter.getStore().getId()));
            }
        }

        criteria.add(Restrictions.isNull("active"));
        result = criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY).list();
    } catch (HibernateException e) {
        log.error(e, e);
    } finally {
        this.releaseSession(session);
    }
    return result;
}

From source file:com.scopix.periscope.extractionplanmanagement.dao.ExtractionPlanCustomizingDAOImpl.java

License:Open Source License

@Override
public List<ExtractionPlanCustomizing> getExtractionPlanCustomizingNullListByIds(List<Integer> epcIds) {
    List<ExtractionPlanCustomizing> result = new ArrayList<ExtractionPlanCustomizing>();
    Session session = this.getSession();
    try {/*from  w w w .j av  a  2s .c o  m*/
        Criteria criteria = session.createCriteria(ExtractionPlanCustomizing.class);
        if (epcIds != null && !epcIds.isEmpty()) {
            criteria.add(Restrictions.in("id", epcIds));
        }

        criteria.add(Restrictions.isNull("active"));
        result = criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY).list();
    } catch (HibernateException e) {
        log.error(e, e);
    } finally {
        this.releaseSession(session);
    }
    return result;
}

From source file:com.scopix.periscope.extractionplanmanagement.dao.ExtractionPlanCustomizingDAOImpl.java

License:Open Source License

/**
 * retorna un ExtractionPlanCustomizing dado SituationTemplate, MetricTemplate, Store, EvidenceProvider Esto se genera por
 * cambio de generacion y extraccion del EPC
 *///from  www  .j  a  va2s  .co m
@Override
public ExtractionPlanCustomizing getWizardCustomizing(ExtractionPlanCustomizing wizardCustomizing) {
    ExtractionPlanCustomizing extractionPlanCustomizing = null;
    Session session = this.getSession();
    try {
        Criteria criteria = session.createCriteria(ExtractionPlanCustomizing.class);
        //criteria.addOrder(Order.asc("evaluationOrder"));
        if (wizardCustomizing != null) {
            if (wizardCustomizing.getSituationTemplate() != null
                    && wizardCustomizing.getSituationTemplate().getId() != null
                    && wizardCustomizing.getSituationTemplate().getId() > 0) {
                criteria.add(Restrictions.eq("situationTemplate.id",
                        wizardCustomizing.getSituationTemplate().getId()));
            }
            //si existen metricas definidas
            if (!wizardCustomizing.getExtractionPlanMetrics().isEmpty()) {
                MetricTemplate metricTemplate = wizardCustomizing.getExtractionPlanMetrics().get(0)
                        .getMetricTemplate();
                if (metricTemplate != null && metricTemplate.getId() != null && metricTemplate.getId() > 0) {
                    criteria.add(Restrictions.eq("metricTemplate.id", metricTemplate.getId()));
                }
            }

            if (wizardCustomizing.getStore() != null && wizardCustomizing.getStore().getId() != null
                    && wizardCustomizing.getStore().getId() > 0) {
                criteria.add(Restrictions.eq("store.id", wizardCustomizing.getStore().getId()));
            }
        }
        criteria.add(Restrictions.or(Restrictions.eq("active", true), Restrictions.isNull("active")));
        List<ExtractionPlanCustomizing> l = criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY).list();
        if (l.size() > 1) {
            for (ExtractionPlanCustomizing epc : l) {
                if (epc.isActive() == null) {
                    extractionPlanCustomizing = epc;
                    break;
                }
            }
            log.debug("lista de epc > 1 " + l.size());
            //todo revisar que paso
        } else if (l.size() == 1) {
            extractionPlanCustomizing = l.get(0);
        }
    } catch (HibernateException e) {
        log.error(e, e);
    } finally {
        this.releaseSession(session);
    }
    return extractionPlanCustomizing;
}

From source file:com.scopix.periscope.extractionplanmanagement.dao.ExtractionPlanCustomizingDAOImpl.java

License:Open Source License

@Override
public List<EvidenceRequest> getFreeEvidenceRequestList(EvidenceRequest evidenceRequest, Date init, Date end) {
    List<EvidenceRequest> list = null;
    Session session = this.getSession();
    try {/*  w  w  w  .  j ava 2s . com*/
        Criteria criteria = session.createCriteria(EvidenceRequest.class);
        criteria.addOrder(Order.asc("id"));
        if (evidenceRequest != null) {
            if (init != null && end != null) {
                criteria.add(Restrictions.ge("evidenceTime", init));
                criteria.add(Restrictions.le("evidenceTime", end));
            } else if (init != null) {
                criteria.add(Restrictions.ge("evidenceTime", init));
            } else if (end != null) {
                criteria.add(Restrictions.le("evidenceTime", end));
            } else if (evidenceRequest.getEvidenceTime() != null) {
                criteria.add(Restrictions.eq("evidenceTime", evidenceRequest.getEvidenceTime()));
            }
            if (evidenceRequest.getType() != null) {
                criteria.add(Restrictions.eq("type", evidenceRequest.getType()));
            }
            if (evidenceRequest.getEvidenceProvider() != null
                    && evidenceRequest.getEvidenceProvider().getId() != null
                    && evidenceRequest.getEvidenceProvider().getId() > 0) {
                criteria.add(
                        Restrictions.eq("evidenceProvider.id", evidenceRequest.getEvidenceProvider().getId()));
            }
        }
        criteria.add(Restrictions.isNull("metric.id"));
        list = criteria.list();
    } catch (HibernateException e) {
        log.error(e, e);
    } finally {
        this.releaseSession(session);
    }
    return list;
}