src/Flexy/FrontBundle/Controller/CategoryProductController.php line 85

Open in your IDE?
  1. <?php
  3. namespace App\Flexy\FrontBundle\Controller;
  5. use App\Flexy\ShopBundle\Entity\Product\CategoryProduct;
  6. use App\Flexy\ProductBundle\Repository\CategoryProductRepository;
  7.  
  8. use App\Flexy\ShopBundle\Repository\Product\ProductRepository;
  9. use App\Flexy\ShopBundle\Entity\Brand;
  10. use App\Flexy\ShopBundle\Entity\Product\ProductShop;
  11. use Doctrine\ORM\EntityManagerInterface;
  12. use Knp\Component\Pager\PaginatorInterface;
  13. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  14. use Symfony\Component\HttpFoundation\Request;
  15. use Symfony\Component\HttpFoundation\Response;
  16. use Symfony\Component\Routing\Annotation\Route;
  18. #[Route('/shop')]
  19. class CategoryProductController extends AbstractController
  20. {
  21.     #[Route('/category-product/{id}', name: 'single_category_product')]
  22.     public function singleProduct(
  23.         CategoryProduct $categoryProduct,
  24.         EntityManagerInterface $em, 
  25.         PaginatorInterface $paginator, 
  26.         Request $request
  27.         ): Response
  28.     {
  30.         $dql   = "SELECT product FROM App\Flexy\ShopBundle\Entity\Product\Product product LEFT OUTER JOIN product.categoriesProduct categorie WhERE categorie.id =  ".$categoryProduct->getId()." AND  product.isPublished = TRUE";
  31.         $query = $em->createQuery($dql);
  32.         
  33.           
  34.         $pagination = $paginator->paginate(
  35.             $query, /* query NOT result */
  36.             $request->query->getInt('page', 1), /*page number*/
  37.             10 /*limit per page*/
  38.         );
  40.         if( $categoryProduct->getId() == 75)  {
  42.             return $this->render('@Flexy\FrontBundle/templates/food/PageFood.html.twig', [
  43.                 'categoryProduct' => $categoryProduct, 
  44.     
  45.             ]);
  47.         }else{
  49.         return $this->render('@Flexy\FrontBundle/templates/categories/singleCategoryProduct.html.twig', [
  50.             'categoryProduct' => $categoryProduct,
  51.             "products"=>$pagination
  53.         ]);
  54.     }
  56.     }
  58.     
  59.         #[Route('/brand-product/{id}', name: 'single_brand_product')]
  60.         public function singleBrand(
  61.             Brand $brand,
  62.             EntityManagerInterface $em, 
  63.             PaginatorInterface $paginator, 
  64.             Request $request
  65.             ): Response
  66.         {
  67.     
  68.             $dql   = "SELECT product FROM App\Flexy\ShopBundle\Entity\Product\Product product LEFT OUTER JOIN product.brand brand WhERE brand.id =  ".$brand->getId()." AND  product.isPublished = TRUE";
  69.             $query = $em->createQuery($dql);
  70.             
  71.     
  72.             $pagination = $paginator->paginate(
  73.                 $query, /* query NOT result */
  74.                 $request->query->getInt('page', 1), /*page number*/
  75.                 10 /*limit per page*/
  76.             );
  77.             return $this->render('@Flexy\FrontBundle/templates/brand/singleBrandProduct.html.twig', [
  78.                 'brand' => $brand,
  79.                 "products"=>$pagination
  80.     
  81.             ]);
  82.         }
  84.         #[Route('/category-announce/{id}', name: 'announce_category_product')]
  85.         public function singleCategory(
  86.             CategoryProduct $categoryProduct,
  87.             EntityManagerInterface $em, 
  88.             ProductRepository $productRepository,
  89.             PaginatorInterface $paginator, 
  90.             Request $request
  91.             ): Response
  92.         {
  93.     
  94.             $dql   = "SELECT product FROM App\Flexy\ShopBundle\Entity\Product\Product product WhERE product.parentCategory =  ".$categoryProduct->getId()."   AND  product.isPublished = TRUE";
  95.             $query = $em->createQuery($dql);
  96.             
  97.             
  98.     
  99.             $pagination = $paginator->paginate(
  100.                 $query, /* query NOT result */
  101.                 $request->query->getInt('page', 1), /*page number*/
  102.                 10 /*limit per page*/
  103.             );
  104.             return $this->render('@Flexy\FrontBundle/templates/categories/announceCategoryProduct.html.twig', [
  105.                 'categoryProduct' =>  $productRepository->findBy(["id"=>$categoryProduct->getId()]),              
  106.                 "products"=>$pagination
  107.     
  108.             ]);
  109.         }
  111.     
  112. }