public function actionIndex()
{
$search = Yii::$app->request->post('search');
$url = \Yii::$app->request->get('cat');
$popularArticle = Articles::find()->orderBy('view DESC')->limit(5)->all();
$discussedArticle = Articles::find()->joinWith('comments', true, 'RIGHT JOIN')->groupBy('comments.article_id')->orderBy('count(comments.article_id) DESC')->limit(5)->all();
if ($search) {
$model = Articles::find()->where(['like', 'title', $search])->all();
} else {
$model = Category::find()->with('articles')->where(['url' => $url])->all();
$model = $model[0]['articles'];
}
$modelCategory = Category::find()->all();
$array = array();
foreach ($model as $mod) {
$array[] .= $mod['id'];
}
$modelImgArticle = Articles::findAll($array);
$arrUser = array();
$modelUser = array();
foreach ($model as $user) {
$arrUser[] = User::find()->where(['id' => $user['author_id']])->all();
}
foreach ($arrUser as $userName) {
$modelUser[] = $userName[0]['name_fml'];
}
return $this->render('index', ['model' => $model, 'modelCategory' => $modelCategory, 'imgArticles' => $modelImgArticle, 'user' => $modelUser, 'popularArticle' => $popularArticle, 'discussedArticle' => $discussedArticle]);
}
public function actionAll()
{
$this->view->values = Articles::findAll();
$this->view->display('all');
}
