src/Controller/Accounting/AccountingExpenseController.php line 35

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'))], []);
  42.         $accounting_expense_category = intval($request->get('accounting_expense_category'));
  43.         $accountingExpenseCategory = $accountingExpenseCategoryRepository->findOneBy(['id' => $accounting_expense_category], []);
  44.         $label = $request->get('label');
  46.         $treasuryCheckouts = $treasuryCheckoutRepository->findByEtsGroup($establishment);
  47.         
  48.         //statistiques
  49.         /* $totalSoumis = $accountingExpenseRepository->getTotalByStatus($establishment, 1, 0, 0, 0);
  50.         $totalAprouve = $accountingExpenseRepository->getTotalByStatus($establishment, 0, 1, 0, 0);
  51.         $totalCanceled = $accountingExpenseRepository->getTotalByStatus($establishment, 0, 0, 1, 0);
  52.         $totalPaid = $accountingExpenseRepository->getTotalByStatus($establishment, 0, 0, 0, 1); */
  53.         
  54.         return $this->render('accounting/accounting_expense/index.html.twig', [
  55.             'userRepository' => $userRepository,
  56.             'createdBy' => $userRepository->findOneBy(['id' => $createdBy], []),
  58.             'checkouts' => $treasuryCheckouts,
  59.             'accounting_expense_categories' => $accountingExpenseCategoryRepository->findBy([], ['name' => 'ASC']),
  61.             /* 'totalSoumis' => $totalSoumis,
  62.             'totalAprouve' => $totalAprouve,
  63.             'totalPaid' => $totalPaid,
  64.             'totalCanceled' => $totalCanceled, */
  66.             'startDate' => $request->get('startDate'),
  67.             'endDate' => $request->get('endDate'),
  68.             'checkout' => $checkout,
  69.             'accountingExpenseCategory' => $accountingExpenseCategory,
  70.             'label' => $label,
  71.         ]);
  72.     }
  74.     /**
  75.      * @Route("/_searh-table", name="accounting_expense_searh_table", methods={"GET","POST"})
  76.      */
  77.     public function _searh_table(Request $request, AccountingExpenseRepository $accountingExpenseRepository, UserRepository $userRepository, TreasuryCheckoutRepository $treasuryCheckoutRepository, AccountingExpenseCategoryRepository $accountingExpenseCategoryRepository): Response
  78.     {
  79.         /**@var User $user */
  80.         $user = $this->getUser();
  82.         $establishment = $this->getUser()->getEstablishment();
  83.         $schoolYear = $user->getSchoolYear();
  85.         $createdBy = intval($request->get('createdBy'));
  86.         $startDate = $request->get('startDate');
  87.         $endDate = $request->get('endDate');
  88.         $checkout = $treasuryCheckoutRepository->findOneBy(['id' => intval($request->get('checkout'))], []);
  89.         $accounting_expense_category = intval($request->get('accounting_expense_category'));
  90.         $accountingExpenseCategory = $accountingExpenseCategoryRepository->findOneBy(['id' => $accounting_expense_category], []);
  91.         $label = $request->get('label');
  93.         $treasuryCheckouts = $treasuryCheckoutRepository->findByEtsGroup($establishment);
  95.         $submited_accounting_expenses = $accountingExpenseRepository->getQueryByStatus($establishment, $createdBy, $checkout, $startDate, $endDate, 1, 0, 0, 0, $accountingExpenseCategory, $label);   
  96.         $aproved_accounting_expenses = $accountingExpenseRepository->getQueryByStatus($establishment, $createdBy, $checkout, $startDate, $endDate, 0, 1, 0, 0, $accountingExpenseCategory, $label);   
  97.         $canceled_accounting_expenses = $accountingExpenseRepository->getQueryByStatus($establishment, $createdBy, $checkout, $startDate, $endDate, 0, 0, 1, 0, $accountingExpenseCategory, $label);   
  98.         $paid_accounting_expenses = $accountingExpenseRepository->getQueryByStatus($establishment, $createdBy, $checkout, $startDate, $endDate, 0, 0, 0, 1, $accountingExpenseCategory, $label);   
  99.         //dd($submited_accounting_expenses);
  100.         $accounting_expenses = new ArrayCollection();
  102.         foreach ($submited_accounting_expenses as $key => $submited_accounting_expense) {
  103.             $accounting_expenses->add($submited_accounting_expense);
  104.         }
  106.         foreach ($aproved_accounting_expenses as $key => $aproved_accounting_expense) {
  107.             $accounting_expenses->add($aproved_accounting_expense);
  108.         }
  110.         foreach ($paid_accounting_expenses as $key => $paid_accounting_expense) {
  111.             $accounting_expenses->add($paid_accounting_expense);
  112.         }
  114.         foreach ($canceled_accounting_expenses as $key => $canceled_accounting_expense) {
  115.             $accounting_expenses->add($canceled_accounting_expense);
  116.         }
  117.         
  118.         //statistiques
  119.         $totalSoumis = $accountingExpenseRepository->getTotalByStatus($establishment, 1, 0, 0, 0);
  120.         $totalAprouve = $accountingExpenseRepository->getTotalByStatus($establishment, 0, 1, 0, 0);
  121.         $totalCanceled = $accountingExpenseRepository->getTotalByStatus($establishment, 0, 0, 1, 0);
  122.         $totalPaid = $accountingExpenseRepository->getTotalByStatus($establishment, 0, 0, 0, 1);
  124.         return $this->renderForm('accounting/accounting_expense/_searh_table.html.twig', [
  125.             'accounting_expenses' => $accounting_expenses,
  126.             'accounting_expenses' => $accounting_expenses,
  127.             'userRepository' => $userRepository,
  128.             'createdBy' => $userRepository->findOneBy(['id' => $createdBy], []),
  130.             'checkouts' => $treasuryCheckouts,
  131.             'accounting_expense_categories' => $accountingExpenseCategoryRepository->findBy([], ['name' => 'ASC']),
  133.             'totalSoumis' => $totalSoumis,
  134.             'totalAprouve' => $totalAprouve,
  135.             'totalPaid' => $totalPaid,
  136.             'totalCanceled' => $totalCanceled,
  138.             'startDate' => $request->get('startDate'),
  139.             'endDate' => $request->get('endDate'),
  140.             'checkout' => $checkout,
  141.             'accountingExpenseCategory' => $accountingExpenseCategory,
  142.             'label' => $label,
  143.         ]);
  144.     }
  146.     /**
  147.      * @Route("/_searh-statistiques", name="accounting_expense_searh_statistiques", methods={"GET","POST"})
  148.      */
  149.     public function _searh_statistiques(AccountingExpenseRepository $accountingExpenseRepository, UserRepository $userRepository, TreasuryCheckoutRepository $treasuryCheckoutRepository): Response
  150.     {
  151.         /**@var User $user */
  152.         $user = $this->getUser();
  153.         $establishment = $user->getEstablishment();
  154.         //statistiques
  155.         $totalSoumis = $accountingExpenseRepository->getTotalByStatus($establishment, 1, 0, 0, 0);
  156.         $totalAprouve = $accountingExpenseRepository->getTotalByStatus($establishment, 0, 1, 0, 0);
  157.         $totalCanceled = $accountingExpenseRepository->getTotalByStatus($establishment, 0, 0, 1, 0);
  158.         $totalPaid = $accountingExpenseRepository->getTotalByStatus($establishment, 0, 0, 0, 1);
  160.         return $this->renderForm('accounting/accounting_expense/_searh_statistiques.html.twig', [
  162.             'totalSoumis' => $totalSoumis,
  163.             'totalAprouve' => $totalAprouve,
  164.             'totalPaid' => $totalPaid,
  165.             'totalCanceled' => $totalCanceled,
  166.         ]);
  167.     }
  169.     /**
  170.      * @Route("/aproved", name="accounting_expense_aproved", methods={"GET"})
  171.     */
  172.     public function aproved(Request $request, PaginatorInterface $paginator, AccountingExpenseRepository $accountingExpenseRepository, UserRepository $userRepository, TreasuryCheckoutRepository $treasuryCheckoutRepository, AccountingExpenseCategoryRepository $accountingExpenseCategoryRepository): Response
  173.     {
  174.         /**@var User $user */
  175.         $user = $this->getUser();
  176.         $establishment = $user->getEstablishment();
  178.         $startDate = $request->get('startDate');
  179.         $endDate = $request->get('endDate');
  181.         $treasuryCheckout = $treasuryCheckoutRepository->findOneBy(['id' => $request->get('checkout')], []);
  182.         $treasuryCheckouts = $treasuryCheckoutRepository->findByEtsGroup($establishment);
  183.         
  184.         $accounting_expense_category = intval($request->get('accounting_expense_category'));
  185.         $accountingExpenseCategory = $accountingExpenseCategoryRepository->findOneBy(['id' => $accounting_expense_category], []);
  186.         $label = $request->get('label');
  187.   
  188.         $aproved_accounting_expenses = $accountingExpenseRepository->getQueryByStatus($establishment, 0, $treasuryCheckout, $startDate, $endDate, 0, 1, 0, 0, null, null);   
  189.         $paid_accounting_expenses = $accountingExpenseRepository->getQueryByStatus($establishment, 0, $treasuryCheckout, $startDate, $endDate, 0, 0, 0, 1, null, null);   
  190.         $accounting_expenses = new ArrayCollection();
  191.         
  192.         foreach ($aproved_accounting_expenses as $key => $aproved_accounting_expense) {
  193.             $accounting_expenses->add($aproved_accounting_expense);
  194.         }
  196.         foreach ($paid_accounting_expenses as $key => $paid_accounting_expense) {
  197.             $accounting_expenses->add($paid_accounting_expense);
  198.         }
  199.         //statistiques
  201.         $totalAprouve = $accountingExpenseRepository->getTotalByStatus($establishment, 0, 1, 0, 0);
  202.         $totalPaid = $accountingExpenseRepository->getTotalByStatus($establishment, 0, 0, 0, 1);
  203.         
  204.         return $this->render('accounting/accounting_expense/aproved.html.twig', [
  205.             'accounting_expenses' => $accounting_expenses,
  206.             'userRepository' => $userRepository,
  208.             'totalAprouve' => ($totalAprouve + $totalPaid),
  209.             'totalPaid' => $totalPaid,
  211.             'checkouts' => $treasuryCheckouts,
  212.             'accounting_expense_categories' => $accountingExpenseCategoryRepository->findBy([], ['name' => 'ASC']),
  214.             'startDate' => $request->get('startDate'),
  215.             'endDate' => $request->get('endDate'),
  216.             'checkout' => $treasuryCheckout,
  217.             'accountingExpenseCategory' => $accountingExpenseCategory,
  218.             'label' => $label,
  219.         ]);
  220.     }
  222.     /**
  223.      * @Route("/paids", name="accounting_expense_paids", methods={"GET"})
  224.     */
  225.     public function paids(Request $request, PaginatorInterface $paginator, AccountingExpenseRepository $accountingExpenseRepository, UserRepository $userRepository, TreasuryCheckoutRepository $treasuryCheckoutRepository, AccountingExpenseCategoryRepository $accountingExpenseCategoryRepository): Response
  226.     {
  227.         /**@var User $user */
  228.         $user = $this->getUser();
  229.         $establishment = $user->getEstablishment();
  231.         $startDate = $request->get('startDate');
  232.         $endDate = $request->get('endDate');
  234.         $treasuryCheckout = $treasuryCheckoutRepository->findOneBy(['id' => $request->get('checkout')], []);
  235.         $treasuryCheckouts = $treasuryCheckoutRepository->findByEtsGroup($establishment);
  237.         $accounting_expense_category = intval($request->get('accounting_expense_category'));
  238.         $accountingExpenseCategory = $accountingExpenseCategoryRepository->findOneBy(['id' => $accounting_expense_category], []);
  239.         $label = $request->get('label');
  240.   
  241.         $paid_accounting_expenses = $accountingExpenseRepository->getQueryByStatus($establishment, 0, $treasuryCheckout, $startDate, $endDate, 0, 0, 0, 1, $accountingExpenseCategory, $label);   
  242.         $accounting_expenses = new ArrayCollection();
  244.         foreach ($paid_accounting_expenses as $key => $paid_accounting_expense) {
  245.             $accounting_expenses->add($paid_accounting_expense);
  246.         }
  247.         
  248.         return $this->render('accounting/accounting_expense/paid.html.twig', [
  249.             'accounting_expenses' => $accounting_expenses,
  250.             'checkouts' => $treasuryCheckouts,
  251.             'accounting_expense_categories' => $accountingExpenseCategoryRepository->findBy([], ['name' => 'ASC']),
  252.             'userRepository' => $userRepository,
  254.             'startDate' => $request->get('startDate'),
  255.             'endDate' => $request->get('endDate'),
  256.             'checkout' => $treasuryCheckout,
  257.             'accountingExpenseCategory' => $accountingExpenseCategory,
  258.             'label' => $label,
  259.         ]);
  260.     }
  262.     /**
  263.      * @Route("/canceleds", name="accounting_expense_canceleds", methods={"GET"})
  264.     */
  265.     public function canceleds(Request $request, PaginatorInterface $paginator, AccountingExpenseRepository $accountingExpenseRepository, UserRepository $userRepository, TreasuryCheckoutRepository $treasuryCheckoutRepository, AccountingExpenseCategoryRepository $accountingExpenseCategoryRepository): Response
  266.     {
  267.         /**@var User $user */
  268.         $user = $this->getUser();
  269.         $establishment = $user->getEstablishment();
  271.         $startDate = $request->get('startDate');
  272.         $endDate = $request->get('endDate');
  274.         $treasuryCheckout = $treasuryCheckoutRepository->findOneBy(['id' => $request->get('checkout')], []);
  275.         $treasuryCheckouts = $treasuryCheckoutRepository->findByEtsGroup($establishment);
  276.         $canceled_accounting_expenses = $accountingExpenseRepository->getQueryByStatus($establishment, 0, $treasuryCheckout, $startDate, $endDate, 0, 0, 1, 0, null, null);   
  277.         //dd($submited_accounting_expenses);
  278.         $accounting_expenses = new ArrayCollection();
  280.         foreach ($canceled_accounting_expenses as $key => $canceled_accounting_expense) {
  281.             $accounting_expenses->add($canceled_accounting_expense);
  282.         }
  283.         
  284.         return $this->render('accounting/accounting_expense/canceled.html.twig', [
  285.             'accounting_expenses' => $accounting_expenses,
  286.             'userRepository' => $userRepository,
  288.             'checkouts' => $treasuryCheckouts,
  289.             'accounting_expense_categories' => $accountingExpenseCategoryRepository->findBy([], ['name' => 'ASC']),
  291.             'startDate' => $request->get('startDate'),
  292.             'endDate' => $request->get('endDate'),
  293.             'checkout' => $treasuryCheckout,
  294.         ]);
  295.     }
  297.     /**
  298.      * @Route("/new", name="accounting_expense_new", methods={"GET","POST"})
  299.     */
  300.     public function new(Request $request, SMSSender $smsSender, TreasuryCheckoutRepository $treasuryCheckoutRepository): Response
  301.     {
  302.         /**@var User $user */
  303.         $user = $this->getUser();
  304.         $schoolYear = $user->getSchoolYear();
  305.         $establishment = $user->getEstablishment();
  307.         $accountingExpense = new AccountingExpense();
  308.         $form = $this->createForm(AccountingExpenseType::class, $accountingExpense)
  309.         ->add('checkout', EntityType::class, [
  310.             'class' => TreasuryCheckout::class,
  311.             'choices' => $treasuryCheckoutRepository->findBy(['created_by' => $user->getId()])
  312.             //'choices' => $treasuryCheckoutRepository->findBy(['schoolYear' => $schoolYear, 'created_by' => $user->getId()])
  313.         ]);
  315.         $form->handleRequest($request);
  317.         if ($form->isSubmitted() && $form->isValid()) {
  318.             if (null == $accountingExpense->getCheckout()) {
  319.                 $this->addFlash('warning', "Veuillez selectionner une caisse SVP.");
  320.                 return $this->redirectToRoute('accounting_expense_new');
  321.             }
  323.             $entityManager = $this->getDoctrine()->getManager();
  324.             $accountingExpense->setEstablishment($establishment);
  325.             $accountingExpense->setSchoolYear($schoolYear);
  326.             $entityManager->persist($accountingExpense);
  327.             try {
  328.                 $entityManager->flush();
  329.                 $this->addFlash('success', "Une dépense à été ajoutée.");
  331.                 $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();
  332.                 $contacts = [];
  333.                 $contacts[] = '225'.str_replace(' ', '',trim($establishment->getSmsBankPayment()));
  334.                 $response = $smsSender->sendSmsByEstablishment($establishment, $message, $contacts, $smsSender::UNICODE_CHARSET);
  335.             } catch (\Throwable $th) {
  336.                 $this->addFlash('warning', "Une erreure est survenue lors de l'ajout de la dépense.");
  337.                 $this->addFlash('info', $th->getMessage());
  338.             }
  340.             return $this->redirectToRoute('accounting_expense_index', [], Response::HTTP_SEE_OTHER);
  341.         }
  343.         return $this->renderForm('accounting/accounting_expense/new.html.twig', [
  344.             'accounting_expense' => $accountingExpense,
  345.             'form' => $form,
  346.         ]);
  347.     }
  349.     /**
  350.      * @Route("/{id}/edit", name="accounting_expense_edit", methods={"GET","POST"})
  351.      */
  352.     public function edit(Request $request, AccountingExpense $accountingExpense, UserRepository $userRepository, TreasuryCheckoutRepository $treasuryCheckoutRepository, AccountingExpenseCategoryRepository $accountingExpenseCategoryRepository): Response
  353.     {
  354.         /**@var User $user */
  355.         $user = $this->getUser();
  356.         $schoolYear = $user->getSchoolYear();
  357.         $establishment = $user->getEstablishment();
  359.         $establishment = $this->getUser()->getEstablishment();
  360.         
  361.         $treasuryCheckouts = $treasuryCheckoutRepository->createQueryBuilder('entity')
  362.         ->innerJoin('entity.establishment', 'establishment')
  363.         ->addSelect('establishment')
  365.         ->andWhere('establishment.establishmentGroup = :establishmentGroup')
  366.         ->setParameter('establishmentGroup', $establishment->getEstablishmentGroup())
  368.         ->orderBy('entity.label', 'ASC')
  369.         ->getQuery()
  370.         ->getResult();
  372.         $form = $this->createForm(AccountingExpenseType::class, $accountingExpense)
  373.         ->add('checkout', EntityType::class, [
  374.             'class' => TreasuryCheckout::class,
  375.             'choices' => $treasuryCheckoutRepository->findBy(['created_by' => $accountingExpense->getCreatedBy()]),
  376.             'required' => false
  377.         ]);
  378.         $form->handleRequest($request);
  380.         if ($form->isSubmitted() && $form->isValid()) {
  381.             if (null == $accountingExpense->getCheckout()) {
  382.                 $this->addFlash('warning', "Veuillez selectionner une caisse SVP.");
  383.                 return $this->redirectToRoute('accounting_expense_edit', ['id' => $accountingExpense->getId()], Response::HTTP_SEE_OTHER);
  384.             }
  386.             try {
  387.                 $this->getDoctrine()->getManager()->flush();
  388.                 $this->addFlash('success', "la dépense a été éditée.");
  389.             } catch (\Throwable $th) {
  390.                 $this->addFlash('warning', "Une erreure est survenue lors de l'édition de la dépense.");
  391.                 $this->addFlash('info', $th->getMessage());
  392.             }
  394.             return $this->redirectToRoute('accounting_expense_index', [], Response::HTTP_SEE_OTHER);
  395.         }
  397.         return $this->renderForm('accounting/accounting_expense/edit.html.twig', [
  398.             'accounting_expense' => $accountingExpense,
  399.             'form' => $form,
  400.             'userRepository' => $userRepository,
  401.             'treasury_checkouts' => $treasuryCheckouts,
  402.             'accounting_expense_categories' => $accountingExpenseCategoryRepository->findBy([], ['name' => 'ASC']),
  403.         ]);
  404.     }
  406.     /**
  407.      * @Route("/set-category/{id}", name="accounting_expense_set_category", methods={"GET", "POST"})
  408.     */
  409.     public function set_category(Request $request, AccountingExpense $accountingExpense, AccountingExpenseCategoryRepository $accountingExpenseCategoryRepository): Response
  410.     {
  411.         /**@var User $user */
  412.         $user = $this->getUser();
  413.         $establishment = $user->getEstablishment();
  415.         $accounting_expense_category = intval($request->request->get('accounting_expense_category'));
  416.         $accountingExpenseCategory = $accountingExpenseCategoryRepository->findOneBy(['id' => $accounting_expense_category], []);
  417.         if (null == $accountingExpenseCategory) {
  418.             $this->addFlash('warning', "Veuillez selectionner une catégorie SVP.");
  419.             return $this->redirectToRoute('accounting_expense_edit', ['id' => $accountingExpense->getId()]);
  420.         }
  422.         $accountingExpense->setAccountingExpenseCategory($accountingExpenseCategory);
  423.         $entityManager = $this->getDoctrine()->getManager();
  425.         try {
  426.             $entityManager->flush();
  427.             $this->addFlash('success', "Traitement effectué");
  428.             
  429.         } catch (\Throwable $th) {
  430.             //$th->getMessage()
  431.             $this->addFlash('warning', $th->getMessage());
  432.         }
  434.         return $this->redirectToRoute('accounting_expense_edit', ['id' => $accountingExpense->getId()]);
  435.     }
  437.     /**
  438.      * @Route("/aprove/{id}", name="accounting_expense_aprove", methods={"POST", "GET"})
  439.     */
  440.     public function aprove(Request $request, AccountingExpense $entity, SMSSender $smsSender, TreasuryCheckoutRepository $treasuryCheckoutRepository): Response
  441.     {
  442.         /*$idCheckout = intval($request->request->get('checkout'));
  443.         $checkout = $treasuryCheckoutRepository->findOneBy(['id' => $idCheckout], []);*/
  445.         if (null == $entity->getCheckout()) {
  446.             $this->addFlash('warning', "Aucune caisse n'est associé à cette dépense.");
  447.             return $this->json(['code' => 500, 'message' => "Aucune caisse n'est associé à cette dépense."], 200);
  448.         }
  450.         $establishment = $this->getUser()->getEstablishment();
  451.         $entityManager = $this->getDoctrine()->getManager();
  452.         $entity->setIsAproved(true);
  453.         $entity->setAprovedBy($this->getUser()->getId());
  454.         $entity->setAprovedAt(new DateTimeImmutable());
  455.         $entity->setCheckout($entity->getCheckout());
  456.         //notification fondateur
  457.         $foundingNotification = new FoundingNotification();
  458.         $foundingNotification->setCreateDate(new DateTimeImmutable());
  459.         $foundingNotification->setAction("Approuvé");
  460.         $foundingNotification->setElement("Dépense: #".$entity->getId());
  461.         $foundingNotification->setDescription($entity->getLabel().' Mt: '.number_format($entity->getAmount(), 0, ' ', ',').' Date: '.$entity->getCreatedAt()->format('d/m/Y').' Caisse: '.$entity->getCheckout()->getLabel());
  462.         $foundingNotification->setEstablishment($entity->getEstablishment());
  463.         $foundingNotification->setIpAddress($request->getClientIp());
  464.         $foundingNotification->setSchoolYear($entity->getSchoolYear());
  465.         $foundingNotification->setUsername($this->getUser()->getUserIdentifier());
  466.         $entityManager->persist($foundingNotification);
  467.         /*---------------------------------------------*/
  468.         try {
  469.             $entityManager->flush();
  470.             $this->addFlash('success', "Traitement effectué");
  472.             $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();
  473.             $contacts = [];
  474.             $contacts[] = '225'.str_replace(' ', '',trim($establishment->getSmsBankPayment()));
  475.             $response = $smsSender->sendSmsByEstablishment($establishment, $message, $contacts, $smsSender::UNICODE_CHARSET);
  477.             return $this->json(['code' => 200, 'message' => "Traitement effectué :)"], 200);
  478.             
  479.         } catch (\Throwable $th) {
  480.             //$th->getMessage()
  481.             $this->addFlash('warning', $th->getMessage());
  482.             return $this->json(['code' => 500, 'message' => $th->getMessage()], 200);
  483.         }
  484.         
  485.         //$this->addFlash('warning', "Traitement non effectué");
  486.         return $this->json(['code' => 500, 'message' => "Traitement non effectué"], 200);
  487.         //return $this->redirectToRoute('accounting_expense_index');
  488.     }
  490.     /**
  491.      * @Route("/cancel/{id}", name="accounting_expense_cancel", methods={"GET"})
  492.     */
  493.     public function cancel(AccountingExpense $entity): Response
  494.     {
  495.         if ($entity->getCashRegister() != null) {
  496.             return $this->json(['code' => 500, 'message' => "Impossible un paiement à été effectué sur cette dépense."], 200);
  497.         }
  498.         
  499.         $entityManager = $this->getDoctrine()->getManager();
  500.         $entity->setIsAproved(true);
  501.         $entity->setIsCanceled(true);
  502.         $entity->setIsPaid(false);
  503.         $entity->setCheckout(null);
  504.         try {
  505.             $entityManager->flush();
  506.             $this->addFlash('success', "Traitement effectué");
  507.             return $this->json(['code' => 200, 'message' => "Traitement effectué :)"], 200);
  508.         } catch (\Throwable $th) {
  509.             //$th->getMessage()
  510.             $this->addFlash('warning', $th->getMessage());
  511.         }
  512.         
  513.         $this->addFlash('warning', "Traitement non effectué");
  514.         return $this->json(['code' => 500, 'message' => "Traitement non effectué"], 200);
  515.     }
  517.     /**
  518.      * @Route("/paid/{id}/{idCashRegister}", name="accounting_expense_paid", methods={"GET"})
  519.     */
  520.     public function paid(Request $request, AccountingExpense $entity, $idCashRegister, TreasuryCashRegisterRepository $treasuryCashRegisterRepository, SMSSender $smsSender): Response
  521.     {
  522.         $establishment = $this->getUser()->getEstablishment();
  523.         $entityManager = $this->getDoctrine()->getManager();
  524.         $cashRegister = $treasuryCashRegisterRepository->find($idCashRegister);
  525.         
  526.         /*
  527.          * 20/08/2022
  528.          * si le solde de la caisse est insuffisant pour payer la dépense 
  529.          * le fondateur à demande de désactiver cette option pour permeetre
  530.          * une sortir de caisse même si le solde est insuffisant
  531.          * 
  532.             if ($cashRegister->toForward($treasuryCashRegisterRepository) < $entity->getAmount()) {
  533.                 return $this->json(['code' => 500, 'message' => "Le solde de la caisse est insuffisant"], 200);
  534.             } 
  535.         */
  537.         $entity->setIsPaid(true);
  538.         $entity->setCreateDate(new DateTimeImmutable());
  539.         $entity->setCashRegister($cashRegister);
  540.         // mouvement de caisse
  541.         $cashMovement = new TreasuryCashMovement();
  542.         $cashMovement->setAmount($entity->getAmount());
  543.         $cashMovement->setAccountingExpense($entity);
  544.         $cashMovement->setCashRegister($cashRegister);
  545.         $cashMovement->setCode($entity->getId().'-'.time());
  546.         $cashMovement->setEstablishment($entity->getEstablishment());
  547.         $cashMovement->setType('out');
  548.         $cashMovement->setLabel($entity->getLabel());
  549.         $entityManager->persist($cashMovement);
  550.         /*---------------------------------------------*/
  551.         //notification fondateur
  552.         $foundingNotification = new FoundingNotification();
  553.         $foundingNotification->setCreateDate(new DateTimeImmutable());
  554.         $foundingNotification->setAction("Paiement");
  555.         $foundingNotification->setElement("Dépense: #".$entity->getId());
  556.         $foundingNotification->setDescription($entity->getLabel().' Mt: '.number_format($entity->getAmount(), 0, ' ', ',').' Date: '.$entity->getCreatedAt()->format('d/m/Y'));
  557.         $foundingNotification->setEstablishment($entity->getEstablishment());
  558.         $foundingNotification->setIpAddress($request->getClientIp());
  559.         $foundingNotification->setSchoolYear($entity->getSchoolYear());
  560.         $foundingNotification->setUsername($this->getUser()->getUserIdentifier());
  561.         $entityManager->persist($foundingNotification);
  562.         /*---------------------------------------------*/
  563.         try {
  564.             $entityManager->flush();
  565.             $this->addFlash('success', "Traitement effectué");
  567.             $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();
  568.             $contacts = [];
  569.             $contacts[] = '225'.str_replace(' ', '',trim($establishment->getSmsBankPayment()));
  570.             $response = $smsSender->sendSmsByEstablishment($establishment, $message, $contacts, $smsSender::UNICODE_CHARSET);
  572.             return $this->json(['code' => 200, 'message' => "Traitement effectué :)"], 200);
  573.         } catch (\Throwable $th) {
  574.             //$th->getMessage()
  575.             $this->addFlash('warning', $th->getMessage());
  576.         }
  577.         
  578.         $this->addFlash('warning', "Traitement non effectué");
  579.         return $this->json(['code' => 500, 'message' => "Traitement non effectué"], 200);
  580.     }
  582.     /**
  583.      * @Route("/delete-selection", name="accounting_expenses_selected_delete", methods={"GET"})
  584.     */
  585.     public function deleteSelected(Request $request, AccountingExpenseRepository $entityRepository): Response
  586.     {
  587.         $list = $request->get('entities');
  588.         $entityManager = $this->getDoctrine()->getManager();
  589.         $errors = 0;
  590.         foreach ($list as $key => $id) {
  591.             $entity = $entityRepository->findOneBy(['id' => intval($id)], []);
  592.             if ($entity != null) {
  593.                 if (!$entity->getIsAproved()) {
  594.                     $entityManager->remove($entity);
  595.                 }
  596.             }
  597.         }
  599.         try {
  600.             $entityManager->flush();
  601.             $this->addFlash('success', "Traitement effectué");
  602.             return $this->json(['code' => 200, 'message' => "Traitement effectué :)"], 200);
  603.         } catch (\Throwable $th) {
  604.             //$th->getMessage()
  605.             $this->addFlash('warning', $th->getMessage());
  606.         }
  607.         
  608.         $this->addFlash('warning', "Traitement non effectué");
  609.         return $this->json(['code' => 500, 'message' => "Traitement non effectué"], 200);
  610.     }
  612.     /**
  613.      * @Route("/report/print", name="accounting_expense_report_print")
  614.     */
  615.     public function print_report(Pdf $knpSnappyPdf, Request $request, TreasuryCheckoutRepository $treasuryCheckoutRepository, AccountingExpenseRepository $accountingExpenseRepository, UserRepository $userRepository, AccountingExpenseCategoryRepository $accountingExpenseCategoryRepository): Response
  616.     {
  617.         /**@var User $user */
  618.         $user = $this->getUser();
  619.         $schoolYear = $user->getSchoolYear();
  620.         $establishment = $user->getEstablishment();
  622.         $dateStart = new DateTimeImmutable($request->get('dateStart'));
  623.         $dateEnd = new DateTimeImmutable($request->get('dateEnd'));
  625.         $show_state = $request->get('show_state');
  627.         $checkout = $treasuryCheckoutRepository->findOneBy(['id' => intval($request->get('checkout'))], []);
  628.         $accounting_expense_category = intval($request->get('accounting_expense_category'));
  629.         $accountingExpenseCategory = $accountingExpenseCategoryRepository->findOneBy(['id' => $accounting_expense_category], []);
  630.         
  632.         $checkouts = $treasuryCheckoutRepository->findByEtsGroup($establishment);
  633.         $submited_accounting_expenses = $accountingExpenseRepository->getQueryByStatus($establishment, 0, $checkout, $dateStart, $dateEnd, 1, 0, 0, 0, $accountingExpenseCategory, null);   
  634.         $aproved_accounting_expenses = $accountingExpenseRepository->getQueryByStatus($establishment, 0, $checkout, $dateStart, $dateEnd, 0, 1, 0, 0, $accountingExpenseCategory, null);   
  635.         $canceled_accounting_expenses = $accountingExpenseRepository->getQueryByStatus($establishment, 0, $checkout, $dateStart, $dateEnd, 0, 0, 1, 0, $accountingExpenseCategory, null);   
  636.         $paid_accounting_expenses = $accountingExpenseRepository->getQueryByStatus($establishment, 0, $checkout, $dateStart, $dateEnd, 0, 0, 0, 1, $accountingExpenseCategory, null);   
  638.         $accounting_expenses = new ArrayCollection();
  640.         foreach ($submited_accounting_expenses as $key => $submited_accounting_expense) {
  641.             $accounting_expenses->add($submited_accounting_expense);
  642.         }
  644.         foreach ($aproved_accounting_expenses as $key => $aproved_accounting_expense) {
  645.             $accounting_expenses->add($aproved_accounting_expense);
  646.         }
  648.         foreach ($paid_accounting_expenses as $key => $paid_accounting_expense) {
  649.             $accounting_expenses->add($paid_accounting_expense);
  650.         }
  652.         foreach ($canceled_accounting_expenses as $key => $canceled_accounting_expense) {
  653.             $accounting_expenses->add($canceled_accounting_expense);
  654.         }
  656.         $html = $this->renderView('accounting/print/expenses.html.twig', [
  657.             'checkouts' => $checkouts,
  658.             'accounting_expenses' => $accounting_expenses,
  659.             'accountingExpenseCategory' => $accountingExpenseCategory,
  660.             'userRepository' => $userRepository,
  661.             
  662.             'dateStart' => $dateStart,
  663.             'dateEnd' => $dateEnd,
  665.             'checkout' => $checkout,
  666.             'show_state' => $show_state,
  667.             
  668.             'school_year' => $schoolYear,
  669.             'setting' => $establishment,
  670.             'isPaid' => $request->get('isPaid'),
  671.             'isAproved' => $request->get('isAproved'),
  672.             'isSubmited' => $request->get('isSubmited'),
  673.             'isCanceled' => $request->get('isCanceled'),
  674.         ]);
  676.         $file_name = "RAPPORT_DEPENSES_.pdf";
  678.         $footer = $this->renderView('print/footer.html.twig', ['setting' => $establishment]);
  679.         $header = $this->renderView('print/header.html.twig', ['setting' => $establishment]);
  681.         $options = [
  682.             'orientation' => 'Portrait',
  683.             'header-html' => $header,
  684.             'footer-html' => $footer,
  685.             'footer-right' => "Page [page] / [toPage]"
  686.         ];
  687.         
  688.         $knpSnappyPdf->generateFromHtml($html, $this->getParameter('app.app_directory').'/downloads/rapport/' . $file_name, $options, true);
  690.         return $this->redirectToRoute('preview', [
  691.             'file' => $file_name,
  692.             'dir' => 'rapport',
  693.         ]);
  694.     }
  696.     /**
  697.      * @Route("/api/aprove", name="api_accounting_expense_aprove", methods={"GET"})
  698.      * Modifié le 15/04/2024
  699.     */
  700.     public function api_aprove(Request $request, AccountingExpenseRepository $entityRepository, SMSSender $smsSender, TreasuryCheckoutRepository $treasuryCheckoutRepository): Response
  701.     {
  702.         /*$idCheckout = intval($request->get('checkout'));
  703.         $checkout = $treasuryCheckoutRepository->findOneBy(['id' => $idCheckout], []);
  704.         if (null == $checkout) {
  705.             $this->addFlash('warning', "Veuillez selectionner une caisse SVP.");
  706.             return $this->json(['code' => 500, 'message' => "Veuillez selectionner une caisse SVP."], 200);
  707.         }*/
  710.         $establishment = $this->getUser()->getEstablishment();
  711.         $entityManager = $this->getDoctrine()->getManager();
  712.         $list = $request->get('entities');
  713.         $errors = 0;
  714.         $success = 0;
  716.         foreach ($list as $key => $id) {
  717.             $entity = $entityRepository->findOneBy(['id' => intval($id)], []);
  718.             if ($entity != null) {
  719.                 if (null != $entity->getCheckout()) {
  720.                     if (!$entity->getIsAproved()) {
  721.                         $success++;
  722.                         $entity->setIsAproved(true);
  723.                         $entity->setAprovedBy($this->getUser()->getId());
  724.                         $entity->setAprovedAt(new DateTimeImmutable());
  725.                         $entity->setCheckout($entity->getCheckout());
  726.                         //notification fondateur
  727.                         $foundingNotification = new FoundingNotification();
  728.                         $foundingNotification->setCreateDate(new DateTimeImmutable());
  729.                         $foundingNotification->setAction("Approuvé");
  730.                         $foundingNotification->setElement("Dépense: #".$entity->getId());
  731.                         $foundingNotification->setDescription($entity->getLabel().' Mt: '.number_format($entity->getAmount(), 0, ' ', ',').' Date: '.$entity->getCreatedAt()->format('d/m/Y').' Caisse: '.$entity->getCheckout()->getLabel());
  732.                         $foundingNotification->setEstablishment($entity->getEstablishment());
  733.                         $foundingNotification->setIpAddress($request->getClientIp());
  734.                         $foundingNotification->setSchoolYear($entity->getSchoolYear());
  735.                         $foundingNotification->setUsername($this->getUser()->getUserIdentifier());
  736.                         $entityManager->persist($foundingNotification);
  738.                         try {
  739.                             $entityManager->flush();
  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);
  744.                             
  745.                         } catch (\Throwable $th) {
  746.                             //$th->getMessage()
  747.                             $this->addFlash('warning', $th->getMessage());
  748.                         }
  749.                     }else {
  750.                         $errors++;
  751.                     }
  752.                 }else {
  753.                     $errors++;
  754.                 }
  755.             }
  756.         }
  757.         
  758.         /*---------------------------------------------*/
  759.         try {
  760.             $entityManager->flush();
  761.             $this->addFlash('success', "Traitement effectué, " . $success . "dépense(s) approuvée(s).");/* 
  763.             $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();
  764.             $contacts = [];
  765.             $contacts[] = '225'.str_replace(' ', '',trim($establishment->getSmsBankPayment()));
  766.             $response = $smsSender->sendSmsByEstablishment($establishment, $message, $contacts, $smsSender::UNICODE_CHARSET); */
  768.             return $this->json(['code' => 200, 'message' => "Traitement effectué :), " . $success . " dépense(s) approuvée(s)."], 200);
  769.             
  770.         } catch (\Throwable $th) {
  771.             //$th->getMessage()
  772.             $this->addFlash('warning', $th->getMessage());
  773.             return $this->json(['code' => 500, 'message' => $th->getMessage()], 200);
  774.         }
  775.         
  776.         //$this->addFlash('warning', "Traitement non effectué");
  777.         return $this->json(['code' => 500, 'message' => "Traitement non effectué"], 200);
  778.         //return $this->redirectToRoute('accounting_expense_index');
  779.     }
  781.     /**
  782.      * @Route("/api/cancel", name="api_accounting_expense_cancel", methods={"GET"})
  783.     */
  784.     public function api_cancel(Request $request, AccountingExpenseRepository $entityRepository): Response
  785.     {
  786.         $establishment = $this->getUser()->getEstablishment();
  787.         $entityManager = $this->getDoctrine()->getManager();
  788.         $list = $request->get('entities');
  789.         $errors = 0;
  790.         $success = 0;
  792.         foreach ($list as $key => $id) {
  793.             $entity = $entityRepository->findOneBy(['id' => intval($id)], []);
  794.             if ($entity != null) {
  795.                 if ($entity->getCashRegister() == null) {
  796.                     if (!$entity->getIsPaid()) {
  797.                         if ($entity->getIsAproved()) {
  798.                             if (!$entity->getIsCanceled()) {
  799.                                 $success++;
  800.                                 $entity->setIsAproved(true);
  801.                                 $entity->setIsCanceled(true);
  802.                                 $entity->setIsPaid(false);
  803.                                 $entity->setCheckout(null);
  804.                             }else {
  805.                                 $errors++;
  806.                             }
  807.                         }else {
  808.                             $errors++;
  809.                         }
  810.                     }else {
  811.                         $errors++;
  812.                     }
  813.                 }else {
  814.                     $errors++;
  815.                 }
  816.             }else {
  817.                 $errors++;
  818.             }
  819.         }
  821.         try {
  822.             $entityManager->flush();
  823.             $this->addFlash('success', $success . " dépense annulée(s)");
  824.             return $this->json(['code' => 200, 'message' => $success . " dépense annulée(s)"], 200);
  825.         } catch (\Throwable $th) {
  826.             //$th->getMessage()
  827.             $this->addFlash('warning', $th->getMessage());
  828.             return $this->json(['code' => 500, 'message' => $th->getMessage()], 200);
  829.         }
  830.         
  831.         $this->addFlash('warning', "Traitement non effectué");
  832.         return $this->json(['code' => 500, 'message' => "Traitement non effectué"], 200);
  833.     }
  835.     /**
  836.      * @Route("/restaure/{id}/{idCheckout}", name="accounting_expense_restaure", methods={"GET", "POST"})
  837.     */
  838.     public function restaure($idCheckout, TreasuryCheckoutRepository $treasuryCheckoutRepository, AccountingExpense $accountingExpense, AccountingExpenseCategoryRepository $accountingExpenseCategoryRepository): Response
  839.     {
  840.         /**@var User $user */
  841.         $user = $this->getUser();
  842.         $treasuryCheckout = $treasuryCheckoutRepository->findOneBy(['id' => $idCheckout], []);
  844.         if (null == $treasuryCheckout) {
  845.             $this->addFlash('warning', "Caisse introuvable!");
  846.             return $this->redirectToRoute('accounting_expense_edit', ['id' => $accountingExpense->getId()]);
  847.         }
  849.         if ($accountingExpense->getCashRegister() != null) {
  850.             $this->addFlash('warning', "cette dépense est déjà payé.");
  851.             return $this->redirectToRoute('accounting_expense_edit', ['id' => $accountingExpense->getId()]);
  852.         }
  854.         $accountingExpense->setIsAproved(true);
  855.         $accountingExpense->setIsCanceled(false);
  856.         $accountingExpense->setIsPaid(false);
  857.         $accountingExpense->setCheckout($treasuryCheckout);
  859.         $entityManager = $this->getDoctrine()->getManager();
  861.         try {
  862.             $entityManager->flush();
  863.             $this->addFlash('success', "Traitement effectué");
  864.             
  865.         } catch (\Throwable $th) {
  866.             //$th->getMessage()
  867.             $this->addFlash('warning', $th->getMessage());
  868.         }
  870.         return $this->redirectToRoute('accounting_expense_edit', ['id' => $accountingExpense->getId()]);
  871.     }
  873.     /**
  874.      * @Route("/api/chart-expense-by-month", name="api_chart_accounting_expense_by_month")
  875.     */
  876.     public function api_chart_expense_by_month(Request $request, AccountingExpenseRepository $accountingExpenseRepository): Response
  877.     {
  878.         /**@var User $user */
  879.         $user = $this->getUser();
  880.         $schoolYear = $user->getSchoolYear();
  881.         $establishment = $user->getEstablishment();
  883.         $year =  $request->get('year');
  884.         //$year =  date('Y');
  886.         $expense_months = [];
  887.         $expense_year = 0;
  889.         $accountingExpenses = $accountingExpenseRepository->createQueryBuilder('entity')
  891.         ->innerJoin('entity.establishment', 'establishment')
  892.         ->addSelect('establishment')
  894.         ->andWhere('establishment.establishmentGroup = :establishmentGroup')
  895.         ->setParameter('establishmentGroup', $establishment->getEstablishmentGroup())
  897.         ->andWhere('entity.is_canceled = :is_canceled')
  898.         ->setParameter('is_canceled', 0)
  900.         ->andWhere('entity.is_paid = :is_paid')
  901.         ->setParameter('is_paid', 1)
  903.         ->andWhere('entity.create_date BETWEEN :startDate AND :endDate')
  904.         ->setParameter('startDate', $year.'-01-01')
  905.         ->setParameter('endDate', $year.'-12-31')
  907.         ->getQuery()
  908.         ->getResult();
  910.         $max = 0;
  912.         for ($i=1; $i <= 12; $i++) { 
  913.             $_year = 0;
  914.             $_months = 0;
  916.             foreach ($accountingExpenses as $key => $accountingExpense) {
  917.                 if ($accountingExpense->getCreateDate()->format('Y-m') == $year.'-'.sprintf("%'02s", $i)) {
  918.                     $_year += $accountingExpense->getAmount();
  919.                     $_months += $accountingExpense->getAmount();
  920.                 }
  921.             }
  923.             if ($_months > $max) {
  924.                 $max = $_months;
  925.             }
  927.             $expense_year += $_year;
  928.             $expense_months[] = intval($_months);
  929.         }
  931.         return $this->json([
  932.             'code' => 200, 
  933.             'message' => "ok", 
  934.             'expense_months' => $expense_months, 
  935.             'expense_year' => intval($expense_year), 
  936.             'max' => intval($max), 
  937.             'interval' => intval($max / 10), 
  938.             'year' => intval($year), 
  939.         ], 200);
  940.     }
  941. }