src/Controller/User/UserController.php line 559

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');
  339.         // In base al tipo di account mostro nella home differenti schermate
  340.         switch($this->getUser()->getAccountTypology()){
  341.             case 'administration': // Amministrazione
  342.             case 'agency': // Agenzia
  343.             case 'commercial': // Commerciale
  344.             case 'warehouse': // Magazzino
  345.                 $operationGroups = $em->getRepository('App\Entity\Slave\OperationGroup')->findAll();
  346.                 $ticketStatuses = $em->getRepository('App\Entity\Slave\TicketStatus')->findAll();
  347.                 $technicians = $em->getRepository('App\Entity\Slave\User')->findTechniciansActive();
  348.                 [$matrixTickets, $matrixTechsTickets, $ticketWithErrors, $ticketSuspensionRequest, $ticketClosedPortal, $ticketWaitingForMaterial, $interventionTariffOut, $interventionWithoutActivities] = $this->calculateTicketAlarms($em, 'agency', $operationGroups, $ticketStatuses, $technicians);
  349.                 $interventionExtras = $em->getRepository('App\Entity\Slave\InterventionExtra')->findBy(array('managed' => false));
  350.                 $ticketReminders = $em->getRepository('App\Entity\Slave\TicketReminder')->findDashboardReminders();
  351.                 $operationsWithoutTariffs = $em->getRepository('App\Entity\Slave\Operation')->findWithoutTariffs();
  352.                 $operationsWithoutKeyMappings = $em->getRepository('App\Entity\Slave\Operation')->findWithoutKeyMappings();
  353.                 $warehouseAlarms = $this->calculateWarehouseAlarms($em, 'agency');
  354.                 [$productModelsSuppliers, $doubleProducts] = $this->calculateProductsAlarms($em);
  355.                 [$formSearch, $results, $type, $like, $value] = $this->searchValues($request, $formFactory, $validator, $em, $session);
  357.                 return $this->render('role/user/index.html.twig', array(
  358.                     'operationGroups' => $operationGroups,
  359.                     'technicians' => $technicians,
  360.                     'ticketStatuses' => $ticketStatuses,
  361.                     'matrixTickets' => $matrixTickets,
  362.                     'matrixTechsTickets' => $matrixTechsTickets,
  363.                     'ticketWithErrors' => $ticketWithErrors,
  364.                     'ticketSuspensionRequest' => $ticketSuspensionRequest,
  365.                     'ticketClosedPortal' => $ticketClosedPortal,
  366.                     'ticketWaitingForMaterial' => $ticketWaitingForMaterial,
  367.                     'interventionWithoutActivities' => $interventionWithoutActivities,
  368.                     'interventionTariffOut' => $interventionTariffOut,
  369.                     'interventionExtras' => $interventionExtras,
  370.                     'operationsWithoutTariffs' => $operationsWithoutTariffs,
  371.                     'operationsWithoutKeyMappings' => $operationsWithoutKeyMappings,
  372.                     'warehouseAlarms' => $warehouseAlarms,
  373.                     'productModelsSuppliers' => $productModelsSuppliers,
  374.                     'doubleProducts' => $doubleProducts,
  375.                     'ticketReminders' => $ticketReminders,
  376.                     'formSearch' => $formSearch->createView(),
  377.                     'searchResults' => $results,
  378.                     'searchType' => $type,
  379.                     'searchLike' => $like,
  380.                     'searchValue' => $value
  381.                 ));
  382.                 break;
  383.             case 'technician': // Tecnici
  384.                 $operationGroups = $em->getRepository('App\Entity\Slave\OperationGroup')->findAll();
  385.                 $ticketStatuses = $em->getRepository('App\Entity\Slave\TicketStatus')->findWithoutToAssignAndWrong();
  386.                 [$matrixTickets, $ticketAssigned] = $this->calculateTicketAlarms($em, 'technician', $operationGroups, $ticketStatuses, null);
  387.                 $ticketReminders = $em->getRepository('App\Entity\Slave\TicketReminder')->findDashboardRemindersByTechnician($this->getUser()->getId());
  388.                 $warehousesTransfers = $this->calculateWarehouseAlarms($em, 'technician');
  390.                 return $this->render('role/user/index.html.twig', array(
  391.                     'operationGroups' => $operationGroups,
  392.                     'ticketStatuses' => $ticketStatuses,
  393.                     'matrixTickets' => $matrixTickets,
  394.                     'ticketAssigned' => $ticketAssigned,
  395.                     'warehousesTransfers' => $warehousesTransfers,
  396.                     'ticketReminders' => $ticketReminders
  397.                 ));
  398.                 break;
  399.             case 'administration': // Amministrazione
  400.                 return $this->render('role/user/index.html.twig');
  401.                 break;
  402.             case 'commercial': // Commerciale
  403.                 return $this->render('role/user/index.html.twig');
  404.                 break;
  405.             default: break;
  406.         }
  407.     }
  409.     /**
  410.      * @Route("/ticket-tab-ricarica/{tab}", name="user_index_ticket_tab_refresh")
  411.      */
  412.     public function userIndexTicketTabRefresh(Request $request, $tab)
  413.     {    
  414.         $em = $this->mr->getManager('slave');
  415.         switch($tab){
  416.             case 'waiting_for_material':
  417.                 $icon = 'icon-truck-loading';
  418.                 $text = 'In attesa di materiale ('.sizeof($em->getRepository('App\Entity\Slave\Ticket')->findWaitingForMaterial()).')';
  419.                 break;
  420.             default: break;
  421.         }
  422.         return $this->render('components/twig/index/tab_label.html.twig', ['icon' => $icon, 'text' => $text]);
  423.     }
  425.     /**
  426.      * @Route("/materiale-mancante-ricarica", name="user_index_ticket_unlock_refresh")
  427.      */
  428.     public function userIndexTicketUnlockRefresh(Request $request)
  429.     {    
  430.         $em = $this->mr->getManager('slave');
  431.         $ticketWaitingForMaterial = $em->getRepository('App\Entity\Slave\Ticket')->findWaitingForMaterial();
  432.         return $this->render('components/twig/index/ticket_waiting.html.twig', ['ticketWaitingForMaterial' => $ticketWaitingForMaterial]);
  433.     }
  434.         
  435.     /**
  436.      * @Route("/tecnico-ricerca-reindirizza", name="user_search_redirect")
  437.      */
  438.     public function userSearchRedirect(Request $request)
  439.     {    
  440.         $em = $this->mr->getManager('slave');
  441.         $session = $request->getSession();
  442.         $type = $request->request->get('type');
  444.         switch($type){
  445.             case 'ticket':
  446.                 $session->set('numberOrTermid', $request->request->get('number'));
  447.                 return $this->redirectToRoute('user_ticket_list');
  448.                 break;
  449.             case 'product': 
  450.                 $session->set('codeProducer', $request->request->get('codeProducer'));
  451.                 $session->set('codeSupplier', $request->request->get('codeSupplier'));                
  452.                 return $this->redirectToRoute('user_product_search');
  453.                 break;
  454.             case 'client': 
  455.                 $session->set('clientNickname', $request->request->get('clientNickname'));
  456.                 $session->set('clientPhone', $request->request->get('clientPhone'));                
  457.                 return $this->redirectToRoute('user_anagraphic_clients');
  458.                 break;
  459.             default: break;
  460.         }
  461.     }
  462.     
  463.     /**
  464.      * @Route("/impostazioni", name="user_settings")
  465.      */
  466.     public function userSettings(Request $request, FormFactoryInterface $formFactory, ValidatorInterface $validator)
  467.     {    
  468.         $em = $this->mr->getManager('slave');
  469.         $settings = $em->getRepository('App\Entity\Slave\Setting')->findAll();
  471.         $settingsModel = new Settings();
  472.         $formSettings = $formFactory->createNamed("form_settings", SettingsType::class, $settingsModel);
  473.         $formSettings->handleRequest($request);
  475.         if($formSettings->isSubmitted()){
  477.             $valid = ValidationService::ValidateNotBlank($validator, $formSettings->get('daysStationary'));
  478.             if($valid) $valid = ValidationService::ValidateNotBlank($validator, $formSettings->get('ticketTechnicianMinutesTakeCharge'));
  479.             if($valid) $valid = ValidationService::ValidateNotBlank($validator, $formSettings->get('ticketSuspensionAgencyEmail'));
  480.             if($valid) $valid = ValidationService::ValidateNotBlank($validator, $formSettings->get('ticketUAVAgencyEmail'));
  481.             if($valid) $valid = ValidationService::validateMultipleEmailString($validator, $formSettings->get('ticketSuspensionAgencyEmail'), '/\,/');
  482.             if($valid) $valid = ValidationService::validateMultipleEmailString($validator, $formSettings->get('ticketUAVAgencyEmail'), '/\,/');
  483.             
  484.             if($valid && $formSettings->isValid()){
  485.                 foreach($settings as $s){
  486.                     switch($s->getSlug()){
  487.                         case 'warehouse_register_stock': $s->setValue($formSettings->get('warehouseRegisterStock')->getData()); break;
  488.                         case 'warehouse_recover_stock': $s->setValue($formSettings->get('warehouseRecoverStock')->getData()); break;
  489.                         case 'warehouse_technician_product_conditions': 
  490.                             $first = true;
  491.                             $stringConditions = '';
  492.                             foreach($formSettings->get('warehouseTechnicianProductConditions')->getData() as $pc){
  493.                                 if($first) $first = false; else $stringConditions.= ',';
  494.                                 $stringConditions.= $pc->getId();
  495.                             }
  496.                             $s->setValue($stringConditions);
  497.                             break;
  498.                         case 'use_ddt': $s->setValue($formSettings->get('useDdt')->getData()); break;
  499.                         case 'ddt_internal_mandatory': $s->setValue($formSettings->get('ddtInternalMandatory')->getData()); break;
  500.                         case 'days_stationary': $s->setValue($formSettings->get('daysStationary')->getData()); break;
  501.                         case 'ticket_suspension_agency_email': $s->setValue($formSettings->get('ticketSuspensionAgencyEmail')->getData()); break;
  502.                         case 'ticket_uav_agency_email': $s->setValue($formSettings->get('ticketUAVAgencyEmail')->getData()); break;
  503.                         case 'ticket_auto_assign': $s->setValue($formSettings->get('ticketAutoAssign')->getData());  break;
  504.                         case 'ticket_auto_operation_tariff_amount': $s->setValue($formSettings->get('ticketAutoOperationTariffAmount')->getData()); break;
  505.                         case 'ticket_backoffice_manage': $s->setValue($formSettings->get('ticketBackofficeManage')->getData()); break;
  506.                         case 'ticket_technician_send_cancel_email': $s->setValue($formSettings->get('ticketTechnicianSendCancelEmail')->getData()); break;
  507.                         case 'ticket_technician_minutes_take_charge': $s->setValue($formSettings->get('ticketTechnicianMinutesTakeCharge')->getData()); break;
  508.                         case 'ticket_suspension_unlock_same_technician': $s->setValue($formSettings->get('ticketSuspensionUnlockSameTechnician')->getData()); break;
  509.                         case 'ticket_suspension_unlock_by_technician': $s->setValue($formSettings->get('ticketSuspensionUnlockByTechnician')->getData()); break;
  510.                         case 'product_model_default_stock_active': $s->setValue($formSettings->get('productModelDefaultStockActive')->getData()); break;
  511.                         case 'product_model_default_stock_yellow': $s->setValue($formSettings->get('productModelDefaultStockYellow')->getData()); break;
  512.                         case 'product_model_default_stock_red': $s->setValue($formSettings->get('productModelDefaultStockRed')->getData()); break;
  513.                         case 'use_ddt_number_for_technicians': $s->setValue($formSettings->get('useDdtNumberForTechnicians')->getData()); break;
  514.                         case 'script_sunday_active': $s->setValue($formSettings->get('scriptSundayActive')->getData()); break;
  515.                         case 'outcome_completed_default': $s->setValue($formSettings->get('outcomeCompletedDefault')->getData()->getId()); break;
  516.                         default: break;
  517.                     }
  518.                 }
  519.                 $em->flush();
  521.                 $this->addFlash('notice_success', "Impostazioni aggiornate");
  522.                 return $this->redirectToRoute('user_settings');
  523.             }
  524.         }
  526.         return $this->render('role/user/settings.html.twig', array(
  527.             'settings' => $settings,
  528.             'formSettings' => $formSettings->createView()
  529.         ));
  530.     }
  531.     
  532.     /**
  533.      * @Route("/utility", name="user_utility")
  534.      */
  535.     public function userUtility(Request $request)
  536.     {    
  537.         return $this->render('role/user/utility.html.twig');
  538.     }
  539.     
  540.     /**
  541.      * @Route("/utility/esegui-comando", name="user_utility_execute_command")
  542.      */
  543.     public function userUtilityExecuteCommand(Request $request)
  544.     {    
  545.         switch($request->request->get('command')){
  546.             case 'clear_session':
  547.                 SessionService::resetUserSession($request->getSession());
  548.                 $this->addFlash('notice_success', 'Sessione resettata correttamente!');
  549.                 break;
  550.             default: break;
  551.         }
  552.         return $this->redirectToRoute('user_utility');
  553.     }
  555.     // POST DI AGGIORNAMENTO
  556.         /**
  557.         * @Route("/economico-carica-tab", name="user_economic_tab")
  558.         */
  559.         public function userEconomicTab(Request $request)
  560.         {
  561.             $em = $this->mr->getManager('slave');
  562.             $emMaster = $this->mr->getManager('master');
  563.             $session = $request->getSession();
  564.             $company = $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get("companyId"));
  565.             $month = $request->request->get('month');
  566.             $year = $request->request->get('year');
  567.             $operationGroupsNotUav = $em->getRepository('App\Entity\Slave\OperationGroup')->findBy(['uav' => 0]);
  568.             $operationGroupUav = $em->getRepository('App\Entity\Slave\OperationGroup')->findBy(['uav' => 1]);
  570.             // Se UserId = 0 --> Significa che è l'aziendale
  571.             if($request->request->get('userId') != 0){
  572.                 $user = $em->getRepository('App\Entity\Slave\User')->findOneById($request->request->get('userId'));
  573.                 $allInterventions = $em->getRepository("App\Entity\Slave\Intervention")->findByTechnicianToPayByYearAndMonth($user->getId(), $year, $month);
  574.             }
  575.             else{                
  576.                 $allInterventions = $em->getRepository("App\Entity\Slave\Intervention")->findToPayByYearAndMonth($year, $month);
  577.             }
  579.             // Rimuovo gli interventi che hanno una sospensione -> Gestita e non approvata / Non gestita
  580.             $interventions = array();
  581.             foreach($allInterventions as $int){
  582.                 $toCalculate = true;
  583.                 if($int->getSuspension() != null && ($int->getSuspension()->isManaged() == false || $int->getSuspension()->isApproved() == false))
  584.                     $toCalculate = false;
  586.                 if($toCalculate)
  587.                     array_push($interventions, $int);
  588.             }
  590.             $arrayProvincesIds = array();
  591.             $arrayProvinces = array();
  592.             foreach($interventions as $int){
  593.                 if(!in_array($int->getTicket()->getIdProvince(), $arrayProvincesIds)){
  594.                     array_push($arrayProvincesIds, $int->getTicket()->getIdProvince());
  595.                     array_push($arrayProvinces, $emMaster->getRepository('App\Entity\Master\Province')->findOneById($int->getTicket()->getIdProvince()));
  596.                 }
  597.             }
  599.             $matrixResults = array();
  600.             foreach($arrayProvinces as $province){
  601.                 $arrayRow = array();
  602.                 array_push($arrayRow, $province->getSign());
  604.                 $arrayCells = array();
  605.                 $rowAmount = 0;
  606.                 $rowCount = 0;
  607.                 $cellUavAmount = 0;
  608.                 $cellUavCount = 0;
  610.                 foreach($operationGroupsNotUav as $og){
  611.                     $arrayCell = array();
  612.                     $cellAmount = 0;
  613.                     $cellCount = 0;
  614.                     foreach($interventions as $int){
  615.                         # 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
  616.                         if($int->getTicket()->getOperation()->getGroup()->getId() == $og->getId() && $int->getTicket()->getIdProvince() == $province->getId()){
  617.                             # SE completato -> aggiungo
  618.                             if($int->getOutcomeType()->getSlug() == 'completed'){
  619.                                 if($request->request->get('userId') != 0)
  620.                                     $cellAmount += $int->calculateTotalTechnicianAmount();
  621.                                 else
  622.                                     $cellAmount += $int->getAmount();
  623.                                 $cellCount++;
  624.                             }
  625.                             # SE uav -> aggiungo alla colonna finale
  626.                             if($int->getOutcomeType()->getSlug() == 'empty'){
  627.                                 if($request->request->get('userId') != 0)
  628.                                     $cellUavAmount += $int->calculateTotalTechnicianAmount();
  629.                                 else
  630.                                     $cellUavAmount += $int->getAmount();
  631.                                 $cellUavCount++;
  632.                             }
  633.                         }
  634.                     }
  635.                     $rowAmount += $cellAmount;
  636.                     $rowCount += $cellCount;
  637.                     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());
  638.                     array_push($arrayCells, $arrayCell);
  639.                 }
  640.                 $test = null;
  641.                 foreach($operationGroupUav as $og){
  642.                     $arrayCell = array();
  643.                     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());
  644.                     array_push($arrayCells, $arrayCell);
  645.                 }
  646.                 $rowAmount += $cellUavAmount;
  647.                 $rowCount += $cellUavCount;
  648.                 array_push($arrayRow, $arrayCells, '['.$rowCount.'] '.number_format($rowAmount, 2, '.', '').' €');
  649.                 array_push($matrixResults, $arrayRow);
  650.             }
  652.             $response = array("code" => 200, "success" => true, "matrixResults" => $matrixResults);
  653.             return new Response(json_encode($response));
  654.         }
  656.         /**
  657.          * @Route("/economico-aggiorna", name="user_economic_update")
  658.          */
  659.         public function userEconomicUpdate(Request $request)
  660.         {    
  661.             $em = $this->mr->getManager('slave');
  662.             $emMaster = $this->mr->getManager('master');
  663.             $session = $request->getSession();
  664.             $province = $emMaster->getRepository('App\Entity\Master\Province')->findOneBySign($request->request->get('taProvince'));
  665.             $year = $request->request->get('year');
  666.             $month = $request->request->get('month');
  667.             $operationGroupId = $request->request->get("operationGroupId");
  668.             $operationGroup = $em->getRepository('App\Entity\Slave\OperationGroup')->findOneById($operationGroupId);
  670.             // Se UserId = 0 --> Significa che è l'aziendale
  671.             if($request->request->get('userId') != 0){
  672.                 $user = $em->getRepository('App\Entity\Slave\User')->findOneById($request->request->get('userId'));
  673.                 if($operationGroup->isUav())
  674.                     $allInterventions = $em->getRepository('App\Entity\Slave\Intervention')->findByTechnicianProvinceToPayByYearAndMonthUav($user->getId(), $province->getId(), $year, $month);
  675.                 else
  676.                     $allInterventions = $em->getRepository('App\Entity\Slave\Intervention')->findByTechnicianProvinceAndOperationGroupToPayByYearAndMonthNotUav($operationGroupId, $user->getId(), $province->getId(), $year, $month);
  677.             }
  678.             else{
  679.                 if($operationGroup->isUav())
  680.                     $allInterventions = $em->getRepository('App\Entity\Slave\Intervention')->findByProvinceToPayByYearAndMonthUav($province->getId(), $year, $month);
  681.                 else
  682.                     $allInterventions = $em->getRepository('App\Entity\Slave\Intervention')->findByProvinceAndOperationGroupToPayByYearAndMonthNotUav($operationGroupId, $province->getId(), $year, $month);
  683.             }
  685.             // Rimuovo gli interventi che hanno una sospensione -> Gestita e non approvata / Non gestita
  686.             $interventions = array();
  687.             foreach($allInterventions as $int){
  688.                 $toCalculate = true;
  689.                 if($int->getSuspension() != null && ($int->getSuspension()->isManaged() == false || $int->getSuspension()->isApproved() == false))
  690.                     $toCalculate = false;
  692.                 if($toCalculate)
  693.                     array_push($interventions, $int);
  694.             }
  696.             # Creo JSON
  697.             $first = true;
  698.             $json = '[';
  699.             foreach($interventions as $int){
  700.                 if($first) $first = false; else $json.= ',';
  701.                 $tableActivities = '---';
  702.                 if(sizeof($int->getActivities()) > 0){
  703.                     $tableActivities = '<table class=\'table table_no_padding b_none m_b_none\'>';
  704.                     foreach($int->getActivities() as $act){
  705.                         if($act->getProductWithdraw() != null) 
  706.                             $tableActivities .= '<tr><th>Ritiro: '.$act->getType().'</th></tr><tr><td>'.$act->getProductWithdraw()->toStringShort().'</td></tr>';
  707.                         else{
  708.                             if($act->getProducerWithdraw() != null)
  709.                                 $tableActivities .= '<tr><th>Ritiro: </th></tr><tr><td>'.$act->getProducerWithdraw().'</td></tr>';
  710.                         }
  711.                         if($act->getProductActual() != null) 
  712.                             $tableActivities .= '<tr><th>Attuale: '.$act->getType().'</th></tr><tr><td>'.$act->getProductActual()->toStringShort().'</td></tr>';
  713.                         else{
  714.                             if($act->getProducerActual() != null)
  715.                                 $tableActivities .= '<tr><th>Attuale: </th></tr><tr><td>'.$act->getProducerActual().'</td></tr>';
  716.                         }
  717.                         if($act->getProductInstallation() != null) 
  718.                             $tableActivities .= '<tr><th>Installato: '.$act->getType().'</th></tr><tr><td>'.$act->getProductInstallation()->toStringShort().'</td></tr>';
  719.                         else{
  720.                             if($act->getProducerInstallation() != null)
  721.                                 $tableActivities .= '<tr><th>Installato: </th></tr><tr><td>'.$act->getProducerInstallation().'</td></tr>';
  722.                         }
  723.                     }
  724.                     $tableActivities.= '</table>';
  725.                 }
  726.                 if($request->request->get('userId') != 0)
  727.                     $tot = $int->calculateTechnicianAmount();
  728.                 else
  729.                     $tot = $int->getAmount();
  731.                 $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>';
  733.                 $termid = '';
  734.                 if($int->getTicket()->getTermid() != null)
  735.                     $termid = $int->getTicket()->getTermid()->getCode();
  736.                 $json.= '{
  737.                     "id":"'.$int->getId().'", 
  738.                     "datetime":"'.$int->getDatetime()->format('d-m-Y H:i').'", 
  739.                     "client":"'.$int->getTicket()->getClient()->__toString().'", 
  740.                     "termid":"'.$termid.'", 
  741.                     "ticket":"'.$int->getTicket()->getNumber().'",
  742.                     "outcome":"'.$int->getOutcome()->getValue().'", 
  743.                     "activities":"'.$tableActivities.'",
  744.                     "amounts":"'.$tableAmounts.'"
  745.                 }';
  746.             }
  747.             $json .= ']';
  749.             return new Response(json_encode(array("code" => 200, "success" => true, "interventions" => $json, "provinceId" => $province->getId()))); 
  750.         }
  751.         
  752.         /**
  753.         * @Route("/economico-aziendale-carica-tab", name="user_company_economic_tab")
  754.         */
  755.         public function userCompanyEconomicTab(Request $request)
  756.         {
  757.             $em = $this->mr->getManager('slave');
  758.             $emMaster = $this->mr->getManager('master');
  759.             $session = $request->getSession();
  760.             $company = $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get("companyId"));
  761.             $month = $request->request->get('month');
  762.             $year = $request->request->get('year');
  763.             $operationGroupsNotUav = $em->getRepository('App\Entity\Slave\OperationGroup')->findBy(['uav' => 0]);
  764.             $operationGroupUav = $em->getRepository('App\Entity\Slave\OperationGroup')->findBy(['uav' => 1]);
  765.             $allInterventions = $em->getRepository("App\Entity\Slave\Intervention")->findToPayByYearAndMonth($year, $month);
  767.             // Rimuovo gli interventi che hanno una sospensione -> Gestita e non approvata / Non gestita
  768.             $interventions = array();
  769.             foreach($allInterventions as $int){
  770.                 $toCalculate = true;
  771.                 if($int->getSuspension() != null && ($int->getSuspension()->isManaged() == false || $int->getSuspension()->isApproved() == false))
  772.                     $toCalculate = false;
  774.                 if($toCalculate)
  775.                     array_push($interventions, $int);
  776.             }
  778.             $arrayTechniciansIds = array();
  779.             $arrayTechnicians = array();
  780.             foreach($interventions as $int){
  781.                 if(!in_array($int->getTechnician()->getId(), $arrayTechniciansIds)){
  782.                     array_push($arrayTechniciansIds, $int->getTechnician()->getId());
  783.                     array_push($arrayTechnicians, $em->getRepository('App\Entity\Slave\User')->findOneById($int->getTechnician()->getId()));
  784.                 }
  785.             }
  787.             $matrixResults = array();
  788.             foreach($arrayTechnicians as $technician){
  789.                 $arrayRow = array();
  790.                 array_push($arrayRow, [$technician->getId(), $technician->getNameShort()]);
  792.                 $arrayCells = array();
  793.                 $rowAmount = 0;
  794.                 $rowCount = 0;
  795.                 $cellUavAmount = 0;
  796.                 $cellUavCount = 0;
  798.                 foreach($operationGroupsNotUav as $og){
  799.                     $arrayCell = array();
  800.                     $cellAmount = 0;
  801.                     $cellCount = 0;
  802.                     foreach($interventions as $int){
  803.                         # SE --- gruppo operazione intervento == gruppo operazione ciclo AND id provincia cliente == id provincia ciclo AND tecnico ciclo
  804.                         if($int->getTicket()->getOperation()->getGroup()->getId() == $og->getId() && $int->getTechnician()->getId() == $technician->getId()){
  805.                             # SE completato -> aggiungo
  806.                             if($int->getOutcomeType()->getSlug() == 'completed'){
  807.                                 $cellAmount += $int->getAmount();
  808.                                 $cellCount++;
  809.                             }
  810.                             # SE uav -> aggiungo alla colonna finale
  811.                             if($int->getOutcomeType()->getSlug() == 'empty'){
  812.                                 $cellUavAmount += $int->getAmount();
  813.                                 $cellUavCount++;
  814.                             }
  815.                         }
  816.                     }
  817.                     $rowAmount += $cellAmount;
  818.                     $rowCount += $cellCount;
  819.                     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());
  820.                     array_push($arrayCells, $arrayCell);
  821.                 }
  822.                 $test = null;
  823.                 foreach($operationGroupUav as $og){
  824.                     $arrayCell = array();
  825.                     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());
  826.                     array_push($arrayCells, $arrayCell);
  827.                 }
  828.                 $rowAmount += $cellUavAmount;
  829.                 $rowCount += $cellUavCount;
  830.                 array_push($arrayRow, $arrayCells, '['.$rowCount.'] '.number_format($rowAmount, 2, '.', '').' €');
  831.                 array_push($matrixResults, $arrayRow);
  832.             }
  834.             $response = array("code" => 200, "success" => true, "matrixResults" => $matrixResults);
  835.             return new Response(json_encode($response));
  836.         }
  839.         /**
  840.          * @Route("/economico-aziendale-aggiorna", name="user_company_economic_update")
  841.          */
  842.         public function userCompanyEconomicUpdate(Request $request)
  843.         {    
  844.             $em = $this->mr->getManager('slave');
  845.             $emMaster = $this->mr->getManager('master');
  846.             $session = $request->getSession();
  847.             $user = $em->getRepository('App\Entity\Slave\User')->findOneById($request->request->get('userId'));
  848.             $year = $request->request->get('year');
  849.             $month = $request->request->get('month');
  850.             $operationGroupId = $request->request->get("operationGroupId");
  851.             $operationGroup = $em->getRepository('App\Entity\Slave\OperationGroup')->findOneById($operationGroupId);
  853.             if($operationGroup->isUav())
  854.                 $allInterventions = $em->getRepository('App\Entity\Slave\Intervention')->findByTechnicianToPayByYearAndMonthUav($user->getId(), $year, $month);
  855.             else
  856.                 $allInterventions = $em->getRepository('App\Entity\Slave\Intervention')->findByTechnicianAndOperationGroupToPayByYearAndMonthNotUav($operationGroupId, $user->getId(), $year, $month);
  858.             // Rimuovo gli interventi che hanno una sospensione -> Gestita e non approvata / Non gestita
  859.             $interventions = array();
  860.             foreach($allInterventions as $int){
  861.                 $toCalculate = true;
  862.                 if($int->getSuspension() != null && ($int->getSuspension()->isManaged() == false || $int->getSuspension()->isApproved() == false))
  863.                     $toCalculate = false;
  865.                 if($toCalculate)
  866.                     array_push($interventions, $int);
  867.             }
  869.             # Creo JSON
  870.             $first = true;
  871.             $json = '[';
  872.             foreach($interventions as $int){
  873.                 if($first) $first = false; else $json.= ',';
  874.                 $tableActivities = '---';
  875.                 if(sizeof($int->getActivities()) > 0){
  876.                     $tableActivities = '<table class=\'table table_no_padding b_none m_b_none\'>';
  877.                     foreach($int->getActivities() as $act){
  878.                         if($act->getProductWithdraw() != null) 
  879.                             $tableActivities .= '<tr><th>Ritiro: '.$act->getType().'</th></tr><tr><td>'.$act->getProductWithdraw()->toStringShort().'</td></tr>';
  880.                         else{
  881.                             if($act->getProducerWithdraw() != null)
  882.                                 $tableActivities .= '<tr><th>Ritiro: </th></tr><tr><td>'.$act->getProducerWithdraw().'</td></tr>';
  883.                         }
  884.                         if($act->getProductActual() != null) 
  885.                             $tableActivities .= '<tr><th>Attuale: '.$act->getType().'</th></tr><tr><td>'.$act->getProductActual()->toStringShort().'</td></tr>';
  886.                         else{
  887.                             if($act->getProducerActual() != null)
  888.                                 $tableActivities .= '<tr><th>Attuale: </th></tr><tr><td>'.$act->getProducerActual().'</td></tr>';
  889.                         }
  890.                         if($act->getProductInstallation() != null) 
  891.                             $tableActivities .= '<tr><th>Installato: '.$act->getType().'</th></tr><tr><td>'.$act->getProductInstallation()->toStringShort().'</td></tr>';
  892.                         else{
  893.                             if($act->getProducerInstallation() != null)
  894.                                 $tableActivities .= '<tr><th>Installato: </th></tr><tr><td>'.$act->getProducerInstallation().'</td></tr>';
  895.                         }
  896.                     }
  897.                     $tableActivities.= '</table>';
  898.                 }
  899.                 $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>';
  901.                 $termid = '';
  902.                 if($int->getTicket()->getTermid() != null)
  903.                     $termid = $int->getTicket()->getTermid()->getCode();
  904.                 $json.= '{
  905.                     "id":"'.$int->getId().'", 
  906.                     "datetime":"'.$int->getDatetime()->format('d-m-Y H:i').'", 
  907.                     "client":"'.$int->getTicket()->getClient()->__toString().'", 
  908.                     "termid":"'.$termid.'", 
  909.                     "ticket":"'.$int->getTicket()->getNumber().'",
  910.                     "outcome":"'.$int->getOutcome()->getValue().'", 
  911.                     "activities":"'.$tableActivities.'",
  912.                     "amounts":"'.$tableAmounts.'"
  913.                 }';
  914.             }
  915.             $json .= ']';
  917.             return new Response(json_encode(array("code" => 200, "success" => true, "interventions" => $json))); 
  918.         }
  920.         
  921.         /**
  922.         * @Route("/economico-fornitori-carica-tab", name="user_supplier_economic_tab")
  923.         */
  924.         public function userSupplierEconomicTab(Request $request)
  925.         {
  926.             $em = $this->mr->getManager('slave');
  927.             $emMaster = $this->mr->getManager('master');
  928.             $session = $request->getSession();
  929.             $company = $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get("companyId"));
  930.             $month = $request->request->get('month');
  931.             $year = $request->request->get('year');
  932.             $operationGroupsNotUav = $em->getRepository('App\Entity\Slave\OperationGroup')->findBy(['uav' => 0]);
  933.             $operationGroupUav = $em->getRepository('App\Entity\Slave\OperationGroup')->findBy(['uav' => 1]);
  934.             $allInterventions = $em->getRepository("App\Entity\Slave\Intervention")->findToPayByYearAndMonth($year, $month);
  936.             // Rimuovo gli interventi che hanno una sospensione -> Gestita e non approvata / Non gestita
  937.             $interventions = array();
  938.             foreach($allInterventions as $int){
  939.                 $toCalculate = true;
  940.                 if($int->getSuspension() != null && ($int->getSuspension()->isManaged() == false || $int->getSuspension()->isApproved() == false))
  941.                     $toCalculate = false;
  943.                 if($toCalculate)
  944.                     array_push($interventions, $int);
  945.             }
  947.             $arraySuppliersIds = array();
  948.             $arraySuppliers = array();
  949.             foreach($interventions as $int){
  950.                 if(!in_array($int->getTicket()->getSupplier()->getId(), $arraySuppliersIds)){
  951.                     array_push($arraySuppliersIds, $int->getTicket()->getSupplier()->getId());
  952.                     array_push($arraySuppliers, $em->getRepository('App\Entity\Slave\Supplier')->findOneById($int->getTicket()->getSupplier()->getId()));
  953.                 }
  954.             }
  956.             $matrixResults = array();
  957.             foreach($arraySuppliers as $supplier){
  958.                 $arrayRow = array();
  959.                 array_push($arrayRow, [$supplier->getId(), $supplier->getName()]);
  961.                 $arrayCells = array();
  962.                 $rowAmount = 0;
  963.                 $rowCount = 0;
  964.                 $cellUavAmount = 0;
  965.                 $cellUavCount = 0;
  967.                 foreach($operationGroupsNotUav as $og){
  968.                     $arrayCell = array();
  969.                     $cellAmount = 0;
  970.                     $cellCount = 0;
  971.                     foreach($interventions as $int){
  972.                         # SE --- gruppo operazione intervento == gruppo operazione ciclo AND id provincia cliente == id provincia ciclo AND tecnico ciclo
  973.                         if($int->getTicket()->getOperation()->getGroup()->getId() == $og->getId() && $int->getTicket()->getSupplier()->getId() == $supplier->getId()){
  974.                             # SE completato -> aggiungo
  975.                             if($int->getOutcomeType()->getSlug() == 'completed'){
  976.                                 $cellAmount += $int->getAmount();
  977.                                 $cellCount++;
  978.                             }
  979.                             # SE uav -> aggiungo alla colonna finale
  980.                             if($int->getOutcomeType()->getSlug() == 'empty'){
  981.                                 $cellUavAmount += $int->getAmount();
  982.                                 $cellUavCount++;
  983.                             }
  984.                         }
  985.                     }
  986.                     $rowAmount += $cellAmount;
  987.                     $rowCount += $cellCount;
  988.                     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());
  989.                     array_push($arrayCells, $arrayCell);
  990.                 }
  991.                 $test = null;
  992.                 foreach($operationGroupUav as $og){
  993.                     $arrayCell = array();
  994.                     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());
  995.                     array_push($arrayCells, $arrayCell);
  996.                 }
  997.                 $rowAmount += $cellUavAmount;
  998.                 $rowCount += $cellUavCount;
  999.                 array_push($arrayRow, $arrayCells, '['.$rowCount.'] '.number_format($rowAmount, 2, '.', '').' €');
  1000.                 array_push($matrixResults, $arrayRow);
  1001.             }
  1003.             $response = array("code" => 200, "success" => true, "matrixResults" => $matrixResults);
  1004.             return new Response(json_encode($response));
  1005.         }
  1007.         /**
  1008.          * @Route("/economico-fornitori-aggiorna", name="user_supplier_economic_update")
  1009.          */
  1010.         public function userSupplierEconomicUpdate(Request $request)
  1011.         {    
  1012.             $em = $this->mr->getManager('slave');
  1013.             $emMaster = $this->mr->getManager('master');
  1014.             $session = $request->getSession();
  1015.             $supplier = $em->getRepository('App\Entity\Slave\Supplier')->findOneById($request->request->get('supplierId'));
  1016.             $year = $request->request->get('year');
  1017.             $month = $request->request->get('month');
  1018.             $operationGroupId = $request->request->get("operationGroupId");
  1019.             $operationGroup = $em->getRepository('App\Entity\Slave\OperationGroup')->findOneById($operationGroupId);
  1021.             if($operationGroup->isUav())
  1022.                 $allInterventions = $em->getRepository('App\Entity\Slave\Intervention')->findBySupplierToPayByYearAndMonthUav($supplier->getId(), $year, $month);
  1023.             else
  1024.                 $allInterventions = $em->getRepository('App\Entity\Slave\Intervention')->findBySupplierAndOperationGroupToPayByYearAndMonthNotUav($operationGroupId, $supplier->getId(), $year, $month);
  1026.             // Rimuovo gli interventi che hanno una sospensione -> Gestita e non approvata / Non gestita
  1027.             $interventions = array();
  1028.             foreach($allInterventions as $int){
  1029.                 $toCalculate = true;
  1030.                 if($int->getSuspension() != null && ($int->getSuspension()->isManaged() == false || $int->getSuspension()->isApproved() == false))
  1031.                     $toCalculate = false;
  1033.                 if($toCalculate)
  1034.                     array_push($interventions, $int);
  1035.             }
  1037.             # Creo JSON
  1038.             $first = true;
  1039.             $json = '[';
  1040.             foreach($interventions as $int){
  1041.                 if($first) $first = false; else $json.= ',';
  1042.                 $tableActivities = '---';
  1043.                 if(sizeof($int->getActivities()) > 0){
  1044.                     $tableActivities = '<table class=\'table table_no_padding b_none m_b_none\'>';
  1045.                     foreach($int->getActivities() as $act){
  1046.                         if($act->getProductWithdraw() != null) 
  1047.                             $tableActivities .= '<tr><th>Ritiro: '.$act->getType().'</th></tr><tr><td>'.$act->getProductWithdraw()->toStringShort().'</td></tr>';
  1048.                         else{
  1049.                             if($act->getProducerWithdraw() != null)
  1050.                                 $tableActivities .= '<tr><th>Ritiro: </th></tr><tr><td>'.$act->getProducerWithdraw().'</td></tr>';
  1051.                         }
  1052.                         if($act->getProductActual() != null) 
  1053.                             $tableActivities .= '<tr><th>Attuale: '.$act->getType().'</th></tr><tr><td>'.$act->getProductActual()->toStringShort().'</td></tr>';
  1054.                         else{
  1055.                             if($act->getProducerActual() != null)
  1056.                                 $tableActivities .= '<tr><th>Attuale: </th></tr><tr><td>'.$act->getProducerActual().'</td></tr>';
  1057.                         }
  1058.                         if($act->getProductInstallation() != null) 
  1059.                             $tableActivities .= '<tr><th>Installato: '.$act->getType().'</th></tr><tr><td>'.$act->getProductInstallation()->toStringShort().'</td></tr>';
  1060.                         else{
  1061.                             if($act->getProducerInstallation() != null)
  1062.                                 $tableActivities .= '<tr><th>Installato: </th></tr><tr><td>'.$act->getProducerInstallation().'</td></tr>';
  1063.                         }
  1064.                     }
  1065.                     $tableActivities.= '</table>';
  1066.                 }
  1067.                 $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>';
  1069.                 $termid = '';
  1070.                 if($int->getTicket()->getTermid() != null)
  1071.                     $termid = $int->getTicket()->getTermid()->getCode();
  1072.                 $json.= '{
  1073.                     "id":"'.$int->getId().'", 
  1074.                     "datetime":"'.$int->getDatetime()->format('d-m-Y H:i').'", 
  1075.                     "client":"'.$int->getTicket()->getClient()->__toString().'", 
  1076.                     "termid":"'.$termid.'", 
  1077.                     "ticket":"'.$int->getTicket()->getNumber().'",
  1078.                     "outcome":"'.$int->getOutcome()->getValue().'", 
  1079.                     "activities":"'.$tableActivities.'",
  1080.                     "amounts":"'.$tableAmounts.'"
  1081.                 }';
  1082.             }
  1083.             $json .= ']';
  1085.             return new Response(json_encode(array("code" => 200, "success" => true, "interventions" => $json))); 
  1086.         }
  1088.         /**
  1089.          * @Route("/provincia-cap", name="user_province_zips")
  1090.          */
  1091.         public function userProvinceZips(Request $request)
  1092.         {    
  1093.             $em = $this->mr->getManager('slave');
  1094.             $emMaster = $this->mr->getManager('master');
  1095.             $province = $emMaster->getRepository('App\Entity\Master\Province')->findOneById($request->request->get("provinceId"));
  1096.             $zips = $emMaster->getRepository('App\Entity\Master\Zip')->findAllByProvince($province->getId());
  1098.             $operationTariffs = $em->getRepository('App\Entity\Slave\OperationTariff')->findByIdProvince($province->getId());
  1100.             $first = true;
  1101.             $json = "[";
  1102.             foreach($zips as $zip){
  1103.                 if($first) $first = false; else $json.= ',';
  1104.                 $enabled = 0;
  1105.                 foreach($operationTariffs as $ot){
  1106.                     // SE TUTTI I CAP DELLA PROVINCIA --> ENABLED = 1
  1107.                     if($ot->isAllZip())
  1108.                         $enabled = 1;
  1109.                     else{
  1110.                         // SE TUTTI IL CAP E TRA QUELLI DELLA TARIFFA --> ENABLED = 1
  1111.                         foreach($ot->getZips() as $otZip)
  1112.                             if($otZip[1] == $zip->getCode())
  1113.                                 $enabled = 1;
  1114.                     }
  1115.                 }
  1116.                 $json.= '{"id":'.$zip->getId().', "value":"'.$zip->displayCodeAndCities().'", "enabled":'.$enabled.'}';
  1117.             }
  1118.             $json.= "]";
  1119.         
  1120.             return new Response(json_encode(array("code" => 200, "success" => true, "zips" => $json))); 
  1121.         }
  1123.         /**
  1124.          * @Route("/aggiorna-produttore-modelli", name="user_update_producer_models")
  1125.          */
  1126.         public function userUpdateProducerModels(Request $request)
  1127.         {    
  1128.             $em = $this->mr->getManager('slave');
  1129.             $producer = $em->getRepository('App\Entity\Slave\Producer')->findOneById($request->request->get("producerId"));
  1130.             $models = $em->getRepository('App\Entity\Slave\ProductModel')->findByProducerOrdered($producer->getId());
  1132.             $first = true;
  1133.             $json = "[";
  1134.             foreach($models as $model){
  1135.                 if($first) $first = false; else $json.= ',';
  1136.                 $json.= '{"id":'.$model->getId().', "name":"'.$model->getName().'"}';
  1137.             }
  1138.             $json.= "]";
  1139.         
  1140.             return new Response(json_encode(array("code" => 200, "success" => true, "models" => $json))); 
  1141.         }
  1142.         
  1143.         /**
  1144.          * @Route("/aggiorna-modello-fornitori", name="user_update_model_suppliers")
  1145.          */
  1146.         public function userUpdateModelSuppliers(Request $request)
  1147.         {    
  1148.             $em = $this->mr->getManager('slave');
  1149.             $model = $em->getRepository('App\Entity\Slave\ProductModel')->findOneById($request->request->get("modelId"));
  1150.             $suppliers = $em->getRepository('App\Entity\Slave\Supplier')->findByModelOrdered($model->getId());
  1152.             $first = true;
  1153.             $json = "[";
  1154.             foreach($suppliers as $supplier){
  1155.                 if($first) $first = false; else $json.= ',';
  1156.                 $json.= '{"id":'.$supplier->getId().', "name":"'.$supplier->getName().'"}';
  1157.             }
  1158.             $json.= "]";
  1159.         
  1160.             return new Response(json_encode(array("code" => 200, "success" => true, "suppliers" => $json))); 
  1161.         }
  1162.         
  1163.         /**
  1164.          * @Route("/aggiorna-modelli-sottocategorie", name="user_product_model_update_subcategory")
  1165.          */
  1166.         public function userProductModelUpdateSubcategories(Request $request)
  1167.         {
  1168.             $em = $this->mr->getManager('slave');
  1169.             if($request->request->get('categoryId') != null){
  1170.                 $category = $em->getRepository("App\Entity\Slave\ProductCategory")->findOneById($request->request->get('categoryId'));
  1171.                 $subcategories = $category->getSubcategories();
  1172.             }
  1173.             else{
  1174.                 $subcategories = $em->getRepository("App\Entity\Slave\ProductSubcategory")->findAll();
  1175.             }
  1177.             $first = true;
  1178.             $json = '[';
  1179.             foreach($subcategories as $s){
  1180.                 if($first) $first = false; else $json.= ',';
  1181.                 $json.= '{"id":"'.$s->getId().'", "name":'.json_encode($s->getName()).'}';
  1182.             }
  1183.             $json .= ']';
  1185.             $response = array("code" => 200, "success" => true, "subcategories" => $json, 'isPos' => $category->isPos());
  1186.             return new Response(json_encode($response));
  1187.         }
  1188.         
  1189.         /**
  1190.          * @Route("/controlla-prodotto-matricole", name="user_check_product_codes")
  1191.          */
  1192.         public function userCheckProductCodes(Request $request)
  1193.         {    
  1194.             $em = $this->mr->getManager('slave');
  1195.             $code = $request->request->get("code");
  1196.             $type = $request->request->get("type");
  1197.             $msg = null;
  1198.             $product = null;
  1200.             switch($type){
  1201.                 case 'producer': $product = $em->getRepository('App\Entity\Slave\Product')->findOneBy(array('codeProducer' => $code)); break;
  1202.                 case 'supplier': $product = $em->getRepository('App\Entity\Slave\Product')->findOneBy(array('codeSupplier' => $code)); break;
  1203.                 default: break;
  1204.             }
  1206.             $found = false;
  1207.             if($product != null){
  1208.                 $found = true;
  1209.                 $msg = "Il prodotto risulta già registrato nella piattaforma ecco i dettagli<br>".$product->getDisplayConflict()."<strong>Magazzino</strong>: ".$product->getActualWarehouse().".";
  1210.             }
  1211.         
  1212.             return new Response(json_encode(array("code" => 200, "success" => true, "found" => $found, 'msg' => $msg))); 
  1213.         }
  1215.         /**
  1216.          * @Route("/aggiorna-codici-interni-modelli", name="user_update_internal_code_models")
  1217.          */
  1218.         public function userUpdateInternalCodeModels(Request $request)
  1219.         {    
  1220.             $em = $this->mr->getManager('slave');
  1221.             $models = $em->getRepository('App\Entity\Slave\ProductModel')->findByInternalCodeNullOrEmpty();
  1222.             foreach($models as $m){
  1223.                 $m->setInternalCode(UtilitiesService::generateModelInternalCode($m->getId()));
  1224.             }
  1225.             $em->flush();
  1226.             $this->addFlash('notice_success', 'Codici aggiornati');
  1227.             return $this->redirectToRoute('user_index');
  1228.         }      
  1229.         
  1230.         /**
  1231.          * @Route("/aggiorna-modelli-consentiti-per-fornitore", name="user_available_product_models_by_supplier_updates")
  1232.          */
  1233.         public function userAvailableProductModelsBySupplierUpdates(Request $request)
  1234.         {
  1235.             $em = $this->mr->getManager('slave');
  1236.             $supplierId = $request->request->get('supplierId');
  1237.             $values = $em->getRepository('App\Entity\Slave\ProductModel')->findAllowedModelsBySupplier($supplierId);
  1239.             $first = true;
  1240.             $json = "[";
  1241.             foreach($values as $v){
  1242.                 if($first) $first = false; else $json.= ',';
  1243.                 $json.= '{"id":'.$v->getId().', "name":'.json_encode($v->getName()).'}';
  1244.             }
  1245.             $json.= "]";
  1246.         
  1247.             return new Response(json_encode(array("code" => 200, "success" => true, "values" => $json))); 
  1248.         }       
  1249.         
  1250.         /**
  1251.          * @Route("/aggiorna-valori-modello-fornitore", name="user_product_model_name_by_supplier_updates")
  1252.          */
  1253.         public function userProductModelNameBySupplierUpdates(Request $request)
  1254.         {
  1255.             $em = $this->mr->getManager('slave');
  1256.             $name = $request->request->get('modelName');
  1257.             $supplierId = $request->request->get('supplierId');
  1258.             $values = $em->getRepository('App\Entity\Slave\ProductModel')->findByNameOrInternalCodeBySupplier($name, $supplierId);
  1260.             $first = true;
  1261.             $json = "[";
  1262.             foreach($values as $v){
  1263.                 if($first) $first = false; else $json.= ',';
  1264.                 $json.= '{"id":'.$v->getId().', "name":'.json_encode($v->getName()).'}';
  1265.             }
  1266.             $json.= "]";
  1267.         
  1268.             return new Response(json_encode(array("code" => 200, "success" => true, "values" => $json))); 
  1269.         }
  1270.         
  1271.         /**
  1272.          * @Route("/aggiorna-valori-modello", name="user_product_model_name_updates")
  1273.          */
  1274.         public function userProductModelNameUpdates(Request $request)
  1275.         {
  1276.             $em = $this->mr->getManager('slave');
  1277.             $name = $request->request->get('modelName');
  1278.             $values = $em->getRepository('App\Entity\Slave\ProductModel')->findByNameOrInternalCode($name);
  1280.             $first = true;
  1281.             $json = "[";
  1282.             foreach($values as $v){
  1283.                 if($first) $first = false; else $json.= ',';
  1284.                 $json.= '{"id":'.$v->getId().', "name":'.json_encode($v->getName()).'}';
  1285.             }
  1286.             $json.= "]";
  1287.         
  1288.             return new Response(json_encode(array("code" => 200, "success" => true, "values" => $json))); 
  1289.         }
  1290.         
  1291.         /**
  1292.          * @Route("/aggiorna-valori-magazzini", name="user_product_warehouse_nickname_updates")
  1293.          */
  1294.         public function userProductWarehouseNicknameUpdates(Request $request)
  1295.         {
  1296.             $em = $this->mr->getManager('slave');
  1297.             $nickname = $request->request->get('nickname');
  1298.             $termid = $request->request->get('termid');
  1299.             $values = $em->getRepository('App\Entity\Slave\Warehouse')->findLikeNicknameAndTermid($nickname, $termid);
  1301.             $first = true;
  1302.             $json = "[";
  1303.             foreach($values as $v){
  1304.                 if($first) $first = false; else $json.= ',';
  1305.                 $termids = '';
  1306.                 if($v->getClient() != null)
  1307.                     $termids = $v->getClient()->displayTermids('string');
  1308.                 $json.= '{"id":'.$v->getId().', "nickname":'.json_encode($v->getNickname()).', "termids":'.json_encode($termids).'}';
  1309.             }
  1310.             $json.= "]";
  1311.         
  1312.             return new Response(json_encode(array("code" => 200, "success" => true, "values" => $json))); 
  1313.         }
  1315.         /**
  1316.          * @Route("/aggiorna-valori-prodotto", name="user_product_value_updates")
  1317.          */
  1318.         public function userProductValuesUpdate(Request $request)
  1319.         {    
  1320.             $em = $this->mr->getManager('slave');
  1321.             $id = $request->request->get('id');
  1322.             $id2 = $request->request->get('id2');
  1323.             switch($request->request->get('type')){
  1324.                 case 'subcategories': $values = $em->getRepository('App\Entity\Slave\ProductSubcategory')->findByCategoryOrdered($id); break;
  1325.                 case 'producers': $values = $em->getRepository('App\Entity\Slave\Producer')->findBySubcategoryOrdered($id); break;
  1326.                 case 'models': $values = $em->getRepository('App\Entity\Slave\ProductModel')->findByProducerAndSubcategoryOrdered($id, $id2); break;
  1327.                 case 'suppliers': $values = $em->getRepository('App\Entity\Slave\Supplier')->findByModelOrdered($id); break;
  1328.                 default: break;
  1329.             }
  1331.             $first = true;
  1332.             $json = "[";
  1333.             foreach($values as $v){
  1334.                 if($first) $first = false; else $json.= ',';
  1335.                 $json.= '{"id":'.$v->getId().', "name":'.json_encode($v->getName()).'}';
  1336.             }
  1337.             $json.= "]";
  1338.         
  1339.             return new Response(json_encode(array("code" => 200, "success" => true, "values" => $json))); 
  1340.         }
  1342.         /**
  1343.          * @Route("/aggiorna-rigenerati-fornitori", name="user_product_regenerate_suppliers_update")
  1344.          */
  1345.         public function userProductRegenerateSuppliersUpdate(Request $request)
  1346.         {    
  1347.             $em = $this->mr->getManager('slave');
  1348.             $productRegenerated = $em->getRepository('App\Entity\Slave\ProductRegenerated')->findOneById($request->request->get('productRegeneratedId'));
  1349.             $first = true;
  1350.             $json = "[";
  1351.             foreach($productRegenerated->getProduct()->getSuppliers() as $supplier){
  1352.                 if($first) $first = false; else $json.= ',';
  1353.                 $name = $supplier->getName().' ('.$supplier->getAmountRegenerate().' €)';
  1354.                 $json.= '{"id":'.$supplier->getId().', "name":'.json_encode($name).'}';
  1355.             }
  1356.             $json.= "]";
  1358.             return new Response(json_encode(array("code" => 200, "success" => true, "suppliers" => $json, "startDate" => $productRegenerated->getDatetime()->format("d-m-Y")))); 
  1359.         }
  1360.         
  1361.         /**
  1362.          * @Route("/aggiorna-ticket-termid", name="user_ticket_termid_search")
  1363.          */
  1364.         public function userTicketTermidSearch(Request $request)
  1365.         {
  1366.             $em = $this->mr->getManager('slave');
  1367.             $termidCode = $request->request->get('termidCode');
  1368.             $termid = $em->getRepository('App\Entity\Slave\Termid')->findOneBy(array('code' => $termidCode));
  1370.             $json = '{}';
  1371.             $found = false;
  1372.             if($termid != null){
  1373.                 $found = true;
  1374.                 $client = $termid->getClient();
  1375.                 $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()).'}';
  1376.             }
  1377.         
  1378.             return new Response(json_encode(array("code" => 200, "success" => true, "found" => $found, "json" => $json)));
  1379.         }
  1380.         
  1381.         /**
  1382.          * @Route("/aggiorna-ticket-fornitore-operazioni", name="user_ticket_supplier_operations")
  1383.          */
  1384.         public function userTicketSupplierOperations(Request $request)
  1385.         {
  1386.             $em = $this->mr->getManager('slave');
  1387.             if($request->request->get('supplierId') != null){
  1388.                 $supplier = $em->getRepository('App\Entity\Slave\Supplier')->findOneById($request->request->get('supplierId'));
  1389.                 $operations = $supplier->getOperations();
  1390.             }
  1391.             else{
  1392.                 $operations = $em->getRepository('App\Entity\Slave\Operation')->findAll();
  1393.             }
  1395.             $first = true;
  1396.             $json = '[';
  1397.             foreach($operations as $operation){
  1398.                 if($first) $first = false; else $json.= ',';
  1399.                 $json.= '{"id":'.json_encode($operation->getId()).', "name":'.json_encode($operation->__toString()).'}';
  1400.             }
  1401.             $json.= ']';
  1402.         
  1403.             return new Response(json_encode(array("code" => 200, "success" => true, "operations" => $json)));
  1404.         }
  1405.     //
  1406. }