src\Controller\HomeController.php line 16

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  6. use Symfony\Component\HttpFoundation\Response;
  7. use Symfony\Component\Routing\Annotation\Route;
  8. use Doctrine\Persistence\ManagerRegistry;
  9. use App\Entity\Gaccentry;
  10. use App\Entity\Gaccentryd;
  11. use Symfony\Component\HttpFoundation\JsonResponse;
  13. class HomeController extends AbstractController
  14. {
  15.     #[Route('/', name: 'app_home')]
  16.     public function index(): Response
  17.     {
  18.         return $this->render('home/index.html.twig', [
  19.             'controller_name' => 'HomeController',
  20.         ]);
  21.     }
  24.     #[Route('/test', name: 'test')]
  25.     public function test(ManagerRegistry $doctrine): Response
  26.     {
  27.         // $emDbcom =  $doctrine->getManager('dbcom');
  28.         // $request = " select * from  YGAS where rowid = 498207" ;
  30.         // $stmt = $emDbcom->getConnection()->fetchAllAssociative($request);
  31.       
  33.         $em =  $doctrine->getManager();
  35.         // 2011-03-07 00:33:45
  38.         $Gaccentries = $em->getRepository(Gaccentry::class)->find(498207);
  40.         $strTime = $Gaccentries->getAccdat()->format('Y-m-d H:i:s');
  42.         if($Gaccentries->getAccdat()->format('Y') == '2022'){
  44.             $newDate = date('Y-m-d', strtotime($strTime. ' + 1 years'));
  45.            
  46.         }else{
  47.             dd('est à jour');
  48.         }
  50.         dd(new \DateTime('2023-01-01 00:00:00'));
  52.         $Gaccentries->setAccdat(new \DateTime('2023-01-01 00:00:00'));
  54.         dd( $Gaccentries->getAccdat()->format('Y-m-d'));
  56.         // dd(new \DateTime($newDate));
  57.       
  58.         // dd(      $newDate);
  59.         
  60.         // dd($Gaccentries->getAccdat()->format('y'));
  62.         dd($Gaccentries);
  63.     }
  65.     #[Route('/insert/adonix', name: 'insert_adonix')]
  66.     public function insert_adonix(ManagerRegistry $doctrine): Response
  67.     {
  69.         $em =  $doctrine->getManager();
  71.         $emDbcom =  $doctrine->getManager('dbcom');
  73.         $Gaccentries = $em->getRepository(Gaccentry::class)->findByNotHosix();
  74.         // dd($Gaccentries);
  76.         foreach ($Gaccentries as $key => $Gac) {
  78.                 // dd($Gac->getFczFlag3(), $Gac->getFczFlag5());
  80.             //    if($Gac->getFczFlag5() == 1  && $Gac->getFczFlag3() == 0 ){
  82.            
  84.             // if($Gac->getAccdat()->format('Y') == '2022'){ 
  85.             //     $Gac->setAccdat(new \DateTime('2023-01-01 00:00:00'));
  86.             // }
  88.             // if($Gac->getDuddat()->format('Y') == '2022'){
  89.             //     $Gac->setDuddat(new \DateTime('2023-01-01 00:00:00'));
  90.             // }
  92.             // if($Gac->getRatDat()->format('Y') == '2022'){
  93.             //     $Gac->setRatDat(new \DateTime('2023-01-01 00:00:00'));
  94.             // }
  95.            
  96.                     $request = "  set IDENTITY_INSERT YGAS  ON
  97.                     
  98.                                 INSERT INTO YGAS(ROWID , TYPE_UG , TYP_0,
  99.                                                 NUM_0 , FCY_0 , JOU_0,
  100.                                                 FIY_0 , PER_0 , ACCDAT_0,
  101.                                                 DUDDAT_0 , RATDAT_0 , cat,
  102.                                                 sta , orimod , dacdia,
  103.                                                 flgpaz , flggen , CUR_0,
  104.                                                 TYPRAT_0 , led , curled,
  105.                                                 RATMLT_0 , RATDIV_0 , DESVCR_0,
  106.                                                 REF_0 , BPRVCR_0 , rvs ,
  107.                                                 rvsdat , rvsorinum , xdossier ,
  108.                                                 xidfacini , fcz_id_local , fcz_id_systeme_cm ,
  109.                                                 fcz_id_cp , fcz_description_systeme , fcz_id_site ,
  110.                                                 fcz_description_site , fcz_description_tier_piece , fcz_id_doc2_asso ,
  111.                                                 fcz_id_doc1_asso , fcz_ec_ref , fcz_factureini ,
  112.                                                 fcz_motif_annul , fcz_autre_information , fcz_type_paiement ,
  113.                                                 fcz_type_banque , fcz_cheq_num , fcz_cheq_type ,
  114.                                                 fcz_cheq_bnq , fcz_montant_initial , fcz_montant_remise , 
  115.                                                 fcz_montant_retenu , fcz_montant_net , fcz_montant_autre1 , 
  116.                                                 fcz_montant_autre2 , fcz_cc_max_ref , fcz_cc_max_mt , 
  117.                                                 fcz_flag1 , fcz_flag2 , fcz_flag3 , 
  118.                                                 fcz_flag4 , fcz_flag5 , fcz_date_interf_cm , 
  119.                                                 fcz_user_name_cm , fcz_date_interf_cp , fcz_user_name_cp , 
  120.                                                 fcz_id_tier_piece , fcz_id_ad_piece , CCE_0 , 
  121.                                                 NUMX3_0 , UPDTICK_0 , BPRDATVCR_0 , 
  122.                                                 EXPNUM_0 , CREDAT_0 , CREUSR_0 , 
  123.                                                 UPDDAT_0 , UPDUSR_0 , CREDATTIM_0 , 
  124.                                                 UPDDATTIM_0 , pc_num
  125.                                                 )
  128.                                 VALUES ('".$Gac->getId()."' , '".$Gac->getTyp()."' , '".$this->strQuote($Gac->getTyp1())."'
  129.                                         ,'".$this->strQuote($Gac->getNum())."','".$Gac->getFcy1()."', '".$Gac->getJou()."'
  130.                                         ,'".$Gac->getFiy()."','".$Gac->getPer()."', '".$this->dateString($Gac->getAccdat())."' 
  131.                                         ,'".$this->dateString($Gac->getDuddat() )."','". $this->dateString( $Gac->getRatDat() ) ."', '". $this->dateString( $Gac->getCat() )."' 
  132.                                         ,'".$Gac->getSta()."','".$Gac->getOrimod()."', '".$Gac->getDacdia()."' 
  133.                                         ,'".$Gac->isFlgpaz()."',  '".$Gac->isFlggen()."' , '".$Gac->getCur()."' 
  134.                                         ,'".$Gac->getTyprat()."','".$Gac->getLed()."', '".$Gac->getCurled()."' 
  135.                                         ,'".$this->numNull($Gac->getRatmlt())."','".$this->numNull($Gac->getRatdiv())."', '".$this->strQuote($Gac->getDesvcr())."' 
  136.                                         ,'".$Gac->getRef()."','".$Gac->getBprvcr()."', '".$Gac->getRvs()."' 
  137.                                         ,'".$this->dateString($Gac->getRvsdat())."','".$Gac->getRvsorinum()."', '".$Gac->getXdossier()."' 
  138.                                         ,'".$Gac->getXidfacini()."','".$Gac->getFczIdLocal()."', '".$Gac->getFczIdSystemeCm()."' 
  139.                                         ,'".$Gac->getFczIdCp()."','".$Gac->getFczDescriptionSysteme()."', '".$Gac->GetFczIdSite()."' 
  140.                                         ,'".$this->strQuote($Gac->getFczDescriptionSite())."','".$this->strQuote($Gac->getFczDescriptionTierPiece())."', '".$Gac->getFczIdDoc2Asso()."' 
  141.                                         ,'".$Gac->getFczIdDoc1Asso()."','".$Gac->getFczEcRef()."', '".$Gac->getFczFactureini()."' 
  142.                                         ,'".$Gac->getFczMotifAnnul()."','".$Gac->getFczAutreInformation()."', '".$Gac->getFczTypePaiement()."' 
  143.                                         ,'".$Gac->getFczTypeBanque()."','".$Gac->getFczCheqNum()."', '".$Gac->getFczCheqType()."' 
  144.                                         ,'".$Gac->getFczCheqBnq()."','".$Gac->getFczMontantInitial()."', '".$Gac->getFczMontantRemise()."' 
  145.                                         ,'".$Gac->getFczMontantRetenu()."','".$Gac->getFczMontantNet()."', '".$Gac->getFczMontantAutre1()."' 
  146.                                         ,'".$Gac->getFczMontantAutre2()."','".$Gac->getFczCcMaxRef()."', '".$Gac->getFczCcMaxMt()."' 
  147.                                         ,'".$Gac->getFczFlag1()."','".$Gac->getFczFlag2()."', ' 3 ' 
  148.                                         ,'".$Gac->getFczFlag4()."','".$Gac->getFczFlag5()."', '".$this->dateString($Gac->getFczDateInterfCm())."' 
  149.                                         ,'".$Gac->getFczUserNameCm()."','".$this->dateString($Gac->getFczDateInterfCp())."', '".$Gac->getFczUserNameCp()."' 
  150.                                         ,'".$Gac->getFczIdTierPiece()."','".$Gac->getFczIdAdPiece()."', '".$Gac->getCce0()."'
  151.                                         ,'".$Gac->getNUMX30()."','".$Gac->getUPDTICK0()."', '".$this->dateString($Gac->getBPRDATVCR0())."' 
  152.                                         ,'".$Gac->getEXPNUM0()."','".$this->dateString($Gac->getCREDAT0())."', '".$Gac->getCREUSR0()."' 
  153.                                         ,'".$this->dateString($Gac->getUPDDAT0())."','".$Gac->getUPDUSR0()."', '".$this->dateString($Gac->getCREDATTIM0())."' 
  154.                                         ,'".$this->dateString($Gac->getUPDDATTIM0())."' ,'".$Gac->getCode()."'
  155.                                         )
  158.                                         set IDENTITY_INSERT YGAS  OFF 
  159.                                         
  160.                                         
  161.                                         ";
  163.                                         // $arrayChar = str_split($request);
  164.                                         
  165.                                         // foreach ($arrayChar as $key => $char) {
  167.                                         //     if($char == "'" && $key >= 1 ){
  168.                                         //         if($arrayChar[$key - 1]  != "," && $arrayChar[$key + 1]  != "," ){
  169.                                         //             $arrayChar[$key] = "\'";
  170.                                         //         }
  171.                                         //     }
  172.                                             
  173.                                         // }
  175.                                         // dd(implode("",$arrayChar));
  176.                                         // dd($request);
  179.                     $stmt = $emDbcom->getConnection()->prepare($request);
  180.                     $result = $stmt->executeQuery();
  184.           
  186.             // foreach ($Gaccentryds as $key => $CDet) 
  187.             // {
  189.             //     $request = " INSERT INTO YGASD(ygas_id,TYPE_UG)
  190.             //                  VALUES (  '".$Gaccentry->getId()."', 
  191.             //                           '".$CDet->getTypUg()."' ) ";
  193.             //     $stmt = $emDbcom->getConnection()->prepare($request);
  194.             //     $result = $stmt->executeQuery();
  196.             // }
  199.                     $Gaccentryds  = $Gac->getGaccentryds();
  200.                     
  201.                     foreach ($Gaccentryds as $key => $CDet) 
  202.                     {
  203.                         
  204.                             // ROWID    
  205.                             // AUUID_0   $CDet->getAUUID0()
  207.                             $requestDet = " set IDENTITY_INSERT YGASD  ON
  208.                                     
  209.                                     INSERT INTO YGASD ( ROWID , ygas_id, TYPE_UG,
  210.                                                             TYP_0, NUM_0, LIN_0,
  211.                                                             ledtyp, led, accnum,
  212.                                                             cpy, fcylin, accdat,
  213.                                                             fiy, per, CCE_0,
  214.                                                             sac, ACC_0, BPR_0,
  215.                                                             SNS_0, cur, AMTCUR_0,
  216.                                                             curled, DES_0, mtc,
  217.                                                             mtcdat, FREREF_0,FREREF_1, chk,
  218.                                                             chkdat, fcz_id_systeme_com, fcz_id_comptable,
  219.                                                             fcz_acc_libelle, FCY_0, CREDATTIM_0,
  220.                                                             UPDDATTIM_0, CREUSR_0,
  221.                                                             UPDUSR_0, UPDTICK_0
  222.                                                             )
  224.                                     VALUES (    '". $CDet->getId()."','". $CDet->getGaccentry()->getId()."', '". $CDet->getTypUg()."','".
  225.                                                 $CDet->getTyp0()."', '". $CDet->getNum()."', '". $CDet->getLin()."', '".
  226.                                                 $CDet->getLedtyp()."', '".$CDet->getLed()."', '".$CDet->getAccnum()."', '".
  227.                                                 $CDet->getCpy()."', '". $CDet->getFcylin()."', '".$this->dateString($CDet->getAccdat())."', '".
  228.                                                 $CDet->getFiy()."', '".$CDet->getPer()."', '". $CDet->getCce0()."', '".
  229.                                                 $CDet->getSac()."', '". $CDet->getAcc()."', '". $CDet->getBpr()."', '".
  230.                                                 $CDet->getSns()."', '". $CDet->getCur()."', '". $CDet->getAMTCUR()."', '".
  231.                                                 $CDet->getCurled()."', '". $this->strQuote($CDet->getDes())."', '". $CDet->getMtc()."', '".
  232.                                                 $this->dateString($CDet->getMtcdat())."', '". $CDet->getFreref0()."', '". $CDet->getFreref()."', '". $CDet->getChk()."', '".
  233.                                                 $this->dateString($CDet->getChkdat())."', '". $CDet->getFczIdSystemeCom()."', '". $CDet->getFczIdComptable()."', '".
  234.                                                 $this->strQuote($CDet->getFczAccLibelle())."', '". $CDet->getFcy0()."', '". $this->dateString($CDet->getCREDATTIM0())."', '".
  235.                                                 $this->dateString( $CDet->getUPDDATTIM0())."', '". $CDet->getCREUSR0()."', '".
  236.                                                 $CDet->getUPDUSR0()."', '". $CDet->getUPDTICK0()."'
  237.                                             
  238.                                                 ) 
  239.                                                 
  240.                                                 set IDENTITY_INSERT YGASD  OFF 
  241.                                             ";
  243.                             $stmt = $emDbcom->getConnection()->prepare($requestDet);
  244.                             $result = $stmt->executeQuery();
  245.                     
  246.                     }
  248.                 $Gac->setFczFlag3(1);
  249.                 $em->flush();
  251.             // }
  254.         }
  256.         // die();
  259.         return new Response('ok');
  263.         // dd($Gaccentries);
  266.         // return $this->render('home/index.html.twig', [
  267.         //     'controller_name' => 'HomeController',
  268.         // ]);
  271.     }
  272.     
  273.     #[Route('/insert/hosix/adonix', name: 'insert_hosix_adonix')]
  274.     public function insert_hosix_adonix(ManagerRegistry $doctrine): Response
  275.     {
  276.         dd('amine');
  278.         $em =  $doctrine->getManager();
  282.         $emDbcom =  $doctrine->getManager('dbcom');
  283.         $adonix =  $doctrine->getManager('adonix');
  285.         $request = "select count(*) as tot from HCZ.YGAS where YFLGTRS_0 = 1";
  286.         $stmt = $adonix->getConnection()->fetchAssociative($request);
  288.         if($stmt["tot"] != 0) {
  289.             return new Response('not ready');
  290.         }
  292.         $Gaccentries = $em->getRepository(Gaccentry::class)->findBy(['fczFlag3' => 0, 'fczFlag5' => 1, 'source' => 'HOSIX'], [], 500);
  295.         
  297.         foreach ($Gaccentries as $key => $Gac) {
  299.             //     dd($Gac->getFczFlag3(), $Gac->getFczFlag5());
  301.             //    if($Gac->getFczFlag5() == 1  && $Gac->getFczFlag3() == 0 ){
  303.            
  305.             if($Gac->getAccdat()->format('Y') == '2022'){ 
  306.                 $Gac->setAccdat(new \DateTime('2023-01-01 00:00:00'));
  307.             }
  309.             if($Gac->getDuddat()->format('Y') == '2022'){
  310.                 $Gac->setDuddat(new \DateTime('2023-01-01 00:00:00'));
  311.             }
  313.             if($Gac->getRatDat()->format('Y') == '2022'){
  314.                 $Gac->setRatDat(new \DateTime('2023-01-01 00:00:00'));
  315.             }
  317.         
  318.            
  319.                     $request = "  set IDENTITY_INSERT YGAS  ON
  320.                     
  321.                                 INSERT INTO YGAS(ROWID , TYPE_UG , TYP_0,
  322.                                                 NUM_0 , FCY_0 , JOU_0,
  323.                                                 FIY_0 , PER_0 , ACCDAT_0,
  324.                                                 DUDDAT_0 , RATDAT_0 , cat,
  325.                                                 sta , orimod , dacdia,
  326.                                                 flgpaz , flggen , CUR_0,
  327.                                                 TYPRAT_0 , led , curled,
  328.                                                 RATMLT_0 , RATDIV_0 , DESVCR_0,
  329.                                                 REF_0 , BPRVCR_0 , rvs ,
  330.                                                 rvsdat , rvsorinum , xdossier ,
  331.                                                 xidfacini , fcz_id_local , fcz_id_systeme_cm ,
  332.                                                 fcz_id_cp , fcz_description_systeme , fcz_id_site ,
  333.                                                 fcz_description_site , fcz_description_tier_piece , fcz_id_doc2_asso ,
  334.                                                 fcz_id_doc1_asso , fcz_ec_ref , fcz_factureini ,
  335.                                                 fcz_motif_annul , fcz_autre_information , fcz_type_paiement ,
  336.                                                 fcz_type_banque , fcz_cheq_num , fcz_cheq_type ,
  337.                                                 fcz_cheq_bnq , fcz_montant_initial , fcz_montant_remise , 
  338.                                                 fcz_montant_retenu , fcz_montant_net , fcz_montant_autre1 , 
  339.                                                 fcz_montant_autre2 , fcz_cc_max_ref , fcz_cc_max_mt , 
  340.                                                 fcz_flag1 , fcz_flag2 , fcz_flag3 , 
  341.                                                 fcz_flag4 , fcz_flag5 , fcz_date_interf_cm , 
  342.                                                 fcz_user_name_cm , fcz_date_interf_cp , fcz_user_name_cp , 
  343.                                                 fcz_id_tier_piece , fcz_id_ad_piece , CCE_0 , 
  344.                                                 NUMX3_0 , UPDTICK_0 , BPRDATVCR_0 , 
  345.                                                 EXPNUM_0 , CREDAT_0 , CREUSR_0 , 
  346.                                                 UPDDAT_0 , UPDUSR_0 , CREDATTIM_0 , 
  347.                                                 UPDDATTIM_0 , pc_num
  348.                                                 )
  351.                                 VALUES ('".$Gac->getId()."' , '".$Gac->getTyp()."' , '".$this->strQuote($Gac->getTyp1())."'
  352.                                         ,'".$this->strQuote($Gac->getNum())."','".$Gac->getFcy1()."', '".$Gac->getJou()."'
  353.                                         ,'".$Gac->getFiy()."','".$Gac->getPer()."', '".$this->dateString($Gac->getAccdat())."' 
  354.                                         ,'".$this->dateString($Gac->getDuddat() )."','". $this->dateString( $Gac->getRatDat() ) ."', '". $this->dateString( $Gac->getCat() )."' 
  355.                                         ,'".$Gac->getSta()."','".$Gac->getOrimod()."', '".$Gac->getDacdia()."' 
  356.                                         ,'".$Gac->isFlgpaz()."',  '".$Gac->isFlggen()."' , '".$Gac->getCur()."' 
  357.                                         ,'".$Gac->getTyprat()."','".$Gac->getLed()."', '".$Gac->getCurled()."' 
  358.                                         ,'".$this->numNull($Gac->getRatmlt())."','".$this->numNull($Gac->getRatdiv())."', '".$this->strQuote($Gac->getDesvcr())."' 
  359.                                         ,'".$Gac->getRef()."','".$Gac->getBprvcr()."', '".$Gac->getRvs()."' 
  360.                                         ,'".$this->dateString($Gac->getRvsdat())."','".$Gac->getRvsorinum()."', '".$Gac->getXdossier()."' 
  361.                                         ,'".$Gac->getXidfacini()."','".$Gac->getFczIdLocal()."', '".$Gac->getFczIdSystemeCm()."' 
  362.                                         ,'".$Gac->getFczIdCp()."','".$Gac->getFczDescriptionSysteme()."', '".$Gac->GetFczIdSite()."' 
  363.                                         ,'".$this->strQuote($Gac->getFczDescriptionSite())."','".$this->strQuote($Gac->getFczDescriptionTierPiece())."', '".$Gac->getFczIdDoc2Asso()."' 
  364.                                         ,'".$this->strQuote($Gac->getFczIdDoc1Asso())."','".$Gac->getFczEcRef()."', '".$Gac->getFczFactureini()."' 
  365.                                         ,'".$Gac->getFczMotifAnnul()."','".$Gac->getFczAutreInformation()."', '".$Gac->getFczTypePaiement()."' 
  366.                                         ,'".$Gac->getFczTypeBanque()."','".$Gac->getFczCheqNum()."', '".$Gac->getFczCheqType()."' 
  367.                                         ,'".$Gac->getFczCheqBnq()."','".$Gac->getFczMontantInitial()."', '".$Gac->getFczMontantRemise()."' 
  368.                                         ,'".$Gac->getFczMontantRetenu()."','".$Gac->getFczMontantNet()."', '".$Gac->getFczMontantAutre1()."' 
  369.                                         ,'".$Gac->getFczMontantAutre2()."','".$Gac->getFczCcMaxRef()."', '".$Gac->getFczCcMaxMt()."' 
  370.                                         ,'".$Gac->getFczFlag1()."','".$Gac->getFczFlag2()."', ' 3 ' 
  371.                                         ,'".$Gac->getFczFlag4()."','".$Gac->getFczFlag5()."', '".$this->dateString($Gac->getFczDateInterfCm())."' 
  372.                                         ,'".$Gac->getFczUserNameCm()."','".$this->dateString($Gac->getFczDateInterfCp())."', '".$Gac->getFczUserNameCp()."' 
  373.                                         ,'".$Gac->getFczIdTierPiece()."','".$Gac->getFczIdAdPiece()."', '".$Gac->getCce0()."'
  374.                                         ,'".$Gac->getNUMX30()."','".$Gac->getUPDTICK0()."', '".$this->dateString($Gac->getBPRDATVCR0())."' 
  375.                                         ,'".$Gac->getEXPNUM0()."','".$this->dateString($Gac->getCREDAT0())."', '".$Gac->getCREUSR0()."' 
  376.                                         ,'".$this->dateString($Gac->getUPDDAT0())."','".$Gac->getUPDUSR0()."', '".$this->dateString($Gac->getCREDATTIM0())."' 
  377.                                         ,'".$this->dateString($Gac->getUPDDATTIM0())."' ,'".$Gac->getCode()."'
  378.                                         )
  381.                                         set IDENTITY_INSERT YGAS  OFF 
  382.                                         
  383.                                         
  384.                                         ";
  386.                                         // $arrayChar = str_split($request);
  387.                                         
  388.                                         // foreach ($arrayChar as $key => $char) {
  390.                                         //     if($char == "'" && $key >= 1 ){
  391.                                         //         if($arrayChar[$key - 1]  != "," && $arrayChar[$key + 1]  != "," ){
  392.                                         //             $arrayChar[$key] = "\'";
  393.                                         //         }
  394.                                         //     }
  395.                                             
  396.                                         // }
  398.                                         // dd(implode("",$arrayChar));
  399.                                         // dd($request);
  402.                     $stmt = $emDbcom->getConnection()->prepare($request);
  403.                     $result = $stmt->executeQuery();
  407.           
  409.             // foreach ($Gaccentryds as $key => $CDet) 
  410.             // {
  412.             //     $request = " INSERT INTO YGASD(ygas_id,TYPE_UG)
  413.             //                  VALUES (  '".$Gaccentry->getId()."', 
  414.             //                           '".$CDet->getTypUg()."' ) ";
  416.             //     $stmt = $emDbcom->getConnection()->prepare($request);
  417.             //     $result = $stmt->executeQuery();
  419.             // }
  422.                     $Gaccentryds  = $Gac->getGaccentryds();
  423.                     
  424.                     foreach ($Gaccentryds as $key => $CDet) 
  425.                     {
  426.                         
  427.                             // ROWID    
  428.                             // AUUID_0   $CDet->getAUUID0()
  430.                             $requestDet = " set IDENTITY_INSERT YGASD  ON
  431.                                     
  432.                                     INSERT INTO YGASD ( ROWID , ygas_id, TYPE_UG,
  433.                                                             TYP_0, NUM_0, LIN_0,
  434.                                                             ledtyp, led, accnum,
  435.                                                             cpy, fcylin, accdat,
  436.                                                             fiy, per, CCE_0,
  437.                                                             sac, ACC_0, BPR_0,
  438.                                                             SNS_0, cur, AMTCUR_0,
  439.                                                             curled, DES_0, mtc,
  440.                                                             mtcdat, FREREF_0,FREREF_1, chk,
  441.                                                             chkdat, fcz_id_systeme_com, fcz_id_comptable,
  442.                                                             fcz_acc_libelle, FCY_0, CREDATTIM_0,
  443.                                                             UPDDATTIM_0, CREUSR_0,
  444.                                                             UPDUSR_0, UPDTICK_0
  445.                                                             )
  447.                                     VALUES (    '". $CDet->getId()."','". $CDet->getGaccentry()->getId()."', '". $CDet->getTypUg()."','".
  448.                                                 $CDet->getTyp0()."', '". $CDet->getNum()."', '". $CDet->getLin()."', '".
  449.                                                 $CDet->getLedtyp()."', '".$CDet->getLed()."', '".$CDet->getAccnum()."', '".
  450.                                                 $CDet->getCpy()."', '". $CDet->getFcylin()."', '".$this->dateString($CDet->getAccdat())."', '".
  451.                                                 $CDet->getFiy()."', '".$CDet->getPer()."', '". $CDet->getCce0()."', '".
  452.                                                 $CDet->getSac()."', '". $CDet->getAcc()."', '". $CDet->getBpr()."', '".
  453.                                                 $CDet->getSns()."', '". $CDet->getCur()."', '". $CDet->getAMTCUR()."', '".
  454.                                                 $CDet->getCurled()."', '". $this->strQuote($CDet->getDes())."', '". $CDet->getMtc()."', '".
  455.                                                 $this->dateString($CDet->getMtcdat())."', '". $CDet->getFreref0()."', '". $CDet->getFreref()."', '". $CDet->getChk()."', '".
  456.                                                 $this->dateString($CDet->getChkdat())."', '". $CDet->getFczIdSystemeCom()."', '". $CDet->getFczIdComptable()."', '".
  457.                                                 $this->strQuote($CDet->getFczAccLibelle())."', '". $CDet->getFcy0()."', '". $this->dateString($CDet->getCREDATTIM0())."', '".
  458.                                                 $this->dateString( $CDet->getUPDDATTIM0())."', '". $CDet->getCREUSR0()."', '".
  459.                                                 $CDet->getUPDUSR0()."', '". $CDet->getUPDTICK0()."'
  460.                                             
  461.                                                 ) 
  462.                                                 
  463.                                                 set IDENTITY_INSERT YGASD  OFF 
  464.                                             ";
  466.                             $stmt = $emDbcom->getConnection()->prepare($requestDet);
  467.                             $result = $stmt->executeQuery();
  468.                     
  469.                     }
  471.                 $Gac->setFczFlag3(1);
  472.                 $em->flush();
  474.             // }
  477.         }
  479.         // die();
  482.         return new Response('ok');
  486.         // dd($Gaccentries);
  489.         // return $this->render('home/index.html.twig', [
  490.         //     'controller_name' => 'HomeController',
  491.         // ]);
  494.     }
  496.     function dateString($date){
  497.                 
  498.         if($date)
  499.             if ($date->format('Y') == '-0001' )  return '';
  500.             else return $date->format('Y-m-d') ;
  501.         else return '';
  502.     }
  504.     function numNull($value){
  505.         if($value){  return $value; }
  506.         else{ return 0;}
  507.     }
  509.     function strQuote($value){
  510.     
  511.         return str_replace("'"," ",$value);
  512.     }
  514. }