src/Controller/TaxonController.php line 202

Open in your IDE?
  1. <?php 
  3. declare(strict_types=1);
  5. namespace App\Controller;
  7. use Symfony\Component\HttpFoundation\Request;
  8. use Symfony\Component\HttpFoundation\Response;
  9. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  10. use Sylius\Component\Locale\Context\LocaleContextInterface;
  11. use Sylius\Component\Taxonomy\Repository\TaxonRepositoryInterface;
  12. use Sylius\Component\Core\Repository\ProductRepositoryInterface;
  13. use Sylius\Component\Core\Repository\ProductVariantRepositoryInterface;
  14. use Sylius\Component\Product\Repository\ProductAttributeValueRepositoryInterface;
  15. use Symfony\Component\HttpKernel\Exception\NotFoundHttpException;
  16. use WhiteOctober\BreadcrumbsBundle\Model\Breadcrumbs;
  17. use App\Services\ElasticSearchService;
  18. use App\Entity\SiteArticle;
  19. use App\Entity\SiteCollection;
  20. use App\Entity\SiteFilterFacet;
  21. use Symfony\Component\HttpFoundation\JsonResponse;
  22. use Twig\Environment;
  23. use Symfony\Contracts\Translation\TranslatorInterface;
  25. class TaxonController extends AbstractController
  26. {
  28.     /**
  29.      * Page catégorie
  30.      */
  31.     public function indexAction(
  32.         Request $request,
  33.         LocaleContextInterface $localeContext,
  34.         TaxonRepositoryInterface $taxonRepository,
  35.         ProductRepositoryInterface $productRepository,
  36.         ProductVariantRepositoryInterface $productVariantRepository,
  37.         ProductAttributeValueRepositoryInterface $productAttributeValueRepository,
  38.         ElasticSearchService $elasticSearch,
  39.         Breadcrumbs $breadcrumbs,
  40.         TranslatorInterface $translator,
  41.         $slug
  42.     ) {
  43.         $em = $this->get('doctrine')->getManager();
  44.         // Récupère la catégorie
  45.         $taxon = $taxonRepository->findOneBySlug($slug, $localeContext->getLocaleCode());
  46.         
  47.         if (empty($taxon)) {
  48.             // return;
  49.             // dump($localeContext->getLocaleCode());
  50.             if (str_contains( $slug, 'nos-produits') && $localeContext->getLocaleCode() == 'en_US') {
  51.                 $taxon = $taxonRepository->findOneBySlug($slug,  'fr_FR');
  52.                 if (!empty($taxon)) {
  53.                     $conn = $em->getConnection();
  54.                     $sql = '
  55.                         SELECT * FROM sylius_taxon_translation
  56.                         WHERE translatable_id = :translatable_id
  57.                         AND locale = "en_US"
  58.                     ';
  59.                     $stmt = $conn->prepare($sql);
  60.                     $resultSet = $stmt->executeQuery(['translatable_id' => $taxon->getId()]);            
  61.                     // returns an array of arrays (i.e. a raw data set)
  62.                     $result = $resultSet->fetchAllAssociative();
  63.                     if(count($result) > 0){
  64.                         return $this->redirectToRoute('sylius_shop_product_index', ['slug' => $result[0]['slug']]);
  65.                     }else{
  66.                         throw new NotFoundHttpException("Cette catégorie produit n'existe pas.");
  67.                     }
  68.                     // return $this->redirect('http://symfony.com/doc');
  69.                 }else{
  70.                     throw new NotFoundHttpException("Cette catégorie produit n'existe pas.");
  71.                 }
  72.             }elseif(str_contains( $slug, 'our-products') && $localeContext->getLocaleCode() == 'fr_FR'){
  73.                 $taxon = $taxonRepository->findOneBySlug($slug,  'en_US');
  74.                 if (!empty($taxon)) {
  75.                     $conn = $em->getConnection();
  76.                     $sql = '
  77.                         SELECT * FROM sylius_taxon_translation
  78.                         WHERE translatable_id = :translatable_id
  79.                         AND locale = "fr_FR"
  80.                     ';
  81.                     $stmt = $conn->prepare($sql);
  82.                     $resultSet = $stmt->executeQuery(['translatable_id' => $taxon->getId()]);            
  83.                     // returns an array of arrays (i.e. a raw data set)
  84.                     $result = $resultSet->fetchAllAssociative();
  85.                     if(count($result) > 0){
  86.                         return $this->redirectToRoute('sylius_shop_product_index', ['slug' => $result[0]['slug']]);
  87.                     }else{
  88.                         throw new NotFoundHttpException("Cette catégorie produit n'existe pas.");
  89.                     }
  90.                     // return $this->redirect('http://symfony.com/doc');
  91.                 }else{
  92.                     throw new NotFoundHttpException("Cette catégorie produit n'existe pas.");
  93.                 }
  94.             }elseif(str_contains( $slug, 'fabrics-and-small-haberdashery') && $localeContext->getLocaleCode() == 'fr_FR'){
  95.                 $taxon = $taxonRepository->findOneBySlug($slug,  'en_US');
  96.                 if (!empty($taxon)) {
  97.                     $conn = $em->getConnection();
  98.                     $sql = '
  99.                         SELECT * FROM sylius_taxon_translation
  100.                         WHERE translatable_id = :translatable_id
  101.                         AND locale = "fr_FR"
  102.                     ';
  103.                     $stmt = $conn->prepare($sql);
  104.                     $resultSet = $stmt->executeQuery(['translatable_id' => $taxon->getId()]);            
  105.                     // returns an array of arrays (i.e. a raw data set)
  106.                     $result = $resultSet->fetchAllAssociative();
  107.                     if(count($result) > 0){
  108.                         return $this->redirectToRoute('sylius_shop_product_index', ['slug' => $result[0]['slug']]);
  109.                     }else{
  110.                         throw new NotFoundHttpException("Cette catégorie produit n'existe pas.");
  111.                     }
  112.                     // return $this->redirect('http://symfony.com/doc');
  113.                 }else{
  114.                     throw new NotFoundHttpException("Cette catégorie produit n'existe pas.");
  115.                 }
  116.             }elseif(str_contains( $slug, 'tissus-et-petite-mercerie') && $localeContext->getLocaleCode() == 'en_US'){
  117.                 $taxon = $taxonRepository->findOneBySlug($slug,  'fr_FR');
  118.                 if (!empty($taxon)) {
  119.                     $conn = $em->getConnection();
  120.                     $sql = '
  121.                         SELECT * FROM sylius_taxon_translation
  122.                         WHERE translatable_id = :translatable_id
  123.                         AND locale = "en_US"
  124.                     ';
  125.                     $stmt = $conn->prepare($sql);
  126.                     $resultSet = $stmt->executeQuery(['translatable_id' => $taxon->getId()]);            
  127.                     // returns an array of arrays (i.e. a raw data set)
  128.                     $result = $resultSet->fetchAllAssociative();
  129.                     if(count($result) > 0){
  130.                         return $this->redirectToRoute('sylius_shop_product_index', ['slug' => $result[0]['slug']]);
  131.                     }else{
  132.                         throw new NotFoundHttpException("Cette catégorie produit n'existe pas.");
  133.                     }
  134.                     // return $this->redirect('http://symfony.com/doc');
  135.                 }else{
  136.                     throw new NotFoundHttpException("Cette catégorie produit n'existe pas.");
  137.                 }
  138.             }else{
  139.                 throw new NotFoundHttpException("Cette catégorie produit n'existe pas.");
  140.             }
  141.             
  142.         }
  144.         // Fil d'ariane
  145.         $taxonParent = $taxon;
  146.         // dump( $taxonParent);
  147.         // dump( $taxon->getRoot());
  148.         while ($taxonParent->getId() != $taxon->getRoot()->getId()) {
  149.             // dump( $taxonParent);
  150.             $breadcrumbs->prependRouteItem($taxonParent, "sylius_shop_product_index", [
  151.                 'slug' => $taxonParent->getSlug()
  152.             ]);
  153.             // dump( $taxonParent);
  154.             $taxonParent = $taxonParent->getParent();
  155.         }
  156.         $breadcrumbs->prependRouteItem($taxon->getRoot()->getName(), "sylius_shop_product_index", [
  157.             'slug' => $taxon->getRoot()->getSlug()
  158.         ]);
  159.         $breadcrumbs->prependRouteItem("sylius.ui.home", "sylius_shop_homepage");
  161.         // Catégorie de "niveau 1" - On affiche uniquement les sous catégories
  162.         if ($taxon->getLevel() == 0) {
  163.            
  164.             // foreach($taxon->getChildren() as $child){
  165.             //     dump($child->getSlug());
  166.             // }
  167.             return $this->render('site_taxon_level1_show.html.twig', [
  168.                 'taxon' => $taxon
  169.             ]);
  170.         }
  172.         $em = $this->get('doctrine')->getManager();
  174.         // Récupère les articles dans la catégorie d'articles associé
  175.         $articles = [];
  176.         if (empty($taxon->getSingleArticleCategory()) == false) {
  177.             $articles = $em->getRepository(SiteArticle::class)
  178.             ->createQueryBuilder('a')
  179.             ->where('a.articleCategory = :category')
  180.             ->andWhere('a.dateDiffusion < :today')
  181.             ->setParameter('today', date("Y-m-d H:i:s"))
  182.             ->orderBy('a.createdAt', 'DESC')
  183.             ->setParameter('category', $taxon->getSingleArticleCategory())
  184.             ->getQuery()
  185.             ->getResult();
  186.         }
  188.         // Récupère tous les filtres à facettes disponible pour 
  189.         // cette "recherche"
  190.         $siteFilterFacets = $em->getRepository(SiteFilterFacet::class)
  191.         ->findBy([
  192.             'enabled' => true
  193.         ], [
  194.             'position' => 'ASC'
  195.         ]);
  197.         // dump($siteFilterFacets);
  198.         $esAggregations = $elasticSearch->getFilterFacetsByTaxon($localeContext->getLocaleCode(), $taxon->getId(), array_map(function ($row) {
  199.             return $row->getId();
  200.         }, $siteFilterFacets));
  202.         dump( $esAggregations);
  204.         $siteFilterShape = [];
  205.         if (count($esAggregations['shape']['buckets']) > 1) {
  206.             $siteFilterShape = $productRepository->findBy([
  207.                 'id' => array_map(function ($row) {
  208.                     return $row['key'];
  209.                 }, $esAggregations['shape']['buckets']),
  210.                 'enabled' => true
  211.             ], [
  212.                 'code' => 'ASC'
  213.             ]);
  214.             usort($siteFilterShape, function ($a, $b) {
  215.                 // dump($a->getTranslation()->getName());
  216.                
  217.                 return strcmp(str_replace('É', 'e',$a->getTranslation()->getName()) , str_replace('É', 'e', $b->getTranslation()->getName()) );
  218.             });
  219.         }
  221.         dump($siteFilterShape);
  223.         // dump($esAggregations) ;
  226.         $siteFilterColor = [];
  227.         if (count($esAggregations['color']['buckets']) > 1) {
  228.             $siteFilterColor = $em->getRepository(SiteCollection::class)->findBy([
  229.                 'productOptionValue' => array_map(function ($row) {
  230.                     return $row['key'];
  231.                 }, $esAggregations['color']['buckets']),
  232.             ]);
  233.         }
  235.         usort($siteFilterColor, function($a, $b) {
  236.             return $a->getDateRelease() < $b->getDateRelease();
  237.         });
  239.         $siteFilterFacetsValues = [];
  240.         foreach ($esAggregations as $keyEsAggregation => $rowEsAggregation) {
  242.             // dump( $keyEsAggregation);
  243.             // dump( $rowEsAggregation);
  244.             if (isset($rowEsAggregation['buckets']) && count($rowEsAggregation['buckets']) > 1) {
  245.                 $siteFilterFacetsValues[$keyEsAggregation] = array_map(function ($row) {
  246.                     return $row['key'];
  247.                 }, $rowEsAggregation['buckets']);
  249.                 // On met dans l'ordre alphabétique
  250.                 sort($siteFilterFacetsValues[$keyEsAggregation]);
  251.             }
  252.         }
  254.         dump( $siteFilterFacetsValues);
  256.         // Conserve que les filtres à facettes disponible pour cette recherche
  257.         $siteFilterFacets = array_filter($siteFilterFacets, function ($row) use (&$siteFilterFacetsValues) {
  258.             return in_array($row->getId(), array_keys($siteFilterFacetsValues));
  259.         });
  262.         $siteFilterBadge = [];
  263.         $siteFilterBadgeVariants = [];
  264.         if (count($esAggregations['badge']['buckets']) > 1) {
  265.             foreach($esAggregations['badge']['buckets'] as $badge){
  266.                 $siteFilterBadge[] = array(
  267.                     'name' => $translator->trans("app.ui.product_callout.".$badge['key']),
  268.                     'id' => $badge['key'],
  269.                 );
  270.             }
  272.             // $siteFilterBadgeVariants = $productVariantRepository->findBy([
  273.             //     'badge' => array_map(function ($row) {
  274.             //         return $row['key'];
  275.             //     }, $esAggregations['badge']['buckets']),
  276.             //     'enabled' => true
  277.             // ], [
  278.             //     'code' => 'ASC'
  279.             // ]);
  280.             
  281.             // if(count($siteFilterBadgeVariants) > 0){
  282.             //     foreach($siteFilterBadgeVariants as $siteFilterBadgeVariant){
  283.             //         $siteFilterBadge[$siteFilterBadgeVariant->getBadge()] = array(
  284.             //             'name' => $translator->trans("app.ui.product_callout.".$siteFilterBadgeVariant->getBadge()),
  285.             //             'id' => $siteFilterBadgeVariant->getBadge(),
  286.             //         );
  287.             //     }
  288.             // }
  290.         }
  292.         // dump( $esAggregations);
  294.         // Récupère tous les produits dans cette catégorie avec 
  295.         // l'applique du filtre à facette et/ou de l'ordre 
  296.         $sorting = $request->query->get('sorting');
  297.         $sortBy = null;
  298.         $sortOrder = null;
  299.         if (is_array($sorting)) {
  300.             $sortBy = key($sorting);
  301.             $sortOrder = $sorting[key($sorting)];
  302.         }
  303.         $selectedFacets = (array) $request->query->get('facets', []);
  304.         $results = $elasticSearch->getElementsByTaxon($localeContext->getLocaleCode(), $taxon->getId(), 0, $selectedFacets, $sortBy, $sortOrder);
  305.         $variants = [];
  306.         if (count($results['hits']['hits']) > 0) {
  307.             $variants = $productVariantRepository->findByIdsAndOrderByFieldId(array_map(function ($row) {
  308.                 return str_ireplace('VARIANT_', '', $row['_id']);
  309.             }, $results['hits']['hits']));
  310.         }
  312.         dump($taxon->getLevel());
  314.         // Récupère les liens pour la partie référencement
  315.         $referencementllinks = [];
  316.         if (!empty($taxon->getSeoLinks())) {
  317.             $referencementllinks = $taxonRepository->findBy([
  318.                 'id' => $taxon->getSeoLinks()
  319.             ]);
  320.         }       
  322.         // Catégorie de "niveau 2"
  323.         if ($taxon->getLevel() == 1) {
  324.             // Récupère les produits avec le badge "nouveau" de la catégorie
  325.             $newestProducts = $productVariantRepository->findNewestEnabledByTaxonsAndLocale(
  326.                 array_merge(
  327.                     [$taxon], 
  328.                     $taxonRepository->findAllChildren($taxon->getCode(), $localeContext->getLocaleCode())
  329.                 ),
  330.                 $localeContext->getLocaleCode(),
  331.                 10 // nombre de produits minimum avec le badge "newest"/"nouveauté"
  332.             );
  334.             // $newestProducts = [];
  336.             // dump($newestProducts );
  337.             // dump($localeContext->getLocaleCode());
  338.             
  339.             if($localeContext->getLocaleCode() == 'fr_FR'){
  340.                 $ctas = empty($taxon->getCtas()) ? $taxon->getRoot()->getCtas() : $taxon->getCtas();
  341.             }else{
  342.                 $ctas = empty($taxon->getCtasEn()) ? $taxon->getRoot()->getCtasEn() : $taxon->getCtasEn();
  343.             }
  344.             
  345.             return $this->render('site_taxon_level2_show.html.twig', [
  346.                 'taxon' => $taxon,
  347.                 'referencementllinks' => $referencementllinks,
  348.                 'variants' => $variants,
  349.                 'articles' => $articles,
  350.                 'newestProducts' => $newestProducts,
  351.                 'ctas' => $ctas,
  352.                 'selectedFacets' => $selectedFacets,
  353.                 'siteFilterShape' => $siteFilterShape,
  354.                 'siteFilterColor' => $siteFilterColor,
  355.                 'siteFilterBadge' => $siteFilterBadge,
  356.                 'siteFilterFacets' => $siteFilterFacets,
  357.                 'siteFilterFacetsValues' => $siteFilterFacetsValues,
  358.                 'siteFilterMinPrice' => $esAggregations[ElasticSearchService::FACET_PRICE_MIN]['value'],
  359.                 'siteFilterMaxPrice' => $esAggregations[ElasticSearchService::FACET_PRICE_MAX]['value'],
  360.                 'maxViewResults' => ElasticSearchService::MAX_SEARCH_RESULTS,
  361.                 'totalResults' => $results['hits']['total']['value'],
  362.                 'filtreUrl' => ''
  363.             ]);
  364.         }
  365.         
  366.            // dump($siteFilterFacets);
  367.         // dump($siteFilterFacetsValues);
  368.         // Catégorie de "niveau 3"
  369.         return $this->render('site_taxon_lastlevel_show.html.twig', [
  370.             'taxon' => $taxon,
  371.             'referencementllinks' => $referencementllinks,
  372.             'variants' => $variants,
  373.             'selectedFacets' => $selectedFacets,
  374.             'siteFilterShape' => $siteFilterShape,
  375.             'siteFilterColor' => $siteFilterColor,
  376.             'siteFilterBadge' => $siteFilterBadge,
  377.             'siteFilterFacets' => $siteFilterFacets,
  378.             'siteFilterFacetsValues' => $siteFilterFacetsValues,
  379.             'siteFilterMinPrice' => $esAggregations[ElasticSearchService::FACET_PRICE_MIN]['value'],
  380.             'siteFilterMaxPrice' => $esAggregations[ElasticSearchService::FACET_PRICE_MAX]['value'],
  381.             'maxViewResults' => ElasticSearchService::MAX_SEARCH_RESULTS,
  382.             'totalResults' => $results['hits']['total']['value'],
  383.             'filtreUrl' => ''
  384.         ]);
  385.     }
  388.     public function ajaxTaxonProductList(
  389.         Request $request, 
  390.         ElasticSearchService $elasticSearch, 
  391.         LocaleContextInterface $localeContext,
  392.         ProductVariantRepositoryInterface $productVariantRepository,
  393.         TaxonRepositoryInterface $taxonRepository,
  394.         Environment $twigEnvironment,
  395.         ProductRepositoryInterface $productRepository,
  396.         TranslatorInterface $translator,
  397.         $taxonId
  398.     ) {
  399.        
  400.         $tstart = microtime(true);
  401.         // Récupère la catégorie
  402.         $taxon = $taxonRepository->findOneById($taxonId);
  403.         
  404.         if (empty($taxon)) {
  405.             return new Response('');
  406.         }
  408.         $t1 = microtime(true);
  410.         // OFFSET
  411.         $offset = intval($request->request->get('offset', 0));
  412.         $offset = min(max($offset, 0), ElasticSearchService::MAX_WINDOW_RESULTS - ElasticSearchService::MAX_SEARCH_RESULTS);
  413.         // SORT BY
  414.         $sorting = $request->request->get('sorting');
  415.         $sortBy = null;
  416.         $sortOrder = null;
  417.         if (is_array($sorting)) {
  418.             $sortBy = key($sorting);
  419.             $sortOrder = $sorting[key($sorting)];
  420.         }
  422.         $selectedFacets = (array) $request->request->get('facets', []);
  423.         $fromPage = $request->query->get('filtre');
  424.         // $selectedFacetsFromPage = array();
  425.         // if(!empty($fromPage)){
  426.         //     // si badge
  427.         //     if (str_contains( $fromPage, 'badge')) {
  428.         //         $filtreArr = explode("=", $fromPage);
  429.         //         $badge = $filtreArr[1];
  430.         //         $selectedFacetsFromPage = ['badge' => $badge];
  431.         //     }else{
  432.         //         $selectedFacetsFromPage = $fromPage;
  433.         //     }
  434.         // }
  435.         // if(count($selectedFacetsFromPage) > 0){
  436.         //     $selectedFacets = array_merge($selectedFacets,$selectedFacetsFromPage);
  437.         // }
  438.         // 
  439.         // dump($selectedFacets);
  440.         // dump($selectedFacetsFromPage);
  441.         
  442.         // dump($selectedFacets);
  443.         $fromCat = $taxon->getId();
  444.         if(isset($selectedFacets['taxons'])){
  445.             foreach($selectedFacets['taxons'] as $taxonId){
  446.                  //si recherche tissu, la cat de base est 222 
  447.                  $is_tissu = array(222, 223, 225, 226, 228, 229, 230, 231, 224, 234, 232, 233, 290, 285, 235);
  448.                  if (in_array($taxonId, $is_tissu)) {
  449.                     $fromCat = 222;
  450.                 }
  451.             }           
  452.         }
  453.         // die($fromCat.'aaa');
  454.         if(count($selectedFacets) == 0 && !empty($fromPage)){
  455.             $results = array();
  456.         }elseif($offset != 0){
  457.             $results = $elasticSearch->getElementsByTaxon($localeContext->getLocaleCode(), $fromCat, $offset, $selectedFacets, $sortBy, $sortOrder, false);
  458.         }else{
  459.             $results = $elasticSearch->getElementsByTaxon($localeContext->getLocaleCode(), $fromCat, $offset, $selectedFacets, $sortBy, $sortOrder, true);
  460.         }
  462.         $t2 = microtime(true);
  465.         // dump($fromCat); 
  466.         $variants = [];
  467.         if (isset($results['hits']) && count($results['hits']['hits']) > 0) {
  468.             $variants = $productVariantRepository->findByIdsAndOrderByFieldId(array_map(function ($row) {
  469.                 return str_ireplace('VARIANT_', '', $row['_id']);
  470.             }, $results['hits']['hits']));
  471.         }
  473.         $t3 = microtime(true);
  475.         $em = $this->get('doctrine')->getManager();
  476.         $siteFilterFacets = $em->getRepository(SiteFilterFacet::class)
  477.         ->findBy([
  478.             'enabled' => true
  479.         ], [
  480.             'position' => 'ASC'
  481.         ]);
  483.         $t4 = microtime(true);
  485.         // dump($siteFilterFacets);
  486.         $esAggregations = $elasticSearch->getFilterFacetsByTaxon($localeContext->getLocaleCode(), $fromCat, array_map(function ($row) {
  487.             return $row->getId();
  488.         }, $siteFilterFacets));
  490.         // dump($taxon);
  491.         // dump($esAggregations) ;
  493.         $siteFilterFacetsValues = [];
  494.         foreach ($esAggregations as $keyEsAggregation => $rowEsAggregation) {
  496.             // dump( $keyEsAggregation);
  497.             // dump( $rowEsAggregation);
  498.             if (isset($rowEsAggregation['buckets']) && count($rowEsAggregation['buckets']) > 1) {
  499.                 $siteFilterFacetsValues[$keyEsAggregation] = array_map(function ($row) {
  500.                     return $row['key'];
  501.                 }, $rowEsAggregation['buckets']);
  503.                 // On met dans l'ordre alphabétique
  504.                 sort($siteFilterFacetsValues[$keyEsAggregation]);
  505.             }
  506.         }
  508.         $t5 = microtime(true);
  510.         // dump($siteFilterFacetsValues);
  511.          // Conserve que les filtres à facettes disponible pour cette recherche
  512.          $siteFilterFacets = array_filter($siteFilterFacets, function ($row) use (&$siteFilterFacetsValues) {
  513.             return in_array($row->getId(), array_keys($siteFilterFacetsValues));
  514.         });
  515.         // dump($siteFilterFacets);
  516.         // dump($variants);
  518.         $t6 = microtime(true);
  520.         $siteFilterShape = [];
  521.         if (count($esAggregations['shape']['buckets']) > 1) {
  522.             $siteFilterShape = $productRepository->findBy([
  523.                 'id' => array_map(function ($row) {
  524.                     return $row['key'];
  525.                 }, $esAggregations['shape']['buckets']),
  526.                 'enabled' => true
  527.             ], [
  528.                 'code' => 'ASC'
  529.             ]);
  530.             usort($siteFilterShape, function ($a, $b) {
  531.                 // dump($a->getTranslation()->getName());
  532.                
  533.                 return strcmp(str_replace('É', 'e',$a->getTranslation()->getName()) , str_replace('É', 'e', $b->getTranslation()->getName()) );
  534.             });
  535.         }
  536.         
  537.         $t7 = microtime(true);
  538.         dump($siteFilterShape);
  540.         $siteFilterColor = [];
  541.         if (count($esAggregations['color']['buckets']) > 1) {
  542.             $siteFilterColor = $em->getRepository(SiteCollection::class)->findBy([
  543.                 'productOptionValue' => array_map(function ($row) {
  544.                     return $row['key'];
  545.                 }, $esAggregations['color']['buckets']),
  546.             ]);
  547.         }
  549.         usort($siteFilterColor, function($a, $b) {
  550.             return $a->getDateRelease() < $b->getDateRelease();
  551.         });
  553.         $t8 = microtime(true);
  555.         $siteFilterBadge = [];
  556.         $siteFilterBadgeVariants = [];
  557.         if (count($esAggregations['badge']['buckets']) > 1) {
  558.             foreach($esAggregations['badge']['buckets'] as $badge){
  559.                 $siteFilterBadge[] = array(
  560.                     'name' => $translator->trans("app.ui.product_callout.".$badge['key']),
  561.                     'id' => $badge['key'],
  562.                 );
  563.             }
  564.             // $siteFilterBadgeVariants = $productVariantRepository->findBy([
  565.             //     'badge' => array_map(function ($row) {
  566.             //         return $row['key'];
  567.             //     }, $esAggregations['badge']['buckets']),
  568.             //     'enabled' => true
  569.             // ], [
  570.             //     'code' => 'ASC'
  571.             // ]);
  572.             
  573.             // if(count($siteFilterBadgeVariants) > 0){
  574.             //     foreach($siteFilterBadgeVariants as $siteFilterBadgeVariant){
  575.             //         $siteFilterBadge[$siteFilterBadgeVariant->getBadge()] = array(
  576.             //             'name' => $translator->trans("app.ui.product_callout.".$siteFilterBadgeVariant->getBadge()),
  577.             //             'id' => $siteFilterBadgeVariant->getBadge(),
  578.             //         );
  579.             //     }
  580.             // }
  582.         }
  583.         dump( $esAggregations);
  584.         dump( $siteFilterBadge);
  586.         $t9 = microtime(true);
  587.         $log = [];
  588.         $log[] = 'Time to retrieve taxon: ' . ($t1 - $tstart) . ' seconds';
  589.         $log[] = 'Time to retrieve elements by taxon: ' . ($t2 - $t1) . ' seconds';
  590.         $log[] = 'Time to retrieve variants: ' . ($t3 - $t2) . ' seconds';
  591.         $log[] = 'Time to retrieve site filter facets: ' . ($t4 - $t3) . ' seconds';
  592.         $log[] = 'Time to retrieve filter facets by taxon: ' . ($t5 - $t4) . ' seconds';
  593.         $log[] = 'Time to filter site filter facets: ' . ($t6 - $t5) . ' seconds';
  594.         $log[] = 'Time to retrieve site filter shape: ' . ($t7 - $t6) . ' seconds';
  595.         $log[] = 'Time to retrieve site filter color: ' . ($t8 - $t7) . ' seconds';
  596.         $log[] = 'Time to retrieve site filter badge: ' . ($t9 - $t8) . ' seconds';
  598.         dump($log);
  599.         // $filtreUrl = '';
  600.         // if(!empty($request->get('filtre')) && !empty($request->get('filtrevalue'))){
  601.         //     $filtreUrl = $request->get('filtre').'/'.$request->get('filtrevalue');
  602.         // }
  604.         if (count($variants) <= 0) {
  605.             return new JsonResponse([
  606.                 'variants' => $twigEnvironment->render('taxons/taxon_list_products_ajax.html.twig', [
  607.                     'variants' => '',
  608.                     'taxon' => $taxon
  609.                 ]),
  610.                 'maxViewResults' => ElasticSearchService::MAX_SEARCH_RESULTS_AJAX,
  611.                 'totalResults' => 0,
  612.                 // 'siteFilterFacets' => $siteFilterFacets
  613.                 'siteFilterFacets' => $twigEnvironment->render('partials/block-facet-filters.html.twig', [
  614.                     'siteFilterFacets' => $siteFilterFacets,
  615.                     'siteFilterShape' => $siteFilterShape,
  616.                     'siteFilterBadgeVariants' => $siteFilterBadgeVariants,
  617.                     'siteFilterColor' => $siteFilterColor,
  618.                     'siteFilterBadge' => $siteFilterBadge,
  619.                     'siteFilterFacetsValues' => $siteFilterFacetsValues,
  620.                     'ajaxUrl'=> $this->get('router')->generate('app_taxon_ajax_list', array('taxonId' => $taxon->getId()))
  621.                 ]),
  622.                 // 'filtreUrl' => $filtreUrl,
  623.             ]); 
  624.         }else{
  625.             if(isset( $selectedFacets['color'])){
  627.                 $shapeMatch = array();
  628.                 foreach($variants as $variant){
  629.                     $shapeMatch[$variant->getProduct()->getId()] = $variant->getProduct()->getId();                  
  630.                 }
  631.         
  632.                 $siteFilterShapeVariants = array();
  633.                 foreach($siteFilterShape as $shape){
  634.                     if (in_array($shape->getId(), $shapeMatch)) {
  635.                         $siteFilterShapeVariants[] = $shape; 
  636.                     }
  637.                 }
  638.     
  639.             }else{
  640.                 $siteFilterShapeVariants = $siteFilterShape;
  641.             }
  642.             
  643.             if(isset( $selectedFacets['shape'])){       
  644.         
  645.                 $collectionMatch = array();
  646.                 foreach($variants as $variant){
  647.                     if($variant->getOptionValues()->first()){
  648.                         $collectionMatch[$variant->getOptionValues()->first()->getId()] = $variant->getOptionValues()->first()->getId();  
  649.                     }
  650.                                    
  651.                 }
  652.     
  653.                 $siteFilterColorVariants = array();
  654.                 foreach($siteFilterColor as $color){
  655.                     if (in_array($color->getProductOptionValue()->getId(), $collectionMatch)) {
  656.                         $siteFilterColorVariants[] = $color; 
  657.                     }
  658.                 }
  659.     
  660.             }else{
  661.                 $siteFilterColorVariants = $siteFilterColor;
  662.             }
  664.             $badgeMatch = array();
  665.             foreach($variants as $variant){
  666.                 $badgeMatch[$variant->getBadge()] = $variant->getBadge();                  
  667.             }
  670.             $siteFilterBadgeVariants = array();
  671.             foreach($siteFilterBadge as $badge){
  672.                 if (in_array($badge['id'], $badgeMatch)) {
  673.                     $siteFilterBadgeVariants[] = $badge; 
  674.                 }
  675.             }
  677.             $filtersMatch = array();
  678.             foreach($variants as $variant){               
  679.                 // $variant->getProduct()->getAttributeValue()
  680.                 foreach($variant->getProduct()->getAttributes() as $attr){                    
  681.                     $value = $attr->getValue();
  682.                     // $filtersMatch[$attr->getAttribute()->getId()][$variant->getProduct()->getId()][$attr->getId()] = $value[0];    
  683.                     if(isset($value[0])){     
  684.                         $filtersMatch[$attr->getAttribute()->getId()][$value[0]] = $attr->getId();        
  685.                     }        
  686.                    
  687.                 }
  688.             }
  690.             $siteFilterOtherVariants = array();
  691.             foreach($siteFilterFacets as $key => $facet){
  692.                 // dump($facet);
  693.                 // dump($facet->getProductAttribute());
  694.                 if (isset($filtersMatch[$facet->getProductAttribute()->getId()])/* && in_array($facet->getProductAttribute()->getOptionValues(), $filtersMatch[$facet->getProductAttribute()->getId()])*/) {
  695.                     $siteFilterOtherVariants[] = $facet; 
  696.                     // foreach($facet->getProductAttribute()->getConfiguration()['choices'] as $key => $choice){
  698.                     // }
  699.                 }
  700.             }
  701.             
  702.             // dump($variants);
  703.             // dump($filtersMatch);
  704.             // dump($siteFilterFacets);
  705.             // dump($siteFilterFacetsValues);
  706.             // // dump($esAggregations);
  707.             // dump($siteFilterOtherVariants);
  708.             // // dump($siteFilterColor);
  709.             // // dump($collectionMatch);
  710.             // // dump($siteFilterColorVariants);
  712.         }
  714.         $tend = microtime(true);
  716.         // dump($t1 - $tstart);
  717.         
  718.         $log[] = 'Total execution time: ' . ($tend - $tstart) . ' seconds';
  719.         dump($log);
  722.         // $logger = $this->get('logger');
  723.         // $logger->info('Time to retrieve taxon: ' . ($t1 - $tstart) . ' seconds');
  724.         // $logger->info('Time to retrieve elements by taxon: ' . ($t2 - $t1) . ' seconds');
  725.         // $logger->info('Time to retrieve variants: ' . ($t3 - $t2) . ' seconds');
  726.         // $logger->info('Time to retrieve site filter facets: ' . ($t4 - $t3) . ' seconds');
  727.         // $logger->info('Time to retrieve filter facets by taxon: ' . ($t5 - $t4) . ' seconds');
  728.         // $logger->info('Time to filter site filter facets: ' . ($t6 - $t5) . ' seconds');
  729.         // $logger->info('Time to retrieve site filter shape: ' . ($t7 - $t6) . ' seconds');
  730.         // $logger->info('Time to retrieve site filter color: ' . ($t8 - $t7) . ' seconds');
  731.         // $logger->info('Time to retrieve site filter badge: ' . ($t9 - $t8) . ' seconds');
  732.         // $logger->info('Total execution time: ' . ($tend - $tstart) . ' seconds');
  734.         // Renvoyer les résultats
  735.         // return $this->render('taxons/taxon_list_products_ajax.html.twig', [
  736.         //     'variants' => $variants,
  737.         //     'taxon' => $taxon
  738.         // ]);
  739.         return new JsonResponse([
  740.             'variants' => $twigEnvironment->render('taxons/taxon_list_products_ajax.html.twig', [
  741.                 'variants' => $variants,
  742.                 'taxon' => $taxon
  743.             ]),
  744.             'maxViewResults' => ElasticSearchService::MAX_SEARCH_RESULTS_AJAX,
  745.             'totalResults' => $results['hits']['total']['value'],
  746.             // 'siteFilterFacets' => $siteFilterFacets
  747.             'siteFilterFacets' => $twigEnvironment->render('partials/block-facet-filters.html.twig', [
  748.                 'siteFilterFacets' => $siteFilterOtherVariants,
  749.                 'siteFilterShape' => $siteFilterShapeVariants,
  750.                 'siteFilterColor' => $siteFilterColorVariants,
  751.                 'siteFilterBadge' => $siteFilterBadgeVariants,
  752.                 'siteFilterFacetsValues' => $siteFilterFacetsValues,
  753.                 'ajaxUrl'=> $this->get('router')->generate('app_taxon_ajax_list', array('taxonId' => $taxon->getId())),                
  754.             ]),
  755.             // 'filtreUrl' => $filtreUrl,
  756.         ]);  
  757.     }
  758.     
  759.     
  761.     public function indexWithFiltreAction(
  762.         Request $request,
  763.         LocaleContextInterface $localeContext,
  764.         TaxonRepositoryInterface $taxonRepository,
  765.         ProductRepositoryInterface $productRepository,
  766.         ProductVariantRepositoryInterface $productVariantRepository,
  767.         ProductAttributeValueRepositoryInterface $productAttributeValueRepository,
  768.         ElasticSearchService $elasticSearch,
  769.         Breadcrumbs $breadcrumbs,
  770.         TranslatorInterface $translator,
  771.         $cat1,
  772.         $cat2
  773.     ) {
  774.       
  775.         $slug = 'nos-produits/'.$cat1.'/'.$cat2;
  776.         //si filtre deja engagé
  777.         $filtreUrl = '';
  778.         if(!empty($request->get('filtre')) && !empty($request->get('filtrevalue'))){
  779.             $filtreUrl = $request->get('filtre').'/'.$request->get('filtrevalue');
  780.         }
  782.         // Récupère la catégorie
  783.         $taxon = $taxonRepository->findOneBySlug($slug, $localeContext->getLocaleCode());
  785.        
  786.         if (empty($taxon)) {
  787.             // return;
  788.             throw new NotFoundHttpException("Cette catégorie produit n'existe pas.");
  789.         }
  791.         // Fil d'ariane
  792.         $taxonParent = $taxon;
  793.         while ($taxonParent != $taxon->getRoot()) {
  794.             $breadcrumbs->prependRouteItem($taxonParent, "sylius_shop_product_index", [
  795.                 'slug' => $taxonParent->getSlug()
  796.             ]);
  797.             $taxonParent = $taxonParent->getParent();
  798.         }
  799.         $breadcrumbs->prependRouteItem($taxon->getRoot()->getName(), "sylius_shop_product_index", [
  800.             'slug' => $taxon->getRoot()->getSlug()
  801.         ]);
  802.         $breadcrumbs->prependRouteItem("sylius.ui.home", "sylius_shop_homepage");
  804.       
  806.         // Catégorie de "niveau 1" - On affiche uniquement les sous catégories
  807.         if ($taxon->getLevel() == 0) {
  808.             return $this->render('site_taxon_level1_show.html.twig', [
  809.                 'taxon' => $taxon
  810.             ]);
  811.         }
  813.         $em = $this->get('doctrine')->getManager();
  815.         // Récupère les articles dans la catégorie d'articles associé
  816.         $articles = [];
  817.         if (empty($taxon->getSingleArticleCategory()) == false) {
  818.             $articles = $em->getRepository(SiteArticle::class)
  819.             ->createQueryBuilder('a')
  820.             ->where('a.articleCategory = :category')
  821.             ->andWhere('a.dateDiffusion < :today')
  822.             ->setParameter('today', date("Y-m-d H:i:s"))
  823.             ->orderBy('a.createdAt', 'DESC')
  824.             ->setParameter('category', $taxon->getSingleArticleCategory())
  825.             ->getQuery()
  826.             ->getResult();
  827.         }
  829.         // Récupère tous les filtres à facettes disponible pour 
  830.         // cette "recherche"
  831.         $siteFilterFacets = $em->getRepository(SiteFilterFacet::class)
  832.         ->findBy([
  833.             'enabled' => true
  834.         ], [
  835.             'position' => 'ASC'
  836.         ]);
  837.         $esAggregations = $elasticSearch->getFilterFacetsByTaxon($localeContext->getLocaleCode(), $taxon->getId(), array_map(function ($row) {
  838.             return $row->getId();
  839.         }, $siteFilterFacets));
  841.         dump($esAggregations) ;
  842.         $siteFilterShape = [];
  843.         if (count($esAggregations['shape']['buckets']) > 1) {
  844.             $siteFilterShape = $productRepository->findBy([
  845.                 'id' => array_map(function ($row) {
  846.                     return $row['key'];
  847.                 }, $esAggregations['shape']['buckets']),
  848.                 'enabled' => true
  849.             ], [
  850.                 'code' => 'ASC'
  851.             ]);
  852.             usort($siteFilterShape, function ($a, $b) {
  853.                 // dump($a->getTranslation()->getName());
  854.                
  855.                 return strcmp(str_replace('É', 'e',$a->getTranslation()->getName()) , str_replace('É', 'e', $b->getTranslation()->getName()) );
  856.             });
  857.         }
  859.         $siteFilterColor = [];
  860.         if (count($esAggregations['color']['buckets']) > 1) {
  861.             $siteFilterColor = $em->getRepository(SiteCollection::class)->findBy([
  862.                 'productOptionValue' => array_map(function ($row) {
  863.                     return $row['key'];
  864.                 }, $esAggregations['color']['buckets']),
  865.             ]);
  866.         }
  868.         usort($siteFilterColor, function($a, $b) {
  869.             return $a->getDateRelease() < $b->getDateRelease();
  870.         });
  872.         $siteFilterBadge = [];
  873.         $siteFilterBadgeVariants = [];
  874.         if (count($esAggregations['badge']['buckets']) > 1) {
  875.             foreach($esAggregations['badge']['buckets'] as $badge){
  876.                 $siteFilterBadge[] = array(
  877.                     'name' => $translator->trans("app.ui.product_callout.".$badge['key']),
  878.                     'id' => $badge['key'],
  879.                 );
  880.             }
  881.             // $siteFilterBadgeVariants = $productVariantRepository->findBy([
  882.             //     'badge' => array_map(function ($row) {
  883.             //         return $row['key'];
  884.             //     }, $esAggregations['badge']['buckets']),
  885.             //     'enabled' => true
  886.             // ], [
  887.             //     'code' => 'ASC'
  888.             // ]);
  889.             
  890.             // if(count($siteFilterBadgeVariants) > 0){
  891.             //     foreach($siteFilterBadgeVariants as $siteFilterBadgeVariant){
  892.             //         $siteFilterBadge[$siteFilterBadgeVariant->getBadge()] = array(
  893.             //             'name' => $translator->trans("app.ui.product_callout.".$siteFilterBadgeVariant->getBadge()),
  894.             //             'id' => $siteFilterBadgeVariant->getBadge(),
  895.             //         );
  896.             //     }
  897.             // }
  899.         }
  901.         $siteFilterFacetsValues = [];
  902.         foreach ($esAggregations as $keyEsAggregation => $rowEsAggregation) {
  903.             if (isset($rowEsAggregation['buckets']) && count($rowEsAggregation['buckets']) > 1) {
  904.                 $siteFilterFacetsValues[$keyEsAggregation] = array_map(function ($row) {
  905.                     return $row['key'];
  906.                 }, $rowEsAggregation['buckets']);
  908.                 // On met dans l'ordre alphabétique
  909.                 sort($siteFilterFacetsValues[$keyEsAggregation]);
  910.             }
  911.         }
  914.         // Conserve que les filtres à facettes disponible pour cette recherche
  915.         $siteFilterFacets = array_filter($siteFilterFacets, function ($row) use (&$siteFilterFacetsValues) {
  916.             return in_array($row->getId(), array_keys($siteFilterFacetsValues));
  917.         });
  919.        
  920.         $noindex = true;
  921.         dump($siteFilterFacetsValues);
  922.         dump($request->get('filtre'));
  923.         //on regarde si le filtre engagé est indexable ou non
  924.         foreach($siteFilterFacetsValues as $key => $facet){
  925.             if(is_int($key)){
  926.                 //carac
  927.                 $filtre = $em->getRepository(SiteFilterFacet::class)->find($key);     
  928.                 // dump($filtre->getProductAttribute());        
  929.                 // dump($request->get('filtre').' ---- '.$this->replaceSpecialChar(strtolower($filtre->getProductAttribute()->getName())));     
  930.                 if($this->replaceSpecialChar(strtolower($filtre->getProductAttribute()->getName())) == $request->get('filtre')){
  931.                     $noindex = !$filtre->getIndexableSeo();
  932.                    
  933.                 }          
  934.             }elseif($key == 'shape' && $request->get('filtre') == "forme"){ //forme
  935.                 $noindex = false;
  936.             }elseif($key == 'color' && $request->get('filtre') == "collection"){  //colelction
  937.                 $noindex = true;
  938.             }elseif($key == 'badge' && $request->get('filtre') == "badge"){  //colelction
  939.                 $noindex = false;
  940.             }
  941.                     
  942.         }
  944.         dump($noindex);
  945.         
  946.         $meta_filtre = ucfirst($request->get('filtre')).' '.$request->get('filtrevalue');           
  947.         
  948.         // dump( $meta_filtre);
  950.         // Récupère tous les produits dans cette catégorie avec 
  951.         // l'applique du filtre à facette et/ou de l'ordre 
  952.         $sorting = $request->query->get('sorting');
  953.         $sortBy = null;
  954.         $sortOrder = null;
  955.         if (is_array($sorting)) {
  956.             $sortBy = key($sorting);
  957.             $sortOrder = $sorting[key($sorting)];
  958.         }
  959.         $selectedFacets = (array) $request->query->get('facets', []);
  960.         $results = $elasticSearch->getElementsByTaxon($localeContext->getLocaleCode(), $taxon->getId(), 0, $selectedFacets, $sortBy, $sortOrder);
  961.         $variants = [];
  962.         if (count($results['hits']['hits']) > 0) {
  963.             $variants = $productVariantRepository->findByIdsAndOrderByFieldId(array_map(function ($row) {
  964.                 return str_ireplace('VARIANT_', '', $row['_id']);
  965.             }, $results['hits']['hits']));
  966.         }
  968.         // Récupère les liens pour la partie référencement
  969.         $referencementllinks = [];
  970.         if (!empty($taxon->getSeoLinks())) {
  971.             $referencementllinks = $taxonRepository->findBy([
  972.                 'id' => $taxon->getSeoLinks()
  973.             ]);
  974.         }       
  976.         
  977.         // return new JsonResponse([
  978.         //     'variants' => $twigEnvironment->render('taxons/taxon_list_products_ajax.html.twig', [
  979.         //         'variants' => $variants,
  980.         //         'taxon' => $taxon
  981.         //     ]),
  982.         //     'maxViewResults' => ElasticSearchService::MAX_SEARCH_RESULTS,
  983.         //     'totalResults' => $results['hits']['total']['value'],
  984.         // ]); 
  986.         
  987.         // Catégorie de "niveau 3"
  988.         return $this->render('site_taxon_lastlevel_show.html.twig', [
  989.             'taxon' => $taxon,
  990.             'referencementllinks' => $referencementllinks,
  991.             'variants' => $variants,
  992.             'selectedFacets' => $selectedFacets,
  993.             'siteFilterShape' => $siteFilterShape,
  994.             'siteFilterColor' => $siteFilterColor,
  995.             'siteFilterBadge' => $siteFilterBadge,
  996.             'siteFilterFacets' => $siteFilterFacets,
  997.             'siteFilterFacetsValues' => $siteFilterFacetsValues,
  998.             'siteFilterMinPrice' => $esAggregations[ElasticSearchService::FACET_PRICE_MIN]['value'],
  999.             'siteFilterMaxPrice' => $esAggregations[ElasticSearchService::FACET_PRICE_MAX]['value'],
  1000.             'maxViewResults' => ElasticSearchService::MAX_SEARCH_RESULTS,
  1001.             'totalResults' => $results['hits']['total']['value'],
  1002.             'filtreUrl' => $filtreUrl,
  1003.             'noindex' =>  $noindex,
  1004.             'metaFiltre' =>  $meta_filtre,
  1005.             
  1006.         ]);
  1007.     }
  1009.     public function tissuLevel2Action(
  1010.         Request $request,
  1011.         LocaleContextInterface $localeContext,
  1012.         TaxonRepositoryInterface $taxonRepository,
  1013.         ProductRepositoryInterface $productRepository,
  1014.         ProductVariantRepositoryInterface $productVariantRepository,
  1015.         ProductAttributeValueRepositoryInterface $productAttributeValueRepository,
  1016.         ElasticSearchService $elasticSearch,
  1017.         Breadcrumbs $breadcrumbs,
  1018.         $cat1,
  1019.     ) {
  1020.        
  1021.         $slug = 'tissus-et-petite-mercerie/'.$cat1;
  1022.         //si filtre deja engagé
  1023.         $filtreUrl = '';
  1024.         if(!empty($request->get('filtre')) && !empty($request->get('filtrevalue'))){
  1025.             $filtreUrl = $request->get('filtre').'/'.$request->get('filtrevalue');
  1026.         }
  1028.         // Récupère la catégorie
  1029.         $taxon = $taxonRepository->findOneBySlug($slug, $localeContext->getLocaleCode());      
  1030.        
  1031.         if (empty($taxon)) {
  1032.             // return;
  1033.             throw new NotFoundHttpException("Cette catégorie produit n'existe pas.");
  1034.         }
  1036.         // Fil d'ariane
  1037.         $taxonParent = $taxon;
  1038.         while ($taxonParent != $taxon->getRoot()) {
  1039.             $breadcrumbs->prependRouteItem($taxonParent, "sylius_shop_product_index", [
  1040.                 'slug' => $taxonParent->getSlug()
  1041.             ]);
  1042.             $taxonParent = $taxonParent->getParent();
  1043.         }
  1044.         $breadcrumbs->prependRouteItem($taxon->getRoot()->getName(), "sylius_shop_product_index", [
  1045.             'slug' => $taxon->getRoot()->getSlug()
  1046.         ]);
  1047.         $breadcrumbs->prependRouteItem("sylius.ui.home", "sylius_shop_homepage");
  1049.         $em = $this->get('doctrine')->getManager();
  1051.         // Récupère les articles dans la catégorie d'articles associé
  1052.         $articles = [];
  1053.         if (empty($taxon->getSingleArticleCategory()) == false) {
  1054.             $articles = $em->getRepository(SiteArticle::class)
  1055.             ->createQueryBuilder('a')
  1056.             ->where('a.articleCategory = :category')
  1057.             ->andWhere('a.dateDiffusion < :today')
  1058.             ->setParameter('today', date("Y-m-d H:i:s"))
  1059.             ->orderBy('a.createdAt', 'DESC')
  1060.             ->setParameter('category', $taxon->getSingleArticleCategory())
  1061.             ->getQuery()
  1062.             ->getResult();
  1063.         }
  1065.         // Récupère tous les filtres à facettes disponible pour 
  1066.         // cette "recherche"
  1067.         $siteFilterFacets = $em->getRepository(SiteFilterFacet::class)
  1068.         ->findBy([
  1069.             'enabled' => true
  1070.         ], [
  1071.             'position' => 'ASC'
  1072.         ]);
  1073.         $esAggregations = $elasticSearch->getFilterFacetsByTaxon($localeContext->getLocaleCode(), $taxon->getId(), array_map(function ($row) {
  1074.             return $row->getId();
  1075.         }, $siteFilterFacets));
  1077.       
  1078.         $siteFilterShape = [];
  1079.         if (count($esAggregations['shape']['buckets']) > 1) {
  1080.             $siteFilterShape = $productRepository->findBy([
  1081.                 'id' => array_map(function ($row) {
  1082.                     return $row['key'];
  1083.                 }, $esAggregations['shape']['buckets']),
  1084.                 'enabled' => true
  1085.             ], [
  1086.                 'code' => 'ASC'
  1087.             ]);
  1088.             usort($siteFilterShape, function ($a, $b) {
  1089.                 // dump($a->getTranslation()->getName());
  1090.                
  1091.                 return strcmp(str_replace('É', 'e',$a->getTranslation()->getName()) , str_replace('É', 'e', $b->getTranslation()->getName()) );
  1092.             });
  1093.         }
  1095.         $siteFilterColor = [];
  1096.         if (count($esAggregations['color']['buckets']) > 1) {
  1097.             $siteFilterColor = $em->getRepository(SiteCollection::class)->findBy([
  1098.                 'productOptionValue' => array_map(function ($row) {
  1099.                     return $row['key'];
  1100.                 }, $esAggregations['color']['buckets']),
  1101.             ]);
  1102.         }
  1104.         usort($siteFilterColor, function($a, $b) {
  1105.             return $a->getDateRelease() < $b->getDateRelease();
  1106.         });
  1108.         $siteFilterFacetsValues = [];
  1109.         foreach ($esAggregations as $keyEsAggregation => $rowEsAggregation) {
  1110.             if (isset($rowEsAggregation['buckets']) && count($rowEsAggregation['buckets']) > 1) {
  1111.                 $siteFilterFacetsValues[$keyEsAggregation] = array_map(function ($row) {
  1112.                     return $row['key'];
  1113.                 }, $rowEsAggregation['buckets']);
  1115.                 // On met dans l'ordre alphabétique
  1116.                 sort($siteFilterFacetsValues[$keyEsAggregation]);
  1117.             }
  1118.         }
  1120.         // dump($siteFilterFacetsValues) ;
  1122.         // Conserve que les filtres à facettes disponible pour cette recherche
  1123.         $siteFilterFacets = array_filter($siteFilterFacets, function ($row) use (&$siteFilterFacetsValues) {
  1124.             return in_array($row->getId(), array_keys($siteFilterFacetsValues));
  1125.         });
  1127.       
  1128.         // Récupère tous les produits dans cette catégorie avec 
  1129.         // l'applique du filtre à facette et/ou de l'ordre 
  1130.         $sorting = $request->query->get('sorting');
  1131.         $sortBy = null;
  1132.         $sortOrder = null;
  1133.         if (is_array($sorting)) {
  1134.             $sortBy = key($sorting);
  1135.             $sortOrder = $sorting[key($sorting)];
  1136.         }
  1137.         $selectedFacets = (array) $request->query->get('facets', []);
  1138.         $results = $elasticSearch->getElementsByTaxon($localeContext->getLocaleCode(), $taxon->getId(), 0, $selectedFacets, $sortBy, $sortOrder);
  1139.         $variants = [];
  1140.         if (count($results['hits']['hits']) > 0) {
  1141.             $variants = $productVariantRepository->findByIdsAndOrderByFieldId(array_map(function ($row) {
  1142.                 return str_ireplace('VARIANT_', '', $row['_id']);
  1143.             }, $results['hits']['hits']));
  1144.         }
  1146.         // Récupère les liens pour la partie référencement
  1147.         $referencementllinks = [];
  1148.         if (!empty($taxon->getSeoLinks())) {
  1149.             $referencementllinks = $taxonRepository->findBy([
  1150.                 'id' => $taxon->getSeoLinks()
  1151.             ]);
  1152.         }       
  1154.         return $this->render('site_taxon_level2_show.html.twig', [
  1155.             'taxon' => $taxon,
  1156.             'referencementllinks' => $referencementllinks,
  1157.             'variants' => $variants,
  1158.             'articles' => $articles,
  1159.             'selectedFacets' => $selectedFacets,
  1160.             'siteFilterShape' => $siteFilterShape,
  1161.             'siteFilterColor' => $siteFilterColor,
  1162.             'siteFilterFacets' => $siteFilterFacets,
  1163.             'siteFilterFacetsValues' => $siteFilterFacetsValues,
  1164.             'siteFilterMinPrice' => $esAggregations[ElasticSearchService::FACET_PRICE_MIN]['value'],
  1165.             'siteFilterMaxPrice' => $esAggregations[ElasticSearchService::FACET_PRICE_MAX]['value'],
  1166.             'maxViewResults' => ElasticSearchService::MAX_SEARCH_RESULTS,
  1167.             'totalResults' => $results['hits']['total']['value'],
  1168.             'filtreUrl' => $filtreUrl
  1169.         ]);
  1170.     }
  1172.     public function tissuLevel3Action(
  1173.         Request $request,
  1174.         LocaleContextInterface $localeContext,
  1175.         TaxonRepositoryInterface $taxonRepository,
  1176.         ProductRepositoryInterface $productRepository,
  1177.         ProductVariantRepositoryInterface $productVariantRepository,
  1178.         ProductAttributeValueRepositoryInterface $productAttributeValueRepository,
  1179.         ElasticSearchService $elasticSearch,
  1180.         Breadcrumbs $breadcrumbs,
  1181.         TranslatorInterface $translator,
  1182.         $cat1,
  1183.         $cat2,
  1184.     ) {
  1185.       
  1186.         
  1187.         $slug = 'tissus-et-petite-mercerie/'.$cat1.'/'.$cat2;
  1188.         //si filtre deja engagé
  1189.         $filtreUrl = '';
  1190.         if(!empty($request->get('filtre')) && !empty($request->get('filtrevalue'))){
  1191.             $filtreUrl = $request->get('filtre').'/'.$request->get('filtrevalue');
  1192.         }
  1194.         // Récupère la catégorie
  1195.         $taxon = $taxonRepository->findOneBySlug($slug, $localeContext->getLocaleCode());      
  1196.        
  1197.         if (empty($taxon)) {
  1198.             // return;
  1199.             throw new NotFoundHttpException("Cette catégorie produit n'existe pas.");
  1200.         }
  1202.         // Fil d'ariane
  1203.         $taxonParent = $taxon;
  1204.         while ($taxonParent != $taxon->getRoot()) {
  1205.             $breadcrumbs->prependRouteItem($taxonParent, "sylius_shop_product_index", [
  1206.                 'slug' => $taxonParent->getSlug()
  1207.             ]);
  1208.             $taxonParent = $taxonParent->getParent();
  1209.         }
  1210.         $breadcrumbs->prependRouteItem($taxon->getRoot()->getName(), "sylius_shop_product_index", [
  1211.             'slug' => $taxon->getRoot()->getSlug()
  1212.         ]);
  1213.         $breadcrumbs->prependRouteItem("sylius.ui.home", "sylius_shop_homepage");
  1215.         $em = $this->get('doctrine')->getManager();
  1217.         // Récupère les articles dans la catégorie d'articles associé
  1218.         $articles = [];
  1219.         if (empty($taxon->getSingleArticleCategory()) == false) {
  1220.             $articles = $em->getRepository(SiteArticle::class)
  1221.             ->createQueryBuilder('a')
  1222.             ->where('a.articleCategory = :category')
  1223.             ->andWhere('a.dateDiffusion < :today')
  1224.             ->setParameter('today', date("Y-m-d H:i:s"))
  1225.             ->orderBy('a.createdAt', 'DESC')
  1226.             ->setParameter('category', $taxon->getSingleArticleCategory())
  1227.             ->getQuery()
  1228.             ->getResult();
  1229.         }
  1231.         // Récupère tous les filtres à facettes disponible pour 
  1232.         // cette "recherche"
  1233.         $siteFilterFacets = $em->getRepository(SiteFilterFacet::class)
  1234.         ->findBy([
  1235.             'enabled' => true
  1236.         ], [
  1237.             'position' => 'ASC'
  1238.         ]);
  1239.         $esAggregations = $elasticSearch->getFilterFacetsByTaxon($localeContext->getLocaleCode(), $taxon->getId(), array_map(function ($row) {
  1240.             return $row->getId();
  1241.         }, $siteFilterFacets));
  1243.       
  1244.         $siteFilterShape = [];
  1245.         if (count($esAggregations['shape']['buckets']) > 1) {
  1246.             $siteFilterShape = $productRepository->findBy([
  1247.                 'id' => array_map(function ($row) {
  1248.                     return $row['key'];
  1249.                 }, $esAggregations['shape']['buckets']),
  1250.                 'enabled' => true
  1251.             ], [
  1252.                 'code' => 'ASC'
  1253.             ]);
  1254.             usort($siteFilterShape, function ($a, $b) {
  1255.                 // dump($a->getTranslation()->getName());
  1256.                
  1257.                 return strcmp(str_replace('É', 'e',$a->getTranslation()->getName()) , str_replace('É', 'e', $b->getTranslation()->getName()) );
  1258.             });
  1259.         }
  1261.         $siteFilterColor = [];
  1262.         if (count($esAggregations['color']['buckets']) > 1) {
  1263.             $siteFilterColor = $em->getRepository(SiteCollection::class)->findBy([
  1264.                 'productOptionValue' => array_map(function ($row) {
  1265.                     return $row['key'];
  1266.                 }, $esAggregations['color']['buckets']),
  1267.             ]);
  1268.         }
  1270.         usort($siteFilterColor, function($a, $b) {
  1271.             return $a->getDateRelease() < $b->getDateRelease();
  1272.         });
  1274.         $siteFilterFacetsValues = [];
  1275.         foreach ($esAggregations as $keyEsAggregation => $rowEsAggregation) {
  1276.             if (isset($rowEsAggregation['buckets']) && count($rowEsAggregation['buckets']) > 1) {
  1277.                 $siteFilterFacetsValues[$keyEsAggregation] = array_map(function ($row) {
  1278.                     return $row['key'];
  1279.                 }, $rowEsAggregation['buckets']);
  1281.                 // On met dans l'ordre alphabétique
  1282.                 sort($siteFilterFacetsValues[$keyEsAggregation]);
  1283.             }
  1284.         }
  1286.         // dump($siteFilterFacetsValues) ;
  1288.         // Conserve que les filtres à facettes disponible pour cette recherche
  1289.         $siteFilterFacets = array_filter($siteFilterFacets, function ($row) use (&$siteFilterFacetsValues) {
  1290.             return in_array($row->getId(), array_keys($siteFilterFacetsValues));
  1291.         });
  1293.         $siteFilterBadge = [];
  1294.         $siteFilterBadgeVariants = [];
  1295.         if (count($esAggregations['badge']['buckets']) > 1) {
  1296.             $siteFilterBadgeVariants = $productVariantRepository->findBy([
  1297.                 'badge' => array_map(function ($row) {
  1298.                     return $row['key'];
  1299.                 }, $esAggregations['badge']['buckets']),
  1300.                 'enabled' => true
  1301.             ], [
  1302.                 'code' => 'ASC'
  1303.             ]);
  1304.             
  1305.             if(count($siteFilterBadgeVariants) > 0){
  1306.                 foreach($siteFilterBadgeVariants as $siteFilterBadgeVariant){
  1307.                     $siteFilterBadge[$siteFilterBadgeVariant->getBadge()] = array(
  1308.                         'name' => $translator->trans("app.ui.product_callout.".$siteFilterBadgeVariant->getBadge()),
  1309.                         'id' => $siteFilterBadgeVariant->getBadge(),
  1310.                     );
  1311.                 }
  1312.             }
  1314.         }
  1315.       
  1316.         // Récupère tous les produits dans cette catégorie avec 
  1317.         // l'applique du filtre à facette et/ou de l'ordre 
  1318.         $sorting = $request->query->get('sorting');
  1319.         $sortBy = null;
  1320.         $sortOrder = null;
  1321.         if (is_array($sorting)) {
  1322.             $sortBy = key($sorting);
  1323.             $sortOrder = $sorting[key($sorting)];
  1324.         }
  1325.         $selectedFacets = (array) $request->query->get('facets', []);
  1326.         $results = $elasticSearch->getElementsByTaxon($localeContext->getLocaleCode(), $taxon->getId(), 0, $selectedFacets, $sortBy, $sortOrder);
  1327.         $variants = [];
  1328.         if (count($results['hits']['hits']) > 0) {
  1329.             $variants = $productVariantRepository->findByIdsAndOrderByFieldId(array_map(function ($row) {
  1330.                 return str_ireplace('VARIANT_', '', $row['_id']);
  1331.             }, $results['hits']['hits']));
  1332.         }
  1334.         // Récupère les liens pour la partie référencement
  1335.         $referencementllinks = [];
  1336.         if (!empty($taxon->getSeoLinks())) {
  1337.             $referencementllinks = $taxonRepository->findBy([
  1338.                 'id' => $taxon->getSeoLinks()
  1339.             ]);
  1340.         }       
  1342.         return $this->render('site_taxon_level2_show.html.twig', [
  1343.             'taxon' => $taxon,
  1344.             'referencementllinks' => $referencementllinks,
  1345.             'variants' => $variants,
  1346.             'articles' => $articles,
  1347.             'selectedFacets' => $selectedFacets,
  1348.             'siteFilterShape' => $siteFilterShape,
  1349.             'siteFilterColor' => $siteFilterColor,
  1350.             'siteFilterFacets' => $siteFilterFacets,
  1351.             'siteFilterFacetsValues' => $siteFilterFacetsValues,
  1352.             'siteFilterMinPrice' => $esAggregations[ElasticSearchService::FACET_PRICE_MIN]['value'],
  1353.             'siteFilterMaxPrice' => $esAggregations[ElasticSearchService::FACET_PRICE_MAX]['value'],
  1354.             'maxViewResults' => ElasticSearchService::MAX_SEARCH_RESULTS,
  1355.             'totalResults' => $results['hits']['total']['value'],
  1356.             'filtreUrl' => $filtreUrl
  1357.         ]);
  1358.     }
  1360.     function replaceSpecialChar($str) {
  1362.         $ch0 = array( 
  1363.                 "œ"=>"oe",
  1364.                 "Œ"=>"OE",
  1365.                 "æ"=>"ae",
  1366.                 "Æ"=>"AE",
  1367.                 "À" => "A",
  1368.                 "Á" => "A",
  1369.                 "Â" => "A",
  1370.                 "à" => "A",
  1371.                 "Ä" => "A",
  1372.                 "Å" => "A",
  1373.                 "&#256;" => "A",
  1374.                 "&#258;" => "A",
  1375.                 "&#461;" => "A",
  1376.                 "&#7840;" => "A",
  1377.                 "&#7842;" => "A",
  1378.                 "&#7844;" => "A",
  1379.                 "&#7846;" => "A",
  1380.                 "&#7848;" => "A",
  1381.                 "&#7850;" => "A",
  1382.                 "&#7852;" => "A",
  1383.                 "&#7854;" => "A",
  1384.                 "&#7856;" => "A",
  1385.                 "&#7858;" => "A",
  1386.                 "&#7860;" => "A",
  1387.                 "&#7862;" => "A",
  1388.                 "&#506;" => "A",
  1389.                 "&#260;" => "A",
  1390.                 "à" => "a",
  1391.                 "á" => "a",
  1392.                 "â" => "a",
  1393.                 "à" => "a",
  1394.                 "ä" => "a",
  1395.                 "å" => "a",
  1396.                 "&#257;" => "a",
  1397.                 "&#259;" => "a",
  1398.                 "&#462;" => "a",
  1399.                 "&#7841;" => "a",
  1400.                 "&#7843;" => "a",
  1401.                 "&#7845;" => "a",
  1402.                 "&#7847;" => "a",
  1403.                 "&#7849;" => "a",
  1404.                 "&#7851;" => "a",
  1405.                 "&#7853;" => "a",
  1406.                 "&#7855;" => "a",
  1407.                 "&#7857;" => "a",
  1408.                 "&#7859;" => "a",
  1409.                 "&#7861;" => "a",
  1410.                 "&#7863;" => "a",
  1411.                 "&#507;" => "a",
  1412.                 "&#261;" => "a",
  1413.                 "Ç" => "C",
  1414.                 "&#262;" => "C",
  1415.                 "&#264;" => "C",
  1416.                 "&#266;" => "C",
  1417.                 "&#268;" => "C",
  1418.                 "ç" => "c",
  1419.                 "&#263;" => "c",
  1420.                 "&#265;" => "c",
  1421.                 "&#267;" => "c",
  1422.                 "&#269;" => "c",
  1423.                 "Ð" => "D",
  1424.                 "&#270;" => "D",
  1425.                 "&#272;" => "D",
  1426.                 "&#271;" => "d",
  1427.                 "&#273;" => "d",
  1428.                 "È" => "E",
  1429.                 "É" => "E",
  1430.                 "Ê" => "E",
  1431.                 "Ë" => "E",
  1432.                 "&#274;" => "E",
  1433.                 "&#276;" => "E",
  1434.                 "&#278;" => "E",
  1435.                 "&#280;" => "E",
  1436.                 "&#282;" => "E",
  1437.                 "&#7864;" => "E",
  1438.                 "&#7866;" => "E",
  1439.                 "&#7868;" => "E",
  1440.                 "&#7870;" => "E",
  1441.                 "&#7872;" => "E",
  1442.                 "&#7874;" => "E",
  1443.                 "&#7876;" => "E",
  1444.                 "&#7878;" => "E",
  1445.                 "è" => "e",
  1446.                 "é" => "e",
  1447.                 "ê" => "e",
  1448.                 "ë" => "e",
  1449.                 "&#275;" => "e",
  1450.                 "&#277;" => "e",
  1451.                 "&#279;" => "e",
  1452.                 "&#281;" => "e",
  1453.                 "&#283;" => "e",
  1454.                 "&#7865;" => "e",
  1455.                 "&#7867;" => "e",
  1456.                 "&#7869;" => "e",
  1457.                 "&#7871;" => "e",
  1458.                 "&#7873;" => "e",
  1459.                 "&#7875;" => "e",
  1460.                 "&#7877;" => "e",
  1461.                 "&#7879;" => "e",
  1462.                 "&#284;" => "G",
  1463.                 "&#286;" => "G",
  1464.                 "&#288;" => "G",
  1465.                 "&#290;" => "G",
  1466.                 "&#285;" => "g",
  1467.                 "&#287;" => "g",
  1468.                 "&#289;" => "g",
  1469.                 "&#291;" => "g",
  1470.                 "&#292;" => "H",
  1471.                 "&#294;" => "H",
  1472.                 "&#293;" => "h",
  1473.                 "&#295;" => "h",
  1474.                 "Ì" => "I",
  1475.                 "Í" => "I",
  1476.                 "Î" => "I",
  1477.                 "Ï" => "I",
  1478.                 "&#296;" => "I",
  1479.                 "&#298;" => "I",
  1480.                 "&#300;" => "I",
  1481.                 "&#302;" => "I",
  1482.                 "&#304;" => "I",
  1483.                 "&#463;" => "I",
  1484.                 "&#7880;" => "I",
  1485.                 "&#7882;" => "I",
  1486.                 "&#308;" => "J",
  1487.                 "&#309;" => "j",
  1488.                 "&#310;" => "K",
  1489.                 "&#311;" => "k",
  1490.                 "&#313;" => "L",
  1491.                 "&#315;" => "L",
  1492.                 "&#317;" => "L",
  1493.                 "&#319;" => "L",
  1494.                 "&#321;" => "L",
  1495.                 "&#314;" => "l",
  1496.                 "&#316;" => "l",
  1497.                 "&#318;" => "l",
  1498.                 "&#320;" => "l",
  1499.                 "&#322;" => "l",
  1500.                 "Ñ" => "N",
  1501.                 "&#323;" => "N",
  1502.                 "&#325;" => "N",
  1503.                 "&#327;" => "N",
  1504.                 "ñ" => "n",
  1505.                 "&#324;" => "n",
  1506.                 "&#326;" => "n",
  1507.                 "&#328;" => "n",
  1508.                 "&#329;" => "n",
  1509.                 "Ò" => "O",
  1510.                 "Ó" => "O",
  1511.                 "Ô" => "O",
  1512.                 "Õ" => "O",
  1513.                 "Ö" => "O",
  1514.                 "Ø" => "O",
  1515.                 "&#332;" => "O",
  1516.                 "&#334;" => "O",
  1517.                 "&#336;" => "O",
  1518.                 "&#416;" => "O",
  1519.                 "&#465;" => "O",
  1520.                 "&#510;" => "O",
  1521.                 "&#7884;" => "O",
  1522.                 "&#7886;" => "O",
  1523.                 "&#7888;" => "O",
  1524.                 "&#7890;" => "O",
  1525.                 "&#7892;" => "O",
  1526.                 "&#7894;" => "O",
  1527.                 "&#7896;" => "O",
  1528.                 "&#7898;" => "O",
  1529.                 "&#7900;" => "O",
  1530.                 "&#7902;" => "O",
  1531.                 "&#7904;" => "O",
  1532.                 "&#7906;" => "O",
  1533.                 "ò" => "o",
  1534.                 "ó" => "o",
  1535.                 "ô" => "o",
  1536.                 "õ" => "o",
  1537.                 "ö" => "o",
  1538.                 "ø" => "o",
  1539.                 "&#333;" => "o",
  1540.                 "&#335;" => "o",
  1541.                 "&#337;" => "o",
  1542.                 "&#417;" => "o",
  1543.                 "&#466;" => "o",
  1544.                 "&#511;" => "o",
  1545.                 "&#7885;" => "o",
  1546.                 "&#7887;" => "o",
  1547.                 "&#7889;" => "o",
  1548.                 "&#7891;" => "o",
  1549.                 "&#7893;" => "o",
  1550.                 "&#7895;" => "o",
  1551.                 "&#7897;" => "o",
  1552.                 "&#7899;" => "o",
  1553.                 "&#7901;" => "o",
  1554.                 "&#7903;" => "o",
  1555.                 "&#7905;" => "o",
  1556.                 "&#7907;" => "o",
  1557.                 "ð" => "o",
  1558.                 "&#340;" => "R",
  1559.                 "&#342;" => "R",
  1560.                 "&#344;" => "R",
  1561.                 "&#341;" => "r",
  1562.                 "&#343;" => "r",
  1563.                 "&#345;" => "r",
  1564.                 "&#346;" => "S",
  1565.                 "&#348;" => "S",
  1566.                 "&#350;" => "S",
  1567.                 "&#347;" => "s",
  1568.                 "&#349;" => "s",
  1569.                 "&#351;" => "s",
  1570.                 "&#354;" => "T",
  1571.                 "&#356;" => "T",
  1572.                 "&#358;" => "T",
  1573.                 "&#355;" => "t",
  1574.                 "&#357;" => "t",
  1575.                 "&#359;" => "t",
  1576.                 "Ù" => "U",
  1577.                 "Ú" => "U",
  1578.                 "Û" => "U",
  1579.                 "Ü" => "U",
  1580.                 "&#360;" => "U",
  1581.                 "&#362;" => "U",
  1582.                 "&#364;" => "U",
  1583.                 "&#366;" => "U",
  1584.                 "&#368;" => "U",
  1585.                 "&#370;" => "U",
  1586.                 "&#431;" => "U",
  1587.                 "&#467;" => "U",
  1588.                 "&#469;" => "U",
  1589.                 "&#471;" => "U",
  1590.                 "&#473;" => "U",
  1591.                 "&#475;" => "U",
  1592.                 "&#7908;" => "U",
  1593.                 "&#7910;" => "U",
  1594.                 "&#7912;" => "U",
  1595.                 "&#7914;" => "U",
  1596.                 "&#7916;" => "U",
  1597.                 "&#7918;" => "U",
  1598.                 "&#7920;" => "U",
  1599.                 "ù" => "u",
  1600.                 "ú" => "u",
  1601.                 "û" => "u",
  1602.                 "ü" => "u",
  1603.                 "&#361;" => "u",
  1604.                 "&#363;" => "u",
  1605.                 "&#365;" => "u",
  1606.                 "&#367;" => "u",
  1607.                 "&#369;" => "u",
  1608.                 "&#371;" => "u",
  1609.                 "&#432;" => "u",
  1610.                 "&#468;" => "u",
  1611.                 "&#470;" => "u",
  1612.                 "&#472;" => "u",
  1613.                 "&#474;" => "u",
  1614.                 "&#476;" => "u",
  1615.                 "&#7909;" => "u",
  1616.                 "&#7911;" => "u",
  1617.                 "&#7913;" => "u",
  1618.                 "&#7915;" => "u",
  1619.                 "&#7917;" => "u",
  1620.                 "&#7919;" => "u",
  1621.                 "&#7921;" => "u",
  1622.                 "&#372;" => "W",
  1623.                 "&#7808;" => "W",
  1624.                 "&#7810;" => "W",
  1625.                 "&#7812;" => "W",
  1626.                 "&#373;" => "w",
  1627.                 "&#7809;" => "w",
  1628.                 "&#7811;" => "w",
  1629.                 "&#7813;" => "w",
  1630.                 "Ý" => "Y",
  1631.                 "&#374;" => "Y",
  1632.                 "?" => "Y",
  1633.                 "&#7922;" => "Y",
  1634.                 "&#7928;" => "Y",
  1635.                 "&#7926;" => "Y",
  1636.                 "&#7924;" => "Y",
  1637.                 "ý" => "y",
  1638.                 "ÿ" => "y",
  1639.                 "&#375;" => "y",
  1640.                 "&#7929;" => "y",
  1641.                 "&#7925;" => "y",
  1642.                 "&#7927;" => "y",
  1643.                 "&#7923;" => "y",
  1644.                 "&#377;" => "Z",
  1645.                 "&#379;" => "Z",
  1646.                 '+'         =>'',
  1647.                 "'"        =>'',
  1648.                 ' '        =>'-',
  1649.                 '.'        =>'-',
  1650.                 );
  1651.             $str = strtr($str,$ch0);
  1652.             return $str;
  1653.         
  1655.     }
  1657. }