src/Controller/ProductsController.php line 60

Open in your IDE?
  1. <?php
  3. /*
  4.  * To change this license header, choose License Headers in Project Properties.
  5.  * To change this template file, choose Tools | Templates
  6.  * and open the template in the editor.
  7.  */
  9. namespace App\Controller;
  11. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  12. use Symfony\Component\HttpFoundation\Session\Session;
  13. use Symfony\Component\DependencyInjection\ParameterBag\ParameterBagInterface;
  14. use Symfony\Component\HttpFoundation\JsonResponse;
  15. use Symfony\Component\HttpFoundation\File\Exception\FileException;
  16. use Symfony\Component\HttpFoundation\File\UploadedFile;
  17. use Symfony\Component\HttpFoundation\Request;
  18. use Symfony\Component\HttpFoundation\Response;
  19. use Knp\Component\Pager\PaginatorInterface;
  20. use App\Entity\Products;
  21. use App\Entity\Attributes;
  22. use App\Form\AttributosType;
  23. use App\Entity\ProductAttributes;
  24. use App\Controller\WCController;
  25. use App\Entity\Categorias;
  26. use App\Entity\Marcas;
  27. use App\Entity\Proveedores;
  28. use App\Form\ProveedoresType;
  29. use App\Entity\Albaranes;
  30. use App\Entity\ProductMarca;
  31. use App\Entity\ProductUploads;
  32. use App\Entity\ProveedorOrder;
  33. use CodeItNow\BarcodeBundle\Utils\BarcodeGenerator;
  34. use Symfony\Component\Serializer\Serializer;
  35. use Symfony\Component\Serializer\Encoder\JsonEncoder;
  36. use Symfony\Component\Serializer\Encoder\XmlEncoder;
  37. use Symfony\Component\Serializer\Normalizer\ObjectNormalizer;
  38. use Symfony\Component\Serializer\Encoder\CsvEncoder;
  39. use App\Form\CategoriasType;
  43. /**
  44.  * Description of ProductsController
  45.  *
  46.  * @author joseangelparra
  47.  */
  48. class ProductsController extends AbstractController {
  50.     private $params;
  51.     private $api;
  53.     public function __construct(ParameterBagInterface $params) {
  55.         $this->session = new Session();
  56.         $this->params = $params;
  57.         $this->api = new WCController();
  58.     }
  60.     public function index(Request $request, PaginatorInterface $paginator) {
  62.         if (!$this->getUser() || !is_object($this->getUser())) {
  63.             return $this->redirectToRoute('logout');
  64.         }
  66.         $em = $this->getDoctrine()->getManager();
  68.         $s = ($request->get("s") ) ? $request->get("s") : "";
  69.         $s_str = "";
  71.         if ($s) {
  72.             $s_str = " AND p.name LIKE '%" . $s . "%' OR p.ean LIKE '%" . $s . "%' OR p.sku LIKE '%" . $s . "%'";
  73.         }
  75.         $orden = ($request->get("orden")) ? $request->get("orden") : 'DESC';
  76.         $filter = ($request->get("filter")) ? $request->get("filter") : 'id';
  78.         $prods = $em->createQueryBuilder()->select("p")
  79.                         ->from("App\Entity\Products", "p")
  80.                         ->where("p.id <> '' and p.status > 0 and p.parent= 0" . $s_str)
  81.                         ->orderBy("p." . $filter, $orden)
  82.                         ->getQuery()->getResult();
  84.         $productos = $paginator->paginate(
  85.                 $prods, $request->query->getInt('page', 1), 20);
  87.         return $this->render('products/list.html.twig', array(
  88.                     'productos' => $productos,
  89.                     's' => $s,
  90.                     'orden' => $orden
  91.         ));
  92.     }
  94.     public function addProduct(Request $request) {
  96.         $page = $request->get("page");
  97.         $em = $this->getDoctrine()->getManager();
  98.         $parent_products = $em->createQueryBuilder()->select('p')
  99.                 ->from("App\Entity\Products", "p")
  100.                 ->where("(p.parent=0 ) and p.status=1")
  101.                 ->orderBy("p.name", "ASC")
  102.                 ->getQuery()
  103.                 ->getResult();
  105.         $attr = $em->getRepository(Attributes::class)->findAll();
  107.         $cats = $em->getRepository(Categorias::class)->findAll();
  108.         $marcas =  $em->createQueryBuilder()->select('p')
  109.                 ->from("App\Entity\Marcas", "p")
  110.                 ->where("p.status=1")
  111.                 ->getQuery()
  112.                 ->getResult();
  113.         
  114.         return $this->render('products/add.html.twig', array(
  115.                     'parents' => $parent_products,
  116.                     'attr' => $attr,
  117.                     'cats' => $cats,
  118.                     'page' => $page,
  119.                     'marcas'=>$marcas
  120.         ));
  121.     }
  123.     public function getAttributesConfig(Request $request) {
  124.         $id = $request->get("id");
  125.         $em = $this->getDoctrine()->getManager();
  127.         $attr = $em->getRepository(Attributes::class)->find($id);
  129.         return $this->render('products/_parts/attrConfig.html.twig', array(
  130.                     'attr' => $attr
  131.         ));
  132.     }
  134.     public function storeProduct(Request $request) {
  135.         
  136.         $page = $request->get("page");
  137.         $em = $this->getDoctrine()->getManager();
  138.         
  139.         $info = $request->request->all();
  140.         //dd($info);
  141.         if (isset($info["id"]) && $info["id"] != "") {
  142.             $product = $em->getRepository(Products::class)->find($info["id"]);
  143.             $prod_image = $product->getImage();
  144.         } else {
  145.             $product = new Products();
  146.             $product->setDateCreated(new \DateTime());
  147.             $prod_image = "";
  148.         }
  150.         //seteamos
  152.         $product->setName($info["name"]);
  153.         $product->setSku($info["sku"]);
  154.         $product->setEan($info["ean"]);
  155.         $product->setDescription($info["description"]);
  156.         $product->setPrice(floatval($info["price"]));
  157.         $product->setIva(floatval($info["iva"]));
  158.         $product->setCostPrice($info["cost_price"]);
  159.         $product->setStoreStock($info["store_stock"]);
  160.         $product->setWpStock($info["wp_stock"]);
  161.         if ($info["discount_from"] != "") {
  162.             $disc_from = \DateTime::createFromFormat('d/m/Y', $info["discount_from"]);
  163.             $product->setDiscountFrom($disc_from);
  164.         } else {
  165.             $product->setDiscountFrom(null);
  166.         }
  167.         if ($info["discount_to"] != "") {
  168.             $disc_to = \DateTime::createFromFormat('d/m/Y', $info["discount_to"]);
  169.             $product->setDiscountTo($disc_to);
  170.         } else {
  171.             $product->setDiscountTo(null);
  172.         }
  173.         $product->setStoreDiscount(($info["store_discount"] != "") ? $info["store_discount"] : 0 );
  174.         $product->setWebDiscount(($info["web_discount"] != "") ? $info["web_discount"] : 0);
  175.         $product->setDateModify(new \DateTime());
  176.         $product->setGlobalStock(floatval($info["store_stock"]) + floatval($info["wp_stock"]));
  177.         $product->setStatus(1);
  178.         $product->setParent((isset($info["parent"]) ? $info["parent"] : 0));
  180.         //imagen
  181.         $image = $request->files->get("image");
  182.         if ($image) { //subimos la imagen
  183.             $originalFilename = pathinfo($image[0]->getClientOriginalName(), PATHINFO_FILENAME);
  184.             $safeFilename = \transliterator_transliterate('Any-Latin; Latin-ASCII; [^A-Za-z0-9_] remove; Lower()', $originalFilename);
  185.             $newFileName = $safeFilename . "-product" . uniqid() . "." . $image[0]->guessExtension();
  186.             try {
  187.                 $image[0]->move(
  188.                         'assets/images/products/',
  189.                         $newFileName
  190.                 );
  191.             } catch (FileException $e) {
  192.                 var_dump($e);
  193.                 die();
  194.             }
  195.             $product->setImage($newFileName);
  196.             if (count($image) > 0) {
  197.                 $gal = [];
  198.                 for ($i = 1; $i < count($image); $i++) {
  199.                     $originalFilename = pathinfo($image[$i]->getClientOriginalName(), PATHINFO_FILENAME);
  200.                     $safeFilename = \transliterator_transliterate('Any-Latin; Latin-ASCII; [^A-Za-z0-9_] remove; Lower()', $originalFilename);
  201.                     $newFileName = $safeFilename . "-product" . uniqid() . "." . $image[$i]->guessExtension();
  202.                     try {
  203.                         $image[$i]->move(
  204.                                 'assets/images/products/',
  205.                                 $newFileName
  206.                         );
  207.                     } catch (FileException $e) {
  208.                         var_dump($e);
  209.                         die();
  210.                     }
  211.                     $gal[] = $newFileName;
  212.                 }
  213.                 $product->setGallery(json_encode($gal));
  214.             }
  215.         } else {
  216.             $product->setImage($prod_image);
  217.         }
  218.         
  219.         //guardamos en local
  220.         $em->persist($product);
  221.         $f = $em->flush();
  222.         if ($f == null) {
  223.             //atributos
  224.             if (isset($info["attr"]) && $info["attr"] != "") {
  225.                 //borramos los atributos actuales
  226.                 $p_attr = $em->getRepository(ProductAttributes::class)->findBy(array("productId" => $product->getId()));
  227.                 foreach ($p_attr as $p_at) {
  228.                     $em->remove($p_at);
  229.                     $em->flush();
  230.                 }
  231.                 foreach ($info["attr"] as $attr_id) {
  232.                     $value = $info["attrib_" . $attr_id . "_value"];
  233.                     $prod_attr = new ProductAttributes();
  234.                     $prod_attr->setAttributeId($attr_id);
  235.                     $prod_attr->setProductId($product->getId());
  236.                     $prod_attr->setValue($value);
  237.                     $em->persist($prod_attr);
  238.                     $em->flush();
  239.                 }
  240.             }
  242.             //categorías
  243.             if (isset($info["categoria"]) && count($info["categoria"])>0) {
  244.                 
  245.                 foreach($categoria as $cat){
  246.                   $prod_cat = new \App\Entity\ProductCats();
  247.                   $prod_cat->setCatId($cat);
  248.                   $prod_cat->setProductId($product->getId());
  249.                   $prod_cat->setDateCreated(new \DateTime());
  250.                 
  251.                   $em->persist($prod_cat);
  252.                   $em->flush();
  253.                 }
  254.             }
  255.             
  256.             //marca
  257.             if(isset($info["marca"]) && $info["marca"] !=""){
  258.                 $marc = new ProductMarca();
  259.                 $marc->setProductId($product->getId());
  260.                 $marc->setMarcaId($info["marca"]);
  261.                 
  262.                 $em->persist($marc);
  263.                 $em->flush();
  264.             }
  266.             //web
  267.             if (isset($info["web"]) && $info["web"] == "on") {
  268.                 //lo enviamos a WP
  269.                 $addedwp = $this->api->addProductToWP($product, $em);
  270.             }
  272.             $type = 1;
  273.             $status = "Producto guardado correctamente";
  274.         } else {
  275.             $type = 0;
  276.             $status = "Error al guardar el producto";
  277.         }
  279.         $this->session->getFlashBag()->add('type', $type);
  280.         $this->session->getFlashBag()->add('status', $status);
  282.         return $this->redirectToRoute('productos', ['page' => $page]);
  283.     }
  285.     public function deleteProduct(Request $request) {
  286.         
  287.         if (!$this->getUser() || !is_object($this->getUser())) {
  288.             return $this->redirectToRoute('logout');
  289.         }
  291.         $em = $this->getDoctrine()->getManager();
  292.         $pid = $request->get("id");
  293.         $page = $request->get("page");
  295.         $prod = $em->getRepository(Products::class)->find($pid);
  296.         if ($prod) {
  297.             $prod->setStatus(0);
  298.             $em->persist($prod);
  299.             $f = $em->flush();
  300.             if ($f == null) {
  301.                 if ($prod->getWpId() != null) {
  302.                     $delete_wp = $this->api->deleteProductToWP($prod, $em);
  303.                 }
  304.                 $type = 1;
  305.                 $status = "Producto eliminado correctamente";
  306.             } else {
  307.                 $type = 0;
  308.                 $status = "Error al eliminar el producto";
  309.             }
  310.         } else {
  311.             $type = 0;
  312.             $status = "Producto no encontrado";
  313.         }
  314.         $this->session->getFlashBag()->add('type', $type);
  315.         $this->session->getFlashBag()->add('status', $status);
  317.         return $this->redirectToRoute('productos', ['page' => $page]);
  318.     }
  320.     public function generateAutoSku() {
  321.         $em = $this->getDoctrine()->getManager();
  323.         $l_prod = $em->createQueryBuilder()->select('p')
  324.                 ->from("App\Entity\Products", "p")
  325.                 ->where("p.id<>''")
  326.                 ->orderBy("p.id", "DESC")
  327.                 ->setMaxResults(1)
  328.                 ->getQuery()
  329.                 ->getResult();
  330.         if ($l_prod) {
  331.             $last_num = $l_prod[0]->getSku();
  332.             $last_num++;
  333.         } else {
  334.             $last_num = date("Y") . "00001";
  335.         }
  336.         return new JsonResponse(array('sku' => $last_num));
  337.     }
  339.     public function editProduct(Request $request) {
  340.         $em = $this->getDoctrine()->getManager();
  341.         $id = $request->get("id");
  342.         $page = $request->get("page");
  344.         $prod = $em->getRepository(Products::class)->find($id);
  346.         $parent_products = $em->createQueryBuilder()->select('p')
  347.                 ->from("App\Entity\Products", "p")
  348.                 ->where("(p.parent=0 ) and p.status=1")
  349.                 ->orderBy("p.name", "ASC")
  350.                 ->getQuery()
  351.                 ->getResult();
  353.         $product_attr = $em->getRepository(ProductAttributes::class)->findBy(array("productId" => $id));
  354.         $atrib = array();
  355.         foreach ($product_attr as $pa) {
  356.             $atrib[] = $pa->getAttributeId();
  357.         }
  358.         $attr = $em->getRepository(Attributes::class)->findAll();
  359.         $cats = $em->getRepository(Categorias::class)->findAll();
  361.         $product_cats = $em->getRepository(\App\Entity\ProductCats::class)->findBy(array("productId" => $id));
  362.         $c_cats = array();
  363.         foreach ($product_cats as $c) {
  364.             $c_cats[] = $c->getCatId();
  365.         }
  366.         
  367.         $marcas = $marcas =  $em->createQueryBuilder()->select('p')
  368.                 ->from("App\Entity\Marcas", "p")
  369.                 ->where("p.status=1")
  370.                 ->getQuery()
  371.                 ->getResult();
  372.                 
  373.         $product_marcas = $em->getRepository(ProductMarca::class)->findBy(array("productId"=>$id));
  374.         $c_marc = array();
  375.         foreach($product_marcas as $m){
  376.           $c_marc[] = $m->getMarcaId();
  377.         }
  378.         
  379.         return $this->render('products/edit.html.twig', array(
  380.                     "prod" => $prod,
  381.                     'parents' => $parent_products,
  382.                     'attr' => $attr,
  383.                     'c_attr' => $product_attr,
  384.                     'atrib' => $atrib,
  385.                     'cats' => $cats,
  386.                     'c_cats' => $c_cats,
  387.                     'page' => $page,
  388.                     'marcas'=>$marcas,
  389.                     'c_marc'=>$c_marc
  390.         ));
  391.     }
  393.     public function updateProduct(Request $request) {
  394.         $em = $this->getDoctrine()->getManager();
  395.         $page = $request->get("page");
  397.         $info = $request->request->all();
  398.         //dd($info);
  399.         if (isset($info["id"]) && $info["id"] != "") {
  400.             $product = $em->getRepository(Products::class)->find($info["id"]);
  401.             $prod_image = $product->getImage();
  402.         } else {
  403.             return false;
  404.         }
  406.         //seteamos
  408.         $product->setName($info["name"]);
  409.         $product->setSku($info["sku"]);
  410.         $product->setEan($info["ean"]);
  411.         $product->setDescription($info["description"]);
  412.         $product->setPrice(floatval($info["price"]));
  413.         $product->setIva(floatval($info["iva"]));
  414.         $product->setCostPrice($info["cost_price"]);
  415.         $product->setStoreStock($info["store_stock"]);
  416.         $product->setWpStock($info["wp_stock"]);
  417.         if ($info["discount_from"] != "") {
  418.             $disc_from = \DateTime::createFromFormat('d/m/Y', $info["discount_from"]);
  419.             $product->setDiscountFrom($disc_from);
  420.         }
  421.         if ($info["discount_to"] != "") {
  422.             $disc_to = \DateTime::createFromFormat('d/m/Y', $info["discount_to"]);
  423.             $product->setDiscountTo($disc_to);
  424.         }
  425.         $product->setStoreDiscount(($info["store_discount"] != "") ? $info["store_discount"] : 0 );
  426.         $product->setWebDiscount(($info["web_discount"] != "") ? $info["web_discount"] : 0);
  427.         $product->setDateModify(new \DateTime());
  428.         $product->setGlobalStock(floatval($info["store_stock"]) + floatval($info["wp_stock"]));
  429.         $product->setParent((isset($info["parent"]) ? $info["parent"] : 0));
  431.         //imagen
  432.         $image = $request->files->get("image");
  433.         if ($image) { //subimos la imagen
  434.             $originalFilename = pathinfo($image[0]->getClientOriginalName(), PATHINFO_FILENAME);
  435.             $safeFilename = \transliterator_transliterate('Any-Latin; Latin-ASCII; [^A-Za-z0-9_] remove; Lower()', $originalFilename);
  436.             $newFileName = $safeFilename . "-product" . uniqid() . "." . $image[0]->guessExtension();
  437.             try {
  438.                 $image[0]->move(
  439.                         'assets/images/products/',
  440.                         $newFileName
  441.                 );
  442.             } catch (FileException $e) {
  443.                 var_dump($e);
  444.                 die();
  445.             }
  447.             $product->setImage($newFileName);
  448.             if (count($image) > 0) {
  449.                 $gal = [];
  450.                 for ($i = 1; $i < count($image); $i++) {
  451.                     $originalFilename = pathinfo($image[$i]->getClientOriginalName(), PATHINFO_FILENAME);
  452.                     $safeFilename = \transliterator_transliterate('Any-Latin; Latin-ASCII; [^A-Za-z0-9_] remove; Lower()', $originalFilename);
  453.                     $newFileName = $safeFilename . "-product" . uniqid() . "." . $image[$i]->guessExtension();
  454.                     try {
  455.                         $image[$i]->move(
  456.                                 'assets/images/products/',
  457.                                 $newFileName
  458.                         );
  459.                     } catch (FileException $e) {
  460.                         var_dump($e);
  461.                         die();
  462.                     }
  463.                     $gal[] = $newFileName;
  464.                 }
  465.                 $product->setGallery(json_encode($gal));
  466.             }
  467.         } else {
  468.             $product->setImage($prod_image);
  469.         }
  472.         //guardamos en local
  474.         $em->persist($product);
  475.         $f = $em->flush();
  476.         if ($f == null) {
  477.             //atributos
  478.             if (isset($info["attr"]) && $info["attr"] != "") {
  479.                 //borramos los atributos actuales
  480.                 $p_attr = $em->getRepository(ProductAttributes::class)->findBy(array("productId" => $product->getId()));
  481.                 foreach ($p_attr as $p_at) {
  482.                     $em->remove($p_at);
  483.                     $em->flush();
  484.                 }
  485.                 foreach ($info["attr"] as $attr_id) {
  486.                     $value = $info["attrib_" . $attr_id . "_value"];
  487.                     $prod_attr = new ProductAttributes();
  488.                     $prod_attr->setAttributeId($attr_id);
  489.                     $prod_attr->setProductId($product->getId());
  490.                     $prod_attr->setValue($value);
  491.                     $em->persist($prod_attr);
  492.                     $em->flush();
  493.                 }
  494.             }
  496.             //categorías
  497.             
  498.             if (isset($info["categoria"]) && count($info["categoria"])>0) {
  499.                 //borramos la actual
  500.                 $p_cats = $em->getRepository(\App\Entity\ProductCats::class)->findBy(array('productId' => $product->getId()));
  501.                 foreach ($p_cats as $pc) {
  502.                     $em->remove($pc);
  503.                     $em->flush();
  504.                 }
  505.                 foreach($categoria as $cat){
  506.                   $prod_cat = new \App\Entity\ProductCats();
  507.                   $prod_cat->setCatId($cat);
  508.                   $prod_cat->setProductId($product->getId());
  509.                   $prod_cat->setDateCreated(new \DateTime());
  510.                 
  511.                   $em->persist($prod_cat);
  512.                   $em->flush();
  513.                 }
  514.                 
  515.             }
  516.             
  517.             if(isset($info["marca"]) && $info["marca"] !=""){
  518.               //borramos la actual
  519.                 $p_cats = $em->getRepository(\App\Entity\ProductMarca::class)->findBy(array('productId' => $product->getId()));
  520.                 foreach ($p_cats as $pc) {
  521.                     $em->remove($pc);
  522.                     $em->flush();
  523.                 }
  524.                 $marc = new ProductMarca();
  525.                 $marc->setProductId($product->getId());
  526.                 $marc->setMarcaId($info["marca"]);
  527.                 
  528.                 $em->persist($marc);
  529.                 $em->flush();
  530.             }
  532.             //web
  533.             if (isset($info["web"]) && $info["web"] == "on") {
  534.                 if ($product->getWpId()) {
  535.                     //update
  536.                     $updatedwp = $this->api->updateProductToWP($product, $em);
  537.                 } else {
  538.                     //create
  539.                     $addedwp = $this->api->addProductToWP($product, $em);
  540.                 }
  541.             } else {
  542.                 if ($product->getWpId()) {
  543.                     $deleteWp = $this->api->deleteProductToWP($product, $em);
  544.                 }
  545.             }
  547.             $type = 1;
  548.             $status = "Producto guardado correctamente";
  549.         } else {
  550.             $type = 0;
  551.             $status = "Error al guardar el producto";
  552.         }
  554.         $this->session->getFlashBag()->add('type', $type);
  555.         $this->session->getFlashBag()->add('status', $status);
  557.         return $this->redirectToRoute('productos', ['page' => $page]);
  558.     }
  560.     public function addProductVariation(Request $request) {
  561.         $em = $this->getDoctrine()->getManager();
  562.         $id = $request->get("id");
  564.         $prod = $em->getRepository(Products::class)->find($id);
  566.         $parent_products = $em->createQueryBuilder()->select('p')
  567.                 ->from("App\Entity\Products", "p")
  568.                 ->where("(p.parent=0 ) and p.status=1")
  569.                 ->orderBy("p.name", "ASC")
  570.                 ->getQuery()
  571.                 ->getResult();
  573.         $product_attr = $em->getRepository(ProductAttributes::class)->findBy(array("productId" => $id));
  574.         $atrib = array();
  575.         foreach ($product_attr as $pa) {
  576.             $atrib[] = $pa->getAttributeId();
  577.         }
  578.         $attr = $em->getRepository(Attributes::class)->findAll();
  579.         $cats = $em->getRepository(Categorias::class)->findAll();
  581.         $product_cats = $em->getRepository(\App\Entity\ProductCats::class)->findBy(array("productId" => $id));
  582.         $c_cats = array();
  583.         foreach ($product_cats as $c) {
  584.             $c_cats[] = $c->getCatId();
  585.         }
  586.         
  587.         $marcas =  $em->createQueryBuilder()->select('p')
  588.                 ->from("App\Entity\Marcas", "p")
  589.                 ->where("p.status=1")
  590.                 ->getQuery()
  591.                 ->getResult();
  592.         $product_marcas = $em->getRepository(\App\Entity\ProductMarca::class)->findBy(array("productId" => $id));
  593.         $c_marc = array();
  594.         foreach($product_marcas as $m){
  595.           $c_marc[] = $m->getMarcaId();
  596.         }
  597.         
  598.         return $this->render('products/addProdVariation.html.twig', array(
  599.                     "prod" => $prod,
  600.                     'parents' => $parent_products,
  601.                     'attr' => $attr,
  602.                     'c_attr' => $product_attr,
  603.                     'atrib' => $atrib,
  604.                     'cats' => $cats,
  605.                     'c_cats' => $c_cats,
  606.                     'marcas'=>$marcas,
  607.                     'c_marc'=>$c_marc
  608.         ));
  609.     }
  611.     public function viewProductVariations(Request $request, PaginatorInterface $paginator) {
  612.         $em = $this->getDoctrine()->getManager();
  613.         $id = $request->get("id");
  615.         $prod_parent = $em->getRepository(Products::class)->find($id);
  617.         $prods = $em->createQueryBuilder()->select("p")
  618.                         ->from("App\Entity\Products", "p")
  619.                         ->where("p.id <> '' and p.status > 0 and p.parent=" . $id)
  620.                         ->getQuery()->getResult();
  621.         $productos = $paginator->paginate(
  622.                 $prods, $request->query->getInt('page', 1), 20);
  624.         return $this->render('products/listVariations.html.twig', array(
  625.                     'productos' => $productos,
  626.                     'prod' => $prod_parent
  627.         ));
  628.     }
  630.     /*
  631.      * Attributes functions
  632.      */
  634.     public function indexAtributes(Request $request, PaginatorInterface $paginator) {
  635.         $em = $this->getDoctrine()->getManager();
  637.         $attr_new = new Attributes();
  639.         $form = $this->createForm(AttributosType::class, $attr_new, ['save_lbl' => "Guardar"]);
  641.         $form->handleRequest($request);
  643.         if ($form->isSubmitted()) {
  644.             $attr_new->setDatecreated(new \DateTime());
  645.             $em->persist($attr_new);
  646.             $f = $em->flush();
  648.             if ($f == null) {
  649.                 $type = 1;
  650.                 $status = "Atributo guardado correctamente";
  651.             } else {
  652.                 $type = 0;
  653.                 $status = "Error al guardar el atributo";
  654.             }
  655.             $this->session->getFlashBag()->add('type', $type);
  656.             $this->session->getFlashBag()->add('status', $status);
  658.             return $this->redirectToRoute('atributos');
  659.         }
  661.         $orden = ($request->get("orden")) ? $request->get("orden") : 'DESC';
  662.         $filter = ($request->get("filter")) ? $request->get("filter") : 'id';
  664.         $attrs = $em->createQueryBuilder()->select("a")
  665.                         ->from("App\Entity\Attributes", "a")
  666.                         ->where("a.id <> ''")
  667.                         ->orderBy("a." . $filter, $orden)
  668.                         ->getQuery()->getResult();
  670.         $atributos = $paginator->paginate(
  671.                 $attrs, $request->query->getInt('page', 1), 20);
  673.         return $this->render('products/attributes/list.html.twig', array(
  674.                     'atributos' => $atributos,
  675.                     'orden' => $orden,
  676.                     'form' => $form->createView()
  677.         ));
  678.     }
  680.     public function addAtributeValues(Request $request) {
  681.         $em = $this->getdoctrine()->getManager();
  682.         $values = $request->request->get("valores");
  683.         $id = $request->request->get('id_attr');
  684.         if ($values != "") {
  685.             $valores = json_encode(explode(",", $values));
  686.             $atr = $em->getRepository(Attributes::class)->find($id);
  688.             $atr->setValue($valores);
  689.             $em->persist($atr);
  690.             $f = $em->flush();
  691.             if ($f == null) {
  692.                 $type = 1;
  693.                 $status = "Atributos guardados correctamente";
  694.             } else {
  695.                 $type = 0;
  696.                 $status = "Error al guardar atributos";
  697.             }
  698.             $this->session->getFlashBag()->add('type', $type);
  699.             $this->session->getFlashBag()->add('status', $status);
  701.             return $this->redirectToRoute('atributos');
  702.         }
  703.     }
  705.     /*
  706.      * Categorias functions
  707.      */
  709.     public function indexCategorias(Request $request, PaginatorInterface $paginator) {
  710.         $em = $this->getDoctrine()->getManager();
  712.         $orden = ($request->get("orden")) ? $request->get("orden") : 'DESC';
  714.         //$cats = $em->getRepository(\App\Entity\Categorias::class)->findAll();
  715.         
  716.         $cats = $em->createQueryBuilder()->select("c")
  717.             ->from("App\Entity\Categorias", "c")
  718.             ->where("c.id <> '' and c.status > 0")
  719.             ->getQuery()->getResult();
  720.         
  721.         $pagination = $paginator->paginate(
  722.                 $cats, $request->query->getInt('page', 1), 20);
  723.                 
  724.         $cat_new = new Categorias();
  725.         $p_cats = $em->getRepository(Categorias::class)->findBy(array('parent'=>0));
  726.         $parents = ["Ninguna"=>0];
  727.         foreach($p_cats as $cat){
  728.             if ($cat->getStatus() != '0')
  729.             $parents[$cat->getNombre()]=$cat->getId();
  730.         }
  731.         
  732.         $form = $this->createForm(CategoriasType::class,$cat_new, [
  733.             'save_lbl'=>"Guardar",
  734.             'parents'=>$parents
  735.         ]);
  736.         
  737.         $form->handleRequest($request);
  738.         
  739.         if($form->isSubmitted()){
  740.             $cat_new->setIdWp('');
  741.             $cat_new->setParentWp('');
  742.             $cat_new->setStatus('1');
  743.             
  744.             $em->persist($cat_new);
  745.             $f = $em->flush();
  746.             if($f == null){
  747.                 $type = 1;
  748.                 $status = "Categoría guardada correctamente";
  749.             }else{
  750.                 $type = 0;
  751.                 $status = "Error al guardar categoría";
  752.             }
  753.             $this->session->getFlashBag()->add('type', $type);
  754.             $this->session->getFlashBag()->add('status', $status);
  756.             return $this->redirectToRoute('categorias');
  757.         }
  758.         
  759.         return $this->render('products/categories/list.html.twig', array(
  760.                     "cats" => $pagination,
  761.                     'orden' => $orden,
  762.                     'form'=>$form->createView()
  763.         ));
  764.     }
  765.     
  766.     public function categoryEditForm(Request $request) {
  767.         
  768.         $em = $this->getDoctrine()->getManager();
  769.         
  770.         $id = $request->request->get('id');
  771.         
  772.         $cat = $em->getRepository(Categorias::class)->findBy(['id' => $id]);
  773.         $cats = $em->createQueryBuilder()->select("c")
  774.             ->from("App\Entity\Categorias", "c")
  775.             ->where("c.id <> '' and c.status > 0")
  776.             ->getQuery()->getResult();
  777.         
  778.         
  779.         
  780.         return $this->render('products/categories/editForm.html.twig', array(
  781.                     "id" => $id,
  782.                     "cat" => $cat[0],
  783.                     "cats" => $cats,
  784.         ));
  785.     }
  786.     
  787.     public function categoryEdit(Request $request) {
  788.         
  789.         //dd($request->request);
  790.         $em = $this->getDoctrine()->getManager();
  791.         $data = $request->request->all();
  792.         
  793.         $cat = $em->getRepository(Categorias::class)->find($data['id']);
  794.         
  795.         if($data && $cat && $data['nombre']){
  796.             
  797.             $cat->setNombre($data['nombre']); 
  798.             $cat->setParent($data['padre']);
  799.             
  800.             $em->persist($cat);
  801.             $f = $em->flush();
  802.             
  803.             if($f == null){
  804.                 $type = 1;
  805.                 $status = "Categoría editada correctamente";
  806.             }else{
  807.                 $type = 0;
  808.                 $status = "Error al editar la categoría";
  809.             } 
  810.         } else {
  811.             $type = 0;
  812.             $status = "Datos incorrectos o no se encontro la categoría";
  813.         }
  814.         $this->session->getFlashBag()->add('type', $type);
  815.         $this->session->getFlashBag()->add('status', $status);
  816.         
  817.         return $this->redirectToRoute('categorias');
  818.     }
  819.     
  820.     public function categoryDelete(Request $request) {
  821.         
  822.         if (!$this->getUser() || !is_object($this->getUser())) {
  823.             return $this->redirectToRoute('logout');
  824.         }
  825.         
  826.         $em = $this->getDoctrine()->getManager();
  827.         $id = $request->query->get('id');
  828.         
  829.         $cat = $em->getRepository(Categorias::class)->find($id);
  830.         
  831.         if($id && $cat){
  832.             $cat->setStatus(0);
  833.             $em->persist($cat);
  834.             $f = $em->flush();
  836.             if($f == null){
  837.                 $type = 1;
  838.                 $status = "Categoría eliminada correctamente";
  839.             }else{
  840.                 $type = 0;
  841.                 $status = "Error al eliminar la categoría";
  842.             }
  843.         } else {
  844.             $type = 0;
  845.             $status = "Datos incorrectos o no se encontro la categoría";
  846.         }
  847.         $this->session->getFlashBag()->add('type', $type);
  848.         $this->session->getFlashBag()->add('status', $status);
  849.         
  850.         return $this->redirectToRoute('categorias');
  851.     }
  853.     public function SyncCatsWP(Request $request) {
  854.         $em = $this->getDoctrine()->getManager();
  855.         $api = new WCController();
  856.         $return = $request->get("return");
  858.         $cats = $api->getProductCats();
  859.         foreach ($cats as $cat) {
  860.             if (!is_object($cat)) {
  861.                 dd($cat);
  862.             }
  863.             $cate = $em->getRepository(Categorias::class)->findOneBy(array('idWp' => $cat->id));
  864.             if (!$cate) {
  865.                 $cate = new Categorias();
  866.             }
  867.             $cate->setIdWp($cat->id);
  868.             $cate->setNombre($cat->name);
  869.             if ($cat->parent == 0) {
  870.                 $cate->setParent($cat->parent);
  871.             } else {
  872.                 $parent_cat = $em->getRepository(Categorias::class)->findOneBy(array('idWp' => $cat->parent));
  873.                 if ($parent_cat) {
  874.                     $cate->setParent($parent_cat->getId());
  875.                 } else {
  876.                     $cate->setParent(0);
  877.                 }
  878.             }
  879.             $cate->setParentWp($cat->parent);
  881.             $em->persist($cate);
  882.             $em->flush();
  883.         }
  884.         if ($return == 1) {
  885.             $this->session->getFlashBag()->add('type', 1);
  886.             $this->session->getFlashBag()->add('status', "Categorías sincronizadas");
  888.             return $this->redirectToRoute('categorias');
  889.         } else {
  890.             dd($cats);
  891.         }
  892.     }
  894.     public function SyncBrandsWP(Request $request) {
  895.         $api = new WCController();
  896.         $brands = $api->getProductBrands();
  897.         dd($brands);
  898.     }
  900.     /*
  901.      * Proveedores functions
  902.      */
  904.     public function proveedoresIndex(Request $request, PaginatorInterface $paginator) {
  905.         if (!$this->getUser() || !is_object($this->getUser())) {
  906.             return $this->redirectToRoute('logout');
  907.         }
  909.         $s = ($request->get("s") ) ? $request->get("s") : "";
  910.         $s_str = "";
  912.         if ($s) {
  913.             $s_str = " AND p.name LIKE '%" . $s . "%' OR p.email LIKE '%" . $s . "%'";
  914.         }
  916.         $orden = ($request->get("orden")) ? $request->get("orden") : 'DESC';
  917.         $filter = ($request->get("filter")) ? $request->get("filter") : 'id';
  919.         $em = $this->getDoctrine()->getManager();
  921.         $proveedores = $em->createQueryBuilder()->select("p")
  922.                 ->from("App\Entity\Proveedores", "p")
  923.                 ->where("p.id <> ''")
  924.                 ->orderBy("p." . $filter, $orden)
  925.                 ->getQuery()
  926.                 ->getResult();
  927.         $provs = $paginator->paginate(
  928.                 $proveedores, $request->query->getInt('page', 1), 20);
  930.         $new_p = new Proveedores();
  931.         $form = $this->createForm(ProveedoresType::class, $new_p, [
  932.             'save_lbl' => "Guardar"
  933.         ]);
  934.         $form->handleRequest($request);
  935.         if ($form->isSubmitted()) {
  936.             $new_p->setDatecreated(new \DateTime());
  937.             $em->persist($new_p);
  938.             $f = $em->flush();
  939.             if ($f == null) {
  940.                 $type = 1;
  941.                 $status = "Proveedor guardado correctamente";
  942.             } else {
  943.                 $type = 0;
  944.                 $status = "Error al guardar el proveedor";
  945.             }
  947.             $this->session->getFlashBag()->add('type', $type);
  948.             $this->session->getFlashBag()->add('status', $status);
  950.             return $this->redirectToRoute('proveedores');
  951.         }
  953.         return $this->render('products/proveedores/index.html.twig', array(
  954.                     "s" => $s,
  955.                     "proveedores" => $provs,
  956.                     'orden' => $orden,
  957.                     'form' => $form->createView()
  958.         ));
  959.     }
  961.     public function deleteProveedor(Request $request) {
  962.         $id = $request->get("id");
  963.         $em = $this->getDoctrine()->getManager();
  965.         $provee = $em->getRepository(Proveedores::class)->find($id);
  966.         if ($provee) {
  967.             $em->remove($provee);
  968.             $f = $em->flush();
  969.             if ($f == null) {
  970.                 $type = 1;
  971.                 $status = "Proveedor eliminado correctamente";
  972.             } else {
  973.                 $type = 0;
  974.                 $status = "Error al eliminar el proveedor";
  975.             }
  977.             $this->session->getFlashBag()->add('type', $type);
  978.             $this->session->getFlashBag()->add('status', $status);
  980.             return $this->redirectToRoute('proveedores');
  981.         }
  982.     }
  984.     public function editProveedor(Request $request) {
  985.         $id = $request->get("id");
  986.         $em = $this->getDoctrine()->getManager();
  988.         $prove = $em->getRepository(Proveedores::class)->find($id);
  989.         $form = $this->createForm(ProveedoresType::class, $prove, [
  990.             'save_lbl' => "Guardar"
  991.         ]);
  993.         $form->handleRequest($request);
  994.         if ($form->isSubmitted()) {
  995.             $em->persist($prove);
  996.             $f = $em->flush();
  997.             if ($f == null) {
  998.                 $type = 1;
  999.                 $status = "Proveedor editado correctamente";
  1000.             } else {
  1001.                 $type = 0;
  1002.                 $status = "Error al editar el proveedor";
  1003.             }
  1005.             $this->session->getFlashBag()->add('type', $type);
  1006.             $this->session->getFlashBag()->add('status', $status);
  1008.             return $this->redirectToRoute('proveedores');
  1009.         }
  1010.         return $this->render('products/proveedores/edit.html.twig', array(
  1011.                     'id' => $id,
  1012.                     'form' => $form->createView()
  1013.         ));
  1014.     }
  1016.     public function proveedorAlbaranes(Request $request, PaginatorInterface $paginator) {
  1017.         if (!$this->getUser() || !is_object($this->getUser())) {
  1018.             return $this->redirectToRoute('logout');
  1019.         }
  1021.         $s = ($request->get("s") ) ? $request->get("s") : "";
  1022.         $s_str = "";
  1024.         if ($s) {
  1025.             $s_str = " AND a.num_albaran LIKE '%" . $s . "%'";
  1026.         }
  1028.         $orden = ($request->get("orden")) ? $request->get("orden") : 'DESC';
  1029.         $filter = ($request->get("filter")) ? $request->get("filter") : 'id';
  1031.         $em = $this->getDoctrine()->getManager();
  1032.         $id = $request->get("id");
  1033.         $proveedor = $em->getRepository(Proveedores::class)->find($id);
  1034.         $albaranes = $em->createQueryBuilder()->select("a")
  1035.                 ->from("App\Entity\Albaranes", "a")
  1036.                 ->where("a.id_provider = " . $id . " " . $s_str)
  1037.                 ->orderBy("a." . $filter, $orden)
  1038.                 ->getQuery()
  1039.                 ->getResult();
  1040.         $provs = $paginator->paginate(
  1041.                 $albaranes, $request->query->getInt('page', 1), 20);
  1042.                 
  1043.         $uploads = $em->createQueryBuilder()->select("p")
  1044.                 ->from("App\Entity\ProductUploads", "p")
  1045.                 ->where("p.proveedorId = " . $id . " " . $s_str)
  1046.                 ->getQuery()
  1047.                 ->getResult();
  1049.         return $this->render('products/proveedores/albaranes.html.twig', array(
  1050.                     'id' => $id,
  1051.                     'albaranes' => $provs,
  1052.                     'proveedor' => $proveedor,
  1053.                     "s" => $s,
  1054.                     'orden' => $orden,
  1055.                     'uploads' => $uploads,
  1056.                         //'form'=>$form->createView()
  1057.         ));
  1058.     }
  1060.     public function addAlbaran(Request $request) {
  1061.         if (!$this->getUser() || !is_object($this->getUser())) {
  1062.             return $this->redirectToRoute('logout');
  1063.         }
  1064.         $em = $this->getDoctrine()->getManager();
  1065.         $id = $request->get("id");
  1066.         $proveedor = $em->getRepository(Proveedores::class)->find($id);
  1068.         return $this->render('products/proveedores/add_albaran.html.twig', array(
  1069.                     'id' => $id,
  1070.                     'proveedor' => $proveedor,
  1071.         ));
  1072.     }
  1074.     public function printLabel(Request $request) {
  1075.         $em = $this->getDoctrine()->getManager();
  1076.         $id = $request->request->get("id");
  1077.         $prod = $em->getRepository(Products::class)->find($id);
  1079.         $barcode = new BarcodeGenerator();
  1080.         $barcode->setText($prod->getSku());
  1081.         $barcode->setType(BarcodeGenerator::Code128);
  1082.         $barcode->setScale(2);
  1083.         $barcode->setThickness(25);
  1084.         $barcode->setFontSize(10);
  1085.         $code = $barcode->generate();
  1087.         return $this->render('products/label.html.twig', array(
  1088.                     'id' => $id,
  1089.                     'prod' => $prod,
  1090.                     'code' => $code
  1091.         ));
  1092.     }
  1094.     public function addNewProductAjax(Request $request) {
  1095.         $em = $this->getDoctrine()->getManager();
  1096.         $data = $request->request->get("form");
  1098.         $prod = new Products();
  1099.         $prod->setCostPrice(0);
  1100.         $prod->setDateCreated(new \DateTime());
  1101.         $prod->setDescription("");
  1102.         $prod->setDateModify(new \DateTime());
  1103.         $prod->setDiscount(0);
  1104.         $prod->setDiscountFrom(null);
  1105.         $prod->setDiscountTo(null);
  1106.         $prod->setEan("");
  1107.         $prod->setGlobalStock($data[3]["value"]);
  1108.         $prod->setImage("");
  1109.         $prod->setName($data[0]["value"]);
  1110.         $prod->setParent(0);
  1111.         $prod->setPrice($data[2]["value"]);
  1112.         $prod->setSku($data[1]["value"]);
  1113.         $prod->setStatus(1);
  1114.         $prod->setStoreDiscount(0);
  1115.         $prod->setStoreStock($data[3]["value"]);
  1116.         $prod->setWebDiscount(0);
  1117.         $prod->setWpId(null);
  1118.         $prod->setWpStock(0);
  1119.         $prod->setIva(21);
  1121.         $em->persist($prod);
  1122.         $f = $em->flush();
  1123.         if ($f == null) {
  1124.             return new JsonResponse(array("ok" => true, "sku" => $prod->getSku()));
  1125.         } else {
  1126.             return new JsonResponse(array("ok" => false));
  1127.         }
  1128.     }
  1130.     public function getAlbaranesLine(Request $request) {
  1131.         $em = $this->getDoctrine()->getManager();
  1132.         $id = $request->request->get("id");
  1133.         $prod = $em->getRepository(Products::class)->find($id);
  1135.         return $this->render('products/proveedores/albaranLineTable.html.twig', array(
  1136.                     'prod' => $prod,
  1137.         ));
  1138.     }
  1140.     public function UpdateAllProductsToWp(Request $request) {
  1142.         $em = $this->getDoctrine()->getManager();
  1144.         $products = $em->createQueryBuilder()->select("p")
  1145.                 ->from(Products::class, "p")
  1146.                 ->where("p.wpId IS NOT NULL AND p.wpId <> '' and p.sku > 3627")
  1147.                 ->getQuery()
  1148.                 ->getResult();
  1149.                 //dd($products);
  1150.             //creem tots els productes
  1151.             foreach ($products as $product) {
  1152.                 $product->setWpId(null);
  1153.                 
  1154.                 $this->api->addProductToWP($product, $em);
  1155.                 //die();
  1156.                 
  1157.             }
  1159.         return new JsonResponse(array("ok" => true));
  1160.     }
  1161.     
  1162.     public function choice(Request $request) {
  1163.         
  1164.         if (!$this->getUser() || !is_object($this->getUser())) {
  1165.             return $this->redirectToRoute('logout');
  1166.         }
  1167.         $em = $this->getDoctrine()->getManager();
  1168.         $id = $request->get("id");
  1169.         $proveedor = $em->getRepository(Proveedores::class)->find($id);
  1170.         
  1171.         return $this->render('products/proveedores/choice.html.twig', array(
  1172.                     'id' => $id,
  1173.                     'proveedor' => $proveedor,
  1174.         ));
  1175.     }
  1176.     
  1177.     public function volcar(Request $request) {
  1178.         
  1179.         if (!$this->getUser() || !is_object($this->getUser())) {
  1180.             return $this->redirectToRoute('logout');
  1181.         }
  1182.         $em = $this->getDoctrine()->getManager();
  1183.         $id = $request->get("id");
  1184.         $proveedor = $em->getRepository(Proveedores::class)->find($id);
  1185.         
  1186.         return $this->render('products/proveedores/volcar.html.twig', array(
  1187.                     'id' => $id,
  1188.                     'proveedor' => $proveedor,
  1189.         ));
  1190.     }
  1191.     
  1192.     public function saveFiles(Request $request): response {
  1193.         
  1194.         if (!$this->getUser() || !is_object($this->getUser())) {
  1195.             return $this->redirectToRoute('logout');
  1196.         }
  1197.         $em = $this->getDoctrine()->getManager();
  1198.         $id = $request->get("proveedor_id");
  1199.         
  1200.         $images = $request->files->get("imgs");
  1201.         $file = $request->files->get("file");
  1202.         
  1203.         // UPLOAD IMAGES
  1204.         $newImagesFileName = NULL;
  1205.         if ($images) {
  1206.             if ($images->guessExtension() == "zip") {
  1207.                 $originalImagesFilename = pathinfo($images->getClientOriginalName(), PATHINFO_FILENAME);
  1208.                 $safeImagesFilename = \transliterator_transliterate('Any-Latin; Latin-ASCII; [^A-Za-z0-9_] remove; Lower()', $originalImagesFilename);
  1209.                 $newImagesFileName = $safeImagesFilename . "-product" . uniqid() . "." . $images->guessExtension();
  1211.                 try {
  1212.                     $images->move(
  1213.                         'assets/images/products/',
  1214.                         $newImagesFileName
  1215.                     );
  1216.                 } catch (FileException $e) {
  1217.                     var_dump($e);
  1218.                     die();
  1219.                 }
  1220.             } else {
  1221.                 $type = 0;
  1222.                 $status = "Formato de imágenes incorrecto. Asegúrese de subir un archivo comprimido .zip";
  1224.                 $this->session->getFlashBag()->add('type', $type);
  1225.                 $this->session->getFlashBag()->add('status', $status);
  1227.                 return $this->redirectToRoute('proveedor_volcar', [ 'id' => $id ]);
  1228.             }
  1229.         }
  1230.         
  1231.         //UPLOAD FILE
  1232.         $extension = "";
  1233.         if ($file != null) { $extension = '.'.$file->getClientOriginalExtension();}
  1234.         if ($file && $extension == ".csv") {
  1235.             
  1236.             $originalFilename = pathinfo($file->getClientOriginalName(), PATHINFO_FILENAME);
  1237.             $safeFilename = \transliterator_transliterate('Any-Latin; Latin-ASCII; [^A-Za-z0-9_] remove; Lower()', $originalFilename);
  1238.             $newFileName = $safeFilename . "-product" . uniqid() . $extension;
  1239.             
  1240.             try {
  1241.                 $file->move(
  1242.                     'assets/files/products/',
  1243.                     $newFileName
  1244.                 );
  1245.             } catch (FileException $e) {
  1246.                 var_dump($e);
  1247.                 die();
  1248.             }
  1249.             
  1250.         } else {
  1251.             
  1252.             $type = 0;
  1253.             $status = "Archivo .csv no seleccionado o formato incorrecto";
  1254.             
  1255.             $this->session->getFlashBag()->add('type', $type);
  1256.             $this->session->getFlashBag()->add('status', $status);
  1257.             
  1258.             return $this->redirectToRoute('proveedor_volcar', [ 'id' => $id ]);
  1259.             
  1260.         } 
  1261.         
  1262.         $productUploads = new ProductUploads();
  1263.         
  1264.         $productUploads->setProveedorId($request->get("proveedor_id"));
  1265.         $productUploads->setFile($newFileName);
  1266.         if ($newImagesFileName != NULL) {
  1267.         $productUploads->setImages($newImagesFileName);
  1268.         } else {
  1269.             $productUploads->setImages("null");
  1270.         }
  1271.         
  1272.         $em->persist($productUploads);
  1273.         $em->flush();
  1274.         
  1275.         $prodUploadsId = $productUploads->getId();
  1276.         
  1277.         return $this->redirectToRoute('proveedor_selectRows', [ 'id' => $prodUploadsId ]);
  1278.     }
  1279.     
  1280.     public function selectRows(Request $request){
  1281.         
  1282.         if (!$this->getUser() || !is_object($this->getUser())) {
  1283.             return $this->redirectToRoute('logout');
  1284.         }
  1285.         
  1286.         $em = $this->getDoctrine()->getManager();
  1287.         $id = $request->get("id");
  1288.         $prodUploads = $em->getRepository(ProductUploads::class)->find($id);
  1289.         $proveedorId = $prodUploads->getProveedorId();
  1290.         $proveedor = $em->getRepository(Proveedores::class)->find($proveedorId);
  1291.         
  1292.         $order = $em->createQueryBuilder()->select("o.rowsOrder")
  1293.                 ->from(ProveedorOrder::class, "o")
  1294.                 ->where("o.proveedorId = '$proveedorId'")
  1295.                 ->orderBy("o.id", "DESC") // Ordena por ID en orden descendente
  1296.                 ->setMaxResults(1)
  1297.                 ->getQuery()
  1298.                 ->getOneOrNullResult();
  1299.         
  1300.         $arrayOrder = (array) null;
  1301.         if ($order) {
  1302.             
  1303.             $arrayOrder = json_decode($order['rowsOrder']);
  1304.           
  1305.         }
  1306.         
  1307.         
  1308.         $file = $prodUploads->getFile();
  1309.         $filePath = 'assets/files/products/' . $file;
  1310.         
  1311.         // CSV Decoder
  1312.         $csvEncoder = new CsvEncoder();
  1313.         $values = $csvEncoder->decode(file_get_contents($filePath), 'csv',[CsvEncoder::DELIMITER_KEY => ';']);
  1314.         //dd(count($values[0]));
  1315.         if (count($values[0]) == 1) {
  1316.             $values = $csvEncoder->decode(file_get_contents($filePath), 'csv',[CsvEncoder::DELIMITER_KEY => ',']);
  1317.         }
  1318.         
  1319.         // Save only array keys (first colum)
  1320.         $columnNames = array_keys($values[0]);
  1321.         
  1322.         return $this->render('products/proveedores/selectRows.html.twig', array(
  1323.             'rows' => $columnNames,
  1324.             'proveedor' => $proveedor,
  1325.             'prod_uploads_id' => $id,
  1326.             'order' => $arrayOrder,
  1327.         ));
  1328.     }
  1329.     
  1330.     public function saveOrder(Request $request) {
  1331.         
  1332.         if (!$this->getUser() || !is_object($this->getUser())) {
  1333.             return $this->redirectToRoute('logout');
  1334.         }
  1335.         
  1336.         $em = $this->getDoctrine()->getManager();
  1337.         $proveedorId = $request->get("proveedor_id");
  1338.         $prodUploadsId = $request->get("prod_uploads_id");
  1339.         $rows = $request->get("product");
  1340.         
  1341.         //Si mantenen el valor per defecte del formulari ho cambia a null
  1342.         for ($i = 0; $i <= 21; $i++) {
  1343.             if ($rows[$i] == "Seleccionar columna") {
  1344.                 $rows[$i] = "null";
  1345.             }
  1346.         }
  1347.         
  1348.         $stringRows = json_encode($rows);
  1349.         
  1350.         $proveedorOrder = new ProveedorOrder();
  1352.         $proveedorOrder->setProveedorId($proveedorId);
  1353.         $proveedorOrder->setRowsOrder($stringRows);
  1354.         $proveedorOrder->setProductUploadId($prodUploadsId);
  1356.         $em->persist($proveedorOrder);
  1357.         $em->flush();
  1358.         
  1359.         //MUNTAR PRODUCTES
  1360.         
  1361.         //CARREGAR EL FILE I IMAGES
  1362.         $prodUploads = $em->getRepository(ProductUploads::class)->find($prodUploadsId);
  1363.         $file = $prodUploads->getFile();
  1364.         $images = $prodUploads->getImages();
  1365.         
  1366.         $filePath = 'assets/files/products/' . $file;
  1367.         $imagePath = 'assets/images/products/' . $images;
  1368.         $savePath = 'assets/images/products/';
  1369.         
  1370.         // CSV Decoder
  1371.         $csvEncoder = new CsvEncoder();
  1372.         $values = $csvEncoder->decode(file_get_contents($filePath), 'csv',[CsvEncoder::DELIMITER_KEY => ';']); //posar el ';'
  1373.         if (count($values[0]) == 1) {
  1374.             $values = $csvEncoder->decode(file_get_contents($filePath), 'csv',[CsvEncoder::DELIMITER_KEY => ',']);
  1375.         }
  1376.         //DESCOMPRIMIR LES IMATGES I BORRAR EL ZIP
  1377.         
  1378.         $zip = new \ZipArchive();
  1379.         if ($zip->open($imagePath) === TRUE) {
  1380.             $zip->extractTo($savePath);
  1381.             $zip->close();
  1382.         }
  1383.         
  1384.         foreach ($values as $key => $value) {
  1385.                 
  1386.             //$orderedValue = array_merge(array_flip($rows), $value);
  1387.             $index = [];
  1388.             foreach ($rows as $clave) {
  1389.                 $index[] = isset($value[$clave]) ? $value[$clave] : null;
  1390.             }
  1392.             $sku = array("sku" => "$index[2]");
  1393.             $product = $em->getRepository(Products::class)->findOneBy($sku);
  1394.             
  1395.             if (isset($index[0]) && $index[0] !== "") {
  1396.                 
  1397.                 if (!isset($product) && $product == "") {
  1398.                     $product = new Products();
  1399.                     $product->setDateCreated(new \DateTime());
  1400.                 }
  1401.                 //convert parent id into int
  1402.                 $parentIdInt = (int)$index[7];
  1404.                 //Setters
  1405.                 $product->setName(($index[0])?$index[0] : '');
  1406.                 $product->setEan(($index[1])?$index[1] : '');
  1407.                 if ($index[2] != null || $index[2] != "") {
  1408.                     $product->setSku($index[2]);
  1409.                 } else {
  1410.                     //Generate sku
  1411.                     $genSkuJson = $this->generateAutoSku();
  1412.                     $content = $genSkuJson->getContent();
  1413.                     $data = json_decode($content, true);
  1415.                     if ($sku["sku"] == null || $sku["sku"] == "") {
  1416.                         $product->setSku($data["sku"]);
  1417.                         } else {
  1418.                             $product->setSku($index[2]);
  1419.                     }
  1420.                 }
  1421.                 $product->setDescription(($index[3])?$index[3] : '');
  1422.                 $product->setPrice(($index[4])?floatval(str_replace(",",".",$index[4])) : 0);
  1423.                 $product->setIva(($index[5])?floatval($index[5]) : 0);
  1424.                 //$product->setDateCreated(new \DateTime());
  1425.                 $product->setParent((isset($parentIdInt) ? $parentIdInt : 0));
  1426.                 //wpId = $index[8]
  1427.                 $images = explode(",",$index[9]);
  1428.                 if($images){
  1429.                     $product->setImage($images[0]);
  1430.                 }
  1431.                 $product->setCostPrice((isset($index[10]) ? floatval($index[10]) : 0));
  1432.                 $product->setDateModify(new \DateTime());
  1433.                 //globalStock = $index[12]
  1434.                 $product->setWpStock((isset($index[13]) ? floatval($index[13]) : 0));
  1435.                 $product->setStoreStock((isset($index[14]) ? floatval($index[14]) : 0));
  1436.                 ////discount = $index[15]
  1437.                 if ($index[16] != "") {
  1438.                     $disc_from = \DateTime::createFromFormat('d/m/Y', $index[16]);
  1439.                     $product->setDiscountFrom($disc_from);
  1440.                 } else {
  1441.                     $product->setDiscountFrom(null);
  1442.                 }
  1443.                 if ($index[17] != "") {
  1444.                     $disc_to = \DateTime::createFromFormat('d/m/Y', $index[17]);
  1445.                     $product->setDiscountTo($disc_to);
  1446.                 } else {
  1447.                     $product->setDiscountTo(null);
  1448.                 }
  1449.                 $product->setStoreDiscount(($index[18] != "") ? $index[18] : 0 );
  1450.                 $product->setWebDiscount(($index[19] != "") ? $index[19] : 0);
  1451.                 //$product->setGlobalStock(floatval($index[14]) + floatval($index[13]));
  1452.                 $product->setGlobalStock((isset($index[14]) ? floatval($index[14]) : 0));
  1453.                 $product->setStatus(1);
  1455.                 $em->persist($product);
  1456.                 $f = $em->flush();
  1457.             }
  1458.         }
  1459.         
  1460.         if ($f == null) {
  1461.             $type = 1;
  1462.             $status = "Albaran subido correctamente";
  1463.         } else {
  1464.             $type = 0;
  1465.             $status = "Error al guardar el Albaran";
  1466.         }
  1468.         $this->session->getFlashBag()->add('type', $type);
  1469.         $this->session->getFlashBag()->add('status', $status);
  1470.         
  1471.         return $this->redirectToRoute('proveedor_albaranes', [ 'id' => $proveedorId ]);
  1472.     }
  1474. }