protected function handle() { $request = $this->getRequest(); $parent_node_id = $request->query->get('parent_form_id'); $parent_forum = ForumModel::getForum($parent_node_id); if (!$parent_forum) { throw new \Exception("论坛分组或者版块不存在"); } if ($request->getMethod() == 'POST') { try { // 检查参数 $forum_name = $request->request->get('name'); if (!$forum_name) { throw new \Exception('论坛分组名称不能为空'); } $forum_status = $request->request->get('forum_status'); $forum_status = intval($forum_status); $now = time(); $parent_forum->createChildNode(array('name' => $forum_name, 'forum_type' => 'forum', 'forum_status' => $forum_status, 'create_timestamp' => $now, 'update_timestamp' => $now)); } catch (\Exception $e) { $session = $this->getSession(); $session->addFlash('error', $e->getMessage()); } return new RedirectResponse($this->generateUrl('admin_forum_group_manage')); } return $this->render('forum/forum-add.html.twig'); }
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)); }
public function __invoke($forum_id) { // 检查登录 $session = $this->getSession(); if (empty($session['user'])) { $session->addFlash('error', '请先登录'); return new RedirectResponse($this->generateUrl('user_login')); } $user = UserModel::getUser($session['user']['id']); // 检查版块是否存在 $forum = ForumModel::getForum($forum_id); if (!$forum) { $session->addFlash('error', '论坛版块不存在'); return new RedirectResponse($this->generateUrl('forum_homepage')); } $request = $this->getRequest(); if ($request->getMethod() == 'POST') { // 处理发布数据 $posts = $request->request; $db = ForumDatabase::getInstance(); try { $db->transaction(); $subject = $posts->get('subject'); $content = $posts->get('content'); $pictures = $posts->get('thumbnails'); if (!$pictures) { $pictures = array(); } else { $pictures = explode('<>', $pictures); } if (empty($subject)) { throw new \Exception('帖子标题不能为空'); } $summary = strip_tags($content); // 创建主题 $thread = new ThreadModel(); $thread->subject = $subject; $thread->summary = $summary; $thread->thumbnails = implode('<>', $pictures); $thread->content = $content; $thread->forumId = $forum_id; $thread->authorId = $user->id; $thread->authorName = $user->username; $now = time(); $thread->createTimestamp = $now; $thread->lastPostTimestamp = $now; $thread->lastPosterName = $user->username; // 保存 $thread = ThreadModel::createThread($thread); $db->commit(); return new RedirectResponse($this->generateUrl('forum_thread_view', array('thread_id' => $thread->threadId))); } catch (\Exception $e) { $db->rollback(); $session->addFlash('error', $e->getMessage()); return new RedirectResponse($this->generateUrl('forum_thread_post', array('forum_id' => $forum_id))); } } return $this->render('thread/post.html.twig', array('forum' => $forum)); }
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); } $request = $this->getRequest(); if ($request->getMethod() == 'POST') { $forums_data = $request->request->get('forums'); if (!$forums_data) { $forums_data = array(); } $db = ForumModel::getDb(); try { $db->transaction(); foreach ($forums_data as $forum_id => $info) { $sort_number = $info['sort']; $forum_name = $info['name']; $forum = ForumModel::getForum($forum_id); if ($forum) { $forum->name = $forum_name; $forum->displayOrder = $sort_number; ForumModel::saveForum($forum); } } $db->commit(); } catch (\Exception $e) { $db->rollback(); throw $e; } } /** @var ForumModel[] $sub_tree */ $sub_tree = $root_node->getSubTree(); $list = array(); foreach ($sub_tree as $i => $node) { if ($i == 0) { continue; } $list[$node->forumId] = $node; } ForumBusiness::preOrderTree2RecursiveTree($list, $root_node); return $this->render('forum/group-manage.html.twig', array('root_node' => $root_node)); }
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)); }
public function __invoke() { // 论坛首页 /** @var ForumModel $root_node */ $root_node = ForumModel::getRootNode(); /** @var ForumModel[] $sub_tree */ $sub_tree = $root_node->getSubTree(); $list = array(); foreach ($sub_tree as $i => $node) { if ($i == 0) { continue; } $list[$node->forumId] = $node; } ForumBusiness::preOrderTree2RecursiveTree($list, $root_node); return $this->render('forum/homepage.html.twig', array('root_node' => $root_node)); }
public function __invoke($thread_id) { // 主题 $thread = ThreadModel::getThread($thread_id); if (!$thread) { $session = $this->getSession(); $session->addFlash('error', '帖子主题不存在'); return new RedirectResponse($this->getRequest()->server->get('HTTP_REFERER')); } $forum = ForumModel::getForum($thread->forumId); if (!$forum) { $session = $this->getSession(); $session->addFlash('error', '论坛版块不存在'); return new RedirectResponse($this->getRequest()->server->get('HTTP_REFERER')); } // 增加浏览数 $thread->views += 1; $thread = ThreadModel::saveThread($thread); $request = $this->getRequest(); $page = $request->query->get('page'); if (!$page) { $page = 1; } $size = 10; $posts_pager = PostModel::listForumPosts($page, $size, function (QueryBuilder $qb) use($thread) { /** @var ThreadModel $thread */ $qb->andWhere($qb->expr()->eq('forum_id', ':forum_id'))->setParameter(':forum_id', $thread->forumId); $qb->andWhere($qb->expr()->eq('thread_id', ':thread_id'))->setParameter(':thread_id', $thread->threadId); $qb->addOrderBy('create_timestamp'); }); $data = $posts_pager->getData(); foreach ($data as $key => $post) { if ($post['reply_post_id']) { $reply_post = PostModel::getPost($post['reply_post_id']); if ($reply_post) { $data[$key]['reply_post'] = $reply_post->toArray(); } } } $posts_pager->setData($data); return $this->render('thread/view.html.twig', array('forum' => $forum, 'thread' => $thread, 'posts_pager' => $posts_pager)); }
protected function handle() { $request = $this->getRequest(); $forum_id = $request->query->get('forum_id'); $forum = ForumModel::getForum($forum_id); if (!$forum) { throw new \Exception('论坛不存在'); } if ($request->getMethod() == 'POST') { $session = $this->getSession(); try { $forum->remove(); $session->addFlash('success', '操作成功'); } catch (\Exception $e) { $session->addFlash('error', $e->getMessage()); } return new RedirectResponse($this->generateUrl('admin_forum_group_manage')); } return $this->render('forum/forum-delete.html.twig', array('forum' => $forum)); }
protected function handle() { $request = $this->getRequest(); $forum_id = $request->query->get('forum_id'); $forum = ForumModel::getForum($forum_id); // 检查论坛是否存在 try { if (!$forum) { throw new \Exception('论坛不存在'); } } catch (\Exception $e) { $session = $this->getSession(); $session->addFlash('error', $e->getMessage()); return new RedirectResponse($this->generateUrl('admin_forum_gruop_manage')); } if ($request->getMethod() == 'POST') { // 修改数据 $session = $this->getSession(); try { $forum_name = $request->request->get('name'); $forum_description = $request->request->get('description'); $forum_icon = $request->request->get('icon'); if (!$forum_name) { throw new \Exception('版块名称不能为空'); } $forum->name = $forum_name; $forum->description = $forum_description; $forum->icon = $forum_icon; ForumModel::saveForum($forum); $session->addFlash('success', '操作成功'); } catch (\Exception $e) { $session->addFlash('error', $e->getMessage()); } return new RedirectResponse($this->generateUrl('admin_forum_forum_edit', array('forum_id' => $forum_id))); } return $this->render('forum/forum-edit.html.twig', array('forum' => $forum)); }
/** * 保存 * @param ForumModel $forum * @return ForumModel * @throws \Exception */ public static function saveForum(ForumModel $forum) { return self::editForum($forum->toArray()); }