src/Controller/OrderController.php line 29

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\Category;
  6. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  7. use Symfony\Component\HttpFoundation\Response;
  8. use Symfony\Component\Routing\Annotation\Route;
  9. use App\Repository\CategoryRepository;
  10. use App\Repository\ProductRepository;
  11. use Symfony\Component\HttpFoundation\Request;
  13. class OrderController extends AbstractController
  14. {
  15.     private $categoryRepository;
  16.     private $productRepository;
  18.     public function __construct(
  19.         CategoryRepository $categoryRepository,
  20.         ProductRepository $productRepository
  21.     )
  22.     {
  23.         $this->categoryRepository = $categoryRepository;
  24.         $this->productRepository = $productRepository;
  25.     }
  26.     /**
  27.      * @Route("/order", name="app_order")
  28.      */
  29.     public function index(Request $request): Response
  30.     {
  31.         // Obtener filtros del request
  32.         $search = $request->query->get('search');
  33.         $category = $request->query->get('category');
  34.         $maxPrice = $request->query->get('price');
  36.         // Obtener el precio máximo de los productos
  37.         $highestPriceProduct = $this->productRepository->findOneBy([], ['price' => 'DESC']);
  38.         $maxPriceLimit = ($highestPriceProduct ? ($highestPriceProduct->getPrice() / 100) + 1 : 100);
  40.         // Construir la consulta
  41.         $queryBuilder = $this->productRepository->createQueryBuilder('p');
  43.         // Unir con la tabla de categorías
  44.         if ($category) {
  45.             $queryBuilder->join('p.categories', 'c')
  46.                         ->andWhere('c.id = :category')
  47.                         ->setParameter('category', $category);
  48.         }
  50.         if ($search) {
  51.             $queryBuilder->andWhere('p.name LIKE :search')
  52.                         ->setParameter('search', '%' . $search . '%');
  53.         }
  55.         if ($maxPrice) {
  56.             $queryBuilder->andWhere('p.price <= :maxPrice')
  57.                         ->setParameter('maxPrice', ($maxPrice * 100));
  58.         }
  60.         $products = $queryBuilder->getQuery()->getResult();
  61.         $categories = $this->categoryRepository->findAll();
  63.         return $this->render('order/index.html.twig', [
  64.             'products' => $products,
  65.             'categories' => $categories,
  66.             'max_price' => $maxPriceLimit,
  67.         ]);
  68.     }
  69. }