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

Complexity

Conditions	2
Paths	2

Size

Total Lines	25
Code Lines	14

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

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

        $event->activeQuery->select('`id`')
            ->from(Product::tableName())
            ->orWhere('`name` LIKE :q')
            ->orWhere('`h1` LIKE :q')
            ->orWhere('`content` LIKE :q')
            ->orWhere('`sku` LIKE :q')
            ->addParams([':q' => '%' . $event->q . '%'])
            ->andWhere(
                [
                    'active' => 1,
                ]
            );
        if ($module->allowSearchGeneratedProducts != 1) {
            $event->activeQuery->andWhere(
                [
                    'parent_id' => 0
                ]
            );
        }
    }
}