src/Controller/User/UserWarehouseController.php line 308

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