src/Controller/CartController.php line 693

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\Bundle;
  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\Usercart;
  18. use App\Entity\User;
  19. use App\Entity\Vendorpartnerlevel;
  20. use App\Entity\Businessoportinities;
  21. use App\Entity\DiscountsByChannel;
  22. use App\Service\HeaderData;
  23. use App\Service\Translation;
  24. use App\Service\ServiceNotification;
  25. use App\Entity\Productsbusinessoportinities;
  26. use App\Entity\Licenseresources;
  27. use App\Repository\TaxesRepository;
  28. use App\Service\ServiceDiscounts;
  29. use App\Service\JsonSearchService;
  30. use App\Entity\Taxes;
  31. use App\Service\StockService;
  32. use App\Service\PickupWarehouseService;
  33. use App\Service\GenerateLinesFromSalesService;
  34. use App\Service\PriceCalculatorService;
  35. use App\Entity\Sales;
  36. use App\Entity\License;
  37. use App\Entity\File;
  38. use App\Entity\MarkupsByChannel;
  39. use App\Service\FinancialRiskService;
  40. use DateTime;
  41. use App\Service\ConnectifService;
  42. use App\Service\Currency\OperationalCurrencyProvider;
  43. use App\Entity\Warehouse;
  44. use App\Entity\WarehousePolicies;
  45. use App\Entity\CompanyAddress;
  46. use App\Service\LicenseGeneratorService;
  47. use App\Service\SaleGeneratorService;
  48. use App\Service\ExtraFieldsService;
  50. class CartController extends AbstractController
  51. {
  52.     private $financialRiskService;
  53.     private $buildHeaderData;
  54.     private $connectifService;
  55.     private $operationalCurrencyProvider;
  57.     public function __construct(FinancialRiskService $financialRiskService, HeaderData $buildHeaderData, ConnectifService $connectifService, OperationalCurrencyProvider $operationalCurrencyProvider)
  58.     {
  59.         $this->financialRiskService = $financialRiskService;
  60.         $this->buildHeaderData = $buildHeaderData;
  61.         $this->connectifService = $connectifService;
  62.         $this->operationalCurrencyProvider = $operationalCurrencyProvider;
  63.     }
  65.     /**
  66.      * /**
  67.      * @Route("/catalog/cart/customercarts/{userId}", name="cart_customer_carts", requirements={"userId"="\d+"})
  68.      */
  69.     public function customerCarts(Request $request, TrafficTracker $trafficTracker, HeaderData $buildHeaderData, Translation $translation, ServiceDiscounts $serviceDiscounts, $userId)
  70.     {
  71.         $trafficTracker->registerTraffic();
  72.         $vendorRepository = $this->getDoctrine()->getRepository(Vendors::class);
  73.         $userCartRepository = $this->getDoctrine()->getRepository(Usercart::class);
  74.         $entityManager = $this->getDoctrine()->getManager();
  76.         $user = $this->getUser();
  77.         //$cart = $userCartRepository->MyUserCartQuery($user)->getQuery()->getResult();
  78.         if($user->getCustomer()){
  79.             return $this->redirectToRoute('cart_index', ['userId' => $userId, 'customerId' => $user->getCustomer()->getId()]);
  80.         }
  82.         $cart = $entityManager->createQuery("SELECT uc FROM \App\Entity\Usercart uc "
  83.             . "JOIN App\Entity\Customer c "
  84.             . "JOIN App\Entity\Partner p "
  85.             . 'where uc.customer = c.id and c.partner = :partner and uc.unregistrationdate is null and uc.sale is null')
  86.             ->setParameter('partner', $user->getPartner())
  87.             ->getResult();
  89.         if (sizeof($cart) == 0) {
  90.             return $this->redirectToRoute('catalog_goto');
  91.         }
  93.         $customerCarts = array();
  94.         foreach ($cart as $cartItem) {
  95.             if (!array_key_exists($cartItem->getCustomer()->getId(), $customerCarts)) {
  96.                 $customerCarts[$cartItem->getCustomer()->getId()] = array($cartItem);
  97.             } else {
  98.                 array_push($customerCarts[$cartItem->getCustomer()->getId()], $cartItem);
  99.             }
  100.         }
  102.         foreach ($customerCarts as $cart) {
  103.             $serviceDiscounts->checkPromosAvailableInCart($cart);
  104.             $serviceDiscounts->checkBOsAvailableInCart($cart);
  105.         }
  107.         return $this->render('/catalog/cart/customercarts.html.twig', array(
  108.             'headerData' => $buildHeaderData->buildHeaderData($user),
  109.             'customerCarts' => $customerCarts,
  110.             'vendorsRepository' => $vendorRepository
  111.         ));
  112.     }
  114.     /**
  115.      * Remove one item from customer carts
  116.      * 
  117.      * @Route("/catalog/cart/removecustomercarts/{userId}/{itemId}", name="cart_remove_customercarts", requirements={"userId"="\d+", "itemId"="\d+"})
  118.      */
  119.     public function removeCustomerCarts(TrafficTracker $trafficTracker, StockService $stockService, $userId, $itemId)
  120.     {
  121.         $trafficTracker->registerTraffic();
  122.         $entityManager = $this->getDoctrine()->getManager();
  123.         $user = $this->getUser();
  124.         $userCartRepository = $this->getDoctrine()->getRepository(Usercart::class);
  126.         $cartItem = $userCartRepository->MyCustomersCartQuery()
  127.             ->andwhere('uc.id = :cartId')
  128.             ->setparameter('cartId', $itemId)
  129.             ->getQuery()
  130.             ->getOneOrNullResult();
  132.         if (!is_null($cartItem)) {
  133.             $stockService->removeProvisioningRelatedItems($user, $cartItem);
  134.             $this->removeItem($cartItem);
  135.         }
  137.         // Redirect to cart index
  138.         return $this->redirectToRoute('cart_customer_carts', ['userId' => $userId]);
  139.     }
  141.     public function removeItem($cartItem)
  142.     {
  143.         $entityManager = $this->getDoctrine()->getManager();
  144.         $user = $this->getUser();
  145.         $userCartRepository = $this->getDoctrine()->getRepository(Usercart::class);
  147.         if (!is_null($cartItem->getRelatedCartId())) {
  148.             foreach ($cartItem->getRelatedCartId() as $relatedCartId) {
  150.                 /*$relatedItem = $userCartRepository->MyUserCartQuery($user)
  151.                     ->andwhere('uc.id = :relatedItem')
  152.                     ->setparameter('relatedItem', $relatedCartId)
  153.                     ->getQuery()
  154.                     ->getOneOrNullResult();*/
  156.                 $relatedItem = $entityManager->createQuery("SELECT uc FROM \App\Entity\Usercart uc "
  157.                     . "JOIN App\Entity\Customer c "
  158.                     . "JOIN App\Entity\Partner p "
  159.                     . 'where uc.customer = c.id and c.partner = :partner and uc.unregistrationdate is null and uc.sale is null and uc.id = :relatedItem')
  160.                     ->setParameter('partner', $user->getPartner())
  161.                     ->setparameter('relatedItem', $relatedCartId)
  162.                     ->getOneOrNullResult();
  164.                 $relatedItem->setUnregistrationdate(new \DateTime());
  165.                 $entityManager->persist($relatedItem);
  166.                 $entityManager->flush();
  167.             }
  168.         }
  170.         $cartItem->setUnregistrationdate(new \DateTime());
  171.         $entityManager->persist($cartItem);
  172.         $entityManager->flush();
  173.     }
  175.     /**
  176.      * /**
  177.      * @Route("/catalog/cart/index/{userId}/{customerId}", name="cart_index", requirements={"userId"="\d+"})
  178.      */
  179.     public function index(Request $request, TrafficTracker $trafficTracker, TranslatorInterface $translator, HeaderData $buildHeaderData, Translation $translation, ServiceDiscounts $serviceDiscounts, PriceCalculatorService $priceCalculatorService, PickupWarehouseService $pickupWarehouseService, $userId, $customerId = null)
  180.     {
  181.         $trafficTracker->registerTraffic();
  182.         $entityManager = $this->getDoctrine()->getManager();
  183.         $partnerRepository = $this->getDoctrine()->getRepository(Partner::class);
  184.         $vendorRepository = $this->getDoctrine()->getRepository(Vendors::class);
  185.         $userCartRepository = $this->getDoctrine()->getRepository(Usercart::class);
  186.         $bundleRepository = $this->getDoctrine()->getRepository(Bundle::class);
  187.         $pbwRepository = $this->getDoctrine()->getRepository(Productbywholesaler::class);
  188.         $productRepository = $this->getDoctrine()->getRepository(Product::class);
  189.         $productPromotionRepository = $this->getDoctrine()->getRepository(\App\Entity\Productpromotion::class);
  191.         /** @var TaxesRepository */
  192.         $taxesRepository = $this->getDoctrine()->getRepository(Taxes::class);
  193.         /** @var Warehouse */
  194.         $warehouseRepository = $entityManager->getRepository(Warehouse::class);
  195.         /** @var Customer */
  196.         $customerRepository = $entityManager->getRepository(Customer::class);
  197.         
  198.         $session = $this->get('session');
  199.         $locale = $request->getLocale();
  200.         $user = $this->getUser();
  201.         
  202.         $taxes = 0;
  203.         $data = array();
  205.         $customer=null;
  206.         if (!$customerId) {
  207.             return $this->redirectToRoute('catalog_goto');
  208.         }
  209.         else
  210.         {
  211.             $customer = $customerRepository->MyCustomerQuery($user)
  212.             ->andWhere('c.id = :id')
  213.             ->setParameter('id', $customerId)
  214.             ->getQuery()
  215.             ->setMaxResults(1)
  216.             ->getOneOrNullResult();
  217.         }
  218.         
  219.         $isPartner = $user->getPartner() ? true : false;
  221.         $partner=null;
  222.         if($user->getPartner()){
  223.             $partner=$user->getPartner();$target=$user->getPartner();
  224.         }
  225.         elseif($user->getCustomer()){
  226.             $partner=$user->getCustomer()->getPartner();$target=$user->getCustomer();
  227.         }
  228.         else{
  229.             $session->getFlashBag()->add('danger', $translator->trans('app.General.SystemMessages.PartnerNotFound'));
  230.             return $this->redirectToRoute('catalog_goto');
  231.         }
  233.         $cart = $userCartRepository->MyCustomerCartQuery($user)
  234.             ->andWhere('uc.customer = :customer')
  235.             ->setParameter('customer', $customerId)
  236.             ->getQuery()->getResult();
  237.             
  238.         if (sizeof($cart) == 0) {
  239.             return $this->redirectToRoute('catalog_goto');
  240.         }
  242.         $serviceDiscounts->checkPromosAvailableInCart($cart);
  243.         $serviceDiscounts->checkBOsAvailableInCart($cart);
  245.         $cartIncludesHardware=false;
  246.         $cartIncludesStockMerge=null;
  247.         $cartIncludesStockMergeText = null;
  248.         $total = 0;
  249.         foreach ($cart as $item) {
  251.             if (!$userCartRepository->checkRelatedId($item)) {
  252.                 continue;
  253.             }
  255.             $pbw = $pbwRepository->MyProductbywholesalerQuery($user)
  256.                 ->andWhere('pbw.id = :pbwId')
  257.                 ->setParameter('pbwId', $item->getPbw()->getId())
  258.                 ->getQuery()
  259.                 ->getOneOrNullResult();
  261.             $tax = $taxesRepository->getTaxForPbw($pbw);
  263.             $partnerlevel = $partnerRepository->getPartnerLevel($partner, $pbw->getProduct()->getProductLine()->getVendor()->getId());
  265.             $promo = null;
  266.             $discountType = null;
  267.             $promoCode = null;
  269.             if ($item->getProductPromotion() && $user->getPartner()) {
  270.                 $discountType = $translation->getTranslationBy($item->getProductPromotion()->getDiscountType(), $locale, 'name');
  271.                 $promoCode = $item->getProductPromotion()->getPromotion()->getCode();
  272.                 $promo=$item->getProductPromotion();
  273.             }
  275.             $bo = null;
  276.             $discountTypeBo = null;
  277.             $boCode = null;
  279.             if ($item->getProductbusinessoportunities() != null && $user->getPartner()) {
  280.                 $bo = $item->getProductbusinessoportunities();
  281.                 $discountTypeBo = $item->getProductbusinessoportunities()->getDiscountType()->getName();
  282.                 $boCode = $item->getProductbusinessoportunities()->getBusinessOportunity()->getCode();
  283.             }
  284.             elseif($item->getProductBusinessOpportunityCustomer() != null && $user->getCustomer()) {
  285.                 $bo = $item->getProductBusinessOpportunityCustomer();
  286.                 $discountTypeBo = $item->getProductBusinessOpportunityCustomer()->getDiscountType()->getName();
  287.                 $boCode = $item->getProductBusinessOpportunityCustomer()->getBusinessOportunity()->getCode();
  288.             }
  290.             if (isset($pbw)) {
  292.                 //overrider partnerLevel if not follows katy system
  293.                 if (!$pbw->getProduct()->getProductline()->getVendor()->getFollowsKatyPartnerLevel()) {
  295.                     $vendorLvlName = $entityManager->createQuery('SELECT vplvl FROM App\Entity\Vendorpartnerlevel vplvl '
  296.                         . 'where vplvl.vendor = :vendorId and vplvl.level = :level')
  297.                         ->setParameters(array('vendorId' => $pbw->getProduct()->getProductline()->getVendor()->getId(), 'level' => $partnerlevel))
  298.                         ->setMaxResults(1)
  299.                         ->getOneOrNullResult();
  301.                     $partnerlevel = $vendorLvlName ? $vendorLvlName->getName() : '';
  302.                 }
  304.                 if ($pbw->getProduct()->getVolumeMin() == $pbw->getProduct()->getVolumeMax())
  305.                 {
  306.                     $itemMultiplier = 1;
  307.                 } else
  308.                 {
  309.                     $itemMultiplier = $item->getVolume();
  310.                 }
  312.                 $unitPrice = $priceCalculatorService->calculatePrice($pbw, $target, null, null, 1, $bo, $promo, null, true, false);             
  313.                 $priceNoTax = $priceCalculatorService->calculatePrice($pbw, $target, null, null, $itemMultiplier, $bo, $promo, null, true, false) * $item->getQuantity();
  314.                 
  315.                 if ($tax) {
  316.                     $taxes += ($priceNoTax * $tax->getValue()) / 100;
  317.                 }
  318.                 $totalImport = $priceCalculatorService->calculatePrice($pbw, $target, null, null, $itemMultiplier, $bo, $promo, null, true, true) * $item->getQuantity();
  321.                 if ($pbw->getProduct()->getFare() != 1) {
  322.                     $total = $total + $totalImport;
  323.                 }
  325.                 // TO-DO calculatePrice
  326.                 if ($pbw->getProduct()->getSku() == 'BUNDLE') {
  327.                     $bundle = true;
  328.                     $description = '';
  329.                     $parameters = $item->getParameters();
  330.                     $bundle = $bundleRepository->find($parameters['bundleId']);
  331.                     $name = $bundle->getName();
  332.                     $productsBundle = $bundle->getBundleProduct();
  333.                     $price = $bundle->getPrice();
  334.                     foreach ($productsBundle as $pb) {
  335.                         $description .= $pb->getProduct()->getDescriptiveName() . ' - ' . $pb->getProduct()->getSku() . '</br>';
  336.                     }
  337.                     $unitPrice = $bundle->getPrice();
  338.                     $pvdTotal = $price * $item->getQuantity();
  339.                     $priceNoTax = $price * $item->getQuantity();
  340.                     $total += $priceNoTax;
  341.                 } else {
  342.                     $bundle = false;
  343.                 }
  345.                 $parameters = $item->getParameters();
  346.                 if ($pbw->getProduct()->getIsHardware() == true) {
  347.                     $cartIncludesHardware = true;                  
  348.                 }
  350.                 $stockMergeText = $parameters['stockMergeText'] ?? null;
  351.                 if (!empty($stockMergeText) && is_null($cartIncludesStockMerge)) {
  352.                     $cartIncludesStockMergeText = $stockMergeText;
  353.                 }
  354.                 
  355.                 $data[] = array(                
  356.                   'productByWholesaler' => $pbw,
  357.                   'productName' => $bundle ? $name : $pbw->getProduct()->getDescriptiveName(),
  358.                   'pbwDescription' => $bundle ? $description : $pbw->getDescription(),
  359.                   'period' => $pbw->getProduct()->getPayperiod()->getPeriod(),
  360.                   'image' => $pbwRepository->getCoverImage($pbw),
  361.                   'sku' => $pbw->getProduct()->getSku(),
  362.                   'quantity' => $item->getQuantity(),
  363.                   'volume' => $item->getVolume(),
  364.                   'cartId' => $item->getId(),
  365.                   'unitPrice' => $unitPrice,
  366.                   'priceNoTax' => $priceNoTax,                                
  367.                   'isPartner' => $isPartner,                 
  368.                   'promotion' => $item->getProductPromotion(),
  369.                   'discountType' => $discountType,
  370.                   'promoCode' => $promoCode,
  371.                   'bo' => $bo,
  372.                   'discountTypeBo' => $discountTypeBo,
  373.                   'boCode' => $boCode,             
  374.                   'tax' => $tax ? $tax : null,
  375.                   'overage' => $item->getOverage(),
  376.                   'bundle' => $bundle
  377.                 );
  378.             }
  379.         }
  381.         $delivaryData = $this->getDeliveryDataFromCartItems($cart, $partner, $customer, $translator);
  382.         
  383.         return $this->render('/catalog/cart/index.html.twig', array(
  384.             'partnerId' => $partner->getId(),
  385.             'isPartner' => $isPartner,
  386.             'data' => $data,
  387.             'headerData' => $buildHeaderData->buildHeaderData($user),
  388.             'total' => $total,
  389.             'locale' => $locale,
  390.             'customer' => $customerId,
  391.             'taxes' => (float)$taxes,
  392.             'useSymbol' => $partner->getWholesaler()->getUseSymbolCurrency(),
  393.             'cnClientInfo' => ($this->connectifService->cnClientInfo($user)),
  394.             'cnCart' => ($this->connectifService->cnCart($user)),
  395.             'operationalCurrency' => $this->operationalCurrencyProvider->provide($target),
  396.             'cartIncludesHardware' => $cartIncludesHardware,
  397.             'cartIncludesStockMergeText' => $cartIncludesStockMergeText,
  398.             'delivaryData' => $delivaryData,
  399.             'pickupData' => $pickupWarehouseService->getAvailableWarehouses($cart, $user)
  400.         ));
  401.     }
  403.     private function getDeliveryDataFromCartItems($cart, $partner, $customer, $translator)
  404.     {
  405.         $entityManager = $this->getDoctrine()->getManager();
  406.         /** @var Warehouse */
  407.         $warehouseRepository = $entityManager->getRepository(Warehouse::class);
  408.         /** @var CompanyAddress */
  409.         $companyAddressRepository = $entityManager->getRepository(CompanyAddress::class);
  410.         /** @var WarehousePolicies */
  411.         $warehousePoliciesRepository = $entityManager->getRepository(WarehousePolicies::class);
  413.         $user = $this->getUser();
  415.         $data = array('allowPickup' => true, 'allowCustomerDelivery' => false, 'allowUnofficialDelivery' => false);
  417.         //DATA FROM POLICIES
  418.         $warehousePolicies = $warehousePoliciesRepository->MyWarehousePoliciesQuery($user)
  419.             ->getQuery()
  420.             ->getOneOrNullResult();
  422.         if($warehousePolicies){
  423.             $data['allowCustomerDelivery']=$warehousePolicies->getAllowCustomerDelivery();
  424.             $data['allowUnofficialDelivery']=$warehousePolicies->getAllowNonOfficialAddresses();          
  425.         }
  427.         $addresses = array();
  429.         //GENERAL PARTNER ADDRESSES
  430.         $companyAddresses = $companyAddressRepository->MyCompanyAddressQuery($partner)->getQuery()->getResult();
  432.         foreach ($companyAddresses as $companyAddress) {
  433.             $addresses[] = [
  434.                 'id' => $companyAddress->getId(),
  435.                 'address' => $companyAddress->getName()." - ".$companyAddress->getAddress().", ".$companyAddress->getPostcode().", ".$companyAddress->getCity(),
  436.                 'selected' => $companyAddress->getPrimaryAddress(),
  437.             ];
  438.         }
  440.         if (empty($addresses)) {
  441.             $addresses[] = [
  442.                 'id' => $partner->getId(),
  443.                 'address' => $partner->getAddress().", ".$partner->getPostcode().", ".$partner->getCity(),
  444.                 'selected' => true,
  445.             ];
  446.         }
  447.         $data['addresses']=$addresses;
  450.         $customerAddresses = array();
  451.         //CUSTOMER ADDRESSES
  452.         $customerAddressesBD = $companyAddressRepository->MyCompanyAddressQuery($customer)->getQuery()->getResult();
  453.         
  454.         foreach ($customerAddressesBD as $companyAddress) {
  455.             $customerAddresses[] = [
  456.                 'id' => $companyAddress->getId(),
  457.                 'address' => $companyAddress->getName()." - ".$companyAddress->getAddress().", ".$companyAddress->getPostcode().", ".$companyAddress->getCity(),
  458.                 'selected' => $companyAddress->getPrimaryAddress(),
  459.             ];
  460.         }
  462.         if (empty($customerAddresses)) {
  463.             $customerAddresses[] = [
  464.                 'id' => $customer->getId(),
  465.                 'address' => $customer->getAddress().", ".$customer->getPostcode().", ".$customer->getCity(),
  466.                 'selected' => true,
  467.             ];
  468.         }
  469.         $data['customerAddresses']=$customerAddresses;
  471.         
  473.         return $data;
  474.     }
  476.     /**
  477.      * /**
  478.      * @Route("/catalog/cart/add/{userId}", name="cart_add", requirements={"userId"="\d+"})
  479.      */
  480.     public function add(Request $request, TrafficTracker $trafficTracker, $userId, ExtraFieldsService $extraFieldsService)
  481.     {
  482.         $trafficTracker->registerTraffic();
  483.         $userCart = new Usercart();
  484.         $typeOfProduct = $request->get('typeofproduct');
  485.         $domain = empty($request->get('domain')) ? null : $request->get('domain');
  486.         $quantity = $request->get('quantity');
  487.         $volume = $request->get('volume');
  488.         $volume_addon = $request->get('volume_addon');
  489.         $customer = $request->get('customer');
  490.         $pbwId = $request->get('pbwId');
  491.         $preorder = $request->get('preorder');
  492.         $divide = $request->get('divide');
  493.         $bundleId = $request->get('bundle');
  494.         $productbywholesalerRepository = $this->getDoctrine()->getRepository(Productbywholesaler::class);
  495.         $productRepository = $this->getDoctrine()->getRepository(Product::class);
  496.         $bundleRepository = $this->getDoctrine()->getRepository(Bundle::class);
  497.         
  498.         $licenseType = $request->get('licenseType');
  499.         $stockMergeText = $request->get('stock_merge_text');
  502.         if ((is_null($pbwId) && is_null($bundleId)) || is_null($customer) || is_null($volume) || is_null($quantity)) {
  503.             return $this->redirectToRoute('catalog_goto');
  504.         }
  506.         $serialNumber = $request->files->get('serialNumber');
  507.         if (!is_null($serialNumber) && !empty($serialNumber)) {
  508.             // Verificar la extensión del archivo
  509.             $fileExtension = $serialNumber->guessExtension();
  510.             if (!in_array($fileExtension, array("xlsx"))) {
  511.                 return $this->redirectToRoute('catalog_view', ['id' => $pbwId]);
  512.             }
  513.         }
  515.         if(is_null($volume_addon)){
  516.             $volume_addon=$volume;          
  517.         }
  518.         
  519.         $entityManager = $this->getDoctrine()->getManager();
  520.         $userCartRepository = $this->getDoctrine()->getRepository(Usercart::class);
  521.         $user = $this->getDoctrine()->getRepository(User::class)->find($userId);
  522.         $customer = $this->getDoctrine()->getRepository(Customer::class)->find($customer);
  523.         $productPromotionRepo = $this->getDoctrine()->getRepository(\App\Entity\Productpromotion::class);
  524.         $productRepository = $this->getDoctrine()->getRepository(Product::class);
  527.         if ($pbwId) {
  528.             $pbw = $this->getDoctrine()->getRepository(Productbywholesaler::class)->find($request->get('pbwId'));
  529.         } else { //BUNDLE ONLY
  530.             $bundle = $bundleRepository->MyBundleQuery($user)->andWhere('b.id = :bundleId')->setParameter('bundleId', $bundleId)->getQuery()->getOneOrNullResult();
  531.             $parameters = $userCart->getParameters();
  532.             $parameters['bundleId'] = $bundleId;
  533.             $parameters['description'] = $bundle->getDescription();
  534.             $parameters['name'] = $bundle->getName();
  535.             $parameters['price'] = $bundle->getPrice();
  536.             $parameters['freeInvoicescustomer'] = 1;
  537.             $parameters['freeInvoicespartner'] = 1;
  538.             $userCart->setParameters($parameters);
  539.             $pbw = $productbywholesalerRepository->MyBundleByWholesalerQuery($user);
  540.             $mainProduct = $userCartRepository->addItem($userCart, $user, $pbw, $volume, $quantity, $customer, $domain, null, null, null, null, 0, 0, $bundle->getPrice());
  541.             return $this->redirectToRoute('cart_customer_carts', ['userId' => $userId]);
  542.         }
  543.         //New types with volume and quantity
  544.         $newTypesVolumeAndQuantity = array(1/*'simple_type'*/, 3/*'with_maintenance'*/, 5/*'flavoured_type'*/, 4/*'flavoured_list_type'*/, 6/*'flavoured_duration'*/, 7 /*'flavoured_volumelist_duration'*/, 8 /*'flavoured_duration_volumeinput'*/, 9 /*'flavoured_version'*/, 10 /*'flavoured_version_volume_input'*/, 11/*'flavour_list_with_maintenance'*/, 12/*'flavour_with_maintenance'*/, 13/*'flavoured_version_maintenance'*/, 14/*'flavoured_version_with_volume'*/, 15/*'flavoured_version_volumeinput_range'*/, 16, 17, 21, 22, 23, 24, 25, 26);
  545.         $newTypesVolumeAndQuantityMaint = array(3/*'with_maintenance'*/, 11/*'flavour_list_with_maintenance'*/, 12/*'flavour_with_maintenance'*/, 13/*'flavoured_version_maintenance'*/, 22, 23, 26);
  547.         //SOFTWARE
  548.         $stockCart = 0;
  549.         $preorderCart = 0;
  551.         //HARDWARE - ONLY STOCK
  552.         if ($pbw->getProduct()->getIsHardware()) {
  553.             $stockCart = $volume;
  554.         }
  556.         //HARDWARE - ALL PREORDER
  557.         if (empty($divide) && !empty($preorder)) {
  558.             $stockCart = $volume - $preorder;
  559.             $preorderCart = $preorder;
  560.         }
  562.         //HARDWARE - STOCK -> DIVIDED
  563.         if (!empty($divide) && $divide == 1) {
  564.             $volume = $volume - $preorder;
  565.             $stockCart = $volume;
  566.             $volume_addon = $volume;
  567.         }
  569.         if ($volume > 0) {
  570.             //New types with volume and quantity
  571.             if (in_array($typeOfProduct, $newTypesVolumeAndQuantity)) {
  572.                 $promotionsRequest = json_decode($request->get('promotions'), true);
  574.                 $idProductPromotion = $promotionsRequest == null ? null : $promotionsRequest[$pbw->getId()];
  575.                 $productPromo = $idProductPromotion ? $productPromotionRepo->find($idProductPromotion) : null;
  577.                 $userCart = $this->resetUserCartInstance();
  578.                 $mainProduct = $userCartRepository->addItem($userCart, $user, $pbw, $volume, $quantity, $customer, $domain, null, $productPromo, null, null, $stockCart, $preorderCart);
  580.                 if (in_array($typeOfProduct, $newTypesVolumeAndQuantityMaint) && !is_null($request->get('maintenance')) && $request->get('maintenance') != '') {
  581.                     $pbwMaintId = $request->get('maintenance');
  582.                     $pbwMain = $this->getDoctrine()->getRepository(Productbywholesaler::class)->find($pbwMaintId);
  584.                     $idProductPromoMaint = $promotionsRequest == null ? null : $promotionsRequest[$pbwMaintId];
  585.                     $productPromoMaint = $idProductPromoMaint ? $productPromotionRepo->find($idProductPromoMaint) : null;
  587.                     $userCart = $this->resetUserCartInstance();
  588.                     $subProduct = $userCartRepository->addItem($userCart, $user, $pbwMain, $volume_addon, $quantity, $customer, $domain, $mainProduct->getId(), $productPromoMaint, null, null, $stockCart, $preorderCart);
  589.                     $userCartRepository->addRelatedId($mainProduct, $subProduct->getId());
  590.                 }
  591.             }
  593.             /// Bloque Extrafields
  594.             $extraParams = $extraFieldsService->processExtraFields(
  595.                 $request,
  596.                 $productRepository->getParentSkuIds($pbw->getProduct())->getParameters() ?? []
  597.             );
  598.             
  599.             if (!empty($extraParams)) {
  600.                 $newParams = array_merge($newParams ?? [], $extraParams);
  601.                 $mainProduct->setParameters($newParams);
  602.                 $entityManager->persist($mainProduct);
  603.                 $entityManager->flush();
  604.             }
  605.             ////
  608.             if (!is_null($licenseType) && !empty($licenseType)) {
  609.                 $newParams['licenseType'] = $licenseType;
  611.                 $mainProduct->setParameters(json_decode(json_encode($newParams), true));
  612.                 $entityManager->persist($mainProduct);
  613.                 $entityManager->flush();
  614.             }
  616.             if (!is_null($stockMergeText) && !empty($stockMergeText)) {
  617.                 $newParams['stockMergeText'] = $stockMergeText;
  618.                 $mainProduct->setParameters(json_decode(json_encode($newParams), true));
  619.                 $entityManager->persist($mainProduct);
  620.                 $entityManager->flush();
  621.             }
  622.         }
  624.         //HARDWARE - PREORDER -> DIVIDED
  625.         if (!empty($preorder) && !empty($divide)) {
  626.             $volume = $preorder;
  627.             $volume_addon = $volume;
  629.             $preorderCart = $preorder;
  630.             $stockCart = 0;
  632.             if (in_array($typeOfProduct, $newTypesVolumeAndQuantity)) {
  633.                 $promotionsRequest = json_decode($request->get('promotions'), true);
  635.                 $idProductPromotion = $promotionsRequest == null ? null : $promotionsRequest[$pbw->getId()];
  636.                 $productPromo = $idProductPromotion ? $productPromotionRepo->find($idProductPromotion) : null;
  638.                 $userCart = $this->resetUserCartInstance();
  639.                 $mainProduct = $userCartRepository->addItem($userCart, $user, $pbw, $volume, $quantity, $customer, $domain, null, $productPromo, null, null, $stockCart, $preorderCart);
  641.                 if (in_array($typeOfProduct, $newTypesVolumeAndQuantityMaint) && !is_null($request->get('maintenance')) && $request->get('maintenance') != '') {
  642.                     $pbwMaintId = $request->get('maintenance');
  643.                     $pbwMain = $this->getDoctrine()->getRepository(Productbywholesaler::class)->find($pbwMaintId);
  645.                     $idProductPromoMaint = $promotionsRequest == null ? null : $promotionsRequest[$pbwMaintId];
  646.                     $productPromoMaint = $idProductPromoMaint ? $productPromotionRepo->find($idProductPromoMaint) : null;
  648.                     $userCart = $this->resetUserCartInstance();
  649.                     $subProduct = $userCartRepository->addItem($userCart, $user, $pbwMain, $volume_addon, $quantity, $customer, $domain, $mainProduct->getId(), $productPromoMaint, null, null, $stockCart, $preorderCart);
  650.                     $userCartRepository->addRelatedId($mainProduct, $subProduct->getId());
  651.                 }
  652.             }
  653.         }
  655.         return $this->redirectToRoute('cart_index', ['userId' => $userId, 'customerId' => $customer->getId()]);
  656.         //return $this->redirectToRoute('cart_customer_carts', ['userId' => $userId]);
  657.     }
  659.     /**
  660.      * Remove one item from the cart
  661.      * 
  662.      * @Route("/catalog/cart/remove/{userId}/{cartId}", name="cart_remove", requirements={"userId"="\d+", "cartId"="\d+"})
  663.      */
  664.     public function remove(TrafficTracker $trafficTracker, StockService $stockService, $userId, $cartId)
  665.     {
  666.         $trafficTracker->registerTraffic();
  667.         $entityManager = $this->getDoctrine()->getManager();
  668.         $user = $this->getUser();
  669.         $userCartRepository = $this->getDoctrine()->getRepository(Usercart::class);
  671.         $cartItem = $userCartRepository->MyUserCartQuery($user)
  672.             ->andwhere('uc.id = :cartId')
  673.             ->setparameter('cartId', $cartId)
  674.             ->getQuery()
  675.             ->getOneOrNullResult();
  677.         $customerId = $cartItem->getCustomer()->getId();
  679.         if (!is_null($cartItem)) {
  680.             $stockService->removeProvisioningRelatedItems($user, $cartItem);
  681.             $this->removeItem($cartItem);
  682.         }
  684.         // Redirect to cart index
  685.         return $this->redirectToRoute('cart_index', ['userId' => $userId, 'customerId' => $customerId]);
  686.     }
  688.     /**
  689.      * Action to sale everything in the cart
  690.      * 
  691.      * @Route("/catalog/cart/checkout/{userId}/{customerId}", name="cart_checkout", requirements={"userId"="\d+"})
  692.      */
  693.     public function checkout(Request $request, TrafficTracker $trafficTracker, Translation $translation, TranslatorInterface $translator, HeaderData $buildHeaderData, $userId, ServiceNotification $serviceNotification, ServiceDiscounts $serviceDiscounts, JsonSearchService $jsonSearchService, GenerateLinesFromSalesService $invoiceService, PriceCalculatorService $priceCalculatorService, $customerId = null, LicenseGeneratorService $licenseGenerator, SaleGeneratorService $saleGenerator)
  694.     {
  695.         $trafficTracker->registerTraffic();
  696.         $session = $this->get('session');
  697.         $entityManager = $this->getDoctrine()->getManager();
  698.         $userCartRepository = $this->getDoctrine()->getRepository(Usercart::class);
  699.         $userRepository = $this->getDoctrine()->getRepository(User::class);
  700.         $partnerRepository = $this->getDoctrine()->getRepository(Partner::class);
  701.         $boRepository = $this->getDoctrine()->getRepository(Businessoportinities::class);
  702.         $customerRepository = $this->getDoctrine()->getRepository(Customer::class);
  703.         $vendorRepository = $this->getDoctrine()->getRepository(Vendors::class);
  704.         $productbywholesalerRepository = $this->getDoctrine()->getRepository(Productbywholesaler::class);
  705.         $productRepository = $this->getDoctrine()->getRepository(Product::class);
  706.         $productPromotionRepository = $this->getDoctrine()->getRepository(\App\Entity\Productpromotion::class);
  707.         $session = $this->get('session');
  709.         /** @var TaxesRepository */
  710.         $taxRepository = $this->getDoctrine()->getRepository(Taxes::class);
  711.         //Check Markup and Discounts
  712.         /** @var MarkupsByChannelRepository */
  713.         $markupsByChannelRepository = $this->getDoctrine()->getRepository(MarkupsByChannel::class);
  714.         /** @var DiscountsByChannelRepository */
  715.         $discountsByChannelRepository = $this->getDoctrine()->getRepository(DiscountsByChannel::class);
  716.         /** @var FileRepository */
  717.         $fileRepository = $this->getDoctrine()->getRepository(File::class);
  719.         $deliveryType     = $request->request->get('delivery_type');
  720.         $warehouseId      = $request->request->get('pickup_warehouse_id');
  721.         $addressSource   = $request->request->get('address_source'); // 'partner' | 'customer' | 'custom'
  722.         $selectedAddress  = $request->request->get('selected_address');
  724.         //USER
  725.         $user = $userRepository->MyUserQuery($this->getUser())
  726.             ->andWhere('u.id = :userId')
  727.             ->setParameter('userId', $userId)
  728.             ->getQuery()
  729.             ->getSingleResult();
  731.         //CUSTOMER
  732.         if (!$customerId) {
  733.             return $this->redirectToRoute('catalog_goto');
  734.         }else{
  735.             $customer = $customerRepository->MyCustomerQuery($user)
  736.             ->andWhere('c.unregistrationdate is NULL ')
  737.             ->andWhere('c.id = :customerId ')
  738.             ->setParameter('customerId', $customerId)
  739.             ->getQuery()
  740.             ->getOneOrNullResult();
  742.             if (!$customer) {
  743.                 return $this->redirectToRoute('catalog_goto');
  744.             }
  745.         }
  747.         //PARTNER
  748.         $partner = $partnerRepository->MyPartnerQuery($user)->getQuery()->getSingleResult();
  749.         if (!$partner) {
  750.             $session->getFlashBag()->add('danger', $translator->trans('app.General.SystemMessages.PartnerNotFound'));
  751.             return $this->redirectToRoute('catalog_goto');
  752.         }
  753.         
  754.         //WHOLESALER
  755.         $wholesaler = $partner->getWholesaler();
  757.         //TARGET
  758.         if($user->getPartner()){
  759.             $target=$user->getPartner();
  760.         }
  761.         elseif($user->getCustomer()){
  762.             $target=$user->getCustomer();
  763.         }
  765.         //CART
  766.         $cart = $userCartRepository->MyUserCartQuery($user)
  767.             ->andWhere('uc.customer = :customer')
  768.             ->setParameter('customer', $customerId)
  769.             ->getQuery()
  770.             ->getResult();
  772.         // If cart is empty  
  773.         if (sizeof($cart) == 0) {
  774.             return $this->redirect($this->generateUrl('cart_index', array('userId' => $userId)));
  775.         }
  777.         $serviceDiscounts->checkPromosAvailableInCart($cart);
  778.         $serviceDiscounts->checkBOsAvailableInCart($cart);
  779.         
  780.         $financialRiskCheckResult=$this->financialRiskService->financialRiskCheck('cartCheckout', $cart, $user, $customer);
  781.         if($financialRiskCheckResult['result']==false){
  782.             return $this->render('catalog/cart/denied.html.twig', array(
  783.                 'headerData' => $buildHeaderData->buildHeaderData($user),
  784.                 'partnerId' => $partner->getId(),
  785.                 'reference' => 'reference',
  786.                 'data' => $financialRiskCheckResult['data'],
  787.                 'currency' => $partner->getWholesaler()->getCurrency()->getIso(),
  788.                 'comercial' => $userRepository->find($userRepository->getCompany($user)->getIdCommercialAgent()),
  789.                 'title' => 'app.General.SystemMessages.LimitExceeded',
  790.                 'message' => 'app.General.SystemMessages.LimitExceeded',
  791.                 'messageDesc' => 'app.General.SystemMessages.AuthorizationRequired',
  792.                 'vendorsRepository' => $vendorRepository,
  793.                 'useSymbol' => $partner->getWholesaler()->getUseSymbolCurrency()
  794.             ));
  795.         }
  797.         //Mark BO has redeemed
  798.         $idBusinessoportunity = $this->findBOActiveInCustomerCart($cart);
  799.         if ($idBusinessoportunity) {
  800.             $bo = $boRepository->find($idBusinessoportunity);
  801.             if (!$bo->getUsed()) {
  802.                 $bo->setUsed(true);
  803.                 $entityManager->persist($bo);
  804.                 $entityManager->flush();
  805.             }
  806.         }
  808.         //PO NUMBER
  809.         if (!empty($request->get('po_number'))) {
  810.             $po_number = $request->get('po_number');
  811.             if (strlen($po_number) > 50) {
  812.                 $session->getFlashBag()->add('danger', $translator->trans('app.General.Guidelines.TooLong'));
  813.                 return $this->redirectToRoute('cart_index', ['userId' => $userId, 'customerId' => $customerId]);
  814.             }
  815.         }else {
  816.             $po_number = null;
  817.         }
  819.         $poOriginalFileName = null;
  820.         $poFileName = null;
  821.         $purchaseOrder = null;
  822.         $path = $this->getParameter('private_folder') . 'po/';
  823.         if (!empty($request->files->get('po'))) {
  824.             $file = $request->files->get('po');
  825.             $fileExtension = $file->guessExtension();
  826.             if (!in_array($fileExtension, array("pdf"))) {
  827.                 $session->getFlashBag()->add('danger', $translator->trans('app.Development.DataImport.FileCannotLoaded'));
  828.                 return $this->redirectToRoute('cart_index', ['userId' => $userId, 'customerId' => $customerId]);
  829.             }
  831.             $poOriginalFileName = $file->getClientOriginalName();
  833.             $newName = uniqid() . '.' . $file->guessExtension();
  834.             $poFileName = $newName;
  835.             $file->move($path, $newName);
  837.             $uploadedPofile = new \App\Entity\File();
  838.             $uploadedPofile->setOriginalName($poOriginalFileName);
  839.             $uploadedPofile->setFileName($poFileName);
  840.             $entityManager->persist($uploadedPofile);
  842.             $purchaseOrder = new \App\Entity\PurchaseOrder();
  843.             $purchaseOrder->setNumber($po_number);
  844.             $purchaseOrder->setDescription("purchase");
  845.             $purchaseOrder->setCreatedBy($user->getId());
  846.             $purchaseOrder->setFile($uploadedPofile);
  847.             $entityManager->persist($purchaseOrder);
  849.             $entityManager->flush();
  850.         }
  852.         $locale = $request->getLocale();
  853.         $reference = time() . '-' . rand(0, 999999);
  854.         $licensesArray = array();
  855.         $cartReference = null;
  857.         //Process each SKU (Create license and Sale)
  858.         foreach ($cart as $cartItem) {
  860.             if ($cartItem->getProductPromotion() && !is_null($cartItem->getProductPromotion()->getStock()) && $cartItem->getProductPromotion()->getStock() > 0) {
  861.                 $cartItem->getProductPromotion()->setStock($cartItem->getProductPromotion()->getStock() - 1);
  862.                 $entityManager->persist($cartItem);
  863.                 $entityManager->flush();
  864.             }
  866.             //Find product
  867.             $pbw = $productbywholesalerRepository->MyProductbywholesalerQuery($user)
  868.                 ->andWhere('pbw.id = :pbwId')
  869.                 ->setParameter('pbwId', $cartItem->getPbw()->getId())
  870.                 ->getQuery()
  871.                 ->getOneOrNullResult();
  873.             $parameters = $cartItem->getParameters();
  875.             $q = $cartItem->getQuantity();
  876.             $v = $cartItem->getVolume();
  877.             $n = $pbw->getProduct()->getVolumeMin() == $pbw->getProduct()->getVolumeMax() ? 1 : $v;
  879.             for ($i = 0; $i < $q; $i++) {
  881.                 //Create  License
  882.                 $license = $licenseGenerator->createLicense($customer, $pbw->getProduct(), $v, 1, null, null, null, null);
  884.                 if (!is_null($purchaseOrder)) {
  885.                     $license->addPurchaseOrder($purchaseOrder);
  886.                 }
  888.                 if($pbw->getProduct()->getIsHardware()){
  889.                     $parameters['deliveryType'] = $deliveryType;
  890.                     $parameters['warehouseId'] = $warehouseId;
  891.                     $parameters['addressSource'] = $addressSource;
  892.                     $parameters['selectedAddress'] = $selectedAddress;
  893.                     $license->setParameters(json_decode(json_encode($parameters), true));
  894.                 }
  895.                 else
  896.                 {
  897.                     $license->setParameters($cartItem->getParameters());
  898.                 }
  899.                 
  901.                 $license->setStock($cartItem->getStock());
  902.                 $license->setOverage($cartItem->getOverage());
  904.                 $mainProduct=$productRepository->getParentSkuIds($pbw->getProduct());
  905.                 if ($mainProduct->getProductType()->getId()==26 && $pbw->getProduct()->getCanSellAlone()) {
  906.                     $license->setIsMain(0);
  907.                 } elseif($mainProduct->getProductType()->getId()==26) {
  908.                     $license->setIsMain(1);
  909.                 } elseif ($pbw->getProduct()->getCanSellAlone()) {
  910.                     $license->setIsMain(1);
  911.                 } else {
  912.                     $license->setIsMain(0);
  913.                 }                         
  915.                 if ($cartItem->getDomain()) {
  916.                     $license->setLicenseId($cartItem->getDomain());
  917.                 }
  919.                 if ($license->getProduct()->getIsHardware()) {
  920.                     $license->setDeliveryStatus("Processing");
  921.                 }
  923.                 $entityManager->persist($license);
  924.                 $entityManager->flush();
  926.                 $serialNumberFileId = $jsonSearchService->searchKeyInArray($cartItem->getParameters(), 'serialNumberFile');
  927.                 if (!empty($serialNumberFileId)) {
  928.                     $serialNumberFile = $fileRepository->find($serialNumberFileId[0]);
  930.                     $licenseResource = new Licenseresources();
  931.                     $licenseResource->setResourcetype(8);
  932.                     $licenseResource->setResource($serialNumberFile->getOriginalName());
  933.                     $licenseResource->setResourceDescription($serialNumberFile->getFileName());
  934.                     $licenseResource->setLicense($license);
  935.                     $entityManager->persist($licenseResource);
  936.                     $entityManager->flush();
  937.                 }
  939.                 $licensesArray[] = $license;
  941.                 // Recoger PO
  942.                 $user = $this->getUser();
  943.                 $isPartner = $user->getPartner() ? true : false;
  944.                 $exchangeRate = $productbywholesalerRepository->getExchangeRate($pbw);
  945.                 $boCustomer = $cartItem->getProductBusinessOpportunityCustomer();
  946.                 $bo = $cartItem->getProductBusinessOportunities();
  949.                 if ($cartItem->getProductPromotion() != null) {
  950.                     $productPromotion = $cartItem->getProductPromotion();
  952.                     $promotions = $productPromotionRepository->find($cartItem->getProductPromotion()->getId());
  954.                     if (!is_null($promotions) && $promotions->getPromotion()->getUsed() == 0) {
  955.                         $promotions->getPromotion()->setUsed(1);
  956.                         $entityManager->persist($promotions);
  957.                         $entityManager->flush();
  958.                     }
  960.                     if ($promotions->getStock() != 0 || $promotions->getStock()) {
  961.                         $promotions->setStock($promotions->getStock() - 1);
  962.                         $entityManager->persist($promotions);
  963.                         $entityManager->flush();
  964.                     }
  965.                 }else{
  966.                     $productPromotion = null;
  967.                 }
  969.                 $partnerPO = $isPartner ? $po_number : null;
  970.                 $customerPO = !$isPartner ? $po_number: null;
  972.                 $sale = $saleGenerator->createSale(
  973.                     $reference,
  974.                     $partnerPO,
  975.                     null,
  976.                     $customerPO,
  977.                     $customer,
  978.                     $pbw,
  979.                     $n,
  980.                     null,
  981.                     null,
  982.                     $exchangeRate,
  983.                     $license,
  984.                     null,
  985.                     null,
  986.                     null,
  987.                     1,
  988.                     $bo,
  989.                     $boCustomer,
  990.                     $productPromotion
  991.                 );
  993.                 $cartItem->setSale($sale);
  994.                 $cartItem->setSaleReference($reference);
  996.                 $entityManager->persist($cartItem);
  997.                 $entityManager->flush();
  998.                 
  999.                 //BUNDLE SUBLICENSES ONLY
  1000.                 if (!is_null($parameters) && array_key_exists('bundleId', $parameters)) {
  1001.                     $bundleRepository = $this->getDoctrine()->getRepository(Bundle::class);
  1002.                     $bundle = $bundleRepository->MyBundleQuery($user)->andWhere('b.id = :bundleId')->setParameter('bundleId', $parameters['bundleId'])->getQuery()->getOneOrNullResult();
  1003.                     $bundlePbws = $bundle->getBundleProduct();
  1004.                     $license->setActivationDate(new DateTime('now'));
  1005.                     $license->setActivationRequestDate(new DateTime('now'));
  1006.                     $license->setHasSublicenses(1);
  1007.                     $entityManager->persist($license);
  1008.                     $entityManager->flush();
  1009.                     foreach ($bundlePbws as $item) {
  1010.                         $z = 1;
  1011.                         $subLicense = $licenseGenerator->createLicense($customer, $item->getProduct(), $v, 0, null, null, null, null);
  1012.                         $subLicense->setParameters($parameters);
  1013.                         $subLicense->setStock(0);
  1014.                         $subLicense->setOverage(0);
  1015.                         $subLicense->setMainLicense($license);
  1016.                         $entityManager->persist($subLicense);
  1017.                         $entityManager->flush();
  1018.                         $reference = $reference . '-' . $z++;
  1019.                         
  1020.                         $subSale = $saleGenerator->createSale(
  1021.                             $reference,
  1022.                             $partnerPO,
  1023.                             null,
  1024.                             $customerPO,
  1025.                             $customer,
  1026.                             $pbw,
  1027.                             null,
  1028.                             null,
  1029.                             null,
  1030.                             $exchangeRate,
  1031.                             $subLicense,
  1032.                             null,
  1033.                             null,
  1034.                             null,
  1035.                             1,
  1036.                             $bo,
  1037.                             $boCustomer,
  1038.                             $productPromotion
  1039.                         );
  1041.                       
  1042.                     }
  1043.                     $sale->setDatebegining(new DateTime('now'));
  1044.                     $sale->setClosed('0');
  1045.                     $sale->setPrice($bundle->getPrice());
  1046.                     $sale->setPriceConverted($bundle->getPrice());
  1047.                     $sale->setExchangeRate(null);
  1048.                     $entityManager->persist($sale);
  1049.                     $entityManager->flush();
  1050.                     $month = $sale->getDatebegining()->format('m');
  1051.                     $year = $sale->getDatebegining()->format('Y');
  1052.                     $invoiceService->generateLines('partner', $month, $year, $wholesaler, $sale->getId());
  1053.                     $invoiceService->generateLines('customer', $month, $year, $wholesaler, $sale->getId());
  1054.                     $financialRisk = $partner->getFinancialrisk();
  1055.                     if (!is_null($financialRisk)) {
  1056.                         $totalSale = $sale->getQuantity() * $sale->getPrice();
  1057.                         $financialRisk = $financialRisk - $totalSale;
  1058.                         $partner->setFinancialRisk($financialRisk);
  1059.                         $entityManager->persist($partner);
  1060.                         $entityManager->flush();
  1061.                     }
  1062.                 }
  1063.             }
  1064.             $cartReference = $cartItem->getCartReference();
  1065.         }
  1067.         $allLicenseToActivate = $licensesArray;
  1068.         //Link sublicenses to mainlicense
  1069.         foreach ($licensesArray as $key => $license) {
  1070.             if ($license->getIsMain()) {
  1071.                 foreach ($licensesArray as $l) {
  1072.                     if(is_null($l->getMainlicense()) && !is_null($license->getProduct()->getMaintenanceskuids()) && in_array($l->getProduct()->getId(), $license->getProduct()->getMaintenanceskuids())){
  1073.                         $l->setMainlicense($license);
  1074.                         $license->setHasSublicenses(1);
  1075.                         $entityManager->persist($l);
  1076.                         $entityManager->persist($license);
  1077.                         $entityManager->flush();
  1078.                         unset($licensesArray[$key]);
  1079.                         break;
  1080.                     }
  1081.                 }
  1082.             }
  1083.         }
  1085.         foreach ($allLicenseToActivate as $key => $license) {
  1086.             $response = $this->forward('App\Controller\ProductManagerController::activationlicenseAction', ['id'  => $license->getId()]);
  1087.         }
  1088.         
  1089.         return $this->redirectToRoute('license_index', ['cart_id' => $cartReference]);
  1090.     }
  1092.     /**
  1093.      * Last page of the process shows aquired services / products
  1094.      * 
  1095.      * 
  1096.      * @Route("/catalog/cart/done/{userId}/{reference}", name="cart_done", requirements={"userId"="\d+", "reference"="\S+"})
  1097.      */
  1098.     public function done(Request $request, TrafficTracker $trafficTracker, TranslatorInterface $translator, HeaderData $buildHeaderData, ServiceNotification $serviceNotification, PriceCalculatorService $priceCalculatorService, $userId, $reference)
  1099.     {
  1100.         $trafficTracker->registerTraffic();
  1101.         $entityManager = $this->getDoctrine()->getManager();
  1102.         $productRepository = $this->getDoctrine()->getRepository(Product::class);
  1103.         $userRepository = $this->getDoctrine()->getRepository(User::class);
  1104.         $partnerRepository = $this->getDoctrine()->getRepository(Partner::class);
  1105.         $pbwRepository = $this->getDoctrine()->getRepository(Productbywholesaler::class);
  1106.         $vendorsRepository = $this->getDoctrine()->getRepository(Vendors::class);
  1107.         $session = $this->get('session');
  1108.         /** @var TaxesRepository */
  1109.         $taxesRepository = $this->getDoctrine()->getRepository(Taxes::class);
  1110.         
  1111.         $data = [];
  1112.         $isPartner = $this->getUser()->getPartner() ? true : false;
  1113.         $locale = $request->getLocale();
  1114.         $taxes = 0;
  1116.         // Get partner
  1117.         $user = $userRepository->MyUserQuery($this->getUser())
  1118.             ->andWhere('u.id = :userId ')
  1119.             ->setParameter('userId', $userId)
  1120.             ->setMaxResults(1)
  1121.             ->getQuery()
  1122.             ->getSingleResult();
  1124.         if($user->getPartner()){
  1125.             $target=$user->getPartner();
  1126.             $partner = $user->getPartner();
  1127.         }
  1128.         elseif($user->getCustomer()){
  1129.             $target=$user->getCustomer();
  1130.             $partner = $user->getCustomer()->getPartner();
  1131.         }    
  1133.         if (!$partner) {
  1134.             $session->getFlashBag()->add('danger', $translator->trans('app.General.SystemMessages.PartnerNotFound'));
  1135.             return $this->redirectToRoute('catalog_goto');
  1136.         }
  1138.         $userCart = $entityManager->createQuery('SELECT uc FROM App\Entity\Usercart uc WHERE uc.salereference = :reference')->setParameter('reference', $reference)->getResult();
  1140.         $total = 0;
  1142.         // For each element in the cart
  1143.         foreach ($userCart as $cartItem) {
  1145.             $promotion = null;
  1146.             $discountTypePr = null;
  1147.             $promoCode = null;
  1148.             $bo = null;
  1149.             $discountTypeBo = null;
  1150.             $boCode = null;
  1152.             //Find product
  1153.             $pbw = $pbwRepository->MyProductbywholesalerQuery($user)
  1154.                 ->andWhere('pbw.wholesaler = :wholesalerId')
  1155.                 ->andWhere('p.sku = :sku')
  1156.                 ->leftJoin('pbw.product', 'p')
  1157.                 ->setParameter('wholesalerId', $partner->getWholesaler()->getId())
  1158.                 ->setParameter('sku', $cartItem->getSale()->getSku())
  1159.                 ->getQuery()
  1160.                 ->getOneOrNullResult();
  1161.             
  1162.             $tax = $taxesRepository->getTaxForPbw($pbw);
  1164.             if ($cartItem->getSale()->getProductPromotion() != null && $user->getPartner()) {
  1165.                 $promotion = $cartItem->getSale()->getProductPromotion();
  1166.                 $discountTypePr = $cartItem->getSale()->getProductPromotion()->getDiscountType()->getName();
  1167.                 $promoCode = $cartItem->getSale()->getProductPromotion()->getPromotion()->getCode();
  1168.             }
  1170.             if ($cartItem->getSale()->getProductbusinessoportunity() != null && $user->getPartner()) {
  1171.                 $bo = $cartItem->getSale()->getProductbusinessoportunity();
  1172.                 $discountTypeBo = $cartItem->getSale()->getProductbusinessoportunity()->getDiscountType()->getName();
  1173.                 $boCode = $cartItem->getSale()->getProductbusinessoportunity()->getBusinessOportunity()->getCode();
  1174.             }
  1175.             elseif($cartItem->getSale()->getProductBusinessOpportunityCustomer() != null && $user->getCustomer()) {
  1176.                 $bo = $cartItem->getSale()->getProductBusinessOpportunityCustomer();
  1177.                 $discountTypeBo = $cartItem->getSale()->getProductBusinessOpportunityCustomer()->getDiscountType()->getName();
  1178.                 $boCode = $cartItem->getSale()->getProductBusinessOpportunityCustomer()->getBusinessOportunity()->getCode();
  1179.             }
  1181.             $unitPrice = $priceCalculatorService->calculatePrice($pbw, $target, null, null, 1, $bo, $promotion, null, true, false);             
  1182.             $priceNoTax = $priceCalculatorService->calculatePrice($pbw, $target, null, null, $cartItem->getSale()->getQuantity(), $bo, $promotion, null, true, false) * $cartItem->getQuantity();
  1184.             if ($tax) {
  1185.                 $taxes += ($priceNoTax * $tax->getValue()) / 100;
  1186.             }
  1187.             $totalImport = $priceCalculatorService->calculatePrice($pbw, $target, null, null, $cartItem->getSale()->getQuantity(), $bo, $promotion, null, true, true) * $cartItem->getQuantity();   
  1190.             if ($cartItem->getSale()->getProduct()->getFare() != 1) {
  1191.                 $total = $total + $totalImport;
  1192.             }
  1194.             $exchange_rate = $pbwRepository->getExchangeRateToApply($pbw);
  1197.             $parameters = $cartItem->getParameters();
  1198.             // TO-DO calculatePrice
  1199.             if (!is_null($parameters) && array_key_exists('bundleId', $parameters)) {
  1200.                 $pvd = $parameters['price'];
  1201.                 $pvdTotal = $cartItem->getQuantity() * $pvd;
  1202.                 $pvdTotalNoTax = $pvdTotal;
  1203.                 $tax = null;
  1204.                 $total += $pvdTotal;
  1205.             }
  1207.             // Calculamos los totales          
  1208.             $totalForDiscount = $priceNoTax / $exchange_rate;
  1210.             // Calculamos el descuento total. Cero si es cliente o si precio es Cero.
  1211.             if ($cartItem->getSale()->getPrice() == 0) {
  1212.                 $totalDiscount = 0;
  1213.             } else {
  1214.                 $totalDiscount = (1 - ($totalForDiscount / ($priceCalculatorService->calculatePrice($pbw, $target, null, null, $cartItem->getSale()->getQuantity(), null, null, null, false, false) * $cartItem->getQuantity()))) * 100;
  1215.                 $totalDiscount = ($totalDiscount < 0 ? 0 : $totalDiscount);
  1216.             }
  1218.             $dataItems[] = array(
  1219.                 'productName' => $cartItem->getSale()->getSku(),
  1220.                 'fareName' => $cartItem->getSale()->getDescription(),
  1221.                 'unitPrice' => $unitPrice,
  1222.                 'priceNoTax' => $priceNoTax,
  1223.                 'quantity' => $cartItem->getQuantity(),
  1224.                 'volume' => $cartItem->getVolume(),
  1225.                 'period' => $cartItem->getSale()->getPayperiod()->getPeriod(),
  1226.                 'promotion' => $promotion,
  1227.                 'discountTypePr' => $discountTypePr,
  1228.                 'productByWholesaler' => $pbw,
  1229.                 'bo' => $bo,
  1230.                 'discountTypeBo' => $discountTypeBo,
  1231.                 'promoCode' => $promoCode,
  1232.                 'totalDiscount' => $totalDiscount,
  1233.                 'image' => $pbwRepository->getCoverImage($pbw),
  1234.                 'boCode' => $boCode,
  1235.                 'tax' => $tax ? $tax : null,
  1236.                 'overage' => $cartItem->getOverage(),
  1237.             );
  1238.             $dateCreated = $cartItem->getSale()->getDateCreated();
  1239.         }
  1241.         return $this->render('/catalog/cart/done.html.twig', array(
  1242.             'data' => $dataItems,
  1243.             'reference' => $reference,
  1244.             'currency' => $partner->getWholesaler()->getCurrency()->getIso(),
  1245.             'headerData' => $buildHeaderData->buildHeaderData($user),
  1246.             'partnerId' => $partner->getId(),
  1247.             'date' => $dateCreated,
  1248.             'isPartner' => $isPartner,
  1249.             'total' => $total,
  1250.             'locale' => $locale,
  1251.             'vendorsRepository' => $vendorsRepository,
  1252.             'taxes' => $taxes,
  1253.             'useSymbol' => $partner->getWholesaler()->getUseSymbolCurrency(),
  1254.         ));
  1255.     }
  1257.     private function resetUserCartInstance()
  1258.     {
  1259.         return new Usercart();
  1260.     }
  1262.     /**
  1263.      * Remove products (set $unregistrationdate) from UserCart
  1264.      * 
  1265.      */
  1266.     private function emptyUserCart($userId)
  1267.     {
  1269.         $userCartRepository = $this->getDoctrine()->getRepository(Usercart::class);
  1270.         $cart = $userCartRepository->MyUserCartQuery($this->getUser())
  1271.             ->andWhere('uc.id = :userId')
  1272.             ->setParameter('userId', $userId)
  1273.             ->getQuery()
  1274.             ->getResult();
  1276.         foreach ($cart as $cartItem) {
  1277.             $this->remove($userId, $cartItem->getId());
  1278.         }
  1279.     }
  1281.     /**
  1282.      * Return BO in a customer cart if exists
  1283.      * 
  1284.      * @return entity BO
  1285.      */
  1286.     private function findBOActiveInCustomerCart($cart)
  1287.     {
  1289.         $bo = null;
  1290.         foreach ($cart as $cartItem) {
  1291.             if ($cartItem->getProductBusinessOportunities()) {
  1292.                 $bo = $cartItem->getProductBusinessOportunities()->getBusinessOportunity();
  1293.             }
  1294.         }
  1295.         return $bo;
  1296.     }
  1298.     public function getNumberCustomerCarts()
  1299.     {
  1301.         $user = $this->getUser();
  1302.         $userCartRepository = $this->getDoctrine()->getRepository(Usercart::class);
  1304.         return new Response(
  1305.             $userCartRepository->getNumberCustomerCarts($user)
  1306.         );
  1307.     }
  1309.     /**
  1310.      * @Route("/catalog/cart/showcartsheader", name="showcarts_header")
  1311.      */
  1312.     public function showcartsheader(Request $request): Response {
  1313.         $place = $request->query->get('place', 'backoffice');
  1314.         
  1315.         $userCartRepository = $this->getDoctrine()->getRepository(Usercart::class);
  1317.         $customers = $userCartRepository->MyCustomersCartsQuery($this->getUser());
  1319.         if($place == 'backoffice'){                                        
  1320.             return $this->render('catalog/cart/showcartsheader.html.twig', [
  1321.                 'customers' => $customers,
  1322.                 'headerData' => $this->buildHeaderData->buildHeaderData($this->getUser()),
  1323.             ]);
  1324.         }
  1325.         else{
  1326.             return $this->render('catalog/cart/showcartscatalog.html.twig', [
  1327.                 'customers' => $customers,
  1328.                 'headerData' => $this->buildHeaderData->buildHeaderData($this->getUser()),
  1329.             ]); 
  1330.         }
  1331.     }
  1333. }