src/Controller/Setting/SettingFeeController.php line 363

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Setting;
  5. use DateInterval;
  6. use Knp\Snappy\Pdf;
  7. use App\Entity\User;
  8. use DateTimeImmutable;
  9. use App\Entity\SettingFee;
  10. use App\Entity\SettingLevel;
  11. use App\Entity\SettingFeeShedul;
  12. use App\Repository\UserRepository;
  13. use App\Form\Setting\SettingFeeType;
  14. use App\Repository\SchoolYearRepository;
  15. use App\Repository\SettingFeeRepository;
  16. use Doctrine\ORM\EntityManagerInterface;
  17. use App\Form\Setting\SettingFeeShedulType;
  18. use App\Repository\SettingLevelRepository;
  19. use App\Repository\EstablishmentRepository;
  20. use Knp\Component\Pager\PaginatorInterface;
  21. use Symfony\Component\HttpFoundation\Request;
  22. use App\Repository\SettingClassroomRepository;
  23. use App\Repository\SettingFeeShedulRepository;
  24. use Symfony\Component\HttpFoundation\Response;
  25. use Symfony\Component\Routing\Annotation\Route;
  26. use Symfony\Bridge\Doctrine\Form\Type\EntityType;
  27. use App\Repository\RegistrationStudentRegistrationRepository;
  28. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  30. /**
  31.  * @Route("/setting/fee")
  32.  */
  33. class SettingFeeController extends AbstractController
  34. {
  35.     /**
  36.      * @Route("/index", name="setting_fee_index", methods={"GET"})
  37.      */
  38.     public function index(Request $request, PaginatorInterface $paginator, SettingFeeRepository $settingFeeRepository, SchoolYearRepository $schoolYearRepository, EstablishmentRepository $establishmentRepository, UserRepository $userRepository): Response
  39.     {
  40.         /**@var User $user */
  41.         $user = $this->getUser();
  42.         $schoolYear = $user->getSchoolYear();
  43.         
  44.         $establishment = $user->getEstablishment();
  45.         $setting_fees = $paginator->paginate(
  46.             $settingFeeRepository->createQueryBuilder('entity')
  48.             ->andWhere('entity.establishment = :establishment')
  49.             ->setParameter('establishment', $establishment)
  51.             ->andWhere('entity.schoolYear = :schoolYear')
  52.             ->setParameter('schoolYear', $schoolYear)
  54.             ->orderBy('entity.id', 'DESC')
  55.             ->getQuery(),
  56.             $request->query->getInt('page', 1),
  57.             1000
  58.         );
  60.         $establishments = $establishmentRepository->createQueryBuilder('entity')
  62.             ->andWhere('entity.establishmentGroup = :establishmentGroup')
  63.             ->setParameter('establishmentGroup', $establishment->getEstablishmentGroup())
  65.             ->orderBy('entity.name', 'ASC')
  66.             ->getQuery()
  67.             ->getResult();
  69.         return $this->render('setting/setting_fee/index.html.twig', [
  70.             'userRepository' => $userRepository,
  71.             'setting_fees' => $setting_fees,
  72.             'school_year' => $schoolYear,
  73.             'school_years' => $schoolYearRepository->findBy([], ['id' => 'DESC']),
  74.             'establishments' => $establishments
  75.         ]);
  76.     }
  78.     /**
  79.      * @Route("/new", name="setting_fee_new", methods={"GET","POST"})
  80.      */
  81.     public function new(Request $request, SettingLevelRepository $settingLevelRepository): Response
  82.     {
  83.         /**@var User $user */
  84.         $user = $this->getUser();
  85.         $schoolYear = $user->getSchoolYear();
  87.         $establishment = $this->getUser()->getEstablishment();
  88.         $settingFee = new SettingFee();
  89.         $levels = $settingLevelRepository->findBy(['establishment' => $establishment]);
  90.         $form = $this->createForm(SettingFeeType::class, $settingFee);
  91.         if ($establishment->getType() != $establishment::ESTABLISHMENT_PRESCOLAIRE_PRIMAIRE_TYPES) {
  92.             $form
  93.             ->add('is_for_non_affected')
  94.             ->add('is_for_affected');
  95.         }
  96.         $form
  97.         ->add('levels', EntityType::class, [
  98.             'class' => SettingLevel::class,
  99.             'choices' => $levels,
  100.             'multiple' => true,
  101.             'required' => false
  102.         ]);
  104.         $form->handleRequest($request);
  106.         if ($form->isSubmitted() && $form->isValid()) {
  107.             $entityManager = $this->getDoctrine()->getManager();
  108.             $settingFee->setEstablishment($this->getUser()->getEstablishment());
  109.             $settingFee->setSchoolYear($schoolYear);
  110.             $entityManager->persist($settingFee);
  111.             try {
  112.                 $entityManager->flush();
  113.                 $this->addFlash('success', "Un frais à été ajouté.");
  114.             } catch (\Throwable $th) {
  115.                 $this->addFlash('warning', "Une erreure est survenue lors de l'ajout du frais.");
  116.                 $this->addFlash('info', $th->getMessage());
  117.             }
  119.             return $this->redirectToRoute('setting_fee_edit', ['id' => $settingFee->getId()]);
  120.         }
  122.         return $this->renderForm('setting/setting_fee/new.html.twig', [
  123.             'setting_fee' => $settingFee,
  124.             'form' => $form,
  125.         ]);
  126.     }
  128.     /**
  129.      * @Route("/import", name="setting_fee_import", methods={"GET"})
  130.      */
  131.     public function import(Request $request, SettingFeeRepository $settingFeeRepository, SchoolYearRepository $schoolYearRepository): Response
  132.     {
  133.         /**@var User $user */
  134.         $user = $this->getUser();
  135.         $schoolYear = $schoolYearRepository->findOneBy(['id' => $request->get('school_year')], []);
  136.         $establishment = $user->getEstablishment();
  138.         if (null != $schoolYear) {
  139.             $settingFees = $settingFeeRepository->findBy(['schoolYear' => $schoolYear, 'establishment' => $establishment], []);
  140.             $entityManager = $this->getDoctrine()->getManager();
  142.             foreach ($settingFees as $key => $fee) {
  143.                 $settingFee = new SettingFee;
  144.                 $settingFee->setEstablishment($fee->getEstablishment());
  145.                 $settingFee->setSchoolYear($user->getSchoolYear());
  146.                 $settingFee->setAccountingAccount($fee->getAccountingAccount());
  147.                 $settingFee->setAmount($fee->getAmount());
  148.                 $settingFee->setLabel($fee->getLabel());
  149.                 $settingFee->setCategory($fee->getCategory());
  150.                 $settingFee->setDuration($fee->getDuration());
  151.                 $settingFee->setFeeProvider($fee->getFeeProvider());
  152.                 $settingFee->setIsForAffected($fee->getIsForAffected());
  153.                 $settingFee->setIsForAll($fee->getIsForAll());
  154.                 $settingFee->setIsForNonAffected($fee->getIsForNonAffected());
  155.                 $settingFee->setQuantityAvailable($fee->getQuantityAvailable());
  157.                 foreach ($fee->getLevels() as $key => $level) {
  158.                     $settingFee->addLevel($level);
  159.                 }
  161.                 foreach ($fee->getTransportZones() as $key => $transportZone) {
  162.                     $settingFee->addTransportZone($transportZone);
  163.                 }
  165.                 foreach ($fee->getSettingFeeSheduls() as $key => $feeShedul) {
  166.                     $settingFeeShedul = new SettingFeeShedul();
  167.                     $settingFeeShedul->setFee($settingFee);
  168.                     $settingFeeShedul->setAmount($feeShedul->getAmount());
  169.                     $settingFeeShedul->setDateDue($feeShedul->getDateDue()->add(new DateInterval("P1Y")));
  170.                     $settingFeeShedul->setOrderNum($feeShedul->getOrderNum());
  171.                     $settingFeeShedul->setEstablishment($feeShedul->getEstablishment());
  173.                     $entityManager->persist($settingFeeShedul);
  174.                 }
  176.                 $entityManager->persist($settingFee);
  177.             }
  178.         }
  179.         
  180.         try {
  181.             $entityManager->flush();
  182.             $this->addFlash('success', "Importation effectuée.");
  183.         } catch (\Throwable $th) {
  184.             $this->addFlash('warning', "Une erreure est survenue lors de l'importation.");
  185.             $this->addFlash('info', $th->getMessage());
  186.         }
  187.         
  188.         return $this->redirectToRoute('setting_fee_index', [], Response::HTTP_SEE_OTHER);
  189.     }
  191.     /**
  192.      * @Route("/{id}/edit", name="setting_fee_edit", methods={"GET","POST"})
  193.      */
  194.     public function edit(Request $request, SettingFee $settingFee, SettingFeeShedulRepository $settingFeeShedulRepository, SettingLevelRepository $settingLevelRepository): Response
  195.     {
  196.         $establishment = $this->getUser()->getEstablishment();
  197.         $levels = $settingLevelRepository->findBy(['establishment' => $establishment]);
  198.         $form = $this->createForm(SettingFeeType::class, $settingFee);
  199.         if ($establishment->getType() != $establishment::ESTABLISHMENT_PRESCOLAIRE_PRIMAIRE_TYPES) {
  200.             $form
  201.             ->add('is_for_non_affected')
  202.             ->add('is_for_affected')
  203.             ->add('is_for_all');
  204.         }
  205.         $form
  206.         ->add('levels', EntityType::class, [
  207.             'class' => SettingLevel::class,
  208.             'choices' => $levels,
  209.             'multiple' => true,
  210.             'required' => false
  211.         ]);
  212.         $form->handleRequest($request);
  214.         if ($form->isSubmitted() && $form->isValid()) {
  215.             try {
  216.                 $this->getDoctrine()->getManager()->flush();
  217.                 $this->addFlash('success', "le frais à été édité.");
  218.             } catch (\Throwable $th) {
  219.                 $this->addFlash('warning', "Une erreure est survenue lors de l'édition du frais.");
  220.                 $this->addFlash('info', $th->getMessage());
  221.             }
  223.             return $this->redirectToRoute('setting_fee_edit', ['id' => $settingFee->getId()]);
  224.         }
  225.         /* Ajout des echeancies */
  226.         $settingFeeShedul = new SettingFeeShedul();
  227.         $settingFeeShedul->setOrderNum(count($settingFee->getSettingFeeSheduls()) + 1);
  228.         $ShedulForm = $this->createForm(SettingFeeShedulType::class, $settingFeeShedul);
  229.         $ShedulForm->handleRequest($request);
  231.         if ($ShedulForm->isSubmitted() && $ShedulForm->isValid()) {
  232.             if ($settingFeeShedulRepository->findOneBy([],['id' => 'DESC']) != null) {
  233.                 if ($settingFeeShedulRepository->findOneBy(['fee' => $settingFee],['id' => 'DESC']) != null) {
  234.                     if ($settingFeeShedul->getDateDue() <= $settingFeeShedulRepository->findOneBy(['fee' => $settingFee],['id' => 'DESC'])->getDateDue()) {
  235.                         $this->addFlash('warning', "date invalide.");
  236.                         return $this->redirectToRoute('setting_fee_edit', ['id' => $settingFee->getId()]);
  237.                     }
  238.                 }
  239.             }
  241.             if (($settingFee->getSheduledAmount() + $settingFeeShedul->getAmount()) > $settingFee->getAmount()) {
  242.                 $this->addFlash('warning', "le montant est trop élévé.");
  243.                 return $this->redirectToRoute('setting_fee_edit', ['id' => $settingFee->getId()]);
  244.             }
  245.             $entityManager = $this->getDoctrine()->getManager();
  246.             $settingFeeShedul->setEstablishment($settingFee->getEstablishment());
  247.             $settingFeeShedul->setFee($settingFee);
  248.             $entityManager->persist($settingFeeShedul);
  249.             try {
  250.                 $entityManager->flush();
  251.                 $this->addFlash('success', "un écheancier à été ajouté.");
  252.             } catch (\Throwable $th) {
  253.                 $this->addFlash('warning', "Une erreur est survenue lors de l'ajout de l'échéancier.");
  254.                 $this->addFlash('info', $th->getMessage());
  255.             }
  257.             return $this->redirectToRoute('setting_fee_edit', ['id' => $settingFee->getId()]);
  258.         }
  260.         return $this->renderForm('setting/setting_fee/edit.html.twig', [
  261.             'setting_fee' => $settingFee,
  262.             'setting_fee_shedul' => $settingFeeShedul,
  263.             'form' => $form,
  264.             'ShedulForm' => $ShedulForm,
  265.         ]);
  266.     }
  268.     /**
  269.      * @Route("/delete-selection", name="setting_fees_selected_delete", methods={"GET"})
  270.     */
  271.     public function deleteSelected(Request $request, SettingFeeRepository $entityRepository): Response
  272.     {
  273.         $list = $request->get('entities');
  274.         $entityManager = $this->getDoctrine()->getManager();
  275.         $errors = 0;
  276.         foreach ($list as $key => $id) {
  277.             $entity = $entityRepository->findOneBy(['id' => intval($id)], []);
  278.             if ($entity != null) {
  279.                 if (count($entity->getAccountingStudentRegistrationFees()) <= 0) {
  280.                     foreach ($entity->getSettingFeeSheduls() as $key => $settingFeeShedul) {
  281.                         $entityManager->remove($settingFeeShedul);
  282.                     }
  283.                     $entityManager->remove($entity);
  284.                 }
  285.             }
  286.         }
  288.         try {
  289.             $entityManager->flush();
  290.             $this->addFlash('success', "Traitement effectué");
  291.             return $this->json(['code' => 200, 'message' => "Traitement effectué :)"], 200);
  292.         } catch (\Throwable $th) {
  293.             //$th->getMessage()
  294.             $this->addFlash('warning', $th->getMessage());
  295.         }
  296.         
  297.         $this->addFlash('warning', "Traitement non effectué");
  298.         return $this->json(['code' => 500, 'message' => "Traitement non effectué"], 200);
  299.     }
  301.     /**
  302.      * @Route("/{id}/printStudent", name="setting_fee_print_student", methods={"GET"})
  303.     */
  304.     public function printStudent(Pdf $knpSnappyPdf, SettingFee $settingFee, RegistrationStudentRegistrationRepository $registrationStudentRegistrationRepository)
  305.     {
  306.         /**@var User $user */
  307.         $user = $this->getUser();
  308.         $schoolYear = $user->getSchoolYear();
  310.         $setting = $settingFee->getEstablishment();
  311.         $registrationStudentRegistrations = $registrationStudentRegistrationRepository->createQueryBuilder('entity')
  313.         ->innerJoin('entity.student', 'student')
  314.         ->addSelect('student')
  315.         
  316.         ->innerJoin('entity.accountingStudentRegistrationFees', 'accountingStudentRegistrationFee')
  317.         ->addSelect('accountingStudentRegistrationFee')
  319.         ->innerJoin('accountingStudentRegistrationFee.fee', 'fee')
  320.         ->addSelect('fee')
  322.         ->andWhere('fee.schoolYear = :schoolYear')
  323.         ->setParameter('schoolYear', $schoolYear)
  325.         /*->andWhere('accountingStudentRegistrationFee.is_cancel = :isCancel')
  326.         ->setParameter('isCancel', false)*/
  328.         ->andWhere('fee.id = :feeId')
  329.         ->setParameter('feeId', $settingFee->getId())
  331.         ->orderBy('student.last_name', 'ASC')
  332.         ->getQuery()
  333.         ->getResult();
  334.         $html = $this->renderView('setting/print/studentRegistrationFee.html.twig', [
  335.             'setting_fee' => $settingFee,
  336.             'registration_student_registrations' => $registrationStudentRegistrations,
  337.             'school_year' => $schoolYear,
  338.             'setting' => $setting,
  339.         ]);
  341.         $file_name = 'ABONNES_FRAIS_'.$settingFee->getId().".pdf";
  343.         $footer = $this->renderView('print/footer.html.twig', ['setting' => $setting,]);
  344.         $header = $this->renderView('print/header.html.twig', ['setting' => $setting,]);
  346.         $options = [
  347.             'orientation' => 'Landscape',
  348.             'header-html' => $header,
  349.             'footer-html' => $footer
  350.         ];
  351.         
  352.         $knpSnappyPdf->generateFromHtml($html, $this->getParameter('app.app_directory').'/downloads/setting/' . $file_name, $options, true);
  354.         return $this->redirectToRoute('preview', [
  355.             'file' => $file_name,
  356.             'dir' => 'setting',
  357.         ]);
  358.     }
  360.     /**
  361.      * @Route("/api/has-duration", name="api_setting_fee_has_duration", methods={"GET"})
  362.     */
  363.     public function api_has_duration(Request $request, SettingFeeRepository $entityRepository): Response
  364.     {
  365.         $id = $request->get('id');
  366.         $entity = $entityRepository->findOneBy(['id' => intval($id)], []);
  367.         if ($entity != null) {
  368.             if (strlen($entity->getDuration()) > 3) {
  369.                 return $this->json(['code' => 200, 'message' => $entity->getDuration()], 200);
  370.             }
  371.         }
  372.         
  373.         return $this->json(['code' => 500, 'message' => "Cette abonnement n' est pas periodique."], 200);
  374.     }
  376.     /**
  377.      * @Route("/print-student-by-classroom", name="setting_fee_print_student_by_classroom", methods={"GET"})
  378.     */
  379.     public function print_student_by_classroom(Pdf $knpSnappyPdf, SettingFeeRepository $settingFeeRepository, SettingClassroomRepository $settingClassroomRepository)
  380.     {
  381.         /**@var User $user */
  382.         $user = $this->getUser();
  383.         $schoolYear = $user->getSchoolYear();
  385.         $setting = $this->getUser()->getEstablishment();
  386.         $settingFees = $settingFeeRepository->createQueryBuilder('entity')
  388.         ->andWhere('entity.schoolYear = :schoolYear')
  389.         ->setParameter('schoolYear', $schoolYear)
  391.         ->andWhere('entity.establishment = :establishment')
  392.         ->setParameter('establishment', $setting)
  394.         ->orderBy('entity.label', 'ASC')
  395.         ->getQuery()
  396.         ->getResult();
  398.         $settingClassrooms = $settingClassroomRepository->createQueryBuilder('entity')
  400.         ->andWhere('entity.schoolYear = :schoolYear')
  401.         ->setParameter('schoolYear', $schoolYear)
  403.         ->andWhere('entity.establishment = :establishment')
  404.         ->setParameter('establishment', $setting)
  406.         ->orderBy('entity.label', 'ASC')
  407.         ->getQuery()
  408.         ->getResult();
  410.         $html = $this->renderView('setting/print/student_fee_by_classrooms.html.twig', [
  411.             'setting_fees' => $settingFees,
  412.             'setting_classrooms' => $settingClassrooms,
  413.             'school_year' => $schoolYear,
  414.             'create_date' => new DateTimeImmutable(),
  415.             'setting' => $setting,
  416.         ]);
  418.         $file_name = 'ABONNES_FRAIS_PAR_CLASSE_'.time().".pdf";
  420.         $footer = $this->renderView('print/footer.html.twig', ['setting' => $setting,]);
  421.         $header = $this->renderView('print/header.html.twig', ['setting' => $setting,]);
  423.         $options = [
  424.             'orientation' => 'Portrait',
  425.             'header-html' => $header,
  426.             'footer-html' => $footer
  427.         ];
  428.         
  429.         $knpSnappyPdf->generateFromHtml($html, $this->getParameter('app.app_directory').'/downloads/setting/' . $file_name, $options, true);
  431.         return $this->redirectToRoute('preview', [
  432.             'file' => $file_name,
  433.             'dir' => 'setting',
  434.         ]);
  435.     }
  437.     /**
  438.      * @Route("/print/{id}/student-by-classroom", name="setting_fee_print_by_classroom", methods={"GET"})
  439.     */
  440.     public function print_by_classroom(Pdf $knpSnappyPdf, SettingFee $settingFee, SettingClassroomRepository $settingClassroomRepository)
  441.     {
  442.         /**@var User $user */
  443.         $user = $this->getUser();
  444.         $schoolYear = $user->getSchoolYear();
  446.         $setting = $this->getUser()->getEstablishment();
  448.         $settingClassrooms = $settingClassroomRepository->createQueryBuilder('entity')
  450.         ->andWhere('entity.schoolYear = :schoolYear')
  451.         ->setParameter('schoolYear', $schoolYear)
  453.         ->andWhere('entity.establishment = :establishment')
  454.         ->setParameter('establishment', $setting)
  456.         ->orderBy('entity.label', 'ASC')
  457.         ->getQuery()
  458.         ->getResult();
  460.         $html = $this->renderView('setting/print/fee_by_classroom.html.twig', [
  461.             'setting_fee' => $settingFee,
  462.             'setting_classrooms' => $settingClassrooms,
  463.             'school_year' => $schoolYear,
  464.             'create_date' => new DateTimeImmutable(),
  465.             'setting' => $setting,
  466.         ]);
  468.         $file_name = 'ABONNES_FRAIS_PAR_CLASSE_'.time().".pdf";
  470.         $footer = $this->renderView('print/footer.html.twig', ['setting' => $setting,]);
  471.         $header = $this->renderView('print/header.html.twig', ['setting' => $setting,]);
  473.         $options = [
  474.             'orientation' => 'Portrait',
  475.             'header-html' => $header,
  476.             'footer-html' => $footer
  477.         ];
  478.         
  479.         $knpSnappyPdf->generateFromHtml($html, $this->getParameter('app.app_directory').'/downloads/setting/' . $file_name, $options, true);
  481.         return $this->redirectToRoute('preview', [
  482.             'file' => $file_name,
  483.             'dir' => 'setting',
  484.         ]);
  485.     }
  487.     /**
  488.      * @Route("/add-year", name="setting_fee_add_year", methods={"GET"})
  489.     */
  490.     public function add_year(SettingFeeShedulRepository $entityRepository): Response
  491.     {
  492.         $entityManager = $this->getDoctrine()->getManager();
  493.         foreach ($entityRepository->findBy([], []) as $key => $entity) {
  494.             $entity->setDateDue($entity->getDateDue()->add(new DateInterval("P1Y")));
  495.         }
  497.         try {
  498.             $entityManager->flush();
  499.             $this->addFlash('success', "Traitement effectué");
  500.             return $this->json(['code' => 200, 'message' => "Traitement effectué :)"], 200);
  501.         } catch (\Throwable $th) {
  502.             //$th->getMessage()
  503.             $this->addFlash('warning', $th->getMessage());
  504.         }
  505.         
  506.         $this->addFlash('warning', "Traitement non effectué");
  507.         return $this->json(['code' => 500, 'message' => "Traitement non effectué"], 200);
  508.     }
  510.     /**
  511.      * @Route("/sub-year", name="setting_fee_sub_year", methods={"GET"})
  512.     */
  513.     public function sub_year(SettingFeeShedulRepository $entityRepository): Response
  514.     {
  515.         $entityManager = $this->getDoctrine()->getManager();
  516.         foreach ($entityRepository->findBy([], []) as $key => $entity) {
  517.             $entity->setDateDue($entity->getDateDue()->sub(new DateInterval("P1Y")));
  518.         }
  520.         try {
  521.             $entityManager->flush();
  522.             $this->addFlash('success', "Traitement effectué");
  523.             return $this->json(['code' => 200, 'message' => "Traitement effectué :)"], 200);
  524.         } catch (\Throwable $th) {
  525.             //$th->getMessage()
  526.             $this->addFlash('warning', $th->getMessage());
  527.         }
  528.         
  529.         $this->addFlash('warning', "Traitement non effectué");
  530.         return $this->json(['code' => 500, 'message' => "Traitement non effectué"], 200);
  531.     }
  533.     /**
  534.      * @Route("/api/set-establishment/{id}", name="api_setting_fee_set_establishment", methods={"GET"})
  535.     */
  536.     public function api_set_establishment(Request $request, EstablishmentRepository $establishmentRepositoryRepository, SettingFee $settingFee, EntityManagerInterface $entityManager): Response
  537.     {
  538.         $id = $request->get('establishment');
  539.         $establishment = $establishmentRepositoryRepository->findOneBy(['id' => $id], []);
  540.         if ($establishment != null) {
  541.             $settingFee->setEstablishment($establishment);
  542.         }
  543.         
  544.         try {
  545.             $entityManager->flush();
  546.             return $this->json(['code' => 200, 'message' => "Traitement effectué :)"], 200);
  547.         } catch (\Throwable $th) {
  548.             $this->addFlash('warning', $th->getMessage());
  549.         }
  550.         
  551.         $this->addFlash('warning', "Traitement non effectué");
  552.         return $this->json(['code' => 500, 'message' => "Traitement non effectué"], 200);
  553.     }
  554. }