src/Controller/StockController.php line 106

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\Attribute;
  6. use App\Entity\Cart;
  7. use App\Entity\Category;
  8. use App\Entity\Color;
  9. use App\Entity\Grade;
  10. use App\Entity\Manufacturer;
  11. use App\Entity\Model;
  12. use App\Entity\Option;
  13. use App\Entity\Order;
  14. use App\Entity\Product;
  15. use App\Entity\Shop;
  16. use App\Entity\Stock;
  17. use App\Form\SavType;
  18. use App\Form\SearchType;
  19. use App\Form\StockType;
  20. use App\Repository\CategoryRepository;
  21. use App\Repository\ManufacturerRepository;
  22. use App\Repository\OptionRepository;
  23. use App\Repository\StockRepository;
  24. use App\Service\HistoryService;
  25. use App\Service\ShopService;
  26. use App\Service\UserService;
  27. use DateTime;
  28. use Doctrine\ORM\EntityManagerInterface;
  29. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  30. use Symfony\Component\DependencyInjection\ParameterBag\ParameterBag;
  31. use Symfony\Component\DependencyInjection\ParameterBag\ParameterBagInterface;
  32. use Symfony\Component\HttpFoundation\JsonResponse;
  33. use Symfony\Component\HttpFoundation\Request;
  34. use Symfony\Component\HttpFoundation\RequestStack;
  35. use Symfony\Component\HttpFoundation\Response;
  36. use Symfony\Component\HttpKernel\KernelInterface;
  37. use Symfony\Component\Routing\Annotation\Route;
  38. use Symfony\Component\Translation\TranslatableMessage;
  39. use Symfony\Contracts\Translation\TranslatorInterface;
  41. /**
  42.  * @Route("/{_locale<%app.supported_locales%>}/stock")
  43.  */
  44. class StockController extends AbstractController
  45. {
  47.     private $shop_config;
  48.     private $shop_grades;
  49.     private $shop_selling_grades;
  52.     private $attributes = array(
  53.         '0'=>'size',
  54.         '1'=>'storage',
  55.         '2'=> 'memory',
  56.         '3'=> 'screen_size',
  57.         '4'=> 'screen_resolution',
  58.         '5'=> 'connectivity',
  59.         '6'=> 'connectic',
  60.         '7'=> 'width',
  61.         '8'=> 'height',
  62.         '9'=> 'depth',
  63.         '10'=> 'weight',
  64.         '11'=> 'ID_recognition',
  65.         '12'=> 'battery',
  66.         '13'=> 'front_camera',
  67.         '14'=> 'rear_camera',
  68.         '15'=> 'external_storage',
  69.         '16'=> 'SIM',
  70.         '17'=> 'OS',
  71.         '18'=>'usage',
  72.         '19'=> 'format',
  73.         '20'=> 'screen type',
  74.         '21'=> 'touch',
  75.         '22'=> 'webcam',
  76.         '23'=> 'audio',
  77.         '24'=> 'ratio',
  78.         '25'=> 'connectic 2',
  79.         '26'=> 'network card',
  80.         '27'=> 'graphic card',
  81.         '28'=> 'support',
  82.         '29'=> 'keyboard',
  83.         '30'=> 'numeric pad',
  84.         '31'=> 'processor',
  85.         '32'=> 'speed',
  86.         '33'=> 'generation',
  87.         '34'=> 'size',
  88.         '35'=> 'norme support',
  89.     );
  91.     private $cachedPrices=array();
  93.     private $capacities=[ //percents on price
  94.         32=>0,
  95.         64=>25,
  96.         128=>20,
  97.         256=>15,
  98.         512=>12.5,
  99.         1000=>12.5
  100.     ];
  103.     /**
  104.      * @Route("/", name="app_stock_index", methods={"GET"})
  105.      */
  106.     public function index(Request $request, StockRepository $stockRepository, CategoryRepository $categoryRepository, ManufacturerRepository $manufacturerRepository, UserService $userService, RequestStack $requestStack, ShopService $shopService, ParameterBagInterface $params, TranslatorInterface $translator): Response
  107.     {
  109.         $session = $request->getSession();
  110.         $locale = $request->getLocale();
  113.         // echo $locale;
  114.         $template_sub_file = '_list';
  115.         $request = $requestStack->getCurrentRequest();
  116.         $user = $this->getUser();
  117.         if(!$user->getShop()) {
  118.             $userService->setDefaultShop($user);
  119.         }
  120.         if($shop = $user->getShop()) {
  121.             $vat = $shopService->getSetting($shop, 'vat');
  122.             if($shopService->getSetting($shop, 'view-as-card')) {
  123.                 $template_sub_file='_cards';
  124.             }
  125.             /*
  126.             $settings=$shop->getSettings();
  127.             foreach($settings as $shop_setting) {
  128.                 $setting=$shop_setting->getSetting();
  130.                 if($setting->getMachineName()=='view-as-card' && $shop_setting->getValue()==1) {
  131.                     $template_sub_file='_cards';
  132.                 }
  133.                 //echo $shop_setting->getValue();
  134.             }
  135.             //temp
  136.             if($shop->getId()==9) {
  137.                 $template_sub_file = '_cards';
  138.             }
  139.             */
  140.             /*if($shop->getCountry()=='es') {
  141.                 $vat=21;
  142.             }*/
  143.         }
  150.         $cats = $stockRepository->findCategoriesByShop($shop);
  151.         foreach($cats as $k=>$st) {
  152.             if(preg_match('/pack/i',$st->getModel()->getCategory()->getName())) {
  153.                 $st->getModel()->getCategory()->setName("Pack/Deal");
  154.             }
  155.             //echo $st->getModel()->getCategory()->getName();
  156.             //echo $cat->getId();
  157.         }
  159.         if($shopService->getSetting($shop, 'view-as-card')) {
  160.             $categories=array();
  162.             foreach($cats as $stock) {
  163.                 $label=new TranslatableMessage($stock->getModel()->getCategory()->getName());
  165.                 $categories[$stock->getModel()->getCategory()->getId()]= $label;
  166.             }
  167.             //$categories = array_merge(array_flip(array('MOBILE', 'TABLET', 'LAPTOP','DESKTOP','SCREEN','PACK','ROUTER','TV')), $categories);
  168.             $order=array('1', '2', '3','6','7','12','19','17','13');
  170.             uksort($categories, function($key1, $key2) use ($order) {
  171.                 return (array_search($key1, $order) > array_search($key2, $order));
  172.             });
  174.         }
  178.         $stocks = $stockRepository->findByShop($shop, $request);
  179.         foreach($stocks as $s) {
  180.             $request->getSession()->remove('stock_'.$s->getId());
  181.         }
  182.         $list=$this->list($stocks, $manufacturerRepository);
  184.         $currentCategory=null;
  185.         if($category = $request->query->get('category')) {
  186.             $currentCategory=$categoryRepository->find($category);
  187.         }
  189.         return $this->render('stock/index.html.twig', [
  190.             'template_sub_file'=>$template_sub_file,
  191.             'stocks' => $list['stocks'],
  192.             'manufacturers' => $list['manufacturers'],
  193.             'models' => $list['models'],
  194.             'colors' => $list['colors'],
  195.             'grades' => $list['grades'],
  196.             'categories' => isset($categories)?$categories:$list['categories'],
  197.             'currentCategory' => $currentCategory,
  198.             //'title'=>$translator->trans(ucfirst(strtolower($currentCategory->getName()))),
  199.             'shops' => $list['shops'],
  200.             'cats'=>$cats,
  201.             'vat'=>$vat,
  202.             'config'=>$shop?$shop->getConfig():null
  203.         ]);
  204.     }
  208.     /**
  209.      * @Route("/{id}/card", name="app_stock_card", methods={"POST"})
  210.      */
  211.     public function card(Stock $stock, Request $request, ): Response
  212.     {
  213.         return $this->render('stock/_card.html.twig', [
  214.             'stock'=>$stock,
  215.             'ajax'=>true
  216.             ]);
  217.     }
  221.     public function list($stocks,  ManufacturerRepository $manufacturerRepository):array {
  222.         $manufacturers = array();
  223.         $models = array();
  224.         $colors = array();
  225.         $grades = array();
  226.         $categories = array();
  227.         $shops = array();
  229.         foreach ($stocks as $stock) {
  230.             //$product = $stock->getProduct();
  231.             if (!isset($colors[$stock->getColor()->getId()])) {
  232.                 $colors[$stock->getColor()->getId()] = $stock->getColor()->getName();
  233.             }
  234.             if (!isset($manufacturers[$stock->getModel()->getManufacturer()->getId()])) {
  235.                 $manufacturerId=$stock->getModel()->getManufacturer()->getId();
  236.                 $manufacturerName=$stock->getModel()->getManufacturer()->getName();
  237.                 if($manufacturerName=="GENERIC") {
  238.                     $t=explode(' ',$stock->getModel()->getName());
  239.                     $manufacturerName=$t[0];
  240.                     if($manufacturer=$manufacturerRepository->findOneBy(['name'=>$t[0]])) {
  241.                         $manufacturerId=$manufacturer->getId();
  242.                     }
  244.                 }
  245.                 $manufacturers[$manufacturerId] = $manufacturerName;
  246.             }
  247.             if (!isset($models[$stock->getModel()->getId()])) {
  248.                 $models[$stock->getModel()->getId()] = $stock->getModel()->getName();
  249.             }
  250.             if (!isset($grades[$stock->getGrade()])) {
  251.                 $grades[$stock->getGrade()] = $stock->getGrade();
  252.             }
  254.             if (!isset($categories[$stock->getModel()->getCategory()->getId()])) {
  255.                 $categories[$stock->getModel()->getCategory()->getId()] = $stock->getModel()->getCategory()->getName();
  256.             }
  257.             if (!isset($shops[$stock->getShop()->getId()])) {
  258.                 $shops[$stock->getShop()->getId()] = $stock->getShop()->getName();
  259.             }
  261.             if($stock->getQty()==-1) {
  262.                 //$stock->setQty(1);
  263.             }
  265.         }
  267.         asort($manufacturers);
  268.         asort($models);
  269.         asort($colors);
  270.         asort($grades);
  271.         asort($categories);
  272.         asort($shops);
  274.         return array(
  275.             'stocks' => $stocks,
  276.             'manufacturers' => $manufacturers,
  277.             'models' => $models,
  278.             'colors' => $colors,
  279.             'grades' => $grades,
  280.             'categories' => $categories,
  281.             'shops' => $shops
  282.         );
  283.     }
  285.     /**
  286.      * @Route("/admin", name="app_stock_admin_list", methods={"GET"})
  287.      */
  288.     public function admin(StockRepository $stockRepository, Request $request): Response
  289.     {
  290.         $stocks=$stockRepository->findBy(['shop'=>$request->query->get('shop')]);
  291.         return $this->render('stock/index_admin.html.twig', [
  292.             'stocks' => $stocks,
  293.         ]);
  294.     }
  297.     /**
  298.      * @Route("/{id}", name="app_stock_show", methods={"GET"})
  299.      */
  300.     public function show(Stock $stock): Response
  301.     {
  302.         return $this->render('stock/show.html.twig', [
  303.             'stock' => $stock,
  304.         ]);
  305.     }
  309.     /**
  310.      * @Route("/{id}/edit", name="app_stock_edit", methods={"GET","POST"})
  311.      */
  312.     public function edit(Stock $stock, EntityManagerInterface $entityManager, Request $request,): Response
  313.     {
  315.         $form = $this->createForm(StockType::class, $stock);
  316.         $form->handleRequest($request);
  318.         if ($form->isSubmitted() && $form->isValid()) {
  319.             $entityManager->flush();
  320.         }
  322.         return $this->renderForm('stock/edit.html.twig', [
  323.             'stock' => $stock,
  324.             'form' => $form,
  325.         ]);
  327.     }
  329.     /**
  330.      * @Route("/option", name="app_stock_option_price", methods={"POST","GET"})
  331.      */
  332.     public function optionalPrice(Request $request): Response
  333.     {
  334.         $em = $this->getDoctrine()->getManager();
  335.         $price=0;
  336.         if($stock=$em->getRepository(Stock::class)->find($request->request->get('stock'))) {
  337.             $price=$stock->getPrice();
  338.             if($option=$em->getRepository(Option::class)->find($request->request->get('option'))) {
  340.                 //if($stock->getModel()->getCategory()->hasOption($option)) {
  342.                 if(str_contains($option->getPrice(), '%')) {
  343.                     //percent
  344.                     $price=$stock->getPrice()+(((int)$option->getPrice()*$stock->getPrice())/100);
  345.                     //}
  346.                 }
  347.                 else {
  348.                     $price=$stock->getPrice()+$option->getPrice();
  349.                 }
  350.             }
  351.         }
  353.         return new JsonResponse(array(
  354.             'price'=>$price
  355.         ));
  356.     }
  360.     public function import($em, $bak2_api_url, HistoryService $historyService, $shopId=null)
  361.     {
  362.         $lastUpdate=new DateTime('now');
  364.         $this->em = $em;
  365.         if($shopId) {
  366.             $shops = [$em->getRepository(Shop::class)->find($shopId)];
  367.         } else {
  368.             $shops = $em->getRepository(Shop::class)->findBy(['active'=>1]);
  369.         }
  371.         $destock=$this->getCurrentDestock();
  374.         $em->getRepository(Product::class)->reset();
  376.         foreach ($shops as $shop) {
  377.             //$em->getRepository(Stock::class)->reset($shop);
  378.         }
  381.         foreach ($shops as $shop) {
  382.             $this->cachedPrices=array();
  383.             /*if($shop->getId()==9) { // AFPA pas de màj
  384.                 continue;
  385.             }*/
  386.             $shopHasOption=false;
  387.             $shopHasCategory=false;
  388.             echo "######## ".$shop->getWttName() . " #############\n";
  389.             //$em->getRepository(Stock::class)->reset($shop);
  390.             $stockData = null;
  391.             $this->shop_config = null;
  392.             $this->shop_grades = null;
  393.             $this->shop_selling_grades = null;
  395.             $options=$shop->getOptions();
  396.             if(count($options)>0) {
  397.                 $shopHasOption=true;
  398.             }
  400.             $shopCat=$shop->getCategories();
  401.             $shopCategories=[];
  402.             if(count($shopCat)>0) {
  403.                 $shopHasCategory=true;
  404.                 foreach($shopCat as $k=>$cat) {
  405.                     $shopCategories[$cat->getWttId()]=$cat->getWttId();
  406.                 }
  407.             }
  410.             echo "######## has options: ".$shopHasOption . " #############\n";
  411.             echo "######## has categories: ".$shopHasCategory . " ##".implode(',',$shopCategories)."###########\n";
  413.             $configContent = file_get_contents($bak2_api_url . "/tempStock.php?action=config&channel=" . $shop->getWttName());
  414.             $configData = json_decode($configContent);
  415.             $this->shop_config = reset($configData);
  416.             $vboxIds = $this->shop_config->vbox;
  417.             $shop->setConfig($configData);
  418.             $em->persist($shop);
  419.             $em->flush();
  421.             $allGrades = $em->getRepository(Grade::class)->findAll();
  423.             if (isset($this->shop_config->grades)) {
  424.                 foreach ($this->shop_config->grades as $from => $to) {
  425.                     //echo $from . " / " . $to . "\n";
  426.                     $this->shop_grades[$from] = $this->em->getRepository(Grade::class)->findOneByName($to);
  427.                 }
  428.             } else {
  429.                 $allGrades = $em->getRepository(Grade::class)->findAll();
  430.                 foreach ($allGrades as $grade) {
  431.                     $this->shop_grades[$grade->getName()] = $grade;
  432.                 }
  433.             }
  435.             if (isset($this->shop_config->quality)) {
  436.                 foreach ($this->shop_config->quality as $quality) {
  438.                     $this->shop_selling_grades[$quality->outGrade] = $quality->quality;
  439.                 }
  440.             } else {
  441.                 if (isset($this->shop_config->grades)) {
  442.                     foreach ($this->shop_config->grades as $from => $to) {
  443.                         //echo $from . " / " . $to . "\n";
  444.                         $this->shop_selling_grades[$from] = $to;
  445.                     }
  446.                 } else {
  448.                     foreach ($allGrades as $grade) {
  449.                         $this->shop_selling_grades[$grade->getName()] = $grade->getName();
  450.                     }
  451.                 }
  452.             }
  454.             // var_dump($this->shop_selling_grades);
  455.             if(count($this->shop_selling_grades)==1) {
  456.                 $outGrade  = array_key_first($this->shop_selling_grades);
  457.             }
  460.             $importUrl = $bak2_api_url . "/tempStock.php?action=getProductByTempVbox&vboxes=" . $vboxIds . "&sku_marketplace=".($shop->getId()==5?'b2c':'b2b')."&marketplaceId=" . $shop->getWttId();
  461.             echo $importUrl."\n";
  462.             $importUrl=preg_replace('/ /','',$importUrl);
  463.             $stockContent = file_get_contents($importUrl);
  464.             $stockData = json_decode($stockContent);
  466.             $disableModels=array();
  467.             $existingStock=$em->getRepository(Stock::class)->findBy(array('shop'=>$shop->getId()));
  468.             foreach($existingStock as $stock) {
  469.                 $disableModels[$stock->getModel()->getWttId()]=$stock->getModel();
  470.             }
  471.             foreach ($stockData as $k => $stockProduct) {
  472.                 if(!is_object($stockProduct)) {
  473.                     continue;
  474.                 }
  476.                 if (!isset($stockProduct->colorId) || $stockProduct->colorId == 0) {
  477.                     $stockProduct->colorId = 99;
  478.                     $stockProduct->color = "UNKNOWN";
  479.                 }
  480.                 if (!isset($outGrade) && !isset($this->shop_selling_grades[$stockProduct->outGrade]) && $stockProduct->outGrade!='unknown') {
  481.                     //var_dump($this->shop_selling_grades);
  482.                     //echo " ----->" . $stockProduct->outGrade . " (" . $stockProduct->outGradeId . ") not allowed \n";
  484.                     unset($stockData[$k]);
  485.                 }
  486.             }
  489.             foreach ($stockData as $stockProduct) {
  490.                 if(!is_object($stockProduct)) {
  491.                     continue;
  492.                 }
  493.                 if($shopHasCategory) {
  494.                     if(!in_array($stockProduct->categoryId, $shopCategories)) {
  495.                         continue;
  496.                     }
  497.                 }
  498.                 echo "----" . $stockProduct->model . "-(".$stockProduct->modelId.")---\n";
  499.                 unset($disableModels[$stockProduct->modelId]);
  500.                 if (!$stockProduct->modelId) {
  501.                     echo "No modelId : ".$stockProduct->model." / ".$stockProduct->manufacturer." / ".$stockProduct->color." / ".$stockProduct->outGrade."\n";
  502.                     //var_dump($stockProduct);
  503.                     continue;
  504.                 }
  505.                 if (!$stockProduct->sku) {
  506.                     if($this->shop_config->sourceable==1) {
  507.                         $stockProduct->sku="W-".$stockProduct->modelId."-".$stockProduct->colorId."-".$stockProduct->outGradeId;
  508.                         //$skucontent = file_get_contents($bak2_api_url . "/sku.php?sku=".$sku."&modelId=".$stockProduct->modelId."&outGradeId=".$stockProduct->outGradeId."&colorId=".$stockProduct->colorId."&channel=b2b");
  510.                     }
  511.                     else {
  512.                         echo "No sku : ".$stockProduct->model." / ".$stockProduct->manufacturer." / ".$stockProduct->color." / ".$stockProduct->outGrade."\n";
  513.                         continue;
  514.                     }
  517.                 }
  520.                 if ($stockProduct->colorId == 0) {
  521.                     $stockProduct->colorId = 99;
  522.                     $stockProduct->color = "UNKNOWN";
  523.                 }
  525.                 if(!isset($destock[$stockProduct->sku])) {
  526.                     $destock[$stockProduct->sku]=0;
  527.                 }
  529.                 $stockProduct->nb=$stockProduct->nb-$destock[$stockProduct->sku];
  532.                 if(!isset($outGrade)) {
  533.                     if (!$grade = $em->getRepository(Grade::class)->findOneBy(array('wttId' => $stockProduct->outGradeId))) {
  534.                         $grade = new Grade();
  535.                         $grade->setName($stockProduct->outGrade);
  536.                         $grade->setWttId($stockProduct->outGradeId);
  537.                         $em->persist($grade);
  538.                         $em->flush();
  539.                     }
  540.                 }
  541.                 else {
  542.                     $grade = $em->getRepository(Grade::class)->findOneBy(array('name' => $outGrade));
  543.                 }
  546.                 //echo "Original grade:" . $grade->getName() . "\n";
  547.                 // var_dump($this->shop_grades);
  548.                 if(!isset($this->shop_grades[$grade->getName()])) {
  549.                     echo "Unknown grade: ".$grade->getName()."\n";
  550.                     continue;
  551.                     //var_dump($this->shop_grades);
  552.                 }
  553.                 else {
  554.                     $shopGrade = $this->shop_grades[$grade->getName()];
  555.                 }
  556.                 //echo "Shop grade: " . $shopGrade->getName() . "\n";
  557.                 //echo "Selling grade: " . $this->shop_selling_grades[$shopGrade->getName()] . "\n";
  559.                 //echo $stockProduct->modelId . "\n";
  560.                 //echo $stockProduct->colorId . "\n";
  563.                 if (!$color = $em->getRepository(Color::class)->findOneBy(array('wttId' => $stockProduct->colorId))) {
  564.                     $color = new Color();
  565.                     $color->setName($stockProduct->color);
  566.                     $color->setWttId($stockProduct->colorId);
  567.                     $em->persist($color);
  568.                     $em->flush();
  570.                 }
  571.                 //echo $color->getName() . "\n";
  573.                 if (!$category = $em->getRepository(Category::class)->findOneBy(array('wttId' => $stockProduct->categoryId))) {
  574.                     $category = new Category();
  575.                     $category->setName($stockProduct->categoryName);
  576.                     $category->setWttId($stockProduct->categoryId);
  577.                     $category->setType('Model');
  578.                     $em->persist($category);
  579.                     $em->flush();
  580.                 }
  582.                 if (!$stockProduct->manufacturer) {
  583.                     $stockProduct->manufacturer = "UNKNOWN";
  584.                 }
  585.                 if(!$manufacturer = $em->getRepository(Manufacturer::class)->findOneBy(array('name' => $stockProduct->manufacturer))) {
  586.                     $manufacturer = new Manufacturer();
  587.                     $manufacturer->setName($stockProduct->manufacturer);
  588.                     //$manufacturer->setWttId($stockProduct->manufacturerId);
  589.                     $em->persist($manufacturer);
  590.                     $em->flush();
  591.                 }
  593.                 if (!$model = $em->getRepository(Model::class)->findOneBy(array('wttId' => $stockProduct->modelId))) {
  594.                     // var_dump($stockProduct);
  595.                     $model = new Model();
  596.                     $model->setName($stockProduct->model);
  597.                     $model->setWttId($stockProduct->modelId);
  598.                     $model->setManufacturer($manufacturer);
  599.                     $model->setCategory($category);
  600.                     $em->persist($model);
  601.                     $em->flush();
  602.                 }
  604.                 if (isset($stockProduct->attr_id) && isset($stockProduct->attr_val)) {
  606.                     $tId=explode('|',$stockProduct->attr_id);
  607.                     $tVal=explode('|',$stockProduct->attr_val);
  608.                     $tName=explode('|',$stockProduct->attr_name);
  609.                     foreach($tId as $k=>$v) {
  610.                         $attributeId=(int)$tId[$k];
  612.                         //$attributeName=$tName[$k];
  613.                         $attributeValue=$tVal[$k];
  615.                         if(($model->getCategory()->getId()==1 || $model->getCategory()->getId()==2) && $attributeId==1 && $capacities=explode('/', $attributeValue)) {
  616.                             $attributePrice=0;
  617.                             foreach($capacities as $k2=>$capacity) {
  618.                                 $capacity=(int)$capacity;
  619.                                 if($capacity<4) {
  620.                                     $capacity=1000*$capacity;
  621.                                 }
  623.                                 if($k2==0) {
  624.                                     $attributePrice=0;
  625.                                 }
  628.                                 $capacityName=$capacity<1000?($capacity." GB"):(($capacity/1000)." TB");
  629.                                 if($k2>0) {
  630.                                     $attributePrice=$attributePrice+$this->capacities[$capacity];
  631.                                 }
  633.                                 echo "k2 ".$k2." - attributePrice: ".$attributePrice."\n";
  634.                                 if (!$attribute = $em->getRepository(Attribute::class)->findOneBy(array('model' => $model->getId(),'wttId'=>$attributeId,'name'=>$this->attributes[$attributeId],'value'=>$capacityName))) {
  636.                                     $attribute=new Attribute();
  637.                                     $attribute->setModel($model);
  638.                                     $attribute->setName($this->attributes[$attributeId]);
  639.                                     $attribute->setWttId($attributeId);
  640.                                     $attribute->setValue($capacityName);
  642.                                     //$attribute->setPrice($attributePrice);
  643.                                     $em->persist($attribute);
  644.                                 }
  645.                                 $attribute->setPrice($attributePrice);
  646.                                 $em->persist($attribute);
  647.                             }
  648.                             //die();
  649.                         }
  650.                         else {
  651.                             if($attributeValue!='' && $attributeId>0) {
  652.                                 if (!$attribute = $em->getRepository(Attribute::class)->findOneBy(array('model' => $model->getId(),'wttId'=>$attributeId))) {
  653.                                     $attribute=new Attribute();
  654.                                     $attribute->setModel($model);
  655.                                     //$attribute->setName($this->attributes[$attributeId]);
  656.                                     $attribute->setWttId($attributeId);
  657.                                     //$attribute->setValue($attributeValue);
  658.                                     $em->persist($attribute);
  659.                                 }
  662.                                 $attribute->setName($this->attributes[$attributeId]);
  663.                                 $attribute->setValue($attributeValue);
  664.                                 $em->persist($attribute);
  665.                             }
  666.                         }
  669.                     }
  670.                 }
  672.                 if(isset($stockProduct->pict) ) {
  673.                     echo $stockProduct->pict."\n";
  674.                     if(!$model->getImage() || str_contains($model->getImage(), 'http')) {
  675.                         echo "update pict\n";
  676.                         $model->setImage("http://pict.bak2group.com/models/".$stockProduct->pict);
  677.                         $em->persist($model);
  678.                         $em->flush();
  679.                     }
  681.                 }
  682.                 /*
  683.                 $model->setCategory($category);
  684.                 $em->persist($model);
  685.                 $em->flush();
  686.                 */
  687.                 //echo $model->getName() . "\n";
  689.                 $productGrade = $grade->getName();
  690.                 //echo $category->getName()."\n";
  691.                 if (!$product = $em->getRepository(Product::class)->findOneBy(array('model' => $model, 'color' => $color, 'grade' => $grade, 'sku' => $stockProduct->sku))) {
  693.                     $product = new Product();
  694.                     $product->setColor($color);
  695.                     $product->setModel($model);
  696.                     $product->setGrade($grade);
  697.                     $product->setSku($stockProduct->sku);
  698.                     $product->setQty($stockProduct->nb);
  699.                     $product->setName($manufacturer->getName() . " " . $model->getName() . " " . $color->getName() . " " . $grade->getName());
  700.                     $product->setPrice($stockProduct->$productGrade);
  701.                     $product->setChannel($shop->getChannel());
  702.                     $em->persist($product);
  703.                     $em->flush();
  704.                 }
  705.                 $product->setChannel($shop->getChannel());
  706.                 //$product->setCategory($category);
  707.                 if($product->getQty()<=0) {
  708.                     $product->setQty($stockProduct->nb);
  710.                     $product->setPrice($stockProduct->$productGrade);
  711.                     //$product->setName($manufacturer->getName()." ".$model->getName()." ".$color->getName()." ".$grade->getName());
  712.                     $em->persist($product);
  713.                     $em->flush();
  715.                     echo "updating ".$product->getName()."\n";
  716.                 }
  718.                 if($product->getSku()=='n.a.') {
  720.                     $product->setSku($stockProduct->sku);
  721.                     $em->persist($product);
  722.                     $em->flush();
  723.                 }
  726.                 // echo $product->getName() . "\n";
  728.                 if(!isset($this->shop_selling_grades[$grade->getName()])) {
  729.                     continue;
  730.                 }
  731.                 if (!$stock = $em->getRepository(Stock::class)->findOneBy(array('shop' => $shop, 'model' => $model, 'color' => $color, 'grade' => $this->shop_selling_grades[$grade->getName()]))) {
  732.                     $stock = new Stock();
  733.                     //echo "sku:" . $stockProduct->sku . "\n";
  734.                     $stock->setModel($model);
  735.                     $stock->setGrade($this->shop_selling_grades[$grade->getName()]);
  736.                     $stock->setColor($color);
  737.                     $stock->setShop($shop);
  738.                     $stock->setQty(0);
  739.                     $stock->setSourceGrade($stockProduct->outGrade);
  740.                     $em->persist($stock);
  741.                     echo "-------------> create model: " . $stockProduct->modelId . "  -- Shop grade: " . $shopGrade->getName() . " -- Color: " . $stockProduct->colorId . " (" . $stockProduct->outGrade . ")\n";
  743.                 }
  744.                 $overridenPrice=$stock->getPrice();
  746.                 echo "shop:".$shop->getName()." model: " . $stockProduct->modelId . "  -- Shop grade: " . $shopGrade->getName() . " -- Color: " . $stockProduct->colorId . " (" . $stockProduct->outGrade . ")\n";
  747.                 echo "qty 1: ".$stock->getQty()."\n";
  749.                 if($stock->getQty()<2) {
  750.                     $stock->setQty(0);
  751.                 }
  752.                 $shopGrade = $shopGrade->getName();
  753.                 $price = $this->getPriceNet($stockProduct->$shopGrade / 100, $shop, $bak2_api_url);
  755.                 $sourceGrade=explode(',',$stock->getSourceGrade());
  756.                 $sourceGrade[]=$stockProduct->outGrade;
  757.                 $stock->setSourceGrade(implode(',',array_filter(array_unique($sourceGrade))));
  758.                 $stock->setPrice((int)$price * 100);
  759.                 $stock->setEnabled(true);
  761.                 //$stock->setQty($stock->getQty() + $stockProduct->nb);
  762.                 $stock->setQty($stockProduct->nb);
  765.                 echo "qty: ".$stock->getQty()."\n";
  768.                 //options
  769.                 echo "Options \n";
  770.                 if($shopHasOption) {
  772.                     foreach($stock->getOptions() as $option) {
  773.                         $stock->removeOption($option);
  774.                     }
  776.                      if(count($options)>0) {
  777.                          echo "Has options \n";
  778.                             $modelAttributes=$stock->getModel()->getAttributes();
  779.                             $t=array();
  780.                             foreach($modelAttributes as $attribute) {
  781.                                 if($attribute->getName()=='storage' || $attribute->getName()=='memory') {
  782.                                     $t[$attribute->getName()]=(int)$attribute->getValue();
  783.                                 }
  785.                             }
  786.                             $modelAttributes=$t;
  788.                             foreach($shop->getOptions() as $option) {
  789.                                // if($option->getCategory()->getId()==$stock->getModel()->getCategory()->getId()) {
  791.                                 if($optionAttribute = $option->getAttribute()) {
  792.                                     if(isset($modelAttributes[$option->getAttribute()->getName()])) {
  793.                                         if((int)$modelAttributes[$option->getAttribute()->getName()]==(int)$option->getAttributeValue()) {
  794.                                             if($option->getCategory()->getId()==$stock->getModel()->getCategory()->getId()) {
  795.                                                 $stock->addOption($option);
  796.                                             }
  797.                                         }
  798.                                     }
  800.                                 }
  801.                                 else {
  802.                                     if($option->getCategory()) {
  803.                                         if($option->getCategory()->getId()==$stock->getModel()->getCategory()->getId()) {
  804.                                             $stock->addOption($option);
  805.                                         }
  806.                                     }
  808.                                 }
  809.                             }
  811.                             //die();
  812.                         }
  815.                 }
  816.                 else {
  817.                     foreach($stock->getOptions() as $option) {
  818.                         $stock->removeOption($option);
  819.                     }
  820.                 }
  821.                 $stock->setUpdated($lastUpdate);
  823.                 if($stock->isOverride()) {
  824.                     $stock->setPrice($overridenPrice);
  825.                     echo "### stock overriden, continue\n";
  826.                     //die();
  827.                     continue;
  828.                 }
  829.                 $em->persist($stock);
  830.                 echo "Stock saved\n";
  831.                 if($stock->getId()) {
  832.                     if(!$historyService->getHistory('stock', $stock->getId(),'status','created')) {
  833.                         $historyService->setHistory('stock',$stock->getId(),'status','created');
  834.                         $historyService->setHistory('stock',$stock->getId(), 'status', 'updated');
  835.                         $historyService->setHistory('stock',$stock->getId(), 'price',  $stock->getPrice());
  836.                         // $historyService->setHistory('stock',$stock->getId(),'updated');
  837.                     }
  838.                     if($historyService->getHistory('stock', $stock->getId(),'price')!=$stock->getPrice()) {
  839.                         $historyService->setHistory('stock',$stock->getId(), 'price',  $stock->getPrice());
  840.                         $historyService->setHistory('stock',$stock->getId(), 'status', 'updated');
  841.                     }
  842.                     echo "History done\n";
  843.                 }
  846.             }
  847.             foreach($disableModels as $k=>$model) {
  848.                 $existingStock=$em->getRepository(Stock::class)->findBy(array('shop'=>$shop->getId(),'model'=>$model));
  849.                 $stock=$existingStock[0];
  850.                 $stock->setEnabled(false);
  851.                 echo "remove ".$model."\n";
  852.                 $stock->setQty(0);
  854.             }
  855.             // var_dump($disableModels);
  856.             $em->flush();
  857.         }
  858.         //var_dump($this->cachedPrices);
  859.         return new Response('ok');
  860.     }
  862.     public function getPriceNet($price, $shop, $bak2_api_url)
  863.     {
  864.         if($price<=0) {
  865.             return 0;
  866.         }
  867.         echo "price: ".$price. " / MP: ".$shop->getWttId()."\n";
  870.         //$url=https://share.ddev.site:8443/routine/report/api/tempStock.php?action=getBestPrice&marketplaceId=17&price=".$price;
  871.         if(!isset($this->cachedPrices[$price])) {
  872.             echo "----prices doesn't exist\n";
  873.             $importUrl = $bak2_api_url . "/tempStock.php?action=getBestPrice&marketplaceId=" . $shop->getWttId()."&price=".$price;
  874.             echo $importUrl."\n";
  875.             $importUrl=preg_replace('/ /','',$importUrl);
  876.             $stockContent = file_get_contents($importUrl);
  877.             $stockData = json_decode($stockContent);
  878.             echo "new price ".$stockData->bsp."\n";
  879.             $this->cachedPrices[$price]=$stockData->bsp;
  881.         }
  882.         else {
  883.             echo "----ok prices cached\n";
  884.         }
  886.         return $this->cachedPrices[$price];
  887.         /*
  888.         if($price<=0) {
  889.             return 0;
  890.         }
  891.         $internalCost = (float)$this->shop_config->internalCost;
  892.         $labor = (float)$this->shop_config->laborCost;
  893.         $logistic = (float)$this->shop_config->logisticCost;
  894.         $accessory = (float)$this->shop_config->accessoryCost;
  895.         $warranty_percentage = (float)$this->shop_config->warranty_perentage;
  896.         $warranty_fixe = (float)$this->shop_config->warranty_fixe;
  897.         $commision_percentage = (float)$this->shop_config->commision_perentage;
  898.         $margin_other_percentage = (float)$this->shop_config->margin_other_percentage;
  899.         $margin_tablet_percentage = (float)$this->shop_config->margin_tablet_percentage;
  901.         $tva = (100 + (float)$this->shop_config->tva_percentage) / 100;
  902.         echo "price:" . $price . "\n";
  903.         $bbNet1 = $price / $tva;
  904.         echo "bbNet1: " . $bbNet1 . "\n";
  905.         $bbNet2 = $bbNet1 - ($commision_percentage / 100 * $price);
  906.         echo "bbNet2:" . $bbNet2 . "\n";
  907.         $bbNet3 = $bbNet2 - ($warranty_percentage / 100 * $bbNet2) - $warranty_fixe;
  908.         echo "bbNet3:" . $bbNet3 . "\n";
  909.         $bbNet = $bbNet3 - ($internalCost + $labor + $logistic + $accessory);
  910.         echo $bbNet."\n";
  911.         echo $internalCost ." + ".$labor ." + ". $logistic ." + ". $accessory."\n";
  912.         //Version Nico
  913.         //$pp = ($warranty_perentage/100) + ($commision_perentage/100);
  914.         //$bbNet = (($price-($tva*$warranty_fixe))/($tva*(1+$pp))) - $labor - $logistic - $accessory;
  917.         $bsp1 = $price + $labor + $logistic + $accessory ;
  918.         if($category->getId()==2) {
  919.             //    $bsp1=$bsp1+ $margin_tablet_percentage;
  920.         }
  921.         else {
  922.             //    $bsp1=$bsp1+ $margin_other_percentage;
  923.         }
  924.         echo "bsp1:" . $bsp1 . "\n";
  925.         $bsp2 = $bsp1 + ($warranty_percentage / 100 * $bsp1) + $warranty_fixe;
  926.         echo "bsp2:" . $bsp2 . "\n";
  927.         $bsp = ($bsp2 + ($commision_percentage / 100 * $bsp2)) * $tva;
  928.         echo "bsp:" . $bsp . "\n";
  929.         return $bsp;
  930.         */
  931.     }
  933.     private function getResalePrice($price)
  934.     {
  935.         if($price<=0) {
  936.             return 0;
  937.         }
  938.         if ($price > 300) {
  939.             $resalePrice = $price + 15;
  940.         } elseif ($price > 100) {
  941.             $resalePrice = $price + 10;
  942.         } elseif ($price > 50) {
  943.             $resalePrice = $price + 5;
  944.         } else {
  945.             $resalePrice = floor($price * 1.08);
  946.         }
  948.         return $resalePrice;
  949.     }
  951.     function getMinPrice($price, $grade)
  952.     {
  953.         if ($price > 0) {
  954.             if ($price < 5 && $grade == 'C') {
  955.                 $price = 5;
  956.             } elseif ($price < 4 && $grade == 'E') {
  957.                 $price = 4;
  958.             } elseif ($price < 3) {
  959.                 $price = 3;
  960.             }
  961.         }
  963.         return $price;
  964.     }
  966.     private function getCurrentDestock() {
  967.         $destock=array();
  968.         $em=$this->em;
  969.         if($orders= $em->getRepository(Order::class)->findBy(array('status'=>10))) {
  970.             $gradeRepository=$em->getRepository(Grade::class);
  971.             $productRepository=$em->getRepository(Product::class);
  972.             $cartRepository=$em->getRepository(Cart::class);
  973.             foreach($orders as $order) {
  974.                 foreach($order->getCarts() as $cart) {
  975.                     $stock=$cart->getStock();
  976.                     $sourceGrades = $stock->getSourceGrade();
  977.                     foreach (explode(',', $sourceGrades) as $sourceGrade) {
  978.                         if ($grade = $gradeRepository->findOneByName($sourceGrade)) {
  979.                             if ($product = $productRepository->findOneBy(array('grade' => $grade, 'model' => $stock->getModel(), 'color' => $stock->getColor()))) {
  980.                                 if(!isset($destock[$product->getSku()])) {
  981.                                     $destock[$product->getSku()]=0;
  982.                                 }
  983.                                 $destock[$product->getSku()] = $destock[$product->getSku()]+$cart->getQty();
  984.                                 break;
  985.                             }
  986.                         }
  987.                     }
  988.                 }
  990.             }
  991.         }
  992.         return $destock;
  993.     }
  996.     public function searchForm() {
  997.         $form =   $this->createForm(SearchType::class);
  998.         return $this->render('stock/search.html.twig', [
  999.             'form' => $form->createView()
  1000.         ]);
  1001.     }
  1003.     public function getHeader(ParameterBagInterface $params) {
  1004.         $user=$this->getUser();
  1005.         $template_sub_file="stock/header.html.twig";
  1006.         if(file_exists($params->get('kernel.project_dir')."/private/shops/".$user->getShop()->getId()."/templates/stock/header.html.twig")) {
  1007.             $template_sub_file="shops/".$user->getShop()->getId()."/templates/stock/header.html.twig";
  1008.         }
  1009.         return $this->render($template_sub_file);
  1010.     }
  1012.     public function getFooter(ParameterBagInterface $params) {
  1013.         $user=$this->getUser();
  1014.         $template_sub_file="stock/footer.html.twig";
  1015.         if(file_exists($params->get('kernel.project_dir')."/private/shops/".$user->getShop()->getId()."/templates/stock/footer.html.twig")) {
  1016.             $template_sub_file="shops/".$user->getShop()->getId()."/templates/stock/footer.html.twig";
  1017.         }
  1019.         return $this->render($template_sub_file);
  1020.     }
  1022. }