src/Controller/DefaultController.php line 52

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  6. use Symfony\Component\HttpFoundation\Response;
  7. use Symfony\Component\Routing\Annotation\Route;
  8. use App\Repository\PagesRepository;
  9. use App\Repository\FormationsRepository;
  10. use App\Repository\VersionsFormationsRepository;
  11. use App\Repository\TypesFormationsRepository;
  12. use App\Repository\TemoignagesRepository;
  13. use App\Repository\LieuFormationsRepository;
  14. use App\Repository\TeamsRepository;
  15. use App\Repository\ContenusRepository;
  16. use App\Repository\SujetsFormationsRepository;
  17. use App\Repository\LogicielsFormationsRepository;
  18. use App\Repository\JobsRepository;
  19. use App\Repository\BusinessUnitRepository;
  20. use App\Repository\AdressesRepository;
  21. use App\Repository\LieuxJobsRepository;
  22. use App\Repository\ActualitesRepository;
  23. use App\Repository\SessionsFormationsRepository;
  24. use App\Repository\DocumentsRepository;
  25. use App\Repository\CategoriesActualitesRepository;
  26. use App\Repository\SectionsRepository;
  27. use App\Repository\CarouselsRepository;
  28. use App\Repository\DictionnaireRepository;
  29. use App\Repository\CertificatsFormationsRepository;
  30. use App\Repository\CriteresFormationsRepository;
  31. use App\Repository\CatalogueRepository;
  32. use App\Repository\CategoriesFormationsRepository;
  37. use Mailjet\Api\Client;
  38. use Mailjet\Resources;
  39. use Symfony\Component\HttpFoundation\RedirectResponse;
  40. use Doctrine\ORM\EntityManagerInterface;
  41. use ReCaptcha\ReCaptcha;
  42. use Symfony\Component\HttpFoundation\Request;
  43. use Spipu\Html2Pdf\Html2Pdf;
  46. class DefaultController extends AbstractController
  47. {
  49.     /**
  50.         * @Route("/", name="app_home")
  51.     */
  52.     public function index( ActualitesRepository $actualitesRepository,SessionsFormationsRepository $sessionsFormationsRepository, FormationsRepository $formationsRepository, CarouselsRepository $carouRepo, DictionnaireRepository $dicoRepo,SectionsRepository $sectionsRepository, PagesRepository $pagesRepository): Response
  53.     {
  54.         $page = $pagesRepository->findOneById(13);
  55.         $nb = count($page->getSections()) +1;
  56.         $sections = $sectionsRepository->findBy(array('Pages'=>13),array('Ordre'=>'asc'));
  57.         $formations = $formationsRepository->findAll();
  60.         $sessions = $sessionsFormationsRepository->findAll();
  62.         $dates = [];
  63.         foreach ($sessions as $session) {
  64.             $dates[] = $session->getDate(); // Supposons que "getDate()" soit la méthode pour récupérer la date.
  65.         }
  69.         $actus = $actualitesRepository->findBy(['Afficher'=>1],['Date'=>'desc'],2);
  70.         $lastActus = $actualitesRepository->findBy(['Afficher'=>1],['Date'=>'desc'],10);
  71.         $lastFormations = $formationsRepository->findBy(['Afficher'=>1], ['Date' => 'desc'], 10);
  72.         return $this->render('default/index.html.twig', [
  73.             'actus' => $actus,
  74.             'lastActus'=>$lastActus,
  75.             'formations' => $formations,
  77.             'sessions' => $sessions,
  78.             'lastFormations' => $lastFormations,
  79.             'sections' => $sections,
  80.             'page'=> $page,
  81.             'ordreMax' =>$nb,
  82.             'carousels' => $carouRepo->findBy(['Contenus'=>367],['Ordre'=>'asc']),
  83.             'dico' => $dicoRepo->findAll(),
  84.             'dates' => $dates
  86.         ]);
  87.     }
  92.     /**
  93.     * @Route("/{locale}/industrialisation", name="app_industrialisation")
  94.     */
  95.     public function industrialisation($locale, Request $request,SectionsRepository $sectionsRepository, PagesRepository $pagesRepository,TemoignagesRepository $temoignagesRepository): Response
  96.     {
  98.         
  100.         $page = $pagesRepository->findOneById(1);
  101.         $nb = count($page->getSections()) +1;
  102.         
  103.         $sections = $sectionsRepository->findBy(array('Pages'=>1),array('Ordre'=>'asc'));
  104.         return $this->render('default/industrialisation.html.twig', [
  105.             'sections' => $sections,
  106.             'page'=> $page,
  107.             'ordreMax' =>$nb,
  108.             'ip' => '90.63.222.84',
  109.             'temoignages'=>$temoignagesRepository->findAll()
  110.         ]);
  111.     }
  113.    
  115.     /**
  116.         * @Route("{locale}/demo", name="demo")
  117.     */
  118.     public function demo(SectionsRepository $sectionsRepository, PagesRepository $pagesRepository, TemoignagesRepository $temoignagesRepository): Response
  119.     {
  121.         $page = $pagesRepository->findOneById(11);
  122.         $nb = count($page->getSections()) +1;
  123.         
  124.         $sections = $sectionsRepository->findBy(array('Pages'=>11),array('Ordre'=>'asc'));
  125.         return $this->render('default/demo.html.twig', [
  126.             'sections' => $sections,
  127.             'page'=> $page,
  128.             'ordreMax' =>$nb,
  129.             'ip' => '90.63.222.84',
  130.             'temoignages'=>$temoignagesRepository->findAll()
  131.         ]);
  132.     }
  135.     /**
  136.         * @Route("/{locale}/formation", name="app_formation")
  137.     */
  138.     public function formation($locale): Response
  139.     {
  140.         return $this->render('default/formation.html.twig', [
  141.             'controller_name' => 'DefaultController',
  142.         ]);
  143.     }
  146.      /**
  147.     * @Route("/cms/digital-manufacturing-services", name="app_digitalManufacturingServicesCms")
  148.     */
  149.     public function app_digitalManufacturingServicesCms(): Response
  150.     {
  152.         return $this->render('default/digitalManufacturingServicesbackup.html.twig', [
  153.             'controller_name' => 'DefaultController',
  154.         ]);
  158.     }
  161.     /**
  162.     * @Route("/{locale}/digital-manufacturing-services", name="app_digitalManufacturingServices")
  163.     */
  164.    
  165.     public function app_digitalManufacturingServices(SectionsRepository $sectionsRepository, PagesRepository $pagesRepository, TemoignagesRepository $temoignagesRepository): Response
  166.     {
  168.         $page = $pagesRepository->findOneById(3);
  169.         $nb = count($page->getSections()) +1;
  170.         
  171.         $sections = $sectionsRepository->findBy(array('Pages'=>3),array('Ordre'=>'asc'));
  172.         return $this->render('default/digitalManufacturingServices.html.twig', [
  173.             'sections' => $sections,
  174.             'page'=> $page,
  175.             'ordreMax' =>$nb,
  176.             'ip' => '90.63.222.84',
  177.             'temoignages'=>$temoignagesRepository->findAll()
  178.         ]);
  180.        
  181.     }
  184.     /**
  185.     * @Route("/cms/presentation-erp", name="app_manufacturingERPCms")
  186.     */
  187.     public function app_manufacturingERP(DocumentsRepository $documentRepository): Response
  188.     {
  189.         $pdfs = $documentRepository->findAll();
  190.         
  191.         return $this->render('default/ERPBackup.html.twig', [
  192.             'pdfs' => $pdfs,
  193.         ]);
  194.     }
  196.     /**
  197.     * @Route("admin/{locale}/presentation-erp", name="app_manufacturingERP")
  198.     */
  199.     
  200.     public function app_manufacturingERPCms( DocumentsRepository $documentRepository, SectionsRepository $sectionsRepository, PagesRepository $pagesRepository, TemoignagesRepository $temoignagesRepository): Response
  201.     {
  202.         $page = $pagesRepository->findOneById(4);
  203.         $nb = count($page->getSections()) +1;
  204.         $pdfs = $documentRepository->findAll();
  206.         $sections = $sectionsRepository->findBy(array('Pages'=>4),array('Ordre'=>'asc'));
  207.         return $this->render('default/manufacturingERP.html.twig', [
  208.             'sections' => $sections,
  209.             'page'=> $page,
  210.             'ordreMax' =>$nb,
  211.             'ip' => '90.63.222.84'  ,
  212.             'pdfs' => $pdfs,
  213.             'temoignages'=>$temoignagesRepository->findAll()
  215.         ]);
  216.     }
  218.     
  219.    /**
  220.         * @Route("admin/{locale}/fonctionnalites-delmiaworks", name="presentationERP")
  221.     */
  222.     public function app_presentationERP(SectionsRepository $sectionsRepository, PagesRepository $pagesRepository, TemoignagesRepository $temoignagesRepository): Response
  223.     {
  225.         $page = $pagesRepository->findOneById(12);
  226.         $nb = count($page->getSections()) +1;
  227.         
  228.         $sections = $sectionsRepository->findBy(array('Pages'=>12),array('Ordre'=>'asc'));
  229.         return $this->render('default/presentationERP.html.twig', [
  230.             'sections' => $sections,
  231.             'page'=> $page,
  232.             'ordreMax' =>$nb,
  233.             'ip' => '90.63.222.84',
  234.             'temoignages'=>$temoignagesRepository->findAll()
  235.         ]);
  236.     }
  239.       /**
  240.         * @Route("/{locale}/base-outils", name="app_baseOutils")
  241.     */
  242.     public function app_baseOutilsCms(SectionsRepository $sectionsRepository, PagesRepository $pagesRepository, TemoignagesRepository $temoignagesRepository): Response
  243.     {
  245.         $page = $pagesRepository->findOneById(5);
  246.         $nb = count($page->getSections()) +1;
  247.         
  248.         $sections = $sectionsRepository->findBy(array('Pages'=>5),array('Ordre'=>'asc'));
  249.         return $this->render('default/baseOutils.html.twig', [
  250.             'sections' => $sections,
  251.             'page'=> $page,
  252.             'ordreMax' =>$nb,
  253.             'ip' => '90.63.222.84'  ,
  254.             'temoignages'=>$temoignagesRepository->findAll(),
  255.             
  256.         ]);
  257.     }
  258.      /**
  259.         * @Route("/cms/base-outils", name="app_baseOutilsCms")
  260.     */
  262.     
  263.     public function app_baseOutils(): Response
  264.     {
  265.         return $this->render('default/base-outil-backup.html.twig', [
  266.             'controller_name' => 'DefaultController',
  267.         ]);
  268.     }
  271.      /**
  272.         * @Route("/{locale}/societe", name="app_societe")
  273.     */
  274.     public function app_societeCms(SectionsRepository $sectionsRepository, PagesRepository $pagesRepository, TemoignagesRepository $temoignagesRepository): Response
  275.     {
  277.         $page = $pagesRepository->findOneById(6);
  278.         $nb = count($page->getSections()) +1;
  280.         $sections = $sectionsRepository->findBy(array('Pages'=>6),array('Ordre'=>'asc'));
  281.         return $this->render('default/societe.html.twig', [
  282.             'sections' => $sections,
  283.             'page'=> $page,
  284.             'ordreMax' =>$nb,
  285.             'ip' => '90.63.222.84'  ,
  286.             'temoignages'=>$temoignagesRepository->findAll()
  287.         ]);
  288.     }
  291.  
  293.      /**
  294.     * @Route("/cms/societe", name="app_societeCms")
  295.     */
  296.    
  297.     public function app_societe(SectionsRepository $sectionsRepository, PagesRepository $pagesRepository, TemoignagesRepository $temoignagesRepository): Response
  298.     {
  299.         $page = $pagesRepository->findOneById(6);
  300.         $nb = count($page->getSections()) +1;
  302.         $sections = $sectionsRepository->findBy(array('Pages'=>6),array('Ordre'=>'asc'));
  303.         return $this->render('default/societeBackup.html.twig', [
  304.             'sections' => $sections,
  305.             'page'=> $page,
  306.             'ordreMax' =>$nb,
  307.             'ip' => '90.63.222.84'  ,
  308.             'temoignages'=>$temoignagesRepository->findAll()
  310.         ]);
  311.     }
  313.      /**
  314.  * @Route("/{locale}/formations", name="formations")
  315.  */
  316. public function formations($locale, CatalogueRepository $catalogueRepository, SessionsFormationsRepository $sessionsFormationsRepository, FormationsRepository $formationsRepository,CertificatsFormationsRepository $certificatsFormations, CriteresFormationsRepository $criteresFormations,VersionsFormationsRepository $versionsFormationsRepository, TypesFormationsRepository $typesFormationsRepository, SujetsFormationsRepository $sujetsFormationsRepository, LogicielsFormationsRepository $logicielsFormationsRepository, Request $request, SectionsRepository $sectionsRepository, PagesRepository $pagesRepository): Response
  317. {
  318.     $page = $pagesRepository->findOneById(14);
  319.     $nb = count($page->getSections()) + 1;
  320.     $sections = $sectionsRepository->findBy(array('Pages' => 14), array('Ordre' => 'asc'));
  321.     $typeTitre = $typesFormationsRepository->findBy(['TitreFr' => 'ASC']);
  323.     // Initialisation du tableau de critères
  324.     $critereFiltre = ['Afficher' => 1];
  326.     // Ajout des critères de filtrage
  327.     if ($request->query->get('version')) {
  328.         $critereFiltre['VersionsFormations'] = $request->query->get('version');
  329.     }
  331.     $typesFormations = $typesFormationsRepository->findAll();
  333.     // Ajoutez le filtre pour le type s'il est spécifié dans la requête
  334.    
  335.     
  337.     if ($request->query->get('sujet')) {
  338.         $critereFiltre['SujetsFormations'] = $request->query->get('sujet');
  339.     }
  341.     if ($request->query->get('logiciel')) {
  342.         $critereFiltre['LogicielsFormations'] = $request->query->get('logiciel');
  343.     }
  345.     if ($request->query->get('formation')) {
  346.         $critereFiltre['TitreFr'] = $request->query->get('formation');
  347.     }
  349.     $sessions = $sessionsFormationsRepository->findAll();
  352.     $dates = [];
  353.     foreach ($sessions as $session) {
  354.         $dates[] = $session->getDate(); // Supposons que "getDate()" soit la méthode pour récupérer la date.
  355.     }
  358.     
  362.     // Requête avec tous les critères
  363.     $formations = $formationsRepository->findBy($critereFiltre, ['Ordre' => 'ASC']);
  364.     $sessionsFormations = $sessionsFormationsRepository->findAll();
  365.     $certificats = $certificatsFormations->findAll();
  366.     $criteres = $criteresFormations->findAll();
  367.     $cataloguesFormations = $catalogueRepository->findAll();
  370.     if ($request->query->has('type')) {
  371.         $selectedTypeId = $request->query->get('type');
  372.     
  373.         // Vérifiez si l'option "Tous les Types" est sélectionnée
  374.         if ($selectedTypeId !== 'all') {
  375.             $formations = $this->filterFormationsByType($formations, (int)$selectedTypeId);
  376.         }
  377.         // Si "Tous les Types" est sélectionné, n'appliquez pas de filtre par type
  378.     }
  379.     
  382.     return $this->render('default/formations.html.twig', [
  383.         'formations' => $formations,
  384.         'cataloguesFormations' => $cataloguesFormations,
  385.         'sessionsFormations' => $sessionsFormations,
  386.         'certificats' => $certificats,
  387.         'criteres' => $criteres,
  388.         'versions' => $versionsFormationsRepository->findBy([], ['TitreFr' => 'ASC']),
  389.         'types' => $typesFormationsRepository->findBy([], ['TitreFr' => 'ASC']),
  390.         'sujets' => $sujetsFormationsRepository->findBy([], ['TitreFr' => 'ASC']),
  391.         'logiciels' => $logicielsFormationsRepository->findBy([], ['TitreFr' => 'ASC']),
  392.         'formation' => $formationsRepository->findBy([], ['TitreFr' => 'ASC']),
  393.         'sections' => $sections,
  394.         'page' => $page,
  395.         'ordreMax' => $nb,
  396.         'formationSelected' => $request->query->get('formation'),
  397.         'ip' => '90.63.222.84',
  398.         'dates' => $dates
  399.     ]);
  400. }
  405. /**
  406.  * Filtre les formations par le type spécifié.
  407.  */
  408. private function filterFormationsByType(array $formations, int $typeId): array
  409. {
  410.     return array_filter($formations, function ($formation) use ($typeId) {
  411.         foreach ($formation->getSessionsFormations() as $session) {
  412.             if ($session->getTypesFormations()->getId() === $typeId) {
  413.                 return true;
  414.             }
  415.         }
  416.         return false;
  417.     });
  418. }
  420.      /**
  421.         * @Route("/{locale}/formations/{ref}", name="detailsFormation")
  422.     */
  423.     public function detailsFormation($locale,FormationsRepository $formationsRepository,SessionsFormationsRepository $sessionsFormationsRepository,  $ref): Response
  424.     {
  426.         $sessions = $sessionsFormationsRepository->findAll();
  427.         
  430.         $dates = [];
  431.         foreach ($sessions as $session) {
  432.             $dates[] = $session->getDate(); // Supposons que "getDate()" soit la méthode pour récupérer la date.
  433.         }
  435.         
  436.         return $this->render('default/detailsFormation.html.twig', [
  437.             'formation' => $formationsRepository->findOneBy(['Reference'=>$ref]),
  438.             'formationsall' => $formationsRepository->findAll(),
  439.             '$dates' => $dates,
  441.            
  442.         ]);
  443.     }
  446.     /**
  447.         * @Route("/{locale}/actualites", name="app_actualites")
  448.     */
  449.     public function actualites(ActualitesRepository $actualitesRepository, CategoriesActualitesRepository $categoriesActualites): Response
  450.     {
  453.         if(isset($_GET['date']))
  454.         {
  456.             if($_GET['date'] == 'mois')
  457.             {
  458.                 $debut = date('Y-m-d',strtotime('- 30 day'));
  459.       
  460.                 $fin = date('Y-m-d');
  461.             }
  462.             if($_GET['date'] == 'annee')
  463.             {
  464.                 $debut = date('Y-m-d',strtotime('- 365 day'));
  465.       
  466.                 $fin = date('Y-m-d');
  467.             }
  468.         }
  469.     
  471.         $last = $actualitesRepository->findBy([],['Date'=>'desc'],1);
  472.         $two = $actualitesRepository->findBy([],['Date'=>'desc'],2,1);
  473.         $all = $actualitesRepository->findBy([],['Date'=>'desc'],10,3);
  475.         if(isset($_GET['categorie']))
  476.         {
  477.             $last = $actualitesRepository->findBy(['CategoriesActualites'=>$_GET['categorie']],['Date'=>'desc'],1);
  478.             $two = $actualitesRepository->findBy(['CategoriesActualites'=>$_GET['categorie']],['Date'=>'desc'],2,1);
  479.             $all = $actualitesRepository->findBy(['CategoriesActualites'=>$_GET['categorie']],['Date'=>'desc'],10,3);
  480.         }
  482.         if(isset($_GET['date']))
  483.         {
  484.             /*$last = $actualitesRepository->findOneBy(['CategoriesActualites'=>$_GET['categorie']],['Date'=>'desc']);
  485.             $two = $actualitesRepository->findBy(['CategoriesActualites'=>$_GET['categorie']],['Date'=>'desc'],2,1);*/
  486.             $last = $actualitesRepository->findDate1($debut,$fin);
  487.             $two = $actualitesRepository->findDate2($debut,$fin);
  488.             $all = $actualitesRepository->findDate($debut,$fin);
  489.         }
  490.         
  491.         
  494.         return $this->render('default/actualites.html.twig', [
  495.             'lasts' => $last,
  496.             'two'=>$two,
  497.             'all'=>$all,
  498.             'cat'=>$categoriesActualites->findBy([], ['TitreFr' => 'ASC'])
  499.         ]);
  500.     }
  503.     /**
  504.      * @Route("/{locale}/actualites/{titre}/{id}", name="actualitesD")
  505.      */
  506.     public function actualitesD(ActualitesRepository $actualitesRepository, $id, SectionsRepository $sectionsRepository): Response
  507.     {
  508.         $actu = $actualitesRepository->findOneBy(['id' => $id]);
  510.         if (!$actu) {
  511.             throw $this->createNotFoundException('Article non trouvé');
  512.         }
  514.         $nb = $actu->getNbVues() + 1;
  515.         $actu->setNbVues($nb);
  516.         $actualitesRepository->add($actu, true);
  518.         $previousActu = $actualitesRepository->findOneBy(['id' => $id - 1]);
  519.         $nextActu = $actualitesRepository->findOneBy(['id' => $id + 1]);
  521.         $vues = $actualitesRepository->findBy([], ['NbVues' => 'desc'], 5);
  527.         
  528.        
  529.         
  530.         $sections = $sectionsRepository->findBy(array('Actualites'=>$actu),array('Ordre'=>'asc'));
  532.         return $this->render('default/detailsActualites.html.twig', [
  533.             'actu' => $actu,
  534.             'previousActu' => $previousActu,
  535.             'nextActu' => $nextActu,
  536.             'vues' => $vues,
  537.             'sections' => $sections,
  538.             'ordreMax' =>$nb
  539.         ]);
  540.     }
  542.     /**
  543.         * @Route("/{locale}/contact", name="app_contact")
  544.     */
  545.     public function contact(AdressesRepository $adressesRepository, TeamsRepository $teams): Response
  546.     {
  547.         return $this->render('default/contact.html.twig', [
  548.             'adresses' => $adressesRepository->findAll(),
  549.             'teams'=>$teams->findBy([],['Ordre'=>'asc'])
  550.         ]);
  551.     }
  554.   /**
  555.  * @Route("/{locale}/join-us", name="app_joinus")
  556.  */
  557. public function joinUs(Request $request, $locale, JobsRepository $JobsRepository, BusinessUnitRepository $businessUnitRepository, LieuxJobsRepository $lieuxJobsRepository): Response
  558. {
  559.     
  560.     $jobsCriteria=[];
  561.     $businessUnits = $businessUnitRepository->findAll();
  562.     $lieux = $lieuxJobsRepository->findAll();
  563.     $jobsListe = $JobsRepository->findAll();
  564.     
  565.     if ($request->query->get('businessUnit')) {
  566.         $jobsCriteria['BusinessUnit'] = $request->query->get('businessUnit');
  567.     }
  568.     if ($request->query->get('lieu')) {
  569.         $jobsCriteria['LieuxJobs'] = $request->query->get('lieu');
  570.     }
  571.     if ($request->query->get('job')) {
  572.         $jobsCriteria['TitreFr'] = $request->query->get('job');
  573.     }
  575.     $jobs = $JobsRepository->findByCriteria($jobsCriteria);
  577.     return $this->render('default/joinUs.html.twig', [
  578.         'jobs' => $jobs,
  579.         'businessUnit' => $businessUnits,
  580.         'lieux' => $lieux,
  581.         'locale' => $locale,
  582.         'jobsL' => $jobsListe
  583.         
  584.     ]);
  585. }
  588.     /**
  589.         * @Route("/{locale}/join-us/{ref}", name="app_joinusD")
  590.     */
  591.     public function app_joinusD(JobsRepository $JobsRepository, BusinessUnitRepository $businessUnitRepository, LieuxJobsRepository $lieuxJobsRepository, $ref): Response
  592.     {
  594.         $jobs=$JobsRepository->findOneBy(['Reference'=>$ref]);
  596.         return $this->render('default/joinUsDetails.html.twig', [
  597.             'jobs' => $jobs,
  598.            
  599.         ]);
  601.     }
  602.     /**
  603.      * @Route("/sendFormJoin", name="sendFormJoin")
  604.      */
  605.     public function sendJoinUs(JobsRepository $JobsRepository,Request $request): Response
  606.     {
  608.         $jobs = $JobsRepository->findOneBy(['id'=>$_POST['job']]);
  610.         $nom = $_POST['nom'];
  611.        $prenom = $_POST['prenom'];
  612.         $email = $_POST['email'];
  613.         $telephone = $_POST['telephone'];
  614.          $motivation = $_POST['motivation'];
  616.          $total_count = count($_FILES['cv']['name']);
  617.          // Loop through every file
  618.          for( $i=0 ; $i < $total_count ; $i++ ) {
  619.         
  620.             $extension = pathinfo($_FILES['cv']['name'][$i], PATHINFO_EXTENSION);
  621.             //The temp file path is obtained
  622.             $tmpFilePath = $_FILES['cv']['tmp_name'][$i];
  623.             //A file path needs to be present
  624.             if ($tmpFilePath != ""){
  625.                //Setup our new file path
  626.                $newFilePath = "./uploadFiles/" . $_FILES['cv']['name'][$i];
  627.                //File is uploaded to temp dir
  629.                $nb =  rand();
  630.                $newfilename = time().$nb.'.'.$extension;
  631.               move_uploaded_file($_FILES['cv']['tmp_name'][$i], '/var/www/vhosts/deamonerp.fr/httpdocs/cpi2/public/uploads/cv/'.$newfilename);
  637.               $lien = $newfilename; 
  638.               $content = fread(fopen('uploads/cv/'.$lien, "r"), filesize('uploads/cv/'.$lien));
  639.               $doc['ContentType'] = "text/plain";
  640.               $doc['Filename'] = $lien;
  641.               $doc['Base64Content'] = base64_encode($content);
  642.               $docs[$i] = $doc;
  645.              
  646.             }
  647.          }
  649.        
  657.         
  658.         if(isset($_POST['confidentialite']))
  659.         {
  660.         $confidentialite = 'on';
  661.         }
  662.         else
  663.         {
  664.            $confidentialite = 'off';
  665.         }
  668.           // Verify reCAPTCHA
  669.           $recaptchaResponse = $request->request->get('g-recaptcha-response');
  670.           $recaptcha = new \ReCaptcha\ReCaptcha('6Lf0RGEnAAAAANFz2iFW62hx189DTGl08c3fYnw4');
  671.               $recaptchaResult = $recaptcha->verify($recaptchaResponse);
  672.   
  673.               if (!$recaptchaResult->isSuccess()) {
  674.                   // La vérification reCAPTCHA a échoué. Redirigez vers le formulaire avec un message d'erreur.
  675.                   return $this->redirectToRoute('app_joinusD', ['ref' => $jobs->getReference(), 'recaptcha_error' => 'true']);
  676.               }
  679.         $subject = "CPI - Candidature";
  680.         $message = $this->renderView(
  681.            'emails/joinus.html.twig',
  682.            [
  683.                'nom' => strtoupper($nom), 
  684.                'prenom' => strtoupper($prenom), 
  685.                'email'=>$email, 
  686.                'telephone'=>$telephone, 
  687.                'motivation'=>$motivation, 
  688.                'flexCheckDefault'=>$confidentialite, 
  689.                'titre'=>$jobs->getTitreFr(),
  690.                'reference'=>$jobs->getReference()        
  691.                ]
  692.        );
  694.        
  695.        $userEmail = $_POST['email'];
  696.         $mj = new \Mailjet\Client('61722507da55a4f5570d0ad1a5b1435e', '01d31913ab5c0fd4586d08d17d114b8c',true,['version' => 'v3.1']); 
  697.         $body = [
  698.             'Messages' => [
  699.                 [
  700.                     'From' => [
  701.                         'Email' => "recrutement@cpi.lu",
  702.                         'Name' => "CPI"
  703.                     ],
  704.                     'To' => [
  705.                         [
  706.                             'Email' => 'recrutement@cpi.lu',
  707.                         ]
  708.                         
  709.                     ],
  710.                     'Bcc' => [  
  711.                         [
  712.                             'Email' => 'damien@piranha.lu',
  713.                         ],
  714.                         [
  715.                             'Email' => 'thomasbregler@protonmail.com',
  716.                         ],
  717.                         [
  718.                             'Email' => $userEmail,
  719.                         ],
  720.                     ],
  721.                     'Attachments' => $docs,
  722.                     'Subject' => $subject,
  723.                     'HTMLPart' => $message,
  724.                 ]
  725.             ]
  726.         ];
  727.         
  728.         $response = $mj->post(Resources::$Email, ['body' => $body]);
  729.         $response->success();
  731.     
  734.         return $this->redirectToRoute('app_joinusD', ['ref'=>$jobs->getReference(),'send'=>'success'], Response::HTTP_SEE_OTHER);
  739.      }
  742.     /**
  743.      * @Route("/sendFormContact", name="sendFormContact")
  744.      */
  745.       public function sendFormContact(Request $request,$locale): Response
  746.    {
  747.         
  751.          $nom = $_POST['nom'];
  752.          $prenom = $_POST['prenom'];
  753.          $societe = $_POST['societe'];
  754.         
  755.          $bp = $_POST['bp'];
  756.          $batiment = $_POST['batiment'];
  757.          $cp = $_POST['cp'];
  758.          $ville = $_POST['ville'];
  759.          $pays = $_POST['pays'];
  760.          $email = $_POST['email'];
  761.          $telephone = $_POST['telephone'];
  762.          $message = $_POST['message'];
  763.          if(isset($_POST['flexCheckDefault']))
  764.          {
  765.          $flexCheckDefault = 'on';
  766.          }
  767.          else
  768.          {
  769.             $flexCheckDefault = 'off';
  770.          }
  773.        // Verify reCAPTCHA
  774.        $recaptchaResponse = $request->request->get('g-recaptcha-response');
  775.        $recaptcha = new \ReCaptcha\ReCaptcha('6Lf0RGEnAAAAANFz2iFW62hx189DTGl08c3fYnw4');
  776.         $recaptchaResult = $recaptcha->verify($recaptchaResponse);
  778.         if (!$recaptchaResult->isSuccess()) {
  779.             // La vérification reCAPTCHA a échoué. Redirigez vers le formulaire avec un message d'erreur.
  780.             return $this->redirectToRoute('app_contact', ['recaptcha_error' => 'true']);
  781.         }
  783.       
  785.         
  787.          
  788.          $subject = "CPI - Demande de contact / Contact request";
  789.          $message = $this->renderView(
  790.             'emails/contact.html.twig',
  791.             [
  792.                 'nom' => strtoupper($nom), 
  793.                 'prenom' => strtoupper($prenom), 
  794.                 'societe'=>$societe,  
  795.                 'bp'=>$bp, 
  796.                 'cp'=>$cp, 
  797.                 'ville'=>$ville, 
  798.                 'pays'=>$pays, 
  799.                 'email'=>$email, 
  800.                 'telephone'=>$telephone, 
  801.                 'message'=>$message, 
  802.                 'batiment'=>$batiment, 
  803.                 'flexCheckDefault'=>$flexCheckDefault, 
  804.                
  805.                 ]
  806.         );
  808.       
  809.         $userEmail = $_POST['email'];
  810.          $mj = new \Mailjet\Client('61722507da55a4f5570d0ad1a5b1435e', '01d31913ab5c0fd4586d08d17d114b8c',true,['version' => 'v3.1']);
  811.          $body = [
  812.             'Messages' => [
  813.                 [
  814.                     'From' => [
  815.                         'Email' => "info@cpi.lu",
  816.                         'Name' => "CPI"
  817.                     ],
  818.                     'To' => [
  819.                         [
  820.                             'Email' => 'info@cpi.lu', 
  821.                             
  822.                         ]
  823.                        
  824.                      
  825.                     ],
  826.                     'Bcc' => [  
  827.                         [
  828.                             'Email' => 'damien@piranha.lu',
  829.                         ],
  830.                         [
  831.                             'Email' => 'thomasbregler@protonmail.com',
  832.                         ],
  833.                         [
  834.                             'Email' => $userEmail,
  835.                         ],
  836.                     ],
  837.            
  838.                     'Subject' => $subject,
  839.                     'HTMLPart' => $message,
  840.                 ]
  841.             ]
  842.         ];
  843.          $response = $mj->post(Resources::$Email, ['body' => $body]);
  844.          $response->success();
  846.          return $this->redirectToRoute('app_contact', ['locale' => $locale, 'send' => 'success'], Response::HTTP_SEE_OTHER);
  847.         }
  851.     /**
  852.      * @Route("/sendFormDetailsFormation", name="sendFormDetailsFormation")
  853.      */
  854.     public function sendFormDetailsFormation(SessionsFormationsRepository $sessionsFormationsRepository,Request $request) : Response
  855.     {
  856.          $session = $_POST['session'];
  857.         $nom = $_POST['nom'];
  858.          $prenom = $_POST['prenom'];
  859.          $societe = $_POST['societe'];
  860.          $email = $_POST['email'];
  861.          $telephone = $_POST['telephone'];
  862.          $remarque = $_POST['remarque'];
  863.          if(isset($_POST['confidentialite']))
  864.          {
  865.          $confidentialite = 'on';
  866.          }
  867.          else
  868.          {
  869.             $confidentialite = 'off';
  870.          }
  873.          $sess = $sessionsFormationsRepository->findOneById($session);
  875.          $subject = "CPI - Demande de formation / Training application";
  876.          $message = $this->renderView(
  877.             'emails/formation.html.twig',
  878.             [
  879.                 'nom' => strtoupper($nom), 
  880.                 'prenom' => strtoupper($prenom), 
  881.                 'societe'=>$societe, 
  882.                 'email'=>$email, 
  883.                 'telephone'=>$telephone, 
  884.                 'remarque'=>$remarque, 
  885.                 'flexCheckDefault'=>$confidentialite, 
  886.                 'titre'=>$sess->getFormations()->getTitreFr(),
  887.                 'reference'=>$sess->getFormations()->getReference(),
  888.                 'session'=>$sess->getDate()        
  889.                 ]
  890.         );
  891.  
  893.          // Verify reCAPTCHA
  894.         $recaptchaResponse = $request->request->get('g-recaptcha-response');
  895.         $recaptcha = new \ReCaptcha\ReCaptcha('6Lf0RGEnAAAAANFz2iFW62hx189DTGl08c3fYnw4');
  896.             $recaptchaResult = $recaptcha->verify($recaptchaResponse);
  898.             if (!$recaptchaResult->isSuccess()) {
  899.                 // La vérification reCAPTCHA a échoué. Redirigez vers le formulaire avec un message d'erreur.
  900.                 return $this->redirectToRoute('detailsFormation', ['ref' => $sess->getFormations()->getReference(), 'recaptcha_error' => 'true']);
  901.             }
  902.       
  903.          $userEmail = $_POST['email'];
  904.          $mj = new \Mailjet\Client('61722507da55a4f5570d0ad1a5b1435e', '01d31913ab5c0fd4586d08d17d114b8c',true,['version' => 'v3.1']);
  905.          $body = [
  906.             'Messages' => [
  907.                 [
  908.                     'From' => [
  909.                         'Email' => "formations@cpi.lu",
  910.                         'Name' => "CPI"
  911.                     ],
  912.                     'To' => [
  913.                         [
  914.                             'Email' => 'formations@cpi.lu',
  915.                             
  916.                         ]
  917.                        
  918.                      
  919.                     ], 
  920.                     'Bcc' => [  
  921.                         [
  922.                             'Email' => 'damien@piranha.lu',
  923.                         ],
  924.                         [
  925.                             'Email' => 'thomasbregler@protonmail.com',
  926.                         ],
  927.                         [
  928.                             'Email' => $userEmail,
  929.                         ],
  930.                     ],
  931.                    
  932.                     'Subject' => $subject,
  933.                     'HTMLPart' => $message,
  934.                 ]
  935.             ]
  936.         ];
  937.          $response = $mj->post(Resources::$Email, ['body' => $body]);
  938.          $response->success();
  941.          
  942.          return $this->redirectToRoute('detailsFormation', ['ref'=>$sess->getFormations()->getReference(),'send'=>'success'], Response::HTTP_SEE_OTHER);
  945.      }
  949.  /**
  950.      * @Route("/sendDocument", name="sendDocument")
  951.      */
  952.     public function sendDocument(Request $request, ContenusRepository $contenusRepository): Response
  953.     {
  954.         
  955.             $id = $_POST['document'];
  956.             $doc = $contenusRepository->findOneBy(['id' => $id]);
  957.             $docName = $doc->getDocument();
  958.             $fileUrl = '../uploads/contenus/'.$docName;
  959.            
  960.             
  961.            
  962.         
  963.             
  964.           $nom = $_POST['nom'];
  965.           $prenom = $_POST['prenom'];
  966.           $societe = $_POST['societe'];
  967.           $email = $_POST['mail'];
  968.          
  969.           if(isset($_POST['flexCheckDefault']))
  970.           {
  971.           $flexCheckDefault = 'on';
  972.           }
  973.           else
  974.           {
  975.              $flexCheckDefault = 'off';
  976.           }
  977.  
  978.  
  979.           $subject = "CPI - Demande de Documentation / documentation request";
  980.           $message = $this->renderView(
  981.              'emails/document.html.twig',
  982.              [
  983.                  'nom' => strtoupper($nom), 
  984.                  'prenom' => strtoupper($prenom), 
  985.                  'societe'=>$societe, 
  986.                  'email'=>$email, 
  987.                  'flexCheckDefault'=>$flexCheckDefault, 
  988.                 
  989.                  ]
  990.          );
  991.  
  992.        
  993.         $userEmail = $_POST['mail'];
  994.           $mj = new \Mailjet\Client('61722507da55a4f5570d0ad1a5b1435e', '01d31913ab5c0fd4586d08d17d114b8c',true,['version' => 'v3.1']);
  995.           $body = [
  996.             'Messages' => [
  997.                 [
  998.                     'From' => [
  999.                         'Email' => "info@cpi.lu",
  1000.                         'Name' => "CPI"
  1001.                     ],
  1002.                     'To' => [
  1003.                         [
  1004.                             'Email' => 'info@cpi.lu',
  1005.                             
  1006.                         ]
  1007.                         
  1008.                         ],
  1009.                         'Bcc' => [  
  1010.                             [
  1011.                                 'Email' => 'damien@piranha.lu',
  1012.                             ],
  1013.                             [
  1014.                                 'Email' => 'thomasbregler@protonmail.com',
  1015.                             ],
  1016.                             [
  1017.                                 'Email' => $userEmail,
  1018.                             ],
  1019.                      
  1020.                     ],
  1021.                     'Subject' => $subject,
  1022.                     'HTMLPart' => $message,
  1023.                 ]
  1024.             ]
  1025.         ];
  1026.           $response = $mj->post(Resources::$Email, ['body' => $body]);
  1027.           $response->success();
  1028.           
  1029.        
  1031.           return new RedirectResponse($fileUrl);
  1032.           //return $this->redirectToRoute('app_contact', ['send'=>'success'], Response::HTTP_SEE_OTHER);
  1033.      }
  1034.      
  1042.  /**
  1043.      * @Route("/sendConsultationERP", name="sendConsultationERP")
  1044.      */
  1045.     public function sendConsultationERP(DocumentsRepository $documentsRepository): Response
  1046.     {
  1048.        
  1049.           $nom = $_POST['nom'];
  1050.           $prenom = $_POST['prenom'];
  1051.           $societe = $_POST['societe'];
  1052.           $email = $_POST['mail'];
  1053.          
  1054.           if(isset($_POST['flexCheckDefault']))
  1055.           {
  1056.           $flexCheckDefault = 'on';
  1057.           }
  1058.           else
  1059.           {
  1060.              $flexCheckDefault = 'off';
  1061.           }
  1062.  
  1063.  
  1064.           $subject = "CPI - Demande de consultation ERP-MES / ERP-MES consultation request";
  1065.           $message = $this->renderView(
  1066.              'emails/consultationERP.html.twig',
  1067.              [
  1068.                  'nom' => strtoupper($nom), 
  1069.                  'prenom' => strtoupper($prenom), 
  1070.                  'societe'=>$societe, 
  1071.                  'email'=>$email, 
  1072.                  'flexCheckDefault'=>$flexCheckDefault, 
  1073.                 
  1074.                  ]
  1075.          );
  1076.  
  1077.        
  1078.          $userEmail = $_POST['mail'];
  1079.           $mj = new \Mailjet\Client('61722507da55a4f5570d0ad1a5b1435e', '01d31913ab5c0fd4586d08d17d114b8c',true,['version' => 'v3.1']);
  1080.           $body = [
  1081.             'Messages' => [
  1082.                 [
  1083.                     'From' => [
  1084.                         'Email' => "info@cpi.lu",
  1085.                         'Name' => "CPI"
  1086.                     ],
  1087.                     'To' => [
  1088.                         [
  1089.                             'Email' => 'info@cpi.lu',
  1090.                             
  1091.                         ]
  1092.                        
  1093.                      
  1094.                     ],
  1096.                     'Bcc' => [  
  1097.                         [
  1098.                             'Email' => 'damien@piranha.lu',
  1099.                         ],
  1100.                         [
  1101.                             'Email' => 'thomasbregler@protonmail.com',
  1102.                         ],
  1103.                     
  1104.                         [
  1105.                             'Email' => $userEmail,
  1106.                         ],
  1107.                     ],
  1108.                    
  1109.                     'Subject' => $subject,
  1110.                     'HTMLPart' => $message,
  1111.                 ]
  1112.             ]
  1113.         ];
  1114.           $response = $mj->post(Resources::$Email, ['body' => $body]);
  1115.           $response->success();
  1116.           
  1117.     
  1118.           return $this->redirectToRoute('app_manufacturingERP');
  1119.      }
  1121.       /**
  1122.      * @Route("/sendConsultationBaseOutils", name="sendConsultationBaseOutils")
  1123.      */
  1124.     public function sendConsultationBaseOutils(DocumentsRepository $documentsRepository): Response
  1125.     {
  1127.        
  1128.           $nom = $_POST['nom'];
  1129.           $prenom = $_POST['prenom'];
  1130.           $societe = $_POST['societe'];
  1131.           $email = $_POST['mail'];
  1132.          
  1133.           if(isset($_POST['flexCheckDefault']))
  1134.           {
  1135.           $flexCheckDefault = 'on';
  1136.           }
  1137.           else
  1138.           {
  1139.              $flexCheckDefault = 'off';
  1140.           }
  1141.  
  1142.  
  1143.           $subject = "CPI - Demande de consultation BASE OUTILS COUPANTS / CUTTING TOOLS BASE consultation request : WINTOOL";
  1144.           $message = $this->renderView(
  1145.              'emails/consultationBaseOutils.html.twig',
  1146.              [
  1147.                  'nom' => strtoupper($nom), 
  1148.                  'prenom' => strtoupper($prenom), 
  1149.                  'societe'=>$societe, 
  1150.                  'email'=>$email, 
  1151.                  'flexCheckDefault'=>$flexCheckDefault, 
  1152.                 
  1153.                  ]
  1154.          );
  1155.  
  1156.        
  1157.          $userEmail = $_POST['mail'];
  1158.           $mj = new \Mailjet\Client('61722507da55a4f5570d0ad1a5b1435e', '01d31913ab5c0fd4586d08d17d114b8c',true,['version' => 'v3.1']);
  1159.           $body = [
  1160.             'Messages' => [
  1161.                 [
  1162.                     'From' => [
  1163.                         'Email' => "info@cpi.lu",
  1164.                         'Name' => "CPI"
  1165.                     ],
  1166.                     'To' => [
  1167.                         [
  1168.                             'Email' => 'info@cpi.lu',
  1169.                             
  1170.                         ]
  1171.                        
  1172.                      
  1173.                     ],
  1174.                     'Bcc' => [  
  1175.                         [
  1176.                             'Email' => 'damien@piranha.lu',
  1177.                         ],
  1178.                         [
  1179.                             'Email' => 'thomasbregler@protonmail.com',
  1180.                         ],
  1181.                         [
  1182.                             'Email' => $userEmail,
  1183.                         ],
  1184.                     ],
  1185.                    
  1186.                     'Subject' => $subject,
  1187.                     'HTMLPart' => $message,
  1188.                 ]
  1189.             ]
  1190.         ];
  1191.           $response = $mj->post(Resources::$Email, ['body' => $body]);
  1192.           $response->success();
  1193.           
  1194.     
  1195.           return $this->redirectToRoute('app_baseOutils');
  1196.      }
  1197.      
  1200.      
  1204.     /**
  1205.         * @Route("/{locale}/cookies", name="cookies")
  1206.     */
  1207.     public function cookies(): Response
  1208.     {
  1209.         return $this->render('default/cookie.html.twig', [
  1210.             
  1211.            
  1212.         ]);
  1213.     }
  1217.     /**
  1218.         * @Route("/{locale}/politique-de-confidentialite", name="politique")
  1219.     */
  1220.     public function politique(SectionsRepository $sectionsRepository, PagesRepository $pagesRepository, TemoignagesRepository $temoignagesRepository): Response
  1221.     {
  1222.         $page = $pagesRepository->findOneById(15);
  1223.         $nb = count($page->getSections()) +1;
  1224.         
  1225.         $sections = $sectionsRepository->findBy(array('Pages'=>15),array('Ordre'=>'asc'));
  1227.         return $this->render('default/politique.html.twig', [
  1228.             'sections' => $sections,
  1229.             'page'=> $page,
  1230.             'ordreMax' =>$nb,
  1231.             'ip' => '90.63.222.84',
  1232.             'temoignages'=>$temoignagesRepository->findAll()
  1233.             
  1234.            
  1235.         ]);
  1236.     }
  1238.     public function findSearch($sujet, $type, $lieu, $ref) {
  1239.         $query = $this->createQueryBuilder('s'); // s représente votre entité de session
  1240.     
  1241.         if ($sujet) {
  1242.             $query->andWhere('s.sujetFormation = :sujet')
  1243.                   ->setParameter('sujet', $sujet);
  1244.         }
  1245.     
  1246.         if ($type) {
  1247.             $query->andWhere('s.typeFormation = :type')
  1248.                   ->setParameter('type', $type);
  1249.         }
  1250.     
  1251.         if ($lieu) {
  1252.             $query->andWhere('s.lieu = :lieu')
  1253.                   ->setParameter('lieu', $lieu);
  1254.         }
  1255.     
  1256.         if ($ref) {
  1257.             $query->andWhere('s.ref = :ref')
  1258.                   ->setParameter('ref', $ref);
  1259.         }
  1260.     
  1261.         // Continuez pour les autres critères de filtrage
  1262.     
  1263.         return $query->getQuery()->getResult();
  1264.     }
  1266.      /**
  1267.      * @Route("/{locale}/planning-formation", name="app_planningFormation")
  1268.      */
  1269.     public function planningFormation($locale,FormationsRepository $formationsRepository, VersionsFormationsRepository $versionsFormationsRepository, TypesFormationsRepository $typesFormationsRepository,
  1270.     SujetsFormationsRepository $sujetsFormationsRepository,LogicielsFormationsRepository $logicielsFormationsRepository, SessionsFormationsRepository $sessionsFormationsRepository, Request $request): Response
  1271.     {
  1273.     
  1274.             $formations = $formationsRepository->findBy([], ['Date' => 'ASC']);
  1275.             $sessionsformations = $sessionsFormationsRepository->findBy([], ['Date' => 'ASC']);
  1276.             $sessionsformationsAll = $sessionsFormationsRepository->findAll();
  1278.             $formationsSearch = $formationsRepository->findBy([], ['TitreFr' => 'ASC']);
  1279.             $typeFormation = $typesFormationsRepository->findAll();
  1280.             $sujetFormation = $sujetsFormationsRepository->findAll();
  1282.             $date = $sessionsFormationsRepository->findBy([],['Date'=>'asc']);
  1283.             $tarifs = $sessionsFormationsRepository->findBy([],['Tarifs'=>'asc']);
  1284.             
  1285.             $langues = $sessionsFormationsRepository->findBy([],['LanguesFr'=>'asc']);
  1288.             $sessionsCriteria=[];
  1289.             $sujetFormation = $sujetsFormationsRepository->findAll();
  1290.             $typeFormation = $typesFormationsRepository->findAll();
  1293.             if ($request->query->get('sujet')) {
  1294.                 $sessionsCriteria['SujetsFormations'] = $request->query->get('sujet');
  1295.             }
  1297.             if ($request->query->get('type')) {
  1298.                 $sessionsCriteria['TypesFormations'] = $request->query->get('type');
  1299.             }
  1301.             if ($request->query->get('lieu')) {
  1302.                 $sessionsCriteria['Lieu'] = $request->query->get('lieu');
  1303.             }
  1305.             if ($request->query->get('ref')) {
  1306.                 $sessionsCriteria['TitreFr'] = $request->query->get('ref');
  1307.             }
  1309.             $sessionsformations = $sessionsFormationsRepository->findByCriteria($sessionsCriteria);
  1310.             
  1312.         
  1316.     
  1318.             return $this->render('default/planningFormation.html.twig', [
  1319.                 'formations' => $formations,
  1320.                 'sessionsformationsAll' => $sessionsformationsAll,
  1321.                 'sessionsformations' => $sessionsformations,
  1322.                 'formationsSearch'=>$formationsSearch,
  1323.                 'typeFormation'=>$typeFormation,
  1324.                 'sujetFormation'=>$sujetFormation,
  1325.             
  1327.                 'sujets' => $sujetsFormationsRepository->findBy([], ['TitreFr' => 'ASC']),
  1328.                 'date' => $date,
  1329.                 'tarifs' => $tarifs,
  1330.                 'langues' => $langues,
  1331.                
  1332.                
  1333.              
  1334.             ]);
  1335.         }
  1338.         
  1343. /**
  1344.         * @Route("/genererpdf/{id}", name="genererpdf")
  1345.     */
  1346.     public function genererpdf(FormationsRepository $formationsRepository,CategoriesFormationsRepository $categoriesFormationsRep,$id): Response
  1347.     {
  1348.         $categoriesFormations = $categoriesFormationsRep->findAll();
  1349.         $forma = $formationsRepository->findOneById($id);
  1350.         $template = $this->renderView('formationPdf.html.twig', [
  1351.             'formations' => $formationsRepository->findOneById($id),
  1352.             'categoriesFormations' => $categoriesFormations
  1353.             
  1354.        ]);
  1356.        $html2pdf = new Html2Pdf();
  1357.        $html2pdf->setDefaultFont('dejavusans'); // Définit 'dejavusans' comme police par défaut
  1358.        $html2pdf->writeHTML($template);
  1359.        $html2pdf->output('formation_cpi_'.$forma->getReference().'.pdf');
  1361.     }
  1363.     /**
  1364.         * @Route("/genererpdfjobs/{id}", name="genererpdfjob")
  1365.     */
  1366.     public function genererpdfjobs(JobsRepository $jobsRepository,$id): Response
  1367.     {
  1369.         $template = $this->renderView('jobsPdf.html.twig', [
  1370.             'jobs' => $jobsRepository->findOneById($id)
  1371.        ]);
  1373.        $html2pdf = new Html2Pdf();
  1374.         $html2pdf->writeHTML($template);
  1375.         $html2pdf->output();
  1378.         
  1380.     }
  1387.       /**
  1388.         * @Route("/resultat-recherche", name="resultatRecherche")
  1389.     */
  1390.     public function resultatRecherche(ContenusRepository $ContenusRepository, FormationsRepository $FormationsRepository, ActualitesRepository $ActualitesRepository, JobsRepository $JobsRepository): Response
  1391.     {
  1393.         $keyword = $_POST['search'];
  1394.         $contenus = $ContenusRepository->findSearch($keyword);
  1395.         $formations = $FormationsRepository->findSearch($keyword);
  1396.         $actualites = $ActualitesRepository->findSearch($keyword);
  1397.         $jobs = $JobsRepository->findSearch($keyword);
  1399.     
  1400.         return $this->render('default/resultatRecherche.html.twig', [
  1401.             'contenus'=>$contenus,
  1402.             'formations'=>$formations,
  1403.             'actualites'=>$actualites,
  1404.             'jobs'=>$jobs
  1405.            
  1406.         ]);
  1407.     }
  1412.     /**
  1413.         * @Route("/search", name="search")
  1414.     */
  1415.     public function search(ContenusRepository $ContenusRepository, FormationsRepository $FormationsRepository, ActualitesRepository $ActualitesRepository, JobsRepository $JobsRepository): Response
  1416.     {
  1417.         $keyword = 'Manufacturing';
  1418.         $contenus = $ContenusRepository->findSearch($keyword);
  1419.         $formations = $FormationsRepository->findSearch($keyword);
  1420.         $actualites = $ActualitesRepository->findSearch($keyword);
  1421.         $jobs = $JobsRepository->findSearch($keyword);
  1423.         dd($formations);
  1424.        
  1426.         return new response('ok');
  1428.     }
  1432.     }
  1434.     
  1435.     
  1457. // $formations = $formationsRepository->findBy([], ['TitreFr' => 'ASC']);
  1458. // $formationsSearch = $formationsRepository->findBy([], ['TitreFr' => 'ASC']);
  1459. // $date = $sessionsFormationsRepository->findBy([],['Date'=>'asc']);
  1461. // if(isset($_GET['sujet']))
  1462. // {
  1463. //     $formations = $formationsRepository->findBy(['SujetsFormations'=>$_GET['sujet']]);
  1464. // }
  1466. // $selectedSujet = $request->query->get('sujet');
  1468. // if ($selectedSujet !== null) {
  1469. //     // Filter the sessions by the selected sujet
  1470. //     $formations = $formationsRepository->findBy(['SujetsFormations' => $selectedSujet]);
  1471. // }
  1474. // $reference = $formationsRepository->findBy([],['Reference'=>'asc']);
  1476. // $lieu = $sessionsFormationsRepository->findBy([],['Lieu'=>'desc']);
  1477. // $type = $sessionsFormationsRepository->findBy([], ['Type' => 'desc']);
  1478. // $tarifs = $sessionsFormationsRepository->findBy([], ['Tarifs' => 'desc']);
  1480. // return $this->render('default/planningFormation.html.twig', [
  1481. //     'formations' => $formations,
  1482. //     'date' => $date,
  1483. //     'sujets' =>$sujetsFormationsRepository->findBy([], ['TitreFr' => 'ASC']),
  1484. //     'reference' => $reference,
  1485. //     'lieu'=>$lieu,
  1486. //     'tarifs' => $tarifs,
  1487. //     'type' => $type,
  1488. //     'catLieu'=>$sessionsFormationsRepository->findBy([], ['Lieu' => 'ASC']),
  1489. //     'selectedSujet' => $selectedSujet,
  1490. // ]);