コード例 #1
0
 /**
  * Lists all pages with given $tag
  *
  * @param string $tag An urlencoded tag string
  *
  * @return void
  */
 public function listAction($tag)
 {
     $tag = Tag::fromUrl($tag);
     $pages = $this->pageRepository->findAllByTag($tag);
     $this->view->assign('pages', $pages);
     $this->view->assign('tag', $tag);
 }
コード例 #2
0
ファイル: TagManager.php プロジェクト: svenhartmann/vantomas
 /**
  * Returns a TagCloud impl
  *
  * @return TagCloudInterface
  */
 public function getCloud()
 {
     $pages = $this->pageRepository->findAllWithTags();
     foreach ($pages as $page) {
         $pageTags = GeneralUtility::trimExplode(',', $page->getKeywords());
         foreach ($pageTags as $pageTag) {
             $this->tagCloud->add(Tag::fromString($pageTag));
         }
     }
     return $this->tagCloud;
 }
コード例 #3
0
 /**
  * Finds all pages by given Tag
  *
  * @param Tag $tag Search pages with this tag
  *
  * @return Page[]
  */
 public function findAllByTag(Tag $tag)
 {
     $query = $this->createQuery();
     $sql = "\n            SELECT\n                *,\n                FROM_UNIXTIME(crdate) as created_at,\n                FROM_UNIXTIME(lastUpdated) as last_updated_at\n            FROM\n                pages\n            WHERE\n                nav_hide = 0\n                AND deleted = 0\n                AND hidden = 0\n                AND keywords IS NOT NULL\n                AND keywords <> ''\n                AND (\n                    keywords LIKE ?\n                    OR keywords LIKE ?\n                    OR keywords LIKE ?\n                    OR keywords LIKE ?\n                )\n        ";
     $query->statement($this->objectManager->get(PreparedStatement::class, $sql, 'pages'), [',%' . $tag->getValue() . '%,', '%' . $tag->getValue() . '%,', ',%' . $tag->getValue() . '%', '%' . $tag->getValue() . '%']);
     $rawResults = $query->execute(true);
     return $this->hydrate($rawResults);
 }