src/Controller/UserController.php line 230

  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\Formation;
  6. use App\Entity\Trainee;
  7. use App\Entity\TraineeFormation;
  8. use App\Entity\User;
  9. use App\Form\RegistrationFormType;
  10. use App\Form\TraineeFormType;
  11. use App\Form\UpdateUserFormType;
  12. use Doctrine\DBAL\Types\TextType;
  13. use PhpOffice\PhpSpreadsheet\Reader\Xlsx;
  14. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  15. use PhpOffice\PhpSpreadsheet\Writer\Xls;
  16. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  17. use Symfony\Component\HttpFoundation\Request;
  18. use Symfony\Component\HttpFoundation\Response;
  19. use Symfony\Component\HttpFoundation\StreamedResponse;
  20. use Symfony\Component\Mailer\MailerInterface;
  21. use Symfony\Component\Mime\Email;
  22. use Symfony\Component\Routing\Annotation\Route;
  23. use Symfony\Component\PasswordHasher\Hasher\UserPasswordHasherInterface;
  24. use Symfony\Component\Security\Core\Security;
  25. use Symfony\Component\Security\Http\Authentication\UserAuthenticatorInterface;
  26. use App\Security\AppAuthenticator;
  27. use Doctrine\ORM\EntityManagerInterface;
  29. class UserController extends AbstractController
  30. {
  31.     /** User CRUD */
  32.     #[Route('/user', name: 'app_user')]
  33.     public function index(EntityManagerInterface $entityManager): Response
  34.     {
  35.         $users = $entityManager->getRepository(User::class)->findUsers("ROLE_SUPER_ADMIN");
  36.         return $this->render('user/index.html.twig', [
  37.             'users' => $users,
  38.         ]);
  39.     }
  41.     #[Route('/user/add', name: 'app_add_user')]
  42.     public function addUser(Request $request, UserPasswordHasherInterface $userPasswordHasher, UserAuthenticatorInterface $userAuthenticator, EntityManagerInterface $entityManager): Response
  43.     {
  44.         $user = new User();
  45.         $form = $this->createForm(RegistrationFormType::class, $user);
  46.         $form->handleRequest($request);
  47.         if ($form->isSubmitted() && $form->isValid()) {
  48.              // Créer une instance de l'entité User avec les données du formulaire
  49.             $user = $form->getData();
  51.             // Définir le rôle de l'utilisateur en tant qu'utilisateur
  52.             $user->setRoles(['ROLE_SUPER_ADMIN']);
  53.             // encode the plain password
  54.             $user->setPassword(
  55.                 $userPasswordHasher->hashPassword(
  56.                     $user,
  57.                     $form->get('password')->getData()
  58.                 )
  59.             );
  60.             $entityManager->persist($user);
  61.             $entityManager->flush();
  62.             // do anything else you need here, like send an email
  63.             return $this->redirectToRoute('app_user');
  64.         }
  65.         return $this->render('user/new.html.twig', [
  66.             'registrationForm' => $form->createView(),
  67.         ]);
  68.     }
  70.     #[Route('/user/profile/{id}', name: 'app_edit_user')]
  71.     public function updateUserProfile(Request $request, EntityManagerInterface $entityManager, $id): Response
  72.     {
  73.         if($id) {
  74.             $user = $entityManager->getRepository(User::class)->findOneBy(['id' => $id]);
  75.         } else {
  76.             $user = $this->getUser();
  77.         }
  78.         $form = $this->createForm(UpdateUserFormType::class, $user);
  79.         $form->handleRequest($request);
  80.         $teacher = false;
  81.         if (in_array('ROLE_TEACHER', $this->getUser()->getRoles(), true)) {
  82.             $teacher = true;
  83.         }
  84.         if ($form->isSubmitted() && $form->isValid()) {
  85.             $user = $form->getData();
  86.             $entityManager->persist($user);
  87.             $entityManager->flush();
  88.             // do anything else you need here, like send an email
  89.             if ($teacher) {
  90.                 return $this->redirectToRoute('app_trainer');
  91.             }
  92.             return $this->redirectToRoute('app_user');
  93.         }
  94.         return $this->render('user/update.html.twig', [
  95.             'setUserForm' => $form->createView(),
  96.             'teacher' => $teacher
  97.         ]);
  98.     }
  99.     /** Trainees CRUD */
  100.     #[Route('/user/trainees', name: 'app_trainees')]
  101.     public function listOfTrainees(EntityManagerInterface $entityManager): Response
  102.     {
  103.         $users = $entityManager->getRepository(Trainee::class)->findBy([],['id' => 'DESC']);
  104.         $isTeacher = false;
  105.         if (in_array('ROLE_TEACHER', $this->getUser()->getRoles(), true)) {
  106.             $isTeacher = true;
  107.         }
  108.         return $this->render('trainees/trainees.html.twig', [
  109.             'users' => $users,
  110.             'base_template' => $isTeacher ? 'baseTeacher.html.twig' : 'baseAdmin.html.twig'
  111.         ]);
  112.     }
  114.     #[Route('/user/addTrainee/{formationId}', name: 'app_add_trainee')]
  115.     public function addTrainees(Request $request, EntityManagerInterface $entityManager, $formationId = null): Response
  116.     {
  117.         $user = new Trainee();
  118.         $type = "";
  119.         $formation = null;
  120.         if ($formationId) {
  121.             $formation = $entityManager->getRepository(Formation::class)->findOneBy(['id' => $formationId]);
  122.             if ($formation) {
  123.                 $type = $formation->getType();
  124.                 if( $formation->getType() == "intra") {
  125.                     $customer = $formation->getCustomers();
  126.                     if ($customer) {
  127.                         $user->setCustomer($customer[0]);
  128.                     }
  129.                 }  
  130.             }
  131.         }
  132.         // hide comments field on the trainee edit view
  133.         $form = $this->createForm(TraineeFormType::class, $user, ['show_comments' => false]);
  134.         $form->handleRequest($request);
  135.         if ($form->isSubmitted() && $form->isValid()) {
  136.             $user = $form->getData();
  137.             $entityManager->persist($user);
  138.             $entityManager->flush();
  139.             if($formationId) {
  140.                 $formation  = $entityManager->getRepository(Formation::class)->findOneBy(['id'=> $formationId]);
  141.                 $TraineeFormation = new TraineeFormation();
  142.                 $TraineeFormation->setTrainee($user);
  143.                 $TraineeFormation->setFormation($formation);
  144.                 $entityManager->persist($TraineeFormation);
  145.                 $entityManager->flush();
  146.                 return $this->redirectToRoute('app_courses_manage', ['idFormation' => $formationId, 'type' => $formation->getType()]);
  147.             } else {
  148.                 return $this->redirectToRoute('app_trainees');
  149.             }
  150.         }
  151.         $isTeacher = false;
  152.         if (in_array('ROLE_TEACHER', $this->getUser()->getRoles(), true)) {
  153.             $isTeacher = true;
  154.         }
  155.         return $this->render('trainees/new_trainee.html.twig', [
  156.             'registrationForm' => $form->createView(),
  157.             'formationId' => $formationId,
  158.             'typeFormation' => $type,
  159.             'base_template' => $isTeacher ? 'baseTeacher.html.twig' : 'baseAdmin.html.twig'
  160.         ]);
  161.     }
  162.     /** Teacher CRUD */
  163.     #[Route('/user/teachers', name: 'app_teachers')]
  164.     public function listOfTeacher(EntityManagerInterface $entityManager): Response
  165.     {
  166.         $users = $entityManager->getRepository(User::class)->findUsers('ROLE_TEACHER');
  167.         return $this->render('user/teachers.html.twig', [
  168.             'users' => $users,
  169.         ]);
  170.     }
  172.     #[Route('/user/addTeacher', name: 'app_add_teacher')]
  173.     public function addTeacher(Request $request, EntityManagerInterface $entityManager, UserPasswordHasherInterface $userPasswordHasher): Response
  174.     {
  175.         $user = new User();
  176.         $form = $this->createForm(UpdateUserFormType::class, $user);
  177.         $form->handleRequest($request);
  178.         if ($form->isSubmitted() && $form->isValid()) {
  179.             $user = $form->getData();
  180.             //set default password for Trainees 00000000
  181.             $user->setPassword(
  182.                 $userPasswordHasher->hashPassword(
  183.                     $user,
  184.                     '00000000'
  185.                 )
  186.             );
  188.             $user->setRoles(['ROLE_TEACHER']);
  189.             $entityManager->persist($user);
  190.             $entityManager->flush();
  191.             return $this->redirectToRoute('app_teachers');
  192.         }
  193.         return $this->render('user/new_teacher.html.twig', [
  194.             'registrationForm' => $form->createView(),
  195.         ]);
  196.     }
  198.     #[Route('/trainee/edit/{id}/{idFormation}', name: 'app_edit_trainee')]
  199.     public function updateTrainee(Request $request, EntityManagerInterface $entityManager, $id, $idFormation = null): Response
  200.     {
  201.         $user = $entityManager->getRepository(Trainee::class)->findOneBy(['id' => $id]);
  202.         $form = $this->createForm(TraineeFormType::class, $user, ['show_comments' => false]);
  203.         $type = "";
  204.         if($idFormation) {
  205.             $formation = $entityManager->getRepository(Formation::class)->findOneBy(['id' => $idFormation]);
  206.             $type = $formation->getType();
  207.         }
  208.         $form->handleRequest($request);
  209.         if ($form->isSubmitted() && $form->isValid()) {
  210.             $user = $form->getData();
  211.             $entityManager->persist($user);
  212.             $entityManager->flush();
  213.             if ($idFormation !== null) {
  214.                 return $this->redirectToRoute('app_courses_manage', ['type' => $type, 'idFormation' => $idFormation]);
  215.             }
  216.             return $this->redirectToRoute('app_trainees');
  217.         }
  218.         $isTeacher = false;
  219.         if (in_array('ROLE_TEACHER', $this->getUser()->getRoles(), true)) {
  220.             $isTeacher = true;
  221.         }
  222.         return $this->render('trainees/update_trainee.html.twig', [
  223.             'setTraineeForm' => $form->createView(),
  224.             'typeFormation' => $type,
  225.             'base_template' => $isTeacher ? 'baseTeacher.html.twig' : 'baseAdmin.html.twig'
  226.         ]);
  227.     }
  229.     #[Route('/update-password', name: 'app_update_password')]
  230.     public function updatePassword(Request $request, EntityManagerInterface $entityManager, MailerInterface $mailer): Response
  231.     {
  232.         if ($request->isMethod('POST')) {
  233.             $email = $request->request->get('email');
  234.             if($email != "") {
  235.                 $user = $entityManager->getRepository(User::class)->findOneBy(['email' => $email]);
  236.                 if ($user) {
  237.                     //send mail to user with token
  238.                     $link = 'https://adformation.online'.$this->generateUrl('app_update_user_password',['email'=>$email]);
  239.                     $emailToSend = (new Email())
  240.                         ->from('noreply-formation@adconseil.eu')
  241.                         ->subject('Modification de mot de passe')
  242.                         ->html('<p>Bonjour, cliquer sur le lien pour modifier votre mot de passe:<br><a href="'.$link.'">'.$link.'</a></p>')
  243.                         ->to($user->getEmail());
  244.                     $mailer->send($emailToSend);
  245.                     $this->addFlash('success', "Un email est envoyé à votre compte.");
  246.                     return $this->redirectToRoute('app_update_password');
  247.                 } else {
  248.                     // show error message
  249.                     $this->addFlash('warning', "Cet email n'existe pas!");
  250.                     return $this->redirectToRoute('app_update_password');
  251.                 }
  252.             }
  253.             return $this->redirectToRoute('app_update_password');
  254.         }
  255.         return $this->render('security/resetPassword.html.twig', [
  256.         ]);
  257.     }
  259.     #[Route('/update-user-password/{email}', name: 'app_update_user_password')]
  260.     public function updateUserPassword(Request $request, EntityManagerInterface $entityManager,UserPasswordHasherInterface $userPasswordHasher, $email): Response
  261.     {
  262.         if ($request->isMethod('POST')) {
  263.             $password= $request->request->get('password');
  264.             if($email != "" && $password != "") {
  265.                 $user = $entityManager->getRepository(User::class)->findOneBy(['email' => $email]);
  266.                 if ($user) {
  267.                     //update password
  268.                     $user->setPassword(
  269.                         $userPasswordHasher->hashPassword(
  270.                             $user,
  271.                             $password
  272.                         )
  273.                     );
  274.                     $entityManager->persist($user);
  275.                     $entityManager->flush();
  276.                     $this->addFlash('success', "Votre mot de passe aura été changé avec succès");
  277.                     return $this->redirectToRoute('app_login');
  278.                 } else {
  279.                     // show error message
  280.                     $this->addFlash('warning', "Le lien est incorrect");
  281.                     return $this->redirectToRoute('app_update_user_password');
  282.                 }
  283.             }
  284.             return $this->redirectToRoute('app_login');
  285.         }
  286.         return $this->render('security/newPassword.html.twig', [
  287.         ]);
  288.     }
  289.     #[Route('/trainee/delete/{id}', name: 'app_delete_trainee')]
  290.     public function deleteTrainee(EntityManagerInterface $entityManager, $id): Response
  291.     {
  292.         $trainee = $entityManager->getRepository(Trainee::class)->findOneBy(['id' => $id]);
  293.         $traineeFormation = $entityManager->getRepository(TraineeFormation::class)->findBy(['trainee' => $trainee]);
  294.         //find if trainee is affected to formation
  295.         $object = new \stdClass();
  296.         if($traineeFormation) {
  297.             foreach ($traineeFormation as $trfor) {
  298.                  $entityManager->remove($trfor);
  299.             }
  300.             $entityManager->flush();
  301.         }
  303.         $entityManager->remove($trainee);
  304.         $entityManager->flush();
  305.         $object->status = true;
  306.         $object->message = "Le stagiaire est supprimé avec succès";
  307.         return new Response(json_encode($object));
  308.     }
  309.     #[Route('/teacher/delete/{id}', name: 'app_delete_teacher')]
  310.     public function deleteTeacher(EntityManagerInterface $entityManager, $id): Response
  311.     {
  312.         $teacher = $entityManager->getRepository(User::class)->findOneBy(['id' => $id]);
  313.         //find if trainee is affected to formation
  314.         $teacherFormation = $entityManager->getRepository(Formation::class)->findOneBy(['formateur' => $teacher]);
  315.         $object = new \stdClass();
  316.         if ($teacherFormation) {
  317.             $object->status = false;
  318.             $object->message = "Ce formateur est enregistré dans une formation et il est impossible de le supprimer.";
  319.         } else {
  320.             $entityManager->remove($teacher);
  321.             $entityManager->flush();
  322.             $object->status = true;
  323.             $object->message = "Le formateur est supprimé avec succès";
  324.         }
  325.         return new Response(json_encode($object));
  326.     }
  328.     #[Route('/user/delete/{id}', name: 'app_delete_user')]
  329.     public function deleteUser(EntityManagerInterface $entityManager, $id): Response
  330.     {
  331.         $user = $entityManager->getRepository(User::class)->findOneBy(['id' => $id]);
  332.         $object = new \stdClass();
  333.         $entityManager->remove($user);
  334.         $entityManager->flush();
  335.         $object->status = true;
  336.         $object->message = "L'utilisateur est supprimé avec succès";
  337.         return new Response(json_encode($object));
  338.     }
  340.     #[Route('/downloadTrainee', name: 'app_download_trainee')]
  341.     public function downloadTrainee(EntityManagerInterface $entityManager): Response
  342.     {
  343.         $users = $entityManager->getRepository(Trainee::class)->findBy([],['id' => 'DESC']);
  344.         $spreadsheet = new Spreadsheet();
  345.         $sheet = $spreadsheet->getActiveSheet();
  346.         $sheet->setCellValue('A1', 'Nom');
  347.         $sheet->setCellValue('B1', 'Prénom');
  348.         $sheet->setCellValue('C1', 'Fonction');
  349.         $sheet->setCellValue('D1', 'Email');
  350.         $counter = 2;
  351.         foreach ($users as $user) {
  352.             $sheet->setCellValue('A' . $counter, $user->getFirstName());
  353.             $sheet->setCellValue('B' . $counter, $user->getLastName());
  354.             $sheet->setCellValue('C' . $counter, $user->getPosition());
  355.             $sheet->setCellValue('D' . $counter, $user->getEmail());
  356.             $counter++;
  357.         }
  358.         $writer = new Xls($spreadsheet);
  359.         $response =  new StreamedResponse(
  360.             function () use ($writer) {
  361.                 $writer->save('php://output');
  362.             }
  363.         );
  364.         $fileName = "ExportEmails_".date('m-d-Y_hia').".xls";
  365.         $response->headers->set('Content-Type', 'application/vnd.ms-excel');
  366.         $response->headers->set('Content-Disposition', 'attachment; filename=' . '"' . $fileName . '"');
  367.         $response->headers->set('Cache-Control','max-age=0');
  368.         return $response;
  369.         //$this->addFlash('success', "Les stagiaires sont télechargées avec succès.");
  370.        // return $this->redirectToRoute('app_trainees');
  371.     }
  373.     #[Route('/downloadTraineeByFormation/{idFormation}', name: 'app_download_trainee_by_formation')]
  374.     public function downloadTraineeByFormation(EntityManagerInterface $entityManager, $idFormation = null): Response
  375.     {
  376.         $course =  $entityManager->getRepository(Formation::class)->find($idFormation);
  377.         $formationUser = $entityManager->getRepository(TraineeFormation::class)->findBy(['formation' => $course]);
  378.         $spreadsheet = new Spreadsheet();
  379.         $sheet = $spreadsheet->getActiveSheet();
  380.         $sheet->setCellValue('A1', 'Nom');
  381.         $sheet->setCellValue('B1', 'Prénom');
  382.         $sheet->setCellValue('C1', 'Fonction');
  383.         $sheet->setCellValue('D1', 'Email');
  384.         $counter = 2;
  385.         foreach ($formationUser as $item) {
  386.             $sheet->setCellValue('A' . $counter, $item->getTrainee()->getFirstName());
  387.             $sheet->setCellValue('B' . $counter, $item->getTrainee()->getLastName());
  388.             $sheet->setCellValue('C' . $counter, $item->getTrainee()->getPosition());
  389.             $sheet->setCellValue('D' . $counter, $item->getTrainee()->getEmail());
  390.             $counter++;
  391.         }
  392.         $writer = new Xls($spreadsheet);
  393.         $response =  new StreamedResponse(
  394.             function () use ($writer) {
  395.                 $writer->save('php://output');
  396.             }
  397.         );
  398.         $fileName = "ExportEmails_".str_replace(' ','',$course->getNomFormation())."_".date('m-d-Y_hia').".xls";
  399.         $response->headers->set('Content-Type', 'application/vnd.ms-excel');
  400.         $response->headers->set('Content-Disposition', 'attachment; filename=' . '"' . $fileName . '"');
  401.         $response->headers->set('Cache-Control','max-age=0');
  402.         return $response;
  403.         //$this->addFlash('success', "Les stagiaires sont télechargées avec succès.");
  404.         // return $this->redirectToRoute('app_trainees');
  405.     }
  407.     #[Route('/user/profileAdmin/{id}', name: 'app_edit_admin')]
  408.     public function updateAdminProfile(Request $request, EntityManagerInterface $entityManager, $id): Response
  409.     {
  410.         if($id) {
  411.             $user = $entityManager->getRepository(User::class)->findOneBy(['id' => $id]);
  412.         } else {
  413.             $user = $this->getUser();
  414.         }
  415.         $form = $this->createForm(UpdateUserFormType::class, $user);
  416.         $form->handleRequest($request);
  417.         $teacher = false;
  418.         if (in_array('ROLE_TEACHER', $this->getUser()->getRoles(), true)) {
  419.             $teacher = true;
  420.         }
  421.         if ($form->isSubmitted() && $form->isValid()) {
  422.             $user = $form->getData();
  423.             $entityManager->persist($user);
  424.             $entityManager->flush();
  425.             // do anything else you need here, like send an email
  426.             if ($teacher) {
  427.                 return $this->redirectToRoute('app_trainer');
  428.             }
  429.             return $this->redirectToRoute('app_user');
  430.         }
  431.         return $this->render('user/update.html.twig', [
  432.             'setUserForm' => $form->createView(),
  433.             'teacher' => $teacher
  434.         ]);
  435.     }
  437.     #[Route('/user/profileFormateur/{id}', name: 'app_edit_formateur')]
  438.     public function updateFormateurProfile(Request $request, EntityManagerInterface $entityManager, $id): Response
  439.     {
  440.         if($id) {
  441.             $user = $entityManager->getRepository(User::class)->findOneBy(['id' => $id]);
  442.         } else {
  443.             $user = $this->getUser();
  444.         }
  445.         $form = $this->createForm(UpdateUserFormType::class, $user);
  446.         $form->handleRequest($request);
  447.         $teacher = false;
  448.         if (in_array('ROLE_TEACHER', $this->getUser()->getRoles(), true)) {
  449.             $teacher = true;
  450.         }
  451.         if ($form->isSubmitted() && $form->isValid()) {
  452.             $user = $form->getData();
  453.             $entityManager->persist($user);
  454.             $entityManager->flush();
  455.             // do anything else you need here, like send an email
  456.             if ($teacher) {
  457.                 return $this->redirectToRoute('app_trainer');
  458.             }
  459.             return $this->redirectToRoute('app_user');
  460.         }
  461.         return $this->render('user/update.html.twig', [
  462.             'setUserForm' => $form->createView(),
  463.             'teacher' => $teacher
  464.         ]);
  465.     }
  467.     #[Route('/user/loginTeacher/{id}', name: 'app_login_formateur')]
  468.     public function loginTeacher(EntityManagerInterface $entityManager,
  469.                                  UserAuthenticatorInterface $userAuthenticator,
  470.                                  AppAuthenticator $authenticator,
  471.                                  Request $request,
  472.         $id): Response
  473.     {
  474.         if (in_array('ROLE_SUPER_ADMIN', $this->getUser()->getRoles(), true)) {
  475.             $admin =$this->getUser();
  476.             $request->getSession()->set('adminId', $admin->getId());
  477.         }
  479.         // Load the user by ID (assuming Doctrine)
  480.         $user = $entityManager->getRepository(User::class)->findOneBy(['id' => $id]);
  481.         // Authenticate the user
  482.         $userAuthenticator->authenticateUser($user, $authenticator, $request);
  484.         // Redirect to homepage (or another route)
  485.         if (in_array('ROLE_SUPER_ADMIN', $this->getUser()->getRoles(), true)) {
  486.             return $this->redirectToRoute('app_home');
  487.         } else {
  488.             return $this->redirectToRoute('app_home_trainer');
  489.         }
  491.     }
  492. }