Example usage for com.liferay.portal.kernel.workflow WorkflowConstants STATUS_IN_TRASH

List of usage examples for com.liferay.portal.kernel.workflow WorkflowConstants STATUS_IN_TRASH

Introduction

In this page you can find the example usage for com.liferay.portal.kernel.workflow WorkflowConstants STATUS_IN_TRASH.

Prototype

int STATUS_IN_TRASH

To view the source code for com.liferay.portal.kernel.workflow WorkflowConstants STATUS_IN_TRASH.

Click Source Link

Usage

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;/*from  w ww  .j av  a 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;//www  . ja va 2 s .  com

    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.journal.service.persistence.test.JournalArticleFinderTest.java

License:Open Source License

@Test
public void testFindByExpirationDate() throws Exception {

    // Status any

    QueryDefinition<JournalArticle> queryDefinition = new QueryDefinition<>();

    queryDefinition.setStatus(WorkflowConstants.STATUS_ANY);

    List<JournalArticle> articles = _journalArticleFinder
            .findByExpirationDate(JournalArticleConstants.CLASSNAME_ID_DEFAULT, new Date(), queryDefinition);

    Assert.assertEquals(articles.toString(), 1, articles.size());

    JournalArticle article = articles.get(0);

    Assert.assertEquals(_USER_ID, article.getUserId());

    // Status in trash

    queryDefinition.setStatus(WorkflowConstants.STATUS_IN_TRASH);

    articles = _journalArticleFinder.findByExpirationDate(JournalArticleConstants.CLASSNAME_ID_DEFAULT,
            new Date(), queryDefinition);

    Assert.assertEquals(articles.toString(), 1, articles.size());

    article = articles.get(0);/*from  w  ww .j a v a  2s . co  m*/

    Assert.assertEquals(_USER_ID, article.getUserId());

    // Status not in trash

    queryDefinition.setStatus(WorkflowConstants.STATUS_IN_TRASH, true);

    articles = _journalArticleFinder.findByExpirationDate(JournalArticleConstants.CLASSNAME_ID_DEFAULT,
            new Date(), queryDefinition);

    Assert.assertEquals(articles.toString(), 0, articles.size());
}

From source file:com.liferay.journal.service.persistence.test.JournalArticleFinderTest.java

License:Open Source License

@Test
public void testQueryByC_G_F_C_A_V_T_D_C_T_S_T_D_R() throws Exception {

    // Status any

    QueryDefinition<JournalArticle> queryDefinition = new QueryDefinition<>();

    queryDefinition.setStatus(WorkflowConstants.STATUS_ANY);

    testQueryByC_G_F_C_A_V_T_D_C_T_S_T_D_R(_group.getCompanyId(), _group.getGroupId(), _folderIds,
            JournalArticleConstants.CLASSNAME_ID_DEFAULT, null, null, "Article", null, null, null,
            (String) null, null, null, null, null, true, queryDefinition, 3);
    testQueryByC_G_F_C_A_V_T_D_C_T_S_T_D_R(_group.getCompanyId(), _group.getGroupId(), _folderIds,
            JournalArticleConstants.CLASSNAME_ID_DEFAULT, null, null, null, null, null, null,
            _ddmStructure.getStructureKey(), null, null, null, null, true, queryDefinition, 1);

    // Status in trash

    queryDefinition.setStatus(WorkflowConstants.STATUS_IN_TRASH);

    testQueryByC_G_F_C_A_V_T_D_C_T_S_T_D_R(_group.getCompanyId(), _group.getGroupId(), _folderIds,
            JournalArticleConstants.CLASSNAME_ID_DEFAULT, null, null, "Article", null, null, null,
            (String) null, null, null, null, null, true, queryDefinition, 1);

    // Status not in trash

    queryDefinition.setStatus(WorkflowConstants.STATUS_IN_TRASH, true);

    testQueryByC_G_F_C_A_V_T_D_C_T_S_T_D_R(_group.getCompanyId(), _group.getGroupId(), _folderIds,
            PortalUtil.getClassNameId(DDMStructure.class), null, null, "Article", null, null, null,
            (String) null, null, null, null, null, true, queryDefinition, 1);
}

From source file:com.liferay.journal.service.persistence.test.JournalArticleFinderTest.java

License:Open Source License

@Test
public void testQueryByG_C_S() throws Exception {

    // Status any

    QueryDefinition<JournalArticle> queryDefinition = new QueryDefinition<>();

    queryDefinition.setStatus(WorkflowConstants.STATUS_ANY);

    testQueryByG_C_S(_group.getGroupId(), JournalArticleConstants.CLASSNAME_ID_DEFAULT,
            _ddmStructure.getStructureKey(), queryDefinition, 1);
    testQueryByG_C_S(_group.getGroupId(), JournalArticleConstants.CLASSNAME_ID_DEFAULT,
            _basicWebContentDDMStructure.getStructureKey(), queryDefinition, 2);

    // Status in trash

    queryDefinition.setStatus(WorkflowConstants.STATUS_IN_TRASH);

    testQueryByG_C_S(_group.getGroupId(), JournalArticleConstants.CLASSNAME_ID_DEFAULT,
            _ddmStructure.getStructureKey(), queryDefinition, 0);
    testQueryByG_C_S(_group.getGroupId(), JournalArticleConstants.CLASSNAME_ID_DEFAULT,
            _basicWebContentDDMStructure.getStructureKey(), queryDefinition, 1);

    // Status not in trash

    queryDefinition.setStatus(WorkflowConstants.STATUS_IN_TRASH, true);

    testQueryByG_C_S(_group.getGroupId(), JournalArticleConstants.CLASSNAME_ID_DEFAULT,
            _ddmStructure.getStructureKey(), queryDefinition, 1);
    testQueryByG_C_S(_group.getGroupId(), JournalArticleConstants.CLASSNAME_ID_DEFAULT,
            _basicWebContentDDMStructure.getStructureKey(), queryDefinition, 1);
}

From source file:com.liferay.journal.service.persistence.test.JournalArticleFinderTest.java

License:Open Source License

@Test
public void testQueryByG_F() throws Exception {

    // Status any

    QueryDefinition<JournalArticle> queryDefinition = new QueryDefinition<>();

    queryDefinition.setStatus(WorkflowConstants.STATUS_ANY);

    testQueryByG_F(_group.getGroupId(), _folderIds, queryDefinition, 4);

    // Status in trash

    queryDefinition.setStatus(WorkflowConstants.STATUS_IN_TRASH);

    testQueryByG_F(_group.getGroupId(), _folderIds, queryDefinition, 1);

    // Status not in trash

    queryDefinition.setStatus(WorkflowConstants.STATUS_IN_TRASH, true);

    testQueryByG_F(_group.getGroupId(), _folderIds, queryDefinition, 3);

    // Comparators

    testQueryByG_F(new ArticleCreateDateComparator(true));
    testQueryByG_F(new ArticleCreateDateComparator(false));
    testQueryByG_F(new ArticleDisplayDateComparator(true));
    testQueryByG_F(new ArticleDisplayDateComparator(false));
    testQueryByG_F(new ArticleIDComparator(true));
    testQueryByG_F(new ArticleIDComparator(false));
    testQueryByG_F(new ArticleModifiedDateComparator(true));
    testQueryByG_F(new ArticleModifiedDateComparator(false));
    testQueryByG_F(new ArticleReviewDateComparator(true));
    testQueryByG_F(new ArticleReviewDateComparator(false));
    testQueryByG_F(new ArticleVersionComparator(true));
    testQueryByG_F(new ArticleVersionComparator(false));
}

From source file:com.liferay.journal.service.persistence.test.JournalArticleFinderTest.java

License:Open Source License

@Test
public void testQueryByG_F_C() throws Exception {

    // Status any (constructor), which is status not in trash

    QueryDefinition<JournalArticle> queryDefinition = new QueryDefinition<>(WorkflowConstants.STATUS_ANY);

    queryDefinition.setOwnerUserId(TestPropsValues.getUserId());

    testQueryByG_C(_group.getGroupId(), Collections.<Long>emptyList(),
            JournalArticleConstants.CLASSNAME_ID_DEFAULT, queryDefinition, 2);

    // Status any

    queryDefinition.setStatus(WorkflowConstants.STATUS_ANY);
    queryDefinition.setOwnerUserId(_USER_ID);

    testQueryByG_C(_group.getGroupId(), Collections.<Long>emptyList(),
            JournalArticleConstants.CLASSNAME_ID_DEFAULT, queryDefinition, 1);

    // Status in trash

    queryDefinition.setStatus(WorkflowConstants.STATUS_IN_TRASH);
    queryDefinition.setOwnerUserId(_USER_ID);

    testQueryByG_C(_group.getGroupId(), Collections.<Long>emptyList(),
            JournalArticleConstants.CLASSNAME_ID_DEFAULT, queryDefinition, 1);

    // Status not in trash

    queryDefinition.setStatus(WorkflowConstants.STATUS_IN_TRASH, true);
    queryDefinition.setOwnerUserId(_USER_ID);

    testQueryByG_C(_group.getGroupId(), Collections.<Long>emptyList(),
            JournalArticleConstants.CLASSNAME_ID_DEFAULT, queryDefinition, 0);
}

From source file:com.liferay.journal.service.persistence.test.JournalFolderFinderTest.java

License:Open Source License

@Test
public void testCountF_A_ByG_F() throws Exception {
    QueryDefinition<Object> queryDefinition = new QueryDefinition<>();

    queryDefinition.setStatus(WorkflowConstants.STATUS_ANY);

    Assert.assertEquals(3,//from   w  ww. j a va 2s.co m
            _journalFolderFinder.countF_A_ByG_F(_group.getGroupId(), _folder1.getFolderId(), queryDefinition));

    queryDefinition.setStatus(WorkflowConstants.STATUS_IN_TRASH);

    Assert.assertEquals(1,
            _journalFolderFinder.countF_A_ByG_F(_group.getGroupId(), _folder1.getFolderId(), queryDefinition));

    queryDefinition.setStatus(WorkflowConstants.STATUS_IN_TRASH, true);

    Assert.assertEquals(2,
            _journalFolderFinder.countF_A_ByG_F(_group.getGroupId(), _folder1.getFolderId(), queryDefinition));
}

From source file:com.liferay.journal.service.persistence.test.JournalFolderFinderTest.java

License:Open Source License

@Test
public void testFindF_A_ByG_F() throws Exception {
    QueryDefinition<Object> queryDefinition = new QueryDefinition<>();

    queryDefinition.setStatus(WorkflowConstants.STATUS_ANY);

    List<Object> results = _journalFolderFinder.findF_A_ByG_F(_group.getGroupId(), _folder1.getFolderId(),
            queryDefinition);/*from   w ww .j ava2 s  .co  m*/

    Assert.assertEquals(results.toString(), 3, results.size());

    for (Object result : results) {
        if (result instanceof JournalFolder) {
            JournalFolder folder = (JournalFolder) result;

            Assert.assertEquals("Folder 2", folder.getName());
        } else if (result instanceof JournalArticle) {
            JournalArticle article = (JournalArticle) result;

            String title = article.getTitleCurrentValue();

            Assert.assertTrue(title, title.equals("Article 1") || title.equals("Article 2"));
        }
    }

    queryDefinition.setStatus(WorkflowConstants.STATUS_IN_TRASH);

    results = _journalFolderFinder.findF_A_ByG_F(_group.getGroupId(), _folder1.getFolderId(), queryDefinition);

    Assert.assertEquals(results.toString(), 1, results.size());

    for (Object result : results) {
        if (result instanceof JournalFolder) {
            JournalFolder folder = (JournalFolder) result;

            Assert.assertEquals("Folder 2", folder.getName());
        } else if (result instanceof JournalArticle) {
            JournalArticle article = (JournalArticle) result;

            Assert.assertEquals("Article 2", article.getTitleCurrentValue());
        }
    }

    queryDefinition.setStatus(WorkflowConstants.STATUS_IN_TRASH, true);

    results = _journalFolderFinder.findF_A_ByG_F(_group.getGroupId(), _folder1.getFolderId(), queryDefinition);

    Assert.assertEquals(results.toString(), 2, results.size());

    for (Object result : results) {
        if (result instanceof JournalFolder) {
            JournalFolder folder = (JournalFolder) result;

            Assert.assertEquals("Folder 2", folder.getName());
        } else if (result instanceof JournalArticle) {
            JournalArticle article = (JournalArticle) result;

            Assert.assertEquals("Article 1", article.getTitleCurrentValue());
        }
    }
}

From source file:com.liferay.journal.trash.JournalBaseTrashHandler.java

License:Open Source License

@Override
public List<TrashRenderer> getTrashModelTrashRenderers(long classPK, int start, int end, OrderByComparator obc)
        throws PortalException {

    List<TrashRenderer> trashRenderers = new ArrayList<>();

    JournalFolder folder = JournalFolderLocalServiceUtil.getFolder(classPK);

    List<Object> foldersAndArticles = JournalFolderLocalServiceUtil.getFoldersAndArticles(folder.getGroupId(),
            classPK, WorkflowConstants.STATUS_IN_TRASH, start, end, obc);

    for (Object folderOrArticle : foldersAndArticles) {
        TrashRenderer trashRenderer = null;

        if (folderOrArticle instanceof JournalFolder) {
            JournalFolder curFolder = (JournalFolder) folderOrArticle;

            TrashHandler trashHandler = TrashHandlerRegistryUtil.getTrashHandler(JournalFolder.class.getName());

            trashRenderer = trashHandler.getTrashRenderer(curFolder.getPrimaryKey());
        } else {// www .j a  va  2s  .c om
            JournalArticle article = (JournalArticle) folderOrArticle;

            TrashHandler trashHandler = TrashHandlerRegistryUtil
                    .getTrashHandler(JournalArticle.class.getName());

            trashRenderer = trashHandler.getTrashRenderer(article.getResourcePrimKey());
        }

        trashRenderers.add(trashRenderer);
    }

    return trashRenderers;
}