app\modules\shop\controllers\BackendProductController

Complexity

Total Complexity

83

Size/Duplication

Total Lines	714
Duplicated Lines	22.97 %

Coupling/Cohesion

Components	1
Dependencies	34

Importance

Changes

0

12 Methods

Rating	Name	Duplication	Size	Complexity
A	behaviors()	14	14	1
B	actions()	27	81	7
A	actionIndex()	0	21	2
F	actionEdit()	15	141	22
F	actionGenerate()	34	141	18
C	actionClone()	47	123	13
A	actionDelete()	0	24	5
A	actionRemoveAll()	0	13	3
A	sortModels()	19	19	2
B	generateOptions()	0	24	6
A	generateCase()	8	8	2
A	actionAjaxRelatedProduct()	0	23	2

<?php

namespace app\modules\shop\controllers;

use app\backend\actions\PropertyHandler;
use app\backend\components\BackendController;
use app\backend\events\BackendEntityEditEvent;
use app\modules\image\widgets\views\AddImageAction;
use app\modules\shop\models\Category;
use app\modules\image\models\Image;
use app\models\BaseObject;
use app\models\ObjectPropertyGroup;
use app\modules\shop\models\Currency;
use app\modules\shop\models\Product;
use app\models\Property;
use app\models\PropertyStaticValues;
use app\models\ViewObject;
use app\properties\HasProperties;
use app\modules\image\widgets\RemoveAction;
use app\modules\image\widgets\SaveInfoAction;
use app\modules\image\widgets\UploadAction;
use app\backend\actions\UpdateEditable;
use devgroup\JsTreeWidget\AdjacencyFullTreeDataAction;
use Yii;
use yii\data\ActiveDataProvider;
use yii\db\Query;
use yii\filters\AccessControl;
use yii\helpers\ArrayHelper;
use yii\helpers\Json;
use yii\helpers\Url;
use yii\web\NotFoundHttpException;
use yii\web\ServerErrorHttpException;
use app\backend\actions\MassPublishAction;
use app\backend\actions\CategoryMovementsAction;
use app\modules\shop\actions\BatchEditPriceAction;

class BackendProductController extends BackendController
{
    const EVENT_BACKEND_PRODUCT_EDIT = 'backend-product-edit';
    const EVENT_BACKEND_PRODUCT_EDIT_SAVE = 'backend-product-edit-save';
    const EVENT_BACKEND_PRODUCT_EDIT_FORM = 'backend-product-edit-form';
    const EVENT_BACKEND_PRODUCT_AFTER_SAVE = 'backend-product-after-save';

    /**
     * @inheritdoc
     * @return array

Consider making the return type a bit more specific; maybe use array<string,array<string,string|array<string,boolean|string[]>[]>>.

     */
    public function behaviors()
    {
        return [
            'access' => [
                'class' => AccessControl::className(),

The method yii\base\BaseObject::className() has been deprecated with message: since 2.0.14. On PHP >=5.5, use `::class` instead.

                'rules' => [
                    [
                        'allow' => true,
                        'roles' => ['product manage'],
                    ],
                ],
            ],
        ];
    }

    /**
     * @inheritdoc
     * @return array

Consider making the return type a bit more specific; maybe use array<string,array>.

     */
    public function actions()
    {
        $product = Yii::$container->get(Product::class);
        return [
            'getTree' => [
                'class' => AdjacencyFullTreeDataAction::className(),

The method yii\base\BaseObject::className() has been deprecated with message: since 2.0.14. On PHP >=5.5, use `::class` instead.

                'class_name' => Category::className(),

The method yii\base\BaseObject::className() has been deprecated with message: since 2.0.14. On PHP >=5.5, use `::class` instead.

                'model_label_attribute' => 'name',
            ],
            'getCatTree' => [
                'class' => 'app\backend\actions\JSSelectableTreeGetTree',
                'modelName' => 'app\modules\shop\models\Category',
                'label_attribute' => 'name',
                'vary_by_type_attribute' => null,
            ],
            'addImage' => [
                'class' => AddImageAction::className(),

The method yii\base\BaseObject::className() has been deprecated with message: since 2.0.14. On PHP >=5.5, use `::class` instead.

            ],
            'upload' => [
                'class' => UploadAction::className(),

The method yii\base\BaseObject::className() has been deprecated with message: since 2.0.14. On PHP >=5.5, use `::class` instead.

                'upload' => 'theme/resources/product-images',
            ],
            'remove' => [
                'class' => RemoveAction::className(),

The method yii\base\BaseObject::className() has been deprecated with message: since 2.0.14. On PHP >=5.5, use `::class` instead.

                'uploadDir' => 'theme/resources/product-images',
            ],
            'save-info' => [
                'class' => SaveInfoAction::className(),

The method yii\base\BaseObject::className() has been deprecated with message: since 2.0.14. On PHP >=5.5, use `::class` instead.

            ],
            'update-editable' => [
                'class' => UpdateEditable::className(),

The method yii\base\BaseObject::className() has been deprecated with message: since 2.0.14. On PHP >=5.5, use `::class` instead.

                'modelName' => get_class($product),
                'allowedAttributes' => [
                    'currency_id' => function (Product $model, $attribute) {

The parameter $attribute is not used and could be removed.

                        if ($model === null || $model->currency === null || $model->currency_id === 0) {

The property currency does not seem to exist. Did you mean currency_id?

                            return null;
                        }
                        return \yii\helpers\Html::tag(
                            'div',
                            $model->currency->name,

The property currency does not seem to exist. Did you mean currency_id?

                            ['class' => $model->currency->name]

The property currency does not seem to exist. Did you mean currency_id?

                        );
                    },
                    'price',
                    'old_price',
                    'active' => function (Product $model) {
                        if ($model === null || $model->active === null) {
                            return null;
                        }
                        if ($model->active === 1) {
                            $label_class = 'label-success';
                            $value = 'Active';
                        } else {
                            $value = 'Inactive';
                            $label_class = 'label-default';
                        }
                        return \yii\helpers\Html::tag(
                            'span',
                            Yii::t('app', $value),
                            ['class' => "label $label_class"]
                        );
                    },
                ],
            ],
            'property-handler' => [
                'class' => PropertyHandler::className(),

The method yii\base\BaseObject::className() has been deprecated with message: since 2.0.14. On PHP >=5.5, use `::class` instead.

                'modelName' => get_class($product)
            ],
            'publish-switch' => [
                'class' => MassPublishAction::className(),

The method yii\base\BaseObject::className() has been deprecated with message: since 2.0.14. On PHP >=5.5, use `::class` instead.

                'modelName' => get_class($product),
                'attribute' => 'active',
            ],
            'categoryMovements' => [
                'class' => CategoryMovementsAction::className(),

The method yii\base\BaseObject::className() has been deprecated with message: since 2.0.14. On PHP >=5.5, use `::class` instead.

            ],
            'batch-edit-price' => [
                'class' => BatchEditPriceAction::className(),

The method yii\base\BaseObject::className() has been deprecated with message: since 2.0.14. On PHP >=5.5, use `::class` instead.

            ]
        ];
    }

    /**
     * @return string
     * @throws ServerErrorHttpException
     */
    public function actionIndex()
    {
        $product = Yii::$container->get(Product::class);
        $searchModel = $product;
        $params = Yii::$app->request->get();
        /** @var ActiveDataProvider $dataProvider */
        $dataProvider = $searchModel->search($params);
        if (null !== $catId = Yii::$app->request->get('parent_id')) {
            $dataProvider->query->leftJoin(
                BaseObject::getForClass(get_class($product))->categories_table_name . ' cp',
                'cp.object_model_id=product.id'
            )->andWhere('product.parent_id=0 AND cp.category_id=:cur', [':cur' => $catId]);
        }
        return $this->render(
            'index',
            [
                'dataProvider' => $dataProvider,
                'searchModel' => $searchModel,
            ]
        );
    }

    /**
     * @param null $id
     * @return string|\yii\web\Response
     * @throws NotFoundHttpException
     * @throws ServerErrorHttpException
     * @throws \Exception
     * @throws \yii\base\InvalidRouteException
     */
    public function actionEdit($id = null)
    {
        $product = Yii::$container->get(Product::class);
        /*
         * @todo Продумать механизм сохранения изображений для нового продукта.
         * Сейчас для нового продукта скрывается форма добавления изображений.
         */
        if (null === $object = BaseObject::getForClass($product::className())) {
            throw new ServerErrorHttpException;
        }

        /** @var null|Product|HasProperties|\devgroup\TagDependencyHelper\ActiveRecordHelper $model */
        $model = null;
        $parent = null;
        if (null === $id) {
            $model = $product;
            $model->loadDefaultValues();
            $model->currency_id = Currency::getMainCurrency()->id;
            $parent_id = Yii::$app->request->get('owner_id', 0);
            if (0 !== intval($parent_id) && null !== $product::findById($parent_id)) {
                $model->parent_id = $parent_id;
            }
            $model->measure_id = $this->module->defaultMeasureId;
        } else {
            $model = $product::findById($id, null);
            if ((null !== $model) && ($model->parent_id > 0)) {
                $parent = $product::findById($model->parent_id, null);
            }
        }

        if (null === $model) {
            throw new NotFoundHttpException();
        }

        $model->loadRelatedProductsArray();

        $event = new BackendEntityEditEvent($model);
        $this->trigger(self::EVENT_BACKEND_PRODUCT_EDIT, $event);

        $post = \Yii::$app->request->post();

        if ($event->isValid && $model->load($post)) {
            $saveStateEvent = new BackendEntityEditEvent($model);
            $this->trigger(self::EVENT_BACKEND_PRODUCT_EDIT_SAVE, $saveStateEvent);

            if ($model->validate()) {
                if (isset($post['GeneratePropertyValue'])) {
                    $generateValues = $post['GeneratePropertyValue'];
                } else {
                    $generateValues = [];
                }
                if (isset($post['PropertyGroup'])) {
                    $model->option_generate = Json::encode(
                        [
                            'group' => $post['PropertyGroup']['id'],
                            'values' => $generateValues
                        ]
                    );
                } else {
                    $model->option_generate = '';
                }

                $save_result = $model->save();
                $model->saveProperties($post);
                $model->saveRelatedProducts();

                if (null !== $view_object = ViewObject::getByModel($model, true)) {
                    if ($view_object->load($post, 'ViewObject')) {
                        if ($view_object->view_id <= 0) {
                            $view_object->delete();
                        } else {
                            $view_object->save();
                        }
                    }
                }

                if ($save_result) {
                    $modelAfterSaveEvent = new BackendEntityEditEvent($model);
                    $this->trigger(self::EVENT_BACKEND_PRODUCT_AFTER_SAVE, $modelAfterSaveEvent);

                    $categories = isset($post[$model->formName()]['categories']) ? $post[$model->formName()]['categories'] : [];

                    $model->saveCategoriesBindings($categories);

                    $this->runAction('save-info', ['model_id'=>$model->id]);
                    $model->invalidateTags();


                    $action = Yii::$app->request->post('action', 'save');
                    if (Yii::$app->request->post(HasProperties::FIELD_ADD_PROPERTY_GROUP)
                        || Yii::$app->request->post(HasProperties::FIELD_REMOVE_PROPERTY_GROUP)) {
                        $action = 'save';
                    }
                    $returnUrl = Yii::$app->request->get('returnUrl', ['index']);
                    switch ($action) {
                        case 'next':
                            return $this->redirect(
                                [
                                    'edit',
                                    'returnUrl' => $returnUrl,
                                    'parent_id' => Yii::$app->request->get('parent_id', null)
                                ]
                            );
                        case 'back':
                            return $this->redirect($returnUrl);
                        default:
                            return $this->redirect(
                                Url::toRoute([
                                    'edit',
                                    'id' => $model->id,
                                    'returnUrl' => $returnUrl,
                                    'parent_id' => $model->main_category_id
                                ])
                            );
                    }
                } else {
                    Yii::$app->session->setFlash('error', Yii::t('app', 'Cannot save data'));
                }
            } else {
                Yii::$app->session->setFlash('error', Yii::t('app', 'Cannot save data'));
            }
        }

        $items = ArrayHelper::map(
            Category::find()->all(),
            'id',
            'name'
        );


        return $this->render(
            'product-form',
            [
                'object' => $object,
                'model' => $model,
                'items' => $items,
                'selected' => $model->getCategoryIds(),
                'parent' => $parent,
            ]
        );
    }

    /**
     * @param $id
     * @throws NotFoundHttpException
     * @throws \yii\db\Exception
     */
    public function actionGenerate($id)
    {
        $product = Yii::$container->get(Product::class);
        $post = \Yii::$app->request->post();
        if (!isset($post['GeneratePropertyValue'])) {
            throw new NotFoundHttpException();
        }
        $parent = $product::findById($id, null);
        if ($parent === null) {
            throw new NotFoundHttpException();
        }

        $object = BaseObject::getForClass(get_class($product));
        $catIds = (new Query())->select('category_id')->from([$object->categories_table_name])->where(
            'object_model_id = :id',
            [':id' => $id]
        )->orderBy(['sort_order' => SORT_ASC, 'id' => SORT_ASC])->column();


        if (isset($post['GeneratePropertyValue'])) {
            $generateValues = $post['GeneratePropertyValue'];
            if(empty($parent->propertyGroups[$post['PropertyGroup']['id']])){
                $post[HasProperties::FIELD_ADD_PROPERTY_GROUP]['Product'] = $post['PropertyGroup']['id'];
            }
        } else {
            $generateValues = [];
        }
        $parent->option_generate = Json::encode(
            [
                'group' => $post['PropertyGroup']['id'],
                'values' => $generateValues
            ]
        );
        $parent->save();

        $postProperty = [];
        foreach ($post['GeneratePropertyValue'] as $key_property => $values) {
            $inner = [];
            foreach ($values as $key_value => $trash) {
                $inner[] = [$key_property => $key_value];
            }
            $postProperty[] = $inner;
        }

        $optionProperty = self::generateOptions($postProperty);

        foreach ($optionProperty as $option) {
            $product = Yii::$container->get(Product::class);
            /** @var Product|HasProperties $model */
            $model = $product;
            $model->load($post);

The method load does only exist in app\modules\shop\models\Product, but not in app\properties\HasProperties.

            $model->parent_id = $parent->id;
            $nameAppend = [];
            $slugAppend = [];
            $tempPost = [];

            // @todo something
            foreach ($option as $optionValue) {
                $valueModels = [];
                foreach ($optionValue as $propertyKey => $propertyValue) {
                    if (false === in_array($propertyKey, $valueModels)) {
                        /** @var  $propertyStaticValues  PropertyStaticValues */
                        $propertyStaticValues = PropertyStaticValues::findOne($propertyValue);
                        $key = $propertyStaticValues->property->key;
                        $tempPost[$key] = $propertyValue;
                        $valueModels[] = $propertyKey;
                        $nameAppend[] = $propertyStaticValues->name;
                        $slugAppend[] = $propertyStaticValues->id;
                    }
                }
            }
            $model->measure_id = $parent->measure_id;
            $model->name = $parent->name . ' (' . implode(', ', $nameAppend) . ')';
            $model->slug = $parent->slug . '-' . implode('-', $slugAppend);
            $save_model = $model->save();

The method save does only exist in app\modules\shop\models\Product, but not in app\properties\HasProperties.

            if ($save_model) {
                $groups = [
                    [$parent->object->id, $model->id, $post['PropertyGroup']['id']]
                ];
                foreach (array_keys($parent->propertyGroups) as $key) {
                    if ($key === $post['PropertyGroup']['id']) {
                        continue;
                    }
                    $groups[] = [$parent->object->id, $model->id, $key];
                }
                Yii::$app->db->createCommand()->batchInsert(
                    ObjectPropertyGroup::tableName(),
                    ['object_id', 'object_model_id', 'property_group_id'],
                    $groups
                )->execute();
                $newValues = array_merge($parent->abstractModel->attributes, $tempPost);
                $model->saveProperties([

The method saveProperties does only exist in app\properties\HasProperties, but not in app\modules\shop\models\Product.

                    'Properties_Product_' . $model->id => $newValues,
                ]);
                $add = [];
                foreach ($catIds as $value) {
                    $add[] = [
                        $value,
                        $model->id
                    ];
                }
                if (!empty($add)) {
                    Yii::$app->db->createCommand()->batchInsert(
                        $object->categories_table_name,
                        ['category_id', 'object_model_id'],
                        $add
                    )->execute();
                }

                $params = $parent->images;
                if (!empty($params)) {
                    $rows = [];
                    foreach ($params as $param) {
                        $rows[] = [
                            $param['object_id'],
                            $model->id,
                            $param['filename'],
                            $param['image_title'],
                            $param['image_alt'],
                            $param['sort_order'],
                        ];
                    }

                    Yii::$app->db->createCommand()->batchInsert(
                        Image::tableName(),
                        [
                            'object_id',
                            'object_model_id',
                            'filename',
                            'image_title',
                            'image_alt',
                            'sort_order',
                        ],
                        $rows
                    )->execute();

                }
            }
        }
    }

    /**
     * Clone product action.
     * @param integer $id
     * @throws \yii\web\NotFoundHttpException
     */
    public function actionClone($id, $returnUrl = ['index'])
    {
        $product = Yii::$container->get(Product::class);
        /** @var Product|HasProperties $model */
        $model = $product::findOne($id);
        if ($model === null) {
            throw new NotFoundHttpException;
        }

        /** @var Product|HasProperties $newModel */
        $newModel = $product;
        $newModel->setAttributes($model->attributes, false);

The method setAttributes does only exist in app\modules\shop\models\Product, but not in app\properties\HasProperties.

        $time = time();
        $newModel->name .= ' (copy ' . date('Y-m-d h:i:s', $time) . ')';
        $newModel->slug .= '-copy-' . date('Ymdhis', $time);
        $newModel->id = null;
        if ($newModel->validate() === false) {

The method validate does only exist in app\modules\shop\models\Product, but not in app\properties\HasProperties.

            $newModel->slug = substr(uniqid() . "-" . $model->slug, 0, 80);
        }
        if ($newModel->save()) {

The method save does only exist in app\modules\shop\models\Product, but not in app\properties\HasProperties.

            $object = BaseObject::getForClass(get_class($newModel));
            // save categories
            $categoriesTableName = BaseObject::getForClass(get_class($product))->categories_table_name;
            $query = new Query();
            $params = $query->select(['category_id', 'sort_order'])->from($categoriesTableName)->where(
                ['object_model_id' => $model->id]
            )->all();
            if (!empty($params)) {
                $rows = [];
                foreach ($params as $param) {
                    $rows[] = [
                        $param['category_id'],
                        $newModel->id,
                        $param['sort_order'],
                    ];
                }
                Yii::$app->db->createCommand()->batchInsert(
                    $categoriesTableName,
                    [
                        'category_id',
                        'object_model_id',
                        'sort_order'
                    ],
                    $rows
                )->execute();
            }

            // save images bindings
            $params = $query->select(
                ['object_id', 'filename', 'image_title', 'image_alt', 'sort_order']
            )->from(Image::tableName())->where(
                [
                    'object_id' => $object->id,
                    'object_model_id' => $model->id
                ]
            )->all();
            if (!empty($params)) {
                $rows = [];
                foreach ($params as $param) {
                    $rows[] = [
                        $param['object_id'],
                        $newModel->id,
                        $param['filename'],
                        $param['image_title'],
                        $param['image_alt'],
                        $param['sort_order'],
                    ];
                }
                Yii::$app->db->createCommand()->batchInsert(
                    Image::tableName(),
                    [
                        'object_id',
                        'object_model_id',
                        'filename',
                        'image_title',
                        'image_alt',
                        'sort_order',
                    ],
                    $rows
                )->execute();
            }
            $newModelProps = [];
            foreach (array_keys($model->propertyGroups) as $key) {
                $opg = new ObjectPropertyGroup();
                $opg->attributes = [
                    'object_id' => $object->id,
                    'object_model_id' => $newModel->id,
                    'property_group_id' => $key,
                ];
                $opg->save();
                $props = Property::getForGroupId($key);
                foreach ($props as $prop) {
                    $propValues = $model->getPropertyValuesByPropertyId($prop->id);

The method getPropertyValuesByPropertyId does only exist in app\properties\HasProperties, but not in app\modules\shop\models\Product.

                    if ($propValues !== null) {
                        foreach ($propValues->values as $val) {
                            $valueToSave = ArrayHelper::getValue($val, 'psv_id', $val['value']);
                            $newModelProps[$prop->key][] = $valueToSave;
                        }
                    }
                }
            }
            $newModel->saveProperties(

The method saveProperties does only exist in app\properties\HasProperties, but not in app\modules\shop\models\Product.

                [
                    'Properties_Product_' . $newModel->id => $newModelProps,
                ]
            );

            // addons cloning
            foreach ($model->bindedAddons as $index => $addon) {
                $newModel->link(

The method link does only exist in app\modules\shop\models\Product, but not in app\properties\HasProperties.

                    'bindedAddons',
                    $addon,
                    [
                        'sort_order'=>$index,
                        'appliance_object_id' => $object->id,
                    ]
                );
            }

            Yii::$app->session->setFlash('success', Yii::t('app', 'Product has been cloned successfully.'));
            $this->redirect(['edit', 'id' => $newModel->id, 'returnUrl' => $returnUrl]);
        }
    }

    /**
     * @param $id
     * @return \yii\web\Response
     * @throws NotFoundHttpException
     * @throws \Exception
     */
    public function actionDelete($id)
    {
        $product = Yii::$container->get(Product::class);
        /** @var Product $model */
        if (null === $model = $product::findOne($id)) {
            throw new NotFoundHttpException;
        }

        if (Yii::$app->request->get('returnUrl') !== null) {
            $redirect = Yii::$app->request->get('returnUrl');
        } elseif ($model->parent_id == 0) {
            $redirect = Url::toRoute(['index']);
        } else {
            $redirect = Url::toRoute(['edit', 'id' => $model->parent_id]);
        }

        if (!$model->delete()) {
            Yii::$app->session->setFlash('info', Yii::t('app', 'The object is placed in the cart'));
        } else {
            Yii::$app->session->setFlash('info', Yii::t('app', 'Object has been removed'));
        }

        return $this->redirect($redirect);
    }

    /**
     * @param $parent_id
     * @return \yii\web\Response
     * @throws \Exception
     */
    public function actionRemoveAll($parent_id)
    {
        $items = Yii::$app->request->post('items', []);
        if (!empty($items)) {
            $product = Yii::$container->get(Product::class);
            $items = $product::find()->where(['in', 'id', $items])->all();
            foreach ($items as $item) {
                $item->delete();
            }
        }

        return $this->redirect(['index', 'parent_id' => $parent_id]);
    }

    /**
     * @param $tableName
     * @param $ids
     * @param string $field
     * @return bool
     * @throws \yii\db\Exception
     */
    public static function sortModels($tableName, $ids, $field = 'sort_order')
    {
        $priorities = [];
        $start = 0;
        $ids_sorted = $ids;
        sort($ids_sorted);
        foreach ($ids as $id) {
            $priorities[$id] = $ids_sorted[$start++];
        }
        $sql = "UPDATE " . $tableName . " SET $field = " . self::generateCase($priorities) . " WHERE id IN(" . implode(
                ', ',
                $ids
            ) . ")";

        return Yii::$app->db->createCommand(
            $sql
        )->execute() > 0;

    }

    /**
     * Рекурсивный генератор свойств для создания комплектаций.
     * @param array $array Трехмерный массив вида:
     * [[['{property1}' => '{value1}']], [['{property1}' => '{value2}']], [['{property2}' => '{value1}']], [['{property2}' => '{value1}']]]
     * @param array $result Используется для передачи результатов внутри рекурсии
     * @param integer $count Счетчик внутри рекурсии
     * @return array
     */
    public static function generateOptions($array, $result = [], $count = 0)
    {
        if (empty($result)) {
            foreach ($array[$count] as $value) {
                $result[] = [$value];
            }
            $count++;
            $arResult = self::generateOptions($array, $result, $count);
        } else {
            if (isset($array[$count])) {
                $nextResult = [];
                foreach ($array[$count] as $value) {
                    foreach ($result as $resValue) {
                        $nextResult[] = array_merge($resValue, [$value]);
                    }
                }
                $count++;
                $arResult = self::generateOptions($array, $nextResult, $count);
            } else {
                return $result;
            }
        }
        return $arResult;
    }

    /**
     * @param $priorities
     * @return string
     */
    private static function generateCase($priorities)
    {
        $result = 'CASE `id`';
        foreach ($priorities as $k => $v) {
            $result .= ' when "' . $k . '" then "' . $v . '"';
        }
        return $result . ' END';
    }

    /**
     * @return array

Consider making the return type a bit more specific; maybe use array<string,false|array>.

     */
    public function actionAjaxRelatedProduct()
    {
        Yii::$app->response->format = \yii\web\Response::FORMAT_JSON;

        $result = [
            'more' => false,
            'results' => []
        ];
        $search = Yii::$app->request->get('search');
        if (!empty($search['term'])) {
            $query = new \yii\db\Query();
            $product = Yii::$container->get(Product::class);
            $query->select('id, name AS text')->from($product::tableName())->andWhere(
                ['like', 'name', $search['term']]
            )->andWhere(['active' => 1])->orderBy(['sort_order' => SORT_ASC, 'name' => SORT_ASC]);
            $command = $query->createCommand();
            $data = $command->queryAll();

            $result['results'] = array_values($data);
        }

        return $result;
    }
}