Anastasia / clinica

  <?php
      /**
       * Created by PhpStorm.
       * User: stes
       * Date: 29.05.18
       * Time: 9:51
       */
      
      namespace frontend\controllers;
      
      use common\models\Service;

      use yii\db\ActiveQuery;

      use yii\db\Query;

      use yii\web\Controller;
      use yii\web\NotFoundHttpException;

      use frontend\microdata\MicrodataFabric;

  
      class ServiceController extends Controller
      {

          public function actionView($id){
              $model = $this->findModel($id);
              if ($model->parent_id == null){

                 $others = Service::find()->where(['parent_id' => $model->id])->with(['services.language.alias', 'language.alias'])->all();

                 if (empty($others)){

                     $others = Service::find()->where(['parent_id' => null, 'status' => true])->with(['services.language.alias', 'language.alias'])->all();

                 }

              }elseif ($model->level == 1){

                  $others = Service::find()->where(['parent_id' => $model->parent_id])->with(['services.language.alias', 'language.alias'])->all();

              }else{

                  $others = Service::find()->where(['parent_id' => (new Query())->select('parent_id')->from('service')->where(['id' => $model->parent_id])])->with(['services.language.alias', 'language.alias'])->all();

              }

              # список цен для микроданных

              $prices=[];
              foreach ($model->prices as $kry=>$price)
              {
                  foreach ($price as $key2=>$val2){
                      if($key2=='price')$prices[]=$price[$key2];
                  }
  
              }
  
              $layoutMicrodata=(count($model->prices)>1)?
                  [
                      '@context'=> 'http://schema.org/',
                      '@type'=> 'Product',
                      'name'=> "'{$model->language->attributes['title']}'",
                      'offers' =>
                          [
                              '@type'=> 'AggregateOffer',
                              'lowPrice'=> "'".min($prices)."'",
                              'highPrice'=> "'".max($prices)."'",
                              'priceCurrency'=> 'UAH'
                          ]
                  ]
                  :[
                      'type'=>'Product',
                      'name'=> "'{$model->language->attributes['title']}'",

                      'offers'=> [
                          '@type'=> 'Offer',
                          'priceCurrency'=> 'UAH',
                          'Price'=> "'".max($prices)."'",

                      ]
                  ];
  
  
              $microdata=new MicrodataFabric();
              $pageMicrodata=$microdata::createJsonFromProduct($layoutMicrodata)->toJson();
  
  
  

              $model->body = str_replace('[[prices]]', $this->renderPartial('_prices', ['prices' => $model->prices]), $model->body);

              return $this->render('view', [
                  'model' => $model,

                  'others'=> $others,
                  'microdata'=>$pageMicrodata

              ]);
          }
          
          public function findModel($id){
              $model = Service::find()
                              ->where(['id' => $id, 'status' => true])

                              ->with(['language.alias',  'prices' => function (ActiveQuery $query){

                                  $query->where(['status' => true])->with('language')->orderBy('sort');

                              }, 'comments' => function (ActiveQuery $query){
                                  $query->where(['status' => true]);

                              }, 'questions' => function (ActiveQuery $query){

                                  $query->where(['status' => true])->with('doctor');

                              },'packages' => function (ActiveQuery $query){

                                  $query->with(['image', 'language.alias'])->where(['status' => true]);

                              }])->one();

              if (empty($model)){
                  throw new NotFoundHttpException('Model not found');
              }
              return $model;
          }
      }