frontend/controllers/SiteController.php

<?php
    namespace frontend\controllers;
    
    use artbox\core\models\Alias;
    use artbox\core\models\Feedback;
    use artbox\core\models\Language;
    use common\models\Comment;
    use common\models\Package;
    use common\models\Question;
    use common\models\Service;
    use common\models\Settings;
    use common\models\slider\Slide;
    use Yii;
    use yii\data\ActiveDataProvider;
    use yii\db\ActiveQuery;
    use yii\db\Expression;
    use yii\filters\VerbFilter;
    use yii\helpers\ArrayHelper;
    use yii\helpers\Json;
    use yii\swiftmailer\Mailer;
    use yii\web\BadRequestHttpException;
    use yii\web\Controller;
    use yii\web\Response;
    use yii\helpers\VarDumper as d;
    
    /**
     * Site controller
     */
    class SiteController extends Controller
    {
        /**
         * @inheritdoc
         */
        public function actions()
        {
            return [
                'error' => [
                    'class' => 'yii\web\ErrorAction',
                ],
            ];
        }
        
        /**
         * @inheritdoc
         */
        public function behaviors()
        {
            return [
                'verbs' => [
                    'class'   => VerbFilter::className(),
                    'actions' => [
                        'feedback' => [ 'post' ],
                    ],
                ],
            ];
        }
        
        /**
         * Displays homepage.
         *
         * @return mixed
         */
        public function actionIndex()
        {
            $slides = Slide::find()->with('language')->where(['status' => true])->orderBy('sort')->with('language.image')->all();
            $services = Service::find()->where(['is not' ,'image_id', NULL])->andWhere(
                [
                    'status' => true,
                    'level'  => 0,
                ]
            )
                                                                              ->with(
                                                                                  [
                                                                                      'image',
                                                                                      'language.alias',
                                                                                      'services' => function (ActiveQuery $query) {
                                                                                          $query->where(['status' => true])->with(['language.alias']);
                                                                                      },
                                                                                  ]
                                                                              )->orderBy([ new Expression('sort ASC NULLS LAST') ])
                                                                              ->all();
            $comments = Comment::find()->where(['status' => true, 'on_main' => true])->limit(6)->all();
            $package = Package::find()->with(['language.alias'])->where(['status' => true])->orderBy('sort')->limit(3)->all();
            $settings = Settings::getInstance();
            return $this->render('index', [
                'slides' => $slides,
                'services' => $services,
                'comments' => $comments,
                'settings' => $settings,
                'package'  => $package
            ]);
        }
        
        /**
         * Displays contact page.
         *
         * @return mixed
         */
        public function actionContact()
        {
            $contact = new Feedback();
            $settings = Settings::getInstance();
            return $this->render(
                'contact',
                [
                    'contact' => $contact,
                    'settings' => $settings
                ]
            );
        }
        
        /**
         * Displays about page.
         *
         * @return mixed
         */
        public function actionAbout()
        {
            return $this->render('about');
        }
        
        /**
         * Action to view robots.txt file dinamycli
         *
         * @return string
         */
        public function actionRobots()
        {
            $response = \Yii::$app->response;
            /**
             * @var Settings $settings
             */
            $settings = Settings::find()
                                ->one();
            $temp = tmpfile();
            fwrite($temp, $settings->robots);
            $meta = stream_get_meta_data($temp);
            $response->format = $response::FORMAT_RAW;
            $response->headers->set('Content-Type', 'text/plain');
            return $this->renderFile($meta[ 'uri' ]);
        }
        
        public function actionFeedback()
        {
            Yii::$app->response->format = Response::FORMAT_JSON;
            
            /**
             * @var Mailer $mailer
             */
            $mailer = \Yii::$app->get('smtpmailer');
            $settings = Settings::getInstance();
            
            if (empty(Yii::$app->request->post())) {
                throw new BadRequestHttpException();
            } else {
                $model = new Feedback();
                if ($model->load(Yii::$app->request->post()) && $model->save()) {
                    
                    $mailer->compose(
                        'feedback',
                        [
                            'model' => $model,
                        ]
                    )
                           ->setFrom('artbox@domain.com')
                           ->setTo($settings->email)
                           ->setSubject(\Yii::t('app', 'Feedback'))
                           ->send();
                    
                    return [
                        'success' => true,
                        'message' => 'Success message',
                        'alert'   => '<div class="alert alert-success">
            <h3>Success</h3>
            <p>
              Success text
            </p>
          </div>',
                    ];
                } else {
                    return [
                        'success' => false,
                        'error'   => $model->errors,
                    ];
                }
            }
        }
        public function actionPrices(){
            $services = Service::find()->innerJoinWith(['prices' => function (ActiveQuery $query){
                $query->where(['price.status' => true]);
            }])->all();
            
            return $this->render('prices', [
               'services' => $services,
            ]);
        }
        
        
        public function actionPage1(){
            return $this->render('page1');
        }
    
        public function actionPage2(){
            return $this->render('page2');
        }
        public function actionPage22(){
            return $this->render('page2-2');
        }
        public function actionPage23(){
            return $this->render('page2-3');
        }
    
        public function actionPage3(){
            return $this->render('page3');
        }
    
        public function actionPage4(){
            return $this->render('page4');
        }
    
        public function actionPage5(){
            return $this->render('page5');
        }
    
        public function actionPage6(){
            return $this->render('page6');
        }
        
        # Вопрос/ответ
        public function actionQuestions($service_id = null){
            Language::getCurrent();
            
            if (\Yii::$app->request->isAjax){
                Yii::$app->response->format = Response::FORMAT_JSON;
                $model = new Question();
                $model->scenario = Question::SCENARIO_QUESTION;
                if ($model->load(\Yii::$app->request->post()) and $model->save()){
                    return [
                      'status' => true,
                      'message' => 'Спасибо за Ваш вопрос'
                    ];
                }else{
                    return [
                        'status' => false,
                        'message' => 'Ошибка'
                    ];
                }
            }
            $dataProvider = new ActiveDataProvider([
                   'query' => Question::find()->where(['status' => true])->andFilterWhere(['service_id' => $service_id])->with(['doctor.language']),
                   'pagination' => [
                       'pageSize' => 10,
                   ],
                ]);
            $services = Service::find()->where(['status' => true])->andWhere(['parent_id' => null])->all();
            $route = [];
            foreach ($services as $service){
               $route[] = Json::encode(['site/questions', 'service_id' => $service->id]);
            }
            $route [] = '{"0":"site/questions"}';
            $alias = Alias::find()->where(['route' => $route])->andWhere(['language_id' => Language::getCurrent()->id])->indexBy('route')->asArray()->all();
            return $this->render('questions', [
               'dataProvider' => $dataProvider,
               'services'  => $services,
               'service_id' => $service_id,
                'alias' => $alias
            ]);
        }
    
        public function actionComments($service_id = null){
            if (\Yii::$app->request->isAjax){
                Yii::$app->response->format = Response::FORMAT_JSON;
                $model = new Comment();
                #if ($model->load(\Yii::$app->request->post()) and $model->save()){
                if ($model->load(\Yii::$app->request->post())){
                    if(!$model->entity_id)$model->entity_id=0;
                    $model->entity=Service::className();
                    $model->save();
                    return [
                        'status' => true,
                        'message' => 'Спасибо за Ваш отзыв. После проверки модератором он появиться на сайте'
                    ];
                }else{
                    return [
                        'status' => false,
                        'message' => 'Ошибка'
                    ];
                }
            }
            # подкоректировал логику для сохранрения в БД/выдачи вопросов с категории "Общие вопросы"
            # закрепил за ними entity_id=0
            if($service_id==null)$service_id=0;
            $dataProvider = new ActiveDataProvider([
                                                       'query' => Comment::find()
                                                           ->where(['status' => true])
                                                           ->andWhere(['entity' => Service::className()])
                                                           ->andFilterWhere(['entity_id' => $service_id]),//'SELECT * FROM \"comment\" WHERE (\"status\"=TRUE) AND (\"entity\"=\'common\\models\\Service\')'
                                                       'pagination' => [
                                                           'pageSize' => 10,
                                                       ],
                                                   ]);
            $services = Service::find()->where(['status' => true])->andWhere(['parent_id' => null])->all();
            return $this->render('comments', [
                'dataProvider' => $dataProvider,
                'services'  => $services,
                'service_id' => $service_id
            ]);
        }
    }