/**
* Displays homepage.
*
* @return mixed
*/
public function actionIndex($slug = 'index')
{
// display home page
if (empty($slug) || $slug == 'index') {
$query = Post::find()->where(['status' => Post::STATUS_PUBLISHED]);
$countQuery = clone $query;
$pagination = new Pagination(['totalCount' => $countQuery->count(), 'defaultPageSize' => 5]);
$posts = $query->offset($pagination->offset)->limit($pagination->limit)->all();
return $this->render('index', ['posts' => $posts, 'pagination' => $pagination]);
}
//try to display action from controller
try {
return $this->runAction($slug);
} catch (\yii\base\InvalidRouteException $ex) {
}
//try to display static page from datebase
$page = Page::getDb()->cache(function ($db) use($slug) {
return Page::findOne(['slug' => $slug, 'status' => Page::STATUS_PUBLISHED]);
}, 3600);
if ($page) {
$pageAction = new PageAction($slug, $this, ['slug' => $slug, 'page' => $page]);
return $pageAction->run();
}
//try to display post from datebase
$post = Post::getDb()->cache(function ($db) use($slug) {
return Post::findOne(['slug' => $slug, 'status' => Post::STATUS_PUBLISHED]);
}, 3600);
if ($post) {
$postAction = new PostAction($slug, $this, ['slug' => $slug, 'post' => $post]);
return $postAction->run();
}
//if nothing suitable was found then throw 404 error
throw new \yii\web\NotFoundHttpException('Page not found.');
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Post::find()->joinWith('translations');
$dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => Yii::$app->request->cookies->getValue('_grid_page_size', 20)], 'sort' => ['defaultOrder' => ['id' => SORT_DESC]]]);
$this->load($params);
if (!$this->validate()) {
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id, 'created_by' => $this->created_by, 'updated_by' => $this->updated_by, 'status' => $this->status, 'comment_status' => $this->comment_status, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at, 'revision' => $this->revision]);
$query->andFilterWhere([$this->published_at_operand ? $this->published_at_operand : '=', 'published_at', $this->published_at ? strtotime($this->published_at) : null]);
$query->andFilterWhere(['like', 'slug', $this->slug])->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'content', $this->content]);
return $dataProvider;
}
public function run()
{
if (!$this->options) {
$this->options = $this->getDefaultOptions();
}
if (User::hasPermission('viewPosts')) {
$searchModel = new PostSearch();
$formName = $searchModel->formName();
$recentPosts = Post::find()->orderBy(['id' => SORT_DESC])->limit($this->recentLimit)->all();
foreach ($this->options as &$option) {
$count = Post::find()->filterWhere($option['filterWhere'])->count();
$option['count'] = $count;
$option['url'] = [$this->indexAction, $formName => $option['filterWhere']];
}
return $this->render('posts', ['height' => $this->height, 'width' => $this->width, 'position' => $this->position, 'posts' => $this->options, 'recentPosts' => $recentPosts]);
}
}
/**
* Displays homepage.
*
* @return mixed
*/
public function actionIndex($slug = 'index')
{
if (empty($slug) || $slug == 'index') {
throw new NotFoundHttpException('Page not found.');
} else {
$tag = Tag::find()->where(['slug' => $slug]);
$tagCount = clone $tag;
if (!$tagCount->count()) {
throw new NotFoundHttpException('Page not found.');
}
}
$query = Post::find()->joinWith('tags')->where(['status' => Post::STATUS_PUBLISHED, Tag::tableName() . '.slug' => $slug])->orderBy('published_at DESC');
$countQuery = clone $query;
$pagination = new Pagination(['totalCount' => $countQuery->count(), 'defaultPageSize' => Yii::$app->settings->get('reading.page_size', 10)]);
$posts = $query->offset($pagination->offset)->limit($pagination->limit)->all();
return $this->render('index', ['posts' => $posts, 'tag' => $tag->one(), 'pagination' => $pagination]);
}
