src/Controller/Rh/RhPaySlipController.php line 254

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Rh;
  5. use Knp\Snappy\Pdf;
  6. use App\Entity\User;
  7. use App\Entity\RhPaySlip;
  8. use App\Form\Rh\RhPaySlipType;
  9. use App\Entity\RhSalaryPaySlip;
  10. use App\Entity\RhPaySlipTaxableItem;
  11. use App\Entity\RhPaySlipRetainedItem;
  12. use App\Service\SalaryContractManage;
  13. use App\Entity\RhPaySlipNonTaxableItem;
  14. use App\Repository\RhPaySlipRepository;
  15. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  16. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  17. use App\Repository\RhTaxableItemRepository;
  18. use Knp\Component\Pager\PaginatorInterface;
  19. use App\Repository\RhRetainedItemRepository;
  20. use App\Repository\RhSalaryPaySlipRepository;
  21. use App\Repository\SalaryBandScaleRepository;
  22. use Symfony\Component\HttpFoundation\Request;
  23. use App\Repository\RhSalaryContractRepository;
  24. use Symfony\Component\HttpFoundation\Response;
  25. use Symfony\Component\Routing\Annotation\Route;
  26. use Doctrine\Common\Collections\ArrayCollection;
  27. use App\Repository\TaxReductionSheduleRepository;
  28. use App\Repository\RhSalaryCreditShedulRepository;
  29. use Symfony\Component\HttpFoundation\ResponseHeaderBag;
  30. use Knp\Bundle\SnappyBundle\Snappy\Response\PdfResponse;
  31. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  33. /**
  34.  * @Route("/rh/paySlip")
  35.  */
  36. class RhPaySlipController extends AbstractController
  37. {
  38.     public const LABEL_RATE_NOT_PERMANANT = 'RIBNC';
  40.     /**
  41.      * @Route("/index", name="rh_pay_slip_index", methods={"GET"})
  42.      */
  43.     public function index(Request $request, PaginatorInterface $paginator, RhPaySlipRepository $rhPaySlipRepository): Response
  44.     {
  45.         $establishment = $this->getUser()->getEstablishment();
  46.         $rh_pay_slips = $paginator->paginate(
  47.             $rhPaySlipRepository->createQueryBuilder('entity')
  48.             ->andWhere('entity.establishment = :establishment')
  49.             ->setParameter('establishment', $establishment)
  51.             ->orderBy('entity.id', 'desc')
  52.             ->getQuery(),
  53.             $request->query->getInt('page', 1),
  54.             1000
  55.         );
  57.         return $this->render('rh/rh_pay_slip/index.html.twig', [
  58.             'rh_pay_slips' => $rh_pay_slips,
  59.         ]);
  60.     }
  62.     /**
  63.      * @Route("/new", name="rh_pay_slip_new", methods={"GET","POST"})
  64.      */
  65.     public function new(Request $request): Response
  66.     {
  67.         $establishment = $this->getUser()->getEstablishment();
  68.         $rhPaySlip = new RhPaySlip();
  69.         $form = $this->createForm(RhPaySlipType::class, $rhPaySlip);
  70.         $form->handleRequest($request);
  72.         if ($form->isSubmitted() && $form->isValid()) {
  73.             $entityManager = $this->getDoctrine()->getManager();
  74.             $rhPaySlip->setEstablishment($establishment);
  75.             $rhPaySlip->setCode(str_replace(' ', '-', $rhPaySlip->getLabel()." ".$establishment->getId()));
  76.             $rhPaySlip->setDay($rhPaySlip->getDateEnd()->format('Y-m-d'));
  77.             $rhPaySlip->setMonth($rhPaySlip->getDateEnd()->format('Y-m'));
  78.             $rhPaySlip->setYear($rhPaySlip->getDateEnd()->format('Y'));
  79.             $entityManager->persist($rhPaySlip);
  80.             try {
  81.                 $entityManager->flush();
  82.                 $this->addFlash('success', "Enrégistrement effectué.");
  83.             } catch (\Throwable $th) {
  84.                 $this->addFlash('warning', "Enrégistrement non effectué.");
  85.                 $this->addFlash('info', $th->getMessage());
  86.                 return $this->redirectToRoute('rh_pay_slip_new');
  87.             }
  89.             return $this->redirectToRoute('rh_pay_slip_index', [], Response::HTTP_SEE_OTHER);
  90.         }
  92.         return $this->renderForm('rh/rh_pay_slip/new.html.twig', [
  93.             'rh_pay_slip' => $rhPaySlip,
  94.             'form' => $form,
  95.         ]);
  96.     }
  98.     /**
  99.      * @Route("/{id}/show", name="rh_pay_slip_show", methods={"GET"})
  100.      */
  101.     public function show(RhPaySlip $rhPaySlip, RhSalaryPaySlipRepository $rhSalaryPaySlipRepository, TaxReductionSheduleRepository $taxReductionSheduleRepository, SalaryBandScaleRepository $salaryBandScaleRepository): Response
  102.     {
  103.         /**@var User $user */
  104.         $user = $this->getUser();
  105.         $establishment = $user->getEstablishment();
  106.         $schoolYear = $user->getSchoolYear();
  108.         foreach ($rhPaySlip->getRhSalaryPaySlips() as $key => $salaryPaySlip) {
  109.             if (!$salaryPaySlip->getIsValidated()) {
  110.                 $salaryPaySlip->setGrossTotal(0);
  111.                 $salaryPaySlip->setTaxGross(0);
  112.                 $salaryPaySlip->setSocialGross(0);
  114.                 $salaryPaySlip->setPatronalWithholdingTax(0);
  115.                 $salaryPaySlip->setWithholdingTax(0);
  116.                 $salaryPaySlip->setOthersRetained(0);
  118.                 $salaryPaySlip->setGrossTaxable(0);
  120.                 foreach ($salaryPaySlip->getRhPaySlipTaxableItems() as $key => $taxableItem) {
  121.                     $paySlipTaxableItem = SalaryContractManage::setPaySlipTaxableItem($salaryPaySlip->getRhSalaryContract(), $taxableItem, null);
  122.                     $salaryPaySlip->setGrossTaxable($salaryPaySlip->getGrossTaxable() + $paySlipTaxableItem->getProfit());
  123.                     
  124.                     $salaryPaySlip->setGrossTotal($salaryPaySlip->getGrossTotal() + $paySlipTaxableItem->getProfit());
  125.                     $salaryPaySlip->setTaxGross($salaryPaySlip->getTaxGross() + $paySlipTaxableItem->getProfit());
  126.                     $salaryPaySlip->setSocialGross($salaryPaySlip->getSocialGross() + $paySlipTaxableItem->getProfit());
  127.                 }
  128.     
  129.                 foreach ($salaryPaySlip->getRhPaySlipNonTaxableItems() as $key => $nonTaxableItem) {
  130.                     $nonTaxableItem = SalaryContractManage::setPaySlipNonTaxableItem($salaryPaySlip->getRhSalaryContract(), $nonTaxableItem, null);
  131.                     /* le transport n'est pas inclus dans le brut social */
  132.                     if (!str_contains($nonTaxableItem->getLabel(), 'TRANSPORT')) {
  133.                         $salaryPaySlip->setSocialGross($salaryPaySlip->getSocialGross() + $nonTaxableItem->getProfit());
  134.                     }
  135.                     $salaryPaySlip->setGrossTotal($salaryPaySlip->getGrossTotal() + $nonTaxableItem->getProfit());
  136.                 }
  137.     
  138.                 foreach ($salaryPaySlip->getRhPaySlipRetainedItems() as $key => $retainedItem) {
  139.                     if ($retainedItem->getComputeMethod() == 'ITS') {
  140.                         $retainedItem = SalaryContractManage::setITS($salaryPaySlip->getRhSalaryContract(), $salaryPaySlip, $retainedItem, null, $taxReductionSheduleRepository, $salaryBandScaleRepository);
  141.                     }else {
  142.                         $retainedItem = SalaryContractManage::setPaySlipRetainedItem($salaryPaySlip->getRhSalaryContract(), $salaryPaySlip, $retainedItem, null);
  143.                     }
  144.     
  145.                     if ($retainedItem->getPart() == 'SALARIALE') {
  146.                         $salaryPaySlip->setWithholdingTax($salaryPaySlip->getWithholdingTax() + $retainedItem->getProfit());
  147.                     }else {
  148.                         $salaryPaySlip->setPatronalWithholdingTax($salaryPaySlip->getPatronalWithholdingTax() + $retainedItem->getProfit());
  149.                     }
  150.                 }
  152.                 $salaryPaySlip->setNetSalary($salaryPaySlip->getGrossTotal() - ($salaryPaySlip->getWithholdingTax() + $salaryPaySlip->getOthersRetained()));
  154.                 try {
  155.                     $this->getDoctrine()->getManager()->flush();
  156.                 } catch (\Throwable $th) {
  157.                     //$this->addFlash('warning', $this->getParameter('sm.entity_updating_error_message'));
  158.                 }
  159.             }
  160.         }
  162.         $banks = $rhSalaryPaySlipRepository->createQueryBuilder('entity')
  163.         ->andWhere('entity.establishment = :establishment')
  164.         ->setParameter('establishment', $establishment)
  166.         ->andWhere('entity.rhPaySlip = :rhPaySlip')
  167.         ->setParameter('rhPaySlip', $rhPaySlip)
  169.         ->innerJoin('entity.rhSalary', 'rhSalary')
  170.         ->addSelect('rhSalary')
  172.         /* ->andWhere('rhSalary.bank_name = :bank_name')
  173.         ->setParameter('bank_name', $request->get('bankName')) */
  174.         
  175.         ->groupBy('rhSalary.bank_name')
  176.         ->orderBy('rhSalary.last_name', 'ASC')
  177.         ->getQuery()
  178.         ->getResult();
  179.         return $this->render('rh/rh_pay_slip/show.html.twig', [
  180.             'banks' => $banks,
  181.             'rh_pay_slip' => $rhPaySlip,
  182.         ]);
  183.     }
  185.     /**
  186.      * @Route("/{id}/edit", name="rh_pay_slip_edit", methods={"GET","POST"})
  187.      */
  188.     public function edit(Request $request, RhPaySlip $rhPaySlip): Response
  189.     {
  190.         $form = $this->createForm(RhPaySlipType::class, $rhPaySlip);
  191.         $form->handleRequest($request);
  193.         if ($form->isSubmitted() && $form->isValid()) {
  194.             $rhPaySlip->setDay($rhPaySlip->getDateEnd()->format('Y-m-d'));
  195.             $rhPaySlip->setMonth($rhPaySlip->getDateEnd()->format('Y-m'));
  196.             $rhPaySlip->setYear($rhPaySlip->getDateEnd()->format('Y'));
  197.             try {
  198.                 $this->getDoctrine()->getManager()->flush();
  199.                 $this->addFlash('success', "Modification effectuée.");
  200.             } catch (\Throwable $th) {
  201.                 $this->addFlash('warning', "Modification non effectuée.");
  202.             }
  204.             return $this->redirectToRoute('rh_pay_slip_index', [], Response::HTTP_SEE_OTHER);
  205.         }
  207.         return $this->renderForm('rh/rh_pay_slip/edit.html.twig', [
  208.             'rh_pay_slip' => $rhPaySlip,
  209.             'form' => $form,
  210.         ]);
  211.     }
  213.     /**
  214.      * @Route("/delete-selection", name="rh_pay_slips_selected_delete", methods={"GET"})
  215.      */
  216.     public function deleteSelected(Request $request, RhPaySlipRepository $entityRepository): Response
  217.     {
  218.         $list = $request->get('entities');
  219.         $entityManager = $this->getDoctrine()->getManager();
  220.         $errors = 0;
  221.         $success = 0;
  222.         foreach ($list as $key => $id) {
  223.             $entity = $entityRepository->findOneBy(['id' => intval($id)], []);
  224.             if ($entity != null) {
  225.                 if (count($entity->getRhSalaryPaySlips()) <= 0) {
  226.                     $entityManager->remove($entity);
  227.                     $success = $success + 1;
  228.                 }else {
  229.                     $errors = $errors + 1;
  230.                 }
  231.             }
  232.         }
  234.         try {
  235.             $entityManager->flush();
  236.             if ($success > 0) {
  237.                 $this->addFlash('success', "Suppression effectuée.");
  238.             }
  239.             if ($errors > 0) {
  240.                 $this->addFlash('warning', $errors." ligne(s) ne peuvent être supprimés pour l'instant car elles sont liées à d'autres entités.");
  241.             }
  242.             return $this->json(['code' => 200, 'message' => "Suppression effectuée."], 200);
  243.         } catch (\Throwable $th) {
  244.             //$th->getMessage()
  245.         }
  246.         
  247.         $this->addFlash('warning', "Suppression non effectuée.");
  248.         return $this->json(['code' => 500, 'message' => "Suppression non effectuée."], 200);
  249.     }
  251.     /**
  252.      * @Route("/{id}/regenerateSalaryPaySlip", name="rh_pay_slip_regenerate_salary_pay_slip", methods={"GET"})
  253.      */
  254.     public function OnRegenerateSalaryPaySlipClicked(RhPaySlip $paySlip, RhTaxableItemRepository $taxableItemRepository, RhRetainedItemRepository $retainedItemRepository, RhSalaryPaySlipRepository $salaryPaySlipRepository, RhSalaryContractRepository $rhSalaryContractRepository, RhSalaryCreditShedulRepository $rhSalaryCreditShedulRepository, TaxReductionSheduleRepository $taxReductionSheduleRepository, SalaryBandScaleRepository $salaryBandScaleRepository): Response
  255.     {
  256.         $establishment = $this->getUser()->getEstablishment();
  258.         $entityManager = $this->getDoctrine()->getManager();
  259.         $rhSalaryContracts = $rhSalaryContractRepository->createQueryBuilder('entity')
  260.         ->innerJoin('entity.rhSalary', 'rhSalary')
  261.         ->addSelect('rhSalary')
  263.         ->andWhere('entity.is_closed = :is_closed')
  264.         ->setParameter('is_closed', 0)
  266.         ->andWhere('entity.establishment = :establishment')
  267.         ->setParameter('establishment', $establishment)
  269.         ->andWhere('rhSalary.is_permanent = :is_permanent')
  270.         ->setParameter('is_permanent', $paySlip->getIsForPermanent())
  272.         ->orderBy('entity.id', 'DESC')
  273.         ->getQuery()
  274.         ->getResult();
  276.         //dd($rhSalaryContracts);
  278.         foreach ($rhSalaryContracts as $key => $salaryContract) {
  279.             if ($salaryContract->getStartDate() < $paySlip->getDateEnd() && ($salaryContract->getEndDate() == null || $salaryContract->getEndDate() > $paySlip->getDateStart())) {
  280.                 if (null == $salaryPaySlipRepository->findOneBy(['rhPaySlip' => $paySlip, 'rhSalaryContract' => $salaryContract], [])) {
  281.                     //if ($salaryContract->getRhSalary()->getIsPermanent() == $paySlip->getIsForPermanent()) {
  282.                         $salaryPaySlip = new RhSalaryPaySlip();
  283.                         $salaryPaySlip->setRhPaySlip($paySlip);
  284.                         $salaryPaySlip->setRhSalary($salaryContract->getRhSalary());
  285.                         $salaryPaySlip->setLabel($paySlip->getLabel());
  286.                         $salaryPaySlip->setCode($paySlip->getLabel()."-".$salaryContract->getId());
  287.                         $salaryPaySlip->setDay($paySlip->getCreatedAt()->format('Y-m-d'));
  288.                         $salaryPaySlip->setMonth($paySlip->getCreatedAt()->format('Y-m'));
  289.                         $salaryPaySlip->setYear($paySlip->getCreatedAt()->format('Y'));
  290.                         $salaryPaySlip->setEstablishment($paySlip->getEstablishment());
  292.                         $salaryPaySlip->setHourlyRate($salaryContract->getHourlyRate());
  293.                         $salaryPaySlip->setNumberHourPerformed($salaryContract->getHoursWorked());
  295.                         if (!$salaryContract->getRhSalary()->getIsPermanent()) {
  296.                             $salaryPaySlip->setNumberHourPerformed($salaryContract->getWorkingTime($paySlip->getDateStart(), $paySlip->getDateEnd()));
  297.                         }
  298.                         
  299.                         $salaryPaySlip->setRhSalaryContract($salaryContract);
  300.                         $salaryPaySlip->setBaseSalary($salaryPaySlip->getHourlyRate() * $salaryPaySlip->getNumberHourPerformed());
  302.                         $salaryPaySlip->setDay($paySlip->getDateEnd()->format('Y-m-s'));
  303.                         $salaryPaySlip->setMonth($paySlip->getDateEnd()->format('Y-m'));
  304.                         $salaryPaySlip->setYear($paySlip->getDateEnd()->format('Y'));
  306.                         if ($salaryContract->getRhSalary()->getIsPermanent()) {
  307.                             foreach ($taxableItemRepository->findBy([], ['num' => 'ASC']) as $key => $taxableItem) {
  308.                                 $paySlipTaxableItem = new RhPaySlipTaxableItem();
  309.                                 $paySlipTaxableItem->setComputeMethod($taxableItem->getComputeMethod());
  310.                                 $paySlipTaxableItem->setLabel($taxableItem->getLabel());
  311.                                 $paySlipTaxableItem->setCode($taxableItem->getLabel());
  312.                                 $paySlipTaxableItem->setNum($taxableItem->getNum());
  313.                                 $paySlipTaxableItem->setRhSalaryPaySlip($salaryPaySlip);
  314.                                 if (null != $salaryPaySlip->getHourlyRate()) {
  315.                                     $paySlipTaxableItem->setBased($salaryPaySlip->getHourlyRate());
  316.                                 }else {
  317.                                     $paySlipTaxableItem->setBased(0);
  318.                                 }
  319.                                 
  320.                                 if (null != $salaryPaySlip->getNumberHourPerformed()) {
  321.                                     $paySlipTaxableItem->setRate($salaryPaySlip->getNumberHourPerformed());
  322.                                 }else {
  323.                                     $paySlipTaxableItem->setRate(1);
  324.                                 }
  326.                                 $paySlipTaxableItem = SalaryContractManage::setPaySlipTaxableItem($salaryContract, $paySlipTaxableItem, $taxableItem);
  327.                                 
  328.                                 $salaryPaySlip->setGrossTotal($salaryPaySlip->getGrossTotal() + $paySlipTaxableItem->getProfit());
  329.                                 $salaryPaySlip->setTaxGross($salaryPaySlip->getTaxGross() + $paySlipTaxableItem->getProfit());
  330.                                 $salaryPaySlip->setSocialGross($salaryPaySlip->getSocialGross() + $paySlipTaxableItem->getProfit());
  332.                                 $paySlipTaxableItem->setDay($paySlip->getDateEnd()->format('Y-m-s'));
  333.                                 $paySlipTaxableItem->setMonth($paySlip->getDateEnd()->format('Y-m'));
  334.                                 $paySlipTaxableItem->setYear($paySlip->getDateEnd()->format('Y'));
  336.                                 $paySlipTaxableItem->setEstablishment($paySlip->getEstablishment());
  337.                                 
  338.                                 $entityManager->persist($paySlipTaxableItem);
  339.                             }
  340.                         }else {
  341.                             foreach ($taxableItemRepository->findBy([], ['num' => 'ASC']) as $key => $taxableItem) {
  342.                                 if ($taxableItem->getComputeMethod() != 'PRIME ANCIENNETE') {
  343.                                     $paySlipTaxableItem = new RhPaySlipTaxableItem();
  344.                                     $paySlipTaxableItem->setComputeMethod($taxableItem->getComputeMethod());
  345.                                     $paySlipTaxableItem->setLabel($taxableItem->getLabel());
  346.                                     $paySlipTaxableItem->setCode($taxableItem->getLabel());
  347.                                     $paySlipTaxableItem->setNum($taxableItem->getNum());
  348.                                     $paySlipTaxableItem->setRhSalaryPaySlip($salaryPaySlip);
  349.                                     if (null != $salaryPaySlip->getHourlyRate()) {
  350.                                         $paySlipTaxableItem->setBased($salaryPaySlip->getHourlyRate());
  351.                                     }else {
  352.                                         $paySlipTaxableItem->setBased(0);
  353.                                     }
  354.                                     
  355.                                     if (null != $salaryPaySlip->getNumberHourPerformed()) {
  356.                                         $paySlipTaxableItem->setRate($salaryPaySlip->getNumberHourPerformed());
  357.                                     }else {
  358.                                         $paySlipTaxableItem->setRate(1);
  359.                                     }
  361.                                     $paySlipTaxableItem = SalaryContractManage::setPaySlipTaxableItem($salaryContract, $paySlipTaxableItem, $taxableItem);
  362.                                     
  363.                                     $salaryPaySlip->setGrossTotal($salaryPaySlip->getGrossTotal() + $paySlipTaxableItem->getProfit());
  364.                                     $salaryPaySlip->setTaxGross($salaryPaySlip->getTaxGross() + $paySlipTaxableItem->getProfit());
  365.                                     $salaryPaySlip->setSocialGross($salaryPaySlip->getSocialGross() + $paySlipTaxableItem->getProfit());
  367.                                     $paySlipTaxableItem->setDay($paySlip->getDateEnd()->format('Y-m-s'));
  368.                                     $paySlipTaxableItem->setMonth($paySlip->getDateEnd()->format('Y-m'));
  369.                                     $paySlipTaxableItem->setYear($paySlip->getDateEnd()->format('Y'));
  371.                                     $paySlipTaxableItem->setEstablishment($paySlip->getEstablishment());
  372.                                     
  373.                                     $entityManager->persist($paySlipTaxableItem);
  374.                                 }
  375.                             }
  376.                         }
  378.                         foreach ($salaryContract->getRhSalaryContractItems([], ['num' => 'ASC']) as $key => $salaryContractItem) {
  379.                             if ($salaryContractItem->getType() == 'IMPOSABLE') {
  380.                                 $paySlipTaxableItem = new RhPaySlipTaxableItem();
  381.                                 $paySlipTaxableItem->setComputeMethod('DEFAUT');
  382.                                 $paySlipTaxableItem->setLabel($salaryContractItem->getLabel());
  383.                                 $paySlipTaxableItem->setCode($salaryContractItem->getLabel());
  384.                                 $paySlipTaxableItem->setNum($salaryContractItem->getNum());
  385.                                 $paySlipTaxableItem->setRhSalaryPaySlip($salaryPaySlip);
  386.                                 $paySlipTaxableItem->setRate(1);
  387.                                 $paySlipTaxableItem->setBased($salaryContractItem->getBased());
  388.                                 $paySlipTaxableItem = SalaryContractManage::setPaySlipTaxableItem($salaryContract, $paySlipTaxableItem, null);
  389.                                 
  390.                                 $salaryPaySlip->setGrossTotal($salaryPaySlip->getGrossTotal() + $paySlipTaxableItem->getProfit());
  391.                                 $salaryPaySlip->setTaxGross($salaryPaySlip->getTaxGross() + $paySlipTaxableItem->getProfit());
  392.                                 $salaryPaySlip->setSocialGross($salaryPaySlip->getSocialGross() + $paySlipTaxableItem->getProfit());
  394.                                 $paySlipTaxableItem->setDay($paySlip->getDateEnd()->format('Y-m-s'));
  395.                                 $paySlipTaxableItem->setMonth($paySlip->getDateEnd()->format('Y-m'));
  396.                                 $paySlipTaxableItem->setYear($paySlip->getDateEnd()->format('Y'));
  398.                                 $paySlipTaxableItem->setEstablishment($paySlip->getEstablishment());
  399.                                 
  400.                                 $entityManager->persist($paySlipTaxableItem);
  401.                             }else {
  402.                                 if ($salaryContractItem->getBased() > $salaryContractItem->getAmountLimit()) {
  403.                                     $paySlipTaxableItem = new RhPaySlipTaxableItem();
  404.                                     $paySlipTaxableItem->setComputeMethod('DEFAUT');
  405.                                     $paySlipTaxableItem->setLabel($salaryContractItem->getLabel()." imposable");
  406.                                     $paySlipTaxableItem->setCode($salaryContractItem->getLabel()." imposable");
  407.                                     $paySlipTaxableItem->setNum($salaryContractItem->getNum());
  408.                                     $paySlipTaxableItem->setRhSalaryPaySlip($salaryPaySlip);
  409.                                     $paySlipTaxableItem->setRate(1);
  410.                                     $paySlipTaxableItem->setBased($salaryContractItem->getBased() - $salaryContractItem->getAmountLimit());
  411.                                     $paySlipTaxableItem = SalaryContractManage::setPaySlipTaxableItem($salaryContract, $paySlipTaxableItem, null);
  412.                                     
  413.                                     $salaryPaySlip->setGrossTotal($salaryPaySlip->getGrossTotal() + $paySlipTaxableItem->getProfit());
  414.                                     $salaryPaySlip->setTaxGross($salaryPaySlip->getTaxGross() + $paySlipTaxableItem->getProfit());
  415.                                     $salaryPaySlip->setSocialGross($salaryPaySlip->getSocialGross() + $paySlipTaxableItem->getProfit());
  417.                                     $paySlipTaxableItem->setDay($paySlip->getDateEnd()->format('Y-m-s'));
  418.                                     $paySlipTaxableItem->setMonth($paySlip->getDateEnd()->format('Y-m'));
  419.                                     $paySlipTaxableItem->setYear($paySlip->getDateEnd()->format('Y'));
  421.                                     $paySlipTaxableItem->setEstablishment($paySlip->getEstablishment());
  423.                                     $entityManager->persist($paySlipTaxableItem);
  424.                                 }
  426.                                 $paySlipNonTaxableItem = new RhPaySlipNonTaxableItem();
  427.                                 $paySlipNonTaxableItem->setComputeMethod('DEFAUT');
  428.                                 $paySlipNonTaxableItem->setLabel($salaryContractItem->getLabel());
  429.                                 $paySlipNonTaxableItem->setCode($salaryContractItem->getLabel());
  430.                                 $paySlipNonTaxableItem->setNum($salaryContractItem->getNum());
  431.                                 $paySlipNonTaxableItem->setRhSalaryPaySlip($salaryPaySlip);
  432.                                 $paySlipNonTaxableItem->setRate(1);
  433.                                 $paySlipNonTaxableItem->setBased($salaryContractItem->getAmountLimit());
  434.                                 $paySlipNonTaxableItem = SalaryContractManage::setPaySlipNonTaxableItem($salaryContract, $paySlipNonTaxableItem, $salaryContractItem);
  435.                                 
  436.                                 $salaryPaySlip->setGrossTotal($salaryPaySlip->getGrossTotal() + $paySlipNonTaxableItem->getProfit());
  437.                                 /* le transport n'est pas inclus dans le brut social */
  438.                                 if (!str_contains($salaryContractItem->getLabel(), 'TRANSPORT')) {
  439.                                     $salaryPaySlip->setSocialGross($salaryPaySlip->getSocialGross() + $paySlipNonTaxableItem->getProfit());
  440.                                 }
  442.                                 $paySlipNonTaxableItem->setDay($paySlip->getDateEnd()->format('Y-m-s'));
  443.                                 $paySlipNonTaxableItem->setMonth($paySlip->getDateEnd()->format('Y-m'));
  444.                                 $paySlipNonTaxableItem->setYear($paySlip->getDateEnd()->format('Y'));
  446.                                 $paySlipNonTaxableItem->setEstablishment($paySlip->getEstablishment());
  447.                                 
  448.                                 $entityManager->persist($paySlipNonTaxableItem);
  449.                             }
  450.                         }
  452.                         if ($salaryContract->getRhSalary()->getIsPermanent()) {
  453.                             foreach ($retainedItemRepository->findBy([], ['num' => 'ASC']) as $key => $retainedItem) {
  454.                                 if ($retainedItem->getComputeMethod() != self::LABEL_RATE_NOT_PERMANANT) {
  455.                                     $paySlipRetainedItem = new RhPaySlipRetainedItem();
  456.                                     $paySlipRetainedItem->setType($retainedItem->getType());
  457.                                     $paySlipRetainedItem->setPart($retainedItem->getPart());
  458.                                     $paySlipRetainedItem->setComputeMethod($retainedItem->getComputeMethod());
  459.                                     $paySlipRetainedItem->setLabel($retainedItem->getLabel());
  460.                                     $paySlipRetainedItem->setCode($retainedItem->getLabel());
  461.                                     $paySlipRetainedItem->setNum($retainedItem->getNum());
  462.                                     $paySlipRetainedItem->setRhSalaryPaySlip($salaryPaySlip);
  464.                                     if ($retainedItem->getComputeMethod() == 'ITS') {
  465.                                         $paySlipRetainedItem = SalaryContractManage::setITS($salaryContract, $salaryPaySlip, $paySlipRetainedItem, $retainedItem, $taxReductionSheduleRepository, $salaryBandScaleRepository);
  466.                                     }else {
  467.                                         $paySlipRetainedItem = SalaryContractManage::setPaySlipRetainedItem($salaryContract, $salaryPaySlip, $paySlipRetainedItem, $retainedItem);
  468.                                     }
  469.                                     
  470.                                     if ($retainedItem->getPart() == 'SALARIALE') {
  471.                                         $salaryPaySlip->setWithholdingTax($salaryPaySlip->getWithholdingTax() + $paySlipRetainedItem->getProfit());
  472.                                     }else {
  473.                                         $salaryPaySlip->setPatronalWithholdingTax($salaryPaySlip->getPatronalWithholdingTax() + $paySlipRetainedItem->getProfit());
  474.                                     }
  475.                                     
  476.                                     $paySlipRetainedItem->setDay($paySlip->getDateEnd()->format('Y-m-s'));
  477.                                     $paySlipRetainedItem->setMonth($paySlip->getDateEnd()->format('Y-m'));
  478.                                     $paySlipRetainedItem->setYear($paySlip->getDateEnd()->format('Y'));
  480.                                     $paySlipRetainedItem->setEstablishment($paySlip->getEstablishment());
  481.                                     
  482.                                     $entityManager->persist($paySlipRetainedItem);
  483.                                 }
  484.                             }
  485.                         }else {
  486.                             foreach ($retainedItemRepository->findBy([], ['num' => 'ASC']) as $key => $retainedItem) {
  487.                                 if ($retainedItem->getComputeMethod() == self::LABEL_RATE_NOT_PERMANANT) {
  488.                                     $paySlipRetainedItem = new RhPaySlipRetainedItem();
  489.                                     $paySlipRetainedItem->setType($retainedItem->getType());
  490.                                     $paySlipRetainedItem->setPart($retainedItem->getPart());
  491.                                     $paySlipRetainedItem->setComputeMethod($retainedItem->getComputeMethod());
  492.                                     $paySlipRetainedItem->setLabel($retainedItem->getLabel());
  493.                                     $paySlipRetainedItem->setCode($retainedItem->getLabel());
  494.                                     $paySlipRetainedItem->setNum($retainedItem->getNum());
  495.                                     $paySlipRetainedItem->setRhSalaryPaySlip($salaryPaySlip);
  497.                                     if ($retainedItem->getComputeMethod() == 'ITS') {
  498.                                         $paySlipRetainedItem = SalaryContractManage::setITS($salaryContract, $salaryPaySlip, $paySlipRetainedItem, $retainedItem, $taxReductionSheduleRepository, $salaryBandScaleRepository);
  499.                                     }else {
  500.                                         $paySlipRetainedItem = SalaryContractManage::setPaySlipRetainedItem($salaryContract, $salaryPaySlip, $paySlipRetainedItem, $retainedItem);
  501.                                     }
  502.                                     
  503.                                     if ($retainedItem->getPart() == 'SALARIALE') {
  504.                                         $salaryPaySlip->setWithholdingTax($salaryPaySlip->getWithholdingTax() + $paySlipRetainedItem->getProfit());
  505.                                     }else {
  506.                                         $salaryPaySlip->setPatronalWithholdingTax($salaryPaySlip->getPatronalWithholdingTax() + $paySlipRetainedItem->getProfit());
  507.                                     }
  508.                                     
  509.                                     $paySlipRetainedItem->setDay($paySlip->getDateEnd()->format('Y-m-s'));
  510.                                     $paySlipRetainedItem->setMonth($paySlip->getDateEnd()->format('Y-m'));
  511.                                     $paySlipRetainedItem->setYear($paySlip->getDateEnd()->format('Y'));
  513.                                     $paySlipRetainedItem->setEstablishment($paySlip->getEstablishment());
  514.                                     
  515.                                     $entityManager->persist($paySlipRetainedItem);
  516.                                 }
  517.                             }
  518.                         }
  520.                         $rhSalaryCreditSheduls = $rhSalaryCreditShedulRepository->createQueryBuilder('entity')
  521.                         ->innerJoin('entity.rhSalaryCredit', 'rhSalaryCredit')
  522.                         ->addSelect('rhSalaryCredit')
  524.                         ->andWhere('entity.date_due BETWEEN :dateStart AND :dateEnd')
  525.                         ->setParameter('dateStart', $paySlip->getDateStart())
  526.                         ->setParameter('dateEnd', $paySlip->getDateEnd())
  528.                         ->andWhere('rhSalaryCredit.rhSalary = :rhSalary')
  529.                         ->setParameter('rhSalary', $salaryContract->getRhSalary())
  531.                         ->getQuery()
  532.                         ->getResult();
  533.                         foreach ($rhSalaryCreditSheduls as $key => $rhSalaryCreditShedul) {
  534.                             if ($rhSalaryCreditShedul->amountRestToPaid() > 0) {
  535.                                 $paySlipRetainedItem = new RhPaySlipRetainedItem();
  536.                                 $paySlipRetainedItem->setType('AUTRES');
  537.                                 $paySlipRetainedItem->setPart('SALARIALE');
  538.                                 $paySlipRetainedItem->setComputeMethod("DEFAUT");
  539.                                 $paySlipRetainedItem->setLabel('Retenue Echéancié Prêt du '.$rhSalaryCreditShedul->getDateDue()->format('d/m/Y'));
  540.                                 $paySlipRetainedItem->setCode("EP-".$rhSalaryCreditShedul->getId().'-du-'.$rhSalaryCreditShedul->getDateDue()->format('d-m-Y'));
  541.                                 $paySlipRetainedItem->setNum('99');
  542.                                 $paySlipRetainedItem->setRhSalaryPaySlip($salaryPaySlip);
  543.                                 $paySlipRetainedItem->setRate(1);
  544.                                 $paySlipRetainedItem->setBased($rhSalaryCreditShedul->amountRestToPaid());
  545.                                 $paySlipRetainedItem->setProfit($rhSalaryCreditShedul->amountRestToPaid());
  546.                                 $paySlipRetainedItem = SalaryContractManage::setPaySlipRetainedItem($salaryContract, $salaryPaySlip, $paySlipRetainedItem, null); 
  547.                                 $salaryPaySlip->setWithholdingTax($salaryPaySlip->getWithholdingTax() + $paySlipRetainedItem->getProfit());
  548.                                 
  549.                                 $paySlipRetainedItem->setRhSalaryCreditShedul($rhSalaryCreditShedul);
  551.                                 $paySlipRetainedItem->setDay($paySlip->getDateEnd()->format('Y-m-s'));
  552.                                 $paySlipRetainedItem->setMonth($paySlip->getDateEnd()->format('Y-m'));
  553.                                 $paySlipRetainedItem->setYear($paySlip->getDateEnd()->format('Y'));
  555.                                 $paySlipRetainedItem->setEstablishment($paySlip->getEstablishment());
  556.                                 
  557.                                 $entityManager->persist($paySlipRetainedItem);
  558.                             }
  559.                         }
  561.                         $salaryPaySlip->setCode('PAIE-'.$salaryContract->getId().$paySlip->getId());
  562.                         $salaryPaySlip->setNetSalary($salaryPaySlip->getGrossTotal() - ($salaryPaySlip->getWithholdingTax() + $salaryPaySlip->getOthersRetained()));
  563.                         $entityManager->persist($salaryPaySlip);
  564.                     //}
  565.                 }
  566.             }
  567.         }
  569.         try {
  570.             $entityManager->flush();
  571.             $this->addFlash('info', "les ligne(s) ont été générées avec succès.");
  572.         } catch (\Throwable $th) {
  573.             //$th->getMessage()
  574.             $this->addFlash('info', $th->getMessage());
  575.         }
  577.         return $this->redirectToRoute('rh_pay_slip_show', [
  578.             'id' => $paySlip->getId()
  579.         ]);
  580.     }
  582.     /**
  583.      * @Route("/print/{id}", name="rh_pay_slip_print", methods={"GET"})
  584.      */
  585.     public function print(Request $request, Pdf $knpSnappyPdf, RhPaySlip $paySlip, RhSalaryPaySlipRepository $salaryPaySlipRepository)
  586.     {
  587.         $establishment = $this->getUser()->getEstablishment();
  588.         $setting = $establishment;
  590.         $salaryPaySlips = $salaryPaySlipRepository->createQueryBuilder('entity')
  591.         ->andWhere('entity.establishment = :establishment')
  592.         ->setParameter('establishment', $setting)
  594.         ->andWhere('entity.rhPaySlip = :rhPaySlip')
  595.         ->setParameter('rhPaySlip', $paySlip)
  597.         ->innerJoin('entity.rhSalary', 'rhSalary')
  598.         ->addSelect('rhSalary')
  600.         /* ->andWhere('rhSalary.bank_name = :bank_name')
  601.         ->setParameter('bank_name', $request->get('bankName')) */
  602.         
  603.         ->orderBy('rhSalary.last_name', 'ASC')
  604.         ->getQuery()
  605.         ->getResult();
  607.         $paySlipLines = new ArrayCollection();
  609.         $netToPay = 0;
  610.         foreach ($salaryPaySlips as $key => $salaryPaySlip) {
  611.             if (strlen($request->get('bankName')) > 0) {
  612.                 if ($salaryPaySlip->getRhSalary()->getBankName() == $request->get('bankName')) {
  613.                     $paySlipLines->add(
  614.                         [
  615.                             'fullName' => $salaryPaySlip->getRhSalary()->getName(),
  616.                             'bankName' => $salaryPaySlip->getRhSalary()->getBankName(),
  617.                             'bankCode' => $salaryPaySlip->getRhSalary()->getBankCode(),
  618.                             'bankCounterCode' => $salaryPaySlip->getRhSalary()->getCounterCode(),
  619.                             'job' => $salaryPaySlip->getRhSalaryContract()->getService(),
  620.                             'bankAccountNumber' => $salaryPaySlip->getRhSalary()->getBankAccountNumber(),
  621.                             'finetAccountNumber' => $salaryPaySlip->getRhSalary()->getFinetAccountNumber(),
  622.                             'netToPay' => $salaryPaySlip->getNetSalary(),
  623.                             'taxGross' => $salaryPaySlip->getTaxGross(),
  624.                             'pTransport' => $salaryPaySlip->getPTransport()
  625.                         ]
  626.                     );
  628.                     $netToPay = $netToPay + $salaryPaySlip->getNetSalary();
  629.                 }
  630.             }else {
  631.                 $paySlipLines->add(
  632.                     [
  633.                         'fullName' => $salaryPaySlip->getRhSalary()->getName(),
  634.                         'bankName' => $salaryPaySlip->getRhSalary()->getBankName(),
  635.                         'bankCode' => $salaryPaySlip->getRhSalary()->getBankCode(),
  636.                         'bankCounterCode' => $salaryPaySlip->getRhSalary()->getCounterCode(),
  637.                         'job' => $salaryPaySlip->getRhSalaryContract()->getService(),
  638.                         'bankAccountNumber' => $salaryPaySlip->getRhSalary()->getBankAccountNumber(),
  639.                         'finetAccountNumber' => $salaryPaySlip->getRhSalary()->getFinetAccountNumber(),
  640.                         'netToPay' => $salaryPaySlip->getNetSalary(),
  641.                         'taxGross' => $salaryPaySlip->getTaxGross(),
  642.                         'pTransport' => $salaryPaySlip->getPTransport()
  643.                     ]
  644.                 );
  646.                 $netToPay = $netToPay + $salaryPaySlip->getNetSalary();
  647.             }
  648.         }
  650.         $iterator = $paySlipLines->getIterator();
  651.         $iterator->uasort(function ($first, $second) {
  652.             if ($first === $second) {
  653.                 return 0;
  654.             }
  656.             return $first['fullName'] < $second['fullName'] ? -1 : 1;
  657.         });
  659.         $paySlipLines = new ArrayCollection(iterator_to_array($iterator));
  661.         $html = $this->renderView('rh/rh_pay_slip/print/order.html.twig', [
  662.             'paySlip' => $paySlip,
  663.             'paySlipLines' => $paySlipLines,
  664.             'netToPay' => $netToPay,
  665.             'bankName' => $request->get('bankName'),
  666.             'setting' => $setting,
  667.         ]);
  669.         $file_name = "OV_".$paySlip->getId().".pdf";
  670.         $footer = $this->renderView('print/footer.html.twig', ['setting' => $establishment]);
  671.         $header = $this->renderView('print/header.html.twig', ['setting' => $establishment]);
  673.         $options = [
  674.             'orientation' => 'Portrait',
  675.             'header-html' => $header
  676.             //'footer-html' => $footer
  677.         ];
  679.         $knpSnappyPdf->generateFromHtml($html, $this->getParameter('app.app_directory').'/downloads/payslips/' . $file_name, $options, true);
  681.         return $this->redirectToRoute('preview', [
  682.             'file' => $file_name,
  683.             'dir' => 'payslips',
  684.         ]);
  685.     }
  687.     /**
  688.      * @Route("/export/{id}", name="rh_pay_slip_export", methods={"GET"})
  689.      */
  690.     public function export(RhPaySlip $paySlip)
  691.     {
  692.         $setting = $this->getUser()->getEstablishment();
  693.         $paySlipInCompanyBankLines = new ArrayCollection();
  694.         foreach ($paySlip->getRhSalaryPaySlips() as $key => $salaryPaySlip) {
  695.             //if ($salaryPaySlip->getRhSalary()->getBankCode() == $setting->getBankCode()) {
  696.                 $paySlipInCompanyBankLines->add(
  697.                     [
  698.                         'companyName' => $setting->getName(),
  699.                         'fullName' => $salaryPaySlip->getRhSalary()->getName(),
  700.                         'counter' => $salaryPaySlip->getRhSalary()->getCounterCode(),
  701.                         'bankAccountNumber' => $salaryPaySlip->getRhSalary()->getBankAccountNumber(),
  702.                         'finetAccountNumber' => $salaryPaySlip->getRhSalary()->getFinetAccountNumber(),
  703.                         'netToPaid' => number_format($salaryPaySlip->getNetSalary(), 0, ',', ''),
  704.                         'label' => $paySlip->getLabel(),
  705.                         'bank' => $salaryPaySlip->getRhSalary()->getBankCode()
  706.                     ]
  707.                 );
  708.             //}
  709.         }
  711.         $iterator = $paySlipInCompanyBankLines->getIterator();
  712.         $iterator->uasort(function ($first, $second) {
  713.             if ($first === $second) {
  714.                 return 0;
  715.             }
  717.             return $first['bankAccountNumber'] < $second['bankAccountNumber'] ? -1 : 1;
  718.         });
  719.         $paySlipInCompanyBankLines = new ArrayCollection(iterator_to_array($iterator));
  721.         $spreadsheet = new Spreadsheet();
  722.         $sheet = $spreadsheet->getActiveSheet();
  723.         $sheet->setCellValue('A1', 'ETABLISSEMENT');
  724.         $sheet->setCellValue('B1', 'NOM ET PRENOMS');
  725.         $sheet->setCellValue('C1', 'GUICHE');
  726.         $sheet->setCellValue('D1', 'N° COMPTE BANCAIRE');
  727.         $sheet->setCellValue('E1', 'N° FINCARTE');
  728.         $sheet->setCellValue('F1', 'MONTANT');
  729.         $sheet->setCellValue('G1', 'LIBELLE');
  730.         $sheet->setCellValue('H1', 'BANQUE');
  731.         $index = 2;
  732.         $loopIndex = 1;
  733.         foreach ($paySlipInCompanyBankLines as $key => $paySlipInCompanyBankLine) {
  734.             $sheet->setCellValue('A' . $index, $paySlipInCompanyBankLine['companyName']);
  735.             $sheet->setCellValue('B' . $index, $paySlipInCompanyBankLine['fullName']);
  736.             $sheet->setCellValue('C' . $index, $paySlipInCompanyBankLine['counter']);
  737.             $sheet->setCellValue('D' . $index, $paySlipInCompanyBankLine['bankAccountNumber']);
  738.             $sheet->setCellValue('E' . $index, $paySlipInCompanyBankLine['finetAccountNumber']);
  739.             $sheet->setCellValue('F' . $index, $paySlipInCompanyBankLine['netToPaid']);
  740.             $sheet->setCellValue('G' . $index, $paySlipInCompanyBankLine['label']);
  741.             $sheet->setCellValue('H' . $index, $paySlipInCompanyBankLine['bank']);
  742.             $index = $index + 1;
  743.             $loopIndex = $loopIndex + 1;
  744.         }
  745.         $sheet->setCellValue('A' . $index, '');
  746.         $sheet->setCellValue('B' . $index, '');
  747.         $sheet->setCellValue('C' . $index, '');
  748.         $sheet->setCellValue('D' . $index, '');
  749.         $sheet->setCellValue('E' . $index, '');
  750.         $sheet->setCellValue('F' . $index, '');
  751.         $sheet->setCellValue('G' . $index, '');
  752.         $sheet->setCellValue('H' . $index, '');
  753.         $index = $index + 1;
  754.         $loopIndex = $loopIndex + 1;
  755.         
  756.         $sheet->setTitle('OV-' . $paySlip->getId());
  757.         $writer = new Xlsx($spreadsheet);
  758.         // Create a Temporary file in the system
  759.         $fileName = 'OV-' . $paySlip->getLabel() . '.xlsx';
  760.         $temp_file = tempnam(sys_get_temp_dir(), $fileName);
  761.         $writer->save($temp_file);
  763.         // Return the excel file as an attachment
  764.         return $this->file($temp_file, $fileName, ResponseHeaderBag::DISPOSITION_INLINE);
  765.     }
  767.     /**
  768.      * @Route("/validated/{id}", name="rh_pay_slip_validated", methods={"GET"})
  769.      */
  770.     public function validated(RhPaySlip $paySlip): Response
  771.     {
  772.         $entityManager = $this->getDoctrine()->getManager();
  773.         foreach ($paySlip->getRhSalaryPaySlips() as $key => $salaryPaySlip) {
  774.             $salaryPaySlip->setIsValidated(true);
  775.         }
  777.         $paySlip->setIsValidated(true);
  778.         try {
  779.             $entityManager->flush();
  780.             return $this->json(['code' => 200, 'message' => "Validation effectuée"], 200);
  781.         } catch (\Throwable $th) {
  782.             $this->addFlash('warning', $th->getMessage());
  783.         }
  784.         
  785.         $this->addFlash('warning', "Validation non effectuée.");
  786.         return $this->json(['code' => 500, 'message' => "Validation non effectuée."], 200);
  787.     }
  789.     /**
  790.      * @Route("/cancel/{id}", name="rh_pay_slip_cancel", methods={"GET"})
  791.      */
  792.     public function cancel(RhPaySlip $paySlip): Response
  793.     {
  794.         $entityManager = $this->getDoctrine()->getManager();
  795.         foreach ($paySlip->getRhSalaryPaySlips() as $key => $salaryPaySlip) {
  796.             $salaryPaySlip->setIsValidated(false);
  797.         }
  798.         $paySlip->setIsValidated(false);
  799.         try {
  800.             $entityManager->flush();
  801.             return $this->json(['code' => 200, 'message' => "Annulation effectuée"], 200);
  802.         } catch (\Throwable $th) {
  803.             $this->addFlash('warning', $th->getMessage());
  804.         }
  805.         
  806.         $this->addFlash('warning', "Annulation non effectuée.");
  807.         return $this->json(['code' => 500, 'message' => "Annulation non effectuée."], 200);
  808.     }
  810.     /**
  811.      * @Route("/paysheet/{id}/print", name="rh_pay_slip_paysheet_print", methods={"GET"})
  812.      */
  813.     public function paysheet_print(Pdf $knpSnappyPdf, RhPaySlip $paySlip, RhSalaryPaySlipRepository $rhSalaryPaySlipRepository)
  814.     {
  815.         /**@var User $user */
  816.         $user = $this->getUser();
  817.         $establishment = $user->getEstablishment();
  818.         $setting = $establishment;
  820.         $rhSalaryPaySlips = $rhSalaryPaySlipRepository->createQueryBuilder('entity')
  821.         ->innerJoin('entity.rhSalary', 'rhSalary')
  822.         ->addSelect('rhSalary')
  824.         ->andWhere('entity.rhPaySlip = :rhPaySlip')
  825.         ->setParameter('rhPaySlip', $paySlip)
  827.         ->andWhere('entity.establishment = :establishment')
  828.         ->setParameter('establishment', $establishment)
  830.         ->orderBy('rhSalary.last_name', 'ASC')
  831.         ->getQuery()
  832.         ->getResult();
  834.         $html = $this->renderView('rh/rh_pay_slip/print/paysheet.html.twig', [
  835.             'paySlip' => $paySlip,
  836.             'rhSalaryPaySlips' => $rhSalaryPaySlips,
  837.             'setting' => $setting,
  838.         ]);
  840.         $footer = $this->renderView('print/footer.html.twig', ['setting' => $setting,]);
  841.         $header = $this->renderView('print/header.html.twig', ['setting' => $setting,]);
  842.         $options = [
  843.             'orientation' => 'Landscape'
  844.             //'header-html' => $header
  845.             //'footer-html' => $footer
  846.         ];
  848.         $file_name = "LIVRE_PAIE_".$paySlip->getId().".pdf";
  850.         try {
  851.             $knpSnappyPdf->generateFromHtml($html, $this->getParameter('app.app_directory').'/downloads/payslips/' . $file_name, $options, true);
  852.         } catch (\Throwable $th) {
  853.             $this->addFlash('info', "Effectué");
  854.         }
  856.         return $this->redirectToRoute('preview', [
  857.             'file' => $file_name,
  858.             'dir' => 'payslips',
  859.         ]);
  860.     }
  862.     /**
  863.      * @Route("/cnps-declaration/export/{id}", name="rh_pay_slip_cnps_declaration_export", methods={"GET"})
  864.      */
  865.     public function cnps_declaration_expor(RhPaySlip $paySlip, RhSalaryPaySlipRepository $rhSalaryPaySlipRepository)
  866.     {
  867.         /**@var User $user */
  868.         $user = $this->getUser();
  869.         $establishment = $user->getEstablishment();
  870.         $setting = $establishment;
  872.         $spreadsheet = new Spreadsheet();
  873.         $sheet = $spreadsheet->getActiveSheet();
  874.         $sheet->setCellValue('A1', 'NUMERO CNPS');
  875.         $sheet->setCellValue('B1', 'NOM');
  876.         $sheet->setCellValue('C1', 'PRENOMS');
  877.         $sheet->setCellValue('D1', 'ANNEE DE NAISSANCE');
  878.         $sheet->setCellValue('E1', 'DATE D\'EMBAUCHE');
  879.         $sheet->setCellValue('F1', 'DATE DE DEPART');
  880.         $sheet->setCellValue('G1', 'TYPE SALARIE M: Mensuel J : Journalier H: Horaire');
  881.         $sheet->setCellValue('H1', 'DUREE TRAVAILLEE');
  882.         $sheet->setCellValue('I1', 'SALAIRE BRUT');
  883.         $index = 2;
  884.         $loopIndex = 1;
  885.         $tax_gross = 0;
  887.         $rhSalaryPaySlips = $rhSalaryPaySlipRepository->createQueryBuilder('entity')
  888.         ->innerJoin('entity.rhSalary', 'rhSalary')
  889.         ->addSelect('rhSalary')
  891.         ->andWhere('rhSalary.is_declared = :is_declared')
  892.         ->setParameter('is_declared', 1)
  894.         ->andWhere('entity.rhPaySlip = :rhPaySlip')
  895.         ->setParameter('rhPaySlip', $paySlip)
  897.         ->orderBy('rhSalary.social_number', 'DESC')
  898.         ->getQuery()
  899.         ->getResult();
  901.         foreach ($rhSalaryPaySlips as $key => $salaryPaySlip) {
  902.             if ($salaryPaySlip->getRhSalary()->getIsDeclared()) {
  903.                 $sheet->setCellValue('A' . $index, ' '.$salaryPaySlip->getRhSalary()->getSocialNumber());
  904.                 $sheet->setCellValue('B' . $index, $salaryPaySlip->getRhSalary()->getLastName());
  905.                 $sheet->setCellValue('C' . $index, $salaryPaySlip->getRhSalary()->getFirstName());
  906.                 $sheet->setCellValue('D' . $index, $salaryPaySlip->getRhSalary()->getBirthDay() ? $salaryPaySlip->getRhSalary()->getBirthDay()->format('Y') : '');
  907.                 $sheet->setCellValue('E' . $index, $salaryPaySlip->getRhSalaryContract()->getStartDate() ? $salaryPaySlip->getRhSalaryContract()->getStartDate()->format('d/m/Y') : '');
  908.                 $sheet->setCellValue('F' . $index, $salaryPaySlip->getRhSalaryContract()->getEndDate() ? $salaryPaySlip->getRhSalaryContract()->getEndDate()->format('d/m/Y') : '');
  909.                 $sheet->setCellValue('G' . $index, 'M');
  910.                 $sheet->setCellValue('H' . $index, '1');
  911.                 $sheet->setCellValue('I' . $index, $salaryPaySlip->getSocialGross());
  912.                 $index += 1;
  913.                 $loopIndex +=  1;
  914.                 $tax_gross += $salaryPaySlip->getSocialGross();
  915.             }
  916.         }
  918.         
  919.         
  920.         $sheet->setCellValue('A' . $index, '');
  921.         $sheet->setCellValue('B' . $index, '');
  922.         $sheet->setCellValue('C' . $index, '');
  923.         $sheet->setCellValue('D' . $index, '');
  924.         $sheet->setCellValue('E' . $index, '');
  925.         $sheet->setCellValue('F' . $index, '');
  926.         $sheet->setCellValue('G' . $index, '');
  927.         $sheet->setCellValue('H' . $index, '');
  928.         $sheet->setCellValue('I' . $index, $tax_gross);
  929.         $index = $index + 1;
  930.         $loopIndex = $loopIndex + 1;
  931.         
  932.         $sheet->setTitle('DECL_CNPS' . $paySlip->getId());
  933.         $writer = new Xlsx($spreadsheet);
  934.         // Create a Temporary file in the system
  935.         $fileName = 'DECL_CNPS_' . $paySlip->getLabel() . '_' . str_replace(' ', '_', $setting->getEstablishmentGroup()->getName()) . '.xlsx';
  936.         $temp_file = tempnam(sys_get_temp_dir(), $fileName);
  937.         $writer->save($temp_file);
  939.         // Return the excel file as an attachment
  940.         return $this->file($temp_file, $fileName, ResponseHeaderBag::DISPOSITION_INLINE);
  941.     }
  942. }