src/Controller/MedecinController.php line 96

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\Agencies;
  6. use App\Entity\AgencyDoctors;
  7. use App\Entity\Categories;
  8. use App\Entity\CenterZipcode;
  9. use App\Entity\Centers;
  10. use App\Entity\Cities;
  11. use App\Entity\Degrees;
  12. use App\Entity\DoctorDegrees;
  13. use App\Entity\DoctorPractices;
  14. use App\Entity\Doctors;
  15. use App\Entity\Geocode;
  16. use App\Entity\Hospitals;
  17. use App\Entity\Image;
  18. use App\Entity\Lookup;
  19. use App\Entity\Maps;
  20. use App\Entity\NewsDoctors;
  21. use App\Entity\Practices;
  22. use App\Entity\ServiceDoctors;
  23. use App\Entity\Services;
  24. use App\Entity\Zipcode;
  25. use App\Repository\DoctorPracticesRepository;
  26. use App\Repository\DoctorsRepository;
  27. use App\Repository\ServiceDoctorsRepository;
  28. use Knp\Component\Pager\PaginatorInterface;
  29. use Symfony\Bundle\FrameworkBundle\Controller\Controller;
  30. use Symfony\Component\HttpFoundation\Request;
  31. use Symfony\Component\HttpFoundation\Response;
  32. use Symfony\Component\HttpKernel\Exception\NotFoundHttpException;
  33. use Symfony\Component\Routing\Annotation\Route;
  35. use PhpOffice\PhpSpreadsheet\IOFactory;
  36. use Cocur\Slugify\Slugify;
  37. use Doctrine\ORM\EntityManagerInterface;
  38. use Dom\Entity;
  40. class MedecinController extends AbstractController
  41. {
  42.     /**
  43.      * @Route("/medecin-ORL-phoniatre/{id}", name="redirect_id_medecin", requirements={"id"="\d+"})
  44.      */
  45.     public function redirectIdOnly($id)
  46.     {
  47.         $doctor = $this->getDoctrine()->getRepository(Doctors::class)->findOneBy(['id' => $id, 'visible' => 1]);
  48.         if ($doctor) {
  49.             $slug = $this->slugify->slugify($doctor->getFirstName() . '-' . $doctor->getName());
  50.             $url = $this->router->generate(
  51.                 'page_single_medecin_alone',
  52.                 array('nomMedecin' => $slug, 'idMedecin' => $id)
  53.             );
  54.         } else {
  55.             $url = $this->router->generate(
  56.                 'liste_medecin'
  57.             );
  58.         }
  59.         return $this->redirect($url, 301);
  60.     }
  61.     /**
  62.      * @Route("/medecin-ORL-phoniatre/page/{page}", name="redirect_page_medecins")
  63.      */
  64.     public function redirectPage($page = null)
  65.     {
  66.         if ($page) {
  67.             $url = $this->router->generate(
  68.                 'liste_medecin'
  69.             );
  70.         }
  71.         return $this->redirect($url, 301);
  72.     }
  73.     /**
  74.      * @Route("/medecin-ORL-phoniatre", name="liste_medecin")
  75.      */
  76.     public function renderDefault(): Response
  77.     {
  78.         $this->setJsonIntoTemplate('list');
  79.         $this->setTemplateParameters(array('title_seo' => "Médecins ORL et Phoniatres : Trouvez un médecin ORL près de chez vous"));
  80.         $data =  $this->JsonProvider->getJson('seo_text_medecins_orl');
  81.         $this->setTemplateParameters(array('seo_text' => json_decode($data)));
  82.         $this->setInternalLinkage('medecinListe');
  83.         return $this->renderTemplate('pages/annuaire_search_ORL.twig');
  84.     }
  85.     /**
  86.      * @Route("/medecin-ORL-phoniatre-{zipcode}-{ville}.html", name="results_medecin_audio_by_city", requirements={"zipcode"="\d{5}"}, defaults={"page" = 1})
  87.      * @Route("/medecin-ORL-phoniatre-{zipcode}-{ville}/filtre-resultats/phoniatres-{isPhoniatre}.html", name="results_medecin_audio_by_city_filter_phoniatre", requirements={"zipcode"="\d{5}"}, defaults={"page" = 1})
  88.      * @Route("/medecin-ORL-phoniatre-{zipcode}-{ville}/filtre-resultats/exercice-{exercice}.html", name="results_medecin_audio_by_city_filter_exercice", requirements={"zipcode"="\d{5}"}, defaults={"page" = 1})
  89.      * @Route("/medecin-ORL-phoniatre-{zipcode}-{ville}/filtre-resultats/{idspecialite}-{specialite}.html", name="results_medecin_audio_by_city_filter_specialite", requirements={"zipcode"="\d{5}"}, defaults={"page" = 1})
  90.      * @Route("/medecin-ORL-phoniatre-{departementCode}-{departementTexte}.html", name="results_medecin_by_departement", requirements={"departementCode"="[0-9]{1,2}[0-9A-B]{1}"}, defaults={"page" = 1})
  91.      * @Route("/medecin-ORL-phoniatre-{departementCode}-{departementTexte}/filtre-resultats/phoniatres-{isPhoniatre}.html", name="results_medecin_by_departement_filter_phoniatre", requirements={"departementCode"="[0-9]{1,2}[0-9A-B]{1}"}, defaults={"page" = 1})
  92.      * @Route("/medecin-ORL-phoniatre-{departementCode}-{departementTexte}/filtre-resultats/exercice-{exercice}.html", name="results_medecin_by_departement_filter_exercice", requirements={"departementCode"="[0-9]{1,2}[0-9A-B]{1}"}, defaults={"page" = 1})
  93.      * @Route("/medecin-ORL-phoniatre-{departementCode}-{departementTexte}/filtre-resultats/{idspecialite}-{specialite}.html", name="results_medecin_by_departement_filter_specialite", requirements={"departementCode"="[0-9]{1,2}[0-9A-B]{1}"}, defaults={"page" = 1})
  94.      * 
  95.      */
  96.     public function renderList($zipcode = null, $ville = null, $departementCode = null, $departementTexte = null, $isPhoniatre = null, $exercice = null, $idspecialite = null, $specialite = null, Request $request, PaginatorInterface $paginator): Response
  97.     {
  98.         $title_seo = "Médecins ORL - Phoniatres";
  99.         $doctors_title_seo = $doctors_description_seo = null;
  100.         if ($idspecialite) {
  101.             $diplomeCheck = $this->getDoctrine()->getRepository(Degrees::class)->findOneBy(array('id' => $idspecialite));
  102.             if (!$diplomeCheck) {
  103.                 if ($zipcode) {
  104.                     return $this->redirectProvider->redirect301('results_medecin_audio_by_city', array('zipcode' => $zipcode, 'ville' => $ville));
  105.                 } else if ($departementCode) {
  106.                     return $this->redirectProvider->redirect301('results_medecin_by_departement', array('departementCode' => $departementCode, 'departementTexte' => $departementTexte));
  107.                 }
  108.             } else if ($this->slugify->slugify($diplomeCheck->getName()) != $specialite) {
  109.                 $slugCheck = $this->slugify->slugify($diplomeCheck->getName());
  110.                 if ($zipcode) {
  111.                     return $this->redirectProvider->redirect301('results_medecin_audio_by_city_filter_specialite', array('zipcode' => $zipcode, 'ville' => $ville, 'idspecialite' => $idspecialite, 'specialite' => $slugCheck));
  112.                 } else if ($departementCode) {
  113.                     return $this->redirectProvider->redirect301('results_medecin_by_departement_filter_specialite', array('departementCode' => $departementCode, 'departementTexte' => $departementTexte, 'idspecialite' => $idspecialite, 'specialite' => $slugCheck));
  114.                 }
  115.             }
  116.         }
  117.         $result = [];
  118.         $searchtype = [];
  119.         $doctorsID = [];
  120.         $localisationId = $lng = $lat = $canonical_url = null;
  121.         $doctors = array();
  122.         // SI RECHERCHE PAR VILLE
  123.         if ($zipcode) {
  125.             /********** Description seo ***************/
  126.             $description_seo = "ORL à " . $this->dataProvider->wordUpperCaseFirstLetter($ville) . " (" . $zipcode . ") : Trouvez un médecin ORL ou phoniatre proche de chez vous, consultez ses coordonnées et prenez rendez-vous avec l'Annuaire de l'Audition.";
  127.             // LOCALISATION           
  128.             $localisation = $this->getDoctrine()->getRepository(Zipcode::class)->findOneBy(array(
  129.                 'zipcode' => $zipcode,
  130.                 'city' => strtoupper($ville)
  131.             ));
  132.             if (!$localisation) {
  133.                 $localisation = $this->getDoctrine()->getRepository(Zipcode::class)->findOneBy(array(
  134.                     'zipcode' => $zipcode,
  135.                     'city' => strtoupper(str_replace('-', ' ', $ville))
  136.                 ));
  137.             }
  138.             if (!$localisation) {
  139.                 $localisation = $this->getDoctrine()->getRepository(Zipcode::class)->findByZipCodeAndCityLike($zipcode, $ville);
  140.             }
  141.             if (!$localisation) {
  142.                 $localisation = $this->getDoctrine()->getRepository(Zipcode::class)->findOneBy(['zipcode' => $zipcode]);
  143.             }
  145.             if (!$localisation) {
  146.                 throw new NotFoundHttpException();
  147.             }
  149.             if ($ville != $this->slugify->slugify($localisation->getCity())) {
  150.                 return $this->redirectProvider->redirect301('results_medecin_audio_by_city', array('ville' => $this->slugify->slugify($localisation->getCity()), 'zipcode' => $zipcode));
  151.             }
  152.             $cities = $localisation->getCities();
  153.             if (!$cities) {
  154.                 $cities = $this->geoProvider->addCities($ville, $zipcode, $localisation);
  155.             }
  156.             // DEPARTEMENT ET COORDONNEES
  157.             if (!empty($localisation->getCities())) {
  158.                 $departementTexte = $localisation->getCities()->getDeptTxt();
  159.                 $depcode = $localisation->getCities()->getDeptcode();
  160.                 $localisationId = $localisation->getCities()->getId();
  161.                 $lat = $localisation->getCities()->getLat();
  162.                 $lng = $localisation->getCities()->getLng();
  163.             } else {
  164.                 $dep = $localisation->getDepartment();
  165.                 $departementTexte = substr($dep, 7);
  166.                 $depcode = substr($dep, 0, 2);
  167.             }
  168.             // PREFOOTER 
  169.             $searchtype['departementCode'] = $depcode;
  170.             $searchtype['departementTexte'] = $this->slugify->slugify($departementTexte);
  172.             // BREADCRUMB
  173.             $this->breadDatas['type'] = 'city';
  174.             $this->breadDatas['final'] = $localisation->getCity() . " (" . $zipcode . ")";
  175.             $this->breadDatas['final_url'] = $this->router->generate(
  176.                 'results_medecin_audio_by_city',
  177.                 array('zipcode' => $zipcode, 'ville' => $this->slugify->slugify($ville))
  178.             );
  179.             $this->breadDatas['departementTxt'] = $departementTexte;
  180.             $this->breadDatas['departementCode'] = $depcode;
  181.             $arrondissement = false;
  182.             if ($ville == "paris" || $ville == "marseille" || $ville == "lyon") {
  183.                 $arrondissement = " " . $this->dataProvider->getArrondissement($zipcode);
  184.                 if ($ville != "paris")
  185.                     $this->breadDatas['villeArrondissement'] = $ville;
  186.             }
  187.             $title_seo = "ORL " . $this->dataProvider->wordUpperCaseFirstLetter($localisation->getCity()) . $arrondissement . " (" . $zipcode . ") - Phoniatre : Prenez RDV en ligne";
  189.             // TITRE DE RECHERCHE
  190.             $search_location = $ville;
  192.             // Recherche basée sur le zipcode des adresses des cabinets et des hopitaux
  193.             $doctors = $this->getDoctrine()->getRepository(Doctors::class)->findByLocalisation($localisation->getId());
  194.             foreach ($doctors as $doctor) {
  195.                 $doctor->zip = $zipcode;
  196.                 $doctor->city = $ville;
  197.             }
  198.             $total_results = count($doctors);
  199.             $limit = 30 - $total_results;
  201.             if ($total_results < 30) {
  202.                 $doctors_proximite = [];
  203.                 // ------- Récupération coordonnées de la ville courante
  204.                 $lat = $localisation->getCities()->getLat();
  205.                 $lng = $localisation->getCities()->getLng();
  206.                 $idLoc = $localisation->getCities()->getId();
  207.                 $cities_proximite = $this->getDoctrine()->getRepository(Zipcode::class)->findCitiesByProximite($lat, $lng, $idLoc);
  208.                 foreach ($cities_proximite as $city) {
  209.                     if ($zip_pro = $this->getDoctrine()->getRepository(Zipcode::class)->find($city[0]->getId())) {
  210.                         $zip_pro_id = $zip_pro->getId();
  211.                         if ($total_results < 30) {
  212.                             $doctors_proximite = $this->getDoctrine()->getRepository(Doctors::class)->findByLocalisation($city[0]->getId());
  213.                             foreach ($doctors_proximite as $doctor_proximite) {
  214.                                 if (!in_array($doctor_proximite, $doctors) && $total_results < 30) {
  215.                                     $doctor_proximite->zip = $zip_pro->getZipcode();
  216.                                     $doctor_proximite->city = $zip_pro->getCity();
  217.                                     array_push($doctors, $doctor_proximite);
  218.                                     $total_results = count($doctors);
  219.                                     $limit = 30 - $total_results;
  220.                                 }
  221.                             }
  222.                         }
  223.                     }
  224.                 }
  225.             }
  227.             $datasFilters = array('ville' => $ville, 'zipcode' => $zipcode);
  228.             // Description seo //
  229.             if ($localisation) {
  230.                 $doctors_title_seo = $localisation->getDoctorsTitleSeo();
  231.                 $doctors_description_seo = html_entity_decode($localisation->getDoctorsDescriptionSeo(), ENT_QUOTES);
  232.             }
  233.             $canonical_url = $this->router->generate('results_medecin_audio_by_city', array('zipcode' => $zipcode, 'ville' => $this->slugify->slugify($ville)));
  235.             $centers_url = $this->router->generate('results_centres_audio_by_city', array('zipcode' => $zipcode, 'ville' => $this->slugify->slugify($ville)));
  236.             //$audio_url = $this->router->generate('results_audio_by_city', array('zipcode' => $zipcode, 'ville' => $this->slugify->slugify($ville)));
  237.             $ortho_url = $this->router->generate('results_ortho_audio_by_city', array('zipcode' => $zipcode, 'ville' => $this->slugify->slugify($ville)));
  240.             //$searchtype['exceptZipCode'] = $zipcode;
  241.             $this->setTemplateParameters(array('zipcode' => $zipcode));
  242.             $this->setTemplateParameters(array('ville' => $ville));
  243.         }
  244.         // SI RECHERCHE PAR DEPARTEMENT
  245.         elseif ($departementCode) {
  246.             $depcode = $departementCode;
  248.             /************ Description seo ***************/
  249.             $description_seo = "ORL " . $this->dataProvider->wordUpperCaseFirstLetter($departementTexte) . " (" . $departementCode . ") : Trouvez un médecin ORL ou phoniatre proche de chez vous, consultez ses coordonnées et prenez rendez-vous avec l'Annuaire de l'Audition.";
  251.             // PREFOOTER 
  252.             $searchtype['departementCode'] = $departementCode;
  253.             $searchtype['departementTexte'] = $this->slugify->slugify($departementTexte);
  254.             $localisation = $this->getDoctrine()->getRepository(Cities::class)->findOneBy(array('deptCode' => $departementCode));
  255.             $checkDept = $this->slugify->slugify($localisation->getDeptTxt());
  256.             if ($checkDept != $departementTexte && ($departementTexte != 'lyon' && $departementTexte != 'paris' && $departementTexte != 'marseille')) {
  257.                 return $this->redirectProvider->redirect301('results_medecin_by_departement', array('departementCode' => $departementCode, 'departementTexte' => $checkDept));
  258.             }
  259.             $ville = $localisation->getVille();
  260.             $zipcode = $localisation->getZipCode();
  262.             // DEPARTEMENT ET COORDONNEES
  263.             $localisationId = $localisation->getId();
  264.             $lat = $localisation->getLat();
  265.             $lng = $localisation->getLng();
  267.             // BREADCRUMB
  268.             $this->breadDatas['type'] = 'dept';
  269.             $this->breadDatas['final'] = $localisation->getDeptTxt() . " (" . $departementCode . ")";
  270.             $this->breadDatas['final_url'] = $this->router->generate(
  271.                 'results_medecin_by_departement',
  272.                 array('departementCode' => $departementCode, 'departementTexte' => $this->slugify->slugify($departementTexte))
  273.             );
  274.             $title_seo = "ORL " . $this->dataProvider->wordUpperCaseFirstLetter($localisation->getDeptTxt()) . " (" . $departementCode . ") - Phoniatre : Prenez RDV en ligne";
  276.             // TITRE DE RECHERCHE
  277.             $search_location = $departementTexte;
  279.             // TOUTES LES VILLES DU DEPARTEMENT 
  280.             if ($departementTexte == 'lyon' || $departementTexte == 'paris' || $departementTexte == 'marseille') {
  281.                 $citiesInDept = $this->getDoctrine()->getRepository(Zipcode::class)->findBy(['city' => $departementTexte]);
  282.                 $this->breadDatas['type'] = 'city';
  283.                 $title_seo = "ORL " . $this->dataProvider->wordUpperCaseFirstLetter($departementTexte) . " (" . $departementCode . ") - Phoniatre : Prenez RDV en ligne";
  284.                 $this->breadDatas['final'] = $this->dataProvider->wordUpperCaseFirstLetter($departementTexte) . " (" . $departementCode . ")";
  285.                 // BREADCRUMB SPECIFIQUE
  286.                 switch ($departementTexte) {
  287.                     case 'paris':
  288.                         $this->breadDatas['departementTxt'] = 'Paris';
  289.                         $this->breadDatas['departementCode'] = 75;
  290.                         break;
  291.                     case 'lyon':
  292.                         $this->breadDatas['departementTxt'] = 'Rhône';
  293.                         $this->breadDatas['departementCode'] = 69;
  294.                         break;
  295.                     case 'marseille':
  296.                         $this->breadDatas['departementTxt'] = 'Bouches-du-Rhône';
  297.                         $this->breadDatas['departementCode'] = 13;
  298.                         break;
  299.                 }
  300.             } else {
  301.                 $citiesInDept = $this->getDoctrine()->getRepository(Zipcode::class)->findCitiesInDept($departementCode);
  302.             }
  304.             // TOUS LES DOCTEURS DE TOUTES LES VILLES
  305.             foreach ($citiesInDept as $city) {
  306.                 $doctorsincity = $this->getDoctrine()->getRepository(Doctors::class)->findByLocalisation($city->getId());
  307.                 foreach ($doctorsincity as $doctorincity) {
  308.                     if (!in_array($doctorincity, $doctors)) {
  309.                         $doctorincity->zip = $city->getZipcode();
  310.                         array_push($doctors, $doctorincity);
  311.                     }
  312.                 }
  313.             }
  314.             $datasFilters = array('departementCode' => $departementCode, 'departementTexte' => $departementTexte);
  315.             // Description seo //
  316.             //---- On cherche l'objet Map ayant le nom qui commence par depcode %
  317.             $maps = $this->getDoctrine()->getRepository(Maps::class)->findOneMapByDepCode($departementCode);
  318.             if ($maps && isset($maps[0])) {
  319.                 $doctors_title_seo = $maps[0]->getDoctorsTitleSeo();
  320.                 $doctors_description_seo = html_entity_decode($maps[0]->getDoctorsDescriptionSeo(), ENT_QUOTES);
  321.             }
  323.             $canonical_url = $this->router->generate('results_medecin_by_departement', array('departementCode' => $departementCode, 'departementTexte' => $this->slugify->slugify($departementTexte)));
  325.             $centers_url = $this->router->generate('results_centres_audio_by_departement', array('departementCode' => $departementCode, 'departementTexte' => $this->slugify->slugify($departementTexte)));
  326.             //$audio_url = $this->router->generate('results_audio_by_departement', array('departementCode' => $departementCode, 'departementTexte' => $this->slugify->slugify($departementTexte)));
  327.             $ortho_url = $this->router->generate('results_ortho_by_departement', array('departementCode' => $departementCode, 'departementTexte' => $this->slugify->slugify($departementTexte)));
  328.         }
  330.         // Récupération des filtres phoniatres
  331.         $phoniatre_filters = $this->FiltersProvider->getMedecinPhoniatreFilters($doctors, $datasFilters);
  332.         // Récupération des filtres spécialités
  333.         $specialite_filters = $this->FiltersProvider->getMedecinSpecialiteFilters($doctors, $datasFilters);
  334.         // Récupération des filtres exercices
  335.         $exercice_filters = $this->FiltersProvider->getMedecinExerciceFilters($doctors, $datasFilters);
  336.         $filtered = false;
  337.         $doctors_filtered = array();
  338.         // SI filtre par phoniatre
  339.         if ($isPhoniatre) {
  340.             foreach ($doctors as $doctor) {
  341.                 if (($doctor->getPhoniatricians() && $isPhoniatre == "oui") || (!$doctor->getPhoniatricians() && $isPhoniatre == "non")) {
  342.                     $doctors_filtered[] = $doctor;
  343.                 }
  344.             }
  345.             $filtered = true;
  346.         }
  347.         // Si filtre par spécialité
  348.         if ($idspecialite) {
  349.             foreach ($doctors as $doctor) {
  350.                 $degree = $this->getDoctrine()->getRepository(DoctorDegrees::class)->findOneBy(['doctor' => $doctor->getId(), 'degree' => $idspecialite]);
  351.                 if ($degree) {
  352.                     $doctors_filtered[] = $doctor;
  353.                 }
  354.             }
  355.             $filtered = true;
  356.         }
  357.         // SI filtre par exercice
  358.         if ($exercice) {
  359.             foreach ($doctors as $doctor) {
  360.                 if ($exercice == 'liberal') {
  361.                     $cabinet = $this->getDoctrine()->getRepository(DoctorPractices::class)->findOneBy(['doctorId' => $doctor->getId()]);
  362.                     if ($cabinet)
  363.                         $doctors_filtered[] = $doctor;
  364.                 } else if ($exercice == 'hospitalier') {
  365.                     $service = $this->getDoctrine()->getRepository(ServiceDoctors::class)->findOneBy(['doctorId' => $doctor->getId()]);
  366.                     if ($service)
  367.                         $doctors_filtered[] = $doctor;
  368.                 }
  369.             }
  370.             $filtered = true;
  371.         }
  372.         if ($filtered) {
  373.             $result = $this->cardProvider->getDoctorsCards($doctors_filtered);
  374.         } else {
  375.             $result = $this->cardProvider->getDoctorsCards($doctors);
  376.         }
  377.         // PAGINATION
  378.         $results_paginated = $paginator->paginate(
  379.             $result,
  380.             $request->query->getInt('page', 1),
  381.             30
  382.         );
  384.         $map = array();
  385.         foreach ($results_paginated as $result_paginated) {
  386.             if (array_key_exists('hospital', $result_paginated)) {
  387.                 if ($marker = $this->geoProvider->getHospitalCoords($result_paginated['hospital'], $result_paginated['image'], 'Docteur', $result_paginated['doctor']->getTitle())) {
  388.                     $map['markers'][] = $marker;
  389.                 }
  390.             } else if (array_key_exists('practice', $result_paginated)) {
  391.                 if ($marker = $this->geoProvider->getPracticeCoords($result_paginated['practice'], $result_paginated['image'], 'Docteur', $result_paginated['doctor']->getTitle())) {
  392.                     $map['markers'][] = $marker;
  393.                 }
  394.             }
  395.         }
  397.         // INJECTION DANS VUE
  398.         $this->setTemplateParameters(array(
  399.             'searchresult' => array('orl' => $results_paginated),
  400.             'filter' => array(
  401.                 'specialites' => $specialite_filters,
  402.                 'phoniatre' => $phoniatre_filters,
  403.                 'exercice' => $exercice_filters,
  404.             )
  405.         ));
  407.         //$this->breadDatas['ville'] = $ville;
  408.         //$this->breadDatas['zipcode'] = $zipcode;
  409.         $this->setBreadcrumb('medecins', 'list');
  411.         // PREFOOTER
  412.         $searchtype['lng'] = $lng;
  413.         $searchtype['lat'] = $lat;
  414.         $searchtype['localisationId'] = $localisationId;
  416.         $this->setTemplateParameters(array('map' => $map));
  417.         $deptForPreFooter = ($departementTexte == "paris" || $ville == "paris" || $departementTexte == "marseille" || $ville == "marseille" || $departementTexte == "lyon" || $ville == "lyon") ? "à " . $departementTexte : "en " . $departementTexte;
  418.         $this->setTemplateParameters(array('dept' => $deptForPreFooter));
  419.         $this->setTitleSearch();
  420.         $this->setPrevNextRel(count($result), $request->query->getInt('page'), $request->getSchemeAndHttpHost() . $request->getPathInfo());
  421.         $this->setInternalLinkage('medecinListe', $searchtype);
  422.         $this->setTemplateParameters(array('title_seo' => $title_seo));
  423.         $this->setTemplateParameters(array('description_seo' => $description_seo));
  424.         $this->setTemplateParameters(array('seo_text' => array('title' => $doctors_title_seo, 'text' => $doctors_description_seo)));
  425.         $this->setTemplateParameters(array('canonical_url' => $canonical_url));
  426.         $this->setTemplateParameters(array(
  427.             'centers_url' => $centers_url,
  428.             //'audio_url' =>$audio_url, 
  429.             'ortho_url' => $ortho_url
  430.         ));
  431.         return $this->renderTemplate('pages/annuaire_searchResults_ORL.twig');
  432.     }
  435.     /**
  436.      * @Route("/medecin-ORL-phoniatre/{ville}-{zipcode}/{nomMedecin}-{idMedecin}-practice-{idPractice}.html", name="page_single_medecin_with_practice", requirements={"zipcode"="\d{5}", "nomMedecin"="[a-zA-Z0-9\-_\/]+", "idMedecin"="[0-9]+", "ville"="[a-zA-Z0-9\-_\/]+", "idPractice"="[0-9]+"})
  437.      *
  438.      * @Route("/medecin-ORL-phoniatre/{ville}-{zipcode}/{nomMedecin}-{idMedecin}-service-{idService}.html", name="page_single_medecin_with_service", requirements={"zipcode"="\d{5}", "nomMedecin"="[a-zA-Z0-9\-_\/]+", "idMedecin"="[0-9]+", "ville"="[a-zA-Z0-9\-_\/]+", "idService"="[0-9]+"})
  439.      *
  440.      * @Route("/medecin-ORL-phoniatre/{ville}-{zipcode}/{nomMedecin}-{idMedecin}.html", name="page_single_medecin", requirements={"zipcode"="\d{5}", "nomMedecin"="[a-zA-Z0-9\-_\/]+", "idMedecin"="[0-9]+", "ville"="[a-zA-Z0-9\-_\/]+"})
  441.      * @Route("/medecin-ORL-phoniatre/{nomMedecin}-{idMedecin}.html", name="page_single_medecin_alone", requirements={"nomMedecin"="[a-zA-Z0-9\-_\/]+", "idMedecin"="[0-9]+"})
  442.      */
  443.     public function renderPage($ville = null, $zipcode = null, $nomMedecin = null, $idMedecin = null, $idPractice = null, $idService = null, Request $request): Response
  444.     {
  445.         $team = [];
  446.         $page_provider = [];
  447.         $url_practice = $url_service = null;
  448.         $doctor = $this->getDoctrine()->getRepository(Doctors::class)->findOneBy(['id' => $idMedecin, 'visible' => 1]);
  449.         if (!$doctor) {
  450.             if ($zipcode) {
  451.                 return $this->redirectProvider->redirect301('results_medecin_audio_by_city', array('zipcode' => $zipcode, 'ville' => $ville));
  452.             } else {
  453.                 return $this->redirectProvider->redirect301('liste_medecin');
  454.             }
  455.         }
  456.         $cabinet = $service = null;
  457.         $slugMedecin = $this->slugify->slugify($doctor->getFirstName() . '-' . $doctor->getName());
  458.         if ($slugMedecin != $nomMedecin) {
  460.             if ($idPractice) {
  461.                 return $this->redirectProvider->redirect301('page_single_medecin_with_practice', array('zipcode' => $zipcode, 'ville' => $ville, 'nomMedecin' => $slugMedecin, 'idMedecin' => $idMedecin, 'idPractice' => $idPractice));
  462.             } else if ($idService) {
  463.                 return $this->redirectProvider->redirect301('page_single_medecin_with_service', array('zipcode' => $zipcode, 'ville' => $ville, 'nomMedecin' => $slugMedecin, 'idMedecin' => $idMedecin, 'idService' => $idService));
  464.             } else {
  466.                 return $this->redirectProvider->redirect301('page_single_medecin_alone', array('nomMedecin' => $slugMedecin, 'idMedecin' => $idMedecin));
  467.             }
  468.         }
  469.         $alone = false;
  470.         if (!$idPractice && !$idService) {
  471.             $alone = true;
  472.         }
  473.         if ($idPractice) {
  474.             $cabinet = $this->getDoctrine()->getRepository(Practices::class)->find($idPractice);
  475.             if (!$cabinet) {
  477.                 return $this->redirectProvider->redirect301('page_single_medecin_alone', array('nomMedecin' => $slugMedecin, 'idMedecin' => $idMedecin));
  478.             }
  479.         } else if ($idService) {
  480.             $service = $this->getDoctrine()->getRepository(Services::class)->find($idService);
  481.             if (!$service) {
  482.                 return $this->redirectProvider->redirect301('page_single_medecin_alone', array('nomMedecin' => $slugMedecin, 'idMedecin' => $idMedecin));
  483.             }
  484.         }
  485.         /*else {
  486.       $cabinet = $this->getDoctrine()->getRepository(Doctors::class)->findPracticeByDoctorID($idMedecin, null, 1);
  487.       $cabinet = ($cabinet)? $cabinet[0] : NULL;
  488.       if($cabinet) {
  489.         $idPractice = $cabinet->getId();
  490.       }
  491.     }*/
  492.         // Les Autres Cabinets & Services //
  493.         $buttons = [];
  494.         
  495.         $i = 1;
  496.         $idspractices = array();
  497.         $practices = $this->getDoctrine()->getRepository(Doctors::class)->findPracticeByDoctorID($idMedecin);
  498.         foreach ($practices as $practice) {
  499.             $zipcodeCheck = $this->getDoctrine()->getRepository(Zipcode::class)->findOneBy(['id' => $practice->getLocalisation()->getId()]);
  500.             if ($zipcodeCheck) {
  501.                 if ($practice->getLocalisation()->getZipcode()) {
  502.                     $url = $this->router->generate(
  503.                         'page_single_medecin_with_practice',
  504.                         array(
  505.                             'zipcode' => $practice->getLocalisation()->getZipcode(),
  506.                             'nomMedecin' => $slugMedecin,
  507.                             'idMedecin' => $idMedecin,
  508.                             'ville' => $this->slugify->slugify($practice->getLocalisation()->getCity()),
  509.                             'idPractice' => $practice->getId(),
  510.                         )
  511.                     );
  512.                     $url_practice = $url;
  513.                     if ($alone) {
  514.                         return $this->redirect($url, 301);
  515.                     }
  517.                     $idpractice = $practice->getId();
  518.                     $idspractices[] = $idpractice;
  519.                     $current = (!$idService && $idpractice == $idPractice) ? true : false;
  520.                     array_push($buttons, array(
  521.                         "title" => 'Cabinet ' . $i,
  522.                         "url" => "/medecin-ORL-phoniatre/" . $this->slugify->slugify($practice->getLocalisation()->getCity()) . "-" . $practice->getLocalisation()->getZipcode() . "/" . $slugMedecin . '-' . $idMedecin . "-practice-" . $idpractice . ".html",
  523.                         "current" => $current,
  524.                     ));
  525.                     $i++;
  527.                     if ($current) {
  528.             $doctorPractice = $this->getDoctrine()->getRepository(DoctorPractices::class)->findOneBy(['doctorId' => $idMedecin, 'practice' => $idpractice]);
  530.             $this->setTemplateParameters(array('doctolibIframe' => $doctorPractice->getDoctolibIframe() ?? ''));
  532.                         $phone = (!empty($doctorPractice->getPhone())) ? $doctorPractice->getPhone() : $cabinet->getPhone();
  533.                         if ($practice->getLocalisation()->getZipcode() && $zipcode != $practice->getLocalisation()->getZipcode()) {
  534.                             return $this->redirectProvider->redirect301(
  535.                                 'page_single_medecin_with_practice',
  536.                                 array(
  537.                                     'ville' => $this->slugify->slugify($practice->getLocalisation()->getCity()),
  538.                                     'zipcode' => $practice->getLocalisation()->getZipcode(),
  539.                                     'nomMedecin' => $nomMedecin,
  540.                                     'idMedecin' => $idMedecin,
  541.                                     'idPractice' => $idPractice,
  542.                                 )
  543.                             );
  544.                         }
  545.                         // Infos Cabinet
  546.                         $adresse = $cabinet->getAddress() . " \n";
  547.                         if ($cabinet->getAdditionalAddress()) {
  548.                             $adresse .= $cabinet->getAdditionalAddress() . " \n";
  549.                         }
  550.                         $adresse .= $cabinet->getLocalisation()->getZipcode() . ' ' . $cabinet->getLocalisation()->getCity() . " \n";
  551.                         if ($cabinet->getPoBox()) {
  552.                             $adresse .= $cabinet->getPoBox() . " \n";
  553.                         }
  554.                         if ($cabinet->getZipCedex()) {
  555.                             $adresse .= $cabinet->getZipCedex() . " ";
  556.                         }
  557.                         if ($cabinet->getCityCedex()) {
  558.                             $adresse .= $cabinet->getCityCedex();
  559.                         }
  560.             
  561.                         $page_provider = array(
  562.                             "coords" => array(
  563.                                 "items" => array(
  564.                                     "tel1" => $phone,
  565.                                     "address" => $cabinet->getAddress() . " \n" . $cabinet->getAdditionalAddress(),
  566.                                     "zip" => $cabinet->getLocalisation()->getZipcode(),
  567.                                     "city" => $cabinet->getLocalisation()->getCity(),
  568.                                     "bp" => $cabinet->getPoBox(),
  569.                                     "zipcedex" => $cabinet->getZipCedex(),
  570.                                     "citycedex" => $cabinet->getCityCedex()
  571.                                 ),
  572.                                 "coordTitle" => $practice->getName()
  573.                             )
  574.                         );
  575.                     }
  576.                 }
  577.             }
  578.         }
  579.         if (($idPractice && !in_array($idPractice, $idspractices))) {
  580.             $zipcodeCheckCurrent = $this->getDoctrine()->getRepository(Zipcode::class)->findOneBy(['id' => $idPractice]);
  581.             if (!$zipcodeCheckCurrent) {
  582.                 return $this->redirectProvider->redirect301('page_single_medecin_alone', array('nomMedecin' => $nomMedecin, 'idMedecin' => $idMedecin));
  583.             }
  584.         }
  586.         $services = $this->getDoctrine()->getRepository(Doctors::class)->findServiceByDoctorID($idMedecin);
  587.         $idsservices = array();
  588.         $j = 1;
  589.         foreach ($services as $serv) {
  590.             if ($serv->getHospital()->getLocalisation()->getCountry() == "FRANCE" || $serv->getHospital()->getLocalisation()->getCountry() == "") {
  591.                 $url = $this->router->generate(
  592.                     'page_single_medecin_with_service',
  593.                     array(
  594.                         'zipcode' => $serv->getHospital()->getLocalisation()->getZipcode(),
  595.                         'nomMedecin' => $slugMedecin,
  596.                         'idMedecin' => $idMedecin,
  597.                         'ville' => $this->slugify->slugify($serv->getHospital()->getLocalisation()->getCity()),
  598.                         'idService' => $serv->getId()
  599.                     )
  600.                 );
  601.                 $url_service = $url;
  602.                 if ($alone) {
  603.                     return $this->redirect($url, 301);
  604.                 }
  605.                 $idservice = $serv->getId();
  606.                 $idsservices[] = $idservice;
  607.                 $current = ($idservice == $idService) ? true : false;
  608.                 array_push($buttons, array(
  609.                     "title" => "Service ORL " . $j,
  610.                     "url" => "/medecin-ORL-phoniatre/" . $this->slugify->slugify($serv->getHospital()->getLocalisation()->getCity()) . "-" . $serv->getHospital()->getLocalisation()->getZipcode() . "/" . $slugMedecin . '-' . $idMedecin . "-service-" . $idservice . ".html",
  611.                     "current" => $current,
  612.                 ));
  613.                 $j++;
  614.                 if ($current) {
  615.                     if ($zipcode != $serv->getHospital()->getLocalisation()->getZipcode()) {
  617.                         return $this->redirectProvider->redirect301(
  618.                             'page_single_medecin_with_service',
  619.                             array(
  620.                                 'ville' => $this->slugify->slugify($serv->getHospital()->getLocalisation()->getCity()),
  621.                                 'zipcode' => $serv->getHospital()->getLocalisation()->getZipcode(),
  622.                                 'nomMedecin' => $nomMedecin,
  623.                                 'idMedecin' => $idMedecin,
  624.                                 'idService' => $idService
  625.                             )
  626.                         );
  627.                     }
  629.                     $page_provider = array(
  630.                         "coords" => array(
  631.                             "items" => array(
  632.                                 "address" => $serv->getHospital()->getAddress() . " \n" . $serv->getHospital()->getAdditionalAddress(),
  633.                                 "zip" => $serv->getHospital()->getLocalisation()->getZipcode(),
  634.                                 "city" => $serv->getHospital()->getLocalisation()->getCity(),
  635.                                 "bp" => $serv->getHospital()->getPoBox(),
  636.                                 "zipcedex" => $serv->getHospital()->getCedex(),
  637.                                 "citycedex" => $serv->getHospital()->getCityCedex()
  638.                             ),
  639.                             "coordTitle" => $serv->getHospital()->getCorporateName(),
  640.                             'subtitleORLService' => $serv->getName(),
  641.                             'link' => $url = $this->router->generate(
  642.                                 'page_service_hospitalier_avec_service',
  643.                                 array(
  644.                                     'ville' => $ville,
  645.                                     'zipcode' => $zipcode,
  646.                                     'nomhopital' => $this->slugify->slugify($serv->getHospital()->getCorporateName()),
  647.                                     'idhopital' => $serv->getHospital()->getId(),
  648.                                     'nomservice' => $this->slugify->slugify($serv->getName()),
  649.                                     'idservice' => $serv->getId(),
  650.                                 )
  651.                             )
  652.                         )
  653.                     );
  655.                     $serviceDoctor = $this->getDoctrine()->getRepository(ServiceDoctors::class)->findOneBy([
  656.                         'service' => $idService,
  657.                         'doctor' => $idMedecin
  658.                     ]);
  659.           $this->setTemplateParameters(array('doctolibIframe' => $serviceDoctor->getDoctolibIframe() ?? ''));
  661.                     if ($serviceDoctor && $serviceDoctor->getTelSpecifique()) {
  662.                         $page_provider['coords']['items']['telSpec'] = $serviceDoctor->getTelSpecifique();
  663.                         $page_provider['coords']['items']['telSpecDesc'] = $serviceDoctor->getTelSpecifiqueDesc();
  664.                     } else {
  665.                         // Infos Cabinet
  666.                         for ($i = 1; $i <= 3; $i++) {
  667.                             $tel = $serv->{'getTitle' . $i}();
  668.                             if (!empty($tel))
  669.                                 $tel .= "\n";
  670.                             $tel .= $serv->{'getDescription' . $i}();
  671.                             $page_provider['coords']['items']['tel' . $i] = $tel;
  672.                         }
  673.                     }
  674.                 }
  675.             }
  676.         }
  677.         if ($idService && !in_array($idService, $idsservices)) {
  678.             return $this->redirectProvider->redirect301('page_single_medecin_alone', array('nomMedecin' => $nomMedecin, 'idMedecin' => $idMedecin));
  679.         }
  680.         $localisation = $this->getDoctrine()->getRepository(Zipcode::class)->findOneBy(array(
  681.             'zipcode' => $zipcode,
  682.             'city' => strtoupper($ville)
  683.         ));
  684.         if (!$localisation) {
  685.             $localisation = $this->getDoctrine()->getRepository(Zipcode::class)->findOneBy(array(
  686.                 'zipcode' => $zipcode,
  687.                 'city' => strtoupper(str_replace('-', ' ', $ville))
  688.             ));
  689.         }
  690.         if (!$localisation) {
  691.             $localisation = $this->getDoctrine()->getRepository(Zipcode::class)->findByZipCodeAndCityLike($zipcode, $ville);
  692.         }
  693.         if (!$localisation) {
  694.             $localisation = $this->getDoctrine()->getRepository(Zipcode::class)->findOneBy(['zipcode' => $zipcode]);
  695.         }
  697.         if (!$localisation) {
  698.             throw new NotFoundHttpException();
  699.         }
  701.         if ($localisation && ($zipcode != $localisation->getZipcode() || $ville != $this->slugify->slugify($localisation->getCity()))) {
  702.             return $this->redirectProvider->redirect301('page_single_medecin_alone', array('nomMedecin' => $nomMedecin, 'idMedecin' => $idMedecin));
  703.         }
  704.         //if(!$alone)
  705.         //$slugVille = $this->slugify->slugify($localisation->getCity());
  707.         // Logo //
  708.         $logo = $this->dataProvider->getAvatar('Docteur', $doctor->getTitle());
  709.         if ($logoId = $this->getDoctrine()->getRepository(Image::class)->findOneBy(['class' => 'Doctors', 'entityId' => $idMedecin, 'cover' => 1])) {
  710.             $file = $this->bo_url . "images/" . $logoId->getId() . "-medium.jpg";
  711.             $logo = $file;
  712.         }
  714.         // Diplômes //
  715.         $diplomes = $this->getDoctrine()->getRepository(Doctors::class)->getDoctorDegrees($idMedecin);
  716.         $diplomas = [];
  717.         foreach ($diplomes as $diplome) {
  718.             $diplomas[] = $diplome->getName();
  719.         }
  720.         if (!empty($doctor->getFreeField())) {
  721.             $diplomas[] = $doctor->getFreeField();
  722.         }
  724.         // Centres à proximités du cabinet //
  725.         // On teste s'il y a un cabinet en paramètre, sinon on récupère le premier cabinet dans la requête.
  726.         $centre_proximite = [];
  728.         if ($cabinet || $service) {
  729.             $object = ($cabinet) ? $cabinet : $service;
  730.             // Coordonnées de localisation
  731.             if ($service) {
  732.                 $cities = $service->getHospital()->getLocalisation()->getCities();
  733.                 if (!$cities) {
  734.                     $cities = $this->geoProvider->addCities($ville, $zipcode, $localisation);
  735.                 }
  736.                 $geocode = $this->dataProvider->getGeoCode($service->getHospital());
  737.             } else {
  738.                 $cities = $object->getLocalisation()->getCities();
  739.                 if (!$cities) {
  740.                     $cities = $this->geoProvider->addCities($ville, $zipcode, $localisation);
  741.                 }
  742.                 $geocode = $this->dataProvider->getGeoCode($object);
  743.             }
  744.             $lat = $geocode['lat'];
  745.             $lng = $geocode['lng'];
  746.             $idLoc = $geocode['idLoc'];
  747.             $centersCity = $this->getDoctrine()->getRepository(Centers::class)->findBy([
  748.                 'localisation' => $localisation->getId(),
  749.                 'advertiser' => 1,
  750.                 'visible' => 1
  751.             ]);
  752.             shuffle($centersCity);
  753.             foreach ($centersCity as $c) {
  754.                 array_push($centre_proximite, $c);
  755.             }
  756.             $centersRelated = $this->getDoctrine()->getRepository(CenterZipcode::class)->findBy(['zipcodeId' => $localisation->getId()]);
  757.             shuffle($centersRelated);
  758.             foreach ($centersRelated as $c) {
  759.                 $cr = $this->getDoctrine()->getRepository(Centers::class)->findOneBy([
  760.                     'id' => $c->getCenterId(),
  761.                     'advertiser' => 1,
  762.                     'visible' => 1
  763.                 ]);
  764.                 if ($cr) {
  765.                     array_push($centre_proximite, $cr);
  766.                 }
  767.             }
  768.             if (sizeof($centre_proximite) < 6) {
  769.                 $limit = 6 - sizeof($centre_proximite);
  770.                 $proximites = $this->getDoctrine()->getRepository(Centers::class)->findCentersByProximiteCity(array('lat' => $lat, 'lng' => $lng), $localisation->getId(), $limit);
  771.                 shuffle($proximites);
  772.                 foreach ($proximites as $proximite) {
  773.                     $centerPro = $this->getDoctrine()->getRepository(Centers::class)->findOneBy(['id' => $proximite[0]->getId(), 'visible' => 1]);
  774.                     if ($centerPro && !in_array($centerPro, $centre_proximite)) {
  775.                         array_push($centre_proximite, $centerPro);
  776.                     }
  777.                 }
  778.             }
  779.             $centre_proximite = $this->cardProvider->getCenterCards($centre_proximite);
  781.             // On cherche les autres médecins du même cabinet ou du même service //
  782.             $lieuType = null;
  783.             $lieuEntity = null;
  784.             if ($cabinet) {
  785.                 $otherDoctors = $this->getDoctrine()->getRepository(Doctors::class)->findByPractice($cabinet->getId(), $idMedecin);
  786.                 $lieuType = "cabinet";
  787.                 $lieuEntity = $cabinet;
  788.             } elseif ($service) {
  789.                 $otherDoctors = $this->getDoctrine()->getRepository(Doctors::class)->findByService($service->getId(), $idMedecin);
  790.                 $lieuType = "service";
  791.                 $lieuEntity = $service;
  792.             }
  793.             $team = $this->cardProvider->getOrlCards($otherDoctors, $localisation, $lieuType, $lieuEntity);
  794.         }
  796.         // Les actualités //
  797.         $news = [];
  798.         $a = [];
  799.         $v = [];
  800.         $actualites = $this->getDoctrine()->getRepository(NewsDoctors::class)->findNewsByDoctorID($idMedecin);
  801.         if ($actualites) {
  802.             $a = $this->cardProvider->getNewsCards($actualites);
  803.         }
  804.         $videos = $this->getDoctrine()->getRepository(NewsDoctors::class)->findVideosByDoctorID($idMedecin);
  805.         if ($videos) {
  806.             $v = $this->cardProvider->getVideosCards($videos);
  807.         }
  808.         $news = array_merge($a, $v);
  810.         // Associations //
  811.         $agencies = [];
  812.         $associations = $this->getDoctrine()->getRepository(AgencyDoctors::class)->findBy(array('doctor' => $idMedecin));
  813.         if ($associations) {
  814.             $orga = array();
  815.             foreach ($associations as $asso) {
  816.                 $agencie = null;
  817.                 $agencie = $this->getDoctrine()->getRepository(Agencies::class)->findOneBy(array('id' => $asso->getAgency()->getId()));
  818.                 if ($agencie) {
  819.                     $agencie->role1 = $asso->getSpecificity1();
  820.                     $agencie->role2 = $asso->getSpecificity2();
  821.                 }
  822.                 array_push($orga, $agencie);
  823.             }
  824.             $agencies = $this->cardProvider->getAgencyCards($orga, $zipcode, $ville, true);
  825.         }
  827.         // ROLES
  828.         $servicesDoctors = $this->getDoctrine()->getRepository(ServiceDoctors::class)->findBy(array('doctorId' => $idMedecin));
  829.         $rolesDesordre = array();
  830.         $roles = [];
  832.         foreach ($servicesDoctors as $servicesDoctor) {
  833.             $hopital = false;
  834.             $lookup = $this->getDoctrine()->getRepository(Lookup::class)->findOneBy(['code' => $servicesDoctor->getStatusGrade(), 'type' => 'StatusGrade']);
  835.             $serviceD = $this->getDoctrine()->getRepository(Services::class)->findOneBy(['id' => $servicesDoctor->getService()]);
  836.             if ($serviceD) {
  837.                 $hopital = $this->getDoctrine()->getRepository(Hospitals::class)->findOneBy(['id' => $serviceD->getHospital()]);
  838.             }
  839.             $cityhospital = "";
  840.             if ($hopital && $hopital->getLocalisation()->getCity())
  841.                 $cityhospital = " de " . $hopital->getLocalisation()->getCity();
  842.             if ($lookup && $hopital) {
  843.                 $nom = $lookup->getName();
  844.                 if (!empty($servicesDoctor->getSpecialty()))
  845.                     $nom .= " (" . $servicesDoctor->getSpecialty() . ")";
  846.                 $nom .= " " . $hopital->getCorporateName() . $cityhospital;
  847.                 $rolesDesordre[] = array(
  848.                     'nom' => $nom,
  849.                     'position' => $lookup->getPosition()
  851.                 );
  852.             }
  853.         }
  854.         $pos = array_column($rolesDesordre, 'position');
  855.         array_multisort($pos, SORT_ASC, $rolesDesordre);
  856.         foreach ($rolesDesordre as $r) {
  857.             $roles[] = $r['nom'];
  858.         }
  860.         // Titres organismes
  861.         if (isset($orga)) {
  862.             foreach ($orga as $agencie) {
  863.                 $rolePerson = "";
  864.                 if ($agencie->role1)
  865.                     $rolePerson = $agencie->role1;
  866.                 if ($agencie->role2)
  867.                     $rolePerson .= ", " . $agencie->role2;
  868.                 if ($agencie->role1 || $agencie->role2)
  869.                     $rolePerson .= " " . $agencie->getCorporateName();
  870.                 $roles[] = $rolePerson;
  871.             }
  872.         }
  873.         // Header //
  874.         $header = array(
  875.             "image" => $logo,
  876.             "name" => $doctor->getFirstName(),
  877.             "surname" => $doctor->getName(),
  878.             "grade" => $doctor->getTitle(),
  879.             "job" => $this->dataProvider->getDoctorSpecialities($idMedecin),
  880.             "roles" => $roles,
  881.         );
  882.         $this->setTemplateParameters(array(
  883.             "page_orl" => array(
  884.                 "header" => $header,
  885.                 "diplomas" => $diplomas,
  886.                 "centers" => $centre_proximite,
  887.                 "team" => $team,
  888.                 "type" => ($service) ? 'service' : 'cabinet',
  889.                 "actus" => $news,
  890.                 "associations" => $agencies,
  891.                 "lieuType" => ($service) ? 'service ORL' : 'cabinet',
  892.             ),
  893.             'search' => array(
  894.                 'filter' => $buttons,
  895.             ),
  896.             "page_provider" => $page_provider,
  897.         ));
  898.         if (!$alone) {
  899.             if (!isset($lat)) {
  900.                 $lat = $localisation->getCities()->getLat();
  901.                 $lng = $localisation->getCities()->getLng();
  902.                 $idLoc = $localisation->getCities()->getId();
  903.             }
  904.             $searchtype['lat'] = $lat;
  905.             $searchtype['lng'] = $lng;
  906.             $searchtype['currentCityId'] = $idLoc;
  907.             $this->setTemplateParameters(array('city' => $localisation->getCity()));
  908.             $map['markers'][] = array(
  909.                 "lat" => $lat,
  910.                 "lon" => $lng,
  911.                 "premium" => true,
  912.                 "src" => "url(" . $logo . ")"
  913.             );
  914.             $this->setInternalLinkage('medecinPage', $searchtype);
  915.             $dep = $localisation->getDepartment();
  916.             $departementTxt = $localisation->getCities()->getDeptTxt();
  917.             $departementCode = $localisation->getCities()->getDeptCode();
  919.             $this->breadDatas['ville'] = $localisation->getCity();
  920.             $this->breadDatas['zipcode'] = $localisation->getZipcode();
  921.             $this->breadDatas['departementTxt'] = $departementTxt;
  922.             $this->breadDatas['departementCode'] = $departementCode;
  923.             $this->setTemplateParameters(array('map' => $map));
  924.         }
  926.         if ($zipcode && $ville) {
  927.             $centers_url = $this->router->generate('results_centres_audio_by_city', array('zipcode' => $zipcode, 'ville' => $this->slugify->slugify($ville)));
  928.             //$audio_url = $this->router->generate('results_audio_by_city', array('zipcode' => $zipcode, 'ville' => $this->slugify->slugify($ville)));
  929.             $ortho_url = $this->router->generate('results_ortho_audio_by_city', array('zipcode' => $zipcode, 'ville' => $this->slugify->slugify($ville)));
  930.         }
  933.         /************** Titre seo ***************/
  934.         $title_seo = $doctor->getFirstName() . ' ' . $doctor->getName() . ' - Médecin ORL';
  935.         if ($ville) {
  936.             $title_seo .=  ' à ' . $this->dataProvider->wordUpperCaseFirstLetter($localisation->getCity()) . ' (' . $zipcode . ')';
  937.             /************** Description seo ***************/
  938.             $description_seo = "Prenez rendez-vous avec " . $doctor->getFirstName() . " " . $doctor->getName() . ", médecin ORL à " . $this->dataProvider->wordUpperCaseFirstLetter($localisation->getCity()) . " (" . $zipcode . "). Consultez ses coordonnées et son adresse sur l'Annuaire de l'Audition.";
  939.         }
  941.         $canonical_url = null;
  942.         if ($url_practice) {
  943.             $canonical_url = $url_practice;
  944.     }
  945.         elseif ($url_service) {
  946.             $canonical_url = $url_service;
  947.     }
  948.         else {
  949.             $canonical_url = $this->dataProvider->getDoctorLink($idMedecin);
  950.     }
  952.         $this->setTemplateParameters(array('title_seo' => $title_seo));
  953.         $this->setTemplateParameters(array('description_seo' => $description_seo ?? ""));
  954.         $this->setTemplateParameters(array('canonical_url' => $canonical_url));
  955.         $this->breadDatas['final'] = $doctor->getFirstName() . ' ' . $doctor->getName();
  956.         // Breadcrumb
  957.         $this->setBreadcrumb('medecins', 'single');
  958.         $this->setTemplateParameters(array('dataLayerCenters' => $centre_proximite, 'creative' => 'fiche-pro'));
  959.         $this->setTemplateParameters(array(
  960.             'centers_url' => $centers_url ?? "",
  961.             //'audio_url' =>$audio_url ?? "",
  962.             'ortho_url' => $ortho_url ?? ""
  963.         ));
  965.         if ($idPractice) $this->setTemplateParameters(array('idPractice' => $idPractice));
  966.         if ($idService)  $this->setTemplateParameters(array('idService' => $idService));
  968.         if ($idPractice || $idService) {
  969.             $id_entity = $idPractice ?? $idService;
  970.             $entity = $idPractice ? 'practice' : 'service';
  972.             // on cherche le cache des parkings
  973.             if (file_exists('overpass/parkings/' . $entity . '/' . $entity . '-' . intval($id_entity) . '.json')) {
  974.                 $data = json_decode(file_get_contents('overpass/parkings/' . $entity . '/' . $entity . '-' . intval($id_entity) . '.json'));
  975.                 $parkings = $this->renderView('modules/map/nearby.html.twig', array(
  976.                     'type' => "parkings",
  977.                     'parkings' => (array)$data
  978.                 ));
  979.                 $this->setTemplateParameters(array('parkings' => $parkings));
  980.             }
  982.             $transport_communs = [];
  983.             // on cherche le cache des bus
  984.             if (file_exists('overpass/buses/' . $entity . '/' . $entity . '-' . intval($id_entity) . '.json')) {
  985.                 $data = json_decode(file_get_contents('overpass/buses/' . $entity . '/' . $entity . '-' . intval($id_entity) . '.json'));
  986.                 if ($data) {
  987.                     $transport_communs['buses'] = $data;
  988.                 }
  989.                 $buses = $this->renderView('modules/map/nearby.html.twig', array(
  990.                     'type' => "transport",
  991.                     'subtype' => "buses",
  992.                     'buses' => (array)$data
  993.                 ));
  994.                 $this->setTemplateParameters(array('buses' => $buses));
  995.             }
  997.             // on cherche le cache des métros/trains
  998.             if (file_exists('overpass/subways/' . $entity . '/' . $entity . '-' . intval($id_entity) . '.json')) {
  999.                 $data = json_decode(file_get_contents('overpass/subways/' . $entity . '/' . $entity . '-' . intval($id_entity) . '.json'));
  1000.                 if ($data) {
  1001.                     $transport_communs['subways'] = $data;
  1002.                 }
  1003.                 $subways = $this->renderView('modules/map/nearby.html.twig', array(
  1004.                     'type' => "transport",
  1005.                     'subtype' => "subways",
  1006.                     'subways' => (array)$data
  1007.                 ));
  1008.                 $this->setTemplateParameters(array('subways' => $subways));
  1009.             }
  1011.             // on cherche le cache des trams.
  1012.             if (file_exists('overpass/trams/' . $entity . '/' . $entity . '-' . intval($id_entity) . '.json')) {
  1013.                 $data = json_decode(file_get_contents('overpass/trams/' . $entity . '/' . $entity . '-' . intval($id_entity) . '.json'));
  1014.                 if ($data) {
  1015.                     $transport_communs['trams'] = $data;
  1016.                 }
  1017.                 $trams = $this->renderView('modules/map/nearby.html.twig', array(
  1018.                     'type' => "transport",
  1019.                     'subtype' => "trams",
  1020.                     'trams' => (array)$data
  1021.                 ));
  1022.                 $this->setTemplateParameters(array('trams' => $trams));
  1023.             }
  1024.         }
  1026.         // FAQ //
  1027.         $faqs = [];
  1028.         $nomMedecin = $doctor->getTitle() . ' ' . $doctor->getFirstName() . ' ' . $doctor->getName();
  1029.         $entity = $cabinet;
  1030.         if (!$cabinet && $service && $service->getHospital()) $entity = $service->getHospital();
  1032.         if ($entity) {
  1033.             $address = $entity->getAddress();
  1034.             if ($entity->getLocalisation() && $entity->getLocalisation()->getId()) {
  1035.                 $address .= " " . $entity->getLocalisation()->getZipcode() . " " . $entity->getLocalisation()->getCity();
  1036.             }
  1037.             $faqs[] = [
  1038.                 "question" => "Quelle est l'adresse du " . $nomMedecin . " ?",
  1039.                 "response" => "L'adresse du " . $nomMedecin . " est " . $address
  1040.             ];
  1042.             $phone = $entity->getPhone();
  1043.             if ($phone) {
  1044.                 $faqs[] = [
  1045.                     "question" => "Comment contacter le " . $nomMedecin . " ?",
  1046.                     "response" => "Il est possible de contacter le " . $nomMedecin . " par téléphone au " . $phone . "."
  1047.                 ];
  1048.             }
  1049.       
  1050.         }
  1052.         if ($diplomas) {
  1053.             $suffix = (sizeof($diplomas) > 1) ? "s" : "";
  1054.             $response_txt = "Le " . $nomMedecin . " possède le" . $suffix . " diplôme" . $suffix . " suivant" . $suffix . " :<ul>";
  1055.             foreach ($diplomas as $diplome) {
  1056.                 $response_txt .= "<li>" . $diplome . "</li>";
  1057.             }
  1058.             $response_txt .= "</ul>";
  1059.             $faqs[] = [
  1060.                 "question" => "Quelle est la formation et quels sont les diplômes du " . $nomMedecin . " ?",
  1061.                 "response" => $response_txt
  1062.             ];
  1063.         }
  1065.         if ((sizeof($idsservices) + sizeof($idspractices) > 1)) {
  1066.             $suffix = (sizeof($idsservices) + sizeof($idspractices) > 1) ? "s" : "";
  1067.             $suffixX = (sizeof($idsservices) + sizeof($idspractices) > 1) ? "x" : "";
  1068.             $response_txt = "";
  1069.             foreach ($practices as $practice) {
  1070.                 $response_txt .= "<li>" . $practice->getName();
  1071.                 if ($practice->getLocalisation() && $practice->getLocalisation()->getId()) {
  1072.                     $response_txt .= " à " . $practice->getLocalisation()->getCity();
  1073.                 }
  1074.                 $response_txt .= "</li>";
  1075.             }
  1076.             foreach ($services as $service) {
  1077.                 $service = $service->getHospital();
  1078.                 $response_txt .= "<li>" . $service->getCorporateName();
  1079.                 if ($service->getLocalisation() && $service->getLocalisation()->getId()) {
  1080.                     $response_txt .= " à " . $service->getLocalisation()->getCity();
  1081.                 }
  1082.                 $response_txt .= "</li>";
  1083.             }
  1084.             if ($response_txt) {
  1085.                 $faqs[] = [
  1086.                     "question" => "Où exerce le " . $nomMedecin . " ?",
  1087.                     "response" => "Le " . $nomMedecin . " exerce dans les " . (sizeof($idsservices) + sizeof($idspractices)) . " lieu" . $suffixX . " suivant" . $suffix . " :<ul>" . $response_txt . "</ul>"
  1088.                 ];
  1089.             }
  1090.         }
  1092.         $placeType = $cabinet ? "cabinet ORL" : "service ORL";
  1093.         if ($otherDoctors) {
  1094.             $suffix = sizeof($otherDoctors) > 1 ? "s" : "";
  1095.             $suffix_ENT = sizeof($otherDoctors) > 1 ? "nt" : "";
  1096.             $placeAddress = " " . $entity->getAddress();
  1097.             if ($entity->getLocalisation() && $entity->getLocalisation()->getId()) {
  1098.                 $placeAddress .= " " . $entity->getLocalisation()->getZipcode() . " " . $entity->getLocalisation()->getCity();
  1099.             }
  1100.             $response_txt = "";
  1101.             foreach ($otherDoctors as $doc) {
  1102.                 $response_txt .= "<li>" . $doc->getTitle() . " " . $doc->getFirstName() . " " . $doc->getName() . "</li>";
  1103.             }
  1104.             $faqs[] = [
  1105.                 "question" => "Quels sont les autres médecins ORL du " . $placeType . " " . $placeAddress . " ?",
  1106.                 "response" => sizeof($otherDoctors) . " autre" . $suffix . " médecin" . $suffix . " ORL exerce" . $suffix_ENT . " également dans le " . $placeType . " du " . $nomMedecin . " :<ul>" . $response_txt . "</ul>"
  1107.             ];
  1108.         }
  1110.         if ($transport_communs) {
  1111.             $response_txt = "";
  1112.             foreach ($transport_communs as $type => $tc) {
  1113.                 $type = $type == 'buses' ? 'Bus - ' : ($type == 'subways' ? 'Métro - ' : 'Tram - ');
  1114.                 foreach ($tc as $value) {
  1115.                     $response_txt .= "<li>" . $type . $value->name . "</li>";
  1116.                 }
  1117.             }
  1118.             $faqs[] = [
  1119.                 "question" => "Comment accéder au " . $placeType . " du " . $nomMedecin . " par les transports en commun ?",
  1120.                 "response" => "Le " . $placeType . " du " . $nomMedecin . " est situé à proximité des arrêts suivants :<ul>" . $response_txt . "</ul>"
  1121.             ];
  1122.         }
  1124.         $this->setTemplateParameters(array('faqs' => $faqs));
  1126.         return $this->renderTemplate('pages/annuaire_page_ORL.twig', [
  1127.             'idMedecin' => $idMedecin,
  1128.         ]);
  1129.     }
  1131.   /**
  1132.    * @Route("/import-doctolib-links", name="import_doctolib_links")
  1133.    */
  1134.   public function importDoctolibLinks(
  1135.     DoctorPracticesRepository $doctorPracticesRepository,
  1136.     ServiceDoctorsRepository $serviceDoctorsRepository,
  1137.     EntityManagerInterface $em,
  1138.     Request $request
  1139.   ) {
  1140.     if (!$request->query->get('filename')) {
  1141.       die('No file exists');
  1142.     }
  1144.     $inputFileName = 'imports/' . $request->query->get('filename');
  1145.     $spreadsheet = IOFactory::load($inputFileName);
  1146.     $sheetData = $spreadsheet->getActiveSheet()->toArray();
  1147.     unset($sheetData[0]);
  1148.     $prefix = "https://partners.doctolib.fr/orl/";
  1149.     $slugify = new Slugify();
  1150.     foreach ($sheetData as $row)
  1151.     {
  1152.       if (empty($row[0])) break;
  1153.       
  1154.       $url = $prefix . $slugify->slugify($row[13]) . '/' . $slugify->slugify($row[8]) . '-' . $slugify->slugify($row[9]);
  1155.       $urlImported = false;
  1156.       $idCabService = $row[3];
  1158.       // Check practices.
  1159.       /** @var [] DoctorPractices */
  1160.       $doctorPractices = $doctorPracticesRepository->findBy(['doctorId' => $row[0]]);
  1161.       if (count($doctorPractices)) {
  1162.         foreach ($doctorPractices as $doctorPractice) {
  1163.           /**
  1164.            * @var Practices $practice
  1165.            */
  1166.           $practice = $doctorPractice->getPractice();
  1167.           $idCabService = $row[3];
  1168.           if ($idCabService == $practice->getId()) {
  1169.             $doctorPractice->setDoctolibIframe($url);
  1170.             $em->persist($doctorPractice);
  1171.             $em->flush();
  1172.             $urlImported = true;
  1173.             break;
  1174.           }
  1175.         }
  1176.       }
  1178.       // Check services.
  1179.       if (!$urlImported) {
  1180.         $services = $serviceDoctorsRepository->findBy(['doctorId' => $row[0]]);
  1181.         if (count($services)) {
  1182.           foreach ($services as $serviceDoctor) {
  1183.             if ($idCabService == $serviceDoctor->getService()->getId()) {
  1184.               $serviceDoctor->setDoctolibIframe($url);
  1185.               $em->persist($serviceDoctor);
  1186.               $em->flush();
  1187.               $urlImported = true;
  1188.               break;
  1189.             }
  1190.           }
  1191.         }
  1192.       }
  1194.       if (!$urlImported) {
  1195.         echo $row[0] . ' - ' . $url . '<br>';
  1196.       }
  1198.     }
  1200.     die('Import done');
  1201.   }
  1203.   /**
  1204.    * @Route("/get-all-orls-having-doctolib-iframe", name="get_all_orls_having_doctolib_iframe")
  1205.    */
  1206.   public function getAllOrlsHavingDoctolibIframe(
  1207.     DoctorPracticesRepository $doctorPracticesRepository,
  1208.     ServiceDoctorsRepository $serviceDoctorsRepository
  1209.   ) {
  1210.     $siteUrl = $_SERVER['REQUEST_SCHEME'] . '://' . $_SERVER['HTTP_HOST'];
  1211.     $urls = '';
  1212.     // Practices.
  1213.     $doctorPractices = $doctorPracticesRepository->findAllHavingDoctolibIframe();
  1214.     foreach ($doctorPractices as $doctorPractice) {
  1215.       $practice = $doctorPractice->getPractice();
  1216.       if ($practice->getLocalisation()->getCountry() != 'FRANCE') {
  1217.         continue;
  1218.       }
  1219.       $doctor = $doctorPractice->getDoctor();
  1220.       if (!$doctor || !$practice) continue;
  1222.       $slugMedecin = $this->slugify->slugify($doctor->getFirstName() . '-' . $doctor->getName());
  1223.       $urls .= $siteUrl . $this->router->generate(
  1224.         'page_single_medecin_with_practice',
  1225.         array(
  1226.           'zipcode' => $practice->getLocalisation()->getZipcode(),
  1227.           'nomMedecin' => $slugMedecin,
  1228.           'idMedecin' => $doctor->getId(),
  1229.           'ville' => $this->slugify->slugify($practice->getLocalisation()->getCity()),
  1230.           'idPractice' => $practice->getId(),
  1231.         )
  1232.       ) . '<br>';
  1233.     }
  1235.     // Services.
  1236.     $servicesDoctors = $serviceDoctorsRepository->findAllHavingDoctolibIframe();
  1237.     foreach ($servicesDoctors as $serviceDoctor) {
  1238.       $service = $serviceDoctor->getService();
  1239.       if ($service->getHospital()->getLocalisation()->getCountry() !== 'FRANCE') {
  1240.         continue;
  1241.       }
  1242.       $doctor = $serviceDoctor->getDoctor();
  1243.       if (!$doctor || !$practice) continue;
  1245.       $slugMedecin = $this->slugify->slugify($doctor->getFirstName() . '-' . $doctor->getName());
  1246.       $urls .= $siteUrl . $this->router->generate(
  1247.         'page_single_medecin_with_service',
  1248.         array(
  1249.           'zipcode' => $service->getHospital()->getLocalisation()->getZipcode(),
  1250.           'nomMedecin' => $slugMedecin,
  1251.           'idMedecin' => $doctor->getId(),
  1252.           'ville' => $this->slugify->slugify($service->getHospital()->getLocalisation()->getCity()),
  1253.           'idService' => $service->getId()
  1254.         )
  1255.       ) . '<br>';
  1256.     }
  1258.     die($urls);
  1259.   }
  1261. }