src/Controller/ProductController.php line 217

Open in your IDE?
  1. <?php
  3. /**
  4.  * Pimcore
  5.  *
  6.  * This source file is available under two different licenses:
  7.  * - GNU General Public License version 3 (GPLv3)
  8.  * - Pimcore Enterprise License (PEL)
  9.  * Full copyright and license information is available in
  10.  * LICENSE.md which is distributed with this source code.
  11.  *
  12.  *  @copyright  Copyright (c) Pimcore GmbH (http://www.pimcore.org)
  13.  *  @license    http://www.pimcore.org/license     GPLv3 and PEL
  14.  */
  16. namespace App\Controller;
  18. use App\Model\Product\AbstractProduct;
  19. use App\Model\Product\AccessoryPart;
  20. use App\Model\Product\Car;
  21. use App\Model\Product\Category;
  22. use App\Services\CurlService;
  23. use Pimcore\Model\DataObject\Manufacturer;
  24. use App\Services\SegmentTrackingHelperService;
  25. use App\Website\LinkGenerator\ProductLinkGenerator;
  26. use App\Website\Navigation\BreadcrumbHelperService;
  27. use Knp\Component\Pager\Pagination\SlidingPagination;
  28. use Knp\Component\Pager\PaginatorInterface;
  29. use Pimcore\Bundle\EcommerceFrameworkBundle\Factory;
  30. use Pimcore\Bundle\EcommerceFrameworkBundle\FilterService\ListHelper;
  31. use Pimcore\Bundle\EcommerceFrameworkBundle\IndexService\ProductList\DefaultMysql;
  32. use Pimcore\Bundle\EcommerceFrameworkBundle\IndexService\ProductList\ElasticSearch\AbstractElasticSearch;
  33. use Pimcore\Bundle\EcommerceFrameworkBundle\IndexService\ProductList\ProductListInterface;
  34. use Pimcore\Config;
  35. use Pimcore\Model\DataObject\AbstractObject;
  36. use Pimcore\Model\DataObject\Concrete;
  37. use Pimcore\Model\DataObject\Data\UrlSlug;
  38. use Pimcore\Model\DataObject\FilterDefinition;
  39. use Pimcore\Translation\Translator;
  40. use Pimcore\Twig\Extension\Templating\HeadTitle;
  41. use Pimcore\Twig\Extension\Templating\Placeholder;
  42. use Symfony\Component\HttpFoundation\JsonResponse;
  43. use Symfony\Component\HttpFoundation\Request;
  44. use Symfony\Component\HttpFoundation\Response;
  45. use Symfony\Component\HttpFoundation\Session\SessionInterface;
  46. use Symfony\Component\HttpKernel\Exception\NotFoundHttpException;
  47. use Symfony\Component\Routing\Annotation\Route;
  48. use Symfony\Component\Security\Core\User\UserInterface;
  49. use Pimcore\Model\DataObject;
  50. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Security;
  51. use Pimcore\Db;
  52. use App\Model\Order;
  53. use App\Lib\Utility;
  55. class ProductController extends BaseController
  56. {
  57.     /**
  58.      * @param Request $request
  59.      * @param AbstractObject $object
  60.      * @param UrlSlug $urlSlug
  61.      * @return Response
  62.      */
  63.     public function productDetailSlugAction(Request $request, AbstractObject $object, UrlSlug $urlSlug) {
  64.         return $this->forward('App\Controller\ProductController::detailAction', ['product' => $object]);
  65.     }
  67.     /**
  68.      * @Route("/shop/{path}{productname}~p{product}", name="shop-detail", defaults={"path"=""}, requirements={"path"=".*?", "productname"="[\w-]+", "product"="\d+"})
  69.      * @Security("is_granted('ROLE_USER')")
  70.      * @param Request $request
  71.      * @param HeadTitle $headTitleHelper
  72.      * @param BreadcrumbHelperService $breadcrumbHelperService
  73.      * @param Factory $ecommerceFactory
  74.      * @param SegmentTrackingHelperService $segmentTrackingHelperService
  75.      * @param Concrete $product built-in parameter conversion, please see https://github.com/pimcore/pimcore/pull/5554
  76.      * @param ProductLinkGenerator $productLinkGenerator
  77.      *
  78.      * @return Response
  79.      *
  80.      * @throws \Exception
  81.      */
  82.     public function detailAction(
  83.         Request $request,
  84.         HeadTitle $headTitleHelper,
  85.         BreadcrumbHelperService $breadcrumbHelperService,
  86.         Factory $ecommerceFactory,
  87.         SegmentTrackingHelperService $segmentTrackingHelperService,
  88.         Concrete $product,
  89.         ProductLinkGenerator $productLinkGenerator,
  90.         UserInterface $user,
  91.         SessionInterface $session,
  92.         PaginatorInterface $paginator
  93.     )
  94.     {
  95.         if (!(
  96.                 $product && $product->isPublished()
  97.             )
  98.         ) {
  99.             throw new NotFoundHttpException('Product not found.');
  100.         }
  102.         $file = null;
  103.         $fileExists = false;
  105.         /*$file = BASE_URL.'/document/'.$product->getItem().'.pdf';
  107.        // p_r($file);
  109.         if(Utility::check_file_exist($file))
  110.         {
  111.            $fileExists = true;
  112.            $file = BASE_URL.'/document/'.$product->getItem().'.pdf';
  113.         }else{
  114.             $file = null;
  115.         }*/
  117.         if($file = $product->getProductPdf()){
  118.             $fileExists = true;
  119.             $file = $product->getProductPdf();
  120.         }
  122.         //redirect to main url
  123.         $generatorUrl = $productLinkGenerator->generate($product);
  124.         if($generatorUrl != $request->getPathInfo()) {
  125.             $queryString = $request->getQueryString();
  126.             return $this->redirect($generatorUrl . ($queryString ? '?' . $queryString : ''));
  127.         }
  129.         $breadcrumbHelperService->enrichProductDetailPage($product);
  130.         $headTitleHelper($product->getOSName());
  132.         $paramBag = $this->getAllParameters($request);
  133.         $paramBag['product'] = $product;
  134.         $paramBag['category'] = $product->getMainCategory();
  135.         $paramBag['brand'] = $product->getManufacturer();
  136.         $paramBag['search'] = false;
  137.         $paramBag['file'] = $file;
  138.         $paramBag['fileExists'] = $fileExists;
  140.         $addToDraftEnabled = 0;
  141.         $draftOrder = false;
  142.         if($user){
  143.             $order = new Order();
  144.             $branches = $this->getBranches($session,$user);
  145.             $draftOrder = $order->getOrderByStatus('Draft',$branches,$paginator);
  146.             if(count($draftOrder)>0)
  147.                 $addToDraftEnabled = count($draftOrder);
  148.         }
  149.         $paramBag['addToDraftEnabled'] = $addToDraftEnabled;
  150.         $paramBag['draftOrder'] = $draftOrder;
  152.         $paramBag['isMecstoreUser'] =  false;
  153.         $partner = $user->getPartner();
  154.        // p_r($partner->getisMecstoreHQ());exit;
  155.         if($partner->getisMecstoreHQ()){
  156.             $paramBag['isMecstoreUser'] =  true;
  157.         }
  159.         //track segments for personalization
  160.         $segmentTrackingHelperService->trackSegmentsForProduct($product);
  162.         $trackingManager = $ecommerceFactory->getTrackingManager();
  163.         $trackingManager->trackProductView($product);
  165.         $salesRepesentative = [];
  166.         $manufacturer = $product->getManufacturer();
  167.         if($manufacturer){
  168.             $sales = $manufacturer->getSalesRepesentative();
  169.             if($sales)
  170.             {
  171.                 $count = 0;
  172.                 foreach($sales as $key=>$sale){
  173.                     $salesRepesentative[$count]['Name'] = $sale['Name']->getData().' ('.$sale['Area']->getData().')';
  174.                     $salesRepesentative[$count]['PhoneNo'] = $sale['PhoneNo']->getData();
  175.                     $count++;
  176.                 }
  177.             }
  179.             $salesRepesentative = $input = array_map("unserialize", array_unique(array_map("serialize", $salesRepesentative)));
  181.         }
  184.         $paramBag['sales_representative'] = $salesRepesentative;
  186.        // $_SERVER['HTTP_REFERER'] ="";
  187.         if(isset($_SERVER['HTTP_REFERER']) && strpos($_SERVER['HTTP_REFERER'],'shop-by-brand') !== false){
  188.             return $this->render('product/detail_brand.html.twig', $paramBag);
  189.         }
  190.         else if(isset($_SERVER['HTTP_REFERER']) &&  strpos($_SERVER['HTTP_REFERER'],'ovunque') !== false){
  191.             $paramBag['search'] = true;
  192.             return $this->render('product/detail.html.twig', $paramBag);
  193.         }
  194.         else{
  195.             return $this->render('product/detail.html.twig', $paramBag);
  196.         }
  199.     }
  202.     /**
  203.      * @Route("/wishlist/{id}/{remove}", name="wishlist-add")
  204.      * @Security("is_granted('ROLE_USER')")
  205.      * @param Request $request
  206.      * @param HeadTitle $headTitleHelper
  207.      * @param BreadcrumbHelperService $breadcrumbHelperService
  208.      * @param Factory $ecommerceFactory
  209.      * @param SegmentTrackingHelperService $segmentTrackingHelperService
  210.      * @param Concrete $product built-in parameter conversion, please see https://github.com/pimcore/pimcore/pull/5554
  211.      * @param ProductLinkGenerator $productLinkGenerator
  212.      *
  213.      * @return Response
  214.      *
  215.      * @throws \Exception
  216.      */
  217.     public function wishlistAddAction(Request $request)
  218.     {
  219.         $user = $this->getUser();
  220.         if(!$user){
  221.             return $this->json(['success'=>false,'message'=>"User is not logged in"]);
  222.         }
  223.         $result = [];
  224.         $products = [];
  225.         $productId = $request->get('id',0);
  226.         $remove = $request->get('remove',false);
  230.         $product = \Pimcore\Model\DataObject::getById($productId);
  231.         if($product){
  233.             $wishlist = new DataObject\Wishlist\Listing();
  234.             $wishlist->setCondition("user__id = ? AND item__id = ?",[$user->getId(),$product->getId()]);
  235.             $lists = $wishlist->load();
  237.             if($remove == 'true' && $lists)
  238.             {
  240.                 $wishlist = $lists[0];
  241.                 $wishlist->delete();
  243.             }else{
  244.                 if($lists)
  245.                 {
  246.                     $wishlist = $lists[0];
  248.                 }else{
  249.                     $wishlist = new DataObject\Wishlist();
  250.                     $wishlist->setKey(\Pimcore\Model\Element\Service::getValidKey($user->getId().'-'.$product->getKey(), 'object'));
  251.                     $wishlist->setParent(\Pimcore\Model\DataObject\Service::createFolderByPath('/customers/Wishlist/'.$user->getEmail()));
  252.                 }
  253.                 $wishlist->setUser($user);
  254.                 $wishlist->setPublished(TRUE);
  255.                 $wishlist->setItem($product);
  256.                 $wishlist->save();
  257.             }
  258.         }
  259.         $totalCount = $this->getProductsInWishList($user);
  260.         return $this->json(['success'=>true,'products'=>$totalCount]);
  261.     }
  264.     /**
  265.      * @Route("/wish-list/index", name="wishlist-index")
  266.      * @Security("is_granted('ROLE_USER')")
  267.      * @param Request $request
  268.      * @return Response
  269.      *
  270.      * @throws \Exception
  271.      */
  272.     public function wishListIndexAction(Request $request,UserInterface $user)
  273.     {
  274.         $result = [];
  275.         $products = [];
  276.         $productId = $request->get('id',0);
  277.         $params = array_merge($request->query->all(), $request->attributes->all());
  279.         if($user){
  281.             $db = Db::get();
  283.             $orderBy = " ow.oo_id DESC";
  284.             if(isset($params['orderby'])){
  285.                 if($params['orderby'] == "price")
  286.                 {
  287.                     $orderBy = 'CONSORZ ASC';
  288.                 }else if($params['orderby'] == "price-desc"){
  289.                     $orderBy =  'CONSORZ DESC';
  290.                 }else if($params['orderby'] == "date"){
  291.                     $orderBy = 'oo_id DESC';
  292.                 }else if($params['orderby'] == "popularity"){
  293.                     $orderBy = 'oo_id DESC';
  294.                 }
  295.             }else{
  296.                 $orderBy  = "ow.o_modificationDate DESC";
  297.             }
  299.             $lists = [];
  300.             $sql = 'SELECT ow.oo_id FROM `object_wishlist` ow LEFT JOIN object_prod op ON ow.item__id = op.oo_id WHERE user__id = '.$user->getId().' ORDER BY '.$orderBy;
  301.             $products = $db->fetchAll($sql);
  302.             if($products)
  303.             {
  304.                 foreach($products as $prod){
  305.                     $lists[] = \Pimcore\Model\DataObject::getById($prod['oo_id']);
  306.                 }
  307.             }
  309.             $params['products'] = $lists;
  310.             $params['orderby'] = $orderBy;
  312.             $params['isMecstoreUser'] =  false;
  313.             $partner = $user->getPartner();
  314.             if($partner->getisMecstoreHQ()){
  315.                 $params['isMecstoreUser'] =  true;
  316.             }
  317.         }
  318.         return $this->render('product/wishlist.html.twig', $params);
  319.     }
  321.     /**
  322.      * @Route("/shop/{categoryname}~c{category}", name="shop-category")
  323.      *
  324.      * @param Request $request
  325.      * @param HeadTitle $headTitleHelper
  326.      * @param BreadcrumbHelperService $breadcrumbHelperService
  327.      * @param Factory $ecommerceFactory
  328.      * @param SegmentTrackingHelperService $segmentTrackingHelperService
  329.      * @param ListHelper $listHelper
  330.      *
  331.      * @return Response
  332.      */
  333.     public function listingAction(Request $request, HeadTitle $headTitleHelper, BreadcrumbHelperService $breadcrumbHelperService, Factory $ecommerceFactory, SegmentTrackingHelperService $segmentTrackingHelperService, ListHelper $listHelper, PaginatorInterface $paginator,UserInterface $user, SessionInterface $session)
  334.     {
  335.         $masterFilterDefinition = Config::getWebsiteConfig()->get('masterFilterDefinition');
  336.         $params = array_merge($request->query->all(), $request->attributes->all());
  338.         $addToDraftEnabled = 0;
  339.         $draftOrder = false;
  340.         if($user){
  341.             $order = new Order();
  342.             $branches = $this->getBranches($session,$user);
  343.             $draftOrder = $order->getOrderByStatus('Draft',$branches,$paginator);
  344.             if(count($draftOrder)>0)
  345.                 $addToDraftEnabled = count($draftOrder);
  346.         }
  347.         $params['addToDraftEnabled'] = $addToDraftEnabled;
  348.         $params['draftOrder'] = $draftOrder;
  350.         $params['maxRange'] = 10;
  352.         //Get pricelist name
  353.         $priceListName = DEFAULT_PRICELIST_COLUMN;
  354.         if($user){
  355.             $partner = $user->getPartner();
  356.             if($partner){
  357.                 //$priceListName = $partner->getPriceList();
  358.             }
  359.         }
  361.         //needed to make sure category filter filters for active category
  362.         $params['parentCategoryIds'] = $params['category'] ?? null;
  364.         $category = Category::getById($params['category'] ?? null);
  367.         $params['category'] = $category;
  368.         if ($category) {
  369.             $headTitleHelper($category->getName());
  370.             $breadcrumbHelperService->enrichCategoryPage($category);
  371.         }else{
  372.             $category = new \stdClass();
  373.             $category->name = "tutto il catalogo";
  374.             $params['category'] = $category;
  375.         }
  377.         $indexService = $ecommerceFactory->getIndexService();
  378.         $productListing = $indexService->getProductListForCurrentTenant();
  379.         $productListing->addCondition("disabled != 1");
  380.      //p_r(get_class_methods($productListing));exit;
  381.         $params['term'] = isset($params['term'])?$params['term']:"";
  383.         if(isset($params['term'])){
  384.             //p_r($params);
  385.             //p_r('lower(description) LIKE "%'.strtolower($params['term']).'%"');exit;
  386.             if(strtolower($params['term']) != "ovunque"){
  388.                 if($category instanceof \Pimcore\Model\DataObject){
  389.                     if($params['term']){
  391.                         $searchTerms = explode(" ",$params['term']);
  392.                         if($searchTerms)
  393.                         {
  394.                             foreach($searchTerms as $term)
  395.                             {
  396.                                 $productListing->addCondition("searchelem LIKE '%".$term."%' AND categoryIds LIKE '%".$category->getId()."%'");
  397.                             }
  398.                         }
  400.                     }else{
  401.                         $productListing->addCondition("categoryIds LIKE '%".$category->getId()."%'");
  402.                     }
  404.                 }else{
  405.                     if(is_object($category)){
  406.                         if($category->name == "tutto il catalogo"){
  407.                             $filterDefinition = $masterFilterDefinition;
  408.                             $category->name = "RICERCA";
  409.                         }
  410.                     }
  411.                    // echo "(lower(description) LIKE '".strtolower($params['term'])."%' OR lower(name) LIKE '".strtolower($params['term'])."%' )";exit;
  412.                     if($params['term']){
  413.                         $searchTerms = explode(" ",$params['term']);
  414.                         if($searchTerms)
  415.                         {
  416.                             foreach($searchTerms as $term)
  417.                             {
  418.                                 $productListing->addCondition("searchelem LIKE '%".$term."%' OR name LIKE '%".$term."%'");
  419.                             }
  420.                         }
  421.                     }
  422.                 }
  424.             }
  425.             else if($category)
  426.             {
  428.                 $productListing->addCondition("categories LIKE '%".$category->getId()."%'");
  429.             }
  431.         }
  433.          $productListing->setOrderKey('o_id');
  434.          $productListing->setOrder('asc');
  435.         if(isset($params['orderby'])){
  436.            // p_r($params['orderby']);exit;
  437.             if($params['orderby'] == "price")
  438.             {
  439.                 $productListing->setOrderKey($priceListName);
  440.                 $productListing->setOrder('asc');
  442.             }else if($params['orderby'] == "price-desc"){
  444.                 $productListing->setOrderKey($priceListName);
  445.                 $productListing->setOrder('DESC');
  447.             }else if($params['orderby'] == "date"){
  449.                 $productListing->setOrderKey('o_id');
  450.                 $productListing->setOrder('DESC');
  452.             }else if($params['orderby'] == "popularity"){
  454.                 // $productListing->setOrderKey('price');
  455.                 // $productListing->setOrder('DESC');
  456.             }
  457.         }else{
  458.             $params['orderby'] = "o_id";
  459.         }
  460.         $params['productListing'] = $productListing;
  462.         // load current filter
  463.         if ($category instanceof \Pimcore\Model\DataObject) {
  464.             $filterDefinition = $category->getFilterdefinition();
  466.             //track segments for personalization
  467.             $segmentTrackingHelperService->trackSegmentsForCategory($category);
  469.             $trackingManager = $ecommerceFactory->getTrackingManager();
  470.             $trackingManager->trackCategoryPageView($category->getName(), null);
  471.         }
  473.         if ($request->get('filterdefinition') instanceof FilterDefinition) {
  474.             $filterDefinition = $request->get('filterdefinition');
  475.         }
  477.         if (empty($filterDefinition)) {
  478.             $filterDefinition = Config::getWebsiteConfig()->get('fallbackFilterdefinition');
  479.         }
  481.         $filterService = $ecommerceFactory->getFilterService();
  485.         // Get Max price
  486.         $maxPriceList = clone $productListing;
  487.         $maxParam = $params;
  488.         unset($maxParam['page']);
  490.         //p_r($maxPriceList);exit;
  492.         $listHelper->setupProductList($filterDefinition, $maxPriceList, $maxParam, $filterService, true);
  495.         $maxPriceList->setOrderKey($priceListName);
  496.         $maxPriceList->setOrder('desc');
  497.         $maxPriceList->setLimit(1);
  498.         $maxPriceItems = $maxPriceList->load();
  499.         if($maxPriceItems){
  500.             $getter = "getPrice";
  501.             $params['maxRange'] = (int)$maxPriceItems[0]->$getter() +1;
  502.         }
  504.         $listHelper->setupProductList($filterDefinition, $productListing, $params, $filterService, true);
  506.         //p_);
  508.         $params['filterService'] = $filterService;
  509.         $params['filterDefinition'] = $filterDefinition;
  511.         //$
  512.         /** @var SlidingPagination $paginator */
  513.         // init pagination
  514.         $pagelimit = $request->get('limit', 24);
  515.         $paginator = $paginator->paginate(
  516.             $productListing,
  517.             $request->get('page', 1),
  518.             ($pagelimit)?$pagelimit:24
  519.         );
  521.        // p_r(get_class_methods($paginator));exit;
  522.         $params['results'] = $paginator;
  523.         $params['paginationVariables'] = $paginator->getPaginationData();
  524.         $params['totalCount'] = $paginator->getTotalItemCount();
  525.         $params['offset'] = $paginator->getCurrentPageNumber();
  526.         $params['limit'] =  $pagelimit;
  528.         $params['isMecstoreUser'] =  false;
  529.         $partner = $user->getPartner();
  530.         if($partner->getisMecstoreHQ()){
  531.             $params['isMecstoreUser'] =  true;
  532.         }
  534.         //p_r($params);exit;
  536.         if ($request->attributes->get('noLayout')) {
  537.             return $this->render('product/listing_content.html.twig', $params);
  538.         }
  540.         // track product impressions
  541.         $trackingManager = $ecommerceFactory->getTrackingManager();
  542.         foreach ($paginator as $product) {
  543.             $trackingManager->trackProductImpression($product, 'grid');
  544.         }
  545.         //p_r($params);exit;
  546.         return $this->render('product/listing.html.twig', $params);
  547.     }
  550.     /**
  551.      * @Route("/shop-by-brand/{brandname}~c{brand}", name="shop-brand")
  552.      *
  553.      * @param Request $request
  554.      * @param HeadTitle $headTitleHelper
  555.      * @param BreadcrumbHelperService $breadcrumbHelperService
  556.      * @param Factory $ecommerceFactory
  557.      * @param SegmentTrackingHelperService $segmentTrackingHelperService
  558.      * @param ListHelper $listHelper
  559.      *
  560.      * @return Response
  561.      */
  562.     public function listingBrandsAction(Request $request, HeadTitle $headTitleHelper, BreadcrumbHelperService $breadcrumbHelperService, Factory $ecommerceFactory, SegmentTrackingHelperService $segmentTrackingHelperService, ListHelper $listHelper, PaginatorInterface $paginator,UserInterface $user)
  563.     {
  564.         $params = array_merge($request->query->all(), $request->attributes->all());
  566.         $params['maxRange'] = 10;
  568.         //Get pricelist name
  569.         $priceListName = DEFAULT_PRICELIST_COLUMN;
  570.         if($user){
  571.             $partner = $user->getPartner();
  572.             if($partner){
  573.                 //$priceListName = $partner->getPriceList();
  574.             }
  575.         }
  577.         //needed to make sure category filter filters for active category
  578.         $params['parentCategoryIds'] = $params['category'] ?? null;
  580.         $brand = Manufacturer::getById($params['brand'] ?? null);
  581.         $params['manufacturer'] = $brand;
  582.         if ($brand) {
  583.             $headTitleHelper($brand->getName());
  584.         }else{
  585.             $brand = new \stdClass();
  586.             $brand->name = "tutto il catalogo";
  587.             $params['manufacturer'] = $brand;
  588.         }
  590.         $indexService = $ecommerceFactory->getIndexService();
  591.         $productListing = $indexService->getProductListForCurrentTenant();
  592.         $productListing->addCondition("disabled != 1");
  593.         $params['term'] = isset($params['term'])?$params['term']:"";
  594.         if(isset($params['term'])){
  595.             $brandName = $brand->getName();
  596.             //p_r($params);
  597.             //p_r('lower(description) LIKE "%'.strtolower($params['term']).'%"');exit;
  598.             if(strtolower($params['term']) != "ovunque"){
  600.                 //echo "searchelem LIKE '%".$brandName."%' OR lower(searchelem) LIKE '".strtolower($params['term'])."%'";exit;
  601.                 if($params['term'])
  602.                 {
  603.                     $productListing->addCondition("manufacturer_name LIKE '%".$brandName."%' OR lower(searchelem) LIKE '%".strtolower($params['term'])."%'");
  604.                 }else{
  605.                     $productListing->addCondition("manufacturer_name LIKE '%".$brandName."%'");
  606.                 }
  608.             }else
  609.             {
  610.                 $productListing->addCondition("searchelem LIKE '%".$brandName."%'");
  611.             }
  612.         }
  614.         // $productListing->setOrderKey('o_id');
  615.         // $productListing->setOrder('asc');
  616.         if(isset($params['orderby'])){
  617.            // p_r($params['orderby']);exit;
  618.             if($params['orderby'] == "price")
  619.             {
  620.                 $productListing->setOrderKey($priceListName);
  621.                 $productListing->setOrder('asc');
  623.             }else if($params['orderby'] == "price-desc"){
  625.                 $productListing->setOrderKey($priceListName);
  626.                 $productListing->setOrder('DESC');
  628.             }else if($params['orderby'] == "date"){
  630.                 $productListing->setOrderKey('o_id');
  631.                 $productListing->setOrder('DESC');
  633.             }else if($params['orderby'] == "popularity"){
  635.                 // $productListing->setOrderKey('price');
  636.                 // $productListing->setOrder('DESC');
  637.             }
  638.         }else{
  639.             $productListing->setOrderKey('manufacturer_name = "'.$brandName.'"');
  640.             $productListing->setOrder('DESC');
  641.             $params['orderby'] = "manufacturer_name";
  642.         }
  643.         $params['productListing'] = $productListing;
  647.         $filterDefinition = Config::getWebsiteConfig()->get('manufacturerFilterdefinition');
  650.         $filterService = $ecommerceFactory->getFilterService();
  652.         // Get Max price
  653.         $maxPriceList = clone $productListing;
  654.         $maxParam = $params;
  655.         unset($maxParam['page']);
  656.         // p_r($maxParam);
  657.         // p_r($filterDefinition);
  658.         // p_r($maxPriceList);
  659.         // p_r($filterService);exit;
  660.         $listHelper->setupProductList($filterDefinition, $maxPriceList, $maxParam, $filterService, true);
  662.         $maxPriceList->setOrderKey($priceListName);
  663.         $maxPriceList->setOrder('desc');
  664.         $maxPriceList->setLimit(1);
  665.         $maxPriceItems = $maxPriceList->load();
  666.         if($maxPriceItems){
  667.             $params['maxRange'] = $maxPriceItems[0]->getPrice()+1;
  668.         }
  670.         //p_r($params);exit;
  671.         $listHelper->setupProductList($filterDefinition, $productListing, $params, $filterService, true);
  674.         $params['filterService'] = $filterService;
  675.         $params['filterDefinition'] = $filterDefinition;
  677.        // p_r(get_class_methods($productListing));exit;
  679.         //$
  680.         /** @var SlidingPagination $paginator */
  681.         // init pagination
  682.         $pagelimit = $request->get('limit', 12);
  683.         $paginator = $paginator->paginate(
  684.             $productListing,
  685.             $request->get('page', 1),
  686.             ($pagelimit)?$pagelimit:12
  687.         );
  689.        // p_r(get_class_methods($paginator));exit;
  690.         $params['results'] = $paginator;
  691.         $params['paginationVariables'] = $paginator->getPaginationData();
  692.         $params['totalCount'] = $paginator->getTotalItemCount();
  693.         $params['offset'] = $paginator->getCurrentPageNumber();
  694.         $params['limit'] =  $pagelimit;
  695.         $params['brandObj'] =  $brand;
  697.         $params['isMecstoreUser'] =  false;
  698.         $partner = $user->getPartner();
  699.         if($partner->getisMecstoreHQ()){
  700.             $params['isMecstoreUser'] =  true;
  701.         }
  703.         if ($request->attributes->get('noLayout')) {
  704.             return $this->render('product/listing_content_brand.html.twig', $params);
  705.         }
  707.         // track product impressions
  708.         $trackingManager = $ecommerceFactory->getTrackingManager();
  709.         foreach ($paginator as $product) {
  710.             $trackingManager->trackProductImpression($product, 'grid');
  711.         }
  712.         //p_r($params);exit;
  713.         return $this->render('product/shop-in-shop_listing.html.twig', $params);
  714.     }
  717.     /**
  718.      * @Route("/brand/{brandname}~c{brand}", name="shop-brand-product")
  719.      *
  720.      * @param Request $request
  721.      * @param HeadTitle $headTitleHelper
  722.      * @param BreadcrumbHelperService $breadcrumbHelperService
  723.      * @param Factory $ecommerceFactory
  724.      * @param SegmentTrackingHelperService $segmentTrackingHelperService
  725.      * @param ListHelper $listHelper
  726.      *
  727.      * @return Response
  728.      */
  729.     public function brandsProductsAction(Request $request, HeadTitle $headTitleHelper, BreadcrumbHelperService $breadcrumbHelperService, Factory $ecommerceFactory, SegmentTrackingHelperService $segmentTrackingHelperService, ListHelper $listHelper, PaginatorInterface $paginator,UserInterface $user)
  730.     {
  731.         $params = array_merge($request->query->all(), $request->attributes->all());
  733.         $params['maxRange'] = 10;
  735.         //Get pricelist name
  736.         $priceListName = DEFAULT_PRICELIST_COLUMN;
  737.         if($user){
  738.             $partner = $user->getPartner();
  739.             if($partner){
  740.                 //$priceListName = $partner->getPriceList();
  741.             }
  742.         }
  744.         //needed to make sure category filter filters for active category
  745.         $params['parentCategoryIds'] = $params['category'] ?? null;
  747.         $brand = Manufacturer::getById($params['brand'] ?? null);
  748.         $params['manufacturer'] = $brand;
  749.         if ($brand) {
  750.             $headTitleHelper($brand->getName());
  751.         }else{
  752.             $brand = new \stdClass();
  753.             $brand->name = "tutto il catalogo";
  754.             $params['manufacturer'] = $brand;
  755.         }
  757.         $indexService = $ecommerceFactory->getIndexService();
  758.         $productListing = $indexService->getProductListForCurrentTenant();
  759.         $productListing->addCondition("disabled != 1");
  760.         $params['term'] = isset($params['term'])?$params['term']:"";
  761.         if(isset($params['term'])){
  762.             $brandName = $brand->getName();
  763.             //p_r($params);
  764.             //p_r('lower(description) LIKE "%'.strtolower($params['term']).'%"');exit;
  765.             if(strtolower($params['term']) != "ovunque"){
  767.                 //echo "searchelem LIKE '%".$brandName."%' OR lower(searchelem) LIKE '".strtolower($params['term'])."%'";exit;
  768.                 if($params['term'])
  769.                 {
  770.                     $productListing->addCondition("manufacturer_name LIKE '%".$brandName."%' OR lower(searchelem) LIKE '%".strtolower($params['term'])."%'");
  771.                 }else{
  772.                     $productListing->addCondition("searchelem LIKE '%".$brandName."%'");
  773.                 }
  775.             }else
  776.             {
  777.                 $productListing->addCondition("searchelem LIKE '%".$brandName."%'");
  778.             }
  779.         }
  781.         // $productListing->setOrderKey('o_id');
  782.         // $productListing->setOrder('asc');
  783.         if(isset($params['orderby'])){
  784.            // p_r($params['orderby']);exit;
  785.             if($params['orderby'] == "price")
  786.             {
  787.                 $productListing->setOrderKey($priceListName);
  788.                 $productListing->setOrder('asc');
  790.             }else if($params['orderby'] == "price-desc"){
  792.                 $productListing->setOrderKey($priceListName);
  793.                 $productListing->setOrder('DESC');
  795.             }else if($params['orderby'] == "date"){
  797.                 $productListing->setOrderKey('o_id');
  798.                 $productListing->setOrder('DESC');
  800.             }else if($params['orderby'] == "popularity"){
  802.                 // $productListing->setOrderKey('price');
  803.                 // $productListing->setOrder('DESC');
  804.             }
  805.         }else{
  806.             $productListing->setOrderKey('manufacturer_name = "'.$brandName.'"');
  807.             $productListing->setOrder('DESC');
  808.             $params['orderby'] = "manufacturer_name";
  809.         }
  810.         $params['productListing'] = $productListing;
  814.         $filterDefinition = Config::getWebsiteConfig()->get('manufacturerFilterdefinition');
  817.         $filterService = $ecommerceFactory->getFilterService();
  819.         // Get Max price
  820.         $maxPriceList = clone $productListing;
  821.         $maxParam = $params;
  822.         unset($maxParam['page']);
  823.         // p_r($maxParam);
  824.         // p_r($filterDefinition);
  825.         // p_r($maxPriceList);
  826.         // p_r($filterService);exit;
  827.         $listHelper->setupProductList($filterDefinition, $maxPriceList, $maxParam, $filterService, true);
  829.         $maxPriceList->setOrderKey($priceListName);
  830.         $maxPriceList->setOrder('desc');
  831.         $maxPriceList->setLimit(1);
  832.         $maxPriceItems = $maxPriceList->load();
  833.         if($maxPriceItems){
  834.             $params['maxRange'] = $maxPriceItems[0]->getPrice()+1;
  835.         }
  837.         //p_r($params);exit;
  838.         $listHelper->setupProductList($filterDefinition, $productListing, $params, $filterService, true);
  841.         $params['filterService'] = $filterService;
  842.         $params['filterDefinition'] = $filterDefinition;
  844.        // p_r(get_class_methods($productListing));exit;
  846.         //$
  847.         /** @var SlidingPagination $paginator */
  848.         // init pagination
  849.         $pagelimit = $request->get('limit', 12);
  850.         $paginator = $paginator->paginate(
  851.             $productListing,
  852.             $request->get('page', 1),
  853.             ($pagelimit)?$pagelimit:12
  854.         );
  856.        // p_r(get_class_methods($paginator));exit;
  857.         $params['results'] = $paginator;
  858.         $params['paginationVariables'] = $paginator->getPaginationData();
  859.         $params['totalCount'] = $paginator->getTotalItemCount();
  860.         $params['offset'] = $paginator->getCurrentPageNumber();
  861.         $params['limit'] =  $pagelimit;
  862.         $params['brandObj'] =  $brand;
  864.         $params['isMecstoreUser'] =  false;
  865.         $partner = $user->getPartner();
  866.         if($partner->getisMecstoreHQ()){
  867.             $params['isMecstoreUser'] =  true;
  868.         }
  870.         if ($request->attributes->get('noLayout')) {
  871.             return $this->render('product/listing_content_brand.html.twig', $params);
  872.         }
  874.         // track product impressions
  875.         $trackingManager = $ecommerceFactory->getTrackingManager();
  876.         foreach ($paginator as $product) {
  877.             $trackingManager->trackProductImpression($product, 'grid');
  878.         }
  879.         //p_r($params);exit;
  880.         return $this->render('product/shop-in-shop.html.twig', $params);
  881.     }
  883.     /**
  884.      * @param Request $request
  885.      * @param Factory $ecommerceFactory
  886.      *
  887.      * @return Response
  888.      */
  889.     public function productTeaserAction(Request $request, Factory $ecommerceFactory)
  890.     {
  891.         $paramsBag = [];
  892.         if ($request->get('type') == 'object') {
  893.             AbstractObject::setGetInheritedValues(true);
  894.             $product = AbstractProduct::getById($request->get('id'));
  896.             $paramsBag['product'] = $product;
  897.             $paramsBag['backend'] = true;
  899.             //track product impression
  900.             $trackingManager = $ecommerceFactory->getTrackingManager();
  901.             $trackingManager->trackProductImpression($product, 'teaser');
  903.             return $this->render('product/product_teaser.html.twig', $paramsBag);
  904.         }
  906.         throw new NotFoundHttpException('Product not found.');
  907.     }
  909.     /**
  910.      * @Route("/search", name="search")
  911.      *
  912.      * @param Request $request
  913.      * @param ListHelper $listHelper
  914.      * @param Factory $ecommerceFactory
  915.      * @param ProductLinkGenerator $productLinkGenerator
  916.      * @param Translator $translator
  917.      * @param BreadcrumbHelperService $breadcrumbHelperService
  918.      * @param HeadTitle $headTitleHelper
  919.      * @param Placeholder $placeholder
  920.      *
  921.      * @return Response|JsonResponse
  922.      */
  923.     public function searchAction(Request $request, ListHelper $listHelper, Factory $ecommerceFactory, ProductLinkGenerator $productLinkGenerator, Translator $translator, BreadcrumbHelperService $breadcrumbHelperService, HeadTitle $headTitleHelper, Placeholder $placeholder, PaginatorInterface $paginator)
  924.     {
  925.         $params = $request->query->all();
  927.         $params['category'] = Category::getById($params['category'] ?? null);
  929.         $indexService = $ecommerceFactory->getIndexService();
  930.         $productListing = $indexService->getProductListForCurrentTenant();
  931.         $productListing->setVariantMode(ProductListInterface::VARIANT_MODE_VARIANTS_ONLY);
  933.         $term = strip_tags($request->get('term'));
  935.         if($productListing instanceof AbstractElasticSearch) {
  937.             // simple elastic search query - uses multi-match query on all defined search_attributes
  938. //            $productListing->addQueryCondition($term);
  940.             //sample for a more specific elastic search query - not considers search_attributes but provides full flexibility
  941.             // this query weights cars more that accessories
  942.             $query = [
  943.                 'function_score' => [
  944.                     'query' => [
  945.                         'multi_match' => [
  946.                             "query" => $term,
  947.                             "type" => "cross_fields",
  948.                             "operator" => "and",
  949.                             "fields" => [
  950.                                 "attributes.name^4",
  951.                                 "attributes.name.analyzed",
  952.                                 "attributes.name.analyzed_ngram",
  953.                                 "attributes.manufacturer_name^3",
  954.                                 "attributes.manufacturer_name.analyzed",
  955.                                 "attributes.manufacturer_name.analyzed_ngram",
  956.                                 "attributes.color",
  957.                                 "attributes.color.analyzed",
  958.                                 "attributes.color.analyzed_ngram",
  959.                                 "attributes.carClass",
  960.                                 "attributes.carClass.analyzed",
  961.                                 "attributes.carClass.analyzed_ngram"
  962.                             ]
  963.                         ]
  964.                     ],
  965.                     'functions' => [
  966.                         [
  967.                             'filter' => ['match' => ['system.o_classId' => 'AP']],
  968.                             'weight' => 1
  969.                         ],
  970.                         [
  971.                             'filter' => ['match' => ['system.o_classId' => 'CAR']],
  972.                             'weight' => 2
  973.                         ]
  974.                     ],
  975.                     'boost_mode' => 'multiply'
  976.                 ]
  978.             ];
  980.             $productListing->addQueryCondition($query, 'searchTerm');
  983.         } else {
  985.             //default mysql search query condition - would also work for elastic search in that way
  986.             $term = trim(preg_replace('/\s+/', ' ', $term));
  988.             if (!empty($term)) {
  989.                 foreach (explode(' ', $term) as $t) {
  990.                     $productListing->addQueryCondition($t);
  991.                 }
  992.             }
  994.         }
  997.         if (isset($params['autocomplete'])) {
  998.             $resultset = [];
  999.             $productListing->setLimit(10);
  1000.             foreach ($productListing as $product) {
  1001.                 $result['href'] = $productLinkGenerator->generateWithMockup($product, []);
  1002.                 if ($product instanceof Car) {
  1003.                     $result['product'] = $product->getOSName() . ' ' . $product->getColor()[0] . ', ' . $product->getCarClass();
  1004.                 } else {
  1005.                     $result['product'] = $product->getOSName();
  1006.                 }
  1008.                 $resultset[] = $result;
  1009.             }
  1011.             return $this->json($resultset);
  1012.         }
  1014.         $filterDefinition = $params['filterDefinition'] = Config::getWebsiteConfig()->get('fallbackFilterdefinition');
  1016.         // create and init filter service
  1017.         $filterService = Factory::getInstance()->getFilterService();
  1019.         $listHelper->setupProductList($filterDefinition, $productListing, $params, $filterService, true);
  1021.         $params['filterService'] = $filterService;
  1022.         $params['products'] = $productListing;
  1024.         // init pagination
  1025.         $paginator = $paginator->paginate(
  1026.             $productListing,
  1027.             $request->get('page', 1),
  1028.             $filterDefinition->getPageLimit()
  1029.         );
  1032.         $params['results'] = $paginator;
  1033.         $params['paginationVariables'] = $paginator->getPaginationData();
  1035.         $trackingManager = $ecommerceFactory->getTrackingManager();
  1036.         foreach ($paginator as $product) {
  1037.             $trackingManager->trackProductImpression($product, 'search-results');
  1038.         }
  1040.         //breadcrumbs
  1041.         $placeholder('addBreadcrumb')->append([
  1042.             'parentId' => $this->document->getId(),
  1043.             'id' => 'search-result',
  1044.             'label' => $translator->trans('shop.search-result', [$term])
  1045.         ]);
  1047.         $params['language'] = $request->getLocale();
  1048.         $params['term'] = $term;
  1050.         $breadcrumbHelperService->enrichGenericDynamicPage($translator->trans('shop.search-result', [$term]));
  1051.         $headTitleHelper($translator->trans('shop.search-result', [$term]));
  1053.         return $this->render('product/search.html.twig', $params);
  1054.     }
  1056.     private function getProductsInWishList($user){
  1057.         $products = new \Pimcore\Model\DataObject\Wishlist\Listing();
  1058.         $products->setCondition('user__id = ?',[$user->getId()]);
  1059.         return $products->getCount();
  1060.     }
  1062.     /**
  1063.      * @Route("/get-product-statistics/{id}", name="get-product-statistics")
  1064.      *
  1065.      * @param Request $request
  1066.      *
  1067.      * @return Response|JsonResponse
  1068.      */
  1069.     public function getProductStatistics(Request $request,UserInterface $user = null){
  1071.         $order = new Order();
  1072.         $db = \Pimcore\Db::get();
  1073.         $response = [];
  1074.         $jsonResponse = [];
  1076.         $partner = $user->getPartner();
  1077.         // p_r($partner->getisMecstoreHQ());exit;
  1078.         if($partner->getisMecstoreHQ()){
  1079.             try{
  1080.                 $productId = $request->get('id',null);
  1081.                 if(!$productId){
  1082.                     throw new \Exception("Product not found ");
  1083.                 }
  1085.                 // Product
  1086.                 $product = \Pimcore\Model\DataObject::getById($productId);
  1088.                 //User
  1089.                 $partner = $user->getPartner();
  1091.                 // Order statistics
  1092.                 $response['order'] = $order->getOrderStatistics($db,$productId);
  1094.                 //print_r($response['order']); die();
  1096.                 $deliveredQty = $this->getProductDeliveredQty($response['order'], $product->getItem());
  1098.                 $response['deliveredQty'] = (float)$deliveredQty;
  1100.                 $this->deleteOrdersDeleted($response['order']);
  1102.                 // Booking statistics
  1103.                 $response['booking'] = $order->getBookingStatistics($db,$productId);
  1105.                 // Booking statistics
  1106.                 $response['draft'] = $order->getBookingStatistics($db,$productId,'draft');
  1109.                 // Pre Order statistics
  1110.                 $response['pre_order'] = $order->getPreOrderStatistics($db,$productId);
  1112.                 $response['item'] = \App\Model\Utility::getOrders([$product->getItem()],$partner->getCustSupp());
  1114.                 $response['product'] = $product;
  1116.                 $response['giacenza'] = $this->getProductGiacenza($product->getItem());
  1118.             //  p_r($response);exit;
  1119.                 $jsonResponse['success'] = true;
  1121.                 $html = $this->renderView('product/_availability_modal.html.twig',$response);
  1123.                 $jsonResponse['html'] = $html;
  1126.             }catch(\Exception $ex){
  1127.                 $jsonResponse['success'] = false;
  1128.                 $jsonResponse['message'] = $ex->getMessage();
  1129.             }
  1130.         }
  1132.         return $this->json($jsonResponse);
  1134.     }
  1136.     public function getBranches(SessionInterface $session = null, UserInterface $user){
  1138.         $branches = [];
  1139.         if($user){
  1140.             $partner = $user->getPartner();
  1141.             if($partner){
  1142.                 $taxIdNumber = $partner->getTaxIdNumber();
  1143.                 if($user->getUserRoles() == "Executive" || $user->getUserRoles() == "Customer" || $user->getUserRoles() == "Affiliate"){
  1144.                     $branches[] = $partner->getId();
  1145.                 }
  1146.                 else if($user->getUserRoles() == 'Manager'){
  1147.                     $partnerBranches = new DataObject\Partners\Listing();
  1148.                     $partnerBranches->setCondition("TaxIdNumber = ?",[$partner->getTaxIdNumber()]);
  1149.                     $partnerBranches = $partnerBranches->load();
  1150.                     if($partnerBranches)
  1151.                     {
  1152.                         foreach($partnerBranches as $branch){
  1153.                             $branches[] = $branch->getId();
  1154.                         }
  1155.                     }
  1156.                 }
  1157.             }
  1158.         }
  1160.         return $branches;
  1161.     }
  1163.     /**
  1164.      * @Route("/get-product-opd/{id}", name="get-product-opd")
  1165.      *
  1166.      * @param Request $request
  1167.      *
  1168.      * @return Response|JsonResponse
  1169.      */
  1170.     public function getProductOpd(Request $request,UserInterface $user = null, PaginatorInterface $paginator, SessionInterface $session){
  1172.         $order = new Order();
  1173.         $db = \Pimcore\Db::get();
  1174.         $response = [];
  1175.         $jsonResponse = [];
  1177.         $partner = $user->getPartner();
  1178.         $branches = $this->getBranches($session,$user);
  1179.         // p_r($partner->getisMecstoreHQ());exit;
  1180.         if(true){
  1181.             try{
  1182.                 $productId = $request->get('id',null);
  1183.                 if(!$productId){
  1184.                     throw new \Exception("Product not found ");
  1185.                 }
  1187.                 // Product
  1188.                 $product = \Pimcore\Model\DataObject::getById($productId);
  1190.                 //User
  1191.                 $partner = $user->getPartner();
  1193.                 // Order statistics
  1194.                 $response['order'] = $order->getCustomerOrderWithProduct($db, $user->getId(), $productId);
  1196.                 //print_r($response['order']); die();
  1198.                 $deliveredQty = $this->getProductDeliveredQty($response['order'], $product->getItem());
  1200.                 $response['deliveredQty'] = (float)$deliveredQty;
  1202.                 //$this->deleteOrdersDeleted($response['order']);
  1204.                 // Booking statistics
  1205.                 $response['booking'] = $order->getCustomerPrenotazioniProduct($db, $user->getId(), $productId);
  1207.                 // Booking statistics
  1208.                 $response['draft'] = $order->getCustomerDraftWithProduct($db, $user->getId(), $productId);
  1211.                 // Pre Order statistics
  1212.                 $response['pre_order'] = $order->getCustomerPreorderProduct($db, $user->getId(), $productId);
  1214.                 $response['item'] = \App\Model\Utility::getOrders([$product->getItem()],$partner->getCustSupp());
  1216.                 $response['product'] = $product;
  1219.                 //  p_r($response);exit;
  1220.                 $jsonResponse['success'] = true;
  1222.                 $html = $this->renderView('product/_opd_modal.html.twig',$response);
  1224.                 $jsonResponse['html'] = $html;
  1227.             }catch(\Exception $ex){
  1228.                 $jsonResponse['success'] = false;
  1229.                 $jsonResponse['message'] = $ex->getMessage();
  1230.             }
  1231.         }
  1233.         return $this->json($jsonResponse);
  1235.     }
  1237.     /**
  1238.      * @Route("/get-products-opd/{ids}", name="get-products-opd")
  1239.      *
  1240.      * @param Request $request
  1241.      *
  1242.      * @return Response|JsonResponse
  1243.      */
  1244.     public function getProductsOpd(Request $request,UserInterface $user = null, PaginatorInterface $paginator, SessionInterface $session){
  1246.         $order = new Order();
  1247.         $db = \Pimcore\Db::get();
  1248.         $response = [];
  1249.         $jsonResponse = [];
  1251.         $partner = $user->getPartner();
  1252.         $branches = $this->getBranches($session,$user);
  1253.         $ids = explode(",", substr($request->get('ids',null),1));
  1254.         //p_r($ids);
  1255.         // p_r($partner->getisMecstoreHQ());exit;
  1256.         $data = [];
  1257.         if(true){
  1258.             foreach($ids as $productId) {
  1259.                 try {
  1260.                     if (!$productId) {
  1261.                         continue;
  1262.                     }
  1264.                     $temp = [];
  1266.                     // Product
  1267.                     $product = \Pimcore\Model\DataObject::getById($productId);
  1269.                     //User
  1270.                     $partner = $user->getPartner();
  1272.                     // Order statistics
  1273.                     $response['order'] = $order->getCustomerOrderWithProduct($db, $user->getId(), $productId);
  1275.                     //print_r($response['order']); die();
  1277.                     $deliveredQty = $this->getProductDeliveredQty($response['order'], $product->getItem());
  1279.                     $response['deliveredQty'] = (float)$deliveredQty;
  1281.                     //$this->deleteOrdersDeleted($response['order']);
  1283.                     // Booking statistics
  1284.                     $response['booking'] = $order->getCustomerPrenotazioniProduct($db, $user->getId(), $productId);
  1286.                     // Booking statistics
  1287.                     $response['draft'] = $order->getCustomerDraftWithProduct($db, $user->getId(), $productId);
  1290.                     // Pre Order statistics
  1291.                     $response['pre_order'] = $order->getCustomerPreorderProduct($db, $user->getId(), $productId);
  1293.                     //$response['item'] = \App\Model\Utility::getOrders([$product->getItem()], $partner->getCustSupp());
  1295.                     //$response['product'] = $product;
  1297.                     if(
  1298.                         count($response['order'])>0 ||
  1299.                         $response['booking'][0]['order_id'] != '' ||
  1300.                         count($response['draft'])>0 ||
  1301.                         $response['pre_order'][0]['company'] != ''
  1302.                     ){
  1303.                         $temp[$productId] = 'custom-yellow';
  1304.                     }else{
  1305.                         $temp[$productId] = 'custom-green';
  1306.                     }
  1308.                     $data[] = $temp;
  1311.                 } catch (\Exception $ex) {
  1312.                     $data[] = $ex->getMessage();
  1313.                 }
  1314.             }
  1315.         }
  1317.         return $this->json($data);
  1319.     }
  1321.     public function deleteOrdersDeleted($listaOrdini){
  1322.         //print_r($listaOrdini);
  1323.         $salesOrdersIds = [];
  1324.         foreach($listaOrdini as $ordine){
  1325.             $ord = \Pimcore\Model\DataObject\OnlineShopOrder::getById($ordine['order_id'], true);
  1326.             $salesOrdersIds[] = $ord->getSalesOrderId();
  1327.         }
  1328.         $salesOrdersIds = implode(",", $salesOrdersIds);
  1329.         //echo $salesOrdersIds;
  1331.         $responseArr = [];
  1332.         if($salesOrdersIds != '') {
  1333.             $curl = new CurlService();
  1334.             try {
  1335.                 $request = '<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:tem="http://tempuri.org/">
  1336.             <soapenv:Header/>
  1337.             <soapenv:Body>
  1338.                 <tem:getNumOrdNoMatch>
  1339.                     <tem:Token_Client>' . SOAP_TOKEN . '</tem:Token_Client>
  1340.                     <tem:ListSaleOrdId>' . $salesOrdersIds . '</tem:ListSaleOrdId>
  1341.                 </tem:getNumOrdNoMatch>
  1342.             </soapenv:Body>
  1343.             </soapenv:Envelope>';
  1344.                 \Pimcore\Log\Simple::log('erp_order_request', $request);
  1345.                 $xml = sprintf($request, SOAP_TOKEN);
  1346.                 $response = $curl->getCurlResponseNew($request, $xml);
  1347.                 $ordersToDelete = $response->xpath('//ListaOrdiniRichiesti/SaleOrdId');
  1348.             } catch (Exception $e) {
  1349.                 //\Pimcore\Log\Simple::log('soap', $e->getMessage());
  1350.                 echo "ERRORE";
  1351.             }
  1352.             //echo $xml; //die();
  1353.             //print_r($response);
  1354.             //print_r($ordersToDelete); die();
  1355.             foreach ($ordersToDelete as $orderToDelete) {
  1356.                 $otd = \Pimcore\Model\DataObject\OnlineShopOrder::getBySalesOrderId($orderToDelete, true);
  1357.                 if ($otd) {
  1358.                     //echo $otd->getOrdernumber();
  1359.                     $otd->delete();
  1360.                 }
  1361.             }
  1362.         }
  1363.     }
  1365.     private function getProductGiacenza($productId)
  1366.     {
  1367.         $curl = new CurlService();
  1368.         $request = '<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:tem="http://tempuri.org/">
  1369.             <soapenv:Header/>
  1370.             <soapenv:Body>
  1371.             <tem:getDisponibilitaItems>
  1372.                 <!--Optional:-->
  1373.                 <tem:Token_Client>'.SOAP_TOKEN.'</tem:Token_Client>
  1374.                 <!--Optional:-->
  1375.                 <tem:ListItems>'.$productId.'</tem:ListItems>
  1376.             </tem:getDisponibilitaItems>
  1377.             </soapenv:Body>
  1378.         </soapenv:Envelope>';
  1379.         // echo $request;exit;
  1380.         $xml = sprintf($request,SOAP_TOKEN);
  1381.         $response = $curl->getCurlResponseNew($request,$xml);
  1383.         $output = [
  1384.             'giacenza' => null,
  1385.             'disponibilita' => null
  1386.         ];
  1388.         if($response instanceof \SimpleXMLElement) {
  1389.             $results = $response->xpath('//Disponibilita/Giacenza');
  1391.             foreach ($results as $item) {
  1392.                 $xmlResponse = (array)$item;
  1393.                 if (isset($xmlResponse[0])) {
  1394.                     $output['giacenza'] = $xmlResponse[0];
  1395.                 }
  1396.             }
  1398.             $results = $response->xpath('//Disponibilita/Disponibilita');
  1400.             foreach ($results as $item) {
  1401.                 $xmlResponse = (array)$item;
  1402.                 if (isset($xmlResponse[0])) {
  1403.                     $output['disponibilita'] = $xmlResponse[0];
  1404.                 }
  1405.             }
  1406.         }
  1408.         return $output;
  1409.     }
  1411.     private function getProductDeliveredQty($orderId, $item){
  1413.         $return = 0;
  1414.         if(isset($orderId[0]['order_id'])) {
  1415.             $ord = \Pimcore\Model\DataObject\OnlineShopOrder::getById($orderId[0]['order_id'], true);
  1416.             if ($ord) {
  1417.                 $salesOrderId = $ord->getSalesOrderId();
  1418.                 $curl = new CurlService();
  1419.                 $request = '<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:tem="http://tempuri.org/">
  1420.                 <soapenv:Header/>
  1421.                 <soapenv:Body>
  1422.                     <tem:getMembersSaleOrdersDetails_Parameters>
  1423.                         <!--Optional:-->
  1424.                         <tem:Token_Client>%s</tem:Token_Client>
  1425.                         <!--Optional:-->
  1426.                         <tem:ToDate></tem:ToDate>
  1427.                         <!--Optional:-->
  1428.                         <tem:Customer/>
  1429.                         <tem:FromSaleOrdId>%s</tem:FromSaleOrdId>
  1430.                         <!--Optional:-->
  1431.                         <tem:LimitRecords>1</tem:LimitRecords>
  1432.                         <!--Optional:-->
  1433.                         <tem:FromDate></tem:FromDate>
  1434.                     </tem:getMembersSaleOrdersDetails_Parameters>
  1435.                 </soapenv:Body>
  1436.                 </soapenv:Envelope>';
  1437.                 $xml = sprintf($request, SOAP_TOKEN, $salesOrderId);
  1438.                 $response = $curl->getCurlResponseNew($request, $xml);
  1439.                 //print_r($response);
  1440.                 $membersOrdersDetails = $response->xpath('//MembersOrdersDetailsParameters');
  1441.                 if (count($membersOrdersDetails)) {
  1442.                     foreach ($membersOrdersDetails as $membersOrderDetails) {
  1443.                         if ($membersOrderDetails->Item == $item) {
  1444.                             $return = $membersOrderDetails->DeliveredQty;
  1445.                         }
  1446.                     }
  1447.                 }
  1448.             }
  1449.         }
  1450.         return $return;
  1451.     }
  1453.     /**
  1454.      * @Route("/admin/tutti-i-prodotti", name="tutti-i-prodotti")
  1455.      *
  1456.      * @param Request $request
  1457.      * @param HeadTitle $headTitleHelper
  1458.      * @param BreadcrumbHelperService $breadcrumbHelperService
  1459.      * @param Factory $ecommerceFactory
  1460.      * @param SegmentTrackingHelperService $segmentTrackingHelperService
  1461.      * @param ListHelper $listHelper
  1462.      *
  1463.      * @return Response
  1464.      */
  1465.     public function tuttiIProdottiAction(Request $request, HeadTitle $headTitleHelper, BreadcrumbHelperService $breadcrumbHelperService, Factory $ecommerceFactory, SegmentTrackingHelperService $segmentTrackingHelperService, ListHelper $listHelper, PaginatorInterface $paginator,UserInterface $user, SessionInterface $session)
  1466.     {
  1467.         $masterFilterDefinition = Config::getWebsiteConfig()->get('masterFilterDefinition');
  1468.         $params = array_merge($request->query->all(), $request->attributes->all());
  1470.         $addToDraftEnabled = 0;
  1471.         $draftOrder = false;
  1473.         $params['addToDraftEnabled'] = $addToDraftEnabled;
  1474.         $params['draftOrder'] = $draftOrder;
  1476.         $params['maxRange'] = 10;
  1478.         //Get pricelist name
  1479.         $priceListName = DEFAULT_PRICELIST_COLUMN;
  1482.         //needed to make sure category filter filters for active category
  1483.         $params['parentCategoryIds'] = $params['category'] ?? null;
  1485.         $category = Category::getById($params['category'] ?? null);
  1488.         $params['category'] = $category;
  1489.         if ($category) {
  1490.             $headTitleHelper($category->getName());
  1491.             $breadcrumbHelperService->enrichCategoryPage($category);
  1492.         }else{
  1493.             $category = new \stdClass();
  1494.             $category->name = "tutto il catalogo";
  1495.             $params['category'] = $category;
  1496.         }
  1498.         $indexService = $ecommerceFactory->getIndexService();
  1499.         $productListing = $indexService->getProductListForCurrentTenant();
  1500.         $productListing->addCondition("disabled != 1");
  1501.         //p_r(get_class_methods($productListing));exit;
  1502.         $params['term'] = isset($params['term'])?$params['term']:"";
  1504.         if(isset($params['term'])){
  1505.             //p_r($params);
  1506.             //p_r('lower(description) LIKE "%'.strtolower($params['term']).'%"');exit;
  1507.             if(strtolower($params['term']) != "ovunque"){
  1509.                 if($category instanceof \Pimcore\Model\DataObject){
  1510.                     if($params['term']){
  1512.                         $searchTerms = explode(" ",$params['term']);
  1513.                         if($searchTerms)
  1514.                         {
  1515.                             foreach($searchTerms as $term)
  1516.                             {
  1518.                                 $productListing->addCondition("searchelem LIKE '%".$term."%' AND categoryIds LIKE '%".$category->getId()."%'");
  1519.                             }
  1520.                         }
  1522.                     }else{
  1523.                         $productListing->addCondition("categoryIds LIKE '%".$category->getId()."%'");
  1524.                     }
  1526.                 }else{
  1527.                     if(is_object($category)){
  1528.                         if($category->name == "tutto il catalogo"){
  1529.                             $filterDefinition = $masterFilterDefinition;
  1530.                             $category->name = "RICERCA";
  1531.                         }
  1532.                     }
  1533.                     // echo "(lower(description) LIKE '".strtolower($params['term'])."%' OR lower(name) LIKE '".strtolower($params['term'])."%' )";exit;
  1534.                     if($params['term']){
  1535.                         $searchTerms = explode(" ",$params['term']);
  1536.                         if($searchTerms)
  1537.                         {
  1538.                             foreach($searchTerms as $term)
  1539.                             {
  1540.                                 $productListing->addCondition("searchelem LIKE '%".$term."%'");
  1541.                             }
  1542.                         }
  1543.                     }
  1544.                 }
  1546.             }
  1547.             else if($category)
  1548.             {
  1550.                 $productListing->addCondition("categories LIKE '%".$category->getId()."%'");
  1551.             }
  1553.         }
  1555.         $productListing->setOrderKey('o_id');
  1556.         $productListing->setOrder('asc');
  1557.         if(isset($params['orderby'])){
  1558.             // p_r($params['orderby']);exit;
  1559.             if($params['orderby'] == "price")
  1560.             {
  1561.                 $productListing->setOrderKey($priceListName);
  1562.                 $productListing->setOrder('asc');
  1564.             }else if($params['orderby'] == "price-desc"){
  1566.                 $productListing->setOrderKey($priceListName);
  1567.                 $productListing->setOrder('DESC');
  1569.             }else if($params['orderby'] == "date"){
  1571.                 $productListing->setOrderKey('o_id');
  1572.                 $productListing->setOrder('DESC');
  1574.             }else if($params['orderby'] == "popularity"){
  1576.                 // $productListing->setOrderKey('price');
  1577.                 // $productListing->setOrder('DESC');
  1578.             }
  1579.         }else{
  1580.             $params['orderby'] = "o_id";
  1581.         }
  1582.         $params['productListing'] = $productListing;
  1584.         // load current filter
  1585.         if ($category instanceof \Pimcore\Model\DataObject) {
  1586.             $filterDefinition = $category->getFilterdefinition();
  1588.             //track segments for personalization
  1589.             $segmentTrackingHelperService->trackSegmentsForCategory($category);
  1591.             $trackingManager = $ecommerceFactory->getTrackingManager();
  1592.             $trackingManager->trackCategoryPageView($category->getName(), null);
  1593.         }
  1595.         if ($request->get('filterdefinition') instanceof FilterDefinition) {
  1596.             $filterDefinition = $request->get('filterdefinition');
  1597.         }
  1599.         if (empty($filterDefinition)) {
  1600.             $filterDefinition = Config::getWebsiteConfig()->get('fallbackFilterdefinition');
  1601.         }
  1603.         $filterService = $ecommerceFactory->getFilterService();
  1607.         // Get Max price
  1608.         $maxPriceList = clone $productListing;
  1609.         $maxParam = $params;
  1610.         unset($maxParam['page']);
  1612.         //p_r($maxPriceList);exit;
  1614.         $listHelper->setupProductList($filterDefinition, $maxPriceList, $maxParam, $filterService, true);
  1617.         $maxPriceList->setOrderKey($priceListName);
  1618.         $maxPriceList->setOrder('desc');
  1619.         $maxPriceList->setLimit(1);
  1620.         $maxPriceItems = $maxPriceList->load();
  1621.         if($maxPriceItems){
  1622.             $getter = "getPrice";
  1623.             $params['maxRange'] = (int)$maxPriceItems[0]->$getter() +1;
  1624.         }
  1626.         $listHelper->setupProductList($filterDefinition, $productListing, $params, $filterService, true);
  1628.         //p_);
  1630.         $params['filterService'] = $filterService;
  1631.         $params['filterDefinition'] = $filterDefinition;
  1633.         //$
  1634.         /** @var SlidingPagination $paginator */
  1635.         // init pagination
  1636.         $pagelimit = $request->get('limit', 24);
  1637.         $paginator = $paginator->paginate(
  1638.             $productListing,
  1639.             $request->get('page', 1),
  1640.             99999
  1641.         );
  1643.         // p_r(get_class_methods($paginator));exit;
  1644.         $params['results'] = $paginator;
  1645.         $params['paginationVariables'] = $paginator->getPaginationData();
  1646.         $params['totalCount'] = $paginator->getTotalItemCount();
  1647.         $params['offset'] = $paginator->getCurrentPageNumber();
  1648.         $params['limit'] =  $pagelimit;
  1650.         $params['isMecstoreUser'] =  false;
  1652.         p_r($params);
  1654.         $contatore = 1;
  1655.         foreach($params['results'] as $item){
  1656.             echo $contatore.";".$item->getItem()."<br/>";
  1657.             $contatore++;
  1658.         }
  1660.         return new Response('');
  1661.     }
  1663. }