protected function findModel($id)
{
if (($model = DiscussionCategories::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = DiscussionCategories::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at]);
$query->andFilterWhere(['like', 'name', $this->name]);
return $dataProvider;
}
public static function getCategoriesWithPosts()
{
foreach (DiscussionCategories::find()->all() as $category) {
$q[] = '(SELECT *,discussion_categories.id as dcId FROM discussion_categories
LEFT OUTER JOIN discussion_posts on discussion_posts.discussion_category_id = discussion_categories.id
where discussion_categories.id = ' . $category['id'] . ' ORDER BY discussion_posts.id DESC LIMIT 3 )';
}
if (!empty($q)) {
//var_dump(DiscussionCategories::_group_by(Yii::$app->db->createCommand(implode(' UNION ALL ', $q))->queryAll(), 'name'));
/*Yii::$app->end();*/
return DiscussionCategories::_group_by(Yii::$app->db->createCommand(implode(' UNION ALL ', $q))->queryAll(), 'name');
}
return [];
}
