src/Controller/PortfolioguideController.php line 33

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  6. /**
  7.  * The core controller for Portfolioguide Portal
  8.  * 
  9.  * Login session criteria to be declared
  10.  *
  11.  * PHP version 5.3
  12.  *
  13.  * @category  Portfolio_Guide
  14.  * @package   PortfolioGuide
  15.  * @author    TCS Beam Suntory
  16.  * @copyright TCS Beam Suntory
  17.  * @license   
  18.  * @link
  19.  */
  21. /**
  22.  * The core controller for Portfolioguide Portal
  23.  */
  24. use Pimcore\Controller\FrontendController;
  25. use Pimcore\Model\DataObject;
  26. use Pimcore\Mail;
  27. use Pimcore\Model\Search\Backend\Data;
  28. use Symfony\Component\HttpFoundation\Request;
  29. use Symfony\Component\HttpKernel\Event\FilterControllerEvent;
  30. use Symfony\Component\Intl\Intl;
  32. // class PortfolioguideController extends \Website\Controller\Action
  33. class PortfolioguideController extends Action
  34. {
  36.     public $countryId;
  37.     public $countryObj;
  38.     /**
  39.      * Init function in which the cookie based authentication is written
  40.      * Checks authentication based on URL parameter passed from Connect Library
  41.      * Also sets the cookie variable for displaying/hiding Downloads section in Detail page
  42.      */
  43.     public function onKernelController(FilterControllerEvent $event)
  44.     {
  45.         parent::onKernelController($event);
  46.         
  47.         if ($event->getRequest()->get("country")) {
  48.             
  49.             $country = strtolower($event->getRequest()->get("country"));
  51.             $countryObj = DataObject\AvailabilityCountry::getByPath("/availability-countries/" . $country);
  52.             if ($countryObj) {
  53.                 if ($countryObj->getportfolioGuideEnable()) {
  54.                     $this->countryId = $countryObj->getId();
  55.                     $this->view->countryId = $countryObj->getId();
  56.                     $this->country = $country;
  57.                     $this->view->country = $country;
  58.                     $this->countryObj = $countryObj;
  59.                     $this->view->countryObj = $countryObj;
  60.                 }
  61.             }
  63.         }
  64.         
  65.         if (!$this->country || !$this->countryId) {
  66.             $this->countryId = 32853;
  67.             $this->view->countryId = 32853;
  68.             $this->country = "us";
  69.             $this->view->country = "us";
  70.             $this->countryObj = DataObject\AvailabilityCountry::getById(32853);
  71.             $this->view->countryObj = DataObject\AvailabilityCountry::getById(32853);
  72.         }
  73.         
  74.         //get available countries
  75.         $countriesView = [];
  76.         $x = 0;
  77.         $countries = new DataObject\AvailabilityCountry\Listing();
  78.         $countries->setCondition("portfolioGuideEnable = 1");
  79.         
  80.         foreach ($countries as $enabledCountry) {
  81.             if ($enabledCountry->getAltCode()) {
  82.                 $countriesView[$x]["Value"] = $enabledCountry->getAltCode();
  83.                 $countriesView[$x]["Name"] = $enabledCountry->getAltName();
  84.             } else {
  85.                 $countriesView[$x]["Value"] = $enabledCountry->getCountry();
  86.                 $countriesView[$x]["Name"] = Intl::getRegionBundle()->getCountryName($enabledCountry->getName());
  87.             }
  88.             if ($this->country == $enabledCountry->getKey()) {
  89.                 $countriesView[$x]["Selected"] = "Selected";
  90.             }
  91.             $countriesView[$x]["Icon"] = $enabledCountry->getFlagIconImage();
  92.             $x++;        
  93.         }
  94.         $this->view->countries = $countriesView;
  96.         
  97.         $localesView = [];
  98.         $x = 0;
  99.         $locales = DataObject\EnabledLanguages::getByPath("/enabled-languages/enabled-languages");
  100.         foreach($locales->getEnabledLanguages() as $item) {
  101.             if ($item['portfolioGuideEnable']->getData()) {
  102.                 $localesView[$x]["Value"] = $item['EnabledLanguage']->getData();
  103.                 $localesView[$x]["Name"] = $item['LanguageDisplay']->getData();
  104.                 $localesView[$x]["Icon"] = $item['FlagIconImage']->getData();
  105.                 if ($this->locale == $item['EnabledLanguage']->getData()) {
  106.                     $localesView[$x]["Selected"] = "Selected";
  107.                 }
  108.                 $x++;    
  109.             }
  110.         }
  111.         
  112.         $this->view->localesView = $localesView;
  113.         
  114.         //need to change this to SSO        
  115.         if(!empty($_GET['v'])){ // Checks whether a url parameter is passed for 'Downloads' section display in Detail page
  116.                 //$paramV = $_GET['v'];
  117.                 setcookie("paramV", "f", time()+2592000); // Sets cookie for 1 month as per client requirement
  118.                 $this->view->paramV = "f";
  119.         }
  120.         $this->view->paramV = $_COOKIE['paramV'];    
  121.         
  122.     }
  123.     
  124.     /**
  125.      * Get the list of published portfolioguides 
  126.      * 
  127.      * @return html products landing page
  128.      */
  129.     public function portfolioguideLandingAction(Request $request) 
  130.     {  
  131.         ini_set('memory_limit', '512M'); 
  132.         $order_by = "";        
  133.         $condition = "";
  134.         $limit = "";
  135.         $this->view->current_alcohol_type = "";
  136.         //$this->layout()->setLayout('portfolioguideportal');
  137.         $this->view->CssClass = "sub-category-page";
  138.         $headTitleHelper = \Pimcore::getContainer()->get('pimcore.templating.view_helper.head_title');
  139.         $headTitleHelper("Portfolio Guide");
  141.         $alcohol_type_obj = new DataObject\CategoryAlcoholType();       
  142.         $brand_obj = new DataObject\Brand();
  143.         $brand_extension_obj = new DataObject\BrandExtension();
  144.         $portfolio_guide_obj = new DataObject\PortfolioGuide();
  145.         $portfolio_brand = DataObject\CategoryAlcoholType::getList();
  146.         
  147.         $locale = $this->locale;
  149.         $type_id = ($_REQUEST['type']) ? $_REQUEST['type'] : "";
  150.         $brand_id = ($_REQUEST['Brand']) ? $_REQUEST['Brand'] : "";
  151.         $search = ($_REQUEST['search']) ? $_REQUEST['search'] : "";
  152.         $countryAvailability = ($this->countryId) ? $this->countryId : "";
  153.         $count_per_page = ($_REQUEST['counter'])? $_REQUEST['counter']:15;        
  154.         
  155.         //the below line gets all Portfolio Guide objects + all the related data, becomes 160MB array and kills php, let's use SQL
  156.         //$portfolio_guides_list = Object\PortfolioGuide::getList();        
  157.         $db = \Pimcore\Db::get();
  158.         $result = $db->fetchAll("SELECT COUNT(`oo_id`) as PFG_Number FROM `object_localized_" . $portfolio_guide_obj->getClassId() . "_" . $locale . "` WHERE `o_published` = 1");
  159.         $portfolio_guides_list = $result[0]['PFG_Number'];
  160.             
  161.         $count_per_page = ($count_per_page == "all")? $portfolio_guides_list:$count_per_page;
  162.         $sorting =  ($_REQUEST['sorting'])? $_REQUEST['sorting']:1;  
  163.         $childs = $this->view->types = \App\Model\DataObject\PortfolioGuide::getAlcoholChilds($type_id);   
  164.         $child_array = array($type_id);
  165.         foreach($childs as $child)
  166.         {
  167.             $child_array[] = $child->getId();
  168.         }        
  169.         if($type_id)
  170.         {
  171.             $current_alcohol_type = \App\Model\DataObject\PortfolioGuide::getAlcoholTypeName($type_id);
  172.             $this->view->current_alcohol_type = $current_alcohol_type;
  173.         }
  174.         if ($type_id) {
  175.             $condition .= " AND REPLACE(object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ".AlcoholType,',','') IN (" . implode(', ', $child_array) . ")";
  176.         }        
  178.         if ($brand_id) {
  179.             $condition .= " AND object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ".Brand LIKE '%" . $brand_id . "%'";
  180.         }
  182.         if ($search) {
  183.             $condition .= " AND object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ".BrandExtensionName LIKE '%" . trim($search) . "%'";
  184.         }
  185.         
  186.         if ($countryAvailability) {
  187.             $condition .= " AND object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ".CountryAvailabilityList LIKE '%" . trim($countryAvailability) . "%'";
  188.         }
  189.         
  190.         if ($sorting) {
  191.             if ($sorting == 2) {
  192.                 $order_by = " ORDER BY object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ".BrandExtensionName ASC";
  193.             } else if ($sorting == 3) {
  194.                 $order_by = " ORDER BY object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ".BrandExtensionName DESC";
  195.             } else if ($sorting == 4) {
  196.                 $order_by = " ORDER BY object_localized_" . $portfolio_guide_obj->getClassId() . "_" . $locale . ".o_modificationDate DESC";
  197.             } else {
  198.                 $order_by = " ORDER BY BrandName ASC, Ordering ASC";
  199.             }
  200.         }
  201.         $db = \Pimcore\Db::get();
  202.                        
  203.         $start = ($_REQUEST["page"])?($_REQUEST["page"]-1)*$count_per_page:0;
  204.         $start = ($start < $portfolio_guides_list)? $start:0;
  205.         $limit = " LIMIT ".$start.",".$count_per_page;
  206.         
  207.         $sql = "SELECT "
  208.                 . "object_localized_" . $portfolio_guide_obj->getClassId() . "_" . $locale . ".oo_id AS guide_id, "
  209.                 . "object_localized_" . $portfolio_guide_obj->getClassId() . "_" . $locale . ".Order AS Ordering, "
  210.                 . "object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ".o_creationDate AS creation_date,"
  211.                 . "object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ".o_modificationDate AS modification_date, "
  212.                 . "object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ".oo_id AS brand_extension_id, "
  213.                 . "object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ".BrandExtensionNameTrademark, "
  214.                 . "object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ".BrandExtensionName, "
  215.                 . "object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ".FullDescriptionHeadline as brandextDescriptionHeadline, "
  216.                 . "object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ".CountryAvailabilityList, "
  217.                 . "object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ".P_BrandName as BrandName, "
  218.                 . "object_localized_" . $alcohol_type_obj->getClassId() . "_" . $locale . ".*"
  219.                 . "FROM object_localized_" . $portfolio_guide_obj->getClassId() . "_" . $locale . ""
  220.                 . " LEFT JOIN object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ""
  221.                 . " ON REPLACE(SUBSTRING_INDEX(object_localized_" . $portfolio_guide_obj->getClassId() . "_" . $locale . ".BrandExtension, ',', 2),',','') = object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ".oo_id"
  222.                 . " LEFT JOIN object_localized_" . $brand_obj->getClassId() . "_" . $locale . ""
  223.                 . " ON REPLACE(object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ".Brand,',','') = object_localized_" . $brand_obj->getClassId() . "_" . $locale . ".oo_id"
  224.                 . " LEFT JOIN object_localized_" . $alcohol_type_obj->getClassId() . "_" . $locale . ""
  225.                 . " ON REPLACE(object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ".AlcoholType,',','') = object_localized_" . $alcohol_type_obj->getClassId() . "_" . $locale . ".oo_id"
  226.                 . " WHERE object_localized_" . $portfolio_guide_obj->getClassId() . "_" . $locale . ".o_published=1" . $condition;        
  227.         
  228.         $portfolio_guide_all_list = $db->fetchAll($sql);
  229.         $this->view->total_items = ceil((count($portfolio_guide_all_list))/$count_per_page);
  230.         $portfolio_guide = $db->fetchAll($sql.$order_by.$limit);
  231.         $this->view->current_page = ($_REQUEST["page"])?($_REQUEST["page"]):1;       
  232.         $display_items_id = array();                
  233.         $all_portfolio_type_count = \App\Model\DataObject\PortfolioGuide::getAlcoholTypeCount($brand_id, $portfolio_guide_all_list);
  234.         
  235.         foreach($this->view->types as $type)
  236.         {
  237.             $sub_child_count_alcohol[$type->getId()] = 0;
  238.             $items = new DataObject\CategoryAlcoholType\Listing();                
  239.             $items ->setCondition("o_parentId = ?", array($type->getId()));  
  240.             if($all_portfolio_type_count[$type->getId()])
  241.             {
  242.                 $display_items_id[] = $type->getId();                  
  243.             }            
  244.             else
  245.             {
  246.                 foreach($items as $item)
  247.                 {
  248.                     if($all_portfolio_type_count[$item->getId()])
  249.                     {
  250.                         $display_items_id[] = $type->getId();                          
  251.                     }
  252.                 }
  253.             }            
  254.         }  
  255.                         
  256.         DataObject\AbstractObject::setHideUnpublished(false);
  257.         $this->view->brand = DataObject\Brand::getList();
  258.         DataObject\AbstractObject::setHideUnpublished(true);
  259.         $this->view->portfolio_guide = $portfolio_guide;        
  260.         $this->view->portfolio_brand_count = \App\Model\DataObject\PortfolioGuide::getBrandCount($type_id, $portfolio_guide_all_list);
  261.         $this->view->portfolio_type_count = $all_portfolio_type_count;
  262.         $this->view->initial_display_alcohol_type = $display_items_id;
  263.         
  264.         //$this->enableLayout();  
  265.         
  266.     }
  268.     /**
  269.      *  Function used to display the detail page of portfolioguide
  270.      * 
  271.      * @return Portfolioguide detail page html
  272.      */
  273.     public function portfolioguideDetailPageAction(Request $request) 
  274.     {
  275.         
  276.         $brand = $brand_extension = $portfolioGuideName = $sizes = '';
  277.         $pgMultiFlag = false;
  278.         //$this->layout()->setLayout('portfolioguideportal');
  279.         $this->view->CssClass = "detail-page";  
  280.         $headTitleHelper = \Pimcore::getContainer()->get('pimcore.templating.view_helper.head_title');
  281.         $headTitleHelper("Portfolio Guide");
  282.                 
  283.         $locale = $this->locale;
  284.         
  285.         $paramId = $request->get("portfolioid");
  286.         $pgObject = DataObject\PortfolioGuide::getById($paramId);    
  287.         
  288.         $this->view->brand_info_connect = $pgObject->getCONNECTBrandPageURL($locale);
  289.         $this->view->recipe = $pgObject->getRecipesPageURL($locale);
  290.         $this->view->related1 = $pgObject->getAddlRelatedLinkURL1($locale);
  291.         $this->view->related2 = $pgObject->getAddlRelatedLinkURL2($locale);
  292.         $this->view->related3 = $pgObject->getAddlRelatedLinkURL3($locale); 
  293.         
  294.         //Show Ordering Specs for U.S. or the rest of the world (Global)
  295.         if ($this->countryId == 32853) {        
  296.             $this->view->orderingspecs = $pgObject->getOrderingSpecsDownloadURL($locale);
  297.         } else {
  298.             $this->view->orderingspecs = $pgObject->getGlobalOrderingSpecsDownloadURL($locale);
  299.         }
  300.         //$this->view->otherBrandExtObj = $pgObject->getOtherBrandExtensions($locale);
  301.         $this->view->footerNotes = $pgObject->getFootnotesLegalDisclaimer($locale);
  302.         
  303.         DataObject\AbstractObject::setHideUnpublished(false);
  304.         $brand_extension = $pgObject->getBrandExtension(); 
  306.         $pgMultiBottleImage = $pgObject->getMultiBottlesPhoto($locale);
  307.         $portfolioGuideName = $pgObject->getAltTitle($locale);
  308.         
  309.         if ($brand_extension) {
  310.             
  311.             if (count($brand_extension) > 1)
  312.             {
  313.                 $pgMultiFlag = true;
  314.                 $this->view->brandExtList = $brand_extension;
  315.             }              
  316.             
  317.             $brandExtObj = $brand_extension[0]->getObject();
  318.             $brand = $brandExtObj->getBrand();
  319.             DataObject\AbstractObject::setHideUnpublished(true);
  320.             
  321.             if ($brand) {
  322.                 $brand = $brand[0]->getObject();
  323.                 $this->view->website = $brand->getBrandWebsiteURL();
  324.                 $this->view->brandNameTrademark = $brand->getBrandNameTrademark();
  325.                 $brandExtParent = $brand;
  326.                 $brandPhotoAsset = $brandExtParent->getBrandMarkImage();
  327.                 $brandPhoto = $brandPhotoAsset->getPath().$brandPhotoAsset->getFilename();
  328.                 //$brandPhotoName = $brandPhoto->getFilename();
  329.                 $brandPhotoName = $brandPhotoAsset->getFilename();
  330.             } else {
  331.                 $this->view->website = "";
  332.                 $this->view->brandExtParent = "";
  333.             }
  334.             $photo = $brandExtObj->getBottlePhoto();
  335.             $bottleImage = $photo->getPath().$photo->getFilename();
  336.             $bottleImageName = $photo->getFilename();
  337.             if($pgMultiBottleImage)
  338.             {
  339.                 $bottleImageHtml = $pgMultiBottleImage->getThumbnail('PGDetail_HTML')->getHtml(['class' => 'product-image']);
  340.             } 
  341.             else if ($pgMultiFlag)
  342.             {
  343.                 if ($brandPhotoAsset)
  344.                 {
  345.                     $bottleImageHtml = $brandPhotoAsset->getThumbnail('PGDetail_HTML')->getHtml(['class' => 'product-image']);
  346.                 }
  347.             }
  348.             else
  349.             {
  350.                 $bottleImageHtml = $brandExtObj->getFirstImage('PGDetail_HTML', $this->countryObj)->getHtml(['class' => 'product-image']);
  351.             }
  352.                                     
  353.             $alcoholTypeCategObj = $brandExtObj->getAlcoholType();
  354.             if($alcoholTypeCategObj){
  355.                 $alcoholTypeCateg = $alcoholTypeCategObj[0]->getObject();
  356.                 $alcoholTypeCateg = $alcoholTypeCateg->getAlcoholType();
  357.             }
  358.             $this->view->proof = $brandExtObj->getProof();
  359.             $this->view->abv = $brandExtObj->getABV();
  360.             $this->view->aging = $brandExtObj->getAging($locale);  
  362.             DataObject\AbstractObject::setHideUnpublished(false);
  363.             $variants = $brandExtObj->getSizeVariants($this->countryObj);
  364.             DataObject\AbstractObject::setHideUnpublished(true);
  365.             if ($variants) {
  366.                 foreach ($variants as $variants){
  367.                     if($variants->getBottleSize()!=''){
  368.                         //bottle sizes
  369.                         $sizeValue = str_replace(" ml", "", $variants->getBottleSize());
  370.                         $sizeValue = (int)$sizeValue;
  371.                         if($sizeValue >= 1000){
  372.                             $sizeValue  = $sizeValue / 1000;
  373.                             $sizeValue  = $sizeValue." L";
  374.                         }else{
  375.                             $sizeValue  = $variants->getBottleSize();
  376.                         }
  377.                         $sizes.=$sizeValue.', ';
  378.                     }
  379.                     
  380.                     $countries = $variants->getCountryAvailabilityList();
  381.                     $continue = 0;
  382.                     if (count($countries) == 1) {
  383.                         foreach ($countries as $country) {
  384.                                 if ($country->getObject()->getId() == $this->countryId) {
  385.                                     $this->view->proof = $variants->getProof();
  386.                                     $this->view->abv = $variants->getABV();
  387.                                 }
  388.                         }
  389.                     }
  390.                 }
  391.             }
  392.             if ($sizes !='') {
  393.                 $sizes = rtrim($sizes, ', ');
  394.             }
  395.             
  396.             $accolades = $brandExtObj->getAccoladesList();
  397.             if ($accolades) {
  398.                 $this->view->accoladeItems = $accolades->getItems();
  399.             }
  400.             
  401.             //$tasingNoteItems = $brandExtObj->getlocalizedfields()->getItems();
  402.             $tasingNoteItems = array();
  403.             $tasingNoteItems['TasteProfileColor'] = $brandExtObj->getTasteProfileColor($locale);
  404.             $tasingNoteItems['TasteProfileAroma'] = $brandExtObj->getTasteProfileAroma($locale);
  405.             $tasingNoteItems['TasteProfileTaste'] = $brandExtObj->getTasteProfileTaste($locale);
  406.             $tasingNoteItems['TasteProfileFinish'] = $brandExtObj->getTasteProfileFinish($locale);
  407.             $tasingNoteItems['TasteProfileHeadline'] = $brandExtObj->getTasteProfileHeadline($locale);
  408.             $tasingNoteItems['TasteProfileIntro'] = $brandExtObj->getTasteProfileIntro($locale);
  409.             $this->view->tastingNotes = $tasingNoteItems;
  410.             
  411.             $brandExtFullDescrHeadline = $brandExtObj->getFullDescriptionHeadline($locale);
  412.             $brandExtFullDescr = $brandExtObj->getFullDescription($locale);
  413.             
  414.             $brandExtNameTradeMark = $this->view->brandExtNameTradeMark = $brandExtObj->getBrandExtensionNameTrademark();
  415.             $this->view->brandExtName = $brandExtObj->getBrandExtensionName();
  416.             
  417.             if((!$portfolioGuideName || $portfolioGuideName == '') && !$pgMultiFlag){
  418.                 
  419.                 if (!$brandExtNameTradeMark || $brandExtNameTradeMark == '')
  420.                 {
  421.                     $portfolioGuideName = $brandExtObj->getBrandExtensionName();
  422.                 }
  423.                 else
  424.                 {
  425.                     $portfolioGuideName = $brandExtNameTradeMark;
  426.                 }
  427.             }
  428.         }
  429.                    
  430.         $altProdDescrHeadline = $pgObject->getAltProductDescrHeadline($locale);
  431.         if((!$altProdDescrHeadline || $altProdDescrHeadline == "") && !$pgMultiFlag){
  432.             $altProdDescrHeadline = $brandExtFullDescrHeadline;
  433.         }
  434.         
  435.         //get other expressions
  436.         $otherExpressionsHeadline = $pgObject->getAltExpressionsHeadline($locale);
  437.         if(!$otherExpressionsHeadline || $otherExpressionsHeadline == ""){
  438.             if ($brand->getBrandNameTrademark()) {
  439.                 $otherExpressionsHeadline = $brand->getBrandNameTrademark();
  440.             } else {
  441.                 $otherExpressionsHeadline = $brand->getBrandName();
  442.             }
  443.         }
  444.                 
  445.         $otherExpressions = [];
  446.         $otherExpressionsList = $pgObject->getOtherPortfolioGuides();
  447.         $x = 0;
  448.         if ($otherExpressionsList)
  449.         {
  451.             foreach ($otherExpressionsList as $otherExpression)
  452.             {
  454.                 $otherPG = $otherExpression->getObject();
  455.                 $otherPGId = $otherPG->getId();
  456.                 
  457.                 if($otherExpression->getaltdisplayname()){
  458.                     $otherPGName = $otherExpression->getaltdisplayname();
  459.                 }
  460.                 else
  461.                 {    
  462.                     DataObject\AbstractObject::setHideUnpublished(false);
  463.                     $otherPGbrandExtensionList = $otherPG->getBrandExtension();
  464.                     DataObject\AbstractObject::setHideUnpublished(true);
  466.                     DataObject\AbstractObject::setHideUnpublished(false);
  467.                     $otherPGNameBrandExt = $otherPG->getBrandExtension();
  468.                     if ($otherPGNameBrandExt)
  469.                     {
  470.                         $otherPGNameBrandExtObj = $otherPGNameBrandExt[0]->getObject();
  471.                         
  472.                         $countries = $otherPGNameBrandExtObj->getCountryAvailabilityList();
  473.                         $add = 0;
  474.                         if ($countries) {
  475.                             foreach ($countries as $country) {
  476.                                     if ($country->getObject()->getId() == $this->countryId) {
  477.                                         $add = 1;
  478.                                     }
  479.                             }
  480.                             if ($add == 0) {
  481.                                 continue;
  482.                             }
  483.                         }
  485.                         if ($otherPG->getAltTitle())
  486.                         {
  487.                             $otherPGName = $otherPG->getAltTitle();
  488.                         }
  489.                         else
  490.                         {
  491.                             $otherPGName = $otherPGNameBrandExtObj->getBrandExtensionNameTrademark();
  492.                             if (!$otherPGName || $otherPGName == '')
  493.                             {
  494.                                 $otherPGName = $otherPGNameBrandExtObj->getBrandExtensionName();
  495.                             }
  496.                         }
  497.                     }
  498.                     DataObject\AbstractObject::setHideUnpublished(true);
  499.                     if(count($otherPGbrandExtensionList) > 1)
  500.                     {
  501.                          
  502.                     } 
  503.                     else
  504.                     {
  506.                     }
  508.                 }
  509.                 
  510.                 $otherExpressions[$x][0] = $otherPGId;
  511.                 $otherExpressions[$x][1] = $otherPGName;
  512.                 $otherExpressions[$x][2] = $otherPG->getKey();
  513.                 $x++;
  514.             }
  515.             
  516.             $this->view->otherExpressionsList = $otherExpressions;
  517.                 
  518.         }
  519.         
  520.         $altProdDescr = $pgObject->getAltProductDescr($locale);
  521.         if((!$altProdDescr || $altProdDescr == "") && !$pgMultiFlag){
  522.             $altProdDescr = $brandExtFullDescr;
  523.         }
  524.         $this->view->pgMultiFlag = $pgMultiFlag;      
  525.         $this->view->pgKey = $pgObject->getKey();
  526.         $this->view->portfolioGuideName = $portfolioGuideName;
  527.         $this->view->paramId = $paramId;
  528.         $this->view->alcoholTypeCateg = $alcoholTypeCateg;
  529.         $this->view->bottleImageHtml = $bottleImageHtml;
  530.         $this->view->altProdDescrHeadline = $altProdDescrHeadline;
  531.         $this->view->altProdDescr = $altProdDescr;
  532.         $this->view->sizes = $sizes;
  533.         $this->view->otherExpressionsHeadline = $otherExpressionsHeadline;
  534.         $this->view->bottleImage = $bottleImage;
  535.         $this->view->bottleImageName = $bottleImageName;
  536.         $this->view->brandPhoto = $brandPhoto;
  537.         $this->view->brandPhotoName = $brandPhotoName;
  538.         //$this->enableLayout();
  539.     }
  540.     
  541.     public function pageAction(Request $request) {
  542.         
  543.             //$this->layout()->setLayout('portfolioguideportal');
  544.             //$this->enableLayout();    
  545.     }
  546.     public function footerAction(Request $request) {
  548.     }
  549.     
  550.     public function portfolioGuideOrdering() 
  551.     {  
  552.         ini_set('memory_limit', '512M'); 
  553.         $order_by = "";        
  554.         $condition = "";
  555.         $limit = "";
  556.         $this->view->current_alcohol_type = "";
  557.         //$this->layout()->setLayout('portfolioguideportal');
  558.         $this->view->CssClass = "sub-category-page";
  559.         $headTitleHelper = \Pimcore::getContainer()->get('pimcore.templating.view_helper.head_title');
  560.         $headTitleHelper("Portfolio Guide");
  562.         $alcohol_type_obj = new DataObject\CategoryAlcoholType();       
  563.         $brand_obj = new DataObject\Brand();
  564.         $brand_extension_obj = new DataObject\BrandExtension();
  565.         $portfolio_guide_obj = new DataObject\PortfolioGuide();
  566.         $portfolio_brand = DataObject\CategoryAlcoholType::getList();
  567.         
  568.         $locale = $this->locale;
  569.                 
  570.         $type_id = ($_REQUEST['type']) ? $_REQUEST['type'] : "";
  571.         $brand_id = ($_REQUEST['Brand']) ? $_REQUEST['Brand'] : "";
  572.         $search = ($_REQUEST['search']) ? $_REQUEST['search'] : "";
  573.         $countryAvailability = ($this->countryId) ? $this->countryId : "";
  574.         $count_per_page = ($_REQUEST['counter'])? $_REQUEST['counter']:15;        
  575.         
  576.         //the below line gets all Portfolio Guide objects + all the related data, becomes 160MB array and kills php, let's use SQL
  577.         //$portfolio_guides_list = Object\PortfolioGuide::getList();        
  578.         $db = \Pimcore\Db::get();
  579.         $result = $db->fetchAll("SELECT COUNT(`oo_id`) as PFG_Number FROM `object_localized_" . $portfolio_guide_obj->getClassId() . "_" . $locale . "` WHERE `o_published` = 1");
  580.         $portfolio_guides_list = $result[0]['PFG_Number'];
  581.             
  582.         $count_per_page = ($count_per_page == "all")? $portfolio_guides_list:$count_per_page;
  583.         $sorting =  ($_REQUEST['sorting'])? $_REQUEST['sorting']:1;  
  585.         $childs = $this->view->types = \App\Model\DataObject\PortfolioGuide::getAlcoholChilds($type_id);   
  586.         $child_array = array($type_id);
  587.         foreach($childs as $child)
  588.         {
  589.             $child_array[] = $child->getId();
  590.         }        
  591.         if($type_id)
  592.         {
  593.             $current_alcohol_type = \App\Model\DataObject\PortfolioGuide::getAlcoholTypeName($type_id);
  594.             $this->view->current_alcohol_type = $current_alcohol_type;
  595.         }
  596.         if ($type_id) {
  597.             $condition .= " AND REPLACE(object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ".AlcoholType,',','') IN (" . implode(', ', $child_array) . ")";
  598.         }        
  600.         if ($brand_id) {
  601.             $condition .= " AND object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ".Brand LIKE '%" . $brand_id . "%'";
  602.         }
  604.         if ($search) {
  605.             $condition .= " AND object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ".BrandExtensionName LIKE '%" . trim($search) . "%'";
  606.         }
  607.         
  608.         if ($countryAvailability) {
  609.             $condition .= " AND object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ".CountryAvailabilityList LIKE '%" . trim($countryAvailability) . "%'";
  610.         }
  611.         
  612.         if ($sorting) {
  613.             if ($sorting == 2) {
  614.                 $order_by = " ORDER BY object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ".BrandExtensionName ASC";
  615.             } else if ($sorting == 3) {
  616.                 $order_by = " ORDER BY object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ".BrandExtensionName DESC";
  617.             } else if ($sorting == 4) {
  618.                 $order_by = " ORDER BY object_localized_" . $portfolio_guide_obj->getClassId() . "_" . $locale . ".o_modificationDate DESC";
  619.             } else {
  620.                 $order_by = " ORDER BY object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ".Brand ASC, Ordering";
  621.             }
  622.         }
  623.         $db = \Pimcore\Db::get();
  624.                        
  625.         $start = ($_REQUEST["page"])?($_REQUEST["page"]-1)*$count_per_page:0;
  626.         $start = ($start < $portfolio_guides_list)? $start:0;
  627.         $limit = " LIMIT ".$start.",".$count_per_page;
  628.         
  629.         $sql = "SELECT "
  630.                 . "object_localized_" . $portfolio_guide_obj->getClassId() . "_" . $locale . ".oo_id AS guide_id, "
  631.                 . "object_localized_" . $portfolio_guide_obj->getClassId() . "_" . $locale . ".Order AS Ordering, "
  632.                 . "object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ".o_creationDate AS creation_date,"
  633.                 . "object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ".o_modificationDate AS modification_date, "
  634.                 . "object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ".oo_id AS brand_extension_id, "
  635.                 . "object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ".BrandExtensionNameTrademark, "
  636.                 . "object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ".BrandExtensionName, "
  637.                 . "object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ".FullDescriptionHeadline as brandextDescriptionHeadline, "
  638.                 . "object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ".CountryAvailabilityList, "
  639.                 . "object_localized_" . $alcohol_type_obj->getClassId() . "_" . $locale . ".*"
  640.                 . "FROM object_localized_" . $portfolio_guide_obj->getClassId() . "_" . $locale . ""
  641.                 . " LEFT JOIN object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ""
  642.                 . " ON REPLACE(SUBSTRING_INDEX(object_localized_" . $portfolio_guide_obj->getClassId() . "_" . $locale . ".BrandExtension, ',', 2),',','') = object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ".oo_id"
  643.                 . " LEFT JOIN object_localized_" . $brand_obj->getClassId() . "_" . $locale . ""
  644.                 . " ON REPLACE(object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ".Brand,',','') = object_localized_" . $brand_obj->getClassId() . "_" . $locale . ".oo_id"
  645.                 . " LEFT JOIN object_localized_" . $alcohol_type_obj->getClassId() . "_" . $locale . ""
  646.                 . " ON REPLACE(object_localized_" . $brand_extension_obj->getClassId() . "_" . $locale . ".AlcoholType,',','') = object_localized_" . $alcohol_type_obj->getClassId() . "_" . $locale . ".oo_id"
  647.                 . " WHERE object_localized_" . $portfolio_guide_obj->getClassId() . "_" . $locale . ".o_published=1" . $condition;        
  648.         
  649.         $portfolio_guide_all_list = $db->fetchAll($sql);
  650.         $this->view->total_items = ceil((count($portfolio_guide_all_list))/$count_per_page);
  651.         $portfolio_guide = $db->fetchAll($sql.$order_by.$limit);
  652.         
  653.         $this->view->current_page = ($_REQUEST["page"])?($_REQUEST["page"]):1;       
  654.         $display_items_id = array();                
  655.         $all_portfolio_type_count = \App\Model\DataObject\PortfolioGuide::getAlcoholTypeCount($brand_id, $portfolio_guide_all_list);
  656.         
  657.         foreach($this->view->types as $type)
  658.         {
  659.             $sub_child_count_alcohol[$type->getId()] = 0;
  660.             $items = new DataObject\CategoryAlcoholType\Listing();                
  661.             $items ->setCondition("o_parentId = ?", array($type->getId()));  
  662.             if($all_portfolio_type_count[$type->getId()])
  663.             {
  664.                 $display_items_id[] = $type->getId();                  
  665.             }            
  666.             else
  667.             {
  668.                 foreach($items as $item)
  669.                 {
  670.                     if($all_portfolio_type_count[$item->getId()])
  671.                     {
  672.                         $display_items_id[] = $type->getId();                          
  673.                     }
  674.                 }
  675.             }            
  676.         }  
  677.                         
  678.         DataObject\AbstractObject::setHideUnpublished(false);
  679.         $this->view->brand = DataObject\Brand::getList();
  680.         DataObject\AbstractObject::setHideUnpublished(true);
  681.         $this->view->portfolio_guide = $portfolio_guide;        
  682.         $this->view->portfolio_brand_count = \App\Model\DataObject\PortfolioGuide::getBrandCount($type_id, $portfolio_guide_all_list);
  683.         $this->view->portfolio_type_count = $all_portfolio_type_count;
  684.         $this->view->initial_display_alcohol_type = $display_items_id;
  685.         
  686.         //$this->enableLayout();  
  687.         
  688.     }
  690. }