src\Controller\EDIController.php line 42

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\JOURNAL;
  6. use App\Entity\SAGE\GACCDUDATE;
  7. use App\Entity\SAGE\GACCENTRYA;
  8. use App\Entity\SAGE\GACCENTRY as sageGaccentries;
  9. use App\Entity\SAGE\GACCENTRYD as sageGaccentryd;
  10. use App\Entity\Bpartner;
  11. use App\Entity\Gaccentry as outputGaccentries;
  12. use App\Entity\CompteTier;
  13. use App\Entity\Gaccentryd;
  14. use App\Entity\Genratenum;
  15. use App\Entity\Partenaire;
  16. use Psr\Log\LoggerInterface;
  17. use Doctrine\DBAL\Connection;
  18. use Doctrine\ORM\Query\Expr\Join;
  19. use App\Service\ConnectionService;
  20. use Doctrine\DBAL\Driver\Exception;
  21. use Doctrine\Persistence\ManagerRegistry;
  22. use Symfony\Component\HttpFoundation\Request;
  23. use Symfony\Component\HttpFoundation\Response;
  24. use Symfony\Component\Routing\Annotation\Route;
  25. use Symfony\Component\HttpFoundation\JsonResponse;
  26. use Symfony\Contracts\HttpClient\HttpClientInterface;
  27. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  29. class EDIController extends AbstractController
  30. {
  31.     private $em;
  32.     private $client;
  34.     public function __construct(ConnectionService $em,HttpClientInterface $client)
  35.     {
  36.         $this->em = $em;
  37.         $this->client = $client;
  38.     }
  40.     #[Route('/edi', name: 'app_edi')]
  41.     public function index(): Response
  42.     {
  43.         return $this->render('edi/index.html.twig', [
  44.             'controller_name' => 'EDIController',
  45.         ]);
  46.     }
  48.     #[Route('/getCodeAdonix', name: 'app_getCodeAdonix')]
  49.     public function getCodeAdonix(): Response
  50.     {
  51.         $results = $this->em->getEntity()->getRepository(outputGaccentries::class)->findByDate(); // Adjust the method to match your repository
  52.         // dd($results);
  53.         foreach ($results as $entry) {
  54.             $num = $entry->getNum();
  55.     
  56.             // Use $num in your SQL query
  57.             $searchAdonix = $this->em->getSage()->fetchAllAssociative("SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = '".$num."' ");
  58.             
  59.             if ($searchAdonix) {
  60.                 $entry->setObservationFczFlag6($searchAdonix[0]['NUM_0']);
  61.                 $entry->setFczFlag6(8);
  62.                 $this->em->getEntity()->persist($entry);
  63.                 
  64.             }
  65.         }
  66.         $this->em->getEntity()->flush();
  67.         return new Response('ok');
  68.     }
  70.     #[Route('/sage/accnum', name: 'app_sage_accnum')]
  71.     public function accnum()
  72.     {
  73.         try {
  75.             $this->em->getInterface()->beginTransaction();
  77.             $accnum = $this->em->getEntity()->getRepository(Genratenum::class)->findLastAccnum();
  78.                 // dd($accnum);
  79.             $pieceCaImport = $this->em->getEntity()->getRepository(outputGaccentries::class)->findCaAccnum();
  80.             // dd($pieceCaImport);
  81.         
  82.             foreach ($pieceCaImport as $piece) {
  83.                 // dd($piece);
  84.                 $piece->setFczFlag3(1);
  86.                 $Gaccentryds = $piece->getGaccentryds();
  87.         
  88.                 foreach ($Gaccentryds as $det) {
  89.                     $accnum++;
  90.                     $det->setPcg($accnum);
  91.                     $accnum++;
  92.                     $det->setPca($accnum);
  94.                     // dd($det);
  95.                 }
  96.             }
  97.         
  98.             $this->em->getEntity()->flush();
  99.             
  100.             $updateAccnum = $this->em->getInterface()->fetchAssociative("UPDATE genratenum SET type = '".$accnum."' WHERE id = 810699");    
  101.             
  102.             $this->em->getInterface()->commit();
  103.     
  104.         } catch (Exception $e) {
  106.                 if ($this->em->getInterface()->isTransactionActive()) {
  107.                     $this->em->getInterface()->rollBack();
  108.                 }
  109.                 
  110.                 return new JsonResponse("Error: " . $e->getMessage());
  111.         }
  112.             // return new JsonResponse($accnum);
  113.             return new JsonResponse("ok");
  114.     }
  116.     #[Route('/sage/collectif', name: 'app_sage_collectif')]
  117.     public function collectif()
  118.     {
  119.         try {
  121.             $this->em->getInterface()->beginTransaction();
  123.             $pieceCaImport = $this->em->getEntity()->getRepository(outputGaccentries::class)->findCaCollectif();
  125.             // dd($pieceCaImport);
  126.         
  127.             foreach ($pieceCaImport as $piece) {
  128.                 // dd($piece);
  129.                 $piece->setFczFlag1(7);
  131.                 $Gaccentryds = $piece->getGaccentryds();
  132.         
  133.                 foreach ($Gaccentryds as $det) {
  135.                     if ($det->getBpr()) {
  136.                         // dd($det);
  137.                         $compteCollectif = $this->em->getEntity()->getRepository(CompteTier::class)->findSacByAcc($det->getAcc());
  138.                         $det->SetSac($compteCollectif->getPca());
  139.                     }
  140.                     continue;
  141.                 }
  142.             }
  143.         
  144.             $this->em->getEntity()->flush();
  145.             $this->em->getInterface()->commit();
  146.     
  147.         } catch (Exception $e) {
  149.                 if ($this->em->getInterface()->isTransactionActive()) {
  150.                     $this->em->getInterface()->rollBack();
  151.                 }
  152.                 
  153.                 return new JsonResponse("Error: " . $e->getMessage());
  154.         }
  155.             // return new JsonResponse($accnum);
  156.             return new JsonResponse("ok");
  157.     }
  159.     #[Route('/anomalie', name: 'app_anomalie')]
  160.     public function anomalie(Request $request): Response
  161.     {
  162.         // Construire la requête Doctrine pour chercher les anomalies
  163.         $queryBuilder = $this->em->getEntity()->createQueryBuilder()
  164.         ->select('g.typ', 'g.num', 'g.accdat', 'g.desvcr', 'g.observation_fcz_flag6')
  165.         ->from(outputGaccentries::class, 'g')
  166.         ->where('g.fcz_flag6 = 9')
  167.         ->andWhere('g.fczFlag5 = 1')
  168.         ->andWhere('g.fczFlag3 = 0');
  170.         // Execute the main query
  171.         $results = $queryBuilder->getQuery()->getResult();
  173.         foreach ($results as &$row) {
  174.             $row['accdat'] = $row['accdat']->format('Y-m-d'); // Adjust format as needed
  175.         }
  177.         // Return the response
  178.         return new JsonResponse($results);
  179.     }
  180.     
  181.     #[Route('/anomalie/observationPiece', name: 'app_anomalie_observationPiece')]
  182.     public function observationPiece(Request $request): JsonResponse
  183.     {
  184.         $qb = $this->em->getEntity()->createQueryBuilder();
  186.         $qb->select('DISTINCT CASE
  187.                                 WHEN o.observation_fcz_flag6 LIKE :date THEN :dateLabel
  188.                                 WHEN o.observation_fcz_flag6 LIKE :fournisseur THEN :fournisseurLabel
  189.                                 WHEN o.observation_fcz_flag6 LIKE :client THEN :clientLabel
  190.                                 WHEN o.observation_fcz_flag6 LIKE :type THEN :typeLabel
  191.                                 WHEN o.observation_fcz_flag6 LIKE :desequilibrees THEN :desequilibreesLabel
  192.                                 WHEN o.observation_fcz_flag6 LIKE :det THEN :detLabel
  193.                                 WHEN o.observation_fcz_flag6 LIKE :acc THEN :cmpLabel
  194.                                 ELSE :otherLabel 
  195.                             END AS Observ')
  196.             ->from('App\Entity\Gaccentry', 'o')
  197.             ->where('o.fczFlag3 = :fczFlag3')
  198.             ->andWhere('o.fcz_flag6 = :fczFlag6')
  199.             ->andWhere('o.fczFlag5 = :fczFlag2')
  200.             ->setParameter('date', '%DATE%')
  201.             ->setParameter('dateLabel', 'DATE')
  202.             ->setParameter('fournisseur', '%FOURNISSEUR%')
  203.             ->setParameter('fournisseurLabel', 'FOURNISSEUR')
  204.             ->setParameter('client', '%CLIENT%')
  205.             ->setParameter('clientLabel', 'CLIENT')
  206.             ->setParameter('acc', '%ACC N EXISTE%')
  207.             ->setParameter('cmpLabel', 'compte')
  208.             ->setParameter('type', '%TYPE%')
  209.             ->setParameter('typeLabel', 'TYPE')
  210.             ->setParameter('desequilibrees', '%DESEQUILIBREES%')
  211.             ->setParameter('desequilibreesLabel', 'PIECE DESEQUILIBREES')
  212.             ->setParameter('det', '%DET%')
  213.             ->setParameter('detLabel', 'SANS DET')
  214.             ->setParameter('otherLabel', 'OTHER')
  215.             ->setParameter('fczFlag3', 0)
  216.             ->setParameter('fczFlag6', 9)
  217.             ->setParameter('fczFlag2', 1);
  219.         $observationFlags = $qb->getQuery()->getResult();
  221.         $options = [];
  222.         foreach ($observationFlags as $flag) {
  223.             $options[] = $flag['Observ'];
  224.         }
  225.     
  226.         return new JsonResponse($options);
  227.     }
  229.     #[Route('/suivi/returnPiece', name: 'app_suivi_returnPiece')]
  230.     public function suiviReturnPiece(Request $request): Response
  231.     {
  232.         // Step 1: Retrieve the $num parameter from the query string
  233.         $num = $request->query->get('num');
  234.         
  235.         // Step 2: Check if $num is present; return an error if it's missing
  236.         if (!$num) {
  237.             return new JsonResponse(['error' => 'Missing num parameter'], 400);
  238.         }
  240.         // Step 3: Perform the database queries using $num
  241.         $queryBuilderGaccentry = $this->em->getEntity()->createQueryBuilder()
  242.             ->select('g.num', 'g.desvcr', 'g.accdat', 'g.observation_fcz_flag6','g.id')
  243.             ->from(outputGaccentries::class, 'g')
  244.             ->where('g.num = :num')
  245.             ->setParameter('num', $num);
  247.         $queryBuilderGaccentryd = $this->em->getEntity()->createQueryBuilder()
  248.             ->select('d.typ0', 'd.cce0', 'd.acc', 'd.bpr', 'd.amtcur', 'd.acc', 'd.sns', 'd.lin', 'd.id')
  249.             ->from(outputGaccentries::class, 'd')
  250.             ->where('d.num = :num')
  251.             ->setParameter('num', $num);
  253.         // Step 4: Execute the queries
  254.         $outputGaccentry = $queryBuilderGaccentry->getQuery()->getResult();
  255.         $outputGaccentryd = $queryBuilderGaccentryd->getQuery()->getResult();
  257.         // Step 5: Format the accdat field in the result
  258.         foreach ($outputGaccentry as &$entry) {
  259.             if ($entry['accdat'] instanceof \DateTime) {
  260.                 // Format the DateTime object to 'Y-m-d H:i:s.u' format
  261.                 $entry['accdat'] = $entry['accdat']->format('Y-m-d H:i:s');  // Example: '2024-01-02 00:00:00.0'
  262.             }
  263.         }
  265.         // Step 6: Prepare the data for the response
  266.         $data = [
  267.             'outputGaccentry' => $outputGaccentry,
  268.             'outputGaccentryd' => $outputGaccentryd,
  269.         ];
  271.         // Step 3: Send the formatted data as a JSON response
  272.         return new JsonResponse($data);
  273.     }
  275.     #[Route('/bpsupplier', name: 'opp_bpsupplier')]
  276.     public function bpsupplier(Request $request): JsonResponse
  277.     {
  278.         $bpsupplierAdonix = $this->em->getSage()->fetchAllAssociative("SELECT BPSNUM_0 , ENAFLG_0 FROM HCZ.BPSUPPLIER");
  280.         // Fetching all existing suppliers of type 'SUPPLIER' in one query
  281.         $bPartnerRepository = $this->em->getEntity()->getRepository(Bpartner::class);
  282.         $existingSuppliers  = $bPartnerRepository->findBy(['type' => 'SUPPLIER']);
  284.         // Creating a map of existing suppliers for fast lookup
  285.         $existingSuppliersMap = [];
  286.         foreach ($existingSuppliers as $supplier) {
  287.             $existingSuppliersMap[$supplier->getPartner()] = $supplier;
  288.         }
  290.         // Processing the bpsupplierAdonix data
  291.         foreach ($bpsupplierAdonix as $bpsupplier) {
  292.             $partner = $bpsupplier["BPSNUM_0"];
  293.             $active = $bpsupplier["ENAFLG_0"];
  295.             if (isset($existingSuppliersMap[$partner])) {
  296.                 $supplier = $existingSuppliersMap[$partner];
  297.                 if ($supplier->getActive() !== $active) {
  298.                     $supplier->setActive($active);
  299.                     $this->em->getEntity()->persist($supplier); // Persist only when there's a change
  300.                 }
  301.             } else {
  302.                 $creationSupplier = new Bpartner();
  303.                 $creationSupplier->setPartner($partner);
  304.                 $creationSupplier->setActive($active);
  305.                 $creationSupplier->setType("SUPPLIER");
  306.                 $this->em->getEntity()->persist($creationSupplier);
  307.             }
  308.         }
  310.         // Flush all changes at once
  311.         $this->em->getEntity()->flush();
  313.         return new JsonResponse(['message' => 'Process supplier completed successfully']);
  314.     }
  316.     #[Route('/bpcustomer', name: 'app_bpcustomer')]
  317.     public function bpcustomer(Request $request): Response
  318.     {
  320.         $bpcustomerAdonix = $this->em->getSage()->fetchAllAssociative("SELECT BPCNUM_0 , BPCSTA_0 FROM HCZ.BPCUSTOMER");
  322.         // Fetching all existing customers of type 'SUPPLIER' in one query
  323.         $bPartnerRepository = $this->em->getEntity()->getRepository(Bpartner::class);
  324.         $existingCustomers = $bPartnerRepository->findBy(['type' => 'CUSTOMER']);
  326.         // Creating a map of existing customers for fast lookup
  327.         $existingCustomersMap = [];
  328.         foreach ($existingCustomers as $customer) {
  329.             $existingCustomersMap[$customer->getPartner()] = $customer;
  330.         }
  332.         // Processing the bpcustomerAdonix data
  333.         foreach ($bpcustomerAdonix as $bpcustomer) {
  334.             $partner = $bpcustomer["BPCNUM_0"];
  335.             $active = $bpcustomer["BPCSTA_0"];
  337.             if (isset($existingCustomersMap[$partner])) {
  338.                 $customer = $existingCustomersMap[$partner];
  339.                 if ($customer->getActive() !== $active) {
  340.                     $customer->setActive($active);
  341.                     $this->em->getEntity()->persist($customer); // Persist only when there's a change
  342.                 }
  343.             } else {
  344.                 $creationCustomer = new Bpartner();
  345.                 $creationCustomer->setPartner($partner);
  346.                 $creationCustomer->setActive($active);
  347.                 $creationCustomer->setType("CUSTOMER");
  348.                 $this->em->getEntity()->persist($creationCustomer);
  349.             }
  350.         }
  352.         // Flush all changes at once
  353.         $this->em->getEntity()->flush();
  355.         return new JsonResponse(['message' => 'Process customer completed successfully']);
  356.     }
  358.     #[Route('/PieceControle', name: 'app_PieceControle')]
  359.     public function PieceControle(): Response
  360.     {
  361.         $conditionMet = false;
  363.         $Gaccentries  = $this->em->getEntity()->getRepository(outputGaccentries::class)->findPieceValid();
  364.         // dd($Gaccentries);
  365.             $sumArray = [];
  367.             foreach ($Gaccentries as $key => $Gac) {
  368.                 // fcz_flag6 = 8 Is Exsit In Table Comptabilité sage
  369.                 // dd($Gac);
  370.                 $num = $Gac->getNum();
  371.                 $RefCheck = $this->em->getSage()->fetchAllAssociative("SELECT REF_0,NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = '".$num."' ");
  372.                 foreach ($RefCheck as $key => $value) {
  373.                     if ($RefCheck) {
  374.                         $Gac->setObservationFczFlag6($value['NUM_0']);
  375.                         $Gac->setFczFlag6(8);
  376.                         $conditionMet = true;
  377.                     }
  378.                 }
  380.             // fcz_flag6 = 4 Is Exsit In dbcom 
  382.                 $NumCheck = $this->em->getDbcom()->fetchAllAssociative("SELECT NUM_0,NUMX3_0 FROM YGAS WHERE NUM_0 = '".$num."' ");
  383.                 // dd($NumCheck);
  384.                 foreach ($NumCheck as $key => $value) {
  385.                     if ($NumCheck) {
  386.                         $Gac->setObservationFczFlag6(empty($value['NUMX3_0']) ? $value['NUM_0'] : $Gac->getObservationFczFlag6());
  387.                         $Gac->setFczFlag6(4);
  388.                         $Gac->setFczFlag3(1);
  389.                         $conditionMet = true;
  390.                     }
  391.                 }
  393.             // fcz_flag6 = 9 Piece a Probleme 
  395.                 $jouCheck          = $Gac->getJou();
  396.                 $matchingJournals  = $this->em->getEntity()->getRepository(JOURNAL::class)->findJournal($jouCheck);
  397.                 if (!$matchingJournals) {
  398.                     $Gac->setObservationFczFlag6('JOURNAL N EXISTE PAS DANS SAGE' . ' ' . $jouCheck);
  399.                     $Gac->setFczFlag6(9);
  400.                     $conditionMet = true;
  401.                 } 
  403.                 $cpy1Check    = $Gac->getCpy1();
  404.                 $matchingCpy  = $this->em->getEntity()->getRepository(Partenaire::class)->findCpy($cpy1Check);
  405.                 if (!$matchingCpy) {
  406.                     $Gac->setObservationFczFlag6('DOSSIER N EXISTE PAS DANS SAGE' . ' ' . $cpy1Check);
  407.                     $Gac->setFczFlag6(9);
  408.                     $conditionMet = true;
  409.                 } 
  411.                 $fcy1Check    = $Gac->getFcy1();
  412.                 $matchingFcy  = $this->em->getEntity()->getRepository(Partenaire::class)->findFcy($fcy1Check);
  413.                 if (!$matchingFcy) {
  414.                     $Gac->setObservationFczFlag6('SOUS DOSSIER N EXISTE PAS DANS SAGE' . ' ' . $fcy1Check);
  415.                     $Gac->setFczFlag6(9);
  416.                     $conditionMet = true;
  417.                 } 
  419.                 if (strlen($Gac->getBprvcr()) > 20) {
  420.                     $Gac->setObservationFczFlag6('BPRVCR PLUS QUE 20: ' . $Gac->getBprvcr());
  421.                     $Gac->setFczFlag6(9);
  422.                     $conditionMet = true;
  423.                 }
  425.                 if ($Gac->getCur() != 'MAD') {
  426.                     $Gac->setObservationFczFlag6('DEVISE NON MAD' . ' ' . $Gac->getCur());
  427.                     $Gac->setFczFlag6(9);
  428.                     $conditionMet = true;
  429.                 }
  430.                 
  431.                 $Year = (int) $Gac->getAccdat()->format('Y');
  432.                 // if ($Year < 2023 || $Year > 2025 || $Year == 2023) {
  433.                 if ($Year < 2026 || $Year > 2026 || $Year == 2025) {
  434.                     $Gac->setObservationFczFlag6('DIFFÉRENCE DE DATE DE 2026');
  435.                     $Gac->setFczFlag6(9);
  436.                     $conditionMet = true;
  437.                 }
  439.                 if ($Gac->getDesvcr() && strpos($Gac->getDesvcr(), ';') !== false) {
  440.                     $Gac->setObservationFczFlag6('DÉSIGNATION AVEC POINT-VIRGULE');
  441.                     $Gac->setFczFlag6(9);
  442.                     $conditionMet = true;
  443.                 }
  445.                 if ($Gac->getAccdat()->format('Y-m-d H:i:s') !== $Gac->getDuddat()->format('Y-m-d H:i:s') || $Gac->getAccdat()->format('Y-m-d H:i:s') !== $Gac->getRatdat()->format('Y-m-d H:i:s') ) {
  446.                     // dd($Gac->getAccdat(),$Gad->getAccdat());
  447.                     $Gac->setObservationFczFlag6('DIFFÉRENCE DATE');
  448.                     $Gac->setFczFlag6(9);
  449.                     $conditionMet = true;
  450.                 }
  452.                 $typCheck = $Gac->getTyp1();
  453.                 $sum = "0";
  454.                 $matchingType  = $this->em->getEntity()->getRepository(JOURNAL::class)->findType($typCheck);
  456.                 if ($matchingType) {
  458.                     $Gaccentryds  = $Gac->getGaccentryds();
  459.                     // dd($Gaccentryds);
  460.                     if ($Gaccentryds->isEmpty()) {
  461.                         $Gac->setObservationFczFlag6('PIÈCE SANS DET');
  462.                         $Gac->setFczFlag6(9);
  463.                         $conditionMet = true;
  465.                     }else {
  466.                         foreach ($Gaccentryds as $key => $Gad) {
  467.                             // dd($Gad);
  468.                             if ($Gac->getTyp1() !== $Gad->getTyp0()) {
  469.                                 $Gac->setObservationFczFlag6('TYPES NE SONT PAS LES MÊMES' . ' ' .$Gac->getTyp1() . ' ' . $Gad->getTyp0() );
  470.                                 $Gac->setFczFlag6(9);
  471.                                 $conditionMet = true;
  472.                             }                        
  474.                             if ($Gac->getAccdat()->format('Y-m-d H:i:s') !== $Gad->getAccdat()->format('Y-m-d H:i:s')) {
  475.                                 // dd($Gac->getAccdat(),$Gad->getAccdat());
  476.                                 $Gac->setObservationFczFlag6('DIFFÉRENCE DATE CAB ET DET');
  477.                                 $Gac->setFczFlag6(9);
  478.                                 $conditionMet = true;
  479.                             }
  480.                             
  481.                             // dd("Hi date");
  482.                             if ($Gad->getAmtcur() < 0) {   
  483.                                 $Gac->setObservationFczFlag6('MONTANT NÉGATIF' . ' ' . $Gad->getAmtcur());
  484.                                 $Gac->setFczFlag6(9);
  485.                                 $conditionMet = true;
  486.                             }
  487.                             if ($Gad->getSns() !== 1 && $Gad->getSns() !== -1  ) {
  488.                                 $Gac->setObservationFczFlag6('SENS DIFFÉRENCE DE 1 ET -1' . ' ' . $Gad->getSns());
  489.                                 $Gac->setFczFlag6(9);
  490.                                 $conditionMet = true;
  491.                             }
  492.                             $cceCheck     = $Gad->getCce0();
  493.                             $matchingCce  = $this->em->getEntity()->getRepository(Partenaire::class)->findCce($cceCheck);
  494.                             if (!$matchingCce) {
  495.                                 $Gac->setObservationFczFlag6('CCE N EXISTE PAS DANS SAGE' . ' ' . $cceCheck);
  496.                                 $Gac->setFczFlag6(9);
  497.                                 $conditionMet = true;
  498.                             } 
  499.                             $accCheck     = $Gad->getAcc();
  500.                             $cleanaccCheck = str_replace(array("\r", "\n"), '', $accCheck);
  501.                             $matchingAcc  = $this->em->getEntity()->getRepository(CompteTier::class)->findAccByAcc($cleanaccCheck);
  502.                             if (!$matchingAcc) {
  503.                                 $Gac->setObservationFczFlag6('ACC N EXISTE PAS DANS SAGE' . ' ' . $Gad->getAcc());
  504.                                 $Gac->setFczFlag6(9);
  505.                                 $conditionMet = true;
  506.                             } 
  507.                             foreach ($matchingAcc as $key => $value) {
  508.                                 if ($value['sac'] == '2') {
  509.                                     if (substr($Gad->getAcc(), 0, 1) == '3') {
  510.                                         if ($Gad->getBpr()) {
  511.                                             $customerCheck = $Gad->getBpr();
  512.                                             $cleanaccCheckCustomer = str_replace(array("\r", "\n"), '', $customerCheck);
  513.                                             $matchingCustomer  = $this->em->getEntity()->getRepository(Bpartner::class)->findCustomer($cleanaccCheckCustomer);
  514.                                             if (!$matchingCustomer) {
  515.                                                 $Gac->setObservationFczFlag6('CLIENT N EXISTE PAS DANS SAGE ' . ' ' . $Gad->getBpr());
  516.                                                 $Gac->setFczFlag6(9);
  517.                                                 $conditionMet = true;
  518.                                                 // if ($matchingCustomer->getActive() == 1) {
  519.                                                 //     // dd($matchingSupplier);
  520.                                                 //     $Gac->setObservationFczFlag6('CUSTOMER NOT ACTIVE IN SAGE' . ' ' . $Gad->getBpr());
  521.                                                 //     $Gac->setFczFlag6(9);
  522.                                                 //     $conditionMet = true;
  523.                                                 // }
  524.                                                 
  525.                                             }
  526.                                             elseif ($matchingCustomer?->getActive() === 1) {
  527.                                                 // dd($matchingCustomer);
  528.                                                 $Gac->setObservationFczFlag6('CLIENT NON ACTIF DANS SAGE' . ' ' . $Gad->getBpr());
  529.                                                 $Gac->setFczFlag6(9);
  530.                                                 $conditionMet = true;
  531.                                             }
  532.                                         }else {
  533.                                             $Gac->setObservationFczFlag6('COMPTE CLIENT COLLECTIF SANS TIER' . ' ' . $Gad->getAcc());
  534.                                             $Gac->setFczFlag6(9);
  535.                                             $conditionMet = true;
  536.                                         }
  537.                                     }if (substr($Gad->getAcc(), 0, 1) == '4') {
  538.                                         if ($Gad->getBpr()) {
  539.                                             $supplierCheck    = $Gad->getBpr();
  540.                                             $cleanaccCheckSupplier = str_replace(array("\r", "\n"), '', $supplierCheck);
  541.                                             $matchingSupplier = $this->em->getEntity()->getRepository(Bpartner::class)->findSupplier($cleanaccCheckSupplier);
  542.                                             if (!$matchingSupplier) {
  543.                                                 $Gac->setObservationFczFlag6('FOURNISSEUR N EXISTE PAS DANS SAGE' . ' ' . $Gad->getBpr());
  544.                                                 $Gac->setFczFlag6(9);
  545.                                                 $conditionMet = true;
  546.                                             }
  547.                                             elseif ($matchingSupplier->getActive() == 1) {
  548.                                                 $Gac->setObservationFczFlag6('FOURNISSEUR NON ACTIF DANS SAGE' . ' ' . $Gad->getBpr());
  549.                                                 $Gac->setFczFlag6(9);
  550.                                                 $conditionMet = true;
  551.                                             }
  552.                                             //     dd($matchingSupplier);
  553.                                             // if ($matchingSupplier->getActive() == 1) {
  554.                                             //     // dd($matchingSupplier);
  555.                                             //     $Gac->setObservationFczFlag6('SUPPLIER NOT ACTIVE IN SAGE' . ' ' . $Gad->getBpr());
  556.                                             //     $Gac->setFczFlag6(9);
  557.                                             //     $conditionMet = true;
  558.                                             // }
  559.                                             // elseif($matchingSupplier->getActive() == null) {
  560.                                             //     $Gac->setObservationFczFlag6('SUPPLIER IS NUL' . ' ' . $Gad->getBpr());
  561.                                             //     $Gac->setFczFlag6(9);
  562.                                             //     $conditionMet = true;
  563.                                             // }
  564.                                         }else {
  565.                                             $Gac->setObservationFczFlag6('COMPTE FOURNISSEUR COLLECTIF SANS TIER' . ' ' . $Gad->getAcc());
  566.                                             $Gac->setFczFlag6(9);
  567.                                             $conditionMet = true;
  568.                                         }
  569.                                     }
  570.                                 }
  571.                                 $all_acc = substr($Gad->getAcc(), 0, 1);
  572.                                 if ($all_acc == '5' || $all_acc == '6' || $all_acc == '7' || $all_acc == '2' || $all_acc == '1') {
  573.                                     if ($Gad->getBpr()) {
  574.                                         // dd($Gac->getBpr());
  575.                                         $Gac->setObservationFczFlag6('COMPTE' . $Gad->getAcc() . 'AVEC TIER ' . $Gad->getBpr());
  576.                                         $Gac->setFczFlag6(9);
  577.                                         $conditionMet = true;
  578.                                     }
  579.                                 }
  580.                                 // if ($all_acc == '7' || $all_acc == '2' || $all_acc == '1') {
  581.                                 //     if ($Gad->getBpr()) {
  582.                                 //         $Gac->setObservationFczFlag6('ACC ' . $Gad->getAcc() . ' HAS TIER '. $Gad->getBpr());
  583.                                 //         $Gac->setFczFlag6(9);
  584.                                 //         $conditionMet = true;
  585.                                 //     }
  586.                                 // }
  587.                             }
  588.                             // $amtcur = round($Gad->getAmtcur(), 2);
  590.                             // if ($Gad->getSns() === -1) {
  591.                             //     $amtcur = -$amtcur;
  592.                             // }
  593.                         
  594.                             // $sum += $amtcur;
  595.                             // $amtcurFormatted = number_format($amtcur, 2, '.', ''); // Format as a number with two decimal places.
  596.                             // array_push($sumArray, $amtcurFormatted);
  598.                             $amtcur = $Gad->getAmtcur();
  599.                             $sens = $Gad->getSns();
  600.             
  601.                             $montant =$amtcur * $sens;
  603.                             $sum += $montant;
  604.                         }
  605.                 }
  606.                 $finalBalance = round($sum, 2); // Round to 2 decimal places for final balance
  608.                     if ($finalBalance != 0 || $finalBalance != -0 ) {
  609.                         $Gac->setObservationFczFlag6('PIECE DESEQUILIBREES' . ' ' . $finalBalance);
  610.                         $Gac->setFczFlag6(9);
  611.                         $conditionMet = true;
  612.                     }
  613.                 }else {
  614.                     $Gac->setObservationFczFlag6('TYPE DOES NOT EXIST' . ' ' . $typCheck);
  615.                     $Gac->setFczFlag6(9);
  616.                     $conditionMet = true;
  617.                 }
  618.                 // fcz_flag6 = 2 Piece Sans Probleme 
  620.                 if (!$conditionMet) {
  621.                     $Gac->setObservationFczFlag6('CONTROLLE DONE');
  622.                     $Gac->setFczFlag6(2);
  623.                 }
  625.                 $this->em->getEntity()->persist($Gac);
  626.             }
  627.             $this->em->getEntity()->flush();
  628.         return new Response('ok');
  629.     }
  631.     #[Route('/sage/inserted', name: 'app_sage_inserted')]
  632.     public function inserted()
  633.     {
  634.         try {
  635.             ini_set('memory_limit', '512M');
  636.             $this->em->getSage()->beginTransaction();
  637.             $this->em->getInterface()->beginTransaction();
  639.             $pieceCaImport = $this->em->getEntity()->getRepository(outputGaccentries::class)->findCAUgouv();
  640.             // dd($pieceCaImport);
  641.             if ($pieceCaImport) {
  642.                 foreach ($pieceCaImport as $piece) {
  644.                     $piece->setFczFlag5(1);
  645.                     $piece->setFczFlag3(7);
  646.                     $piece->setFczFlag6(2);
  648.                     $adonixGaccentry = new sageGaccentries();
  649.                         $adonixGaccentry->setUPDTICK0("1");
  650.                         $adonixGaccentry->setTYP0($piece->getTyp());
  651.                         $adonixGaccentry->setNUM0($piece->getNum());
  652.                         $adonixGaccentry->setCPY0($piece->getCpy1());
  653.                         $adonixGaccentry->setFCY0($piece->getFcy1());
  654.                         $adonixGaccentry->setJOU0($piece->getJou());
  655.                         $adonixGaccentry->setFIY0(11);
  656.                         $adonixGaccentry->setPER0(12);
  657.                         $adonixGaccentry->setBOLLATO0('');
  658.                         $adonixGaccentry->setYREFE30('');
  659.                         $adonixGaccentry->setYREFE20('');
  660.                         $adonixGaccentry->setYREFE10('');
  661.                         $adonixGaccentry->setYREFE0($piece->getId());
  662.                         $adonixGaccentry->setACCDAT0($this->dateString($piece->getAccdat()));
  663.                         $adonixGaccentry->setENTDAT0($this->dateString($piece->getAccdat()));
  664.                         $adonixGaccentry->setVALDAT0($this->dateString($piece->getAccdat()));
  665.                         $adonixGaccentry->setDUDDAT0($this->dateString($piece->getAccdat()));
  666.                         $adonixGaccentry->setBANDAT0($this->dateString($piece->getAccdat()));
  667.                         $adonixGaccentry->setRATDAT0($this->dateString($piece->getAccdat()));
  668.                         $adonixGaccentry->setCAT0(1);
  669.                         $adonixGaccentry->setSTA0(1);
  670.                         $adonixGaccentry->setFNLPSTDAT0('1753-01-01 00:00:00.000');
  671.                         $adonixGaccentry->setORIMOD0(2);
  672.                         $adonixGaccentry->setDACDIA0('STDCO');
  673.                         $adonixGaccentry->setFLGDAS0(1);
  674.                         $adonixGaccentry->setFLGFUP0(1);
  675.                         $adonixGaccentry->setFLGPAZ0(4);
  676.                         $adonixGaccentry->setFLGREP0(1);
  677.                         $adonixGaccentry->setFLGGEN0(1);
  678.                         $adonixGaccentry->setTYPDUD0(2);
  679.                         $adonixGaccentry->setBANCIB0('');
  680.                         $adonixGaccentry->setCUR0('MAD');
  681.                         $adonixGaccentry->setTYPRAT0(1);
  682.                         $adonixGaccentry->setLED0('RFG');
  683.                         $adonixGaccentry->setLED1('RFA');
  684.                         $adonixGaccentry->setLED2('');
  685.                         $adonixGaccentry->setLED3('');
  686.                         $adonixGaccentry->setLED4('');
  687.                         $adonixGaccentry->setLED5('');
  688.                         $adonixGaccentry->setLED6('');
  689.                         $adonixGaccentry->setLED7('');
  690.                         $adonixGaccentry->setLED8('');
  691.                         $adonixGaccentry->setLED9('');
  692.                         $adonixGaccentry->setCURLED0('MAD');
  693.                         $adonixGaccentry->setCURLED1('MAD');
  694.                         $adonixGaccentry->setCURLED2('');
  695.                         $adonixGaccentry->setCURLED3('');
  696.                         $adonixGaccentry->setCURLED4('');
  697.                         $adonixGaccentry->setCURLED5('');
  698.                         $adonixGaccentry->setCURLED6('');
  699.                         $adonixGaccentry->setCURLED7('');
  700.                         $adonixGaccentry->setCURLED8('');
  701.                         $adonixGaccentry->setCURLED9('');
  702.                         $adonixGaccentry->setRATMLT0(1);
  703.                         $adonixGaccentry->setRATMLT1(0);
  704.                         $adonixGaccentry->setRATMLT2(0);
  705.                         $adonixGaccentry->setRATMLT3(0);
  706.                         $adonixGaccentry->setRATMLT4(0);
  707.                         $adonixGaccentry->setRATMLT5(0);
  708.                         $adonixGaccentry->setRATMLT6(0);
  709.                         $adonixGaccentry->setRATMLT7(0);
  710.                         $adonixGaccentry->setRATMLT8(0);
  711.                         $adonixGaccentry->setRATMLT9(0);
  712.                         $adonixGaccentry->setRATDIV0(1);
  713.                         $adonixGaccentry->setRATDIV1(0);
  714.                         $adonixGaccentry->setRATDIV2(0);
  715.                         $adonixGaccentry->setRATDIV3(0);
  716.                         $adonixGaccentry->setRATDIV4(0);
  717.                         $adonixGaccentry->setRATDIV5(0);
  718.                         $adonixGaccentry->setRATDIV6(0);
  719.                         $adonixGaccentry->setRATDIV7(0);
  720.                         $adonixGaccentry->setRATDIV8(0);
  721.                         $adonixGaccentry->setRATDIV9(0);
  722.                         $adonixGaccentry->setDESVCR0($this->cleanText($piece->getDesvcr(), 100) ?? '');
  723.                         $adonixGaccentry->setREF0($piece->getRef());
  724.                         $adonixGaccentry->setBPRVCR0('');
  725.                         $adonixGaccentry->setBPRDATVCR0('1753-01-01 00:00:00.000');
  726.                         $adonixGaccentry->setREFSIM0('');
  727.                         $adonixGaccentry->setREFINT0('');
  728.                         $adonixGaccentry->setNUMDCL0(0);
  729.                         $adonixGaccentry->setRVS0(0);
  730.                         $adonixGaccentry->setRVSDAT0('1753-01-01 00:00:00.000');
  731.                         $adonixGaccentry->setRVSORITYP0('');
  732.                         $adonixGaccentry->setRVSORINUM0('');
  733.                         $adonixGaccentry->setEXPNUM0(1);
  734.                         $adonixGaccentry->setCREDAT0((new \DateTime())->format('Y-m-d'));
  735.                         $adonixGaccentry->setCREUSR0('AHAZ');
  736.                         $adonixGaccentry->setUPDDAT0((new \DateTime())->format('Y-m-d'));
  737.                         $adonixGaccentry->setUPDUSR0('AHAZ');
  738.                         $adonixGaccentry->setORIGIN0(3);
  739.                         $adonixGaccentry->setCREDATTIM0((new \DateTime())->format('Y-m-d H:i:s'));  // For current date and time
  740.                         $adonixGaccentry->setUPDDATTIM0((new \DateTime())->format('Y-m-d H:i:s'));
  741.                         $adonixGaccentry->setAUUID0(3);
  742.                         $adonixGaccentry->setFNLPSTNUM0('');
  743.                         $adonixGaccentry->setFNLPSTNUM1('');
  744.                         $adonixGaccentry->setFNLPSTNUM2('');
  745.                         $adonixGaccentry->setFNLPSTNUM3('');
  746.                         $adonixGaccentry->setFNLPSTNUM4('');
  747.                         $adonixGaccentry->setFNLPSTNUM5('');
  748.                         $adonixGaccentry->setFNLPSTNUM6('');
  749.                         $adonixGaccentry->setFNLPSTNUM7('');
  750.                         $adonixGaccentry->setFNLPSTNUM8('');
  751.                         $adonixGaccentry->setFNLPSTNUM9('');
  752.                         $adonixGaccentry->setPJT0('');
  753.                         $adonixGaccentry->setORICOD0("YGASANA");
  754.                         $adonixGaccentry->setYPCNUM0($piece->getCode());
  755.                         $adonixGaccentry->setYFLG0(0);
  756.                     $this->em->getAdonix()->persist($adonixGaccentry);
  758.                     foreach ($piece->getGaccentryds() as $key => $det) {
  759.                         $adonixGaccentrydPcg = new sageGaccentryd();
  760.                             $adonixGaccentrydPcg->setUPDTICK0(1);
  761.                             $adonixGaccentrydPcg->setTYP0($det->getTyp0());
  762.                             $adonixGaccentrydPcg->setNUM0($det->getNum());
  763.                             $adonixGaccentrydPcg->setLIN0($det->getLin());
  764.                             $adonixGaccentrydPcg->setLEDTYP0(1);
  765.                             $adonixGaccentrydPcg->setLED0('RFG');
  766.                             $adonixGaccentrydPcg->setACCNUM0($det->getPcg());
  767.                             $adonixGaccentrydPcg->setCHRNUM0('');
  768.                             $adonixGaccentrydPcg->setIDTLIN0($det->getLin());
  769.                             $adonixGaccentrydPcg->setCPY0($piece->getCpy1());
  770.                             $adonixGaccentrydPcg->setFCYLIN0($piece->getFcy1());
  771.                             $adonixGaccentrydPcg->setACCDAT0($this->dateString($piece->getAccdat()));
  772.                             $adonixGaccentrydPcg->setFIY0(11);
  773.                             $adonixGaccentrydPcg->setPER0(12);
  774.                             $adonixGaccentrydPcg->setCOA0('PCG');
  775.                             $adonixGaccentrydPcg->setSAC0($det->getSac() ?? '');
  776.                             $adonixGaccentrydPcg->setACC0($det->getAcc());
  777.                             $adonixGaccentrydPcg->setBPR0($det->getBpr() ?? '');
  778.                             $adonixGaccentrydPcg->setDSP0('');
  779.                             $adonixGaccentrydPcg->setSNS0($det->getSns());
  780.                             $adonixGaccentrydPcg->setCUR0('MAD');
  781.                             $adonixGaccentrydPcg->setAMTCUR0($det->getamtcur());
  782.                             $adonixGaccentrydPcg->setCURLED0('MAD');
  783.                             $adonixGaccentrydPcg->setAMTLED0($det->getamtcur());
  784.                             $adonixGaccentrydPcg->setAMTFLG0(0);
  785.                             $adonixGaccentrydPcg->setAMTLED10(0);
  786.                             $adonixGaccentrydPcg->setUOM0('');
  787.                             $adonixGaccentrydPcg->setQTY0(1);
  788.                             $adonixGaccentrydPcg->setDES0($this->cleanText($det->getDes(), 100) ?? '');
  789.                             $adonixGaccentrydPcg->setREFINTLIN0('');
  790.                             $adonixGaccentrydPcg->setOFFACC0('');
  791.                             $adonixGaccentrydPcg->setCSLCOD0('');
  792.                             $adonixGaccentrydPcg->setCSLFLO0('');
  793.                             $adonixGaccentrydPcg->setSTT10('');
  794.                             $adonixGaccentrydPcg->setSTT20('');
  795.                             $adonixGaccentrydPcg->setSTT30('');
  796.                             $adonixGaccentrydPcg->setMTC0('');
  797.                             $adonixGaccentrydPcg->setMTCDAT0('1753-01-01 00:00:00');
  798.                             $adonixGaccentrydPcg->setMTCDATMIN0('1753-01-01 00:00:00');
  799.                             $adonixGaccentrydPcg->setMTCDATMAX0('1753-01-01 00:00:00');
  800.                             $adonixGaccentrydPcg->setFLGMTC0(0);
  801.                             $adonixGaccentrydPcg->setFREREF0($det->getFreref0() ?? '');
  802.                             $adonixGaccentrydPcg->setCHK0('');
  803.                             $adonixGaccentrydPcg->setCHKDAT0('1753-01-01 00:00:00');
  804.                             $adonixGaccentrydPcg->setMRK0('');
  805.                             $adonixGaccentrydPcg->setTAX0('');
  806.                             $adonixGaccentrydPcg->setTAX20('');
  807.                             $adonixGaccentrydPcg->setTAX30('');
  808.                             $adonixGaccentrydPcg->setAMTVAT0(0);
  809.                             $adonixGaccentrydPcg->setINDEDVAT0(0);
  810.                             $adonixGaccentrydPcg->setEXPNUM0(1);
  811.                             $adonixGaccentrydPcg->setACCNUMORI0(0);
  812.                             $adonixGaccentrydPcg->setACCNUMDOE0(0);
  813.                             $adonixGaccentrydPcg->setCAPFLOTYP0('');
  814.                             $adonixGaccentrydPcg->setVATRAT0(0);
  815.                             $adonixGaccentrydPcg->setVATDEDRAT0(0);
  816.                             $adonixGaccentrydPcg->setCREDATTIM0((new \DateTime())->format('Y-m-d H:i:s'));
  817.                             $adonixGaccentrydPcg->setUPDDATTIM0((new \DateTime())->format('Y-m-d H:i:s'));
  818.                             $adonixGaccentrydPcg->setAUUID0(3);
  819.                             $adonixGaccentrydPcg->setCREUSR0('AHAZ');
  820.                             $adonixGaccentrydPcg->setUPDUSR0('AHAZ');
  821.                             $adonixGaccentrydPcg->setCSLBPR0('');
  822.                             $adonixGaccentrydPcg->setPJTLIN0('');
  823.                             $adonixGaccentrydPcg->setPCCCOD0('');
  824.                             $adonixGaccentrydPcg->setBSITRS0('');
  825.                             $adonixGaccentrydPcg->setYLETTR0('');
  826.                             $adonixGaccentrydPcg->setYBPCANC0('');
  827.                             $adonixGaccentrydPcg->setYREFE0($piece->getId());
  828.                             $adonixGaccentrydPcg->setYREFE10($det->getId());
  829.                             $adonixGaccentrydPcg->setYREFE20('');
  830.                             $adonixGaccentrydPcg->setYREFE30(mb_substr($det->getFczAccLibelle() ?? '', 0, 55));
  831.                             $adonixGaccentrydPcg->setAMTCURHIS0(0);
  832.                             $adonixGaccentrydPcg->setCCE00($det->getcce0());
  833.                             $adonixGaccentrydPcg->setBPRINIT0($det->getBpr() ?? '');
  834.                             $adonixGaccentrydPcg->setHISACC0($det->getAcc());
  835.                             
  836.                             
  838.                         $this->em->getAdonix()->persist($adonixGaccentrydPcg);
  840.                         $adonixGaccentrydPca = clone $adonixGaccentrydPcg;
  841.                             $adonixGaccentrydPca->setBPR0('');
  842.                             $adonixGaccentrydPca->setSAC0('');
  843.                             $adonixGaccentrydPca->setLED0('RFA');
  844.                             $adonixGaccentrydPca->setCOA0('PCA');
  845.                             $adonixGaccentrydPca->setACCNUM0($det->getPca());
  846.                             $adonixGaccentrydPca->setLEDTYP0(2);
  847.                         $this->em->getAdonix()->persist($adonixGaccentrydPca);
  849.                         $adonixGaccentrya = new GACCENTRYA();
  850.                             $adonixGaccentrya->setUPDTICK0(1);
  851.                             $adonixGaccentrya->setTYP0($det->getTyp0());
  852.                             $adonixGaccentrya->setNUM0($det->getNum());
  853.                             $adonixGaccentrya->setLIN0($det->getLin());
  854.                             $adonixGaccentrya->setLEDTYP0(2);
  855.                             $adonixGaccentrya->setANALIN0(1);
  856.                             $adonixGaccentrya->setIDTLIN0($det->getLin());
  857.                             $adonixGaccentrya->setLED0('RFA');
  858.                             $adonixGaccentrya->setCPY0($piece->getCpy1());
  859.                             $adonixGaccentrya->setFCYLIN0($piece->getFcy1());
  860.                             $adonixGaccentrya->setACCDAT0($this->dateString($piece->getAccdat()));
  861.                             $adonixGaccentrya->setACCNUM0($det->getPca());
  862.                             $adonixGaccentrya->setCOA0('PCA');
  863.                             $adonixGaccentrya->setACC0($det->getAcc());
  864.                             $adonixGaccentrya->setBPR0('');
  865.                             $adonixGaccentrya->setDIE0('CCT');
  866.                             $adonixGaccentrya->setDIE1('');
  867.                             $adonixGaccentrya->setDIE2('');
  868.                             $adonixGaccentrya->setDIE3('');
  869.                             $adonixGaccentrya->setDIE4('');
  870.                             $adonixGaccentrya->setDIE5('');
  871.                             $adonixGaccentrya->setDIE6('');
  872.                             $adonixGaccentrya->setDIE7('');
  873.                             $adonixGaccentrya->setDIE8('');
  874.                             $adonixGaccentrya->setCCE0($det->getcce0());
  875.                             $adonixGaccentrya->setCCE1('');
  876.                             $adonixGaccentrya->setCCE2('');
  877.                             $adonixGaccentrya->setCCE3('');
  878.                             $adonixGaccentrya->setCCE4('');
  879.                             $adonixGaccentrya->setCCE5('');
  880.                             $adonixGaccentrya->setCCE6('');
  881.                             $adonixGaccentrya->setCCE7('');
  882.                             $adonixGaccentrya->setCCE8('');
  883.                             $adonixGaccentrya->setSNS0($det->getSns());
  884.                             $adonixGaccentrya->setCUR0('MAD');
  885.                             $adonixGaccentrya->setAMTCUR0($det->getamtcur());
  886.                             $adonixGaccentrya->setCURLED0('MAD');
  887.                             $adonixGaccentrya->setAMTLED0($det->getamtcur());
  888.                             $adonixGaccentrya->setUOM0('');
  889.                             $adonixGaccentrya->setQTY0(0);
  890.                             $adonixGaccentrya->setACCNUMDOE0(0);
  891.                             $adonixGaccentrya->setCREDATTIM0((new \DateTime())->format('Y-m-d H:i:s'));
  892.                             $adonixGaccentrya->setUPDDATTIM0((new \DateTime())->format('Y-m-d H:i:s'));
  893.                             $adonixGaccentrya->setAUUID0(3);
  894.                             $adonixGaccentrya->setCREUSR0('ADMIN');
  895.                             $adonixGaccentrya->setUPDUSR0('ADMIN');
  896.                             $adonixGaccentrya->setYREFE0(0);
  897.                             $adonixGaccentrya->setYREFE10(0);
  898.                             $adonixGaccentrya->setYREFE20('');
  899.                             $adonixGaccentrya->setYREFE30('');
  900.                             $adonixGaccentrya->setAMTCURHIS0(0);
  901.                             $adonixGaccentrya->setHISACC0('');
  902.                         $this->em->getAdonix()->persist($adonixGaccentrya);
  904.                         if (!empty($det->getBpr())) {
  905.                             // dd("gaccdudate");
  907.                             $ACCNUM1 = $det->getPcg();
  908.                             $A7 = "1";
  909.                             $NUMDUD_0 = $ACCNUM1 . '/' . $A7;
  911.                             $adonixGaccdudate = new GACCDUDATE();
  912.                                 $adonixGaccdudate->setUPDTICK0(1);
  913.                                 $adonixGaccdudate->setTYP0($det->getTyp0());
  914.                                 $adonixGaccdudate->setNUM0($det->getNum());
  915.                                 $adonixGaccdudate->setLIG0($det->getLin());
  916.                                 $adonixGaccdudate->setDUDLIG0(1);
  917.                                 $adonixGaccdudate->setACCNUM0($det->getPcg());
  918.                                 $adonixGaccdudate->setCPY0($piece->getCpy1());
  919.                                 $adonixGaccdudate->setFCY0($piece->getFcy1());
  920.                                 $adonixGaccdudate->setCUR0('MAD');
  921.                                 $adonixGaccdudate->setSAC0($det->getSac());
  922.                                 $adonixGaccdudate->setBPR0($det->getBpr());
  923.                                 $adonixGaccdudate->setBPRTYP0(2);
  924.                                 $adonixGaccdudate->setBPRPAY0($det->getBpr());
  925.                                 $adonixGaccdudate->setBPAPAY0('A01');
  926.                                 $adonixGaccdudate->setDUDDAT0($this->dateString($piece->getAccdat()));
  927.                                 $adonixGaccdudate->setPAM0('CHQ');
  928.                                 $adonixGaccdudate->setPAMTYP0(1);
  929.                                 $adonixGaccdudate->setDEP0('');
  930.                                 $adonixGaccdudate->setSNS0($det->getSns());
  931.                                 $adonixGaccdudate->setAMTCUR0($det->getAmtcur());
  932.                                 $adonixGaccdudate->setAMTLOC0($det->getAmtcur());
  933.                                 $adonixGaccdudate->setPAYCUR0(0);
  934.                                 $adonixGaccdudate->setPAYLOC0(0);
  935.                                 $adonixGaccdudate->setTMPCUR0(0);
  936.                                 $adonixGaccdudate->setTMPLOC0(0);
  937.                                 $adonixGaccdudate->setFLGFUP0(0);
  938.                                 $adonixGaccdudate->setLEVFUP0(0);
  939.                                 $adonixGaccdudate->setDATFUP0('1753-01-01 00:00:00');
  940.                                 $adonixGaccdudate->setDPTCOD0('');
  941.                                 $adonixGaccdudate->setFLGPAZ0(4);
  942.                                 $adonixGaccdudate->setSOI0(1);
  943.                                 $adonixGaccdudate->setSOINUM0('');
  944.                                 $adonixGaccdudate->setDUDSTA0(2);
  945.                                 $adonixGaccdudate->setDINAMT0(0);
  946.                                 $adonixGaccdudate->setIBDAMT0(0);
  947.                                 $adonixGaccdudate->setVAT0(0);
  948.                                 $adonixGaccdudate->setFIY0(11);
  949.                                 $adonixGaccdudate->setPER0(12);
  950.                                 $adonixGaccdudate->setEXPSENDAT0('1753-01-01 00:00:00');
  951.                                 $adonixGaccdudate->setSENDAT0('1753-01-01 00:00:00');
  952.                                 $adonixGaccdudate->setSENINS0(0);
  953.                                 $adonixGaccdudate->setBPRFCT0('');
  954.                                 $adonixGaccdudate->setFCTVCR0('');
  955.                                 $adonixGaccdudate->setFLGCLE0(1);
  956.                                 $adonixGaccdudate->setPAYDAT0('1753-01-01 00:00:00');
  957.                                 $adonixGaccdudate->setTYPDUD0(3);
  958.                                 $adonixGaccdudate->setNUMDUD0($NUMDUD_0);
  959.                                 $adonixGaccdudate->setCREDAT0((new \DateTime())->format('Y-m-d'));
  960.                                 $adonixGaccdudate->setCREUSR0('AHAZ');
  961.                                 $adonixGaccdudate->setCREDATTIM0((new \DateTime())->format('Y-m-d H:i:s'));
  962.                                 $adonixGaccdudate->setUPDDATTIM0((new \DateTime())->format('Y-m-d H:i:s'));
  963.                                 $adonixGaccdudate->setAUUID0(3);
  964.                                 $adonixGaccdudate->setUPDUSR0('AHAZ');
  965.                                 $adonixGaccdudate->setUMRNUM0('');
  966.                                 $adonixGaccdudate->setBELVCS0('');
  967.                                 $adonixGaccdudate->setBIDNUMMAN0('');
  968.                                 $adonixGaccdudate->setBADBTRULE0(0);
  969.                                 $adonixGaccdudate->setYREFE0(0);
  970.                                 $adonixGaccdudate->setYREFE10(0);
  971.                                 $adonixGaccdudate->setYREFE20('');
  972.                                 $adonixGaccdudate->setYREFE30('');
  973.                                 $adonixGaccdudate->setAMTCURHIS0(0);
  974.                                 $adonixGaccdudate->setHISACC0('');
  975.                             $this->em->getAdonix()->persist($adonixGaccdudate);
  976.                             // dd("gaccdudateHi");
  978.                         }else {
  979.                             continue;
  980.                         }
  981.                     }
  982.                 }
  983.             }
  984.             // dd($adonixGaccdudate);
  985.             $this->em->getAdonix()->flush();
  986.             $this->em->getEntity()->flush();
  987.             $this->em->getInterface()->commit();
  989.         } catch (Exception $e) {
  990.             // dd($e);
  991.             $this->em->getInterface()->rollBack();
  993.             $this->em->getAdonix()->clear();
  995.             // continue;
  996.             return new JsonResponse("Error: " . $e->getMessage());
  997.         }
  998.         return new JsonResponse('ok');
  999.     }
  1001.     function dateString($date){
  1002.                 
  1003.         if($date)
  1004.             if ($date->format('Y') == '-0001' )  return '';
  1005.             else return $date->format('Y-m-d') ;
  1006.         else return '';
  1007.     }
  1009.     private function cleanText(?string $text, int $max = 100): ?string
  1010.     {
  1011.         if(!$text){
  1012.             return null;
  1013.         }
  1015.         $text = str_replace("'", "", $text);
  1016.         $text = mb_substr($text, 0, $max);
  1018.         return $text;
  1019.     }
  1021. }