src/Controller/HomeController.php line 15

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Repository\TrainingsRepository;
  6. use Doctrine\DBAL\Exception;
  7. use Doctrine\ORM\EntityManagerInterface;
  8. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  9. use Symfony\Component\HttpFoundation\Response;
  10. use Symfony\Component\Routing\Annotation\Route;
  12. class HomeController extends AbstractController
  13. {
  14.     #[Route('/', name: 'home')]
  15.     public function home(TrainingsRepository $fichesRepository): Response
  16.     {
  17.         if($this->getUser()){
  18.             $roles = $this->getUser()->getRoles();
  20.             if (in_array('ROLE_SUPER_ADMIN', $roles)) {
  21.                 return $this->render('admin/admin.html.twig');
  22.             } elseif (in_array('ROLE_COMMERCIAL', $roles)) {
  23.                 return $this->render('commercial/commercial.html.twig', [
  24.                     'fiches' => $fichesRepository->findBy(['owner' => $this->getUser(), 'isFiche' => true], ['creationDate' => 'ASC'], 15),
  25.                 ]);
  26.             } elseif (in_array('ROLE_ADMIN', $roles)) {
  27.                 return $this->render('adminDesktop.html.twig', [
  28.                     'proposals' => $fichesRepository->findBy(['isFiche' => true],['creationDate' => 'DESC'], 10),
  29.                     'fiches' => $fichesRepository->findBy(['isFiche' => false],['creationDate' => 'DESC'], 10),
  30.                 ]);
  31.             }
  32.         }else {
  33.             return $this->redirectToRoute('login');
  34.         }
  36.     }
  38.     /**
  39.      * @throws Exception
  40.      */
  41.     #[Route('/test', name: 'test')]
  42.     public function test(EntityManagerInterface $entityManager): Response
  43.     {
  44.         $queryBuilder = $entityManager->getConnection();
  46.         $sql = "SELECT * FROM isens_pages";
  48.         $query = $queryBuilder->prepare($sql);
  50.         $result = $query->executeQuery();
  52.         $results = $result->fetchAllAssociative();
  54. //        foreach($results as $dataSeo) {
  55. /*            $arraySeo = explode('?>',$dataSeo['corps']);*/
  56. //        }
  58.         return $this->render('admin/admin.html.twig');
  59.     }
  60. }