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\Bpartner;
  7. use App\Entity\Gaccentry;
  8. use App\Entity\CompteTier;
  9. use App\Entity\Gaccentryd;
  10. use App\Entity\Partenaire;
  11. use Psr\Log\LoggerInterface;
  12. use Doctrine\DBAL\Connection;
  13. use Doctrine\ORM\Query\Expr\Join;
  14. use App\Service\ConnectionService;
  15. use Doctrine\Persistence\ManagerRegistry;
  16. use Symfony\Component\HttpFoundation\Request;
  17. use Symfony\Component\HttpFoundation\Response;
  18. use Symfony\Component\Routing\Annotation\Route;
  19. use Symfony\Component\HttpFoundation\JsonResponse;
  20. use Symfony\Contracts\HttpClient\HttpClientInterface;
  21. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  23. class EDIController extends AbstractController
  24. {
  26.     private $em;
  28.     public function __construct(ConnectionService $em)
  29.     {
  30.         $this->em = $em;
  31.     }
  33.     #[Route('/edi', name: 'app_edi')]
  34.     public function index(): Response
  35.     {
  36.         return $this->render('edi/index.html.twig', [
  37.             'controller_name' => 'EDIController',
  38.         ]);
  39.     }
  41.     #[Route('/getCodeAdonix', name: 'app_getCodeAdonix')]
  42.     public function getCodeAdonix(): Response
  43.     {
  44.         $results = $this->em->getEntity()->getRepository(Gaccentry::class)->findByDate(); // Adjust the method to match your repository
  45.         // dd($results);
  46.         foreach ($results as $entry) {
  47.             // Access properties using getters or directly
  48.             $num = $entry->getNum(); // Assuming you have a getNum() method
  49.     
  50.             // Use $num in your SQL query
  51.             $searchAdonix = $this->em->getSage()->fetchAllAssociative("SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = '".$num."' ");
  52.             
  53.             if ($searchAdonix) {
  54.                 # code...
  55.                 // dd($searchAdonix);
  57.                 $entry->setObservationFczFlag6($searchAdonix[0]['NUM_0']);
  58.                 $entry->setFczFlag6(8);
  59.                 $this->em->getEntity()->persist($entry);
  60.                 
  61.             }
  62.         }
  63.         $this->em->getEntity()->flush();
  64.         return new Response('ok');
  66.     }
  67.     
  71.     #[Route('/PieceControle', name: 'app_PieceControle')]
  72.     public function PieceControle(): Response
  73.     {
  74.         $conditionMet = false;
  76.         $Gaccentries  = $this->em->getEntity()->getRepository(Gaccentry::class)->findPieceValid();
  77.         // dd($Gaccentries);
  78.             $sumArray = [];
  80.             foreach ($Gaccentries as $key => $Gac) {
  81.                 // fcz_flag6 = 8 Is Exsit In Table Comptabilité sage
  82.                 $num = $Gac->getNum();
  83.                 $RefCheck = $this->em->getSage()->fetchAllAssociative("SELECT REF_0,NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = '".$num."' ");
  84.                 foreach ($RefCheck as $key => $value) {
  85.                     if ($RefCheck) {
  86.                         $Gac->setObservationFczFlag6($value['NUM_0']);
  87.                         $Gac->setFczFlag6(8);
  88.                         $conditionMet = true;
  89.                     }
  90.                 }
  92.             // fcz_flag6 = 4 Is Exsit In dbcom 
  94.                 $NumCheck = $this->em->getDbcom()->fetchAllAssociative("SELECT NUM_0,NUMX3_0 FROM YGAS WHERE NUM_0 = '".$num."' ");
  95.                 // dd($NumCheck);
  96.                 foreach ($NumCheck as $key => $value) {
  97.                     if ($NumCheck) {
  98.                         $Gac->setObservationFczFlag6(empty($value['NUMX3_0']) ? $value['NUM_0'] : $Gac->getObservationFczFlag6());
  99.                         $Gac->setFczFlag6(4);
  100.                         $Gac->setFczFlag3(1);
  101.                         $conditionMet = true;
  102.                     }
  103.                 }
  105.             // fcz_flag6 = 9 Piece a Probleme 
  107.                 $jouCheck          = $Gac->getJou();
  108.                 $matchingJournals  = $this->em->getEntity()->getRepository(JOURNAL::class)->findJournal($jouCheck);
  109.                 if (!$matchingJournals) {
  110.                     $Gac->setObservationFczFlag6('JOURNAL N EXISTE PAS DANS SAGE' . ' ' . $jouCheck);
  111.                     $Gac->setFczFlag6(9);
  112.                     $conditionMet = true;
  113.                 } 
  115.                 $cpy1Check    = $Gac->getCpy1();
  116.                 $matchingCpy  = $this->em->getEntity()->getRepository(Partenaire::class)->findCpy($cpy1Check);
  117.                 if (!$matchingCpy) {
  118.                     $Gac->setObservationFczFlag6('DOSSIER N EXISTE PAS DANS SAGE' . ' ' . $cpy1Check);
  119.                     $Gac->setFczFlag6(9);
  120.                     $conditionMet = true;
  121.                 } 
  123.                 $fcy1Check    = $Gac->getFcy1();
  124.                 $matchingFcy  = $this->em->getEntity()->getRepository(Partenaire::class)->findFcy($fcy1Check);
  125.                 if (!$matchingFcy) {
  126.                     $Gac->setObservationFczFlag6('SOUS DOSSIER N EXISTE PAS DANS SAGE' . ' ' . $fcy1Check);
  127.                     $Gac->setFczFlag6(9);
  128.                     $conditionMet = true;
  129.                 } 
  131.                 if ($Gac->getCur() != 'MAD') {
  132.                     $Gac->setObservationFczFlag6('DEVISE NON MAD' . ' ' . $Gac->getCur());
  133.                     $Gac->setFczFlag6(9);
  134.                     $conditionMet = true;
  135.                 }
  136.                 
  137.                 $Year = (int) $Gac->getAccdat()->format('Y');
  138.                 if ($Year < 2023 || $Year > 2024 || $Year == 2023) {
  139.                 // if ($Year < 2023 || $Year > 2024 ) {
  140.                     // dd('Hi');
  141.                     $Gac->setObservationFczFlag6('DIFFÉRENCE DE DATE DE 2024');
  142.                     $Gac->setFczFlag6(9);
  143.                     $conditionMet = true;
  144.                 }
  146.                 if ($Gac->getDesvcr() && strpos($Gac->getDesvcr(), ';') !== false) {
  147.                     $Gac->setObservationFczFlag6('DÉSIGNATION AVEC POINT-VIRGULE');
  148.                     $Gac->setFczFlag6(9);
  149.                     $conditionMet = true;
  150.                 }
  152.                 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') ) {
  153.                     // dd($Gac->getAccdat(),$Gad->getAccdat());
  154.                     $Gac->setObservationFczFlag6('DIFFÉRENCE DATE');
  155.                     $Gac->setFczFlag6(9);
  156.                     $conditionMet = true;
  157.                 }
  159.                 $typCheck = $Gac->getTyp1();
  160.                 $sum = "0";
  161.                 $matchingType  = $this->em->getEntity()->getRepository(JOURNAL::class)->findType($typCheck);
  163.                 if ($matchingType) {
  165.                     $Gaccentryds  = $Gac->getGaccentryds();
  167.                     if ($Gaccentryds->isEmpty()) {
  168.                         $Gac->setObservationFczFlag6('PIÈCE SANS DET');
  169.                         $Gac->setFczFlag6(9);
  170.                         $conditionMet = true;
  172.                     }else {
  173.                         foreach ($Gaccentryds as $key => $Gad) {
  175.                             if ($Gac->getTyp1() !== $Gad->getTyp0()) {
  176.                                 $Gac->setObservationFczFlag6('TYPES NE SONT PAS LES MÊMES' . ' ' .$Gac->getTyp1() . ' ' . $Gad->getTyp0() );
  177.                                 $Gac->setFczFlag6(9);
  178.                                 $conditionMet = true;
  179.                             }
  181.                             if ($Gac->getAccdat()->format('Y-m-d H:i:s') !== $Gad->getAccdat()->format('Y-m-d H:i:s')) {
  182.                                 // dd($Gac->getAccdat(),$Gad->getAccdat());
  183.                                 $Gac->setObservationFczFlag6('DIFFÉRENCE DE 2024');
  184.                                 $Gac->setFczFlag6(9);
  185.                                 $conditionMet = true;
  186.                             }
  187.                             
  188.                             // dd("Hi date");
  189.                             if ($Gad->getAmtcur() < 0) {   
  190.                                 $Gac->setObservationFczFlag6('MONTANT NÉGATIF' . ' ' . $Gad->getAmtcur());
  191.                                 $Gac->setFczFlag6(9);
  192.                                 $conditionMet = true;
  193.                             }
  194.                             if ($Gad->getSns() !== 1 && $Gad->getSns() !== -1  ) {
  195.                                 $Gac->setObservationFczFlag6('SENS DIFFÉRENCE DE 1 ET -1' . ' ' . $Gad->getSns());
  196.                                 $Gac->setFczFlag6(9);
  197.                                 $conditionMet = true;
  198.                             }
  199.                             $cceCheck     = $Gad->getCce0();
  200.                             $matchingCce  = $this->em->getEntity()->getRepository(Partenaire::class)->findCce($cceCheck);
  201.                             if (!$matchingCce) {
  202.                                 $Gac->setObservationFczFlag6('CCE N EXISTE PAS DANS SAGE' . ' ' . $cceCheck);
  203.                                 $Gac->setFczFlag6(9);
  204.                                 $conditionMet = true;
  205.                             } 
  206.                             $accCheck     = $Gad->getAcc();
  207.                             $cleanaccCheck = str_replace(array("\r", "\n"), '', $accCheck);
  208.                             $matchingAcc  = $this->em->getEntity()->getRepository(CompteTier::class)->findAccByAcc($cleanaccCheck);
  209.                             if (!$matchingAcc) {
  210.                                 $Gac->setObservationFczFlag6('ACC N EXISTE PAS DANS SAGE' . ' ' . $Gad->getAcc());
  211.                                 $Gac->setFczFlag6(9);
  212.                                 $conditionMet = true;
  213.                             } 
  214.                             foreach ($matchingAcc as $key => $value) {
  215.                                 if ($value['sac'] == '2') {
  216.                                     if (substr($Gad->getAcc(), 0, 1) == '3') {
  217.                                         if ($Gad->getBpr()) {
  218.                                             $customerCheck = $Gad->getBpr();
  219.                                             $cleanaccCheckCustomer = str_replace(array("\r", "\n"), '', $customerCheck);
  220.                                             $matchingCustomer  = $this->em->getEntity()->getRepository(Bpartner::class)->findCustomer($cleanaccCheckCustomer);
  221.                                             if (!$matchingCustomer) {
  222.                                                 $Gac->setObservationFczFlag6('CLIENT N EXISTE PAS DANS SAGE ' . ' ' . $Gad->getBpr());
  223.                                                 $Gac->setFczFlag6(9);
  224.                                                 $conditionMet = true;
  225.                                                 // if ($matchingCustomer->getActive() == 1) {
  226.                                                 //     // dd($matchingSupplier);
  227.                                                 //     $Gac->setObservationFczFlag6('CUSTOMER NOT ACTIVE IN SAGE' . ' ' . $Gad->getBpr());
  228.                                                 //     $Gac->setFczFlag6(9);
  229.                                                 //     $conditionMet = true;
  230.                                                 // }
  231.                                                 
  232.                                             }
  233.                                             elseif ($matchingCustomer?->getActive() === 1) {
  234.                                                 // dd($matchingCustomer);
  235.                                                 $Gac->setObservationFczFlag6('CLIENT NON ACTIF DANS SAGE' . ' ' . $Gad->getBpr());
  236.                                                 $Gac->setFczFlag6(9);
  237.                                                 $conditionMet = true;
  238.                                             }
  239.                                         }else {
  240.                                             $Gac->setObservationFczFlag6('COMPTE CLIENT COLLECTIF SANS TIER' . ' ' . $Gad->getAcc());
  241.                                             $Gac->setFczFlag6(9);
  242.                                             $conditionMet = true;
  243.                                         }
  244.                                     }if (substr($Gad->getAcc(), 0, 1) == '4') {
  245.                                         if ($Gad->getBpr()) {
  246.                                             $supplierCheck    = $Gad->getBpr();
  247.                                             $cleanaccCheckSupplier = str_replace(array("\r", "\n"), '', $supplierCheck);
  248.                                             $matchingSupplier = $this->em->getEntity()->getRepository(Bpartner::class)->findSupplier($cleanaccCheckSupplier);
  249.                                             if (!$matchingSupplier) {
  250.                                                 $Gac->setObservationFczFlag6('FOURNISSEUR N EXISTE PAS DANS SAGE' . ' ' . $Gad->getBpr());
  251.                                                 $Gac->setFczFlag6(9);
  252.                                                 $conditionMet = true;
  253.                                             }
  254.                                             elseif ($matchingSupplier->getActive() == 1) {
  255.                                                 $Gac->setObservationFczFlag6('FOURNISSEUR NON ACTIF DANS SAGE' . ' ' . $Gad->getBpr());
  256.                                                 $Gac->setFczFlag6(9);
  257.                                                 $conditionMet = true;
  258.                                             }
  259.                                             //     dd($matchingSupplier);
  260.                                             // if ($matchingSupplier->getActive() == 1) {
  261.                                             //     // dd($matchingSupplier);
  262.                                             //     $Gac->setObservationFczFlag6('SUPPLIER NOT ACTIVE IN SAGE' . ' ' . $Gad->getBpr());
  263.                                             //     $Gac->setFczFlag6(9);
  264.                                             //     $conditionMet = true;
  265.                                             // }
  266.                                             // elseif($matchingSupplier->getActive() == null) {
  267.                                             //     $Gac->setObservationFczFlag6('SUPPLIER IS NUL' . ' ' . $Gad->getBpr());
  268.                                             //     $Gac->setFczFlag6(9);
  269.                                             //     $conditionMet = true;
  270.                                             // }
  271.                                         }else {
  272.                                             $Gac->setObservationFczFlag6('COMPTE FOURNISSEUR COLLECTIF SANS TIER' . ' ' . $Gad->getAcc());
  273.                                             $Gac->setFczFlag6(9);
  274.                                             $conditionMet = true;
  275.                                         }
  276.                                     }
  277.                                 }
  278.                                 $all_acc = substr($Gad->getAcc(), 0, 1);
  279.                                 if ($all_acc == '5' || $all_acc == '6' || $all_acc == '7' || $all_acc == '2' || $all_acc == '1') {
  280.                                     if ($Gad->getBpr()) {
  281.                                         // dd($Gac->getBpr());
  282.                                         $Gac->setObservationFczFlag6('COMPTE' . $Gad->getAcc() . 'AVEC TIER ' . $Gad->getBpr());
  283.                                         $Gac->setFczFlag6(9);
  284.                                         $conditionMet = true;
  285.                                     }
  286.                                 }
  287.                                 // if ($all_acc == '7' || $all_acc == '2' || $all_acc == '1') {
  288.                                 //     if ($Gad->getBpr()) {
  289.                                 //         $Gac->setObservationFczFlag6('ACC ' . $Gad->getAcc() . ' HAS TIER '. $Gad->getBpr());
  290.                                 //         $Gac->setFczFlag6(9);
  291.                                 //         $conditionMet = true;
  292.                                 //     }
  293.                                 // }
  294.                             }
  295.                             // $amtcur = round($Gad->getAmtcur(), 2);
  297.                             // if ($Gad->getSns() === -1) {
  298.                             //     $amtcur = -$amtcur;
  299.                             // }
  300.                         
  301.                             // $sum += $amtcur;
  302.                             // $amtcurFormatted = number_format($amtcur, 2, '.', ''); // Format as a number with two decimal places.
  303.                             // array_push($sumArray, $amtcurFormatted);
  305.                             $amtcur = $Gad->getAmtcur();
  306.                             $sens = $Gad->getSns();
  307.             
  308.                             $montant =$amtcur * $sens;
  310.                             $sum += $montant;
  311.                         }
  312.                 }
  313.                 $finalBalance = round($sum, 2); // Round to 2 decimal places for final balance
  315.                     if ($finalBalance != 0 || $finalBalance != -0 ) {
  316.                         $Gac->setObservationFczFlag6('PIECE DESEQUILIBREES' . ' ' . $finalBalance);
  317.                         $Gac->setFczFlag6(9);
  318.                         $conditionMet = true;
  319.                     }
  320.                 }else {
  321.                     $Gac->setObservationFczFlag6('TYPE DOES NOT EXIST' . ' ' . $typCheck);
  322.                     $Gac->setFczFlag6(9);
  323.                     $conditionMet = true;
  324.                 }
  325.                 // fcz_flag6 = 2 Piece Sans Probleme 
  327.                 if (!$conditionMet) {
  328.                     $Gac->setObservationFczFlag6('CONTROLLE DONE');
  329.                     $Gac->setFczFlag6(2);
  330.                 }
  332.                 $this->em->getEntity()->persist($Gac);
  333.             }
  334.             $this->em->getEntity()->flush();
  335.         return new Response('ok');
  336.     }
  337. }