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

Introduction

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

Prototype

public OrderByComparator<T> getOrderByComparator(String tableName) 

Source Link

Usage

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

License:Open Source License

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

    Session session = null;//from w w  w  . j  av  a2  s  .co m

    try {
        session = openSession();

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

        sql = replaceStatusJoin(sql, queryDefinition);

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

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

        sql = StringUtil.replace(sql, "[$FOLDER_ID$]", getFolderIds(folderIds, JournalArticleImpl.TABLE_NAME));

        SQLQuery q = session.createSynchronizedSQLQuery(sql);

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

        QueryPos qPos = QueryPos.getInstance(q);

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

        for (int i = 0; i < folderIds.size(); i++) {
            Long folderId = folderIds.get(i);

            qPos.add(folderId);
        }

        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.journal.service.persistence.impl.JournalArticleFinderImpl.java

License:Open Source License

protected List<JournalArticle> doFindByG_C_S(long groupId, long classNameId, String[] ddmStructureKeys,
        QueryDefinition<JournalArticle> queryDefinition, boolean inlineSQLHelper) {

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

    try {
        session = openSession();

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

        sql = replaceStatusJoin(sql, queryDefinition);

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

        if (groupId <= 0) {
            sql = StringUtil.replace(sql, "(JournalArticle.groupId = ?) AND", StringPool.BLANK);
        }

        sql = StringUtil.replace(sql, "[$DDM_STRUCTURE_KEY$]",
                getDDMStructureKeys(ddmStructureKeys, 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);

        if (groupId > 0) {
            qPos.add(groupId);
        }

        qPos.add(classNameId);
        qPos.add(ddmStructureKeys);
        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.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 www  .j  a  va2 s  .c o 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.journal.service.persistence.impl.JournalArticleFinderImpl.java

License:Open Source License

protected List<JournalArticle> doFindByC_G_F_C_A_V_T_D_C_S_T_D_R(long companyId, long groupId,
        List<Long> folderIds, long classNameId, String[] articleIds, Double version, String[] titles,
        String[] descriptions, String[] contents, String[] ddmStructureKeys, String[] ddmTemplateKeys,
        Date displayDateGT, Date displayDateLT, Date reviewDate, boolean andOperator,
        QueryDefinition<JournalArticle> queryDefinition, boolean inlineSQLHelper) {

    articleIds = CustomSQLUtil.keywords(articleIds, false);
    titles = CustomSQLUtil.keywords(titles);
    descriptions = CustomSQLUtil.keywords(descriptions, false);
    contents = CustomSQLUtil.keywords(contents, false);
    ddmStructureKeys = CustomSQLUtil.keywords(ddmStructureKeys, false);
    ddmTemplateKeys = CustomSQLUtil.keywords(ddmTemplateKeys, false);
    Timestamp displayDateGT_TS = CalendarUtil.getTimestamp(displayDateGT);
    Timestamp displayDateLT_TS = CalendarUtil.getTimestamp(displayDateLT);
    Timestamp reviewDate_TS = CalendarUtil.getTimestamp(reviewDate);

    Session session = null;//from  ww  w  . j  av a 2 s.  c o m

    try {
        session = openSession();

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

        sql = replaceStatusJoin(sql, queryDefinition);

        if (groupId <= 0) {
            sql = StringUtil.replace(sql, "(JournalArticle.groupId = ?) AND", StringPool.BLANK);
        }

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

        sql = CustomSQLUtil.replaceKeywords(sql, "JournalArticle.articleId", StringPool.LIKE, false,
                articleIds);

        if ((version == null) || (version <= 0)) {
            sql = StringUtil.replace(sql, "(JournalArticle.version = ?) [$AND_OR_CONNECTOR$]",
                    StringPool.BLANK);
        }

        sql = CustomSQLUtil.replaceKeywords(sql, "JournalArticleLocalization.title", StringPool.LIKE, false,
                titles);
        sql = CustomSQLUtil.replaceKeywords(sql, "JournalArticleLocalization.description", StringPool.LIKE,
                true, descriptions);
        sql = CustomSQLUtil.replaceKeywords(sql, "JournalArticle.content", StringPool.LIKE, false, contents);

        sql = replaceStructureTemplate(sql, ddmStructureKeys, ddmTemplateKeys);

        if (!isNullArray(ddmStructureKeys)) {
            sql = CustomSQLUtil.replaceKeywords(sql, "JournalArticle.DDMStructureKey", StringPool.LIKE, false,
                    ddmStructureKeys);
        }

        if (!isNullArray(ddmTemplateKeys)) {
            sql = CustomSQLUtil.replaceKeywords(sql, "JournalArticle.DDMTemplateKey", StringPool.LIKE, false,
                    ddmTemplateKeys);
        }

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

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

            sql = StringUtil.replace(sql, "(companyId", "(JournalArticle.companyId");
        }

        SQLQuery q = session.createSynchronizedSQLQuery(sql);

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

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(titles, 2);
        qPos.add(descriptions, 2);

        qPos.add(companyId);

        if (groupId > 0) {
            qPos.add(groupId);
        }

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

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

        if (!isNullArray(ddmStructureKeys)) {
            qPos.add(ddmStructureKeys, 2);
        }

        if (!isNullArray(ddmTemplateKeys)) {
            qPos.add(ddmTemplateKeys, 2);
        }

        qPos.add(articleIds, 2);

        if ((version != null) && (version > 0)) {
            qPos.add(version);
        }

        qPos.add(contents, 2);
        qPos.add(displayDateGT_TS);
        qPos.add(displayDateGT_TS);
        qPos.add(displayDateLT_TS);
        qPos.add(displayDateLT_TS);
        qPos.add(reviewDate_TS);
        qPos.add(reviewDate_TS);

        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.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;//  w w  w  .  j  av  a 2 s  .  c  o 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);
    }
}

---