List of usage examples for com.liferay.portal.kernel.workflow WorkflowConstants STATUS_IN_TRASH
int STATUS_IN_TRASH
To view the source code for com.liferay.portal.kernel.workflow WorkflowConstants STATUS_IN_TRASH.
Click Source Link
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; }