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)); }