/**
* Lists all KskPosts models.
* @return mixed
*/
public function actionIndex()
{
if (isset($_GET['category_id'])) {
$query = KskPosts::getPostsByCategoryAndStatus($_GET['category_id'], 'publish');
$category_name = Yii::$app->db->createCommand('SELECT name FROM ksk_categories WHERE id=:category_id', [':category_id' => $_GET['category_id']])->queryScalar();
} else {
$query = KskPosts::getPostsByStatus('publish');
$category_name = '';
}
$dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 10], 'sort' => ['defaultOrder' => ['created_date' => SORT_DESC, 'title' => SORT_ASC]]]);
return $this->render('index', ['dataProvider' => $dataProvider, 'category_name' => $category_name]);
}
