src/Controller/Registration/RegistrationStudentRegistrationController.php line 1105

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Registration;
  5. use DateInterval;
  6. use Knp\Snappy\Pdf;
  7. use App\Entity\User;
  8. use DateTimeImmutable;
  9. use App\Entity\SettingFee;
  10. use App\Service\SMSSender;
  11. use App\Entity\StockKitOut;
  12. use App\Entity\TransportZone;
  13. use App\Entity\StockKitOutLine;
  14. use App\Entity\SettingClassroom;
  15. use App\Service\DateIntervalManage;
  16. use App\Entity\CommunicationMessage;
  17. use App\Entity\SettingDocumentToProvide;
  18. use App\Repository\DocManagerRepository;
  19. use App\Repository\SettingFeeRepository;
  20. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  21. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  22. use App\Repository\TransportZoneRepository;
  23. use Symfony\Component\HttpFoundation\Request;
  24. use App\Repository\EquivalentMatterRepository;
  25. use App\Repository\SchoolReportCardRepository;
  26. use App\Repository\SettingClassroomRepository;
  27. use App\Repository\StockKitCategoryRepository;
  28. use Symfony\Component\HttpFoundation\Response;
  29. use App\Entity\RegistrationStudentRegistration;
  30. use App\Entity\RegistrationTransportCheckpoint;
  31. use Symfony\Component\Routing\Annotation\Route;
  32. use App\Entity\AccountingStudentRegistrationFee;
  33. use Doctrine\Common\Collections\ArrayCollection;
  34. use Doctrine\ORM\EntityManagerInterface;
  35. use Symfony\Bridge\Doctrine\Form\Type\EntityType;
  36. use App\Entity\RegistrationStudentPreRegistration;
  37. use App\Entity\AccountingStudentRegistrationFeeShedul;
  38. use App\Repository\SettingDocumentToProvideRepository;
  39. use Symfony\Component\HttpFoundation\ResponseHeaderBag;
  40. use Knp\Bundle\SnappyBundle\Snappy\Response\PdfResponse;
  41. use Symfony\Component\Form\Extension\Core\Type\NumberType;
  42. use App\Form\Accounting\AccountingStudentRegistrationFeeType;
  43. use App\Repository\RegistrationStudentRegistrationRepository;
  44. use App\Form\Registration\RegistrationStudentRegistrationType;
  45. use App\Form\Registration\RegistrationTransportCheckpointType;
  46. use App\Repository\AccountingStudentRegistrationFeeRepository;
  47. use Sensio\Bundle\FrameworkExtraBundle\Configuration\IsGranted;
  48. use App\Repository\RegistrationStudentPreRegistrationRepository;
  49. use App\Repository\RegistrationStudentRepository;
  50. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  52. /**
  53.  * @Route("/registration/student-registration")
  54.  */
  55. class RegistrationStudentRegistrationController extends AbstractController
  56. {
  57.     /**
  58.      * @Route("/index/{_from}", name="registration_student_registration_index", methods={"GET"})
  59.      */
  60.     public function index($_from = 'All'): Response
  61.     {
  62.         return $this->render('registration/registration_student_registration/index.html.twig', [
  63.             '_from' => $_from,
  64.         ]);
  65.     }
  67.     /**
  68.      * @Route("/_searh-table/{_from}", name="registration_student_registration_searh_table", methods={"GET","POST"})
  69.      */
  70.     public function _searh_table($_from = 'All', Request $request, RegistrationStudentRegistrationRepository $registrationStudentRegistrationRepository): Response
  71.     {
  72.         /**@var User $user */
  73.         $user = $this->getUser();
  75.         $establishment = $user->getEstablishment();
  76.         $schoolYear = $user->getSchoolYear();
  78.         $query = $registrationStudentRegistrationRepository->createQueryBuilder('entity')
  80.         ->innerJoin('entity.student', 'student')
  81.         ->addSelect('student')
  83.         ->andWhere('entity.establishment = :establishment')
  84.         ->setParameter('establishment', $establishment)
  85.         
  86.         ->andWhere('entity.schoolYear = :schoolYear')
  87.         ->setParameter('schoolYear', $schoolYear)
  88.         
  89.         ->andWhere('entity.status != :status')
  90.         ->setParameter('status', RegistrationStudentRegistration::STATUS_ABANDONNE);
  92.         if ($request->get('registrationNumber')) {
  93.             $query = $query
  95.             ->andWhere('student.registration_number LIKE :registration_number')
  96.             ->setParameter('registration_number', '%'.$request->get('registrationNumber').'%');
  97.         }
  98.         
  99.         if ($request->get('code')) {
  100.             $query = $query
  101.             ->andWhere('student.code LIKE :code')
  102.             ->setParameter('code', '%'.$request->get('code').'%');
  103.         }
  105.         if ($request->get('lastName')) {
  106.             $query = $query
  107.             ->andWhere('student.last_name LIKE :last_name')
  108.             ->setParameter('last_name', '%'.$request->get('lastName').'%');
  109.         }
  111.         if ($request->get('firstName')) {
  112.             $query = $query
  113.             ->andWhere('student.first_name LIKE :first_name')
  114.             ->setParameter('first_name', '%'.$request->get('firstName').'%');
  115.         } 
  117.         if ($request->get('phoneNumber')) {
  118.             $query = $query
  119.             ->andWhere('student.notification_phone_number LIKE :notification_phone_number')
  120.             ->setParameter('notification_phone_number', '%'.$request->get('phoneNumber').'%');
  121.         } 
  123.         $query = $query
  124.         ->orderBy('student.last_name', 'ASC')
  125.         ->getQuery();
  127.         $registration_student_registrations = $query
  128.         ->setMaxResults(100)
  129.         ->getResult();
  131.         return $this->renderForm('registration/registration_student_registration/_searh_table.html.twig', [
  132.             'registration_student_registrations' => $registration_student_registrations,
  133.             '_from' => $_from,
  134.         ]);
  135.     }
  137.     /**
  138.      * @Route("/new", name="registration_student_registration_new", methods={"GET","POST"})
  139.      */
  140.     public function new(Request $request, SettingFeeRepository $settingFeeRepository, RegistrationStudentPreRegistrationRepository $registrationStudentPreRegistrationRepository, SettingDocumentToProvideRepository $settingDocumentToProvideRepository, RegistrationStudentRegistrationRepository $registrationStudentRegistrationRepository, SettingClassroomRepository $settingClassroomRepository): Response
  141.     {
  142.         /**@var User $user */
  143.         $user = $this->getUser();
  144.         $schoolYear = $user->getSchoolYear();
  145.         $establishment = $user->getEstablishment();
  146.         
  147.         if ($schoolYear == null) {
  148.             $this->addFlash('warning', "Aucune base de donnée n'est activé.");
  149.             return $this->redirectToRoute('registration_student_registration_new');
  150.         }
  151.         /* recuperation des non encore incrits */
  152.         $unregisteredRegistrationStudentPreRegistrations = new ArrayCollection();
  153.         $registrationStudentPreRegistrations = $registrationStudentPreRegistrationRepository->createQueryBuilder('entity')
  155.         ->andWhere('entity.establishment = :establishment')
  156.         ->setParameter('establishment', $establishment)
  158.         ->andWhere('entity.schoolYear = :schoolYear')
  159.         ->setParameter('schoolYear', $schoolYear)
  161.         ->getQuery()
  162.         ->getResult();
  164.         foreach ($registrationStudentPreRegistrations as $key => $registrationStudentPreRegistration) {
  165.             if ($registrationStudentPreRegistration->getStudent() != null) {
  166.                 if(count($registrationStudentPreRegistration->getRegistrationStudentRegistrations()) <= 0){
  167.                     if ($registrationStudentPreRegistration->getIsEntryTestPerformed() or !$registrationStudentPreRegistration->getIsSubjectEntryTest()) {
  168.                         $unregisteredRegistrationStudentPreRegistrations->add($registrationStudentPreRegistration);
  169.                     }
  170.                 } 
  171.             }
  172.         }
  174.         $registrationStudentRegistration = new RegistrationStudentRegistration();
  175.         $registrationStudentRegistration->setPortalLogin($registrationStudentRegistration->getId().time());
  176.         $registrationStudentRegistration->setPortalPassword(uniqid());
  178.         $form = $this->createForm(RegistrationStudentRegistrationType::class, $registrationStudentRegistration)
  179.         
  180.         ->add('registrationStudentPreRegistration', EntityType::class, [
  181.             'class' => RegistrationStudentPreRegistration::class,
  182.             'choices' => $unregisteredRegistrationStudentPreRegistrations
  183.         ])
  184.         ->add('classroom', EntityType::class, [
  185.             'class' => SettingClassroom::class,
  186.             'choices' => $settingClassroomRepository->findBy(['schoolYear' => $schoolYear, 'establishment' => $establishment], ['label' => 'ASC'])
  187.             //'choices' => $settingClassroomRepository->findBy(['schoolYear' => $schoolYear, 'is_excellent' => 0], ['label' => 'ASC'])
  188.         ])
  189.         ->add('documentProvides', EntityType::class, [
  190.             'class' => SettingDocumentToProvide::class,
  191.             'choices' => $settingDocumentToProvideRepository->findBy(['establishment' => $establishment], []),
  192.             'multiple' => true,
  193.             'required' => false
  194.         ]);
  196.         $form->handleRequest($request);
  198.         if($form->isSubmitted() && $form->isValid()) {
  199.             $entityManager = $this->getDoctrine()->getManager();
  200.             $student = $registrationStudentRegistration->getRegistrationStudentPreRegistration()->getStudent();
  202.             if ($registrationStudentRegistrationRepository->findOneBy(['establishment' => $establishment, 'schoolYear' => $schoolYear, 'student' => $student], []) != null) {
  203.                 $this->addFlash('warning', "Cet élève est déjà inscrit");
  204.                 return $this->redirectToRoute('registration_student_registration_new');
  205.             }
  207.             $registrationStudentRegistration->setSchoolYear($schoolYear);
  208.             $registrationStudentRegistration->setEstablishment($establishment);
  209.             
  210.             $registrationStudentRegistration->setStudent($student);
  211.             $registrationStudentRegistration->setIsAffected($student->getIsAffected());
  212.             
  213.             if (count($student->getRegistrationStudentRegistrations()) <= 0) {
  214.                 if ($student->getAnteriorBalance() > 0) {
  215.                     // Ajout de solde anterieur pour la première année de gestion
  216.                     $fee = $settingFeeRepository->findOneBy(['establishment' => $registrationStudentRegistration->getEstablishment(), 'schoolYear' => $schoolYear, 'label'  => 'SOLDE ANTERIEUR'], []);
  217.                     if (null == $fee) {
  218.                         $fee = new SettingFee();
  219.                         $fee->setEstablishment($registrationStudentRegistration->getEstablishment());
  220.                         $fee->setCategory('AUTRE-FRAIS');
  221.                         $fee->setLabel('SOLDE ANTERIEUR');
  222.                         $fee->setAmount(0);
  223.                         $fee->setSchoolYear($schoolYear);
  224.                         $fee->setIsForAll(false);
  225.                         $fee->setIsForAffected(false);
  226.                         $fee->setIsForNonAffected(false);
  227.                         $entityManager->persist($fee);
  228.                     }
  230.                     $anteriorAccountingStudentRegistrationFee = new AccountingStudentRegistrationFee();
  231.                     $anteriorAccountingStudentRegistrationFee->setEstablishment($registrationStudentRegistration->getEstablishment());
  232.                     $anteriorAccountingStudentRegistrationFee->setStudentRegistration($registrationStudentRegistration);
  233.                     $anteriorAccountingStudentRegistrationFee->setFee($fee);
  234.                     $anteriorAccountingStudentRegistrationFee->setAmount($student->getAnteriorBalance());
  235.                     $anteriorAccountingStudentRegistrationFee->setCode($fee->getLabel().'-'.$registrationStudentRegistration->getId());
  236.                     $anteriorAccountingStudentRegistrationFee->setLabel($fee->getLabel());
  238.                     $anteriorAccountingStudentRegistrationFeeShedul = new AccountingStudentRegistrationFeeShedul();
  239.                     $anteriorAccountingStudentRegistrationFeeShedul->setAmount($student->getAnteriorBalance());
  240.                     $anteriorAccountingStudentRegistrationFeeShedul->setDateDue(new DateTimeImmutable());
  241.                     $anteriorAccountingStudentRegistrationFeeShedul->setOrderNum(1);
  242.                     $anteriorAccountingStudentRegistrationFeeShedul->setEstablishment($registrationStudentRegistration->getEstablishment());
  243.                     $anteriorAccountingStudentRegistrationFeeShedul->setStudentRegistrationFee($anteriorAccountingStudentRegistrationFee);
  244.                     
  245.                     $entityManager->persist($anteriorAccountingStudentRegistrationFeeShedul);
  246.                     $entityManager->persist($anteriorAccountingStudentRegistrationFee);
  247.                 }
  248.             }
  250.             // Ajout de solde anterieur à partir de la deuxième année de gestion
  251.             $anteriorRegistrationStudentRegistration = $registrationStudentRegistrationRepository->findOneBy(['student' => $registrationStudentRegistration->getStudent()], ['id' => 'DESC']);
  252.             $order = 0;
  253.             if (null != $anteriorRegistrationStudentRegistration) {
  254.                 foreach ($anteriorRegistrationStudentRegistration->getAccountingStudentRegistrationFees() as $key => $accountingStudentRegistrationFee) {
  255.                     $order++;
  256.                     if (!$accountingStudentRegistrationFee->getIsArchived()) {
  257.                         if (!$accountingStudentRegistrationFee->getIsCancel()) {
  258.                             if (!$accountingStudentRegistrationFee->getIsReported()) {
  259.                                 if ($accountingStudentRegistrationFee->getAmountRest() > 0) {
  260.                                     $anteriorAccountingStudentRegistrationFee = new AccountingStudentRegistrationFee();
  261.                                     $anteriorAccountingStudentRegistrationFee->setEstablishment($registrationStudentRegistration->getEstablishment());
  262.                                     $anteriorAccountingStudentRegistrationFee->setStudentRegistration($registrationStudentRegistration);
  263.                                     $anteriorAccountingStudentRegistrationFee->setFee($accountingStudentRegistrationFee->getFee());
  264.                                     $anteriorAccountingStudentRegistrationFee->setAmount($accountingStudentRegistrationFee->getAmountRest());
  265.                                     $anteriorAccountingStudentRegistrationFee->setCode('SA-'.$accountingStudentRegistrationFee->getLabel().'-'.$registrationStudentRegistration->getId());
  266.                                     $anteriorAccountingStudentRegistrationFee->setLabel('SOLDE ANT. '.$accountingStudentRegistrationFee->getLabel());
  267.                                     $anteriorAccountingStudentRegistrationFee->setIsArchived($accountingStudentRegistrationFee->getIsArchived());
  268.                                     $anteriorAccountingStudentRegistrationFee->setIsCancel($accountingStudentRegistrationFee->getIsCancel());
  270.                                     $anteriorAccountingStudentRegistrationFeeShedul = new AccountingStudentRegistrationFeeShedul();
  271.                                     $anteriorAccountingStudentRegistrationFeeShedul->setAmount($anteriorAccountingStudentRegistrationFee->getAmount());
  272.                                     $anteriorAccountingStudentRegistrationFeeShedul->setDateDue(new DateTimeImmutable());
  273.                                     $anteriorAccountingStudentRegistrationFeeShedul->setOrderNum($order);
  274.                                     $anteriorAccountingStudentRegistrationFeeShedul->setEstablishment($registrationStudentRegistration->getEstablishment());
  275.                                     $anteriorAccountingStudentRegistrationFeeShedul->setStudentRegistrationFee($anteriorAccountingStudentRegistrationFee);
  276.                                     
  277.                                     foreach ($accountingStudentRegistrationFee->getAccountingStudentRegistrationFeeSheduls() as $key => $accountingStudentRegistrationFeeShedul) {
  278.                                         $accountingStudentRegistrationFeeShedul->setAmountReported($accountingStudentRegistrationFeeShedul->getAmountCancel() + $accountingStudentRegistrationFeeShedul->getAmountRest());
  279.                                         $accountingStudentRegistrationFeeShedul->setIsReported(true);
  280.                                     }
  281.                                     
  282.                                     $accountingStudentRegistrationFee->setIsReported(true);
  283.                                     $accountingStudentRegistrationFee->setAmountReported($accountingStudentRegistrationFee->getAmountRest());
  285.                                     $entityManager->persist($anteriorAccountingStudentRegistrationFeeShedul);
  286.                                     $entityManager->persist($anteriorAccountingStudentRegistrationFee);
  287.                                 }
  288.                             }
  289.                         }
  290.                     }
  291.                 }
  292.             }
  293.             /* Ajout des frais de SCOLARITE pour tous*/
  294.             $settingScolariteFees = $settingFeeRepository->findBy(['is_for_all' => true, 'category' => 'SCOLARITE', 'schoolYear' => $schoolYear, 'establishment' => $establishment],['id' => 'DESC']);
  295.             foreach ($settingScolariteFees as $key => $settingFee) {
  296.                 if($settingFee->getLevels()->contains($registrationStudentRegistration->getClassroom()->getLevel()->getParent()) || $settingFee->getLevels()->contains($registrationStudentRegistration->getClassroom()->getLevel()) || count($settingFee->getLevels()) <= 0){
  297.                     $accountingStudentRegistrationFee = new AccountingStudentRegistrationFee;
  298.                     $accountingStudentRegistrationFee->setStudentRegistration($registrationStudentRegistration);
  299.                     $accountingStudentRegistrationFee->setAmount($settingFee->getAmount());
  300.                     $accountingStudentRegistrationFee->setCode('ASF-'.$registrationStudentRegistration->getId().$settingFee->getId());
  301.                     $accountingStudentRegistrationFee->setFee($settingFee);
  302.                     $accountingStudentRegistrationFee->setEstablishment($this->getUser()->getEstablishment());
  303.                     $accountingStudentRegistrationFee->setLabel($settingFee->getLabel());
  304.                     $entityManager->persist($accountingStudentRegistrationFee);
  305.                     /* Etablissement des echeanciers */
  306.                     if (count($settingFee->getSettingFeeSheduls()) > 0) {
  307.                         foreach ($settingFee->getSettingFeeSheduls() as $key => $feeShedul) {
  308.                             $order++;
  309.                             $accountingStudentRegistrationFeeShedul = new AccountingStudentRegistrationFeeShedul();
  310.                             $accountingStudentRegistrationFeeShedul->setAmount($feeShedul->getAmount());
  311.                             $accountingStudentRegistrationFeeShedul->setDateDue($feeShedul->getDateDue());
  312.                             $accountingStudentRegistrationFeeShedul->setOrderNum($order);
  313.                             $accountingStudentRegistrationFeeShedul->setEstablishment($this->getUser()->getEstablishment());
  314.                             $accountingStudentRegistrationFeeShedul->setStudentRegistrationFee($accountingStudentRegistrationFee);
  315.                             $entityManager->persist($accountingStudentRegistrationFeeShedul);
  316.                         }
  317.                     }else {
  318.                         $accountingStudentRegistrationFeeShedul = new AccountingStudentRegistrationFeeShedul();
  319.                         $accountingStudentRegistrationFeeShedul->setAmount($settingFee->getAmount());
  320.                         $accountingStudentRegistrationFeeShedul->setDateDue(new DateTimeImmutable());
  321.                         $accountingStudentRegistrationFeeShedul->setOrderNum(1);
  322.                         $accountingStudentRegistrationFeeShedul->setEstablishment($this->getUser()->getEstablishment());
  323.                         $accountingStudentRegistrationFeeShedul->setStudentRegistrationFee($accountingStudentRegistrationFee);
  324.                         $entityManager->persist($accountingStudentRegistrationFeeShedul);
  325.                     }
  326.                 }
  327.             }
  328.             /* Ajout des frais de SCOLARITE  specifiques */
  329.             $settingScolariteAffectedFees = $settingFeeRepository->findBy(['is_for_affected' => true, 'category' => 'SCOLARITE', 'schoolYear' => $schoolYear, 'establishment' => $establishment],['id' => 'DESC']);
  330.             $settingScolariteNonAffectedFees = $settingFeeRepository->findBy(['is_for_non_affected' => true, 'category' => 'SCOLARITE', 'schoolYear' => $schoolYear, 'establishment' => $establishment],['id' => 'DESC']);
  331.             if ($registrationStudentRegistration->getIsAffected()) {
  332.                 foreach ($settingScolariteAffectedFees as $key => $settingFee) {
  333.                     if($settingFee->getLevels()->contains($registrationStudentRegistration->getClassroom()->getLevel()->getParent()) || $settingFee->getLevels()->contains($registrationStudentRegistration->getClassroom()->getLevel()) || count($settingFee->getLevels()) <= 0){
  334.                         $accountingStudentRegistrationFee = new AccountingStudentRegistrationFee;
  335.                         $accountingStudentRegistrationFee->setStudentRegistration($registrationStudentRegistration);
  336.                         $accountingStudentRegistrationFee->setAmount($settingFee->getAmount());
  337.                         $accountingStudentRegistrationFee->setCode('ASF-'.$registrationStudentRegistration->getId().$settingFee->getId());
  338.                         $accountingStudentRegistrationFee->setFee($settingFee);
  339.                         $accountingStudentRegistrationFee->setEstablishment($this->getUser()->getEstablishment());
  340.                         $accountingStudentRegistrationFee->setLabel($settingFee->getLabel());
  341.                         $entityManager->persist($accountingStudentRegistrationFee);
  342.                         /* Etablissement des echeancier */
  343.                         if (count($settingFee->getSettingFeeSheduls()) > 0) {
  344.                             foreach ($settingFee->getSettingFeeSheduls() as $key => $feeShedul) {
  345.                                 $order++;
  346.                                 $accountingStudentRegistrationFeeShedul = new AccountingStudentRegistrationFeeShedul();
  347.                                 $accountingStudentRegistrationFeeShedul->setAmount($feeShedul->getAmount());
  348.                                 $accountingStudentRegistrationFeeShedul->setDateDue($feeShedul->getDateDue());
  349.                                 $accountingStudentRegistrationFeeShedul->setOrderNum($order);
  350.                                 $accountingStudentRegistrationFeeShedul->setEstablishment($this->getUser()->getEstablishment());
  351.                                 $accountingStudentRegistrationFeeShedul->setStudentRegistrationFee($accountingStudentRegistrationFee);
  352.                                 $entityManager->persist($accountingStudentRegistrationFeeShedul);
  353.                             }
  354.                         }else {
  355.                             $accountingStudentRegistrationFeeShedul = new AccountingStudentRegistrationFeeShedul();
  356.                             $accountingStudentRegistrationFeeShedul->setAmount($settingFee->getAmount());
  357.                             $accountingStudentRegistrationFeeShedul->setDateDue(new DateTimeImmutable());
  358.                             $accountingStudentRegistrationFeeShedul->setOrderNum(1);
  359.                             $accountingStudentRegistrationFeeShedul->setEstablishment($this->getUser()->getEstablishment());
  360.                             $accountingStudentRegistrationFeeShedul->setStudentRegistrationFee($accountingStudentRegistrationFee);
  361.                             $entityManager->persist($accountingStudentRegistrationFeeShedul);
  362.                         }
  363.                     }
  364.                 }
  365.             }else{
  366.                 foreach ($settingScolariteNonAffectedFees as $key => $settingFee) {
  367.                     if($settingFee->getLevels()->contains($registrationStudentRegistration->getClassroom()->getLevel()->getParent()) || $settingFee->getLevels()->contains($registrationStudentRegistration->getClassroom()->getLevel()) || count($settingFee->getLevels()) <= 0){
  368.                         $accountingStudentRegistrationFee = new AccountingStudentRegistrationFee;
  369.                         $accountingStudentRegistrationFee->setStudentRegistration($registrationStudentRegistration);
  370.                         $accountingStudentRegistrationFee->setAmount($settingFee->getAmount());
  371.                         $accountingStudentRegistrationFee->setCode('ASF-'.$registrationStudentRegistration->getId().$settingFee->getId());
  372.                         $accountingStudentRegistrationFee->setFee($settingFee);
  373.                         $accountingStudentRegistrationFee->setEstablishment($this->getUser()->getEstablishment());
  374.                         $accountingStudentRegistrationFee->setLabel($settingFee->getLabel());
  375.                         $entityManager->persist($accountingStudentRegistrationFee);
  376.                         /* Etablissement des echeancier */
  377.                         if (count($settingFee->getSettingFeeSheduls()) > 0) {
  378.                             foreach ($settingFee->getSettingFeeSheduls() as $key => $feeShedul) {
  379.                                 $order++;
  380.                                 $accountingStudentRegistrationFeeShedul = new AccountingStudentRegistrationFeeShedul();
  381.                                 $accountingStudentRegistrationFeeShedul->setAmount($feeShedul->getAmount());
  382.                                 $accountingStudentRegistrationFeeShedul->setDateDue($feeShedul->getDateDue());
  383.                                 $accountingStudentRegistrationFeeShedul->setOrderNum($order);
  384.                                 $accountingStudentRegistrationFeeShedul->setEstablishment($this->getUser()->getEstablishment());
  385.                                 $accountingStudentRegistrationFeeShedul->setStudentRegistrationFee($accountingStudentRegistrationFee);
  386.                                 $entityManager->persist($accountingStudentRegistrationFeeShedul);
  387.                             }
  388.                         }else {
  389.                             $accountingStudentRegistrationFeeShedul = new AccountingStudentRegistrationFeeShedul();
  390.                             $accountingStudentRegistrationFeeShedul->setAmount($settingFee->getAmount());
  391.                             $accountingStudentRegistrationFeeShedul->setDateDue(new DateTimeImmutable());
  392.                             $accountingStudentRegistrationFeeShedul->setOrderNum(1);
  393.                             $accountingStudentRegistrationFeeShedul->setEstablishment($this->getUser()->getEstablishment());
  394.                             $accountingStudentRegistrationFeeShedul->setStudentRegistrationFee($accountingStudentRegistrationFee);
  395.                             $entityManager->persist($accountingStudentRegistrationFeeShedul);
  396.                         }
  397.                     }
  398.                 }
  399.             }
  401.             /* Ajout des frais de ARTICLE pour tous */
  402.             $settingArticleFees = $settingFeeRepository->findBy(['is_for_all' => true, 'category' => 'ARTICLE', 'schoolYear' => $schoolYear, 'establishment' => $establishment],['id' => 'DESC']);
  403.             $settingArticleAffectedFees = $settingFeeRepository->findBy(['is_for_affected' => true, 'category' => 'ARTICLE', 'schoolYear' => $schoolYear, 'establishment' => $establishment],['id' => 'DESC']);
  404.             $settingArticleNonAffectedFees = $settingFeeRepository->findBy(['is_for_non_affected' => true, 'category' => 'ARTICLE', 'schoolYear' => $schoolYear, 'establishment' => $establishment],['id' => 'DESC']);
  405.             foreach ($settingArticleFees as $key => $settingFee) {
  406.                 if($settingFee->getLevels()->contains($registrationStudentRegistration->getClassroom()->getLevel()->getParent()) || $settingFee->getLevels()->contains($registrationStudentRegistration->getClassroom()->getLevel()) || count($settingFee->getLevels()) <= 0){
  407.                     $accountingStudentRegistrationFee = new AccountingStudentRegistrationFee;
  408.                     $accountingStudentRegistrationFee->setStudentRegistration($registrationStudentRegistration);
  409.                     $accountingStudentRegistrationFee->setAmount($settingFee->getAmount());
  410.                     $accountingStudentRegistrationFee->setCode('ASF-'.$registrationStudentRegistration->getId().$settingFee->getId());
  411.                     $accountingStudentRegistrationFee->setFee($settingFee);
  412.                     $accountingStudentRegistrationFee->setEstablishment($this->getUser()->getEstablishment());
  413.                     $accountingStudentRegistrationFee->setLabel($settingFee->getLabel());
  414.                     $entityManager->persist($accountingStudentRegistrationFee);
  416.                     /* Etablissement des echeancier */
  417.                     if (count($settingFee->getSettingFeeSheduls()) > 0) {
  418.                         foreach ($settingFee->getSettingFeeSheduls() as $key => $feeShedul) {
  419.                             $order++;
  420.                             $accountingStudentRegistrationFeeShedul = new AccountingStudentRegistrationFeeShedul();
  421.                             $accountingStudentRegistrationFeeShedul->setAmount($feeShedul->getAmount());
  422.                             $accountingStudentRegistrationFeeShedul->setDateDue($feeShedul->getDateDue());
  423.                             $accountingStudentRegistrationFeeShedul->setOrderNum($order);
  424.                             $accountingStudentRegistrationFeeShedul->setEstablishment($this->getUser()->getEstablishment());
  425.                             $accountingStudentRegistrationFeeShedul->setStudentRegistrationFee($accountingStudentRegistrationFee);
  426.                             $entityManager->persist($accountingStudentRegistrationFeeShedul);
  427.                         }
  428.                     }else {
  429.                         $accountingStudentRegistrationFeeShedul = new AccountingStudentRegistrationFeeShedul();
  430.                         $accountingStudentRegistrationFeeShedul->setAmount($settingFee->getAmount());
  431.                         $accountingStudentRegistrationFeeShedul->setDateDue(new DateTimeImmutable());
  432.                         $accountingStudentRegistrationFeeShedul->setOrderNum(1);
  433.                         $accountingStudentRegistrationFeeShedul->setEstablishment($this->getUser()->getEstablishment());
  434.                         $accountingStudentRegistrationFeeShedul->setStudentRegistrationFee($accountingStudentRegistrationFee);
  435.                         $entityManager->persist($accountingStudentRegistrationFeeShedul);
  436.                     }
  437.                 }
  438.             }
  439.             /* Ajout des frais de ARTICLE specifique */
  440.             if ($registrationStudentRegistration->getIsAffected()) {
  441.                 foreach ($settingArticleAffectedFees as $key => $settingFee) {
  442.                     if($settingFee->getLevels()->contains($registrationStudentRegistration->getClassroom()->getLevel()->getParent()) || $settingFee->getLevels()->contains($registrationStudentRegistration->getClassroom()->getLevel()) || count($settingFee->getLevels()) <= 0){
  443.                         $accountingStudentRegistrationFee = new AccountingStudentRegistrationFee;
  444.                         $accountingStudentRegistrationFee->setStudentRegistration($registrationStudentRegistration);
  445.                         $accountingStudentRegistrationFee->setAmount($settingFee->getAmount());
  446.                         $accountingStudentRegistrationFee->setCode('ASF-'.$registrationStudentRegistration->getId().$settingFee->getId());
  447.                         $accountingStudentRegistrationFee->setFee($settingFee);
  448.                         $accountingStudentRegistrationFee->setEstablishment($this->getUser()->getEstablishment());
  449.                         $accountingStudentRegistrationFee->setLabel($settingFee->getLabel());
  450.                         $entityManager->persist($accountingStudentRegistrationFee);
  452.                         /* Etablissement des echeancier */
  453.                         if (count($settingFee->getSettingFeeSheduls()) > 0) {
  454.                             foreach ($settingFee->getSettingFeeSheduls() as $key => $feeShedul) {
  455.                                 $order++;
  456.                                 $accountingStudentRegistrationFeeShedul = new AccountingStudentRegistrationFeeShedul();
  457.                                 $accountingStudentRegistrationFeeShedul->setAmount($feeShedul->getAmount());
  458.                                 $accountingStudentRegistrationFeeShedul->setDateDue($feeShedul->getDateDue());
  459.                                 $accountingStudentRegistrationFeeShedul->setOrderNum($order);
  460.                                 $accountingStudentRegistrationFeeShedul->setEstablishment($this->getUser()->getEstablishment());
  461.                                 $accountingStudentRegistrationFeeShedul->setStudentRegistrationFee($accountingStudentRegistrationFee);
  462.                                 $entityManager->persist($accountingStudentRegistrationFeeShedul);
  463.                             }
  464.                         }else {
  465.                             $accountingStudentRegistrationFeeShedul = new AccountingStudentRegistrationFeeShedul();
  466.                             $accountingStudentRegistrationFeeShedul->setAmount($settingFee->getAmount());
  467.                             $accountingStudentRegistrationFeeShedul->setDateDue(new DateTimeImmutable());
  468.                             $accountingStudentRegistrationFeeShedul->setOrderNum(1);
  469.                             $accountingStudentRegistrationFeeShedul->setEstablishment($this->getUser()->getEstablishment());
  470.                             $accountingStudentRegistrationFeeShedul->setStudentRegistrationFee($accountingStudentRegistrationFee);
  471.                             $entityManager->persist($accountingStudentRegistrationFeeShedul);
  472.                         }
  473.                     }
  474.                 }
  475.             }else {
  476.                 foreach ($settingArticleNonAffectedFees as $key => $settingFee) {
  477.                     if($settingFee->getLevels()->contains($registrationStudentRegistration->getClassroom()->getLevel()->getParent()) || $settingFee->getLevels()->contains($registrationStudentRegistration->getClassroom()->getLevel()) || count($settingFee->getLevels()) <= 0){
  478.                         $accountingStudentRegistrationFee = new AccountingStudentRegistrationFee;
  479.                         $accountingStudentRegistrationFee->setStudentRegistration($registrationStudentRegistration);
  480.                         $accountingStudentRegistrationFee->setAmount($settingFee->getAmount());
  481.                         $accountingStudentRegistrationFee->setCode('ASF-'.$registrationStudentRegistration->getId().$settingFee->getId());
  482.                         $accountingStudentRegistrationFee->setFee($settingFee);
  483.                         $accountingStudentRegistrationFee->setEstablishment($this->getUser()->getEstablishment());
  484.                         $accountingStudentRegistrationFee->setLabel($settingFee->getLabel());
  485.                         $entityManager->persist($accountingStudentRegistrationFee);
  487.                         /* Etablissement des echeancier */
  488.                         if (count($settingFee->getSettingFeeSheduls()) > 0) {
  489.                             foreach ($settingFee->getSettingFeeSheduls() as $key => $feeShedul) {
  490.                                 $order++;
  491.                                 $accountingStudentRegistrationFeeShedul = new AccountingStudentRegistrationFeeShedul();
  492.                                 $accountingStudentRegistrationFeeShedul->setAmount($feeShedul->getAmount());
  493.                                 $accountingStudentRegistrationFeeShedul->setDateDue($feeShedul->getDateDue());
  494.                                 $accountingStudentRegistrationFeeShedul->setOrderNum($order);
  495.                                 $accountingStudentRegistrationFeeShedul->setEstablishment($this->getUser()->getEstablishment());
  496.                                 $accountingStudentRegistrationFeeShedul->setStudentRegistrationFee($accountingStudentRegistrationFee);
  497.                                 $entityManager->persist($accountingStudentRegistrationFeeShedul);
  498.                             }
  499.                         }else {
  500.                             $accountingStudentRegistrationFeeShedul = new AccountingStudentRegistrationFeeShedul();
  501.                             $accountingStudentRegistrationFeeShedul->setAmount($settingFee->getAmount());
  502.                             $accountingStudentRegistrationFeeShedul->setDateDue(new DateTimeImmutable());
  503.                             $accountingStudentRegistrationFeeShedul->setOrderNum(1);
  504.                             $accountingStudentRegistrationFeeShedul->setEstablishment($this->getUser()->getEstablishment());
  505.                             $accountingStudentRegistrationFeeShedul->setStudentRegistrationFee($accountingStudentRegistrationFee);
  506.                             $entityManager->persist($accountingStudentRegistrationFeeShedul);
  507.                         }
  508.                     }
  509.                 }
  510.             }
  512.             /* Ajout des frais de ACTIVITE-EXTAT pour tous */
  513.             $settingActiviteExtratFees = $settingFeeRepository->findBy(['is_for_all' => true, 'category' => 'ACTIVITE-EXTAT', 'schoolYear' => $schoolYear, 'establishment' => $establishment],['id' => 'DESC']);
  514.             $settingActiviteExtratAffectedFees = $settingFeeRepository->findBy(['is_for_affected' => true, 'category' => 'ACTIVITE-EXTAT', 'schoolYear' => $schoolYear, 'establishment' => $establishment],['id' => 'DESC']);
  515.             $settingActiviteExtratNonAffectedFees = $settingFeeRepository->findBy(['is_for_non_affected' => true, 'category' => 'ACTIVITE-EXTAT', 'schoolYear' => $schoolYear, 'establishment' => $establishment],['id' => 'DESC']);
  516.             foreach ($settingActiviteExtratFees as $key => $settingFee) {
  517.                 if($settingFee->getLevels()->contains($registrationStudentRegistration->getClassroom()->getLevel()->getParent()) || $settingFee->getLevels()->contains($registrationStudentRegistration->getClassroom()->getLevel()) || count($settingFee->getLevels()) <= 0){
  518.                     $accountingStudentRegistrationFee = new AccountingStudentRegistrationFee;
  519.                     $accountingStudentRegistrationFee->setStudentRegistration($registrationStudentRegistration);
  520.                     $accountingStudentRegistrationFee->setAmount($settingFee->getAmount());
  521.                     $accountingStudentRegistrationFee->setCode('ASF-'.$registrationStudentRegistration->getId().$settingFee->getId());
  522.                     $accountingStudentRegistrationFee->setFee($settingFee);
  523.                     $accountingStudentRegistrationFee->setEstablishment($this->getUser()->getEstablishment());
  524.                     $accountingStudentRegistrationFee->setLabel($settingFee->getLabel());
  525.                     $entityManager->persist($accountingStudentRegistrationFee);
  527.                     /* Etablissement des echeancier */
  528.                     if (count($settingFee->getSettingFeeSheduls()) > 0) {
  529.                         foreach ($settingFee->getSettingFeeSheduls() as $key => $feeShedul) {
  530.                             $order++;
  531.                             $accountingStudentRegistrationFeeShedul = new AccountingStudentRegistrationFeeShedul();
  532.                             $accountingStudentRegistrationFeeShedul->setAmount($feeShedul->getAmount());
  533.                             $accountingStudentRegistrationFeeShedul->setDateDue($feeShedul->getDateDue());
  534.                             $accountingStudentRegistrationFeeShedul->setOrderNum($order);
  535.                             $accountingStudentRegistrationFeeShedul->setEstablishment($this->getUser()->getEstablishment());
  536.                             $accountingStudentRegistrationFeeShedul->setStudentRegistrationFee($accountingStudentRegistrationFee);
  537.                             $entityManager->persist($accountingStudentRegistrationFeeShedul);
  538.                         }
  539.                     }else {
  540.                         $accountingStudentRegistrationFeeShedul = new AccountingStudentRegistrationFeeShedul();
  541.                         $accountingStudentRegistrationFeeShedul->setAmount($settingFee->getAmount());
  542.                         $accountingStudentRegistrationFeeShedul->setDateDue(new DateTimeImmutable());
  543.                         $accountingStudentRegistrationFeeShedul->setOrderNum(1);
  544.                         $accountingStudentRegistrationFeeShedul->setEstablishment($this->getUser()->getEstablishment());
  545.                         $accountingStudentRegistrationFeeShedul->setStudentRegistrationFee($accountingStudentRegistrationFee);
  546.                         $entityManager->persist($accountingStudentRegistrationFeeShedul);
  547.                     }
  548.                 }
  549.             }
  550.             /* Ajout des frais de ACTIVITE-EXTAT specifique */
  551.             if ($registrationStudentRegistration->getIsAffected()) {
  552.                 foreach ($settingActiviteExtratAffectedFees as $key => $settingFee) {
  553.                     if($settingFee->getLevels()->contains($registrationStudentRegistration->getClassroom()->getLevel()->getParent()) || $settingFee->getLevels()->contains($registrationStudentRegistration->getClassroom()->getLevel()) || count($settingFee->getLevels()) <= 0){
  554.                         $accountingStudentRegistrationFee = new AccountingStudentRegistrationFee;
  555.                         $accountingStudentRegistrationFee->setStudentRegistration($registrationStudentRegistration);
  556.                         $accountingStudentRegistrationFee->setAmount($settingFee->getAmount());
  557.                         $accountingStudentRegistrationFee->setCode('ASF-'.$registrationStudentRegistration->getId().$settingFee->getId());
  558.                         $accountingStudentRegistrationFee->setFee($settingFee);
  559.                         $accountingStudentRegistrationFee->setEstablishment($this->getUser()->getEstablishment());
  560.                         $accountingStudentRegistrationFee->setLabel($settingFee->getLabel());
  561.                         $entityManager->persist($accountingStudentRegistrationFee);
  563.                         /* Etablissement des echeancier */
  564.                         if (count($settingFee->getSettingFeeSheduls()) > 0) {
  565.                             foreach ($settingFee->getSettingFeeSheduls() as $key => $feeShedul) {
  566.                                 $order++;
  567.                                 $accountingStudentRegistrationFeeShedul = new AccountingStudentRegistrationFeeShedul();
  568.                                 $accountingStudentRegistrationFeeShedul->setAmount($feeShedul->getAmount());
  569.                                 $accountingStudentRegistrationFeeShedul->setDateDue($feeShedul->getDateDue());
  570.                                 $accountingStudentRegistrationFeeShedul->setOrderNum($order);
  571.                                 $accountingStudentRegistrationFeeShedul->setEstablishment($this->getUser()->getEstablishment());
  572.                                 $accountingStudentRegistrationFeeShedul->setStudentRegistrationFee($accountingStudentRegistrationFee);
  573.                                 $entityManager->persist($accountingStudentRegistrationFeeShedul);
  574.                             }
  575.                         }else {
  576.                             $order++;
  577.                             $accountingStudentRegistrationFeeShedul = new AccountingStudentRegistrationFeeShedul();
  578.                             $accountingStudentRegistrationFeeShedul->setAmount($settingFee->getAmount());
  579.                             $accountingStudentRegistrationFeeShedul->setDateDue(new DateTimeImmutable());
  580.                             $accountingStudentRegistrationFeeShedul->setOrderNum($order);
  581.                             $accountingStudentRegistrationFeeShedul->setEstablishment($this->getUser()->getEstablishment());
  582.                             $accountingStudentRegistrationFeeShedul->setStudentRegistrationFee($accountingStudentRegistrationFee);
  583.                             $entityManager->persist($accountingStudentRegistrationFeeShedul);
  584.                         }
  585.                     }
  586.                 }
  587.             }else {
  588.                 foreach ($settingActiviteExtratNonAffectedFees as $key => $settingFee) {
  589.                     if($settingFee->getLevels()->contains($registrationStudentRegistration->getClassroom()->getLevel()->getParent()) || $settingFee->getLevels()->contains($registrationStudentRegistration->getClassroom()->getLevel()) || count($settingFee->getLevels()) <= 0){
  590.                         $accountingStudentRegistrationFee = new AccountingStudentRegistrationFee;
  591.                         $accountingStudentRegistrationFee->setStudentRegistration($registrationStudentRegistration);
  592.                         $accountingStudentRegistrationFee->setAmount($settingFee->getAmount());
  593.                         $accountingStudentRegistrationFee->setCode('ASF-'.$registrationStudentRegistration->getId().$settingFee->getId());
  594.                         $accountingStudentRegistrationFee->setFee($settingFee);
  595.                         $accountingStudentRegistrationFee->setEstablishment($this->getUser()->getEstablishment());
  596.                         $accountingStudentRegistrationFee->setLabel($settingFee->getLabel());
  597.                         $entityManager->persist($accountingStudentRegistrationFee);
  599.                         /* Etablissement des echeancier */
  600.                         if (count($settingFee->getSettingFeeSheduls()) > 0) {
  601.                             foreach ($settingFee->getSettingFeeSheduls() as $key => $feeShedul) {
  602.                                 $order++;
  603.                                 $accountingStudentRegistrationFeeShedul = new AccountingStudentRegistrationFeeShedul();
  604.                                 $accountingStudentRegistrationFeeShedul->setAmount($feeShedul->getAmount());
  605.                                 $accountingStudentRegistrationFeeShedul->setDateDue($feeShedul->getDateDue());
  606.                                 $accountingStudentRegistrationFeeShedul->setOrderNum($order);
  607.                                 $accountingStudentRegistrationFeeShedul->setEstablishment($this->getUser()->getEstablishment());
  608.                                 $accountingStudentRegistrationFeeShedul->setStudentRegistrationFee($accountingStudentRegistrationFee);
  609.                                 $entityManager->persist($accountingStudentRegistrationFeeShedul);
  610.                             }
  611.                         }else {
  612.                             $order++;
  613.                             $accountingStudentRegistrationFeeShedul = new AccountingStudentRegistrationFeeShedul();
  614.                             $accountingStudentRegistrationFeeShedul->setAmount($settingFee->getAmount());
  615.                             $accountingStudentRegistrationFeeShedul->setDateDue(new DateTimeImmutable());
  616.                             $accountingStudentRegistrationFeeShedul->setOrderNum($order);
  617.                             $accountingStudentRegistrationFeeShedul->setEstablishment($this->getUser()->getEstablishment());
  618.                             $accountingStudentRegistrationFeeShedul->setStudentRegistrationFee($accountingStudentRegistrationFee);
  619.                             $entityManager->persist($accountingStudentRegistrationFeeShedul);
  620.                         }
  621.                     }
  622.                 }
  623.             }
  625.             /* Ajout des frais de AUTRE-FRAIS pour tous */
  626.             $settingAutreFraisFees = $settingFeeRepository->findBy(['is_for_all' => true, 'category' => 'AUTRE-FRAIS', 'schoolYear' => $schoolYear, 'establishment' => $establishment],['id' => 'DESC']);
  627.             $settingAutreFraisAffectedFees = $settingFeeRepository->findBy(['is_for_affected' => true, 'category' => 'AUTRE-FRAIS', 'schoolYear' => $schoolYear, 'establishment' => $establishment],['id' => 'DESC']);
  628.             $settingAutreFraisNonAffectedFees = $settingFeeRepository->findBy(['is_for_non_affected' => true, 'category' => 'AUTRE-FRAIS', 'schoolYear' => $schoolYear, 'establishment' => $establishment],['id' => 'DESC']);
  629.             foreach ($settingAutreFraisFees as $key => $settingFee) {
  630.                 if($settingFee->getLevels()->contains($registrationStudentRegistration->getClassroom()->getLevel()->getParent()) || $settingFee->getLevels()->contains($registrationStudentRegistration->getClassroom()->getLevel()) || count($settingFee->getLevels()) <= 0){
  631.                     $accountingStudentRegistrationFee = new AccountingStudentRegistrationFee;
  632.                     $accountingStudentRegistrationFee->setStudentRegistration($registrationStudentRegistration);
  633.                     $accountingStudentRegistrationFee->setAmount($settingFee->getAmount());
  634.                     $accountingStudentRegistrationFee->setCode('ASF-'.$registrationStudentRegistration->getId().$settingFee->getId());
  635.                     $accountingStudentRegistrationFee->setFee($settingFee);
  636.                     $accountingStudentRegistrationFee->setEstablishment($this->getUser()->getEstablishment());
  637.                     $accountingStudentRegistrationFee->setLabel($settingFee->getLabel());
  638.                     $entityManager->persist($accountingStudentRegistrationFee);
  640.                     /* Etablissement des echeancier */
  641.                     if (count($settingFee->getSettingFeeSheduls()) > 0) {
  642.                         foreach ($settingFee->getSettingFeeSheduls() as $key => $feeShedul) {
  643.                             $order++;
  644.                             $accountingStudentRegistrationFeeShedul = new AccountingStudentRegistrationFeeShedul();
  645.                             $accountingStudentRegistrationFeeShedul->setAmount($feeShedul->getAmount());
  646.                             $accountingStudentRegistrationFeeShedul->setDateDue($feeShedul->getDateDue());
  647.                             $accountingStudentRegistrationFeeShedul->setOrderNum($order);
  648.                             $accountingStudentRegistrationFeeShedul->setEstablishment($this->getUser()->getEstablishment());
  649.                             $accountingStudentRegistrationFeeShedul->setStudentRegistrationFee($accountingStudentRegistrationFee);
  650.                             $entityManager->persist($accountingStudentRegistrationFeeShedul);
  651.                         }
  652.                     }else {
  653.                         $order++;
  654.                         $accountingStudentRegistrationFeeShedul = new AccountingStudentRegistrationFeeShedul();
  655.                         $accountingStudentRegistrationFeeShedul->setAmount($settingFee->getAmount());
  656.                         $accountingStudentRegistrationFeeShedul->setDateDue(new DateTimeImmutable());
  657.                         $accountingStudentRegistrationFeeShedul->setOrderNum($order);
  658.                         $accountingStudentRegistrationFeeShedul->setEstablishment($this->getUser()->getEstablishment());
  659.                         $accountingStudentRegistrationFeeShedul->setStudentRegistrationFee($accountingStudentRegistrationFee);
  660.                         $entityManager->persist($accountingStudentRegistrationFeeShedul);
  661.                     }
  662.                 }
  663.             }
  664.             /* Ajout des frais de ACTIVITE-EXTAT specifique */
  665.             if ($registrationStudentRegistration->getIsAffected()) {
  666.                 foreach ($settingAutreFraisAffectedFees as $key => $settingFee) {
  667.                     if($settingFee->getLevels()->contains($registrationStudentRegistration->getClassroom()->getLevel()->getParent()) || $settingFee->getLevels()->contains($registrationStudentRegistration->getClassroom()->getLevel()) || count($settingFee->getLevels()) <= 0){
  668.                         $accountingStudentRegistrationFee = new AccountingStudentRegistrationFee;
  669.                         $accountingStudentRegistrationFee->setStudentRegistration($registrationStudentRegistration);
  670.                         $accountingStudentRegistrationFee->setAmount($settingFee->getAmount());
  671.                         $accountingStudentRegistrationFee->setCode('ASF-'.$registrationStudentRegistration->getId().$settingFee->getId());
  672.                         $accountingStudentRegistrationFee->setFee($settingFee);
  673.                         $accountingStudentRegistrationFee->setEstablishment($this->getUser()->getEstablishment());
  674.                         $accountingStudentRegistrationFee->setLabel($settingFee->getLabel());
  675.                         $entityManager->persist($accountingStudentRegistrationFee);
  677.                         /* Etablissement des echeancier */
  678.                         if (count($settingFee->getSettingFeeSheduls()) > 0) {
  679.                             foreach ($settingFee->getSettingFeeSheduls() as $key => $feeShedul) {
  680.                                 $order++;
  681.                                 $accountingStudentRegistrationFeeShedul = new AccountingStudentRegistrationFeeShedul();
  682.                                 $accountingStudentRegistrationFeeShedul->setAmount($feeShedul->getAmount());
  683.                                 $accountingStudentRegistrationFeeShedul->setDateDue($feeShedul->getDateDue());
  684.                                 $accountingStudentRegistrationFeeShedul->setOrderNum($order);
  685.                                 $accountingStudentRegistrationFeeShedul->setEstablishment($this->getUser()->getEstablishment());
  686.                                 $accountingStudentRegistrationFeeShedul->setStudentRegistrationFee($accountingStudentRegistrationFee);
  687.                                 $entityManager->persist($accountingStudentRegistrationFeeShedul);
  688.                             }
  689.                         }else {
  690.                             $order++;
  691.                             $accountingStudentRegistrationFeeShedul = new AccountingStudentRegistrationFeeShedul();
  692.                             $accountingStudentRegistrationFeeShedul->setAmount($settingFee->getAmount());
  693.                             $accountingStudentRegistrationFeeShedul->setDateDue(new DateTimeImmutable());
  694.                             $accountingStudentRegistrationFeeShedul->setOrderNum($order);
  695.                             $accountingStudentRegistrationFeeShedul->setEstablishment($this->getUser()->getEstablishment());
  696.                             $accountingStudentRegistrationFeeShedul->setStudentRegistrationFee($accountingStudentRegistrationFee);
  697.                             $entityManager->persist($accountingStudentRegistrationFeeShedul);
  698.                         }
  699.                     }
  700.                 }
  701.             }else {
  702.                 foreach ($settingAutreFraisNonAffectedFees as $key => $settingFee) {
  703.                     if($settingFee->getLevels()->contains($registrationStudentRegistration->getClassroom()->getLevel()->getParent()) || $settingFee->getLevels()->contains($registrationStudentRegistration->getClassroom()->getLevel()) || count($settingFee->getLevels()) <= 0){
  704.                         $accountingStudentRegistrationFee = new AccountingStudentRegistrationFee;
  705.                         $accountingStudentRegistrationFee->setStudentRegistration($registrationStudentRegistration);
  706.                         $accountingStudentRegistrationFee->setAmount($settingFee->getAmount());
  707.                         $accountingStudentRegistrationFee->setCode('ASF-'.$registrationStudentRegistration->getId().$settingFee->getId());
  708.                         $accountingStudentRegistrationFee->setFee($settingFee);
  709.                         $accountingStudentRegistrationFee->setEstablishment($this->getUser()->getEstablishment());
  710.                         $accountingStudentRegistrationFee->setLabel($settingFee->getLabel());
  711.                         $entityManager->persist($accountingStudentRegistrationFee);
  713.                         /* Etablissement des echeancier */
  714.                         if (count($settingFee->getSettingFeeSheduls()) > 0) {
  715.                             foreach ($settingFee->getSettingFeeSheduls() as $key => $feeShedul) {
  716.                                 $order++;
  717.                                 $accountingStudentRegistrationFeeShedul = new AccountingStudentRegistrationFeeShedul();
  718.                                 $accountingStudentRegistrationFeeShedul->setAmount($feeShedul->getAmount());
  719.                                 $accountingStudentRegistrationFeeShedul->setDateDue($feeShedul->getDateDue());
  720.                                 $accountingStudentRegistrationFeeShedul->setOrderNum($order);
  721.                                 $accountingStudentRegistrationFeeShedul->setEstablishment($this->getUser()->getEstablishment());
  722.                                 $accountingStudentRegistrationFeeShedul->setStudentRegistrationFee($accountingStudentRegistrationFee);
  723.                                 $entityManager->persist($accountingStudentRegistrationFeeShedul);
  724.                             }
  725.                         }else {
  726.                             $order++;
  727.                             $accountingStudentRegistrationFeeShedul = new AccountingStudentRegistrationFeeShedul();
  728.                             $accountingStudentRegistrationFeeShedul->setAmount($settingFee->getAmount());
  729.                             $accountingStudentRegistrationFeeShedul->setDateDue(new DateTimeImmutable());
  730.                             $accountingStudentRegistrationFeeShedul->setOrderNum($order);
  731.                             $accountingStudentRegistrationFeeShedul->setEstablishment($this->getUser()->getEstablishment());
  732.                             $accountingStudentRegistrationFeeShedul->setStudentRegistrationFee($accountingStudentRegistrationFee);
  733.                             $entityManager->persist($accountingStudentRegistrationFeeShedul);
  734.                         }
  735.                     }
  736.                 }
  737.             }
  739.             $entityManager->persist($registrationStudentRegistration);
  740.             try {
  741.                 $entityManager->flush();
  742.                 $this->addFlash('success', "Un inscrit à été ajouté.");
  743.             } catch (\Throwable $th) {
  744.                 $this->addFlash('warning', "Une erreure est survenue lors de l'ajout de l'inscrit.");
  745.                 $this->addFlash('info', $th->getMessage());
  746.             }
  748.             return $this->redirectToRoute('registration_student_registration_index', [], Response::HTTP_SEE_OTHER);
  749.         }
  751.         return $this->renderForm('registration/registration_student_registration/new.html.twig', [
  752.             'registration_student_registration' => $registrationStudentRegistration,
  753.             'form' => $form,
  754.         ]);
  755.     }
  757.     /**
  758.      * @Route("/{id}/show", name="registration_student_registration_show", methods={"GET","POST"})
  759.      */
  760.     public function show(Request $request, RegistrationStudentRegistration $registrationStudentRegistration, SettingFeeRepository $settingFeeRepository, TransportZoneRepository $transportZoneRepository, SMSSender $smsSender): Response
  761.     {
  762.         /**@var User $user */
  763.         $user = $this->getUser();
  764.         $schoolYear = $user->getSchoolYear();
  765.         $establishment = $this->getUser()->getEstablishment();
  766.         
  767.         /* Ajouter un nouveau frais */
  768.         $setting_fees = $settingFeeRepository->createQueryBuilder('entity')
  769.         ->andWhere('entity.establishment = :establishment')
  770.         ->setParameter('establishment', $establishment)
  772.         ->andWhere('entity.schoolYear = :schoolYear')
  773.         ->setParameter('schoolYear', $schoolYear)
  775.         ->andWhere('entity.category != :category')
  776.         ->setParameter('category', 'SCOLARITE')
  778.         ->andWhere('entity.category != :category')
  779.         ->setParameter('category', SettingFee::TRANSPORT_FEE)
  781.         ->orderBy('entity.id', 'DESC')
  782.         ->getQuery()
  783.         ->getResult();
  785.         $accountingStudentRegistrationFee = new AccountingStudentRegistrationFee();
  786.         $accountingStudentRegistrationFeeForm = $this->createForm(AccountingStudentRegistrationFeeType::class, $accountingStudentRegistrationFee)
  787.         ->add('fee', EntityType::class,[
  788.             'class' => SettingFee::class,
  789.             'choices' => $setting_fees
  790.         ])
  791.         ->add('quantity', NumberType::class, [
  792.             'attr' => [
  793.                 'class' => 'form-control',
  794.                 'style' => 'width: 100%;'
  795.             ],
  796.             'mapped' => false,
  797.             'required' => true,
  798.             'data' => 1
  799.         ]);
  800.         $accountingStudentRegistrationFeeForm->handleRequest($request);
  802.         if ($accountingStudentRegistrationFeeForm->isSubmitted() && $accountingStudentRegistrationFeeForm->isValid()) {
  803.             $entityManager = $this->getDoctrine()->getManager();
  804.             $settingFee = $accountingStudentRegistrationFee->getFee();
  805.             if (strlen($settingFee->getDuration()) > 0 && null == $accountingStudentRegistrationFee->getStartAt()) {
  806.                 $this->addFlash('warning', "Veuillez saisir la date de debut SVP.");
  807.                 return $this->redirectToRoute('registration_student_registration_show', ['id' => $registrationStudentRegistration->getId()]);
  808.             }
  809.             /** set start date end end date */
  810.             if (null != $accountingStudentRegistrationFee->getStartAt()) {
  811.                 if ($settingFee->getDuration() == 'JOURNALIER') {
  812.                     $accountingStudentRegistrationFee->setEndAt($accountingStudentRegistrationFee->getStartAt());
  813.                     
  814.                 }
  815.                 if ($settingFee->getDuration() == 'HEBDOMADAIRE') {
  816.                     $date = $accountingStudentRegistrationFee->getStartAt();
  817.                     $njdsc = date($date->format('w') , strtotime("-7 days"));
  818.                     $njmc = date("t");
  819.                     switch ($njdsc) {
  820.                         case 0:
  821.                             $accountingStudentRegistrationFee->setEndAt($date->sub(new DateInterval("P2D")));
  822.                             break;
  823.                         case 1:
  824.                             $accountingStudentRegistrationFee->setEndAt($date->add(new DateInterval("P4D")));
  825.                             break;
  826.                         case 2:
  827.                             $accountingStudentRegistrationFee->setEndAt($date->add(new DateInterval("P3D")));
  828.                             break;
  829.                         case 3:
  830.                             $accountingStudentRegistrationFee->setEndAt($date->add(new DateInterval("P2D")));
  831.                             break;
  832.                         case 4:
  833.                             $accountingStudentRegistrationFee->setEndAt($date->add(new DateInterval("P1D")));
  834.                             break;
  835.                         case 5:
  836.                             $accountingStudentRegistrationFee->setEndAt($date->add(new DateInterval("P0D")));
  837.                             break;
  838.                         case 6:
  839.                             $accountingStudentRegistrationFee->setEndAt($date->sub(new DateInterval("P1D")));
  840.                             break;
  841.                         default:
  842.                             # code...
  843.                             break;
  844.                     }
  845.                 }
  847.                 if ($settingFee->getDuration() == 'MENSUEL-SIMPLE') {
  848.                     $date = $accountingStudentRegistrationFee->getStartAt();
  849.                     $njdsc = date($date->format('w') , strtotime("-7 days"));
  850.                     $njmc = date("t");
  851.                     $date_end = new DateTimeImmutable($date->format('Y-m-').$njmc);
  852.                     $accountingStudentRegistrationFee->setEndAt($date_end);
  853.                     if ($date_end->format('D') == 'Sun') {
  854.                         $accountingStudentRegistrationFee->setEndAt($date_end->sub(new DateInterval("P2D")));
  855.                     }
  857.                     if ($date_end->format('D') == 'Sat') {
  858.                         $accountingStudentRegistrationFee->setEndAt($date_end->sub(new DateInterval("P1D")));
  859.                     }
  860.                 }
  862.                 if ($settingFee->getDuration() == 'MENSUEL-FULL') {
  863.                     $date = $accountingStudentRegistrationFee->getStartAt();
  864.                     $njdsc = date($date->format('w') , strtotime("-7 days"));
  865.                     $njmc = date("t");
  866.                     $date_end = new DateTimeImmutable($date->format('Y-m-').$njmc);
  867.                     $accountingStudentRegistrationFee->setEndAt($date_end);
  868.                 }
  870.                 $contacts = [];
  871.                 $contacts[] = '225'.str_replace(' ', '',trim($registrationStudentRegistration->getStudent()->getNotificationPhoneNumber()));
  872.                 $message = "BIENVENUE A LA GARDERIE, VOTRE ABONNEMENT ". $settingFee->getLabel() ." DEBUTE LE ". strtoupper(DateIntervalManage::FRENCH_DAY[$accountingStudentRegistrationFee->getStartAt()->format('D')]). ' ' .$accountingStudentRegistrationFee->getStartAt()->format('d'). ' ' .strtoupper(DateIntervalManage::FRENCH_MONTH[$accountingStudentRegistrationFee->getStartAt()->format('m')]). ' '. $accountingStudentRegistrationFee->getStartAt()->format('Y') ." A 07H00 ET PRENDRA FIN LE ".  strtoupper(DateIntervalManage::FRENCH_DAY[$accountingStudentRegistrationFee->getEndAt()->format('D')]). ' ' .$accountingStudentRegistrationFee->getEndAt()->format('d'). ' ' .strtoupper(DateIntervalManage::FRENCH_MONTH[$accountingStudentRegistrationFee->getEndAt()->format('m')]). ' '. $accountingStudentRegistrationFee->getEndAt()->format('Y') ." A 18H00. Contact: ".$settingFee->getEstablishment()->getMobileNumber();
  873.                 try {
  874.                     $response = $smsSender->sendSmsByEstablishment($establishment, $message, $contacts, $smsSender::UNICODE_CHARSET);
  875.                     $responses = explode(':', $response);
  876.                     $code = trim($responses[1]);
  877.                     $communicationMessage = new CommunicationMessage();
  878.                     $communicationMessage->setCode($code);
  879.                     $communicationMessage->setContacts($contacts);
  880.                     $communicationMessage->setContent($message);
  881.                     $communicationMessage->setEstablishment($establishment);
  882.                     $communicationMessage->setType($smsSender::UNICODE_CHARSET);
  883.                     $entityManager->persist($communicationMessage);
  884.                 } catch (\Throwable $th) {
  885.                     //throw $th;
  886.                 }
  887.                 
  888.             }
  890.             /** */
  891.             $quantity = $accountingStudentRegistrationFeeForm->get('quantity')->getData() ?? 1;
  892.             $label = $quantity > 1 ? $settingFee->getLabel() . ' x ' . $quantity : $settingFee->getLabel();
  893.             $amount = $settingFee->getAmount() * $quantity;
  895.             $accountingStudentRegistrationFee->setDuration($settingFee->getDuration());
  896.             $accountingStudentRegistrationFee->setEstablishment($establishment);
  897.             $accountingStudentRegistrationFee->setCode(time());
  898.             $accountingStudentRegistrationFee->setLabel($label);
  899.             $accountingStudentRegistrationFee->setAmount($amount);
  900.             $accountingStudentRegistrationFee->setStudentRegistration($registrationStudentRegistration);
  901.             $accountingStudentRegistrationFee->setFee($settingFee);
  902.             if (count($settingFee->getSettingFeeSheduls()) > 0) {
  903.                 $order = 0;
  904.                 foreach ($settingFee->getSettingFeeSheduls() as $key => $feeShedul) {
  905.                     $accountingStudentRegistrationFeeShedul = new AccountingStudentRegistrationFeeShedul();
  906.                     $accountingStudentRegistrationFeeShedul->setAmount($feeShedul->getAmount() * $quantity);
  907.                     
  908.                     if (null != $accountingStudentRegistrationFee->getStartAt()) {
  909.                         $accountingStudentRegistrationFeeShedul->setDateDue($accountingStudentRegistrationFee->getStartAt());
  910.                     }else {
  911.                         $accountingStudentRegistrationFeeShedul->setDateDue($feeShedul->getDateDue());
  912.                     }
  914.                     $accountingStudentRegistrationFeeShedul->setOrderNum($order + 1);
  915.                     $accountingStudentRegistrationFeeShedul->setEstablishment($establishment);
  916.                     $accountingStudentRegistrationFeeShedul->setStudentRegistrationFee($accountingStudentRegistrationFee);
  917.                     $entityManager->persist($accountingStudentRegistrationFeeShedul);
  918.                     $order++;
  919.                 }
  920.             }else {
  921.                 $accountingStudentRegistrationFeeShedul = new AccountingStudentRegistrationFeeShedul();
  922.                 $accountingStudentRegistrationFeeShedul->setAmount($amount);
  923.                 if (null != $accountingStudentRegistrationFee->getStartAt()) {
  924.                     $accountingStudentRegistrationFeeShedul->setDateDue($accountingStudentRegistrationFee->getStartAt());
  925.                 }else {
  926.                     $accountingStudentRegistrationFeeShedul->setDateDue(new DateTimeImmutable());
  927.                 }
  928.                 
  929.                 $accountingStudentRegistrationFeeShedul->setOrderNum(1);
  930.                 $accountingStudentRegistrationFeeShedul->setEstablishment($this->getUser()->getEstablishment());
  931.                 $accountingStudentRegistrationFeeShedul->setStudentRegistrationFee($accountingStudentRegistrationFee);
  932.                 
  933.                 $entityManager->persist($accountingStudentRegistrationFeeShedul);
  934.             }
  936.             foreach ($settingFee->getStockKitCategories() as $key => $stockKitCategory) {
  937.                 // sortie de kits
  938.                 $stockKitOut = new StockKitOut();
  939.                 $stockKitOut->setEstablishment($establishment);
  940.                 $stockKitOut->setSchoolYear($schoolYear);
  941.                 $stockKitOut->setRegistrationStudent($registrationStudentRegistration);
  942.                 $stockKitOut->setAccountingStudentRegistrationFee($accountingStudentRegistrationFee);
  943.                 $stockKitOut->setIsValidated(false);
  945.                 $stockKitOut->setKitCategory($stockKitCategory);
  946.                 $stockKitOut->setCreateDate(new DateTimeImmutable());
  947.                 // lignes de sortie de kits
  948.                 foreach ($stockKitCategory->getStockKitProducts() as $key => $stockKitProduct) {
  949.                     $stockKitOutLine = new StockKitOutLine();
  950.                     $stockKitOutLine->setEstablishment($establishment);
  951.                     $stockKitOutLine->setSchoolYear($schoolYear);
  952.                     $stockKitOutLine->setStockKitOut($stockKitOut);
  953.                     $stockKitOutLine->setStockKitProduct($stockKitProduct);
  954.                     $stockKitOutLine->setProduct($stockKitProduct->getProduct());
  955.                     $stockKitOutLine->setQuantity($quantity);
  956.                     $entityManager->persist($stockKitOutLine);
  957.                 }
  959.                 $entityManager->persist($stockKitOut);
  960.             }
  961.             
  962.             $entityManager->persist($accountingStudentRegistrationFee);
  963.             
  964.             try {
  965.                 $this->getDoctrine()->getManager()->flush();
  966.                 $accountingStudentRegistrationFee->setCode('ABN-'.sprintf("%'05s", $accountingStudentRegistrationFee->getId()));
  967.                 $this->getDoctrine()->getManager()->flush();
  968.                 $this->addFlash('success', "des frais ont été ajouté.");
  969.             } catch (\Throwable $th) {
  970.                 $this->addFlash('info', $th->getMessage());
  971.             }
  973.             return $this->redirectToRoute('registration_student_registration_show', ['id' => $registrationStudentRegistration->getId()]);
  974.         }
  976.         $transport_zones = $transportZoneRepository->createQueryBuilder('entity')
  977.         ->innerJoin('entity.establishment', 'establishment')
  978.         ->addSelect('establishment')
  980.         ->innerJoin('establishment.establishmentGroup', 'establishmentGroup')
  981.         ->addSelect('establishmentGroup')
  983.         ->andWhere('establishmentGroup.id = :establishmentGroupId')
  984.         ->setParameter('establishmentGroupId', $establishment->getEstablishmentGroup()->getId())
  986.         ->orderBy('entity.id', 'DESC')
  987.         ->getQuery()
  988.         ->getResult();
  990.         $registrationTransportCheckpoint = new RegistrationTransportCheckpoint();
  991.         $registrationTransportCheckpointForm = $this->createForm(RegistrationTransportCheckpointType::class, $registrationTransportCheckpoint)
  992.         ->add('transportZone', EntityType::class, [
  993.             'class' => TransportZone::class,
  994.             'choices' => $transport_zones
  995.         ]);
  996.         $registrationTransportCheckpointForm->handleRequest($request);
  998.         if ($registrationTransportCheckpointForm->isSubmitted() && $registrationTransportCheckpointForm->isValid()) {
  999.             $entityManager = $this->getDoctrine()->getManager();
  1000.             $registrationTransportCheckpoint->setRegistrationStudentRegistration($registrationStudentRegistration);
  1001.             $registrationTransportCheckpoint->setEstablishment($registrationStudentRegistration->getEstablishment());
  1002.             $entityManager->persist($registrationTransportCheckpoint);
  1003.             
  1004.             try{
  1005.                 $entityManager->flush();
  1006.             }catch(\Throwable $th){
  1007.                 $this->addFlash('info', $th->getMessage());
  1008.             }
  1009.             return $this->redirectToRoute('registration_student_registration_show', ['id' => $registrationStudentRegistration->getId()]);
  1010.         }
  1012.         if ($request->get('__cd_token___') == 'soldeAnterieur') {
  1013.             $entityManager = $this->getDoctrine()->getManager();
  1014.             $fee = $settingFeeRepository->findOneBy(['establishment' => $registrationStudentRegistration->getEstablishment(),'schoolYear' => $schoolYear, 'label'  => 'SOLDE ANTERIEUR'], []);
  1015.             if (null == $fee) {
  1016.                 $fee = new SettingFee();
  1017.                 $fee->setEstablishment($registrationStudentRegistration->getEstablishment());
  1018.                 $fee->setCategory('AUTRE-FRAIS');
  1019.                 $fee->setLabel('SOLDE ANTERIEUR');
  1020.                 $fee->setAmount(0);
  1021.                 $fee->setSchoolYear($schoolYear);
  1022.                 $entityManager->persist($fee);
  1023.             }
  1025.             $anteriorAccountingStudentRegistrationFee = new AccountingStudentRegistrationFee();
  1026.             $anteriorAccountingStudentRegistrationFee->setEstablishment($registrationStudentRegistration->getEstablishment());
  1027.             $anteriorAccountingStudentRegistrationFee->setStudentRegistration($registrationStudentRegistration);
  1028.             $anteriorAccountingStudentRegistrationFee->setFee($fee);
  1029.             $anteriorAccountingStudentRegistrationFee->setAmount(intval($request->get('anterior_balance_amount')));
  1030.             $anteriorAccountingStudentRegistrationFee->setCode($fee->getLabel().'-'.$registrationStudentRegistration->getId());
  1031.             $anteriorAccountingStudentRegistrationFee->setLabel($fee->getLabel());
  1033.             $anteriorAccountingStudentRegistrationFeeShedul = new AccountingStudentRegistrationFeeShedul();
  1034.             $anteriorAccountingStudentRegistrationFeeShedul->setAmount($anteriorAccountingStudentRegistrationFee->getAmount());
  1035.             $anteriorAccountingStudentRegistrationFeeShedul->setDateDue(new DateTimeImmutable());
  1036.             $anteriorAccountingStudentRegistrationFeeShedul->setOrderNum(1);
  1037.             $anteriorAccountingStudentRegistrationFeeShedul->setEstablishment($registrationStudentRegistration->getEstablishment());
  1038.             $anteriorAccountingStudentRegistrationFeeShedul->setStudentRegistrationFee($anteriorAccountingStudentRegistrationFee);
  1039.             
  1040.             $entityManager->persist($anteriorAccountingStudentRegistrationFeeShedul);
  1041.             $entityManager->persist($anteriorAccountingStudentRegistrationFee);
  1042.             
  1043.             try{
  1044.                 $entityManager->flush();
  1045.             }catch(\Throwable $th){
  1046.                 $this->addFlash('info', $th->getMessage());
  1047.             }
  1048.             return $this->redirectToRoute('registration_student_registration_show', ['id' => $registrationStudentRegistration->getId()]);
  1049.         }
  1051.         return $this->renderForm('registration/registration_student_registration/show.html.twig', [
  1052.             'registration_student_registration' => $registrationStudentRegistration,
  1054.             'accounting_student_registration_fee' => $accountingStudentRegistrationFee,
  1055.             'accounting_student_registration_fee_form' => $accountingStudentRegistrationFeeForm,
  1057.             'registrationTransportCheckpoint' => $registrationTransportCheckpoint,
  1058.             'registrationTransportCheckpointForm' => $registrationTransportCheckpointForm,
  1059.         ]);
  1060.     }
  1062.     /**
  1063.      * @Route("/{id}/edit", name="registration_student_registration_edit", methods={"GET","POST"})
  1064.      */
  1065.     public function edit(Request $request, RegistrationStudentRegistration $registrationStudentRegistration, SettingDocumentToProvideRepository $settingDocumentToProvideRepository): Response
  1066.     {
  1067.         $establishment = $this->getUser()->getEstablishment();
  1068.         $form = $this->createForm(RegistrationStudentRegistrationType::class, $registrationStudentRegistration)
  1069.         ->add('documentProvides', EntityType::class, [
  1070.             'class' => SettingDocumentToProvide::class,
  1071.             'choices' => $settingDocumentToProvideRepository->findBy(['establishment' => $establishment], []),
  1072.             'multiple' => true,
  1073.             'required' => false
  1074.         ])
  1075.         ->remove('student');
  1076.         $form->handleRequest($request);
  1078.         if ($form->isSubmitted() && $form->isValid()) {
  1079.             
  1080.             try {
  1081.                 $this->getDoctrine()->getManager()->flush();
  1082.                 $this->addFlash('success', "l'inscrit à été édité.");
  1083.             } catch (\Throwable $th) {
  1084.                 $this->addFlash('warning', "Une erreure est survenue lors de l'édition de l'inscrit.");
  1085.                 $this->addFlash('info', $th->getMessage());
  1086.             }
  1088.             return $this->redirectToRoute('registration_student_registration_edit', ['id' => $registrationStudentRegistration->getId()], Response::HTTP_SEE_OTHER);
  1089.         }
  1091.         return $this->renderForm('registration/registration_student_registration/edit.html.twig', [
  1092.             'registration_student_registration' => $registrationStudentRegistration,
  1093.             'form' => $form,
  1094.         ]);
  1095.     }
  1097.     /**
  1098.      * @Route("/delete-selection", name="registration_student_registrations_selected_delete", methods={"GET"})
  1099.     */
  1100.     public function deleteSelected(Request $request, RegistrationStudentRegistrationRepository $entityRepository): Response
  1101.     {
  1102.         $list = $request->get('entities');
  1103.         $entityManager = $this->getDoctrine()->getManager();
  1104.         $errors = 0;
  1105.         foreach ($list as $key => $id) {
  1106.             $entity = $entityRepository->findOneBy(['id' => intval($id)], []);
  1107.             if ($entity != null) {
  1108.                 foreach ($entity->getStockKitOuts() as $key => $stockKitOut) {
  1109.                     if (!$stockKitOut->getIsValidated()) {
  1110.                         foreach ($stockKitOut->getStockKitOutLines() as $key => $stockKitOutLine) {
  1111.                             $entityManager->remove($stockKitOutLine);
  1112.                         }
  1113.                         $entityManager->remove($stockKitOut);
  1114.                     }
  1115.                 }
  1116.                 
  1117.                 foreach ($entity->getStockStudentKitEntries() as $key => $stockStudentKitEntry) {
  1118.                     foreach ($stockStudentKitEntry->getStockStudentKitEntryLines() as $key => $stockStudentKitEntryLine) {
  1119.                         $entityManager->remove($stockStudentKitEntryLine);
  1120.                     }
  1121.                     $entityManager->remove($stockStudentKitEntry);
  1122.                 }
  1124.                 foreach ($entity->getAccountingCredits() as $key => $accountingCredit) {
  1125.                     foreach ($accountingCredit->getAccountingCreditLines() as $key => $accountingCreditLine) {
  1126.                         $entityManager->remove($accountingCreditLine);
  1127.                     }
  1128.                     $entityManager->remove($accountingCredit);
  1129.                 }
  1131.                 if (count($entity->getAccountingStudentRegistrationFees()) <= 0) {
  1132.                     $entityManager->remove($entity);
  1133.                 }
  1134.             }
  1135.         }
  1137.         try {
  1138.             $entityManager->flush();
  1139.             $this->addFlash('success', "Traitement effectué");
  1140.             return $this->json(['code' => 200, 'message' => "Traitement effectué :)"], 200);
  1141.         } catch (\Throwable $th) {
  1142.             //$th->getMessage()
  1143.             $this->addFlash('warning', $th->getMessage());
  1144.         }
  1145.         
  1146.         $this->addFlash('warning', "Traitement non effectué");
  1147.         return $this->json(['code' => 500, 'message' => "Traitement non effectué"], 200);
  1148.     }
  1150.     /**
  1151.      * @Route("/{id}/toggle-abandon", name="registration_student_registration_abandon", methods={"GET"})
  1152.     */
  1153.     public function abandon(RegistrationStudentRegistration $registrationStudentRegistration): Response
  1154.     {
  1155.         $registrationStudentRegistration->setIsAbandonned(!$registrationStudentRegistration->getIsAbandonned());
  1156.         if ($registrationStudentRegistration->getIsAbandonned()) {
  1157.             $registrationStudentRegistration->setStatus(RegistrationStudentRegistration::STATUS_ABANDONNE);
  1158.         } else {
  1159.             $registrationStudentRegistration->setStatus(RegistrationStudentRegistration::STATUS_INSCRIT);
  1160.         }
  1162.         $message = $registrationStudentRegistration->getIsAbandonned() ? "Abandonné" : "Inscrit";
  1164.         try {
  1165.             $this->getDoctrine()->getManager()->flush();
  1166.             $this->addFlash('success', "Traitement effectué : " . $message);
  1167.             return $this->json(['code' => 200, 'message' => "Traitement effectué :) : " . $message], 200);
  1168.         } catch (\Throwable $th) {
  1169.             $this->addFlash('info', $th->getMessage());
  1170.         }
  1172.         return $this->json(['code' => 500, 'message' => "Traitement non effectué"], 200);
  1173.     }
  1175.     /**
  1176.      * @Route("/{id}/delete", name="registration_student_registration_delete", methods={"GET"})
  1177.      * @IsGranted("ROLE_SUPER_ADMIN")
  1178.     */
  1179.     public function delete(RegistrationStudentRegistration $registrationStudentRegistration): Response
  1180.     {
  1181.         if (count($registrationStudentRegistration->getAccountingStudentRegistrationFees()) > 0) {
  1182.             return $this->json(['code' => 500, 'message' => "Ce inscrit a des frais, il ne peut pas être supprimé."], 200);
  1183.         }
  1185.         if(count($registrationStudentRegistration->getAccountingStudentRegistrationPayments()) > 0) {
  1186.             return $this->json(['code' => 500, 'message' => "Ce inscrit a des paiements, il ne peut pas être supprimé."], 200);
  1187.         }
  1189.         foreach ($registrationStudentRegistration->getStockKitOuts() as $key => $stockKitOut) {
  1190.             if (!$stockKitOut->getIsValidated()) {
  1191.                 foreach ($stockKitOut->getStockKitOutLines() as $key => $stockKitOutLine) {
  1192.                     $this->getDoctrine()->getManager()->remove($stockKitOutLine);
  1193.                 }
  1194.             }
  1195.         }
  1197.         foreach ($registrationStudentRegistration->getStockStudentKitEntries() as $key => $stockStudentKitEntry) {
  1198.             foreach ($stockStudentKitEntry->getStockStudentKitEntryLines() as $key => $stockStudentKitEntryLine) {
  1199.                 $this->getDoctrine()->getManager()->remove($stockStudentKitEntryLine);
  1200.             }
  1201.             $this->getDoctrine()->getManager()->remove($stockStudentKitEntry);
  1202.         }
  1204.         foreach ($registrationStudentRegistration->getRegistrationTransportCheckpoints() as $key => $registrationTransportCheckpoint) {
  1205.             $this->getDoctrine()->getManager()->remove($registrationTransportCheckpoint);
  1206.         }
  1208.         foreach ($registrationStudentRegistration->getRegistrationStudentDowngrades() as $key => $registrationStudentDowngrade) {
  1209.             $this->getDoctrine()->getManager()->remove($registrationStudentDowngrade);
  1210.         }
  1212.         foreach ($registrationStudentRegistration->getRegistrationStudentAbandonments() as $key => $registrationStudentAbandonment) {
  1213.             $this->getDoctrine()->getManager()->remove($registrationStudentAbandonment);
  1214.         }
  1216.         foreach ($registrationStudentRegistration->getRegistrationStudentContacts() as $key => $registrationStudentContact) {
  1217.             $this->getDoctrine()->getManager()->remove($registrationStudentContact);
  1218.         }
  1221.         try {
  1222.             $this->getDoctrine()->getManager()->remove($registrationStudentRegistration);
  1223.             $this->getDoctrine()->getManager()->flush();
  1224.         } catch (\Throwable $th) {
  1225.             return $this->json(['code' => 500, 'message' => $th->getMessage()], 200);
  1226.         }
  1228.         return $this->json(['code' => 200, 'message' => "Traitement effectué :)"], 200);
  1229.     }
  1231.     /**
  1232.      * @Route("/api/get-info", name="api_registration_student_registration_info", methods={"GET"})
  1233.     */
  1234.     public function apiGetInfo(Request $request, RegistrationStudentRegistrationRepository $entityRepository, SettingClassroomRepository $settingClassroomRepository): Response
  1235.     {
  1236.         /**@var User $user */
  1237.         $user = $this->getUser();
  1238.         $establishment = $user->getEstablishment();
  1239.         $schoolYear = $user->getSchoolYear();
  1241.         $id = intval($request->get('id'));
  1242.         $student = $entityRepository->findOneBy(['id' => $id], []);
  1244.         if (null == $student) {
  1245.             return $this->json(['code' => 500, 'message' => "not found :)"], 200);
  1246.         }
  1248.         $sclassrooms = new ArrayCollection();
  1249.         $_sclassrooms = $settingClassroomRepository->findBy(['level' => $student->getClassroom()->getLevel(), 'schoolYear' => $schoolYear], ['label' => 'ASC']);
  1250.         
  1252.         $_sclassrooms =  $settingClassroomRepository->createQueryBuilder('entity')
  1253.         ->innerJoin('entity.level', 'level')
  1254.         ->addSelect('level')
  1256.         ->andWhere('entity.establishment = :establishment')
  1257.         ->setParameter('establishment', $establishment)
  1259.         ->andWhere('entity.schoolYear = :schoolYear')
  1260.         ->setParameter('schoolYear', $schoolYear)
  1262.         ->andWhere('level.parent = :parent')
  1263.         ->setParameter('parent', $student->getClassroom()->getLevel()->getParent())
  1265.         ->getQuery()
  1266.         ->getResult();
  1268.         $__sclassrooms =  $settingClassroomRepository->createQueryBuilder('entity')
  1269.         ->innerJoin('entity.level', 'level')
  1270.         ->addSelect('level')
  1272.         ->andWhere('entity.establishment = :establishment')
  1273.         ->setParameter('establishment', $establishment)
  1275.         ->andWhere('entity.schoolYear = :schoolYear')
  1276.         ->setParameter('schoolYear', $schoolYear)
  1278.         ->andWhere('entity.level = :level')
  1279.         ->setParameter('level', $student->getClassroom()->getLevel())
  1281.         ->getQuery()
  1282.         ->getResult();
  1284.         foreach ($_sclassrooms as $key => $_sclassroom) {
  1285.             if ($student->getClassroom() != $_sclassroom) {
  1286.                 $sclassrooms->add([
  1287.                     'id' => $_sclassroom->getId(),
  1288.                     'label' => $_sclassroom->getLabel()
  1289.                 ]);
  1290.             }
  1291.         };
  1293.         foreach ($__sclassrooms as $key => $_sclassroom) {
  1294.             if ($student->getClassroom() != $_sclassroom) {
  1295.                 if ($student->getClassroom()->getLevel()->getParent() == null) {
  1296.                     $sclassrooms->add([
  1297.                         'id' => $_sclassroom->getId(),
  1298.                         'label' => $_sclassroom->getLabel()
  1299.                     ]);
  1300.                 }
  1301.             }
  1302.         };
  1304.         if ($student != null) {
  1305.             return $this->json([
  1306.                 'code' => 200, 
  1307.                 'message' => "found :)", 
  1308.                 'sname' => $student->getName(), 
  1309.                 'sregistrationNumber' => $student->getStudent()->getRegistrationNumber(), 
  1310.                 'scode' => $student->getStudent()->getCode(), 
  1311.                 'sclassroom' => $student->getClassroom()->getLabel(), 
  1312.                 'sclassrooms' => $sclassrooms, 
  1313.                 'slevel' => $student->getClassroom()->getLevel()->getId(), 
  1314.                 'sestablishment' => $student->getEstablishment()->getName(), 
  1315.                 'ssolde' => number_format($student->getAmountRest(), 0, ',', ' '),
  1316.                 'is_affected' => $student->getStudent()->getIsAffected(), 
  1317.                 'is_redoubling' => $student->getStudent()->getIsRedoubling(), 
  1318.             ], 
  1319.             200);
  1320.         }else{
  1321.             return $this->json(['code' => 500, 'message' => "not found :)"], 200);
  1322.         }
  1323.     }
  1325.     /**
  1326.      * @Route("/print/{id}/card", name="registration_student_registration_print_card", methods={"GET"})
  1327.     */
  1328.     public function printCard(Pdf $knpSnappyPdf, RegistrationStudentRegistration $registrationStudent)
  1329.     {
  1330.         /**@var User $user */
  1331.         $user = $this->getUser();
  1333.         $schoolYear = $user->getSchoolYear();
  1334.         $setting = $registrationStudent->getEstablishment();
  1335.         $template = 'registration/print/primaireCard.html.twig';
  1336.         if ($setting->getType() != $setting::ESTABLISHMENT_PRESCOLAIRE_PRIMAIRE_TYPES) {
  1337.             $template = 'registration/print/secondaireCard.html.twig';
  1338.         }
  1339.         
  1340.         $html = $this->renderView($template, [
  1341.             'student_registration' => $registrationStudent,
  1342.             'school_year' => $schoolYear,
  1343.             'setting' => $setting,
  1344.         ]);
  1346.         $file_name = 'CARTE_DE_SORTIE_'.$registrationStudent->getStudent()->getCode().".pdf";
  1347.         return new PdfResponse(
  1348.             $knpSnappyPdf->getOutputFromHtml($html),
  1349.             $file_name,
  1350.             'application/pdf',
  1351.             'attachment'
  1352.         );
  1353.     }
  1355.     /**
  1356.      * @Route("/print/{id}/badge", name="registration_student_registration_print_badge", methods={"GET"})
  1357.     */
  1358.     public function printBadge(Pdf $knpSnappyPdf, RegistrationStudentRegistration $registrationStudent)
  1359.     {
  1360.         /**@var User $user */
  1361.         $user = $this->getUser();
  1363.         $schoolYear = $user->getSchoolYear();
  1364.         $setting = $registrationStudent->getEstablishment();
  1366.         $template = 'registration/print/primaireBadge.html.twig';
  1367.         if ($setting->getType() != $setting::ESTABLISHMENT_PRESCOLAIRE_PRIMAIRE_TYPES) {
  1368.             $template = 'registration/print/secondaireBadge.html.twig';
  1369.         }
  1370.         
  1371.         $html = $this->renderView($template, [
  1372.             'student_registration' => $registrationStudent,
  1373.             'school_year' => $schoolYear,
  1374.             'setting' => $setting,
  1375.         ]);
  1377.         $file_name = 'BADGE_'.$registrationStudent->getStudent()->getCode().".pdf";
  1378.         return new PdfResponse(
  1379.             $knpSnappyPdf->getOutputFromHtml($html, [
  1380.                 'margin-left' => '0',
  1381.                 'margin-top' => '0',
  1382.                 'margin-right' => '0',
  1383.                 'margin-bottom' => '0',
  1384.                 'page-height' =>  35,
  1385.                 'page-width' => 53
  1386.             ]),
  1387.             $file_name,
  1388.             'application/pdf',
  1389.             'attachment'
  1390.         );
  1391.     }
  1393.     /**
  1394.      * @Route("/print/{id}/badgeVerso", name="registration_student_registration_print_badge_verso", methods={"GET"})
  1395.     */
  1396.     public function printBadgeVerso(Pdf $knpSnappyPdf, RegistrationStudentRegistration $registrationStudent)
  1397.     {
  1398.         /**@var User $user */
  1399.         $user = $this->getUser();
  1401.         $schoolYear = $user->getSchoolYear();
  1402.         $setting = $registrationStudent->getEstablishment();
  1404.         $template = 'registration/print/primaireBadgeVerso.html.twig';
  1405.         if ($setting->getType() != $setting::ESTABLISHMENT_PRESCOLAIRE_PRIMAIRE_TYPES) {
  1406.             $template = 'registration/print/secondaireBadgeVerso.html.twig';
  1407.         }
  1408.         
  1409.         $html = $this->renderView($template, [
  1410.             'student_registration' => $registrationStudent,
  1411.             'school_year' => $schoolYear,
  1412.             'setting' => $setting,
  1413.         ]);
  1415.         $file_name = 'BADGE_VERSO'.$registrationStudent->getStudent()->getCode().".pdf";
  1416.         return new PdfResponse(
  1417.             $knpSnappyPdf->getOutputFromHtml($html, [
  1418.                 'margin-left' => '0',
  1419.                 'margin-top' => '0',
  1420.                 'margin-right' => '0',
  1421.                 'margin-bottom' => '0',
  1422.                 'page-height' =>  35,
  1423.                 'page-width' => 53
  1424.             ]),
  1425.             $file_name,
  1426.             'application/pdf',
  1427.             'attachment'
  1428.         );
  1429.     }
  1431.     /**
  1432.      * @Route("/print/{id}/attestationOfAttendance", name="registration_student_registration_print_attestation_of_attendance", methods={"GET"})
  1433.     */
  1434.     public function printAttestationOfAttendance(Pdf $knpSnappyPdf, RegistrationStudentRegistration $registrationStudent)
  1435.     {
  1436.         /**@var User $user */
  1437.         $user = $this->getUser();
  1439.         $schoolYear = $user->getSchoolYear();
  1440.         $setting = $registrationStudent->getEstablishment();
  1441.         $template = 'registration/print/attestation_of_attendance.html.twig';
  1443.         $html = $this->renderView($template, [
  1444.             'student_registration' => $registrationStudent,
  1445.             'school_year' => $schoolYear,
  1446.             'setting' => $setting,
  1447.         ]);
  1449.         $file_name = 'ATTESTATION_DE_FREQUENTATION_'.$registrationStudent->getStudent()->getCode().".pdf";
  1450.         $footer = $this->renderView('print/footer.html.twig', ['setting' => $setting,]);
  1451.         $header = $this->renderView('print/header.html.twig', ['setting' => $setting,]);
  1452.         $options = [
  1453.             'orientation' => 'Portrait'
  1454.             //'header-html' => $header
  1455.             //'footer-html' => $footer
  1456.         ];
  1458.         try {
  1459.             $knpSnappyPdf->generateFromHtml($html, $this->getParameter('app.app_directory').'/downloads/students/' . $file_name, $options, true);
  1460.         } catch (\Throwable $th) {
  1461.             $this->addFlash('info', "Ce reçu à déjà été imprimé.");
  1462.         }
  1463.         
  1465.         return $this->redirectToRoute('preview', [
  1466.             'file' => $file_name,
  1467.             'dir' => 'students',
  1468.         ]);
  1469.     }
  1471.     /**
  1472.      * @Route("/print/{id}/transpotantionSheet", name="registration_student_registration_print_transpotantion_sheet", methods={"GET"})
  1473.     */
  1474.     public function printTranspotantionSheet(Pdf $knpSnappyPdf, RegistrationStudentRegistration $registrationStudent)
  1475.     {
  1476.         /**@var User $user */
  1477.         $user = $this->getUser();
  1479.         $schoolYear = $user->getSchoolYear();
  1480.         $setting = $registrationStudent->getEstablishment();
  1481.         $template = 'registration/print/transpotantion_sheet.html.twig';
  1483.         $html = $this->renderView($template, [
  1484.             'student_registration' => $registrationStudent,
  1485.             'school_year' => $schoolYear,
  1486.             'setting' => $setting,
  1487.         ]);
  1489.         $file_name = 'FICHE_DE_TRANSPORT_'.$registrationStudent->getStudent()->getCode().".pdf";
  1490.         $footer = $this->renderView('print/footer.html.twig', ['setting' => $setting,]);
  1491.         $header = $this->renderView('print/header.html.twig', ['setting' => $setting,]);
  1492.         $options = [
  1493.             'orientation' => 'Portrait',
  1494.             'header-html' => $header
  1495.             //'footer-html' => $footer
  1496.         ];
  1498.         try {
  1499.             $knpSnappyPdf->generateFromHtml($html, $this->getParameter('app.app_directory').'/downloads/students/' . $file_name, $options, true);
  1500.         } catch (\Throwable $th) {
  1501.             $this->addFlash('info', $th->getMessage());
  1502.         }
  1503.         
  1505.         return $this->redirectToRoute('preview', [
  1506.             'file' => $file_name,
  1507.             'dir' => 'students',
  1508.         ]);
  1509.     }
  1511.     /**
  1512.      * @Route("/print/{id}/acknowledgmentReceip", name="registration_student_registration_print_acknowledgment_receip", methods={"GET"})
  1513.     */
  1514.     public function acknowledgment_receip(Pdf $knpSnappyPdf, RegistrationStudentRegistration $registrationStudent)
  1515.     {
  1516.         /**@var User $user */
  1517.         $user = $this->getUser();
  1519.         $schoolYear = $user->getSchoolYear();
  1520.         $setting = $registrationStudent->getEstablishment();
  1521.         $template = 'registration/print/acknowledgment_receip.html.twig';
  1522.         
  1523.         $html = $this->renderView($template, [
  1524.             'student_registration' => $registrationStudent,
  1525.             'school_year' => $schoolYear,
  1526.             'setting' => $setting,
  1527.         ]);
  1529.         $file_name = 'ACCUSE_DE_RECEPTION_'.$registrationStudent->getId().".pdf";
  1530.         $footer = $this->renderView('print/footer.html.twig', ['setting' => $setting,]);
  1531.         $header = $this->renderView('print/header.html.twig', ['setting' => $setting,]);
  1532.         $options = [
  1533.             'orientation' => 'Portrait',
  1534.             'header-html' => $header
  1535.             //'footer-html' => $footer
  1536.         ];
  1538.         try {
  1539.             $knpSnappyPdf->generateFromHtml($html, $this->getParameter('app.app_directory').'/downloads/students/' . $file_name, $options, true);
  1540.         } catch (\Throwable $th) {
  1541.             $this->addFlash('info', $th->getMessage());
  1542.         }
  1543.         
  1545.         return $this->redirectToRoute('preview', [
  1546.             'file' => $file_name,
  1547.             'dir' => 'students',
  1548.         ]);
  1549.     }
  1551.     /**
  1552.      * @Route("/api/get-kit-model", name="api_registration_student_registration_get_kit_models", methods={"GET"})
  1553.     */
  1554.     public function apiGetKitModel(Request $request, RegistrationStudentRegistrationRepository $entityRepository): Response
  1555.     {
  1556.         /**@var User $user */
  1557.         $user = $this->getUser();
  1558.         $schoolYear = $user->getSchoolYear();
  1559.         $establishment = $this->getUser()->getEstablishment();
  1561.         $id = intval($request->get('id'));
  1562.         $student = $entityRepository->find($id);
  1563.         $kitCategories = new ArrayCollection();
  1564.         $level = $student->getClassroom()->getLevel();
  1565.         foreach ($level->getSettingFees() as $key => $settingFee) {
  1566.             foreach ($settingFee->getStockKitCategories() as $key => $stockKitCategorie) {
  1567.                 if($stockKitCategorie->getEstablishment() == $establishment && $stockKitCategorie->getSchoolYear() == $schoolYear){
  1568.                     $kitCategories->add([
  1569.                         'id' => $stockKitCategorie->getId(),
  1570.                         'name' => $stockKitCategorie->getName()
  1571.                     ]);
  1572.                 }
  1573.             };
  1574.         };
  1575.         if ($student != null) {
  1576.             return $this->json([
  1577.                 'code' => 200, 
  1578.                 'message' => "found :)", 
  1579.                 'sname' => $student->getName(), 
  1580.                 'sregistrationNumber' => $student->getStudent()->getRegistrationNumber(), 
  1581.                 'scode' => $student->getStudent()->getCode(), 
  1582.                 'sclassroom' => $student->getClassroom()->getLabel(), 
  1583.                 'slevel' => $student->getClassroom()->getLevel()->getId(), 
  1584.                 'sestablishment' => $student->getEstablishment()->getName(), 
  1585.                 'ssolde' => number_format(($student->getGleAmount() - $student->getAmountPaid()), 0, ',', ' '),
  1586.                 'kit_categories' => $kitCategories, 
  1587.             ], 
  1588.             200);
  1589.         }else{
  1590.             return $this->json(['code' => 500, 'message' => "not found :)"], 200);
  1591.         }
  1592.     }
  1594.     /**
  1595.      * @Route("/{id}/print", name="registration_student_registration_print", methods={"GET"})
  1596.     */
  1597.     public function print(Pdf $knpSnappyPdf, RegistrationStudentRegistration $registrationStudentRegistration, DocManagerRepository $docManagerRepository)
  1598.     {
  1599.         /**@var User $user */
  1600.         $user = $this->getUser();
  1602.         $schoolYear = $user->getSchoolYear();
  1603.         $setting = $registrationStudentRegistration->getEstablishment();
  1605.         $template = 'registration/print/rePrimaire.html.twig';
  1607.         if ($setting->getType() != $setting::ESTABLISHMENT_PRESCOLAIRE_PRIMAIRE_TYPES) {
  1608.             $template = 'registration/print/reSecondaire.html.twig';
  1609.         }
  1610.         
  1611.         $html = $this->renderView($template, [
  1612.             'doc_manager' => $docManagerRepository->findOneBy(['establishment' => $setting, 'code' => 'REGLEMENT-INTERIEUR'], []),
  1613.             'registration_student_registration' => $registrationStudentRegistration,
  1614.             'registration_student_pre_registration' => $registrationStudentRegistration->getRegistrationStudentPreRegistration(),
  1615.             'school_year' => $schoolYear,
  1616.             'setting' => $setting,
  1617.         ]);
  1619.         $file_name = 'INSCRIPTION_N_'.$schoolYear->getCode().'--'.$registrationStudentRegistration->getStudent()->getCode().".pdf";
  1620.         return new PdfResponse(
  1621.             $knpSnappyPdf->getOutputFromHtml($html),
  1622.             $file_name,
  1623.             'application/pdf',
  1624.             'attachment'
  1625.         );
  1626.     }
  1628.     /**
  1629.      * @Route("/print/{id}/access-card", name="registration_student_registration_print_access_card", methods={"GET"})
  1630.     */
  1631.     public function printAccessCard(Pdf $knpSnappyPdf, RegistrationStudentRegistration $registrationStudent)
  1632.     {
  1633.         /**@var User $user */
  1634.         $user = $this->getUser();
  1636.         $schoolYear = $user->getSchoolYear();
  1637.         $setting = $registrationStudent->getEstablishment();
  1639.         // Vérifier si l'élève a une photo
  1640.         $studentImage = $registrationStudent->getStudent()->getImage();
  1641.         $registrationImage = $registrationStudent->getImage();
  1642.         
  1643.         if (empty($studentImage) && empty($registrationImage)) {
  1644.             $this->addFlash('warning', 'Attention : Cet élève n\'a pas de photo dans la base de données. La carte d\'accès sera générée sans photo.');
  1645.         } elseif (empty($studentImage) && !empty($registrationImage)) {
  1646.             $this->addFlash('info', 'Information : La photo de l\'inscription sera utilisée. Pensez à synchroniser les photos si nécessaire.');
  1647.         }
  1649.         $template = 'registration/print/accessCard2.html.twig';
  1650.         if ($setting->getType() != $setting::ESTABLISHMENT_PRESCOLAIRE_PRIMAIRE_TYPES) {
  1651.             $template = 'registration/print/accessCard2.html.twig';
  1652.         }
  1653.         
  1654.         $html = $this->renderView($template, [
  1655.             'student_registration' => $registrationStudent,
  1656.             'school_year' => $schoolYear,
  1657.             'setting' => $setting,
  1658.         ]);
  1660.         $options = [
  1661.             'margin-left' => '0',
  1662.             'margin-top' => '0',
  1663.             'margin-right' => '0',
  1664.             'margin-bottom' => '0',
  1665.             'page-height' =>  37,
  1666.             'page-width' => 55
  1667.         ];
  1668.         $file_name = 'CARTE_DACCES_'.$registrationStudent->getStudent()->getCode().".pdf";
  1669.         try {
  1670.             $knpSnappyPdf->generateFromHtml($html, $this->getParameter('app.app_directory').'/downloads/students/' . $file_name, $options, true);
  1671.         } catch (\Throwable $th) {
  1672.             $this->addFlash('info', $th->getMessage());
  1673.         }
  1675.         return $this->redirectToRoute('preview', [
  1676.             'file' => $file_name,
  1677.             'dir' => 'students',
  1678.         ]);
  1679.     }
  1681.     /**
  1682.      * @Route("/print/{id}/qr-card", name="registration_student_registration_print_qr_card", methods={"GET"})
  1683.      */
  1684.     public function printQrCard(
  1685.         RegistrationStudentRegistration $registrationStudent,
  1686.         EntityManagerInterface $em
  1687.     ): Response {
  1688.         /** @var \App\Entity\User $user */
  1689.         $user = $this->getUser();
  1691.         if ($registrationStudent->getEstablishment() !== $user->getEstablishment()) {
  1692.             throw $this->createAccessDeniedException();
  1693.         }
  1695.         // Génère le QR code s'il n'existe pas encore
  1696.         if (!$registrationStudent->getQrCode()) {
  1697.             $registrationStudent->generateQrCode();
  1698.             $em->flush();
  1699.         }
  1701.         return $this->render('registration/registration_student_registration/print_qr_card.html.twig', [
  1702.             'registration' => $registrationStudent,
  1703.         ]);
  1704.     }
  1706.     /**
  1707.      * @Route("/export", name="registration_student_registration_export")
  1708.     */
  1709.     public function export(RegistrationStudentRegistrationRepository $registrationStudentRegistrationRepository): Response
  1710.     {
  1711.         /**@var User $user */
  1712.         $user = $this->getUser();
  1714.         $schoolYear = $user->getSchoolYear();
  1715.         $students = new ArrayCollection();
  1717.         $establishment = $this->getUser()->getEstablishment();
  1718.         $registration_student_registrations = $registrationStudentRegistrationRepository->createQueryBuilder('entity')
  1720.             ->innerJoin('entity.student', 'student')
  1721.             ->addSelect('student')
  1723.             ->andWhere('entity.is_abandonned = :is_abandonned')
  1724.             ->setParameter('is_abandonned', 0)
  1726.             ->andWhere('entity.establishment = :establishment')
  1727.             ->setParameter('establishment', $establishment)
  1729.             ->andWhere('entity.schoolYear = :schoolYear')
  1730.             ->setParameter('schoolYear', $schoolYear)
  1732.             ->orderBy('student.last_name', 'asc')
  1733.             ->getQuery()
  1734.             ->getResult();
  1735.         
  1736.         foreach ($registration_student_registrations as $key => $registration_student_registration) {
  1737.             $students->add(
  1738.                 [
  1739.                     'registrationNumber' => $registration_student_registration->getStudent()->getRegistrationNumber(),
  1740.                     'code' => $registration_student_registration->getStudent()->getCode(),
  1741.                     'name' => $registration_student_registration->getStudent()->getName(),
  1742.                     'lastName' => $registration_student_registration->getStudent()->getLastName(),
  1743.                     'firstName' => $registration_student_registration->getStudent()->getFirstName(),
  1744.                     'birthDay' => $registration_student_registration->getStudent()->getBirthDay()->format('d/m/Y'),
  1745.                     'birthLocation' => $registration_student_registration->getStudent()->getBirthLocation(),
  1746.                     'statut' => $registration_student_registration->getStudent()->getIsAffected() ? "Affecté(e)" : "Non Affecté(e)",
  1747.                     'notificationPhoneNumber' => $registration_student_registration->getStudent()->getNotificationPhoneNumber(),
  1748.                     'doubling' => $registration_student_registration->getIsRedoubling() ? "Doublant(e)" : "Non Doublant(e)",
  1749.                     'nationality' => $registration_student_registration->getStudent()->getNationality(),
  1750.                     'classroom' => $registration_student_registration->getClassroom()->getLabel(),
  1751.                     'level' => $registration_student_registration->getClassroom()->getLevel()->getLabel(),
  1752.                     'gender' => $registration_student_registration->getStudent()->getGender(),
  1753.                     'round' => $registration_student_registration->getClassroom()->getRound() ?  $registration_student_registration->getClassroom()->getRound()->getLabel() : '',
  1754.                     'lv1' => $registration_student_registration->getStudent()->getLv1(),
  1755.                     'lv2' => $registration_student_registration->getStudent()->getLv2(),
  1756.                     'createDate' => $registration_student_registration->getRegisteredAt() ? $registration_student_registration->getRegisteredAt()->format('d/m/Y') : '',
  1757.                 ]
  1758.             );
  1759.             
  1760.         }
  1761.         
  1762.         $iterator = $students->getIterator();
  1763.         $array = iterator_to_array($iterator);
  1764.         uasort($array, function ($first, $second) {
  1765.             if ($first === $second) {
  1766.                 return 0;
  1767.             }
  1769.             return $first['name'] < $second['name'] ? -1 : 1;
  1770.         });
  1771.         $students = new ArrayCollection($array);
  1773.         $spreadsheet = new Spreadsheet();
  1774.         $sheet = $spreadsheet->getActiveSheet();
  1775.         $index = 1;
  1776.         $sheet->setCellValue('A' . $index, 'MATRICULE NATIONAL');
  1777.         $sheet->setCellValue('B' . $index, 'NOM');
  1778.         $sheet->setCellValue('C' . $index, 'PRENOMS');
  1779.         $sheet->setCellValue('D' . $index, 'DATE DE NAISSANCE');
  1780.         $sheet->setCellValue('E' . $index, 'LIEU DE NAISSANCE');
  1781.         $sheet->setCellValue('F' . $index, 'STATUT');
  1782.         $sheet->setCellValue('G' . $index, 'CONTACT PARENT');
  1783.         $sheet->setCellValue('H' . $index, 'DOUBLANT');
  1784.         $sheet->setCellValue('I' . $index, 'NATIONALITE');
  1785.         $sheet->setCellValue('J' . $index, 'CLASSE');
  1786.         $sheet->setCellValue('K' . $index, 'NIVEAU');
  1787.         $sheet->setCellValue('L' . $index, 'SEX');
  1788.         $sheet->setCellValue('M' . $index, 'SERIE');
  1789.         $sheet->setCellValue('N' . $index, 'LV1');
  1790.         $sheet->setCellValue('O' . $index, 'LV2');
  1791.         $sheet->setCellValue('P' . $index, 'MATRICULE INTERNE');
  1792.         $sheet->setCellValue('Q' . $index, 'Date Inscription');
  1793.         $index++;
  1794.         $loopIndex = 1;
  1795.         foreach ($students as $key => $student) {
  1796.             $sheet->setCellValue('A' . $index, $student['registrationNumber']);
  1797.             $sheet->setCellValue('B' . $index, $student['lastName']);
  1798.             $sheet->setCellValue('C' . $index, $student['firstName']);
  1799.             $sheet->setCellValue('D' . $index, $student['birthDay']);
  1800.             $sheet->setCellValue('E' . $index, $student['birthLocation']);
  1801.             $sheet->setCellValue('F' . $index, $student['statut']);
  1802.             $sheet->setCellValue('G' . $index, $student['notificationPhoneNumber']);
  1803.             $sheet->setCellValue('H' . $index, $student['doubling']);
  1804.             $sheet->setCellValue('I' . $index, $student['nationality']);
  1805.             $sheet->setCellValue('J' . $index, $student['classroom']);
  1806.             $sheet->setCellValue('K' . $index, $student['level']);
  1807.             $sheet->setCellValue('L' . $index, $student['gender']);
  1808.             $sheet->setCellValue('M' . $index, $student['round']);
  1809.             $sheet->setCellValue('N' . $index, $student['lv1']);
  1810.             $sheet->setCellValue('O' . $index, $student['lv2']);
  1811.             $sheet->setCellValue('P' . $index, $student['code']);
  1812.             $sheet->setCellValue('Q' . $index, $student['createDate']);
  1813.             $index++;
  1814.             $loopIndex++;
  1815.         }
  1817.         $sheet->setTitle('INSCRITS_' . $establishment->getCode().'_'.$schoolYear->getCode());
  1818.         $writer = new Xlsx($spreadsheet);
  1819.         // Create a Temporary file in the system
  1820.         $fileName = 'LISTE_INSCRITS_' . $establishment->getName().'_'.date('Y').'.xlsx';
  1821.         $temp_file = tempnam(sys_get_temp_dir(), $fileName);
  1822.         $writer->save($temp_file);
  1824.         // Return the excel file as an attachment
  1825.         return $this->file($temp_file, $fileName, ResponseHeaderBag::DISPOSITION_INLINE);
  1826.     }
  1828.     /**
  1829.      * @Route("/print/{id}/extract-school-record-book", name="registration_student_registration_print_extract_school_record_book", methods={"GET"})
  1830.     */
  1831.     public function extract_school_record_book(Pdf $knpSnappyPdf, RegistrationStudentRegistration $registrationStudent, SchoolReportCardRepository $schoolReportCardRepository, EquivalentMatterRepository $equivalentMatterRepository)
  1832.     {
  1833.         /**@var User $user */
  1834.         $user = $this->getUser();
  1835.         $schoolYear = $user->getSchoolYear();
  1836.         $setting = $registrationStudent->getEstablishment();
  1838.         $school_report_cards = $schoolReportCardRepository->createQueryBuilder('entity')
  1839.         ->innerJoin('entity.schoolYearPeriode', 'schoolYearPeriode')
  1840.         ->addSelect('schoolYearPeriode')
  1842.         ->andWhere('entity.studentRegistration = :studentRegistration')
  1843.         ->setParameter('studentRegistration', $registrationStudent)
  1845.         ->orderBy('schoolYearPeriode.code', 'ASC')
  1846.         ->getQuery()
  1847.         ->getResult();
  1849.         $equivalent_matters = $equivalentMatterRepository->createQueryBuilder('entity')
  1851.         ->orderBy('entity.num_order', 'ASC')
  1852.         ->getQuery()
  1853.         ->getResult();
  1855.         $template = 'registration/print/extract_school_record_book.html.twig';
  1856.         
  1857.         $html = $this->renderView($template, [
  1858.             'equivalent_matters' => $equivalent_matters,
  1859.             'school_report_cards' => $school_report_cards,
  1860.             'student_registration' => $registrationStudent,
  1861.             'school_year' => $schoolYear,
  1862.             'setting' => $setting,
  1863.         ]);
  1865.         $file_name = 'EXTRAIT_DE_LIVRET_SCOLAIRE_'.$registrationStudent->getId().".pdf";
  1866.         $footer = $this->renderView('print/footer.html.twig', ['setting' => $setting]);
  1867.         $header = $this->renderView('print/header.html.twig', ['setting' => $setting]);
  1868.         $options = [
  1869.             'orientation' => 'Landscape',
  1870.             'header-html' => $header
  1871.             //'footer-html' => $footer
  1872.         ];
  1874.         try {
  1875.             $knpSnappyPdf->generateFromHtml($html, $this->getParameter('app.app_directory').'/downloads/students/' . $file_name, $options, true);
  1876.         } catch (\Throwable $th) {
  1877.             $this->addFlash('info', $th->getMessage());
  1878.         }
  1879.         
  1881.         return $this->redirectToRoute('preview', [
  1882.             'file' => $file_name,
  1883.             'dir' => 'students',
  1884.         ]);
  1885.     }
  1887.     /**
  1888.      * @Route("/_statistics-table", name="registration_student_registration_statistics_table", methods={"GET","POST"})
  1889.      */
  1890.     public function _statistics_table(RegistrationStudentRegistrationRepository $registrationStudentRegistrationRepository): Response
  1891.     {
  1892.         /**@var User $user */
  1893.         $user = $this->getUser();
  1894.         $establishment = $user->getEstablishment();
  1895.         $schoolYear = $user->getSchoolYear();
  1897.         $registration_student_registrations = $registrationStudentRegistrationRepository->createQueryBuilder('entity')
  1899.         ->innerJoin('entity.student', 'student')
  1900.         ->addSelect('student')
  1902.         ->andWhere('entity.establishment = :establishment')
  1903.         ->setParameter('establishment', $establishment)
  1904.         
  1905.         ->andWhere('entity.schoolYear = :schoolYear')
  1906.         ->setParameter('schoolYear', $schoolYear)
  1908.         ->getQuery()
  1909.         ->getResult();
  1911.         $registration_student_registration_women = $registrationStudentRegistrationRepository->createQueryBuilder('entity')
  1913.         ->innerJoin('entity.student', 'student')
  1914.         ->addSelect('student')
  1916.         ->andWhere('entity.establishment = :establishment')
  1917.         ->setParameter('establishment', $establishment)
  1918.         
  1919.         ->andWhere('entity.schoolYear = :schoolYear')
  1920.         ->setParameter('schoolYear', $schoolYear)
  1922.         ->andWhere('student.gender = :gender')
  1923.         ->setParameter('gender', 'FEMININ')
  1925.         ->getQuery()
  1926.         ->getResult();
  1928.         $registration_student_registration_men = $registrationStudentRegistrationRepository->createQueryBuilder('entity')
  1930.         ->innerJoin('entity.student', 'student')
  1931.         ->addSelect('student')
  1933.         ->andWhere('entity.establishment = :establishment')
  1934.         ->setParameter('establishment', $establishment)
  1935.         
  1936.         ->andWhere('entity.schoolYear = :schoolYear')
  1937.         ->setParameter('schoolYear', $schoolYear)
  1939.         ->andWhere('student.gender = :gender')
  1940.         ->setParameter('gender', 'MASCULIN')
  1942.         ->getQuery()
  1943.         ->getResult();
  1945.         $registration_student_registration_affecteds = $registrationStudentRegistrationRepository->createQueryBuilder('entity')
  1947.         ->innerJoin('entity.student', 'student')
  1948.         ->addSelect('student')
  1950.         ->andWhere('entity.establishment = :establishment')
  1951.         ->setParameter('establishment', $establishment)
  1952.         
  1953.         ->andWhere('entity.schoolYear = :schoolYear')
  1954.         ->setParameter('schoolYear', $schoolYear)
  1956.         ->andWhere('student.is_affected = :is_affected')
  1957.         ->setParameter('is_affected', 1)
  1959.         ->getQuery()
  1960.         ->getResult();
  1962.         return $this->renderForm('registration/registration_student_registration/_statistics_table.html.twig', [
  1963.             'registration_student_registrations' => count($registration_student_registrations),
  1964.             'registration_student_registration_women' => count($registration_student_registration_women),
  1965.             'registration_student_registration_men' => count($registration_student_registration_men),
  1966.             'registration_student_registration_affecteds' => count($registration_student_registration_affecteds),
  1967.         ]);
  1968.     }
  1970.     /**
  1971.      * @Route("/_registration_select", name="api_registration_student_registration_select", methods={"GET","POST"})
  1972.      */
  1973.     public function api_select(Request $request, RegistrationStudentRegistrationRepository $registrationStudentRegistrationRepository){
  1975.         /**@var User $user */
  1976.         $user = $this->getUser();
  1977.         $schoolYear = $user->getSchoolYear();
  1979.         $establishment = $user->getEstablishment();
  1981.         $registrationStudentRegistrations = $registrationStudentRegistrationRepository->createQueryBuilder('entity')
  1983.         ->innerJoin('entity.student', 'student')
  1984.         ->addSelect('student')
  1986.         ->orWhere('student.code LIKE :code')
  1987.         ->setParameter('code', '%'.$request->get('q').'%')
  1989.         ->orWhere('student.registration_number LIKE :registration_number')
  1990.         ->setParameter('registration_number', '%'.$request->get('q').'%')
  1992.         ->orWhere('student.last_name LIKE :last_name')
  1993.         ->setParameter('last_name', '%'.$request->get('q').'%')
  1995.         ->orWhere('student.first_name LIKE :first_name')
  1996.         ->setParameter('first_name', '%'.$request->get('q').'%')
  1998.         ->andWhere('entity.establishment = :establishment')
  1999.         ->setParameter('establishment', $establishment)
  2001.         ->andWhere('entity.schoolYear = :schoolYear')
  2002.         ->setParameter('schoolYear', $schoolYear)
  2004.         ->andWhere('entity.is_abandonned = :is_abandonned')
  2005.         ->setParameter('is_abandonned', 0)
  2006.         
  2007.         ->setMaxResults(100)
  2008.         ->getQuery()
  2009.         ->getResult();
  2011.         $data = new ArrayCollection();
  2012.         foreach ($registrationStudentRegistrations as $key => $registrationStudentRegistration) {
  2013.             if ($registrationStudentRegistration->getAmountRest() > 0) {
  2014.                 $data->add([
  2015.                     'id' => $registrationStudentRegistration->getId(),
  2016.                     'text' => '['.$registrationStudentRegistration->getStudent()->getRegistrationNumber().'] '.$registrationStudentRegistration->getName().' ['.$registrationStudentRegistration->getClassroom()->getLabel().']'
  2017.                 ]);
  2018.             }
  2019.         }
  2021.         return $this->json($data, 200);
  2022.     }
  2024.     /**
  2025.      * @Route("/print/{id}/fees-details", name="registration_student_registration_print_fees_details", methods={"GET"})
  2026.     */
  2027.     public function print_fees_details(Pdf $knpSnappyPdf, RegistrationStudentRegistration $registrationStudent)
  2028.     {
  2029.         /**@var User $user */
  2030.         $user = $this->getUser();
  2031.         $schoolYear = $user->getSchoolYear();
  2032.         $setting = $registrationStudent->getEstablishment();
  2034.         $template = 'registration/print/frees_details.html.twig';
  2035.         
  2036.         $html = $this->renderView($template, [
  2037.             'registration_student_registration' => $registrationStudent,
  2038.             'school_year' => $schoolYear,
  2039.             'setting' => $setting,
  2040.         ]);
  2042.         $file_name = 'DETAILS_FRAIS_'.$registrationStudent->getId().".pdf";
  2043.         $footer = $this->renderView('print/footer.html.twig', ['setting' => $setting]);
  2044.         $header = $this->renderView('print/header.html.twig', ['setting' => $setting]);
  2045.         $options = [
  2046.             'orientation' => 'Portrait',
  2047.             'header-html' => $header
  2048.             //'footer-html' => $footer
  2049.         ];
  2051.         try {
  2052.             $knpSnappyPdf->generateFromHtml($html, $this->getParameter('app.app_directory').'/downloads/students/' . $file_name, $options, true);
  2053.         } catch (\Throwable $th) {
  2054.             $this->addFlash('info', $th->getMessage());
  2055.         }
  2056.         
  2058.         return $this->redirectToRoute('preview', [
  2059.             'file' => $file_name,
  2060.             'dir' => 'students',
  2061.         ]);
  2062.     }
  2064.     /**
  2065.      * @Route("/print/{id}/schedule", name="registration_student_registration_print_schedule", methods={"GET"})
  2066.      */
  2067.     public function print_schedule(Pdf $knpSnappyPdf, RegistrationStudentRegistration $registrationStudent)
  2068.     {
  2069.         /**@var User $user */
  2070.         $user = $this->getUser();
  2071.         $schoolYear = $user->getSchoolYear();
  2072.         $setting = $registrationStudent->getEstablishment();
  2074.         $template = 'registration/print/schedule.html.twig';
  2075.         
  2076.         $html = $this->renderView($template, [
  2077.             'registration_student_registration' => $registrationStudent,
  2078.             'school_year' => $schoolYear,
  2079.             'setting' => $setting,
  2080.         ]);
  2082.         $file_name = 'ECHEANCIER_'.$registrationStudent->getId().".pdf";
  2083.         $footer = $this->renderView('print/footer.html.twig', ['setting' => $setting]);
  2084.         $header = $this->renderView('print/header.html.twig', ['setting' => $setting]);
  2085.         $options = [
  2086.             'orientation' => 'Portrait',
  2087.             'header-html' => $header
  2088.             //'footer-html' => $footer
  2089.         ];
  2091.         try {
  2092.             $knpSnappyPdf->generateFromHtml($html, $this->getParameter('app.app_directory').'/downloads/students/' . $file_name, $options, true);
  2093.         } catch (\Throwable $th) {
  2094.             $this->addFlash('info', $th->getMessage());
  2095.         }
  2096.         
  2098.         return $this->redirectToRoute('preview', [
  2099.             'file' => $file_name,
  2100.             'dir' => 'students',
  2101.         ]);
  2102.     }
  2104.     /**
  2105.      * @Route("/_registration_fee", name="api_registration_student_registration_get_registration_fees", methods={"GET","POST"})
  2106.      */
  2107.     public function api_get_registration_fees(Request $request, StockKitCategoryRepository $stockKitCategoryRepository, AccountingStudentRegistrationFeeRepository $accountingStudentRegistrationFeeRepository, RegistrationStudentRegistrationRepository $registrationStudentRegistrationRepository){
  2109.         /**@var User $user */
  2110.         $user = $this->getUser();
  2111.         $schoolYear = $user->getSchoolYear();
  2112.         $establishment = $user->getEstablishment();
  2114.         $stockKitCategory = $stockKitCategoryRepository->findOneBy(['id' => $request->get('kitCategory')], []);
  2115.         $registrationStudentRegistration = $registrationStudentRegistrationRepository->findOneBy(['id' => $request->get('registrationStudent')], []);
  2117.         if (null == $stockKitCategory || null == $registrationStudentRegistration) {
  2118.             return $this->json([
  2119.                 'code' => 404, 
  2120.                 'message' => "ok",
  2121.                 'accountingStudentRegistrationFees' => new ArrayCollection()
  2122.             ], 200);
  2123.         }
  2124.         
  2125.         $accountingStudentRegistrationFees = $accountingStudentRegistrationFeeRepository->createQueryBuilder('entity')
  2127.             ->andWhere('entity.studentRegistration = :studentRegistration')
  2128.             ->setParameter('studentRegistration', $registrationStudentRegistration)
  2130.             ->andWhere('entity.fee = :fee')
  2131.             ->setParameter('fee', $stockKitCategory->getFee())
  2133.             ->orderBy('entity.label', 'ASC')
  2134.             ->getQuery()
  2135.             ->getResult();
  2137.         $data = new ArrayCollection();
  2138.         
  2139.         foreach ($accountingStudentRegistrationFees as $key => $accountingStudentRegistrationFee) {
  2140.             if (count($accountingStudentRegistrationFee->getStockKitOuts()) <= 0) {
  2141.                 $data->add([
  2142.                     'id' => $accountingStudentRegistrationFee->getId(),
  2143.                     'label' => $accountingStudentRegistrationFee->getLabel()
  2144.                 ]);
  2145.             }
  2146.         }
  2148.         return $this->json([
  2149.             'code' => 200, 
  2150.             'message' => "ok",
  2151.             'accountingStudentRegistrationFees' => $data
  2152.         ], 200);
  2153.     }
  2155.     /**
  2156.      * @Route("/{id}/set-student-to-affected/{idStudent}", name="registration_student_registration_set_student_to_affected", methods={"GET"})
  2157.      */
  2158.     public function set_student_to_affected(RegistrationStudentRegistration $registrationStudentRegistration, RegistrationStudentRepository $registrationStudent, $idStudent): Response
  2159.     {
  2160.         $student = $registrationStudent->findOneBy(['id' => $idStudent], []);
  2162.         if (null == $student) {
  2163.             $this->addFlash('info', 'Étudiant non trouvé');
  2164.             return $this->redirectToRoute('registration_student_registration_edit', ['id' => $registrationStudentRegistration->getId()]);
  2165.         }
  2167.         $registrationStudentRegistration->setStudent($student);
  2169.         $entityManager = $this->getDoctrine()->getManager();
  2170.         $entityManager->flush();
  2172.         $this->addFlash('success', 'Inscrition : '.$registrationStudentRegistration->getSchoolYear().' - '.$registrationStudentRegistration->getStudent()->getRegistrationNumber().' - '.$registrationStudentRegistration->getStudent()->getLastName().' '.$registrationStudentRegistration->getStudent()->getFirstName().' transférée avec succès vers l\'étudiant : '.$student->getRegistrationNumber().' - '.$student->getLastName().' '.$student->getFirstName());
  2174.         return $this->redirectToRoute('registration_student_registration_edit', ['id' => $registrationStudentRegistration->getId()]);
  2175.     }
  2177.     /**
  2178.      * @Route("/{id}/get-solde-anterieur", name="registration_student_registration_get_solde_anterieur", methods={"GET"})
  2179.      */
  2180.     public function get_solde_anterieur(RegistrationStudentRegistration $registrationStudentRegistration, RegistrationStudentRegistrationRepository $registrationStudentRegistrationRepository): Response
  2181.     {
  2182.         // Ajout de solde anterieur à partir de la deuxième année de gestion
  2183.         $anteriorRegistrationStudentRegistrations = $registrationStudentRegistrationRepository->findBy(['student' => $registrationStudentRegistration->getStudent()], ['id' => 'DESC']);
  2184.         $entityManager = $this->getDoctrine()->getManager();
  2185.         
  2186.         foreach ($anteriorRegistrationStudentRegistrations as $key => $anteriorRegistrationStudentRegistration) {
  2187.             if ($anteriorRegistrationStudentRegistration->getSchoolYear() != $registrationStudentRegistration->getSchoolYear()) {
  2188.                 $order = 0;
  2189.                 if (null != $anteriorRegistrationStudentRegistration) {
  2190.                     foreach ($anteriorRegistrationStudentRegistration->getAccountingStudentRegistrationFees() as $key => $accountingStudentRegistrationFee) {
  2191.                         $order++;
  2192.                         if (!$accountingStudentRegistrationFee->getIsArchived()) {
  2193.                             if (!$accountingStudentRegistrationFee->getIsCancel()) {
  2194.                                 if (!$accountingStudentRegistrationFee->getIsReported()) {
  2195.                                     if ($accountingStudentRegistrationFee->getAmountRest() > 0) {
  2196.                                         $anteriorAccountingStudentRegistrationFee = new AccountingStudentRegistrationFee();
  2197.                                         $anteriorAccountingStudentRegistrationFee->setEstablishment($registrationStudentRegistration->getEstablishment());
  2198.                                         $anteriorAccountingStudentRegistrationFee->setStudentRegistration($registrationStudentRegistration);
  2199.                                         $anteriorAccountingStudentRegistrationFee->setFee($accountingStudentRegistrationFee->getFee());
  2200.                                         $anteriorAccountingStudentRegistrationFee->setAmount($accountingStudentRegistrationFee->getAmountRest());
  2201.                                         $anteriorAccountingStudentRegistrationFee->setCode('SA-'.$accountingStudentRegistrationFee->getLabel().'-'.$registrationStudentRegistration->getId());
  2202.                                         $anteriorAccountingStudentRegistrationFee->setLabel('SOLDE ANT. '.$accountingStudentRegistrationFee->getLabel());
  2203.                                         $anteriorAccountingStudentRegistrationFee->setIsArchived($accountingStudentRegistrationFee->getIsArchived());
  2204.                                         $anteriorAccountingStudentRegistrationFee->setIsCancel($accountingStudentRegistrationFee->getIsCancel());
  2206.                                         $anteriorAccountingStudentRegistrationFeeShedul = new AccountingStudentRegistrationFeeShedul();
  2207.                                         $anteriorAccountingStudentRegistrationFeeShedul->setAmount($anteriorAccountingStudentRegistrationFee->getAmount());
  2208.                                         $anteriorAccountingStudentRegistrationFeeShedul->setDateDue(new DateTimeImmutable());
  2209.                                         $anteriorAccountingStudentRegistrationFeeShedul->setOrderNum($order);
  2210.                                         $anteriorAccountingStudentRegistrationFeeShedul->setEstablishment($registrationStudentRegistration->getEstablishment());
  2211.                                         $anteriorAccountingStudentRegistrationFeeShedul->setStudentRegistrationFee($anteriorAccountingStudentRegistrationFee);
  2212.                                         
  2213.                                         foreach ($accountingStudentRegistrationFee->getAccountingStudentRegistrationFeeSheduls() as $key => $accountingStudentRegistrationFeeShedul) {
  2214.                                             $accountingStudentRegistrationFeeShedul->setAmountReported($accountingStudentRegistrationFeeShedul->getAmountCancel() + $accountingStudentRegistrationFeeShedul->getAmountRest());
  2215.                                             $accountingStudentRegistrationFeeShedul->setIsReported(true);
  2216.                                         }
  2217.                                         
  2218.                                         $accountingStudentRegistrationFee->setIsReported(true);
  2219.                                         $accountingStudentRegistrationFee->setAmountReported($accountingStudentRegistrationFee->getAmountRest());
  2221.                                         $entityManager->persist($anteriorAccountingStudentRegistrationFeeShedul);
  2222.                                         $entityManager->persist($anteriorAccountingStudentRegistrationFee);
  2223.                                     }
  2224.                                 }
  2225.                             }
  2226.                         }
  2227.                     }
  2228.                 }
  2230.                 break;
  2231.             }
  2232.         }
  2234.         $entityManager = $this->getDoctrine()->getManager();
  2236.         try {
  2237.             $entityManager->flush();
  2238.             $this->addFlash('success', 'Solde antérieur ajouté avec succès');
  2239.         } catch (\Throwable $th) {
  2240.             $this->addFlash('info', $th->getMessage());
  2241.         }
  2243.         return $this->redirectToRoute('registration_student_registration_show', ['id' => $registrationStudentRegistration->getId()]);
  2244.     }
  2246.     /**
  2247.      * @Route("/{id}/set-empty-lv2", name="registration_student_registration_set_student_to_affected", methods={"GET"})
  2248.      */
  2249.     public function set_empty_lv2(RegistrationStudentRegistration $registrationStudentRegistration, RegistrationStudentRepository $registrationStudent): Response
  2250.     {
  2251.         $student = $registrationStudentRegistration->getStudent();
  2252.         $student->setLv2('');
  2254.         $entityManager = $this->getDoctrine()->getManager();
  2255.         $entityManager->flush();
  2257.         $this->addFlash('success', 'Traitement effectué');
  2259.         return $this->redirectToRoute('registration_student_registration_edit', ['id' => $registrationStudentRegistration->getId()]);
  2260.     }
  2261. }