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