src/Controller/Setting/SettingFeeController.php line 360

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_index', [], Response::HTTP_SEE_OTHER);
  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('entity.schoolYear = :schoolYear')
  323.         ->setParameter('schoolYear', $schoolYear)
  325.         ->andWhere('fee.id = :feeId')
  326.         ->setParameter('feeId', $settingFee->getId())
  328.         ->orderBy('student.last_name', 'ASC')
  329.         ->getQuery()
  330.         ->getResult();
  331.         $html = $this->renderView('setting/print/studentRegistrationFee.html.twig', [
  332.             'setting_fee' => $settingFee,
  333.             'registration_student_registrations' => $registrationStudentRegistrations,
  334.             'school_year' => $schoolYear,
  335.             'setting' => $setting,
  336.         ]);
  338.         $file_name = 'ABONNES_FRAIS_'.$settingFee->getId().".pdf";
  340.         $footer = $this->renderView('print/footer.html.twig', ['setting' => $setting,]);
  341.         $header = $this->renderView('print/header.html.twig', ['setting' => $setting,]);
  343.         $options = [
  344.             'orientation' => 'Landscape',
  345.             'header-html' => $header,
  346.             'footer-html' => $footer
  347.         ];
  348.         
  349.         $knpSnappyPdf->generateFromHtml($html, $this->getParameter('app.app_directory').'/downloads/setting/' . $file_name, $options, true);
  351.         return $this->redirectToRoute('preview', [
  352.             'file' => $file_name,
  353.             'dir' => 'setting',
  354.         ]);
  355.     }
  357.     /**
  358.      * @Route("/api/has-duration", name="api_setting_fee_has_duration", methods={"GET"})
  359.     */
  360.     public function api_has_duration(Request $request, SettingFeeRepository $entityRepository): Response
  361.     {
  362.         $id = $request->get('id');
  363.         $entity = $entityRepository->findOneBy(['id' => intval($id)], []);
  364.         if ($entity != null) {
  365.             if (strlen($entity->getDuration()) > 3) {
  366.                 return $this->json(['code' => 200, 'message' => $entity->getDuration()], 200);
  367.             }
  368.         }
  369.         
  370.         return $this->json(['code' => 500, 'message' => "Cette abonnement n' est pas periodique."], 200);
  371.     }
  373.     /**
  374.      * @Route("/print-student-by-classroom", name="setting_fee_print_student_by_classroom", methods={"GET"})
  375.     */
  376.     public function print_student_by_classroom(Pdf $knpSnappyPdf, SettingFeeRepository $settingFeeRepository, SettingClassroomRepository $settingClassroomRepository)
  377.     {
  378.         /**@var User $user */
  379.         $user = $this->getUser();
  380.         $schoolYear = $user->getSchoolYear();
  382.         $setting = $this->getUser()->getEstablishment();
  383.         $settingFees = $settingFeeRepository->createQueryBuilder('entity')
  385.         ->andWhere('entity.schoolYear = :schoolYear')
  386.         ->setParameter('schoolYear', $schoolYear)
  388.         ->andWhere('entity.establishment = :establishment')
  389.         ->setParameter('establishment', $setting)
  391.         ->orderBy('entity.label', 'ASC')
  392.         ->getQuery()
  393.         ->getResult();
  395.         $settingClassrooms = $settingClassroomRepository->createQueryBuilder('entity')
  397.         ->andWhere('entity.schoolYear = :schoolYear')
  398.         ->setParameter('schoolYear', $schoolYear)
  400.         ->andWhere('entity.establishment = :establishment')
  401.         ->setParameter('establishment', $setting)
  403.         ->orderBy('entity.label', 'ASC')
  404.         ->getQuery()
  405.         ->getResult();
  407.         $html = $this->renderView('setting/print/student_fee_by_classrooms.html.twig', [
  408.             'setting_fees' => $settingFees,
  409.             'setting_classrooms' => $settingClassrooms,
  410.             'school_year' => $schoolYear,
  411.             'create_date' => new DateTimeImmutable(),
  412.             'setting' => $setting,
  413.         ]);
  415.         $file_name = 'ABONNES_FRAIS_PAR_CLASSE_'.".pdf";
  417.         $footer = $this->renderView('print/footer.html.twig', ['setting' => $setting,]);
  418.         $header = $this->renderView('print/header.html.twig', ['setting' => $setting,]);
  420.         $options = [
  421.             'orientation' => 'Portrait',
  422.             'header-html' => $header
  423.             //'footer-html' => $footer
  424.         ];
  425.         
  426.         $knpSnappyPdf->generateFromHtml($html, $this->getParameter('app.app_directory').'/downloads/setting/' . $file_name, $options, true);
  428.         return $this->redirectToRoute('preview', [
  429.             'file' => $file_name,
  430.             'dir' => 'setting',
  431.         ]);
  432.     }
  434.     /**
  435.      * @Route("/print/{id}/student-by-classroom", name="setting_fee_print_by_classroom", methods={"GET"})
  436.     */
  437.     public function print_by_classroom(Pdf $knpSnappyPdf, SettingFee $settingFee, SettingClassroomRepository $settingClassroomRepository)
  438.     {
  439.         /**@var User $user */
  440.         $user = $this->getUser();
  441.         $schoolYear = $user->getSchoolYear();
  443.         $setting = $this->getUser()->getEstablishment();
  445.         $settingClassrooms = $settingClassroomRepository->createQueryBuilder('entity')
  447.         ->andWhere('entity.schoolYear = :schoolYear')
  448.         ->setParameter('schoolYear', $schoolYear)
  450.         ->andWhere('entity.establishment = :establishment')
  451.         ->setParameter('establishment', $setting)
  453.         ->orderBy('entity.label', 'ASC')
  454.         ->getQuery()
  455.         ->getResult();
  457.         $html = $this->renderView('setting/print/fee_by_classroom.html.twig', [
  458.             'setting_fee' => $settingFee,
  459.             'setting_classrooms' => $settingClassrooms,
  460.             'school_year' => $schoolYear,
  461.             'create_date' => new DateTimeImmutable(),
  462.             'setting' => $setting,
  463.         ]);
  465.         $file_name = 'ABONNES_FRAIS_PAR_CLASSE_'.".pdf";
  467.         $footer = $this->renderView('print/footer.html.twig', ['setting' => $setting,]);
  468.         $header = $this->renderView('print/header.html.twig', ['setting' => $setting,]);
  470.         $options = [
  471.             'orientation' => 'Portrait',
  472.             'header-html' => $header
  473.             //'footer-html' => $footer
  474.         ];
  475.         
  476.         $knpSnappyPdf->generateFromHtml($html, $this->getParameter('app.app_directory').'/downloads/setting/' . $file_name, $options, true);
  478.         return $this->redirectToRoute('preview', [
  479.             'file' => $file_name,
  480.             'dir' => 'setting',
  481.         ]);
  482.     }
  484.     /**
  485.      * @Route("/add-year", name="setting_fee_add_year", methods={"GET"})
  486.     */
  487.     public function add_year(SettingFeeShedulRepository $entityRepository): Response
  488.     {
  489.         $entityManager = $this->getDoctrine()->getManager();
  490.         foreach ($entityRepository->findBy([], []) as $key => $entity) {
  491.             $entity->setDateDue($entity->getDateDue()->add(new DateInterval("P1Y")));
  492.         }
  494.         try {
  495.             $entityManager->flush();
  496.             $this->addFlash('success', "Traitement effectué");
  497.             return $this->json(['code' => 200, 'message' => "Traitement effectué :)"], 200);
  498.         } catch (\Throwable $th) {
  499.             //$th->getMessage()
  500.             $this->addFlash('warning', $th->getMessage());
  501.         }
  502.         
  503.         $this->addFlash('warning', "Traitement non effectué");
  504.         return $this->json(['code' => 500, 'message' => "Traitement non effectué"], 200);
  505.     }
  507.     /**
  508.      * @Route("/sub-year", name="setting_fee_sub_year", methods={"GET"})
  509.     */
  510.     public function sub_year(SettingFeeShedulRepository $entityRepository): Response
  511.     {
  512.         $entityManager = $this->getDoctrine()->getManager();
  513.         foreach ($entityRepository->findBy([], []) as $key => $entity) {
  514.             $entity->setDateDue($entity->getDateDue()->sub(new DateInterval("P1Y")));
  515.         }
  517.         try {
  518.             $entityManager->flush();
  519.             $this->addFlash('success', "Traitement effectué");
  520.             return $this->json(['code' => 200, 'message' => "Traitement effectué :)"], 200);
  521.         } catch (\Throwable $th) {
  522.             //$th->getMessage()
  523.             $this->addFlash('warning', $th->getMessage());
  524.         }
  525.         
  526.         $this->addFlash('warning', "Traitement non effectué");
  527.         return $this->json(['code' => 500, 'message' => "Traitement non effectué"], 200);
  528.     }
  530.     /**
  531.      * @Route("/api/set-establishment/{id}", name="api_setting_fee_set_establishment", methods={"GET"})
  532.     */
  533.     public function api_set_establishment(Request $request, EstablishmentRepository $establishmentRepositoryRepository, SettingFee $settingFee, EntityManagerInterface $entityManager): Response
  534.     {
  535.         $id = $request->get('establishment');
  536.         $establishment = $establishmentRepositoryRepository->findOneBy(['id' => $id], []);
  537.         if ($establishment != null) {
  538.             $settingFee->setEstablishment($establishment);
  539.         }
  540.         
  541.         try {
  542.             $entityManager->flush();
  543.             return $this->json(['code' => 200, 'message' => "Traitement effectué :)"], 200);
  544.         } catch (\Throwable $th) {
  545.             $this->addFlash('warning', $th->getMessage());
  546.         }
  547.         
  548.         $this->addFlash('warning', "Traitement non effectué");
  549.         return $this->json(['code' => 500, 'message' => "Traitement non effectué"], 200);
  550.     }
  551. }