src/Controller/ShopController.php line 100

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use Pimcore\Controller\FrontendController;
  6. use App\Ecommerce\Tool\RecentlyViewedProducts;
  7. use Pimcore\Bundle\EcommerceFrameworkBundle\Factory;
  8. use Pimcore\Mail;
  9. use Pimcore\Model\DataObject\AvailabilityCountry;
  10. use Pimcore\Model\DataObject;
  11. use Pimcore\Http\RequestHelper;
  12. use Pimcore\Model\Search\Backend\Data;
  13. use Symfony\Component\HttpFoundation\Request;
  14. use OutputDataConfigToolkitBundle\Service;
  15. use Carbon\Carbon;
  16. use Zend\Paginator\Paginator;
  17. use Symfony\Component\HttpKernel\Event\FilterControllerEvent;
  18. // New way (using constructor injection)
  19. use Symfony\Component\DependencyInjection\ContainerInterface;
  20. use Pimcore\Bundle\EcommerceFrameworkBundle\IndexService\ProductList\ProductListInterface;
  21. use Pimcore\Bundle\EcommerceFrameworkBundle\FilterService\ListHelper;
  22. use App\Model\DataObject\CategoryAlcoholType;
  23. use Knp\Component\Pager\PaginatorInterface;
  24. use Pimcore\Twig\Extension\Templating\Placeholder;
  26. // class ShopController extends \Website\Controller\Action
  27. //class ShopController extends FrontendController
  28. class ShopController extends Action
  29. {
  32.    
  33.     public function onKernelController(FilterControllerEvent $event)
  34.     {
  35.         $this->view->preview = $event->getRequest()->get('pimcore_preview');
  36.         parent::onKernelController($event);
  37.         $this->view->category = DataObject\CategoryAlcoholType::getById($event->getRequest()->get('category'));
  38.     }
  41.     /**
  42.      * show product landing
  43.      */
  44.     public function brandListAction(Request $request)
  45.     {
  46.         //Set the layout and CSS Class
  47.         $params = [];
  48.         $params['language'] = $this->language;
  49.         $params['CssClass'] = "brand-page";
  50.         $params['locale'] = strtolower($request->getLocale());
  51.         $params['params'] = $request->request->all();
  52.         $params['preview'] = $request->get('pimcore_preview',null);
  53.         //$this->layout()->setLayout('product');
  54.         //$this->enableLayout();
  55.         //Get All the BrandVariety 
  56.         
  57.         //$brandvariety->load();
  59.         // Set Us as default country
  60.         $defaultCountry = DataObject\AvailabilityCountry::getByPath('/availability-countries/us');
  61.         if(isset($this->country)){
  62.             $availableCountry = $this->country;
  63.         }else{
  64.             $availableCountry = $defaultCountry;
  65.             $params['country']  = $defaultCountry;
  66.         }
  68.         //List all brands
  69.         $filter = array();
  70.         $brands = new DataObject\CategoryAlcoholType\Listing();        
  71.         $params['brands'] = $brands;
  72.         $brands->setOrderKey("AlcoholType");
  73.         $brands->setOrder("ASC");
  74.         foreach ($brands as $brand) {
  75.             $brandvariety_local = new DataObject\BrandExtension\Listing();            
  76. //            $brandvariety_local->setCondition(" Category like '%," . $brand->getId() . ",%'");
  77.             if (count($brandvariety_local) > 0) {
  78.                 $brandname = $brand->getAlcoholType();
  79.                 if (!empty($brandname)) {
  80.                     $firstCharacter = strtoupper(substr($brandname, 0, 1));
  81.                     $brandsSorted[$firstCharacter][] = $brand;
  82.                     if (!in_array($firstCharacter, $filter)) {
  83.                         $filter[] = $firstCharacter;                        
  84.                     }
  85.                 }
  86.             }
  87.         }
  88.         
  89.         sort($filter);
  90.         $params['filter'] = $filter;
  91.     $params['brandsSorted'] = $brandsSorted;
  92.         return $this->render('Shop/brandList.html.twig', $params);
  93.     }
  95.     /**
  96.      * show product landing
  97.      * @param Request $request
  98.      * @param ListHelper $listHelper
  99.      */
  100.     public function productLandingAction(Request $request,ListHelper $listHelper)
  101.     {        
  102.         $params = [];
  103.         $params['CssClass'] = "landing-page";
  104.         $params['locale'] = strtolower($request->getLocale());
  105.         $params['params'] = $request->request->all();
  106.         $params['preview'] = $request->get('pimcore_preview',null);
  107.         //$this->layout()->setLayout('product');
  109.         // Set Us as default country
  110.         $defaultCountry = DataObject\AvailabilityCountry::getByPath('/availability-countries/us');
  111.         if(isset($this->country)){
  112.             $availableCountry = $this->country;
  113.         }else{
  114.             $availableCountry = $defaultCountry;
  115.             $params['country'] = $defaultCountry;
  116.         }
  118.         $filterDefinition = \Pimcore\Model\DataObject\FilterDefinition::getByPath("/filter-definitions/default"); // \Pimcore\Config::getWebsiteConfig()->fallbackFilterdefinition;
  119.         $params['filterDefinitionObject'] = $filterDefinition;
  122.         // create product list
  123.         $products =Factory::getInstance()->getIndexService()->getProductListForCurrentTenant();
  124.         //$products->setVariantMode(ProductListInterface::VARIANT_MODE_HIDE);
  125.         //$products->addRelationCondition('CountryAvailabilityList', "dest IN (" . $availableCountry->getId() . ")");
  126.         
  127.         $params['products'] = $products;
  129.         $params =  @array_merge($params,$request->query->all());
  130.         // create and init filter service
  131.         $filterService = Factory::getInstance()->getFilterService();
  132.         $listHelper->setupProductList($filterDefinition, $products, $params,  $filterService, true);
  133.         $params['filterService'] = $filterService;
  134.         $params['valuesIndex'] = $this->getValueIndex($filterDefinition, $products);
  135.         $params['subCategories'] = CategoryAlcoholType::getTopLevelCategories();       
  136.         return $this->render('Shop/productLanding.html.twig',$params);
  139. //        $this->enableLayout();
  140.     }
  142.     /**
  143.      * get product value indexing
  144.      * @return  array
  145.      */
  146.     private function getValueIndex($filterDefinitionObject, $products){
  147.         $valuesIndex = array();
  148.         foreach ($filterDefinitionObject->getFilters() as $filter) {
  149.             $products->setVariantMode(ProductListInterface::VARIANT_MODE_HIDE);           
  150.             $rawValues = $products->getGroupByValues("parentCategoryids", true);                   
  151.             foreach($rawValues as $v) {
  152.                 $values[$v['value']] = array('value' => $v['value'], "count" => $v['count']);
  153.             }
  154.             // resort values
  155.             
  156.             if ($values) {
  157.               foreach($values as $entry)
  158.               {
  159.                 $ids = explode(",",$entry['value']);
  160.                   foreach ($ids as $id) {
  161.                     if (!empty($id)) {
  162.                       if (array_key_exists($id, $valuesIndex)) {
  163.                         $valuesIndex[ $id ] += $entry['count'] ;
  164.                       } else {
  165.                         $valuesIndex[ $id ] = $entry['count'] ;
  166.                       }
  167.                     }
  168.                   } 
  169.               }
  170.             }
  171.         } 
  172.         return $valuesIndex;
  173.     }
  174.     /**
  175.      * show product list
  176.      */
  177.     public function listAction(Request $request,ListHelper $listHelper, PaginatorInterface $paginator, Placeholder $placeholderHelper)
  178.     {          
  179.         //$params = array_merge($request->query->all(), $request->attributes->all());
  180.         
  181.         
  182.         $params['lastlogin'] = '';
  183.         $params['locale'] = strtolower($request->getLocale());
  184.         $params['params'] = $request->request->all();
  185.         $params['preview'] = $request->get('pimcore_preview',null);
  186.         $defaultCountry = DataObject\AvailabilityCountry::getByPath('/availability-countries/us');
  187.         if(isset($this->country)){
  188.             $availableCountry = $this->country;
  189.         }else{
  190.             $availableCountry = $defaultCountry;
  191.             $params['country'] = $defaultCountry;
  192.         }
  194.         //TODO  We will handle after user login and session 
  195.         $session = $request->getSession();
  196.         $authNamespace = $session->getBag('espirit');
  197.         if ($authNamespace && $authNamespace->has('customeraccount')) {
  198.             $orders = new DataObject\OnlineShopOrder\Listing();
  199.             $orders->setCondition(" customer__id = '" . $authNamespace->get('customeraccount')->getId() . "'");
  200.             $orders->setOrderKey("orderdate",false);
  201.             $orders->setOrder("desc");
  202.             $orders->setLimit(1);
  203.             $orders->load();
  204.             if (count($orders) > 0) {
  205.                 foreach ($orders as $order) {break;}
  206.                 $lastlogin = $order->getOrderDate();
  207.                 $params['lastlogin'] = $lastlogin->getTimestamp();
  208.         } else {
  209.                 $lastlogin = Carbon::now();
  210.                 $params['lastlogin'] = $lastlogin->getTimestamp();
  211.             }
  212.         }
  214.         //END TODO
  216.         //$this->layout()->setLayout('product');
  217.         $params['CssClass'] = "sub-category-page";
  219.         $params["parentCategoryIds"] = $request->get('category');
  220.         $params =  array_merge($params,$request->query->all());
  221.         
  222.         //$category = \Website\ShopCategory::getById($params['category']);
  223.         $category = CategoryAlcoholType::getById($request->get('category'));
  224.         $params['category'] = $category;
  225.         if ($request->get("Brand")) {
  226.             $brand = DataObject\Brand::getById($request->get('Brand'));
  227.             if ($brand) {
  228.                 $params['BrandName'] = $brand->getBrandName();
  229.             }
  230.         }
  232.         // load current filter
  233.         if($category) {
  234.             $filterDefinition = $category->getFilterdefinition();
  235.         }
  238.         if($request->get("filterdefinition") instanceof \Pimcore\Model\DataObject\FilterDefinition) {
  239.             $filterDefinition = $request->get("filterdefinition");
  240.             
  241.         }
  243.         if(empty($filterDefinition)) {
  244.             $filterDefinition = \Pimcore\Config::getWebsiteConfig()->get('fallbackFilterdefinition');
  245.         }
  246.         
  247.         $params['filterDefinitionObject'] = $filterDefinition;
  249.         
  250.         // create product list
  251.         $products = Factory::getInstance()->getIndexService()->getProductListForCurrentTenant();
  252.         //$products->setVariantMode(ProductListInterface::VARIANT_MODE_HIDE);
  253.         //$products->addCondition("is_default = 1");      
  254.        // $products->addRelationCondition('CountryAvailabilityList', "dest IN (" . $availableCountry->getId() . ")");    
  255.         
  256.         //search query
  257.         $query = $request->get("search");
  258.         
  259.         if ($query) {
  260.             $query = preg_replace('/[^A-Za-z0-9\-\ ]/', '', $query);
  261.             //$products->addCondition("SearchData LIKE " . $products->quote("%" . $query . "%"));
  262.             $products->addCondition("MATCH (`searchData`) AGAINST (" . $products->quote($query) . ")");
  263.             $params['search'] = $query;
  264.         }
  265.         // echo "<pre>"; print_r($products); die;
  266.         
  267.         $params['products'] = $products;
  268.         
  269.         // create and init filter service
  270.         $filterService = Factory::getInstance()->getFilterService();
  271.         $listHelper->setupProductList($filterDefinition, $products, $params,  $filterService, true);
  272.         $params['filterService'] = $filterService;
  273.         $params['filterDefinition'] = $filterDefinition;
  275.         // init pagination
  276.         $paginator = $paginator->paginate(
  277.             $products,
  278.             $request->get('page', 1),
  279.             12
  280.         );
  281.         $params['paginator']  = $paginator;
  282.         $params['paginationVariables']  = $paginator->getPaginationData();;
  284.        // $this->enableLayout();
  287.         //breadcrumbs
  288.     
  289.         if($category) {
  290.             $parentCategories = $category->getParentCategoryList(null, $this->document);
  291.             $parentCategories[] = $category;
  292.             foreach($parentCategories as $parentCategory) {
  293.                 $placeholderHelper->__invoke('addBreadcrumb')->append([
  294.                     'parentId' => "category-" . $parentCategory->getParentId(),
  295.                     'id' => "category-" . $parentCategory->getId(),
  296.                     'url' => $parentCategory->getDetailUrl(["document" => $this->document]),
  297.                     'label' => $parentCategory->getName()
  298.                 ]);
  300.                
  301.             }
  302.             
  303.             //$headTitleHelper = \Pimcore::getContainer()->get('pimcore.templating.view_helper.head_title');
  304.             //$headTitleHelper($category->getName());
  305.         }
  306.         return $this->render('Shop/list.html.twig', $params);
  307.     }
  310.     /**
  311.      * show product detail page
  312.      * @throws Zend_Controller_Router_Exception
  313.      */
  314.     public function detailAction(Request $request, RequestHelper $requestHelper) {
  315.         //Set the product layout
  316.         //$this->layout()->setLayout('product');
  317.         $params = [];
  318.         $params['CssClass'] = "detail-page";
  319.         $params['locale'] = strtolower($request->getLocale());
  320.         $params['params'] = $request->request->all();
  321.         $params['preview'] = $request->get('pimcore_preview',null);
  322.         // Set Us as default country
  323.         
  324.         $defaultCountry = DataObject\AvailabilityCountry::getByPath('/availability-countries/us');
  325.         if(isset($this->country)){
  326.             $availableCountry = $this->country;
  327.         }else{
  328.             $availableCountry = $defaultCountry;
  329.             //$this->view->country = $defaultCountry;
  330.             $params['country'] = $defaultCountry;
  331.         }
  332.         //$this->enableLayout();
  334.         // load product
  335.         $product = \App\Model\DataObject\BrandExtension::getById($request->get("product"));
  337.         if(!$product || (!$product->isActive() && !$requestHelper->isFrontendRequestByAdmin($request))) {
  338.             return $this->forward('error', ['error']);
  339.             //throw new Zend_Controller_Router_Exception("die gewünschte Seite existiert nicht mehr");
  340.         } else {
  341.             $params['product'] = $product;
  342.             
  343.             $categories = $product->getCategory();//Pimcore\Model\Object\CategoryAlcoholType::getById($this->getParam("category"));
  344.             if ($categories) foreach ($categories as $category) {break;}
  345.             // ...
  346.             $params['specificationOutputChannel'] = Service::getOutputDataConfig($product, "productdetail_specification");
  347.             $params['hasSpec'] = false;
  348.             
  349.             foreach($params['specificationOutputChannel'] as $x) {
  350.                 if($x->getLabeledValue($product)) {
  351.                     $params['hasSpec'] = true;
  352.                     break;
  353.                 }
  354.             }
  356.             //recently viewed products
  357.             $recently = new RecentlyViewedProducts( Factory::getInstance()->getEnvironment(), function($id) {
  358.                 return DataObject\BrandExtension::getById($id);
  359.             });
  362.             /*
  363.             $sizeVariants = $product->getSizeVariants();
  364.             if(empty($sizeVariants)) {
  365.                 $linkProduct = $product;
  366.             } else {
  367.                 $tmp = array_values($sizeVariants);
  368.                 $linkProduct = array_shift($tmp);
  369.             }
  370.             $this->view->recentlyViewed = $recently->addProduct( $linkProduct )->getProducts(4);
  371.             */
  372.             
  373.             $filterdefinition = null;
  374.             if($category) {
  375.                 $category = $category->getObject();
  376.                 $filterdefinition = $category->getFilterdefinition();
  377.             }
  378.             if(empty($filterdefinition)) {
  379.                 $filterdefinition = \Pimcore\Config::getWebsiteConfig()->fallbackFilterdefinition;
  380.             }
  381.             $params['similarProducts'] = $this->getSimilarProducts($product, $filterdefinition);
  383.             //breadcrumbs
  384.             $category = $product->getFirstCategory();
  385.             $container = \Pimcore::getKernel()->getContainer();
  387.             // $placeholder = $container->get('pimcore.templating.view_helper.placeholder');
  388.             // if($category) {
  389.             //     $parentCategories = $category->getParentCategoryList(null, $this->document);
  390.             //     $parentCategories[] = $category;
  391.             //     foreach($parentCategories as $index => $parentCategory) {
  392.             //         $placeholder('addBreadcrumb')->append([
  393.             //             'parentId' => "category-" . $parentCategory->getParentId()
  394.             //             , 'id' => "category-" . $parentCategory->getId()
  395.             //             , 'url' => $parentCategory->getDetailUrl(["document" => $this->document])
  396.             //             , 'label' => $parentCategory->getName()
  397.             //         ]);
  398.             //     }
  399.             // }
  400.             // $placeholder('addBreadcrumb')->append([
  401.             //     'parentId' => $category ? "category-" . $category->getParentId() : ""
  402.             //     , 'id' => "product-" . $product->getId()
  403.             //     , 'url' => $product->getDetailUrl(["document" => $this->document])
  404.             //     , 'label' => $product->getName()
  405.             // ]);
  406.             
  407.             // $headTitle = $container->get('pimcore.templating.view_helper.head_title');
  408.             // $headTitle($product->getName());
  409.             
  410.             
  411.             //$trackingManager = Factory::getInstance()->getTrackingManager();
  412.             //$trackingManager->trackProductView($product);
  413.             return $this->render('Shop/detail.html.twig',$params);
  414.         }
  415.     }
  418.     private function getSimilarProducts(DataObject\BrandExtension $product, \Pimcore\Model\DataObject\FilterDefinition $filterDefinition = null) {
  420.         if($filterDefinition) {
  422.             // Set Us as default country
  423.             $defaultCountry = DataObject\AvailabilityCountry::getByPath('/availability-countries/us');
  424.             if(isset($this->country)){
  425.                 $availableCountry = $this->country;
  426.             }else{
  427.                 $availableCountry = $defaultCountry;
  428.             }
  430.             $productList = Factory::getInstance()->getIndexService()->getProductListForCurrentTenant();;
  431.             $productList->setVariantMode(ProductListInterface::VARIANT_MODE_INCLUDE_PARENT_OBJECT);
  432.             $productList->addRelationCondition('CountryAvailabilityList', "dest IN (" . $availableCountry->getId() . ")");
  433.             $similarityFields = $filterDefinition->getSimilarityFields();
  434.             if($similarityFields) {
  435.                 $statement = $productList->buildSimularityOrderBy($filterDefinition->getSimilarityFields(), $product->getId());
  436.             }
  438.             if(!empty($statement)) {
  439.                 $productList->setLimit(4);
  440.                 $productList->setOrder("ASC");
  441.                 $productList->addCondition("o_virtualProductId != " . $product->internalGetBaseProduct()->getId(), "o_id");
  442.                 if($filterDefinition->getCrossSellingCategory()) {
  443.                     $productList->setCategory($filterDefinition->getCrossSellingCategory());
  444.                 }
  445.                 $productList->setOrderKey($statement);
  447.                 return $productList->load();
  448.             }
  449.         }
  450.         return array();
  452.     }
  456.     public function productCellAction(Request $request) {
  457.         if($request->get("type") == "object") {
  458.             $this->view->product = Pimcore\Model\Object\Product::getById($request->get("id"));
  459.             $this->view->col = $request->get("editmode") ? 12 : 3;
  460.             $this->view->view = $this->view;
  462.         }
  463.         $this->renderScript('/product/list/product.php');
  464.     }
  466.     public function searchAction(Request $request) {
  468.         // Set Us as default country
  469.         $defaultCountry = DataObject\AvailabilityCountry::getByPath('/availability-countries/us');
  470.         if(isset($this->country)){
  471.             $availableCountry = $this->country;
  472.         }else{
  473.             $availableCountry = $defaultCountry;
  474.             $this->view->country = $defaultCountry;
  475.         }
  476.         // $this->enableLayout();
  478.         $session = $this->get('session');
  479.         $authNamespace = $session->getBag('espirit');  
  480.         if ($authNamespace && $authNamespace->has('customeraccount')) {
  481.             $orders = new DataObject\OnlineShopOrder\Listing();
  482.             $orders->setCondition(" customer__id = '" . $authNamespace->get('customeraccount')->getId() . "'");
  483.             $orders->setOrderKey("orderdate",false);
  484.             $orders->setOrder("desc");
  485.             $orders->setLimit(1);
  486.             $orders->load();
  487.             if (count($orders) > 0) {
  488.                 foreach ($orders as $order) {break;}
  489.                 $lastlogin = $order->getOrderDate();
  490.                 $this->view->lastlogin = $lastlogin->getTimestamp();
  491.             } else {
  492.                 $lastlogin = Carbon::now();
  493.                 $this->view->lastlogin = $lastlogin->getTimestamp();
  494.             }
  495.         }
  496.         
  497.       //** $this->layout()->setLayout('product');
  499.         $searchstr = $request->get('q');
  500.         if (!$searchstr || empty($searchstr)) return;
  502.         $searcherList = new Data\Listing();
  503.         $db = \Pimcore\Db::get();
  504.         $condition[] = " `subtype` = 'BrandExtension'";
  505.         $condition[] = " `type` = 'object' ";
  506.         $condition[] = "( MATCH (`data`,`properties`) AGAINST (" . $db->quote($searchstr) . ") AND `data` LIKE " . $db->quote("%" . $availableCountry->getFullPath() . "%") . ")";
  507.         //$condition[] = "( `data` LIKE " . $db->quote("%" . $searchstr . "%") . " AND `data` LIKE " . $db->quote("%" . $availableCountry->getFullPath() . "%"). " )";
  508.         $searcherList->setLimit(100);
  510.         if (count($condition) > 0) {
  511.             $condition = implode(" AND ", $condition);
  512.             $searcherList->setCondition($condition);
  513.         }
  514.         
  515.         //$searcherList->setOrderKey( " MATCH (`data`,`properties`) AGAINST (" . $db->quote($searchstr) . ")",false);
  516.         //$searcherList->setOrder("desc");
  517.         $hits = $searcherList->load();
  519.         $list=array();
  520.         $idlist = "0";
  521.         $this->view->searchresults = $hits;
  522.     }
  523.     
  524.     /*
  525.     public function searchAction() {
  526.         $this->view->hideNav = true;
  528.         $productList = \OnlineShop\Framework\Factory::getInstance()->getIndexService()->getProductListForCurrentTenant();;
  529.         $productList->setVariantMode(\OnlineShop\Framework\IndexService\ProductList\IProductList::VARIANT_MODE_INCLUDE_PARENT_OBJECT);
  530.         if($this->getParam("term")) {
  531.             foreach(explode(" ", $this->getParam("term")) as $term) {
  532.                 $productList->addQueryCondition($term, "search");
  533.             }
  534.         }
  536.         $params = $this->getAllParams();
  537.         if(empty($filterDefinition)) {
  538.             $filterDefinition = \Pimcore\Config::getWebsiteConfig()->searchFilterdefinition;
  539.         }
  540.         $this->view->filterDefinitionObject = $filterDefinition;
  542.         // create and init filter service
  543.         $filterService = \OnlineShop\Framework\Factory::getInstance()->getFilterService($this->view);
  545.         \OnlineShop\Framework\FilterService\Helper::setupProductList($filterDefinition, $productList, $params, $this->view, $filterService, true);
  546.         $this->view->filterService = $filterService;
  547.         $this->view->products = $productList;
  549.         // init pagination
  550.         $paginator = Zend_Paginator::factory( $productList );
  551.         $paginator->setCurrentPageNumber( $this->getParam('page') );
  552.         $paginator->setItemCountPerPage( $filterDefinition->getPageLimit() );
  553.         $paginator->setPageRange(10);
  554.         $this->view->paginator = $paginator;
  556.         $this->enableLayout();
  558.         //breadcrumbs
  559.         $this->view->placeholder('addBreadcrumb')->append([
  560.             'parentId' => $this->document->getId()
  561.             , 'id' => "search-result"
  562.             , 'label' => $this->view->translate("shop.search-result", $this->view->escape($this->getParam("term")))
  563.         ]);
  565.         $this->view->headTitle( $this->view->translate("shop.search-result", $this->view->escape($this->getParam("term"))) );
  568.     }
  569.     */
  570. }