src/Controller/Pages/Pages/CategoriesController.php line 244

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Pages\Pages;
  5. use App\Entity\St_Settings;
  6. use App\Entity\Db_Products;
  7. use App\Entity\Gl_Images;
  8. use App\Entity\Db_Categoriesassign;
  9. use App\Entity\Db_Accessories;
  10. use App\Entity\Db_Accesscategory;
  11. use App\Entity\Db_Seotable;
  12. use App\Entity\Db_Categories;
  13. use App\Entity\Db_Cart;
  14. use App\Entity\Db_Contents;
  15. use App\Entity\Db_Accesscategoryassign;
  16. use App\Entity\Db_Categoryaccessassign;
  17. use Symfony\Component\HttpFoundation\Response;
  18. use Symfony\Component\Routing\Annotation\Route;
  19. use Symfony\Bundle\FrameworkBundle\Controller\Controller;    
  20. use Symfony\Component\HttpFoundation\Request;
  21. use Symfony\Component\Security\Core\Security;
  22. use Symfony\Component\HttpFoundation\Session\SessionInterface;
  26.     class CategoriesController extends Controller
  27.     {
  28.         
  30.         
  31.         function __construct(SessionInterface $session)
  32.         {
  33.             
  34.            
  35.             $this->lang = (isset($_COOKIE['langFront']) && !empty($_COOKIE['langFront'])) ? $this->lang = $_COOKIE['langFront'] : $this->lang = "HU";
  36.             $this->session = $session;
  38.             
  40.         }
  42.         /**
  43.         * @Route("/category/set-cookie/{categoryId}", name="set-category-cookie")
  44.         */
  46.         public function setCookie(Security $security, Request $request, $categoryId) {
  47.             $c = $this->getDoctrine()->getRepository(Db_Categories::class)->find($categoryId);
  48.             if ( $request->request->all() ) {
  50.                 setcookie("access", json_encode($request->request->get("access")), time() + (86400 * 30), "/kategoria/".$c->getUrlName()."/oldal/1"); 
  51.                 return $this->redirect("/kategoria/".$c->getUrlName()."/oldal/1");
  52.             } else {
  54.                 setcookie("access", NULL, time() + (86400 * 30), "/kategoria/".$c->getUrlName()."/oldal/1"); 
  55.                 return $this->redirect("/kategoria/".$c->getUrlName()."/oldal/1");
  56.             }
  58.         }
  60.         /**
  61.         * @Route("/search/set-cookie/{urlname}", name="set-search-cookie")
  62.         */
  64.         public function setCookieSearch(Security $security, Request $request, $urlname) {
  65.             
  66.             if ( $request->request->all() ) {
  68.                 setcookie("access", json_encode($request->request->get("access")), time() + (86400 * 30), "/kereso/".$urlname."/oldal/1"); 
  69.                 return $this->redirect("/kereso/".$urlname."/oldal/1");
  70.             } else {
  72.                 setcookie("access", NULL, time() + (86400 * 30), "/kereso/".$urlname."/oldal/1"); 
  73.                 return $this->redirect("/kereso/".$urlname."/oldal/1");
  74.             }
  76.         }
  77.        
  79.         /**
  80.         * @Route("/kategoria/{urlName}/oldal/{actualPage}", name="get-categories-page")
  81.         */
  83.         public function getCategoriesPage(Security $security, $urlName, $actualPage, Request $request) {
  85.             //Beállítjuk az adott oldalt header adatait, hogy ne cacheljen.
  86.             header("Expires: 0");
  87.             header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
  88.             header("Cache-Control: no-store, no-cache, must-revalidate");
  89.             header("Cache-Control: post-check=0, pre-check=0", false);
  90.             header("Pragma: no-cache");
  91.             if ( $request->cookies->get("access") ) {
  92.                 $cookie = $request->cookies->get("access");
  93.             } else {
  94.                 $cookie = NULL;
  95.             }
  97.             $category = $this->getDoctrine()->getRepository(Db_Categories::class)->findOneBy(["UrlName" => $urlName]);
  98.             $products = $this->getDoctrine()->getRepository(Db_Categoriesassign::class)->findByProductAndImagePerPage($actualPage, $category->getID(), $cookie);
  99.             $allProducts = $this->getDoctrine()->getRepository(Db_Categoriesassign::class)->findByProductAndImageAll($category->getID(), $cookie);
  100.             $categories = $this->getDoctrine()->getRepository(Db_Categories::class)->findAllCategoryAndImage();
  101.             $allPage = count($allProducts);
  102.             if ( isset( $_COOKIE['paginationCookie'] ) && !empty($_COOKIE['paginationCookie']) ) {
  103.                 $perPage = $_COOKIE['paginationCookie'];
  104.             } else {
  105.                 $perPage = 20;
  106.             }
  107.             $allPage = ceil($allPage/$perPage);
  108.                $accessArray = array();
  109.                $accessories = $this->getDoctrine()->getRepository(Db_Categoryaccessassign::class)->findBy(["categoryid" => $category->getID()]);
  111.                $i = 0;
  112.                foreach( $accessories as $value ) {
  114.                    $accessArray[$i] = array(
  116.                        "accessCategory" => $value->getAccesscategoryid(),
  117.                        "accessElements" => $this->getDoctrine()->getRepository(Db_Accessories::class)->findBy(["AccessCategory" => $value->getAccesscategoryid()->getID()]),
  119.                    );
  121.                    $i++;
  122.                }
  124.             return $this->render("templates/default/pages/category.html.twig", array(
  126.                 "category" => $category,
  127.                 "seo"=> $this->getDoctrine()->getRepository(Db_Seotable::class)->findSeoDataByPageIDAndType($category->getID(), "Category"),
  128.                 "products" => $products,
  129.                 "categories" => $this->getDoctrine()->getRepository(Db_Categories::class)->findAllCategoryAndImage(),
  130.                 "subCategories"    => $this->getDoctrine()->getRepository(Db_Categories::class)->findBy(["Visible" => "y", "ParentID" => $category->getID()]),
  131.                 "newProducts" => $this->getDoctrine()->getRepository(Db_Categoriesassign::class)->findBy(["CategoryID" => $category->getID()],["ID" => "DESC"],5),
  132.                 "allPage" => $allPage,
  133.                 "actualPage" => $actualPage,
  134.                 "accessArray" => $accessArray,
  135.                 "allProducts" => count($allProducts),
  137.             ));
  139.         }
  141.         /**
  142.         * @Route("/termekek/{urlname}", name="get-product-page")
  143.         */
  145.         public function getProductPage(Security $security, $urlname, Request $request) {
  147.             //Beállítjuk az adott oldalt header adatait, hogy ne cacheljen.
  148.             header("Expires: 0");
  149.             header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
  150.             header("Cache-Control: no-store, no-cache, must-revalidate");
  151.             header("Cache-Control: post-check=0, pre-check=0", false);
  152.             header("Pragma: no-cache");
  153.             
  154.             $product = $this->getDoctrine()->getRepository(Db_Products::class)->findOneBy(["UrlName" => $urlname]);
  155.             if ( $request->cookies->get("related") ) {
  156.                 $array = json_decode($request->cookies->get("related"));
  157.                 if ( !in_array($product->getID(), $array) ) {
  158.                     array_unshift($array, $product->getId());
  159.                     setcookie("related", json_encode($array), time() + ((86400 * 30)*12), "/"); 
  160.                 }
  161.             } else {
  162.                 setcookie("related", json_encode(array()), time() + ((86400 * 30)*12), "/"); 
  163.             }
  164.             if ( isset($_COOKIE['orderCookieId']) && !empty($_COOKIE['orderCookieId']) ) {
  166.                 $cartElements = $this->getDoctrine()->getRepository(Db_Cart::class)->findBy(['CookieID' => $_COOKIE['orderCookieId']]);
  168.             } else {
  169.                 $cartElements = array();
  170.             }
  171.             
  172.             
  173.             $seo = $this->getDoctrine()->getRepository(Db_Seotable::class)->findSeoDataByPageIDAndType($product->getID(), "Product");
  174.             $categories = $this->getDoctrine()->getRepository(Db_Categories::class)->findAllCategoryAndImage();
  175.             $productCategories = $this->getDoctrine()->getRepository(Db_Categoriesassign::class)->findBy(["ProductID" => $product->getID()]);
  176.             $gallery = $this->getDoctrine()->getRepository(Gl_Images::class)->findBy(["ProductID" => $product->getID()]);
  177.             
  178.             $accessories = $this->getDoctrine()->getRepository(Db_Accesscategoryassign::class)->findAllCategoryByProduct($product->getID());
  179.             
  180.             $accessArray = array();
  181.             $i = 0;
  182.             foreach ( $accessories as $value ) {
  184.                 $accessArray[$i] = array(
  186.                     "categoryName" => $value->getCategoryId()->getNameHU(),
  187.                     "accessValues" => $this->getDoctrine()->getRepository(Db_Accesscategoryassign::class)->findBy(["categoryid" => $value->getCategoryId()->getId(),"productid" => $product->getID()]),
  189.                 );
  190.                 $i++;
  191.             }
  192.             $content = new Db_Contents();
  193.             $content->setTitle($product->getNameHU());
  194.             return $this->render("templates/default/pages/product.html.twig", array(
  196.                 "product" => $product,
  197.                 "seo" => $seo,
  198.                 "categories" => $categories,
  199.                 "productCategories" => $productCategories,
  200.                 "gallery" => $gallery,
  201.                 "accessArray" => $accessArray,
  202.                 "cartElements" => $cartElements,
  203.                 "content" => $content,
  204.                 "pages" => $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(['TypeID' => 7, "Visible" => "y", "ParentID" => ["", NULL]],["Short" => "ASC"]),
  207.             ));
  209.         }
  211.         /**
  212.         * @Route("/{categoryUrl}/{urlname}", name="get-product-page-category")
  213.         */
  215.         public function getProductPageCategory(Security $security, $urlname, Request $request, $categoryUrl) {
  217.             //Beállítjuk az adott oldalt header adatait, hogy ne cacheljen.
  218.             header("Expires: 0");
  219.             header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
  220.             header("Cache-Control: no-store, no-cache, must-revalidate");
  221.             header("Cache-Control: post-check=0, pre-check=0", false);
  222.             header("Pragma: no-cache");
  223.             if ($urlname == "biztonsag") {
  224.                 return $this->redirect("/biztonsag");
  225.             }
  226.             $product = $this->getDoctrine()->getRepository(Db_Products::class)->findOneBy(["UrlName" => $urlname]);
  227.             if ( $request->cookies->get("related") ) {
  228.                 $array = json_decode($request->cookies->get("related"));
  229.                 if ( !in_array($product->getID(), $array) ) {
  230.                     array_unshift($array, $product->getId());
  231.                     setcookie("related", json_encode($array), time() + ((86400 * 30)*12), "/"); 
  232.                 }
  233.             } else {
  234.                 setcookie("related", json_encode(array()), time() + ((86400 * 30)*12), "/"); 
  235.             }
  237.             if ( isset($_COOKIE['orderCookieId']) && !empty($_COOKIE['orderCookieId']) ) {
  239.                 $cartElements = $this->getDoctrine()->getRepository(Db_Cart::class)->findBy(['CookieID' => $_COOKIE['orderCookieId']]);
  241.             } else {
  242.                 $cartElements = array();
  243.             }
  244.             $seo = $this->getDoctrine()->getRepository(Db_Seotable::class)->findSeoDataByPageIDAndType($product->getID(), "Product");
  245.             $category = $this->getDoctrine()->getRepository(Db_Categories::class)->findOneBy(["UrlName" => $categoryUrl]);
  246.             $categories = $this->getDoctrine()->getRepository(Db_Categories::class)->findAllCategoryAndImage();
  247.             $productCategories = $this->getDoctrine()->getRepository(Db_Categoriesassign::class)->findBy(["ProductID" => $product->getID()]);
  248.             $gallery = $this->getDoctrine()->getRepository(Gl_Images::class)->findBy(["ProductID" => $product->getID()]);
  249.             
  250.             $accessories = $this->getDoctrine()->getRepository(Db_Accesscategoryassign::class)->findAllCategoryByProduct($product->getID());
  251.             
  252.             $accessArray = array();
  253.             $i = 0;
  254.             foreach ( $accessories as $value ) {
  256.                 $accessArray[$i] = array(
  258.                     "categoryName" => $value->getCategoryId()->getNameHU(),
  259.                     "accessValues" => $this->getDoctrine()->getRepository(Db_Accesscategoryassign::class)->findBy(["categoryid" => $value->getCategoryId()->getId(),"productid" => $product->getID()]),
  261.                 );
  262.                 $i++;
  263.             }
  264.             $content = new Db_Contents();
  265.             $content->setTitle($product->getNameHU());
  267.             return $this->render("templates/default/pages/product.html.twig", array(
  269.                 "product" => $product,
  270.                 "seo" => $seo,
  271.                 "categories" => $categories,
  272.                 "productCategories" => $productCategories,
  273.                 "gallery" => $gallery,
  274.                 "accessArray" => $accessArray,
  275.                 "category" => $category,
  276.                 "cartElements" => $cartElements,
  277.                 "content" => $content,
  278.                 "pages" => $this->getDoctrine()->getRepository(Db_Contents::class)->findBy(['TypeID' => 7, "Visible" => "y", "ParentID" => ["", NULL]],["Short" => "ASC"]),
  280.             ));
  282.         }
  284.         /**
  285.         * @Route("/kereso", name="get-search-page")
  286.         */
  288.         public function getProductSearch(Security $security, Request $request) {
  290.             return $this->redirect("/kereso/".$request->query->get("search")."/oldal/1");
  292.         }
  294.         /**
  295.         * @Route("/kereso/{urlname}/oldal/{actualPage}", name="get-search-page-per-page")
  296.         */
  298.         public function getProductSearchPerPage(Security $security, $urlname, $actualPage, Request $request) {
  300.             //Beállítjuk az adott oldalt header adatait, hogy ne cacheljen.
  301.             header("Expires: 0");
  302.             header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
  303.             header("Cache-Control: no-store, no-cache, must-revalidate");
  304.             header("Cache-Control: post-check=0, pre-check=0", false);
  305.             header("Pragma: no-cache");
  307.             
  308.             if ( $request->cookies->get("access") ) {
  309.                 $cookie = $request->cookies->get("access");
  310.             } else {
  311.                 $cookie = NULL;
  312.             }
  314.             
  315.             $products = $this->getDoctrine()->getRepository(Db_Products::class)->findByProductAndImagePerPageBySearch($actualPage, $urlname, $cookie);
  316.             $allProducts = $this->getDoctrine()->getRepository(Db_Products::class)->findByProductAndImageBySearchAll($urlname, $cookie);
  317.             $categories = $this->getDoctrine()->getRepository(Db_Categories::class)->findAllCategoryAndImage();
  318.             $allPage = count($allProducts);
  319.             if ( isset( $_COOKIE['paginationCookie'] ) && !empty($_COOKIE['paginationCookie']) ) {
  320.                 $perPage = $_COOKIE['paginationCookie'];
  321.             } else {
  322.                 $perPage = 20;
  323.             }
  324.             $allPage = ceil($allPage/$perPage);
  325.                $accessArray = array();
  326.                $accessories = $this->getDoctrine()->getRepository(Db_Accesscategory::class)->findAll();
  327.                $i = 0;
  328.                foreach( $accessories as $value ) {
  330.                    $accessArray[$i] = array(
  332.                        "accessCategory" => $value,
  333.                        "accessElements" => $this->getDoctrine()->getRepository(Db_Accessories::class)->findBy(["AccessCategory" => $value->getID()]),
  335.                    );
  337.                    $i++;
  338.                }
  340.             return $this->render("templates/default/pages/search.html.twig", array(
  342.                 
  343.                 
  344.                 "products" => $products,
  345.                 "categories" => $this->getDoctrine()->getRepository(Db_Categories::class)->findAllCategoryAndImage(),
  346.                 "newProducts" => $this->getDoctrine()->getRepository(Db_Categoriesassign::class)->findBy([],["ID" => "DESC"],5),
  347.                 "allPage" => $allPage,
  348.                 "actualPage" => $actualPage,
  349.                 "accessArray" => $accessArray,
  350.                 "allProducts" => count($allProducts),
  351.                 "urlname" => $urlname,
  353.             ));
  355.         }
  357.         /**
  358.         * @Route("/teszt-cookie/related/{max}", name="get-search-page-related")
  359.         */
  361.         public function getRelatedProducts(Security $security, Request $request, $max) {
  363.             $cookie = $request->cookies->get("related");
  364.             if ( $cookie ) {
  366.                 $array = json_decode($cookie);
  367.                 $inArray = implode(",",$array);
  368.                 $relatedProducts = $this->getDoctrine()->getRepository(Db_Products::class)->getRelatedProducts($inArray, $max); 
  370.             } else {
  371.                 return new Response("Jelenleg nem találhatóak megtekintett termékek!");
  372.             }
  374.         }
  376.     }