public function __invoke($slug = null)
{
$group_id_or_search = $slug;
$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::search($group_id_or_search, $forum->id);
if (!$group) {
$group = GroupModel::getGroup($group_id_or_search);
}
// 分组下的一级版块
$boards = BoardModel::allBoards(function (QueryBuilder $qb) use($group) {
$qb->andWhere($qb->expr()->eq('forum_id', ':forum_id'))->setParameter(':forum_id', $group->forumId);
$qb->andWhere($qb->expr()->eq('group_id', ':group_id'))->setParameter(':group_id', $group->id);
$qb->andWhere($qb->expr()->eq('parent_id', 0));
$qb->addOrderBy('weight', 'desc');
$qb->addOrderBy('create_timestamp');
});
return $this->render('group/index.html.twig', array('forum' => $forum, 'groups' => $groups, 'group' => $group, 'boards' => $boards));
}
public function __invoke($group_slug = null, $board_slug = null)
{
$forum = $this->getForum();
$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);
}
$request = $this->getRequest();
$t_page = $request->query->get('t_page');
$t_size = $request->query->get('t_size');
if (!$t_page) {
$t_page = 1;
}
if (!$t_size) {
$t_size = 5;
}
$threads_pager = ThreadModel::listThreads($t_page, $t_size, function (QueryBuilder $qb) use($board, $group, $forum) {
$qb->andWhere($qb->expr()->eq('board_id', ':board_id'))->setParameter(':board_id', $board->id);
$qb->andWhere($qb->expr()->eq('group_id', ':group_id'))->setParameter(':group_id', $group->id);
$qb->andWhere($qb->expr()->eq('forum_id', ':forum_id'))->setParameter(':forum_id', $forum->id);
$qb->addOrderBy('create_timestamp', 'desc');
});
$threads_pager->setPageParamName('t_page');
$threads_pager->setBaseUrl($this->generateUrl('forum_board_threads', array('group_slug' => $group->search ? $group->search : $group->id, 'board_slug' => $board->search ? $board->search : $board->id)));
return $this->render('board/threads.html.twig', array('pager' => $threads_pager, 'group' => $group, 'board' => $board));
}
protected function handle()
{
$forum_id = $this->forumId;
$forum = ForumModel::getForum($forum_id);
$request = $this->getRequest();
$session = $this->getSession();
if (!$forum) {
if ($request->isXmlHttpRequest()) {
throw new \Exception('论坛不存在');
} else {
$session->addFlash('error', '论坛不存在');
return new RedirectResponse($this->generateUrl('admin_forum_index'));
}
}
if ($request->getMethod() == 'POST') {
$posts = $request->request;
$db = ForumDatabase::getDb();
$db->transaction();
try {
$name = $posts->get('name');
if (!$name) {
throw new \Exception('分组名称不能为空');
}
$description = $posts->get('description');
$search = $posts->get('search');
if ($search) {
// 检查重复性
$g = GroupModel::search($search, $forum_id);
if ($g) {
throw new \Exception('URL占位符已被使用');
}
} else {
$search = null;
}
$group = new GroupModel();
$group->name = $name;
$group->search = $search;
$group->description = $description;
$group->forumId = $forum_id;
$now = time();
$group->createTimestamp = $now;
$group->updateTimestamp = $now;
// 更改论坛数据
$forum->groupCount += 1;
// 保存
GroupModel::createGroup($group);
ForumModel::saveForum($forum);
$db->commit();
$session->addFlash('success', '操作成功');
} catch (\Exception $e) {
$db->rollback();
$session->addFlash('error', $e->getMessage());
}
return new RedirectResponse($this->generateUrl('admin_forum_group_index', array('forum_id' => $forum_id)));
}
return $this->render('group/add.html.twig', array('forum' => $forum));
}
protected function handle()
{
$group_id = $this->id;
$request = $this->getRequest();
$session = $this->getSession();
// 检验参数
$group = GroupModel::getGroup($group_id);
if (!$group) {
if ($request->isXmlHttpRequest()) {
throw new \Exception('论坛分组不存在');
} else {
$session->addFlash('error', '论坛分组不存在');
return new RedirectResponse($this->generateUrl('admin_forum_group_index', array('forum_id' => $group->forumId)));
}
}
if ($request->getMethod() == 'POST') {
$posts = $request->request;
try {
$name = $posts->get('name');
if (!$name) {
throw new \Exception('分组名称不能为空');
}
$description = $posts->get('description');
$board_per_row = $posts->get('board_per_row');
if (!$board_per_row) {
throw new \Exception('每行显示的版块数不能为空');
}
$search = $posts->get('search');
if ($search) {
// 检查重复性
$g = GroupModel::search($search, $group->forumId);
if ($g && $g->id != $group->id) {
throw new \Exception('URL占位符已被使用');
}
} else {
$search = null;
}
$group->name = $name;
$group->search = $search;
$group->description = $description;
$group->boardPerRow = intval($board_per_row);
$group->updateTimestamp = time();
// 保存
GroupModel::saveGroup($group);
$session->addFlash('success', '操作成功');
} catch (\Exception $e) {
$session->addFlash('error', $e->getMessage());
}
return new RedirectResponse($this->generateUrl('admin_forum_group_index', array('forum_id' => $group->forumId)));
}
return $this->render('group/edit.html.twig', array('group' => $group));
}
public function __invoke($group_slug = null, $board_slug = null)
{
$group_id_or_search = $group_slug;
$board_id_or_search = $board_slug;
$forum = $this->getForum();
// 优先search
$group = GroupModel::search($group_id_or_search, $forum->id);
if (!$group) {
$group = GroupModel::getGroup($group_id_or_search);
}
$board = BoardModel::search($board_id_or_search, $forum->id, $group->id);
if (!$board) {
$board = BoardModel::getBoard($board_id_or_search);
}
// 获得论坛的分组信息
$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');
});
// 子版块
$sub_boards = BoardModel::allBoards(function (QueryBuilder $qb) use($board) {
$qb->andWhere($qb->expr()->eq('parent_id', ':parent_id'))->setParameter(':parent_id', $board->id);
$qb->addOrderBy('weight', 'desc');
$qb->addOrderBy('create_timestamp');
});
// 导航
$breadcrumbs = array();
$breadcrumbs[] = array('url' => $this->generateUrl('forum_group', array('slug' => $group_id_or_search)), '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_id_or_search, 'board_slug' => $b->search ? $b->search : $b->id)), 'title' => $b->name);
}
}
// 自己
$breadcrumbs[] = array('url' => $this->generateUrl('forum_board', array('group_slug' => $group_id_or_search, 'board_slug' => $board->search ? $board->search : $board->id)), 'title' => $board->name);
return $this->render('board/index.html.twig', array('forum' => $forum, 'groups' => $groups, 'group' => $group, 'board' => $board, 'sub_boards' => $sub_boards, 'breadcrumbs' => $breadcrumbs));
}
public function __invoke($group_slug = null, $board_slug = null, $thread_id = null)
{
// 检查登录
$session = $this->getSession();
if (!isset($session['auth'])) {
$current_url = $this->getCurrentUrl();
return new RedirectResponse($this->generateUrl('forum_login') . '?redirection=' . $current_url);
}
$thread = ThreadModel::getThread($thread_id);
$post = PostModel::getPostByThreadId($thread_id);
$request = $this->getRequest();
if ($request->getMethod() == 'POST') {
$posts = $request->request;
$session = $this->getSession();
$db = ForumDatabase::getDb();
$db->transaction();
try {
$comment = $posts->get('comment');
if (!$comment) {
throw new \Exception('回复内容不能为空');
}
// 创建
$reply = new PostModel();
$reply->content = $comment;
$now = time();
$reply->createTimestamp = $now;
$reply->updateTimestamp = $now;
$reply->forumId = $thread->forumId;
$reply->groupId = $thread->groupId;
$reply->boardId = $thread->boardId;
$reply->threadId = $thread->id;
$reply->postId = $post->id;
$reply->authorId = $session['auth']['id'];
$reply->authorName = $session['profile']['nickname'];
// 保存
PostModel::createPost($reply);
// 更新
$post->commentCount += 1;
PostModel::savePost($post);
// 主题
$thread->replyAuthorId = $session['auth']['id'];
$thread->replyAuthorName = $session['profile']['nickname'];
$thread->replyCount += 1;
$thread->replyTimestamp = $now;
ThreadModel::saveThread($thread);
$db->commit();
$session->addFlash('success', '回复成功');
return new JsonResponse(array('status' => 1, 'data' => '回复成功'));
} catch (\Exception $e) {
$db->rollback();
return new JsonResponse(array('status' => 0, 'data' => $e->getMessage()));
}
} else {
$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);
}
$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' => '回复RE: ' . $thread->title);
// 获得论坛的分组信息
$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');
});
$post = PostModel::getPostByThreadId($thread->id);
return $this->render('thread/reply.html.twig', array('forum' => $forum, 'groups' => $groups, 'group' => $group, 'board' => $board, 'thread' => $thread, 'post' => $post, '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));
}
