src/Controller/ProductController.php line 41

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use AdvancedObjectSearchBundle\Service;
  6. use App\Service\ElasticSearchService;
  7. use Carbon\Carbon;
  8. use Pimcore\Controller\FrontendController;
  9. use Pimcore\Model\DataObject\Book;
  10. use Pimcore\Model\DataObject\OnixProduct;
  11. use Pimcore\Model\DataObject\ClassDefinition;
  12. use Pimcore\Model\DataObject\Fieldcollection;
  13. use Pimcore\Model\DataObject\InventoryItem;
  14. use Pimcore\Model\DataObject\Serie;
  15. use Pimcore\Model\Document;
  16. use Symfony\Component\HttpKernel\Exception\NotFoundHttpException;
  17. use Symfony\Component\HttpFoundation\Request;
  18. use Symfony\Component\HttpFoundation\Response;
  19. use App\Service\DolpoSearchService;
  20. use Symfony\Component\Routing\Annotation\Route; 
  22. use function PHPUnit\Framework\isEmpty;
  24. class ProductController extends FrontendController
  25. {
  27.     private $map_availability=[
  28.         'InStock'=>"<p class='edition__shipping shipping-48h'>  En stock </a>",
  29.         'POD'=>"<p class='edition__shipping shipping-purple'> Imprimé sur demande </a>",
  30.         'NotYetAvailable'=>"<p class='edition__shipping shipping-purple'> Pas encore disponible </a>",
  31.         'TemporaryUnavailable'=>"<p class='edition__shipping shipping-purple'> Momentanément indisponible éditeur </a>",
  32.         'PublisherOutOfStock'=>"<p class='edition__shipping shipping-nondis'> Rupture éditeur </a>",
  33.         'PublisherReprint'=>"<p class='edition__shipping shipping-nondis'> En Réimpression </a>",
  34.         'EditorUnavailable'=>"<p class='edition__shipping shipping-nondis'>Indisponible éditeur</p>",
  35.         'Retired'=>"<p class='edition__shipping shipping-nondis'>Retiré de la vente</p>",
  36.         'EditorNoCommand'=>"<p class='edition__shipping shipping-nondis'>Pas de commande pour cet éditeur</p>"
  38.     ];
  41.     public function editionPageAction(Request $request, Document $document, DolpoSearchService $dolpoSearchService): Response
  42.     {
  43.         $param=[];
  44.         if ($request->get('isbn')){
  45.             $edition = OnixProduct::getByEan($request->get('isbn'),['limit' => 1]);
  46.             if(empty($edition)){
  47.                 throw new NotFoundHttpException('Edition needed');
  48.             }
  49.             else{
  50.                 $BookDolpoId = $edition->getDolpoId();
  51.             }
  53.             if (!empty($BookDolpoId)) {
  54.                 // Redirige vers la page du livre
  55.                 return $this->redirectToRoute('product', ['dolpoId' => $BookDolpoId, 'productId' => $edition->getId()]);
  56.             }
  57.             
  59.             
  60.             $param['item'] = $edition; 
  61.             //dump($edition->getAuthors());
  62.             
  63.             // Affectation des valeurs aux propriétés de l'objet
  64.             $availabilityLabel = $edition->getAvailabilityLabel();
  66.             //isAdminUser
  67.             $user = \Pimcore\Tool\Session::getReadonly()->get("user");
  68.             $isPimcoreAdminUser= ($user !== null);
  69.             
  70.             $param['isPimcoreAdminUser'] = $isPimcoreAdminUser;
  71.             $param['availabilityLabel'] = $availabilityLabel;
  72.             $param['document'] = \Pimcore\Model\Document::getById(1);
  74.             $param['document']->setTitle($edition->getLongTitle());
  75.             $param['document']->setDescription(\App\Service\Website\Tool\Text::cutStringRespectingWhitespace($edition->getDescription(),250));
  77.             $prodcutFormats = ClassDefinition::getById($edition->getClassId())->getFieldDefinition('Format')->getOptions();
  79.             foreach ($prodcutFormats as $productFormat) {
  80.                 $prodcutFormatArray[$productFormat['value']] = $productFormat['key'];
  81.             }
  83.             $param['prodcutFormats'] = $prodcutFormatArray;
  85.             return $this->render('product/productEdition.html.twig', $param);
  86.         }
  87.     }
  88.    
  89.     public function productPageAction(Request $request, Document $document, DolpoSearchService $dolpoSearchService): Response
  90.     {
  91.         $param = [];
  92.         if ($request->get('dolpoId')) {
  93.             $item = Book::getByDolpoId($request->get('dolpoId'));
  94.             $book = $item->load();
  95.             $collectionItem = null;
  96.             $title = null;
  97.             $subtitle = null;
  98.             $editions = null;
  99.             $selectedEdition = null;
  100.             $displayedEditions=null;
  101.             $image = null;
  102.             $productScores = [];
  103.             $productScoresOrder = [];
  104.             $productScoresRating = [];
  105.             $productScoresRatingArray = [];
  106.             $prodcutFormats = [];
  107.             $prodcutFormatArray = [];
  108.             if (empty($book)) {
  109.                 //throw new NotFoundHttpException('Book needed');
  110.                 return $this->redirect('/');
  111.             } else {
  112.                 $book = $book[0];
  113.                 $title = $book->getTitle();
  114.                 $image = $book->getItemThumbnail('lg');
  115.                
  116.             }
  118.             // New selection options dynamic
  119.             // Get All options dynamic for this item
  120.             $productScoresRatingArray = $book->getItemRatingOptions();
  121.             // Avis Dolpo : ex: A lire pour les accros au genre
  122.             if ($book->getReview()) {
  123.                 foreach ($book->getReview()->getItems() as $collection) {
  124.                     if ($collection instanceof Fieldcollection\Data\Review) {
  125.                         // $productScoresRating = $collection->getDefinition()->getFieldDefinition('Rating')->getoptions();
  126.                         $collectionItem = $collection;
  127.                         break;
  128.                     }
  129.                 }
  131.             }
  132.             
  133.             
  135.             if( $collectionItem != null ){
  136.                 $ratingsCriterias = $collectionItem->getRatingCriteria();
  137.                 if(count($ratingsCriterias)) {
  138.                     foreach($ratingsCriterias as $reviewCrit) {
  139.                         $dataRating = ($reviewCrit->getData());
  140.                         $productScores[$reviewCrit->getObjectId()][] = $dataRating['Rating'];
  141.                     }
  142.                 }
  143.             }
  144.             
  145.             $finalProductScores = [];
  146.             // Calcul average
  147.             foreach($productScores as $idCriteria => $infos){
  148.                 $criteria = \Pimcore\Model\DataObject\ReviewCriteria::getById($idCriteria);
  149.                 
  150.                 $color = '#36A9E1';
  151.                 if($criteria->getProperty("color") != ''){
  152.                     $color = $criteria->getProperty("color");
  153.                 }
  154.                 
  155.                 
  156.                 $label = $criteria->getKey();
  157.                 // label to override key
  158.                 if($criteria->getLabel() != ''){
  159.                     $label = $criteria->getLabel();
  160.                 }
  161.                 // Label front if needed
  162.                 if($criteria->getProperty("label") != ''){
  163.                     $label = $criteria->getProperty("label");
  164.                 }
  165.                 
  166.                 $position = $idCriteria; // todo to change by custom property with position (like label)
  167.                 
  168.                 $finalProductScores[$position] = [
  169.                     'label' => $label,
  170.                     'color' => $color,
  171.                     'score' => (int) ceil(array_sum($infos) / count($infos))
  172.                     ];
  173.             }
  174.             
  175.             $productScores = $finalProductScores;
  176.             
  177.             // ---------------------------------
  178.             
  179.             
  180.             
  182.             // Title and subtitle
  183.             $serie=null;
  184.             if(!empty($book->getSerieId())){
  185.                 $serie=Serie::getById($book->getSerieId());
  186.             }
  187.             
  188.             if (!empty($serie)) {
  190.                 $title = $serie->getName();
  191.                 foreach ($serie->getVolumes() as $bookAdded) {
  192.                     if ($bookAdded->getObjectId() === $book->getId()) {
  193.                         if(array_key_exists( 'Tome', $bookAdded->getData())){
  194.                             if (count(explode(":", $book->getTitle())) > 1) {
  195.                                 $subtitle = "Tome " . $bookAdded->getData()['Tome'] . " " . explode(":", $book->getTitle())[1];
  196.                             } else {
  197.                                 $subtitle = "Tome " . $bookAdded->getData()['Tome'] . " " . $book->getTitle();
  198.                             }
  199.                         }
  200.                         else{
  201.                             
  202.                         }
  203.                     }
  204.                 }
  205.             }
  207.             // Edition 
  209.             $editionIds = [];
  210.             $inventoryItemProduct = [];
  211.             if (!empty($book->getEditions())) {
  212.                 $editions = $book->getAllSortedEditions();
  213.                 $selectedEdition = $editions[0]['edition'];
  214.                 $i=0;
  215.                 $hasInStockArticles = false;
  216.                 $hasOrderedArticles = false;
  217.                 $hasOrderableArticles = false;
  218.                 $displayed_formats=[];
  219.                 foreach ($editions as $editionArray) {
  220.                     $edition=$editionArray['edition'];
  221.                     
  222.                                         
  223.                     if (empty($editionArray['Format']) or ($editionArray['Format']=='')){
  224.                         $editionArray['Format']='vide';
  225.                     }
  227.                     if ($request->get('productId') and $request->get('productId') == $edition->getId()) {
  228.                         $inventoryItemProduct[$edition->getId()] = $edition->getAvailabilityLabel();
  229.                         $selectedEdition = $edition;
  230.                         $displayedEditions[]=$edition;
  231.                         $displayed_formats[]=$editionArray['Format'];
  232.                     }
  233.                     elseif($editionArray['Availability']=='InStock'){
  234.                         $inventoryItemProduct[$edition->getId()] = $this->map_availability[$editionArray['Availability']];
  235.                         $hasInStockArticles=true;
  236.                         $displayedEditions[]=$edition;
  237.                         $displayed_formats[]=$editionArray['Format'];
  238.                         $i++;
  239.                     }
  240.                     elseif($editionArray['Availability']=='Ordered'){
  241.                         $inventoryItemProduct[$edition->getId()] = "<p class='edition__shipping shipping-48h'>  En arrivage - livré en " . $editionArray['Delay'] . ($editionArray['Delay'] == 1 ? 'jour' : ' jours') . "</a>";
  242.                         $hasOrderedArticles=true;
  243.                         $displayedEditions[]=$edition;
  244.                         $displayed_formats[]=$editionArray['Format'];
  245.                         $i++;
  246.                     }
  247.                     elseif(in_array($editionArray['Format'], $displayed_formats)){
  248.                         //on n'affiche pas l'édition si le format est déjà dans les formats proposés
  249.                     }
  250.                     elseif($editionArray['Availability']=='Orderable'){
  251.                         $inventoryItemProduct[$edition->getId()] = "<p class='edition__shipping shipping-48h'> livré en " . $editionArray['Delay'] . ($editionArray['Delay'] == 1 ? 'jour' : ' jours') . "</a>";
  252.                         $hasOrderableArticles=true;
  253.                         $displayedEditions[]=$edition;
  254.                         $displayed_formats[]=$editionArray['Format'];
  255.                         $i++;
  256.                     }
  257.                     elseif($editionArray['Availability']=='PreOrderable'){
  258.                         $inventoryItemProduct[$edition->getId()] = "<p class='edition__shipping shipping-48h'> Précommande </a>";
  259.                         $hasOrderableArticles=true;
  260.                         $displayedEditions[]=$edition;
  261.                         $displayed_formats[]=$editionArray['Format'];
  262.                         $i++;
  263.                     }
  264.                     elseif(array_key_exists($editionArray['Availability'], $this->map_availability)  
  265.                            && !$hasOrderedArticles && !$hasInStockArticles && !$hasOrderableArticles){
  266.                         $inventoryItemProduct[$edition->getId()] = $this->map_availability[$editionArray['Availability']];
  267.                         $displayedEditions[]=$edition;
  268.                         $displayed_formats[]=$editionArray['Format'];
  269.                         $i++;
  270.                     }
  271.                     else{
  272.                         
  273.                     }
  274.                    
  275.                    
  276.                    if(!$hasOrderedArticles and !$hasInStockArticles and ($i>=3)){
  277.                        break;
  278.                    }
  279.                    
  280.                 }
  281.             }
  285.             // images
  286.             
  287.             if ($selectedEdition) {
  288.                 $prodcutFormats = ClassDefinition::getById($selectedEdition->getClassId())->getFieldDefinition('Format')->getOptions();
  289.                 
  290.                 if ($selectedEdition->getLargeCover()->getDirect()) {
  291.                     $image = $selectedEdition->getLargItemThumbnail();
  292.                     
  293.                 }
  294.             }
  296.             foreach ($prodcutFormats as $productFormat) {
  297.                 $prodcutFormatArray[$productFormat['value']] = $productFormat['key'];
  298.             }
  299.         }
  300.         $category = null;
  301.         foreach ($book->getDolpoTags() as $dolpoTag) {
  302.             if ($dolpoTag->getTagType() == 'category') {
  303.                 $category = $dolpoTag;
  304.                 break;
  305.             }
  306.         }
  308.         /**
  309.          * 
  310.          * Author best book
  311.          */
  312.          
  313.         if (!empty($book->getAuthors())) {
  314.         
  315.             $author = $book->getAuthors()[0];
  316.             $authorBestBookDefault = \Pimcore\Model\WebsiteSetting::getByName('authorBestBookDefault');
  317.             $authorBestBookDefaultval = 4;
  318.             if ($authorBestBookDefault) {
  319.                 $authorBestBookDefaultval = $authorBestBookDefault->getData();
  320.             }
  322.             $authorBookItems = $dolpoSearchService->getBooksByAuthorId($author->getId(), 0, $authorBestBookDefaultval + 1, ['o_id']);
  323.             $authorBookIds_tmp = array_values(array_unique(array_filter(array_map(
  324.                 static fn ($item) => is_array($item) && array_key_exists('o_id', $item) ? $item['o_id'] : null,
  325.                 $authorBookItems
  326.             ), static fn ($bookId) => $bookId !== null)));
  327.             $authorBookIds=[];
  328.             foreach($authorBookIds_tmp as $itemId){
  329.                 if(count($authorBookIds)<$authorBestBookDefaultval){
  330.                     if($itemId!=$book->getId()){
  331.                         $authorBookIds[]=$itemId;          
  332.                     }
  333.                 }
  334.             }
  335.             $authorBookIdString = implode(',', $authorBookIds);
  337.             $param['authorBooks'] = [
  338.                 "tagsToShow" => false,
  339.                 "tagsSelectionIds" => '',
  340.                 "objectsSelectionIds" => $authorBookIdString,
  341.                 "frontFilters" => null,
  342.                 "pagination" => null,
  343.                 "showCount" => false,
  344.                 "ad" => null,
  345.                 "title" => "AUTRES LIVRES DE " . $author->getName(),
  346.                 "editmode" => false,
  347.                 "uniqueId" => null
  348.             ];
  349.         }
  351.         /**
  352.          * 
  353.          * Auther best book
  354.          */
  358.         // add document 
  359.         if ($category) {
  360.             $param['document'] = $category->getPage();
  361.             // Add snippet
  362.             $param['snippet'] = $category->getSnippet();
  364.             $dolpoBestBookDefault = \Pimcore\Model\WebsiteSetting::getByName('dolpoBestBookDefault');
  365.             $dolpoBestBookDefaultval = 4;
  366.             if ($dolpoBestBookDefault) {
  367.                 $dolpoBestBookDefaultval = $dolpoBestBookDefault->getData();
  368.             }
  371.             $filters = ['DolpoTags' => [$category->getId()]]; 
  372.             $dolpoBooks = $dolpoSearchService->bookSearchFilter($filters, 0, 25);
  373.             $cle_hasard=[];
  374.             if ($dolpoBooks) {
  375.                 if (count($dolpoBooks) === 1) {
  376.                     // Si il n'y a qu'un seul livre, on prend directement la clé 0
  377.                     $cle_hasard = [0];
  378.                 } else {
  379.                     // Sinon, on utilise array_rand pour obtenir une clé aléatoire
  380.                     $cle_hasard = array_rand($dolpoBooks, min($dolpoBestBookDefaultval, count($dolpoBooks)));
  381.                 }
  382.             }
  384.             $dolpoBookIds = [];
  385.             
  386.             foreach ($cle_hasard as $cle) {
  387.                $dolpoBookIds[] = $dolpoBooks[$cle]['o_id'];
  388.             }
  389.             $dolpoBookIdString = implode(',', $dolpoBookIds);
  391.             $param['dolpoBooks'] = [
  392.                 "tagsToShow" => false,
  393.                 "tagsSelectionIds" => '',
  394.                 "objectsSelectionIds" => $dolpoBookIdString,
  395.                 "frontFilters" => null,
  396.                 "pagination" => null,
  397.                 "showCount" => false,
  398.                 "ad" => null,
  399.                 "title" => "DOLPO RECOMMANDE",
  400.                 "editmode" => false,
  401.                 "uniqueId" => null
  402.             ];
  403.         }else{
  404.             $param['document'] = \Pimcore\Model\Document::getById(1);
  405.         }
  408.         $newEditable = new \Pimcore\Model\Document\Editable\Wysiwyg();
  409.         $newEditable->setName('title');
  410.         $newEditable->setDataFromResource('');
  411.         $document->setEditable($newEditable);
  413.         //isAdminUser
  414.         $user = \Pimcore\Tool\Session::getReadonly()->get("user");
  415.         $isPimcoreAdminUser= ($user !== null);
  417.         $param['refresh']=$request->query->get('refresh');
  419.         $param['item'] = $book;
  420.         $param['serie'] = $serie;
  421.         $param['title'] = $title;
  422.         $param['subtitle'] = $subtitle;
  423.         $param['collection'] = $collectionItem;
  424.         $param['editions'] = $displayedEditions;
  425.         $param['selectedEdition'] = $selectedEdition;
  426.         $param['image'] = $image;
  427.         $param['productScores'] = $productScores;
  428.         $param['productScoresOrder'] = $productScoresOrder;
  429.         $param['productScoresRating'] = $productScoresRatingArray;
  430.         //$param['colorCode'] = self::$COLOR_CODE;
  431.         $param['productId'] = $request->get('productId');
  432.         $param['prodcutFormats'] = $prodcutFormatArray;
  433.         $param['inventoryItemProduct'] = $inventoryItemProduct;
  434.         $param['isPimcoreAdminUser'] = $isPimcoreAdminUser;
  436.         // SEO
  437.         $title = $book->getTitle();
  438.         if($subtitle != ''){
  439.             $title.= ' : '.$subtitle;
  440.         }
  441.         if (!empty($book->getAuthors())) {
  442.             $authors = $book->getAuthors();
  443.             foreach ($authors as $author) {
  444.                 $title.= ' : '.$author->getName();
  445.             }
  446.         }
  447.         if($param['document']){
  448.             $param['document']->setTitle($title);
  449.             $param['document']->setDescription(\App\Service\Website\Tool\Text::cutStringRespectingWhitespace($book->getDescription(),250));
  450.         }
  451.         return $this->render('product/product.html.twig', $param);
  452.     }
  454.     public function productListAction(Request $request): Response
  455.     {
  457.         return $this->render('product/product_list.html.twig');
  458.     }
  460.     public function elasticSearchAction(Request $request, DolpoSearchService $dolpoSearchService): Response
  461.     {
  463.         $query = '';
  464.         if ($request->get("q")) {
  465.             $query = $request->get("q");
  466.         }
  468.         $data = [
  469.             'serie' => [],
  470.             'auteur' => [],
  471.             'book' => [],
  472.         ];
  474.         $query = trim((string) $query);
  475.         if ($query !== '') {
  476.             $filters = ['TextSearch' => $query];
  477.             $returnFields = [
  478.                 'book_id',
  479.                 'book_dolpo_id',
  480.                 'book_title',
  481.                 'title_long',
  482.                 'ean',
  483.                 'authors_json',
  484.                 'author_names',
  485.             ];
  486.             $results = $dolpoSearchService->bookSearchFilter($filters, null, 0, 7, $returnFields);
  488.             foreach ($results as $item) {
  489.                 $authors = [];
  490.                 $authorsJson = $item['authors_json'] ?? [];
  491.                 if (is_string($authorsJson)) {
  492.                     $decoded = json_decode($authorsJson, true);
  493.                     if (is_array($decoded)) {
  494.                         $authorsJson = $decoded;
  495.                     }
  496.                 }
  497.                 if (is_array($authorsJson)) {
  498.                     foreach ($authorsJson as $author) {
  499.                         if (!is_array($author)) {
  500.                             continue;
  501.                         }
  502.                         $name = $author['name'] ?? ($author['Name'] ?? null);
  503.                         if ($name === null || $name === '') {
  504.                             continue;
  505.                         }
  506.                         $authors[] = [
  507.                             'Name' => $name,
  508.                             'dolpoId' => $author['dolpo_id'] ?? ($author['dolpoId'] ?? null),
  509.                         ];
  510.                     }
  511.                 }
  513.                 if ($authors === []) {
  514.                     $authorNames = $item['author_names'] ?? [];
  515.                     if (is_string($authorNames)) {
  516.                         $authorNames = [$authorNames];
  517.                     }
  518.                     if (is_array($authorNames)) {
  519.                         foreach ($authorNames as $name) {
  520.                             if ($name !== '') {
  521.                                 $authors[] = ['Name' => $name, 'dolpoId' => null];
  522.                             }
  523.                         }
  524.                     }
  525.                 }
  527.                 $data['book'][] = [
  528.                     'id' => $item['book_id'] ?? null,
  529.                     'dolpoId' => $item['book_dolpo_id'] ?? ($item['book_id'] ?? null),
  530.                     'title' => $item['book_title'] ?? ($item['title_long'] ?? ''),
  531.                     'ean' => $item['ean'] ?? null,
  532.                     'author' => $authors,
  533.                 ];
  534.             }
  535.         }
  536.         $data = $this->render('product/product_serie_result.html.twig', ["data" => $data]);
  537.         return $this->json(["success" => true, "data" => $data]);
  538.     }
  541.     public function productSearchAction(Request $request): Response
  542.     {
  544.         $query = '';
  545.         if ($request->get("q")) {
  546.             $query = $request->get("q");
  547.         }
  548.         $paginationDefault = \Pimcore\Model\WebsiteSetting::getByName('paginationGalleryDefault');
  549.         $paginationDefaultVal = $paginationDefault->getData();
  550.         $param['query'] = $query;
  551.         $param["pagination"] = $paginationDefaultVal;
  553.         return $this->render('product/product_search.html.twig', $param);
  554.     }
  555.     public function productSearchNextAction(Request $request, ElasticSearchService $elasticSearchService): Response
  556.     {
  558.         $query = '';
  559.         if ($request->get("query")) {
  560.             $query = $request->get("query");
  561.         }
  563.         $total = $request->get("total");
  564.         $pagination = $request->get("pagination");
  565.         $offset = $request->get("offset");
  568.         $paginationDefault = \Pimcore\Model\WebsiteSetting::getByName('paginationGalleryDefault');
  569.         $paginationDefaultVal = $paginationDefault->getData();
  570.         $objectBooks = $elasticSearchService->bookSearchFilter($query, (int)$offset, (int)$pagination, true);
  572.         $param['query'] = $query;
  573.         $param['total'] = $objectBooks["total"];
  574.         $param["pagination"] = $pagination;
  575.         $param["offset"] = $offset +  $pagination;
  576.         $param['productHtml'] = $this->render('product/book_gallary.html.twig', ["books" => $objectBooks["data"]]);
  578.         return $this->json(["success" => true, "data" => $param]);
  579.     }
  581. }