/** * {@inheritdoc} */ public function addFieldFilter($field, $operator, $value, $locale = null, $scope = null, $options = []) { if (Operators::IS_EMPTY !== $operator && Operators::IS_NOT_EMPTY !== $operator) { $this->checkValue($field, $value); if (FieldFilterHelper::getProperty($field) === FieldFilterHelper::CODE_PROPERTY) { $value = $this->objectIdResolver->getIdsFromCodes('group', $value); } } $rootAlias = $this->qb->getRootAlias(); $entityAlias = $this->getUniqueAlias('filter' . FieldFilterHelper::getCode($field)); $this->qb->leftJoin($rootAlias . '.' . FieldFilterHelper::getCode($field), $entityAlias); switch ($operator) { case Operators::IN_LIST: $this->qb->andWhere($this->qb->expr()->in($entityAlias . '.id', $value)); break; case Operators::NOT_IN_LIST: $this->qb->andWhere($this->qb->expr()->notIn($rootAlias . '.id', $this->getNotInSubquery(FieldFilterHelper::getCode($field), $value))); break; case Operators::IS_EMPTY: case Operators::IS_NOT_EMPTY: $this->qb->andWhere($this->prepareCriteriaCondition($entityAlias . '.id', $operator, null)); break; } return $this; }
/** * {@inheritdoc} */ public function addAttributeFilter(AttributeInterface $attribute, $operator, $value, $locale = null, $scope = null, $options = []) { try { $options = $this->resolver->resolve($options); } catch (\Exception $e) { throw InvalidArgumentException::expectedFromPreviousException($e, $attribute->getCode(), 'filter', 'option'); } $this->checkLocaleAndScope($attribute, $locale, $scope, 'option'); $field = $options['field']; if (Operators::IS_EMPTY !== $operator) { $this->checkValue($field, $value); } $joinAlias = $this->getUniqueAlias('filter' . $attribute->getCode(), true); // prepare join value condition $optionAlias = $joinAlias . '.option'; if (Operators::IS_EMPTY === $operator) { $this->qb->leftJoin($this->qb->getRootAlias() . '.values', $joinAlias, 'WITH', $this->prepareAttributeJoinCondition($attribute, $joinAlias, $locale, $scope)); $this->qb->andWhere($this->qb->expr()->isNull($optionAlias)); } else { // inner join to value $condition = $this->prepareAttributeJoinCondition($attribute, $joinAlias, $locale, $scope); if (FieldFilterHelper::getProperty($field) === FieldFilterHelper::CODE_PROPERTY) { $value = $this->objectIdResolver->getIdsFromCodes('option', $value); } $condition .= ' AND ( ' . $this->qb->expr()->in($optionAlias, $value) . ' ) '; $this->qb->innerJoin($this->qb->getRootAlias() . '.values', $joinAlias, 'WITH', $condition); } return $this; }
/** * {@inheritdoc} */ public function addFieldFilter($field, $operator, $value, $locale = null, $scope = null, $options = []) { $categoryIds = $value; if ($operator !== Operators::UNCLASSIFIED) { $this->checkValue($field, $value); if (FieldFilterHelper::getProperty($field) === FieldFilterHelper::CODE_PROPERTY) { $categoryIds = $this->objectIdResolver->getIdsFromCodes('category', $value); } } switch ($operator) { case Operators::IN_LIST: $this->itemCategoryRepo->applyFilterByCategoryIds($this->qb, $categoryIds, true); break; case Operators::NOT_IN_LIST: $this->itemCategoryRepo->applyFilterByCategoryIds($this->qb, $categoryIds, false); break; case Operators::IN_CHILDREN_LIST: $categoryIds = $this->getAllChildrenIds($categoryIds); $this->itemCategoryRepo->applyFilterByCategoryIds($this->qb, $categoryIds, true); break; case Operators::NOT_IN_CHILDREN_LIST: $categoryIds = $this->getAllChildrenIds($categoryIds); $this->itemCategoryRepo->applyFilterByCategoryIds($this->qb, $categoryIds, false); break; case Operators::UNCLASSIFIED: $this->itemCategoryRepo->applyFilterByUnclassified($this->qb); break; case Operators::IN_LIST_OR_UNCLASSIFIED: $this->itemCategoryRepo->applyFilterByCategoryIdsOrUnclassified($this->qb, $categoryIds); break; } return $this; }
/** * {@inheritdoc} */ public function addAttributeFilter(AttributeInterface $attribute, $operator, $value, $locale = null, $scope = null, $options = []) { try { $options = $this->resolver->resolve($options); } catch (\Exception $e) { throw InvalidArgumentException::expectedFromPreviousException($e, $attribute->getCode(), 'filter', 'options'); } $this->checkLocaleAndScope($attribute, $locale, $scope, 'options'); if ($operator != Operators::IS_EMPTY) { $this->checkValue($options['field'], $value); } $joinAlias = $this->getUniqueAlias('filter' . $attribute->getCode()); $joinAliasOpt = $this->getUniqueAlias('filterO' . $attribute->getCode()); $backendField = sprintf('%s.%s', $joinAliasOpt, 'id'); if (Operators::IS_EMPTY === $operator) { $this->qb->leftJoin($this->qb->getRootAlias() . '.values', $joinAlias, 'WITH', $this->prepareAttributeJoinCondition($attribute, $joinAlias, $locale, $scope)); $this->qb->leftJoin($joinAlias . '.' . $attribute->getBackendType(), $joinAliasOpt)->andWhere($this->qb->expr()->isNull($backendField)); } else { if (FieldFilterHelper::getProperty($options['field']) === FieldFilterHelper::CODE_PROPERTY) { $value = $this->objectIdResolver->getIdsFromCodes('option', $value); } $this->qb->innerJoin($this->qb->getRootAlias() . '.values', $joinAlias, 'WITH', $this->prepareAttributeJoinCondition($attribute, $joinAlias, $locale, $scope))->innerJoin($joinAlias . '.' . $attribute->getBackendType(), $joinAliasOpt, 'WITH', $this->qb->expr()->in($backendField, $value)); } return $this; }
/** * {@inheritdoc} */ public function addFieldFilter($field, $operator, $value, $locale = null, $scope = null, $options = []) { if (Operators::IS_EMPTY !== $operator) { $this->checkValue($field, $value); if (FieldFilterHelper::getProperty($field) === FieldFilterHelper::CODE_PROPERTY) { $value = $this->objectIdResolver->getIdsFromCodes('family', $value); } } $fieldCode = FieldFilterHelper::getCode($field); switch ($operator) { case Operators::IN_LIST: $expr = new Expr(); $this->qb->addAnd($expr->field($fieldCode)->in($value)); break; case Operators::NOT_IN_LIST: $this->qb->field($fieldCode)->notIn($value); break; case Operators::IS_EMPTY: $exists = new Expr(); $equals = new Expr(); $expr = new Expr(); $exists->field($fieldCode)->exists(false); $equals->field($fieldCode)->equals(null); $expr->addOr($exists)->addOr($equals); $this->qb->addAnd($expr); break; } return $this; }
/** * {@inheritdoc} */ public function addFieldFilter($field, $operator, $value, $locale = null, $scope = null, $options = []) { $this->checkValue($field, $value); $value = is_array($value) ? $value : [$value]; if (FieldFilterHelper::getProperty($field) === FieldFilterHelper::CODE_PROPERTY) { $value = $this->objectIdResolver->getIdsFromCodes('group', $value); } $value = array_map('intval', $value); $this->applyFilter($value, 'groupIds', $operator); return $this; }
/** * {@inheritdoc} */ public function addFieldFilter($field, $operator, $value, $locale = null, $scope = null, $options = []) { if (Operators::IS_EMPTY !== $operator && Operators::IS_NOT_EMPTY !== $operator) { $this->checkValue($field, $value); if (FieldFilterHelper::CODE_PROPERTY === FieldFilterHelper::getProperty($field)) { $value = $this->objectIdResolver->getIdsFromCodes('group', $value); } else { $value = array_map('intval', $value); } } $this->applyFilter('groupIds', $operator, $value); return $this; }
/** * {@inheritdoc} */ public function addAttributeFilter(AttributeInterface $attribute, $operator, $value, $locale = null, $scope = null, $options = []) { try { $options = $this->resolver->resolve($options); } catch (\Exception $e) { throw InvalidArgumentException::expectedFromPreviousException($e, $attribute->getCode(), 'filter', 'option'); } $this->checkLocaleAndScope($attribute, $locale, $scope, 'option'); if (Operators::IS_EMPTY !== $operator) { $this->checkValue($options['field'], $value); if (FieldFilterHelper::getProperty($options['field']) === FieldFilterHelper::CODE_PROPERTY) { $value = $this->objectIdResolver->getIdsFromCodes('option', $value, $attribute); } } $mongoField = sprintf('%s.%s.id', ProductQueryUtility::NORMALIZED_FIELD, ProductQueryUtility::getNormalizedValueFieldFromAttribute($attribute, $locale, $scope)); $this->applyFilter($operator, $value, $mongoField, $options); return $this; }
/** * {@inheritdoc} */ public function addFieldFilter($field, $operator, $value, $locale = null, $scope = null, $options = []) { if (Operators::IS_EMPTY !== $operator) { $this->checkValue($field, $value); if (FieldFilterHelper::getProperty($field) === FieldFilterHelper::CODE_PROPERTY) { $value = $this->objectIdResolver->getIdsFromCodes('group', $value); } } $rootAlias = $this->qb->getRootAlias(); $entityAlias = $this->getUniqueAlias('filter' . FieldFilterHelper::getCode($field)); $this->qb->leftJoin($rootAlias . '.' . FieldFilterHelper::getCode($field), $entityAlias); if ($operator === Operators::IN_LIST) { $this->qb->andWhere($this->qb->expr()->in($entityAlias . '.id', $value)); } elseif ($operator === Operators::NOT_IN_LIST) { $this->qb->andWhere($this->qb->expr()->orX($this->qb->expr()->notIn($entityAlias . '.id', $value), $this->qb->expr()->isNull($entityAlias . '.id'))); } elseif ($operator === Operators::IS_EMPTY) { $this->qb->andWhere($this->qb->expr()->isNull($entityAlias . '.id')); } return $this; }