org.hibernate.Criteria.createCriteria() - java examples

Here are the examples of the java api org.hibernate.Criteria.createCriteria() taken from open source projects. By voting up you can indicate which examples are most useful and appropriate.

151 Examples 7

19 View Complete Implementation : DaoUtil.java
Copyright Apache License 2.0
Author : tmobile
public static void addEnvironmentToCriteria(int envId, boolean isParentComponents, List<Integer> compIds, Criteria criteria) {
    criteria.createCriteria("environment", "environment");
    if (envId != 0) {
        criteria.add(Restrictions.eq("environment.environmentId", envId));
    }
    criteria.add(Restrictions.eq("environment.envLock", 0));
    if (compIds.size() > 0) {
        if (isParentComponents) {
            criteria.add(Restrictions.in("component.parentComponent.componentId", compIds));
        } else {
            criteria.add(Restrictions.in("component.componentId", compIds));
        }
    }
}

19 View Complete Implementation : DaoUtil.java
Copyright Apache License 2.0
Author : tmobile
public static void addEnvironmentToCriteria(int envId, List<Integer> compIds, Criteria criteria) {
    criteria.createCriteria("environment", "environment");
    if (envId != 0) {
        criteria.add(Restrictions.eq("environment.environmentId", envId));
    }
    criteria.add(Restrictions.eq("environment.envLock", 0));
    if (compIds.size() > 0) {
        criteria.add(Property.forName("component.componentId").in(compIds));
    }
}

19 View Complete Implementation : EntityCriteria.java
Copyright MIT License
Author : theonedev
public Criteria createCriteria(String replacedociationPath) throws HibernateException {
    return criteria.createCriteria(replacedociationPath);
}

19 View Complete Implementation : EntityCriteria.java
Copyright MIT License
Author : theonedev
public Criteria createCriteria(String replacedociationPath, String alias) throws HibernateException {
    return criteria.createCriteria(replacedociationPath, alias);
}

19 View Complete Implementation : EReportingObservationDAO.java
Copyright GNU General Public License v2.0
Author : 52North
@Override
protected Criteria addAdditionalObservationIdentification(Criteria c, OmObservation observation) {
    String identifier = getSamplingPointIdentifier(observation);
    if (!Strings.isNullOrEmpty(identifier)) {
        c.createCriteria(getSamplingPointreplacedociationPath()).add(Restrictions.eq(EReportingSamplingPointEnreplacedy.IDENTIFIER, identifier));
    }
    return c;
}

18 View Complete Implementation : ECRFDaoImpl.java
Copyright GNU Lesser General Public License v2.1
Author : phoenixctms
@Override
protected Collection<ECRF> handleFindByTrialActiveSorted(Long trialId, Boolean active, boolean sort, PSFVO psf) throws Exception {
    org.hibernate.Criteria ecrfCriteria = createEcrfCriteria(null);
    SubCriteriaMap criteriaMap = new SubCriteriaMap(ECRF.clreplaced, ecrfCriteria);
    if (trialId != null) {
        ecrfCriteria.add(Restrictions.eq("trial.id", trialId.longValue()));
    }
    // if (groupId != null) {
    // ecrfCriteria.add(Restrictions.or(Restrictions.eq("group.id", groupId.longValue()),
    // Restrictions.isNull("group.id")));
    // }
    // if (visitId != null) {
    // ecrfCriteria.add(Restrictions.or(Restrictions.eq("visit.id", visitId.longValue()),
    // Restrictions.isNull("visit.id")));
    // }
    if (active != null) {
        ecrfCriteria.add(Restrictions.eq("active", active.booleanValue()));
    }
    CriteriaUtil.applyPSFVO(criteriaMap, psf);
    if (sort) {
        ecrfCriteria.addOrder(Order.asc("trial"));
        Criteria visitCriteria = ecrfCriteria.createCriteria("visit", CriteriaSpecification.LEFT_JOIN);
        visitCriteria.addOrder(Order.asc("token"));
        Criteria groupCriteria = ecrfCriteria.createCriteria("group", CriteriaSpecification.LEFT_JOIN);
        groupCriteria.addOrder(Order.asc("token"));
        // ecrfCriteria.addOrder(Order.asc("position"));
        ecrfCriteria.addOrder(Order.asc("position"));
    }
    return ecrfCriteria.list();
}

18 View Complete Implementation : ProbandListEntryDaoImpl.java
Copyright GNU Lesser General Public License v2.1
Author : phoenixctms
@Override
protected long handleGetTrialGroupProbandCount(Long trialId, Long probandGroupId, Long probandId, boolean total) throws Exception {
    org.hibernate.Criteria listEntryCriteria = createListEntryCriteria();
    if (trialId != null) {
        listEntryCriteria.add(Restrictions.eq("trial.id", trialId.longValue()));
    }
    if (probandGroupId != null) {
        listEntryCriteria.add(Restrictions.eq("group.id", probandGroupId.longValue()));
    }
    if (probandId != null) {
        listEntryCriteria.add(Restrictions.eq("proband.id", probandId.longValue()));
    }
    if (!total) {
        listEntryCriteria.createCriteria("lastStatus", CriteriaSpecification.INNER_JOIN).createCriteria("status", CriteriaSpecification.INNER_JOIN).add(Restrictions.eq("count", true));
    // istEntryCriteria.add(Restrictions.eq("proband.id", probandId.longValue()));
    }
    return (Long) listEntryCriteria.setProjection(Projections.rowCount()).uniqueResult();
}

18 View Complete Implementation : MaintenanceScheduleItemDaoImpl.java
Copyright GNU Lesser General Public License v2.1
Author : phoenixctms
@Override
protected Collection<MaintenanceScheduleItem> handleFindMaintenanceInterval(Long inventoryId, Long departmentId, Long inventoryCategoryId, Long responsiblePersonId, Long responsiblePersonProxyId, Boolean reminder, Timestamp from, Timestamp to) throws Exception {
    Criteria maintenanceItemCriteria = createMaintenanceItemCriteria();
    if (inventoryId != null || departmentId != null || inventoryCategoryId != null) {
        Criteria inventoryCriteria = maintenanceItemCriteria.createCriteria("inventory", CriteriaSpecification.INNER_JOIN);
        if (inventoryId != null) {
            inventoryCriteria.add(Restrictions.idEq(inventoryId.longValue()));
        }
        if (departmentId != null) {
            inventoryCriteria.add(Restrictions.eq("department.id", departmentId.longValue()));
        }
        if (inventoryCategoryId != null) {
            inventoryCriteria.add(Restrictions.eq("category.id", inventoryCategoryId.longValue()));
        }
    }
    applyResponsiblePersonProxyCriterions(maintenanceItemCriteria, responsiblePersonId, responsiblePersonProxyId);
    // performance only...
    maintenanceItemCriteria.add(Restrictions.eq("active", true));
    return CriteriaUtil.listEvents(maintenanceItemCriteria, from, to, reminder);
}

18 View Complete Implementation : VisitScheduleItemDaoImpl.java
Copyright GNU Lesser General Public License v2.1
Author : phoenixctms
@Override
protected Collection<VisitScheduleItem> handleFindByTrialSorted(Long trialId, boolean sort, PSFVO psf) throws Exception {
    Criteria visitScheduleItemCriteria = createVisitScheduleItemCriteria(null);
    SubCriteriaMap criteriaMap = new SubCriteriaMap(VisitScheduleItem.clreplaced, visitScheduleItemCriteria);
    if (trialId != null) {
        visitScheduleItemCriteria.add(Restrictions.eq("trial.id", trialId.longValue()));
    }
    // if (groupId != null) {
    // visitScheduleItemCriteria.add(Restrictions.or(Restrictions.eq("group.id", groupId.longValue()),
    // Restrictions.isNull("group.id")));
    // }
    // if (visitId != null) {
    // visitScheduleItemCriteria.add(Restrictions.or(Restrictions.eq("visit.id", visitId.longValue()),
    // Restrictions.isNull("visit.id")));
    // }
    // proband has only one probandlistentry, and listentry has only one group, but left joins
    CriteriaUtil.applyPSFVO(criteriaMap, psf);
    if (sort) {
        visitScheduleItemCriteria.addOrder(Order.asc("trial"));
        Criteria visitCriteria = visitScheduleItemCriteria.createCriteria("visit", CriteriaSpecification.LEFT_JOIN);
        visitCriteria.addOrder(Order.asc("token"));
        Criteria groupCriteria = visitScheduleItemCriteria.createCriteria("group", CriteriaSpecification.LEFT_JOIN);
        groupCriteria.addOrder(Order.asc("token"));
        visitScheduleItemCriteria.addOrder(Order.asc("token"));
    }
    return visitScheduleItemCriteria.list();
}

18 View Complete Implementation : VisitScheduleItemDaoImpl.java
Copyright GNU Lesser General Public License v2.1
Author : phoenixctms
@Override
protected long handleGetCount(Long trialId, Long groupId, Long visitId, Long probandId, Boolean travel) throws Exception {
    Criteria visitScheduleItemCriteria = createVisitScheduleItemCriteria("visitScheduleItem");
    if (trialId != null) {
        visitScheduleItemCriteria.add(Restrictions.eq("trial.id", trialId.longValue()));
    }
    if (groupId != null) {
        visitScheduleItemCriteria.add(Restrictions.or(Restrictions.eq("group.id", groupId.longValue()), Restrictions.isNull("group.id")));
    }
    if (visitId != null) {
        visitScheduleItemCriteria.add(Restrictions.or(Restrictions.eq("visit.id", visitId.longValue()), Restrictions.isNull("visit.id")));
    }
    if (probandId != null) {
        Criteria trialCriteria = visitScheduleItemCriteria.createCriteria("trial");
        trialCriteria.createCriteria("probandListEntries").add(Restrictions.eq("proband.id", probandId.longValue()));
        Criteria groupCriteria = visitScheduleItemCriteria.createCriteria("group", CriteriaSpecification.LEFT_JOIN);
        groupCriteria.createCriteria("probandListEntries", CriteriaSpecification.LEFT_JOIN).add(Restrictions.or(Restrictions.eq("proband.id", probandId.longValue()), Restrictions.isNull("visitScheduleItem.group")));
    }
    if (travel != null) {
        visitScheduleItemCriteria.createCriteria("visit.type", CriteriaSpecification.LEFT_JOIN).add(Restrictions.or(Restrictions.eq("travel", travel.booleanValue()), Restrictions.isNull("visitScheduleItem.visit")));
    }
    if (probandId == null) {
        return (Long) visitScheduleItemCriteria.setProjection(Projections.rowCount()).uniqueResult();
    // CriteriaUtil.applyPSFVO(criteriaMap, psf); // proband has only one probandlistentry, and listentry has only one group, but left joins
    // return visitScheduleItemCriteria.list();
    } else {
        return (Long) visitScheduleItemCriteria.setProjection(Projections.countDistinct("id")).uniqueResult();
    // return CriteriaUtil.listDistinctRootPSFVO(criteriaMap, psf, this);
    }
}

18 View Complete Implementation : EReportingSeriesDAO.java
Copyright GNU General Public License v2.0
Author : 52North
/**
 * Add EReportingSamplingPoint restriction to Hibernate Criteria
 *
 * @param c
 *            Hibernate Criteria to add restriction
 * @param samplingPoints
 *            EReportingSamplingPoint identifiers to add
 */
public void addEReportingSamplingPointToCriteria(Criteria c, Collection<String> samplingPoints) {
    c.createCriteria(getSamplingPointreplacedociationPath()).add(Restrictions.in(EReportingSamplingPointEnreplacedy.IDENTIFIER, samplingPoints));
}

18 View Complete Implementation : ECRFDaoImpl.java
Copyright GNU Lesser General Public License v2.1
Author : phoenixctms
@Override
protected long handleGetCount(Long probandListEntryId, Long visitId, Boolean active, Long ecrfStatusTypeId, Boolean done) throws Exception {
    ProbandListEntry listEntry = this.getProbandListEntryDao().load(probandListEntryId);
    Long trialId = listEntry.getTrial().getId();
    Long groupId = (listEntry.getGroup() != null ? listEntry.getGroup().getId() : null);
    org.hibernate.Criteria ecrfCriteria = createEcrfCriteria("ecrf0");
    if (visitId != null) {
        ecrfCriteria.add(Restrictions.eq("visit.id", visitId.longValue()));
    } else {
        ecrfCriteria.add(Restrictions.eq("trial.id", trialId.longValue()));
    }
    if (groupId != null) {
        ecrfCriteria.add(Restrictions.or(Restrictions.eq("group.id", groupId.longValue()), Restrictions.isNull("group.id")));
    }
    if (active != null) {
        ecrfCriteria.add(Restrictions.eq("active", active.booleanValue()));
    }
    if (ecrfStatusTypeId != null || done != null) {
        org.hibernate.Criteria ecrfStatusEntryCriteria = ecrfCriteria.createCriteria("ecrfStatusEntries", "statusEntries", CriteriaSpecification.LEFT_JOIN, Restrictions.and(Restrictions.eqProperty("statusEntries.ecrf.id", "ecrf0.id"), Restrictions.eq("statusEntries.listEntry.id", probandListEntryId.longValue())));
        org.hibernate.Criteria ecrfStatusTypeCriteria = ecrfStatusEntryCriteria.createCriteria("status", CriteriaSpecification.LEFT_JOIN);
        if (ecrfStatusTypeId != null) {
            ecrfStatusTypeCriteria.add(Restrictions.idEq(ecrfStatusTypeId.longValue()));
        }
        if (done != null) {
            ecrfStatusTypeCriteria.add(Restrictions.eq("done", done.booleanValue()));
        }
    }
    return (Long) ecrfCriteria.setProjection(Projections.rowCount()).uniqueResult();
}

17 View Complete Implementation : HibernateQueryModelDAO.java
Copyright Apache License 2.0
Author : jeppetto
// -------------------------------------------------------------
// Methods - Private
// -------------------------------------------------------------
private Criteria buildCriteria(QueryModel queryModel) {
    Criteria criteria = getCurrentSession().createCriteria(persistentClreplaced);
    if (queryModel.getConditions() != null) {
        for (Condition condition : queryModel.getConditions()) {
            criteria.add((Criterion) condition.getConstraint());
        }
    }
    for (Map.Entry<String, List<Condition>> replacedociationCriteriaEntry : queryModel.getreplacedociationConditions().entrySet()) {
        Criteria replacedociationCriteria = criteria.createCriteria(replacedociationCriteriaEntry.getKey());
        criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENreplacedY);
        for (Condition condition : replacedociationCriteriaEntry.getValue()) {
            replacedociationCriteria.add((Criterion) condition.getConstraint());
        }
    }
    if (queryModel.getProjection() != null) {
        ProjectionList projectionList = Projections.projectionList();
        projectionList.add((org.hibernate.criterion.Projection) queryModel.getProjection().getDetails());
        criteria.setProjection(projectionList);
    }
    return criteria;
}

17 View Complete Implementation : HibernateQueryModelDAO.java
Copyright Apache License 2.0
Author : jeppetto
// TODO: Add projection, maxResults, firstResult support
private Query createAccessControlledQuery(QueryModel queryModel) {
    Criteria criteria = getCurrentSession().createCriteria(persistentClreplaced);
    for (String replacedociationPath : queryModel.getreplacedociationConditions().keySet()) {
        criteria.createCriteria(replacedociationPath);
    }
    CriteriaQueryTranslator criteriaQueryTranslator = new CriteriaQueryTranslator((SessionFactoryImplementor) sessionFactory, (CriteriaImpl) criteria, persistentClreplaced.getName(), CriteriaQueryTranslator.ROOT_SQL_ALIAS);
    StringBuilder queryStringBuilder = new StringBuilder();
    buildSelectClause(queryStringBuilder, criteriaQueryTranslator, queryModel.getreplacedociationConditions().keySet());
    List<TypedValue> parameters = buildWhereClause(queryStringBuilder, queryModel, criteria, criteriaQueryTranslator);
    if ((queryModel.getreplacedociationConditions() == null || queryModel.getreplacedociationConditions().isEmpty()) && (queryModel.getSorts() == null || queryModel.getSorts().isEmpty())) {
        buildDefaultOrderClause(queryStringBuilder);
    } else {
        // can't use the default ordering by "ace.id" because of "select distinct..." syntax
        buildOrderClause(queryStringBuilder, queryModel, criteria, criteriaQueryTranslator);
    }
    Query query = getCurrentSession().createQuery(queryStringBuilder.toString());
    setParameters(parameters, query, queryModel.getAccessControlContext());
    return query;
}

17 View Complete Implementation : AccountingDAO.java
Copyright GNU Lesser General Public License v3.0
Author : OurGrid
private void updateGridProcessAccounting(String dNdata, GridProcessAccounting replicaAccounting) {
    long jobId = replicaAccounting.getJobId();
    int taskId = replicaAccounting.getTaskSequenceNumber();
    int processId = replicaAccounting.getGridProcessSequenceNumber();
    long requestId = replicaAccounting.getRequestId();
    Criteria criteria = HibernateUtil.getSession().createCriteria(GridProcess.clreplaced);
    criteria.add(Restrictions.eq("sequenceNumber", processId));
    Criteria taskCriteria = criteria.createCriteria("task");
    taskCriteria.add(Restrictions.eq("sequenceNumber", taskId));
    Criteria jobCriteria = taskCriteria.createCriteria("job");
    jobCriteria.add(Restrictions.eq("jobId", jobId));
    jobCriteria.add(Restrictions.eq("requestId", requestId));
    GridProcess gridProcess = (GridProcess) criteria.uniqueResult();
    gridProcess.setProviderDN(dNdata);
    gridProcess.setCpuConsumed(replicaAccounting.getAccountings().getCPUTime());
    gridProcess.setDataConsumed(replicaAccounting.getAccountings().getData());
    Session session = HibernateUtil.getSession();
    session.saveOrUpdate(gridProcess);
    session.flush();
}

17 View Complete Implementation : WorkerDAO.java
Copyright GNU Lesser General Public License v3.0
Author : OurGrid
@SuppressWarnings("unchecked")
public Attribute findByWorkerAndProperty(List<IResponseTO> responses, Worker worker, String key) {
    responses.add(LoggerUtil.enter());
    Attribute att = null;
    Criteria criteria = HibernateUtil.getSession().createCriteria(Attribute.clreplaced);
    criteria.createCriteria("worker").add(Restrictions.eq("id", worker.getId()));
    criteria.add(Restrictions.eq("property", key));
    List<Attribute> result = criteria.list();
    if (!result.isEmpty()) {
        att = result.get(0);
    }
    responses.add(LoggerUtil.leave());
    return att;
}

17 View Complete Implementation : CourseParticipationStatusEntryDaoImpl.java
Copyright GNU Lesser General Public License v2.1
Author : phoenixctms
@Override
protected Collection<CourseParticipationStatusEntry> handleFindByCourseSorted(Long courseId) throws Exception {
    org.hibernate.Criteria courseParticipationStatusEntryCriteria = createCourseParticipationStatusEntryCriteria();
    if (courseId != null) {
        courseParticipationStatusEntryCriteria.add(Restrictions.eq("course.id", courseId.longValue()));
    }
    Criteria staffCriteria = courseParticipationStatusEntryCriteria.createCriteria("staff", CriteriaSpecification.INNER_JOIN);
    Criteria personParticularsCriteria = staffCriteria.createCriteria("personParticulars", CriteriaSpecification.INNER_JOIN);
    personParticularsCriteria.addOrder(Order.asc("lastName"));
    personParticularsCriteria.addOrder(Order.asc("firstName"));
    return courseParticipationStatusEntryCriteria.list();
}

17 View Complete Implementation : CourseParticipationStatusEntryDaoImpl.java
Copyright GNU Lesser General Public License v2.1
Author : phoenixctms
@Override
protected Collection<CourseParticipationStatusEntry> handleFindByStaffCourseRelevantForCourseAppointments(Long staffId, Long courseId, Boolean isRelevantForCourseAppointments) throws Exception {
    org.hibernate.Criteria courseParticipationStatusEntryCriteria = createCourseParticipationStatusEntryCriteria();
    if (staffId != null) {
        courseParticipationStatusEntryCriteria.add(Restrictions.eq("staff.id", staffId.longValue()));
    }
    if (courseId != null) {
        courseParticipationStatusEntryCriteria.add(Restrictions.eq("course.id", courseId.longValue()));
    }
    if (isRelevantForCourseAppointments != null) {
        courseParticipationStatusEntryCriteria.createCriteria("status", CriteriaSpecification.INNER_JOIN).add(Restrictions.eq("relevantForCourseAppointments", isRelevantForCourseAppointments.booleanValue()));
    }
    return courseParticipationStatusEntryCriteria.list();
}

17 View Complete Implementation : ECRFDaoImpl.java
Copyright GNU Lesser General Public License v2.1
Author : phoenixctms
// private Long getCount(Long probandListEntryId, Long visitId, Boolean active, Long ecrfStatusTypeId, String property, Boolean value) throws Exception {
// 
// ProbandListEntry listEntry = this.getProbandListEntryDao().load(probandListEntryId);
// Long trialId = listEntry.getTrial().getId();
// Long groupId = (listEntry.getGroup() != null ? listEntry.getGroup().getId() : null);
// org.hibernate.Criteria ecrfCriteria = createEcrfCriteria("ecrf0");
// if (visitId != null) {
// ecrfCriteria.add(Restrictions.eq("visit.id", visitId.longValue()));
// } else {
// ecrfCriteria.add(Restrictions.eq("trial.id", trialId.longValue()));
// }
// if (groupId != null) {
// ecrfCriteria.add(Restrictions.or(Restrictions.eq("group.id", groupId.longValue()),
// Restrictions.isNull("group.id")
// ));
// }
// if (active != null) {
// ecrfCriteria.add(Restrictions.eq("active", active.booleanValue()));
// }
// if (ecrfStatusTypeId != null || value != null) {
// org.hibernate.Criteria ecrfStatusEntryCriteria = ecrfCriteria.createCriteria("ecrfStatusEntries", "statusEntries",
// CriteriaSpecification.LEFT_JOIN,
// Restrictions.and(
// Restrictions.eqProperty("statusEntries.ecrf.id", "ecrf0.id"),
// Restrictions.eq("statusEntries.listEntry.id", probandListEntryId.longValue())
// ));
// org.hibernate.Criteria ecrfStatusTypeCriteria = ecrfStatusEntryCriteria.createCriteria("status",CriteriaSpecification.LEFT_JOIN);
// if (ecrfStatusTypeId != null) {
// ecrfStatusTypeCriteria.add(Restrictions.idEq(ecrfStatusTypeId.longValue()));
// }
// if (value != null) {
// ecrfStatusTypeCriteria.add(Restrictions.eq(property, value.booleanValue()));
// }
// 
// }
// return (Long) ecrfCriteria.setProjection(Projections.rowCount()).uniqueResult();
// }
@Override
protected Collection<ECRF> handleFindByListEntryActiveSorted(Long probandListEntryId, Boolean active, boolean sort, PSFVO psf) throws Exception {
    ProbandListEntry listEntry = this.getProbandListEntryDao().load(probandListEntryId);
    Long trialId = listEntry.getTrial().getId();
    Long groupId = (listEntry.getGroup() != null ? listEntry.getGroup().getId() : null);
    org.hibernate.Criteria ecrfCriteria = createEcrfCriteria(null);
    ecrfCriteria.add(Restrictions.eq("trial.id", trialId.longValue()));
    if (groupId != null) {
        // http://stackoverflow.com/questions/4334970/hibernate-cannot-simultaneously-fetch-multiple-bags
        Criteria ecrfFieldCriteria = ecrfCriteria.createCriteria("ecrfFields", CriteriaSpecification.LEFT_JOIN);
        // ecrfFieldCriteria.setFetchMode("fieldValues", FetchMode.EAGER);
        Criteria ecrfFieldValueCriteria = ecrfFieldCriteria.createCriteria("fieldValues", "ecrfFieldValues", CriteriaSpecification.LEFT_JOIN);
        if (active != null) {
            ecrfCriteria.add(Restrictions.or(Restrictions.and(Restrictions.or(Restrictions.eq("group.id", groupId.longValue()), Restrictions.isNull("group.id")), Restrictions.eq("active", active.booleanValue())), Restrictions.eq("ecrfFieldValues.listEntry.id", probandListEntryId.longValue())));
        } else {
            ecrfCriteria.add(Restrictions.or(Restrictions.or(Restrictions.eq("group.id", groupId.longValue()), Restrictions.isNull("group.id")), Restrictions.eq("ecrfFieldValues.listEntry.id", probandListEntryId.longValue())));
        }
    } else {
        // if (active != null) {
        // ecrfCriteria.add(Restrictions.eq("active", active.booleanValue()));
        // }
        if (active != null) {
            // http://stackoverflow.com/questions/4334970/hibernate-cannot-simultaneously-fetch-multiple-bags
            Criteria ecrfFieldCriteria = ecrfCriteria.createCriteria("ecrfFields", CriteriaSpecification.LEFT_JOIN);
            // ecrfFieldCriteria.setFetchMode("fieldValues", FetchMode.EAGER);
            Criteria ecrfFieldValueCriteria = ecrfFieldCriteria.createCriteria("fieldValues", "ecrfFieldValues", CriteriaSpecification.LEFT_JOIN);
            ecrfCriteria.add(Restrictions.or(Restrictions.eq("active", active.booleanValue()), Restrictions.eq("ecrfFieldValues.listEntry.id", probandListEntryId.longValue())));
        }
    }
    SubCriteriaMap criteriaMap = new SubCriteriaMap(ECRF.clreplaced, ecrfCriteria);
    if (sort) {
        if (psf == null) {
            psf = new PSFVO();
        }
        psf.setSortField("position");
        psf.setSortOrder(true);
    // ecrfCriteria.addOrder(Order.asc("position"));
    }
    return CriteriaUtil.listDistinctRootPSFVO(criteriaMap, psf, this);
}

17 View Complete Implementation : InventoryBookingDaoImpl.java
Copyright GNU Lesser General Public License v2.1
Author : phoenixctms
private void applyCourseIntervalCriterion(Criteria bookingCriteria, Long courseId, Timestamp from, Timestamp to, Boolean isRelevantForCourseAppointments) {
    CriteriaUtil.applyClosedIntervalCriterion(bookingCriteria, from, to, null);
    if (courseId != null) {
        bookingCriteria.add(Restrictions.eq("course.id", courseId.longValue()));
    }
    if (isRelevantForCourseAppointments != null) {
        bookingCriteria.createCriteria("inventory", CriteriaSpecification.INNER_JOIN).createCriteria("category", CriteriaSpecification.INNER_JOIN).add(Restrictions.eq("relevantForCourseAppointments", isRelevantForCourseAppointments.booleanValue()));
    }
}

17 View Complete Implementation : InventoryBookingDaoImpl.java
Copyright GNU Lesser General Public License v2.1
Author : phoenixctms
@Override
protected Collection<InventoryBooking> handleFindByProbandTrial(Long probandId, Long trialId, Boolean isRelevantForProbandAppointments, Boolean isRelevantForTrialAppointments, boolean sort) throws Exception {
    Criteria bookingCriteria = createBookingCriteria();
    if (probandId != null) {
        bookingCriteria.add(Restrictions.eq("proband.id", probandId.longValue()));
    }
    if (trialId != null) {
        bookingCriteria.add(Restrictions.eq("trial.id", trialId.longValue()));
    }
    if (isRelevantForProbandAppointments != null || isRelevantForTrialAppointments != null) {
        Criteria categoryCriteria = bookingCriteria.createCriteria("inventory", CriteriaSpecification.INNER_JOIN).createCriteria("category", CriteriaSpecification.INNER_JOIN);
        if (isRelevantForProbandAppointments != null) {
            categoryCriteria.add(Restrictions.eq("relevantForProbandAppointments", isRelevantForProbandAppointments.booleanValue()));
        }
        if (isRelevantForTrialAppointments != null) {
            categoryCriteria.add(Restrictions.eq("relevantForTrialAppointments", isRelevantForTrialAppointments.booleanValue()));
        }
    }
    if (sort) {
        bookingCriteria.addOrder(Order.asc("start"));
    }
    return bookingCriteria.list();
}

17 View Complete Implementation : InventoryBookingDaoImpl.java
Copyright GNU Lesser General Public License v2.1
Author : phoenixctms
@Override
protected Collection<InventoryBooking> handleFindByCourseSorted(Long courseId, Boolean isRelevantForCourseAppointments, boolean sort) throws Exception {
    Criteria bookingCriteria = createBookingCriteria();
    if (courseId != null) {
        bookingCriteria.add(Restrictions.eq("course.id", courseId.longValue()));
    }
    if (isRelevantForCourseAppointments != null) {
        bookingCriteria.createCriteria("inventory", CriteriaSpecification.INNER_JOIN).createCriteria("category", CriteriaSpecification.INNER_JOIN).add(Restrictions.eq("relevantForCourseAppointments", isRelevantForCourseAppointments.booleanValue()));
    }
    if (sort) {
        bookingCriteria.addOrder(Order.asc("start"));
    }
    return bookingCriteria.list();
}

17 View Complete Implementation : InventoryBookingDaoImpl.java
Copyright GNU Lesser General Public License v2.1
Author : phoenixctms
private static void applyIncludeAppointmentsCriterion(Criteria bookingCriteria, Boolean isAppointment, String idProperty, Boolean isRelevantForAppointments, String relevantForAppointmentsProperty) {
    if (isAppointment != null) {
        if (isAppointment) {
            bookingCriteria.add(Restrictions.isNotNull(idProperty));
        } else {
            bookingCriteria.add(Restrictions.isNull(idProperty));
        }
    }
    if (isRelevantForAppointments != null) {
        bookingCriteria.createCriteria("inventory", CriteriaSpecification.INNER_JOIN).createCriteria("category", CriteriaSpecification.INNER_JOIN).add(Restrictions.eq(relevantForAppointmentsProperty, isRelevantForAppointments.booleanValue()));
    }
}

17 View Complete Implementation : EReportingSeriesDAO.java
Copyright GNU General Public License v2.0
Author : 52North
/**
 * Add EReportingSamplingPoint restriction to Hibernate Criteria
 *
 * @param c
 *            Hibernate Criteria to add restriction
 * @param samplingPoint
 *            EReportingSamplingPoint identifier to add
 */
public void addEReportingSamplingPointToCriteria(Criteria c, String samplingPoint) {
    c.createCriteria(getSamplingPointreplacedociationPath()).add(Restrictions.eq(EReportingSamplingPointEnreplacedy.IDENTIFIER, samplingPoint));
}

17 View Complete Implementation : ProbandListEntryDaoImpl.java
Copyright GNU Lesser General Public License v2.1
Author : phoenixctms
@Override
protected Collection<ProbandListEntry> handleFindByTrialProbandDepartment(Long trialId, Long probandDepartmentId) throws Exception {
    org.hibernate.Criteria listEntryCriteria = createListEntryCriteria();
    if (trialId != null) {
        listEntryCriteria.add(Restrictions.eq("trial.id", trialId.longValue()));
    }
    if (probandDepartmentId != null) {
        listEntryCriteria.createCriteria("proband", CriteriaSpecification.INNER_JOIN).add(Restrictions.eq("department.id", probandDepartmentId.longValue()));
    }
    return listEntryCriteria.list();
}

17 View Complete Implementation : TrialDaoImpl.java
Copyright GNU Lesser General Public License v2.1
Author : phoenixctms
@Override
protected Collection<Trial> handleFindByParticipatingProbandSorted(Long probandId) throws Exception {
    org.hibernate.Criteria trialCriteria = createTrialCriteria(null);
    trialCriteria.createCriteria("probandListEntries", CriteriaSpecification.INNER_JOIN).add(Restrictions.eq("proband.id", probandId.longValue()));
    trialCriteria.addOrder(Order.asc("name"));
    return trialCriteria.list();
}

17 View Complete Implementation : EReportingSeriesDAO.java
Copyright GNU General Public License v2.0
Author : 52North
private void addreplacedessmentType(Criteria c, String replacedessmentType) {
    c.createCriteria(getSamplingPointreplacedociationPath()).createCriteria(EReportingSamplingPointEnreplacedy.replacedESSMENTTYPE).add(Restrictions.ilike(EReportingreplacedessmentTypeEnreplacedy.replacedESSMENT_TYPE, replacedessmentType));
}

17 View Complete Implementation : TrialDaoImpl.java
Copyright GNU Lesser General Public License v2.1
Author : phoenixctms
@Override
protected Collection<Trial> handleFindByReimbursementProbandSorted(Long probandId, PaymentMethod method, String costType, Boolean paid) throws Exception {
    org.hibernate.Criteria trialCriteria = createTrialCriteria(null);
    Criteria payoffCriteria = trialCriteria.createCriteria("payoffs", CriteriaSpecification.INNER_JOIN);
    payoffCriteria.add(Restrictions.eq("proband.id", probandId.longValue()));
    if (method != null) {
        payoffCriteria.add(Restrictions.eq("method", method));
    }
    if (paid != null) {
        payoffCriteria.add(Restrictions.eq("paid", paid.booleanValue()));
    }
    CategoryCriterion.apply(payoffCriteria, new CategoryCriterion(costType, "costType", MatchMode.EXACT, EmptyPrefixModes.ALL_ROWS));
    trialCriteria.addOrder(Order.asc("name"));
    // trialCriteria.setResultTransformer(org.hibernate.Criteria.DISTINCT_ROOT_ENreplacedY);
    // return trialCriteria.list();
    return CriteriaUtil.listDistinctRoot(trialCriteria, this, "name");
}

17 View Complete Implementation : DaoUtil.java
Copyright Apache License 2.0
Author : tmobile
public static List<TpsLatencyHistory> getTpsAndLatOfComponent(String startDate, String endDate, String environment, String componentIdsStrg, String platform, Clreplaced enreplacedyClreplaced, SessionFactory sessionFactory, EnvironmentDao environmentDao) throws ParseException {
    Session session = sessionFactory.openSession();
    final SimpleDateFormat sdf = new SimpleDateFormat(SIMPLE_DATE_FORMAT);
    List<Integer> comIdList = convertCSVToList(componentIdsStrg);
    Date sDate = sdf.parse(startDate);
    Date eDate = sdf.parse(endDate);
    Criteria tpsLatencyCriteria = session.createCriteria(enreplacedyClreplaced, "tpsLat");
    tpsLatencyCriteria.createCriteria("tpsLat.component", "component");
    tpsLatencyCriteria.add(Restrictions.gt("tpsLat.statusDate", sDate));
    tpsLatencyCriteria.add(Restrictions.le("tpsLat.statusDate", eDate));
    if (environment != null) {
        int envId = environmentDao.getEnironmentIdFromName(environment);
        tpsLatencyCriteria.add(Restrictions.eq("tpsLat.environment.environmentId", envId));
    }
    if (platform != null && !platform.equalsIgnoreCase("All")) {
        tpsLatencyCriteria.add(Restrictions.eq("component.platform", platform));
    }
    if (comIdList.size() > 0) {
        tpsLatencyCriteria.add(Restrictions.in("component.componentId", comIdList));
    }
    List<TpsLatencyHistory> listOfTpsLatency = new ArrayList<TpsLatencyHistory>();
    if (platform.equals(Constants.PLATFORM_K8S)) {
        getK8sTpsLatency(tpsLatencyCriteria, listOfTpsLatency);
    } else if (platform.equals(Constants.PLATFORM_MESOS)) {
        getMesosTpsLatency(tpsLatencyCriteria, listOfTpsLatency);
    }
    session.close();
    return listOfTpsLatency;
}

17 View Complete Implementation : AbstractSeriesObservationDAO.java
Copyright GNU General Public License v2.0
Author : 52North
private Criteria addRestrictionsToCriteria(Criteria criteria, String procedure, String observableProperty, String featureOfInterest, String offering) throws OwsExceptionReport {
    AbstractSeriesDAO seriesDAO = getDaoFactory().getSeriesDAO();
    Criteria seriesCriteria = criteria.createCriteria(DataEnreplacedy.PROPERTY_DATASET);
    seriesDAO.addFeatureOfInterestToCriteria(seriesCriteria, featureOfInterest);
    seriesDAO.addProcedureToCriteria(seriesCriteria, procedure);
    seriesDAO.addObservablePropertyToCriteria(seriesCriteria, observableProperty);
    seriesDAO.addOfferingToCriteria(seriesCriteria, offering);
    return seriesCriteria;
}

16 View Complete Implementation : GrailsHibernateQueryUtils.java
Copyright Apache License 2.0
Author : grails
/**
 * Add order to criteria, creating necessary subCriteria if nested sort property (ie. sort:'nested.property').
 */
private static void addOrderPossiblyNested(Criteria c, PersistentEnreplacedy enreplacedy, String sort, String order, boolean ignoreCase) {
    int firstDotPos = sort.indexOf(".");
    if (firstDotPos == -1) {
        addOrder(c, sort, order, ignoreCase);
    } else {
        // nested property
        String sortHead = sort.substring(0, firstDotPos);
        String sortTail = sort.substring(firstDotPos + 1);
        PersistentProperty property = enreplacedy.getPropertyByName(sortHead);
        if (property instanceof Embedded) {
            // embedded objects cannot reference enreplacedies (at time of writing), so no more recursion needed
            addOrder(c, sort, order, ignoreCase);
        } else if (property instanceof replacedociation) {
            replacedociation a = (replacedociation) property;
            Criteria subCriteria = c.createCriteria(sortHead);
            PersistentEnreplacedy replacedociatedEnreplacedy = a.getreplacedociatedEnreplacedy();
            Clreplaced<?> propertyTargetClreplaced = replacedociatedEnreplacedy.getJavaClreplaced();
            cacheCriteriaByMapping(propertyTargetClreplaced, subCriteria);
            // Recurse on nested sort
            addOrderPossiblyNested(subCriteria, replacedociatedEnreplacedy, sortTail, order, ignoreCase);
        }
    }
}

16 View Complete Implementation : AccountingDAO.java
Copyright GNU Lesser General Public License v3.0
Author : OurGrid
/**
 * Returns te current balance of a remote peer
 * @param remotePeerPublicKey The remote peer's public key
 * @return The remote peer balance
 */
public PeerBalance getRemotePeerBalance(Peer localPeer, Peer remotePeer) {
    if (localPeer == null || remotePeer == null) {
        return null;
    }
    Criteria criteria = HibernateUtil.getSession().createCriteria(Balance.clreplaced);
    criteria.createCriteria("self").add(Restrictions.eq("DNdata", localPeer.getDNdata()));
    criteria.createCriteria("other").add(Restrictions.eq("DNdata", remotePeer.getDNdata()));
    // criteria.add(Restrictions.eq("self.DNdata", localPeer.getDNdata()));
    // criteria.add(Restrictions.eq("other.DNdata", remotePeer.getDNdata()));
    criteria.addOrder(Order.desc("balanceTime"));
    List<Balance> balances = criteria.list();
    PeerBalance balanceReturn = null;
    if (balances != null && !balances.isEmpty()) {
        Balance balance = balances.get(0);
        List<BalanceValue> values = balance.getValues();
        if (values != null) {
            balanceReturn = fillBalanceValue(values);
        }
    }
    return balanceReturn;
}

16 View Complete Implementation : WorkerDAO.java
Copyright GNU Lesser General Public License v3.0
Author : OurGrid
@SuppressWarnings("unchecked")
public WorkerStatusChange findCurrentStatus(List<IResponseTO> responses, Worker worker) {
    responses.add(LoggerUtil.enter());
    WorkerStatusChange wsc = null;
    Criteria criteria = HibernateUtil.getSession().createCriteria(WorkerStatusChange.clreplaced);
    criteria.createCriteria("worker").add(Restrictions.eq("id", worker.getId()));
    criteria.addOrder(Order.desc("timeOfChange"));
    List<WorkerStatusChange> result = criteria.list();
    if (!result.isEmpty()) {
        wsc = result.get(0);
    }
    responses.add(LoggerUtil.leave());
    return wsc;
}

16 View Complete Implementation : InventoryBookingDaoImpl.java
Copyright GNU Lesser General Public License v2.1
Author : phoenixctms
@Override
protected Collection<InventoryBooking> handleFindByAppointmentDepartmentsCalendarInterval(Long probandDepartmentId, Long courseDepartmentId, Long trialDepartmentId, String calendar, Timestamp from, Timestamp to, Boolean isProbandAppointment, Boolean isRelevantForProbandAppointments, Boolean isCourseAppointment, Boolean isRelevantForCourseAppointments, Boolean isTrialAppointment, Boolean isRelevantForTrialAppointments) throws Exception {
    Criteria bookingCriteria = createBookingCriteria();
    CriteriaUtil.applyClosedIntervalCriterion(bookingCriteria, from, to, null);
    if (probandDepartmentId != null) {
        bookingCriteria.createCriteria("proband", CriteriaSpecification.LEFT_JOIN).add(Restrictions.or(Restrictions.isNull("department.id"), Restrictions.eq("department.id", probandDepartmentId.longValue())));
    }
    if (courseDepartmentId != null) {
        bookingCriteria.createCriteria("course", CriteriaSpecification.LEFT_JOIN).add(Restrictions.or(Restrictions.isNull("department.id"), Restrictions.eq("department.id", courseDepartmentId.longValue())));
    }
    if (trialDepartmentId != null) {
        bookingCriteria.createCriteria("trial", CriteriaSpecification.LEFT_JOIN).add(Restrictions.or(Restrictions.isNull("department.id"), Restrictions.eq("department.id", trialDepartmentId.longValue())));
    }
    applyIncludeAppointmentsCriterion(bookingCriteria, isProbandAppointment, "proband.id", isRelevantForProbandAppointments, "relevantForProbandAppointments");
    applyIncludeAppointmentsCriterion(bookingCriteria, isCourseAppointment, "course.id", isRelevantForCourseAppointments, "relevantForCourseAppointments");
    applyIncludeAppointmentsCriterion(bookingCriteria, isTrialAppointment, "trial.id", isRelevantForTrialAppointments, "relevantForTrialAppointments");
    CategoryCriterion.apply(bookingCriteria, new CategoryCriterion(calendar, "calendar", MatchMode.EXACT, EmptyPrefixModes.ALL_ROWS));
    bookingCriteria.addOrder(Order.asc("start"));
    return bookingCriteria.list();
}

16 View Complete Implementation : InventoryBookingDaoImpl.java
Copyright GNU Lesser General Public License v2.1
Author : phoenixctms
/**
 * @inheritDoc
 */
@Override
protected Collection<InventoryBooking> handleFindByProbandCalendarInterval(Long probandId, String calendar, Timestamp from, Timestamp to, Boolean isRelevantForProbandAppointments) throws Exception {
    Criteria bookingCriteria = createBookingCriteria();
    CriteriaUtil.applyClosedIntervalCriterion(bookingCriteria, from, to, null);
    if (probandId != null) {
        bookingCriteria.add(Restrictions.eq("proband.id", probandId.longValue()));
    }
    if (isRelevantForProbandAppointments != null) {
        bookingCriteria.createCriteria("inventory", CriteriaSpecification.INNER_JOIN).createCriteria("category", CriteriaSpecification.INNER_JOIN).add(Restrictions.eq("relevantForProbandAppointments", isRelevantForProbandAppointments.booleanValue()));
    }
    CategoryCriterion.apply(bookingCriteria, new CategoryCriterion(calendar, "calendar", MatchMode.EXACT, EmptyPrefixModes.ALL_ROWS));
    return bookingCriteria.list();
}

16 View Complete Implementation : InventoryBookingDaoImpl.java
Copyright GNU Lesser General Public License v2.1
Author : phoenixctms
@Override
protected Collection<InventoryBooking> handleFindByTrialCalendarInterval(Long trialId, String calendar, Timestamp from, Timestamp to, Boolean isRelevantForTrialAppointments) throws Exception {
    Criteria bookingCriteria = createBookingCriteria();
    CriteriaUtil.applyClosedIntervalCriterion(bookingCriteria, from, to, null);
    if (trialId != null) {
        bookingCriteria.add(Restrictions.eq("trial.id", trialId.longValue()));
    }
    if (isRelevantForTrialAppointments != null) {
        bookingCriteria.createCriteria("inventory", CriteriaSpecification.INNER_JOIN).createCriteria("category", CriteriaSpecification.INNER_JOIN).add(Restrictions.eq("relevantForTrialAppointments", isRelevantForTrialAppointments.booleanValue()));
    }
    CategoryCriterion.apply(bookingCriteria, new CategoryCriterion(calendar, "calendar", MatchMode.EXACT, EmptyPrefixModes.ALL_ROWS));
    return bookingCriteria.list();
}

16 View Complete Implementation : InventoryBookingDaoImpl.java
Copyright GNU Lesser General Public License v2.1
Author : phoenixctms
@Override
protected Collection<InventoryBooking> handleFindByDepartmentCategoryInventoryOnBehalfOfProbandCourseTrialCalendarInterval(Long departmentId, Long inventoryCategoryId, Long inventoryId, Long onBehalfOfId, Long probandId, Long courseId, Long trialId, String calendar, Timestamp from, Timestamp to) throws Exception {
    Criteria bookingCriteria = createBookingCriteria();
    CriteriaUtil.applyClosedIntervalCriterion(bookingCriteria, from, to, null);
    if (departmentId != null || inventoryCategoryId != null) {
        Criteria inventoryCriteria = bookingCriteria.createCriteria("inventory", CriteriaSpecification.INNER_JOIN);
        if (departmentId != null) {
            inventoryCriteria.add(Restrictions.eq("department.id", departmentId.longValue()));
        }
        if (inventoryCategoryId != null) {
            inventoryCriteria.add(Restrictions.eq("category.id", inventoryCategoryId.longValue()));
        }
    }
    if (inventoryId != null) {
        bookingCriteria.add(Restrictions.eq("inventory.id", inventoryId.longValue()));
    }
    if (onBehalfOfId != null) {
        bookingCriteria.add(Restrictions.eq("onBehalfOf.id", onBehalfOfId.longValue()));
    }
    if (probandId != null) {
        bookingCriteria.add(Restrictions.eq("proband.id", probandId.longValue()));
    }
    if (courseId != null) {
        bookingCriteria.add(Restrictions.eq("course.id", courseId.longValue()));
    }
    if (trialId != null) {
        bookingCriteria.add(Restrictions.eq("trial.id", trialId.longValue()));
    }
    CategoryCriterion.apply(bookingCriteria, new CategoryCriterion(calendar, "calendar", MatchMode.EXACT, EmptyPrefixModes.ALL_ROWS));
    return bookingCriteria.list();
}

16 View Complete Implementation : InventoryBookingDaoImpl.java
Copyright GNU Lesser General Public License v2.1
Author : phoenixctms
@Override
protected Collection<String> handleFindCalendars(Long inventoryDepartmentId, Long inventoryId, Long probandId, Long courseId, Long trialId, String calendarPrefix, Integer limit) throws Exception {
    Criteria bookingCriteria = createBookingCriteria();
    if (inventoryId != null) {
        bookingCriteria.add(Restrictions.eq("inventory.id", inventoryId.longValue()));
    }
    if (inventoryDepartmentId != null) {
        Criteria inventoryCriteria = bookingCriteria.createCriteria("inventory", CriteriaSpecification.INNER_JOIN);
        inventoryCriteria.add(Restrictions.eq("department.id", inventoryDepartmentId.longValue()));
    }
    if (probandId != null) {
        bookingCriteria.add(Restrictions.eq("proband.id", probandId.longValue()));
    }
    if (courseId != null) {
        bookingCriteria.add(Restrictions.eq("course.id", courseId.longValue()));
    }
    if (trialId != null) {
        bookingCriteria.add(Restrictions.eq("trial.id", trialId.longValue()));
    }
    CategoryCriterion.apply(bookingCriteria, new CategoryCriterion(calendarPrefix, "calendar", MatchMode.START));
    bookingCriteria.addOrder(Order.asc("calendar"));
    bookingCriteria.setProjection(Projections.distinct(Projections.property("calendar")));
    CriteriaUtil.applyLimit(limit, Settings.getIntNullable(SettingCodes.INVENTORY_BOOKING_CALENDAR_AUTOCOMPLETE_DEFAULT_RESULT_LIMIT, Bundle.SETTINGS, DefaultSettings.INVENTORY_BOOKING_CALENDAR_AUTOCOMPLETE_DEFAULT_RESULT_LIMIT), bookingCriteria);
    return bookingCriteria.list();
}

16 View Complete Implementation : ProbandListEntryDaoImpl.java
Copyright GNU Lesser General Public License v2.1
Author : phoenixctms
private static Criteria applyStratificationTagValuesCriterions(org.hibernate.Criteria listEntryCriteria, Set<Long> selectionSetValueIds) {
    org.hibernate.Criteria tagValuesCriteria = listEntryCriteria.createCriteria("tagValues", CriteriaSpecification.INNER_JOIN);
    tagValuesCriteria.createCriteria("tag", CriteriaSpecification.INNER_JOIN).add(Restrictions.eq("stratification", true));
    org.hibernate.Criteria selectionValuesCriteria = // "selectionValues0",
    tagValuesCriteria.createCriteria("value", CriteriaSpecification.INNER_JOIN).createCriteria(// "selectionValues0",
    "selectionValues", CriteriaSpecification.INNER_JOIN);
    selectionValuesCriteria.add(Restrictions.in("id", selectionSetValueIds));
    ProjectionList proj = Projections.projectionList();
    proj.add(Projections.id());
    proj.add(Projections.sqlGroupProjection("count(*) as selectionValuesCount", "{alias}.id having count(*) = " + selectionSetValueIds.size(), new String[] { "selectionValuesCount" }, new org.hibernate.type.Type[] { Hibernate.LONG }));
    listEntryCriteria.setProjection(proj);
    return listEntryCriteria;
}

16 View Complete Implementation : TimelineEventDaoImpl.java
Copyright GNU Lesser General Public License v2.1
Author : phoenixctms
@Override
protected Collection<TimelineEvent> handleFindByTrialDepartmentStatusTypeShowInterval(Long trialId, Long departmentId, Long statusId, Long typeId, Boolean show, Timestamp from, Timestamp to) throws Exception {
    Criteria timelineEventCriteria = createTimelineEventCriteria();
    CriteriaUtil.applyStopOptionalIntervalCriterion(timelineEventCriteria, from, to, null, true);
    if (trialId != null || departmentId != null || statusId != null) {
        Criteria trialCriteria = timelineEventCriteria.createCriteria("trial", CriteriaSpecification.INNER_JOIN);
        if (trialId != null) {
            trialCriteria.add(Restrictions.idEq(trialId.longValue()));
        }
        if (departmentId != null) {
            trialCriteria.add(Restrictions.eq("department.id", departmentId.longValue()));
        }
        if (statusId != null) {
            trialCriteria.add(Restrictions.eq("status.id", statusId.longValue()));
        }
    }
    if (typeId != null) {
        timelineEventCriteria.add(Restrictions.eq("type.id", typeId.longValue()));
    }
    if (show != null) {
        timelineEventCriteria.add(Restrictions.eq("show", show.booleanValue()));
    }
    return timelineEventCriteria.list();
}

16 View Complete Implementation : TimelineEventDaoImpl.java
Copyright GNU Lesser General Public License v2.1
Author : phoenixctms
@Override
protected Collection<TimelineEvent> handleFindByTrialDepartmentMemberInterval(Long trialId, Long departmentId, Long teamMemberStaffId, Boolean notify, Boolean ignoreTimelineEvents, Timestamp from, Timestamp to) throws Exception {
    Criteria timelineEventCriteria = createTimelineEventCriteria();
    CriteriaUtil.applyStopOptionalIntervalCriterion(timelineEventCriteria, from, to, null, true);
    boolean distinctRoot = false;
    if (trialId != null || departmentId != null || teamMemberStaffId != null || ignoreTimelineEvents != null) {
        Criteria trialCriteria = timelineEventCriteria.createCriteria("trial", CriteriaSpecification.INNER_JOIN);
        if (trialId != null) {
            trialCriteria.add(Restrictions.idEq(trialId.longValue()));
        }
        if (departmentId != null) {
            trialCriteria.add(Restrictions.eq("department.id", departmentId.longValue()));
        }
        if (ignoreTimelineEvents != null) {
            trialCriteria.createCriteria("status", CriteriaSpecification.INNER_JOIN).add(Restrictions.eq("ignoreTimelineEvents", ignoreTimelineEvents.booleanValue()));
        }
        if (teamMemberStaffId != null) {
            Criteria membersCriteria = trialCriteria.createCriteria("members", CriteriaSpecification.INNER_JOIN);
            if (notify != null) {
                membersCriteria.add(Restrictions.eq("notifyTimelineEvent", notify.booleanValue()));
            }
            membersCriteria.add(Restrictions.eq("staff.id", teamMemberStaffId.longValue()));
            // timelineEventCriteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENreplacedY);
            distinctRoot = true;
        }
    }
    // performance only...
    timelineEventCriteria.add(Restrictions.eq("dismissed", false));
    if (distinctRoot) {
        return CriteriaUtil.listEvents(CriteriaUtil.listDistinctRoot(timelineEventCriteria, this), from, to, notify);
    } else {
        return CriteriaUtil.listEvents(timelineEventCriteria, from, to, notify);
    }
}

16 View Complete Implementation : TrialDaoImpl.java
Copyright GNU Lesser General Public License v2.1
Author : phoenixctms
@Override
protected Collection<Trial> handleFindByInquiryValuesProbandSorted(Long departmentId, Long probandId, Boolean active, Boolean activeSignup) throws Exception {
    org.hibernate.Criteria trialCriteria = createTrialCriteria("trial0");
    if (departmentId != null) {
        trialCriteria.add(Restrictions.eq("department.id", departmentId.longValue()));
    }
    org.hibernate.Criteria statusCriteria = trialCriteria.createCriteria("status", "trialStatus", CriteriaSpecification.INNER_JOIN);
    // IMPL!!!!
    DetachedCriteria valuesSubQuery = DetachedCriteria.forClreplaced(InquiryValueImpl.clreplaced, "inquiryValue");
    valuesSubQuery.setProjection(Projections.rowCount());
    valuesSubQuery.add(Restrictions.eq("proband.id", probandId.longValue()));
    // if (active != null || activeSignup != null) {
    DetachedCriteria inquiriesSubQuery = valuesSubQuery.createCriteria("inquiry", "inquiry0", CriteriaSpecification.INNER_JOIN);
    inquiriesSubQuery.add(Restrictions.eqProperty("trial.id", "trial0.id"));
    if (active != null) {
        inquiriesSubQuery.add(Restrictions.eq("active", active.booleanValue()));
    }
    if (activeSignup != null) {
        inquiriesSubQuery.add(Restrictions.eq("activeSignup", activeSignup.booleanValue()));
    }
    // IMPL!!!!
    inquiriesSubQuery = DetachedCriteria.forClreplaced(InquiryImpl.clreplaced, "inquiry1");
    inquiriesSubQuery.setProjection(Projections.rowCount());
    inquiriesSubQuery.add(Restrictions.eqProperty("trial.id", "trial0.id"));
    if (active != null) {
        inquiriesSubQuery.add(Restrictions.eq("active", active.booleanValue()));
    }
    if (activeSignup != null) {
        inquiriesSubQuery.add(Restrictions.eq("activeSignup", activeSignup.booleanValue()));
    }
    // }
    trialCriteria.add(Restrictions.or(Subqueries.lt(0l, valuesSubQuery), Restrictions.and(Subqueries.lt(0l, inquiriesSubQuery), Restrictions.and(Restrictions.eq("trialStatus.inquiryValueInputEnabled", true), Restrictions.eq("trialStatus.lockdown", false)))));
    trialCriteria.addOrder(Order.asc("name"));
    return trialCriteria.list();
}

16 View Complete Implementation : TrialDaoImpl.java
Copyright GNU Lesser General Public License v2.1
Author : phoenixctms
@Override
protected Collection<Trial> handleFindBySignup(Long departmentId, boolean ignoreSignupInquiries, PSFVO psf) throws Exception {
    org.hibernate.Criteria trialCriteria = createTrialCriteria("trial0");
    SubCriteriaMap criteriaMap = new SubCriteriaMap(Trial.clreplaced, trialCriteria);
    if (departmentId != null) {
        trialCriteria.add(Restrictions.eq("department.id", departmentId.longValue()));
    }
    org.hibernate.Criteria statusCriteria = trialCriteria.createCriteria("status", "trialStatus", CriteriaSpecification.INNER_JOIN);
    statusCriteria.add(Restrictions.eq("lockdown", false));
    // IMPL!!!!
    DetachedCriteria subQuery = DetachedCriteria.forClreplaced(InquiryImpl.clreplaced, "inquiry");
    subQuery.setProjection(Projections.rowCount());
    subQuery.add(Restrictions.eqProperty("trial.id", "trial0.id"));
    subQuery.add(Restrictions.eq("activeSignup", true));
    trialCriteria.add(Restrictions.or(Restrictions.eq("signupProbandList", true), Restrictions.and(ignoreSignupInquiries ? Subqueries.lt(0l, subQuery) : Restrictions.and(Restrictions.eq("signupInquiries", true), Subqueries.lt(0l, subQuery)), Restrictions.eq("trialStatus.inquiryValueInputEnabled", true))));
    // if (probandList != null) {
    // trialCriteria.add(Restrictions.eq("signupProbandList", probandList.booleanValue()));
    // }
    // if (inquiries != null) {
    // trialCriteria.add(Restrictions.eq("signupInquiries", inquiries.booleanValue()));
    // statusCriteria.add(Restrictions.eq("inquiryValueInputEnabled", true));
    // trialCriteria.add(Restrictions.sizeGt("inquiries", 0));
    // }
    CriteriaUtil.applyPSFVO(criteriaMap, psf);
    return trialCriteria.list();
}

16 View Complete Implementation : VisitScheduleItemDaoImpl.java
Copyright GNU Lesser General Public License v2.1
Author : phoenixctms
@Override
protected Collection<VisitScheduleItem> handleFindByTrialDepartmentStatusTypeIntervalId(Long trialId, Long departmentId, Long statusId, Long visitTypeId, Timestamp from, Timestamp to, Long id) throws Exception {
    Criteria visitScheduleItemCriteria = createVisitScheduleItemCriteria("visitScheduleItem");
    org.hibernate.criterion.Criterion idCriterion;
    if (id != null) {
        idCriterion = Restrictions.eq("visitScheduleItem.id", id.longValue());
    } else {
        idCriterion = null;
    }
    CriteriaUtil.applyClosedIntervalCriterion(visitScheduleItemCriteria, from, to, idCriterion);
    if (trialId != null || departmentId != null || statusId != null) {
        // ? inner join because trial is never null
        Criteria trialCriteria = visitScheduleItemCriteria.createCriteria("trial", CriteriaSpecification.INNER_JOIN);
        if (trialId != null) {
            trialCriteria.add(CriteriaUtil.applyOr(Restrictions.idEq(trialId.longValue()), idCriterion));
        }
        if (departmentId != null) {
            trialCriteria.add(CriteriaUtil.applyOr(Restrictions.eq("department.id", departmentId.longValue()), idCriterion));
        }
        if (statusId != null) {
            trialCriteria.add(CriteriaUtil.applyOr(Restrictions.eq("status.id", statusId.longValue()), idCriterion));
        }
    }
    if (visitTypeId != null) {
        // ? inner join because trial is never null
        Criteria visitCriteria = visitScheduleItemCriteria.createCriteria("visit", CriteriaSpecification.INNER_JOIN);
        visitCriteria.add(CriteriaUtil.applyOr(Restrictions.eq("type.id", visitTypeId.longValue()), idCriterion));
    }
    return visitScheduleItemCriteria.list();
}

16 View Complete Implementation : VisitScheduleItemDaoImpl.java
Copyright GNU Lesser General Public License v2.1
Author : phoenixctms
@Override
protected Collection<VisitScheduleItem> handleFindByDepartmentTravelInterval(Long departmentId, Timestamp from, Timestamp to, Boolean travel) throws Exception {
    Criteria visitScheduleItemCriteria = createVisitScheduleItemCriteria("visitScheduleItem");
    CriteriaUtil.applyClosedIntervalCriterion(visitScheduleItemCriteria, from, to, null);
    if (departmentId != null) {
        visitScheduleItemCriteria.createCriteria("trial").add(Restrictions.eq("department.id", departmentId.longValue()));
    }
    if (travel != null) {
        visitScheduleItemCriteria.createCriteria("visit.type", CriteriaSpecification.LEFT_JOIN).add(Restrictions.or(Restrictions.eq("travel", travel.booleanValue()), Restrictions.isNull("visitScheduleItem.visit")));
    }
    return visitScheduleItemCriteria.list();
}

16 View Complete Implementation : OfferingDAO.java
Copyright GNU General Public License v2.0
Author : 52North
private void addOfferingRestrictionFor(Criteria c, String offering, String replacedociationPath) {
    c.createCriteria(replacedociationPath).add(Restrictions.eq(OfferingEnreplacedy.IDENTIFIER, offering));
}

15 View Complete Implementation : AbstractSeriesObservationDAO.java
Copyright GNU General Public License v2.0
Author : 52North
private Criteria getDefaultSeriesObservationCriteria(Criteria criteria) {
    Criteria seriesCriteria = criteria.createCriteria(DataEnreplacedy.PROPERTY_DATASET);
    seriesCriteria.add(Restrictions.eq(DatasetEnreplacedy.PROPERTY_PUBLISHED, true));
    return seriesCriteria;
}

15 View Complete Implementation : OfferingDAO.java
Copyright GNU General Public License v2.0
Author : 52North
/**
 * Add offering identifier restriction to Hibernate Criteria
 *
 * @param c
 *            Hibernate Criteria to add restriction
 * @param offering
 *            Offering identifier
 */
public void addOfferingRestricionForObservation(Criteria c, String offering) {
    c.createCriteria(DataEnreplacedy.PROPERTY_DATASET).createCriteria(DatasetEnreplacedy.PROPERTY_OFFERING).add(Restrictions.eq(OfferingEnreplacedy.IDENTIFIER, offering));
}

15 View Complete Implementation : AggregatorDAO.java
Copyright GNU Lesser General Public License v3.0
Author : OurGrid
private AG_Worker getExistingWorker(AG_Worker worker, String peerAddress) {
    Criteria criteria = HibernateUtil.getSession().createCriteria(AG_Worker.clreplaced);
    criteria.add(Restrictions.eq("address", worker.getAddress()));
    Criteria peerCriteria = criteria.createCriteria("peer");
    peerCriteria.add(Restrictions.eq("address", peerAddress));
    return (AG_Worker) criteria.uniqueResult();
}

15 View Complete Implementation : AggregatorDAO.java
Copyright GNU Lesser General Public License v3.0
Author : OurGrid
private boolean hasNotExistingWorkerStatusChange(String workerAddress, long timeOfChange) {
    Criteria criteria = HibernateUtil.getSession().createCriteria(AG_WorkerStatusChange.clreplaced);
    criteria.add(Restrictions.eq("timeOfChange", timeOfChange));
    Criteria workerCriteria = criteria.createCriteria("worker");
    workerCriteria.add(Restrictions.eq("address", workerAddress));
    return criteria.list().isEmpty();
}