Ejemplo n.º 1
0
 protected function handle()
 {
     $request = $this->getRequest();
     if ($request->getMethod() == 'POST') {
         $ids = $request->request->get('ids');
         $session = $this->getSession();
         $db = TagModel::getDb();
         try {
             $db->transaction();
             foreach ($ids as $id) {
                 TagModel::deleteTag($id);
             }
             $db->commit();
             $session->addFlash('success', '操作成功');
         } catch (\Exception $e) {
             $db->rollback();
             $session->addFlash('error', $e->getMessage());
         }
         return new RedirectResponse($this->generateUrl('admin_www_tag'));
     } else {
         $ids = $request->query->get('ids');
         $ids = json_decode($ids);
         if (!$ids) {
             return $this->render('@TachigoWWWAdmin/error-modal.html.twig', array('message' => '没有选中任何标签'));
         } else {
             $pager = TagModel::listTags(1, count($ids), function (QueryBuilder $qb) use($ids) {
                 $qb->where($qb->expr()->in('id', $ids));
             });
             return $this->render('tag/delete.html.twig', array('tags' => $pager));
         }
     }
 }
Ejemplo n.º 2
0
 protected function handle()
 {
     $request = $this->getRequest();
     $tag = TagModel::getTag($this->id);
     if ($request->getMethod() == 'POST') {
         $posts = $request->request;
         try {
             $name = $posts->get('name');
             if (!$name) {
                 throw new \Exception('标签名不能为空');
             }
             $description = $posts->get('description');
             $slug = $posts->get('slug');
             if (!$slug) {
                 $slug = null;
             }
             $tag->name = $name;
             $tag->description = $description;
             $tag->slug = $slug;
             $tag->updateTimestamp = time();
             // 保存
             $tag = TagModel::saveTag($tag);
             return new JsonResponse(array('status' => 1, 'data' => array('tag' => $tag->toArray())));
         } catch (\Exception $e) {
             return new JsonResponse(array('status' => 0, 'data' => $e->getMessage()));
         }
     }
     return $this->render('tag/edit.html.twig', array('tag' => $tag));
 }
Ejemplo n.º 3
0
 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));
         }
     }
 }
Ejemplo n.º 4
0
 public function __invoke($limit = null)
 {
     $tags = TagModel::allTags(function (QueryBuilder $qb) use($limit) {
         if ($limit) {
             $qb->setFirstResult(1);
             $qb->setMaxResults($limit);
         }
         $qb->addOrderBy('article_count', 'desc');
     });
     return $this->render('fragment/tags.html.twig', array('tags' => $tags, 'limit' => $limit));
 }
Ejemplo n.º 5
0
 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));
 }
Ejemplo n.º 6
0
 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));
 }
Ejemplo n.º 7
0
 protected function handle()
 {
     $request = $this->getRequest();
     if ($request->getMethod() == 'POST') {
         $posts = $request->request;
         try {
             $name = $posts->get('name');
             if (!$name) {
                 throw new \Exception('标签名不能为空');
             }
             $description = $posts->get('description');
             $slug = $posts->get('slug');
             if (!$slug) {
                 $slug = null;
             }
             // 判断slug是否重复
             if ($slug) {
                 $tag = TagModel::getTagBySlug($slug);
                 if ($tag) {
                     throw new \Exception('标签URL占位符已被使用');
                 }
             }
             // 创建tag
             $tag = new TagModel();
             $tag->name = $name;
             $tag->description = $description;
             $tag->slug = $slug;
             $now = time();
             $tag->createTimestamp = $now;
             $tag->updateTimestamp = $now;
             // 保存
             $tag = TagModel::createTag($tag);
             return new JsonResponse(array('status' => 1, 'data' => array('tag' => $tag->toArray())));
         } catch (\Exception $e) {
             return new JsonResponse(array('status' => 0, 'data' => $e->getMessage()));
         }
     }
     return $this->render('tag/add.html.twig');
 }
Ejemplo n.º 8
0
 /**
  * 保存
  * @param TagModel $tag
  * @return TagModel
  * @throws \Exception
  */
 public static function saveTag(TagModel $tag)
 {
     return self::editTag($tag->toArray());
 }
Ejemplo n.º 9
0
 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));
 }
Ejemplo n.º 10
0
 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));
 }
Ejemplo n.º 11
0
 protected function handle()
 {
     $tree = StructureModel::getTree();
     $tags = TagModel::allTags();
     $request = $this->getRequest();
     if ($request->getMethod() == 'POST') {
         $session = $this->getSession();
         $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');
             if (!$title) {
                 throw new \Exception('文章标题不能为空');
             }
             if (!$structure_id) {
                 throw new \Exception('请选择栏目');
             }
             $structure = StructureModel::getStructure($structure_id);
             if (!$structure) {
                 throw new \Exception('栏目不存在');
             }
             $tags_id = $posts->get('tags');
             if (!$tags_id) {
                 $tags_id = array();
             }
             // 开启事务
             $db->transaction();
             // 创建文章
             $article = new ArticleModel();
             $article->title = $title;
             $article->content = $content;
             $article->summary = $summary;
             $article->structureId = $structure_id;
             $now = time();
             $article->createTimestamp = $now;
             $article->updateTimestamp = $now;
             // 保存
             $article = ArticleModel::createArticle($article);
             // 添加标签的文章数量
             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);
             }
             // 解析媒体
             $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);
             }
             $db->commit();
             $session->addFlash('success', '创建成功');
             return new RedirectResponse($this->generateUrl('admin_www_article_edit', array('id' => $article->id)));
         } catch (\Exception $e) {
             $db->rollback();
             $session->addFlash('error', $e->getMessage());
             return new RedirectResponse($this->generateUrl('admin_www_article_add'));
         }
     }
     return $this->render('article/add.html.twig', array('tree' => $tree, 'tags' => $tags));
 }
Ejemplo n.º 12
0
 protected function handle()
 {
     $columns = array('ID', '名称', '描述', 'URL占位符', '内容数量', '创建时间', '更新时间');
     $fields = array('id', 'name', 'description', 'slug', 'article_count', 'create_timestamp', 'update_timestamp');
     $request = $this->getRequest();
     if ($request->isXmlHttpRequest()) {
         $posts = $request->request;
         $page_offset = $posts->get('start');
         $page_offset = intval($page_offset);
         $page_size = $posts->get('length');
         $page_size = intval($page_size);
         $is_all = false;
         if ($page_size < 0) {
             $is_all = true;
         }
         $s_echo = $posts->get('draw');
         $s_echo = intval($s_echo);
         $search = $posts->get('search');
         $search_value = $search['value'];
         $records = array();
         $records['data'] = array();
         $records['draw'] = $s_echo;
         $records['recordsTotal'] = 0;
         $records['recordsFiltered'] = 0;
         if ($is_all) {
             $page_size = TagModel::getCount(function (QueryBuilder $qb) use($search_value) {
                 if ($search_value) {
                     $qb->orWhere($qb->expr()->like("`name`", ":name"))->setParameter(":name", "%{$search_value}%");
                     $qb->orWhere($qb->expr()->like("`slug`", ":slug"))->setParameter(":slug", "%{$search_value}%");
                 }
             });
         }
         $page = $page_offset / $page_size + 1;
         $pager = TagModel::listTags($page, $page_size, function (QueryBuilder $qb) use($search_value) {
             if ($search_value) {
                 $qb->orWhere($qb->expr()->like("`name`", ":name"))->setParameter(":name", "%{$search_value}%");
                 $qb->orWhere($qb->expr()->like("`slug`", ":slug"))->setParameter(":slug", "%{$search_value}%");
             }
             $qb->addOrderBy('create_timestamp', 'desc');
         });
         $total = $pager->getCount();
         $records['recordsTotal'] = $total;
         $records['recordsFiltered'] = $total;
         $data = $pager->getData();
         foreach ($data as $k => $v) {
             $line = array();
             $line[] = '<input type="checkbox" name="id[]" value="' . $v['id'] . '">';
             foreach ($fields as $field) {
                 if (isset($v[$field]) || $v[$field] === null) {
                     if ($field == 'create_timestamp' || $field == 'update_timestamp') {
                         // 时间
                         $line[] = date('Y-m-d H:i:s', $v[$field]);
                     } elseif ($field == 'slug') {
                         if (!$v[$field]) {
                             $line[] = 'Null';
                         } else {
                             $line[] = $v[$field];
                         }
                     } elseif ($field == 'article_count') {
                         $line[] = intval($v[$field]);
                     } elseif (!$v[$field]) {
                         $line[] = '&nbsp;';
                     } else {
                         $line[] = $v[$field];
                     }
                 }
             }
             $edit_url = $this->generateUrl('admin_www_tag_edit', array('id' => $v['id']));
             $line[] = '<a data-toggle="modal" data-target="#modal" href="' . $edit_url . '">编辑</a>';
             $records['data'][] = $line;
         }
         return new JsonResponse($records);
     }
     return $this->render('tag/index.html.twig', array('columns' => $columns));
 }