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'); }