src/Controller/ApprenantController.php line 504

Open in your IDE?
  1. <?php
  2. // src/Controller/ApprenantController.php
  3. namespace App\Controller;
  5. use DateTimeZone;
  6. use IntlDateFormatter;
  8. use Symfony\Component\HttpFoundation\Request;
  9. use Symfony\Component\HttpFoundation\Response;
  10. use Symfony\Component\HttpFoundation\JsonResponse;
  11. use Symfony\Component\HttpFoundation\BinaryFileResponse;
  12. use Symfony\Component\HttpFoundation\ResponseHeaderBag;
  13. use Symfony\Component\Routing\Annotation\Route;
  15. use Symfony\Component\Filesystem\Filesystem;
  17. use Symfony\Contracts\HttpClient\HttpClientInterface;
  18. use Symfony\Component\DependencyInjection\ContainerInterface;
  20. use App\Classes\GeneratePDF;
  22. /**
  23.  * @Route("/apprenant", name="apprenant_")
  24.  */
  25. class ApprenantController extends DigiEntityController
  26. {
  27.     const REF = 'apprenant';
  28.     const NAME = 'Apprenant';
  29.     const CERFA_PDF_NUM = '14';
  31.     public function field_format($name, $field, $options=[])
  32.     {
  33.         $html = '';
  34.         $style = '';
  35.         $digi_map = (!empty($field['digi_map']) && is_string($field['digi_map']) ?' data-digi="'.$field['digi_map'].'"' :'');
  36.         if (!empty($field['align']))
  37.             $style .= 'text-align: '.$field['align'].';';
  38.         if (!empty($field['width']))
  39.             $style .= 'width: '.$field['width'].';';
  40.         // True par défaut
  41.         $required = !isset($field['required']) || $field['required'];
  42.         $class = ($required ?'required' :'');
  44.         if (!empty($field['premsg']))
  45.             $html .= '<span class="msg">'.$field['premsg'].'</span>&nbsp;';
  47.         if (!empty($options['checkbox_to_radio']))
  48.             $class .= ' radio';
  50.         if ($field['type']=='checkbox') {
  51.             if (isset($field['values']['Yes']))
  52.                 $value_ok = 'Yes';
  53.             else
  54.                 $value_ok = 'Oui';
  55.             $html .= '<input type="checkbox" id="'.$name.'"'.$digi_map.' name="'.$name.'" value="'.$value_ok.'"'.($field['value']==$value_ok ?' checked' :'').($class ?' class="'.$class.'" ' :'').($style ?' style="'.$style.'" ' :'').' />&nbsp;<label for="'.$name.'">'.$field['values'][$value_ok].'</label>';
  56.         }
  57.         elseif ($field['type']=='radio') {
  58.             foreach($field['values'] as $value=>$label)
  59.                 $html .= '<input type="radio" id="'.$name.'_'.$value.'"'.$digi_map.' name="'.$name.'" value="'.$value.'"'.($field['value']==$value ?' checked' :'').' />&nbsp;<label for="'.$name.'_'.$value.'">'.$label.'</label>';
  60.         }
  61.         elseif ($field['type']=='select') {
  62.             $html .= '<select id="'.$name.'"'.$digi_map.' name="'.$name.'"'.($class ?' class="'.$class.'" ' :'').($style ?' style="'.$style.'" ' :'').' data-value="'.$field['value'].'"'.($required ?' required' :'').'>'.(empty($field['noempty']) ?'<option value=""></option>' :'');
  63.             foreach($field['values'] as $value=>$select_option) {
  64.                 if (is_array($select_option)) {
  65.                     $label = $select_option['label'];
  66.                     $disabled = !empty($select_option['disabled']) || in_array('disabled', $select_option);
  67.                 }
  68.                 else {
  69.                     $label = $select_option;
  70.                     $disabled = false;
  71.                 }
  72.                 $html .= '<option value="'.$value.'"'.($field['value']==$value ?' selected' :'').($disabled ?' disabled' :'').' data-detail="'.htmlspecialchars(json_encode($select_option)).'">'.$label.'</option>';
  73.             }
  74.             $html .= '</select>';
  75.         }
  76.         elseif ($field['type'] =='date') {
  77.             $html .= '<input type="date" id="'.$name.'"'.$digi_map.' name="'.$name.'" placeholder="'.$field['label'].'" value="'.$field['value'].'" data-value="'.$field['value'].'"'.(!empty($field['maxlength']) ?' size="'.$field['maxlength'].'" maxlength="'.$field['maxlength'].'"' :'').($class ?' class="'.$class.'" ' :'').($style ?' style="'.$style.'" ' :'').($required ?' required' :'').' />';
  78.         }
  79.         elseif ($field['type'] =='textarea') {
  80.             $html .= '<textarea id="'.$name.'"'.$digi_map.' name="'.$name.'" placeholder="'.$field['label'].'" data-value="'.$field['value'].'"'.(!empty($field['maxlength']) ?' size="'.$field['maxlength'].'" maxlength="'.$field['maxlength'].'"' :'').($class ?' class="'.$class.'" ' :'').($style ?' style="'.$style.'" ' :'').($required ?' required' :'').' />'.$field['value'].'</texrarea>';
  81.         }
  82.         else { // text
  83.             $html .= '<input type="text" id="'.$name.'"'.$digi_map.' name="'.$name.'" placeholder="'.$field['label'].'" value="'.$field['value'].'" data-value="'.(isset($field['value']) ?$field['value'] :'').'"'.(!empty($field['maxlength']) ?' size="'.$field['maxlength'].'" maxlength="'.$field['maxlength'].'"' :'').($class ?' class="'.$class.'" ' :'').($style ?' style="'.$style.'" ' :'').($required ?' required' :'').' />'.(!empty($field['unit']) ?'&nbsp;'.$field['unit'] :'');
  84.         }
  85.         if (empty($field['noreset']) && empty($options['noreset']) && ! in_array($field['type'], ['checkbox']))
  86.             $html .= '&nbsp;<span class="reset" data-for="'.$name.'">X</span>';
  87.         if (!empty($field['digi_map']))
  88.             $html .= '&nbsp;<span class="digi_mapped" title="'.$field['digi_map'].'">D</span>';
  89.         elseif (!isset($field['digi_map']) || $field['digi_map']!==false)
  90.             $html .= '&nbsp;<span class="digi_unmapped">D</span>';
  91.         if (!empty($field['postmsg']))
  92.             $html .= '&nbsp;<span class="msg">'.$field['postmsg'].'</span>';
  94.         return $html;
  95.     }
  97.     /**
  98.     * @Route("/{id}/certificat", name="certificat")
  99.     */
  100.     public function CertificatAction(Request $request): Response
  101.     {
  102.         if (!($params = $this->cerfa_params($request)))
  103.             die('Paramètres invalides');
  105.         extract($params);
  106.         //var_dump($params); die();
  108.         $locale = 'fr_FR';
  109.         $timezone = 'Europe/Paris';
  110.         setlocale(LC_ALL, $locale);
  111.         date_default_timezone_set($timezone);
  113.         $datetimezone = new DateTimeZone($timezone);
  114.         $dayformatter = new IntlDateFormatter(
  115.             $locale,  // the locale to use, e.g. 'en_GB'
  116.             IntlDateFormatter::FULL,  // how the date should be formatted, e.g. IntlDateFormatter::FULL
  117.             IntlDateFormatter::FULL,  // how the time should be formatted, e.g. IntlDateFormatter::FULL 
  118.             $timezone  // the time should be returned in which timezone?
  119.         );
  120.         $dayformatter->setPattern('dd/mm/YYYY');
  122.         $dayformatter = new IntlDateFormatter(
  123.             $locale,  // the locale to use, e.g. 'en_GB'
  124.             IntlDateFormatter::FULL,  // how the date should be formatted, e.g. IntlDateFormatter::FULL
  125.             IntlDateFormatter::FULL,  // how the time should be formatted, e.g. IntlDateFormatter::FULL 
  126.             $timezone  // the time should be returned in which timezone?
  127.         );
  128.         $dayformatter->setPattern('d MMMM YYYY');
  130.         // Params
  131.         $this->params = [
  132.             'date' => $dayformatter->format(new \DateTime()),
  133.             'apprenant' => $apprenant,
  134.             'session' => $session,
  135.             'company' => $company,
  136.             'program' => $program,
  137.         ];
  139.         // Twig template
  140.         $tplfile = 'apprenant/certificat.html.twig';
  141.         
  142.         return $this->render($tplfile, $this->params);
  144.     }
  147.     /**
  148.     * @Route("/cerfa_list", name="cerfa_list")
  149.     */
  150.     public function CERFAListAction(Request $request): Response
  151.     {
  152.         $repository = $this->em->getRepository('App\\Entity\\Financeur');
  153.         $f = $repository->findByQ('CERFA');
  154.         //var_dump($f);
  156.         $repository = $this->em->getRepository('App\\Entity\\SessionCustomer');
  157.         $customer_list = $repository->findByQ('CERFA');
  159.         // Traitement
  160.         $list = [];
  161.         foreach($customer_list as $customer) {
  162.             foreach($customer->getApprenants() as $apprenant) {
  163.                 $list[] = [
  164.                     'customer'=>$customer,
  165.                     'apprenant'=>$apprenant,
  166.                     'entreprise'=>$customer->getEntreprise(),
  167.                     'session'=>$customer->getSession(),
  168.                 ];
  169.             }
  170.         }
  171.         usort($list, function($a, $b){
  172.             $i = $a['apprenant']->getContratSignature();
  173.             $j = $b['apprenant']->getContratSignature();
  174.             //var_dump($a['apprenant']->getNom(), $i); echo '<br />'; var_dump($b['apprenant'], $b['apprenant']->getNom(), $j, $i==$j, $i<$j); echo '<hr />';
  175.             if ($i==$j)
  176.                 return 0;
  177.             return ($i<$j) ?-1 :1;
  179.         });
  180.         //var_dump($list);
  181.         //die();
  183.         // Params
  184.         $this->params();
  185.         $this->params['page']['head']['title'] = 'Formulaires Cerfa';
  186.         $this->params['page']['subtitle'] = 'Liste des CERFA à faire';
  187.         $this->params['page']['breadcrumbs'][] = [
  188.             'route' => static::REF.'_cerfa_list',
  189.             'label' => 'Liste',
  190.         ];
  191.         $this->params['f'] = $f;
  192.         $this->params['list'] = $list;
  194.         // Twig template
  195.         $tplfile = 'apprenant/cerfa_list.html.twig';
  196.         
  197.         return $this->render($tplfile, $this->params);
  198.     }
  200.     /**
  201.     * @Route("/{id}/cerfa", name="cerfa")
  202.     */
  203.     public function CERFAAction(Request $request): Response
  204.     {
  205.         if (!($params = $this->cerfa_params($request)))
  206.             die('Paramètres invalides');
  208.         extract($params);
  210.         //var_dump($session); die();
  211.         $cerfa = $this->getCERFA();
  212.         $data = $cerfa->cerfa_mapping($id, $customer_id);
  214.         $mapping = $data['mapping'];
  215.         $cat_list = $data['cat_list'];
  217.         $html = '<table style="width: 100%;" border="0" cellpadding="1">';
  218.         $cat = '';
  219.         $group = '';
  220.         foreach($mapping as $name=>$field) {
  221.             if (!empty($field['cat']) && $field['cat'] != $cat) {
  222.                 if ($cat)
  223.                     $html .= '<tr><td colspan="3"><hr /></td></tr></tbody>';
  224.                 $cat = $field['cat'];
  225.                 $html .= '<tr><th>'.$cat_list[$cat]['label'].'</th></tr>';
  226.                 $html .= '<tbody border="1" style="border: 1px solid black;">';
  227.             }
  228.             if (!empty($field['group']) && $field['group'] != $group) {
  229.                 $group = $field['group'];
  230.                 $html .= '<tr><th>'.$group.'</th></tr>';
  231.             }    
  232.             // Mise en page particulière
  233.             if (!empty($field['noauto']))
  234.                 continue;
  235.             $html .= '<tr>';
  236.             $html .= '<td class="label"><label for="'.$name.'">'.$field['label'].'</label>';
  237.             
  238.             $html .= '<td>';
  239.             $options = [];
  240.             if (!empty($field['checkbox_to_radio']))
  241.                 $options['checkbox_to_radio'] = true;
  242.             if ($field['type']=='group') {
  243.                 foreach($field['list'] as $ename=>$efield) {
  244.                     if (!is_numeric($ename))
  245.                         $html .= $this->field_format($ename, $efield, $options);
  246.                     else
  247.                         $html .= $efield['info'];
  248.                 }
  249.             }
  250.             else
  251.                 $html .= $this->field_format($name, $field, $options);
  252.             $html .= '</td>';
  254.             if (!empty($field['help'])) {
  255.                 $html .= '<td><div class="help_container"><div class="help_icon">?</div><div class="help">'.$field['help'].'</div></div></td>';
  256.             }
  257.             $html .= '</tr>';
  258.         }
  259.         $html .= '</tbody></table>';
  261.         // History
  262.         $repo = $this->em->getRepository('App\\Entity\\CERFA');
  263.         $histo = $repo->findBy(['apprenant'=>$id, 'session'=>$session_id]);
  264.         //var_dump($histo); die();
  265.         
  266.         $this->params();
  267.         $this->params['page']['head']['title'] = 'Formulaire Cerfa '.$apprenant;
  268.         $this->params['page']['subtitle'] = 'CERFA '.$apprenant.' pour '.$session;
  269.         $this->params['page']['breadcrumbs'][] = [
  270.             'route' => static::REF.'_list',
  271.             'label' => 'Liste',
  272.         ];
  273.         $this->params['form'] = $html;
  274.         $this->params['data'] = $data;
  275.         $this->params['cerfa_pdf_url'] = $this->generateUrl('apprenant_cerfa_pdf', ['id'=>$id, 'customer_id'=>$customer_id]);
  276.         $this->params['cerfa_save_url'] = $this->generateUrl('apprenant_cerfa_save', ['id'=>$id, 'customer_id'=>$customer_id]);
  277.         $this->params['cerfa_api_update_url'] = $this->generateUrl('apprenant_cerfa_api_update', ['id'=>$id, 'customer_id'=>$customer_id]);;
  278.         $this->params['cerfa_resync_urls'] = [
  279.             ['Apprenant', $this->generateUrl('apprenant_api_sync', ['id'=>$data['trainee']['id']])],
  280.             ['Entreprise', $this->generateUrl('entreprise_api_sync', ['id'=>$data['company']['id']])],
  281.             ['Session', $this->generateUrl('session_api_sync', ['id'=>$data['session']['id']])],
  282.             ['Programme', $this->generateUrl('formation_programme_api_sync', ['id'=>$data['program']['id']])],
  283.         ];
  284.         $this->params['cerfa_linked_urls'] = [
  285.             ['Apprenant', $this->generateUrl('apprenant_read', ['id'=>$apprenant->getID()])],
  286.             ['Entreprise', $this->generateUrl('entreprise_read', ['id'=>$company->getID()])],
  287.             ['Customer', $this->generateUrl('entreprise_read', ['id'=>$customer->getID()])],
  288.             ['Session', $this->generateUrl('session_read', ['id'=>$session->getID()])],
  289.             ['Programme', $this->generateUrl('formation_programme_read', ['id'=>$program->getID()])],
  290.         ];
  291.         $this->params['cerfa_histo'] = $histo;
  293.         // Twig template
  294.         $tplfile = 'apprenant/cerfa_form.html.twig';
  295.         
  296.         return $this->render($tplfile, $this->params);
  297.     }
  298.     
  299.     /**
  300.      * Enregiostre les données à jour dans Digiforma
  301.      * 
  302.      * @Route("/{id}/cerfa_api_update", name="cerfa_api_update")
  303.      */
  304.     public function CERFAAPIUpdateAction(Request $request, HttpClientInterface $client): Response
  305.     {
  306.         if (!($params = $this->cerfa_params($request)))
  307.             return new JsonResponse(['r'=>false, 'msg'=>'Paramètres invalides']);
  309.         extract($params);
  311.         if(empty($u_data))
  312.             return new JsonResponse(['r'=>false, 'msg'=>'Missing user data']);
  314.         // Mapping
  315.         $cerfa = $this->getCERFA();
  316.         $mdata = $cerfa->cerfa_mapping($id, $customer_id, $u_data);
  317.         //var_dump($mdata['d_data']); die();
  318.         //var_dump($u_data, $mdata['mapping']); die();
  319.         //var_dump($mdata['mapping']['apprenant_dernierdiplome']['list']['apprenant_dernierdiplome_code']['values']); die();
  320.         $rdata = [];
  322.         $l = [
  323.             'apprenant' => ['updateTrainee', 'traineeInput', 'trainee', 'Apprenant'],
  324.             'company' => ['updateCompany', 'companyInput', 'company', 'Entreprise'],
  325.             'customer' => ['updateCustomer', 'customerInput', 'customer', 'SessionCustomer'],
  326.             'session' => ['updateTrainingSession', 'trainingSessionInput', 'session', 'Session'],
  327.             'program' => ['updateProgram', 'programInput', 'program', 'FormationProgramme'],
  328.         ];
  329.         $ok = true;
  330.         foreach($mdata['d_data'] as $type=>$data) {
  331.             if(!isset($l[$type]))
  332.                 continue;
  333.             
  334.             $query = <<<'GRAPHQL'
  335.                 mutation {
  336.                     \$mutationName(id: \$id, \$inputName: {
  337.                         \$data
  338.                     }) {
  339.                         id
  340.                     }
  341.                 }
  342.                 GRAPHQL;
  343.             $dataText = [];
  344.             foreach($data as $name=>$value){
  345.                 if (is_array($value)) {
  346.                     $valueText = [];
  347.                     if ($name=='customFields') {
  348.                         foreach($value as $ename=>$evalue) {
  349.                             $valueText[] .= '{field: "'.$ename.'", value: "'.(is_array($evalue) ?(!empty($evalue['digi'] ?$evalue['digi'] :$evalue['label'])) :$evalue).'"}';
  350.                         }
  351.                         $dataText[] .= $name.': ['."\r\n".implode("\r\n", $valueText)."\r\n".']';
  352.                     }
  353.                     else {
  354.                         foreach($value as $ename=>$evalue) {
  355.                             $valueText[] .= $ename.': '.$this->digi_value($evalue);
  356.                         }
  357.                         $dataText[] .= $name.': {'."\r\n".implode("\r\n", $valueText)."\r\n".'}';
  358.                     }
  359.                 }
  360.                 else {
  361.                     $dataText[] .= $name.': '.$this->digi_value($value);
  362.                 }
  363.             }
  364.             if (empty($dataText))
  365.                 continue;
  366.             $query = str_replace(['\$mutationName', '\$inputName', '\$id', '\$data'], [$l[$type][0], $l[$type][1], $mdata[$l[$type][2]]['id'], implode("\r\n", $dataText)], $query);
  367.             //echo '<pre>'.$query.'</pre>';
  368.             $repo = $this->em->getRepository('App\\Entity\\'.$l[$type][3]);
  369.             $res = $repo->api_query($query, ['user' => 'dunglas']);
  370.             if (!$rok = !empty($res['data'][$l[$type][0]]['id']))
  371.                 $ok = false;
  372.             //var_dump($res);
  373.             $rdata[] = [$type, $query, $res, $rok];
  374.         }
  376.         return new JsonResponse(['r'=>$ok, 'data'=>$rdata]);
  377.     }
  379.     public function digi_value($value)
  380.     {
  381.         if (is_bool($value))
  382.             return $value ?'true' :'false';
  383.         elseif (is_int($value) || is_float($value))
  384.             return ''.$value;
  385.         else
  386.             return '"'.$value.'"';
  387.     }
  389.     public function getCERFA()
  390.     {
  391.         $classname = '\\App\\Classes\\CERFA_10103_'.static::CERFA_PDF_NUM;
  392.         $cerfa = new $classname($this->em);
  393.         return $cerfa;
  394.     }
  395.     
  396.     /**
  397.      * Enregistre les données mises à jour localement
  398.      * 
  399.      * @Route("/{id}/cerfa_save", name="cerfa_save")
  400.      */
  401.     public function CERFASaveAction(Request $request, HttpClientInterface $client): Response
  402.     {
  403.         if (!($params = $this->cerfa_params($request)))
  404.             die('Paramètres invalides');
  406.         extract($params);
  408.         if(empty($u_data))
  409.             die('Missing user data');
  411.         // Mapping
  412.         $cerfa = $this->getCERFA();
  413.         $mdata = $cerfa->cerfa_mapping($id, $customer_id, $u_data);
  415.         $o_data = $mdata['o_data'];
  416.         //var_dump($o_data); die();
  418.         // Enregistrement des données du CERFA en local
  419.         $object = new \App\Entity\CERFA();
  420.         $object->setSession($session);
  421.         $object->setApprenant($apprenant);
  422.         $object->setData(json_encode($u_data));
  423.         $this->em->persist($object);
  424.         // Apprenant
  425.         $apprenant->setCERFAData($o_data['apprenant']);
  426.         $this->em->persist($apprenant);
  427.         // Company
  428.         $company->setCERFAData($o_data['company']);
  429.         $this->em->persist($company);
  430.         // Customer
  431.         $customer->setCERFAData($o_data['customer']);
  432.         $this->em->persist($customer);
  433.         // Session
  434.         $session->setCERFAData($o_data['session']);
  435.         $this->em->persist($session);
  436.         // Program
  437.         if (!empty($program)) {
  438.             $program->setCERFAData($o_data['program']);
  439.             $this->em->persist($program);
  440.         }
  442.         $this->em->flush();
  443.         
  444.         // Save cerfa related informations into digiforma
  445.         
  446.         //$html = '';
  448.         return new JsonResponse(['r'=>true]);
  449.     }
  451.     /**
  452.     * @Route("/{id}/cerfa_pdf", name="cerfa_pdf")
  453.     */
  454.     public function CERFAPDFAction(Request $request): Response
  455.     {
  456.         if (!($params = $this->cerfa_params($request)))
  457.             die('Paramètres invalides');
  459.         extract($params);
  460.         
  461.         // Mapping        
  462.         $cerfa = $this->getCERFA();
  463.         $mdata = $cerfa->cerfa_mapping($id, $customer_id);
  464.         $mapping = $mdata['mapping'];
  466.         $pdf_data = [];
  467.         //var_dump($request->request->all()); die();
  468.         foreach($mapping as $name=>&$field) {
  469.             if ($field['type']=='group') {
  470.                 foreach($field['list'] as $ename=>&$efield) {
  471.                     if (!empty($efield['pdf_name'])) {
  472.                         $value = $request->request->get($ename);
  473.                         if (!is_null($value) && $value != '') {
  474.                             $efield['value'] = $value;
  475.                             if (!empty($efield['type'])) {
  476.                                 if ($efield['type']=='date')
  477.                                     $efield['value'] = implode('/', array_reverse(explode('-', $efield['value'])));
  478.                             }
  479.                             $pdf_data[$efield['pdf_name']] = $efield['value'];
  480.                         }
  481.                     }
  482.                 }
  483.                 unset($efield);
  484.             }
  485.             else {
  486.                 if (!empty($field['pdf_name'])) {
  487.                     $value = $request->request->get($name);
  488.                     if (!is_null($value) && $value != '')
  489.                         $field['value'] = $value;
  490.                     if (!empty($field['type'])) {
  491.                         if ($field['type']=='date')
  492.                             $field['value'] = implode('/', array_reverse(explode('-', $field['value'])));
  493.                     }
  494.                     $pdf_data[$field['pdf_name']] = $field['value'];
  495.                 }
  496.             }
  497.         }
  498.         unset($field);
  500.         // PDF
  501.         $folder = 'cerfa_filled';
  502.         $pdf = new GeneratePdf('cerfa/'.$cerfa->getFilename(), $folder);
  503.         $filename = 'cerfa-'.$id.'-'.$session_id.'.pdf';
  504.         $ret = $pdf->generate($filename, $pdf_data);
  505.         if ($ret !== true) {
  506.             return new JsonResponse($pdf_data);
  507.             //var_dump($ret);
  508.         }
  510.         return (new BinaryFileResponse('../data/'.$folder.'/'.$filename, Response::HTTP_OK))
  511.             ->setContentDisposition(ResponseHeaderBag::DISPOSITION_ATTACHMENT, 'cerfa-'.$id.'-'.$session_id.'-'.$apprenant.'.pdf');
  512.     }
  514.     /**
  515.      * Request analysis to retrieve all CERFA data
  516.      * @return []|boolean
  517.      */
  518.     public function cerfa_params(Request $request)
  519.     {
  520.         $id = $request->attributes->get('id');
  521.         $apprenant = $this->em->getRepository('App\\Entity\\Apprenant')->find($id);
  522.         if (empty($apprenant)) {
  523.             throw $this->createNotFoundException('Missing Trainee'); 
  524.             return false;
  525.         }
  526.         
  527.         if ($customer_id = $request->query->get('customer_id')) {
  528.             $customer = $this->em->getRepository('App\\Entity\\SessionCustomer')->find($customer_id);
  529.             $session = $customer->getSession();
  530.             $session_id = $session->getID();
  531.         }
  532.         elseif ($session_id = $request->query->get('session_id'))
  533.         {
  534.             if ($session = $this->em->getRepository('App\\Entity\\Session')->find($session_id)) {
  535.                 foreach($session->getCustomers() as $session_customer) {
  536.                     //var_dump($session_customer);
  537.                     if ($session_customer->getApprenants()->contains($apprenant)) {
  538.                         $customer = $session_customer;
  539.                         $customer_id = $customer->getID();
  540.                         break;
  541.                     }
  542.                 }
  543.             }
  544.         }
  545.         else {
  546.             throw $this->createNotFoundException('Missing Session/Customer'); 
  547.             return false;
  548.         }
  549.         if (empty($customer))
  550.             //die('Customer invalide');
  551.             return false;
  553.         // Données complémentaires
  554.         $program = $session->getProgramme();
  555.         if (empty($program)) {
  556.             throw $this->createNotFoundException('Missing Program'); 
  557.             return false;
  558.         }
  559.         $company = $customer->getEntreprise();
  560.         if (empty($company)) {
  561.             throw $this->createNotFoundException('Missing Company'); 
  562.             return false;
  563.         }
  565.         // User data
  566.         $u_data = [];
  567.         if (!empty($sdata = $request->get('data'))) {
  568.             //var_dump($_POST);
  569.             foreach($sdata as $v) {
  570.                 $u_data[$v['name']] = $v['value'];
  571.             }
  572.         }
  574.         return [
  575.             'id' => $id,
  576.             'apprenant' => $apprenant,
  577.             'customer' => $customer,
  578.             'customer_id' => $customer_id,
  579.             'session' => $session,
  580.             'session_id' => $session_id,
  581.             'company' => $company,
  582.             'program' => $program,
  583.             'u_data' => $u_data,
  584.         ];
  585.     }
  586.     
  587.     /**
  588.     * API Setter/Modifier
  589.     */
  590.     protected function apisettel($row)
  591.     {
  592.         if (!empty($row['phone'])) {
  593.             return str_replace(' ', '', $row['phone']);
  594.         }
  595.         return $row['phone'];
  596.     }
  597. }