/**
*
* @return string
*/
public function actionIndex()
{
// page size
$pageSize = 2;
// main query
$query = CmsNews::find()->innerJoinWith(['cmsNewsI18ns' => function ($query) {
$query->where(['i18n_id' => Yii::$app->language]);
}])->where(['cms_news_group_id' => 2, 'activated' => 1]);
// count query
$countQuery = clone $query;
$pages = new Pagination(['totalCount' => $countQuery->count(), 'pageSize' => $pageSize, 'defaultPageSize' => $pageSize]);
$models = $query->offset($pages->offset)->limit($pages->limit)->orderBy(['published_at' => SORT_DESC])->all();
return $this->render($this->renderView, ['models' => $models, 'pages' => $pages]);
}
