vendor/score/cms/src/Controller/Page/PublicController.php line 24

Open in your IDE?
  1. <?php
  3. namespace Score\CmsBundle\Controller\Page;
  5. use DateTime;
  6. use Score\CmsBundle\Entity\Menu;
  7. use Score\CmsBundle\Entity\Stat;
  8. use Score\CmsBundle\Services\PageManager;
  9. use Score\CmsBundle\Services\StatManager;
  10. use Score\CmsBundle\Services\OptionManager;
  11. use Symfony\Component\HttpFoundation\Request;
  12. use Symfony\Component\HttpFoundation\Response;
  13. use Symfony\Component\Routing\Annotation\Route;
  14. use Score\BaseBundle\Services\AdjacencyArrayTreeManager;
  15. use Score\BaseBundle\Services\SeoUrl;
  16. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  18. class PublicController extends AbstractController
  19. {
  20.     /**
  21.      * @Route("/", name="default_homepage")
  22.      * @Route("/{seoid}", name="default_subpage", requirements={"seoid"="^(?!login$|logout$|registration$|api/|user/|clanky/|udalosti/|dokumenty/|dokument/|admin/|cookies$|vyhladavanie|_profiler/).+"}, condition="!request.isXmlHttpRequest()")
  23.      */
  24.     public function subpageAction(PageManager $pageManager, $seoid = null, $cmsTemplate = true)
  25.     {
  26.         $responseCode = 200;
  27.         if ($seoid) {
  28.             if ($seoid === "homepage") {
  29.                 return $this->redirectToRoute('default_homepage');
  30.             }
  31.             $page = $pageManager->getPageBySeoId($seoid);
  32.             if (!$page || $page->getIsDeleted() || $page->getStatus() === "hidden") {
  33.                 $page = $pageManager->getPageBySeoId('error');
  34.                 $responseCode = 404;
  35.             }
  36.             if ($page->getRedirectToPage()) {
  37.                 return $this->redirectToRoute('default_subpage', [
  38.                     "seoid" => $page->getRedirectToPage()->getSeoId()
  39.                 ]);
  40.             }
  41.         } else {
  42.             $page = $pageManager->getPageBySeoId('homepage');
  43.         }
  45.         if ($cmsTemplate === false) {
  46.             return ["page" => $page, "code" => $responseCode];
  47.         }
  49.         return new Response($this->renderView('@ScoreCms/Public/default/subpage.html.twig', [
  50.             'page' => $page,
  51.         ]), $responseCode);
  52.     }
  54.     /**
  55.      * @Route("/cookies", name="cookies")
  56.      */
  57.     public function cookiesAction(){
  58.         return $this->render('@ScoreCms/Public/idsk/cookies.html.twig');
  59.     }
  61.      /**
  62.      * @Route("/vyhladavanie", name="search")
  63.      */
  64.     public function searchAction(Request $request, SeoUrl $seoUrlManager, $cmsTemplate = true){
  66.         $slug = $request->get('search');
  67.         $result = [];
  69.         if ($slug && $seoUrlManager->createSlug($slug)) {
  70.             
  71.             //$seoSlug = $seoUrlManager->createSlug($slug);
  72.             $seoSlug = $seoUrlManager->removeDiacritic($slug);
  74.             $con = $this->getDoctrine()->getManager()->getConnection();
  75.             $rawData = [];
  76.             // //$rawData['page'] = $con->fetchAllAssociative('SELECT p.title as name , p.content , p.seo_id as slug, p.icon as icon, p.edited_at as edit FROM cms_page p');
  77.             // $rawData['page'] = $con->fetchAllAssociative('SELECT p.title as name , p.content , p.seo_id as slug, p.icon as icon, p.edited_at as edit FROM cms_page p WHERE p.seo_id NOT IN (?, ?, ?)', ["as", "error", "homepage"]);
  78.             // $rawData['article'] = $con->fetchAllAssociative('SELECT a.name as name, a.teaser, a.body, a.author, a.slug as slug, a.icon as icon, a.edited_at as edit FROM cms_article a');
  79.             // $rawData['event'] = $con->fetchAllAssociative('SELECT e.name as name, e.content, e.teaser, e.organizer, e.contact_person, e.slug as slug, e.icon as icon, e.edited_at as edit FROM cms_event e');
  81.             $rawData['page'] = $con->fetchAllAssociative('SELECT p.title as name , p.seo_id as slug, p.p_search as search, p.icon as icon, p.edited_at as edit FROM cms_page p WHERE p.seo_id NOT IN (?, ?, ?)', ["as", "error", "homepage"]);
  82.             $rawData['article'] = $con->fetchAllAssociative('SELECT a.name as name, a.slug as slug, a.search as search, a.icon as icon, a.edited_at as edit FROM cms_article a');
  83.             $rawData['event'] = $con->fetchAllAssociative('SELECT e.name as name, e.slug as slug, e.e_search as search, e.icon as icon, e.edited_at as edit FROM cms_event e');
  85.             foreach ($rawData as $type => $rows) {
  86.                 foreach ($rows as $row) {
  87.                     if ($row['SEARCH']  && strpos($row['SEARCH'], $seoSlug) !== false) {
  88.                         $result[] = [
  89.                             "title" => $row['NAME'],
  90.                             "slug" => $row['SLUG'],
  91.                             "icon" => $row['ICON'],
  92.                             "edited"=> $row['EDIT'],
  93.                             "type" => $type
  94.                         ];
  95.                     }
  96.                 }
  97.             }
  99.             usort($result, function ($item1, $item2) {
  100.                 return $item2['edited'] <=> $item1['edited'];
  101.             });
  102.         }
  104.         if ($cmsTemplate === false) {
  105.             return $result;
  106.         }
  108.         return $this->render('@ScoreCms/Public/default/search.html.twig', [
  109.             "items" => $result,
  110.             "search_slug" => $slug
  111.         ]);
  112.     }
  113. }