src/Trinity/WebshopBundle/Controller/FrontController.php line 425

Open in your IDE?
  1. <?php
  3. namespace App\Trinity\WebshopBundle\Controller;
  5. use App\CmsBundle\Controller\StorageController;
  6. use Symfony\Bundle\FrameworkBundle\Controller\Controller;
  7. use Symfony\Component\Routing\Annotation\Route;
  8. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Template;
  9. use Symfony\Component\HttpFoundation\Request;
  10. use Symfony\Component\HttpFoundation\JsonResponse;
  11. use App\Trinity\WebshopBundle\Entity\Category;
  12. use App\Trinity\WebshopBundle\Entity\Invoice;
  13. use App\Trinity\WebshopBundle\Entity\OrderPayment;
  14. use App\Trinity\WebshopBundle\Entity\Review;
  15. use App\Trinity\WebshopBundle\Entity\SavedSearch;
  16. use App\Trinity\WebshopBundle\Entity\InvoiceProduct;
  17. use App\Trinity\WebshopBundle\Classes\Pdf;
  18. use App\Trinity\WebshopBundle\Entity\Tag;
  20. use App\Trinity\WebshopBundle\Classes\Picqer;
  21. use Twig\Environment;
  23. class FrontController extends StorageController
  24. {
  26.     /**
  27.      * @Route("/webshop-main/save/search", name="save_search")
  28.      * @Template()
  29.      */
  30.     public function savesearchAction(Request $request)
  31.     {
  32.         $this->init($request);
  34.         $validCaptcha = $this->Settings->validateGoogleRecaptcha($request->request->get('g-recaptcha-response'));
  36.         if(($validCaptcha)){
  38.             if(!empty($_POST['email'])){
  39.                 $SavedSearch = new SavedSearch();
  40.                 $SavedSearch->setWebshop($this->Webshop);
  41.                 $SavedSearch->setEmail($_POST['email']);
  42.                 $SavedSearch->setDateStart(new \DateTime());
  43.                 $SavedSearch->setParameters($_POST);
  45.                 $em = $this->getDoctrine()->getManager();
  46.                 $em->persist($SavedSearch);
  47.                 $em->flush();
  48.             }else{
  49.                 $spec_query = '';
  50.                 $spec_filter = [];
  51.                 $licenseplate = null;
  52.                 if(!empty($this->get('session')->get('ecomm_spec_filter'))){
  53.                     $spec_filter = $this->get('session')->get('ecomm_spec_filter');
  54.                 }
  55.                 if(!empty($this->get('session')->get('ecomm_spec_plate'))){
  56.                     $licenseplate = $this->get('session')->get('ecomm_spec_plate');
  57.                 }
  58.                 /*if(!empty($this->get('session')->get('ecomm_spec_query'))){
  59.                     $spec_query = $this->get('session')->get('ecomm_spec_query');
  60.                 }*/
  61.                 $data = [
  62.                     'spec_filter' => $spec_filter,
  63.                     'licenseplate' => $licenseplate,
  64.                     'spec_query' => $spec_query,
  65.                 ];
  68.                 $SavedSearch = new SavedSearch();
  69.                 $SavedSearch->setWebshop($this->Webshop);
  70.                 $SavedSearch->setEmail($_POST['filter-email']);
  71.                 $SavedSearch->setDateStart(new \DateTime());
  72.                 $SavedSearch->setParameters($data);
  74.                 $em = $this->getDoctrine()->getManager();
  75.                 $em->persist($SavedSearch);
  76.                 $em->flush();
  77.             }
  79.             return new JsonResponse(['success' => true]);
  80.         }else{
  81.             return new JsonResponse(['success' => false, 'message' => 'Ongeldige captcha.']);
  82.         }
  83.     }
  85.     public function check_diff_multi($array1, $array2){
  86.         $result = array();
  87.         foreach($array1 as $key => $val) {
  88.              if(isset($array2[$key])){
  89.                if(is_array($val) && $array2[$key]){
  90.                    $result[$key] = $this->check_diff_multi($val, $array2[$key]);
  91.                }
  92.            } else {
  93.                $result[$key] = $val;
  94.            }
  95.         }
  97.         return $result;
  98.     }
  100.     public function initPaging(Request $request){
  101.         $em = $this->getDoctrine()->getManager();
  102.         $this->Settings = $em->getRepository('CmsBundle:Settings')->findByLanguage($this->language, str_replace('www.', '', $request->getHttpHost()));
  103.         if(is_null($this->Settings)) $this->Settings = new \App\CmsBundle\Entity\Settings();
  105.         $this->absoluteUrl = $request->getScheme() . '://' . $request->getHttpHost() . $request->getBasePath();
  107.         $this->FirstPage = null;
  108.         $tmp_pages = $this->getDoctrine()->getRepository('CmsBundle:Page')->findBy(array('language' => $this->Settings->getLanguage(), 'page' => null, 'base' => null, 'enabled' => true), array('sort' => 'ASC'), 1);
  109.         if(!empty($tmp_pages)){
  110.             $this->FirstPage = $tmp_pages[0];
  111.         }
  112.     }
  114.     public function parse( $tpl, $args = array() ){
  115.         $args[ 'Settings' ] = $this->Settings;
  116.         $args[ 'languages' ] = $this->getDoctrine()->getRepository('CmsBundle:Language')->findAll();
  118.         if( !isset($args[ 'bodyClass' ]) ) $args[ 'bodyClass' ] = 'sub';
  120.         return $this->render($tpl . '.html.twig', $args);
  121.     }
  123.     /**
  124.      * Load dynamic category as defined in WebshopBundle
  125.      *
  126.      * @param  Request $request
  127.      * @Template()
  128.      */
  129.     public function loadAction(Request $request)
  130.     {
  131.         $this->init($request);
  133.         $params = array();
  134.         $params[] = $request->get('param1');
  135.         $params[] = $request->get('param2');
  136.         $params[] = $request->get('param3');
  138.         // Find recipes page
  139.         $RecipesPage = null;
  140.         $blocks = $this->getDoctrine()->getRepository('CmsBundle:PageBlock')->findByData('TrinityRecipesBundle');
  141.         foreach($blocks as $Block){
  142.             $p = $Block->getWrapper()->getPage();
  143.             if($p->getLanguage() == $this->language){
  144.                 $RecipesPage = $p;
  145.                 break;
  146.             }
  147.         }
  149.         $this->initPaging($request);
  150.         $this->init($request);
  151.         $Webshop = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Webshop')->getByLanguageAndSettings($this->language, $this->Settings);
  152.         $Settings = $Webshop->getSettings();
  154.         $custom_breadcrumbs = [];
  155.         $custom_breadcrumbs[] = [
  156.             'name' => $this->trans('home', [], 'webshop_backend'),
  157.             'url' => $this->generateUrl('homepage') . substr($this->Settings->getBaseUri(),1)
  158.         ];
  160.         // VALIDATE HOMEPAGE AS HIGHEST LEVEL
  161.         $access = $this->FirstPage->getAccess();
  162.         if($access != null){
  163.             // Validate permissions
  164.             if($access == 'login'){
  165.                 $checkRoles = $this->FirstPage->getAccessRoles();
  166.                 if($checkRoles){
  167.                     if(!is_array($checkRoles)) $checkRoles = [$checkRoles];
  168.                     $hasRoleAccess = false;
  169.                     foreach($checkRoles as $role){
  170.                         if($this->get('security.authorization_checker')->isGranted($role)){
  171.                             $hasRoleAccess = true;
  172.                             break;
  173.                         }
  174.                     }
  176.                     if(!$hasRoleAccess){
  177.                         if ($this->FirstPage->getAccessAllowLogin()) {
  178.                             // LOGIN FORM
  180.                             $hasLoginInvalidRoles = false;
  181.                             if($this->get('security.authorization_checker')->isGranted('IS_AUTHENTICATED_FULLY')){
  182.                                 $hasLoginInvalidRoles = true;
  183.                             }
  185.                             $metatags       = $this->getDoctrine()->getRepository('CmsBundle:Metatag')->getBySystem(0, (int)$this->FirstPage->getId(), true);
  186.                             $systemMetatags = $this->getDoctrine()->getRepository('CmsBundle:Metatag')->getBySystem(1, false, false);
  188.                             $lastUsername = '';
  189.                             $error = null;
  191.                             $this->FirstPage->setTitle('Inloggen');
  192.                             $this->FirstPage->setLabel('Inloggen');
  194.                             $this->FirstPage->requireAuth = true;
  196.                             return $this->parse( 'CmsBundle:Page:page', $this->attributes([
  197.                                 'loginform'            => true,
  198.                                 'bodyClass'            => 'dynamic',
  199.                                 'Page'                 => $this->FirstPage,
  200.                                 'metatags'             => $metatags,
  201.                                 'systemMetatags'       => $systemMetatags,
  202.                                 'error'                => $error,
  203.                                 'last_username'        => $lastUsername,
  204.                                 'hasLoginInvalidRoles' => $hasLoginInvalidRoles,
  205.                             ]));
  206.                         }else{
  207.                             throw $this->createAccessDeniedException('Permission denied');
  208.                         }
  209.                     }
  210.                 }
  211.             }elseif($access == 'no-login'){
  212.                 if($this->get('security.authorization_checker')->isGranted('ROLE_USER')){
  213.                     throw $this->createAccessDeniedException('Permission denied');
  214.                 }
  215.             }
  216.         }
  225.         $this->get('session')->set('last-route', $request->get('_route'));
  227.         $Page = $Settings->getPage();
  228.         if(empty($Page)){
  229.             $Page = new \App\CmsBundle\Entity\Page();
  230.             $Page->setOptionBreadcrumbs(false);
  231.             $Page->setOptionSubnavigation(false);
  232.             $Page->setOptionTitle(false);
  233.         }
  235.         $metatags       = $this->getDoctrine()->getRepository('CmsBundle:Metatag')->getBySystem(0, (int)$Page->getId(), true);
  236.         $systemMetatags = $this->getDoctrine()->getRepository('CmsBundle:Metatag')->getBySystem(1, false, false);
  238.         $all_products = null;
  239.         $price_range = null;
  240.         $catFix = false;
  243.         $Product = null;
  244.         $Category = null;
  245.         if ($request->get('categoryId')) {
  246.             $Category = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Category')->findOneBy(['webshop' => $Webshop, 'id' => $request->get('categoryId')]);
  248.             if(empty($Category)){
  249.                 $_Category = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Category')->findOneBy(['id' => $request->get('categoryId')]);
  250.                 if($_Category->getWebshop() != $Webshop){
  251.                     // Webshop mismatch
  252.                     // Try to find one based on the same slug and webshop
  253.                     $Category = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Category')->findOneBy(['webshop' => $Webshop, 'slug' => $_Category->getSlug()]);
  254.                 }
  256.                 if(empty($Category)){
  257.                     throw $this->createNotFoundException('Category ' . $request->get('categoryId') . ' not found');
  258.                 }
  259.             }
  261.             // Parsed wrong language category
  262.             if($Category->getWebshop() && ($Category->getWebshop()->getLanguage() != $this->language || $Category->getWebshop() != $this->Webshop)){
  263.                 $TmpCategory = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Category')->findOneBy([ 'slug' => $Category->getSlug(), 'webshop' => $this->Webshop ]);
  264.                 if($TmpCategory) {
  265.                     $Category = $TmpCategory;
  266.                 }
  267.             }
  269.             if(!empty($params[1])){
  270.                 $Product = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->findByCategoryAndSlug($Category, $params[1], true);
  271.             }else if(!empty($params[0])){
  272.                 $Product = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->findByCategoryAndSlug($Category, $params[0], true);
  273.             } else if($request->get('productId')){
  274.                 $Product = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->findOneBy(['webshop' => $Webshop, 'id' => $request->get('productId')]);
  275.             }
  277.             // if($this->containerInterface->getParameter('kernel.environment') == 'dev'){
  278.             if(empty($Product)){
  279.                 // Fix for dynamic assigned products based on promotions
  280.                 if(!empty($params[1])){
  281.                     $FoundProduct = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->findOneBySlug($params[1]);
  282.                 }elseif(!empty($params[0])){
  283.                     $FoundProduct = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->findOneBySlug($params[0]);
  284.                 }
  286.                 // Found product itself, try look for dynamic promotion link
  287.                 if(!empty($FoundProduct) && !empty($FoundProduct->getCategory())){
  288.                     $CategoryProduct = $FoundProduct->getCategory()->first();
  289.                     if((int)$this->WebshopSettings->getUriType() == 1){
  290.                         $productUrl = '';
  291.                         $productUrl .= ($this->Webshop->getSettings()->getUri() ? '/' . $this->Webshop->getSettings()->getUri() : $this->generateUrl('homepage'));
  292.                         // $productUrl .= $productname;
  293.                         // $productUrl .= '/' . $FoundProduct->getNumber();
  294.                         $productUrl .= $CategoryProduct->getCategory()->getUri();
  295.                         $productUrl .= '/' . $FoundProduct->getSlug();
  296.                     }else{
  297.                         $productUrl = '';
  298.                         $productUrl .= ($this->Webshop->getSettings()->getUri() ? '/' . $this->Webshop->getSettings()->getUri() : $this->generateUrl('homepage') . ($this->Webshop->getCmssettings()->getBaseUri() ? $this->Webshop->getCmssettings()->getBaseUri() . '/' : ''));
  299.                         //$productUrl .= ($Webshop->getSettings()->getUri() ? '/' . $Webshop->getSettings()->getUri() : $this->generateUrl('homepage'));
  300.                         $productUrl .= $CategoryProduct->getCategory()->getUri();
  301.                         $productUrl .= '/' . $FoundProduct->getSlug();
  303.                         $productUrl = str_replace('//', '/', $productUrl);
  304.                     }
  306.                     header('Location:' . $productUrl);
  307.                     exit;
  308.                 }
  309.             }
  310.             // }
  311.         }
  313.         // pelikan
  314.         if (is_numeric($params[0])) {
  315.             $Product = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->findOneBy(['number' => $params[0], 'language' => $this->language]);
  316.             $Category = $Product->getCategory()->first()->getCategory();
  317.         }
  319.         if(!empty($_GET['q'])){
  320.             $res = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->search($this->Webshop, ['q' => $_GET['q']], 'id', 'asc');
  321.             if(!empty($res['total'])){
  322.                 $FoundProduct = $res['results'][0];
  323.                 if(!empty($FoundProduct->getTemplateKey())){
  324.                     if((int)$this->WebshopSettings->getUriType() == 1){
  325.                         $productUrl = '';
  326.                         $productUrl .= ($this->Webshop->getSettings()->getUri() ? '/' . $this->Webshop->getSettings()->getUri() : $this->generateUrl('homepage'));
  327.                         // $productUrl .= $productname;
  328.                         // $productUrl .= '/' . $FoundProduct->getNumber();
  329.                         $productUrl .= $FoundProduct->getCategory()->first()->getCategory()->getUri();
  330.                         $productUrl .= '/' . $FoundProduct->getSlug();
  331.                     }else{
  332.                         $productUrl = '';
  333.                         $productUrl .= ($this->Webshop->getSettings()->getUri() ? '/' . $this->Webshop->getSettings()->getUri() : $this->generateUrl('homepage') . ($this->Webshop->getCmssettings()->getBaseUri() ? $this->Webshop->getCmssettings()->getBaseUri() . '/' : ''));
  334.                         //$productUrl .= ($Webshop->getSettings()->getUri() ? '/' . $Webshop->getSettings()->getUri() : $this->generateUrl('homepage'));
  335.                         $productUrl .= $FoundProduct->getCategory()->first()->getCategory()->getUri();
  336.                         $productUrl .= '/' . $FoundProduct->getSlug();
  338.                         $productUrl = str_replace('//', '/', $productUrl);
  339.                     }
  341.                     header('Location:' . $productUrl);
  342.                     exit;
  343.                 }
  344.             }
  345.         }
  347.         $sort = null;
  348.         $sort_dir = 'asc';
  349.         $defaultSort = $this->WebshopSettings->getDefaultSort();
  350.         if(!empty($defaultSort)){
  351.             $defaultSort = str_replace('-', ' ', $defaultSort);
  352.             $sort = $defaultSort;
  353.         }
  355.         /**
  356.          * 
  357.          * 
  358.          *     ==============================================================================================================
  359.          *     ==============================================================================================================
  360.          *     ==============================================================================================================
  361.          *     ==============================================================================================================
  362.          * 
  363.          *     PRODUCT DETAIL
  364.          * 
  365.          *     ==============================================================================================================
  366.          *     ==============================================================================================================
  367.          *     ==============================================================================================================
  368.          *     ==============================================================================================================
  369.          * 
  370.          * 
  371.          */
  372.         if($Product){
  373.             //$this->Timer->break('Found product: ' . $Product->getLabel() . ', start product display');
  375.             // Check from parameters if caching must be enabled
  376.             $allowCache = false;
  377.             if ($this->containerInterface->hasParameter('trinity_cache') && ($this->containerInterface->getParameter('trinity_cache') == 'true' || $this->containerInterface->getParameter('trinity_cache'))) {
  378.                 $allowCache = true;
  379.             }
  380.             if(!empty($_GET['nocache']) || !empty($_GET['resetcache']) || !empty($_GET['timer']) || $this->containerInterface->getParameter('kernel.environment') == 'dev' || $Settings->getB2b()){
  381.                 $allowCache = false;
  382.             }
  383.             /* if ($allowCache) {
  384.                 $cachedData = $Product->getCacheData();
  385.                 if(!empty($cachedData)){
  386.                     // Return cached data
  387.                     echo $cachedData;
  388.                     exit;
  389.                 }
  390.             } */
  392.             $Product->activeCategory = $Category;
  394.             $recipes = [];
  395.             if(!empty($Product->getBundleLinkdata())){
  396.                 $bld = $Product->getBundleLinkdata();
  397.                 if(!empty($bld['RecipesBundle'])){
  398.                     foreach($bld['RecipesBundle'] as $recipe_id){
  399.                         $Recipe = $this->getDoctrine()->getRepository(\App\Trinity\RecipesBundle\Entity\Recipe::class)->find($recipe_id);
  400.                         if(!empty($Recipe)){
  401.                             $recipes[] = $Recipe;
  402.                         }
  403.                     }
  404.                 }
  405.             }
  408.             /*if($this->containerInterface->getParameter('kernel.environment') == 'dev'){
  409.                 dump($Product->getId());
  410.                 $displayPrice = $Product->getDisplayPrice($this->WebshopSettings, $this->WebshopCustomer, $this->getUser(), true);
  411.                 die($displayPrice);
  412.             }*/
  415.             if($Product->getType() == 1 || $Product->getType() == 2){
  416.                 // if($this->containerInterface->getParameter('kernel.environment') == 'dev'){
  417.                     if(empty($Product->getLinkedProductsSorted()) && empty($Product->getSuper())){
  418.                         throw $this->createNotFoundException('Product ' . $Product->getId() . ' not found');
  419.                     }
  420.                 // }
  421.             }
  423.             // $Product = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->find($request->get('productId'));
  425.             $current_productViewHistory = $this->get('session')->get('product-view-history');
  426.             $productHistory = [$Product->getId()];
  427.             if(!empty($current_productViewHistory)){
  428.                 foreach($current_productViewHistory as $id){
  430.                     $historyProd = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->find($id);
  431.                     if($historyProd){
  432.                         if($id != $Product->getId() && $historyProd->getVisible() && $historyProd->getEnabled()){
  433.                             if(!in_array($id, $productHistory)){
  434.                                 if(count($productHistory) < 5){
  435.                                     $productHistory[] = $id;
  436.                                 }
  437.                             }
  438.                         }
  439.                     }
  440.                 }
  441.             }
  443.             // Sign-up for restock messages
  444.             if(!empty($_POST['signupstock'])){
  445.                 $receipients = $Product->getRestockNotify();
  446.                 $receipients[] = $_POST['signupstock'];
  447.                 $Product->setRestockNotify($receipients);
  449.                 $em = $this->getDoctrine()->getManager();
  450.                 $em->persist($Product);
  451.                 $em->flush();
  453.                 header('Location:' . $request->getUri() . '?notify-restock=true');
  454.                 exit;
  455.             }
  457.             $this->get('session')->set('product-view-history', $productHistory);
  461.             $firstAvailable = null;
  462.             $firstAvailablePrice = 100000000000;
  463.             if ($Product->getLinkedProducts()->count() > 0) {
  464.                 foreach($Product->getLinkedProducts() as $LP){
  465.                     if($LP->canOrder()){
  466.                         if($LP->getRealPriceIncl() < $firstAvailablePrice){
  467.                             $firstAvailable = $LP;
  468.                             $firstAvailablePrice = $LP->getRealPriceIncl();
  469.                         }
  470.                     }
  471.                 }
  472.             }
  474.             $productHistoryObjects = [];
  475.             foreach($productHistory as $id){
  476.                 if($id != $Product->getId()){
  477.                     $productHistoryObjects[$id] = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->findOneById($id);
  478.                 }
  479.             }
  488.             /*$productRelatedObjects = [];
  489.             $limit = 10;
  490.             $count = 0;
  491.             $CatProds = $Product->getCategory()[0]->getCategory()->getProducts();
  492.             foreach($CatProds as $CatProd){
  493.                 if($count <= $limit){
  494.                     if($CatProd->getProduct()->getId() != $Product->getId()){
  495.                         $productRelatedObjects[$CatProd->getProduct()->getId()] = $CatProd->getProduct();
  496.                         $count++;
  497.                     }
  498.                 } else {
  499.                     break;
  500.                 }
  501.             }*/
  503.             // Cleaner way and directly filtered by brand and model
  504.             $f = [];
  505.             $BrandsSpec = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Spec')->findOneBy(['label' => 'Merk']);
  506.             $ModelsSpec = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Spec')->findOneBy(['label' => 'Model']);
  508.             $specData = $Product->getSimplifiedSpecValues();
  509.             foreach($specData as $k => $v){
  510.                 if(!empty($BrandsSpec) && $k == $BrandsSpec->getId()){ $f[$k] = $v; }
  511.                 if(!empty($ModelsSpec) && $k == $ModelsSpec->getId()){ $f[$k] = $v; }
  512.             }
  514.             $productRelatedObjects_raw = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->search(
  515.                 $this->Webshop,
  516.                 [
  517.                     'category' => $Product->getCategory()->first()->getCategory(),
  518.                     'visible' => 1,
  519.                     'filters' => $f,
  520.                     'ignore_ids' => [$Product->getId()],
  521.                 ], null, 'asc', ($this->WebshopSettings->getPagination() == 'none'), false, 1, 10, 0
  522.             );
  523.             $productRelatedObjects = $productRelatedObjects_raw['results'];
  531.             $country = $Settings->getMapZoomCountry();
  532.             if (empty($Settings->getMapZoomCountry())) {
  533.                 $country = '';
  534.             }
  536.             switch ($country)
  537.             {
  538.                 case 'nl':
  539.                     $center_lat = 52.307963;
  540.                     $center_lng = 5.551342;
  541.                     $center_zoom = 7;
  542.                     break;
  543.                 case 'be':
  544.                     $center_lat = 50.683057;
  545.                     $center_lng = 4.731317;
  546.                     $center_zoom = 8;
  547.                     break;
  548.                 case 'gb':
  549.                     $center_lat = 54.121844;
  550.                     $center_lng = -2.767957;
  551.                     $center_zoom = 6;
  552.                     break;
  553.                 case 'de':
  554.                     $center_lat = 51.085295;
  555.                     $center_lng = 10.027864;
  556.                     $center_zoom = 6;
  557.                     break;
  558.                 case 'fr':
  559.                     $center_lat = 47.091676;
  560.                     $center_lng = 2.791095;
  561.                     $center_zoom = 6;
  562.                     break;
  563.                 case 'it':
  564.                     $center_lat = 43.095551;
  565.                     $center_lng = 12.306936;
  566.                     $center_zoom = 5;
  567.                     break;
  568.                 case 'ch':
  569.                     $center_lat = 46.911197;
  570.                     $center_lng = 8.297312;
  571.                     $center_zoom = 8;
  572.                     break;
  573.                 case 'cz':
  574.                     $center_lat = 49.832784;
  575.                     $center_lng = 15.493717;
  576.                     $center_zoom = 7.5;
  577.                     break;
  578.                 default:
  579.                     $center_lat = 50.626387;
  580.                     $center_lng = 9.889074;
  581.                     $center_zoom = 4;
  582.                     break;
  583.             }
  585.             $custom_breadcrumbs[] = [
  586.                 'name' => $Category->getLabel(),
  587.                 'url' => ($Settings->getUri() ? '/' . $Settings->getUri() : $this->generateUrl('homepage')) . $Category->getUri()
  588.             ];
  590.             if($Product->getTemplateKey() == 'printer_types.html.twig' || $Product->getTemplateKey() == 'printer_cartridges.html.twig'){
  591.                 $custom_breadcrumbs[] = [
  592.                     'name' => $Product->getFullLabel(),
  593.                     'url' => ($Settings->getUri() ? '/' . $Settings->getUri() : $this->generateUrl('homepage')) . 'printers/' . $Product->getSlug()
  594.                 ];
  595.             }else{
  596.                 $custom_breadcrumbs[] = [
  597.                     'name' => $Product->getFullLabel(),
  598.                     'url' => ($Settings->getUri() ? '/' . $Settings->getUri() : $this->generateUrl('homepage')) . 'product/' . $Product->getNumber() . '/' . $Product->getSlug()
  599.                 ];
  600.             }
  602.             $this->breadcrumbs->addItem($Category->getLabel(), ($Settings->getUri() ? $Settings->getUri() : $this->generateUrl('homepage') . (!empty($this->Settings->getBaseUri()) ? substr($this->Settings->getBaseUri(),1) . '/' : '')) . $Category->getUri());
  604.             $this->breadcrumbs->addItem($Product->getFullLabel(), ($Settings->getUri() ? $Settings->getUri() : $this->generateUrl('homepage') . (!empty($this->Settings->getBaseUri()) ? substr($this->Settings->getBaseUri(),1) . '/' : '')) . 'product/' . $Product->getNumber() . '/' . $Product->getSlug());
  605.             // Validate
  606.             if(!$Product->getEnabled()){
  607.                 throw $this->createNotFoundException('Product ' . $Product->getId() . ' not found');
  608.             }
  610.             $Page->setTitle($Product->getLabel());
  612.             // Prepare specs
  613.             $specsList = [];
  614.             $specs = [];
  615.             foreach($Product->getCategory() as $_Category){
  616.                 foreach($_Category->getCategory()->getSpecGroups() as $_SpecGroup){
  617.                     if(!$this->Webshop->getSpecGroups()->contains($_SpecGroup)) continue;
  618.                     foreach($_SpecGroup->getSpecs() as $_Spec){
  619.                         if(!$Webshop->getSpecs()->contains($_Spec)) continue;
  620.                         $specsList[] = $_Spec;
  621.                     }
  622.                 }
  623.             }
  625.             foreach($Product->getSpecGroups() as $_SpecGroup){
  626.                 if(!$this->Webshop->getSpecGroups()->contains($_SpecGroup)) continue;
  627.                 foreach($_SpecGroup->getSpecs() as $_Spec){
  628.                     if(!$Webshop->getSpecs()->contains($_Spec)) continue;
  629.                     $specsList[] = $_Spec;
  630.                 }
  631.             }
  633.             /*foreach($Product->getLinkedProducts()->first()->getSpecGroups() as $_SpecGroup){
  634.                 if(!$this->Webshop->getSpecGroups()->contains($_SpecGroup)) continue;
  635.                 foreach($_SpecGroup->getSpecs() as $_Spec){
  636.                     if(!$Webshop->getSpecs()->contains($_Spec)) continue;
  637.                     $specsList[] = $_Spec;
  638.                 }
  639.             }*/
  641.             $selectSpecs = [];
  642.             $specsSorted = [];
  644.             foreach($specsList as $_Spec){
  645.                 if($_Spec->getHidden() == true) { continue; }
  646.                 if($_Spec->getOptDetail() != true) { continue; }
  648.                 if($_Spec->getType() == 'dropdown'){
  649.                     $default = [];
  650.                     $available = $this->getDoctrine()->getRepository('TrinityWebshopBundle:SpecValue')->findBy(['spec' => $_Spec], ['position' => 'asc']);
  651.                     $SpecValues = $this->getDoctrine()->getRepository('TrinityWebshopBundle:SpecValue')->findValuesByProduct(
  652.                         $_Spec,
  653.                         $Product
  654.                     );
  655.                 }else{
  656.                     $default = '';
  657.                     $available = null;
  658.                     $SpecValues = $this->getDoctrine()->getRepository('TrinityWebshopBundle:SpecValue')->findValuesByProduct(
  659.                         $_Spec,
  660.                         $Product
  661.                     );
  662.                 }
  665.                 if($_Spec->getMultiple() && $_Spec->getChooseMultiple() && !empty($SpecValues)){
  666.                     $selectSpecs[$_Spec->getId()] = ['Spec' => $_Spec, 'values' => $SpecValues];
  667.                 }
  669.                 $groups = [];
  670.                 $lastGroup = null;
  671.                 if($_Spec->getGroups()->count()){
  672.                     foreach($_Spec->getGroups() as $_SpecGroup){
  673.                         $lastGroup = $_SpecGroup;
  674.                         $groups[] = $_SpecGroup->getLabel();
  675.                     }
  676.                 }
  678.                 $spdata = [
  679.                     'id'         => $_Spec->getId(),
  680.                     'label'      => $_Spec->getLabel(),
  681.                     'code'       => $_Spec->getCode(),
  682.                     'value'      => (!empty($SpecValues) ? $SpecValues : $default),
  683.                     'available'  => $available,
  684.                     'groups'     => $groups,
  685.                     'multiple'   => $_Spec->getMultiple(),
  686.                     'choose'     => $_Spec->getChooseMultiple(),
  687.                     'required'   => $_Spec->getRequired(),
  688.                     'type'       => $_Spec->getType(),
  689.                     'hidden'     => $_Spec->getHidden(),
  691.                     'opt_filter' => $_Spec->getOptFilter(),
  692.                     'opt_detail' => $_Spec->getOptDetail(),
  693.                 ];
  695.                 $specs[$_Spec->getId()] = $spdata;
  697.                 if($lastGroup){
  698.                     $specsSorted[$lastGroup->getLabel()][$_Spec->getId()] = $spdata;
  699.                 }
  700.             }
  702.             // dump($specs);die();
  704.             $MatchLinked = null;
  705.             $FirstLinked = null;
  706.             $OriginalProduct = $Product;
  709.             $filterTarget = [];
  710.             $filterTarget_readable = [];
  711.             if(!empty($_GET['filter'])){
  712.                 foreach($_GET['filter'] as $spec_id => $options){
  713.                     $Spec = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Spec')->find($spec_id);
  714.                     foreach($options as $v){
  715.                         $SpecValue = $this->getDoctrine()->getRepository('TrinityWebshopBundle:SpecValue')->findOneBy(['spec' => $Spec, 'value' => $v]);
  716.                         if(!empty($SpecValue)){
  717.                             $filterTarget[] = $spec_id . '+' . $SpecValue->getId();
  718.                             $filterTarget_readable[] = $Spec->getLabel() . '(' . $spec_id . ')+' . $SpecValue->getValue() . '(' . $SpecValue->getId() . ')';
  719.                         }
  720.                     }
  721.                 }
  722.             }
  724.             $configHex = [];
  725.             $configSpecs = [];
  726.             $configSpecs_alt = [];
  727.             $configSpecs_done = [];
  728.             $configSpecs_data = [];
  729.             $configSpecsObjects = [];
  730.             $usedSpecIds = [];
  731.             if($Product->getType() == 1){
  732.                 // Prepare specs
  733.                 $configSpecs = [];
  734.                 $configSpecs_pos = [];
  735.                 foreach($Product->getLinkedProducts() as $LinkedProduct){
  736.                     if($LinkedProduct->getEnabled()){
  737.                     foreach($LinkedProduct->getSpecValues() as $SpecValue){
  739.                         $configHex[$SpecValue->getValue()] = $SpecValue->getHex();
  741.                         /* if($FirstLinked == null){
  742.                             $FirstLinked = $LinkedProduct;
  743.                         } */
  744.                         $Spec = $SpecValue->getSpec();
  753.                         if(!is_null($Spec) && ($Spec->getType() == 'dropdown' || $Spec->getType() == 'color')){
  754.                             if(!$Spec->getChooseMultiple()){
  755.                                 if($Spec->getOptFilter() != true) { continue; }
  756.                                 $configSpecs_pos[$Spec->getId()] = $Spec->getPosition();
  758.                                 $groups = [];
  759.                                 if($Spec->getGroups()->count()){
  760.                                     foreach($Spec->getGroups() as $_SpecGroup){
  761.                                         $groups[] = $_SpecGroup->getLabel();
  762.                                     }
  763.                                 }
  765.                                 // Required for parent
  766.                                 $specs[$Spec->getId()] = [
  767.                                     'id'         => $Spec->getId(),
  768.                                     'label'      => $Spec->getLabel(),
  769.                                     'code'       => $Spec->getCode(),
  770.                                     'value'      => null,
  771.                                     'available'  => null,
  772.                                     'groups'     => $groups,
  773.                                     'multiple'   => $Spec->getMultiple(),
  774.                                     'choose'     => $Spec->getChooseMultiple(),
  775.                                     'required'   => $Spec->getRequired(),
  776.                                     'type'       => $Spec->getType(),
  778.                                     'opt_filter' => $Spec->getOptFilter(),
  779.                                     'opt_detail' => $Spec->getOptDetail(),
  780.                                     // 'hidden'    => $Spec->getHidden(),
  781.                                 ];
  783.                                 /*if($Spec->getMultiple() && $Spec->getChooseMultiple()){
  784.                                     $selectSpecs[$Spec->getId()] = $Spec;
  785.                                 }*/
  787.                                 $configSpecsObjects[$SpecValue->getId()] = $SpecValue;
  789.                                 // if($Spec->getOptDetail()){
  790.                                     if(!isset($configSpecs[$Spec->getId()][$SpecValue->getPosition() . '+' . $SpecValue->getId()])){
  791.                                         $configSpecs[$Spec->getId()][$SpecValue->getPosition() . '+' . $SpecValue->getId()] = [];
  792.                                     }
  793.                                     $configSpecs[$Spec->getId()][$SpecValue->getPosition() . '+' . $SpecValue->getId()][] = $LinkedProduct->getId();
  794.                                     $configSpecs_alt[$Spec->getId() . '+' . $SpecValue->getId()][] = $LinkedProduct->getId();
  796.                                     //ksort($configSpecs[$Spec->getId()]);
  798.                                     $usedSpecIds[] = $Spec->getId();
  799.                                 // }
  800.                             }
  801.                         }
  802.                     }
  803.                 }
  804.             }
  805.             }
  815.             $sorted = [];
  817.             if(!empty($configSpecs_pos)){
  818.                 asort($configSpecs_pos);
  819.                 foreach($configSpecs_pos as $k => $pos){
  820.                     $sorted[$k] = [];
  821.                 }
  822.             }
  825.             // Sort configSpecs afterwards
  826.             foreach($configSpecs as $specid => $values){
  827.                 foreach($values as $k => $v){
  828.                     $k = explode('+', $k);
  830.                     $sorted[$specid][$k[0]][$k[1]] = $v;
  831.                     ksort($sorted[$specid]);
  832.                 }
  833.             }
  835.             $configSpecs = [];
  836.             foreach($sorted as $specid => $d1){
  837.                 foreach($d1 as $sort => $d2){
  838.                     foreach($d2 as $svid => $vs){
  839.                         $configSpecs[$specid][$sort . '+' . $svid] = $vs;
  840.                     }
  841.                 }
  842.             }
  845.             // Find child product by filters
  846.             $foundCount = [];
  847.             foreach($filterTarget as $targetSpec){
  848.                 if(!empty($configSpecs_alt[$targetSpec])){
  849.                     // dump($configSpecs_alt[$targetSpec]);die();
  850.                     if(count($configSpecs_alt[$targetSpec]) > 0){
  851.                         foreach($configSpecs_alt[$targetSpec] as $id){
  852.                             if(empty($foundCount[$id])) $foundCount[$id] = 0;
  853.                             $foundCount[$id]++;
  854.                         }
  855.                         // $FirstLinked = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->find($configSpecs_alt[$targetSpec][0]);
  856.                     }
  857.                 }
  858.             }
  860.             foreach($foundCount as $id => $count){
  861.                 if($count == count($filterTarget)){
  862.                     $FirstLinked = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->find($id);
  863.                 }
  864.             }
  871.             foreach($configSpecs as $spec_id => $values){
  872.                 foreach($values as $pos_data => $links){
  873.                     $pos_data = explode('+', $pos_data);
  874.                     $configSpecs_done[$spec_id][$configSpecsObjects[$pos_data[1]]->getValue()] = $links;
  875.                     $configSpecs_data[$spec_id][$configSpecsObjects[$pos_data[1]]->getValue()] = $configSpecsObjects[$pos_data[1]]->getId();
  876.                 }
  877.             }
  880.             /*foreach($usedSpecIds as $id){
  881.                 ksort($configSpecs[$id]);
  882.             }*/
  884.             // dump($configSpecs);die();
  887.             // Update views
  888.             $em = $this->getDoctrine()->getManager();
  889.             $Product->setViews((int)$Product->getViews() + 1);
  891.             // Update real selling price
  892.             /*if($this->containerInterface->getParameter('kernel.environment') == 'dev'){
  893.                 dump($Product->getRealPrice());
  894.                 dump($Product->getRealPriceIncl());
  895.                 die();
  896.             }*/
  899.             /* if($FirstLinked){
  900.                 if($Product->getSellPrice() != $FirstLinked->getSellPrice()){
  901.                     $Product->setSellPrice($FirstLinked->getSellPrice());
  902.                 }
  903.                 if($Product->getSellPriceIncl() != $FirstLinked->getSellPriceIncl()){
  904.                     $Product->setSellPriceIncl($FirstLinked->getSellPriceIncl());
  905.                 }
  906.             }else{
  907.                 $Product->setSellPrice($Product->getRealPrice());
  908.                 $Product->setSellPriceIncl($Product->getRealPriceIncl());
  909.             } */
  913.             $em->persist($Product);
  914.             $em->flush();
  916.             if($FirstLinked){
  917.                 $Alt = $Product;
  918.                 if($this->WebshopSettings->getInitializeConfigurable()){
  919.                     // Keep configurable global
  920.                     $Alt = $FirstLinked;
  921.                 }else{
  922.                     $Product = $FirstLinked;
  923.                 }
  925.                 // Prepare specs
  926.                 $specsList = [];
  927.                 $specs = [];
  928.                 foreach($FirstLinked->getCategory() as $_Category){
  929.                     foreach($_Category->getCategory()->getSpecGroups() as $_SpecGroup){
  930.                         if(!$this->Webshop->getSpecGroups()->contains($_SpecGroup)) continue;
  931.                         foreach($_SpecGroup->getSpecs() as $_Spec){
  932.                             if(!$Webshop->getSpecs()->contains($_Spec)) continue;
  933.                             $specsList[] = $_Spec;
  934.                         }
  935.                     }
  936.                 }
  938.                 foreach($FirstLinked->getSpecGroups() as $_SpecGroup){
  939.                     if(!$this->Webshop->getSpecGroups()->contains($_SpecGroup)) continue;
  940.                     foreach($_SpecGroup->getSpecs() as $_Spec){
  941.                         if(!$Webshop->getSpecs()->contains($_Spec)) continue;
  942.                         $specsList[] = $_Spec;
  943.                     }
  944.                 }
  946.                 // dump($specsList);die();
  948.                 $selectSpecs = [];
  950.                 foreach($specsList as $_Spec){
  951.                     if($_Spec->getHidden() == true) continue;
  953.                     if($_Spec->getType() == 'dropdown'){
  954.                         $default = [];
  955.                         $available = $this->getDoctrine()->getRepository('TrinityWebshopBundle:SpecValue')->findBy(['spec' => $_Spec], ['position' => 'asc']);
  956.                         $SpecValues = $this->getDoctrine()->getRepository('TrinityWebshopBundle:SpecValue')->findValuesByProduct(
  957.                             $_Spec,
  958.                             $Product
  959.                         );
  960.                     }else{
  961.                         $default = '';
  962.                         $available = null;
  963.                         $SpecValues = $this->getDoctrine()->getRepository('TrinityWebshopBundle:SpecValue')->findValuesByProduct(
  964.                             $_Spec,
  965.                             $Product
  966.                         );
  967.                     }
  970.                     if($_Spec->getMultiple() && $_Spec->getChooseMultiple() && !empty($SpecValues)){
  971.                         $selectSpecs[$_Spec->getId()] = ['Spec' => $_Spec, 'values' => $SpecValues];
  972.                     }
  974.                     $groups = [];
  975.                     if($_Spec->getGroups()->count()){
  976.                         foreach($_Spec->getGroups() as $_SpecGroup){
  977.                             $groups[] = $_SpecGroup->getLabel();
  978.                         }
  979.                     }
  981.                     $specs[$_Spec->getId()] = [
  982.                         'id'         => $_Spec->getId(),
  983.                         'label'      => $_Spec->getLabel(),
  984.                         'code'       => $_Spec->getCode(),
  985.                         'value'      => (!empty($SpecValues) ? $SpecValues : $default),
  986.                         'available'  => $available,
  987.                         'groups'     => $groups,
  988.                         'multiple'   => $_Spec->getMultiple(),
  989.                         'choose'     => $_Spec->getChooseMultiple(),
  990.                         'required'   => $_Spec->getRequired(),
  991.                         'type'       => $_Spec->getType(),
  992.                         'opt_filter' => $_Spec->getOptFilter(),
  993.                         'opt_detail' => $_Spec->getOptDetail(),
  994.                         'hidden'     => $_Spec->getHidden(),
  995.                     ];
  996.                 }
  997.             }
  999.             // dump($specs); die();
  1001.             // Find favorite products
  1002.             $isLinked = false;
  1003.             $WebshopUser = $this->getDoctrine()->getRepository('TrinityWebshopBundle:User')->findOneByUser($this->getUser());
  1004.             if($WebshopUser){
  1005.                 foreach($WebshopUser->getProductList() as $ItemList){
  1006.                     foreach($ItemList->getProducts() as $p){
  1007.                         if($p == $Product){
  1008.                             $isLinked = true;
  1009.                         }
  1010.                     }
  1011.                 }
  1012.             }
  1014.             $metatags       = $this->getDoctrine()->getRepository('CmsBundle:Metatag')->getBySystem(0, (int)$Page->getId(), true);
  1015.             $systemMetatags = $this->getDoctrine()->getRepository('CmsBundle:Metatag')->getBySystem(1, false, false);
  1020.             $children_count = [];
  1021.             $children = [];
  1024.             $carFilterName = ['merk' => '', 'model' => '', 'bouwjaar' => ''];
  1025.             $rootCategory = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Category')->findOneByLabel('Onderdelen');
  1026.             if(!empty($rootCategory)){
  1027.                 $spec_filter_checked = [];
  1028.                 foreach($Product->getSpecValues() as $SV){
  1029.                     $Spec = $SV->getSpec();
  1030.                     if(!empty($Spec) && in_array($Spec->getId(), [265, 266, 267])){
  1032.                         if($Spec->getId() == 265){
  1033.                             $carFilterName['merk'] = $SV->getValue();
  1034.                         }
  1035.                         if($Spec->getId() == 266){
  1036.                             $carFilterName['model'] = $SV->getValue();
  1037.                         }
  1038.                         if($Spec->getId() == 267){
  1039.                             $carFilterName['bouwjaar'] = $SV->getValue();
  1040.                         }
  1042.                         $spec_filter_checked[$Spec->getId()] = $SV->getValue();
  1043.                     }
  1044.                 }
  1047.                 if(!empty($spec_filter_checked)){
  1048.                     $children_raw = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Category')->findCategoriesWithSpecs($rootCategory, $spec_filter_checked, 'root');
  1049.                     foreach($children_raw as $c){
  1050.                         if($c['id']){
  1051.                             $children[] = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Category')->find($c['id']);
  1052.                             $children_count[$c['id']] = $c['num'];
  1053.                         }
  1054.                     }
  1055.                 }
  1056.             }
  1058.             $category_view_query = '?merk=' . $carFilterName['merk'] . '&model=' . $carFilterName['model'] . '&bouwjaar=' . $carFilterName['bouwjaar'] . '';
  1060.             $carFilterName = implode(' ', $carFilterName);
  1065.             
  1074.             $total_rating = ['total' => 0, 'rating_total' => 0, 'avg' => 0];
  1075.             $total_rating_raw = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Review')->productTotal($Product->getId());
  1076.             $total_rating_rawTwo = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Review')->countTotalByProduct($Product->getId());
  1077.             if(!empty($total_rating_raw[0])){
  1078.                 $total_rating = $total_rating_raw[0];
  1079.             }
  1080.             if(!empty($total_rating_rawTwo)){
  1081.                 $total_rating['total'] = $total_rating_rawTwo;
  1082.             }
  1084.             $total_rating['avg_up'] = (ceil($total_rating['avg'] * 2) / 2);
  1100.     
  1101.             $specs_disabled_format = [];
  1102.             $simpSpec = $Product->getSimplifiedSpecValues(true);
  1103.             if(!empty($simpSpec)){
  1104.                 $svid = $simpSpec['svid'];
  1105.                 $checkSpec = $simpSpec['Spec'];
  1106.                 
  1107.                 $tmp_all = [];
  1108.                 $tmp_enabled = [];
  1109.                 $tmp_disabled = [];
  1110.                 $tmp_matching = [];
  1111.                 $sv_obj = [];
  1113.                 foreach($OriginalProduct->getLinkedProducts() as $ChildProduct){
  1114.                     foreach($ChildProduct->getSpecValues() as $SV){
  1115.                         if($svid){
  1116.                             if($SV->getId() == $svid){
  1117.                                 $tmp_matching[] = $ChildProduct;
  1118.                             }else{
  1119.                                 if($checkSpec != $SV->getSpec()){
  1120.                                     $tmp_all[$SV->getId()] = $SV->getValue();
  1121.                                     $sv_obj[$SV->getId()] = $SV;
  1122.                                 }
  1123.                             }
  1124.                         }else{
  1125.                             $tmp_matching[] = $ChildProduct;
  1126.                             $tmp_all[$SV->getId()] = $SV->getValue();
  1127.                             $sv_obj[$SV->getId()] = $SV;
  1128.                         }
  1129.                     }
  1130.                 }
  1132.                 foreach($tmp_matching as $ChildProduct){
  1133.                     foreach($ChildProduct->getSpecValues() as $SV){
  1134.                         if($checkSpec != $SV->getSpec() && $ChildProduct->canOrder()){
  1135.                             $tmp_enabled[$SV->getId()] = $SV->getValue();
  1136.                             $sv_obj[$SV->getId()] = $SV;
  1137.                         }
  1138.                     }
  1139.                 }
  1142.                 $tmp_disabled = array_diff($tmp_all, $tmp_enabled);
  1144.                 foreach($tmp_disabled as $svid => $svlabel){
  1145.                     if(!empty($sv_obj[$svid]->getSpec())){
  1146.                         $specs_disabled_format[$sv_obj[$svid]->getSpec()->getId()][] = $svlabel;
  1147.                     }
  1148.                 }
  1149.             }
  1155.             
  1156.             
  1157.             if($Settings->getPicqerChoice() == 1 && !empty($Settings->getPicqerApikey()) && !empty($Settings->getPicqerUrl())){
  1158.                 $Picqer = new Picqer($Settings->getPicqerApikey(), $Settings->getPicqerUrl());
  1160.                 if($Settings->getPicqerFulfillment()){
  1161.                     if(!empty($Settings->getPicqerFulfillmentId())){
  1162.                         $fulfilment_id = $Settings->getPicqerFulfillmentId();
  1163.                     } else {
  1164.                         $fulfilment_id = null;
  1165.                     }
  1166.                 } else {
  1167.                     $fulfilment_id = null;
  1168.                 }
  1170.                 $stock = $Picqer::checkStock($Product, $fulfilment_id);
  1172.                 if($stock !== "Product not found in Picqer" && $stock !== "Product empty"){
  1173.                     if($Product->getStockAmount() != $stock){
  1174.                         $Product->setStockAmount($stock);
  1175.                     }
  1176.                 }
  1177.             }
  1179.             if(preg_match('/price_incl.*?(asc|desc)/', $sort, $m)){
  1180.                 $sort = 'sell_price ' . $m[1];
  1181.             }
  1184.             $products_data = [];
  1185.             $priceRange = [(int)$Product->getMin(),(int)$Product->getMax()];
  1186.             if($Product->getTemplateKey() == 'printer_cartridges.html.twig'){
  1187.                 // Currently Pelikan specific
  1188.                 $spec_filter_checked = [];
  1189.                 $get_q = '';
  1190.                 $get_qo = '';
  1192.                 $products_data = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->search(null, array(
  1193.                     'spec_filter_checked' => $spec_filter_checked,
  1194.                     'relation' => $Product,
  1195.                     'visible' => true,
  1196.                     'page' => 1,
  1197.                     /*'limit' => [
  1198.                         'start' => 0,
  1199.                         'limit' => 9
  1200.                     ],*/
  1201.                     'q' => $get_q,
  1202.                     'qo' => $get_qo,
  1203.                     'filters' => $spec_filter_checked,
  1204.                 ), $sort, $sort_dir, ($Settings->getPagination() == 'none'), false, (!empty($_GET['page']) && is_numeric($_GET['page']) ? $_GET['page'] : 1), $this->WebshopSettings->getPerPage());
  1206.             }
  1209.             $activeRelations = [];
  1210.             foreach($Product->getRelations() as $Relation){
  1211.                 if($Relation->getEnabled() && $Relation->getVisible()){
  1212.                     $activeRelations[] = $Relation;
  1213.                 }
  1214.             }
  1215.             //dump($Product->getId());
  1216.             //dump($Product->getRelations()->count());
  1217.             //dump($activeRelations);die();
  1220.             $canonical_url = '';
  1221.             $foundCategory = null;
  1223.             foreach ($Product->getCategory() as $catProd)
  1224.             {
  1225.                 if (empty($foundCategory)) {
  1226.                     $foundCategory = $catProd->getCategory();
  1227.                 } else if ($Settings->getCanonicalType() == 'first-main-cat') {
  1228.                     if (!empty($foundCategory->getParent()) && $foundCategory->getParent()->getId() == $catProd->getCategory()->getId()) {
  1229.                         $foundCategory = $catProd->getCategory();
  1230.                     }
  1231.                 } else if (is_null($Settings->getCanonicalType()) || $Settings->getCanonicalType() == 'first-sub-cat') {
  1232.                     $subCat = $catProd->getCategory();
  1233.                     $tempCat = null;
  1234.                     $subLoop = true;
  1236.                     do {
  1237.                         if (!empty($subCat->getParent()) &&
  1238.                             $subCat->getParent()->getId() == $foundCategory->getId()) {
  1239.                             $tempCat = $subCat;
  1240.                         } else if (!empty($subCat->getParent()) &&
  1241.                                    !empty($subCat->getParent()->getParent()) &&
  1242.                                    $subCat->getParent()->getParent()->getId() == $foundCategory->getId()) {
  1243.                             $tempCat = $subCat;
  1244.                         } else if (!empty($subCat->getParent()) && 
  1245.                                    !empty($subCat->getParent()->getParent()) &&
  1246.                                    !empty($subCat->getParent()->getParent()->getParent()) &&
  1247.                                    $subCat->getParent()->getParent()->getParent()->getId() == $foundCategory->getId()) {
  1248.                             $tempCat = $subCat;
  1249.                         } else {
  1250.                             $subLoop = false;
  1251.                         }
  1253.                         $subCat = $subCat->getParent();
  1254.                     } while ($subLoop);
  1256.                     if (!empty($tempCat)) {
  1257.                         $foundCategory = $tempCat;
  1258.                     }
  1259.                 }
  1260.             }
  1262.             if (!empty($foundCategory)) {
  1263.                 $canonical_url = $foundCategory->getUri() . '/' . $Product->getSlug();
  1264.             }
  1266.             $Product = $this->parseEntityPageUrls($Product);
  1267.             $Settings = $this->parseSettingsPageUrls($Settings);
  1269.             $specsByGroup = [];
  1270.             foreach($specs as $id => $spec){
  1271.                 if(!empty($spec['groups'])){
  1272.                     foreach($spec['groups'] as $g){
  1273.                         $specsByGroup[$g][$id] = $spec;
  1274.                     }
  1275.                 }else{
  1276.                     $specsByGroup['Default'][$id] = $spec;
  1277.                 }
  1278.             }
  1280.             if($this->Meta && !empty($Product)){
  1281.                 $this->Meta->registerView($request, 'webshop_product', $Product->getId(), $Product->getLabel());
  1282.             }
  1284.             $response = $this->render('@TrinityWebshop/front/product.html.twig', $this->attributes([
  1285.                 'Category'              => $Category,
  1286.                 'Product'               => $Product,
  1287.                 'OriginalProduct'       => $OriginalProduct,
  1288.                 'firstAvailable'        => $firstAvailable,
  1289.                 'configHex'             => $configHex,
  1290.                 'specs'                 => $specs,
  1291.                 'specsSorted'           => $specsSorted,
  1292.                 'specsByGroup'          => $specsByGroup,
  1293.                 'configSpecs'           => $configSpecs_done,
  1294.                 'configSpecsIds'        => $configSpecs_data,
  1295.                 'selectSpecs'           => $selectSpecs,
  1296.                 'metatags'              => $metatags,
  1297.                 'systemMetatags'        => $systemMetatags,
  1298.                 'Page'                  => $Page,
  1299.                 'usedSpecIds'           => $usedSpecIds,
  1300.                 
  1301.                 'products_data'         => $products_data,
  1302.                 'priceRange'            => $priceRange,
  1303.                 'sort'                  => $sort,
  1305.                 'productHistoryObjects' => (array)$productHistoryObjects,
  1306.                 'productRelatedObjects' => (array)$productRelatedObjects,
  1307.                 'WebshopSettings'       => $Settings,
  1308.                 'isLinked'              => $isLinked,
  1309.                 'bodyClass'             => 'product-detail',
  1310.                 'custom_breadcrumbs'    => $custom_breadcrumbs,
  1311.                 'locale'                => '',
  1312.                 'center_lat'            => $center_lat,
  1313.                 'center_lng'            => $center_lng,
  1314.                 'center_zoom'           => $center_zoom,
  1315.                 'specs_disabled'        => $specs_disabled_format,
  1316.                 'category_view'         => $children,
  1317.                 'category_view_count'   => $children_count,
  1318.                 'category_view_query'   => $category_view_query,
  1319.                 'canonical_url'         => $canonical_url,
  1320.                 'carFilterName'         => $carFilterName,
  1321.                 'total_rating'          => $total_rating,
  1322.                 'activeRelations'       => $activeRelations,
  1323.                 'recipes'               => $recipes,
  1324.                 'RecipesPage' => $RecipesPage,
  1325.             ]));
  1327.             if ($allowCache) {
  1328.                 $Product->setCacheData($response->getContent());
  1329.             }
  1331.             //$response = $this->responseRewriteOutput($response, false, false);
  1333.             return $response;
  1334.         }
  1336.         /**
  1337.          * 
  1338.          * 
  1339.          *     ==============================================================================================================
  1340.          *     ==============================================================================================================
  1341.          *     ==============================================================================================================
  1342.          *     ==============================================================================================================
  1343.          * 
  1344.          *     ROOT CATEGORY OVERVIEW
  1345.          * 
  1346.          *     ==============================================================================================================
  1347.          *     ==============================================================================================================
  1348.          *     ==============================================================================================================
  1349.          *     ==============================================================================================================
  1350.          * 
  1351.          * 
  1352.          */
  1353.         elseif($Category != null && $Category->getShowSubCategories()){
  1354.             /*
  1355.                 Categorie shows sub categories, not products
  1356.              */
  1357.             $Category = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Category')->find($request->get('categoryId'));
  1358.             $Page->setTitle($Category->getLabel());
  1360.             $allRootCategories = [];
  1361.             if($Category->getShowAll()){
  1362.                 $allRootCategories = $this->getDoctrine()->getRepository(Category::class)->findBy(['parent' => null], ['position' => 'asc']);
  1363.             }
  1365.             $children = [];
  1366.             $doSearch = false;
  1370.             $noResults = false;
  1371.             if(!empty($_GET['r']) && $_GET['r'] == 'no-results'){
  1372.                 $noResults = true;
  1373.             }
  1378.             $brandAndModelArr = [];
  1379.             $brandAndModel = '[]';
  1380.             $cachedir = preg_replace('/src\/.*?$/', '', __DIR__) . 'var/cache/';
  1381.             if(file_exists($cachedir . 'brands_sorted.json')){
  1382.                 $brandAndModelArr_tmp = json_decode(file_get_contents($cachedir . 'brands_sorted.json'), true);
  1383.                 $brandAndModelArr = [];
  1384.                 if(!is_array($brandAndModelArr_tmp)) $brandAndModelArr_tmp = [];
  1385.                 else{
  1386.                     if(!empty($brandAndModelArr_tmp[$Category->getId()])){
  1387.                         $brandAndModelArr = $brandAndModelArr_tmp[$Category->getId()];
  1388.                     }
  1389.                 }
  1390.                 $brandAndModel = json_encode($brandAndModelArr);
  1391.             }
  1394.             $typesArr = [];
  1395.             $types = '[]';
  1396.             $cachedir = preg_replace('/src\/.*?$/', '', __DIR__) . 'var/cache/';
  1397.             if(file_exists($cachedir . 'types_sorted.json')){
  1398.                 $typesArr_tmp = json_decode(file_get_contents($cachedir . 'types_sorted.json'), true);
  1399.                 $typesArr = [];
  1400.                 if(!is_array($typesArr_tmp)) $typesArr_tmp = [];
  1401.                 else{
  1402.                     if(!empty($typesArr_tmp[$Category->getId()])){
  1403.                         $typesArr = $typesArr_tmp[$Category->getId()];
  1404.                     }
  1405.                 }
  1406.                 $types = json_encode($typesArr);
  1407.             }
  1411.             $spec_query = '';
  1412.             $spec_filter = [];
  1413.             $licenseplate = null;
  1414.             if (!$Settings->getDisableRememberSearch()) {
  1415.                 if(!empty($this->get('session')->get('ecomm_spec_filter'))){
  1416.                     $spec_filter = $this->get('session')->get('ecomm_spec_filter');
  1417.                 }
  1418.                 if(!empty($this->get('session')->get('ecomm_spec_plate'))){
  1419.                     $licenseplate = $this->get('session')->get('ecomm_spec_plate');
  1420.                 }
  1422.                 /*if(!empty($this->get('session')->get('ecomm_spec_query'))){
  1423.                     $spec_query = $this->get('session')->get('ecomm_spec_query');
  1424.                 }*/
  1425.             }
  1430.             if(!empty($_GET['clearplate'])){
  1431.                 $licenseplate = '';
  1432.                 $spec_filter = [];
  1433.                 $this->get('session')->set('ecomm_spec_plate', '');
  1434.                 $this->get('session')->set('ecomm_spec_filter', []);
  1435.             }
  1440.             /*$BrandsSpec = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Spec')->findOneBy(['label' => 'Merk']);
  1441.             $ModelsSpec = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Spec')->findOneBy(['label' => 'Model']);*/
  1442.         
  1443.             $category_label = '';
  1444.             if(!empty($_GET['c'])){
  1445.                 $C = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Category')->find($_GET['c']);
  1446.                 $category_label = $C->getLabel();
  1447.             }
  1449.             if(!empty($_GET['q']) && $_GET['q'] != 'undefined'){
  1450.                 $spec_query = $_GET['q'];
  1451.                 // $this->get('session')->set('ecomm_spec_query', $_GET['q']);
  1452.             }else{
  1453.                 if(isset($_GET['q'])){
  1454.                     // $this->get('session')->set('ecomm_spec_query', '');
  1455.                 }
  1456.             }
  1460.             if(!empty($spec_query)){
  1461.                 $spec_query_tmp = explode(' ', $spec_query);
  1463.                 $modelsToSearch = [];
  1464.                 foreach($spec_query_tmp as $qpi => $qp){
  1465.                     foreach($brandAndModelArr as $brand => $models){
  1466.                         if(strtolower($brand) == strtolower($qp)){
  1467.                             $spec_filter['Merk'] = $brand;
  1468.                             unset($spec_query_tmp[$qpi]);
  1469.                             $modelsToSearch = $models;
  1470.                             break;
  1471.                         }
  1472.                     }
  1473.                 }
  1474.                 foreach($spec_query_tmp as $qpi => $qp){
  1475.                     foreach($modelsToSearch as $model){
  1476.                         if(strtolower($model) == strtolower($qp)){
  1477.                             $spec_filter['Model'] = $model;
  1478.                             unset($spec_query_tmp[$qpi]);
  1479.                             break;
  1480.                         }
  1481.                     }
  1482.                 }
  1483.                 $spec_query = implode(' ', $spec_query_tmp);
  1484.             }
  1489.             if($spec_query == 'undefined'){
  1490.                 $spec_query = '';
  1491.                 // $this->get('session')->set('ecomm_spec_query', '');
  1492.             }
  1494.             if(!empty($_GET['merk'])){
  1495.                 $spec_filter['Merk'] = $_GET['merk'];
  1496.                 if(!empty($_GET['model'])){
  1497.                     $spec_filter['Model'] = $_GET['model'];
  1498.                     if(!empty($_GET['bouwjaar'])){
  1499.                         $spec_filter['Bouwjaar'] = $_GET['bouwjaar'];
  1500.                     }
  1501.                 }
  1502.                 $this->get('session')->set('ecomm_spec_filter', $spec_filter);
  1503.             }
  1505.             if(!empty($_GET['type']) && $_GET['type'] != 'Alle onderdelen'){
  1506.                 $spec_filter['Type Onderdeel'] = $_GET['type'];
  1507.                 $this->get('session')->set('ecomm_spec_filter', $spec_filter);
  1508.             }else{
  1509.                 if(isset($_GET['type']) && isset($spec_filter['Type Onderdeel'])){
  1510.                     unset($spec_filter['Type Onderdeel']);
  1511.                     $this->get('session')->set('ecomm_spec_filter', $spec_filter);
  1512.                 }
  1513.             }
  1515.             if(!empty($_GET['licenseplate'])){
  1516.                 $licenseplate = $_GET['licenseplate'];
  1517.             }
  1522.             $model = null;
  1523.             $type = null;
  1524.             $year = null;
  1526.             if(!empty($licenseplate)){
  1527.                 $api_url = 'https://services.onderdelenlijn.nl/parts/v7.asmx?WSDL';
  1529.                 $user = 'info@beyonit.nl';
  1530.                 $pass = 'fUAJT6!XP';
  1532.                 $Webshop = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Webshop')->getByLanguageAndSettings($this->language, $this->Settings);
  1533.                 
  1535.                 $SOAP_LOCATION_APP = $api_url;
  1536.                 $soapClient = new \SoapClient($SOAP_LOCATION_APP, ["trace" => 1, "exception" => 0, 'cache_wsdl' => WSDL_CACHE_NONE, 'soap_version' => SOAP_1_2]);
  1537.                 $soapMessage = [
  1538.                     'Credentials' => [
  1539.                         'Username' => $user,
  1540.                         'Password' => $pass,
  1541.                     ],
  1542.                     'Parameters' => [
  1543.                         'Culture' => "NL",
  1544.                         'TviRequest' => [
  1545.                             'Type' => 'LicensePlate',
  1546.                             'Value' => $licenseplate
  1547.                         ]
  1548.                     ]
  1549.                 ];
  1550.                 $soapResult = $soapClient->TviData($soapMessage);
  1551.                 $res = json_decode(json_encode($soapResult), true);
  1553.                 if(!empty($res["TviDataResult"]["Result"])){
  1554.                     $array = $res["TviDataResult"]["Result"];
  1556.                     $model = (!empty($array["Basic"]["MakeModel"]["MakeName"]) ? $array["Basic"]["MakeModel"]["MakeName"] : null);
  1557.                     $type  = (!empty($array["Basic"]["MakeModel"]["ModelName"]) ? $array["Basic"]["MakeModel"]["ModelName"] : null);
  1558.                     $year  = (!empty($array["Basic"]["Constructed"]['Year']) ? $array["Basic"]["Constructed"]['Year'] : null);
  1559.                     $month = (!empty($array["Basic"]["Constructed"]['Month']) ? $array["Basic"]["Constructed"]['Month'] : null);
  1561.                     $spec_filter['Merk'] = $model;
  1562.                     $spec_filter['Model'] = $type;
  1563.                     $spec_filter['Bouwjaar'] = $year;
  1565.                 }
  1566.             }
  1582.             if(!empty($spec_filter['Merk']) && $spec_filter['Merk'] == 'Alle merken'){
  1583.                 if($model){
  1584.                     $spec_filter['Merk'] = $model;
  1585.                     $this->get('session')->set('ecomm_spec_filter', $spec_filter);
  1586.                 }else{
  1587.                     unset($spec_filter['Merk']);
  1588.                 }
  1589.             }
  1591.             if(!empty($spec_filter['Model']) && $spec_filter['Model'] == 'Alle modellen'){
  1592.                 if($type){
  1593.                     $spec_filter['Model'] = $type;
  1594.                     $this->get('session')->set('ecomm_spec_filter', $spec_filter);
  1595.                 }else{
  1596.                     unset($spec_filter['Model']);
  1597.                 }
  1598.             }
  1600.             if(!empty($spec_filter['Type Onderdeel']) && $spec_filter['Type Onderdeel'] == 'Alle onderdelen'){
  1601.                 unset($spec_filter['Type Onderdeel']);
  1602.             }
  1615.             if(!empty($_GET['drop'])){
  1616.                 if($_GET['drop'] == 'all'){
  1617.                     // $this->get('session')->set('ecomm_spec_query', '');
  1618.                     $spec_query = '';
  1619.                     $spec_filter = [];
  1620.                     $this->get('session')->set('ecomm_spec_filter', []);
  1621.                     $this->get('session')->set('ecomm_spec_plate', '');
  1622.                 }else if(preg_match('/_/', $_GET['drop'])){
  1623.                     $_GET['drop'] = explode('_', $_GET['drop']);
  1624.                     // $q = explode(' ', $this->get('session')->get('ecomm_spec_query'));
  1625.                     foreach($q as $k => $v){
  1626.                         if($_GET['drop'][1] == $k){
  1627.                             unset($q[$k]);
  1628.                         }
  1629.                     }
  1630.                     $q = implode(' ', $q);
  1631.                     // $this->get('session')->set('ecomm_spec_query', $q);
  1632.                     $spec_query = $q;
  1633.                 }else{
  1634.                     if($_GET['drop'] == 'q'){
  1635.                         // Drop search filter
  1636.                         // $this->get('session')->set('ecomm_spec_query', '');
  1637.                         $spec_query = '';
  1638.                     }else{
  1639.                         // Drop spec filter
  1640.                         $spec_id = $_GET['drop'];
  1641.                         $Spec = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Spec')->find($spec_id);
  1642.                         if(!empty($Spec) && isset($spec_filter[$Spec->getLabel()])){
  1643.                             unset($spec_filter[$Spec->getLabel()]);
  1644.                             $this->get('session')->set('ecomm_spec_filter', $spec_filter);
  1645.                             $this->get('session')->set('ecomm_spec_plate', '');
  1646.                         }
  1647.                     }
  1648.                 }
  1649.             }
  1651.             $spec_filter_checked = [];
  1652.             $filters_visual = [];
  1653.             
  1654.             if(!empty($spec_filter) && is_array($spec_filter)){
  1655.                 foreach($spec_filter as $specLabel => $value){
  1657.                     // TMP IGNORE
  1658.                     if(in_array($specLabel, ['Bouwmaand'])) continue;
  1660.                     $Spec = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Spec')->findOneBy(['label' => $specLabel]);
  1661.                     if(!empty($Spec)){
  1662.                         $spec_filter_checked[$Spec->getId()] = $value;
  1664.                         $filters_visual[$Spec->getId()] = ['label' => ($Spec->getLabel() == 'Model compatibiliteit' ? 'Bouwjaar' : $Spec->getLabel()), 'value' => $value];
  1665.                     }
  1666.                 }
  1667.             }
  1669.             if(!empty($spec_query)){
  1670.                 $spec_filter_checked['q'] = explode(' ', $spec_query);
  1672.                 // $filters_visual['q'] = ['label' => 'Zoeken', 'value' => implode(', ', $spec_filter_checked['q'])];
  1673.                 foreach($spec_filter_checked['q'] as $qpart){
  1674.                     if(!isset($filters_visual['q'])){
  1675.                         $filters_visual['q'] = [];
  1676.                     }
  1677.                     $filters_visual['q'][] = ['label' => 'Zoeken', 'value' => $qpart];
  1678.                 }
  1679.             }
  1681.             $level = 'root';
  1682.             if(count($Category->getParents()) > 0){
  1683.                 $level = 'sub';
  1684.             }
  1688.             if($level == 'sub'){
  1689.                 $custom_breadcrumbs[] = [
  1690.                     'name' => $Category->getParent()->getLabel(),
  1691.                     'url' => ($Settings->getUri() ? '/' . $Settings->getUri() : $this->generateUrl('homepage')) . $Category->getParent()->getUri()
  1692.                 ];
  1693.             }
  1695.             $custom_breadcrumbs[] = [
  1696.                 'name' => $Category->getLabel(),
  1697.                 'url' => ($Settings->getUri() ? '/' . $Settings->getUri() : $this->generateUrl('homepage')) . $Category->getUri()
  1698.             ];
  1701.             $children_count = [];
  1703.             if(!empty($spec_filter_checked)){
  1704.                 $doSearch = true;
  1705.                 $redirectToId = null;
  1707.                 $children = [];
  1708.                 $children_raw = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Category')->findCategoriesWithSpecs($Category, $spec_filter_checked, $level);
  1710.                 // Check if only one category
  1711.                 if(count($children_raw) == 1 && !empty($children_raw[0])){
  1712.                     $tmp_id = $children_raw[0]['id'];
  1713.                     $redirectToId = $children_raw[0]['id'];
  1715.                     // Test sub
  1716.                     $sub_children_raw = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Category')->findCategoriesWithSpecs($tmp_id, $spec_filter_checked, 'sub');
  1717.                     if(count($sub_children_raw) == 1 && !empty($sub_children_raw[0])){
  1718.                         $redirectToId = $sub_children_raw[0]['id'];
  1719.                     }
  1720.                 }
  1723.                 if(!empty($redirectToId)){
  1724.                     // Redirect to category
  1725.                     $CatRedirect = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Category')->find($redirectToId);
  1726.                     return $this->redirectToRoute($CatRedirect->getSlugKey());
  1727.                 }
  1730.                 foreach($children_raw as $c){
  1731.                     if($c['id']){
  1732.                         $children[] = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Category')->find($c['id']);
  1733.                         $children_count[$c['id']] = $c['num'];
  1734.                     }
  1735.                 }
  1736.             }
  1743.             if(!$doSearch){
  1744.                 // No search, show categories index
  1745.                 $children = $Category->getChildren();
  1746.                 /*if($this->containerInterface->getParameter('kernel.environment') == 'dev'){
  1747.                     dump($children->last());die();
  1748.                 }*/
  1749.                 if($level == 'root'){
  1750.                     foreach($children as $Child){
  1751.                         if($Child->getHidden()) continue;
  1752.                         $children_count[$Child->getId()] = 0;
  1753.                         foreach($Child->getChildren() as $SubChild){
  1754.                             $children_count[$Child->getId()] += $SubChild->getProducts()->count();
  1755.                         }
  1756.                     }
  1757.                 }else{
  1758.                     foreach($children as $Child){
  1759.                         if($Child->getHidden()) continue;
  1760.                         $children_count[$Child->getId()] = $Child->getProducts()->count();
  1761.                     }
  1762.                 }
  1763.             }
  1765.             $Category = $this->parseEntityPageUrls($Category);
  1767.             $response = $this->render('@TrinityWebshop/front/root_category.html.twig', $this->attributes([
  1768.                 'Category'           => $Category,
  1769.                 'Page'               => $Page,
  1770.                 'children'           => $children,
  1771.                 'noResults'          => $noResults,
  1772.                 'systemMetatags'     => $systemMetatags,
  1773.                 'licenseplate'       => $licenseplate,
  1774.                 'brandAndModel'      => $brandAndModel,
  1775.                 'brandAndModelArr'   => $brandAndModelArr,
  1776.                 'types'              => $types,
  1777.                 'typesArr'           => $typesArr,
  1778.                 'category_label'     => $category_label,
  1779.                 'custom_breadcrumbs' => $custom_breadcrumbs,
  1780.                 'children_count'     => $children_count,
  1781.                 'filters_visual'     => $filters_visual,
  1782.                 'spec_filter'        => $spec_filter,
  1783.                 'merk'               => (!empty($spec_filter['Merk']) ? $spec_filter['Merk'] : ''),
  1784.                 'model'              => (!empty($spec_filter['Model']) ? $spec_filter['Model'] : ''),
  1785.                 'bouwjaar'           => (!empty($spec_filter['Bouwjaar']) ? $spec_filter['Bouwjaar'] : ''),
  1786.                 'type'               => (!empty($spec_filter['Type']) ? $spec_filter['Type'] : ''),
  1787.                 'q'                  => $spec_query,
  1788.                 'licensepate'        => (!empty($spec_filter['licensepate']) ? $spec_filter['licensepate'] : ''),
  1789.                 'bodyClass'          => 'root-category-view',
  1790.                 'allRootCategories'  => $allRootCategories,
  1791.                 'RecipesPage' => $RecipesPage,
  1792.             ]));
  1794.             //$response = $this->responseRewriteOutput($response, false, false);
  1796.             return $response;
  1797.         }
  1798.         /**
  1799.          * 
  1800.          * 
  1801.          *     ==============================================================================================================
  1802.          *     ==============================================================================================================
  1803.          *     ==============================================================================================================
  1804.          *     ==============================================================================================================
  1805.          *
  1806.          *     CATEGORY DETAIL / PRODUCT OVERVIEW
  1807.          * 
  1808.          *     ==============================================================================================================
  1809.          *     ==============================================================================================================
  1810.          *     ==============================================================================================================
  1811.          *     ==============================================================================================================
  1812.          * 
  1813.          * 
  1814.          */
  1815.         else{
  1816.             $filters = [];
  1817.             if ($request->query->get('q')) {
  1818.                 $filters['q'] = $request->query->get('q');
  1819.             }
  1820.             if ($request->query->get('category')) {
  1821.                 $filters['category'] = $request->query->get('category');
  1822.             }
  1824.             $webshop_tags = $this->getDoctrine()->getRepository(Tag::class)->findAll();
  1826.             if (empty($_GET['q']) && !empty($_GET['brand']) && isset($_GET['model'])) {
  1827.                 $brand_prod = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->find($_GET['brand']);
  1828.                 $model_prod = null;
  1829.                 if(!empty($_GET['model'])){
  1830.                     $model_prod = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->find($_GET['model']);
  1831.                 }
  1832.                 
  1833.                 if(!empty($brand_prod)){
  1834.                     if(!empty($model_prod)){
  1835.                         if((int)$this->WebshopSettings->getUriType() == 1){
  1836.                             $productUrl = '';
  1837.                             $productUrl .= ($Webshop->getSettings()->getUri() ? '/' . $Webshop->getSettings()->getUri() : $this->generateUrl('homepage'));
  1838.                             // $productUrl .= $productname;
  1839.                             // $productUrl .= '/' . $model_prod->getNumber();
  1840.                             $productUrl .= $model_prod->getCategory()->first()->getCategory()->getUri();
  1841.                             $productUrl .= '/' . $model_prod->getSlug();
  1842.                         }else{
  1843.                             $productUrl = '';
  1844.                             $productUrl .= ($Webshop->getSettings()->getUri() ? '/' . $Webshop->getSettings()->getUri() : $this->generateUrl('homepage') . ($Webshop->getCmssettings()->getBaseUri() ? $Webshop->getCmssettings()->getBaseUri() . '/' : ''));
  1845.                             //$productUrl .= ($Webshop->getSettings()->getUri() ? '/' . $Webshop->getSettings()->getUri() : $this->generateUrl('homepage'));
  1846.                             $productUrl .= $model_prod->getCategory()->first()->getCategory()->getUri();
  1847.                             $productUrl .= '/' . $model_prod->getSlug();
  1849.                             $productUrl = str_replace('//', '/', $productUrl);
  1850.                         }
  1851.                     }else{
  1852.                         if((int)$this->WebshopSettings->getUriType() == 1){
  1853.                             $productUrl = '';
  1854.                             $productUrl .= ($Webshop->getSettings()->getUri() ? '/' . $Webshop->getSettings()->getUri() : $this->generateUrl('homepage'));
  1855.                             // $productUrl .= $productname;
  1856.                             // $productUrl .= '/' . $model_prod->getNumber();
  1857.                             $productUrl .= $brand_prod->getCategory()->first()->getCategory()->getUri();
  1858.                             $productUrl .= '/' . $brand_prod->getSlug();
  1859.                         }else{
  1860.                             $productUrl = '';
  1861.                             $productUrl .= ($Webshop->getSettings()->getUri() ? '/' . $Webshop->getSettings()->getUri() : $this->generateUrl('homepage') . ($Webshop->getCmssettings()->getBaseUri() ? $Webshop->getCmssettings()->getBaseUri() . '/' : ''));
  1862.                             //$productUrl .= ($Webshop->getSettings()->getUri() ? '/' . $Webshop->getSettings()->getUri() : $this->generateUrl('homepage'));
  1863.                             $productUrl .= $brand_prod->getCategory()->first()->getCategory()->getUri();
  1864.                             $productUrl .= '/' . $brand_prod->getSlug();
  1866.                             $productUrl = str_replace('//', '/', $productUrl);
  1867.                         }
  1868.                     }
  1870.                     header('Location: ' . $productUrl);
  1871.                     exit;
  1872.                 }
  1873.             }
  1879.             /*$brandAndModel = [];
  1880.             $cachedir = preg_replace('/src\/.*?$/', '', __DIR__) . 'var/cache/';
  1881.             if(file_exists($cachedir . 'brands.json')){
  1882.                 $brandAndModelArr = json_decode(file_get_contents($cachedir . 'brands.json'), true);
  1883.                 if(!is_array($brandAndModelArr)) $brandAndModelArr = [];
  1884.                 $brandAndModel = json_encode($brandAndModelArr);
  1885.             }*/
  1888.             $brandAndModelArr = [];
  1889.             $brandAndModel = '[]';
  1891.             if(!empty($Category)){
  1892.                 $cachedir = preg_replace('/src\/.*?$/', '', __DIR__) . 'var/cache/';
  1893.                 if(file_exists($cachedir . 'brands_sorted.json')){
  1894.                     $brandAndModelArr = json_decode(file_get_contents($cachedir . 'brands_sorted.json'), true);
  1895.                     if(!is_array($brandAndModelArr)) $brandAndModelArr = [];
  1896.                     else{
  1897.                         if(!empty($brandAndModelArr[$Category->getId()])){
  1898.                             $brandAndModelArr = $brandAndModelArr[$Category->getId()];
  1899.                         }
  1900.                     }
  1901.                     $brandAndModel = json_encode($brandAndModelArr);
  1902.                 }
  1903.             }
  1906.             $typesArr = [];
  1907.             $types = '[]';
  1908.             if(!empty($Category)){
  1909.                 $cachedir = preg_replace('/src\/.*?$/', '', __DIR__) . 'var/cache/';
  1910.                 if(file_exists($cachedir . 'types_sorted.json')){
  1911.                     $typesArr = json_decode(file_get_contents($cachedir . 'types_sorted.json'), true);
  1912.                     if(!is_array($typesArr)) $typesArr = [];
  1913.                     else{
  1914.                         if(!empty($typesArr[$Category->getId()])){
  1915.                             $typesArr = $typesArr[$Category->getId()];
  1916.                         }
  1917.                     }
  1918.                     $types = json_encode($typesArr);
  1919.                 }
  1920.             }
  1927.             if(!empty($request->get('categoryId')) && is_numeric($request->get('categoryId'))){
  1928.                 $Category = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Category')->find($request->get('categoryId'));
  1929.             }else{
  1930.                 throw $this->createNotFoundException('Category not found');
  1931.             }
  1934.             $allRootCategories = [];
  1935.             if($Category->getShowAll()){
  1936.                 $allRootCategories = $this->getDoctrine()->getRepository(Category::class)->findBy(['parent' => null], ['position' => 'asc']);
  1937.             }
  1939.             if($Category->getId() == 4872 || $Category->getId() == 4871){
  1940.                 $this->get('session')->set('ecomm_spec_filter', []);
  1941.                 $this->get('session')->set('ecomm_spec_plate', '');
  1942.                 // $this->get('session')->set('ecomm_spec_query', '');
  1943.             }
  1947.             if ($Category->getHidden()) {
  1948.                 throw $this->createNotFoundException('Category ' . $request->get('categoryId') . ' not found [hidden]');
  1949.             }
  1954.             $spec_filter = [];
  1955.             $spec_query = null;
  1956.             $licenseplate = null;
  1957.             if (!$Settings->getDisableRememberSearch()) {
  1958.             if(!empty($this->get('session')->get('ecomm_spec_filter'))){
  1959.                 $spec_filter = $this->get('session')->get('ecomm_spec_filter');
  1960.             }
  1961.             if(!empty($this->get('session')->get('ecomm_spec_plate'))){
  1962.                 $licenseplate = $this->get('session')->get('ecomm_spec_plate');
  1963.             }
  1964.             /*if(!empty($this->get('session')->get('ecomm_spec_query'))){
  1965.                 $spec_query = $this->get('session')->get('ecomm_spec_query');
  1966.         }*/
  1967.             }
  1973.             if(!empty($_GET['Merk'])){
  1974.                 $spec_filter['Merk'] = $_GET['Merk'];
  1975.                 $this->get('session')->set('ecomm_spec_filter', $spec_filter);
  1976.             }
  1978.             if(!empty($_GET['Model'])){
  1979.                 $spec_filter['Model'] = $_GET['Model'];
  1980.                 $this->get('session')->set('ecomm_spec_filter', $spec_filter);
  1981.             }
  1984.             if(!empty($_GET['spec'])){
  1985.                 foreach($_GET['spec'] as $sid => $v){
  1986.                     // if($sid == 11){
  1987.                         $spec_filter[$sid] = $v;
  1988.                     // }
  1989.                 }
  1990.             }
  1995.             if(isset($spec_filter['Merk']) && $spec_filter['Merk'] == 'Alle merken'){
  1996.                 unset($spec_filter['Merk']);
  1997.                 $this->get('session')->set('ecomm_spec_filter', $spec_filter);
  1998.             }
  2000.             if(isset($spec_filter['Model']) && $spec_filter['Model'] == 'Alle modellen'){
  2001.                 unset($spec_filter['Model']);
  2002.                 $this->get('session')->set('ecomm_spec_filter', $spec_filter);
  2003.             }
  2007.             if(!empty($spec_query)){
  2008.                 $spec_query_tmp = explode(' ', $spec_query);
  2010.                 $modelsToSearch = [];
  2011.                 foreach($spec_query_tmp as $qpi => $qp){
  2012.                     foreach($brandAndModelArr as $brand => $models){
  2013.                         if(strtolower($brand) == strtolower($qp)){
  2014.                             $spec_filter['Merk'] = $brand;
  2015.                             unset($spec_query_tmp[$qpi]);
  2016.                             $modelsToSearch = $models;
  2017.                             break;
  2018.                         }
  2019.                     }
  2020.                 }
  2021.                 foreach($spec_query_tmp as $qpi => $qp){
  2022.                     foreach($modelsToSearch as $model){
  2023.                         if(strtolower($model) == strtolower($qp)){
  2024.                             $spec_filter['Model'] = $model;
  2025.                             unset($spec_query_tmp[$qpi]);
  2026.                             break;
  2027.                         }
  2028.                     }
  2029.                 }
  2030.                 $spec_query = implode(' ', $spec_query_tmp);
  2031.             }
  2033.             $filters_visual = [];
  2034.             $spec_filter_checked = [];
  2035.             if(!empty($spec_filter) && is_array($spec_filter)){
  2036.                 foreach($spec_filter as $specLabel => $value){
  2038.                     // TMP IGNORE
  2039.                     // if(in_array($specLabel, ['Bouwjaar'])) continue;
  2041.                     if(is_numeric($specLabel)){
  2042.                         $Spec = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Spec')->findOneBy(['id' => $specLabel]);
  2043.                     }else{
  2044.                     $Spec = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Spec')->findOneBy(['label' => $specLabel]);
  2045.                     }
  2046.                     if(!empty($Spec)){
  2047.                         $spec_filter_checked[$Spec->getId()] = $value;
  2049.                         $filters_visual[$Spec->getId()] = ['label' => ($Spec->getLabel() == 'Model compatibiliteit' ? 'Bouwjaar' : $Spec->getLabel()), 'value' => $value];
  2050.                     }
  2051.                 }
  2052.             }
  2054.             if(empty($filters['q']) && !empty($spec_query)){
  2055.                 $filters['q'] = $spec_query;
  2056.             }
  2058.             if(!empty($spec_query)){
  2059.                 $spec_filter_checked['q'] = explode(' ', $spec_query);
  2061.                 // $filters_visual['q'] = ['label' => 'Zoeken', 'value' => implode(', ', $spec_filter_checked['q'])];
  2062.                 foreach($spec_filter_checked['q'] as $qpart){
  2063.                     if(!isset($filters_visual['q'])){
  2064.                         $filters_visual['q'] = [];
  2065.                     }
  2066.                     $filters_visual['q'][] = ['label' => 'Zoeken', 'value' => $qpart];
  2067.                 }
  2068.             }
  2085.             /*$brands = [];
  2086.             $BrandsSpec = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Spec')->findOneBy(['label' => 'Merk']);
  2087.             $ModelsSpec = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Spec')->findOneBy(['label' => 'Model']);
  2088.             foreach($BrandsSpec->getValues() as $SpecValue){
  2089.                 if(!in_array($SpecValue->getValue(), $brands)){
  2090.                     $brands[] = $SpecValue->getValue();
  2091.                     sort($brands);
  2093.                     dump($SpecValue->getValue());
  2096.                     if($SpecValue->getProducts()->count() > 0){
  2097.                         foreach($ModelsSpec->getValues() as $ModelSpecValue){
  2098.                             if($ModelSpecValue)
  2099.                         }
  2100.                     }
  2104.                 }
  2105.             }
  2107.             dump($brands);die();*/
  2129.             $this->Timer->reset();
  2132.             $cats = array_reverse($Category->getParents());
  2133.             foreach($cats as $cr){
  2134.                 $custom_breadcrumbs[] = [
  2135.                     'name' => $cr->getLabel(),
  2136.                     'url' => ($Settings->getUri() ? '/' . $Settings->getUri() : $this->generateUrl('homepage')) . $cr->getUri()
  2137.                 ];
  2138.             }
  2149.             $this->Timer->mark('Load category');
  2151.             $categories = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Category')->findBy(['parent' => null]);
  2153.             $this->Timer->mark('Load categories');
  2155.             if(empty($Category)){
  2156.                 return $this->redirectToRoute('homepage');
  2157.             }
  2159.             // Parsed wrong language category
  2160.             if($Category->getWebshop() && $Category->getWebshop()->getLanguage() != $this->language){
  2161.                 $TmpCategory = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Category')->findOneBy([ 'slug' => $Category->getSlug(), 'webshop' => $this->Webshop ]);
  2162.                 if($TmpCategory){$Category = $TmpCategory; }
  2163.             }
  2165.             // Parsed wrong webshop
  2166.             if($Category->getWebshop() != $this->Webshop){
  2167.                 $TmpCategory = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Category')->findOneBy([ 'slug' => $Category->getSlug(), 'webshop' => $this->Webshop ]);
  2168.                 if($TmpCategory){$Category = $TmpCategory; }
  2169.             }
  2171.             if(($Category->getWebshop() && $Category->getWebshop()->getLanguage() != $this->language) || ($Category->getWebshop() != $this->Webshop)){
  2172.                 return $this->redirectToRoute('homepage');
  2173.             }
  2175.             $Page->setTitle($Category->getLabel());
  2177.             $custom_breadcrumbs[] = [
  2178.                 'name' => $Category->getLabel(),
  2179.                 'url' => ($Settings->getUri() ? '/' . $Settings->getUri() : $this->generateUrl('homepage')) . $Category->getUri()
  2180.             ];
  2182.             $this->breadcrumbs->addItem($Category->getLabel(), ($Settings->getUri() ? '/' . $Settings->getUri() : $this->generateUrl('homepage')) . $Category->getUri());
  2185.             $this->Timer->mark('Before products');
  2187.             $get_q = null;
  2188.             $get_qo = null;
  2190.             if ($Settings->getSearchMode() && $Settings->getSearchMode() == 'or')
  2191.             {
  2192.                 if(!empty($request->query->get('q'))){
  2193.                     $get_q = $request->query->get('q');
  2194.                     /*if(preg_match('/^([a-zA-Z]+)(\d+)$/', $get_q, $m)){
  2195.                         $get_q = $m[1] . ' ' . $m[2];
  2196.                     }
  2197.                     $get_q = explode(' ', $get_q);*/
  2201.                     if(!empty($get_q)){
  2202.                         /*if(preg_match('/^([a-zA-Z]+)(\d+)$/', $get_q, $m)){
  2203.                             $get_q = [];
  2204.                             $get_qo = [];
  2205.                             $get_qo = [];
  2206.                             // if(strlen($m[1]) > 2){
  2207.                                 $get_q[] = $m[1];
  2208.                             // }
  2209.                             // if(strlen($m[2]) > 2){
  2210.                                 $get_q[] = $m[2];
  2211.                             // }
  2212.                             $get_qo[] = $m[1] . $m[2];
  2213.                             $get_qo[] = $m[1] . '-' . $m[2];
  2214.                             $get_qo[] = $m[1] . ' ' . $m[2];
  2215.                         }else{*/
  2216.                             $f = explode(' ', $get_q);
  2217.                             $get_q = [];
  2218.                             $get_qo = [];
  2220.                             foreach($f as $v){
  2221.                                 // if(strlen($v) > 2){
  2222.                                     $get_q[] = $v;
  2223.                                 // }
  2224.                             }
  2225.                             $get_qo[] = implode($f, '-');
  2226.                             $get_qo[] = implode($f, ' ');
  2227.                         //}
  2228.                     }
  2229.                 }
  2230.             } else {
  2231.                 if (isset($filters['q'])) {
  2232.                     $get_q = $filters['q'];
  2233.                 }
  2234.             }
  2236.             if(preg_match('/price_incl.*?(asc|desc)/', $sort, $m)){
  2237.                 $sort = 'sell_price_incl ' . $m[1];
  2238.             }
  2240.             $SearchCategory = $Category;
  2241.             if(!empty($SearchCategory) && ($SearchCategory->getSlug() == 'category' || $SearchCategory->getSlug() == 'categorie' || $SearchCategory->getSlug() == 'kategorie')){
  2242.                 $SearchCategory = null;
  2243.             }
  2245.             $relationProduct = null;
  2246.             if(!empty($_GET['brand'])){
  2247.                 $brand_prod = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->find($_GET['brand']);
  2248.                 $model_prod = null;
  2249.                 if(!empty($_GET['model'])){
  2250.                     $model_prod = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->find($_GET['model']);
  2251.                 }
  2253.                 if(!empty($brand_prod)){
  2254.                     $relationProduct = $brand_prod;
  2255.                 }
  2256.                 if(!empty($model_prod)){
  2257.                     $relationProduct = $model_prod;
  2258.                 }
  2259.             }
  2261.             $dev = false;
  2262.             if($this->containerInterface->getParameter('kernel.environment') == 'dev'){
  2263.                 $dev = true;
  2264.             }
  2266.             $products_data = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->search($this->Webshop, array(
  2267.                 'spec_filter_checked' => $spec_filter_checked,
  2268.                 'category' => $SearchCategory,
  2269.                 'relation' => $relationProduct,
  2270.                 'visible' => true,
  2271.                 'page' => 1,
  2272.                 /*'limit' => [
  2273.                     'start' => 0,
  2274.                     'limit' => 9
  2275.                 ],*/
  2276.                 'q' => $get_q,
  2277.                 'qo' => $get_qo,
  2278.                 'dev' => $dev,
  2279.                 'filters' => $spec_filter_checked,
  2280.                 // 'debug' => ($dev ? true : false),
  2281.             ), $sort, $sort_dir, ($Settings->getPagination() == 'none'), false, (!empty($_GET['page']) && is_numeric($_GET['page']) ? $_GET['page'] : 1), $this->WebshopSettings->getPerPage());
  2283.             $this->Timer->mark('Products loaded');
  2289.             /*if($this->containerInterface->getParameter('kernel.environment') == 'dev'){
  2290.                 dump($products_data);die();
  2291.             }*/
  2324.             if (empty($products_data['total']) && !empty($_GET['brand']) && isset($_GET['model'])) {
  2325.                 $brand_prod = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->find($_GET['brand']);
  2326.                 $model_prod = null;
  2327.                 if(!empty($_GET['model'])){
  2328.                     $model_prod = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->find($_GET['model']);
  2329.                 }
  2330.                 
  2331.                 if(!empty($brand_prod)){
  2332.                     if(!empty($model_prod)){
  2333.                         if((int)$this->WebshopSettings->getUriType() == 1){
  2334.                             $productUrl = '';
  2335.                             $productUrl .= ($Webshop->getSettings()->getUri() ? '/' . $Webshop->getSettings()->getUri() : $this->generateUrl('homepage'));
  2336.                             // $productUrl .= $productname;
  2337.                             // $productUrl .= '/' . $model_prod->getNumber();
  2338.                             $productUrl .= $model_prod->getCategory()->first()->getCategory()->getUri();
  2339.                             $productUrl .= '/' . $model_prod->getSlug();
  2340.                         }else{
  2341.                             $productUrl = '';
  2342.                             $productUrl .= ($Webshop->getSettings()->getUri() ? '/' . $Webshop->getSettings()->getUri() : $this->generateUrl('homepage') . ($Webshop->getCmssettings()->getBaseUri() ? $Webshop->getCmssettings()->getBaseUri() . '/' : ''));
  2343.                             //$productUrl .= ($Webshop->getSettings()->getUri() ? '/' . $Webshop->getSettings()->getUri() : $this->generateUrl('homepage'));
  2344.                             $productUrl .= $model_prod->getCategory()->first()->getCategory()->getUri();
  2345.                             $productUrl .= '/' . $model_prod->getSlug();
  2347.                             $productUrl = str_replace('//', '/', $productUrl);
  2348.                         }
  2349.                     }else{
  2350.                         if((int)$this->WebshopSettings->getUriType() == 1){
  2351.                             $productUrl = '';
  2352.                             $productUrl .= ($Webshop->getSettings()->getUri() ? '/' . $Webshop->getSettings()->getUri() : $this->generateUrl('homepage'));
  2353.                             // $productUrl .= $productname;
  2354.                             // $productUrl .= '/' . $model_prod->getNumber();
  2355.                             $productUrl .= $brand_prod->getCategory()->first()->getCategory()->getUri();
  2356.                             $productUrl .= '/' . $brand_prod->getSlug();
  2357.                         }else{
  2358.                             $productUrl = '';
  2359.                             $productUrl .= ($Webshop->getSettings()->getUri() ? '/' . $Webshop->getSettings()->getUri() : $this->generateUrl('homepage') . ($Webshop->getCmssettings()->getBaseUri() ? $Webshop->getCmssettings()->getBaseUri() . '/' : ''));
  2360.                             //$productUrl .= ($Webshop->getSettings()->getUri() ? '/' . $Webshop->getSettings()->getUri() : $this->generateUrl('homepage'));
  2361.                             $productUrl .= $brand_prod->getCategory()->first()->getCategory()->getUri();
  2362.                             $productUrl .= '/' . $brand_prod->getSlug();
  2364.                             $productUrl = str_replace('//', '/', $productUrl);
  2365.                         }
  2366.                     }
  2368.                     // dump($productUrl);die();
  2370.                     header('Location: ' . $productUrl);
  2371.                     exit;
  2372.                 }
  2373.             }elseif(empty($products_data['total']) && !empty($_GET['q'])){
  2374.                 // dump($_GET['q']);die();
  2375.             }
  2425.             if(empty($products_data['total']) && $Settings->getFillEmptyCat()){
  2426.                 // Try to find by underlying categories
  2427.                 if($Category->getChildren()->count()){
  2428.                     $catlist = [];
  2429.                     foreach($Category->getChildren() as $c){
  2430.                         $catlist[] = $c->getId();
  2431.                     }
  2433.                     $products_data = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->search($this->Webshop, array(
  2434.                         'spec_filter_checked' => $spec_filter_checked,
  2435.                         'category' => $catlist,
  2436.                         'visible' => true,
  2437.                         'page' => 1,
  2438.                         'q' => $get_q,
  2439.                         'qo' => $get_qo,
  2440.                         'filters' => $spec_filter_checked,
  2441.                     ), $sort, $sort_dir, ($Settings->getPagination() == 'none'), false, (!empty($_GET['page']) && is_numeric($_GET['page']) ? $_GET['page'] : 1), $this->WebshopSettings->getPerPage());
  2443.                     //$all_products = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->gatherProducts($catlist);
  2444.                     // $price_range = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->getPriceRange($Webshop, $catlist);
  2445.                     $catFix = true;
  2446.                 }
  2448.                 $this->Timer->mark('Products (fill underlying) loaded');
  2449.             }
  2451.             $this->Timer->mark('Stuff loaded');
  2452.             $products = $products_data['results'];
  2454.             foreach($products as $i => $p){
  2455.                 $p->activeCategory = $Category;
  2456.                 $products[$i] = $p;
  2457.             }
  2459.             // $prices = [];
  2460.             // foreach ($products as $i => $product) {
  2461.             //     // check if this is the right function to get the right price, should doe sales, promotions etc.
  2462.             //     $p = $product->getRealPriceIncl($this->WebshopSettings);
  2464.             //     if(!empty($p)){
  2465.             //         $prices[] = $p;
  2466.             //     }
  2467.             // }
  2470.             if(!empty($Category->getMin()) && !empty($Category->getMax())){
  2471.                 $priceRange = [$Category->getMin(), $Category->getMax()];
  2472.                 // $priceRange = [0, 1];
  2473.             }else{
  2474.                 if(empty($price_range)){
  2475.                     $price_range = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->getPriceRange($Webshop, $Category);
  2476.                 }
  2478.                 if(!empty($price_range)){
  2479.                     $pr = $price_range[0];
  2480.                     $priceRange = [floor($pr['min_price']), ceil($pr['max_price'])];
  2481.                 }else{
  2482.                     $priceRange = [0, 0];
  2483.                     if(!empty($prices)){
  2484.                         $priceRange = [floor(min($prices)), ceil(max($prices))];
  2485.                     }
  2486.                 }
  2487.             }
  2489.             $this->Timer->mark('Price range');
  2491.             // Prepare specs
  2492.             $specs = [];
  2493.             $groups = [];
  2494.             /*
  2495.             if(empty($all_products)){
  2496.                 $all_products = $Category->getProducts(); //$this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->findAll();
  2497.             }
  2498.             foreach($all_products as $Product){
  2499.                 $Product = $Product->getProduct();
  2500.                 foreach($Product->getCategory() as $_Category){
  2501.                     foreach($_Category->getCategory()->getSpecGroups() as $_SpecGroup){
  2502.                         if(!$this->Webshop->getSpecGroups()->contains($_SpecGroup)) continue;
  2503.                         $groups[$_SpecGroup->getId()] = $_SpecGroup;
  2504.                     }
  2505.                 }
  2506.                 foreach($Product->getSpecGroups() as $_SpecGroup){
  2507.                     if(!$this->Webshop->getSpecGroups()->contains($_SpecGroup)) continue;
  2508.                     $groups[$_SpecGroup->getId()] = $_SpecGroup;
  2509.                 }
  2510.             }
  2511.             $this->Timer->mark('Loaded: specs');
  2512.             // dump($groups);
  2513.             $productsList = [];
  2514.             foreach($all_products as $Product){
  2515.                 $Product = $Product->getProduct();
  2516.                 if($Product->getVisible() && $Product->getEnabled()){
  2517.                     $productsList[] = $Product;
  2518.                 }
  2519.                 if($Product->getType() > 0){
  2520.                     foreach($Product->getLinkedProducts() as $P){
  2521.                         $productsList[] = $P;
  2522.                     }
  2523.                 }
  2524.             }
  2527.             // dump(count($productsList));die();
  2528.             $this->Timer->mark('Loaded: productslist');
  2529.             // dump($productsList);die();
  2531.             if($this->WebshopSettings->getShowUnusedSpecs()){
  2532.                 foreach($groups as $_SpecGroup){
  2533.                     if(!$this->Webshop->getSpecGroups()->contains($_SpecGroup)) continue;
  2534.                     foreach($_SpecGroup->getSpecs() as $_Spec){
  2535.                         if(!$Webshop->getSpecs()->contains($_Spec)) continue;
  2536.                         if($_Spec->getHidden() == true || $_Spec->getOptFilter() == false) continue;
  2537.                         if($_Spec->getType() == 'dropdown'){
  2538.                             $available = $this->getDoctrine()->getRepository('TrinityWebshopBundle:SpecValue')->findBy(['spec' => $_Spec], ['position' => 'asc']);
  2539.                             $SpecValues = $_Spec->getValues();
  2541.                             if(!empty($SpecValues)){
  2543.                                 $foundValues = 0;
  2544.                                 foreach($SpecValues as $v){
  2545.                                     if(!empty($v->getValue())){
  2546.                                         $foundValues++;
  2547.                                     }
  2548.                                 }
  2550.                                 if($foundValues == 0){
  2551.                                     continue;
  2552.                                 }
  2554.                                 if(isset($specs[$_Spec->getId()])){
  2555.                                     if(!is_array($specs[$_Spec->getId()]['value'])){
  2556.                                         $specs[$_Spec->getId()]['value'] = [$specs[$_Spec->getId()]['value']];
  2557.                                     }
  2558.                                         $specs[$_Spec->getId()]['value'] = array_unique(array_merge($specs[$_Spec->getId()]['value'], (!empty($SpecValues) ? $SpecValues : $default)));
  2559.                                     // }
  2560.                                 }else{
  2561.                                     $specs[$_Spec->getId()] = [
  2562.                                         'id'    => $_Spec->getId(),
  2563.                                         'label'    => $this->trans($_Spec->getLabel(), 'webshop'),
  2564.                                         'value'    => (!empty($SpecValues) ? $SpecValues : $default),
  2565.                                         'available'    => $available,
  2566.                                         'multiple'  => $_Spec->getMultiple(),
  2567.                                         'required' => $_Spec->getRequired(),
  2568.                                         'type' => $_Spec->getType(),
  2569.                                         'disabled' => true,
  2570.                                     ];
  2571.                                 }
  2572.                             }
  2573.                         }
  2574.                     }
  2575.                 }
  2576.             }
  2578.             $this->Timer->mark('Loaded: specs');
  2580.             $specAvailability = [];
  2583.             foreach($productsList as $Product){
  2585.                 if((!$Product->getVisible() && ($Product->getLinkedTo()->count() == 0 || (!$Product->getLinkedTo()->first()->getVisible() || !$Product->getLinkedTo()->first()->getEnabled()))) || !$Product->getEnabled()){
  2586.                     continue;
  2587.                 }
  2589.                 // dump($Product->getLabel());
  2590.                 foreach($groups as $_SpecGroup){
  2591.                     if(!$this->Webshop->getSpecGroups()->contains($_SpecGroup)) continue;
  2592.                     foreach($_SpecGroup->getSpecs() as $_Spec){
  2593.                         if(!$Webshop->getSpecs()->contains($_Spec)) continue;
  2594.                         // if($_Spec->getCode() != 'opslag') continue;
  2595.                         if($_Spec->getHidden() == true || $_Spec->getOptFilter() == false) continue;
  2597.                         if($_Spec->getType() == 'dropdown'){
  2598.                             $default = [];
  2599.                             $available = $this->getDoctrine()->getRepository('TrinityWebshopBundle:SpecValue')->findBy(['spec' => $_Spec], ['position' => 'asc']);
  2600.                             $SpecValues = $this->getDoctrine()->getRepository('TrinityWebshopBundle:SpecValue')->findValuesByProduct(
  2601.                                 $_Spec,
  2602.                                 $Product
  2603.                             );
  2604.                         }else{
  2605.                             $default = [];
  2606.                             $available = null;
  2607.                             $SpecValues = $this->getDoctrine()->getRepository('TrinityWebshopBundle:SpecValue')->findValuesByProduct(
  2608.                                 $_Spec,
  2609.                                 $Product
  2610.                             );
  2611.                         }
  2613.                         if(!empty($SpecValues)){
  2615.                             if(!is_array($SpecValues)){
  2616.                                 $SpecValues = [$SpecValues];
  2617.                             }
  2619.                             $foundValues = 0;
  2620.                             if($_Spec->getCode() == 'color' && count($SpecValues) > 1){
  2621.                                 // Combine multi-color when spec has code 'color'
  2622.                                 $spec_values = [];
  2623.                                 $c_id = [];
  2624.                                 $c_value = [];
  2625.                                 $c_hex = [];
  2626.                                 foreach($SpecValues as $k => $v){
  2627.                                     if(!empty($v->getValue())){
  2628.                                         $c_id[] = $v->getId();
  2629.                                         $c_hex[] = $v->getHex();
  2630.                                         $c_value[] = $v->getValue();
  2631.                                         unset($SpecValues[$k]);
  2632.                                         $foundValues++;
  2633.                                     }
  2634.                                 }
  2635.                                 // dump(implode('-', $c_hex));
  2636.                                 $SpecValues[implode('-', $c_id)] = implode('-', $c_hex);
  2637.                             }else{
  2638.                                 foreach($SpecValues as $v){
  2639.                                     if(!empty($v->getValue())){
  2640.                                         // dump($v->getValue());
  2641.                                         $foundValues++;
  2642.                                     }
  2643.                                 }
  2644.                             }
  2646.                             if($foundValues == 0){
  2647.                                 continue;
  2648.                             }
  2650.                             // dump($SpecValues);
  2652.                             // dump($specs[5]['value']->toArray());die();
  2654.                             if(isset($specs[$_Spec->getId()])){
  2655.                                 $specs[$_Spec->getId()]['disabled'] = false;
  2656.                                 if(!is_array($specs[$_Spec->getId()]['value'])){
  2657.                                     $specs[$_Spec->getId()]['value'] = [$specs[$_Spec->getId()]['value']];
  2658.                                 }
  2659.                                 $specs[$_Spec->getId()]['value'] = array_unique(array_merge($specs[$_Spec->getId()]['value'], (!empty($SpecValues) ? $SpecValues : $default)));
  2660.                                 // }
  2661.                             }else{
  2662.                                 $specs[$_Spec->getId()] = [
  2663.                                     'id'    => $_Spec->getId(),
  2664.                                     'label'    => $this->trans($_Spec->getLabel(), 'webshop'),
  2665.                                     'value'    => (!empty($SpecValues) ? $SpecValues : $default),
  2666.                                     'available'    => $available,
  2667.                                     'multiple'  => $_Spec->getMultiple(),
  2668.                                     'required' => $_Spec->getRequired(),
  2669.                                     'type' => $_Spec->getType(),
  2670.                                 ];
  2671.                             }
  2672.                         }
  2673.                     }
  2674.                 }
  2676.                 // $this->Timer->mark('      FETCH PRODUCT');
  2677.             }
  2678.             */
  2680.             // sleep(1.6);
  2681.             $this->Timer->mark('Loaded: product list after specs');
  2682.             // dump($specs[5]);die();
  2684.             // Find favorite products
  2685.             $listIds = [];
  2686.             $WebshopUser = $this->getDoctrine()->getRepository('TrinityWebshopBundle:User')->findOneByUser($this->getUser());
  2687.             if($WebshopUser){
  2688.                 foreach($WebshopUser->getProductList() as $ItemList){
  2689.                     foreach($ItemList->getProducts() as $p){
  2690.                         $listIds[] = $p->getId();
  2691.                     }
  2692.                 }
  2693.             }
  2697.             $this->Timer->mark('Loaded: id crap');
  2699.             /*foreach($specs as $id => $data){
  2700.                 $poslist = [];
  2701.                 foreach($data['value'] as $SV){
  2702.                     if(!empty($SV) && !is_string($SV)){
  2703.                         $poslist[$SV->getPosition()][] = $SV;
  2704.                     }
  2705.                 }
  2706.                 ksort($poslist);
  2707.                 foreach($data['value'] as $SV){
  2708.                     if(!empty($SV) && is_string($SV)){
  2709.                         $poslist[9999][] = $SV;
  2710.                     }
  2711.                 }
  2712.                 $rawList = [];
  2713.                 foreach($poslist as $l){
  2714.                     foreach($l as $SV){
  2715.                         $rawList[] = $SV;
  2716.                     }
  2717.                 }
  2718.                 $specs[$id]['value'] = $rawList;
  2719.             }*/
  2721.             $specs = $Category->getSpecCache();
  2722.             foreach($specs as $k => $spec){
  2723.                 if($spec['type'] == 'range'){
  2724.                     // Walk values for sorting
  2725.                     $resort = [];
  2726.                     foreach($spec['value'] as $v){
  2727.                         $resort[$v['value']][] = $v;
  2728.                     }
  2729.                     ksort($resort);
  2730.                     $new = [];
  2731.                     foreach($resort as $vd){
  2732.                         foreach($vd as $v){
  2733.                             $new[] = $v;
  2734.                         }
  2735.                     }
  2737.                     $specs[$k]['value'] = $new;
  2738.                 }
  2740.             }
  2744.             $tmp_brand = null;
  2745.             $tmp_model = null;
  2746.             if(!empty($filters['q'])){
  2747.                 $f = explode(' ', $filters['q']);
  2748.                 if(!empty($f)){
  2749.                     foreach($f as $i => $fp){
  2750.                         // Search for brand
  2751.                         if(isset($brandAndModelArr[ucfirst($fp)])){
  2752.                             $tmp_brand = ucfirst($fp);
  2753.                             unset($f[$i]);
  2754.                             break;
  2755.                         }
  2756.                     }
  2758.                     if(!empty($tmp_brand)){
  2759.                         foreach($f as $i => $fp){
  2760.                             // Search for brand
  2761.                             if(in_array($fp, $brandAndModelArr[$tmp_brand])){
  2762.                                 $tmp_model = $fp;
  2763.                                 unset($f[$i]);
  2764.                                 break;
  2765.                             }
  2766.                         }
  2767.                     }
  2769.                     $filters['q'] = implode(' ', $f);
  2770.                 }
  2771.             }
  2773.             if(!empty($tmp_brand)){ $spec_filter['Merk'] = $tmp_brand; }
  2774.             if(!empty($tmp_model)){ $spec_filter['Model'] = $tmp_model; }
  2780.             
  2782.             $children_count = [];
  2783.             $children = [];
  2784.             $rootCategory = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Category')->findOneByLabel('Onderdelen');
  2786.             if(!empty($spec_filter_checked) && !empty($rootCategory)){
  2787.                 $doSearch = true;
  2788.                 $redirectToId = null;
  2790.                 $children = [];
  2791.                 $children_raw = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Category')->findCategoriesWithSpecs($rootCategory, $spec_filter_checked, 'root');
  2793.                 // Check if only one category
  2794.                 /*if(count($children_raw) == 1 && !empty($children_raw[0])){
  2795.                     $tmp_id = $children_raw[0]['id'];
  2796.                     $redirectToId = $children_raw[0]['id'];
  2798.                     // Test sub
  2799.                     $sub_children_raw = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Category')->findCategoriesWithSpecs($tmp_id, $spec_filter_checked, 'sub');
  2800.                     if(count($sub_children_raw) == 1 && !empty($sub_children_raw[0])){
  2801.                         $redirectToId = $sub_children_raw[0]['id'];
  2802.                     }
  2803.                 }
  2806.                 if(!empty($redirectToId)){
  2807.                     // Redirect to category
  2808.                     $CatRedirect = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Category')->find($redirectToId);
  2809.                     return $this->redirectToRoute($CatRedirect->getSlugKey());
  2810.                 }*/
  2813.                 foreach($children_raw as $c){
  2814.                     if($c['id']){
  2815.                         $children[] = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Category')->find($c['id']);
  2816.                         $children_count[$c['id']] = $c['num'];
  2817.                     }
  2818.                 }
  2819.             }
  2826.             $paginationFilters = $spec_filter;
  2827.             if(!empty($filters['q'])){
  2828.                 $paginationFilters['q'] = $filters['q'];
  2829.             }
  2833.             $Category = $this->parseEntityPageUrls($Category);
  2835.             $this->Timer->mark('Loaded: before twig return');
  2836.             // $this->Timer->show();
  2837.             
  2838.             if($this->Meta && !empty($Category)){
  2839.                 $this->Meta->registerView($request, 'webshop_category', $Category->getId(), $Category->getLabel());
  2840.             }
  2842.             if($this->Meta && !empty($Category)){
  2843.                 $this->Meta->registerView($request, 'webshop_category', $Category->getId(), $Category->getLabel());
  2844.             }
  2846.             $response =  $this->render('@TrinityWebshop/front/category.html.twig', $this->attributes([
  2847.                 'Category'            => $Category,
  2848.                 'categories'          => $categories,
  2849.                 'Page'                => $Page,
  2850.                 'products'            => $products,
  2851.                 'specs'               => $specs,
  2852.                 'metatags'            => $metatags,
  2853.                 'sort'                => $sort,
  2854.                 'brandAndModel'       => $brandAndModel,
  2855.                 'brandAndModelArr'    => $brandAndModelArr,
  2856.                 'types'               => $types,
  2857.                 'typesArr'            => $typesArr,
  2858.                 'systemMetatags'      => $systemMetatags,
  2859.                 'spec_filter_checked' => $spec_filter_checked,
  2860.                 'filters_visual'      => $filters_visual,
  2861.                 'WebshopSettings'     => $Settings,
  2862.                 'licenseplate'        => $licenseplate,
  2863.                 'priceRange'          => $priceRange,
  2864.                 'catFix'              => $catFix,
  2865.                 'listIds'             => $listIds,
  2866.                 'products_data'       => $products_data,
  2867.                 'bodyClass'           => 'category-view',
  2868.                 'spec_filter'         => $spec_filter,
  2869.                 'filters'             => $filters,
  2870.                 'paginationFilters'   => $paginationFilters,
  2871.                 'custom_breadcrumbs'  => $custom_breadcrumbs,
  2872.                 'children'            => $children,
  2873.                 'children_count'      => $children_count,
  2874.                 'defaultSort'         => $defaultSort,
  2875.                 'allRootCategories'   => $allRootCategories,
  2876.                 'webshop_tags'        => $webshop_tags,
  2877.                 'RecipesPage' => $RecipesPage,
  2878.             ]));
  2880.             //$response = $this->responseRewriteOutput($response, false, false);
  2882.             return $response;
  2883.         }
  2884.     }
  2886.     /**
  2887.      * @Route("/webshop-main/categories/{parent}", name="webshop_front_categories")
  2888.      * @Template()
  2889.      */
  2890.     public function categoriesAction(Request $request, $parent)
  2891.     {
  2892.         parent::init($request);
  2894.         $Parent = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Category')->find($parent);
  2895.         $categories = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Category')->findByParent($Parent);
  2897.         return $this->attributes([
  2898.             'categories' => $categories
  2899.         ]);
  2900.     }
  2902.     /**
  2903.      * @Route("/webshop-main/review/{id}", name="webshop_review")
  2904.      * @Template()
  2905.      */
  2906.     public function reviewAction(Request $request, $id)
  2907.     {
  2908.         parent::init($request);
  2910.         $post = null;
  2911.         $saved = false;
  2912.         if(!empty($_POST)){
  2913.             $post = $_POST;
  2915.             $Product = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->find($id);
  2916.             $WebshopUser = $this->getDoctrine()->getRepository('TrinityWebshopBundle:User')->findOneByUser($this->getUser());
  2918.             $rating = 0;
  2919.             if(!empty($post['review']['rating'])){
  2920.                 $rating = $post['review']['rating'];
  2921.             }
  2923.             $Review = new Review();
  2924.             $Review->setWebshop($this->Webshop);
  2925.             $Review->setLabel($post['review']['title']);
  2926.             $Review->setName($post['review']['name']);
  2927.             $Review->setReview($post['review']['body']);
  2928.             $Review->setRating((float)$rating);
  2929.             // $Review->setRecommend($post['review']['recommend'] == 1);
  2930.             $Review->setDate(new \DateTime());
  2931.             $Review->setProduct($Product);
  2932.             $Review->setUser($WebshopUser);
  2933.             $Review->setIp($request->getClientIp());
  2935.             if($this->WebshopSettings->getModerateReviews()){
  2936.                 $Review->setModerated(false);
  2937.             }else{
  2938.                 $Review->setModerated(true);
  2939.             }
  2941.             $em = $this->getDoctrine()->getManager();
  2942.             $em->persist($Review);
  2943.             $em->flush();
  2945.             // clear product cache
  2946.             $Product->setCacheData(null);
  2947.             
  2948.             $saved = true;
  2949.         }
  2951.         return $this->attributes([
  2952.             'saved' => $saved,
  2953.         ]);
  2954.     }
  2956.     /**
  2957.      * @Route("/webshop-main/ajax/productcount", name="mod_webshop_count")
  2958.      */
  2959.     public function productCount( Request $request )
  2960.     {
  2961.         // Initialize StorageController
  2962.         parent::init($request);
  2964.         $Products = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->countBy();
  2966.         dump($Products); die();
  2968.         return new JsonResponse(array('count' => $productcount));
  2969.     }
  2971.     /**
  2972.      * @Route("/webshop-main/configurable/{Product}", name="webshop_configurable")
  2973.      * @Template()
  2974.      */
  2975.     public function configurableProductAction(Request $request,$Product)
  2976.     {
  2977.         parent::init($request);
  2979.         $data = $_POST;
  2980.         if(isset($_GET['spec'])){
  2981.             $data = $_GET;
  2982.         }
  2984.         $svid = null;
  2985.         $checkSpecValue = null;
  2986.         $checkSpec = null;
  2987.         if(!empty($_GET['svid']) && is_numeric($_GET['svid'])){
  2988.             $svid = (int)$_GET['svid'];
  2989.             $checkSpecValue = $this->getDoctrine()->getRepository('TrinityWebshopBundle:SpecValue')->find($svid);
  2990.             $checkSpec = $checkSpecValue->getSpec();
  2991.         }
  2993.         if(!empty($data['spec'])){
  2994.             foreach($data['spec'] as $k => $v){
  2995.                 if(empty($v)){
  2996.                     unset($data['spec'][$k]);
  2997.                 }
  2998.             }
  2999.         }
  3002.         $OriginalProduct = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->find($Product);
  3014.         
  3031.         $all_values = [];
  3032.         $enabled_values = [];
  3033.         $disabled_values = [];
  3035.         $all = [];
  3036.         $enabled = [];
  3037.         $disabled = [];
  3038.         $matching = [];
  3039.         $active = [];
  3041.         foreach($OriginalProduct->getLinkedProducts() as $ChildProduct){
  3042.             if($ChildProduct->getEnabled()){
  3043.                 foreach($ChildProduct->getSpecValues() as $SV){
  3044.                     if($svid){
  3045.                         if($SV->getId() == $svid){
  3046.                             $matching[] = $ChildProduct;
  3047.                         }else{
  3048.                             if($checkSpec != $SV->getSpec()){
  3049.                                 $all[$SV->getId()] = $SV->getId();
  3050.                                 $all_values[$SV->getId()] = $SV->getValue();
  3051.                             }
  3052.                         }
  3053.                     }else{
  3054.                         $matching[] = $ChildProduct;
  3055.                         $all[$SV->getId()] = $SV->getId();
  3056.                         $all_values[$SV->getId()] = $SV->getValue();
  3057.                     }
  3058.                 }
  3059.             }
  3060.         }
  3062.         // dump('checkSpec => ' . $checkSpec->getLabel());
  3064.         $selectedValues = [];
  3065.         if(!empty($data['spec'])){
  3066.             foreach($data['spec'] as $spec_id => $value_label){
  3067.                 $Spec = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Spec')->find($spec_id);
  3068.                 // dump($Spec->getLabel());
  3069.                 foreach($Spec->getValues() as $SV){
  3070.                     if($SV->getValue() == $value_label){
  3071.                         $selectedValues[] = $SV;
  3072.                     }
  3073.                 }
  3074.             }
  3075.         }
  3077.         $validProducts = [];
  3078.         foreach($matching as $ChildProduct){
  3079.             if($ChildProduct->canOrder()){
  3080.                 $productValues = $ChildProduct->getSpecValues();
  3081.                 $simplified = [];
  3082.                 foreach($productValues as $SV){
  3083.                     $simplified[] = $SV->getId();
  3084.                 }
  3085.                 foreach($selectedValues as $SV){
  3086.                     // dump($SV->getValue() . ' - ' . $SV->getId());
  3087.                     if(!$productValues->contains($SV)){
  3088.                         // dump('fail');
  3089.                         if(isset($validProducts[$ChildProduct->getId()])){
  3090.                             unset($validProducts[$ChildProduct->getId()]);
  3091.                         }
  3092.                         continue(2);
  3093.                     }
  3094.                     // dump('pass');
  3096.                     $validProducts[$ChildProduct->getId()] = $ChildProduct;
  3097.                     // $enabled[$SV->getId()] = $SV->getId();
  3098.                     // $enabled_values[$SV->getId()] = $SV->getValue();
  3099.                 }
  3100.             }
  3101.         }
  3103.         // dump($validProducts); die();
  3105.         foreach($validProducts as $ChildProduct){
  3106.             foreach($ChildProduct->getSpecValues() as $SV){
  3107.                 $enabled[$SV->getId()] = $SV->getId();
  3108.                 $enabled_values[$SV->getId()] = $SV->getValue();
  3109.             }
  3110.         }
  3113.         $disabled = array_diff($all, $enabled);
  3114.         $disabled_values = array_diff($all_values, $enabled_values);
  3116.         $config_spec_filter = [
  3117.             'all'      => array_values($all),
  3118.             'enabled'  => array_values($enabled),
  3119.             'disabled' => array_values($disabled),
  3120.         ];
  3122.         $config_spec_filter_values = [
  3123.             'all'      => array_values($all_values),
  3124.             'enabled'  => array_values($enabled_values),
  3125.             'disabled' => array_values($disabled_values),
  3126.         ];
  3153.         $chosen = [];
  3154.         if(!empty($_GET['chosenid'])){
  3155.             $chosen = explode('_', $_GET['chosenid']);
  3156.         }
  3158.         $products = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->findBySpecs($data, $Product, $this->containerInterface->getParameter('kernel.environment') == 'dev');
  3160.         $products_sort_done = [];
  3161.         $products_sort = [];
  3162.         // if($this->containerInterface->getParameter('kernel.environment') == 'dev'){
  3163.             if(!empty($data)){
  3164.                 // Sort based on spec_values
  3165.                 foreach($products as $p){
  3166.                     foreach($p->getSpecValues() as $sv){
  3167.                         if(!in_array($p->getId(), $products_sort_done) && !empty($sv->getSpec()) && (empty($data['spec']) || !array_key_exists($sv->getSpec()->getId(), $data['spec']))){
  3168.                             if(!isset($products_sort[$sv->getPosition()])){
  3169.                                 $products_sort[$sv->getPosition()] = [];
  3170.                             }
  3171.                             $products_sort[$sv->getPosition()][] = $p;
  3172.                             $products_sort_done[] = $p->getId();
  3173.                         }
  3174.                     }
  3175.                 }
  3176.             }
  3177.             if(!empty($products_sort)){
  3178.                 $products = [];
  3179.                 ksort($products_sort);
  3180.                 foreach($products_sort as $svpos => $prods){
  3181.                     foreach($prods as $p){
  3182.                         $products[] = $p;
  3183.                     }
  3184.                 }
  3185.             }
  3186.         // }
  3189.         if(empty($products)){
  3190.             // No products found by filter, find another by target spec
  3191.             $products = $matching;
  3192.         }
  3193.         
  3194.         if(!empty($products)){
  3195.             $ChildProduct = $products[0];
  3197.             foreach($ChildProduct->getSpecValues() as $SV){
  3198.                 $active[] = $SV->getId();
  3199.             }
  3200.         }
  3206.         $config_spec_filter['active'] = $active;
  3280.         $flatSpecs = [];
  3281.         $allSpecsRaw = [];
  3282.         $keyValue = [];
  3283.         foreach($OriginalProduct->getLinkedProducts() as $Product){
  3284.             $specs = [];
  3285.             foreach($Product->getSpecValues() as $SV){
  3286.                 if(!empty($SV->getSpec())){
  3287.                     if ($SV->getSpec()->getOptDetail()) {
  3288.                         $specs[$SV->getSpec()->getId()] = $SV->getValue();
  3289.                         if(!isset($filters[$SV->getSpec()->getId()])){
  3290.                             if(!isset($allSpecsRaw[$SV->getSpec()->getId()])) $allSpecsRaw[$SV->getSpec()->getId()] = [];
  3291.                             if(!in_array($SV->getValue(), $allSpecsRaw[$SV->getSpec()->getId()])){
  3292.                                 $allSpecsRaw[$SV->getSpec()->getId()][] = (int)$SV->getPosition() . '+' . $SV->getValue();
  3293.                                 $keyValue[$SV->getSpec()->getId()][(int)$SV->getId()] =  $SV->getValue();
  3294.                                 sort($allSpecsRaw[$SV->getSpec()->getId()]);
  3295.                             }
  3296.                         }
  3297.                     }
  3298.                 }
  3299.             }
  3300.             $flatSpecs[$Product->getId()] = $specs;
  3301.         }
  3303.         $allSpecs = [];
  3304.         foreach($allSpecsRaw as $sid => $sv){
  3305.             foreach($sv as $svi => $svid){
  3306.                 $svid = preg_replace('/^\d\+/', '', $svid);
  3307.                 if(!isset($allSpecs[$sid]) || !in_array($svid, $allSpecs[$sid])){
  3308.                     $allSpecs[$sid][] = $svid;
  3309.                 }
  3310.             }
  3311.         }
  3319.         $filters = [];
  3320.         if(!empty($data['spec'])){
  3321.             $filters = $data['spec'];
  3322.             foreach($filters as $k => $v){
  3323.                 $filters[$k] = [$v];
  3324.             }
  3325.         }
  3327.         $matchedSpecs = [];
  3328.         $matchedOtherSpecs = [];
  3330.         foreach($products as $Product){
  3331.             if($Product->canOrder()){
  3332.                 $pid = $Product->getId();
  3334.                 if(!empty($filters)){
  3335.                     // Filters required, product MUST HAVE filters
  3336.                     if(!empty($flatSpecs[$pid])){
  3337.                         $flatProdSpecs = $flatSpecs[$pid];
  3338.                         $flatProdSpecsNotFiltered = $flatSpecs[$pid];
  3339.                         $notFound = false;
  3340.                         foreach($filters as $spec_id => $filter_values){
  3341.                             unset($flatProdSpecsNotFiltered[$spec_id]);
  3342.                             if(!array_key_exists($spec_id, $flatProdSpecs)){
  3343.                                 $notFound = true;
  3344.                             }elseif(!in_array($flatProdSpecs[$spec_id], $filter_values)){
  3345.                                 $notFound = true;
  3346.                             }
  3347.                         }
  3349.                         if(!$notFound){
  3350.                             $matchedSpecs[$pid] = $flatProdSpecs;
  3351.                             $matchedOtherSpecs[$pid] = $flatProdSpecsNotFiltered;
  3352.                         }
  3353.                     }
  3354.                 }else{
  3355.                     if(!empty($flatSpecs[$pid])){
  3356.                         $matchedOtherSpecs[$pid] = $flatSpecs[$pid];
  3357.                         $matchedSpecs[$pid] = $flatSpecs[$pid];
  3358.                     }
  3359.                     // No active filters, allow product
  3360.                 }
  3361.             }
  3362.         }
  3365.         // Find other filters against currently selected
  3366.         $specsAvailableCurrentFilter = [];
  3367.         foreach($matchedOtherSpecs as $pid => $s){
  3368.             foreach($s as $specid => $val){
  3369.                 if(!isset($specsAvailableCurrentFilter[$specid])){
  3370.                     $specsAvailableCurrentFilter[$specid] = [];
  3371.                 }
  3372.                 if(!in_array($val, $specsAvailableCurrentFilter[$specid])){
  3373.                     $specsAvailableCurrentFilter[$specid][] = $val;
  3374.                 }
  3375.             }
  3376.         }
  3378.         $returnSpecs = [];
  3379.         $returnSpecs['all_specs'] = $allSpecs;
  3380.         $returnSpecs['enabled_specs'] = $specsAvailableCurrentFilter;
  3382.         $disabled_specs = [];
  3383.         foreach($allSpecs as $k => $v){
  3384.             if(isset($specsAvailableCurrentFilter[$k])){
  3385.                 $disabled_specs[$k] = array_diff($v, $specsAvailableCurrentFilter[$k]);
  3386.                 if(empty($disabled_specs[$k])){
  3387.                     unset($disabled_specs[$k]);
  3388.                 }
  3389.             }
  3390.         }
  3392.         $returnSpecs['disabled_specs'] = $disabled_specs;
  3394.         $list = [];
  3395.         foreach($products as $product){
  3396.             $media = [];
  3397.             $media_size = [];
  3398.             $media_thumb = [];
  3399.             if($product->getMedia()->count()){
  3400.                 foreach($product->getMedia() as $m){
  3401.                     $media_size[] = ($m->getWidth() > $m->getHeight() ? $m->getHeight() : $m->getWidth());
  3402.                     $media[] = $m->getWebPath();
  3403.                     $media_thumb[] = $m->getWebPath('thumb');
  3404.                 }
  3405.             }else if($OriginalProduct->getMedia()->count()){
  3406.                 foreach($OriginalProduct->getMedia() as $m){
  3407.                     $media_size[] = ($m->getWidth() > $m->getHeight() ? $m->getHeight() : $m->getWidth());
  3408.                     $media[] = $m->getWebPath();
  3409.                     $media_thumb[] = $m->getWebPath('thumb');
  3410.                 }
  3411.             }
  3413.             $priceblock = '';
  3415.             if($product->hasPromotion()){
  3416.                 $priceblock = '
  3417.                 <div class="price-wrapper">
  3418.                     <span class="price sale" data-price="' . $product->getRealPriceIncl($this->WebshopSettings, false, false, $this->WebshopCustomer) . '">' . $this->WebshopSettings->getCurrency()->getFormat($product->getRealPriceIncl($this->WebshopSettings, false, false, $this->WebshopCustomer)) . '</span>
  3419.                 </div><div class="price-wrapper">
  3420.                     <span class="price old">' . $this->WebshopSettings->getCurrency()->getFormat($product->getPriceIncl($this->WebshopSettings, false, false, $this->WebshopCustomer)) . '</span>
  3421.                 </div>
  3422.                 <span class="tax-suffix">' . ($this->WebshopSettings->getPriceDisplay() != 'excl' ? 'incl. BTW' : 'excl. BTW') . '</span>
  3423.                 ';
  3424.                 // $priceblock = '<span class="col-sm col-md-6 price old">&euro; ' . number_format($product->getPriceIncl($this->WebshopSettings), 2, ',', '.') . '</span>
  3425.                 // <span class="col-sm col-md-6 price sale">&euro; ' . number_format($product->getRealPriceIncl($this->WebshopSettings), 2, ',', '.') . '</span>';
  3426.             }elseif(!empty($product->getPriceSale()) && $product->getPriceSale() > 0){
  3427.                 $priceblock = '
  3428.                 <div class="price-wrapper">
  3429.                     <span class="price sale" data-price="' . $product->getRealPriceIncl($this->WebshopSettings, false, false, $this->WebshopCustomer) . '">' . $this->WebshopSettings->getCurrency()->getFormat($product->getRealPriceIncl($this->WebshopSettings, false, false, $this->WebshopCustomer)) . '</span>
  3430.                 </div><div class="price-wrapper">
  3431.                     <span class="price old">' . $this->WebshopSettings->getCurrency()->getFormat($product->getPriceIncl($this->WebshopSettings, false, false, $this->WebshopCustomer)) . '</span>
  3432.                 </div>
  3433.                     <span class="tax-suffix">' . ($this->WebshopSettings->getPriceDisplay() != 'excl' ? 'incl. BTW' : 'excl. BTW') . '</span>';
  3434.             }else{
  3435.                 $priceblock = '<div class="price-wrapper">
  3436.                     <span class="price sale" data-price="' . $product->getRealPriceIncl($this->WebshopSettings, false, false, $this->WebshopCustomer) . '">' . $this->WebshopSettings->getCurrency()->getFormat($product->getRealPriceIncl($this->WebshopSettings, false, false, $this->WebshopCustomer)) . '</span>
  3437.                     <span class="tax-suffix">' . ($this->WebshopSettings->getPriceDisplay() != 'excl' ? 'incl. BTW' : 'excl. BTW') . '</span>
  3438.                 </div>';
  3439.             }
  3441.             if($this->WebshopSettings->getShowStockIndicator()){
  3442.                 $priceblock .= '<div class="stock-label">';
  3444.                 $lowStock = 2;
  3445.                 $mediumStock = 6;
  3446.                 $noStock = 0;
  3447.                 if (!empty($this->WebshopSettings->getStockLevels())) {
  3448.                     $stcklevel = $this->WebshopSettings->getStockLevels();
  3449.                     if (isset($stcklevel['low'])) {
  3450.                         $lowStock = $stcklevel['low'];
  3451.                     }
  3452.                     if (isset($stcklevel['medium'])) {
  3453.                         $mediumStock = $stcklevel['medium'];
  3454.                     }
  3455.                 }
  3457.                 if($this->WebshopSettings->getPicqerChoice() == 1 && !empty($this->WebshopSettings->getPicqerApikey()) && !empty($this->WebshopSettings->getPicqerUrl())){
  3458.                     $Picqer = new Picqer($this->WebshopSettings->getPicqerApikey(), $this->WebshopSettings->getPicqerUrl());
  3459.                     
  3460.                     if($this->WebshopSettings->getPicqerFulfillment()){
  3461.                         if(!empty($this->WebshopSettings->getPicqerFulfillmentId())){
  3462.                             $fulfilment_id = $this->WebshopSettings->getPicqerFulfillmentId();
  3463.                         } else {
  3464.                             $fulfilment_id = null;
  3465.                         }
  3466.                     } else {
  3467.                         $fulfilment_id = null;
  3468.                     }
  3470.                     $stock = $Picqer::checkStock($product, $fulfilment_id);
  3472.                     if($stock !== "Product not found in Picqer" && $stock !== "Product empty"){
  3473.                         if ($stock == 0) {
  3474.                             $priceblock .= '<div class="text-danger"><i class="fa fa-times"></i> ' . $this->trans('Niet op voorraad', [], 'webshop') . '</div>';
  3475.                         }elseif((int)$stock >= (int)$product->getOutOfStockQuantity() && $stock < $lowStock){
  3476.                             $priceblock .= '<div class="text-warning"><i class="fa fa-circle"></i> ' . $this->trans('Zeer beperkt op voorraad', [], 'webshop') . '</div>';
  3477.                         }elseif((int)$stock >= (int)$product->getOutOfStockQuantity() && $stock < $mediumStock){
  3478.                             $priceblock .= '<div class="text-warning"><i class="fa fa-check"></i> ' . $this->trans('Beperkt op voorraad', [], 'webshop') . '</div>';
  3479.                         }elseif((int)$stock >= (int)$product->getOutOfStockQuantity()){
  3480.                             $priceblock .= '<div class="text-success"><i class="fa fa-check"></i> ' . $this->trans('Op voorraad', [], 'webshop') . '</div>';
  3481.                         }else{
  3482.                             $priceblock .= '<div class="text-danger"><i class="fa fa-times"></i> ' . $this->trans('Niet op voorraad', [], 'webshop') . '</div>';
  3483.                         }
  3484.                         $priceblock .= '</div>';
  3485.                     } else {
  3486.                         if($product->canOrder() && $product->getStockAmount() < $lowStock){
  3487.                             $priceblock .= '<div class="text-warning"><i class="fa fa-circle"></i> ' . $this->trans('Zeer beperkt op voorraad', [], 'webshop') . '</div>';
  3488.                         }elseif($product->canOrder() && $product->getStockAmount() < $mediumStock){
  3489.                             $priceblock .= '<div class="text-warning"><i class="fa fa-check"></i> ' . $this->trans('Beperkt op voorraad', [], 'webshop') . '</div>';
  3490.                         }elseif($product->canOrder()){
  3491.                             $priceblock .= '<div class="text-success"><i class="fa fa-check"></i> ' . $this->trans('Op voorraad', [], 'webshop') . '</div>';
  3492.                         }else{
  3493.                             $priceblock .= '<div class="text-danger"><i class="fa fa-times"></i> ' . $this->trans('Niet op voorraad', [], 'webshop') . '</div>';
  3494.                         }
  3495.                         $priceblock .= '</div>';    
  3496.                     }
  3497.                 } else {
  3498.                     if($product->canOrder() && $product->getStockAmount() < $lowStock && $product->getStock()){
  3499.                         $priceblock .= '<div class="text-warning"><i class="fa fa-circle"></i> ' . $this->trans('Zeer beperkt op voorraad', [], 'webshop') . '</div>';
  3500.                     }elseif($product->canOrder() && $product->getStockAmount() < $mediumStock && $product->getStock()){
  3501.                         $priceblock .= '<div class="text-warning"><i class="fa fa-check"></i> ' . $this->trans('Beperkt op voorraad', [], 'webshop') . '</div>';
  3502.                     }elseif($product->canOrder()){
  3503.                         $priceblock .= '<div class="text-success"><i class="fa fa-check"></i> ' . $this->trans('Op voorraad', [], 'webshop') . '</div>';
  3504.                     }else{
  3505.                         $priceblock .= '<div class="text-danger"><i class="fa fa-times"></i> ' . $this->trans('Niet op voorraad', [], 'webshop') . '</div>';
  3506.                     }
  3507.                     $priceblock .= '</div>';
  3508.                 }
  3509.             }
  3515.             // Prepare specs
  3516.             $specs = [];
  3517.             $groups = [];
  3518.             foreach($product->getCategory() as $_Category){
  3519.                 foreach($_Category->getCategory()->getSpecGroups() as $_SpecGroup){
  3520.                     if(!$this->Webshop->getSpecGroups()->contains($_SpecGroup)) continue;
  3521.                     $groups[$_SpecGroup->getId()] = $_SpecGroup;
  3522.                 }
  3523.             }
  3524.             foreach($product->getSpecGroups() as $_SpecGroup){
  3525.                 if(!$this->Webshop->getSpecGroups()->contains($_SpecGroup)) continue;
  3526.                 $groups[$_SpecGroup->getId()] = $_SpecGroup;
  3527.             }
  3529.             // dump($groups);
  3530.             // $productsList = [];
  3531.             // $productsList[] = $product;
  3532.             // foreach($product->getLinkedProducts() as $P){
  3533.             //     $productsList[] = $P;
  3534.             // }
  3536.             // foreach($productsList as $product){
  3537.                 // dump($product->getLabel());
  3538.                 if(!empty($product->getWeight())){
  3539.                     $specs['weight'] = [
  3540.                         'label' => 'Gewicht',
  3541.                         'value' => ($product->getWeight() >= 1000 ? $product->getWeight() . ' Kg.' : $product->getWeight() . ' g'),
  3542.                         'type' => 'text',
  3543.                     ];
  3544.                 }
  3546.                 foreach($groups as $_SpecGroup){
  3547.                     if(!$this->Webshop->getSpecGroups()->contains($_SpecGroup)) continue;
  3548.                     foreach($_SpecGroup->getSpecs() as $_Spec){
  3549.                         if ($_Spec->getOptDetail()) {
  3550.                             // if($_Spec->getCode() != 'opslag') continue;
  3551.                             if($_Spec->getHidden() == true) continue;
  3553.                             if($_Spec->getType() == 'dropdown'){
  3554.                                 $default = [];
  3555.                                 $available = $this->getDoctrine()->getRepository('TrinityWebshopBundle:SpecValue')->findBy(['spec' => $_Spec], ['position' => 'asc']);
  3556.                                 $SpecValues = $this->getDoctrine()->getRepository('TrinityWebshopBundle:SpecValue')->findValuesByProduct(
  3557.                                     $_Spec,
  3558.                                     $product
  3559.                                 );
  3560.                             }else{
  3561.                                 $default = [];
  3562.                                 $available = null;
  3563.                                 $SpecValues = $this->getDoctrine()->getRepository('TrinityWebshopBundle:SpecValue')->findValuesByProduct(
  3564.                                     $_Spec,
  3565.                                     $product
  3566.                                 );
  3567.                             }
  3569.                             if($_Spec->getCode() == 'bereidingswijze'){
  3570.                                 continue;
  3571.                             }
  3573.                             if(!empty($SpecValues)){
  3575.                                 if(!is_array($SpecValues)){
  3576.                                     $SpecValues = [$SpecValues];
  3577.                                 }
  3579.                                 $flatValues = [];
  3580.                                 $flatHex = [];
  3581.                                 foreach($SpecValues as $Value){
  3582.                                     $flatValues[] = $Value->getValue();
  3583.                                     $flatHex[] = $Value->getHex();
  3584.                                 }
  3586.                                 // dump($SpecValues);
  3588.                                 if(isset($specs[$_Spec->getId()])){
  3589.                                     if(!is_array($specs[$_Spec->getId()]['value'])){
  3590.                                         $specs[$_Spec->getId()]['value'] = [$specs[$_Spec->getId()]['value']];
  3591.                                     }
  3592.                                         $specs[$_Spec->getId()]['value'] = array_unique(array_merge($specs[$_Spec->getId()]['value'], (!empty($flatValues) ? $flatValues : $default)));
  3593.                                     // }
  3594.                                 }else{
  3595.                                     $specs[$_Spec->getId()] = [
  3596.                                         'label'    => $_Spec->getLabel(),
  3597.                                         'value'    => implode(', ', (!empty($flatValues) ? $flatValues : $default)),
  3598.                                         'hex'    => implode(', ', (!empty($flatHex) ? $flatHex : [])),
  3599.                                         'type' => $_Spec->getType(),
  3600.                                     ];
  3601.                                 }
  3602.                             }
  3603.                         }
  3604.                     }
  3605.                 }
  3607.             // }
  3608.             if($product->getType() != 2){
  3609.                 if(!empty($product->getSku())){
  3610.                     $specs['sku'] = [
  3611.                         'label' => 'SKU',
  3612.                         'value' => $product->getSku(),
  3613.                         'type' => 'text',
  3614.                     ];
  3615.                 }
  3616.                 if(!empty($product->getEan())){
  3617.                     $specs['ean'] = [
  3618.                         'label' => 'EAN',
  3619.                         'value' => $product->getEan(),
  3620.                         'type' => 'text',
  3621.                     ];
  3622.                 }
  3623.             }
  3625.             $pdata = [
  3626.                 'id'          => $product->getId(),
  3627.                 'can_order'   => $product->canOrder(),
  3628.                 'label'       => $product->getLabel(),
  3629.                 'sub_label'   => $product->getLabelSub(),
  3630.                 'number'      => $product->getNumber(),
  3631.                 'ean'         => $product->getEan(),
  3632.                 'sku'         => $product->getSku(),
  3633.                 'intro'       => $product->getIntro(),
  3634.                 'intro_stripped'    => strip_tags($product->getIntro()),
  3635.                 'description' => $product->getDescription(),
  3636.                 'price'       => $product->getPriceIncl($this->WebshopSettings),
  3637.                 'priceblock'  => $priceblock,
  3638.                 'specs'       => $specs,
  3639.                 'media'       => $media,
  3640.                 'media_size'  => $media_size,
  3641.                 'media_thumb' => $media_thumb,
  3642.             ];
  3644.             $list[] = $pdata;
  3645.         }
  3647.         return new JsonResponse(['specs' => $returnSpecs, 'keyValue' => $keyValue, 'spec_filter' => $config_spec_filter, 'spec_values' => $config_spec_filter_values, 'options' => $list]);
  3648.     }
  3650.     /**
  3651.      * @Route("/compare", name="webshop_compare")
  3652.      * @Template()
  3653.      */
  3654.     public function compareAction(Request $request)
  3655.     {
  3656.         $this->init($request);
  3657.         $Webshop = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Webshop')->getByLanguageAndSettings($this->language, $this->Settings);
  3658.         $Settings = $Webshop->getSettings();
  3660.         $Page = $Settings->getPage();
  3661.         if(empty($Page)){
  3662.             $Page = new \App\CmsBundle\Entity\Page();
  3663.             $Page->setOptionBreadcrumbs(false);
  3664.             $Page->setOptionSubnavigation(false);
  3665.             $Page->setOptionTitle(false);
  3666.         }
  3667.         $Page->setTitle($this->trans('Vergelijken', [], 'webshop'));
  3669.         $metatags       = $this->getDoctrine()->getRepository('CmsBundle:Metatag')->getBySystem(0, (int)$Page->getId(), true);
  3670.         $systemMetatags = $this->getDoctrine()->getRepository('CmsBundle:Metatag')->getBySystem(1, false, false);
  3672.         $specData = [];
  3674.         $products = [];
  3675.         if(!empty($_GET['compare'])){
  3676.             foreach($_GET['compare'] as $id){
  3677.                 $p = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->find($id);
  3678.                 $products[] = $p;
  3680.                 foreach($p->getSpecValues() as $v){
  3681.                     $spec = $v->getSpec();
  3682.                     if(!empty($spec)){
  3683.                         $specData[$spec->getLabel()][$id] = [
  3684.                             'value' => $v->getValue(),
  3685.                             'hex' => $v->getHex(),
  3686.                             'type' => $spec->getType(),
  3687.                         ];
  3688.                     }
  3689.                 }
  3690.             }
  3691.         }
  3693.         return $this->attributes([
  3694.             'Page'            => $Page,
  3695.             'metatags'        => $metatags,
  3696.             'systemMetatags'  => $systemMetatags,
  3697.             'WebshopSettings' => $Settings,
  3698.             'products'        => $products,
  3699.             'specData'        => $specData,
  3700.         ]);
  3701.     }
  3703.     /**
  3704.      * @Route("/webshop-main/reviews/{product_id}/{page}", name="webshop_reviews")
  3705.      * @Template()
  3706.      */
  3707.     public function reviewsAction(Request $request, $product_id, $page = 1)
  3708.     {
  3709.         $this->init($request);
  3711.         $perpage = 3;
  3713.         $Product = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->find($product_id);
  3715.         $moderate = $this->WebshopSettings->getModerateReviews();
  3717.         $reviews_count = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->countReviews($product_id, $page, $perpage, $moderate);
  3718.         $pages         = ceil($reviews_count / $perpage);
  3719.         $reviews       = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->fetchReviews($product_id, $page, $perpage, $moderate);
  3721.         return ['reviews' => $reviews, 'reviews_count' => $reviews_count, 'Product' => $Product, 'product_id' => $product_id, 'WebshopSettings' => $this->WebshopSettings, 'User' => $this->getUser(), 'page' => $page, 'pages' => $pages];
  3722.     }
  3724.     /**
  3725.      * @Route("/profile/orders", name="profile_orders")
  3726.      * @Template()
  3727.      */
  3728.     public function ordersAction(Request $request)
  3729.     {
  3730.         $this->init($request);
  3732.         $Webshop = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Webshop')->getByLanguageAndSettings($this->language, $this->Settings);
  3734.         // $breadcrumbs = $this->get("white_october_breadcrumbs");
  3735.         // $breadcrumbs->addRouteItem($Webshop->getLabel(), "homepage");
  3736.         // $this->breadcrumbs->addRouteItem('Mijn Profiel', "profile");
  3737.         $this->breadcrumbs->addRouteItem('Mijn Bestellingen', "profile_orders");
  3739.         $orders = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Order')->findBy(array(
  3740.             'user' => $this->getUser(),
  3741.             'webshop' => $Webshop
  3742.         ), array(
  3743.             'date' => 'desc'
  3744.         ));
  3746.         if(!empty($_GET['pay'])){
  3747.             $Order = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Order')->find($_GET['pay']);
  3749.             $mollie = new \Mollie_API_Client;
  3750.             $mollie->setApiKey(($this->containerInterface->get('kernel')->getEnvironment() == 'dev' ? self::MOLLIE_API_DEV : self::MOLLIE_API_LIVE));
  3752.             $Payment = $mollie->payments->create(array(
  3753.                 "amount"      => $Order->getTotalPrice(),
  3754.                 "description" => "Order " . $Order->getHash(),
  3755.                 "redirectUrl" => $this->generateUrl('cart_finish', array('hash' => $Order->getHash()), UrlGeneratorInterface::ABSOLUTE_URL),
  3756.                 "method"      => $Order->getPayment(),
  3757.             ));
  3759.             $em = $this->getDoctrine()->getManager();
  3760.             $Order->setPaymentId($Payment->id);
  3761.             $Order->setPaymentStatus($Payment->status);
  3762.             $em->persist($Order);
  3764.             // Payment history
  3765.             $OrderPayment = new OrderPayment();
  3766.             $OrderPayment->setOrder($Order);
  3767.             $OrderPayment->setDate(new \Datetime());
  3768.             $OrderPayment->setPaymentId($Payment->id);
  3769.             $OrderPayment->setPaymentStatus($Payment->status);
  3771.             // Save order
  3772.             // Add to payment history
  3773.             $em->persist($OrderPayment);
  3774.             // Remove cart
  3775.             // $em->remove($Cart);
  3776.             $em->flush();
  3778.             header('Location:' . $Payment->links->paymentUrl);
  3779.             exit;
  3780.         }
  3782.         return $this->attributes(['orders' => $orders]);
  3783.     }
  3785.     /**
  3786.      * @Route("/profile/orders/download-invoice/{id}", name="profile_orders_download_invoice", requirements={"id": "\d+"})
  3787.      */
  3788.     public function downloadInvoiceAction(Request $request, $id)
  3789.     {
  3790.         parent::init($request);
  3791.         $Webshop = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Webshop')->getByLanguageAndSettings($this->language, $this->Settings);
  3792.         $Settings = $Webshop->getSettings();
  3794.         $Invoice  = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Invoice')->find($id);
  3796.         if($Invoice && $Invoice->getOrder()->getUser()->getUser() == $this->getUser()){
  3798.             $tplPath = '@TrinityWebshop/invoice_template.html.twig';
  3799.             $customTplPath = preg_replace('/src\/.*?$/', 'templates/invoice_template.html.twig', __DIR__);
  3800.             if(file_exists($customTplPath)){
  3801.                 $tplPath = '/invoice_template.html.twig';
  3802.             }
  3804.             $tpl = $this->renderView($tplPath, $this->attributes([
  3805.                 'Invoice'         => $Invoice,
  3806.             ]));
  3807.             $html = $tpl;
  3809.             $pdf = new Pdf();
  3811.             // $pdf->setBrd(true);
  3812.             $pdf->setInvoice($Invoice);
  3813.             $pdf->setTranslator($this->translator);
  3814.             $pdf->setSettings($this->Settings);
  3815.             $pdf->setWebshopSettings($Settings);
  3816.             $pdf->setTitle($this->trans('FACTUUR #', [], 'webshop', $Webshop->getLanguage()->getLocale()) . $Invoice->getId());
  3817.             $pdf->setTitleRight($Invoice->getDate()->format('d-m-Y H:i:s'));
  3819.             // $pdf->create();
  3820.             $pdf->AddPage();
  3821.             $pdf->writeHTML($html, true, false, true, false, '');
  3822.             $pdf->Output($this->doSluggify($this->Settings->getLabel()) . '_' . $this->trans('Factuur', [], 'webshop', $Webshop->getLanguage()->getLocale()) . '_' . $Invoice->getId() . '.pdf', 'D');
  3823.             exit;
  3824.         }
  3826.         header('Location:/'); exit;
  3827.     }
  3829.     /**
  3830.      * @Route("/profile/orders/download-credit/{id}", name="profile_orders_download_credit", requirements={"id": "\d+"})
  3831.      */
  3832.     public function downloadCreditAction(Request $request, $id)
  3833.     {
  3834.         parent::init($request);
  3835.         $Webshop = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Webshop')->getByLanguageAndSettings($this->language, $this->Settings);
  3836.         $Settings = $Webshop->getSettings();
  3837.         $CmsSettings = $Webshop->getCmsSettings();
  3838.         $language = $CmsSettings->getLanguage();
  3840.         $Credit  = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Credit')->find($id);
  3842.         if($Credit && $Credit->getOrder()->getUser()->getUser() == $this->getUser()){
  3844.             $tplPath = '@TrinityWebshop/credit_template.html.twig';
  3845.             $customTplPath = preg_replace('/src\/.*?$/', 'templates/credit_template.html.twig', __DIR__);
  3846.             if(file_exists($customTplPath)){
  3847.                 $tplPath = '/credit_template.html.twig';
  3848.             }
  3850.             $tpl = $this->renderView($tplPath, $this->attributes([
  3851.                 'Credit'         => $Credit,
  3852.                 'sitename' => $CmsSettings->getLabel(),
  3853.                 'locale'          => $language->getLocale(),
  3854.             ]));
  3855.             $html = $tpl;
  3857.             $pdf = new Pdf();
  3859.             // $pdf->setBrd(true);
  3860.             $pdf->setCredit($Credit);
  3861.             $pdf->setTranslator($this->translator);
  3862.             $pdf->setSettings($this->Settings);
  3863.             $pdf->setWebshopSettings($Settings);
  3864.             $pdf->setTitle($this->trans('CREDITFACTUUR #', [], 'webshop', $Webshop->getLanguage()->getLocale()) . $Credit->getId());
  3865.             $pdf->setTitleRight($Credit->getDate()->format('d-m-Y H:i:s'));
  3867.             // $pdf->create();
  3868.             $pdf->AddPage();
  3869.             $pdf->writeHTML($html, true, false, true, false, '');
  3870.             $pdf->Output($this->doSluggify($this->Settings->getLabel()) . '_' . $this->trans('Creditfactuur', [], 'webshop', $Webshop->getLanguage()->getLocale()) . '_' . $Credit->getId() . '.pdf', 'D');
  3871.             exit;
  3872.         }
  3874.         header('Location:/'); exit;
  3875.     }
  3877.     private function doSluggify($str, $replace=array(), $delimiter='-')
  3878.     {
  3879.         $str = strtolower($str);
  3881.         if( !empty($replace) ) {
  3882.             $str = str_replace((array)$replace, ' ', $str);
  3883.         }
  3885.         $slugify = new \Cocur\Slugify\Slugify();
  3887.         return $slugify->slugify($str, $delimiter);
  3888.     }
  3890.     /**
  3891.      * @Route("/profile/orders/view/{id}", name="profile_orders_view")
  3892.      * @Template()
  3893.      */
  3894.     public function orderViewAction(Request $request, $id)
  3895.     {
  3896.         $this->init($request);
  3898.         $order = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Order')->find($id);
  3900.         $tax = [];
  3901.         $tax_total = 0;
  3903.         /*if($order->getTotalDelivery() > 0){
  3904.             $tax[21] = (($order->getTotalDelivery() / 100) * 21);
  3905.         }*/
  3907.         if(!empty($order->getProducts())){
  3908.             foreach($order->getProducts() as $Product){
  3909.                 $Tax = $Product->getProduct()->getTax();
  3910.                 if(empty($Tax)){
  3911.                     $Tax = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Tax')->findOneByPercent(21);
  3912.                 }
  3913.                 $percent = $Tax->getPercent();
  3914.                 $price = $Product->getTotalPrice();
  3915.                 // dump($price);
  3916.                 $_tax = (($price / 100) * $percent);
  3917.                 if(!isset($tax[$percent])) $tax[$percent] = 0;
  3918.                 $tax[$percent] += $_tax;
  3919.                 $tax_total += $_tax;
  3920.             }
  3921.         }
  3923.         $delivery = $order->getTotalDelivery();
  3924.         if(!empty($delivery)){
  3925.             $t = (($delivery / 100) * 21);
  3926.             $tax[21] += $t;
  3927.             // $tax_total += $t;
  3928.         }
  3930.         return [
  3931.             'order' => $order,
  3932.             'tax' => $tax,
  3933.             'tax_total' => $tax_total
  3934.         ];
  3935.     }
  3937.     /**
  3938.      * @Route("/dropfilter/{specid}", name="drop_filter")
  3939.      * @Template()
  3940.      */
  3941.     public function dropFilter(Request $request, $specid = null){
  3942.         $this->init($request);
  3944.         if($specid == 'all'){
  3945.             $this->get('session')->set('ecomm_spec_query', '');
  3946.             $this->get('session')->set('ecomm_spec_plate', '');
  3947.             $this->get('session')->set('ecomm_spec_filter', []);
  3948.             return new JsonResponse([]);
  3949.         }
  3950.         $q = '';
  3951.         if(preg_match('/_/', $specid)){
  3952.             $specid = explode('_', $specid);
  3953.             $q = explode(' ', $this->get('session')->get('ecomm_spec_query'));
  3954.             foreach($q as $k => $v){
  3955.                 if($specid[1] == $k || empty($v)){
  3956.                     unset($q[$k]);
  3957.                 }
  3958.             }
  3959.             $q = implode(' ', $q);
  3960.             $this->get('session')->set('ecomm_spec_query', $q);
  3961.         }else{
  3962.             if($specid == 'q'){
  3963.                 $this->get('session')->set('ecomm_spec_query', '');
  3964.             }else{
  3965.                 $filters = $this->get('session')->get('ecomm_spec_filter');
  3966.                 if(!empty($filters)){
  3967.                     foreach($filters as $k => $v){
  3968.                         $Spec = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Spec')->findOneByLabel($k);
  3969.                         if($Spec){
  3970.                             if($Spec->getId() == $specid){
  3971.                                 unset($filters[$k]);
  3972.                             }
  3973.                         }
  3974.                     }
  3975.                 }
  3976.                 $this->get('session')->set('ecomm_spec_filter', $filters);
  3977.             }
  3978.         }
  3980.         return new JsonResponse(['q' => $q]);
  3981.     }
  3983.     /**
  3984.      * @Route("/profile/list/{listid}/{articleid}", name="profile_list")
  3985.      * @Template()
  3986.      */
  3987.     public function listAction(Request $request, $listid = 0, $articleid = null)
  3988.     {
  3989.         $this->init($request);
  3991.         $Product = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->find($articleid);
  3992.         $addedList = false;
  3993.         $savedList = false;
  3994.         $alreadyAdded = false;
  3996.         $WebshopUser = $this->getDoctrine()->getRepository('TrinityWebshopBundle:User')->findOneByUser($this->getUser());
  3998.         if(!empty($_POST['listid'])){
  3999.             if($_POST['listid'] == 'new'){
  4000.                 $ProductList = new \App\Trinity\WebshopBundle\Entity\ProductList();
  4001.                 $ProductList->setUser($WebshopUser);
  4002.                 $ProductList->setLabel($_POST['newList']);
  4003.             }else{
  4004.                 $ProductList = $this->getDoctrine()->getRepository('TrinityWebshopBundle:ProductList')->find($_POST['listid']);
  4005.             }
  4007.             if($ProductList->hasProduct($Product)){
  4008.                 $alreadyAdded = true;
  4009.             }else{
  4010.                 $Product->addProductlist($ProductList);
  4011.                 $em = $this->getDoctrine()->getManager();
  4012.                 $em->persist($Product);
  4013.                 $em->persist($ProductList);
  4014.                 $em->flush();
  4016.                 if(empty($_POST['listid'])){
  4017.                     $addedList = true;
  4018.                 }else{
  4019.                     $savedList = true;
  4020.                 }
  4021.             }
  4022.         }
  4024.         $ProductLists = $this->getDoctrine()->getRepository('TrinityWebshopBundle:ProductList')->findByUser($WebshopUser);
  4025.         return [
  4026.             'Product' => $Product,
  4027.             'alreadyAdded' => $alreadyAdded,
  4028.             'addedList' => $addedList,
  4029.             'savedList' => $savedList,
  4030.             'lists' => $ProductLists,
  4031.             'newList' => (!empty($_POST['newList']) ? $_POST['newList'] : '')
  4032.         ];
  4033.     }
  4035.     /**
  4036.      * @Route("/profile/orders/download/{id}", name="profile_orders_download")
  4037.      * @Template()
  4038.      */
  4039.     public function downloadAction(Request $request, $id)
  4040.     {
  4041.         $this->init($request);
  4043.         $Order = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Order')->find($id);
  4045.         if($Order->getUser()->getId() != $this->getUser()->getId() && !$this->get('security.authorization_checker')->isGranted('ROLE_ADMIN')){
  4046.             throw new AccessDeniedHttpException('Invalid order');
  4047.         }
  4049.         \App\Trinity\WebshopBundle\Classes\Invoice::generate($request, $Order, $this->container, 'D');
  4050.     }
  4052.     /**
  4053.      * @Route("/ajax/products/{webshopid}", name="products")
  4054.      */
  4055.     public function productsAction(Request $request, Environment $twig, int $webshopid = 0)
  4056.     {
  4057.         $this->init($request);
  4059.         if($webshopid > 0){
  4060.             $Webshop = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Webshop')->findOneBy(['id' => $webshopid]);
  4062.             if(empty($Webshop)){
  4063.                 $Webshop = $this->Webshop;
  4064.             }
  4065.         }else{
  4066.             $Webshop = $this->Webshop;
  4067.         }
  4069.         $Settings = $Webshop->getSettings();
  4071.         $em = $this->getDoctrine()->getManager();
  4072.         $return = ['count' => 0, 'products' => [], 'checked' => []];
  4074.         $postValues = $_POST;
  4075.         if(!empty($_GET['c'])) $postValues = $_GET;
  4079.         if(!isset($postValues['filter'])){
  4080.             $postValues['filter'] = [];
  4081.         }
  4085.         $this->get('session')->set('ecomm_spec_plate', '');
  4086.         $this->get('session')->set('ecomm_spec_filter', []);
  4090.         // Hardwired for licenseplate check
  4091.         if(!empty($postValues['licenseplate'])){
  4092.             $api_url = 'https://services.onderdelenlijn.nl/parts/v7.asmx?WSDL';
  4094.             $user = 'info@beyonit.nl';
  4095.             $pass = 'fUAJT6!XP';
  4097.             $Webshop = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Webshop')->getByLanguageAndSettings($this->language, $this->Settings);
  4098.             
  4100.             $SOAP_LOCATION_APP = $api_url;
  4101.             $soapClient = new \SoapClient($SOAP_LOCATION_APP, ["trace" => 1, "exception" => 0, 'cache_wsdl' => WSDL_CACHE_NONE, 'soap_version' => SOAP_1_2]);
  4102.             $soapMessage = [
  4103.                 'Credentials' => [
  4104.                     'Username' => $user,
  4105.                     'Password' => $pass,
  4106.                 ],
  4107.                 'Parameters' => [
  4108.                     'Culture' => "NL",
  4109.                     'TviRequest' => [
  4110.                         'Type' => 'LicensePlate',
  4111.                         'Value' => $postValues['licenseplate']
  4112.                     ]
  4113.                 ]
  4114.             ];
  4115.             $soapResult = $soapClient->TviData($soapMessage);
  4116.             $res = json_decode(json_encode($soapResult), true);
  4118.             if(!empty($res["TviDataResult"]["Result"])){
  4119.                 $array = $res["TviDataResult"]["Result"];
  4121.                 /*if(isset($array["Aldoc"]["Models"]["AldocModel"]["Images"])){
  4122.                     $img_url = str_replace('demo.', '', $array["Aldoc"]["Models"]["AldocModel"]["Images"]["Root"]["Small"]) . $array["Aldoc"]["Models"]["AldocModel"]["Images"]["Filenames"]["string"][0];
  4123.                     dump($img_url);
  4124.                 } else {
  4125.                     dump("No Images");
  4126.                 }*/
  4129.                 $filters = [];
  4131.                 $model = (!empty($array["Basic"]["MakeModel"]["MakeName"]) ? $array["Basic"]["MakeModel"]["MakeName"] : null);
  4132.                 $type  = (!empty($array["Basic"]["MakeModel"]["ModelName"]) ? $array["Basic"]["MakeModel"]["ModelName"] : null);
  4133.                 $year  = (!empty($array["Basic"]["Constructed"]['Year']) ? $array["Basic"]["Constructed"]['Year'] : null);
  4134.                 $month = (!empty($array["Basic"]["Constructed"]['Month']) ? $array["Basic"]["Constructed"]['Month'] : null);
  4136.                 if($model){ $filters['Merk']      = $model; }
  4137.                 if($type){ $filters['Model']      = $type; }
  4138.                 if($year){ $filters['Bouwjaar']   = $year; }
  4139.                 // if($month){ $filters['Bouwmaand'] = $month; }
  4140.             }else{
  4141.                 // Fallback
  4143.                 $filters = [];
  4145.                 $model = 'Mazda';
  4146.                 $type  = 'CX-3.';
  4147.                 $year  = '2015';
  4148.                 $month = '6';
  4150.                 if($model){ $filters['Merk']      = $model; }
  4151.                 if($type){ $filters['Model']      = $type; }
  4152.                 if($year){ $filters['Bouwjaar']   = $year; }
  4153.                 // if($month){ $filters['Bouwmaand'] = $month; }
  4154.             }
  4156.             $this->get('session')->set('ecomm_spec_plate', $postValues['licenseplate']);
  4157.             $this->get('session')->set('ecomm_spec_filter', $filters);
  4159.             if(!empty($filters)){
  4160.                 foreach($filters as $k => $v){
  4161.                     $postValues['spec'][$k] = $v;
  4162.                 }
  4163.             }
  4164.         }
  4174.         $filters_visual = [];
  4176.         if(!empty($postValues['spec'])){
  4177.             foreach($postValues['spec'] as $specLabel => $value){
  4178.                 if(!preg_match('/Alle/', $value)){
  4180.                     // TMP IGNORE
  4181.                     // if(in_array($specLabel, ['/Model', 'Bouwjaar', 'Bouwmaand'])) continue;
  4183.                     $Spec = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Spec')->findOneBy(['label' => $specLabel]);
  4184.                     if(!empty($Spec) && !empty($value)){
  4185.                         $postValues['filter'][$Spec->getId()] = $value;
  4187.                         $filters_visual[$Spec->getId()] = $value;
  4188.                     }
  4189.                 }
  4190.             }
  4191.         }
  4193.         unset($postValues['spec']);
  4196.         /*if(!empty($postValues['filter'])){
  4197.             foreach($postValues['filter'] as $id => $values){
  4198.                 foreach($values as $ind => $value){
  4199.                     if(strpos($value, '-') !== false){
  4200.                         unset($postValues['filter'][$id][$ind]);
  4201.                         $value = explode('-', $value);
  4202.                         foreach($value as $v){
  4203.                             $postValues['filter'][$id][] = $v;
  4204.                         }
  4205.                     }
  4206.                 }
  4207.                 if(empty($postValues['filter'][$id])){
  4208.                     unset($postValues['filter'][$id]);
  4209.                 }
  4210.             }
  4211.         }*/
  4213.         // die( "<pre>" . print_r( $_POST, 1 ) . "</pre>" );
  4214.         $filters = [
  4215.             // 'category' => $Category,
  4216.             // 'q' => 'red',
  4217.             /*'filters' => [
  4218.                 7 => [
  4219.                     'Nederland',
  4220.                     'Frankrijk',
  4221.                 ]
  4222.             ]*/
  4223.             'visible' => true
  4224.         ];
  4225.         if(!empty($postValues['c'])){
  4226.             $filters['category'] = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Category')->find($postValues['c']);
  4227.         }
  4228.         if(!empty($postValues['q'])){
  4230.             // $this->get('session')->set('ecomm_spec_query', $postValues['q']);
  4232.             foreach(explode(' ', $postValues['q']) as $q){
  4233.                 if(!isset($filters_visual['q'])){
  4234.                     $filters_visual['q'] = [];
  4235.                 }
  4236.                 $filters_visual['q'][] = '<strong>' . $this->trans('Zoeken', [], 'webshop') . ':</strong> ' . $q;
  4237.             }
  4238.             
  4239.             if ($Settings->getSearchMode() && $Settings->getSearchMode() == 'or')
  4240.             {
  4241.                 /*if(is_string($postValues['q']) && preg_match('/^([a-zA-Z]+)(\d+)$/', $postValues['q'], $m)){
  4242.                     $filters['q'] = [];
  4243.                     $filters['qo'] = [];
  4244.                     // if(strlen($m[1]) > 2){
  4245.                         $filters['q'][] = $m[1];
  4246.                     // }
  4247.                     // if(strlen($m[2]) > 2){
  4248.                         $filters['q'][] = $m[2];
  4249.                     // }
  4250.                     $filters['qo'][] = $m[1] . $m[2];
  4251.                     $filters['qo'][] = $m[1] . '-' . $m[2];
  4252.                     $filters['qo'][] = $m[1] . ' ' . $m[2];
  4253.                 }else{*/
  4254.                     $f = explode(' ', $postValues['q']);
  4255.                     $filters['q'] = [];
  4256.                     $filters['qo'] = [];
  4258.                     foreach($f as $v){
  4259.                         // if(strlen($v) > 2){
  4260.                             $filters['q'][] = $v;
  4261.                         // }
  4262.                     }
  4263.                     $filters['qo'][] = implode($f, '-');
  4264.                     $filters['qo'][] = implode($f, ' ');
  4265.                 //}
  4266.             } else { 
  4267.                 $filters['q'] = explode(' ', $postValues['q']);
  4268.             }
  4269.         }
  4270.         if(!empty($postValues['limit'])){
  4271.             $filters['limit'] = [
  4272.                 'start' => (!empty($postValues['start']) ? (int)$postValues['start'] : 0),
  4273.                 'limit' => $postValues['limit'],
  4274.             ];
  4275.         }
  4277.         if(!empty($postValues['page'])){
  4278.             $filters['page'] = (int)$postValues['page'];
  4279.         }else{
  4280.             $filters['page'] = 1;
  4281.         }
  4282.         /*if(!empty($postValues['order'])){
  4283.             $filters['order'] = $postValues['order'];
  4284.         }*/
  4285.         if(!empty($postValues['price']) && isset($postValues['price']['min']) && isset($postValues['price']['max'])){
  4286.             $filters['price'] = [(float)$postValues['price']['min'], (float)$postValues['price']['max']];
  4287.             $filters['ignore_pricing'] = ((int)$postValues['ignore_pricing'] == 1);
  4288.         }
  4290.         if(!empty($postValues['filter'])){
  4291.             foreach($postValues['filter'] as $spec_id => $values){
  4292.                 if(!is_array($values)){
  4293.                     $postValues['filter'][$spec_id] = [$values];
  4294.                 }
  4295.             }
  4296.         }
  4298.         $spec_value_link = [];
  4299.         
  4300.         if(!empty($postValues['filter'])){
  4301.             foreach($postValues['filter'] as $specid => $f){
  4302.                 $return['checked'] = array_merge($return['checked'], $f);
  4303.                 $spec_value_link[] = [$specid, $f];
  4304.             }
  4305.             $filters['filters'] = $postValues['filter'];
  4306.         }
  4308.         foreach($spec_value_link as $k => $r){
  4309.             $Spec = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Spec')->find($r[0]);
  4310.             if(!empty($Spec)){
  4311.                 foreach($r[1] as $v){
  4312.                     $allow = true;
  4313.                     if(is_array($v)){
  4314.                         $allow = false;
  4315.                         if(!empty($v[0]) && !empty($v[1])){
  4316.                             $allow = true;
  4317.                             $v = implode(' - ', $v);
  4318.                         }
  4319.                     }
  4320.                     if($allow){
  4321.                         $filters_visual[$Spec->getId()] = '<strong>' . ($Spec->getLabel() == 'Model compatibiliteit' ? 'Bouwjaar' : $Spec->getLabel()) . ':</strong> ' . $v;
  4322.                     }
  4323.                 }
  4324.             }
  4325.         }
  4327.         //$Webshop = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Webshop')->getByLanguageAndSettings($this->language, $this->Settings);
  4328. // dump($filters);
  4329.         
  4330.         if(!empty($postValues['order'])){
  4331.             $postValues['order_full'] = $postValues['order'];
  4332.             if(preg_match('/^price_/', $postValues['order_full'])){
  4333.                 $dir = preg_replace('/^.*? (.*?)$/', '$1', $postValues['order_full']);
  4334.                 $postValues['order_full'] = 'sell_price_incl ' . $dir;
  4335.                 // $postValues['order_full'] = 'price_sale ' . $dir . ', p.' . $postValues['order_full'];
  4336.                 // die( "<pre>" . print_r( $postValues['order_full'], 1 ) . "</pre>" );
  4337.             }
  4338.         }
  4340.         $perPage = $Settings->getPerPage();
  4342.         if(!empty($postValues['pp'])){
  4343.             $perPage = $postValues['pp'];
  4344.         }
  4346.         $sort = (!empty($postValues['order_full']) ? $postValues['order_full'] : null);
  4348.         if(preg_match('/price_incl.*?(asc|desc)/', $sort, $m)){
  4349.             $sort = 'sell_price ' . $m[1];
  4350.         }
  4352.         $filters['sliders'] = [];
  4353.         $filters['sliders_range'] = [];
  4354.         if(!empty($filters['filters'])){
  4355.             foreach($filters['filters'] as $s_id => $f_values){
  4356.                 if(is_numeric($s_id)){
  4357.                     // dump($s_id);
  4359.                     $Spec = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Spec')->find($s_id);
  4360.                     // dump($Spec);die();
  4361.                     if($Spec->getType() == 'slider'){
  4362.                         $filters['sliders'][] = $s_id;
  4363.                     }
  4364.                     if($Spec->getType() == 'slider2'){
  4365.                         $filters['sliders_range'][] = $s_id;
  4366.                     }
  4367.                 }
  4368.             }
  4369.         }
  4371.         $filters['tags'] = [];
  4372.         if(!empty($postValues['tags']) && is_array($postValues['tags'])){
  4373.             $filters['tags'] = $postValues['tags'];
  4374.         }
  4376.         $products_data = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->search($Webshop, $filters, $sort, 'asc', ($this->WebshopSettings->getPagination() == 'none'), false, 1, $perPage, 0, true);
  4378.         if(empty($products_data['total']) && !empty($filters['category'])){
  4379.             // Try to find by underlying categories
  4380.             if($filters['category']->getChildren()->count()){
  4381.                 $catlist = [];
  4382.                 foreach($filters['category']->getChildren() as $c){
  4383.                     $catlist[] = $c->getId();
  4384.                 }
  4386.                 $filters['category'] = $catlist;
  4388.                 $products_data = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Product')->search($Webshop, $filters, $sort, 'asc', ($Settings->getPagination() == 'none'), false, (!empty($_GET['page']) && is_numeric($_GET['page']) ? $_GET['page'] : 1), $perPage, 0, true);
  4389.             }
  4390.         }
  4396.         // dump($products_data);die();
  4397.         $products = $products_data['results'];
  4398.         $product_return = [];
  4399.         $product_return_childs = [];
  4400.         $product_list = [];
  4402.         // dump($products);
  4403.         // die();
  4405.         $prices = [];
  4406.         foreach ($products as $product) {
  4407.             $p = $product->getRealPriceIncl($Settings);
  4408.             // if(!empty($p)){
  4409.                 $prices[] = $p;
  4410.             // }
  4411.         }
  4413.         if(!empty($prices)){
  4414.             $priceRange = [min($prices), max($prices)];
  4415.         }else{
  4416.             $priceRange = [0, 0];
  4417.         }
  4419.         $return['count'] = count($products);
  4420.         $return['priceRange'] = $priceRange;
  4422.         $defaultImage = $Settings->getDefaultProductImageObject();
  4424.         foreach($products as $Product){
  4425.             $Category = null;
  4426.             if(!empty($Product->getCategory())){
  4427.                 foreach($Product->getCategory() as $_Category){
  4428.                     $Category = $_Category;
  4429.                 }
  4430.             }
  4432.             $now = new \DateTime();
  4434.             $relatedChild = null;
  4436.             $childProd = null;
  4437.             $childProductSale = false;
  4439.             $children = [];
  4440.             foreach($Product->getLinkedProducts() as $p){
  4442.                 $media = $Product->getMedia()->first();
  4443.                 $secondMedia = null;
  4445.                 if(empty($media)){
  4446.                     $media = $defaultImage;
  4447.                 } else if ($this->WebshopSettings->getImageSwap() and $Product->getMedia()->count() >= 2){
  4448.                     $secondMedia = $Product->getMedia()->next();
  4449.                 }
  4451.                 if(!empty($filters['category'])){
  4452.                     $Category = $filters['category'];
  4453.                 }
  4455.                 if($Category instanceof \App\Trinity\WebshopBundle\Entity\CategoryProduct){
  4456.                     $Category = $Category->getCategory();
  4457.                 }
  4459.                 $matchCount = 0;
  4460.                 if(!empty($filters['filters'])){
  4461.                     foreach($p->getSpecValues() as $sv){
  4462.                         if($sv->getSpec()){
  4463.                             if(array_key_exists($sv->getSpec()->getId(), $filters['filters'])){
  4464.                                 $f = $filters['filters'][$sv->getSpec()->getId()];
  4465.                                 if(in_array($sv->getValue(), $f)){
  4466.                                     $matchCount++;
  4467.                                 }
  4468.                             }
  4469.                         }
  4470.                     }
  4471.                 }
  4473.                 if(!empty($filters['filters']) && $matchCount >= count($filters['filters'])){
  4474.                     $relatedChild = $p;
  4475.                 }
  4477.                 $product_list[] = $p;
  4479.                 $childProd = (float)$p->getRealPriceIncl($Settings);
  4481.                 if($p->hasPromotion() || (!empty($p->getPriceSale()) && $p->getPriceSale() > 0)){
  4482.                     $childProductSale = true;
  4483.                 }
  4485.                 $prod = [
  4486.                     'id'               => $p->getId(),
  4487.                     'label'            => ($p->getBrand() ? $p->getBrand()->getLabel() . ' ' : '') . $p->getLabel(),
  4488.                     'label_sub'        => $p->getLabelSub(),
  4489.                     'intro'            => $p->getIntro(),
  4490.                     'intro_stripped'   => strip_tags($p->getIntro()),
  4491.                     'number'           => $p->getNumber(),
  4492.                     'price'            => $Settings->getCurrency()->getFormat($p->getPriceIncl($Settings)),
  4493.                     'real_price'       => $Settings->getCurrency()->getFormat($p->getRealPriceIncl($Settings)),
  4494.                     'image'            => null,
  4495.                     'isNew'            => ($p->getNew() && (($p->getNewFrom() <= $now && $p->getNewTill() >= $now) || (empty($p->getNewTill()) && empty($p->getNewFrom())))),
  4496.                     'exclusive'        => $p->getExclusive(),
  4497.                     'priceSell'        => (float)$p->getSellPrice(),
  4498.                     'priceSellIncl'    => (float)$p->getSellPriceIncl(),
  4499.                     'priceSale'        => $p->getPriceSale(),
  4500.                     'priceSaleFloat'   => (float)$p->getPriceSale(),
  4501.                     'priceSalePercent' => $p->getPriceSalePercent(),
  4502.                     'category_id'      => $Category->getId(),
  4503.                     'hasSale'          => ((float)$p->getPriceSale() > 0 || $p->hasPromotion()),
  4504.                     'hasPromotion'     => $p->hasPromotion(true),
  4505.                     'hasCombi'         => $p->hasCombi(),
  4506.                     'canOrder'         => $p->canOrder(),
  4507.                     'isChild'          => true,
  4508.                     'hasMedia'         => !empty($media),
  4509.                     'media'            => (!empty($media) ? $media->getWebPath() : 'bundles/trinitywebshop/img/no-product-image.png'),
  4510.                     'mediaWidth'       => (!empty($media) ? $media->getWidth() : 800),
  4511.                     'mediaHeight'      => (!empty($media) ? $media->getHeight() :  600),
  4512.                     'hasSecondMedia'   => !empty($secondMedia),
  4513.                     'secondMedia'      => (!empty($secondMedia) ? $secondMedia->getWebPath() : ''),
  4514.                     'secondMediaWidth' => (!empty($secondMedia) ? $secondMedia->getWidth() : ''),
  4515.                     'secondMediaHeight'=> (!empty($secondMedia) ? $secondMedia->getHeight() : ''),
  4516.                     'price_display'    => $p->getDisplayPrice($Settings, $this->WebshopCustomer, $this->getUser()),
  4517.                     'review_enabled'   => $this->WebshopSettings->getEnableCardReviews(),
  4518.                     'review_count'     => $p->getReviews()->count(),
  4519.                     'review_average'   => $p->getScore(),
  4520.                     'card_specs'       => $p->getProductCardSpecValues(),
  4521.                 ];
  4523.                 $children[] = $prod;
  4525.                 $product_return_childs[$p->getId()] = $prod;
  4526.             }
  4528.             $media = $Product->getMedia()->first();
  4529.             $secondMedia = null;
  4531.             if(empty($media)){
  4532.                 $media = $defaultImage;
  4533.             } else if ($this->WebshopSettings->getImageSwap() and $Product->getMedia()->count() >= 2){
  4534.                 $secondMedia = $Product->getMedia()->next();
  4535.             }
  4537.             if(!empty($filters['category'])){
  4538.                 $Category = $filters['category'];
  4539.             }
  4541.             if($Category instanceof \App\Trinity\WebshopBundle\Entity\CategoryProduct){
  4542.                 $Category = $Category->getCategory();
  4543.             }
  4545.             if(is_array($Category)){
  4546.                 $Category = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Category')->find(reset($Category));
  4547.             }
  4549.             if(empty($Category)){
  4550.                 continue;
  4551.             }
  4553.             if(empty($Product->getLanguage())){
  4554.                 $locale = 'nl';
  4555.             }else{
  4556.                 $locale = $Product->getLanguage()->getLocale();
  4557.             }
  4559.             switch($locale)
  4560.             {
  4561.             case "de":
  4562.                 $productname = 'produkt';
  4563.                 break;
  4564.                 case "fr":
  4565.                 $productname = 'produit';
  4566.                 break;
  4567.             default:
  4568.                 $productname = 'product';
  4569.             }
  4571.             if((int)$this->WebshopSettings->getUriType() == 1){
  4572.                 $productUrl = '';
  4573.                 $productUrl .= ($Webshop->getSettings()->getUri() ? '/' . $Webshop->getSettings()->getUri() : $this->generateUrl('homepage'));
  4574.                 $productUrl .= $productname;
  4575.                 $productUrl .= '/' . $Product->getNumber();
  4576.                 $productUrl .= '/' . $Product->getSlug();
  4577.             }else{
  4578.                 $productUrl = '';
  4579.                 $productUrl .= ($Webshop->getSettings()->getUri() ? '/' . $Webshop->getSettings()->getUri() : $this->generateUrl('homepage') . ($Webshop->getCmssettings()->getBaseUri() ? $Webshop->getCmssettings()->getBaseUri() . '/' : ''));
  4580.                 //$productUrl .= ($Webshop->getSettings()->getUri() ? '/' . $Webshop->getSettings()->getUri() : $this->generateUrl('homepage'));
  4581.                 $productUrl .= $Category->getUri();
  4582.                 $productUrl .= '/' . $Product->getSlug();
  4584.                 $productUrl = str_replace('//', '/', $productUrl);
  4585.             }
  4587.             if($Category){
  4588.                 $product_list[] = $Product;
  4589.                 $prod = [
  4590.                     'id'               => $Product->getId(),
  4591.                     'type'             => $Product->getType(),
  4592.                     'label'            => ($Product->getBrand() ? $Product->getBrand()->getLabel() . ' ' : '') . $Product->getLabel(),
  4593.                     'label_sub'        => $Product->getLabelSub(),
  4594.                     'intro'            => $Product->getIntro(),
  4595.                     'intro_stripped'   => strip_tags($Product->getIntro()),
  4596.                     'number'           => $Product->getNumber(),
  4597.                     'url'              => $productUrl,
  4598.                     'price'            => $Settings->getCurrency()->getFormat((float)$Product->getPriceIncl($Settings)),
  4599.                     'real_price'       => ($childProd ? $childProd : $Settings->getCurrency()->getFormat($Product->getRealPriceIncl($Settings))),
  4600.                     'image'            => null,
  4601.                     'isNew'            => ($Product->getNew() && (($Product->getNewFrom() <= $now && $Product->getNewTill() >= $now) || (empty($Product->getNewTill()) && empty($Product->getNewFrom())))),
  4602.                     'exclusive'        => $Product->getExclusive(),
  4603.                     'priceSell'        => (float)$Product->getSellPrice(),
  4604.                     'priceSellIncl'    => (float)$Product->getSellPriceIncl(),
  4605.                     'priceSale'        => $Product->getPriceSale(),
  4606.                     'priceSaleFloat'   => (float)$Product->getPriceSale(),
  4607.                     'priceSalePercent' => $Product->getPriceSalePercent(),
  4608.                     'category_id'    => $Product->getCategory()->first()->getCategory()->getId(),
  4609.                     'hasSale'        => ((float)$Product->getPriceSale() > 0 || $Product->hasPromotion() || $childProductSale),
  4610.                     'hasPromotion'   => $Product->hasPromotion(true),
  4611.                     'hasCombi'       => $Product->hasCombi(),
  4612.                     'hasFeatured'    => $Product->getFeatured() ? true : false,
  4613.                     'canOrder'       => $Product->canOrder(),
  4614.                     'isChild'        => false,
  4615.                     'hasMedia'       => !empty($media),
  4616.                     'media'          => (!empty($media) ? $media->getWebPath() : 'bundles/trinitywebshop/img/no-product-image.png'),
  4617.                     'mediaWidth'       => (!empty($media) ? $media->getWidth() : 800),
  4618.                     'mediaHeight'      => (!empty($media) ? $media->getHeight() :  600),
  4619.                     'hasSecondMedia' => !empty($secondMedia),
  4620.                     'secondMedia'    => (!empty($secondMedia) ? $secondMedia->getWebPath() : ''),
  4621.                     'secondMediaWidth' => (!empty($secondMedia) ? $secondMedia->getWidth() : ''),
  4622.                     'secondMediaHeight'=> (!empty($secondMedia) ? $secondMedia->getHeight() : ''),
  4623.                     'products'       => $children,
  4624.                     'products_count' => count($children),
  4625.                     'price_display'  => $Product->getDisplayPrice($Settings, $this->WebshopCustomer, $this->getUser()),
  4626.                     'review_enabled' => $this->WebshopSettings->getEnableCardReviews(),
  4627.                     'review_count'   => $Product->getReviews()->count(),
  4628.                     'review_average' => $Product->getScore(),
  4629.                     'card_specs'     => $Product->getProductCardSpecValues(),
  4630.                     // 'discountHtml' => $discountHtml,
  4631.                 ];
  4633.                 if(!empty($Product->getMedia())){
  4634.                     foreach($Product->getMedia() as $Media){
  4635.                         $prod['image'] = '/' . $Media->getWebPath();
  4636.                         break;
  4637.                     }
  4638.                 }
  4640.                 if(!empty($relatedChild) && $relatedChild->getMedia()->count()){
  4641.                     $prod['image'] = '/' . $relatedChild->getMedia()->first()->getWebPath();
  4642.                     $prod['media'] = $relatedChild->getMedia()->first()->getWebPath();
  4643.                 }
  4645.                 $product_return[$Product->getId()] = $prod;
  4646. //            }
  4648.             $return['products'][] = $prod;
  4649. //        }
  4650.             }
  4651.         }
  4655.         // dump(array_keys($product_return));
  4666.         $filter_type = 'up';
  4667. // xxx hmmmm?
  4668.         //$return['products'] = [];
  4679.         $spec_response = [
  4680.             'enabled'  => [],
  4681.             'disabled' => [],
  4682.             'all'      => [],
  4683.         ];
  4687.         /*
  4688.             Filter products list based on filters
  4689.          */
  4690.         
  4691.         $specs_filters = (!empty($filters['filters']) ? $filters['filters'] : []);
  4692.         // Remove range filters
  4693.         foreach($specs_filters as $k => $v){ if(isset($v['range'])){ unset($specs_filters[$k]); } }
  4696.         if(!empty($filters['category'])){
  4697.             if(!empty($specs_filters)){
  4698.                 $compatible_specvalues = $this->getDoctrine()->getRepository('TrinityWebshopBundle:SpecValue')->checkCompatibleValues($specs_filters, (!empty($filters['category']) ? $filters['category'] : null));
  4699.                 if(!is_array($filters['category'])){
  4700.                     $all_category_specs = $filters['category']->getSpecCache();
  4701.                     foreach($all_category_specs as $spec_id => $sdata){
  4702.                         foreach($sdata['value'] as $vdata){
  4703.                             $v = $vdata['value'];
  4705.                             // Capture for all
  4706.                             if(!isset($spec_response['all'][$spec_id])) $spec_response['all'][$spec_id] = [];
  4707.                             $spec_response['all'][$spec_id][] = $v;
  4709.                             if(!empty($compatible_specvalues[$spec_id])){
  4710.                                 // Found spec in compatible
  4711.                                 if(in_array($v, $compatible_specvalues[$spec_id])){
  4712.                                     // Spec + value is compatible
  4713.                                     if(!isset($spec_response['enabled'][$spec_id])) $spec_response['enabled'][$spec_id] = [];
  4714.                                     $spec_response['enabled'][$spec_id][] = $v;
  4715.                                 }else{
  4716.                                     // Spec + value is not compatible
  4717.                                     if(!isset($spec_response['disabled'][$spec_id])) $spec_response['disabled'][$spec_id] = [];
  4718.                                     $spec_response['disabled'][$spec_id][] = $v;
  4719.                                 }
  4720.                             }else{
  4721.                                 // Spec at all not compatible
  4722.                                 if(!isset($spec_response['disabled'][$spec_id])) $spec_response['disabled'][$spec_id] = [];
  4723.                                 $spec_response['disabled'][$spec_id][] = $v;
  4724.                             }
  4725.                         }
  4726.                     }
  4727.                 }
  4728.             }
  4729.         }
  4731.         // dump($spec_response);die();
  4735.         /*
  4736.             Convert strings to SpecValue IDs
  4737.          */
  4739.         /*$specs_filters_ids = [];
  4740.         foreach($specs_filters as $spec_id => $strings){
  4741.             foreach($strings as $string){
  4742.                 $Spec = $this->getDoctrine()->getRepository('TrinityWebshopBundle:SpecValue')->find($spec_id);
  4743.                 $SpecValues = $this->getDoctrine()->getRepository('TrinityWebshopBundle:SpecValue')->findBy(['spec' => $Spec, 'value' => $string]);
  4744.                 foreach($SpecValues as $SpecValue){
  4745.                     $specs_filters_ids[] = $spec_id . '+' . $SpecValue->getId();
  4746.                 }
  4747.             }
  4748.         }*/
  4750.         /*
  4751.             Collect strict list of spec -> spec_value -> product
  4752.          */
  4753.         
  4754.         /*foreach($product_list as $X){
  4755.             dump($X->getId() . ' | ' . $X->getLabel());
  4756.         }*/
  4759.         /*$checkMatchTarget = count($specs_filters_ids);
  4761.         // dump($specs_filters_ids);
  4763.         $filter_productsList = [];
  4764.         // $simple_productsList = [];
  4765.         foreach($product_list as $Product){
  4766.             if(empty($specs_filters_ids)){
  4767.                 if(!empty($product_return[$Product->getId()])){
  4768.                     $ProductObject = $product_return[$Product->getId()];
  4770.                     if(!in_array($ProductObject, $return['products'])){
  4771.                         $return['products'][] = $ProductObject;
  4772.                     }
  4773.                 }
  4774.             }else{
  4775.                 $checkMatchCount = 0;
  4777.                 foreach($Product->getSpecValues() as $SpecValue){
  4778.                     if($SpecValue instanceof \App\Trinity\WebshopBundle\Entity\SpecValue){
  4779.                         $Spec = $SpecValue->getSpec();
  4781.                         // dump('X ======:' . $Product->getId() . ' | ' . $Product->getLabel() . ' | ' . $Spec->getId() . '+' . $SpecValue->getId());
  4783.                         $checkMatchCount = 0;
  4785.                         if(empty($specs_filters_ids) || in_array($Spec->getId() . '+' . $SpecValue->getId(), $specs_filters_ids)){
  4786.                             $filter_productsList[] = $Product;
  4788.                             // dump('X ======:' . $Product->getId() . ' | ' . $Product->getLabel() . ' | ' . $Spec->getId() . '+' . $SpecValue->getId());
  4791.                             if(!empty($product_return_childs[$Product->getId()])){
  4793.                                 // dump('FOUND ======:' . $Product->getId() . ' | ' . $Product->getLabel() . ' | ' . $Spec->getId() . '+' . $SpecValue->getId());
  4795.                                 if($Product->getLinkedTo()->count() > 0){
  4797.                                     if($Product->getVisible()){
  4798.                                         // dump('CHILD VISIBLE =======: ' . $Product->getId() . ' | ' . $Product->getLabel() . ' | ' . $Spec->getId() . '+' . $SpecValue->getId());
  4799.                                         $ProductObject = $product_return_childs[$Product->getId()];
  4801.                                         if(!in_array($ProductObject, $return['products'])){
  4802.                                             $return['products'][] = $ProductObject;
  4803.                                         }
  4804.                                     }
  4806.                                     // dump('CHILD =======: ' . $Product->getId() . ' | ' . $Product->getLabel() . ' | ' . $Spec->getId() . '+' . $SpecValue->getId());
  4808.                                     foreach($Product->getLinkedTo() as $ParentProduct){
  4809.                                         if(!empty($product_return_childs[$ParentProduct->getId()])){
  4810.                                         $ProductObject = $product_return_childs[$ParentProduct->getId()];
  4812.                                         if(!in_array($ProductObject, $return['products'])){
  4813.                                             $return['products'][] = $ProductObject;
  4814.                                         }
  4815.                                     }
  4816.                                     }
  4817.                                 }else{
  4818.                                     // dump('ROOT =======: ' . $Product->getId() . ' | ' . $Product->getLabel() . ' | ' . $Spec->getId() . '+' . $SpecValue->getId());
  4820.                                     $ProductObject = $product_return_childs[$Product->getId()];
  4822.                                     if(!in_array($ProductObject, $return['products'])){
  4823.                                         $return['products'][] = $ProductObject;
  4824.                                     }
  4825.                                 }
  4826.                             }
  4827.                         }
  4828.                     }
  4829.                 }
  4830.             }
  4831.         }
  4833.         // die();
  4835.         $return['count'] = count($return['products']);
  4836.         $return['total'] = count($return['products']);
  4837.         $return['current'] = count($return['products']);
  4838.         // dump($return);die();
  4839.         // dump($return['products']);die();
  4841.         // die();
  4843.         // dump($simple_productsList);die();
  4845.         / *
  4846.             Setup new specs arrays
  4847.          * /
  4849.         $specs_groups           = [];
  4851.         $specs_id_to_obj        = [];
  4853.         $specs_all              = [];
  4854.         $specs_available        = [];
  4855.         $specs_disabled         = [];
  4857.         $specs_all_simple       = [];
  4858.         $specs_available_simple = [];
  4859.         $specs_disabled_simple  = [];
  4861.         // dump(count($filter_productsList) );die();
  4863.         foreach($filter_productsList as $Product){
  4864.             foreach($Product->getSpecValues() as $SpecValue){
  4865.                 if($SpecValue instanceof \App\Trinity\WebshopBundle\Entity\SpecValue){
  4866.                     $Spec = $SpecValue->getSpec();
  4868.                     foreach($Spec->getGroups() as $Group){
  4869.                         $specs_groups[$Group->getId()] = $Group;
  4870.                     }
  4872.                     if($Spec instanceof \App\Trinity\WebshopBundle\Entity\Spec){
  4873.                         $specs_id_to_obj[$SpecValue->getId()] = $SpecValue;
  4874.                         $specs_available_simple[$Spec->getId()][$SpecValue->getPosition() . '_' . $SpecValue->getId()] = $SpecValue->getId();
  4875.                         ksort($specs_available_simple[$Spec->getId()]);
  4876.                     }
  4877.                 }
  4878.             }
  4879.         }
  4881.         foreach($specs_groups as $SpecGroup){
  4882.             if($SpecGroup instanceof \App\Trinity\WebshopBundle\Entity\SpecGroup){
  4883.                 foreach($SpecGroup->getSpecs() as $Spec){
  4884.                     foreach($Spec->getValues() as $SpecValue){
  4885.                         $specs_id_to_obj[$SpecValue->getId()] = $SpecValue;
  4886.                         $specs_all_simple[$Spec->getId()][$SpecValue->getPosition() . '_' . $SpecValue->getId()] = $SpecValue->getId();
  4887.                         ksort($specs_all_simple[$Spec->getId()]);
  4888.                     }
  4889.                 }
  4890.             }
  4891.         }
  4893.         foreach($specs_all_simple as $spec_id => $values){
  4894.             if(!isset($specs_available_simple[$spec_id])){
  4895.                 $specs_disabled_simple[$spec_id] = $values;
  4896.             }else{
  4897.                 $diff = array_diff($values, $specs_available_simple[$spec_id]);
  4898.                 if(!empty($diff)){
  4899.                     $specs_disabled_simple[$spec_id] = $diff;
  4900.                 }
  4901.             }
  4902.         }
  4904.         foreach($specs_all_simple as $spec_id => $values){
  4905.             foreach($values as $value_id){
  4906.                 $SpecValue = $specs_id_to_obj[$value_id];
  4908.                 $sv_data = [
  4909.                     'id' => $SpecValue->getId(),
  4910.                     'value' => $SpecValue->getValue(),
  4911.                     'hex' => $SpecValue->getHex(),
  4912.                 ];
  4914.                 $specs_all[$spec_id][] = $sv_data;
  4915.             }
  4916.         }
  4918.         foreach($specs_available_simple as $spec_id => $values){
  4919.             foreach($values as $value_id){
  4920.                 $SpecValue = $specs_id_to_obj[$value_id];
  4922.                 $sv_data = [
  4923.                     'id' => $SpecValue->getId(),
  4924.                     'value' => $SpecValue->getValue(),
  4925.                     'hex' => $SpecValue->getHex(),
  4926.                 ];
  4928.                 $specs_available[$spec_id][] = $sv_data;
  4929.             }
  4930.         }
  4932.         foreach($specs_disabled_simple as $spec_id => $values){
  4933.             foreach($values as $value_id){
  4934.                 $SpecValue = $specs_id_to_obj[$value_id];
  4936.                 $sv_data = [
  4937.                     'id' => $SpecValue->getId(),
  4938.                     'value' => $SpecValue->getValue(),
  4939.                     'hex' => $SpecValue->getHex(),
  4940.                 ];
  4942.                 $specs_disabled[$spec_id][] = $sv_data;
  4943.             }
  4944.         }
  4946.         $return['specs_all']              = $specs_all;
  4947.         $return['specs_available']        = $specs_available;
  4948.         $return['specs_disabled']         = $specs_disabled;*/
  4959.         // New
  4960.         $return['specs_disabled']  = $spec_response['disabled'];
  4961.         $return['specs_available'] = $spec_response['enabled'];
  4962.         $return['specs_all']       = $spec_response['all'];
  4972.         if(empty($postValues['order'])){
  4973.             $postValues['order'] = 'pos asc';
  4974.         }
  4978.         $order_pos = explode(' ', $postValues['order']);
  4981.         /*if($order_pos[0] != 'pos'){
  4982.             // Sort
  4983.             $sorted = [];
  4984.             $new_list = [];
  4985.             foreach($return['products'] as $prod){
  4987.                 if($order_pos[0] == 'label'){
  4988.                     $sorted[$prod['label']][] = $prod;
  4989.                 }elseif($order_pos[0] == 'price_incl'){
  4990.                     $sorted[$prod['real_price']][] = $prod;
  4991.                 }else{
  4992.                     // $sorted[$prod['pos']][] = $prod;
  4993.                 }
  4995.                 if($order_pos[1] == 'asc'){
  4996.                     ksort($sorted);
  4997.                 }else{
  4998.                     krsort($sorted);
  4999.                 }
  5000.             }
  5003.             // dump($sorted);die();
  5005.             // Reset to list
  5006.             foreach($sorted as $prods){
  5007.                 foreach($prods as $p){
  5008.                     $new_list[] = $p;
  5009.                 }
  5010.             }
  5012.             $return['products'] = $new_list;
  5013.         }*/
  5034.         // dump($return['specs']);die();
  5036.         // Prepare specs for json
  5037.         /*foreach($return['specs'] as $specId => $spec){
  5038.             if(is_array($spec['value'])){
  5039.                 $list = [];
  5040.                 foreach($spec['value'] as $v){
  5041.                     $list[] = [
  5042.                         'id' => $v->getId(),
  5043.                         'value' => $v->getValue(),
  5044.                     ];
  5045.                 }
  5046.                 $return['specs'][$specId]['value'] = $list;
  5047.             }
  5048.             if(is_array($spec['available'])){
  5049.                 $list = [];
  5050.                 foreach($spec['available'] as $v){
  5051.                     $list[] = [
  5052.                         'id' => $v->getId(),
  5053.                         'value' => $v->getValue(),
  5054.                     ];
  5055.                 }
  5056.                 $return['specs'][$specId]['available'] = $list;
  5057.             }
  5058.         }*/
  5062.         $return['total']          = $products_data['total'];
  5063.         $return['current']        = $products_data['current'];
  5064.         $return['start']          = $products_data['start'];
  5065.         $return['limit']          = $products_data['limit'];
  5066.         $return['pages']          = $products_data['pages'];
  5067.         $return['page']           = $products_data['page'];
  5068.         $return['filters_visual'] = $filters_visual;
  5069.         $return['hasmore']        = ($products_data['page'] < $return['pages']);
  5070.         
  5071.         $return['filters']        = (!empty($postValues['filter']) ? $postValues['filter'] : []);
  5073.         $allFilters = [];
  5074.         if(!empty($postValues['q'])){
  5075.             $allFilters['q'] = $postValues['q'];
  5076.         }
  5078.         foreach($return['filters'] as $spec_id => $data){
  5079.             if(!empty($data['range'])){
  5080.                 if(empty($data['range'][0]) && empty($data['range'][1])){
  5081.                     unset($return['filters'][$spec_id]);
  5082.                 }else{
  5083.                     if(!empty($data[0])){
  5084.                         $Spec = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Spec')->find($spec_id);
  5085.                         $allFilters[$Spec->getLabel()] = $data[0];
  5086.                     }
  5087.                 }
  5088.             }else{
  5089.                 if(!empty($data[0])){
  5090.                     $Spec = $this->getDoctrine()->getRepository('TrinityWebshopBundle:Spec')->find($spec_id);
  5091.                     $allFilters[$Spec->getLabel()] = $data[0];
  5092.                 }
  5093.             }
  5094.         }
  5101.         $route = (!empty($postValues['route']) ? $postValues['route'] : 'homepage');
  5105.         $return['pagination'] = '<div class="js-pag">' . $twig->render(
  5106.             '@Cms/pagination_bootstrap.html.twig',
  5107.             [
  5108.                 'currentFilters' => $allFilters,
  5109.                 'currentPage' => $return['page'],
  5110.                 'paginationPath' => $route,
  5111.                 'lastPage' => $return['pages'],
  5112.                 'showAlwaysFirstAndLast' => true
  5113.             ]
  5114.         ) . '</div>';
  5116.         // Render pagination HTML
  5117.         /*{% include '@Cms/pagination_bootstrap.html.twig' with {
  5118.           currentPage : products_data.page,
  5119.           paginationPath: app.request.attributes.get('_route'),
  5120.           lastPage: products_data.pages,
  5121.           showAlwaysFirstAndLast: true
  5122.         }
  5123.         only %}*/
  5148.         // dump($return['specs']);die();
  5150.         // Try to find grouped values
  5151.         /*foreach($return['specs'] as $id => $spec){
  5152.             foreach($spec['value'] as $n => $value){
  5153.                 $return['specs'][$id]['value'][$n] = explode(' / ', $value);
  5154.             }
  5155.         }*/
  5157.         return new JsonResponse($return);
  5159.         // return $this->render('@TrinityWebshop/default/category.html.twig', array(
  5160.         //     'Category' => $Category,
  5161.         //     'products' => $products,
  5162.         //     'specs' => $specs,
  5163.         // ));
  5164.     }
  5166.     private function parseEntityPageUrls($entity)
  5167.     {
  5168.         if ($entity instanceof \App\Trinity\WebshopBundle\Entity\Product)
  5169.         {
  5170.             $intro = $this->parseCmsUrls($entity->getIntro());
  5171.             $entity->setIntro($intro);
  5172.             $description = $this->parseCmsUrls($entity->getDescription());
  5173.             $entity->setDescription($description);
  5174.         }
  5176.         if ($entity instanceof \App\Trinity\WebshopBundle\Entity\Category)
  5177.         {
  5178.             $description = $this->parseCmsUrls($entity->getDescription());
  5179.             $entity->setDescription($description);
  5180.             $blocktext = $this->parseCmsUrls($entity->getBlockText());
  5181.             $entity->setBlockText($blocktext);
  5182.         }
  5184.         return $entity;
  5185.     }
  5187.     private function parseSettingsPageUrls($Settings)
  5188.     {
  5189.         $intro = $this->parseCmsUrls($Settings->getInfo());
  5190.         $Settings->setInfo($intro);
  5191.         $c1 = $this->parseCmsUrls($Settings->getCustom1());
  5192.         $Settings->setCustom1($c1);
  5193.         $c2 = $this->parseCmsUrls($Settings->getCustom2());
  5194.         $Settings->setCustom2($c2);
  5195.         $c3 = $this->parseCmsUrls($Settings->getCustom3());
  5196.         $Settings->setCustom3($c3);
  5197.         $c4 = $this->parseCmsUrls($Settings->getCustom4());
  5198.         $Settings->setCustom4($c4);
  5199.         $c5 = $this->parseCmsUrls($Settings->getCustom5());
  5200.         $Settings->setCustom5($c5);
  5201.         $c6 = $this->parseCmsUrls($Settings->getCustom6());
  5202.         $Settings->setCustom6($c6);
  5204.         $usp = $this->parseCmsUrls($Settings->getUsps());
  5205.         $Settings->setUsps($usp);
  5207.         return $Settings;
  5208.     }
  5209. }