Example usage for com.liferay.portal.kernel.dao.orm Type DOUBLE

Introduction

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

Prototype

Type DOUBLE

To view the source code for com.liferay.portal.kernel.dao.orm Type DOUBLE.

Click Source Link

Usage

From source file:com.inkwell.internet.slogan.service.persistence.SloganFinderImpl.java

License:Open Source License

public List<Slogan> findByRatingsStats(long groupId, int status, int start, int end) throws SystemException {

    long classNameId = PortalUtil.getClassNameId("com.inkwell.internet.slogan.model.Slogan");

    Session session = null;/*from  w ww .  jav a2  s . co  m*/

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(FIND_BY_RATINGSSTATS);

        SQLQuery q = session.createSQLQuery(sql);

        q.addScalar("averageScore", Type.DOUBLE);
        q.addScalar("sloganId", Type.LONG);
        q.addScalar("sloganText", Type.STRING);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(groupId);
        qPos.add(status);
        qPos.add(classNameId);

        List<Object[]> ratedSlogans = (List<Object[]>) QueryUtil.list(q, getDialect(), start, end);

        List<Slogan> slogans = assembleSlogans(ratedSlogans);

        return slogans;
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

---

From source file:com.liferay.journal.service.persistence.impl.JournalFolderFinderImpl.java

License:Open Source License

protected List<Object> doFindF_A_ByG_F(long groupId, long folderId, QueryDefinition<?> queryDefinition,
        boolean inlineSQLHelper) {

    Session session = null;//w  ww  .ja va 2  s  .  c  o m

    try {
        session = openSession();

        StringBundler sb = new StringBundler(5);

        sb.append(StringPool.OPEN_PARENTHESIS);
        sb.append(getFoldersSQL(FIND_F_BY_G_F, groupId, queryDefinition, inlineSQLHelper));
        sb.append(") UNION ALL (");
        sb.append(getArticlesSQL(FIND_A_BY_G_U_F, groupId, queryDefinition, inlineSQLHelper));
        sb.append(StringPool.CLOSE_PARENTHESIS);

        String sql = updateSQL(sb.toString(), folderId);

        sql = CustomSQLUtil.replaceOrderBy(sql, queryDefinition.getOrderByComparator());

        SQLQuery q = session.createSynchronizedSQLQuery(sql);

        q.addScalar("modelFolderId", Type.LONG);
        q.addScalar("modelFolder", Type.LONG);
        q.addScalar("articleId", Type.STRING);
        q.addScalar("version", Type.DOUBLE);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(groupId);
        qPos.add(queryDefinition.getStatus());

        if (folderId >= 0) {
            qPos.add(folderId);
        }

        qPos.add(groupId);

        if (queryDefinition.getOwnerUserId() > 0) {
            qPos.add(queryDefinition.getOwnerUserId());
            qPos.add(WorkflowConstants.STATUS_IN_TRASH);
        }

        qPos.add(queryDefinition.getStatus());

        if (folderId >= 0) {
            qPos.add(folderId);
        }

        List<Object> models = new ArrayList<>();

        Iterator<Object[]> itr = (Iterator<Object[]>) QueryUtil.iterate(q, getDialect(),
                queryDefinition.getStart(), queryDefinition.getEnd());

        while (itr.hasNext()) {
            Object[] array = itr.next();

            long curFolderId = (Long) array[0];
            long modelFolder = (Long) array[1];

            Object obj = null;

            if (modelFolder == 1) {
                obj = JournalFolderUtil.findByPrimaryKey(curFolderId);
            } else {
                String articleId = (String) array[2];
                double version = (Double) array[3];

                obj = JournalArticleUtil.findByG_A_V(groupId, articleId, version);
            }

            models.add(obj);
        }

        return models;
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

---

From source file:com.liferay.journal.service.persistence.impl.JournalFolderFinderImpl.java

License:Open Source License

protected List<Object> doFindF_A_ByG_F_L(long groupId, long folderId, Locale locale,
        QueryDefinition<?> queryDefinition, boolean inlineSQLHelper) {

    Session session = null;/*from ww w .j  a  va2s .c  om*/

    try {
        session = openSession();

        StringBundler sb = new StringBundler(5);

        sb.append(StringPool.OPEN_PARENTHESIS);
        sb.append(getFoldersSQL(FIND_F_BY_G_F_L, groupId, queryDefinition, inlineSQLHelper));
        sb.append(") UNION ALL (");
        sb.append(getArticlesSQL(FIND_A_BY_G_U_F_L, groupId, queryDefinition, inlineSQLHelper));
        sb.append(StringPool.CLOSE_PARENTHESIS);

        String sql = updateSQL(sb.toString(), folderId);

        sql = CustomSQLUtil.replaceOrderBy(sql, queryDefinition.getOrderByComparator());

        SQLQuery q = session.createSynchronizedSQLQuery(sql);

        q.addScalar("modelFolderId", Type.LONG);
        q.addScalar("modelFolder", Type.LONG);
        q.addScalar("articleId", Type.STRING);
        q.addScalar("version", Type.DOUBLE);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(groupId);
        qPos.add(queryDefinition.getStatus());

        if (folderId >= 0) {
            qPos.add(folderId);
        }

        qPos.add(groupId);

        if (queryDefinition.getOwnerUserId() > 0) {
            qPos.add(queryDefinition.getOwnerUserId());
            qPos.add(WorkflowConstants.STATUS_IN_TRASH);
        }

        qPos.add(queryDefinition.getStatus());

        if (folderId >= 0) {
            qPos.add(folderId);
        }

        qPos.add(LocaleUtil.toLanguageId(locale));

        List<Object> models = new ArrayList<>();

        Iterator<Object[]> itr = (Iterator<Object[]>) QueryUtil.iterate(q, getDialect(),
                queryDefinition.getStart(), queryDefinition.getEnd());

        while (itr.hasNext()) {
            Object[] array = itr.next();

            long curFolderId = (Long) array[0];
            long modelFolder = (Long) array[1];

            Object obj = null;

            if (modelFolder == 1) {
                obj = JournalFolderUtil.findByPrimaryKey(curFolderId);
            } else {
                String articleId = (String) array[2];
                double version = (Double) array[3];

                obj = JournalArticleUtil.findByG_A_V(groupId, articleId, version);
            }

            models.add(obj);
        }

        return models;
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

---

From source file:com.liferay.timesheet.service.persistence.ExpenseFinderImpl.java

License:Open Source License

public double sumByProject(long projectId) throws SystemException {

    Session session = null;//from   w  ww .j ava2s.c o  m

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(SUM_BY_P);

        SQLQuery q = session.createSQLQuery(sql);

        QueryPos qPos = QueryPos.getInstance(q);

        q.addScalar("ExpenseTotal", Type.DOUBLE);

        qPos.add(projectId);

        Iterator<Double> itr = q.list().iterator();

        if (itr.hasNext()) {
            Double sum = itr.next();

            if (sum != null) {
                return sum.doubleValue();
            }
        }

        return 0;
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

---

From source file:com.liferay.timesheet.service.persistence.TaskFinderImpl.java

License:Open Source License

public double sumHoursByProject(long projectId) throws SystemException {

    Session session = null;/*  ww  w . j av  a2s .c  o  m*/

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(SUM_H_BY_P);

        SQLQuery q = session.createSQLQuery(sql);

        QueryPos qPos = QueryPos.getInstance(q);

        q.addScalar("Hours", Type.DOUBLE);

        qPos.add(projectId);

        Iterator<Double> itr = q.list().iterator();

        if (itr.hasNext()) {
            Double sum = itr.next();

            if (sum != null) {
                return sum.doubleValue();
            }
        }

        return 0;
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

---

From source file:org.tvd.thptty.slogan.service.persistence.SloganFinderImpl.java

License:Open Source License

public List<Slogan> findByRatingsStats(long groupId, int status, int start, int end) throws SystemException {

    long classNameId = PortalUtil.getClassNameId("org.tvd.thptty.slogan.model.Slogan");

    Session session = null;/*from  w  w  w. java 2  s  .  c o  m*/

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(FIND_BY_RATINGSSTATS);

        SQLQuery q = session.createSQLQuery(sql);

        q.addScalar("averageScore", Type.DOUBLE);
        q.addScalar("sloganId", Type.LONG);
        q.addScalar("sloganText", Type.STRING);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(groupId);
        qPos.add(status);
        qPos.add(classNameId);

        List<Object[]> ratedSlogans = (List<Object[]>) QueryUtil.list(q, getDialect(), start, end);

        List<Slogan> slogans = assembleSlogans(ratedSlogans);

        return slogans;
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

---