src/Controller/User/UserController.php line 524

Open in your IDE?
  1. <?php
  3. namespace App\Controller\User;
  5. use App\Form\Model\Settings;
  6. use App\Form\Model\SearchIndex;
  7. use App\Form\Slave\SettingsType;
  8. use App\Form\Slave\SearchIndexType;
  9. use App\Service\FilterService;
  10. use App\Service\SessionService;
  11. use App\Service\TicketService;
  12. use App\Service\UtilitiesService;
  13. use App\Service\ValidationService;
  14. use Doctrine\Persistence\ManagerRegistry;
  15. use Knp\Component\Pager\PaginatorInterface;
  16. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Security;
  17. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  18. use Symfony\Component\DependencyInjection\ParameterBag\ParameterBagInterface;
  19. use Symfony\Component\Filesystem\Filesystem;
  20. use Symfony\Component\Form\FormFactoryInterface;
  21. use Symfony\Component\Form\FormError;
  22. use Symfony\Component\HttpFoundation\Request;
  23. use Symfony\Component\HttpFoundation\Response;
  24. use Symfony\Component\Routing\Annotation\Route;
  25. use Symfony\Component\Validator\Validator\ValidatorInterface;
  26. use Symfony\Component\Validator\Constraints as Assert;
  28. /**
  29.  * @Route("/scrivania")
  30.  * @Security("is_granted('ROLE_USER') and is_granted('active', user)")
  31.  */
  32. class UserController extends AbstractController
  33. {
  34.     private $mr;
  35.     private $params;
  37.     public function __construct(ManagerRegistry $mr, ParameterBagInterface $params)
  38.     {
  39.         $this->mr = $mr;
  40.         $this->params = $params;
  41.     }
  43.     public function calculateTicketAlarms($em, $type, $operationGroups, $ticketStatuses, $technicians)
  44.     {
  45.         $matrixTickets = array();
  46.         $matrixTechsTickets = array();
  47.         $ticketWithErrors = null;
  48.         $ticketSuspensionRequest = null;
  49.         $ticketAssigned = null;
  50.         $ticketClosedPortal = null;
  51.         
  52.         switch($type){
  53.             case 'administration':
  54.             case 'agency':
  55.             case 'commercial':
  56.             case 'warehouse':
  57.                 foreach($operationGroups as $og){
  58.                     $arrayTmp1 = array();
  59.                     $arrayTmp2 = array();
  60.                     foreach($ticketStatuses as $ts){
  61.                         $arrayTmp3 = array();
  62.                         $ticketsCount = sizeof($em->getRepository('App\Entity\Slave\Ticket')->findByStatusAndOperationGroup($ts->getId(), $og->getId()));
  63.                         array_push($arrayTmp3, $ts->getId(), $ticketsCount);
  64.                         array_push($arrayTmp2, $arrayTmp3);
  65.                     }
  66.                     array_push($arrayTmp1, $og->getId(), $arrayTmp2);
  67.                     array_push($matrixTickets, $arrayTmp1);
  68.                 }
  69.                 
  70.                 foreach($technicians as $t){
  71.                     $arrayTmp1 = array();
  72.                     $arrayTmp2 = array();
  73.                     foreach($operationGroups as $og){
  74.                         $arrayTmp3 = array();
  75.                         $ticketsCountAssigned = sizeof($em->getRepository('App\Entity\Slave\Ticket')->findByTechnicianOperationGroupAndStatus($t->getId(), $og->getId(), 'assigned'));
  76.                         $ticketsCountTakenCharge = sizeof($em->getRepository('App\Entity\Slave\Ticket')->findByTechnicianOperationGroupAndStatus($t->getId(), $og->getId(), 'taken_charge'));
  77.                         array_push($arrayTmp3, $og->getId(), $ticketsCountAssigned, $ticketsCountTakenCharge);
  78.                         array_push($arrayTmp2, $arrayTmp3);
  79.                     }
  80.                     array_push($arrayTmp1, $t->getId(), $arrayTmp2);
  81.                     array_push($matrixTechsTickets, $arrayTmp1);
  82.                 }
  84.                 $ticketWithErrors = $em->getRepository('App\Entity\Slave\Ticket')->findWithErrors();
  85.                 $ticketSuspensionRequest = $em->getRepository('App\Entity\Slave\Ticket')->findBySuspensionRequestAndNotManaged();
  86.                 $ticketClosedPortal = $em->getRepository('App\Entity\Slave\Ticket')->findClosedPortalAndNotPlatform();
  87.                 $ticketWaitingForMaterial = $em->getRepository('App\Entity\Slave\Ticket')->findWaitingForMaterial();
  88.                 $interventionsOutcomeTypeCompleted = $em->getRepository('App\Entity\Slave\Intervention')->findOutcomeTypeCompleted();
  89.                 $interventionWithoutActivities = array();
  90.                 foreach($interventionsOutcomeTypeCompleted as $int){
  91.                     if(sizeof($int->getActivities()) == 0)
  92.                         array_push($interventionWithoutActivities, $int);
  93.                 }
  94.                 $interventionsZero = $em->getRepository('App\Entity\Slave\Intervention')->findCompletedOrUavWithoutAmountTechnician();
  95.                 $interventionTariffOut = array();
  96.                 foreach($interventionsZero as $int){
  97.                     $hasTarOut = false;
  98.                     foreach($int->getExtras() as $ext){
  99.                         if($ext->isTariffOut())
  100.                             $hasTarOut = true;
  101.                     }
  102.                     if(!$hasTarOut)
  103.                         array_push($interventionTariffOut, $int);
  104.                 }
  105.                 return [$matrixTickets, $matrixTechsTickets, $ticketWithErrors, $ticketSuspensionRequest, $ticketClosedPortal, $ticketWaitingForMaterial, $interventionTariffOut, $interventionWithoutActivities];
  106.                 break;
  107.             case 'technician':
  108.                 foreach($operationGroups as $og){
  109.                     $arrayTmp1 = array();
  110.                     $arrayTmp2 = array();
  111.                     foreach($ticketStatuses as $ts){
  112.                         $arrayTmp3 = array();
  113.                         $ticketsCount = sizeof($em->getRepository('App\Entity\Slave\Ticket')->findByUserStatusAndOperationGroup($this->getUser()->getId(), $ts->getId(), $og->getId()));
  114.                         array_push($arrayTmp3, $ts->getId(), $ticketsCount);
  115.                         array_push($arrayTmp2, $arrayTmp3);
  116.                     }
  117.                     array_push($arrayTmp1, $og->getId(), $arrayTmp2);
  118.                     array_push($matrixTickets, $arrayTmp1);
  119.                 }
  120.                 $ticketAssigned = $em->getRepository('App\Entity\Slave\Ticket')->findByUserAndStatus($this->getUser()->getId(), 'assigned');
  121.                 return [$matrixTickets, $ticketAssigned];
  122.                 break;
  123.             default: break;
  124.         }
  125.     }
  127.     public function calculateWarehouseAlarms($em, $type)
  128.     {
  129.         switch($type){
  130.             case 'administration':
  131.             case 'agency':
  132.             case 'commercial':
  133.             case 'warehouse':
  134.                 $productModels = $em->getRepository('App\Entity\Slave\ProductModel')->findAll();
  135.                 $headquarterWarehouses = $em->getRepository('App\Entity\Slave\Warehouse')->findBy(array('headquarter' => true));
  136.                 $warehouseAlarms = array();
  137.                 foreach($headquarterWarehouses as $w){
  138.                     $tmp = array();
  139.                     $warehouseProductsToManage = sizeof($em->getRepository('App\Entity\Slave\Product')->findByWarehouseToManage($w->getId()));
  140.                     $warehouseTransferIncoming = $em->getRepository('App\Entity\Slave\ProductTransfer')->findIncomingByWarehouseAndNotCompleted($w->getId());
  141.                     $warehouseTransferOutput = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOutputByWarehouseAndNotCompleted($w->getId());
  142.                     $warehouseTransferWithoutDdtSigned = $em->getRepository('App\Entity\Slave\ProductTransfer')->findWithoutDdtSignedByWarehouse($w->getId());
  143.                     $warehouseRequestTechnicians = $em->getRepository('App\Entity\Slave\ProductRequest')->findByWarehouseAndNotCompleted($w->getId());
  144.                     $warehouseProductStocksRed = array();
  145.                     $warehouseProductStocksYellow = array();
  146.                     foreach($productModels as $pm){
  147.                         if(sizeof($pm->getSuppliers()) > 0){
  148.                             foreach($pm->getSuppliers() as $jtpms){
  149.                                 $tmpRed = array();
  150.                                 $tmpYellow = array();
  151.                                 $qty = sizeof($em->getRepository('App\Entity\Slave\Product')->countByWarehouseAndModelAndSupplierAndStatus($w->getId(), $pm->getId(), $jtpms->getSupplier()->getId(), 'available'));
  152.                                 if($jtpms->isAlarmStockActive()){
  153.                                     if($qty <= $jtpms->getAlarmStockRed()){
  154.                                         array_push($tmpRed, $qty, $jtpms->getAlarmStockRed(), $pm->getName(), $jtpms->getSupplier()->getName());
  155.                                         array_push($warehouseProductStocksRed, $tmpRed);
  156.                                     }
  157.                                     elseif($qty <= $jtpms->getAlarmStockYellow()){
  158.                                         array_push($tmpYellow, $qty, $jtpms->getAlarmStockYellow(), $jtpms->getAlarmStockRed(), $pm->getName(), $jtpms->getSupplier()->getName());
  159.                                         array_push($warehouseProductStocksYellow, $tmpYellow);
  160.                                     }
  161.                                 }
  162.                             }
  163.                         }
  164.                     }
  165.                     array_push($tmp, $w->getId(), $w->getNickname(), $warehouseProductsToManage, $warehouseTransferIncoming, $warehouseTransferOutput, $warehouseTransferWithoutDdtSigned, $warehouseRequestTechnicians, $warehouseProductStocksRed, $warehouseProductStocksYellow);
  166.                     array_push($warehouseAlarms, $tmp);
  167.                 }
  168.                 return $warehouseAlarms;
  169.                 break;
  170.             case 'technician':
  171.                 $warehousesTransfers = array();
  172.                 foreach($this->getUser()->getWarehouses() as $jtuw){
  173.                     $transfersIncoming = $em->getRepository('App\Entity\Slave\ProductTransfer')->findIncomingByWarehouseAndNotCompleted($jtuw->getWarehouse()->getId());
  174.                     $transfersOutput = $em->getRepository('App\Entity\Slave\ProductTransfer')->findOutputByWarehouseAndNotCompleted($jtuw->getWarehouse()->getId());
  175.                     $transfersWithoutDdtSigned = $em->getRepository('App\Entity\Slave\ProductTransfer')->findWithoutDdtSignedByWarehouse($jtuw->getWarehouse()->getId());
  176.                     $tmp = array();
  177.                     array_push($tmp, $jtuw->getWarehouse()->getId(), $jtuw->getWarehouse()->getNickname(), $transfersIncoming, $transfersOutput, $transfersWithoutDdtSigned);
  178.                     array_push($warehousesTransfers, $tmp);
  179.                 }
  180.                 return $warehousesTransfers;
  181.                 break;
  182.             default: break;
  183.         }
  184.     }
  186.     public function calculateProductsAlarms($em)
  187.     {
  188.         $productModels = $em->getRepository('App\Entity\Slave\ProductModel')->findAll();
  189.         $productModelsSuppliers = array();
  190.         foreach($productModels as $pm){
  191.             if(sizeof($pm->getSuppliers()) == 0)
  192.                 array_push($productModelsSuppliers, $pm);
  193.         }
  195.         $doubleProducts = array();
  196.         $codesProducerDouble = $em->getRepository('App\Entity\Slave\Product')->findWithSameCodeByType('codeProducer');
  197.         $codesSupplierDouble = $em->getRepository('App\Entity\Slave\Product')->findWithSameCodeByType('codeSupplier');
  199.         foreach($codesProducerDouble as $cpd){
  200.             $tmp = array();
  201.             $prs = $em->getRepository('App\Entity\Slave\Product')->findBy(array('codeProducer' => $cpd->getCodeProducer()));
  202.             switch(sizeof($prs)){
  203.                 case 2: $tmp = array($prs[0]->getId(), $prs[0]->getCodeProducer(), $prs[0]->getCodeSupplier(), $prs[1]->getId(), $prs[1]->getCodeProducer(), $prs[1]->getCodeSupplier()); break;
  204.                 case 3: $tmp = array($prs[0]->getId(), $prs[0]->getCodeProducer(), $prs[0]->getCodeSupplier(), $prs[1]->getId(), $prs[1]->getCodeProducer(), $prs[1]->getCodeSupplier(), $prs[2]->getId(), $prs[2]->getCodeProducer(), $prs[2]->getCodeSupplier()); break;
  205.                 default: break;
  206.             }
  207.             if(sizeof($tmp) > 0)
  208.                 array_push($doubleProducts, $tmp);
  209.         }
  210.         
  211.         foreach($codesSupplierDouble as $csd){
  212.             $tmp = array();
  213.             $prs = $em->getRepository('App\Entity\Slave\Product')->findBy(array('codeSupplier' => $csd->getCodeSupplier()));
  214.             switch(sizeof($prs)){
  215.                 case 2: $tmp = array($prs[0]->getId(), $prs[0]->getCodeProducer(), $prs[0]->getCodeSupplier(), $prs[1]->getId(), $prs[1]->getCodeProducer(), $prs[1]->getCodeSupplier()); break;
  216.                 case 3: $tmp = array($prs[0]->getId(), $prs[0]->getCodeProducer(), $prs[0]->getCodeSupplier(), $prs[1]->getId(), $prs[1]->getCodeProducer(), $prs[1]->getCodeSupplier(), $prs[2]->getId(), $prs[2]->getCodeProducer(), $prs[2]->getCodeSupplier()); break;
  217.                 default: break;
  218.             }
  219.             if(sizeof($tmp) > 0)
  220.                 array_push($doubleProducts, $tmp);
  221.         }
  223.         return [$productModelsSuppliers, $doubleProducts];
  224.     }
  226.     public function searchValues($request, $formFactory, $validator, $em, $session)
  227.     {
  228.         $results = array();
  229.         $type = '';
  230.         $like = '';
  231.         $value = '';
  233.         $subjects = array();
  234.         $subjectTicket = array('TermID' => 'termid', 'N° Ticket' => 'n_ticket');
  235.         $subjectProduct = array('Matricola produttore' => 'code_producer', 'Matricola fornitore' => 'code_supplier');
  236.         $subjectTransfer = array('N° DDT' => 'ddt');
  237.         $subjectClient = array('Cliente insegna' => 'client_nickname', 'Cliente telefono' => 'client_phone');
  238.         
  239.         if($this->getUser()->canRead('ticket')) array_push($subjects, $subjectTicket);
  240.         if($this->getUser()->canRead('product')) array_push($subjects, $subjectProduct);
  241.         if($this->getUser()->canRead('transfer')) array_push($subjects, $subjectTransfer);
  242.         if($this->getUser()->canRead('anagraphic_client')) array_push($subjects, $subjectClient);
  244.         $searchIndex = new SearchIndex();
  245.         $formSearch = $formFactory->createNamed("form_settings", SearchIndexType::class, $searchIndex, array('types' => $subjects));
  246.         $formSearch->handleRequest($request);
  248.         if($formSearch->isSubmitted()){
  250.             $valid = true;
  251.             if($valid) $valid = ValidationService::ValidateNotBlank($validator, $formSearch->get('type'));
  252.             if($valid) $valid = ValidationService::ValidateNotBlank($validator, $formSearch->get('like'));
  253.             if($valid) $valid = ValidationService::ValidateNotBlank($validator, $formSearch->get('value'));
  254.             
  255.             if($valid && $formSearch->isValid()){
  257.                 $type = $formSearch->get('type')->getData();
  258.                 $like = $formSearch->get('like')->getData();
  259.                 $value = $formSearch->get('value')->getData();
  261.                 switch($like){
  262.                     case 'like': $value = '%'.$value.'%'; break;
  263.                     case 'from_left': $value = $value.'%'; break;
  264.                     case 'from_right': $value = '%'.$value; break;
  265.                     default: break;
  266.                 }
  268.                 switch($type){
  269.                     case 'termid': 
  270.                     case 'n_ticket':
  271.                         $results = $em->getRepository('App\Entity\Slave\Ticket')->searchByValue($type, $value);
  272.                         break;
  273.                     case 'code_supplier': 
  274.                     case 'code_producer':
  275.                         $results = $em->getRepository('App\Entity\Slave\Product')->searchByValue($type, $value);
  276.                         break;
  277.                     case 'ddt':
  278.                         $results = $em->getRepository('App\Entity\Slave\ProductTransfer')->searchByValue($type, $value);
  279.                         break;
  280.                     case 'client_nickname':
  281.                         $results = $em->getRepository('App\Entity\Slave\Client')->searchByValue($type, $value);
  282.                         break;
  283.                     case 'client_phone':
  284.                         $results = $em->getRepository('App\Entity\Slave\ClientPhone')->searchByValue($type, $value);
  285.                         break;
  286.                     default: break;
  287.                 }
  288.             }
  289.         }
  291.         return [$formSearch, $results, $type, $like, $value];
  292.     }
  294.     /**
  295.      * @Route("/", name="user_index")
  296.      */
  297.     public function userIndex(Request $request, PaginatorInterface $paginator, FormFactoryInterface $formFactory, ValidatorInterface $validator)
  298.     {    
  299.         $em = $this->mr->getManager('slave');
  300.         $emMaster = $this->mr->getManager('master');
  301.         $session = $request->getSession();
  302.         $session->remove('ticketId');
  304.         // In base al tipo di account mostro nella home differenti schermate
  305.         switch($this->getUser()->getAccountTypology()){
  306.             case 'administration': // Amministrazione
  307.             case 'agency': // Agenzia
  308.             case 'commercial': // Commerciale
  309.             case 'warehouse': // Magazzino
  310.                 $operationGroups = $em->getRepository('App\Entity\Slave\OperationGroup')->findAll();
  311.                 $ticketStatuses = $em->getRepository('App\Entity\Slave\TicketStatus')->findAll();
  312.                 $technicians = $em->getRepository('App\Entity\Slave\User')->findTechniciansActive();
  313.                 [$matrixTickets, $matrixTechsTickets, $ticketWithErrors, $ticketSuspensionRequest, $ticketClosedPortal, $ticketWaitingForMaterial, $interventionTariffOut, $interventionWithoutActivities] = $this->calculateTicketAlarms($em, 'agency', $operationGroups, $ticketStatuses, $technicians);
  314.                 $interventionExtras = $em->getRepository('App\Entity\Slave\InterventionExtra')->findBy(array('managed' => false));
  315.                 $ticketReminders = $em->getRepository('App\Entity\Slave\TicketReminder')->findDashboardReminders();
  316.                 $operationsWithoutTariffs = $em->getRepository('App\Entity\Slave\Operation')->findWithoutTariffs();
  317.                 $operationsWithoutKeyMappings = $em->getRepository('App\Entity\Slave\Operation')->findWithoutKeyMappings();
  318.                 $warehouseAlarms = $this->calculateWarehouseAlarms($em, 'agency');
  319.                 [$productModelsSuppliers, $doubleProducts] = $this->calculateProductsAlarms($em);
  320.                 [$formSearch, $results, $type, $like, $value] = $this->searchValues($request, $formFactory, $validator, $em, $session);
  322.                 return $this->render('role/user/index.html.twig', array(
  323.                     'operationGroups' => $operationGroups,
  324.                     'technicians' => $technicians,
  325.                     'ticketStatuses' => $ticketStatuses,
  326.                     'matrixTickets' => $matrixTickets,
  327.                     'matrixTechsTickets' => $matrixTechsTickets,
  328.                     'ticketWithErrors' => $ticketWithErrors,
  329.                     'ticketSuspensionRequest' => $ticketSuspensionRequest,
  330.                     'ticketClosedPortal' => $ticketClosedPortal,
  331.                     'ticketWaitingForMaterial' => $ticketWaitingForMaterial,
  332.                     'interventionWithoutActivities' => $interventionWithoutActivities,
  333.                     'interventionTariffOut' => $interventionTariffOut,
  334.                     'interventionExtras' => $interventionExtras,
  335.                     'operationsWithoutTariffs' => $operationsWithoutTariffs,
  336.                     'operationsWithoutKeyMappings' => $operationsWithoutKeyMappings,
  337.                     'warehouseAlarms' => $warehouseAlarms,
  338.                     'productModelsSuppliers' => $productModelsSuppliers,
  339.                     'doubleProducts' => $doubleProducts,
  340.                     'ticketReminders' => $ticketReminders,
  341.                     'formSearch' => $formSearch->createView(),
  342.                     'searchResults' => $results,
  343.                     'searchType' => $type,
  344.                     'searchLike' => $like,
  345.                     'searchValue' => $value
  346.                 ));
  347.                 break;
  348.             case 'technician': // Tecnici
  349.                 $operationGroups = $em->getRepository('App\Entity\Slave\OperationGroup')->findAll();
  350.                 $ticketStatuses = $em->getRepository('App\Entity\Slave\TicketStatus')->findWithoutToAssignAndWrong();
  351.                 [$matrixTickets, $ticketAssigned] = $this->calculateTicketAlarms($em, 'technician', $operationGroups, $ticketStatuses, null);
  352.                 $ticketReminders = $em->getRepository('App\Entity\Slave\TicketReminder')->findDashboardRemindersByTechnician($this->getUser()->getId());
  353.                 $warehousesTransfers = $this->calculateWarehouseAlarms($em, 'technician');
  355.                 return $this->render('role/user/index.html.twig', array(
  356.                     'operationGroups' => $operationGroups,
  357.                     'ticketStatuses' => $ticketStatuses,
  358.                     'matrixTickets' => $matrixTickets,
  359.                     'ticketAssigned' => $ticketAssigned,
  360.                     'warehousesTransfers' => $warehousesTransfers,
  361.                     'ticketReminders' => $ticketReminders
  362.                 ));
  363.                 break;
  364.             case 'administration': // Amministrazione
  365.                 return $this->render('role/user/index.html.twig');
  366.                 break;
  367.             case 'commercial': // Commerciale
  368.                 return $this->render('role/user/index.html.twig');
  369.                 break;
  370.             default: break;
  371.         }
  372.     }
  374.     /**
  375.      * @Route("/ticket-tab-ricarica/{tab}", name="user_index_ticket_tab_refresh")
  376.      */
  377.     public function userIndexTicketTabRefresh(Request $request, $tab)
  378.     {    
  379.         $em = $this->mr->getManager('slave');
  380.         switch($tab){
  381.             case 'waiting_for_material':
  382.                 $icon = 'icon-truck-loading';
  383.                 $text = 'In attesa di materiale ('.sizeof($em->getRepository('App\Entity\Slave\Ticket')->findWaitingForMaterial()).')';
  384.                 break;
  385.             default: break;
  386.         }
  387.         return $this->render('components/twig/index/tab_label.html.twig', ['icon' => $icon, 'text' => $text]);
  388.     }
  390.     /**
  391.      * @Route("/materiale-mancante-ricarica", name="user_index_ticket_unlock_refresh")
  392.      */
  393.     public function userIndexTicketUnlockRefresh(Request $request)
  394.     {    
  395.         $em = $this->mr->getManager('slave');
  396.         $ticketWaitingForMaterial = $em->getRepository('App\Entity\Slave\Ticket')->findWaitingForMaterial();
  397.         return $this->render('components/twig/index/ticket_waiting.html.twig', ['ticketWaitingForMaterial' => $ticketWaitingForMaterial]);
  398.     }
  399.         
  400.     /**
  401.      * @Route("/tecnico-ricerca-reindirizza", name="user_search_redirect")
  402.      */
  403.     public function userSearchRedirect(Request $request)
  404.     {    
  405.         $em = $this->mr->getManager('slave');
  406.         $session = $request->getSession();
  407.         $type = $request->request->get('type');
  409.         switch($type){
  410.             case 'ticket':
  411.                 $session->set('numberOrTermid', $request->request->get('number'));
  412.                 return $this->redirectToRoute('user_ticket_list');
  413.                 break;
  414.             case 'product': 
  415.                 $session->set('codeProducer', $request->request->get('codeProducer'));
  416.                 $session->set('codeSupplier', $request->request->get('codeSupplier'));                
  417.                 return $this->redirectToRoute('user_product_search');
  418.                 break;
  419.             case 'client': 
  420.                 $session->set('clientNickname', $request->request->get('clientNickname'));
  421.                 $session->set('clientPhone', $request->request->get('clientPhone'));                
  422.                 return $this->redirectToRoute('user_anagraphic_clients');
  423.                 break;
  424.             default: break;
  425.         }
  426.     }
  427.     
  428.     /**
  429.      * @Route("/impostazioni", name="user_settings")
  430.      */
  431.     public function userSettings(Request $request, FormFactoryInterface $formFactory, ValidatorInterface $validator)
  432.     {    
  433.         $em = $this->mr->getManager('slave');
  434.         $settings = $em->getRepository('App\Entity\Slave\Setting')->findAll();
  436.         $settingsModel = new Settings();
  437.         $formSettings = $formFactory->createNamed("form_settings", SettingsType::class, $settingsModel);
  438.         $formSettings->handleRequest($request);
  440.         if($formSettings->isSubmitted()){
  442.             $valid = ValidationService::ValidateNotBlank($validator, $formSettings->get('daysStationary'));
  443.             if($valid) $valid = ValidationService::ValidateNotBlank($validator, $formSettings->get('ticketTechnicianMinutesTakeCharge'));
  444.             if($valid) $valid = ValidationService::ValidateNotBlank($validator, $formSettings->get('ticketSuspensionAgencyEmail'));
  445.             if($valid) $valid = ValidationService::ValidateNotBlank($validator, $formSettings->get('ticketUAVAgencyEmail'));
  446.             if($valid) $valid = ValidationService::validateMultipleEmailString($validator, $formSettings->get('ticketSuspensionAgencyEmail'), '/\,/');
  447.             if($valid) $valid = ValidationService::validateMultipleEmailString($validator, $formSettings->get('ticketUAVAgencyEmail'), '/\,/');
  448.             
  449.             if($valid && $formSettings->isValid()){
  450.                 foreach($settings as $s){
  451.                     switch($s->getSlug()){
  452.                         case 'warehouse_register_stock': $s->setValue($formSettings->get('warehouseRegisterStock')->getData()); break;
  453.                         case 'warehouse_recover_stock': $s->setValue($formSettings->get('warehouseRecoverStock')->getData()); break;
  454.                         case 'warehouse_technician_product_conditions': 
  455.                             $first = true;
  456.                             $stringConditions = '';
  457.                             foreach($formSettings->get('warehouseTechnicianProductConditions')->getData() as $pc){
  458.                                 if($first) $first = false; else $stringConditions.= ',';
  459.                                 $stringConditions.= $pc->getId();
  460.                             }
  461.                             $s->setValue($stringConditions);
  462.                             break;
  463.                         case 'use_ddt': $s->setValue($formSettings->get('useDdt')->getData()); break;
  464.                         case 'ddt_internal_mandatory': $s->setValue($formSettings->get('ddtInternalMandatory')->getData()); break;
  465.                         case 'days_stationary': $s->setValue($formSettings->get('daysStationary')->getData()); break;
  466.                         case 'ticket_suspension_agency_email': $s->setValue($formSettings->get('ticketSuspensionAgencyEmail')->getData()); break;
  467.                         case 'ticket_uav_agency_email': $s->setValue($formSettings->get('ticketUAVAgencyEmail')->getData()); break;
  468.                         case 'ticket_auto_assign': $s->setValue($formSettings->get('ticketAutoAssign')->getData());  break;
  469.                         case 'ticket_auto_operation_tariff_amount': $s->setValue($formSettings->get('ticketAutoOperationTariffAmount')->getData()); break;
  470.                         case 'ticket_backoffice_manage': $s->setValue($formSettings->get('ticketBackofficeManage')->getData()); break;
  471.                         case 'ticket_technician_send_cancel_email': $s->setValue($formSettings->get('ticketTechnicianSendCancelEmail')->getData()); break;
  472.                         case 'ticket_technician_minutes_take_charge': $s->setValue($formSettings->get('ticketTechnicianMinutesTakeCharge')->getData()); break;
  473.                         case 'ticket_suspension_unlock_same_technician': $s->setValue($formSettings->get('ticketSuspensionUnlockSameTechnician')->getData()); break;
  474.                         case 'ticket_suspension_unlock_by_technician': $s->setValue($formSettings->get('ticketSuspensionUnlockByTechnician')->getData()); break;
  475.                         case 'product_model_default_stock_active': $s->setValue($formSettings->get('productModelDefaultStockActive')->getData()); break;
  476.                         case 'product_model_default_stock_yellow': $s->setValue($formSettings->get('productModelDefaultStockYellow')->getData()); break;
  477.                         case 'product_model_default_stock_red': $s->setValue($formSettings->get('productModelDefaultStockRed')->getData()); break;
  478.                         case 'use_ddt_number_for_technicians': $s->setValue($formSettings->get('useDdtNumberForTechnicians')->getData()); break;
  479.                         case 'script_sunday_active': $s->setValue($formSettings->get('scriptSundayActive')->getData()); break;
  480.                         case 'outcome_completed_default': $s->setValue($formSettings->get('outcomeCompletedDefault')->getData()->getId()); break;
  481.                         default: break;
  482.                     }
  483.                 }
  484.                 $em->flush();
  486.                 $this->addFlash('notice_success', "Impostazioni aggiornate");
  487.                 return $this->redirectToRoute('user_settings');
  488.             }
  489.         }
  491.         return $this->render('role/user/settings.html.twig', array(
  492.             'settings' => $settings,
  493.             'formSettings' => $formSettings->createView()
  494.         ));
  495.     }
  496.     
  497.     /**
  498.      * @Route("/utility", name="user_utility")
  499.      */
  500.     public function userUtility(Request $request)
  501.     {    
  502.         return $this->render('role/user/utility.html.twig');
  503.     }
  504.     
  505.     /**
  506.      * @Route("/utility/esegui-comando", name="user_utility_execute_command")
  507.      */
  508.     public function userUtilityExecuteCommand(Request $request)
  509.     {    
  510.         switch($request->request->get('command')){
  511.             case 'clear_session':
  512.                 SessionService::resetUserSession($request->getSession());
  513.                 $this->addFlash('notice_success', 'Sessione resettata correttamente!');
  514.                 break;
  515.             default: break;
  516.         }
  517.         return $this->redirectToRoute('user_utility');
  518.     }
  520.     // POST DI AGGIORNAMENTO
  521.         /**
  522.         * @Route("/economico-carica-tab", name="user_economic_tab")
  523.         */
  524.         public function userEconomicTab(Request $request)
  525.         {
  526.             $em = $this->mr->getManager('slave');
  527.             $emMaster = $this->mr->getManager('master');
  528.             $session = $request->getSession();
  529.             $company = $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get("companyId"));
  530.             $month = $request->request->get('month');
  531.             $year = $request->request->get('year');
  532.             $operationGroupsNotUav = $em->getRepository('App\Entity\Slave\OperationGroup')->findBy(['uav' => 0]);
  533.             $operationGroupUav = $em->getRepository('App\Entity\Slave\OperationGroup')->findBy(['uav' => 1]);
  535.             // Se UserId = 0 --> Significa che è l'aziendale
  536.             if($request->request->get('userId') != 0){
  537.                 $user = $em->getRepository('App\Entity\Slave\User')->findOneById($request->request->get('userId'));
  538.                 $allInterventions = $em->getRepository("App\Entity\Slave\Intervention")->findByTechnicianToPayByYearAndMonth($user->getId(), $year, $month);
  539.             }
  540.             else{                
  541.                 $allInterventions = $em->getRepository("App\Entity\Slave\Intervention")->findToPayByYearAndMonth($year, $month);
  542.             }
  544.             // Rimuovo gli interventi che hanno una sospensione -> Gestita e non approvata / Non gestita
  545.             $interventions = array();
  546.             foreach($allInterventions as $int){
  547.                 $toCalculate = true;
  548.                 if($int->getSuspension() != null && ($int->getSuspension()->isManaged() == false || $int->getSuspension()->isApproved() == false))
  549.                     $toCalculate = false;
  551.                 if($toCalculate)
  552.                     array_push($interventions, $int);
  553.             }
  555.             $arrayProvincesIds = array();
  556.             $arrayProvinces = array();
  557.             foreach($interventions as $int){
  558.                 if(!in_array($int->getTicket()->getIdProvince(), $arrayProvincesIds)){
  559.                     array_push($arrayProvincesIds, $int->getTicket()->getIdProvince());
  560.                     array_push($arrayProvinces, $emMaster->getRepository('App\Entity\Master\Province')->findOneById($int->getTicket()->getIdProvince()));
  561.                 }
  562.             }
  564.             $matrixResults = array();
  565.             foreach($arrayProvinces as $province){
  566.                 $arrayRow = array();
  567.                 array_push($arrayRow, $province->getSign());
  569.                 $arrayCells = array();
  570.                 $rowAmount = 0;
  571.                 $rowCount = 0;
  572.                 $cellUavAmount = 0;
  573.                 $cellUavCount = 0;
  575.                 foreach($operationGroupsNotUav as $og){
  576.                     $arrayCell = array();
  577.                     $cellAmount = 0;
  578.                     $cellCount = 0;
  579.                     foreach($interventions as $int){
  580.                         # SE --- gruppo operazione intervento == gruppo operazione ciclo AND id provincia cliente == id provincia ciclo AND provincia ciclo comprende tutti i CAP o se CAP cliente compreso nei CAPS del tecnico
  581.                         if($int->getTicket()->getOperation()->getGroup()->getId() == $og->getId() && $int->getTicket()->getIdProvince() == $province->getId()){
  582.                             # SE completato -> aggiungo
  583.                             if($int->getOutcomeType()->getSlug() == 'completed'){
  584.                                 if($request->request->get('userId') != 0)
  585.                                     $cellAmount += $int->calculateTotalTechnicianAmount();
  586.                                 else
  587.                                     $cellAmount += $int->getAmount();
  588.                                 $cellCount++;
  589.                             }
  590.                             # SE uav -> aggiungo alla colonna finale
  591.                             if($int->getOutcomeType()->getSlug() == 'empty'){
  592.                                 if($request->request->get('userId') != 0)
  593.                                     $cellUavAmount += $int->calculateTotalTechnicianAmount();
  594.                                 else
  595.                                     $cellUavAmount += $int->getAmount();
  596.                                 $cellUavCount++;
  597.                             }
  598.                         }
  599.                     }
  600.                     $rowAmount += $cellAmount;
  601.                     $rowCount += $cellCount;
  602.                     array_push($arrayCell, '[<span class="count_'.$year.'_'.$month.'_'.$og->getId().'">'.$cellCount.'</span>] <span class="amount_'.$year.'_'.$month.'_'.$og->getId().'">'.number_format($cellAmount, 2, '.', '').'</span> €', $og->getId(), $og->getValue());
  603.                     array_push($arrayCells, $arrayCell);
  604.                 }
  605.                 $test = null;
  606.                 foreach($operationGroupUav as $og){
  607.                     $arrayCell = array();
  608.                     array_push($arrayCell, '[<span class="count_'.$year.'_'.$month.'_'.$og->getId().'">'.$cellUavCount.'</span>] <span class="amount_'.$year.'_'.$month.'_'.$og->getId().'">'.number_format($cellUavAmount, 2, '.', '').'</span> €', $og->getId(), $og->getValue());
  609.                     array_push($arrayCells, $arrayCell);
  610.                 }
  611.                 $rowAmount += $cellUavAmount;
  612.                 $rowCount += $cellUavCount;
  613.                 array_push($arrayRow, $arrayCells, '['.$rowCount.'] '.number_format($rowAmount, 2, '.', '').' €');
  614.                 array_push($matrixResults, $arrayRow);
  615.             }
  617.             $response = array("code" => 200, "success" => true, "matrixResults" => $matrixResults);
  618.             return new Response(json_encode($response));
  619.         }
  621.         /**
  622.          * @Route("/economico-aggiorna", name="user_economic_update")
  623.          */
  624.         public function userEconomicUpdate(Request $request)
  625.         {    
  626.             $em = $this->mr->getManager('slave');
  627.             $emMaster = $this->mr->getManager('master');
  628.             $session = $request->getSession();
  629.             $province = $emMaster->getRepository('App\Entity\Master\Province')->findOneBySign($request->request->get('taProvince'));
  630.             $year = $request->request->get('year');
  631.             $month = $request->request->get('month');
  632.             $operationGroupId = $request->request->get("operationGroupId");
  633.             $operationGroup = $em->getRepository('App\Entity\Slave\OperationGroup')->findOneById($operationGroupId);
  635.             // Se UserId = 0 --> Significa che è l'aziendale
  636.             if($request->request->get('userId') != 0){
  637.                 $user = $em->getRepository('App\Entity\Slave\User')->findOneById($request->request->get('userId'));
  638.                 if($operationGroup->isUav())
  639.                     $allInterventions = $em->getRepository('App\Entity\Slave\Intervention')->findByTechnicianProvinceToPayByYearAndMonthUav($user->getId(), $province->getId(), $year, $month);
  640.                 else
  641.                     $allInterventions = $em->getRepository('App\Entity\Slave\Intervention')->findByTechnicianProvinceAndOperationGroupToPayByYearAndMonthNotUav($operationGroupId, $user->getId(), $province->getId(), $year, $month);
  642.             }
  643.             else{
  644.                 if($operationGroup->isUav())
  645.                     $allInterventions = $em->getRepository('App\Entity\Slave\Intervention')->findByProvinceToPayByYearAndMonthUav($province->getId(), $year, $month);
  646.                 else
  647.                     $allInterventions = $em->getRepository('App\Entity\Slave\Intervention')->findByProvinceAndOperationGroupToPayByYearAndMonthNotUav($operationGroupId, $province->getId(), $year, $month);
  648.             }
  650.             // Rimuovo gli interventi che hanno una sospensione -> Gestita e non approvata / Non gestita
  651.             $interventions = array();
  652.             foreach($allInterventions as $int){
  653.                 $toCalculate = true;
  654.                 if($int->getSuspension() != null && ($int->getSuspension()->isManaged() == false || $int->getSuspension()->isApproved() == false))
  655.                     $toCalculate = false;
  657.                 if($toCalculate)
  658.                     array_push($interventions, $int);
  659.             }
  661.             # Creo JSON
  662.             $first = true;
  663.             $json = '[';
  664.             foreach($interventions as $int){
  665.                 if($first) $first = false; else $json.= ',';
  666.                 $tableActivities = '---';
  667.                 if(sizeof($int->getActivities()) > 0){
  668.                     $tableActivities = '<table class=\'table table_no_padding b_none m_b_none\'>';
  669.                     foreach($int->getActivities() as $act){
  670.                         if($act->getProductWithdraw() != null) 
  671.                             $tableActivities .= '<tr><th>Ritiro: '.$act->getType().'</th></tr><tr><td>'.$act->getProductWithdraw()->toStringShort().'</td></tr>';
  672.                         else{
  673.                             if($act->getProducerWithdraw() != null)
  674.                                 $tableActivities .= '<tr><th>Ritiro: </th></tr><tr><td>'.$act->getProducerWithdraw().'</td></tr>';
  675.                         }
  676.                         if($act->getProductActual() != null) 
  677.                             $tableActivities .= '<tr><th>Attuale: '.$act->getType().'</th></tr><tr><td>'.$act->getProductActual()->toStringShort().'</td></tr>';
  678.                         else{
  679.                             if($act->getProducerActual() != null)
  680.                                 $tableActivities .= '<tr><th>Attuale: </th></tr><tr><td>'.$act->getProducerActual().'</td></tr>';
  681.                         }
  682.                         if($act->getProductInstallation() != null) 
  683.                             $tableActivities .= '<tr><th>Installato: '.$act->getType().'</th></tr><tr><td>'.$act->getProductInstallation()->toStringShort().'</td></tr>';
  684.                         else{
  685.                             if($act->getProducerInstallation() != null)
  686.                                 $tableActivities .= '<tr><th>Installato: </th></tr><tr><td>'.$act->getProducerInstallation().'</td></tr>';
  687.                         }
  688.                     }
  689.                     $tableActivities.= '</table>';
  690.                 }
  691.                 if($request->request->get('userId') != 0)
  692.                     $tot = $int->calculateTechnicianAmount();
  693.                 else
  694.                     $tot = $int->getAmount();
  696.                 $tableAmounts = '<table class=\'table table_no_padding b_none m_b_none\'><tr><td class=\'td_w_30p txt_a_c\'>'.number_format($tot, 2, '.', '').'</td><td class=\'td_w_30p txt_a_c\'>'.number_format($int->calculateExtraAmount(), 2, '.', '').'</td></tr></table>';
  698.                 $termid = '';
  699.                 if($int->getTicket()->getTermid() != null)
  700.                     $termid = $int->getTicket()->getTermid()->getCode();
  701.                 $json.= '{
  702.                     "id":"'.$int->getId().'", 
  703.                     "datetime":"'.$int->getDatetime()->format('d-m-Y H:i').'", 
  704.                     "client":"'.$int->getTicket()->getClient()->__toString().'", 
  705.                     "termid":"'.$termid.'", 
  706.                     "ticket":"'.$int->getTicket()->getNumber().'",
  707.                     "outcome":"'.$int->getOutcome()->getValue().'", 
  708.                     "activities":"'.$tableActivities.'",
  709.                     "amounts":"'.$tableAmounts.'"
  710.                 }';
  711.             }
  712.             $json .= ']';
  714.             return new Response(json_encode(array("code" => 200, "success" => true, "interventions" => $json, "provinceId" => $province->getId()))); 
  715.         }
  716.         
  717.         /**
  718.         * @Route("/economico-aziendale-carica-tab", name="user_company_economic_tab")
  719.         */
  720.         public function userCompanyEconomicTab(Request $request)
  721.         {
  722.             $em = $this->mr->getManager('slave');
  723.             $emMaster = $this->mr->getManager('master');
  724.             $session = $request->getSession();
  725.             $company = $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get("companyId"));
  726.             $month = $request->request->get('month');
  727.             $year = $request->request->get('year');
  728.             $operationGroupsNotUav = $em->getRepository('App\Entity\Slave\OperationGroup')->findBy(['uav' => 0]);
  729.             $operationGroupUav = $em->getRepository('App\Entity\Slave\OperationGroup')->findBy(['uav' => 1]);
  730.             $allInterventions = $em->getRepository("App\Entity\Slave\Intervention")->findToPayByYearAndMonth($year, $month);
  732.             // Rimuovo gli interventi che hanno una sospensione -> Gestita e non approvata / Non gestita
  733.             $interventions = array();
  734.             foreach($allInterventions as $int){
  735.                 $toCalculate = true;
  736.                 if($int->getSuspension() != null && ($int->getSuspension()->isManaged() == false || $int->getSuspension()->isApproved() == false))
  737.                     $toCalculate = false;
  739.                 if($toCalculate)
  740.                     array_push($interventions, $int);
  741.             }
  743.             $arrayTechniciansIds = array();
  744.             $arrayTechnicians = array();
  745.             foreach($interventions as $int){
  746.                 if(!in_array($int->getTechnician()->getId(), $arrayTechniciansIds)){
  747.                     array_push($arrayTechniciansIds, $int->getTechnician()->getId());
  748.                     array_push($arrayTechnicians, $em->getRepository('App\Entity\Slave\User')->findOneById($int->getTechnician()->getId()));
  749.                 }
  750.             }
  752.             $matrixResults = array();
  753.             foreach($arrayTechnicians as $technician){
  754.                 $arrayRow = array();
  755.                 array_push($arrayRow, [$technician->getId(), $technician->getNameShort()]);
  757.                 $arrayCells = array();
  758.                 $rowAmount = 0;
  759.                 $rowCount = 0;
  760.                 $cellUavAmount = 0;
  761.                 $cellUavCount = 0;
  763.                 foreach($operationGroupsNotUav as $og){
  764.                     $arrayCell = array();
  765.                     $cellAmount = 0;
  766.                     $cellCount = 0;
  767.                     foreach($interventions as $int){
  768.                         # SE --- gruppo operazione intervento == gruppo operazione ciclo AND id provincia cliente == id provincia ciclo AND tecnico ciclo
  769.                         if($int->getTicket()->getOperation()->getGroup()->getId() == $og->getId() && $int->getTechnician()->getId() == $technician->getId()){
  770.                             # SE completato -> aggiungo
  771.                             if($int->getOutcomeType()->getSlug() == 'completed'){
  772.                                 $cellAmount += $int->getAmount();
  773.                                 $cellCount++;
  774.                             }
  775.                             # SE uav -> aggiungo alla colonna finale
  776.                             if($int->getOutcomeType()->getSlug() == 'empty'){
  777.                                 $cellUavAmount += $int->getAmount();
  778.                                 $cellUavCount++;
  779.                             }
  780.                         }
  781.                     }
  782.                     $rowAmount += $cellAmount;
  783.                     $rowCount += $cellCount;
  784.                     array_push($arrayCell, '[<span class="count_c_'.$year.'_'.$month.'_'.$og->getId().'">'.$cellCount.'</span>] <span class="amount_c_'.$year.'_'.$month.'_'.$og->getId().'">'.number_format($cellAmount, 2, '.', '').'</span> €', $og->getId(), $og->getValue());
  785.                     array_push($arrayCells, $arrayCell);
  786.                 }
  787.                 $test = null;
  788.                 foreach($operationGroupUav as $og){
  789.                     $arrayCell = array();
  790.                     array_push($arrayCell, '[<span class="count_c_'.$year.'_'.$month.'_'.$og->getId().'">'.$cellUavCount.'</span>] <span class="amount_c_'.$year.'_'.$month.'_'.$og->getId().'">'.number_format($cellUavAmount, 2, '.', '').'</span> €', $og->getId(), $og->getValue());
  791.                     array_push($arrayCells, $arrayCell);
  792.                 }
  793.                 $rowAmount += $cellUavAmount;
  794.                 $rowCount += $cellUavCount;
  795.                 array_push($arrayRow, $arrayCells, '['.$rowCount.'] '.number_format($rowAmount, 2, '.', '').' €');
  796.                 array_push($matrixResults, $arrayRow);
  797.             }
  799.             $response = array("code" => 200, "success" => true, "matrixResults" => $matrixResults);
  800.             return new Response(json_encode($response));
  801.         }
  804.         /**
  805.          * @Route("/economico-aziendale-aggiorna", name="user_company_economic_update")
  806.          */
  807.         public function userCompanyEconomicUpdate(Request $request)
  808.         {    
  809.             $em = $this->mr->getManager('slave');
  810.             $emMaster = $this->mr->getManager('master');
  811.             $session = $request->getSession();
  812.             $user = $em->getRepository('App\Entity\Slave\User')->findOneById($request->request->get('userId'));
  813.             $year = $request->request->get('year');
  814.             $month = $request->request->get('month');
  815.             $operationGroupId = $request->request->get("operationGroupId");
  816.             $operationGroup = $em->getRepository('App\Entity\Slave\OperationGroup')->findOneById($operationGroupId);
  818.             if($operationGroup->isUav())
  819.                 $allInterventions = $em->getRepository('App\Entity\Slave\Intervention')->findByTechnicianToPayByYearAndMonthUav($user->getId(), $year, $month);
  820.             else
  821.                 $allInterventions = $em->getRepository('App\Entity\Slave\Intervention')->findByTechnicianAndOperationGroupToPayByYearAndMonthNotUav($operationGroupId, $user->getId(), $year, $month);
  823.             // Rimuovo gli interventi che hanno una sospensione -> Gestita e non approvata / Non gestita
  824.             $interventions = array();
  825.             foreach($allInterventions as $int){
  826.                 $toCalculate = true;
  827.                 if($int->getSuspension() != null && ($int->getSuspension()->isManaged() == false || $int->getSuspension()->isApproved() == false))
  828.                     $toCalculate = false;
  830.                 if($toCalculate)
  831.                     array_push($interventions, $int);
  832.             }
  834.             # Creo JSON
  835.             $first = true;
  836.             $json = '[';
  837.             foreach($interventions as $int){
  838.                 if($first) $first = false; else $json.= ',';
  839.                 $tableActivities = '---';
  840.                 if(sizeof($int->getActivities()) > 0){
  841.                     $tableActivities = '<table class=\'table table_no_padding b_none m_b_none\'>';
  842.                     foreach($int->getActivities() as $act){
  843.                         if($act->getProductWithdraw() != null) 
  844.                             $tableActivities .= '<tr><th>Ritiro: '.$act->getType().'</th></tr><tr><td>'.$act->getProductWithdraw()->toStringShort().'</td></tr>';
  845.                         else{
  846.                             if($act->getProducerWithdraw() != null)
  847.                                 $tableActivities .= '<tr><th>Ritiro: </th></tr><tr><td>'.$act->getProducerWithdraw().'</td></tr>';
  848.                         }
  849.                         if($act->getProductActual() != null) 
  850.                             $tableActivities .= '<tr><th>Attuale: '.$act->getType().'</th></tr><tr><td>'.$act->getProductActual()->toStringShort().'</td></tr>';
  851.                         else{
  852.                             if($act->getProducerActual() != null)
  853.                                 $tableActivities .= '<tr><th>Attuale: </th></tr><tr><td>'.$act->getProducerActual().'</td></tr>';
  854.                         }
  855.                         if($act->getProductInstallation() != null) 
  856.                             $tableActivities .= '<tr><th>Installato: '.$act->getType().'</th></tr><tr><td>'.$act->getProductInstallation()->toStringShort().'</td></tr>';
  857.                         else{
  858.                             if($act->getProducerInstallation() != null)
  859.                                 $tableActivities .= '<tr><th>Installato: </th></tr><tr><td>'.$act->getProducerInstallation().'</td></tr>';
  860.                         }
  861.                     }
  862.                     $tableActivities.= '</table>';
  863.                 }
  864.                 $tableAmounts = '<table class=\'table table_no_padding b_none m_b_none\'><tr><td class=\'td_w_30p txt_a_c\'>'.number_format($int->getAmount(), 2, '.', '').'</td><td class=\'td_w_30p txt_a_c\'>'.number_format($int->calculateExtraAmount(), 2, '.', '').'</td></tr></table>';
  866.                 $termid = '';
  867.                 if($int->getTicket()->getTermid() != null)
  868.                     $termid = $int->getTicket()->getTermid()->getCode();
  869.                 $json.= '{
  870.                     "id":"'.$int->getId().'", 
  871.                     "datetime":"'.$int->getDatetime()->format('d-m-Y H:i').'", 
  872.                     "client":"'.$int->getTicket()->getClient()->__toString().'", 
  873.                     "termid":"'.$termid.'", 
  874.                     "ticket":"'.$int->getTicket()->getNumber().'",
  875.                     "outcome":"'.$int->getOutcome()->getValue().'", 
  876.                     "activities":"'.$tableActivities.'",
  877.                     "amounts":"'.$tableAmounts.'"
  878.                 }';
  879.             }
  880.             $json .= ']';
  882.             return new Response(json_encode(array("code" => 200, "success" => true, "interventions" => $json))); 
  883.         }
  885.         
  886.         /**
  887.         * @Route("/economico-fornitori-carica-tab", name="user_supplier_economic_tab")
  888.         */
  889.         public function userSupplierEconomicTab(Request $request)
  890.         {
  891.             $em = $this->mr->getManager('slave');
  892.             $emMaster = $this->mr->getManager('master');
  893.             $session = $request->getSession();
  894.             $company = $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get("companyId"));
  895.             $month = $request->request->get('month');
  896.             $year = $request->request->get('year');
  897.             $operationGroupsNotUav = $em->getRepository('App\Entity\Slave\OperationGroup')->findBy(['uav' => 0]);
  898.             $operationGroupUav = $em->getRepository('App\Entity\Slave\OperationGroup')->findBy(['uav' => 1]);
  899.             $allInterventions = $em->getRepository("App\Entity\Slave\Intervention")->findToPayByYearAndMonth($year, $month);
  901.             // Rimuovo gli interventi che hanno una sospensione -> Gestita e non approvata / Non gestita
  902.             $interventions = array();
  903.             foreach($allInterventions as $int){
  904.                 $toCalculate = true;
  905.                 if($int->getSuspension() != null && ($int->getSuspension()->isManaged() == false || $int->getSuspension()->isApproved() == false))
  906.                     $toCalculate = false;
  908.                 if($toCalculate)
  909.                     array_push($interventions, $int);
  910.             }
  912.             $arraySuppliersIds = array();
  913.             $arraySuppliers = array();
  914.             foreach($interventions as $int){
  915.                 if(!in_array($int->getTicket()->getSupplier()->getId(), $arraySuppliersIds)){
  916.                     array_push($arraySuppliersIds, $int->getTicket()->getSupplier()->getId());
  917.                     array_push($arraySuppliers, $em->getRepository('App\Entity\Slave\Supplier')->findOneById($int->getTicket()->getSupplier()->getId()));
  918.                 }
  919.             }
  921.             $matrixResults = array();
  922.             foreach($arraySuppliers as $supplier){
  923.                 $arrayRow = array();
  924.                 array_push($arrayRow, [$supplier->getId(), $supplier->getName()]);
  926.                 $arrayCells = array();
  927.                 $rowAmount = 0;
  928.                 $rowCount = 0;
  929.                 $cellUavAmount = 0;
  930.                 $cellUavCount = 0;
  932.                 foreach($operationGroupsNotUav as $og){
  933.                     $arrayCell = array();
  934.                     $cellAmount = 0;
  935.                     $cellCount = 0;
  936.                     foreach($interventions as $int){
  937.                         # SE --- gruppo operazione intervento == gruppo operazione ciclo AND id provincia cliente == id provincia ciclo AND tecnico ciclo
  938.                         if($int->getTicket()->getOperation()->getGroup()->getId() == $og->getId() && $int->getTicket()->getSupplier()->getId() == $supplier->getId()){
  939.                             # SE completato -> aggiungo
  940.                             if($int->getOutcomeType()->getSlug() == 'completed'){
  941.                                 $cellAmount += $int->getAmount();
  942.                                 $cellCount++;
  943.                             }
  944.                             # SE uav -> aggiungo alla colonna finale
  945.                             if($int->getOutcomeType()->getSlug() == 'empty'){
  946.                                 $cellUavAmount += $int->getAmount();
  947.                                 $cellUavCount++;
  948.                             }
  949.                         }
  950.                     }
  951.                     $rowAmount += $cellAmount;
  952.                     $rowCount += $cellCount;
  953.                     array_push($arrayCell, '[<span class="count_s_'.$year.'_'.$month.'_'.$og->getId().'">'.$cellCount.'</span>] <span class="amount_s_'.$year.'_'.$month.'_'.$og->getId().'">'.number_format($cellAmount, 2, '.', '').'</span> €', $og->getId(), $og->getValue());
  954.                     array_push($arrayCells, $arrayCell);
  955.                 }
  956.                 $test = null;
  957.                 foreach($operationGroupUav as $og){
  958.                     $arrayCell = array();
  959.                     array_push($arrayCell, '[<span class="count_s_'.$year.'_'.$month.'_'.$og->getId().'">'.$cellUavCount.'</span>] <span class="amount_s_'.$year.'_'.$month.'_'.$og->getId().'">'.number_format($cellUavAmount, 2, '.', '').'</span> €', $og->getId(), $og->getValue());
  960.                     array_push($arrayCells, $arrayCell);
  961.                 }
  962.                 $rowAmount += $cellUavAmount;
  963.                 $rowCount += $cellUavCount;
  964.                 array_push($arrayRow, $arrayCells, '['.$rowCount.'] '.number_format($rowAmount, 2, '.', '').' €');
  965.                 array_push($matrixResults, $arrayRow);
  966.             }
  968.             $response = array("code" => 200, "success" => true, "matrixResults" => $matrixResults);
  969.             return new Response(json_encode($response));
  970.         }
  972.         /**
  973.          * @Route("/economico-fornitori-aggiorna", name="user_supplier_economic_update")
  974.          */
  975.         public function userSupplierEconomicUpdate(Request $request)
  976.         {    
  977.             $em = $this->mr->getManager('slave');
  978.             $emMaster = $this->mr->getManager('master');
  979.             $session = $request->getSession();
  980.             $supplier = $em->getRepository('App\Entity\Slave\Supplier')->findOneById($request->request->get('supplierId'));
  981.             $year = $request->request->get('year');
  982.             $month = $request->request->get('month');
  983.             $operationGroupId = $request->request->get("operationGroupId");
  984.             $operationGroup = $em->getRepository('App\Entity\Slave\OperationGroup')->findOneById($operationGroupId);
  986.             if($operationGroup->isUav())
  987.                 $allInterventions = $em->getRepository('App\Entity\Slave\Intervention')->findBySupplierToPayByYearAndMonthUav($supplier->getId(), $year, $month);
  988.             else
  989.                 $allInterventions = $em->getRepository('App\Entity\Slave\Intervention')->findBySupplierAndOperationGroupToPayByYearAndMonthNotUav($operationGroupId, $supplier->getId(), $year, $month);
  991.             // Rimuovo gli interventi che hanno una sospensione -> Gestita e non approvata / Non gestita
  992.             $interventions = array();
  993.             foreach($allInterventions as $int){
  994.                 $toCalculate = true;
  995.                 if($int->getSuspension() != null && ($int->getSuspension()->isManaged() == false || $int->getSuspension()->isApproved() == false))
  996.                     $toCalculate = false;
  998.                 if($toCalculate)
  999.                     array_push($interventions, $int);
  1000.             }
  1002.             # Creo JSON
  1003.             $first = true;
  1004.             $json = '[';
  1005.             foreach($interventions as $int){
  1006.                 if($first) $first = false; else $json.= ',';
  1007.                 $tableActivities = '---';
  1008.                 if(sizeof($int->getActivities()) > 0){
  1009.                     $tableActivities = '<table class=\'table table_no_padding b_none m_b_none\'>';
  1010.                     foreach($int->getActivities() as $act){
  1011.                         if($act->getProductWithdraw() != null) 
  1012.                             $tableActivities .= '<tr><th>Ritiro: '.$act->getType().'</th></tr><tr><td>'.$act->getProductWithdraw()->toStringShort().'</td></tr>';
  1013.                         else{
  1014.                             if($act->getProducerWithdraw() != null)
  1015.                                 $tableActivities .= '<tr><th>Ritiro: </th></tr><tr><td>'.$act->getProducerWithdraw().'</td></tr>';
  1016.                         }
  1017.                         if($act->getProductActual() != null) 
  1018.                             $tableActivities .= '<tr><th>Attuale: '.$act->getType().'</th></tr><tr><td>'.$act->getProductActual()->toStringShort().'</td></tr>';
  1019.                         else{
  1020.                             if($act->getProducerActual() != null)
  1021.                                 $tableActivities .= '<tr><th>Attuale: </th></tr><tr><td>'.$act->getProducerActual().'</td></tr>';
  1022.                         }
  1023.                         if($act->getProductInstallation() != null) 
  1024.                             $tableActivities .= '<tr><th>Installato: '.$act->getType().'</th></tr><tr><td>'.$act->getProductInstallation()->toStringShort().'</td></tr>';
  1025.                         else{
  1026.                             if($act->getProducerInstallation() != null)
  1027.                                 $tableActivities .= '<tr><th>Installato: </th></tr><tr><td>'.$act->getProducerInstallation().'</td></tr>';
  1028.                         }
  1029.                     }
  1030.                     $tableActivities.= '</table>';
  1031.                 }
  1032.                 $tableAmounts = '<table class=\'table table_no_padding b_none m_b_none\'><tr><td class=\'td_w_30p txt_a_c\'>'.number_format($int->getAmount(), 2, '.', '').'</td><td class=\'td_w_30p txt_a_c\'>'.number_format($int->calculateExtraAmount(), 2, '.', '').'</td></tr></table>';
  1034.                 $termid = '';
  1035.                 if($int->getTicket()->getTermid() != null)
  1036.                     $termid = $int->getTicket()->getTermid()->getCode();
  1037.                 $json.= '{
  1038.                     "id":"'.$int->getId().'", 
  1039.                     "datetime":"'.$int->getDatetime()->format('d-m-Y H:i').'", 
  1040.                     "client":"'.$int->getTicket()->getClient()->__toString().'", 
  1041.                     "termid":"'.$termid.'", 
  1042.                     "ticket":"'.$int->getTicket()->getNumber().'",
  1043.                     "outcome":"'.$int->getOutcome()->getValue().'", 
  1044.                     "activities":"'.$tableActivities.'",
  1045.                     "amounts":"'.$tableAmounts.'"
  1046.                 }';
  1047.             }
  1048.             $json .= ']';
  1050.             return new Response(json_encode(array("code" => 200, "success" => true, "interventions" => $json))); 
  1051.         }
  1053.         /**
  1054.          * @Route("/provincia-cap", name="user_province_zips")
  1055.          */
  1056.         public function userProvinceZips(Request $request)
  1057.         {    
  1058.             $em = $this->mr->getManager('slave');
  1059.             $emMaster = $this->mr->getManager('master');
  1060.             $province = $emMaster->getRepository('App\Entity\Master\Province')->findOneById($request->request->get("provinceId"));
  1061.             $zips = $emMaster->getRepository('App\Entity\Master\Zip')->findAllByProvince($province->getId());
  1063.             $operationTariffs = $em->getRepository('App\Entity\Slave\OperationTariff')->findByIdProvince($province->getId());
  1065.             $first = true;
  1066.             $json = "[";
  1067.             foreach($zips as $zip){
  1068.                 if($first) $first = false; else $json.= ',';
  1069.                 $enabled = 0;
  1070.                 foreach($operationTariffs as $ot){
  1071.                     // SE TUTTI I CAP DELLA PROVINCIA --> ENABLED = 1
  1072.                     if($ot->isAllZip())
  1073.                         $enabled = 1;
  1074.                     else{
  1075.                         // SE TUTTI IL CAP E TRA QUELLI DELLA TARIFFA --> ENABLED = 1
  1076.                         foreach($ot->getZips() as $otZip)
  1077.                             if($otZip[1] == $zip->getCode())
  1078.                                 $enabled = 1;
  1079.                     }
  1080.                 }
  1081.                 $json.= '{"id":'.$zip->getId().', "value":"'.$zip->displayCodeAndCities().'", "enabled":'.$enabled.'}';
  1082.             }
  1083.             $json.= "]";
  1084.         
  1085.             return new Response(json_encode(array("code" => 200, "success" => true, "zips" => $json))); 
  1086.         }
  1088.         /**
  1089.          * @Route("/aggiorna-produttore-modelli", name="user_update_producer_models")
  1090.          */
  1091.         public function userUpdateProducerModels(Request $request)
  1092.         {    
  1093.             $em = $this->mr->getManager('slave');
  1094.             $producer = $em->getRepository('App\Entity\Slave\Producer')->findOneById($request->request->get("producerId"));
  1095.             $models = $em->getRepository('App\Entity\Slave\ProductModel')->findByProducerOrdered($producer->getId());
  1097.             $first = true;
  1098.             $json = "[";
  1099.             foreach($models as $model){
  1100.                 if($first) $first = false; else $json.= ',';
  1101.                 $json.= '{"id":'.$model->getId().', "name":"'.$model->getName().'"}';
  1102.             }
  1103.             $json.= "]";
  1104.         
  1105.             return new Response(json_encode(array("code" => 200, "success" => true, "models" => $json))); 
  1106.         }
  1107.         
  1108.         /**
  1109.          * @Route("/aggiorna-modello-fornitori", name="user_update_model_suppliers")
  1110.          */
  1111.         public function userUpdateModelSuppliers(Request $request)
  1112.         {    
  1113.             $em = $this->mr->getManager('slave');
  1114.             $model = $em->getRepository('App\Entity\Slave\ProductModel')->findOneById($request->request->get("modelId"));
  1115.             $suppliers = $em->getRepository('App\Entity\Slave\Supplier')->findByModelOrdered($model->getId());
  1117.             $first = true;
  1118.             $json = "[";
  1119.             foreach($suppliers as $supplier){
  1120.                 if($first) $first = false; else $json.= ',';
  1121.                 $json.= '{"id":'.$supplier->getId().', "name":"'.$supplier->getName().'"}';
  1122.             }
  1123.             $json.= "]";
  1124.         
  1125.             return new Response(json_encode(array("code" => 200, "success" => true, "suppliers" => $json))); 
  1126.         }
  1127.         
  1128.         /**
  1129.          * @Route("/aggiorna-modelli-sottocategorie", name="user_product_model_update_subcategory")
  1130.          */
  1131.         public function userProductModelUpdateSubcategories(Request $request)
  1132.         {
  1133.             $em = $this->mr->getManager('slave');
  1134.             if($request->request->get('categoryId') != null){
  1135.                 $category = $em->getRepository("App\Entity\Slave\ProductCategory")->findOneById($request->request->get('categoryId'));
  1136.                 $subcategories = $category->getSubcategories();
  1137.             }
  1138.             else{
  1139.                 $subcategories = $em->getRepository("App\Entity\Slave\ProductSubcategory")->findAll();
  1140.             }
  1142.             $first = true;
  1143.             $json = '[';
  1144.             foreach($subcategories as $s){
  1145.                 if($first) $first = false; else $json.= ',';
  1146.                 $json.= '{"id":"'.$s->getId().'", "name":'.json_encode($s->getName()).'}';
  1147.             }
  1148.             $json .= ']';
  1150.             $response = array("code" => 200, "success" => true, "subcategories" => $json, 'isPos' => $category->isPos());
  1151.             return new Response(json_encode($response));
  1152.         }
  1153.         
  1154.         /**
  1155.          * @Route("/controlla-prodotto-matricole", name="user_check_product_codes")
  1156.          */
  1157.         public function userCheckProductCodes(Request $request)
  1158.         {    
  1159.             $em = $this->mr->getManager('slave');
  1160.             $code = $request->request->get("code");
  1161.             $type = $request->request->get("type");
  1162.             $msg = null;
  1163.             $product = null;
  1165.             switch($type){
  1166.                 case 'producer': $product = $em->getRepository('App\Entity\Slave\Product')->findOneBy(array('codeProducer' => $code)); break;
  1167.                 case 'supplier': $product = $em->getRepository('App\Entity\Slave\Product')->findOneBy(array('codeSupplier' => $code)); break;
  1168.                 default: break;
  1169.             }
  1171.             $found = false;
  1172.             if($product != null){
  1173.                 $found = true;
  1174.                 $msg = "Il prodotto risulta già registrato nella piattaforma ecco i dettagli<br>".$product->getDisplayConflict()."<strong>Magazzino</strong>: ".$product->getActualWarehouse().".";
  1175.             }
  1176.         
  1177.             return new Response(json_encode(array("code" => 200, "success" => true, "found" => $found, 'msg' => $msg))); 
  1178.         }
  1180.         /**
  1181.          * @Route("/aggiorna-codici-interni-modelli", name="user_update_internal_code_models")
  1182.          */
  1183.         public function userUpdateInternalCodeModels(Request $request)
  1184.         {    
  1185.             $em = $this->mr->getManager('slave');
  1186.             $models = $em->getRepository('App\Entity\Slave\ProductModel')->findByInternalCodeNullOrEmpty();
  1187.             foreach($models as $m){
  1188.                 $m->setInternalCode(UtilitiesService::generateModelInternalCode($m->getId()));
  1189.             }
  1190.             $em->flush();
  1191.             $this->addFlash('notice_success', 'Codici aggiornati');
  1192.             return $this->redirectToRoute('user_index');
  1193.         }      
  1194.         
  1195.         /**
  1196.          * @Route("/aggiorna-modelli-consentiti-per-fornitore", name="user_available_product_models_by_supplier_updates")
  1197.          */
  1198.         public function userAvailableProductModelsBySupplierUpdates(Request $request)
  1199.         {
  1200.             $em = $this->mr->getManager('slave');
  1201.             $supplierId = $request->request->get('supplierId');
  1202.             $values = $em->getRepository('App\Entity\Slave\ProductModel')->findAllowedModelsBySupplier($supplierId);
  1204.             $first = true;
  1205.             $json = "[";
  1206.             foreach($values as $v){
  1207.                 if($first) $first = false; else $json.= ',';
  1208.                 $json.= '{"id":'.$v->getId().', "name":'.json_encode($v->getName()).'}';
  1209.             }
  1210.             $json.= "]";
  1211.         
  1212.             return new Response(json_encode(array("code" => 200, "success" => true, "values" => $json))); 
  1213.         }       
  1214.         
  1215.         /**
  1216.          * @Route("/aggiorna-valori-modello-fornitore", name="user_product_model_name_by_supplier_updates")
  1217.          */
  1218.         public function userProductModelNameBySupplierUpdates(Request $request)
  1219.         {
  1220.             $em = $this->mr->getManager('slave');
  1221.             $name = $request->request->get('modelName');
  1222.             $supplierId = $request->request->get('supplierId');
  1223.             $values = $em->getRepository('App\Entity\Slave\ProductModel')->findByNameOrInternalCodeBySupplier($name, $supplierId);
  1225.             $first = true;
  1226.             $json = "[";
  1227.             foreach($values as $v){
  1228.                 if($first) $first = false; else $json.= ',';
  1229.                 $json.= '{"id":'.$v->getId().', "name":'.json_encode($v->getName()).'}';
  1230.             }
  1231.             $json.= "]";
  1232.         
  1233.             return new Response(json_encode(array("code" => 200, "success" => true, "values" => $json))); 
  1234.         }
  1235.         
  1236.         /**
  1237.          * @Route("/aggiorna-valori-modello", name="user_product_model_name_updates")
  1238.          */
  1239.         public function userProductModelNameUpdates(Request $request)
  1240.         {
  1241.             $em = $this->mr->getManager('slave');
  1242.             $name = $request->request->get('modelName');
  1243.             $values = $em->getRepository('App\Entity\Slave\ProductModel')->findByNameOrInternalCode($name);
  1245.             $first = true;
  1246.             $json = "[";
  1247.             foreach($values as $v){
  1248.                 if($first) $first = false; else $json.= ',';
  1249.                 $json.= '{"id":'.$v->getId().', "name":'.json_encode($v->getName()).'}';
  1250.             }
  1251.             $json.= "]";
  1252.         
  1253.             return new Response(json_encode(array("code" => 200, "success" => true, "values" => $json))); 
  1254.         }
  1255.         
  1256.         /**
  1257.          * @Route("/aggiorna-valori-magazzini", name="user_product_warehouse_nickname_updates")
  1258.          */
  1259.         public function userProductWarehouseNicknameUpdates(Request $request)
  1260.         {
  1261.             $em = $this->mr->getManager('slave');
  1262.             $nickname = $request->request->get('nickname');
  1263.             $termid = $request->request->get('termid');
  1264.             $values = $em->getRepository('App\Entity\Slave\Warehouse')->findLikeNicknameAndTermid($nickname, $termid);
  1266.             $first = true;
  1267.             $json = "[";
  1268.             foreach($values as $v){
  1269.                 if($first) $first = false; else $json.= ',';
  1270.                 $termids = '';
  1271.                 if($v->getClient() != null)
  1272.                     $termids = $v->getClient()->displayTermids('string');
  1273.                 $json.= '{"id":'.$v->getId().', "nickname":'.json_encode($v->getNickname()).', "termids":'.json_encode($termids).'}';
  1274.             }
  1275.             $json.= "]";
  1276.         
  1277.             return new Response(json_encode(array("code" => 200, "success" => true, "values" => $json))); 
  1278.         }
  1280.         /**
  1281.          * @Route("/aggiorna-valori-prodotto", name="user_product_value_updates")
  1282.          */
  1283.         public function userProductValuesUpdate(Request $request)
  1284.         {    
  1285.             $em = $this->mr->getManager('slave');
  1286.             $id = $request->request->get('id');
  1287.             $id2 = $request->request->get('id2');
  1288.             switch($request->request->get('type')){
  1289.                 case 'subcategories': $values = $em->getRepository('App\Entity\Slave\ProductSubcategory')->findByCategoryOrdered($id); break;
  1290.                 case 'producers': $values = $em->getRepository('App\Entity\Slave\Producer')->findBySubcategoryOrdered($id); break;
  1291.                 case 'models': $values = $em->getRepository('App\Entity\Slave\ProductModel')->findByProducerAndSubcategoryOrdered($id, $id2); break;
  1292.                 case 'suppliers': $values = $em->getRepository('App\Entity\Slave\Supplier')->findByModelOrdered($id); break;
  1293.                 default: break;
  1294.             }
  1296.             $first = true;
  1297.             $json = "[";
  1298.             foreach($values as $v){
  1299.                 if($first) $first = false; else $json.= ',';
  1300.                 $json.= '{"id":'.$v->getId().', "name":'.json_encode($v->getName()).'}';
  1301.             }
  1302.             $json.= "]";
  1303.         
  1304.             return new Response(json_encode(array("code" => 200, "success" => true, "values" => $json))); 
  1305.         }
  1307.         /**
  1308.          * @Route("/aggiorna-rigenerati-fornitori", name="user_product_regenerate_suppliers_update")
  1309.          */
  1310.         public function userProductRegenerateSuppliersUpdate(Request $request)
  1311.         {    
  1312.             $em = $this->mr->getManager('slave');
  1313.             $productRegenerated = $em->getRepository('App\Entity\Slave\ProductRegenerated')->findOneById($request->request->get('productRegeneratedId'));
  1314.             $first = true;
  1315.             $json = "[";
  1316.             foreach($productRegenerated->getProduct()->getSuppliers() as $supplier){
  1317.                 if($first) $first = false; else $json.= ',';
  1318.                 $name = $supplier->getName().' ('.$supplier->getAmountRegenerate().' €)';
  1319.                 $json.= '{"id":'.$supplier->getId().', "name":'.json_encode($name).'}';
  1320.             }
  1321.             $json.= "]";
  1323.             return new Response(json_encode(array("code" => 200, "success" => true, "suppliers" => $json, "startDate" => $productRegenerated->getDatetime()->format("d-m-Y")))); 
  1324.         }
  1325.         
  1326.         /**
  1327.          * @Route("/aggiorna-ticket-termid", name="user_ticket_termid_search")
  1328.          */
  1329.         public function userTicketTermidSearch(Request $request)
  1330.         {
  1331.             $em = $this->mr->getManager('slave');
  1332.             $termidCode = $request->request->get('termidCode');
  1333.             $termid = $em->getRepository('App\Entity\Slave\Termid')->findOneBy(array('code' => $termidCode));
  1335.             $json = '{}';
  1336.             $found = false;
  1337.             if($termid != null){
  1338.                 $found = true;
  1339.                 $client = $termid->getClient();
  1340.                 $json = '{"termidId":'.json_encode($termid->getId()).',"clientId":'.json_encode($client->getId()).',"clientCode":'.json_encode($client->getCode()).',"clientName":'.json_encode($client->getName()).',"clientNickname":'.json_encode($client->getNickname()).'}';
  1341.             }
  1342.         
  1343.             return new Response(json_encode(array("code" => 200, "success" => true, "found" => $found, "json" => $json)));
  1344.         }
  1345.         
  1346.         /**
  1347.          * @Route("/aggiorna-ticket-fornitore-operazioni", name="user_ticket_supplier_operations")
  1348.          */
  1349.         public function userTicketSupplierOperations(Request $request)
  1350.         {
  1351.             $em = $this->mr->getManager('slave');
  1352.             if($request->request->get('supplierId') != null){
  1353.                 $supplier = $em->getRepository('App\Entity\Slave\Supplier')->findOneById($request->request->get('supplierId'));
  1354.                 $operations = $supplier->getOperations();
  1355.             }
  1356.             else{
  1357.                 $operations = $em->getRepository('App\Entity\Slave\Operation')->findAll();
  1358.             }
  1360.             $first = true;
  1361.             $json = '[';
  1362.             foreach($operations as $operation){
  1363.                 if($first) $first = false; else $json.= ',';
  1364.                 $json.= '{"id":'.json_encode($operation->getId()).', "name":'.json_encode($operation->__toString()).'}';
  1365.             }
  1366.             $json.= ']';
  1367.         
  1368.             return new Response(json_encode(array("code" => 200, "success" => true, "operations" => $json)));
  1369.         }
  1370.     //
  1371. }