src/Controller/User/UserWarehouseController.php line 2053

Open in your IDE?
  1. <?php
  3. namespace App\Controller\User;
  5. use Doctrine\Persistence\ManagerRegistry;
  6. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Security;
  7. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  8. use Symfony\Component\DependencyInjection\ParameterBag\ParameterBagInterface;
  9. use Symfony\Component\Filesystem\Filesystem;
  10. use Symfony\Component\Form\FormFactoryInterface;
  11. use Symfony\Component\Form\FormError;
  12. use Symfony\Component\HttpFoundation\Request;
  13. use Symfony\Component\HttpFoundation\Response;
  14. use Symfony\Component\HttpFoundation\StreamedResponse;
  15. use Symfony\Component\HttpFoundation\ResponseHeaderBag;
  16. use Symfony\Component\Mailer\MailerInterface;
  17. use Symfony\Component\Routing\Annotation\Route;
  18. use Symfony\Component\Validator\Validator\ValidatorInterface;
  19. use Spipu\Html2Pdf\Html2Pdf;
  20. use Knp\Component\Pager\PaginatorInterface;
  21. use App\Entity\Slave\JoinTableUserWarehouse;
  22. use App\Entity\Slave\JoinTableProductProductTransfer;
  23. use App\Entity\Slave\ProductTransfer;
  24. use App\Entity\Slave\Product;
  25. use App\Entity\Slave\ProductRequest;
  26. use App\Entity\Slave\Warehouse;
  27. use App\Form\Model\DdtPrint;
  28. use App\Form\Model\ProductRegister;
  29. use App\Form\Model\ProductRecover;
  30. use App\Form\Model\ImportInventory;
  31. use App\Form\Slave\ImportInventoryType;
  32. use App\Form\Slave\DdtPrintType;
  33. use App\Form\Slave\ProductType;
  34. use App\Form\Slave\ProductTransferEditType;
  35. use App\Form\Slave\ProductTransferDdtType;
  36. use App\Form\Slave\ProductTransferDownloadType;
  37. use App\Form\Slave\ProductTransferReceiveType;
  38. use App\Form\Slave\ProductTransferSendType;
  39. use App\Form\Slave\ProductTransferSendProductsType;
  40. use App\Form\Slave\ProductRegisterType;
  41. use App\Form\Slave\ProductRecoverType;
  42. use App\Form\Slave\ProductRequestType;
  43. use App\Form\Slave\WarehouseType;
  44. use App\Service\FilterService;
  45. use App\Service\FormValidatorService;
  46. use App\Service\ProductService;
  47. use App\Service\MediaService;
  48. use App\Service\ValidationService;
  50. /**
  51.  * @Route("/scrivania/magazzini")
  52.  * @Security("is_granted('ROLE_USER') and is_granted('active', user)")
  53.  */
  54. class UserWarehouseController extends AbstractController
  55. {
  56.     private $mr;
  57.     private $params;
  59.     public function __construct(ManagerRegistry $mr, ParameterBagInterface $params)
  60.     {
  61.         $this->mr = $mr;
  62.         $this->params = $params;
  63.     }
  65.     public function createDdtProductsArray($products)
  66.     {
  67.         $first = true;
  68.         $total = 0;
  69.         $qty = 0;
  70.         $arrayRows = array();
  71.         $arrayCodes = array();
  72.         foreach($products as $product){
  73.             if($first){
  74.                 $first = false;
  75.                 $oldModel = $product->getModel();
  76.             }
  77.             if($product->getModel()->getId() == $oldModel->getId()){
  78.                 $qty++;
  79.                 $tmp = array();
  80.                 if($product->getCodeProducer()) array_push($tmp, $product->getCodeProducer()); else array_push($tmp, 'ND');
  81.                 if($product->getCodeSupplier()) array_push($tmp, $product->getCodeSupplier()); else array_push($tmp, 'ND');
  82.                 array_push($arrayCodes, $tmp);
  83.             }
  84.             else{
  85.                 $arrayTmp = array();
  86.                 array_push($arrayTmp, $qty, $oldModel->getSku(), '('.$oldModel->getProducer()->getName().') - '.$oldModel->getName(), $arrayCodes);
  87.                 array_push($arrayRows, $arrayTmp);
  88.                 $qty = 1;
  89.                 $oldModel = $product->getModel();
  90.                 $arrayCodes = array();
  91.                 $tmp = array();
  92.                 if($product->getCodeProducer()) array_push($tmp, $product->getCodeProducer()); else array_push($tmp, 'ND');
  93.                 if($product->getCodeSupplier()) array_push($tmp, $product->getCodeSupplier()); else array_push($tmp, 'ND');
  94.                 array_push($arrayCodes, $tmp);
  95.             }
  97.             $total++;
  98.             if(sizeof($products) == $total){
  99.                 $arrayTmp = array();
  100.                 array_push($arrayTmp, $qty, $product->getModel()->getSku(), '('.$product->getModel()->getProducer()->getName().') - '.$product->getModel()->getName(), $arrayCodes);
  101.                 array_push($arrayRows, $arrayTmp);
  102.             }
  103.         }
  104.         return [$arrayRows, $total];
  105.     }
  107.     public function searchDDTSender($em, $transfer)
  108.     {
  109.         $supplier = null;
  110.         $sender = null;
  111.         $warehouseHeadquarter = null;
  112.         switch($transfer->getType()){
  113.             case 'destination': $supplier = $transfer->getSupplier(); break;
  114.             case 'technician': 
  115.                 if($transfer->getUserFrom() != null)
  116.                     $sender = $transfer->getUserFrom();
  117.                 else
  118.                     $warehouseHeadquarter = $transfer->getWarehouseFrom();
  119.                 break;
  120.             case 'main': $sender = $transfer->getUserFrom(); break;
  121.             default: break;
  122.         }
  123.         return [$supplier, $sender, $warehouseHeadquarter];
  124.     }
  126.     public function searchDDTDestination($em, $transfer)
  127.     {
  128.         $destination = null;
  129.         $receiver = null;
  130.         $warehouseHeadquarter = null;
  131.         switch($transfer->getType()){
  132.             case 'destination': $destination = $transfer->getWarehouseTo()->getDestination(); break;
  133.             case 'technician': $receiver = $transfer->getUserTo(); break;
  134.             case 'main': $warehouseHeadquarter = $transfer->getWarehouseTo(); break;
  135.             default: break;
  136.         }
  138.         return [$destination, $receiver, $warehouseHeadquarter];
  139.     }
  141.     public function downloadSetByType($em, $transfer)
  142.     {
  143.         $status = null;
  144.         $toManage = null;
  145.         $toManagePriority = 2;
  147.         switch($transfer->getType()){
  148.             case 'main': 
  149.                 $status = $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'not_available'));
  150.                 $toManage = true;
  151.                 $toManagePriority = 1;
  152.                 break;
  153.             case 'technician':
  154.                 $status = $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'available'));
  155.                 $toManage = false;
  156.                 break;
  157.             case 'destination':
  158.                 $status = $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'not_available'));
  159.                 $toManage = false;
  160.                 break;
  161.             default: break;
  162.         }
  164.         return [$status, $toManage, $toManagePriority];
  165.     }
  167.     public function registerReceiveProducts($em, $warehouse, $status, $form, $codeProducer, $codeSupplier, $arrayProducerCodes, $arraySupplierCodes, $countProductsUpdated, $countProductsNew, $countProductsDouble, $productsUpdatedMats, $productsDoubleMats)
  168.     {
  169.         $product = null;
  170.         if($product == null && $codeProducer != null) $product = $em->getRepository('App\Entity\Slave\Product')->findOneBy(array('codeProducer' => $codeProducer));
  171.         if($product == null && $codeSupplier != null) $product = $em->getRepository('App\Entity\Slave\Product')->findOneBy(array('codeSupplier' => $codeSupplier));
  173.         if($product != null){
  174.             if(!in_array($codeProducer, $arrayProducerCodes) && !in_array($codeSupplier, $arraySupplierCodes)){
  175.                 $product = ProductService::updateProduct($em, $product, $form->get('model')->getData(), $codeProducer, $codeSupplier, $form->get('suppliers')->getData(), $status, $form->get('condition')->getData());
  176.                 $countProductsUpdated++;
  177.                 $productsUpdatedMats.="<br>".$codeProducer.";".$codeSupplier;
  178.             }
  179.             else{
  180.                 $countProductsDouble++;
  181.                 $productsDoubleMats.="<br>".$codeProducer.";".$codeSupplier;
  182.             }
  183.         }
  184.         else{
  185.             $product = ProductService::createProduct($em, $form->get('model')->getData(), $codeProducer, $codeSupplier, $form->get('suppliers')->getData(), $status, $form->get('condition')->getData());
  186.             $countProductsNew++;
  187.         }
  189.         $product->setActualWarehouse($warehouse);
  190.         $product->setDateLastTransfer(new \Datetime());
  191.         if($codeProducer != null && $codeProducer != '') array_push($arrayProducerCodes, $codeProducer);
  192.         if($codeSupplier != null && $codeSupplier != '') array_push($arraySupplierCodes, $codeSupplier);
  193.         return [$product, $arrayProducerCodes, $arraySupplierCodes, $countProductsUpdated, $countProductsNew, $countProductsDouble, $productsUpdatedMats, $productsDoubleMats];
  194.     }
  196.     /**
  197.      * @Route("/lista", name="user_warehouse_list")
  198.      */
  199.     public function userWarehouseList(Request $request, ValidatorInterface $validator, PaginatorInterface $paginator, FormFactoryInterface $formFactory)
  200.     {
  201.         $em = $this->mr->getManager('slave');
  202.         $session = $request->getSession();
  204.         $filters = FilterService::nicknameFilter($request);
  206.         $canSeeAll = false;
  207.         foreach($this->getUser()->getAccountType()->getPermissions() as $jtatp){
  208.             if($jtatp->getPermission()->getSlug() == 'warehouse' && $jtatp->getRw() == 'RW'){
  209.                 $canSeeAll = true;
  210.             }
  211.         }
  213.         if($canSeeAll){
  214.             $warehousesActiveQuery = $em->getRepository("App\Entity\Slave\Warehouse")->queryNotClientsAndDestinationFiltered($filters, true);
  215.             $warehousesNotActiveQuery = $em->getRepository("App\Entity\Slave\Warehouse")->queryNotClientsAndDestinationFiltered($filters, false);
  216.         }
  217.         else{
  218.             $warehousesActiveQuery = $em->getRepository("App\Entity\Slave\Warehouse")->queryByActiveAndUserFiltered($filters, true, $this->getUser()->getId());
  219.             $warehousesNotActiveQuery = $em->getRepository("App\Entity\Slave\Warehouse")->queryByActiveAndUserFiltered($filters, false, $this->getUser()->getId());
  220.         }
  221.         $warehousesActive = $paginator->paginate($warehousesActiveQuery, $request->getSession()->get($request->get("_route")."_page"), 15);
  222.         $warehousesNotActive = $paginator->paginate($warehousesNotActiveQuery, $request->getSession()->get($request->get("_route")."_page"), 15);
  223.         $countActive = sizeof($warehousesActiveQuery->getResult());
  224.         $countNotActive = sizeof($warehousesNotActiveQuery->getResult());
  226.         $warehouse = new Warehouse();
  227.         $form = $formFactory->createNamed("form_warehouse_new", WarehouseType::class, $warehouse);
  228.         $form->handleRequest($request);
  229.         $editId = 0;
  231.         if($form->isSubmitted()){
  232.             $valid = ValidationService::validateNotDuplicate($validator, $form->get("nickname"), $em, "App\Entity\Slave\Warehouse", ['id' => 0]);
  234.             if($form->isValid()){
  235.                 $em->persist($warehouse);
  236.                 $em->flush();
  238.                 $jtuw = new JoinTableUserWarehouse();
  239.                 $jtuw->setUser($this->getUser());
  240.                 $jtuw->setWarehouse($warehouse);
  241.                 $jtuw->setPermission("RW");
  242.                 $em->persist($jtuw);
  243.                 $em->flush();
  245.                 if($this->getUser()->getAccountTypology() != 'agency'){
  246.                     $userAgency = $em->getRepository('App\Entity\Slave\User')->findMainAccountAgency();
  247.                     $jtuw = new JoinTableUserWarehouse();
  248.                     $jtuw->setUser($userAgency);
  249.                     $jtuw->setWarehouse($warehouse);
  250.                     $jtuw->setPermission("RW");
  251.                     $em->persist($jtuw);
  252.                     $em->flush();
  253.                 }
  255.                 $this->addFlash('notice_success', "Valore inserito");
  256.                 return $this->redirectToRoute('user_warehouse_list');
  257.             }
  258.             else
  259.                 $session->set('openNewModal', true);
  260.         }
  261.         
  262.         return $this->render('role/user/warehouse/list.html.twig',[
  263.             "filters" => $filters,
  264.             'warehousesActive' => $warehousesActive,
  265.             'warehousesNotActive' => $warehousesNotActive,
  266.             'countActive' => $countActive,
  267.             'countNotActive' => $countNotActive,
  268.             "form" => $form->createView()
  269.         ]);
  270.     }
  272.     /**
  273.      * @Route("/cambia-stato", name="user_warehouse_change_status")
  274.      * @Security("is_granted('edit', 'warehouse')")
  275.      */
  276.     public function userUsersStaffChangeStatus(Request $request)
  277.     {    
  278.         $em = $this->mr->getManager('slave');
  279.         $warehouse = $em->getRepository("App\Entity\Slave\Warehouse")->findOneById($request->request->get("warehouseChangeId"));
  280.         $warehouse->setactive(!$warehouse->isActive());
  281.         $em->flush();
  282.         
  283.         $this->addFlash('notice_success', "Stato aggiornato");
  284.         return $this->redirectToRoute('user_warehouse_list');
  285.     }
  286.     
  287.     /**
  288.      * @Route("/elimina", name="user_warehouse_delete")
  289.      * @Security("is_granted('edit', 'warehouse')")
  290.      */
  291.     public function userWarehouseDelete(Request $request)
  292.     {    
  293.         $em = $this->mr->getManager('slave');
  294.         $warehouse = $em->getRepository("App\Entity\Slave\Warehouse")->findOneById($request->request->get("warehouseDelId"));
  295.         foreach($warehouse->getUsers() as $jt)
  296.             $em->remove($jt);
  297.         $em->remove($warehouse);
  298.         $em->flush();
  300.         $this->addFlash('notice_success', "Magazzino eliminato");
  301.         return $this->redirectToRoute('user_warehouse_list');
  302.     }
  304.     /**
  305.      * @Route("/{warehouseId}/scheda", name="user_warehouse_sheet")
  306.      * @Security("is_granted('view', 'warehouse') || is_granted('warehouse_view', warehouseId)")
  307.      */
  308.     public function userWarehouseSheet($warehouseId, Request $request, ValidatorInterface $validator, PaginatorInterface $paginator, FormFactoryInterface $formFactory, FileSystem $fs)
  309.     {    
  310.         $em = $this->mr->getManager('slave');
  311.         $emMaster = $this->mr->getManager('master');
  312.         $session = $request->getSession();
  313.         $company = $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get("companyId"));
  314.         $warehouse = $em->getRepository("App\Entity\Slave\Warehouse")->findOneById($warehouseId);
  315.         $productModels = $em->getRepository('App\Entity\Slave\ProductModel')->findBy([], ['name' => 'ASC']);
  316.         $uploadDir = $this->params->get('kernel.project_dir').'/'.$this->params->get('web_path').'/companies/'.$company->getDirectoryPath().'/ddt/';
  317.         $settingRegisterStock = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'warehouse_register_stock'));
  318.         $settingRecoverStock = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'warehouse_recover_stock'));
  319.         $settingDdtMandatory = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'ddt_internal_mandatory'));
  320.         $settingWarehouseProductConditions = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'warehouse_technician_product_conditions'));
  321.         $suppliers = $em->getRepository('App\Entity\Slave\Supplier')->findAllActiveOrdered();
  322.         
  323.         // DATI MAGAZZINO
  324.         $formEdit = $formFactory->createNamed("form_warehouse_edit", WarehouseType::class, $warehouse);
  325.         $formEdit->handleRequest($request);
  327.         if($formEdit->isSubmitted()){
  329.             $valid = ValidationService::validateNotBlank($validator, $formEdit->get("nickname"));
  331.             if($valid && $formEdit->isValid()){
  332.                 $em->flush();
  333.                 $this->addFlash('notice_success', "Magazzino aggiornato");
  334.                 return $this->redirectToRoute('user_warehouse_sheet', array('warehouseId' => $warehouse->getId()));
  335.             }
  336.             else{
  337.                 $session->set('openEditModal', true);
  338.             }
  339.         }
  341.         $filters = FilterService::userWarehouseSheetFilter($request);
  342.         // STOCK
  343.         $toManageProductsQuery = $em->getRepository("App\Entity\Slave\Product")->findByWarehouseFiltered(true, $warehouse->getId(), 'to_manage', $filters, 0);
  344.         $toManageProducts = $paginator->paginate($toManageProductsQuery, $request->getSession()->get($request->get("_route")."_page_0"), 100, array('pageParameterName' => 'page_0'));
  346.         $availableProductsQuery = $em->getRepository("App\Entity\Slave\Product")->findByWarehouseFiltered(true, $warehouse->getId(), 'available', $filters, 1);
  347.         $availableProducts = $paginator->paginate($availableProductsQuery, $request->getSession()->get($request->get("_route")."_page_1"), 100, array('pageParameterName' => 'page_1'));
  348.         
  349.         $notAvailableProductsQuery = $em->getRepository("App\Entity\Slave\Product")->findByWarehouseFiltered(true, $warehouse->getId(), 'not_available', $filters, 1);
  350.         $notAvailableProducts = $paginator->paginate($notAvailableProductsQuery, $request->getSession()->get($request->get("_route")."_page_1"), 100, array('pageParameterName' => 'page_1'));
  351.         
  352.         $transferProductsQuery = $em->getRepository("App\Entity\Slave\Product")->findByWarehouseFiltered(true, $warehouse->getId(), 'transfer', $filters, 1);
  353.         $transferProducts = $paginator->paginate($transferProductsQuery, $request->getSession()->get($request->get("_route")."_page_1"), 100, array('pageParameterName' => 'page_1'));
  355.         // INVENTORY
  356.         if($session->get('inventorySupplierId') != null) $session->remove('inventorySupplierId');
  357.         if($session->get('inventoryStatusId') != null) $session->remove('inventoryStatusId');
  358.         if($session->get('inventoryResults') != null) $session->remove('inventoryResults');
  359.         $importInventory = new ImportInventory();
  360.         $formInventory = $formFactory->createNamed("form_import_inventory", ImportInventoryType::class, $importInventory);
  361.         $formInventory->handleRequest($request);
  363.         if($formInventory->isSubmitted()){
  364.             
  365.             $valid = true;
  366.             if($valid) $valid = ValidationService::validateNotBlank($validator, $formInventory->get('supplier'));
  367.             if($valid) $valid = ValidationService::validateNotBlank($validator, $formInventory->get('status'));
  368.             if($valid) $valid = ValidationService::validateFile($validator, $formInventory->get('file'), true, $formInventory->get('file')->getData(), '10', array('csv', 'txt'));
  370.             if($valid && $formInventory->isValid()){
  372.                 $row = 0;
  373.                 $productsIdsFound = array();
  374.                 $results = array();
  376.                 if(($handle = fopen($formInventory->get('file')->getData(), "r")) !== FALSE) {
  377.                     while(($data = fgetcsv($handle, 2000, ',')) !== FALSE) {
  378.                         $data = array_map("utf8_encode", $data);
  379.                         if($row > 0){
  381.                             $found = false;
  382.                             $color = 'bg_r_l';
  383.                             $errorMsg = '';
  384.                             $prod = null;
  385.                             $prodCodeProducer = null;
  386.                             $prodCodeSupplier = null;
  387.                             $prodModel = null;
  388.                             $prodWarehouse = null;
  389.                             $priority = 5;
  390.                             $trimmedCode = rtrim(ltrim($data[0], " ")," ");
  392.                             foreach($warehouse->getProducts() as $p){
  393.                                 if($trimmedCode == $p->getCodeProducer()){
  394.                                     $found = true;
  395.                                     $prod = $p;
  396.                                     break;
  397.                                 }
  398.                                 if(!$found && $trimmedCode == $p->getCodeSupplier()){
  399.                                     $found = true;
  400.                                     $prod = $p;
  401.                                     break;
  402.                                 }
  403.                             }
  405.                             if($found){
  406.                                 // PRODOTTO TROVATO NEL MAGAZZINO
  407.                                 // CONTROLLO FORNITORE
  408.                                 $suppliersIds = array();
  409.                                 foreach($prod->getSuppliers() as $supplier)
  410.                                     array_push($suppliersIds, $supplier->getId());
  412.                                 if(!in_array($formInventory->get('supplier')->getData()->getId(), $suppliersIds)){
  413.                                     $color = 'bg_r_m';
  414.                                     $errorMsg = 'Prodotto presente --- Fornitore non corretto';
  415.                                     $priority = 3;
  416.                                 }
  418.                                 // CONTROLLO STATO
  419.                                 if($prod->getStatus()->getId() != $formInventory->get('status')->getData()->getId()){ 
  420.                                     $color = 'bg_r_l_m';
  421.                                     $errorMsg = 'Prodotto presente --- Stato non corretto';
  422.                                     $priority = 4;
  423.                                 }
  424.                             }
  425.                             else{
  426.                                 // PRODOTTO NON TROVATO --- CERCO TRA TUTTI I PRODOTTI
  427.                                 if($prod == null) $prod = $em->getRepository('App\Entity\Slave\Product')->findOneByCodeProducer($trimmedCode);
  428.                                 if($prod == null) $prod = $em->getRepository('App\Entity\Slave\Product')->findOneByCodeSupplier($trimmedCode);
  429.                                 if($prod != null){
  430.                                     // MAGAZZINO SBAGLIATO
  431.                                     $color = 'bg_r_m_h';
  432.                                     $errorMsg = 'Prodotto non presente --- Presente in un altro magazzino';
  433.                                     $priority = 2;
  434.                                 }
  435.                                 else{
  436.                                     // PRODOTTO NON IN PIATTAFORMA
  437.                                     $color = 'bg_r_b';
  438.                                     $errorMsg = 'Prodotto non presente in piattaforma';
  439.                                     $priority = 0;
  440.                                     $prodCodeProducer = $trimmedCode;
  441.                                 }
  442.                             }
  443.                             
  444.                             $prodLastTransfer = '';
  446.                             if($prod != null){
  447.                                 if($prod->getCodeProducer() != null) $prodCodeProducer = $prod->getCodeProducer(); else $prodCodeProducer = '---';
  448.                                 if($prod->getCodeSupplier() != null) $prodCodeSupplier = $prod->getCodeSupplier(); else $prodCodeSupplier = '---';
  449.                                 $prodModel = $prod->getModel()->__toString();
  450.                                 $prodWarehouse = $prod->getActualWarehouse()->__toString();
  451.                                 if($prod->getLastTransfer() != null){
  452.                                     $transfer = $prod->getLastTransfer();
  453.                                     $prodLastTransfer = 'Magazzino partenza: '.$transfer->getWarehouseFrom().' --- Magazzino destinazione: '.$transfer->getWarehouseTo();
  454.                                     if($transfer->getDatetimeCompletion() != null)
  455.                                         $prodLastTransfer .= ' --- Data completamento: '.$transfer->getDatetimeCompletion()->format('d-m-Y H:i');
  456.                                 }
  457.                                 array_push($productsIdsFound, $prod->getId());
  458.                             }
  460.                             if($trimmedCode != '' && $trimmedCode != ' '){
  461.                                 $arrayTmp = array();
  462.                                 array_push($arrayTmp, $priority, $color, $prodModel, $prodCodeProducer, $prodCodeSupplier, $prodWarehouse, $errorMsg, $prodLastTransfer);
  463.                                 array_push($results, $arrayTmp);
  464.                             }
  465.                         }
  466.                         $row++;
  467.                     }
  468.                     fclose($handle);
  469.                 }
  471.                 // RECUPERO PRODOTTI NEL MAGAZZINO E NON NEL FILE
  472.                 $color = 'bg_r_h';
  473.                 $errorMsg = 'Prodotto non presente nel file';
  474.                 $priority = 1;
  475.                 $productsInWarehouseAndNotInFile = $em->getRepository('App\Entity\Slave\Product')->findByWarehouseSupplierStatusAndNotInIds($warehouseId, $formInventory->get('supplier')->getData()->getId(), $formInventory->get('status')->getData()->getId(), $productsIdsFound);
  476.                 foreach($productsInWarehouseAndNotInFile as $p){
  477.                     $arrayTmp = array();
  478.                     $prodCodeProducer = '';
  479.                     $prodCodeSupplier = '';
  480.                     $prodModel = '';
  481.                     $prodWarehouse = '';
  482.                     if($p->getCodeProducer() != null) $prodCodeProducer = $p->getCodeProducer(); else $prodCodeProducer = '---';
  483.                     if($p->getCodeSupplier() != null) $prodCodeSupplier = $p->getCodeSupplier(); else $prodCodeSupplier = '---';
  484.                     $prodModel = $p->getModel()->__toString();
  485.                     $prodWarehouse = $p->getActualWarehouse()->__toString();
  486.                     $prodLastTransfer = '';
  487.                     if($p->getLastTransfer() != null){
  488.                         $transfer = $p->getLastTransfer();
  489.                         $prodLastTransfer = 'Magazzino partenza: '.$transfer->getWarehouseFrom().' --- Magazzino destinazione: '.$transfer->getWarehouseTo();
  490.                         if($transfer->getDatetimeCompletion() != null)
  491.                             $prodLastTransfer .= ' --- Data completamento: '.$transfer->getDatetimeCompletion()->format('d-m-Y H:i');
  492.                     }
  493.                     array_push($arrayTmp, $priority, $color, $prodModel, rtrim(ltrim($prodCodeProducer)), rtrim(ltrim($prodCodeSupplier)), $prodWarehouse, $errorMsg, $prodLastTransfer);
  494.                     array_push($results, $arrayTmp);
  495.                 }
  497.                 $session->set('inventorySupplierId', $formInventory->get('supplier')->getData()->getId());
  498.                 $session->set('inventoryStatusId', $formInventory->get('status')->getData()->getId());
  499.                 $session->set('inventoryResults', $results);
  500.                 return $this->redirectToRoute('user_warehouse_stock_inventory', array('warehouseId' => $warehouse->getId()));
  501.             }
  502.             else{
  503.                 $session->set('openStockInventoryModal', true);
  504.             }
  505.         }
  507.         // TRANSFER
  508.         $incomingTransfersQuery = $em->getRepository("App\Entity\Slave\ProductTransfer")->findByWarehouseTypeAndPhaseNotCompletedFiltered(true, $warehouse->getId(), 'to', $filters);
  509.         $incomingTransfers = $paginator->paginate($incomingTransfersQuery, $request->getSession()->get($request->get("_route")."_page_2"), 100, array('pageParameterName' => 'page_2'));
  510.         
  511.         $outputTransfersQuery = $em->getRepository("App\Entity\Slave\ProductTransfer")->findByWarehouseTypeAndPhaseNotCompletedFiltered(true, $warehouse->getId(), 'from', $filters);
  512.         $outputTransfers = $paginator->paginate($outputTransfersQuery, $request->getSession()->get($request->get("_route")."_page_2"), 100, array('pageParameterName' => 'page_2'));
  513.         
  514.         $transferReceive = new ProductTransfer();
  515.         $formReceive = $formFactory->createNamed("form_transfer_receive", ProductTransferReceiveType::class, $transferReceive);
  516.         $formReceive->handleRequest($request);
  517.         
  518.         if($formReceive->isSubmitted()){
  520.             $valid = true;
  521.             if($formReceive->get('ddtMandatory')->getData()){
  522.                 if($valid) $valid = ValidationService::ValidateNotBlank($validator, $formReceive->get('ddt'));
  523.                 $valid = ValidationService::validateFile($validator, $formReceive->get('ddtPath'), false, $formReceive->get('file')->getData(), '10', array('pdf', 'jpg', 'jpeg', 'png'));
  524.             }
  525.             if($valid) $valid = ValidationService::ValidateNotBlank($validator, $formReceive->get('warehouse'));
  527.             if($valid && $formReceive->isValid()){
  529.                 $warehouseFrom = $formReceive->get('warehouse')->getData();
  531.                 $transferReceive->setDatetimeCreation(new \Datetime());
  532.                 $transferReceive->setPhase('inserted');
  533.                 $transferReceive->setWarehouseFrom($warehouseFrom);
  534.                 $transferReceive->setWarehouseTo($warehouse);
  535.                 if($formReceive->get('file')->getData() != null){
  536.                     if($formReceive->get('file')->getData()->guessExtension() == 'pdf')
  537.                         MediaService::uploadDocument($formReceive->get('file')->getData(), $uploadDir, $transferReceive, 'signedDdt');
  538.                     else
  539.                         MediaService::uploadImage($fs, $formReceive->get('file')->getData(), null, $uploadDir, $transferReceive, 'signedDdt', 100, 1000, 200, false);
  540.                 }
  541.                 $transferReceive->setType('destination');
  542.                 $em->persist($transferReceive);
  543.                 $em->flush();
  545.                 $session->set('transferId', $transferReceive->getId());
  546.                 return $this->redirectToRoute('user_warehouse_transfer_receive', array('warehouseId' => $warehouse->getId(), 'transferId' => $transferReceive->getId()));
  547.             }
  548.             else{
  549.                 $session->set('openTransferReceiveModal', true);
  550.             }
  551.         }
  552.         
  553.         $transferSend = new ProductTransfer();
  554.         $formSend = $formFactory->createNamed("form_transfer_send", ProductTransferSendType::class, $transferSend, array('warehouseId' => $warehouse->getId()));
  555.         $formSend->handleRequest($request);
  556.         
  557.         if($formSend->isSubmitted()){
  559.             $valid = true;
  560.             switch($formSend->get('type')->getData()){
  561.                 case 'destination':
  562.                     if($valid)
  563.                         $valid = ValidationService::ValidateNotBlank($validator, $formSend->get('supplier'));
  564.                         // $valid = ValidationService::ValidateNotBlank($validator, $formSend->get('stockOrder'));
  565.                     break;
  566.                 case 'main':
  567.                     if($valid && $warehouse->isHeadquarter() == 0 && $this->getUser()->getAccountTypology() != 'technician')
  568.                         $valid = ValidationService::ValidateNotBlank($validator, $formSend->get('userFrom'));
  569.                     break;
  570.                 case 'technician':
  571.                     if($valid)
  572.                         $valid = ValidationService::ValidateNotBlank($validator, $formSend->get('userTo'));
  573.                     if($valid && $warehouse->isHeadquarter() == 0){
  574.                         $valid = ValidationService::ValidateNotBlank($validator, $formSend->get('userFrom'));
  575.                     }
  576.                 default: break;
  577.             }
  579.             if($warehouse->getId() == $formSend->get('warehouse')->getData()->getId()){
  580.                 $valid = false;
  581.                 $formSend->get('warehouse')->addError(new FormError("Il magazzino di destinazione non può essere lo stesso del magazzino di invio."));
  582.             }
  583.             if($valid && $formSend->isValid()){
  584.                 $warehouseTo = $formSend->get('warehouse')->getData();
  585.                 $transferSend->setDatetimeCreation(new \Datetime());
  586.                 $transferSend->setPhase('inserted');
  587.                 $transferSend->setWarehouseFrom($warehouse);
  588.                 $transferSend->setWarehouseTo($warehouseTo);
  589.                 switch($formSend->get('type')->getData()){
  590.                     case 'main': 
  591.                         if($warehouse->isHeadquarter() == 0 && $this->getUser()->getAccountTypology() != 'technician')
  592.                             $transferSend->setUserFrom($formSend->get('userFrom')->getData());
  593.                         else
  594.                             $transferSend->setUserFrom($this->getUser());
  595.                         break;
  596.                     case 'technician':
  597.                         $transferSend->setUserTo($formSend->get('userTo')->getData());
  598.                         if($warehouse->isHeadquarter() == 0){
  599.                             $transferSend->setUserFrom($this->getUser());
  600.                         }
  601.                         break;
  602.                     default: break;
  603.                 }
  604.                 $em->persist($transferSend);
  605.                 $em->flush();
  607.                 if($formSend->get('productRequestId')->getData() != null)
  608.                     $session->set('productRequestId', $formSend->get('productRequestId')->getData());
  609.                 $session->set('transferId', $transferSend->getId());
  610.                 $session->set('transferStocksIds', $formSend->get('sendStocksIds')->getData());
  611.                 $session->set('action_edit', false);
  612.                 return $this->redirectToRoute('user_warehouse_transfer_send', array('warehouseId' => $warehouse->getId(), 'transferId' => $transferSend->getId()));
  613.             }
  614.             else{
  615.                 $session->set('openTransferSendModal', true);
  616.             }
  617.         }
  619.         // PRODUCT REQUEST
  620.         $productConditions = array();
  621.         $conditions = $em->getRepository('App\Entity\Slave\ProductCondition')->findAll();
  622.         $insertedProductRequests = null;
  623.         $takeChargeProductRequests = null;
  624.         $completedProductRequests = null;
  626.         switch($this->getUser()->getAccountTypology()){
  627.             case 'administration':
  628.             case 'agency':
  629.             case 'commercial':
  630.             case 'warehouse':
  631.                 foreach($conditions as $condition)
  632.                     array_push($productConditions, $condition);
  633.                 break;
  634.             case 'technician':
  635.                 $conditionsIds = explode(',', $settingWarehouseProductConditions->getValue());
  636.                 foreach($conditionsIds as $conditionId){
  637.                     $condition = $em->getRepository('App\Entity\Slave\ProductCondition')->findOneById($conditionId);
  638.                     array_push($productConditions, $condition);
  639.                 }
  640.                 break;
  641.             default: break;
  642.         }
  644.         if($warehouse->isHeadquarter()){
  645.             $insertedProductRequestsQuery = $em->getRepository("App\Entity\Slave\ProductRequest")->findByWarehouseHeadquarterAndPhaseFiltered(true, $warehouse->getId(), 'inserted', $filters);
  646.             $insertedProductRequests = $paginator->paginate($insertedProductRequestsQuery, $request->getSession()->get($request->get("_route")."_page_3"), 50, array('pageParameterName' => 'page_3'));
  648.             $takeChargeProductRequestsQuery = $em->getRepository("App\Entity\Slave\ProductRequest")->findByWarehouseHeadquarterAndPhaseFiltered(true, $warehouse->getId(), 'take_charge', $filters);
  649.             $takeChargeProductRequests = $paginator->paginate($takeChargeProductRequestsQuery, $request->getSession()->get($request->get("_route")."_page_3"), 50, array('pageParameterName' => 'page_3'));
  650.             
  651.             $completedProductRequestsQuery = $em->getRepository("App\Entity\Slave\ProductRequest")->findByWarehouseHeadquarterAndPhaseFiltered(true, $warehouse->getId(), 'completed', $filters);
  652.             $completedProductRequests = $paginator->paginate($completedProductRequestsQuery, $request->getSession()->get($request->get("_route")."_page_3"), 50, array('pageParameterName' => 'page_3'));
  653.         }
  654.         else{
  655.             $insertedProductRequestsQuery = $em->getRepository("App\Entity\Slave\ProductRequest")->findByWarehouseAndPhaseFiltered(true, $warehouse->getId(), 'inserted', $filters);
  656.             $insertedProductRequests = $paginator->paginate($insertedProductRequestsQuery, $request->getSession()->get($request->get("_route")."_page_3"), 50, array('pageParameterName' => 'page_3'));
  657.             
  658.             $takeChargeProductRequestsQuery = $em->getRepository("App\Entity\Slave\ProductRequest")->findByWarehouseAndPhaseFiltered(true, $warehouse->getId(), 'take_charge', $filters);
  659.             $takeChargeProductRequests = $paginator->paginate($takeChargeProductRequestsQuery, $request->getSession()->get($request->get("_route")."_page_3"), 50, array('pageParameterName' => 'page_3'));
  660.             
  661.             $completedProductRequestsQuery = $em->getRepository("App\Entity\Slave\ProductRequest")->findByWarehouseAndPhaseFiltered(true, $warehouse->getId(), 'completed', $filters);
  662.             $completedProductRequests = $paginator->paginate($completedProductRequestsQuery, $request->getSession()->get($request->get("_route")."_page_3"), 50, array('pageParameterName' => 'page_3'));
  663.         }
  665.         return $this->render('role/user/warehouse/sheet.html.twig', array(
  666.             'company' => $company,
  667.             'settingRegisterStock' => $settingRegisterStock,
  668.             'settingRecoverStock' => $settingRecoverStock,
  669.             'settingDdtMandatory' => $settingDdtMandatory,
  670.             'warehouse' => $warehouse,
  671.             'productConditions' => $productConditions,
  672.             'suppliers' => $suppliers,
  673.             'productModels' => $productModels,
  674.             'toManageProducts' => $toManageProducts,
  675.             'availableProducts' => $availableProducts,
  676.             'notAvailableProducts' => $notAvailableProducts,
  677.             'transferProducts' => $transferProducts,
  678.             'filters' => $filters,
  679.             'incomingTransfers' => $incomingTransfers,
  680.             'outputTransfers' => $outputTransfers,
  681.             'insertedProductRequests' => $insertedProductRequests,
  682.             'takeChargeProductRequests' => $takeChargeProductRequests,
  683.             'completedProductRequests' => $completedProductRequests,
  684.             "formEdit" => $formEdit->createView(),
  685.             'formInventory' => $formInventory->createView(),
  686.             'formReceive' => $formReceive->createView(),
  687.             'formSend' => $formSend->createView()
  688.         ));
  689.     }
  691.     // SCORTE
  692.         /**
  693.          * @Route("/{warehouseId}/scheda/scorte/selezione-multipla-azione", name="user_warehouse_stock_multiple_select_action")
  694.          * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  695.          */
  696.         public function userWarehouseStockMultipleSelectAction($warehouseId, Request $request)
  697.         {    
  698.             $em = $this->mr->getManager('slave');
  699.             $session = $request->getSession();
  700.             $productIds = explode(',', $request->request->get('ids'));
  702.             switch($request->request->get('action')){
  703.                 case 'print':
  704.                     $supplierSelected = $em->getRepository('App\Entity\Slave\Supplier')->findOneById($request->request->get('supplierId'));
  705.                     $products = array();
  706.                     foreach($productIds as $id){
  707.                         $p = $em->getRepository('App\Entity\Slave\Product')->findOneById($id);
  708.                         array_push($products, $p);
  709.                     }
  710.                     return $this->render('role/user/print/products_labels.html.twig', [
  711.                         "products" => $products,
  712.                         "supplierSelected" => $supplierSelected
  713.                     ]);
  714.                     break;
  715.                 case 'managed':
  716.                     $session->set('user_warehouse_stock_multiple_selection_tab', 'to_manage');
  717.                     foreach($productIds as $id){
  718.                         $product = $em->getRepository('App\Entity\Slave\Product')->findOneById($id);
  719.                         $oldStatus = $product->getStatus();
  720.                         $product->setToManage(false);
  721.                         $product->setToManagePriority(0);
  722.                         $newStatus = ProductService::getStatusByCondition($em, $product->getCondition());
  723.                         if($oldStatus->getId() != $newStatus->getId()){
  724.                             ProductService::createProductLog($em, $product, $this->getUser(), null, 'status', $oldStatus->getValue(), $newStatus->getValue());
  725.                             $product->setStatus($newStatus);
  726.                         }
  727.                     }
  728.                     $this->addFlash('notice_success', 'Scorte gestite!');
  729.                     break;
  730.                 case 'supplier':
  731.                     $session->set('user_warehouse_stock_multiple_selection_tab', 'to_manage');
  732.                     $allSuppliers = $em->getRepository('App\Entity\Slave\Supplier')->findAllActiveOrdered();
  733.                     $selectedSuppliers = array();
  734.                     foreach($allSuppliers as $s){
  735.                         if($request->request->get('supplier_'.$s->getId()) == 'on')
  736.                             array_push($selectedSuppliers, $s);
  737.                     }
  738.                     foreach($productIds as $id){
  739.                         $product = $em->getRepository('App\Entity\Slave\Product')->findOneById($id);
  740.                         foreach($selectedSuppliers as $s){
  741.                             if(!$product->hasSupplier($s))
  742.                                 $product->addSupplier($s);
  743.                         }
  744.                     }
  745.                     $this->addFlash('notice_success', 'Fornitori dei prodotti aggiornati!');
  746.                     break;
  747.                 case 'condition':
  748.                     $session->set('user_warehouse_stock_multiple_selection_tab', $request->request->get('tab'));
  749.                     $productCondition = $em->getRepository('App\Entity\Slave\ProductCondition')->findOneById($request->request->get('productCondition'));
  750.                     foreach($productIds as $id){
  751.                         $product = $em->getRepository('App\Entity\Slave\Product')->findOneById($id);
  752.                         if($product->getStatus()->getSlug() != 'transfer' && $product->getStatus()->getSlug() != 'in_use'){
  753.                             ProductService::productChangeCondition($em, $this->getUser(), $product, $productCondition);
  754.                             $product->setToManage(false);
  755.                             $product->setToManagePriority(2);
  756.                         }
  757.                     }
  758.                     $this->addFlash('notice_success', 'Condizione scorte aggiornata!');
  759.                     break;
  760.                 case 'model':
  761.                     $session->set('user_warehouse_stock_multiple_selection_tab', 'to_manage');
  762.                     $productModel = $em->getRepository('App\Entity\Slave\ProductModel')->findOneById($request->request->get('productModel'));
  763.                     foreach($productIds as $id){
  764.                         $product = $em->getRepository('App\Entity\Slave\Product')->findOneById($id);
  765.                         $product->setModel($productModel);
  766.                     }
  767.                     $this->addFlash('notice_success', 'Modello scorte aggiornata!');
  768.                     break;
  769.                 default: break;
  770.             }
  771.             $em->flush();
  772.             return $this->redirectToRoute('user_warehouse_sheet', array('warehouseId' => $warehouseId));
  773.         }
  774.         
  775.         /**
  776.          * @Route("/{warehouseId}/scheda/scorte/registra", name="user_warehouse_stocks_register")
  777.          * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  778.          */
  779.         public function userWarehouseStocksRegister($warehouseId, Request $request, ValidatorInterface $validator, FormFactoryInterface $formFactory)
  780.         {    
  781.             $em = $this->mr->getManager('slave');
  782.             $session = $request->getSession();
  783.             $warehouse = $em->getRepository("App\Entity\Slave\Warehouse")->findOneById($warehouseId);
  785.             $register = new ProductRegister();
  786.             $form = $formFactory->createNamed("form_register", ProductRegisterType::class, $register);
  787.             $form->handleRequest($request);
  788.             
  789.             if($form->isSubmitted()){
  791.                 [$valid, $methodRegister, $errorMsg] = FormValidatorService::validateProductRegister($em, $validator, $form);
  793.                 if($valid && $form->isValid()){
  794.                     
  795.                     $arrayProducerCodes = array();
  796.                     $arraySupplierCodes = array();
  797.                     $countProductsUpdated = 0;
  798.                     $countProductsNew = 0;
  799.                     $countProductsDouble = 0;
  800.                     $productsUpdatedMats = "";
  801.                     $productsDoubleMats = "";
  802.                     $status = ProductService::getStatusByCondition($em, $form->get('condition')->getData());
  803.                     if($methodRegister == 'gun'){
  804.                         // IMPORTAZIONE TRAMITE SPARO
  805.                         foreach($form->get('products')->getData() as $prod){
  806.                             if(!($prod->getCodeProducer() == null && $prod->getCodeSupplier() == null)){
  807.                                 [$product, $arrayProducerCodes, $arraySupplierCodes, $countProductsUpdated, $countProductsNew, $countProductsDouble, $productsUpdatedMats, $productsDoubleMats] = $this->registerReceiveProducts($em, $warehouse, $status, $form, $prod->getCodeProducer(), $prod->getCodeSupplier(), $arrayProducerCodes, $arraySupplierCodes, $countProductsUpdated, $countProductsNew, $countProductsDouble, $productsUpdatedMats, $productsDoubleMats);
  808.                             }
  809.                         }
  810.                     }
  811.                     else{
  812.                         // IMPORTAZIONE TRAMITE FILE
  813.                         $result = ProductService::checkProducts($form->get('file')->getData(), $form->get('separator')->getData());
  814.                         
  815.                         if($result['error'] != null){
  816.                             $this->addFlash('notice_danger', $result['msg']);
  817.                             return $this->redirect($request->server->get('HTTP_REFERER'));
  818.                         }
  819.                         else{
  820.                             $row = 0;
  821.                             if(($handle = fopen($form->get('file')->getData(), "r")) !== FALSE) {
  822.                                 while(($data = fgetcsv($handle, 1000, $form->get('separator')->getData())) !== FALSE) {
  823.                                     $data = array_map("utf8_encode", $data);
  824.                                     if($row > 0){
  825.                                         if(!($data[0] == null && $data[1] == null)){
  826.                                             [$product, $arrayProducerCodes, $arraySupplierCodes, $countProductsUpdated, $countProductsNew, $countProductsDouble, $productsUpdatedMats, $productsDoubleMats] = $this->registerReceiveProducts($em, $warehouse, $status, $form, $data[0], $data[1], $arrayProducerCodes, $arraySupplierCodes, $countProductsUpdated, $countProductsNew, $countProductsDouble, $productsUpdatedMats, $productsDoubleMats);
  827.                                         }
  828.                                     }
  829.                                     $row++;
  830.                                 }
  831.                                 fclose($handle);
  832.                             }
  833.                         }
  834.                     }
  836.                     $em->flush();
  837.                     $this->addFlash('notice_success', '<br>Prodotti nuovi inseriti: '.$countProductsNew.'<br>Prodotti aggiornati: '.$countProductsUpdated.$productsUpdatedMats.'<br>Prodotti doppi ignorati: '.$countProductsDouble.$productsDoubleMats);
  838.                     if($request->request->get('submit_action') == 'list')
  839.                         return $this->redirectToRoute('user_warehouse_sheet', array('warehouseId' => $warehouse->getId()));
  840.                     elseif($request->request->get('submit_action') == 'add')
  841.                         return $this->redirectToRoute('user_warehouse_stocks_register', array('warehouseId' => $warehouse->getId()));
  842.                 }
  843.                 else{
  844.                     if($errorMsg != ''){
  845.                         $this->addFlash('notice_danger', $errorMsg);
  846.                     }
  847.                 }
  848.             }
  849.             
  850.             return $this->render('role/user/warehouse/stocks_register.html.twig', array(
  851.                 "form" => $form->createView(),
  852.                 'warehouse' => $warehouse
  853.             ));
  854.         }
  855.         
  856.         /**
  857.          * @Route("/{warehouseId}/scheda/scorte/rientra", name="user_warehouse_stocks_recover")
  858.          * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  859.          */
  860.         public function userWarehouseStocksRecover($warehouseId, Request $request, ValidatorInterface $validator, FormFactoryInterface $formFactory)
  861.         {    
  862.             $em = $this->mr->getManager('slave');
  863.             $session = $request->getSession();
  864.             $warehouse = $em->getRepository("App\Entity\Slave\Warehouse")->findOneById($warehouseId);
  865.             $productsIdsToRecover = array();
  867.             $countMoved = 0;
  868.             $error = "";
  869.             $recover = new ProductRecover();
  870.             $form = $formFactory->createNamed("form_recover", ProductRecoverType::class, $recover);
  871.             $form->handleRequest($request);
  872.             
  873.             if($form->isSubmitted()){
  875.                 if($form->get('gunOrImport')->getData())
  876.                     $methodRegister = 'import';
  877.                 else
  878.                     $methodRegister = 'gun';
  880.                 $valid = true;
  881.                 if($methodRegister == 'gun'){
  882.                     // IMPORTAZIONE TRAMITE SPARO
  883.                     if(sizeof($form->get('products')->getData()) <= 0){
  884.                         $valid = false;
  885.                         $form->get('products')->addError(new FormError('Inserire almeno una matricola prodotto!'));
  886.                     }
  887.                 }
  888.                 else{
  889.                     // IMPORTAZIONE TRAMITE FILE
  890.                     $valid = ValidationService::validateFile($validator, $form->get('filePath'), true, $form->get('file')->getData(), '10', array('csv', 'txt'));
  891.                 }
  893.                 if($valid && $form->isValid()){
  894.                     
  895.                     if($methodRegister == 'gun'){
  896.                         foreach($form->get('products')->getData() as $prod){
  897.                             $product = $em->getRepository('App\Entity\Slave\Product')->findOneById($prod->getId());
  898.                             if($product != null)
  899.                                 array_push($productsIdsToRecover, $product->getId());
  900.                         }
  901.                     }
  902.                     else{
  903.                         $row = 0;
  904.                         if(($handle = fopen($form->get('file')->getData(), "r")) !== FALSE) {
  905.                             while(($data = fgetcsv($handle, 1000, $form->get('separator')->getData())) !== FALSE) {
  906.                                 $data = array_map("utf8_encode", $data);
  907.                                 if($row > 0){
  908.                                     if(!($data[0] == null && $data[1] == null)){
  909.                                         $product = null;
  910.                                         if($product == null && $data[0] != null) $product = $em->getRepository('App\Entity\Slave\Product')->findOneBy(array('codeProducer' => $data[0]));
  911.                                         if($product == null && $data[1] != null) $product = $em->getRepository('App\Entity\Slave\Product')->findOneBy(array('codeSupplier' => $data[1]));
  912.                                         if($product != null){
  913.                                             if($product->getStatus()->getSlug() == 'transfer'){
  914.                                                 $error.= '<br>Errore alla riga '.($row + 1).' -> Impossibile spostare il prodotto '.$product->getCodeProducer().' poiché in fase "In trasferimento"';
  915.                                             }
  916.                                             if($product->getStatus()->getSlug() == 'in_use'){
  917.                                                 $error.= '<br>Errore alla riga '.($row + 1).' -> Impossibile spostare il prodotto '.$product->getCodeProducer().' poiché uso da un cliente';
  918.                                             }
  919.                                             if($product->getCondition()->getSlug() == 'historic'){
  920.                                                 $error = '<br>Errore alla riga '.($row + 1).' -> Impossibile spostare il prodotto '.$product->getCodeProducer().' poiché in una destinazione esterna';
  921.                                             }
  922.                                             array_push($productsIdsToRecover, $product->getId());
  923.                                         }
  924.                                         else{
  925.                                             if($data[0] != null)
  926.                                                 $code = $data[0];
  927.                                             else
  928.                                                 $code = $data[1];
  930.                                             $error.= '<br>Errore alla riga '.($row + 1).' -> Non è stato trovato alcun prodotto con codice '.$code;
  931.                                         }
  932.                                     }
  933.                                 }
  934.                                 $row++;
  935.                             }
  936.                             fclose($handle);
  937.                             if($error != ""){
  938.                                 $this->addFlash('notice_warning', "Errori rilevati:".$error);
  939.                                 return $this->redirectToRoute('user_warehouse_stocks_recover', array('warehouseId' => $warehouse->getId()));
  940.                             }
  941.                         }
  942.                     }
  943.                     
  944.                     // Scorro l'array di ProductIds e li rientro
  945.                     $statusNotAvailable = $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(['slug' => 'not_available']);
  946.                     foreach($productsIdsToRecover as $ptrId){
  947.                         $ptr = $em->getRepository('App\Entity\Slave\Product')->findOneById($ptrId);
  948.                         $oldStatusId = $ptr->getStatus()->getId();
  949.                         if($statusNotAvailable->getId() != $oldStatusId){
  950.                             ProductService::createProductLog($em, $ptr, $this->getUser(), null, 'status', $ptr->getStatus()->getValue(), $statusNotAvailable->getValue());
  951.                             $ptr->setStatus($statusNotAvailable);
  952.                         }
  953.                         if($ptr->getActualWarehouse()->getId() != $warehouse->getId()){
  954.                             ProductService::createProductTransferLog($em, $ptr, null, $this->getUser(), $warehouse, new \Datetime(), 'forced');
  955.                             $ptr->setActualWarehouse($warehouse);
  956.                         }
  957.                         $ptr->setDateLastTransfer(new \Datetime());
  958.                         $ptr->setToManage(true);
  959.                         $ptr->setToManagePriority(2);
  960.                         $countMoved++;
  961.                     }
  963.                     $em->flush();
  964.                     $this->addFlash('notice_success', '<br>Prodotti spostati: '.$countMoved);
  965.                     return $this->redirectToRoute('user_warehouse_sheet', array('warehouseId' => $warehouse->getId()));
  966.                 }
  967.             }
  968.             
  969.             return $this->render('role/user/warehouse/stocks_recover.html.twig', array(
  970.                 "form" => $form->createView(),
  971.                 'warehouse' => $warehouse
  972.             ));
  973.         }
  975.         /**
  976.          * @Route("/{warehouseId}/scheda/scorte/rientra-cerca", name="user_warehouse_stocks_recover_search")
  977.          * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  978.          */
  979.         public function userWarehouseStocksRecoverSearch($warehouseId, Request $request)
  980.         {
  981.             $em = $this->mr->getManager('slave');
  982.             $warehouse = $em->getRepository("App\Entity\Slave\Warehouse")->findOneById($warehouseId);
  983.             $productCode = $request->request->get('productCode');
  984.             $codeType = $request->request->get('codeType');
  985.             $product = null;
  986.             $error = 'Il prodotto con il codice "'.$productCode.'" non è stato trovato!';
  987.             $errorRead = 'Il prodotto non è stato trovato!';
  989.             $found = false;
  990.             $product = false;
  991.             if($productCode != null){
  992.                 switch($codeType){
  993.                     case 'producer': $product = $em->getRepository("App\Entity\Slave\Product")->findOneBy(['codeProducer' => $productCode]); break;
  994.                     case 'supplier': $product = $em->getRepository("App\Entity\Slave\Product")->findOneBy(['codeSupplier' => $productCode]); break;
  995.                     default: break;
  996.                 }
  997.             }
  999.             if($product != null){
  1000.                 if($product->getStatus()->getSlug() == 'transfer'){
  1001.                     $error = 'Impossibile spostare un prodotto in fase "In trasferimento"';
  1002.                     $errorRead = $error;
  1003.                     return new Response(json_encode(array("code" => 200, "success" => true, "found" => $found, "error" => $error, "errorRead" => $errorRead)));
  1004.                 }
  1005.                 if($product->getStatus()->getSlug() == 'in_use'){
  1006.                     $error = 'Impossibile spostare un prodotto in uso da un cliente';
  1007.                     $errorRead = $error;
  1008.                     return new Response(json_encode(array("code" => 200, "success" => true, "found" => $found, "error" => $error, "errorRead" => $errorRead)));
  1009.                 }
  1010.                 if($product->getCondition()->getSlug() == 'historic'){
  1011.                     $error = 'Impossibile spostare un prodotto in una destinazione esterna';
  1012.                     $errorRead = $error;
  1013.                     return new Response(json_encode(array("code" => 200, "success" => true, "found" => $found, "error" => $error, "errorRead" => $errorRead)));
  1014.                 }
  1015.                 $found = true;
  1016.                     
  1017.                 $json = '{
  1018.                     "id":"'.$product->getId().'", 
  1019.                     "codeProducer":"'.$product->getCodeProducer().'", 
  1020.                     "codeSupplier":"'.$product->getCodeSupplier().'",
  1021.                     "model":"'.$product->getModel()->getName().'",
  1022.                     "condition":"'.$product->displayCondition('string-short').'", 
  1023.                     "suppliers":"'.$product->displayStringSuppliers().'", 
  1024.                     "warehouseNickname":"'.$product->getActualWarehouse()->__toString().'"}';
  1026.                 return new Response(json_encode(array("code" => 200, "success" => true, "found" => $found, 'product' => $json)));
  1027.             }
  1029.             return new Response(json_encode(array("code" => 200, "success" => true, "found" => $found, "error" => $error, "errorRead" => $errorRead)));
  1030.         }
  1031.         
  1032.         /**
  1033.          * @Route("/{warehouseId}/scheda/scorte/rientra-sposta-prodotto", name="user_warehouse_stocks_recover_move_product")
  1034.          * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  1035.          */
  1036.         public function userWarehouseStocksRecoverMoveProduct($warehouseId, Request $request)
  1037.         {
  1038.             $em = $this->mr->getManager('slave');
  1039.             $session = $request->getSession();
  1040.             $product = $em->getRepository('App\Entity\Slave\Product')->findOneById($request->request->get('productId'));
  1041.             $warehouse = $em->getRepository("App\Entity\Slave\Warehouse")->findOneById($warehouseId);
  1043.             ProductService::createProductTransferLog($em, $product, null, $this->getUser(), $warehouse, new \Datetime(), 'manual');                
  1044.             $product->setActualWarehouse($warehouse);
  1045.             $product->setDateLastTransfer(new \Datetime);
  1046.             $em->flush();
  1048.             return new Response(json_encode(array("code" => 200, "success" => true)));
  1049.         }
  1050.         
  1051.         /**
  1052.          * @Route("/{warehouseId}/scheda/scorte/inventario", name="user_warehouse_stock_inventory")
  1053.          * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  1054.          */
  1055.         public function userWarehouseStockInventory($warehouseId, Request $request)
  1056.         {    
  1057.             $em = $this->mr->getManager('slave');
  1058.             $session = $request->getSession();
  1059.             $warehouse = $em->getRepository("App\Entity\Slave\Warehouse")->findOneById($warehouseId);
  1060.             $supplier = $em->getRepository("App\Entity\Slave\Supplier")->findOneById($session->get('inventorySupplierId'));
  1061.             $status = $em->getRepository("App\Entity\Slave\ProductStatus")->findOneById($session->get('inventoryStatusId'));
  1063.             return $this->render('role/user/warehouse/inventory.html.twig', array(
  1064.                 'warehouse' => $warehouse,
  1065.                 'supplier' => $supplier,
  1066.                 'status' => $status,
  1067.                 'results' => $session->get('inventoryResults')
  1068.             ));
  1069.         }
  1070.         
  1071.         /**
  1072.          * @Route("/{warehouseId}/scheda/scorte/inventario-esporta", name="user_warehouse_stock_inventory_export")
  1073.          * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  1074.          */
  1075.         public function userWarehouseStockInventoryExport($warehouseId, Request $request)
  1076.         {    
  1077.             $em = $this->mr->getManager('slave');
  1078.             $session = $request->getSession();
  1079.             $results = $session->get('inventoryResults');
  1080.             $warehouse = $em->getRepository("App\Entity\Slave\Warehouse")->findOneById($warehouseId);
  1081.             $supplier = $em->getRepository("App\Entity\Slave\Supplier")->findOneById($session->get('inventorySupplierId'));
  1082.             $status = $em->getRepository("App\Entity\Slave\ProductStatus")->findOneById($session->get('inventoryStatusId'));
  1083.     
  1084.             $response = new StreamedResponse();
  1085.             $response->setCallback(function() use($results, $warehouse, $supplier, $status) {
  1086.                 $handle = fopen('php://output', 'w+');
  1087.                 fputcsv($handle, array('Magazzino',$warehouse->getNickname(),'','',''), ";", '"', "\\");
  1088.                 fputcsv($handle, array('Fornitore',$supplier->getName(),'','',''), ";", '"', "\\");
  1089.                 fputcsv($handle, array('Stato',$status->getValue(),'','',''), ";", '"', "\\");
  1090.                 fputcsv($handle, array('Modello', 'Matricola produttore','Matricola fornitore','Magazzino attuale','Errore', 'Ultimo trasferimento'), ";", '"', "\\");
  1091.                 foreach($results as $r){
  1092.                     fputcsv($handle, array($r[2], $r[3], $r[4], $r[5], $r[6], $r[7]), ";", '"', "\\");
  1093.                 }
  1094.                 fclose($handle);
  1095.             });
  1096.             
  1097.             $response->setStatusCode(200);
  1098.             $dispositionHeader = $response->headers->makeDisposition(ResponseHeaderBag::DISPOSITION_ATTACHMENT, $warehouse->getNickname().' - Inventario.csv');
  1099.             $response->headers->set('Content-Type', 'text/csv; charset=ISO-8859-15');
  1100.             $response->headers->set('Content-Disposition', $dispositionHeader);
  1101.             return $response;
  1102.         }
  1103.     //
  1105.     // TRASFERIMENTI
  1106.         /**
  1107.          * @Route("/{warehouseId}/scheda/trasferimento/{transferId}/riprendi", name="user_warehouse_transfer_resume")
  1108.          * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  1109.          */
  1110.         public function userWarehouseTransferSelect(Request $request, $warehouseId, $transferId)
  1111.         {
  1112.             $em = $this->mr->getManager('slave');
  1113.             $session = $request->getSession();
  1114.             $warehouse = $em->getRepository("App\Entity\Slave\Warehouse")->findOneById($warehouseId);
  1115.             $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($transferId);
  1116.             if($transfer->getWarehouseTo()->getId() == $warehouse->getId()){
  1117.                 return $this->redirectToRoute('user_warehouse_transfer_receive', array('warehouseId' => $warehouseId, 'transferId' => $transferId));
  1118.             }
  1119.             elseif($transfer->getWarehouseFrom()->getId() == $warehouse->getId()){
  1120.                 $session->set('action_edit', true);
  1121.                 return $this->redirectToRoute('user_warehouse_transfer_send', array('warehouseId' => $warehouseId, 'transferId' => $transferId));
  1122.             }
  1123.         }
  1125.         /**
  1126.          * @Route("/{warehouseId}/scheda/trasferimento/elimina", name="user_warehouse_transfer_delete")
  1127.          * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  1128.          */
  1129.         public function userWarehouseTransferDelete($warehouseId, Request $request)
  1130.         {    
  1131.             $em = $this->mr->getManager('slave');
  1132.             $session = $request->getSession();
  1133.             $transfer = $em->getRepository("App\Entity\Slave\ProductTransfer")->findOneById($request->request->get("transferDelId"));
  1135.             foreach($transfer->getProducts() as $jtppt){
  1136.                 $status = ProductService::getStatusByCondition($em, $jtppt->getProduct()->getCondition());
  1137.                 ProductService::createProductLog($em, $jtppt->getProduct(), $this->getUser(), null, 'status', $jtppt->getProduct()->getStatus()->getValue(), $status->getValue());
  1138.                 $jtppt->getProduct()->setStatus($status);
  1139.                 $em->remove($jtppt);
  1140.             }
  1141.             $em->remove($transfer);
  1142.             $em->flush();
  1144.             $this->addFlash('notice_success', "Trasferimento eliminato");
  1145.             return $this->redirectToRoute('user_warehouse_sheet', array('warehouseId' => $warehouseId));
  1146.         }
  1148.         /**
  1149.          * @Route("/{warehouseId}/scheda/trasferimento-aggiorna-magazzini", name="user_warehouse_transfer_update_warehouses")
  1150.          * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  1151.          */
  1152.         public function userWarehouseTransferUpdateWarehouses($warehouseId, Request $request)
  1153.         {    
  1154.             $em = $this->mr->getManager('slave');
  1155.             $type = $request->request->get("type");
  1156.             switch($type){
  1157.                 case 'technician': $warehouses = $em->getRepository('App\Entity\Slave\Warehouse')->findWarehousesTechnicians($warehouseId); break;
  1158.                 case 'destination': $warehouses = $em->getRepository('App\Entity\Slave\Warehouse')->findWarehousesDestinations(); break;
  1159.                 case 'main': $warehouses = $em->getRepository('App\Entity\Slave\Warehouse')->findHeadquarterWarehouses(); break;
  1160.                 default: break;
  1161.             }
  1163.             $first = true;
  1164.             $json = "[";
  1165.             foreach($warehouses as $w){
  1166.                 if($first) $first = false; else $json.= ',';
  1167.                 $json.= '{"id":'.$w->getId().', "nickname":"'.$w->getNickname().'"}';
  1168.             }
  1169.             $json.= "]";
  1170.         
  1171.             return new Response(json_encode(array("code" => 200, "success" => true, "warehouses" => $json))); 
  1172.         }
  1174.         /**
  1175.          * @Route("/{warehouseId}/scheda/trasferimento-aggiorna-magazzini-tecnico", name="user_warehouse_transfer_update_technician_warehouses")
  1176.          * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  1177.          */
  1178.         public function userWarehouseTransferUpdateTechnicianWarehouses($warehouseId, Request $request)
  1179.         {    
  1180.             $em = $this->mr->getManager('slave');
  1181.             $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($request->request->get("transferId"));
  1182.             $technician = $em->getRepository('App\Entity\Slave\User')->findOneById($request->request->get("technicianId"));
  1184.             $first = true;
  1185.             $json = "[";
  1186.             if($transfer != null){
  1187.                 switch($transfer->getType()){
  1188.                     case 'technician':
  1189.                         foreach($technician->getWarehouses() as $jt){
  1190.                             if($jt->getPermission() == "RW"){
  1191.                                 if($first) $first = false; else $json.= ',';
  1192.                                 $json.= '{"id":'.$jt->getWarehouse()->getId().', "nickname":"'.$jt->getWarehouse()->getNickname().'"}';
  1193.                             }
  1194.                         }
  1195.                         break;
  1196.                     case 'destination':
  1197.                         $warehouses = $em->getRepository('App\Entity\Slave\Warehouse')->findWarehousesDestinations();
  1198.                         foreach($warehouses as $w){
  1199.                             if($first) $first = false; else $json.= ',';
  1200.                             $json.= '{"id":'.$w->getId().', "nickname":"'.$w->getNickname().'"}';
  1201.                         }
  1202.                         break;
  1203.                     default: break;
  1204.                 }
  1205.             }
  1206.             else{
  1207.                 foreach($technician->getWarehouses() as $jt){
  1208.                     if($jt->getPermission() == "RW"){
  1209.                         if($first) $first = false; else $json.= ',';
  1210.                         $json.= '{"id":'.$jt->getWarehouse()->getId().', "nickname":"'.$jt->getWarehouse()->getNickname().'"}';
  1211.                     }
  1212.                 }
  1213.             }
  1214.             $json.= "]";
  1215.         
  1216.             return new Response(json_encode(array("code" => 200, "success" => true, "warehouses" => $json))); 
  1217.         }
  1219.         /**
  1220.          * @Route("/{warehouseId}/scheda/trasferimento/{transferId}/scheda", name="user_warehouse_transfer_sheet")
  1221.          * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId) || is_granted('transfer_edit', transferId)")
  1222.          */
  1223.         public function userWarehouseTransferSheet($warehouseId, $transferId, Request $request, ValidatorInterface $validator, FormFactoryInterface $formFactory, FileSystem $fs)
  1224.         {    
  1225.             $em = $this->mr->getManager('slave');
  1226.             $emMaster = $this->mr->getManager('master');
  1227.             $session = $request->getSession();
  1228.             $transferInternalDdtActive = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'use_ddt'))->getValue();
  1229.             $warehouse = $em->getRepository('App\Entity\Slave\Warehouse')->findOneById($warehouseId);
  1230.             $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($transferId);
  1231.             $transferType = $transfer->getType();
  1232.             $company = $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get("companyId"));
  1233.             $uploadDir = $this->params->get('kernel.project_dir').'/'.$this->params->get('web_path').'/companies/'.$company->getDirectoryPath().'/ddt/';
  1234.             $session->remove('productRequestId');
  1236.             // RESETTO VARIABILI STAMPA
  1237.             $session->remove('ddtHeader');
  1238.             $session->remove('port');
  1239.             $session->remove('ddtCausal');
  1240.             $session->remove('appearance');
  1241.             $session->remove('numberGoods');
  1242.             $session->remove('weight');
  1243.             $session->remove('transport');
  1244.             $session->remove('courier');
  1245.             $session->remove('courierId');
  1246.             $session->remove('notes');
  1247.                     
  1248.             $uploadDir = $this->params->get('kernel.project_dir').'/'.$this->params->get('web_path').'/companies/'.$company->getDirectoryPath().'/ddt/';
  1249.             
  1250.             // EDIT TRANSFER DATA
  1251.             $formEdit = $formFactory->createNamed("form_transfer_edit", ProductTransferEditType::class, $transfer);
  1252.             $formEdit->handleRequest($request);
  1253.             
  1254.             if($formEdit->isSubmitted()){
  1256.                 $valid = true;
  1257.                 // Da destinazione a sede centrale
  1258.                 if($transfer->getType() == 'destination' && $transfer->getWarehouseTo()->getId() == $warehouse->getId() && $formEdit->get('ddtMandatory')->getData()){
  1259.                     if($valid) $valid = ValidationService::validateNotBlank($validator, $formEdit->get('ddt'));
  1260.                     if($valid && $formEdit->get('file')->getData() != null) $valid = ValidationService::validateFile($validator, $formEdit->get('signedDdtPath'), true, $formEdit->get('file')->getData(), '10', array('pdf', 'jpg', 'jpeg', 'png'));
  1261.                 }
  1263.                 if($valid && $formEdit->isValid()){
  1264.                     
  1265.                     // Da destinazione a sede centrale
  1266.                     if($transfer->getType() == 'destination'){
  1267.                         $transfer->setWarehouseTo($formEdit->get('warehouse')->getData());
  1268.                         if($transfer->getWarehouseTo()->getId() == $warehouse->getId()){
  1269.                             $transfer->setDdtMandatory($formEdit->get('ddtMandatory')->getData());
  1270.                             if($formEdit->get('ddtMandatory')->getData()){
  1271.                                 $transfer->setDdt($formEdit->get('ddt')->getData());
  1272.                                 if($formEdit->get('file')->getData() != null)
  1273.                                     MediaService::uploadDocument($formEdit->get('file')->getData(), $uploadDir, $transfer, 'signedDdt');
  1274.                             }
  1275.                         }
  1276.                     }
  1277.                     if($transfer->getType() == 'technician'){
  1278.                         $transfer->setDdtMandatory($formEdit->get('ddtMandatory')->getData());
  1279.                         if($transfer->getPhase() == 'inserted' || $transfer->getPhase() == 'inserted_editable'){
  1280.                             $transfer->setUserTo($formEdit->get('userTo')->getData());
  1281.                             $transfer->setWarehouseTo($formEdit->get('warehouse')->getData());
  1282.                         }
  1283.                     }
  1285.                     $this->addFlash('notice_success', "Dati aggiornati!");
  1286.                     $em->flush();
  1287.                     return $this->redirectToRoute('user_warehouse_transfer_sheet', array('warehouseId' => $warehouseId, 'transferId' => $transferId));
  1288.                 }
  1289.                 else{
  1290.                     $session->set('openEditModal', true);
  1291.                 }
  1292.             }            
  1294.             // UPLOAD DDT
  1295.             $formDdt = $formFactory->createNamed("form_transfer_ddt", ProductTransferDdtType::class, $transfer);
  1296.             $formDdt->handleRequest($request);
  1297.             
  1298.             if($formDdt->isSubmitted()){
  1300.                 $valid = ValidationService::validateFile($validator, $formDdt->get('ddtPath'), true, $formDdt->get('file')->getData(), '10',array('pdf', 'jpg', 'jpeg', 'png'));
  1301.                 $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($request->request->get('transferId'));
  1303.                 if($valid && $formDdt->isValid()){
  1304.                     
  1305.                     if($formDdt->get('file')->getData() != null){
  1306.                         if($formDdt->get('file')->getData()->guessExtension() == 'pdf')
  1307.                             MediaService::uploadDocument($formDdt->get('file')->getData(), $uploadDir, $transfer, 'signedDdt');
  1308.                         else
  1309.                             MediaService::uploadImage($fs, $formDdt->get('file')->getData(), null, $uploadDir, $transfer, 'signedDdt', 100, 1000, 200, false);
  1310.                     }
  1312.                     $transfer->setPhaseDdt('completed');
  1313.                    
  1314.                     $conditionHistoric = $em->getRepository('App\Entity\Slave\ProductCondition')->findOneBySlug('historic');
  1315.                     $statusNotAvailable = $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBySlug('not_available');
  1316.                     foreach($transfer->getProducts() as $jtppt){
  1317.                         $product = $jtppt->getProduct();
  1318.                         ProductService::createProductTransferLog($em, $product, $jtppt->getTransfer(), $this->getUser(), null, new \Datetime(), 'scan');
  1319.                         ProductService::moveProductTransfer($em, $jtppt, $this->getUser(), $statusNotAvailable);
  1320.                         ProductService::createProductLog($em, $product, $this->getUser(), null, 'condition', $product->getCondition()->getValue(), $conditionHistoric->getValue());
  1321.                         $product->setCondition($conditionHistoric);
  1322.                     }
  1323.                     $transfer->setPhase('completed');
  1324.                     $transfer->setDatetimeCompletion(new \Datetime());
  1325.                     $this->addFlash('notice_success', "Consegna registrata!");
  1326.                     $em->flush();
  1327.                     return $this->redirectToRoute('user_warehouse_transfer_sheet', array('warehouseId' => $warehouseId, 'transferId' => $transferId));
  1328.                 }
  1329.             }
  1330.             
  1331.             // CHANGE UPLOADED DDT
  1332.             $formChangeDdt = $formFactory->createNamed("form_transfer_change_ddt", ProductTransferDdtType::class, $transfer);
  1333.             $formChangeDdt->handleRequest($request);
  1334.             
  1335.             if($formChangeDdt->isSubmitted()){
  1337.                 $valid = ValidationService::validateFile($validator, $formChangeDdt->get('ddtPath'), true, $formChangeDdt->get('file')->getData(), '10',array('pdf', 'jpg', 'jpeg', 'png'));
  1338.                 $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($request->request->get('transferId'));
  1340.                 if($valid && $formChangeDdt->isValid()){
  1341.                     
  1342.                     if($formChangeDdt->get('file')->getData() != null){
  1343.                         MediaService::removeDocument($fs, $transfer->getSignedDdtPath(), $uploadDir);
  1344.                         if($formChangeDdt->get('file')->getData()->guessExtension() == 'pdf')
  1345.                             MediaService::uploadDocument($formChangeDdt->get('file')->getData(), $uploadDir, $transfer, 'signedDdt');
  1346.                         else
  1347.                             MediaService::uploadImage($fs, $formChangeDdt->get('file')->getData(), null, $uploadDir, $transfer, 'signedDdt', 100, 1000, 200, false);
  1348.                     }
  1349.                                         
  1350.                     $transfer->setPhaseDdt('completed');
  1351.                     $em->flush();
  1352.                     $this->addFlash('notice_success', "DDT caricato!");
  1353.                     return $this->redirectToRoute('user_warehouse_transfer_sheet', array('warehouseId' => $warehouseId, 'transferId' => $transferId));
  1354.                 }
  1355.             }
  1356.             
  1357.             return $this->render('role/user/warehouse/transfer/sheet.html.twig', array(
  1358.                 'company' => $company,
  1359.                 'warehouse' => $warehouse,
  1360.                 'transfer' => $transfer,
  1361.                 'transferType' => $transferType,
  1362.                 'transferInternalDdtActive' => $transferInternalDdtActive,
  1363.                 'formEdit' => $formEdit->createView(),
  1364.                 'formDdt' => $formDdt->createView(),
  1365.                 'formChangeDdt' => $formChangeDdt->createView()
  1366.             ));
  1367.         }
  1369.         // RICEVI
  1370.             /**
  1371.              * @Route("/{warehouseId}/scheda/trasferimento/{transferId}/ricevi", name="user_warehouse_transfer_receive")
  1372.              * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  1373.              */
  1374.             public function userWarehouseTransferReceive($warehouseId, $transferId, Request $request, ValidatorInterface $validator, FormFactoryInterface $formFactory)
  1375.             {    
  1376.                 $em = $this->mr->getManager('slave');
  1377.                 $session = $request->getSession();
  1378.                 $warehouse = $em->getRepository("App\Entity\Slave\Warehouse")->findOneById($warehouseId);
  1379.                 $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($transferId);
  1380.                 $transferType = $transfer->getType();
  1382.                 $register = new ProductRegister();
  1383.                 $form = $formFactory->createNamed("form_transfer_receive", ProductRegisterType::class, $register);
  1384.                 $form->handleRequest($request);
  1385.                 
  1386.                 if($form->isSubmitted()){
  1388.                     [$valid, $methodRegister, $errorMsg] = FormValidatorService::validateProductReceive($em, $validator, $form, $transferType);
  1390.                     if($valid && $form->isValid()){
  1391.                         
  1392.                         $arrayProducerCodes = array();
  1393.                         $arraySupplierCodes = array();
  1394.                         $countProductsUpdated = 0;
  1395.                         $countProductsNew = 0;
  1396.                         $countProductsDouble = 0;
  1397.                         $productsUpdatedMats = "";
  1398.                         $productsDoubleMats = "";
  1399.                         $status = $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'transfer'));
  1400.                         $transfer->setPhase('product_insert');
  1402.                         if($methodRegister == 'gun'){
  1403.                             // IMPORTAZIONE TRAMITE SPARO
  1404.                             foreach($form->get('products')->getData() as $prod){
  1405.                                 if(!($prod->getCodeProducer() == null && $prod->getCodeSupplier() == null)){
  1406.                                     [$product, $arrayProducerCodes, $arraySupplierCodes, $countProductsUpdated, $countProductsNew, $countProductsDouble, $productsUpdatedMats, $productsDoubleMats] = $this->registerReceiveProducts($em, $warehouse, $status, $form, $prod->getCodeProducer(), $prod->getCodeSupplier(), $arrayProducerCodes, $arraySupplierCodes, $countProductsUpdated, $countProductsNew, $countProductsDouble, $productsUpdatedMats, $productsDoubleMats);
  1407.                                     ProductService::createJtProductTransfer($em, $product, $transfer, new \Datetime());
  1408.                                 }
  1409.                             }
  1410.                         }
  1411.                         else{
  1412.                             // IMPORTAZIONE TRAMITE FILE
  1413.                             $result = ProductService::checkProducts($form->get('file')->getData(), $form->get('separator')->getData());
  1414.                             
  1415.                             if($result['error'] != null){
  1416.                                 $this->addFlash('notice_danger', $result['msg']);
  1417.                                 return $this->redirect($request->server->get('HTTP_REFERER'));
  1418.                             }
  1419.                             else{
  1420.                                 $row = 0;
  1421.                                 if(($handle = fopen($form->get('file')->getData(), "r")) !== FALSE) {
  1422.                                     while(($data = fgetcsv($handle, 1000, $form->get('separator')->getData())) !== FALSE) {
  1423.                                         $data = array_map("utf8_encode", $data);
  1424.                                         if($row > 0){
  1425.                                             if(!($data[0] == null && $data[1] == null)){
  1426.                                                 [$product, $arrayProducerCodes, $arraySupplierCodes, $countProductsUpdated, $countProductsNew, $countProductsDouble, $productsUpdatedMats, $productsDoubleMats] = $this->registerReceiveProducts($em, $warehouse, $status, $form, $data[0], $data[1], $arrayProducerCodes, $arraySupplierCodes, $countProductsUpdated, $countProductsNew, $countProductsDouble, $productsUpdatedMats, $productsDoubleMats);
  1427.                                                 ProductService::createJtProductTransfer($em, $product, $transfer, new \Datetime());
  1428.                                             }
  1429.                                         }
  1430.                                         $row++;
  1431.                                     }
  1432.                                     fclose($handle);
  1433.                                 }
  1434.                             }
  1435.                         }
  1436.                         
  1437.                         $em->flush();
  1439.                         if($request->request->get('submit_action') == 'add_products')
  1440.                             return $this->redirectToRoute('user_warehouse_transfer_receive', array('warehouseId' => $warehouse->getId(), 'transferId' => $transfer->getId()));
  1441.                         else{
  1442.                             foreach($transfer->getProducts() as $jtppt){
  1443.                                 $status = $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'available'));
  1444.                                 ProductService::moveProductTransfer($em, $jtppt, $this->getUser(), $status);
  1445.                                 ProductService::createProductTransferLog($em, $jtppt->getProduct(), $transfer, $this->getUser(), null, new \Datetime(), 'scan');
  1446.                             }
  1447.                             $transfer->setPhase('completed');
  1448.                             $transfer->setDatetimeCompletion(new \Datetime());
  1449.                             $em->flush();
  1450.                             $this->addFlash('notice_success', '<br>Prodotti nuovi inseriti: '.$countProductsNew.'<br>Prodotti aggiornati: '.$countProductsUpdated.$productsUpdatedMats.'<br>Prodotti doppi ignorati: '.$countProductsDouble.$productsDoubleMats);
  1451.                             return $this->redirectToRoute('user_warehouse_transfer_sheet', array('warehouseId' => $warehouseId, 'transferId' => $transfer->getId()));
  1452.                         }
  1453.                     }
  1454.                     else{
  1455.                         $receiveSuppliersIds = [];
  1456.                         foreach($form->get('suppliers')->getData() as $sup){
  1457.                             array_push($receiveSuppliersIds, $sup->getId());
  1458.                         }
  1459.                         $session->set('receiveSuppliersIds', $receiveSuppliersIds);
  1460.                         if($errorMsg != ''){
  1461.                             $this->addFlash('notice_danger', $errorMsg);
  1462.                         }
  1463.                     }
  1464.                 }
  1465.                 
  1466.                 return $this->render('role/user/warehouse/transfer/receive.html.twig', array(
  1467.                     'transfer' => $transfer,
  1468.                     'transferType' => $transferType,
  1469.                     'warehouse' => $warehouse,
  1470.                     "form" => $form->createView()
  1471.                 ));
  1472.             }
  1474.             /**
  1475.              * @Route("/{warehouseId}/scheda/trasferimento/{transferId}/ricevi-concludi", name="user_warehouse_transfer_receive_complete")
  1476.              * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  1477.              */
  1478.             public function userWarehouseTransferReceiveComplete($warehouseId, $transferId, Request $request)
  1479.             {    
  1480.                 $em = $this->mr->getManager('slave');
  1481.                 $session = $request->getSession();
  1482.                 $warehouse = $em->getRepository("App\Entity\Slave\Warehouse")->findOneById($warehouseId);
  1483.                 $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($transferId);
  1484.                 $status = $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'available'));
  1486.                 foreach($transfer->getProducts() as $jtppt){
  1487.                     ProductService::moveProductTransfer($em, $jtppt, $this->getUser(), $status);
  1488.                     ProductService::createProductTransferLog($em, $jtppt->getProduct(), $transfer, $this->getUser(), null, new \Datetime(), 'scan');
  1489.                 }
  1490.                 $transfer->setPhase('completed');
  1491.                 $transfer->setDatetimeCompletion(new \Datetime());
  1492.                 $em->flush();
  1494.                 $this->addFlash('notice_success', 'Prodotti inseriti a magazzino');
  1496.                 return $this->redirectToRoute('user_warehouse_transfer_sheet', array('warehouseId' => $warehouseId, 'transferId' => $transfer->getId()));
  1497.             }
  1498.                         
  1499.             /**
  1500.              * @Route("/{warehouseId}/scheda/trasferimento/{transferId}/scarica-materiale", name="user_warehouse_transfer_download")
  1501.              * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  1502.              */
  1503.             public function userWarehouseTransferDownload($warehouseId, $transferId, Request $request, ValidatorInterface $validator, FormFactoryInterface $formFactory, FileSystem $fs)
  1504.             {    
  1505.                 $em = $this->mr->getManager('slave');
  1506.                 $emMaster = $this->mr->getManager('master');
  1507.                 $session = $request->getSession();
  1509.                 $transferInternalDdtActive = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'use_ddt'))->getValue();
  1510.                 $company = $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get("companyId"));
  1511.                 $uploadDir = $this->params->get('kernel.project_dir').'/'.$this->params->get('web_path').'/companies/'.$company->getDirectoryPath().'/ddt/';
  1512.                 $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($transferId);
  1514.                 // SCARICA MATERIALE
  1515.                 $form = $formFactory->createNamed("form_transfer_download", ProductTransferDownloadType::class, $transfer, array('transferId' => $transfer->getId()));
  1516.                 $form->handleRequest($request);
  1517.                 
  1518.                 if($form->isSubmitted()){
  1519.     
  1520.                     $file = $form->get('file')->getData();
  1521.                     $valid = true;
  1522.                     if($transferInternalDdtActive && $transfer->isDdtMandatory()){
  1523.                         $valid = ValidationService::validateFile($validator, $form->get('ddtPath'), true, $file, 10, array('pdf', 'jpg', 'jpeg', 'png'));
  1524.                     }
  1526.                     if($valid && $form->isValid()){
  1527.     
  1528.                         if($transferInternalDdtActive){
  1529.                             if($file != null){
  1530.                                 if($file->guessExtension() == 'pdf')
  1531.                                     MediaService::uploadDocument($file, $uploadDir, $transfer, 'signedDdt');
  1532.                                 else
  1533.                                     MediaService::uploadImage($fs, $file, null, $uploadDir, $transfer, 'signedDdt', 100, 1000, 200, false);
  1534.                                 $transfer->setPhaseDdt('completed');
  1535.                             }
  1536.                             else{
  1537.                                 $transfer->setPhaseDdt('signed_missing');
  1538.                             }
  1539.                         }
  1540.                         $transfer->setPhase('completed');
  1541.                         $transfer->setDatetimeCompletion(new \Datetime());
  1543.                         [$status, $toManage, $toManagePriority] = $this->downloadSetByType($em, $transfer);
  1544.                         
  1545.                         if($request->request->get('jtpptGunIds') != null){
  1546.                             $gunIds = explode(',', $request->request->get('jtpptGunIds'));
  1547.                             for($i = 0; $i < sizeof($gunIds); $i++){
  1548.                                 $jtppt = $em->getRepository('App\Entity\Slave\JoinTableProductProductTransfer')->findOneById($gunIds[$i]);
  1549.                                 ProductService::moveProductTransfer($em, $jtppt, $this->getUser(), $status);
  1550.                                 ProductService::createProductTransferLog($em, $jtppt->getProduct(), $transfer, $this->getUser(), null, new \Datetime(), 'scan');
  1551.                                 $jtppt->setDownloadType('scan');
  1552.                                 $jtppt->getProduct()->setToManage($toManage);
  1553.                                 $jtppt->getProduct()->setToManagePriority($toManagePriority);
  1554.                             }
  1555.                         }
  1556.                         
  1557.                         if($request->request->get('jtpptManualIds') != null){
  1558.                             $manualIds = explode(',', $request->request->get('jtpptManualIds'));
  1559.                             for($i = 0; $i < sizeof($manualIds); $i++){
  1560.                                 $jtppt = $em->getRepository('App\Entity\Slave\JoinTableProductProductTransfer')->findOneById($manualIds[$i]);
  1561.                                 ProductService::moveProductTransfer($em, $jtppt, $this->getUser(), $status);
  1562.                                 ProductService::createProductTransferLog($em, $jtppt->getProduct(), $transfer, $this->getUser(), null, new \Datetime(), 'manual');
  1563.                                 $jtppt->setDownloadType('manual');
  1564.                                 $jtppt->getProduct()->setToManage($toManage);
  1565.                                 $jtppt->getProduct()->setToManagePriority($toManagePriority);
  1566.                             }
  1567.                         }
  1568.                         $em->flush();
  1570.                         // I PRODOTTI NON SCARICATI LI RIMETTO NELLO STATO PRECEDENTE
  1571.                         foreach($transfer->getProducts() as $jtppt){
  1572.                             if(!$jtppt->isTransferOk()){
  1573.                                 if($jtppt->getProduct()->getCondition()->isStatusAvailable())
  1574.                                     $status = $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'available'));
  1575.                                 else
  1576.                                     $status = $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'not_available'));
  1577.                                 ProductService::createProductLog($em, $jtppt->getProduct(), $this->getUser(), null, 'status', $jtppt->getProduct()->getStatus()->getValue(), $status->getValue());
  1578.                                 ProductService::createProductTransferBackLog($em, $jtppt->getProduct(), $transfer, $this->getUser(), null, new \Datetime(), 'manual');
  1579.                                 $jtppt->getProduct()->setStatus($status);
  1580.                                 if($transfer->getWarehouseFrom()->isHeadquarter()){
  1581.                                     $jtppt->getProduct()->setToManage(true);
  1582.                                     $jtppt->getProduct()->setToManagePriority('5');
  1583.                                 }
  1584.                             }
  1585.                         }
  1586.                         
  1587.                         $em->flush();
  1588.                         
  1589.                         $this->addFlash('notice_success', 'Trasferimento scaricato correttamente!');
  1590.                         return $this->redirectToRoute('user_warehouse_transfer_sheet', array('warehouseId' => $warehouseId, 'transferId' => $transfer->getId()));
  1591.                     }
  1592.                     else{
  1593.                         $session->set('openModalTransferComplete', true);
  1594.                         $session->set('jtpptGunIds', $request->request->get('jtpptGunIds'));
  1595.                         $session->set('jtpptManualIds', $request->request->get('jtpptManualIds'));
  1596.                     }
  1597.                 }
  1599.                 return $this->render('role/user/warehouse/transfer/download.html.twig', array(
  1600.                     'company' => $company,
  1601.                     'transfer' => $transfer,
  1602.                     'transferInternalDdtActive' => $transferInternalDdtActive,
  1603.                     "form" => $form->createView()
  1604.                 ));
  1605.             }
  1607.             /**
  1608.              * @Route("/{warehouseId}/scheda/trasferimento/scarica-materiale/parziale", name="user_warehouse_transfer_download_partial")
  1609.              * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  1610.              */
  1611.             public function userWarehouseTransferDownloadPartial($warehouseId, Request $request)
  1612.             {
  1613.                 $em = $this->mr->getManager('slave');
  1614.                 $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($request->request->get('transferId'));
  1615.                 [$status, $toManage, $toManagePriority] = $this->downloadSetByType($em, $transfer);
  1617.                 if($request->request->get('jtpptGunIds') != null){
  1618.                     $gunIds = explode(',', $request->request->get('jtpptGunIds'));
  1619.                     for($i = 0; $i < sizeof($gunIds); $i++){
  1620.                         $jtppt = $em->getRepository('App\Entity\Slave\JoinTableProductProductTransfer')->findOneById($gunIds[$i]);
  1621.                         ProductService::moveProductTransfer($em, $jtppt, $this->getUser(), $status);
  1622.                         ProductService::createProductTransferLog($em, $jtppt->getProduct(), $transfer, $this->getUser(), null, new \Datetime(), 'scan');
  1623.                         $jtppt->setDownloadType('scan');
  1624.                         $jtppt->getProduct()->setToManage($toManage);
  1625.                         $jtppt->getProduct()->setToManagePriority($toManagePriority);
  1626.                     }
  1627.                 }
  1628.                 
  1629.                 if($request->request->get('jtpptManualIds') != null){
  1630.                     $manualIds = explode(',', $request->request->get('jtpptManualIds'));
  1631.                     for($i = 0; $i < sizeof($manualIds); $i++){
  1632.                         $jtppt = $em->getRepository('App\Entity\Slave\JoinTableProductProductTransfer')->findOneById($manualIds[$i]);
  1633.                         ProductService::moveProductTransfer($em, $jtppt, $this->getUser(), $status);
  1634.                         ProductService::createProductTransferLog($em, $jtppt->getProduct(), $transfer, $this->getUser(), null, new \Datetime(), 'manual');
  1635.                         $jtppt->setDownloadType('manual');
  1636.                         $jtppt->getProduct()->setToManage($toManage);
  1637.                         $jtppt->getProduct()->setToManagePriority($toManagePriority);
  1638.                     }
  1639.                 }
  1640.                 
  1641.                 $em->flush();
  1643.                 $this->addFlash('notice_success', 'Trasferimento parziale effettuato!');
  1644.                 return $this->redirectToRoute('user_warehouse_transfer_sheet', array('warehouseId' => $warehouseId, 'transferId' => $transfer->getId()));
  1645.             }
  1647.             /**
  1648.              * @Route("/{warehouseId}/scheda/trasferimento/scarica-materiale/cerca", name="user_warehouse_transfer_download_search")
  1649.              * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  1650.              */
  1651.             public function userWarehouseTransferDownloadSearch($warehouseId, Request $request)
  1652.             {
  1653.                 $em = $this->mr->getManager('slave');
  1654.                 $session = $request->getSession();
  1655.                 $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($request->request->get('transferId'));
  1656.                 $productCode = $request->request->get('productCode');
  1658.                 $jtpptId = null;
  1659.                 $found = false;
  1660.                 foreach($transfer->getProducts() as $jtppt){
  1661.                     if($productCode == $jtppt->getProduct()->getCodeProducer() || $productCode == $jtppt->getProduct()->getCodeSupplier()){
  1662.                         $jtpptId = $jtppt->getId();
  1663.                         $found = true;
  1664.                         break;
  1665.                     }
  1666.                 }
  1668.                 return new Response(json_encode(array("code" => 200, "success" => true, "found" => $found, 'jtpptId' => $jtpptId)));
  1669.             }
  1670.         //
  1672.         // INVIA
  1673.             /**
  1674.              * @Route("/{warehouseId}/scheda/trasferimento/{transferId}/invia", name="user_warehouse_transfer_send")
  1675.              * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  1676.              */
  1677.             public function userWarehouseTransferSend($warehouseId, $transferId, Request $request, ValidatorInterface $validator, FormFactoryInterface $formFactory)
  1678.             {
  1679.                 $em = $this->mr->getManager('slave');
  1680.                 $emMaster = $this->mr->getManager('master');
  1681.                 $session = $request->getSession();
  1682.                 $company = $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get("companyId"));
  1683.                 $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($transferId);
  1684.                 $warehouse = $em->getRepository("App\Entity\Slave\Warehouse")->findOneById($warehouseId);
  1685.                 $transferInternalDdtActive = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'use_ddt'))->getValue();
  1687.                 $form = $formFactory->createNamed("form_transfer_send", ProductTransferSendProductsType::class, $transfer);
  1688.                 $form->handleRequest($request);
  1689.                 
  1690.                 if($form->isSubmitted()){
  1691.                     [$valid, $methodRegister, $errorMsg, $arrayProducts] = FormValidatorService::validateProductSend($em, $validator, $form, $warehouse);
  1693.                     // Se magazzino principale e verso destinazione esterna -> Controllo se prodotti hanno il fornitore inserito
  1694.                     if($valid && $warehouse->isHeadquarter() && $transfer->getType() == 'destination'){
  1695.                         foreach($arrayProducts as $p){
  1697.                             $suppliersIds = [];
  1698.                             foreach($p->getSuppliers() as $sup){
  1699.                                 array_push($suppliersIds, $sup->getId());
  1700.                             }
  1702.                             if(!in_array($transfer->getSupplier()->getId(), $suppliersIds)){
  1703.                                 $valid = false;
  1704.                                 $errorMsg = 'Il prodotto '.$p.' non ha il fornitore inserito '.$transfer->getSupplier();
  1705.                                 $form->get('file')->addError(new FormError('Il prodotto '.$p.' non ha il fornitore inserito '.$transfer->getSupplier()));
  1706.                                 break;
  1707.                             }
  1708.                         }
  1709.                     }
  1711.                     if($valid && $form->isValid()){
  1713.                         // Se i controlli sono andati a buon fine -> inserisco le JoinTableProductTransfer per le righe non vuote
  1714.                         $status = $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'transfer'));
  1715.                         foreach($arrayProducts as $product){
  1716.                             ProductService::createProductLog($em, $product, $this->getUser(), null, 'status', $product->getStatus()->getValue(), $status->getValue());
  1717.                             $product->setStatus($status);
  1718.                             ProductService::createJtProductTransfer($em, $product, $transfer, new \Datetime());
  1719.                         }
  1720.                         
  1721.                         if($transferInternalDdtActive || $transfer->getType() == 'destination'){
  1722.                             $transfer->setPhase('inserted_editable');
  1723.                             $transfer->setPhaseDdt('create');
  1724.                         }
  1725.                         else{
  1726.                             $transfer->setPhase('waiting_receiver');
  1727.                         }
  1728.                         $em->flush();
  1729.                         
  1730.                         $session->remove('transferStocksIds');
  1732.                         if($request->request->get('submit_action') == 'ddt')
  1733.                             return $this->redirectToRoute('user_warehouse_transfer_create_ddt', array('warehouseId' => $warehouseId, 'transferId' => $transfer->getId()));
  1734.                         else
  1735.                             return $this->redirectToRoute('user_warehouse_transfer_sheet', array('warehouseId' => $warehouse->getId(), 'transferId' => $transfer->getId()));
  1736.                     }
  1737.                     else{
  1738.                         $this->addFlash('notice_danger', $errorMsg);       
  1739.                         return $this->redirect($request->server->get('HTTP_REFERER'));
  1740.                     }
  1741.                 }
  1742.                 
  1743.                 return $this->render('role/user/warehouse/transfer/send.html.twig', array(
  1744.                     'company' => $company,
  1745.                     'transfer' => $transfer,
  1746.                     'warehouse' => $warehouse,
  1747.                     'transferInternalDdtActive' => $transferInternalDdtActive,
  1748.                     'actionEdit' => $session->get('action_edit'),
  1749.                     "form" => $form->createView()
  1750.                 ));
  1751.             }
  1753.             /**
  1754.              * @Route("/{warehouseId}/scheda/trasferimento/{transferId}/crea-ddt", name="user_warehouse_transfer_create_ddt")
  1755.              * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  1756.              */
  1757.             public function userWarehouseTransferCreateDdt($warehouseId, $transferId, Request $request, ValidatorInterface $validator, FormFactoryInterface $formFactory)
  1758.             {
  1759.                 $em = $this->mr->getManager('slave');
  1760.                 $emMaster = $this->mr->getManager('master');
  1761.                 $session = $request->getSession();
  1762.                 $company = $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get("companyId"));
  1763.                 $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($transferId);
  1764.                 $useCounterForTechnicians = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'use_ddt_number_for_technicians'))->getValue();
  1765.                 $ddtHeaders = $em->getRepository('App\Entity\Slave\DdtHeader')->findAll();
  1766.                 $products = $em->getRepository('App\Entity\Slave\Product')->findByTransferOrderedByModel($transfer->getId());
  1768.                 [$arrayRows, $total] = $this->createDdtProductsArray($products);
  1769.                 [$senderSupplierSlave, $senderTechnician, $senderWarehouseHeadquarter] = $this->searchDDTSender($em, $transfer);
  1770.                 [$destinationExternal, $destinationTechnician, $destinationWarehouseHeadquarter] = $this->searchDDTDestination($em, $transfer);
  1771.                 
  1772.                 $senderSupplier = null;
  1773.                 if($senderSupplierSlave != null)
  1774.                     $senderSupplier = $emMaster->getRepository('App\Entity\Master\Supplier')->findOneById($senderSupplierSlave->getIdSupplier());
  1776.                 $ddtPrint = new DdtPrint();
  1777.                 $form = $formFactory->createNamed("form_ddt_print", DdtPrintType::class, $ddtPrint);
  1778.                 $form->handleRequest($request);
  1779.                 
  1780.                 if($form->isSubmitted()){
  1782.                     $valid = true;
  1783.                     if($valid && $this->getUser()->getAccountTypology() != 'technician') $valid = ValidationService::validateNotBlank($validator, $form->get('ddtHeader'));
  1784.                     if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('port'));
  1785.                     if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('ddtCausal'));
  1786.                     if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('appearance'));
  1787.                     if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('numberGoods'));
  1788.                     if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('weight'));
  1789.                     if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('transport'));
  1790.                     if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('courier'));
  1791.                     if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('total'));
  1793.                     if($valid && $form->isValid()){
  1794.                     
  1795.                         if(!$useCounterForTechnicians && $transfer->getUserFrom() != null && $transfer->getUserFrom()->getAccountTypology() == "technician")
  1796.                             $transfer->setDdt($form->get('ddtTechnicianNumber')->getData());
  1797.                         $transfer->setDdtHeader($form->get('ddtHeader')->getData());
  1798.                         $em->flush();
  1799.                         
  1800.                         $session->set('port', $form->get('port')->getData());
  1801.                         $session->set('ddtCausal', $form->get('ddtCausal')->getData()->getId());
  1802.                         $session->set('appearance', $form->get('appearance')->getData());
  1803.                         $session->set('numberGoods', $form->get('numberGoods')->getData());
  1804.                         $session->set('weight', $form->get('weight')->getData());
  1805.                         $session->set('transport', $form->get('transport')->getData());
  1806.                         $session->set('courier', $form->get('courier')->getData());
  1807.                         $session->set('courierId', $form->get('courier')->getData()->getId());
  1808.                         $session->set('total', $form->get('total')->getData());
  1809.                         $session->set('notes', $form->get('notes')->getData());
  1810.                         return $this->redirectToRoute('user_warehouse_transfer_send_ddt', array('warehouseId' => $warehouseId, 'transferId' => $transfer->getId()));
  1811.                     }
  1812.                 }
  1814.                 return $this->render('role/user/warehouse/transfer/ddt.html.twig', array(
  1815.                     'company' => $company,
  1816.                     'transfer' => $transfer,
  1817.                     'senderSupplier' => $senderSupplier,
  1818.                     'senderTechnician' => $senderTechnician,
  1819.                     'senderWarehouseHeadquarter' => $senderWarehouseHeadquarter,
  1820.                     'destinationExternal' => $destinationExternal,
  1821.                     'destinationTechnician' => $destinationTechnician,
  1822.                     'destinationWarehouseHeadquarter' => $destinationWarehouseHeadquarter,
  1823.                     'useCounterForTechnicians' => $useCounterForTechnicians,
  1824.                     'arrayRows' => $arrayRows,
  1825.                     'total' => $total,
  1826.                     'ddtHeaders' => $ddtHeaders,
  1827.                     "form" => $form->createView()
  1828.                 ));
  1829.             }
  1831.             /**
  1832.              * @Route("/{warehouseId}/scheda/trasferimento/{transferId}/invia-ddt", name="user_warehouse_transfer_send_ddt")
  1833.              * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  1834.              */
  1835.             public function userWarehouseTransferSendDdt($warehouseId, $transferId, Request $request, ValidatorInterface $validator, FormFactoryInterface $formFactory, FileSystem $fs)
  1836.             {
  1837.                 $em = $this->mr->getManager('slave');
  1838.                 $emMaster = $this->mr->getManager('master');
  1839.                 $session = $request->getSession();
  1840.                 $company = $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get("companyId"));
  1841.                 $useCounterForTechnicians = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'use_ddt_number_for_technicians'))->getValue();
  1842.                 $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($transferId);
  1843.                 $oldDDt = $transfer->getDdtPath();
  1844.                 $ddtCausal = $em->getRepository('App\Entity\Slave\DdtCausal')->findOneById($session->get('ddtCausal'));
  1845.                 $ddtHeader = $transfer->getDdtHeader();
  1846.                 $products = $em->getRepository('App\Entity\Slave\Product')->findByTransferOrderedByModel($transfer->getId());
  1847.                 $uploadDir = $this->params->get('kernel.project_dir').'/'.$this->params->get('web_path').'/companies/'.$company->getDirectoryPath().'/ddt/';
  1849.                 [$arrayRows, $total] = $this->createDdtProductsArray($products);
  1850.                 [$senderSupplierSlave, $senderTechnician, $senderWarehouseHeadquarter] = $this->searchDDTSender($em, $transfer);
  1851.                 [$destinationExternal, $destinationTechnician, $destinationWarehouseHeadquarter] = $this->searchDDTDestination($em, $transfer);
  1853.                 $senderSupplier = null;
  1854.                 if($senderSupplierSlave != null)
  1855.                     $senderSupplier = $emMaster->getRepository('App\Entity\Master\Supplier')->findOneById($senderSupplierSlave->getIdSupplier());
  1857.                 $html2pdf = new Html2Pdf('P', 'A4', 'it', true, 'UTF-8', array(5, 5, 5, 5), false);
  1858.                 $html2pdf->writeHTML($this->renderView('role/user/print/ddt.html.twig', array(
  1859.                     'company' => $company,
  1860.                     'transfer' => $transfer,
  1861.                     'senderSupplier' => $senderSupplier,
  1862.                     'senderTechnician' => $senderTechnician,
  1863.                     'senderWarehouseHeadquarter' => $senderWarehouseHeadquarter,
  1864.                     'destinationExternal' => $destinationExternal,
  1865.                     'destinationTechnician' => $destinationTechnician,
  1866.                     'destinationWarehouseHeadquarter' => $destinationWarehouseHeadquarter,
  1867.                     'useCounterForTechnicians' => $useCounterForTechnicians,
  1868.                     'arrayRows' => $arrayRows,
  1869.                     'total' => $session->get('total'),
  1870.                     'port' => $session->get('port'),
  1871.                     'ddtCausal' => $ddtCausal,
  1872.                     'appearance' => $session->get('appearance'),
  1873.                     'numberGoods' => $session->get('numberGoods'),
  1874.                     'weight' => $session->get('weight'),
  1875.                     'transport' => $session->get('transport'),
  1876.                     'courier' => $session->get('courier'),
  1877.                     'notes' => $session->get('notes')
  1878.                 )));
  1879.                 ob_end_clean();
  1880.                 
  1881.                 $fileName = md5(uniqid()).'.pdf';
  1882.                 $html2pdf->Output($uploadDir.$fileName, 'F');
  1883.                 $transfer->setDdtPath($fileName);
  1884.                 $transfer->setPhase('waiting_receiver');
  1885.                 $transfer->setPhaseDdt('prepared');
  1886.                 
  1887.                 if($useCounterForTechnicians || ($transfer->getUserFrom() == null || $transfer->getUserFrom()->getAccountTypology() != "technician")){
  1888.                     if($transfer->getType() == "destination" && !$ddtHeader->isUseOneCounter()){
  1889.                         if($transfer->getDdt() == null){
  1890.                             $transfer->setDdt($ddtHeader->getExternalNumber());
  1891.                             $ddtHeader->setExternalNumber(intval($ddtHeader->getExternalNumber() + 1));
  1892.                         }
  1893.                     }
  1894.                     else{
  1895.                         if($transfer->getDdt() == null){
  1896.                             $transfer->setDdt($ddtHeader->getInternalNumber());
  1897.                             $ddtHeader->setInternalNumber(intval($ddtHeader->getInternalNumber() + 1));
  1898.                         }
  1899.                     }
  1900.                 }
  1902.                 $em->flush();
  1903.                 MediaService::removeDocument($fs, $oldDDt, $uploadDir);
  1904.                 $this->addFlash('notice_success', 'Trasferimento completato!');
  1905.                 return $this->redirectToRoute('user_warehouse_transfer_sheet', array('warehouseId' => $warehouseId, 'transferId' => $transfer->getId()));
  1906.             }
  1907.             
  1908.             /**
  1909.              * @Route("/{warehouseId}/scheda/trasferimento/invia-cerca", name="user_warehouse_transfer_send_search")
  1910.              * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  1911.              */
  1912.             public function userWarehouseTransferSendSearch($warehouseId, Request $request)
  1913.             {
  1914.                 $em = $this->mr->getManager('slave');
  1915.                 $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($request->request->get('transferId'));
  1916.                 $productCode = $request->request->get('productCode');
  1917.                 $codeType = $request->request->get('codeType');
  1918.                 $product = null;
  1919.                 $error = 'Il prodotto con il codice "'.$productCode.'" non è stato trovato!';
  1921.                 $found = false;
  1922.                 foreach($transfer->getWarehouseFrom()->getProducts() as $pr){
  1923.                     // CERCO TRA I PRODOTTI DEL MAGAZZINO DI PARTENZA
  1924.                     if($codeType == 'producer' && $productCode != null){
  1925.                         if(strtolower($pr->getCodeProducer()) == strtolower($productCode)){
  1926.                             $error = $pr->canBeTransferredStatus($transfer);
  1927.                             $found = true;
  1928.                             if($error == "ok")
  1929.                                 $product = $pr;
  1930.                             break;
  1931.                         }
  1932.                     }
  1933.                     elseif($codeType == 'supplier' && $pr->getCodeSupplier() != null){
  1934.                         if(strtolower($pr->getCodeSupplier()) == strtolower($productCode)){
  1935.                             $error = $pr->canBeTransferredStatus($transfer);
  1936.                             $found = true;
  1937.                             if($error == "ok")
  1938.                                 $product = $pr;
  1939.                             break;
  1940.                         }
  1941.                     }
  1942.                 }
  1944.                 if($found){
  1945.                     if($error == "ok"){
  1946.                         $json = '{
  1947.                             "id":"'.$product->getId().'", 
  1948.                             "model":"'.$product->getModel()->getName().'",
  1949.                             "producer":"'.$product->getModel()->getProducer()->getName().'",
  1950.                             "condition":"'.$product->displayCondition('string-short').'",
  1951.                             "suppliers":"'.$product->displayStringSuppliers().'",
  1952.                             "codeProducer":"'.$product->getCodeProducer().'", 
  1953.                             "codeSupplier":"'.$product->getCodeSupplier().'"
  1954.                         }';
  1955.                         return new Response(json_encode(array("code" => 200, "success" => true, "found" => $found, "error" => $error, 'product' => $json)));
  1956.                     }
  1957.                 }
  1958.                 else{
  1959.                     if($productCode != null){
  1960.                         switch($codeType){
  1961.                             case 'producer': $product = $em->getRepository("App\Entity\Slave\Product")->findOneBy(['codeProducer' => $productCode]); break;
  1962.                             case 'supplier': $product = $em->getRepository("App\Entity\Slave\Product")->findOneBy(['codeSupplier' => $productCode]); break;
  1963.                             default: break;
  1964.                         }
  1965.                     }
  1966.                     if($product != null)
  1967.                         $error = 'Il prodotto non è in questo magazzino! Si trova nel "'.$product->getActualWarehouse()->getNickname().'"';
  1968.                 }
  1970.                 return new Response(json_encode(array("code" => 200, "success" => true, "found" => $found, "error" => $error, 'product' => null)));
  1971.             }
  1972.             
  1973.             /**
  1974.              * @Route("/{warehouseId}/scheda/trasferimento/invia-preselezionati", name="user_warehouse_transfer_send_preselected")
  1975.              * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  1976.              */
  1977.             public function userWarehouseTransferSendPreselected($warehouseId, Request $request)
  1978.             {
  1979.                 $em = $this->mr->getManager('slave');
  1980.                 $product = $em->getRepository('App\Entity\Slave\Product')->findOneById($request->request->get('productId'));
  1981.                 $json = '{
  1982.                     "id":"'.$product->getId().'", 
  1983.                     "model":'.json_encode($product->getModel()->getName()).',
  1984.                     "producer":'.json_encode($product->getModel()->getProducer()->getName()).', 
  1985.                     "condition":"'.$product->displayCondition('string-short').'",
  1986.                     "suppliers":"'.$product->displayStringSuppliers().'",
  1987.                     "codeProducer":"'.$product->getCodeProducer().'", 
  1988.                     "codeSupplier":"'.$product->getCodeSupplier().'"
  1989.                 }';
  1990.                 return new Response(json_encode(array("code" => 200, "success" => true, 'product' => $json)));
  1991.             }
  1992.             
  1993.             /**
  1994.              * @Route("/{warehouseId}/scheda/trasferimento/invia-sposta-prodotto", name="user_warehouse_transfer_send_move_product")
  1995.              * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  1996.              */
  1997.             public function userWarehouseTransferSendMoveProduct($warehouseId, Request $request)
  1998.             {
  1999.                 $em = $this->mr->getManager('slave');
  2000.                 $session = $request->getSession();
  2001.                 $product = $em->getRepository('App\Entity\Slave\Product')->findOneById($request->request->get('productId'));
  2002.                 $warehouse = $em->getRepository("App\Entity\Slave\Warehouse")->findOneById($warehouseId);
  2004.                 ProductService::createProductTransferLog($em, $product, null, $this->getUser(), $warehouse, new \Datetime(), 'manual');                
  2005.                 $product->setActualWarehouse($warehouse);
  2006.                 $product->setDateLastTransfer(new \Datetime);
  2007.                 $em->flush();
  2009.                 return new Response(json_encode(array("code" => 200, "success" => true)));
  2010.             }
  2011.             
  2012.             /**
  2013.              * @Route("/{warehouseId}/scheda/trasferimento/invia-elimina-prodotto-trasferimento", name="user_warehouse_transfer_send_delete_product")
  2014.              * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  2015.              */
  2016.             public function userWarehouseTransferSendDeleteProduct($warehouseId, Request $request)
  2017.             {
  2018.                 $em = $this->mr->getManager('slave');
  2019.                 $transferInternalDdtActive = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'use_ddt'))->getValue();
  2020.                 $jtppt = $em->getRepository('App\Entity\Slave\JoinTableProductProductTransfer')->findOneById($request->request->get('jtpptId'));
  2021.                 $transferId = $jtppt->getTransfer()->getId();
  2023.                 $product = $jtppt->getProduct();
  2024.                 $status = ProductService::getStatusByCondition($em, $product->getCondition());
  2026.                 ProductService::createProductLog($em, $product, $this->getUser(), null, 'status', $product->getStatus()->getValue(), $status->getValue());
  2027.                 $product->setStatus($status);
  2028.                 $em->remove($jtppt);
  2029.                 $em->flush();
  2031.                 // RESETTO LO FASE TRANSFER A CREA DDT --- SE PRESENTE
  2032.                 $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($transferId);
  2033.                 if($transferInternalDdtActive || $transfer->getType() == 'destination'){
  2034.                     $transfer->setPhase('inserted_editable');
  2035.                     $transfer->setPhaseDdt('create');
  2036.                 }
  2037.                 else{
  2038.                     if(sizeof($transfer->getProducts()) > 0){
  2039.                         $transfer->setPhase('waiting_receiver');
  2040.                     }
  2041.                     else
  2042.                         $transfer->setPhase('inserted');
  2043.                 }
  2045.                 $em->flush();
  2046.                 return new Response(json_encode(array("code" => 200, "success" => true)));
  2047.             }
  2048.             
  2049.             /**
  2050.              * @Route("/{warehouseId}/scheda/trasferimento/invia-a-destinazione", name="user_warehouse_transfer_send_destination")
  2051.              * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  2052.              */
  2053.             public function userWarehouseTransferSendDestination($warehouseId, Request $request)
  2054.             {
  2055.                 $em = $this->mr->getManager('slave');
  2056.                 $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($request->request->get('transferId'));
  2057.                 $transfer->setPhase('to_download');
  2058.                 $transfer->setDatetimeSend(new \Datetime());
  2059.                 $em->flush();
  2060.                 $this->addFlash('notice_success', 'Trasferimento inviato correttamente!');
  2061.                 return $this->redirectToRoute('user_warehouse_transfer_sheet', array('warehouseId' => $warehouseId, 'transferId' => $transfer->getId()));
  2062.             }
  2063.             
  2064.             /**
  2065.              * @Route("/{warehouseId}/scheda/trasferimento/{transferId}/torna-a-modifica-dati", name="user_warehouse_transfer_back_edit_data")
  2066.              * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  2067.              */
  2068.             public function userWarehouseTransferBackEditData($warehouseId, $transferId, Request $request, FileSystem $fs)
  2069.             {
  2070.                 $em = $this->mr->getManager('slave');
  2071.                 $emMaster = $this->mr->getManager('master');
  2072.                 $session = $request->getSession();
  2073.                 $company = $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get("companyId"));
  2074.                 $uploadDir = $this->params->get('kernel.project_dir').'/'.$this->params->get('web_path').'/companies/'.$company->getDirectoryPath().'/ddt/';
  2075.                 $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($transferId);
  2076.                 $oldDDt = $transfer->getDDtPath();
  2078.                 $transfer->setPhase('inserted_editable');
  2079.                 $transfer->setPhaseDdt('create');
  2080.                 $transfer->setDdtPath(null);
  2081.                 MediaService::removeDocument($fs, $oldDDt, $uploadDir);
  2082.                 $em->flush();
  2083.                 $this->addFlash('notice_success', 'Trasferimento riportato alla fase precedente!');
  2084.                 return $this->redirectToRoute('user_warehouse_transfer_sheet', array('warehouseId' => $warehouseId, 'transferId' => $transfer->getId()));
  2085.             }
  2086.         //
  2087.     //
  2089.     // RICHIESTE TECNICI
  2090.         /**
  2091.          * @Route("/{warehouseId}/scheda/tecnico-richiedi-scorte/nuova", name="user_warehouse_product_request_new")
  2092.          * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  2093.          */
  2094.         public function userWarehouseProductRequestNew($warehouseId, Request $request, ValidatorInterface $validator, FormFactoryInterface $formFactory)
  2095.         {    
  2096.             $em = $this->mr->getManager('slave');
  2097.             $session = $request->getSession();
  2098.             $warehouse = $em->getRepository('App\Entity\Slave\Warehouse')->findOneById($warehouseId);
  2099.             $technician = $this->getUser();
  2100.             $headquarterWarehouses = $em->getRepository('App\Entity\Slave\Warehouse')->findBy(array('headquarter' => true));
  2101.             
  2102.             $productRequest = new ProductRequest();
  2103.             $form = $formFactory->createNamed("form_product_request", ProductRequestType::class, $productRequest);
  2104.             $form->handleRequest($request);
  2105.             
  2106.             if($form->isSubmitted()){
  2108.                 $valid = true;
  2109.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('warehouseHeadquarter'));
  2110.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('supplier'));
  2111.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('model'));
  2112.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('qty'));
  2114.                 if($valid && $form->isValid()){
  2116.                     $model = $em->getRepository('App\Entity\Slave\ProductModel')->findOneById($form->get('model')->getData());
  2117.                     $supplier = $em->getRepository('App\Entity\Slave\Supplier')->findOneById($form->get('supplier')->getData());
  2118.                     $qty = $form->get('qty')->getData();
  2120.                     $json = '{
  2121.                         "categoryId":"'.$model->getSubcategory()->getCategory()->getId().'",
  2122.                         "categoryName":"'.$model->getSubcategory()->getCategory()->getName().'",
  2123.                         "subcategoryId":"'.$model->getSubcategory()->getId().'",
  2124.                         "subcategoryName":"'.$model->getSubcategory()->getName().'",
  2125.                         "producerId":"'.$model->getProducer()->getId().'",
  2126.                         "producerName":"'.$model->getProducer()->getName().'",
  2127.                         "supplierName":"'.$supplier->getName().'",
  2128.                         "modelId":"'.$model->getId().'",
  2129.                         "modelName":"'.$model->getName().'",
  2130.                         "qty":"'.$qty.'"
  2131.                     }';
  2133.                     $productRequest->setTechnician($technician);
  2134.                     $productRequest->setWarehouse($warehouse);
  2135.                     $productRequest->setPhase('inserted');
  2136.                     $productRequest->setDatetime(new \Datetime());
  2137.                     $productRequest->setDetails($json);
  2138.                     $em->persist($productRequest);
  2139.                     $em->flush();
  2141.                     if($request->request->get('action') == 'add'){
  2142.                         $this->addFlash('notice_success', 'Richiesta aggiunta!');
  2143.                         return $this->redirectToRoute('user_warehouse_product_request_new', array('warehouseId' => $warehouse->getId()));
  2144.                     }
  2145.                     else{
  2146.                         $this->addFlash('notice_success', 'Richiesta inoltrata al magazzino centrale!');
  2147.                         return $this->redirectToRoute('user_warehouse_sheet', array('warehouseId' => $warehouse->getId()));
  2148.                     }
  2149.                 }
  2150.             }
  2151.             
  2152.             return $this->render('role/user/warehouse/product_request.html.twig', array(
  2153.                 'warehouse' => $warehouse,
  2154.                 'headquarterWarehouses' => $headquarterWarehouses,
  2155.                 "form" => $form->createView()
  2156.             ));
  2157.         }
  2159.         /**
  2160.          * @Route("/{warehouseId}/scheda/richiesta-tecnico/elimina", name="user_warehouse_product_request_delete")
  2161.          * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  2162.          */
  2163.         public function userWarehouseProductRequestDelete($warehouseId, Request $request)
  2164.         {
  2165.             $em = $this->mr->getManager('slave');
  2166.             $productRequest = $em->getRepository('App\Entity\Slave\ProductRequest')->findOneById($request->request->get('productRequestId'));
  2167.             $em->remove($productRequest);
  2168.             $em->flush();
  2169.             $this->addFlash('notice_success', 'Richiesta eliminata!');
  2170.             return $this->redirectToRoute('user_warehouse_sheet', array('warehouseId' => $warehouseId));
  2171.         }
  2172.         
  2173.         /**
  2174.          * @Route("/{warehouseId}/scheda/richiesta-tecnico/prendi-in-carico", name="user_warehouse_product_request_take_charge")
  2175.          * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  2176.          */
  2177.         public function userWarehouseProductRequestTakeCharge($warehouseId, Request $request)
  2178.         {
  2179.             $em = $this->mr->getManager('slave');
  2180.             $productRequest = $em->getRepository('App\Entity\Slave\ProductRequest')->findOneById($request->request->get('productRequestId'));
  2181.             $productRequest->setPhase('take_charge');
  2182.             $em->flush();
  2183.             $this->addFlash('notice_success', 'Richiesta presa in carico!');
  2184.             return $this->redirectToRoute('user_warehouse_sheet', array('warehouseId' => $warehouseId));
  2185.         }
  2186.         
  2187.         /**
  2188.          * @Route("/{warehouseId}/scheda/richiesta-tecnico/dichiara-gestita", name="user_warehouse_product_request_managed")
  2189.          * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  2190.          */
  2191.         public function userWarehouseProductRequestManaged($warehouseId, Request $request)
  2192.         {
  2193.             $em = $this->mr->getManager('slave');
  2194.             $productRequest = $em->getRepository('App\Entity\Slave\ProductRequest')->findOneById($request->request->get('productRequestId'));
  2195.             $productRequest->setPhase('completed');
  2196.             $em->flush();
  2197.             $this->addFlash('notice_success', 'Richiesta gestita!');
  2198.             return $this->redirectToRoute('user_warehouse_sheet', array('warehouseId' => $warehouseId));
  2199.         }
  2200.     //
  2202.     // ESPORTAZIONI
  2203.         /**
  2204.          * @Route("/{warehouseId}/scorte/esporta-csv", name="user_warehouse_stocks_export_csv")
  2205.          * @Security("is_granted('view', 'warehouse') || is_granted('warehouse_view', warehouseId)")
  2206.          */
  2207.         public function userWarehouseStocksExportCsv($warehouseId, Request $request)
  2208.         {    
  2209.             $em = $this->mr->getManager('slave');
  2210.             $session = $request->getSession();
  2211.             $warehouse = $em->getRepository("App\Entity\Slave\Warehouse")->findOneById($warehouseId);
  2212.             $products = $em->getRepository('App\Entity\Slave\Product')->findByWarehouseOrdered($warehouse->getId());
  2214.             $response = new StreamedResponse();
  2216.             $response->setCallback(function() use($products) {
  2217.                 $handle = fopen('php://output', 'w+');
  2218.                 fputcsv($handle, array('Stato','Modello','Matricola produttore','Matricola fornitore','Fornitori','Condizione','Ultimo ticket - Numero','Ultimo ticket - Termid','Ultimo ticket - Tipo intervento'), ";", '"', "\\");
  2220.                 foreach($products as $p){
  2221.             
  2222.                     $status = null;
  2223.                     $model = null;
  2224.                     $codeProducer = '';
  2225.                     $codeSupplier = '';
  2226.                     $condition = null;
  2227.                     $suppliers = '';
  2228.                     $lastTicket = '';
  2229.                     $lastTermid = '';
  2230.                     $lastOperation = '';
  2231.                     if($p->getStatus() != null) $status = $p->getStatus()->getValue();
  2232.                     if($p->getModel() != null) $model = $p->getModel()->getName().' - '.$p->getModel()->getSubcategory()->getName().' - '.$p->getModel()->getSubcategory()->getCategory()->getName();
  2233.                     if($p->getCodeProducer() != null) $codeProducer = $p->getCodeProducer();
  2234.                     if($p->getCodeSupplier() != null) $codeSupplier = $p->getCodeSupplier();
  2235.                     if(sizeof($p->getSuppliers()) > 0){
  2236.                         $suppliers = "";
  2237.                         $first = true;
  2238.                         foreach($p->getSuppliers() as $s){
  2239.                             if($first) $first = false; else $suppliers.= ', ';
  2240.                             $suppliers.= $s->getName();
  2241.                         }
  2242.                     }
  2243.                     if($p->getCondition() != null) $condition = $p->getCondition()->getValue();
  2244.                     if($p->getLastTicket() != null && $p->getStatus()->getSlug() == "not_available"){
  2245.                         $lastTicket = $p->getLastTicket()->getNumber();
  2246.                         $lastTermid = $p->getLastTicket()->getTermid()->getCode();
  2247.                         $lastOperation = $p->getLastOperationGroupType();
  2248.                     }
  2249.                     fputcsv($handle, array($status, $model, $codeProducer, $codeSupplier, $suppliers, $condition, $lastTicket, $lastTermid, $lastOperation), ";", '"', "\\");
  2250.                 }
  2252.                 fclose($handle);
  2253.             });
  2254.             
  2255.             $response->setStatusCode(200);
  2256.             $dispositionHeader = $response->headers->makeDisposition(ResponseHeaderBag::DISPOSITION_ATTACHMENT, 'Magazzino '.$warehouse->getNickname().' - Scorte.csv');
  2257.             $response->headers->set('Content-Type', 'text/csv; charset=ISO-8859-15');
  2258.             $response->headers->set('Content-Disposition', $dispositionHeader);
  2259.             return $response;
  2260.         }
  2262.         /**
  2263.          * @Route("/{warehouseId}/scorte/esporta-csv-filtrate/{status}", name="user_warehouse_stocks_export_csv_filtered")
  2264.          * @Security("is_granted('view', 'warehouse') || is_granted('warehouse_view', warehouseId)")
  2265.          */
  2266.         public function userWarehouseStocksExportCsvFiltered($warehouseId, $status, Request $request)
  2267.         {    
  2268.             $em = $this->mr->getManager('slave');
  2269.             $session = $request->getSession();
  2270.             $warehouse = $em->getRepository("App\Entity\Slave\Warehouse")->findOneById($warehouseId);
  2271.             $filters = $session->get('user_warehouse_sheet_filters');
  2273.             if($status === 'to_manage') 
  2274.                 $products = $em->getRepository("App\Entity\Slave\Product")->findByWarehouseFiltered(false, $warehouse->getId(), 'to_manage', $filters, 0);
  2275.             else 
  2276.                 $products = $em->getRepository('App\Entity\Slave\Product')->findByWarehouseFiltered(false, $warehouse->getId(), $status, $filters, 1);
  2278.             $response = new StreamedResponse();
  2279.             $response->setCallback(function() use($products) {
  2280.                 $handle = fopen('php://output', 'w+');
  2281.                 fputcsv($handle, array('Stato','Modello','Matricola produttore','Matricola fornitore','Fornitori','Condizione','Ultimo ticket - Numero','Ultimo ticket - Termid','Ultimo ticket - Tipo intervento'), ";", '"', "\\");
  2283.                 foreach($products as $p){
  2284.                     $status = null;
  2285.                     $model = null;
  2286.                     $codeProducer = '';
  2287.                     $codeSupplier = '';
  2288.                     $condition = null;
  2289.                     $suppliers = '';
  2290.                     $lastTicket = '';
  2291.                     $lastTermid = '';
  2292.                     $lastOperation = '';
  2293.                     if($p->getStatus() != null) $status = $p->getStatus()->getValue();
  2294.                     if($p->getModel() != null) $model = $p->getModel()->getName().' - '.$p->getModel()->getSubcategory()->getName().' - '.$p->getModel()->getSubcategory()->getCategory()->getName();
  2295.                     if($p->getCodeProducer() != null) $codeProducer = $p->getCodeProducer();
  2296.                     if($p->getCodeSupplier() != null) $codeSupplier = $p->getCodeSupplier();
  2297.                     if(sizeof($p->getSuppliers()) > 0){
  2298.                     $suppliers = "";
  2299.                     $first = true;
  2300.                     foreach($p->getSuppliers() as $s){
  2301.                         if($first) $first = false; else $suppliers.= ', ';
  2302.                         $suppliers.= $s->getName();
  2303.                     }
  2304.                     }
  2305.                     if($p->getCondition() != null) $condition = $p->getCondition()->getValue();
  2306.                     if($p->getLastTicket() != null && $p->getStatus()->getSlug() == "not_available"){
  2307.                     $lastTicket = $p->getLastTicket()->getNumber();
  2308.                     $lastTermid = $p->getLastTicket()->getTermid()->getCode();
  2309.                     $lastOperation = $p->getLastOperationGroupType();
  2310.                     }
  2311.                     fputcsv($handle, array($status, $model, $codeProducer, $codeSupplier, $suppliers, $condition, $lastTicket, $lastTermid, $lastOperation), ";", '"', "\\");
  2312.                 }
  2314.                 fclose($handle);
  2315.             });
  2316.             
  2317.             $response->setStatusCode(200);
  2318.             $dispositionHeader = $response->headers->makeDisposition(ResponseHeaderBag::DISPOSITION_ATTACHMENT, 'Magazzino '.$warehouse->getNickname().' - Scorte filtrate.csv');
  2319.             $response->headers->set('Content-Type', 'text/csv; charset=ISO-8859-15');
  2320.             $response->headers->set('Content-Disposition', $dispositionHeader);
  2321.             return $response;
  2322.         }
  2323.         /**
  2324.          * @Route("/{warehouseId}/scorte/esporta-csv-per-invio/{status}", name="user_warehouse_stocks_export_csv_for_send")
  2325.          * @Security("is_granted('view', 'warehouse') || is_granted('warehouse_view', warehouseId)")
  2326.          */
  2327.         public function userWarehouseStocksExportCsvForSend($warehouseId, $status, Request $request)
  2328.         {    
  2329.             $em = $this->mr->getManager('slave');
  2330.             $session = $request->getSession();
  2331.             $warehouse = $em->getRepository("App\Entity\Slave\Warehouse")->findOneById($warehouseId);
  2332.             $filters = $session->get('user_warehouse_sheet_filters');
  2333.             $products = $em->getRepository('App\Entity\Slave\Product')->findByWarehouseFiltered(false, $warehouse->getId(), $status, $filters, 1);
  2335.             $response = new StreamedResponse();
  2337.             $response->setCallback(function() use($products) {
  2338.                 $handle = fopen('php://output', 'w+');
  2339.                 fputcsv($handle, array('Matricola produttore','Matricola fornitore'), ";", '"', "\\");
  2341.                 foreach($products as $p){
  2342.             
  2343.                     $codeProducer = '';
  2344.                     $codeSupplier = '';
  2345.                     if($p->getCodeProducer() != null) $codeProducer = $p->getCodeProducer();
  2346.                     if($p->getCodeSupplier() != null) $codeSupplier = $p->getCodeSupplier();
  2347.         
  2348.                     fputcsv($handle, array($codeProducer, $codeSupplier), ";", '"', "\\");
  2349.                 }
  2351.                 fclose($handle);
  2352.             });
  2353.             
  2354.             $response->setStatusCode(200);
  2355.             $dispositionHeader = $response->headers->makeDisposition(ResponseHeaderBag::DISPOSITION_ATTACHMENT, 'Magazzino '.$warehouse->getNickname().' - Scorte per invio.csv');
  2356.             $response->headers->set('Content-Type', 'text/csv; charset=ISO-8859-15');
  2357.             $response->headers->set('Content-Disposition', $dispositionHeader);
  2358.             return $response;
  2359.         }
  2360.         
  2361.         /**
  2362.          * @Route("/{warehouseId}/scheda/trasferimento/{transferId}/scheda/esporta-csv", name="user_warehouse_transfer_sheet_export")
  2363.          * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  2364.          */
  2365.         public function userWarehouseTransferSheetExport($warehouseId, $transferId, Request $request)
  2366.         {    
  2367.             $em = $this->mr->getManager('slave');
  2368.             $emMaster = $this->mr->getManager('master');
  2369.             $session = $request->getSession();
  2370.             $warehouse = $em->getRepository("App\Entity\Slave\Warehouse")->findOneById($warehouseId);
  2371.             $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($transferId);
  2372.             $jtppts = $transfer->getProducts();
  2374.             $response = new StreamedResponse();
  2375.             $response->setCallback(function() use($jtppts) {
  2376.                 $handle = fopen('php://output', 'w+');
  2377.                 fputcsv($handle, array("Fornitori", "Modello", "Matricola produttore",'Matricola fornitore'), ";", '"', "\\");
  2378.                 foreach($jtppts as $jtppt){
  2379.                     $suppliers = $jtppt->getProduct()->displayStringSuppliers();
  2380.                     $productModel = $jtppt->getProduct()->getModel()->getName();
  2381.                     $codeProducer = '';
  2382.                     $codeSupplier = '';
  2383.                     if($jtppt->getProduct()->getCodeProducer() != null) $codeProducer = $jtppt->getProduct()->getCodeProducer();
  2384.                     if($jtppt->getProduct()->getCodeSupplier() != null) $codeSupplier = $jtppt->getProduct()->getCodeSupplier();
  2385.                     fputcsv($handle, array($suppliers, $productModel, $codeProducer, $codeSupplier), ";", '"', "\\");
  2386.                 }
  2387.                 fclose($handle);
  2388.             });
  2389.     
  2390.             $response->setStatusCode(200);
  2391.             $dispositionHeader = $response->headers->makeDisposition(ResponseHeaderBag::DISPOSITION_ATTACHMENT, 'Matricole trasferimento.csv');
  2392.             $response->headers->set('Content-Type', 'text/csv; charset=ISO-8859-15');
  2393.             $response->headers->set('Content-Disposition', $dispositionHeader);
  2394.     
  2395.             return $response;
  2396.         }
  2397.     //
  2398. }