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(), null, 'status', $oldStatus->getValue(), $newStatus->getValue());
  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(), null, 'status', $ptr->getStatus()->getValue(), $statusNotAvailable->getValue());
  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(), null, 'status', $jtppt->getProduct()->getStatus()->getValue(), $status->getValue());
  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.             $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($request->request->get("transferId"));
  1161.             $technician = $em->getRepository('App\Entity\Slave\User')->findOneById($request->request->get("technicianId"));
  1163.             $first = true;
  1164.             $json = "[";
  1165.             if($transfer != null){
  1166.                 switch($transfer->getType()){
  1167.                     case 'technician':
  1168.                         foreach($technician->getWarehouses() as $jt){
  1169.                             if($jt->getPermission() == "RW"){
  1170.                                 if($first) $first = false; else $json.= ',';
  1171.                                 $json.= '{"id":'.$jt->getWarehouse()->getId().', "nickname":"'.$jt->getWarehouse()->getNickname().'"}';
  1172.                             }
  1173.                         }
  1174.                         break;
  1175.                     case 'destination':
  1176.                         $warehouses = $em->getRepository('App\Entity\Slave\Warehouse')->findWarehousesDestinations();
  1177.                         foreach($warehouses as $w){
  1178.                             if($first) $first = false; else $json.= ',';
  1179.                             $json.= '{"id":'.$w->getId().', "nickname":"'.$w->getNickname().'"}';
  1180.                         }
  1181.                         break;
  1182.                     default: break;
  1183.                 }
  1184.             }
  1185.             else{
  1186.                 foreach($technician->getWarehouses() as $jt){
  1187.                     if($jt->getPermission() == "RW"){
  1188.                         if($first) $first = false; else $json.= ',';
  1189.                         $json.= '{"id":'.$jt->getWarehouse()->getId().', "nickname":"'.$jt->getWarehouse()->getNickname().'"}';
  1190.                     }
  1191.                 }
  1192.             }
  1193.             $json.= "]";
  1194.         
  1195.             return new Response(json_encode(array("code" => 200, "success" => true, "warehouses" => $json))); 
  1196.         }
  1198.         /**
  1199.          * @Route("/{warehouseId}/scheda/trasferimento/{transferId}/scheda", name="user_warehouse_transfer_sheet")
  1200.          * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId) || is_granted('transfer_edit', transferId)")
  1201.          */
  1202.         public function userWarehouseTransferSheet($warehouseId, $transferId, Request $request, ValidatorInterface $validator, FormFactoryInterface $formFactory, FileSystem $fs)
  1203.         {    
  1204.             $em = $this->mr->getManager('slave');
  1205.             $emMaster = $this->mr->getManager('master');
  1206.             $session = $request->getSession();
  1207.             $transferInternalDdtActive = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'use_ddt'))->getValue();
  1208.             $warehouse = $em->getRepository('App\Entity\Slave\Warehouse')->findOneById($warehouseId);
  1209.             $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($transferId);
  1210.             $transferType = $transfer->getType();
  1211.             $company = $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get("companyId"));
  1212.             $uploadDir = $this->params->get('kernel.project_dir').'/'.$this->params->get('web_path').'/companies/'.$company->getDirectoryPath().'/ddt/';
  1213.             $session->remove('productRequestId');
  1215.             // RESETTO VARIABILI STAMPA
  1216.             $session->remove('ddtHeader');
  1217.             $session->remove('port');
  1218.             $session->remove('ddtCausal');
  1219.             $session->remove('appearance');
  1220.             $session->remove('numberGoods');
  1221.             $session->remove('weight');
  1222.             $session->remove('transport');
  1223.             $session->remove('courier');
  1224.             $session->remove('courierId');
  1225.             $session->remove('notes');
  1226.                     
  1227.             $uploadDir = $this->params->get('kernel.project_dir').'/'.$this->params->get('web_path').'/companies/'.$company->getDirectoryPath().'/ddt/';
  1228.             
  1229.             // EDIT TRANSFER DATA
  1230.             $formEdit = $formFactory->createNamed("form_transfer_edit", ProductTransferEditType::class, $transfer);
  1231.             $formEdit->handleRequest($request);
  1232.             
  1233.             if($formEdit->isSubmitted()){
  1235.                 $valid = true;
  1236.                 // Da destinazione a sede centrale
  1237.                 if($transfer->getType() == 'destination' && $transfer->getWarehouseTo()->getId() == $warehouse->getId() && $formEdit->get('ddtMandatory')->getData()){
  1238.                     if($valid) $valid = ValidationService::validateNotBlank($validator, $formEdit->get('ddt'));
  1239.                     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'));
  1240.                 }
  1242.                 if($valid && $formEdit->isValid()){
  1243.                     
  1244.                     // Da destinazione a sede centrale
  1245.                     if($transfer->getType() == 'destination'){
  1246.                         $transfer->setWarehouseTo($formEdit->get('warehouse')->getData());
  1247.                         if($transfer->getWarehouseTo()->getId() == $warehouse->getId()){
  1248.                             $transfer->setDdtMandatory($formEdit->get('ddtMandatory')->getData());
  1249.                             if($formEdit->get('ddtMandatory')->getData()){
  1250.                                 $transfer->setDdt($formEdit->get('ddt')->getData());
  1251.                                 if($formEdit->get('file')->getData() != null)
  1252.                                     MediaService::uploadDocument($formEdit->get('file')->getData(), $uploadDir, $transfer, 'signedDdt');
  1253.                             }
  1254.                         }
  1255.                     }
  1256.                     if($transfer->getType() == 'technician'){
  1257.                         $transfer->setDdtMandatory($formEdit->get('ddtMandatory')->getData());
  1258.                         if($transfer->getPhase() == 'inserted' || $transfer->getPhase() == 'inserted_editable'){
  1259.                             $transfer->setUserTo($formEdit->get('userTo')->getData());
  1260.                             $transfer->setWarehouseTo($formEdit->get('warehouse')->getData());
  1261.                         }
  1262.                     }
  1264.                     $this->addFlash('notice_success', "Dati aggiornati!");
  1265.                     $em->flush();
  1266.                     return $this->redirectToRoute('user_warehouse_transfer_sheet', array('warehouseId' => $warehouseId, 'transferId' => $transferId));
  1267.                 }
  1268.                 else{
  1269.                     $session->set('openEditModal', true);
  1270.                 }
  1271.             }            
  1273.             // UPLOAD DDT
  1274.             $formDdt = $formFactory->createNamed("form_transfer_ddt", ProductTransferDdtType::class, $transfer);
  1275.             $formDdt->handleRequest($request);
  1276.             
  1277.             if($formDdt->isSubmitted()){
  1279.                 $valid = ValidationService::validateFile($validator, $formDdt->get('ddtPath'), true, $formDdt->get('file')->getData(), '10',array('pdf', 'jpg', 'jpeg', 'png'));
  1280.                 $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($request->request->get('transferId'));
  1282.                 if($valid && $formDdt->isValid()){
  1283.                     
  1284.                     if($formDdt->get('file')->getData() != null){
  1285.                         if($formDdt->get('file')->getData()->guessExtension() == 'pdf')
  1286.                             MediaService::uploadDocument($formDdt->get('file')->getData(), $uploadDir, $transfer, 'signedDdt');
  1287.                         else
  1288.                             MediaService::uploadImage($fs, $formDdt->get('file')->getData(), null, $uploadDir, $transfer, 'signedDdt', 100, 1000, 200, false);
  1289.                     }
  1291.                     $transfer->setPhaseDdt('completed');
  1292.                    
  1293.                     $conditionHistoric = $em->getRepository('App\Entity\Slave\ProductCondition')->findOneBySlug('historic');
  1294.                     $statusNotAvailable = $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBySlug('not_available');
  1295.                     foreach($transfer->getProducts() as $jtppt){
  1296.                         $product = $jtppt->getProduct();
  1297.                         ProductService::createProductTransferLog($em, $product, $jtppt->getTransfer(), $this->getUser(), null, new \Datetime(), 'scan');
  1298.                         ProductService::moveProductTransfer($em, $jtppt, $this->getUser(), $statusNotAvailable);
  1299.                         ProductService::createProductLog($em, $product, $this->getUser(), null, 'condition', $product->getCondition()->getValue(), $conditionHistoric->getValue());
  1300.                         $product->setCondition($conditionHistoric);
  1301.                     }
  1302.                     $transfer->setPhase('completed');
  1303.                     $transfer->setDatetimeCompletion(new \Datetime());
  1304.                     $this->addFlash('notice_success', "Consegna registrata!");
  1305.                     $em->flush();
  1306.                     return $this->redirectToRoute('user_warehouse_transfer_sheet', array('warehouseId' => $warehouseId, 'transferId' => $transferId));
  1307.                 }
  1308.             }
  1309.             
  1310.             // CHANGE UPLOADED DDT
  1311.             $formChangeDdt = $formFactory->createNamed("form_transfer_change_ddt", ProductTransferDdtType::class, $transfer);
  1312.             $formChangeDdt->handleRequest($request);
  1313.             
  1314.             if($formChangeDdt->isSubmitted()){
  1316.                 $valid = ValidationService::validateFile($validator, $formChangeDdt->get('ddtPath'), true, $formChangeDdt->get('file')->getData(), '10',array('pdf', 'jpg', 'jpeg', 'png'));
  1317.                 $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($request->request->get('transferId'));
  1319.                 if($valid && $formChangeDdt->isValid()){
  1320.                     
  1321.                     if($formChangeDdt->get('file')->getData() != null){
  1322.                         MediaService::removeDocument($fs, $transfer->getSignedDdtPath(), $uploadDir);
  1323.                         if($formChangeDdt->get('file')->getData()->guessExtension() == 'pdf')
  1324.                             MediaService::uploadDocument($formChangeDdt->get('file')->getData(), $uploadDir, $transfer, 'signedDdt');
  1325.                         else
  1326.                             MediaService::uploadImage($fs, $formChangeDdt->get('file')->getData(), null, $uploadDir, $transfer, 'signedDdt', 100, 1000, 200, false);
  1327.                     }
  1328.                                         
  1329.                     $transfer->setPhaseDdt('completed');
  1330.                     $em->flush();
  1331.                     $this->addFlash('notice_success', "DDT caricato!");
  1332.                     return $this->redirectToRoute('user_warehouse_transfer_sheet', array('warehouseId' => $warehouseId, 'transferId' => $transferId));
  1333.                 }
  1334.             }
  1335.             
  1336.             return $this->render('role/user/warehouse/transfer/sheet.html.twig', array(
  1337.                 'company' => $company,
  1338.                 'warehouse' => $warehouse,
  1339.                 'transfer' => $transfer,
  1340.                 'transferType' => $transferType,
  1341.                 'transferInternalDdtActive' => $transferInternalDdtActive,
  1342.                 'formEdit' => $formEdit->createView(),
  1343.                 'formDdt' => $formDdt->createView(),
  1344.                 'formChangeDdt' => $formChangeDdt->createView()
  1345.             ));
  1346.         }
  1348.         // RICEVI
  1349.             /**
  1350.              * @Route("/{warehouseId}/scheda/trasferimento/{transferId}/ricevi", name="user_warehouse_transfer_receive")
  1351.              * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  1352.              */
  1353.             public function userWarehouseTransferReceive($warehouseId, $transferId, Request $request, ValidatorInterface $validator, FormFactoryInterface $formFactory)
  1354.             {    
  1355.                 $em = $this->mr->getManager('slave');
  1356.                 $session = $request->getSession();
  1357.                 $warehouse = $em->getRepository("App\Entity\Slave\Warehouse")->findOneById($warehouseId);
  1358.                 $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($transferId);
  1359.                 $transferType = $transfer->getType();
  1361.                 $register = new ProductRegister();
  1362.                 $form = $formFactory->createNamed("form_transfer_receive", ProductRegisterType::class, $register);
  1363.                 $form->handleRequest($request);
  1364.                 
  1365.                 if($form->isSubmitted()){
  1367.                     [$valid, $methodRegister, $errorMsg] = FormValidatorService::validateProductReceive($em, $validator, $form, $transferType);
  1369.                     if($valid && $form->isValid()){
  1370.                         
  1371.                         $arrayProducerCodes = array();
  1372.                         $arraySupplierCodes = array();
  1373.                         $countProductsUpdated = 0;
  1374.                         $countProductsNew = 0;
  1375.                         $countProductsDouble = 0;
  1376.                         $productsUpdatedMats = "";
  1377.                         $productsDoubleMats = "";
  1378.                         $status = $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'transfer'));
  1379.                         $transfer->setPhase('product_insert');
  1381.                         if($methodRegister == 'gun'){
  1382.                             // IMPORTAZIONE TRAMITE SPARO
  1383.                             foreach($form->get('products')->getData() as $prod){
  1384.                                 if(!($prod->getCodeProducer() == null && $prod->getCodeSupplier() == null)){
  1385.                                     [$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);
  1386.                                     ProductService::createJtProductTransfer($em, $product, $transfer, new \Datetime());
  1387.                                 }
  1388.                             }
  1389.                         }
  1390.                         else{
  1391.                             // IMPORTAZIONE TRAMITE FILE
  1392.                             $result = ProductService::checkProducts($form->get('file')->getData(), $form->get('separator')->getData());
  1393.                             
  1394.                             if($result['error'] != null){
  1395.                                 $this->addFlash('notice_danger', $result['msg']);
  1396.                                 return $this->redirect($request->server->get('HTTP_REFERER'));
  1397.                             }
  1398.                             else{
  1399.                                 $row = 0;
  1400.                                 if(($handle = fopen($form->get('file')->getData(), "r")) !== FALSE) {
  1401.                                     while(($data = fgetcsv($handle, 1000, $form->get('separator')->getData())) !== FALSE) {
  1402.                                         $data = array_map("utf8_encode", $data);
  1403.                                         if($row > 0){
  1404.                                             if(!($data[0] == null && $data[1] == null)){
  1405.                                                 [$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);
  1406.                                                 ProductService::createJtProductTransfer($em, $product, $transfer, new \Datetime());
  1407.                                             }
  1408.                                         }
  1409.                                         $row++;
  1410.                                     }
  1411.                                     fclose($handle);
  1412.                                 }
  1413.                             }
  1414.                         }
  1415.                         
  1416.                         $em->flush();
  1418.                         if($request->request->get('submit_action') == 'add_products')
  1419.                             return $this->redirectToRoute('user_warehouse_transfer_receive', array('warehouseId' => $warehouse->getId(), 'transferId' => $transfer->getId()));
  1420.                         else{
  1421.                             foreach($transfer->getProducts() as $jtppt){
  1422.                                 $status = $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'available'));
  1423.                                 ProductService::moveProductTransfer($em, $jtppt, $this->getUser(), $status);
  1424.                                 ProductService::createProductTransferLog($em, $jtppt->getProduct(), $transfer, $this->getUser(), null, new \Datetime(), 'scan');
  1425.                             }
  1426.                             $transfer->setPhase('completed');
  1427.                             $transfer->setDatetimeCompletion(new \Datetime());
  1428.                             $em->flush();
  1429.                             $this->addFlash('notice_success', '<br>Prodotti nuovi inseriti: '.$countProductsNew.'<br>Prodotti aggiornati: '.$countProductsUpdated.$productsUpdatedMats.'<br>Prodotti doppi ignorati: '.$countProductsDouble.$productsDoubleMats);
  1430.                             return $this->redirectToRoute('user_warehouse_transfer_sheet', array('warehouseId' => $warehouseId, 'transferId' => $transfer->getId()));
  1431.                         }
  1432.                     }
  1433.                     else{
  1434.                         $receiveSuppliersIds = [];
  1435.                         foreach($form->get('suppliers')->getData() as $sup){
  1436.                             array_push($receiveSuppliersIds, $sup->getId());
  1437.                         }
  1438.                         $session->set('receiveSuppliersIds', $receiveSuppliersIds);
  1439.                         if($errorMsg != ''){
  1440.                             $this->addFlash('notice_danger', $errorMsg);
  1441.                         }
  1442.                     }
  1443.                 }
  1444.                 
  1445.                 return $this->render('role/user/warehouse/transfer/receive.html.twig', array(
  1446.                     'transfer' => $transfer,
  1447.                     'transferType' => $transferType,
  1448.                     'warehouse' => $warehouse,
  1449.                     "form" => $form->createView()
  1450.                 ));
  1451.             }
  1453.             /**
  1454.              * @Route("/{warehouseId}/scheda/trasferimento/{transferId}/ricevi-concludi", name="user_warehouse_transfer_receive_complete")
  1455.              * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  1456.              */
  1457.             public function userWarehouseTransferReceiveComplete($warehouseId, $transferId, Request $request)
  1458.             {    
  1459.                 $em = $this->mr->getManager('slave');
  1460.                 $session = $request->getSession();
  1461.                 $warehouse = $em->getRepository("App\Entity\Slave\Warehouse")->findOneById($warehouseId);
  1462.                 $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($transferId);
  1463.                 $status = $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'available'));
  1465.                 foreach($transfer->getProducts() as $jtppt){
  1466.                     ProductService::moveProductTransfer($em, $jtppt, $this->getUser(), $status);
  1467.                     ProductService::createProductTransferLog($em, $jtppt->getProduct(), $transfer, $this->getUser(), null, new \Datetime(), 'scan');
  1468.                 }
  1469.                 $transfer->setPhase('completed');
  1470.                 $transfer->setDatetimeCompletion(new \Datetime());
  1471.                 $em->flush();
  1473.                 $this->addFlash('notice_success', 'Prodotti inseriti a magazzino');
  1475.                 return $this->redirectToRoute('user_warehouse_transfer_sheet', array('warehouseId' => $warehouseId, 'transferId' => $transfer->getId()));
  1476.             }
  1477.                         
  1478.             /**
  1479.              * @Route("/{warehouseId}/scheda/trasferimento/{transferId}/scarica-materiale", name="user_warehouse_transfer_download")
  1480.              * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  1481.              */
  1482.             public function userWarehouseTransferDownload($warehouseId, $transferId, Request $request, ValidatorInterface $validator, FormFactoryInterface $formFactory, FileSystem $fs)
  1483.             {    
  1484.                 $em = $this->mr->getManager('slave');
  1485.                 $emMaster = $this->mr->getManager('master');
  1486.                 $session = $request->getSession();
  1488.                 $transferInternalDdtActive = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'use_ddt'))->getValue();
  1489.                 $company = $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get("companyId"));
  1490.                 $uploadDir = $this->params->get('kernel.project_dir').'/'.$this->params->get('web_path').'/companies/'.$company->getDirectoryPath().'/ddt/';
  1491.                 $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($transferId);
  1493.                 // SCARICA MATERIALE
  1494.                 $form = $formFactory->createNamed("form_transfer_download", ProductTransferDownloadType::class, $transfer, array('transferId' => $transfer->getId()));
  1495.                 $form->handleRequest($request);
  1496.                 
  1497.                 if($form->isSubmitted()){
  1498.     
  1499.                     $file = $form->get('file')->getData();
  1500.                     $valid = true;
  1501.                     if($transferInternalDdtActive && $transfer->isDdtMandatory()){
  1502.                         $valid = ValidationService::validateFile($validator, $form->get('ddtPath'), true, $file, 10, array('pdf', 'jpg', 'jpeg', 'png'));
  1503.                     }
  1505.                     if($valid && $form->isValid()){
  1506.     
  1507.                         if($transferInternalDdtActive){
  1508.                             if($file != null){
  1509.                                 if($file->guessExtension() == 'pdf')
  1510.                                     MediaService::uploadDocument($file, $uploadDir, $transfer, 'signedDdt');
  1511.                                 else
  1512.                                     MediaService::uploadImage($fs, $file, null, $uploadDir, $transfer, 'signedDdt', 100, 1000, 200, false);
  1513.                                 $transfer->setPhaseDdt('completed');
  1514.                             }
  1515.                             else{
  1516.                                 $transfer->setPhaseDdt('signed_missing');
  1517.                             }
  1518.                         }
  1519.                         $transfer->setPhase('completed');
  1520.                         $transfer->setDatetimeCompletion(new \Datetime());
  1522.                         [$status, $toManage, $toManagePriority] = $this->downloadSetByType($em, $transfer);
  1523.                         
  1524.                         if($request->request->get('jtpptGunIds') != null){
  1525.                             $gunIds = explode(',', $request->request->get('jtpptGunIds'));
  1526.                             for($i = 0; $i < sizeof($gunIds); $i++){
  1527.                                 $jtppt = $em->getRepository('App\Entity\Slave\JoinTableProductProductTransfer')->findOneById($gunIds[$i]);
  1528.                                 ProductService::moveProductTransfer($em, $jtppt, $this->getUser(), $status);
  1529.                                 ProductService::createProductTransferLog($em, $jtppt->getProduct(), $transfer, $this->getUser(), null, new \Datetime(), 'scan');
  1530.                                 $jtppt->setDownloadType('scan');
  1531.                                 $jtppt->getProduct()->setToManage($toManage);
  1532.                                 $jtppt->getProduct()->setToManagePriority($toManagePriority);
  1533.                             }
  1534.                         }
  1535.                         
  1536.                         if($request->request->get('jtpptManualIds') != null){
  1537.                             $manualIds = explode(',', $request->request->get('jtpptManualIds'));
  1538.                             for($i = 0; $i < sizeof($manualIds); $i++){
  1539.                                 $jtppt = $em->getRepository('App\Entity\Slave\JoinTableProductProductTransfer')->findOneById($manualIds[$i]);
  1540.                                 ProductService::moveProductTransfer($em, $jtppt, $this->getUser(), $status);
  1541.                                 ProductService::createProductTransferLog($em, $jtppt->getProduct(), $transfer, $this->getUser(), null, new \Datetime(), 'manual');
  1542.                                 $jtppt->setDownloadType('manual');
  1543.                                 $jtppt->getProduct()->setToManage($toManage);
  1544.                                 $jtppt->getProduct()->setToManagePriority($toManagePriority);
  1545.                             }
  1546.                         }
  1547.                         $em->flush();
  1549.                         // I PRODOTTI NON SCARICATI LI RIMETTO NELLO STATO PRECEDENTE
  1550.                         foreach($transfer->getProducts() as $jtppt){
  1551.                             if(!$jtppt->isTransferOk()){
  1552.                                 $status = $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'not_available'));
  1553.                                 ProductService::createProductLog($em, $jtppt->getProduct(), $this->getUser(), null, 'status', $jtppt->getProduct()->getStatus()->getValue(), $status->getValue());
  1554.                                 ProductService::createProductTransferBackLog($em, $jtppt->getProduct(), $transfer, $this->getUser(), null, new \Datetime(), 'manual');
  1555.                                 $jtppt->getProduct()->setStatus($status);
  1556.                                 if($transfer->getWarehouseFrom()->isHeadquarter()){
  1557.                                     $jtppt->getProduct()->setToManage(true);
  1558.                                     $jtppt->getProduct()->setToManagePriority('5');
  1559.                                 }
  1560.                             }
  1561.                         }
  1562.                         
  1563.                         $em->flush();
  1564.                         
  1565.                         $this->addFlash('notice_success', 'Trasferimento scaricato correttamente!');
  1566.                         return $this->redirectToRoute('user_warehouse_transfer_sheet', array('warehouseId' => $warehouseId, 'transferId' => $transfer->getId()));
  1567.                     }
  1568.                     else{
  1569.                         $session->set('openModalTransferComplete', true);
  1570.                         $session->set('jtpptGunIds', $request->request->get('jtpptGunIds'));
  1571.                         $session->set('jtpptManualIds', $request->request->get('jtpptManualIds'));
  1572.                     }
  1573.                 }
  1575.                 return $this->render('role/user/warehouse/transfer/download.html.twig', array(
  1576.                     'company' => $company,
  1577.                     'transfer' => $transfer,
  1578.                     'transferInternalDdtActive' => $transferInternalDdtActive,
  1579.                     "form" => $form->createView()
  1580.                 ));
  1581.             }
  1583.             /**
  1584.              * @Route("/{warehouseId}/scheda/trasferimento/scarica-materiale/parziale", name="user_warehouse_transfer_download_partial")
  1585.              * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  1586.              */
  1587.             public function userWarehouseTransferDownloadPartial($warehouseId, Request $request)
  1588.             {
  1589.                 $em = $this->mr->getManager('slave');
  1590.                 $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($request->request->get('transferId'));
  1591.                 [$status, $toManage, $toManagePriority] = $this->downloadSetByType($em, $transfer);
  1593.                 if($request->request->get('jtpptGunIds') != null){
  1594.                     $gunIds = explode(',', $request->request->get('jtpptGunIds'));
  1595.                     for($i = 0; $i < sizeof($gunIds); $i++){
  1596.                         $jtppt = $em->getRepository('App\Entity\Slave\JoinTableProductProductTransfer')->findOneById($gunIds[$i]);
  1597.                         ProductService::moveProductTransfer($em, $jtppt, $this->getUser(), $status);
  1598.                         ProductService::createProductTransferLog($em, $jtppt->getProduct(), $transfer, $this->getUser(), null, new \Datetime(), 'scan');
  1599.                         $jtppt->setDownloadType('scan');
  1600.                         $jtppt->getProduct()->setToManage($toManage);
  1601.                         $jtppt->getProduct()->setToManagePriority($toManagePriority);
  1602.                     }
  1603.                 }
  1604.                 
  1605.                 if($request->request->get('jtpptManualIds') != null){
  1606.                     $manualIds = explode(',', $request->request->get('jtpptManualIds'));
  1607.                     for($i = 0; $i < sizeof($manualIds); $i++){
  1608.                         $jtppt = $em->getRepository('App\Entity\Slave\JoinTableProductProductTransfer')->findOneById($manualIds[$i]);
  1609.                         ProductService::moveProductTransfer($em, $jtppt, $this->getUser(), $status);
  1610.                         ProductService::createProductTransferLog($em, $jtppt->getProduct(), $transfer, $this->getUser(), null, new \Datetime(), 'manual');
  1611.                         $jtppt->setDownloadType('manual');
  1612.                         $jtppt->getProduct()->setToManage($toManage);
  1613.                         $jtppt->getProduct()->setToManagePriority($toManagePriority);
  1614.                     }
  1615.                 }
  1616.                 
  1617.                 $em->flush();
  1619.                 $this->addFlash('notice_success', 'Trasferimento parziale effettuato!');
  1620.                 return $this->redirectToRoute('user_warehouse_transfer_sheet', array('warehouseId' => $warehouseId, 'transferId' => $transfer->getId()));
  1621.             }
  1623.             /**
  1624.              * @Route("/{warehouseId}/scheda/trasferimento/scarica-materiale/cerca", name="user_warehouse_transfer_download_search")
  1625.              * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  1626.              */
  1627.             public function userWarehouseTransferDownloadSearch($warehouseId, Request $request)
  1628.             {
  1629.                 $em = $this->mr->getManager('slave');
  1630.                 $session = $request->getSession();
  1631.                 $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($request->request->get('transferId'));
  1632.                 $productCode = $request->request->get('productCode');
  1634.                 $jtpptId = null;
  1635.                 $found = false;
  1636.                 foreach($transfer->getProducts() as $jtppt){
  1637.                     if($productCode == $jtppt->getProduct()->getCodeProducer() || $productCode == $jtppt->getProduct()->getCodeSupplier()){
  1638.                         $jtpptId = $jtppt->getId();
  1639.                         $found = true;
  1640.                         break;
  1641.                     }
  1642.                 }
  1644.                 return new Response(json_encode(array("code" => 200, "success" => true, "found" => $found, 'jtpptId' => $jtpptId)));
  1645.             }
  1646.         //
  1648.         // INVIA
  1649.             /**
  1650.              * @Route("/{warehouseId}/scheda/trasferimento/{transferId}/invia", name="user_warehouse_transfer_send")
  1651.              * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  1652.              */
  1653.             public function userWarehouseTransferSend($warehouseId, $transferId, Request $request, ValidatorInterface $validator, FormFactoryInterface $formFactory)
  1654.             {
  1655.                 $em = $this->mr->getManager('slave');
  1656.                 $emMaster = $this->mr->getManager('master');
  1657.                 $session = $request->getSession();
  1658.                 $company = $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get("companyId"));
  1659.                 $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($transferId);
  1660.                 $warehouse = $em->getRepository("App\Entity\Slave\Warehouse")->findOneById($warehouseId);
  1661.                 $transferInternalDdtActive = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'use_ddt'))->getValue();
  1663.                 $form = $formFactory->createNamed("form_transfer_send", ProductTransferSendProductsType::class, $transfer);
  1664.                 $form->handleRequest($request);
  1665.                 
  1666.                 if($form->isSubmitted()){
  1667.                     [$valid, $methodRegister, $errorMsg, $arrayProducts] = FormValidatorService::validateProductSend($em, $validator, $form, $warehouse);
  1669.                     // Se magazzino principale e verso destinazione esterna -> Controllo se prodotti hanno il fornitore inserito
  1670.                     if($valid && $warehouse->isHeadquarter() && $transfer->getType() == 'destination'){
  1671.                         foreach($arrayProducts as $p){
  1673.                             $suppliersIds = [];
  1674.                             foreach($p->getSuppliers() as $sup){
  1675.                                 array_push($suppliersIds, $sup->getId());
  1676.                             }
  1678.                             if(!in_array($transfer->getSupplier()->getId(), $suppliersIds)){
  1679.                                 $valid = false;
  1680.                                 $errorMsg = 'Il prodotto '.$p.' non ha il fornitore inserito '.$transfer->getSupplier();
  1681.                                 $form->get('file')->addError(new FormError('Il prodotto '.$p.' non ha il fornitore inserito '.$transfer->getSupplier()));
  1682.                                 break;
  1683.                             }
  1684.                         }
  1685.                     }
  1687.                     if($valid && $form->isValid()){
  1689.                         // Se i controlli sono andati a buon fine -> inserisco le JoinTableProductTransfer per le righe non vuote
  1690.                         $status = $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'transfer'));
  1691.                         foreach($arrayProducts as $product){
  1692.                             ProductService::createProductLog($em, $product, $this->getUser(), null, 'status', $product->getStatus()->getValue(), $status->getValue());
  1693.                             $product->setStatus($status);
  1694.                             ProductService::createJtProductTransfer($em, $product, $transfer, new \Datetime());
  1695.                         }
  1696.                         
  1697.                         if($transferInternalDdtActive || $transfer->getType() == 'destination'){
  1698.                             $transfer->setPhase('inserted_editable');
  1699.                             $transfer->setPhaseDdt('create');
  1700.                         }
  1701.                         else{
  1702.                             $transfer->setPhase('waiting_receiver');
  1703.                         }
  1704.                         $em->flush();
  1705.                         
  1706.                         $session->remove('transferStocksIds');
  1708.                         if($request->request->get('submit_action') == 'ddt')
  1709.                             return $this->redirectToRoute('user_warehouse_transfer_create_ddt', array('warehouseId' => $warehouseId, 'transferId' => $transfer->getId()));
  1710.                         else
  1711.                             return $this->redirectToRoute('user_warehouse_transfer_sheet', array('warehouseId' => $warehouse->getId(), 'transferId' => $transfer->getId()));
  1712.                     }
  1713.                     else{
  1714.                         $this->addFlash('notice_danger', $errorMsg);       
  1715.                         return $this->redirect($request->server->get('HTTP_REFERER'));
  1716.                     }
  1717.                 }
  1718.                 
  1719.                 return $this->render('role/user/warehouse/transfer/send.html.twig', array(
  1720.                     'company' => $company,
  1721.                     'transfer' => $transfer,
  1722.                     'warehouse' => $warehouse,
  1723.                     'transferInternalDdtActive' => $transferInternalDdtActive,
  1724.                     'actionEdit' => $session->get('action_edit'),
  1725.                     "form" => $form->createView()
  1726.                 ));
  1727.             }
  1729.             /**
  1730.              * @Route("/{warehouseId}/scheda/trasferimento/{transferId}/crea-ddt", name="user_warehouse_transfer_create_ddt")
  1731.              * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  1732.              */
  1733.             public function userWarehouseTransferCreateDdt($warehouseId, $transferId, Request $request, ValidatorInterface $validator, FormFactoryInterface $formFactory)
  1734.             {
  1735.                 $em = $this->mr->getManager('slave');
  1736.                 $emMaster = $this->mr->getManager('master');
  1737.                 $session = $request->getSession();
  1738.                 $company = $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get("companyId"));
  1739.                 $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($transferId);
  1740.                 $useCounterForTechnicians = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'use_ddt_number_for_technicians'))->getValue();
  1741.                 $ddtHeaders = $em->getRepository('App\Entity\Slave\DdtHeader')->findAll();
  1742.                 $products = $em->getRepository('App\Entity\Slave\Product')->findByTransferOrderedByModel($transfer->getId());
  1744.                 [$arrayRows, $total] = $this->createDdtProductsArray($products);
  1745.                 [$senderSupplierSlave, $senderTechnician, $senderWarehouseHeadquarter] = $this->searchDDTSender($em, $transfer);
  1746.                 [$destinationExternal, $destinationTechnician, $destinationWarehouseHeadquarter] = $this->searchDDTDestination($em, $transfer);
  1747.                 
  1748.                 $senderSupplier = null;
  1749.                 if($senderSupplierSlave != null)
  1750.                     $senderSupplier = $emMaster->getRepository('App\Entity\Master\Supplier')->findOneById($senderSupplierSlave->getIdSupplier());
  1752.                 $ddtPrint = new DdtPrint();
  1753.                 $form = $formFactory->createNamed("form_ddt_print", DdtPrintType::class, $ddtPrint);
  1754.                 $form->handleRequest($request);
  1755.                 
  1756.                 if($form->isSubmitted()){
  1758.                     $valid = true;
  1759.                     if($valid && $this->getUser()->getAccountTypology() != 'technician') $valid = ValidationService::validateNotBlank($validator, $form->get('ddtHeader'));
  1760.                     if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('port'));
  1761.                     if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('ddtCausal'));
  1762.                     if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('appearance'));
  1763.                     if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('numberGoods'));
  1764.                     if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('weight'));
  1765.                     if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('transport'));
  1766.                     if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('courier'));
  1767.                     if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('total'));
  1769.                     if($valid && $form->isValid()){
  1770.                     
  1771.                         if(!$useCounterForTechnicians && $transfer->getUserFrom() != null && $transfer->getUserFrom()->getAccountTypology() == "technician")
  1772.                             $transfer->setDdt($form->get('ddtTechnicianNumber')->getData());
  1773.                         $transfer->setDdtHeader($form->get('ddtHeader')->getData());
  1774.                         $em->flush();
  1775.                         
  1776.                         $session->set('port', $form->get('port')->getData());
  1777.                         $session->set('ddtCausal', $form->get('ddtCausal')->getData()->getId());
  1778.                         $session->set('appearance', $form->get('appearance')->getData());
  1779.                         $session->set('numberGoods', $form->get('numberGoods')->getData());
  1780.                         $session->set('weight', $form->get('weight')->getData());
  1781.                         $session->set('transport', $form->get('transport')->getData());
  1782.                         $session->set('courier', $form->get('courier')->getData());
  1783.                         $session->set('courierId', $form->get('courier')->getData()->getId());
  1784.                         $session->set('total', $form->get('total')->getData());
  1785.                         $session->set('notes', $form->get('notes')->getData());
  1786.                         return $this->redirectToRoute('user_warehouse_transfer_send_ddt', array('warehouseId' => $warehouseId, 'transferId' => $transfer->getId()));
  1787.                     }
  1788.                 }
  1790.                 return $this->render('role/user/warehouse/transfer/ddt.html.twig', array(
  1791.                     'company' => $company,
  1792.                     'transfer' => $transfer,
  1793.                     'senderSupplier' => $senderSupplier,
  1794.                     'senderTechnician' => $senderTechnician,
  1795.                     'senderWarehouseHeadquarter' => $senderWarehouseHeadquarter,
  1796.                     'destinationExternal' => $destinationExternal,
  1797.                     'destinationTechnician' => $destinationTechnician,
  1798.                     'destinationWarehouseHeadquarter' => $destinationWarehouseHeadquarter,
  1799.                     'useCounterForTechnicians' => $useCounterForTechnicians,
  1800.                     'arrayRows' => $arrayRows,
  1801.                     'total' => $total,
  1802.                     'ddtHeaders' => $ddtHeaders,
  1803.                     "form" => $form->createView()
  1804.                 ));
  1805.             }
  1807.             /**
  1808.              * @Route("/{warehouseId}/scheda/trasferimento/{transferId}/invia-ddt", name="user_warehouse_transfer_send_ddt")
  1809.              * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  1810.              */
  1811.             public function userWarehouseTransferSendDdt($warehouseId, $transferId, Request $request, ValidatorInterface $validator, FormFactoryInterface $formFactory, FileSystem $fs)
  1812.             {
  1813.                 $em = $this->mr->getManager('slave');
  1814.                 $emMaster = $this->mr->getManager('master');
  1815.                 $session = $request->getSession();
  1816.                 $company = $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get("companyId"));
  1817.                 $useCounterForTechnicians = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'use_ddt_number_for_technicians'))->getValue();
  1818.                 $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($transferId);
  1819.                 $oldDDt = $transfer->getDdtPath();
  1820.                 $ddtCausal = $em->getRepository('App\Entity\Slave\DdtCausal')->findOneById($session->get('ddtCausal'));
  1821.                 $ddtHeader = $transfer->getDdtHeader();
  1822.                 $products = $em->getRepository('App\Entity\Slave\Product')->findByTransferOrderedByModel($transfer->getId());
  1823.                 $uploadDir = $this->params->get('kernel.project_dir').'/'.$this->params->get('web_path').'/companies/'.$company->getDirectoryPath().'/ddt/';
  1825.                 [$arrayRows, $total] = $this->createDdtProductsArray($products);
  1826.                 [$senderSupplierSlave, $senderTechnician, $senderWarehouseHeadquarter] = $this->searchDDTSender($em, $transfer);
  1827.                 [$destinationExternal, $destinationTechnician, $destinationWarehouseHeadquarter] = $this->searchDDTDestination($em, $transfer);
  1829.                 $senderSupplier = null;
  1830.                 if($senderSupplierSlave != null)
  1831.                     $senderSupplier = $emMaster->getRepository('App\Entity\Master\Supplier')->findOneById($senderSupplierSlave->getIdSupplier());
  1833.                 $html2pdf = new Html2Pdf('P', 'A4', 'it', true, 'UTF-8', array(5, 5, 5, 5), false);
  1834.                 $html2pdf->writeHTML($this->renderView('role/user/print/ddt.html.twig', array(
  1835.                     'company' => $company,
  1836.                     'transfer' => $transfer,
  1837.                     'senderSupplier' => $senderSupplier,
  1838.                     'senderTechnician' => $senderTechnician,
  1839.                     'senderWarehouseHeadquarter' => $senderWarehouseHeadquarter,
  1840.                     'destinationExternal' => $destinationExternal,
  1841.                     'destinationTechnician' => $destinationTechnician,
  1842.                     'destinationWarehouseHeadquarter' => $destinationWarehouseHeadquarter,
  1843.                     'useCounterForTechnicians' => $useCounterForTechnicians,
  1844.                     'arrayRows' => $arrayRows,
  1845.                     'total' => $session->get('total'),
  1846.                     'port' => $session->get('port'),
  1847.                     'ddtCausal' => $ddtCausal,
  1848.                     'appearance' => $session->get('appearance'),
  1849.                     'numberGoods' => $session->get('numberGoods'),
  1850.                     'weight' => $session->get('weight'),
  1851.                     'transport' => $session->get('transport'),
  1852.                     'courier' => $session->get('courier'),
  1853.                     'notes' => $session->get('notes')
  1854.                 )));
  1855.                 ob_end_clean();
  1856.                 
  1857.                 $fileName = md5(uniqid()).'.pdf';
  1858.                 $html2pdf->Output($uploadDir.$fileName, 'F');
  1859.                 $transfer->setDdtPath($fileName);
  1860.                 $transfer->setPhase('waiting_receiver');
  1861.                 $transfer->setPhaseDdt('prepared');
  1862.                 
  1863.                 if($useCounterForTechnicians || ($transfer->getUserFrom() == null || $transfer->getUserFrom()->getAccountTypology() != "technician")){
  1864.                     if($transfer->getType() == "destination" && !$ddtHeader->isUseOneCounter()){
  1865.                         if($transfer->getDdt() == null){
  1866.                             $transfer->setDdt($ddtHeader->getExternalNumber());
  1867.                             $ddtHeader->setExternalNumber(intval($ddtHeader->getExternalNumber() + 1));
  1868.                         }
  1869.                     }
  1870.                     else{
  1871.                         if($transfer->getDdt() == null){
  1872.                             $transfer->setDdt($ddtHeader->getInternalNumber());
  1873.                             $ddtHeader->setInternalNumber(intval($ddtHeader->getInternalNumber() + 1));
  1874.                         }
  1875.                     }
  1876.                 }
  1878.                 $em->flush();
  1879.                 MediaService::removeDocument($fs, $oldDDt, $uploadDir);
  1880.                 $this->addFlash('notice_success', 'Trasferimento completato!');
  1881.                 return $this->redirectToRoute('user_warehouse_transfer_sheet', array('warehouseId' => $warehouseId, 'transferId' => $transfer->getId()));
  1882.             }
  1883.             
  1884.             /**
  1885.              * @Route("/{warehouseId}/scheda/trasferimento/invia-cerca", name="user_warehouse_transfer_send_search")
  1886.              * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  1887.              */
  1888.             public function userWarehouseTransferSendSearch($warehouseId, Request $request)
  1889.             {
  1890.                 $em = $this->mr->getManager('slave');
  1891.                 $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($request->request->get('transferId'));
  1892.                 $productCode = $request->request->get('productCode');
  1893.                 $codeType = $request->request->get('codeType');
  1894.                 $product = null;
  1895.                 $error = 'Il prodotto con il codice "'.$productCode.'" non è stato trovato!';
  1897.                 $found = false;
  1898.                 foreach($transfer->getWarehouseFrom()->getProducts() as $pr){
  1899.                     // CERCO TRA I PRODOTTI DEL MAGAZZINO DI PARTENZA
  1900.                     if($codeType == 'producer' && $productCode != null){
  1901.                         if(strtolower($pr->getCodeProducer()) == strtolower($productCode)){
  1902.                             $error = $pr->canBeTransferredStatus($transfer);
  1903.                             $found = true;
  1904.                             if($error == "ok")
  1905.                                 $product = $pr;
  1906.                             break;
  1907.                         }
  1908.                     }
  1909.                     elseif($codeType == 'supplier' && $pr->getCodeSupplier() != null){
  1910.                         if(strtolower($pr->getCodeSupplier()) == strtolower($productCode)){
  1911.                             $error = $pr->canBeTransferredStatus($transfer);
  1912.                             $found = true;
  1913.                             if($error == "ok")
  1914.                                 $product = $pr;
  1915.                             break;
  1916.                         }
  1917.                     }
  1918.                 }
  1920.                 if($found){
  1921.                     if($error == "ok"){
  1922.                         $json = '{
  1923.                             "id":"'.$product->getId().'", 
  1924.                             "model":"'.$product->getModel()->getName().'",
  1925.                             "producer":"'.$product->getModel()->getProducer()->getName().'",
  1926.                             "condition":"'.$product->displayCondition('string-short').'",
  1927.                             "suppliers":"'.$product->displayStringSuppliers().'",
  1928.                             "codeProducer":"'.$product->getCodeProducer().'", 
  1929.                             "codeSupplier":"'.$product->getCodeSupplier().'"
  1930.                         }';
  1931.                         return new Response(json_encode(array("code" => 200, "success" => true, "found" => $found, "error" => $error, 'product' => $json)));
  1932.                     }
  1933.                 }
  1934.                 else{
  1935.                     if($productCode != null){
  1936.                         switch($codeType){
  1937.                             case 'producer': $product = $em->getRepository("App\Entity\Slave\Product")->findOneBy(['codeProducer' => $productCode]); break;
  1938.                             case 'supplier': $product = $em->getRepository("App\Entity\Slave\Product")->findOneBy(['codeSupplier' => $productCode]); break;
  1939.                             default: break;
  1940.                         }
  1941.                     }
  1942.                     if($product != null)
  1943.                         $error = 'Il prodotto non è in questo magazzino! Si trova nel "'.$product->getActualWarehouse()->getNickname().'"';
  1944.                 }
  1946.                 return new Response(json_encode(array("code" => 200, "success" => true, "found" => $found, "error" => $error, 'product' => null)));
  1947.             }
  1948.             
  1949.             /**
  1950.              * @Route("/{warehouseId}/scheda/trasferimento/invia-preselezionati", name="user_warehouse_transfer_send_preselected")
  1951.              * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  1952.              */
  1953.             public function userWarehouseTransferSendPreselected($warehouseId, Request $request)
  1954.             {
  1955.                 $em = $this->mr->getManager('slave');
  1956.                 $product = $em->getRepository('App\Entity\Slave\Product')->findOneById($request->request->get('productId'));
  1957.                 $json = '{
  1958.                     "id":"'.$product->getId().'", 
  1959.                     "model":'.json_encode($product->getModel()->getName()).',
  1960.                     "producer":'.json_encode($product->getModel()->getProducer()->getName()).', 
  1961.                     "condition":"'.$product->displayCondition('string-short').'",
  1962.                     "suppliers":"'.$product->displayStringSuppliers().'",
  1963.                     "codeProducer":"'.$product->getCodeProducer().'", 
  1964.                     "codeSupplier":"'.$product->getCodeSupplier().'"
  1965.                 }';
  1966.                 return new Response(json_encode(array("code" => 200, "success" => true, 'product' => $json)));
  1967.             }
  1968.             
  1969.             /**
  1970.              * @Route("/{warehouseId}/scheda/trasferimento/invia-sposta-prodotto", name="user_warehouse_transfer_send_move_product")
  1971.              * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  1972.              */
  1973.             public function userWarehouseTransferSendMoveProduct($warehouseId, Request $request)
  1974.             {
  1975.                 $em = $this->mr->getManager('slave');
  1976.                 $session = $request->getSession();
  1977.                 $product = $em->getRepository('App\Entity\Slave\Product')->findOneById($request->request->get('productId'));
  1978.                 $warehouse = $em->getRepository("App\Entity\Slave\Warehouse")->findOneById($warehouseId);
  1980.                 ProductService::createProductTransferLog($em, $product, null, $this->getUser(), $warehouse, new \Datetime(), 'manual');                
  1981.                 $product->setActualWarehouse($warehouse);
  1982.                 $product->setDateLastTransfer(new \Datetime);
  1983.                 $em->flush();
  1985.                 return new Response(json_encode(array("code" => 200, "success" => true)));
  1986.             }
  1987.             
  1988.             /**
  1989.              * @Route("/{warehouseId}/scheda/trasferimento/invia-elimina-prodotto-trasferimento", name="user_warehouse_transfer_send_delete_product")
  1990.              * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  1991.              */
  1992.             public function userWarehouseTransferSendDeleteProduct($warehouseId, Request $request)
  1993.             {
  1994.                 $em = $this->mr->getManager('slave');
  1995.                 $transferInternalDdtActive = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'use_ddt'))->getValue();
  1996.                 $jtppt = $em->getRepository('App\Entity\Slave\JoinTableProductProductTransfer')->findOneById($request->request->get('jtpptId'));
  1997.                 $transferId = $jtppt->getTransfer()->getId();
  1999.                 $product = $jtppt->getProduct();
  2000.                 $status = ProductService::getStatusByCondition($em, $product->getCondition());
  2002.                 ProductService::createProductLog($em, $product, $this->getUser(), null, 'status', $product->getStatus()->getValue(), $status->getValue());
  2003.                 $product->setStatus($status);
  2004.                 $em->remove($jtppt);
  2005.                 $em->flush();
  2007.                 // RESETTO LO FASE TRANSFER A CREA DDT --- SE PRESENTE
  2008.                 $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($transferId);
  2009.                 if($transferInternalDdtActive || $transfer->getType() == 'destination'){
  2010.                     $transfer->setPhase('inserted_editable');
  2011.                     $transfer->setPhaseDdt('create');
  2012.                 }
  2013.                 else{
  2014.                     if(sizeof($transfer->getProducts()) > 0){
  2015.                         $transfer->setPhase('waiting_receiver');
  2016.                     }
  2017.                     else
  2018.                         $transfer->setPhase('inserted');
  2019.                 }
  2021.                 $em->flush();
  2022.                 return new Response(json_encode(array("code" => 200, "success" => true)));
  2023.             }
  2024.             
  2025.             /**
  2026.              * @Route("/{warehouseId}/scheda/trasferimento/invia-a-destinazione", name="user_warehouse_transfer_send_destination")
  2027.              * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  2028.              */
  2029.             public function userWarehouseTransferSendDestination($warehouseId, Request $request)
  2030.             {
  2031.                 $em = $this->mr->getManager('slave');
  2032.                 $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($request->request->get('transferId'));
  2033.                 $transfer->setPhase('to_download');
  2034.                 $transfer->setDatetimeSend(new \Datetime());
  2035.                 $em->flush();
  2036.                 $this->addFlash('notice_success', 'Trasferimento inviato correttamente!');
  2037.                 return $this->redirectToRoute('user_warehouse_transfer_sheet', array('warehouseId' => $warehouseId, 'transferId' => $transfer->getId()));
  2038.             }
  2039.             
  2040.             /**
  2041.              * @Route("/{warehouseId}/scheda/trasferimento/{transferId}/torna-a-modifica-dati", name="user_warehouse_transfer_back_edit_data")
  2042.              * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  2043.              */
  2044.             public function userWarehouseTransferBackEditData($warehouseId, $transferId, Request $request, FileSystem $fs)
  2045.             {
  2046.                 $em = $this->mr->getManager('slave');
  2047.                 $emMaster = $this->mr->getManager('master');
  2048.                 $session = $request->getSession();
  2049.                 $company = $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get("companyId"));
  2050.                 $uploadDir = $this->params->get('kernel.project_dir').'/'.$this->params->get('web_path').'/companies/'.$company->getDirectoryPath().'/ddt/';
  2051.                 $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($transferId);
  2052.                 $oldDDt = $transfer->getDDtPath();
  2054.                 $transfer->setPhase('inserted_editable');
  2055.                 $transfer->setPhaseDdt('create');
  2056.                 $transfer->setDdtPath(null);
  2057.                 MediaService::removeDocument($fs, $oldDDt, $uploadDir);
  2058.                 $em->flush();
  2059.                 $this->addFlash('notice_success', 'Trasferimento riportato alla fase precedente!');
  2060.                 return $this->redirectToRoute('user_warehouse_transfer_sheet', array('warehouseId' => $warehouseId, 'transferId' => $transfer->getId()));
  2061.             }
  2062.         //
  2063.     //
  2065.     // RICHIESTE TECNICI
  2066.         /**
  2067.          * @Route("/{warehouseId}/scheda/tecnico-richiedi-scorte/nuova", name="user_warehouse_product_request_new")
  2068.          * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  2069.          */
  2070.         public function userWarehouseProductRequestNew($warehouseId, Request $request, ValidatorInterface $validator, FormFactoryInterface $formFactory)
  2071.         {    
  2072.             $em = $this->mr->getManager('slave');
  2073.             $session = $request->getSession();
  2074.             $warehouse = $em->getRepository('App\Entity\Slave\Warehouse')->findOneById($warehouseId);
  2075.             $technician = $this->getUser();
  2076.             $headquarterWarehouses = $em->getRepository('App\Entity\Slave\Warehouse')->findBy(array('headquarter' => true));
  2077.             
  2078.             $productRequest = new ProductRequest();
  2079.             $form = $formFactory->createNamed("form_product_request", ProductRequestType::class, $productRequest);
  2080.             $form->handleRequest($request);
  2081.             
  2082.             if($form->isSubmitted()){
  2084.                 $valid = true;
  2085.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('warehouseHeadquarter'));
  2086.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('supplier'));
  2087.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('model'));
  2088.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('qty'));
  2090.                 if($valid && $form->isValid()){
  2092.                     $model = $em->getRepository('App\Entity\Slave\ProductModel')->findOneById($form->get('model')->getData());
  2093.                     $supplier = $em->getRepository('App\Entity\Slave\Supplier')->findOneById($form->get('supplier')->getData());
  2094.                     $qty = $form->get('qty')->getData();
  2096.                     $json = '{
  2097.                         "categoryId":"'.$model->getSubcategory()->getCategory()->getId().'",
  2098.                         "categoryName":"'.$model->getSubcategory()->getCategory()->getName().'",
  2099.                         "subcategoryId":"'.$model->getSubcategory()->getId().'",
  2100.                         "subcategoryName":"'.$model->getSubcategory()->getName().'",
  2101.                         "producerId":"'.$model->getProducer()->getId().'",
  2102.                         "producerName":"'.$model->getProducer()->getName().'",
  2103.                         "supplierName":"'.$supplier->getName().'",
  2104.                         "modelId":"'.$model->getId().'",
  2105.                         "modelName":"'.$model->getName().'",
  2106.                         "qty":"'.$qty.'"
  2107.                     }';
  2109.                     $productRequest->setTechnician($technician);
  2110.                     $productRequest->setWarehouse($warehouse);
  2111.                     $productRequest->setPhase('inserted');
  2112.                     $productRequest->setDatetime(new \Datetime());
  2113.                     $productRequest->setDetails($json);
  2114.                     $em->persist($productRequest);
  2115.                     $em->flush();
  2117.                     if($request->request->get('action') == 'add'){
  2118.                         $this->addFlash('notice_success', 'Richiesta aggiunta!');
  2119.                         return $this->redirectToRoute('user_warehouse_product_request_new', array('warehouseId' => $warehouse->getId()));
  2120.                     }
  2121.                     else{
  2122.                         $this->addFlash('notice_success', 'Richiesta inoltrata al magazzino centrale!');
  2123.                         return $this->redirectToRoute('user_warehouse_sheet', array('warehouseId' => $warehouse->getId()));
  2124.                     }
  2125.                 }
  2126.             }
  2127.             
  2128.             return $this->render('role/user/warehouse/product_request.html.twig', array(
  2129.                 'warehouse' => $warehouse,
  2130.                 'headquarterWarehouses' => $headquarterWarehouses,
  2131.                 "form" => $form->createView()
  2132.             ));
  2133.         }
  2135.         /**
  2136.          * @Route("/{warehouseId}/scheda/richiesta-tecnico/elimina", name="user_warehouse_product_request_delete")
  2137.          * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  2138.          */
  2139.         public function userWarehouseProductRequestDelete($warehouseId, Request $request)
  2140.         {
  2141.             $em = $this->mr->getManager('slave');
  2142.             $productRequest = $em->getRepository('App\Entity\Slave\ProductRequest')->findOneById($request->request->get('productRequestId'));
  2143.             $em->remove($productRequest);
  2144.             $em->flush();
  2145.             $this->addFlash('notice_success', 'Richiesta eliminata!');
  2146.             return $this->redirectToRoute('user_warehouse_sheet', array('warehouseId' => $warehouseId));
  2147.         }
  2148.         
  2149.         /**
  2150.          * @Route("/{warehouseId}/scheda/richiesta-tecnico/prendi-in-carico", name="user_warehouse_product_request_take_charge")
  2151.          * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  2152.          */
  2153.         public function userWarehouseProductRequestTakeCharge($warehouseId, Request $request)
  2154.         {
  2155.             $em = $this->mr->getManager('slave');
  2156.             $productRequest = $em->getRepository('App\Entity\Slave\ProductRequest')->findOneById($request->request->get('productRequestId'));
  2157.             $productRequest->setPhase('take_charge');
  2158.             $em->flush();
  2159.             $this->addFlash('notice_success', 'Richiesta presa in carico!');
  2160.             return $this->redirectToRoute('user_warehouse_sheet', array('warehouseId' => $warehouseId));
  2161.         }
  2162.         
  2163.         /**
  2164.          * @Route("/{warehouseId}/scheda/richiesta-tecnico/dichiara-gestita", name="user_warehouse_product_request_managed")
  2165.          * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  2166.          */
  2167.         public function userWarehouseProductRequestManaged($warehouseId, Request $request)
  2168.         {
  2169.             $em = $this->mr->getManager('slave');
  2170.             $productRequest = $em->getRepository('App\Entity\Slave\ProductRequest')->findOneById($request->request->get('productRequestId'));
  2171.             $productRequest->setPhase('completed');
  2172.             $em->flush();
  2173.             $this->addFlash('notice_success', 'Richiesta gestita!');
  2174.             return $this->redirectToRoute('user_warehouse_sheet', array('warehouseId' => $warehouseId));
  2175.         }
  2176.     //
  2178.     // ESPORTAZIONI
  2179.         /**
  2180.          * @Route("/{warehouseId}/scorte/esporta-csv", name="user_warehouse_stocks_export_csv")
  2181.          * @Security("is_granted('view', 'warehouse') || is_granted('warehouse_view', warehouseId)")
  2182.          */
  2183.         public function userWarehouseStocksExportCsv($warehouseId, Request $request)
  2184.         {    
  2185.             $em = $this->mr->getManager('slave');
  2186.             $session = $request->getSession();
  2187.             $warehouse = $em->getRepository("App\Entity\Slave\Warehouse")->findOneById($warehouseId);
  2188.             $products = $em->getRepository('App\Entity\Slave\Product')->findByWarehouseOrdered($warehouse->getId());
  2190.             $response = new StreamedResponse();
  2192.             $response->setCallback(function() use($products) {
  2193.                 $handle = fopen('php://output', 'w+');
  2194.                 fputcsv($handle, array('Stato','Modello','Matricola produttore','Matricola fornitore','Fornitori','Condizione','Ultimo ticket - Numero','Ultimo ticket - Termid','Ultimo ticket - Tipo intervento'), ";", '"', "\\");
  2196.                 foreach($products as $p){
  2197.             
  2198.                     $status = null;
  2199.                     $model = null;
  2200.                     $codeProducer = '';
  2201.                     $codeSupplier = '';
  2202.                     $condition = null;
  2203.                     $suppliers = '';
  2204.                     $lastTicket = '';
  2205.                     $lastTermid = '';
  2206.                     $lastOperation = '';
  2207.                     if($p->getStatus() != null) $status = $p->getStatus()->getValue();
  2208.                     if($p->getModel() != null) $model = $p->getModel()->getName().' - '.$p->getModel()->getSubcategory()->getName().' - '.$p->getModel()->getSubcategory()->getCategory()->getName();
  2209.                     if($p->getCodeProducer() != null) $codeProducer = $p->getCodeProducer();
  2210.                     if($p->getCodeSupplier() != null) $codeSupplier = $p->getCodeSupplier();
  2211.                     if(sizeof($p->getSuppliers()) > 0){
  2212.                         $suppliers = "";
  2213.                         $first = true;
  2214.                         foreach($p->getSuppliers() as $s){
  2215.                             if($first) $first = false; else $suppliers.= ', ';
  2216.                             $suppliers.= $s->getName();
  2217.                         }
  2218.                     }
  2219.                     if($p->getCondition() != null) $condition = $p->getCondition()->getValue();
  2220.                     if($p->getLastTicket() != null && $p->getStatus()->getSlug() == "not_available"){
  2221.                         $lastTicket = $p->getLastTicket()->getNumber();
  2222.                         $lastTermid = $p->getLastTicket()->getTermid()->getCode();
  2223.                         $lastOperation = $p->getLastOperationGroupType();
  2224.                     }
  2225.                     fputcsv($handle, array($status, $model, $codeProducer, $codeSupplier, $suppliers, $condition, $lastTicket, $lastTermid, $lastOperation), ";", '"', "\\");
  2226.                 }
  2228.                 fclose($handle);
  2229.             });
  2230.             
  2231.             $response->setStatusCode(200);
  2232.             $dispositionHeader = $response->headers->makeDisposition(ResponseHeaderBag::DISPOSITION_ATTACHMENT, 'Magazzino '.$warehouse->getNickname().' - Scorte.csv');
  2233.             $response->headers->set('Content-Type', 'text/csv; charset=ISO-8859-15');
  2234.             $response->headers->set('Content-Disposition', $dispositionHeader);
  2235.             return $response;
  2236.         }
  2238.         /**
  2239.          * @Route("/{warehouseId}/scorte/esporta-csv-filtrate/{status}", name="user_warehouse_stocks_export_csv_filtered")
  2240.          * @Security("is_granted('view', 'warehouse') || is_granted('warehouse_view', warehouseId)")
  2241.          */
  2242.         public function userWarehouseStocksExportCsvFiltered($warehouseId, $status, Request $request)
  2243.         {    
  2244.             $em = $this->mr->getManager('slave');
  2245.             $session = $request->getSession();
  2246.             $warehouse = $em->getRepository("App\Entity\Slave\Warehouse")->findOneById($warehouseId);
  2247.             $filters = $session->get('user_warehouse_sheet_filters');
  2248.             $products = $em->getRepository('App\Entity\Slave\Product')->findByWarehouseFiltered(false, $warehouse->getId(), $status, $filters, 1);
  2249.             $response = new StreamedResponse();
  2250.             $response->setCallback(function() use($products) {
  2251.                 $handle = fopen('php://output', 'w+');
  2252.                 fputcsv($handle, array('Stato','Modello','Matricola produttore','Matricola fornitore','Fornitori','Condizione','Ultimo ticket - Numero','Ultimo ticket - Termid','Ultimo ticket - Tipo intervento'), ";", '"', "\\");
  2254.                 foreach($products as $p){
  2255.             
  2256.                     $status = null;
  2257.                     $model = null;
  2258.                     $codeProducer = '';
  2259.                     $codeSupplier = '';
  2260.                     $condition = null;
  2261.                     $suppliers = '';
  2262.                     $lastTicket = '';
  2263.                     $lastTermid = '';
  2264.                     $lastOperation = '';
  2265.                     if($p->getStatus() != null) $status = $p->getStatus()->getValue();
  2266.                     if($p->getModel() != null) $model = $p->getModel()->getName().' - '.$p->getModel()->getSubcategory()->getName().' - '.$p->getModel()->getSubcategory()->getCategory()->getName();
  2267.                     if($p->getCodeProducer() != null) $codeProducer = $p->getCodeProducer();
  2268.                     if($p->getCodeSupplier() != null) $codeSupplier = $p->getCodeSupplier();
  2269.                     if(sizeof($p->getSuppliers()) > 0){
  2270.                         $suppliers = "";
  2271.                         $first = true;
  2272.                         foreach($p->getSuppliers() as $s){
  2273.                             if($first) $first = false; else $suppliers.= ', ';
  2274.                             $suppliers.= $s->getName();
  2275.                         }
  2276.                     }
  2277.                     if($p->getCondition() != null) $condition = $p->getCondition()->getValue();
  2278.                     if($p->getLastTicket() != null && $p->getStatus()->getSlug() == "not_available"){
  2279.                         $lastTicket = $p->getLastTicket()->getNumber();
  2280.                         $lastTermid = $p->getLastTicket()->getTermid()->getCode();
  2281.                         $lastOperation = $p->getLastOperationGroupType();
  2282.                     }
  2283.                     fputcsv($handle, array($status, $model, $codeProducer, $codeSupplier, $suppliers, $condition, $lastTicket, $lastTermid, $lastOperation), ";", '"', "\\");
  2284.                 }
  2286.                 fclose($handle);
  2287.             });
  2288.             
  2289.             $response->setStatusCode(200);
  2290.             $dispositionHeader = $response->headers->makeDisposition(ResponseHeaderBag::DISPOSITION_ATTACHMENT, 'Magazzino '.$warehouse->getNickname().' - Scorte filtrate.csv');
  2291.             $response->headers->set('Content-Type', 'text/csv; charset=ISO-8859-15');
  2292.             $response->headers->set('Content-Disposition', $dispositionHeader);
  2293.             return $response;
  2294.         }
  2295.         
  2296.         /**
  2297.          * @Route("/{warehouseId}/scorte/esporta-csv-per-invio/{status}", name="user_warehouse_stocks_export_csv_for_send")
  2298.          * @Security("is_granted('view', 'warehouse') || is_granted('warehouse_view', warehouseId)")
  2299.          */
  2300.         public function userWarehouseStocksExportCsvForSend($warehouseId, $status, Request $request)
  2301.         {    
  2302.             $em = $this->mr->getManager('slave');
  2303.             $session = $request->getSession();
  2304.             $warehouse = $em->getRepository("App\Entity\Slave\Warehouse")->findOneById($warehouseId);
  2305.             $filters = $session->get('user_warehouse_sheet_filters');
  2306.             $products = $em->getRepository('App\Entity\Slave\Product')->findByWarehouseFiltered(false, $warehouse->getId(), $status, $filters, 1);
  2308.             $response = new StreamedResponse();
  2310.             $response->setCallback(function() use($products) {
  2311.                 $handle = fopen('php://output', 'w+');
  2312.                 fputcsv($handle, array('Matricola produttore','Matricola fornitore'), ";", '"', "\\");
  2314.                 foreach($products as $p){
  2315.             
  2316.                     $codeProducer = '';
  2317.                     $codeSupplier = '';
  2318.                     if($p->getCodeProducer() != null) $codeProducer = $p->getCodeProducer();
  2319.                     if($p->getCodeSupplier() != null) $codeSupplier = $p->getCodeSupplier();
  2320.         
  2321.                     fputcsv($handle, array($codeProducer, $codeSupplier), ";", '"', "\\");
  2322.                 }
  2324.                 fclose($handle);
  2325.             });
  2326.             
  2327.             $response->setStatusCode(200);
  2328.             $dispositionHeader = $response->headers->makeDisposition(ResponseHeaderBag::DISPOSITION_ATTACHMENT, 'Magazzino '.$warehouse->getNickname().' - Scorte per invio.csv');
  2329.             $response->headers->set('Content-Type', 'text/csv; charset=ISO-8859-15');
  2330.             $response->headers->set('Content-Disposition', $dispositionHeader);
  2331.             return $response;
  2332.         }
  2333.         
  2334.         /**
  2335.          * @Route("/{warehouseId}/scheda/trasferimento/{transferId}/scheda/esporta-csv", name="user_warehouse_transfer_sheet_export")
  2336.          * @Security("is_granted('edit', 'warehouse') || is_granted('warehouse_edit', warehouseId)")
  2337.          */
  2338.         public function userWarehouseTransferSheetExport($warehouseId, $transferId, Request $request)
  2339.         {    
  2340.             $em = $this->mr->getManager('slave');
  2341.             $emMaster = $this->mr->getManager('master');
  2342.             $session = $request->getSession();
  2343.             $warehouse = $em->getRepository("App\Entity\Slave\Warehouse")->findOneById($warehouseId);
  2344.             $transfer = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOneById($transferId);
  2345.             $jtppts = $transfer->getProducts();
  2347.             $response = new StreamedResponse();
  2348.             $response->setCallback(function() use($jtppts) {
  2349.                 $handle = fopen('php://output', 'w+');
  2350.                 fputcsv($handle, array("Fornitori", "Modello", "Matricola produttore",'Matricola fornitore'), ";", '"', "\\");
  2351.                 foreach($jtppts as $jtppt){
  2352.                     $suppliers = $jtppt->getProduct()->displayStringSuppliers();
  2353.                     $productModel = $jtppt->getProduct()->getModel()->getName();
  2354.                     $codeProducer = '';
  2355.                     $codeSupplier = '';
  2356.                     if($jtppt->getProduct()->getCodeProducer() != null) $codeProducer = $jtppt->getProduct()->getCodeProducer();
  2357.                     if($jtppt->getProduct()->getCodeSupplier() != null) $codeSupplier = $jtppt->getProduct()->getCodeSupplier();
  2358.                     fputcsv($handle, array($suppliers, $productModel, $codeProducer, $codeSupplier), ";", '"', "\\");
  2359.                 }
  2360.                 fclose($handle);
  2361.             });
  2362.     
  2363.             $response->setStatusCode(200);
  2364.             $dispositionHeader = $response->headers->makeDisposition(ResponseHeaderBag::DISPOSITION_ATTACHMENT, 'Matricole trasferimento.csv');
  2365.             $response->headers->set('Content-Type', 'text/csv; charset=ISO-8859-15');
  2366.             $response->headers->set('Content-Disposition', $dispositionHeader);
  2367.     
  2368.             return $response;
  2369.         }
  2370.     //
  2371. }