common/modules/product/controllers/ManageController.php

<?php
    
    namespace common\modules\product\controllers;
    
    use common\models\ProductCertificate;
    use common\models\ProductSpec;
    use common\modules\language\models\Language;
    use common\modules\product\models\Export;
    use common\modules\product\models\Import;
    use common\modules\product\models\ProductImage;
    use common\modules\product\models\ProductVariant;
    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 yii\web\UploadedFile;
    
    /**
     * 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 actionDev()
        {
            foreach(ProductVariant::find()
                                  ->where([
                                      '>',
                                      'price_old',
                                      0,
                                  ])
                                  ->all() as $item) {
                if($item->price >= $item->price_old || $item->price == 0) {
                    print $item->price . ' | ' . $item->price_old . "<br>\n";
                }
            }
            print '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~';
        }
        
        /**
         * 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();
            $model_langs = $model->generateLangs();
            
            $product_spec = new ProductSpec();
            $product_spec_langs = $product_spec->generateLangs();
            
            if($model->load(Yii::$app->request->post())) {
                $model->loadLangs(\Yii::$app->request, $model_langs);
                $model->imagesUpload = UploadedFile::getInstances($model, 'imagesUpload');
                $model->certificateUpload = UploadedFile::getInstances($model, 'certificateUpload');
                
                if($model->save()) {
                    
                    if(!empty( $model->imagesUpload ) && ( ( $images = $model->imagesUpload() ) !== false )) {
                        foreach($images as $image) {
                            $imageModel = new ProductImage();
                            $imageModel->product_id = $model->product_id;
                            $imageModel->image = $image;
                            $imageModel->save();
                        }
                    }
                    
                    if(!empty( $model->certificateUpload ) && ( ( $certificates = $model->certificateUpload() ) !== false )) {
                        foreach($certificates as $certificate) {
                            $certificateModel = new ProductCertificate([
                                'product_id' => $model->product_id,
                                'link'       => $certificate,
                            ]);
                            $certificateModel->save(false);
                        }
                    }
                    
                    if($product_spec->load(Yii::$app->request->post())) {
                        $product_spec->loadLangs(\Yii::$app->request, $product_spec_langs);
                        $product_spec->product_id = $model->product_id;
                        $product_spec->techSpecFile = UploadedFile::getInstance($product_spec, 'techSpecFile');
                        $product_spec->techCharFile = UploadedFile::getInstance($product_spec, 'techCharFile');
                        if($product_spec->upload() && $model->linkLangs($model_langs) && $model->saveLangs($model_langs)) {
                            $product_spec->save(false);
                            if($product_spec->linkLangs($product_spec_langs) && $product_spec->saveLangs($product_spec_langs)) {
                                return $this->redirect([
                                    'view',
                                    'id' => $model->product_id,
                                ]);
                            } else {
                                return $this->redirect([
                                    'update',
                                    'id' => $model->product_id,
                                ]);
                            }
                        }
                    } elseif($model->linkLangs($model_langs) && $model->saveLangs($model_langs)) {
                        return $this->redirect([
                            'view',
                            'id' => $model->product_id,
                        ]);
                    } else {
                        return $this->redirect([
                            'update',
                            'id' => $model->product_id,
                        ]);
                    }
                }
            }
            return $this->render('create', [
                'model'              => $model,
                'model_langs'        => $model_langs,
                'product_spec'       => $product_spec,
                'product_spec_langs' => $product_spec_langs,
            ]);
        }
        
        /**
         * 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);
            $model_langs = $model->generateLangs();
            if(!empty( $model->productSpec )) {
                $product_spec = $model->productSpec;
            } else {
                $product_spec = new ProductSpec([
                    'product_id' => $model->product_id,
                ]);
            }
            $product_spec_langs = $product_spec->generateLangs();
            if($model->load(Yii::$app->request->post())) {
                $model->loadLangs(\Yii::$app->request, $model_langs);
                $model->imagesUpload = UploadedFile::getInstances($model, 'imagesUpload');
                $model->certificateUpload = UploadedFile::getInstances($model, 'certificateUpload');
                if($model->save()) {
                    if(!empty( $model->imagesUpload ) && ( ( $images = $model->imagesUpload() ) !== false )) {
                        foreach($images as $image) {
                            $imageModel = new ProductImage();
                            $imageModel->product_id = $model->product_id;
                            $imageModel->image = $image;
                            $imageModel->save();
                        }
                    }
                    
                    if(!empty( $model->certificateUpload ) && ( ( $certificates = $model->certificateUpload() ) !== false )) {
                        foreach($certificates as $certificate) {
                            $certificateModel = new ProductCertificate([
                                'product_id' => $model->product_id,
                                'link'       => $certificate,
                            ]);
                            $certificateModel->save(false);
                        }
                    }
                    
                    if($product_spec->load(Yii::$app->request->post())) {
                        $product_spec->loadLangs(\Yii::$app->request, $product_spec_langs);
                        $product_spec->techSpecFile = UploadedFile::getInstance($product_spec, 'techSpecFile');
                        $product_spec->techCharFile = UploadedFile::getInstance($product_spec, 'techCharFile');
                        if($product_spec->upload() && $model->linkLangs($model_langs) && $model->saveLangs($model_langs)) {
                            $product_spec->save(false);
                            if($product_spec->linkLangs($product_spec_langs) && $product_spec->saveLangs($product_spec_langs)) {
                                return $this->redirect([
                                    'view',
                                    'id' => $model->product_id,
                                ]);
                            }
                        }
                    } elseif($model->linkLangs($model_langs) && $model->saveLangs($model_langs)) {
                        return $this->redirect([
                            'view',
                            'id' => $model->product_id,
                        ]);
                    }
                }
            }
            $groups = $model->getTaxGroupsByLevel(0);
            return $this->render('update', [
                'model'              => $model,
                'model_langs'        => $model_langs,
                'groups'             => $groups,
                'product_spec'       => $product_spec,
                'product_spec_langs' => $product_spec_langs,
            ]);
        }
        
        /**
         * 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 actionDelimg($id)
        {
            $image = ProductImage::findOne($id);
            
            if($image) {
                $image->delete();
            }
            
            print '1';
            exit;
        }
        
        public function actionDelcert($id)
        {
            $certificate = ProductCertificate::findOne($id);
            
            if($certificate) {
                $certificate->delete();
            }
            
            print '1';
            exit;
        }
        
        public function actionIs_top($id)
        {
            $model = $this->findModel($id);
            
            $model->is_top = intval(empty( $model->is_top ));
            
            $model->save(false, [ 'is_top' ]);
            
            return $this->redirect([ 'index' ]);
        }
        
        public function actionIs_new($id)
        {
            $model = $this->findModel($id);
            
            $model->is_new = intval(empty( $model->is_new ));
            
            $model->save(false, [ 'is_new' ]);
            
            return $this->redirect([ 'index' ]);
        }
        
        public function actionAkciya($id)
        {
            $model = $this->findModel($id);
            
            $model->akciya = intval(empty( $model->akciya ));
            
            $model->save(false, [ 'akciya' ]);
            
            return $this->redirect([ 'index' ]);
        }
        
        public function actionImport()
        {
            $model = new Import();
            
            $languages = Language::find()
                                 ->select([
                                     'name',
                                     'language_id',
                                 ])
                                 ->where([ 'status' => 1 ])
                                 ->orderBy([ 'default' => SORT_DESC ])
                                 ->asArray()
                                 ->indexBy('language_id')
                                 ->column();
            
            if($model->load(Yii::$app->request->post())) {
                \Yii::$app->session->set('export_lang', $model->lang);
                $file = UploadedFile::getInstances($model, 'file');
                $method = 'go' . ucfirst($model->type);
                $target = Yii::getAlias('@uploadDir') . '/' . Yii::getAlias('@uploadFile' . ucfirst($model->type));
                if(empty( $file )) {
                    $model->errors[] = 'File not upload';
                } elseif($method == 'goPrices' && $file[ 0 ]->name != 'file_1.csv') {
                    $model->errors[] = 'File need "file_1.csv"';
                } elseif($method == 'goProducts' && $file[ 0 ]->name == 'file_1.csv') {
                    $model->errors[] = 'File can not "file_1.csv"';
                } elseif($model->validate() && $file[ 0 ]->saveAs($target)) {
                    // PROCESS PAGE
                    return $this->render('import-process', [
                        'model'  => $model,
                        'method' => $model->type,
                        'target' => $target,
                    ]);
                    //                $model->$method();
                } else {
                    $model->errors[] = 'File can not be upload or other error';
                }
            }
            
            return $this->render('import', [
                'model'     => $model,
                'languages' => $languages,
            ]);
        }
        
        public function actionProducts()
        {
            $from = Yii::$app->request->get('from', 0);
            
            $model = new Import();
            
            if(Yii::$app->request->isAjax) {
                Yii::$app->response->format = \yii\web\Response::FORMAT_JSON;
                return $model->goProducts($from, 2);
            }
        }
        
        public function actionPrices()
        {
            $from = Yii::$app->request->get('from', 0);
            
            $model = new Import();
            
            if(Yii::$app->request->isAjax) {
                Yii::$app->response->format = \yii\web\Response::FORMAT_JSON;
                return $model->goPrices($from, 10);
            }
        }
        
        public function actionExportProcess($from, $filename)
        {
            
            $model = new Export();
            if(Yii::$app->request->isAjax) {
                Yii::$app->response->format = \yii\web\Response::FORMAT_JSON;
                return $model->process($filename, $from);
            }
        }
        
        public function actionExport()
        {
            $model = new Export();
            
            if($model->load(Yii::$app->request->post())) {
                \Yii::$app->session->set('export_lang', $model->lang);
                return $this->render('export-process', [
                    'model'  => $model,
                    'method' => 'export',
                ]);
            }
            
            return $this->render('export', [
                'model' => $model,
            ]);
            //            $model = new Export();
            //            if(( $file = $model->process(Yii::getAlias('@uploadDir')) )) {
            //                return Yii::$app->response->sendFile($file)
            //                                          ->send();
            //            }
            //            throw new NotFoundHttpException('Error');
        }
        
        /**
         * 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.');
            }
        }
    }