src/Controller/Api/Factory/ApiWidgetsController.php line 1157

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Api\Factory;
  5. use App\Entity\Adherent\Annuaire\MagasinContact;
  6. use App\Entity\Adherent\Magasin;
  7. use App\Entity\Adherent\MagasinCollaborateurs;
  8. use App\Entity\Adherent\MagasinCoordonnees;
  9. use App\Entity\Adherent\MagasinEquipe;
  10. use App\Entity\Adherent\MagasinMarques;
  11. use App\Entity\Adherent\MagasinUrl;
  12. use App\Entity\Image\Image;
  13. use App\Entity\ImagePartner;
  14. use App\Entity\OffresConso\OffreInscription;
  15. use App\Entity\OffresConso\OffreWeb;
  16. use App\Entity\Webfactory\Actualites\WebfactoryActualite;
  17. use App\Entity\Webfactory\Actualites\WebfactoryActualiteCategory;
  18. use App\Entity\Webfactory\AnnouncementBar;
  19. use App\Entity\Webfactory\CustomCssJs;
  20. use App\Entity\Webfactory\SeoVilles;
  21. use App\Entity\Webfactory\SeoVillesContenus;
  22. use App\Entity\Webfactory\WebfactoryFittingBoxImg;
  23. use App\Entity\Webfactory\WebfactoryPage;
  24. use App\Entity\Webfactory\WebfactoryWidget;
  25. use App\Entity\Webfactory\Widget\SiteWebService;
  26. use App\Entity\Webfactory\Widget\SiteWebSpecialite;
  27. use App\Entity\Webfactory\Widget\WidgetAbstract;
  28. use App\Enum\FactoryEnum;
  29. use App\Helper\Factory\FactoryHelper;
  30. use App\Helper\FiltersReviewsHelper;
  31. use App\Manager\Crm\CrmAccessManager;
  32. use App\Manager\Crm\RcuManager;
  33. use App\Manager\DatasProgress;
  34. use App\Manager\OpcManager;
  35. use App\Manager\QueryProgress;
  36. use App\Manager\Webfactory\MarquesManager;
  37. use App\Manager\Webfactory\WebfactoryManager;
  38. use App\Manager\WsProgressManager;
  39. use Cocur\Slugify\Slugify;
  40. use Doctrine\Common\Collections\Criteria;
  41. use Doctrine\ORM\EntityManagerInterface;
  42. use Doctrine\ORM\NonUniqueResultException;
  43. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  44. use Symfony\Component\DependencyInjection\ParameterBag\ParameterBagInterface;
  45. use Symfony\Component\HttpFoundation\JsonResponse;
  46. use Symfony\Component\HttpFoundation\Request;
  47. use Symfony\Component\HttpFoundation\Session\SessionInterface;
  48. use Symfony\Component\Routing\Annotation\Route;
  49. use Symfony\Component\Serializer\Normalizer\ObjectNormalizer;
  50. use Symfony\Contracts\HttpClient\HttpClientInterface;
  51. use Symfony\Contracts\Translation\TranslatorInterface;
  53. /**
  54.  * @Route("/api/v1")
  55.  */
  56. class ApiWidgetsController extends AbstractController
  57. {
  59.     private $entityManager;
  60.     private $wsProgressManager;
  61.     private $datasProgress;
  62.     private $webfactoryManager;
  63.     private $session;
  64.     private $translator;
  65.     private $factoryHelper;
  66.     private $rcuManager;
  67.     private $crmAccessManager;
  68.     private $cdnOpc;
  69.     private $opcManager;
  70.     private $marquesManager;
  71.     private $langs;
  72.     private $urlPhotosAdh;
  74.     /**
  75.      * @param EntityManagerInterface $entityManager
  76.      * @param WsProgressManager $wsProgressManager
  77.      * @param DatasProgress $datasProgress
  78.      * @param WebfactoryManager $webfactoryManager
  79.      * @param SessionInterface $session
  80.      */
  81.     public function __construct(
  82.         FactoryHelper                $factoryHelper,
  83.         EntityManagerInterface       $entityManager,
  84.         WsProgressManager            $wsProgressManager,
  85.         DatasProgress                $datasProgress,
  86.         WebfactoryManager            $webfactoryManager,
  87.         SessionInterface             $session,
  88.         TranslatorInterface          $translator,
  89.         RcuManager                   $rcuManager,
  90.         CrmAccessManager             $crmAccessManager,
  91.         ParameterBagInterface        $parameterBag,
  92.         OpcManager                   $opcManager,
  93.         MarquesManager               $marquesManager,
  94.         private HttpClientInterface  $client,
  95.         private FiltersReviewsHelper $filtersReviewsHelper
  96.     )
  97.     {
  98.         $this->entityManager = $entityManager;
  99.         $this->wsProgressManager = $wsProgressManager;
  100.         $this->datasProgress = $datasProgress;
  101.         $this->webfactoryManager = $webfactoryManager;
  102.         $this->session = $session;
  103.         $this->translator = $translator;
  104.         $this->factoryHelper = $factoryHelper;
  105.         $this->rcuManager = $rcuManager;
  106.         $this->crmAccessManager = $crmAccessManager;
  107.         $this->cdnOpc = $parameterBag->get('twicpics_domain_images_OPC');
  108.         $this->opcManager = $opcManager;
  109.         $this->marquesManager = $marquesManager;
  110.         $this->langs = ['fr', 'nl'];
  112.         $request = Request::createFromGlobals();
  113.         if ($request->getHttpHost() == "espace-adherent.groupeall.com" || $request->getHttpHost() == "api.groupeall.com") {
  114.             $this->urlPhotosAdh = $parameterBag->get('twicpics_domain_images_OPC') . 'adherent/';
  115.             $this->urlPhotosDefault = $parameterBag->get('twicpics_domain_images_OPC') . 'webfactory/fitting_box/';
  116.             $this->urlPhotosPrivateUpload = $parameterBag->get('twicpics_domain_images'). 'adherent/';
  118.         } elseif ($request->getHttpHost() == "espace-adherentpp.groupeall.com" || $request->getHttpHost() == "apipp.groupeall.com") {
  119.             $this->urlPhotosAdh = $request->getSchemeAndHttpHost() . "/privateUploads/photos_adh_web/";
  120.             $this->urlPhotosDefault = $request->getSchemeAndHttpHost() . "/build/images/webfactory/fitting_box/";
  121.             $this->urlPhotosPrivateUpload = $request->getSchemeAndHttpHost() . "/privateUploads/photos_adh_web/";
  122.         } else {
  123.             $this->urlPhotosAdh = $request->getSchemeAndHttpHost() . "/espace_adherent/public/privateUploads/photos_adh_web/";
  124.             $this->urlPhotosDefault = $request->getSchemeAndHttpHost() . "/espace_adherent/public/build/images/webfactory/fitting_box/";
  125.             $this->urlPhotosPrivateUpload = $request->getSchemeAndHttpHost() . "/espace_adherent/public/privateUploads/photos_adh_web/";
  126.         }
  127.     }
  129.     /**
  130.      * @Route("/magasin/{magasin}/widget/virtual_fitting", name="factory_api_widget_virtual_fitting")
  131.      * @param Request $request
  132.      * @param Magasin $magasin
  133.      * @return void
  134.      */
  135.     public function widgetCabineEssayage(Request $request, Magasin $magasin)
  136.     {
  137.         $listBrands = $this->entityManager->getRepository(MagasinMarques::class)->findBy(['magasin' => $magasin]);
  138.         $tabListBrands = $this->marquesManager->formatTabListBrandsApi($listBrands, $magasin);
  140.         // ----------------------------------------- Gestion images fitting box -----------------------------------------------
  142.         $selectedFittingBoxImg = $this->entityManager->getRepository(WebfactoryFittingBoxImg::class)->findOneBy(['adherent' => $magasin->getKAdherent()]);
  144.         $finalTab = [];
  145.         foreach ($this->langs as $lang) {
  147.             $finalTab[strtolower($lang)] = [
  148.                 "alt" => $this->translator->trans("Cabine d'essayage virtuelle", [], "messages", $lang),
  149.                 "title" => $this->translator->trans("Essayez votre monture en ligne", [], "messages", $lang),
  150.                 "button_text" => $this->translator->trans("Essayer maintenant", [], "messages", $lang),
  151.                 "brands_slides" => [
  152.                     'list' => $tabListBrands[strtolower($lang)]['list'],
  153.                     'total' => $tabListBrands[strtolower($lang)]['total']
  154.                 ]
  155.             ];
  157.             if ($selectedFittingBoxImg) {
  158.                 if ($selectedFittingBoxImg->getImageDefault()){
  159.                     $finalTab[strtolower($lang)]['image'] = $this->urlPhotosDefault . $selectedFittingBoxImg->getImageWidget();
  160.                 } else {
  161.                     $finalTab[strtolower($lang)]['image'] = $this->urlPhotosPrivateUpload . $magasin->getKAdherent() . "/". $selectedFittingBoxImg->getImageWidget();
  162.                 }
  163.             } else {
  164.                 $finalTab[strtolower($lang)]['image'] = $this->urlPhotosDefault . "widget_fitting_box_2.png";
  165.             }
  167.         }
  168.         return new JsonResponse($finalTab);
  169.     }
  171.     /**
  172.      * @param Magasin $magasin
  173.      * @return JsonResponse
  174.      * @Route("/magasin/{magasin}/widget/hours", name="factory_api_widget_hours")
  175.      */
  176.     public function horaires(Magasin $magasin)
  177.     {
  178.         $datas = [
  179.             'fr' => $this->webfactoryManager->formatHoursForApi($magasin),
  180.             'nl' => $this->webfactoryManager->formatHoursForApi($magasin, "nl")
  181.         ];
  183.         return new JsonResponse($datas);
  185.     }
  187.     /**
  188.      * @Route("/magasin/{magasin}/widget/store_presentation", name="factory_api_widget_store_presentation")
  189.      * @param Request $request
  190.      * @param Magasin $magasin
  191.      * @return JsonResponse
  192.      */
  193.     public function widgetPresentationMagasin(Request $request, Magasin $magasin)
  194.     {
  195.         if (!$request->query->has('page')) {
  196.             return new JsonResponse(['status' => 400, 'error' => 'Paramètre page manquant'], 400);
  197.         }
  199.         $page = $request->query->get('page');
  200.         $page = $this->entityManager->getRepository(WebfactoryPage::class)->findOneBy(['id' => $page]);
  201.         $pageCustomId = $request->query->get('customPage');
  203.         $config = $this->webfactoryManager->getFactoryConfig($magasin->getKAdherent());
  204.         $opc = $this->webfactoryManager->getAffichageOpc($magasin->getKAdherent());
  205.         ($magasin->getKNIVEAUADH() == "LOL4G") ? $esv = true : $esv = false;
  207.         $theme = $config['offer']['theme']['name'];
  209.         $widget = $this->entityManager->getRepository(WebfactoryWidget::class)->findOneBy(['identifier' => 'store_presentation']);
  211.         try {
  212.             $widgets = $this->entityManager->getRepository(WidgetAbstract::class)->findBy([
  213.                 'magasin' => $magasin->getKAdherent(),
  214.                 'page' => $page->getIdentifier(),
  215.                 'theme' => $theme,
  216.                 'widget' => $widget,
  217.                 'pageCustom' => $pageCustomId
  218.             ]);
  219.         } catch (\Exception $e) {
  220.             return new JsonResponse(['status' => 500, 'error' => $e->getMessage()], 500);
  221.         }
  223.         $datas = [];
  224.         if (!empty($widgets)) {
  226.             foreach ($widgets as $widgetDetail) {
  228.                 $datas[strtolower($widgetDetail->getLang())] =
  229.                     [
  230.                         "title" => $widgetDetail->getTitle(),
  231.                         "baseline" => $widgetDetail->getText(),
  232.                         "button_text" => $widgetDetail->getButtonText(),
  233.                         "button_url" => $widgetDetail->getButtonUrl(),
  234.                         "perso_button_url" => $widgetDetail->getButtonUrlOther(),
  235.                         "hours" => $widgetDetail->getHours(),
  236.                         "images" => [
  238.                         ]
  239.                     ];
  240.                 if ($esv) {
  241.                     $datas[strtolower($widgetDetail->getLang())]['images'][] =
  242.                         [
  243.                             "src" => [
  244.                                 "mobile" => $this->cdnOpc . "images/logo/Expert_Sante_Visuelle-ESV-noir-petit-FR.svg",
  245.                                 "tablette" => $this->cdnOpc . "images/logo/Expert_Sante_Visuelle-ESV-noir-moyen-FR.svg",
  246.                                 "desktop" => $this->cdnOpc . "images/logo/Expert_Sante_Visuelle-ESV-noir-grand-FR.svg"
  247.                             ],
  248.                             "alt" => "Logo du label Expert en santé visuelle",
  249.                             "title" => "Expert en santé visuelle"
  250.                         ];
  253.                 }
  255.                 if ($opc) {
  256.                     $datas[strtolower($widgetDetail->getLang())]['images'][] = [
  257.                         "src" => [
  258.                             "mobile" => $this->cdnOpc . "images/logo/OPC-vert-petit.svg",
  259.                             "tablette" => $this->cdnOpc . "images/logo/OPC-vert-moyen.svg",
  260.                             "desktop" => $this->cdnOpc . "images/logo/OPC-vert-grand.svg",
  261.                         ],
  262.                         "alt" => "Logo Opticiens par conviction",
  263.                         "title" => "Opticiens par conviction"
  264.                     ];
  265.                 }
  266.             }
  268.             return new JsonResponse($datas);
  270.         } else {
  271.             return new JsonResponse(['status' => 400, 'error' => 'Aucun widget pour cette page'], 400);
  272.         }
  274.     }
  276.     /**
  277.      * @Route("/magasin/{magasin}/widget/contact", name="factory_api_widget_contact")
  278.      * @param Request $request
  279.      * @param Magasin $magasin
  280.      * @return void
  281.      */
  282.     public function widgetCoordonnees(Request $request, Magasin $magasin)
  283.     {
  284.         $social_medias = $this->entityManager->getRepository(MagasinUrl::class)->findBy(['magasin' => $magasin]);
  285.         $socials = [];
  286.         $socialsNl = [];
  288.         if (!empty($social_medias)) {
  289.             foreach ($social_medias as $social_media) {
  290.                 if ($social_media->getType() == "facebook" && !is_null($social_media->getUrl())) {
  291.                     $currentSocial = [
  292.                         "url" => $this->forceHttps($social_media->getUrl()),
  293.                         "svg_name" => "facebook",
  294.                         "icon" => file_get_contents($this->getParameter("images_directory") . '/webfactory/svg/facebook.svg'),
  295.                         "type" => "facebook",
  296.                         "title" => "Voir notre compte Facebook"
  297.                     ];
  299.                     $socials[] = $currentSocial;
  300.                     $currentSocial['title'] = "Zie onze Facebook-account";
  301.                     $socialsNl = $currentSocial;
  302.                 }
  304.                 if ($social_media->getType() == "twitter" && !is_null($social_media->getUrl())) {
  305.                     $currentSocial = [
  306.                         "url" => $this->forceHttps($social_media->getUrl()),
  307.                         "svg_name" => "twitter",
  308.                         "icon" => file_get_contents($this->getParameter("images_directory") . '/webfactory/svg/twitter.svg'),
  309.                         "type" => "twitter",
  310.                         "title" => "Voir notre compte Twitter"
  311.                     ];
  313.                     $socials[] = $currentSocial;
  314.                     $currentSocial['title'] = "Zie onze Twitter-account";
  315.                     $socialsNl = $currentSocial;
  316.                 }
  318.                 if ($social_media->getType() == "instagram" && !is_null($social_media->getUrl())) {
  320.                     $currentSocial = [
  321.                         "url" => $this->forceHttps($social_media->getUrl()),
  322.                         "svg_name" => "instagram",
  323.                         "icon" => file_get_contents($this->getParameter("images_directory") . '/webfactory/svg/instagram.svg'),
  324.                         "type" => "instagram",
  325.                         "title" => "Voir notre profil Instagram"
  326.                     ];
  328.                     $socials[] = $currentSocial;
  329.                     $currentSocial['title'] = "Zie onze Instagram-account";
  330.                     $socialsNl = $currentSocial;
  331.                 }
  333.                 if ($social_media->getType() == "tiktok" && !is_null($social_media->getUrl())) {
  335.                     $currentSocial = [
  336.                         "url" => $this->forceHttps($social_media->getUrl()),
  337.                         "svg_name" => "tiktok",
  338.                         "icon" => file_get_contents($this->getParameter("images_directory") . '/webfactory/svg/tiktok.svg'),
  339.                         "type" => "tiktok",
  340.                         "title" => "Voir notre profil TikTok"
  341.                     ];
  343.                     $socials[] = $currentSocial;
  344.                     $currentSocial['title'] = "Zie onze TikTok-account";
  345.                     $socialsNl = $currentSocial;
  346.                 }
  347.             }
  348.         }
  350.         $ficheCoordonnees = $this->entityManager->getRepository(MagasinCoordonnees::class)->findOneBy(
  351.             ['K_ADHERENT' => $magasin->getKAdherent(), 'TYPE' => 'MARKETING']);
  353.         if (empty($ficheCoordonnees)) {
  354.             $ficheCoordonnees = $this->entityManager->getRepository(MagasinCoordonnees::class)->findOneBy(
  355.                 ['K_ADHERENT' => $magasin->getKAdherent(), 'TYPE' => 'MAGASIN']);
  357.             if (empty($ficheCoordonnees)) {
  358.                 $ficheCoordonnees = $this->entityManager->getRepository(MagasinCoordonnees::class)->findOneBy(
  359.                     ['K_ADHERENT' => $magasin->getKAdherent(), 'TYPE' => 'SIEGE']);
  360.             }
  361.         }
  363.         // Mails pour "Envoyer un message"
  364.         $magasinContactsEmails = $this->entityManager->getRepository(MagasinContact::class)->getSpecificContact($magasin, 'site_web_emails_contacts', true, false, true);
  366.         // Numéro de téléphone pour la prise de contact
  367.         $telDeContact = $this->entityManager->getRepository(MagasinContact::class)->getSpecificContact($magasin, 'site_web_tel_contact');
  369.         $urlMagasin = $this->entityManager->getRepository(MagasinUrl::class)->findOneBy(['magasin' => $magasin, 'type' => 'OPC/OZC']);
  370.         $urlRdv = $this->entityManager->getRepository(MagasinUrl::class)->findOneBy(['magasin' => $magasin, 'type' => 'rdv']);
  372.         $contactsFr = [];
  373.         $contactsNl = [];
  375.         if (!is_null($ficheCoordonnees)) {
  376.             // Prise de rdv
  377.             preg_match("/(opticiens-oc.be\/nl\/*)|(:8082)/", $urlMagasin->getUrl(), $matches);
  378.             if (!empty($matches)) {
  379.                 $urlRdvOPC = $urlMagasin->getUrl() . '/maak-een-afspraak';
  380.             } else {
  381.                 $urlRdvOPC = $urlMagasin->getUrl() . '/prise-de-rdv';
  383.             }
  385.             $priseRdv = [
  386.                 "title" => "Prendre RDV",
  387.                 "svg_name" => "calendar-time",
  388.                 "icon" => file_get_contents($this->getParameter("images_directory") . '/webfactory/svg/calendar-week.svg'),
  389.                 "content" => null,
  390.                 "button_text" => "Prendre RDV",
  391.                 "link" => (!is_null($urlRdv)) ? $urlRdv->getUrl() : $urlRdvOPC,
  392.                 "target" => "_blank",
  393.                 "type" => "rdv",
  394.                 'rel' => 'nofollow'
  395.             ];
  397.             $contactsFr[] = $priseRdv;
  398.             $priseRdv['title'] = "Afspraak";
  399.             $priseRdv['button_text'] = "Lees meer";
  400.             $contactsNl[] = $priseRdv;
  403.             //Y aller
  404.             $destination = urlencode(strtolower($ficheCoordonnees->getLib() . " " . trim($ficheCoordonnees->getVOIENUM() . ' ' . $ficheCoordonnees->getVOIETYPE() . ' ' . $ficheCoordonnees->getVOIELIB()) . "," . $ficheCoordonnees->getKCP() . "," . $ficheCoordonnees->getKVILLE()));
  406.             $urlYAller = "https://www.google.com/maps/dir/?api=1&destination=" . $destination . "&travelmode=driving";
  408.             $voieCplt = (!is_null($ficheCoordonnees->getVOIECPLT())) ? $ficheCoordonnees->getVOIECPLT() : "";
  409.             $content = $ficheCoordonnees->getVOIENUM() . " " . $voieCplt . " " . $ficheCoordonnees->getVOIETYPE() . " " . $ficheCoordonnees->getVOIELIB() . "<br>" . $ficheCoordonnees->getKCP() . " " . $ficheCoordonnees->getKVILLE();
  411.             $yAller = [
  412.                 "title" => "S'y rendre",
  413.                 "svg_name" => "location",
  414.                 "icon" => file_get_contents($this->getParameter("images_directory") . '/webfactory/svg/geo-alt.svg'),
  415.                 "content" => $content,
  416.                 "button_text" => "S'y rendre",
  417.                 "link" => $urlYAller,
  418.                 "target" => "_blank",
  419.                 "type" => "location",
  420.                 "street" => $ficheCoordonnees->getVOIENUM() . " " . $ficheCoordonnees->getVOIETYPE() . " " . $ficheCoordonnees->getVOIELIB(),
  421.                 "zipcode" => $ficheCoordonnees->getKCP(),
  422.                 "city" => $ficheCoordonnees->getKVILLE(),
  423.                 "country" => $ficheCoordonnees->getKPAYS(),
  424.                 "lib" => $ficheCoordonnees->getLib()
  425.             ];
  426.             $contactsFr[] = $yAller;
  427.             $yAller['title'] = "Route";
  428.             $yAller['button_text'] = "Lees meer";
  429.             $contactsNl[] = $yAller;
  431.             // Appeler
  432.             if (!is_null($telDeContact)) {
  434.                 $indicatifs = ['+33', '+32', '+590', '+596', '+262', '+377'];
  437.                 foreach ($indicatifs as $indicatif) {
  438.                     if (str_starts_with($telDeContact->getValue(), $indicatif)) {
  439.                         $telDeContactVisible = substr($telDeContact->getValue(), strlen($indicatif));
  441.                         // clear
  442.                         $telDeContactVisible = preg_replace('/\D/', '', $telDeContactVisible);
  444.                         if ($telDeContactVisible[0] !== '0') {
  445.                             $telDeContactVisible = '0' . $telDeContactVisible;
  446.                         }
  447.                         break;
  448.                     }
  449.                 }
  450.                 // formatage espace entre 2
  451.                 $telDeContactVisible = trim(chunk_split($telDeContactVisible, 2, ' '));
  453.                 $appeler = [
  454.                     "title" => "Appeler",
  455.                     "svg_name" => "phone",
  456.                     "icon" => file_get_contents($this->getParameter("images_directory") . '/webfactory/svg/telephone-fill.svg'),
  457.                     "content" => $telDeContactVisible,
  458.                     "button_text" => $telDeContactVisible,
  459.                     "link" => "tel:" . str_replace(" ", "", $telDeContact->getValue()),
  460.                     "target" => null,
  461.                     "type" => "phone"
  462.                 ];
  464.                 $contactsFr[] = $appeler;
  465.                 $appeler['title'] = "Bel";
  466.                 $appeler['button_text'] = $telDeContactVisible;
  467.                 $contactsNl[] = $appeler;
  468.             }
  470.             // Mail
  471.             if (!empty($magasinContactsEmails)) {
  472.                 $mails = $magasinContactsEmails;
  474.                 $envoieMail = [
  475.                     "title" => "Envoyer un e-mail",
  476.                     "svg_name" => "mail",
  477.                     "icon" => file_get_contents($this->getParameter("images_directory") . '/webfactory/svg/send.svg'),
  478.                     "content" => $mails,
  479.                     "button_text" => "Nous contacter",
  480. //                    "link" => "mailto:" . rtrim($mails, ";"),
  481.                     "link" => "/contact",
  482.                     "target" => null,
  483.                     "type" => "mail"
  484.                 ];
  486.                 $contactsFr[] = $envoieMail;
  487.                 $envoieMail['title'] = "Stuur een e-mail";
  488.                 $envoieMail['button_text'] = "Neem contact op";
  489.                 $contactsNl[] = $envoieMail;
  490.             }
  492.         }
  494.         $contact_fr = [
  495.             "title" => "Contactez-nous",
  496.             "svg_name" => "clock",
  497.             "icon" => file_get_contents($this->getParameter("images_directory") . '/webfactory/svg/clock.svg'),
  498.             "contacts" => $contactsFr,
  499.             'socials' => $socials
  500.         ];
  502.         $contact_nl = [
  503.             "title" => "Neem contact op",
  504.             "svg_name" => "clock",
  505.             "icon" => "<svg width='18' height='20' viewBox='0 0 18 20'><path d='M15,2h0V0H13V2H5V0H3V2H3A3,3,0,0,0,0,5V17a3,3,0,0,0,3,3H15a3,3,0,0,0,3-3V5A3,3,0,0,0,15,2Zm1,14.83a1,1,0,0,1-1,1H3a1,1,0,0,1-1-1v-10a1,1,0,0,1,1-1H15a1,1,0,0,1,1,1Z'/></svg>",
  506.             "contacts" => $contactsNl,
  507.             'socials' => $socialsNl
  508.         ];
  510.         $datas = [
  511.             'fr' => $contact_fr,
  512.             'nl' => $contact_nl
  513.         ];
  515.         return new JsonResponse($datas);
  516.     }
  518.     /**
  519.      * @Route("/magasin/{magasin}/widget/social_networks", name="factory_api_widget_social_networks")
  520.      * @param Request $request
  521.      * @param Magasin $magasin
  522.      * @return void
  523.      */
  524.     public function widgetSocialNetwork(Request $request, Magasin $magasin)
  525.     {
  526.         $social_medias = $this->entityManager->getRepository(MagasinUrl::class)->findBy(['magasin' => $magasin]);
  527.         $socials = [];
  528.         $socialsNl = [];
  530.         $allowTypes = ['facebook', 'twitter', 'instagram', 'youtube', 'linkedin', 'whatsapp', 'tiktok'];
  532.         if (!empty($social_medias)) {
  533.             foreach ($social_medias as $social_media) {
  535.                 if (in_array($social_media->getType(), $allowTypes) && !is_null($social_media->getUrl())) {
  536.                     $currentSocial = [
  537.                         "url" => $this->forceHttps($social_media->getUrl()),
  538.                         "svg_name" => strtolower($social_media->getType()),
  539.                         "icon" => file_get_contents($this->getParameter("images_directory") . '/webfactory/svg/' . strtolower($social_media->getType()) . '.svg'),
  540.                         "type" => strtolower($social_media->getType()),
  541.                         "title" => "Voir notre compte " . ucfirst($social_media->getType()),
  542.                     ];
  544.                     $socials[] = $currentSocial;
  545.                     $currentSocial['title'] = "Zie onze " . ucfirst($social_media->getType()) . "-account";
  546.                     $socialsNl[] = $currentSocial;
  547.                 }
  549.             }
  550.         }
  552.         $contact_fr = [
  553.             'socials' => $socials
  554.         ];
  556.         $contact_nl = [
  557.             'socials' => $socialsNl
  558.         ];
  560.         $datas = [
  561.             'fr' => $contact_fr,
  562.             'nl' => $contact_nl
  563.         ];
  565.         return new JsonResponse($datas);
  566.     }
  568.     /**
  569.      * @Route("/magasin/{magasin}/widget/brands", name="factory_api_widget_brands")
  570.      * @param Request $request
  571.      * @param Magasin $magasin
  572.      * @return void
  573.      */
  574.     public function widgetMarques(Request $request, Magasin $magasin)
  575.     {
  576.         $config = $this->webfactoryManager->getFactoryConfig($magasin->getKAdherent());
  577.         $theme = $config['offer']['theme']['name'];
  579.         $entityName = "App\Entity\Webfactory\\Widget\\" . $theme . "\\Brands";
  581.         $widgets = $this->entityManager->getRepository($entityName)->findBy(['magasin' => $magasin]);
  583.         $brands = [
  584.             'fr' => ['widget' => [], 'categories' => [], 'total' => 0],
  585.             'nl' => ['widget' => [], 'categories' => [], 'total' => 0]
  586.         ];
  588.         if (!empty($widgets)) {
  590.             foreach ($widgets as $widget) {
  591.                 $brands[strtolower($widget->getLang())] = [
  592.                     "widget" => [
  593.                         "title" => $widget->getTitle(),
  594.                         "description" => $widget->getDescription(),
  595.                         "image" => $this->urlPhotosAdh . $magasin->getKAdherent() . '/' . $widget->getImage(),
  596.                         "button" => $widget->getButton()
  597.                     ],
  598.                     "categories" => [],
  599.                     "total" => 0
  600.                 ];
  601.             }
  602.         }
  603.         return new JsonResponse($brands);
  604.     }
  606.     /**
  607.      * @Route("/magasin/{magasin}/widget/list-brands", name="factory_api_widget_list_marques")
  608.      * @param Request $request
  609.      * @param Magasin $magasin
  610.      * @return JsonResponse
  611.      */
  612.     public function widgetListMarques(Request $request, Magasin $magasin): JsonResponse
  613.     {
  614.         //     ?limit=9&page=0
  615.         $limit = ($request->query->has('limit')) ? intval($request->query->get('limit')) : 100;
  616.         $page = ($request->query->has('page')) ? intval($request->query->get('page')) : 1;
  618.         if ($page <= 1) {
  619.             $offset = 0;
  620.         } else {
  621.             $offset = $page * $limit - $limit;
  622.         }
  624.         $config = $this->webfactoryManager->getFactoryConfig($magasin->getKAdherent());
  625.         $theme = $config['offer']['theme']['name'];
  627.         $entityName = "App\Entity\Webfactory\\Widget\\" . $theme . "\\Brands";
  629.         $widgets = $this->entityManager->getRepository($entityName)->findBy(['magasin' => $magasin]);
  631.         $finalTab = [];
  633.         if (!empty($widgets)) {
  635.             foreach ($widgets as $widget) {
  637.                 $finalTab[strtolower($widget->getLang())] = [
  638.                     "title" => $widget->getTitle(),
  639.                     "description" => $widget->getDescription(),
  640.                     "bouton_text" => $widget->getButton(),
  641.                     "url" => (strtolower($widget->getLang()) == "nl") ? '/merken' : '/marques',
  642.                     'list' => []
  643.                 ];
  645.                 $listBrands = $widget->getListBrands();
  647.                 $criteria = Criteria::create()->where(Criteria::expr()->in("id", array_slice($listBrands, $offset, $limit)));
  648.                 $magMarques = $this->entityManager->getRepository(MagasinMarques::class)->matching($criteria)->getValues();
  650.                 $tabListBrands = $this->marquesManager->formatTabListBrandsApi($magMarques);
  652.                 $finalTab[strtolower($widget->getLang())]['list'] = $tabListBrands[strtolower($widget->getLang())]['list'];
  653.             }
  655.         }
  657.         return new JsonResponse($finalTab);
  658.     }
  660.     /**
  661.      * @Route("/magasin/{magasin}/widget/deals", name="factory_api_widget_deals")
  662.      * @param Request $request
  663.      * @param Magasin $magasin
  664.      * @return JsonResponse
  665.      */
  666.     public function widgetDeals(Request $request, Magasin $magasin)
  667.     {
  668.         $date = new \DateTime('now');
  669.         $year = $date->format('Y');
  670.         $previousYear = $date->sub(new \DateInterval("P1Y"));
  671.         $prev_year = $previousYear->format("Y");
  672.         $anneeLimitTraitement = $year - 2;
  674.         $offres_inscription = $this->entityManager->getRepository(OffreInscription::class)->findBy(['adherent' => $magasin->getKAdherent(), 'tag' => [$year, $prev_year]]);
  676.         $address = $this->entityManager->getRepository(MagasinCoordonnees::class)->findOneBy([
  677.             'K_ADHERENT' => $magasin->getKAdherent(),
  678.             'TYPE' => 'MAGASIN'
  679.         ]);
  680.         if (empty($address)) {
  681.             $address = $this->entityManager->getRepository(MagasinCoordonnees::class)->findOneBy(['K_ADHERENT' => $magasin->getKAdherent(), 'TYPE' => 'SIEGE']);
  682.         }
  684.         $details['deals'] = [];
  685.         if (!empty($offres_inscription)) {
  686.             foreach ($offres_inscription as $inscription) {
  687.                 if (substr($inscription->getTag(), 0, 4) > $anneeLimitTraitement) {
  688.                     $list_insc = json_decode($inscription->getOffres());
  690.                     foreach ($list_insc as $insc) {
  692.                         $offre = $this->entityManager->getRepository(OffreWeb::class)->findOneBy(['code' => $insc]);
  694.                         $debut = $offre->getDateDebut();
  695.                         $fin = $offre->getDateFin();
  696.                         $tag = substr($offre->getTag(), 0, 4);
  698.                         if (date("Y-m-d h:m:s") >= $debut->format('Y-m-d h:m:s') && date("Y-m-d h:m:s") <= $fin->format('Y-m-d h:m:s')) {
  700.                             $infosOffre = [
  701.                                 "src" => $this->getParameter("twicpics_domain_images_OPC") . "offres-web/" . $tag . "/640x338/" . $offre->getPays() . "/" . $offre->getFileEmail(),
  702.                                 "alt" => $offre->getTexte(),
  703.                                 "title" => $offre->getTexte(),
  704.                                 "slug_title" => $offre->getName(),
  705.                                 "url" => $this->opcManager->getAdhOpcUrl($address),
  706.                                 "legals" => $offre->getMentions(),
  707.                                 "type" => $offre->getType() == 'P' ? 'headline' : 'season',
  708.                                 "uid" => $offre->getTag() . $insc,
  709.                                 "year" => $offre->getTag(),
  710.                                 "seo" => [
  711.                                     "title" => ucfirst(strtolower($magasin->getLib())) . " - " . $offre->getName(),
  712.                                     "description" => $offre->getTexte(),
  713.                                     "keywords" => ""
  714.                                 ],
  715.                                 'rel' => 'nofollow'
  716.                             ];
  718.                             if ($offre->getType() === "S") {
  719.                                 $details['current'][] = $infosOffre;
  720.                             } else {
  721.                                 $details['deals'][] = $infosOffre;
  722.                             }
  724.                         }
  726.                     }
  727.                 }
  728.             }
  729.         }
  731.         $dealsYear = [
  732.             "title" => "Découvrez nos offres",
  733.             "subtitle" => "valables toute l'année",
  734.             "button_text" => "Voir nos bons plans",
  735.             "button_url" => $this->opcManager->getAdhOpcUrl($address),
  736.             "deals" => $details['deals']
  737.         ];
  739.         $dealCurrent = [
  740.             "title" => "Découvrez notre offre",
  741.             "subtitle" => "du moment",
  742.             "button_text" => "Voir nos bons plans",
  743.             "button_url" => $this->opcManager->getAdhOpcUrl($address),
  744.             "deal" => (array_key_exists('current', $details)) ? $details['current'] : []
  745.         ];
  747.         $datas = [
  748.             'fr' => [
  749.                 'current' => (array_key_exists('current', $details)) ? $dealCurrent : [],
  750.                 'year' => (!empty($details['deals'])) ? $dealsYear : [],
  751.                 'slug' => "offres",
  752.                 'slug_translated' => 'deals',
  753.             ],
  754.             'nl' => [
  755.                 'current' => (array_key_exists('current', $details)) ? $dealCurrent : [],
  756.                 'year' => (!empty($details['deals'])) ? $dealsYear : [],
  757.                 'slug' => "deals",
  758.                 'slug_translated' => 'offres',
  759.             ]
  760.         ];
  762.         return new JsonResponse($datas);
  763.     }
  765.     /**
  766.      * @Route("/magasin/{magasin}/widget/teams", name="factory_api_widget_teams")
  767.      * @param Request $request
  768.      * @param Magasin $magasin
  769.      * @return void
  770.      */
  771.     public function widgetTeams(Request $request, Magasin $magasin)
  772.     {
  773.         $datas = [
  774.             'fr' => [],
  775.             'nl' => []
  776.         ];
  778.         $config = $this->webfactoryManager->getFactoryConfig($magasin->getKAdherent());
  779.         $theme = $config['offer']['theme']['name'];
  781.         $entityName = "App\Entity\Webfactory\\Widget\\" . $theme . "\\Teams";
  783.         $widgetTeams = $this->entityManager->getRepository($entityName)->findBy(['magasin' => $magasin->getKAdherent()]);
  784.         $magasinEquipe = $this->entityManager->getRepository(MagasinEquipe::class)->findOneBy(['magasin' => $magasin->getKAdherent()]);
  786.         if (!empty($widgetTeams)) {
  787.             foreach ($widgetTeams as $widgetTeam) {
  789.                 $verbatim = [
  790.                     "quote" => "",
  791.                     "from" => ""
  792.                 ];
  794.                 if (!is_null($magasinEquipe)) {
  795.                     if (strtolower($widgetTeam->getLang()) === "fr") {
  796.                         $verbatim["quote"] = $magasinEquipe->getVerbatim();
  797.                         $verbatim["from"] = "L'équipe " . ucfirst(strtolower($magasin->getLib()));
  798.                     } else {
  799.                         $verbatim["quote"] = $magasinEquipe->getVerbatimNl();
  800.                         $verbatim["from"] = "Het " . ucfirst(strtolower($magasin->getLib())) . " team";
  801.                     }
  802.                 }
  804.                 $widget = [
  805.                     "title" => $widgetTeam->getEquipeTitre(),
  806.                     "description" => $widgetTeam->getEquipeDescription(),
  807.                     "button_text" => $widgetTeam->getButtonText(),
  808.                     "verbatim" => $verbatim
  809.                 ];
  811.                 $detail = [
  812.                     "image" => [
  813.                         [
  814.                             "media" => [
  815.                                 "mobile" => (!is_null($magasinEquipe)) ? $this->urlPhotosAdh . $magasin->getKAdherent() . "/" . $magasinEquipe->getPhotoEquipe() : "",
  816.                                 "desktop" => (!is_null($magasinEquipe)) ? $this->urlPhotosAdh . $magasin->getKAdherent() . "/" . $magasinEquipe->getPhotoEquipe() : "",
  817.                             ],
  818.                             "alt" => "",
  819.                             "title" => ""
  820.                         ]
  821.                     ],
  822.                     "title" => "",
  823.                     "description" => "",
  824.                     "seo" => [
  825.                         "title" => "",
  826.                         "description" => "",
  827.                         "keywords" => ""
  828.                     ]
  829.                 ];
  831.                 $teams = [];
  832.                 $arrayIdCollabo = $widgetTeam->getEquipeList();
  833.                 $collaborateurs = $this->entityManager->getRepository(MagasinCollaborateurs::class)->findByArrayId($arrayIdCollabo);
  835.                 foreach ($collaborateurs as $collaborateur) {
  836.                     $teams[] = [
  837.                         "image" => [
  838.                             "small" => (!is_null($collaborateur->getImage())) ? $this->urlPhotosAdh . $magasin->getKAdherent() . "/" . $collaborateur->getImage() : $this->cdnOpc . 'webfactory/default/' . FactoryEnum::ProfileImage,
  839.                             "big" => (!is_null($collaborateur->getImage())) ? $this->urlPhotosAdh . $magasin->getKAdherent() . "/" . $collaborateur->getImage() : $this->cdnOpc . 'webfactory/default/' . FactoryEnum::ProfileImage
  840.                         ],
  841.                         "alt" => $collaborateur->getImage(),
  842.                         "title" => $collaborateur->getImage(),
  843.                         "name" => $collaborateur->getLastName(),
  844.                         "firstname" => $collaborateur->getFirstName(),
  845.                         "job" => (strtolower($widgetTeam->getLang()) === "fr") ? $collaborateur->getJobs() : $collaborateur->getJobsNl(),
  846.                         "skills" => (strtolower($widgetTeam->getLang()) === "fr") ? $collaborateur->getSpecialties() : $collaborateur->getSpecialtiesNl(),
  847.                         "presentation" => (strtolower($widgetTeam->getLang()) === "fr") ? $collaborateur->getPresentation() : $collaborateur->getPresentationNl(),
  848.                         "verbatim" => (strtolower($widgetTeam->getLang()) === "fr") ? $collaborateur->getVerbatim() : $collaborateur->getVerbatimNl()
  849.                     ];
  850.                 }
  852.                 $team = [
  853.                     'widget' => $widget,
  854.                     "details" => $detail,
  855.                     "teams" => $teams
  856.                 ];
  858.                 (strtolower($widgetTeam->getLang()) === "fr") ? $datas['fr'][] = $team : $datas['nl'][] = $team;
  860.             }
  861.         }
  863.         return new JsonResponse($datas);
  864.     }
  866.     /**
  867.      * @Route("/magasin/{magasin}/widget/crm_reviews", name="factory_api_widget_crm_reviews")
  868.      * @Route("/magasin/{magasin}/page/reviews_detail", name="factory_api_page_reviews_detail")
  869.      * @param Request $request
  870.      * @param Magasin $magasin
  871.      * @return void
  872.      * @throws \Exception
  873.      */
  874.     public function widgetCrmReviews(Request $request, Magasin $magasin)
  875.     {
  877.         $queryParams = $request->query->all();
  878.         $limit = (!empty($queryParams && array_key_exists('limit', $queryParams))) ? intval($queryParams['limit']) : 3;
  879.         $offset = (!empty($queryParams && array_key_exists('offset', $queryParams))) ? intval($queryParams['offset']) : 0;
  882.         // Vérification si adhérent a le CRM ou des avis GMB
  883.         $CRM_infos = $this->crmAccessManager->checkAccessCrm($magasin->getKAdherent(), null);
  884.         $avisGmb = $magasin->isAvisGmbActive();
  886.         $data['statutAvisGMB'] = false;
  888.         $listAvis = [];
  889.         $noteAvis = [];
  891.         if ($avisGmb) {
  892.             $data['statutAvisGMB'] = true;
  893.         }
  895.         if ($magasin->getKAdherent() == "C9920") {
  896.             $CRM_infos["access"] = true;
  897.             $CRM_infos["avis_crm"] = true;
  898.         }
  901.         // Contrat CRM valide, a des avis et souhaite les afficher
  902.         if ($CRM_infos['access'] && $CRM_infos['avis_crm']) {
  904.             $query = (new QueryProgress("quest_ach_indiv"))
  905.                 ->where('K_QUEST', '=', 'SAT')
  906.                 ->andWhere("K_ADHERENT", '=', ($magasin->getKAdherent() == "C9920") ? "C3571" : $magasin->getKAdherent())
  907.                 ->orderBy('D_CREE', 'DESC')
  908.                 ->limit(0, 5000);
  910.             $allAvis = $this->rcuManager->findAvis($query);
  912.             foreach ($allAvis as &$data) {
  913.                 // Traitement du tableau QUEST_L
  914.                 $quest = [];
  915.                 if ($data['QUEST_L']) {
  917.                     foreach ($data['QUEST_L'] as $quest_l) {
  918.                         $quest[$quest_l["K_QUEST_L"]] = ['val' => $quest_l['VAL'], 'date' => $quest_l['D_CREE']];
  919.                     }
  921.                     $data['QUEST_L'] = $quest;
  922.                     // Gestion des variables réutilisables
  923.                     $commentaire = (isset($data['QUEST_L']['experience_opticien_commentaire']['val'])) ? addslashes($data['QUEST_L']['experience_opticien_commentaire']['val']) : "";
  924.                     $reponse = (isset($data['QUEST_L']['experience_opticien_commentaire_rep']['val'])) ? addslashes($data['QUEST_L']['experience_opticien_commentaire_rep']['val']) : "";
  926.                     $d_cree = new \DateTime($data['D_CREE']);
  927.                     $now = new \DateTime('2021-04-27');
  928.                     $autoPublicationDate = new \DateTime('2024-02-20');
  930.                     // Application des CGU le 27/04/2021
  931.                     // Avant le 27/04
  932.                     if ($d_cree->getTimestamp() < $now->getTimestamp()) {
  933.                         //On crée le tableau que si l'avis peut être publié
  934.                         if (isset($data['QUEST_L']['publication_avis']['val']) && $data['QUEST_L']['publication_avis']['val'] == 1 && !isset($data['QUEST_L']['publication_OPC']['val'])) {
  936.                             $listAvis[] = [
  937.                                 "name" => $data['PRENOM'] . " " . $data['NOM'][0],
  938.                                 "fr" => $commentaire,
  939.                                 "nl" => $commentaire,
  940.                                 "lang" => "fr",
  941.                                 "rating" => $data['QUEST_L']['experience_opticien']['val'],
  942.                                 "answer" => $reponse,
  943.                                 "date" => $data['D_CREE'],
  944.                                 "origin" => "Groupe All"
  945.                             ];
  946.                         }
  948.                     } else {
  950.                         // A partir du 20/02/2024 les avis sont publiés automatiquement
  951.                         //On crée le tableau que si l'avis peut être publié en acceptant les CGU
  952.                         if (
  953.                             (isset($data['QUEST_L']['cgu']['val']) &&
  954.                                 (isset($data['QUEST_L']['publication_avis']['val']) &&
  955.                                     $data['QUEST_L']['publication_avis']['val'] == "1") &&
  956.                                 ($data['QUEST_L']['cgu']['val'] == 'yes' || $data['QUEST_L']['cgu']['val'] == '1') &&
  957.                                 !isset($data['QUEST_L']['publication_OPC']['val']))
  958.                             || $d_cree->getTimestamp() >= $autoPublicationDate->getTimestamp()
  959.                         ) {
  961.                             $listAvis[] = [
  962.                                 "name" => $data['PRENOM'] . " " . $data['NOM'][0],
  963.                                 "fr" => $commentaire,
  964.                                 "nl" => $commentaire,
  965.                                 "lang" => "fr",
  966.                                 "rating" => (int)$data['QUEST_L']['experience_opticien']['val'],
  967.                                 "answer" => $reponse,
  968.                                 "date" => $data['D_CREE'],
  969.                                 "origin" => "Groupe All"
  970.                             ];
  972.                         }
  973.                     }
  974.                 }
  975.             }
  977.         }
  979.         if (!empty($listAvis)) {
  980.             //Somme des notes de l'adhérent
  981.             $notes = 0;
  982.             foreach ($listAvis as $k => $v) {
  983.                 $notes += $v['rating'];
  984.             }
  986.             $noteAvis['total'] = count($listAvis);
  987.             $noteAvis['note'] = floor($notes / count($listAvis) * 10) / 10;
  989.             $noteAvis['detail']['five'] = $this->filtersReviewsHelper->countStarsReview($listAvis, 5);
  990.             $noteAvis['detail']['four'] = $this->filtersReviewsHelper->countStarsReview($listAvis, 4);
  991.             $noteAvis['detail']['three'] = $this->filtersReviewsHelper->countStarsReview($listAvis, 3);
  992.             $noteAvis['detail']['two'] = $this->filtersReviewsHelper->countStarsReview($listAvis, 2);
  993.             $noteAvis['detail']['one'] = $this->filtersReviewsHelper->countStarsReview($listAvis, 1);
  994.         }
  996.         $rating = [
  997.             "total_rating" => $noteAvis ? $noteAvis['total'] : null,
  998.             "average_rating" => $noteAvis ? $noteAvis['note'] : null,
  999.             'detailed_rating' => $noteAvis ? $noteAvis['detail'] : null,
  1000.             "ratings" => $listAvis,
  1001.             "limited_ratings" => $limit ? array_slice($listAvis, $offset, $limit) : null,
  1002.             "image" => $this->cdnOpc . "webfactory/pages/Details-avis.png",
  1003.             "lang" => [
  1004.                 "fr" => [
  1005.                     "title" => "Découvrez",
  1006.                     "subtitle" => "nos avis clients"
  1007.                 ],
  1008.                 "nl" => [
  1009.                     "title" => "Ontdek",
  1010.                     "subtitle" => "onze klantenbeoordelingen"
  1011.                 ]
  1012.             ]
  1013.         ];
  1015.         return new JsonResponse($rating);
  1016.     }
  1018.     /**
  1019.      * @Route("/magasin/{magasin}/widget/crm_reviews_by_note", name="factory_api_widget_crm_reviews_by_note")
  1020.      * @param Request $request
  1021.      * @param Magasin $magasin
  1022.      * @return void
  1023.      * @throws \Exception
  1024.      */
  1025.     public function widgetCrmReviewsByNote(Request $request, Magasin $magasin)
  1026.     {
  1028.         $queryParams = $request->query->all();
  1029.         $note = intval($queryParams['note']);
  1030.         $limit = (!empty($queryParams && array_key_exists('limit', $queryParams))) ? intval($queryParams['limit']) : null;
  1031.         $offset = (!empty($queryParams && array_key_exists('offset', $queryParams))) ? intval($queryParams['offset']) : 0;
  1034.         // Vérification si adhérent a le CRM ou des avis GMB
  1035.         $CRM_infos = $this->crmAccessManager->checkAccessCrm($magasin->getKAdherent(), null);
  1036.         $avisGmb = $magasin->isAvisGmbActive();
  1038.         $data['statutAvisGMB'] = false;
  1040.         $listAvis = [];
  1041.         $noteAvis = [];
  1043.         if ($avisGmb) {
  1044.             $data['statutAvisGMB'] = true;
  1045.         }
  1047.         if ($magasin->getKAdherent() == "C9920") {
  1048.             $CRM_infos["access"] = true;
  1049.             $CRM_infos["avis_crm"] = true;
  1050.         }
  1053.         // Contrat CRM valide, a des avis et souhaite les afficher
  1054.         if ($CRM_infos['access'] && $CRM_infos['avis_crm']) {
  1056.             $query = (new QueryProgress("quest_ach_indiv"))
  1057.                 ->where('K_QUEST', '=', 'SAT')
  1058.                 ->andWhere("K_ADHERENT", '=', ($magasin->getKAdherent() == "C9920") ? "C3571" : $magasin->getKAdherent())
  1059.                 ->orderBy('D_CREE', 'DESC')
  1060.                 ->limit(0, 5000);
  1062.             $allAvis = $this->rcuManager->findAvis($query);
  1064.             foreach ($allAvis as &$data) {
  1065.                 // Traitement du tableau QUEST_L
  1066.                 $quest = [];
  1067.                 if ($data['QUEST_L']) {
  1069.                     foreach ($data['QUEST_L'] as $quest_l) {
  1070.                         $quest[$quest_l["K_QUEST_L"]] = ['val' => $quest_l['VAL'], 'date' => $quest_l['D_CREE']];
  1071.                     }
  1073.                     $data['QUEST_L'] = $quest;
  1074.                     // Gestion des variables réutilisables
  1075.                     $commentaire = (isset($data['QUEST_L']['experience_opticien_commentaire']['val'])) ? addslashes($data['QUEST_L']['experience_opticien_commentaire']['val']) : "";
  1077.                     $d_cree = new \DateTime($data['D_CREE']);
  1078.                     $now = new \DateTime('2021-04-27');
  1079.                     $autoPublicationDate = new \DateTime('2024-02-20');
  1081.                     // Application des CGU le 27/04/2021
  1082.                     // Avant le 27/04
  1083.                     if ($d_cree->getTimestamp() < $now->getTimestamp()) {
  1084.                         //On crée le tableau que si l'avis peut être publié
  1085.                         if (isset($data['QUEST_L']['publication_avis']['val']) && $data['QUEST_L']['publication_avis']['val'] == 1 && !isset($data['QUEST_L']['publication_OPC']['val'])) {
  1086.                             if ($note == $data['QUEST_L']['experience_opticien']['val']) {
  1087.                                 $listAvis[] = [
  1088.                                     "name" => $data['PRENOM'] . " " . $data['NOM'][0],
  1089.                                     "fr" => $commentaire,
  1090.                                     "nl" => $commentaire,
  1091.                                     "lang" => "fr",
  1092.                                     "rating" => $data['QUEST_L']['experience_opticien']['val'],
  1093.                                     "date" => $data['D_CREE'],
  1094.                                     "origin" => "Groupe All"
  1095.                                 ];
  1096.                             }
  1097.                         }
  1099.                     } else {
  1101.                         // A partir du 20/02/2024 les avis sont publiés automatiquement
  1102.                         //On crée le tableau que si l'avis peut être publié en acceptant les CGU
  1103.                         if (
  1104.                             (isset($data['QUEST_L']['cgu']['val']) &&
  1105.                                 (isset($data['QUEST_L']['publication_avis']['val']) &&
  1106.                                     $data['QUEST_L']['publication_avis']['val'] == "1") &&
  1107.                                 ($data['QUEST_L']['cgu']['val'] == 'yes' || $data['QUEST_L']['cgu']['val'] == '1') &&
  1108.                                 !isset($data['QUEST_L']['publication_OPC']['val']))
  1109.                             || $d_cree->getTimestamp() >= $autoPublicationDate->getTimestamp()
  1110.                         ) {
  1111.                             if ($note == $data['QUEST_L']['experience_opticien']['val']) {
  1113.                                 $listAvis[] = [
  1114.                                     "name" => $data['PRENOM'] . " " . $data['NOM'][0],
  1115.                                     "fr" => $commentaire,
  1116.                                     "nl" => $commentaire,
  1117.                                     "lang" => "fr",
  1118.                                     "rating" => (int)$data['QUEST_L']['experience_opticien']['val'],
  1119.                                     "date" => $data['D_CREE'],
  1120.                                     "origin" => "Groupe All"
  1121.                                 ];
  1123.                             }
  1124.                         }
  1125.                     }
  1126.                 }
  1127.             }
  1130.         }
  1132.         $rating = [
  1133.             "ratings" => $listAvis,
  1134.             "limited_ratings" => $limit ? array_slice($listAvis, $offset, $limit) : null,
  1135.             "nb_notes" => count($listAvis),
  1136.             "lang" => [
  1137.                 "fr" => [
  1138.                     "title" => "Découvrez",
  1139.                     "subtitle" => "Nos avis clients"
  1140.                 ],
  1141.                 "nl" => [
  1142.                     "title" => "Ontdek",
  1143.                     "subtitle" => "Onze klantenbeoordelingen"
  1144.                 ]
  1145.             ]
  1146.         ];
  1148.         return new JsonResponse($rating);
  1149.     }
  1151.     /**
  1152.      * @Route("/magasin/{magasin}/widget/news", name="factory_api_widget_news")
  1153.      * @param Request $request
  1154.      * @param Magasin $magasin
  1155.      * @return void
  1156.      */
  1157.     public function widgetNews(Request $request, Magasin $magasin)
  1158.     {
  1159.         $queryParams = $request->query->all();
  1160.         $limit = (!empty($queryParams && array_key_exists('limit', $queryParams))) ? intval($queryParams['limit']) : 4;
  1161.         $page = (!empty($queryParams && array_key_exists('page', $queryParams))) ? intval($queryParams['page']) : 0;
  1162.         $categoryiD = (!empty($queryParams && array_key_exists('category', $queryParams))) ? intval($queryParams['category']) : null;
  1163.         $lang = (!empty($queryParams && array_key_exists('lang', $queryParams))) ? strtolower($queryParams['lang']) : 'fr';
  1165.         $offset = ($page > 1) ? ($page * $limit - $limit) : 0;
  1166.         $articles = [];
  1167.         if (!is_null($categoryiD) && $categoryiD != 0) {
  1168.             $category = $this->entityManager->getRepository(WebfactoryActualiteCategory::class)->findOneBy(['id' => $categoryiD]);
  1169.             if (!is_null($category)) {
  1170.                 $dataArticles = $this->entityManager->getRepository(WebfactoryActualite::class)->paginateArticlesByCategory($magasin, $offset, $limit, $category->getId(), $lang);
  1171.             } else {
  1172.                 return new JsonResponse('Catégorie inconnue');
  1173.             }
  1174.         } else {
  1175.             $datas = $this->entityManager->getRepository(WebfactoryActualite::class)->findBy(['adherent' => $magasin->getKAdherent(), 'active' => true], ['updated_at' => 'DESC'], $limit, $offset);
  1176.             $dataArticles['articles'] = $datas;
  1177.         }
  1179.         foreach ($dataArticles['articles'] as $article) {
  1180.             foreach ($article->getWebfactoryActualiteContenus() as $contenu) {
  1181.                 if ($contenu->getStatut() != "brouillon"
  1182.                     && (
  1183.                         (is_null($contenu->getDateDebutpublication()) && is_null($contenu->getDateFinPublication()))
  1184.                         || ($contenu->getDateDebutpublication() <= new \DateTime('today'))
  1185.                         || ($contenu->getDateDebutpublication() <= new \DateTime('today') && $contenu->getDateFinPublication() >= new \DateTime('today'))
  1186.                     )
  1187.                 ) {
  1188.                     $categoryContenu = $article->getActualiteCategory()?->getContenuByLang($lang);
  1189.                     $articles[strtolower($contenu->getLang())][] = [
  1190.                         "id" => $article->getId(),
  1191.                         "slug" => $contenu->getSlug(),
  1192.                         "title" => $contenu->getTitle(),
  1193.                         "short_description" => html_entity_decode($contenu->getShortDescription()),
  1194.                         "description" => $contenu->getContent(),
  1195.                         "date" => $contenu->getDateDebutPublication() ? strtotime($contenu->getDateDebutPublication()->format('Y-m-d H:i:s')) : strtotime($contenu->getCreatedAt()->format('Y-m-d H:i:s')),
  1196.                         "author" => $article->getAuthor(),
  1197.                         "lang" => strtolower($contenu->getLang()),
  1198.                         "categories" => [
  1199.                             [
  1200.                                 "title" => ($categoryContenu) ? $categoryContenu->getName() : "",
  1201.                                 "id" => ($article->getActualiteCategory()) ? $article->getActualiteCategory()->getId() : "",
  1202.                                 'lang' => strtolower($contenu->getLang())
  1203.                             ]
  1204.                         ],
  1205.                         "src" => ($article->isLockCopie()) ? $this->cdnOpc . "articlesPrerediges/" . $contenu->getImage() : $this->cdnOpc . 'adherent/' . $article->getAdherent() . "/" . $contenu->getImage()
  1206.                     ];
  1207.                 }
  1208.             }
  1209.         }
  1210.         $datas = [
  1211.             'fr' => [
  1212.                 "news" => (array_key_exists('fr', $articles)) ? $articles['fr'] : [],
  1213.                 "seo" => [
  1214.                     "title" => "",
  1215.                     "description" => "",
  1216.                     "keywords" => ""
  1217.                 ],
  1218.                 "total" => (array_key_exists('fr', $articles)) ? count($articles['fr']) : 0
  1219.             ],
  1220.             'nl' => [
  1221.                 "news" => (array_key_exists('nl', $articles)) ? $articles['nl'] : [],
  1222.                 "seo" => [
  1223.                     "title" => "",
  1224.                     "description" => "",
  1225.                     "keywords" => ""
  1226.                 ],
  1227.                 "total" => (array_key_exists('nl', $articles)) ? count($articles['nl']) : 0
  1228.             ]
  1229.         ];
  1231.         return new JsonResponse($datas);
  1232.     }
  1234.     /**
  1235.      * @Route("/magasin/{magasin}/widget/lastnews", name="factory_api_widget_lastnews")
  1236.      * @param Request $request
  1237.      * @param Magasin $magasin
  1238.      * @return void
  1239.      */
  1240.     public function widgetLastNews(Request $request, Magasin $magasin)
  1241.     {
  1242.         $limit = 4;
  1244.         $articlesFr = [];
  1245.         $articlesNl = [];
  1247.         $articles = $this->entityManager->getRepository(WebfactoryActualite::class)->findLastActu($magasin, $limit);
  1249.         foreach ($articles as $article) {
  1250.             foreach ($article->getWebfactoryActualiteContenus() as $contenu) {
  1251.                 if ($contenu->getStatut() != "brouillon"
  1252.                     && (
  1253.                         (is_null($contenu->getDateDebutpublication()) && is_null($contenu->getDateFinPublication()))
  1254.                         || ($contenu->getDateDebutpublication() <= new \DateTime('today'))
  1255.                         || ($contenu->getDateDebutpublication() <= new \DateTime('today') && $contenu->getDateFinPublication() >= new \DateTime('today'))
  1256.                     )
  1257.                 ) {
  1258.                     $categoryContenu = $article->getActualiteCategory()?->getContenuByLang($contenu->getLang());
  1259.                     $art = [
  1260.                         "id" => $article->getId(),
  1261.                         "slug" => $contenu->getSlug(),
  1262.                         "title" => $contenu->getTitle(),
  1263.                         "lang" => strtolower($contenu->getLang()),
  1264.                         "short_description" => html_entity_decode($contenu->getShortDescription()),
  1265.                         "date" => strtotime($contenu->getCreatedAt()->format('Y-m-d H:i:s')),
  1266.                         "author" => $article->getAuthor(),
  1267.                         "categories" => [
  1268.                             [
  1269.                                 "title" => ($categoryContenu) ? $categoryContenu->getName() : "",
  1270.                                 "id" => ($article->getActualiteCategory()) ? $article->getActualiteCategory()->getId() : "",
  1271.                                 'lang' => strtolower($contenu->getLang())
  1272.                             ]
  1273.                         ],
  1274.                         "src" => ($article->isLockCopie()) ? $this->cdnOpc . "articlesPrerediges/" . $contenu->getImage() : $this->urlPhotosAdh . $article->getAdherent() . "/" . $contenu->getImage()
  1275.                     ];
  1276.                     (strtolower($contenu->getLang()) === "fr") ? $articlesFr[] = $art : $articlesNl[] = $art;
  1277.                 }
  1278.             }
  1279.         }
  1281.         $datas = [
  1282.             'fr' => [
  1283.                 "last_news" => $articlesFr
  1284.             ],
  1285.             'nl' => [
  1286.                 "last_news" => $articlesNl
  1287.             ],
  1288.         ];
  1289.         return new JsonResponse($datas);
  1290.     }
  1292.     /**
  1293.      * @Route("/magasin/{magasin}/widget/news/categories", name="factory_api_widget_categories")
  1294.      * @param Request $request
  1295.      * @param Magasin $magasin
  1296.      * @return JsonResponse
  1297.      */
  1298.     public function widgetCategories(Request $request, Magasin $magasin)
  1299.     {
  1300.         $categoriesFr = [];
  1301.         $categoriesNl = [];
  1303.         $nbTotalNews = ['fr' => 0, 'nl' => 0];
  1305.         $categoriesFrNl = $this->entityManager->getRepository(WebfactoryActualiteCategory::class)->findBy(['adherent' => $magasin]);
  1307.         foreach ($categoriesFrNl as $categorie) {
  1308.             foreach ($categorie->getWebfactoryActualiteCategoryContenus() as $contenu) {
  1310.                 $categ = [
  1311.                     "name" => $contenu->getName(),
  1312.                     "id" => $categorie->getId(),
  1313.                     "slug" => $contenu->getSlug(),
  1314.                     "total" => count($categorie->getWebfactoryActualites()->toArray())
  1315.                     /*                    "lang" => $categorie->getLang(),
  1316.                                         'correspondance' => (!is_null($categorie->getCorrespondance())) ? $categorie->getCorrespondance()->getId() : null*/
  1317.                 ];
  1319.                 $nbTotalNews[strtolower($contenu->getLang())] += count($categorie->getWebfactoryActualites()->toArray());
  1321.                 (strtolower($contenu->getLang()) === "fr") ? $categoriesFr[] = $categ : $categoriesNl[] = $categ;
  1322.             }
  1324.         }
  1326.         array_unshift($categoriesFr, ['name' => 'Toutes', 'id' => 0, 'slug' => 'toutes', 'total' => $nbTotalNews['fr']]);
  1327.         array_unshift($categoriesNl, ['name' => 'alle', 'id' => 0, 'slug' => 'alle', 'total' => $nbTotalNews['nl']]);
  1329.         $datas = [
  1330.             'fr' => [
  1331.                 "categories" => $categoriesFr
  1332.             ],
  1333.             'nl' => [
  1334.                 "categories" => $categoriesNl
  1335.             ],
  1336.         ];
  1338.         return new JsonResponse($datas);
  1339.     }
  1341.     /**
  1342.      * @Route("/magasin/{magasin}/widget/news/{slug}", name="factory_api_widget_news_detail")
  1343.      * @param Magasin $magasin
  1344.      * @param null $slug
  1345.      * @return void
  1346.      * @throws NonUniqueResultException
  1347.      */
  1348.     public function widgetNewsDetail(Magasin $magasin, $slug = null)
  1349.     {
  1350.         $article = $this->entityManager->getRepository(WebfactoryActualite::class)->createQueryBuilder('a')
  1351.             ->join('a.webfactoryActualiteContenus', 'ac', 'ac.article')
  1352.             ->where('ac.slug = :slug')
  1353.             ->andWhere('a.adherent = :adherent')
  1354.             ->andWhere('ac.statut != :statut OR ac.statut IS NULL')
  1355.             ->setParameter('slug', $slug)
  1356.             ->setParameter('adherent', $magasin)
  1357.             ->setParameter('statut', 'brouillon')
  1358.             ->getQuery()->getOneOrNullResult();
  1360.         if (!is_null($article)) {
  1361.             foreach ($article->getWebfactoryActualiteContenus() as $contenu) {
  1362.                 $categoryContent = $article->getActualiteCategory()?->getContenuByLang($contenu->getLang());
  1363.                 $news[strtolower($contenu->getLang())] = [
  1364.                     "id" => $article->getId(),
  1365.                     "slug" => $contenu->getSlug(),
  1366.                     "title" => $contenu->getTitle(),
  1367.                     "image" => [
  1368.                         "mobile" => ($article->isLockCopie()) ? $this->cdnOpc . "articlesPrerediges/" . $contenu->getImage() : $this->urlPhotosAdh . $magasin->getKAdherent() . "/" . $contenu->getImage(),
  1369.                         "desktop" => ($article->isLockCopie()) ? $this->cdnOpc . "articlesPrerediges/" . $contenu->getImage() : $this->urlPhotosAdh . $magasin->getKAdherent() . "/" . $contenu->getImage(),
  1370.                         "alt" => $contenu->getTitle(),
  1371.                         "title" => $contenu->getTitle()
  1372.                     ],
  1373.                     "description1" => $contenu->getContent(),
  1374.                     "description2" => "",
  1375.                     "date" => $contenu->getDateDebutPublication() ? $contenu->getDateDebutPublication()->format('Y-m-d H:i:s') : $contenu->getUpdatedAt()->format('Y-m-d H:i:s'),
  1376.                     "author" => $article->getAuthor(),
  1377.                     "author_job" => (strtolower(strtolower($contenu->getLang())) === "nl") ? "Het team van " . $magasin->getLib() : "L'équipe de " . $magasin->getLib(),
  1378.                     "lang" => strtolower($contenu->getLang()),
  1379.                     "categories" => [
  1380.                         [
  1381.                             "title" => (isset($categoryContent)) ? $categoryContent->getName() : "",
  1382.                             "id" => (isset($categoryContent)) ? $article->getActualiteCategory()->getId() : "",
  1383.                             'lang' => (isset($categoryContent)) ? strtolower($categoryContent->getLang()) : "",
  1384.                         ]
  1385.                     ],
  1386.                     "seo" => [
  1387.                         "title" => $contenu->getMetatitle(),
  1388.                         "description" => $contenu->getMetaDesc(),
  1389.                         "keywords" => $contenu->getMetaKeywords()
  1390.                     ]
  1391.                 ];
  1392.             }
  1395.             $datas = [
  1396.                 'fr' => (array_key_exists('fr', $news)) ? $news['fr'] : [],
  1397.                 'nl' => (array_key_exists('nl', $news)) ? $news['nl'] : []
  1398.             ];
  1400.             return new JsonResponse($datas);
  1401.         }
  1402.         return new JsonResponse('Article introuvable');
  1403.     }
  1405.     /**
  1406.      * @Route("/magasin/{magasin}/widget/banner", name="factory_api_widget_banner")
  1407.      * @param Request $request
  1408.      * @param Magasin $magasin
  1409.      * @return void
  1410.      */
  1411.     public function widgetAnnouncementBar(Request $request, Magasin $magasin)
  1412.     {
  1413.         $datas = [
  1414.             'fr' => [
  1415.                 'banner' => []
  1416.             ],
  1417.             'nl' => [
  1418.                 'banner' => []
  1419.             ],
  1420.         ];
  1422.         if (!is_null($magasin)) {
  1423.             $announcementBars = $this->entityManager->getRepository(AnnouncementBar::class)->findBy(['magasin' => $magasin]);
  1425.             foreach ($announcementBars as $announcementBar) {
  1427.                 $options = $announcementBar->getOptions()->toArray();
  1429.                 foreach ($options as $option) {
  1430.                     $banner = [];
  1431.                     switch ($option->getChoice()) {
  1432.                         case 'texte_libre':
  1433.                             $banner = [
  1434.                                 "type" => $option->getChoice(),
  1435.                                 "content" => $option->getContent(),
  1436.                                 "url" => $option->getUrl(),
  1437.                                 "target" => $option->getTarget(),
  1438.                                 "rating" => null,
  1439.                                 "author" => null
  1440.                             ];
  1442.                             break;
  1443.                         case 'rdv':
  1444.                             $urlRdv = $this->entityManager->getRepository(MagasinUrl::class)->findOneBy(['magasin' => $magasin, 'type' => 'rdv']);
  1446.                             // Prise de rdv
  1447.                             $urlMagasin = $this->entityManager->getRepository(MagasinUrl::class)->findOneBy(['magasin' => $magasin, 'type' => 'OPC/OZC']);
  1449.                             preg_match("/(opticiens-oc.be\/nl\/*)/", $urlMagasin->getUrl(), $matches);
  1450.                             if (!empty($matches)) {
  1451.                                 $slugrdv = $urlMagasin->getUrl() . '/maak-een-afspraak';
  1452.                             } else {
  1453.                                 $slugrdv = $urlMagasin->getUrl() . '/prise-de-rdv';
  1454.                             }
  1456.                             $urlRDV = (!is_null($urlRdv)) ? $urlRdv->getUrl() : $slugrdv;
  1458.                             $banner = [
  1459.                                 "type" => $option->getChoice(),
  1460.                                 "content" => $option->getContent(),
  1461.                                 "url" => $urlRDV,
  1462.                                 "target" => $option->getTarget(),
  1463.                                 "rating" => null,
  1464.                                 "author" => null,
  1465.                                 'rel' => 'nofollow'
  1466.                             ];
  1468.                             break;
  1469.                         case 'avis_CRM':
  1471.                             if (!is_null($option->getAvisCrm())) {
  1473.                                 $avis = json_decode($option->getAvisCrm(), true);
  1475.                                 $content = [
  1476.                                     "date" => $avis['D_CREE'],
  1477.                                     "comment" => $avis['COMMENT']
  1478.                                 ];
  1480.                                 $banner = [
  1481.                                     "type" => $option->getChoice(),
  1482.                                     "content" => $content,
  1483.                                     "url" => null,
  1484.                                     "target" => $option->getTarget(),
  1485.                                     "rating" => $avis['NOTE'],
  1486.                                     "author" => $avis['AUTEUR']
  1487.                                 ];
  1488.                             }
  1490.                             break;
  1491.                         case 'offers':
  1492.                             $banner = [
  1493.                                 "type" => $option->getChoice(),
  1494.                                 "content" => json_decode($option->getOffreWeb()),
  1495.                                 "url" => null,
  1496.                                 "target" => $option->getTarget(),
  1497.                                 "rating" => null,
  1498.                                 "author" => null
  1499.                             ];
  1501.                             break;
  1502.                     }
  1504.                     if (strtolower($announcementBar->getLang()) === "fr") {
  1505.                         $datas['fr']['banner'][] = $banner;
  1506.                     } else {
  1507.                         $datas['nl']['banner'][] = $banner;
  1508.                     }
  1509.                 }
  1511.             }
  1512.         }
  1514.         return new JsonResponse($datas);
  1515.     }
  1517.     /**
  1518.      * @Route("/magasin/{magasin}/widget/stores", name="factory_api_widget_stores")
  1519.      * @param Request $request
  1520.      * @param Magasin $magasin
  1521.      * @return void
  1522.      */
  1523.     public function widgetStores(Request $request, Magasin $magasin)
  1524.     {
  1525.         $stores = [];
  1526.         $seoFr = [
  1527.             "title" => "",
  1528.             "description" => "",
  1529.             "keywords" => ""
  1530.         ];
  1531.         $seoNl = $seoFr;
  1533.         $magasins = $this->entityManager->getRepository(Magasin::class)->findBy(['adhMmStat' => $magasin->getAdhMmStat()]);
  1535.         foreach ($magasins as $magasin) {
  1537.             foreach ($magasin->getMagasinCoordonnees() as $adresse) {
  1539.                 if (strtoupper($adresse->getTYPE()) === "MAGASIN") {
  1541.                     $entityName = "App\Entity\Webfactory\\Page\\Classique\\Store";
  1543.                     $pageMagasins = $this->entityManager->getRepository($entityName)->findBy(['magasin' => $magasin->getKADHERENT()]);
  1545.                     foreach ($pageMagasins as $pageMagasin) {
  1547.                         if (strtolower($pageMagasin->getLang()) === "fr") {
  1548.                             $seoFr = [
  1549.                                 "title" => (empty($seo['title'])) ? $pageMagasin->getMetatitle() : $seo['title'],
  1550.                                 "description" => (empty($seo['description'])) ? $pageMagasin->getMetadescription() : $seo['description'],
  1551.                                 "keywords" => (empty($seo['keywords'])) ? $pageMagasin->getMetakeywords() : $seo['keywords']
  1552.                             ];
  1553.                         } else {
  1554.                             $seoNl = [
  1555.                                 "title" => (empty($seo['title'])) ? $pageMagasin->getMetatitle() : $seo['title'],
  1556.                                 "description" => (empty($seo['description'])) ? $pageMagasin->getMetadescription() : $seo['description'],
  1557.                                 "keywords" => (empty($seo['keywords'])) ? $pageMagasin->getMetakeywords() : $seo['keywords']
  1558.                             ];
  1559.                         }
  1561.                     }
  1563.                     $rue = ((!empty($adresse->getVOIENUM())) ? $adresse->getVOIENUM() . ' ' : '') .
  1564.                         ((!empty($adresse->getVOIECPLT())) ? $adresse->getVOIECPLT() . ' ' : '') .
  1565.                         ((!empty($adresse->getVOIETYPE())) ? $adresse->getVOIETYPE() . ' ' : '') .
  1566.                         ((!empty($adresse->getVOIELIB())) ? $adresse->getVOIELIB() : '');
  1568.                     // Image
  1569.                     $imageMags = $this->entityManager->getRepository(Image::class)->findOneBy([
  1570.                         'adherent' => $magasin->getKADHERENT(),
  1571.                         'profileDefault' => true
  1572.                     ]);
  1574.                     $stores[] = [
  1575.                         "name" => $adresse->getLIB(),
  1576.                         "address" => $rue,
  1577.                         "address_2" => null,
  1578.                         "postal_code" => $adresse->getKCP(),
  1579.                         "city" => $adresse->getKVILLE(),
  1580.                         "src" => $imageMags != null ? $this->urlPhotosAdh . $adresse->getKAdherent() . "/" . $imageMags->getName() : null,
  1581.                         "code" => $adresse->getKADHERENT(),
  1582.                         "hours" => $this->webfactoryManager->formatHoursForApi($magasin),
  1584.                     ];
  1585.                 }
  1586.             }
  1588.         }
  1590.         $datas = [
  1591.             'fr' => [
  1592.                 "stores" => $stores,
  1593.                 "seo" => $seoFr
  1594.             ],
  1595.             'nl' => [
  1596.                 "stores" => $stores,
  1597.                 "seo" => $seoNl
  1598.             ]
  1599.         ];
  1601.         return new JsonResponse($datas);
  1602.     }
  1604.     /**
  1605.      * @Route("/magasin/{magasin}/widget/more_about", name="factory_api_widget_more_about")
  1606.      * @param Request $request
  1607.      * @param Magasin $magasin
  1608.      * @return void
  1609.      * MULTIPAGE !
  1610.      */
  1611.     public function widgetMoreAbout(Request $request, Magasin $magasin)
  1612.     {
  1613.         if (!$request->query->has('page')) {
  1614.             return new JsonResponse(['status' => 400, 'error' => 'Paramètre page manquant'], 400);
  1615.         }
  1617.         $page = $request->query->get('page');
  1618.         $page = $this->entityManager->getRepository(WebfactoryPage::class)->findOneBy(['id' => $page]);
  1619.         $pageCustomId = $request->query->get('customPage');
  1621.         $config = $this->webfactoryManager->getFactoryConfig($magasin->getKAdherent());
  1622.         $theme = $config['offer']['theme']['name'];
  1624.         $widget = $this->entityManager->getRepository(WebfactoryWidget::class)->findOneBy(['identifier' => 'more_about']);
  1626.         $widgets = $this->entityManager->getRepository(WidgetAbstract::class)->findBy([
  1627.             'magasin' => $magasin->getKAdherent(),
  1628.             'page' => $page->getIdentifier(),
  1629.             'theme' => $theme,
  1630.             'widget' => $widget,
  1631.             'pageCustom' => $pageCustomId
  1632.         ]);
  1634.         $datas = ['fr' => [], 'nl' => []];
  1636.         if (!empty($widgets)) {
  1638.             foreach ($widgets as $widgetDetails) {
  1639.                 $datas[strtolower($widgetDetails->getLang())] = [
  1640.                     'title' => $widgetDetails->getText(),
  1641.                     'link' => $widgetDetails->getLink(),
  1642.                     "perso_link" => $widgetDetails->getLinkOther(),
  1643.                     'image' => $this->urlPhotosAdh . $magasin->getKAdherent() . "/" . $widgetDetails->getImage(),
  1644.                     'target' => '_blank',
  1645.                     "button" => $this->translator->trans("En savoir plus", [], 'messages', $widgetDetails->getLang())
  1646.                 ];
  1648.             }
  1650.             return new JsonResponse($datas);
  1652.         } else {
  1653.             return new JsonResponse(['status' => 400, 'error' => 'Aucun widget pour cette page'], 400);
  1654.         }
  1656.     }
  1658.     /**
  1659.      * @Route("/magasin/{magasin}/widget/custom_text", name="factory_api_widget_custom_text")
  1660.      * @param Request $request
  1661.      * @param Magasin $magasin
  1662.      * @return void
  1663.      * MULTIPAGE !
  1664.      */
  1665.     public function widgetCustomText(Request $request, Magasin $magasin)
  1666.     {
  1667.         if (!$request->query->has('page')) {
  1668.             return new JsonResponse(['status' => 400, 'error' => 'Paramètre page manquant'], 400);
  1669.         }
  1671.         $page = $request->query->get('page');
  1672.         $page = $this->entityManager->getRepository(WebfactoryPage::class)->findOneBy(['id' => $page]);
  1673.         $pageCustomId = $request->query->get('customPage');
  1675.         $config = $this->webfactoryManager->getFactoryConfig($magasin->getKAdherent());
  1677.         $theme = $config['offer']['theme']['name'];
  1679.         $widget = $this->entityManager->getRepository(WebfactoryWidget::class)->findOneBy(['identifier' => 'custom_text']);
  1681.         $widgetDetails = $this->entityManager->getRepository(WidgetAbstract::class)->findBy([
  1682.             'magasin' => $magasin->getKAdherent(),
  1683.             'page' => $page->getIdentifier(),
  1684.             'theme' => $theme,
  1685.             'widget' => $widget,
  1686.             'pageCustom' => $pageCustomId
  1687.         ]);
  1689.         $datas['fr']['content'] = [];
  1690.         $datas['nl']['content'] = [];
  1692.         if (!empty($widgetDetails)) {
  1693.             foreach ($widgetDetails as $widgetDetail) {
  1694.                 $datas[strtolower($widgetDetail->getLang())]['content'] = $widgetDetail->getContent();
  1695.             }
  1696.         }
  1697.         return new JsonResponse($datas);
  1698.     }
  1700.     /**
  1701.      * @Route("/magasin/{magasin}/widget/gallery", name="factory_api_widget_gallery")
  1702.      * @param Request $request
  1703.      * @param Magasin $magasin
  1704.      * @return void
  1705.      * MULTIPAGE
  1706.      */
  1707.     public function widgetGallery(Request $request, Magasin $magasin)
  1708.     {
  1710.         if (!$request->query->has('page')) {
  1711.             return new JsonResponse(['status' => 400, 'error' => 'Paramètre page manquant'], 400);
  1712.         }
  1713.         $page = $request->query->get('page');
  1714.         $page = $this->entityManager->getRepository(WebfactoryPage::class)->findOneBy(['id' => $page]);
  1715.         $pageCustomId = $request->query->get('customPage');
  1717.         $config = $this->webfactoryManager->getFactoryConfig($magasin->getKAdherent());
  1718.         $theme = $config['offer']['theme']['name'];
  1720.         $widget = $this->entityManager->getRepository(WebfactoryWidget::class)->findOneBy(['identifier' => 'gallery']);
  1722.         $widgetDetails = $this->entityManager->getRepository(WidgetAbstract::class)->findBy([
  1723.             'magasin' => $magasin->getKAdherent(),
  1724.             'page' => $page->getIdentifier(),
  1725.             'theme' => $theme,
  1726.             'widget' => $widget,
  1727.             'pageCustom' => $pageCustomId
  1728.         ]);
  1730.         $datas['fr']['images'] = [];
  1731.         $datas['nl']['images'] = [];
  1733.         if (!empty($widgetDetails)) {
  1734.             foreach ($widgetDetails as $widgetDetail) {
  1735.                 if (!empty($widgetDetail->getImages()->toArray())) {
  1736.                     $images = $widgetDetail->getImages()->toArray();
  1737.                     foreach ($images as $image) {
  1739.                         if (intval($image->getWidth()) > intval($image->getHeight())) {
  1740.                             $orientation = "landscape";
  1741.                         } else {
  1742.                             $orientation = "portrait";
  1743.                         }
  1745.                         $datas[strtolower($widgetDetail->getLang())]['images'][] = [
  1746.                             "media" => [
  1747.                                 "mobile" => $this->urlPhotosAdh . $magasin->getKAdherent() . "/" . $image->getName(),
  1748.                                 "desktop" => $this->urlPhotosAdh . $magasin->getKAdherent() . "/" . $image->getName(),
  1749.                             ],
  1750.                             "alt" => $image->getAlt(),
  1751.                             "title" => str_replace("." . $image->getExtension(), "", $image->getName()),
  1752.                             'orientation' => $orientation,
  1753.                         ];
  1755.                     }
  1756.                     $datas[strtolower($widgetDetail->getLang())]['affichage'] = $widgetDetail->getTypeAffichagePhotos();
  1757.                     $datas[strtolower($widgetDetail->getLang())]['slider_slide_to_show'] = $widgetDetail->getSliderSlideToShow();
  1758.                 }
  1759.             }
  1760.         }
  1762.         return new JsonResponse($datas);
  1763.     }
  1765.     /**
  1766.      * @Route("/magasin/{magasin}/widget/esv", name="factory_api_widget_esv")
  1767.      * @param Request $request
  1768.      * @param Magasin $magasin
  1769.      * @return void
  1770.      */
  1771.     public function widgetESV(Request $request, Magasin $magasin)
  1772.     {
  1773.         if ($magasin->getKNIVEAUADH() === "LOL4G") {
  1775.             $esv = [
  1776.                 'fr' => [
  1777.                     "title" => "Expert santé visuelle",
  1778.                     "blocks" => [
  1779.                         [
  1780.                             "title" => "Experts santé visuelle qui sont-ils ?",
  1781.                             "svg_name" => "bullseye",
  1782.                             "icon" => file_get_contents($this->getParameter("images_directory") . "/icons/bxs-bullseye.svg.svg"),
  1783.                             "button_text" => "En savoir plus",
  1784.                             "link" => "https://www.opticiensparconviction.fr/les-experts-en-sante-visuelle",
  1785.                             "target" => "_blank",
  1786.                             'rel' => 'nofollow'
  1787.                         ],
  1788.                         [
  1789.                             "title" => "Ce qu’il faut savoir<br />Prix, qualité...",
  1790.                             "svg_name" => "purchase-tag",
  1791.                             "icon" => file_get_contents($this->getParameter("images_directory") . "/icons/bxs-purchase-tag.svg.svg"),
  1792.                             "button_text" => "En savoir plus",
  1793.                             "link" => "https://www.expertsantevisuelle.com/prix-qualite-remboursement/payer-le-bon-prix",
  1794.                             "target" => "_blank",
  1795.                             'rel' => 'nofollow'
  1796.                         ],
  1797.                         [
  1798.                             "title" => "Clins d’oeil, infos, astuces, conseils...",
  1799.                             "svg_name" => "info-circle",
  1800.                             "icon" => file_get_contents($this->getParameter("images_directory") . "/icons/bxs-info-circle.svg.svg"),
  1801.                             "button_text" => "En savoir plus",
  1802.                             "link" => "https://www.expertsantevisuelle.com/clin-oeil",
  1803.                             "target" => "_blank",
  1804.                             'rel' => 'nofollow'
  1805.                         ]
  1806.                     ]
  1807.                 ],
  1808.                 'nl' => []
  1809.             ];
  1810.             return new JsonResponse($esv);
  1812.         } else {
  1813.             return new JsonResponse(['status' => 400, 'error' => 'Adhérent non ESV'], 400);
  1814.         }
  1816.     }
  1818.     /**
  1819.      * @Route("/magasin/{magasin}/widget/services_specialties", name="factory_api_widget_services_specialties")
  1820.      * @param Request $request
  1821.      * @param Magasin $magasin
  1822.      * @return void
  1823.      */
  1824.     public function widgetServicesEtSpecialities(Request $request, Magasin $magasin)
  1825.     {
  1827.         $services = $this->entityManager->getRepository(SiteWebService::class)->findBy(['kAdh' => $magasin], ['sort' => 'ASC']);
  1828.         $specialites = $this->entityManager->getRepository(SiteWebSpecialite::class)->findBy(['kAdh' => $magasin], ['sort' => 'ASC']);
  1830.         $datas = [];
  1832.         $datas['fr']['widgets']['services_specialties'][] = [
  1833.             'subtitle' => "Notre expertise à votre service",
  1834.             'subdescription' => "Dans notre magasin, nous mettons à votre disposition une palette de services et de spécialités afin de vous garantir une expérience unique."
  1835.         ];
  1836.         $datas['nl']['widgets']['services_specialties'][] = [
  1837.             'subtitle' => "Onze expertise tot uw dienst",
  1838.             'subdescription' => "In onze winkel bieden wij een waaier van diensten en specialiteiten aan om een unieke ervaring te garanderen."
  1839.         ];
  1841.         foreach ($services as $serv) {
  1843.             $datas['fr']['widgets']['services_specialties']['services'][] = [
  1844.                 "name" => $serv->getIdService()->getName(),
  1845.                 "svg_name" => $serv->getIdService()->getSvg(),
  1846.                 'icon' => (!is_null($serv->getIdService()->getSvg())) ? file_get_contents($this->getParameter("images_directory") . '/webfactory/svg/' . $serv->getIdService()->getSvg()) : ""
  1847.             ];
  1849.             $datas['nl']['widgets']['services_specialties']['services'][] = [
  1850.                 "name" => $this->translator->trans($serv->getIdService()->getName(), [], 'messages', 'nl'),
  1851.                 "svg_name" => $serv->getIdService()->getSvg(),
  1852.                 'icon' => (!is_null($serv->getIdService()->getSvg())) ? file_get_contents($this->getParameter("images_directory") . '/webfactory/svg/' . $serv->getIdService()->getSvg()) : ""
  1853.             ];
  1855.         }
  1857.         foreach ($specialites as $spec) {
  1858.             $datas['fr']['widgets']['services_specialties']['specialites'][] = [
  1859.                 "name" => $spec->getIdSpecialite()->getName(),
  1860.                 "svg_name" => $spec->getIdSpecialite()->getSvg(),
  1861.                 'icon' => (!is_null($spec->getIdSpecialite()->getSvg())) ? file_get_contents($this->getParameter("images_directory") . '/webfactory/svg/' . $spec->getIdSpecialite()->getSvg() . ".svg") : ""
  1862.             ];
  1864.             $datas['nl']['widgets']['services_specialties']['specialites'][] = [
  1865.                 "name" => $this->translator->trans($spec->getIdSpecialite()->getName(), [], 'messages', 'nl'),
  1866.                 "svg_name" => $spec->getIdSpecialite()->getSvg(),
  1867.                 'icon' => (!is_null($spec->getIdSpecialite()->getSvg())) ? file_get_contents($this->getParameter("images_directory") . '/webfactory/svg/' . $spec->getIdSpecialite()->getSvg() . ".svg") : ""
  1868.             ];
  1869.         }
  1871.         return new JsonResponse($datas);
  1872.     }
  1875.     /**
  1876.      * @Route("/magasin/{magasin}/widget/verbatim", name="factory_api_widget_verbatim")
  1877.      * @param Request $request
  1878.      * @param Magasin $magasin
  1879.      * @return void
  1880.      * MULTIPAGE !
  1881.      */
  1882.     public function widgetVerbatim(Request $request, Magasin $magasin)
  1883.     {
  1884.         if (!$request->query->has('page')) {
  1885.             return new JsonResponse(['status' => 400, 'error' => 'Paramètre page manquant'], 400);
  1886.         }
  1888.         $page = $request->query->get('page');
  1889.         $page = $this->entityManager->getRepository(WebfactoryPage::class)->findOneBy(['id' => $page]);
  1890.         $pageCustomId = $request->query->get('customPage');
  1892.         $config = $this->webfactoryManager->getFactoryConfig($magasin->getKAdherent());
  1893.         $theme = $config['offer']['theme']['name'];
  1895.         $widget = $this->entityManager->getRepository(WebfactoryWidget::class)->findOneBy(['identifier' => 'verbatim']);
  1897.         $widgets = $this->entityManager->getRepository(WidgetAbstract::class)->findBy([
  1898.             'magasin' => $magasin->getKAdherent(),
  1899.             'page' => $page->getIdentifier(),
  1900.             'theme' => $theme,
  1901.             'widget' => $widget,
  1902.             'pageCustom' => $pageCustomId
  1903.         ]);
  1905.         $datas = [];
  1906.         foreach ($widgets as $widget) {
  1908.             $datas[strtolower($widget->getLang())][] = [
  1909.                 'quote' => $widget->getConviction(),
  1910.                 'from' => $widget->getAuthor()
  1911.             ];
  1913.         }
  1915.         return new JsonResponse($datas);
  1916.     }
  1918.     /**
  1919.      * @Route("/magasin/{magasin}/widget/promote", name="factory_api_widget_promote")
  1920.      * @param Request $request
  1921.      * @param Magasin $magasin
  1922.      * @return JsonResponse
  1923.      * MULTIPAGE !
  1924.      */
  1925.     public function widgetPromote(Request $request, Magasin $magasin)
  1926.     {
  1927.         if (!$request->query->has('page')) {
  1928.             return new JsonResponse(['status' => 400, 'error' => 'Paramètre page manquant'], 400);
  1929.         }
  1931.         $page = $request->query->get('page');
  1932.         $page = $this->entityManager->getRepository(WebfactoryPage::class)->findOneBy(['id' => $page]);
  1933.         $pageCustomId = $request->query->get('customPage');
  1935.         $config = $this->webfactoryManager->getFactoryConfig($magasin->getKAdherent());
  1936.         $theme = $config['offer']['theme']['name'];
  1938.         $widget = $this->entityManager->getRepository(WebfactoryWidget::class)->findOneBy(['identifier' => 'promote']);
  1940.         $widgets = $this->entityManager->getRepository(WidgetAbstract::class)->findBy([
  1941.             'magasin' => $magasin->getKAdherent(),
  1942.             'page' => $page->getIdentifier(),
  1943.             'theme' => $theme,
  1944.             'widget' => $widget,
  1945.             'pageCustom' => $pageCustomId
  1946.         ]);
  1948.         $datas = [];
  1949.         if (!empty($widgets)) {
  1951.             foreach ($widgets as $widgetDetail) {
  1953.                 $datas[strtolower($widgetDetail->getLang())] = [
  1954.                     "first" => [
  1955.                         "title" => $widgetDetail->getDiscoveryTitle1(),
  1956.                         "button_text" => $widgetDetail->getDiscoveryBtnText1(),
  1957.                         "link" => $widgetDetail->getDiscoveryBtnUrl1(),
  1958.                         "perso_link" => $widgetDetail->getDiscoveryBtnUrlOther1(),
  1959.                         "images" => [
  1960.                             "image" => (!is_null($widgetDetail->getDiscoveryImg1())) ? $this->urlPhotosAdh . $magasin->getKAdherent() . "/" . $widgetDetail->getDiscoveryImg1() : null,
  1961.                             "alt" => (!is_null($widgetDetail->getDiscoveryImg1())) ? "Image de présentation" : null,
  1962.                             "title" => (!is_null($widgetDetail->getDiscoveryImg1())) ? "Image de présentation" : null
  1963.                         ]
  1964.                     ],
  1965.                     "second" => [
  1966.                         "title" => $widgetDetail->getDiscoveryTitle2(),
  1967.                         "button_text" => $widgetDetail->getDiscoveryBtnText2(),
  1968.                         "link" => $widgetDetail->getDiscoveryBtnUrl2(),
  1969.                         "perso_link" => $widgetDetail->getDiscoveryBtnUrlOther2(),
  1970.                         "images" => [
  1971.                             "image" => (!is_null($widgetDetail->getDiscoveryImg2())) ? $this->urlPhotosAdh . $magasin->getKAdherent() . "/" . $widgetDetail->getDiscoveryImg2() : null,
  1972.                             "alt" => (!is_null($widgetDetail->getDiscoveryImg2())) ? "Image de présentation" : null,
  1973.                             "title" => (!is_null($widgetDetail->getDiscoveryImg2())) ? "Image de présentation" : null
  1974.                         ]
  1975.                     ]
  1976.                 ];
  1978.             }
  1980.             return new JsonResponse($datas);
  1982.         } else {
  1983.             return new JsonResponse(['status' => 400, 'error' => 'Aucun widget pour cette page'], 400);
  1984.         }
  1986.     }
  1988.     /**
  1989.      * @Route("/magasin/{magasin}/widget/notification", name="factory_api_widget_notification")
  1990.      * @param Request $request
  1991.      * @param Magasin $magasin
  1992.      * @return void
  1993.      * MULTIPAGE
  1994.      */
  1995.     public function widgetNotification(Request $request, Magasin $magasin)
  1996.     {
  1998.         if (!$request->query->has('page')) {
  1999.             return new JsonResponse(['status' => 400, 'error' => 'Paramètre page manquant'], 400);
  2000.         }
  2002.         $page = $request->query->get('page');
  2003.         $page = $this->entityManager->getRepository(WebfactoryPage::class)->findOneBy(['id' => $page]);
  2004.         $pageCustomId = $request->query->get('customPage');
  2006.         $config = $this->webfactoryManager->getFactoryConfig($magasin->getKAdherent());
  2007.         $theme = $config['offer']['theme']['name'];
  2009.         $widget = $this->entityManager->getRepository(WebfactoryWidget::class)->findOneBy(['identifier' => 'notification']);
  2011.         $widgetDetails = $this->entityManager->getRepository(WidgetAbstract::class)->findBy([
  2012.             'magasin' => $magasin->getKAdherent(),
  2013.             'page' => $page->getIdentifier(),
  2014.             'theme' => $theme,
  2015.             'widget' => $widget,
  2016.             'pageCustom' => $pageCustomId
  2017.         ]);
  2019.         $datas['fr'] = [];
  2020.         $datas['nl'] = [];
  2022.         if (!empty($widgetDetails)) {
  2023.             foreach ($widgetDetails as $widgetDetail) {
  2024.                 $datas[strtolower($widgetDetail->getLang())]['content'] = $widgetDetail->getContent();
  2025.                 $datas[strtolower($widgetDetail->getLang())]['start_date'] = $widgetDetail->getStartDate();
  2026.                 $datas[strtolower($widgetDetail->getLang())]['end_date'] = $widgetDetail->getEndDate();
  2027.                 $datas[strtolower($widgetDetail->getLang())]['uuid'] = base64_encode(uniqid($widgetDetail->getMagasin() . $widgetDetail->getId() . $widgetDetail->getUpdatedAt()?->format('Y-m-d')));
  2028.             }
  2029.         }
  2031.         return new JsonResponse($datas);
  2032.     }
  2034.     /**
  2035.      * @Route("/magasin/{magasin}/custom_css_js", name="factory_api_custom_css_js")
  2036.      * @param Request $request
  2037.      * @param Magasin $magasin
  2038.      * @return JsonResponse
  2039.      */
  2040.     public function customCssJs(Request $request, Magasin $magasin): JsonResponse
  2041.     {
  2043.         $custom = $this->entityManager->getRepository(CustomCssJs::class)->findOneBy(['magasin' => $magasin->getKAdherent(), 'active' => 1]);
  2044.         $datas = [];
  2045.         if ($custom) {
  2046.             $datas = [
  2047.                 'css' => $custom->getContentCss(),
  2048.                 'js' => $custom->getContentJs()
  2049.             ];
  2050.         } else {
  2051.             return new JsonResponse(['status' => 400, 'error' => 'Aucun code css/js actif'], 400);
  2052.         }
  2053.         return new JsonResponse($datas, 200);
  2055.     }
  2057.     /**
  2058.      * @Route("/magasin/{magasin}/seo_ville/{ville}", name="factory_api_seo_villes")
  2059.      * @Route("/magasin/{magasin}/seo_ville/{ville}", name="factory_api_page_seo_ville_detail")
  2060.      * @param Request $request
  2061.      * @param Magasin $magasin
  2062.      * @return JsonResponse
  2063.      */
  2064.     public function apiSeoVilleDetail(Request $request, Magasin $magasin, $ville = null): JsonResponse
  2065.     {
  2066.         $arrayLangues = ['fr', 'nl'];
  2068.         $datas = [];
  2070.         if (is_null($ville)) {
  2071.             foreach ($arrayLangues as $langue) {
  2072.                 $findCities = $this->entityManager->getRepository(SeoVilles::class)->createQueryBuilder('ville', 'ville.name')
  2073.                     ->select('ville.name, contenu.langue')
  2074.                     ->join(SeoVillesContenus::class, "contenu", "WITH", 'contenu.ville = ville.id')
  2075.                     ->where('ville.magasin = :magasin')
  2076.                     ->andWhere('contenu.langue = :langue')
  2077.                     ->setParameters(['magasin' => $magasin->getKAdherent(), 'langue' => $langue])
  2078.                     ->getQuery()->getResult();
  2080.                 foreach ($findCities as $city) {
  2081.                     $datas[$city['name']][$langue] = [
  2082.                         'name' => $city['name']
  2083.                     ];
  2084.                 }
  2085.             }
  2087.         } else {
  2088.             foreach ($arrayLangues as $langue) {
  2089.                 $findCity = $this->entityManager->getRepository(SeoVilles::class)->createQueryBuilder('ville', 'ville.name')
  2090.                     ->select('ville.name,contenu.intro, contenu.text, contenu.metatitle, contenu.metadesc,contenu.image, contenu.langue')
  2091.                     ->join(SeoVillesContenus::class, "contenu", "WITH", 'contenu.ville = ville.id')
  2092.                     ->where('ville.magasin = :magasin')
  2093.                     ->andWhere('contenu.langue = :langue')
  2094.                     ->andWhere('ville.name = :ville')
  2095.                     ->setParameters(['magasin' => $magasin->getKAdherent(), 'langue' => $langue, 'ville' => strtoupper($ville)])
  2096.                     ->getQuery()->getOneOrNullResult();
  2098.                 if ($findCity) {
  2099.                     $datas[$langue]['name'] = $findCity['name'];
  2100.                     $datas[$langue]['intro'] = $findCity['intro'];
  2101.                     $datas[$langue]['text'] = $findCity['text'];
  2102.                     $datas[$langue]['metatitle'] = $findCity['metatitle'];
  2103.                     $datas[$langue]['metadesc'] = $findCity['metadesc'];
  2105.                     $datas[$langue]['image'] = ($findCity['image']) ? $this->urlPhotosAdh . $magasin->getKAdherent() . "/" . $findCity['image'] : null;
  2106.                     $datas[$langue]['enseigne'] = $magasin->getLib();
  2107.                 }
  2108.             }
  2109.         }
  2111.         if ($datas) {
  2112.             return new JsonResponse($datas, 200);
  2113.         } else {
  2114.             return new JsonResponse(['status' => 400, 'error' => 'Aucune ville'], 400);
  2115.         }
  2116.     }
  2118.     /**
  2119.      * @Route("/magasin/{magasin}/widget/faq", name="factory_api_widget_faq")
  2120.      * @param Request $request
  2121.      * @param Magasin $magasin
  2122.      * @return void
  2123.      * MULTIPAGE
  2124.      */
  2125.     public
  2126.     function widgetFaq(Request $request, Magasin $magasin)
  2127.     {
  2128.         if (!$request->query->has('page')) {
  2129.             return new JsonResponse(['status' => 400, 'error' => 'Paramètre page manquant'], 400);
  2130.         }
  2132.         $page = $request->query->get('page');
  2133.         $page = $this->entityManager->getRepository(WebfactoryPage::class)->findOneBy(['id' => $page]);
  2134.         $pageCustomId = $request->query->get('customPage');
  2135.         $config = $this->webfactoryManager->getFactoryConfig($magasin->getKAdherent());
  2136.         $theme = $config['offer']['theme']['name'];
  2138.         $widget = $this->entityManager->getRepository(WebfactoryWidget::class)->findOneBy(['identifier' => 'faq']);
  2140.         $widgetDetails = $this->entityManager->getRepository(WidgetAbstract::class)->findBy([
  2141.             'magasin' => $magasin->getKAdherent(),
  2142.             'page' => $page->getIdentifier(),
  2143.             'theme' => $theme,
  2144.             'widget' => $widget,
  2145.             'pageCustom' => $pageCustomId
  2146.         ]);
  2148.         $datas['fr'] = [];
  2149.         $datas['nl'] = [];
  2151.         if (!empty($widgetDetails)) {
  2152.             foreach ($widgetDetails as $widgetDetail) {
  2153.                 foreach ($widgetDetail->getFaqContenus() as $key => $question) {
  2154.                     $datas[strtolower($widgetDetail->getLang())][$widgetDetail->getTitre()][$key]['question'] = $question->getQuestion();
  2155.                     $datas[strtolower($widgetDetail->getLang())][$widgetDetail->getTitre()][$key]['reponse'] = $question->getReponse();
  2156.                     $datas[strtolower($widgetDetail->getLang())][$widgetDetail->getTitre()][$key]['created_at'] = $question->getCreatedAt();
  2157.                     $datas[strtolower($widgetDetail->getLang())][$widgetDetail->getTitre()][$key]['updated_at'] = $question->getUpdatedAt();
  2158.                 }
  2159.             }
  2160.         }
  2162.         return new JsonResponse($datas);
  2163.     }
  2165.     /**
  2166.      * @Route("/magasin/{magasin}/image_partner", name="factory_api_image_partner")
  2167.      * @param Request $request
  2168.      * @param Magasin $magasin
  2169.      * @return JsonResponse
  2170.      */
  2171.     public function apiImagesPartners(Magasin $magasin): JsonResponse
  2172.     {
  2173.         $datas['fr'] = [];
  2174.         $datas['nl'] = [];
  2176.         $listImages = $this->entityManager->getRepository(ImagePartner::class)->findBy(['magasin' => $magasin]);
  2177.         foreach ($listImages as $image) {
  2178.             $datas[strtolower($image->getLang())][] = [
  2179.                 'image' => $this->urlPhotosAdh . $magasin->getKAdherent() . '/' . $image->getImage(),
  2180.                 'slot' => $image->getSlot(),
  2181.             ];
  2182.         }
  2183.         return new JsonResponse($datas ?? null, $datas ? 200 : 400);
  2184.     }
  2187.     private
  2188.     function translateHoursNL($day)
  2189.     {
  2190.         if (isset($day['morning']['hours']) && is_string($day['morning']['hours'])) {
  2191.             $day['morning']['hours'] = str_replace("h", "u", $day['morning']['hours']);
  2192.         }
  2193.         if (isset($day['afternoon']['hours']) && is_string($day['afternoon']['hours'])) {
  2194.             $day['afternoon']['hours'] = str_replace("h", "u", $day['afternoon']['hours']);
  2195.         }
  2197.         return $day;
  2198.     }
  2200.     private
  2201.     function forceHttps($url)
  2202.     {
  2203.         // Search the pattern
  2204.         if (!preg_match("~^(?:f|ht)tps?://~i", $url)) {
  2206.             // If not exist then add http
  2207.             $url = "https://" . $url;
  2208.         }
  2210.         // Return the URL
  2211.         return $url;
  2212.     }
  2214. }