src/Controller/InscriptionSite/ApiCarteController.php line 64

Open in your IDE?
  1. <?php
  3. namespace App\Controller\InscriptionSite;
  5. use Symfony\Component\HttpFoundation\Request;
  6. use Amp\Http\Client\Response;
  7. use App\Controller\MailerController;
  8. use App\Entity\Carte;
  9. use App\Entity\EcheanceInscrit;
  10. use App\Entity\Elearning;
  11. use App\Entity\Inscrit;
  12. use App\Form\InscritType;
  13. use App\Repository\InscritRepository;
  14. use App\Entity\Tier;
  15. use App\Entity\JustifFourni;
  16. use App\Entity\Reglement;
  17. use App\Entity\Financement;
  18. use App\Entity\Organisme;
  19. use App\Form\TierType;
  20. use App\Repository\TierRepository;
  21. use App\Repository\OrganismeRepository;
  22. use App\Repository\SiteRepository;
  23. use App\Repository\FormationRepository;
  24. use App\Repository\JustificatifRepository;
  25. use App\Repository\MoyPaiementRepository;
  26. use App\Repository\CondRegleRepository;
  27. use App\Repository\SourceFinanceRepository;
  28. use App\Repository\StatusRepository;
  29. use App\Repository\StatusInscritRepository;
  30. use App\Entity\Entreprise;
  31. use App\Entity\ReglementEcheance;
  32. use App\Entity\Session;
  33. use App\Entity\UniteInscription;
  34. use App\Form\EntrepriseType;
  36. use App\Repository\DemandeRepository;
  37. use App\Repository\EcheanceInscritRepository;
  38. use App\Repository\ElearningRepository;
  39. use App\Repository\EnqueteJ1Repository;
  40. use App\Repository\EnqueteJ30Repository;
  41. use App\Repository\EntrepriseRepository;
  42. use App\Repository\ExamenRepository;
  43. use App\Repository\FinancementRepository;
  44. use App\Repository\CarteRepository;
  45. use App\Repository\OptionCategorieInscritRepository;
  46. use App\Repository\ReglementRepository;
  47. use App\Repository\SessionRepository;
  48. use App\Repository\TypeInscritRepository;
  49. use App\Repository\UniteInscriptionRepository;
  50. use App\Service\FileUploader;
  51. use Doctrine\ORM\EntityManagerInterface;
  52. use Exception;
  53. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  54. use Symfony\Component\HttpFoundation\JsonResponse;
  55. use Symfony\Component\HttpFoundation\Request as HttpFoundationRequest;
  56. use Symfony\Component\Mailer\MailerInterface;
  57. use Symfony\Component\Routing\Annotation\Route;
  59. class ApiCarteController extends AbstractController
  60. {
  61.     /**
  62.      * @Route("/api/carte", name="app_api_carte",methods={"GET"})
  63.      */
  64.     public function carte(CarteRepository $carteRepository,$session=null){
  65.         
  66.         $carte = [];
  67.         $carte["vtc"] =[] ;
  68.         $carte["tm"] =[] ;
  69.         $carte["t"] =[] ;
  70.         $carteTMT = $carteRepository->findBy(['site'=>2,'optioncategorie'=>4,'is_activate'=>true],['wording'=>'asc']);
  71.         $carteTMP = $carteRepository->findBy(['site'=>2,'optioncategorie'=>5,'is_activate'=>true],['wording'=>'asc']);
  72.         $carteTMTP = $carteRepository->findBy(['site'=>2,'optioncategorie'=>6,'is_activate'=>true],['wording'=>'asc']);
  73.         //vtc
  74.         $carteVTCT = $carteRepository->findBy(['site'=>3,'optioncategorie'=>1,'is_activate'=>true],['wording'=>'asc']);
  75.         $carteVTCP = $carteRepository->findBy(['site'=>3,'optioncategorie'=>2,'is_activate'=>true],['wording'=>'asc']);
  76.         $carteVTCTP = $carteRepository->findBy(['site'=>3,'optioncategorie'=>3,'is_activate'=>true],['wording'=>'asc']);
  77.         $carteVTCTPC = $carteRepository->findBy(['site'=>3,'optioncategorie'=>16,'is_activate'=>true],['wording'=>'asc']);
  78.         //taxi
  79.         $carteTI = $carteRepository->findBy(['site'=>1,'optioncategorie'=>7,'is_activate'=>true],['wording'=>'asc']);
  80.         $carteTC = $carteRepository->findBy(['site'=>1,'optioncategorie'=>8,'is_activate'=>true],['wording'=>'asc']);
  81.         $carteTTMP = $carteRepository->findBy(['site'=>1,'optioncategorie'=>9,'is_activate'=>true],['wording'=>'asc']);
  82.         $carteTVTCTAXI = $carteRepository->findBy(['site'=>1,'optioncategorie'=>10,'is_activate'=>true],['wording'=>'asc']);
  83.         
  84.         //vtccontinu
  85.         $carteVTCC = $carteRepository->findBy(['site'=>3,'optioncategorie'=>11,'is_activate'=>true],['wording'=>'asc']);
  86.         
  87.         //vtctpmr
  88.         $carteVTCTPMR = $carteRepository->findBy(['site'=>3,'optioncategorie'=>12,'is_activate'=>true],['wording'=>'asc']);
  90.         //preparation examen
  91.         $carteExamen = $carteRepository->findBy(['site'=>[3],'optioncategorie'=>14,'is_activate'=>true],['id'=>'asc']);
  92.         $carteExamenTaxi = $carteRepository->findBy(['site'=>[1],'optioncategorie'=>15,'is_activate'=>true],['id'=>'asc']);
  94.         $carteVTC["theoriepratique"] = [];
  95.         $carteVTC["theoriepratiquecma"] = [];
  96.         $carteVTC["theorie"] = [];
  97.         $carteVTC["pratique"] = [];
  98.         $carteVTC["continue"] = [];
  99.         $carteVTC["tpmr"] = [];
  100.         $carteTM["pratique"] = [];
  101.         $carteTM["theorie"] = [];
  102.         $carteTM["theoriepratique"] = [];
  103.         $carteT["fi"] = [];
  104.         $carteT["fc"] = [];
  105.         $carteT["mp"] = [];
  106.         $carteT["vtctaxi"] = [];
  107.         $carteE = [];
  108.         $carteETaxi = [];
  109.         
  110.         foreach ($carteVTCT as $key => $value) {
  111.             $formations = [];
  112.             foreach ($value->getFormation() as $key => $formation) {
  113.                 array_push($formations,[
  114.                     "id"=>$formation->getId(),
  115.                     "wording" => $formation->getWording(),
  116.                 ]);
  117.             }
  118.             array_push($carteVTC["theorie"],
  119.             [
  120.                 "id" => $value->getId(),
  121.                 "wording" => $value->getWording(),
  122.                 "libellelibre" => $value->getLibellelibre(),
  123.                 "prerequis" => $value->getPrerequis(),
  124.                 "pricepersonal" => $value->getPricepersonal(),
  125.                 "pricecompany" => $value->getPricecompany(),
  126.                 "pricecpf" => $value->getPricecpf(),
  127.                 "formation" => count($formations) > 0?$formations:[]
  129.             ]);
  130.         }
  131.         foreach ($carteVTCP as $key => $value) {
  132.             $formations = [];
  133.             foreach ($value->getFormation() as $key => $formation) {
  134.                 array_push($formations,[
  135.                     "id"=>$formation->getId(),
  136.                     "wording" => $formation->getWording(),
  137.                 ]);
  138.             }
  139.             array_push($carteVTC["pratique"],
  140.             [
  141.                 "id" => $value->getId(),
  142.                 "wording" => $value->getWording(),
  143.                 "libellelibre" => $value->getLibellelibre(),
  144.                 "pricepersonal" => $value->getPricepersonal(),
  145.                 "pricecompany" => $value->getPricecompany(),
  146.                 "pricecpf" => $value->getPricecpf(),
  147.                 "formation" => count($formations) > 0?$formations:[]
  149.             ]);
  150.         }
  151.         foreach ($carteVTCTP as $key => $value) {
  152.             $formations = [];
  153.             foreach ($value->getFormation() as $key => $formation) {
  154.                 array_push($formations,[
  155.                     "id"=>$formation->getId(),
  156.                     "wording" => $formation->getWording(),
  157.                 ]);
  158.             }
  159.             array_push($carteVTC["theoriepratique"],
  160.             [
  161.                 "id" => $value->getId(),
  162.                 "wording" => $value->getWording(),
  163.                 "libellelibre" => $value->getLibellelibre(),
  164.                 "pricepersonal" => $value->getPricepersonal(),
  165.                 "pricecompany" => $value->getPricecompany(),
  166.                 "pricecpf" => $value->getPricecpf(),
  167.                 "formation" => count($formations) > 0?$formations:[]
  169.             ]);
  170.         }
  171.         foreach ($carteVTCTPC as $key => $value) {
  172.             $formations = [];
  173.             foreach ($value->getFormation() as $key => $formation) {
  174.                 array_push($formations,[
  175.                     "id"=>$formation->getId(),
  176.                     "wording" => $formation->getWording(),
  177.                 ]);
  178.             }
  179.             array_push($carteVTC["theoriepratiquecma"],
  180.             [
  181.                 "id" => $value->getId(),
  182.                 "wording" => $value->getWording(),
  183.                 "libellelibre" => $value->getLibellelibre(),
  184.                 "pricepersonal" => $value->getPricepersonal(),
  185.                 "pricecompany" => $value->getPricecompany(),
  186.                 "pricecpf" => $value->getPricecpf(),
  187.                 "formation" => count($formations) > 0?$formations:[]
  189.             ]);
  190.         }
  191.         foreach ($carteVTCC as $key => $value) {
  192.             $formations = [];
  193.             foreach ($value->getFormation() as $key => $formation) {
  194.                 array_push($formations,[
  195.                     "id"=>$formation->getId(),
  196.                     "wording" => $formation->getWording(),
  197.                 ]);
  198.             }
  199.             array_push($carteVTC["continue"],
  200.             [
  201.                 "id" => $value->getId(),
  202.                 "wording" => $value->getWording(),
  203.                 "libellelibre" => $value->getLibellelibre(),
  204.                 "pricepersonal" => $value->getPricepersonal(),
  205.                 "pricecompany" => $value->getPricecompany(),
  206.                 "pricecpf" => $value->getPricecpf(),
  207.                 "formation" => count($formations) > 0?$formations:[]
  208.             ]);
  209.         }
  210.         foreach ($carteVTCTPMR as $key => $value) {
  211.             $formations = [];
  212.             foreach ($value->getFormation() as $key => $formation) {
  213.                 array_push($formations,[
  214.                     "id"=>$formation->getId(),
  215.                     "wording" => $formation->getWording(),
  216.                 ]);
  217.             }
  218.             array_push($carteVTC["tpmr"],
  219.             [
  220.                 "id" => $value->getId(),
  221.                 "wording" => $value->getWording(),
  222.                 "libellelibre" => $value->getLibellelibre(),
  223.                 "pricepersonal" => $value->getPricepersonal(),
  224.                 "pricecompany" => $value->getPricecompany(),
  225.                 "pricecpf" => $value->getPricecpf(),
  226.                 "formation" => count($formations) > 0?$formations:[]
  227.             ]);
  228.         }
  229.         
  230.         $carte["vtc"] =$carteVTC;
  231.         // fin vtc
  233.         foreach ($carteTMT as $key => $value) {
  234.             $formations = [];
  235.             foreach ($value->getFormation() as $key => $formation) {
  236.                 array_push($formations,[
  237.                     "id"=>$formation->getId(),
  238.                     "wording" => $formation->getWording(),
  239.                 ]);
  240.             }
  241.             array_push($carteTM["theorie"],
  242.             [
  243.                 "id" => $value->getId(),
  244.                 "wording" => $value->getWording(),
  245.                 "libellelibre" => $value->getLibellelibre(),
  246.                 "pricepersonal" => $value->getPricepersonal(),
  247.                 "pricecompany" => $value->getPricecompany(),
  248.                 "pricecpf" => $value->getPricecpf(),
  249.                 "formation" => count($formations) > 0?$formations:[]
  251.             ]);
  252.         }
  253.         
  254.         foreach ($carteTMP as $key => $value) {
  255.             $formations = [];
  256.             //dd($value);
  257.             foreach ($value->getFormation() as $key => $formation) {
  258.                 array_push($formations,[
  259.                     "id"=>$formation->getId(),
  260.                     "wording" => $formation->getWording(),
  261.                 ]);
  262.             }
  263.             array_push($carteTM["pratique"],
  264.             [
  265.                 "id" => $value->getId(),
  266.                 "wording" => $value->getWording(),
  267.                 "libellelibre" => $value->getLibellelibre(),
  268.                 "pricepersonal" => $value->getPricepersonal(),
  269.                 "pricecompany" => $value->getPricecompany(),
  270.                 "pricecpf" => $value->getPricecpf(),
  271.                 "formation" => count($formations) > 0?$formations:[]
  273.             ]);
  274.         }
  275.         foreach ($carteTMTP as $key => $value) {
  276.             $formations = [];
  277.             foreach ($value->getFormation() as $key => $formation) {
  278.                 array_push($formations,[
  279.                     "id"=>$formation->getId(),
  280.                     "wording" => $formation->getWording(),
  281.                 ]);
  282.             }
  283.             array_push($carteTM["theoriepratique"],
  284.             [
  285.                 "id" => $value->getId(),
  286.                 "wording" => $value->getWording(),
  287.                 "libellelibre" => $value->getLibellelibre(),
  288.                 "pricepersonal" => $value->getPricepersonal(),
  289.                 "pricecompany" => $value->getPricecompany(),
  290.                 "pricecpf" => $value->getPricecpf(),
  291.                 "formation" => count($formations) > 0?$formations:[]
  293.             ]);
  294.         }
  295.         $carte['tm']=$carteTM;
  297.         foreach ($carteTI as $key => $value) {
  298.             $formations = [];
  299.             foreach ($value->getFormation() as $key => $formation) {
  300.                 array_push($formations,[
  301.                     "id"=>$formation->getId(),
  302.                     "wording" => $formation->getWording(),
  303.                 ]);
  304.             }
  305.             array_push($carteT["fi"],
  306.             [
  307.                 "id" => $value->getId(),
  308.                 "wording" => $value->getWording(),
  309.                 "libellelibre" => $value->getLibellelibre(),
  310.                 "pricepersonal" => $value->getPricepersonal(),
  311.                 "pricecompany" => $value->getPricecompany(),
  312.                 "pricecpf" => $value->getPricecpf(),
  313.                 "formation" => count($formations) > 0?$formations:[]
  315.             ]);
  316.         }
  317.         foreach ($carteTC as $key => $value) {
  318.             $formations = [];
  319.             foreach ($value->getFormation() as $key => $formation) {
  320.                 array_push($formations,[
  321.                     "id"=>$formation->getId(),
  322.                     "wording" => $formation->getWording(),
  323.                 ]);
  324.             }
  325.             array_push($carteT["fc"],
  326.             [
  327.                 "id" => $value->getId(),
  328.                 "wording" => $value->getWording(),
  329.                 "libellelibre" => $value->getLibellelibre(),
  330.                 "pricepersonal" => $value->getPricepersonal(),
  331.                 "pricecompany" => $value->getPricecompany(),
  332.                 "pricecpf" => $value->getPricecpf(),
  333.                 "formation" => count($formations) > 0?$formations:[]
  335.             ]);
  336.         }
  337.         foreach ($carteTTMP as $key => $value) {
  338.             $formations = [];
  339.             foreach ($value->getFormation() as $key => $formation) {
  340.                 array_push($formations,[
  341.                     "id"=>$formation->getId(),
  342.                     "wording" => $formation->getWording(),
  343.                 ]);
  344.             }
  345.             array_push($carteT["mp"],
  346.             [
  347.                 "id" => $value->getId(),
  348.                 "wording" => $value->getWording(),
  349.                 "libellelibre" => $value->getLibellelibre(),
  350.                 "pricepersonal" => $value->getPricepersonal(),
  351.                 "pricecompany" => $value->getPricecompany(),
  352.                 "pricecpf" => $value->getPricecpf(),
  353.                 "formation" => count($formations) > 0?$formations:[]
  355.             ]);
  356.         }
  357.         foreach ($carteTVTCTAXI as $key => $value) {
  358.             $formations = [];
  359.             foreach ($value->getFormation() as $key => $formation) {
  360.                 array_push($formations,[
  361.                     "id"=>$formation->getId(),
  362.                     "wording" => $formation->getWording(),
  363.                 ]);
  364.             }
  365.             array_push($carteT["vtctaxi"],
  366.             [
  367.                 "id" => $value->getId(),
  368.                 "wording" => $value->getWording(),
  369.                 "libellelibre" => $value->getLibellelibre(),
  370.                 "pricepersonal" => $value->getPricepersonal(),
  371.                 "pricecompany" => $value->getPricecompany(),
  372.                 "pricecpf" => $value->getPricecpf(),
  373.                 "formation" => count($formations) > 0?$formations:[]
  375.             ]);
  376.         }
  377.         $carte["t"] = $carteT;
  379.         foreach ($carteExamen as $key => $value) {
  380.             $formations = [];
  381.             foreach ($value->getFormation() as $key => $formation) {
  382.                 array_push($formations,[
  383.                     "id"=>$formation->getId(),
  384.                     "wording" => $formation->getWording(),
  385.                 ]);
  386.             }
  387.             array_push($carteE,
  388.             [
  389.                 "id" => $value->getId(),
  390.                 "wording" => $value->getWording(),
  391.                 "libellelibre" => $value->getLibellelibre(),
  392.                 "pricepersonal" => $value->getPricepersonal(),
  393.                 "pricecompany" => $value->getPricecompany(),
  394.                 "pricecpf" => $value->getPricecpf(),
  395.                 "formation" => count($formations) > 0?$formations:[]
  397.             ]);
  398.         }
  399.         $carte["examen"] = $carteE;
  401.         //examen taxi
  402.         foreach ($carteExamenTaxi as $key => $value) {
  403.             $formations = [];
  404.             foreach ($value->getFormation() as $key => $formation) {
  405.                 array_push($formations,[
  406.                     "id"=>$formation->getId(),
  407.                     "wording" => $formation->getWording(),
  408.                 ]);
  409.             }
  410.             array_push($carteETaxi,
  411.             [
  412.                 "id" => $value->getId(),
  413.                 "wording" => $value->getWording(),
  414.                 "libellelibre" => $value->getLibellelibre(),
  415.                 "pricepersonal" => $value->getPricepersonal(),
  416.                 "pricecompany" => $value->getPricecompany(),
  417.                 "pricecpf" => $value->getPricecpf(),
  418.                 "formation" => count($formations) > 0?$formations:[]
  420.             ]);
  421.         }
  422.         $carte["examenTaxi"] = $carteETaxi;
  423.         return new JsonResponse($carte);
  424.         
  425.     }
  428.     /**
  429.      * @Route("/api/carte/{id}", name="app_api_carte_detail",methods={"GET"})
  430.      */
  431.     public function getCarte(Carte $carte)
  432.     {
  433.         $response = $formations = [];
  434.        
  435.         foreach ($carte->getFormation() as $key => $formation) {
  436.             array_push($formations,[
  437.                 "id"=>$formation->getId(),
  438.                 "wording" => $formation->getWording(),
  439.             ]);
  440.         }
  442.         $response = [
  443.             "id" => $carte->getId(),
  444.             "wording" => $carte->getWording(),
  445.             "libellelibre" => $carte->getLibellelibre(),
  446.             "prerequis" => $carte->getPrerequis(),
  447.             "pricepersonal" => $carte->getPricepersonal(),
  448.             "pricecompany" => $carte->getPricecompany(),
  449.             "pricecpf" => $carte->getPricecpf(),
  450.             "formation" => count($formations) > 0?$formations:[]
  451.         ];
  453.         return new JsonResponse($response);
  454.     }
  456.     /**
  457.      * @Route("/carte/inscription/{session}", name="app_inscrit_site_carte", methods={"GET", "POST"})
  458.      */
  459.     public function carteView(CarteRepository $carteRepository,$session=null){
  460.         
  461.         $carte = [];
  462.         
  463.         
  464.         $carteTM = $carteRepository->findBy(['site'=>2]);
  465.         $carteVTC = $carteRepository->findBy(['site'=>3]);
  466.     
  467.         
  468.         
  469.         /*if ($request->getMethod()=='POST') {
  470.             $carte = $request->request->get('carte');
  471.         }*/
  472.         
  473.         return $this->renderForm('inscription_site/carte.html.twig',[
  474.             
  475.             'carteTM' =>$carteTM,
  476.             'carteVTC'=> $carteVTC,
  477.             'menuLink' => 'inscription',
  478.             'path' => 'app_inscrit_index',
  479.             'page' => 'Carte',
  480.             'menu' => ''
  481.         ]);
  482.         
  483.     }
  484.     private function cleanValueFromRequest($temp){
  485.         return trim($temp);
  486.     }
  487.     /**
  488.      * @Route("/nouvelle/insciption/", name="app_inscrit_site_new", methods={"GET", "POST"})
  489.      */
  490.     public function new(EntityManagerInterface $em,Request $request, InscritRepository $inscritRepository,SiteRepository $siteRepository,FormationRepository $formationRepository,TypeInscritRepository $typeInscritRepository, ReglementRepository $reglementRepository,TierRepository $tierRepository,FileUploader $fileUploader,OrganismeRepository $organimseRepository,
  491.     StatusInscritRepository $statusInscritRepository,CarteRepository $carteRepository,OptionCategorieInscritRepository $optionCategorieInscritRepository,DemandeRepository $demandeRepository, StatusRepository $statusRepository,MoyPaiementRepository $moyPaiementRepository,CondRegleRepository $condRegleRepository,SourceFinanceRepository $sourceFinanceRepository,
  492.     SessionRepository $sessionRepository,UniteInscriptionRepository $uniteInscriptionRepository,ExamenRepository $examenRepository,ElearningRepository $elearningRepository,EntrepriseRepository $entrepriseRepository,MailerController $mailer, MailerInterface $mailerinterf,ApiElearning $apiElearning)
  493.     {
  494.         $inscrit = new Inscrit();
  495.         //$form = $this->createForm(InscritType::class, $inscrit);
  496.         $defaultData=['message'=>'type'];
  497.         $form=$this->createFormBuilder($defaultData)->getForm();
  498.         
  499.         $form->handleRequest($request);
  500.         // get all site
  501.         $site_id = $request->query->get('site');
  502.         $isElearning = false; // c'est pour afficher le message mail elearning envoye 
  503.         if ($site_id != null) {
  504.             $carte = $carteRepository->find($site_id);
  505.             if ($carte == null) {
  506.                 throw new Exception("Error Processing carte", 1);
  507.             }
  508.             //dd($carte->getFormation()[2]->getWording());
  509.             
  510.         }else {
  511.             throw new Exception("Error Processing Request site", 1);
  512.             
  513.         }
  514.         //if ($this->isGranted('ROLE_ADMIN')) {
  515.             $site = $siteRepository->find($carte->getSite()->getId());
  516.             //dd($site);
  517.         /*}
  518.         else{
  519.             $site = $siteRepository->findBy(["id"=>(string)$this->getUser()->getSite()->getId()], ["id" => "DESC"]);
  520.         }*/
  521.         //get formation
  522.         $formation = $carte->getFormation();
  523.         
  524.         $sessionArray = [];
  525.         
  526.         for ($i=0; $i < count($formation); $i++) {             
  527.             //dump($formation[$i]->getTypeformation());
  528.             if ($formation[$i]->getTypeformation() == 1 ) {
  529.                 $tempSession = $sessionRepository->findBy(['formation'=>$formation[$i]->getId(),'status'=>[1,2],'modeapprentissage'=>$carte->getModeapprentissage()]);
  530.                 $onlySessionForPole = [];
  531.                 for ($j=0; $j < count($tempSession); $j++) { 
  532.                     if ($tempSession[$j]->getSite()->getId() == $carte->getSite()->getId()) {
  533.                         array_push($onlySessionForPole,$tempSession[$j]);
  534.                     }
  535.                 }
  536.                 $sessionArray[$i] = $onlySessionForPole;
  537.             }
  538.             elseif ($formation[$i]->getTypeformation() == 2) { //2 pour e learning
  539.                 //$tempSession = $elearningRepository->findBy(['is_archived'=>false]);
  540.                 $sessionArray[$i] = ['elearning'];
  541.                 
  542.             }
  543.             elseif ($formation[$i]->getTypeformation() == 3) { //2 pour examen
  544.                 $tempSession = $examenRepository->findBy(['is_archived'=>false]);
  545.                 $sessionArray[$i] = $tempSession;
  546.                 
  547.                 //dd($formation[$i]);
  548.                 
  549.             }
  550.             elseif ($formation[$i]->getTypeformation() == 4) { //4 pour conduite
  551.                 //$tempSession = $elearningRepository->findBy(['is_archived'=>false]);
  552.                 $sessionArray[$i] = ['conduite'];
  553.                 
  554.             }
  555.             //unset($tempSession);
  556.             //dump($sessionArray[$i]);
  557.         }
  558.                 
  559.         //get optioncategori
  560.         $optioncategorieinscrit = $optionCategorieInscritRepository->findAll();
  561.         //$request->getMethod()=='POST'
  562.         if ($request->getMethod()=='POST') {
  563.             $buttonSubmitPaiement = $request->request->get('paeiement');
  564.             $inscritavecpaiement = $buttonSubmitPaiement == 1?true:false; // 1 pour paiement 
  565.             $em->getConnection()->beginTransaction();
  566.             try{
  567.                 
  568.                    
  569.                     $uniteinscription = new UniteInscription();
  570.                    
  571.                     //creer entite justiffouri puis passer le fichier uploader avant de lui faire un push
  573.                     
  574.                     //$formation = $formationRepository->find($request->request->get('formation'));
  575.                     $sessions = $request->request->get('session');
  576.                     $examens = $request->request->get('examen');
  577.                     $conduites = $carte->getHeureconduite();
  578.                     $typeInscrit = $typeInscritRepository->find(1);
  579.                     $statusinscrit = $statusInscritRepository->find(1/*$request->request->get('statutinscrit')*/);
  580.                     
  581.                     $condRegle = $condRegleRepository->find(1);
  582.                     $sourceF = $sourceFinanceRepository->find($request->request->get('typeIns'));
  583.                     $categorieinscrit = $request->request->get('categorieinscrit');
  584.                     
  585.                     
  586.     
  587.                     //information sur le tier
  588.                     $tier = new Tier();
  589.                     $tier->setLastname($this->cleanValueFromRequest($request->request->get('lastname')))
  590.                         ->setFirstname($this->cleanValueFromRequest($request->request->get('firstname')))
  591.                         ->setSexe($this->cleanValueFromRequest($request->request->get('civilite')))
  592.                         ->setTelephone($this->cleanValueFromRequest($request->request->get('telephone')))
  593.                         ->setEmail($this->cleanValueFromRequest($request->request->get('email')));
  594.                     if ($tierRepository->findOneBy(["email"=>$tier->getEmail()]) == null) {
  595.                         /*$this->addFlash("message", "Cette adresse mail ".$tier->getEmail()." est déjà utilisée !");
  596.                         
  597.                         return $this->redirect($request->headers->get('referer'));*/
  598.                         $tierRepository->add($tier,true);
  599.                     }
  600.                     $tier = $tierRepository->findOneBy(["email"=>$tier->getEmail()]);
  601.                     //dd($tier->getId());
  602.                     $uniteinscription->setStatutinscrit($statusinscrit)
  603.                                     ->setCreatedat(new \DateTime())
  604.                                     ->setSourcefinancement($sourceF)
  605.                                     ->setCategorieinscrit($categorieinscrit)
  606.                                     ->setCarte($carte)
  607.                                     ->setTier($tier)
  608.                                     ->setRemise(0/*$request->request->get('remise')*/)
  609.                                     ->setMontantapresremise($carte->getPricepersonal()/*$request->request->get('montantremise')*/)
  610.                                     ->setTypeinscrit($typeInscrit)
  611.                                     ->setMontanttotal($carte->getPricepersonal()/*$request->request->get('montantTotal')*/)
  612.                                     ->setSourceinscription("Site");
  614.                     
  615.                     //dd($uniteinscription);
  616.                     
  617.                     
  618.                     
  619.                     
  621.                     foreach($carte->getFormation() as $key => $formation)
  622.                     {
  623.                         if ($formation->getTypeformation() == 1) {
  624.                             
  625.                             $session = null;
  626.                             if(!is_array($sessions))
  627.                                 throw new Exception('Les session attendues devraient etre de type "array" ou "iterable object"');
  628.                                 
  629.                             foreach ($sessions as $sessionValue) {
  630.                                     $session = $sessionRepository->findOneBy(['id'=>$sessionValue,'formation'=>$formation]);
  631.                                     if ($session != null) {
  632.                                         break;
  633.                                     }
  634.                                 }
  635.                             
  636.                             //dump($formation->getWording());
  637.                             if($session == null)
  638.                             {
  639.                                //dd("session null");
  640.                                 $this->addFlash("message", "Oups!!! Une erreur est survenue lors de l'inscription du stagiaire. Une session n'a pas été retrouvée. Veuillez reprendre svp!");
  641.                                 return $this->redirect($request->headers->get('referer'));
  642.                                 
  643.                             }
  645.                             $tierinsession = $inscritRepository->findOneBy(['session' => $session, 'tier' => $tier, 'isdelete' => false]);
  646.                             if($tierinsession != null)
  647.                             {
  648.                                 //dd("session deja");
  649.                                
  650.                                 $this->addFlash("message", "Le stagiaire ".$tier->getLastname()." ".$tier->getFirstname()." a déjà été inscrit à cette session!");
  651.                                 
  652.                                 return  $this->redirect($request->headers->get('referer'));
  653.                             }
  655.                             $inscrit = (new Inscrit())->setUniteinscription($uniteinscription)
  656.                                                         ->setSession($session)
  657.                                                         ->setFormation($formation)
  658.                                                         ->setTypeinscrit($typeInscrit)
  659.                                                         ->setTier($tier)
  660.                                                         ->setIsdelete(false)
  661.                                                         ->setCreatedAt(new \DateTime());
  662.                             $uniteinscription->addInscrit($inscrit);
  664.                             //upload fichiers justif
  665.                             //retourne array du nombre de pieces requises et du nombre founi pour la formation
  666.                             //array_push($jaugejustifs, $this->uploadInscriptionJustif($fichier, $inscrit, $formation));  
  667.                         }
  668.                         elseif ($formation->getTypeformation() == 2) {
  669.                             //$conduites = (array)$conduites;
  670.                             //$session = $elearningRepository->find(key_exists($key, $conduites) ? $conduites[$key] : 0); //if key doesn't exist will return null and fail 
  671.                             $dateDebut = $request->request->get('datedebut');
  672.                             $dateFin = $request->request->get('datefin');
  674.                             
  675.                             if ($request->request->get('datedebut') == null ) {
  676.                                 //dd("date");
  677.                                 $this->addFlash("message", "Oups!!! Une erreur est survenue lors de l'inscription du stagiaire. Date de début et fin obligatoire. Veuillez reprendre svp!");
  678.                                 return $this->redirect($request->headers->get('referer'));
  679.                             }
  681.                             //definition des dates de debut et de fin au cas ou cest une carte examen
  682.                             if((int)$carte->getDuree() > 0 && (int)$carte->getThinkificFormationId() > 0)
  683.                             {
  684.                                 $dateDebut = date("Y-m-d H:i:s");
  685.                                 $dateFin = date('Y-m-d H:i:s', strtotime($dateDebut. ' + '.$carte->getDuree().' days'));
  686.                             }
  688.                             
  689.                             $elearning = new Elearning();
  690.                             $elearning->setDatedebut(new \DateTime($dateDebut))
  691.                                     ->setDatefin(new \DateTime($dateFin))
  692.                                     ->setIsArchived(false);
  693.                             $inscrit = (new Inscrit())->setUniteinscription($uniteinscription)
  694.                                                         ->setElearning($elearning)
  695.                                                         ->setFormation($formation)
  696.                                                         ->setTypeinscrit($typeInscrit)
  697.                                                         ->setTier($tier)
  698.                                                         ->setIsdelete(false)
  699.                                                         ->setCreatedAt(new \DateTime());
  700.                             $uniteinscription->addInscrit($inscrit);
  701.                             $isElearning = true;
  702.                             
  703.                             //dd($elearning);
  704.                             //upload fichiers justif
  705.                             //retourne array du nombre de pieces requises et du nombre founi pour la formation
  706.                             //array_push($jaugejustifs, $this->uploadInscriptionJustif($fichier, $inscrit, $formation));  
  707.                         }
  708.                         elseif ($formation->getTypeformation() == 3) { //3 examen
  709.                             
  710.                             $session = $examenRepository->find($examens); //if key doesn't exist will return null and fail 
  711.                             
  712.                             if($session == null)
  713.                             {
  714.                                 //dd("examen");
  715.                                 $this->addFlash("message", "Oups!!! Une erreur est survenue lors de l'inscription du stagiaire. La date d'examen n'a pas été retrouvée. Veuillez reprendre svp!");
  716.                                 return $this->redirect($request->headers->get('referer'));
  717.                             }
  719.                             $tierinsession = $inscritRepository->findOneBy(['elearning' => $session, 'tier' => $tier, 'isdelete' => false]);
  720.                            
  722.                             $inscrit = (new Inscrit())->setUniteinscription($uniteinscription)
  723.                                                         ->setExamen($session)
  724.                                                         ->setFormation($formation)
  725.                                                         ->setTypeinscrit($typeInscrit)
  726.                                                         ->setTier($tier)
  727.                                                         ->setIsdelete(false)
  728.                                                         ->setCreatedAt(new \DateTime());
  729.                             $uniteinscription->addInscrit($inscrit);
  731.                             //upload fichiers justif
  732.                             //retourne array du nombre de pieces requises et du nombre founi pour la formation
  733.                             //array_push($jaugejustifs, $this->uploadInscriptionJustif($fichier, $inscrit, $formation));  
  734.                         }
  735.                         elseif ($formation->getTypeformation() == 4) { //4 conduite
  736.                             
  737.                             //$session = $examenRepository->find($examens); //if key doesn't exist will return null and fail 
  738.                             
  739.                             if($conduites == null)
  740.                             {
  741.                                //dd("conduite");
  742.                                 $this->addFlash("message", "Oups!!! Une erreur est survenue lors de l'inscription du stagiaire. Les heures de conduite n'ont pas été retrouver. Veuillez reprendre svp!");
  743.                                 return $this->redirect($request->headers->get('referer'));
  744.                             }
  746.                             
  747.                             
  748.                             $inscrit = (new Inscrit())->setUniteinscription($uniteinscription)
  749.                                                         ->setConduiteheure($conduites)
  750.                                                         ->setFormation($formation)
  751.                                                         ->setTypeinscrit($typeInscrit)
  752.                                                         ->setTier($tier)
  753.                                                         ->setIsdelete(false)
  754.                                                         ->setCreatedAt(new \DateTime());
  755.                             $uniteinscription->addInscrit($inscrit);
  757.                             //upload fichiers justif
  758.                             //retourne array du nombre de pieces requises et du nombre founi pour la formation
  759.                            // array_push($jaugejustifs, $this->uploadInscriptionJustif($fichier, $inscrit, $formation));  
  760.                         }
  761.                         
  762.                     }
  763.                    
  764.                     //dd("regle");
  765.                     if ($sourceF->getId() == 2) //personnel
  766.                     {
  767.                         $reglement= new Reglement();
  768.                         $moyenPaiement = 1;//$request->request->get('moypaiement');
  769.                         $reglement->setMontanttotal($carte->getPricepersonal())
  770.                                 ->setMontantapresremise($carte->getPricepersonal()/*$request->request->get('montantremise')*/)
  771.                                 ->setRemise(0/*$request->request->get('remise')*/)
  772.                                 ->setModpaiement($moyPaiementRepository->find($moyenPaiement))
  773.                                 ->setMontant((float)0/*$request->request->get('montantpayer')*/)
  774.                                 ->setCreatedat(new \DateTime($request->request->get('dateregle')));
  775.                         if($carte->getPricepersonal()/*$request->request->get('restepayer')*/ != ""){
  776.                             $reglement->setRestepayer(/*$request->request->get('restepayer')*/$carte->getPricepersonal());
  777.                         }
  778.                         //}
  779.                         //dump("source");
  780.                         $financement = new Financement();
  781.                         $financement->setTypeF("1")
  782.                                     ->setConditionreglement($condRegle);
  783.                         $uniteinscription->addFinancement($financement);
  784.                         
  785.                         $financement->setMontant($carte->getPricepersonal());
  786.                         if($request->request->get('restepayer') != ""){
  787.                             $reste = (float)$carte->getPricepersonal();//$request->request->get('restepayer');
  789.                             //unset auto validation
  790.                             /*if($statusInscritRepository->find(2) != null && (float)$request->request->get('montantpayer') > 0) 
  791.                                 $statusinscrit=$statusInscritRepository->find(2);*/
  792.                             
  793.                             if ($reste == 0) {
  794.                                 $inscrit->setRegler("Réglé");
  795.                             }else if ($reste > 0){
  796.                                 $inscrit->setRegler("Partiellement réglé");
  797.                             }
  798.                         }else{
  799.                             $inscrit->setRegler("Non réglé");
  800.                         }
  801.                         //$financement->
  802.                         
  803.                         if(isset($reglement))
  804.                         {
  805.                             //frequence of reglement of tranches if financement personnelle 
  806.                             $financement->setFrequence(1);
  807.                             //echeanceInscrit
  808.                             $tranche = (int)$condRegle->getWording();
  809.                             $dateEcheance = date('Y-m-d'); //$request->request->get('dateecheance');
  810.                             if ($dateEcheance == null) {
  811.                                // dump("date");
  812.                                 $this->addFlash("message", "Oups!!!. Veuillez indiquer la date du début de l'échéance!");
  813.                                 return $this->redirect($request->headers->get('referer'));
  814.                             }
  815.                             $dateEcheance = date_create($dateEcheance);
  816.                             $montantEcheance = 0.00;
  817.                             if($tranche<=0)
  818.                                 $tranche=1;//prevent division by zero
  820.                             $montantEcheance =$carte->getPricepersonal();
  821.                              //round(($carte->getPricepersonal() - (float)$carte->getPricepersonal())/$tranche, 2);
  823.                             $next_date = new \DateTime(date('Y-m-d', strtotime(date('Y-m-d', $dateEcheance->getTimestamp()). ' + 1 days')));
  825.                             $echeanceInscrit = new EcheanceInscrit();
  826.                             $echeanceInscrit->setMontantEcheance($montantEcheance);
  827.                             $echeanceInscrit->setMontantRegle(0.00);
  828.                             $echeanceInscrit->setRestearegler($montantEcheance);
  829.                             $echeanceInscrit->setDateEcheance($next_date);
  830.                             $echeanceInscrit->setCreatedAt(new \DateTimeImmutable());
  831.                             $financement->addEcheanceInscrit($echeanceInscrit);
  833.                             for($i=2; $i<=$tranche; $i++)
  834.                             {
  835.                                 $next_date = new \DateTime(date('Y-m-d', strtotime(date_format($next_date, 'Y-m-d'). ' + 1 days')));
  836.                                 $echeanceInscrit = new EcheanceInscrit();
  837.                                 $echeanceInscrit->setMontantEcheance($montantEcheance);
  838.                                 $echeanceInscrit->setMontantRegle(0.00);
  839.                                 $echeanceInscrit->setRestearegler($montantEcheance);
  840.                                 $echeanceInscrit->setDateEcheance($next_date);
  841.                                 $echeanceInscrit->setCreatedAt(new \DateTimeImmutable());
  842.                                 $financement->addEcheanceInscrit($echeanceInscrit);
  843.                             }
  844.                         }
  845.                         
  846.                         //imputations start if montant regle > 0
  847.                         if(isset($reglement))
  848.                         {
  849.                             //$this->imputerReglerAEcheance($reglement, $financement);
  850.                             $reglement->setFinancement($financement);
  851.                             $financement->addReglement($reglement);
  852.                             $reglementRepository->add($reglement,true);
  853.                         }
  854.                         
  856.                         //update inscrit statutregle(non regle, partiellement regle or regle after each imputation)
  857.                         //$this->setInscritStatutRegle($uniteinscription);
  858.                         
  859.                     }
  860.                     elseif ($sourceF->getId() == 4) {
  861.                         $financement2 = new Financement();
  862.                         $financement2->setTypeF("3"); // cpf
  863.                        
  864.                         $montant =$carte->getPricecpf();
  865.                         if ($montant != "") {
  866.                             $financement2->setMontant($montant);
  867.                         }
  868.                         //l'inscrit est passe au statut réglé automatiquement si CPF
  869.                         $uniteinscription->setRegler("Réglé");
  870.                         $uniteinscription->addFinancement($financement2);
  871.                         $uniteInscriptionRepository->add($uniteinscription);
  872.                         //dd($financement2);
  873.                         
  874.                         
  875.                     }
  876.                     //dd($carte->getPricecpf());
  877.                     //dd("fd");
  878.                     //calcul jauge des pieces fournis
  879.                     /*foreach($jaugejustifs as $justif)
  880.                     {
  881.                         $nbrFourni += (int)$justif["fourni"];
  882.                         $nbrRequis += (int)$justif["requis"];
  883.                     }
  884.                     
  885.                     if($nbrRequis == 0)
  886.                         $nbrRequis=1;
  887.                     */
  888.                     $uniteinscription->setPiecefourni(0) ;
  889.                     //fin calcul jauge
  890.                     
  892.                    // if(isset($reglement))
  893.                      //   $reglementRepository->add($reglement,true);
  894.                     
  895.                     if ($tier->getEmail() != null) {
  896.                         $mailer->sendPreinscriptionMail($mailerinterf,$uniteinscription);
  897.                     }
  898.                     
  899.                     
  900.                     
  901.                     $em->flush();
  902.                     $em->getConnection()->commit();
  903.                     
  904.                 } catch (Exception $e) {
  905.                     $em->getConnection()->rollBack();
  906.                     
  907.                     throw $e;
  908.                 }
  909.                 if($inscritavecpaiement){
  910.                     $apiPaiementController = new ApiPaiementController();
  911.                     $getDateForHMAC = $apiPaiementController->sendRequestPayment($uniteinscription->getMontanttotal(),$tier->getLastname(),$tier->getFirstname(),$tier->getEmail(), $uniteinscription->getId());
  912.                     $getDateForHMAC = json_decode($getDateForHMAC->getContent());
  913.                     $n = '1';
  914.                     $pbx_shoppingcart = "<?xml version=\"1.0\" encoding=\"utf-8\"?><shoppingcart><total><totalQuantity>".$n."</totalQuantity></total></shoppingcart>";
  915.                     
  916.                     return $this->render('inscription_site/paiement.html.twig',[
  917.                         'status'=>'success',
  918.                         'PBX_HMAC'=>$getDateForHMAC->hmac,
  919.                         'PBX_BILLING'=>$getDateForHMAC->billing,
  920.                         'PBX_TOTAL'=>$getDateForHMAC->total,
  921.                         'PBX_PORTEUR'=>$getDateForHMAC->email,
  922.                         'PBX_CMD'=> $getDateForHMAC->id,
  923.                         'PBX_TIME'=> $getDateForHMAC->time,
  924.                         'pbx_shoppingcart' => $pbx_shoppingcart
  925.                     ]);
  926.                 }else{
  927.                     if ($carte->getSite()->getId() == 1) {
  928.                         return $this->render('inscription_site/terminer.html.twig',[
  929.                             'path'=>'https://www.taxi.ecole-chauffeur-prive.fr/',
  930.                             'elearning'=>false
  931.                         ]);        
  932.                     }
  933.                     return $this->render('inscription_site/terminer.html.twig',[
  934.                         'path'=>'https://www.ecole-chauffeur-prive.fr/',
  935.                         'elearning'=>false]);
  936.                 }
  937.         }
  939.         //les pieces justificatives de toutes les formations
  940.         //$cartejutificatifs = $this->getCarteJustificatif($formation);
  941.         
  942.         return $this->renderForm('inscription_site/inscription.html.twig', [
  943.             'inscrit' => $inscrit,
  944.             //'form' => $form,
  945.             
  946.             
  947.             'menu' => 'Inscription',
  948.             'page' => 'Nouvelle inscription',
  949.             'menuLink' => 'inscription',
  950.             'path'=>'app_inscrit_index',
  951.             'sites'=>$site,
  952.             'carte' => $carte,
  953.             'formations'=>$formation,
  954.             'session'=>$sessionArray,
  955.             'datedebutelearning' => new \DateTime(date("Y-m-d H:i:s")),
  956.             'datefinelearning' => new \DateTime(date('Y-m-d H:i:s', strtotime(date("Y-m-d H:i:s"). ' + '.$carte->getDuree().' days'))),
  957.           
  958.             'conduitehoure'=>$carte->getHeureconduite(),
  959.             
  960.             
  961.             //'cartejutificatifs' => $cartejutificatifs,
  962.             'optioncategorieinscrit'=>$optioncategorieinscrit
  963.         ]);
  964.     }
  965. }