DevGroup-ru / dotplant2

    {

        Yii::$app->response->format = Response::FORMAT_JSON;

        $query = Product::find()->orderBy('sort_order');

        foreach (['name', 'content'] as $attribute) {

            $query->orWhere(['like', $attribute, $term]);

        }

        $products = $query->limit(20)->all();

        $result = [];

        /** @var Product $product */

        $query = Product::find()

            ->select(['id', 'name', 'main_category_id', 'slug', 'sku'])

            ->orderBy(['sort_order' => SORT_ASC, 'id' => SORT_DESC]);

        foreach (['name', 'content', 'sku'] as $attribute) {

            $query->orWhere(['like', $attribute, $term]);

        }

        $query->andWhere(['active'=>1]);

        $products = $query->limit(Yii::$app->getModule('core')->autoCompleteResultsCount)->all();

        $result = [];