protected void addDefaultCriteria(DynamicQuery dynamicQuery) { if (_companyId > 0) { Property property = PropertyFactoryUtil.forName("companyId"); dynamicQuery.add(property.eq(_companyId)); } if (_groupId > 0) { Property property = PropertyFactoryUtil.forName( _groupIdPropertyName); dynamicQuery.add(property.eq(_groupId)); } }
@Override public Criterion getDateRangeCriteria(String propertyName) { if (!hasDateRange()) { return null; } Conjunction conjunction = RestrictionsFactoryUtil.conjunction(); Property property = PropertyFactoryUtil.forName(propertyName); conjunction.add(property.le(_endDate)); conjunction.add(property.ge(_startDate)); return conjunction; }
"lastPublishDate"); disjunction.add(lastPublishDateProperty.isNull()); dynamicQuery.add(classNameIdProperty.eq( stagedModelType.getReferrerClassNameId())); dynamicQuery.add(classNameIdProperty.isNotNull()); dynamicQuery.add(workflowStatusProperty.ne( WorkflowConstants.STATUS_IN_TRASH)); StagedModelDataHandler<?> stagedModelDataHandler = StagedModelDataHandlerRegistryUtil.getStagedModelDataHandler(JournalArticle.class.getName()); dynamicQuery.add(workflowStatusProperty.in( stagedModelDataHandler.getExportableStatuses()));
@Override public void addCriteria(DynamicQuery dynamicQuery) { portletDataContext.addDateRangeCriteria(dynamicQuery, "modifiedDate"); StagedModelType stagedModelType = exportActionableDynamicQuery.getStagedModelType(); long referrerClassNameId = stagedModelType.getReferrerClassNameId(); Property classNameIdProperty = PropertyFactoryUtil.forName( "classNameId"); if ((referrerClassNameId != StagedModelType.REFERRER_CLASS_NAME_ID_ALL) && (referrerClassNameId != StagedModelType.REFERRER_CLASS_NAME_ID_ANY)) { dynamicQuery.add(classNameIdProperty.eq( stagedModelType.getReferrerClassNameId())); } else if (referrerClassNameId == StagedModelType.REFERRER_CLASS_NAME_ID_ANY) { dynamicQuery.add(classNameIdProperty.isNotNull()); } } });
.forClass(MBThread.class, PortalClassLoaderUtil.getClassLoader()) .add(PropertyFactoryUtil.forName("groupId").eq(scopeGroupId)) .add(PropertyFactoryUtil.forName("status").eq( WorkflowConstants.STATUS_APPROVED)) .add(PropertyFactoryUtil.forName("categoryId").in( categoryIdsRecursively)) .addOrder(OrderFactoryUtil.desc("priority"))
.setProjection(ProjectionFactoryUtil.property("threadId")) .add(PropertyFactoryUtil.forName("userId") .eq(currentUserId)); .forClass(MBThread.class, PortalClassLoaderUtil.getClassLoader()) .add(PropertyFactoryUtil.forName("categoryId").in( categoryIds)) .add(PropertyFactoryUtil.forName("threadId").notIn( readThreadIds)) .add(PropertyFactoryUtil.forName("status").eq( WorkflowConstants.STATUS_APPROVED));
"lastPublishDate"); disjunction.add(lastPublishDateProperty.isNull()); dynamicQuery.add(workflowStatusProperty.ne( WorkflowConstants.STATUS_IN_TRASH)); StagedModelDataHandler<?> stagedModelDataHandler = StagedModelDataHandlerRegistryUtil.getStagedModelDataHandler(JournalFolder.class.getName()); dynamicQuery.add(workflowStatusProperty.in( stagedModelDataHandler.getExportableStatuses()));
protected DynamicQuery getRecordVersionDynamicQuery() { StagedModelDataHandler<?> stagedModelDataHandler = StagedModelDataHandlerRegistryUtil.getStagedModelDataHandler( DDMFormInstanceRecord.class.getName()); Class<?> clazz = stagedModelDataHandler.getClass(); DynamicQuery formInstanceRecordVersionDynamicQuery = DynamicQueryFactoryUtil.forClass( DDMFormInstanceRecordVersion.class, "formInstanceRecordVersion", clazz.getClassLoader()); formInstanceRecordVersionDynamicQuery.setProjection( ProjectionFactoryUtil.property("formInstanceRecordId")); Property statusProperty = PropertyFactoryUtil.forName("status"); formInstanceRecordVersionDynamicQuery.add( statusProperty.in(stagedModelDataHandler.getExportableStatuses())); formInstanceRecordVersionDynamicQuery.add( RestrictionsFactoryUtil.eqProperty( "formInstanceRecordVersion.version", "version")); formInstanceRecordVersionDynamicQuery.add( RestrictionsFactoryUtil.eqProperty( "formInstanceRecordVersion.formInstanceRecordId", "formInstanceRecordId")); return formInstanceRecordVersionDynamicQuery; }
@Override public void addCriteria(DynamicQuery dynamicQuery) { portletDataContext.addDateRangeCriteria(dynamicQuery, "modifiedDate"); StagedModelType stagedModelType = exportActionableDynamicQuery.getStagedModelType(); long referrerClassNameId = stagedModelType.getReferrerClassNameId(); Property classNameIdProperty = PropertyFactoryUtil.forName( "classNameId"); if ((referrerClassNameId != StagedModelType.REFERRER_CLASS_NAME_ID_ALL) && (referrerClassNameId != StagedModelType.REFERRER_CLASS_NAME_ID_ANY)) { dynamicQuery.add(classNameIdProperty.eq( stagedModelType.getReferrerClassNameId())); } else if (referrerClassNameId == StagedModelType.REFERRER_CLASS_NAME_ID_ANY) { dynamicQuery.add(classNameIdProperty.isNotNull()); } } });
@Override public ExportActionableDynamicQuery getExportActionableDynamicQuery( PortletDataContext portletDataContext) { ExportActionableDynamicQuery exportActionableDynamicQuery = _ddmFormInstanceRecordLocalService.getExportActionableDynamicQuery( portletDataContext); final ActionableDynamicQuery.AddCriteriaMethod addCriteriaMethod = exportActionableDynamicQuery.getAddCriteriaMethod(); exportActionableDynamicQuery.setAddCriteriaMethod( dynamicQuery -> { addCriteriaMethod.addCriteria(dynamicQuery); Property formInstanceRecordIdProperty = PropertyFactoryUtil.forName("formInstanceRecordId"); DynamicQuery formInstanceRecordVersionDynamicQuery = getRecordVersionDynamicQuery(); dynamicQuery.add( formInstanceRecordIdProperty.in( formInstanceRecordVersionDynamicQuery)); Property formInstanceIdProperty = PropertyFactoryUtil.forName( "formInstanceId"); DynamicQuery formInstanceDynamicQuery = getFormInstanceDynamicQuery(); dynamicQuery.add( formInstanceIdProperty.in(formInstanceDynamicQuery)); }); return exportActionableDynamicQuery; }
private void _transformRatingsData( final String classPKFieldName, final long classPKFieldValue, final String className, RatingsType fromRatingsType, RatingsType toRatingsType) throws PortalException { if ((toRatingsType == null) || fromRatingsType.equals(toRatingsType)) { return; } RatingsDataTransformer ratingsDataTransformer = _serviceTracker.getService(); ActionableDynamicQuery.PerformActionMethod<RatingsEntry> performActionMethod = ratingsDataTransformer.transformRatingsData( fromRatingsType, toRatingsType); if (performActionMethod == null) { return; } ActionableDynamicQuery ratingsEntryActionableDynamicQuery = RatingsEntryLocalServiceUtil.getActionableDynamicQuery(); ratingsEntryActionableDynamicQuery.setAddCriteriaMethod( dynamicQuery -> { Property property = PropertyFactoryUtil.forName( classPKFieldName); dynamicQuery.add(property.eq(classPKFieldValue)); property = PropertyFactoryUtil.forName("className"); dynamicQuery.add(property.eq(className)); }); ratingsEntryActionableDynamicQuery.setPerformActionMethod( performActionMethod); ratingsEntryActionableDynamicQuery.performActions(); }
groupIdProperty.eq(portletDataContext.getScopeGroupId())); dynamicQuery.add(groupIdProperty.eq(0L)); classNameIdProperty.eq(stagedModelType.getClassNameId())); referrerClassNameIdProperty.eq( stagedModelType.getReferrerClassNameId())); StagedModelType.REFERRER_CLASS_NAME_ID_ANY) { dynamicQuery.add(referrerClassNameIdProperty.isNotNull()); dynamicQuery.add(typeProperty.eq(SystemEventConstants.TYPE_DELETE));
protected void addCreateDateProperty( PortletDataContext portletDataContext, DynamicQuery dynamicQuery) { if (!portletDataContext.hasDateRange()) { return; } Property createDateProperty = PropertyFactoryUtil.forName("createDate"); Date startDate = portletDataContext.getStartDate(); dynamicQuery.add(createDateProperty.ge(startDate)); Date endDate = portletDataContext.getEndDate(); dynamicQuery.add(createDateProperty.le(endDate)); }