src/Controller/Front/FormationController.php line 36

  1. <?php
  3. namespace App\Controller\Front;
  5. use App\Entity\Actualite;
  6. use App\Entity\Contrats;
  7. use App\Entity\Diplomes;
  8. use App\Entity\Domaines;
  9. use App\Entity\Pole;
  10. use App\Repository\ContratsRepository;
  11. use App\Repository\DiplomesRepository;
  12. use App\Repository\DomainesRepository;
  13. use App\Repository\FormationRepository;
  14. use App\Repository\PoleRepository;
  15. use App\Repository\PositionBlocsFormationRepository;
  16. use Doctrine\ORM\EntityManagerInterface;
  17. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  18. use Symfony\Component\HttpFoundation\Request;
  19. use Symfony\Component\HttpFoundation\Response;
  20. use Symfony\Component\Routing\Annotation\Route;
  21. use Ttskch\PaginatorBundle\Context;
  22. use Ttskch\PaginatorBundle\Doctrine\Counter;
  23. use Ttskch\PaginatorBundle\Doctrine\Slicer;
  24. use Ttskch\PaginatorBundle\Entity\Criteria;
  26. class FormationController extends AbstractController
  27. {
  28.     public function __construct(
  29.         private EntityManagerInterface $entityManager,
  30.         private FormationRepository $formationRepository,
  31.         private PositionBlocsFormationRepository $positionBlocsFormationRepository
  32.     ) {
  33.     }
  35.     #[Route('/formations', name: 'app_formation_list')]
  36.     public function index(Request $request, FormationRepository $formationRepository, Context $context): Response
  37.     {
  38.         $poles = $this->entityManager->getRepository(Pole::class)->findAll();
  39.         $domaines = $this->entityManager->getRepository(Domaines::class)->findAll();
  40.         $diplomes = $this->entityManager->getRepository(Diplomes::class)->findAll();
  41.         $contrats = $this->entityManager->getRepository(Contrats::class)->findAll();
  43.         $pole = $request->get('pole');
  44.         $domaine = $request->get('domaine');
  45.         $diplome = $request->get('diplome');
  46.         $contrat = $request->get('contrat');
  48.         if (null === $domaine && null === $diplome && null === $contrat && null === $pole) {
  49.             // $formations = $this->formationRepository->findAll();
  50.             $qb = $formationRepository->createQueryBuilder('P')
  51.                 ->where('P.visible = true');
  52.             $context->initialize('id', new Slicer($qb), new Counter($qb));
  53.         } else {
  54.             $formations = $this->formationRepository->findBySearch($domaine, $diplome, $contrat, $pole);
  55.             $array = (array) $formations;
  56.             $context->initialize(
  57.                 'id',
  58.                 function (Criteria $criteria) use ($array) {
  59.                     return \array_slice($array, $criteria->limit * ($criteria->page - 1), $criteria->limit);
  60.                 },
  61.                 function () use ($array) {
  62.                     return \count($array);
  63.                 }
  64.             );
  65.         }
  66.         //  dd($qb);
  67.         $nbFormation = $context->count;
  69.         $actualites = $this->entityManager->getRepository(Actualite::class)->findAll();
  71.         return $this->render('front/formation/index.html.twig', [
  72.             'poles' => $poles,
  73.             'domaines' => $domaines,
  74.             'diplomes' => $diplomes,
  75.             'contrats' => $contrats,
  76.             'poleSearch' => $pole,
  77.             'domaineSearch' => $domaine,
  78.             'diplomeSearch' => $diplome,
  79.             'contratSearch' => $contrat,
  80.             'formations' => $context->slice,
  81.             'nbFormation' => $nbFormation,
  82.             'actualites' => $actualites,
  83.         ]);
  84.     }
  86.     #[Route('/formation/change-select-ajax', name: 'change-select-ajax')]
  87.     public function changeSelectAjax(
  88.         Request $request,
  89.         PoleRepository $poleRepository,
  90.         DomainesRepository $domainesRepository,
  91.         DiplomesRepository $diplomesRepository,
  92.         ContratsRepository $contratsRepository
  93.     ) {
  94.         $pole = $request->get('pole');
  95.         $poles = [];
  96.         $domaines = [];
  97.         $diplomes = [];
  98.         $contrats = [];
  100.         $poles = $poleRepository->findAll();
  102.         $poleName = $poleRepository->findBy(['name' => $pole]);
  103.         $formations = $this->formationRepository->findBy(['poleId' => $poleName]);
  104.         if (null !== $formations) {
  105.             foreach ($formations as $formation) {
  106.                 if ($formation->getDomaineId()) {
  107.                     $domaineFormation = $domainesRepository->find($formation->getDomaineId()->getId());
  109.                     if (!\in_array($domaineFormation, $domaines, true)) {
  110.                         $domaines[] = $domaineFormation;
  111.                     }
  112.                 }
  114.                 if ($formation->getDiplomeId()) {
  115.                     $diplomeFormation = $diplomesRepository->find($formation->getDiplomeId()->getId());
  116.                     if (!\in_array($diplomeFormation, $diplomes, true)) {
  117.                         $diplomes[] = $diplomeFormation;
  118.                     }
  119.                 }
  121.                 if ($formation->getContratId()) {
  122.                     $contratFormation = $contratsRepository->find($formation->getContratId()->getId());
  124.                     if (!\in_array($contratFormation, $contrats, true)) {
  125.                         $contrats[] = $contratFormation;
  126.                     }
  127.                 }
  128.             }
  129.         }
  131.         // dd($domaines);
  132.         // dd($diplomes);
  134.         /* fonctionne mais avec tomselect cassé */
  136.         return $this->render('front/formation/include/_recherche.html.twig', [
  137.             'poles' => $poles,
  138.             'domaines' => $domaines,
  139.             'diplomes' => $diplomes,
  140.             'contrats' => $contrats,
  141.             'selectedPole' => $poleRepository->findOneBy(['name' => $pole]),
  142.             'formations' => $formations,
  143.         ]);
  144.     }
  146.     #[
  147.         Route('/formation/{formation<[0-9]\d*>}', name: 'app_formation_detail'),
  148.         Route('/formation/{slug}', name: 'app_formation_detail_slug')
  149.     ]
  150.     public function detail(
  151.         ?int $formation,
  152.         ?string $slug
  153.     ): Response {
  154.         if (!$slug) {
  155.             $formation = $this->formationRepository->findOneBy(['id' => $formation]);
  156.         } else {
  157.             $formation = $this->formationRepository->findOneBy(['slug' => $slug]);
  158.         }
  160.         if (null === $formation || (!$this->isGranted('ROLE_ADMIN') && false === $formation->isVisible())) {
  161.             throw $this->createNotFoundException('Page not found');
  162.         }
  164.         if ($this->isGranted('ROLE_ADMIN') && false === $formation->isVisible()) {
  165.             $this->addFlash('success', 'Cette page est visible car vous ête administrateur');
  166.         }
  168.         $formations = $this->formationRepository->findOther($formation);
  170.         $tbBlocFormation = $this->positionBlocsFormationRepository->findBy(
  171.             ['formation' => $formation],
  172.             ['position' => 'ASC']
  173.         );
  175.         return $this->render('front/formation/detail.html.twig', [
  176.             'blocFormation' => $tbBlocFormation,
  177.             'formation' => $formation,
  178.             'formations' => $formations,
  179.         ]);
  180.     }
  181. }