/** * @return string */ public function actionList() { $name = Yii::$app->getRequest()->get('name'); $tagModel = ''; if (isset($name)) { /** @var Tag $tagModel */ $tagModel = Tag::findOne(['name' => $name]); if (!$tagModel) { throw new NotFoundHttpException(); } } $query = Topic::find()->select('*')->from('topic t')->with('tags', 'firstPostUser', 'lastPostUser'); if (isset($name)) { $query->innerJoin('tag_topic_assignment tta', 'tta.topic_id = t.id')->where(['tta.tag_name' => $name]); } $sort_by = Yii::$app->getRequest()->get('sort_by'); if (!$sort_by || $sort_by == 'new') { $query->orderBy(['t.last_post_created_at' => SORT_DESC]); } elseif ($sort_by == 'unanwser') { $query->andWhere(['t.number_posts' => 0])->orderBy(['t.last_post_created_at' => SORT_DESC]); } elseif ($sort_by == 'own') { $id = Yii::$app->getUser()->getId(); $query->andWhere(['t.first_post_user_id' => $id])->orderBy(['t.last_post_created_at' => SORT_DESC]); } $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['forcePageParam' => false, 'pageSizeLimit' => false, 'defaultPageSize' => Yii::$app->config->get('display_topics_count')]]); $topics = $dataProvider->getModels(); return $this->render('list', ['dataProvider' => $dataProvider, 'tagModel' => $tagModel, 'topics' => $topics]); }
/** * @return boolean */ public function create() { // very, so much, stupid source code :) if ($this->validate()) { $user = Yii::$app->getUser()->getIdentity(); // create post $post = new Post(); $post->topic_id = 0; $post->message = $this->message; $post->save(); if ($post->save()) { // create topic $topic = new Topic(); $topic->subject = $this->subject; $topic->post = $post; $topic->save(); // update post.topic_id $post->link('topic', $topic); $tagNames = explode(',', $this->tags); foreach ($tagNames as $tagName) { /** @var Tag $tagModel */ $tagModel = Tag::findOne($tagName); $topic->link('tags', $tagModel); } $this->topic = $topic; return true; } } return false; }
/** * @inheritdoc */ public function run() { $name = Yii::$app->getRequest()->get('name'); if ($name !== '') { $tagModel = Tag::findOne(['name' => $name]); echo $this->render('sidebar', ['tagModel' => $tagModel]); } else { echo $this->render('sidebar'); } }