/** * Find page * @throws HttpException */ public function beforeAction() { // request $request = Yii::$app->request; if ($slugParam = $request->get($this->slugParam, false)) { // controller $controller = Yii::$app->controller; // view $view = $controller->view; // cache key $cacheKey = 'cms_page_slug:' . $slugParam . ':' . Yii::$app->language; // get from cache if (($dataPage = Yii::$app->commonCache->get($cacheKey)) === false) { $cmsPage = CmsPage::find()->innerJoinWith(['cmsPageI18ns' => function ($query) use($slugParam) { $query->where(['slug' => $slugParam, 'i18n_id' => Yii::$app->language]); }, 'cmsLayout'])->where(['activated' => 1])->asArray()->one(); if ($cmsPage !== null && isset($cmsPage['cmsPageI18ns'][0])) { $cmsPageContents = CmsPageContent::find()->innerJoinWith(['cmsPageContentI18ns' => function ($query) { $query->where(['i18n_id' => Yii::$app->language]); }])->where(['cms_page_id' => $cmsPage['id']])->orderBy(['index' => SORT_ASC])->asArray()->all(); Yii::$app->commonCache->set($cacheKey, ['cmsPage' => $cmsPage, 'cmsPageContents' => $cmsPageContents], $cmsPage['cache_duration'], new TagDependency(['tags' => [CmsPageComponent::getCacheTag(), CmsPageComponent::getCacheTag($cmsPage['id']), CmsPageComponent::getCacheTag($cmsPage['id'], $cmsPage['cmsPageI18ns'][0]['slug'], Yii::$app->language)]])); } } else { $cmsPage = $dataPage['cmsPage']; $cmsPageContents = $dataPage['cmsPageContents']; } if (!empty($cmsPage) && !empty($cmsPageContents)) { $view->title = $cmsPage['cmsPageI18ns'][0]['html_title']; if ($cmsPage['cmsPageI18ns'][0]['html_description'] != '') { $view->registerMetaTag(['name' => 'description', 'content' => $cmsPage['cmsPageI18ns'][0]['html_description']]); } if ($cmsPage['cmsPageI18ns'][0]['html_keywords'] != '') { $view->registerMetaTag(['name' => 'keywords', 'content' => $cmsPage['cmsPageI18ns'][0]['html_keywords']]); } $controller->layout = $cmsPage['cmsLayout']['path']; $this->renderView = $cmsPage['cmsLayout']['view']; $this->parseCmsPageContents($cmsPageContents); foreach ($cmsPageContents as &$cmsPageContent) { if (isset($cmsPageContent['cmsPageContentI18ns'][0])) { $view->blocks['cms_block_page_' . $cmsPageContent['index']] = $cmsPageContent['cmsPageContentI18ns'][0]['content']; } } } else { throw new HttpException(404); } } else { throw new HttpException(404); } }
/** * Load page content models * @param integer $layout Layout ID * @param integer|null $page Page ID * @return array * @throws Exception */ protected function loadPageContentsModels($layout, $page = null) { $cmsPageContents = []; $cmsLayout = CmsLayout::find()->select('max_container')->where(['id' => $layout])->one(); if ($cmsLayout !== null) { for ($i = 1; $i <= $cmsLayout->max_container; ++$i) { $cmsPageContents[$i]['main'] = new CmsPageContent(['scenario' => 'insert']); $cmsPageContents[$i]['main']->index = $i; $cmsPageContents[$i]['i18n'] = new CmsPageContentI18n(['scenario' => 'beforeInsert']); $cmsPageContents[$i]['i18n']->i18n_id = Yii::$app->language; } if ($page !== null) { $results = CmsPageContent::find()->joinWith(['cmsPageContentI18ns' => function ($query) { $query->onCondition(['cms_page_content_i18n.i18n_id' => Yii::$app->language]); }])->where(['cms_page_id' => $page])->all(); foreach ($results as $result) { $scenario = 'update'; if (!isset($cmsPageContents[$result->index]['main'])) { $scenario = 'delete'; } $cmsPageContents[$result->index]['main'] = $result; $cmsPageContents[$result->index]['main']->scenario = $scenario; if (isset($result->cmsPageContentI18ns[0])) { $cmsPageContents[$result->index]['i18n'] = $result->cmsPageContentI18ns[0]; $cmsPageContents[$result->index]['i18n']->scenario = $scenario; } } } } else { throw new Exception('No layout'); } return $cmsPageContents; }
/** * @return \yii\db\ActiveQuery */ public function getCmsPageContents() { return $this->hasMany(CmsPageContent::className(), ['cms_page_id' => 'id']); }
/** * @return \yii\db\ActiveQuery */ public function getCmsPageContent() { return $this->hasOne(CmsPageContent::className(), ['id' => 'cms_page_content_id']); }