src/Controller/DefaultController.php line 364

  1. <?php
  3. namespace App\Controller;
  5. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  6. use Symfony\Component\Routing\Annotation\Route;
  7. use Symfony\Component\HttpFoundation\Request;
  8. use Symfony\Component\HttpFoundation\Response;
  9. use Sensio\Bundle\FrameworkExtraBundle\Configuration\ParamConverter;
  10. use Symfony\Component\Mailer\MailerInterface;
  11. use Symfony\Bridge\Twig\Mime\TemplatedEmail;
  12. use Symfony\Component\Mime\Email;
  13. use Symfony\Component\Mime\Address;
  14. use OlaSoft\Common;
  15. use App\Entity\Subscribers;
  16. use App\Entity\Services;
  17. use App\Entity\ServicesCategories;
  18. use App\Entity\Opportunities;
  19. use App\Entity\OpportunitiesCategories;
  20. use App\Entity\Articles;
  21. use App\Entity\ArticlesCategories;
  22. use App\Entity\Structures;
  23. use App\Entity\StructuresCategories;
  24. use App\Entity\FAQ;
  25. use App\Entity\FAQCategories;
  26. use App\Entity\Projects;
  27. use App\Entity\Resources;
  28. use App\Entity\ResourcesCategories;
  29. use App\Entity\Pages;
  30. use App\Entity\Partners;
  31. use App\Entity\Banners;
  32. use App\Entity\Videos;
  33. use App\Entity\VideosCategories;
  34. use App\Entity\Messages;
  35. use App\Entity\Members;
  36. use App\Entity\Events;
  37. use App\Form\MessagesType;
  38. use App\Form\SubscribersType;
  40. use Doctrine\Persistence\ManagerRegistry;
  43. class DefaultController extends AbstractController
  44. {
  45.     public function __construct(ManagerRegistry $doctrine){
  46.         $this->doctrine =  $doctrine;
  47.     }
  49.     private $doctrine;
  51.     public function getDoctrine()
  52.     {
  53.         return $this->doctrine;
  54.     }
  56.     /**
  57.      * @Route("/", name="home")
  58.      */
  59.     public function index()
  60.     {
  61.         $em = $this->getDoctrine()->getManager();
  63.         $role1 = $em->getRepository(Pages::class)->findOneBy(['id'=>2],[]);
  64.         $role2 = $em->getRepository(Pages::class)->findOneBy(['id'=>3],[]);
  65.         $role3 = $em->getRepository(Pages::class)->findOneBy(['id'=>4],[]);
  66.         $banners = $em->getRepository(Banners::class)->findBy(['isEnabled'=>1], ['id'=>'desc'],2);
  67.         $projects = $em->getRepository(Projects::class)->findBy(['isEnabled'=>1], ['id'=>'desc'],3);
  68.         $articles = $em->getRepository(Articles::class)->findBy(['isEnabled'=>1], ['date'=>'desc'], 3);
  69.         $services = $em->getRepository(Services::class)->findBy(['isEnabled'=>1], ['id'=>'asc'], 3);
  70.         $events = $em->getRepository(Events::class)->findBy(['isEnabled'=>1], ['startDate'=>'desc'], 3);
  71.         $emplois =  $em->getRepository(Opportunities::class)->createQueryBuilder('o')
  72.             ->leftjoin('o.category','c')
  73.             ->where('o.isEnabled = 1 and c.id = 1')
  74.             ->select('o')->addSelect('c')->setMaxResults(3)
  75.             ->getQuery()->getResult();
  76.         $avis =  $em->getRepository(Opportunities::class)->createQueryBuilder('o')
  77.             ->leftjoin('o.category','c')
  78.             ->where('o.isEnabled = 1 and c.id = 2')
  79.             ->select('o')->addSelect('c')->setMaxResults(3)
  80.             ->getQuery()->getResult();
  81.         return $this->render('Default/index.html.twig',[
  82.             'role1' => $role1,
  83.             'role2' => $role2,
  84.             'role3' => $role3,
  85.             'banners' => $banners,
  86.             'projects' => $projects,
  87.             'articles' => $articles,
  88.             'services' => $services,
  89.             'emplois' => $emplois,
  90.             'avis' => $avis,
  91.             'events' => $events,
  92.         ]);
  93.     }
  95.     /**
  96.      * @Route("/sitemap.xml", name="sitemap", defaults={"xml"=true, "_format"="xml"})
  97.      */
  98.     public function menu($activeMenu = null, $isFooter = false, $xml = false)
  99.     {
  100.         $em = $this->getDoctrine()->getManager();
  101.         $articlesCats = $em->getRepository(ArticlesCategories::class)->findBy(['isEnabled'=>1]);
  102.         $opportunitiesCats = $em->getRepository(OpportunitiesCategories::class)->findBy(['isEnabled'=>1]);
  103.         $resourcesCats = $em->getRepository(ResourcesCategories::class)->findAll();
  104.         $videosCats = $em->getRepository(VideosCategories::class)->findBy(['isEnabled'=>1]);
  106.         return $this->render($xml ? 'Default/sitemap.xml.twig' : ($isFooter ? 'Default/footer.html.twig' : 'Default/menu.html.twig'),[
  107.             'articlesCats'=>$articlesCats,
  108.             'opportunitiesCats'=>$opportunitiesCats,
  109.             'resourcesCats'=>$resourcesCats,
  110.             'videosCats'=>$videosCats,
  111.             'activeMenu'=>$activeMenu,
  112.         ]);
  113.     }
  115.     /**
  116.      * @Route("/opportunites/", name="opportunities")
  117.      * @Route("/opportunites/{cat}/", name="opportunities-cat")
  118.      */
  119.     public function opportunites(Request $request, $offset = 1, $cat = null)
  120.     {
  121.         $offset = $request->get('offset') ?? 1;
  122.         $keyword = $request->get('q');
  123.         $offset--;
  124.         $limit = 60;
  125.         $params = [];
  126.         $of = $offset*$limit;
  127.         $em = $this->getDoctrine()->getManager();
  128.         $cat = $cat ? $em->getRepository(OpportunitiesCategories::class)->findOneBySlug($cat) : null;
  130.         $query =  $em->getRepository(Opportunities::class)->createQueryBuilder('o')
  131.             ->leftjoin('o.category','c')
  132.             ->where('o.isEnabled = 1');
  134.         if($cat) {
  135.             $query = $query->andWhere('c.id = '.$cat->getId());
  136.             $params['cat'] = $cat->getSlug();
  137.         }
  139.         if($keyword) $query = $query->andWhere('(o.title like :k or o.description like :k)')
  140.             ->setParameter('k','%'.$keyword.'%');
  142.         $count = $query->select('count(o.id)')->getQuery()->getResult()[0][1];
  143.         $list = $query->select('o')->addSelect('c')->setMaxResults($limit)->setFirstResult($of)->getQuery()->getResult();
  145.         return $this->render('Default/opportunities.html.twig',[
  146.             'list'=>$list,
  147.             'count'=>$count,
  148.             'cat'=>$cat,
  149.             'params'=>$params,
  150.             'table_limit'=>$limit,
  151.             'offset'=>$offset,
  152.             'keyword'=>$keyword,
  153.         ]);
  154.     }
  156.     /**
  157.      * @Route("/opportunite/{id}/{slug}/", name="opportunity")
  158.      */
  159.     public function opportunite(Opportunities $item, $slug = null)
  160.     {
  161.         $em = $this->getDoctrine()->getManager();
  162.         $list = $em->getRepository(Opportunities::class)->createQueryBuilder('o')
  163.             ->select('o')->where('o.isEnabled = 1')
  164.             ->getQuery()->getResult();
  165.         return $this->render('Default/opportunity.html.twig',[
  166.             'item'=>$item,
  167.             'list'=>$list,
  168.         ]);
  169.     }
  171.     /**
  172.      * @Route("/services/", name="services")
  173.      * @Route("/services/{cat}/", name="services-cat")
  174.      */
  175.     public function services(Request $request, $cat = null)
  176.     {
  177.         $em = $this->getDoctrine()->getManager();
  178.         $cat = $cat ? $em->getRepository(ServicesCategories::class)->findOneBySlug($cat) : null;
  179.         $groups = $em->getRepository(ServicesCategories::class)->findBy(['isEnabled'=>1], ['id'=>'asc']);
  181.         $offset = $request->get('offset') ?? 1;
  182.         $keyword = $request->get('q');
  183.         $offset--;
  184.         $limit = 50;
  185.         $params = [];
  186.         $of = $offset*$limit;
  187.         $list = $em->getRepository(Services::class)->findBy(['isEnabled'=>1],[],$limit,$of);
  188.         $count = $em->getRepository(Services::class)->count(['isEnabled'=>1]);
  190.         $query =  $em->getRepository(Services::class)->createQueryBuilder('s')
  191.             ->leftjoin('s.category','c')
  192.             ->where('s.isEnabled = 1');
  194.         if($cat) {
  195.             $query = $query->andWhere('c.id = '.$cat->getId());
  196.             $params['cat'] = $cat->getSlug();
  197.         }
  199.         if($keyword) $query = $query->andWhere('(s.title like :k or s.description like :k or s.content like :k or s.cost like :k or s.time like :k or s.department like :k)')
  200.             ->setParameter('k','%'.$keyword.'%');
  202.         $count = $query->select('count(s.id)')->getQuery()->getResult()[0][1];
  203.         $list = $query->select('s')->addSelect('c')->setMaxResults($limit)->setFirstResult($of)->getQuery()->getResult();
  205.         return $this->render('Default/services.html.twig',[
  206.             'list'=>$list,
  207.             'groups'=>$groups,
  208.             'cat'=>$cat,
  209.             'params'=>$params,
  210.             'count'=>$count,
  211.             'table_limit'=>$limit,
  212.             'offset'=>$offset,
  213.             'keyword'=>$keyword,
  214.         ]);
  215.     }
  217.     /**
  218.      * @Route("/service/{id}/{slug}/", name="service", requirements={"id": "\d+"})
  219.      * @Route("/service/{id}/", requirements={"id": "\d+"})
  220.      */
  221.     public function service(Services $service, $slug = null)
  222.     {
  223.         // if(!$service->getIsEnabled() && !$this->isGranted('ROLE_USER'))
  224.             // return $this->redirectToRoute('services');
  226.         $em = $this->getDoctrine()->getManager();
  227.         $list = $em->getRepository(Services::class)->createQueryBuilder('s')
  228.             ->leftjoin('s.category','c')
  229.             ->andWhere('s.id <> '.$service->getId())
  230.             ->andWhere('c.id = '.$service->getCategory()->getId())
  231.             ->andWhere('s.isEnabled = 1')
  232.             ->getQuery()->getResult();
  233.         return $this->render('Default/service.html.twig',[
  234.             'service'=>$service,
  235.             'list'=>$list,
  236.         ]);
  238.     }
  239.     
  240.     
  241.     /**
  242.      * @Route("/projets/", name="projects")
  243.      */
  244.     public function projects(Request $request)
  245.     {
  246.         $offset = $request->get('offset') ?? 1;
  247.         $keyword = $request->get('q');
  248.         $offset--;
  249.         $limit = 50;
  250.         $of = $offset*$limit;
  251.         $em = $this->getDoctrine()->getManager();
  252.         $list = $em->getRepository(Projects::class)->findBy(['isEnabled'=>1],[],$limit,$of);
  253.         $count = $em->getRepository(Projects::class)->count(['isEnabled'=>1]);
  255.         $query =  $em->getRepository(Projects::class)->createQueryBuilder('p')
  256.             ->where('p.isEnabled = 1');
  258.         if($keyword) $query = $query->andWhere('(p.name like :k or p.description like :k or p.details like :k)')
  259.             ->setParameter('k','%'.$keyword.'%');
  261.         $count = $query->select('count(p.id)')->getQuery()->getResult()[0][1];
  262.         $list = $query->select('p')->setMaxResults($limit)->setFirstResult($of)->getQuery()->getResult();
  264.         return $this->render('Default/projects.html.twig',[
  265.             'list'=>$list,
  266.             'count'=>$count,
  267.             'table_limit'=>$limit,
  268.             'offset'=>$offset,
  269.             'keyword'=>$keyword,
  270.         ]);
  271.     }
  273.     /**
  274.      * @Route("/projet/{id}/{slug}/", name="project")
  275.      */
  276.     public function project(Projects $project)
  277.     {
  278.         $em = $this->getDoctrine()->getManager();
  279.         $list = $em->getRepository(Projects::class)->createQueryBuilder('p')
  280.             // ->leftjoin('a.sector','s')
  281.             ->leftjoin('p.album','aa')
  282.             ->orderBy('p.name','ASC')
  283.             ->andWhere('p.id <> '.$project->getId())
  284.             ->andWhere('p.isEnabled = 1')
  285.             ->setMaxResults(4)
  286.             ->getQuery()
  287.             ->getResult();
  288.         return $this->render('Default/project.html.twig',[
  289.             'project'=>$project,
  290.             'list'=>$list,
  291.         ]);
  292.     }
  294.     /**
  295.      * @Route("/articles/", name="articles")
  296.      * @Route("/articles/{offset}/", name="articles-page", requirements={"offset": "\d+"})
  297.      * @Route("/articles/{cat}/", name="articles-cat")
  298.      * @Route("/articles/{cat}/{offset}/", name="articles-cat-page", requirements={"offset": "\d+"})
  299.      */
  300.     public function articles($offset = 1, $cat = null)
  301.     {
  302.         $offset--;
  303.         $limit = 30;
  304.         $of = $offset*$limit;
  305.         $params = [];
  306.         $em = $this->getDoctrine()->getManager();
  307.         $cat = $cat ? $em->getRepository(ArticlesCategories::class)->findOneBySlug($cat) : null;
  308.         $list = $em->getRepository(Articles::class)->createQueryBuilder('a')
  309.             ->leftjoin('a.banner','b')
  310.             ->leftjoin('a.category','c')
  311.             ->leftjoin('a.type','t')
  312.             ->leftjoin('a.album','aa')
  313.             ->leftjoin('a.biblio','ab')
  314.             ->orderBy('a.date','DESC')
  315.             ->andWhere("a.date <= '".(new \DateTime())->format('Y-m-d H:i:s')."'")
  316.             ->andWhere('a.isEnabled = 1')
  317.         ;
  319.         if($cat) {
  320.             $list = $list->andWhere('c.id = '.$cat->getId());
  321.             $params['cat'] = $cat->getSlug();
  322.         }
  324.         $count = $list->select('count(distinct(a.id))')->getQuery()->getResult()[0][1];
  325.         $list = $list->select('a')
  326.             ->setMaxResults($limit)
  327.             ->setFirstResult($of)
  328.             ->getQuery()->getResult();
  330.         return $this->render('Default/articles.html.twig',[
  331.             'list'=>$list,
  332.             'cat'=>$cat,
  333.             'count'=>$count,
  334.             'table_limit'=>$limit,
  335.             'offset'=>$offset,
  336.             'params'=>$params
  337.         ]);
  338.     }
  340.     /**
  341.      * @Route("/article/{id}/{slug}/", name="article", requirements={"id": "\d+"})
  342.      * @Route("/article/{id}/", requirements={"id": "\d+"})
  343.      */
  344.     public function article(Articles $article, $slug = null)
  345.     {
  346.         if(!$article->getIsEnabled() && !$this->isGranted('ROLE_USER'))
  347.             return $this->redirectToRoute('articles');
  348.         if($article->getURL())
  349.             return $this->redirect($article->getURL());
  351.         $em = $this->getDoctrine()->getManager();
  352.         $list = $em->getRepository(Articles::class)->createQueryBuilder('a')
  353.             ->leftjoin('a.banner','b')
  354.             ->leftjoin('a.category','c')
  355.             ->leftjoin('a.type','t')
  356.             ->leftjoin('a.album','aa')
  357.             ->leftjoin('a.biblio','ab')
  358.             ->orderBy('a.date','DESC')
  359.             // ->andWhere('a.id <> '.$article->getId())
  360.             ->andWhere("a.date <= '".(new \DateTime())->format('Y-m-d H:i:s')."'")
  361.             ->andWhere('a.isEnabled = 1')
  362.             ->setMaxResults(6)
  363.             ->getQuery()
  364.             ->getResult();
  365.         return $this->render('Default/article.html.twig',[
  366.             'article'=>$article,
  367.             'list'=>$list,
  368.         ]);
  370.     }
  372.     /**
  373.      * @Route("/evenements/", name="events")
  374.      */
  375.     public function events(Request $request)
  376.     {
  377.         $offset = $request->get('offset') ?? 1;
  378.         $keyword = $request->get('q');
  379.         $offset--;
  380.         $limit = 50;
  381.         $of = $offset*$limit;
  382.         $em = $this->getDoctrine()->getManager();
  384.         $query =  $em->getRepository(Events::class)->createQueryBuilder('e')
  385.             ->where('e.isEnabled = 1')
  386.             ->orderBy('e.startDate','desc');
  388.         if($keyword) $query = $query->andWhere('(e.name like :k or e.startDate like :k or e.endDate like :k or e.place like :k)')
  389.             ->setParameter('k','%'.$keyword.'%');
  391.         $count = $query->select('count(e.id)')->getQuery()->getResult()[0][1];
  392.         $list = $query->select('e')->setMaxResults($limit)->setFirstResult($of)->getQuery()->getResult();
  394.         return $this->render('Default/events.html.twig',[
  395.             'list'=>$list,
  396.             'count'=>$count,
  397.             'table_limit'=>$limit,
  398.             'offset'=>$offset,
  399.             'keyword'=>$keyword,
  400.         ]);
  401.     }
  403.     /**
  404.      * @Route("/videos/", name="videos")
  405.      * @Route("/videos/{cat}/", name="videos-cat")
  406.      */
  407.     public function videos($cat = null)
  408.     {
  409.         $em = $this->getDoctrine()->getManager();
  410.         $videos = $em->getRepository(Videos::class)->findBy(['isEnabled'=>1], ['id'=>'desc']);
  411.         return $this->render('Default/videos.html.twig',[
  412.             'list'=>$videos
  413.         ]);
  414.     }
  416.     /**
  417.      * @Route("/video/{id}/", name="video", requirements={"id": "\d+"})
  418.      */
  419.     public function video(Videos $video)
  420.     {
  421.         return $this->render('Default/video.html.twig',[
  422.             'video'=>$video
  423.         ]);
  425.     }
  427.     /**
  428.      * @Route("/structures/", name="structures")
  429.      * @Route("/structures/{slug}/", name="structures-cat")
  430.      */
  431.     public function structures(StructuresCategories $cat = null)
  432.     {
  433.         $em = $this->getDoctrine()->getManager();
  435.         $filter = ['isEnabled' => 1];
  436.         if($cat) $filter['category'] = $cat->getId();
  438.         $list = $em->getRepository(Structures::class)->findBy($filter, ['position'=>'DESC']);
  439.         // $groups = $cat ? null : $em->getRepository(StructuresCategories::class)->findBy(['isEnabled'=>1], ['id'=>'asc']);
  440.         $groups = $em->getRepository(StructuresCategories::class)->findBy(['isEnabled'=>1], ['id'=>'asc']);
  442.         return $this->render('Default/structures.html.twig',[
  443.             'list'=>$list,
  444.             'groups'=>$groups,
  445.             'cat'=>$cat,
  446.         ]);
  447.     }
  449.     /**
  450.      * @Route("/structure/{id}/{slug}/", name="structure")
  451.      */
  452.     public function structure(Structures $struct)
  453.     {
  454.         return $this->render('Default/structure.html.twig',[
  455.             'struct'=>$struct,
  456.         ]);
  457.     }
  460.     /**
  461.      * @Route("/plateformes-services/", name="plateformes-services")
  462.      */
  463.     public function partners(Request $request)
  464.     {
  465.         $offset = $request->get('offset') ?? 1;
  466.         $keyword = $request->get('q');
  467.         $offset--;
  468.         $limit = 50;
  469.         $of = $offset*$limit;
  470.         $em = $this->getDoctrine()->getManager();
  471.         $list = $em->getRepository(Partners::class)->findBy(['isEnabled'=>1],[],$limit,$of);
  472.         $count = $em->getRepository(Partners::class)->count(['isEnabled'=>1]);
  474.         $query =  $em->getRepository(Partners::class)->createQueryBuilder('p')
  475.             ->where('p.isEnabled = 1');
  477.         if($keyword) $query = $query->andWhere('(p.name like :k or p.description like :k or p.website like :k)')
  478.             ->setParameter('k','%'.$keyword.'%');
  480.         $count = $query->select('count(p.id)')->getQuery()->getResult()[0][1];
  481.         $list = $query->select('p')->setMaxResults($limit)->setFirstResult($of)->getQuery()->getResult();
  483.         return $this->render('Default/partners.html.twig',[
  484.             'list'=>$list,
  485.             'count'=>$count,
  486.             'table_limit'=>$limit,
  487.             'offset'=>$offset,
  488.             'keyword'=>$keyword,
  489.         ]);
  490.     }
  493.     /**
  494.      * @Route("/documents/", name="resources")
  495.      * @Route("/documents/{slug}/", name="resources-cat")
  496.      */
  497.     public function resources(Request $request, ResourcesCategories $cat = null)
  498.     {
  499.         $keyword = $request->get('q');
  500.         $offset = $request->get('offset') ?? 1;
  501.         $offset--;
  502.         $limit = 50;
  503.         $of = $offset*$limit;
  504.         $em = $this->getDoctrine()->getManager();
  506.         $query =  $em->getRepository(Resources::class)->createQueryBuilder('r')
  507.             ->leftjoin('r.category','c')
  508.             ->where('r.isEnabled = 1')
  509.             ->orderBy('r.date','desc');
  511.         if($cat) $query = $query->andWhere('c.id = '.$cat->getId())->addOrderBy('r.isImportant','desc');
  512.         if($keyword)
  513.             $query = $query->andWhere('(r.title like :k or r.description like :k or c.label like :k )')
  514.             ->setParameter('k','%'.$keyword.'%');
  516.         $count = $query->select('count(r.id)')->getQuery()->getResult()[0][1];
  517.         $list = $query->select('r')->setMaxResults($limit)->setFirstResult($of)->getQuery()->getResult();
  519.         return $this->render('Default/resources.html.twig',[
  520.             'cat'=>$cat,
  521.             'list'=>$list,
  522.             'count'=>$count,
  523.             'table_limit'=>$limit,
  524.             'offset'=>$offset,
  525.             'keyword'=>$keyword
  526.         ]);
  527.     }
  528. }