src/Controller/ProductController.php line 456

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  6. use Symfony\Component\HttpFoundation\Response;
  7. use Symfony\Component\Routing\Annotation\Route;
  8. use App\Service\TrafficTracker;
  9. use Symfony\Contracts\Translation\TranslatorInterface;
  10. use Symfony\Component\HttpFoundation\Request;
  11. use App\Entity\Partner;
  12. use App\Entity\Productbywholesaler;
  13. use App\Entity\Vendorpartnerlevel;
  14. use App\Entity\Vendors;
  15. use App\Entity\Vendorprogramms;
  16. use App\Entity\Productunit;
  17. use App\Entity\Customer;
  18. use App\Entity\Product;
  19. use App\Entity\Usercart;
  20. use App\Entity\User;
  21. use App\Entity\Agreements;
  22. use App\Entity\Productimages;
  23. use App\Entity\Businessoportinities;
  24. use App\Service\HeaderData;
  25. use App\Service\Translation;
  26. use App\Service\ServiceNotification;
  27. use App\Entity\Productsbusinessoportinities;
  28. use App\Form\Product\EditProduct;
  29. use App\Form\Import\ProductsImport;
  30. use App\Service\RegisterEvent;
  31. use App\Service\ExtensionFileService;
  32. use App\Service\SanitizeService;
  33. use DateTime;
  34. use Symfony\Component\Serializer\Encoder\JsonEncoder;
  35. use Symfony\Component\Serializer\Serializer;
  36. use App\Entity\Payperiod;
  37. use Psr\Log\LoggerInterface;
  38. use App\Service\PriceCalculatorService;
  39. use App\Service\JsonSearchService;
  41. class ProductController extends AbstractController {
  43.     private $priceCalculatorService;
  45.     public function __construct(PriceCalculatorService $priceCalculatorService)
  46.     {
  47.         $this->priceCalculatorService = $priceCalculatorService;
  48.     }
  49.     
  50.     /**
  51.      *
  52.      * @Route("/product/default/index/{vendorId}/{status}", name="product_index")
  53.      */
  54.     public function index(Request $request, TranslatorInterface $translator, TrafficTracker $trafficTracker, $vendorId = 0, $status = 1) {
  56.         $trafficTracker->registerTraffic();
  57.         $pbwRepository = $this->getDoctrine()->getRepository(Productbywholesaler::class);
  58.         $productRepository = $this->getDoctrine()->getRepository(Product::class);
  59.         $userRepository = $this->getDoctrine()->getRepository(user::class);
  60.         
  61.         $user = $this->getUser();
  62.         $vendors = array();
  63.         $userKaty = false;
  64.         $miniVendor = false;
  65.         $idWholesaler = null;
  66.                 
  67.         if ($user->getWholesaler() == null && $user->getPartner() == null && $user->getCustomer() == null && $user->getVendor() == null) {
  68.             $userKaty = true;
  69.             $data = $productRepository->createQueryBuilder('p')->getQuery()->execute();
  70.             foreach($data as $p){
  71.                 $vendors[$p->getProductline()->getVendor()->getId()]=$p->getProductline()->getVendor()->getName();
  72.             }
  73.             asort($vendors);                       
  74.         }
  75.         elseif($user->getWholesaler()){
  76.             $idWholesaler = $user->getWholesaler()->getId();
  77.         }
  79.         $statusArray=array(1 => $translator->trans('app.General.All'), 2 => $translator->trans('app.General.Active'), 3 => $translator->trans('app.General.Inactive'));
  80.         
  81.         return $this->render('/product/index.html.twig', array(
  82.             'userKaty' => $userKaty==false ? 0 : 1,
  83.             'vendors' => $vendors,
  84.             'vendorId' => $vendorId,
  85.             'idWholesaler' => $idWholesaler==false ? 0 : $idWholesaler,
  86.             'miniVendor' => $userRepository->isMinivendor($user)==false ? 0 : 1,
  87.             'pbwRepository' => $pbwRepository,
  88.             'statusArray' => $statusArray,
  89.             'status' => $status
  91.         ));
  92.     }
  95.     /**
  96.      * @Route("/server/processing", name="server_processing")
  97.      */
  98.     public function serverProcessing(Request $request, TranslatorInterface $translator, Translation $translation)
  99.     {
  100.         $entityManager = $this->getDoctrine()->getManager();
  101.         $pbwRepository = $this->getDoctrine()->getRepository(Productbywholesaler::class);
  102.         $user = $this->getUser();
  103.         $locale = $request->getLocale();
  104.         $wholesaler = $user->getWholesaler() ? $user->getWholesaler()->getId() : null;
  105.         $vendor = $user->getVendor() ? $user->getVendor()->getId() : $_GET['vendorId'];
  106.         $status = $_GET['status'];
  107.         $columnNames=array();
  108.         $flavoursGroupIds = null;
  110.         $statusFilter = "";
  111.         if($user->getWholesaler())
  112.         {
  113.             if($status==2){ $statusFilter = " AND pbw.unregistrationdate is null"; }
  114.             if($status==3){ $statusFilter = " AND pbw.unregistrationdate is not null"; }
  115.         }
  116.         else{
  117.             if($status==2){ $statusFilter = " AND p.unregistrationdate is null"; }
  118.             if($status==3){ $statusFilter = " AND p.unregistrationdate is not null"; }
  119.         }
  121.         if($user->getWholesaler())
  122.         {
  123.             //BUSCAMOS primero por sku en los flavours de Productbywholesaler
  124.             if (!empty($_GET['search']['value'])) {
  125.                 $flavours = 'SELECT DISTINCT p.groupid FROM App\Entity\Productbywholesaler pbw JOIN pbw.product p JOIN p.productLine pl JOIN pl.vendor v where v.isminivendor = 0 and pbw.wholesaler = :wholesaler and p.productType is null and (p.sku like :sku OR p.name like :name)';
  126.                 
  127.                 $flavoursGroupIds = $entityManager
  128.                     ->createQuery($flavours)
  129.                     ->setParameter('wholesaler', $wholesaler)
  130.                     ->setParameter('sku', '%'.$_GET['search']['value'].'%')
  131.                     ->setParameter('name', $_GET['search']['value'])
  132.                     ->getResult();
  133.             }
  134.         }
  135.         else{
  136.             //BUSCAMOS primero por sku en los flavours de Product
  137.             if (!empty($_GET['search']['value'])) {
  138.                 $flavours = 'SELECT DISTINCT p.groupid FROM App\Entity\Product p JOIN p.productLine pl JOIN pl.vendor v where ';
  139.                 if ($vendor!=0) {
  140.                     $flavours .= 'v.id = :vendor and ';
  141.                 }
  142.                 $flavours .= 'p.productType is null and (p.sku like :sku OR p.name like :name)';
  143.                 
  144.                 $flavoursGroupIds = $entityManager->createQuery($flavours);
  145.                 if ($vendor!=0) {
  146.                     $flavoursGroupIds = $flavoursGroupIds->setParameter('vendor', $vendor);  
  147.                 }   
  148.                 $flavoursGroupIds = $flavoursGroupIds
  149.                     ->setParameter('sku', '%'.$_GET['search']['value'].'%')
  150.                     ->setParameter('name', $_GET['search']['value'])
  151.                     ->getResult();
  152.             }    
  153.         }
  154.         
  155.         if($user->getWholesaler())
  156.         {
  157.             $dql = 'SELECT pbw FROM App\Entity\Productbywholesaler pbw JOIN pbw.product p JOIN p.payPeriod pp JOIN p.productLine pl JOIN pl.vendor v where v.isminivendor = 0 and pbw.wholesaler = :wholesaler and p.productType is not null'.$statusFilter;
  158.             $dqlCountFiltered = 'SELECT count(pbw) FROM App\Entity\Productbywholesaler pbw JOIN pbw.product p JOIN p.payPeriod pp JOIN p.productLine pl JOIN pl.vendor v where v.isminivendor = 0 and pbw.wholesaler = :wholesaler and p.productType is not null'.$statusFilter;
  159.         }
  160.         else
  161.         {
  162.             $dql = 'SELECT p FROM App\Entity\Product p JOIN p.productLine pl JOIN pl.vendor v where ';
  163.             if($vendor!=0){$dql .= 'pl.vendor = :vendor and ';}
  164.             $dql .= 'p.productType is not null'.$statusFilter;
  165.             
  166.             $dqlCountFiltered = 'SELECT count(p) FROM App\Entity\Product p JOIN p.productLine pl JOIN pl.vendor v where ';
  167.             if($vendor!=0){$dqlCountFiltered .= 'pl.vendor = :vendor and ';}
  168.             $dqlCountFiltered .= 'p.productType is not null'.$statusFilter;
  169.         }
  170.         $sqlFilter = '';
  172.         if($user->getWholesaler())
  173.         {
  174.             if (!empty($_GET['search']['value'])) {
  175.                 $strMainSearch = $_GET['search']['value'];
  176.                 $sqlFilter .= " (v.name LIKE '%".$strMainSearch."%' OR "
  177.                     ."pl.name LIKE '%".$strMainSearch."%' OR "
  178.                     ."p.name LIKE '%".$strMainSearch."%' OR ("
  179.                     ."p.sku LIKE '%".$strMainSearch."%' OR p.id IN (:flavoursGroupIds)) OR "
  180.                     ."p.duration LIKE '%".$strMainSearch."%' OR "
  181.                     ."pp.period LIKE '%".$strMainSearch."%' OR "
  182.                     ."pbw.price LIKE '%".$strMainSearch."%')";
  183.             }
  185.             $columnNames=[
  186.                 '0' => '',
  187.                 '1' => 'pl.vendor.name',
  188.                 '2' => 'pl.name',
  189.                 '3' => 'p.name',
  190.                 '4' => 'p.sku',
  191.                 '5' => 'p.duration',
  192.                 '6' => 'pbw.price',
  193.                 '7' => '',
  194.                 '8' => ''
  195.             ];
  196.         }
  197.         else{
  198.             if (!empty($_GET['search']['value'])) {
  199.                 $strMainSearch = $_GET['search']['value'];
  200.                 $sqlFilter .= " (v.name LIKE '%".$strMainSearch."%' OR "
  201.                     ."pl.name LIKE '%".$strMainSearch."%' OR "
  202.                     ."p.name LIKE '%".$strMainSearch."%' OR "
  203.                     ."p.sku LIKE '%".$strMainSearch."%' OR p.id IN (:flavoursGroupIds) OR "
  204.                     ."p.duration LIKE '%".$strMainSearch."%') ";
  205.             }
  206.             $columnNames=[
  207.                 '0' => '',
  208.                 '1' => 'pl.vendor.name',
  209.                 '2' => 'pl.name',
  210.                 '3' => 'p.name',
  211.                 '4' => 'p.sku',
  212.                 '5' => 'p.duration',
  213.                 '6' => '',
  214.                 '7' => ''
  215.             ];
  216.         }
  217.         
  218.         if (!empty($sqlFilter)) {
  219.             $dql .= ' AND'.$sqlFilter;
  220.             $dqlCountFiltered .= ' AND'.$sqlFilter;
  221.         }
  223.         if (!empty($_GET['order']['0']['column']!=1)) {
  224.             $dql .= ' ORDER BY '.$columnNames[$_GET["order"][0]["column"]].' '.$_GET["order"][0]["dir"];
  225.         }
  226.         else{
  227.             $dql .= ' ORDER BY v.name ASC';
  228.         }
  230.         if($user->getWholesaler())
  231.         {
  232.             $items = $entityManager
  233.                 ->createQuery($dql)
  234.                 ->setParameter('wholesaler', $wholesaler)
  235.                 ->setFirstResult($_GET['start']);
  236.             if ($_GET['length']!=-1) {
  237.                 $items=$items->setMaxResults($_GET['length']);
  238.             }       
  239.             if (!empty($sqlFilter)) {
  240.                 $items=$items->setParameter('flavoursGroupIds', $flavoursGroupIds);
  241.             }
  242.         }
  243.         else
  244.         {
  245.             $items = $entityManager
  246.                 ->createQuery($dql)               
  247.                 ->setFirstResult($_GET['start']);
  248.             if ($_GET['length']!=-1) {
  249.                 $items=$items->setMaxResults($_GET['length']);
  250.             }    
  251.             if ($vendor!=0) {
  252.                 $items=$items->setParameter('vendor', $vendor);
  253.             }
  254.             if (!empty($sqlFilter)) {
  255.                 $items=$items->setParameter('flavoursGroupIds', $flavoursGroupIds);
  256.             }
  257.         }
  259.         $items = $items->getResult();
  261.         $data = [];
  263.         if($user->getWholesaler())
  264.         {
  265.             //with WHOLESALER PROFILE we work with PRODUCTBYWHOLESALER entity
  266.             foreach ($items as $key => $value) {
  267.                 $url = $this->generateUrl('product_editproduct', array('id' => $value->getId()));
  268.                 $status = is_null($value->getUnregistrationDate()) ? "<span class='label label-success'>".$translator->trans('app.General.Active')."</span>" : "<span class='label label-danger'>".$translator->trans('app.General.Inactive')."</span>";
  269.                 $circle = ($value->getProduct()->getProductType()->getId()!=1 || !is_null($value->getProduct()->getRenovationProduct())) ? "<i class='base fa fa-lg fa-fw m-r-10 fa-plus-circle' group='".$value->getProduct()->getGroupId()."' style='pointer:cursor;'></i>" : "" ;
  270.                 $currency = $user->getWholesaler()->getCurrency()->getIso();
  271.                 $currencyFormat = new \NumberFormatter($request->getLocale(), \NumberFormatter::CURRENCY);
  272.                 $data[] = [
  273.                     'DT_RowId' => $value->getId(),                 
  274.                     $circle,
  275.                     $value->getProduct()->getProductline()->getVendor()->getName(),
  276.                     $value->getProduct()->getProductline()->getName(),
  277.                     "<span title='".$value->getProduct()->getName()."'><a href='".$url."' >".$value->getProduct()->getName()."</a></span>",
  278.                     $value->getProduct()->getSku(),
  279.                     $value->getProduct()->getDuration(),
  280.                     $currencyFormat->formatCurrency(round($pbwRepository->getPrice($value), 2), $currency),
  281.                     $translation->getTranslationBy($value->getProduct()->getPayperiod(), $locale, 'period'),
  282.                     $status,
  283.                 ];
  284.             }
  285.         
  286.             $recordsTotal = $entityManager
  287.                 ->createQuery('SELECT count(pbw) FROM App\Entity\Productbywholesaler pbw JOIN pbw.product p JOIN p.payPeriod pp JOIN p.productLine pl JOIN pl.vendor v where v.isminivendor = 0 and pbw.wholesaler = :wholesaler and p.productType is not null')
  288.                 ->setParameter('wholesaler', $wholesaler)
  289.                 ->getSingleScalarResult();
  291.             $recordsFiltered = $entityManager
  292.                 ->createQuery($dqlCountFiltered)
  293.                 ->setParameter('wholesaler', $wholesaler);
  294.             if (!empty($sqlFilter)) {
  295.                 $recordsFiltered=$recordsFiltered->setParameter('flavoursGroupIds', $flavoursGroupIds);
  296.             }
  297.             $recordsFiltered = $recordsFiltered->getSingleScalarResult();
  298.         }
  299.         else
  300.         {
  301.             //with MINIVENDORS and KATY PROFILES we work with PRODUCT entity
  302.             foreach ($items as $key => $value) {
  303.                 $url = $this->generateUrl('product_editproduct', array('id' => $value->getId()));
  304.                 $status = is_null($value->getUnregistrationDate()) ? "<span class='label label-success'>".$translator->trans('app.General.Active')."</span>" : "<span class='label label-danger'>".$translator->trans('app.General.Inactive')."</span>";
  305.                 $circle = ($value->getProductType()->getId()!=1 || !is_null($value->getRenovationProduct())) ? "<i class='base fa fa-lg fa-fw m-r-10 fa-plus-circle' group='".$value->getGroupId()."' style='pointer:cursor;'></i>" : "" ;
  306.                 $data[] = [
  307.                     'DT_RowId' => $value->getId(),
  308.                     $circle,
  309.                     $value->getProductline()->getVendor()->getName(),
  310.                     $value->getProductline()->getName(),
  311.                     "<span title='".$value->getName()."'><a href='".$url."' >".$value->getName()."</a></span>",
  312.                     $value->getSku(),
  313.                     $value->getDuration(),
  314.                     $translation->getTranslationBy($value->getPayperiod(), $locale, 'period'),
  315.                     $status,
  316.                 ];
  317.             }
  319.             $queryRecordsTotal='';
  320.             if ($vendor!=0) {
  321.                 $queryRecordsTotal='SELECT count(p) FROM App\Entity\Product p JOIN p.productLine pl JOIN pl.vendor v where pl.vendor = :vendor and p.productType is not null';
  322.             }
  323.             else{
  324.                 $queryRecordsTotal='SELECT count(p) FROM App\Entity\Product p JOIN p.productLine pl where p.productType is not null';
  325.             }
  326.             $recordsTotal = $entityManager->createQuery($queryRecordsTotal);
  327.             if ($vendor!=0) {
  328.                 $recordsTotal=$recordsTotal->setParameter('vendor', $vendor);
  329.             }      
  330.             $recordsTotal = $recordsTotal->getSingleScalarResult();
  333.             $recordsFiltered = $entityManager
  334.                 ->createQuery($dqlCountFiltered);
  335.             if ($vendor!=0) {
  336.                 $recordsFiltered=$recordsFiltered->setParameter('vendor', $vendor);
  337.             }    
  338.             if (!empty($sqlFilter)) {
  339.                 $recordsFiltered=$recordsFiltered->setParameter('flavoursGroupIds', $flavoursGroupIds);
  340.             }
  342.             $recordsFiltered = $recordsFiltered->getSingleScalarResult();
  343.         }    
  344.         
  345.         return $this->json([
  346.             'recordsTotal' => $recordsTotal,
  347.             'recordsFiltered' => $recordsFiltered,
  348.             'data' => $data,
  349.             'dql' => $dql,
  350.             'groupIds' => $flavoursGroupIds,
  351.             'dqlCountFiltered' => $dqlCountFiltered,
  352.         ]);
  353.     }
  356.     /**
  357.      * @Route("/product/default/exportproducts", name="product_export")
  358.      */
  359.     public function exportProducts(Request $request, TrafficTracker $trafficTracker, TranslatorInterface $translator) {
  361.         $trafficId = $trafficTracker->registerTraffic();
  362.         $user = $this->getUser();
  363.         $entityManager = $this->getDoctrine()->getManager();
  364.         $pbwRepository = $this->getDoctrine()->getRepository(Productbywholesaler::class);
  365.         $entityIds = $request->request->get('entityIds');
  367.         $spreadsheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet();
  368.         $sheet = $spreadsheet->getActiveSheet();
  370.         $sheet->SetCellValue('A1', $translator->trans('app.General.Vendor'));
  371.         $sheet->SetCellValue('B1', $translator->trans('app.General.ProductLine'));
  372.         $sheet->SetCellValue('C1', $translator->trans('app.General.Name'));
  373.         $sheet->SetCellValue('D1', $translator->trans('app.General.SKU'));
  374.         $sheet->SetCellValue('E1', $translator->trans('app.General.Duration'));
  375.         if ($user->getWholesaler()) {
  376.             $sheet->SetCellValue('F1', $translator->trans('app.General.Price'));
  377.             $sheet->SetCellValue('G1', $translator->trans('app.LicenseManager.PaymentPeriod'));
  378.             $sheet->SetCellValue('H1', $translator->trans('app.General.Status'));      
  379.         }
  380.         else{
  381.             $sheet->SetCellValue('F1', $translator->trans('app.LicenseManager.PaymentPeriod'));
  382.             $sheet->SetCellValue('G1', $translator->trans('app.General.Status'));
  383.         }
  385.         if ($user->getWholesaler()) {
  386.             $groupIds = $entityManager
  387.             ->createQuery('SELECT p.groupid FROM App\Entity\Productbywholesaler pbw JOIN pbw.product p JOIN p.productLine pl JOIN pl.vendor v where v.isminivendor = 0 and pbw.wholesaler = :wholesaler and pbw.id IN (:pbwIds)')
  388.             ->setParameter('wholesaler', $user->getWholesaler())
  389.             ->setParameter('pbwIds', $entityIds)
  390.             ->getResult();
  392.             $pbws = $entityManager
  393.             ->createQuery('SELECT pbw FROM App\Entity\Productbywholesaler pbw JOIN pbw.product p where  p.groupid IN (:groupIds) and pbw.wholesaler = :wholesaler')
  394.             ->setParameter('wholesaler', $user->getWholesaler())
  395.             ->setParameter('groupIds', $groupIds)
  396.             ->getResult();
  398.             $pos = 2;
  400.             foreach ($pbws as $pbw) {
  401.                 $sheet->SetCellValue('A' . $pos, $pbw->getProduct()->getProductline()->getVendor()->getName());
  402.                 $sheet->SetCellValue('B' . $pos, $pbw->getProduct()->getProductline()->getName());
  403.                 $sheet->SetCellValue('C' . $pos, $pbw->getProduct()->getName());
  404.                 $sheet->SetCellValue('D' . $pos, $pbw->getProduct()->getSku());
  405.                 $sheet->SetCellValue('E' . $pos, $pbw->getProduct()->getDuration());
  406.                 $currency = $user->getWholesaler()->getCurrency()->getIso();
  407.                 $currencyFormat = new \NumberFormatter($request->getLocale(), \NumberFormatter::CURRENCY);
  408.                 $sheet->SetCellValue('F' . $pos, $currencyFormat->formatCurrency(round($pbwRepository->getPrice($pbw), 2), $currency));
  409.                 $sheet->SetCellValue('G' . $pos, $pbw->getProduct()->getPayperiod()->getPeriod());
  410.                 $sheet->SetCellValue('H' . $pos, !is_null($pbw->getUnregistrationdate()) ? $translator->trans('app.General.Inactive') : $translator->trans('app.General.Active'));         
  411.                 $pos++;
  412.             }
  413.         }
  414.         else{
  415.             $products = $entityManager
  416.             ->createQuery('SELECT p FROM App\Entity\Product p where  p.groupid IN (:groupIds)')
  417.             ->setParameter('groupIds', $entityIds)
  418.             ->getResult();
  420.             $pos = 2;
  422.             foreach ($products as $p) {
  423.                 $sheet->SetCellValue('A' . $pos, $p->getProductline()->getVendor()->getName());
  424.                 $sheet->SetCellValue('B' . $pos, $p->getProductline()->getName());
  425.                 $sheet->SetCellValue('C' . $pos, $p->getName());
  426.                 $sheet->SetCellValue('D' . $pos, $p->getSku());
  427.                 $sheet->SetCellValue('E' . $pos, $p->getDuration());
  428.                 $sheet->SetCellValue('F' . $pos, $p->getPayperiod()->getPeriod());
  429.                 $sheet->SetCellValue('G' . $pos, $p->getDuration());         
  430.                 $pos++;
  431.             }
  432.         }     
  433.         
  435.         $writer = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet);
  436.         $fileName = 'orders_' . date('Y-m-d') . '.xlsx';
  437.         header('Content-Type: application/vnd.ms-excel');
  438.         header('Content-Disposition: attachment; filename="' . urlencode($fileName) . '"');
  439.         header('Cache-Control: max-age=0');
  441.         ob_start();
  442.         $writer->save('php://output');
  444.         $xlsData = ob_get_contents();
  445.         ob_end_clean();
  447.         $response = array('op' => 'ok', 'file' => "data:application/vnd.ms-excel;base64," . base64_encode($xlsData));
  448.         die(json_encode($response));
  449.     }
  450.     
  451.     
  452.     /**
  453.      *
  454.      * @Route("/product/default/editproduct/{id}", name="product_editproduct", requirements={"id"="\d+"})
  455.      */
  456.     public function editproduct(Request $request, TrafficTracker $trafficTracker, TranslatorInterface $translator, Translation $translation, RegisterEvent $registerEvent, SanitizeService $sanitizeService, JsonSearchService $jsonSearchService, $id = 0, ExtensionFileService $extensionFileService) {
  457.          
  458.         $trafficTracker->registerTraffic();
  459.         $entityManager = $this->getDoctrine()->getManager();
  460.         $productRepository = $this->getDoctrine()->getRepository(Product::class);
  461.         $pbwRepository = $this->getDoctrine()->getRepository(Productbywholesaler::class);
  462.         $userRepository = $this->getDoctrine()->getRepository(User::class);
  463.         $licensetypeRepository = $this->getDoctrine()->getRepository(\App\Entity\Licensetype::class);
  464.         $locale = $request->getLocale();
  466.         $session = $this->get('session');
  467.         $productQ = $productRepository->find($id);        
  468.         $user = $this->getUser();
  469.         $currency = array();
  470.         $control = false;
  471.         $userKaty = null;  
  472.         $isBasePrice = false;     
  474.         if ($user->getWholesaler()) {
  475.             $product = $entityManager->createQuery("SELECT pbw FROM \App\Entity\Productbywholesaler pbw "               
  476.                 . 'where pbw.wholesaler = :idWholesaler and pbw.id = :id ')
  477.                 ->setParameter('idWholesaler', $this->getUser()->getWholesaler()->getId())
  478.                 ->setParameter('id', $id)
  479.                 ->getOneOrNullResult();
  480.             
  481.             if (!is_null($product)) { $isBasePrice = $productRepository->isBasePriceProduct($product->getProduct()); }
  482.               
  483.         }
  484.         else if ($user->getVendor()) {
  485.             
  486.             if (!$productQ) {
  487.                 
  488.                 return $this->redirectToRoute('product_index');
  489.             }
  490.             
  491.             $product = $entityManager->createQuery("SELECT pbw FROM \App\Entity\Productbywholesaler pbw "               
  492.                 . 'where pbw.product = :product ')
  493.                 ->setParameter('product', $productQ)
  494.                 ->getResult();
  495.             
  496.             $isBasePrice = $productRepository->isBasePriceProduct($productQ);    
  497.         }
  498.         else if ($user->getPartner() == null && $user->getCustomer() == null) {
  499.             $userKaty = true;
  500.             $product = $productRepository->find($id);
  501.         }
  503.         if (!$product) { return $this->redirectToRoute('product_index'); }
  505.         $productImages = array();
  506.         $productCover = array();
  507.         $productBwImages = array();
  508.         $cont = array();
  510.         if ($this->getUser()->getWholesaler()) {
  512.             if ($product->getUnregistrationdate() != null) {
  513.                 $active = false;
  514.             }
  515.             else {
  516.                 $active = true;
  517.             }
  519.             $data = array(
  520.               'precio' => $pbwRepository->getPrice($product, false) ? $pbwRepository->getPrice($product, false) : 0,
  521.               'active' => $active,
  522.               'description' => $product->getDescription(),
  523.               'saleTerms' => $product->getSaleTerms(),
  524.               'requirements' => $product->getRequirements(),
  525.               //'stock' => 0,
  526.               //'allowOverage' => true,
  527.               //'overage' => 0,
  528.               'isHardware' => $product->getProduct()->getIsHardware(),
  529.               'isBasePrice' => $isBasePrice,
  530.               'basePrice' => $product->getBasePrice(),
  531.               'isMain' => $product->getProduct()->getId()==$product->getProduct()->getGroupid() ? true : false
  532.             );
  533.         }
  534.         else if ($this->getUser()->getVendor()) {
  535.             foreach ($product as $p) {
  536.                 if ($p->getUnregistrationdate() != null) {
  537.                     $active = false;
  538.                 }
  539.                 else {
  540.                     $active = true;
  541.                 }
  543.                 $data[$p->getId()] = array(
  544.                   'id' => $p->getId(),
  545.                   'country' => $p->getWholesaler()->getCountry()->getAlpha3Code(),
  546.                   'precio' => $pbwRepository->getPrice($p, false) ? $pbwRepository->getPrice($p, false) : 0,
  547.                   'active' => $active,
  548.                   'description' => $p->getDescription(),
  549.                   'saleTerms' => $p->getSaleTerms(),
  550.                   'requirements' => $p->getRequirements(),
  551.                 ); 
  552.             }
  553.         }
  554.         else if ($userKaty) {
  555.             
  556.             if ($product->getUnregistrationdate() != null) {
  557.                 $active = false;
  558.             }
  559.             else {
  560.                 $active = true;
  561.             }
  563.             $data = array(
  564.               'active' => $active,
  565.             );            
  566.             
  567.         }
  569.         $form = $this->createForm(EditProduct::class, null, array(
  570.             'translator' => $translator,
  571.             'productQ' => $productQ,
  572.             'data' => $data,
  573.             'user' => $user,
  574.             'userKaty' => $userKaty,
  575.         ));
  576.         
  577.         $form->handleRequest($request);
  579.         // If cancelled
  580.         if ($form->getClickedButton() && 'cancel' === $form->getClickedButton()->getName()) {          
  581.             $this->get('session')->getFlashBag()->add('warning', $translator->trans('app.General.SystemMessages.NoChanges'));
  582.             return $this->redirectToRoute('product_index');        
  583.         }
  586.         if ($userKaty || $user->getVendor() && $productQ->getIsFlavour() == 0 && $productQ->getCanSellAlone() == 1) {
  587.             //Delete coverImage
  588.             if ($form->isSubmitted() && $form->isValid() && $form->get('deletecoverImage')->isClicked()) {
  589.                 $post = $form->getData();
  590.                 $selectedimages = $post['selecteditemsCover'];
  591.                 $selectedimagesarray = explode(',', $selectedimages);
  592.                 $this->deleteImages($translator, $id, $selectedimagesarray, $session, $extensionFileService);
  593.                 return $this->redirectToRoute('product_editproduct', array('id' => $id));     
  594.             }
  595.         }
  596.         
  597.         
  598.         if ($userKaty || $user->getWholesaler() || $user->getVendor() && $productQ->getIsFlavour() == 0 && $productQ->getCanSellAlone() == 1) {        
  599.             
  600.             //Delete images           
  601.             if ($form->isSubmitted() && $form->isValid() && $form->get('deleteImages')->isClicked()) { 
  602.                 $post = $form->getData();
  603.                 $selectedimages = $post['selecteditems'];
  604.                 $selectedimagesarray = explode(',', $selectedimages);
  605.                 $this->deleteImages($translator, $id, $selectedimagesarray, $session, $extensionFileService);
  606.                 return $this->redirectToRoute('product_editproduct', array('id' => $id));     
  607.             }
  608.                        
  609.             if ($user->getVendor()) {
  610.                 foreach ($product as $p) {
  611.                     if ($form->isSubmitted() && $form->isValid() && $form->get('deletepbwImages_' . $p->getId())->isClicked()) {
  613.                         $post = $form->getData();
  615.                         $selectedimages = $post['selecteditemsPbwImages_' . $p->getId()];
  617.                         $selectedimagesarray = explode(',', $selectedimages);
  619.                         $this->deleteImages($translator, $id, $selectedimagesarray, $session, $extensionFileService);
  620.                         $control = true;
  621.                     }
  622.                 }
  624.                 if ($control == true) {
  625.                     return $this->redirectToRoute('product_editproduct', array('id' => $id));    
  626.                 }
  627.             }
  628.         }
  629.             
  630.         if ($form->isSubmitted() and $form->isValid()) {          
  631.             $post = $form->getData();
  632.             if ($user->getWholesaler()) {
  633.                 if ($post['active']) {                  
  634.                     $prd = $productRepository->find($product->getProduct());                   
  635.                     if ($prd->getId() == $prd->getGroupId()) {
  636.                                               
  637.                         $prdGroup = $entityManager->createQuery('SELECT p FROM App\Entity\Product p '            
  638.                             . 'where p.groupid = :groupId ')
  639.                             ->setParameters(array('groupId' => $prd->getGroupId()))
  640.                             ->getResult();
  641.                         
  642.                         $pbwToActive = $pbwRepository->createQueryBuilder('pbw') 
  643.                             ->andWhere('pbw.wholesaler = :idWholesaler and pbw.product IN (:products)')    
  644.                             ->setParameters(array('idWholesaler'=> $user->getWholesaler(), 'products'=> $prdGroup))
  645.                             ->getQuery()
  646.                             ->getResult();
  647.                                         
  648.                         foreach ($pbwToActive as $pbw) {
  649.                             $pbw->setUnregistrationdate(null);
  650.                             $entityManager->persist($pbw);
  651.                             $entityManager->flush();
  652.                         }
  653.                     }
  654.                     else {
  655.                         $product->setUnregistrationdate(null);
  656.                     }
  657.                 }
  658.                 else if(!$product->getUnregistrationdate() && $post['active'] == false){
  660.                     $prd = $productRepository->find($product->getProduct());
  662.                     if ($prd->getId() == $prd->getGroupId()) {
  664.                         $prdGroup = $entityManager->createQuery('SELECT p FROM App\Entity\Product p '            
  665.                             . 'where p.groupid = :groupId ')
  666.                             ->setParameters(array('groupId' => $prd->getGroupId()))
  667.                             ->getResult();
  668.                         
  669.                         $pbwToDelete = $pbwRepository->createQueryBuilder('pbw') 
  670.                             ->andWhere('pbw.wholesaler = :idWholesaler and pbw.product IN (:products)')    
  671.                             ->setParameters(array('idWholesaler'=> $user->getWholesaler(), 'products'=> $prdGroup))
  672.                             ->getQuery()
  673.                             ->getResult();
  675.                         foreach ($pbwToDelete as $pbw) {
  677.                             $pbw->setUnregistrationdate(new \DateTime());
  678.                             $entityManager->persist($pbw);
  679.                             $entityManager->flush();
  680.                         }
  681.                     }
  682.                     else {
  683.                         $product->setUnregistrationdate(new \DateTime());
  684.                     }
  685.                 }
  687.                 if($sanitizeService->getSanitize($form->get('description')->getData())){
  688.                     $product->setDescription($form['description']->getData());                                  
  689.                 }else{
  690.                     $product->setDescription('');              
  691.                 }
  692.                 if($sanitizeService->getSanitize($form->get('requirements')->getData())){
  693.                     $product->setRequirements($form['requirements']->getData());                                  
  694.                 }else{
  695.                     $product->setRequirements('');              
  696.                 }
  697.                 if($sanitizeService->getSanitize($form->get('saleTerms')->getData())){
  698.                     $product->setSaleTerms($form['saleTerms']->getData());                                  
  699.                 }else{
  700.                     $product->setSaleTerms('');              
  701.                 }
  702.                 
  703.                 $product->setPrice($post['Price']);
  705.                 if($isBasePrice){$product->setBasePrice($post['BasePrice']);}              
  707.                 $entityManager->persist($product);
  708.                 $entityManager->flush();
  709.             }
  710.             
  711.             if ($user->getVendor()) {
  712.                 foreach ($product as $p) {
  713.                     $p->setPrice($post['Price_' . $p->getId()]);
  714.                     if ($user->getWholesaler() || $user->getVendor() && $productQ->getIsFlavour() == 0 && $productQ->getCanSellAlone() == 1) {
  715.                         $p->setDescription($post['description_' . $p->getId()]);
  716.                         $p->setSaleTerms($post['saleTerms_' . $p->getId()]);
  717.                         $p->setRequirements($post['requirements_' . $p->getId()]);
  718.                     }
  719.                     $entityManager->persist($p);
  720.                     $entityManager->flush();
  721.                 }
  722.             }         
  723.             
  724.             //Save the images in the product If there is an attachment
  725.             if (!empty($post['attachment_'])) {
  726.                 $postType = "attachment_";
  727.                 $this->addImages($id, $product, $post['attachment_'], $userKaty, $postType, $translator, $registerEvent, $session);
  728.             }
  730.             foreach ($product as $p) {
  731.                 if (!empty($post['pbwImages_' . $p->getId()])) {
  732.                     $postType = "attachmentpbw_";
  733.                     $this->addImages($id, $p, $post['pbwImages_' . $p->getId()], $userKaty, $postType, $translator, $registerEvent, $session);
  734.                 }
  735.             }
  737.             
  738.             if (!empty($post['coverImage_'])) {
  740.                 $imageCover = $entityManager->createQuery('SELECT pi FROM App\Entity\Productimages pi '            
  741.                     . 'where pi.product = :product and pi.iscoverimage = 1 ')
  742.                     ->setParameters(array('product' => $productQ))
  743.                     ->getResult();    
  745.                 if (sizeof($imageCover) != 0) {
  746.                     $this->get('session')->getFlashBag()->add('danger', $translator->trans('app.General.SystemMessages.LimitExceeded'));
  747.                     return $this->redirectToRoute('product_editproduct', array('id' => $id)); 
  748.                 }
  750.                 $postType = "coverImage_";
  752.                 $this->addImages($id, $product, $post['coverImage_'], $userKaty, $postType, $translator, $registerEvent, $session);
  753.             }            
  754.       
  755.             
  756.             if ($session->getFlashBag()->keys() == null) 
  757.             {
  758.                 
  759.                 if ($form->getClickedButton() && 'save' === $form->getClickedButton()->getName()) {
  760.                     $session->getFlashBag()->add('success', $translator->trans('app.General.SystemMessages.ChangesSaved'));
  761.                     return $this->redirectToRoute('product_index'); 
  762.                 }
  763.                 
  764.                 
  765.                 if ($user->getVendor()) {
  766.                   foreach ($product as $p) {
  767.                       if ($form->isSubmitted() && $form->isValid() && $form->get('save_view_' . $p->getId())->isClicked()) {  
  768.                           if ($p->getUnregistrationdate()) { 
  769.                             $session->getFlashBag()->add('success', $translator->trans('app.General.SystemMessages.ChangesSaved'));
  770.                           }
  771.                           else {
  772.                             return $this->redirectToRoute('catalog_view', array('id' => $p->getId())); 
  773.                           }
  774.                       }
  775.                   }
  776.                 }
  777.                 
  778.                                
  779.                 if (!$user->getVendor() && $form->getClickedButton() && 'save_view' === $form->getClickedButton()->getName()) {
  780.                     if ($product->getUnregistrationdate()) {
  781.                         $session->getFlashBag()->add('success', $translator->trans('app.General.SystemMessages.ChangesSaved'));
  782.                         return $this->redirectToRoute('product_index'); 
  783.                     }
  784.                     else {
  785.                         return $this->redirectToRoute('catalog_view', array('id' => $id)); 
  786.                     }
  787.                 }
  788.             }           
  789.             else {
  790.                 foreach ($session->getFlashBag()->all()['danger'] as $a) {
  791.                     $session->getFlashBag()->add('danger', $a);
  792.                 }
  793.                 return $this->redirectToRoute('product_editproduct', array('id' => $id)); 
  794.             }
  795.             
  796.         }
  797.         
  798.         if ($this->getUser()->getWholesaler()) {
  799.             $images = $entityManager->createQuery('SELECT pi FROM App\Entity\Productimages pi '            
  800.             . 'where pi.productByWholesaler = :pbw and pi.iscoverimage = 0 ')
  801.             ->setParameters(array('pbw' => $product))
  802.             ->getResult();           
  803.         }       
  804.         else if ($user->getVendor()) {
  805.             
  806.             $images = $entityManager->createQuery('SELECT pi FROM App\Entity\Productimages pi '            
  807.             . 'where pi.product = :product and pi.iscoverimage = 0 and pi.productByWholesaler is null ')
  808.             ->setParameters(array('product' => $productQ))
  809.             ->getResult();
  810.           
  811.             foreach ($product as $pId) {
  813.                 $IdW[] = $pId->getId();
  814.             }
  815.             
  816.             $imagespbw = $entityManager->createQuery('SELECT pi FROM App\Entity\Productimages pi '            
  817.             . 'where pi.productByWholesaler IN (:pbw) and pi.iscoverimage = 0 ')
  818.             ->setParameters(array('pbw' => $IdW))
  819.             ->getResult();
  820.             
  821.             if (!empty($imagespbw)) {
  822.                 for ($pos = 0; $pos < sizeof($imagespbw); $pos++) {
  823.                     $productBwImages[] = [
  824.                       'id' => $imagespbw[$pos]->getId(),
  825.                       'pbwId' => $imagespbw[$pos]->getProductByWholesaler()->getId(),
  826.                       'path' => '/uploads/images/productImages/' . $imagespbw[$pos]->getImageName(),
  827.                       'default' => $imagespbw[$pos]->getIsDefaultImage(),
  828.                       'cover' => $imagespbw[$pos]->getIsCoverImage()
  829.                     ];
  830.                 }
  831.                 for ($pos = 0; $pos < sizeof($imagespbw); $pos++) {
  832.                     $cont[$imagespbw[$pos]->getProductByWholesaler()->getId()] = [];
  833.                 }
  834.             }
  835.             $imageCover = $entityManager->createQuery('SELECT pi FROM App\Entity\Productimages pi '            
  836.                     . 'where pi.product = :product and pi.iscoverimage = 1 ')
  837.                     ->setParameters(array('product' => $productQ))
  838.                     ->setMaxResults(1) 
  839.                     ->getOneOrNullResult();
  840.             
  841.         }        
  842.         else if ($userKaty) {
  844.             $productQ = $product;
  845.          
  846.             $images = $entityManager->createQuery('SELECT pi FROM App\Entity\Productimages pi '            
  847.             . 'where pi.product = :product and pi.productByWholesaler is null and pi.iscoverimage = 0 ')
  848.             ->setParameters(array('product' => $productQ))
  849.             ->getResult();
  850.             
  851.             $imageCover = $entityManager->createQuery('SELECT pi FROM App\Entity\Productimages pi '            
  852.             . 'where pi.product = :product and pi.iscoverimage = 1 ')
  853.             ->setParameters(array('product' => $productQ))
  854.             ->setMaxResults(1)        
  855.             ->getOneOrNullResult();
  857.         }
  858.                 
  859.         if (!empty($images)) {
  860.             for ($pos = 0; $pos < sizeof($images); $pos++) {
  861.                 $productImages[] = [
  862.                   'id' => $images[$pos]->getId(),
  863.                   'path' => '/uploads/images/productImages/' . $images[$pos]->getImageName(),
  864.                   'default' => $images[$pos]->getIsDefaultImage(),
  865.                   'cover' => $images[$pos]->getIsCoverImage()
  866.                 ];
  867.             }
  868.         }
  870.         if (!empty($imageCover)) {
  871.             $productCover = [
  872.               'id' => $imageCover->getId(),
  873.               'path' => '/uploads/images/productImages/' . $imageCover->getImageName(),
  874.               'default' => $imageCover->getIsDefaultImage(),
  875.               'cover' => $imageCover->getIsCoverImage()
  876.             ];
  877.         }
  879.         if ($this->getUser()->getWholesaler()) {
  880.             $productQ = $product->getProduct();
  881.         }
  882.         
  883.         if ($this->getUser()->getVendor()) {
  884.             foreach ($product as $item) {
  886.                 $agreement = $entityManager->createQuery('SELECT a FROM App\Entity\Agreements a '            
  887.                     . 'where a.programm = :programm and a.wholesaler = :wholesaler ')
  888.                     ->setParameters(array('programm' => $productQ->getVendorProgramm()->getId(), 'wholesaler'=>$item->getWholesaler()->getId()))
  889.                     ->setMaxResults(1)
  890.                     ->getOneOrNullResult();
  891.  
  892.                 $currency[$item->getWholesaler()->getId()] = ( ($agreement) ? $agreement->getEntryCurrency()->getIso() : $item->getWholesaler()->getCurrency()->getIso());
  893.             }
  894.         }
  895.         
  896.         $licenseTypeIds=$jsonSearchService->searchKeyInArray($productRepository->getParentSkuIds($productQ)->getParameters(), 'licenseType');
  897.         
  898.         $licenseTypes=[];
  899.         if($licenseTypeIds){
  900.             foreach($licenseTypeIds[0] as $value){                
  901.                 $lt = $licensetypeRepository->find((int)$value);
  902.                 $licenseTypes[$lt->getId()] = $translation->getTranslationBy($lt, $locale, 'name');   
  903.             }
  904.         }
  905.                 
  906.         return $this->render('/product/editproduct.html.twig', array(
  907.             'cont' => $cont,
  908.             'currency' => $currency,
  909.             'productByWh' => $product,
  910.             'product' => $productQ,
  911.             'payperiod' => $productQ->getPayPeriod(),
  912.             'licensetype' => $licenseTypes,
  913.             'productImages' => $productImages,
  914.             'productCover' => $productCover,
  915.             'productBwImages' => $productBwImages,
  916.             'userKaty' => $userKaty,
  917.             'form' => $form->createView(),
  918.             'userRepository' => $userRepository,
  919.             'isBasePrice' => $isBasePrice,
  920.          ));
  921.     }    
  922.     
  923.     
  924.     public function addImages($id, $product, $post, $userKaty, $postType, $translator, $registerEvent, $session) {
  925.         $entityManager = $this->getDoctrine()->getManager();
  926.         $productRepository = $this->getDoctrine()->getRepository(Product::class);
  927.         $user = $this->getUser();   
  928.         $numImg = 0;
  929.         foreach ($post as $img) {
  930.             $productImg = new Productimages();
  931.             // Get extension
  932.             $extension = $img->guessExtension();
  933.             // Get size
  934.             $size = $img->getSize();
  935.             $valid_extensions = array('jpeg', 'jpg', 'png', 'gif');
  936.             if (in_array($extension, $valid_extensions)) {
  937.                 //Check file size '1MB'
  938.                 if ($size < 1000000) {
  939.                     $image = getimagesize($img);
  940.                     $maximum = array(
  941.                       'width' => '500',
  942.                       'height' => '600'
  943.                     );
  944.                     $image_width = $image[0];
  945.                     $image_height = $image[1];
  946.                     if ($image_width > $maximum['width'] || $image_height > $maximum['height']) {                      
  947.                         $session->getFlashBag()->add('danger', $translator->trans('app.General.Guidelines.Max500px'));
  948.                         return $this->redirectToRoute('product_editproduct', ['id' => $id]);                             
  949.                     }
  950.                     else {
  951.                         // Get extension
  952.                         $filename = uniqid() . '.' . $extension;
  953.                         $productImg->setImagename($filename);
  954.                         // Try to save file
  955.                         $img->move($this->getParameter('private_folder').'/images/productImages/', $filename);
  956.                         $productImg->setRegistrationdate(new \DateTime());
  958.                         if ($postType == "attachment_") {
  959.                             if ($user->getWholesaler()) {
  960.                                 $productImg->setProductByWholesaler($product);
  961.                             }
  962.                             else if ($userKaty or $user->getVendor()) {
  963.                                 $productQ = $productRepository->find($id);
  964.                                 if ($user->getVendor()) {
  965.                                     $product = $productQ;
  966.                                 }
  967.                                 $productImg->setProduct($product);
  968.                             }
  969.                             if ($numImg == 0) {
  970.                                 
  971.                                 $images = $entityManager->createQuery('SELECT pi FROM App\Entity\Productimages pi '            
  972.                                     . 'where pi.product = :productId and pi.isdefaultimage = 1')
  973.                                     ->setParameters(array('productId' => $id))
  974.                                     ->getResult();
  975.                                 
  976.                                 if (sizeof($images)) {
  977.                                     $productImg->setisDefaultImage(1);
  978.                                 }
  979.                             }
  980.                         }
  982.                         if ($postType == "coverImage_") {
  983.                             $productQ = $productRepository->find($id);
  984.                             if ($user->getVendor()) {
  985.                                 $product = $productQ;
  986.                             }
  987.                             $productImg->setProduct($product);
  988.                             $productImg->setIsCoverImage(1);
  989.                         }
  991.                         if ($postType == "attachmentpbw_") {
  992.                             $productImg->setProductByWholesaler($product);
  993.                         }
  995.                         $entityManager->persist($productImg);
  996.                         $entityManager->flush();           
  997.                         $registerEvent->addModifiedBy($productImg, $this->getUser()->getId());
  998.                         $numImg++;
  999.                     }
  1000.                 }
  1001.                 else {
  1002.                     $session->getFlashBag()->add('danger', $translator->trans('app.General.Guidelines.ImageSize'));
  1003.                     return $this->redirectToRoute('product_editproduct', array('id' => $id)); 
  1004.                 }
  1005.             }
  1006.             else {
  1007.                 $session->getFlashBag()->add('danger', $translator->trans('app.General.Guidelines.ImageFormat'));
  1008.                 return $this->redirectToRoute('product_editproduct', array('id' => $id)); 
  1010.             }
  1011.         }
  1012.     }
  1013.     
  1014.     
  1015.     private function deleteImages($translator, $productId, $imagesId, $session, $extensionFileService) {
  1016.         
  1017.         $mistakes = false;
  1018.         $entityManager = $this->getDoctrine()->getManager();
  1019.         $imageRepository = $this->getDoctrine()->getRepository(Productimages::class);
  1020.         
  1021.         foreach ($imagesId as $id) {          
  1022.             $imageToDelete = $imageRepository->find($id);
  1023.             if ($imageToDelete != null) {
  1024.                 $image_path = $this->getParameter('private_folder').'/images/productImages/' . $imageToDelete->getImagename();
  1025.                 $imageName = $imageToDelete->getImagename();
  1026.                 $sanitize = $extensionFileService->getSanitize('img', $imageName);
  1027.                 if($sanitize){
  1028.                     if (file_exists($image_path)) {
  1029.                         unlink($image_path);
  1030.                     }
  1031.                     $entityManager->remove($imageToDelete);
  1032.                     $entityManager->flush();
  1033.                 }
  1034.                 else {
  1035.                     $mistakes = true;
  1036.                 }
  1037.             }
  1038.             else {
  1039.                 $mistakes = true;
  1040.             }
  1041.         }
  1042.         
  1043.         if (!$imagesId){
  1044.             $session->getFlashBag()->add('danger', $translator->trans('app.General.SystemMessages.NoChanges'));
  1045.         }
  1046.         if ($mistakes){
  1047.             $session->getFlashBag()->add('danger', $translator->trans('app.General.SystemMessages.NoChanges'));
  1048.         }
  1049.         else{
  1050.             $session->getFlashBag()->add('success', $translator->trans('app.General.SystemMessages.Deleted'));
  1051.         }
  1052.     }
  1053.     
  1054.     
  1055.     private function searchProductsToDownload($pais=0) {
  1056.         
  1057.         $em = $this->getDoctrine()->getManager();
  1058.         $userRepository = $this->getDoctrine()->getRepository(User::class); 
  1059.         $user = $userRepository->find($this->getUser()->getId());
  1060.         
  1061.         if ($pais) {
  1062.             $wholesaler = $em->createQuery('SELECT w FROM App\Entity\Wholesaler w '            
  1063.                 . 'where w.country = :country ')
  1064.                 ->setParameters(array('country' => $pais))
  1065.                 ->setMaxResults(1)
  1066.                 ->getOneOrNullResult();
  1067.         }
  1068.         else {
  1069.             $wholesaler = $user->getWholesaler();
  1070.         }
  1071.         
  1072.         $productByWholesaler= $em->createQuery('SELECT pbw FROM App\Entity\Productbywholesaler pbw '            
  1073.             . ' JOIN pbw.product p '
  1074.             . ' JOIN p.productLine pl'
  1075.             . ' JOIN pl.vendor v '
  1076.             . 'where pbw.wholesaler = :wholesaler and v.isminivendor = 0'
  1077.             . 'and p.unregistrationdate is null')
  1078.             ->setParameters(array('wholesaler' => $wholesaler))
  1079.             ->getResult();
  1080.         
  1081.         if($userRepository->isMiniVendor($user)){
  1082.             $productByWholesaler= $em->createQuery('SELECT pbw FROM App\Entity\Productbywholesaler pbw '            
  1083.                 . ' JOIN pbw.product p '
  1084.                 . ' JOIN p.productLine pl '
  1085.                 . ' JOIN pl.vendor v '    
  1086.                 . 'where pbw.wholesaler = :wholesaler and v.id = :vendor '
  1087.                 . 'and p.unregistrationdate is null')
  1088.                 ->setParameters(array('wholesaler' => $wholesaler->getId(), 'vendor'=>$this->getUser()->getVendor()->getId()))
  1089.                 ->getResult();
  1090.         }
  1091.         return $productByWholesaler;          
  1092.     }
  1093.     
  1094.     
  1095.     /**
  1096.     * 
  1097.     * @Route("/product/default/editbackofficeproduct/{groupid}", name="edit_backoffice_product", requirements={"groupid"="\d+"}))
  1098.     */
  1099.     public function editpbw(Request $request, $groupid, $edit = null) {
  1100.         $em = $this->getDoctrine()->getManager();  
  1101.         $payPeriodRepository = $this->getDoctrine()->getRepository(\App\Entity\Payperiod::class);
  1102.         $productRepository = $this->getDoctrine()->getRepository(\App\Entity\Product::class);
  1103.         $productUnitRepository = $this->getDoctrine()->getRepository(\App\Entity\Productunit::class);
  1104.         $plRepository = $this->getDoctrine()->getRepository(\App\Entity\Productline::class);
  1105.         $vpRepository = $this->getDoctrine()->getRepository(\App\Entity\Vendorprogramms::class);
  1106.         
  1107.         $edit = $request->get('edit');       
  1108.         $updates = json_decode($request->get('updates'));
  1109.         
  1110.         if ($edit) {
  1112.             foreach ($updates as $key => $toedit) {
  1113.                 $product = $productRepository->find($key);
  1114.                 $product->setName($toedit->name);
  1115.                 $product->setDescriptiveName($toedit->descriptivename);                              
  1116.                 $product->setDuration($toedit->duration);
  1117.                 $product->setPayperiod($payPeriodRepository->find($toedit->payperiod));
  1118.                 $product->setVolumeMin($toedit->volmin);
  1119.                 $product->setVolumeMax($toedit->volmax);
  1120.                 $product->setProductUnit($productUnitRepository->find($toedit->unitid));
  1121.                 $product->setProductline($plRepository->find($toedit->plid));
  1122.                 $product->setProductVendorId($toedit->productVendorId);
  1123.                 $product->setIsVolumeEditable($toedit->volumeEditable);
  1124.                 
  1125.                 $product->setDownloadLink($toedit->downloadLink);
  1126.                 $product->setConsoleLink($toedit->consoleLink);
  1127.                 
  1128.                 
  1129.                 $product->setFare($toedit->fare == 0 ? 0 : 1);
  1130.                 if($product->getProducttype()){
  1131.                     $product->setCanSellAlone($request->get('catalog'));                   
  1132.                 }
  1133.                 $product->setCanSell($request->get('catalog'));
  1134.                 $product->setAcceptsMarkup($toedit->markup);
  1135.                 $product->setQuantityActive($toedit->quantityActive);
  1136.                 
  1137.                 $product->setAddons(explode (",", $toedit->addons));
  1138.                 $product->setOrderPriority($toedit->orderPriority);
  1140.                 $product->setRequiresRenewal($request->get('requiresRenewal'));
  1141.                 $product->setVendorProgramm($vpRepository->find($request->get('programm')));
  1142.                 $product->setIsHardware($toedit->isHardware == 0 ? 0 : 1);
  1144.                 $product->setParameters(json_decode($toedit->parameters, true));
  1145.                 $product->setRenovationProduct($productRepository->find($toedit->defaultRenewal));
  1146.                                 
  1147.                 if($toedit->limitRenewalMonths!=""){
  1148.                     $product->setLimitRenewalMonths($toedit->limitRenewalMonths);
  1149.                 }                          
  1150.                 
  1151.                 try {
  1152.                     $product->setSku($toedit->sku);
  1153.                     $em->persist($product);
  1154.                     $em->flush();
  1155.                 }
  1156.                 catch (\Exception $e) {
  1157.         
  1158.                     $this->get('session')->getFlashBag()->add('danger', 'Duplicated Sku: '.$toedit->sku);                      
  1159.                     return $this->redirectToRoute('edit_backoffice_product', ['groupid' => $groupid]);
  1160.                 }
  1161.             }
  1162.         }
  1163.         
  1164.         $products= $em->createQuery('SELECT p FROM App\Entity\Product p '            
  1165.         . 'where p.groupid = :group')
  1166.         ->setParameter('group', $groupid)        
  1167.         ->getResult();                            
  1169.         $arrayProductLines = array();
  1170.         if ($groupid) {           
  1171.             $vendorProgramm= $em->createQuery('SELECT vp FROM App\Entity\Vendorprogramms vp '            
  1172.             . 'where vp.id = :vpId')
  1173.             ->setParameter('vpId', $products[0]->getVendorProgramm()->getId())
  1174.             ->setMaxResults(1)      
  1175.             ->getOneOrNullResult(); 
  1176.             
  1177.             $productLines= $em->createQuery('SELECT pl FROM App\Entity\Productline pl '            
  1178.             . 'where pl.vendor = :vendorId ORDER BY pl.name asc')
  1179.             ->setParameter('vendorId', $vendorProgramm->getVendor()->getId())
  1180.             ->getResult(); 
  1181.             
  1182.             $payperiods= $em->createQuery('SELECT pl FROM App\Entity\Productline pl '            
  1183.             . 'where pl.vendor = :vendorId')
  1184.             ->setParameter('vendorId', $vendorProgramm->getVendor()->getId())
  1185.             ->getResult();
  1186.             
  1187.             $programms= $em->createQuery('SELECT p FROM App\Entity\Vendorprogramms p')->getResult();
  1189.             foreach ($productLines as $pl) {
  1190.                 array_push($arrayProductLines, array("id" => $pl->getId(), "name" => $pl->getName(), "vname" => $pl->getVendor()->getName()));
  1191.             }
  1192.         }
  1194.         return $this->render('backoffice/editbackofficeproduct.html.twig', [
  1195.             'data' => $products, 
  1196.             'groupid' => $groupid, 
  1197.             'productlines' => $arrayProductLines,
  1198.             'payperiods'=> $payPeriodRepository->findAll(),
  1199.             'programms' => $programms
  1200.         ]);
  1201.     }
  1203.     
  1204.     /**
  1205.     * 
  1206.     * @Route("/product/default/getproductsgroup", name="product_getproductsgroup")
  1207.     */
  1208.     public function getproductsgroup(Request $request, TranslatorInterface $translator) {       
  1209.         $em = $this->getDoctrine()->getManager();
  1210.         
  1211.         $arrayProducts = array();
  1212.         $groupid = $request->get('id');
  1214.         $products = $em->createQuery("SELECT p FROM \App\Entity\Product p "               
  1215.             . 'where p.groupid = :group and p.id <> :group')
  1216.             ->setParameter('group', $groupid)
  1217.             ->getResult();
  1218.              
  1219.         foreach ($products as $product) {
  1220.             $url = $this->generateUrl('product_editproduct', array('id' => $product->getId()));
  1221.             $status = is_null($product->getUnregistrationDate()) ? "<span class='label label-success'>".$translator->trans('app.General.Active')."</span>" : "<span class='label label-danger'>".$translator->trans('app.General.Inactive')."</span>";
  1222.             $arrayProducts[$product->getId()] = array(
  1223.                 $product->getId(), 
  1224.                 $product->getProductline()->getName(), 
  1225.                 $product->getName(), $product->getSku(), 
  1226.                 $product->getGroupid(), 
  1227.                 $product->getDuration(), 
  1228.                 $product->getPayperiod()->getPeriod(), 
  1229.                 $product->getVolumemin(), 
  1230.                 $product->getVolumemax(), 
  1231.                 $product->getVendorProgramm()->getId(), 
  1232.                 $product->getFare(), 
  1233.                 $product->getCanSell(), 
  1234.                 $product->getAcceptsMarkup(),
  1235.                 "<span title='".$product->getName()."'><a href='".$url."' >".$product->getName()."</a></span>",
  1236.                 $status,
  1237.             );
  1238.         }
  1239.                 
  1240.         $response = json_encode($arrayProducts);
  1241.               
  1242.         return new Response($response, 200, array(
  1243.             'Content-Type' => 'application/json'
  1244.         ));
  1246.     }
  1249.     /**
  1250.     * 
  1251.     * @Route("/product/default/getallproductsgroup", name="product_getallproductsgroup")
  1252.     */
  1253.     public function getallproductsgroup(Request $request, TranslatorInterface $translator) {       
  1254.         $em = $this->getDoctrine()->getManager();
  1255.         
  1256.         $arrayProducts = array();
  1257.         $groupid = $request->get('id');
  1259.         $products = $em->createQuery("SELECT p FROM \App\Entity\Product p "               
  1260.             . 'where p.groupid = :group')
  1261.             ->setParameter('group', $groupid)
  1262.             ->getResult();
  1263.              
  1264.         foreach ($products as $product) {
  1265.             $url = $this->generateUrl('product_editproduct', array('id' => $product->getId()));
  1266.             $status = is_null($product->getUnregistrationDate()) ? "<span class='label label-success'>".$translator->trans('app.General.Active')."</span>" : "<span class='label label-danger'>".$translator->trans('app.General.Inactive')."</span>";
  1267.             $arrayProducts[$product->getId()] = array(
  1268.                 $product->getId(), 
  1269.                 $product->getProductline()->getName(), 
  1270.                 $product->getName(), $product->getSku(), 
  1271.                 $product->getGroupid(), 
  1272.                 $product->getDuration(), 
  1273.                 $product->getPayperiod()->getPeriod(), 
  1274.                 $product->getVolumemin(), 
  1275.                 $product->getVolumemax(), 
  1276.                 $product->getVendorProgramm()->getId(), 
  1277.                 $product->getFare(), 
  1278.                 $product->getCanSell(), 
  1279.                 $product->getAcceptsMarkup(),
  1280.                 "<a href='".$url."' >".$product->getName()."</a>",
  1281.                 $status,
  1282.             );
  1283.         }
  1284.                 
  1285.         $response = json_encode($arrayProducts);
  1286.               
  1287.         return new Response($response, 200, array(
  1288.             'Content-Type' => 'application/json'
  1289.         ));
  1291.     }
  1294.     /**
  1295.     * 
  1296.     * @Route("/product/default/getpbwsbygroup", name="product_getpbwsbygroup")
  1297.     */
  1298.     public function getpbwsbygroup(Request $request, TranslatorInterface $translator) {       
  1299.         $em = $this->getDoctrine()->getManager();
  1300.         $wholesalerRepository = $this->getDoctrine()->getRepository(\App\Entity\Wholesaler::class);
  1301.         $pbwRepository = $this->getDoctrine()->getRepository(Productbywholesaler::class);
  1302.         $arrayPbws = array();
  1303.         $groupid = $request->get('id');
  1304.         $wholesalerid = $request->get('wholesaler');
  1306.         $pbws = $em->createQuery("SELECT pbw FROM \App\Entity\Productbywholesaler pbw JOIN pbw.product p "               
  1307.             . 'where p.groupid = :group and p.id <> :group and pbw.wholesaler = :wholesaler')
  1308.             ->setParameter('group', $groupid)
  1309.             ->setParameter('wholesaler', $wholesalerid)
  1310.             ->getResult();
  1312.         foreach ($pbws as $pbw) {
  1313.             $url = $this->generateUrl('product_editproduct', array('id' => $pbw->getId()));
  1314.             $status = is_null($pbw->getUnregistrationDate()) ? "<span class='label label-success'>".$translator->trans('app.General.Active')."</span>" : "<span class='label label-danger'>".$translator->trans('app.General.Inactive')."</span>";
  1315.             $currency = $wholesalerRepository->find($wholesalerid)->getCurrency()->getIso();
  1316.             $currencyFormat = new \NumberFormatter($request->getLocale(), \NumberFormatter::CURRENCY);
  1317.             
  1318.             $arrayPbws[$pbw->getId()] = array(
  1319.                 $pbw->getId(),
  1320.                 $pbw->getProduct()->getProductline()->getVendor()->getName(), 
  1321.                 $pbw->getProduct()->getProductline()->getName(), 
  1322.                 "<span title='".$pbw->getProduct()->getName()."'><a href='".$url."' >".$pbw->getProduct()->getName()."</a></span>",
  1323.                 $pbw->getProduct()->getSku(),
  1324.                 $pbw->getProduct()->getDuration(),  
  1325.                 $currencyFormat->formatCurrency(round($pbwRepository->getPrice($pbw), 2), $currency),
  1326.                 $pbw->getProduct()->getPayperiod()->getPeriod(),
  1327.                 $status,
  1328.             );
  1329.         }
  1330.                 
  1331.         $response = json_encode($arrayPbws);
  1332.               
  1333.         return new Response($response, 200, array(
  1334.             'Content-Type' => 'application/json'
  1335.         ));
  1337.     }
  1338.     
  1339.     
  1340.     /**
  1341.     * 
  1342.     * @Route("/product/default/editpbwsbyprogramm", name="product_editpbwsbyprogramm")
  1343.     */
  1344.     public function editpbwsbyprogramm(Request $request, $programmId = 0, $wholesalerId = 0, $productLineId = 0) {
  1346.         $search = $request->get('search');
  1347.         $edit = $request->get('edit');
  1349.         $products = array();
  1350.         $productsToAsign = array();
  1351.         $pbwsArray = array();
  1352.         $arrayProgramms = array();
  1353.         $arrayProductLines = array();
  1355.         $em = $this->getDoctrine()->getManager();  
  1356.         $wholesalerRepository = $this->getDoctrine()->getRepository(\App\Entity\Wholesaler::class);
  1357.         $wholesalers = $wholesalerRepository->findAll();
  1359.         
  1360.         if ($search) {
  1361.             
  1362.             $programmId = $request->get('programm');
  1363.             $wholesalerId = $request->get('wholesaler');
  1364.             $productLineId = $request->get('productline');
  1366.             $products = $em->createQuery("SELECT p FROM \App\Entity\Product p "               
  1367.             . 'where p.vendorProgramm = :programm and p.productLine = :productline '
  1368.             . 'and p.isflavour = 0 and p.unregistrationdate is null and p.productType is not null and p.groupid is not null')
  1369.             ->setParameter('programm', $programmId)
  1370.             ->setParameter('productline', $productLineId)        
  1371.             ->getResult();
  1372.             
  1373.             
  1374.             $pbws = $em->createQuery("SELECT pbw FROM \App\Entity\Productbywholesaler pbw JOIN pbw.product p "               
  1375.             . 'where pbw.wholesaler = :wholesaler and pbw.unregistrationdate is null '
  1376.             . 'and p.vendorProgramm = :programm and p.productLine = :productline '
  1377.             . 'and p.isflavour = 0 and p.unregistrationdate is null and p.productType is not null and p.groupid is not null')
  1378.             ->setParameter('programm', $programmId)
  1379.             ->setParameter('productline', $productLineId)
  1380.             ->setParameter('wholesaler', $wholesalerId)        
  1381.             ->getResult();
  1382.             
  1383.             $pbwsArray = array();
  1384.             foreach ($pbws as $pbw) {
  1385.                 array_push($pbwsArray, $pbw->getProduct()->getId());
  1386.             }
  1388.             $arrayProgramms = $this->getarrayprogrammsbywholesaler($wholesalerId);
  1389.             $arrayProductLines = $this->getarrayplsbyprogramm($programmId);
  1390.         }
  1391.        
  1392.         
  1393.         if ($edit) {
  1395.             $toactive = json_decode($request->get('toactive'));
  1396.             $todisable = json_decode($request->get('todisable'));
  1397.             $wholesalerId = json_decode($request->get('wholesaler'));
  1398.             $programmId = $request->get('programm');
  1399.             $productLineId = $request->get('productline');
  1401.             foreach ($toactive as $newasignation) {
  1403.                 $products = $em->createQuery("SELECT p FROM \App\Entity\Product p "               
  1404.                 . 'where p.groupid = :groupid ')
  1405.                 ->setParameter('groupid', $newasignation)
  1406.                 ->getResult();
  1408.                 
  1409.                 $pbwsAlreadyAsigned = $em->createQuery("SELECT pbw FROM \App\Entity\Productbywholesaler pbw JOIN pbw.product p "               
  1410.                 . 'where pbw.wholesaler = :wholesaler '
  1411.                 . 'and p.groupid = :groupid')
  1412.                 ->setParameter('groupid', $newasignation)
  1413.                 ->setParameter('wholesaler', $wholesalerId)        
  1414.                 ->getResult();
  1417.                 if (sizeof($pbwsAlreadyAsigned) == 0) {
  1418.                     
  1419.                     foreach ($products as $p) {
  1420.                         $newPBW = new Productbywholesaler();
  1421.                         $newPBW->setProduct($p);
  1422.                         $newPBW->setWholesaler($wholesalerRepository->find($wholesalerId));
  1423.                         $em->persist($newPBW);
  1424.                         $em->flush();
  1425.                     }
  1426.                 }
  1427.                 else {
  1428.                     foreach ($pbwsAlreadyAsigned as $pbw) {
  1429.                         $pbw->setUnregistrationdate(null);
  1430.                         $em->persist($pbw);
  1431.                         $em->flush();
  1432.                     }
  1433.                 }
  1434.             }
  1436.             foreach ($todisable as $toUnregistrate) { //id's - por cada wholesaler en el selector
  1438.                 $products = $em->createQuery("SELECT p FROM \App\Entity\Product p "               
  1439.                 . 'where p.groupid = :groupid ')
  1440.                 ->setParameter('groupid', $toUnregistrate)
  1441.                 ->getResult();
  1442.                
  1443.                 $pbwsBase = $em->createQuery("SELECT pbw FROM \App\Entity\Productbywholesaler pbw "               
  1444.                 . 'where pbw.wholesaler = :wholesaler and pbw.product = :product')
  1445.                 ->setParameter('wholesaler', $wholesalerId)
  1446.                 ->setParameter('product', $toUnregistrate)        
  1447.                 ->setMaxResults(1)
  1448.                 ->getResult();
  1450.                 $pbwsToUnregistrate = $em->createQuery("SELECT pbw FROM \App\Entity\Productbywholesaler pbw JOIN pbw.product p "               
  1451.                 . 'where pbw.wholesaler = :wholesaler '
  1452.                 . 'and p.groupid = :groupid')
  1453.                 ->setParameter('groupid', $toUnregistrate)
  1454.                 ->setParameter('wholesaler', $wholesalerId)        
  1455.                 ->getResult();
  1457.                 foreach ($pbwsToUnregistrate as $pbw) {
  1458.                     $pbw->setUnregistrationdate(new \DateTime());
  1459.                     $em->persist($pbw);
  1460.                     $em->flush();
  1461.                 }  
  1462.             }
  1464.             $arrayProgramms = $this->getarrayprogrammsbywholesaler($wholesalerId);
  1465.             $arrayProductLines = $this->getarrayplsbyprogramm($programmId);
  1467.             $products = $em->createQuery("SELECT p FROM \App\Entity\Product p "               
  1468.             . 'where p.vendorProgramm = :programm and p.productLine = :productline '
  1469.             . 'and p.isflavour = 0 and p.unregistrationdate is null and p.productType is not null and p.groupid is not null')
  1470.             ->setParameter('programm', $programmId)
  1471.             ->setParameter('productline', $productLineId)        
  1472.             ->getResult();
  1473.             
  1474.             
  1475.             $pbws = $em->createQuery("SELECT pbw FROM \App\Entity\Productbywholesaler pbw JOIN pbw.product p "               
  1476.             . 'where pbw.wholesaler = :wholesaler and pbw.unregistrationdate is null '
  1477.             . 'and p.vendorProgramm = :programm and p.productLine = :productline '
  1478.             . 'and p.isflavour = 0 and p.unregistrationdate is null and p.productType is not null and p.groupid is not null')
  1479.             ->setParameter('programm', $programmId)
  1480.             ->setParameter('productline', $productLineId)
  1481.             ->setParameter('wholesaler', $wholesalerId)        
  1482.             ->getResult();
  1484.             $pbwsArray = array();
  1485.             foreach ($pbws as $pbw) {
  1486.                 array_push($pbwsArray, $pbw->getProduct()->getId());
  1487.             }
  1488.         } 
  1490.         return $this->render('product/editpbwsbyprogramm.html.twig', [
  1491.             'programmId' => $programmId, 
  1492.             'wholesalers' => $wholesalers, 
  1493.             'wholesalerId' => $wholesalerId, 
  1494.             'productLineId' => $productLineId,
  1495.             'products' => $products,
  1496.             'pbwsArray' => $pbwsArray,
  1497.             'arrayProgramms' => $arrayProgramms, 
  1498.             'arrayProductLines' => $arrayProductLines
  1499.         ]);
  1500.     }
  1502.         /**
  1503.     * 
  1504.     * @Route("/product/default/editpbwskusbyprogramm/{id}/{idWholesaler}", name="product_editpbwskusbyprogramm")
  1505.     */
  1506.     public function editpbwskusbyprogramm(Request $request, $id, $idWholesaler) {
  1508.         $edit = $request->get('edit');
  1510.         $products = array();
  1511.         $productsToAsign = array();
  1512.         $pbwsArray = array();
  1513.         $arrayProgramms = array();
  1514.         $arrayProductLines = array();
  1516.         $em = $this->getDoctrine()->getManager();  
  1517.         $wholesalerRepository = $this->getDoctrine()->getRepository(\App\Entity\Wholesaler::class);
  1518.         $wholesalers = $wholesalerRepository->findAll();
  1520.         $products = $em->createQuery("SELECT p FROM \App\Entity\Product p "               
  1521.         . 'where p.groupid = :id and p.unregistrationdate is null')
  1522.         ->setParameter('id', $id)
  1523.         ->getResult();
  1525.         $pbws = $em->createQuery("SELECT pbw FROM \App\Entity\Productbywholesaler pbw JOIN pbw.product p "               
  1526.         . 'where pbw.wholesaler = :wholesaler and p.groupid = :id and pbw.unregistrationdate is null and p.unregistrationdate is null')
  1527.         ->setParameter('wholesaler', $idWholesaler)
  1528.         ->setParameter('id', $id)        
  1529.         ->getResult();
  1531.         $pbwsArray = array();
  1532.         foreach ($pbws as $pbw) {
  1533.             array_push($pbwsArray, $pbw->getProduct()->getId());
  1534.         }
  1536.         if ($edit) {
  1538.             $toactive = json_decode($request->get('toactive'));
  1539.             $todisable = json_decode($request->get('todisable'));
  1540.             $wholesalerId = json_decode($request->get('wholesaler'));
  1542.             foreach ($toactive as $newasignation) {
  1544.                 $products = $em->createQuery("SELECT p FROM \App\Entity\Product p "               
  1545.                 . 'where p.id = :id ')
  1546.                 ->setParameter('id', $newasignation)
  1547.                 ->getResult();
  1549.                 $pbwsAlreadyAsigned = $em->createQuery("SELECT pbw FROM \App\Entity\Productbywholesaler pbw JOIN pbw.product p "               
  1550.                 . 'where pbw.wholesaler = :wholesaler '
  1551.                 . 'and p.id = :id')
  1552.                 ->setParameter('id', $newasignation)
  1553.                 ->setParameter('wholesaler', $wholesalerId)        
  1554.                 ->getResult();
  1557.                 if (sizeof($pbwsAlreadyAsigned) == 0) {
  1559.                     foreach ($products as $p) {
  1560.                         $newPBW = new Productbywholesaler();
  1561.                         $newPBW->setProduct($p);
  1562.                         $newPBW->setWholesaler($wholesalerRepository->find($wholesalerId));
  1563.                         $em->persist($newPBW);
  1564.                         $em->flush();
  1565.                     }
  1566.                 }
  1567.                 else {
  1568.                     foreach ($pbwsAlreadyAsigned as $pbw) {
  1569.                         $pbw->setUnregistrationdate(null);
  1570.                         $em->persist($pbw);
  1571.                         $em->flush();
  1572.                     }
  1573.                 }
  1574.             }
  1576.             $errorIds = array();
  1577.             foreach ($todisable as $toUnregistrate) { //id's - por cada wholesaler en el selector
  1579.                 $products = $em->createQuery("SELECT p FROM \App\Entity\Product p "               
  1580.                 . 'where p.id = :id ')
  1581.                 ->setParameter('id', $toUnregistrate)
  1582.                 ->getResult();
  1584.                 $pbwsBase = $em->createQuery("SELECT pbw FROM \App\Entity\Productbywholesaler pbw "               
  1585.                 . 'where pbw.wholesaler = :wholesaler and pbw.product = :product')
  1586.                 ->setParameter('wholesaler', $wholesalerId)
  1587.                 ->setParameter('product', $toUnregistrate)        
  1588.                 ->setMaxResults(1)
  1589.                 ->getResult();
  1591.                 $pbwsToUnregistrate = $em->createQuery("SELECT pbw FROM \App\Entity\Productbywholesaler pbw JOIN pbw.product p "               
  1592.                 . 'where pbw.wholesaler = :wholesaler '
  1593.                 . 'and p.id = :id')
  1594.                 ->setParameter('id', $toUnregistrate)
  1595.                 ->setParameter('wholesaler', $wholesalerId)        
  1596.                 ->getResult();
  1598.                 foreach ($pbwsToUnregistrate as $pbw) {
  1599.                     $pbw->setUnregistrationdate(new \DateTime());
  1600.                     $em->persist($pbw);
  1601.                     $em->flush();
  1602.                 }
  1603.             }
  1605.             $products = $em->createQuery("SELECT p FROM \App\Entity\Product p "               
  1606.             . 'where p.groupid = :id and p.unregistrationdate is null')
  1607.             ->setParameter('id', $id)
  1608.             ->getResult();
  1610.             $pbws = $em->createQuery("SELECT pbw FROM \App\Entity\Productbywholesaler pbw JOIN pbw.product p "               
  1611.             . 'where pbw.wholesaler = :wholesaler and p.groupid = :id and pbw.unregistrationdate is null and p.unregistrationdate is null')
  1612.             ->setParameter('wholesaler', $idWholesaler)
  1613.             ->setParameter('id', $id)        
  1614.             ->getResult();
  1616.             $pbwsArray = array();
  1617.             foreach ($pbws as $pbw) {
  1618.                 array_push($pbwsArray, $pbw->getProduct()->getId());
  1619.             }
  1621.             if (!empty($errorIds)) {
  1622.                 $str = implode(", ", $errorIds);
  1623.                 $this->get('session')->getFlashBag()->add('danger', 'Productos no desasignados por estar en Portada: ' . $str);
  1624.             }
  1626.             return $this->redirectToRoute('product_editpbwskusbyprogramm', ['id' => $id, 'idWholesaler' => $idWholesaler]);
  1627.         } 
  1629.         return $this->render('product/editpbwskusbyprogramm.html.twig', [
  1630.             'id' => $id,
  1631.             'wholesalers' => $wholesalers, 
  1632.             'idWholesaler' => $idWholesaler, 
  1633.             'products' => $products,
  1634.             'pbwsArray' => $pbwsArray
  1635.         ]);
  1636.     }
  1637.        
  1638.     
  1639.     /**
  1640.     * 
  1641.     * @Route("/product/default/getprogrammsbywholesaler", name="getprogrammsbywholesaler")
  1642.     */
  1643.     public function getprogrammsbywholesaler(Request $request) {
  1644.         $em = $this->getDoctrine()->getManager();
  1646.         $wholesalerId = $request->get('id');
  1647.         $arrayProgramms = array();
  1648.         $arrayProgramms = $this->getarrayprogrammsbywholesaler($wholesalerId);
  1649.         
  1650.         $response = json_encode($arrayProgramms);
  1651.               
  1652.         return new Response($response, 200, array(
  1653.             'Content-Type' => 'application/json'
  1654.         ));
  1655.    
  1656.     }
  1657.     
  1658.     
  1659.     public function getarrayprogrammsbywholesaler($id) {
  1661.         $em = $this->getDoctrine()->getManager();
  1663.         $arrayProgramms = array();
  1665.         $agreements = $em->createQuery("SELECT a FROM \App\Entity\Agreements a "               
  1666.             . 'where a.wholesaler = :wholesaler ')
  1667.             ->setParameter('wholesaler', $id)
  1668.             ->getResult();
  1669.         foreach ($agreements as $a) {
  1670.             
  1671.             $prog = $em->createQuery("SELECT vp FROM \App\Entity\VendorProgramms vp "               
  1672.             . 'where vp.id = :id ')
  1673.             ->setParameter('id', $a->getProgramm()->getId())                   
  1674.             ->getOneOrNullResult();
  1675.             
  1676.             if (!empty($prog)) {
  1677.                 array_push($arrayProgramms, array("id" => $prog->getId(), "name" => $prog->getName(), "vname" => $prog->getVendor()->getName()));
  1678.             }
  1679.         }
  1681.         return $arrayProgramms;
  1682.     }
  1683.     
  1684.     
  1685.     /**
  1686.     * 
  1687.     * @Route("/product/default/getplsbyprogramm", name="getplsbyprogramm")
  1688.     */
  1689.     public function getplsbyprogramm(Request $request) {
  1690.        
  1691.         $em = $this->getDoctrine()->getManager();
  1693.         $arrayProductLines = array();
  1694.         $programmId = $request->get('id');
  1696.         $arrayProductLines = $this->getarrayplsbyprogramm($programmId);
  1698.         
  1699.         $response = json_encode($arrayProductLines);
  1700.               
  1701.         return new Response($response, 200, array(
  1702.             'Content-Type' => 'application/json'
  1703.         ));
  1704.   
  1705.     }
  1706.     
  1707.     
  1708.     public function getarrayplsbyprogramm($id) {
  1709.         
  1710.         $em = $this->getDoctrine()->getManager();
  1711.         
  1712.         $vendorProgramm = $em->createQuery("SELECT vp FROM \App\Entity\VendorProgramms vp "               
  1713.             . 'where vp.id = :id ')
  1714.             ->setParameter('id', $id)                   
  1715.             ->getOneOrNullResult();
  1716.   
  1717.         $arrayProductLines = array();
  1719.         $productLines = $em->createQuery("SELECT pl FROM \App\Entity\Productline pl "               
  1720.             . 'where pl.vendor = :vendor AND pl.unregistrationdate is null ORDER BY pl.name asc')
  1721.             ->setParameter('vendor', $vendorProgramm->getVendor()->getId())      
  1722.             ->setParameter('vendor', $vendorProgramm->getVendor()->getId())
  1723.             ->getResult();
  1725.         foreach ($productLines as $pl) {
  1726.             array_push($arrayProductLines, array("id" => $pl->getId(), "name" => $pl->getName(), "vname" => $pl->getVendor()->getName()));
  1727.         }
  1729.         return $arrayProductLines;
  1730.     }
  1731.     
  1732.     
  1733.     /**
  1734.     * 
  1735.     * @Route("/product/default/createproduct", name="product_createproduct")
  1736.     */
  1737.     public function createproduct(Request $request) {
  1738.         $dataProduct = array();
  1739.         $session = $this->get('session');
  1740.         $em = $this->getDoctrine()->getManager();  
  1742.         $progsRepository = $this->getDoctrine()->getRepository(\App\Entity\Vendorprogramms::class);
  1743.         $unitsRepository = $this->getDoctrine()->getRepository(\App\Entity\Productunit::class);
  1744.         $payperiodRepository = $this->getDoctrine()->getRepository(\App\Entity\Payperiod::class);
  1745.         $productlineRepository = $this->getDoctrine()->getRepository(\App\Entity\Productline::class);
  1746.         $licensetypeRepository = $this->getDoctrine()->getRepository(\App\Entity\Licensetype::class);
  1747.         
  1748.         $dataProduct['producttype'] = $request->get('producttype');
  1749.         $dataProduct['producttype_name'] = $request->get('producttype_name');
  1750.         $dataProduct['programm'] = $request->get('programm');
  1751.         $dataProduct['line'] = $request->get('line');
  1752.         $dataProduct['licensetype'] = $request->request->get('licensetype', []);
  1753.         $dataProduct['downloadlink'] = $request->get('downloadlink');
  1754.         $dataProduct['consolelink'] = $request->get('consolelink');
  1755.         $dataProduct['fare'] = $request->get('fare');
  1756.         $dataProduct['markup'] = $request->get('markup');
  1757.         $dataProduct['function'] = $request->get('function');
  1758.         $dataProduct['vendorid'] = $request->get('vendorid');
  1759.         $dataProduct['hardware'] = $request->get('hardware');
  1760.        
  1762.         $version = $request->get('version');
  1763.         $flavour = $request->get('flavour');
  1764.         $manintenance = $request->get('maintenance');
  1765.         $renewal = $request->get('renewal');
  1766.         $renewal = $request->get('extrafiels');//revisar utilidad de este bloque
  1767.         $extrafiels = $request->get('extrafiels');
  1768.         $baseprice = $request->get('baseprice');
  1770.         $dataProduct['sku'] = $request->get('sku');
  1771.         $dataProduct['name'] = $request->get('name');
  1772.         $dataProduct['payperiod'] = $request->get('payperiod');
  1773.         $dataProduct['volumemin'] = $request->get('volumemin');
  1774.         $dataProduct['volumemax'] = $request->get('volumemax');
  1775.         $dataProduct['duration'] = $request->get('duration');
  1776.         $dataProduct['unit'] = $request->get('unit');
  1777.         $dataProduct['requiresrenewal'] = $request->get('requiresrenewal');
  1779.         $input_hidden_versions = json_decode($request->get('input_hidden_versions'));
  1780.         $input_hidden_flavours = json_decode($request->get('input_hidden_flavours'));
  1781.         $input_hidden_maintenances = json_decode($request->get('input_hidden_maintenances'));
  1782.         $input_hidden_renewals = json_decode($request->get('input_hidden_renewals'));
  1783.         $input_hidden_extrafields = json_decode($request->get('input_hidden_extrafields'));
  1784.         
  1785.         if ($dataProduct['producttype']) {
  1787.             $arrayGeneralParaRenovaciones = array(); // index => objecto, index => objeto
  1789.             $newproduct = $this->insertProduct($dataProduct, $progsRepository, $productlineRepository, $licensetypeRepository, $unitsRepository, $payperiodRepository, $input_hidden_extrafields, $baseprice);
  1790.             if (!$newproduct) {
  1791.                 $session->getFlashBag()->add('danger', "SKU " . $dataProduct['sku'] . " duplicado.");
  1792.             }
  1793.             else {
  1794.                 $arrayGeneralParaRenovaciones['1'] = $newproduct;
  1795.                 switch ($dataProduct['producttype']) {
  1797.                     case "3":
  1798.                         $maintenances = array();
  1799.                         foreach ($input_hidden_maintenances as $maintenance) {
  1800.                             $newmaintenance = $this->insertMaintenances($dataProduct, $maintenance, $newproduct->getId(), $progsRepository, $productlineRepository, $licensetypeRepository, $unitsRepository, $payperiodRepository);
  1801.                             array_push($maintenances, $newmaintenance->getId());
  1802.                             $arrayGeneralParaRenovaciones[$maintenance->index] = $newmaintenance;
  1803.                         }
  1804.                         $newproduct->setMaintenanceSkuIds($maintenances);
  1805.                         $em->persist($newproduct);
  1806.                         $em->flush();
  1807.                         break;
  1809.                     //<option value="4" >flavoured_list_type</option>
  1810.                     //<option value="5" >flavoured_type</option>                 
  1811.                     //<option value="6" >flavoured_duration</option>
  1812.                     //<option value="10">flavoured_volumelist_duration</option>
  1813.                     //<option value="15">flavoured_duration_volumeinput</option>
  1814.                     //<option value="7" >flavoured_version</option>
  1815.                     //<option value="13">flavoured_version_volume_input</option>
  1816.                     //<option value="24">flavoured_volumeinput_duration_payperiod</option>
  1817.                     case "4":
  1818.                     case "5":
  1819.                     case "6":
  1820.                     case "10":
  1821.                     case "15":
  1822.                     case "7": // version=sabor
  1823.                     case "13": // version=sabor
  1824.                     case "24":
  1825.                     case "26":          
  1827.                         foreach ($input_hidden_flavours as $flavour) {
  1828.                             $newflavour = $this->insertFlavour($dataProduct, $flavour, $newproduct->getId(), $newproduct->getId(), $progsRepository, $productlineRepository, $licensetypeRepository, $unitsRepository, $payperiodRepository);
  1829.                             $arrayGeneralParaRenovaciones[$flavour->index] = $newflavour;
  1830.                         }
  1831.                         $newproduct->setHasFlavours(1);
  1832.                         $em->persist($newproduct);
  1833.                         $em->flush();
  1834.                         break;
  1836.                     //<option value="8" >flavour_list_with_maintenance</option>
  1837.                     //<option value="9" >flavour_with_maintenance</option>
  1838.                     //<option value="12">flavoured_version_maintenance</option>
  1839.                     case "8":
  1840.                     case "9":
  1841.                     case "12": // version=sabor    
  1843.                         $saboresRef = array(); // 2 => newFlavour(4789), 3 => newFlavour(4790)
  1844.                         foreach ($input_hidden_flavours as $flavour) {
  1845.                             $newflavour = $this->insertFlavour($dataProduct, $flavour, $newproduct->getId(), $newproduct->getId(), $progsRepository, $productlineRepository, $licensetypeRepository, $unitsRepository, $payperiodRepository);
  1846.                             $saboresRef[$flavour->index] = $newflavour;
  1847.                             $arrayGeneralParaRenovaciones[$flavour->index] = $newflavour;
  1848.                         }
  1849.                         $newproduct->setHasFlavours(1);
  1850.                         $em->persist($newproduct);
  1851.                         $em->flush();
  1853.                         $maintenancesRefs = array(); // 2 => array(4791, 4792, 4793), 3 => array(4794, 4795, 4796)
  1854.                         foreach ($input_hidden_maintenances as $maintenance) {
  1855.                             $newmaintenance = $this->insertMaintenances($dataProduct, $maintenance, $newproduct->getId(), $progsRepository, $productlineRepository, $licensetypeRepository, $unitsRepository, $payperiodRepository);
  1856.                             if (array_key_exists($maintenance->related, $maintenancesRefs)) {
  1857.                                 array_push($maintenancesRefs[$maintenance->related], $newmaintenance->getId());
  1858.                             }
  1859.                             else {
  1860.                                 $maintenancesRefs[$maintenance->related] = array($newmaintenance->getId());
  1861.                             }
  1862.                             $arrayGeneralParaRenovaciones[$maintenance->index] = $newmaintenance;
  1863.                         }
  1865.                         foreach ($saboresRef as $key => $newFlavour) {
  1866.                             $newFlavour->setMaintenanceSkuIds($maintenancesRefs[$key]);
  1867.                             $em->persist($newFlavour);
  1868.                             $em->flush();
  1869.                         }
  1871.                         break;
  1873.                     //<option value="11" style="background-color: #f59c1a8a;">flavoured_version_with_volume</option>
  1874.                     //<option value="14" style="background-color: #f59c1a8a;">flavoured_version_volumeninput_rango</option>
  1875.                     //<option value="16" style="background-color: #f59c1a8a;">flavoured_version_volumeinput_duration</option>
  1876.                     case "11":
  1877.                     case "14":
  1878.                     case "16":
  1879.                     case "20":
  1880.                     case "21":        
  1881.                     case "25":
  1882.                         $versionsRef = array(); // 2 => newversion(4789), 3 => newversion(4790)
  1883.                         foreach ($input_hidden_versions as $version) {
  1884.                             $newversion = $this->insertVersion($dataProduct, $version, $newproduct->getId(), $progsRepository, $productlineRepository, $licensetypeRepository, $unitsRepository, $payperiodRepository); // insertVersion = I
  1885.                             $versionsRef[$version->index] = $newversion;
  1886.                             $arrayGeneralParaRenovaciones[$version->index] = $newversion;
  1887.                         }
  1888.                         $newproduct->setHasFlavours(1);
  1889.                         $em->persist($newproduct);
  1890.                         $em->flush();
  1892.                         foreach ($input_hidden_flavours as $flavour) {
  1893.                             $newflavour = $this->insertFlavour($dataProduct, $flavour, $newproduct->getId(), $versionsRef[$flavour->related]->getId(), $progsRepository, $productlineRepository, $licensetypeRepository, $unitsRepository, $payperiodRepository);
  1894.                             $saboresRef[$flavour->index] = $newflavour;
  1895.                             $arrayGeneralParaRenovaciones[$flavour->index] = $newflavour;
  1896.                         }
  1897.                         break;
  1898.                     case "22":
  1899.                     case "23":    
  1900.                         
  1901.                         $versionsRef = array(); // 2 => newversion(4789), 3 => newversion(4790)
  1902.                         foreach ($input_hidden_versions as $version) {
  1903.                             $newversion = $this->insertVersion($dataProduct, $version, $newproduct->getId(), $progsRepository, $productlineRepository, $licensetypeRepository, $unitsRepository, $payperiodRepository); // insertVersion = I
  1904.                             $versionsRef[$version->index] = $newversion;
  1905.                             $arrayGeneralParaRenovaciones[$version->index] = $newversion;
  1906.                         }
  1907.                         $newproduct->setHasFlavours(1);
  1908.                         $em->persist($newproduct);
  1909.                         $em->flush();
  1911.                         foreach ($input_hidden_flavours as $flavour) {
  1912.                             $newflavour = $this->insertFlavour($dataProduct, $flavour, $newproduct->getId(), $versionsRef[$flavour->related]->getId(), $progsRepository, $productlineRepository, $licensetypeRepository, $unitsRepository, $payperiodRepository);
  1913.                             $saboresRef[$flavour->index] = $newflavour;
  1914.                             $arrayGeneralParaRenovaciones[$flavour->index] = $newflavour;
  1915.                         }
  1917.                         $maintenancesRefs = array(); // 2 => array(4791, 4792, 4793), 3 => array(4794, 4795, 4796)
  1918.                         foreach ($input_hidden_maintenances as $maintenance) {
  1919.                             $newmaintenance = $this->insertMaintenances($dataProduct, $maintenance, $newproduct->getId(), $progsRepository, $productlineRepository, $licensetypeRepository, $unitsRepository, $payperiodRepository);
  1920.                             if (array_key_exists($maintenance->related, $maintenancesRefs)) {
  1921.                                 array_push($maintenancesRefs[$maintenance->related], $newmaintenance->getId());
  1922.                             }
  1923.                             else {
  1924.                                 $maintenancesRefs[$maintenance->related] = array($newmaintenance->getId());
  1925.                             }
  1926.                             $arrayGeneralParaRenovaciones[$maintenance->index] = $newmaintenance;
  1927.                         }
  1929.                         foreach ($saboresRef as $key => $newFlavour) {
  1930.                             $newFlavour->setMaintenanceSkuIds($maintenancesRefs[$key]);
  1931.                             $em->persist($newFlavour);
  1932.                             $em->flush();
  1933.                         }
  1935.                         break;
  1936.                     default:
  1937.                         break;
  1938.                 }
  1940.                 foreach ($input_hidden_renewals as $renewal) {
  1941.                     $newrenewal = $this->insertRenewal($dataProduct, $renewal, $newproduct->getId(), $progsRepository, $productlineRepository, $licensetypeRepository, $unitsRepository, $payperiodRepository);
  1942.                     $arrayGeneralParaRenovaciones[$renewal->related]->setRenovationProduct($newrenewal);
  1943.                     $em->persist($arrayGeneralParaRenovaciones[$renewal->related]);
  1944.                     $em->flush();
  1945.                 }
  1947.                 $session->getFlashBag()->add('success', 'producto con SKU: "' . $dataProduct['sku'] . '" creado.');
  1948.             }
  1949.         }
  1951.         
  1952.         
  1953.         $q =  $progsRepository->createQueryBuilder('vp');                  
  1954.         $progs=$q->leftJoin('vp.vendor', 'v')
  1955.             ->andWhere('v.unregistrationdate is null')
  1956.             //->andWhere('v.unregistrationdate is null and vp.unregistrationdate is null')
  1957.             ->orderBy('vp.name', 'asc')    
  1958.             ->getQuery()
  1959.             ->getResult();
  1960.         $units = $unitsRepository->findAll();       
  1961.         //$payperiod = $payperiodRepository->findAll();
  1962.         $payperiod = $em->createQuery("SELECT pp FROM \App\Entity\Payperiod pp "               
  1963.             . "where pp.period <> '' ")
  1964.             ->getResult();
  1966.         return $this->render('product/createproduct.html.twig', [
  1967.             'programms' => $progs, 
  1968.             'units' => $units, 
  1969.             'payperiod' => $payperiod
  1970.         ]);
  1971.     }
  1972.     
  1973.     
  1974.     /**
  1975.     * 
  1976.     * @Route("/product/default/checkskus", name="product_checkskus")
  1977.     */
  1978.     public function checkskusAction(Request $request) {
  1979.         
  1980.         $em = $this->getDoctrine()->getManager();
  1981.         
  1982.         $response = new Response();
  1983.        
  1984.         $error = false;
  1985.         $duplicatedSkus = [];
  1986.         $totalSkus = [];
  1987.                 
  1988.         $skusToCheck = json_decode($request->get('skus'));
  1990.         foreach ($skusToCheck as $key => $sku) {
  1991.             $totalSkus[$key] = $sku;
  1992.         }
  1994.         //dubplicados en el formulario
  1995.         $duplicatedSkus = array();
  1996.         foreach (array_count_values($totalSkus) as $val => $c) {
  1997.             if ($c > 1) {
  1998.                 $domId = array_search($val, $totalSkus);
  1999.                 array_push($duplicatedSkus, $domId);
  2000.             }
  2001.         }
  2003.         //dubplicados en BD
  2004.         if (!sizeof($duplicatedSkus) > 0) {
  2005.                                     
  2006.             $duplicateds = $em->createQuery("SELECT p FROM \App\Entity\Product p "               
  2007.             . 'where p.sku IN (:skus) ')
  2008.             ->setParameter('skus', $totalSkus)
  2009.             ->getResult();
  2010.                         
  2011.             foreach ($duplicateds as $product) {
  2012.                 $domId = array_search($product->getSku(), $totalSkus);
  2013.                 array_push($duplicatedSkus, $domId);
  2014.             }
  2015.         }
  2017.         if (sizeof($duplicatedSkus) > 0) {
  2018.             $error = true;
  2019.         }
  2020.         
  2021.         $response = json_encode(array("error" => $error, "duplicated" => $duplicatedSkus));
  2022.               
  2023.         return new Response($response, 200, array(
  2024.             'Content-Type' => 'application/json'
  2025.         ));        
  2026.     }
  2027.     
  2028.     
  2029.     public function insertProduct($productData, $progsRepository, $productlineRepository, $licensetypeRepository, $unitsRepository, $payperiodRepository, $input_hidden_extrafields, $baseprice) {
  2030.         $em = $this->getDoctrine()->getManager();
  2031.         $product = new Product();
  2032.  
  2033.         $typeofproduct = $em->createQuery("SELECT pt FROM \App\Entity\Producttype pt where pt.name = :typename ")->setParameter('typename', $productData['producttype_name'])->getOneOrNullResult();          
  2034.         $product->setProducttype($typeofproduct);     
  2035.         $product->setVendorProgramm($progsRepository->find($productData['programm']));      
  2036.         $product->setProductline($productlineRepository->find($productData['line']));
  2037.         $product->setLicenseType($licensetypeRepository->find($productData['licensetype'][0]));
  2038.         
  2039.         $product->setDownloadLink(empty($productData['downloadlink']) ? null : $productData['downloadlink'] );
  2040.         $product->setConsoleLink(empty($productData['consolelink']) ? null : $productData['consolelink'] );
  2041.         $product->setFare($productData['fare'] == 0 ? 0 : 1);
  2042.         $product->setAcceptsMarkup($productData['markup']);
  2043.         $product->setCanSell($productData['function']);
  2044.         $product->setRequiresRenewal($productData['requiresrenewal']);
  2045.         $product->setCanSellAlone($productData['function']);
  2046.         $product->setProductVendorId($productData['vendorid']);
  2047.         $product->setDescriptiveName($productData['name']);
  2049.         $product->setDescriptiveName($productData['name']);
  2050.         $product->setSku($productData['sku']);
  2051.         $product->setName($productData['name']);
  2053.         $product->setPayperiod($payperiodRepository->find($productData['payperiod']));
  2054.         $product->setVolumeMin($productData['volumemin']);
  2055.         $product->setVolumeMax($productData['volumemax']);
  2056.         $product->setDuration($productData['duration']);
  2057.         $product->setProductUnit($unitsRepository->find($productData['unit']));
  2059.         $product->setIsHardware($productData['hardware']);
  2060.         
  2061.         $extra_fields = json_decode(json_encode($input_hidden_extrafields), true);
  2063.         /*$licenseType=[];
  2064.         foreach($productData['licensetype'] as $lt)
  2065.         {
  2066.             $licenseType[$lt]=$licensetypeRepository->find($lt)->getName(); 
  2067.         }*/
  2069.         $parameters = [
  2070.             'licenseType' => $productData['licensetype'],///$licenseType,
  2071.         ];
  2073.         if (!empty($extra_fields) && is_array($extra_fields)) {
  2074.             $parameters = [
  2075.                 'extrafields' => $extra_fields
  2076.             ];
  2077.         }
  2079.         if($baseprice!=0){
  2080.             $parameters['baseprice']=($baseprice==1 ? 'original' : 'renewable');
  2081.         }
  2083.         $product->setParameters($parameters);
  2084.         $product->setRegistrationdate(new \DateTime());
  2086.         $em->persist($product);
  2087.         $em->flush();
  2088.         try {
  2089.             $product->setGroupId($product->getId());
  2090.             $em->persist($product);
  2091.             $em->flush();
  2092.         }
  2093.         catch (PropelException $pe) {
  2095.             return false;
  2096.         }
  2098.         return $product;
  2099.     }
  2100.     
  2101.     
  2102.     public function insertVersion($productData, $version, $baseId, $progsRepository, $productlineRepository, $licensetypeRepository, $unitsRepository, $payperiodRepository) {
  2103.         $em = $this->getDoctrine()->getManager();
  2104.         $product = new Product();
  2105.         $product->setVendorProgramm($progsRepository->find($productData['programm']));      
  2106.         $product->setProductline($productlineRepository->find($productData['line']));
  2107.         $product->setLicenseType($licensetypeRepository->find($productData['licensetype'][0]));
  2108.         $product->setProductUnit($unitsRepository->find($productData['unit']));       
  2109.         $product->setDownloadLink(empty($productData['downloadlink']) ? null : $productData['downloadlink'] );
  2110.         $product->setConsoleLink(empty($productData['consolelink']) ? null : $productData['consolelink'] );
  2111.         $product->setFare($productData['fare'] == 0 ? 0 : 1);
  2112.         $product->setAcceptsMarkup($productData['markup']);
  2113.         $product->setCanSell($productData['function']);
  2114.         $product->setCanSellAlone($productData['function']);
  2115.         $product->setRequiresRenewal($productData['requiresrenewal']);
  2116.         $product->setDescriptiveName($version->name);
  2118.         $product->setSku($version->sku);
  2119.         $product->setName($version->name);
  2120.         $product->setDescriptiveName($version->name);
  2121.         $product->setPayperiod($payperiodRepository->find($productData['payperiod']));
  2122.         $product->setVolumeMin($productData['volumemin']);
  2123.         $product->setVolumeMax($productData['volumemax']);
  2124.         $product->setDuration($productData['duration']);
  2126.         $product->setRegistrationdate(new \DateTime());
  2127.         $product->setGroupId($baseId);
  2128.         $product->setParentskuids(array($baseId));
  2129.         $product->setIsFlavour(1);
  2130.         $product->setIsHardware($productData['hardware']);
  2131.         $em->persist($product);
  2132.         $em->flush();
  2134.         return $product;
  2135.     }
  2136.     
  2137.     
  2138.     public function insertMaintenances($productData, $manintenance, $baseId, $progsRepository, $productlineRepository, $licensetypeRepository, $unitsRepository, $payperiodRepository) {
  2139.         $em = $this->getDoctrine()->getManager();
  2140.         $product = new Product();
  2141.         $product->setVendorProgramm($progsRepository->find($productData['programm']));      
  2142.         $product->setProductline($productlineRepository->find($productData['line']));
  2143.         $product->setLicenseType($licensetypeRepository->find($productData['licensetype'][0]));
  2144.         $product->setProductUnit($unitsRepository->find($productData['unit']));       
  2145.         $product->setDownloadLink(empty($productData['downloadlink']) ? null : $productData['downloadlink'] );
  2146.         $product->setConsoleLink(empty($productData['consolelink']) ? null : $productData['consolelink'] );
  2147.         $product->setFare($productData['fare'] == 0 ? 0 : 1);
  2148.         $product->setAcceptsMarkup($productData['markup']);
  2149.         $product->setCanSell($productData['function']);
  2150.         $product->setRequiresRenewal($productData['requiresrenewal']);
  2151.         $product->setDescriptiveName($manintenance->name);
  2154.         $product->setSku($manintenance->sku);
  2155.         $product->setName($manintenance->name);
  2156.         $product->setDescriptiveName($manintenance->name);
  2157.         $product->setPayperiod($payperiodRepository->find($manintenance->payperiod));
  2158.         $product->setVolumeMin($manintenance->volumemin);
  2159.         $product->setVolumeMax($manintenance->volumemax);
  2160.         $product->setDuration($manintenance->duration);
  2161.         $product->setProductVendorId($manintenance->vendorid);
  2164.         $product->setRegistrationdate(new \DateTime());
  2165.         $product->setGroupId($baseId);
  2166.         $product->setCanSellAlone(0);
  2167.         $product->setIsHardware($productData['hardware']);
  2168.         $em->persist($product);
  2169.         $em->flush();
  2171.         return $product;
  2172.     }
  2173.     
  2174.     
  2175.     public function insertFlavour($productData, $flavour, $groupId, $linkId, $progsRepository, $productlineRepository, $licensetypeRepository, $unitsRepository, $payperiodRepository) {
  2176.         $em = $this->getDoctrine()->getManager();
  2177.         $product = new Product();
  2178.         
  2179.         $product->setVendorProgramm($progsRepository->find($productData['programm']));      
  2180.         $product->setProductline($productlineRepository->find($productData['line']));
  2181.         $product->setLicenseType($licensetypeRepository->find($productData['licensetype'][0]));
  2182.         $product->setProductUnit($unitsRepository->find($productData['unit']));                     
  2183.         $product->setDownloadLink(empty($productData['downloadlink']) ? null : $productData['downloadlink'] );
  2184.         $product->setConsoleLink(empty($productData['consolelink']) ? null : $productData['consolelink'] );
  2185.         $product->setFare($productData['fare'] == 0 ? 0 : 1);
  2186.         $product->setAcceptsMarkup($productData['markup']);
  2187.         $product->setCanSell($productData['function']);       
  2188.         $product->setCanSellAlone($productData['function']);
  2189.         if($productData['producttype']==26){
  2190.             $product->setCanSellAlone(0);
  2191.             $product->setMaintenanceSkuIds(array($linkId));    
  2192.         }
  2193.         $product->setRequiresRenewal($productData['requiresrenewal']);
  2194.         $product->setProductVendorId($productData['vendorid']);
  2195.                 
  2196.         $product->setDescriptiveName($flavour->name);
  2197.         
  2198.         $product->setSku($flavour->sku);
  2199.         $product->setName($flavour->name);
  2200.         $product->setDescriptiveName($flavour->name);
  2201.         $product->setPayperiod($payperiodRepository->find($flavour->payperiod));
  2202.         $product->setVolumeMin($flavour->volumemin);
  2203.         $product->setVolumeMax($flavour->volumemax);
  2204.         $product->setDuration($flavour->duration);
  2205.         $product->setProductVendorId($flavour->vendorid);
  2208.         $product->setRegistrationdate(new \DateTime());
  2209.         $product->setGroupId($groupId);
  2210.         $product->setParentskuids(array($linkId));
  2211.         $product->setIsFlavour(1);
  2212.         $product->setIsHardware($productData['hardware']);
  2213.         $em->persist($product);
  2214.         $em->flush();
  2216.         return $product;
  2217.     }
  2218.     
  2219.     
  2220.     public function insertRenewal($productData, $renewal, $groupId, $progsRepository, $productlineRepository, $licensetypeRepository, $unitsRepository, $payperiodRepository) {
  2221.         $em = $this->getDoctrine()->getManager();
  2222.         $product = new Product();
  2223.         $product->setVendorProgramm($progsRepository->find($productData['programm']));      
  2224.         $product->setProductline($productlineRepository->find($productData['line']));
  2225.         $product->setLicenseType($licensetypeRepository->find($productData['licensetype'][0]));
  2226.         $product->setProductUnit($unitsRepository->find($productData['unit']));       
  2227.         $product->setDownloadLink(empty($productData['downloadlink']) ? null : $productData['downloadlink'] );
  2228.         $product->setConsoleLink(empty($productData['consolelink']) ? null : $productData['consolelink'] );
  2229.         $product->setFare($productData['fare'] == 0 ? 0 : 1);
  2230.         $product->setAcceptsMarkup($productData['markup']);
  2231.         $product->setCanSell($productData['function']);
  2232.         $product->setRequiresRenewal($productData['requiresrenewal']);
  2233.         $product->setProductVendorId($productData['vendorid']);
  2234.         $product->setDescriptiveName($renewal->name);
  2236.         $product->setSku($renewal->sku);
  2237.         $product->setName($renewal->name);
  2238.         $product->setDescriptiveName($renewal->name);
  2239.         $product->setPayperiod($payperiodRepository->find($renewal->payperiod));
  2240.         $product->setVolumeMin($renewal->volumemin);
  2241.         $product->setVolumeMax($renewal->volumemax);
  2242.         $product->setDuration($renewal->duration);
  2243.         $product->setProductVendorId($renewal->vendorid);
  2245.         $product->setRegistrationdate(new \DateTime());
  2246.         $product->setGroupId($groupId);
  2247.         $product->setCanSellAlone(0);
  2248.         $product->setIsHardware($productData['hardware']);
  2249.         $em->persist($product);
  2250.         $em->flush();
  2252.         return $product;
  2253.     }
  2254.          
  2255. }