src/Controller/VStudentCardController.php line 676

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  6. use Psr\Log\LoggerInterface;
  8. use Doctrine\ORM\EntityManagerInterface;
  10. use App\Entity\VCard;
  11. use App\Form\VCardType;
  13. use App\Entity\VCardStudent;
  14. use App\Form\VCardStudentType;
  16. use App\Repository\VCardRepository;
  17. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  18. use Symfony\Component\HttpFoundation\Request;
  19. use Symfony\Component\HttpFoundation\Response;
  20. use Symfony\Component\Routing\Annotation\Route;
  22. use Symfony\Component\Mailer\MailerInterface;
  23. use Symfony\Component\Mime\Email;
  24. use Symfony\Component\Mailer\Exception\TransportExceptionInterface;
  26. use Symfony\Component\Filesystem\Exception\IOExceptionInterface;
  27. use Symfony\Component\Filesystem\Filesystem;
  28. use Symfony\Component\Filesystem\Path;
  31. use Symfony\Component\HttpClient\CurlHttpClient;
  34. use JeroenDesloovere\VCard\VCard as VCardFile;
  35. use chillerlan\QRCode\QRCode;
  37. use chillerlan\QRCode\QROptions;
  40. use phpCAS;
  41. use App\Controller\VCardController;
  43. use DateTime;
  44. use DateTimeZone;
  48. class VStudentCardController extends  CustomController // AbstractController
  49. {
  51.     private    $applicationSender = 'no-reply';
  52.     // private $uploadsDIR = __DIR__.'/../../public/uploads/';
  54.     private $qrcodeOutDIR = __DIR__.'/../../public/uploads/';
  55.     private $studentsFileURL = 'https://am-auriontbo-1/servlet/Dispatcher?action=transformFavori&data=<transformFavori><favori><id>132012446</id></favori><database>ensam</database><xslFile>JSON_json.xsl</xslFile></transformFavori>';
  56.     
  57.     // private $studentsCacheFile = __DIR__.'/../../public/uploads/'.'students.json';
  59.     private $CACHE_DURATION = 120;
  61.     private $SOCIAL_NETS = array(
  62.                 'linkedin'     => 'https://www.linkedin.com/in/',
  63.                 'facebook'    => 'https://www.facebook.com/',
  64.                 'twitter'    => '',
  65.                 'tiktok'    => 'https://www.tiktok.com/',
  66.                 'instagram'    => 'https://www.instagram.com/',
  67.                 'other'        => '',
  69.             );
  72.     private $pendingMailDatas = array(
  73.                         'à valider' => array(
  74.                             'subject' => '[Rappel] Carte de visite',
  75.                             'content' => 'La carte de {PRENOM} {NOM} attend votre validation, cliquez sur le lien pour accéder à la demande de validation.<br/>'
  76.                                         . '<a href="{URI}/v/card/manager">'
  77.                                         . 'Voir...'
  78.                                     . '</a><br/>'
  79.                                     . '<i>Ce message a été créé automatiquement par le gestionnaire de carte de visites des Arts et Métiers, merci de ne pas y répondre.</i>'
  81.                         ),
  82.                         'enregistrée' => array('subject' => '[Rappel] Carte de visite',
  83.                         'content' => "N'oubliez-pas de soumettre votre carte de visite pour sa publication...<br/>"
  84. .'Cliquez sur le lien pour la soumettre.<br/>'
  85.                                         . '<a href="{URI}/v/card/">'
  86.                                         . 'Voir...'
  87.                                     . '</a><br/>'
  88.                                     . '<i>Ce message a été créé automatiquement par le gestionnaire de carte de visites des Arts et Métiers, merci de ne pas y répondre.</i>'
  90.                         ),
  91.                         'rejetée' => array('subject' => '[Rappel] Carte de visite',
  92.                                     'content' => 'Votre carte de visite a été rejetée.<br/>'
  93.                                             .'Vous pouvez la modifier à cette adresse:<br/>'
  94.                                             . '<a href="{URI}/v/card/{ID_VCARD}">'
  95.                                             . 'Voir...'
  96.                                         . '</a><br/>'
  97.                                         . '<i>Ce message a été créé automatiquement par le gestionnaire de carte de visites des Arts et Métiers, merci de ne pas y répondre.</i>'
  98. // "VALIDATE_CONTENT"
  99.                                 ),
  101.     );
  104.     protected function getNewStudentVersion($id) {
  105.     $out = -1;
  106.     $query = 'select max(version)+1 as NEW_VERSION from vcard_student where id_apprenant='.$id;
  107.     $result = $this->selectRaw($query);
  109.     if (isset($result[0]['NEW_VERSION'])) {
  110.         $out = $result[0]['NEW_VERSION'];
  111.     }
  113.     return $out;
  114.     }
  116.     protected function getNewStudentVCardId($TEST_MODE = false) {
  117.         $out = -1;
  119.     if ($TEST_MODE === false) {
  120.     $query = 'select max(id_vcard) + 1 as NEW_ID from VCARD_STUDENT';
  122.     $result = $this->selectRaw($query);
  124.     if (isset($result[0]['NEW_ID'])) {
  125.         $out = $result[0]['NEW_ID'];
  126.     }
  127.     } else {
  128.         $out = date_timestamp_get(date_create());
  129.     }
  130.     return $out;
  131.     }
  134.     protected function getParamType($param) : String{
  135.         $out = 's';
  136.     if (ctype_digit((string) $param)) {
  137.         $out =  $param <= PHP_INT_MAX ? 'i' : 's';
  138.     }
  140.     if (is_numeric($param)) {
  141.         $out = 'd';
  142.     }
  143.     return $out;
  144. }
  146. protected function getBoundTypes(array $values) : String {
  147.     $out = "";
  149.     foreach($values as $k => $v) {
  150.         $out .= $this->getParamType($values[$k]); 
  151.     }
  153.     return $out;
  154. }    
  156. protected function writeRaw($SQL, array $values, $DBG = false) {
  157.     $out = false;
  158.     $nb_values = count($values);
  161.     if (isset($SQL)
  162.         && strpos($SQL, ':') !== false
  163.         && $nb_values > 0
  164.     ) {
  165.         $wc_count = substr_count($SQL, ':');
  167.         if ($wc_count == $nb_values) {
  169.             // $bound_types = $this-> getBoundTypes($values);
  171.             // echo(__METHOD__. ': SQL:' . $SQL . ', '. $bound_types);
  172.             $em = $this->getDoctrine()->getManager();
  173.             // $statement = $em->getConnection()->prepare($SQL);
  174.             
  175.            $db = $em->getConnection(); // Doctrine_Manager::getInstance()->getCurrentConnection();
  176.             $query = $db->prepare($SQL);
  178.             $res = $query->execute($values);
  179.             /*
  180.             $results = $res->fetchAllAssociative();
  182.              echo(__METHOD__.' results: '.var_export($results, true));       
  183.              */
  184. /*
  185.             // Set parameters
  186.             foreach($values as $item => $item_value) {
  187.                 $statement->bindValue($item, $item_value);
  188.             }
  190.             $res = $statement->execute();
  191.  */
  193.             if ( TRUE || // TODO: remove Debug 
  194.                 isset($_GET['DBG'])
  195.                 && $_GET['DBG'] == 1
  196.             ) {
  197.                   echo(__METHOD__.' values: '.var_export($values, true));       
  198.             }
  199.             $out = true;
  200.         } // END if count
  201.     }
  203.     return $out;
  204. }
  206.     /**
  207.      * @Route("/v/student/card/", name="app_v_card_student_index", methods={"GET", "POST"})
  208.      */
  209. public function index(Request $request, VCardRepository $vCardRepository, LoggerInterface $logger): Response {
  210.                 return new Response(null, 302, array(
  211.                     'Location'        => 'show',
  212.                 ));
  213. }
  215.  /**
  216.      * @Route("/v/student/card/auth", name="app_v_card_student_auth", methods={"GET", "POST"})
  217.      */
  218.     public function auth(Request $request): Response {
  219.                 return new Response(null, 302, array(
  220.                     'Location'        => "https://{$_SERVER['HTTP_HOST']}",
  221.                 ));
  223.     }
  226.     /**
  227.      * @Route("/v/student/card/testauth", name="app_v_card_student_testauth", methods={"GET", "POST"})
  228.      */
  229.     public function testauth(Request $request): Response {
  230.         $session = $request->getSession();
  232.         $this->checkAuth($session, 'app_v_card_student_testauth');
  233.         $content = __METHOD__.': authentified';
  235.         return new Response($content, 302, array(
  236.                     'Location'        => 'auth',
  237.         ));
  239.     }
  241.     /**
  242.      * @Route("/v/student/card/edit", name="app_v_card_student_edit", methods={"GET", "POST"})
  243.      */
  244. public function edit(Request $request): Response {
  245.         $session = $request->getSession();
  246.         
  247.         $this->checkAuth($session, 'app_v_card_student_edit');
  250.         $user_email = $session->get('user_email'); // $_GET['email'];
  251.         $is_auth = $session->get('is_auth'); // $_GET['email'];
  253.     $url = "https://{$_SERVER['HTTP_HOST']}/v/student/card/last?";
  256.     $DBG = isset($_GET['DBG']) && $_GET['DBG'] == '1';
  258.     $student_datas = array(
  259.         'avecphoto'    => 'non',
  260.         'tel2'        => '',
  261.             );
  263.     if (isset($user_email)
  264.         && $is_auth
  265.     ) {
  266.         /*
  267.         $found = $this->getStudentDatasFromMail($user_email);
  269.         if (isset($found)) {
  270.             $student_datas['titre'] = $found['Fonction'];
  271.             $student_datas['tel']    = $found['Portable'];
  273.             $student_datas['emailPerso']    = $found['emailPerso'];
  275.         */
  277.         $student_datas = $this->getAllStudentDatas($user_email, $DBG);
  279.     // echo(__METHOD__.' student_datas:'.var_export($student_datas, true)); exit();
  282.     if (!isset($student_datas['id.Apprenant'])) {
  283.         return $this->redirectToRoute('app_v_card_student_notfound', [], Response::HTTP_SEE_OTHER);
  285.     } else if (!isset($student_datas['ID_VCARD'])) {
  286.             $args = array();
  288.             if (isset($_GET['email'])) {
  289.                 $args['email'] = $_GET['email'];
  290.             }
  292.             return $this->redirectToRoute('app_v_card_student_new', $args, Response::HTTP_SEE_OTHER);
  293.      }
  295.         $ide_dossier = 'E-'.$student_datas['id.Apprenant'];
  297.     $custom_photo_key = '';
  298.     $delete_custom_key = '';
  300.     $file_path = $this->uploadsDIR.('photo_'.$ide_dossier.'.jpg');
  302.     $is_custom_photo = (file_exists($file_path)); // NOTE: user needs to delete to disable custom
  304.     if ($is_custom_photo) {
  305.         $custom_photo_key = $this->storeInSession($session, $file_path);
  306.         $delete_custom_key = $this->storeInSession($session, $file_path);
  308.     }
  310.             $comm_datas = json_decode($student_datas['COMMENTAIRE'], true); // NOTE: commentaire used for keeping opt fields 
  311.             $comm_datas['login'] = $student_datas['login.Individu'];
  313.             if (isset($comm_datas['role'])) {
  314.                 $student_datas['role'] = $comm_datas['role'];
  315.             }
  317.             if (!isset($comm_datas['date_expiration'])
  318.                 && isset($student_datas['date_expiration'])
  319.             ) {
  320.                 $comm_datas['date_expiration'] = $student_datas['date_expiration'];
  321.             }
  324.             /* TODO: enable social networks
  325.              
  326.             foreach($this->SOCIAL_NETS as $net_item => $val) {
  327.                 if (isset($comm_datas[$net_item])
  328.             ) {
  329.                     $student_datas[$net_item] = $comm_datas[$net_item];
  330.                 }
  332.             }
  334.             // */
  337.             $vCardStudent = new VCardStudent();
  338.             $vCardStudent->setcommentaire($student_datas['COMMENTAIRE']);
  340.             $form = $this->createForm(VCardStudentType::class, $vCardStudent);
  342.             $form->handleRequest($request);
  344.             if ($form->isSubmitted() && $form->isValid()) {
  345.                 $datas = $form->getData();
  347.                 $titre_datas = json_decode($datas->gettitre(), true);
  349.                 if (isset($titre_datas[1])) {
  350.                     $comm_datas['role'] = $titre_datas[1];
  351.                 } else {
  352.                     $comm_datas['role'] = '';
  353.                 }
  355.                 $form_comment = $datas->getcommentaire();
  356.                 if (isset($form_comment)) {
  357.                     $tmp_comms = json_decode($form_comment, true);
  358.                     $comm_datas = array_merge($comm_datas, $tmp_comms);    
  359.                 }
  361.                 $datas->setid_apprenant($student_datas['id.Apprenant']);
  362.                 $datas->setformation($student_datas['Formation']);
  364.                 $datas->setVERSION(printf("%d", $student_datas['VERSION']) + 1);
  365.                 $datas->setcommentaire(json_encode($comm_datas));
  368.                 $this->addVCardStudent($datas); // , true); // TODO: REMOVE true !!!!!
  369.                 $this->generateQrCodeFile($url, $user_email);
  371.                 if (isset($_GET['DBG'])) {
  372.                     echo(__METHOD__.': '. var_export($datas->gettitre(), true));
  373.                     echo(__METHOD__.': '. var_export($datas, true));
  374.                 } else {
  375.                     return $this->redirectToRoute('app_v_card_student_show', [], Response::HTTP_SEE_OTHER);
  376.                 }
  378.             }
  379.             
  380.         //} // END if found
  381.             return $this->renderForm('v_card_student/new.html.twig', [
  382.             // 'v_card' => $vCard,
  383.             'user_email' => $user_email,
  384.             // 'personnel'    => $personnel_datas,
  385.             'student'    => $student_datas,
  386.             'is_new'    => true,
  387.             'current_card'     => true,
  388.             'disp_form_student'    => true,
  389.             // 'is_manager'    => $session->get('is_manager'),
  390.         'custom_photo_key'     => $custom_photo_key,
  391.         'delete_custom_key'    => $delete_custom_key,
  393.             'form' => $form,
  394.         ]);
  397.     } else { // END if user_email
  398.         return $this->redirectToRoute('app_v_card_student_notfound', [], Response::HTTP_SEE_OTHER);
  399.     }
  401.         }
  404.     /**
  405.      * @Route("/v/student/card/{id}/vcardinfo", name="app_v_card_student_vcardinfo", methods={"GET", "POST"})
  406.      */
  407. public function vcardinfo(Request $request, $id): Response {
  409.     $datas = array();
  410.     $found = $this->selectVcardStudentWhere('ID_VCARD='.sprintf("%d", $id));
  412.     if (isset($found)) {
  413.         $datas = $found;
  414.     }
  416.     $content = __METHOD__.' datas: '.var_export($datas, true);
  420.     return new Response($content, 200, array(
  422.                     )
  423.             );
  425.     }
  428.     /**
  429.      * @Route("/v/student/card/notfound", name="app_v_card_student_notfound", methods={"GET"})
  430.      */
  431.     public function notfound(Request $request): Response {
  432.     // echo(__METHOD__); exit(); 
  433.     $v_datas = array();
  436.     $tpl_name = 'v_card_student/message.html.twig';
  438.     $needs_create = false;
  442.     $v_datas[ 'disp_message'] = true;
  443.     $v_datas[ 'is_student'] = true;
  445.     $v_datas['message'] = ($needs_create ? 'Aucune carte' : 'Carte non').'  trouvée....';
  447.     if (isset($_GET['embedded'])) {
  448.         $v_datas['embedded'] = true;
  449.         // $v_datas['message'] = 'Carte non trouvée.<br/>Créer votre carte de visite <a href="/v/card">ici</a>';
  450.         if (isset($_GET['needs_create']) && $_GET['needs_create'] == 1) {
  451.             $v_datas['needs_create'] = $needs_create = true;
  452.         
  453.         }
  454.         $tpl_name = 'v_card_student/notfound_embedded.html.twig';
  455.     }
  458.         return $this->render($tpl_name, $v_datas); 
  459.     }
  462.     /**
  463.      * @Route("/v/student/card/show", name="app_v_card_student_show", methods={"GET", "POST"})
  464.      */
  465.     public function show(Request $request): Response {
  467.         $session = $request->getSession();
  468.         $this->checkAuth($session, 'app_v_card_student_show');
  471.     $email = $session->get('user_email'); // $_GET['email'];
  472.     $is_auth = $session->get('is_auth');
  474.     $student_datas = $this->getAllStudentDatas($email, isset($_GET['DBG']) && $_GET['DBG'] == 1); // $this->getStudentDatasFromMail($email);
  476.     if (!isset($student_datas['id.Apprenant'])) {
  477.         return $this->redirectToRoute('app_v_card_student_notfound', [], Response::HTTP_SEE_OTHER);
  479.     }
  481.     if (!isset($student_datas['ID_VCARD'])) {
  482.         return $this->redirectToRoute('app_v_card_student_new', [], Response::HTTP_SEE_OTHER);
  484.     }
  487.     $ide_dossier = 'E-'.$student_datas['id.Apprenant'];
  489.     // echo(__METHOD__.': student_datas: '. var_export($student_datas, true));
  491.     $vcard_datas = array();
  493.     $vcard_datas['user_email'] = $email;
  494.     $vcard_datas['disp_vcard_student'] = true;
  496.     $vcard_datas['current_card'] = true;
  497.     $vcard_datas['can_validate'] = false;
  499.     $vcard_datas['can_duplicate'] = false;
  500.     $vcard_datas['validated'] = true;
  502.     $vcard_datas['new_version'] = true;
  504.         $vcard_datas['is_manager'] = false;
  505.         // $vcard_datas['published'] = true;
  507.         // $vcard_datas['published_card'] = true; 
  511.     $vcard_datas['needs_submit'] = false;
  512.     $vcard_datas['personnel_datas'] = array(
  513.         'PRENOM'=> $student_datas['Prénom'],
  514.         'NOM'    => $student_datas['Nom'],
  515.         'TEL_PRO'    => $student_datas['Portable'],
  516.         'EMAIL_PRO'    => $email,
  518.     );
  520.     $comm_datas = json_decode($student_datas['COMMENTAIRE'], true);
  521.     if (isset($comm_datas['role'])) {
  522.         $vcard_datas['personnel_datas']['ROLE'] = $comm_datas['role'];
  523.     }
  525.     $vcard_datas['v_datas_card'] = array(
  526.         'SITE_RATTACHEMENT' => $student_datas['Campus'],
  527.         'ADRESSE_PRO'    => $student_datas['Campus'].' - '. $student_datas['ADRESSE_PRO'],
  529.         // 'ADRESSE_PRO'        => $student_datas['ADRESSE_PRO'],
  530.     );
  532.     $vcard_datas['v_card'] = array(
  533.         'titre'    => '["'.$student_datas['Fonction'].'"]',
  534.         'tel'    => $student_datas['TEL'], // '["'.$student_datas['Portable'].'"]',
  535.         'email' => '["'.$student_datas['email'].'","'.$student_datas['emailPerso'].'"]'
  536.     );
  538.     //* // TODO: enable social links
  539.     foreach ($this->SOCIAL_NETS as $net_item => $net_value) {
  540.         if (isset($comm_datas[$net_item])
  541.             && $comm_datas[$net_item] != ''
  542.         ) {
  543.             $vcard_datas['v_card'][$net_item] = // $net_value.
  544.                 $comm_datas[$net_item];
  545.             $vcard_datas['v_card'][$net_item.'_url'] = $net_value.$comm_datas[$net_item];
  546.         }
  547.     }
  548.     //  */
  549.     $photo_file = '/mnt/recadre/'.$ide_dossier.'.jpg';
  551.     if ($student_datas['AVEC_PHOTO'] == 'oui'
  552.         || (file_exists($this->uploadsDIR.('photo_'.$ide_dossier.'.jpg')))
  553.     ) {
  554.                 if ($student_datas['AVEC_PHOTO'] != 'oui') {
  555.                     $photo_file = $this->uploadsDIR.('photo_'.$ide_dossier.'.jpg');
  556.                 }
  558.         $key = $this->storeInSession($session, $photo_file);
  560.         if (!empty($key)) {
  561.             $vcard_datas['PHOTO_K'] = $key;
  562.         }
  563.     }
  567.         return $this->renderForm('v_card_student/show.html.twig', $vcard_datas); 
  568.     /* 
  569.         [
  570.             'v_card' => $vCard,
  571.         'vcard_datas' => $vcard_datas,
  572.         'v_datas_card' => $v_datas_card,
  573.         'personnel_datas' => $personnel_datas,
  574.         'infos_carte' => $infos_carte,
  575.         'can_validate' => $this->isCardManager($vCard),
  576.         ]
  577. );
  578.     */
  580. }
  582.     public function selectMailLike($search, $DBG = false) {
  583.     $out = array();
  585.         if (!empty($search)) {
  586.         $RAW_QUERY = "SELECT EMAIL FROM VCARD_STUDENT where EMAIL like '%".$search."%' order by VERSION desc FETCH FIRST 1 ROWS ONLY"; // "SELECT EMAIL FROM VCARD where STATUT='validé' and LOWER(EMAIL) like '%".$search."%' order by VERSION desc FETCH FIRST 1 ROWS ONLY"; // "SELECT EMAIL FROM VCARD where LOWER(EMAIL) like '%". $search."%'"; // ' where IDE_DOSSIER='.$ide_dossier;
  587.         
  588.         $found = $this->selectRaw($RAW_QUERY, $DBG);
  590.         if (count($found) > 0) {
  591.             $out = $found;
  592.         }    
  593.     }
  595.     return $out;
  596.     }
  598.     /**
  599.      * @Route("/v/student/card/search", name="app_v_card_student_search", methods={"GET", "POST"})
  600.      */
  601.     public function search(Request $request): Response {
  602.         // echo(__METHOD__.' _POST: '.var_export($_POST, true)); exit();
  604.     $session = $request->getSession();
  605.     $is_auth = $session->get('is_auth');
  607.     $datas = array();
  608.     $datas['is_manager'] = $session->get('is_manager');
  610.     if (!$is_auth) {
  611.         $datas['needs_auth'] = true;
  612.     }
  614.     $datas['disp_search_student'] = true;
  616.     if (isset($_POST['email'])
  617.         && $_POST['email'] != ''
  618.     ) {
  619.         $ans = array('msg' => 'NOT_FOUND');
  620.         $found = $this->selectMailLike($_POST['email']); // getVCardFromEmail($_POST['email'], $get_like = true);
  621.         // echo(__METHOD__.' found: '.var_export($found, true));
  623.         /*
  624.         if (isset($found['EMAIL_PRO'])) {
  625.             $ans['msg'] = 'ok';
  626.             $ans['EMAIL_PRO'] = $found['EMAIL_PRO'];
  627.         }
  628.         //*/
  629.         //
  631.         if (count($found) > 0) {
  632.             $ans = $found;
  633.         }
  635.         $content = json_encode($ans);
  637.         return new Response($content, 200, array(
  638.                 'Content-type'        => 'text/json',
  639.             )
  640.         );
  642.     } else {
  643.          return $this->render('v_card_student/search.html.twig', $datas); 
  644.     }
  645.     }
  647.     protected function addOptVcardFields($vcard, array $datas, $DBG = false) {
  648.         if (isset($vcard)) {
  650.         if ($DBG !== false) {
  651.                 echo(__METHOD__.': datas: '.var_export($datas, true));
  652.         }
  654.             $vcard->addRole('Elève ingénieur Arts et Métiers');
  656.             if (isset($datas['personnel_datas']['ROLE'])) {
  657.                 $vcard->addNote($datas['personnel_datas']['ROLE']);
  658.             }
  660.         foreach ($this->SOCIAL_NETS as $field_type => $values) {
  661.         if (isset($datas['v_datas_card'][$field_type])) {
  662.             $vcard->addURL($datas['v_datas_card'][$field_type], $field_type);
  663.         }
  664.         }
  665.         }
  666.     
  667.     }
  670.    /**
  671.      * @Route("/v/student/card/last", name="app_v_card_student_last", methods={"GET"})
  672.      */
  673. public function last(Request $request, LoggerInterface $logger): Response {
  675.     $session = $request->getSession();
  676.     $is_auth = $session->get('is_auth');
  678.     $user_email = isset($_GET['email']) ?  $_GET['email'] : $session->get('user_email');
  680.     $student_datas = array(
  681.         'avec_photo'    => 'non',
  682.         'tel2'        => '',
  683.             );
  685.     $vcard_datas['can_validate'] = false;
  687.     $vcard_datas['needs_submit'] = false;
  688.     $vcard_datas['can_duplicate'] = false;
  690.     $vcard_datas['disp_vcard_student'] = true;
  692.     $vcard_datas['is_last'] = true;
  693.     $ide_dossier = null;
  695.     $tpl_name = 'v_card_student/last.html.twig';
  697.     $is_download = (    
  698.             (isset($_GET['download']) && $_GET['download'] == 1)
  699.             || (isset($_POST['download']) && $_POST['download'] == 1)
  700.             );
  702.     if (!$is_download) {
  703.             $vcard_datas['is_search'] = true;
  704.         if (isset($_GET['back'])
  705.             && !empty($_GET['back'])
  706.         ) {
  707.             $vcard_datas['back_url'] = '/v/card/search';
  708.         }
  711.         if (isset($_GET['embedded'])) {
  712.             $vcard_datas['embedded'] = true;
  713.         }
  715.         $vcard_datas['is_manager'] = false;
  716.         $vcard_datas['published'] = true;
  718.         $vcard_datas['published_card'] = true; 
  720.         if (isset($_GET['back'])
  721.             && $_GET['back'] == 'search'
  722.         ) {
  723.             $vcard_datas['from_search'] = true;
  724.         }
  725.     }
  727.     if (isset($user_email)) {
  728.         $found = $this->getStudentDatasFromMail($user_email);
  730.         if (isset($found)) { 
  731.             /*
  732.             $student_datas['email'] = $user_email;
  734.             $student_datas['Fonction'] = $found['Fonction'];
  735.             $student_datas['Portable']    = $found['Portable'];
  737.             $student_datas['emailPerso']    = $found['emailPerso'];
  738.             $student_datas['Campus']    = $found['Campus'];
  739.             //*/
  740.             //
  742.             $student_datas = $this->getAllStudentDatas($user_email, isset($_GET['DBG']) && $_GET['DBG'] == 1);
  744.             if (!isset($student_datas['ID_VCARD'])) {
  745.                 return $this->redirectToRoute('app_v_card_student_notfound', [], Response::HTTP_SEE_OTHER);
  747.             }
  749.             $ide_dossier = 'E-'.$student_datas['id.Apprenant'];
  750.             /*
  751.                 $tmp_vcard  = new VCard();
  753.                 $tmp_vcard->setid_vcard(123);
  754.                 $tmp_vcard->settitre($student_datas['titre']);
  756.                 $tmp_vcard->settel($student_datas['tel']);
  757.                 $tmp_vcard->setemail($user_email);
  759.                 $tmp_vcard->setavec_photo($student_datas['avec_photo']);
  760.              */
  766.     $vcard_datas['v_card'] = array(
  767.         'titre'    => '["'.$student_datas['Fonction'].'"]',
  768.         'tel'    => $student_datas['TEL'], // '["'.$student_datas['Portable'].'"]',
  769.         'email' => '["'.$student_datas['email'].'","'.$student_datas['emailPerso'].'"]',
  770.     );
  773.     $tmp_tel_datas = json_decode($student_datas['TEL'], true);
  774.     $d_creation_datas = explode(' ', $student_datas['D_CREATION']);
  775.     $d_creation_label = $d_creation_datas[1];
  778.     $d_creation_datas = explode('-', $d_creation_datas[0]);
  779.     $d_creation_label = $d_creation_datas[2].'/'. $d_creation_datas[1].'/'.$d_creation_datas[0].' '.$d_creation_label;
  782.     $vcard_datas['v_datas_card'] = array(
  783.         'IDE_DOSSIER'    => $ide_dossier,
  784.         'SITE_RATTACHEMENT' => $student_datas['Campus'],
  785.         'ID_VCARD'    => $student_datas['ID_VCARD'],
  786.         'EMAIL_PRO'    => $user_email,
  787.         'ADRESSE_PRO'    => $student_datas['Campus'].' - '. $student_datas['ADRESSE_PRO'],
  788.         'AVEC_PHOTO'    => $student_datas['AVEC_PHOTO'],
  789.         'PRENOM'    => $student_datas['Prénom'],
  790.         'NOM'        => $student_datas['Nom'],
  791.         'TITRE'        => '["'.$student_datas['Fonction'].'"]',
  792.         'TEL_PRO'    => (isset($tmp_tel_datas[0]) ? $tmp_tel_datas[0] : ''), // $student_datas['Portable'],
  793.         'TEL'        => $student_datas['TEL'],
  794.         'EMAIL'     => '["'.$student_datas['email'].'","'.$student_datas['emailPerso'].'"]',
  795.         // TODO: comment social links for now
  796.         /*
  797.         'facebook'    => 'test_facebook',
  798.         'linkedin'    => 'test_linkedin',
  799.         'tikTok'    => 'test_tiktok',
  800.         'instagram'    => 'test_insta',
  801.          // */
  802.         'D_CREATION'    => $d_creation_label 
  804.     );
  806.                 // echo(__METHOD__.' adding v_card....');
  808.         } else { // ENDIF isset found
  809.         return $this->redirectToRoute('app_v_card_student_notfound', [], Response::HTTP_SEE_OTHER);
  811.     } 
  813.     $comm_datas = json_decode($student_datas['COMMENTAIRE'], true);
  815. //*    // TODO: enable social networks support
  816.     foreach ($this->SOCIAL_NETS as $net_item => $net_value) {
  817.         if (isset($comm_datas[$net_item])
  818.             && $comm_datas[$net_item] != ''
  819.         ) {
  820.             $vcard_datas['v_card'][$net_item] = $net_value.$comm_datas[$net_item];
  821.             $vcard_datas['v_datas_card'][$net_item] = $net_value.$comm_datas[$net_item];
  823.             $vcard_datas['v_card'][$net_item.'_url'] = $net_value.$comm_datas[$net_item];
  825.         }
  826.     }
  827. //*/
  829.     $vcard_datas['personnel_datas'] = array(
  830.         'PRENOM'=> $found['Prénom'],
  831.         'NOM'    => $found['Nom'],
  832.         'TEL_PRO'    => $found['Portable'],
  833.         'EMAIL_PRO'    => $user_email,
  836.     );
  838.     if (isset($comm_datas['role'])) {
  839.         $vcard_datas['personnel_datas']['ROLE'] = $comm_datas['role'];
  840.     }
  842.     $uri = "https://{$_SERVER['HTTP_HOST']}{$_SERVER['REQUEST_URI']}";
  843.     $uri .=(isset($_GET['email']) || isset($_GET['embedded']) ? '&' : '?');
  844.         
  845.     $dwnl = $uri . 'download=1'.(isset($user_email) ? '&email='.$user_email : '&email='.$personnel_datas['EMAIL_PRO']);
  847.     $vcard_datas['download_url'] = $dwnl;
  850.     $vcard_datas['qr_code_url'] = $this->generateQrCode($vcard_datas);
  851.     $vcard_datas['disp_vcard_student'] = true;
  853.     $vcard_datas['is_last'] = true;
  855.     $is_download = (    
  856.             (isset($_GET['download']) && $_GET['download'] == 1)
  857.             || (isset($_POST['download']) && $_POST['download'] == 1)
  858.             );
  859.     //*    // TODO: enable social links
  860.             foreach($this->SOCIAL_NETS as $net_item => $val) {
  861.                 if (isset($comm_datas[$net_item])
  862.                     && $comm_datas[$net_item] != ''
  863.                 ) {
  864.                     $vcard_datas['v_card'][$net_item] = $comm_datas[$net_item];
  865.                 }
  867.             }
  868.     //*/
  869.         $tpl_name = isset($_GET['embedded']) // ($_GET['v2']) 
  870.                 ?  'v_card_student/embedded.html.twig' 
  871.                 : 'v_card_student/last.html.twig';
  874.         if (isset($_GET['embedded'])
  875.             && isset($_GET['v4'])
  876.         ) {
  877.             $tpl_name =  'v_card_student/embedded_v4.html.twig'; 
  879.         }
  881.     $photo_file = '/mnt/recadre/'.$ide_dossier.'.jpg';
  884.     // $photo_file = '/mnt/recadre/'.$ide_dossier.'.jpg';
  886.     if ($student_datas['AVEC_PHOTO'] == 'oui'
  887.         || (file_exists($this->uploadsDIR.('photo_'.$ide_dossier.'.jpg')))
  888.     ) {
  889.                 if ($student_datas['AVEC_PHOTO'] != 'oui') {
  890.                     $photo_file = $this->uploadsDIR.('photo_'.$ide_dossier.'.jpg');
  891.                 }
  893.         $key = $this->storeInSession($session, $photo_file);
  895.         if (!empty($key)) {
  896.             $vcard_datas['PHOTO_K'] = $key;
  897.         }
  898.     }
  901. /*
  902.             // echo(__METHOD__.': '. var_export($last_vcard, true)); exit();
  904.             if (isset($student_datas['AVEC_PHOTO']) && $student_datas['AVEC_PHOTO'] == 'oui'
  905.                 || (file_exists($this->uploadsDIR.('photo_'.$ide_dossier.'.jpg')))
  906.             ) {
  907.                 if (!isset($last_vcard['AVEC_PHOTO']) || $last_vcard['AVEC_PHOTO'] != 'oui') {
  908.                     $photo_file = $this->uploadsDIR.('photo_'.$ide_dossier.'.jpg');
  909.                 }
  911.                 $key = $this->storeInSession($session, $photo_file);
  913.                 if (!empty($key)) {
  914.                     $vcard_datas['PHOTO_K'] = $key;
  915.                 }
  917.             }
  918.     //*/
  920.     if (isset($_GET['DBG'])) {
  921.         echo('<br/>'.__METHOD__.': user_email: '.$user_email);
  922.         echo('<br/>'.__METHOD__.': download_url: '.$vcard_datas['download_url']);
  923.     }
  925.         if ($is_download) {
  926.             $vcard_struct_datas = $this->buildVCardFileStructure($user_email);
  927.             $vcard_datas = array_merge($vcard_struct_datas, $vcard_datas);
  929.             // echo(__METHOD__.': vcard_datas: '.var_export($vcard_datas, true));
  931.      $content = $this->getVCardFileContent($vcard_datas, isset($_GET['DBG']));
  932.         $filename = 'vcard_'.$ide_dossier.'.vcf';
  934.         // echo(__METHOD__.' content:'.$content); exit();
  936.              $logger->debug('Downloading QRCODE', [
  937.         // 'user_email' => $user_email,
  938.         'IP_ADDR'    => $_SERVER['REMOTE_ADDR'],
  939.                     ]);
  942.             return new Response($content, 200, array(
  943.                 //*
  944.                 'X-Sendfile'          => $filename,
  945.                 'Content-type'        => 'application/octet-stream',
  946.             'Content-Disposition' => sprintf('attachment; filename="%s"', $filename)
  947.             //*/
  948.             )
  949.         );
  950.     }
  952.     } else { // END if user_email
  953.             return $this->redirectToRoute('app_v_card_student_notfound', [], Response::HTTP_SEE_OTHER);
  954.     }
  956.     if (isset($_GET['DBG'])
  957.         && $tpl_name == 'v_card_student/last.html.twig'
  958.     ) {
  959.         echo(__METHOD__.': '.var_export($vcard_datas, true));
  960.     }
  962.     return $this->renderForm($tpl_name, $vcard_datas);
  964.     }
  966.   /**
  967.      * @Route("/v/student/card/lastcardinfo", name="app_v_card_student_lastcardinfo", methods={"GET"})
  968.      */
  969.    public function lastcardinfo(Request $request, VCardRepository $vCardRepository): Response {
  970.     $content = 'NOT FOUND';
  971.     $session = $request->getSession();
  972.     $user_email = $session->get('user_email');
  973.     $student_datas = $this->getAllStudentDatas($user_email);
  974.     $found = $this->selectLastVcardStudent($student_datas['id.Apprenant']);
  976.     $content = __METHOD__.'<br/>'.var_export($found, true);
  977.     $content .= '<br/>'.var_export($student_datas, true);
  979.     return new Response($content, 200, array(
  981.                     )
  982.             );
  984.    }
  986.     /**
  987.      * @Route("/v/student/card/testvcardstruct", name="app_v_card_student_testvcardstruct", methods={"GET"})
  988.      */
  989.    public function testvcardstruct(Request $request, VCardRepository $vCardRepository): Response {
  991.     $datas = $this->buildVCardFileStructure($_GET['email'], true);
  992.     $content = __METHOD__.' datas: '.var_export($datas, true);
  994.     return new Response($content, 200, array(
  996.                     )
  997.             );
  998.     }
  1001. protected function DEP_selectVcardStudentWhere($where = '') {
  1002.     $out = null;
  1003.     // $id_apprenant = isset($datas['id.Apprenant']) ? $datas['id.Apprenant'] : null;
  1005.     if (isset($where)) {
  1006.         $where = ' where '.$where;
  1007.     }
  1008.         $query  = 'select * from  vcard_student'. $where;
  1010.         $found = $this->selectRaw($query);
  1012.         echo(__METHOD__.': query:'.var_export($query, true));
  1014.         if (count($found) > 0) {
  1015.             // $found = $found[0];
  1017.             if (isset($found[0]['ID_VCARD'])) {
  1018.                 $out = $found;
  1019.             }
  1020.         }
  1021.     
  1023.     return $out;
  1024. }
  1027. protected function buildVCardFileStructure($user_email, $DBG = false) {
  1028.         $out = array();
  1030.     $student_datas = $this->getStudentDatasFromMail($user_email);
  1032.     $out['v_datas_card'] = array(
  1033.                     'NOM'     => $student_datas['Nom'],
  1034.                     'PRENOM'=> $student_datas['Prénom'],
  1035.                     'TITRE' => '["'.$student_datas['Fonction'].'"]',
  1036.                     'EMAIL_PRO'    => $user_email,
  1037.                     'EMAIL'    => $student_datas['emailPerso'],
  1038.                     'TEL_PRO'    => '',
  1039.                     'TEL'    => '["'.$student_datas['Portable'].'"]',
  1040.                     'ADRESSE_PRO' => $this->getFromSite($student_datas['Campus']),
  1041.                     'IDE_DOSSIER' => $student_datas['id.Apprenant'],
  1042.                 );
  1044.     $out['personnel_datas'] = array(
  1045.                     'SERVICE' => $student_datas['Formation'],
  1046.                 );
  1049.     $out = array_merge($out, $this->getAllStudentDatas($user_email));
  1051.     if ($DBG !== false) {
  1052.         echo(__METHOD__.' out: '. var_export($out, true));
  1053.     }
  1055.         return $out;
  1056.     }
  1058. protected function selectLastVcardStudent($id_apprenant) {
  1059.     $out = null;
  1060.     // $id_apprenant = isset($datas['id.Apprenant']) ? $datas['id.Apprenant'] : null;
  1062.     if (isset($id_apprenant)) {
  1063.         $query  = 'select * from  vcard_student where id_apprenant = '. $id_apprenant .' order by id_vcard desc fetch first 1 rows only';
  1065.         $found = $this->selectRaw($query);
  1067.         // echo(__METHOD__.': found:'.var_export($found, true));
  1069.         if (count($found) > 0) {
  1070.             $found = $found[0];
  1072.             if (isset($found['ID_VCARD'])) {
  1073.                 $out = $found;
  1074.             }
  1075.         }
  1076.     }
  1078.     return $out;
  1079. }
  1081. protected function addStudentOptFields($datas) {
  1082.     $out = $datas;
  1083.     $add_fields = array(
  1084.         'Formation'
  1085.     );
  1087.     $add_fields = array_merge($add_fields, array_keys($this->SOCIAL_NETS));
  1089.     if (isset($datas['COMMENTAIRE'])) {
  1090.         $tmp_val = json_decode($datas['COMMENTAIRE'], true);
  1091.     
  1092.         foreach($add_fields as $k => $item) {
  1093.             if (isset($tmp_val[$item])) {
  1094.                 $out[$item] = $tmp_val[$item]; 
  1095.             }
  1096.         }
  1097.     }
  1099.     return $out;
  1100. }
  1102. protected function getAllStudentDatas($user_email, $DBG = false) {
  1103.     $out = array();
  1105.     if (isset($user_email)) {
  1106.         $found = $this->getStudentDatasFromMail($user_email);
  1108.         if (isset($found)) {
  1109.             $student_datas = array(
  1110.                 'avecphoto'    => 'non',
  1111.                 'tel2'        => '',
  1112.             );
  1114.             $student_datas = array_merge($found, $student_datas);
  1116.             $student_datas['titre'] = $found['Fonction'];
  1117.             $student_datas['tel']    = $found['Portable'];
  1119.             $student_datas['emailPerso']    = $found['emailPerso'];
  1120.             $student_datas['ADRESSE_PRO']     = $this->getFromSite($found['Campus']);
  1123.             $db_datas = $this->selectLastVcardStudent($found['id.Apprenant']);
  1125.             if (isset($db_datas['ID_VCARD']) 
  1126.             ) {
  1127.                 $tmp_val = json_decode($db_datas['EMAIL'], true);
  1128.                 if (count($tmp_val) > 1) {
  1129.                     $student_datas['emailPerso'] = $tmp_val[1];
  1130.                 } 
  1132.                 $tmp_val = json_decode($db_datas['TEL'], true);
  1133.                 if (count($tmp_val) > 0) {
  1134.                     $student_datas['tel'] = '0' . substr($tmp_val[0], 3);
  1137.                     if (isset($tmp_val[1])) {
  1138.                         $student_datas['tel2'] = '0' . substr($tmp_val[1], 3);
  1139.                     }
  1140.                 }
  1142.                 if ($db_datas['AVEC_PHOTO'] == 'oui') {
  1143.                     $student_datas['avecphoto'] = $db_datas['AVEC_PHOTO'];
  1144.                 }
  1146.                 $student_datas = array_merge($student_datas, $this->addStudentOptFields($db_datas));
  1147.             }
  1150.             $student_datas['avec_photo'] = $student_datas['avecphoto'];
  1152.             $out = $student_datas;
  1154.             if ($DBG !== false) {
  1155.                 echo(__METHOD__.' out:'. var_export($out, true));
  1156.             }
  1157.         }
  1159.     }
  1161.     return $out;
  1162. }
  1165.     /**
  1166.      * @Route("/v/student/card/new", name="app_v_card_student_new", methods={"GET", "POST"})
  1167.      */
  1168. public function new(Request $request, VCardRepository $vCardRepository): Response {
  1170.     $session = $request->getSession();
  1172.     $this->checkAuth($session, 'app_v_card_student_new');
  1175.     $user_email = $session->get('user_email'); // $_GET['email'];
  1176.     $is_auth = $session->get('is_auth');
  1178.     $DBG = // true ||    // TODO: remove true 
  1179.         isset($_GET['DBG']) && $_GET['DBG'] == '1';
  1181.     $student_datas = array(
  1182.         'avecphoto'    => 'non',
  1183.         'tel2'        => '',
  1184.             );
  1186.     $comm_datas = array();
  1187.     $url = "https://{$_SERVER['HTTP_HOST']}/v/student/card/last?";
  1190.     if (!isset($user_email)) {
  1191.             return $this->redirectToRoute('app_v_card_student_notfound', [], Response::HTTP_SEE_OTHER);
  1192.     }
  1195.     if (isset($user_email)
  1196.         && $is_auth
  1197.     ) {
  1198.         $db_datas = $this->getAllStudentDatas($user_email);
  1200.         if (isset($db_datas['ID_VCARD'])) { // NOTE: card exists in DB
  1201.                 return $this->redirectToRoute('app_v_card_student_edit', [], Response::HTTP_SEE_OTHER);
  1202.         }
  1204.         //*
  1205.         $found = $this->getStudentDatasFromMail($user_email, $DBG);
  1207.         if (isset($found)) {
  1208.             $student_datas['titre'] = $found['Fonction'];
  1209.             $student_datas['tel']    = $found['Portable'];
  1211.             $student_datas['Nom']     = $found['Nom'];
  1212.             $student_datas['Prénom']    = $found['Prénom'];
  1213.             $student_datas['Campus']    = $found['Campus'];
  1214.             $student_datas['ADRESSE_PRO']    = $this->getFromSite($student_datas['Campus']);
  1217.             $student_datas['emailPerso']    = $found['emailPerso'];
  1218.             $student_datas['id.Apprenant']    = $found['id.Apprenant'];
  1220.             $student_datas['Formation']    = $found['Formation'];
  1221.             $student_datas['VERSION']    = 0;
  1224.         //*/
  1226.         // $student_datas = $this->getAllStudentDatas($user_email, $DBG);
  1227.             
  1229.             $vCardStudent = new VCardStudent(); 
  1230.             $form = $this->createForm(VCardStudentType::class, $vCardStudent);
  1232.             $form->handleRequest($request);
  1235.             if ($form->isSubmitted() && $form->isValid()) {
  1236.                 $datas = $form->getData();
  1237.                 $tmp_comms = array();
  1239.                 $comm_datas['date_expiration']    = $found['date_expiration'];
  1240.                 $comm_datas['login']    = $found['login.Individu'];
  1242.                 $datas->setid_apprenant($student_datas['id.Apprenant']);
  1243.                 $datas->setformation($student_datas['Formation']);
  1245.                 $datas->setVERSION(sprintf("%d", $student_datas['VERSION']) + 1);
  1247.                 // NOTE: getting titre opt used for storing role
  1248.                 $titre_datas = json_decode($datas->gettitre(), true);
  1250.                 if (isset($titre_datas[1])) {
  1251.                     $comm_datas['role'] = $titre_datas[1];
  1252.                 }
  1254.                 $form_comment = $datas->getcommentaire();
  1255.                 if (isset($form_comment)) {
  1256.                     $tmp_comms = json_decode($form_comment, true);
  1257.                     $comm_datas = array_merge($comm_datas, $tmp_comms);    
  1258.                 }
  1261.                 if (isset($found['date_expiration'])) {
  1262.                     $datas->setcommentaire(json_encode($comm_datas));
  1263.                 }
  1264.                 // echo(__METHOD__.': '.var_export($datas->gettitre(), true));
  1265.                 // echo(__METHOD__.': '. var_export($datas, true));
  1266.                 if (false !== $this->addVCardStudent($datas)) { // , true)) { // TODO: REMOVE true !!!!!
  1267.                     $this->generateQrCodeFile($url, $user_email);
  1268.                     return $this->redirectToRoute('app_v_card_student_show', [], Response::HTTP_SEE_OTHER);
  1269.                 } else {
  1270.                     echo(__METHOD__. ' addVCardStudent FAILURE: datas: '.var_export($datas, true)); exit();    
  1271.                 }
  1272.             }
  1275.         } else { // END if found
  1276.             return $this->redirectToRoute('app_v_card_student_notfound', [], Response::HTTP_SEE_OTHER);
  1277.         }
  1278.     } // END if user_email
  1280.         return $this->renderForm('v_card_student/new.html.twig', [
  1281.             // 'v_card' => $vCard,
  1282.             'user_email' => $user_email,
  1283.             // 'personnel'    => $personnel_datas,
  1284.             'student'    => $student_datas,
  1285.             'is_new'    => true,
  1286.             'disp_form_student'    => true,
  1287.             // 'is_manager'    => $session->get('is_manager'),
  1288.             'form' => $form,
  1289.         ]);
  1291.     }
  1293. protected function addVCardStudent(VCardStudent $datas, $TEST_MODE = false) {
  1294.     // INSERT INTO "EASYID"."VCARD_STUDENT" (ID_VCARD, ID_APPRENANT, FORMATION, EMAIL, TEL, STATUT, COMMENTAIRE, VERSION, AVEC_PHOTO) VALUES ('1', '1234', 'TEST_FORMATION', 'email@test.com', '[""]', 'enregistrée', '{}', '1', 'non')
  1295.         $out = false;
  1298.         if (isset($datas)) {
  1299.             $query = 'INSERT INTO "EASYID"."VCARD_STUDENT" (ID_VCARD, ID_APPRENANT, FORMATION, EMAIL, TEL, STATUT, COMMENTAIRE, VERSION, AVEC_PHOTO, D_CREATION) VALUES (:ID_VCARD, :ID_APPRENANT, :FORMATION, :EMAIL, :TEL, :STATUT, :COMMENTAIRE, :VERSION, :AVEC_PHOTO, CURRENT_DATE)';
  1301.             $tmp_id = $this->getNewStudentVCardId(); // $datas->getId();
  1303.             if (!isset($tmp_id)) {
  1304.                 $tmp_id = $this->getNewStudentVCardId($TEST_MODE);
  1305.                 $datas->setid_vcard($tmp_id);
  1306.             }
  1308.             $version  = $datas->getversion();
  1309.             $version = ((int) $version) + 1;
  1311.             $version = $this->getNewStudentVersion($datas->getid_apprenant());
  1313.             $commentaire_datas = $datas->getcommentaire();
  1315.             if (!isset($commentaire_datas)) {
  1316.                 $commentaire_datas = '{}';
  1317.             };
  1319.             $avec_photo = $datas->getavecphoto();
  1321.             if ($avec_photo != 'oui') {
  1322.                 $avec_photo = 'non';
  1323.             }
  1325.             $values = array(
  1326.             'ID_VCARD'    => $tmp_id,
  1327.             'ID_APPRENANT'    => $datas->getid_apprenant(),
  1328.             'FORMATION'    => $datas->getformation(),
  1329.             'EMAIL'        => $datas->getemail(),
  1330.             'TEL'        => $datas->gettel(),
  1331.             'STATUT'    => $datas->getstatut(),
  1332.             'COMMENTAIRE'    => $commentaire_datas,
  1333.             'VERSION'    => $version,
  1334.             'AVEC_PHOTO'    => $avec_photo 
  1335.             );
  1336.         // $tmp_datas[] = $datas[];
  1338.         if ($TEST_MODE) {
  1339.             echo(__METHOD__.': SQL:' . $query . '<br/>' . var_export($values, true));
  1340.         }
  1342.         $out = $this->writeRaw($query, $values, $TEST_MODE);
  1343.         }
  1345.         return $out;
  1346.     }
  1349.     /**
  1350.      * @Route("/v/student/card/setuser", name="app_v_card_student_setuser", methods={"GET", "POST"})
  1351.      */
  1352.     public function setuser(Request $request): Response {
  1354.         $session = $request->getSession();
  1356.     $session->set('is_auth', true);
  1357.     $session->set('user_email', $_GET['email']);
  1359.         $content = __METHOD__.': session:'.var_export($session, true);
  1361.     return new Response($content, 200, array(
  1362.             'Content-type'        => 'text/html'
  1363.         )
  1364.     );
  1366.         
  1367.     }
  1369.     /**
  1370.      * @Route("/v/student/card/logout", name="app_v_card_student_logout", methods={"GET", "POST"})
  1371.      */
  1372.     public function logout(Request $request): Response {
  1374.         $session = $request->getSession();
  1376.         $session->set('is_auth', false);
  1377.         $session->set('user_email', null);
  1379.         $content = __METHOD__.': LOGGED_OUT';
  1381.     return new Response($content, 200, array(
  1382.             'Content-type'        => 'text/html'
  1383.         )
  1384.     );
  1386.     }
  1389.     /**
  1390.      * @Route("/v/student/card/userinfo", name="app_v_card_student_userinfo", methods={"GET", "POST"})
  1391.      */
  1392.     public function userinfo(Request $request): Response {
  1394.         $session = $request->getSession();
  1396.         $user = $session->get('user_email');
  1398.         $content = __METHOD__.': session:'.var_export($session, true);
  1399.         $content .= ' user: ' . $user;
  1401.         $content .= '<br/>'.var_export($this->getStudentDatasFromMail($user), true);
  1403.     return new Response($content, 200, array(
  1404.             'Content-type'        => 'text/html'
  1405.         )
  1406.     );
  1408.         
  1409.     }
  1412.     /**
  1413.      * @Route("/v/student/card/uploadres", name="app_v_card_student_uploadres", methods={"GET", "POST"})
  1414.      */
  1415.     public function uploadres(Request $request, VCardRepository $vCardRepository): Response
  1416.     {
  1418.         $session = $request->getSession();
  1421.         /*
  1422.     $is_auth = $session->get('is_auth');
  1423.         //*/
  1424.         $is_auth = true;
  1427.     if (!$is_auth) {
  1429.         $session->set('previous', 'app_v_card_student_show');
  1430.         // $session->set('prev_id', $vCard->getId());
  1433.         return new Response(null, 302, array(
  1434.                 'Location'        => 'auth',
  1435.         ));
  1437.     } else {
  1439.     $user_email = $session->get('user_email');
  1440.     $personnel_datas = $this->getAllStudentDatas($user_email); // getPersonnelFromEnv($session);
  1442.     $ide_dossier = 'E-'.$personnel_datas['id.Apprenant'];
  1444.     /*
  1445.     $filename = '/mnt/recadre/E-94824323.jpg';
  1447.     $target_dir = 'public/uploads/';
  1449.     if (!isset($_GET['key'])) {
  1450.         $key = $this->storeInSession($session, $filename);
  1451.         // echo(__METHOD__.': key: '.$key);
  1452.     } else {
  1453.         $val = $session->get($_GET['key']);
  1454.         echo(__METHOD__.': val: '.$val);
  1455.     }
  1457.     // exit();
  1458.     //
  1459.     //
  1461.     */
  1463.     if (isset($_FILES['fileToUpload']['name'])) { // (isset($_POST['submit']))
  1465.         $file_out = $this->uploadFile('photo_'.$ide_dossier.'.jpg');
  1468.         $file_path = __DIR__.'/../../public'.$file_out;
  1469.         // echo(__METHOD__.': file_out: '.$file_path);
  1471.         $key = $this->storeInSession($session, $file_path);
  1472.         $del_key = $this->storeInSession($session, $file_path);
  1474.         $data_out = array(
  1475.                     'src' => '/v/card/photo?rel='.$key,
  1476.                     'del_key' => $del_key,
  1477.                 );
  1479.         $content = json_encode($data_out); 
  1481.         // $content = 'Done.';
  1483.     return new Response($content, 200, array(
  1484.             'Content-type'        => 'text/html'
  1485.         )
  1486.     );
  1487.     } else if (!empty($_GET['remove'])){
  1488.         $datas = array();
  1489.         $datas['status'] = $this->deleteUploadedFile($_GET['remove']);
  1491.         $content = json_encode($datas);
  1493.         return new Response($content, 200, array(
  1494.             'Content-type'        => 'text/html'
  1495.         ));
  1496.     
  1497.     } else {
  1498.         return $this->render('v_card/upload.html.twig', []); 
  1499.     }
  1500.     } // END else not auth
  1502.     }
  1504.     /**
  1505.      * @Route("/v/student/card/photo", name="app_v_card_student_photo", methods={"GET", "POST"})
  1506.      */
  1507.     public function photo(Request $request, VCardRepository $vCardRepository): Response
  1508.     {
  1510.     $params = array_merge($_GET, $_POST);
  1511.     $session = $request->getSession();
  1512.     // $is_auth = $session->get('is_auth');
  1515.     $img_filename = $this->retrieveFromSession($session, $params['rel']); // $session->get($params['rel']);
  1517.     $content = (isset($params['rel']) && !empty($params['rel']) && isset($img_filename)) ? file_get_contents($img_filename) : '';
  1519.     return new Response($content, 200, array(
  1520.             'Content-type'        => 'image/jpeg'
  1521.         )
  1522.     );
  1523.     }
  1526.     /**
  1527.      * @Route("/v/student/card/testbound", name="app_v_studentcard_testbound")
  1528.      */
  1529.     public function testbound(): Response {
  1530.         echo(__METHOD__.': '. $this->writeRaw('insert into ma_table values(?, ?, ?, ?)',['un', 'deuz', '3', 4])); exit(); 
  1532.     }
  1535.     /**
  1536.      * @Route("/v/student/card/sonsbeurk", name="app_v_card_student_sonsbeurk")
  1537.      */
  1538. public function sonsbeurk(): Response {
  1539.         $tmp_card = (new VCardFile());
  1541.         $test_datas = array(
  1542.                     'v_datas_card' => array(
  1543.                                     'linkedin' => 'https://my_linked_in_URL'
  1544.                                 )
  1545.                 );
  1547.         $this->addVcardOptionalFields($tmp_card, $test_datas);
  1549.         echo(__METHOD__.'tmp_vard: ' . $tmp_card->getOutput());
  1551.         $this->beurk(); exit(); 
  1553.     }
  1556. protected function addVcardSocialFields(VCardFile $vcard, $datas) {
  1557.     $out = $vcard;
  1559.     // $lastname = $datas['v_datas_card']['NOM'];
  1561.     if (isset($datas)
  1562.         && isset($datas['v_datas_card'])
  1563.     ) {
  1564.         $field_type = 'linkedin';
  1566.         if (isset($datas['v_datas_card'][$field_type])) {
  1567.             $vcard->addURL($datas['v_datas_card'][$field_type], $field_type);
  1568.         }
  1569.     }
  1572.         echo(__METHOD__.' vcard: '.var_export($vcard, true). '<br/>datas:' . var_export($datas, true));
  1574.     return $out;
  1575. }
  1578.     public function generateQrCodeFile($uri, $email = '', $prefix = 'QRC') {
  1579.         // $uri = "https://{$_SERVER['HTTP_HOST']}{$_SERVER['REQUEST_URI']}";
  1580.     // $uri .=(isset($_GET['email']) || isset($_GET['embedded']) ? '&' : '?');
  1581.         
  1582.         $dwnl = $uri . 'download=1&email='.$email;
  1584.         $DBG = isset($_GET['DBG']);
  1586.         if (!is_null($uri)
  1587.             && !is_null($email)
  1588.         ) {
  1590.         $student_datas = $this->getAllStudentDatas($email);
  1593.         // TODO: write to file
  1594.         /*
  1595.          $vcard = $this->getVCardFromEmail($email);
  1597.         if ($DBG) {
  1598.             echo(__METHOD__.': vcard: '. var_export($vcard, true));
  1599.         }
  1600.         // */
  1602.         if (isset($student_datas['id.Apprenant'])) {
  1603.             $ide_dossier = 'E-'.$student_datas['id.Apprenant'];
  1605.             $filename = $ide_dossier.'.JPG';
  1606.             $filesystem = new Filesystem();
  1609.             try {
  1610.                 $filename = Path::normalize('/mnt/qrcode/'
  1611.                     // .'TEST__' // TEST ONLY
  1612.                     .$prefix.$filename
  1613.                 ); // sys_get_temp_dir().'/'. $filename);
  1616.                 if (!$this->isNewQRCode($filename)) {
  1617.                     if (file_exists($filename)) {
  1618.                         rename($filename, $filename.'.OLD'); // NOTE: backup old version
  1619.                     }
  1621.                     $options = new QROptions([
  1622.                         'version'         => 5,
  1623.                         'eccLevel'        => QRCode::ECC_L,
  1624.                         'scale'     => 6,                     // 275x275
  1625.                         'outputType'      => QRCode::OUTPUT_IMAGE_JPG,
  1626.                         'imageTransparent' => false,
  1627.                     ]);
  1629. // echo(strpos(file('/mnt/qrcode/TEST__QRC5474.jpg')[0], 'CREATOR'));
  1631.                     $content = (new QRCode($options))->render($dwnl, $filename);
  1632. /*            $filesystem->appendToFile(
  1633.             $filename, $content, true
  1634.             );
  1635.                  */
  1636.         if ($DBG) {
  1638.             echo(__METHOD__.': dwnl:'.$dwnl.'<br/>File: '.$filename);
  1639.         }
  1640.                 } else {
  1641.         if ($DBG) {
  1643.             echo(__METHOD__.': filename: '.$filename.' already updated....');
  1644.         }
  1645.                 }
  1646.             } catch (IOExceptionInterface $exception) {
  1647.                 echo "An error occurred while creating your directory at ".$exception->getPath();
  1648.             }
  1649.         } // END if IDE_DOSSIER
  1651.     }
  1652.     }
  1654.     /**
  1655.      * @Route("/v/student/card/testcreate", name="app_v_card_student_testcreate", methods={"GET", "POST"})
  1656.      */
  1657.     public function testcreate(Request $request, VCardRepository $vCardRepository): Response {
  1658.         $content = 'NOT_FOUND';
  1660.     /*
  1661.         $new_id = $this->getNewStudentVCardId();
  1662.         $content = __METHOD__.': new_id: '. $new_id;
  1663.     //*/
  1665.         echo(__METHOD__.': POST: '.var_export($_POST, true));
  1667.         if ( isset($_POST['v_card']['id_etudiant'])
  1668. //            && isset($_POST['v_card']['email'])
  1669. //            && isset($_POST['v_card']['titre'])
  1670. //            && isset($_POST['v_card']['tel'])
  1671. //            && isset($_POST['v_card']['commentaire'])
  1672. //            && isset($_POST['v_card']['avecphoto'])
  1673.         ) {
  1674.             $content = __METHOD__.' datas: '.$_POST['v_card']['id_etudiant'];
  1675.         }
  1677.     return new Response($content, 200, array(
  1679.                     )
  1680.             );
  1682.     }
  1685.     /**
  1686.      * @Route("/v/student/card/getcachedate", name="app_v_card_student__getcachedate", methods={"GET"})
  1687.      */
  1688.     public function getcachedate(Request $request, VCardRepository $vCardRepository): Response {
  1689.         $content = 'NOT_FOUND';
  1690.         $js_datas = array();
  1692.         $found = $this->getStudentDatasById('CREATED');
  1693.         $content = isset($found) ? $found : 'NOT_FOUND';
  1695.     return new Response($content, 200, array(
  1697.                     )
  1698.             );
  1699.     
  1700.     }
  1702.     /**
  1703.      * @Route("/v/student/card/getdatasbymail", name="app_v_card_student__getdatasbymail", methods={"GET"})
  1704.      */
  1705.     public function getdatasbymail(Request $request, VCardRepository $vCardRepository): Response {
  1706.         $content = 'NOT_FOUND';
  1707.         $js_datas = array();
  1709.         /*
  1710.     if (isset($_GET['email'])) {
  1711.         $file_datas = file_get_contents($this->studentsCacheFile);
  1713.         if (isset($file_datas)) {
  1714.             $js_datas = json_decode($file_datas, true);
  1716.             if (count($js_datas) > 0
  1717.             ) {
  1718.                 $js_datas = $js_datas[$_GET['email']];
  1719.                 if (isset($js_datas['email'])) {
  1720.                     $content = json_encode($js_datas);
  1721.                 }
  1722.             }
  1723.         }
  1724.     }
  1725.      */
  1726.         $found = $this->getStudentDatasFromMail($_GET['email']);
  1727.         $content = isset($found) ? json_encode($found) : 'NOT_FOUND';
  1729.     return new Response($content, 200, array(
  1731.                     )
  1732.             );
  1734.     }
  1737.     /**
  1738.      * @Route("/v/student/card/refreshstudentsfile", name="app_v_studentcard_refreshstudentsfile", methods={"GET"})
  1739.      */
  1740.     public function refreshstudentsfile(Request $request, VCardRepository $vCardRepository): Response {
  1741.     $content = 'KO';
  1743.         $cache_date = (file_exists($this->studentsCacheFile)) ? $this->getStudentDatasById('CREATED') : 0;
  1745.         if (isset($cache_date)) {
  1746.             $content = $cache_date;
  1747.         $timestamp_now = date_timestamp_get(date_create());
  1749.         $duration = $timestamp_now - ((int) $cache_date);
  1751.         if ($duration > $this->CACHE_DURATION) {
  1752.             $datas = $this->getStudentDatasFromServer();
  1754.             if (isset($datas['CREATED'])) {
  1755.                 $content = $datas['CREATED'];
  1756.             }
  1759.         }
  1761.             if (isset($_GET['DBG'])) {
  1762.                 $content .= ' delta:' .$duration;
  1763.             }
  1764.         }
  1766.     return new Response($content, 200, array(
  1767.                     )
  1768.             );
  1770.     }
  1771.     public function getStudentDatasFromServer($DBG = false) {
  1772.         $out = false;
  1774.         $client = new CurlHttpClient();
  1775.         // curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);
  1776. // $client->AllowSelfSignedCertificate();
  1778. $response = $client->request('GET', $this->studentsFileURL, [
  1779.     // ...
  1780.     "verify_peer"=>false,
  1781.     "verify_host"=>false,
  1782.     'extra' => [
  1783.         'curl' => [
  1784.             CURLOPT_IPRESOLVE => CURL_IPRESOLVE_V4,
  1785.         ],
  1786.     ],
  1787. ]);
  1789.         $content = $response->getContent();
  1791.         $datas = json_decode($content, true);
  1793.         $students_datas = array();
  1795.         foreach($datas as $k => $data_line) {
  1796.             if (isset($data_line['email'])) {
  1797.                 $students_datas[$data_line['email']] = $data_line;
  1798.             }
  1799.         }
  1801.         if (count($students_datas) > 1) {
  1802.             $students_datas['CREATED'] = date_timestamp_get(date_create());
  1803.             file_put_contents($this->studentsCacheFile, json_encode($students_datas));
  1805.             $out = $students_datas['CREATED'];
  1806.         }
  1808.         if ($DBG !== false) {
  1809.         echo(__METHOD__. ' Response: ' . var_export($students_datas, true)); exit();
  1810.         }
  1812.         return $out;
  1813.     }
  1815.     /**
  1816.      * @Route("/v/student/card/testSQL", name="app_v_card_student_testSQL", methods={"GET"})
  1817.      */
  1818.         public function testSQL(Request $request, VCardRepository $vCardRepository): Response {
  1819.             //*
  1820.         $query = "INSERT INTO \"EASYID\".\"VCARD_STUDENT\" (ID_VCARD, ID_APPRENANT, FORMATION, EMAIL, TEL, STATUT, COMMENTAIRE, VERSION, AVEC_PHOTO) VALUES (:ID_VCARD, :ID_APPRENANT, :FORMATION, :EMAIL, :TEL, :STATUT, :COMMENTAIRE, :VERSION, :AVEC_PHOTO)";
  1821.         
  1822.         $result = $this->writeRaw($query, array(
  1823.                 'ID_VCARD'     => 2, 
  1824.             'ID_APPRENANT'     => 1234,
  1825.             'FORMATION'    => 'TEST_FORMATION',
  1826.             'EMAIL'        => 'email@test.com', 
  1827.             'TEL'        => '[\"\"]',
  1828.             'STATUT'    => 'enregistrée', 
  1829.             'COMMENTAIRE'    => '{}', 
  1830.             'VERSION'    => '1', 
  1831.             'AVEC_PHOTO'    => 'non'
  1832.             )
  1833.         );
  1835.      // */
  1837.         /*
  1838.         $query = 'select id_vcard,email from vcard_student where id_apprenant = :id_apprenant';
  1839.         $result = $this->writeRaw($query, array(
  1840.                             'id_apprenant'    => 1234
  1841.                         )
  1842.         );
  1843.      */
  1845.     $content = __METHOD__.' result: '.$result;
  1847.     return new Response($content, 200, array(
  1849.                     )
  1850.             );
  1852.     }
  1856.     /**
  1857.      * @Route("/v/student/card/testcurl", name="app_v_card_student_testcurl", methods={"GET"})
  1858.      */
  1859.     public function testcurl(Request $request, VCardRepository $vCardRepository): Response {
  1862. $client = new CurlHttpClient();
  1864. $response = $client->request('GET', 'https://www.google.com', [
  1865.     // ...
  1866.     'extra' => [
  1867.         'curl' => [
  1868.             CURLOPT_IPRESOLVE => CURL_IPRESOLVE_V4,
  1869.         ],
  1870.     ],
  1871. ]);
  1873.     $content = $response->getContent();
  1875.     echo(__METHOD__. ' Response: ' .$content); exit();
  1877.     }
  1878.     /**
  1879.      * @Route("/studentindex", name="app_v_card_student_index", methods={"GET"})
  1880.     public function index(Request $request, VCardRepository $vCardRepository): Response
  1881.     {
  1882.        
  1883.     $session = $request->getSession();
  1884.     $is_auth = $session->get('is_auth');
  1886.     $user_email = $session->get('user_email');
  1888.     print(__METHOD__.' session: '.var_export($session, true).'<br/>'); exit();
  1891.     if (!$is_auth) {
  1893.         $session->set('previous', 'app_v_card_index');
  1894.         return new Response(null, 302, array(
  1895.                 'Location'        => '/v/card/auth',
  1896.         ));
  1898.     } else if (isset($_GET['admin']) && $_GET['admin'] == 1) {
  1900.     // echo(__METHOD__.': user_mail:'.var_export($user_email, true)); exit();
  1902.         return $this->render('v_card/index.html.twig', [
  1903.             'v_cards' => $vCardRepository->findAll(),
  1904.     ]);
  1905.     } else {
  1906.         $content = __METHOD__.': user not found...';
  1908.         $personnel_datas = $this->getPersonnelFromEnv($session);
  1909.         $is_manager = $session->get('is_manager'); // $this->isManager($personnel_datas, $session);
  1911.         // echo(__METHOD__.': personnel_datas: '.var_export($personnel_datas, true)); exit();
  1914.         if (isset($personnel_datas['IDE_DOSSIER'])) {
  1915.             $ide_dossier = $personnel_datas['IDE_DOSSIER'];
  1917.             $last_card = $this->getRecentVCardByIdeDossier($ide_dossier);
  1918.             // $content = var_export($last_card, true);
  1920.             if (isset($last_card['IDE_DOSSIER'])) {
  1921.                     return $this->redirectToRoute('app_v_card_student_show', ['id_vcard' => $last_card['ID_VCARD']], Response::HTTP_SEE_OTHER);
  1922.             } else {
  1923.                         return $this->redirectToRoute('app_v_card_student_new', [], Response::HTTP_SEE_OTHER);
  1924.             }
  1925.         }
  1926.         return new Response($content, 200, array(
  1928.                     )
  1929.             );
  1931.     }
  1932.     }
  1934.      */
  1936. }