src/Flexy/FrontBundle/Controller/VendorController.php line 19

Open in your IDE?
  1. <?php
  3. namespace App\Flexy\FrontBundle\Controller;
  5. use App\Flexy\FrontBundle\Repository\ProductFrontRepository;
  6. use App\Flexy\ProductBundle\Repository\ProductRepository;
  7. use App\Flexy\ShopBundle\Entity\Vendor\Vendor;
  8. use Doctrine\ORM\EntityManagerInterface;
  9. use Knp\Component\Pager\PaginatorInterface;
  10. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  11. use Symfony\Component\HttpFoundation\Request;
  12. use Symfony\Component\HttpFoundation\Response;
  13. use Symfony\Component\Routing\Annotation\Route;
  15. #[Route('/shop/vendors')]
  16. class VendorController extends AbstractController
  17. {
  18.     #[Route('/single-vendor/{id}', name: 'single_vendor')]
  19.     public function single(
  20.         Vendor $vendor,
  21.     ProductFrontRepository $productFrontRepository,
  22.     EntityManagerInterface $em, 
  23.     PaginatorInterface $paginator, 
  24.     Request $request
  25.     ): Response
  26.     {
  28.         $dql   = "SELECT product FROM App\Flexy\ShopBundle\Entity\Product\Product product LEFT  JOIN product.vendor vendor WHERE vendor.id =  ".$vendor->getId()." AND  product.isPublished = TRUE";
  29.         $query = $em->createQuery($dql);
  30.         
  32.         $pagination = $paginator->paginate(
  33.             $query, /* query NOT result */
  34.             $request->query->getInt('page', 1), /*page number*/
  35.             10 /*limit per page*/
  36.         );
  39.         return $this->render('@Flexy\FrontBundle/templates/vendors/singleVendor.html.twig', [
  40.             'vendor' => $vendor,
  41.             'products'=>$pagination
  43.         ]);
  44.     }
  45. }