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

Complexity

Conditions	1
Paths	1

Size

Total Lines	23
Code Lines	15

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	1

<?php
    public static function editQuery(SearchEvent $event)
    {
        /** @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_model_id`')
            ->distinct(true)
            ->from(ObjectStaticValues::tableName())
            ->where('`object_id` = :objectId')
            ->addParams([':objectId' => 1])
            ->andWhere(['in', '`property_static_value_id`', ArrayHelper::getColumn($properties, 'id')]);

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

    }
}