src\Controller\RecController.php line 485

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\Avis;
  6. use App\Entity\Histo;
  7. use App\Entity\Terme;
  8. use App\Entity\AvisAr;
  9. use App\Entity\LogCon;
  10. use App\Form\AvisType;
  11. use App\Entity\Domaine;
  12. use App\Entity\Visitor;
  13. use App\Entity\Historic;
  14. use App\Entity\HistoricAr;
  15. use App\Entity\Recommandation;
  17. use App\Entity\RecommandationAr;
  18. use App\Form\RecommandationType;
  20. use App\Form\RecommandationArType;
  21. use PhpOffice\PhpSpreadsheet\IOFactory;
  22. use Doctrine\ORM\EntityManagerInterface;
  23. use phpoffice\phpexcel\Classes\PHPExcel;
  24. use phpDocumentor\Reflection\Types\Integer;
  25. use Symfony\Component\HttpFoundation\Request;
  26. use Symfony\Component\HttpFoundation\Response;
  27. use Symfony\Component\Routing\Annotation\Route;
  28. use Symfony\Bridge\Doctrine\Form\Type\EntityType;
  29. use Symfony\Component\Form\Extension\Core\Type\TextType;
  30. use Symfony\Component\Form\Extension\Core\Type\ChoiceType;
  31. use Symfony\Component\Form\Extension\Core\Type\SubmitType;
  32. use Symfony\Component\Form\Extension\Core\Type\TextareaType;
  33. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  36. use Knp\Component\Pager\PaginatorInterface;
  43. class RecController extends AbstractController
  44. {
  45.     /**
  46.      * @Route("/rec", name="rec")
  47.      */
  48.     public function index_rec(Request $request, PaginatorInterface $paginator): Response
  49.     {
  50.         $repo = $this->getDoctrine()->getRepository(Recommandation::class);
  51.         $query = $repo->createQueryBuilder('r')->getQuery();
  53.         $Avisnom = $repo->total_av();
  54.         $commission = $repo->total_com();
  55.         $total = $repo->total();
  57.         $recommandations = $paginator->paginate(
  58.             $query,
  59.             $request->query->getInt('page', 1),
  60.             // Numéro de la page
  61.             50 // Limite d'affichage
  62.         );
  64.         $recommandations->setTemplate('@KnpPaginator/Pagination/twitter_bootstrap_v4_pagination.html.twig'); //Application du style css
  66.         return $this->render('rec/index.html.twig', [
  67.             'recommandations' => $recommandations,
  68.             'nombre' => $total,
  69.             'av' => $Avisnom,
  70.             'com' => $commission
  71.         ]);
  72.     }
  74.     /**
  75.      * @Route("/rec/trad", name="rec_trad")
  76.      */
  77.     public function index_trad(Request $request, PaginatorInterface $paginator): Response
  78.     {
  79.         $repo = $this->getDoctrine()->getRepository(Recommandation::class);
  80.         $query = $repo->createQueryBuilder('r')->getQuery();
  82.         $Avisnom = $repo->total_av();
  83.         $commission = $repo->total_com();
  84.         $total = $repo->total();
  86.         $recommandations = $paginator->paginate(
  87.             $query,
  88.             $request->query->getInt('page', 1),
  89.             // Numéro de la page
  90.             50 // Limite d'affichage
  91.         );
  93.         $recommandations->setTemplate('@KnpPaginator/Pagination/twitter_bootstrap_v4_pagination.html.twig'); //Application du style css
  96.         return $this->render('rec/index_trad.html.twig', [
  97.             'recommandations' => $recommandations,
  98.             'nombre' => $total,
  99.             'av' => $Avisnom,
  100.             'com' => $commission
  101.         ]);
  102.     }
  105.     /**
  106.      * @Route("/rec/ar", name="rec_ar")
  107.      */
  108.     public function index_ar(Request $request, PaginatorInterface $paginator): Response
  109.     {
  111.         $repo = $this->getDoctrine()->getRepository(Recommandation::class);
  112.         $query = $repo->createQueryBuilder('r')->getQuery();
  114.         $Avisnom = $repo->total_av();
  115.         $commission = $repo->total_com();
  116.         $total = $repo->total();
  118.         $recommandations = $paginator->paginate(
  119.             $query,
  120.             $request->query->getInt('page', 1),
  121.             // Numéro de la page
  122.             50 // Limite d'affichage
  123.         );
  125.         $recommandations->setTemplate('@KnpPaginator/Pagination/twitter_bootstrap_v4_pagination.html.twig'); //Application du style css
  128.         return $this->render('rec/index_ar.html.twig', [
  129.             'recommandations' => $recommandations,
  130.             'nombre' => $total,
  131.             'av' => $Avisnom,
  132.             'com' => $commission
  133.         ]);
  134.     }
  137.     /**
  138.      * @Route("/rec/new", name="rec_create")
  139.      */
  141.     public function form(Request $request, EntityManagerInterface $manager)
  142.     {
  144.         $histo = new Historic();
  145.         $recommandation = new Recommandation();
  146.         $form = $this->createForm(RecommandationType::class, $recommandation);
  147.         $form->add('AvisURL', EntityType::class, [
  148.             'class' => Avis::class,
  149.             'choice_label' => 'Intitule',
  150.             'label' => 'Avis'
  151.         ]);
  152.         $form->add('Ar', RecommandationArType::class);
  154.         $form->handleRequest($request);
  155.         $message = null;
  157.         if ($form->isSubmitted() && $form->isValid()) {
  159.             $repo = $this->getDoctrine()->getRepository(Recommandation::class);
  160.             $user = $this->getUser();
  161.             $recommandationExist = $repo->findOneBy(['recommandation' => $recommandation->getRecommandation()]);
  163.             if (!$recommandationExist) {
  164.                 $manager->persist($recommandation);
  165.                 $manager->flush();
  166.                 $message = "Cette Recommandation est saisie avec succés";
  168.                 $histo->setRec($recommandation);
  169.                 $histo->setUser($user);
  170.                 $histo->setType("Création");
  171.                 $histo->setDate(new \DateTime());
  173.                 $manager->persist($histo);
  174.                 $manager->flush();
  175.                 return $this->redirect('rec/create.html.twig');
  176.             } else {
  177.                 $message = "Cette Recommandation est déjà saisie";
  178.                 return $this->redirect('rec/create.html.twig');
  179.             }
  180.         }
  181.         $av = true;
  182.         $lien = '/rec/new/';
  183.         return $this->render('rec/create.html.twig', [
  184.             'formRecommandation' => $form->createView(),
  185.             'message' => $message,
  186.             'av' => $av,
  187.             'id' => $av->getid()
  188.             // 'recommandation' => $recommandation
  189.         ]);
  190.     }
  192.     /**
  193.      * @Route("/rec/{id}/edit", name="rec_edit")
  194.      */
  196.     public function formed(int $id, Request $request, EntityManagerInterface $manager)
  197.     {
  199.         $repo = $this->getDoctrine()->getRepository(Recommandation::class);
  200.         $recommandation = $repo->findOneBy(['id' => $id]);
  201.         $form = $this->createForm(RecommandationType::class, $recommandation);
  203.         $form->add('AvisURL', EntityType::class, [
  204.             'class' => Avis::class,
  205.             'choice_label' => 'Intitule',
  206.         ]);
  207.         $form->add('Ar', RecommandationArType::class);
  209.         $form->handleRequest($request);
  210.         $message = null;
  212.         if ($form->isSubmitted() && $form->isValid()) {
  214.             $manager->persist($recommandation);
  215.             $manager->flush();
  216.             $message = "Cette Recommandation est modifiée avec succés";
  218.             $histo = new Histo();
  219.             $histo->setUser($this->getUser());
  220.             $histo->setType("Modification de recommandation");
  221.             $histo->setDate(new \DateTime());
  222.             $histo->setCommentaire("Modifier la recommandation \"" . $recommandation->getRecommandation() . "\"/\"" . $recommandation->getAr()->getRecommandation() . "\"  de l'avis \"" . $recommandation->getAvisURL()->getIntitule() . "\", qui situe dans la page: " . $recommandation->getNPage() . "(fr) " . $recommandation->getAr()->getNPage() . "(ar)");
  224.             $manager->persist($histo);
  225.             $manager->flush();
  226.         }
  227.         $av = true;
  229.         return $this->render('rec/modify.html.twig', [
  230.             'formRecommandation' => $form->createView(),
  231.             'message' => $message,
  232.             'av' => $av,
  233.             'recommandation' => $recommandation
  234.         ]);
  235.     }
  237.     /**
  238.      * @Route("/rec/new/ar", name="rec_create_ar")
  239.      */
  241.     public function form_ar(RecommandationAr $recommandation = null, Request $request, EntityManagerInterface $manager)
  242.     {
  244.         $histo = new HistoricAr();
  245.         $recommandation = new RecommandationAr();
  246.         $form = $this->createForm(RecommandationArType::class, $recommandation);
  247.         $form->add('AvisURL', EntityType::class, [
  248.             'class' => AvisAr::class,
  249.             'choice_label' => 'Intitule',
  250.             'label' => 'Avis'
  251.         ]);
  253.         $form->handleRequest($request);
  254.         $message = null;
  256.         if ($form->isSubmitted() && $form->isValid()) {
  258.             $repo = $this->getDoctrine()->getRepository(RecommandationAr::class);
  259.             $user = $this->getUser();
  260.             $recommandationExist = $repo->findOneBy(['recommandation' => $recommandation->getRecommandation()]);
  262.             if (!$recommandationExist) {
  263.                 $manager->persist($recommandation);
  264.                 $manager->flush();
  265.                 $message = "لقد تمت إضافة هذه التوصية بنجاح";
  267.                 $histo->setRec($recommandation);
  268.                 $histo->setUser($user);
  269.                 $histo->setType("Création");
  270.                 $histo->setDate(new \DateTime());
  272.                 $manager->persist($histo);
  273.                 $manager->flush();
  274.             } else {
  275.                 $message = "هذه التوصية موجودة بالفعل";
  276.             }
  277.         }
  278.         $av = true;
  280.         return $this->render('rec/create_ar.html.twig', [
  281.             'formRecommandationAr' => $form->createView(),
  282.             'message' => $message,
  283.             'av' => $av,
  284.             'recommandation' => $recommandation
  285.         ]);
  286.     }
  289.     /**
  290.      * @Route("/rec/{id}/edit/ar", name="rec_edit_ar")
  291.      */
  293.     public function formed_ar(int $id, Request $request, EntityManagerInterface $manager)
  294.     {
  296.         $repo = $this->getDoctrine()->getRepository(Recommandation::class);
  297.         $recommandation = $repo->findOneBy(['Ar' => $id]);
  298.         $form = $this->createForm(RecommandationType::class, $recommandation);
  300.         $form->add('AvisURL', EntityType::class, [
  301.             'class' => Avis::class,
  302.             'choice_label' => 'Intitule',
  303.         ]);
  304.         $form->add('Ar', RecommandationArType::class);
  306.         $form->handleRequest($request);
  307.         $message = null;
  309.         if ($form->isSubmitted() && $form->isValid()) {
  311.             $manager->persist($recommandation);
  312.             $manager->flush();
  313.             $message = "تم تعديل التوصية بنجاح";
  315.             $histo = new Histo();
  316.             $histo->setUser($this->getUser());
  317.             $histo->setType("Modification de recommandation");
  318.             $histo->setDate(new \DateTime());
  319.             $histo->setCommentaire("Modifier la recommandation \"" . $recommandation->getRecommandation() . "\"/\"" . $recommandation->getAr()->getRecommandation() . "\"  de l'avis \"" . $recommandation->getAvisURL()->getIntitule() . "\", qui situe dans la page: " . $recommandation->getNPage() . "(fr) " . $recommandation->getAr()->getNPage() . "(ar)");
  321.             $manager->persist($histo);
  322.             $manager->flush();
  323.         }
  324.         $av = true;
  326.         return $this->render('rec/modify_ar.html.twig', [
  327.             'formRecommandation' => $form->createView(),
  328.             'message' => $message,
  329.             'av' => $av,
  330.             'recommandation' => $recommandation
  331.         ]);
  332.     }
  335.     /**
  336.      *@Route("/recom/{domaine}", name="rec_dom")
  337.      */
  338.     public function index_env(string $domaine): Response
  339.     {
  340.         $re = $this->getDoctrine()->getRepository(Domaine::class);
  341.         $dom = $re->findOneBy(['Intitule' => 'Rapport Annuels']);
  343.         $rep = $this->getDoctrine()->getRepository(Avis::class);
  344.         $avis = $rep->findBy(['domaineId' => $dom]);
  347.         return $this->render('rec/index_prepa1.html.twig', [
  348.             'Domaine' => $domaine,
  349.             'rapports' => $avis
  350.         ]);
  351.     }
  353.     /**
  354.      *@Route("/rec/{Domaine}", name="rec_domaine")
  355.      */
  356.     public function index_eco(string $Domaine, Request $request, PaginatorInterface $paginator): Response
  357.     {
  359.         $re = $this->getDoctrine()->getRepository(Domaine::class);
  360.         $dom = $re->findOneBy(['Intitule' => $Domaine]);
  362.         $rep = $this->getDoctrine()->getRepository(Avis::class);
  363.         $avis = $rep->findBy(['domaineId' => $dom]);
  365.         $repos = $this->getDoctrine()->getRepository(Recommandation::class);
  366.         $recommandations = $repos->findBy(['AvisURL' => $avis]);
  369.         $repo = $this->getDoctrine()->getRepository(Recommandation::class);
  370.         $recommandations = $repos->findBy(['AvisURL' => $avis]);
  371.         $query = $repo->createQueryBuilder('r')->getQuery();
  373.         $total = $repos->total_dom($dom->getId());
  374.         $total_com = $rep->total_com($dom->getId());
  375.         $total_avis = $rep->total_dom($dom->getId());
  377.         $recommandations = $paginator->paginate(
  378.             $query,
  379.             $request->query->getInt('page', 1),
  380.             // Numéro de la page
  381.             50 // Limite d'affichage
  382.         );
  384.         $recommandations->setTemplate('@KnpPaginator/Pagination/twitter_bootstrap_v4_pagination.html.twig'); //Application du style css
  386.         return $this->render('rec/index_eco.html.twig', [
  387.             'recommandations' => $recommandations,
  388.             'Domaine' => $Domaine,
  389.             'nombre' => $total,
  390.             'nombre_com' => $total_com,
  391.             'nombre_av' => $total_avis
  392.         ]);
  393.     }
  395.     /**
  396.      *@Route("/rec/Environement et developpement durable/ar", name="rec_dom_env")
  397.      */
  398.     public function index_env_ar(): Response
  399.     {
  400.         $domaine = "البيئة والتنمية المستدامة";
  402.         return $this->render('rec/index_prepa.html.twig', [
  403.             'Domaine' => $domaine,
  405.         ]);
  406.     }
  409.     /**
  410.      *@Route("/recom/RAPPORTS ANNUELS/ar", name="rec_dom_rap")
  411.      */
  412.     public function index_rap_ar(): Response
  413.     {
  415.         $domaine = "التقارير السنوية";
  417.         $re = $this->getDoctrine()->getRepository(Domaine::class);
  418.         $dom = $re->findOneBy(['Intitule' => 'Rapport Annuels']);
  420.         $rep = $this->getDoctrine()->getRepository(Avis::class);
  421.         $avis = $rep->findBy(['domaineId' => $dom]);
  424.         return $this->render('rec/index_prepa_ar.html.twig', [
  425.             'Domaine' => $domaine,
  426.             'rapports' => $avis
  427.         ]);
  428.     }
  430.     /**
  431.      *@Route("/rec/{domainefr}/ar", name="rec_domaine_ar")
  432.      */
  433.     public function index_eco_ar(string $domainefr, Request $request, PaginatorInterface $paginator): Response
  434.     {
  435.         $repoo = $this->getDoctrine()->getRepository(Domaine::class);
  436.         $Domaine = $repoo->findOneBy(['Intitule' => $domainefr]);
  438.         $repo = $this->getDoctrine()->getRepository(RecommandationAr::class);
  439.         $query = $repo->createQueryBuilder('r')->getQuery();
  440.         $recommandations = $repo->findBy(['domainefr' => $domainefr]);
  441.         $total = $repo->total_dom($domainefr);
  442.         $total_com = $repo->total_dom_com($domainefr);
  443.         $total_avis = $repo->total_dom_av($domainefr);
  446.         $recommandations = $paginator->paginate(
  447.             $query,
  448.             $request->query->getInt('page', 1),
  449.             // Numéro de la page
  450.             50 // Limite d'affichage
  451.         );
  453.         $recommandations->setTemplate('@KnpPaginator/Pagination/twitter_bootstrap_v4_pagination.html.twig'); //Application du style css
  456.         return $this->render('rec/index_eco_ar.html.twig', [
  457.             'recommandations' => $recommandations,
  458.             'Domaine' => $Domaine->getIntituleAr(),
  459.             'DomaineF' => $domainefr,
  460.             'nombre' => $total,
  461.             'nombre_com' => $total_com,
  462.             'nombre_av' => $total_avis
  463.         ]);
  464.     }
  467.     /**
  468.      * @Route("/ar", name="home_ar")
  469.      */
  470.     public function home_ar(EntityManagerInterface $manager)
  471.     {
  473.         $reposs = $this->getDoctrine()->getRepository(RecommandationAr::class);
  474.         $totalar = $reposs->total();
  476.         return $this->render('rec/home_ar.html.twig', [
  477.             'nombrear' => $totalar
  478.         ]);
  479.     }
  482.     /**
  483.      * @Route("/", name="home")
  484.      */
  485.     public function home(EntityManagerInterface $manager)
  486.     {
  488.         if (!empty($_SERVER['HTTP_CLIENT_IP'])) {
  489.             $ip = $_SERVER['HTTP_CLIENT_IP'];
  490.         }
  491.         //whether ip is from the proxy  
  492.         elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) {
  493.             $ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
  494.         }
  495.         //whether ip is from the remote address  
  496.         else {
  497.             $ip = $_SERVER['REMOTE_ADDR'];
  498.         } // L'adresse IP du visiteur
  499.         $date = date('Y-m-d'); // La date d'aujourd'hui, sous la forme AAAA-MM-JJ
  501.         $visitor = new Visitor();
  503.         $visitor->setIp($ip);
  504.         $visitor->setDate(new \DateTime());
  506.         $manager->persist($visitor);
  507.         $manager->flush();
  509.         $repos = $this->getDoctrine()->getRepository(Recommandation::class);
  510.         $total = $repos->total();
  512.         $rep = $this->getDoctrine()->getRepository(Avis::class);
  513.         $av = $rep->av();
  515.         for ($i = 2; $i < 10; $i++) {
  517.             $totaldom[$i] = $repos->total_dom($i);
  518.             $total_com[$i] = $rep->total_com($i);
  519.             $total_avis[$i] = $rep->total_dom($i);
  520.         }
  522.         $histo = new LogCon();
  523.         $user = $this->getUser();
  526.         $histo->setUser($user);
  527.         $histo->setType("Accueil");
  528.         $histo->setDate(new \DateTime());
  530.         $manager->persist($histo);
  531.         $manager->flush();
  534.         if (!$this->getUser()) {
  535.             return $this->render('rec/home.html.twig', [
  536.                 // 'der' => $lastRow,
  537.                 'nombre' => $total,
  538.                 'totaldom' => $totaldom,
  539.                 'total_com' => $total_com,
  540.                 'total_avis' => $total_avis,
  541.                 'av' => $av
  542.             ]);
  543.         } else {
  544.             if ($this->getUser()->getDomaine() == "Traducteur") {
  545.                 $repo = $this->getDoctrine()->getRepository(Terme::class);
  546.                 $nombre = count($repo->findAll());
  547.                 $repos = $this->getDoctrine()->getRepository(Avis::class);
  548.                 $av = count($repos->findAll());
  550.                 $av_ext = count($repos->avis_ext('CESE'));
  552.                 $n_ext = count($repo->findBy(['avis' => $repos->avis_ext('CESE')]));
  553.                 $org = $repo->total_org();
  555.                 $av_int = count($repos->findBy(['source' => 'CESE']));
  557.                 $n_int = count($repo->findBy(['avis' => $repos->findBy(['source' => 'CESE'])]));
  560.                 return $this->render('accueil/home_trad.html.twig', [
  561.                     'nombre' => $nombre,
  562.                     'n_av' => $av,
  563.                     'n_av_ext' => $av_ext,
  564.                     'n_ext' => $n_ext,
  565.                     'org' => $org,
  566.                     'n_av_int' => $av_int,
  567.                     'n_int' => $n_int
  568.                 ]);
  569.             } else {
  570.                 return $this->render('rec/home.html.twig', [
  571.                     // 'der' => $lastRow,
  572.                     'nombre' => $total,
  573.                     'totaldom' => $totaldom,
  574.                     'total_com' => $total_com,
  575.                     'total_avis' => $total_avis,
  576.                     'av' => $av
  577.                 ]);
  578.             }
  579.         }
  580.     }
  584.     /**
  585.      * @Route("/rec/{id}", name="rec_show")
  586.      */
  587.     public function show($id)
  588.     {
  592.         return $this->render('rec/show.html.twig', [
  593.             'recommandation' => $recommandation
  594.         ]);
  595.     }
  599.     /**
  600.      * @Route("new", name="befor_create")
  601.      */
  602.     public function before()
  603.     {
  605.         $reposi = $this->getDoctrine()->getRepository(Avis::class);
  606.         $Avis = $reposi->findAll();
  608.         $repos = $this->getDoctrine()->getRepository(Recommandation::class);
  609.         $total = $repos->total();
  611.         return $this->render('rec/befor_create.html.twig', [
  612.             'Avis' => $Avis,
  613.             'nombre' => $total
  614.         ]);
  615.     }
  618.     /**
  619.      * @Route("new/ar", name="befor_create_ar")
  620.      */
  622.     public function before_ar()
  623.     {
  625.         $reposi = $this->getDoctrine()->getRepository(AvisAr::class);
  626.         $Avis = $reposi->findAll();
  628.         $repos = $this->getDoctrine()->getRepository(RecommandationAr::class);
  629.         $total = $repos->total();
  631.         return $this->render('rec/befor_create_ar.html.twig', [
  632.             'Avis' => $Avis,
  633.             'nombre' => $total
  634.         ]);
  635.     }
  639.     /**
  640.     * @Route("/rec/new/{id}", name="rec_create_many")
  641.     
  642.     */
  644.     public function forma(int $id, Recommandation $recommandation = null, Request $request, EntityManagerInterface $manager)
  645.     {
  647.         $recommandation = new Recommandation();
  649.         $av = false;
  650.         $repoo = $this->getDoctrine()->getRepository(Avis::class);
  651.         $avExistt = $repoo->findOneBy(['id' => $id]);
  652.         $avar = $avExistt->getAr();
  653.         $recommandation->setAvisURL($avExistt);
  657.         $form = $this->createForm(RecommandationType::class, $recommandation);
  660.         $form->add('Ar', RecommandationArType::class);
  663.         $form->handleRequest($request);
  664.         $message = null;
  666.         if ($form->isSubmitted() && $form->isValid()) {
  668.             $repo = $this->getDoctrine()->getRepository(Recommandation::class);
  669.             $recommandationExist = $repo->findOneBy(['recommandation' => $recommandation->getRecommandation()]);
  670.             $recommandation->getAr()->setAvisUrl($avar);
  671.             $recommandation->getAr()->setDomainefr($avExistt->getDomaineId()->getIntitule());
  672.             if (!$recommandationExist) {
  673.                 $manager->persist($recommandation);
  674.                 $manager->flush();
  675.                 $message = "La Recommandation est saisie avec succés";
  678.                 $histo = new Histo();
  679.                 $histo->setUser($this->getUser());
  680.                 $histo->setType("Ajout Recommandation");
  681.                 $histo->setDate(new \DateTime());
  682.                 $histo->setCommentaire("Ajout la recommandation \"" . $recommandation->getRecommandation() . "\"/\"" . $recommandation->getAr()->getRecommandation() . "\"  de l'avis \"" . $recommandation->getAvisURL()->getIntitule() . "\", qui situe dans la page: " . $recommandation->getNPage() . "(fr) " . $recommandation->getAr()->getNPage() . "(ar)");
  684.                 $manager->persist($histo);
  685.                 $manager->flush();
  686.             } else {
  687.                 $message = "Cette Recommandation est déjà saisie";
  688.             }
  689.         }
  694.         return $this->render('rec/create.html.twig', [
  695.             'formRecommandation' => $form->createView(),
  696.             'editMode' => $recommandation->getId() !== null,
  697.             'av' => $av,
  698.             'ar' => $avExistt->getId(),
  699.             'titre' => $avExistt->getIntitule(),
  700.             'message' => $message,
  701.             'recommandation' => $recommandation
  702.             // 'url' => $url
  703.         ]);
  704.     }
  707.     /**
  708.     * @Route("/rec/new/{id}/ar", name="rec_create_many_ar")
  709.     
  710.     */
  712.     public function forma_ar(int $id, Recommandation $recommandation = null, Request $request, EntityManagerInterface $manager)
  713.     {
  715.         $recommandation = new Recommandation();
  717.         $av = false;
  718.         $repoo = $this->getDoctrine()->getRepository(Avis::class);
  719.         $avExistt = $repoo->findOneBy(['id' => $id]);
  720.         $avar = $avExistt->getAr();
  721.         $recommandation->setAvisURL($avExistt);
  724.         $form = $this->createForm(RecommandationType::class, $recommandation);
  727.         $form->add('Ar', RecommandationArType::class);
  730.         $form->handleRequest($request);
  731.         $message = null;
  733.         if ($form->isSubmitted() && $form->isValid()) {
  735.             $repo = $this->getDoctrine()->getRepository(Recommandation::class);
  736.             $recommandationExist = $repo->findOneBy(['recommandation' => $recommandation->getRecommandation()]);
  737.             $user = $this->getUser();
  738.             $recommandation->getAr()->setAvisUrl($avar);
  739.             $recommandation->getAr()->setDomainefr($avExistt->getDomaineId()->getIntitule());
  740.             if (!$recommandationExist) {
  741.                 $manager->persist($recommandation);
  742.                 $manager->flush();
  743.                 $message = "La Recommandation est saisie avec succés";
  746.                 $histo = new Histo();
  747.                 $histo->setUser($this->getUser());
  748.                 $histo->setType("Ajout Recommandation");
  749.                 $histo->setDate(new \DateTime());
  750.                 $histo->setCommentaire("Ajout la recommandation \"" . $recommandation->getAr()->getRecommandation() . "\" de l'avis \"" . $recommandation->getAvisURL()->getIntitule() . "\", qui situe dans la page: " . $recommandation->getAr()->getNPage());
  752.                 $manager->persist($histo);
  753.                 $manager->flush();
  754.             } else {
  755.                 $message = "Cette Recommandation est déjà saisie";
  756.             }
  757.         }
  759.         return $this->render('rec/create_ar.html.twig', [
  760.             'formRecommandation' => $form->createView(),
  761.             'editMode' => $recommandation->getId() !== null,
  762.             'av' => $av,
  763.             'ar' => $avExistt->getId(),
  764.             'titre' => $avExistt->getAr()->getIntitule(),
  765.             'message' => $message,
  766.             'recommandation' => $recommandation
  767.         ]);
  768.     }
  771.     /**
  772.      * @Route("/rec/{id}/delete", name="rec_delete")
  773.      */
  775.     public function delete(Request $request, EntityManagerInterface $manager, int $id)
  776.     {
  778.         $histo = new Histo();
  780.         $repo = $this->getDoctrine()->getRepository(Recommandation::class);
  781.         $recommandation = $repo->findOneBy(['id' => $id]);
  783.         $repos = $this->getDoctrine()->getRepository(RecommandationAr::class);
  784.         $recommandationAr = $repos->findOneBy(['id' => $recommandation->getAr()->getId()]);
  786.         $message = null;
  788.         $manager->remove($recommandation);
  789.         $manager->flush();
  790.         $manager->remove($recommandationAr);
  791.         $manager->flush();
  793.         $histo->setUser($this->getUser());
  794.         $histo->setType("Suppression Recommandation");
  795.         $histo->setDate(new \DateTime());
  796.         $histo->setCommentaire("Supprimer la recommandation \"" . $recommandation->getRecommandation() . "\" de l'avis \"" . $recommandation->getAvisURL()->getIntitule() . "\", qui situe dans la page: " . $recommandation->getNPage());
  799.         $manager->persist($histo);
  800.         $manager->flush();
  802.         return $this->redirectToRoute('rec_domaine', array('Domaine' => $recommandationAr->getDomainefr()));
  803.     }
  804. }