src/Controller/Products/categoryController.php line 146

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Products;
  5. use Pimcore\Controller\FrontendController;
  6. use Symfony\Component\HttpFoundation\Request;
  7. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Template;
  8. use Symfony\Component\Routing\Annotation\Route;
  9. use Pimcore\Localization\LocaleServiceInterface;
  10. use Pimcore\Model\DataObject\ClassDefinition\Service;
  11. use Pimcore\Model\DataObject\Category;
  12. use Pimcore\Model\DataObject\Products;
  13. use Pimcore\Model\DataObject\Brands;
  14. use App\Model\Product\AbstractProduct;
  15. use Pimcore\Bundle\EcommerceFrameworkBundle\Factory;
  16. use Pimcore\Model\DataObject\Userloyaltyprogram;
  17. use Pimcore\Model\DataObject\Slider;
  18. use Pimcore\Model\DataObject\Recipe;
  19. use Symfony\Contracts\Translation\TranslatorInterface;
  20. use Pimcore\Model\DataObject\FilterDefinition;
  21. use Pimcore\Bundle\EcommerceFrameworkBundle\IndexService\ProductList\ProductListInterface;
  22. use Pimcore\Config;
  23. use Pimcore\Bundle\EcommerceFrameworkBundle\FilterService\ListHelper;
  24. use Knp\Component\Pager\PaginatorInterface;
  26. class categoryController extends FrontendController
  27. {
  28.     /**
  29.         * @Route("/{locale}/products/{url?}", name="products")
  30.     */
  31.     public function categoryProductAction(Request $request , TranslatorInterface $translator,Factory $ecommerceFactory,ListHelper $listHelper, PaginatorInterface $paginator){
  32.                 
  33.         $get_param = $request->query->all();
  34.         $params = array_merge($request->query->all(), $request->attributes->all());
  35.        
  36.         $category_ids   = isset($params["categories"])?$params["categories"]:"";
  37.         $brand_ids      = isset($params["brands"])?$params["brands"]:"";
  38.         $subCategoryIds      = isset($params["subCategory"])?$params["subCategory"]:"";
  39.         $query          = isset($params["query"])?$params["query"]:"";
  40.         $cuisine_id     = isset($params["cuisine_id"])?$params["cuisine_id"]:"";
  41.         $meal_type   = isset($params["meal_type"])?$params["meal_type"]:"";
  42.         $childList = array();
  43.         $brand = null;
  44.         $url = $request->get('url');
  45.         if(!empty($request->get('url')) && empty($get_param)){
  46.             $brand = (string)$this->getBrandId($request->get('url'));
  47.         }
  48.         $catId = null;
  49.         if(!empty($request->get('url')) && empty($get_param)){
  50.             $catId = (string)$this->getCategoryId($request->get('url'));
  51.         }
  52.         $indexService = $ecommerceFactory->getIndexService();
  53.         $productListing = $indexService->getProductListForCurrentTenant();  
  54.         $productListing->addCondition("o_parentId != 74");    
  55.         if($query){
  56.             $productListing->addCondition("name LIKE '%{$query}%'"); 
  57.         }        
  58.         if(!empty($request->get('url')) && !empty($brand)){
  59.             $brand_ids = explode(",",$brand);
  60.             $params["brands"] = $brand_ids;
  61.         }
  62.         if(!empty($request->get('url')) && !empty($catId)){      
  63.             $category_ids = explode(",",$catId);
  64.             $params["categories"] = $category_ids;
  65.         }
  66.         $productListing->setOrderKey('name');
  67.         $productListing->setOrder('asc');
  68.         $page = $request->get('page');
  69.         if($page){
  70.             $page = $page+1;
  71.         }else{
  72.             $page = 1;
  73.         }          
  76.         if ($request->get('filterdefinition') instanceof FilterDefinition) {
  77.             $filterDefinition = $request->get('filterdefinition');
  78.         }
  80.         if (empty($filterDefinition)) {
  81.             $filterDefinition = Config::getWebsiteConfig()->get('fallbackFilterdefinition');
  82.         }        
  84.         $filterService = $ecommerceFactory->getFilterService();
  85. (new \Pimcore\Bundle\EcommerceFrameworkBundle\FilterService\ListHelper)->setupProductList($filterDefinition, $productListing, $params, $filterService, true, true);
  86.        
  87.         $paginator = $paginator->paginate(
  88.             $productListing,
  89.             $page,
  90.             24
  91.         ); 
  92.         
  93.        // p_r();
  94.                  
  95.         foreach ($paginator as $product) {            
  96.             if($product->getChildren() ){
  97.                 $parent_id = $product->getParentId();
  98.                 if($parent_id > 74){
  99.                     $childList[] = $product->getChildren();
  100.                 }
  101.             }else{
  102.                 $childList[] = $product;
  103.             }            
  104.         }
  105.         
  106.         $categories = $this->getCategories();
  107.         $brands = $this->getBrands();
  109.         // filters
  110.         // dd($brand_ids);
  111.         $filters = array(
  112.             'category_ids'      => $category_ids,
  113.             'brand_ids'         => $brand_ids,
  114.             'subCategory'         => $subCategoryIds,
  115.             'query'             => $query,
  116.             'cuisine_id'        => $cuisine_id,
  117.             'meal_type'         => $meal_type,            
  118.         );       
  120.         $currentFilter = [            
  121.             'categoryIds' => $category_ids,
  122.             "categories" => $category_ids,
  123.             'subCategory'         => $subCategoryIds,
  124.             'brands' => $brand_ids,
  125.             'meal_type' => $meal_type, 
  126.         ];
  128.         // Category Sliders
  129.         $category_slider = new Slider\Listing();
  130.         $category_slider->setCondition("o_id = 205");
  131.         $category_slider->load();
  133.         if(empty($category_slider->getdata()[0]->getsliders())){
  134.             $category_slider = array();
  135.         }else{
  136.             $category_slider = $category_slider->getdata()[0]->getsliders();
  137.         }
  139.         if(!empty($request->get('url'))){
  140.             $getCategoryData    = $this->getCategoryDescription($request->get('url'));
  141.             $getBrandData       = $this->getBrandDescription($request->get('url'));
  142.             if(!empty($getCategoryData)){
  143.                 $products_head = array(
  144.                     'id'         => $getCategoryData->getId(),
  145.                     'name'         => $getCategoryData->getName(),
  146.                     'description'  => $getCategoryData->getDescription(),
  147.                     'Detail_desc'  => $getCategoryData->getDetail_desc(),
  148.                     'breadcrumb'   => $getCategoryData->getName(),
  149.                     'slides'       => $getCategoryData->getCategory_slides(),
  150.                     'brand_logo'   => '',
  151.                     'meta_title'       => $getCategoryData->getMeta_title(),
  152.                     'meta_description'   => $getCategoryData->getMeta_description(),
  153.                 );
  154.             }else if(!empty($getBrandData)){
  155.                 $products_head = array(
  156.                     'id'           => $getBrandData->getId(),
  157.                     'name'         => $getBrandData->getName(),
  158.                     'description'  => $getBrandData->getDescription(),
  159.                     'breadcrumb'   => $getBrandData->getName(),
  160.                     'slides'       => $getBrandData->getCategory_slides(),
  161.                     'brand_logo'   => $getBrandData->getImage(),
  162.                     'meta_title'       => $getBrandData->getMeta_title(),
  163.                     'meta_description'   => $getBrandData->getMeta_description(),
  164.                 );
  165.             }
  166.             else{
  167.                 $products_head = array();
  168.             }
  169.         }else{
  170.             $products_head = array();
  171.         }
  174.         // Category Mid Banner
  175.         $mid_banner = new Slider\Listing();
  176.         $mid_banner->setCondition("o_id = 206");
  177.         $mid_banner->load();
  179.         if(empty($mid_banner->getdata()[0]->getsliders())){
  180.             $mid_banner = array();
  181.         }else{
  182.             $mid_banner = $mid_banner->getdata()[0]->getsliders();
  183.         }   
  185.         // dd($childList);
  186.         if ($request->isXmlHttpRequest()) {
  187.             return $this->loadMoreProduct($childList, $request ,$translator);
  188.         }
  191.         // Featured Recipes
  192.         $featured_recipes = new Recipe\Listing();
  193.         $featured_recipes->setCondition('featured IN (?)', '1');
  194.         $featured_recipes->setLimit('10');
  195.         $featured_recipes->load();
  196.         //dd($childList);
  197.         $ObjectIds = [];
  198.         foreach($childList as $ChildList){
  199.             $ObjectIds[] =  $ChildList->getId();
  200.         }
  201.        // dd(count($ObjectIds));
  202.        // echo $ObjectIds;
  203.         $uid = $this->get('session')->get('loginUID');
  204.         //$rid = $recipedata->getId();
  205.         $Liked = new Userloyaltyprogram\Listing();
  206.        //for($i=0; $i<count($ObjectIds); $i++){
  207.         $Liked->setCondition("op_name = ? and u_id = ? and obj_mod_name = ? and obj_data__id IN (?)",['Like',$uid,'Product',$ObjectIds]);
  208.     
  209.        
  210.       //}
  211.      
  212.       $Liked->load();
  213.       $LikedId = [];
  214.       foreach($Liked as $liked){
  215.         $LikedId[]=$liked->getObj_id();
  217.       }  
  218.      
  219.         return $this->render('Products/category.html.twig', [
  220.                 'products'          => $childList,
  221.                 'categories'        => $categories,
  222.                 'brands'            => $brands,
  223.                 'filters'           => $filters,
  224.                 'category_slider'   => $category_slider,
  225.                 'featured_recipes'  => $featured_recipes,
  226.                 'mid_banner'        => $mid_banner,
  227.                 'products_head'     => $products_head,
  228.                 'Liked'     => $Liked,
  229.                 'LikedId'     => $LikedId,
  230.                 'filterService'=> $filterService,
  231.                 'filterDefinition'=> $filterDefinition,            
  232.                 'productListing'=> $productListing,
  233.                 'currentFilter' => $currentFilter
  234.             ]);
  236.     }
  238.     public function getCategories($category_id = 0){
  239.         $categories = new Category\Listing();
  240.         $categories->load();
  241.         return $categories;
  242.     }
  244.     public function getCategoryId($url = ''){
  245.         $categories = new Category\Listing();
  246.         $categories->setCondition("url IN (?)", [[$url]]);
  247.         $categories->load();
  248.         foreach($categories as $category){
  249.             $category_id = $category->getId();
  250.             break;
  251.         }
  252.         if(isset($category_id)){
  253.             return $category_id;
  254.         }
  255.         return '';
  256.     }
  258.     public function getBrands($brand_id = 0){
  259.         $brands = new Brands\Listing();
  260.         $brands->load();
  261.         return $brands;
  262.     }
  263.     
  264.     public function getBrandId($url = ''){
  265.         $brands = new Brands\Listing();
  266.         $brands->setCondition("url IN (?)", [[$url]]);
  267.         $brands->load();
  268.         foreach($brands as $brand){
  269.             $brand_id = $brand->getId();
  270.             break;
  271.         }
  272.         if(isset($brand_id)){
  273.             return $brand_id;
  274.         }
  275.         return '';
  276.     }
  280.     // Get Category Description
  281.     public function getCategoryDescription($url = ''){
  282.         $categories = new Category\Listing();
  283.         $categories->setCondition("url IN (?)", [[$url]]);
  284.         $categories->load();
  285.         foreach($categories as $category_data){
  286.             break;
  287.         }
  288.         if(isset($category_data)){
  289.             return $category_data;
  290.         }
  291.         return '';
  292.     }
  295.     // Get Brands
  296.     public function getBrandDescription($url = ''){
  297.         $brands = new Brands\Listing();
  298.         $brands->setCondition("url IN (?)", [[$url]]);
  299.         $brands->load();
  300.         foreach($brands as $brand){
  301.             break;
  302.         }
  303.         if(isset($brand)){
  304.             return $brand;
  305.         }
  306.         return '';
  307.     }
  308.     
  309.     /**
  310.      * @Route("products/{}/loadmore", name="loadmore")
  311.     */
  312.     public function loadMoreProduct($childList, $request ,$translator){
  313.         $more_product = '';
  315.         if(!empty($childList)){
  316.             $total_products = sizeof($childList);
  317.         }else{
  318.             $total_products = '';
  319.         }
  321.             foreach($childList as $product){
  322.                 $uid = $this->get('session')->get('loginUID');
  323.                 $LikedId = [];
  324.                 if($uid){
  325.                     $Liked = new Userloyaltyprogram\Listing();
  326.                     $Liked->setCondition("op_name = ? and u_id = ? and obj_mod_name = ? and obj_id IN (?)",['Like',$uid,'Product',$product->getId()]);         
  327.                     $Liked->load();
  328.                     foreach($Liked as $liked){
  329.                         $LikedId[]=$liked->getObj_id();        
  330.                     }
  331.                     
  332.                 }       
  333.                 if($product->getBrands()->getId()){
  334.                     if($product->getBrands()->getId() == 263 ){
  335.                         $class = "slide-img-bg-brown";
  336.                     }elseif($product->getBrands()->getId() == 262){
  337.                         $class = "slide-img-bg-blue";
  338.                     }elseif($product->getBrands()->getId() == 413){
  339.                         $class = "slide-img-bg-purple";
  340.                     }elseif($product->getBrands()->getId() == 260){
  341.                         $class = "slide-img-bg-green";
  342.                     }else{
  343.                         $class = "slide-img-bg-green";
  344.                     }
  345.                 }
  346.                 $more_product .= '<div class="col-12 col-md-6 col-lg-4 product-result">';
  347.                 $more_product .=  $this->renderView('/includes/product-card.html.twig', [
  348.                     'featured_product' => $product,
  349.                     'class' => $class,
  350.                     'LikedId' => $LikedId 
  351.                 ]);
  352.                 $more_product .= '</div>';
  353.             }
  355.             return $this->json([
  356.                 'success' => $more_product,
  357.                 'total_products' => $total_products
  358.             ]);        
  359.     }
  360.     /**
  361.   * @Route("/{locale}/brand", name="brand")
  362.  */
  364.     public function redirectBrandAction(Request $request)
  365.     {
  366.         $weblink = $request->get('locale');
  367.         return $this->redirect('/'.$weblink.'/products/',301);
  368.     }
  370.      /**
  371.   * @Route("/{locale}/product", name="product")
  372.  */
  374. public function redirectProductDetailAction(Request $request)
  375. {
  376.     $weblink = $request->get('locale');
  377.     return $this->redirect('/'.$weblink.'/products/',301);
  378. }
  380. //     /**
  381. //   * @Route("/{locale}/products", name="productslash")
  382. //  */
  384. // public function redirectProductslashRemove(Request $request)
  385. // {
  386. //     $weblink = $request->get('locale');
  387. //     return $this->json(['name'=>'name']);
  388. // }
  389. /**
  390.         * @Route("/{locale}/products2/{url?}", name="products2")
  391.     */
  392.     public function categoryProduct2Action(Request $request , TranslatorInterface $translator){
  393.         
  396.         $products = new Products\Listing();
  397.         $products->load();        
  398.         $childList = array();
  400.         foreach ($products as $product) {            
  401.             if($product->getChildren()){
  402.                 $parent_id = $product->getParentId();
  403.                 if($parent_id > 74){
  404.                     $childList[] = $product->getChildren();
  405.                 }
  406.             }else{
  407.                 $childList[] = $product;
  408.             }            
  409.         }
  410.         
  411.         $categories = $this->getCategories();
  412.         $brands = $this->getBrands();
  414.        
  416.         // Category Sliders
  417.         $category_slider = new Slider\Listing();
  418.         $category_slider->setCondition("o_id = 205");
  419.         $category_slider->load();
  421.         if(empty($category_slider->getdata()[0]->getsliders())){
  422.             $category_slider = array();
  423.         }else{
  424.             $category_slider = $category_slider->getdata()[0]->getsliders();
  425.         }
  427.         if(!empty($request->get('url'))){
  428.             $getCategoryData    = $this->getCategoryDescription($request->get('url'));
  429.             $getBrandData       = $this->getBrandDescription($request->get('url'));
  430.             if(!empty($getCategoryData)){
  431.                 $products_head = array(
  432.                     'id'         => $getCategoryData->getId(),
  433.                     'name'         => $getCategoryData->getName(),
  434.                     'description'  => $getCategoryData->getDescription(),
  435.                     'Detail_desc'  => $getCategoryData->getDetail_desc(),
  436.                     'breadcrumb'   => $getCategoryData->getName(),
  437.                     'slides'       => $getCategoryData->getCategory_slides(),
  438.                     'brand_logo'   => '',
  439.                     'meta_title'       => $getCategoryData->getMeta_title(),
  440.                     'meta_description'   => $getCategoryData->getMeta_description(),
  441.                 );
  442.             }else if(!empty($getBrandData)){
  443.                 $products_head = array(
  444.                     'id'           => $getBrandData->getId(),
  445.                     'name'         => $getBrandData->getName(),
  446.                     'description'  => $getBrandData->getDescription(),
  447.                     'breadcrumb'   => $getBrandData->getName(),
  448.                     'slides'       => $getBrandData->getCategory_slides(),
  449.                     'brand_logo'   => $getBrandData->getImage(),
  450.                     'meta_title'       => $getBrandData->getMeta_title(),
  451.                     'meta_description'   => $getBrandData->getMeta_description(),
  452.                 );
  453.             }
  454.             else{
  455.                 $products_head = array();
  456.             }
  457.         }else{
  458.             $products_head = array();
  459.         }
  462.         // Category Mid Banner
  463.         $mid_banner = new Slider\Listing();
  464.         $mid_banner->setCondition("o_id = 206");
  465.         $mid_banner->load();
  467.         if(empty($mid_banner->getdata()[0]->getsliders())){
  468.             $mid_banner = array();
  469.         }else{
  470.             $mid_banner = $mid_banner->getdata()[0]->getsliders();
  471.         }   
  474.         // Featured Recipes
  475.         $featured_recipes = new Recipe\Listing();
  476.         $featured_recipes->setCondition('featured IN (?)', '1');
  477.         $featured_recipes->setLimit('10');
  478.         $featured_recipes->load();
  479.         //dd($childList);
  480.        
  481.        // dd(count($ObjectIds));
  482.        // echo $ObjectIds;
  483.         $uid = $this->get('session')->get('loginUID');
  484.         //$rid = $recipedata->getId();
  485.         $Liked = new Userloyaltyprogram\Listing();
  486.        //for($i=0; $i<count($ObjectIds); $i++){
  487.         // $Liked->setCondition("op_name = ? and u_id = ? and obj_mod_name = ? and obj_data__id IN (?)",['Like',$uid,'Product',$ObjectIds]);
  488.     
  489.        
  490.       //}
  491.      
  492.       $Liked->load();
  493.       $LikedId = [];
  494.       foreach($Liked as $liked){
  495.         $LikedId[]=$liked->getObj_id();
  497.       }
  498.       //dd($LikedId);
  500.        
  502.          
  503.         return $this->render('Products/category2.html.twig', [
  504.                 'products'          => $childList,
  505.                 'categories'        => $categories,
  506.                 'brands'            => $brands,
  507.                 'category_slider'   => $category_slider,
  508.                 'featured_recipes'  => $featured_recipes,
  509.                 'mid_banner'        => $mid_banner,
  510.                 'products_head'     => $products_head,
  511.                 'Liked'     => $Liked,
  512.                 'LikedId'     => $LikedId,
  513.             ]);
  515.     }
  516.  
  518.    
  519.   
  520. }
  522. ?>