Example usage for com.liferay.portal.kernel.dao.orm ProjectionFactoryUtil avg

Introduction

In this page you can find the example usage for com.liferay.portal.kernel.dao.orm ProjectionFactoryUtil avg.

Prototype

public static Projection avg(String propertyName) 

Source Link

Usage

From source file:com.cmcti.cmts.domain.service.impl.CableModemLocalServiceImpl.java

License:Open Source License

@SuppressWarnings({ "rawtypes" })
public List getAvgValueForUpstream(long cmtsId, int ifIndex, int status) throws SystemException {

    DynamicQuery query = dynamicQuery();

    // restrictions
    query.add(RestrictionsFactoryUtil.eq("cmtsId", cmtsId));
    query.add(RestrictionsFactoryUtil.eq("ucIfIndex", ifIndex));
    query.add(RestrictionsFactoryUtil.eq("status", status));
    query.add(RestrictionsFactoryUtil.ne("dsSNR", 0));
    query.add(RestrictionsFactoryUtil.ne("usPower", 0));
    query.add(RestrictionsFactoryUtil.ne("dsSNR", 129));
    query.add(RestrictionsFactoryUtil.ne("usPower", 129));

    // projection
    query.setProjection(ProjectionFactoryUtil.projectionList().add(ProjectionFactoryUtil.avg("microRef"))
            .add(ProjectionFactoryUtil.avg("rxPower")).add(ProjectionFactoryUtil.avg("txPower"))
            .add(ProjectionFactoryUtil.avg("usPower")).add(ProjectionFactoryUtil.avg("dsPower"))
            .add(ProjectionFactoryUtil.avg("dsSNR")));

    query.setLimit(0, 1);//from   ww  w  . j ava  2 s  .  co m

    return dynamicQuery(query);
}

---

From source file:com.liferay.lms.service.impl.CourseResultLocalServiceImpl.java

License:Open Source License

public Double avgResult(long courseId, boolean passed) throws SystemException {
    ClassLoader classLoader = (ClassLoader) PortletBeanLocatorUtil.locate(ClpSerializer.getServletContextName(),
            "portletClassLoader");
    DynamicQuery dq = DynamicQueryFactoryUtil.forClass(CourseResult.class, classLoader);
    Criterion criterion = PropertyFactoryUtil.forName("courseId").eq(courseId);
    dq.add(criterion);//from w w  w.  j a  va 2  s .c  o  m
    criterion = PropertyFactoryUtil.forName("passed").eq(passed);
    dq.add(criterion);
    dq.setProjection(ProjectionFactoryUtil.avg("result"));
    return (Double) (learningActivityResultPersistence.findWithDynamicQuery(dq).get(0));
}

---

From source file:com.liferay.lms.service.impl.CourseResultLocalServiceImpl.java

License:Open Source License

public Double avgResult(long courseId) throws SystemException {
    ClassLoader classLoader = (ClassLoader) PortletBeanLocatorUtil.locate(ClpSerializer.getServletContextName(),
            "portletClassLoader");
    DynamicQuery dq = DynamicQueryFactoryUtil.forClass(CourseResult.class, classLoader);
    Criterion criterion = PropertyFactoryUtil.forName("courseId").eq(courseId);
    dq.add(criterion);// ww w . j  a v a2  s  . c om
    dq.setProjection(ProjectionFactoryUtil.avg("result"));
    return (Double) (learningActivityResultPersistence.findWithDynamicQuery(dq).get(0));
}

---

From source file:com.liferay.lms.service.impl.CourseResultLocalServiceImpl.java

License:Open Source License

public Double avgStudentsResult(Course course, boolean passed) throws SystemException {
    List<User> students = CourseLocalServiceUtil.getStudentsFromCourse(course.getCompanyId(),
            course.getGroupCreatedId());

    ClassLoader classLoader = (ClassLoader) PortletBeanLocatorUtil.locate(ClpSerializer.getServletContextName(),
            "portletClassLoader");
    DynamicQuery consulta = DynamicQueryFactoryUtil.forClass(CourseResult.class, classLoader)
            .add(PropertyFactoryUtil.forName("courseId").eq(course.getCourseId()));

    if (Validator.isNotNull(students) && students.size() > 0) {
        Criterion criterion = null;//w w w.j  a va2 s .  c o  m
        for (int i = 0; i < students.size(); i++) {
            if (i == 0) {
                criterion = RestrictionsFactoryUtil.like("userId", students.get(i).getUserId());
            } else {
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.like("userId", students.get(i).getUserId()));
            }
        }
        if (Validator.isNotNull(criterion)) {
            criterion = RestrictionsFactoryUtil.and(criterion, RestrictionsFactoryUtil.eq("passed", passed));
            consulta.add(criterion);
        }
    }
    consulta.setProjection(ProjectionFactoryUtil.avg("result"));
    return (Double) (learningActivityResultPersistence.findWithDynamicQuery(consulta).get(0));
}

---

From source file:com.liferay.lms.service.impl.LearningActivityResultLocalServiceImpl.java

License:Open Source License

public Double avgResult(long actId) throws SystemException {
    ClassLoader classLoader = (ClassLoader) PortletBeanLocatorUtil.locate(ClpSerializer.getServletContextName(),
            "portletClassLoader");
    DynamicQuery dq = DynamicQueryFactoryUtil.forClass(LearningActivityResult.class, classLoader);
    Criterion criterion = PropertyFactoryUtil.forName("actId").eq(actId);
    dq.add(criterion);/*from  w ww  .j a v a 2  s .  c om*/
    criterion = PropertyFactoryUtil.forName("endDate").isNotNull();
    dq.add(criterion);
    dq.setProjection(ProjectionFactoryUtil.avg("result"));
    return (Double) (learningActivityResultPersistence.findWithDynamicQuery(dq).get(0));
}

---

From source file:com.liferay.lms.service.impl.LearningActivityResultLocalServiceImpl.java

License:Open Source License

public Double avgResultOnlyStudents(long actId, long companyId, long courseGropupCreatedId)
        throws SystemException {
    ClassLoader classLoader = (ClassLoader) PortletBeanLocatorUtil.locate(ClpSerializer.getServletContextName(),
            "portletClassLoader");
    DynamicQuery dq = DynamicQueryFactoryUtil.forClass(LearningActivityResult.class, classLoader);
    Criterion criterion = PropertyFactoryUtil.forName("actId").eq(actId);
    dq.add(criterion);//from w w w. ja  v a 2 s  .  c  om
    criterion = PropertyFactoryUtil.forName("endDate").isNotNull();
    dq.add(criterion);

    List<User> students = CourseLocalServiceUtil.getStudentsFromCourse(companyId, courseGropupCreatedId);
    if (Validator.isNotNull(students) && students.size() > 0) {
        for (int i = 0; i < students.size(); i++) {
            if (i == 0) {
                criterion = RestrictionsFactoryUtil.like("userId", students.get(i).getUserId());
            } else {
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.like("userId", students.get(i).getUserId()));
            }
        }
    }
    dq.add(criterion);

    dq.setProjection(ProjectionFactoryUtil.avg("result"));
    return (Double) (learningActivityResultPersistence.findWithDynamicQuery(dq).get(0));
}

---

From source file:net.sareweb.txotx.service.impl.GertaeraLocalServiceImpl.java

License:Open Source License

public double getBalorazioBB(long lekuId) throws SystemException {
    DynamicQuery dq = DynamicQueryFactoryUtil.forClass(Gertaera.class);
    Criterion sagardotegiCr = PropertyFactoryUtil.forName("sagardotegiId").eq(lekuId);
    dq.add(sagardotegiCr);//from w  w w.  j  av  a  2s.c om

    Criterion gertaeraMotaCr = PropertyFactoryUtil.forName("gertaeraMota").eq("GERTAERA_MOTA_BALORAZIOA");
    dq.add(gertaeraMotaCr);

    dq.setProjection(ProjectionFactoryUtil.avg("balorazioa"));
    List<Double> results = GertaeraLocalServiceUtil.dynamicQuery(dq);
    if (results != null) {
        return results.get(0);
    } else {
        return 0;
    }
}

---