Example usage 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.dynamic.data.mapping.service.persistence.impl.DDMStructureFinderImpl.java

License:Open Source License

protected List<DDMStructure> doFindByC_G_C_N_D_S_T_S(long companyId, long[] groupIds, long classNameId,
        String[] names, String[] descriptions, String storageType, int type, int status, boolean andOperator,
        int start, int end, OrderByComparator<DDMStructure> orderByComparator, boolean inlineSQLHelper) {

    names = CustomSQLUtil.keywords(names);
    descriptions = CustomSQLUtil.keywords(descriptions, false);

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

    try {
        session = openSession();

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

        if (inlineSQLHelper) {
            sql = InlineSQLHelperUtil.replacePermissionCheck(sql,
                    DDMStructurePermission.getStructureModelResourceName(classNameId),
                    "DDMStructure.structureId", groupIds);
        }

        sql = StringUtil.replace(sql, "[$GROUP_ID$]", getGroupIds(groupIds));
        sql = StringUtil.replace(sql, "[$STATUS$]", getStatus(status));
        sql = CustomSQLUtil.replaceKeywords(sql, "lower(CAST_TEXT(DDMStructure.name))", StringPool.LIKE, false,
                names);
        sql = CustomSQLUtil.replaceKeywords(sql, "DDMStructure.description", StringPool.LIKE, true,
                descriptions);
        sql = CustomSQLUtil.replaceAndOperator(sql, andOperator);

        if (orderByComparator != null) {
            sql = CustomSQLUtil.replaceOrderBy(sql, orderByComparator);
        }

        SQLQuery q = session.createSynchronizedSQLQuery(sql);

        q.addEntity("DDMStructure", DDMStructureImpl.class);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(companyId);

        if (groupIds != null) {
            qPos.add(groupIds);
        }

        qPos.add(classNameId);
        qPos.add(names, 2);
        qPos.add(descriptions, 2);
        qPos.add(storageType);
        qPos.add(storageType);
        qPos.add(type);

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

        return (List<DDMStructure>) QueryUtil.list(q, getDialect(), start, end);
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

---

From source file:com.liferay.dynamic.data.mapping.service.persistence.impl.DDMStructureFinderImpl.java

License:Open Source License

protected String getStatus(int status) {
    if (status == WorkflowConstants.STATUS_ANY) {
        return StringPool.BLANK;
    }/*from   w  ww. j a v a2s. c o  m*/

    StringBundler sb = new StringBundler(5);

    sb.append("AND EXISTS (SELECT 1 FROM DDMStructureVersion WHERE ");
    sb.append("(DDMStructureVersion.structureId = ");
    sb.append("DDMStructure.structureId) AND ");
    sb.append("(DDMStructureVersion.version = DDMStructure.version) AND ");
    sb.append("(DDMStructureVersion.status = ?))");

    return sb.toString();
}

---

From source file:com.liferay.dynamic.data.mapping.service.persistence.impl.DDMTemplateFinderImpl.java

License:Open Source License

protected int doCountByG_C_SC_S(long[] groupIds, long classNameId, long structureClassNameId, int status,
        boolean inlineSQLHelper) {

    Session session = null;//from   w w  w.java  2s .c  om

    try {
        session = openSession();

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

        if (inlineSQLHelper) {
            sql = InlineSQLHelperUtil.replacePermissionCheck(sql,
                    DDMTemplatePermission.getTemplateModelResourceName(structureClassNameId),
                    "DDMTemplate.templateId", groupIds);
        }

        sql = StringUtil.replace(sql, "[$GROUP_ID$]", getGroupIds(groupIds));
        sql = StringUtil.replace(sql, "[$STATUS$]", getStatus(status));

        SQLQuery q = session.createSynchronizedSQLQuery(sql);

        q.addScalar(COUNT_COLUMN_NAME, Type.LONG);

        QueryPos qPos = QueryPos.getInstance(q);

        if (groupIds != null) {
            qPos.add(groupIds);
        }

        qPos.add(classNameId);
        qPos.add(structureClassNameId);

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

        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.dynamic.data.mapping.service.persistence.impl.DDMTemplateFinderImpl.java

License:Open Source License

protected int doCountByC_G_C_C_R_N_D_T_M_L_S(long companyId, long[] groupIds, long[] classNameIds,
        long[] classPKs, long resourceClassNameId, String[] names, String[] descriptions, String[] types,
        String[] modes, String[] languages, int status, boolean andOperator, boolean inlineSQLHelper) {

    names = CustomSQLUtil.keywords(names);
    descriptions = CustomSQLUtil.keywords(descriptions, false);
    types = CustomSQLUtil.keywords(types, false);
    modes = CustomSQLUtil.keywords(modes, false);
    languages = CustomSQLUtil.keywords(languages, false);

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

    try {
        session = openSession();

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

        if (inlineSQLHelper) {
            sql = InlineSQLHelperUtil.replacePermissionCheck(sql,
                    DDMTemplatePermission.getTemplateModelResourceName(resourceClassNameId),
                    "DDMTemplate.templateId", groupIds);
        }

        sql = StringUtil.replace(sql, "[$GROUP_ID$]", getGroupIds(groupIds));
        sql = StringUtil.replace(sql, "[$CLASSNAME_ID$]", getClassNameIds(classNameIds));
        sql = StringUtil.replace(sql, "[$CLASS_PK$]", getClassPKs(classPKs));
        sql = StringUtil.replace(sql, "[$STATUS$]", getStatus(status));
        sql = CustomSQLUtil.replaceKeywords(sql, "lower(CAST_TEXT(DDMTemplate.name))", StringPool.LIKE, false,
                names);
        sql = CustomSQLUtil.replaceKeywords(sql, "DDMTemplate.description", StringPool.LIKE, false,
                descriptions);
        sql = CustomSQLUtil.replaceKeywords(sql, "DDMTemplate.type", StringPool.LIKE, false, types);
        sql = CustomSQLUtil.replaceKeywords(sql, "DDMTemplate.mode", StringPool.LIKE, false, modes);
        sql = CustomSQLUtil.replaceKeywords(sql, "DDMTemplate.language", StringPool.LIKE, true, languages);
        sql = CustomSQLUtil.replaceAndOperator(sql, andOperator);

        SQLQuery q = session.createSynchronizedSQLQuery(sql);

        q.addScalar(COUNT_COLUMN_NAME, Type.LONG);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(companyId);

        if (groupIds != null) {
            qPos.add(groupIds);
        }

        if (classNameIds != null) {
            qPos.add(classNameIds);
        }

        if (classPKs != null) {
            qPos.add(classPKs);
        }

        qPos.add(resourceClassNameId);
        qPos.add(names, 2);
        qPos.add(descriptions, 2);
        qPos.add(types, 2);
        qPos.add(modes, 2);
        qPos.add(languages, 2);

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

        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.dynamic.data.mapping.service.persistence.impl.DDMTemplateFinderImpl.java

License:Open Source License

protected List<DDMTemplate> doFindByG_C_SC_S(long[] groupIds, long classNameId, long structureClassNameId,
        int status, int start, int end, OrderByComparator<DDMTemplate> orderByComparator,
        boolean inlineSQLHelper) {

    Session session = null;// w ww.  ja  va2s  . c  o m

    try {
        session = openSession();

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

        if (inlineSQLHelper) {
            sql = InlineSQLHelperUtil.replacePermissionCheck(sql,
                    DDMTemplatePermission.getTemplateModelResourceName(structureClassNameId),
                    "DDMTemplate.templateId", groupIds);
        }

        sql = StringUtil.replace(sql, "[$GROUP_ID$]", getGroupIds(groupIds));
        sql = StringUtil.replace(sql, "[$STATUS$]", getStatus(status));

        if (orderByComparator != null) {
            sql = CustomSQLUtil.replaceOrderBy(sql, orderByComparator);
        }

        SQLQuery q = session.createSynchronizedSQLQuery(sql);

        q.addEntity("DDMTemplate", DDMTemplateImpl.class);

        QueryPos qPos = QueryPos.getInstance(q);

        if (groupIds != null) {
            qPos.add(groupIds);
        }

        qPos.add(classNameId);
        qPos.add(structureClassNameId);

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

        return (List<DDMTemplate>) QueryUtil.list(q, getDialect(), start, end);
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

---

From source file:com.liferay.dynamic.data.mapping.service.persistence.impl.DDMTemplateFinderImpl.java

License:Open Source License

protected List<DDMTemplate> doFindByC_G_C_C_R_N_D_T_M_L_S(long companyId, long[] groupIds, long[] classNameIds,
        long[] classPKs, long resourceClassNameId, String[] names, String[] descriptions, String[] types,
        String[] modes, String[] languages, int status, boolean andOperator, int start, int end,
        OrderByComparator<DDMTemplate> orderByComparator, boolean inlineSQLHelper) {

    names = CustomSQLUtil.keywords(names);
    descriptions = CustomSQLUtil.keywords(descriptions, false);
    types = CustomSQLUtil.keywords(types, false);
    modes = CustomSQLUtil.keywords(modes, false);
    languages = CustomSQLUtil.keywords(languages, false);

    Session session = null;/*from   w  w  w . ja va 2  s .  co  m*/

    try {
        session = openSession();

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

        if (inlineSQLHelper) {
            sql = InlineSQLHelperUtil.replacePermissionCheck(sql,
                    DDMTemplatePermission.getTemplateModelResourceName(resourceClassNameId),
                    "DDMTemplate.templateId", groupIds);
        }

        sql = StringUtil.replace(sql, "[$GROUP_ID$]", getGroupIds(groupIds));
        sql = StringUtil.replace(sql, "[$CLASSNAME_ID$]", getClassNameIds(classNameIds));
        sql = StringUtil.replace(sql, "[$CLASS_PK$]", getClassPKs(classPKs));
        sql = StringUtil.replace(sql, "[$STATUS$]", getStatus(status));
        sql = CustomSQLUtil.replaceKeywords(sql, "lower(CAST_TEXT(DDMTemplate.name))", StringPool.LIKE, false,
                names);
        sql = CustomSQLUtil.replaceKeywords(sql, "DDMTemplate.description", StringPool.LIKE, false,
                descriptions);
        sql = CustomSQLUtil.replaceKeywords(sql, "DDMTemplate.type", StringPool.LIKE, false, types);
        sql = CustomSQLUtil.replaceKeywords(sql, "DDMTemplate.mode", StringPool.LIKE, false, modes);
        sql = CustomSQLUtil.replaceKeywords(sql, "DDMTemplate.language", StringPool.LIKE, true, languages);
        sql = CustomSQLUtil.replaceAndOperator(sql, andOperator);

        if (orderByComparator != null) {
            sql = CustomSQLUtil.replaceOrderBy(sql, orderByComparator);
        }

        SQLQuery q = session.createSynchronizedSQLQuery(sql);

        q.addEntity("DDMTemplate", DDMTemplateImpl.class);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(companyId);

        if (groupIds != null) {
            qPos.add(groupIds);
        }

        if (classNameIds != null) {
            qPos.add(classNameIds);
        }

        if (classPKs != null) {
            qPos.add(classPKs);
        }

        qPos.add(resourceClassNameId);
        qPos.add(names, 2);
        qPos.add(descriptions, 2);
        qPos.add(types, 2);
        qPos.add(modes, 2);
        qPos.add(languages, 2);

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

        return (List<DDMTemplate>) QueryUtil.list(q, getDialect(), start, end);
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

---

From source file:com.liferay.dynamic.data.mapping.service.persistence.impl.DDMTemplateFinderImpl.java

License:Open Source License

protected String getStatus(int status) {
    if (status == WorkflowConstants.STATUS_ANY) {
        return StringPool.BLANK;
    }/*from  www .jav a  2s .c  o  m*/

    StringBundler sb = new StringBundler(4);

    sb.append("AND EXISTS (SELECT 1 FROM DDMTemplateVersion WHERE ");
    sb.append("(DDMTemplateVersion.templateId = DDMTemplate.templateId) ");
    sb.append("AND (DDMTemplateVersion.version = DDMTemplate.version) ");
    sb.append("AND (DDMTemplateVersion.status = ?))");

    return sb.toString();
}

---

From source file:com.liferay.dynamic.data.mapping.service.test.DDMStructureLocalServiceTest.java

License:Open Source License

@Test
public void testSearchByAnyStatus() throws Exception {
    addStructure(0, _classNameId, null, StringUtil.randomString(), StringPool.BLANK, read("test-structure.xsd"),
            StorageType.JSON.getValue(), DDMStructureConstants.TYPE_DEFAULT, WorkflowConstants.STATUS_APPROVED);

    addStructure(0, _classNameId, null, StringUtil.randomString(), StringPool.BLANK, read("test-structure.xsd"),
            StorageType.JSON.getValue(), DDMStructureConstants.TYPE_DEFAULT, WorkflowConstants.STATUS_DRAFT);

    List<DDMStructure> structures = DDMStructureLocalServiceUtil.search(TestPropsValues.getCompanyId(),
            new long[] { group.getGroupId() }, _classNameId, null, null, null,
            DDMStructureConstants.TYPE_DEFAULT, WorkflowConstants.STATUS_ANY, true, QueryUtil.ALL_POS,
            QueryUtil.ALL_POS, null);/*from ww w.  j  a va2s .c  o  m*/

    Assert.assertEquals(structures.toString(), 2, structures.size());
}

---

From source file:com.liferay.dynamic.data.mapping.service.test.DDMStructureLocalServiceTest.java

License:Open Source License

@Test
public void testSearchCountByType() throws Exception {
    int initialCount = DDMStructureLocalServiceUtil.searchCount(TestPropsValues.getCompanyId(),
            new long[] { group.getGroupId() }, _classNameId, null, null, null,
            DDMStructureConstants.TYPE_FRAGMENT, WorkflowConstants.STATUS_ANY, true);

    addStructure(0, _classNameId, null, StringUtil.randomString(), StringPool.BLANK, read("test-structure.xsd"),
            StorageType.JSON.getValue(), DDMStructureConstants.TYPE_FRAGMENT,
            WorkflowConstants.STATUS_APPROVED);

    int count = DDMStructureLocalServiceUtil.searchCount(TestPropsValues.getCompanyId(),
            new long[] { group.getGroupId() }, _classNameId, null, null, null,
            DDMStructureConstants.TYPE_FRAGMENT, WorkflowConstants.STATUS_ANY, true);

    Assert.assertEquals(initialCount + 1, count);
}

---

From source file:com.liferay.dynamic.data.mapping.service.test.DDMStructureServiceTest.java

License:Open Source License

@Test
public void testGetStructures() throws Exception {
    addStructure(_classNameId, StringUtil.randomString());
    addStructure(_classNameId, StringUtil.randomString());
    addStructure(_classNameId, StringUtil.randomString());

    long[] groupIds = { group.getGroupId(), _group.getGroupId() };

    List<DDMStructure> structures = DDMStructureServiceUtil.getStructures(TestPropsValues.getCompanyId(),
            groupIds, _classNameId, WorkflowConstants.STATUS_ANY);

    Assert.assertEquals(structures.toString(), 3, structures.size());
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• »