Example usage for com.liferay.portal.kernel.dao.orm QueryDefinition isIncludeOwner

Introduction

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

Prototype

public boolean isIncludeOwner() 

Source Link

Usage

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

License:Open Source License

protected int doCountByG_F_C(long groupId, List<Long> folderIds, long classNameId,
        QueryDefinition<JournalArticle> queryDefinition, boolean inlineSQLHelper) {

    Session session = null;//  w ww.j  a v a 2  s  . co m

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(getClass(), COUNT_BY_G_U_F_C, queryDefinition, "JournalArticle");

        sql = replaceStatusJoin(sql, queryDefinition);

        if (folderIds.isEmpty()) {
            sql = StringUtil.replace(sql, "([$FOLDER_ID$]) AND", StringPool.BLANK);
        } else {
            sql = StringUtil.replace(sql, "[$FOLDER_ID$]",
                    getFolderIds(folderIds, JournalArticleImpl.TABLE_NAME));
        }

        if (inlineSQLHelper) {
            sql = InlineSQLHelperUtil.replacePermissionCheck(sql, JournalArticle.class.getName(),
                    "JournalArticle.resourcePrimKey", groupId);
        }

        SQLQuery q = session.createSynchronizedSQLQuery(sql);

        q.addScalar(COUNT_COLUMN_NAME, Type.LONG);

        QueryPos qPos = QueryPos.getInstance(q);

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

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

            if (queryDefinition.isIncludeOwner()) {
                qPos.add(WorkflowConstants.STATUS_IN_TRASH);
            }
        }

        for (long folderId : folderIds) {
            qPos.add(folderId);
        }

        qPos.add(queryDefinition.getStatus());

        Iterator<Long> itr = q.iterate();

        if (itr.hasNext()) {
            Long count = itr.next();

            if (count != null) {
                return count.intValue();
            }
        }

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

---

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

License:Open Source License

protected List<JournalArticle> doFindByG_F_C(long groupId, List<Long> folderIds, long classNameId,
        QueryDefinition<JournalArticle> queryDefinition, boolean inlineSQLHelper) {

    Session session = null;/*from   w ww.j a  v a  2  s. co  m*/

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(getClass(), FIND_BY_G_U_F_C, queryDefinition, "JournalArticle");

        sql = replaceStatusJoin(sql, queryDefinition);

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

        if (folderIds.isEmpty()) {
            sql = StringUtil.replace(sql, "([$FOLDER_ID$]) AND", StringPool.BLANK);
        } else {
            sql = StringUtil.replace(sql, "[$FOLDER_ID$]",
                    getFolderIds(folderIds, JournalArticleImpl.TABLE_NAME));
        }

        if (inlineSQLHelper) {
            sql = InlineSQLHelperUtil.replacePermissionCheck(sql, JournalArticle.class.getName(),
                    "JournalArticle.resourcePrimKey", groupId);
        }

        SQLQuery q = session.createSynchronizedSQLQuery(sql);

        q.addEntity(JournalArticleImpl.TABLE_NAME, JournalArticleImpl.class);

        QueryPos qPos = QueryPos.getInstance(q);

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

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

            if (queryDefinition.isIncludeOwner()) {
                qPos.add(WorkflowConstants.STATUS_IN_TRASH);
            }
        }

        for (long folderId : folderIds) {
            qPos.add(folderId);
        }

        qPos.add(queryDefinition.getStatus());

        return (List<JournalArticle>) QueryUtil.list(q, getDialect(), queryDefinition.getStart(),
                queryDefinition.getEnd());
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

---

From source file:com.liferay.petra.model.adapter.util.ModelAdapterUtil.java

License:Open Source License

public static <T, V> QueryDefinition<T> adapt(Class<V> clazz, QueryDefinition<V> queryDefinition) {

    if (queryDefinition == null) {
        return null;
    }//ww  w  .j  a va  2  s  .  c o  m

    QueryDefinition<T> adaptedQueryDefinition = new QueryDefinition<>(queryDefinition.getStatus(),
            queryDefinition.isExcludeStatus(), queryDefinition.getOwnerUserId(),
            queryDefinition.isIncludeOwner(), queryDefinition.getStart(), queryDefinition.getEnd(),
            adapt(clazz, queryDefinition.getOrderByComparator()));

    adaptedQueryDefinition.setAttributes(queryDefinition.getAttributes());

    return adaptedQueryDefinition;
}

---

From source file:com.liferay.wiki.service.persistence.impl.WikiPageFinderImpl.java

License:Open Source License

protected int doCountByG_N_H_S(long groupId, long nodeId, boolean head,
        QueryDefinition<WikiPage> queryDefinition, boolean inlineSQLHelper) {

    Session session = null;/*from   ww w  . j  a va2  s  .co m*/

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(getClass(), COUNT_BY_G_N_H_S, queryDefinition, "WikiPage");

        if (inlineSQLHelper) {
            sql = InlineSQLHelperUtil.replacePermissionCheck(sql, WikiPage.class.getName(),
                    "WikiPage.resourcePrimKey", groupId);
        }

        SQLQuery q = session.createSynchronizedSQLQuery(sql);

        q.addScalar(COUNT_COLUMN_NAME, Type.LONG);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(groupId);
        qPos.add(nodeId);
        qPos.add(head);

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

            if (queryDefinition.isIncludeOwner()) {
                qPos.add(WorkflowConstants.STATUS_IN_TRASH);
            }
        }

        qPos.add(queryDefinition.getStatus());

        Iterator<Long> itr = q.iterate();

        if (itr.hasNext()) {
            Long count = itr.next();

            if (count != null) {
                return count.intValue();
            }
        }

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

---

From source file:com.liferay.wiki.service.persistence.impl.WikiPageFinderImpl.java

License:Open Source License

protected List<WikiPage> doFindByG_N_H_S(long groupId, long nodeId, boolean head,
        QueryDefinition<WikiPage> queryDefinition, boolean inlineSQLHelper) {

    Session session = null;//from w ww  .j  a  v a  2  s  .co m

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(getClass(), FIND_BY_G_N_H_S, queryDefinition, "WikiPage");

        if (inlineSQLHelper) {
            sql = InlineSQLHelperUtil.replacePermissionCheck(sql, WikiPage.class.getName(),
                    "WikiPage.resourcePrimKey", groupId);
        }

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

        SQLQuery q = session.createSynchronizedSQLQuery(sql);

        q.addEntity("WikiPage", WikiPageImpl.class);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(groupId);
        qPos.add(nodeId);
        qPos.add(head);

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

            if (queryDefinition.isIncludeOwner()) {
                qPos.add(WorkflowConstants.STATUS_IN_TRASH);
            }
        }

        qPos.add(queryDefinition.getStatus());

        return (List<WikiPage>) QueryUtil.list(q, getDialect(), queryDefinition.getStart(),
                queryDefinition.getEnd());
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

---