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

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

Introduction

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

Prototype

int STATUS_ANY

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

Click Source Link

Usage

From source file:com.liferay.blogs.service.persistence.impl.BlogsEntryFinderImpl.java

License:Open Source License

@Override
public int countByOrganizationIds(List<Long> organizationIds, Date displayDate,
        QueryDefinition<BlogsEntry> queryDefinition) {

    Timestamp displayDate_TS = CalendarUtil.getTimestamp(displayDate);

    Session session = null;/*w w w.  j a v  a2 s . c  o  m*/

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(getClass(), COUNT_BY_ORGANIZATION_IDS);

        if (queryDefinition.getStatus() != WorkflowConstants.STATUS_ANY) {
            if (queryDefinition.isExcludeStatus()) {
                sql = CustomSQLUtil.appendCriteria(sql, "AND (BlogsEntry.status != ?)");
            } else {
                sql = CustomSQLUtil.appendCriteria(sql, "AND (BlogsEntry.status = ?)");
            }
        }

        sql = StringUtil.replace(sql, "[$ORGANIZATION_ID$]", getOrganizationIds(organizationIds));

        SQLQuery q = session.createSynchronizedSQLQuery(sql);

        q.addScalar(COUNT_COLUMN_NAME, Type.LONG);

        QueryPos qPos = QueryPos.getInstance(q);

        for (Long organizationId : organizationIds) {
            qPos.add(organizationId);
        }

        qPos.add(displayDate_TS);

        if (queryDefinition.getStatus() != WorkflowConstants.STATUS_ANY) {
            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.blogs.service.persistence.impl.BlogsEntryFinderImpl.java

License:Open Source License

@Override
public List<BlogsEntry> findByGroupIds(long companyId, long groupId, Date displayDate,
        QueryDefinition<BlogsEntry> queryDefinition) {

    Session session = null;/* w  w w.  j  a v a2  s  .c o  m*/

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(getClass(), FIND_BY_GROUP_IDS);

        if (queryDefinition.getStatus() != WorkflowConstants.STATUS_ANY) {
            if (queryDefinition.isExcludeStatus()) {
                sql = CustomSQLUtil.appendCriteria(sql, "AND (BlogsEntry.status != ?)");
            } else {
                sql = CustomSQLUtil.appendCriteria(sql, "AND (BlogsEntry.status = ?)");
            }
        }

        SQLQuery q = session.createSynchronizedSQLQuery(sql);

        q.addEntity("BlogsEntry", BlogsEntryImpl.class);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(companyId);
        qPos.add(groupId);
        qPos.add(groupId);
        qPos.add(groupId);
        qPos.add(displayDate);

        if (queryDefinition.getStatus() != WorkflowConstants.STATUS_ANY) {
            qPos.add(queryDefinition.getStatus());
        }

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

From source file:com.liferay.blogs.service.persistence.impl.BlogsEntryFinderImpl.java

License:Open Source License

@Override
public List<BlogsEntry> findByOrganizationIds(List<Long> organizationIds, Date displayDate,
        QueryDefinition<BlogsEntry> queryDefinition) {

    Timestamp displayDate_TS = CalendarUtil.getTimestamp(displayDate);

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

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(getClass(), FIND_BY_ORGANIZATION_IDS);

        if (queryDefinition.getStatus() != WorkflowConstants.STATUS_ANY) {
            if (queryDefinition.isExcludeStatus()) {
                sql = CustomSQLUtil.appendCriteria(sql, "AND (BlogsEntry.status != ?)");
            } else {
                sql = CustomSQLUtil.appendCriteria(sql, "AND (BlogsEntry.status = ?)");
            }
        }

        sql = StringUtil.replace(sql, "[$ORGANIZATION_ID$]", getOrganizationIds(organizationIds));
        sql = CustomSQLUtil.replaceOrderBy(sql, queryDefinition.getOrderByComparator());

        SQLQuery q = session.createSynchronizedSQLQuery(sql);

        q.addEntity("BlogsEntry", BlogsEntryImpl.class);

        QueryPos qPos = QueryPos.getInstance(q);

        for (Long organizationId : organizationIds) {
            qPos.add(organizationId);
        }

        qPos.add(displayDate_TS);

        if (queryDefinition.getStatus() != WorkflowConstants.STATUS_ANY) {
            qPos.add(queryDefinition.getStatus());
        }

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

From source file:com.liferay.blogs.service.test.BlogsEntryLocalServiceTest.java

License:Open Source License

@Test
public void testGetDiscussionMessageDisplay() throws Exception {
    BlogsEntry entry = addEntry(false);/*from   w ww .  j a  v a  2s .c  om*/

    MBMessageLocalServiceUtil.getDiscussionMessageDisplay(_user.getUserId(), _group.getGroupId(),
            BlogsEntry.class.getName(), entry.getEntryId(), WorkflowConstants.STATUS_ANY);
}

From source file:com.liferay.blogs.service.test.BlogsEntryTrashHandlerTest.java

License:Open Source License

@Override
protected int getNotInTrashBaseModelsCount(BaseModel<?> parentBaseModel) throws Exception {

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

    return BlogsEntryLocalServiceUtil.getGroupEntriesCount((Long) parentBaseModel.getPrimaryKeyObj(),
            queryDefinition);/*from w w w .  j  a  v a 2  s  .c o m*/
}

From source file:com.liferay.bookmarks.service.impl.BookmarksEntryServiceImpl.java

License:Open Source License

@Override
public int getEntriesCount(long groupId, long folderId, int status) {
    if (status == WorkflowConstants.STATUS_ANY) {
        return bookmarksEntryPersistence.filterCountByG_F_NotS(groupId, folderId,
                WorkflowConstants.STATUS_IN_TRASH);
    } else {//from w w  w .  ja v a2  s  .  co  m
        return bookmarksEntryPersistence.filterCountByG_F_S(groupId, folderId, status);
    }
}

From source file:com.liferay.bookmarks.service.impl.BookmarksFolderLocalServiceImpl.java

License:Open Source License

@Override
public List<Object> getFoldersAndEntries(long groupId, long folderId) {
    return getFoldersAndEntries(groupId, folderId, WorkflowConstants.STATUS_ANY);
}

From source file:com.liferay.bookmarks.service.impl.BookmarksFolderServiceImpl.java

License:Open Source License

@Override
public List<BookmarksFolder> getFolders(long groupId, long parentFolderId, int status, int start, int end) {

    if (status == WorkflowConstants.STATUS_ANY) {
        return bookmarksFolderPersistence.filterFindByG_P(groupId, parentFolderId, start, end);
    } else {/* www.j  ava2s.co m*/
        return bookmarksFolderPersistence.filterFindByG_P_S(groupId, parentFolderId, status, start, end);
    }
}

From source file:com.liferay.bookmarks.service.impl.BookmarksFolderServiceImpl.java

License:Open Source License

@Override
public int getFoldersAndEntriesCount(long groupId, long folderId) {
    return getFoldersAndEntriesCount(groupId, folderId, WorkflowConstants.STATUS_ANY);
}

From source file:com.liferay.bookmarks.service.impl.BookmarksFolderServiceImpl.java

License:Open Source License

@Override
public int getFoldersCount(long groupId, long parentFolderId, int status) {
    if (status == WorkflowConstants.STATUS_ANY) {
        return bookmarksFolderPersistence.filterCountByG_P_NotS(groupId, parentFolderId,
                WorkflowConstants.STATUS_IN_TRASH);
    } else {/*from  w w w  .j  a  va  2s .  co m*/
        return bookmarksFolderPersistence.filterCountByG_P_S(groupId, parentFolderId, status);
    }
}