public function indexAction() { $forumMapper = new ForumMapper(); $id = (int) $this->getRequest()->getParam('id'); $forum = $forumMapper->getForumById($id); $cat = $forumMapper->getCatByParentId($forum->getParentId()); $this->getLayout()->set('metaTitle', $this->getTranslator()->trans('forum') . ' - ' . $forum->getTitle()); $this->getLayout()->set('metaDescription', $this->getTranslator()->trans('forum') . ' - ' . $forum->getDesc()); $this->getLayout()->getHmenu()->add($this->getTranslator()->trans('forum'), array('controller' => 'index', 'action' => 'index'))->add($cat->getTitle(), array('controller' => 'showcat', 'action' => 'index', 'id' => $cat->getId()))->add($forum->getTitle(), array('controller' => 'showtopics', 'action' => 'index', 'forumid' => $id))->add($this->getTranslator()->trans('newTopicTitle'), array('controller' => 'newtopic', 'action' => 'index', 'id' => $id)); if ($this->getRequest()->getPost('saveNewTopic')) { $topicModel = new ForumTopicModel(); $topicMapper = new TopicMapper(); $dateTime = new \Ilch\Date(); $topicModel->setTopicTitle($this->getRequest()->getPost('topicTitle')); $topicModel->setText($this->getRequest()->getPost('text')); $topicModel->setTopicId($id); $topicModel->setForumId($id); $topicModel->setCat($id); $topicModel->setCreatorId($this->getUser()->getId()); $topicModel->setType($this->getRequest()->getPost('type')); $topicModel->setDateCreated($dateTime); $topicMapper->save($topicModel); $postMapper = new PostMapper(); $postModel = new ForumPostModel(); $lastid = $topicMapper->getLastInsertId(); $postModel->setTopicId($lastid); $postModel->setUserId($this->getUser()->getId()); $postModel->setText($this->getRequest()->getPost('text')); $postModel->setDateCreated($dateTime); $postMapper->save($postModel); $this->redirect(array('controller' => 'showposts', 'action' => 'index', 'topicid' => $lastid)); } $userMapper = new UserMapper(); $userId = null; if ($this->getUser()) { $userId = $this->getUser()->getId(); } $user = $userMapper->getUserById($userId); $ids = array(0); if ($user) { $ids = array(); foreach ($user->getGroups() as $us) { $ids[] = $us->getId(); } } $readAccess = explode(',', implode(',', $ids)); $this->getView()->set('readAccess', $readAccess); $this->getView()->set('forum', $forum); }
public function indexAction() { $postMapper = new PostMapper(); $topicMapper = new TopicMapper(); $forumMapper = new ForumMapper(); $topicModel = new ForumTopicModel(); $pagination = new \Ilch\Pagination(); $pagination->setPage($this->getRequest()->getParam('page')); $topicId = (int) $this->getRequest()->getParam('topicid'); $forumId = $forumMapper->getForumByTopicId($topicId); $forum = $forumMapper->getForumById($forumId->getId()); $cat = $forumMapper->getCatByParentId($forum->getParentId()); $posts = $postMapper->getPostByTopicId($topicId, $pagination); $post = $topicMapper->getPostById($topicId); $this->getLayout()->set('metaTitle', $this->getTranslator()->trans('forum') . ' - ' . $forum->getTitle()); $this->getLayout()->set('metaDescription', $this->getTranslator()->trans('forum') . ' - ' . $forum->getDesc()); $this->getLayout()->getHmenu()->add($this->getTranslator()->trans('forum'), array('controller' => 'index', 'action' => 'index'))->add($cat->getTitle(), array('controller' => 'showcat', 'action' => 'index', 'id' => $cat->getId()))->add($forum->getTitle(), array('controller' => 'showtopics', 'action' => 'index', 'forumid' => $forumId->getId()))->add($post->getTopicTitle(), array('controller' => 'showposts', 'action' => 'index', 'topicid' => $topicId)); $topicModel->setId($topicId); $topicModel->setVisits($post->getVisits() + 1); $topicMapper->saveVisits($topicModel); $userMapper = new UserMapper(); $userId = null; if ($this->getUser()) { $userId = $this->getUser()->getId(); $postMapper = new PostMapper(); $postModel = new ForumPostModel(); $lastPost = $topicMapper->getLastPostByTopicId($topicId); $lastRead = $lastPost->getRead(); if (in_array($this->getUser()->getId(), explode(',', $lastRead)) == false) { $postModel->setId($lastPost->getId()); $postModel->setRead($lastPost->getRead() . ',' . $this->getUser()->getId()); $postMapper->saveRead($postModel); } } $user = $userMapper->getUserById($userId); $ids = array(0); if ($user) { $ids = array(); foreach ($user->getGroups() as $us) { $ids[] = $us->getId(); } } $readAccess = explode(',', implode(',', $ids)); $this->getView()->set('post', $post); $this->getView()->set('posts', $posts); $this->getView()->set('forum', $forum); $this->getView()->set('readAccess', $readAccess); $this->getView()->set('pagination', $pagination); }
/** * Updates visits. * * @param FileModel $model */ public function saveVisits(TopicModel $model) { if ($model->getVisits()) { $this->db()->update('forum_topics')->values(array('visits' => $model->getVisits()))->where(array('id' => $model->getId()))->execute(); } }