frontend/controllers/ServiceController.php

<?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')->all();
               if (empty($others)){
                   $others = Service::find()->where(['parent_id' => null, 'status' => true])->all();
               }
            }elseif ($model->level == 1){
                $others = Service::find()->where(['parent_id' => $model->parent_id])->with('services.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')->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']}'",
                    'image'=> [
                        'https://example.com/photos/1x1/photo.jpg',
                        'https://example.com/photos/4x3/photo.jpg',
                        'https://example.com/photos/16x9/photo.jpg'
                    ],
                    'offers'=> [
                        '@type'=> 'Offer',
                        'priceCurrency'=> 'UAH',
                        'Price'=> "'".max($prices)."'",
                        'priceValidUntil'=> '2020-11-05',
                        'itemCondition'=> 'http://schema.org/UsedCondition',
                        'availability'=> 'http://schema.org/InStock',
                        'seller'=> [
                            'type'=> 'Organization',
                            'name'=>'Executive Objects']
                    ]
                ];
            $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])->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'])->where(['status' => true]);
                            }])->one();
            if (empty($model)){
                throw new NotFoundHttpException('Model not found');
            }
            return $model;
        }
    }