src/Controller/User/UserController.php line 529

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