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