public function actionIndex($id, $page = 1) { $page = $page < 1 ? 1 : $page; $this->assign("subcategory", ForumSubcategory::findByPk($id)); $this->assign('threads', ForumThread::findAllForSubcategory($id, $page)); $this->assign('currentPage', $page); $this->assign('categories', ForumCategory::findAllBySection($this->sectionId, true)); }
/** * @return $this */ public function checkLastActivity() { $thread = ForumThread::findByAttributes(['subcategory_id' => $this->id, 'deleted' => 0], ['order' => 'IF(last_reply_date > create_time & last_reply_date > edit_time, last_reply_date, (IF(edit_time > create_time & edit_time > last_reply_date, edit_time, create_time))) DESC']); if (!$thread) { $this->last_active_thread_id = 0; $this->last_active_user_id = 0; $this->last_activity_time = null; return $this; } $this->last_active_thread_id = $thread->id; if ($thread->last_reply_date >= max($thread->create_time, $thread->edit_time)) { $this->last_activity = 'reply'; $this->last_active_user_id = $thread->last_reply_user_id; } elseif ($thread->edit_time >= max($thread->create_time, $thread->last_reply_date)) { $this->last_activity = 'edit'; $this->last_active_user_id = $thread->edit_user_id; } else { $this->last_activity = 'create'; $this->last_active_user_id = $thread->user_id; } $this->last_activity_time = max($thread->create_time, $thread->edit_time, $thread->last_reply_date); return $this; }
public function actionRecent() { $this->assign("threads", ForumThread::findRecent($this->sectionId)); }
public function actionIndex($id, $currentPage = 1) { $this->assign('user', ForumUser2Section::findByAttributes(['user_id' => $id, 'section_id' => $this->sectionId])); $this->assign("threads", ForumThread::findAllByUser($id, $this->sectionId, $currentPage)); }
/** * It will save thread info(update with last reply info) + subcategory info * @param int $sectionId * @param int $level * @param int $userId * @param int $userGroupID * @param int $time * @return bool */ public function saveReply($sectionId, $level = 1, $userId = null, $userGroupID = null, $time = null) { $this->user_id = is_null($userId) ? WebApp::get()->user()->id : $userId; $this->time = date('Y-m-d H:i:s', $time ?: time()); $this->section_id = $sectionId; $this->score = $this->edited = $this->edit_user_id = $this->deleted = $this->deleted_user_id = 0; $this->user_group_id = $userGroupID ?: UserAccess::get()->getUserGroup($sectionId, true); if (!$this->save()) { return false; } $thread = ForumThread::findByPk($this->thread_id); $thread->replies = ($firstLevelReplies = ForumReply::countByAttributes(['thread_id' => $this->thread_id])) + ForumReplySecond::countByAttributes(['thread_id' => $this->thread_id]) + ForumReplyThird::countByAttributes(['thread_id' => $this->thread_id]) + ForumReplyForth::countByAttributes(['thread_id' => $this->thread_id]) + ForumReplyFifth::countByAttributes(['thread_id' => $this->thread_id]) + ForumReplySixth::countByAttributes(['thread_id' => $this->thread_id]) + ForumReplySeventh::countByAttributes(['thread_id' => $this->thread_id]) + ForumReplyEighth::countByAttributes(['thread_id' => $this->thread_id]) + ForumReplyNth::countByAttributes(['thread_id' => $this->thread_id]); $thread->first_level_replies = $firstLevelReplies; $thread->last_reply_id = $this->id; $thread->last_reply_user_id = $this->user_id; $thread->last_reply_level = $level; $thread->last_reply_date = $this->time; $thread->save(false); $thread->subcategory->last_active_thread_id = $thread->id; $thread->subcategory->last_activity_time = $this->time; $thread->subcategory->last_activity = 'reply'; $thread->subcategory->last_active_user_id = $this->user_id; $thread->subcategory->recalculateNumbers()->save(); return true; }