src/Controller/User/UserController.php line 454

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