src/Controller/Accounting/AccountingExpenseController.php line 853

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Accounting;
  5. use Knp\Snappy\Pdf;
  6. use App\Entity\User;
  7. use DateTimeImmutable;
  8. use App\Service\SMSSender;
  9. use App\Entity\AccountingExpense;
  10. use App\Repository\UserRepository;
  11. use App\Entity\FoundingNotification;
  12. use App\Entity\TreasuryCashMovement;
  13. use App\Entity\TreasuryCheckout;
  14. use Knp\Component\Pager\PaginatorInterface;
  15. use Symfony\Component\HttpFoundation\Request;
  16. use App\Form\Accounting\AccountingExpenseType;
  17. use App\Repository\TreasuryCheckoutRepository;
  18. use Symfony\Component\HttpFoundation\Response;
  19. use App\Repository\AccountingExpenseRepository;
  20. use Symfony\Component\Routing\Annotation\Route;
  21. use App\Repository\TreasuryCashRegisterRepository;
  22. use App\Repository\AccountingExpenseCategoryRepository;
  23. use Doctrine\Common\Collections\ArrayCollection;
  24. use Symfony\Bridge\Doctrine\Form\Type\EntityType;
  25. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  27. /**
  28.  * @Route("/accounting/expense")
  29.  */
  30. class AccountingExpenseController extends AbstractController
  31. {
  32.     /**
  33.      * @Route("/index", name="accounting_expense_index", methods={"GET"})
  34.     */
  35.     public function index(Request $request, AccountingExpenseRepository $accountingExpenseRepository, UserRepository $userRepository, TreasuryCheckoutRepository $treasuryCheckoutRepository, AccountingExpenseCategoryRepository $accountingExpenseCategoryRepository): Response
  36.     {
  37.         /**@var User $user */
  38.         $user = $this->getUser();
  39.         $establishment = $user->getEstablishment();
  40.         $createdBy = intval($request->get('createdBy'));
  41.         $checkout = $treasuryCheckoutRepository->findOneBy(['id' => intval($request->get('checkout'))], []);
  43.         $treasuryCheckouts = $treasuryCheckoutRepository->findByEtsGroup($establishment);
  44.         
  45.         //statistiques
  46.         /* $totalSoumis = $accountingExpenseRepository->getTotalByStatus($establishment, 1, 0, 0, 0);
  47.         $totalAprouve = $accountingExpenseRepository->getTotalByStatus($establishment, 0, 1, 0, 0);
  48.         $totalCanceled = $accountingExpenseRepository->getTotalByStatus($establishment, 0, 0, 1, 0);
  49.         $totalPaid = $accountingExpenseRepository->getTotalByStatus($establishment, 0, 0, 0, 1); */
  50.         
  51.         return $this->render('accounting/accounting_expense/index.html.twig', [
  52.             'userRepository' => $userRepository,
  53.             'createdBy' => $userRepository->findOneBy(['id' => $createdBy], []),
  55.             'checkouts' => $treasuryCheckouts,
  56.             'accounting_expense_categories' => $accountingExpenseCategoryRepository->findBy([], ['name' => 'ASC']),
  58.             /* 'totalSoumis' => $totalSoumis,
  59.             'totalAprouve' => $totalAprouve,
  60.             'totalPaid' => $totalPaid,
  61.             'totalCanceled' => $totalCanceled, */
  63.             'startDate' => $request->get('startDate'),
  64.             'endDate' => $request->get('endDate'),
  65.             'checkout' => $checkout,
  66.         ]);
  67.     }
  69.     /**
  70.      * @Route("/_searh-table", name="accounting_expense_searh_table", methods={"GET","POST"})
  71.      */
  72.     public function _searh_table(Request $request, AccountingExpenseRepository $accountingExpenseRepository, UserRepository $userRepository, TreasuryCheckoutRepository $treasuryCheckoutRepository): Response
  73.     {
  74.         /**@var User $user */
  75.         $user = $this->getUser();
  77.         $establishment = $this->getUser()->getEstablishment();
  78.         $schoolYear = $user->getSchoolYear();
  80.         $createdBy = intval($request->get('createdBy'));
  81.         $startDate = $request->get('startDate');
  82.         $endDate = $request->get('endDate');
  83.         $checkout = $treasuryCheckoutRepository->findOneBy(['id' => intval($request->get('checkout'))], []);
  85.         $treasuryCheckouts = $treasuryCheckoutRepository->findByEtsGroup($establishment);
  87.         $submited_accounting_expenses = $accountingExpenseRepository->getQueryByStatus($establishment, $createdBy, $checkout, $startDate, $endDate, 1, 0, 0, 0, null);   
  88.         $aproved_accounting_expenses = $accountingExpenseRepository->getQueryByStatus($establishment, $createdBy, $checkout, $startDate, $endDate, 0, 1, 0, 0, null);   
  89.         $canceled_accounting_expenses = $accountingExpenseRepository->getQueryByStatus($establishment, $createdBy, $checkout, $startDate, $endDate, 0, 0, 1, 0, null);   
  90.         $paid_accounting_expenses = $accountingExpenseRepository->getQueryByStatus($establishment, $createdBy, $checkout, $startDate, $endDate, 0, 0, 0, 1, null);   
  91.         //dd($submited_accounting_expenses);
  92.         $accounting_expenses = new ArrayCollection();
  94.         foreach ($submited_accounting_expenses as $key => $submited_accounting_expense) {
  95.             $accounting_expenses->add($submited_accounting_expense);
  96.         }
  98.         foreach ($aproved_accounting_expenses as $key => $aproved_accounting_expense) {
  99.             $accounting_expenses->add($aproved_accounting_expense);
  100.         }
  102.         foreach ($paid_accounting_expenses as $key => $paid_accounting_expense) {
  103.             $accounting_expenses->add($paid_accounting_expense);
  104.         }
  106.         foreach ($canceled_accounting_expenses as $key => $canceled_accounting_expense) {
  107.             $accounting_expenses->add($canceled_accounting_expense);
  108.         }
  109.         
  110.         //statistiques
  111.         $totalSoumis = $accountingExpenseRepository->getTotalByStatus($establishment, 1, 0, 0, 0);
  112.         $totalAprouve = $accountingExpenseRepository->getTotalByStatus($establishment, 0, 1, 0, 0);
  113.         $totalCanceled = $accountingExpenseRepository->getTotalByStatus($establishment, 0, 0, 1, 0);
  114.         $totalPaid = $accountingExpenseRepository->getTotalByStatus($establishment, 0, 0, 0, 1);
  116.         return $this->renderForm('accounting/accounting_expense/_searh_table.html.twig', [
  117.             'accounting_expenses' => $accounting_expenses,
  118.             'accounting_expenses' => $accounting_expenses,
  119.             'userRepository' => $userRepository,
  120.             'createdBy' => $userRepository->findOneBy(['id' => $createdBy], []),
  122.             'checkouts' => $treasuryCheckouts,
  124.             'totalSoumis' => $totalSoumis,
  125.             'totalAprouve' => $totalAprouve,
  126.             'totalPaid' => $totalPaid,
  127.             'totalCanceled' => $totalCanceled,
  129.             'startDate' => $request->get('startDate'),
  130.             'endDate' => $request->get('endDate'),
  131.             'checkout' => $checkout,
  132.         ]);
  133.     }
  135.     /**
  136.      * @Route("/_searh-statistiques", name="accounting_expense_searh_statistiques", methods={"GET","POST"})
  137.      */
  138.     public function _searh_statistiques(AccountingExpenseRepository $accountingExpenseRepository, UserRepository $userRepository, TreasuryCheckoutRepository $treasuryCheckoutRepository): Response
  139.     {
  140.         /**@var User $user */
  141.         $user = $this->getUser();
  142.         $establishment = $user->getEstablishment();
  143.         //statistiques
  144.         $totalSoumis = $accountingExpenseRepository->getTotalByStatus($establishment, 1, 0, 0, 0);
  145.         $totalAprouve = $accountingExpenseRepository->getTotalByStatus($establishment, 0, 1, 0, 0);
  146.         $totalCanceled = $accountingExpenseRepository->getTotalByStatus($establishment, 0, 0, 1, 0);
  147.         $totalPaid = $accountingExpenseRepository->getTotalByStatus($establishment, 0, 0, 0, 1);
  149.         return $this->renderForm('accounting/accounting_expense/_searh_statistiques.html.twig', [
  151.             'totalSoumis' => $totalSoumis,
  152.             'totalAprouve' => $totalAprouve,
  153.             'totalPaid' => $totalPaid,
  154.             'totalCanceled' => $totalCanceled,
  155.         ]);
  156.     }
  158.     /**
  159.      * @Route("/aproved", name="accounting_expense_aproved", methods={"GET"})
  160.     */
  161.     public function aproved(Request $request, PaginatorInterface $paginator, AccountingExpenseRepository $accountingExpenseRepository, UserRepository $userRepository, TreasuryCheckoutRepository $treasuryCheckoutRepository, AccountingExpenseCategoryRepository $accountingExpenseCategoryRepository): Response
  162.     {
  163.         /**@var User $user */
  164.         $user = $this->getUser();
  165.         $establishment = $user->getEstablishment();
  167.         $startDate = $request->get('startDate');
  168.         $endDate = $request->get('endDate');
  170.         $treasuryCheckout = $treasuryCheckoutRepository->findOneBy(['id' => $request->get('checkout')], []);
  171.         $treasuryCheckouts = $treasuryCheckoutRepository->findByEtsGroup($establishment);
  172.   
  173.         $aproved_accounting_expenses = $accountingExpenseRepository->getQueryByStatus($establishment, 0, $treasuryCheckout, $startDate, $endDate, 0, 1, 0, 0, null);   
  174.         $paid_accounting_expenses = $accountingExpenseRepository->getQueryByStatus($establishment, 0, $treasuryCheckout, $startDate, $endDate, 0, 0, 0, 1, null);   
  175.         $accounting_expenses = new ArrayCollection();
  176.         
  177.         foreach ($aproved_accounting_expenses as $key => $aproved_accounting_expense) {
  178.             $accounting_expenses->add($aproved_accounting_expense);
  179.         }
  181.         foreach ($paid_accounting_expenses as $key => $paid_accounting_expense) {
  182.             $accounting_expenses->add($paid_accounting_expense);
  183.         }
  184.         //statistiques
  186.         $totalAprouve = $accountingExpenseRepository->getTotalByStatus($establishment, 0, 1, 0, 0);
  187.         $totalPaid = $accountingExpenseRepository->getTotalByStatus($establishment, 0, 0, 0, 1);
  188.         
  189.         return $this->render('accounting/accounting_expense/aproved.html.twig', [
  190.             'accounting_expenses' => $accounting_expenses,
  191.             'userRepository' => $userRepository,
  193.             'totalAprouve' => ($totalAprouve + $totalPaid),
  194.             'totalPaid' => $totalPaid,
  196.             'checkouts' => $treasuryCheckouts,
  197.             'accounting_expense_categories' => $accountingExpenseCategoryRepository->findBy([], ['name' => 'ASC']),
  199.             'startDate' => $request->get('startDate'),
  200.             'endDate' => $request->get('endDate'),
  201.             'checkout' => $treasuryCheckout,
  202.         ]);
  203.     }
  205.     /**
  206.      * @Route("/paids", name="accounting_expense_paids", methods={"GET"})
  207.     */
  208.     public function paids(Request $request, PaginatorInterface $paginator, AccountingExpenseRepository $accountingExpenseRepository, UserRepository $userRepository, TreasuryCheckoutRepository $treasuryCheckoutRepository, AccountingExpenseCategoryRepository $accountingExpenseCategoryRepository): Response
  209.     {
  210.         /**@var User $user */
  211.         $user = $this->getUser();
  212.         $establishment = $user->getEstablishment();
  214.         $startDate = $request->get('startDate');
  215.         $endDate = $request->get('endDate');
  217.         $treasuryCheckout = $treasuryCheckoutRepository->findOneBy(['id' => $request->get('checkout')], []);
  218.         $treasuryCheckouts = $treasuryCheckoutRepository->findByEtsGroup($establishment);
  219.   
  220.         $paid_accounting_expenses = $accountingExpenseRepository->getQueryByStatus($establishment, 0, $treasuryCheckout, $startDate, $endDate, 0, 0, 0, 1, null);   
  221.         $accounting_expenses = new ArrayCollection();
  223.         foreach ($paid_accounting_expenses as $key => $paid_accounting_expense) {
  224.             $accounting_expenses->add($paid_accounting_expense);
  225.         }
  226.         
  227.         return $this->render('accounting/accounting_expense/paid.html.twig', [
  228.             'accounting_expenses' => $accounting_expenses,
  229.             'checkouts' => $treasuryCheckouts,
  230.             'accounting_expense_categories' => $accountingExpenseCategoryRepository->findBy([], ['name' => 'ASC']),
  231.             'userRepository' => $userRepository,
  233.             'startDate' => $request->get('startDate'),
  234.             'endDate' => $request->get('endDate'),
  235.             'checkout' => $treasuryCheckout,
  236.         ]);
  237.     }
  239.     /**
  240.      * @Route("/canceleds", name="accounting_expense_canceleds", methods={"GET"})
  241.     */
  242.     public function canceleds(Request $request, PaginatorInterface $paginator, AccountingExpenseRepository $accountingExpenseRepository, UserRepository $userRepository, TreasuryCheckoutRepository $treasuryCheckoutRepository, AccountingExpenseCategoryRepository $accountingExpenseCategoryRepository): Response
  243.     {
  244.         /**@var User $user */
  245.         $user = $this->getUser();
  246.         $establishment = $user->getEstablishment();
  248.         $startDate = $request->get('startDate');
  249.         $endDate = $request->get('endDate');
  251.         $treasuryCheckout = $treasuryCheckoutRepository->findOneBy(['id' => $request->get('checkout')], []);
  252.         $treasuryCheckouts = $treasuryCheckoutRepository->findByEtsGroup($establishment);
  253.         $canceled_accounting_expenses = $accountingExpenseRepository->getQueryByStatus($establishment, 0, $treasuryCheckout, $startDate, $endDate, 0, 0, 1, 0, null);   
  254.         //dd($submited_accounting_expenses);
  255.         $accounting_expenses = new ArrayCollection();
  257.         foreach ($canceled_accounting_expenses as $key => $canceled_accounting_expense) {
  258.             $accounting_expenses->add($canceled_accounting_expense);
  259.         }
  260.         
  261.         return $this->render('accounting/accounting_expense/canceled.html.twig', [
  262.             'accounting_expenses' => $accounting_expenses,
  263.             'userRepository' => $userRepository,
  265.             'checkouts' => $treasuryCheckouts,
  266.             'accounting_expense_categories' => $accountingExpenseCategoryRepository->findBy([], ['name' => 'ASC']),
  268.             'startDate' => $request->get('startDate'),
  269.             'endDate' => $request->get('endDate'),
  270.             'checkout' => $treasuryCheckout,
  271.         ]);
  272.     }
  274.     /**
  275.      * @Route("/new", name="accounting_expense_new", methods={"GET","POST"})
  276.     */
  277.     public function new(Request $request, SMSSender $smsSender, TreasuryCheckoutRepository $treasuryCheckoutRepository): Response
  278.     {
  279.         /**@var User $user */
  280.         $user = $this->getUser();
  281.         $schoolYear = $user->getSchoolYear();
  282.         $establishment = $user->getEstablishment();
  284.         $accountingExpense = new AccountingExpense();
  285.         $form = $this->createForm(AccountingExpenseType::class, $accountingExpense)
  286.         ->add('checkout', EntityType::class, [
  287.             'class' => TreasuryCheckout::class,
  288.             'choices' => $treasuryCheckoutRepository->findBy(['created_by' => $user->getId()])
  289.             //'choices' => $treasuryCheckoutRepository->findBy(['schoolYear' => $schoolYear, 'created_by' => $user->getId()])
  290.         ]);
  292.         $form->handleRequest($request);
  294.         if ($form->isSubmitted() && $form->isValid()) {
  295.             if (null == $accountingExpense->getCheckout()) {
  296.                 $this->addFlash('warning', "Veuillez selectionner une caisse SVP.");
  297.                 return $this->redirectToRoute('accounting_expense_new');
  298.             }
  300.             $entityManager = $this->getDoctrine()->getManager();
  301.             $accountingExpense->setEstablishment($establishment);
  302.             $accountingExpense->setSchoolYear($schoolYear);
  303.             $entityManager->persist($accountingExpense);
  304.             try {
  305.                 $entityManager->flush();
  306.                 $this->addFlash('success', "Une dépense à été ajoutée.");
  308.                 $message = "Nouvelle depense soumise: ".$accountingExpense->getLabel().' '.$accountingExpense->getDescription().", Montant : ".number_format($accountingExpense->getAmount(), 0, ',', ' ').' Date: '.$accountingExpense->getCreateDate()->format('d/m/Y').'. Soumise par: '.$this->getUser()->getUserIdentifier();
  309.                 $contacts = [];
  310.                 $contacts[] = '225'.str_replace(' ', '',trim($establishment->getSmsBankPayment()));
  311.                 $response = $smsSender->sendSmsByEstablishment($establishment, $message, $contacts, $smsSender::UNICODE_CHARSET);
  312.             } catch (\Throwable $th) {
  313.                 $this->addFlash('warning', "Une erreure est survenue lors de l'ajout de la dépense.");
  314.                 $this->addFlash('info', $th->getMessage());
  315.             }
  317.             return $this->redirectToRoute('accounting_expense_index', [], Response::HTTP_SEE_OTHER);
  318.         }
  320.         return $this->renderForm('accounting/accounting_expense/new.html.twig', [
  321.             'accounting_expense' => $accountingExpense,
  322.             'form' => $form,
  323.         ]);
  324.     }
  326.     /**
  327.      * @Route("/{id}/edit", name="accounting_expense_edit", methods={"GET","POST"})
  328.      */
  329.     public function edit(Request $request, AccountingExpense $accountingExpense, UserRepository $userRepository, TreasuryCheckoutRepository $treasuryCheckoutRepository, AccountingExpenseCategoryRepository $accountingExpenseCategoryRepository): Response
  330.     {
  331.         /**@var User $user */
  332.         $user = $this->getUser();
  333.         $schoolYear = $user->getSchoolYear();
  334.         $establishment = $user->getEstablishment();
  336.         $establishment = $this->getUser()->getEstablishment();
  337.         
  338.         $treasuryCheckouts = $treasuryCheckoutRepository->createQueryBuilder('entity')
  339.         ->innerJoin('entity.establishment', 'establishment')
  340.         ->addSelect('establishment')
  342.         ->andWhere('establishment.establishmentGroup = :establishmentGroup')
  343.         ->setParameter('establishmentGroup', $establishment->getEstablishmentGroup())
  345.         ->orderBy('entity.label', 'ASC')
  346.         ->getQuery()
  347.         ->getResult();
  349.         $form = $this->createForm(AccountingExpenseType::class, $accountingExpense)
  350.         ->add('checkout', EntityType::class, [
  351.             'class' => TreasuryCheckout::class,
  352.             'choices' => $treasuryCheckoutRepository->findBy(['created_by' => $accountingExpense->getCreatedBy()]),
  353.             'required' => false
  354.         ]);
  355.         $form->handleRequest($request);
  357.         if ($form->isSubmitted() && $form->isValid()) {
  358.             if (null == $accountingExpense->getCheckout()) {
  359.                 $this->addFlash('warning', "Veuillez selectionner une caisse SVP.");
  360.                 return $this->redirectToRoute('accounting_expense_edit', ['id' => $accountingExpense->getId()], Response::HTTP_SEE_OTHER);
  361.             }
  363.             try {
  364.                 $this->getDoctrine()->getManager()->flush();
  365.                 $this->addFlash('success', "la dépense a été éditée.");
  366.             } catch (\Throwable $th) {
  367.                 $this->addFlash('warning', "Une erreure est survenue lors de l'édition de la dépense.");
  368.                 $this->addFlash('info', $th->getMessage());
  369.             }
  371.             return $this->redirectToRoute('accounting_expense_index', [], Response::HTTP_SEE_OTHER);
  372.         }
  374.         return $this->renderForm('accounting/accounting_expense/edit.html.twig', [
  375.             'accounting_expense' => $accountingExpense,
  376.             'form' => $form,
  377.             'userRepository' => $userRepository,
  378.             'treasury_checkouts' => $treasuryCheckouts,
  379.             'accounting_expense_categories' => $accountingExpenseCategoryRepository->findBy([], ['name' => 'ASC']),
  380.         ]);
  381.     }
  383.     /**
  384.      * @Route("/set-category/{id}", name="accounting_expense_set_category", methods={"GET", "POST"})
  385.     */
  386.     public function set_category(Request $request, AccountingExpense $accountingExpense, AccountingExpenseCategoryRepository $accountingExpenseCategoryRepository): Response
  387.     {
  388.         /**@var User $user */
  389.         $user = $this->getUser();
  390.         $establishment = $user->getEstablishment();
  392.         $accounting_expense_category = intval($request->request->get('accounting_expense_category'));
  393.         $accountingExpenseCategory = $accountingExpenseCategoryRepository->findOneBy(['id' => $accounting_expense_category], []);
  394.         if (null == $accountingExpenseCategory) {
  395.             $this->addFlash('warning', "Veuillez selectionner une catégorie SVP.");
  396.             return $this->redirectToRoute('accounting_expense_edit', ['id' => $accountingExpense->getId()]);
  397.         }
  399.         $accountingExpense->setAccountingExpenseCategory($accountingExpenseCategory);
  400.         $entityManager = $this->getDoctrine()->getManager();
  402.         try {
  403.             $entityManager->flush();
  404.             $this->addFlash('success', "Traitement effectué");
  405.             
  406.         } catch (\Throwable $th) {
  407.             //$th->getMessage()
  408.             $this->addFlash('warning', $th->getMessage());
  409.         }
  411.         return $this->redirectToRoute('accounting_expense_edit', ['id' => $accountingExpense->getId()]);
  412.     }
  414.     /**
  415.      * @Route("/aprove/{id}", name="accounting_expense_aprove", methods={"POST", "GET"})
  416.     */
  417.     public function aprove(Request $request, AccountingExpense $entity, SMSSender $smsSender, TreasuryCheckoutRepository $treasuryCheckoutRepository): Response
  418.     {
  419.         /*$idCheckout = intval($request->request->get('checkout'));
  420.         $checkout = $treasuryCheckoutRepository->findOneBy(['id' => $idCheckout], []);*/
  422.         if (null == $entity->getCheckout()) {
  423.             $this->addFlash('warning', "Aucune caisse n'est associé à cette dépense.");
  424.             return $this->json(['code' => 500, 'message' => "Aucune caisse n'est associé à cette dépense."], 200);
  425.         }
  427.         $establishment = $this->getUser()->getEstablishment();
  428.         $entityManager = $this->getDoctrine()->getManager();
  429.         $entity->setIsAproved(true);
  430.         $entity->setAprovedBy($this->getUser()->getId());
  431.         $entity->setAprovedAt(new DateTimeImmutable());
  432.         $entity->setCheckout($entity->getCheckout());
  433.         //notification fondateur
  434.         $foundingNotification = new FoundingNotification();
  435.         $foundingNotification->setCreateDate(new DateTimeImmutable());
  436.         $foundingNotification->setAction("Approuvé");
  437.         $foundingNotification->setElement("Dépense: #".$entity->getId());
  438.         $foundingNotification->setDescription($entity->getLabel().' Mt: '.number_format($entity->getAmount(), 0, ' ', ',').' Date: '.$entity->getCreatedAt()->format('d/m/Y').' Caisse: '.$entity->getCheckout()->getLabel());
  439.         $foundingNotification->setEstablishment($entity->getEstablishment());
  440.         $foundingNotification->setIpAddress($request->getClientIp());
  441.         $foundingNotification->setSchoolYear($entity->getSchoolYear());
  442.         $foundingNotification->setUsername($this->getUser()->getUserIdentifier());
  443.         $entityManager->persist($foundingNotification);
  444.         /*---------------------------------------------*/
  445.         try {
  446.             $entityManager->flush();
  447.             $this->addFlash('success', "Traitement effectué");
  449.             $message = "Dépense approuvée: ".$entity->getLabel().' '.$entity->getDescription().", Montant : ".number_format($entity->getAmount(), 0, ',', ' ').' Date: '.$entity->getCreateDate()->format('d/m/Y').'. Approuvée par: '.$this->getUser()->getUserIdentifier();
  450.             $contacts = [];
  451.             $contacts[] = '225'.str_replace(' ', '',trim($establishment->getSmsBankPayment()));
  452.             $response = $smsSender->sendSmsByEstablishment($establishment, $message, $contacts, $smsSender::UNICODE_CHARSET);
  454.             return $this->json(['code' => 200, 'message' => "Traitement effectué :)"], 200);
  455.             
  456.         } catch (\Throwable $th) {
  457.             //$th->getMessage()
  458.             $this->addFlash('warning', $th->getMessage());
  459.             return $this->json(['code' => 500, 'message' => $th->getMessage()], 200);
  460.         }
  461.         
  462.         //$this->addFlash('warning', "Traitement non effectué");
  463.         return $this->json(['code' => 500, 'message' => "Traitement non effectué"], 200);
  464.         //return $this->redirectToRoute('accounting_expense_index');
  465.     }
  467.     /**
  468.      * @Route("/cancel/{id}", name="accounting_expense_cancel", methods={"GET"})
  469.     */
  470.     public function cancel(AccountingExpense $entity): Response
  471.     {
  472.         if ($entity->getCashRegister() != null) {
  473.             return $this->json(['code' => 500, 'message' => "Impossible un paiement à été effectué sur cette dépense."], 200);
  474.         }
  475.         
  476.         $entityManager = $this->getDoctrine()->getManager();
  477.         $entity->setIsAproved(true);
  478.         $entity->setIsCanceled(true);
  479.         $entity->setIsPaid(false);
  480.         $entity->setCheckout(null);
  481.         try {
  482.             $entityManager->flush();
  483.             $this->addFlash('success', "Traitement effectué");
  484.             return $this->json(['code' => 200, 'message' => "Traitement effectué :)"], 200);
  485.         } catch (\Throwable $th) {
  486.             //$th->getMessage()
  487.             $this->addFlash('warning', $th->getMessage());
  488.         }
  489.         
  490.         $this->addFlash('warning', "Traitement non effectué");
  491.         return $this->json(['code' => 500, 'message' => "Traitement non effectué"], 200);
  492.     }
  494.     /**
  495.      * @Route("/paid/{id}/{idCashRegister}", name="accounting_expense_paid", methods={"GET"})
  496.     */
  497.     public function paid(Request $request, AccountingExpense $entity, $idCashRegister, TreasuryCashRegisterRepository $treasuryCashRegisterRepository, SMSSender $smsSender): Response
  498.     {
  499.         $establishment = $this->getUser()->getEstablishment();
  500.         $entityManager = $this->getDoctrine()->getManager();
  501.         $cashRegister = $treasuryCashRegisterRepository->find($idCashRegister);
  502.         
  503.         /*
  504.          * 20/08/2022
  505.          * si le solde de la caisse est insuffisant pour payer la dépense 
  506.          * le fondateur à demande de désactiver cette option pour permeetre
  507.          * une sortir de caisse même si le solde est insuffisant
  508.          * 
  509.             if ($cashRegister->toForward($treasuryCashRegisterRepository) < $entity->getAmount()) {
  510.                 return $this->json(['code' => 500, 'message' => "Le solde de la caisse est insuffisant"], 200);
  511.             } 
  512.         */
  514.         $entity->setIsPaid(true);
  515.         $entity->setCreateDate(new DateTimeImmutable());
  516.         $entity->setCashRegister($cashRegister);
  517.         // mouvement de caisse
  518.         $cashMovement = new TreasuryCashMovement();
  519.         $cashMovement->setAmount($entity->getAmount());
  520.         $cashMovement->setAccountingExpense($entity);
  521.         $cashMovement->setCashRegister($cashRegister);
  522.         $cashMovement->setCode($entity->getId().'-'.time());
  523.         $cashMovement->setEstablishment($entity->getEstablishment());
  524.         $cashMovement->setType('out');
  525.         $cashMovement->setLabel($entity->getLabel());
  526.         $entityManager->persist($cashMovement);
  527.         /*---------------------------------------------*/
  528.         //notification fondateur
  529.         $foundingNotification = new FoundingNotification();
  530.         $foundingNotification->setCreateDate(new DateTimeImmutable());
  531.         $foundingNotification->setAction("Paiement");
  532.         $foundingNotification->setElement("Dépense: #".$entity->getId());
  533.         $foundingNotification->setDescription($entity->getLabel().' Mt: '.number_format($entity->getAmount(), 0, ' ', ',').' Date: '.$entity->getCreatedAt()->format('d/m/Y'));
  534.         $foundingNotification->setEstablishment($entity->getEstablishment());
  535.         $foundingNotification->setIpAddress($request->getClientIp());
  536.         $foundingNotification->setSchoolYear($entity->getSchoolYear());
  537.         $foundingNotification->setUsername($this->getUser()->getUserIdentifier());
  538.         $entityManager->persist($foundingNotification);
  539.         /*---------------------------------------------*/
  540.         try {
  541.             $entityManager->flush();
  542.             $this->addFlash('success', "Traitement effectué");
  544.             $message = "Dépense payée: ".$entity->getLabel().' '.$entity->getDescription().", Montant : ".number_format($entity->getAmount(), 0, ',', ' ').' Date: '.$entity->getCreateDate()->format('d/m/Y').'. Payée par: '.$this->getUser()->getUserIdentifier().'. Caisse: '.$cashRegister->getCheckout()->getLabel();
  545.             $contacts = [];
  546.             $contacts[] = '225'.str_replace(' ', '',trim($establishment->getSmsBankPayment()));
  547.             $response = $smsSender->sendSmsByEstablishment($establishment, $message, $contacts, $smsSender::UNICODE_CHARSET);
  549.             return $this->json(['code' => 200, 'message' => "Traitement effectué :)"], 200);
  550.         } catch (\Throwable $th) {
  551.             //$th->getMessage()
  552.             $this->addFlash('warning', $th->getMessage());
  553.         }
  554.         
  555.         $this->addFlash('warning', "Traitement non effectué");
  556.         return $this->json(['code' => 500, 'message' => "Traitement non effectué"], 200);
  557.     }
  559.     /**
  560.      * @Route("/delete-selection", name="accounting_expenses_selected_delete", methods={"GET"})
  561.     */
  562.     public function deleteSelected(Request $request, AccountingExpenseRepository $entityRepository): Response
  563.     {
  564.         $list = $request->get('entities');
  565.         $entityManager = $this->getDoctrine()->getManager();
  566.         $errors = 0;
  567.         foreach ($list as $key => $id) {
  568.             $entity = $entityRepository->findOneBy(['id' => intval($id)], []);
  569.             if ($entity != null) {
  570.                 if (!$entity->getIsAproved()) {
  571.                     $entityManager->remove($entity);
  572.                 }
  573.             }
  574.         }
  576.         try {
  577.             $entityManager->flush();
  578.             $this->addFlash('success', "Traitement effectué");
  579.             return $this->json(['code' => 200, 'message' => "Traitement effectué :)"], 200);
  580.         } catch (\Throwable $th) {
  581.             //$th->getMessage()
  582.             $this->addFlash('warning', $th->getMessage());
  583.         }
  584.         
  585.         $this->addFlash('warning', "Traitement non effectué");
  586.         return $this->json(['code' => 500, 'message' => "Traitement non effectué"], 200);
  587.     }
  589.     /**
  590.      * @Route("/report/print", name="accounting_expense_report_print")
  591.     */
  592.     public function print_report(Pdf $knpSnappyPdf, Request $request, TreasuryCheckoutRepository $treasuryCheckoutRepository, AccountingExpenseRepository $accountingExpenseRepository, UserRepository $userRepository, AccountingExpenseCategoryRepository $accountingExpenseCategoryRepository): Response
  593.     {
  594.         /**@var User $user */
  595.         $user = $this->getUser();
  596.         $schoolYear = $user->getSchoolYear();
  597.         $establishment = $user->getEstablishment();
  599.         $dateStart = new DateTimeImmutable($request->get('dateStart'));
  600.         $dateEnd = new DateTimeImmutable($request->get('dateEnd'));
  602.         $show_state = $request->get('show_state');
  604.         $checkout = $treasuryCheckoutRepository->findOneBy(['id' => intval($request->get('checkout'))], []);
  605.         $accounting_expense_category = intval($request->get('accounting_expense_category'));
  606.         $accountingExpenseCategory = $accountingExpenseCategoryRepository->findOneBy(['id' => $accounting_expense_category], []);
  607.         
  609.         $checkouts = $treasuryCheckoutRepository->findByEtsGroup($establishment);
  610.         $submited_accounting_expenses = $accountingExpenseRepository->getQueryByStatus($establishment, 0, $checkout, $dateStart, $dateEnd, 1, 0, 0, 0, $accountingExpenseCategory);   
  611.         $aproved_accounting_expenses = $accountingExpenseRepository->getQueryByStatus($establishment, 0, $checkout, $dateStart, $dateEnd, 0, 1, 0, 0, $accountingExpenseCategory);   
  612.         $canceled_accounting_expenses = $accountingExpenseRepository->getQueryByStatus($establishment, 0, $checkout, $dateStart, $dateEnd, 0, 0, 1, 0, $accountingExpenseCategory);   
  613.         $paid_accounting_expenses = $accountingExpenseRepository->getQueryByStatus($establishment, 0, $checkout, $dateStart, $dateEnd, 0, 0, 0, 1, $accountingExpenseCategory);   
  615.         $accounting_expenses = new ArrayCollection();
  617.         foreach ($submited_accounting_expenses as $key => $submited_accounting_expense) {
  618.             $accounting_expenses->add($submited_accounting_expense);
  619.         }
  621.         foreach ($aproved_accounting_expenses as $key => $aproved_accounting_expense) {
  622.             $accounting_expenses->add($aproved_accounting_expense);
  623.         }
  625.         foreach ($paid_accounting_expenses as $key => $paid_accounting_expense) {
  626.             $accounting_expenses->add($paid_accounting_expense);
  627.         }
  629.         foreach ($canceled_accounting_expenses as $key => $canceled_accounting_expense) {
  630.             $accounting_expenses->add($canceled_accounting_expense);
  631.         }
  633.         $html = $this->renderView('accounting/print/expenses.html.twig', [
  634.             'checkouts' => $checkouts,
  635.             'accounting_expenses' => $accounting_expenses,
  636.             'accountingExpenseCategory' => $accountingExpenseCategory,
  637.             'userRepository' => $userRepository,
  638.             
  639.             'dateStart' => $dateStart,
  640.             'dateEnd' => $dateEnd,
  642.             'checkout' => $checkout,
  643.             'show_state' => $show_state,
  644.             
  645.             'school_year' => $schoolYear,
  646.             'setting' => $establishment,
  647.             'isPaid' => $request->get('isPaid'),
  648.             'isAproved' => $request->get('isAproved'),
  649.             'isSubmited' => $request->get('isSubmited'),
  650.             'isCanceled' => $request->get('isCanceled'),
  651.         ]);
  653.         $file_name = "RAPPORT_DEPENSES_.pdf";
  655.         $footer = $this->renderView('print/footer.html.twig', ['setting' => $establishment]);
  656.         $header = $this->renderView('print/header.html.twig', ['setting' => $establishment]);
  658.         $options = [
  659.             'orientation' => 'Portrait',
  660.             'header-html' => $header,
  661.             'footer-html' => $footer,
  662.             'footer-right' => "Page [page] / [toPage]"
  663.         ];
  664.         
  665.         $knpSnappyPdf->generateFromHtml($html, $this->getParameter('app.app_directory').'/downloads/rapport/' . $file_name, $options, true);
  667.         return $this->redirectToRoute('preview', [
  668.             'file' => $file_name,
  669.             'dir' => 'rapport',
  670.         ]);
  671.     }
  673.     /**
  674.      * @Route("/api/aprove", name="api_accounting_expense_aprove", methods={"GET"})
  675.      * Modifié le 15/04/2024
  676.     */
  677.     public function api_aprove(Request $request, AccountingExpenseRepository $entityRepository, SMSSender $smsSender, TreasuryCheckoutRepository $treasuryCheckoutRepository): Response
  678.     {
  679.         /*$idCheckout = intval($request->get('checkout'));
  680.         $checkout = $treasuryCheckoutRepository->findOneBy(['id' => $idCheckout], []);
  681.         if (null == $checkout) {
  682.             $this->addFlash('warning', "Veuillez selectionner une caisse SVP.");
  683.             return $this->json(['code' => 500, 'message' => "Veuillez selectionner une caisse SVP."], 200);
  684.         }*/
  687.         $establishment = $this->getUser()->getEstablishment();
  688.         $entityManager = $this->getDoctrine()->getManager();
  689.         $list = $request->get('entities');
  690.         $errors = 0;
  691.         $success = 0;
  693.         foreach ($list as $key => $id) {
  694.             $entity = $entityRepository->findOneBy(['id' => intval($id)], []);
  695.             if ($entity != null) {
  696.                 if (null != $entity->getCheckout()) {
  697.                     if (!$entity->getIsAproved()) {
  698.                         $success++;
  699.                         $entity->setIsAproved(true);
  700.                         $entity->setAprovedBy($this->getUser()->getId());
  701.                         $entity->setAprovedAt(new DateTimeImmutable());
  702.                         $entity->setCheckout($entity->getCheckout());
  703.                         //notification fondateur
  704.                         $foundingNotification = new FoundingNotification();
  705.                         $foundingNotification->setCreateDate(new DateTimeImmutable());
  706.                         $foundingNotification->setAction("Approuvé");
  707.                         $foundingNotification->setElement("Dépense: #".$entity->getId());
  708.                         $foundingNotification->setDescription($entity->getLabel().' Mt: '.number_format($entity->getAmount(), 0, ' ', ',').' Date: '.$entity->getCreatedAt()->format('d/m/Y').' Caisse: '.$entity->getCheckout()->getLabel());
  709.                         $foundingNotification->setEstablishment($entity->getEstablishment());
  710.                         $foundingNotification->setIpAddress($request->getClientIp());
  711.                         $foundingNotification->setSchoolYear($entity->getSchoolYear());
  712.                         $foundingNotification->setUsername($this->getUser()->getUserIdentifier());
  713.                         $entityManager->persist($foundingNotification);
  715.                         try {
  716.                             $entityManager->flush();
  717.                             $message = "Dépense approuvée: ".$entity->getLabel().' '.$entity->getDescription().", Montant : ".number_format($entity->getAmount(), 0, ',', ' ').' Date: '.$entity->getCreateDate()->format('d/m/Y').'. Approuvée par: '.$this->getUser()->getUserIdentifier();
  718.                             $contacts = [];
  719.                             $contacts[] = '225'.str_replace(' ', '',trim($establishment->getSmsBankPayment()));
  720.                             $response = $smsSender->sendSmsByEstablishment($establishment, $message, $contacts, $smsSender::UNICODE_CHARSET);
  721.                             
  722.                         } catch (\Throwable $th) {
  723.                             //$th->getMessage()
  724.                             $this->addFlash('warning', $th->getMessage());
  725.                         }
  726.                     }else {
  727.                         $errors++;
  728.                     }
  729.                 }else {
  730.                     $errors++;
  731.                 }
  732.             }
  733.         }
  734.         
  735.         /*---------------------------------------------*/
  736.         try {
  737.             $entityManager->flush();
  738.             $this->addFlash('success', "Traitement effectué, " . $success . "dépense(s) approuvée(s).");/* 
  740.             $message = "Dépense approuvée: ".$entity->getLabel().' '.$entity->getDescription().", Montant : ".number_format($entity->getAmount(), 0, ',', ' ').' Date: '.$entity->getCreateDate()->format('d/m/Y').'. Approuvée par: '.$this->getUser()->getUserIdentifier();
  741.             $contacts = [];
  742.             $contacts[] = '225'.str_replace(' ', '',trim($establishment->getSmsBankPayment()));
  743.             $response = $smsSender->sendSmsByEstablishment($establishment, $message, $contacts, $smsSender::UNICODE_CHARSET); */
  745.             return $this->json(['code' => 200, 'message' => "Traitement effectué :), " . $success . " dépense(s) approuvée(s)."], 200);
  746.             
  747.         } catch (\Throwable $th) {
  748.             //$th->getMessage()
  749.             $this->addFlash('warning', $th->getMessage());
  750.             return $this->json(['code' => 500, 'message' => $th->getMessage()], 200);
  751.         }
  752.         
  753.         //$this->addFlash('warning', "Traitement non effectué");
  754.         return $this->json(['code' => 500, 'message' => "Traitement non effectué"], 200);
  755.         //return $this->redirectToRoute('accounting_expense_index');
  756.     }
  758.     /**
  759.      * @Route("/api/cancel", name="api_accounting_expense_cancel", methods={"GET"})
  760.     */
  761.     public function api_cancel(Request $request, AccountingExpenseRepository $entityRepository): Response
  762.     {
  763.         $establishment = $this->getUser()->getEstablishment();
  764.         $entityManager = $this->getDoctrine()->getManager();
  765.         $list = $request->get('entities');
  766.         $errors = 0;
  767.         $success = 0;
  769.         foreach ($list as $key => $id) {
  770.             $entity = $entityRepository->findOneBy(['id' => intval($id)], []);
  771.             if ($entity != null) {
  772.                 if ($entity->getCashRegister() == null) {
  773.                     if (!$entity->getIsPaid()) {
  774.                         if ($entity->getIsAproved()) {
  775.                             if (!$entity->getIsCanceled()) {
  776.                                 $success++;
  777.                                 $entity->setIsAproved(true);
  778.                                 $entity->setIsCanceled(true);
  779.                                 $entity->setIsPaid(false);
  780.                                 $entity->setCheckout(null);
  781.                             }else {
  782.                                 $errors++;
  783.                             }
  784.                         }else {
  785.                             $errors++;
  786.                         }
  787.                     }else {
  788.                         $errors++;
  789.                     }
  790.                 }else {
  791.                     $errors++;
  792.                 }
  793.             }else {
  794.                 $errors++;
  795.             }
  796.         }
  798.         try {
  799.             $entityManager->flush();
  800.             $this->addFlash('success', $success . " dépense annulée(s)");
  801.             return $this->json(['code' => 200, 'message' => $success . " dépense annulée(s)"], 200);
  802.         } catch (\Throwable $th) {
  803.             //$th->getMessage()
  804.             $this->addFlash('warning', $th->getMessage());
  805.             return $this->json(['code' => 500, 'message' => $th->getMessage()], 200);
  806.         }
  807.         
  808.         $this->addFlash('warning', "Traitement non effectué");
  809.         return $this->json(['code' => 500, 'message' => "Traitement non effectué"], 200);
  810.     }
  812.     /**
  813.      * @Route("/restaure/{id}/{idCheckout}", name="accounting_expense_restaure", methods={"GET", "POST"})
  814.     */
  815.     public function restaure($idCheckout, TreasuryCheckoutRepository $treasuryCheckoutRepository, AccountingExpense $accountingExpense, AccountingExpenseCategoryRepository $accountingExpenseCategoryRepository): Response
  816.     {
  817.         /**@var User $user */
  818.         $user = $this->getUser();
  819.         $treasuryCheckout = $treasuryCheckoutRepository->findOneBy(['id' => $idCheckout], []);
  821.         if (null == $treasuryCheckout) {
  822.             $this->addFlash('warning', "Caisse introuvable!");
  823.             return $this->redirectToRoute('accounting_expense_edit', ['id' => $accountingExpense->getId()]);
  824.         }
  826.         if ($accountingExpense->getCashRegister() != null) {
  827.             $this->addFlash('warning', "cette dépense est déjà payé.");
  828.             return $this->redirectToRoute('accounting_expense_edit', ['id' => $accountingExpense->getId()]);
  829.         }
  831.         $accountingExpense->setIsAproved(true);
  832.         $accountingExpense->setIsCanceled(false);
  833.         $accountingExpense->setIsPaid(false);
  834.         $accountingExpense->setCheckout($treasuryCheckout);
  836.         $entityManager = $this->getDoctrine()->getManager();
  838.         try {
  839.             $entityManager->flush();
  840.             $this->addFlash('success', "Traitement effectué");
  841.             
  842.         } catch (\Throwable $th) {
  843.             //$th->getMessage()
  844.             $this->addFlash('warning', $th->getMessage());
  845.         }
  847.         return $this->redirectToRoute('accounting_expense_edit', ['id' => $accountingExpense->getId()]);
  848.     }
  850.     /**
  851.      * @Route("/api/chart-expense-by-month", name="api_chart_accounting_expense_by_month")
  852.     */
  853.     public function api_chart_expense_by_month(Request $request, AccountingExpenseRepository $accountingExpenseRepository): Response
  854.     {
  855.         /**@var User $user */
  856.         $user = $this->getUser();
  857.         $schoolYear = $user->getSchoolYear();
  858.         $establishment = $user->getEstablishment();
  860.         $year =  $request->get('year');
  861.         //$year =  date('Y');
  863.         $expense_months = [];
  864.         $expense_year = 0;
  866.         $accountingExpenses = $accountingExpenseRepository->createQueryBuilder('entity')
  868.         ->innerJoin('entity.establishment', 'establishment')
  869.         ->addSelect('establishment')
  871.         ->andWhere('establishment.establishmentGroup = :establishmentGroup')
  872.         ->setParameter('establishmentGroup', $establishment->getEstablishmentGroup())
  874.         ->andWhere('entity.is_canceled = :is_canceled')
  875.         ->setParameter('is_canceled', 0)
  877.         ->andWhere('entity.is_paid = :is_paid')
  878.         ->setParameter('is_paid', 1)
  880.         ->andWhere('entity.create_date BETWEEN :startDate AND :endDate')
  881.         ->setParameter('startDate', $year.'-01-01')
  882.         ->setParameter('endDate', $year.'-12-31')
  884.         ->getQuery()
  885.         ->getResult();
  887.         $max = 0;
  889.         for ($i=1; $i <= 12; $i++) { 
  890.             $_year = 0;
  891.             $_months = 0;
  893.             foreach ($accountingExpenses as $key => $accountingExpense) {
  894.                 if ($accountingExpense->getCreateDate()->format('Y-m') == $year.'-'.sprintf("%'02s", $i)) {
  895.                     $_year += $accountingExpense->getAmount();
  896.                     $_months += $accountingExpense->getAmount();
  897.                 }
  898.             }
  900.             if ($_months > $max) {
  901.                 $max = $_months;
  902.             }
  904.             $expense_year += $_year;
  905.             $expense_months[] = intval($_months);
  906.         }
  908.         return $this->json([
  909.             'code' => 200, 
  910.             'message' => "ok", 
  911.             'expense_months' => $expense_months, 
  912.             'expense_year' => intval($expense_year), 
  913.             'max' => intval($max), 
  914.             'interval' => intval($max / 10), 
  915.             'year' => intval($year), 
  916.         ], 200);
  917.     }
  918. }