protected function handle() { $request = $this->getRequest(); if ($request->getMethod() == 'POST') { $ids = $request->request->get('ids'); $session = $this->getSession(); $db = ArticleModel::getDb(); try { $db->transaction(); foreach ($ids as $id) { $article = ArticleModel::getArticle($id); if ($article) { // 删除标签分类 $article_tags = ArticleTagModel::allRelationship(function (QueryBuilder $qb) use($article) { /** @var ArticleModel $article */ $qb->andWhere($qb->expr()->eq('article_id', ':article_id'))->setParameter(':article_id', $article->id); }); foreach ($article_tags as $article_tag) { ArticleTagModel::deleteRelationship($article_tag['article_id'], $article_tag['tag_id']); $tag = TagModel::getTag($article_tag['tag_id']); if ($tag) { $tag->articleCount -= 1; TagModel::saveTag($tag); } } // 删除媒体 $medias = MediaModel::allMedias(function (QueryBuilder $qb) use($article) { /** @var ArticleModel $article */ $qb->andWhere($qb->expr()->eq('article_id', ':article_id'))->setParameter(':article_id', $article->id); }); foreach ($medias as $media) { MediaModel::deleteMedia($media['id']); } // 删除文章 ArticleModel::deleteArticle($id); } } $db->commit(); $session->addFlash('success', '操作成功'); } catch (\Exception $e) { $db->rollback(); $session->addFlash('error', $e->getMessage()); } return new RedirectResponse($this->generateUrl('admin_www_article')); } else { $ids = $request->query->get('ids'); $ids = json_decode($ids); if (!$ids) { return $this->render('@TachigoWWWAdmin/error-modal.html.twig', array('message' => '没有选中任何文章')); } else { $pager = ArticleModel::listArticles(1, count($ids), function (QueryBuilder $qb) use($ids) { $qb->where($qb->expr()->in('id', $ids)); }); return $this->render('article/delete.html.twig', array('articles' => $pager)); } } }
public function __invoke($slug = null) { $structure = StructureModel::search($slug); if (!$structure) { $structure = StructureModel::getStructure($slug); } if (!$structure) { // 404 } // 将所有文章用博客的形式展现 // 筛选出所有发布的文章 $request = $this->getRequest(); $page = $request->query->get('page'); $size = 15; $articles_pager = ArticleModel::listArticles($page, $size, function (QueryBuilder $qb) use($structure) { $qb->andWhere($qb->expr()->gt('publish_timestamp', 0)); $qb->andWhere($qb->expr()->eq('structure_id', ':structure_id'))->setParameter(':structure_id', $structure->id); $qb->addOrderBy('publish_timestamp', 'desc'); }); $articles = $articles_pager->getData(); foreach ($articles as $key => $article) { // 取出文章的图片媒体 $article['media'] = MediaModel::allMedias(function (QueryBuilder $qb) use($article) { $qb->andWhere($qb->expr()->eq('article_id', ':article_id'))->setParameter(':article_id', $article['id']); $qb->andWhere($qb->expr()->eq('type', ':type'))->setParameter(':type', 'picture'); }); // 取出文章的tag标签 $article_tags = ArticleTagModel::allRelationship(function (QueryBuilder $qb) use($article) { $qb->andWhere($qb->expr()->eq('article_id', ':article_id'))->setParameter(':article_id', $article['id']); }); $article['tags'] = array(); foreach ($article_tags as $article_tag) { $t = TagModel::getTag($article_tag['tag_id']); $article['tags'][] = $t->toArray(); } // 发布者 $article['publisher'] = array(); $article_publishers = ArticlePublisherModel::allRelationship(function (QueryBuilder $qb) use($article) { $qb->where($qb->expr()->eq('article_id', ':article_id'))->setParameter(':article_id', $article['id']); }); if ($article_publishers) { $article_publisher = array_shift($article_publishers); $publisher_id = $article_publisher['publisher_id']; $publisher = PublisherModel::getPublisher($publisher_id); if ($publisher) { $article['publisher'] = $publisher; } } $articles[$key] = $article; } $articles_pager->setData($articles); return $this->render('category/blogs.html.twig', array('blog_posts' => $articles_pager)); }
public function __invoke($id = null) { $request = $this->getRequest(); $page = $request->query->get('page'); $size = 15; // 查询出发布者 $publisher_id = $id; $publisher = PublisherModel::getPublisher($publisher_id); $publisher_articles = ArticlePublisherModel::allRelationship(function (QueryBuilder $qb) use($publisher) { $qb->where($qb->expr()->eq('publisher_id', ':publisher_id'))->setParameter(':publisher_id', $publisher->id); }); $article_ids = array(); foreach ($publisher_articles as $publisher_article) { $article_ids[] = $publisher_article['article_id']; } $article_ids = array_unique($article_ids); // 查询出文章 $articles_pager = ArticleModel::listArticles($page, $size, function (QueryBuilder $qb) use($article_ids) { $qb->andWhere($qb->expr()->gt('publish_timestamp', 0)); if ($article_ids) { $qb->andWhere($qb->expr()->in('id', $article_ids)); } else { $qb->andWhere($qb->expr()->eq('id', 0)); } $qb->addOrderBy('publish_timestamp', 'desc'); }); $articles = $articles_pager->getData(); foreach ($articles as $key => $article) { // 取出文章的图片媒体 $article['media'] = MediaModel::allMedias(function (QueryBuilder $qb) use($article) { $qb->andWhere($qb->expr()->eq('article_id', ':article_id'))->setParameter(':article_id', $article['id']); $qb->andWhere($qb->expr()->eq('type', ':type'))->setParameter(':type', 'picture'); }); // 取出文章的tag标签 $article_tags = ArticleTagModel::allRelationship(function (QueryBuilder $qb) use($article) { $qb->andWhere($qb->expr()->eq('article_id', ':article_id'))->setParameter(':article_id', $article['id']); }); $article['tags'] = array(); foreach ($article_tags as $article_tag) { $t = TagModel::getTag($article_tag['tag_id']); $article['tags'][] = $t->toArray(); } // 发布者 $article['publisher'] = $publisher; $articles[$key] = $article; } $articles_pager->setData($articles); return $this->render('publisher/blogs.html.twig', array('blog_posts' => $articles_pager, 'publisher' => $publisher)); }
public function __invoke($id = null) { $request = $this->getRequest(); $a_page = $request->query->get('a_page'); if (!$a_page) { $a_page = 1; } $a_size = $request->query->get('a_size'); $article = ArticleModel::getArticle($id); $article = $article->toArray(); // 取出文章的tag标签 $article_tags = ArticleTagModel::allRelationship(function (QueryBuilder $qb) use($article) { $qb->andWhere($qb->expr()->eq('article_id', ':article_id'))->setParameter(':article_id', $article['id']); }); $article['tags'] = array(); foreach ($article_tags as $article_tag) { $t = TagModel::getTag($article_tag['tag_id']); $article['tags'][] = $t->toArray(); } // 分页 if (!$a_size) { $content_pager = explode('<!-- pagebreak -->', $article['content']); } else { // 全文 $content_pager = array(str_replace('<!-- pagebreak -->', '', $article['content'])); } $article['content'] = $content_pager[$a_page - 1]; if (!$a_size) { $count = count($content_pager); } else { $count = 0; } $a_pager = new Pager(array(), $count, $a_page, 1); $a_pager->setPageParamName('a_page'); // 文章的发布者 $article['publisher'] = array(); $article_publishers = ArticlePublisherModel::allRelationship(function (QueryBuilder $qb) use($article) { $qb->andWhere($qb->expr()->eq('article_id', ':article_id'))->setParameter(':article_id', $article['id']); }); if ($article_publishers) { $article_publisher = array_shift($article_publishers); $publisher_id = $article_publisher['publisher_id']; $publisher = PublisherModel::getPublisher($publisher_id); if ($publisher) { $article['publisher'] = $publisher; } } // 轮播图 $carousels = MediaModel::allMedias(function (QueryBuilder $qb) use($article) { $qb->andWhere($qb->expr()->eq('article_id', ':article_id'))->setParameter(':article_id', $article['id']); $qb->andWhere($qb->expr()->eq('type', ':type'))->setParameter(':type', 'carousel'); }); foreach ($carousels as $k => $v) { $metadata = json_decode($v['metadata'], true); unset($v['metadata']); $v['description'] = ''; if ($metadata) { $v['description'] = $metadata['description']; } $carousels[$k] = $v; } // 所有的插件 $data = PluginModel::allPlugins(); $plugins = array(); foreach ($data as $row) { $row['sources'] = json_decode($row['sources'], true); $row['options'] = json_decode($row['options'], true); $row['apply_code'] = htmlspecialchars_decode($row['apply_code']); $plugins[$row['id']] = $row; } // 文章的插件 $data = ArticlePluginModel::allRelationship(function (QueryBuilder $qb) use($article) { $qb->andWhere($qb->expr()->eq('article_id', ':article_id'))->setParameter(':article_id', $article['id']); }); foreach ($data as $row) { $row['sources'] = json_decode($row['sources'], true); $row['options'] = json_decode($row['options'], true); $row['apply_code'] = htmlspecialchars_decode($row['apply_code']); if (isset($plugins[$row['plugin_id']])) { $plugins[$row['plugin_id']] = $row; } } // 评论 $c_page = $request->query->get('c_page'); if (!$c_page) { $c_page = 1; } $c_size = $request->query->get('c_size'); if (!$c_size) { $c_size = 3; } $c_pager = CommentModel::listComments($c_page, $c_size, function (QueryBuilder $qb) use($article) { $qb->andWhere($qb->expr()->eq('article_id', ':article_id'))->setParameter(':article_id', $article['id']); $qb->addOrderBy('create_timestamp'); }); $comments_data = $c_pager->getData(); foreach ($comments_data as $k => $comment_data) { // 获取用户数据 $comment_user_id = $comment_data['user_id']; /** @var \Tachigo\User\Aware\Component\UserAwareDispatcher $dispatcher */ $dispatcher = $this->getContainer()->tag('tachigo_user_dispatcher'); /** @var \Tachigo\User\Aware\Hook\UserHook $hook */ $hook = $this->getContainer()->tag('tachigo_user_hook.user'); $hook->setUserId($comment_user_id); $dispatcher->fire($hook); $comment_data['user'] = $hook->getResults(); $comment_data['reply'] = array(); if ($comment_data['comment_id']) { $reply_comment = CommentModel::getComment($comment_data['comment_id'])->toArray(); $comment_user_id = $reply_comment['user_id']; /** @var \Tachigo\User\Aware\Component\UserAwareDispatcher $dispatcher */ $dispatcher = $this->getContainer()->tag('tachigo_user_dispatcher'); /** @var \Tachigo\User\Aware\Hook\UserHook $hook */ $hook = $this->getContainer()->tag('tachigo_user_hook.user'); $hook->setUserId($comment_user_id); $dispatcher->fire($hook); $reply_comment['user'] = $hook->getResults(); $comment_data['reply'] = $reply_comment; } $comments_data[$k] = $comment_data; } $c_pager->setData($comments_data); $c_pager->setPageParamName('c_page'); // 分页内容 $pager_query = array('a_page' => $a_page, 'a_size' => $a_size, 'c_page' => $c_page, 'c_size' => $c_size); $a_pager->setQuery($pager_query); $c_pager->setQuery($pager_query); // 导航条 $structure_id = $article['structure_id']; $structure = StructureModel::getStructure($structure_id); /** @var StructureModel[] $breadcrumbs */ $breadcrumbs = $structure->getNodeSinglePath(); array_shift($breadcrumbs); return $this->render('article/blog.html.twig', array('article' => $article, 'a_pager' => $a_pager, 'c_pager' => $c_pager, 'carousels' => $carousels, 'plugins' => $plugins, 'breadcrumbs' => $breadcrumbs)); }
protected function handle() { $tags = TagModel::allTags(); $tree = StructureModel::getTree(); $session = $this->getSession(); $article = ArticleModel::getArticle($this->id); if (!$article) { $session->addFlash('error', '文章不存在'); return new RedirectResponse($this->generateUrl('admin_www_article')); } // 文章已有的标签 $article_tags = ArticleTagModel::allRelationship(function (QueryBuilder $qb) use($article) { /** @var ArticleModel $article */ $qb->andWhere($qb->expr()->eq('article_id', ':article_id'))->setParameter(':article_id', $article->id); }); $request = $this->getRequest(); if ($request->getMethod() == 'POST') { $posts = $request->request; $db = WWWDatabase::getDb(); try { $title = $posts->get('title'); $content = $posts->get('content'); $summary = $posts->get('summary'); $structure_id = $posts->get('structure_id'); $tags_id = $posts->get('tags'); if (!$tags_id) { $tags_id = array(); } if (!$title) { throw new \Exception('文章标题不能为空'); } if (!$structure_id) { throw new \Exception('请选择栏目'); } $structure = StructureModel::getStructure($structure_id); if (!$structure) { throw new \Exception('栏目不存在'); } // 开启事务 $db->transaction(); // 创建文章 $article->title = $title; $article->content = $content; $article->summary = $summary; $article->structureId = $structure_id; $article->updateTimestamp = time(); // 保存 // 解析媒体 // 删除已有媒体 $medias = MediaModel::allMedias(function (QueryBuilder $qb) use($article) { $qb->andWhere($qb->expr()->eq('article_id', ':article_id'))->setParameter(':article_id', $article->id); }); foreach ($medias as $media_info) { MediaModel::deleteMedia($media_info['id']); } $cdn_url = $this->getContainer()->getParameter('cdn_url'); $cdn_url = str_replace('/', '\\/', $cdn_url); // 解析图片 $pictures = ArticleBusiness::parsePictures($cdn_url, $content); foreach ($pictures as $picture_source) { $media = new MediaModel(); $media->type = 'picture'; $media->source = $picture_source; $media->articleId = $article->id; // 保存 MediaModel::createMedia($media); } ArticleModel::saveArticle($article); // 清空原有分类 foreach ($article_tags as $article_tag) { $tag_id = $article_tag['tag_id']; $tag = TagModel::getTag($tag_id); if ($tag) { $tag->articleCount -= 1; // 保存 TagModel::saveTag($tag); } // 删除关联 $article_tag = ArticleTagModel::getRelationship($article->id, $tag->id); if ($article_tag) { ArticleTagModel::deleteRelationship($article->id, $tag->id); } } // 添加标签的文章数量 foreach ($tags_id as $tag_id) { $tag = TagModel::getTag($tag_id); if (!$tag) { throw new \Exception('标签不存在'); } $tag->articleCount += 1; // 保存tag标签 TagModel::saveTag($tag); // 添加文章与标签的关系 $article_tag = new ArticleTagModel(); $article_tag->articleId = $article->id; $article_tag->tagId = $tag->id; ArticleTagModel::createRelationship($article_tag); } /*// 添加插件 $plugin_ids = $posts->get('plugins'); if (!$plugin_ids) { $plugin_ids = array(); } // 删除不要的插件 foreach ($article_plugins as $article_plugin) { if (!in_array($article_plugin['plugin_id'], $plugin_ids)) { ArticlePluginModel::deleteRelationship($article_plugin['article_id'], $article_plugin['plugin_id']); unset($article_plugins[$article_plugin['plugin_id']]); } } // 检查插件是否存在 foreach ($plugin_ids as $plugin_id) { if (!isset($plugins[$plugin_id])) { throw new \Exception("插件不存在或者未启用"); } if (!isset($article_plugins[$plugin_id])) { // 创建文章插件关系 $article_plugin = new ArticlePluginModel(); $article_plugin->articleId = $article->id; $article_plugin->pluginId = $plugin_id; // 存储默认数据 $article_plugin->sources = $plugins[$plugin_id]['sources']; $article_plugin->applyCode = $plugins[$plugin_id]['default_code']; $article_plugin->options = $plugins[$plugin_id]['default_options']; // 保存 ArticlePluginModel::createRelationship($article_plugin); } }*/ $db->commit(); $session->addFlash('success', '保存成功'); return new RedirectResponse($this->generateUrl('admin_www_article_edit', array('id' => $this->id))); } catch (\Exception $e) { $db->rollback(); $session->addFlash('error', $e->getMessage()); return new RedirectResponse($this->generateUrl('admin_www_article_edit', array('id' => $this->id))); } } return $this->render('article/edit.html.twig', array('article' => $article, 'tree' => $tree, 'tags' => $tags, 'article_tags' => $article_tags)); }