src/Controller/School/SchoolTeacherController.php line 48

Open in your IDE?
  1. <?php
  3. namespace App\Controller\School;
  5. use Knp\Snappy\Pdf;
  6. use App\Entity\User;
  7. use App\Entity\RhSalary;
  8. use App\Entity\SettingRoom;
  9. use App\Entity\SchoolMatter;
  10. use App\Entity\SchoolTeacher;
  11. use App\Entity\SettingClassroom;
  12. use App\Entity\SettingTimeTable;
  13. use App\Entity\SchoolWorkingTime;
  14. use App\Repository\UserRepository;
  15. use App\Entity\SchoolTeacherTimeSheet;
  16. use App\Form\School\SchoolTeacherType;
  17. use App\Repository\RhSalaryRepository;
  18. use App\Repository\SettingRoomRepository;
  19. use App\Repository\SchoolMatterRepository;
  20. use App\Entity\SchoolWorkingTimeHourLesson;
  21. use App\Repository\SchoolTeacherRepository;
  22. use Knp\Component\Pager\PaginatorInterface;
  23. use App\Entity\SchoolTeacherMatterClassroom;
  24. use Symfony\Component\HttpFoundation\Request;
  25. use App\Repository\EquivalentMatterRepository;
  26. use App\Repository\SettingClassroomRepository;
  27. use App\Repository\SettingTimeTableRepository;
  28. use Symfony\Component\HttpFoundation\Response;
  29. use App\Repository\SchoolWorkingTimeRepository;
  30. use Symfony\Component\Routing\Annotation\Route;
  31. use Doctrine\Common\Collections\ArrayCollection;
  32. use Symfony\Bridge\Doctrine\Form\Type\EntityType;
  33. use App\Form\School\SchoolWorkingTimeHourLessonType;
  34. use App\Form\School\SchoolTeacherMatterClassroomType;
  35. use App\Repository\SchoolWorkingTimeHourLessonRepository;
  36. use App\Repository\SchoolTeacherMatterClassroomRepository;
  37. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  38. use Symfony\Component\PasswordHasher\Hasher\UserPasswordHasherInterface;
  40. /**
  41.  * @Route("/school/teacher")
  42.  */
  43. class SchoolTeacherController extends AbstractController
  44. {
  45.     /**
  46.      * @Route("/index", name="school_teacher_index", methods={"GET"})
  47.      */
  48.     public function index(Request $request, PaginatorInterface $paginator, SchoolTeacherRepository $schoolTeacherRepository): Response
  49.     {
  50.         /**@var User $user */
  51.         $user = $this->getUser();
  52.         $schoolYear = $user->getSchoolYear();
  54.         $establishment = $this->getUser()->getEstablishment();
  55.         $school_teachers = $paginator->paginate(
  56.             $schoolTeacherRepository->createQueryBuilder('entity')
  58.             ->innerJoin('entity.establishment', 'establishment')
  59.             ->addSelect('establishment')
  61.             ->andWhere('establishment.establishmentGroup = :establishmentGroup')
  62.             ->setParameter('establishmentGroup', $establishment->getEstablishmentGroup())
  64.             ->andWhere('entity.schoolYear = :schoolYear')
  65.             ->setParameter('schoolYear', $schoolYear)
  67.             ->orderBy('entity.id', 'DESC')
  68.             ->getQuery(),
  69.             $request->query->getInt('page', 1),
  70.             1000
  71.         );
  73.         return $this->render('school/school_teacher/index.html.twig', [
  74.             'school_teachers' => $school_teachers,
  75.         ]);
  76.     }
  78.     /**
  79.      * @Route("/new", name="school_teacher_new", methods={"GET","POST"})
  80.      */
  81.     public function new(Request $request, RhSalaryRepository $rhSalaryRepository, SchoolTeacherRepository $schoolTeacherRepository): Response
  82.     {
  83.         /**@var User $user */
  84.         $user = $this->getUser();
  85.         $schoolYear = $user->getSchoolYear();
  87.         $establishment = $this->getUser()->getEstablishment();
  88.         $salaries = $rhSalaryRepository->createQueryBuilder('entity')
  89.         ->innerJoin('entity.establishment', 'establishment')
  90.         ->addSelect('establishment')
  92.         ->andWhere('establishment.establishmentGroup = :establishmentGroup')
  93.         ->setParameter('establishmentGroup', $establishment->getEstablishmentGroup())
  95.         ->orderBy('entity.last_name', 'ASC')
  96.         ->getQuery()
  97.         ->getResult();
  99.         $notTeacherSalaries = new ArrayCollection();
  100.         foreach ($salaries as $key => $salarie) {
  101.             //if (count($salarie->getSchoolTeachers()) <= 0 ) {
  102.                 if (!$notTeacherSalaries->contains($salarie)) {
  103.                     $notTeacherSalaries->add($salarie);
  104.                 }
  105.             //}
  106.         }
  108.         $schoolTeacher = new SchoolTeacher();
  110.         $form = $this->createForm(SchoolTeacherType::class, $schoolTeacher)
  111.         ->add('salary', EntityType::class, [
  112.             'class' => RhSalary::class,
  113.             'choices' => $notTeacherSalaries
  114.         ]);
  116.         $form->handleRequest($request);
  118.         if ($form->isSubmitted() && $form->isValid()) {
  119.             $teacher = $schoolTeacherRepository->findOneBy(['salary' => $schoolTeacher->getSalary(), 'schoolYear' => $schoolYear], []);
  120.             if (null != $teacher) {
  121.                 $this->addFlash('info', "Impossible: Cet enseignant existe déjà.");
  122.                 return $this->redirectToRoute('school_teacher_new');
  123.             }
  125.             $entityManager = $this->getDoctrine()->getManager();
  126.             $schoolTeacher->setEstablishment($establishment);
  127.             $schoolTeacher->setSchoolYear($schoolYear);
  128.             $entityManager->persist($schoolTeacher);
  129.             try {
  130.                 $entityManager->flush();
  131.                 $this->addFlash('success', "Une classe à été ajoutée.");
  132.             } catch (\Throwable $th) {
  133.                 $this->addFlash('warning', "Une erreure est survenue lors de l'ajout de la classe.");
  134.                 $this->addFlash('info', $th->getMessage());
  135.                 return $this->redirectToRoute('school_teacher_new');
  136.             }
  138.             return $this->redirectToRoute('school_teacher_edit', ['id' => $schoolTeacher->getId()]);
  139.         }
  141.         return $this->renderForm('school/school_teacher/new.html.twig', [
  142.             'school_teacher' => $schoolTeacher,
  143.             'form' => $form,
  144.         ]);
  145.     }
  147.     /**
  148.      * @Route("/{id}/edit", name="school_teacher_edit", methods={"GET","POST"})
  149.      */
  150.     public function edit(Request $request, SchoolTeacher $schoolTeacher, SchoolMatterRepository $schoolMatterRepository, SettingClassroomRepository $settingClassroomRepository, RhSalaryRepository $rhSalaryRepository, SchoolTeacherMatterClassroomRepository $schoolTeacherMatterClassroomRepository, SchoolTeacherRepository $schoolTeacherRepository): Response
  151.     {
  152.         /**@var User $user */
  153.         $user = $this->getUser();
  154.         $schoolYear = $user->getSchoolYear();
  156.         $establishment = $user->getEstablishment();
  157.         $classrooms = $settingClassroomRepository->findBy(['establishment' => $establishment, 'schoolYear' => $schoolYear], []);
  159.         $matters = $schoolMatterRepository->findBy(['establishment' => $establishment], []);
  160.         $matterCollections = new ArrayCollection();
  161.         foreach ($matters as $key => $matter) {
  162.             if ($schoolTeacher->getEquivalentMatters()->contains($matter->getEquivalentMatter())) {
  163.                 $matterCollections->add($matter);
  164.             }
  165.         }
  167.         $notTeacherSalaries = $rhSalaryRepository->createQueryBuilder('entity')
  169.             ->innerJoin('entity.establishment', 'establishment')
  170.             ->addSelect('establishment')
  172.             ->andWhere('establishment.establishmentGroup = :establishmentGroup')
  173.             ->setParameter('establishmentGroup', $establishment->getEstablishmentGroup())
  175.             ->andWhere('entity.last_name = :last_name')
  176.             ->setParameter('last_name', $schoolTeacher->getSalary()->getLastName())
  178.             ->andWhere('entity.first_name = :first_name')
  179.             ->setParameter('first_name', $schoolTeacher->getSalary()->getFirstName())
  181.             ->orderBy('entity.last_name', 'ASC')
  182.             ->getQuery()
  183.             ->getResult();
  184.         
  185.         //$notTeacherSalaries = $rhSalaryRepository->findBy(['establishment' => $establishment], ['last_name' => 'ASC']);
  186.         if (!$this->isGranted("ROLE_EMPLOI_DU_TEMPS")) {
  187.             $notTeacherSalaries = new ArrayCollection();
  188.             $notTeacherSalaries->add($schoolTeacher->getSalary());
  189.         }
  190.         
  192.         $form = $this->createForm(SchoolTeacherType::class, $schoolTeacher)
  193.         ->add('salary', EntityType::class, [
  194.             'class' => RhSalary::class,
  195.             'choices' => $notTeacherSalaries
  196.         ]);
  197.         $form->handleRequest($request);
  199.         if ($form->isSubmitted() && $form->isValid()) {
  200.             $teacher = $schoolTeacherRepository->findOneBy(['salary' => $schoolTeacher->getSalary(), 'schoolYear' => $schoolYear], []);
  201.             if (null != $teacher) {
  202.                 if ($teacher != $schoolTeacher) {
  203.                     $this->addFlash('info', "Impossible: Cet enseignant existe déjà.");
  204.                     return $this->redirectToRoute('school_teacher_edit', ['id' => $schoolTeacher->getId()]);
  205.                 }
  206.             }
  208.             try {
  209.                 $this->getDoctrine()->getManager()->flush();
  210.                 $this->addFlash('success', "la classe à été édité.");
  211.             } catch (\Throwable $th) {
  212.                 $this->addFlash('warning', "Une erreure est survenue lors de l'édition de la classe.");
  213.                 $this->addFlash('info', $th->getMessage());
  214.                 return $this->redirectToRoute('school_teacher_edit', ['id' => $schoolTeacher->getId()]);
  215.             }
  216.         }
  218.         $schoolTeacherMatterClassroom = new SchoolTeacherMatterClassroom();
  219.         $schoolTeacherMatterClassroomForm = $this->createForm(SchoolTeacherMatterClassroomType::class, $schoolTeacherMatterClassroom)
  220.         ->add('matter', EntityType::class, [
  221.             'class' => SchoolMatter::class,
  222.             'choices' => $matterCollections
  223.         ])
  225.         ->add('classroom', EntityType::class, [
  226.             'class' => SettingClassroom::class,
  227.             'choices' => $classrooms
  228.         ]);
  230.         $schoolTeacherMatterClassroomForm->handleRequest($request);
  232.         if ($schoolTeacherMatterClassroomForm->isSubmitted() && $schoolTeacherMatterClassroomForm->isValid()) {
  233.             $entityManager = $this->getDoctrine()->getManager();
  234.             if ($schoolTeacherMatterClassroom->getMatter()->getLevel() != $schoolTeacherMatterClassroom->getClassroom()->getLevel()) {
  235.                 $this->addFlash('warning', "La matière selectionnée doit être dans le même niveau que la classe");
  236.                 return $this->redirectToRoute('school_teacher_edit', ['id' => $schoolTeacher->getId()]);
  237.             }
  239.             $_schoolTeacherMatterClassroom = $schoolTeacherMatterClassroomRepository->findOneBy(['classroom' => $schoolTeacherMatterClassroom->getClassroom(), 'matter' => $schoolTeacherMatterClassroom->getMatter(), 'is_disabled' => 0], []);
  240.             if (null != $_schoolTeacherMatterClassroom) {
  241.                 $this->addFlash('warning', "Un enseignant (" .$_schoolTeacherMatterClassroom->getTeacher()->getName(). ") est déjà affecté à cette matière dans cette classe.");
  242.                 return $this->redirectToRoute('school_teacher_edit', ['id' => $schoolTeacher->getId()]);
  243.             }
  245.             $schoolTeacherMatterClassroom->setTeacher($schoolTeacher);
  246.             $schoolTeacherMatterClassroom->setEstablishment($establishment);
  247.             $schoolTeacherMatterClassroom->setSchoolYear($schoolTeacher->getSchoolYear());
  249.             $entityManager->persist($schoolTeacherMatterClassroom);
  250.             try {
  251.                 $this->getDoctrine()->getManager()->flush();
  252.                 $this->addFlash('success', "Enrégistrement effectué avec succès.");
  253.             } catch (\Throwable $th) {
  254.                 $this->addFlash('warning', "Une erreure est survenue lors de l'édition de l'enseignant.");
  255.                 $this->addFlash('info', $th->getMessage());
  256.                 return $this->redirectToRoute('school_teacher_edit', ['id' => $schoolTeacher->getId()]);
  257.             }
  258.         }
  260.         return $this->renderForm('school/school_teacher/edit.html.twig', [
  261.             'school_teacher' => $schoolTeacher,
  262.             'form' => $form,
  264.             'school_teacher_matter_classroom' => $schoolTeacherMatterClassroom,
  265.             'school_teacher_matter_classroom_form' => $schoolTeacherMatterClassroomForm,
  266.         ]);
  267.     }
  269.     /**
  270.      * @Route("/delete-selection", name="school_teachers_selected_delete", methods={"GET"})
  271.     */
  272.     public function deleteSelected(Request $request, SchoolTeacherRepository $entityRepository): Response
  273.     {
  274.         $list = $request->get('entities');
  275.         $entityManager = $this->getDoctrine()->getManager();
  276.         $errors = 0;
  277.         foreach ($list as $key => $id) {
  278.             $entity = $entityRepository->findOneBy(['id' => intval($id)], []);
  279.             if ($entity != null) {
  280.                 foreach ($entity->getSchoolTeacherMatterClassrooms() as $key => $schoolTeacherMatterClassroom) {
  281.                     $schoolTeacherMatterClassroom->setIsDisabled(true);
  282.                 }
  284.                 $entity->setIsDisabled(true);
  285.                 //$entityManager->remove($entity);
  286.             }
  287.         }
  289.         try {
  290.             $entityManager->flush();
  291.             $this->addFlash('success', "Traitement effectué");
  292.             return $this->json(['code' => 200, 'message' => "Traitement effectué :)"], 200);
  293.         } catch (\Throwable $th) {
  294.             //$th->getMessage()
  295.             $this->addFlash('warning', $th->getMessage());
  296.         }
  297.         
  298.         $this->addFlash('warning', "Traitement non effectué");
  299.         return $this->json(['code' => 500, 'message' => "Traitement non effectué"], 200);
  300.     }
  302.     /**
  303.      * @Route("/api/new-get-classroom-matters", name="api_school_teacher_new_get_classroom_matters", methods={"GET"})
  304.     */
  305.     public function apiNewGetClassroomMatters(Request $request, SettingClassroomRepository $settingClassroomRepository, SchoolMatterRepository $schoolMatterRepository, SchoolTeacherRepository $schoolTeacherRepository, EquivalentMatterRepository $equivalentMatterRepository): Response
  306.     {
  307.         $equivalentMatterList = $request->get('equivalentMatters');
  308.         $classroomList = $request->get('classrooms');
  309.         $schoolMatters = new ArrayCollection();
  310.         if (count($classroomList) > 0) {
  311.         
  312.             foreach ($classroomList as $key => $id) {
  313.                 $classroom = $settingClassroomRepository->findOneBy(['id' => intval($id)], []);
  314.                 if ($classroom != null) {
  315.                     foreach ($equivalentMatterList as $key => $id) {
  316.                         $equivalentMatter = $equivalentMatterRepository->findOneBy(['id' => intval($id)], []);
  317.                         if ($equivalentMatter != null) {
  318.                             foreach ($schoolMatterRepository->findBy(['equivalentMatter' => $equivalentMatter, 'level' => $classroom->getLevel(), 'is_test_matter' => 0], []) as $key => $matter) {
  319.                                 $isTeach = false;
  320.                                 foreach ($schoolTeacherRepository->findBy(['establishment' => $classroom->getEstablishment()], []) as $key => $_teacher) {
  321.                                     if ($_teacher->getClassrooms()->contains($classroom) && $_teacher->getMatters()->contains($matter)) {
  322.                                         $isTeach = true;
  323.                                         break;
  324.                                     }
  325.                                 }
  326.                                 if (!$isTeach) {
  327.                                     $sMatter = [
  328.                                         'id' => $matter->getId(),
  329.                                         'label' => $matter->getLevel()->getLabel().' '.$matter->getLabel(),
  330.                                     ];
  332.                                     if (!$schoolMatters->contains($sMatter)) {
  333.                                         $schoolMatters->add($sMatter);
  334.                                     }
  335.                                     
  336.                                 }
  337.                             }
  338.                         }
  339.                     }
  340.                 }
  341.             }
  342.         }
  343.         
  344.         return $this->json([
  345.             'code' => 200, 
  346.             'message' => "found :)", 
  347.             'schoolMatters' => $schoolMatters,
  348.             'classrooms' => $classroomList 
  349.         ], 
  350.         200);
  351.         
  352.     }
  354.     /**
  355.      * @Route("/print/list-by-classroom", name="school_teacher_print_list_by_classroom")
  356.     */
  357.     public function print_list_by_classroom(Pdf $knpSnappyPdf, SettingClassroomRepository $settingClassroomRepository): Response
  358.     {
  359.         /**@var User $user */
  360.         $user = $this->getUser();
  361.         $schoolYear = $user->getSchoolYear();
  362.         
  363.         $establishment = $this->getUser()->getEstablishment();
  365.         $setting_classrooms = $settingClassroomRepository->createQueryBuilder('entity')
  366.             ->andWhere('entity.establishment = :establishment')
  367.             ->setParameter('establishment', $establishment)
  369.             ->andWhere('entity.schoolYear = :schoolYear')
  370.             ->setParameter('schoolYear', $schoolYear)
  372.             ->orderBy('entity.id', 'DESC')
  373.             ->getQuery()
  374.             ->getResult();
  376.         $html = $this->renderView('school/print/list_by_classroom.html.twig', [
  377.             'setting_classrooms' => $setting_classrooms,
  378.             
  379.             'school_year' => $schoolYear,
  380.             'setting' => $establishment,
  381.         ]);
  383.         $file_name = "LISTE_ENSEIGNANT_PAR_CLASSE.pdf";
  385.         $footer = $this->renderView('print/footer.html.twig', ['setting' => $establishment,]);
  386.         $header = $this->renderView('print/header.html.twig', ['setting' => $establishment,]);
  388.         $options = [
  389.             'orientation' => 'Portrait',
  390.             'header-html' => $header
  391.             //'footer-html' => $footer
  392.         ];
  393.         
  394.         $knpSnappyPdf->generateFromHtml($html, $this->getParameter('app.app_directory').'/downloads/rapport/' . $file_name, $options, true);
  396.         return $this->redirectToRoute('preview', [
  397.             'file' => $file_name,
  398.             'dir' => 'rapport',
  399.         ]);
  400.     }
  402.     /**
  403.      * @Route("/print/list-by-teacher", name="school_teacher_print_list_by_teacher")
  404.     */
  405.     public function print_list_by_teacher(Pdf $knpSnappyPdf, SchoolTeacherRepository $schoolTeacherRepository): Response
  406.     {
  407.         /**@var User $user */
  408.         $user = $this->getUser();
  409.         $schoolYear = $user->getSchoolYear();
  410.         $establishment = $user->getEstablishment();
  412.         $school_teachers = $schoolTeacherRepository->createQueryBuilder('entity')
  413.             ->andWhere('entity.establishment = :establishment')
  414.             ->setParameter('establishment', $establishment)
  416.             ->andWhere('entity.schoolYear = :schoolYear')
  417.             ->setParameter('schoolYear', $schoolYear)
  419.             ->andWhere('entity.is_disabled = :is_disabled')
  420.             ->setParameter('is_disabled', 0)
  422.             ->orderBy('entity.id', 'DESC')
  423.             ->getQuery()
  424.             ->getResult();
  426.         $html = $this->renderView('school/print/list_by_teacher.html.twig', [
  427.             'school_teachers' => $school_teachers,
  428.             
  429.             'school_year' => $schoolYear,
  430.             'setting' => $establishment,
  431.         ]);
  433.         $file_name = "LISTE_ENSEIGNANT_PAR_CLASSE_ET_MATIERE.pdf";
  435.         $footer = $this->renderView('print/footer.html.twig', ['setting' => $establishment,]);
  436.         $header = $this->renderView('print/header.html.twig', ['setting' => $establishment,]);
  438.         $options = [
  439.             'orientation' => 'Portrait',
  440.             'header-html' => $header
  441.             //'footer-html' => $footer
  442.         ];
  443.         
  444.         $knpSnappyPdf->generateFromHtml($html, $this->getParameter('app.app_directory').'/downloads/rapport/' . $file_name, $options, true);
  446.         return $this->redirectToRoute('preview', [
  447.             'file' => $file_name,
  448.             'dir' => 'rapport',
  449.         ]);
  450.     }
  452.     /**
  453.      * @Route("/api/edit-get-matters", name="api_school_teacher_edit_get_matters", methods={"GET"})
  454.     */
  455.     public function apiEditMatters(Request $request, SettingClassroomRepository $settingClassroomRepository, SchoolMatterRepository $schoolMatterRepository, SchoolTeacherRepository $schoolTeacherRepository): Response
  456.     {
  457.         $idClassroom = $request->get('idClassroom');
  458.         $idTeacher = intval($request->get('idTeacher'));
  460.         $teacher = $schoolTeacherRepository->findOneBy(['id' => $idTeacher], []);
  461.         $classroom = $settingClassroomRepository->findOneBy(['id' => $idClassroom], []);
  463.         $matters = new ArrayCollection();
  465.         $establishment = $this->getUser()->getEstablishment();
  466.         
  467.         $schoolMatters = $schoolMatterRepository->createQueryBuilder('entity')
  468.         /* ->innerJoin('entity.establishment', 'establishment')
  469.         ->addSelect('establishment')
  471.         ->andWhere('establishment.establishmentGroup = :establishmentGroup')
  472.         ->setParameter('establishmentGroup', $establishment->getEstablishmentGroup()) */
  474.         ->andWhere('entity.establishment = :establishment')
  475.         ->setParameter('establishment', $establishment)
  477.         ->andWhere('entity.level = :level')
  478.         ->setParameter('level', $classroom->getLevel())
  480.         ->andWhere('entity.is_test_matter = :is_test_matter')
  481.         ->setParameter('is_test_matter', 0)
  483.         ->orderBy('entity.label', 'ASC')
  484.         ->getQuery()
  485.         ->getResult(); 
  487.         foreach ($schoolMatters as $key => $matter) {
  488.             if ($teacher->getEquivalentMatters()->contains($matter->getEquivalentMatter())) {
  489.                 $matters->add([
  490.                     'id' => $matter->getId(),
  491.                     'label' => $matter->getLevel()->getLabel().' '.$matter->getLabel(),
  492.                 ]);
  493.                 
  494.             }
  495.         }
  497.         return $this->json([
  498.             'code' => 200, 
  499.             'message' => "found :)", 
  500.             'schoolMatters' => $matters,
  501.         ], 
  502.         200);
  503.     } 
  505.     /**
  506.      * @Route("/{id}/enabled", name="school_teacher_enabled", methods={"GET"})
  507.     */
  508.     public function enabled(SchoolTeacher $entity): Response
  509.     {
  510.         $entityManager = $this->getDoctrine()->getManager();
  511.         foreach ($entity->getSchoolTeacherMatterClassrooms() as $key => $schoolTeacherMatterClassroom) {
  512.             $schoolTeacherMatterClassroom->setIsDisabled(false);
  513.         }
  515.         $entity->setIsDisabled(false);
  517.         try {
  518.             $entityManager->flush();
  519.             $this->addFlash('success', "Traitement effectué");
  520.             return $this->json(['code' => 200, 'message' => "Traitement effectué :)"], 200);
  521.         } catch (\Throwable $th) {
  522.             //$th->getMessage()
  523.             $this->addFlash('warning', $th->getMessage());
  524.         }
  525.         
  526.         $this->addFlash('warning', "Traitement non effectué");
  527.         return $this->json(['code' => 500, 'message' => "Traitement non effectué"], 200);
  528.     }
  530.     /**
  531.      * @Route("/{id}/time-sheet", name="school_teacher_time_sheet", methods={"GET","POST"})
  532.      */
  533.     public function time_sheet(Request $request, SchoolTeacher $schoolTeacher, SchoolMatterRepository $schoolMatterRepository, SettingClassroomRepository $settingClassroomRepository, SettingRoomRepository $settingRoomRepository, SettingTimeTableRepository $settingTimeTableRepository, SchoolWorkingTimeRepository $schoolWorkingTimeRepository, SchoolWorkingTimeHourLessonRepository $schoolWorkingTimeHourLessonRepository): Response
  534.     {
  535.         /**@var User $user */
  536.         $user = $this->getUser();
  537.         $schoolYear = $user->getSchoolYear();
  539.         $establishment = $user->getEstablishment();
  540.         $settingClassrooms = $settingClassroomRepository->findBy(['establishment' => $establishment, 'schoolYear' => $schoolYear], []);
  542.         //$schoolMatters = $schoolMatterRepository->findBy(['establishment' => $establishment], []);
  543.         $settingRooms = $settingRoomRepository->createQueryBuilder('entity')
  544.         ->innerJoin('entity.establishment', 'establishment')
  545.         ->addSelect('establishment')
  546.         
  547.         ->andWhere('establishment.establishmentGroup = :establishmentGroup')
  548.         ->setParameter('establishmentGroup', $establishment->getEstablishmentGroup())
  550.         /* ->andWhere('entity.establishment = :establishment')
  551.         ->setParameter('establishment', $establishment) */
  552.         
  553.         ->orderBy('entity.label', 'ASC')
  554.         ->getQuery()
  555.         ->getResult();
  557.         $settingTimeTables = $settingTimeTableRepository->findBy(['establishment' => $establishment, 'schoolYear' => $schoolYear], []);
  559.         $matterCollections = new ArrayCollection();
  560.         $settingClassroomCollections = new ArrayCollection();
  562.         foreach ($schoolTeacher->getSchoolTeacherMatterClassrooms() as $key => $schoolTeacherMatterClassroom) {
  563.             if ($schoolTeacherMatterClassroom->getMatter()->getEstablishment() == $establishment) {
  564.                 $matterCollections->add($schoolTeacherMatterClassroom->getMatter());
  565.             }
  566.         }
  568.         foreach ($schoolTeacher->getSchoolTeacherMatterClassrooms() as $key => $schoolTeacherMatterClassroom) {
  569.             foreach ($matterCollections as $key => $_schoolMatter) {
  570.                 if (!$settingClassroomCollections->contains($schoolTeacherMatterClassroom->getClassroom())) {
  571.                     if ($schoolTeacherMatterClassroom->getClassroom()->getEstablishment() == $establishment) {
  572.                         $settingClassroomCollections->add($schoolTeacherMatterClassroom->getClassroom());
  573.                     }
  574.                 }
  575.             }
  576.         }
  577.         
  578.         $schoolWorkingTimeHourLesson = new SchoolWorkingTimeHourLesson();
  579.         $form = $this->createForm(SchoolWorkingTimeHourLessonType::class, $schoolWorkingTimeHourLesson)
  580.         ->add('schoolMatter', EntityType::class, [
  581.             'class' => SchoolMatter::class,
  582.             'choices' => $matterCollections
  583.         ])
  584.         ->add('settingClassroom', EntityType::class, [
  585.             'class' => SettingClassroom::class,
  586.             'choices' => $settingClassroomCollections
  587.         ])
  588.         ->add('settingRoom', EntityType::class, [
  589.             'class' => SettingRoom::class,
  590.             'choices' => $settingRooms
  591.         ])
  592.         ->add('settingTimeTable', EntityType::class, [
  593.             'class' => SettingTimeTable::class,
  594.             'choices' => $settingTimeTables
  595.         ]);
  596.         $form->handleRequest($request);
  598.         if ($form->isSubmitted() && $form->isValid()) {
  599.             $entityManager = $this->getDoctrine()->getManager();
  600.             $settingRoom = $settingRoomRepository->findOneBy(['id' => $schoolWorkingTimeHourLesson->getSettingRoom()->getId()], []);
  601.             $schoolMatter = $schoolMatterRepository->findOneBy(['id' => $schoolWorkingTimeHourLesson->getSchoolMatter()->getId()], []);
  602.             $settingTimeTable = $settingTimeTableRepository->findOneBy(['id' => $schoolWorkingTimeHourLesson->getSettingTimeTable()->getId()], []);
  603.             $settingClassroom = $settingClassroomRepository->findOneBy(['id' => $schoolWorkingTimeHourLesson->getSettingClassroom()->getId()], []);
  605.             if (null == $settingTimeTable) {
  606.                 $this->addFlash('warning', "La plage horaire est introuvable.");
  607.                 return $this->redirectToRoute('school_teacher_time_sheet', ['id' => $schoolTeacher->getId()]);
  608.             }
  609.     
  610.             if (null == $settingRoom) {
  611.                 $this->addFlash('warning', "Veuillez selectionner une salle");
  612.                 return $this->redirectToRoute('school_teacher_time_sheet', ['id' => $schoolTeacher->getId()]);
  613.             }
  614.     
  615.             if (null == $schoolMatter) {
  616.                 $this->addFlash('warning', "Veuillez selectionner une matière");
  617.                 return $this->redirectToRoute('school_teacher_time_sheet', ['id' => $schoolTeacher->getId()]);
  618.             }
  619.     
  620.             if (null == $settingClassroom) {
  621.                 $this->addFlash('warning', "Veuillez selectionner une classe");
  622.                 return $this->redirectToRoute('school_teacher_time_sheet', ['id' => $schoolTeacher->getId()]);
  623.             }
  625.             if ($schoolWorkingTimeHourLesson->getSchoolMatter()->getLevel() != $schoolWorkingTimeHourLesson->getSettingClassroom()->getLevel()) {
  626.                 $this->addFlash('warning', "Matière et classe doivent être du même niveau.");
  627.                 return $this->redirectToRoute('school_teacher_time_sheet', ['id' => $schoolTeacher->getId()]);
  628.             }
  629.             $schoolWorkingTime = $schoolWorkingTimeRepository->findOneBy(['establishment' => $establishment, 'schoolYear' => $schoolYear, 'settingClassroom' => $schoolWorkingTimeHourLesson->getSettingClassroom()], []);
  630.             if (null == $schoolWorkingTime) {
  631.                 $schoolWorkingTime = new SchoolWorkingTime();
  632.                 $schoolWorkingTime->setEstablishment($establishment);
  633.                 $schoolWorkingTime->setSchoolYear($schoolYear);
  634.                 $schoolWorkingTime->setSettingClassroom($schoolWorkingTimeHourLesson->getSettingClassroom());
  636.                 $entityManager->persist($schoolWorkingTime);
  637.             }
  639.             $_schoolWorkingTimeHourLesson = $schoolWorkingTimeHourLessonRepository->findOneBy(['schoolWorkingTime' => $schoolWorkingTime, 'settingTimeTable' => $schoolWorkingTimeHourLesson->getSettingTimeTable(), 'day' => $schoolWorkingTimeHourLesson->getDay()], []);
  640.             
  641.             $schoolWorkingTimeHourLesson->setEstablishment($establishment);
  642.             $schoolWorkingTimeHourLesson->setSchoolTeacher($schoolTeacher);
  643.             $schoolWorkingTimeHourLesson->setSchoolYear($schoolYear);
  644.             $schoolWorkingTimeHourLesson->setSchoolWorkingTime($schoolWorkingTime);
  645.             $schoolWorkingTimeHourLesson->setDefautDuration($settingTimeTable->getDefautDuration());
  647.             if (count($schoolWorkingTimeHourLessonRepository->findBy(['schoolTeacher' => $schoolTeacher, 'settingClassroom' => $schoolWorkingTime->getSettingClassroom(), 'settingTimeTable' => $settingTimeTable, 'day' => $schoolWorkingTimeHourLesson->getDay()], [])) > 0) {
  648.                 $this->addFlash('warning', "Un enseignant ne peut avoir plus d'un cours le même jour à la même heure avec la même classe.");
  649.                 return $this->redirectToRoute('school_teacher_time_sheet', ['id' => $schoolTeacher->getId()]);
  650.             }
  652.             $_schoolWorkingTimeHourLesson = $schoolWorkingTimeHourLessonRepository->findOneBy(['schoolYear' => $schoolYear, 'settingRoom' => $settingRoom, 'settingTimeTable' => $schoolWorkingTimeHourLesson->getSettingTimeTable(), 'day' => $schoolWorkingTimeHourLesson->getDay()], []);
  653.             //if (count($schoolWorkingTimeHourLessonRepository->findBy(['settingRoom' => $settingRoom, 'settingTimeTable' => $schoolWorkingTimeHourLesson->getSettingTimeTable(), 'day' => $schoolWorkingTimeHourLesson->getDay(), 'settingClassroom' => $schoolWorkingTimeHourLesson->getSettingClassroom()], [])) > 0) {
  654.             if (null != $_schoolWorkingTimeHourLesson) {
  655.                 if (!$_schoolWorkingTimeHourLesson->getSettingRoom()->getIsArea()) {
  656.                     $this->addFlash('warning', "Une salle ne peut abriter plus d'un cours le même jour à la même heure. Classe: " .$_schoolWorkingTimeHourLesson->getSettingClassroom()->getLabel().", Enseignant: " .$_schoolWorkingTimeHourLesson->getSchoolTeacher()->__toString().", Jour: " .$_schoolWorkingTimeHourLesson->getDay().", Heure: " .$_schoolWorkingTimeHourLesson->getSettingTimeTable()->getLabel().", Matière: " .$_schoolWorkingTimeHourLesson->getSchoolMatter()->getLabel());
  657.                     return $this->redirectToRoute('school_teacher_time_sheet', ['id' => $schoolTeacher->getId()]);
  658.                 }
  659.             }
  661.             if (count($schoolWorkingTimeHourLessonRepository->findBy(['schoolMatter' => $schoolMatter, 'settingTimeTable' => $schoolWorkingTimeHourLesson->getSettingTimeTable(), 'day' => $schoolWorkingTimeHourLesson->getDay(), 'settingClassroom' => $schoolWorkingTimeHourLesson->getSettingClassroom()], [])) > 0) {
  662.                 $this->addFlash('warning', "Une matière ne peut être enseigner plus d'un fois le même jour à la même heure dans la même classe.");
  663.                 return $this->redirectToRoute('school_teacher_time_sheet', ['id' => $schoolTeacher->getId()]);
  664.             }
  666.             /* if ($schoolWorkingTimeHourLesson->getSchoolMatter()->getHourlyVolumeRestToDispach($schoolYear) < $schoolWorkingTimeHourLesson->getSettingTimeTable()->getDefautDuration()) {
  667.                 $this->addFlash('warning', "Le volume horaire hebdomadaire affecté à cette matière est atteint.");
  668.                 return $this->redirectToRoute('school_teacher_time_sheet', ['id' => $schoolTeacher->getId()]);
  669.             } */
  671.             if (null != $_schoolWorkingTimeHourLesson) {
  672.                 $_schoolWorkingTimeHourLesson->setSchoolMatter($schoolWorkingTimeHourLesson->getSchoolMatter());
  673.                 $_schoolWorkingTimeHourLesson->setSchoolTeacher($schoolTeacher);
  674.                 $_schoolWorkingTimeHourLesson->setSettingRoom($schoolWorkingTimeHourLesson->getSettingRoom());
  675.             }else {
  676.                 $entityManager->persist($schoolWorkingTimeHourLesson);
  677.             }
  679.             try {
  680.                 $entityManager->flush();
  681.                 $this->addFlash('success', "Enrégistrement effectué avec succès.");
  682.             } catch (\Throwable $th) {
  683.                 $this->addFlash('warning', "Une erreure est survenue lors de l'édition de l'enseignant.");
  684.                 $this->addFlash('info', $th->getMessage());
  685.             }
  687.             return $this->redirectToRoute('school_teacher_time_sheet', ['id' => $schoolTeacher->getId()]);
  688.         }
  690.         return $this->renderForm('school/school_teacher/time_sheet.html.twig', [
  691.             'school_teacher' => $schoolTeacher,
  692.             'school_working_time_hour_lesson' => $schoolWorkingTimeHourLesson,
  693.             'form' => $form,
  694.         ]);
  695.     }
  697.     /**
  698.      * @Route("/working-time/{id}/print", name="school_teacher_working_time_print", methods={"GET"})
  699.     */
  700.     public function print_working_time(Pdf $knpSnappyPdf, SchoolTeacher $schoolTeacher, SettingTimeTableRepository $settingTimeTableRepository, SchoolWorkingTimeHourLessonRepository $schoolWorkingTimeHourLessonRepository)
  701.     {
  702.         /**@var User $user */
  703.         $user = $this->getUser();
  704.         $schoolYear = $user->getSchoolYear();
  706.         $establishment = $user->getEstablishment();
  708.         $template = 'school/print/schoolTeacherWorkingTime.html.twig';
  709.         if ($establishment->getType() != $establishment::ESTABLISHMENT_PRESCOLAIRE_PRIMAIRE_TYPES) {
  710.             $template = 'school/print/schoolTeacherWorkingTime.html.twig';
  711.         }
  713.         $schoolWorkingTimeHourLessons = $schoolWorkingTimeHourLessonRepository->findBy(['schoolTeacher' => $schoolTeacher], []);
  714.         
  715.         $html = $this->renderView($template, [
  716.             'school_year' => $schoolYear,
  717.             'school_teacher' => $schoolTeacher,
  718.             'schoolWorkingTimeHourLessons' => $schoolWorkingTimeHourLessons,
  719.             'setting_time_tables' => $settingTimeTableRepository->findBy(['establishment' => $establishment, 'schoolYear' => $schoolYear], ['label' => 'ASC']),
  720.             'week_days' => SchoolWorkingTime::COURS_DAYS,
  721.             'setting' => $establishment,
  722.         ]);
  724.         $footer = $this->renderView('print/footer.html.twig', ['setting' => $establishment]);
  725.         $header = $this->renderView('print/header.html.twig', ['setting' => $establishment]);
  726.         $options = [
  727.             'orientation' => 'Portrait'
  728.             //'header-html' => $header
  729.             //'footer-html' => $footer
  730.         ];
  732.         $file_name = 'EMPLOIE_DU_TEMPS_'.$schoolTeacher->getId()."_.pdf";
  734.         try {
  735.             $knpSnappyPdf->generateFromHtml($html, $this->getParameter('app.app_directory').'/downloads/working-time/' . $file_name, $options, true);
  736.         } catch (\Throwable $th) {
  737.             $this->addFlash('info', "Effectué");
  738.         }
  740.         return $this->redirectToRoute('preview', [
  741.             'file' => $file_name,
  742.             'dir' => 'working-time',
  743.         ]);
  744.     }
  746.     /**
  747.      * @Route("/reset-password/{id}", name="school_teacher_reset_password", methods={"GET"})
  748.     */
  749.     public function resetPassword(SchoolTeacher $schoolTeacher, UserPasswordHasherInterface $userPasswordHasherInterface): Response
  750.     {
  751.         $entityManager = $this->getDoctrine()->getManager();
  752.         $user = $schoolTeacher->getSalary()->getUser();
  753.         if (null != $user) {
  754.             $user->setIsPasswordChanged(false);
  755.             $user->setIsEnabled(true);
  756.             $user->setPassword(
  757.                 $userPasswordHasherInterface->hashPassword(
  758.                         $user,
  759.                         "central-edu"
  760.                     )
  761.                 );
  763.             try {
  764.                 $entityManager->flush();
  765.                 $this->addFlash('success', "Mot de passe réinitialisé :)".$user->getUserIdentifier());
  766.                 return $this->json(['code' => 200, 'message' => "Mot de passe réinitialisé :) ".$user->getUserIdentifier()], 200);
  767.             } catch (\Throwable $th) {
  768.                 //$th->getMessage()
  769.                 $this->addFlash('info', $th->getMessage());
  770.                 return $this->json(['code' => 500, 'message' => $th->getMessage()], 200);
  771.             }
  772.         }
  773.         
  774.         $this->addFlash('warning', "Une erreure s'est produite");
  775.         return $this->json(['code' => 500, 'message' => "Une erreure s'est produite"], 200);
  776.     }
  778.     /**
  779.      * @Route("/api/get-matters", name="api_school_teacher_matters", methods={"GET"})
  780.     */
  781.     public function api_get_matters(Request $request, SchoolTeacherRepository $entityRepository, SettingClassroomRepository $settingClassroomRepository): Response
  782.     {
  783.         /**@var User $user */
  784.         $user = $this->getUser();
  785.         $schoolYear = $user->getSchoolYear();
  786.         $establishment = $user->getEstablishment();
  788.         $classroom = $settingClassroomRepository->findOneBy(['id' => $request->get('classroom')], []);
  789.         $entity = $entityRepository->findOneBy(['id' => $request->get('teacher')], []);
  791.         if ($entity != null) {
  792.             
  793.             return $this->json([
  794.                 'code' => 200, 
  795.                 'message' => "found :)", 
  796.                 'schoolMatters' => $entity->getJsonMatterTeachs($classroom, $establishment)], 
  797.             200);
  798.         }else{
  799.             return $this->json(['code' => 500, 'message' => "not found :)"], 200);
  800.         }
  801.     }
  803.     /**
  804.      * @Route("/print/teachers", name="school_teacher_print_teachers", methods={"GET"})
  805.     */
  806.     public function print_teachers(Pdf $knpSnappyPdf, UserRepository $userRepository)
  807.     {
  808.         $setting = $this->getUser()->getEstablishment();
  809.         $teachers = $userRepository->createQueryBuilder('entity')
  810.         ->innerJoin('entity.rhSalary', 'rhSalary')
  811.         ->addSelect('rhSalary')
  813.         ->innerJoin('rhSalary.schoolTeachers', 'schoolTeachers')
  814.         ->addSelect('schoolTeachers')
  816.         ->andWhere('entity.establishment = :establishment')
  817.         ->setParameter('establishment', $setting)
  819.         ->andWhere('schoolTeachers.is_disabled = :is_disabled')
  820.         ->setParameter('is_disabled', 0)
  822.         ->andWhere('entity.is_enabled = :is_enabled')
  823.         ->setParameter('is_enabled', 1)
  825.         ->orderBy('rhSalary.last_name', 'ASC')
  827.         ->getQuery()
  828.         ->getResult();
  830.         $template = 'security/print/teachers.html.twig';
  832.         $html = $this->renderView($template, [
  833.             'teachers' => $teachers,
  834.             'setting' => $setting,
  835.         ]);
  837.         $file_name = "ENSEIGNANTS_.pdf";
  838.         $footer = $this->renderView('print/footer.html.twig', ['setting' => $setting,]);
  839.         $header = $this->renderView('print/header.html.twig', ['setting' => $setting,]);
  840.         $options = [
  841.             'orientation' => 'Portrait',
  842.             'header-html' => $header,
  843.             'footer-html' => $footer
  844.         ];
  846.         try {
  847.             $knpSnappyPdf->generateFromHtml($html, $this->getParameter('app.app_directory').'/downloads/teachers/' . $file_name, $options, true);
  848.         } catch (\Throwable $th) {
  849.             $this->addFlash('info', "Ce reçu à déjà été imprimé.");
  850.         }
  851.         
  853.         return $this->redirectToRoute('preview', [
  854.             'file' => $file_name,
  855.             'dir' => 'teachers',
  856.         ]);
  857.     }
  859.     /**
  860.      * @Route("/api/get-classrooms", name="api_school_teacher_classrooms", methods={"GET"})
  861.     */
  862.     public function api_get_classrooms(Request $request, SchoolTeacherRepository $entityRepository): Response
  863.     {
  864.         /**@var User $user */
  865.         $user = $this->getUser();
  866.         $schoolYear = $user->getSchoolYear();
  867.         $establishment = $user->getEstablishment();
  868.         $entity = $entityRepository->findOneBy(['id' => $request->get('teacher'), 'is_disabled' => 0], []);
  870.         if ($entity != null) {
  871.             
  872.             return $this->json([
  873.                 'code' => 200, 
  874.                 'message' => "found :)", 
  875.                 'settingClassrooms' => $entity->getJsonClassroomTeachs($establishment)], 
  876.             200);
  877.         }else{
  878.             return $this->json(['code' => 500, 'message' => "not found :)"], 200);
  879.         }
  880.     }
  882.     /**
  883.      * @Route("/api/get-time_tables", name="api_school_teacher_time_tables", methods={"GET"})
  884.     */
  885.     public function api_get_time_tables(Request $request, SchoolTeacherRepository $entityRepository, SettingClassroomRepository $settingClassroomRepository): Response
  886.     {
  887.         /**@var User $user */
  888.         $user = $this->getUser();
  889.         $schoolYear = $user->getSchoolYear();
  890.         $establishment = $user->getEstablishment();
  891.         $classroom = $settingClassroomRepository->findOneBy(['id' => $request->get('classroom')], []);
  892.         $entity = $entityRepository->findOneBy(['id' => $request->get('teacher'), 'is_disabled' => 0], []);
  894.         if ($entity != null) {
  895.             
  896.             return $this->json([
  897.                 'code' => 200, 
  898.                 'message' => "found :)", 
  899.                 'settingTimeTables' => $entity->getJsonTimeTableTeachs($classroom, $establishment)], 
  900.             200);
  901.         }else{
  902.             return $this->json(['code' => 500, 'message' => "not found :)"], 200);
  903.         }
  904.     }
  906.     /**
  907.      * @Route("/api/get-working-time-hour-lessons", name="api_school_teacher_working_time_hour_lessons", methods={"GET"})
  908.     */
  909.     public function api_get_working_time_hour_lessons(Request $request, SchoolTeacherRepository $entityRepository): Response
  910.     {
  911.         /**@var User $user */
  912.         $user = $this->getUser();
  913.         $establishment = $user->getEstablishment();
  914.         $entity = $entityRepository->findOneBy(['id' => $request->get('teacher'), 'is_disabled' => 0], []);
  916.         if ($entity != null) {
  917.             
  918.             return $this->json([
  919.                 'code' => 200, 
  920.                 'message' => "found :)", 
  921.                 'workingTimeHourLessons' => $entity->getJsonWorkingTimeHourLessons($establishment)], 
  922.             200);
  923.         }else{
  924.             return $this->json(['code' => 500, 'message' => "not found :)"], 200);
  925.         }
  926.     }
  928.     /**
  929.      * @Route("/{id}/edit-login", name="school_teacher_edit_login", methods={"POST"})
  930.      */
  931.     public function editLogin(Request $request, SchoolTeacher $schoolTeacher, UserRepository $userRepository, UserPasswordHasherInterface $userPasswordHasherInterface): Response
  932.     {
  933.         if (!$this->isGranted('ROLE_DIRECTEUR')) {
  934.             return $this->json(['code' => 403, 'message' => 'Accès refusé'], 403);
  935.         }
  937.         $newLogin = $request->request->get('newLogin');
  938.         $resetPassword = $request->request->get('resetPassword') === 'true';
  939.         
  940.         // Validation : au moins une action doit être demandée
  941.         if (empty($newLogin) && !$resetPassword) {
  942.             return $this->json(['code' => 400, 'message' => 'Veuillez sélectionner au moins une action : modifier le login ou réinitialiser le mot de passe'], 400);
  943.         }
  945.         $user = $schoolTeacher->getSalary()->getUser();
  946.         $currentLogin = $user->getUsername();
  947.         $messages = [];
  949.         // Traitement de la modification du login
  950.         if (!empty($newLogin)) {
  951.             if ($newLogin === $currentLogin) {
  952.                 return $this->json(['code' => 400, 'message' => 'Le nouveau login doit être différent de l\'actuel'], 400);
  953.             }
  955.             // Vérifier si le nouveau login existe déjà
  956.             $existingUser = $userRepository->findOneBy(['username' => $newLogin]);
  957.             if ($existingUser && $existingUser->getId() !== $user->getId()) {
  958.                 return $this->json(['code' => 400, 'message' => 'Ce login existe déjà'], 400);
  959.             }
  961.             $user->setUsername($newLogin);
  962.             $messages[] = 'Login modifié';
  963.         }
  965.         // Traitement de la réinitialisation du mot de passe
  966.         if ($resetPassword) {
  967.             $user->setPassword(
  968.                 $userPasswordHasherInterface->hashPassword(
  969.                     $user,
  970.                     "central-edu"
  971.                 )
  972.             );
  973.             $user->setIsPasswordChanged(false);
  974.             $user->setIsEnabled(true);
  975.             $messages[] = 'Mot de passe réinitialisé';
  976.         }
  978.         try {
  979.             $entityManager = $this->getDoctrine()->getManager();
  980.             $entityManager->flush();
  982.             $message = implode(' et ', $messages) . ' avec succès';
  983.             return $this->json(['code' => 200, 'message' => $message], 200);
  984.         } catch (\Throwable $th) {
  985.             return $this->json(['code' => 500, 'message' => 'Une erreur est survenue lors des modifications'], 500);
  986.         }
  987.     }
  988. }