src/Controller/User/UserWarehouseController.php line 1868

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