EavAttributeCondition.php

Go to the documentation of this file.

<?php
declare(strict_types=1);

namespace Magento\Catalog\Model\Api\SearchCriteria\CollectionProcessor\ConditionProcessor\ConditionBuilder;

use Magento\Framework\Api\SearchCriteria\CollectionProcessor\ConditionProcessor\CustomConditionInterface;
use Magento\Framework\Api\Filter;
use Magento\Catalog\Model\ResourceModel\Product\Collection;
use Magento\Catalog\Model\ResourceModel\Eav\Attribute;

class EavAttributeCondition implements CustomConditionInterface
{
    private $resourceConnection;

    private $eavConfig;

    public function __construct(
        \Magento\Eav\Model\Config $eavConfig,
        \Magento\Framework\App\ResourceConnection $resourceConnection
    ) {
        $this->eavConfig = $eavConfig;
        $this->resourceConnection = $resourceConnection;
    }

    public function build(Filter $filter): string
    {
        $attribute = $this->getAttributeByCode($filter->getField());
        $tableAlias = 'ca_' . $attribute->getAttributeCode();

        $conditionType = $this->mapConditionType($filter->getConditionType());
        $conditionValue = $this->mapConditionValue($conditionType, $filter->getValue());

        // NOTE: store scope was ignored intentionally to perform search across all stores
        $attributeSelect = $this->resourceConnection->getConnection()
            ->select()
            ->from(
                [$tableAlias => $attribute->getBackendTable()],
                $tableAlias . '.' . $attribute->getEntityIdField()
            )->where(
                $this->resourceConnection->getConnection()->prepareSqlCondition(
                    $tableAlias . '.' . $attribute->getIdFieldName(),
                    ['eq' => $attribute->getAttributeId()]
                )
            )->where(
                $this->resourceConnection->getConnection()->prepareSqlCondition(
                    $tableAlias . '.value',
                    [$conditionType => $conditionValue]
                )
            );

        return $this->resourceConnection
            ->getConnection()
            ->prepareSqlCondition(
                Collection::MAIN_TABLE_ALIAS . '.' . $attribute->getEntityIdField(),
                [
                    'in' => $attributeSelect
                ]
            );
    }

    private function getAttributeByCode(string $field): Attribute
    {
        return $this->eavConfig->getAttribute(\Magento\Catalog\Model\Product::ENTITY, $field);
    }

    private function mapConditionType(string $conditionType): string
    {
        $conditionsMap = [
            'eq' => 'in',
            'neq' => 'nin'
        ];

        return isset($conditionsMap[$conditionType]) ? $conditionsMap[$conditionType] : $conditionType;
    }

    private function mapConditionValue(string $conditionType, string $conditionValue): string
    {
        $conditionsMap = ['like', 'nlike'];

        if (in_array($conditionType, $conditionsMap)) {
            $conditionValue = '%' . $conditionValue . '%';
        }

        return $conditionValue;
    }
}