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

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.bookmarks.service.persistence.impl.BookmarksFolderFinderImpl.java

License:Open Source License

protected int doCountF_E_ByG_F(long groupId, long folderId, QueryDefinition<?> queryDefinition,
        boolean inlineSQLHelper) {

    Session session = null;//w w w  .j  a  v a 2 s  .  c  om

    try {
        session = openSession();

        StringBundler sb = new StringBundler(5);

        sb.append(StringPool.OPEN_PARENTHESIS);

        String sql = null;

        if (queryDefinition.getStatus() == WorkflowConstants.STATUS_ANY) {
            sql = CustomSQLUtil.get(getClass(), COUNT_F_BY_G_P);
        } else {
            sql = CustomSQLUtil.get(getClass(), COUNT_F_BY_G_P_S);

            sql = replaceExcludeStatus(sql, queryDefinition);
        }

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

        sb.append(sql);
        sb.append(") UNION ALL (");

        if (queryDefinition.getStatus() == WorkflowConstants.STATUS_ANY) {
            sql = CustomSQLUtil.get(getClass(), COUNT_E_BY_G_F);
        } else {
            sql = CustomSQLUtil.get(getClass(), COUNT_E_BY_G_F_S);

            sql = replaceExcludeStatus(sql, queryDefinition);
        }

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

        sb.append(sql);
        sb.append(StringPool.CLOSE_PARENTHESIS);

        sql = sb.toString();

        SQLQuery q = session.createSynchronizedSQLQuery(sql);

        q.addScalar(COUNT_COLUMN_NAME, Type.LONG);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(groupId);
        qPos.add(folderId);

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

        qPos.add(groupId);
        qPos.add(folderId);

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

        int count = 0;

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

        while (itr.hasNext()) {
            Long l = itr.next();

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

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

From source file:com.liferay.bookmarks.service.persistence.impl.BookmarksFolderFinderImpl.java

License:Open Source License

protected List<Object> doFindF_E_ByG_F(long groupId, long folderId, QueryDefinition<?> queryDefinition,
        boolean inlineSQLHelper) {

    Session session = null;//from   w w w.  ja  v  a2  s .co m

    try {
        session = openSession();

        StringBundler sb = new StringBundler(5);

        sb.append("SELECT * FROM (");

        String sql = null;

        if (queryDefinition.getStatus() == WorkflowConstants.STATUS_ANY) {
            sql = CustomSQLUtil.get(getClass(), FIND_F_BY_G_P);
        } else {
            sql = CustomSQLUtil.get(getClass(), FIND_F_BY_G_P_S);

            sql = replaceExcludeStatus(sql, queryDefinition);
        }

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

        sb.append(sql);
        sb.append(" UNION ALL ");

        if (queryDefinition.getStatus() == WorkflowConstants.STATUS_ANY) {
            sql = CustomSQLUtil.get(getClass(), FIND_E_BY_G_F);
        } else {
            sql = CustomSQLUtil.get(getClass(), FIND_E_BY_G_F_S);

            sql = replaceExcludeStatus(sql, queryDefinition);
        }

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

        sb.append(sql);
        sb.append(") TEMP_TABLE ORDER BY modelName ASC");

        sql = sb.toString();

        SQLQuery q = session.createSynchronizedSQLQuery(sql);

        q.addScalar("modelId", Type.LONG);
        q.addScalar("modelName", Type.STRING);
        q.addScalar("modelFolder", Type.LONG);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(groupId);
        qPos.add(folderId);

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

        qPos.add(groupId);
        qPos.add(folderId);

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

        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 modelId = (Long) array[0];
            //String name = (String)array[1];
            long modelFolder = (Long) array[2];

            Object obj = null;

            if (modelFolder == 0) {
                obj = BookmarksFolderUtil.findByPrimaryKey(modelId);
            } else {
                obj = BookmarksEntryUtil.findByPrimaryKey(modelId);
            }

            models.add(obj);
        }

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

From source file:com.liferay.customsql.CustomSQL.java

License:Open Source License

public String get(String id, QueryDefinition queryDefinition, String tableName) {

    String sql = get(id);/*  w w w  .j  a v  a 2 s . com*/

    if (!Validator.isBlank(tableName) && !tableName.endsWith(StringPool.PERIOD)) {

        tableName = tableName.concat(StringPool.PERIOD);
    }

    if (queryDefinition.getStatus() == WorkflowConstants.STATUS_ANY) {
        sql = sql.replace(_STATUS_KEYWORD, _STATUS_CONDITION_EMPTY);
    } else {
        if (queryDefinition.isExcludeStatus()) {
            sql = sql.replace(_STATUS_KEYWORD, tableName.concat(_STATUS_CONDITION_INVERSE));
        } else {
            sql = sql.replace(_STATUS_KEYWORD, tableName.concat(_STATUS_CONDITION_DEFAULT));
        }
    }

    return sql;
}

From source file:com.liferay.document.library.internal.repository.capabilities.LiferayTrashCapability.java

License:Open Source License

protected void deleteTrashEntries(long groupId, long dlFolderId) throws PortalException {

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

    queryDefinition.setStatus(WorkflowConstants.STATUS_ANY);

    List<Object> foldersAndFileEntriesAndFileShortcuts = _dlFolderServiceAdapter
            .getFoldersAndFileEntriesAndFileShortcuts(groupId, dlFolderId, null, true, queryDefinition);

    for (Object folderFileEntryOrFileShortcut : foldersAndFileEntriesAndFileShortcuts) {

        if (folderFileEntryOrFileShortcut instanceof DLFileEntry) {
            deleteTrashEntry((DLFileEntry) folderFileEntryOrFileShortcut);
        } else if (folderFileEntryOrFileShortcut instanceof DLFolder) {
            DLFolder dlFolder = (DLFolder) folderFileEntryOrFileShortcut;

            deleteTrashEntries(dlFolder.getGroupId(), dlFolder.getFolderId());

            deleteTrashEntry(dlFolder);//from   w ww. jav  a 2  s  .  c o m
        }
    }
}

From source file:com.liferay.document.library.internal.repository.capabilities.LiferayTrashCapability.java

License:Open Source License

protected void deleteTrashEntry(DLFileEntry dlFileEntry) {
    if (!dlFileEntry.isInTrash()) {
        return;//ww  w .  ja  v  a2  s .  c o  m
    }

    if (dlFileEntry.isInTrashExplicitly()) {
        _trashEntryLocalService.deleteEntry(DLFileEntryConstants.getClassName(), dlFileEntry.getFileEntryId());
    } else {
        List<DLFileVersion> dlFileVersions = dlFileEntry.getFileVersions(WorkflowConstants.STATUS_ANY);

        for (DLFileVersion dlFileVersion : dlFileVersions) {
            _trashVersionLocalService.deleteTrashVersion(DLFileVersion.class.getName(),
                    dlFileVersion.getFileVersionId());
        }
    }
}

From source file:com.liferay.document.library.internal.verify.DLServiceVerifyProcess.java

License:Open Source License

protected void copyDLFileEntry(DLFileEntry dlFileEntry) throws PortalException {

    long companyId = dlFileEntry.getCompanyId();
    long dataRepositoryId = dlFileEntry.getDataRepositoryId();
    String name = dlFileEntry.getName();
    String version = dlFileEntry.getVersion();

    if (DLStoreUtil.hasFile(companyId, dataRepositoryId, name, version)) {
        return;/*from  w  ww.j av a2s. co  m*/
    }

    List<DLFileVersion> dlFileVersions = dlFileEntry.getFileVersions(WorkflowConstants.STATUS_APPROVED);

    if (dlFileVersions.isEmpty()) {
        dlFileVersions = dlFileEntry.getFileVersions(WorkflowConstants.STATUS_ANY);
    }

    if (dlFileVersions.isEmpty()) {
        DLStoreUtil.addFile(companyId, dataRepositoryId, name, new byte[0]);

        return;
    }

    dlFileVersions = ListUtil.copy(dlFileVersions);

    Collections.sort(dlFileVersions, new DLFileVersionVersionComparator());

    DLFileVersion dlFileVersion = dlFileVersions.get(0);

    DLStoreUtil.copyFileVersion(companyId, dataRepositoryId, name, dlFileVersion.getVersion(), version);
}

From source file:com.liferay.document.library.repository.external.ExtRepositoryAdapter.java

License:Open Source License

private void _forceGetFileVersions(ExtRepositoryFileEntryAdapter extRepositoryFileEntryAdapter) {

    extRepositoryFileEntryAdapter.getFileVersions(WorkflowConstants.STATUS_ANY);
}

From source file:com.liferay.document.library.repository.external.model.ExtRepositoryFileEntryAdapter.java

License:Open Source License

@Override
@SuppressWarnings("rawtypes")
public List<FileVersion> getFileVersions(int status) {
    if ((status == WorkflowConstants.STATUS_ANY) || (status == WorkflowConstants.STATUS_APPROVED)) {

        try {/*from  w w w  . j a  v a2s  .  c o m*/
            return (List) _getExtRepositoryFileVersionAdapters();
        } catch (PortalException pe) {
            throw new SystemException(pe);
        }
    } else {
        return Collections.emptyList();
    }
}

From source file:com.liferay.document.library.service.test.DLFileEntryFinderTest.java

License:Open Source License

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

    queryDefinition.setStatus(WorkflowConstants.STATUS_ANY);

    Assert.assertEquals(3, doCountBy_G_U_F_M(0, null, queryDefinition));
}

From source file:com.liferay.document.library.service.test.DLFileEntryFinderTest.java

License:Open Source License

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

    queryDefinition.setStatus(WorkflowConstants.STATUS_ANY);

    Assert.assertEquals(2, doCountBy_G_U_F_M(0, ContentTypes.TEXT_PLAIN, queryDefinition));
}

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

Introduction

Prototype

Usage