src/Controller/User/UserTicketController.php line 3302

Open in your IDE?
  1. <?php
  2. namespace App\Controller\User;
  3. use App\Entity\Master\CityAlias;
  4. use App\Entity\Slave\Client;
  5. use App\Entity\Slave\ClientPhone;
  6. use App\Entity\Slave\Product;
  7. use App\Entity\Slave\Intervention;
  8. use App\Entity\Slave\InterventionActivity;
  9. use App\Entity\Slave\InterventionExtra;
  10. use App\Entity\Slave\Termid;
  11. use App\Entity\Slave\Ticket;
  12. use App\Entity\Slave\TicketReminder;
  13. use App\Entity\Slave\TicketSuspension;
  14. use App\Entity\Slave\Warehouse;
  15. use App\Form\Base\DocumentType;
  16. use App\Form\Master\CityAliasType;
  17. use App\Form\Model\AssignTechnician;
  18. use App\Form\Model\Document;
  19. use App\Form\Model\ImportTicketsSuspend;
  20. use App\Form\Model\ImportTicketsSusUnlock;
  21. use App\Form\Model\ImportTicketCancels;
  22. use App\Form\Model\ImportTicketClosures;
  23. use App\Form\Model\ImportTicketIntervention;
  24. use App\Form\Model\ImportTicketNew;
  25. use App\Form\Slave\AssignTechnicianType;
  26. use App\Form\Slave\ClientEditType;
  27. use App\Form\Slave\InterventionType;
  28. use App\Form\Slave\InterventionActivityType;
  29. use App\Form\Slave\InterventionSlaType;
  30. use App\Form\Slave\InterventionExtraType;
  31. use App\Form\Slave\OperationKeysMappingType;
  32. use App\Form\Slave\TicketType;
  33. use App\Form\Slave\TicketAddressType;
  34. use App\Form\Slave\TicketErrorProvinceType;
  35. use App\Form\Slave\TicketErrorAddressType;
  36. use App\Form\Slave\TicketErrorSupplierType;
  37. use App\Form\Slave\TicketErrorOperationType;
  38. use App\Form\Slave\TicketDeleteType;
  39. use App\Form\Slave\TicketOperationType;
  40. use App\Form\Slave\TicketOperationTariffAmountType;
  41. use App\Form\Slave\TicketExpirationEditType;
  42. use App\Form\Slave\TicketWaybillEditType;
  43. use App\Form\Slave\TicketReminderType;
  44. use App\Form\Slave\TicketSuspensionEditType;
  45. use App\Form\Slave\TicketSuspensionApproveType;
  46. use App\Form\Slave\TicketSuspensionUnlockType;
  47. use App\Form\Slave\ImportTicketCancelsType;
  48. use App\Form\Slave\ImportTicketClosuresType;
  49. use App\Form\Slave\ImportTicketsSuspendType;
  50. use App\Form\Slave\ImportTicketsSusUnlockType;
  51. use App\Form\Slave\ImportTicketInterventionType;
  52. use App\Form\Slave\ImportTicketNewType;
  53. use App\Service\EncryptionService;
  54. use App\Service\FilterService;
  55. use App\Service\FormValidatorService;
  56. use App\Service\ImportService;
  57. use App\Service\MediaService;
  58. use App\Service\ProductService;
  59. use App\Service\TicketService;
  60. use App\Service\UtilitiesService;
  61. use App\Service\ValidationService;
  62. use Doctrine\Persistence\ManagerRegistry;
  63. use Knp\Snappy\Pdf;
  64. use Knp\Component\Pager\PaginatorInterface;
  65. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Security;
  66. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  67. use Symfony\Bridge\Twig\Mime\TemplatedEmail;
  68. use Symfony\Component\DependencyInjection\ParameterBag\ParameterBagInterface;
  69. use Symfony\Component\Filesystem\Filesystem;
  70. use Symfony\Component\Form\FormError;
  71. use Symfony\Component\Form\FormFactoryInterface;
  72. use Symfony\Component\HttpFoundation\Request;
  73. use Symfony\Component\HttpFoundation\Response;
  74. use Symfony\Component\HttpFoundation\ResponseHeaderBag;
  75. use Symfony\Component\HttpFoundation\StreamedResponse;
  76. use Symfony\Component\Mailer\MailerInterface;
  77. use Symfony\Component\PasswordHasher\Hasher\UserPasswordHasherInterface;
  78. use Symfony\Component\Routing\Annotation\Route;
  79. use Symfony\Component\Validator\Validator\ValidatorInterface;
  80. /**
  81.  * @Route("/scrivania/ticket")
  82.  * @Security("is_granted('ROLE_USER') and is_granted('active', user) && is_granted('view', 'ticket')")
  83.  */
  84. class UserTicketController extends AbstractController
  85. {
  86.     private $mr;
  87.     private $params;
  88.     public function __construct(ManagerRegistry $mrParameterBagInterface $params)
  89.     {
  90.         $this->mr $mr;
  91.         $this->params $params;
  92.     }
  93.     public function activityProductByType($em$form$type$suppliers){
  94.         if($form->get('product'.$type.'Id')->getData() != null){
  95.             $product $em->getRepository('App\Entity\Slave\Product')->findOneById($form->get('product'.$type.'Id')->getData());
  96.         }
  97.         else{
  98.             $model $em->getRepository('App\Entity\Slave\ProductModel')->findOneById($form->get('model'.$type.'Id')->getData());
  99.             switch($type){
  100.                 case 'Withdraw'
  101.                     $status $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'not_available'));
  102.                     $condition $em->getRepository('App\Entity\Slave\ProductCondition')->findOneBy(array('slug' => 'broken'));
  103.                     break;
  104.                 case 'Actual':
  105.                     $status $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'in_use'));
  106.                     $condition $em->getRepository('App\Entity\Slave\ProductCondition')->findOneBy(array('slug' => 'free'));
  107.                     break;
  108.                 default: break;
  109.             }
  110.             $product ProductService::createProduct($em$model$form->get('producer'.$type)->getData(), $form->get('supplier'.$type)->getData(), $suppliers$status$condition);
  111.         }
  112.         return $product;
  113.     }
  114.     public function importCheckFile($em$validator$form)
  115.     {
  116.         $row 0;
  117.         $valid true;
  118.         if($valid$valid ValidationService::validateNotBlank($validator$form->get('separator'));
  119.         if($valid$valid ValidationService::validateFile($validator$form->get('path'), true$form->get('file')->getData(), '10', array('csv''txt'));
  120.         if($valid && ($handle fopen($form->get('file')->getData(), "r")) !== FALSE) {
  121.             while(($data fgetcsv($handle2000$form->get('separator')->getData())) !== FALSE) {
  122.                 $data array_map("utf8_encode"$data);
  123.                 if($row 0){
  124.                     $ticket $em->getRepository('App\Entity\Slave\Ticket')->findOneByNumberAndTermid($data[0], $data[1]);
  125.                     if($ticket == null){
  126.                         $valid false;
  127.                         $form->get("path")->addError(new FormError("Ticket non trovato"));
  128.                         $this->addFlash('notice_danger''Il ticket presente alla riga '.$row.' con n° '.$data[0].' e termid '.$data[1].' non è stato trovato! Ricontrolla il file!');
  129.                         break;
  130.                     }
  131.                 }
  132.                 $row++;
  133.             }
  134.             fclose($handle);
  135.         }
  136.         return $valid;
  137.     }
  138.     public function importInterventionCreate($em$ticket$warehouse$datetime)
  139.     {
  140.         $intervention = new Intervention();
  141.         $intervention->setTicket($ticket);
  142.         $intervention->setTechnician($ticket->getTechnician());
  143.         $intervention->setOperator($this->getUser());
  144.         $intervention->setOutcomeType($em->getRepository('App\Entity\Slave\InterventionOutcomeType')->findOneBy(array('slug' => 'completed')));
  145.         $intervention->setOutcome($em->getRepository('App\Entity\Slave\InterventionOutcome')->findOneBy(array('slug' => 'completato-correttamente')));
  146.         $intervention->setWarehouse($warehouse);
  147.         $intervention->setDatetime($datetime);
  148.         $intervention->setDatetimeBilling(date_create_from_format('d-m-Y H:i:s''01-'.$datetime->format('m').'-'.$datetime->format('Y').' 00:00:00'));
  149.         if($ticket->getOperationTariffAmount() != null)
  150.             $intervention->setAmount($ticket->getOperationTariffAmount()->getAmount());
  151.         $intervention->setAmountTechnician('0.00');
  152.         $intervention->setBillable(true);
  153.         $em->persist($intervention);
  154.         return $intervention;
  155.     }
  156.     public function importInterventionSearchProduct($em$code$supplier){
  157.         $product $em->getRepository('App\Entity\Slave\Product')->findOneBy(array('codeProducer' => $code));
  158.         if($product == null)
  159.             $product $em->getRepository('App\Entity\Slave\Product')->findOneBy(array('codeSupplier' => $code));
  160.         return $product;
  161.     }
  162.     public function importInterventionActivity($em$ticket$intervention$activityType$isDisi$prodOld$prodNew$warehouse$datetime)
  163.     {
  164.         $activity = new InterventionActivity();
  165.         $activity->setIntervention($intervention);
  166.         $activity->setType($activityType);
  167.         $skip false;
  168.         if($prodOld != null && $prodNew != null && ($prodNew->getCodeProducer() == $prodOld->getCodeProducer() || $prodNew->getCodeProducer() == '0'.$prodOld->getCodeProducer()))
  169.             $skip true;
  170.         if($prodOld != null){
  171.             $activity->setProductWithdraw($prodOld);
  172.             $activity->setProducerWithdraw($prodOld->getCodeProducer());
  173.             $activity->setSupplierWithdraw($prodOld->getCodeSupplier());
  174.             $newWarehouse $warehouse;
  175.             if($prodOld->movedByDS())
  176.                 $newWarehouse $prodOld->getActualWarehouse();
  177.             else{
  178.                 $prodOld->setStatus($em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'not_available')));
  179.                 $prodOld->setCondition($em->getRepository('App\Entity\Slave\ProductCondition')->findOneBy(array('slug' => 'broken')));
  180.             }
  181.             $prodOld->setActualWarehouse($ticket->getClient()->getWarehouse());
  182.             ProductService::createProductTransferLog($em$prodOldnull$this->getUser(), $warehouse$datetime'forced');
  183.             $prodOld->setActualWarehouse($newWarehouse);
  184.         }
  185.         if($prodNew != null && !$skip){
  186.             if($isDisi){
  187.                 $activity->setProductWithdraw($prodNew);
  188.                 $activity->setProducerWithdraw($prodNew->getCodeProducer());
  189.                 $activity->setSupplierWithdraw($prodNew->getCodeSupplier());
  190.                 $newWarehouse $warehouse;
  191.                 if($prodNew->movedByDS())
  192.                     $newWarehouse $prodNew->getActualWarehouse();
  193.                 else{
  194.                     $prodNew->setStatus($em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'not_available')));
  195.                     $prodNew->setCondition($em->getRepository('App\Entity\Slave\ProductCondition')->findOneBy(array('slug' => 'broken')));
  196.                 }
  197.                 $prodNew->setActualWarehouse($ticket->getClient()->getWarehouse());
  198.                 ProductService::createProductTransferLog($em$prodNewnull$this->getUser(), $warehouse$datetime'forced');
  199.                 $prodNew->setActualWarehouse($newWarehouse);
  200.             }
  201.             else{
  202.                 $activity->setProductInstallation($prodNew);
  203.                 $activity->setProducerInstallation($prodNew->getCodeProducer());
  204.                 $activity->setSupplierInstallation($prodNew->getCodeSupplier());
  205.                 $newWarehouse $ticket->getClient()->getWarehouse();
  206.                 if($prodNew->movedByDS())
  207.                     $newWarehouse $prodNew->getActualWarehouse();
  208.                 else{
  209.                     $prodNew->setTermid($ticket->getTermid());
  210.                     $prodNew->setStatus($em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'in_use')));
  211.                     $prodNew->setCondition($em->getRepository('App\Entity\Slave\ProductCondition')->findOneBy(array('slug' => 'free')));
  212.                 }
  213.                 $prodNew->setActualWarehouse($warehouse);
  214.                 ProductService::createProductTransferLog($em$prodNewnull$this->getUser(), $ticket->getClient()->getWarehouse(), $datetime'forced');
  215.                 $prodNew->setActualWarehouse($newWarehouse);
  216.             }
  217.         }
  218.         $em->persist($activity);
  219.     }
  220.     public function deleteTicketAndConnectedValues($em$ticket){
  221.         $termid $ticket->getTermid();
  222.         $client $ticket->getClient();
  223.         if($termid != null){
  224.             if(sizeof($termid->getTickets()) == 1){
  225.                 foreach($termid->getProducts() as $pr)
  226.                     $pr->setTermid(null);
  227.                 $em->remove($termid);
  228.             }
  229.         }
  230.         if($ticket->getClient() != null){
  231.             if(sizeof($client->getTermids()) == && sizeof($client->getTickets()) == && sizeof($client->getFiles()) == && $client->getWarehouse()->canDelete()){
  232.                 foreach($client->getPhones() as $phone)
  233.                     $em->remove($phone);
  234.                 $em->remove($client->getWarehouse());
  235.                 $em->remove($client);
  236.             }
  237.         }
  238.         $em->remove($ticket);
  239.     }
  240.     public function deleteProductAlreadyInserted($em$product)
  241.     {
  242.         foreach($product->getTransferLogs() as $transferLog)
  243.             $em->remove($transferLog);
  244.         foreach($product->getLogs() as $log)
  245.             $em->remove($log);
  246.         $em->remove($product);
  247.         $em->flush();
  248.     }
  249.     // SCRIVANIA
  250.         /**
  251.          * @Route("/sblocca-materiale-mancante", name="user_ticket_unlock_waiting_material")
  252.          */
  253.         public function userTicketUnlockWaitingMaterial(Request $request)
  254.         {    
  255.             $em $this->mr->getManager('slave');
  256.             $ticket $em->getRepository('App\Entity\Slave\Ticket')->findOneById($request->request->get('ticketId'));
  257.             foreach($ticket->getSuspensions() as $s){
  258.                 if(!$s->isUnlocked())
  259.                     $suspension $s;
  260.             }
  261.             $unlockCausal "Ticket sbloccato per materiale mancante ricevuto";
  262.             $suspension->unlock($unlockCausal, new \DateTime(), $em);
  263.             $em->flush();
  264.             $response = array("code" => 200"success" => true);
  265.             return new Response(json_encode($response)); 
  266.         }
  267.     //
  268.     // SCARICA
  269.         /**
  270.          * @Route("/scarica-da-email", name="user_ticket_download_email")
  271.          * @Security("is_granted('edit', 'ticket')")
  272.          */
  273.         public function userTicketDownloadEmail(Request $request)
  274.         {
  275.             $emMaster $this->mr->getManager('master');
  276.             $session $request->getSession();
  277.             $company $emMaster->getRepository('App\Entity\Master\Company')->findOneById($session->get('companyId'));
  278.             $mailbox "{in.postassl.it:993/imap/ssl}INBOX";
  279.             $mailboxOther "{in.postassl.it:993/imap/ssl}INBOX.other";
  280.             $em $this->mr->getManager('slave');
  281.             foreach($company->getMailers() as $mailer){
  282.                 $count 0;
  283.                 $countTicket 0;
  284.                 $countTicketError 0;
  285.                 $inboxOther imap_open($mailboxOther$mailer->getUser(), EncryptionService::decrypt($mailer->getPassword())) or die('Impossibile connettersi alla casella email: '.imap_last_error()); // Connessione alla casella email
  286.                 imap_expunge($inboxOther); // Elimina le mail "marcate"
  287.                 imap_close($inboxOther); // Chiude la connessione
  288.                 
  289.                 $inbox imap_open($mailbox$mailer->getUser(), EncryptionService::decrypt($mailer->getPassword())) or die('Impossibile connettersi alla casella email: '.imap_last_error()); // Connessione alla casella email
  290.                 imap_expunge($inbox); // Elimina le mail "marcate"
  291.                 $emails imap_search($inbox'ALL'); // Cerca tutte le email da leggere
  292.                 $testing $this->params->get('ticket_download_testing');
  293.                 $error false;
  294.                 if($emails){
  295.                     rsort($emails); // Ordino con la più nuova in cima
  296.                     foreach($emails as $email){
  297.                         if($count 600){
  298.                             // INOLTRO A THEBURMANUTENZIONE@GMAIL.COM
  299.                             if($company->getCode() == "BBQV25"){
  300.                                 $overview imap_fetch_overview($inbox$email0);
  301.                                 $isRead = isset($overview[0]->seen) && $overview[0]->seen == 1;
  302.                                 if(!$isRead){
  303.                                     $header imap_headerinfo($inbox$email); // Gestisco l'header                            
  304.                                     // Serve per skippare le email che non hanno mittente o di spam
  305.                                     if(property_exists($header'from') && property_exists($header->from[0], 'host'))
  306.                                         $sender $header->from[0]->mailbox."@".$header->from[0]->host;
  307.                                     if($sender == "thebur.manutenzioni@gmail.com"){
  308.                                         $body imap_fetchbody($inbox$email1);
  309.                                         $subject $header->subject;
  310.                                         $to 'thebur.integrations@gmail.com';
  311.         
  312.                                         $headers "From: $sender\r\n";
  313.                                         $headers .= "Reply-To: $sender\r\n";
  314.                                         $headers .= "X-Mailer: PHP/" phpversion();
  315.         
  316.                                         mail($to$subject$body$headers);
  317.                                         imap_setflag_full($inbox$email"\\SEEN");
  318.                                     }
  319.                                 }
  320.                             }
  321.                             [$countTicket$countTicketError] = TicketService::downloadTicket($em$emMaster$inbox$email$mailer$testing$company,$countTicket$countTicketError);
  322.                         }
  323.                         else
  324.                             break;
  325.                         $count++;
  326.                     }
  327.                 }
  328.                 if(!$testing){
  329.                     imap_expunge($inbox); // Elimina le mail "marcate"
  330.                     imap_close($inbox); // Chiude la connessione
  331.                 }
  332.                 
  333.                 if($countTicketError 0)
  334.                     $noticeType "notice_warning";
  335.                 else
  336.                     $noticeType "notice_success";
  337.                 $this->addFlash($noticeType'Casella '.$mailer->getUser().':<br>E-mail processate: '.$count.'<br>Ticket scaricati: '.$countTicket.'<br>Ticket con errori: '.$countTicketError);
  338.             }
  339.             return $this->redirectToRoute("user_ticket_list");
  340.         }
  341.         
  342.         /**
  343.          * @Route("/scarica-da-email-altro", name="user_ticket_download_email_other")
  344.          * @Security("is_granted('edit', 'ticket')")
  345.          */
  346.         public function userTicketDownloadEmailOther(Request $request)
  347.         {
  348.             $session $request->getSession();
  349.             $emMaster $this->mr->getManager('master');
  350.             $company $emMaster->getRepository('App\Entity\Master\Company')->findOneById($session->get('companyId'));
  351.             $mailbox "{in.postassl.it:993/imap/ssl}INBOX.other";
  352.             $mailboxIncoming "{in.postassl.it:993/imap/ssl}INBOX";
  353.             $em $this->mr->getManager('slave');
  354.             
  355.             foreach($company->getMailers() as $mailer){
  356.                 $count 0;
  357.                 $countTicket 0;
  358.                 $countTicketError 0;
  359.                 $inboxIncoming imap_open($mailboxIncoming$mailer->getUser(), EncryptionService::decrypt($mailer->getPassword())) or die('Impossibile connettersi alla casella email: '.imap_last_error()); // Connessione alla casella email
  360.                 imap_expunge($inboxIncoming); // Elimina le mail "marcate"
  361.                 imap_close($inboxIncoming); // Chiude la connessione
  362.                 $inbox imap_open($mailbox$mailer->getUser(), EncryptionService::decrypt($mailer->getPassword())) or die('Impossibile connettersi alla casella email: '.imap_last_error()); // Connessione alla casella email
  363.                 imap_expunge($inbox); // Elimina le mail "marcate"
  364.                 $emails imap_search($inbox'UNSEEN'); // Cerca tutte le email da leggere
  365.                 $testing $this->params->get('ticket_download_testing');;
  366.                 $error false;
  367.                 if($emails){
  368.                     rsort($emails); // Ordino con la più nuova in cima
  369.                     foreach($emails as $email){
  370.                         if($count 600){
  371.                             // INOLTRO A THEBURMANUTENZIONE@GMAIL.COM
  372.                             if($company->getCode() == "BBQV25"){
  373.                                 $overview imap_fetch_overview($inbox$email0);
  374.                                 $isRead = isset($overview[0]->seen) && $overview[0]->seen == 1;
  375.                                 if(!$isRead){
  376.                                     $header imap_headerinfo($inbox$email); // Gestisco l'header                            
  377.                                     // Serve per skippare le email che non hanno mittente o di spam
  378.                                     if(property_exists($header'from') && property_exists($header->from[0], 'host'))
  379.                                         $sender $header->from[0]->mailbox."@".$header->from[0]->host;
  380.                                     if($sender == "thebur.manutenzioni@gmail.com"){
  381.                                         $body imap_fetchbody($inbox$email1);
  382.                                         $subject $header->subject;
  383.                                         $to 'thebur.integrations@gmail.com';
  384.         
  385.                                         $headers "From: $sender\r\n";
  386.                                         $headers .= "Reply-To: $sender\r\n";
  387.                                         $headers .= "X-Mailer: PHP/" phpversion();
  388.         
  389.                                         mail($to$subject$body$headers);
  390.                                         imap_setflag_full($inbox$email"\\SEEN");
  391.                                     }
  392.                                 }
  393.                             }
  394.                             [$countTicket$countTicketError] = TicketService::downloadTicket($em$emMaster$inbox$email$mailer$testing$company,$countTicket$countTicketError);
  395.                         }
  396.                         else
  397.                             break;
  398.                         $count++;
  399.                     }
  400.                 }
  401.                 if(!$testing){
  402.                     imap_expunge($inbox); // Elimina le mail "marcate"
  403.                     imap_close($inbox); // Chiude la connessione
  404.                 }
  405.                 
  406.                 if($countTicketError 0)
  407.                     $noticeType "notice_warning";
  408.                 else
  409.                     $noticeType "notice_success";
  410.                 $this->addFlash($noticeType'Casella '.$mailer->getUser().':<br>E-mail processate: '.$count.'<br>Ticket scaricati: '.$countTicket.'<br>Ticket con errori: '.$countTicketError);
  411.             }
  412.             return $this->redirectToRoute("user_ticket_list");
  413.         }
  414.     //
  415.     // IMPORTA CSV
  416.         /**
  417.          * @Route("/importa", name="user_ticket_import")
  418.          * @Security("is_granted('edit', 'ticket')")
  419.          */
  420.         public function userTicketImport(Request $requestValidatorInterface $validatorFormFactoryInterface $formFactory)
  421.         {    
  422.             $em $this->mr->getManager('slave');
  423.             $emMaster $this->mr->getManager('master');
  424.             $session $request->getSession();
  425.             $company $emMaster->getRepository('App\Entity\Master\Company')->findOneById($session->get('companyId'));
  426.             
  427.             $arraySuppliers = [];
  428.             $masterSuppliersIds = [];
  429.             foreach($company->getSuppliers() as $jtcs){
  430.                 array_push($masterSuppliersIds$jtcs->getSupplier()->getId());
  431.             }
  432.             foreach($masterSuppliersIds as $sId){
  433.                 $supplier $em->getRepository('App\Entity\Slave\Supplier')->findOneBy(['idSupplier' => $sId]);
  434.                 switch($supplier->getSlug()){
  435.                     case 'bcc-pos'$arraySuppliers['BCC Pos'] = 'bcc-pos'; break;
  436.                     case 'fabrick'$arraySuppliers['Fabrick'] = 'fabrick'; break;
  437.                     case 'nexi-book-meps':
  438.                     case 'nexi-book-monetica':
  439.                         $arraySuppliers['Nexi (Book MEPS o Book Monetica)'] = 'nexi';
  440.                         break;
  441.                     case 'nexi-book-sia'$arraySuppliers['NEXI Book SIA'] = 'nexi-book-sia'; break;
  442.                     case 'worldline-italia'$arraySuppliers['Worldline Italia'] = 'worldline-italia'; break;
  443.                     case 'csc---axerve':
  444.                     case 'csc---cglobal':
  445.                     case 'csc---cronos':
  446.                     case 'csc---cse':
  447.                     case 'csc---decathlon':
  448.                     case 'csc---euronet':
  449.                     case 'csc---lis-pay':
  450.                     case 'csc---mooney':
  451.                     case 'csc---nexi-book-meps':
  452.                     case 'csc---nexi-book-monetica':
  453.                     case 'csc---nexi-book-sia':
  454.                     case 'csc---numera':
  455.                     case 'csc---p4cards':
  456.                     case 'csc---q8':
  457.                     case 'csc---repas':
  458.                     case 'csc---worldline-italia':
  459.                     case 'csc---yamamay':
  460.                         $arraySuppliers['CSC'] = 'csc';
  461.                         break;
  462.                     case 'sate---worldline':
  463.                     case 'sate---numera':
  464.                     case 'sate---mooney':
  465.                     case 'sate---flagpay':
  466.                     case 'sate---argentea':
  467.                         $arraySuppliers['SATE'] = 'sate';
  468.                         break;
  469.                     default: break;
  470.                 }
  471.             }
  472.             // NUOVI TICKET
  473.             $operationId null;
  474.             $importTicketNew = new ImportTicketNew();
  475.             $formTicket $formFactory->createNamed("form_import_ticket_new"ImportTicketNewType::class, $importTicketNew, array('suppliers' => $arraySuppliers));
  476.             $formTicket->handleRequest($request);
  477.             if($formTicket->isSubmitted()){
  478.                 $valid true;
  479.                 if($valid$valid ValidationService::validateNotBlank($validator$formTicket->get('supplier'));
  480.                 if($valid && $formTicket->get('supplier')->getData() == 'nexi-book-sia'){
  481.                     $valid ValidationService::validateNotBlank($validator$formTicket->get('operation'));
  482.                     $operationId $formTicket->get('operation')->getData();
  483.                 }
  484.                 if($valid$valid ValidationService::validateNotBlank($validator$formTicket->get('separator'));
  485.                 if($valid$valid ValidationService::validateFile($validator$formTicket->get('file'), true$formTicket->get('file')->getData(), '10', array('csv''txt''bin'));
  486.                 if($valid && $formTicket->isValid()){
  487.                     $error false;
  488.                     $row 0;
  489.                     $countInserted 0;
  490.                     switch($formTicket->get('supplier')->getData()){
  491.                         case 'bcc-pos':
  492.                         case 'fabrick':
  493.                         case 'lis-holding':
  494.                         case 'nexi':
  495.                         case 'nexi-book-sia':
  496.                         case 'sate':
  497.                         case 'worldline-italia':
  498.                             [$error$row$countInserted] = TicketService::importFile($em$emMaster$formTicket$company$operationId$row);
  499.                             break;
  500.                         case 'csc'// CSC
  501.                             [$error$row$countInserted] = TicketService::importFileCSC($em$emMaster$formTicket$error$row$countInserted);
  502.                             break;
  503.                         default: break;
  504.                     }
  505.                     if($error)
  506.                         $this->addFlash('notice_warning''Un totale di '.$countInserted.' su '.($row 1).' ticket è stato scaricato dal file CSV, alcuni presentano degli errori!');
  507.                     else
  508.                         $this->addFlash('notice_success''Un totale di '.$countInserted.' su '.($row 1).' ticket è stato scaricato dal file CSV senza errori!');
  509.                     return $this->redirectToRoute('user_ticket_list');
  510.                 }
  511.             }
  512.             // INTERVENTI
  513.             $importTicketIntervention = new ImportTicketIntervention();
  514.             $formIntervention $formFactory->createNamed("form_import_ticket_intervention"ImportTicketInterventionType::class, $importTicketIntervention);
  515.             $formIntervention->handleRequest($request);
  516.             if($formIntervention->isSubmitted()){
  517.                 
  518.                 $valid true;
  519.                 if($valid$valid ValidationService::validateNotBlank($validator$formIntervention->get('separator'));
  520.                 if($valid$valid ValidationService::validateFile($validator$formIntervention->get('file'), true$formIntervention->get('file')->getData(), '10', array('csv''txt'));
  521.                 $row 0;
  522.                 if(($handle fopen($formIntervention->get('file')->getData(), "r")) !== FALSE) {
  523.                     while(($data fgetcsv($handle2000$formIntervention->get('separator')->getData())) !== FALSE) {
  524.                         // Salta righe vuote
  525.                         if(empty(array_filter($data))) {$row++; continue; }
  526.                         $data array_map("utf8_encode"$data);
  527.                         if($row 0){
  528.                             $ticket null;
  529.                             $nTicket null;
  530.                             $termid null;
  531.                             switch($formIntervention->get('supplier')->getData()){
  532.                                 case 'fabrick-flex':
  533.                                     $ticket $em->getRepository('App\Entity\Slave\Ticket')->findOneByLikeNumberAndTermid($data[1], $data[2]);
  534.                                     if($ticket == null){
  535.                                         $valid false;
  536.                                         $formIntervention->get("path")->addError(new FormError("Ticket non trovato"));
  537.                                         $this->addFlash('notice_danger''Il ticket presente alla riga '.($row 1).' con n° '.$data[1].' e termid '.$data[2].' non è stato trovato! Ricontrolla il file!');
  538.                                         break;
  539.                                     }
  540.                                     if($valid){
  541.                                         $prodPos $this->importInterventionSearchProduct($em$data[9], $ticket->getSupplier());
  542.                                         if($prodPos == null){
  543.                                             $valid false;
  544.                                             $formIntervention->get("path")->addError(new FormError("Matricola non presente"));
  545.                                             $this->addFlash('notice_danger''Non è stato trovato il prodotto presente alla riga '.($row 1).' con matricola '.$data[9].' ! Ricontrolla il file!');
  546.                                             break;
  547.                                         }
  548.                                     }
  549.                                     if($valid){
  550.                                         $prodSim $this->importInterventionSearchProduct($em$data[10], $ticket->getSupplier());
  551.                                         if($prodSim == null){
  552.                                             $valid false;
  553.                                             $formIntervention->get("path")->addError(new FormError("Matricola non presente"));
  554.                                             $this->addFlash('notice_danger''Non è stato trovato il prodotto presente alla riga '.($row 1).' con matricola '.$data[10].'! Ricontrolla il file!');
  555.                                             break;
  556.                                         }
  557.                                     }
  558.                                     break;
  559.                                 default: break;
  560.                             }
  561.                         }
  562.                         $row++;
  563.                     }
  564.                     fclose($handle);
  565.                 }
  566.                 
  567.                 if($valid && $formIntervention->isValid()){
  568.                     $actualNumber 0;
  569.                     $actualTermid 0;
  570.                     $ignored false;
  571.                     $continueIntervention false;
  572.                     $row 0;
  573.                     $ticketStatusClosed $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'closed'));
  574.                     $countClosed 0;
  575.                     $countIgnored 0;
  576.                     if(($handle fopen($formIntervention->get('file')->getData(), "r")) !== FALSE) {
  577.                         while(($data fgetcsv($handle2000$formIntervention->get('separator')->getData())) !== FALSE) {
  578.                             $data array_map("utf8_encode"$data);
  579.                             if($row 0){
  580.                                 switch($formIntervention->get('supplier')->getData()){
  581.                                     case 'fabrick-flex'// FABRICK FLEX
  582.                                         $ticket $em->getRepository('App\Entity\Slave\Ticket')->findOneByLikeNumberAndTermid($data[1], $data[2]);
  583.                                         if($ticket != null && ($ticket->getStatus()->getSlug() == "closed" || $ticket->getStatus()->getSlug() != "closed_portal"))
  584.                                             $countIgnored++;
  585.                                         if($ticket != null && $ticket->getStatus()->getSlug() != "to_assign" && $ticket->getStatus()->getSlug() != "closed" && $ticket->getStatus()->getSlug() != "closed_portal" && $ticket->getStatus()->getSlug() != "wrong" && $ticket->getStatus()->getSlug() != "canceled"){
  586.                                             $warehouse $ticket->getTechnician()->mainWarehouse();
  587.                                             
  588.                                             // Inserisco intervento
  589.                                             $datetime date_create_from_format('m/d/Y'$data[12]);
  590.                                             $intervention $this->importInterventionCreate($em$ticket$warehouse$datetime);
  591.                                             // Cerco o creo i prodotti del ticket
  592.                                             $pPos $this->importInterventionSearchProduct($em$data[9], $ticket->getSupplier());
  593.                                             $pSim $this->importInterventionSearchProduct($em$data[10], $ticket->getSupplier());
  594.                                             // Inserisco le attività
  595.                                             $activityTypePos $em->getRepository('App\Entity\Slave\InterventionActivityType')->findOneBy(array('slug' => 'installato-pos-fabrick-flex'));
  596.                                             $activityTypeSim $em->getRepository('App\Entity\Slave\InterventionActivityType')->findOneBy(array('slug' => 'installato-accessorio-fabrick-flex'));
  597.                                             $this->importInterventionActivity($em$ticket$intervention$activityTypePosfalsenull$pPos$warehouse$datetime);
  598.                                             $this->importInterventionActivity($em$ticket$intervention$activityTypeSimfalsenull$pSim$warehouse$datetime);
  599.                                             $ticket->setStatus($ticketStatusClosed);
  600.                                             $ticket->setWaybill($data[11]);
  601.                                             $ticket->setDatetimeEnd(new \Datetime());
  602.                                             $em->flush();
  603.                                             $countClosed++;
  604.                                         }
  605.                                         break;
  606.                                     default: break;
  607.                                 }
  608.                             }
  609.                             $row++;
  610.                         }
  611.                         fclose($handle);
  612.                     }
  613.                     $em->flush();
  614.                     $this->addFlash('notice_success''Sono stati inseriti '.$countClosed.' interventi e sono stati ignorati '.$countIgnored.' interventi perché già chiusi!');
  615.                     return $this->redirectToRoute('user_ticket_list');
  616.                 }
  617.             }
  618.             // CHIUSURE PORTALE
  619.             $statusClosedPortal $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'closed_portal'));
  620.             $ticketClosures = new ImportTicketClosures();
  621.             $formClosures $formFactory->createNamed("form_import_ticket_closures"ImportTicketClosuresType::class, $ticketClosures);
  622.             $formClosures->handleRequest($request);
  623.             if($formClosures->isSubmitted()){
  624.                 
  625.                 $valid true;
  626.                 if($valid$valid ValidationService::validateNotBlank($validator$formClosures->get('separator'));
  627.                 if($valid$valid ValidationService::validateFile($validator$formClosures->get('file'), true$formClosures->get('file')->getData(), '10', array('csv''txt'));
  628.                 if($valid$valid $this->importCheckFile($em$validator$formClosures);
  629.                 if($valid && $formClosures->isValid()){
  630.                     $row 0;
  631.                     $counterNotUpdated 0;
  632.                     $counterClosed 0;
  633.                     $counterAlreadyClosed 0;
  634.                     if(($handle fopen($formClosures->get('file')->getData(), "r")) !== FALSE) {
  635.                         while(($data fgetcsv($handle2000$formClosures->get('separator')->getData())) !== FALSE) {
  636.                             $data array_map("utf8_encode"$data);
  637.                             if($row 0){
  638.                                 $ticket $em->getRepository('App\Entity\Slave\Ticket')->findOneByNumberAndTermid($data[0], $data[1]);
  639.                                 if($ticket != null){
  640.                                     $ticket->setClosedOnPortal(true);
  641.                                     switch($ticket->getStatus()->getSlug()){
  642.                                         case 'closed'$ticket->setStatus($statusClosedPortal); $counterClosed++; break;
  643.                                         case 'closed_portal'$counterAlreadyClosed++; break;
  644.                                         default: $counterNotUpdated++; break;
  645.                                     }
  646.                                 }
  647.                             }
  648.                             $row++;
  649.                         }
  650.                         fclose($handle);
  651.                     }
  652.                     $em->flush();
  653.                     $this->addFlash('notice_success''Ticket chiusi: '.$counterClosed.'<br>Ticket già chiusi: '.$counterAlreadyClosed.'<br>Ticket stato non aggiornato: '.$counterNotUpdated);
  654.                     return $this->redirectToRoute('user_ticket_list');
  655.                 }
  656.             }
  657.             // ANNULLA TICKET
  658.             $statusCanceled $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'canceled'));
  659.             $ticketCancels = new ImportTicketCancels();
  660.             $formCancels $formFactory->createNamed("form_import_ticket_cancels"ImportTicketCancelsType::class, $ticketCancels);
  661.             $formCancels->handleRequest($request);
  662.             if($formCancels->isSubmitted()){
  663.                 
  664.                 $valid true;
  665.                 if($valid$valid ValidationService::validateNotBlank($validator$formCancels->get('separator'));
  666.                 if($valid$valid ValidationService::validateFile($validator$formCancels->get('file'), true$formCancels->get('file')->getData(), '10', array('csv''txt'));
  667.                 if($valid$valid $this->importCheckFile($em$validator$formCancels);
  668.                 if($valid && $formCancels->isValid()){
  669.                     $row 0;
  670.                     if(($handle fopen($formCancels->get('file')->getData(), "r")) !== FALSE) {
  671.                         while(($data fgetcsv($handle2000$formCancels->get('separator')->getData())) !== FALSE) {
  672.                             $data array_map("utf8_encode"$data);
  673.                             if($row 0){
  674.                                 $ticket $em->getRepository('App\Entity\Slave\Ticket')->findOneByNumberAndTermid($data[0], $data[1]);
  675.                                 if($ticket != null){
  676.                                     $ticket->setStatus($statusCanceled);
  677.                                 }
  678.                             }
  679.                             $row++;
  680.                         }
  681.                         fclose($handle);
  682.                     }
  683.                     $em->flush();
  684.                     $this->addFlash('notice_success''Ticket annullati!');
  685.                     return $this->redirectToRoute('user_ticket_list');
  686.                 }
  687.             }
  688.             // SOSPENDI TICKET
  689.             $statusSuspended $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'suspended'));
  690.             $interventionOutcomeTypeSuspended $em->getRepository('App\Entity\Slave\InterventionOutcomeType')->findOneBy(array('slug' => 'suspended'));
  691.             $interventionOutcomeSuspendedMassiva $em->getRepository('App\Entity\Slave\InterventionOutcome')->findOneBy(array('slug' => 'suspended-massiva'));
  692.             $ticketsSuspend = new ImportTicketsSuspend();
  693.             $formSuspend $formFactory->createNamed("form_import_tickets_suspend"ImportTicketsSuspendType::class, $ticketsSuspend);
  694.             $formSuspend->handleRequest($request);
  695.             if($formSuspend->isSubmitted()){
  696.                 
  697.                 $valid true;
  698.                 if($valid$valid ValidationService::validateNotBlank($validator$formSuspend->get('causal'));
  699.                 if($valid$valid $this->importCheckFile($em$validator$formSuspend);
  700.                 if($valid && $formSuspend->isValid()){
  701.                     $row 0;
  702.                     if(($handle fopen($formSuspend->get('file')->getData(), "r")) !== FALSE) {
  703.                         while(($data fgetcsv($handle2000$formSuspend->get('separator')->getData())) !== FALSE) {
  704.                             $data array_map("utf8_encode"$data);
  705.                             if($row 0){
  706.                                 $ticket $em->getRepository('App\Entity\Slave\Ticket')->findOneByNumberAndTermid($data[0], $data[1]);
  707.                                 if($ticket != null){
  708.                                     $today = new \Datetime();
  709.                                     $intervention = new Intervention();
  710.                                     $intervention->setTicket($ticket);
  711.                                     $intervention->setOutcomeType($interventionOutcomeTypeSuspended);
  712.                                     $intervention->setOutcome($interventionOutcomeSuspendedMassiva);
  713.                                     $intervention->setDatetime(new \Datetime());
  714.                                     $intervention->setDatetimeBilling(date_create_from_format('d-m-Y H:i:s''01-'.$today->format('m').'-'.$today->format('Y').' 00:00:00'));
  715.                                     $intervention->setBillable(false);
  716.                                     $em->persist($intervention);
  717.                     
  718.                                     $ticketSuspension = new TicketSuspension();
  719.                                     $ticketSuspension->setTicket($ticket);
  720.                                     $ticketSuspension->setIntervention($intervention);
  721.                                     $ticketSuspension->setDatetimeFrom(new \Datetime());
  722.                                     $ticketSuspension->setApproved(true);
  723.                                     $ticketSuspension->setManaged(true);
  724.                                     $ticketSuspension->setUnlockCausal($formSuspend->get('causal')->getData());
  725.                                     $ticketSuspension->setRefuseMotivation(null);
  726.                                     $em->persist($ticketSuspension);
  727.                     
  728.                                     $settingUnlockSameTech $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'ticket_suspension_unlock_same_technician'));
  729.                                     if($settingUnlockSameTech->getValue() != 1)
  730.                                         $ticket->setTechnician(null);
  731.                                     $ticket->setStatus($statusSuspended);
  732.                                     $em->flush();
  733.                                 }
  734.                             }
  735.                             $row++;
  736.                         }
  737.                         fclose($handle);
  738.                     }
  739.                     $em->flush();
  740.                     $this->addFlash('notice_success''Ticket sospesi!');
  741.                     return $this->redirectToRoute('user_ticket_list');
  742.                 }
  743.             }
  744.             // SBLOCCA SOSPENSIONE TICKET
  745.             $ticketsSusUnlock = new ImportTicketsSusUnlock();
  746.             $formSusUnlock $formFactory->createNamed("form_import_tickets_sus_unlock"ImportTicketsSusUnlockType::class, $ticketsSusUnlock);
  747.             $formSusUnlock->handleRequest($request);
  748.             if($formSusUnlock->isSubmitted()){
  749.                 
  750.                 $valid true;
  751.                 if($valid$valid ValidationService::validateNotBlank($validator$formSusUnlock->get('unlockCausal'));
  752.                 if($valid$valid ValidationService::validateNotBlank($validator$formSusUnlock->get('date'));
  753.                 if($valid$valid ValidationService::validateNotBlank($validator$formSusUnlock->get('hour'));
  754.                 if($valid$valid ValidationService::validateNotBlank($validator$formSusUnlock->get('minute'));
  755.                 if($valid$valid $this->importCheckFile($em$validator$formSusUnlock);
  756.                 if($valid && $formSusUnlock->isValid()){
  757.                     $row 0;
  758.                     if(($handle fopen($formSusUnlock->get('file')->getData(), "r")) !== FALSE) {
  759.                         while(($data fgetcsv($handle2000$formSusUnlock->get('separator')->getData())) !== FALSE) {
  760.                             $data array_map("utf8_encode"$data);
  761.                             if($row 0){
  762.                                 $ticket $em->getRepository('App\Entity\Slave\Ticket')->findOneByNumberAndTermid($data[0], $data[1]);
  763.                                 if($ticket != null){
  764.                                     $datetimeTo date_create_from_format('d-m-Y H:i'$formSusUnlock->get('date')->getData()->format('d-m-Y').' '.$formSusUnlock->get('hour')->getData().':'.$formSusUnlock->get('minute')->getData());
  765.                                     $unlockCausal $formSusUnlock->get('unlockCausal')->getData();
  766.                                     $ticketSuspension $ticket->getActualSuspension();
  767.                                     $ticketSuspension->unlock($unlockCausal$datetimeTo$em);
  768.                                 }
  769.                             }
  770.                             $row++;
  771.                         }
  772.                         fclose($handle);
  773.                     }
  774.                     $em->flush();
  775.                     $this->addFlash('notice_success''Sospensioni sbloccate!');
  776.                     return $this->redirectToRoute('user_ticket_list');
  777.                 }
  778.             }
  779.             return $this->render('role/user/ticket/import.html.twig', array(
  780.                 'formTicket' => $formTicket->createView(),
  781.                 'formIntervention' => $formIntervention->createView(),
  782.                 'formClosures' => $formClosures->createView(),
  783.                 'formCancels' => $formCancels->createView(),
  784.                 'formSuspend' => $formSuspend->createView(),
  785.                 'formSusUnlock' => $formSusUnlock->createView()
  786.             ));
  787.         }
  788.     //
  789.     /**
  790.      * @Route("/", name="user_tickets")
  791.      * @Security("is_granted('view', 'ticket')")
  792.      */
  793.     public function userTickets(Request $request)
  794.     {    
  795.         return $this->render('role/user/ticket/index.html.twig');
  796.     }
  797.     /**
  798.      * @Route("/ricerca", name="user_ticket_search")
  799.      * @Security("is_granted('view', 'ticket')")
  800.      */
  801.     public function userTicketSearch(Request $requestPaginatorInterface $paginator)
  802.     {    
  803.         $em $this->mr->getManager('slave');
  804.         $suppliers $em->getRepository("App\Entity\Slave\Supplier")->findAllOrdered();
  805.         $operationGroups $em->getRepository("App\Entity\Slave\OperationGroup")->findAllOrdered();
  806.         $ticketStatuses $em->getRepository('App\Entity\Slave\TicketStatus')->findAll();
  807.         if($this->getUser()->getAccountTypology() == 'technician'){
  808.             $filters FilterService::ticket3Filter($request);
  809.             $ticketsQuery $em->getRepository("App\Entity\Slave\Ticket")->findByTechnicianFiltered(true$filters$this->getUser()->getId());
  810.             $tickets $paginator->paginate($ticketsQuery$request->getSession()->get($request->get("_route")."_page"), 100);
  811.             $ticketsCount sizeof($em->getRepository("App\Entity\Slave\Ticket")->findByTechnicianFiltered(false$filters$this->getUser()->getId()));
  812.         }
  813.         else{
  814.             $filters FilterService::ticket2Filter($request);
  815.             $ticketsQuery $em->getRepository("App\Entity\Slave\Ticket")->findFiltered(true$filters);
  816.             $tickets $paginator->paginate($ticketsQuery$request->getSession()->get($request->get("_route")."_page"), 100);
  817.             $ticketsCount sizeof($em->getRepository("App\Entity\Slave\Ticket")->findFiltered(false$filters));
  818.         }
  819.         
  820.         return $this->render('role/user/ticket/search.html.twig', array(
  821.             'tickets' => $tickets,
  822.             'ticketsCount' => $ticketsCount,
  823.             'suppliers' => $suppliers,
  824.             'operations' => $operationGroups,
  825.             'filters' => $filters,
  826.             'ticketStatuses' => $ticketStatuses
  827.         ));
  828.     }
  829.     
  830.     /**
  831.      * @Route("/ricerca/esporta-csv", name="user_ticket_search_filter_export")
  832.      * @Security("is_granted('view', 'ticket')")
  833.      */
  834.     public function userTicketSearchFilterExport(Request $request)
  835.     {    
  836.         $em $this->mr->getManager('slave');
  837.         $emMaster $this->mr->getManager('master');
  838.         $session $request->getSession();
  839.         $filters $session->get('user_ticket_search_filters');
  840.         if($this->getUser()->getAccountTypology() == 'technician')
  841.             $tickets $em->getRepository("App\Entity\Slave\Ticket")->findByTechnicianFiltered(false$filters$this->getUser()->getId());
  842.         else
  843.             $tickets $em->getRepository("App\Entity\Slave\Ticket")->findFiltered(false$filters);
  844.         $response = new StreamedResponse();
  845.         $response->setCallback(function() use($emMaster$tickets) {
  846.             $handle fopen('php://output''w+');
  847.             fputcsv($handle, array('Stato','Numero','Termid','Cliente','Operazione','Fornitore','Tariffa','Provincia','Tecnico','Data/Ora ricezione','Data/Ora chiusura','Data/Ora scadenza'), ";"'"'"\\");
  848.             foreach($tickets as $t){
  849.                 $status null;
  850.                 $number null;
  851.                 $termid null;
  852.                 $client null;
  853.                 $operation null;
  854.                 $supplier null;
  855.                 $tariff null;
  856.                 $province null;
  857.                 $technician null;
  858.                 $datetimeStart null;
  859.                 $datetimeEnd null;
  860.                 $datetimeExpiration null;
  861.                 if($t->getStatus() != null$status $t->getStatus()->getValue();
  862.                 if($t->getNumber() != null$number $t->getNumber();
  863.                 if($t->getTermid() != null$termid $t->getTermid()->getCode();
  864.                 if($t->getClient() != null$client $t->getClient()->__toString();
  865.                 if($t->getOperation() != null$operation $t->getOperation()->__toString();
  866.                 if($t->getOperationTariffAmount() != null$tariff $t->getOperationTariffAmount()->getValue();
  867.                 if($t->getSupplier() != null$supplier $t->getSupplier()->__toString();
  868.                 if($t->getIdProvince() != null$province $emMaster->getRepository("App\Entity\Master\Province")->findOneById($t->getIdProvince())->getSign();
  869.                 if($t->getTechnician() != null$technician $t->getTechnician()->__toString();
  870.                 if($t->getDatetimeStart() != null$datetimeStart $t->getDatetimeStart()->format('d-m-Y H:i');
  871.                 if($t->getDatetimeEnd() != null$datetimeEnd $t->getDatetimeEnd()->format('d-m-Y H:i');
  872.                 if($t->getDatetimeExpiration() != null$datetimeExpiration $t->getDatetimeExpiration()->format('d-m-Y H:i');
  873.                 fputcsv($handle, array($status$number$termid$client$operation$supplier$tariff$province$technician$datetimeStart$datetimeEnd$datetimeExpiration), ";"'"'"\\");
  874.             }
  875.             fclose($handle);
  876.         });
  877.         
  878.         $response->setStatusCode(200);
  879.         $dispositionHeader $response->headers->makeDisposition(ResponseHeaderBag::DISPOSITION_ATTACHMENT'Ticket filtrati.csv');
  880.         $response->headers->set('Content-Type''text/csv; charset=ISO-8859-15');
  881.         $response->headers->set('Content-Disposition'$dispositionHeader);
  882.         return $response;
  883.     }
  884.     /**
  885.      * @Route("/lista-tab", name="user_ticket_list_tab")
  886.      * @Security("is_granted('view', 'ticket')")
  887.      */
  888.     public function userTicketListTab(Request $request)
  889.     {    
  890.         $request->getSession()->set('user_ticket_list_tab'$request->request->get('ticketTabOpen'));
  891.         $request->getSession()->set('tab_operation_group'$request->request->get('ticketOperationGroup'));
  892.         $request->getSession()->set('tab_technician'$request->request->get('ticketTechnician'));
  893.         return $this->redirectToRoute('user_ticket_list');
  894.     }
  895.     
  896.     /**
  897.      * @Route("/lista", name="user_ticket_list")
  898.      * @Security("is_granted('view', 'ticket')")
  899.      */
  900.     public function userTicketList(Request $requestPaginatorInterface $paginatorValidatorInterface $validatorFormFactoryInterface $formFactory)
  901.     {    
  902.         $em $this->mr->getManager('slave');
  903.         $emMaster $this->mr->getManager('master');
  904.         $session $request->getSession();
  905.         $cities $emMaster->getRepository("App\Entity\Master\City")->findByName('');
  906.         $settingBackOffice $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'ticket_backoffice_manage'));
  907.         $suppliers $em->getRepository("App\Entity\Slave\Supplier")->findAllOrdered();
  908.         $operationGroups $em->getRepository("App\Entity\Slave\OperationGroup")->findAllOrdered();
  909.         if($this->getUser()->getAccountTypology() == 'agency' || $this->getUser()->getAccountTypology() == 'warehouse'){
  910.             # Agenzia
  911.             $filters FilterService::ticketFilter($request);
  912.             if($session->get('tab_operation_group') != null){
  913.                 $filters['operation'] = $session->get('tab_operation_group');
  914.             }
  915.             if($session->get('tab_technician') != null){
  916.                 $filters['technician'] = $session->get('tab_technician');
  917.             }
  918.             
  919.             $errorTicketsQuery $em->getRepository("App\Entity\Slave\Ticket")->findTicketsErrorFiltered(true$filters);
  920.             $errorTickets $paginator->paginate($errorTicketsQuery$request->getSession()->get($request->get("_route")."_page"), 100);
  921.             $errorCount sizeof($em->getRepository("App\Entity\Slave\Ticket")->findTicketsErrorFiltered(false$filters));
  922.             $toAssignTicketsQuery $em->getRepository("App\Entity\Slave\Ticket")->findTicketsByStatusFiltered(true'to_assign'$filters);
  923.             $toAssignTickets $paginator->paginate($toAssignTicketsQuery$request->getSession()->get($request->get("_route")."_page"), 100);
  924.             $toAssignCount sizeof($em->getRepository("App\Entity\Slave\Ticket")->findTicketsByStatusFiltered(false'to_assign'$filters));
  925.             
  926.             $assignedTicketsQuery $em->getRepository("App\Entity\Slave\Ticket")->findTicketsByStatusFiltered(true'assigned'$filters);
  927.             $assignedTickets $paginator->paginate($assignedTicketsQuery$request->getSession()->get($request->get("_route")."_page"), 100);
  928.             $assignedCount sizeof($em->getRepository("App\Entity\Slave\Ticket")->findTicketsByStatusFiltered(false'assigned'$filters));
  929.             
  930.             $takenChargeTicketsQuery $em->getRepository("App\Entity\Slave\Ticket")->findTicketsByStatusFiltered(true'taken_charge'$filters);
  931.             $takenChargeTickets $paginator->paginate($takenChargeTicketsQuery$request->getSession()->get($request->get("_route")."_page"), 100);
  932.             $takenChargeCount sizeof($em->getRepository("App\Entity\Slave\Ticket")->findTicketsByStatusFiltered(false'taken_charge'$filters));
  933.             
  934.             $suspensionRequestTicketsQuery $em->getRepository("App\Entity\Slave\Ticket")->findTicketsByStatusFiltered(true'suspension_request'$filters);
  935.             $suspensionRequestTickets $paginator->paginate($suspensionRequestTicketsQuery$request->getSession()->get($request->get("_route")."_page"), 100);
  936.             $suspensionRequestCount sizeof($em->getRepository("App\Entity\Slave\Ticket")->findTicketsByStatusFiltered(false'suspension_request'$filters));
  937.             $suspendedTicketsQuery $em->getRepository("App\Entity\Slave\Ticket")->findTicketsByStatusFiltered(true'suspended'$filters);
  938.             $suspendedTickets $paginator->paginate($suspendedTicketsQuery$request->getSession()->get($request->get("_route")."_page"), 100);
  939.             $suspendedCount sizeof($em->getRepository("App\Entity\Slave\Ticket")->findTicketsByStatusFiltered(false'suspended'$filters));
  940.             
  941.             $closedTicketsQuery $em->getRepository("App\Entity\Slave\Ticket")->findTicketsByStatusFiltered(true'closed'$filters);
  942.             $closedTickets $paginator->paginate($closedTicketsQuery$request->getSession()->get($request->get("_route")."_page"), 100);
  943.             $closedCount sizeof($em->getRepository("App\Entity\Slave\Ticket")->findTicketsByStatusFiltered(false'closed'$filters));
  944.             
  945.             $closedPortalTicketsQuery $em->getRepository("App\Entity\Slave\Ticket")->findTicketsByStatusFiltered(true'closed_portal'$filters);
  946.             $closedPortalTickets $paginator->paginate($closedPortalTicketsQuery$request->getSession()->get($request->get("_route")."_page"), 100);
  947.             $closedPortalCount sizeof($em->getRepository("App\Entity\Slave\Ticket")->findTicketsByStatusFiltered(false'closed_portal'$filters));
  948.             
  949.             $canceledTicketsQuery $em->getRepository("App\Entity\Slave\Ticket")->findTicketsByStatusFiltered(true'canceled'$filters);
  950.             $canceledTickets $paginator->paginate($canceledTicketsQuery$request->getSession()->get($request->get("_route")."_page"), 100);
  951.             $canceledCount sizeof($em->getRepository("App\Entity\Slave\Ticket")->findTicketsByStatusFiltered(false'canceled'$filters));
  952.             
  953.             $wrongTicketsQuery $em->getRepository("App\Entity\Slave\Ticket")->findTicketsByStatusFiltered(true'wrong'$filters);
  954.             $wrongTickets $paginator->paginate($wrongTicketsQuery$request->getSession()->get($request->get("_route")."_page"), 100);
  955.             $wrongCount sizeof($em->getRepository("App\Entity\Slave\Ticket")->findTicketsByStatusFiltered(false'wrong'$filters));
  956.             // Assegna ticket
  957.             $ticketsError "Ticket assegnati! Ticket non spostati perché hanno un intervento in corso: ";
  958.             $error false;
  959.             $first true;
  960.             $assignTechnician = new AssignTechnician();
  961.             $formAssignTechnician $formFactory->createNamed("form_assign_technician"AssignTechnicianType::class, $assignTechnician);
  962.             $formAssignTechnician->handleRequest($request);
  963.             if($formAssignTechnician->isSubmitted()){
  964.                 
  965.                 $valid ValidationService::validateNotBlank($validator$formAssignTechnician->get("technician"));
  966.                 if($valid && $formAssignTechnician->isValid()){
  967.                     $statusAssigned $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'assigned'));
  968.                     $ids $request->request->get('ids');
  969.                     $ticketIds explode(','$ids);
  970.                     foreach($ticketIds as $ticketId){
  971.                         $ticket $em->getRepository('App\Entity\Slave\Ticket')->findOneById($ticketId);
  972.                         $interventionId null;
  973.                         foreach($ticket->getInterventions() as $int){
  974.                             if($int->getOutcome() == null){
  975.                                 $interventionId $int->getId();
  976.                                 break;
  977.                             }
  978.                         }
  979.                         if($interventionId == null){
  980.                             $ticket->setTechnician($formAssignTechnician->get("technician")->getData());
  981.                             $ticket->setStatus($statusAssigned);
  982.                         }
  983.                         else{
  984.                             $error true;
  985.                             if($first$first false; else $ticketsError .= ', ';
  986.                             $ticketsError .= $ticket->getNumber();
  987.                         }
  988.                     }
  989.                     $em->flush();
  990.                     if(!$error)
  991.                         $this->addFlash('notice_success'"Tecnico assegnato ai ticket!");
  992.                     else
  993.                         $this->addFlash('notice_success'$ticketsError);
  994.                     return $this->redirectToRoute('user_ticket_list');
  995.                 }
  996.             }
  997.             return $this->render('role/user/ticket/list.html.twig', array(
  998.                 'cities' => $cities,
  999.                 'settingBackOffice' => $settingBackOffice->getValue(),
  1000.                 'errorTickets' => $errorTickets,
  1001.                 'errorCount' => $errorCount,
  1002.                 'toAssignTickets' => $toAssignTickets,
  1003.                 'toAssignCount' => $toAssignCount,
  1004.                 'assignedTickets' => $assignedTickets,
  1005.                 'assignedCount' => $assignedCount,
  1006.                 'takenChargeTickets' => $takenChargeTickets,
  1007.                 'takenChargeCount' => $takenChargeCount,
  1008.                 'suspensionRequestTickets' => $suspensionRequestTickets,
  1009.                 'suspensionRequestCount' => $suspensionRequestCount,
  1010.                 'suspendedTickets' => $suspendedTickets,
  1011.                 'suspendedCount' => $suspendedCount,
  1012.                 'closedTickets' => $closedTickets,
  1013.                 'closedCount' => $closedCount,
  1014.                 'closedPortalTickets' => $closedPortalTickets,
  1015.                 'closedPortalCount' => $closedPortalCount,
  1016.                 'canceledTickets' => $canceledTickets,
  1017.                 'canceledCount' => $canceledCount,
  1018.                 'wrongTickets' => $wrongTickets,
  1019.                 'wrongCount' => $wrongCount,
  1020.                 'suppliers' => $suppliers,
  1021.                 'operations' => $operationGroups,
  1022.                 'filters' => $filters,
  1023.                 'formAssignTechnician' => $formAssignTechnician->createView()
  1024.             ));
  1025.         }
  1026.         if($this->getUser()->getAccountTypology() == 'technician'){
  1027.             # Tecnico
  1028.             $settingTechUnlockSuspension $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'ticket_suspension_unlock_by_technician'));
  1029.             $filters FilterService::ticketTechnicianFilter($request);
  1030.             if($session->get('tab_operation_group') != null){
  1031.                 $filters['all'] = $session->get('tab_operation_group');
  1032.             }
  1033.             if($session->get('numberOrTermid') != null){
  1034.                 $filters['all'] = $session->get('numberOrTermid');
  1035.                 $session->remove('numberOrTermid');
  1036.             }
  1037.             $assignedTicketsQuery $em->getRepository("App\Entity\Slave\Ticket")->findTicketsByUserAndStatusFiltered(true$this->getUser()->getId(), 'assigned'$filters);
  1038.             $assignedTickets $paginator->paginate($assignedTicketsQuery$request->getSession()->get($request->get("_route")."_page"), 100);
  1039.             $assignedCount sizeof($em->getRepository("App\Entity\Slave\Ticket")->findTicketsByUserAndStatusFiltered(false$this->getUser()->getId(), 'assigned'$filters));
  1040.             
  1041.             $takenChargeTicketsQuery $em->getRepository("App\Entity\Slave\Ticket")->findTicketsByUserAndStatusFiltered(true$this->getUser()->getId(), 'taken_charge'$filters);
  1042.             $takenChargeTickets $paginator->paginate($takenChargeTicketsQuery$request->getSession()->get($request->get("_route")."_page"), 100);
  1043.             $takenChargeCount sizeof($em->getRepository("App\Entity\Slave\Ticket")->findTicketsByUserAndStatusFiltered(false$this->getUser()->getId(), 'taken_charge'$filters));
  1044.             
  1045.             $suspensionRequestTicketsQuery $em->getRepository("App\Entity\Slave\Ticket")->findTicketsByUserAndStatusFiltered(true$this->getUser()->getId(), 'suspension_request'$filters);
  1046.             $suspensionRequestTickets $paginator->paginate($suspensionRequestTicketsQuery$request->getSession()->get($request->get("_route")."_page"), 100);
  1047.             $suspensionRequestCount sizeof($em->getRepository("App\Entity\Slave\Ticket")->findTicketsByUserAndStatusFiltered(false$this->getUser()->getId(), 'suspension_request'$filters));
  1048.             $suspendedTicketsQuery $em->getRepository("App\Entity\Slave\Ticket")->findTicketsByUserAndStatusFiltered(true$this->getUser()->getId(), 'suspended'$filters);
  1049.             $suspendedTickets $paginator->paginate($suspendedTicketsQuery$request->getSession()->get($request->get("_route")."_page"), 100);
  1050.             $suspendedCount sizeof($em->getRepository("App\Entity\Slave\Ticket")->findTicketsByUserAndStatusFiltered(false$this->getUser()->getId(), 'suspended'$filters));
  1051.             
  1052.             $closedTicketsQuery $em->getRepository("App\Entity\Slave\Ticket")->findTicketsByUserAndStatusFiltered(true$this->getUser()->getId(), 'closed'$filters);
  1053.             $closedTickets $paginator->paginate($closedTicketsQuery$request->getSession()->get($request->get("_route")."_page"), 100);
  1054.             $closedCount sizeof($em->getRepository("App\Entity\Slave\Ticket")->findTicketsByUserAndStatusFiltered(false$this->getUser()->getId(), 'closed'$filters));
  1055.             
  1056.             $closedPortalTicketsQuery $em->getRepository("App\Entity\Slave\Ticket")->findTicketsByUserAndStatusFiltered(true$this->getUser()->getId(), 'closed_portal'$filters);
  1057.             $closedPortalTickets $paginator->paginate($closedPortalTicketsQuery$request->getSession()->get($request->get("_route")."_page"), 100);
  1058.             $closedPortalCount sizeof($em->getRepository("App\Entity\Slave\Ticket")->findTicketsByUserAndStatusFiltered(false$this->getUser()->getId(), 'closed_portal'$filters));
  1059.             
  1060.             $canceledTicketsQuery $em->getRepository("App\Entity\Slave\Ticket")->findTicketsByUserAndStatusFiltered(true$this->getUser()->getId(), 'canceled'$filters);
  1061.             $canceledTickets $paginator->paginate($canceledTicketsQuery$request->getSession()->get($request->get("_route")."_page"), 100);
  1062.             $canceledCount sizeof($em->getRepository("App\Entity\Slave\Ticket")->findTicketsByUserAndStatusFiltered(false$this->getUser()->getId(), 'canceled'$filters));
  1063.             
  1064.             return $this->render('role/user/ticket/list.html.twig', array(
  1065.                 'settingTechUnlockSuspension' => $settingTechUnlockSuspension,
  1066.                 'assignedTickets' => $assignedTickets,
  1067.                 'takenChargeTickets' => $takenChargeTickets,
  1068.                 'suspensionRequestTickets' => $suspensionRequestTickets,
  1069.                 'suspendedTickets' => $suspendedTickets,
  1070.                 'closedTickets' => $closedTickets,
  1071.                 'closedPortalTickets' => $closedPortalTickets,
  1072.                 'canceledTickets' => $canceledTickets,
  1073.                 'assignedCount' => $assignedCount,
  1074.                 'takenChargeCount' => $takenChargeCount,
  1075.                 'suspensionRequestCount' => $suspensionRequestCount,
  1076.                 'suspendedCount' => $suspendedCount,
  1077.                 'closedCount' => $closedCount,
  1078.                 'closedPortalCount' => $closedPortalCount,
  1079.                 'canceledCount' => $canceledCount,
  1080.                 'suppliers' => $suppliers,
  1081.                 'operations' => $operationGroups,
  1082.                 'filters' => $filters
  1083.             ));
  1084.         }    
  1085.     }
  1086.     
  1087.     // AZIONI LISTA
  1088.         // MULTIPLE
  1089.             /**
  1090.              * @Route("/selezione-multipla-azione", name="user_ticket_multiple_select_action")
  1091.              * @Security("is_granted('edit', 'ticket')")
  1092.              */
  1093.             public function userTicketMultipleSelectAction(Request $requestMailerInterface $mailer)
  1094.             {    
  1095.                 $em $this->mr->getManager('slave');
  1096.                 $session $request->getSession();
  1097.                 $tab $request->request->get('tab');
  1098.                 $action $request->request->get('action');
  1099.                 $ids $request->request->get('ids');
  1100.                 $causal $request->request->get('causal');
  1101.                 $session->set('ticketsIds'$ids);
  1102.                 $session->set('ticketsAction'$action);
  1103.                 $valid true;
  1104.                 if($action == 'suspend' || $action == 'suspend_end'){
  1105.                     if($causal == null || $causal == ''){
  1106.                         $valid false;
  1107.                         $session->set('ticketsError''causal');
  1108.                     }
  1109.                 }
  1110.                 if($valid){
  1111.                     $tickets = array();
  1112.                     $ticketsIds explode(','$ids);
  1113.                     foreach($ticketsIds as $id){
  1114.                         $t $em->getRepository("App\Entity\Slave\Ticket")->findOneById($id);
  1115.                         array_push($tickets$t);
  1116.                     }
  1117.                     switch($action){
  1118.                         case 'wrong':
  1119.                             foreach($tickets as $ticket){
  1120.                                 $ticket->setSystemError(false);
  1121.                                 $ticket->setSystemErrorSlug(null);
  1122.                                 $ticket->setSystemErrorDetails(null);
  1123.                                 $ticket->setStatus($em->getRepository('App\Entity\Slave\TicketStatus')->findOneBySlug('wrong'));
  1124.                             }
  1125.                             $em->flush();
  1126.                             $this->addFlash('notice_success''Ticket spostati in errati!');
  1127.                             break;
  1128.                         case 'print'
  1129.                             return $this->redirectToRoute('user_ticket_reports_print');
  1130.                             break;
  1131.                         case 'suspend':
  1132.                             foreach($tickets as $ticket){
  1133.                                 $today = new \Datetime();
  1134.                                 $intervention = new Intervention();
  1135.                                 $intervention->setTicket($ticket);
  1136.                                 $intervention->setOutcomeType($em->getRepository('App\Entity\Slave\InterventionOutcomeType')->findOneBySlug('suspended'));
  1137.                                 $intervention->setOutcome($em->getRepository('App\Entity\Slave\InterventionOutcome')->findOneBySlug('suspended-massiva'));
  1138.                                 $intervention->setDatetime(new \Datetime());
  1139.                                 $intervention->setDatetimeBilling(date_create_from_format('d-m-Y H:i:s''01-'.$today->format('m').'-'.$today->format('Y').' 00:00:00'));
  1140.                                 $intervention->setBillable(false);
  1141.                                 $em->persist($intervention);
  1142.                                 $ticketSuspension = new TicketSuspension();
  1143.                                 $ticketSuspension->setTicket($ticket);
  1144.                                 $ticketSuspension->setIntervention($intervention);
  1145.                                 $ticketSuspension->setDatetimeFrom(new \Datetime());
  1146.                                 $ticketSuspension->setApproved(true);
  1147.                                 $ticketSuspension->setManaged(true);
  1148.                                 $ticketSuspension->setUnlockCausal($causal);
  1149.                                 $ticketSuspension->setRefuseMotivation(null);
  1150.                                 $em->persist($ticketSuspension);
  1151.                     
  1152.                                 $settingUnlockSameTech $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'ticket_suspension_unlock_same_technician'));
  1153.                                 if($settingUnlockSameTech->getValue() != 1)
  1154.                                     $ticket->setTechnician(null);
  1155.                                 $ticket->setStatus($em->getRepository('App\Entity\Slave\TicketStatus')->findOneBySlug('suspended'));
  1156.                             }
  1157.                             $em->flush();
  1158.                             $this->addFlash('notice_success''Sospensioni inserite!');
  1159.                             break;
  1160.                         case 'suspend_end':
  1161.                             foreach($tickets as $ticket){
  1162.                                 $ticketSuspension $ticket->getActualSuspension();
  1163.                                 $ticketSuspension->unlock($causal, new \Datetime(), $em);
  1164.                             }
  1165.                             $em->flush();
  1166.                             $this->addFlash('notice_success''Sospensioni sbloccate!');
  1167.                             break;
  1168.                         case 'approve':
  1169.                             foreach($tickets as $ticket){
  1170.                                 $ticketSuspension $ticket->getActualSuspension();
  1171.                                 $ticketSuspension->setApproved(true);
  1172.                                 $ticketSuspension->setManaged(true);
  1173.                     
  1174.                                 $settingUnlockSameTech $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'ticket_suspension_unlock_same_technician'));
  1175.                                 if($settingUnlockSameTech->getValue() != 1)
  1176.                                     $ticket->setTechnician(null);
  1177.                                 $ticket->setStatus($em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'suspended')));
  1178.                             }
  1179.                             // TODO inviare una email con l'elenco delle sospensioni approvate per ogni tecnico
  1180.                             $em->flush();
  1181.                             $this->addFlash('notice_success''Sospensioni approvate!');
  1182.                             break;
  1183.                         case 'closed_portal':
  1184.                             foreach($tickets as $ticket){
  1185.                                 $ticket->setStatus($em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'closed_portal')));
  1186.                                 $ticket->setClosedOnPortal(1);
  1187.                             }
  1188.                             $em->flush();
  1189.                             $this->addFlash('notice_success''Ticket chiusi su portal fornitore!');
  1190.                             break;
  1191.                         case 'cancel'
  1192.                             foreach($tickets as $ticket){
  1193.                                 $ticket->setStatus($em->getRepository('App\Entity\Slave\TicketStatus')->findOneBySlug('canceled'));
  1194.                             }
  1195.                             // TODO inviare una email con l'elenco dei ticket annullati per ogni tecnico
  1196.                             $em->flush();
  1197.                             $this->addFlash('notice_success''Ticket annullati!');
  1198.                             break;
  1199.                         case 'delete'
  1200.                             $countDeleted 0;
  1201.                             $countIgnored 0;
  1202.                             foreach($tickets as $ticket){
  1203.                                 if($ticket->canDelete('all')){
  1204.                                     $this->deleteTicketAndConnectedValues($em$ticket);
  1205.                                     $countDeleted++;
  1206.                                 }
  1207.                                 else
  1208.                                     $countIgnored++;
  1209.                             }
  1210.                             $em->flush();
  1211.                             $this->addFlash('notice_success''Rimossi '.$countDeleted.' ticket e ignorati '.$countIgnored.' ticket non eliminabili!');
  1212.                             break;
  1213.                         case 'urge':
  1214.                             $now = new \Datetime();
  1215.                             $settingSunday $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'script_sunday_active'));
  1216.                             $techniciansIds = array();
  1217.                             $users = array();
  1218.                             foreach($tickets as $ticket){
  1219.                                 if(!in_array($ticket->getTechnician()->getId(), $techniciansIds))
  1220.                                     array_push($techniciansIds$ticket->getTechnician()->getId());
  1221.                             }
  1222.                             if($settingSunday->getValue() == || ($settingSunday->getValue() == && $today->format('N') != 7)){
  1223.                                 foreach($techniciansIds as $tId){
  1224.                                     $tmp = array();
  1225.                                     $tmp2 = array();
  1226.                                     $technician $em->getRepository('App\Entity\Slave\User')->findOneById($tId);
  1227.                                     if(!$technician->isInHolidayAtDate($now)){
  1228.                                         foreach($tickets as $ticket){
  1229.                                             if($ticket->getTechnician()->getId() == $technician->getId())
  1230.                                                 array_push($tmp2$ticket);
  1231.                                         }
  1232.                                     }
  1233.                                     array_push($tmp$technician$tmp2);
  1234.                                     array_push($users$tmp);
  1235.                                 }
  1236.                                 
  1237.                                 foreach($users as $u){
  1238.                                     $message = (new TemplatedEmail())
  1239.                                         ->subject($this->params->get('subject_ticket_urge'))
  1240.                                         ->from($this->params->get('email_noreply'))
  1241.                                         ->to($u[0]->getEmail())
  1242.                                         ->htmlTemplate('email/technician_urge_tickets.html.twig')
  1243.                                         ->context(['user' => $u[0], 'tickets' => $u[1]]);
  1244.                                     $mailer->send($message);
  1245.                                 }
  1246.                                 $this->addFlash('notice_success''Email di notifica urgenza inviate!');
  1247.                             }
  1248.                             else{
  1249.                                 $this->addFlash('notice_warning''Notifiche disabilitate la Domenica! Attivale dalle impostazioni');
  1250.                             }
  1251.                             break;
  1252.                         default: break;
  1253.                     }
  1254.                 }
  1255.                 return $this->redirectToRoute('user_ticket_list');
  1256.             }
  1257.             /**
  1258.              * @Route("/verbali-stampa", name="user_ticket_reports_print")
  1259.              * @Security("is_granted('view', 'ticket')")
  1260.              */
  1261.             public function userTicketReportsPrint(Request $request)
  1262.             {    
  1263.                 $em $this->mr->getManager('slave');
  1264.                 $session $request->getSession();
  1265.                 $matrixTickets = array();
  1266.                 $ticketsIds explode(','$session->get('ticketsIds'));
  1267.                 foreach($ticketsIds as $id){
  1268.                     $t $em->getRepository("App\Entity\Slave\Ticket")->findOneById($id);
  1269.                     $jsonReportValues = array();
  1270.                     $tmp = array();
  1271.                     if($t->getJsonReport() != '[]'){
  1272.                         $matrix json_decode($t->getJsonReport(), true);
  1273.                         foreach($matrix as $array)
  1274.                             foreach($array as $a){
  1275.                                 $tcv $em->getRepository('App\Entity\Slave\TicketColumnValue')->findOneBySupplierTicketColumnAndNeedle($t->getSupplier()->getId(), array_keys($array)[0], $a);
  1276.                                 $htmlToAdd '';
  1277.                                 if($tcv != null)
  1278.                                     $htmlToAdd ' ('.$tcv->getValue().')';
  1279.                                 $jsonReportValues[array_keys($array)[0]] = $a.$htmlToAdd;
  1280.                             }
  1281.                     }
  1282.                     array_push($tmp$t$jsonReportValues);
  1283.                     array_push($matrixTickets$tmp);
  1284.                 }
  1285.                 
  1286.                 return $this->render('role/user/print/report.html.twig', array(
  1287.                     'matrixTickets' => $matrixTickets,
  1288.                     'backRoute' => 'sheet',
  1289.                     'continueRoute' => 'sheet'
  1290.                 ));
  1291.             }
  1292.         //
  1293.         
  1294.         // SINGOLE
  1295.             /**
  1296.              * @Route("/invia-email-prendi-in-carico", name="user_ticket_send_email_take_charge")
  1297.              * @Security("is_granted('edit', 'ticket')")
  1298.              */
  1299.             public function userTicketSendEmailTakeCharge(Request $requestMailerInterface $mailer)
  1300.             {    
  1301.                 $em $this->mr->getManager('slave');
  1302.                 $emMaster $this->mr->getManager('master');
  1303.                 $session $request->getSession();
  1304.                 $company $emMaster->getRepository('App\Entity\Master\Company')->findOneById($session->get('companyId'));
  1305.                 $now = new \Datetime();
  1306.                 $users = array();
  1307.                 $technicians $em->getRepository("App\Entity\Slave\User")->findTechniciansActive();
  1308.                 $settingSunday $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'script_sunday_active'));
  1309.                 if($settingSunday->getValue() == || ($settingSunday->getValue() == && $today->format('N') != 7)){
  1310.                     foreach($technicians as $t){
  1311.                         $onHoliday false;
  1312.                         foreach($t->getHolidays() as $h){
  1313.                             if($now->format('Ymd') >= $h->getDateFrom()->format('Ymd') && $now->format('Ymd') <= $h->getDateTo()->format('Ymd')){
  1314.                                 $onHoliday true;
  1315.                                 break;
  1316.                             }
  1317.                         }
  1318.                         if(!$onHoliday){
  1319.                             $tickets $em->getRepository('App\Entity\Slave\Ticket')->findByUserAndStatus($t->getId(), 'assigned');
  1320.                             if(sizeof($tickets) > 0)
  1321.                                 array_push($users, array($t$tickets));
  1322.                         }
  1323.                     }
  1324.                     
  1325.                     foreach($users as $u){
  1326.                         $message = (new TemplatedEmail())
  1327.                             ->subject($this->params->get('subject_ticket_take_charge'))
  1328.                             ->from($this->params->get('email_noreply'))
  1329.                             ->to($u[0]->getEmail())
  1330.                             ->htmlTemplate('email/technician_tickets.html.twig')
  1331.                             ->context(['user' => $u[0], 'tickets' => $u[1]]);
  1332.                         $mailer->send($message);
  1333.                     }
  1334.                     $message = (new TemplatedEmail())
  1335.                         ->subject($this->params->get('subject_event_clicked'))
  1336.                         ->from($this->params->get('email_noreply'))
  1337.                         ->to($this->params->get('email_domini'))
  1338.                         ->htmlTemplate('email/event_clicked.html.twig')
  1339.                         ->context(['user' => $this->getUser(), 'company' => $company'event' => 'Invia email prendi in carico']);
  1340.                     $mailer->send($message);
  1341.                     
  1342.                     $this->addFlash('notice_success''Notifiche email inviate!');
  1343.                 }
  1344.                 else{
  1345.                     $this->addFlash('notice_warning''Notifiche disabilitate la Domenica! Attivale dalle impostazioni');
  1346.                 }
  1347.                 return $this->redirect($request->server->get('HTTP_REFERER'));
  1348.             }
  1349.         
  1350.             /**
  1351.              * @Route("/prendi-in-carico", name="user_ticket_take_charge")
  1352.              * @Security("is_granted('edit', 'ticket')")
  1353.              */
  1354.             public function userTicketTakeCharge(Request $request)
  1355.             {    
  1356.                 $em $this->mr->getManager('slave');
  1357.                 $session $request->getSession();
  1358.                 $tickets $em->getRepository('App\Entity\Slave\Ticket')->findByUserAndStatus($this->getUser()->getId(), 'assigned');
  1359.                 $statusTakenCharge $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBySlug('taken_charge');
  1360.                 foreach($tickets as $ticket){
  1361.                     $ticket->setStatus($statusTakenCharge);
  1362.                 }
  1363.                 $em->flush();
  1364.                 $this->addFlash('notice_success''Stato aggiornato!');
  1365.                 return $this->redirect($request->server->get('HTTP_REFERER'));
  1366.             }
  1367.         //
  1368.     //
  1369.     
  1370.     // AGGIUNGI MANUALMENTE
  1371.         /**
  1372.          * @Route("/nuovo", name="user_ticket_new")
  1373.          * @Security("is_granted('view', 'ticket')")
  1374.          */
  1375.         public function userTicketNew(Request $requestValidatorInterface $validatorFormFactoryInterface $formFactory)
  1376.         {    
  1377.             $em $this->mr->getManager('slave');
  1378.             $emMaster $this->mr->getManager('master');
  1379.             $session $request->getSession();
  1380.             $company $emMaster->getRepository('App\Entity\Master\Company')->findOneById($session->get('companyId'));
  1381.             $cities $emMaster->getRepository("App\Entity\Master\City")->findByName('');
  1382.             $today = new \DateTime();
  1383.             $ticket = new Ticket();
  1384.             $form $formFactory->createNamed("form_ticket_new"TicketType::class, $ticket);
  1385.             $form->handleRequest($request);
  1386.             if($form->isSubmitted()){
  1387.                 $valid true;
  1388.                 if($form->get('termid')->getData() == null && $form->get("termidCode")->getData() == null){
  1389.                     $valid false;
  1390.                     $form->get("termidCode")->addError(new FormError("Campo obbligatorio"));
  1391.                 }
  1392.                 if($valid){
  1393.                     $termidCode $form->get("termidCode")->getData();
  1394.                     if($form->get('termid')->getData() != null)
  1395.                         $termidCode $em->getRepository('App\Entity\Slave\Termid')->findOneById($form->get('termid')->getData())->getCode();
  1396.                     $alreadyExist $em->getRepository('App\Entity\Slave\Ticket')->findOneByNumberAndTermid($ticket->getNumber(), $termidCode);
  1397.                     if($alreadyExist){
  1398.                         $valid false;
  1399.                         $form->get("number")->addError(new FormError("Esiste già un ticket con questo numero e con questo termid!"));
  1400.                         $form->get("termidCode")->addError(new FormError("Esiste già un ticket con questo numero e con questo termid!"));
  1401.                     }
  1402.                 }
  1403.                 
  1404.                 if($valid$valid ValidationService::validateNotBlank($validator$form->get("datetimeStart_date"));
  1405.                 if($valid$valid ValidationService::validateNotBlank($validator$form->get("datetimeStart_date"));
  1406.                 if($valid$valid ValidationService::validateNotBlank($validator$form->get("datetimeStart_hour"));
  1407.                 if($valid$valid ValidationService::validateNotBlank($validator$form->get("datetimeStart_minute"));
  1408.                 if($valid$valid ValidationService::validateNotBlank($validator$form->get("datetimeExpiration_date"));
  1409.                 if($valid$valid ValidationService::validateNotBlank($validator$form->get("datetimeExpiration_hour"));
  1410.                 if($valid$valid ValidationService::validateNotBlank($validator$form->get("datetimeExpiration_minute"));
  1411.                 if($valid$valid ValidationService::validateNotBlank($validator$form->get("anomaly"));
  1412.                 if($form->get('cityId')->getData() == null && $form->get("otherCity")->getData() == null){
  1413.                     $valid false;
  1414.                     $form->get("cityName")->addError(new FormError("Campo obbligatorio"));
  1415.                 }
  1416.                 if($valid && $form->get('client')->getData() == null){
  1417.                     if($valid$valid ValidationService::validateNotBlank($validator$form->get("clientCode"));
  1418.                     if($valid$valid ValidationService::validateNotBlank($validator$form->get("clientName"));
  1419.                     if($valid$valid ValidationService::validateNotBlank($validator$form->get("clientNickname"));
  1420.                     if($valid$valid ValidationService::validateNotBlank($validator$form->get("clientAddress"));
  1421.                     if($form->get('client_cityId')->getData() == null){
  1422.                         $valid false;
  1423.                         $form->get("client_cityName")->addError(new FormError("Campo obbligatorio"));
  1424.                     }
  1425.                     if($valid$valid ValidationService::validateNotBlank($validator$form->get("client_zip"));
  1426.                 }
  1427.                 $valid true;
  1428.                 $zip $emMaster->getRepository('App\Entity\Master\Zip')->findOneById($form->get('zip')->getData());
  1429.                 if($zip == null){
  1430.                     $zip $emMaster->getRepository('App\Entity\Master\Zip')->findOneByCode($request->request->get('other_zip'));
  1431.                     if($zip == null){
  1432.                         $form->get('zip')->addError(new FormError('CAP inesistente! Controlla il valore inserito!'));
  1433.                         $valid false;
  1434.                     }
  1435.                 }
  1436.                 
  1437.                 if($valid && $form->isValid()){
  1438.                     
  1439.                     $jsonReport '[{"ABI":'.json_encode($form->get('abi')->getData()).'},{"Anomalia":'.json_encode($form->get('anomaly')->getData()).'}]';
  1440.                     $datetimeStart date_create_from_format('d-m-Y H:i'$form->get('datetimeStart_date')->getData()->format('d-m-Y').' '.$form->get('datetimeStart_hour')->getData().':'.$form->get('datetimeStart_minute')->getData());
  1441.                     $datetimeExpiration date_create_from_format('d-m-Y H:i'$form->get('datetimeExpiration_date')->getData()->format('d-m-Y').' '.$form->get('datetimeExpiration_hour')->getData().':'.$form->get('datetimeExpiration_minute')->getData());
  1442.                     if($form->get('cityId')->getData() != null)
  1443.                         $city $emMaster->getRepository('App\Entity\Master\City')->findOneById($form->get('cityId')->getData());
  1444.                     
  1445.                     $zip $emMaster->getRepository('App\Entity\Master\Zip')->findOneById($form->get('zip')->getData());
  1446.                     $ticket->setZip($zip->getCode());
  1447.                     if($city != null){
  1448.                         $ticket->setIdCity($city->getId());
  1449.                         $ticket->setIdProvince($city->getProvince()->getId());
  1450.                         $ticket->setOtherCity(null);
  1451.                     }
  1452.                     else{
  1453.                         $ticket->setOtherCity($form->get('otherCity')->getData());
  1454.                         $ticket->setIdProvince($zip->getCities()[0]->getProvince()->getId());
  1455.                     }
  1456.                     $ticket->setStatus($em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'to_assign')));
  1457.                     $ticket->setDirectoryPath($today->format("Y").'/'.$today->format("m").'/'.md5(uniqid()));
  1458.                     $ticket->setDatetimeImport(new \DateTime());
  1459.                     $ticket->setClosedOnPortal(false);
  1460.                     $ticket->setSystemError(false);
  1461.                     $ticket->setJson('[{}]');
  1462.                     $ticket->setJsonReport($jsonReport);
  1463.                     $ticket->setDatetimeStart($datetimeStart);
  1464.                     $ticket->setDatetimeExpiration($datetimeExpiration);
  1465.                     
  1466.                     // Client
  1467.                     $client $em->getRepository('App\Entity\Slave\Client')->findOneById($form->get('client')->getData());
  1468.                     if($client == null){
  1469.                         $client = new Client();
  1470.                         $client->setCode($form->get('clientCode')->getData());
  1471.                         $client->setName($form->get('clientName')->getData());
  1472.                         $client->setNickname($form->get('clientNickname')->getData());
  1473.                         $client->setReferent($form->get('clientReferent')->getData());
  1474.                         $client->setFiscalCode($form->get('clientFiscalCode')->getData());
  1475.                         $client->setVat($form->get('clientVat')->getData());
  1476.                         $client->setSdi($form->get('clientSdi')->getData());
  1477.                         $client->setClosures($form->get('clientClosures')->getData());
  1478.                         $client->setOpenings($form->get('clientOpenings')->getData());
  1479.                         $clientCity $emMaster->getRepository('App\Entity\Master\City')->findOneById($form->get('client_cityId')->getData());
  1480.                         $clientZip $emMaster->getRepository('App\Entity\Master\Zip')->findOneById($form->get('client_zip')->getData());
  1481.                         $client->setAddress($form->get('address')->getData());
  1482.                         $client->setLocality($form->get('locality')->getData());
  1483.                         $client->setIdCity($clientCity->getId());
  1484.                         $client->setZip($clientZip->getCode());
  1485.                         $client->setIdProvince($clientCity->getProvince()->getId());
  1486.                         $client->setNotes($form->get('clientNotes')->getData());
  1487.                         $client->setDirectoryPath(md5(uniqid()));
  1488.                         $em->persist($client);
  1489.         
  1490.                         $clientPhone = new ClientPhone();
  1491.                         $clientPhone->setClient($client);
  1492.                         $clientPhone->setName('Telefono 1');
  1493.                         $clientPhone->setNumber($form->get('clientPhone')->getData());
  1494.                         $em->persist($clientPhone);
  1495.             
  1496.                         $warehouse = new Warehouse();
  1497.                         $warehouse->setClient($client);
  1498.                         $warehouse->setMovable(false);
  1499.                         $warehouse->setNickname('Magazzino cliente - '.$client->getNickname());
  1500.                         $client->setWarehouse($warehouse);
  1501.                         $em->persist($warehouse);
  1502.                         $em->flush();
  1503.                     }
  1504.                     $ticket->setClient($client);
  1505.             
  1506.                     // Termid
  1507.                     $termid $em->getRepository('App\Entity\Slave\Termid')->findOneById($form->get('termid')->getData());
  1508.                     if($termid == null){
  1509.                         $termid = new Termid();
  1510.                         $termid->setClient($client);
  1511.                         $termid->setCode($form->get('termidCode')->getData());
  1512.                         $em->persist($termid);
  1513.                         $em->flush();
  1514.                     }
  1515.                     $ticket->setTermid($termid);
  1516.                     $em->persist($ticket);
  1517.                     $em->flush();               
  1518.                     
  1519.                     $error TicketService::ticketAssignOperationTariffAmount($em$emMaster$ticket);
  1520.                     $this->addFlash('notice_success'"Ticket inserito!");
  1521.                     return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  1522.                 }
  1523.             }
  1524.             return $this->render('role/user/ticket/new.html.twig', array(
  1525.                 'company' => $company,
  1526.                 'cities' => $cities,
  1527.                 'form' => $form->createView()
  1528.             ));
  1529.         }
  1530.     //
  1531.         
  1532.     /**
  1533.      * @Route("/{ticketId}/scheda", name="user_ticket_sheet")
  1534.      * @Security("is_granted('ticket_view', ticketId)")
  1535.      */
  1536.     public function userTicketSheet($ticketIdRequest $requestValidatorInterface $validatorFormFactoryInterface $formFactoryFileSystem $fsUserPasswordHasherInterface $passwordHasherMailerInterface $mailer)
  1537.     {    
  1538.         $em $this->mr->getManager('slave');
  1539.         $emMaster $this->mr->getManager('master');
  1540.         $session $request->getSession();
  1541.         $company $emMaster->getRepository('App\Entity\Master\Company')->findOneById($session->get('companyId'));
  1542.         $settingBackOffice $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'ticket_backoffice_manage'));
  1543.         $settingTechUnlockSuspension $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'ticket_suspension_unlock_by_technician'));
  1544.         $cities $emMaster->getRepository("App\Entity\Master\City")->findByName('');
  1545.         $ticket $em->getRepository("App\Entity\Slave\Ticket")->findOneById($ticketId);
  1546.         $displayJsonReport '';
  1547.         if($ticket->getJsonReport() != '[]'){
  1548.             $matrix json_decode($ticket->getJsonReport(), true);
  1549.             foreach($matrix as $array)
  1550.                 foreach($array as $a){
  1551.                     $tcv $em->getRepository('App\Entity\Slave\TicketColumnValue')->findOneBySupplierTicketColumnAndNeedle($ticket->getSupplier()->getId(), array_keys($array)[0], $a);
  1552.                     $htmlToAdd '';
  1553.                     if($tcv != null)
  1554.                         $htmlToAdd ' <i>('.$tcv->getValue().')</i>';
  1555.                     $displayJsonReport.= '<tr><th>'.array_keys($array)[0].'</th><td colspan="2">'.$a.$htmlToAdd.'</td></tr>';
  1556.                 }
  1557.         }
  1558.         // TICKET - MODIFICA INDIRIZZO
  1559.         $formAddressEdit $formFactory->createNamed("form_address"TicketAddressType::class, $ticket);
  1560.         $formAddressEdit->handleRequest($request);
  1561.         if($formAddressEdit->isSubmitted()){
  1562.             $valid true;
  1563.             $zip $emMaster->getRepository('App\Entity\Master\Zip')->findOneById($formAddressEdit->get('zip')->getData());
  1564.             if($zip == null){
  1565.                 $zip $emMaster->getRepository('App\Entity\Master\Zip')->findOneByCode($request->request->get('other_zip'));
  1566.                 if($zip == null){
  1567.                     $formAddressEdit->get('zip')->addError(new FormError('CAP inesistente! Controlla il valore inserito!'));
  1568.                     $valid false;
  1569.                 }
  1570.             }
  1571.             if($valid && $formAddressEdit->isValid()){
  1572.                 if($formAddressEdit->get('cityId')->getData() != null)
  1573.                     $city $emMaster->getRepository('App\Entity\Master\City')->findOneById($formAddressEdit->get('cityId')->getData());
  1574.                 $ticket->setZip($zip->getCode());
  1575.                 if($city != null){
  1576.                     $ticket->setIdCity($city->getId());
  1577.                     $ticket->setIdProvince($city->getProvince()->getId());
  1578.                     $ticket->setOtherCity(null);
  1579.                 }
  1580.                 else{
  1581.                     $ticket->setOtherCity($formAddressEdit->get('otherCity')->getData());
  1582.                     $ticket->setIdProvince($zip->getCities()[0]->getProvince()->getId());
  1583.                 }
  1584.                 // SE SCELTO AGGIORNA CLIENTE
  1585.                 if($formAddressEdit->get('updateClient')->getData()){
  1586.                     $ticket->getClient()->setAddress($formAddressEdit->get('address')->getData());
  1587.                     $ticket->getClient()->setZip($zip->getCode());
  1588.                     $ticket->getClient()->setLocality($formAddressEdit->get('locality')->getData());
  1589.                     if($city != null){
  1590.                         $ticket->getClient()->setIdCity($city->getId());
  1591.                         $ticket->getClient()->setIdProvince($city->getProvince()->getId());
  1592.                     }
  1593.                     else{
  1594.                         $ticket->getClient()->setOtherCity($formAddressEdit->get('otherCity')->getData());
  1595.                         $ticket->getClient()->setIdProvince($zip->getCities()[0]->getProvince()->getId());
  1596.                     }
  1597.                 }
  1598.                 
  1599.                 $error TicketService::ticketAssignOperationTariffAmount($em$emMaster$ticket);
  1600.                 if($error){
  1601.                     $this->addFlash('notice_warning'"Nessuna tariffa trovata per questo indirizzo!");
  1602.                     return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  1603.                 }
  1604.                 $em->flush();
  1605.                 $this->addFlash('notice_success'"Indirizzo ticket aggiornato!");
  1606.                 return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  1607.             }
  1608.             else{
  1609.                 $session->set('openModalAddressEdit'true);
  1610.             }
  1611.         }
  1612.         // TICKET - CLIENTE - MODIFICA 
  1613.         $numOfPhones 0;
  1614.         if($ticket->getClient() != null)
  1615.             $numOfPhones sizeof($ticket->getClient()->getPhones());
  1616.         $formClientEdit $formFactory->createNamed("form_client_edit"ClientEditType::class, $ticket->getClient(), array('phoneNumber' => $numOfPhones));
  1617.         $formClientEdit->handleRequest($request);
  1618.         if($formClientEdit->isSubmitted()){
  1619.             if($formClientEdit->isValid()){
  1620.                 
  1621.                 foreach($ticket->getClient()->getPhones() as $phone){
  1622.                     if($phone->getName() == 'Telefono 1'$phone->setNumber($formClientEdit->get('phone1')->getData());
  1623.                     if(sizeof($ticket->getClient()->getPhones()) > && $phone->getName() == 'Telefono 2'$phone->setNumber($formClientEdit->get('phone2')->getData());
  1624.                     if(sizeof($ticket->getClient()->getPhones()) > && $phone->getName() == 'Telefono cellulare'$phone->setNumber($formClientEdit->get('phone3')->getData());
  1625.                 }
  1626.                 if(sizeof($ticket->getClient()->getPhones()) == 0){
  1627.                     $clientPhone = new ClientPhone();
  1628.                     $clientPhone->setClient($ticket->getClient());
  1629.                     $clientPhone->setName('Telefono 1');
  1630.                     $clientPhone->setNumber('');
  1631.                     $em->persist($clientPhone);
  1632.                 }
  1633.                 $em->flush();
  1634.                 $this->addFlash('notice_success'"Dati aggiornati");
  1635.                 return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  1636.             }
  1637.             else{
  1638.                 $session->set('openEditModal'true);
  1639.                 $session->set('openEditModalId'$request->request->get('clientNotesEditId'));
  1640.             }
  1641.         }
  1642.     
  1643.         // TICKET - SOSPENSIONE - SBLOCCA
  1644.         $suspension = new TicketSuspension();
  1645.         $formSusUnlock $formFactory->createNamed("form_suspension_unlock"TicketSuspensionUnlockType::class, $suspension);
  1646.         $formSusUnlock->handleRequest($request);
  1647.         if($formSusUnlock->isSubmitted()){
  1648.             $valid ValidationService::validateNotBlank($validator$formSusUnlock->get("unlockCausal"));
  1649.             if($valid && $formSusUnlock->isValid()){
  1650.                 $suspension $em->getRepository('App\Entity\Slave\TicketSuspension')->findOneById($formSusUnlock->get('id')->getData());
  1651.                 $unlockCausal $formSusUnlock->get("unlockCausal")->getData();
  1652.                 $suspension->unlock($unlockCausal, new \DateTime(), $em);
  1653.                 $em->flush();
  1654.                 $this->addFlash('notice_success'"Sospensione sbloccata!");
  1655.                 return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  1656.             }
  1657.             else{
  1658.                 $session->set('openModalSuspensionUnlock'true);
  1659.                 $session->set('openModalSuspensionUnlockId'$formSusUnlock->get('id')->getData());
  1660.             }
  1661.         }
  1662.         
  1663.         // TICKET - EXTRA
  1664.         if($this->getUser()->getAccountTypology() == 'agency' || $this->getUser()->getAccountTypology() == 'warehouse')
  1665.             $choiceTypes = array('Ore' => 'hours''Spesa' => 'cost''Integrazione tariffa' => 'tariff_extra''Tariffa fuori copertura' => 'tariff_out');
  1666.         else
  1667.             $choiceTypes = array('Ore' => 'hours''Spesa' => 'cost''Integrazione tariffa' => 'tariff_extra');
  1668.         $uploadDir $this->params->get('kernel.project_dir').'/'.$this->params->get('web_path').'/companies/'.$company->getDirectoryPath().'/tickets/'.$ticket->getDirectoryPath().'/';
  1669.         $interventionExtra = new InterventionExtra();
  1670.         $formExtraNew $formFactory->createNamed("form_intervention_extra_new"InterventionExtraType::class, $interventionExtra, array('ticketId' => $ticket->getId(), 'choice_types' => $choiceTypes));
  1671.         $formExtraNew->handleRequest($request);
  1672.         if($formExtraNew->isSubmitted()){
  1673.             $valid FormValidatorService::validateInterventionExtra($validator$formExtraNewfalse$this->getUser());
  1674.             if($valid && $formExtraNew->isValid()){
  1675.                 switch($formExtraNew->get('type')->getData()){
  1676.                     case 'cost':
  1677.                         if($formExtraNew->get('file')->getData()->guessExtension() == 'pdf')
  1678.                             MediaService::uploadDocument($formExtraNew->get('file')->getData(), $uploadDir$interventionExtra'file');
  1679.                         else
  1680.                             MediaService::uploadImage($fs$formExtraNew->get('file')->getData(), null$uploadDir$interventionExtra'file'1001000200true);
  1681.                         break;
  1682.                     case 'tariff_out':
  1683.                         $interventionExtra->setTariffOut(true);
  1684.                     default: break;
  1685.                 }
  1686.                 
  1687.                 if($this->getUser()->getAccountTypology() == 'agency' || $this->getUser()->getAccountTypology() == 'warehouse'){
  1688.                     $interventionExtra->setManaged(true);
  1689.                     $interventionExtra->setApproved(true);
  1690.                 }
  1691.                 else{
  1692.                     $interventionExtra->setManaged(false);
  1693.                     $interventionExtra->setApproved(null);
  1694.                 }
  1695.                 $em->persist($interventionExtra);
  1696.                 $em->flush();
  1697.                 $this->addFlash('notice_success'"Nuovo extra inserito!");
  1698.                 return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  1699.             }
  1700.             else{
  1701.                 $session->set('openModalExtraNew'true);
  1702.             }
  1703.         }
  1704.         
  1705.         $formExtraEdit $formFactory->createNamed("form_intervention_extra_edit"InterventionExtraType::class, $interventionExtra, array('ticketId' => $ticket->getId(), 'choice_types' => $choiceTypes));
  1706.         $formExtraEdit->handleRequest($request);
  1707.         if($formExtraEdit->isSubmitted()){
  1708.             $valid FormValidatorService::validateInterventionExtra($validator$formExtraEdittrue$this->getUser());
  1709.             if($valid && $formExtraEdit->isValid()){
  1710.                 $interventionExtraEdit $em->getRepository('App\Entity\Slave\InterventionExtra')->findOneById($request->request->get('extraEditId'));
  1711.                 $oldFilePath $interventionExtraEdit->getFilePath();
  1712.                 $interventionExtraEdit->setIntervention($formExtraEdit->get('intervention')->getData());
  1713.                 $interventionExtraEdit->setType($formExtraEdit->get('type')->getData());
  1714.                 $interventionExtraEdit->setNotes($formExtraEdit->get('notes')->getData());
  1715.                 switch($formExtraEdit->get('type')->getData()){
  1716.                     case 'cost':
  1717.                         $interventionExtraEdit->setTariffOut(false);
  1718.                         $interventionExtraEdit->setCost($formExtraEdit->get('cost')->getData());
  1719.                         if($formExtraEdit->get('file')->getData() != null){
  1720.                             // METTO IL NUOVO
  1721.                             if($formExtraEdit->get('file')->getData()->guessExtension() == 'pdf')
  1722.                                 MediaService::uploadDocument($formExtraEdit->get('file')->getData(), $uploadDir$interventionExtra'file');
  1723.                             else
  1724.                                 MediaService::uploadImage($fs$formExtraEdit->get('file')->getData(), null$uploadDir$interventionExtraEdit'file'1001000200true);
  1725.                             // RIMUOVO IL VECCHIO FILE
  1726.                             if(str_contains($oldFilePath'.pdf'))
  1727.                                 MediaService::removeDocument($fs$oldFilePath$uploadDir);
  1728.                             else
  1729.                                 MediaService::removeImage($fs$oldFilePath$uploadDir);
  1730.                         }
  1731.                         break;
  1732.                     case 'hours':
  1733.                         $interventionExtraEdit->setTariffOut(false);
  1734.                         $interventionExtraEdit->setCost($formExtraEdit->get('cost')->getData());
  1735.                         $interventionExtraEdit->setHours($formExtraEdit->get('hours')->getData());
  1736.                         break;
  1737.                     case 'tariff_extra':
  1738.                         $interventionExtraEdit->setHours(null);
  1739.                         $interventionExtraEdit->setCost($formExtraEdit->get('cost')->getData());
  1740.                         $interventionExtraEdit->setTariffOut(false);
  1741.                         break;
  1742.                     case 'tariff_out':
  1743.                         $interventionExtraEdit->setHours(null);
  1744.                         $interventionExtraEdit->setCost($formExtraEdit->get('cost')->getData());
  1745.                         $interventionExtraEdit->setTariffOut(true);
  1746.                         break;
  1747.                     default: break;
  1748.                 }
  1749.                 $em->flush();
  1750.                 $this->addFlash('notice_success'"Modifiche salvate!");
  1751.                 return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  1752.             }
  1753.             else{
  1754.                 $session->set('openModalExtraEdit'true);
  1755.                 $session->set('openModalExtraEditId'$request->request->get('extraEditId'));
  1756.             }
  1757.         }
  1758.         
  1759.         // TICKET - REMINDER
  1760.         $ticketReminder = new TicketReminder();
  1761.         $formReminderNew $formFactory->createNamed("form_reminder_new"TicketReminderType::class, $ticketReminder);
  1762.         $formReminderNew->handleRequest($request);
  1763.         if($formReminderNew->isSubmitted()){
  1764.             $valid true;
  1765.             if($valid$valid ValidationService::validateNotBlank($validator$formReminderNew->get("date"));
  1766.             if($valid$valid ValidationService::validateNotBlank($validator$formReminderNew->get("hour"));
  1767.             if($valid$valid ValidationService::validateNotBlank($validator$formReminderNew->get("minute"));
  1768.             if($valid && $formReminderNew->isValid()){
  1769.                 
  1770.                 $datetime date_create_from_format('d-m-Y H:i'$formReminderNew->get('date')->getData()->format('d-m-Y').' '.$formReminderNew->get('hour')->getData().':'.$formReminderNew->get('minute')->getData());
  1771.                 $ticketReminder->setDatetime($datetime);
  1772.                 $ticketReminder->setTicket($ticket);
  1773.                 $ticketReminder->setTechnician($this->getUser());
  1774.                 $em->persist($ticketReminder);
  1775.                 $em->flush();
  1776.                 $this->addFlash('notice_success'"Reminder ticket inserito!");
  1777.                 return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  1778.             }
  1779.             else{
  1780.                 $session->set('openModalReminderNew'true);
  1781.             }
  1782.         }
  1783.         
  1784.         $formReminderEdit $formFactory->createNamed("form_reminder_edit"TicketReminderType::class, $ticketReminder);
  1785.         $formReminderEdit->handleRequest($request);
  1786.         if($formReminderEdit->isSubmitted()){
  1787.             $valid true;
  1788.             if($valid$valid ValidationService::validateNotBlank($validator$formReminderEdit->get("date"));
  1789.             if($valid$valid ValidationService::validateNotBlank($validator$formReminderEdit->get("hour"));
  1790.             if($valid$valid ValidationService::validateNotBlank($validator$formReminderEdit->get("minute"));
  1791.             if($valid && $formReminderEdit->isValid()){
  1792.                 
  1793.                 $reminder $em->getRepository('App\Entity\Slave\TicketReminder')->findOneById($formReminderEdit->get('id')->getData());
  1794.                 $datetime date_create_from_format('d-m-Y H:i'$formReminderEdit->get('date')->getData()->format('d-m-Y').' '.$formReminderEdit->get('hour')->getData().':'.$formReminderEdit->get('minute')->getData());
  1795.                 $reminder->setDatetime($datetime);
  1796.                 $reminder->setDetails($formReminderEdit->get('details')->getData());
  1797.                 $em->flush();
  1798.                 $this->addFlash('notice_success'"Modifiche salvate!");
  1799.                 return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  1800.             }
  1801.             else{
  1802.                 $session->set('openModalReminderEdit'true);
  1803.                 $session->set('openModalReminderEditId'$formReminderEdit->get('id')->getData());
  1804.             }
  1805.         }
  1806.         if($this->getUser()->getAccountTypology() == 'agency' || $this->getUser()->getAccountTypology() == 'warehouse'){
  1807.             // AGENZIA
  1808.             // TECNICI
  1809.             $technicians = array();
  1810.             if($ticket->getZip() != null){
  1811.                 $zip $emMaster->getRepository('App\Entity\Master\Zip')->findOneBy(array('code' => $ticket->getClient()->getZip()));
  1812.                 $allTechs $em->getRepository('App\Entity\Slave\User')->findTechniciansActive();
  1813.                 foreach($allTechs as $t){
  1814.                     $supplier false;
  1815.                     $area false;
  1816.                     $tmp = array();
  1817.                     $autoAssignSuppliersIds = array();
  1818.                     foreach($t->getAutoAssignSuppliers() as $supplier)
  1819.                         array_push($autoAssignSuppliersIds$supplier->getId());
  1820.                             
  1821.                     if(in_array($ticket->getOperation()->getSupplier()->getId(), $autoAssignSuppliersIds))
  1822.                         $supplier true;
  1823.                     foreach($t->getTechnicianAreas() as $ta){
  1824.                         $zips = array();
  1825.                         foreach($ta->getZips() as $arrayZip){
  1826.                             array_push($zips$arrayZip[1]);
  1827.                             
  1828.                             if($ticket->getClient()->getIdProvince() == $ta->getIdProvince() && ($ta->isAllZip() || in_array($ticket->getClient()->getZip(), $zips)))
  1829.                                 $area true;
  1830.                         }
  1831.                     }
  1832.                     
  1833.                     array_push($tmp$t$supplier$area);
  1834.                     array_push($technicians$tmp);
  1835.                 }
  1836.             }
  1837.             
  1838.             // TICKET - MODIFICA OPERAZIONE
  1839.             $formOperationEdit $formFactory->createNamed("form_operation"TicketOperationType::class, $ticket, array('supplierId' => $ticket->getSupplier()->getId()));
  1840.             $formOperationEdit->handleRequest($request);
  1841.             if($formOperationEdit->isSubmitted()){
  1842.                 $valid ValidationService::validateNotBlank($validator$formOperationEdit->get("operation"));
  1843.                 if($valid && $formOperationEdit->isValid()){
  1844.                    
  1845.                     $error TicketService::ticketAssignOperationTariffAmount($em$emMaster$ticket);
  1846.                     if($error){
  1847.                         $this->addFlash('notice_warning'"Nessuna tariffa trovata per questa operazione!");
  1848.                         return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  1849.                     }
  1850.                     $em->flush();
  1851.                     $this->addFlash('notice_success'"Operazione aggiornata!");
  1852.                     return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  1853.                 }
  1854.                 else{
  1855.                     $session->set('openModalOperationEdit'true);
  1856.                 }
  1857.             }
  1858.             // TICKET - MODIFICA TARIFFA ASSEGNATA
  1859.             $operationTariffId null;
  1860.             if($ticket->getOperationTariffAmount() != null)
  1861.                 $operationTariffId $ticket->getOperationTariffAmount()->getTariff()->getId();
  1862.             else{
  1863.                 foreach($ticket->getOperation()->getTariffs() as $tar){
  1864.                     $zips = array();
  1865.                     foreach($tar->getZips() as $arrayZip)
  1866.                         array_push($zips$arrayZip[1]);
  1867.                     if($tar->getIdProvince() == $ticket->getIdProvince() && ($tar->isAllZip() || in_array($ticket->getZip(), $zips))){
  1868.                         $operationTariffId $tar->getId();
  1869.                         break;
  1870.                     }
  1871.                 }
  1872.             }
  1873.             $formOperationTariffAmount $formFactory->createNamed("form_operation_tariff_amount"TicketOperationTariffAmountType::class, $ticket, array('operationTariffId' => $operationTariffId));
  1874.             $formOperationTariffAmount->handleRequest($request);
  1875.             if($formOperationTariffAmount->isSubmitted()){
  1876.                 $valid ValidationService::validateNotBlank($validator$formOperationTariffAmount->get('operationTariffAmount'));
  1877.                 
  1878.                 if($valid && $formOperationTariffAmount->isValid()){
  1879.                     $amountTechnician "0.00";
  1880.                     $ota $em->getRepository('App\Entity\Slave\OperationTariffAmount')->findOneById($formOperationTariffAmount->get('operationTariffAmount')->getData());
  1881.                     $ticket->setOperationTariffAmount($ota);
  1882.                     foreach($ota->getTechnicianAreas() as $jttaota){
  1883.                         if($jttaota->getTechnicianArea()->getUser()->getId() == $ticket->getTechnician()->getId()){
  1884.                             $amountTechnician $jttaota->getAmount();
  1885.                             break;
  1886.                         }
  1887.                     }
  1888.                     foreach($ticket->getInterventions() as $i){
  1889.                         $i->setAmount($ota->getAmount());
  1890.                         $i->setAmountTechnician($amountTechnician);
  1891.                     }
  1892.                     if($ticket->getUavOperationTariffAmount() == null){
  1893.                         $uavOt null;
  1894.                         foreach($ticket->getSupplier()->getOperations() as $op){
  1895.                             if($op->isUav()){
  1896.                                 $uavOt $op;
  1897.                                 break;
  1898.                             }
  1899.                         }
  1900.                         foreach($uavOt->getTariffs() as $uavTar){
  1901.                             $zips = array();
  1902.                             foreach($uavTar->getZips() as $arrayZip)
  1903.                                 array_push($zips$arrayZip[1]);
  1904.                 
  1905.                             if($uavTar->getIdProvince() == $ticket->getIdProvince() && ($uavTar->isAllZip() || in_array($ticket->getZip(), $zips))){
  1906.                                 $uavTariff $uavTar;
  1907.                                 break;
  1908.                             }
  1909.                         }
  1910.                         $ticket->setUavOperationTariffAmount($uavTariff->getStandardAmount());
  1911.                     }
  1912.                     $em->flush();
  1913.                     $this->addFlash('notice_success'"Tariffa aggiornata!");
  1914.                     return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  1915.                 }
  1916.                 else{
  1917.                     $ticket $em->getRepository("App\Entity\Slave\Ticket")->findOneById($ticketId);
  1918.                     $session->set('openModalTariff'true);
  1919.                 }
  1920.             }
  1921.             // TICKET - ERRORI - FORNITORE
  1922.             $formErrorSupplier $formFactory->createNamed("form_error_supplier"TicketErrorSupplierType::class, $ticket);
  1923.             $formErrorSupplier->handleRequest($request);
  1924.             if($formErrorSupplier->isSubmitted()){
  1925.                 
  1926.                 $valid ValidationService::validateNotBlank($validator$formErrorSupplier->get("supplier"));
  1927.                 if($valid && $formErrorSupplier->isValid()){
  1928.                     $ticket->setOperation($formErrorSupplier->get("supplier")->getData()->getOperationMaintenance());
  1929.                     $em->flush();
  1930.                     $error true;
  1931.                     if($ticket->getClient()) $error TicketService::ticketMapClient($em$ticket);
  1932.                     if(!$error$error TicketService::ticketMapColumns($em$emMaster$company$ticket);
  1933.                     if(!$errorTicketService::ticketAutoAssign($em$emMaster$ticket);
  1934.                     if(!$error){
  1935.                         $ticket->setSystemError(false);
  1936.                         $ticket->setSystemErrorDetails(null);
  1937.                     }
  1938.                     $em->flush();
  1939.                     $this->addFlash('notice_success'"Ticket aggiornato!");
  1940.                     return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  1941.                 }
  1942.             }
  1943.             // TICKET - ERRORI - OPERAZIONE
  1944.             $supplierId 0;
  1945.             if($ticket->getSupplier() != null)
  1946.                 $supplierId $ticket->getSupplier()->getId();
  1947.             
  1948.             $formErrorOperation $formFactory->createNamed("form_error_operation"TicketErrorOperationType::class, $ticket, array('supplierId' => $supplierId));
  1949.             $formErrorOperation->handleRequest($request);
  1950.             if($formErrorOperation->isSubmitted()){
  1951.                 
  1952.                 $valid ValidationService::validateNotBlank($validator$formErrorOperation->get("operation"));
  1953.                 if($valid && $formErrorOperation->isValid()){
  1954.                     $em->flush();
  1955.                     if($ticket->getClient())
  1956.                         $error TicketService::ticketMapClient($em$ticket);
  1957.                     if(!$error$error TicketService::ticketMapColumns($em$emMaster$company$ticket);
  1958.                     if(!$errorTicketService::ticketAutoAssign($em$emMaster$ticket);
  1959.                     if(!$error){
  1960.                         $ticket->setSystemError(false);
  1961.                         $ticket->setSystemErrorDetails(null);
  1962.                     }
  1963.                     $em->flush();
  1964.                     $this->addFlash('notice_success'"Ticket aggiornato!");
  1965.                     return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  1966.                 }
  1967.             }
  1968.                         
  1969.             // TICKET - ERRORI - CHIAVI COLONNE
  1970.             $formErrorKeyMapping $formFactory->createNamed("form_operation_keys_mapping"OperationKeysMappingType::class, $ticket->getOperation());
  1971.             $formErrorKeyMapping->handleRequest($request);
  1972.             if($formErrorKeyMapping->isSubmitted()){
  1973.                 $valid true;
  1974.                 foreach($formErrorKeyMapping->get('keyMappings') as $keyMapping){
  1975.                     if($valid && $keyMapping->get('keyRequired')->getData()) $valid ValidationService::validateNotBlank($validator$keyMapping->get('mappingValue'));
  1976.                 }
  1977.                 if($valid && $formErrorKeyMapping->isValid()){
  1978.                     $em->flush();
  1979.                     $operationTickets $em->getRepository('App\Entity\Slave\Ticket')->findByOperationAndSystemError($ticket->getOperation(), true);
  1980.                     foreach($operationTickets as $ot){
  1981.                         $error TicketService::ticketMapColumns($em$emMaster$company$ot);
  1982.                         if(!$error$error TicketService::ticketAssignOperationTariffAmount($em$emMaster$ot);
  1983.                         if(!$errorTicketService::ticketAutoAssign($em$emMaster$ot);
  1984.                         if(!$error){
  1985.                             $ot->setSystemError(false);
  1986.                             $ot->setSystemErrorDetails(null);
  1987.                         }
  1988.                     }
  1989.                     $em->flush();
  1990.                     $this->addFlash('notice_success'"Mappatura campi ticket aggiornata!");
  1991.                     return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  1992.                 }
  1993.             }
  1994.             // TICKET - ERRORI - MODIFICA PROVINCIA
  1995.             $formErrorProvince $formFactory->createNamed("form_error_province"TicketErrorProvinceType::class, $ticket);
  1996.             $formErrorProvince->handleRequest($request);
  1997.             if($formErrorProvince->isSubmitted()){
  1998.                 $valid ValidationService::validateNotBlank($validator$formErrorProvince->get('idProvince'));
  1999.                 if($formErrorProvince->isValid() && $valid){
  2000.                     $ticket->setIdProvince($formErrorProvince->get('idProvince')->getData()->getId());
  2001.                     $error TicketService::ticketAssignOperationTariffAmount($em$emMaster$ticket);
  2002.                     if(!$errorTicketService::ticketAutoAssign($em$emMaster$ticket);
  2003.                     if(!$error){
  2004.                         $ticket->setSystemError(false);
  2005.                         $ticket->setSystemErrorSlug(null);
  2006.                     }
  2007.                     $em->flush();
  2008.                     $this->addFlash('notice_success'"Provincia ticket aggiornata!");
  2009.                     return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2010.                 }
  2011.             }
  2012.             // TICKET - ERRORI - MODIFICA INDIRIZZO
  2013.             $formErrorAddress $formFactory->createNamed("form_error_address"TicketErrorAddressType::class, $ticket);
  2014.             $formErrorAddress->handleRequest($request);
  2015.             if($formErrorAddress->isSubmitted()){
  2016.                 if($formErrorAddress->isValid()){
  2017.                     $city $emMaster->getRepository('App\Entity\Master\City')->findOneById($formErrorAddress->get('cityId')->getData());
  2018.                     $zip $emMaster->getRepository('App\Entity\Master\Zip')->findOneById($formErrorAddress->get('zip')->getData());
  2019.                     $ticket->setIdCity($city->getId());
  2020.                     $ticket->setIdProvince($city->getProvince()->getId());
  2021.                     $ticket->setZip($zip->getCode());
  2022.                     $ticket->setSystemError(false);
  2023.                     $ticket->setSystemErrorDetails(null);
  2024.                     $em->flush();
  2025.                     $this->addFlash('notice_success'"Indirizzo ticket aggiornato!");
  2026.                     return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2027.                 }
  2028.             }
  2029.             // TICKET - DATA SCADENZA - MODIFICA
  2030.             $formExpirationDatetimeEdit $formFactory->createNamed("form_expiration_edit"TicketExpirationEditType::class, $ticket);
  2031.             $formExpirationDatetimeEdit->handleRequest($request);
  2032.             if($formExpirationDatetimeEdit->isSubmitted()){
  2033.                 $valid true;
  2034.                 if($valid$valid ValidationService::validateNotBlank($validator$formExpirationDatetimeEdit->get("date"));
  2035.                 if($valid$valid ValidationService::validateNotBlank($validator$formExpirationDatetimeEdit->get("timeHour"));
  2036.                 if($valid$valid ValidationService::validateNotBlank($validator$formExpirationDatetimeEdit->get("timeMinute"));
  2037.                 if($valid && $formExpirationDatetimeEdit->isValid()){
  2038.                     $datetime date_create_from_format("d-m-Y H:i"$formExpirationDatetimeEdit->get('date')->getData()->format('d-m-Y').' '.$formExpirationDatetimeEdit->get('timeHour')->getData().':'.$formExpirationDatetimeEdit->get('timeMinute')->getData());
  2039.                     $ticket->setDatetimeExpiration($datetime);
  2040.                     $em->flush();
  2041.                     $this->addFlash('notice_success'"Data scadenza aggiornata!");
  2042.                     return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2043.                 }
  2044.             }
  2045.             
  2046.             // TICKET - LETTERA DI VETTURA - MODIFICA
  2047.             $formWaybillEdit $formFactory->createNamed("form_waybill_edit"TicketWaybillEditType::class, $ticket);
  2048.             $formWaybillEdit->handleRequest($request);
  2049.             if($formWaybillEdit->isSubmitted()){
  2050.                 if($formWaybillEdit->isValid()){
  2051.                     $em->flush();
  2052.                     $this->addFlash('notice_success'"Lettera di vettura aggiornata!");
  2053.                     return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2054.                 }
  2055.             }
  2056.             // TICKET - SOSPENSIONE - MODIFICA
  2057.             $formSusEdit $formFactory->createNamed("form_suspension_edit"TicketSuspensionEditType::class, $suspension);
  2058.             $formSusEdit->handleRequest($request);
  2059.             if($formSusEdit->isSubmitted()){
  2060.                 $valid true;
  2061.                 if($valid$valid ValidationService::validateNotBlank($validator$formSusEdit->get("dateFrom"));
  2062.                 if($valid$valid ValidationService::validateNotBlank($validator$formSusEdit->get("timeFromHour"));
  2063.                 if($valid$valid ValidationService::validateNotBlank($validator$formSusEdit->get("timeFromMinute"));
  2064.                 if($valid$valid ValidationService::validateNotBlank($validator$formSusEdit->get("dateTo"));
  2065.                 if($valid$valid ValidationService::validateNotBlank($validator$formSusEdit->get("timeToHour"));
  2066.                 if($valid$valid ValidationService::validateNotBlank($validator$formSusEdit->get("timeToMinute"));
  2067.                 if($valid && $formSusEdit->isValid()){
  2068.                     $sus $em->getRepository('App\Entity\Slave\TicketSuspension')->findOneById($formSusEdit->get('id')->getData());
  2069.                     $datetimeFrom date_create_from_format("d-m-Y H:i"$formSusEdit->get('dateFrom')->getData()->format('d-m-Y').' '.$formSusEdit->get('timeFromHour')->getData().':'.$formSusEdit->get('timeFromMinute')->getData());
  2070.                     $datetimeTo date_create_from_format("d-m-Y H:i"$formSusEdit->get('dateTo')->getData()->format('d-m-Y').' '.$formSusEdit->get('timeToHour')->getData().':'.$formSusEdit->get('timeToMinute')->getData());
  2071.                     $sus->setDatetimeFrom($datetimeFrom);
  2072.                     $sus->setDatetimeTo($datetimeTo);
  2073.                     $em->flush();
  2074.                     $this->addFlash('notice_success'"Date sospensione aggiornate!");
  2075.                     return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2076.                 }
  2077.             }
  2078.             
  2079.             // TICKET - SOSPENSIONE - APPROVARE/NON APPROVARE
  2080.             $formSusApprove $formFactory->createNamed("form_suspension_approve"TicketSuspensionApproveType::class, $suspension);
  2081.             $formSusApprove->handleRequest($request);
  2082.             if($formSusApprove->isSubmitted()){
  2083.                 $valid true;
  2084.                 if($formSusApprove->get("isApproved")->getData() == false$valid ValidationService::validateNotBlank($validator$formSusApprove->get("refuseMotivation"));
  2085.                 if($valid && $formSusApprove->isValid()){
  2086.                     $sus $em->getRepository('App\Entity\Slave\TicketSuspension')->findOneById($formSusApprove->get('id')->getData());
  2087.                     $sus->setManaged(true);
  2088.                     $sus->setApproved($formSusApprove->get("isApproved")->getData());
  2089.                     if($sus->isApproved()){
  2090.                         $ticket->setStatus($em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'suspended')));
  2091.                         if($sus->getIntervention()->getOutcomeType()->getSlug() == 'suspended'){
  2092.                             $subject $this->params->get('subject_ticket_suspension_approved');
  2093.                             $template "email/ticket_suspension_approved.html.twig";
  2094.                         }
  2095.                         else{
  2096.                             $subject $this->params->get('subject_ticket_uav_approved');
  2097.                             $template "email/ticket_uav_approved.html.twig";
  2098.                         }
  2099.                         $settingUnlockSameTech $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'ticket_suspension_unlock_same_technician'));
  2100.                         if($settingUnlockSameTech->getValue() != 1)
  2101.                             $ticket->setTechnician(null);
  2102.                     }
  2103.                     else{
  2104.                         $ticket->setStatus($em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'assigned')));
  2105.                         $sus->setRefuseMotivation($formSusApprove->get("refuseMotivation")->getData());
  2106.                         $sus->setUnlocked(1);
  2107.                         $sus->setDatetimeTo(new \Datetime());
  2108.                         $sus->getIntervention()->setBillable(false);
  2109.                         if($sus->getIntervention()->getOutcomeType()->getSlug() == 'suspended'){
  2110.                             $subject $this->params->get('subject_ticket_suspension_not_approved');
  2111.                             $template "email/ticket_suspension_not_approved.html.twig";
  2112.                         }
  2113.                         else{
  2114.                             $subject $this->params->get('subject_ticket_uav_not_approved');
  2115.                             $template "email/ticket_uav_not_approved.html.twig";
  2116.                         }
  2117.                     }
  2118.                     $em->flush();
  2119.                     
  2120.                     $message = (new TemplatedEmail())
  2121.                         ->subject($subject.' '.$ticket->getNumber())
  2122.                         ->from($this->params->get('email_noreply'))
  2123.                         ->to($sus->getIntervention()->getTechnician()->getEmail())
  2124.                         ->htmlTemplate($template)
  2125.                         ->context(['company' => $company'ticket' => $ticket'suspension' => $sus]);
  2126.                     $mailer->send($message);
  2127.                     $this->addFlash('notice_success'"Stato sospensione aggiornato!");
  2128.                     return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2129.                 }
  2130.                 else{                    
  2131.                     $session->set('openModalSuspensionApprove'true);
  2132.                     $session->set('openModalSuspensionApproveId'$formSusApprove->get('id')->getData());
  2133.                     $session->set('openModalSuspensionApproveIs'$formSusApprove->get('isApproved')->getData());
  2134.                 }
  2135.             }
  2136.                         
  2137.             // INTERVENTO - MODIFICA % FUORI SLA E MESE DI FATTURAZIONE
  2138.             $intervention = new Intervention();
  2139.             $formInterventionSla $formFactory->createNamed("form_intervention_sla"InterventionSlaType::class, $intervention);
  2140.             $formInterventionSla->handleRequest($request);
  2141.             if($formInterventionSla->isSubmitted()){
  2142.                 if($formInterventionSla->isValid()){
  2143.                     $editIntervention $em->getRepository('App\Entity\Slave\Intervention')->findOneById($formInterventionSla->get('id')->getData());
  2144.                     if($formInterventionSla->get('slaOutboundPercentage')->getData() != null)
  2145.                         $editIntervention->setSlaOutboundPercentage($formInterventionSla->get('slaOutboundPercentage')->getData());
  2146.                     
  2147.                     $datetimeBilling date_create_from_format('d-m-Y H:i:s'$formInterventionSla->get('dateBilling')->getData()->format('d-m-Y').' 00:00:00');
  2148.                     $editIntervention->setDatetimeBilling($datetimeBilling);
  2149.                     
  2150.                     $em->flush();
  2151.                     $this->addFlash('notice_success'"Dati aggiornati!");
  2152.                     return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2153.                 }
  2154.                 else{
  2155.                     $session->set('openModalInterventionSla'true);
  2156.                     $session->set('openModalInterventionSlaId'$formInterventionSla->get('id')->getData());
  2157.                 }
  2158.             }
  2159.             // TICKET - ELIMINA
  2160.             $formDelete $formFactory->createNamed("form_ticket_delete"TicketDeleteType::class, $ticket);
  2161.             $formDelete->handleRequest($request);
  2162.             if($formDelete->isSubmitted()){
  2163.                 $valid ValidationService::validateNotBlank($validator$formDelete->get('password'));
  2164.                 if($valid && !($passwordHasher->isPasswordValid($this->getUser(), $formDelete->get('password')->getData()))){
  2165.                     $valid false;
  2166.                     $formDelete->get('password')->addError(new FormError('Password errata!'));
  2167.                 }
  2168.                 if($valid && $formDelete->isValid()){
  2169.                     
  2170.                     foreach($ticket->getInterventions() as $intervention){
  2171.                         if($intervention->getSuspension() != null)
  2172.                             $em->remove($intervention->getSuspension());
  2173.                         $em->remove($intervention);
  2174.                     }
  2175.                     
  2176.                     $this->deleteTicketAndConnectedValues($em$ticket);
  2177.                     $em->flush();
  2178.                     $this->addFlash('notice_success'"Ticket eliminato correttamente!");
  2179.                     return $this->redirectToRoute('user_ticket_list');
  2180.                 }
  2181.                 else
  2182.                     $session->set('openDeleteModal'true);
  2183.             }
  2184.             
  2185.             return $this->render('role/user/ticket/sheet.html.twig', array(
  2186.                 'company' => $company,
  2187.                 'ticket' => $ticket,
  2188.                 'cities' => $cities,
  2189.                 'technicians' => $technicians,
  2190.                 'displayJsonReport' => $displayJsonReport,
  2191.                 'settingTechUnlockSuspension' => $settingTechUnlockSuspension,
  2192.                 'settingBackOffice' => $settingBackOffice->getValue(),
  2193.                 'formAddressEdit' => $formAddressEdit->createView(),
  2194.                 'formClientEdit' => $formClientEdit->createView(),
  2195.                 'formDelete' => $formDelete->createView(),
  2196.                 'formErrorAddress' => $formErrorAddress->createView(),
  2197.                 'formErrorKeyMapping' => $formErrorKeyMapping->createView(),
  2198.                 'formErrorOperation' => $formErrorOperation->createView(),
  2199.                 'formErrorProvince' => $formErrorProvince->createView(),
  2200.                 'formErrorSupplier' => $formErrorSupplier->createView(),
  2201.                 'formExpirationDatetimeEdit' => $formExpirationDatetimeEdit->createView(),
  2202.                 'formWaybillEdit' => $formWaybillEdit->createView(),
  2203.                 'formExtraEdit' => $formExtraEdit->createView(),
  2204.                 'formExtraNew' => $formExtraNew->createView(),
  2205.                 'formInterventionSla' => $formInterventionSla->createView(),
  2206.                 'formOperationEdit' => $formOperationEdit->createView(),
  2207.                 'formOperationTariffAmount' => $formOperationTariffAmount->createView(),
  2208.                 'formSusApprove' => $formSusApprove->createView(),
  2209.                 'formSusEdit' => $formSusEdit->createView(),
  2210.                 'formSusUnlock' => $formSusUnlock->createView(),
  2211.                 'formReminderNew' => $formReminderNew->createView(),
  2212.                 'formReminderEdit' => $formReminderEdit->createView()
  2213.             ));
  2214.         }
  2215.         else{
  2216.             return $this->render('role/user/ticket/sheet.html.twig', array(
  2217.                 'company' => $company,
  2218.                 'ticket' => $ticket,
  2219.                 'cities' => $cities,
  2220.                 'displayJsonReport' => $displayJsonReport,
  2221.                 'settingTechUnlockSuspension' => $settingTechUnlockSuspension,
  2222.                 'formClientEdit' => $formClientEdit->createView(),
  2223.                 'settingBackOffice' => $settingBackOffice->getValue(),
  2224.                 'formAddressEdit' => $formAddressEdit->createView(),
  2225.                 'formSusUnlock' => $formSusUnlock->createView(),
  2226.                 'formExtraNew' => $formExtraNew->createView(),
  2227.                 'formExtraEdit' => $formExtraEdit->createView(),
  2228.                 'formReminderNew' => $formReminderNew->createView(),
  2229.                 'formReminderEdit' => $formReminderEdit->createView()
  2230.             ));
  2231.         }
  2232.     }
  2233.     /**
  2234.      * @Route("/{ticketId}/scheda/aggiorna-dati", name="user_ticket_sheet_update_data")
  2235.      * @Security("is_granted('edit', 'ticket')")
  2236.      */
  2237.     public function userTicketSheetUpdateData($ticketIdRequest $request)
  2238.     {
  2239.         $em $this->mr->getManager('slave');
  2240.         $emMaster $this->mr->getManager('master');
  2241.         $session $request->getSession();
  2242.         $session->remove('ticket_id_city_alias');
  2243.         $company $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get('companyId'));
  2244.         $ticket $em->getRepository('App\Entity\Slave\Ticket')->findOneById($ticketId);
  2245.         $operationTickets $em->getRepository('App\Entity\Slave\Ticket')->findByOperationAndSystemError($ticket->getOperation(), true);
  2246.         foreach($operationTickets as $ot){
  2247.             if($ot->getClient() == null)
  2248.                 $error TicketService::ticketMapClient($em$ot);
  2249.             $error TicketService::ticketMapColumns($em$emMaster$company$ot);
  2250.             if(!$error$error TicketService::ticketAssignOperationTariffAmount($em$emMaster$ot);
  2251.             if(!$errorTicketService::ticketAutoAssign($em$emMaster$ot);
  2252.             if(!$error){
  2253.                 $ot->setSystemError(false);
  2254.                 $ot->setSystemErrorDetails(null);
  2255.                 $ot->setStatus($em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'to_assign')));
  2256.             }
  2257.         }
  2258.         $em->flush();
  2259.         $this->addFlash('notice_success'"Dati aggiornati");
  2260.         return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2261.     }
  2262.     /**
  2263.      * @Route("/{ticketId}/reindirizza-configurazione-alias-citta", name="user_ticket_redirect_alias_city")
  2264.      * @Security("is_granted('edit', 'ticket')")
  2265.      */
  2266.     public function userTicketRedirectAliasCity($ticketIdRequest $request)
  2267.     {    
  2268.         $em $this->mr->getManager('slave');
  2269.         $session $request->getSession();
  2270.         $ticket $em->getRepository('App\Entity\Slave\Ticket')->findOneById($ticketId);
  2271.         $keysRequired $em->getRepository('App\Entity\Slave\OperationKeyMapping')->findByOperationAndRequired($ticket->getOperation()->getId(), true);
  2272.         foreach($keysRequired as $k){
  2273.             foreach(json_decode($ticket->getJson(), true) as $val){
  2274.                 if(array_key_exists($k->getMappingValue(), $val)){
  2275.                     switch($k->getTicketColumn()){
  2276.                         case 'Città'$cityName $val[$k->getMappingValue()]; break;
  2277.                         default: break;
  2278.                     }
  2279.                 }
  2280.                 else{
  2281.                     $altKey $k->displayMappingExtraValue("alt_key");
  2282.                     if(array_key_exists($altKey$val)){
  2283.                         switch($k->getTicketColumn()){
  2284.                             case 'Città'$cityName $val[$altKey]; break;
  2285.                             default: break;
  2286.                         }
  2287.                     }
  2288.                 }
  2289.             }
  2290.         }
  2291.                         
  2292.         $session->set('city_alias_value'$cityName);
  2293.         $session->set('ticket_id_city_alias'$ticket->getId());
  2294.         return $this->redirectToRoute('user_configuration_city_aliases');
  2295.     }
  2296.     
  2297.     /**
  2298.      * @Route("/{ticketId}/reindirizza-fornitore-operazione", name="user_ticket_redirect_supplier_operation")
  2299.      * @Security("is_granted('edit', 'ticket')")
  2300.      */
  2301.     public function userTicketRedirectSupplierOperation($ticketIdRequest $request)
  2302.     {    
  2303.         $em $this->mr->getManager('slave');
  2304.         $session $request->getSession();
  2305.         $ticket $em->getRepository('App\Entity\Slave\Ticket')->findOneById($ticketId);
  2306.         $session->set('supplierId'$ticket->getSupplier()->getId());
  2307.         $session->set('operationId'$ticket->getOperation()->getId());
  2308.         return $this->redirectToRoute('user_anagraphic_supplier_operation_sheet', array('operationId' => $ticket->getOperation()->getId()));
  2309.     }
  2310.     /**
  2311.      * @Route("/fatturabile", name="user_ticket_billable")
  2312.      * @Security("is_granted('edit', 'ticket')")
  2313.      */
  2314.     public function userTicketBillable(Request $request)
  2315.     {    
  2316.         $em $this->mr->getManager('slave');
  2317.         $ticket $em->getRepository("App\Entity\Slave\Ticket")->findOneById($request->request->get("ticketId"));
  2318.         $ticket->setBillable(!$ticket->isBillable());
  2319.         $em->flush();
  2320.         $text 'non fatturabile';
  2321.         if($ticket->isBillable())
  2322.             $text 'da fatturare';
  2323.         $this->addFlash('notice_success'"Ticket reso ".$text."!");
  2324.         return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2325.     }    
  2326.     
  2327.     /**
  2328.      * @Route("/intervento/non-fatturabile", name="user_ticket_intervention_not_billable")
  2329.      * @Security("is_granted('edit', 'ticket')")
  2330.      */
  2331.     public function userTicketInterventionNotBillable(Request $request)
  2332.     {    
  2333.         $em $this->mr->getManager('slave');
  2334.         $intervention $em->getRepository("App\Entity\Slave\Intervention")->findOneById($request->request->get("interventionId"));
  2335.         $intervention->setBillable(!$intervention->isBillable());
  2336.         $em->flush();
  2337.         $text 'non fatturabile';
  2338.         if($intervention->isBillable())
  2339.             $text 'da fatturare';
  2340.         $this->addFlash('notice_success'"Intervento reso ".$text."!");
  2341.         return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $intervention->getTicket()->getId()));
  2342.     }
  2343.     
  2344.     /**
  2345.      * @Route("/intervento-extra/elimina", name="user_ticket_intervention_extra_delete")
  2346.      * @Security("is_granted('edit', 'ticket')")
  2347.      */
  2348.     public function userTicketInterventionExtraDelete(Request $request)
  2349.     {    
  2350.         $em $this->mr->getManager('slave');
  2351.         $interventionExtra $em->getRepository("App\Entity\Slave\InterventionExtra")->findOneById($request->request->get("interventionExtraDelId"));
  2352.         $ticketId $interventionExtra->getIntervention()->getTicket()->getId();
  2353.         $em->remove($interventionExtra);
  2354.         $em->flush();
  2355.         $this->addFlash('notice_success'"Extra ticket eliminato");
  2356.         return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticketId));
  2357.     }
  2358.     
  2359.     /**
  2360.      * @Route("/promemoria/elimina", name="user_ticket_reminder_delete")
  2361.      * @Security("is_granted('edit', 'ticket')")
  2362.      */
  2363.     public function userTicketReminderDelete(Request $request)
  2364.     {    
  2365.         $em $this->mr->getManager('slave');
  2366.         $ticketReminder $em->getRepository("App\Entity\Slave\TicketReminder")->findOneById($request->request->get("reminderDelId"));
  2367.         $ticketId $ticketReminder->getTicket()->getId();
  2368.         $em->remove($ticketReminder);
  2369.         $em->flush();
  2370.         $this->addFlash('notice_success'"Reminder ticket eliminato");
  2371.         return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticketId));
  2372.     }
  2373.     
  2374.     /**
  2375.      * @Route("/intervento-extra/invia-approva", name="user_ticket_intervention_extra_send_approve")
  2376.      * @Security("is_granted('edit', 'ticket')")
  2377.      */
  2378.     public function userTicketInterventionExtraSendApprove(Request $request)
  2379.     {    
  2380.         $em $this->mr->getManager('slave');
  2381.         $interventionExtra $em->getRepository("App\Entity\Slave\InterventionExtra")->findOneById($request->request->get("interventionExtraId"));
  2382.         $interventionExtra->setManaged(true);
  2383.         if($request->request->get('interventionExtraStatus') == 'approve')
  2384.             $interventionExtra->setApproved(true);
  2385.         else
  2386.             $interventionExtra->setApproved(false);
  2387.         $em->flush();
  2388.         $this->addFlash('notice_success'"Extra ticket aggiornato");
  2389.         return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $interventionExtra->getIntervention()->getTicket()->getId()));
  2390.     }
  2391.     // AZIONI AGENZIA
  2392.     /**
  2393.      * @Route("/scheda/tecnico-assegna", name="user_ticket_technician_assign")
  2394.      * @Security("is_granted('edit', 'ticket')")
  2395.      */
  2396.     public function userTicketTechnicianAssign(Request $requestMailerInterface $mailer)
  2397.     {    
  2398.         $em $this->mr->getManager('slave');
  2399.         $technician $em->getRepository("App\Entity\Slave\User")->findOneById($request->request->get('technicianId'));
  2400.         $ticket $em->getRepository("App\Entity\Slave\Ticket")->findOneById($request->request->get('ticketId'));
  2401.         $statusAssigned $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'assigned'));
  2402.         
  2403.         // Notifico il vecchio tecnico se impostazione attiva
  2404.         $oldTechnician $ticket->getTechnician();
  2405.         $settingSendEmail $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'ticket_technician_send_cancel_email'));
  2406.         if($oldTechnician != null && $settingSendEmail->getValue() == 1){
  2407.             $message = (new TemplatedEmail())
  2408.                 ->subject($this->params->get('subject_ticket_canceled').' '.$ticket->getNumber())
  2409.                 ->from($this->params->get('email_noreply'))
  2410.                 ->to($oldTechnician->getEmail())
  2411.                 ->htmlTemplate('email/ticket_canceled.html.twig')
  2412.                 ->context(['technician' => $oldTechnician'ticket' => $ticket]);
  2413.             $mailer->send($message);
  2414.         }
  2415.         $ticket->setTechnician($technician);
  2416.         $ticket->setStatus($statusAssigned);
  2417.         $em->flush();
  2418.         $this->addFlash('notice_success'"Ticket assegnato");
  2419.         return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2420.     }
  2421.     /**
  2422.      * @Route("/scheda/cancella", name="user_ticket_cancel")
  2423.      * @Security("is_granted('edit', 'ticket')")
  2424.      */
  2425.     public function userTicketCancel(Request $requestMailerInterface $mailer)
  2426.     {    
  2427.         $em $this->mr->getManager('slave');
  2428.         $ticket $em->getRepository("App\Entity\Slave\Ticket")->findOneById($request->request->get('ticketId'));
  2429.         $statusCanceled $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'canceled'));
  2430.         // Notifico il tecnico se impostazione attiva
  2431.         $settingSendEmail $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'ticket_technician_send_cancel_email'));
  2432.         if($settingSendEmail->getValue() == && $ticket->getTechnician() != null && ($ticket->getStatus()->getSlug() != 'closed' && $ticket->getStatus()->getSlug() != 'closed_portal')){
  2433.             $message = (new TemplatedEmail())
  2434.                 ->subject($this->params->get('subject_ticket_canceled').' '.$ticket->getNumber())
  2435.                 ->from($this->params->get('email_noreply'))
  2436.                 ->to($ticket->getTechnician()->getEmail())
  2437.                 ->htmlTemplate('email/ticket_canceled.html.twig')
  2438.                 ->context(['technician' => $ticket->getTechnician(), 'ticket' => $ticket]);
  2439.             $mailer->send($message);
  2440.         }
  2441.         $ticket->setStatus($statusCanceled);
  2442.         $em->flush();
  2443.         $this->addFlash('notice_success'"Ticket annullato");
  2444.         return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2445.     }
  2446.     
  2447.     /**
  2448.      * @Route("/scheda/errato", name="user_ticket_wrong")
  2449.      * @Security("is_granted('edit', 'ticket')")
  2450.      */
  2451.     public function userTicketWrong(Request $request)
  2452.     {    
  2453.         $em $this->mr->getManager('slave');
  2454.         $ticket $em->getRepository("App\Entity\Slave\Ticket")->findOneById($request->request->get('ticketId'));
  2455.         $statusWrong $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'wrong'));
  2456.         
  2457.         $ticket->setSystemError(false);
  2458.         $ticket->setSystemErrorSlug(null);
  2459.         $ticket->setSystemErrorDetails(null);
  2460.         $ticket->setStatus($statusWrong);
  2461.         $em->flush();
  2462.         $this->addFlash('notice_success'"Ticket spostato in errati");
  2463.         return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2464.     }
  2465.     
  2466.     /**
  2467.      * @Route("/scheda/ripristina", name="user_ticket_restore")
  2468.      * @Security("is_granted('edit', 'ticket')")
  2469.      */
  2470.     public function userTicketRestore(Request $request)
  2471.     {    
  2472.         $em $this->mr->getManager('slave');
  2473.         $ticket $em->getRepository("App\Entity\Slave\Ticket")->findOneById($request->request->get('ticketId'));
  2474.         $statusToAssign $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'to_assign'));
  2475.         $statusAssigned $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'assigned'));
  2476.         if($ticket->getTechnician() != null)
  2477.             $ticket->setStatus($statusAssigned);
  2478.         else
  2479.             $ticket->setStatus($statusToAssign);
  2480.         $em->flush();
  2481.         $this->addFlash('notice_success'"Ticket ripristinato");
  2482.         return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2483.     }
  2484.     
  2485.     /**
  2486.      * @Route("/scheda/prendi-in-carico", name="user_ticket_taken_charge")
  2487.      * @Security("is_granted('edit', 'ticket')")
  2488.      */
  2489.     public function userTicketTakenCharge(Request $request)
  2490.     {    
  2491.         $em $this->mr->getManager('slave');
  2492.         $session $request->getSession();
  2493.         $ticket $em->getRepository("App\Entity\Slave\Ticket")->findOneById($request->request->get('ticketId'));
  2494.         $ticket->setStatus($em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'taken_charge')));
  2495.         $em->flush();
  2496.         $this->addFlash('notice_success'"Ticket ripreso in carico");
  2497.         return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2498.     }
  2499.     
  2500.     /**
  2501.      * @Route("/scheda/completa", name="user_ticket_close")
  2502.      * @Security("is_granted('edit', 'ticket')")
  2503.      */
  2504.     public function userTicketClose(Request $request)
  2505.     {    
  2506.         $em $this->mr->getManager('slave');
  2507.         $ticket $em->getRepository("App\Entity\Slave\Ticket")->findOneById($request->request->get('ticketClosedId'));
  2508.         $ticket->setStatus($em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'closed')));
  2509.         $ticket->setClosedOnPortal(0);
  2510.         $ticket->setDatetimeEnd(new \Datetime());
  2511.         $em->flush();
  2512.         $this->addFlash('notice_success'"Ticket chiuso");
  2513.         return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2514.     }
  2515.     /**
  2516.      * @Route("/scheda/chiuso-su-portale-fornitore", name="user_ticket_closed_on_portal")
  2517.      * @Security("is_granted('edit', 'ticket')")
  2518.      */
  2519.     public function userTicketCloseOnPortal(Request $request)
  2520.     {    
  2521.         $em $this->mr->getManager('slave');
  2522.         $ticket $em->getRepository("App\Entity\Slave\Ticket")->findOneById($request->request->get('ticketClosedPortalId'));
  2523.         $ticket->setStatus($em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'closed_portal')));
  2524.         $ticket->setClosedOnPortal(1);
  2525.         $em->flush();
  2526.         $this->addFlash('notice_success'"Ticket contrassegnato come chiuso su portale cliente");
  2527.         return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2528.     }
  2529.     // AZIONI TECNICO / AGENZIA SE SETTING TICKET_MANAGE == 1
  2530.     /**
  2531.      * @Route("/{ticketId}/scheda/prendi-in-carico", name="user_ticket_take_charge_single")
  2532.      * @Security("is_granted('edit', 'ticket')")
  2533.      */
  2534.     public function userTicketTakeChargeSingle($ticketIdRequest $request)
  2535.     {    
  2536.         $em $this->mr->getManager('slave');
  2537.         $session $request->getSession();
  2538.         $ticket $em->getRepository("App\Entity\Slave\Ticket")->findOneById($ticketId);
  2539.         $statusTakeCharge $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'taken_charge'));
  2540.         $ticket->setStatus($statusTakeCharge);
  2541.         $em->flush();
  2542.         $this->addFlash('notice_success'"Ticket preso in carico");
  2543.         return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2544.     }
  2545.     
  2546.     /**
  2547.      * @Route("/{ticketId}/scheda/verbale-stampa", name="user_ticket_report_print_single")
  2548.      * @Security("is_granted('view', 'ticket')")
  2549.      */
  2550.     public function userTicketReportPrintSingle($ticketIdRequest $request)
  2551.     {    
  2552.         $em $this->mr->getManager('slave');
  2553.         $ticket $em->getRepository("App\Entity\Slave\Ticket")->findOneById($ticketId);
  2554.         $matrixTickets = array();
  2555.         $jsonReportValues = array();
  2556.         $tmp = array();
  2557.         if($ticket->getJsonReport() != '[]'){
  2558.             $matrix json_decode($ticket->getJsonReport(), true);
  2559.             foreach($matrix as $array)
  2560.                 foreach($array as $a){
  2561.                     $tcv $em->getRepository('App\Entity\Slave\TicketColumnValue')->findOneBySupplierTicketColumnAndNeedle($ticket->getSupplier()->getId(), array_keys($array)[0], $a);
  2562.                     $htmlToAdd '';
  2563.                     if($tcv != null)
  2564.                         $htmlToAdd ' ('.$tcv->getValue().')';
  2565.                     $jsonReportValues[array_keys($array)[0]] = $a.$htmlToAdd;
  2566.                 }
  2567.         }
  2568.         array_push($tmp$ticket$jsonReportValues);
  2569.         array_push($matrixTickets$tmp);
  2570.         return $this->render('role/user/print/report.html.twig', array(
  2571.             'matrixTickets' => $matrixTickets,
  2572.             'backRoute' => 'sheet',
  2573.             'continueRoute' => 'sheet'
  2574.         ));
  2575.     }
  2576.     /**
  2577.      * @Route("/scheda/intervento/seleziona", name="user_ticket_intervention_select")
  2578.      * @Security("is_granted('edit', 'ticket')")
  2579.      */
  2580.     public function userTicketInterventionSelect(Request $request)
  2581.     {    
  2582.         $em $this->mr->getManager('slave');
  2583.         $ticket $em->getRepository('App\Entity\Slave\Ticket')->findOneById($request->request->get('ticketId'));
  2584.         $outcomeType $em->getRepository('App\Entity\Slave\InterventionOutcomeType')->findOneBy(array('slug' => $request->request->get('interventionOutcomeTypeSlug')));
  2585.         $today = new \Datetime();
  2586.         $intervention = new Intervention();
  2587.         $intervention->setTicket($ticket);
  2588.         $intervention->setOutcomeType($outcomeType);
  2589.         $intervention->setDatetime($today);
  2590.         $intervention->setDatetimeBilling(date_create_from_format('d-m-Y H:i:s''01-'.$today->format('m').'-'.$today->format('Y').' 00:00:00'));
  2591.         $em->persist($intervention);
  2592.         $em->flush();
  2593.         if($intervention->getOutcomeType()->getSlug() == 'completed'){
  2594.             // Completato --- Vado al seleziona attivita
  2595.             $warehouse $em->getRepository('App\Entity\Slave\Warehouse')->findOneById($request->request->get('interventionWarehouseId'));
  2596.             $intervention->setWarehouse($warehouse);
  2597.             $em->flush();
  2598.             return $this->redirectToRoute('user_ticket_intervention_activity_summary', array('interventionId' => $intervention->getId()));
  2599.         }
  2600.         else{
  2601.             // A vuoto/Sospeso --- Vado direttamente ai dettagli intervento
  2602.             return $this->redirectToRoute("user_ticket_intervention", array('interventionId' => $intervention->getId()));
  2603.         }
  2604.     }
  2605.     /**
  2606.      * @Route("/intervento-incompleto/elimina", name="user_ticket_intervention_delete")
  2607.      * @Security("is_granted('edit', 'ticket')")
  2608.      */
  2609.     public function userTicketInterventionDelete(Request $request)
  2610.     {    
  2611.         $em $this->mr->getManager('slave');
  2612.         $intervention $em->getRepository("App\Entity\Slave\Intervention")->findOneById($request->request->get("interventionDelId"));
  2613.         $ticket $intervention->getTicket();
  2614.         $ticketId $intervention->getTicket()->getId();
  2615.         foreach($intervention->getActivities() as $activity){
  2616.             // Withdraw
  2617.             if($activity->getProductWithdraw() != null){
  2618.                 // Controllo: se l'ho inserita adesso elimino il prodotto altrimenti lo ritrasferisco indietro
  2619.                 if($activity->getProductWithdraw()->getIsAlreadyInserted('withdraw')){
  2620.                     $productToDelete $activity->getProductWithdraw();
  2621.                     $activity->setProductWithdraw(null);
  2622.                     $this->deleteProductAlreadyInserted($em$productToDelete);
  2623.                 }
  2624.                 else{
  2625.                     $oldStatus $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'in_use'));
  2626.                     $oldCondition $em->getRepository('App\Entity\Slave\ProductCondition')->findOneById($intervention->getLastProductLog('condition')->getOldDataId());
  2627.                     ProductService::createProductLog($em$activity->getProductWithdraw(), $this->getUser(), 'status'$oldStatus->getValue(), null$activity->getProductWithdraw()->getStatus()->getId());
  2628.                     ProductService::createProductLog($em$activity->getProductWithdraw(), $this->getUser(), 'condition'$oldCondition->getValue(), null$activity->getProductWithdraw()->getCondition()->getId());
  2629.                     $activity->getProductWithdraw()->setStatus($oldStatus);
  2630.                     $activity->getProductWithdraw()->setCondition($oldCondition);
  2631.                     $activity->getProductWithdraw()->setTermid($ticket->getTermid());
  2632.                     ProductService::moveProductClient($em$activity->getProductWithdraw(), $ticket->getClient()->getWarehouse());
  2633.                     ProductService::createProductTransferLogClient($em$activity->getProductWithdraw(), $this->getUser(), $intervention->getWarehouse(), $ticket->getClient()->getWarehouse(), new \Datetime(), 'scan');
  2634.                 }
  2635.             }
  2636.             // Actual
  2637.             if($activity->getProductActual() != null){
  2638.                 // Controllo: se l'ho inserita adesso elimino il prodotto altrimenti lo ritrasferisco indietro
  2639.                 if($activity->getProductActual()->getIsAlreadyInserted('actual')){
  2640.                     $productToDelete $activity->getProductActual();
  2641.                     $activity->setProductActual(null);
  2642.                     $this->deleteProductAlreadyInserted($em$productToDelete);
  2643.                 }
  2644.                 else{
  2645.                     $activity->getProductActual()->setTermid($ticket->getTermid());
  2646.                     ProductService::moveProductClient($em$activity->getProductActual(), $ticket->getClient()->getWarehouse());
  2647.                 }
  2648.             }
  2649.             // Installation
  2650.             if($activity->getProductInstallation() != null){
  2651.                 $oldStatus $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'available'));
  2652.                 ProductService::createProductLog($em$activity->getProductInstallation(), $this->getUser(), 'status'$oldStatus->getValue(), $intervention$activity->getProductInstallation()->getStatus()->getId());
  2653.                 $activity->getProductInstallation()->setStatus($oldStatus);
  2654.                 $activity->getProductInstallation()->setTermid(null);
  2655.                 ProductService::moveProductClient($em$activity->getProductInstallation(), $intervention->getWarehouse());
  2656.                 ProductService::createProductTransferLogClient($em$activity->getProductInstallation(), $this->getUser(), $ticket->getClient()->getWarehouse(), $intervention->getWarehouse(), new \Datetime(), 'scan');
  2657.             }
  2658.             $em->remove($activity);
  2659.         }
  2660.         foreach($intervention->getProductLogs() as $log){
  2661.             $log->setIntervention(null);
  2662.         }
  2663.         $em->flush();
  2664.         $em->remove($intervention);
  2665.         $em->flush();
  2666.         if($ticket->getInterventionCompleted() == null){
  2667.             $ticket->setDatetimeEnd(null);
  2668.             if($ticket->getStatus()->getSlug() == "closed" || $ticket->getStatus()->getSlug() == "closed_portal"){
  2669.                 $statusAssigned $em->getRepository("App\Entity\Slave\TicketStatus")->findOneBySlug("assigned");
  2670.                 $ticket->setStatus($statusAssigned);
  2671.             }
  2672.             $em->flush();
  2673.         }
  2674.         $this->addFlash('notice_success'"Intervento eliminato correttamente");
  2675.         return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticketId));
  2676.     }
  2677.     
  2678.     /**
  2679.      * @Route("/{interventionId}/scheda/intervento/modifica", name="user_ticket_intervention_edit")
  2680.      * @Security("is_granted('edit', 'ticket')")
  2681.      */
  2682.     public function userTicketInterventionEdit($interventionIdRequest $request)
  2683.     {    
  2684.         $em $this->mr->getManager('slave');
  2685.         $intervention $em->getRepository('App\Entity\Slave\Intervention')->findOneById($interventionId);
  2686.         if($intervention->getOutcomeType()->getSlug() == 'completed')
  2687.             return $this->redirectToRoute('user_ticket_intervention_activity_summary', array('interventionId' => $intervention->getId()));
  2688.         else
  2689.             return $this->redirectToRoute("user_ticket_intervention", array('interventionId' => $intervention->getId()));
  2690.     }
  2691.     /**
  2692.      * @Route("/{interventionId}/scheda/intervento/attivita-riassunto", name="user_ticket_intervention_activity_summary")
  2693.      * @Security("is_granted('edit', 'ticket')")
  2694.      */
  2695.     public function userTicketInterventionActivitySelect($interventionIdRequest $request)
  2696.     {    
  2697.         $em $this->mr->getManager('slave');
  2698.         $session $request->getSession();
  2699.         $intervention $em->getRepository("App\Entity\Slave\Intervention")->findOneById($interventionId);
  2700.         $ticket $intervention->getTicket();
  2701.         $components $em->getRepository("App\Entity\Slave\ProductComponent")->findAll();
  2702.         // Se tecnico -> Escludo i tipi attività solo backoffice
  2703.         if($this->getUser()->getAccountTypology() == 'technician')
  2704.             $interventionActivityTypes $em->getRepository('App\Entity\Slave\InterventionActivityType')->findVisibleByOperationGroupAndOnlyBackoffice($ticket->getOperation()->getGroup()->getSlug(), false);
  2705.         else
  2706.             $interventionActivityTypes $em->getRepository('App\Entity\Slave\InterventionActivityType')->findVisibleByOperationGroupAndOnlyBackoffice($ticket->getOperation()->getGroup()->getSlug(), true);
  2707.         return $this->render('role/user/ticket/intervention/activity/summary.html.twig', array(
  2708.             'ticket' => $ticket,
  2709.             'components' => $components,
  2710.             'intervention' => $intervention,
  2711.             'interventionActivityTypes' => $interventionActivityTypes
  2712.         ));
  2713.     }
  2714.     /**
  2715.      * @Route("/scheda/intervento/attivita-cancella", name="user_ticket_intervention_activity_delete")
  2716.      * @Security("is_granted('edit', 'ticket')")
  2717.      */
  2718.     public function userTicketInterventionActivityDelete(Request $request)
  2719.     {    
  2720.         $em $this->mr->getManager('slave');
  2721.         $session $request->getSession();
  2722.         $activity $em->getRepository("App\Entity\Slave\InterventionActivity")->findOneById($request->request->get('activityId'));
  2723.         $intervention $activity->getIntervention();
  2724.         $ticket $intervention->getTicket();
  2725.         // Withdraw
  2726.         if($activity->getProductWithdraw() != null){
  2727.             // Controllo: se l'ho inserita adesso elimino il prodotto altrimenti lo ritrasferisco indietro
  2728.             if($activity->getProductWithdraw()->getIsAlreadyInserted('withdraw')){
  2729.                 $productToDelete $activity->getProductWithdraw();
  2730.                 $activity->setProductWithdraw(null);
  2731.                 $this->deleteProductAlreadyInserted($em$productToDelete);
  2732.             }
  2733.             else{
  2734.                 $oldStatus $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'in_use'));
  2735.                 $oldCondition $em->getRepository('App\Entity\Slave\ProductCondition')->findOneById($intervention->getLastProductLog('condition')->getOldDataId());
  2736.                 ProductService::createProductLog($em$activity->getProductWithdraw(), $this->getUser(), 'status'$oldStatus->getValue(), null$activity->getProductWithdraw()->getStatus()->getId());
  2737.                 ProductService::createProductLog($em$activity->getProductWithdraw(), $this->getUser(), 'condition'$oldCondition->getValue(), null$activity->getProductWithdraw()->getCondition()->getId());
  2738.                 $activity->getProductWithdraw()->setStatus($oldStatus);
  2739.                 $activity->getProductWithdraw()->setCondition($oldCondition);
  2740.                 $activity->getProductWithdraw()->setTermid($ticket->getTermid());
  2741.                 ProductService::moveProductClient($em$activity->getProductWithdraw(), $ticket->getClient()->getWarehouse());
  2742.                 ProductService::createProductTransferLogClient($em$activity->getProductWithdraw(), $this->getUser(), $intervention->getWarehouse(), $ticket->getClient()->getWarehouse(), new \Datetime(), 'scan');
  2743.             }
  2744.         }
  2745.         // Actual
  2746.         if($activity->getProductActual() != null){
  2747.             // Controllo: se l'ho inserita adesso elimino il prodotto altrimenti lo ritrasferisco indietro
  2748.             if($activity->getProductActual()->getIsAlreadyInserted('actual')){
  2749.                 $productToDelete $activity->getProductActual();
  2750.                 $activity->setProductActual(null);
  2751.                 $this->deleteProductAlreadyInserted($em$productToDelete);
  2752.             }
  2753.             else{
  2754.                 $activity->getProductActual()->setTermid($ticket->getTermid());
  2755.                 ProductService::moveProductClient($em$activity->getProductActual(), $ticket->getClient()->getWarehouse());
  2756.             }
  2757.         }
  2758.         // Installation
  2759.         if($activity->getProductInstallation() != null){
  2760.             $oldStatus $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'available'));
  2761.             ProductService::createProductLog($em$activity->getProductInstallation(), $this->getUser(), 'status'$oldStatus->getValue(), $intervention$activity->getProductInstallation()->getStatus()->getId());
  2762.             $activity->getProductInstallation()->setStatus($oldStatus);
  2763.             $activity->getProductInstallation()->setTermid(null);
  2764.             ProductService::moveProductClient($em$activity->getProductInstallation(), $intervention->getWarehouse());
  2765.             ProductService::createProductTransferLogClient($em$activity->getProductInstallation(), $this->getUser(), $ticket->getClient()->getWarehouse(), $intervention->getWarehouse(), new \Datetime(), 'scan');
  2766.         }
  2767.         $em->remove($activity);
  2768.         $em->flush();
  2769.         $this->addFlash('notice_success''Attivita eliminata correttamente!');
  2770.         return $this->redirectToRoute('user_ticket_intervention_activity_summary', array('interventionId' => $intervention->getId()));
  2771.     }
  2772.     /**
  2773.      * @Route("/scheda/intervento/{interventionId}/attivita/{activityTypeId}", name="user_ticket_intervention_activity")
  2774.      * @Security("is_granted('edit', 'ticket')")
  2775.      */
  2776.     public function userTicketInterventionActivity($interventionId$activityTypeIdRequest $requestValidatorInterface $validatorFormFactoryInterface $formFactory)
  2777.     {    
  2778.         $em $this->mr->getManager('slave');
  2779.         $emMaster $this->mr->getManager('master');
  2780.         $session $request->getSession();
  2781.         $company $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get('companyId'));
  2782.         $activityType $em->getRepository("App\Entity\Slave\InterventionActivityType")->findOneById($activityTypeId);
  2783.         $intervention $em->getRepository("App\Entity\Slave\Intervention")->findOneById($interventionId);
  2784.         $ticket $intervention->getTicket();
  2785.         $activity = new InterventionActivity();
  2786.         $form $formFactory->createNamed("form_intervention_activity"InterventionActivityType::class, $activity);
  2787.         $form->handleRequest($request);
  2788.         if($form->isSubmitted()){
  2789.             
  2790.             $valid FormValidatorService::validateInterventionActivity($validator$form$activityType$ticket$intervention$em);
  2791.             if($valid && $form->isValid()){
  2792.             
  2793.                 $activity->setIntervention($intervention);
  2794.                 $activity->setType($activityType);
  2795.                 // Withdraw
  2796.                 if($activityType->isProducerWithdrawMandatory() || $activityType->isSupplierWithdrawMandatory()){
  2797.                     $withdrawProduct $this->activityProductByType($em$form'Withdraw', array($ticket->getSupplier()));
  2798.                     // Se cambia il modello lo aggiorno al prodotto che ho disinstallato
  2799.                     $withdrawModel $em->getRepository('App\Entity\Slave\ProductModel')->findOneById($form->get('modelWithdrawId')->getData());
  2800.                     if($withdrawModel != null)
  2801.                         $withdrawProduct->setModel($withdrawModel);
  2802.                     $activity->setProductWithdraw($withdrawProduct);
  2803.                     if($activityType->isSupplierWithdrawMandatory()){
  2804.                         $activity->setSupplierWithdraw($form->get('supplierWithdraw')->getData());
  2805.                         $transferLogType $form->get('scanOrManualSupplierWithdraw')->getData();
  2806.                     }
  2807.                     if($activityType->isProducerWithdrawMandatory()){
  2808.                         $activity->setProducerWithdraw($form->get('producerWithdraw')->getData());
  2809.                         $transferLogType $form->get('scanOrManualProducerWithdraw')->getData();
  2810.                     }
  2811.                     $components $em->getRepository('App\Entity\Slave\ProductComponent')->findAll();
  2812.                     $arrayComponents = array();
  2813.                     foreach($components as $c){
  2814.                         $cp $request->request->get('component_'.$c->getId());
  2815.                         if($cp == 'on')
  2816.                             array_push($arrayComponents$c->getId());
  2817.                     }
  2818.                     $activity->setComponents($arrayComponents);
  2819.                     $newStatus $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'not_available'));
  2820.                     $newCondition $em->getRepository('App\Entity\Slave\ProductCondition')->findOneBy(array('slug' => 'retired'));
  2821.                     ProductService::createProductLog($em$activity->getProductWithdraw(), $this->getUser(), 'status'$newStatus->getValue(), $intervention$activity->getProductWithdraw()->getStatus()->getId());
  2822.                     ProductService::createProductLog($em$activity->getProductWithdraw(), $this->getUser(), 'condition'$newCondition->getValue(), $intervention$activity->getProductWithdraw()->getCondition()->getId());
  2823.                     $activity->getProductWithdraw()->setStatus($newStatus);
  2824.                     $activity->getProductWithdraw()->setCondition($newCondition);
  2825.                     $activity->getProductWithdraw()->setTermid(null);
  2826.                     ProductService::createProductTransferLogClient($em$activity->getProductWithdraw(), $this->getUser(), $ticket->getClient()->getWarehouse(), $intervention->getWarehouse(), new \Datetime(), $transferLogType);
  2827.                     ProductService::moveProductClient($em$activity->getProductWithdraw(), $intervention->getWarehouse());
  2828.                 }
  2829.                 // Actual
  2830.                 if($activityType->isProducerActualMandatory() || $activityType->isSupplierActualMandatory()){
  2831.                     $actualProduct $this->activityProductByType($em$form'Actual', array($ticket->getSupplier()));
  2832.                     // Se cambia il modello lo aggiorno al prodotto che c'è installato 
  2833.                     // Questa azione potrebbe creare un problema se un tecnico installa qualcosa, poi fa un evento di aggiornamento dove cambia il modello, poi lo elimina, ha di fatto baypassato l'impossibilità del tecnico di cambiare modello ad un prodotto.
  2834.                     // In ogni caso, quando poi la merce torna in magazzino, viene sistemato il tutto, quindi non è un reale problema.
  2835.                     $actualModel $em->getRepository('App\Entity\Slave\ProductModel')->findOneById($form->get('modelActualId')->getData());
  2836.                     if($actualModel != null)
  2837.                         $actualProduct->setModel($actualModel);
  2838.                     $activity->setProductActual($actualProduct);
  2839.                     if($activityType->isProducerActualMandatory()){
  2840.                         $activity->setProducerActual($form->get('producerActual')->getData());
  2841.                         $transferLogType $form->get('scanOrManualProducerActual')->getData();
  2842.                     }
  2843.                     if($activityType->isSupplierActualMandatory()){
  2844.                         $activity->setSupplierActual($form->get('supplierActual')->getData());
  2845.                         $transferLogType $form->get('scanOrManualSupplierActual')->getData();
  2846.                     }
  2847.                     $activity->getProductActual()->setTermid($ticket->getTermid());
  2848.                     ProductService::moveProductClient($em$activity->getProductActual(), $ticket->getClient()->getWarehouse());
  2849.                 }
  2850.                 // Installation
  2851.                 if($activityType->isProducerInstallationMandatory() || $activityType->isSupplierInstallationMandatory()){
  2852.                     $installationProduct $this->activityProductByType($em$form'Installation', array($ticket->getSupplier()));
  2853.                     // Il modello non cambia mai, perché viene dettato dal magazzino, quindi non consento la modifica
  2854.                     $activity->setProductInstallation($installationProduct);
  2855.                     if($activityType->isProducerInstallationMandatory()){
  2856.                         $activity->setProducerInstallation($form->get('producerInstallation')->getData());
  2857.                         $transferLogType $form->get('scanOrManualProducerInstallation')->getData();
  2858.                     }
  2859.                     if($activityType->isSupplierInstallationMandatory()){
  2860.                         $activity->setSupplierInstallation($form->get('supplierInstallation')->getData());
  2861.                         $transferLogType $form->get('scanOrManualSupplierInstallation')->getData();
  2862.                     }
  2863.                     $newStatus $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'in_use'));
  2864.                     ProductService::createProductLog($em$activity->getProductInstallation(), $this->getUser(), 'status'$newStatus->getValue(), $intervention$activity->getProductInstallation()->getStatus()->getId());
  2865.                     $activity->getProductInstallation()->setStatus($newStatus);
  2866.                     $activity->getProductInstallation()->setTermid($ticket->getTermid());
  2867.                     ProductService::createProductTransferLogClient($em$activity->getProductInstallation(), $this->getUser(), $intervention->getWarehouse(), $ticket->getClient()->getWarehouse(), new \Datetime(), $transferLogType);
  2868.                     ProductService::moveProductClient($em$activity->getProductInstallation(), $ticket->getClient()->getWarehouse());
  2869.                 }
  2870.                 $em->persist($activity);
  2871.                 $em->flush();
  2872.                 return $this->redirectToRoute('user_ticket_intervention_activity_summary', array('interventionId' => $intervention->getId()));
  2873.             }
  2874.         }
  2875.         return $this->render('role/user/ticket/intervention/activity/single.html.twig', array(
  2876.             'company' => $company,
  2877.             'ticket' => $ticket,
  2878.             'intervention' => $intervention,
  2879.             'activityType' => $activityType,
  2880.             'isPos' => $activityType->isPos(),
  2881.             'form' => $form->createView()
  2882.         ));
  2883.     }
  2884.     /**
  2885.      * @Route("/scheda/intervento/attivita-prodotti-cerca-codice", name="user_ticket_intervention_activity_product_search_code")
  2886.      * @Security("is_granted('edit', 'ticket')")
  2887.      */
  2888.     public function userTicketInterventionActivityProductSearchCode(Request $request)
  2889.     {
  2890.         $em $this->mr->getManager('slave');
  2891.         $session $request->getSession();
  2892.         $ticket $em->getRepository('App\Entity\Slave\Ticket')->findOneById($request->request->get('ticketId'));
  2893.         $intervention $em->getRepository('App\Entity\Slave\Intervention')->findOneById($request->request->get('interventionId'));
  2894.         $interventionActivityType $em->getRepository('App\Entity\Slave\InterventionActivityType')->findOneById($request->request->get('activityTypeId'));
  2895.         $product null;
  2896.         // Controllo se esiste il prodotto
  2897.         switch($request->request->get('type')){
  2898.             case 'producer_withdraw':
  2899.             case 'producer_installation':
  2900.             case 'producer_actual':
  2901.                 $product $em->getRepository('App\Entity\Slave\Product')->findOneBy(array('codeProducer' => $request->request->get('code')));
  2902.                 break;
  2903.             case 'supplier_withdraw':
  2904.             case 'supplier_installation':
  2905.             case 'supplier_actual':
  2906.                 $product $em->getRepository('App\Entity\Slave\Product')->findOneBy(array('codeSupplier' => $request->request->get('code')));
  2907.                 break;
  2908.             default: break;
  2909.         }
  2910.         $found false;
  2911.         $json '{';
  2912.         if($product != null){
  2913.             $found true;
  2914.             $posAccessoryOk false;
  2915.             $supplierOk false;    
  2916.             $canMove true;
  2917.             if($product->getModel()->isPos() == $interventionActivityType->isPos())
  2918.                 $posAccessoryOk true;
  2919.             // Controllo se il fornitore del ticket è tra quelli del prodotto
  2920.             foreach($product->getSuppliers() as $supplier){
  2921.                 if($ticket->getSupplier()->getId() == $supplier->getId()){
  2922.                     $supplierOk true;
  2923.                     break;
  2924.                 }
  2925.             }
  2926.             // Controllo se posso spostare il prodotto
  2927.             switch($request->request->get('type')){
  2928.                 case 'producer_withdraw':
  2929.                 case 'supplier_withdraw':
  2930.                 case 'producer_actual':
  2931.                 case 'supplier_actual':
  2932.                     $warehouse $ticket->getClient()->getWarehouse();
  2933.                     break;
  2934.                 case 'producer_installation':
  2935.                 case 'supplier_installation':
  2936.                     $warehouse $intervention->getWarehouse();
  2937.                     if($product->getStatus()->getSlug() != 'available')
  2938.                         $canMove false;
  2939.                     break;
  2940.                 default: break;
  2941.             }
  2942.             $json.= '"id":"'.$product->getId().'", "model":'.json_encode($product->getModel()->getName()).', "codeProducer":"'.$product->getCodeProducer().'", "codeSupplier":"'.$product->getCodeSupplier().'", "supplierOk":"'.$supplierOk.'", "posAccessoryOk":"'.$posAccessoryOk.'",';
  2943.         
  2944.             if($product->getActualWarehouse()->getId() == $warehouse->getId())
  2945.                 $json.= '"otherWarehouse":"0", "type":"", "warehouse":"", "otherWarehouseId":"", "otherWarehouseNickname":"", "canMove":"'.$canMove.'"';
  2946.             else
  2947.                 $json.= '"otherWarehouse":"1","type":"'.$request->request->get('type').'","warehouse":"'.$warehouse->getId().'", "otherWarehouseId":"'.$product->getActualWarehouse()->getId().'", "otherWarehouseNickname":"'.$product->getActualWarehouse()->getNickname().'", "canMove":"'.$canMove.'"';
  2948.             
  2949.         }
  2950.         $json.= '}';
  2951.         return new Response(json_encode(array("code" => 200"success" => true"found" => $found"product" => $json)));
  2952.     }
  2953.     /**
  2954.      * @Route("/scheda/intervento/attivita-prodotto-cerca", name="user_ticket_intervention_activity_product_search")
  2955.      * @Security("is_granted('edit', 'ticket')")
  2956.      */
  2957.     public function userTicketInterventionActivityProductSearch(Request $request)
  2958.     {    
  2959.         $em $this->mr->getManager('slave');
  2960.         $session $request->getSession();
  2961.         $activityType $em->getRepository("App\Entity\Slave\InterventionActivityType")->findOneById($request->request->get('activityTypeId'));
  2962.         $ticket $em->getRepository("App\Entity\Slave\Ticket")->findOneById($request->request->get('ticketId'));
  2963.         $intervention $em->getRepository("App\Entity\Slave\Intervention")->findOneById($request->request->get('interventionId'));
  2964.         $type $request->request->get('type');
  2965.         $filter $request->request->get('filter');
  2966.         $isPos $request->request->get('isPos');
  2967.         $products = array();
  2968.         if($type == 'installation')
  2969.             $products $em->getRepository('App\Entity\Slave\Product')->findByWarehouseSupplierAndIsPosWithFilter($intervention->getWarehouse()->getId(), $ticket->getSupplier()->getId(), $isPos$filter);
  2970.         
  2971.         if($type == 'actual' || $type == 'withdraw')
  2972.             $products $em->getRepository('App\Entity\Slave\Product')->findByWarehouseSupplierAndIsPosWithFilter($ticket->getClient()->getWarehouse()->getId(), $ticket->getSupplier()->getId(), $isPos$filter);
  2973.         $first true;
  2974.         $json "[";
  2975.         foreach($products as $p){
  2976.             if($first$first false; else $json.= ',';
  2977.             $codeProducer '"---"'; if($p->getCodeProducer() != null && $p->getCodeProducer() != ''$codeProducer json_encode($p->getCodeProducer());
  2978.             $codeSupplier '"---"'; if($p->getCodeSupplier() != null && $p->getCodeSupplier() != ''$codeSupplier json_encode($p->getCodeSupplier());
  2979.             $json.= '{"id":'.$p->getId().', "modelName":'.json_encode($p->getModel()->getName()).', "codeProducer":'.$codeProducer.', "codeSupplier":'.$codeSupplier.'}';
  2980.         }
  2981.         $json.= "]";
  2982.         
  2983.         return new Response(json_encode(array("code" => 200"success" => true"products" => $json)));
  2984.     }
  2985.     
  2986.     /**
  2987.      * @Route("/scheda/intervento/attivita-modello-cerca", name="user_ticket_intervention_activity_model_search")
  2988.      * @Security("is_granted('edit', 'ticket')")
  2989.      */
  2990.     public function userTicketInterventionActivityModelSearch(Request $request)
  2991.     {    
  2992.         $em $this->mr->getManager('slave');
  2993.         $session $request->getSession();
  2994.         $activityType $em->getRepository("App\Entity\Slave\InterventionActivityType")->findOneById($request->request->get('activityTypeId'));
  2995.         $isPos $request->request->get('isPos');
  2996.         $filter $request->request->get('filter');
  2997.         $interventionId $request->request->get('interventionId');
  2998.         $intervention $em->getRepository("App\Entity\Slave\Intervention")->findOneById($interventionId);
  2999.         
  3000.         $supplier $intervention->getTicket()->getSupplier();
  3001.         $models $em->getRepository('App\Entity\Slave\ProductModel')->findAllowedPosModel($isPos$filter$supplier);
  3002.                 
  3003.         $first true;
  3004.         $json "[";
  3005.         foreach($models as $m){
  3006.             if($first$first false; else $json.= ',';
  3007.             $json.= '{"id":'.$m->getId().', "name":'.json_encode($m->getName()).', "subcategory":'.json_encode($m->getSubcategory()->getName()).', "category":'.json_encode($m->getSubcategory()->getCategory()->getName()).', "producer":'.json_encode($m->getProducer()->getName()).'}';
  3008.         }
  3009.         $json.= "]";
  3010.       
  3011.         return new Response(json_encode(array("code" => 200"success" => true"models" => $json)));
  3012.     }
  3013.     /**
  3014.      * @Route("/scheda/intervento/attivita-modello-componenti", name="user_ticket_intervention_activity_model_components")
  3015.      * @Security("is_granted('edit', 'ticket')")
  3016.      */
  3017.     public function userTicketInterventionActivityModelComponents(Request $request)
  3018.     {    
  3019.         $em $this->mr->getManager('slave');
  3020.         $session $request->getSession();
  3021.         $activityType $em->getRepository("App\Entity\Slave\InterventionActivityType")->findOneById($request->request->get('activityTypeId'));
  3022.         $model $em->getRepository('App\Entity\Slave\ProductModel')->findOneById($request->request->get('modelId'));
  3023.                 
  3024.         $first true;
  3025.         $json "[";
  3026.         if($model != null){
  3027.             foreach($model->getComponents() as $c){
  3028.                 if($first$first false; else $json.= ',';
  3029.                 $json.= '{"id":"'.$c->getId().'", "name":"'.$c->getName().'"}';
  3030.             }
  3031.         }
  3032.         $json.= "]";
  3033.       
  3034.         return new Response(json_encode(array("code" => 200"success" => true"components" => $json)));
  3035.     }
  3036.     /**
  3037.      * @Route("/{interventionId}/scheda/intervento/attivita-sposta-prodotto", name="user_ticket_intervention_activity_move_product")
  3038.      * @Security("is_granted('edit', 'ticket')")
  3039.      */
  3040.     public function userTicketInterventionActivityMoveProduct(Request $request$interventionId)
  3041.     {
  3042.         $em $this->mr->getManager('slave');
  3043.         $session $request->getSession();
  3044.         $type $request->request->get('type');
  3045.         $product $em->getRepository('App\Entity\Slave\Product')->findOneById($request->request->get('productId'));
  3046.         $oldStatus $product->getStatus();
  3047.         $intervention $em->getRepository('App\Entity\Slave\Intervention')->findOneById($interventionId);
  3048.         if($type == "installation"){
  3049.             $statusNew $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'available'));
  3050.             $warehouse $intervention->getWarehouse();
  3051.             $product->setTermid(null);
  3052.             $product->setStatus($statusNew);
  3053.         }
  3054.         else{
  3055.             $statusNew $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'in_use'));
  3056.             $warehouse $intervention->getTicket()->getClient()->getWarehouse();
  3057.             $product->setTermid($intervention->getTicket()->getTermid());
  3058.             $product->setStatus($statusNew);
  3059.         }
  3060.         
  3061.         if($oldStatus->getId() != $statusNew->getId())
  3062.             ProductService::createProductLog($em$product$this->getUser(), 'status'$oldStatus->getValue(), null$statusNew->getId());
  3063.         ProductService::createProductTransferLog($em$productnull$this->getUser(), $warehouse, new \Datetime(), 'forced');
  3064.         $product->setActualWarehouse($warehouse);
  3065.         $product->setDateLastTransfer(new \Datetime());
  3066.         $product->isToManage(false);
  3067.         $product->setToManagePriority(0);
  3068.         $em->flush();
  3069.         return new Response(json_encode(array("code" => 200"success" => true)));
  3070.     }
  3071.     
  3072.     /**
  3073.      * @Route("/{interventionId}/scheda/intervento/dettagli", name="user_ticket_intervention")
  3074.      * @Security("is_granted('edit', 'ticket')")
  3075.      */
  3076.     public function userTicketIntervention($interventionIdRequest $requestValidatorInterface $validatorFormFactoryInterface $formFactoryFileSystem $fsMailerInterface $mailer)
  3077.     {    
  3078.         $em $this->mr->getManager('slave');
  3079.         $emMaster $this->mr->getManager('master');
  3080.         $session $request->getSession();
  3081.         $company $emMaster->getRepository('App\Entity\Master\Company')->findOneById($session->get('companyId'));
  3082.         $intervention $em->getRepository("App\Entity\Slave\Intervention")->findOneById($interventionId);
  3083.         $ticket $intervention->getTicket();
  3084.         $settingCompletedDefault $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'outcome_completed_default'));
  3085.         $outcomeCompletedDefault $em->getRepository('App\Entity\Slave\InterventionOutcome')->findOneById($settingCompletedDefault->getValue());
  3086.         $form $formFactory->createNamed("form_intervention"InterventionType::class, $intervention, array('typeSlug' => $intervention->getOutcomeType()->getSlug()));
  3087.         $form->handleRequest($request);
  3088.         if($form->isSubmitted()){
  3089.             [$valid$interventionOutcome] = FormValidatorService::validateIntervention($em$validator$form$intervention->getOutcomeType()->getSlug());
  3090.             if($valid && $form->isValid()){
  3091.                 $intervention->setTechnician($ticket->getTechnician());
  3092.                 $intervention->setOperator($this->getUser());
  3093.                 if($intervention->getOutcomeType()->getSlug() == "completed")
  3094.                     $datetime date_create_from_format("d-m-Y H:i"$form->get('date')->getData()->format('d-m-Y').' '.$form->get('timeHour')->getData().':'.$form->get('timeMinute')->getData());
  3095.                 else
  3096.                     $datetime = new \Datetime();
  3097.                 
  3098.                 $intervention->setDatetime($datetime);
  3099.                 $intervention->setMotivation($form->get("motivation")->getData());
  3100.                 $em->persist($intervention);
  3101.                 switch($intervention->getOutcomeType()->getSlug()){
  3102.                     case 'suspended':
  3103.                     case 'empty':
  3104.                         // Inserisco la sospensione del ticket
  3105.                         $suspension = new TicketSuspension();
  3106.                         $suspension->setTicket($ticket);
  3107.                         $suspension->setIntervention($intervention);
  3108.                         $suspension->setDatetimeFrom(date_create_from_format("d-m-Y H:i"$form->get('dateFrom')->getData()->format('d-m-Y').' '.$form->get('timeFromHour')->getData().':'.$form->get('timeFromMinute')->getData()));
  3109.                         if($form->get('dateTo')->getData() != null && $form->get('timeToHour')->getData() != null && $form->get('timeToMinute')->getData() != null){
  3110.                             $suspension->setDatetimeTo(date_create_from_format("d-m-Y H:i"$form->get('dateTo')->getData()->format('d-m-Y').' '.$form->get('timeToHour')->getData().':'.$form->get('timeToMinute')->getData()));
  3111.                         }
  3112.                         $em->persist($suspension);
  3113.                         // Aggiorno dati intervento
  3114.                         if($interventionOutcome->isReferentRequired()) $intervention->setReferent($form->get("referent")->getData());
  3115.                         if($interventionOutcome->isPhoneRequired()) $intervention->setPhone($form->get("phone")->getData());
  3116.                         if($interventionOutcome->isPhotoRequired()) {
  3117.                             $uploadDir $this->params->get('kernel.project_dir').'/'.$this->params->get('web_path').'/companies/'.$company->getDirectoryPath().'/tickets/'.$ticket->getDirectoryPath().'/';
  3118.                             MediaService::uploadImage($fs$form->get('file')->getData(), null$uploadDir$intervention'photo'1001000200true);
  3119.                         }
  3120.                         // SE empty -> Aggiungo costo UAV
  3121.                         if($intervention->getOutcomeType()->getSlug() == 'empty'){
  3122.                             $amountTechnician null;
  3123.                             // Cerco tra gli UAV di quella provincia e di quell'utente
  3124.                             if($ticket->getUAVOperationTariffAmount() != null){
  3125.                                 foreach($ticket->getUAVOperationTariffAmount()->getTechnicianAreas() as $jttaota){
  3126.                                     if($jttaota->getTechnicianArea()->getUser()->getId() == $ticket->getTechnician()->getId())
  3127.                                         $amountTechnician $jttaota->getAmount();
  3128.                                 }
  3129.                             }
  3130.                             // SE non ho risultati -> Fuori zona metto 0.00
  3131.                             if($amountTechnician == null){
  3132.                                 $amountTechnician '0.00';
  3133.                             }
  3134.                             $intervention->setAmount($ticket->getUAVOperationTariffAmount()->getAmount());
  3135.                             $intervention->setAmountTechnician($amountTechnician);
  3136.                         }
  3137.                         // Se account agenzia che gestisce -> approvo automaticamente sospensione --- Altrimenti metto in richiesta sospensione
  3138.                         if($this->getUser()->getAccountTypology() == 'agency' || $this->getUser()->getAccountTypology() == 'warehouse'){
  3139.                             $suspension->setApproved(true);
  3140.                             $suspension->setManaged(true);
  3141.                     
  3142.                             $settingUnlockSameTech $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'ticket_suspension_unlock_same_technician'));
  3143.                             if($settingUnlockSameTech->getValue() != 1)
  3144.                                 $ticket->setTechnician(null);
  3145.                             $ticketStatus $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'suspended'));
  3146.                         }
  3147.                         else{
  3148.                             $ticketStatus $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'suspension_request'));
  3149.                             if($intervention->getOutcomeType()->getSlug() == "suspended"){
  3150.                                 $settingAgencyEmail $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'ticket_suspension_agency_email'));
  3151.                                 $subject $this->params->get('subject_ticket_suspension_request');
  3152.                                 $template "email/ticket_suspension_request.html.twig";
  3153.                             }
  3154.                             else{
  3155.                                 $settingAgencyEmail $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'ticket_uav_agency_email'));
  3156.                                 $subject $this->params->get('subject_ticket_uav_request');
  3157.                                 $template "email/ticket_uav_request.html.twig";
  3158.                             }
  3159.                             if($settingAgencyEmail->getValue() != null){
  3160.                                 $emails preg_split('/\,/'$settingAgencyEmail->getValue());
  3161.                                 foreach($emails as $email){
  3162.                                     $message = (new TemplatedEmail())
  3163.                                         ->subject($subject.' '.$ticket->getNumber())
  3164.                                         ->from($this->params->get('email_noreply'))
  3165.                                         ->to(rtrim(ltrim($email" ")," "))
  3166.                                         ->htmlTemplate($template)
  3167.                                         ->context(['company' => $company'ticket' => $ticket'suspension' => $suspension]);
  3168.                                     $mailer->send($message);
  3169.                                 }
  3170.                             }
  3171.                         }
  3172.                         // Aggiorno stato ticket
  3173.                         $ticket->setStatus($ticketStatus);
  3174.                         break;
  3175.                     case 'completed'
  3176.                         // Chiudo il ticket
  3177.                         $statusClosed $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'closed'));
  3178.                         $ticket->setStatus($statusClosed);
  3179.                         $ticket->setDatetimeEnd($intervention->getDatetime());
  3180.                         // Cerco la jt del tecnico-operazione nell'area e setto l'amount
  3181.                         $amountTechnician null;
  3182.                         foreach($ticket->getOperationTariffAmount()->getTechnicianAreas() as $jttaota){
  3183.                             if($jttaota->getTechnicianArea()->getUser()->getId() == $ticket->getTechnician()->getId()){
  3184.                                 $amountTechnician $jttaota->getAmount();
  3185.                                 break;
  3186.                             }
  3187.                         }
  3188.                         // Se non la trovo -> Fuori zona metto 0.00
  3189.                         if($amountTechnician == null){
  3190.                             $amountTechnician '0.00';
  3191.                         }
  3192.                         $intervention->setAmount($ticket->getOperationTariffAmount()->getAmount());
  3193.                         $intervention->setAmountTechnician($amountTechnician);
  3194.                 
  3195.                         $this->addFlash('notice_success''Ticket completato!');
  3196.                         break;
  3197.                     default: break;
  3198.                 }
  3199.                 $em->flush();
  3200.                 $session->set('interventionId'$intervention->getId());
  3201.                 return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  3202.             }
  3203.         }
  3204.         return $this->render('role/user/ticket/intervention/intervention.html.twig', array(
  3205.             'ticket' => $ticket,
  3206.             'intervention' => $intervention,
  3207.             'outcomeCompletedDefault' => $outcomeCompletedDefault,
  3208.             'form' => $form->createView()
  3209.         ));
  3210.     }
  3211.     /**
  3212.      * @Route("/scheda/intervento/esito-aggiorna", name="user_ticket_intervention_outcome_update")
  3213.      * @Security("is_granted('edit', 'ticket')")
  3214.      */
  3215.     public function userTicketInterventionOutcomeUpdate(Request $request)
  3216.     {    
  3217.         $em $this->mr->getManager('slave');
  3218.         $interventionOutcome $em->getRepository('App\Entity\Slave\InterventionOutcome')->findOneById($request->request->get("outcomeId"));
  3219.         return new Response(json_encode(array(
  3220.             "code" => 200,
  3221.             "success" => true,
  3222.             "suspensionTo" => $interventionOutcome->isSuspensionToRequired(),
  3223.             "referent" => $interventionOutcome->isReferentRequired(),
  3224.             "motivation" => $interventionOutcome->isMotivationRequired(),
  3225.             "phone" => $interventionOutcome->isPhoneRequired(),
  3226.             "photo" => $interventionOutcome->isPhotoRequired()
  3227.         ))); 
  3228.     }
  3229.     /**
  3230.      * @Route("/sistema-duplicati", name="user_ticket_duplicate_to_wrong")
  3231.      */        
  3232.     public function userTicketDuplicateToWrong(Request $request)
  3233.     {    
  3234.         $em $this->mr->getManager('slave');
  3235.         $wrongStatus $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBySlug("wrong");
  3236.         $tickets $em->getRepository('App\Entity\Slave\Ticket')->findAll();
  3237.         $ticketId null;
  3238.         $skipId = array();
  3239.         $wrongTicketArray = array();
  3240.         foreach($tickets as $ticket){
  3241.             $ticketId $ticket->getId();
  3242.             if(!in_array($ticketId$skipId)){
  3243.                 foreach($tickets as $innerTicket){
  3244.                     if($ticketId != $innerTicket->getId() && $ticket->getNumber() == $innerTicket->getNumber() && $ticket->getTermid()->getCode() == $innerTicket->getTermid()->getCode() && $innerTicket->getStatus()->getId() < 4){
  3245.                         array_push($skipId$innerTicket->getId());
  3246.                         array_push($wrongTicketArray$ticket);
  3247.                     }
  3248.                 }
  3249.             }
  3250.         }
  3251.         foreach($wrongTicketArray as $wt){
  3252.             $wt->setStatus($wrongStatus);
  3253.         }
  3254.         $em->flush();
  3255.         return $this->redirectToRoute("user_ticket_list");
  3256.     }
  3257.     /**
  3258.      * @Route("/sposta-temp", name="user_ticket_move_to_temp")
  3259.      */
  3260.     public function userTicketmoveToTemp(Request $request)
  3261.     {    
  3262.         $em $this->mr->getManager('slave');
  3263.         $tempStatus $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBySlug("temp");
  3264.         $ticketArray = [];
  3265.         foreach($ticketArray as $array){
  3266.             $ts $em->getRepository('App\Entity\Slave\Ticket')->findAllByNumber($array[0]);
  3267.             foreach($ts as $t){
  3268.                 if($t->getTermid()->getCode() == $array[1] && $t->getStatus()->getId() < 4)
  3269.                     $t->setStatus($tempStatus);
  3270.             }
  3271.         }
  3272.         $em->flush();
  3273.         return $this->redirectToRoute("user_ticket_list");
  3274.     }
  3275. }