src/Kiwi/EshopBundle/Service/EshopProductsHandle.php line 1547

Open in your IDE?
  1. <?php
  2. /**
  3.  * Created by PhpStorm.
  4.  * User: Matěj Böswart
  5.  * Date: 6.11.2017
  6.  * Time: 20:34
  7.  */
  9. namespace Kiwi\EshopBundle\Service;
  11. use Kiwi\EshopBundle\Entity\Contingents\ProductRecommended;
  12. use Kiwi\EshopBundle\Entity\Product;
  13. use Kiwi\EshopBundle\Entity\Contingents\ProductParams;
  14. use Kiwi\EshopBundle\Entity\ProductHolders;
  15. use Symfony\Component\Form\Extension\Core\Type\HiddenType;
  16. use Symfony\Component\Form\Extension\Core\Type\SubmitType;
  17. use Symfony\Component\Form\Extension\Core\Type\TextType;
  18. use Symfony\Component\Form\Extension\Core\Type\IntegerType;
  19. use Symfony\Component\HttpFoundation\Request;
  20. use Symfony\Component\Form\Extension\Core\Type\FormType;
  21. use Symfony\Component\HttpFoundation\Response;
  22. use Kiwi\ImageGalleryBundle\Entity\ImageFolderTree;
  23. use Symfony\Component\HttpFoundation\Session\Session;
  24. use Symfony\Component\HttpFoundation\Cookie;
  26. class EshopProductsHandle {
  27.     protected $em;
  28.     protected $languages;
  29.     protected $imageGalleryHandle;
  30.     protected $eshopCategoriesHandle;
  31.     protected $eshopParamsHandle;
  32.     protected $eshopCacheHandle;
  33.     protected $attachementsHandle;
  34.     protected $webHandle;
  35.     protected $eshopUsersHandle;
  36.     protected $article;
  38.     var $controller = null;
  39.     var $request = null;
  40.     var $root_image_folder_name = '_ESHOP_IMAGES_';
  41.     var $root_image_sub_folder_name = '_PRODUCT_IMAGES_';
  43.     var $repo = 'Kiwi\EshopBundle\Entity\Product';
  44.     var $repo_holders = 'Kiwi\EshopBundle\Entity\ProductHolders';
  45.     var $repo_params = 'Kiwi\EshopBundle\Entity\Contingents\ProductParams';
  46.     var $repo_categories = 'Kiwi\EshopBundle\Entity\Contingents\ProductCategory';
  48.     //var $qr_url_pattern = 'http://dev.effectiveonline.cz:81/qr-%s';
  49.     //var $qr_url_pattern = 'http://vape.e-online.cz:4081/qr-%s';
  50.     var $qr_url_pattern = 'http://farline-v2.e-online.cz/qr-%s';
  52.     var $no_image = '/bundles/Farline/img/logo.svg';
  54.     var $cookie_key = 'last_products';
  56.     var $log_path = '';
  57.     /**
  58.      * @var \Kiwi\PageBundle\Twig\PageExtensions
  59.      */
  60.     private $pageExtensions;
  62.     public function __construct(\Doctrine\ORM\EntityManager $em,
  63.                                 \Kiwi\LanguagesBundle\Service\LanguagesHandle $languages,
  64.                                 \Kiwi\ImageGalleryBundle\Service\ImageGalleryHandle $imageGalleryHandle,
  65.                                 \Kiwi\EshopBundle\Service\EshopCategoriesHandle $eshopCategoriesHandle,
  66.                                 \Kiwi\EshopBundle\Service\EshopParamsHandle $eshopParamsHandle,
  67.                                 \Kiwi\EshopBundle\Service\EshopCacheHandle $eshopCacheHandle,
  68.                                 \Kiwi\EshopBundle\Service\EshopAttachementsHandle $attachementsHandle,
  69.                                 \Security\UserBundle\Service\WebHandle $webHandle,
  70.                                 \Kiwi\EshopBundle\Service\EshopUsersHandle $eshopUsersHandle,
  71.                                 \Kiwi\PageBundle\Twig\PageExtensions $pageExtensions,
  72.                                 \Kiwi\ArticleBundle\Service\ArticleHandle $article) {
  73.         $this->em = $em;
  74.         $this->languages = $languages;
  75.         $this->imageGalleryHandle = $imageGalleryHandle;
  76.         $this->eshopCategoriesHandle = $eshopCategoriesHandle;
  77.         $this->eshopParamsHandle = $eshopParamsHandle;
  78.         $this->eshopCacheHandle = $eshopCacheHandle;
  79.         $this->attachementsHandle = $attachementsHandle;
  80.         $this->webHandle = $webHandle;
  81.         $this->eshopUsersHandle = $eshopUsersHandle;
  82.         $this->pageExtensions = $pageExtensions;
  83.         $this->article = $article;
  85.         $this->log_path = dirname(dirname(dirname(dirname(__DIR__)))).'/tmp/ProductsHandle.log';
  87.         //$this->NC1();
  88.         //$this->NC2();
  89.     }
  91.     public function fixCodes() {
  92.         foreach ($this->em->getRepository('Kiwi\EshopBundle\Entity\Producers')->findAll() as $producer) {
  93.             $producer->setCode($this->pageExtensions->webalizeFunction($producer->getCode()));
  94.             $this->em->persist($producer);
  95.             $this->em->flush($producer);
  96.         }
  98.         foreach ($this->em->getRepository('Kiwi\EshopBundle\Entity\KategorieTree')->findAll() as $kategorie) {
  99.             $kategorie->setSeoName($this->pageExtensions->webalizeFunction($kategorie->getSeoName()));
  100.             $this->em->persist($kategorie);
  101.             $this->em->flush($kategorie);
  102.         }
  104.         foreach ($this->em->getRepository('Kiwi\EshopBundle\Entity\CustomParamsLists')->findAll() as $param) {
  105.             $param->setCode($this->pageExtensions->webalizeFunction($param->getCode()));
  106.             $this->em->persist($param);
  107.             $this->em->flush($param);
  108.         }
  109.     }
  111.     public function setController($controller) {
  112.         $this->controller = $controller;
  113.         return $this;
  114.     }
  116.     public function setRequest(Request $request) {
  117.         $this->request = $request;
  118.         return $this;
  119.     }
  121.     public function handleProductUpdate(\Kiwi\EshopBundle\Entity\Product $product, Array $update, Array $categories, Array $params, $categories_handle = '_REPLACE_') {
  122.         /*
  123.          * $categories_handle
  124.          * _REPLACE_ = replace current categories (drop current)
  125.          * */
  127.         //collect data for alter
  128.         $multilang_cols = array(
  129.             'name',
  130.             'name_alt_1',
  131.             'name_alt_2',
  132.             'description_fast',
  133.             'description',
  134.             'holder_name',
  135.             'actionText',
  136.         );
  137.         $redirect_call = array(
  138.             'setHolderNameHolderId' => function(\Kiwi\EshopBundle\Entity\Product $product, $bs){
  139.                 $product->setHolder($this->getProduct($bs));
  140.             },
  141.             'setHolderName' => function(\Kiwi\EshopBundle\Entity\Product $product, $bs){
  142.                 /*
  143.                 if(!$product->getHolder()) {
  144.                     //article for holder
  145.                     $article = $this->article->createBlankArticle($this->languages->getLangEntry($bs, 'cz'));
  147.                     //holder
  148.                     $holder = new ProductHolders();
  149.                     $holder->setArticle($article);
  150.                     $holder->setTransportCode(md5($bs));
  152.                     $this->em->persist($holder);
  153.                     $this->em->flush($holder);
  154.                     $this->em->refresh($holder);
  156.                     $product->setHolder($holder);
  157.                 }
  158.                 */
  159.             }
  160.         );
  161.         $base = array();
  162.         foreach($update as $kfd => $fd) {
  163.             if(in_array(substr($kfd,0,-3),$multilang_cols)) {
  164.                 $a_key = substr($kfd,0,-3);
  165.                 $a_lang = substr(str_replace($a_key,'',$kfd),1);
  167.                 $base[$a_key][$a_lang] = $fd;
  168.             } else {
  169.                 $base[$kfd] = $fd;
  170.             }
  171.         }
  173.         foreach($base as $kbs => &$bs) {
  174.             if(is_array($bs)) {
  175.                 $a_bs = '';
  176.                 foreach($bs as $a_lang => $a_content) {
  177.                     $a_bs = $this->languages->updateLangEntry($a_lang,$a_bs,$a_content);
  178.                 }
  179.                 $bs = $a_bs;
  180.             }
  181.         }
  183.         $base = unserialize(serialize($base));
  184.         //update obect
  185.         foreach($base as $kbs => $bs) {
  186.             $method_name = $this->getSetMethodName($kbs);
  187.             switch($method_name) {
  188.                 default:
  189.                     //echo "method".$method_name."::".$bs."\n";
  190.                     if(!isset($redirect_call[$method_name])) {
  191.                         $product->$method_name($bs);
  192.                     } else {
  193.                         $redirect_call[$method_name]($product, $bs);
  194.                     }
  195.                 break;
  196.                 case 'setCurrency':
  197.                     $product->$method_name($this->em->getRepository('Kiwi\EshopBundle\Entity\Currency')->find($bs));
  198.                 break;
  199.                 case 'setVat':
  200.                     $product->$method_name($this->em->getRepository('Kiwi\EshopBundle\Entity\Vat')->find($bs));
  201.                 break;
  202.                 case 'setEshop':
  203.                     $product->$method_name($this->em->getRepository('Kiwi\EshopBundle\Entity\Eshops')->find($bs));
  204.                 break;
  205.                 case 'setHolder':
  206.                     if($bs) {
  207.                         $product->$method_name($this->em->getRepository('Kiwi\EshopBundle\Entity\ProductHolders')->find($bs));
  208.                     } else {
  209.                         $method_name_id = $method_name.'Id';
  210.                         $product->$method_name(null);
  211.                         $product->$method_name_id(null);
  212.                         //var_dump($product->getHolderId()); exit;
  213.                     }
  214.                 break;
  215.                 case 'setUnit':
  216.                     if($bs) {
  217.                         $product->$method_name($this->em->getRepository('Kiwi\EshopBundle\Entity\Unit')->find($bs));
  218.                     } else {
  219.                         $product->$method_name(null);
  220.                     }
  221.                 break;
  222.                 case 'setProducer':
  223.                     if($bs) {
  224.                         $product->$method_name($this->em->getRepository('Kiwi\EshopBundle\Entity\Producers')->find($bs));
  225.                     } else {
  226.                         $product->$method_name(null);
  227.                     }
  228.                 break;
  229.                 case 'setProductId':
  230.                 case 'setRef':
  231.                     null;
  232.                 break;
  233.             }
  234.         }
  236.         $product->setCreatedTime(new \DateTime('now'));
  237.         $product->setUpdatedTime(new \DateTime('now'));
  238.         //$product->setEshop($this->getEshop());
  240.         //$this->em->merge($product);
  241.         $this->em->persist($product);
  242.         $this->em->flush();
  244.         //categories
  245.         $categories = array_unique($categories);
  246.         switch($categories_handle) {
  247.             case '_REPLACE_':
  248.                 foreach($this->eshopCategoriesHandle->getProductCategoriesNoCache($product) as $product_category) {
  249.                     $this->em->remove($product_category);
  250.                     $this->em->flush();
  251.                 }
  253.                 foreach($categories as $category) {
  254.                     $category = $this->eshopCategoriesHandle->getCategory($category);
  255.                     if($category) {
  256.                         $this->eshopCategoriesHandle->addCategoryProduct(
  257.                             $category,
  258.                             $product
  259.                         );
  260.                     }
  261.                 }
  262.             break;
  263.         }
  265.         //params update
  266.         $params_processed = [];
  267.         foreach($params as $param_id => $param_value) {
  268.             $a_param = $this->getProductParam($product->getId(), $param_id);
  270.             if(!$a_param) {
  271.                 $a_param = new ProductParams();
  272.                 $a_param->setProduct($product);
  273.                 $a_param->setParam($this->eshopParamsHandle->getCustomParam($param_id));
  274.             }
  276.             if(is_array($param_value)) {
  277.                 $a_param->setParamValue(serialize($param_value));
  278.             } else {
  279.                 $a_param->setParamValue($param_value);
  280.             }
  282.             $this->em->persist($a_param);
  283.             $this->em->flush();
  285.             $params_processed[] = $param_id;
  286.         }
  288.         //params cleanup (not processed ones)
  289.         $allCustomParams = $this->eshopParamsHandle->getCustomParams();
  290.         foreach ($allCustomParams as $acp) {
  291.             if(!in_array($acp->getId(), $params_processed)) {
  292.                 $a_param = $this->getProductParam($product->getId(), $acp->getId());
  294.                 if($a_param) {
  295.                     $a_param->setParamValue(serialize(array()));
  296.                     $this->em->persist($a_param);
  297.                     $this->em->flush();
  298.                 }
  299.             }
  300.         }
  302.         $this->eshopCacheHandle->clearCache('vape-eshop-product-'.$product->getId().'-compiled');
  303.         $this->eshopCacheHandle->clearCache('eshop-product-'.$product->getId().'-categories');
  305.         return $product;
  306.     }
  308.     public function handleProductsBatchCategoryUpdate(Array $products, Array $categories) {
  309.         if($products) {
  310.             foreach ($products as $product_id) {
  311.                 $product = $this->getProduct($product_id);
  313.                 $this->handleProductUpdate(
  314.                     $product,
  315.                     array(),
  316.                     $categories,
  317.                     array()
  318.                 );
  319.             }
  321.             return true;
  322.         } else {
  323.             return false;
  324.         }
  325.     }
  327.     public function getProduct($product_id) {
  328.         return $this->em->getRepository($this->repo)->find((int)$product_id);
  329.     }
  331.     public function getHolder($holder_id) {
  332.         return $this->em->getRepository($this->repo_holders)->find((int)$holder_id);
  333.     }
  335.     public function getHolders() {
  336.         return $this->em->getRepository($this->repo_holders)->findAll();
  337.     }
  339.     public function getEshops(Array $eshops = null) {
  340.         $ret = array();
  341.         $eshops = (count($eshops) >= 1) ? $eshops : $this->em->getRepository('Kiwi\EshopBundle\Entity\Eshops')->findAll();
  343.         foreach($eshops as $eshop) {
  344.             $web = $this->em->getRepository('Security\UserBundle\Entity\Web')->findOneBy(array('eshop_id' => $eshop->getId()));
  346.             if($web) {
  347.                 $languages = array();
  349.                 foreach($this->em->getRepository('Kiwi\LanguagesBundle\Entity\Languages')->findBy(array('web_id' => $web->getId())) as $language) {
  350.                     $languages[] = $language->getCode();
  351.                 }
  353.                 $ret[] = array(
  354.                     'id' => $eshop->getId(),
  355.                     'name' => $this->languages->getLangEntry($eshop->getName(),$this->languages->getDefaultLang($this->webHandle->getCurrentWeb()->getId())),
  356.                     'code' => $eshop->getCode(),
  357.                     'languages' => $languages
  358.                 );
  359.             }
  360.         }
  362.         return $ret;
  363.     }
  365.     public function getUsersEshops() {
  366.         $user = $this->eshopUsersHandle->getCurrentUser();
  368.         if($user) {
  369.             $_eshops = array();
  370.             foreach($this->eshopUsersHandle->getUsersEshops($user->getId(),true) as $eshop) {
  371.                 $_eshops[] = $this->em->getRepository('Kiwi\EshopBundle\Entity\Eshops')->find($eshop['id']);
  372.             }
  374.             return $this->getEshops($_eshops);
  375.         } else {
  376.             return $this->getEshops();
  377.         }
  378.     }
  380.     public function getEshopById($eshop_id) {
  381.         return $this->em->getRepository('Kiwi\EshopBundle\Entity\Eshops')->find((int)$eshop_id);
  382.     }
  384.     public function getEshop() {
  385.         $web = $this->webHandle->getCurrentWeb();
  387.         if(!$web)
  388.             return null;
  390.         return $web->getEshop();
  391.     }
  393.     public function checkForEshop() {
  394.         if(!$this->getEshop()) {
  395.             Header('Location: '.
  396.                 $this->controller->get('router')->generate('admin_webselector'));
  397.             exit();
  398.         }
  399.     }
  401.     public function getEshopDefaultLang($eshop_id) {
  402.         if($eshop_id >= 1) {
  403.             $web = $this->webHandle->getWebByEshopId($eshop_id);
  404.             if($web) {
  405.                 return $this->languages->getDefaultLang($web->getId());
  406.             }
  407.         }
  409.         return null;
  410.     }
  412.     public function getProductByCode($product_code) {
  413.         return $this->em->getRepository($this->repo)->findOneBy(array('code' => addslashes($product_code)));
  414.     }
  416.     public function getProductImages(\Kiwi\EshopBundle\Entity\Product $product, $lang = 'cz') {
  417.         $ret = array();
  419.         if($product->getGallery()) {
  420.             foreach($this->imageGalleryHandle->getFolderImages($product->getGallery()->getId()) as $image) {
  421.                 $label = $this->getProductName($product, $lang);
  422.                 $label_alt = $this->languages->getLangEntry($image->getAltName(),$lang);
  423.                 $ret[] = array(
  424.                     'id' => $image->getId(),
  425.                     'label' => ($label_alt != '') ? $label_alt : $label
  426.                 );
  427.             }
  428.         }
  430.         return $ret;
  431.     }
  433.     public function getRecommended(\Kiwi\EshopBundle\Entity\Product $product, $lang = 'cz') {
  434.         $recommended = $this->em->getRepository('Kiwi\EshopBundle\Entity\Contingents\ProductRecommended')->findBy(array('product_id' => $product->getId()));
  436.         $ret = [];
  437.         foreach($recommended as $recommend) {
  438.             $ret[] = $this->getProductReturnArrayBlock($recommend->getProductRecommended(), $lang, []);
  439.         }
  441.         return $ret;
  442.     }
  444.     //public function getProduct
  446.     public function getProductParams($product_id) {
  447.         return $this->em->getRepository($this->repo_params)->findBy(array(
  448.             'product_id' => (int)$product_id
  449.         ));
  450.     }
  452.     public function getProductParam($product_id, $param_id) {
  453.         return $this->em->getRepository($this->repo_params)->findOneBy(array(
  454.             'product_id' => (int)$product_id,
  455.             'param_id' => (int)$param_id
  456.         ));
  457.     }
  459.     public function editHolderForm(int $holder_id, $request, $justCreateArticle = false){
  460.         $holder = $this->getHolder($holder_id);
  462.         $referer = false;
  463.         if(isset($_GET['ref'])) {
  464.             if($_GET['ref'] != '') {
  465.                 $referer = urldecode($_GET['ref']);
  466.             }
  467.         }
  469.         if(!$holder->getArticle()) {
  470.             $article = $this->article->createBlankArticle($this->languages->getLangEntry($holder->getName(), 'cz'));
  471.             $holder->setArticle($article);
  472.             $this->em->persist($holder);
  473.             $this->em->flush($holder);
  474.             $this->em->refresh($holder);
  475.         }
  477.         if($justCreateArticle) {
  478.             return true;
  479.         }
  481.         $article_forms = $this->article->getArticleUpdateForm($holder->getArticle(),$request,$referer);
  483.         $K = $this->controller->get('K');
  485.         return $this->controller->get('BL')->setContent($K->getRows(array(
  486.             $K->getPageHeader('Editace článku / '.$this->languages->getLangEntry($holder->getArticle()->getName(), 'cz')),
  487.             $K->getRow(array(
  488.                 $K->getBox(
  489.                     $K->LABEL_HIDE_BOX,
  490.                     11,
  491.                     $article_forms,
  492.                     'Editace článku'
  493.                 )
  494.             ),true)
  495.         )))->getLayoutResponse();
  496.     }
  498.     public function getProductForm($product_id = 0, $holder_id = 0) {
  500.         $is_product_update = false;
  502.         if($product_id >= 1) {
  503.             $product = $this->getProduct($product_id);
  504.             $is_product_update = true;
  505.         } else {
  506.             $product = new Product();
  507.             $web = $this->controller->get('web_handle')->getCurrentWeb();
  508.             $product->setEshop($web->getEshop());
  509.             $product->setIsHidden(false);
  510.             $product->setIsDeleted(false);
  511.             if($holder_id >= 1) {
  512.                 $product->setHolderId($holder_id);
  513.             }
  514.         }
  516.         $gallery = $this->getProductGallery($product);
  518.         if($is_product_update) {
  519.             if(!$product->getGallery())
  520.                 $product->setGallery($gallery);
  521.         } else {
  522.             $product->setGallery($gallery);
  523.         }
  525.         $form = $this->controller->get('form.factory')->createNamedBuilder('product_form', FormType::class, array());
  527.         $reflect = new \ReflectionClass(new $this->repo);
  528.         $tO = new Transformations\ProductFormTransformations();
  529.         $tO->setForm($form);
  530.         $tO->setFormData($product);
  531.         $tO->setController($this->controller);
  532.         $tO->setLanguagesHandle($this->languages);
  534.         foreach($reflect->getProperties() as $method) {
  535.             $method_name = 'fm'.ucfirst($method->name);
  537.             if(method_exists($tO, $method_name)) {
  538.                 $tO->$method_name($method->name);
  539.             } else {
  540.                 $tO->fmDefalut($method->name);
  541.             }
  542.         }
  544.         $form->add('product_id', HiddenType::class, array('data' => $product->getId()));
  545.         $form->add('ref', HiddenType::class, array('data' => $this->request->getRequestUri()));
  546.         $form->add('save', SubmitType::class, array('label' => 'Uložit / upravit'));
  548.         $form = $form->getForm();
  550.         $form->handleRequest($this->request);
  552.         if($form->isValid()) {
  553.             $post_params = (isset($_POST['params'])) ? $_POST['params'] : array();
  555.             $this->handleProductUpdate($product, $form->getData(), array_keys($_POST['product_category']), $post_params);
  557.             //remove gallery session persister
  558.             $session = new Session();
  559.             $session->remove('getProductGallery_freelink');
  561.             if($this->controller->get( 'kernel' )->getEnvironment() == 'dev') {
  562.                 Header("Location: /app_dev.php/kiwi/eshop/produkt/edit/".$product->getId());
  563.             } else {
  564.                 Header("Location: /kiwi/eshop/produkt/edit/".$product->getId());
  565.             }
  567.             exit();
  568.         }
  570.         $form_v = $form->createView();
  572.         //gallery folder
  573.         $tnObj = $this->controller->get('ad13_tree_navigation');
  574.         $tnObj->setRepository('\Kiwi\ImageGalleryBundle\Entity\ImageFolderTree');
  575.         $tnObj->setController($this->controller);
  576.         $tnObj->setRequest($this->request);
  577.         $tnObj->setLevel($gallery->getId());
  578.         $tnObj->setRefreshPath('kiwi_module_image_gallery_folder_level');
  579.         $tnObj->setUploadPath('kiwi_module_image_gallery_folder_upload');
  580.         $tnObj->setFileDownloadPath('kiwi_module_image_gallery_folder_download_file');
  583.         $K = $this->controller->get('K');
  584.         $languages_codes = $this->languages->getLanguagesCodes();
  586.         //Attachements
  587.         $attachements_row = null;
  588.         $recommended_row = null;
  589.         $holderproducts_row = null;
  590.         if($is_product_update) {
  591.             $attachements_holders = $this->controller->get('eshop_attachements_handle')->getAttachementsHolders();
  592.             $attachements = $this->attachementsHandle->getProductAttachements($product_id);
  594.             foreach($attachements_holders as &$ah) {
  595.                 $ah->current_file = null;
  597.                 foreach($attachements as $attachement) {
  598.                     if($ah->getId() == $attachement->getAttachmentId()) {
  599.                         $ah->current_file = $attachement->getFile();
  600.                         break;
  601.                     }
  602.                 }
  603.             }
  605.             $attachements_row = $K->getRow(array(
  606.                 $K->getTwigBox(
  607.                     $K->LABEL_HIDE_BOX,
  608.                     $K->WIDTH_FULL,
  609.                     'KiwiEshopBundle:Forms:product_attachments.html.twig',
  610.                     array(
  611.                         'referer' => '',
  612.                         'lang' => $this->languages->getDefaultLang(),
  613.                         'product_id' => $product->getId(),
  614.                         'attachements_holders' => $attachements_holders
  615.                     ),
  616.                     'Přílohy'
  617.                 )
  618.             ),false);
  620.             $form_recommended = $this->controller->get('form.factory')->createNamedBuilder('product_recommended_form', FormType::class, array());
  621.             $form_recommended->add('product_name', TextType::class);
  622.             $form_recommended->add('product_id', HiddenType::class);
  623.             $form_recommended->add('ref', HiddenType::class, array('data' => $this->request->getRequestUri()));
  624.             $form_recommended->add('save', SubmitType::class, array('label' => 'Uložit / upravit'));
  625.             $form_recommended = $form_recommended->getForm();
  627.             $form_recommended->handleRequest($this->request);
  629.             if($form_recommended->isValid()) {
  630.                 $post_params = (isset($_POST['params'])) ? $_POST['params'] : array();
  632.                 $recommended_obj = new ProductRecommended();
  633.                 $recommended_obj->setProduct($product);
  634.                 $recommended_obj->setProductRecommended(
  635.                     $this->getProduct($form_recommended->getData()['product_id'])
  636.                 );
  637.                 $this->em->persist($recommended_obj);
  638.                 $this->em->flush();
  640.                 Header("Location: ".$form_recommended->getData()['ref']."#recommended");
  641.                 exit();
  642.             }
  644.             $recommended_row = $K->getRow(array(
  645.                 $K->getTwigBox(
  646.                     $K->LABEL_HIDE_BOX,
  647.                     $K->WIDTH_FULL,
  648.                     'KiwiEshopBundle:Forms:product_recommended.html.twig',
  649.                     array(
  650.                         'form' => $form_recommended->createView(),
  651.                         'recommended' => $this->getRecommended($product),
  652.                         'product' => $product,
  653.                         'ref' => $this->request->getRequestUri()
  654.                     ),
  655.                     'Doporučené produkty'
  656.                 )
  657.             ),false);
  659.             if($product->getIsHolder()) {
  660.                 $search = $this->controller->get('search_handle');
  661.                 //->setRequest($request)
  662.                 $search->setFrom('Kiwi\EshopBundle\Entity\Product','p')
  663.                     ->addWhere(sprintf("p.holder_id = '%d'", $product->getId()))
  664.                     ->setOrderBy('p.sort_num', 'ASC')
  665.                     ->setRpp(100);
  667.                 $inholder_products = [];
  668.                 foreach ($search->getResult()['data'] as $inholder_product) {
  669.                     $inholder_products[] = $this->getProductReturnArrayBlock($inholder_product, 'cz', []);
  670.                 }
  672.                 $form_inproduct = $this->controller->get('form.factory')->createNamedBuilder('holder_inproducts_form', FormType::class, array());
  673.                 $form_inproduct->add('product_name', TextType::class);
  674.                 $form_inproduct->add('product_id', HiddenType::class);
  675.                 $form_inproduct->add('ref', HiddenType::class, array('data' => $this->request->getRequestUri()));
  676.                 $form_inproduct->add('save', SubmitType::class, array('label' => 'Uložit'));
  677.                 $form_inproduct = $form_inproduct->getForm();
  679.                 $form_inproduct->handleRequest($this->request);
  681.                 if($form_inproduct->isValid()) {
  682.                     $formdata = $this->request->get('holder_inproducts_form');
  683.                     $inproduct_id = (isset($formdata['product_id'])) ? (int)$formdata['product_id'] : 0;
  685.                     if($inproduct_id >= 1) {
  686.                         $inproduct = $this->getProduct($inproduct_id);
  688.                         $inproduct->setHolder($product);
  689.                         $this->em->persist($inproduct);
  690.                         $this->em->flush();
  691.                     }
  693.                     Header("Location: ".$formdata['ref']."#inholder_products");
  694.                     exit;
  695.                 }
  697.                 $holderproducts_row = $K->getRow(array(
  698.                     $K->getTwigBox(
  699.                         $K->LABEL_HIDE_BOX,
  700.                         $K->WIDTH_FULL,
  701.                         'KiwiEshopBundle:Forms:product_holderproducts.html.twig',
  702.                         array(
  703.                             'form' => $form_inproduct->createView(),
  704.                             'products' => $inholder_products,
  705.                             'ref' => $this->request->getRequestUri()
  706.                         ),
  707.                         /*
  708.                         array(
  709.                             'form' => $form_recommended->createView(),
  710.                             'recommended' => $this->getRecommended($product),
  711.                             'product' => $product,
  712.                             'ref' => $this->request->getRequestUri()
  713.                         ),
  714.                         */
  715.                         'Produkty v holderu'
  716.                     )
  717.                 ),false);
  718.             }
  719.         }
  721.         $inner_view = $K->getRows(array(
  722.             $K->getPageHeader('Vložení nového produktu'),
  724.             $K->getRow(array(
  725.                 $K->getTwigBox(
  726.                     $K->LABEL_HIDE_BOX,
  727.                     7,
  728.                     'KiwiEshopBundle:Forms:product_main.html.twig',
  729.                     array('form' => $form_v, 'languages' => $languages_codes),
  730.                     'Základní parametry produktu'
  731.                 ),
  732.                 $K->getTwigBox(
  733.                     $K->LABEL_HIDE_BOX,
  734.                     5,
  735.                     'KiwiEshopBundle:Forms:product_price.html.twig',
  736.                     array('form' => $form_v),
  737.                     'Cena'
  738.                 )
  739.             ),false),
  741.             $K->getRow(array(
  742.                 $K->getTwigBox(
  743.                     $K->LABEL_HIDE_BOX,
  744.                     8,
  745.                     'KiwiEshopBundle:Forms:product_categories.html.twig',
  746.                     array('data' => $this->eshopCategoriesHandle->getProductAssociationForm($product)),
  747.                     'Kategorie'
  748.                 ),
  750.                 $K->getTwigBox(
  751.                     $K->LABEL_HIDE_BOX,
  752.                     4,
  753.                     'KiwiEshopBundle:Forms:product_flags.html.twig',
  754.                     array('form' => $form_v),
  755.                     'Flagy'
  756.                 )
  757.             ),false),
  759.             $K->getRow(array(
  760.                 $K->getTwigBox(
  761.                     $K->LABEL_HIDE_BOX,
  762.                     12,
  763.                     'KiwiEshopBundle:Forms:product_params.html.twig',
  764.                     array('data' => $this->eshopParamsHandle->getProductParamsForm($product)),
  765.                     'Volitelné parametry'
  766.                 )
  767.             ),false),
  769.             $K->getRow(array(
  770.                 $K->getTwigBox(
  771.                     $K->LABEL_HIDE_BOX,
  772.                     12,
  773.                     'KiwiEshopBundle:Forms:product_description.html.twig',
  774.                     array('form' => $form_v, 'languages' => $languages_codes),
  775.                     'Hlavní popis'
  776.                 )
  777.             ),false),
  779.             $K->getRow(array(
  780.                 $K->getTwigBox(
  781.                     $K->LABEL_HIDE_BOX,
  782.                     12,
  783.                     'KiwiEshopBundle:Forms:product_action.html.twig',
  784.                     array('form' => $form_v, 'languages' => $languages_codes),
  785.                     'Akce'
  786.                 )
  787.             ),false),
  789.             $K->getRow(array(
  790.                 $K->getTwigBox(
  791.                     $K->LABEL_HIDE_BOX,
  792.                     12,
  793.                     'KiwiEshopBundle:Forms:product_holder.html.twig',
  794.                     array('form' => $form_v, 'languages' => $languages_codes, 'product' => $product),
  795.                     'Vícenásobný produkt'
  796.                 )
  797.             ),true),
  799.             $K->getRow(array(
  800.                 $K->getTwigBox(
  801.                     $K->LABEL_HIDE_BOX,
  802.                     12,
  803.                     'KiwiEshopBundle:Forms:product_submit.html.twig',
  804.                     array('form' => $form_v),
  805.                     'Uložení / úprava produktu'
  806.                 )
  807.             ),true),
  809.             $K->getRow(array(
  811.                 $K->getBox(
  812.                     $K->LABEL_HIDE_BOX,
  813.                     $K->WIDTH_FULL,
  814.                     '<div class="tree_navigator gallery_sortable">'.$this->controller->get('image_gallery_handle')->setRefPath($_SERVER['REQUEST_URI'])->disablePlaceholder()->getFolderBrowser($gallery->getId()).'</div>',
  815.                     'Galerie'
  816.                 )
  818.             ),false),
  820.             $K->getRow(array(
  822.                 $K->getBox(
  823.                     $K->LABEL_HIDE_BOX,
  824.                     $K->WIDTH_THIRD,
  825.                     $tnObj->getUploader(array('{title : "Image files", extensions : "jpg,gif,png"}')),
  826.                     'Upload souborů do galerie'
  827.                 ),
  829.                 $K->getBox(
  830.                     $K->LABEL_HIDE_BOX,
  831.                     $K->WIDTH_THIRD,
  832.                     $tnObj->getFileDownloader(),
  833.                     'Zdroje'
  834.                 )
  836.             ),false),
  838.             $attachements_row,
  840.             $recommended_row,
  842.             $holderproducts_row
  843.         ));
  845.         $edit_canvas = $this->controller->get('templating')->render('KiwiEshopBundle:Forms:product_form_holder.html.twig',array(
  846.             'form' => $form_v,
  847.             'content' => '<script src="\bundles\Kiwi\js\plugins\tinymce\js\tinymce\tinymce.min.js"></script>'.$inner_view
  848.         ));
  850.         return $this->controller->get('BL')
  851.                                 ->setContent($edit_canvas,true,true)
  852.                                 ->getLayoutResponse();
  853.     }
  856.     public function dropRecommendedProduct($product_id, $recommended_product_id) {
  857.         $recommended_ref = $this->em->getRepository('Kiwi\EshopBundle\Entity\Contingents\ProductRecommended')->findOneBy(array(
  858.             'product_id' => $product_id,
  859.             'product_recommended_id' => $recommended_product_id
  860.         ));
  861.         $this->em->remove($recommended_ref);
  862.         $this->em->flush();
  863.     }
  865.     public function removeProductHolder($product_id) {
  866.         $product = $this->getProduct($product_id);
  867.         $product->setHolder(null);
  868.         $this->em->persist($product);
  869.         $this->em->flush();
  870.     }
  872.     public function unDropProduct($product_id) {
  873.         $product = $this->getProduct($product_id);
  874.         $product->setIsDeleted(false);
  876.         $this->em->persist($product);
  877.         $this->em->flush();
  878.     }
  880.     public function dropProduct($product_id) {
  881.         $product = $this->getProduct($product_id);
  882.         $product->setIsDeleted(true);
  884.         $this->em->persist($product);
  885.         $this->em->flush();
  886.     }
  888.     public function unInvisibleProduct($product_id) {
  889.         $product = $this->getProduct($product_id);
  890.         $product->setIsHidden(false);
  892.         $this->em->persist($product);
  893.         $this->em->flush();
  894.     }
  896.     public function invisibleProduct($product_id) {
  897.         $product = $this->getProduct($product_id);
  898.         $product->setIsHidden(true);
  900.         $this->em->persist($product);
  901.         $this->em->flush();
  902.     }
  904.     public function getProductGallery(\Kiwi\EshopBundle\Entity\Product $product, $enable_sessions = true) {
  905.         $gallery = $product->getGallery();
  907.         if(!$gallery) {
  909.             //if persist in session, return them instead of create new one
  910.             if($enable_sessions) {
  911.                 $session = new Session();
  912.                 if($session->get('getProductGallery_freelink'))
  913.                     return $this->imageGalleryHandle->getFolder($session->get('getProductGallery_freelink'));
  914.             }
  916.             //find if root folder exists
  917.             $root_folder = null;
  918.             foreach($this->imageGalleryHandle->getFolderByName($this->root_image_folder_name) as $folder) {
  919.                 if(!$folder->getParentRow()) {
  920.                     $root_folder = $folder;
  921.                     break;
  922.                 }
  923.             }
  925.             //create if not
  926.             if(!$root_folder) {
  927.                 $root_folder = new ImageFolderTree();
  928.                 $root_folder->setName($this->root_image_folder_name);
  929.                 $root_folder->setPreventChanges(true);
  930.                 $root_folder->setSystemFolder(true);
  931.                 $root_folder->setWeb($this->controller->get('web_handle')->getCurrentWeb());
  933.                 $this->em->persist($root_folder);
  934.                 $this->em->flush();
  935.             }
  937.             $gallery = new ImageFolderTree();
  938.             $gallery->setName($this->root_image_sub_folder_name.$product->getId());
  939.             $gallery->setParentRow($root_folder);
  940.             $gallery->setPreventChanges(true);
  941.             $gallery->setSystemFolder(true);
  942.             //$gallery->setWeb($this->controller->get('web_handle')->getCurrentWeb());
  943.             $gallery->setWeb($this->controller->get('web_handle')->getWebByEshopId($product->getEshop()->getId()));
  945.             $this->em->persist($gallery);
  946.             $this->em->flush();
  948.             if($enable_sessions)
  949.                 $session->set('getProductGallery_freelink',$gallery->getId());
  950.         }
  952.         return $gallery;
  953.     }
  955.     private function getProductCategories(\Kiwi\EshopBundle\Entity\Product $product) {
  957.     }
  959.     private function getSetMethodName($variable_name) {
  960.         $get_method = str_replace('_',' ',$variable_name);
  961.         $get_method = ucwords($get_method);
  962.         $get_method = str_replace(' ','',$get_method);
  963.         return 'set'.$get_method;
  964.     }
  966.     private function getGetMethodName($variable_name) {
  967.         $get_method = str_replace('_',' ',$variable_name);
  968.         $get_method = ucwords($get_method);
  969.         $get_method = str_replace(' ','',$get_method);
  970.         return 'get'.$get_method;
  971.     }
  973.     //partialy frontend methods
  975.     private function findNotificationEmails(\Kiwi\EshopBundle\Entity\KategorieTree $kategorieTree,$be_verbose){
  976.         $ret = '';
  978.         //$kategorieTree = $this->eshopCacheHandle->getHydrated($kategorieTree);
  980.         if($be_verbose) {
  981.             echo 'looking in '.$kategorieTree->getId().'/'.$kategorieTree->getInfoEmails().'<br>';
  982.         }
  984.         if($kategorieTree->getInfoEmails()) {
  985.             if($kategorieTree->getInfoEmails() != '') {
  986.                 $ret = $kategorieTree->getInfoEmails();
  987.             } else {
  988.                 $parentRow = $this->eshopCacheHandle->getHydrated($kategorieTree->getParentRow());
  989.                 if($parentRow) {
  990.                     $ret = $this->findNotificationEmails($parentRow,$be_verbose);
  991.                 }
  992.             }
  993.         } else {
  994.             $parentRow = $this->eshopCacheHandle->getHydrated($kategorieTree->getParentRow());
  995.             if($parentRow) {
  996.                 $ret = $this->findNotificationEmails($parentRow,$be_verbose);
  997.             }
  998.         }
  1000.         return $ret;
  1001.     }
  1003.     public function findProduct($lang, $product_id) {
  1004.         $product = $this->getProduct($product_id);
  1006.         //kategorie produktu
  1007.         $product_categories = array();
  1008.         $product_order_notifications_emails = array();
  1009.         foreach($this->controller->get('eshop_categories_handle')->getProductCategories($product) as $product_category) {
  1010.             $product_categories[] = $product_category->getCategoryId();
  1012.             $category = $this->eshopCacheHandle->getHydrated($product_category->getCategory());
  1014.             $emails_raw = $category->getInfoEmails();
  1015.             $be_verbose = false;
  1016.             if($emails_raw == '')
  1017.                 $emails_raw = $this->findNotificationEmails($category,$be_verbose);
  1020.             foreach(explode(',',$emails_raw) as $email) {
  1021.                 if($email != '')
  1022.                     $product_order_notifications_emails[] = str_replace(' ','',$email);
  1023.             }
  1025.             $product_order_notifications_emails = array_unique($product_order_notifications_emails);
  1026.         }
  1028.         //siblings getter
  1029.         $siblings = array();
  1030.         if($product->getHolder()) {
  1031.             foreach($this->em->getRepository($this->repo)->findBy(array('holder_id' => $product->getHolder()->getId())) as $sibling_product) {
  1032.                 if($sibling_product->getStockAlt() >= 1) {
  1033.                     if($sibling_product->getId() != $product->getId())
  1034.                         $siblings[] = $this->getProductReturnArrayBlock($sibling_product,$lang,array());
  1035.                 }
  1036.             }
  1037.         }
  1039.         //similars getter
  1040.         $similars = array();
  1041.         if(count($product_categories) >= 1) {
  1042.             $qb_similar = $this->em->createQueryBuilder();
  1043.             $qb_similar->select('p')
  1044.                 ->from($this->repo_categories, 'c')
  1045.                 ->leftJoin($this->repo, 'p', 'WITH', 'p.id = c.product_id')
  1046.                 ->where('p.is_deleted = 0')
  1047.                 ->andWhere('p.eshop_id = '.$product->getEshopId())
  1048.                 ->andWhere('p.stock_alt >= 1');
  1049.             if($product->getHolder())
  1050.                 $qb_similar->andWhere('p.holder_id != '.$product->getHolder()->getId());
  1051.             $qb_similar->andWhere('c.category_id IN ('.implode(",", $product_categories).')')
  1052.                 ->orderBy('p.id', 'DESC')
  1053.                 //->groupBy('p.holder_id')
  1054.                 ->setMaxResults(10);
  1056.             foreach($qb_similar->getQuery()->getResult() as $similar_product) {
  1057.                 if($similar_product->getId() != $product->getId())
  1058.                     $similars[] = $this->getProductReturnArrayBlock($similar_product,$lang,array());
  1059.             }
  1060.         }
  1063.         return $this->getProductReturnArrayBlock($product,$lang,$product_categories, $siblings, $similars);
  1064.     }
  1066.     public function findProducts($lang, $limit = array(), $eshop = 1, $group_by_holder = false, $minimal_stock = 0) {
  1067.         $this->logClean();
  1069.         /*
  1070.         $list_in_eshops = array($this->getEshop()->getId());
  1071.         $user = $this->eshopUsersHandle->getCurrentUser();
  1072.         if($user) {
  1073.             $list_in_eshops = array();
  1074.             foreach($this->eshopUsersHandle->getUsersEshops($user->getId(),true) as $a_eshop) {
  1075.                 $list_in_eshops[] = $a_eshop['id'];
  1076.             }
  1077.         }
  1078.         */
  1080.         /*
  1081.         $data = $this->em->getRepository($this->repo)->findBy(
  1082.             array(),
  1083.             array(),
  1084.             99000,
  1085.             0
  1086.         );
  1087.         */
  1089.         $eshop = ($eshop >= 1) ? $eshop : 1;
  1090.         $group_by = ($group_by_holder) ? 'p.holder_id' : 'p.id';
  1093.         $results_pp = 20;
  1094.         $results_page = 1;
  1096.         if(isset($limit['results_page'])) {
  1097.             if($limit['results_page'] >= 2) {
  1098.                 $results_page = (int)$limit['results_page'];
  1099.             }
  1100.         }
  1102.         if(isset($limit['results_per_page'])) {
  1103.             if($limit['results_per_page'] >= 1) {
  1104.                 $results_pp = (int)$limit['results_per_page'];
  1105.             }
  1106.         }
  1108.         $dynamic_params_grouped = array();
  1109.         if(isset($limit['dynamic-params'])) {
  1110.             if(is_array($limit['dynamic-params'])) {
  1111.                 //group by category
  1112.                 foreach($limit['dynamic-params'] as $dynamic_param) {
  1113.                     $_dynamic_param = explode('@',$dynamic_param);
  1114.                     $dynamic_params_grouped[$_dynamic_param[0]][] = $_dynamic_param[1];
  1115.                 }
  1116.             }
  1117.         }
  1119.         $qb = $this->em->createQueryBuilder();
  1120.         $qb->select('p')
  1121.            ->from($this->repo_categories, 'c')
  1122.            ->leftJoin($this->repo, 'p', 'WITH', 'p.id = c.product_id')
  1123.            ->leftJoin($this->repo_params, 'params', 'WITH', 'params.product_id = p.id');
  1124.            //->leftJoin($this->repo_params, 'params', 'WITH', 'params.product_id = p.id AND params.param_id = 8')
  1126.         if(isset($limit['dynamic-params'])) {
  1127.             if(is_array($limit['dynamic-params'])) {
  1128.                 foreach($dynamic_params_grouped as $group_id => $group_data) {
  1129.                     $qb->leftJoin($this->repo_params, 'params'.$group_id, 'WITH', 'params'.$group_id.'.product_id = p.id');
  1130.                 }
  1131.             }
  1132.         }
  1134.         $qb->where('p.is_deleted = 0')
  1135.            //->andwhere('p.eshop_id = '.$this->getEshop()->getId())
  1136.             //->add('where', $qb->expr()->in('p.eshop_id', $list_in_eshops))
  1137.             //->add('where', 'p.eshop_id = '.$eshop)
  1138.             ->andWhere('p.eshop_id = '.$eshop)
  1139.             ->andWhere('p.stock_alt >= '.$minimal_stock)
  1140.            //->orderBy('p.price_with_vat', 'DESC');
  1141.            ->orderBy('p.id', 'DESC')
  1142.            ->groupBy($group_by);
  1144.         //params.param_value LIKE '%".$limit['fulltext_search']."%' OR
  1145.         if(isset($limit['fulltext_search'])) {
  1146.             if($limit['fulltext_search'] != '') {
  1147.                 /*
  1148.                 $xml_part = '\'<?xml version="1.0" encoding="utf-8" ?>%<cz><![CDATA[%'.strtolower($limit['fulltext_search']).'%]]></cz>%</data>\'';
  1149.                 */
  1150.                 $qb->andWhere("(
  1151.                     p.code LIKE '%".$limit['fulltext_search']."' OR
  1152.                     p.name LIKE '%".$limit['fulltext_search']."%' OR
  1153.                     p.name_alt_1 LIKE '%".$limit['fulltext_search']."%' OR
  1154.                     p.name_alt_2 LIKE '%".$limit['fulltext_search']."%'
  1155.                 )");
  1156.                 /*
  1157.                 params.param_value LIKE '%".$limit['fulltext_search']."%' OR
  1158.                 p.code LIKE '%".$limit['fulltext_search']."%' OR
  1159.                 p.name LIKE $xml_part OR
  1160.                 p.name_alt_1 LIKE $xml_part OR
  1161.                 p.name_alt_2 LIKE $xml_part
  1162.                 */
  1163.             }
  1164.         }
  1166.         if(isset($limit['category'])) {
  1167.             if(is_array($limit['category'])) {
  1168.                 $categories = array();
  1169.                 foreach($limit['category'] as $limit_category) {
  1170.                     if($limit_category >= 1) {
  1171.                         $categories[] = $limit_category;
  1172.                         $subcategories = $this->controller->get('eshop_categories_handle')->getCategories($limit_category, true);
  1174.                         if(is_array($subcategories))
  1175.                             $categories = array_merge($categories,$subcategories);
  1176.                     }
  1177.                 }
  1179.                 if(count($categories) >= 1)
  1180.                     $qb->andWhere('c.category_id IN ('.implode(",", $categories).')');
  1181.             }
  1182.         }
  1184.         if(isset($limit['producer'])) {
  1185.             if(is_array($limit['producer'])) {
  1186.                 $qb->andWhere('p.producer_id IN ('.implode(",", $limit['producer']).')');
  1187.             }
  1188.         }
  1190.         if(isset($limit['dynamic-params'])) {
  1191.             if(is_array($limit['dynamic-params'])) {
  1192.                 //make groups independent wheres
  1193.                 foreach($dynamic_params_grouped as $group_id => $group_data) {
  1194.                     $dynamic_params_likes = '';
  1196.                     foreach($group_data as $agd) {
  1197.                         if(is_numeric($agd)) {
  1198.                             $dynamic_params_likes .= "params".$group_id.".param_value LIKE '%i:".addslashes($agd)."%' OR ";
  1199.                         } else {
  1200.                             $dynamic_params_likes .= "params".$group_id.".param_value = '".base64_decode($agd)."' OR ";
  1201.                         }
  1202.                     }
  1204.                     if($dynamic_params_likes != '') {
  1205.                         $dynamic_params_likes = substr($dynamic_params_likes,0,-4);
  1206.                         $qb->andWhere("($dynamic_params_likes)");
  1207.                     }
  1208.                 }
  1209.             }
  1210.         }
  1212.         if(isset($limit['holder'])) {
  1213.             if(is_numeric($limit['holder'])) {
  1214.                 $qb->andWhere('p.holder_id = '.$limit['holder']);
  1215.             }
  1216.         }
  1218.         if(isset($limit['not-holder'])) {
  1219.             $qb->andWhere('p.is_holder = 0');
  1220.         }
  1222.         if(isset($limit['not-holder-member'])) {
  1223.             $qb->andWhere('p.holder_id IS NULL');
  1224.         }
  1226.         if(isset($limit['action'])) {
  1227.             if(is_numeric($limit['action'])) {
  1228.                 $qb->andWhere('p.is_action = '.$limit['action']);
  1229.             }
  1230.         }
  1232.         $qb_nolimit = clone $qb;
  1233.         $qb_forcount = clone $qb;
  1235.         if(isset($limit['letter'])) {
  1236.             if($limit['letter'] != '') {
  1237.                 $qb->andWhere("p.name_letter = '".$limit['letter']."'");
  1238.             }
  1239.         }
  1241.         //$qb->groupBy('p.holder_id');
  1243.         $qb->setFirstResult(($results_page*$results_pp)-$results_pp)->setMaxResults($results_pp+1);
  1245.         $query = $qb->getQuery();
  1247.         //echo $query->getSQL();
  1248.         $this->logState($query->getSQL());
  1249.         //exit;
  1250.         $data = $query->getResult();
  1252.         $truncateCzech = function($text){
  1253.             $prevodni_tabulka = Array(
  1254.                 'ä'=>'a',
  1255.                 'Ä'=>'A',
  1256.                 'á'=>'a',
  1257.                 'Á'=>'A',
  1258.                 'à'=>'a',
  1259.                 'À'=>'A',
  1260.                 'ã'=>'a',
  1261.                 'Ã'=>'A',
  1262.                 'â'=>'a',
  1263.                 'Â'=>'A',
  1264.                 'č'=>'c',
  1265.                 'Č'=>'C',
  1266.                 'ć'=>'c',
  1267.                 'Ć'=>'C',
  1268.                 'ď'=>'d',
  1269.                 'Ď'=>'D',
  1270.                 'ě'=>'e',
  1271.                 'Ě'=>'E',
  1272.                 'é'=>'e',
  1273.                 'É'=>'E',
  1274.                 'ë'=>'e',
  1275.                 'Ë'=>'E',
  1276.                 'è'=>'e',
  1277.                 'È'=>'E',
  1278.                 'ê'=>'e',
  1279.                 'Ê'=>'E',
  1280.                 'í'=>'i',
  1281.                 'Í'=>'I',
  1282.                 'ï'=>'i',
  1283.                 'Ï'=>'I',
  1284.                 'ì'=>'i',
  1285.                 'Ì'=>'I',
  1286.                 'î'=>'i',
  1287.                 'Î'=>'I',
  1288.                 'ľ'=>'l',
  1289.                 'Ľ'=>'L',
  1290.                 'ĺ'=>'l',
  1291.                 'Ĺ'=>'L',
  1292.                 'ń'=>'n',
  1293.                 'Ń'=>'N',
  1294.                 'ň'=>'n',
  1295.                 'Ň'=>'N',
  1296.                 'ñ'=>'n',
  1297.                 'Ñ'=>'N',
  1298.                 'ó'=>'o',
  1299.                 'Ó'=>'O',
  1300.                 'ö'=>'o',
  1301.                 'Ö'=>'O',
  1302.                 'ô'=>'o',
  1303.                 'Ô'=>'O',
  1304.                 'ò'=>'o',
  1305.                 'Ò'=>'O',
  1306.                 'õ'=>'o',
  1307.                 'Õ'=>'O',
  1308.                 'ő'=>'o',
  1309.                 'Ő'=>'O',
  1310.                 'ř'=>'r',
  1311.                 'Ř'=>'R',
  1312.                 'ŕ'=>'r',
  1313.                 'Ŕ'=>'R',
  1314.                 'š'=>'s',
  1315.                 'Š'=>'S',
  1316.                 'ś'=>'s',
  1317.                 'Ś'=>'S',
  1318.                 'ť'=>'t',
  1319.                 'Ť'=>'T',
  1320.                 'ú'=>'u',
  1321.                 'Ú'=>'U',
  1322.                 'ů'=>'u',
  1323.                 'Ů'=>'U',
  1324.                 'ü'=>'u',
  1325.                 'Ü'=>'U',
  1326.                 'ù'=>'u',
  1327.                 'Ù'=>'U',
  1328.                 'ũ'=>'u',
  1329.                 'Ũ'=>'U',
  1330.                 'û'=>'u',
  1331.                 'Û'=>'U',
  1332.                 'ý'=>'y',
  1333.                 'Ý'=>'Y',
  1334.                 'ž'=>'z',
  1335.                 'Ž'=>'Z',
  1336.                 'ź'=>'z',
  1337.                 'Ź'=>'Z'
  1338.             );
  1340.             return strtr($text, $prevodni_tabulka);
  1341.         };
  1343.         $ret = array();
  1344.         $ret_nofilter = array();
  1345.         $ret_nolettermatter = array();
  1346.         foreach($data as $product) {
  1347.             $pass_product = true;
  1348.             $pass_product_by_category = true;
  1349.             $pass_product_without_letter_matter = true;
  1351.             //$a_name = $this->languages->getLangEntry($product->getName(),$lang);
  1353.             //kategorie produktu
  1354.             $product_categories = array();
  1355.             $product_order_notifications_emails = array();
  1356.             foreach($this->controller->get('eshop_categories_handle')->getProductCategories($product) as $product_category) {
  1357.                 $product_categories[] = $product_category->getCategoryId();
  1359.                 $category = $this->eshopCacheHandle->getHydrated($product_category->getCategory());
  1361.                 $emails_raw = $category->getInfoEmails();
  1362.                 $be_verbose = false;
  1363.                 if($emails_raw == '')
  1364.                     $emails_raw = $this->findNotificationEmails($category,$be_verbose);
  1367.                 foreach(explode(',',$emails_raw) as $email) {
  1368.                     if($email != '')
  1369.                         $product_order_notifications_emails[] = str_replace(' ','',$email);
  1370.                 }
  1372.                 $product_order_notifications_emails = array_unique($product_order_notifications_emails);
  1373.             }
  1375.             //FILTR -- ceny
  1376.             if(isset($limit['price_range'])) {
  1377.                 if(is_array($limit['price_range'])) {
  1378.                     $a_price = $product->getPrice();
  1379.                     if($a_price['price_with_vat'] >= $limit['price_range'][0] && $a_price['price_with_vat'] <= $limit['price_range'][1]) {} else {
  1380.                         $pass_product = false;
  1381.                         $pass_product_without_letter_matter = false;
  1382.                     }
  1383.                 }
  1384.             }
  1386.             $productArrayBlock = $this->getProductReturnArrayBlock($product,$lang,$product_categories);
  1388.             //append notifications emails by theirs categories
  1389.             $productArrayBlock['notifications_emails'] = $product_order_notifications_emails;
  1391.             if($pass_product) {
  1392.                 $ret[] = $productArrayBlock;
  1393.             }
  1394.             if($pass_product_by_category) {
  1395.                 $ret_nofilter[] = $productArrayBlock;
  1396.             }
  1397.             if($pass_product_without_letter_matter) {
  1398.                 $ret_nolettermatter[] = $productArrayBlock;
  1399.             }
  1400.         }
  1402.         $sort_name = function($a,$b){
  1403.             return strcmp($a["name"], $b["name"]);
  1404.         };
  1406.         usort($ret,$sort_name);
  1407.         uasort($ret_nofilter,$sort_name);
  1408.         uasort($ret_nolettermatter,$sort_name);
  1410.         $ret = array_values($ret);
  1411.         $ret_nofilter = array_values($ret_nofilter);
  1413.         //echo count($qb_forcount->getQuery()->getResult());
  1414.         //exit();
  1416.         return array(
  1417.             'filtered' => array_slice($ret,0,$results_pp),
  1418.             'nofilter' => $ret_nofilter,
  1419.             'limit' => $limit,
  1420.             'results_page' => $results_page,
  1421.             'has_more_results' => (count($ret) > $results_pp) ? true : false,
  1422.             'total_results' => count($qb_forcount->getQuery()->getResult()),
  1423.             'q' => $qb->getDQL()
  1424.         );
  1425.     }
  1427.     public function getProductReturnArrayBlock(\Kiwi\EshopBundle\Entity\Product $product, $lang, $product_categories, $siblings = array(), $similars = array()) {
  1428.         //$cache = $this->eshopCacheHandle->setCacheKey('farline-eshop-product-'.$lang.'-'.$product->getId().'-compiled');
  1430.         //if($cache->isKeySet()) {
  1431.         $cache = false;
  1432.         if($cache) {
  1433.             return $cache->getData();
  1434.         } else {
  1435.             $images = array();
  1436.             $images_data = $this->getProductImages($product, $lang);
  1437.             $images_helper = $this->controller->get('image_twig_extension');
  1438.             $stockObj = $this->controller->get('eshop_stock_handle');
  1440.             foreach($images_data as $image) {
  1441.                 $images[] = array(
  1442.                     'id' => $image['id'],
  1443.                     'label' => $image['label'],
  1444.                     'list' => $image['id'],
  1445.                     'full' => $images_helper->imageCutFunction($image['id'],670,0),
  1446.                     'maxi' => $images_helper->imageCutFunction($image['id'],1920,0)
  1447.                 );
  1448.             }
  1450.             $attachments = array();
  1451.             foreach($this->attachementsHandle->getProductAttachements($product->getId()) as $attachement_row) {
  1452.                 $attachments[] = array(
  1453.                     'name' => $this->languages->getLangEntry($attachement_row->getAttachment()->getName(),$lang),
  1454.                     'link' => '/dt/'.$attachement_row->getFile()->getHashName().'.'.$attachement_row->getFile()->getExtension(),
  1455.                     'extension' => $attachement_row->getFile()->getExtension()
  1456.                 );
  1457.             }
  1459.             $main_image = $this->no_image;
  1460.             if(isset($images[0]))
  1461.                 $main_image = $images[0]['list'];
  1463.             $main_product_image = $this->no_image;
  1464.             if(isset($images[0]))
  1465.                 $main_product_image = $images[0]['full'];
  1467.             $unit = false;
  1468.             if($product->getUnit()) {
  1469.                 $unit = array(
  1470.                     'name' => $this->languages->getLangEntry($product->getUnit()->getName(),$lang),
  1471.                     'code' => $product->getUnit()->getCode(),
  1472.                 );
  1473.             }
  1475.             $currency = false;
  1476.             if($product->getCurrency()) {
  1477.                 $currency = array(
  1478.                     'name' => $this->languages->getLangEntry($product->getCurrency()->getName(),$lang),
  1479.                     'code' => $product->getCurrency()->getCode(),
  1480.                 );
  1481.             }
  1483.             $producer = false;
  1484.             if($product->getProducer()) {
  1485.                 $image = '';
  1486.                 $image2 = '';
  1488.                 if($product->getProducer()->getImage())
  1489.                     $image = '/ds/orig/'.$product->getProducer()->getImage()->getName().'.'.$product->getProducer()->getImage()->getExtension();
  1491.                 if($product->getProducer()->getImage2())
  1492.                     $image2 = '/ds/orig/'.$product->getProducer()->getImage2()->getName().'.'.$product->getProducer()->getImage2()->getExtension();
  1494.                 $eshop_producers_handle = $this->controller->get('eshop_producers_handle');
  1496.                 $producer = array(
  1497.                     'id' => $product->getProducer()->getId(),
  1498.                     'name' => $this->languages->getLangEntry($product->getProducer()->getName(),$lang),
  1499.                     'image' => $image,
  1500.                     'image2' => $image2,
  1501.                     'full_link' => $eshop_producers_handle->getProducerLink($product->getProducer(), $lang)
  1502.                 );
  1503.             }
  1505.             $master_category = array(
  1506.                 'id' => 0,
  1507.                 'name' => null,
  1508.                 'title_name' => null
  1509.             );
  1510.             $master_category_data = $this->eshopCategoriesHandle->getProductTopCategory($product);
  1511.             if($master_category_data) {
  1512.                 $master_category['id'] = $master_category_data->getId();
  1513.                 $master_category['name'] = $master_category_data->getName();
  1514.                 $master_category['title_name'] = $master_category_data->getTitle();
  1515.             }
  1517.             //return $cache->setData(
  1518.                 return array(
  1519.                     'id' => $product->getId(),
  1520.                     'code' => $product->getCode(),
  1521.                     'name' => $this->getProductName($product, $lang),
  1522.                     //'name_holder' => $this->languages->getLangEntry($product->getHolder()->getArticle()->getName(), $lang),
  1523.                     'name_alt_1' => $this->languages->getLangEntry($product->getNameAlt1(), $lang),
  1524.                     'name_alt_2' => $this->languages->getLangEntry($product->getNameAlt2(), $lang),
  1525.                     'description' => str_replace("\n",'%NEW-LINE%',$this->languages->getLangEntry($product->getDescription(), $lang)),
  1526.                     'price' => $product->getPrice(),
  1527.                     'quantity_in_package' => $product->getQuantityInPackage(),
  1528.                     'main_image' => $main_image,
  1529.                     'main_product_image' => $main_product_image,
  1530.                     'unit' => $unit,
  1531.                     'currency' => $currency,
  1532.                     'producer' => $producer,
  1533.                     'categories' => $product_categories,
  1534.                     'is_action' => $product->getIsAction(),
  1535.                     'action_text' => $this->languages->getLangEntry($product->getActionText(), $lang),
  1536.                     'is_new' => $product->getIsNew(),
  1537.                     'is_tip' => $product->getIsTip(),
  1538.                     'is_selected' => false,
  1539.                     'images' => $images,
  1540.                     'params' => $this->eshopParamsHandle->getParamsCollection($lang, $product, true, true),
  1541.                     'params_entity' => $this->eshopParamsHandle->getParamsCollection($lang, $product, true, true, true),
  1542.                     'params_full' => $this->eshopParamsHandle->getParamsCollection($lang, $product, true, false),
  1543.                     'attachments' => $attachments,
  1544.                     'stock' => ($product->getStockShow()) ? $stockObj->getStock($product->getId())['stock'] : false,
  1545.                     'siblings' => $siblings,
  1546.                     'similars' => $similars,
  1547.                     'detail_url' => $this->getProductUrl($product, 0, $lang),
  1548.                     //'detail_url' => $this->getHolderUrl($product->getHolder(),$lang).'/'.$product->getCode(),
  1549.                     'master_category' => $master_category,
  1550.                     'holder' => $product->getHolder(),
  1551.                     'is_holder' => $product->getIsHolder()
  1552.                 );
  1553.             //);
  1554.         }
  1555.     }
  1557.     public function getFinder($lang, $limit = array(), $nofilter_products = array()) {
  1558.         //fulltext_search
  1559.         $fulltext_search = '';
  1560.         if(isset($limit['fulltext_search'])) {
  1561.             $fulltext_search = $limit['fulltext_search'];
  1562.         }
  1564.         return array(
  1565.             'fulltext_search' => array('actual' => $fulltext_search),
  1566.             'dynamic_model' => $this->eshopParamsHandle->getParamsCollection($lang)
  1567.         );
  1568.     }
  1570.     public function getFinderFull($lang, $current_products, $limit = array()) {
  1571.         //price range
  1572.         $min_product_price = 0;
  1573.         $max_product_price = 0;
  1575.         foreach($current_products as $product) {
  1576.             $a_price = $product['price'];
  1577.             if($min_product_price > $a_price['price_with_vat'])
  1578.                 $min_product_price = $a_price['price_with_vat'];
  1579.             if($max_product_price < $a_price['price_with_vat'])
  1580.                 $max_product_price = $a_price['price_with_vat'];
  1581.         }
  1583.         $a_price_from = $min_product_price;
  1584.         $a_price_to = $max_product_price;
  1585.         if(isset($limit['price_range'])) {
  1586.             if(is_array($limit['price_range'])) {
  1587.                 $a_price_from = $limit['price_range'][0];
  1588.                 $a_price_to = $limit['price_range'][1];
  1589.             }
  1590.         }
  1592.         //fulltext_search
  1593.         $fulltext_search = '';
  1594.         if(isset($limit['fulltext_search'])) {
  1595.             $fulltext_search = $limit['fulltext_search'];
  1596.         }
  1600.         return array(
  1601.             'price_range' => array('actual' => array($a_price_from,$a_price_to), 'data' => array($min_product_price,$max_product_price)),
  1602.             'fulltext_search' => array('actual' => $fulltext_search),
  1603.             'dynamic_model' => $this->eshopParamsHandle->getParamsCollection($lang)
  1604.         );
  1605.     }
  1607.     public function getFirstLetter($a_name){
  1608.         $a_name_low = strtolower($a_name);
  1609.         $a_name_letter = '';
  1611.         if(isset($a_name_low[0])) {
  1612.             $a_name_letter = $a_name_low[0];
  1613.             if(!$this->isLetter($a_name_letter)) {
  1614.                 for($i = 0; $i < strlen($a_name_low); $i++) {
  1615.                     if($i >= 1) {
  1616.                         $a_name_letter = $a_name_low[$i];
  1618.                         if($this->isLetter($a_name_letter))
  1619.                             break;
  1620.                     }
  1621.                 }
  1622.             }
  1623.         }
  1625.         return $a_name_letter;
  1626.     }
  1628.     public function getProductQrCode($product_id) {
  1629.         require(dirname(__DIR__).'/Lib/phpqrcode/qrlib.php');
  1631.         $product = $this->getProduct($product_id);
  1632.         if(!$product)
  1633.             return false;
  1635.         $write = sprintf($this->qr_url_pattern,$product->getCode());
  1637.         $img_path = dirname(__DIR__).'/tmp/qrcode_'.$product_id.'_'.md5($write).'.png';
  1638.         if(file_exists($img_path))
  1639.             return $img_path;
  1641.         \QRcode::png($write, $img_path, 'H', 6, 2);
  1643.         return $img_path;
  1644.     }
  1646.     public function getEshopInitParams($config) {
  1647.         $uri = explode('?',str_replace('/app_dev.php','',$_SERVER['REQUEST_URI'])); $uri = $uri[0];
  1648.         $deep = count(explode('/',$uri))-2;
  1649.         //$deep = $uri;
  1650.         $request_type = 'category';
  1651.         //$category = null;
  1652.         $images_helper = $this->controller->get('image_twig_extension');
  1654.         $ret = array(
  1655.             'product' => null,
  1656.             'products' => null,
  1657.             'category' => array('deep' => $deep, 'category' => null, 'subcategories' => null),
  1658.             'request_type' => $request_type
  1659.         );
  1661.         $category = $this->eshopCategoriesHandle->getCategoryBySeoName(substr(str_replace('/app_dev.php','',$uri),4));
  1662.         if($category) {
  1663.             $ret['category']['category'] = $category;
  1664.             $ret['category']['subcategories'] = $this->eshopCategoriesHandle->getCategories($category->getId());
  1665.         } else {
  1666.             foreach($this->eshopCategoriesHandle->getRouteableCategories() as $category_seo_data) {
  1667.                 if(substr($uri,4,strlen($category_seo_data['link'])) == $category_seo_data['link']) {
  1668.                     $ret['category']['category'] = $category_seo_data['category_obj'];
  1669.                     $ret['category']['subcategories'] = $this->eshopCategoriesHandle->getCategories($category_seo_data['category']['id']);
  1670.                 }
  1671.             }
  1672.         }
  1674.         if($ret['category']['category']) {
  1675.             $ret['products'] = array();
  1677.             //test
  1678.             if($_SERVER["REMOTE_ADDR"] == '81.201.53.119') {
  1679.                 //\Doctrine\Common\Util\Debug::dump($ret['products']);
  1680.                 //\Doctrine\Common\Util\Debug::dump($this->eshopCategoriesHandle->getCategoryProducts($ret['category']['category']->getId(),false));
  1682.                 //echo 'c'.$ret['category']['category']->getId()."\n";
  1684.                 //foreach($this->eshopCategoriesHandle->getCategoryProducts($ret['category']['category']->getId(),false) as $product_category) {
  1685.                 //    echo $product_category->getProductId()."\n";
  1686.                 //}
  1688.                 //exit;
  1689.             }
  1692.             foreach($this->eshopCategoriesHandle->getCategoryProducts($ret['category']['category']->getId(),false) as $product_category) {
  1693.                 $ret['products'][] = $this->getProductReturnArrayBlock($product_category->getProduct(), 'cz', array());
  1694.             }
  1695.         } else {
  1696.             $ret['category']['subcategories'] = $this->eshopCategoriesHandle->getCategories();
  1697.         }
  1699.         if($ret['category']['subcategories']) {
  1700.             $to_exclude = array();
  1702.             foreach($ret['category']['subcategories'] as &$subcategory) {
  1703.                 $product_in_category = $this->eshopCategoriesHandle->getCategoryProducts($subcategory['id'],false);
  1704.                 if(count($product_in_category) == 1) {
  1705.                     $product = $this->getProductReturnArrayBlock($product_in_category[0]->getProduct(), 'cz', array());
  1706.                     if($product['main_image'] != $this->no_image)
  1707.                         $subcategory['alt_image'] = $product['main_image'];
  1708.                     if($subcategory['article']) {
  1709.                         if($subcategory['article']->getImage())
  1710.                             $subcategory['alt_image'] = $images_helper->imageCutFunction($subcategory['article']->getImage()->getId(),700,320,'crop-best');
  1711.                        }
  1713.                     $subcategory['full_link'] = str_replace('/cz/','',$product['detail_url']);
  1714.                 }
  1716.                 if(count($product_in_category) == 0) {
  1717.                     $to_exclude[] = $subcategory['id'];
  1718.                 }
  1719.             }
  1721.             //exclude empty
  1722.             //$r_c_s_temp = $ret['category']['subcategories'];
  1723.             //$ret['category']['subcategories'] = [];
  1725.             //foreach($r_c_s_temp as $subcategory) {
  1726.                 //if(!in_array($subcategory['id'],$to_exclude))
  1727.                     //$ret['category']['subcategories'][] = $subcategory;
  1728.             //}
  1730.             //echo count($product_in_category).'<br>';
  1731.             //\Doctrine\Common\Util\Debug::dump($to_exclude);
  1732.             //exit();
  1735.         }
  1738.         if($ret['category']['category']) {
  1739.             $this->controller->get('page_frontend_handle')->setPageMeta(
  1740.                 'F.a.r.line - '.$ret['category']['category']->getName()
  1741.             );
  1742.         }
  1744.         //\Doctrine\Common\Util\Debug::dump($ret['category']['subcategories']);
  1745.         //exit();
  1747.         if($_SERVER["REMOTE_ADDR"] == '81.201.53.119') {
  1748.             //\Doctrine\Common\Util\Debug::dump($ret['products']);
  1749.             //exit;
  1750.         }
  1753.         return $ret;
  1754.     }
  1756.     public function getEshopInitProduct($config) {
  1757.         $uri = explode('?',str_replace('/app_dev.php','',$_SERVER['REQUEST_URI'])); $uri = $uri[0];
  1758.         $route_url_split = explode('/',$uri);
  1759.         $product_id = (int)end($route_url_split);
  1761.         if($product_id >= 1) {
  1762.             $product = $this->getProduct($product_id);
  1763.             if($product) {
  1764.                 $product_full = $this->getProductReturnArrayBlock($product,'cz',array());
  1766.                 $this->controller->get('page_frontend_handle')->setPageMeta(
  1767.                     'F.a.r.line - '.$product_full['name'],
  1768.                     $product_full['main_product_image']
  1769.                 );
  1771.                 return $product_full;
  1772.             }
  1773.         }
  1775.         exit('Produkt nenalezen');
  1776.     }
  1778.     public function getEshopInitParamsOld($config) {
  1779.         $uri = explode('?',str_replace('/app_dev.php','',$_SERVER['REQUEST_URI'])); $uri = $uri[0];
  1780.         $request_type = null;
  1781.         $product_url_prefix = array('product/');
  1783.         $product = null;
  1785.         $ret = array(
  1786.             'product_id' => 0,
  1787.             'product' => null,
  1788.             'categories' => array(),
  1789.             'category' => array('category' => null, 'subcategories' => null),
  1790.             'set_categories' => array()
  1791.         );
  1793.         //product url
  1794.         foreach($product_url_prefix as $pp) {
  1795.             if(strpos($uri, $pp) !== false) {
  1796.                 $request_type = 'product';
  1797.             }
  1798.         }
  1800.         //product dynamic url
  1801.         if(!$request_type) {
  1802.             $l1_match = false;
  1803.             $l2_match = false;
  1804.             foreach($this->eshopCategoriesHandle->getRouteableCategories() as $category_seo_data) {
  1805.                 if(substr($uri,4,strlen($category_seo_data['link'])) == $category_seo_data['link']) {
  1806.                     $l1_match = true;
  1807.                     $ret['category']['category'] = $category_seo_data['category_obj'];
  1808.                     $ret['category']['subcategories'] = $this->eshopCategoriesHandle->getCategories($category_seo_data['category']['id']);
  1809.                 }
  1810.             }
  1811.             if($l1_match) {
  1812.                 $uri_explode = explode('/',$uri);
  1813.                 $code = $uri_explode[count($uri_explode)-1];
  1814.                 $product = $this->getProductByCode($code);
  1816.                 if($product)
  1817.                     $l2_match = true;
  1818.             }
  1820.             if($l1_match && $l2_match) {
  1821.                 $request_type = 'product';
  1822.             } else {
  1823.                 if($l1_match)
  1824.                     $request_type = 'category-direct';
  1825.             }
  1826.         }
  1828.         $category = $this->eshopCategoriesHandle->getCategoryBySeoName(substr(str_replace('/app_dev.php','',$uri),4));
  1829.         if($category) {
  1830.             $request_type = 'category';
  1831.         }
  1833.         switch($request_type) {
  1834.             default:
  1835.             break;
  1836.             case 'product':
  1837.                 $uri_explode = explode('/',$uri);
  1838.                 $code = $uri_explode[count($uri_explode)-1];
  1840.                 if(!$product)
  1841.                     $product = $this->getProductByCode($code);
  1843.                 if($product) {
  1844.                     $ret['product_id'] = $product->getId();
  1845.                     $ret['product'] = $product;
  1847.                     $product_full = $this->getProductReturnArrayBlock($product,'cz',array());
  1849.                     $this->controller->get('page_frontend_handle')->setPageMeta(
  1850.                         $product_full['name'].' '.$product_full['master_category']['title_name'],
  1851.                         $product_full['main_product_image']
  1852.                     );
  1853.                 }
  1855.             break;
  1856.             case 'category':
  1857.                 $sub_categories = $this->eshopCategoriesHandle->getCategories($category->getId());
  1859.                 if($category->getParentRow()) {
  1860.                     $this->controller->get('page_frontend_handle')->setPageMeta(
  1861.                         ucfirst($category->getName()).' '.$category->getParentRow()->getTitle().' - Katalog F.A.R. Line'
  1862.                     );
  1863.                 } else {
  1864.                     $this->controller->get('page_frontend_handle')->setPageMeta(
  1865.                         ucfirst($category->getTitle()).' - Katalog F.A.R. Line'
  1866.                     );
  1867.                 }
  1870.                 //if has subcategories -> include them
  1871.                 if(is_array($sub_categories)) {
  1872.                     foreach($sub_categories as $sc) {
  1873.                         $ret['set_categories'][] = $sc['id'];
  1874.                     }
  1875.                 } else {
  1876.                     $ret['set_categories'] = array($category->getId());
  1877.                 }
  1878.             break;
  1879.         }
  1881.         //eshop categories
  1882.         $ret['categories'] = $this->eshopCategoriesHandle->getCategories(0);
  1883.         $ret['dynamic_model'] = $this->eshopParamsHandle->getParamsCollection('cz');
  1885.         //print_r($ret);
  1886.         //exit();
  1888.         return $ret;
  1889.     }
  1891.     public function getEshopTopProducts($config) {
  1892.         return $this->findProducts($config['lang'],array('results_per_page' => 20),1,true,1);
  1893.     }
  1895.     private function isLetter($letter) {
  1896.         if(preg_match("/^[a-z]$/", $letter))
  1897.             return true;
  1899.         return false;
  1900.     }
  1902.     private function getProductName(\Kiwi\EshopBundle\Entity\Product $product, $lang) {
  1903.         //name constructor
  1904.         $name = '';
  1905.         if($product->getQuantityInPackage() >= 2)
  1906.             $name .= $product->getQuantityInPackage().'x ';
  1907.         $name .= $this->languages->getLangEntry($product->getName(),$lang);
  1909.         return $name;
  1910.     }
  1912.     private function getProductUrl(\Kiwi\EshopBundle\Entity\Product $product = null, $product_id = 0, $lang) {
  1913.         $url = $this->controller->get('page_twig_extension')->kpathFunction(3, $lang);
  1915.         $category = null;
  1916.         foreach($this->controller->get('eshop_categories_handle')->getProductCategories($product) as $product_category) {
  1917.             if($product_category->getCategory()->getParentRow()) {
  1918.                 $category = $product_category->getCategory();
  1919.                 break;
  1920.             }
  1921.         }
  1923.         if($category)
  1924.         {
  1925.             if($category->getParentRow())
  1926.             {
  1927.                 if($category->getParentRow()->getParentRow())
  1928.                 {
  1929.                     if($category->getParentRow()->getParentRow()->getParentRow())
  1930.                     {
  1931.                         $url .= $category->getParentRow()->getParentRow()->getParentRow()->getName().'/';
  1932.                     }
  1933.                     
  1934.                     $url .= $category->getParentRow()->getParentRow()->getName().'/';
  1935.                 }
  1936.                 
  1937.                 $url .= $category->getParentRow()->getName().'/';
  1938.             }
  1940.             $url .= $category->getName().'/';
  1941.             $url .= str_replace(array('  '),' ',$this->getProductName($product, $lang)).'/';
  1942.             $url .= $product->getId();
  1943.         }
  1944.         else
  1945.         {
  1946.             
  1947.             $url .= 'produkt/';
  1948.             $url .= str_replace(array('  '),' ',$this->getProductName($product, $lang)).'/';
  1949.             $url .= $product->getId();
  1950.         }
  1952.         $url = str_replace('app_dev-php','app_dev.php',$this->pageExtensions->webalizeFunction($url));
  1954.         return $url;
  1955.     }
  1957.     private function getHolderUrl(ProductHolders $holder, $lang) {
  1958.         $dev_prefix = '';
  1959.         $url = '/'.$lang.'/';
  1961.         if($this->controller->get( 'kernel' )->getEnvironment() == 'dev')
  1962.             $dev_prefix = '/app_dev.php';
  1964.         /*
  1965. $category = null;
  1966. foreach($this->controller->get('eshop_categories_handle')->getProductCategories($product) as $product_category) {
  1967.     if($product_category->getCategory()->getParentRow()) {
  1968.         $category = $product_category->getCategory();
  1969.         break;
  1970.     }
  1971. }
  1974. if($category)
  1975. {
  1976.     if($category->getParentRow())
  1977.     {
  1978.         if($category->getParentRow()->getParentRow())
  1979.         {
  1980.             if($category->getParentRow()->getParentRow()->getParentRow())
  1981.             {
  1982.                 $url .= $category->getParentRow()->getParentRow()->getParentRow()->getName().'/';
  1983.             }
  1985.             $url .= $category->getParentRow()->getParentRow()->getName().'/';
  1986.         }
  1988.         $url .= $category->getParentRow()->getName().'/';
  1989.     }
  1991.     $url .= $category->getName().'/';
  1992.     $url .= str_replace(array('  '),' ',$this->getProductName($product, $lang)).'/';
  1993.     $url .= $product->getId();
  1994. }
  1995. else
  1996. {
  1998.     $url .= 'produkt/'; //$category->GetName().'/';//'drevene-podlahy/';//$category->getName().'/';
  1999.     $url .= str_replace(array('  '),' ',$this->getProductName($product, $lang)).'/';
  2000.     $url .= $product->getId();
  2001. }
  2002. */
  2004.         $url .= 'produkt/';
  2006.         $product = $this->em->getRepository('Kiwi\EshopBundle\Entity\Product')->findOneBy(array(
  2007.             'holder_id' => $holder->getId()
  2008.         ));
  2010.         if($product) {
  2011.             foreach($this->eshopCategoriesHandle->getProductCategoriesNoCache($product) as $product_category) {
  2012.                 if($product_category->getCategory()) {
  2013.                     $url .= $product_category->getCategory()->getSeoName()."/";
  2014.                 }
  2015.             }
  2016.         }
  2018.         $url .= $this->languages->getLangEntry($holder->getArticle()->getName(), $lang).'/';
  2019.         $url .= $holder->getTransportCode();
  2021.         $url = $dev_prefix.$this->pageExtensions->webalizeFunction($url);
  2023.         return $url;
  2024.     }
  2026.     public function storeCookieProductReference($product_id, Request $request, Response $response) {
  2027.         $current = [];
  2028.         if($request->cookies->has($this->cookie_key)) {
  2029.             $current = explode(',',$request->cookies->get($this->cookie_key));
  2030.         }
  2031.         $current = array_merge([$product_id], $current);
  2033.         $cookie = new Cookie($this->cookie_key, join(",",$current), time()+(86400*7));
  2034.         $response->headers->setCookie($cookie);
  2035.     }
  2037.     public function getCookieProduct(Request $request, $lang) {
  2038.         $current = [];
  2039.         if($request->cookies->has($this->cookie_key)) {
  2040.             $current = explode(',',$request->cookies->get($this->cookie_key));
  2041.             $current = array_unique($current);
  2042.             $slice = array_slice($current,0,10);
  2044.             $out = [];
  2045.             foreach ($slice as $product_id) {
  2046.                 $out[] = $this->findProduct($lang, $product_id);
  2047.             }
  2049.             return $out;
  2050.         }
  2051.         return $current;
  2052.     }
  2054.     //debug
  2055.     private function logClean() {
  2056.         file_put_contents($this->log_path, '');
  2057.     }
  2058.     private function logState($s) {
  2059.         file_put_contents($this->log_path, $s."\n", FILE_APPEND);
  2060.     }
  2061. }