/** * 保存 * @param PostModel $post * @return PostModel * @throws \Exception */ public static function savePost(PostModel $post) { return self::editPost($post->toArray()); }
public function __invoke($board_id) { // 检查登录 $session = $this->getSession(); if (!isset($session['auth'])) { $current_url = $this->getCurrentUrl(); return new RedirectResponse($this->generateUrl('forum_login') . '?redirection=' . $current_url); } $board = BoardModel::getBoard($board_id); $request = $this->getRequest(); if ($request->getMethod() == 'POST') { $posts = $request->request; $db = ForumDatabase::getDb(); $db->transaction(); try { // 检查 $title = $posts->get('title'); if (!$title) { throw new \Exception('请输入帖子标题'); } $content = $posts->get('content'); // 创建 $thread = new ThreadModel(); $thread->title = $title; $thread->boardId = $board->id; $thread->groupId = $board->groupId; $thread->forumId = $board->forumId; $thread->authorId = $session['auth']['id']; $thread->authorName = $session['profile']['nickname']; $thread->replyAuthorId = $session['auth']['id']; $thread->replyAuthorName = $session['profile']['nickname']; $now = time(); $thread->replyTimestamp = $now; $thread->createTimestamp = $now; $thread->updateTimestamp = $now; // 保存 $thread = ThreadModel::createThread($thread); // 创建 $post = new PostModel(); $post->threadId = $thread->id; $post->boardId = $board->id; $post->groupId = $board->groupId; $post->forumId = $board->forumId; $post->authorId = $session['auth']['id']; $post->authorName = $session['profile']['nickname']; $post->postId = 0; $post->content = $content; $post->createTimestamp = $now; $post->updateTimestamp = $now; // 保存 $post = PostModel::createPost($post); $board->threadCount += 1; BoardModel::saveBoard($board); // 提交事务 $db->commit(); $session->addFlash('success', '发布成功'); return new JsonResponse(array('status' => 1, 'data' => $thread->id)); } catch (\Exception $e) { $db->rollback(); return new JsonResponse(array('status' => 0, 'data' => $e->getMessage())); } } else { $forum = $this->getForum(); // 获得论坛的分组信息 $groups = GroupModel::allGroup(function (QueryBuilder $qb) use($forum) { $qb->andWhere($qb->expr()->eq('forum_id', ':forum_id'))->setParameter(':forum_id', $forum->id); $qb->addOrderBy('weight', 'desc'); $qb->addOrderBy('create_timestamp'); }); // 优先search $group = GroupModel::getGroup($board->groupId); // 导航 $breadcrumbs = array(); $breadcrumbs[] = array('url' => $this->generateUrl('forum_group', array('slug' => $group->search ? $group->search : $group->id)), 'title' => $group->name); if ($board->path) { $board_ids = explode(',', $board->path); foreach ($board_ids as $board_id) { $b = BoardModel::getBoard($board_id); $breadcrumbs[] = array('url' => $this->generateUrl('forum_board', array('group_slug' => $group->search ? $group->search : $group->id, 'board_slug' => $b->search ? $b->search : $b->id)), 'title' => $b->name); } } // 自己 $breadcrumbs[] = array('url' => $this->generateUrl('forum_board', array('group_slug' => $group->search ? $group->search : $group->id, 'board_slug' => $board->search ? $board->search : $board->id)), 'title' => $board->name); // 发表帖子 $breadcrumbs[] = array('title' => '发表帖子'); return $this->render('thread/post.html.twig', array('forum' => $forum, 'groups' => $groups, 'group' => $group, 'board' => $board, 'breadcrumbs' => $breadcrumbs)); } }
public function __invoke($group_slug = null, $board_slug = null, $thread_id = null) { $forum = $this->getForum(); // 优先search $group = GroupModel::search($group_slug, $forum->id); if (!$group) { $group = GroupModel::getGroup($group_slug); } $board = BoardModel::search($board_slug, $forum->id, $group->id); if (!$board) { $board = BoardModel::getBoard($board_slug); } // 获得论坛的分组信息 $groups = GroupModel::allGroup(function (QueryBuilder $qb) use($forum) { $qb->andWhere($qb->expr()->eq('forum_id', ':forum_id'))->setParameter(':forum_id', $forum->id); $qb->addOrderBy('weight', 'desc'); $qb->addOrderBy('create_timestamp'); }); // 导航 $breadcrumbs = array(); $breadcrumbs[] = array('url' => $this->generateUrl('forum_group', array('slug' => $group->search ? $group->search : $group->id)), 'title' => $group->name); if ($board->path) { $board_ids = explode(',', $board->path); foreach ($board_ids as $board_id) { $b = BoardModel::getBoard($board_id); $breadcrumbs[] = array('url' => $this->generateUrl('forum_board', array('group_slug' => $group->search ? $group->search : $group->id, 'board_slug' => $b->search ? $b->search : $b->id)), 'title' => $b->name); } } // 自己 $breadcrumbs[] = array('url' => $this->generateUrl('forum_board', array('group_slug' => $group->search ? $group->search : $group->id, 'board_slug' => $board->search ? $board->search : $board->id)), 'title' => $board->name); // 帖子 $thread = ThreadModel::getThread($thread_id); // 增加浏览次数 $thread->viewCount += 1; // 保存 $thread = ThreadModel::saveThread($thread); $breadcrumbs[] = array('title' => $thread->title); $request = $this->getRequest(); // 回复 $p_page = $request->query->get('p_page'); $p_size = $request->query->get('p_size'); if (!$p_page) { $p_page = 1; } if (!$p_size) { $p_size = 7; } $post_pager = PostModel::listPosts($p_page, $p_size, function (QueryBuilder $qb) use($forum, $group, $board, $thread) { $qb->andWhere($qb->expr()->eq('forum_id', ':forum_id'))->setParameter(':forum_id', $forum->id); $qb->andWhere($qb->expr()->eq('group_id', ':group_id'))->setParameter(':group_id', $group->id); $qb->andWhere($qb->expr()->eq('board_id', ':board_id'))->setParameter(':board_id', $board->id); $qb->andWhere($qb->expr()->eq('thread_id', ':thread_id'))->setParameter(':thread_id', $thread->id); $qb->addOrderBy('create_timestamp'); }); $posts_data = $post_pager->getData(); foreach ($posts_data as $k => $post) { // 获得用户的数据 $user_id = $post['author_id']; $user = $this->getUserInfo($user_id); $post['author'] = $user; $posts_data[$k] = $post; } $post_pager->setData($posts_data); $post_pager->setPageParamName('p_page'); return $this->render('thread/index.html.twig', array('forum' => $forum, 'groups' => $groups, 'group' => $group, 'board' => $board, 'breadcrumbs' => $breadcrumbs, 'thread' => $thread, 'post_pager' => $post_pager)); }