/**
* 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']);
}
