src/Controller/User/UserProductController.php line 351

Open in your IDE?
  1. <?php
  3. namespace App\Controller\User;
  5. use App\Entity\Slave\JoinTableProductModelSupplier;
  6. use App\Entity\Slave\Product;
  7. use App\Entity\Slave\ProductCategory;
  8. use App\Entity\Slave\ProductComponent;
  9. use App\Entity\Slave\ProductModel;
  10. use App\Entity\Slave\ProductSubcategory;
  11. use App\Form\Model\RegenerateSupplier;
  12. use App\Form\Slave\JoinTableProductModelSupplierType;
  13. use App\Form\Slave\ProductCodeType;
  14. use App\Form\Slave\ProductDataType;
  15. use App\Form\Slave\ProductCategoryType;
  16. use App\Form\Slave\ProductComponentType;
  17. use App\Form\Slave\ProductModelEditType;
  18. use App\Form\Slave\ProductModelNewType;
  19. use App\Form\Slave\ProductModelSuppliersEditType;
  20. use App\Form\Slave\ProductSubcategoryType;
  21. use App\Form\Slave\RegenerateSupplierType;
  22. use App\Service\FilterService;
  23. use App\Service\FormValidatorService;
  24. use App\Service\MediaService;
  25. use App\Service\ProductService;
  26. use App\Service\UtilitiesService;
  27. use App\Service\ValidationService;
  28. use Doctrine\Persistence\ManagerRegistry;
  29. use Knp\Component\Pager\PaginatorInterface;
  30. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  31. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  32. use PhpOffice\PhpSpreadsheet\Cell\DataType;
  33. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Security;
  34. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  35. use Symfony\Component\DependencyInjection\ParameterBag\ParameterBagInterface;
  36. use Symfony\Component\HttpFoundation\ResponseHeaderBag;
  37. use Symfony\Component\HttpFoundation\StreamedResponse;
  38. use Symfony\Component\Filesystem\Filesystem;
  39. use Symfony\Component\Form\FormError;
  40. use Symfony\Component\Form\FormFactoryInterface;
  41. use Symfony\Component\PasswordHasher\Hasher\UserPasswordHasherInterface;
  42. use Symfony\Component\HttpFoundation\Request;
  43. use Symfony\Component\HttpFoundation\Response;
  44. use Symfony\Component\Routing\Annotation\Route;
  45. use Symfony\Component\Validator\Validator\ValidatorInterface;
  47. /**
  48.  * @Route("/scrivania/prodotti")
  49.  * @Security("is_granted('ROLE_USER') and is_granted('active', user) && is_granted('view', 'product')")
  50.  */
  51. class UserProductController extends AbstractController
  52. {
  53.     private $mr;
  54.     private $params;
  56.     public function __construct(ManagerRegistry $mr, ParameterBagInterface $params)
  57.     {
  58.         $this->mr = $mr;
  59.         $this->params = $params;
  60.     }
  62.     public function exportProducts($products)
  63.     {
  64.         $response = new StreamedResponse();
  66.         $response->setCallback(function() use($products) {
  67.             $handle = fopen('php://output', 'w+');
  68.             fputcsv($handle, array('Pos', 'Modello', 'Fornitori', 'Matricola produttore', 'Matricola fornitore', 'Termid', 'Stato', 'Condizione', 'Magazzino attuale', 'DDT', 'Data importazione', 'Data ultimo trasferimento', 'EPOSM id'), ";", '"', "\\");
  70.             foreach($products as $p){
  71.                 $pos = 'No';
  72.                 $model = '---';
  73.                 $suppliers = '---';
  74.                 $codeProducer = '';
  75.                 $codeSupplier = '';
  76.                 $termid = '---';
  77.                 $status = '---';
  78.                 $condition = '---';
  79.                 $warehouse = '---';
  80.                 $ddts = '---';
  81.                 $dateImport = '---';
  82.                 $dateLastTransfer = '---';
  84.                 if($p->getModel()->getSubcategory()->getCategory()->isPos()) $pos = 'Si';
  85.                 $model = $p->getModel()->getName().' - '.$p->getModel()->getSubcategory()->getName().' - '.$p->getModel()->getSubcategory()->getCategory()->getName();
  86.                 if(sizeof($p->getSuppliers()) > 0){
  87.                     $suppliers = "";
  88.                     $first = true;
  89.                     foreach($p->getSuppliers() as $s){
  90.                         if($first) $first = false; else $suppliers.= ', ';
  91.                         $suppliers.= $s->getName();
  92.                     }
  93.                 }
  94.                 if($p->getCodeProducer() != null) $codeProducer = $p->getCodeProducer();
  95.                 if($p->getCodeSupplier() != null) $codeSupplier = $p->getCodeSupplier();
  96.                 if($p->getTermid() != null) $termid = $p->getTermid()->getCode();
  97.                 if($p->getStatus() != null) $status = $p->getStatus()->getValue();
  98.                 if($p->getCondition() != null) $condition = $p->getCondition()->getValue();
  99.                 if($p->getActualWarehouse() != null) $warehouse = $p->getActualWarehouse()->getNickname();
  100.                 if($p->getDateCreation() != null) $dateImport = $p->getDateCreation()->format('d-m-Y');
  101.                 if($p->getDateLastTransfer() != null) $dateLastTransfer = $p->getDateLastTransfer()->format('d-m-Y H:i');
  102.                 $ddts = $p->displayTransfersDdts();
  104.                 fputcsv($handle, array($pos, $model, $suppliers, $codeProducer, $codeSupplier, $termid, $status, $condition, $warehouse, $ddts, $dateImport, $dateLastTransfer, $p->getId()), ";", '"', "\\");
  105.             }
  107.             fclose($handle);
  108.         });
  109.         
  110.         $response->setStatusCode(200);
  111.         $dispositionHeader = $response->headers->makeDisposition(ResponseHeaderBag::DISPOSITION_ATTACHMENT, 'Elenco prodotti.csv');
  112.         $response->headers->set('Content-Type', 'text/csv; charset=ISO-8859-15');
  113.         $response->headers->set('Content-Disposition', $dispositionHeader);
  114.         return $response;
  115.     }
  117.     public function exportStationaryProducts($products)
  118.     {
  119.         $response = new StreamedResponse();
  121.         $response->setCallback(function() use($products) {
  122.             $handle = fopen('php://output', 'w+');
  123.             fputcsv($handle, array('Pos', 'Modello', 'Fornitori', 'Matricola produttore', 'Matricola fornitore', 'Stato', 'Condizione', 'Magazzino attuale', 'DDT', 'Data ultimo trasferimento', 'EPOSM id'), ";", '"', "\\");
  125.             foreach($products as $p){
  126.                 $pos = 'No';
  127.                 $model = '---';
  128.                 $suppliers = '---';
  129.                 $codeProducer = '';
  130.                 $codeSupplier = '';
  131.                 $status = '---';
  132.                 $condition = '---';
  133.                 $warehouse = '---';
  134.                 $ddts = '---';
  135.                 $dateLastTransfer = '---';
  137.                 if($p->getModel()->getSubcategory()->getCategory()->isPos()) $pos = 'Si';
  138.                 $model = $p->getModel()->getName().' - '.$p->getModel()->getSubcategory()->getName().' - '.$p->getModel()->getSubcategory()->getCategory()->getName();
  139.                 if(sizeof($p->getSuppliers()) > 0){
  140.                     $suppliers = "";
  141.                     $first = true;
  142.                     foreach($p->getSuppliers() as $s){
  143.                         if($first) $first = false; else $suppliers.= ', ';
  144.                         $suppliers.= $s->getName();
  145.                     }
  146.                 }
  147.                 if($p->getCodeProducer() != null) $codeProducer = $p->getCodeProducer();
  148.                 if($p->getCodeSupplier() != null) $codeSupplier = $p->getCodeSupplier();
  149.                 if($p->getStatus() != null) $status = $p->getStatus()->getValue();
  150.                 if($p->getCondition() != null) $condition = $p->getCondition()->getValue();
  151.                 if($p->getActualWarehouse() != null) $warehouse = $p->getActualWarehouse()->getNickname();
  152.                 if($p->getDateLastTransfer() != null) $dateLastTransfer = $p->getDateLastTransfer()->format('d-m-Y H:i');
  153.                 $ddts = $p->displayTransfersDdts();
  155.                 fputcsv($handle, array($pos, $model, $suppliers, $codeProducer, $codeSupplier, $status, $condition, $warehouse, $ddts, $dateLastTransfer, $p->getId()), ";", '"', "\\");
  156.             }
  158.             fclose($handle);
  159.         });
  160.         
  161.         $response->setStatusCode(200);
  162.         $dispositionHeader = $response->headers->makeDisposition(ResponseHeaderBag::DISPOSITION_ATTACHMENT, 'Elenco prodotti.csv');
  163.         $response->headers->set('Content-Type', 'text/csv; charset=ISO-8859-15');
  164.         $response->headers->set('Content-Disposition', $dispositionHeader);
  165.         return $response;
  166.     }
  168.     public function exportRegeneratedProducts($rps)
  169.     {
  170.         $response = new StreamedResponse();
  171.         $response->setCallback(function() use($rps) {
  172.             $handle = fopen('php://output', 'w+');
  173.             fputcsv($handle, array('Data rigenerazione', 'Modello', 'Matricola produttore', 'Matricola fornitore', 'Fornitore', 'Ammontare'), ";", '"', "\\");
  175.             foreach($rps as $rp){
  176.                 $datetime = $rp->getDatetime()->format("d-m-Y H:i:s");
  177.                 $model = '---';
  178.                 $codeProducer = '';
  179.                 $codeSupplier = '';
  180.                 $supplier = '---';
  181.                 $amount = '---';
  183.                 if($rp->getProduct() != null) $model = $rp->getProduct()->getModel()->getName();
  184.                 if($rp->getProduct()->getCodeProducer() != null) $codeProducer = $rp->getProduct()->getCodeProducer();
  185.                 if($rp->getProduct()->getCodeSupplier() != null) $codeSupplier = $rp->getProduct()->getCodeSupplier();
  186.                 if($rp->getSupplier() != null) $supplier = $rp->getSupplier()->getName();
  187.                 if($rp->getSupplier() != null) $amount = $rp->getSupplier()->getAmountRegenerate();
  189.                 fputcsv($handle, array($datetime, $model, $codeProducer, $codeSupplier, $supplier, $amount), ";", '"', "\\");
  190.             }
  192.             fclose($handle);
  193.         });
  194.         
  195.         $response->setStatusCode(200);
  196.         $dispositionHeader = $response->headers->makeDisposition(ResponseHeaderBag::DISPOSITION_ATTACHMENT, 'Elenco prodotti rigenerati.csv');
  197.         $response->headers->set('Content-Type', 'text/csv; charset=ISO-8859-15');
  198.         $response->headers->set('Content-Disposition', $dispositionHeader);
  199.         return $response;
  200.     }
  202.     /**
  203.      * @Route("/", name="user_products")
  204.      * @Security("is_granted('view', 'product')")
  205.      */
  206.     public function userProducts(Request $request)
  207.     {    
  208.         return $this->render('role/user/product/index.html.twig');
  209.     }
  211.     // PRODOTTI
  212.         /**
  213.          * @Route("/ricerca", name="user_product_search")
  214.          * @Security("is_granted('view', 'product')")
  215.          */
  216.         public function userProductList(Request $request, ValidatorInterface $validator, PaginatorInterface $paginator, FormFactoryInterface $formFactory)
  217.         {    
  218.             $em = $this->mr->getManager('slave');
  219.             $session = $request->getSession();
  220.             $suppliers = $em->getRepository("App\Entity\Slave\Supplier")->findAllActiveOrdered();
  222.             $filters = FilterService::productFilter($request);
  223.             if($session->get('codeProducer') != null){
  224.                 $filters['codeProducer'] = $session->get('codeProducer');
  225.                 $session->remove('codeProducer');
  226.             }
  227.             if($session->get('codeSupplier') != null){
  228.                 $filters['codeSupplier'] = $session->get('codeSupplier');
  229.                 $session->remove('codeSupplier');
  230.             }
  231.             $productsQuery = $em->getRepository("App\Entity\Slave\Product")->findFiltered(true, $filters);
  232.             $productsCountQuery = clone $productsQuery;
  233.             $products = $paginator->paginate($productsQuery, $request->getSession()->get($request->get("_route")."_page"), 50);
  235.             $productModels = $em->getRepository('App\Entity\Slave\ProductModel')->findAllOrdered();
  237.             return $this->render('role/user/product/search.html.twig', [
  238.                 "filters" => $filters,
  239.                 "products" => $products,
  240.                 "suppliers" => $suppliers,
  241.                 "productModels" => $productModels
  242.             ]);
  243.         }
  245.         /**
  246.          * @Route("/ricerca/esporta-filtro-csv", name="user_product_search_filter_export")
  247.          * @Security("is_granted('view', 'product')")
  248.          */
  249.         public function userProductSearchFilterExport(Request $request)
  250.         {    
  251.             $em = $this->mr->getManager('slave');
  252.             $session = $request->getSession();
  253.             $filters = $session->get('user_product_search_filters');
  254.             $products = $em->getRepository("App\Entity\Slave\Product")->findFiltered(false, $filters);
  255.             return $this->exportProducts($products);
  256.         }
  258.         /**
  259.          * @Route("/ricerca/esporta-per-invio", name="user_product_search_for_send_export")
  260.          * @Security("is_granted('view', 'product')")
  261.          */
  262.         public function userProductSearchForSendExport(Request $request)
  263.         {    
  264.             $em = $this->mr->getManager('slave');
  265.             $session = $request->getSession();
  266.             $filters = $session->get('user_product_search_filters');
  267.             $products = $em->getRepository("App\Entity\Slave\Product")->findFiltered(false, $filters);
  268.             $response = new StreamedResponse();
  269.     
  270.             $response->setCallback(function() use($products) {
  271.                 $handle = fopen('php://output', 'w+');
  272.                 fputcsv($handle, array('Matricola produttore', 'Matricola fornitore'), ";", '"', "\\");
  273.     
  274.                 foreach($products as $p){
  275.                     $codeProducer = '';
  276.                     $codeSupplier = '';
  277.                     if($p->getCodeProducer() != null) $codeProducer = $p->getCodeProducer();
  278.                     if($p->getCodeSupplier() != null) $codeSupplier = $p->getCodeSupplier();
  280.                     fputcsv($handle, array($codeProducer, $codeSupplier), ";", '"', "\\");
  281.                 }
  282.     
  283.                 fclose($handle);
  284.             });
  285.             
  286.             $response->setStatusCode(200);
  287.             $dispositionHeader = $response->headers->makeDisposition(ResponseHeaderBag::DISPOSITION_ATTACHMENT, 'Elenco prodotti per invio.csv');
  288.             $response->headers->set('Content-Type', 'text/csv; charset=ISO-8859-15');
  289.             $response->headers->set('Content-Disposition', $dispositionHeader);
  290.             return $response;
  291.         }
  293.         /**
  294.          * @Route("/ricerca/selezione-multipla-azione", name="user_product_multiple_select_action")
  295.          * @Security("is_granted('edit', 'product')")
  296.          */
  297.         public function userProductMultipleSelectAction(Request $request)
  298.         {    
  299.             $em = $this->mr->getManager('slave');
  300.             $session = $request->getSession();
  301.             $productIds = explode(',', $request->request->get('ids'));
  302.             $action = $request->request->get('action');
  304.             switch($action){
  305.                 case 'model':
  306.                     $productModel = $em->getRepository('App\Entity\Slave\ProductModel')->findOneById($request->request->get('productModelId'));
  307.                     foreach($productIds as $id){
  308.                         $product = $em->getRepository('App\Entity\Slave\Product')->findOneById($id);
  309.                         $product->setModel($productModel);
  310.                     }
  311.                     $em->flush();
  312.                     $this->addFlash('notice_success', 'Modello prodotti aggiornato!');
  313.                     return $this->redirectToRoute('user_product_search');
  314.                     break;
  315.                 case 'delete':
  316.                     $countDeleted = 0;
  317.                     $countIgnored = 0;
  318.                     foreach($productIds as $id){
  319.                         $product = $em->getRepository('App\Entity\Slave\Product')->findOneById($id);
  320.                         if($product->canDelete()){
  321.                             foreach($product->getTransfers() as $jt) $em->remove($jt);
  322.                             foreach($product->getTransferLogs() as $tLog) $em->remove($tLog);
  323.                             foreach($product->getLogs() as $log) $em->remove($log);
  324.                             $em->remove($product);
  325.                             $countDeleted++;
  326.                         }
  327.                         else{
  328.                             $countIgnored++;
  329.                         }
  330.                     }
  331.                     $em->flush();
  332.                     $this->addFlash('notice_success', 'Eliminati '.$countDeleted.' prodotti e ignorati '.$countIgnored.' prodotti non eliminabili!');
  333.                     return $this->redirectToRoute('user_product_search');
  334.                     break;
  335.                 case 'export':
  336.                     $products = array();
  337.                     foreach($productIds as $id){
  338.                         $p = $em->getRepository('App\Entity\Slave\Product')->findOneById($id);
  339.                         array_push($products, $p);
  340.                     }
  341.                     return $this->exportProducts($products);
  342.                     break;
  343.                 default: break;
  344.             }            
  345.         }
  347.         /**
  348.          * @Route("/{productId}/scheda", name="user_product_sheet")
  349.          * @Security("is_granted('view', 'product')")
  350.          */
  351.         public function userProductSheet($productId, Request $request, ValidatorInterface $validator, FormFactoryInterface $formFactory, UserPasswordHasherInterface $passwordHasher)
  352.         {    
  353.             $em = $this->mr->getManager('slave');
  354.             $emMaster = $this->mr->getManager('master');
  355.             $session = $request->getSession();
  356.             $company = $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get("companyId"));
  357.             
  358.             $product = $em->getRepository("App\Entity\Slave\Product")->findOneById($productId);
  359.             $stCoLogs = array();
  360.             $codeLogs = array();
  361.             foreach($product->getLogs() as $log){
  362.                 switch($log->getType()){
  363.                     case 'status':
  364.                     case 'condition':
  365.                         array_push($stCoLogs, $log);
  366.                         break;
  367.                     case 'code-producer':
  368.                     case 'code-supplier':
  369.                         array_push($codeLogs, $log);
  370.                         break;
  371.                     default: break;
  372.                 }
  373.             }
  375.             $oldConditionId = $product->getCondition()->getId();
  376.             $oldStatusId = $product->getStatus()->getId();
  378.             // Modifica dati
  379.             $formData = $formFactory->createNamed("form_product_data_edit", ProductDataType::class, $product);
  380.             $formData->handleRequest($request);
  382.             if($formData->isSubmitted()){
  384.                 if($formData->isValid()){
  385.                                         
  386.                     if($formData->get('condition')->getData()->getId() != $oldConditionId){
  387.                         ProductService::productChangeCondition($em, $this->getUser(), $product, $formData->get('condition')->getData());
  388.                     }
  389.                     
  390.                     $em->flush();
  392.                     $this->addFlash('notice_success', "Dati prodotto aggiornati!");
  393.                     return $this->redirectToRoute('user_product_sheet', array('productId' => $product->getId()));
  394.                 }
  395.                 else{
  396.                     $session->set('openEditDataModal', true);
  397.                     $session->set('openEditDataModalId', $request->request('productCodeEditId'));
  398.                 }
  399.             }
  401.             // Modifica codici
  402.             $formCode = $formFactory->createNamed("form_product_code_edit", ProductCodeType::class, $product);
  403.             $formCode->handleRequest($request);
  405.             if($formCode->isSubmitted()){
  407.                 $valid = ValidationService::validateNotBlank($validator, $formCode->get('password'));
  408.                 if($valid && !($passwordHasher->isPasswordValid($this->getUser(), $formCode->get('password')->getData()))){
  409.                     $valid = false;
  410.                     $formCode->get('password')->addError(new FormError('Password errata!'));
  411.                 }
  412.                 if($valid && ($formCode->get('codeProducer')->getData() == null && $formCode->get('codeSupplier')->getData() == null)){
  413.                     $valid = false;
  414.                     $formCode->get('codeProducer')->addError(new FormError('Inserisci almeno un codice matricola!'));
  415.                     $formCode->get('codeSupplier')->addError(new FormError('Inserisci almeno un codice matricola!'));
  416.                 }
  417.                 if($valid) $valid = ValidationService::validateNotBlankType3($validator, $formCode->get('warehouseId'), $formCode->get('warehouseSearchNickname'), $formCode->get('warehouseSearchTermid'));
  418.                 if($valid && $formCode->get('codeProducer')->getData() != '') {
  419.                     $prod = $em->getRepository('App\Entity\Slave\Product')->findOneBy(['codeProducer' => $formCode->get('codeProducer')->getData()]);
  420.                     if($prod != null && $prod->getId() != $product->getId()){
  421.                         $valid = false;
  422.                         $formCode->get('codeProducer')->addError(new FormError('Esiste già un altro prodotto con la matricola '.$formCode->get('codeProducer')->getData().'!'));
  423.                     }
  424.                 }
  425.                 if($valid && $formCode->get('codeSupplier')->getData() != '') {
  426.                     $prod = $em->getRepository('App\Entity\Slave\Product')->findOneBy(['codeSupplier' => $formCode->get('codeSupplier')->getData()]);
  427.                     if($prod != null && $prod->getId() != $product->getId()){
  428.                         $valid = false;
  429.                         $formCode->get('codeSupplier')->addError(new FormError('Esiste già un altro prodotto con la matricola '.$formCode->get('codeSupplier')->getData().'!'));
  430.                     }
  431.                 }
  433.                 if($valid && $formCode->isValid()){
  434.                     
  435.                     if($product->getCodeProducer() != $formCode->get('codeProducer')->getData()){
  436.                         ProductService::createProductLog($em, $product, $this->getUser(), null, 'code-producer', $product->getCodeProducer(), $formCode->get('codeProducer')->getData());
  437.                         $product->setCodeProducer($formCode->get('codeProducer')->getData());
  438.                     }
  439.                     
  440.                     if($product->getCodeSupplier() != $formCode->get('codeSupplier')->getData()){
  441.                         ProductService::createProductLog($em, $product, $this->getUser(), null, 'code-supplier', $product->getCodeSupplier(), $formCode->get('codeSupplier')->getData());
  442.                         $product->setCodeSupplier($formCode->get('codeSupplier')->getData());
  443.                     }
  445.                     if($product->getActualWarehouse()->getId() != $formCode->get('warehouseId')->getData()){
  446.                         $fromClient = false;
  447.                         $toClient = false;
  448.                         if($product->getActualWarehouse()->getClient() != null)
  449.                             $fromClient = true;
  450.                         
  451.                         $newWarehouse = $em->getRepository('App\Entity\Slave\Warehouse')->findOneById($formCode->get('warehouseId')->getData());
  452.                         
  453.                         if($newWarehouse->getClient() != null)
  454.                             $toClient = true;
  456.                         if($fromClient != $toClient){
  457.                             $oldCondition = $product->getCondition();
  458.                             $oldStatus = $product->getStatus();
  459.                             $statusInUse = $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBySlug("in_use");
  460.                             $statusNotAvailable = $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBySlug("not_available");
  461.                             $conditionRetired = $em->getRepository('App\Entity\Slave\ProductCondition')->findOneBySlug("retired");
  462.                             $conditionFree = $em->getRepository('App\Entity\Slave\ProductCondition')->findOneBySlug("free");
  463.                             if($fromClient){
  464.                                 $product->setStatus($statusNotAvailable);
  465.                                 $product->setCondition($conditionRetired);
  466.                                 if($oldStatus->getId() != $statusNotAvailable->getId())
  467.                                     ProductService::createProductLog($em, $product, $this->getUser(), null, 'status', $oldStatus->getValue(), $statusNotAvailable->getValue());
  468.                                 if($oldCondition->getId() != $conditionRetired->getId())
  469.                                     ProductService::createProductLog($em, $product, $this->getUser(), null, 'condition', $oldCondition->getValue(), $conditionRetired->getValue());
  470.                             }
  471.                             else{
  472.                                 $product->setStatus($statusInUse);
  473.                                 $product->setCondition($conditionFree);
  474.                                 if($oldStatus->getId() != $statusInUse->getId())
  475.                                     ProductService::createProductLog($em, $product, $this->getUser(), null, 'status', $oldStatus->getValue(), $statusInUse->getValue());
  476.                                 if($oldCondition->getId() != $conditionFree->getId())
  477.                                     ProductService::createProductLog($em, $product, $this->getUser(), null, 'condition', $oldCondition->getValue(), $conditionFree->getValue());
  478.                             }
  479.                         }
  480.                         ProductService::createProductTransferLog($em, $product, null, $this->getUser(), $newWarehouse, new \Datetime(), 'forced_password');
  481.                         $product->setActualWarehouse($newWarehouse);
  482.                         
  483.                         $product->setDateLastTransfer(new \Datetime());
  484.                         $product->isToManage(false);
  485.                         $product->setToManagePriority(0);
  486.                     }
  487.                     $em->flush();
  489.                     $this->addFlash('notice_success', "Dati prodotto aggiornati!");
  490.                     return $this->redirectToRoute('user_product_sheet', array('productId' => $product->getId()));
  491.                 }
  492.                 else{
  493.                     $session->set('openEditCodeModal', true);
  494.                     $session->set('openEditCodeModalId', $request->request->get('productDataEditId'));
  495.                 }
  496.             }
  498.             return $this->render('role/user/product/sheet.html.twig', [
  499.                 "company" => $company,
  500.                 "product" => $product,
  501.                 "stCoLogs" => $stCoLogs,
  502.                 "codeLogs" => $codeLogs,
  503.                 "formCode" => $formCode->createView(),
  504.                 "formData" => $formData->createView()
  505.             ]);
  506.         }
  507.         
  508.         /**
  509.          * @Route("/aggiorna-stato", name="user_product_change_active")
  510.          * @Security("is_granted('edit', 'product')")
  511.          */
  512.         public function userAnagraphicProductChangeActive(Request $request)
  513.         {    
  514.             $em = $this->mr->getManager('slave');
  515.             $session = $request->getSession();
  516.             $product = $em->getRepository("App\Entity\Slave\Product")->findOneById($request->request->get("productChangeId"));
  517.             $product->setActive(!$product->isActive());
  518.             $em->flush();
  519.             
  520.             $this->addFlash('notice_success', "Stato aggiornato");
  521.             return $this->redirectToRoute('user_product_search');
  522.         }
  524.         /**
  525.          * @Route("/elimina", name="user_product_search_delete")
  526.          * @Security("is_granted('edit', 'product')")
  527.          */
  528.         public function userProductListDelete(Request $request)
  529.         {    
  530.             $em = $this->mr->getManager('slave');
  531.             $product = $em->getRepository("App\Entity\Slave\Product")->findOneById($request->request->get("productDelId"));
  532.             $em->remove($product);
  533.             $em->flush();
  535.             $this->addFlash('notice_success', "Prodotto eliminato");
  536.             return $this->redirectToRoute('user_product_search');
  537.         }
  538.                 
  539.         /**
  540.          * @Route("/fermi", name="user_product_stationary")
  541.          * @Security("is_granted('edit', 'product')")
  542.          */
  543.         public function userProductStationary(Request $request, PaginatorInterface $paginator, FormFactoryInterface $formFactory, ValidatorInterface $validator)
  544.         {    
  545.             $em = $this->mr->getManager('slave');
  546.             $session = $request->getSession();
  547.             $settingDaysStationary = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'days_stationary'));
  548.             $suppliers = $em->getRepository("App\Entity\Slave\Supplier")->findAllActiveOrdered();
  550.             $filters = FilterService::productStationaryFilter($request);
  551.             $productsQuery = $em->getRepository("App\Entity\Slave\Product")->findStationaryFiltered(true, $filters, new \Datetime(), $settingDaysStationary->getValue());
  552.             $productsStationary = $paginator->paginate($productsQuery, $request->getSession()->get($request->get("_route")."_page"), 50);
  554.             return $this->render('role/user/product/stationary.html.twig', [
  555.                 "filters" => $filters,
  556.                 "suppliers" => $suppliers,
  557.                 "productsStationary" => $productsStationary
  558.             ]);
  559.         }
  561.         /**
  562.          * @Route("/fermi/esporta-filtro-csv", name="user_product_stationary_filter_export")
  563.          * @Security("is_granted('view', 'product')")
  564.          */
  565.         public function userProductStationaryFilterExport(Request $request)
  566.         {    
  567.             $em = $this->mr->getManager('slave');
  568.             $session = $request->getSession();
  569.             $settingDaysStationary = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'days_stationary'));
  571.             $filters = $session->get('user_product_stationary_filters');
  572.             $products = $em->getRepository("App\Entity\Slave\Product")->findStationaryFiltered(false, $filters, new \Datetime(), $settingDaysStationary->getValue());
  573.             return $this->exportStationaryProducts($products);
  574.         }
  576.         /**
  577.          * @Route("/fermi/selezione-multipla-azione", name="user_product_stationary_multiple_select_action")
  578.          * @Security("is_granted('edit', 'product')")
  579.          */
  580.         public function userProductStationaryMultipleSelectAction(Request $request)
  581.         {    
  582.             $em = $this->mr->getManager('slave');
  583.             $session = $request->getSession();
  584.             $productIds = explode(',', $request->request->get('ids'));
  585.             $action = $request->request->get('action');
  587.             switch($action){
  588.                 case 'export':
  589.                     $products = array();
  590.                     foreach($productIds as $id){
  591.                         $p = $em->getRepository('App\Entity\Slave\Product')->findOneById($id);
  592.                         array_push($products, $p);
  593.                     }
  594.                     return $this->exportStationaryProducts($products);
  595.                     break;
  596.                 default: break;
  597.             }            
  598.         }
  600.         /**
  601.          * @Route("/rigenerati", name="user_product_regenerated")
  602.          * @Security("is_granted('view', 'product')")
  603.          */
  604.         public function userProductRegenerated(Request $request, PaginatorInterface $paginator, FormFactoryInterface $formFactory, ValidatorInterface $validator)
  605.         {    
  606.             $em = $this->mr->getManager('slave');
  607.             $openModal = false;
  608.             $openModalId = null;
  609.             $session = $request->getSession();
  610.                         
  611.             $filters = FilterService::productRegeneratedFilter($request);
  612.             $toRegenerateQuery = $em->getRepository("App\Entity\Slave\ProductRegenerated")->findFiltered(true, $filters, false);
  613.             $toRegenerateProducts = $paginator->paginate($toRegenerateQuery, $request->getSession()->get($request->get("_route")."_page"), 50);
  614.             
  615.             $regenerateQuery = $em->getRepository('App\Entity\Slave\ProductRegenerated')->findFiltered(true, $filters, true);
  616.             $regeneratedProducts = $paginator->paginate($regenerateQuery, $request->getSession()->get($request->get("_route")."_page"), 50);
  618.             $regenerateSupplier = new RegenerateSupplier();
  619.             $form = $formFactory->createNamed("form_regenerate", RegenerateSupplierType::class, $regenerateSupplier);
  620.             $form->handleRequest($request);
  622.             if($form->isSubmitted()){
  624.                 $valid = ValidationService::ValidateNotBlank($validator, $form->get('supplier'));
  626.                 if($form->isValid() && $valid){
  628.                     $supplier = $em->getRepository('App\Entity\Slave\Supplier')->findOneById($form->get('supplier')->getData());
  629.                     $productRegenerated = $em->getRepository('App\Entity\Slave\ProductRegenerated')->findOneById($request->request->get('productRegeneratedId'));
  630.                     $productRegenerated->setSupplier($supplier);
  631.                     $em->flush();
  633.                     $this->addFlash('notice_success', "Fornitore aggiornato!");
  634.                     return $this->redirectToRoute('user_product_regenerated');
  635.                 }
  636.                 else{
  637.                     $openModal = true;
  638.                     $openModalId = $request->request->get('productRegeneratedId');
  639.                 }
  640.             }
  642.             return $this->render('role/user/product/regenerated.html.twig', [
  643.                 "filters" => $filters,
  644.                 "openModal" => $openModal,
  645.                 "openModalId" => $openModalId,
  646.                 "toRegenerateProducts" => $toRegenerateProducts,
  647.                 "regeneratedProducts" => $regeneratedProducts,
  648.                 'form' => $form->createView()
  649.             ]);
  650.         }
  652.         /**
  653.          * @Route("/rigenerati/esporta-filtro-csv/{hasSupplier}", name="user_product_regenerated_filter_export")
  654.          * @Security("is_granted('view', 'product')")
  655.          */
  656.         public function userProductRegeneratedFilterExport(Request $request, $hasSupplier)
  657.         {    
  658.             $em = $this->mr->getManager('slave');
  659.             $session = $request->getSession();
  660.             $filters = $session->get('user_product_regenerated_filters');
  661.             $regeneratedProducts = $em->getRepository("App\Entity\Slave\ProductRegenerated")->findFiltered(false, $filters, $hasSupplier);
  663.             return $this->exportRegeneratedProducts($regeneratedProducts);
  664.         }
  666.         /**
  667.          * @Route("/rigenerati/stampa-etichette/{hasSupplier}", name="user_product_regenerated_print_labels")
  668.          * @Security("is_granted('view', 'product')")
  669.          */
  670.         public function userProductRegeneratedPrintLabels(Request $request, $hasSupplier)
  671.         {    
  672.             $em = $this->mr->getManager('slave');
  673.             $session = $request->getSession();
  674.             $filters = $session->get('user_product_regenerated_filters');
  675.             $regeneratedProducts = $em->getRepository("App\Entity\Slave\ProductRegenerated")->findFiltered(false, $filters, true);
  677.             return $this->render('role/user/print/regenerated_products_labels.html.twig', [
  678.                 "regeneratedProducts" => $regeneratedProducts
  679.             ]);
  680.         }
  682.         /**
  683.          * @Route("/rigenerati/elimina", name="user_product_regenerated_delete")
  684.          * @Security("is_granted('edit', 'product')")
  685.          */
  686.         public function userProductRegeneratedDelete(Request $request)
  687.         {    
  688.             $em = $this->mr->getManager('slave');
  689.             $productRegenerated = $em->getRepository("App\Entity\Slave\ProductRegenerated")->findOneById($request->request->get("productRegeneratedDelId"));
  690.             $em->remove($productRegenerated);
  691.             $em->flush();
  693.             $this->addFlash('notice_success', "Rigenerazione prodotto eliminata");
  694.             return $this->redirectToRoute('user_product_regenerated');
  695.         }
  696.     //
  697.     
  698.     // MODELLI
  699.         /**
  700.          * @Route("/modelli", name="user_product_models")
  701.          * @Security("is_granted('view', 'product_model')")
  702.          */
  703.         public function userProductModels(Request $request, ValidatorInterface $validator, PaginatorInterface $paginator, FormFactoryInterface $formFactory, FileSystem $fs)
  704.         {    
  705.             $emMaster = $this->mr->getManager('master');
  706.             $session = $request->getSession();
  707.             $company = $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get("companyId"));
  709.             $em = $this->mr->getManager('slave');
  710.             $suppliers = $em->getRepository("App\Entity\Slave\Supplier")->findAllActiveOrdered();
  711.             $components = $em->getRepository('App\Entity\Slave\ProductComponent')->findAll();
  713.             $filters = FilterService::productModelFilter($request);
  714.             $modelsQuery = $em->getRepository("App\Entity\Slave\ProductModel")->queryFiltered($filters);
  715.             $models = $paginator->paginate($modelsQuery, $request->getSession()->get($request->get("_route")."_page"), 15);
  716.             $uploadDir = $this->params->get('kernel.project_dir').'/'.$this->params->get('web_path').'/companies/'.$company->getDirectoryPath().'/product_models/';
  718.             $model = new ProductModel();
  719.             $form = $formFactory->createNamed("form_model_new", ProductModelNewType::class, $model);
  720.             $form->handleRequest($request);
  722.             if($form->isSubmitted()){
  723.                 $valid = ValidationService::validateNotDuplicate($validator, $form->get("name"), $em, "App\Entity\Slave\ProductModel", ['id' => 0]);
  724.                 if($valid) $valid = ValidationService::validateFile($validator, $form->get('imagePath'), false, $form->get('file')->getData(), '3', array('png', 'jpeg', 'jpg', 'webp'));
  726.                 if($valid && $form->isValid()){
  727.                     
  728.                     MediaService::uploadImage($fs, $form->get('file')->getData(), null, $uploadDir, $model, 'image', 100, 1000, 200, true);
  729.                     $em->persist($model);
  730.                     $em->flush();
  731.                     
  732.                     $model->setInternalCode(UtilitiesService::generateModelInternalCode($model->getId()));
  733.                     foreach($form->get('suppliers') as $formSupplier){
  734.                         if($formSupplier->getData()){
  735.                             $jt = new JoinTableProductModelSupplier();
  736.                             $jt->setModel($model);
  737.                             $jt->setSupplier($em->getRepository('App\Entity\Slave\Supplier')->findOneByid($formSupplier->getName()));
  738.                             $jt->setAlarmStockActive($em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'product_model_default_stock_active'))->getValue());
  739.                             $jt->setAlarmStockYellow($em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'product_model_default_stock_yellow'))->getValue());
  740.                             $jt->setAlarmStockRed($em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'product_model_default_stock_red'))->getValue());
  741.                             $em->persist($jt);
  742.                         }
  743.                     }
  744.                     $em->flush();
  746.                     $this->addFlash('notice_success', "Modello inserito");
  747.                     return $this->redirectToRoute('user_product_model_sheet', array('modelId' => $model->getId()));
  748.                 }
  749.                 else
  750.                     $session->set('openNewModal', true);
  751.             }
  753.             return $this->render('role/user/product/models.html.twig', [
  754.                 "company" => $company,
  755.                 "suppliers" => $suppliers,
  756.                 "components" => $components,
  757.                 "filters" => $filters,
  758.                 "models" => $models,
  759.                 "form" => $form->createView()
  760.             ]);
  761.         }
  763.         /**
  764.          * @Route("/modelli/duplica", name="user_product_model_duplicate")
  765.          * @Security("is_granted('edit', 'product_model')")
  766.          */
  767.         public function userProductModelDuplicate(Request $request, FileSystem $fs)
  768.         {    
  769.             $em = $this->mr->getManager('slave');
  770.             $emMaster = $this->mr->getManager('master');
  771.             $session = $request->getSession();
  772.             $company = $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get("companyId"));
  774.             $modelDuplicate = $em->getRepository("App\Entity\Slave\ProductModel")->findOneById($request->request->get("modelId"));
  775.             $uploadDir = $this->params->get('kernel.project_dir').'/'.$this->params->get('web_path').'/companies/'.$company->getDirectoryPath().'/product_models/';
  776.             if($modelDuplicate->getImagePath() != null){
  777.                 $ext = explode('.', $modelDuplicate->getImagePath())[1];
  778.                 $fileName = md5(uniqid()).'.'.$ext;
  779.             }
  781.             $model = new ProductModel();
  782.             $model->setSubcategory($modelDuplicate->getSubcategory());
  783.             $model->setProducer($modelDuplicate->getProducer());
  784.             $model->setName('000-'.$modelDuplicate->getName());
  785.             $model->setSku($modelDuplicate->getSku());
  786.             $model->setPartNumber($modelDuplicate->getPartNumber());
  787.             if($modelDuplicate->getImagePath() != null){
  788.                 $model->setImagePath($fileName);
  789.                 $fs->copy($uploadDir.$modelDuplicate->getImagePath(), $uploadDir.$fileName, true);
  790.                 $fs->copy($uploadDir.'thumb_'.$modelDuplicate->getImagePath(), $uploadDir.'thumb_'.$fileName, true);
  791.             }
  792.             $em->persist($model);
  793.             
  794.             foreach($modelDuplicate->getComponents() as $com){
  795.                 $model->addComponent($com);
  796.             }
  798.             $model->setInternalCode(UtilitiesService::generateModelInternalCode($model->getId()));
  799.             $em->flush();
  801.             $this->addFlash('notice_success', "Modello duplicato");
  802.             return $this->redirectToRoute('user_product_models');
  803.         }
  804.         
  805.         /**
  806.          * @Route("/modelli/elimina", name="user_product_model_delete")
  807.          * @Security("is_granted('edit', 'product_model')")
  808.          */
  809.         public function userProductModelDelete(Request $request, FileSystem $fs)
  810.         {    
  811.             $em = $this->mr->getManager('slave');
  812.             $emMaster = $this->mr->getManager('master');
  813.             $session = $request->getSession();
  814.             $company = $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get("companyId"));
  815.             $model = $em->getRepository("App\Entity\Slave\ProductModel")->findOneById($request->request->get("modelDelId"));
  816.             $uploadDir = $this->params->get('kernel.project_dir').'/'.$this->params->get('web_path').'/companies/'.$company->getDirectoryPath().'/product_models/';
  818.             foreach($model->getSuppliers() as $jt)
  819.                 $em->remove($jt);
  821.             MediaService::removeImage($fs, $model->getImagePath(), $uploadDir);
  822.             $em->remove($model);
  823.             $em->flush();
  825.             $this->addFlash('notice_success', "Modello eliminato");
  826.             return $this->redirectToRoute('user_product_models');
  827.         }
  828.         
  829.         /**
  830.          * @Route("/modelli/{modelId}/scheda", name="user_product_model_sheet")
  831.          * @Security("is_granted('view', 'product_model')")
  832.          */
  833.         public function userProductModelSheet($modelId, Request $request, ValidatorInterface $validator, FormFactoryInterface $formFactory, FileSystem $fs)
  834.         {    
  835.             $emMaster = $this->mr->getManager('master');
  836.             $session = $request->getSession();
  837.             $company = $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get("companyId"));
  839.             $em = $this->mr->getManager('slave');
  840.             $model = $em->getRepository('App\Entity\Slave\ProductModel')->findOneById($modelId);
  841.             $components = $em->getRepository('App\Entity\Slave\ProductComponent')->findAll();
  842.             $uploadDir = $this->params->get('kernel.project_dir').'/'.$this->params->get('web_path').'/companies/'.$company->getDirectoryPath().'/product_models/';
  844.             $form = $formFactory->createNamed("form_model_edit", ProductModelEditType::class, $model);
  845.             $form->handleRequest($request);
  847.             if($form->isSubmitted()){
  848.                 $valid = ValidationService::validateNotDuplicate($validator, $form->get("name"), $em, "App\Entity\Slave\ProductModel", ['id' => $model->getId()]);
  849.                 if($valid) $valid = ValidationService::validateFile($validator, $form->get('imagePath'), false, $form->get('file')->getData(), '3', array('png', 'jpeg', 'jpg', 'webp'));
  851.                 if($valid && $form->isValid()){
  853.                     MediaService::uploadImage($fs, $form->get('file')->getData(), null, $uploadDir, $model, 'image', 100, 1000, 200, true);
  855.                     $oldSuppliersIds = array();
  856.                     $newSuppliersIds = array();
  857.                     foreach($model->getSuppliers() as $jt){
  858.                         array_push($oldSuppliersIds, $jt->getSupplier()->getId());
  859.                     }
  860.                     foreach($form->get('suppliers') as $formSupplier){
  861.                         if($formSupplier->getData()){
  862.                             if(!in_array($formSupplier->getName(), $oldSuppliersIds)){
  863.                                 $jt = new JoinTableProductModelSupplier();
  864.                                 $jt->setModel($model);
  865.                                 $jt->setSupplier($em->getRepository('App\Entity\Slave\Supplier')->findOneByid($formSupplier->getName()));
  866.                                 $jt->setAlarmStockActive($em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'product_model_default_stock_active'))->getValue());
  867.                                 $jt->setAlarmStockYellow($em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'product_model_default_stock_yellow'))->getValue());
  868.                                 $jt->setAlarmStockRed($em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'product_model_default_stock_red'))->getValue());
  869.                                 $em->persist($jt);
  870.                             }
  871.                             array_push($newSuppliersIds, $formSupplier->getName());
  872.                         }
  873.                     }
  874.                     foreach($oldSuppliersIds as $oldId){
  875.                         if(!in_array($oldId, $newSuppliersIds)){
  876.                             $oldJtpms = $em->getRepository('App\Entity\Slave\JoinTableProductModelSupplier')->findOneByModelAndSupplier($model->getId(), $oldId);
  877.                             $em->remove($oldJtpms);
  878.                         }
  879.                     }
  880.                     
  881.                     $em->flush();
  883.                     $this->addFlash('notice_success', "Modifiche salvate");
  884.                     return $this->redirectToRoute('user_product_model_sheet', array('modelId' => $model->getId()));
  885.                 }
  886.                 else{
  887.                     $session->set('openEditModal', true);
  888.                 }
  889.             }
  891.             $jtpms = new JoinTableProductModelSupplier();
  892.             $formJtpmsEdit = $formFactory->createNamed("form_jtpms_edit", JoinTableProductModelSupplierType::class, $jtpms);
  893.             $formJtpmsEdit->handleRequest($request);
  895.             if($formJtpmsEdit->isSubmitted()){
  897.                 $valid = FormValidatorService::validateJtpms($formJtpmsEdit, true, null);
  899.                 if($valid && $formJtpmsEdit->isValid()){
  900.                     
  901.                     $jtpmsEdit = $em->getRepository('App\Entity\Slave\JoinTableProductModelSupplier')->findOneById($request->request->get('jtpmsEditId'));
  902.                     $jtpmsEdit->setAlarmStockActive($formJtpmsEdit->get('alarmStockActive')->getData());
  903.                     if($formJtpmsEdit->get('alarmStockActive')->getData()){
  904.                         $jtpmsEdit->setAlarmStockYellow($formJtpmsEdit->get('alarmStockYellow')->getData());
  905.                         $jtpmsEdit->setAlarmStockRed($formJtpmsEdit->get('alarmStockRed')->getData());
  906.                     }
  907.                     else{
  908.                         $jtpmsEdit->setAlarmStockYellow(null);
  909.                         $jtpmsEdit->setAlarmStockRed(null);
  910.                     }
  911.                     $em->flush();
  913.                     $this->addFlash('notice_success', "Scorte aggiornate");
  914.                     return $this->redirectToRoute('user_product_model_sheet', array('modelId' => $model->getId()));
  915.                 }
  916.                 else{
  917.                     $session->set('openEditJtpmsModal', true);
  918.                     $session->set('openEditJtpmsModalId', $request->request->get('jtpmsEditId'));
  919.                 }
  920.             }
  922.             return $this->render('role/user/product/model_sheet.html.twig', [
  923.                 "company" => $company,
  924.                 "model" => $model,
  925.                 "components" => $components,
  926.                 "form" => $form->createView(),
  927.                 "formJtpmsEdit" => $formJtpmsEdit->createView()
  928.             ]);
  929.         }
  931.         /**
  932.          * @Route("/modelli/fornitori-elimina", name="user_product_model_jtpms_delete")
  933.          * @Security("is_granted('edit', 'product_model')")
  934.          */
  935.         public function userProductModelJtpmsDelete(Request $request)
  936.         {    
  937.             $em = $this->mr->getManager('slave');
  938.             $jtpms = $em->getRepository("App\Entity\Slave\JoinTableProductModelSupplier")->findOneById($request->request->get("jtpmsDelId"));
  939.             $modelId = $jtpms->getModel()->getId();
  940.             $em->remove($jtpms);
  941.             $em->flush();
  943.             $this->addFlash('notice_success', "Fornitore eliminato");
  944.             return $this->redirectToRoute('user_product_model_sheet', array('modelId' => $modelId));
  945.         }
  946.         
  947.         /**
  948.          * @Route("/modelli/immagine-elimina", name="user_product_model_image_delete")
  949.          * @Security("is_granted('edit', 'product_model')")
  950.          */
  951.         public function userProductModelImageDelete(Request $request, FileSystem $fs)
  952.         {
  953.             $em = $this->mr->getManager('slave');
  954.             $emMaster = $this->mr->getManager('master');
  955.             $session = $request->getSession();
  957.             $company = $emMaster->getRepository('App\Entity\Master\Company')->findOneById($session->get('companyId'));
  958.             $model = $em->getRepository('App\Entity\Slave\ProductModel')->findOneById($request->request->get('modelId'));
  959.             $uploadDir = $this->params->get('kernel.project_dir').'/'.$this->params->get('web_path').'/companies/'.$company->getDirectoryPath().'/product_models/';
  960.     
  961.             if($model->getImagePath() != null && $model->getImagePath() != ""){
  962.                 MediaService::removeImage($fs, $model->getImagePath(), $uploadDir);
  963.                 $model->setImagePath(null);
  964.             }
  965.             $em->flush();
  966.             
  967.             $response = array("code" => 200, "success" => true);
  968.             return new Response(json_encode($response));
  969.         }
  970.     //
  971.     
  972.     // SOTTOCATEGORIE
  973.         /**
  974.          * @Route("/sottocategorie", name="user_product_subcategories")
  975.          * @Security("is_granted('view', 'product_subcategory')")
  976.          */
  977.         public function userProductSubcategories(Request $request, ValidatorInterface $validator, PaginatorInterface $paginator, FormFactoryInterface $formFactory)
  978.         {    
  979.             $em = $this->mr->getManager('slave');
  980.             $session = $request->getSession();
  982.             $filters = FilterService::productSubcategoryFilter($request);
  983.             $subcategoriesQuery = $em->getRepository("App\Entity\Slave\ProductSubcategory")->queryFiltered($filters);
  984.             $subcategories = $paginator->paginate($subcategoriesQuery, $request->getSession()->get($request->get("_route")."_page"), 15);
  986.             $subcategory = new ProductSubcategory();
  987.             $form = $formFactory->createNamed("form_subcategory_new", ProductSubcategoryType::class, $subcategory);
  988.             $form->handleRequest($request);
  990.             if($form->isSubmitted()){
  991.                 $valid = ValidationService::validateNotDuplicate($validator, $form->get("name"), $em, "App\Entity\Slave\ProductSubcategory", ['categoryId' => $form->get('category')->getData()->getId()]);
  992.                 if($form->isValid()){
  993.                     $em->persist($subcategory);
  994.                     $em->flush();
  996.                     $this->addFlash('notice_success', "Sottocategoria inserita");
  997.                     return $this->redirectToRoute('user_product_subcategories');
  998.                 }
  999.                 else
  1000.                     $session->set('openNewModal', true);
  1001.             }
  1003.             $subcategoryEdit = new ProductSubcategory();
  1004.             $formEdit = $formFactory->createNamed("form_subcategory_edit", ProductSubcategoryType::class, $subcategoryEdit);
  1005.             $formEdit->handleRequest($request);
  1007.             if($formEdit->isSubmitted()){
  1008.                 $valid = ValidationService::validateNotDuplicate($validator, $formEdit->get("name"), $em, "App\Entity\Slave\ProductSubcategory", ['categoryId' => $subcategoryEdit->getCategory()->getId()]);
  1010.                 if($valid && $formEdit->isValid()){
  1011.                     $pt = $em->getRepository("App\Entity\Slave\ProductSubcategory")->findOneById($request->request->get("subcategoryEditId"));
  1012.                     $pt->setName($subcategoryEdit->getName());
  1013.                     $pt->setCategory($subcategoryEdit->getCategory());
  1014.                     $em->flush();
  1016.                     $this->addFlash('notice_success', "Sottocategoria modificata");
  1017.                     return $this->redirectToRoute('user_product_subcategories');
  1018.                 }
  1019.                 else{
  1020.                     $session->set('openEditModal', true);
  1021.                     $session->set('openEditModalId', $request->request->get("subcategoryEditId"));
  1022.                 }
  1023.             }
  1024.             
  1025.             return $this->render('role/user/product/subcategories.html.twig', [
  1026.                 "filters" => $filters,
  1027.                 "subcategories" => $subcategories,
  1028.                 "form" => $form->createView(),
  1029.                 "formEdit" => $formEdit->createView()
  1030.             ]);
  1031.         }
  1033.         /**
  1034.          * @Route("/sottocategorie/elimina", name="user_product_subcategory_delete")
  1035.          * @Security("is_granted('edit', 'product_subcategory')")
  1036.          */
  1037.         public function userProductSubcategoryDelete(Request $request)
  1038.         {    
  1039.             $em = $this->mr->getManager('slave');
  1040.             $subcategory = $em->getRepository("App\Entity\Slave\ProductSubcategory")->findOneById($request->request->get("subcategoryDelId"));
  1041.             $em->remove($subcategory);
  1042.             $em->flush();
  1044.             $this->addFlash('notice_success', "Sottocategoria eliminata");
  1045.             return $this->redirectToRoute('user_product_subcategories');
  1046.         }
  1047.     //
  1048.     
  1049.     // CATEGORIE
  1050.         /**
  1051.          * @Route("/categorie", name="user_product_categories")
  1052.          * @Security("is_granted('view', 'product_category')")
  1053.          */
  1054.         public function userProductCategories(Request $request, ValidatorInterface $validator, PaginatorInterface $paginator, FormFactoryInterface $formFactory)
  1055.         {    
  1056.             $em = $this->mr->getManager('slave');
  1057.             $session = $request->getSession();
  1058.             $filters = FilterService::productCategoryFilter($request);
  1059.             $categoriesQuery = $em->getRepository("App\Entity\Slave\ProductCategory")->queryFiltered($filters);
  1060.             $categories = $paginator->paginate($categoriesQuery, $request->getSession()->get($request->get("_route")."_page"), 15);
  1062.             $category = new ProductCategory();
  1063.             $form = $formFactory->createNamed("form_category_new", ProductCategoryType::class, $category);
  1064.             $form->handleRequest($request);
  1066.             if($form->isSubmitted()){
  1067.                 $valid = ValidationService::validateNotDuplicate($validator, $form->get("name"), $em, "App\Entity\Slave\ProductCategory", ['id' => 0]);
  1068.                 if($form->isValid()){
  1069.                     $em->persist($category);
  1070.                     $em->flush();
  1072.                     $this->addFlash('notice_success', "Categoria inserita");
  1073.                     return $this->redirectToRoute('user_product_categories');
  1074.                 }
  1075.                 else
  1076.                     $session->set('openNewModal', true);
  1077.             }
  1079.             $categoryEdit = new ProductCategory();
  1080.             $formEdit = $formFactory->createNamed("form_category_edit", ProductCategoryType::class, $categoryEdit);
  1081.             $formEdit->handleRequest($request);
  1083.             if($formEdit->isSubmitted()){
  1084.                 $valid = ValidationService::validateNotDuplicate($validator, $formEdit->get("name"), $em, "App\Entity\Slave\ProductCategory", ['id' => $request->request->get("categoryEditId")]);
  1086.                 if($valid && $formEdit->isValid()){
  1087.                     $pt = $em->getRepository("App\Entity\Slave\ProductCategory")->findOneById($request->request->get("categoryEditId"));
  1088.                     $pt->setName($categoryEdit->getName());
  1089.                     $pt->setPos($categoryEdit->isPos());
  1090.                     $em->flush();
  1092.                     $this->addFlash('notice_success', "Categoria modificata");
  1093.                     return $this->redirectToRoute('user_product_categories');
  1094.                 }
  1095.                 else{
  1096.                     $session->set('openEditModal', true);
  1097.                     $session->set('openEditModalId', $request->request->get("categoryEditId"));
  1098.                 }
  1099.             }
  1100.             
  1101.             return $this->render('role/user/product/categories.html.twig', [
  1102.                 "filters" => $filters,
  1103.                 "categories" => $categories,
  1104.                 "form" => $form->createView(),
  1105.                 "formEdit" => $formEdit->createView()
  1106.             ]);
  1107.         }
  1109.         /**
  1110.          * @Route("/categorie/elimina", name="user_product_category_delete")
  1111.          * @Security("is_granted('edit', 'product_category')")
  1112.          */
  1113.         public function userProductCategoryDelete(Request $request)
  1114.         {    
  1115.             $em = $this->mr->getManager('slave');
  1116.             $category = $em->getRepository("App\Entity\Slave\ProductCategory")->findOneById($request->request->get("categoryDelId"));
  1117.             $em->remove($category);
  1118.             $em->flush();
  1120.             $this->addFlash('notice_success', "Categoria eliminata");
  1121.             return $this->redirectToRoute('user_product_categories');
  1122.         }
  1123.     //
  1124.     
  1125.     // COMPONENTI
  1126.         /**
  1127.          * @Route("/componenti", name="user_product_components")
  1128.          * @Security("is_granted('view', 'product_component')")
  1129.          */
  1130.         public function userProductComponents(Request $request, ValidatorInterface $validator, PaginatorInterface $paginator, FormFactoryInterface $formFactory)
  1131.         {    
  1132.             $em = $this->mr->getManager('slave');
  1133.             $session = $request->getSession();
  1135.             $filters = FilterService::nameFilter($request);
  1136.             $componentsQuery = $em->getRepository("App\Entity\Slave\ProductComponent")->queryFiltered($filters);
  1137.             $components = $paginator->paginate($componentsQuery, $request->getSession()->get($request->get("_route")."_page"), 15);
  1139.             $component = new ProductComponent();
  1140.             $form = $formFactory->createNamed("form_component_new", ProductComponentType::class, $component);
  1141.             $form->handleRequest($request);
  1143.             if($form->isSubmitted()){
  1144.                 $valid = ValidationService::validateNotDuplicate($validator, $form->get("name"), $em, "App\Entity\Slave\ProductComponent", ['id' => 0]);
  1145.                 if($form->isValid()){
  1146.                     $em->persist($component);
  1147.                     $em->flush();
  1149.                     $this->addFlash('notice_success', "Componente inserito");
  1150.                     return $this->redirectToRoute('user_product_components');
  1151.                 }
  1152.                 else
  1153.                     $session->set('openNewModal', true);
  1154.             }
  1156.             $componentEdit = new ProductComponent();
  1157.             $formEdit = $formFactory->createNamed("form_component_edit", ProductComponentType::class, $componentEdit);
  1158.             $formEdit->handleRequest($request);
  1160.             if($formEdit->isSubmitted()){
  1161.                 $valid = ValidationService::validateNotDuplicate($validator, $formEdit->get("name"), $em, "App\Entity\Slave\ProductComponent", ['id' => $request->request->get("componentEditId")]);
  1163.                 if($valid && $formEdit->isValid()){
  1164.                     $pt = $em->getRepository("App\Entity\Slave\ProductComponent")->findOneById($request->request->get("componentEditId"));
  1165.                     $pt->setName($componentEdit->getName());
  1166.                     $em->flush();
  1168.                     $this->addFlash('notice_success', "Componente modificato");
  1169.                     return $this->redirectToRoute('user_product_components');
  1170.                 }
  1171.                 else{
  1172.                     $session->set('openEditModal', true);
  1173.                     $session->set('openEditModalId', $request->request->get("componentEditId"));
  1174.                 }
  1175.             }
  1176.             
  1177.             return $this->render('role/user/product/components.html.twig', [
  1178.                 "filters" => $filters,
  1179.                 "components" => $components,
  1180.                 "form" => $form->createView(),
  1181.                 "formEdit" => $formEdit->createView()
  1182.             ]);
  1183.         }
  1185.         /**
  1186.          * @Route("/componenti/elimina", name="user_product_component_delete")
  1187.          * @Security("is_granted('edit', 'product_component')")
  1188.          */
  1189.         public function userProductComponentDelete(Request $request)
  1190.         {    
  1191.             $em = $this->mr->getManager('slave');
  1192.             $component = $em->getRepository("App\Entity\Slave\ProductComponent")->findOneById($request->request->get("componentDelId"));
  1193.             $em->remove($component);
  1194.             $em->flush();
  1196.             $this->addFlash('notice_success', "Componente eliminato");
  1197.             return $this->redirectToRoute('user_product_components');
  1198.         }
  1199.     //
  1200. }