public function __invoke($forum_id) { $session = $this->getSession(); $forum = ForumModel::getForum($forum_id); if (!$forum) { $session->addFlash('error', '论坛版块不存在'); return new RedirectResponse($this->generateUrl('forum_homepage')); } /** @var ForumModel[] $sub_tree */ $sub_tree = $forum->getSubTree(); $list = array(); foreach ($sub_tree as $i => $node) { if ($i == 0) { continue; } $list[$node->forumId] = $node; } ForumBusiness::preOrderTree2RecursiveTree($list, $forum); $breadcrumbs = $forum->getNodeSinglePath(); unset($breadcrumbs[0], $breadcrumbs[1]); $breadcrumbs = array_values($breadcrumbs); $request = $this->getRequest(); $page = $request->query->get('page'); if (!$page) { $page = 1; } $size = 20; $threads_pager = ThreadModel::listForumThreads($page, $size, function (QueryBuilder $qb) use($forum_id) { $qb->andWhere($qb->expr()->eq('forum_id', ':forum_id'))->setParameter(':forum_id', $forum_id); }); return $this->render('forum/board.html.twig', array('forum' => $forum, 'threads_pager' => $threads_pager, 'breadcrumbs' => $breadcrumbs)); }
public function __invoke() { // 检查登录 $session = $this->getSession(); if (empty($session['user'])) { $session->addFlash('error', '请先登录'); return new RedirectResponse($this->generateUrl('user_login')); } $user = UserModel::getUser($session['user']['id']); $request = $this->getRequest(); $type = $request->query->get('type'); if (!$type) { $type = 'post'; } $page = $request->query->get('page'); if (!$page) { $page = 1; } $size = 10; $pager = null; if ($type == 'post') { $pager = ThreadModel::listForumThreads($page, $size, function (QueryBuilder $qb) use($user) { /** @var UserModel $user */ $qb->andWhere($qb->expr()->eq('author_id', ':author_id'))->setParameter(':author_id', $user->id); }); $data = $pager->getData(); foreach ($data as $key => $value) { $forum_id = $value['forum_id']; $forum = ForumModel::getForum($forum_id); $value['forum'] = $forum; $data[$key] = $value; } $pager->setData($data); } elseif ($type == 'reply') { $data = PostModel::getPostsWhere(function (QueryBuilder $qb) use($user) { /** @var UserModel $user */ $qb->andWhere($qb->expr()->eq('author_id', ':author_id'))->setParameter(':author_id', $user->id); }); $thread_ids = array(); foreach ($data as $key => $value) { $thread_ids[] = $value['thread_id']; } $thread_ids = array_unique($thread_ids); $pager = ThreadModel::listForumThreads($page, $size, function (QueryBuilder $qb) use($thread_ids) { /** @var UserModel $user */ $qb->andWhere($qb->expr()->in('thread_id', $thread_ids)); }); $data = $pager->getData(); foreach ($data as $key => $value) { $forum_id = $value['forum_id']; $forum = ForumModel::getForum($forum_id); $value['forum'] = $forum; $data[$key] = $value; } $pager->setData($data); } $pager->setQuery(array('type' => $type)); return $this->render('thread/my.html.twig', array('pager' => $pager)); }
protected function handle() { /** @var ForumModel $root_node */ $root_node = ForumModel::getRootNode(); if (!$root_node) { // 没有根分类,需要自动创建 $node = new ForumModel(); $node->name = '论坛首页'; $node->description = '论坛首页'; $node->forumStatus = 1; $node->forumType = 'group'; $now = time(); $node->createTimestamp = $now; $node->updateTimestamp = $now; $node->preOrderTreeLeft = 0; $node->preOrderTreeRight = 1; $root_node = ForumModel::createForumGroup($node); } /** @var ForumModel[] $root_tree */ $root_tree = $root_node->getSubTree(); $request = $this->getRequest(); $page = $request->query->get('page'); if (!$page) { $page = 1; } $size = 15; $forum_id = $request->query->get('forum_id'); if (!$forum_id) { $forum_id = $root_node->forumId; } $forum = ForumModel::getForum($forum_id); /** @var ForumModel[] $sub_tree */ $sub_tree = $forum->getSubTree(); $forum_ids = array(); foreach ($sub_tree as $item) { $forum_ids[] = $item->forumId; } $threads_pager = ThreadModel::listForumThreads($page, $size, function (QueryBuilder $qb) use($forum_ids) { $qb->andWhere($qb->expr()->in('forum_id', $forum_ids)); $qb->addOrderBy('create_timestamp', 'DESC'); }); $threads_pager->setQuery(array('forum_id' => $forum_id)); $data = $threads_pager->getData(); foreach ($data as $key => $item) { $id = $item['forum_id']; $forum = ForumModel::getForum($id); $data[$key]['forum'] = $forum->toArray(); } $threads_pager->setData($data); return $this->render('thread/thread-list.html.twig', array('tree' => $root_tree, 'threads_pager' => $threads_pager, 'forum_id' => $forum_id)); }