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\HttpFoundation\StreamedResponse;
  14. use Symfony\Component\DependencyInjection\ParameterBag\ParameterBagInterface;
  15. use Symfony\Component\HttpFoundation\JsonResponse;
  16. use Symfony\Component\HttpFoundation\File\Exception\FileException;
  17. use Symfony\Component\HttpFoundation\File\UploadedFile;
  18. use Symfony\Component\HttpFoundation\Request;
  19. use Symfony\Component\HttpFoundation\Response;
  20. use Knp\Component\Pager\PaginatorInterface;
  21. use App\Entity\Products;
  22. use App\Entity\Attributes;
  23. use App\Form\AttributosType;
  24. use App\Entity\ProductAttributes;
  25. use App\Controller\WCController;
  26. use App\Entity\Categorias;
  27. use App\Entity\Marcas;
  28. use App\Entity\Proveedores;
  29. use App\Form\ProveedoresType;
  30. use App\Entity\Albaranes;
  31. use App\Entity\ProductMarca;
  32. use App\Entity\ProductUploads;
  33. use App\Entity\ProveedorOrder;
  34. use CodeItNow\BarcodeBundle\Utils\BarcodeGenerator;
  35. use Symfony\Component\Serializer\Serializer;
  36. use Symfony\Component\Serializer\Encoder\JsonEncoder;
  37. use Symfony\Component\Serializer\Encoder\XmlEncoder;
  38. use Symfony\Component\Serializer\Normalizer\ObjectNormalizer;
  39. use Symfony\Component\Serializer\Encoder\CsvEncoder;
  40. use App\Form\CategoriasType;
  44. /**
  45.  * Description of ProductsController
  46.  *
  47.  * @author joseangelparra
  48.  */
  49. class ProductsController extends AbstractController {
  51.     private $params;
  52.     private $api;
  54.     public function __construct(ParameterBagInterface $params) {
  56.         $this->session = new Session();
  57.         $this->params = $params;
  58.         $this->api = new WCController();
  59.     }
  61.     public function index(Request $request, PaginatorInterface $paginator) {
  63.         if (!$this->getUser() || !is_object($this->getUser())) {
  64.             return $this->redirectToRoute('logout');
  65.         }
  67.         $em = $this->getDoctrine()->getManager();
  69.         $s = ($request->get("s") ) ? $request->get("s") : "";
  70.         $s_str = "";
  72.         if ($s) {
  73.             $s_str = " AND p.name LIKE '%" . $s . "%' OR p.ean LIKE '%" . $s . "%' OR p.sku LIKE '%" . $s . "%'";
  74.         }
  76.         $orden = ($request->get("orden")) ? $request->get("orden") : 'DESC';
  77.         $filter = ($request->get("filter")) ? $request->get("filter") : 'id';
  79.         $prods = $em->createQueryBuilder()->select("p")
  80.                         ->from("App\Entity\Products", "p")
  81.                         ->where("p.id <> '' and p.status > 0 and p.parent= 0" . $s_str)
  82.                         ->orderBy("p." . $filter, $orden)
  83.                         ->getQuery()->getResult();
  85.         $productos = $paginator->paginate(
  86.                 $prods, ($request->query->getInt('page')>0) ? $request->query->getInt('page', 1) : 1, 20);
  87.         
  88.         /*$productos = $paginator->paginate(
  89.                 $prods, $request->query->getInt('page', 1), 20);
  90. */
  91.         return $this->render('products/list.html.twig', array(
  92.                     'productos' => $productos,
  93.                     's' => $s,
  94.                     'orden' => $orden
  95.         ));
  96.     }
  98.     public function addProduct(Request $request) {
  100.         $page = $request->get("page");
  101.         $em = $this->getDoctrine()->getManager();
  102.         $parent_products = $em->createQueryBuilder()->select('p')
  103.                 ->from("App\Entity\Products", "p")
  104.                 ->where("(p.parent=0 ) and p.status=1")
  105.                 ->orderBy("p.name", "ASC")
  106.                 ->getQuery()
  107.                 ->getResult();
  109.         $attr = $em->getRepository(Attributes::class)->findAll();
  111.         $cats = $em->getRepository(Categorias::class)->findAll();
  112.         $marcas =  $em->createQueryBuilder()->select('p')
  113.                 ->from("App\Entity\Marcas", "p")
  114.                 ->where("p.status=1")
  115.                 ->getQuery()
  116.                 ->getResult();
  117.         
  118.         return $this->render('products/add.html.twig', array(
  119.                     'parents' => $parent_products,
  120.                     'attr' => $attr,
  121.                     'cats' => $cats,
  122.                     'page' => $page,
  123.                     'marcas'=>$marcas
  124.         ));
  125.     }
  127.     public function getAttributesConfig(Request $request) {
  128.         $id = $request->get("id");
  129.         $em = $this->getDoctrine()->getManager();
  131.         $attr = $em->getRepository(Attributes::class)->find($id);
  133.         return $this->render('products/_parts/attrConfig.html.twig', array(
  134.                     'attr' => $attr
  135.         ));
  136.     }
  138.     public function storeProduct(Request $request) {
  139.         
  140.         $page = $request->get("page");
  141.         $em = $this->getDoctrine()->getManager();
  142.         
  143.         $info = $request->request->all();
  144.         //dd($info);
  145.         if (isset($info["id"]) && $info["id"] != "") {
  146.             $product = $em->getRepository(Products::class)->find($info["id"]);
  147.             $prod_image = $product->getImage();
  148.         } else {
  149.             $product = new Products();
  150.             $product->setDateCreated(new \DateTime());
  151.             $prod_image = "";
  152.         }
  154.         //seteamos
  156.         $product->setName($info["name"]);
  157.         $product->setSku($info["sku"]);
  158.         $product->setEan($info["ean"]);
  159.         $product->setDescription($info["description"]);
  160.         $product->setPrice(floatval($info["price"]));
  161.         $product->setIva(floatval($info["iva"]));
  162.         $product->setCostPrice($info["cost_price"]);
  163.         $product->setStoreStock($info["store_stock"]);
  164.         $product->setWpStock($info["wp_stock"]);
  165.         if ($info["discount_from"] != "") {
  166.             $disc_from = \DateTime::createFromFormat('d/m/Y', $info["discount_from"]);
  167.             $product->setDiscountFrom($disc_from);
  168.         } else {
  169.             $product->setDiscountFrom(null);
  170.         }
  171.         if ($info["discount_to"] != "") {
  172.             $disc_to = \DateTime::createFromFormat('d/m/Y', $info["discount_to"]);
  173.             $product->setDiscountTo($disc_to);
  174.         } else {
  175.             $product->setDiscountTo(null);
  176.         }
  177.         $product->setStoreDiscount(($info["store_discount"] != "") ? $info["store_discount"] : 0 );
  178.         $product->setWebDiscount(($info["web_discount"] != "") ? $info["web_discount"] : 0);
  179.         $product->setDateModify(new \DateTime());
  180.         $product->setGlobalStock(floatval($info["store_stock"]) + floatval($info["wp_stock"]));
  181.         $product->setStatus(1);
  182.         $product->setParent((isset($info["parent"]) ? $info["parent"] : 0));
  184.         //imagen
  185.         $image = $request->files->get("image");
  186.         if ($image) { //subimos la imagen
  187.             $originalFilename = pathinfo($image[0]->getClientOriginalName(), PATHINFO_FILENAME);
  188.             $safeFilename = \transliterator_transliterate('Any-Latin; Latin-ASCII; [^A-Za-z0-9_] remove; Lower()', $originalFilename);
  189.             $newFileName = $safeFilename . "-product" . uniqid() . "." . $image[0]->guessExtension();
  190.             try {
  191.                 $image[0]->move(
  192.                         'assets/images/products/',
  193.                         $newFileName
  194.                 );
  195.             } catch (FileException $e) {
  196.                 var_dump($e);
  197.                 die();
  198.             }
  199.             $product->setImage($newFileName);
  200.             if (count($image) > 0) {
  201.                 $gal = [];
  202.                 for ($i = 1; $i < count($image); $i++) {
  203.                     $originalFilename = pathinfo($image[$i]->getClientOriginalName(), PATHINFO_FILENAME);
  204.                     $safeFilename = \transliterator_transliterate('Any-Latin; Latin-ASCII; [^A-Za-z0-9_] remove; Lower()', $originalFilename);
  205.                     $newFileName = $safeFilename . "-product" . uniqid() . "." . $image[$i]->guessExtension();
  206.                     try {
  207.                         $image[$i]->move(
  208.                                 'assets/images/products/',
  209.                                 $newFileName
  210.                         );
  211.                     } catch (FileException $e) {
  212.                         var_dump($e);
  213.                         die();
  214.                     }
  215.                     $gal[] = $newFileName;
  216.                 }
  217.                 $product->setGallery(json_encode($gal));
  218.             }
  219.         } else {
  220.             $product->setImage($prod_image);
  221.         }
  222.         
  223.         //guardamos en local
  224.         $em->persist($product);
  225.         $f = $em->flush();
  226.         if ($f == null) {
  227.             //atributos
  228.             if (isset($info["attr"]) && $info["attr"] != "") {
  229.                 //borramos los atributos actuales
  230.                 $p_attr = $em->getRepository(ProductAttributes::class)->findBy(array("productId" => $product->getId()));
  231.                 foreach ($p_attr as $p_at) {
  232.                     $em->remove($p_at);
  233.                     $em->flush();
  234.                 }
  235.                 foreach ($info["attr"] as $attr_id) {
  236.                     $value = $info["attrib_" . $attr_id . "_value"];
  237.                     $prod_attr = new ProductAttributes();
  238.                     $prod_attr->setAttributeId($attr_id);
  239.                     $prod_attr->setProductId($product->getId());
  240.                     $prod_attr->setValue($value);
  241.                     $em->persist($prod_attr);
  242.                     $em->flush();
  243.                 }
  244.             }
  246.             //categorías
  247.             if (isset($info["categoria"]) && count($info["categoria"])>0) {
  248.                 
  249.                 foreach($info["categoria"] as $cat){
  250.                   $prod_cat = new \App\Entity\ProductCats();
  251.                   $prod_cat->setCatId($cat);
  252.                   $prod_cat->setProductId($product->getId());
  253.                   $prod_cat->setDateCreated(new \DateTime());
  254.                 
  255.                   $em->persist($prod_cat);
  256.                   $em->flush();
  257.                 }
  258.             }
  259.             
  260.             //marca
  261.             if(isset($info["marca"]) && $info["marca"] !=""){
  262.                 $marc = new ProductMarca();
  263.                 $marc->setProductId($product->getId());
  264.                 $marc->setMarcaId($info["marca"]);
  265.                 
  266.                 $em->persist($marc);
  267.                 $em->flush();
  268.             }
  270.             //web
  271.             
  272.             if (isset($info["web"]) && $info["web"] == "on") {
  273.                 //lo enviamos a WP
  274.                 $addedwp = $this->api->addProductToWP($product, $em);
  275.             }
  277.             $type = 1;
  278.             $status = "Producto guardado correctamente";
  279.         } else {
  280.             $type = 0;
  281.             $status = "Error al guardar el producto";
  282.         }
  284.         $this->session->getFlashBag()->add('type', $type);
  285.         $this->session->getFlashBag()->add('status', $status);
  287.         return $this->redirectToRoute('productos', ['page' => $page]);
  288.     }
  290.     public function deleteProduct(Request $request) {
  291.         
  292.         if (!$this->getUser() || !is_object($this->getUser())) {
  293.             return $this->redirectToRoute('logout');
  294.         }
  296.         $em = $this->getDoctrine()->getManager();
  297.         $pid = $request->get("id");
  298.         $page = $request->get("page");
  300.         $prod = $em->getRepository(Products::class)->find($pid);
  301.         if ($prod) {
  302.             if ($prod->getWpId() != null) {
  303.                     $delete_wp = $this->api->deleteProductToWP($prod, $em);
  304.             }
  305.             //$prod->remove(0);
  306.             $em->remove($prod);
  307.             $f = $em->flush();
  308.             if ($f == null) {
  309.                 $type = 1;
  310.                 $status = "Producto eliminado correctamente";
  311.             } else {
  312.                 $type = 0;
  313.                 $status = "Error al eliminar el producto";
  314.             }
  315.         } else {
  316.             $type = 0;
  317.             $status = "Producto no encontrado";
  318.         }
  319.         $this->session->getFlashBag()->add('type', $type);
  320.         $this->session->getFlashBag()->add('status', $status);
  322.         return $this->redirectToRoute('productos', ['page' => $page]);
  323.     }
  325.     public function generateAutoSku() {
  326.         $em = $this->getDoctrine()->getManager();
  328.         $l_prod = $em->createQueryBuilder()->select('p')
  329.                 ->from("App\Entity\Products", "p")
  330.                 ->where("p.id<>''")
  331.                 ->orderBy("p.id", "DESC")
  332.                 ->setMaxResults(1)
  333.                 ->getQuery()
  334.                 ->getResult();
  335.         if ($l_prod) {
  336.             $last_num = $l_prod[0]->getSku();
  337.             $last_num++;
  338.         } else {
  339.             $last_num = date("Y") . "00001";
  340.         }
  341.         return new JsonResponse(array('sku' => $last_num));
  342.     }
  344.     public function editProduct(Request $request) {
  345.         $em = $this->getDoctrine()->getManager();
  346.         $id = $request->get("id");
  347.         $page = $request->get("page");
  349.         $prod = $em->getRepository(Products::class)->find($id);
  351.         $parent_products = $em->createQueryBuilder()->select('p')
  352.                 ->from("App\Entity\Products", "p")
  353.                 ->where("(p.parent=0 ) and p.status=1")
  354.                 ->orderBy("p.name", "ASC")
  355.                 ->getQuery()
  356.                 ->getResult();
  358.         $product_attr = $em->getRepository(ProductAttributes::class)->findBy(array("productId" => $id));
  359.         $atrib = array();
  360.         foreach ($product_attr as $pa) {
  361.             $atrib[] = $pa->getAttributeId();
  362.         }
  363.         $attr = $em->getRepository(Attributes::class)->findAll();
  364.         $cats = $em->getRepository(Categorias::class)->findAll();
  366.         $product_cats = $em->getRepository(\App\Entity\ProductCats::class)->findBy(array("productId" => $id));
  367.         $c_cats = array();
  368.         foreach ($product_cats as $c) {
  369.             $c_cats[] = $c->getCatId();
  370.         }
  371.         
  372.         $marcas = $marcas =  $em->createQueryBuilder()->select('p')
  373.                 ->from("App\Entity\Marcas", "p")
  374.                 ->where("p.status=1")
  375.                 ->getQuery()
  376.                 ->getResult();
  377.                 
  378.         $product_marcas = $em->getRepository(ProductMarca::class)->findBy(array("productId"=>$id));
  379.         $c_marc = array();
  380.         foreach($product_marcas as $m){
  381.           $c_marc[] = $m->getMarcaId();
  382.         }
  383.         
  384.         return $this->render('products/edit.html.twig', array(
  385.                     "prod" => $prod,
  386.                     'parents' => $parent_products,
  387.                     'attr' => $attr,
  388.                     'c_attr' => $product_attr,
  389.                     'atrib' => $atrib,
  390.                     'cats' => $cats,
  391.                     'c_cats' => $c_cats,
  392.                     'page' => $page,
  393.                     'marcas'=>$marcas,
  394.                     'c_marc'=>$c_marc
  395.         ));
  396.     }
  398.     public function updateProduct(Request $request) {
  399.         $em = $this->getDoctrine()->getManager();
  400.         $page = $request->request->get("page");
  402.         $info = $request->request->all();
  403.         //dd($info);
  404.         if (isset($info["id"]) && $info["id"] != "") {
  405.             $product = $em->getRepository(Products::class)->find($info["id"]);
  406.             $prod_image = $product->getImage();
  407.         } else {
  408.             return false;
  409.         }
  411.         //seteamos
  413.         $product->setName($info["name"]);
  414.         $product->setSku($info["sku"]);
  415.         $product->setEan($info["ean"]);
  416.         $product->setDescription($info["description"]);
  417.         $product->setPrice(floatval($info["price"]));
  418.         $product->setIva(floatval($info["iva"]));
  419.         $product->setCostPrice($info["cost_price"]);
  420.         $product->setStoreStock($info["store_stock"]);
  421.         $product->setWpStock($info["wp_stock"]);
  422.         if ($info["discount_from"] != "") {
  423.             $disc_from = \DateTime::createFromFormat('d/m/Y', $info["discount_from"]);
  424.             $product->setDiscountFrom($disc_from);
  425.         }
  426.         if ($info["discount_to"] != "") {
  427.             $disc_to = \DateTime::createFromFormat('d/m/Y', $info["discount_to"]);
  428.             $product->setDiscountTo($disc_to);
  429.         }
  430.         $product->setStoreDiscount(($info["store_discount"] != "") ? $info["store_discount"] : 0 );
  431.         $product->setWebDiscount(($info["web_discount"] != "") ? $info["web_discount"] : 0);
  432.         $product->setDateModify(new \DateTime());
  433.         $product->setGlobalStock(floatval($info["store_stock"]) + floatval($info["wp_stock"]));
  434.         $product->setParent((isset($info["parent"]) ? $info["parent"] : 0));
  436.         //imagen
  437.         $image = $request->files->get("image");
  438.         if ($image) { //subimos la imagen
  439.             $originalFilename = pathinfo($image[0]->getClientOriginalName(), PATHINFO_FILENAME);
  440.             $safeFilename = \transliterator_transliterate('Any-Latin; Latin-ASCII; [^A-Za-z0-9_] remove; Lower()', $originalFilename);
  441.             $newFileName = $safeFilename . "-product" . uniqid() . "." . $image[0]->guessExtension();
  442.             try {
  443.                 $image[0]->move(
  444.                         'assets/images/products/',
  445.                         $newFileName
  446.                 );
  447.             } catch (FileException $e) {
  448.                 var_dump($e);
  449.                 die();
  450.             }
  452.             $product->setImage($newFileName);
  453.             if (count($image) > 0) {
  454.                 $gal = [];
  455.                 for ($i = 1; $i < count($image); $i++) {
  456.                     $originalFilename = pathinfo($image[$i]->getClientOriginalName(), PATHINFO_FILENAME);
  457.                     $safeFilename = \transliterator_transliterate('Any-Latin; Latin-ASCII; [^A-Za-z0-9_] remove; Lower()', $originalFilename);
  458.                     $newFileName = $safeFilename . "-product" . uniqid() . "." . $image[$i]->guessExtension();
  459.                     try {
  460.                         $image[$i]->move(
  461.                                 'assets/images/products/',
  462.                                 $newFileName
  463.                         );
  464.                     } catch (FileException $e) {
  465.                         var_dump($e);
  466.                         die();
  467.                     }
  468.                     $gal[] = $newFileName;
  469.                 }
  470.                 $product->setGallery(json_encode($gal));
  471.             }
  472.         } else {
  473.             $product->setImage($prod_image);
  474.         }
  477.         //guardamos en local
  479.         $em->persist($product);
  480.         $f = $em->flush();
  481.         if ($f == null) {
  482.             //atributos
  483.             if (isset($info["attr"]) && $info["attr"] != "") {
  484.                 //borramos los atributos actuales
  485.                 $p_attr = $em->getRepository(ProductAttributes::class)->findBy(array("productId" => $product->getId()));
  486.                 foreach ($p_attr as $p_at) {
  487.                     $em->remove($p_at);
  488.                     $em->flush();
  489.                 }
  490.                 foreach ($info["attr"] as $attr_id) {
  491.                     $value = $info["attrib_" . $attr_id . "_value"];
  492.                     $prod_attr = new ProductAttributes();
  493.                     $prod_attr->setAttributeId($attr_id);
  494.                     $prod_attr->setProductId($product->getId());
  495.                     $prod_attr->setValue($value);
  496.                     $em->persist($prod_attr);
  497.                     $em->flush();
  498.                 }
  499.             }
  501.             //categorías
  502.             
  503.             $p_cats = $em->getRepository(\App\Entity\ProductCats::class)->findBy(array('productId' => $product->getId()));
  504.                 foreach ($p_cats as $pc) {
  505.                     $em->remove($pc);
  506.                     $em->flush();
  507.                 }
  508.             if (isset($info["categoria"]) && count($info["categoria"])>0) {
  509.                 //borramos la actual
  510.                 
  511.                 foreach($info["categoria"] as $cat){
  512.                   $prod_cat = new \App\Entity\ProductCats();
  513.                   $prod_cat->setCatId($cat);
  514.                   $prod_cat->setProductId($product->getId());
  515.                   $prod_cat->setDateCreated(new \DateTime());
  516.                 
  517.                   $em->persist($prod_cat);
  518.                   $em->flush();
  519.                 }
  520.                 
  521.             }
  522.             
  523.             if(isset($info["marca"]) && $info["marca"] !=""){
  524.               //borramos la actual
  525.                 $p_cats = $em->getRepository(\App\Entity\ProductMarca::class)->findBy(array('productId' => $product->getId()));
  526.                 foreach ($p_cats as $pc) {
  527.                     $em->remove($pc);
  528.                     $em->flush();
  529.                 }
  530.                 $marc = new ProductMarca();
  531.                 $marc->setProductId($product->getId());
  532.                 $marc->setMarcaId($info["marca"]);
  533.                 
  534.                 $em->persist($marc);
  535.                 $em->flush();
  536.             }
  538.             //web
  539.             
  540.             if (isset($info["web"]) && $info["web"] == "on") {
  541.                 if ($product->getWpId()) {
  542.                     //update
  543.                     $updatedwp = $this->api->updateProductToWP($product, $em);
  544.                 } else {
  545.                     //create
  546.                     $addedwp = $this->api->addProductToWP($product, $em);
  547.                     //dd($addedwp);
  548.                 }
  549.             } else {
  550.                 if ($product->getWpId()) {
  551.                     $deleteWp = $this->api->deleteProductToWP($product, $em);
  552.                 }
  553.             }
  555.             $type = 1;
  556.             $status = "Producto guardado correctamente";
  557.         } else {
  558.             $type = 0;
  559.             $status = "Error al guardar el producto";
  560.         }
  562.         $this->session->getFlashBag()->add('type', $type);
  563.         $this->session->getFlashBag()->add('status', $status);
  565.         return $this->redirectToRoute('productos', ['page' => $page]);
  566.     }
  568.     public function addProductVariation(Request $request) {
  569.         $em = $this->getDoctrine()->getManager();
  570.         $id = $request->get("id");
  572.         $prod = $em->getRepository(Products::class)->find($id);
  574.         $parent_products = $em->createQueryBuilder()->select('p')
  575.                 ->from("App\Entity\Products", "p")
  576.                 ->where("(p.parent=0 ) and p.status=1")
  577.                 ->orderBy("p.name", "ASC")
  578.                 ->getQuery()
  579.                 ->getResult();
  581.         $product_attr = $em->getRepository(ProductAttributes::class)->findBy(array("productId" => $id));
  582.         $atrib = array();
  583.         foreach ($product_attr as $pa) {
  584.             $atrib[] = $pa->getAttributeId();
  585.         }
  586.         $attr = $em->getRepository(Attributes::class)->findAll();
  587.         $cats = $em->getRepository(Categorias::class)->findAll();
  589.         $product_cats = $em->getRepository(\App\Entity\ProductCats::class)->findBy(array("productId" => $id));
  590.         $c_cats = array();
  591.         foreach ($product_cats as $c) {
  592.             $c_cats[] = $c->getCatId();
  593.         }
  594.         
  595.         $marcas =  $em->createQueryBuilder()->select('p')
  596.                 ->from("App\Entity\Marcas", "p")
  597.                 ->where("p.status=1")
  598.                 ->getQuery()
  599.                 ->getResult();
  600.         $product_marcas = $em->getRepository(\App\Entity\ProductMarca::class)->findBy(array("productId" => $id));
  601.         $c_marc = array();
  602.         foreach($product_marcas as $m){
  603.           $c_marc[] = $m->getMarcaId();
  604.         }
  605.         
  606.         return $this->render('products/addProdVariation.html.twig', array(
  607.                     "prod" => $prod,
  608.                     'parents' => $parent_products,
  609.                     'attr' => $attr,
  610.                     'c_attr' => $product_attr,
  611.                     'atrib' => $atrib,
  612.                     'cats' => $cats,
  613.                     'c_cats' => $c_cats,
  614.                     'marcas'=>$marcas,
  615.                     'c_marc'=>$c_marc
  616.         ));
  617.     }
  619.     public function viewProductVariations(Request $request, PaginatorInterface $paginator) {
  620.         $em = $this->getDoctrine()->getManager();
  621.         $id = $request->get("id");
  623.         $prod_parent = $em->getRepository(Products::class)->find($id);
  625.         $prods = $em->createQueryBuilder()->select("p")
  626.                         ->from("App\Entity\Products", "p")
  627.                         ->where("p.id <> '' and p.status > 0 and p.parent=" . $id)
  628.                         ->getQuery()->getResult();
  629.         $productos = $paginator->paginate(
  630.                 $prods, $request->query->getInt('page', 1), 20);
  632.         return $this->render('products/listVariations.html.twig', array(
  633.                     'productos' => $productos,
  634.                     'prod' => $prod_parent
  635.         ));
  636.     }
  638.     /*
  639.      * Attributes functions
  640.      */
  642.     public function indexAtributes(Request $request, PaginatorInterface $paginator) {
  643.         $em = $this->getDoctrine()->getManager();
  645.         $attr_new = new Attributes();
  647.         $form = $this->createForm(AttributosType::class, $attr_new, ['save_lbl' => "Guardar"]);
  649.         $form->handleRequest($request);
  651.         if ($form->isSubmitted()) {
  652.             $attr_new->setDatecreated(new \DateTime());
  653.             $em->persist($attr_new);
  654.             $f = $em->flush();
  656.             if ($f == null) {
  657.                 $type = 1;
  658.                 $status = "Atributo guardado correctamente";
  659.             } else {
  660.                 $type = 0;
  661.                 $status = "Error al guardar el atributo";
  662.             }
  663.             $this->session->getFlashBag()->add('type', $type);
  664.             $this->session->getFlashBag()->add('status', $status);
  666.             return $this->redirectToRoute('atributos');
  667.         }
  669.         $orden = ($request->get("orden")) ? $request->get("orden") : 'DESC';
  670.         $filter = ($request->get("filter")) ? $request->get("filter") : 'id';
  672.         $attrs = $em->createQueryBuilder()->select("a")
  673.                         ->from("App\Entity\Attributes", "a")
  674.                         ->where("a.id <> ''")
  675.                         ->orderBy("a." . $filter, $orden)
  676.                         ->getQuery()->getResult();
  678.         $atributos = $paginator->paginate(
  679.                 $attrs, $request->query->getInt('page', 1), 20);
  681.         return $this->render('products/attributes/list.html.twig', array(
  682.                     'atributos' => $atributos,
  683.                     'orden' => $orden,
  684.                     'form' => $form->createView()
  685.         ));
  686.     }
  688.     public function addAtributeValues(Request $request) {
  689.         $em = $this->getdoctrine()->getManager();
  690.         $values = $request->request->get("valores");
  691.         $id = $request->request->get('id_attr');
  692.         if ($values != "") {
  693.             $valores = json_encode(explode(",", $values));
  694.             $atr = $em->getRepository(Attributes::class)->find($id);
  696.             $atr->setValue($valores);
  697.             $em->persist($atr);
  698.             $f = $em->flush();
  699.             if ($f == null) {
  700.                 $type = 1;
  701.                 $status = "Atributos guardados correctamente";
  702.             } else {
  703.                 $type = 0;
  704.                 $status = "Error al guardar atributos";
  705.             }
  706.             $this->session->getFlashBag()->add('type', $type);
  707.             $this->session->getFlashBag()->add('status', $status);
  709.             return $this->redirectToRoute('atributos');
  710.         }
  711.     }
  713.     /*
  714.      * Categorias functions
  715.      */
  717.     public function indexCategorias(Request $request, PaginatorInterface $paginator) {
  718.         $em = $this->getDoctrine()->getManager();
  720.         $orden = ($request->get("orden")) ? $request->get("orden") : 'DESC';
  722.         //$cats = $em->getRepository(\App\Entity\Categorias::class)->findAll();
  723.         
  724.         $cats = $em->createQueryBuilder()->select("c")
  725.             ->from("App\Entity\Categorias", "c")
  726.             ->where("c.id <> '' and c.status > 0")
  727.             ->getQuery()->getResult();
  728.         
  729.         $pagination = $paginator->paginate(
  730.                 $cats, $request->query->getInt('page', 1), 20);
  731.                 
  732.         $cat_new = new Categorias();
  733.         $p_cats = $em->getRepository(Categorias::class)->findBy(array('parent'=>0));
  734.         $parents = ["Ninguna"=>0];
  735.         foreach($p_cats as $cat){
  736.             if ($cat->getStatus() != '0')
  737.             $parents[$cat->getNombre()]=$cat->getId();
  738.         }
  739.         
  740.         $form = $this->createForm(CategoriasType::class,$cat_new, [
  741.             'save_lbl'=>"Guardar",
  742.             'parents'=>$parents
  743.         ]);
  744.         
  745.         $form->handleRequest($request);
  746.         
  747.         if($form->isSubmitted()){
  748.             
  749.             $cat_new->setStatus('1');
  750.             //crear categoria a wp
  751.             $wc = new WCController();
  752.             $parent_cat_wp = 0;
  753.             if($cat_new->getParent()){
  754.                 $par_cat = $em->getRepository(Categorias::class)->find($cat_new->getParent());
  755.                 $parent_cat_wp = $par_cat->getIdWp();
  756.             }
  757.             $wp_cat = $wc->createCat($cat_new->getNombre(), str_replace(" ", "-", strtolower($cat_new->getNombre())), $parent_cat_wp);
  758.             //dd($wp_cat);
  759.             $cat_new->setIdWp($wp_cat->id);
  760.             $cat_new->setParentWp($wp_cat->parent);
  761.             $em->persist($cat_new);
  762.             $f = $em->flush();
  763.             if($f == null){
  764.                 
  765.                 $type = 1;
  766.                 $status = "Categoría guardada correctamente";
  767.             }else{
  768.                 $type = 0;
  769.                 $status = "Error al guardar categoría";
  770.             }
  771.             $this->session->getFlashBag()->add('type', $type);
  772.             $this->session->getFlashBag()->add('status', $status);
  774.             return $this->redirectToRoute('categorias');
  775.         }
  776.         
  777.         return $this->render('products/categories/list.html.twig', array(
  778.                     "cats" => $pagination,
  779.                     'orden' => $orden,
  780.                     'form'=>$form->createView()
  781.         ));
  782.     }
  783.     
  784.     public function categoryEditForm(Request $request) {
  785.         
  786.         $em = $this->getDoctrine()->getManager();
  787.         
  788.         $id = $request->request->get('id');
  789.         
  790.         $cat = $em->getRepository(Categorias::class)->findBy(['id' => $id]);
  791.         $cats = $em->createQueryBuilder()->select("c")
  792.             ->from("App\Entity\Categorias", "c")
  793.             ->where("c.id <> '' and c.status > 0")
  794.             ->getQuery()->getResult();
  795.         
  796.         
  797.         
  798.         return $this->render('products/categories/editForm.html.twig', array(
  799.                     "id" => $id,
  800.                     "cat" => $cat[0],
  801.                     "cats" => $cats,
  802.         ));
  803.     }
  804.     
  805.     public function categoryEdit(Request $request) {
  806.         
  807.         //dd($request->request);
  808.         $em = $this->getDoctrine()->getManager();
  809.         $data = $request->request->all();
  810.         
  811.         $cat = $em->getRepository(Categorias::class)->find($data['id']);
  812.         
  813.         if($data && $cat && $data['nombre']){
  814.             
  815.             $cat->setNombre($data['nombre']); 
  816.             $cat->setParent($data['padre']);
  817.             $wc = new WCController();
  818.             if($cat->getIdWp()==""){
  819.                 
  820.                 $parent_cat_wp = 0;
  821.                 if($cat->getParent()){
  822.                     $par_cat = $em->getRepository(Categorias::class)->find($cat->getParent());
  823.                     $parent_cat_wp = $par_cat->getIdWp();
  824.                 }
  825.                 $wp_cat = $wc->createCat($cat->getNombre(), str_replace(" ", "-", strtolower($cat->getNombre())), $parent_cat_wp);
  826.                 $cat->setIdWp($wp_cat->id);
  827.                 $cat->setParentWp($wp_cat->parent);
  828.             }else{
  829.                 $parent_cat_wp = 0;
  830.                 $wp_cat = $wc->updateCat($cat->getNombre(), str_replace(" ", "-", strtolower($cat->getNombre())), $cat->getParentWp(), $cat->getIdWp());
  831.             }
  832.             
  833.             $em->persist($cat);
  834.             $f = $em->flush();
  835.             
  836.             if($f == null){
  837.                 $type = 1;
  838.                 $status = "Categoría editada correctamente";
  839.             }else{
  840.                 $type = 0;
  841.                 $status = "Error al editar 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.     }
  852.     
  853.     public function categoryDelete(Request $request) {
  854.         
  855.         if (!$this->getUser() || !is_object($this->getUser())) {
  856.             return $this->redirectToRoute('logout');
  857.         }
  858.         
  859.         $em = $this->getDoctrine()->getManager();
  860.         $id = $request->query->get('id');
  861.         
  862.         $cat = $em->getRepository(Categorias::class)->find($id);
  863.         
  864.         if($id && $cat){
  865.             $cat->setStatus(0);
  866.             if($cat->getIdWP()!=""){
  867.                 $wc = new WCController();
  868.                 $del = $wc->deleteCat($cat->getIdWp());
  869.                 $cat->setIdWp("");
  870.                 $cat->setParentWp("");
  871.             }
  872.             $em->persist($cat);
  873.             $f = $em->flush();
  874.             
  875.             if($f == null){
  876.                 
  877.                 $type = 1;
  878.                 $status = "Categoría eliminada correctamente";
  879.             }else{
  880.                 $type = 0;
  881.                 $status = "Error al eliminar la categoría";
  882.             }
  883.         } else {
  884.             $type = 0;
  885.             $status = "Datos incorrectos o no se encontro la categoría";
  886.         }
  887.         $this->session->getFlashBag()->add('type', $type);
  888.         $this->session->getFlashBag()->add('status', $status);
  889.         
  890.         return $this->redirectToRoute('categorias');
  891.     }
  893.     public function SyncCatsWP(Request $request) {
  894.         $em = $this->getDoctrine()->getManager();
  895.         $api = new WCController();
  896.         $return = $request->get("return");
  898.         $cats = $api->getProductCats();
  899.         
  900.         foreach ($cats as $cat) {
  901.             if (!is_object($cat)) {
  902.                 dd($cat);
  903.             }
  904.             $cate = $em->getRepository(Categorias::class)->findOneBy(array('idWp' => $cat->id));
  905.             if (!$cate) {
  906.                 $cate = new Categorias();
  907.                 $cate->setStatus(1);
  908.             }
  909.             $cate->setIdWp($cat->id);
  910.             $cate->setNombre($cat->name);
  911.             
  912.             if ($cat->parent == 0) {
  913.                 $cate->setParent($cat->parent);
  914.             } else {
  915.                 $parent_cat = $em->getRepository(Categorias::class)->findOneBy(array('idWp' => $cat->parent));
  916.                 if ($parent_cat) {
  917.                     $cate->setParent($parent_cat->getId());
  918.                 } else {
  919.                     $cate->setParent(0);
  920.                 }
  921.             }
  922.             $cate->setParentWp($cat->parent);
  924.             $em->persist($cate);
  925.             $em->flush();
  926.         }
  927.         if ($return == 1) {
  928.             $this->session->getFlashBag()->add('type', 1);
  929.             $this->session->getFlashBag()->add('status', "Categorías sincronizadas");
  931.             return $this->redirectToRoute('categorias');
  932.         } else {
  933.             dd($cats);
  934.         }
  935.     }
  937.     public function SyncBrandsWP(Request $request) {
  938.         $api = new WCController();
  939.         $brands = $api->getProductBrands();
  940.         dd($brands);
  941.     }
  943.     /*
  944.      * Proveedores functions
  945.      */
  947.     public function proveedoresIndex(Request $request, PaginatorInterface $paginator) {
  948.         if (!$this->getUser() || !is_object($this->getUser())) {
  949.             return $this->redirectToRoute('logout');
  950.         }
  952.         $s = ($request->get("s") ) ? $request->get("s") : "";
  953.         $s_str = "";
  955.         if ($s) {
  956.             $s_str = " AND p.name LIKE '%" . $s . "%' OR p.email LIKE '%" . $s . "%'";
  957.         }
  959.         $orden = ($request->get("orden")) ? $request->get("orden") : 'DESC';
  960.         $filter = ($request->get("filter")) ? $request->get("filter") : 'id';
  962.         $em = $this->getDoctrine()->getManager();
  964.         $proveedores = $em->createQueryBuilder()->select("p")
  965.                 ->from("App\Entity\Proveedores", "p")
  966.                 ->where("p.id <> ''")
  967.                 ->orderBy("p." . $filter, $orden)
  968.                 ->getQuery()
  969.                 ->getResult();
  970.         $provs = $paginator->paginate(
  971.                 $proveedores, $request->query->getInt('page', 1), 20);
  973.         $new_p = new Proveedores();
  974.         $form = $this->createForm(ProveedoresType::class, $new_p, [
  975.             'save_lbl' => "Guardar"
  976.         ]);
  977.         $form->handleRequest($request);
  978.         if ($form->isSubmitted()) {
  979.             $new_p->setDatecreated(new \DateTime());
  980.             $em->persist($new_p);
  981.             $f = $em->flush();
  982.             if ($f == null) {
  983.                 $type = 1;
  984.                 $status = "Proveedor guardado correctamente";
  985.             } else {
  986.                 $type = 0;
  987.                 $status = "Error al guardar el proveedor";
  988.             }
  990.             $this->session->getFlashBag()->add('type', $type);
  991.             $this->session->getFlashBag()->add('status', $status);
  993.             return $this->redirectToRoute('proveedores');
  994.         }
  996.         return $this->render('products/proveedores/index.html.twig', array(
  997.                     "s" => $s,
  998.                     "proveedores" => $provs,
  999.                     'orden' => $orden,
  1000.                     'form' => $form->createView()
  1001.         ));
  1002.     }
  1004.     public function deleteProveedor(Request $request) {
  1005.         $id = $request->get("id");
  1006.         $em = $this->getDoctrine()->getManager();
  1008.         $provee = $em->getRepository(Proveedores::class)->find($id);
  1009.         if ($provee) {
  1010.             $em->remove($provee);
  1011.             $f = $em->flush();
  1012.             if ($f == null) {
  1013.                 $type = 1;
  1014.                 $status = "Proveedor eliminado correctamente";
  1015.             } else {
  1016.                 $type = 0;
  1017.                 $status = "Error al eliminar el proveedor";
  1018.             }
  1020.             $this->session->getFlashBag()->add('type', $type);
  1021.             $this->session->getFlashBag()->add('status', $status);
  1023.             return $this->redirectToRoute('proveedores');
  1024.         }
  1025.     }
  1027.     public function editProveedor(Request $request) {
  1028.         $id = $request->get("id");
  1029.         $em = $this->getDoctrine()->getManager();
  1031.         $prove = $em->getRepository(Proveedores::class)->find($id);
  1032.         $form = $this->createForm(ProveedoresType::class, $prove, [
  1033.             'save_lbl' => "Guardar"
  1034.         ]);
  1036.         $form->handleRequest($request);
  1037.         if ($form->isSubmitted()) {
  1038.             $em->persist($prove);
  1039.             $f = $em->flush();
  1040.             if ($f == null) {
  1041.                 $type = 1;
  1042.                 $status = "Proveedor editado correctamente";
  1043.             } else {
  1044.                 $type = 0;
  1045.                 $status = "Error al editar el proveedor";
  1046.             }
  1048.             $this->session->getFlashBag()->add('type', $type);
  1049.             $this->session->getFlashBag()->add('status', $status);
  1051.             return $this->redirectToRoute('proveedores');
  1052.         }
  1053.         return $this->render('products/proveedores/edit.html.twig', array(
  1054.                     'id' => $id,
  1055.                     'form' => $form->createView()
  1056.         ));
  1057.     }
  1059.     public function proveedorAlbaranes(Request $request, PaginatorInterface $paginator) {
  1060.         if (!$this->getUser() || !is_object($this->getUser())) {
  1061.             return $this->redirectToRoute('logout');
  1062.         }
  1064.         $s = ($request->get("s") ) ? $request->get("s") : "";
  1065.         $s_str = "";
  1067.         if ($s) {
  1068.             $s_str = " AND a.num_albaran LIKE '%" . $s . "%'";
  1069.         }
  1071.         $orden = ($request->get("orden")) ? $request->get("orden") : 'DESC';
  1072.         $filter = ($request->get("filter")) ? $request->get("filter") : 'id';
  1074.         $em = $this->getDoctrine()->getManager();
  1075.         $id = $request->get("id");
  1076.         $proveedor = $em->getRepository(Proveedores::class)->find($id);
  1077.         $albaranes = $em->createQueryBuilder()->select("a")
  1078.                 ->from("App\Entity\Albaranes", "a")
  1079.                 ->where("a.id_provider = " . $id . " " . $s_str)
  1080.                 ->orderBy("a." . $filter, $orden)
  1081.                 ->getQuery()
  1082.                 ->getResult();
  1083.         $provs = $paginator->paginate(
  1084.                 $albaranes, $request->query->getInt('page', 1), 20);
  1085.                 
  1086.         $uploads = $em->createQueryBuilder()->select("p")
  1087.                 ->from("App\Entity\ProductUploads", "p")
  1088.                 ->where("p.proveedorId = " . $id . " " . $s_str)
  1089.                 ->getQuery()
  1090.                 ->getResult();
  1092.         return $this->render('products/proveedores/albaranes.html.twig', array(
  1093.                     'id' => $id,
  1094.                     'albaranes' => $provs,
  1095.                     'proveedor' => $proveedor,
  1096.                     "s" => $s,
  1097.                     'orden' => $orden,
  1098.                     'uploads' => $uploads,
  1099.                         //'form'=>$form->createView()
  1100.         ));
  1101.     }
  1103.     public function addAlbaran(Request $request) {
  1104.         if (!$this->getUser() || !is_object($this->getUser())) {
  1105.             return $this->redirectToRoute('logout');
  1106.         }
  1107.         $em = $this->getDoctrine()->getManager();
  1108.         $id = $request->get("id");
  1109.         $proveedor = $em->getRepository(Proveedores::class)->find($id);
  1111.         return $this->render('products/proveedores/add_albaran.html.twig', array(
  1112.                     'id' => $id,
  1113.                     'proveedor' => $proveedor,
  1114.         ));
  1115.     }
  1117.     public function printLabel(Request $request) {
  1118.         $em = $this->getDoctrine()->getManager();
  1119.         $id = $request->request->get("id");
  1120.         $prod = $em->getRepository(Products::class)->find($id);
  1122.         $barcode = new BarcodeGenerator();
  1123.         $barcode->setText($prod->getSku());
  1124.         $barcode->setType(BarcodeGenerator::Code128);
  1125.         $barcode->setScale(2);
  1126.         $barcode->setThickness(25);
  1127.         $barcode->setFontSize(10);
  1128.         $code = $barcode->generate();
  1130.         return $this->render('products/label.html.twig', array(
  1131.                     'id' => $id,
  1132.                     'prod' => $prod,
  1133.                     'code' => $code
  1134.         ));
  1135.     }
  1137.     public function addNewProductAjax(Request $request) {
  1138.         $em = $this->getDoctrine()->getManager();
  1139.         $data = $request->request->get("form");
  1141.         $prod = new Products();
  1142.         $prod->setCostPrice(0);
  1143.         $prod->setDateCreated(new \DateTime());
  1144.         $prod->setDescription("");
  1145.         $prod->setDateModify(new \DateTime());
  1146.         $prod->setDiscount(0);
  1147.         $prod->setDiscountFrom(null);
  1148.         $prod->setDiscountTo(null);
  1149.         $prod->setEan("");
  1150.         $prod->setGlobalStock($data[3]["value"]);
  1151.         $prod->setImage("");
  1152.         $prod->setName($data[0]["value"]);
  1153.         $prod->setParent(0);
  1154.         $prod->setPrice($data[2]["value"]);
  1155.         $prod->setSku($data[1]["value"]);
  1156.         $prod->setStatus(1);
  1157.         $prod->setStoreDiscount(0);
  1158.         $prod->setStoreStock($data[3]["value"]);
  1159.         $prod->setWebDiscount(0);
  1160.         $prod->setWpId(null);
  1161.         $prod->setWpStock(0);
  1162.         $prod->setIva(21);
  1164.         $em->persist($prod);
  1165.         $f = $em->flush();
  1166.         if ($f == null) {
  1167.             return new JsonResponse(array("ok" => true, "sku" => $prod->getSku()));
  1168.         } else {
  1169.             return new JsonResponse(array("ok" => false));
  1170.         }
  1171.     }
  1173.     public function getAlbaranesLine(Request $request) {
  1174.         $em = $this->getDoctrine()->getManager();
  1175.         $id = $request->request->get("id");
  1176.         $prod = $em->getRepository(Products::class)->find($id);
  1178.         return $this->render('products/proveedores/albaranLineTable.html.twig', array(
  1179.                     'prod' => $prod,
  1180.         ));
  1181.     }
  1183.     public function UpdateAllProductsToWp(Request $request) {
  1185.         $em = $this->getDoctrine()->getManager();
  1187.         $products = $em->createQueryBuilder()->select("p")
  1188.                 ->from(Products::class, "p")
  1189.                 ->where("p.wpId IS NOT NULL AND p.wpId <> '' and p.sku > 3627")
  1190.                 ->getQuery()
  1191.                 ->getResult();
  1192.                 //dd($products);
  1193.             //creem tots els productes
  1194.             foreach ($products as $product) {
  1195.                 $product->setWpId(null);
  1196.                 
  1197.                 $this->api->addProductToWP($product, $em);
  1198.                 //die();
  1199.                 
  1200.             }
  1202.         return new JsonResponse(array("ok" => true));
  1203.     }
  1204.     
  1205.     public function choice(Request $request) {
  1206.         
  1207.         if (!$this->getUser() || !is_object($this->getUser())) {
  1208.             return $this->redirectToRoute('logout');
  1209.         }
  1210.         $em = $this->getDoctrine()->getManager();
  1211.         $id = $request->get("id");
  1212.         $proveedor = $em->getRepository(Proveedores::class)->find($id);
  1213.         
  1214.         return $this->render('products/proveedores/choice.html.twig', array(
  1215.                     'id' => $id,
  1216.                     'proveedor' => $proveedor,
  1217.         ));
  1218.     }
  1219.     
  1220.     public function volcar(Request $request) {
  1221.         
  1222.         if (!$this->getUser() || !is_object($this->getUser())) {
  1223.             return $this->redirectToRoute('logout');
  1224.         }
  1225.         $em = $this->getDoctrine()->getManager();
  1226.         $id = $request->get("id");
  1227.         $proveedor = $em->getRepository(Proveedores::class)->find($id);
  1228.         
  1229.         return $this->render('products/proveedores/volcar.html.twig', array(
  1230.                     'id' => $id,
  1231.                     'proveedor' => $proveedor,
  1232.         ));
  1233.     }
  1234.     
  1235.     public function saveFiles(Request $request): response {
  1236.         
  1237.         if (!$this->getUser() || !is_object($this->getUser())) {
  1238.             return $this->redirectToRoute('logout');
  1239.         }
  1240.         $em = $this->getDoctrine()->getManager();
  1241.         $id = $request->get("proveedor_id");
  1242.         
  1243.         $images = $request->files->get("imgs");
  1244.         $file = $request->files->get("file");
  1245.         
  1246.         // UPLOAD IMAGES
  1247.         $newImagesFileName = NULL;
  1248.         if ($images) {
  1249.             if ($images->guessExtension() == "zip") {
  1250.                 $originalImagesFilename = pathinfo($images->getClientOriginalName(), PATHINFO_FILENAME);
  1251.                 $safeImagesFilename = \transliterator_transliterate('Any-Latin; Latin-ASCII; [^A-Za-z0-9_] remove; Lower()', $originalImagesFilename);
  1252.                 $newImagesFileName = $safeImagesFilename . "-product" . uniqid() . "." . $images->guessExtension();
  1254.                 try {
  1255.                     $images->move(
  1256.                         'assets/images/products/',
  1257.                         $newImagesFileName
  1258.                     );
  1259.                 } catch (FileException $e) {
  1260.                     var_dump($e);
  1261.                     die();
  1262.                 }
  1263.             } else {
  1264.                 $type = 0;
  1265.                 $status = "Formato de imágenes incorrecto. Asegúrese de subir un archivo comprimido .zip";
  1267.                 $this->session->getFlashBag()->add('type', $type);
  1268.                 $this->session->getFlashBag()->add('status', $status);
  1270.                 return $this->redirectToRoute('proveedor_volcar', [ 'id' => $id ]);
  1271.             }
  1272.         }
  1273.         
  1274.         //UPLOAD FILE
  1275.         $extension = "";
  1276.         if ($file != null) { $extension = '.'.$file->getClientOriginalExtension();}
  1277.         if ($file && $extension == ".csv") {
  1278.             
  1279.             $originalFilename = pathinfo($file->getClientOriginalName(), PATHINFO_FILENAME);
  1280.             $safeFilename = \transliterator_transliterate('Any-Latin; Latin-ASCII; [^A-Za-z0-9_] remove; Lower()', $originalFilename);
  1281.             $newFileName = $safeFilename . "-product" . uniqid() . $extension;
  1282.             
  1283.             try {
  1284.                 $file->move(
  1285.                     'assets/files/products/',
  1286.                     $newFileName
  1287.                 );
  1288.             } catch (FileException $e) {
  1289.                 var_dump($e);
  1290.                 die();
  1291.             }
  1292.             
  1293.         } else {
  1294.             
  1295.             $type = 0;
  1296.             $status = "Archivo .csv no seleccionado o formato incorrecto";
  1297.             
  1298.             $this->session->getFlashBag()->add('type', $type);
  1299.             $this->session->getFlashBag()->add('status', $status);
  1300.             
  1301.             return $this->redirectToRoute('proveedor_volcar', [ 'id' => $id ]);
  1302.             
  1303.         } 
  1304.         
  1305.         $productUploads = new ProductUploads();
  1306.         
  1307.         $productUploads->setProveedorId($request->get("proveedor_id"));
  1308.         $productUploads->setFile($newFileName);
  1309.         if ($newImagesFileName != NULL) {
  1310.         $productUploads->setImages($newImagesFileName);
  1311.         } else {
  1312.             $productUploads->setImages("null");
  1313.         }
  1314.         
  1315.         $em->persist($productUploads);
  1316.         $em->flush();
  1317.         
  1318.         $prodUploadsId = $productUploads->getId();
  1319.         
  1320.         return $this->redirectToRoute('proveedor_selectRows', [ 'id' => $prodUploadsId ]);
  1321.     }
  1322.     
  1323.     public function selectRows(Request $request){
  1324.         
  1325.         if (!$this->getUser() || !is_object($this->getUser())) {
  1326.             return $this->redirectToRoute('logout');
  1327.         }
  1328.         
  1329.         $em = $this->getDoctrine()->getManager();
  1330.         $id = $request->get("id");
  1331.         $prodUploads = $em->getRepository(ProductUploads::class)->find($id);
  1332.         $proveedorId = $prodUploads->getProveedorId();
  1333.         $proveedor = $em->getRepository(Proveedores::class)->find($proveedorId);
  1334.         
  1335.         $order = $em->createQueryBuilder()->select("o.rowsOrder")
  1336.                 ->from(ProveedorOrder::class, "o")
  1337.                 ->where("o.proveedorId = '$proveedorId'")
  1338.                 ->orderBy("o.id", "DESC") // Ordena por ID en orden descendente
  1339.                 ->setMaxResults(1)
  1340.                 ->getQuery()
  1341.                 ->getOneOrNullResult();
  1342.         
  1343.         $arrayOrder = (array) null;
  1344.         if ($order) {
  1345.             
  1346.             $arrayOrder = json_decode($order['rowsOrder']);
  1347.           
  1348.         }
  1349.         
  1350.         
  1351.         $file = $prodUploads->getFile();
  1352.         $filePath = 'assets/files/products/' . $file;
  1353.         
  1354.         // CSV Decoder
  1355.         $csvEncoder = new CsvEncoder();
  1356.         $values = $csvEncoder->decode(file_get_contents($filePath), 'csv',[CsvEncoder::DELIMITER_KEY => ';']);
  1357.         //dd(count($values[0]));
  1358.         if (count($values[0]) == 1) {
  1359.             $values = $csvEncoder->decode(file_get_contents($filePath), 'csv',[CsvEncoder::DELIMITER_KEY => ',']);
  1360.         }
  1361.         
  1362.         // Save only array keys (first colum)
  1363.         $columnNames = array_keys($values[0]);
  1364.         
  1365.         return $this->render('products/proveedores/selectRows.html.twig', array(
  1366.             'rows' => $columnNames,
  1367.             'proveedor' => $proveedor,
  1368.             'prod_uploads_id' => $id,
  1369.             'order' => $arrayOrder,
  1370.         ));
  1371.     }
  1372.     
  1373.     public function saveOrder(Request $request) {
  1374.         
  1375.         if (!$this->getUser() || !is_object($this->getUser())) {
  1376.             return $this->redirectToRoute('logout');
  1377.         }
  1378.         
  1379.         $em = $this->getDoctrine()->getManager();
  1380.         $proveedorId = $request->get("proveedor_id");
  1381.         $prodUploadsId = $request->get("prod_uploads_id");
  1382.         $rows = $request->get("product");
  1383.         
  1384.         //Si mantenen el valor per defecte del formulari ho cambia a null
  1385.         for ($i = 0; $i <= 21; $i++) {
  1386.             if ($rows[$i] == "Seleccionar columna") {
  1387.                 $rows[$i] = "null";
  1388.             }
  1389.         }
  1390.         
  1391.         $stringRows = json_encode($rows);
  1392.         
  1393.         $proveedorOrder = new ProveedorOrder();
  1395.         $proveedorOrder->setProveedorId($proveedorId);
  1396.         $proveedorOrder->setRowsOrder($stringRows);
  1397.         $proveedorOrder->setProductUploadId($prodUploadsId);
  1399.         $em->persist($proveedorOrder);
  1400.         $em->flush();
  1401.         
  1402.         //MUNTAR PRODUCTES
  1403.         
  1404.         //CARREGAR EL FILE I IMAGES
  1405.         $prodUploads = $em->getRepository(ProductUploads::class)->find($prodUploadsId);
  1406.         $file = $prodUploads->getFile();
  1407.         $images = $prodUploads->getImages();
  1408.         
  1409.         $filePath = 'assets/files/products/' . $file;
  1410.         $imagePath = 'assets/images/products/' . $images;
  1411.         $savePath = 'assets/images/products/';
  1412.         
  1413.         // CSV Decoder
  1414.         $csvEncoder = new CsvEncoder();
  1415.         $values = $csvEncoder->decode(file_get_contents($filePath), 'csv',[CsvEncoder::DELIMITER_KEY => ';']); //posar el ';'
  1416.         if (count($values[0]) == 1) {
  1417.             $values = $csvEncoder->decode(file_get_contents($filePath), 'csv',[CsvEncoder::DELIMITER_KEY => ',']);
  1418.         }
  1419.         //DESCOMPRIMIR LES IMATGES I BORRAR EL ZIP
  1420.         
  1421.         $zip = new \ZipArchive();
  1422.         if ($zip->open($imagePath) === TRUE) {
  1423.             $zip->extractTo($savePath);
  1424.             $zip->close();
  1425.         }
  1426.         
  1427.         foreach ($values as $key => $value) {
  1428.                 
  1429.             //$orderedValue = array_merge(array_flip($rows), $value);
  1430.             $index = [];
  1431.             foreach ($rows as $clave) {
  1432.                 $index[] = isset($value[$clave]) ? $value[$clave] : null;
  1433.             }
  1435.             $sku = array("sku" => "$index[2]");
  1436.             $product = $em->getRepository(Products::class)->findOneBy($sku);
  1437.             
  1438.             if (isset($index[0]) && $index[0] !== "") {
  1439.                 
  1440.                 if (!isset($product) && $product == "") {
  1441.                     $product = new Products();
  1442.                     $product->setDateCreated(new \DateTime());
  1443.                 }
  1444.                 //convert parent id into int
  1445.                 $parentIdInt = (int)$index[7];
  1447.                 //Setters
  1448.                 $product->setName(($index[0])?$index[0] : '');
  1449.                 $product->setEan(($index[1])?$index[1] : '');
  1450.                 if ($index[2] != null || $index[2] != "") {
  1451.                     $product->setSku($index[2]);
  1452.                 } else {
  1453.                     //Generate sku
  1454.                     $genSkuJson = $this->generateAutoSku();
  1455.                     $content = $genSkuJson->getContent();
  1456.                     $data = json_decode($content, true);
  1458.                     if ($sku["sku"] == null || $sku["sku"] == "") {
  1459.                         $product->setSku($data["sku"]);
  1460.                         } else {
  1461.                             $product->setSku($index[2]);
  1462.                     }
  1463.                 }
  1464.                 $product->setDescription(($index[3])?$index[3] : '');
  1465.                 $product->setPrice(($index[4])?floatval(str_replace(",",".",$index[4])) : 0);
  1466.                 $product->setIva(($index[5])?floatval($index[5]) : 0);
  1467.                 //$product->setDateCreated(new \DateTime());
  1468.                 $product->setParent((isset($parentIdInt) ? $parentIdInt : 0));
  1469.                 //wpId = $index[8]
  1470.                 $images = explode(",",$index[9]);
  1471.                 if($images){
  1472.                     $product->setImage($images[0]);
  1473.                 }
  1474.                 $product->setCostPrice((isset($index[10]) ? floatval($index[10]) : 0));
  1475.                 $product->setDateModify(new \DateTime());
  1476.                 //globalStock = $index[12]
  1477.                 $product->setWpStock((isset($index[13]) ? floatval($index[13]) : 0));
  1478.                 $product->setStoreStock((isset($index[14]) ? floatval($index[14]) : 0));
  1479.                 ////discount = $index[15]
  1480.                 if ($index[16] != "") {
  1481.                     $disc_from = \DateTime::createFromFormat('d/m/Y', $index[16]);
  1482.                     $product->setDiscountFrom($disc_from);
  1483.                 } else {
  1484.                     $product->setDiscountFrom(null);
  1485.                 }
  1486.                 if ($index[17] != "") {
  1487.                     $disc_to = \DateTime::createFromFormat('d/m/Y', $index[17]);
  1488.                     $product->setDiscountTo($disc_to);
  1489.                 } else {
  1490.                     $product->setDiscountTo(null);
  1491.                 }
  1492.                 $product->setStoreDiscount(($index[18] != "") ? $index[18] : 0 );
  1493.                 $product->setWebDiscount(($index[19] != "") ? $index[19] : 0);
  1494.                 //$product->setGlobalStock(floatval($index[14]) + floatval($index[13]));
  1495.                 $product->setGlobalStock((isset($index[14]) ? floatval($index[14]) : 0));
  1496.                 $product->setStatus(1);
  1498.                 $em->persist($product);
  1499.                 $f = $em->flush();
  1500.             }
  1501.         }
  1502.         
  1503.         if ($f == null) {
  1504.             $type = 1;
  1505.             $status = "Albaran subido correctamente";
  1506.         } else {
  1507.             $type = 0;
  1508.             $status = "Error al guardar el Albaran";
  1509.         }
  1511.         $this->session->getFlashBag()->add('type', $type);
  1512.         $this->session->getFlashBag()->add('status', $status);
  1513.         
  1514.         return $this->redirectToRoute('proveedor_albaranes', [ 'id' => $proveedorId ]);
  1515.     }
  1517.     public function syncStocksWeb(Request $request){
  1518.         $em = $this->getDoctrine()->getManager();
  1519.         if($request->get("page")){
  1520.             $paged = 20 * (intval($request->get("page"))-1);
  1521.         }else{
  1522.             $paged = 0;
  1523.         }
  1524.         
  1525.         $products = $em->createQueryBuilder()->select("p")
  1526.                 ->from(Products::class, "p")
  1527.                 ->where("p.wpId <> 'NULL'")
  1528.                 ->orderBy("p.id", "DESC") // Ordena por ID en orden descendente
  1529.                 ->setFirstResult($paged)
  1530.                 ->setMaxResults(20)
  1531.                 ->getQuery()
  1532.                 ->getResult();
  1533.         //dd(count($products));
  1534.         $wc = new WCController();
  1535.         foreach($products as $prod){
  1536.             $wc->updateProductToWP($prod, $em);
  1537.         }
  1538.         
  1539.         dd($products);
  1540.     }
  1541.     
  1542.     public function exportProductsStocks(Request $request){
  1543.         $entityManager = $this->getDoctrine()->getManager();
  1544.         
  1545.         $products = $entityManager->getRepository(Products::class)->findAll();
  1546.         
  1547.         $response = new StreamedResponse(function() use ($products) {
  1548.             $output = fopen('php://output', 'w');
  1549.             
  1550.             // Write headers
  1551.             fputcsv($output, [
  1552.                 'ID', 'Name', 'EAN', 'SKU', 'Description', 'Price', 'IVA', 'Date Created',
  1553.                 'Parent', 'WP ID', 'Image', 'Cost Price', 'Date Modified', 'Global Stock',
  1554.                 'Store Stock', 'Discount', 'Discount From', 'Discount To',
  1555.                 'Store Discount', 'Web Discount', 'Status', 'Gallery'
  1556.             ],";");
  1557.             
  1558.             // Write data
  1559.             foreach ($products as $product) {
  1560.                 fputcsv($output, [
  1561.                     $product->getId(),
  1562.                     $product->getName(),
  1563.                     $product->getEan(),
  1564.                     $product->getSku(),
  1565.                     $product->getDescription(),
  1566.                     number_format($product->getPrice(),2,",",""),
  1567.                     $product->getIva(),
  1568.                     $product->getDateCreated()->format('Y-m-d H:i:s'),
  1569.                     $product->getParent(),
  1570.                     $product->getWpId(),
  1571.                     $product->getImage(),
  1572.                     $product->getCostPrice(),
  1573.                     $product->getDateModify()->format('Y-m-d H:i:s'),
  1574.                     $product->getGlobalStock(),
  1575.                     
  1576.                     $product->getStoreStock(),
  1577.                     $product->getDiscount(),
  1578.                     $product->getDiscountFrom() ? $product->getDiscountFrom()->format('Y-m-d H:i:s') : '',
  1579.                     $product->getDiscountTo() ? $product->getDiscountTo()->format('Y-m-d H:i:s') : '',
  1580.                     $product->getStoreDiscount(),
  1581.                     $product->getWebDiscount(),
  1582.                     $product->getStatus(),
  1583.                     $product->getGallery()
  1584.                 ],";");
  1585.             }
  1586.             
  1587.             fclose($output);
  1588.         });
  1589.         
  1590.         $response->headers->set('Content-Type', 'text/csv; charset=utf-8');
  1591.         $response->headers->set('Content-Disposition', 'attachment; filename="products_export.csv"');
  1592.         
  1593.         return $response;
  1594.     }
  1595. }