src/Controller/SyncronisationController.php line 1434

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use Symfony\Component\Validator\Constraints as Assert;
  6. use Symfony\Component\Validator\Constraints\DateTime;
  7. use App\Entity\DemandeAcquisition;
  8. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  9. use Symfony\Component\HttpFoundation\Request;
  10. use Symfony\Component\HttpFoundation\Response;
  11. use Symfony\Component\Routing\Annotation\Route;
  12. use Doctrine\ORM\EntityManagerInterface;
  13. use Doctrine\Persistence\ManagerRegistry;
  14. use Symfony\Contracts\Translation\TranslatorInterface;
  15. use Symfony\Component\DependencyInjection\ParameterBag\ParameterBagInterface;
  17. use App\Entity\DemandeSortie;
  18. use App\Entity\DemandeUpdate;
  19. use App\Entity\DemandeEnree;
  20. use App\Entity\DemandeFormation;
  21. use App\Entity\DemandeIdentification;
  22. use App\Entity\DemandePrgAmelioration;
  23. use App\Entity\DemandeRebouclage;
  24. use App\Entity\OperationInsemination;
  25. use App\Entity\ProgrammeAmelioration;
  26. use App\Entity\DicEspece;
  27. use App\Entity\DicRace;
  28. use App\Entity\Eleveur;
  29. use App\Entity\DicGouvernorat;
  30. use App\Entity\DicDelegation;
  31. use App\Entity\DicImada;
  32. use App\Entity\Ferme;
  33. use App\Entity\Troupeau;
  34. use App\Entity\DicCircuit;
  35. use App\Entity\CircuitImada;
  36. use App\Entity\Animal;
  37. use App\Entity\AgentOep;
  38. use App\Entity\Agent;
  39. use App\Entity\Adhesion;
  40. use App\Entity\Inseminateur;
  41. use Symfony\Component\HttpFoundation\JsonResponse;
  42. use Psr\Log\LoggerInterface;
  47. class SyncronisationController extends AbstractController
  48. {
  49.     private $em, $translator;
  50.     private $serverIp;
  51.     public function __construct(EntityManagerInterface $em, TranslatorInterface $translator , ParameterBagInterface $params)
  52.     {
  53.         $this->em = $em;
  54.         $this->translator = $translator;
  55.         $this->serverIp = $_SERVER['SYNC_SERVER_IP'];
  56.     }
  57.       
  60.      
  61.      private function checkClientIp(Request $request): bool
  62.      {
  63.          $rip = $request->getClientIp();
  64.          return $rip === $this->serverIp;
  65.      }
  66.  
  69.     #[Route('/api/AllDemandes', name: 'app_Demande_sortie')]
  70.     public function index(LoggerInterface $logger, Request $request)
  71.     {
  72.         
  73.         
  74.         $rip = $request->getClientIp();
  75.         $logger->info('api Synchro AllDemandes, ' . $rip);
  76.         /*if ($rip != $serverIp && $rip != '') {
  77.             return new JsonResponse([
  78.                 'code' => 403,
  79.                 'message' => 'not allowed to run this action'
  80.             ]);
  81.         }*/
  83.         if (!$this->checkClientIp($request)) {
  84.             return new JsonResponse([
  85.                 'code' => 403,
  86.                 'message' => 'not allowed to run this action'
  87.             ]);
  88.         }
  89.         
  90.         
  91.         $em = $this->em;
  92.         $content = $request->getContent();
  93.         $dataRecp = json_decode($content, true);
  94.         $logger->info('rebouclage1 : ***************** ' . $content);
  95.         $logger->info('rebouclage1 : *****************' . count($dataRecp));
  96.         $dernierRebouclage = $dataRecp["dernierRebouclage"];
  97.         $dernierUpdate = $dataRecp["dernierUpdate"];
  98.         $dernierPrgAmel = $dataRecp["dernierAmelioration"];
  99.         $dernierAcquisition = $dataRecp["dernierAcquisition"];
  100.         $dernierIdentification = $dataRecp["dernierIdentification"];
  101.         $dernierSortie = $dataRecp["dernierSortie"];
  102.         $dernierEntre = $dataRecp["dernierEntree"];
  103.         $dernierFormation = $dataRecp["dernierFormation"];
  104.         $dernierInsemination = $dataRecp["dernierInsemination"];
  105.         $dernierOpIdenti =  $dataRecp["dernierOpIdentification"];
  107.         $logger->info('rebouclage1 : ' . $dernierRebouclage);
  108.         $logger->info('update1 : ' . $dernierUpdate);
  109.         $logger->info('aquisition1 : ' . $dernierAcquisition);
  110.         $logger->info('entree1 : ' . $dernierEntre);
  111.         $logger->info('formation1 : ' . $dernierFormation);
  112.         $logger->info('insemination : ' . $dernierInsemination);
  113.         $logger->info('operationIdenti : ' . $dernierOpIdenti);
  116.         if ($dernierOpIdenti == null) {
  117.             $dernierOpIdenti = 0;
  118.         }
  119.         if ($dernierInsemination == null) {
  120.             $dernierInsemination = 0;
  121.         }
  122.         if ($dernierRebouclage == null) {
  123.             $dernierRebouclage = 0;
  124.         }
  126.         if ($dernierUpdate == null) {
  127.             $dernierUpdate = 0;
  128.         }
  130.         if ($dernierPrgAmel == null) {
  131.             $dernierPrgAmel = 0;
  132.         }
  133.         if ($dernierAcquisition == null) {
  134.             $dernierAcquisition = 0;
  135.         }
  136.         if ($dernierIdentification == null) {
  137.             $dernierIdentification = 0;
  138.         }
  139.         if ($dernierSortie == null) {
  140.             $dernierSortie = 0;
  141.         }
  142.         if ($dernierEntre == null) {
  143.             $dernierEntre = 0;
  144.         }
  146.         if ($dernierFormation == null) {
  147.             $dernierFormation = 0;
  148.         }
  154.         $logger->info('rebouclage : ' . $dernierRebouclage);
  155.         $logger->info('update : ' . $dernierUpdate);
  156.         $logger->info('aquisition : ' . $dernierAcquisition);
  157.         $logger->info('entree : ' . $dernierEntre);
  158.         $logger->info('formation : ' . $dernierFormation);
  161.         $qb = $em->createQueryBuilder();
  163.         $query = $qb->select('S')
  164.             ->from('App:DemandeSortie', 'S')
  165.             ->where('S.etatTraitement > 0 ')
  166.             ->andWhere('S.id > :dernierId')
  167.             ->setParameter('dernierId', $dernierSortie);
  168.         $entityServices = $query->getQuery()->getResult();
  171.         $datas = array();
  173.         foreach ($entityServices as $key => $entityService) {
  174.             $datas[$key]['Id'] = $entityService->getId();
  176.             $datas[$key]['Animal'] = $entityService->getAnimal()->getId();
  177.             $datas[$key]['codAnimal'] = $entityService->getAnimal()->getIdentAnm();
  180.             $datas[$key]['Frm_Cod'] = $entityService->getFrmCod();
  181.             $datas[$key]['Date_Sortie'] = $entityService->getDateSor()->format('Y-m-d H:i:s');
  182.             $datas[$key]['Etat_Traitement'] = $entityService->getEtatTraitement();
  183.             if ($entityService->getDateTraitement()) {
  184.                 $datas[$key]['Date_Traitement'] = $entityService->getDateTraitement()->format('Y-m-d H:i:s');
  185.             } else {
  186.                 $datas[$key]['Date_Traitement'] = $entityService->getDateTraitement();
  187.             }
  188.             $datas[$key]['Cause_Sortie'] = $entityService->getCauseSor();
  189.             $datas[$key]['CreatedAt'] = $entityService->getCreatedAt()->format('Y-m-d H:i:s');;
  190.             $datas[$key]['Eleveur'] = $entityService->getEleveur()->getId();
  191.             $datas[$key]['codEleveur'] = $entityService->getEleveur()->getCodElv();
  193.             $datas[$key]['codSit'] = $entityService->getEleveur()->getGouvernorat()->getCodeGou();
  194.             $datas[$key]['codEspece'] = $entityService->getEspece()->getCodeEspece();
  195.             $datas[$key]['codAgn'] = $entityService->getCodAgn();
  196.         }
  200.         //$demandesUpdate = $em->getRepository(DemandeUpdate::class)->findAll();
  202.         $qb = $em->createQueryBuilder();
  204.         $query = $qb->select('u')
  205.             ->from('App:DemandeUpdate', 'u')
  206.             ->where('u.etatTraitement > 0 ')
  207.             ->andWhere('u.id > :dernierId')
  208.             ->setParameter('dernierId', $dernierUpdate);
  209.         $demandesUpdate = $query->getQuery()->getResult();
  212.         $demandeUp = array();
  214.         foreach ($demandesUpdate as $key => $demandeU) {
  215.             $demandeUp[$key]['Id'] = $demandeU->getId();
  216.             if ($demandeU->getAnimal() != null) {
  217.                 $demandeUp[$key]['Animal'] = $demandeU->getAnimal()->getId();
  218.                 $demandeUp[$key]['animalCod'] = $demandeU->getAnimal()->getIdentAnm();
  219.             } else {
  220.                 $demandeUp[$key]['Animal'] = $demandeU->getAnimal();
  221.                 $demandeUp[$key]['animalCod'] = $demandeU->getAnimal();
  222.             }
  224.             if ($demandeU->getEleveur() != null) {
  225.                 $demandeUp[$key]['Eleveur'] = $demandeU->getEleveur()->getId();
  226.                 $demandeUp[$key]['codEleveur'] = $demandeU->getEleveur()->getCodElv();
  227.             } else {
  228.                 $demandeUp[$key]['Eleveur'] = $demandeU->getEleveur()->getId();
  229.                 $demandeUp[$key]['codEleveur'] = $demandeU->getEleveur()->getCodElv();
  230.             }
  233.             if ($demandeU->getDicRace() != null) {
  234.                 $demandeUp[$key]['dicRace'] = $demandeU->getDicRace()->getId();
  235.                 $demandeUp[$key]['dicRaceCode'] = $demandeU->getDicRace()->getcodeRace();
  236.             } else {
  237.                 $demandeUp[$key]['dicRace'] = $demandeU->getDicRace();
  238.                 $demandeUp[$key]['dicRaceCode'] = $demandeU->getDicRace();
  239.             }
  242.             if ($demandeU->getSexAnm() == 1) {
  243.                 $demandeUp[$key]['sexAnmCod'] = 'M';
  244.             } else {
  245.                 $demandeUp[$key]['sexAnmCod'] = 'F';
  246.             }
  249.             $demandeUp[$key]['sexAnm'] = $demandeU->getSexAnm();
  250.             $demandeUp[$key]['codAgn'] = $demandeU->getCodAgn();
  256.             $demandeUp[$key]['dateNais'] = $demandeU->getDateNais()->format('Y-m-d');
  257.             $demandeUp[$key]['annNais'] = $demandeU->getAnnNais();
  258.             $demandeUp[$key]['etatTraitement'] = $demandeU->getEtatTraitement();
  260.             if ($demandeU->getDateTraitement() != null) {
  261.                 $demandeUp[$key]['dateTraitement'] = $demandeU->getDateTraitement()->format('Y-m-d H:i:s');
  262.             } else {
  263.                 $demandeUp[$key]['dateTraitement'] = $demandeU->getDateTraitement();
  264.             }
  266.             if ($demandeU->getDateDepot() != null) {
  267.                 $demandeUp[$key]['dateDepot'] = $demandeU->getDateDepot()->format('Y-m-d H:i:s');
  268.             } else {
  269.                 $demandeUp[$key]['dateDepot'] = $demandeU->getDateDepot();
  270.             }
  273.             if ($demandeU->getCreatedAt() != null) {
  274.                 $demandeUp[$key]['createdAt'] = $demandeU->getCreatedAt()->format('Y-m-d H:i:s');
  275.             } else {
  276.                 $demandeUp[$key]['createdAt'] = $demandeU->getCreatedAt();
  277.             }
  280.             if ($demandeU->getUpdatedAt() != null) {
  281.                 $demandeUp[$key]['updatedAt'] = $demandeU->getUpdatedAt()->format('Y-m-d H:i:s');
  282.             } else {
  283.                 $demandeUp[$key]['updatedAt'] = $demandeU->getUpdatedAt();
  284.             }
  287.             $demandeUp[$key]['idePere'] = $demandeU->getIdePere();
  288.             $demandeUp[$key]['ideMere'] = $demandeU->getIdeMere();
  289.         }
  297.         $qb = $em->createQueryBuilder();
  299.         $query = $qb->select('e')
  300.             ->from('App:DemandeEnree', 'e')
  301.             ->where('e.etatTraitement > 0 ')
  302.             ->andWhere('e.id > :dernierId')
  303.             ->setParameter('dernierId', $dernierEntre);
  304.         $demandesEntre = $query->getQuery()->getResult();
  306.         $demandeEn = array();
  308.         foreach ($demandesEntre as $key => $demandeE) {
  310.             $demandeEn[$key]['Id'] = $demandeE->getId();
  311.             // $demandeEn[$key]['Animal']= $demandeE->getAnimal()->getId();
  312.             //$demandeEn[$key]['Animal']= $demandeE->getAnimal();
  313.             $demandeEn[$key]['Animal'] = $demandeE->getIdentAnm();
  316.             $demandeEn[$key]['Ferme'] = $demandeE->getFerme()->getId();
  317.             $demandeEn[$key]['codSit'] = $demandeE->getFerme()->getImada()->getDelegation()->getGouvernorat()->getCodeGou();
  319.             $demandeEn[$key]['codEspece'] = $demandeE->getEspece()->getCodeEspece();
  321.             $demandeEn[$key]['codFerme'] = $demandeE->getFerme()->getFrmCod();
  323.             $demandeEn[$key]['dateCon'] = $demandeE->getDateCon();
  325.             $demandeEn[$key]['etatTraitement'] = $demandeE->getEtatTraitement();
  326.             $demandeEn[$key]['sorFrm'] = $demandeE->getSorFrm();
  327.             $demandeEn[$key]['identAnm'] = $demandeE->getIdentAnm();
  328.             $demandeEn[$key]['createdAt'] = $demandeE->getCreatedAt()->format('Y-m-d H:i:s');
  329.             $demandeEn[$key]['dateEnt'] = $demandeE->getDateEnt()->format('Y-m-d H:i:s');;
  330.             $demandeEn[$key]['eleveur'] = $demandeE->getEleveur()->getId();
  331.             $demandeEn[$key]['codEleveur'] = $demandeE->getEleveur()->getCodElv();
  332.             $demandeEn[$key]['codAgn'] = $demandeE->getCodAgn();
  333.         }
  338.         $qb = $em->createQueryBuilder();
  340.         /* $query = $qb->select('e')
  341.             ->from('App:DemandeRebouclage', 'e')
  342.             ->leftJoin('e.rebouclageAnimals','r')
  343.             ->where('e.id = r.demRebouc')
  344.             ->andWhere('e.etatTraitement > 0 ')
  345.             ->andWhere('e.id > :dernierId')
  346.             ->setParameter('dernierId',$dernierRebouclage );
  347.         $demandesRebouclage = $query->getQuery()->getResult();*/
  350.         $query = $qb->select('e')
  351.             ->from('App:RebouclageAnimal', 'e')
  352.             ->leftJoin('e.demRebouc', 'r')
  353.             ->where('e.demRebouc = r.id')
  354.             ->andWhere('r.etatTraitement > 0 ')
  355.             ->andWhere('r.id > :dernierId')
  356.             ->setParameter('dernierId', $dernierRebouclage);
  357.         $demandesRebouclage = $query->getQuery()->getResult();
  362.         //dump($demandesRebouclages);die;
  364.         $demandeReb = array();
  366.         foreach ($demandesRebouclage as $key => $demandeR) {
  367.             $demandeReb[$key]['Id'] = $demandeR->getDemRebouc()->getId();
  368.             $demandeReb[$key]['Eleveur'] = $demandeR->getDemRebouc()->getEleveur()->getId();
  369.             $demandeReb[$key]['eleveurCod'] = $demandeR->getDemRebouc()->getEleveur()->getCodElv();
  372.             $demandeReb[$key]['etatTraitement'] = $demandeR->getDemRebouc()->getEtatTraitement();
  373.             $demandeReb[$key]['dateDemande'] = $demandeR->getDemRebouc()->getDateDemande();
  374.             $demandeReb[$key]['dateRebouc'] = $demandeR->getDemRebouc()->getDateRebouc();
  375.             $demandeReb[$key]['codAgn'] = $demandeR->getDemRebouc()->getCodAgn();
  379.             if ($demandeR->getAnimal()->getTroupeau() != null) {
  380.                 $demandeReb[$key]['frmCod'] = $demandeR->getAnimal()->getTroupeau()->getFerme()->getFrmCod();
  381.                 $demandeReb[$key]['codGouv'] = $demandeR->getAnimal()->getTroupeau()->getFerme()->getImada()->getDelegation()->getGouvernorat()->getCodeGou();
  382.             } else {
  383.                 $demandeReb[$key]['frmCod'] = null;
  385.                 $demandeReb[$key]['codGouv'] = $demandeR->getDemRebouc()->getEleveur()->getGouvernorat()->getCodeGou();
  386.             }
  388.             $demandeReb[$key]['IdeAnim'] = $demandeR->getAnimal()->getIdentAnm();
  390.             $demandeReb[$key]['codEspece'] = $demandeR->getAnimal()->getDicRace()->getDicEspece()->getCodeEspece();
  391.         }
  397.         $qb = $em->createQueryBuilder();
  399.         $query = $qb->select('f')
  400.             ->from('App:DemandeFormation', 'f')
  401.             ->where('f.etatTraitement > 0 ')
  402.             ->andWhere('f.id > :dernierId')
  403.             ->setParameter('dernierId', $dernierFormation);
  404.         $demandesFormation = $query->getQuery()->getResult();
  406.         $demandeFor = array();
  408.         foreach ($demandesFormation as $key => $demandeF) {
  409.             $demandeFor[$key]['Id'] = $demandeF->getId();
  410.             $demandeFor[$key]['typeFormation'] = $demandeF->getTypeFormation();
  411.             $demandeFor[$key]['etatTraitement'] = $demandeF->getEtatTraitement();
  412.             $demandeFor[$key]['dateTraitement'] = $demandeF->getDateTraitement();
  413.             $demandeFor[$key]['dateDemande'] = $demandeF->getDateDemande();
  414.             $demandeFor[$key]['createdAt'] = $demandeF->getCreatedAt();
  415.             $demandeFor[$key]['updatedAt'] = $demandeF->getUpdatedAt();
  416.             $demandeFor[$key]['identElv'] = $demandeF->getIdentElv();
  417.             $demandeFor[$key]['nprElvLt'] = $demandeF->getNprElvLt();
  418.             $demandeFor[$key]['nprElvLi'] = $demandeF->getNprElvLi();
  419.             $demandeFor[$key]['cin'] = $demandeF->getCin();
  420.             $demandeFor[$key]['niveauEducation'] = $demandeF->getNiveauEducation();
  421.             $demandeFor[$key]['adresse'] = $demandeF->getAdresse();
  422.             $demandeFor[$key]['numTel'] = $demandeF->getNumTel();
  423.             $demandeFor[$key]['email'] = $demandeF->getEmail();
  424.             $demandeFor[$key]['docDiplomes'] = $demandeF->getDocDiplomes();
  425.             $demandeFor[$key]['motif'] = $demandeF->getMotif();
  426.             $demandeFor[$key]['gouvernorat'] = $demandeF->getGouvernorat()->getId();
  427.             $demandeFor[$key]['gouvernoratCod'] = $demandeF->getGouvernorat()->getCodeGou();
  428.         }
  431.         $qb = $em->createQueryBuilder();
  433.         $query = $qb->select('d')
  434.             ->from('App:DemandePrgAmelioration', 'd')
  435.             ->where('d.etatTraitement > 0 ')
  436.             ->andWhere('d.id > :dernierId')
  437.             ->setParameter('dernierId', $dernierPrgAmel);
  438.         $demandesPrgAmelioration = $query->getQuery()->getResult();
  440.         $demandeAm = array();
  442.         foreach ($demandesPrgAmelioration as $key => $demandeA) {
  443.             $demandeAm[$key]['Id'] = $demandeA->getId();
  444.             $demandeAm[$key]['Eleveur'] = $demandeA->getEleveur()->getId();
  445.             $demandeAm[$key]['codEleveur'] = $demandeA->getEleveur()->getCodElv();
  447.             if ($demandeA->getPgrAml() != null) {
  448.                 $demandeAm[$key]['pgrAml'] = $demandeA->getPgrAml()->getId();
  449.             } else {
  450.                 $demandeAm[$key]['pgrAml'] = $demandeA->getPgrAml();
  451.             }
  452.             $demandeAm[$key]['etatTraitement'] = $demandeA->getEtatTraitement();
  453.             $demandeAm[$key]['dateTraitement'] = $demandeA->getDateTraitement();
  454.             $demandeAm[$key]['dateDepot'] = $demandeA->getDateDepot();
  455.         }
  459.         $qb = $em->createQueryBuilder();
  461.         $query = $qb->select('aci')
  462.             ->from('App:DemandeAcquisition', 'aci')
  463.             ->where('aci.etatTraitement > 0 ')
  464.             ->andWhere('aci.id > :dernierId')
  465.             ->setParameter('dernierId', $dernierAcquisition);
  466.         $demandesAcquisition = $query->getQuery()->getResult();
  468.         $demandeAc = array();
  470.         foreach ($demandesAcquisition as $key => $demandeAci) {
  471.             $demandeAc[$key]['Id'] = $demandeAci->getId();
  472.             $demandeAc[$key]['Eleveur'] = $demandeAci->getEleveur()->getId();
  473.             $demandeAc[$key]['codEleveur'] = $demandeAci->getEleveur()->getCodElv();
  475.             $demandeAc[$key]['dicRace'] = $demandeAci->getDicRace()->getId();
  476.             $demandeAc[$key]['dicRaceCod'] = $demandeAci->getDicRace()->getcodeRace();
  478.             $demandeAc[$key]['nbr'] = $demandeAci->getNbr();
  479.             $demandeAc[$key]['etatTraitement'] = $demandeAci->getEtatTraitement();
  480.             $demandeAc[$key]['dateTraitement'] = $demandeAci->getDateTraitement();
  481.             $demandeAc[$key]['dateDepot'] = $demandeAci->getDateDepot();
  482.             $demandeAc[$key]['codAgn'] = $demandeAci->getCodAgn();
  483.         }
  488.         $qb = $em->createQueryBuilder();
  490.         $query = $qb->select('Iden')
  491.             ->from('App:DemandeIdentification', 'Iden')
  492.             ->where('Iden.etatTraitement > 0 ')
  493.             ->andWhere('Iden.id > :dernierId')
  494.             ->setParameter('dernierId', $dernierIdentification);
  495.         $demandesIdentifiacation  = $query->getQuery()->getResult();
  497.         $demandeID = array();
  499.         foreach ($demandesIdentifiacation as $key => $demandeI) {
  500.             $demandeID[$key]['Id'] = $demandeI->getId();
  502.             $demandeID[$key]['Eleveur'] = $demandeI->getEleveur()->getId();
  503.             $demandeID[$key]['codEleveur'] = $demandeI->getEleveur()->getCodElv();
  505.             $demandeID[$key]['dicEspece'] = $demandeI->getDicEspece()->getId();
  506.             $demandeID[$key]['EspeceCod'] = $demandeI->getDicEspece()->getCodeEspece();
  509.             $demandeID[$key]['nbrMale'] = $demandeI->getNbrMale();
  510.             $demandeID[$key]['nbrFemelle'] = $demandeI->getNbrFemelle();
  511.             $demandeID[$key]['etatTraitement'] = $demandeI->getEtatTraitement();
  512.             $demandeID[$key]['dateTraitement'] = $demandeI->getDateTraitement();
  513.             $demandeID[$key]['dateDepot'] = $demandeI->getDateDepot();
  514.         }
  518.         $qb = $em->createQueryBuilder();
  520.         $query = $qb->select('Op')
  521.             ->from('App:OperationInsemination', 'Op')
  522.             ->Where('Op.id > :dernierId')
  523.             ->setParameter('dernierId', $dernierInsemination);
  524.         $operationinsiminantion = $query->getQuery()->getResult();
  526.         $OpIns = array();
  528.         foreach ($operationinsiminantion as $key => $o) {
  529.             $OpIns[$key]['Id'] = $o->getId();
  530.             $OpIns[$key]['Circuit'] = $o->getDicCircuit()->getCodCircuit();
  531.             if ($o->getEleveur() != null) {
  532.                 $OpIns[$key]['Eleveur'] = $o->getEleveur()->getCodElv();
  534.                 $OpIns[$key]['gouvernorat'] = $o->getEleveur()->getGouvernorat()->getCodeGou();
  536.                 $OpIns[$key]['delegation'] = $o->getEleveur()->getDelegation()->getCodDELG();
  538.                 $OpIns[$key]['imada'] = $o->getEleveur()->getImada()->getCodIm();
  539.             } else {
  540.                 $OpIns[$key]['Eleveur'] = $o->getNumeroEleveur();
  541.                 $OpIns[$key]['gouvernorat'] = null;
  542.                 $OpIns[$key]['delegation'] = null;
  543.                 $OpIns[$key]['imada'] = null;
  544.             }
  548.             if ($o->getAnimal() != null) {
  549.                 $OpIns[$key]['Animal'] = $o->getAnimal()->getIdentAnm();
  550.                 $OpIns[$key]['especeCod'] = $o->getAnimal()->getDicRace()->getDicEspece()->getCodeEspece();
  551.             } else {
  552.                 $OpIns[$key]['Animal'] = $o->getNumeroAnimal();
  553.                 $OpIns[$key]['especeCod'] = null;
  554.             }
  555.             $OpIns[$key]['Certificat'] = $o->getCertificat();
  556.             $OpIns[$key]['dateOperation'] = $o->getDateOp();
  557.             $OpIns[$key]['etatValidation'] = $o->getEtatValidation();
  558.             $OpIns[$key]['annee'] = $o->getAnnee();
  559.             $OpIns[$key]['mois'] = $o->getMois();
  560.             $OpIns[$key]['CreatedAt'] = $o->getCreatedAt();
  561.             $OpIns[$key]['UpdatedAt'] = $o->getUpdatedAt();
  562.             $OpIns[$key]['codAgn'] = $o->getCodAgent();
  563.             $OpIns[$key]['taureau'] = $o->getNumeroTaureau();
  564.         }
  568.         $qb = $em->createQueryBuilder();
  569.         $query = $qb->select('OI')
  570.             ->from('App:OperationIdentification', 'OI')
  571.             ->where('OI.etatTraitement > 0 ')
  572.             ->andWhere('OI.id > :dernierId')
  573.             ->setParameter('dernierId', $dernierOpIdenti);
  574.         $operatioIdent = $query->getQuery()->getResult();
  577.         $opIden = array();
  579.         foreach ($operatioIdent as $key => $OI) {
  580.             $opIden[$key]['Id'] = $OI->getId();
  581.             $opIden[$key]['Eleveur'] = $OI->getEleveur()->getId();
  582.             $opIden[$key]['codEleveur'] = $OI->getEleveur()->getCodElv();
  584.             $opIden[$key]['Animal'] = $OI->getIdentAnimal();
  585.             $opIden[$key]['etatTraitement'] = $OI->getEtatTraitement();
  586.             $opIden[$key]['dateOp'] = $OI->getDateOp()->format('Y-m-d H:i:s');
  587.             $opIden[$key]['createdAt'] = $OI->getCreatedAt()->format('Y-m-d H:i:s');
  588.             $opIden[$key]['updatedAt'] = $OI->getUpdatedAt()->format('Y-m-d H:i:s');
  589.             $opIden[$key]['dicRace'] = $OI->getDicRace()->getId();
  590.             $opIden[$key]['dicRaceCod'] = $OI->getDicRace()->getcodeRace();
  593.             $opIden[$key]['dateNais'] = $OI->getDateNai()->format('Y-m-d');
  594.             $opIden[$key]['annNais'] = $OI->getAnnNai();
  595.             $opIden[$key]['sexAnm'] = $OI->getSexAnm();
  596.             $opIden[$key]['troupeau'] = $OI->getTroupeau()->getId();
  597.             $opIden[$key]['ferme'] = $OI->getFerme()->getId();
  598.             $opIden[$key]['codFerme'] = $OI->getFerme()->getFrmCod();
  600.             $opIden[$key]['Anne'] = $OI->getAnnee();
  601.             $opIden[$key]['Mois'] = $OI->getMois();
  606.             $opIden[$key]['numrTroup'] = $OI->getTroupeau()->getIdentTrp();
  607.             $opIden[$key]['EspeceCod'] = $OI->getDicRace()->getDicEspece()->getCodeEspece();
  609.             if ($OI->getSexAnm() == 1) {
  610.                 $opIden[$key]['sexAnmCod'] = 'M';
  611.             } else {
  612.                 $opIden[$key]['sexAnmCod'] = 'F';
  613.             }
  616.             $opIden[$key]['codAgn'] = $OI->getCodAgent();
  617.             $opIden[$key]['codSit'] = $OI->getEleveur()->getGouvernorat()->getCodeGou();
  618.         }
  622.     
  633.         return new JsonResponse([
  634.             'demandesSortie' => $datas,
  635.             'demandesUpdate' => $demandeUp,
  636.             'demandesEntree' => $demandeEn,
  637.             'demandesReboubuclage' => $demandeReb,
  638.             'demandesFormation' => $demandeFor,
  639.             'demandesPrgAmelioration' => $demandeAm,
  640.             'demandesAcquisation' => $demandeAc,
  641.             'demandesIdentification' => $demandeID,
  642.             'operationInsimination' => $OpIns,
  643.             'operationIdentification' => $opIden
  645.         ]);
  646.     }
  651.     #[Route('/api/race', name: 'app_race')]
  652.     public function getAllRace(Request $request, LoggerInterface $logger, ManagerRegistry $doctrine)
  653.     {
  656.         if (!$this->checkClientIp($request)) {
  657.             return new JsonResponse([
  658.                 'code' => 403,
  659.                 'message' => 'not allowed to run this action'
  660.             ]);
  661.         }
  662.         $em = $this->em;
  663.         $content = $request->getContent();
  664.         $dataArr = array();
  665.         $dataArr = json_decode($content, true);
  667.         foreach ($dataArr as $data) {
  668.             try {
  669.                 $race = null;
  670.                 $id = $data['COD_RACE'];
  671.                 $races = $doctrine->getRepository(DicRace::class)->findBy(['COD_RACE' => $id]);
  672.                 if ($races == null || count($races) == 0) {
  673.                     $race = new DicRace();
  674.                     $race->setcodeRace($id);
  675.                 } else {
  676.                     $race = $races[0];
  677.                 }
  678.                 $e = $data['COD_ESPECE'];
  679.                 $espece = $doctrine->getRepository(DicEspece::class)->findOneBy(['COD_ESPECE' => $e]);
  680.                 $race->setDicEspece($espece);
  681.                 $race->setNomRaceLt($data['NOM_RACELT']);
  682.                 $race->setNomRaceLi($data['NOM_RACELI']);
  683.                 $em->persist($race);
  684.                 $em->flush();
  685.             } catch (Exception $e) {
  686.                 echo 'except *************************** ',  $e->getMessage(), "\n";
  687.             }
  688.         }
  689.         return new JsonResponse([
  690.             'code' => 200,
  691.             'message' => 'Add request success',
  692.             'data3' => $race->getId()
  693.         ]);
  694.     }
  699.     #[Route('/api/espece', name: 'app_espece')]
  700.     public function getAlllEspeces(Request $request, ManagerRegistry $doctrine)
  701.     {
  703.         if (!$this->checkClientIp($request)) {
  704.             return new JsonResponse([
  705.                 'code' => 403,
  706.                 'message' => 'not allowed to run this action'
  707.             ]);
  708.         }
  710.         $paramsArr = array();
  711.         $paramsArr = json_decode($request->getContent(), true);
  712.         $em = $this->em;
  713.         foreach ($paramsArr as $params) {
  714.             try {
  716.                 $espece = null;
  717.                 $id = $params['COD_ESPECE'];
  718.                 $especes = $doctrine->getRepository(DicEspece::class)->findBy(['COD_ESPECE' => $id]);
  719.                 if ($especes == null || count($especes) == 0) {
  720.                     $espece = new DicEspece();
  721.                     $espece->setCodeEspece($id);
  722.                 } else {
  723.                     $espece = $especes[0];
  724.                 }
  726.                 $espece->setDesEspeceLt($params['DES_ESPECELT']);
  727.                 $espece->setDesEspeceLi($params['DES_ESPECELI']);
  728.                 $em->persist($espece);
  729.                 $em->flush();
  730.             } catch (Exception $e) {
  731.                 echo 'except *************************** ',  $e->getMessage(), "\n";
  732.             }
  733.         }
  734.         return new JsonResponse([
  735.             'code' => 200,
  736.             'message' => 'Add request success',
  737.             //'data'    => $espece->getId()
  738.         ]);
  739.     }
  744.     #[Route('/api/eleveur', name: 'app_eleveur')]
  745.     public function getAlllEleveur(Request $request, ManagerRegistry $doctrine)
  746.     {
  747.         if (!$this->checkClientIp($request)) {
  748.             return new JsonResponse([
  749.                 'code' => 403,
  750.                 'message' => 'not allowed to run this action'
  751.             ]);
  752.         }
  754.         $paramsArr = array();
  755.         $paramsArr = json_decode($request->getContent(), true);
  756.         $em = $this->em;
  757.         $date = new \DateTime('now');
  759.         if ($paramsArr == '')        $dataArr = array();
  763.         foreach ($paramsArr as $params) {
  764.             try {
  766.                 /*$g= $params['COD_GOU'];
  767.         $d=$params['COD_DEL'];
  768.         $i=$params['COD_IMA'];
  769.         $gouvernorat = $doctrine->getRepository(DicGouvernorat::class)->findOneBy(['COD_GOU' => $g]);
  770.         $delegation = $doctrine->getRepository(DicDelegation::class)->findOneBy(['COD_DELG' => $d]);
  771.         $imada = $doctrine->getRepository(DicImada::class)->findOneBy(['COD_IMAD' => $i]); */
  773.                 $eleveur = null;
  774.                 $id = trim($params['REF_ELV']);
  775.                 $eleveurs = $doctrine->getRepository(Eleveur::class)->findBy(['codElv' => $id]);
  776.                 if ($eleveurs == null || count($eleveurs) == 0) {
  777.                     $eleveur = new Eleveur();
  778.                     $eleveur->setCodElv($id);
  779.                     $eleveur->setCreatedAt($date);
  780.                 } else {
  781.                     $eleveur = $eleveurs[0];
  782.                 }
  783.                 /*$eleveur->setImada($imada);
  784.             $eleveur->setGouvernorat($gouvernorat);
  785.             $eleveur->setDelegation($delegation);*/
  787.                 $eleveur->setNprElvAr($params['NPR_ELVLI']);
  788.                 $eleveur->setNprElvFr($params['NPR_ELVLT']);
  789.                 $eleveur->setAdresse($params['ADR_ELVLT']);
  790.                 $eleveur->setNumTel($params['TEL_ELV']);
  791.                 $eleveur->setNumFax(intval($params['FAX_ELV']));
  792.                 $eleveur->setUpdatedAt($date);
  794.                 $em->persist($eleveur);
  795.                 $em->flush();
  796.             } catch (Exception $e) {
  797.                 echo 'except *************************** ',  $e->getMessage(), "\n";
  798.             }
  799.         }
  803.         return new JsonResponse([
  804.             'code' => 200,
  805.             'message' => 'Add request success'
  807.         ]);
  808.     }
  815.     #[Route('/api/NbEleveur', name: 'app_NbEleveur')]
  816.     public function getNombreEleveur(Request $request)
  817.     {
  820.         $em = $this->em;
  822.         $qb = $em->createQueryBuilder();
  824.         $query = $qb->select('count(E.id)')->from('App:Eleveur', 'E');
  826.         $nbrEleveur = $query->getQuery()->getSingleScalarResult();
  829.         return new JsonResponse([
  830.             'code' => 200,
  831.             'message' => 'Add request success',
  832.             'nbrEleveur' => $nbrEleveur
  833.         ]);
  834.     }
  841.     #[Route('/api/ferme', name: 'app_ferme')]
  842.     public function getAllistFerme(Request $request, ManagerRegistry $doctrine, LoggerInterface $logger)
  843.     {
  845.         if (!$this->checkClientIp($request)) {
  846.             return new JsonResponse([
  847.                 'code' => 403,
  848.                 'message' => 'not allowed to run this action'
  849.             ]);
  850.         }
  851.         $dataArr = array();
  852.         $em = $this->em;
  853.         $content = $request->getContent();
  854.         $dataArr = json_decode($request->getContent(), true);
  855.         $date = new \DateTime('now');
  857.         if ($dataArr == '')        $dataArr = array();
  858.         $nn = 0;
  859.         $ns = 0;
  860.         $nf = 0;
  861.         $total = 0; //count($dataArr);
  862.         //$logger->info('sync ************************** '.$ns.' -- '.$nf.' -- '.$total.' ***************************'); 
  863.         foreach ($dataArr as $data) {
  865.             try {
  867.                 $ferme = null;
  868.                 $i = $data['COD_IMA'];
  869.                 $g = $data['COD_GOU'];
  870.                 $d = $data['COD_DEL'];
  871.                 $e = trim($data['REF_ELV']);
  872.                 $id = trim($data['FRM_COD']);
  874.                 $fermes = $doctrine->getRepository(Ferme::class)->findBy(['frm_cod' => $id]);
  876.                 if ($e != null) {
  877.                     $eleveur = $doctrine->getRepository(Eleveur::class)->findOneBy(['codElv' => $e]);
  878.                 } else {
  879.                     $eleveur = null;
  880.                 }
  882.                 if ($fermes == null || count($fermes) == 0) {
  883.                     $ferme = new Ferme();
  884.                     $ferme->setFrmCod($id);
  885.                     $nn++;
  886.                 } else {
  887.                     $ferme = $fermes[0];
  888.                 }
  890.                 if ($g != null) {
  891.                     $gouvernorat = $doctrine->getRepository(DicGouvernorat::class)->findOneBy(['COD_GOU' => $g]);
  892.                     $gouv = $gouvernorat->getCodeGou();
  893.                 } else {
  894.                     $gouv = null;
  895.                     $gouvernorat = null;
  896.                 }
  898.                 if ($d != null) {
  899.                     $delegation = $doctrine->getRepository(DicDelegation::class)->findOneBy(['COD_DELG' => $d, 'gouvernorat' => $gouvernorat]);
  900.                     $del = $delegation->getCodDELG();
  901.                 } else {
  902.                     $del = null;
  903.                     $delegation = null;
  904.                 }
  907.                 if ($i != null) {
  908.                     $imada = $doctrine->getRepository(DicImada::class)->findOneBy(['COD_IMAD' => $i, 'delegation' => $delegation]);
  910.                     $im = $imada->getCodIm();
  911.                 } else {
  912.                     $imada = null;
  913.                     $im = null;
  914.                 }
  916.                 $qb2 = $em->createQueryBuilder();
  917.                 $query2 = $qb2->select('U')
  918.                     ->from('App:CircuitImada', 'U')
  919.                     ->where('U.COD_GOU = :gou')
  920.                     ->andWhere('U.COD_IMA = :ima')
  921.                     ->andWhere('U.COD_DEL = :del')
  922.                     ->setParameter('ima', $im)
  923.                     ->setParameter('del', $del)
  924.                     ->setParameter('gou', $gouv);
  925.                 $numCircuits = $query2->getQuery()->getResult();
  929.                 $circuit = null;
  931.                 /*if ($numCircuits > 0 || count($numCircuits )>0  || $numCircuits != null ) { 
  932.      $circuitt = $numCircuits[0]; 
  933.         } else{
  934.         $circuitt= $numCircuits;
  935.         }*/
  937.                 $circuit = null;
  939.                 if ($numCircuits != null) {
  940.                     $circuitt = $numCircuits[0];
  941.                 } else {
  942.                     $circuitt = null;
  943.                 }
  945.                 //$circuitt= $numCircuits;
  947.                 //dump($circuitt);die;
  948.                 if ($circuitt != null) {
  949.                     $num = $circuitt->getNUMCIR();
  950.                     $circuit = $doctrine->getRepository(DicCircuit::class)->findOneBy(['codCircuit' => $num]);
  951.                 }
  952.                 //dump($circuitt, $num,$circuit);die;
  956.                 $ferme->setImada($imada);
  957.                 $ferme->setEleveur($eleveur);
  958.                 $ferme->setDicCircuit($circuit);
  960.                 $ferme->setFrmNomLt($data['FRM_DESLT']);
  961.                 $ferme->setFrmNomLi($data['FRM_DESLI']);
  962.                 $ferme->setFrmAdrFr($data['FRM_ADRLI']);
  963.                 $em->persist($ferme);
  965.                 if ($eleveur != null) {
  966.                     $eleveur->setImada($imada);
  967.                     $eleveur->setGouvernorat($gouvernorat);
  968.                     $eleveur->setDelegation($delegation);
  969.                     $eleveur->setUpdatedAt($date);
  971.                     $em->persist($eleveur);
  972.                 }
  975.                 $em->flush();
  976.                 $ns++;
  977.             } catch (Exception $e) {
  978.                 echo 'except *************************** ',  $e->getMessage(), "\n";
  979.                 $nf++;
  980.             }
  981.         }
  987.         $logger->info('sync ************************** ' . $ns . ' -- ' . $nn . ' -- ' . $nf . ' -- ' . $total . ' ***********************');
  989.         return new JsonResponse([
  990.             'code' => 200,
  991.             'message' => 'Add request success',
  992.             // 'cinrcuitnum'=> $numCircuits
  993.         ]);
  994.     }
  1001.     #[Route('/api/NbFerme', name: 'app_NbFerme')]
  1002.     public function getNombreFerme(Request $request, ManagerRegistry $doctrine)
  1003.     {
  1007.         $em = $this->em;
  1009.         $qb = $em->createQueryBuilder();
  1011.         $query = $qb->select('MAX(F.id)')->from('App:Ferme', 'F');
  1013.         $dernierID = $query->getQuery()->getSingleScalarResult();
  1017.         $qb1 = $em->createQueryBuilder();
  1019.         $query1 = $qb1->select('F')
  1020.             ->from('App:Ferme', 'F')
  1021.             ->where('F.id = :DERId')
  1022.             ->setParameter('DERId', $dernierID);
  1024.         $dernierFerme = $query1->getQuery()->getResult();
  1026.         if ($dernierFerme == null) {
  1027.             $codFrm = null;
  1028.         } else {
  1029.             $codFrm = $dernierFerme[0]->getFrmCod();
  1030.         }
  1033.         $qb2 = $em->createQueryBuilder();
  1035.         $query2 = $qb2->select('count(F.id)')->from('App:Ferme', 'F');
  1037.         $nbrFerme = $query2->getQuery()->getSingleScalarResult();
  1040.         return new JsonResponse([
  1041.             'code' => 200,
  1042.             'message' => 'Add request success',
  1043.             'dernierID' => $dernierID,
  1044.             'dernierFrm' => $codFrm,
  1045.             'NombreFrm' => $nbrFerme,
  1046.             //'codecircuit' => $numCircuits
  1047.         ]);
  1048.     }
  1055.     #[Route('/api/troupeau', name: 'app_troupeau')]
  1056.     public function getAlltroupeau(Request $request, ManagerRegistry $doctrine, LoggerInterface $logger)
  1057.     {
  1058.         if (!$this->checkClientIp($request)) {
  1059.             return new JsonResponse([
  1060.                 'code' => 403,
  1061.                 'message' => 'not allowed to run this action'
  1062.             ]);
  1063.         }
  1064.         $dataArr = array();
  1065.         $em = $this->em;
  1066.         $content = $request->getContent();
  1067.         $dataArr = json_decode($content, true);
  1070.         $ns = 0;
  1071.         $nf = 0;
  1072.         if ($dataArr == '')        $dataArr = array();
  1074.         foreach ($dataArr as $data) {
  1076.             try {
  1077.                 $f = trim($data['FRM_COD']);
  1078.                 $p = $data['COD_ESPECE'];
  1079.                 $nmT = $data['NUM_TRP'];
  1081.                 $espece = $doctrine->getRepository(DicEspece::class)->findOneBy(['COD_ESPECE' => $p]);
  1082.                 $ferme = $doctrine->getRepository(Ferme::class)->findOneBy(['frm_cod' => $f]);
  1086.                 $qb = $em->createQueryBuilder();
  1087.                 $query = $qb->select('U')
  1088.                     ->from('App:Troupeau', 'U')
  1089.                     ->where('U.ferme = :ferm')
  1090.                     ->andWhere('U.dicEspece = :espec')
  1091.                     ->andWhere('U.identTrp = :numT')
  1092.                     ->setParameter('espec', $espece->getId())
  1093.                     ->setParameter('numT', $nmT)
  1094.                     ->setParameter('ferm', $ferme->getId());
  1096.                 $troupaux = $query->getQuery()->getResult();
  1101.                 if ($troupaux  == null || count($troupaux) == 0) {
  1102.                     $troupeau = new Troupeau();
  1103.                 } else {
  1104.                     $troupeau = $troupaux[0];
  1105.                 }
  1106.                 $troupeau->setFerme($ferme);
  1107.                 $troupeau->setDicEspece($espece);
  1108.                 $troupeau->setIdSync(trim($data['IDSYNC']));
  1110.                 $troupeau->setIdentTrp($nmT);
  1111.                 $em->persist($troupeau);
  1112.                 $em->flush();
  1113.                 $ns++;
  1114.                 //$nn++;
  1116.             } catch (Exception $e) {
  1117.                 echo 'except *************************** ',  $e->getMessage(), "\n";
  1118.                 $nf++;
  1119.             }
  1122.             $logger->info('sync ************************** ' . $ns . '  -- ' . $nf . ' ***********************');
  1123.         }
  1125.         return new JsonResponse([
  1126.             'code' => 200,
  1127.             'message' => 'Add request success',
  1129.         ]);
  1130.     }
  1135.     #[Route('/api/NbTroupeau', name: 'app_NbTroupeau')]
  1136.     public function getNombreTroupeau(Request $request)
  1137.     {
  1141.         $em = $this->em;
  1143.         $qb = $em->createQueryBuilder();
  1145.         $query = $qb->select('MAX(T.idSync)')->from('App:Troupeau', 'T');
  1147.         $nbrTroupeau = $query->getQuery()->getSingleScalarResult();
  1152.         if ($nbrTroupeau == null) {
  1153.             $nbrTroupeau = 0;
  1154.         }
  1157.         return new JsonResponse([
  1159.             'nbrTroupeau' => $nbrTroupeau
  1160.         ]);
  1161.     }
  1166.     #[Route('/api/gouvernorat', name: 'app_gouvernourat')]
  1167.     public function getAllistGouvernourat(Request $request, LoggerInterface $logger, ManagerRegistry $doctrine)
  1168.     {
  1169.         if (!$this->checkClientIp($request)) {
  1170.             return new JsonResponse([
  1171.                 'code' => 403,
  1172.                 'message' => 'not allowed to run this action'
  1173.             ]);
  1174.         }
  1175.         $em = $this->em;
  1176.         $content = $request->getContent();
  1177.         $dataArr = array();
  1178.         $dataArr = json_decode($content, true);
  1179.         if ($dataArr == '')        $dataArr = array();
  1181.         foreach ($dataArr as $data) {
  1182.             try {
  1183.                 $gouvernorat = null;
  1184.                 $id = $data['COD_GOU'];
  1185.                 $gouvernorats = $doctrine->getRepository(DicGouvernorat::class)->findBy(['COD_GOU' => $id]);
  1186.                 if ($gouvernorats == null || count($gouvernorats) == 0) {
  1187.                     $gouvernorat = new DicGouvernorat();
  1188.                     $gouvernorat->setCodeGou($id);
  1189.                 } else {
  1190.                     $gouvernorat = $gouvernorats[0];
  1191.                 }
  1193.                 $gouvernorat->setGouvernorat($data['NOM_GOULT']);
  1194.                 $gouvernorat->setNomAr($data['NOM_GOULI']);
  1197.                 $em->persist($gouvernorat);
  1198.                 $em->flush();
  1199.             } catch (Exception $e) {
  1200.                 echo 'except *************************** ',  $e->getMessage(), "\n";
  1201.             }
  1202.         }
  1203.         return new JsonResponse([
  1204.             'code' => 200,
  1205.             'message' => 'Add request success',
  1206.             'data3' => $gouvernorat->getId()
  1208.         ]);
  1209.     }
  1214.     #[Route('/api/delegation', name: 'app_delegation')]
  1215.     public function getListDelegation(Request $request, LoggerInterface $logger, ManagerRegistry $doctrine)
  1216.     {
  1217.         if (!$this->checkClientIp($request)) {
  1218.             return new JsonResponse([
  1219.                 'code' => 403,
  1220.                 'message' => 'not allowed to run this action'
  1221.             ]);
  1222.         }
  1223.         $em = $this->em;
  1224.         $content = $request->getContent();
  1225.         $dataArr = array();
  1226.         $dataArr = json_decode($content, true);
  1227.         if ($dataArr == '')        $dataArr = array();
  1228.         foreach ($dataArr as $data) {
  1229.             try {
  1230.                 $delegation = null;
  1231.                 $id = $data['DES_DELLT'];
  1232.                 $delegations = $doctrine->getRepository(DicDelegation::class)->findBy(['delegation' => $id]);
  1233.                 if ($delegations  == null || count($delegations) == 0) {
  1234.                     $delegation = new DicDelegation();
  1235.                     $delegation->setDelegation($id);
  1236.                 } else {
  1237.                     $delegation = $delegations[0];
  1238.                 }
  1239.                 $g = $data['COD_GOU'];
  1240.                 $gouvernorat = $doctrine->getRepository(DicGouvernorat::class)->findOneBy(['COD_GOU' => $g]);
  1241.                 $delegation->setGouvernorat($gouvernorat);
  1242.                 $delegation->setCodDELG($data['COD_DEL']);
  1243.                 $delegation->setNomAr($data['DES_DELLI']);
  1245.                 $em->persist($delegation);
  1246.                 $em->flush();
  1247.             } catch (Exception $e) {
  1248.                 echo 'except *************************** ',  $e->getMessage(), "\n";
  1249.             }
  1250.         }
  1252.         return new JsonResponse([
  1253.             'code' => 200,
  1254.             'message' => 'Add request success',
  1255.             //'data3' => $delegation->getId()
  1257.         ]);
  1258.     }
  1262.     #[Route('/api/imada', name: 'app_imada')]
  1263.     public function getListImada(Request $request, LoggerInterface $logger, ManagerRegistry $doctrine)
  1264.     {
  1265.         if (!$this->checkClientIp($request)) {
  1266.             return new JsonResponse([
  1267.                 'code' => 403,
  1268.                 'message' => 'not allowed to run this action'
  1269.             ]);
  1270.         }
  1271.         $em = $this->em;
  1272.         $content = $request->getContent();
  1273.         $dataArr = array();
  1274.         $dataArr = json_decode($content, true);
  1275.         if ($dataArr == '')        $dataArr = array();
  1277.         foreach ($dataArr as $data) {
  1278.             try {
  1280.                 $imada = null;
  1281.                 $id = $data['DES_IMALI'];
  1282.                 $d = $data['COD_DEL'];
  1283.                 $g = $data['COD_GOU'];
  1284.                 $im = $data['COD_IMA'];
  1286.                 if ($g != null) {
  1287.                     $gouvernorat = $doctrine->getRepository(DicGouvernorat::class)->findOneBy(['COD_GOU' => $g]);
  1288.                 } else {
  1289.                     $gouvernorat = null;
  1290.                 }
  1292.                 if ($d != null) {
  1293.                     $delegation = $doctrine->getRepository(DicDelegation::class)->findOneBy(['COD_DELG' => $d, 'gouvernorat' => $gouvernorat]);
  1294.                 } else {
  1295.                     $delegation = null;
  1296.                 }
  1299.                 $imadas = $doctrine->getRepository(DicImada::class)->findBy(['nom' => $id, 'delegation' => $delegation, 'COD_IMAD' => $im]);
  1302.                 if ($imadas  == null || count($imadas) == 0) {
  1303.                     $imada = new DicImada();
  1304.                 } else {
  1305.                     $imada = $imadas[0];
  1306.                 }
  1307.                 $imada->setNom($id);
  1308.                 $imada->setDelegation($delegation);
  1309.                 $imada->setCodIm($data['COD_IMA']);
  1310.                 $imada->setNomAr($data['DES_IMALI']);
  1312.                 $em->persist($imada);
  1313.                 $em->flush();
  1314.             } catch (Exception $e) {
  1315.                 echo 'except *************************** ',  $e->getMessage(), "\n";
  1316.             }
  1317.         }
  1319.         return new JsonResponse([
  1320.             'code' => 200,
  1321.             'message' => 'Add request success',
  1322.             //'data' => $imada->getId()
  1324.         ]);
  1325.     }
  1329.     #[Route('/api/circuit', name: 'app_circuit')]
  1330.     public function getListCircuit(Request $request, LoggerInterface $logger, ManagerRegistry $doctrine)
  1331.     {
  1332.         if (!$this->checkClientIp($request)) {
  1333.             return new JsonResponse([
  1334.                 'code' => 403,
  1335.                 'message' => 'not allowed to run this action'
  1336.             ]);
  1337.         }
  1338.         $em = $this->em;
  1339.         $content = $request->getContent();
  1340.         $dataArr = array();
  1341.         $dataArr = json_decode($content, true);
  1342.         if ($dataArr == '')        $dataArr = array();
  1343.         foreach ($dataArr as $data) {
  1344.             try {
  1345.                 $circuit = null;
  1346.                 $id = $data['NUM_CIR'];
  1347.                 $circuits = $doctrine->getRepository(DicCircuit::class)->findBy(['codCircuit' => $id]);
  1348.                 if ($circuits  == null || count($circuits) == 0) {
  1349.                     $circuit = new DicCircuit();
  1350.                     $circuit->setCodCircuit($id);
  1351.                 } else {
  1352.                     $circuit = $circuits[0];
  1353.                 }
  1354.                 $circuit->setDesCirLt($data['DES_CIRLT']);
  1355.                 $circuit->setDesCirLi($data['DES_CIRLI']);
  1356.                 $em->persist($circuit);
  1357.                 $em->flush();
  1358.             } catch (Exception $e) {
  1359.                 echo 'except *************************** ',  $e->getMessage(), "\n";
  1360.             }
  1361.         }
  1362.         return new JsonResponse([
  1363.             'code' => 200,
  1364.             'message' => 'Add request success',
  1365.             // 'data' => $circuit->getId()
  1367.         ]);
  1368.     }
  1371.     #[Route('/api/circuitImada', name: 'app_circuitimada')]
  1372.     public function getListCircuitImada(Request $request, LoggerInterface $logger, ManagerRegistry $doctrine)
  1373.     {
  1374.         if (!$this->checkClientIp($request)) {
  1375.             return new JsonResponse([
  1376.                 'code' => 403,
  1377.                 'message' => 'not allowed to run this action'
  1378.             ]);
  1379.         }
  1380.         $em = $this->em;
  1381.         $content = $request->getContent();
  1382.         $dataArr = array();
  1383.         $dataArr = json_decode($content, true);
  1384.         if ($dataArr == '')        $dataArr = array();
  1386.         /* $gouvernorat = $data['COD_GOU'];
  1387.         $delegation = $data ['COD_DEL'];
  1388.         $imada = $data['COD_IMA'];
  1390.         $circuit = $doctrine->getRepository(DicImada::class)->findOneBy(['COD_IMA' => $imada,'COD_DEL'=>$delegation,'COD_GOU'=>$gouvernorat]);*/
  1394.         foreach ($dataArr as $data) {
  1395.             try {
  1397.                 $gouvernorat = $data['COD_GOU'];
  1398.                 $delegation = $data['COD_DEL'];
  1399.                 $imada = $data['COD_IMA'];
  1401.                 $circuits = $doctrine->getRepository(CircuitImada::class)->findBy(['COD_IMA' => $imada, 'COD_DEL' => $delegation, 'COD_GOU' => $gouvernorat]);
  1404.                 if ($circuits  == null || count($circuits) == 0) {
  1405.                     $cirImada = new CircuitImada();
  1406.                 } else {
  1407.                     $cirImada = $circuits[0];
  1408.                 }
  1410.                 $cirImada->setNUMCIR($data['NUM_CIR']);
  1412.                 $cirImada->setCODGOU($data['COD_GOU']);
  1413.                 $cirImada->setCODDEL($data['COD_DEL']);
  1414.                 $cirImada->setCODIMA($data['COD_IMA']);
  1415.                 $em->persist($cirImada);
  1416.                 $em->flush();
  1417.             } catch (Exception $e) {
  1418.                 echo 'except *************************** ',  $e->getMessage(), "\n";
  1419.             }
  1420.         }
  1421.         return new JsonResponse([
  1422.             'code' => 200,
  1423.             'message' => 'Add request success',
  1424.             //'data' => $cirImada->getId()
  1426.         ]);
  1427.     }
  1432.     #[Route('/api/animal', name: 'app_animal')]
  1434.     public function getListAnimal(Request $request, LoggerInterface $logger, ManagerRegistry $doctrine)
  1435.     {
  1436.         if (!$this->checkClientIp($request)) {
  1437.             return new JsonResponse([
  1438.                 'code' => 403,
  1439.                 'message' => 'not allowed to run this action'
  1440.             ]);
  1441.         }
  1442.         $dataArr = array();
  1443.         $em = $this->em;
  1444.         $content = $request->getContent();
  1445.         $dataArr = json_decode($content, true);
  1446.         $date = new \DateTime('now');
  1447.         $taille = count($dataArr);
  1448.         $ns = 0;
  1449.         $nf = 0;
  1450.         $nn = 0;
  1451.         $concatMessage = "";
  1452.         $logger->info('sync ************************** ' . $ns . ' -- ' . $nf . ' -- ' . $taille . ' ***************************');
  1453.         if ($dataArr == '')        $dataArr = array();
  1455.         foreach ($dataArr as $data) {
  1456.             try {
  1457.                 $id = trim($data['IDE_ANIM']);
  1458.                 $concatMessage .= $id . " ";
  1459.                 $animal = null;
  1460.                 $animales = $doctrine->getRepository(Animal::class)->findBy(['identAnm' => $id]);
  1461.                 if ($animales == null || count($animales) == 0) {
  1462.                     $animal = new Animal();
  1463.                     $animal->setIdentAnm($id);
  1464.                     $animal->setIdSync(trim($data['IDSYNC']));
  1465.                     $animal->setCreatedAt($date);
  1466.                     $nn++;
  1467.                     $concatMessage .= " not found /";
  1468.                 } else {
  1469.                     $animal = $animales[0];
  1470.                     $concatMessage .= " found /";
  1471.                     $animal->setIdSync(trim($data['IDSYNC']));
  1472.                 }
  1474.                 $r = $data['COD_RACE'];
  1475.                 $t = $data['NUM_TRP'];
  1476.                 //$t= $data['FRM_COD_ACT'];
  1477.                 $f = trim($data['FRM_COD_ACT']);
  1478.                 $frmNais = trim($data['FRM_COD_NAI']);
  1479.                 $m = trim($data['IDE_MERE']);
  1480.                 $p = trim($data['IDE_PERE']);
  1481.                 $d = $data['DAT_NAI'];
  1482.                 $animPres = $data['ANIM_PRES'];
  1483.                 if ($d != null) {
  1484.                     $dateNaiss = str_replace(array("/"), '-', $d);
  1485.                     $logger->info('dd1 ' . $dateNaiss);
  1486.                     $datt = substr($d, 0, 2);
  1487.                     $logger->info("datt" . $datt);
  1488.                     $mois = substr($d, 3, 2);
  1489.                     $logger->info("mois" . $mois);
  1490.                     $year = substr($d, 6, 2);
  1491.                     $logger->info("year" . $year);
  1492.                     $dateNaiss = $year . '-' . $mois . '-' . $datt;
  1493.                     $logger->info("dateForm" . $dateNaiss);
  1494.                 } else {
  1495.                     $dateNaiss = null;
  1496.                 }
  1499.                 $race = $doctrine->getRepository(DicRace::class)->findOneBy(['COD_RACE' => $r]);
  1503.                 if ($animPres == 'N') {
  1504.                     $troupeau = null;
  1505.                     $ferme = null;
  1506.                     $fermeNais = $doctrine->getRepository(Ferme::class)->findOneBy(['frm_cod' => $frmNais]);
  1507.                 } else {
  1508.                     $ferme = $doctrine->getRepository(Ferme::class)->findOneBy(['frm_cod' => $f]);
  1509.                     $fermeNais = $doctrine->getRepository(Ferme::class)->findOneBy(['frm_cod' => $frmNais]);
  1511.                     //$troupeau = $doctrine->getRepository(Troupeau::class)->findOneBy(['ferme' => $ferme]);
  1512.                     $troupeau = $doctrine->getRepository(Troupeau::class)->findOneBy(['ferme' => $ferme, 'identTrp' => $t]);
  1513.                 }
  1514.                 $mere = $doctrine->getRepository(Animal::class)->findOneBy(['identAnm' => $m]);
  1515.                 $pere = $doctrine->getRepository(Animal::class)->findOneBy(['identAnm' => $p]);
  1516.                 $eleveur  = null;
  1518.                 if ($ferme != null) {
  1519.                     $eleveur = $ferme->getEleveur();
  1520.                 }
  1521.                 if ($eleveur != null) {
  1522.                     $animal->setEleveur($eleveur);
  1523.                 }
  1524.                 if ($pere != null) {
  1525.                     $animal->setIdePere($pere);
  1526.                 }
  1527.                 if ($mere != null) {
  1528.                     $animal->setIdeMere($mere);
  1529.                 }
  1531.                 if ($data['SEX_ANM'] == 'M') {
  1532.                     $animal->setSexAnm(0);
  1533.                 } else {
  1534.                     $animal->setSexAnm(1);
  1535.                 }
  1536.                 if ($dateNaiss == null) {
  1537.                     $animal->setDateNai(null);
  1538.                 } else {
  1539.                     $animal->setDateNai(new \DateTime(date("y-m-d", strtotime($dateNaiss))));
  1540.                 }
  1541.                 $animal->setAnnNai($data['ANN_NAI']);
  1542.                 $animal->setTypAnm($data['TYP_ANIM']);
  1543.                 $animal->setTroupeau($troupeau);
  1544.                 $animal->setFermeNais($fermeNais);
  1546.                 $animal->setDicRace($race);
  1547.                 $animal->setUpdatedAt($date);
  1548.                 $concatMessage .= "*" . json_encode($animal) . "*";
  1549.                 $em->persist($animal);
  1550.                 $em->flush();
  1551.                 $ns++;
  1552.             } catch (Exception $e) {
  1553.                 $nf++;
  1554.             }
  1555.         }
  1557.         $logger->info('sync ************************** ' . $ns . ' -- ' . $nn . ' -- ' . $nf . ' -- ' . $taille . ' ***********************');
  1559.         $concatMessage = "";
  1561.         return new JsonResponse([
  1562.             'code' => 200,
  1563.             'message' => 'Add request success ' . $concatMessage,
  1564.             'taille_tableau' => $taille,
  1565.             'nbrsucess' => $ns,
  1566.             'nbrfailed' => $nf
  1569.         ]);
  1570.     }
  1572.     #[Route('/api/NbAnimal', name: 'app_NbAnimal')]
  1573.     public function getNombreAnimal(Request $request)
  1574.     {
  1578.         $em = $this->em;
  1580.         $qb = $em->createQueryBuilder();
  1582.         $query = $qb->select('MAX(A.idSync)')->from('App:Animal', 'A');
  1584.         $nbrAnimal = $query->getQuery()->getSingleScalarResult();
  1585.         if ($nbrAnimal == null) {
  1586.             $nbrAnimal = 0;
  1587.         }
  1591.         return new JsonResponse([
  1593.             'nbrAnimal' => $nbrAnimal,
  1594.         ]);
  1595.     }
  1600.     #[Route('/api/agentoep', name: 'app_agentoep')]
  1601.     public function getListAgentOep(Request $request, LoggerInterface $logger, ManagerRegistry $doctrine)
  1602.     {
  1603.         if (!$this->checkClientIp($request)) {
  1604.             return new JsonResponse([
  1605.                 'code' => 403,
  1606.                 'message' => 'not allowed to run this action'
  1607.             ]);
  1608.         }
  1609.         $em = $this->em;
  1610.         $content = $request->getContent();
  1611.         $date = new \DateTime('now');
  1612.         $dataArr = array();
  1613.         $dataArr = json_decode($content, true);
  1615.         foreach ($dataArr as $data) {
  1616.             try {
  1617.                 $agent = null;
  1618.                 $id = trim($data['COD_AGN']);
  1619.                 $agents = $doctrine->getRepository(AgentOep::class)->findBy(['codAgent' => $id]);
  1620.                 if ($agents  == null || count($agents) == 0) {
  1621.                     $agent = new AgentOep();
  1622.                     $agent->setCodAgent($id);
  1623.                     $agent->setIdentAgent($id);
  1624.                     $agent->setCreatedAt($date);
  1625.                 } else {
  1626.                     $agent = $agents[0];
  1627.                 }
  1629.                 $i = $data['COD_IMA'];
  1630.                 $d = $data['COD_DEL'];
  1631.                 $g = $data['COD_GOU'];
  1632.                 if ($g != null) {
  1633.                     $gouvern = $doctrine->getRepository(DicGouvernorat::class)->findOneBy(['COD_GOU' => $g]);
  1634.                 } else {
  1635.                     $gouvern = null;
  1636.                 }
  1638.                 if ($d != null) {
  1639.                     $delega = $doctrine->getRepository(DicDelegation::class)->findOneBy(['COD_DELG' => $d, 'gouvernorat' => $gouvern]);
  1640.                 } else {
  1641.                     $delega = null;
  1642.                 }
  1645.                 if ($i != null) {
  1646.                     $imada = $doctrine->getRepository(DicImada::class)->findOneBy(['COD_IMAD' => $i, 'delegation' => $delega]);
  1647.                 } else {
  1648.                     $imada = null;
  1649.                 }
  1650.                 $agent->setIdentAgent($id);
  1652.                 $agent->setNprAgentAr($data['NPR_POILI']);
  1653.                 $agent->setNprAgentFr($data['NPR_POILT']);
  1654.                 $agent->setDelegation($delega);
  1655.                 $agent->setGouvernorat($gouvern);
  1656.                 $agent->setImada($imada);
  1657.                 $agent->setUpdatedAt($date);
  1658.                 $em->persist($agent);
  1659.                 $em->flush();
  1660.             } catch (Exception $e) {
  1661.                 echo 'except *************************** ',  $e->getMessage(), "\n";
  1662.             }
  1663.         }
  1666.         return new JsonResponse([
  1667.             'code' => 200,
  1668.             'message' => 'Add request success',
  1670.             'data' =>  $agent->getId()
  1672.         ]);
  1673.     }
  1675.     #[Route('/api/insiminateur', name: 'app_insiminateur')]
  1676.     public function getListInisiminateur(Request $request, LoggerInterface $logger, ManagerRegistry $doctrine)
  1677.     {
  1678.         if (!$this->checkClientIp($request)) {
  1679.             return new JsonResponse([
  1680.                 'code' => 403,
  1681.                 'message' => 'not allowed to run this action'
  1682.             ]);
  1683.         }
  1684.         $em = $this->em;
  1685.         $content = $request->getContent();
  1686.         $dataArr = array();
  1687.         $dataArr = json_decode($content, true);
  1688.         $date = new \DateTime('now');
  1691.         foreach ($dataArr as $data) {
  1692.             try {
  1694.                 $insiminateur = null;
  1695.                 $id = trim($data['COD_AGN']);
  1696.                 $insiminateurs = $doctrine->getRepository(Inseminateur::class)->findBy(['codIns' => $id]);
  1697.                 if ($insiminateurs  == null || count($insiminateurs) == 0) {
  1698.                     $insiminateur = new Inseminateur();
  1699.                     $insiminateur->setCodIns($id);
  1700.                 } else {
  1701.                     $insiminateur = $insiminateurs[0];
  1702.                 }
  1703.                 $c = $data['NUM_CIR'];
  1704.                 $circuit = $doctrine->getRepository(CircuitImada::class)->findOneBy(['NUM_CIR' => $c]);
  1705.                 if ($circuit == null) {
  1706.                     $gouvern = null;
  1707.                     $diccirc = null;
  1708.                 } else {
  1709.                     $g = $circuit->getCODGOU();
  1710.                     $gouvern = $doctrine->getRepository(DicGouvernorat::class)->findOneBy(['COD_GOU' => $g]);
  1711.                     $diccirc = $doctrine->getRepository(DicCircuit::class)->findOneBy(['codCircuit' => $c]);
  1712.                 }
  1713.                 $insiminateur->setNprInsAr($data['NPR_POILI']);
  1714.                 $insiminateur->setNprInsFr($data['NPR_POILT']);
  1715.                 $insiminateur->setDicGouvernorat($gouvern);
  1716.                 $insiminateur->setDicCircuit($diccirc);
  1717.                 $insiminateur->setCreatedAt($date);
  1718.                 $em->persist($insiminateur);
  1719.                 $em->flush();
  1720.             } catch (Exception $e) {
  1721.                 echo 'except *************************** ',  $e->getMessage(), "\n";
  1722.             }
  1723.         }
  1724.         return new JsonResponse([
  1725.             'code' => 200,
  1726.             'message' => 'Add request success',
  1727.             'data' =>  $insiminateur->getId()
  1728.             //'data' =>  $data
  1731.         ]);
  1732.     }
  1735.     #[Route('/api/agentIdent', name: 'app_agentIdent')]
  1736.     public function getListAgentIdent(Request $request, LoggerInterface $logger, ManagerRegistry $doctrine)
  1737.     {
  1738.         if (!$this->checkClientIp($request)) {
  1739.             return new JsonResponse([
  1740.                 'code' => 403,
  1741.                 'message' => 'not allowed to run this action'
  1742.             ]);
  1743.         }
  1744.         $em = $this->em;
  1745.         $content = $request->getContent();
  1746.         $date = new \DateTime('now');
  1747.         $dataArr = array();
  1748.         $dataArr = json_decode($content, true);
  1750.         foreach ($dataArr as $data) {
  1751.             try {
  1752.                 $agent = null;
  1753.                 $id = trim($data['COD_AGN']);
  1754.                 $agents = $doctrine->getRepository(Agent::class)->findBy(['codAgent' => $id]);
  1755.                 if ($agents  == null || count($agents) == 0) {
  1756.                     $agent = new Agent();
  1757.                     $agent->setCodAgent($id);
  1758.                     $agent->setCreatedAt($date);
  1759.                 } else {
  1760.                     $agent = $agents[0];
  1761.                 }
  1766.                 $i = $data['COD_IMA'];
  1767.                 $d = $data['COD_DEL'];
  1768.                 $g = $data['COD_GOU'];
  1770.                 if ($g != null) {
  1771.                     $gouvern = $doctrine->getRepository(DicGouvernorat::class)->findOneBy(['COD_GOU' => $g]);
  1772.                 } else {
  1773.                     $gouvern = null;
  1774.                 }
  1776.                 if ($d != null) {
  1777.                     $delega = $doctrine->getRepository(DicDelegation::class)->findOneBy(['COD_DELG' => $d, 'gouvernorat' => $gouvern]);
  1778.                 } else {
  1779.                     $delega = null;
  1780.                 }
  1783.                 if ($i != null) {
  1784.                     $imada = $doctrine->getRepository(DicImada::class)->findOneBy(['COD_IMAD' => $i, 'delegation' => $delega]);
  1785.                 } else {
  1786.                     $imada = null;
  1787.                 }
  1789.                 $agent->setNprAgentAr($data['NPR_POILI']);
  1790.                 $agent->setNprAgentFr($data['NPR_POILT']);
  1791.                 $agent->setDelegation($delega);
  1792.                 $agent->setGouvernorat($gouvern);
  1793.                 $agent->setImada($imada);
  1794.                 $agent->setUpdatedAt($date);
  1796.                 $em->persist($agent);
  1797.                 $em->flush();
  1798.             } catch (Exception $e) {
  1799.                 echo 'except *************************** ',  $e->getMessage(), "\n";
  1800.             }
  1801.         }
  1804.         return new JsonResponse([
  1805.             'code' => 200,
  1806.             'message' => 'Add request success',
  1808.             //'data' =>  $agent->getId()
  1810.         ]);
  1811.     }
  1814.     #[Route('/api/adhesion', name: 'app_adhesion')]
  1815.     public function getAllAdhesion(Request $request, ManagerRegistry $doctrine, LoggerInterface $logger)
  1816.     {
  1817.         if (!$this->checkClientIp($request)) {
  1818.             return new JsonResponse([
  1819.                 'code' => 403,
  1820.                 'message' => 'not allowed to run this action'
  1821.             ]);
  1822.         }
  1823.         $dataArr = array();
  1824.         $em = $this->em;
  1825.         $content = $request->getContent();
  1826.         $dataArr = json_decode($content, true);
  1829.         $ns = 0;
  1830.         $nf = 0;
  1831.         if ($dataArr == '')        $dataArr = array();
  1833.         foreach ($dataArr as $data) {
  1835.             try {
  1838.                 $f = trim($data['FRM_COD']);
  1839.                 $E = $data['COD_ESPECE'];
  1840.                 $nmTrAdh = $data['NUM_TRPADH'];
  1841.                 $typAdh = $data['TYP_ADH'];
  1843.                 $espece = $doctrine->getRepository(DicEspece::class)->findOneBy(['COD_ESPECE' => $E]);
  1844.                 $ferme = $doctrine->getRepository(Ferme::class)->findOneBy(['frm_cod' => $f]);
  1845.                 $typeAdh = $doctrine->getRepository(ProgrammeAmelioration::class)->findOneBy(['codPrg' => $typAdh]);
  1850.                 $logger->info(' addhtype ************************** ' . $typAdh . ' ***************************');
  1856.                 $qb = $em->createQueryBuilder();
  1857.                 $query = $qb->select('U')
  1858.                     ->from('App:Adhesion', 'U')
  1859.                     ->where('U.ferme = :ferm')
  1860.                     ->andWhere('U.espece = :espec')
  1861.                     ->andWhere('U.NumTrpAdh = :Num')
  1862.                     ->andWhere('U.TypAdh = :typ')
  1863.                     ->setParameter('espec', $espece->getId())
  1864.                     ->setParameter('typ', $typeAdh->getId())
  1865.                     ->setParameter('Num', $nmTrAdh)
  1866.                     ->setParameter('ferm', $ferme->getId());
  1868.                 $adhesions = $query->getQuery()->getResult();
  1871.                 $dateD = $data['DAT_DEB'];
  1872.                 // $dateDebut = DateTime::createFromFormat('Y-m-d H:i:s', $dateD);
  1875.                 if ($dateD != null) {
  1876.                     $dateDebut = str_replace(array("/"), '-', $dateD);
  1877.                     $logger->info('dd1 ' . $dateDebut);
  1878.                     $datt = substr($dateD, 0, 2);
  1879.                     $logger->info("datt" . $datt);
  1880.                     $mois = substr($dateD, 3, 2);
  1881.                     $logger->info("mois" . $mois);
  1882.                     $year = substr($dateD, 6, 2);
  1883.                     $logger->info("year" . $year);
  1884.                     $dateDebut = $year . '-' . $mois . '-' . $datt;
  1885.                     $logger->info("dateForm" . $dateDebut);
  1886.                 } else {
  1887.                     $dateDebut = null;
  1888.                 }
  1891.                 $dateF = $data['DAT_FIN'];
  1893.                 if ($dateF != null) {
  1894.                     $dateFin = str_replace(array("/"), '-', $dateF);
  1895.                     $logger->info('dd1 ' . $dateFin);
  1896.                     $datt = substr($dateF, 0, 2);
  1897.                     $logger->info("datt" . $datt);
  1898.                     $mois = substr($dateF, 3, 2);
  1899.                     $logger->info("mois" . $mois);
  1900.                     $year = substr($dateF, 6, 2);
  1901.                     $logger->info("year" . $year);
  1902.                     $dateFin = $year . '-' . $mois . '-' . $datt;
  1903.                     $logger->info("dateForm" . $dateFin);
  1904.                 } else {
  1905.                     $dateFin = null;
  1906.                 }
  1907.                 //$dateFin = DateTime::createFromFormat('Y-m-d H:i:s', $dateF);
  1909.                 $logger->info(' addhtype ************************** ' . $dateD . ' ***************************');
  1913.                 $codtypCon = null;
  1915.                 if ($data['COD_TYPCON'] = ! null) {
  1916.                     $codtypCon = $data['COD_TYPCON'];
  1917.                 }
  1919.                 $cauFinAdh = null;
  1920.                 if ($data['CAU_FINADH'] != null) {
  1921.                     $cauFinAdh = $data['CAU_FINADH'];
  1922.                 }
  1925.                 $codSite = null;
  1926.                 if ($data['CODE_SIT'] != null) {
  1927.                     $codSite = $data['CODE_SIT'];
  1928.                 }
  1931.                 $nbrSem = null;
  1933.                 if ($data['NBR_SEM'] != null) {
  1935.                     $nbrSem = $data['NBR_SEM'];
  1936.                 }
  1941.                 if ($adhesions  == null || count($adhesions) == 0) {
  1944.                     $adhesion = new Adhesion();
  1947.                     $adhesion->setFerme($ferme);
  1948.                     $adhesion->setEspece($espece);
  1949.                     $adhesion->setNumTrpAdh($nmTrAdh);
  1950.                     $adhesion->setTypAdh($typeAdh);
  1951.                     $adhesion->setIdSync(trim($data['IDSYNC']));
  1953.                     if ($dateDebut) {
  1954.                         $adhesion->setDateDebut(new \DateTime(date("y-m-d", strtotime($dateDebut))));
  1955.                     } else {
  1956.                         $adhesion->setDateDebut(null);
  1957.                     }
  1958.                     $adhesion->setCodTypCon($codtypCon);
  1959.                     if ($dateFin != null) {
  1960.                         $adhesion->setDateFin(new \DateTime(date("y-m-d", strtotime($dateFin))));
  1961.                     } else {
  1962.                         $adhesion->setDateFin(null);
  1963.                     }
  1964.                     $adhesion->setCauFinAdh($cauFinAdh);
  1965.                     $adhesion->setCodSite($codSite);
  1966.                     $adhesion->setNbrSit($nbrSem);
  1967.                     $adhesion->setCausRetrAdh($data['CAUS_RETR_ADH']);
  1972.                     $em->persist($adhesion);
  1973.                     $em->flush();
  1974.                     $ns++;
  1975.                     //$nn++;
  1976.                 }
  1977.             } catch (Exception $e) {
  1978.                 echo 'except *************************** ',  $e->getMessage(), "\n";
  1979.                 $nf++;
  1980.             }
  1983.             $logger->info('sync ************************** ' . $ns . '  -- ' . $nf . ' ***********************');
  1984.         }
  1986.         return new JsonResponse([
  1987.             'code' => 200,
  1988.             'message' => 'Add request success',
  1989.             'data' => $dataArr
  1991.         ]);
  1992.     }
  1994.     #[Route('/api/NbAdhesion', name: 'app_NbbAdhesion')]
  1995.     public function getNombreAdhesions(Request $request)
  1996.     {
  2000.         $em = $this->em;
  2002.         $qb = $em->createQueryBuilder();
  2004.         $query = $qb->select('MAX(Ad.idSync)')
  2005.             ->from('App:Adhesion', 'Ad');
  2006.         $nbrAdhesion = $query->getQuery()->getSingleScalarResult();
  2008.         if ($nbrAdhesion == null) {
  2009.             $nbrAdhesion = 0;
  2010.         }
  2015.         return new JsonResponse([
  2017.             'nbrAdhesion' => $nbrAdhesion,
  2018.         ]);
  2019.     }
  2020. }