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