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