src/Controller/Treasury/TreasuryCashRegisterController.php line 347

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Treasury;
  5. use Knp\Snappy\Pdf;
  6. use App\Entity\User;
  7. use DateTimeImmutable;
  8. use App\Service\SMSSender;
  9. use App\Entity\LogOperation;
  10. use App\Entity\TreasuryPayment;
  11. use App\Entity\SettingClassroom;
  12. use App\Entity\TreasuryCheckout;
  13. use App\Repository\UserRepository;
  14. use App\Entity\FoundingNotification;
  15. use App\Entity\TreasuryCashMovement;
  16. use App\Entity\TreasuryCashRegister;
  17. use App\Repository\SchoolYearRepository;
  18. use App\Form\Treasury\TreasuryPaymentType;
  19. use Knp\Component\Pager\PaginatorInterface;
  20. use Symfony\Component\HttpFoundation\Request;
  21. use App\Repository\TreasuryCheckoutRepository;
  22. use Symfony\Component\HttpFoundation\Response;
  23. use App\Entity\RegistrationStudentRegistration;
  24. use App\Form\Treasury\TreasuryCashRegisterType;
  25. use App\Repository\AccountingExpenseRepository;
  26. use Symfony\Component\Routing\Annotation\Route;
  27. use Doctrine\Common\Collections\ArrayCollection;
  28. use Symfony\Bridge\Doctrine\Form\Type\EntityType;
  29. use App\Repository\TreasuryCashRegisterRepository;
  30. use App\Entity\AccountingStudentRegistrationPayment;
  31. use Knp\Bundle\SnappyBundle\Snappy\Response\PdfResponse;
  32. use App\Entity\AccountingStudentRegistrationFeeShedulPayment;
  33. use App\Repository\RegistrationStudentRegistrationRepository;
  34. use App\Form\Accounting\AccountingStudentRegistrationPaymentType;
  35. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  36. use App\Repository\AccountingStudentRegistrationPaymentRepository;
  37. use App\Repository\AccountingStudentRegistrationFeeShedulRepository;
  39. /**
  40.  * @Route("/treasury/cash-register")
  41.  */
  42. class TreasuryCashRegisterController extends AbstractController
  43. {
  44.     /**
  45.      * @Route("/index", name="treasury_cash_register_index", methods={"GET","POST"})
  46.      */
  47.     public function index(Request $request, PaginatorInterface $paginator, TreasuryCashRegisterRepository $treasuryCashRegisterRepository, TreasuryCheckoutRepository $treasuryCheckoutRepository): Response
  48.     {
  49.         /**@var User $user */
  50.         $user = $this->getUser();
  51.         $schoolYear = $user->getSchoolYear();
  52.         $establishment = $user->getEstablishment();
  53.         
  54.         
  56.         if ($schoolYear == null) {
  57.             $this->addFlash('warning', "Aucune base de donnée n'est activé.");
  58.             return $this->redirectToRoute('treasury_cash_register_new', []);
  59.         }
  61.         $treasuryCashRegister = new TreasuryCashRegister();
  62.         $treasuryCashRegister->setCode($this->getUser()->getUserIdentifier().'-du-'.$treasuryCashRegister->getCreateAt()->format('d-m-Y'));
  63.         $establishment = $this->getUser()->getEstablishment();
  64.         $checkouts = $treasuryCheckoutRepository->createQueryBuilder('entity')
  66.         ->andWhere('entity.created_by = :created_by')
  67.         ->setParameter('created_by', $this->getUser()->getId())
  69.         ->orderBy('entity.id', 'desc')
  70.         ->getQuery()
  71.         ->getResult();
  73.         $form = $this->createForm(TreasuryCashRegisterType::class, $treasuryCashRegister)
  74.         ->add('checkout', EntityType::class, [
  75.             'class' => TreasuryCheckout::class,
  76.             'choices' => $checkouts
  77.         ]);
  78.         $form->handleRequest($request);
  80.         if ($form->isSubmitted() && $form->isValid()) {
  81.             $entityManager = $this->getDoctrine()->getManager();
  83.             $treasuryCashRegister->setSchoolYear($schoolYear);
  84.             $treasuryCashRegister->setEstablishment($treasuryCashRegister->getCheckout()->getEstablishment());
  85.             $treasuryCashRegister->setCreateAt(new DateTimeImmutable());
  86.             
  87.             $entityManager->persist($treasuryCashRegister);
  88.             try {
  89.                 $entityManager->flush();
  90.                 $this->addFlash('success', "Un releve à été ajoutée.");
  91.                 return $this->redirectToRoute('treasury_cash_register_show', ['id' => $treasuryCashRegister->getId()]);
  92.             } catch (\Throwable $th) {
  93.                 $this->addFlash('warning', "Une erreure est survenue lors de l'ajout du releve.");
  94.                 $this->addFlash('info', $th->getMessage());
  95.                 return $this->redirectToRoute('treasury_cash_register_index', []);
  96.             }
  97.         }
  99.         if ($this->isGranted("ROLE_INDENTANT")) {
  100.             $query = $treasuryCashRegisterRepository->createQueryBuilder('entity')
  101.             ->innerJoin('entity.establishment', 'establishment')
  102.             ->addSelect('establishment')
  104.             ->andWhere('establishment.establishmentGroup = :establishmentGroup')
  105.             ->setParameter('establishmentGroup', $establishment->getEstablishmentGroup())
  107.             ->orderBy('entity.id', 'DESC')
  108.             ->getQuery();
  109.         }else {
  110.             $query = $treasuryCashRegisterRepository->createQueryBuilder('entity')
  111.             ->innerJoin('entity.establishment', 'establishment')
  112.             ->addSelect('establishment')
  113.     
  114.             ->andWhere('establishment.establishmentGroup = :establishmentGroup')
  115.             ->setParameter('establishmentGroup', $establishment->getEstablishmentGroup())
  117.             ->andWhere('entity.created_by = :created_by')
  118.             ->setParameter('created_by', $user->getId())
  120.             ->orderBy('entity.id', 'DESC')
  121.             ->getQuery();
  122.         }
  124.         $treasuryCashRegisters = $paginator->paginate($query, $request->query->getInt('page', 1), 10);
  126.         return $this->renderForm('treasury/treasury_cash_register/index.html.twig', [
  127.             'treasury_cash_registers' => $treasuryCashRegisters,
  128.             'treasury_cash_register' => $treasuryCashRegister,
  129.             'treasuryCashRegisterRepository' => $treasuryCashRegisterRepository,
  130.             'form' => $form,
  131.         ]);
  132.     }
  134.     /**
  135.      * @Route("/{id}/show", name="treasury_cash_register_show", methods={"GET", "POST"})
  136.     */
  137.     public function show(Request $request, TreasuryCashRegister $treasuryCashRegister, RegistrationStudentRegistrationRepository $registrationStudentRegistrationRepository, AccountingStudentRegistrationPaymentRepository $accountingStudentRegistrationPaymentRepository, AccountingExpenseRepository $accountingExpenseRepository, UserRepository $userRepository, TreasuryCashRegisterRepository $treasuryCashRegisterRepository, SMSSender $smsSender): Response
  138.     {
  139.         /**@var User $user */
  140.         $user = $this->getUser();
  141.         $schoolYear = $user->getSchoolYear();
  143.         $establishment = $user->getEstablishment();
  144.         $accountingStudentRegistrationPayment = new AccountingStudentRegistrationPayment();
  145.         $registrationStudentRegistrationUnsolds = new ArrayCollection();
  146.         $studentRegistrations = $registrationStudentRegistrationRepository->createQueryBuilder('entity')
  147.         
  148.         ->innerJoin('entity.student', 'student')
  149.         ->addSelect('student')
  150.         
  151.         ->andWhere('entity.establishment = :establishment')
  152.         ->setParameter('establishment', $establishment)
  154.         ->andWhere('entity.schoolYear = :schoolYear')
  155.         ->setParameter('schoolYear', $schoolYear)
  157.         ->andWhere('entity.is_abandonned = :is_abandonned')
  158.         ->setParameter('is_abandonned', 0)
  160.         ->orderBy('entity.id', 'DESC')
  161.         ->getQuery()
  162.         ->getResult();
  164.         foreach ($studentRegistrations as $key => $registrationStudentRegistration) {
  165.             if ($registrationStudentRegistration->getAmountRest() > 0) {
  166.                 $registrationStudentRegistrationUnsolds->add($registrationStudentRegistration);
  167.             }
  168.         }
  170.         /* $parentStudentRegistrations = $registrationStudentRegistrationRepository->createQueryBuilder('entity')
  171.         ->innerJoin('entity.student', 'student')
  172.         ->addSelect('student')
  173.         
  174.         ->innerJoin('entity.establishment', 'establishment')
  175.         ->addSelect('establishment')
  177.         ->innerJoin('establishment.childEstablishments', 'childEstablishment')
  178.         ->addSelect('childEstablishment')
  180.         ->andWhere('childEstablishment.id = :idChild')
  181.         ->setParameter('idChild', $establishment->getId())
  183.         ->andWhere('entity.schoolYear = :schoolYear')
  184.         ->setParameter('schoolYear', $schoolYear)
  186.         ->andWhere('entity.is_abandonned = :is_abandonned')
  187.         ->setParameter('is_abandonned', 0)
  189.         ->orderBy('entity.id', 'DESC')
  190.         ->getQuery()
  191.         ->getResult();
  193.         foreach ($parentStudentRegistrations as $key => $parentStudentRegistration) {
  194.             if ($parentStudentRegistration->getAmountRest() > 0) {
  195.                 if (!$registrationStudentRegistrationUnsolds->contains($parentStudentRegistration)) {
  196.                     $registrationStudentRegistrationUnsolds->add($parentStudentRegistration);
  197.                 }
  198.             }
  199.         } */
  200.         
  201.         $form = $this->createForm(AccountingStudentRegistrationPaymentType::class, $accountingStudentRegistrationPayment)
  202.         ->add('studentRegistration', EntityType::class, [
  203.             'class' => RegistrationStudentRegistration::class,
  204.             'choices' => $registrationStudentRegistrationUnsolds,
  205.             'required' => true
  206.         ]);
  207.         $form->handleRequest($request);
  209.         if ($form->isSubmitted() && $form->isValid()) {
  210.             $entityManager = $this->getDoctrine()->getManager();
  211.             if ($schoolYear == null) {
  212.                 $this->addFlash('warning', "Aucune base de donnée n'est activé.");
  213.                 return $this->redirectToRoute('treasury_cash_register_show', ['id' => $treasuryCashRegister->getId()]);
  214.             }
  216.             if ($accountingStudentRegistrationPayment->getAmount() > ($accountingStudentRegistrationPayment->getStudentRegistration()->getGleAmount() - $accountingStudentRegistrationPayment->getStudentRegistration()->getAmountPaid())) {
  217.                 $this->addFlash('warning', "Le montant du paiement depasse le solde. Veuillez saisir un montant inferieur ou égal au solde.");
  218.                 return $this->redirectToRoute('treasury_cash_register_show', ['id' => $treasuryCashRegister->getId()]);
  219.             }
  221.             $accountingStudentRegistrationPayment->setSchoolYear($schoolYear);
  222.             $accountingStudentRegistrationPayment->setCashRegister($treasuryCashRegister);
  223.             $accountingStudentRegistrationPayment->setEstablishment($accountingStudentRegistrationPayment->getStudentRegistration()->getEstablishment());
  224.             $nextIndex = count($accountingStudentRegistrationPaymentRepository->findBy(['establishment' => $accountingStudentRegistrationPayment->getStudentRegistration()->getEstablishment()], [])) + 1;
  225.             $accountingStudentRegistrationPayment->setCode(date('Y-').$accountingStudentRegistrationPayment->getStudentRegistration()->getEstablishment()->getId().'-'.sprintf("%'05s", $nextIndex));
  226.             $entityManager->persist($accountingStudentRegistrationPayment);
  227.             
  228.             try {
  229.                 $entityManager->flush();
  230.                 $studentRegistration = $accountingStudentRegistrationPayment->getStudentRegistration();
  231.                 $studentRegistration->setLastPaymentAt(new DateTimeImmutable());
  232.                 $studentRegistration->setLastAmountPaid(floatval($request->get('_shedul_payment')));
  233.                 $studentRegistration->setLastPaymentId($accountingStudentRegistrationPayment->getId());
  234.                 $accountingStudentRegistrationPayment->setCode(date('Y-').$accountingStudentRegistrationPayment->getStudentRegistration()->getEstablishment()->getId().'-'.sprintf("%'05s", $accountingStudentRegistrationPayment->getId()));
  235.                 $logOperation = new LogOperation($request->getClientIp(), $accountingStudentRegistrationPayment->getId(), AccountingStudentRegistrationPayment::class, "Création de paiement N°: <strong>".$accountingStudentRegistrationPayment->getCode().", élève : " . $accountingStudentRegistrationPayment->getStudentRegistration()->getStudent()->getCode() . ", montant: ". number_format($accountingStudentRegistrationPayment->getAmount(), 0, ',', ' ') . " </strong>", $this->getUser()->getUserIdentifier(), "primary");
  236.                 $logOperation->setEstablishment($establishment);
  237.                 $entityManager->persist($logOperation);
  238.                 
  239.                 $entityManager->flush();
  240.                 $this->addFlash('success', "Un paiement à été ajouté.");
  241.             } catch (\Throwable $th) {
  242.                 $this->addFlash('warning', "Une erreure est survenue lors de l'ajout du paiement.");
  243.                 $this->addFlash('info', $th->getMessage());
  244.             }
  246.             return $this->redirectToRoute('treasury_cash_register_shedul_payments', ['id' => $accountingStudentRegistrationPayment->getId()]);
  247.         }
  249.         //versements
  250.         $treasuryPayment = new TreasuryPayment();
  251.         $treasuryPayment->setCreateAt(new DateTimeImmutable());
  252.         $treasuryPaymentForm = $this->createForm(TreasuryPaymentType::class, $treasuryPayment);
  253.         $treasuryPaymentForm->handleRequest($request);
  255.         if ($treasuryPaymentForm->isSubmitted() && $treasuryPaymentForm->isValid()) {
  256.             $entityManager = $this->getDoctrine()->getManager();
  258.             /*
  259.              * 20/08/2022
  260.              * si le solde de la caisse est insuffisant pour effectué un versement 
  261.              * le fondateur à demande de désactiver cette option pour permeetre
  262.              * un versement même si le solde est insuffisant
  263.              * 
  264.                 if ($treasuryCashRegister->toForward($treasuryCashRegisterRepository) < $treasuryPayment->getAmount()) {
  265.                     $this->addFlash('warning', "Le solde de la caisse est insuffisant.");
  266.                     return $this->redirectToRoute('treasury_cash_register_show', ['id' => $treasuryCashRegister->getId()]);
  267.                 }
  268.             */ 
  269.             
  270.             $treasuryPayment->setCashRegister($treasuryCashRegister);
  271.             $treasuryPayment->setEstablishment($treasuryCashRegister->getEstablishment());
  272.             $treasuryPayment->setSchoolYear($treasuryCashRegister->getSchoolYear());
  274.             $entityManager->persist($treasuryPayment);
  276.             //notification fondateur
  277.             $foundingNotification = new FoundingNotification();
  278.             $foundingNotification->setCreateDate(new DateTimeImmutable());
  279.             $foundingNotification->setAction("Versement");
  280.             $foundingNotification->setElement("Versement: #".$treasuryCashRegister->getCode());
  281.             $foundingNotification->setDescription("Versement: #".$treasuryCashRegister->getCode().' Mt: '.number_format($treasuryPayment->getAmount(), 0, ',', ' ').' Date: '.$foundingNotification->getCreateDate()->format('d/m/Y'));
  282.             $foundingNotification->setEstablishment($treasuryPayment->getEstablishment());
  283.             $foundingNotification->setIpAddress($request->getClientIp());
  284.             $foundingNotification->setSchoolYear($treasuryPayment->getSchoolYear());
  285.             $foundingNotification->setUsername($this->getUser()->getUserIdentifier());
  286.             $entityManager->persist($foundingNotification);
  287.             /*---------------------------------------------*/
  289.             try {
  290.                 $entityManager->flush();
  291.                 $this->addFlash('success', "Un versement à été ajouté.");
  292.                 $message = "La caissiere ".$treasuryCashRegister->getCheckout()->getLabel()." vient d'effectuer un versement a la banque. Vous etes prie de bien vouloir valider, Montant : ".number_format($treasuryPayment->getAmount(), 0, ',', ' ').' Date: '.$foundingNotification->getCreateDate()->format('d/m/Y');
  293.                 $contacts = [];
  294.                 //$contacts[] = '225'.str_replace(' ', '',trim('0748808080'));
  295.                 //$contacts[] = '225'.str_replace(' ', '',trim('0749565147'));
  296.                 //$contacts[] = '225'.str_replace(' ', '',trim('0757357534'));
  297.                 $contacts[] = '225'.str_replace(' ', '',trim($establishment->getSmsBankPayment()));
  298.                 $response = $smsSender->sendSmsByEstablishment($establishment, $message, $contacts, $smsSender::UNICODE_CHARSET);
  299.             } catch (\Throwable $th) {
  300.                 $this->addFlash('warning', "Une erreure est survenue lors de l'ajout du versement.");
  301.                 $this->addFlash('info', $th->getMessage());
  302.             }
  304.             return $this->redirectToRoute('treasury_cash_register_show', ['id' => $treasuryCashRegister->getId()]);
  305.         }
  307.         // depenses
  308.         $expenses = $accountingExpenseRepository->createQueryBuilder('entity')
  310.         ->innerJoin('entity.establishment', 'establishment')
  311.         ->addSelect('establishment')
  313.         ->andWhere('establishment.establishmentGroup = :establishmentGroup')
  314.         ->setParameter('establishmentGroup', $establishment->getEstablishmentGroup())
  316.         ->andWhere('entity.is_aproved = :is_aproved')
  317.         ->setParameter('is_aproved', 1)
  319.         ->andWhere('entity.is_submited = :is_submited')
  320.         ->setParameter('is_submited', 1)
  322.         /* ->andWhere('entity.is_paid = :is_paid')
  323.         ->setParameter('is_paid', 0) */
  325.         ->andWhere('entity.is_canceled = :is_canceled')
  326.         ->setParameter('is_canceled', 0)
  328.         ->orderBy('entity.id', 'DESC')
  329.         ->getQuery()
  330.         ->getResult();
  331.         
  332.         return $this->renderForm('treasury/treasury_cash_register/show.html.twig', [
  333.             'treasury_cash_register' => $treasuryCashRegister,
  334.             'registrationStudentRegistrationUnsolds' => $registrationStudentRegistrationUnsolds,
  335.             'form' => $form,
  336.             'treasuryPaymentForm' => $treasuryPaymentForm,
  337.             'treasuryPayment' => $treasuryPayment,
  338.             'expenses' => $expenses,
  339.             'userRepository' => $userRepository,
  340.             'treasuryCashRegisterRepository' => $treasuryCashRegisterRepository,
  341.         ]);
  342.     }
  344.     /**
  345.      * @Route("/shedul-payment/{id}", name="treasury_cash_register_shedul_payments", methods={"GET", "POST"})
  346.     */
  347.     public function shedulPayment(Request $request, AccountingStudentRegistrationPayment $accountingStudentRegistrationPayment, AccountingStudentRegistrationFeeShedulRepository $accountingStudentRegistrationFeeShedulRepository): Response
  348.     {
  349.         if ($accountingStudentRegistrationPayment->isPrintable()) {
  350.             return $this->redirectToRoute('treasury_cash_register_shedul_payment_print', ['id' => $accountingStudentRegistrationPayment->getId()]); 
  351.         }
  353.         if ($request->get('_submitting') == $this->getUser()->getUserIdentifier()) {
  354.             if (($accountingStudentRegistrationPayment->getAmount() - $accountingStudentRegistrationPayment->getShedulAmount())  < floatval($request->get('_shedul_payment'))) {
  355.                 $this->addFlash('warning', "Le montant doit être inférieur ou égale au reste à imputer.");
  356.                 return $this->redirectToRoute('treasury_cash_register_shedul_payments', ['id' => $accountingStudentRegistrationPayment->getId()]); 
  357.             }
  358.             
  359.             $accountingStudentRegistrationFeeShedul = $accountingStudentRegistrationFeeShedulRepository->find(intval($request->get('_feeId')));
  360.             if (null == $accountingStudentRegistrationFeeShedul) {
  361.                 $this->addFlash('warning', "L'échéancié que vous souhaitez payer n'existe pas.");
  362.                 return $this->redirectToRoute('treasury_cash_register_shedul_payments', ['id' => $accountingStudentRegistrationPayment->getId()]); 
  363.             }
  365.             $accountingStudentRegistrationFee = $accountingStudentRegistrationFeeShedul->getStudentRegistrationFee();
  366.             $studentRegistration = $accountingStudentRegistrationPayment->getStudentRegistration();
  367.             
  368.             if (floatval($request->get('_shedul_payment')) > 0) {
  369.                 if(floatval($request->get('_shedul_payment')) <= $accountingStudentRegistrationFeeShedul->getAmountRest()){
  370.                     $accountingStudentRegistrationFeeShedulPayment = new AccountingStudentRegistrationFeeShedulPayment();
  371.                     $accountingStudentRegistrationFeeShedulPayment->setCode('PE-'.$accountingStudentRegistrationPayment->getId().'-'.time());
  372.                     $accountingStudentRegistrationFeeShedulPayment->setLabel('PE-'.$accountingStudentRegistrationPayment->getId().'-'.time());
  373.                     $accountingStudentRegistrationFeeShedulPayment->setAmount(floatval($request->get('_shedul_payment')));
  374.                     $accountingStudentRegistrationFeeShedulPayment->setCashRegister($accountingStudentRegistrationPayment->getCashRegister());
  375.                     $accountingStudentRegistrationFeeShedulPayment->setEstablishment($accountingStudentRegistrationPayment->getEstablishment());
  376.                     $accountingStudentRegistrationFeeShedulPayment->setStudentRegistrationFeeShedul($accountingStudentRegistrationFeeShedul);
  377.                     $accountingStudentRegistrationFeeShedulPayment->setStudentRegistrationFee($accountingStudentRegistrationFee);
  378.                     $accountingStudentRegistrationFeeShedulPayment->setStudentRegistrationPayment($accountingStudentRegistrationPayment);
  379.                     $accountingStudentRegistrationFeeShedulPayment->setAccountingAccount($accountingStudentRegistrationFee->getFee()->getAccountingAccount());
  380.                     
  381.                     $accountingStudentRegistrationFeeShedul->setAmountPaid($accountingStudentRegistrationFeeShedul->getAmountPaid() + floatval($request->get('_shedul_payment')));
  382.                     $accountingStudentRegistrationFeeShedul->setLastPaymentAt(new DateTimeImmutable());
  383.                     $accountingStudentRegistrationFeeShedul->setLastAmountPaid(floatval($request->get('_shedul_payment')));
  384.                     $accountingStudentRegistrationFeeShedul->setLastPaymentId($accountingStudentRegistrationPayment->getId());
  386.                     $accountingStudentRegistrationFee->setLastPaymentAt(new DateTimeImmutable());
  387.                     $accountingStudentRegistrationFee->setLastAmountPaid(floatval($request->get('_shedul_payment')));
  388.                     $accountingStudentRegistrationFee->setLastPaymentId($accountingStudentRegistrationPayment->getId());
  390.                     $studentRegistration->setLastPaymentAt(new DateTimeImmutable());
  391.                     $studentRegistration->setLastAmountPaid(floatval($request->get('_shedul_payment')));
  392.                     $studentRegistration->setLastPaymentId($accountingStudentRegistrationPayment->getId());
  393.                     
  394.                     $cashMovement = new TreasuryCashMovement();
  395.                     $cashMovement->setAmount(floatval($request->get('_shedul_payment')));
  396.                     $cashMovement->setAccountingStudentRegistrationFeeShedulPayment($accountingStudentRegistrationFeeShedulPayment);
  397.                     $cashMovement->setCashRegister($accountingStudentRegistrationPayment->getCashRegister());
  398.                     $cashMovement->setCode($accountingStudentRegistrationPayment->getId().'-'.time());
  399.                     $cashMovement->setEstablishment($accountingStudentRegistrationPayment->getEstablishment());
  400.                     $cashMovement->setType('in');
  401.                     $cashMovement->setLabel('paiement écheancié'.$accountingStudentRegistrationFeeShedul->getStudentRegistrationFee()->getFee()->getLabel());
  402.                     $cashMovement->setAccountingStudentRegistrationFeeShedulPayment($accountingStudentRegistrationFeeShedulPayment);
  403.                     
  404.                     $entityManager = $this->getDoctrine()->getManager();
  405.                     $entityManager->persist($accountingStudentRegistrationFeeShedulPayment);
  406.                     $entityManager->persist($cashMovement);
  408.                     try {
  409.                         $entityManager->flush();
  410.                         return $this->redirectToRoute('treasury_cash_register_shedul_payments', ['id' => $accountingStudentRegistrationPayment->getId()]); 
  411.                     } catch (\Throwable $th) {
  412.                         $this->addFlash('warning', "Une erreur s'est produite.");
  413.                         $this->addFlash('info', $th->getMessage());
  414.                         return $this->redirectToRoute('treasury_cash_register_shedul_payments', ['id' => $accountingStudentRegistrationPayment->getId()]); 
  415.                     }
  416.                     
  417.                 }else {
  418.                     $this->addFlash('warning', "Le montant doit être inférieur ou égale au reste de l'échéancié.");
  419.                     return $this->redirectToRoute('treasury_cash_register_shedul_payments', ['id' => $accountingStudentRegistrationPayment->getId()]); 
  420.                 }
  421.             }else{
  422.                 $this->addFlash('warning', "Le montant doit être supérieur à zéro(0).");
  423.                 return $this->redirectToRoute('treasury_cash_register_shedul_payments', ['id' => $accountingStudentRegistrationPayment->getId()]); 
  424.             }
  425.         }
  427.         return $this->render('treasury/treasury_cash_register/shedul_payments.html.twig', [
  428.             'accounting_student_registration_payment' => $accountingStudentRegistrationPayment,
  429.             'treasury_cash_register' => $accountingStudentRegistrationPayment->getCashRegister(),
  430.             'student_registration' => $accountingStudentRegistrationPayment->getStudentRegistration(),
  431.             'student_registration_fees' => $accountingStudentRegistrationPayment->getStudentRegistration()->getAccountingStudentRegistrationFees(),
  432.         ]);
  433.     }
  435.     /**
  436.      * @Route("/shedul-payment/{id}/print", name="treasury_cash_register_shedul_payment_print", methods={"GET"})
  437.     */
  438.     public function print(Pdf $knpSnappyPdf, AccountingStudentRegistrationPayment $accountingStudentRegistrationPayment, AccountingStudentRegistrationFeeShedulRepository $accountingStudentRegistrationFeeShedulRepository, UserRepository $userRepository)
  439.     {
  440.         if (!$accountingStudentRegistrationPayment->isPrintable()) {
  441.             $this->addFlash('warning', "Veuillez terminer les imputations avant d'imprimer.");
  442.             return $this->redirectToRoute('treasury_cash_register_shedul_payments', ['id' => $accountingStudentRegistrationPayment->getId()]); 
  443.         }
  445.         $setting = $accountingStudentRegistrationPayment->getEstablishment();
  446.         
  447.         $html = $this->renderView('treasury/treasury_cash_register/print/payment.html.twig', [
  448.             'ref' => sprintf("%'04s", $accountingStudentRegistrationPayment->getId()),
  449.             'accounting_student_registration_payment' => $accountingStudentRegistrationPayment,
  450.             'student_registration' => $accountingStudentRegistrationPayment->getStudentRegistration(),
  451.             'student_registration_fees' => $accountingStudentRegistrationPayment->getStudentRegistration()->getAccountingStudentRegistrationFees(),
  452.             'school_year' => $accountingStudentRegistrationPayment->getSchoolYear(),
  453.             'userRepository' => $userRepository,
  454.             'setting' => $setting,
  455.         ]);
  457.         $file_name = 'RECU_N_'.$accountingStudentRegistrationPayment->getStudentRegistration()->getStudent()->getCode().'_'.$accountingStudentRegistrationPayment->getCode().".pdf";
  459.         $footer = $this->renderView('print/footer.html.twig', ['setting' => $setting]);
  460.         $header = $this->renderView('print/header.html.twig', ['setting' => $setting]);
  461.         
  462.         $options = [
  463.             'orientation' => 'Portrait',
  464.             /*'header-html' => $header
  465.             'footer-html' => $footer*/
  466.         ];
  467.         try {
  468.             $knpSnappyPdf->generateFromHtml($html, $this->getParameter('app.app_directory').'/downloads/cashRegister/' . $file_name, $options, true);
  469.         } catch (\Throwable $th) {
  470.             $this->addFlash('info', "Ce reçu à déjà été imprimé.");
  471.         }
  472.         
  473.         $id = $accountingStudentRegistrationPayment->getCashRegister()->getId();
  475.         return $this->redirectToRoute('preview_payment', [
  476.             'id' => $id,
  477.             'file' => $file_name,
  478.             'dir' => 'cashRegister'
  479.         ]);
  480.     }
  482.     /**
  483.      * @Route("/{id}/edit", name="treasury_cash_register_edit", methods={"GET","POST"})
  484.      */
  485.     public function edit(Request $request, TreasuryCashRegister $treasuryCashRegister): Response
  486.     {
  487.         $form = $this->createForm(TreasuryCashRegisterType::class, $treasuryCashRegister);
  488.         $form->handleRequest($request);
  490.         if ($form->isSubmitted() && $form->isValid()) {
  491.             try {
  492.                 $this->getDoctrine()->getManager()->flush();
  493.                 $this->addFlash('success', "le releve à été édité.");
  494.             } catch (\Throwable $th) {
  495.                 $this->addFlash('warning', "Une erreure est survenue lors de l'édition du releve.");
  496.                 $this->addFlash('info', $th->getMessage());
  497.             }
  499.             return $this->redirectToRoute('treasury_cash_register_index', [], Response::HTTP_SEE_OTHER);
  500.         }
  502.         return $this->renderForm('treasury/treasury_cash_register/edit.html.twig', [
  503.             'treasury_cash_register' => $treasuryCashRegister,
  504.             'form' => $form,
  505.         ]);
  506.     }
  508.     /**
  509.      * @Route("/delete-selection", name="treasury_cash_registers_selected_delete", methods={"GET"})
  510.     */
  511.     public function deleteSelected(Request $request, TreasuryCashRegisterRepository $entityRepository): Response
  512.     {
  513.         $list = $request->get('entities');
  514.         $entityManager = $this->getDoctrine()->getManager();
  515.         $errors = 0;
  516.         foreach ($list as $key => $id) {
  517.             $entity = $entityRepository->findOneBy(['id' => intval($id)], []);
  518.             if ($entity != null) {
  519.                 if (count($entity->getAccountingStudentRegistrationPayments()) <= 0) {
  520.                     $entityManager->remove($entity);
  521.                 }
  522.             }
  523.         }
  525.         try {
  526.             $entityManager->flush();
  527.             $this->addFlash('success', "Traitement effectué");
  528.             return $this->json(['code' => 200, 'message' => "Traitement effectué :)"], 200);
  529.         } catch (\Throwable $th) {
  530.             //$th->getMessage()
  531.             $this->addFlash('warning', $th->getMessage());
  532.         }
  533.         
  534.         $this->addFlash('warning', "Traitement non effectué");
  535.         return $this->json(['code' => 500, 'message' => "Traitement non effectué"], 200);
  536.     }
  538.     /**
  539.      * @Route("/close/{id}", name="treasury_cash_register_close", methods={"GET"})
  540.     */
  541.     public function close(TreasuryCashRegister $entity): Response
  542.     {
  543.         foreach ($entity->getAccountingStudentRegistrationPayments() as $key => $studentRegistrationPayment) {
  544.             if ($studentRegistrationPayment->isCanBeShow()) {
  545.                 return $this->json(['code' => 500, 'message' => "Tous les paiement n'ont pas été traités correctement."], 200);
  546.             }
  547.         }
  548.         $entityManager = $this->getDoctrine()->getManager();
  549.         $entity->setIsClosed(true);
  550.         
  551.         try {
  552.             $entityManager->flush();
  553.             //$this->addFlash('success', "Paiement supprimé");
  554.             return $this->json(['code' => 200, 'message' => "Caisse clôturé :)"], 200);
  555.         } catch (\Throwable $th) {
  556.             $this->addFlash('warning', $th->getMessage());
  557.             return $this->json(['code' => 500, 'message' => "Une erreur s'est produite !)"], 200);
  558.         }
  560.         return $this->json(['code' => 500, 'message' => "Caisse non clôturé"], 200);
  561.     }
  563.     /**
  564.      * @Route("/reOpen/{id}", name="treasury_cash_register_reopen", methods={"GET"})
  565.     */
  566.     public function reOpen(TreasuryCashRegister $entity): Response
  567.     {
  568.         foreach ($entity->getAccountingStudentRegistrationPayments() as $key => $studentRegistrationPayment) {
  569.             if ($studentRegistrationPayment->isCanBeShow()) {
  570.                 return $this->json(['code' => 500, 'message' => "Tous les paiement n'ont pas été traités correctement."], 200);
  571.             }
  572.         }
  573.         
  574.         $entityManager = $this->getDoctrine()->getManager();
  575.         $entity->setIsClosed(false);
  576.         
  577.         try {
  578.             $entityManager->flush();
  579.             //$this->addFlash('success', "Paiement supprimé");
  580.             return $this->json(['code' => 200, 'message' => "Caisse ré-ouverte :)"], 200);
  581.         } catch (\Throwable $th) {
  582.             $this->addFlash('warning', $th->getMessage());
  583.             return $this->json(['code' => 500, 'message' => "Une erreur s'est produite !)"], 200);
  584.         }
  586.         return $this->json(['code' => 500, 'message' => "Caisse non clôturé"], 200);
  587.     }
  589.     /**
  590.      * @Route("/re-print-all/{id}", name="treasury_cash_register_re_print", methods={"GET"})
  591.     */
  592.     public function rePrint(Pdf $knpSnappyPdf, SettingClassroom $settingClassroom, AccountingStudentRegistrationPaymentRepository $accountingStudentRegistrationPaymentRepository, UserRepository $userRepository)
  593.     {
  594.         $accountingStudentRegistrations = $accountingStudentRegistrationPaymentRepository->createQueryBuilder('entity')
  595.         ->innerJoin('entity.studentRegistration', 'studentRegistration')
  596.         ->addSelect('studentRegistration')
  598.         ->andWhere('studentRegistration.classroom = :classroom')
  599.         ->setParameter('classroom', $settingClassroom)
  601.         ->getQuery()
  602.         ->getResult();
  603.         $setting = $this->getUser()->getEstablishment();
  604.         $html = $this->renderView('treasury/treasury_cash_register/print/payments.html.twig', [
  605.             'accounting_student_registration_payments' => $accountingStudentRegistrations,
  606.             'userRepository' => $userRepository,
  607.             'setting' => $this->getUser()->getEstablishment(),
  608.         ]);
  610.         $file_name = "RECUS_".date('dmY_Hi_').".pdf";
  612.         $footer = $this->renderView('print/footer.html.twig', ['setting' => $setting]);
  613.         $header = $this->renderView('print/header.html.twig', ['setting' => $setting]);
  614.         
  615.         $options = [
  616.             'orientation' => 'Portrait',
  617.             'header-html' => $header
  618.             //'footer-html' => $footer
  619.         ];
  621.         return new PdfResponse(
  622.             $knpSnappyPdf->getOutputFromHtml($html, $options),
  623.             $file_name,
  624.             'application/pdf',
  625.             'attachment'
  626.         );
  627.     }
  628. }