src/Kiwi/EshopBundle/Service/EshopGatewayHandle.php line 638

Open in your IDE?
  1. <?php
  4. namespace Kiwi\EshopBundle\Service;
  7. use Kiwi\EshopBundle\Entity\Product;
  8. use Kiwi\EshopBundle\Entity\ProductHolders;
  9. use Symfony\Component\HttpFoundation\Request;
  11. class EshopGatewayHandle {
  12.     var $controller = null;
  14.     protected $languages;
  15.     /**
  16.      * @var \Doctrine\ORM\EntityManager
  17.      */
  18.     private $em;
  20.     /**
  21.      * @var \Kiwi\PageBundle\Twig\PageExtensions
  22.      */
  23.     private $pageExtensions;
  25.     /**
  26.      * @var \Kiwi\EshopBundle\Service\EshopProductsHandle
  27.      */
  28.     private $eshopProductsHandle;
  30.     /**
  31.      * @var \Kiwi\SearchBundle\Service\SearchHandle
  32.      */
  33.     private $searchHandle;
  35.     /**
  36.      * @var \Kiwi\EshopBundle\Service\EshopCategoriesHandle
  37.      */
  38.     private $eshopCategoriesHandle;
  40.     /**
  41.      * @var \Kiwi\EshopBundle\Service\EshopParamsHandle
  42.      */
  43.     private $eshopParamsHandle;
  45.     /**
  46.      * @var \Kiwi\EshopBundle\Service\EshopProducersHandle
  47.      */
  48.     private $eshopProducersHandle;
  50.     /**
  51.      * @var \Kiwi\EshopBundle\Service\EshopAttachementsHandle
  52.      */
  53.     private $eshopAttachementsHandle;
  55.     public function __construct(\Doctrine\ORM\EntityManager $em,
  56.                                 \Kiwi\LanguagesBundle\Service\LanguagesHandle $languages,
  57.                                 \Kiwi\PageBundle\Twig\PageExtensions $pageExtensions,
  58.                                 \Kiwi\EshopBundle\Service\EshopProductsHandle $eshopProductsHandle,
  59.                                 \Kiwi\SearchBundle\Service\SearchHandle $searchHandle,
  60.                                 \Kiwi\EshopBundle\Service\EshopCategoriesHandle $eshopCategoriesHandle,
  61.                                 \Kiwi\EshopBundle\Service\EshopParamsHandle $eshopParamsHandle,
  62.                                 \Kiwi\EshopBundle\Service\EshopProducersHandle $eshopProducersHandle,
  63.                                 \Kiwi\EshopBundle\Service\EshopAttachementsHandle $eshopAttachementsHandle) {
  64.         $this->em = $em;
  65.         $this->languages = $languages;
  66.         $this->pageExtensions = $pageExtensions;
  67.         $this->eshopProductsHandle = $eshopProductsHandle;
  68.         $this->searchHandle = $searchHandle;
  69.         $this->eshopCategoriesHandle = $eshopCategoriesHandle;
  70.         $this->eshopParamsHandle = $eshopParamsHandle;
  71.         $this->eshopProducersHandle = $eshopProducersHandle;
  72.         $this->eshopAttachementsHandle = $eshopAttachementsHandle;
  73.     }
  75.     public function setController($controller) {
  76.         $this->controller = $controller;
  77.         return $this;
  78.     }
  80.     public function getCategories($config, Request $request) {
  81.         $main_category = explode('/',$request->getUri()); $main_category = end($main_category);
  83.         return $this->eshopCategoriesHandle->getCategoriesBySeoName($main_category);
  84.     }
  86.     public function getParam($config, Request $request) {
  87.         $code = null;
  88.         if(isset($config['method_params'])) {
  89.             if(isset($config['method_params'][0])) {
  90.                 $code = $config['method_params'][0];
  91.             }
  92.         }
  94.         if(!$config) {
  95.             return false;
  96.         }
  98.         $param = $this->eshopParamsHandle->getCustomParamByCode($code);
  99.         $list = $this->eshopParamsHandle->getCustomParamList($param->getId());
  101.         foreach ($list as $l) {
  102.             $l->full_link = $this->controller->get('page_twig_extension')->kpathFunction(12, $config['lang']);
  103.             $l->full_link .= $l->getCode();
  104.         }
  106.         return array(
  107.             'param' => $param,
  108.             'list' => $list
  109.         );
  112.         return $code;
  113.     }
  115.     private function getUrlCategory(Request $request){
  116.         $uri = explode('?', $request->getRequestUri());
  117.         $uri = explode('/', $uri[0]);
  118.         return $this->eshopCategoriesHandle->getCategoryBySeoName(end($uri));
  119.     }
  121.     private function getUrlKolekce(Request $request){
  122.         $uri = explode('?', $request->getRequestUri());
  123.         $uri = explode('/', $uri[0]);
  124.         return $this->eshopParamsHandle->getCustomListParamByCode(4, end($uri));
  125.     }
  127.     private function getUrlProducer(Request $request){
  128.         $uri = explode('?', $request->getRequestUri());
  129.         $uri = explode('/', $uri[0]);
  130.         return $this->eshopProducersHandle->getProducerByCode(end($uri));
  131.     }
  133.     private function getUrlStyl(Request $request){
  134.         $uri = explode('?', $request->getRequestUri());
  135.         $uri = explode('/', $uri[0]);
  136.         return $this->eshopParamsHandle->getCustomListParamByCode(9, end($uri));
  137.     }
  139.     private function getQQdataCategory(Request $request) {
  140.         $category = $this->getUrlCategory($request);
  142.         $qq = $request->get('qq');
  144.         if($category) {
  145.             $qq[0][$category->getId()] = 'on';
  146.         }
  148.         return $qq;
  149.     }
  151.     private function getQQdataKolekce(Request $request) {
  152.         $kolekce = $this->getUrlKolekce($request);
  154.         $qq = $request->get('qq');
  156.         if($kolekce) {
  157.             $qq[$kolekce->getCustomParamId()][$kolekce->getId()] = 'on';
  158.         }
  160.         return $qq;
  161.     }
  163.     private function getQQdataStyle(Request $request) {
  164.         $styl = $this->getUrlStyl($request);
  166.         if($styl) {
  167.             $qq[$styl->getCustomParamId()][$styl->getId()] = 'on';
  168.         }
  170.         return $qq;
  171.     }
  173.     public function getFilterData($config, Request $request) {
  174.         $context = null;
  175.         if(isset($config['method_params'])) {
  176.             if(isset($config['method_params'][0])) {
  177.                 $context = $config['method_params'][0];
  178.             }
  179.         }
  181.         switch ($context) {
  182.             default:
  183.                 $category = $this->getUrlCategory($request);
  184.                 $qq = $this->getQQdataCategory($request);
  185.             break;
  186.             case 'style':
  187.                 //$category = $this->getUrlCategory($request);
  188.                 $category = null;
  189.                 $qq = $this->getQQdataStyle($request);
  190.             break;
  191.             /*
  192.             case 'material':
  193.                 $qq = $this->getQQdataCategory($request);
  194.             break;
  195.             case 'kolekce':
  196.                 $qq = $this->getQQdataKolekce($request);
  197.             break;
  198.             */
  199.         }
  201.         $fillingProducts = $this->getProducts($config, $request);
  202.         $fillingProductsAgreagted = [];
  203.         $fillingProductsCategoriesAgreagted = [];
  204.         foreach($fillingProducts['result']['data'] as $ag_product) {
  205.             //if($ag_product['id'] == 185)
  206.             //    return $ag_product;
  208.             //categories filler
  209.             if(isset($ag_product['master_category'])) {
  210.                 if(isset($ag_product['master_category']['id'])) {
  211.                     $fillingProductsCategoriesAgreagted[] = $ag_product['master_category']['id'];
  212.                 }
  213.             }
  215.             //params filler
  216.             foreach($ag_product['params_full'] as $ag_product_param) {
  218.                 //declare if not defined
  219.                 if(!isset($fillingProductsAgreagted[$ag_product_param['id']])) {
  220.                     $fillingProductsAgreagted[$ag_product_param['id']] = [];
  221.                 }
  223.                 //agregate enabled values
  224.                 if(count($ag_product_param['current']) >= 1) {
  225.                     foreach($ag_product_param['current'] as $ag_product_param_current) {
  226.                         if(!in_array($ag_product_param_current, $fillingProductsAgreagted[$ag_product_param['id']])) {
  227.                             $fillingProductsAgreagted[$ag_product_param['id']][] = $ag_product_param_current;
  228.                         }
  229.                     }
  230.                 }
  231.             }
  232.         }
  234.         $fillingProductsCategoriesAgreagted = array_unique($fillingProductsCategoriesAgreagted);
  236.         $ret = [];
  238.         if($category) {
  239.             $cpl = $this->eshopParamsHandle->getCustomParamsCategoryFiltered($category);
  240.         } else {
  241.             $cpl = $this->eshopParamsHandle->getCustomParams();
  242.         }
  244.         foreach($cpl as $opt){
  245.             if($opt->getIsVisible()) {
  246.                 $options = $this->eshopParamsHandle->getCustomParamList($opt->getId(), (isset($fillingProductsAgreagted[$opt->getId()])) ? $fillingProductsAgreagted[$opt->getId()] : []);
  247.                 if(count($options) >= 1) {
  248.                     $ret[] = array(
  249.                         'id' => $opt->getId(),
  250.                         'name' => $opt->getName(),
  251.                         'code' => $opt->getCode(),
  252.                         'type' => $opt->getType(),
  253.                         'options' => $options
  254.                     );
  255.                 }
  256.             }
  257.         }
  259.         if(is_null($category) or $category->getOptFour()) {
  260.             $ret[] = array(
  261.                 'id' => 0,
  262.                 'name' => '<?xml version="1.0" encoding="utf-8" ?><data><cz><![CDATA[Material]]></cz></data>',
  263.                 'code' => 'category',
  264.                 'type' => "list-multiple",
  265.                 'options' => $this->eshopCategoriesHandle->getCategories(0, false, 'cz', $fillingProductsCategoriesAgreagted)
  266.             );
  267.         }
  269.         /*
  270.          *     "id" => 2
  271.     "name" => "<?xml version="1.0" encoding="utf-8" ?><data><cz><![CDATA[Styl]]></cz></data>"
  272.     "code" => "style"
  273.     "type" => "list-multiple"
  274.     "options" => array:14 [▶]
  275.   ]
  276.          * */
  278.         return array(
  279.             'data' => $ret,
  280.             'qq' => $qq,
  281.             'test' => $fillingProductsAgreagted,
  282.             'test2' => $fillingProducts['result']['data']
  283.         );
  284.     }
  286.     public function getProductsByProducer($config, Request $request) {
  287.         $producer = $this->getUrlProducer($request);
  289.         if(!$producer) {
  290.             return false;
  291.         }
  293.         $search = clone $this->searchHandle;
  294.         $search->generateRn();
  295.         $search->setRequest($request)
  296.             ->setFrom($this->eshopCategoriesHandle->repo_categories,'c')
  297.             ->setJoin('c.product', 'p')
  298.             ->setJoin('p.producer', 'pr')
  299.             //->setJoin('h.article', 'a')
  300.             ->addWhere('p.is_holder = true')
  301.             ->addWhere('p.eshop_id = '.$this->eshopProductsHandle->getEshop()->getId())
  302.             ->addWhere('pr.id = '.$producer->getId())
  303.             //->setSearchTextLike('p.transport_code', 'Kód')
  304.             //->setSearchTextLike('a.name', 'Jméno')
  305.             //->addWhere('p.eshop_id = '.$this->get('eshop_products_handle')->getEshop()->getId())
  307.             //->setSearchSelect('u.order_state')
  308.             //->setSearchTextLike('us.username', 'Uživatelské jméno')
  309.             //->setSearchTextLike('a.content', 'Jméno společnosti')
  310.             //->setSearchDateRange('u.created_time', 'Vytvořena')
  311.             ->setSortMask(array())
  312.             ->setRpp(99999);
  316.         //return $search->getResult();
  317.         $search->groupBy('p.id');
  318.         $holders_rs = $search->getResult();
  320.         //print_r($holders_rs['config']['query']); exit;
  322.         $_holders = [];
  323.         foreach ($holders_rs['data'] as $product) {
  324.             //$_holders[] = $product->getProduct();
  325.             //$_holders[] = $this->processHolder($product->getProduct());
  326.             $_holders[] = $this->eshopProductsHandle->getProductReturnArrayBlock($product->getProduct(), 'cz', []);
  327.         }
  328.         $holders_rs['data'] = $_holders;
  330.         return [
  331.             'producer' => $producer,
  332.             'search' => $search,
  333.             'form' => $search->getForm(),
  334.             'result' => $holders_rs,
  335.             'result_type' => 'holders'
  336.             //'paginator' => $this->controller->get('templating')->render('KiwiPaginatorBundle:Kbox:buttons.html.twig',array('paginator' => $holders_rs['config']['paginator'])),
  337.         ];
  338.     }
  340.     public function getProducts($config, Request $request) {
  341.         $context = null;
  342.         if(isset($config['method_params'])) {
  343.             if(isset($config['method_params'][0])) {
  344.                 $context = $config['method_params'][0];
  345.             }
  346.         }
  348.         $category = null;
  349.         switch ($context) {
  350.             default:
  351.                 $category = $this->getUrlCategory($request);
  352.                 $qq = $this->getQQdataCategory($request);
  353.             break;
  354.             case 'style':
  355.                 //$category = $this->getUrlCategory($request);
  356.                 $category = null;
  357.                 $qq = $this->getQQdataStyle($request);
  358.             break;
  359.             /*
  360.             case 'material':
  361.                 $qq = $this->getQQdataCategory($request);
  362.             break;
  363.             case 'kolekce':
  364.                 $qq = $this->getQQdataKolekce($request);
  365.             break;
  366.             */
  367.         }
  369.         if($qq) {
  370.             $products = [];
  371.             $required_score = count($qq);
  373.             foreach ($qq as $param_id => $opts) {
  374.                 if($param_id == 0) {
  375.                     $promoted = [];
  376.                     foreach (array_keys($opts) as $_opt) {
  377.                         foreach ($this->eshopCategoriesHandle->getCategoryProducts($_opt, false) as $_product) {
  378.                             $pid = $_product->getProduct()->getId();
  379.                             if(!in_array($pid, $promoted)) {
  380.                                 $products[$pid] = (isset($products[$pid])) ? ($products[$pid]+1) : 1;
  381.                                 $promoted[] = $pid;
  382.                             }
  383.                         }
  384.                     }
  385.                 } else {
  386.                     $promoted = [];
  387.                     foreach ($this->eshopParamsHandle->getCustomCoParamsByParamId($param_id) as $_opt) {
  388.                         //print_r([$_opt->getProductId()]);
  389.                         $pid = $_opt->getProductId();
  390.                         $intersection = array_intersect(
  391.                             array_keys(
  392.                                 $opts
  393.                             ),
  394.                             array_keys(
  395.                                 unserialize($_opt->getParamValue())
  396.                             )
  397.                         );
  398.                         if(count($intersection) >= 1) {
  399.                             if(!in_array($pid, $promoted)) {
  400.                                 $products[$pid] = (isset($products[$pid])) ? ($products[$pid]+1) : 1;
  401.                                 $promoted[] = $pid;
  402.                             }
  403.                         }
  404.                     }
  405.                 }
  406.             }
  408.             $products_temp = $products;
  409.             $products = [];
  410.             foreach ($products_temp as $product_key => $product_score) {
  411.                 if($product_score == $required_score) {
  412.                     $products[] = $product_key;
  413.                 }
  414.             }
  416.             //this is not needed at this context
  417.             /*
  418.             $products_rs = [];
  419.             //foreach (array_slice($products, 0, 99999) as $product_id) {
  420.             foreach ($products as $product_id) {
  421.                 $products_rs[] = $this->eshopProductsHandle->getProductReturnArrayBlock(
  422.                     $this->eshopProductsHandle->getProduct($product_id),
  423.                     $config['lang'],
  424.                     []
  425.                 );
  426.             }
  427.             */
  430. /*
  431.             $holders_rs = [];
  432.             foreach ($products as $product_id) {
  433.                 $product = $this->eshopProductsHandle->getProduct($product_id);
  434.                 if($product->getIsHidden() == false or is_null($product->getIsHidden())) {
  435.                     if($product->getIsDeleted() == false or is_null($product->getIsDeleted())) {
  436.                         if(!array_key_exists($product->getHolder()->getId(), $holders_rs)) {
  437.                             $holders_rs[$product->getHolder()->getId()] = $this->processHolder($product->getHolder());
  438.                         }
  439.                     }
  440.                 }
  441.             }
  442. */
  444.             $holders_rs = [];
  445.             foreach ($products as $product_id) {
  446.                 $product = $this->eshopProductsHandle->getProduct($product_id);
  447.                 if($product->getIsHidden() == false or is_null($product->getIsHidden())) {
  448.                     if($product->getIsDeleted() == false or is_null($product->getIsDeleted())) {
  449.                         if(!array_key_exists($product->getId(), $holders_rs)) {
  450.                             //$holders_rs[$product->getId()] = $this->processHolder($product);
  451.                             $holders_rs[$product->getId()] = $this->eshopProductsHandle->getProductReturnArrayBlock($product, 'cz', []);
  452.                         }
  453.                     }
  454.                 }
  455.             }
  458.             return [
  459.                 //'search' => $search,
  460.                 //'form' => $search->getForm(),
  461.                 'qq' => $qq,
  462.                 //'result_products' => $products_rs,
  463.                 'result' => array('data' => $holders_rs),
  464.                 'result_type' => 'holders'
  465.                 //'paginator' => $this->controller->get('templating')->render('KiwiPaginatorBundle:Kbox:buttons.html.twig',array('paginator' => $holders_rs['config']['paginator'])),
  467.             ];
  468.         }
  470.         /*
  471.          *         $qb = $this->em->createQueryBuilder();
  472.         $qb->select('c')
  473.             ->from($phObj->repo_categories, 'c')
  474.             ->join('c.product', 'p')
  475.             ->where('c.category_id = :category_id')
  476.             ->andWhere('p.is_deleted = false')
  478.             ->andwhere('p.eshop_id = '.$phObj->getEshop()->getId())
  479.             ->setParameter('category_id', (int)$category_id)
  480.             ->setMaxResults(1000);
  482.         if(!$show_hidden) {
  483.             $qb->andWhere('p.is_hidden = false OR p.is_hidden IS NULL');
  485.         }
  486.          * */
  488.         $search = clone $this->searchHandle;
  489.         $search->generateRn();
  490.         $search->setRequest($request)
  491.             ->setFrom($this->eshopCategoriesHandle->repo_categories,'c')
  492.             ->setJoin('c.product', 'p')
  493.             ->setJoin('p.producer', 'pr')
  494.             //->setJoin('h.article', 'a')
  495.             ->addWhere('p.is_holder = true')
  496.             ->addWhere('p.eshop_id = '.$this->eshopProductsHandle->getEshop()->getId())
  497.             //->setSearchTextLike('p.transport_code', 'Kód')
  498.             //->setSearchTextLike('a.name', 'Jméno')
  499.             //->addWhere('p.eshop_id = '.$this->get('eshop_products_handle')->getEshop()->getId())
  501.             //->setSearchSelect('u.order_state')
  502.             //->setSearchTextLike('us.username', 'Uživatelské jméno')
  503.             //->setSearchTextLike('a.content', 'Jméno společnosti')
  504.             //->setSearchDateRange('u.created_time', 'Vytvořena')
  505.             ->setSortMask(array())
  506.             ->setRpp(99999);
  508.         if($category) {
  509.             $search->addWhere('c.category_id = '.$category->getId());
  510.         }
  512.         if($request->get('q')) {
  513.             $search->setSearchTextLike('a.name', 'Jméno');
  514.             $search->addWhere('
  515.                 p.code LIKE \'%'.addslashes($request->get('q')).'%\' OR
  516.                 pr.name LIKE \'%'.addslashes($request->get('q')).'%\' OR                
  517.                 p.name LIKE \'%'.addslashes($request->get('q')).'%\'
  518.             ');
  519.         }
  521.         /*
  522.         $search = clone $this->searchHandle;
  523.         $search->setRequest($request)
  524.                 ->setFrom('Kiwi\EshopBundle\Entity\ProductHolders','p')
  525.                 ->setJoin('p.article','a')
  526.                 ->setSearchTextLike('p.transport_code', 'Kód')
  527.                 ->setSearchTextLike('a.name', 'Jméno')
  528.                 //->addWhere('p.eshop_id = '.$this->get('eshop_products_handle')->getEshop()->getId())
  530.                 //->setSearchSelect('u.order_state')
  531.                 //->setSearchTextLike('us.username', 'Uživatelské jméno')
  532.                 //->setSearchTextLike('a.content', 'Jméno společnosti')
  533.                 //->setSearchDateRange('u.created_time', 'Vytvořena')
  534.                 ->setSortMask(array())
  535.                 ->setRpp(25);
  537.         if($request->get('q')) {
  538.             $search->addWhere('
  539.                 p.transport_code LIKE \'%'.addslashes($request->get('q')).'%\' OR
  540.                 a.name LIKE \'%'.addslashes($request->get('q')).'%\'
  541.             ');
  542.         }
  543.         */
  545.         //return $search->getResult();
  546.         $search->groupBy('p.id');
  547.         $holders_rs = $search->getResult();
  549.         //print_r($holders_rs['config']['query']); exit;
  551.         $_holders = [];
  552.         foreach ($holders_rs['data'] as $product) {
  553.             //$_holders[] = $product->getProduct();
  554.             //$_holders[] = $this->processHolder($product->getProduct());
  555.             $_holders[] = $this->eshopProductsHandle->getProductReturnArrayBlock($product->getProduct(), 'cz', []);
  556.         }
  557.         $holders_rs['data'] = $_holders;
  559.         return [
  560.             'search' => $search,
  561.             'form' => $search->getForm(),
  562.             'result' => $holders_rs,
  563.             'result_type' => 'holders'
  564.             //'paginator' => $this->controller->get('templating')->render('KiwiPaginatorBundle:Kbox:buttons.html.twig',array('paginator' => $holders_rs['config']['paginator'])),
  566.         ];
  567.     }
  569.     public function getActionProducts($config, Request $request) {
  570.         return $this->eshopProductsHandle->findProducts('cz', array('action' => 1))['filtered'];
  571.     }
  573.     public function getCatalogues($config, Request $request) {
  574.         return $this->eshopAttachementsHandle->getAllCatalogues();
  575.     }
  577.     public function getProductsByStyle($config, Request $request) {
  579.     }
  581.     public function getProduct($config, Request $request) {
  583.         $uri = explode('/', $request->getRequestUri());
  584.         $id = end($uri); $id = explode("?",$id); $id = $id[0];
  586.         //search for holder
  587.         $search = clone $this->searchHandle;
  588.         $search->setRequest($request)
  589.                 ->setFrom('Kiwi\EshopBundle\Entity\Product','p')
  590.                 ->addWhere(sprintf("p.id = %d", $id))
  591.                 ->addWhere('p.is_holder = true')
  592.                 ->setSortMask(array())
  593.                 ->setRpp(1);
  595.         $holder = $search->getResult();
  597.         $product = null;
  598.         if(!isset($holder['data'][0])) {
  599.             //if holder not found try extrapolate from product
  600.             $search = clone $this->searchHandle;
  601.             $search->setRequest($request)
  602.                 ->setFrom('Kiwi\EshopBundle\Entity\Product','p')
  603.                 ->addWhere(sprintf("p.id = %d", $id))
  604.                 ->addWhere('p.is_holder = false')
  605.                 ->setSortMask(array())
  606.                 ->setRpp(1);
  608.             $product = $search->getResult();
  610.             if(isset($product['data'][0])) {
  611.                 $product = $product['data'][0];
  612.                 $holder['data'][0] = $product->getHolder();
  613.             }
  614.         }
  616.         if(!isset($holder['data'][0])) {
  617.             $product = null;
  618.             //if holder not found try extrapolate from holder name
  619.             $search = clone $this->searchHandle;
  620.             $search->setRequest($request)
  621.                 ->setFrom('Kiwi\EshopBundle\Entity\ProductHolders','p')
  622.                 ->setJoin('p.article', 'a')
  623.                 ->addWhere('a.name LIKE \'%'.addslashes($id).'%\'')
  624.                 ->setSortMask(array())
  625.                 ->setRpp(1);
  627.             $holder = $search->getResult();
  629.         }
  631.         if(!isset($holder['data'][0])) {
  632.             return false;
  633.         }
  635.         //return $this->eshopProductsHandle->getProductReturnArrayBlock($holder['data'][0], 'cz', []);
  636.         //return $holder['data'][0];
  638.         $out = $this->processHolderExtended($holder['data'][0], 'cz', $product);
  640.         if(count($out['variants']) <= 0) {
  641.             //return false;
  642.         }
  644.         if(isset($out['id'])) {
  645.             if($config['response']) {
  646.                 $this->eshopProductsHandle->storeCookieProductReference($out['id'], $request, $config['response']);
  647.             }
  648.         }
  650.         if(isset($out['id'])) {
  651.             $seotitle = 'F.a.r.line - '.$out['name'];
  652.             $seodescription = strip_tags($out['description']);
  653.             $seoimage = $out['main_product_image'];
  654.             $this->controller->get('page_frontend_handle')->setPageMeta($seotitle,$seoimage,$seodescription);
  655.         }
  657.         return $out;
  658.     }
  660.     public function getProducers($config, Request $request) {
  661.         return $this->eshopProducersHandle->getProducers(null,true, true);
  662.     }
  664.     public function getProducer($config, Request $request) {
  665.         $producer = $this->getUrlProducer($request);
  667.         if(!$producer) {
  668.             return false;
  669.         }else{
  670.             $out = $this->eshopProducersHandle->getProducers($producer,true, true);
  671.             $seotitle = 'F.a.r.line - '.$this->languages->getLangEntry($out->getName(), 'cz');
  672.             $seodescription = strip_tags($out->getArticle()->getContent());
  673.             $seoimage = '/cut-image-strict/640/480/'.$out->getImage()->getName().'.'.$out->getImage()->getExtension();
  674.             $this->controller->get('page_frontend_handle')->setPageMeta($seotitle,$seoimage,$seodescription);
  675.         }
  676.         return $this->eshopProducersHandle->getProducers($producer,true, true);
  677.     }
  679.     private function processHolder(Product $holder, $lang = 'cz') {
  680.         return $this->eshopProductsHandle->getProductReturnArrayBlock($holder, $lang, []);
  681.         return [
  682.             'id' => $holder->getId(),
  683.             'code' => $holder->getCode(),
  684.             'name' => $this->languages->getLangEntry($holder->getName(), $lang),
  685.             'images_id' => [
  686.                 'main' => ($holder->getArticle()->getImage()) ? $holder->getArticle()->getImage()->getId() : null
  687.             ],
  688.             'url' => [
  689.                 'detail' => $this->getHolderUrl($holder, $lang)
  690.             ]
  691.         ];
  692.     }
  693.     private function processHolderExtended(Product $holder, $lang = 'cz', Product $active_product = null) {
  694.         $data = $this->processHolder($holder, $lang);
  696.         $search = clone $this->searchHandle;
  697.             //->setRequest($request)
  698.         $search->setFrom('Kiwi\EshopBundle\Entity\Product','p')
  699.             ->addWhere(sprintf("p.holder_id = '%d'", $holder->getId()))
  700.             ->setSortMask(array())
  701.             ->setOrderBy('p.sort_num', 'ASC')
  702.             ->setRpp(100);
  705.         $variants_pattern = array();
  706.         for ($i = 1; $i <= 99; $i++) {
  707.             foreach (array('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z') as $letter) {
  708.                 $k = strtolower(
  709.                     sprintf('%d%s',$i,$letter)
  710.                 );
  711.                 $variants_pattern[$k] = null;
  712.             }
  713.         }
  715.         $data['variants'] = [];
  716.         $temp = [];
  717.         foreach ($search->getResult()['data'] as $product) {
  718.             if($product->getIsDeleted() == false && $product->getIsHidden() == false) {
  719.                 $variant = $this->eshopProductsHandle->getProductReturnArrayBlock($product, $lang, []);
  720.                 //$variant['detail_url'] = $this->getHolderUrl($product->getHolder(), $lang).'/'.$product->getCode();
  721.                 //$variant['detail_url'] = $this->eshopProductsHandle->getProductUrl();
  722.                 if($active_product) {
  723.                     if($active_product->getId() == $product->getId()) {
  724.                         $variant['is_selected'] = true;
  725.                     }
  726.                 }
  728.                 if(array_key_exists(strtolower($variant['name']), $variants_pattern)) {
  729.                     $variants_pattern[strtolower($variant['name'])] = $variant;
  730.                 } else {
  731.                     $temp[] = $variant;
  732.                 }
  733.             }
  734.         }
  736.         $data['variants'] = array_values(
  737.             array_filter($variants_pattern)
  738.         );
  740.         //append rest
  741.         foreach ($temp as $temp_variant) {
  742.             $data['variants'][] = $temp_variant;
  743.         }
  745.         $data['recommended'] = $this->eshopProductsHandle->getRecommended($holder);
  747.         $data['producer_products'] = ($holder->getProducer()) ? $this->eshopProducersHandle->getProducerProducts([$holder->getProducer()->getId()])['filtered'] : [];
  749.         return $data;
  750.     }
  752.     private function getHolderUrl(Product $holder, $lang) {
  753.         $dev_prefix = '';
  754.         $url = '/'.$lang.'/';
  756.         if($this->controller->get( 'kernel' )->getEnvironment() == 'dev')
  757.             $dev_prefix = '/app_dev.php';
  759.         /*
  760. $category = null;
  761. foreach($this->controller->get('eshop_categories_handle')->getProductCategories($product) as $product_category) {
  762.     if($product_category->getCategory()->getParentRow()) {
  763.         $category = $product_category->getCategory();
  764.         break;
  765.     }
  766. }
  769. if($category)
  770. {
  771.     if($category->getParentRow())
  772.     {
  773.         if($category->getParentRow()->getParentRow())
  774.         {
  775.             if($category->getParentRow()->getParentRow()->getParentRow())
  776.             {
  777.                 $url .= $category->getParentRow()->getParentRow()->getParentRow()->getName().'/';
  778.             }
  780.             $url .= $category->getParentRow()->getParentRow()->getName().'/';
  781.         }
  783.         $url .= $category->getParentRow()->getName().'/';
  784.     }
  786.     $url .= $category->getName().'/';
  787.     $url .= str_replace(array('  '),' ',$this->getProductName($product, $lang)).'/';
  788.     $url .= $product->getId();
  789. }
  790. else
  791. {
  793.     $url .= 'produkt/'; //$category->GetName().'/';//'drevene-podlahy/';//$category->getName().'/';
  794.     $url .= str_replace(array('  '),' ',$this->getProductName($product, $lang)).'/';
  795.     $url .= $product->getId();
  796. }
  797. */
  799.         $url .= 'produkt/';
  801.         $product = $this->em->getRepository('Kiwi\EshopBundle\Entity\Product')->findOneBy(array(
  802.             'holder_id' => $holder->getId()
  803.         ));
  805.         if($product) {
  806.             foreach($this->eshopCategoriesHandle->getProductCategoriesNoCache($product) as $product_category) {
  807.                 if($product_category->getCategory()) {
  808.                     $url .= $product_category->getCategory()->getSeoName()."/";
  809.                 }
  810.             }
  811.         }
  813.         $url .= $this->languages->getLangEntry($holder->getArticle()->getName(), $lang).'/';
  814.         $url .= $holder->getTransportCode();
  816.         $url = $dev_prefix.$this->pageExtensions->webalizeFunction($url);
  818.         return $url;
  819.     }
  821. }