src/Controller/School/SchoolAverageController.php line 422

Open in your IDE?
  1. <?php
  3. namespace App\Controller\School;
  5. use Knp\Snappy\Pdf;
  6. use App\Entity\User;
  7. use DateTimeImmutable;
  8. use App\Entity\SchoolAverage;
  9. use App\Entity\SchoolTeacher;
  10. use App\Entity\SchoolYearPeriode;
  11. use App\Repository\UserRepository;
  12. use App\Entity\SchoolStudentAverage;
  13. use App\Form\School\SchoolAverageType;
  14. use App\Repository\SchoolMatterRepository;
  15. use App\Repository\SchoolAverageRepository;
  16. use App\Repository\SchoolTeacherRepository;
  17. use Knp\Component\Pager\PaginatorInterface;
  18. use App\Entity\SchoolTeacherMatterClassroom;
  19. use App\Form\School\SchoolStudentAverageType;
  20. use Symfony\Component\HttpFoundation\Request;
  21. use App\Repository\SettingClassroomRepository;
  22. use Symfony\Component\HttpFoundation\Response;
  23. use App\Entity\RegistrationStudentRegistration;
  24. use App\Repository\SchoolYearPeriodeRepository;
  25. use Symfony\Component\Routing\Annotation\Route;
  26. use Doctrine\Common\Collections\ArrayCollection;
  27. use Symfony\Bridge\Doctrine\Form\Type\EntityType;
  28. use App\Repository\SchoolStudentAverageRepository;
  29. use App\Repository\SchoolTeacherMatterClassroomRepository;
  30. use App\Repository\RegistrationStudentRegistrationRepository;
  31. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  33. /**
  34.  * @Route("/school/average")
  35.  */
  36. class SchoolAverageController extends AbstractController
  37. {
  38.     /**
  39.      * @Route("/index", name="school_average_index", methods={"GET"})
  40.      */
  41.     public function index(
  42.         Request $request, 
  43.         PaginatorInterface $paginator, 
  44.         SchoolAverageRepository $schoolAverageRepository, 
  45.         SchoolTeacherRepository $schoolTeacherRepository,
  46.         SchoolYearPeriodeRepository $schoolYearPeriodeRepository, 
  47.         SchoolMatterRepository $schoolMatterRepository, 
  48.         SettingClassroomRepository $settingClassroomRepository,
  49.         UserRepository $userRepository
  50.         ): Response
  51.     {
  52.         /**@var User $user */
  53.         $user = $this->getUser();
  54.         $schoolYear = $user->getSchoolYear();
  55.         $establishment = $this->getUser()->getEstablishment();
  56.         $schoolTeacher = $schoolTeacherRepository->findOneBy(['salary' => $user->getRhSalary(), 'schoolYear' => $schoolYear, 'is_disabled' => 0], []);
  58.         $_schoolTeacher = $schoolTeacherRepository->findOneBy(['id' => $request->get('teacher')], []);
  59.         $schoolYearPeriode = $schoolYearPeriodeRepository->findOneBy(['id' => $request->get('school_year_periode')], []);
  60.         $schoolMatter = $schoolMatterRepository->findOneBy(['id' => $request->get('matter')], []);
  61.         $settingClassroom = $settingClassroomRepository->findOneBy(['id' => $request->get('classroom')], []);
  63.         $query = $schoolAverageRepository->createQueryBuilder('entity')
  64.             ->innerJoin('entity.classroom', 'classroom')
  65.             ->addSelect('classroom')
  67.             ->andWhere('classroom.establishment = :establishment')
  68.             ->setParameter('establishment', $establishment)
  70.             ->andWhere('entity.schoolYear = :schoolYear')
  71.             ->setParameter('schoolYear', $schoolYear);
  73.             if ($_schoolTeacher != null) {
  74.                 $query = $query
  75.                 ->andWhere('entity.schoolTeacher = :schoolTeacher')
  76.                 ->setParameter('schoolTeacher', $_schoolTeacher);
  77.             }
  79.             if ($schoolYearPeriode != null) {
  80.                 $query = $query
  81.                 ->andWhere('entity.schoolYearPeriode = :schoolYearPeriode')
  82.                 ->setParameter('schoolYearPeriode', $schoolYearPeriode);
  83.             }
  85.             if ($schoolMatter != null) {
  86.                 $query = $query
  87.                 ->andWhere('entity.matter = :matter')
  88.                 ->setParameter('matter', $schoolMatter);
  89.             }
  91.             if ($settingClassroom != null) {
  92.                 $query = $query
  93.                 ->andWhere('entity.classroom = :classroom')
  94.                 ->setParameter('classroom', $settingClassroom);
  95.             }
  97.             $query = $query
  98.             ->orderBy('entity.id', 'DESC')
  99.             ->getQuery();
  101.         $school_averages = $paginator->paginate(
  102.             $query,
  103.             $request->query->getInt('page', 1),
  104.             1000
  105.         );
  107.         if (null != $schoolTeacher && !$this->isGranted("ROLE_ADMIN")) {
  108.             $query2 = $schoolAverageRepository->createQueryBuilder('entity')
  109.             ->innerJoin('entity.classroom', 'classroom')
  110.             ->addSelect('classroom')
  112.             ->andWhere('classroom.establishment = :establishment')
  113.             ->setParameter('establishment', $establishment)
  115.             ->andWhere('entity.schoolYear = :schoolYear')
  116.             ->setParameter('schoolYear', $schoolYear);
  118.             if ($_schoolTeacher != null) {
  119.                 $query2 = $query2
  120.                 ->andWhere('entity.schoolTeacher = :schoolTeacher')
  121.                 ->setParameter('schoolTeacher', $_schoolTeacher);
  122.             }
  124.             if ($schoolYearPeriode != null) {
  125.                 $query2 = $query2
  126.                 ->andWhere('entity.schoolYearPeriode = :schoolYearPeriode')
  127.                 ->setParameter('schoolYearPeriode', $schoolYearPeriode);
  128.             }
  130.             if ($schoolMatter != null) {
  131.                 $query2 = $query2
  132.                 ->andWhere('entity.matter = :matter')
  133.                 ->setParameter('matter', $schoolMatter);
  134.             }
  136.             if ($settingClassroom != null) {
  137.                 $query2 = $query2
  138.                 ->andWhere('entity.classroom = :classroom')
  139.                 ->setParameter('classroom', $settingClassroom);
  140.             }
  142.             $query2 = $query2
  143.             ->andWhere('entity.schoolTeacher = :schoolTeacher')
  144.             ->setParameter('schoolTeacher', $schoolTeacher)
  146.             ->orderBy('entity.id', 'DESC')
  147.             ->getQuery();
  148.             $school_averages = $paginator->paginate(
  149.                 $query2,
  150.                 $request->query->getInt('page', 1),
  151.                 1000
  152.             ); 
  153.         }
  155.         return $this->render('school/school_average/index.html.twig', [
  156.             'school_averages' => $school_averages,
  157.             'schoolTeacher' => $schoolTeacher,
  158.             'school_year_periodes' => $schoolYearPeriodeRepository->findBy(['establishment' => $user->getEstablishment(), 'schoolYear' => $schoolYear], ['begin_at' => 'ASC']),
  159.             'setting_slassrooms' => $settingClassroomRepository->findBy(['establishment' => $user->getEstablishment(), 'schoolYear' => $schoolYear], ['label' => 'ASC']),
  160.             'school_matters' => $schoolMatterRepository->findBy(['establishment' => $user->getEstablishment(), 'is_test_matter' => 0], ['label' => 'ASC']),
  161.             'school_teachers' => $schoolTeacherRepository->findBy(['establishment' => $user->getEstablishment(), 'schoolYear' => $schoolYear], ['id' => 'DESC']),
  163.             'schoolYearPeriode' => $schoolYearPeriode,
  164.             'settingClassroom' => $settingClassroom,
  165.             'schoolMatter' => $schoolMatter,
  166.             '_schoolTeacher' => $_schoolTeacher,
  168.             'userRepository' => $userRepository,
  169.         ]);
  170.     }
  172.     /**
  173.      * @Route("/new", name="school_average_new", methods={"GET","POST"})
  174.      */
  175.     public function new(Request $request, SchoolYearPeriodeRepository $schoolYearPeriodeRepository, SchoolTeacherRepository $schoolTeacherRepository, SchoolAverageRepository $schoolAverageRepository, SchoolTeacherMatterClassroomRepository $schoolTeacherMatterClassroomRepository): Response
  176.     {
  177.         /**@var User $user */
  178.         $user = $this->getUser();
  179.         $schoolYear = $user->getSchoolYear();
  181.         $user = $this->getUser();
  182.         $establishment = $user->getEstablishment();
  183.         $_date = new DateTimeImmutable();
  185.         $schoolYearPeriodes = $schoolYearPeriodeRepository->createQueryBuilder('entity')
  186.         ->andWhere('entity.establishment = :establishment')
  187.         ->setParameter('establishment', $establishment)
  189.         ->andWhere('entity.schoolYear = :schoolYear')
  190.         ->setParameter('schoolYear', $schoolYear)
  192.         ->andWhere('entity.is_average_closed = :is_average_closed')
  193.         ->setParameter('is_average_closed', 0)
  195.         ->getQuery()
  196.         ->getResult();
  198.         $schoolTeacher = $schoolTeacherRepository->findOneBy(['salary' => $user->getRhSalary(), 'schoolYear' => $schoolYear, 'is_disabled' => 0], []);
  199.         $schoolTeachers = new ArrayCollection();
  201.         if (null != $schoolTeacher) {
  202.             $schoolTeachers->add($schoolTeacher);
  203.         }else {
  204.             $schoolTeachers = $schoolTeacherRepository->createQueryBuilder('entity')
  205.     
  206.                 ->innerJoin('entity.establishment', 'establishment')
  207.                 ->addSelect('establishment')
  208.     
  209.                 ->andWhere('establishment.establishmentGroup = :establishmentGroup')
  210.                 ->setParameter('establishmentGroup', $establishment->getEstablishmentGroup())
  212.                 ->andWhere('entity.schoolYear = :schoolYear')
  213.                 ->setParameter('schoolYear', $schoolYear)
  214.     
  215.                 ->andWhere('entity.is_disabled = :is_disabled')
  216.                 ->setParameter('is_disabled', 0)
  217.     
  218.                 ->orderBy('entity.id', 'DESC')
  219.                 ->getQuery()
  220.                 ->getResult();
  221.             //$schoolTeachers = $schoolTeacherRepository->findBy(['establishment' => $establishment], []);
  222.         }
  224.         if (!$this->isGranted("ROLE_OPERATEUR_SAISIE", $user)) {
  225.             if (null == $schoolTeacher) {
  226.                 $this->addFlash('warning', "Impossible: Vous devez êtes enseignant ou opérateur de saisie pour pouvoir créer des notes.");
  227.                 return $this->redirectToRoute('school_average_index');
  228.             }
  229.         }
  231.         $schoolTeacherMatterClassrooms = new ArrayCollection();
  233.         if (null == $schoolTeacher) {
  234.             if ($this->isGranted("ROLE_OPERATEUR_SAISIE", $user)) {
  235.                 $schoolTeacherMatterClassrooms = $schoolTeacherMatterClassroomRepository->findBy(['establishment' => $establishment], []);
  236.             }
  237.         }else {
  238.             $schoolTeacherMatterClassrooms = $schoolTeacher->getSchoolTeacherMatterClassrooms();
  239.         }
  241.         $schoolAverage = new SchoolAverage();
  242.         $form = $this->createForm(SchoolAverageType::class, $schoolAverage)
  243.         ->add('schoolTeacherMatterClassroom', EntityType::class, [
  244.             'class' => SchoolTeacherMatterClassroom::class,
  245.             'choices' => $schoolTeacherMatterClassrooms,
  246.             'required' => true
  247.         ])
  249.         ->add('schoolTeacher', EntityType::class, [
  250.             'class' => SchoolTeacher::class,
  251.             'choices' => $schoolTeachers,
  252.             'required' => true
  253.         ])
  255.         ->add('schoolYearPeriode', EntityType::class, [
  256.             'class' => SchoolYearPeriode::class,
  257.             'choices' => $schoolYearPeriodes,
  258.             'required' => true
  259.         ]);
  260.         $form->handleRequest($request);
  262.         if ($form->isSubmitted() && $form->isValid()) {
  263.             $entityManager = $this->getDoctrine()->getManager();
  264.             $schoolAverage->setEstablishment($establishment);
  265.             $schoolAverage->setSchoolYear($schoolYear);
  266.             $schoolAverage->setClassroom($schoolAverage->getSchoolTeacherMatterClassroom()->getClassroom());
  267.             $schoolAverage->setMatter($schoolAverage->getSchoolTeacherMatterClassroom()->getMatter());
  268.             //$schoolAverage->setNoteOn($schoolAverage->getMatter()->getNoteOnReportCard());
  269.             $schoolAverage->setLabel('Note '.(count($schoolAverageRepository->findBy(['matter' => $schoolAverage->getMatter(), 'classroom' => $schoolAverage->getClassroom(), 'schoolYearPeriode' => $schoolAverage->getSchoolYearPeriode()], [])) + 1));
  270.             $schoolAverage->setCode(rand(100000, 999999).$schoolAverage->getSchoolYearPeriode()->getId().$schoolAverage->getMatter()->getId().$schoolAverage->getClassroom()->getId());
  271.             $registrationStudentRegistrations = $schoolAverage->getClassroom()->getRegistereds($schoolYear);
  272.             if($schoolAverage->getMatter()->getLv2() == 'AUCUN') {
  273.                 if($schoolAverage->getMatter()->getArtOrMusique() == null || $schoolAverage->getMatter()->getArtOrMusique() == '') {
  274.                 /* --- pas une langue vivante 2 --- */
  275.                     foreach ($registrationStudentRegistrations as $key => $registrationStudentRegistration) {
  276.                         $schoolStudentAverage = new SchoolStudentAverage();
  277.                         $schoolStudentAverage->setEstablishment($establishment);
  278.                         $schoolStudentAverage->setSchoolYear($schoolYear);
  279.                         $schoolStudentAverage->setSchoolAverage($schoolAverage);
  280.                         $schoolStudentAverage->setRegistrationStudentRegistration($registrationStudentRegistration);
  281.                         $schoolStudentAverage->setCode('sa-'.rand(100000, 999999).$schoolAverage->getMatter()->getId().$registrationStudentRegistration->getId().$schoolAverage->getSchoolYearPeriode()->getId());
  282.                         $schoolStudentAverage->setCoefficient(1);
  283.                         $schoolStudentAverage->setNoteOn($schoolAverage->getNoteOn());
  284.                         $schoolStudentAverage->setNote(999);
  285.                         $schoolStudentAverage->setMatter($schoolAverage->getMatter());
  286.                         $schoolStudentAverage->setIsMatterConduct($schoolAverage->getMatter()->getIsMatterConduct());
  287.                         $schoolStudentAverage->setSchoolYearPeriode($schoolAverage->getSchoolYearPeriode());
  288.                         $countSubMatters = 0;
  289.                         foreach ($schoolAverage->getMatter()->getSchoolSubMatters() as $key => $schoolSubMatter) {
  290.                             $schoolStudentAverage->setAsSubmatter(true);
  291.                             $countSubMatters++;
  292.                             $schoolSubStudentAverage = new SchoolStudentAverage();
  293.                             $schoolSubStudentAverage->setEstablishment($establishment);
  294.                             $schoolSubStudentAverage->setSchoolYear($schoolYear);
  295.                             $schoolSubStudentAverage->setSchoolAverage($schoolAverage);
  296.                             $schoolSubStudentAverage->setRegistrationStudentRegistration($registrationStudentRegistration);
  297.                             $schoolSubStudentAverage->setCode('sa-'.rand(100000, 999999).$schoolSubMatter->getId().$registrationStudentRegistration->getId().$schoolAverage->getSchoolYearPeriode()->getId());
  298.                             $schoolSubStudentAverage->setCoefficient(1);
  299.                             $schoolSubStudentAverage->setNoteOn($schoolAverage->getNoteOn());
  300.                             $schoolSubStudentAverage->setNote(999);
  301.                             $schoolSubStudentAverage->setMatter($schoolAverage->getMatter());
  302.                             $schoolSubStudentAverage->setIsMatterConduct($schoolAverage->getMatter()->getIsMatterConduct());
  303.                             $schoolSubStudentAverage->setSubMatter($schoolSubMatter);
  304.                             $schoolSubStudentAverage->setSchoolYearPeriode($schoolAverage->getSchoolYearPeriode());
  305.                             $entityManager->persist($schoolSubStudentAverage);
  306.                         }
  307.                         
  308.                         if ($countSubMatters <= 0) {
  309.                             $entityManager->persist($schoolStudentAverage);
  310.                         }
  311.                     }
  312.                 }else {
  313.                     foreach ($registrationStudentRegistrations as $key => $registrationStudentRegistration) {
  314.                         if ($registrationStudentRegistration->getStudent()->getArtOrMusique() == $schoolAverage->getMatter()->getArtOrMusique()) {
  315.                             $schoolStudentAverage = new SchoolStudentAverage();
  316.                             $schoolStudentAverage->setEstablishment($establishment);
  317.                             $schoolStudentAverage->setSchoolYear($schoolYear);
  318.                             $schoolStudentAverage->setSchoolAverage($schoolAverage);
  319.                             $schoolStudentAverage->setRegistrationStudentRegistration($registrationStudentRegistration);
  320.                             $schoolStudentAverage->setCode('sa-'.rand(100000, 999999).$schoolAverage->getMatter()->getId().$registrationStudentRegistration->getId().$schoolAverage->getSchoolYearPeriode()->getId());
  321.                             $schoolStudentAverage->setCoefficient(1);
  322.                             $schoolStudentAverage->setNoteOn($schoolAverage->getNoteOn());
  323.                             $schoolStudentAverage->setNote(999);
  324.                             $schoolStudentAverage->setMatter($schoolAverage->getMatter());
  325.                             $schoolStudentAverage->setIsMatterConduct($schoolAverage->getMatter()->getIsMatterConduct());
  326.                             $schoolStudentAverage->setSchoolYearPeriode($schoolAverage->getSchoolYearPeriode());
  327.                             $countSubMatters = 0;
  328.                             foreach ($schoolAverage->getMatter()->getSchoolSubMatters() as $key => $schoolSubMatter) {
  329.                                 $schoolStudentAverage->setAsSubmatter(true);
  330.                                 $countSubMatters++;
  331.                                 $schoolSubStudentAverage = new SchoolStudentAverage();
  332.                                 $schoolSubStudentAverage->setEstablishment($establishment);
  333.                                 $schoolSubStudentAverage->setSchoolYear($schoolYear);
  334.                                 $schoolSubStudentAverage->setSchoolAverage($schoolAverage);
  335.                                 $schoolSubStudentAverage->setRegistrationStudentRegistration($registrationStudentRegistration);
  336.                                 $schoolSubStudentAverage->setCode('sa-'.rand(100000, 999999).$schoolSubMatter->getId().$registrationStudentRegistration->getId().$schoolAverage->getSchoolYearPeriode()->getId());
  337.                                 $schoolSubStudentAverage->setCoefficient(1);
  338.                                 $schoolSubStudentAverage->setNoteOn($schoolAverage->getNoteOn());
  339.                                 $schoolSubStudentAverage->setNote(999);
  340.                                 $schoolSubStudentAverage->setMatter($schoolAverage->getMatter());
  341.                                 $schoolSubStudentAverage->setIsMatterConduct($schoolAverage->getMatter()->getIsMatterConduct());
  342.                                 $schoolSubStudentAverage->setSubMatter($schoolSubMatter);
  343.                                 $schoolSubStudentAverage->setSchoolYearPeriode($schoolAverage->getSchoolYearPeriode());
  344.                                 $entityManager->persist($schoolSubStudentAverage);
  345.                             }
  346.                             
  347.                             if ($countSubMatters <= 0) {
  348.                                 $entityManager->persist($schoolStudentAverage);
  349.                             }
  350.                         }
  351.                     }
  352.                 }
  353.             }else {
  354.                 /* --- est une langue vivante 2 --- */
  355.                 foreach ($registrationStudentRegistrations as $key => $registrationStudentRegistration) {
  356.                     if (!$registrationStudentRegistration->getIsAbandonned()) {
  357.                         if ($registrationStudentRegistration->getStudent()->getLv2() == $schoolAverage->getMatter()->getLv2()) {
  358.                             $schoolStudentAverage = new SchoolStudentAverage();
  359.                             $schoolStudentAverage->setEstablishment($establishment);
  360.                             $schoolStudentAverage->setSchoolYear($schoolYear);
  361.                             $schoolStudentAverage->setSchoolAverage($schoolAverage);
  362.                             $schoolStudentAverage->setRegistrationStudentRegistration($registrationStudentRegistration);
  363.                             $schoolStudentAverage->setCode('sa-'.rand(100000, 999999).$schoolAverage->getMatter()->getId().$registrationStudentRegistration->getId().$schoolAverage->getSchoolYearPeriode()->getId());
  364.                             $schoolStudentAverage->setCoefficient(1);
  365.                             $schoolStudentAverage->setNoteOn($schoolAverage->getNoteOn());
  366.                             $schoolStudentAverage->setNote(999);
  367.                             $schoolStudentAverage->setMatter($schoolAverage->getMatter());
  368.                             $schoolStudentAverage->setIsMatterConduct($schoolAverage->getMatter()->getIsMatterConduct());
  369.                             $schoolStudentAverage->setSchoolYearPeriode($schoolAverage->getSchoolYearPeriode());
  370.                             $countSubMatters = 0;
  371.                             foreach ($schoolAverage->getMatter()->getSchoolSubMatters() as $key => $schoolSubMatter) {
  372.                                 $schoolStudentAverage->setAsSubmatter(true);
  373.                                 $countSubMatters++;
  374.                                 $schoolSubStudentAverage = new SchoolStudentAverage();
  375.                                 $schoolSubStudentAverage->setEstablishment($establishment);
  376.                                 $schoolSubStudentAverage->setSchoolYear($schoolYear);
  377.                                 $schoolSubStudentAverage->setSchoolAverage($schoolAverage);
  378.                                 $schoolSubStudentAverage->setRegistrationStudentRegistration($registrationStudentRegistration);
  379.                                 $schoolSubStudentAverage->setCode('sa-'.rand(100000, 999999).$schoolSubMatter->getId().$registrationStudentRegistration->getId().$schoolAverage->getSchoolYearPeriode()->getId());
  380.                                 $schoolSubStudentAverage->setCoefficient(1);
  381.                                 $schoolSubStudentAverage->setNoteOn($schoolAverage->getNoteOn());
  382.                                 $schoolSubStudentAverage->setNote(999);
  383.                                 $schoolSubStudentAverage->setMatter($schoolAverage->getMatter());
  384.                                 $schoolSubStudentAverage->setIsMatterConduct($schoolAverage->getMatter()->getIsMatterConduct());
  385.                                 $schoolSubStudentAverage->setSubMatter($schoolSubMatter);
  386.                                 $schoolSubStudentAverage->setSchoolYearPeriode($schoolAverage->getSchoolYearPeriode());
  387.                                 $entityManager->persist($schoolSubStudentAverage);
  388.                             }
  389.                             
  390.                             if ($countSubMatters <= 0) {
  391.                                 $entityManager->persist($schoolStudentAverage);
  392.                             }
  393.                         }
  394.                     }
  395.                 }
  396.             }
  398.             $entityManager->persist($schoolAverage);
  400.             try {
  401.                 $entityManager->flush();
  402.                 $this->addFlash('success', "Une note à été ajoutée.");
  403.             } catch (\Throwable $th) {
  404.                 $this->addFlash('warning', "Une erreure est survenue lors de l'ajout de la note.");
  405.                 $this->addFlash('info', $th->getMessage());
  406.                 return $this->redirectToRoute('school_average_new');
  407.             }
  409.             return $this->redirectToRoute('school_average_edit', ['id' => $schoolAverage->getId()]);
  410.         }
  412.         return $this->renderForm('school/school_average/new.html.twig', [
  413.             'school_average' => $schoolAverage,
  414.             'schoolTeacher' => $schoolTeacher,
  415.             'form' => $form,
  416.         ]);
  417.     }
  419.     /**
  420.      * @Route("/{id}/edit", name="school_average_edit", methods={"GET","POST"})
  421.      */
  422.     public function edit(Request $request, SchoolAverage $schoolAverage, UserRepository $userRepository, SchoolStudentAverageRepository $schoolStudentAverageRepository, RegistrationStudentRegistrationRepository $registrationStudentRegistrationRepository): Response
  423.     {
  424.         /**@var User $user */
  425.         $user = $this->getUser();
  426.         $schoolYear = $user->getSchoolYear();
  428.         $user = $this->getUser();
  429.         $establishment = $user->getEstablishment();
  431.         foreach ($schoolAverage->getSchoolStudentAverages() as $key => $schoolStudentAverage) {
  432.             $schoolStudentAverage->setNoteOn($schoolAverage->getNoteOn());
  433.         }
  435.         $entityManager = $this->getDoctrine()->getManager();
  436.         
  437.         try {
  438.             $entityManager->flush();
  439.         } catch (\Throwable $th) {
  440.             $this->addFlash('info', $th->getMessage());
  441.         }
  442.         
  443.         $form = $this->createForm(SchoolAverageType::class, $schoolAverage)
  444.         ->remove('classroom')
  445.         ->remove('matter')
  446.         ->remove('schoolYearPeriode');
  447.         $form->handleRequest($request);
  449.         
  450.         if ($form->isSubmitted() && $form->isValid()) {
  451.             try {
  452.                 $entityManager->flush();
  453.                 $this->addFlash('success', "Une classe à été ajoutée.");
  454.             } catch (\Throwable $th) {
  455.                 $this->addFlash('warning', "Une erreure est survenue lors de l'ajout de la classe.");
  456.                 $this->addFlash('info', $th->getMessage());
  457.             }
  459.             return $this->redirectToRoute('school_average_edit', ['id' => $schoolAverage->getId()]);
  460.         }
  462.         $schoolStudentAverages = $schoolStudentAverageRepository->createQueryBuilder('entity')
  463.         ->innerJoin('entity.registrationStudentRegistration', 'registrationStudentRegistration')
  464.         ->addSelect('registrationStudentRegistration')
  466.         ->innerJoin('registrationStudentRegistration.student', 'student')
  467.         ->addSelect('student')
  469.         ->andWhere('entity.schoolAverage = :schoolAverage')
  470.         ->setParameter('schoolAverage', $schoolAverage)
  471.         
  472.         ->getQuery()
  473.         ->getResult();
  475.         $school_student_averages = new ArrayCollection();
  476.         foreach ($schoolStudentAverages as $key => $schoolStudentAverage) {
  477.             $school_student_averages->add([
  478.                 'id' => $schoolStudentAverage->getId(),
  479.                 'code' => $schoolStudentAverage->getRegistrationStudentRegistration()->getStudent()->getRegistrationNumber(),
  480.                 'name' => $schoolStudentAverage->getRegistrationStudentRegistration()->getStudent()->getName(),
  481.                 'classroom' => $schoolStudentAverage->getRegistrationStudentRegistration()->getClassroom()->getLabel(),
  482.                 'note' => $schoolStudentAverage->getNote(),
  483.                 'noteOn' => $schoolStudentAverage->getNoteOn(),
  484.                 'asSubmatter' => $schoolStudentAverage->getAsSubmatter(),
  485.                 'subMatter' => $schoolStudentAverage->getSubMatter() ? $schoolStudentAverage->getSubMatter()->getLabel() : null,
  486.                 'entity' => $schoolStudentAverage,
  487.                 
  488.             ]);
  489.         }
  491.         $iterator = $school_student_averages->getIterator();
  492.         $iterator->uasort(function ($first, $second) {
  493.             if ($first === $second) {
  494.                 return 0;
  495.             }
  497.             return $first['name'] < $second['name'] ? -1 : 1;
  498.         });
  499.         $school_student_averages = new ArrayCollection(iterator_to_array($iterator));
  501.         $registrationStudentRegistrations = $registrationStudentRegistrationRepository->createQueryBuilder('entity')
  502.         ->innerJoin('entity.student', 'student')
  503.         ->addSelect('student')
  505.         ->andWhere('entity.establishment = :establishment')
  506.         ->setParameter('establishment', $establishment)
  508.         ->andWhere('entity.schoolYear = :schoolYear')
  509.         ->setParameter('schoolYear', $schoolYear)
  511.         ->andWhere('entity.classroom = :classroom')
  512.         ->setParameter('classroom', $schoolAverage->getClassroom())
  514.         ->orderBy('student.last_name', 'ASC')
  515.         ->getQuery()
  516.         ->getResult();
  518.         $registration_student_registrations = new ArrayCollection();
  519.         foreach ($registrationStudentRegistrations as $key => $registrationStudentRegistration) {
  520.             if (!$registrationStudentRegistration->getIsAbandonned()) {
  521.                 if (null == $schoolStudentAverageRepository->findOneBy(['registrationStudentRegistration' => $registrationStudentRegistration, 'schoolAverage' => $schoolAverage], [])) {
  522.                     if($schoolAverage->getMatter()->getLv2() == 'AUCUN' || $registrationStudentRegistration->getStudent()->getLv2() == $schoolAverage->getMatter()->getLv2()){
  523.                         if ($schoolAverage->getMatter()->getArtOrMusique() == null || $schoolAverage->getMatter()->getArtOrMusique() == '' || $registrationStudentRegistration->getStudent()->getArtOrMusique() == $schoolAverage->getMatter()->getArtOrMusique()) {
  524.                             $registration_student_registrations->add($registrationStudentRegistration);
  525.                         }
  526.                         
  527.                     }
  528.                     
  529.                 }
  530.             }
  531.         }
  532.         
  534.         $schoolStudentAverage = new SchoolStudentAverage();
  535.         $schoolStudentAverage->setNote(999);
  536.         $school_student_average_form = $this->createForm(SchoolStudentAverageType::class, $schoolStudentAverage)
  537.         ->add('registrationStudentRegistration', EntityType::class, [
  538.             'class' => RegistrationStudentRegistration::class,
  539.             'choices' => $registration_student_registrations,
  540.             'required' => true
  541.         ]);
  542.         $school_student_average_form->handleRequest($request);
  544.         if ($school_student_average_form->isSubmitted() && $school_student_average_form->isValid()) {
  545.             $schoolStudentAverage->setSchoolAverage($schoolAverage);
  546.             $schoolStudentAverage->setCoefficient($schoolAverage->getCoefficient());
  547.             $schoolStudentAverage->setEstablishment($schoolAverage->getEstablishment());
  548.             $schoolStudentAverage->setSchoolYear($schoolAverage->getSchoolYear());
  549.             $schoolStudentAverage->setSchoolYearPeriode($schoolAverage->getSchoolYearPeriode());
  550.             $schoolStudentAverage->setNoteOn($schoolAverage->getNoteOn());
  551.             $schoolStudentAverage->setMatter($schoolAverage->getMatter());
  552.             $schoolStudentAverage->setCode('sa-'.time().$schoolAverage->getId().$schoolStudentAverage->getRegistrationStudentRegistration()->getId());
  554.             $registrationStudentRegistration = $schoolStudentAverage->getRegistrationStudentRegistration();
  555.             if (null != $schoolStudentAverageRepository->findOneBy(['registrationStudentRegistration' => $registrationStudentRegistration, 'schoolAverage' => $schoolAverage], [])) {
  556.                 $this->addFlash('warning', "Cette note existe déjà.");
  557.                 return $this->redirectToRoute('school_average_edit', ['id' => $schoolAverage->getId()]);
  558.             }
  560.             if ($schoolStudentAverage->getNote() > $schoolStudentAverage->getNoteOn() && $schoolStudentAverage->getNote() != 999) {
  561.                 $this->addFlash('warning', "Note invalide");
  562.                 return $this->redirectToRoute('school_average_edit', ['id' => $schoolAverage->getId()]);
  563.             }
  565.             if (0 > $schoolStudentAverage->getNote()) {
  566.                 $this->addFlash('warning', "Note invalide");
  567.                 return $this->redirectToRoute('school_average_edit', ['id' => $schoolAverage->getId()]);
  568.             }
  569.             
  570.             $countSubMatters = 0;
  571.             foreach ($schoolAverage->getMatter()->getSchoolSubMatters() as $key => $schoolSubMatter) {
  572.                 $schoolStudentAverage->setAsSubmatter(true);
  573.                 $countSubMatters++;
  574.                 $schoolSubStudentAverage = new SchoolStudentAverage();
  575.                 $schoolSubStudentAverage->setEstablishment($establishment);
  576.                 $schoolSubStudentAverage->setSchoolYear($schoolYear);
  577.                 $schoolSubStudentAverage->setSchoolAverage($schoolAverage);
  578.                 $schoolSubStudentAverage->setRegistrationStudentRegistration($registrationStudentRegistration);
  579.                 $schoolSubStudentAverage->setCode('sa-'.time().$schoolSubMatter->getId().$schoolAverage->getId().$registrationStudentRegistration->getId());
  580.                 $schoolSubStudentAverage->setCoefficient(1);
  581.                 $schoolSubStudentAverage->setNoteOn($schoolAverage->getNoteOn());
  582.                 $schoolSubStudentAverage->setNote(999);
  583.                 $schoolSubStudentAverage->setMatter($schoolAverage->getMatter());
  584.                 $schoolSubStudentAverage->setIsMatterConduct($schoolAverage->getMatter()->getIsMatterConduct());
  585.                 $schoolSubStudentAverage->setSubMatter($schoolSubMatter);
  586.                 $schoolSubStudentAverage->setSchoolYearPeriode($schoolAverage->getSchoolYearPeriode());
  587.                 $entityManager->persist($schoolSubStudentAverage);
  588.             }
  590.             if (count($schoolAverage->getMatter()->getSchoolSubMatters()) <= 0) {
  591.                 $entityManager->persist($schoolStudentAverage);
  592.             }
  593.             
  594.             try {
  595.                 $entityManager->flush();
  596.                 $this->addFlash('success', "Une note à été ajoutée.");
  597.             } catch (\Throwable $th) {
  598.                 $this->addFlash('warning', "Une erreure est survenue lors de l'ajout de la noteg.");
  599.                 $this->addFlash('info', $th->getMessage());
  600.             }
  602.             return $this->redirectToRoute('school_average_edit', ['id' => $schoolAverage->getId()]);
  603.         }
  605.         return $this->renderForm('school/school_average/edit.html.twig', [
  606.             'school_average' => $schoolAverage,
  607.             'form' => $form,
  609.             'schoolStudentAverage' => $schoolStudentAverage,
  610.             'school_student_average_form' => $school_student_average_form,
  612.             'school_student_averages' => $school_student_averages,
  613.             'userRepository' => $userRepository,
  614.         ]);
  615.     }
  617.     /**
  618.      * @Route("/delete-selection", name="school_averages_selected_delete", methods={"GET"})
  619.     */
  620.     public function deleteSelected(Request $request, SchoolAverageRepository $entityRepository): Response
  621.     {
  622.         $list = $request->get('entities');
  623.         $entityManager = $this->getDoctrine()->getManager();
  624.         $errors = 0;
  625.         foreach ($list as $key => $id) {
  626.             $entity = $entityRepository->findOneBy(['id' => intval($id)], []);
  627.             if ($entity != null) {
  628.                 if (!$entity->getIsValidated()) {
  629.                     foreach ($entity->getSchoolStudentAverages() as $key => $schoolStudentAverage) {
  630.                         $entityManager->remove($schoolStudentAverage);
  631.                     }
  632.                     $entityManager->remove($entity);
  633.                 }
  634.             }
  635.         }
  637.         try {
  638.             $entityManager->flush();
  639.             $this->addFlash('success', "Traitement effectué");
  640.             return $this->json(['code' => 200, 'message' => "Traitement effectué :)"], 200);
  641.         } catch (\Throwable $th) {
  642.             //$th->getMessage()
  643.             $this->addFlash('warning', $th->getMessage());
  644.         }
  645.         
  646.         $this->addFlash('warning', "Traitement non effectué");
  647.         return $this->json(['code' => 500, 'message' => "Traitement non effectué"], 200);
  648.     }
  650.     /**
  651.      * @Route("/{id}/validate", name="school_average_validate", methods={"GET"})
  652.     */
  653.     public function validate(SchoolAverage $entity): Response
  654.     {
  655.         $entityManager = $this->getDoctrine()->getManager();
  656.         foreach ($entity->getSchoolStudentAverages() as $key => $schoolStudentAverage) {
  657.             if (intval($schoolStudentAverage->getNote()) > $schoolStudentAverage->getNoteOn() && intval($schoolStudentAverage->getNote()) != 999) {
  658.                 return $this->json(['code' => 500, 'message' => "Veuillez verifier que toutes les notes sont valides ou 999 si l'élève est non classé."], 200);
  659.             }
  660.         }
  661.         
  662.         $entity->setIsValidated(true);
  664.         try {
  665.             $entityManager->flush();
  666.             $this->addFlash('success', "Traitement effectué");
  667.             return $this->json(['code' => 200, 'message' => "Traitement effectué :)"], 200);
  668.         } catch (\Throwable $th) {
  669.             //$th->getMessage()
  670.             $this->addFlash('warning', $th->getMessage());
  671.         }
  672.         
  673.         $this->addFlash('warning', "Traitement non effectué");
  674.         return $this->json(['code' => 500, 'message' => "Traitement non effectué"], 200);
  675.     }
  677.     /**
  678.      * @Route("/{id}/cancel", name="school_average_cancel", methods={"GET"})
  679.     */
  680.     public function cancel(SchoolAverage $entity): Response
  681.     {
  682.         $entityManager = $this->getDoctrine()->getManager();
  683.         $entity->setIsValidated(false);
  684.             
  685.         try {
  686.             $entityManager->flush();
  687.             $this->addFlash('success', "Traitement effectué");
  688.             return $this->json(['code' => 200, 'message' => "Traitement effectué :)"], 200);
  689.         } catch (\Throwable $th) {
  690.             //$th->getMessage()
  691.             $this->addFlash('warning', $th->getMessage());
  692.         }
  693.         
  694.         $this->addFlash('warning', "Traitement non effectué");
  695.         return $this->json(['code' => 500, 'message' => "Traitement non effectué"], 200);
  696.     }
  698.     /**
  699.      * @Route("/api/teacher-matter", name="api_school_average_teacher_matter", methods={"GET"})
  700.     */
  701.     public function apiGetTeacherMatter(Request $request, SchoolTeacherRepository $schoolTeacherRepository): Response
  702.     {
  703.         /**@var User $user */
  704.         $user = $this->getUser();
  705.         $establishment = $user->getEstablishment();
  706.         $schoolYear = $user->getSchoolYear();
  708.         $teacherId = intval($request->get('api_teacherId'));
  709.         $teacher = $schoolTeacherRepository->findOneBy(['id' => $teacherId, 'is_disabled' => 0], []);
  710.         $schoolTeacherMatterClassrooms = new ArrayCollection();
  711.             if ($teacher != null) {
  712.                 foreach ($teacher->getSchoolTeacherMatterClassrooms() as $key => $schoolTeacherMatterClassroom) {
  713.                     if (!$schoolTeacherMatterClassroom->getMatter()->getIsTestMatter() && !$schoolTeacherMatterClassroom->getIsDisabled()) {
  714.                         if ($schoolTeacherMatterClassroom->getClassroom()->getEstablishment() == $establishment) {
  715.                             if ($schoolTeacherMatterClassroom->getClassroom()->getSchoolYear() == $schoolYear) {
  716.                                 $schoolTeacherMatterClassrooms->add([
  717.                                     'id' => $schoolTeacherMatterClassroom->getId(),
  718.                                     'label' => '['.$schoolTeacherMatterClassroom->getClassroom()->getLabel().' - '.$schoolTeacherMatterClassroom->getClassroom()->getSchoolYear()->getCode().'] '.$schoolTeacherMatterClassroom->getMatter()->getLabel() 
  719.                                 ]);
  720.                             }
  721.                         }
  722.                     }
  723.                 }
  724.             }else{
  725.                 return $this->json(['code' => 500, 'message' => "not found :)"], 200);
  726.             }
  727.             
  728.             return $this->json([
  729.                 'code' => 200, 'message' => "found :)", 
  730.                 'schoolTeacherMatterClassrooms' => $schoolTeacherMatterClassrooms, 
  731.             ], 200);
  732.     }
  734.     /**
  735.      * @Route("/api/get-teacher-classrooms", name="api_school_average_get_teacher_classrooms", methods={"GET"})
  736.     */
  737.     public function apiGetTeacherClassrooms(Request $request, SchoolTeacherRepository $schoolTeacherRepository): Response
  738.     {
  739.         $teacherId = $request->get('api_teacherId');
  740.         $classrooms  = new ArrayCollection();
  741.         $matters  = new ArrayCollection();
  743.         $teacher = $schoolTeacherRepository->findOneBy(['id' => intval($teacherId), 'is_disabled' => 0], []);
  745.         foreach ($teacher->getClassrooms() as $key => $settingClassroom) {
  746.             $classrooms->add([
  747.                 'id' => $settingClassroom->getId(),
  748.                 'label' => $settingClassroom->getLabel(),
  749.             ]);
  750.         }
  752.         return $this->json([
  753.             'code' => 200, 
  754.             'message' => "found :)", 
  755.             'classrooms' => $classrooms 
  756.         ], 
  757.         200);
  758.         
  759.     }
  761.     /**
  762.      * @Route("/transcript-grades", name="school_average_transcript_grades", methods={"GET"})
  763.     */
  764.     public function transcript_grades(Pdf $knpSnappyPdf, Request $request, SchoolMatterRepository $schoolMatterRepository, RegistrationStudentRegistrationRepository $registrationStudentRegistrationRepository, SettingClassroomRepository $settingClassroomRepository, SchoolYearPeriodeRepository $schoolYearPeriodeRepository, SchoolAverageRepository $schoolAverageRepository){
  765.         /**@var User $user */
  766.         $user = $this->getUser();
  767.         $schoolYear = $user->getSchoolYear();
  769.         $establishment = $this->getUser()->getEstablishment();
  771.         $settingClassroom = $settingClassroomRepository->findOneBy(['id' => $request->get('classroom')], []);
  772.         $schoolYearPeriode = $schoolYearPeriodeRepository->findOneBy(['id' => $request->get('school_year_periode')], []);
  773.         $schoolMatter = $schoolMatterRepository->findOneBy(['id' => $request->get('matter')], []);
  775.         $schoolAverages = $schoolAverageRepository->createQueryBuilder('entity')
  777.         ->andWhere('entity.schoolYearPeriode = :schoolYearPeriode')
  778.         ->setParameter('schoolYearPeriode', $schoolYearPeriode)
  780.         ->andWhere('entity.establishment = :establishment')
  781.         ->setParameter('establishment', $establishment)
  783.         ->andWhere('entity.classroom = :classroom')
  784.         ->setParameter('classroom', $settingClassroom)
  786.         ->andWhere('entity.matter = :matter')
  787.         ->setParameter('matter', $schoolMatter)
  789.         ->orderBy('entity.label', 'ASC')
  790.         ->getQuery()
  791.         ->getResult();
  793.         $registrationStudentRegistrations = $registrationStudentRegistrationRepository->createQueryBuilder('entity')
  795.         ->andWhere('entity.schoolYear = :schoolYear')
  796.         ->setParameter('schoolYear', $schoolYear)
  798.         ->andWhere('entity.establishment = :establishment')
  799.         ->setParameter('establishment', $establishment)
  801.         ->andWhere('entity.classroom = :classroom')
  802.         ->setParameter('classroom', $settingClassroom)
  804.         ->innerJoin('entity.student', 'student')
  805.         ->addSelect('student')
  806.         
  807.         ->andWhere('student.is_archived = :is_archived')
  808.         ->setParameter('is_archived', 0)
  810.         ->orderBy('student.last_name', 'ASC')
  811.         ->getQuery()
  812.         ->getResult();
  814.         $html = $this->renderView('school/school_average/print/transcript_grades.html.twig', [
  815.             'school_averages' => $schoolAverages,
  816.             'registration_student_registrations' => $registrationStudentRegistrations,
  817.             'settingClassroom' => $settingClassroom,
  818.             'schoolYearPeriode' => $schoolYearPeriode,
  819.             'schoolMatter' => $schoolMatter,
  821.             'school_year' => $schoolYear,
  822.             'setting' => $establishment,
  823.         ]);
  825.         $file_name = "RELEVE_NOTE_.pdf";
  827.         $footer = $this->renderView('print/footer.html.twig', ['setting' => $establishment]);
  828.         $header = $this->renderView('print/header.html.twig', ['setting' => $establishment]);
  829.         
  830.         $options = [
  831.             'orientation' => 'Portrait',
  832.             'header-html' => $header,
  833.             'footer-html' => $footer
  834.         ];
  835.         
  836.         try {
  837.             $knpSnappyPdf->generateFromHtml($html, $this->getParameter('app.app_directory').'/downloads/recovery/' . $file_name, $options, true);
  838.         } catch (\Throwable $th) {
  839.             $this->addFlash('info', "Une erreur c'est produite");
  840.         }
  841.         
  843.         return $this->redirectToRoute('preview', [
  844.             'file' => $file_name,
  845.             'dir' => 'recovery',
  846.         ]);
  847.     }
  849.     /**
  850.      * @Route("/{id}/folow", name="school_average_folow", methods={"GET","POST"})
  851.      */
  852.     public function folow(SchoolTeacherRepository $schoolTeacherRepository, SchoolYearPeriode $schoolYearPeriode): Response
  853.     {
  854.         /**@var User $user */
  855.         $user = $this->getUser();
  856.         $schoolYear = $user->getSchoolYear();
  857.         $establishment = $user->getEstablishment();
  859.         $schoolTeachers = $schoolTeacherRepository->createQueryBuilder('entity')
  861.             ->innerJoin('entity.establishment', 'establishment')
  862.             ->addSelect('establishment')
  864.             ->andWhere('establishment.establishmentGroup = :establishmentGroup')
  865.             ->setParameter('establishmentGroup', $establishment->getEstablishmentGroup())
  867.             ->andWhere('entity.schoolYear = :schoolYear')
  868.             ->setParameter('schoolYear', $schoolYear)
  870.             ->andWhere('entity.is_disabled = :is_disabled')
  871.             ->setParameter('is_disabled', 0)
  873.             ->orderBy('entity.id', 'DESC')
  874.             ->getQuery()
  875.             ->getResult();
  877.         return $this->renderForm('school/school_average/folow.html.twig', [
  878.             'school_year_periode' => $schoolYearPeriode,
  879.             'school_teachers' => $schoolTeachers,
  880.         ]);
  881.     }
  882. }