app\components\search\SearchProductsByPropertyHandler

Complexity

Total Complexity

2

Size/Duplication

Total Lines	48
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	5

Importance

Changes	2
Bugs	1	Features	1

1 Method

Rating	Name	Duplication	Size	Complexity
B	editQuery()	0	45	2

<?php

namespace app\components\search;


use app\models\Object;
use app\models\ObjectStaticValues;
use app\models\PropertyStaticValues;
use app\modules\shop\models\Product;
use yii\db\Query;
use yii\helpers\ArrayHelper;

class SearchProductsByPropertyHandler implements SearchInterface
{
    public static function editQuery(SearchEvent $event)
    {
        /** @var \app\modules\shop\ShopModule $module */
        $module = \Yii::$app->modules['shop'];

        /** @var \app\modules\shop\ShopModule $module */
        $properties = (new Query())
            ->select('`id`')
            ->from(PropertyStaticValues::tableName())
            ->where('`name` LIKE :q')
            ->addParams([':q' => '%' . $event->q . '%'])
            ->all();


        $event->activeQuery->select('{{%object_static_values}}.object_model_id')
            ->distinct(true)
            ->from(ObjectStaticValues::tableName())
            ->where('{{%object_static_values}}.object_id = :objectId')
            ->addParams([':objectId' => Object::getForClass(Product::className())->id])
            ->andWhere([
                'in',
                '{{%object_static_values}}.property_static_value_id',
                ArrayHelper::getColumn($properties, 'id')
            ]);

        if ($module->allowSearchGeneratedProducts != 1) {

            $event->activeQuery->innerJoin(
                '{{%product}}',
                '{{%product}}.id = {{%object_static_values}}.object_model_id'
            );

            $event->activeQuery->andWhere(
                [
                    '{{%product}}.parent_id' => 0,
                    '{{%product}}.active' => 1
                ]
            );
        }

        $event->setFunctionSearch(function ($activeQuery) {
            return ArrayHelper::getColumn($activeQuery->all(), 'object_model_id');
        });

    }
}