common/modules/product/controllers/ManageController.php

<?php
namespace common\modules\product\controllers;
use common\modules\product\helpers\ProductHelper;
use common\modules\product\models\Category;
use common\modules\product\models\ProductVariant;
use common\modules\product\models\RemoteProductsSearch;
use Yii;
use common\modules\product\models\Product;
use common\modules\product\models\ProductSearch;
use yii\web\Controller;
use yii\web\NotFoundHttpException;
use yii\filters\VerbFilter;
use common\modules\product\models\Brand;
use common\modules\product\models\BrandName;
use common\modules\product\models\RemoteProducts;
/**
 * ManageController implements the CRUD actions for Product model.
 */
class ManageController extends Controller
{
    /**
     * @inheritdoc
     */
    public function behaviors()
    {
        return [
            'verbs' => [
                'class' => VerbFilter::className(),
                'actions' => [
                    'delete' => ['POST'],
                ],
            ],
        ];
    }
    public function actionTest() {
        return;
        foreach(Product::find()->all() as $product) {
            if (!$product->variant) {
                $product->save();
                $variantModel = new ProductVariant();
                $variantModel->product_id = $product->product_id;
                $variantModel->name = 'test-'. uniqid();
                $variantModel->sku = $variantModel->name;
                $variantModel->price = rand(5, 200000);
                $variantModel->price_old = rand(0, 5) > 3 ? $variantModel->price* (1+rand(0, 10) / 10) : $variantModel->price;
                $variantModel->product_unit_id = rand(1, 5);
                $variantModel->stock = rand(0, 50);
                $variantModel->save();
            }
        }
        return;
        $categories = Category::find()->where(['depth' => 2])->all();
        $cats_ids = [];
        foreach($categories as $cat) {
            $cats_ids[] = $cat->category_id;
        }
        $brands = ProductHelper::getBrands()->all();
        $brands_ids = [];
        foreach($brands as $brand) {
            $brands_ids[] = $brand->brand_id;
        }
        for($i=1;$i<=1000;$i++) {
            $uniqid = uniqid();
            $model = new Product();
            $model->name = 'Test '. $uniqid;
            $model->brand_id = $brands_ids[array_rand($brands_ids, 1)];
            $model->categories = [$cats_ids[array_rand($cats_ids, 1)]];
            $model->save();
            $variantModel = new ProductVariant();
            $variantModel->product_id = $model->product_id;
            $variantModel->name = 'test-'. $uniqid;
            $variantModel->sku = $variantModel->name;
            $variantModel->price = rand(5, 200000);
            $variantModel->price_old = rand(0, 5) > 3 ? $variantModel->price* (1+rand(0, 10) / 10) : $variantModel->price;
            $variantModel->product_unit_id = rand(1, 5);
            $variantModel->save();
        }
    }
    /**
     * Lists all Product models.
     * @return mixed
     */
    public function actionIndex()
    {
        $searchModel = new ProductSearch();
        $dataProvider = $searchModel->search(Yii::$app->request->queryParams);
        return $this->render('index', [
            'searchModel' => $searchModel,
            'dataProvider' => $dataProvider,
        ]);
    }
    /**
     * Displays a single Product model.
     * @param integer $id
     * @return mixed
     */
    public function actionView($id)
    {
        return $this->render('view', [
            'model' => $this->findModel($id),
        ]);
    }
    /**
     * Creates a new Product model.
     * If creation is successful, the browser will be redirected to the 'view' page.
     * @return mixed
     */
    public function actionCreate()
    {
        $model = new Product();
        if ($model->load(Yii::$app->request->post()) && $model->save()) {
            return $this->redirect(['view', 'id' => $model->product_id]);
        } else {
            return $this->render('create', [
                'model' => $model,
            ]);
        }
    }
    /**
     * Updates an existing Product model.
     * If update is successful, the browser will be redirected to the 'view' page.
     * @param integer $id
     * @return mixed
     */
    public function actionUpdate($id)
    {
        $model = $this->findModel($id);
        if ($model->load(Yii::$app->request->post()) && $model->save()) {
            return $this->redirect(['view', 'id' => $model->product_id]);
        } else {
            $groups = $model->category->getTaxGroups();
            return $this->render('update', [
                'model' => $model,
                'groups' => $groups,
            ]);
        }
    }
    /**
     * Deletes an existing Product model.
     * If deletion is successful, the browser will be redirected to the 'index' page.
     * @param integer $id
     * @return mixed
     */
    public function actionDelete($id)
    {
        $this->findModel($id)->delete();
        return $this->redirect(['index']);
    }
    public function actionImport() {
        $searchModel = new RemoteProductsSearch();
        $dataProvider = $searchModel->search(Yii::$app->request->queryParams);
        return $this->render('remote-products', [
            'searchModel' => $searchModel,
            'dataProvider' => $dataProvider,
        ]);
    }
    public function actionImportStat() {
            $all_products = $new_products = $linked_products = $orpahed_products = 0;
            $remoteProducts = RemoteProducts::find()->all();
            $not_linked_cats = [];
            foreach($remoteProducts as $product) {
                if (!empty($product->product->product_id)) {
                    $linked_products++;
                } elseif (!empty($product->remoteCategory) && !empty($product->remoteCategory->category) && !empty($product->remoteCategory->category->category_id)) {
                    $new_products++;
                } else {
                    if (!empty($product->remoteCategory)) {
                        if (empty($not_linked_cats[$product->remoteCategory->ID])) {
                            $not_linked_cats[$product->remoteCategory->ID] = $product->remoteCategory->Name ." (". $product->remoteCategory->ID .")";
                        }
                    }
                    $orpahed_products++;
                }
                $all_products++;
            }
        $op = [];
            $op[] = "Всего $all_products товаров, $new_products новых и $linked_products уже связанных.";
            if (!empty($not_linked_cats)) {
                $op[] = "$orpahed_products товаров не привязаны к категориям:";
                foreach ($not_linked_cats as $not_linked_cat) {
                    $op[] = "$not_linked_cat";
                }
            }
        return $this->render('import-stat', [
            'all_products' => $all_products,
            'new_products' => $new_products,
            'linked_products' => $linked_products,
            'orpahed_products' => $orpahed_products,
            'not_linked_cats' => $not_linked_cats,
        ]);
    }
    /**
     * Finds the Product model based on its primary key value.
     * If the model is not found, a 404 HTTP exception will be thrown.
     * @param integer $id
     * @return Product the loaded model
     * @throws NotFoundHttpException if the model cannot be found
     */
    protected function findModel($id)
    {
        if (($model = Product::findOne($id)) !== null) {
            return $model;
        } else {
            throw new NotFoundHttpException('The requested page does not exist.');
        }
    }
}