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

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/|file/|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) {
  33.                 $page = $pageManager->getPageBySeoId('error');
  34.                 $responseCode = 404;
  35.             }
  36.         } else {
  37.             $page = $pageManager->getPageBySeoId('homepage');
  38.         }
  40.         if ($cmsTemplate === false) {
  41.             return ["page" => $page, "code" => $responseCode];
  42.         }
  44.         return new Response($this->renderView('@ScoreCms/Public/default/subpage.html.twig', [
  45.             'page' => $page,
  46.         ]), $responseCode);
  47.     }
  49.     /**
  50.      * @Route("/cookies", name="cookies")
  51.      */
  52.     public function cookiesAction(){
  53.         return $this->render('@ScoreCms/Public/idsk/cookies.html.twig');
  54.     }
  56.      /**
  57.      * @Route("/vyhladavanie", name="search")
  58.      */
  59.     public function searchAction(Request $request, SeoUrl $seoUrlManager, $cmsTemplate = true){
  61.         $slug = $request->get('search');
  62.         $result = [];
  64.         if ($slug && $seoUrlManager->createSlug($slug)) {
  65.             
  66.             //$seoSlug = $seoUrlManager->createSlug($slug);
  67.             $seoSlug = $seoUrlManager->removeDiacritic($slug);
  69.             $con = $this->getDoctrine()->getManager()->getConnection();
  70.             $rawData = [];
  71.             // //$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');
  72.             // $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"]);
  73.             // $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');
  74.             // $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');
  76.             $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"]);
  77.             $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');
  78.             $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');
  80.             foreach ($rawData as $type => $rows) {
  81.                 foreach ($rows as $row) {
  82.                     if ($row['search']  && strpos($row['search'], $seoSlug) !== false) {
  83.                         $result[] = [
  84.                             "title" => $row['name'],
  85.                             "slug" => $row['slug'],
  86.                             "icon" => $row['icon'],
  87.                             "edited"=> $row['edit'],
  88.                             "type" => $type
  89.                         ];
  90.                     }
  91.                 }
  92.             }
  94.             usort($result, function ($item1, $item2) {
  95.                 return $item2['edited'] <=> $item1['edited'];
  96.             });
  97.         }
  99.         if ($cmsTemplate === false) {
  100.             return $result;
  101.         }
  103.         return $this->render('@ScoreCms/Public/default/search.html.twig', [
  104.             "items" => $result,
  105.             "search_slug" => $slug
  106.         ]);
  107.     }
  108. }