src/Controller/CatalogController.php line 1316

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\Agreements;
  6. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  7. use Symfony\Component\HttpFoundation\Response;
  8. use Symfony\Component\Routing\Annotation\Route;
  9. use App\Service\TrafficTracker;
  10. use Symfony\Contracts\Translation\TranslatorInterface;
  11. use Symfony\Component\HttpFoundation\Request;
  12. use App\Entity\Partner;
  13. use App\Entity\Productbywholesaler;
  14. use App\Entity\Vendors;
  15. use App\Entity\Customer;
  16. use App\Entity\Product;
  17. use App\Entity\Category;
  18. use App\Entity\Cta;
  19. use App\Entity\Resources;
  20. use App\Entity\Productline;
  21. use App\Entity\Wholesaler;
  22. use App\Entity\Productopinions;
  23. use App\Entity\User;
  24. use App\Service\DataProductFinder;
  25. use App\Service\HeaderData;
  26. use App\Form\Catalog\CatalogProductSearch;
  27. use App\Service\Translation;
  28. use Doctrine\ORM\Tools\Pagination\Paginator;
  29. use App\Form\Catalog\SearchPromotion;
  30. use Symfony\Component\HttpKernel\Exception\NotFoundHttpException;
  31. use App\Service\SanitizeService;
  32. use App\Entity\Bundle;
  33. use Doctrine\ORM\Query\Expr\Join;
  34. use App\Service\PriceCalculatorService;
  35. use App\Service\ConnectifService;
  36. use App\Service\Currency\OperationalCurrencyProvider;
  37. use App\Service\JsonSearchService;
  38. use App\Entity\WarehouseProduct;
  39. use App\Service\ExtraFieldsService;
  41. class CatalogController extends AbstractController
  42. {
  44.     private $connectifService;
  45.     private $operationalCurrencyProvider;
  47.     public function __construct(ConnectifService $connectifService, OperationalCurrencyProvider $operationalCurrencyProvider)
  48.     {
  49.         $this->connectifService = $connectifService;
  50.         $this->operationalCurrencyProvider = $operationalCurrencyProvider;
  51.     }
  53.     /**
  54.      * @Route("/catalog/default/goto", name="catalog_goto")
  55.      */
  56.     public function index(TrafficTracker $trafficTracker)
  57.     {
  58.         $trafficTracker->registerTraffic();
  59.         $user = $this->getUser();
  61.         if ($user->getPartner()) {
  62.             $partnerRepository = $this->getDoctrine()->getRepository(Partner::class);
  63.             $partner = $partnerRepository->MyPartnerQuery($user)->setMaxResults(1)->getQuery()->getSingleResult();
  64.             return $this->redirectToRoute('catalog_index', ['partnerId' => $partner->getId()]);
  65.         }
  66.         if ($user->getCustomer()) {
  67.             $customerRepository = $this->getDoctrine()->getRepository(Customer::class);
  68.             $customer = $customerRepository->MyCustomerQuery($user)->setMaxResults(1)->getQuery()->getSingleResult();
  69.             return $this->redirectToRoute('catalog_index', ['partnerId' => $customer->getPartner()->getId()]);
  70.         }
  71.         return $this->redirectToRoute('catalog_customizemarket');
  72.     }
  75.     /**
  76.      * @Route("/catalog/default/index/{partnerId}", name="catalog_index", requirements={"partnerId"="\d+"})
  77.      */
  78.     public function catalog(Request $request, HeaderData $buildHeaderData, Translation $translation, TrafficTracker $trafficTracker, PriceCalculatorService $priceCalculator, OperationalCurrencyProvider $operationalCurrencyProvider, $partnerId)
  79.     {
  80.         $trafficTracker->registerTraffic();
  81.         $partnerRepository = $this->getDoctrine()->getRepository(Partner::class);
  82.         $customerRepository = $this->getDoctrine()->getRepository(Customer::class);
  84.         $data = array();
  85.         $locale = $request->getLocale();
  86.         $user = $this->getUser();
  88.         //TODO wholesaler can't enter in index - goes to customize. to delete?
  89.         if (!is_null($user->getWholesaler())) {
  90.             $idwholesaler = $user->getWholesaler()->getId();
  91.         } elseif (!is_null($user->getPartner())) {
  92.             $partner = $partnerRepository->MyPartnerQuery($user)
  93.                 ->andWhere('p.id = :partnerId ')
  94.                 ->setParameter('partnerId', $partnerId)
  95.                 ->setMaxResults(1)->getQuery()->getSingleResult();
  97.             $idwholesaler = $partner->getWholesaler()->getId();
  98.         }
  99.         //TODO customer can enter in index???
  100.         elseif (!is_null($user->getCustomer())) {
  101.             $customer = $customerRepository->MyCustomerQuery($user)
  102.                 ->andWhere('c.id = :customerId ')
  103.                 ->setParameter('customerId', $user->getCustomer()->getId())
  104.                 ->setMaxResults(1)->getQuery()->getSingleResult();
  105.             $partner = $customer->getPartner();
  106.             $idwholesaler = $partner->getwholesaler()->getId();
  107.         }
  109.         $carouselImages = $this->getDoctrine()->getRepository(\App\Entity\Catalogcarouselimages::class)->findBy(['wholesaler' => $idwholesaler]);
  111.         return $this->render('/catalog/default/index.html.twig', [
  112.             'partner' => $partner,
  113.             'idWholesaler' => $partner->getWholesaler()->getId(),
  114.             'headerData' => $buildHeaderData->buildHeaderData($user),
  115.             'coverProducts' => $this->catalogCoverProducts(),
  116.             'carousel' => $carouselImages,
  117.             'locale' => $locale,
  118.             'pbwRepository' => $this->getDoctrine()->getRepository(Productbywholesaler::class),
  119.             'vendorsRepository' => $this->getDoctrine()->getRepository(Vendors::class),
  120.             'server_name' => $_ENV["LOCAL_SERVER_NAME"],
  121.             'useSymbol' => $partner->getWholesaler()->getUseSymbolCurrency(),
  122.             'priceCalculator' => $priceCalculator,
  123.             'cnClientInfo' => ($this->connectifService->cnClientInfo($user)),
  124.             'cnCart' => $this->connectifService->cnCart($user),
  125.             'operationalCurrency' => $operationalCurrencyProvider->provide($partner),
  126.         ]);
  127.     }
  130.     /**
  131.      * @Route("/catalog/default/customizemarket", name="catalog_customizemarket")
  132.      */
  133.     public function customizemarket(HeaderData $buildHeaderData, Translation $translation, TrafficTracker $trafficTracker, PriceCalculatorService $priceCalculator, Request $request)
  134.     {
  135.         $trafficTracker->registerTraffic();
  136.         $user = $this->getUser();
  137.         $idwholesaler = $user->getWholesaler()->getId();
  139.         $carouselImages = $this->getDoctrine()->getRepository(\App\Entity\Catalogcarouselimages::class)->findBy(['wholesaler' => $idwholesaler]);
  141.         return $this->render('/catalog/default/index.html.twig', [
  142.             'data' => array(),
  143.             'headerData' => $buildHeaderData->buildHeaderData($user),
  144.             'coverProducts' => $this->catalogCoverProducts(),
  145.             'carousel' => $carouselImages,
  146.             'pbwRepository' => $this->getDoctrine()->getRepository(Productbywholesaler::class),
  147.             'vendorsRepository' => $this->getDoctrine()->getRepository(Vendors::class),
  148.             'partner' => $partnerRepository = $this->getDoctrine()->getRepository(Partner::class)->find(7),
  149.             'locale' => $request->getLocale(),
  150.             'idWholesaler' => $idwholesaler,
  151.             'server_name' => $_ENV["LOCAL_SERVER_NAME"],
  152.             'useSymbol' => $user->getWholesaler()->getUseSymbolCurrency(),
  153.             'priceCalculator' => $priceCalculator,
  154.             'operationalCurrency' => $this->operationalCurrencyProvider->provide($user->getWholesaler())
  155.         ]);
  156.     }
  159.     /**
  160.      * @Route("/catalog/default/vendor/{id}/{page}", name="catalog_vendor", requirements={"id"="\d+"}, defaults={"page"=1})
  161.      */
  162.     public function vendor($id, $page, TranslatorInterface $translator, Translation $translation, HeaderData $buildHeaderData, TrafficTracker $trafficTracker, PriceCalculatorService $priceCalculator, Request $request, OperationalCurrencyProvider $operationalCurrencyProvider)
  163.     {
  164.         $trafficTracker->registerTraffic();
  165.         $user = $this->getUser();
  166.         $entityManager = $this->getDoctrine()->getManager();
  167.         $vendorRepository = $this->getDoctrine()->getRepository(Vendors::class);
  168.         $partnerRepository = $this->getDoctrine()->getRepository(Partner::class);
  169.         $customerRepository = $this->getDoctrine()->getRepository(Customer::class);
  170.         $productRepository = $this->getDoctrine()->getRepository(Product::class);
  171.         $userRepository = $this->getDoctrine()->getRepository(User::class);
  172.         $operationalCurrency = $operationalCurrencyProvider->provide($userRepository->getCompany($user));
  173.         $vendor = $vendorRepository->find($id);
  174.         $customer = null;
  175.         $hasFilter = false;
  176.         $locale = $request->getLocale();
  178.         if ($user->getPartner()) {
  179.             $partner = $partnerRepository->MyPartnerQuery($user)->getQuery()->getSingleResult();
  180.         } elseif ($user->getWholesaler()) {
  181.             $partner = $partnerRepository->MyPartnerQuery($user)
  182.                 ->andWhere('p.wholesaler = :wholesaler ')
  183.                 ->setParameter('wholesaler', $user->getWholesaler()->getId())
  184.                 ->setMaxResults(1)
  185.                 ->getQuery()
  186.                 ->getOneOrNullResult();
  187.         } else {
  188.             $customer = $customerRepository->MyCustomerQuery($user)->getQuery()->getSingleResult();
  189.             $partner = $customer->getPartner();
  190.         }
  191.         $wholesaler = $partner->getWholesaler();
  193.         //Mirar si el mayorista tiene agreement para ese fabricante?
  194.         $hasAgreement = $userRepository->checkWholesalerAgreementByVendor($user, $vendor);
  196.         if (!$hasAgreement) {
  198.             if ($user->getWholesaler()) {
  199.                 return $this->redirectToRoute('catalog_customizemarket');
  200.             } else {
  201.                 return $this->redirectToRoute('catalog_goto');
  202.             }
  203.         }
  205.         $productsQuery = $productRepository->MyProductQuery($user)
  206.             ->andWhere('p.cansellalone = 1 and p.isflavour = 0 and p.cansell = 1')
  207.             ->andWhere('pl.vendor = :vendorId')
  208.             ->leftJoin('p.productLine', 'pl')
  209.             ->leftJoin('pl.categories', 'cat')
  210.             ->setParameter('vendorId', $id);
  212.         $programms = $entityManager->createQuery("SELECT vp FROM \App\Entity\Vendorprogramms vp "
  213.             . "JOIN App\Entity\Product p "
  214.             . "JOIN App\Entity\Productbywholesaler pbw "
  215.             . 'where vp.id = p.vendorProgramm and pbw.product=p.id and pbw.wholesaler = :idWholesaler and pbw.unregistrationdate is null and vp.vendor = :vendorId and p.cansell = 1')
  216.             ->setParameter('idWholesaler', $wholesaler->getId())
  217.             ->setParameter('vendorId', $id)
  218.             ->getResult();
  220.         $productLines = $entityManager->createQuery("SELECT pl FROM \App\Entity\Productline pl "
  221.             . "JOIN App\Entity\Product p "
  222.             . "JOIN App\Entity\Productbywholesaler pbw "
  223.             . 'where pl.id = p.productLine and pbw.product=p.id and pbw.wholesaler = :idWholesaler and pl.vendor = :vendorId and pl.unregistrationdate is null and pbw.unregistrationdate is null and p.cansell = 1')
  224.             ->setParameter('idWholesaler', $wholesaler->getId())
  225.             ->setParameter('vendorId', $id)
  226.             ->getResult();
  228.         $categories = $entityManager->createQuery("SELECT c FROM \App\Entity\Category c "
  229.             . "JOIN App\Entity\Product p "
  230.             . "JOIN App\Entity\Productbywholesaler pbw "
  231.             . "JOIN c.productlines pl "
  232.             . 'where pl.id = p.productLine and pbw.product=p.id and pbw.wholesaler = :idWholesaler and pl.vendor = :vendorId and pl.unregistrationdate is null and pbw.unregistrationdate is null and p.cansell = 1')
  233.             ->setParameter('idWholesaler', $wholesaler->getId())
  234.             ->setParameter('vendorId', $id)
  235.             ->getResult();
  237.         $form = $this->createForm(CatalogProductSearch::class, null, array(
  238.             'translator' => $translator,
  239.             'translation' => $translation,
  240.             'text' => $request->get('text'),
  241.             'productline' => $request->get('productline'),
  242.             'locale' => $locale,
  243.             'productlines' => $productLines,
  244.             'programm' => $programms,
  245.             'categories' => $categories,
  246.             'vendors' => array(),
  247.         ));
  249.         $form->handleRequest($request);
  251.         if ($form->get('text')->getData() || $form->get('productline')->getData() || $form->get('programm')->getData()) {
  252.             $hasFilter = true;
  254.             //save query in bd
  255.             $catalogQuery = new \App\Entity\Catalogquerys();
  256.             $catalogQuery->setUser($user);
  257.         }
  259.         $filters = [
  260.             'text' => null,
  261.             'programm' => null,
  262.             'productline' => null,
  263.             'category' => null
  264.         ];
  266.         //Custom filters
  267.         if ($form->get('text')->getData()) {
  268.             $productsQuery = $productsQuery
  269.                 ->andWhere("p.name like :text or p.sku like :text ")
  270.                 ->setParameter('text', '%' . $form->get('text')->getData() . '%');
  272.             $catalogQuery->setText($form->get('text')->getData());
  273.             $filters['text'] = $form->get('text')->getData();
  274.         }
  275.         if ($form->get('programm')->getData()) {
  276.             $productsQuery = $productsQuery
  277.                 ->andWhere("p.vendorProgramm = :programm ")
  278.                 ->setParameter('programm', $form->get('programm')->getData());
  280.             $catalogQuery->setIdProgramm($form->get('programm')->getData());
  281.             $filters['programm'] = $form->get('programm')->getData();
  282.         }
  283.         if ($form->get('productline')->getData()) {
  284.             $productsQuery = $productsQuery
  285.                 ->andWhere("p.productLine = :pl ")
  286.                 ->setParameter('pl', $form->get('productline')->getData());
  288.             $catalogQuery->setIdProductline($form->get('productline')->getData());
  289.             $filters['productline'] = $form->get('productline')->getData();
  290.         }
  291.         if ($form->get('category')->getData()) {
  292.             $productsQuery = $productsQuery
  293.                 ->andWhere("cat.id = :cat ")
  294.                 ->setParameter('cat', $form->get('category')->getData());
  296.             $filters['category'] = $form->get('category')->getData();
  297.         }
  299.         $pbwIds = "";
  300.         $productsWithoutFilterCtas = $this->catalogSingleVendorProducts($vendor);
  301.         $featuredCtas = $this->filterCatalogSingleVendorProducts($productsWithoutFilterCtas, $filters);
  302.         $lengthFeaturedProducts = sizeof($featuredCtas);
  304.         $limit = 18;
  305.         if ($page == 1) {
  306.             $limit = $limit - $lengthFeaturedProducts;
  307.             $featuredProducts = array();
  308.             foreach ($featuredCtas as $cta) {
  309.                 array_push($featuredProducts, $cta->getProductbywholesaler());
  310.             }
  311.             $featuredCtasArray = array();
  312.             foreach ($featuredCtas as $cta) {
  313.                 $featuredCtasArray[$cta->getProductbywholesaler()->getId()] = $cta;
  314.             }
  315.         }
  317.         $offset = 18;
  318.         if ($lengthFeaturedProducts > 0) //if get data from campaign
  319.         {
  320.             $pbwIds = array();
  321.             foreach ($featuredCtas as $cta) {
  322.                 array_push($pbwIds, $cta->getProductbywholesaler()->getId());
  323.             }
  324.             $offset = 18 - $lengthFeaturedProducts;
  325.         }
  327.         $productbywholesalerRepository = $this->getDoctrine()->getRepository(Productbywholesaler::class);
  328.         $productsbywholesaler = $productbywholesalerRepository->MyProductbywholesalerQuery($user)
  329.             ->leftJoin("pbw.product", "p");
  330.         if ($user->getCustomer() && $user->getCustomer()->getPartner()->getCustomProducts()) {
  331.             $productsbywholesaler = $productsbywholesaler
  332.                 ->leftJoin("App\Entity\ProductByCustomer", "pbc", Join::WITH, 'pbc.Product = p.id')
  333.                 ->andWhere('pbc.Product = pbw.product');
  334.         }
  335.         $productsbywholesaler = $productsbywholesaler
  336.             ->andWhere('pbw.product IN (:products)')
  337.             ->andWhere('pbw.id NOT IN (:featuredProducts)')
  338.             ->setParameter('products', $productsQuery->getQuery()->execute())
  339.             ->setParameter('featuredProducts', $pbwIds)
  340.             ->orderBy('p.name', 'asc');
  343.         //if filter, save result
  344.         if ($hasFilter) {
  345.             $result = '';
  346.             foreach ($productsbywholesaler->orderBy('p.name', 'asc')->getQuery()->execute() as $product) {
  347.                 $result = $result . $product->getId() . ',';
  348.             }
  349.             $catalogQuery->setResult($result);
  350.             $entityManager->persist($catalogQuery);
  351.             $entityManager->flush();
  352.         }
  355.         $productsbywholesaler->setFirstResult($offset * ($page - 1))->setMaxResults($limit);
  356.         $paginator = new Paginator($productsbywholesaler, $fetchJoinCollection = true);
  357.         $maxPages = ceil($paginator->count() / $limit);
  358.         $thisPage = $page;
  360.         return $this->render('/catalog/default/vendor.html.twig', [
  361.             'vendor' => $vendor,
  362.             'products' => $paginator->getIterator(),
  363.             'partner' => $partner,
  364.             'headerData' => $buildHeaderData->buildHeaderData($user),
  365.             'form' => $form->createView(),
  366.             'customer' => $customer,
  367.             'locale' => $locale,
  368.             'pbwRepository' => $this->getDoctrine()->getRepository(Productbywholesaler::class),
  369.             'productRepository' => $this->getDoctrine()->getRepository(Product::class),
  370.             'vendorsRepository' => $this->getDoctrine()->getRepository(Vendors::class),
  371.             'maxPages' => $maxPages,
  372.             'thisPage' => $thisPage,
  373.             'count' => count($paginator),
  374.             'programms' => count($programms),
  375.             'categories' => count($categories),
  376.             'vendorRepo' => $vendorRepository,
  377.             'vendors' => 0,
  378.             'featuredProducts' => $page == 1 ? $featuredProducts : null,
  379.             'featuredCtasArray' => $page == 1 ? $featuredCtasArray : null,
  380.             'useSymbol' => $partner->getWholesaler()->getUseSymbolCurrency(),
  381.             'priceCalculator' => $priceCalculator,
  382.             'operationalCurrency' => $operationalCurrency
  383.         ]);
  384.     }
  386.     /**
  387.      * @Route("/catalog/default/vendors", name="catalog_vendors")
  388.      */
  389.     public function vendors(TranslatorInterface $translator, Translation $translation, HeaderData $buildHeaderData, TrafficTracker $trafficTracker, Request $request)
  390.     {
  391.         $trafficTracker->registerTraffic();
  392.         $user = $this->getUser();
  393.         $locale = $request->getLocale();
  394.         $entityManager = $this->getDoctrine()->getManager();
  395.         $vendorRepository = $this->getDoctrine()->getRepository(Vendors::class);
  396.         $partnerRepository = $this->getDoctrine()->getRepository(Partner::class);
  397.         $customerRepository = $this->getDoctrine()->getRepository(Customer::class);
  398.         $productRepository = $this->getDoctrine()->getRepository(Product::class);
  399.         $userRepository = $this->getDoctrine()->getRepository(User::class);
  401.         if ($user->getPartner()) {
  402.             $partner = $partnerRepository->MyPartnerQuery($user)->getQuery()->getSingleResult();
  403.         } elseif ($user->getWholesaler()) {
  404.             $partner = $partnerRepository->MyPartnerQuery($user)
  405.                 ->andWhere('p.wholesaler = :wholesaler ')
  406.                 ->setParameter('wholesaler', $user->getWholesaler()->getId())
  407.                 ->setMaxResults(1)
  408.                 ->getQuery()
  409.                 ->getOneOrNullResult();
  410.         } else {
  411.             $customer = $customerRepository->MyCustomerQuery($user)->getQuery()->getSingleResult();
  412.             $partner = $customer->getPartner();
  413.         }
  414.         $wholesaler = $partner->getWholesaler();
  416.         $featuredVendorArray = $this->catalogFeaturedVendors();
  417.         $lengthFeaturedVendorArray = sizeof($featuredVendorArray);
  418.         $limit = 18;
  419.         $limit = $limit - $lengthFeaturedVendorArray;
  420.         $offset = 18;
  421.         $vendorIds = "";
  422.         if ($lengthFeaturedVendorArray > 0) {
  423.             $offset = 18 - $lengthFeaturedVendorArray;
  424.             $vendorIds = array();
  425.             foreach ($featuredVendorArray as $cta) {
  426.                 array_push($vendorIds, $cta->getVendor()->getId());
  427.             }
  428.         }
  430.         $vendors = $entityManager->createQueryBuilder()
  431.             ->select('DISTINCT v')
  432.             ->from('App\Entity\Vendors', 'v')
  433.             ->join('App\Entity\Productline', 'pl', 'WITH', 'pl.vendor = v.id')
  434.             ->join('App\Entity\Product', 'p', 'WITH', 'p.productLine = pl.id')
  435.             ->join('App\Entity\Productbywholesaler', 'pbw', 'WITH', 'pbw.product = p.id')
  436.             ->where('pbw.wholesaler = :idWholesaler');
  437.         if ($user->getCustomer() && $user->getCustomer()->getPartner()->getCustomProducts()) {
  438.             $vendors = $vendors
  439.                 ->leftJoin("App\Entity\ProductByCustomer", "pbc", Join::WITH, 'pbc.Product = p.id')
  440.                 ->andWhere('pbc.Product = pbw.product');
  441.         }
  442.         $vendors = $vendors
  443.             ->andWhere('pbw.unregistrationdate IS NULL')
  444.             ->andWhere('v.id NOT IN (:vendors)')
  445.             ->orderBy('v.name', 'ASC')
  446.             ->setParameter('idWholesaler', $wholesaler->getId())
  447.             ->setParameter('vendors', $vendorIds);
  449.         $vendors->setMaxResults($limit);
  450.         $paginator = new Paginator($vendors, $fetchJoinCollection = false);
  451.         $maxPages = ceil($paginator->count() / $limit);
  453.         return $this->render('/catalog/default/vendors.html.twig', [
  454.             'vendors' => $paginator,
  455.             'vendorsRepository' => $this->getDoctrine()->getRepository(Vendors::class),
  456.             'headerData' => $buildHeaderData->buildHeaderData($user),
  457.             'remaining' => $paginator->count() - $limit,
  458.             'nextOffset' => $offset,
  459.             'featuredVendorArray' => $featuredVendorArray,
  460.         ]);
  461.     }
  464.     /**
  465.      * @Route("/catalog/default/category/{id}/{page}", name="catalog_category", requirements={"id"="\d+"}, defaults={"page"=1})
  466.      */
  467.     public function category($id, $page, TranslatorInterface $translator, Translation $translation, HeaderData $buildHeaderData, TrafficTracker $trafficTracker, PriceCalculatorService $priceCalculator, Request $request)
  468.     {        
  469.         $trafficTracker->registerTraffic();
  470.         $entityManager = $this->getDoctrine()->getManager();
  471.         $partnerRepository = $this->getDoctrine()->getRepository(Partner::class);
  472.         $customerRepository = $this->getDoctrine()->getRepository(Customer::class);
  473.         $userRespository = $this->getDoctrine()->getRepository(User::class);
  474.         $wholesalerRepository = $this->getDoctrine()->getRepository(Wholesaler::class);
  475.         $productRepository = $this->getDoctrine()->getRepository(Product::class);
  476.         $categoryRepository = $this->getDoctrine()->getRepository(Category::class);
  477.         $productlineRepository = $this->getDoctrine()->getRepository(Productline::class);
  478.         $locale = $request->getLocale();
  479.         $user = $this->getUser();
  480.         $category = $categoryRepository->find($id);
  481.         $customer = null;
  482.         $hasFilter = false;
  483.         $target = $userRespository->getCompany($this->getUser());
  485.         if ($user->getPartner()) {
  486.             $partner = $partnerRepository->MyPartnerQuery($user)->getQuery()->getSingleResult();
  487.             $wholesaler = $partner->getWholesaler();
  488.             $partnerId = $partner->getId();
  489.         } elseif ($user->getCustomer()) {
  490.             $customer = $customerRepository->MyCustomerQuery($user)->getQuery()->getSingleResult();
  491.             $partner = $customer->getPartner();
  492.             $wholesaler = $partner->getWholesaler();
  493.             $partnerId = $partner->getId();
  494.         } else {
  495.             $wholesaler = $wholesalerRepository->MyWholesalerQuery($user)->getQuery()->getSingleResult();
  496.             $partnerId = '';
  497.         }
  499.         $productsQuery = $productRepository->MyProductQuery($user)
  500.             ->andWhere('p.cansellalone = 1 and p.isflavour = 0 and c.id = :catId and p.cansell = 1')
  501.             ->leftJoin('p.productLine', 'pl')
  502.             ->leftJoin('pl.categories', 'c')
  503.             ->leftJoin('pl.vendor', 'v')
  504.             ->setParameter('catId', $id);
  506.         $productLines = $entityManager->createQuery("SELECT pl FROM \App\Entity\Productline pl "
  507.             . "JOIN App\Entity\Product p "
  508.             . "JOIN App\Entity\Productbywholesaler pbw "
  509.             . "JOIN pl.categories cat "
  510.             . 'where pl.id = p.productLine and pbw.product=p.id and pbw.wholesaler = :idWholesaler and cat.id = :catId and pl.unregistrationdate is null and pbw.unregistrationdate is null')
  511.             ->setParameter('idWholesaler', $wholesaler->getId())
  512.             ->setParameter('catId', $id)
  513.             ->getResult();
  515.         $vendors = $entityManager->createQuery("SELECT v FROM \App\Entity\Vendors v "
  516.             . "JOIN App\Entity\Productline pl "
  517.             . "JOIN App\Entity\Product p "
  518.             . "JOIN App\Entity\Productbywholesaler pbw "
  519.             . "JOIN pl.categories cat "
  520.             . 'where pl.vendor = v.id and pl.id = p.productLine and pbw.product=p.id and pbw.wholesaler = :idWholesaler and cat.id = :catId and pl.unregistrationdate is null and pbw.unregistrationdate is null')
  521.             ->setParameter('idWholesaler', $wholesaler->getId())
  522.             ->setParameter('catId', $id)
  523.             ->getResult();
  525.         $form = $this->createForm(CatalogProductSearch::class, null, array(
  526.             'translator' => $translator,
  527.             'translation' => $translation,
  528.             'text' => $request->get('text'),
  529.             'productline' => $request->get('productline'),
  530.             'locale' => $locale,
  531.             'productlines' => $productLines,
  532.             'programm' => array(),
  533.             'categories' => array(),
  534.             'vendors' => $vendors,
  535.         ));
  537.         $form->handleRequest($request);
  539.         if ($form->get('text')->getData() || $form->get('productline')->getData()) {
  540.             $hasFilter = true;
  542.             //save query in bd
  543.             $catalogQuery = new \App\Entity\Catalogquerys();
  544.             $catalogQuery->setUser($user);
  545.         }
  547.         //Custom filters
  548.         if ($form->get('text')->getData()) {
  549.             $productsQuery = $productsQuery
  550.                 ->andWhere("p.name like :text or p.sku like :text ")
  551.                 ->setParameter('text', '%' . $form->get('text')->getData() . '%');
  552.         }
  554.         if ($form->get('productline')->getData()) {
  555.             $productsQuery = $productsQuery
  556.                 ->andWhere("p.productLine = :pl ")
  557.                 ->setParameter('pl', $form->get('productline')->getData());
  558.         }
  560.         if ($form->get('vendor')->getData()) {
  561.             $productsQuery = $productsQuery
  562.                 ->andWhere("v.id = :vId ")
  563.                 ->setParameter('vId', $form->get('vendor')->getData());
  564.         }
  566.         $productbywholesalerRepository = $this->getDoctrine()->getRepository(Productbywholesaler::class);
  567.         $productsbywholesaler = $productbywholesalerRepository->MyProductbywholesalerQuery($user)
  568.             ->leftJoin("pbw.product", "p");
  569.         if ($user->getCustomer() && $user->getCustomer()->getPartner()->getCustomProducts()) {
  570.             $productsbywholesaler = $productsbywholesaler
  571.                 ->leftJoin("App\Entity\ProductByCustomer", "pbc", Join::WITH, 'pbc.Product = p.id')
  572.                 ->andWhere('pbc.Product = pbw.product');
  573.         }
  574.         $productsbywholesaler = $productsbywholesaler
  575.             ->andWhere('pbw.product IN (:products)')
  576.             ->setParameter('products', $productsQuery->getQuery()->execute())
  577.             ->orderBy('p.name', 'asc');
  579.         if ($hasFilter) {
  580.             $result = '';
  582.             foreach ($productsbywholesaler->orderBy('p.name', 'asc')->getQuery()->execute() as $product) {
  583.                 $result = $result . $product->getId() . ',';
  584.             }
  586.             $catalogQuery->setResult($result);
  587.             $entityManager->persist($catalogQuery);
  588.             $entityManager->flush();
  589.         }
  591.         $limit = 18;
  592.         $productsbywholesaler->setFirstResult($limit * ($page - 1))->setMaxResults($limit);
  593.         $paginator = new Paginator($productsbywholesaler, $fetchJoinCollection = true);
  594.         $maxPages = ceil($paginator->count() / $limit);
  595.         $thisPage = $page;
  597.         return $this->render('/catalog/default/category.html.twig', [
  598.             'category' => $category,
  599.             'products' => $paginator->getIterator(),
  600.             'partnerId' => $partnerId,
  601.             'partner' => null,
  602.             'headerData' => $buildHeaderData->buildHeaderData($user),
  603.             'form' => $form->createView(),
  604.             'customer' => $customer,
  605.             'locale' => $locale,
  606.             'pbwRepository' => $this->getDoctrine()->getRepository(Productbywholesaler::class),
  607.             'productRepository' => $this->getDoctrine()->getRepository(Product::class),
  608.             'vendorsRepository' => $this->getDoctrine()->getRepository(Vendors::class),
  609.             'maxPages' => $maxPages,
  610.             'thisPage' => $thisPage,
  611.             'count' => count($paginator),
  612.             'programms' => 0,
  613.             'categories' => 0,
  614.             'vendors' => count($vendors),
  615.             'category_name' => $translation->getTranslationBy($category, $locale, 'name'),
  616.             'useSymbol' => $wholesaler->getUseSymbolCurrency(),
  617.             'priceCalculator' => $priceCalculator,
  618.             'operationalCurrency' => $this->operationalCurrencyProvider->provide($target),
  619.             'cnClientInfo' => ($this->connectifService->cnClientInfo($user)),
  620.         ]);
  621.     }
  624.     /**
  625.      * @Route("/catalog/default/view/{id}", name="catalog_view", requirements={"id"="\d+"})
  626.      */
  627.     public function view($id, TrafficTracker $trafficTracker, TranslatorInterface $translator, Translation $translation, DataProductFinder $dataProductFinder, HeaderData $buildHeaderData, PriceCalculatorService $priceCalculator, JsonSearchService $jsonSearchService, Request $request, ExtraFieldsService $extraFieldsService)
  628.     {
  629.         $trafficTracker->registerTraffic();
  630.         $entityManager = $this->getDoctrine()->getManager();
  631.         $pbwRepository = $this->getDoctrine()->getRepository(Productbywholesaler::class);
  632.         $partnerRepository = $this->getDoctrine()->getRepository(Partner::class);
  633.         $wholesalerRepository = $this->getDoctrine()->getRepository(Wholesaler::class);
  634.         $customerRepository = $this->getDoctrine()->getRepository(Customer::class);
  635.         $productRepository = $this->getDoctrine()->getRepository(Product::class);
  636.         $resourceRepository = $this->getDoctrine()->getRepository(Resources::class);
  637.         $userRepository = $this->getDoctrine()->getRepository(User::class);
  638.         $licensetypeRepository = $this->getDoctrine()->getRepository(\App\Entity\Licensetype::class);
  640.         $user = $this->getUser();
  641.         $locale = $request->getLocale();
  643.         $commercialEmail = '';
  644.         $markup_value = 0;
  645.         $discount = 0;
  646.         $isVendor = false;
  648.         $pbw = $pbwRepository->MyProductbywholesalerQuery($user)
  649.             ->andWhere('pbw.id = :id')->setParameter('id', $id);
  650.         if ($user->getCustomer() && $user->getCustomer()->getPartner()->getCustomProducts()) {
  651.             $pbw = $pbw
  652.                 ->leftJoin("pbw.product", "p")
  653.                 ->leftJoin("App\Entity\ProductByCustomer", "pbc", Join::WITH, 'pbc.Product = p.id')
  654.                 ->andWhere('pbc.Product = pbw.product');
  655.         }
  656.         $pbw = $pbw
  657.             ->setMaxResults(1)
  658.             ->getQuery()
  659.             ->getOneOrNullResult();
  661.         $partner = null;
  662.         if ($user->getPartner()) {
  664.             if (!$pbw || $pbw->getProduct()->getProducttype() == null || $pbw->getProduct()->getCanSellAlone() == 0) {
  665.                 return $this->redirect($this->generateUrl('catalog_goto'));
  666.             }
  668.             $partner = $partnerRepository->MyPartnerQuery($user)->getQuery()->getSingleResult();
  669.             $commercialUser = $this->getDoctrine()->getRepository(\App\Entity\User::class)->find($partner->getIdcommercialagent());
  670.             $commercialEmail = $commercialUser->getEmail();
  671.             $isPartner = true;
  672.             $isWholesaler = false;
  673.             $wholesaler = $user->getPartner()->getWholesaler();
  674.             $target = $partner;
  675.             if (!$pbw) {
  676.                 return $this->redirect($this->generateUrl('catalog_goto'));
  677.             }
  678.         } elseif ($user->getWholesaler()) {
  680.             if (!$pbw || $pbw->getProduct()->getProducttype() == null || $pbw->getProduct()->getCanSellAlone() == 0) {
  681.                 return $this->redirect($this->generateUrl('catalog_customizemarket'));
  682.             }
  684.             $wholesaler = $wholesalerRepository->MyWholesalerQuery($user)->getQuery()->getSingleResult();
  685.             
  686.             //TODO hotfix por un calculo necesiario para el product DataFinder - eliminar el precio de allí
  687.             $partner = $entityManager->createQuery('SELECT p FROM App\Entity\Partner p '
  688.             . 'where p.wholesaler = :wholesaler ')
  689.             ->setParameters(array('wholesaler' => $wholesaler->getId()))
  690.             ->setMaxResults(1)
  691.             ->getOneOrNullResult();
  693.             $isPartner = false;
  694.             $isWholesaler = true;
  695.             $wholesaler = $user->getWholesaler();
  696.             $target = $wholesaler;
  697.         } elseif ($user->getVendor()) {
  699.             $wholesaler = $wholesalerRepository->MyWholesalerQuery($user)->setMaxResults(1)->getQuery()->getSingleResult();
  700.             $partner = $entityManager->createQuery('SELECT p FROM App\Entity\Partner p '
  701.                 . 'where p.wholesaler = :wholesaler ')
  702.                 ->setParameters(array('wholesaler' => $wholesaler->getId()))
  703.                 ->setMaxResults(1)
  704.                 ->getOneOrNullResult();
  705.             $isPartner = false;
  706.             $isVendor = true;
  707.             $isWholesaler = false;
  708.             $target = $wholesaler;
  709.         } else {
  711.             if (!$pbw || $pbw->getProduct()->getCanSellAlone() == 0) {
  712.                 return $this->redirect($this->generateUrl('catalog_goto'));
  713.             }
  715.             $customer = $customerRepository->MyCustomerQuery($user)
  716.                 ->andWhere('c.id = :customerId ')
  717.                 ->setParameter('customerId', $user->getCustomer()->getId())
  718.                 ->getQuery()->getSingleResult();
  719.             $wholesaler = $user->getCustomer()->getPartner()->getWholesaler();
  720.             $partner = $customer->getPartner();
  721.             $commercialUser = $this->getDoctrine()->getRepository(\App\Entity\User::class)->find($customer->getIdcommercialagent());
  722.             $commercialEmail = $commercialUser->getEmail();
  723.             $isPartner = false;
  724.             $isWholesaler = false;
  725.             $target = $customer;
  726.         }
  729.         $promotion = null;
  730.         if ($pbwRepository->getProductPromotion($pbw, 1)['pp']) {
  731.             $promotion = $pbwRepository->getProductPromotion($pbw, 1)['pp']->getPromotion();
  732.         }
  734.         $customers = $customerRepository->MyCustomerQuery($user)
  735.             ->andWhere('c.unregistrationdate is NULL ')
  736.             ->andWhere('c.is_self_consumption is NULL ')
  737.             ->orderBy('c.company', 'DESC')
  738.             ->getQuery()
  739.             ->getResult();
  741.         if ($user->getPartner()) {
  742.             $selfConsumptionCustomer = $partnerRepository->getSelfConsumptionCustomer($partner);
  744.             if ($selfConsumptionCustomer) {
  745.                 array_unshift($customers, $selfConsumptionCustomer);
  746.             }
  747.         }
  749.         // TO-DO : revisar si se tiene que borrar.
  750.         $licenseTypeIds=$jsonSearchService->searchKeyInArray($productRepository->getParentSkuIds($pbw->getProduct())->getParameters(), 'licenseType');
  751.         $licenseTypes=[];
  752.         if($licenseTypeIds){
  753.             foreach($licenseTypeIds[0] as $value){
  754.                 $lt = $licensetypeRepository->find((int)$value);
  755.                 $licenseTypes[$lt->getId()] = $translation->getTranslationBy($lt, $locale, 'name');   
  756.             }
  757.         }
  759.         $parametersTranslated = $extraFieldsService->translateExtraFields(
  760.             $productRepository->getParentSkuIds($pbw->getProduct())->getParameters() ?? []
  761.         );
  763.         $data_to_view = array(
  764.             'headerData' => $buildHeaderData->buildHeaderData($user),
  765.             'recomended' => $this->similarProducts($pbw->getId()),
  766.             'resources' => $this->relatedResources($pbw->getId()),
  767.             'ratingreview' => $this->ratingReview($pbw->getProduct()->getId()),
  768.             'images' => $pbwRepository->getImages($pbw),
  769.             'defaultimage' => $pbwRepository->getDefaultImages($pbw),
  770.             'canSell' => $pbw->getProduct()->getCanSell(),
  771.             'commercialEmail' => $commercialEmail,
  772.             'ispartner' => $isPartner,
  773.             'partnerDiscount' => $discount,
  774.             'locale' => $locale,
  775.             'isWholesaler' => $isWholesaler,
  776.             'isVendor' => $isVendor,
  777.             'promotion' => $promotion,
  778.             'pbwRepository' => $this->getDoctrine()->getRepository(Productbywholesaler::class),
  779.             'vendorsRepository' => $this->getDoctrine()->getRepository(Vendors::class),
  780.             'userRepository' => $this->getDoctrine()->getRepository(User::class),
  781.             'partner' => $partner,
  782.             'i18n' => $translation,
  783.             'customers' => $customers,
  784.             'resourceRepository' => $resourceRepository,
  785.             'useSymbol' => $wholesaler->getUseSymbolCurrency(),
  786.             'priceCalculator' => $priceCalculator,
  787.             'target' => $target, //Partner, Customer or Wholesaler
  788.             'cnClientInfo' => ($this->connectifService->cnClientInfo($user)),
  789.             'cnProductVisited' => ($this->connectifService->cnProductVisited()),
  790.             'cnCart' => ($user->getPartner() || $user->getCustomer()) ? $this->connectifService->cnCart($user) : null,
  791.             'operationalCurrency' => $this->operationalCurrencyProvider->provide($target),
  792.             'licenseType' => $licenseTypes, 
  793.             'wholesaler' => $wholesaler,
  794.             'warehouseProductRepository' => $this->getDoctrine()->getRepository(WarehouseProduct::class),
  795.             'parametersTranslated' => $parametersTranslated
  796.         );
  798.         $typeofproduct = $pbw->getProduct()->getProductType();
  799.         $dataPbw = $dataProductFinder->findData($pbwRepository, $typeofproduct, $pbw, $partner, $wholesaler->getId(), $user);
  801.         $data_to_view = array_merge($data_to_view, $dataPbw);
  803.         return $this->render('/catalog/default/view.html.twig', $data_to_view);
  804.     }
  807.     /**    
  808.      * @Route("/catalog/default/genericsearch/{page}", name="catalog_genericsearch", defaults={"page"=1})
  809.      *
  810.      * Save reviews from a Product in BD
  811.      * 
  812.      */
  813.     public function genericsearch($page, TrafficTracker $trafficTracker, Request $request, SanitizeService $sanitizeService, HeaderData $buildHeaderData, PriceCalculatorService $priceCalculator)
  814.     {
  815.         if (!$sanitizeService->getSanitize($request->get('text'))) {
  816.             return $this->redirectToRoute('catalog_genericsearch');
  817.         }
  818.         $trafficTracker->registerTraffic();
  819.         $user = $this->getUser();
  820.         $search = '';
  822.         $entityManager = $this->getDoctrine()->getManager();
  823.         $partnerRepository = $this->getDoctrine()->getRepository(Partner::class);
  824.         $wholesalerRepository = $this->getDoctrine()->getRepository(Wholesaler::class);
  825.         $customerRepository = $this->getDoctrine()->getRepository(Customer::class);
  826.         $productRepository = $this->getDoctrine()->getRepository(Product::class);
  827.         $productbywholesalerRepository = $this->getDoctrine()->getRepository(Productbywholesaler::class);
  829.         if ($user->getPartner()) {
  830.             $partner = $partnerRepository->MyPartnerQuery($user)->getQuery()->getSingleResult();
  831.             $wholesaler = $partner->getWholesaler();
  832.             $partnerId = $partner->getId();
  833.             $target=$user->getPartner();
  834.         } elseif ($user->getCustomer()) {
  835.             $customer = $customerRepository->MyCustomerQuery($user)->getQuery()->getSingleResult();
  836.             $partner = $customer->getPartner();
  837.             $wholesaler = $partner->getWholesaler();
  838.             $partnerId = $partner->getId();
  839.             $target=$user->getCustomer();
  840.         } else {
  841.             $wholesaler = $wholesalerRepository->MyWholesalerQuery($user)->getQuery()->getSingleResult();
  842.             $partnerId = '';
  843.             $partner = null;
  844.             $target=$wholesaler;
  845.         }
  847.         $products = $productRepository->MyProductQuery($user)
  848.             ->andWhere('p.cansellalone = 1 and p.isflavour = 0 and p.cansell = 1');
  850.         //Custom filters      
  851.         if ($request->get('text')) {
  853.             $productIds = $productRepository->MyProductQuery($user)
  854.                 ->andWhere('p.name like :text or p.sku like :text ')
  855.                 ->setParameter('text', '%' . $request->get('text') . '%')
  856.                 ->andWhere('p.cansellalone = 1 and p.cansell = 1')
  857.                 ->getQuery()
  858.                 ->execute();
  860.             $products
  861.                 ->andWhere('p.name like :text or p.sku like :text ')
  862.                 ->setParameter('text', '%' . $request->get('text') . '%');
  864.             foreach ($productIds as $pId) {
  865.                 $parentId = $productRepository->getParentSkuIds($pId);
  866.                 $products->orWhere('p.id = :parentId')->setParameter('parentId', $parentId);
  867.             }
  868.         }
  871.         $productsbywholesaler = $productbywholesalerRepository->MyProductbywholesalerQuery($user)
  872.             ->andWhere('pbw.product IN (:products)')
  873.             ->setParameter('products', $products->getQuery()->execute());
  875.         //if search
  876.         if ($request->get('text')) {
  878.             $result = '';
  880.             //search result
  881.             foreach ($productsbywholesaler->getQuery()->execute() as $product) {
  882.                 $result = $result . $product->getId() . ',';
  883.             }
  885.             //save query in bd
  886.             $catalogQuery = new \App\Entity\Catalogquerys();
  887.             $catalogQuery->setText($request->get('text'));
  888.             $catalogQuery->setUser($user);
  889.             $catalogQuery->setResult($result);
  890.             $entityManager->persist($catalogQuery);
  891.             $entityManager->flush();
  892.         }
  894.         $limit = 12;
  895.         $productsbywholesaler->setFirstResult($limit * ($page - 1))->setMaxResults($limit);
  896.         $paginator = new Paginator($productsbywholesaler, $fetchJoinCollection = true);
  897.         $maxPages = ceil($paginator->count() / $limit);
  898.         $thisPage = $page;
  901.         $search = '"' . $request->get('text') . '"';
  903.         return $this->render('/catalog/default/genericsearch.html.twig', [
  904.             'products' => $paginator->getIterator(),
  905.             'categories' => null, //array(),
  906.             'partnerId' => $partnerId,
  907.             'partner' => $partner,
  908.             'headerData' => $buildHeaderData->buildHeaderData($user),
  909.             'search' => $search,
  910.             'maxPages' => $maxPages,
  911.             'thisPage' => $thisPage,
  912.             'count' => count($paginator),
  913.             'pbwRepository' => $this->getDoctrine()->getRepository(Productbywholesaler::class),
  914.             'productRepository' => $this->getDoctrine()->getRepository(Product::class),
  915.             'vendorsRepository' => $this->getDoctrine()->getRepository(Vendors::class),
  916.             'useSymbol' => $wholesaler->getUseSymbolCurrency(),
  917.             'priceCalculator' => $priceCalculator,
  918.             'target' => $target
  919.         ]);
  920.     }
  923.     /**    
  924.      * @Route("/catalog/default/writereview", name="catalog_writereview")
  925.      *
  926.      * Save reviews from a Product in BD
  927.      * 
  928.      */
  929.     public function writereview(Request $request, TrafficTracker $trafficTracker)
  930.     {
  931.         $trafficTracker->registerTraffic();
  932.         $entityManager = $this->getDoctrine()->getManager();
  933.         $user = $this->getUser();
  934.         $id = $request->request->get('idproduct');
  936.         $pbwRepository = $this->getDoctrine()->getRepository(Productbywholesaler::class);
  937.         $productByWholesaler = $pbwRepository->find($id);
  939.         $review = $request->request->get('review');
  940.         $rating = $request->request->get('rating');
  942.         $productOpinions = new Productopinions();
  943.         $productOpinions->setProduct($productByWholesaler->getProduct());
  944.         $productOpinions->setUser($user);
  945.         $productOpinions->setScore($rating);
  946.         $productOpinions->setComment($review);
  948.         $entityManager->persist($productOpinions);
  949.         $entityManager->flush();
  951.         $response = new \Symfony\Component\HttpFoundation\JsonResponse();
  952.         $response->setStatusCode(200);
  953.         return $response;
  954.     }
  956.     /**
  957.      * @Route("/catalog/default/loadvendors", name="catalog_load_vendors")
  958.      *
  959.      *
  960.      * 
  961.      */
  962.     public function getMoreVendors(Request $request, TranslatorInterface $translator)
  963.     {
  965.         $user = $this->getUser();
  966.         $em = $this->getDoctrine()->getManager();
  967.         $offset = $request->get('offset');
  968.         $limit = 6;
  969.         $partnerRepository = $this->getDoctrine()->getRepository(Partner::class);
  970.         $customerRepository = $this->getDoctrine()->getRepository(Customer::class);
  971.         $vendorRepository = $this->getDoctrine()->getRepository(Vendors::class);
  973.         if ($user->getPartner()) {
  974.             $partner = $partnerRepository->MyPartnerQuery($user)->getQuery()->getSingleResult();
  975.         } elseif ($user->getWholesaler()) {
  976.             $partner = $partnerRepository->MyPartnerQuery($user)
  977.                 ->andWhere('p.wholesaler = :wholesaler ')
  978.                 ->setParameter('wholesaler', $user->getWholesaler()->getId())
  979.                 ->setMaxResults(1)
  980.                 ->getQuery()
  981.                 ->getOneOrNullResult();
  982.         } else {
  983.             $customer = $customerRepository->MyCustomerQuery($user)->getQuery()->getSingleResult();
  984.             $partner = $customer->getPartner();
  985.         }
  986.         $wholesaler = $partner->getWholesaler();
  988.         $featuredVendorArray = $this->catalogFeaturedVendors();
  989.         $lengthFeaturedVendorArray = sizeof($featuredVendorArray);
  991.         $vendorIds = "";
  992.         if ($lengthFeaturedVendorArray > 0) {
  993.             $vendorIds = array();
  994.             foreach ($featuredVendorArray as $cta) {
  995.                 array_push($vendorIds, $cta->getVendor()->getId());
  996.             }
  997.         }
  999.         $vendors = $em->createQuery("SELECT DISTINCT v from App\Entity\Vendors v "
  1000.             . "JOIN App\Entity\Productline pl "
  1001.             . "JOIN App\Entity\Product p "
  1002.             . "JOIN App\Entity\Productbywholesaler pbw "
  1003.             . "WHERE pl.vendor = v.id and pbw.product = p.id and p.productLine = pl.id and pbw.wholesaler = :idWholesaler and pbw.unregistrationdate is null and v.id NOT IN (:vendors) "
  1004.             . "ORDER BY v.name ASC")
  1005.             ->setParameter("idWholesaler", $wholesaler->getId())
  1006.             ->setParameter('vendors', $vendorIds)
  1007.             ->setFirstResult($offset)
  1008.             ->setMaxResults($limit);
  1010.         $vendorsResult = $vendors->getResult();
  1012.         $vendorsArray = array();
  1013.         foreach ($vendorsResult as $vendor) {
  1014.             array_push($vendorsArray, array('id' => $vendor->getId(), 'name' => $vendor->getName(), 'img' => $vendorRepository->getRouteCompanyLogo($vendor)));
  1015.         }
  1017.         $paginator = new Paginator($vendors, $fetchJoinCollection = true);
  1018.         $maxPages = ceil($paginator->count() / $limit);
  1020.         $data = array(
  1021.             'vendors' => $vendorsArray,
  1022.             'newOffset' => $offset + sizeof($vendorsResult),
  1023.             'remaining' => $paginator->count() - $limit - $offset,
  1024.         );
  1026.         $response = json_encode($data);
  1028.         return new Response($response, 200, array(
  1029.             'Content-Type' => 'application/json'
  1030.         ));
  1031.     }
  1034.     /**
  1035.      * Get recomended products(6) to show in catalog index
  1036.      * 
  1037.      * @param $idwholesaler
  1038.      * 
  1039.      */
  1040.     private function catalogCoverProducts()
  1041.     {
  1042.         $user = $this->getUser();
  1043.         /** @var UserRepository */
  1044.         $userRepository = $this->getDoctrine()->getRepository(User::class);
  1045.         /** @var CtaRepository */
  1046.         $ctaRepository = $this->getDoctrine()->getRepository(Cta::class);
  1048.         $wholesalerId = $userRepository->getParentWholesaler($user)->getId();
  1049.         $recomendedArray = array();
  1051.         for ($i = 30; $i <= 41; $i++) {
  1053.             $cta = $ctaRepository->MyCtaQuery($wholesalerId, $i);
  1055.             if (is_null($cta)) {
  1056.                 $cta = $ctaRepository->MyCtaDefaultQuery($wholesalerId, $i);
  1057.             }
  1059.             array_push($recomendedArray, $cta);
  1060.         }
  1062.         return $recomendedArray;
  1063.     }
  1065.     /**
  1066.      * Get Featued Vendors (6) to show in vendor page
  1067.      * 
  1068.      * @param $vendor
  1069.      * 
  1070.      */
  1071.     private function catalogFeaturedVendors()
  1072.     {
  1073.         $user = $this->getUser();
  1074.         /** @var UserRepository */
  1075.         $userRepository = $this->getDoctrine()->getRepository(User::class);
  1076.         /** @var CtaRepository */
  1077.         $ctaRepository = $this->getDoctrine()->getRepository(Cta::class);
  1079.         $wholesalerId = $userRepository->getParentWholesaler($user)->getId();
  1080.         $featuredVendorArray = array();
  1082.         for ($i = 63; $i <= 68; $i++) {
  1084.             $cta = $ctaRepository->MyCtaQuery($wholesalerId, $i);
  1086.             if (is_null($cta)) {
  1087.                 $cta = $ctaRepository->MyCtaDefaultQuery($wholesalerId, $i);
  1088.             }
  1090.             if (!is_null($cta)) {
  1091.                 array_push($featuredVendorArray, $cta);
  1092.             }
  1093.         }
  1094.         return $featuredVendorArray;
  1095.     }
  1097.     /**
  1098.      * Get SingleVendorProducts (3) to show in vendor page
  1099.      * 
  1100.      * @param $vendor
  1101.      * 
  1102.      */
  1103.     private function catalogSingleVendorProducts($vendor)
  1104.     {
  1105.         $user = $this->getUser();
  1106.         /** @var UserRepository */
  1107.         $userRepository = $this->getDoctrine()->getRepository(User::class);
  1108.         /** @var CtaRepository */
  1109.         $ctaRepository = $this->getDoctrine()->getRepository(Cta::class);
  1111.         $wholesalerId = $userRepository->getParentWholesaler($user)->getId();
  1112.         $singleVendorProductsArray = array();
  1114.         for ($i = 57; $i <= 59; $i++) {
  1116.             $cta = $ctaRepository->MyCtaDinamicVendorQuery($wholesalerId, $i, $vendor);
  1118.             if (is_null($cta)) {
  1119.                 $cta = $ctaRepository->MyCtaDefaultDinamicVendorQuery($wholesalerId, $i, $vendor);
  1120.             }
  1122.             if (!is_null($cta) && !is_null($cta->getProductbywholesaler())) {
  1123.                 array_push($singleVendorProductsArray, $cta);
  1124.             }
  1125.         }
  1126.         return $singleVendorProductsArray;
  1127.     }
  1129.     private function filterCatalogSingleVendorProducts($products, $filters)
  1130.     {
  1131.         $user = $this->getUser();
  1132.         /** @var ProductRepository */
  1133.         $productRepository = $this->getDoctrine()->getRepository(Product::class);
  1134.         /** @var UserRepository */
  1135.         $userRepository = $this->getDoctrine()->getRepository(User::class);
  1137.         $singleVendorProductsArray = array_filter($products, function ($obj) use ($filters, $productRepository, $user) {
  1138.             $cumpleTexto = true;
  1139.             if (isset($filters['text'])) {
  1140.                 $texto = $filters['text'];
  1141.                 $cumpleTexto = stripos($obj->getProductbywholesaler()->getProduct()->getName(), $texto) !== false || stripos($obj->getProductbywholesaler()->getProduct()->getSku(), $texto) !== false;
  1142.             }
  1144.             $cumpleNumericos = true;
  1145.             if (isset($filters['programm'])) {
  1146.                 $cumpleNumericos = $cumpleNumericos && $obj->getProductbywholesaler()->getProduct()->getVendorProgramm()->getId() == $filters['programm'];
  1147.             }
  1149.             if (isset($filters['productline'])) {
  1150.                 $cumpleNumericos = $cumpleNumericos && $obj->getProductbywholesaler()->getProduct()->getProductline()->getId() == $filters['productline'];
  1151.             }
  1153.             if (isset($filters['category'])) {
  1155.                 $productsQuery = $productRepository->MyProductQuery($user)
  1156.                     ->andWhere('p.cansellalone = 1 and p.isflavour = 0 and p.cansell = 1 and p.id = :id')
  1157.                     ->leftJoin('p.productLine', 'pl')
  1158.                     ->leftJoin('pl.categories', 'cat')
  1159.                     ->andWhere("cat.id = :cat ")
  1160.                     ->setParameter('cat', $filters['category'])
  1161.                     ->setParameter('id', $obj->getProductbywholesaler()->getProduct()->getId())
  1162.                     ->getQuery()
  1163.                     ->getResult();
  1165.                 $cumpleNumericos = $cumpleNumericos && $productsQuery;
  1166.             }
  1167.             return $cumpleTexto && $cumpleNumericos;
  1168.         });
  1170.         return $singleVendorProductsArray;
  1171.     }
  1173.     /**
  1174.      * Get selected partner and all allowed to switch
  1175.      * 
  1176.      * @param $partnerId
  1177.      * 
  1178.      */
  1179.     private function partnerSelection($partnerId)
  1180.     {
  1181.         $partnerRepository = $this->getDoctrine()->getRepository(Partner::class);
  1183.         // Get the list of all partners we can view the catalog for
  1184.         // TODO - why myquery? only return 1 result
  1185.         $partners = $partnerRepository->MyPartnerQuery($this->getUser())
  1186.             ->orderBy('p.name', 'ASC')
  1187.             ->getQuery()
  1188.             ->getResult();
  1190.         if ($partnerId) {
  1191.             // Verify that we are allowed to view this partner
  1192.             $partner = $partnerRepository->MyPartnerQuery($this->getUser())
  1193.                 ->andWhere('p.id = :partnerId ')
  1194.                 ->setParameter('partnerId', $partnerId)
  1195.                 ->setMaxResults(1)
  1196.                 ->getQuery()
  1197.                 ->getResult();
  1198.         }
  1200.         if (!$partner) {
  1201.             throw $this->createNotFoundException();
  1202.         }
  1204.         return array($partner, $partners);
  1205.     }
  1208.     /**
  1209.      * Get reviews for a Product to show in catalog single view
  1210.      * 
  1211.      * @param $idproduct
  1212.      * 
  1213.      */
  1214.     public function ratingReview($idproduct)
  1215.     {
  1217.         $entityManager = $this->getDoctrine()->getManager();
  1219.         $productOpinions = $entityManager->createQuery("SELECT po from App\Entity\Productopinions po "
  1220.             . "WHERE po.product = :idproduct "
  1221.             . "ORDER BY po.product DESC ")
  1222.             ->setParameter("idproduct", $idproduct)
  1223.             ->getResult();
  1225.         return $productOpinions;
  1226.     }
  1229.     /**
  1230.      * Get similar products(6) to show in catalog view
  1231.      * 
  1232.      * @param $idPbw
  1233.      * 
  1234.      */
  1235.     private function similarProducts($idPbw)
  1236.     {
  1238.         //TODO checkear if borrado de vendor exclusivo
  1239.         $pbwRepository = $this->getDoctrine()->getRepository(Productbywholesaler::class);
  1240.         $pbw = $pbwRepository->find($idPbw);
  1241.         $idVendor = $pbw->getProduct()->getProductline()->getVendor()->getId();
  1242.         $user = $this->getUser();
  1244.         if ($user->getVendor()) {
  1245.             $pbws = $pbwRepository->MyProductbywholesalerQuery($user)
  1246.                 ->leftJoin('p.productLine', 'pl');
  1247.             if ($user->getCustomer() && $user->getCustomer()->getPartner()->getCustomProducts()) {
  1248.                 $pbws = $pbws
  1249.                     ->leftJoin("App\Entity\ProductByCustomer", "pbc", Join::WITH, 'pbc.Product = p.id')
  1250.                     ->andWhere('pbc.Product = pbw.product');
  1251.             }
  1252.             $pbws = $pbws
  1253.                 ->andWhere('pbw.unregistrationdate is null and pbw.id != :idPbw and pbw.wholesaler = :wholesalerId ')
  1254.                 ->andWhere('p.cansellalone = 1 and p.isflavour = 0 ')
  1255.                 ->andWhere('pl.vendor = :idVendor ')
  1256.                 ->setParameter('idPbw', $idPbw)
  1257.                 ->setParameter('wholesalerId', $pbw->getWholesaler()->getId())
  1258.                 ->setParameter('idVendor', $idVendor)
  1259.                 ->setMaxResults(6)
  1260.                 ->getQuery()
  1261.                 ->getResult();
  1262.         } else {
  1263.             $pbws = $pbwRepository->MyProductbywholesalerQuery($user)
  1264.                 ->leftJoin('pbw.product', 'p');
  1265.             if ($user->getCustomer() && $user->getCustomer()->getPartner()->getCustomProducts()) {
  1266.                 $pbws = $pbws
  1267.                     ->leftJoin("App\Entity\ProductByCustomer", "pbc", Join::WITH, 'pbc.Product = p.id')
  1268.                     ->andWhere('pbc.Product = pbw.product');
  1269.             }
  1270.             $pbws = $pbws
  1271.                 ->leftJoin('p.productLine', 'pl')
  1272.                 ->andWhere('pbw.unregistrationdate is null and pbw.id != :idPbw and pbw.wholesaler = :wholesalerId ')
  1273.                 ->andWhere('p.cansellalone = 1 and p.isflavour = 0 ')
  1274.                 ->andWhere('pl.vendor = :idVendor ')
  1275.                 ->setParameter('idPbw', $idPbw)
  1276.                 ->setParameter('wholesalerId', $pbw->getWholesaler()->getId())
  1277.                 ->setParameter('idVendor', $idVendor)
  1278.                 ->setMaxResults(6)
  1279.                 ->getQuery()
  1280.                 ->getResult();
  1281.         }
  1283.         return $pbws;
  1284.     }
  1287.     /**
  1288.      * Get related resources for product to show in catalog view
  1289.      * 
  1290.      * @param $idPbw
  1291.      * 
  1292.      */
  1293.     private function relatedResources($idPbw)
  1294.     {
  1296.         $user = $this->getUser();
  1297.         $pbwRepository = $this->getDoctrine()->getRepository(Productbywholesaler::class);
  1298.         $pbw = $pbwRepository->find($idPbw);
  1300.         $productline = $pbw->getProduct()->getProductline();
  1302.         $resourcesRepository = $this->getDoctrine()->getRepository(\App\Entity\Resources::class);
  1303.         $queryData = $resourcesRepository->findAllMyActiveResources($user);
  1304.         $queryData->join('r.productLines', 'pl');
  1305.         $queryData->andWhere('pl.id = :productline');
  1306.         $queryData->setParameter('productline', $productline->getId());
  1307.         $resources = $queryData->getQuery()->execute();
  1309.         return $resources;
  1310.     }
  1313.     /**
  1314.      * @Route("/catalog/default/promotions", name="catalog_promotions")
  1315.      */
  1316.     public function promotions($page = 1, TrafficTracker $trafficTracker, TranslatorInterface $translator, Translation $translation, HeaderData $buildHeaderData, PriceCalculatorService $priceCalculator, Request $request)
  1317.     {
  1318.         $trafficTracker->registerTraffic();
  1319.         $locale = $request->getLocale();
  1320.         $user = $this->getUser();
  1321.         $currentDate = date("Y-m-d");
  1322.         $idWholesaler = null;
  1324.         $pl = null;
  1325.         $vd = null;
  1326.         $pw = null;
  1328.         $NameProduct = null;
  1329.         $arrayid = null;
  1330.         $newarrayid = null;
  1331.         $arrayidTemp = array();
  1332.         $arrayPbwUrl = array();
  1334.         /** @var EntityManager */
  1335.         $entityManager = $this->getDoctrine()->getManager();
  1336.         /** @var PartnerRepository */
  1337.         $partnerRepository = $this->getDoctrine()->getRepository(Partner::class);
  1338.         /** @var CustomerRepository */
  1339.         $customerRepository = $this->getDoctrine()->getRepository(Customer::class);
  1341.         $categoryRepository = $this->getDoctrine()->getRepository(Category::class);
  1342.         $vendorRepository = $this->getDoctrine()->getRepository(Vendors::class);
  1343.         $pbwRepository = $this->getDoctrine()->getRepository(Productbywholesaler::class);
  1344.         $productRepository = $this->getDoctrine()->getRepository(Product::class);
  1346.         $searchName = $translator->trans('app.Promos.Promotions');
  1348.         if ($user->getPartner()) {
  1349.             $partner = $partnerRepository->MyPartnerQuery($user)->getQuery()->getOneOrNullResult();
  1350.             $wholesaler = $user->getPartner()->getWholesaler();
  1351.         } elseif ($user->getWholesaler()) {
  1352.             $partner =  $partnerRepository->MyPartnerQuery($user)->getQuery()->setMaxResults(1)->getOneOrNullResult();
  1353.             $wholesaler = $user->getWholesaler();
  1354.         } else {
  1355.             $customer = $customerRepository->MyCustomerQuery($user)->getQuery()->getOneOrNullResult();
  1356.             $partner = $customer->getPartner();
  1357.             $wholesaler = $user->getCustomer()->getPartner()->getWholesaler();
  1358.         }
  1360.         $promotions = $entityManager->createQuery("SELECT pp FROM App\Entity\Productpromotion pp
  1361.             JOIN pp.promotion p
  1362.             WHERE (pp.stock > 0 OR pp.stock is null)
  1363.             AND p.wholesaler = :wholesaler
  1364.             AND p.deactivated != 1
  1365.             AND p.validated = 1
  1366.             AND p.expirydate >= :date1
  1367.             AND p.startdate <= :date2")
  1368.             ->setParameter("wholesaler", $wholesaler)
  1369.             ->setParameter("date1", $currentDate)
  1370.             ->setParameter("date2", $currentDate);
  1372.         foreach ($promotions->getResult() as $p) {
  1374.             if ($p->getProductByWholesaler()) {
  1375.                 $id = $p->getProductByWholesaler()->getProduct()->getId();
  1376.                 $groupId = $p->getProductByWholesaler()->getProduct()->getGroupid();
  1378.                 $pbwMain = $entityManager->createQuery("SELECT pbw FROM App\Entity\Productbywholesaler pbw
  1379.                     JOIN pbw.product p
  1380.                     WHERE p.id = :groupid
  1381.                     AND pbw.wholesaler = :wholesaler")
  1382.                     ->setParameter("groupid", $groupId)
  1383.                     ->setParameter("wholesaler", $wholesaler)
  1384.                     ->getOneOrNullResult();
  1386.                 $pw[$p->getId()] = $p->getProductByWholesaler();
  1389.                 if ($groupId == $id) {
  1390.                     if (!array_key_exists($groupId, $arrayidTemp)) {
  1391.                         $arrayidTemp[$groupId] = array("promotion" => $p->getId(), "isMain" => 1, "pbw" => $p, "pbwMain" => $pbwMain->getId());
  1392.                     }
  1393.                 } else {
  1394.                     $arrayidTemp[$groupId] = array("promotion" => $p->getId(), "isMain" => 0, "pbw" => $p, "pbwMain" => $pbwMain->getId());
  1395.                 }
  1396.             }
  1398.             if ($p->getProductline()) {
  1399.                 $pl[$p->getId()] = $p->getProductline()->getVendor();
  1400.             }
  1402.             if ($p->getVendor()) {
  1403.                 $vd[$p->getId()] = $p->getVendor();
  1404.             }
  1405.         }
  1407.         foreach ($arrayidTemp as $key => $pp) {
  1408.             $arrayid[] = $pw[$pp["pbw"]->getId()]->getId();
  1409.             $arrayPbwUrl[$pw[$pp["pbw"]->getId()]->getId()] = $pp["pbwMain"];
  1410.         }
  1413.         if ($arrayid) {
  1414.             $promotions = $entityManager->createQuery("SELECT pp FROM App\Entity\Productpromotion pp
  1415.             JOIN pp.promotion p
  1416.             LEFT JOIN pp.productByWholesaler pbw
  1417.             WHERE (pp.stock > 0 OR pp.stock is null)
  1418.             AND p.wholesaler = :wholesaler
  1419.             AND p.deactivated != 1
  1420.             AND p.validated = 1
  1421.             AND p.expirydate >= :date1
  1422.             AND p.startdate <= :date2
  1423.             AND (pbw.id IN (:pbws)
  1424.             OR pp.productLine is not null
  1425.             OR pp.vendor is not null)")
  1426.                 ->setParameter("wholesaler", $wholesaler)
  1427.                 ->setParameter("date1", $currentDate)
  1428.                 ->setParameter("date2", $currentDate)
  1429.                 ->setParameter("pbws", $arrayid);
  1430.         }
  1432.         $form = $this->createForm(SearchPromotion::class, null, array(
  1433.             'translator' => $translator,
  1434.             'categories' => array(),
  1435.             'vendors' => array(),
  1436.         ));
  1438.         $form->handleRequest($request);
  1440.         return $this->render('/catalog/default/promotionsview.html.twig', [
  1441.             'searchName' => $searchName,
  1442.             'pl' => $pl,
  1443.             'vd' => $vd,
  1444.             'pw' => $pw,
  1445.             'promotions' => $promotions->getResult(), //$pagination,
  1446.             'headerData' => $buildHeaderData->buildHeaderData($user),
  1447.             'form' => $form->createView(),
  1448.             'partnerId' => $partner,
  1449.             'arrayPbwUrl' => $arrayPbwUrl,
  1450.             'locale' => $locale,
  1451.             'vendorsRepository' => $vendorRepository,
  1452.             'pbwRepository' => $pbwRepository,
  1453.             'productRepository' => $productRepository,
  1454.             'useSymbol' => $partner->getWholesaler()->getUseSymbolCurrency(),
  1455.             'priceCalculator' => $priceCalculator
  1456.         ]);
  1457.     }
  1459.     /**
  1460.      * @Route("/catalog/default/bundles", name="catalog_bundles")
  1461.      */
  1462.     public function bundles($page = 1, TrafficTracker $trafficTracker, TranslatorInterface $translator, Translation $translation, HeaderData $buildHeaderData, Request $request)
  1463.     {
  1464.         $trafficTracker->registerTraffic();
  1465.         $locale = $request->getLocale();
  1466.         $user = $this->getUser();
  1467.         $currentDate = date("Y-m-d");
  1468.         $idWholesaler = null;
  1471.         $NameProduct = null;
  1472.         $arrayid = null;
  1473.         $newarrayid = null;
  1474.         $arrayidTemp = array();
  1475.         $arrayPbwUrl = array();
  1477.         /** @var EntityManager */
  1478.         $entityManager = $this->getDoctrine()->getManager();
  1479.         /** @var PartnerRepository */
  1480.         $partnerRepository = $this->getDoctrine()->getRepository(Partner::class);
  1481.         /** @var CustomerRepository */
  1482.         $customerRepository = $this->getDoctrine()->getRepository(Customer::class);
  1483.         /** @var BundleRepository */
  1484.         $bundleRepository = $this->getDoctrine()->getRepository(Bundle::class);
  1486.         $categoryRepository = $this->getDoctrine()->getRepository(Category::class);
  1487.         $vendorRepository = $this->getDoctrine()->getRepository(Vendors::class);
  1488.         $pbwRepository = $this->getDoctrine()->getRepository(Productbywholesaler::class);
  1489.         $productRepository = $this->getDoctrine()->getRepository(Product::class);
  1492.         if ($user->getPartner()) {
  1493.             $partner = $partnerRepository->MyPartnerQuery($user)->getQuery()->getOneOrNullResult();
  1494.             $wholesaler = $user->getPartner()->getWholesaler();
  1495.         } elseif ($user->getWholesaler()) {
  1496.             $partner =  $partnerRepository->MyPartnerQuery($user)->getQuery()->setMaxResults(1)->getOneOrNullResult();
  1497.             $wholesaler = $user->getWholesaler();
  1498.         } else {
  1499.             $customer = $customerRepository->MyCustomerQuery($user)->getQuery()->getOneOrNullResult();
  1500.             $partner = $customer->getPartner();
  1501.         }
  1503.         $bundles = $bundleRepository->MyBundleQuery($user)->andWhere('b.stock > 0')->andWhere('b.endDate >= :date1')->andWhere('b.startDate <= :date2')->setParameter("date1", $currentDate)
  1504.             ->setParameter("date2", $currentDate)->getQuery()->getResult();
  1507.         return $this->render('/catalog/default/bundlesview.html.twig', [
  1508.             'bundles' => $bundles, //$pagination,
  1509.             'headerData' => $buildHeaderData->buildHeaderData($user),
  1510.             'partnerId' => $partner,
  1511.             'arrayPbwUrl' => $arrayPbwUrl,
  1512.             'locale' => $locale,
  1513.             'vendorsRepository' => $vendorRepository,
  1514.             'pbwRepository' => $pbwRepository,
  1515.             'productRepository' => $productRepository,
  1516.             'useSymbol' => $partner->getWholesaler()->getUseSymbolCurrency()
  1517.         ]);
  1518.     }
  1520.     /**
  1521.      * @Route("/catalog/default/view_bundle/{id}", name="catalog_view_bundle", requirements={"id"="\d+"})
  1522.      */
  1523.     public function viewBundle($id, TrafficTracker $trafficTracker, TranslatorInterface $translator, Translation $translation, DataProductFinder $dataProductFinder, HeaderData $buildHeaderData, Request $request)
  1524.     {
  1525.         $session = $this->get('session');
  1526.         $trafficTracker->registerTraffic();
  1527.         $entityManager = $this->getDoctrine()->getManager();
  1528.         $pbwRepository = $this->getDoctrine()->getRepository(Productbywholesaler::class);
  1529.         $partnerRepository = $this->getDoctrine()->getRepository(Partner::class);
  1530.         $wholesalerRepository = $this->getDoctrine()->getRepository(Wholesaler::class);
  1531.         $customerRepository = $this->getDoctrine()->getRepository(Customer::class);
  1532.         $productRepository = $this->getDoctrine()->getRepository(Product::class);
  1533.         /** @var BundleRepository */
  1534.         $bundleRepository = $this->getDoctrine()->getRepository(Bundle::class);
  1536.         $user = $this->getUser();
  1537.         $locale = $request->getLocale();
  1539.         // $id es un id de ProductByWholesaler
  1540.         $commercialEmail = '';
  1541.         $markup_value = 0;
  1542.         $discount = 0;
  1543.         //$currentDate = date("Y-m-d");
  1544.         $isVendor = false;
  1546.         $bundle = $bundleRepository->MyBundleQuery($user)
  1547.             ->andWhere('b.id = :id')
  1548.             ->andWhere('b.active = 1')
  1549.             ->andWhere('b.stock > 0')
  1550.             ->setParameter('id', $id)
  1551.             ->setMaxResults(1)
  1552.             ->getQuery()
  1553.             ->getOneOrNullResult();
  1555.         if (!$bundle) {
  1556.             $session->getFlashBag()->add('danger', $translator->trans('app.General.NoResult'));
  1557.             return $this->redirect($this->generateUrl('catalog_goto'));
  1558.         }
  1560.         $partner = null;
  1561.         if ($user->getPartner()) {
  1562.             $partner = $partnerRepository->MyPartnerQuery($user)->getQuery()->getSingleResult();
  1563.             $commercialUser = $this->getDoctrine()->getRepository(\App\Entity\User::class)->find($partner->getIdcommercialagent());
  1564.             $commercialEmail = $commercialUser->getEmail();
  1565.             $currencyIso = $partner->getWholesaler()->getCurrency()->getIso();
  1566.             $isPartner = true;
  1567.             $isWholesaler = false;
  1568.             $wholesaler = $user->getPartner()->getWholesaler();
  1569.         } elseif ($user->getWholesaler()) {
  1570.             $wholesaler = $wholesalerRepository->MyWholesalerQuery($user)->getQuery()->getSingleResult();
  1571.             $currencyIso = $wholesaler->getCurrency()->getIso();
  1572.             $partner = null;
  1573.             $isPartner = false;
  1574.             $isWholesaler = true;
  1575.             $wholesaler = $user->getWholesaler();
  1576.         } elseif ($user->getVendor()) {
  1577.             $wholesaler = $wholesalerRepository->MyWholesalerQuery($user)->setMaxResults(1)->getQuery()->getSingleResult();
  1578.             $currencyIso = $wholesaler->getCurrency()->getIso();
  1579.             $partner = $entityManager->createQuery('SELECT p FROM App\Entity\Partner p '
  1580.                 . 'where p.wholesaler = :wholesaler ')
  1581.                 ->setParameters(array('wholesaler' => $wholesaler->getId()))
  1582.                 ->setMaxResults(1)
  1583.                 ->getOneOrNullResult();
  1584.             $isPartner = false;
  1585.             $isVendor = true;
  1586.             $isWholesaler = false;
  1587.         } else {
  1588.             $customer = $customerRepository->MyCustomerQuery($user)
  1589.                 ->andWhere('c.id = :customerId ')
  1590.                 ->setParameter('customerId', $user->getCustomer()->getId())
  1591.                 ->getQuery()->getSingleResult();
  1592.             $wholesaler = $user->getCustomer()->getPartner()->getWholesaler();
  1593.             $partner = $customer->getPartner();
  1594.             $commercialUser = $this->getDoctrine()->getRepository(\App\Entity\User::class)->find($customer->getIdcommercialagent());
  1595.             $commercialEmail = $commercialUser->getEmail();
  1596.             $isPartner = false;
  1597.             $isWholesaler = false;
  1598.             $currencyIso = $wholesaler->getCurrency()->getIso();
  1599.         }
  1601.         $catalogImages = $bundle->getCatalogImages();
  1602.         $images = [];
  1603.         $images[] = 'uploads/images/productImages/' . $bundle->getImageName();
  1604.         foreach ($catalogImages as $img) {
  1605.             $images[] = 'uploads/images/productImages/' . $img;
  1606.         }
  1608.         $customers = $customerRepository->MyCustomerQuery($user)
  1609.             ->andWhere('c.unregistrationdate is NULL ')
  1610.             ->orderBy('c.company', 'DESC')
  1611.             ->getQuery()
  1612.             ->getResult();
  1614.         $data_to_view = array(
  1615.             'headerData' => $buildHeaderData->buildHeaderData($user),
  1616.             'bundle' => $bundle,
  1617.             'images' => $images,
  1618.             'defaultimage' => $images[0],
  1619.             'commercialEmail' => $commercialEmail,
  1620.             'ispartner' => $isPartner,
  1621.             'currencyIso' => $currencyIso,
  1622.             'locale' => $locale,
  1623.             'isWholesaler' => $isWholesaler,
  1624.             'isVendor' => $isVendor,
  1625.             'pbwRepository' => $this->getDoctrine()->getRepository(Productbywholesaler::class),
  1626.             'vendorsRepository' => $this->getDoctrine()->getRepository(Vendors::class),
  1627.             'userRepository' => $this->getDoctrine()->getRepository(User::class),
  1628.             'partner' => $partner,
  1629.             'i18n' => $translation,
  1630.             'customers' => $customers,
  1631.         );
  1633.         return $this->render('/catalog/default/viewBundle.html.twig', $data_to_view);
  1634.     }
  1635. }