src/Controller/BlogController.php line 33

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\Blog;
  6. use App\Entity\BlogTagBlog;
  7. use App\Form\BlogFilterClientType;
  8. use App\Repository\BlogRepository;
  9. use App\Service\SearchService;
  10. use App\Util\Search\MyCriteriaParam;
  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('/blog')]
  19. class BlogController extends AbstractController
  20. {
  21.     private $entityManager;
  22.     private $blogRepository;
  23.     
  26.     public function __construct(EntityManagerInterface $entityManager, BlogRepository $blogRepository)
  27.     {
  28.         $this->entityManager = $entityManager;
  29.         $this->blogRepository = $blogRepository;
  30.     }
  32.     #[Route('/', name: 'app_blog_index')]
  33.     public function index(Request $request, PaginatorInterface $paginator, SearchService $searchService): Response
  34.     {
  35.         $error = null;
  36.         $page = $request->query->get('page', 1);
  37.         $limit = 9;
  38.         $criteria = [
  39.             ['prop' => 'categorie.id', 'col' => 'id', 'alias' => 'c'],
  40.             ['prop' => 'search', 'col' => "concat(concat(coalesce(b.description, ''), ' '), b.titre)", 'alias' => null, 'op' => 'LIKE']
  41.         ];
  43.         $filter = [];
  44.         
  45.         $form = $this->createForm(BlogFilterClientType::class, $filter, [
  46.             'method' => 'GET'
  47.         ]);
  48.         $form->handleRequest($request);
  49.         $filter = $form->getData();
  51.         $qb = $this->entityManager
  52.             ->createQueryBuilder();
  53.         
  55.         $query = $qb
  56.             ->select('b')
  57.             ->from(Blog::class, 'b')
  58.             ->join('b.categorie', 'c')
  59.             ->join('b.auteur', 'a')
  60.         ;  
  62.         $where =  $searchService->getWhere($filter, new MyCriteriaParam($criteria, 'b'));   
  63.         $query->andwhere($where["where"]." and b.statut != 0 ");
  65.         if(isset($filter['tags']) && count($filter['tags']) > 0){
  66.             $tagIdArray = BlogTagBlog::generateTagIdArray($filter['tags']);
  68.             $sqb =  $this->entityManager
  69.             ->createQueryBuilder();
  70.             $query->andWhere(
  71.                 $qb->expr()->exists(
  72.                     $sqb->select('bt2')
  73.                     ->from(BlogTagBlog::class, 'bt2')
  74.                     ->join('bt2.tag', 't2')
  75.                     ->join('bt2.blog', 'b2')
  76.                     ->andWhere('b2.id = b.id')
  77.                     ->andWhere('bt2.statut != 0')
  78.                     ->andWhere($sqb->expr()->in('t2.id', $tagIdArray))
  79.                 )
  80.             );
  81.         }
  82.         
  84.         $searchService->setAllParameters($query, $where["params"]);
  85.         $searchService->addOrderBy($query, $filter, ['sort' => 'b.datePublication', 'direction' => 'desc']);
  87.         $blogList = $paginator->paginate(
  88.             $query,
  89.             $page,
  90.             $limit
  91.         );
  93.         // $recentBlog = $this->blogRepository->getRecentBlog(3);
  95.         return $this->render('blog/blog.html.twig', [
  96.             'error' => $error,
  97.             'blogList' => $blogList,
  98.             'form' => $form->createView(),
  99.             // 'recentBlog' => $recentBlog
  100.         ]);
  101.     }
  103.     #[Route('/{slugCat}/{slugTitle}/{id}', name: 'app_blog_details')]
  104.     public function details(Blog $blog, Request $request): Response
  105.     {
  106.         $error = null;
  107.         $form = $this->createForm(BlogFilterClientType::class, null, [
  108.             'method' => 'GET'
  109.         ]);
  110.         
  111.         $recentBlog = $this->blogRepository->getRecentBlog(5);
  112.         $relatedBlog = $this->blogRepository->getRelatedBlog(3, $blog->getId());
  114.         return $this->render('blog/blog-details.html.twig', [
  115.             'error' => $error,
  116.             'blog' => $blog,
  117.             'form' => $form->createView(),
  118.             'recentBlog' => $recentBlog,
  119.             'relatedBlog' => $relatedBlog
  120.         ]);
  121.     }
  122. }