src/Controller/Pages/Pages/PagesController.php line 209

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Pages\Pages;
  5. use App\Entity\Db_Seotable;
  6. use App\Entity\Db_Contents;
  7. use App\Entity\St_Settings;
  8. use App\Entity\Gl_Images;
  9. use App\Entity\Db_Users;
  10. use App\Entity\Db_Products;
  11. use App\Entity\Db_Biketypes;
  12. use Symfony\Component\Translation\TranslatorInterface;
  13. use Symfony\Component\PropertyAccess\PropertyAccess;
  14. use Symfony\Component\HttpFoundation\Response;
  15. use Symfony\Component\Routing\Annotation\Route;
  16. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Method;
  17. use Symfony\Bundle\FrameworkBundle\Controller\Controller;    
  18. use Symfony\Component\Security\Http\Authentication\AuthenticationUtils;
  19. use Symfony\Component\Security\Core\Authorization\AuthorizationCheckerInterface;
  20. use Symfony\Component\Security\Core\Exception\AccessDeniedException;
  21. use Symfony\Component\HttpFoundation\Request;
  22. use Symfony\Component\HttpFoundation\StreamedResponse;
  23. use Symfony\Component\Security\Core\Security;
  24. use Symfony\Component\HttpFoundation\Session\SessionInterface;
  27.     class PagesController extends Controller
  28.     {
  30.         private $security;
  31.         
  32.         function __construct(SessionInterface $session, Security $security)
  33.         {
  34.             
  35.             $this->lang         = (isset($_COOKIE['langFront']) && !empty($_COOKIE['langFront'])) ? $this->lang = $_COOKIE['langFront'] : $this->lang = "HU";
  36.             $this->session         = $session;
  37.             $this->districts = array();
  38.             $this->security = $security;
  42.         }
  44.         /**
  45.         * @Route("/teszt/teszt-oldal", name="teszt-oldal")
  46.         */
  48.         public function teszt(Security $security) {
  49.             return new Response("Teszt");
  50.         }
  52.         /**
  53.         * @Route("/sitemap.xml", defaults={"_format"="xml"}, name="sitemap")
  54.         */
  56.         public function getSitemapXml(Security $security) {
  57.             header("Expires: 0");
  58.             header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
  59.             header("Cache-Control: no-store, no-cache, must-revalidate");
  60.             header("Cache-Control: post-check=0, pre-check=0", false);
  61.             header("Pragma: no-cache");
  62.             header("X-Robots-Tag: index, follow", true);
  64.             $contents = $this->getDoctrine()->getRepository(Db_Contents::class)->findAllSitemap();
  67.             return $this->render("templates/default/pages/sitemap.html.twig", array(
  69.                 "contents" => $contents,
  71.             ));
  73.         }
  75.         /**
  76.         * @Route("/kereses", name="pages-search")
  77.         */
  79.         public function getSearchPage(Security $security, Request $request) {
  81.             //Beállítjuk az adott oldalt header adatait, hogy ne cacheljen.
  82.             header("Expires: 0");
  83.             header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
  84.             header("Cache-Control: no-store, no-cache, must-revalidate");
  85.             header("Cache-Control: post-check=0, pre-check=0", false);
  86.             header("Pragma: no-cache");
  87.             
  88.             return $this->redirect("/kereses/".$request->query->get("search")."/oldal/1");
  90.         }
  92.         
  95.         /**
  96.         * @Route("/kereses/blog", name="pages-search-blog")
  97.         */
  99.         public function getSearchPageBlog(Security $security, Request $request) {
  101.             //Beállítjuk az adott oldalt header adatait, hogy ne cacheljen.
  102.             header("Expires: 0");
  103.             header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
  104.             header("Cache-Control: no-store, no-cache, must-revalidate");
  105.             header("Cache-Control: post-check=0, pre-check=0", false);
  106.             header("Pragma: no-cache");
  107.             
  108.             return $this->redirect("/kereses/blog/".$request->query->get("search")."/oldal/1");
  110.         }
  112.          /**
  113.         * @Route("/megrendeles", name="order-success-page")asd
  114.         */
  116.         public function orderSuccessPage(Security $security, Request $request) {
  117.             if ( $this->security->getUser() ) {
  118.                 $pages =  $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(['TypeID' => 7, "Visible" => "y", "ParentID" => ["", NULL]],["Short" => "ASC"]);
  119.             } else {
  120.                 $pages =  $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(['TypeID' => 7, "Visible" => "y", "ParentID" => ["", NULL], "OnlyWithLogin" => "n"],["Short" => "ASC"]);
  121.             }
  122.             if ( $request->query->get("text") ) {
  123.                 $html = $request->query->get("text");
  124.             } else {
  125.                 
  126.                 $html = "";
  127.             }
  128.             $content = new Db_Contents();
  129.             $content->setTitle("Rendelés visszaigazolása");
  130.             return $this->render("templates/default/pages/order-success.html.twig", array(
  131.                 "html" => $html,
  132.                 "pages" => $pages,
  133.                 "content" => $content,
  135.             ));
  137.         }
  139.         /**
  140.         * @Route("/kezdolap", name="index")
  141.         */
  143.         public function getIndexRedirectPage(Security $security) {
  144.             header("HTTP/1.1 301 Moved Permanently"); 
  145.             header("Location: /"); 
  146.             exit();
  147.         }
  149.         /**
  150.         * @Route("/adwords", name="adwords")
  151.         */
  153.         public function getAdwirdsRedirectPage(Security $security) {
  154.             header("HTTP/1.1 301 Moved Permanently"); 
  155.             header("Location: /weboldal-keszites"); 
  156.             exit();
  157.         }
  159.         /**
  160.         * @Route("/", name="pages")
  161.         */
  163.         public function getIndexPage(Security $security) {
  165.             //Beállítjuk az adott oldalt header adatait, hogy ne cacheljen.
  166.             header("Expires: 0");
  167.             header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
  168.             header("Cache-Control: no-store, no-cache, must-revalidate");
  169.             header("Cache-Control: post-check=0, pre-check=0", false);
  170.             header("Pragma: no-cache");
  171.             header("X-Robots-Tag: index, follow", true);
  172.             $content = $this->getDoctrine()->getRepository(Db_Contents::class)->findOneBy(['UrlName' => "kezdolap"]);
  173.             if ( $this->security->getUser() ) {
  174.                 $pages =  $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(['TypeID' => 7, "Visible" => "y", "ParentID" => ["", NULL]],["Short" => "ASC"]);
  175.             } else {
  176.                 $pages =  $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(['TypeID' => 7, "Visible" => "y", "ParentID" => ["", NULL], "OnlyWithLogin" => "n"],["Short" => "ASC"]);
  177.             }
  178.             return $this->render("templates/default/pages/index.html.twig", array(
  180.                 "content" => $content,
  181.                 "seo" => $this->getDoctrine()->getRepository(Db_Seotable::class)->findSeoDataByPageIDAndType($content->getID(), "Content"),
  182.                 "books" => $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(['TypeID' => 9, "Visible" => "y", "Lang" => $this->lang],["Short" => "DESC"],3),
  183.                 "writes" => $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(['TypeID' => 11, "Visible" => "y", "Lang" => $this->lang],["Short" => "DESC"]),
  184.                 "testimonials" => $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(['TypeID' => 10, "Visible" => "y", "Lang" => $this->lang],["Short" => "DESC"],4),
  185.                 "sliders" => $this->getDoctrine()->getRepository(Db_Contents::class)->findOneBy(['TypeID' => 1, "Visible" => "y", "Lang" => $this->lang],["Short" => "DESC"]),
  186.                 "posts" => $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(['TypeID' => 3, "Visible" => "y", "Lang" => $this->lang],["ID" => "DESC"],3),
  187.                 "pages" => $pages,
  189.             ));
  191.         }
  193.         /**
  194.         * @Route("/{urlName}", name="pages-per-url-name")
  195.         */
  197.         public function getPagePerUrlName(Security $security, $urlName) {
  199.             //Beállítjuk az adott oldalt header adatait, hogy ne cacheljen.
  200.             header("Expires: 0");
  201.             header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
  202.             header("Cache-Control: no-store, no-cache, must-revalidate");
  203.             header("Cache-Control: post-check=0, pre-check=0", false);
  204.             header("Pragma: no-cache");
  205.             header("X-Robots-Tag: index, follow", true);
  206.             
  207.             $content     = $this->getDoctrine()->getRepository(Db_Contents::class)->findOneBy(['UrlName' => $urlName]);
  209.             if ( $content->getOnlyWithLogin() == "y" ) {
  210.                 if ( !$security->getUser() ) {
  211.                     $product = $this->getDoctrine()->getRepository(Db_Products::class)->findOneBy(["UrlName" => "eves-elofizetes"]);
  212.                     return $this->render('templates/default/pages/loggedin.html.twig', array(
  213.                         "content" => $content,
  214.                         "pages" => $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(['TypeID' => 7, "Visible" => "y", "ParentID" => ["", NULL]],["Short" => "ASC"]),
  215.                         "product" => $product,
  216.                     ));
  217.                 }
  218.             }
  219.             
  220.             if ( !$content ) {
  221.                 throw $this->createNotFoundException('The page does not exist');
  222.             }
  223.             
  225.             if ( isset($content) && !empty($content) ) {
  226.                 if ( $content->getUrlName() == "elet-thassoson" ) {
  227.                     return $this->redirect("/elet-thassoson/oldal/1", "301");
  228.                 }
  229.                 
  230.                 if ( file_exists($this->getParameter('template_dir')."templates/default/pages/page-".$content->getID().".html.twig") ) {
  231.                     $render = "templates/default/pages/page-".$content->getID().".html.twig";
  232.                 } else {
  234.                     if (  $content->getTypeId() == 9 ) {
  235.                         $render = "templates/default/pages/page-content-books.html.twig";
  236.                     } else if ( $content->getTypeId() == 3 ) {
  237.                         $render = "templates/default/pages/page-content-blog.html.twig";
  238.                     } else {
  239.                         $render = "templates/default/pages/page-content.html.twig";
  240.                     }
  242.                     
  243.                 }
  244.                 if ( $this->security->getUser() ) {
  245.                     $pages =  $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(['TypeID' => 7, "Visible" => "y", "ParentID" => ["", NULL]],["Short" => "ASC"]);
  246.                 } else {
  247.                     $pages =  $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(['TypeID' => 7, "Visible" => "y", "ParentID" => ["", NULL], "OnlyWithLogin" => "n"],["Short" => "ASC"]);
  248.                 }
  249.                 return $this->render($render, array(
  250.                     "content"             => $content,
  251.                 "seo" => $this->getDoctrine()->getRepository(Db_Seotable::class)->findSeoDataByPageIDAndType($content->getID(), "Content"),
  252.                 "books" => $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(['TypeID' => 9, "Visible" => "y", "Lang" => $this->lang],["Short" => "DESC"],3),
  253.                 "writes" => $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(['TypeID' => 11, "Visible" => "y", "Lang" => $this->lang],["Short" => "DESC"]),
  254.                 "testimonials" => $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(['TypeID' => 10, "Visible" => "y", "Lang" => $this->lang],["Short" => "DESC"],4),
  255.                 "sliders" => $this->getDoctrine()->getRepository(Db_Contents::class)->findOneBy(['TypeID' => 1, "Visible" => "y", "Lang" => $this->lang],["Short" => "DESC"]),
  256.                 "posts" => $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(['TypeID' => 3, "Visible" => "y", "Lang" => $this->lang],["ID" => "DESC"],3),
  257.                 "pages" => $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(['TypeID' => 7, "Visible" => "y", "ParentID" => ["", NULL]],["Short" => "ASC"]),
  258.                 "subcontents" => $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(["Visible" => "y", "ParentID" => $content->getId()],["Short" => "ASC"]),
  260.                 ));
  262.             } else {
  264.                 return $this->render('templates/default/pages/404.html.twig', array(
  265.                     "content" => $content,
  266.                     "pages"    => $pages,
  267.                 ));
  269.             }
  271.         }
  273.         /**
  274.         * @Route("/{urlName}/oldal/{pageNumber}", name="pages-per-url-name-per-page")
  275.         */
  277.         public function getPagePerUrlNamePerPage(Security $security, $urlName, $pageNumber, Request $request) {
  279.             //Beállítjuk az adott oldalt header adatait, hogy ne cacheljen.
  280.             header("Expires: 0");
  281.             header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
  282.             header("Cache-Control: no-store, no-cache, must-revalidate");
  283.             header("Cache-Control: post-check=0, pre-check=0", false);
  284.             header("Pragma: no-cache");
  286.             $content     = $this->getDoctrine()->getRepository(Db_Contents::class)->findOneBy(['UrlName' => $urlName]);
  287.             if ( !$content ) {
  288.                 throw $this->createNotFoundException('The page does not exist');
  289.             }
  291.             if ( isset($content) && !empty($content) ) {
  292.                 
  293.                 if ( file_exists($this->getParameter('template_dir')."templates/default/pages/page-".$content->getID().".html.twig") ) {
  294.                     $render = "templates/default/pages/page-".$content->getID().".html.twig";
  295.                 } else {
  296.                     $render = "templates/default/pages/page-content.html.twig";
  297.                 }
  298.                 $perPage = 10;
  299.                 if ( $pageNumber != 1 ) {
  300.                     $xPage      = (($pageNumber-1)*$perPage);
  301.                 } else {
  302.                     $xPage      = 0;
  303.                 }
  305.                 return $this->render($render, array(
  306.                     "content"             => $content,
  307.                     "seo" => $this->getDoctrine()->getRepository(Db_Seotable::class)->findSeoDataByPageIDAndType($content->getID(), "Content"),
  308.                     "books" => $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(['TypeID' => 9, "Visible" => "y", "Lang" => $this->lang],["Short" => "DESC"],3),
  309.                     "writes" => $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(['TypeID' => 11, "Visible" => "y", "Lang" => $this->lang],["Short" => "DESC"]),
  310.                     "testimonials" => $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(['TypeID' => 10, "Visible" => "y", "Lang" => $this->lang],["Short" => "DESC"],4),
  311.                     "sliders" => $this->getDoctrine()->getRepository(Db_Contents::class)->findOneBy(['TypeID' => 1, "Visible" => "y", "Lang" => $this->lang],["Short" => "DESC"]),
  312.                     "blogs"    => $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(['TypeID' => 3, "Visible" => "y", "Lang" => $this->lang],["ID" => "DESC"], $perPage, $xPage),
  313.                     "pages" => $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(['TypeID' => 7, "Visible" => "y", "ParentID" => ["", NULL]],["Short" => "ASC"]),
  314.                     "subcontents" => $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(["Visible" => "y", "ParentID" => $content->getId()],["Short" => "ASC"]),
  315.                     "actualPage" => $pageNumber,
  316.                 ));
  318.             } else {
  320.                 return $this->render('templates/default/pages/404.html.twig', array(
  321.                     "content" => $content,
  322.                     "pages"    => $pages,
  323.                 ));
  325.             }
  327.         }
  329.         /**
  330.         * @Route("/cimkek/{urlName}/oldal/{pageNumber}", name="pages-tags")
  331.         */
  333.         public function getTagsElement(Security $security, $urlName, $pageNumber, Request $request) {
  335.             //Beállítjuk az adott oldalt header adatait, hogy ne cacheljen.
  336.             header("Expires: 0");
  337.             header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
  338.             header("Cache-Control: no-store, no-cache, must-revalidate");
  339.             header("Cache-Control: post-check=0, pre-check=0", false);
  340.             header("Pragma: no-cache");
  342.             $content     = $this->getDoctrine()->getRepository(Db_Contents::class)->findOneBy(['UrlName' => "tudastar"]);
  343.             $tag = $this->getDoctrine()->getRepository(Db_Biketypes::class)->findOneBy(["UrlName" => $urlName]);
  344.             if ( !$content ) {
  345.                 throw $this->createNotFoundException('The page does not exist');
  346.             }
  348.             if ( isset($content) && !empty($content) ) {
  349.                 
  350.                 $render = "templates/default/pages/page-tags.html.twig";
  351.                 $fullPage = count($this->getDoctrine()->getRepository(Db_Contents::class)->findByBlogsAndCategoryByTagsAll($tag->getNameHU()));
  353.                 return $this->render($render, array(
  354.                     "content"             => $content,
  355.                     "pages"    => $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(['TypeID' => 7, "Visible" => "y", "ParentID" => ["", NULL]],["Short" => "ASC"]),
  356.                     "seo" => $this->getDoctrine()->getRepository(Db_Seotable::class)->findSeoDataByPageIDAndType($content->getID(), "Content"),
  357.                     "bases" => $this->getDoctrine()->getRepository(Db_Contents::class)->findByBlogsAndCategoryByTags($tag->getNameHU(), $pageNumber),
  358.                     "tags" => $this->getDoctrine()->getRepository(Db_Biketypes::class)->findBy(['Visible' => "y"]),
  359.                     "actualPage" => $pageNumber,
  360.                     "tag" => $tag,
  361.                     "fullPage" => ceil($fullPage/10),
  362.                 ));
  364.             } else {
  366.                 return $this->render('templates/default/pages/404.html.twig', array(
  367.                     "content" => $content,
  368.                     "pages"    => $pages,
  369.                 ));
  371.             }
  373.         }
  375.         /**
  376.         * @Route("/kulcsszo/{urlName}/oldal/{pageNumber}", name="pages-keyword")
  377.         */
  379.         public function getKeywordElement(Security $security, $urlName, $pageNumber, Request $request) {
  381.             //Beállítjuk az adott oldalt header adatait, hogy ne cacheljen.
  382.             header("Expires: 0");
  383.             header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
  384.             header("Cache-Control: no-store, no-cache, must-revalidate");
  385.             header("Cache-Control: post-check=0, pre-check=0", false);
  386.             header("Pragma: no-cache");
  388.             $content     = $this->getDoctrine()->getRepository(Db_Contents::class)->findOneBy(['UrlName' => "tudastar"]);
  389.             
  390.             if ( !$content ) {
  391.                 throw $this->createNotFoundException('The page does not exist');
  392.             }
  394.             if ( isset($content) && !empty($content) ) {
  395.                 
  396.                 $render = "templates/default/pages/page-keywords.html.twig";
  397.                 $fullPage = count($this->getDoctrine()->getRepository(Db_Contents::class)->findByBlogsAndCategoryByKeywordAll($urlName));
  399.                 return $this->render($render, array(
  400.                     "content"             => $content,
  401.                     "pages"    => $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(['TypeID' => 7, "Visible" => "y", "ParentID" => ["", NULL]],["Short" => "ASC"]),
  402.                     "seo" => $this->getDoctrine()->getRepository(Db_Seotable::class)->findSeoDataByPageIDAndType($content->getID(), "Content"),
  403.                     "bases" => $this->getDoctrine()->getRepository(Db_Contents::class)->findByBlogsAndCategoryByKeyword($urlName, $pageNumber),
  404.                     "tags" => $this->getDoctrine()->getRepository(Db_Biketypes::class)->findBy(['Visible' => "y"]),
  405.                     "actualPage" => $pageNumber,
  406.                     "tag" => array("UrlName" => $urlName),
  407.                     "fullPage" => ceil($fullPage/10),
  408.                 ));
  410.             } else {
  412.                 return $this->render('templates/default/pages/404.html.twig', array(
  413.                     "content" => $content,
  414.                     "pages"    => $pages,
  415.                 ));
  417.             }
  419.         }
  421.         /**
  422.         * @Route("/kereses/{urlName}/oldal/{pageNumber}", name="pages-keyword-per-page")
  423.         */
  425.         public function getSearchPagePerPage(Security $security, $urlName, $pageNumber, Request $request) {
  427.             //Beállítjuk az adott oldalt header adatait, hogy ne cacheljen.
  428.             header("Expires: 0");
  429.             header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
  430.             header("Cache-Control: no-store, no-cache, must-revalidate");
  431.             header("Cache-Control: post-check=0, pre-check=0", false);
  432.             header("Pragma: no-cache");
  434.             $content     = $this->getDoctrine()->getRepository(Db_Contents::class)->findOneBy(['UrlName' => "tudastar"]);
  435.             
  436.             if ( !$content ) {
  437.                 throw $this->createNotFoundException('The page does not exist');
  438.             }
  440.             if ( isset($content) && !empty($content) ) {
  441.                 
  442.                 $render = "templates/default/pages/page-search.html.twig";
  443.                 $fullPage = count($this->getDoctrine()->getRepository(Db_Contents::class)->findByBlogsAndCategoryBySearchAll($urlName));
  445.                 return $this->render($render, array(
  446.                     "content"             => $content,
  447.                     "pages"    => $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(['TypeID' => 7, "Visible" => "y", "ParentID" => ["", NULL]],["Short" => "ASC"]),
  448.                     "seo" => $this->getDoctrine()->getRepository(Db_Seotable::class)->findSeoDataByPageIDAndType($content->getID(), "Content"),
  449.                     "bases" => $this->getDoctrine()->getRepository(Db_Contents::class)->findByBlogsAndCategoryBySearch($urlName, $pageNumber),
  450.                     "tags" => $this->getDoctrine()->getRepository(Db_Biketypes::class)->findBy(['Visible' => "y"]),
  451.                     "actualPage" => $pageNumber,
  452.                     "tag" => array("UrlName" => $urlName),
  453.                     "fullPage" => ceil($fullPage/10),
  454.                 ));
  456.             } else {
  458.                 return $this->render('templates/default/pages/404.html.twig', array(
  459.                     "content" => $content,
  460.                     "pages"    => $pages,
  461.                 ));
  463.             }
  465.         }
  467.         /**
  468.         * @Route("/kereses/blog/{urlName}/oldal/{pageNumber}", name="pages-keyword-per-page-blog")
  469.         */
  471.         public function getSearchPagePerPageBlog(Security $security, $urlName, $pageNumber, Request $request) {
  473.             //Beállítjuk az adott oldalt header adatait, hogy ne cacheljen.
  474.             header("Expires: 0");
  475.             header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
  476.             header("Cache-Control: no-store, no-cache, must-revalidate");
  477.             header("Cache-Control: post-check=0, pre-check=0", false);
  478.             header("Pragma: no-cache");
  480.             $content     = $this->getDoctrine()->getRepository(Db_Contents::class)->findOneBy(['UrlName' => "blog"]);
  481.             
  482.             if ( !$content ) {
  483.                 throw $this->createNotFoundException('The page does not exist');
  484.             }
  486.             if ( isset($content) && !empty($content) ) {
  487.                 
  488.                 $render = "templates/default/pages/page-search-blog.html.twig";
  489.                 $fullPage = count($this->getDoctrine()->getRepository(Db_Contents::class)->findByBlogBySearchAll($urlName));
  490.                 if ( $this->security->getUser() ) {
  491.                     $pages =  $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(['TypeID' => 7, "Visible" => "y", "ParentID" => ["", NULL]],["Short" => "ASC"]);
  492.                 } else {
  493.                     $pages =  $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(['TypeID' => 7, "Visible" => "y", "ParentID" => ["", NULL], "OnlyWithLogin" => "n"],["Short" => "ASC"]);
  494.                 }
  495.                 return $this->render($render, array(
  496.                     "content"             => $content,
  497.                     "pages" => $pages,
  498.                     "seo" => $this->getDoctrine()->getRepository(Db_Seotable::class)->findSeoDataByPageIDAndType($content->getID(), "Content"),
  499.                     "blogs" => $this->getDoctrine()->getRepository(Db_Contents::class)->findByBlogBySearchAllByPage($urlName, $pageNumber),
  500.                     "tags" => $this->getDoctrine()->getRepository(Db_Biketypes::class)->findBy(['Visible' => "y"]),
  501.                     "actualPage" => $pageNumber,
  502.                     "urlName" => $urlName,
  503.                     "fullPage" => ceil($fullPage/10),
  504.                     "postCategories" => $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(['TypeID' => 14, "Visible" => "y", "Lang" => $this->lang],["Short" => "DESC"]),
  505.                 ));
  507.             } else {
  509.                 return $this->render('templates/default/pages/404.html.twig', array(
  510.                     "content" => $content,
  511.                     "pages"    => $pages,
  512.                 ));
  514.             }
  516.         }
  518.         /**
  519.         * @Route("/cikk-kategoria/{urlName}/oldal/{pageNumber}", name="pages-category-per-page-blog")
  520.         */
  522.         public function getCategoryPagePerPageBlog(Security $security, $urlName, $pageNumber, Request $request) {
  524.             //Beállítjuk az adott oldalt header adatait, hogy ne cacheljen.
  525.             header("Expires: 0");
  526.             header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
  527.             header("Cache-Control: no-store, no-cache, must-revalidate");
  528.             header("Cache-Control: post-check=0, pre-check=0", false);
  529.             header("Pragma: no-cache");
  531.             $content     = $this->getDoctrine()->getRepository(Db_Contents::class)->findOneBy(['UrlName' => "blog"]);
  532.             
  533.             if ( !$content ) {
  534.                 throw $this->createNotFoundException('The page does not exist');
  535.             }
  537.             if ( isset($content) && !empty($content) ) {
  538.                 $searchContent = $this->getDoctrine()->getRepository(Db_Contents::class)->findOneBy(['UrlName' => $urlName]);
  539.                 $render = "templates/default/pages/page-keyword-blog.html.twig";
  540.                 $fullPage = count($this->getDoctrine()->getRepository(Db_Contents::class)->findBy(['TypeID' => 3, "Visible" => "y", "Lang" => $this->lang, "ParentID" => $searchContent->getId()],["Short" => "DESC"]));
  541.                 $perPage = 10;
  542.                 if ( $pageNumber != 1 ) {
  543.                     $xPage      = (($pageNumber-1)*$perPage);
  544.                 } else {
  545.                     $xPage      = 0;
  546.                 }
  547.                 
  548.                 return $this->render($render, array(
  549.                     "content"             => $content,
  550.                     "pages"    => $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(['TypeID' => 7, "Visible" => "y", "ParentID" => ["", NULL]],["Short" => "ASC"]),
  551.                     "seo" => $this->getDoctrine()->getRepository(Db_Seotable::class)->findSeoDataByPageIDAndType($content->getID(), "Content"),
  552.                     "blogs" => $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(['TypeID' => 3, "Visible" => "y", "Lang" => $this->lang, "ParentID" => $searchContent->getId()],["Short" => "DESC"], $perPage, $xPage),
  554.                     "tags" => $this->getDoctrine()->getRepository(Db_Biketypes::class)->findBy(['Visible' => "y"]),
  555.                     "actualPage" => $pageNumber,
  556.                     "urlName" => $urlName,
  557.                     "fullPage" => ceil($fullPage/10),
  558.                     "postCategories" => $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(['TypeID' => 14, "Visible" => "y", "Lang" => $this->lang],["Short" => "DESC"]),
  559.                 ));
  561.             } else {
  563.                 return $this->render('templates/default/pages/404.html.twig', array(
  564.                     "content" => $content,
  565.                     "pages"    => $pages,
  566.                 ));
  568.             }
  570.         }
  571.         /**
  572.         * @Route("/{asd}/{fgh}", name="pages-a-b")
  573.         */
  575.         public function Atiranyitaszvegrehogymehessekhaza(Security $security, $asd, $fgh, Request $request) {
  577.             return $this->redirect("/", 301);
  579.         }
  581.         /**
  582.         * @Route("/{y}/{m}/{d}/{urlName}", name="pages-old-blog")
  583.         */
  585.         public function getOldBlog(Security $security, $urlName, Request $request) {
  587.             $content     = $this->getDoctrine()->getRepository(Db_Contents::class)->findOneBy(['UrlName' => $urlName]);
  588.             if ( !$content ) {
  589.                 return $this->redirect("/", 301);
  590.             } else {
  591.                 header("Expires: 0");
  592.                 header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
  593.                 header("Cache-Control: no-store, no-cache, must-revalidate");
  594.                 header("Cache-Control: post-check=0, pre-check=0", false);
  595.                 header("Pragma: no-cache");
  596.                 
  597.                 return $this->redirect("/".$urlName);
  598.             }
  600.         }
  602.         /**
  603.         * @Route("/{y}/{m}/{d}/{urlName}/feed", name="pages-old-blog-feed")
  604.         */
  606.         public function getOldBlogFeed(Security $security, $urlName, Request $request) {
  608.             $content     = $this->getDoctrine()->getRepository(Db_Contents::class)->findOneBy(['UrlName' => $urlName]);
  609.             if ( !$content ) {
  610.                 return $this->redirect("/", 301);
  611.             } else {
  612.                 header("Expires: 0");
  613.                 header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
  614.                 header("Cache-Control: no-store, no-cache, must-revalidate");
  615.                 header("Cache-Control: post-check=0, pre-check=0", false);
  616.                 header("Pragma: no-cache");
  617.                 
  618.                 return $this->redirect("/".$urlName);
  619.             }
  621.         }
  622.        
  624.         public function getMenuSubsByID($id) {
  626.             //Lekérdezzük a "Főmenühöz" tartozó aloldalakat.
  627.             if ( $this->security->getUser() ) {
  629.                 $pages     = $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(["Visible" => "y", "ParentID" => $id]);
  630.             } else {
  631.                 $pages     = $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(["Visible" => "y", "ParentID" => $id, "OnlyWithLogin" => "n"]);
  632.             }
  633.             
  634.             //Amennyiben találunk aloldalt a szülőhöz továbblépünk a html generáláshoz.
  635.             if ( isset($pages) && !empty($pages) ) {
  636.                 //A $html változó elkészítése és alap értékének beállítása.
  637.                 $html     = '<ul>'; 
  638.                 //Végigjárjuk a visszakapott aloldalakat.
  639.                 foreach ( $pages as $page ) {
  641.                     
  642.                     if ( $this->lang == "HU" ) {
  643.                         $pageName = $page->getTitle();
  644.                     } elseif ($this->lang == "EN") {
  645.                         $pageName = $page->getTitleEN();
  646.                     } else {
  647.                         $pageName = $page->getTitle();
  648.                     }
  649.                     //Minden aloldalhoz legeneráljuk a megfelelő html sort.
  650.                     
  651.                     $subPages     = $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(["Visible" => "y", "ParentID" => $page->getID()]);
  652.                     if ( $subPages ) {
  653.                         if ( $page->getOnlyWithLogin() == "y" ) {
  654.                             if ( $this->security->getUser() ) {
  655.                                 $html .= '<li class="dropdown"><a href="/'.$page->getUrlName().'">'.$pageName.'</a>';
  656.                             } else {
  657.                                 $html .= '<li class="dropdown">';
  658.                             }
  659.                         } else {
  660.                             $html .= '<li class="dropdown"><a href="/'.$page->getUrlName().'">'.$pageName.'</a>';
  661.                         }
  662.                         
  663.                     } else {
  664.                         if ( $page->getOnlyWithLogin() == "y" ) {
  665.                             if ( $this->security->getUser() ) {
  666.                                 $html .= '<li><a href="/'.$page->getUrlName().'">'.$pageName.'</a>';
  667.                             } else {
  668.                                 $html .= '';
  669.                             }
  670.                         } else {
  671.                             $html .= '<li><a href="/'.$page->getUrlName().'">'.$pageName.'</a>';
  672.                         }
  673.                         
  674.                     }
  675.                     
  676.                     //Visszatérünk a funkcióba az aloldal ID értékével. Erre azért van szükség, hogy lefusson a funkció az almenüpont almenüire is.
  677.                     //Ez a művelet ismétlődik egészen addig, amíg el nem fogynak az aloldalak aloldalai.
  678.                     $subMenus = $this->getMenuSubsByID($page->getID());
  679.                     //A legenerált html kódot átadjuk egy változóba.
  680.                     //Ha a változó nem üres akkor a $subMenu objektum getContent változóját lekérjük. Csak erre az egy értékre van szükségünk.
  681.                     if ( isset($subMenus) && !empty($subMenus) ) {
  682.                         //A $html változóhoz hozzáadjuk a $subMenu->getContent() értékét. Ez az érték önmagában egy html kódot tartalmaz az eddigiek alapján.
  683.                         $html .= $subMenus->getContent();
  684.                     } else {
  685.                         //Amennyiben üres a $subMenu változó lezárjuk az előző generált listát.
  686.                         $html .= "</li>";
  687.                     }
  688.                     
  689.                 }    
  690.                 //Lezárjuk a megnyitott ul-t.
  691.                 $html .= '</ul>';
  694.             } else {
  695.                 //Amennyiben egyáltalán nicns aloldala a főmenünek a generált $html változó üres.
  696.                 $html = "";
  697.             }
  698.             //Visszatérünk a teljesen legenerált $html változóval, majd kiíratjuk a menübe.
  699.             return new Response($html);
  700.             
  703.         }
  706.         /**
  707.         * @Route("/cookies/set-pagination-cookie", name="set-pagination-cookie")
  708.         */
  709.         public function setPaginationCookie(Request $request, AuthenticationUtils $authenticationUtils, Security $security)
  710.         {
  712.             if ( isset($_POST) && !empty($_POST) ) {
  714.                 setcookie("paginationCookie", $_POST['pageCount'], time() + (86400 * 30), "/"); 
  716.             }
  718.             die();
  719.             
  720.         }
  722.         /**
  723.         * @Route("/cookies/start-user-cookie", name="cookies-start-user-cookie")
  724.         */
  725.         public function startUserCookie(Request $request, AuthenticationUtils $authenticationUtils, Security $security)
  726.         {
  727.             
  728.             if ( isset($_COOKIE['orderCookieId']) && !empty($_COOKIE['orderCookieId']) ) {
  729.                 $cookieID = $_COOKIE['orderCookieId'];
  730.                 
  731.             } else {
  732.                 $cookieID = rand(0, 99999).md5(uniqid());
  733.                 
  734.             }
  735.             setcookie("orderCookieId", $cookieID, time() + (86400 * 30) * 30, "/");
  736.             return new Response($cookieID);
  738.             
  739.         }
  741.         
  742.         public function getSettingsByID(Request $request, AuthenticationUtils $authenticationUtils, Security $security, $id)
  743.         {
  744.             
  745.             $settings = $this->getDoctrine()->getRepository(St_Settings::class)->find($id);
  747.             return new Response($settings->getSettingsValue());
  749.             
  750.         }
  752.         public function getPagesByContentTypeID(Request $request, AuthenticationUtils $authenticationUtils, Security $security, $id)
  753.         {
  754.             
  755.             $perpage = 10;
  756.             $contents = count($this->getDoctrine()->getRepository(Db_Contents::class)->findBy(["TypeID" => $id]));
  758.             return new Response(ceil($contents/$perpage));
  761.             
  762.         }
  764.         
  766.         public function getContentBySubcontent(Request $request, AuthenticationUtils $authenticationUtils, Security $security, $id)
  767.         {
  768.             
  769.             $content = $this->getDoctrine()->getRepository(Db_Contents::class)->find($id);
  770.             $array = array();
  771.             if ( $content ) {
  772.                 $array = array(
  773.                     "name" => $content->getTitle(),
  774.                     "urlName" => $content->getUrlName(),
  775.                 );
  776.             }
  777.             
  779.             return new Response(json_encode($array));
  781.             
  782.         }
  784.         public function getAllContentByKeywords(Request $request, AuthenticationUtils $authenticationUtils, Security $security, $id)
  785.         {
  786.             
  787.             $contents = $this->getDoctrine()->getRepository(Db_Contents::class)->findByBlogsAndCategoryBySearchAllByPage($id);
  789.             $array = array();
  790.             $i = 0;
  791.             foreach($contents as $content) {
  792.                 if ( $content ) {
  793.                     $array[$i] = array(
  794.                         "name" => $content->getTitle(),
  795.                         "urlName" => $content->getUrlName(),
  796.                         "content" => $content->getShortText(),
  797.                     );
  798.                     $i++;
  799.                 }
  800.                 
  801.             }
  802.             
  804.             return new Response(json_encode($array));
  806.             
  807.         }
  809.         private function StrReplaceKeywrods($search, $replace, $subject)
  810.         {
  811.             $search = '/\b'.preg_quote($search, '/').'\b/';
  812.             return preg_replace($search, $replace, $subject, 1);
  813.         }
  815.     }