app\components\search\SearchProductsByPropertyHandler::editQuery()

Complexity

Conditions	2
Paths	2

Size

Total Lines	45
Code Lines	26

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	1	Features	1

<?php
    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');
        });

    }
}