Exemplo n.º 1
0
 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);
 }
Exemplo n.º 2
0
 public function getPostByTopicId($id, $pagination = NULL)
 {
     $sql = 'SELECT SQL_CALC_FOUND_ROWS *
                        FROM `[prefix]_forum_topics`
                        WHERE topic_id = ' . $id . '
                        LIMIT ' . implode(',', $pagination->getLimit());
     $fileArray = $this->db()->queryArray($sql);
     $pagination->setRows($this->db()->querycell('SELECT FOUND_ROWS()'));
     $entry = array();
     foreach ($fileArray as $entries) {
         $entryModel = new TopicModel();
         $entryModel->setId($entries['id']);
         $entryModel->setText($entries['text']);
         $entryModel->setTopicId($id);
         $entryModel->setTopicTitle($entries['topic_title']);
         $entry[] = $entryModel;
     }
     return $entry;
 }