src/Controller/User/UserTicketController.php line 1304

Open in your IDE?
  1. <?php
  3. namespace App\Controller\User;
  5. use App\Entity\Master\CityAlias;
  6. use App\Entity\Slave\Client;
  7. use App\Entity\Slave\ClientPhone;
  8. use App\Entity\Slave\Product;
  9. use App\Entity\Slave\Intervention;
  10. use App\Entity\Slave\InterventionActivity;
  11. use App\Entity\Slave\InterventionExtra;
  12. use App\Entity\Slave\Termid;
  13. use App\Entity\Slave\Ticket;
  14. use App\Entity\Slave\TicketReminder;
  15. use App\Entity\Slave\TicketSuspension;
  16. use App\Entity\Slave\Warehouse;
  17. use App\Form\Base\DocumentType;
  18. use App\Form\Master\CityAliasType;
  19. use App\Form\Model\AssignTechnician;
  20. use App\Form\Model\Document;
  21. use App\Form\Model\ImportTicketsSuspend;
  22. use App\Form\Model\ImportTicketsSusUnlock;
  23. use App\Form\Model\ImportTicketCancels;
  24. use App\Form\Model\ImportTicketClosures;
  25. use App\Form\Model\ImportTicketIntervention;
  26. use App\Form\Model\ImportTicketNew;
  27. use App\Form\Slave\AssignTechnicianType;
  28. use App\Form\Slave\ClientEditType;
  29. use App\Form\Slave\InterventionType;
  30. use App\Form\Slave\InterventionActivityType;
  31. use App\Form\Slave\InterventionSlaType;
  32. use App\Form\Slave\InterventionExtraType;
  33. use App\Form\Slave\OperationKeysMappingType;
  34. use App\Form\Slave\TicketType;
  35. use App\Form\Slave\TicketAddressType;
  36. use App\Form\Slave\TicketErrorProvinceType;
  37. use App\Form\Slave\TicketErrorAddressType;
  38. use App\Form\Slave\TicketErrorSupplierType;
  39. use App\Form\Slave\TicketErrorOperationType;
  40. use App\Form\Slave\TicketDeleteType;
  41. use App\Form\Slave\TicketOperationType;
  42. use App\Form\Slave\TicketOperationTariffAmountType;
  43. use App\Form\Slave\TicketExpirationEditType;
  44. use App\Form\Slave\TicketWaybillEditType;
  45. use App\Form\Slave\TicketNotesEditType;
  46. use App\Form\Slave\TicketReminderType;
  47. use App\Form\Slave\TicketSuspensionEditType;
  48. use App\Form\Slave\TicketSuspensionApproveType;
  49. use App\Form\Slave\TicketSuspensionUnlockType;
  50. use App\Form\Slave\ImportTicketCancelsType;
  51. use App\Form\Slave\ImportTicketClosuresType;
  52. use App\Form\Slave\ImportTicketsSuspendType;
  53. use App\Form\Slave\ImportTicketsSusUnlockType;
  54. use App\Form\Slave\ImportTicketInterventionType;
  55. use App\Form\Slave\ImportTicketNewType;
  56. use App\Service\EncryptionService;
  57. use App\Service\FilterService;
  58. use App\Service\FormValidatorService;
  59. use App\Service\ImportService;
  60. use App\Service\MediaService;
  61. use App\Service\ProductService;
  62. use App\Service\TicketService;
  63. use App\Service\UtilitiesService;
  64. use App\Service\ValidationService;
  65. use Doctrine\Persistence\ManagerRegistry;
  66. use Knp\Snappy\Pdf;
  67. use Knp\Component\Pager\PaginatorInterface;
  68. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Security;
  69. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  70. use Symfony\Bridge\Twig\Mime\TemplatedEmail;
  71. use Symfony\Component\DependencyInjection\ParameterBag\ParameterBagInterface;
  72. use Symfony\Component\Filesystem\Filesystem;
  73. use Symfony\Component\Form\FormError;
  74. use Symfony\Component\Form\FormFactoryInterface;
  75. use Symfony\Component\HttpFoundation\Request;
  76. use Symfony\Component\HttpFoundation\Response;
  77. use Symfony\Component\HttpFoundation\ResponseHeaderBag;
  78. use Symfony\Component\HttpFoundation\StreamedResponse;
  79. use Symfony\Component\Mailer\MailerInterface;
  80. use Symfony\Component\PasswordHasher\Hasher\UserPasswordHasherInterface;
  81. use Symfony\Component\Routing\Annotation\Route;
  82. use Symfony\Component\Validator\Validator\ValidatorInterface;
  84. /**
  85.  * @Route("/scrivania/ticket")
  86.  * @Security("is_granted('ROLE_USER') and is_granted('active', user) && is_granted('view', 'ticket')")
  87.  */
  88. class UserTicketController extends AbstractController
  89. {
  90.     private $mr;
  91.     private $params;
  93.     public function __construct(ManagerRegistry $mr, ParameterBagInterface $params){
  94.         $this->mr = $mr;
  95.         $this->params = $params;
  96.     }
  98.     public function activityProductByType($em, $form, $type, $suppliers){
  99.         if($form->get('product'.$type.'Id')->getData() != null){
  100.             $product = $em->getRepository('App\Entity\Slave\Product')->findOneById($form->get('product'.$type.'Id')->getData());
  101.         }
  102.         else{
  103.             $model = $em->getRepository('App\Entity\Slave\ProductModel')->findOneById($form->get('model'.$type.'Id')->getData());
  104.             switch($type){
  105.                 case 'Withdraw': 
  106.                     $status = $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'not_available'));
  107.                     $condition = $em->getRepository('App\Entity\Slave\ProductCondition')->findOneBy(array('slug' => 'broken'));
  108.                     break;
  109.                 case 'Actual':
  110.                     $status = $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'in_use'));
  111.                     $condition = $em->getRepository('App\Entity\Slave\ProductCondition')->findOneBy(array('slug' => 'free'));
  112.                     break;
  113.                 default: break;
  114.             }
  115.             $product = ProductService::createProduct($em, $model, $form->get('producer'.$type)->getData(), $form->get('supplier'.$type)->getData(), $suppliers, $status, $condition);
  116.         }
  117.         return $product;
  118.     }
  120.     public function importCheckFile($em, $validator, $form){
  121.         $row = 0;
  122.         $valid = true;
  123.         if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('separator'));
  124.         if($valid) $valid = ValidationService::validateCsvDelimiter($form->get('file')->getData()->getPathName(), $form->get('separator')->getData(), $form->get('separator'));
  125.         if($valid) $valid = ValidationService::validateFile($validator, $form->get('path'), true, $form->get('file')->getData(), '10', array('csv', 'txt'));
  126.         if($valid && ($handle = fopen($form->get('file')->getData(), "r")) !== FALSE) {
  127.             while(($data = fgetcsv($handle, 2000, $form->get('separator')->getData())) !== FALSE) {
  128.                 $data = array_map("utf8_encode", $data);
  129.                 if($row > 0){
  130.                     $ticket = $em->getRepository('App\Entity\Slave\Ticket')->findOneByNumberAndTermid($data[0], $data[1]);
  131.                     if($ticket == null){
  132.                         $valid = false;
  133.                         $form->get("path")->addError(new FormError("Ticket non trovato"));
  134.                         $this->addFlash('notice_danger', 'Il ticket presente alla riga '.$row.' con n° '.$data[0].' e termid '.$data[1].' non è stato trovato! Ricontrolla il file!');
  135.                         break;
  136.                     }
  137.                 }
  138.                 $row++;
  139.             }
  140.             fclose($handle);
  141.         }
  142.         return $valid;
  143.     }
  145.     public function importInterventionCreate($em, $ticket, $warehouse, $datetime){
  146.         $intervention = new Intervention();
  147.         $intervention->setTicket($ticket);
  148.         $intervention->setTechnician($ticket->getTechnician());
  149.         $intervention->setOperator($this->getUser());
  150.         $intervention->setOutcomeType($em->getRepository('App\Entity\Slave\InterventionOutcomeType')->findOneBy(array('slug' => 'completed')));
  151.         $intervention->setOutcome($em->getRepository('App\Entity\Slave\InterventionOutcome')->findOneBy(array('slug' => 'completato-correttamente')));
  152.         $intervention->setWarehouse($warehouse);
  153.         $intervention->setDatetime($datetime);
  154.         $intervention->setDatetimeBilling(date_create_from_format('d-m-Y H:i:s', '01-'.$datetime->format('m').'-'.$datetime->format('Y').' 00:00:00'));
  155.         if($ticket->getOperationTariffAmount() != null)
  156.             $intervention->setAmount($ticket->getOperationTariffAmount()->getAmount());
  157.         $intervention->setAmountTechnician('0.00');
  158.         $intervention->setBillable(true);
  159.         $em->persist($intervention);
  160.         return $intervention;
  161.     }
  163.     public function importInterventionSearchProduct($em, $code, $supplier){
  164.         $product = $em->getRepository('App\Entity\Slave\Product')->findOneBy(array('codeProducer' => $code));
  165.         if($product == null)
  166.             $product = $em->getRepository('App\Entity\Slave\Product')->findOneBy(array('codeSupplier' => $code));
  167.         return $product;
  168.     }
  170.     public function importInterventionActivity($em, $ticket, $intervention, $activityType, $isDisi, $prodOld, $prodNew, $warehouse, $datetime){
  171.         $activity = new InterventionActivity();
  172.         $activity->setIntervention($intervention);
  173.         $activity->setType($activityType);
  174.         $skip = false;
  175.         if($prodOld != null && $prodNew != null && ($prodNew->getCodeProducer() == $prodOld->getCodeProducer() || $prodNew->getCodeProducer() == '0'.$prodOld->getCodeProducer()))
  176.             $skip = true;
  177.         if($prodOld != null){
  178.             $activity->setProductWithdraw($prodOld);
  179.             $activity->setProducerWithdraw($prodOld->getCodeProducer());
  180.             $activity->setSupplierWithdraw($prodOld->getCodeSupplier());
  181.             $newWarehouse = $warehouse;
  182.             if($prodOld->movedByDS())
  183.                 $newWarehouse = $prodOld->getActualWarehouse();
  184.             else{
  185.                 $prodOld->setStatus($em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'not_available')));
  186.                 $prodOld->setCondition($em->getRepository('App\Entity\Slave\ProductCondition')->findOneBy(array('slug' => 'broken')));
  187.             }
  188.             $prodOld->setActualWarehouse($ticket->getClient()->getWarehouse());
  189.             ProductService::createProductTransferLog($em, $prodOld, null, $this->getUser(), $warehouse, $datetime, 'forced');
  190.             $prodOld->setActualWarehouse($newWarehouse);
  191.         }
  192.         if($prodNew != null && !$skip){
  193.             if($isDisi){
  194.                 $activity->setProductWithdraw($prodNew);
  195.                 $activity->setProducerWithdraw($prodNew->getCodeProducer());
  196.                 $activity->setSupplierWithdraw($prodNew->getCodeSupplier());
  197.                 $newWarehouse = $warehouse;
  198.                 if($prodNew->movedByDS())
  199.                     $newWarehouse = $prodNew->getActualWarehouse();
  200.                 else{
  201.                     $prodNew->setStatus($em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'not_available')));
  202.                     $prodNew->setCondition($em->getRepository('App\Entity\Slave\ProductCondition')->findOneBy(array('slug' => 'broken')));
  203.                 }
  204.                 $prodNew->setActualWarehouse($ticket->getClient()->getWarehouse());
  205.                 ProductService::createProductTransferLog($em, $prodNew, null, $this->getUser(), $warehouse, $datetime, 'forced');
  206.                 $prodNew->setActualWarehouse($newWarehouse);
  207.             }
  208.             else{
  209.                 $activity->setProductInstallation($prodNew);
  210.                 $activity->setProducerInstallation($prodNew->getCodeProducer());
  211.                 $activity->setSupplierInstallation($prodNew->getCodeSupplier());
  212.                 $newWarehouse = $ticket->getClient()->getWarehouse();
  213.                 if($prodNew->movedByDS())
  214.                     $newWarehouse = $prodNew->getActualWarehouse();
  215.                 else{
  216.                     $prodNew->setTermid($ticket->getTermid());
  217.                     $prodNew->setStatus($em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'in_use')));
  218.                     $prodNew->setCondition($em->getRepository('App\Entity\Slave\ProductCondition')->findOneBy(array('slug' => 'free')));
  219.                 }
  220.                 $prodNew->setActualWarehouse($warehouse);
  221.                 ProductService::createProductTransferLog($em, $prodNew, null, $this->getUser(), $ticket->getClient()->getWarehouse(), $datetime, 'forced');
  222.                 $prodNew->setActualWarehouse($newWarehouse);
  223.             }
  224.         }
  225.         $em->persist($activity);
  226.     }
  228.     public function deleteTicketAndConnectedValues($em, $ticket){
  229.         $termid = $ticket->getTermid();
  230.         $client = $ticket->getClient();
  231.         if($termid != null){
  232.             if(sizeof($termid->getTickets()) == 1){
  233.                 foreach($termid->getProducts() as $pr)
  234.                     $pr->setTermid(null);
  235.                 $em->remove($termid);
  236.             }
  237.         }
  238.         if($ticket->getClient() != null){
  239.             if(sizeof($client->getTermids()) == 1 && sizeof($client->getTickets()) == 1 && sizeof($client->getFiles()) == 0 && $client->getWarehouse()->canDelete()){
  240.                 foreach($client->getPhones() as $phone)
  241.                     $em->remove($phone);
  242.                 $em->remove($client->getWarehouse());
  243.                 $em->remove($client);
  244.             }
  245.         }
  246.         foreach($ticket->getLogs() as $log){
  247.             $em->remove($log);
  248.         }
  249.         $em->remove($ticket);
  250.     }
  252.     public function deleteProductAlreadyInserted($em, $product){
  253.         foreach($product->getTransferLogs() as $transferLog)
  254.             $em->remove($transferLog);
  255.         foreach($product->getLogs() as $log)
  256.             $em->remove($log);
  257.         $em->remove($product);
  258.         $em->flush();
  259.     }
  261.     // SCRIVANIA
  262.         /**
  263.          * @Route("/sblocca-materiale-mancante", name="user_ticket_unlock_waiting_material")
  264.          */
  265.         public function userTicketUnlockWaitingMaterial(Request $request)
  266.         {    
  267.             $em = $this->mr->getManager('slave');
  268.             $ticket = $em->getRepository('App\Entity\Slave\Ticket')->findOneById($request->request->get('ticketId'));
  270.             foreach($ticket->getSuspensions() as $s){
  271.                 if(!$s->isUnlocked())
  272.                     $suspension = $s;
  273.             }
  275.             $unlockCausal = "Ticket sbloccato per materiale mancante ricevuto";
  276.             $suspension->unlock($em, $this->getUser(), $unlockCausal, new \DateTime());
  277.             $em->flush();
  279.             $response = array("code" => 200, "success" => true);
  280.             return new Response(json_encode($response)); 
  281.         }
  282.     //
  284.     // SCARICA
  285.         /**
  286.          * @Route("/scarica-da-email", name="user_ticket_download_email")
  287.          * @Security("is_granted('edit', 'ticket')")
  288.          */
  289.         public function userTicketDownloadEmail(Request $request)
  290.         {
  291.             $emMaster = $this->mr->getManager('master');
  292.             $session = $request->getSession();
  293.             $company = $emMaster->getRepository('App\Entity\Master\Company')->findOneById($session->get('companyId'));
  294.             $mailbox = "{in.postassl.it:993/imap/ssl}INBOX";
  295.             $mailboxOther = "{in.postassl.it:993/imap/ssl}INBOX.other";
  296.             $em = $this->mr->getManager('slave');
  298.             foreach($company->getMailers() as $mailer){
  300.                 $count = 0;
  301.                 $countTicket = 0;
  302.                 $countTicketError = 0;
  303.                 $inboxOther = imap_open($mailboxOther, $mailer->getUser(), EncryptionService::decrypt($mailer->getPassword())) or die('Impossibile connettersi alla casella email: '.imap_last_error()); // Connessione alla casella email
  304.                 imap_expunge($inboxOther); // Elimina le mail "marcate"
  305.                 imap_close($inboxOther); // Chiude la connessione
  306.                 
  307.                 $inbox = imap_open($mailbox, $mailer->getUser(), EncryptionService::decrypt($mailer->getPassword())) or die('Impossibile connettersi alla casella email: '.imap_last_error()); // Connessione alla casella email
  308.                 imap_expunge($inbox); // Elimina le mail "marcate"
  309.                 $emails = imap_search($inbox, 'ALL'); // Cerca tutte le email da leggere
  310.                 $testing = $this->params->get('ticket_download_testing');
  311.                 $error = false;
  313.                 if($emails){
  314.                     rsort($emails); // Ordino con la più nuova in cima
  315.                     foreach($emails as $email){
  316.                         if($count < 600){
  317.                             // INOLTRO A THEBURMANUTENZIONE@GMAIL.COM
  318.                             if($company->getCode() == "BBQV25"){
  319.                                 $overview = imap_fetch_overview($inbox, $email, 0);
  320.                                 $isRead = isset($overview[0]->seen) && $overview[0]->seen == 1;
  321.                                 if(!$isRead){
  322.                                     $header = imap_headerinfo($inbox, $email); // Gestisco l'header                            
  323.                                     // Serve per skippare le email che non hanno mittente o di spam
  324.                                     if(property_exists($header, 'from') && property_exists($header->from[0], 'host'))
  325.                                         $sender = $header->from[0]->mailbox."@".$header->from[0]->host;
  326.                                     if($sender == "thebur.manutenzioni@gmail.com"){
  327.                                         $body = imap_fetchbody($inbox, $email, 1);
  328.                                         $subject = $header->subject;
  329.                                         $to = 'thebur.integrations@gmail.com';
  330.         
  331.                                         $headers = "From: $sender\r\n";
  332.                                         $headers .= "Reply-To: $sender\r\n";
  333.                                         $headers .= "X-Mailer: PHP/" . phpversion();
  334.         
  335.                                         mail($to, $subject, $body, $headers);
  336.                                         imap_setflag_full($inbox, $email, "\\SEEN");
  337.                                     }
  338.                                 }
  339.                             }
  340.                             [$countTicket, $countTicketError] = TicketService::downloadTicket($em, $emMaster, $this->getUser(), $inbox, $email, $mailer, $testing, $company,$countTicket, $countTicketError);
  341.                         }
  342.                         else
  343.                             break;
  344.                         $count++;
  345.                     }
  346.                 }
  347.                 if(!$testing){
  348.                     imap_expunge($inbox); // Elimina le mail "marcate"
  349.                     imap_close($inbox); // Chiude la connessione
  350.                 }
  351.                 
  352.                 if($countTicketError > 0)
  353.                     $noticeType = "notice_warning";
  354.                 else
  355.                     $noticeType = "notice_success";
  357.                 $this->addFlash($noticeType, 'Casella '.$mailer->getUser().':<br>E-mail processate: '.$count.'<br>Ticket scaricati: '.$countTicket.'<br>Ticket con errori: '.$countTicketError);
  358.             }
  360.             return $this->redirectToRoute("user_ticket_list");
  361.         }
  362.         
  363.         /**
  364.          * @Route("/scarica-da-email-altro", name="user_ticket_download_email_other")
  365.          * @Security("is_granted('edit', 'ticket')")
  366.          */
  367.         public function userTicketDownloadEmailOther(Request $request)
  368.         {
  369.             $session = $request->getSession();
  370.             $emMaster = $this->mr->getManager('master');
  371.             $company = $emMaster->getRepository('App\Entity\Master\Company')->findOneById($session->get('companyId'));
  372.             $mailbox = "{in.postassl.it:993/imap/ssl}INBOX.other";
  373.             $mailboxIncoming = "{in.postassl.it:993/imap/ssl}INBOX";
  374.             $em = $this->mr->getManager('slave');
  375.             
  376.             foreach($company->getMailers() as $mailer){
  378.                 $count = 0;
  379.                 $countTicket = 0;
  380.                 $countTicketError = 0;
  381.                 $inboxIncoming = imap_open($mailboxIncoming, $mailer->getUser(), EncryptionService::decrypt($mailer->getPassword())) or die('Impossibile connettersi alla casella email: '.imap_last_error()); // Connessione alla casella email
  382.                 imap_expunge($inboxIncoming); // Elimina le mail "marcate"
  383.                 imap_close($inboxIncoming); // Chiude la connessione
  385.                 $inbox = imap_open($mailbox, $mailer->getUser(), EncryptionService::decrypt($mailer->getPassword())) or die('Impossibile connettersi alla casella email: '.imap_last_error()); // Connessione alla casella email
  386.                 imap_expunge($inbox); // Elimina le mail "marcate"
  387.                 $emails = imap_search($inbox, 'UNSEEN'); // Cerca tutte le email da leggere
  388.                 $testing = $this->params->get('ticket_download_testing');;
  389.                 $error = false;
  391.                 if($emails){
  392.                     rsort($emails); // Ordino con la più nuova in cima
  393.                     foreach($emails as $email){
  394.                         if($count < 600){
  395.                             // INOLTRO A THEBURMANUTENZIONE@GMAIL.COM
  396.                             if($company->getCode() == "BBQV25"){
  397.                                 $overview = imap_fetch_overview($inbox, $email, 0);
  398.                                 $isRead = isset($overview[0]->seen) && $overview[0]->seen == 1;
  399.                                 if(!$isRead){
  400.                                     $header = imap_headerinfo($inbox, $email); // Gestisco l'header                            
  401.                                     // Serve per skippare le email che non hanno mittente o di spam
  402.                                     if(property_exists($header, 'from') && property_exists($header->from[0], 'host'))
  403.                                         $sender = $header->from[0]->mailbox."@".$header->from[0]->host;
  404.                                     if($sender == "thebur.manutenzioni@gmail.com"){
  405.                                         $body = imap_fetchbody($inbox, $email, 1);
  406.                                         $subject = $header->subject;
  407.                                         $to = 'thebur.integrations@gmail.com';
  408.         
  409.                                         $headers = "From: $sender\r\n";
  410.                                         $headers .= "Reply-To: $sender\r\n";
  411.                                         $headers .= "X-Mailer: PHP/" . phpversion();
  412.         
  413.                                         mail($to, $subject, $body, $headers);
  414.                                         imap_setflag_full($inbox, $email, "\\SEEN");
  415.                                     }
  416.                                 }
  417.                             }
  418.                             [$countTicket, $countTicketError] = TicketService::downloadTicket($em, $emMaster, $this->getUser(), $inbox, $email, $mailer, $testing, $company,$countTicket, $countTicketError);
  419.                         }
  420.                         else
  421.                             break;
  422.                         $count++;
  423.                     }
  424.                 }
  425.                 if(!$testing){
  426.                     imap_expunge($inbox); // Elimina le mail "marcate"
  427.                     imap_close($inbox); // Chiude la connessione
  428.                 }
  429.                 
  430.                 if($countTicketError > 0)
  431.                     $noticeType = "notice_warning";
  432.                 else
  433.                     $noticeType = "notice_success";
  435.                 $this->addFlash($noticeType, 'Casella '.$mailer->getUser().':<br>E-mail processate: '.$count.'<br>Ticket scaricati: '.$countTicket.'<br>Ticket con errori: '.$countTicketError);
  436.             }
  438.             return $this->redirectToRoute("user_ticket_list");
  439.         }
  440.     //
  442.     // IMPORTA CSV
  443.         /**
  444.          * @Route("/importa", name="user_ticket_import")
  445.          * @Security("is_granted('edit', 'ticket')")
  446.          */
  447.         public function userTicketImport(Request $request, ValidatorInterface $validator, FormFactoryInterface $formFactory, FileSystem $fs, MailerInterface $mailer)
  448.         {    
  449.             $em = $this->mr->getManager('slave');
  450.             $emMaster = $this->mr->getManager('master');
  451.             $session = $request->getSession();
  452.             $company = $emMaster->getRepository('App\Entity\Master\Company')->findOneById($session->get('companyId'));
  453.                         
  454.             $arraySuppliers = [];
  455.             $masterSuppliersIds = [];
  456.             $jtcss = $emMaster->getRepository('App\Entity\Master\JoinTableCompanySupplier')->findByCompanyOrdered($company->getId());
  457.             foreach($jtcss as $jtcs)
  458.                 array_push($masterSuppliersIds, $jtcs->getSupplier()->getId());
  460.             foreach($masterSuppliersIds as $sId){
  461.                 $supplier = $em->getRepository('App\Entity\Slave\Supplier')->findOneBy(['idSupplier' => $sId]);
  462.                 if($supplier != null){
  463.                     switch($supplier->getSlug()){
  464.                         case 'demis-adp': $arraySuppliers['DEMIS ADP'] = 'demis-adp'; break;
  465.                         case 'bcc-pos': $arraySuppliers['BCC Pos'] = 'bcc-pos'; break;
  466.                         case 'fabrick': $arraySuppliers['Fabrick'] = 'fabrick'; break;
  467.                         case 'nexi-book-meps':
  468.                         case 'nexi-book-monetica':
  469.                             $arraySuppliers['Nexi (Book MEPS o Book Monetica)'] = 'nexi';
  470.                             break;
  471.                         case 'lottomatica': $arraySuppliers['Lottomatica'] = 'lottomatica'; break;
  472.                         case 'mts&care-srl': $arraySuppliers['MTS CARE'] = 'mts&care-srl'; break;
  473.                         case 'italcard-srl': $arraySuppliers['italcard-srl'] = 'italcard-srl'; break;
  474.                         case 'nexi-book-sia': $arraySuppliers['NEXI Book SIA'] = 'nexi-book-sia'; break;
  475.                         case 'worldline-italia': $arraySuppliers['Worldline Italia'] = 'worldline-italia'; break;
  476.                         case 'csc---axerve':
  477.                         case 'csc---cglobal':
  478.                         case 'csc---cronos':
  479.                         case 'csc---cse':
  480.                         case 'csc---decathlon':
  481.                         case 'csc---euronet':
  482.                         case 'csc---lis-pay':
  483.                         case 'csc---mooney':
  484.                         case 'csc---nexi-book-meps':
  485.                         case 'csc---nexi-book-monetica':
  486.                         case 'csc---nexi-book-sia':
  487.                         case 'csc---numera':
  488.                         case 'csc---p4cards':
  489.                         case 'csc---q8':
  490.                         case 'csc---repas':
  491.                         case 'csc---stripe':
  492.                         case 'csc---worldline-italia':
  493.                         case 'csc---yamamay':
  494.                         case 'csc---ultroneo':
  495.                             $arraySuppliers['CSC'] = 'csc';
  496.                             $arraySuppliers['CSC Nuovo portale'] = 'csc-new';
  497.                             break;
  498.                         case 'sate---worldline':
  499.                         case 'sate---numera':
  500.                         case 'sate---mooney':
  501.                         case 'sate---flagpay':
  502.                         case 'sate---argentea':
  503.                         case 'sate---pluxee':
  504.                         case 'sate---qomodo':
  505.                             $arraySuppliers['SATE'] = 'sate';
  506.                             break;
  507.                         case 'csc---numia':
  508.                             $arraySuppliers['CSC Numia'] = 'csc---numia';
  509.                             break;
  510.                         default: break;
  511.                     }
  512.                 }
  513.             }
  515.             // NUOVI TICKET
  516.             $operationId = null;
  517.             $importTicketNew = new ImportTicketNew();
  518.             $formTicket = $formFactory->createNamed("form_import_ticket_new", ImportTicketNewType::class, $importTicketNew, array('suppliers' => $arraySuppliers));
  519.             $formTicket->handleRequest($request);
  521.             if($formTicket->isSubmitted()){
  523.                 $valid = true;
  524.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $formTicket->get('supplier'));
  525.                 if($valid && ($formTicket->get('supplier')->getData() == 'nexi-book-sia')){
  526.                     if($formTicket->get('operation')->getData() != null)
  527.                         $operationId = $formTicket->get('operation')->getData();
  528.                     else
  529.                         $operationId = 'all';
  530.                 }
  531.                 if($valid && ($formTicket->get('supplier')->getData() == 'lottomatica' || $formTicket->get('supplier')->getData() == 'mts&care-srl')){
  532.                     $valid = ValidationService::validateNotBlank($validator, $formTicket->get('operation'));
  533.                     if($valid) $valid = ValidationService::validateNotBlank($validator, $formTicket->get('date'));
  534.                     if($valid) $valid = ValidationService::validateNotBlank($validator, $formTicket->get('time'));
  535.                     if($valid) $valid = ValidationService::validateFile($validator, $formTicket->get('path'), true, $formTicket->get('file')->getData(), '10', array('xls', 'xlsx'));
  536.                 }
  537.                 else if($valid && $formTicket->get('supplier')->getData() == 'italcard-srl'){
  538.                     $valid = ValidationService::validateNotBlank($validator, $formTicket->get('operation'));
  539.                     if($valid) $valid = ValidationService::validateNotBlank($validator, $formTicket->get('date'));
  540.                     if($valid) $valid = ValidationService::validateFile($validator, $formTicket->get('path'), true, $formTicket->get('file')->getData(), '10', array('xls', 'xlsx'));
  541.                 }
  542.                 else{
  543.                     if($valid) $valid = ValidationService::validateNotBlank($validator, $formTicket->get('separator'));
  544.                     if($valid) $valid = ValidationService::validateCsvDelimiter($formTicket->get('file')->getData()->getPathName(), $formTicket->get('separator')->getData(), $formTicket->get('separator'));
  545.                     if($valid) $valid = ValidationService::validateFile($validator, $formTicket->get('path'), true, $formTicket->get('file')->getData(), '10', array('csv', 'txt', 'bin'));
  546.                 }
  548.                 if($valid && $formTicket->isValid()){
  549.                     $error = false;
  550.                     $row = 0;
  551.                     $countInserted = 0;
  552.                     switch($formTicket->get('supplier')->getData()){
  553.                         case 'bcc-pos':
  554.                         case 'csc---numia':
  555.                         case 'demis-adp':
  556.                         case 'fabrick':
  557.                         case 'lis-holding':
  558.                         case 'nexi':
  559.                         case 'nexi-book-sia':
  560.                         case 'sate':
  561.                         case 'worldline-italia':
  562.                             [$error, $row, $countInserted] = TicketService::importFile($em, $emMaster, $this->getUser(), $formTicket, $company, $operationId, $row, $mailer);
  563.                             break;
  564.                         case 'csc': // CSC
  565.                             [$error, $row, $countInserted] = TicketService::importFileCSC($em, $emMaster, $this->getUser(), $formTicket, $error, $row, $countInserted, $mailer);
  566.                             break;
  567.                         case 'csc-new': // CSC NEW
  568.                             [$error, $row, $countInserted] = TicketService::importFileCSCNew($em, $emMaster, $this->getUser(), $formTicket, $error, $row, $countInserted, $mailer);
  569.                             break;
  570.                         case 'lottomatica': // LOTTOMATICA
  571.                         case 'mts&care-srl': // MTS&CARE SRL
  572.                             [$error, $row, $countInserted] = TicketService::importFileLottomaticaOrMtsCare($em, $emMaster, $this->getUser(), $formTicket, $error, $row, $countInserted, $mailer);
  573.                             break;
  574.                         case 'italcard-srl': // ITALCARD
  575.                             [$error, $row, $countInserted] = TicketService::importFileItalcard($em, $emMaster, $this->getUser(), $formTicket, $error, $row, $countInserted, $mailer);
  576.                             break;
  577.                         default: break;
  578.                     }
  580.                     if($error)
  581.                         $this->addFlash('notice_warning', 'Un totale di '.$countInserted.' su '.($row - 1).' ticket è stato scaricato dal file, alcuni presentano degli errori!');
  582.                     else
  583.                         $this->addFlash('notice_success', 'Un totale di '.$countInserted.' su '.($row - 1).' ticket è stato scaricato dal file senza errori!');
  584.                     return $this->redirectToRoute('user_ticket_list');
  585.                 }
  586.             }
  588.             // INTERVENTI
  589.             $importTicketIntervention = new ImportTicketIntervention();
  590.             $formIntervention = $formFactory->createNamed("form_import_ticket_intervention", ImportTicketInterventionType::class, $importTicketIntervention);
  591.             $formIntervention->handleRequest($request);
  593.             if($formIntervention->isSubmitted()){
  594.                 
  595.                 $valid = true;
  596.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $formIntervention->get('separator'));
  597.                 if($valid) $valid = ValidationService::validateCsvDelimiter($formIntervention->get('file')->getData()->getPathName(), $formIntervention->get('separator')->getData(), $formIntervention->get('separator'));
  598.                 if($valid) $valid = ValidationService::validateFile($validator, $formIntervention->get('path'), true, $formIntervention->get('file')->getData(), '10', array('csv', 'txt'));
  599.                 $row = 0;
  600.                 if($valid && ($handle = fopen($formIntervention->get('file')->getData(), "r")) !== FALSE) {
  601.                     while(($data = fgetcsv($handle, 2000, $formIntervention->get('separator')->getData())) !== FALSE) {
  602.                         // Salta righe vuote
  603.                         if(empty(array_filter($data))) {$row++; continue; }
  605.                         $data = array_map("utf8_encode", $data);
  606.                         if($row > 0){
  607.                             $ticket = null;
  608.                             $nTicket = null;
  609.                             $termid = null;
  610.                             switch($formIntervention->get('supplier')->getData()){
  611.                                 case 'fabrick-flex':
  612.                                     $ticket = $em->getRepository('App\Entity\Slave\Ticket')->findOneByLikeNumberAndTermid($data[1], $data[2]);
  613.                                     if($ticket == null){
  614.                                         $valid = false;
  615.                                         $formIntervention->get("path")->addError(new FormError("Ticket non trovato"));
  616.                                         $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!');
  617.                                         break;
  618.                                     }
  619.                                     if($valid){
  620.                                         $prodPos = $this->importInterventionSearchProduct($em, $data[9], $ticket->getSupplier());
  621.                                         if($prodPos == null){
  622.                                             $valid = false;
  623.                                             $formIntervention->get("path")->addError(new FormError("Matricola non presente"));
  624.                                             $this->addFlash('notice_danger', 'Non è stato trovato il prodotto presente alla riga '.($row + 1).' con matricola '.$data[9].' ! Ricontrolla il file!');
  625.                                             break;
  626.                                         }
  627.                                     }
  628.                                     if($valid){
  629.                                         $prodSim = $this->importInterventionSearchProduct($em, $data[10], $ticket->getSupplier());
  630.                                         if($prodSim == null){
  631.                                             $valid = false;
  632.                                             $formIntervention->get("path")->addError(new FormError("Matricola non presente"));
  633.                                             $this->addFlash('notice_danger', 'Non è stato trovato il prodotto presente alla riga '.($row + 1).' con matricola '.$data[10].'! Ricontrolla il file!');
  634.                                             break;
  635.                                         }
  636.                                     }
  637.                                     break;
  638.                                 default: break;
  639.                             }
  640.                         }
  641.                         $row++;
  642.                     }
  643.                     fclose($handle);
  644.                 }
  645.                 
  646.                 if($valid && $formIntervention->isValid()){
  648.                     $actualNumber = 0;
  649.                     $actualTermid = 0;
  650.                     $ignored = false;
  651.                     $continueIntervention = false;
  652.                     $row = 0;
  653.                     $ticketStatusClosed = $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'closed'));
  654.                     $countClosed = 0;
  655.                     $countIgnored = 0;
  657.                     if(($handle = fopen($formIntervention->get('file')->getData(), "r")) !== FALSE) {
  658.                         while(($data = fgetcsv($handle, 2000, $formIntervention->get('separator')->getData())) !== FALSE) {
  659.                             $data = array_map("utf8_encode", $data);
  660.                             if($row > 0){
  661.                                 switch($formIntervention->get('supplier')->getData()){
  662.                                     case 'fabrick-flex': // FABRICK FLEX
  664.                                         $ticket = $em->getRepository('App\Entity\Slave\Ticket')->findOneByLikeNumberAndTermid($data[1], $data[2]);
  666.                                         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"))
  667.                                             $countIgnored++;
  669.                                         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"){
  671.                                             $warehouse = $ticket->getTechnician()->mainWarehouse();
  672.                                             
  673.                                             // Inserisco intervento
  674.                                             $datetime = date_create_from_format('m/d/Y', $data[12]);
  675.                                             $intervention = $this->importInterventionCreate($em, $ticket, $warehouse, $datetime);
  677.                                             // Cerco o creo i prodotti del ticket
  678.                                             $pPos = $this->importInterventionSearchProduct($em, $data[9], $ticket->getSupplier());
  679.                                             $pSim = $this->importInterventionSearchProduct($em, $data[10], $ticket->getSupplier());
  681.                                             // Inserisco le attività
  682.                                             $activityTypePos = $em->getRepository('App\Entity\Slave\InterventionActivityType')->findOneBy(array('slug' => 'installato-pos-fabrick-flex'));
  683.                                             $activityTypeSim = $em->getRepository('App\Entity\Slave\InterventionActivityType')->findOneBy(array('slug' => 'installato-accessorio-fabrick-flex'));
  684.                                             $this->importInterventionActivity($em, $ticket, $intervention, $activityTypePos, false, null, $pPos, $warehouse, $datetime);
  685.                                             $this->importInterventionActivity($em, $ticket, $intervention, $activityTypeSim, false, null, $pSim, $warehouse, $datetime);
  686.                                             TicketService::createTicketLog($em, $this->getUser(), $ticket, "cs", $ticket->getStatus(), $ticketStatusClosed->getValue());
  687.                                             $ticket->setStatus($ticketStatusClosed);
  688.                                             $ticket->setWaybill($data[11]);
  689.                                             $ticket->setDatetimeEnd(new \Datetime());
  690.                                             $em->flush();
  691.                                             $countClosed++;
  692.                                         }
  693.                                         break;
  694.                                     default: break;
  695.                                 }
  696.                             }
  697.                             $row++;
  698.                         }
  699.                         fclose($handle);
  700.                     }
  702.                     $em->flush();
  703.                     $this->addFlash('notice_success', 'Sono stati inseriti '.$countClosed.' interventi e sono stati ignorati '.$countIgnored.' interventi perché sono cancellati/errati/chiusi!');
  704.                     return $this->redirectToRoute('user_ticket_list');
  705.                 }
  706.             }
  708.             // CHIUSURE PORTALE
  709.             $statusClosedPortal = $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'closed_portal'));
  710.             $ticketClosures = new ImportTicketClosures();
  711.             $formClosures = $formFactory->createNamed("form_import_ticket_closures", ImportTicketClosuresType::class, $ticketClosures);
  712.             $formClosures->handleRequest($request);
  714.             if($formClosures->isSubmitted()){
  715.                 
  716.                 $valid = true;
  717.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $formClosures->get('separator'));
  718.                 if($valid) $valid = ValidationService::validateCsvDelimiter($formClosures->get('file')->getData()->getPathName(), $formClosures->get('separator')->getData(), $formClosures->get('separator'));
  719.                 if($valid) $valid = ValidationService::validateFile($validator, $formClosures->get('path'), true, $formClosures->get('file')->getData(), '10', array('csv', 'txt'));
  720.                 if($valid) $valid = $this->importCheckFile($em, $validator, $formClosures);
  722.                 if($valid && $formClosures->isValid()){
  724.                     $row = 0;
  725.                     $counterNotUpdated = 0;
  726.                     $counterClosed = 0;
  727.                     $counterAlreadyClosed = 0;
  729.                     if(($handle = fopen($formClosures->get('file')->getData(), "r")) !== FALSE) {
  730.                         while(($data = fgetcsv($handle, 2000, $formClosures->get('separator')->getData())) !== FALSE) {
  731.                             $data = array_map("utf8_encode", $data);
  732.                             if($row > 0){
  733.                                 $ticket = $em->getRepository('App\Entity\Slave\Ticket')->findOneByNumberAndTermid($data[0], $data[1]);
  734.                                 if($ticket != null){
  735.                                     $ticket->setClosedOnPortal(true);
  736.                                     switch($ticket->getStatus()->getSlug()){
  737.                                         case 'closed': 
  738.                                             TicketService::createTicketLog($em, $this->getUser(), $ticket, "cs", $ticket->getStatus(), $statusClosedPortal->getValue());
  739.                                             $ticket->setStatus($statusClosedPortal); 
  740.                                             $counterClosed++; 
  741.                                             break;
  742.                                         case 'closed_portal': $counterAlreadyClosed++; break;
  743.                                         default: $counterNotUpdated++; break;
  744.                                     }
  745.                                 }
  746.                             }
  747.                             $row++;
  748.                         }
  749.                         fclose($handle);
  750.                     }
  751.                     $em->flush();
  753.                     $this->addFlash('notice_success', 'Ticket chiusi: '.$counterClosed.'<br>Ticket già chiusi: '.$counterAlreadyClosed.'<br>Ticket stato non aggiornato: '.$counterNotUpdated);
  754.                     return $this->redirectToRoute('user_ticket_list');
  755.                 }
  756.             }
  758.             // ANNULLA TICKET
  759.             $statusCanceled = $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'canceled'));
  760.             $ticketCancels = new ImportTicketCancels();
  761.             $formCancels = $formFactory->createNamed("form_import_ticket_cancels", ImportTicketCancelsType::class, $ticketCancels);
  762.             $formCancels->handleRequest($request);
  764.             if($formCancels->isSubmitted()){
  765.                 
  766.                 $valid = true;
  767.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $formCancels->get('separator'));
  768.                 if($valid) $valid = ValidationService::validateCsvDelimiter($formCancels->get('file')->getData()->getPathName(), $formCancels->get('separator')->getData(), $formCancels->get('separator'));
  769.                 if($valid) $valid = ValidationService::validateFile($validator, $formCancels->get('path'), true, $formCancels->get('file')->getData(), '10', array('csv', 'txt'));
  770.                 if($valid) $valid = $this->importCheckFile($em, $validator, $formCancels);
  772.                 if($valid && $formCancels->isValid()){
  774.                     $row = 0;
  775.                     if(($handle = fopen($formCancels->get('file')->getData(), "r")) !== FALSE) {
  776.                         while(($data = fgetcsv($handle, 2000, $formCancels->get('separator')->getData())) !== FALSE) {
  777.                             $data = array_map("utf8_encode", $data);
  778.                             if($row > 0){
  779.                                 $ticket = $em->getRepository('App\Entity\Slave\Ticket')->findOneByNumberAndTermid($data[0], $data[1]);
  780.                                 if($ticket != null){
  781.                                     TicketService::createTicketLog($em, $this->getUser(), $ticket, "cs", $ticket->getStatus(), $statusCanceled->getValue());
  782.                                     $ticket->setStatus($statusCanceled);
  783.                                 }
  784.                             }
  785.                             $row++;
  786.                         }
  787.                         fclose($handle);
  788.                     }
  789.                     $em->flush();
  791.                     $this->addFlash('notice_success', 'Ticket annullati!');
  792.                     return $this->redirectToRoute('user_ticket_list');
  793.                 }
  794.             }
  796.             // SOSPENDI TICKET
  797.             $statusSuspended = $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'suspended'));
  798.             $interventionOutcomeTypeSuspended = $em->getRepository('App\Entity\Slave\InterventionOutcomeType')->findOneBy(array('slug' => 'suspended'));
  800.             $ticketsSuspend = new ImportTicketsSuspend();
  801.             $formSuspend = $formFactory->createNamed("form_import_tickets_suspend", ImportTicketsSuspendType::class, $ticketsSuspend, array('typeSlug' => 'suspended'));
  802.             $formSuspend->handleRequest($request);
  804.             if($formSuspend->isSubmitted()){
  805.                 
  806.                 $today = new \Datetime();
  807.                 $valid = true;
  808.                 [$valid, $interventionOutcome] = FormValidatorService::validateIntervention($em, $validator, $formSuspend, 'suspended');
  809.                 if($valid) $valid = $this->importCheckFile($em, $validator, $formSuspend);
  810.                 
  811.                 if($valid && $formSuspend->isValid()){
  812.                     $row = 0;
  813.                     if(($handle = fopen($formSuspend->get('file')->getData(), "r")) !== FALSE) {
  814.                         while(($data = fgetcsv($handle, 2000, $formSuspend->get('separator')->getData())) !== FALSE) {
  815.                             $data = array_map("utf8_encode", $data);
  816.                             if($row > 0){
  817.                                 $ticket = $em->getRepository('App\Entity\Slave\Ticket')->findOneByNumberAndTermid($data[0], $data[1]);
  818.                                 if($ticket != null){
  819.                                     $suspensionDatetimeFrom = date_create_from_format("d-m-Y H:i", $formSuspend->get('dateFrom')->getData()->format('d-m-Y').' '.$formSuspend->get('timeFromHour')->getData().':'.$formSuspend->get('timeFromMinute')->getData());
  821.                                     $intervention = new Intervention();
  822.                                     $intervention->setTicket($ticket);
  823.                                     $intervention->setDatetime($suspensionDatetimeFrom);
  824.                                     $intervention->setOutcomeType($interventionOutcomeTypeSuspended);
  825.                                     $intervention->setOutcome($interventionOutcome);
  826.                                     $intervention->setDatetimeBilling(date_create_from_format('d-m-Y H:i:s', '01-'.$today->format('m').'-'.$today->format('Y').' 00:00:00'));
  827.                                     $intervention->setBillable(false);
  828.                                     $intervention->setMotivation($formSuspend->get("motivation")->getData());
  829.                                     $intervention->setOperator($this->getUser());
  830.                                     if($interventionOutcome->isReferentRequired()) $intervention->setReferent($formSuspend->get("referent")->getData());
  831.                                     if($interventionOutcome->isPhoneRequired()) $intervention->setPhone($formSuspend->get("phone")->getData());
  832.                                     if($interventionOutcome->isPhotoRequired()) {
  833.                                         $uploadDir = $this->params->get('kernel.project_dir').'/'.$this->params->get('web_path').'/companies/'.$company->getDirectoryPath().'/tickets/'.$ticket->getDirectoryPath().'/';
  834.                                         MediaService::uploadImage($fs, $formSuspend->get('file')->getData(), null, $uploadDir, $intervention, 'photo', 100, 1000, 200, true);
  835.                                     }
  836.                                     $em->persist($intervention);
  837.                     
  838.                                     $ticketSuspension = new TicketSuspension();
  839.                                     $ticketSuspension->setTicket($ticket);
  840.                                     $ticketSuspension->setIntervention($intervention);
  841.                                     $ticketSuspension->setDatetimeFrom($suspensionDatetimeFrom);
  842.                                     if($formSuspend->get('dateTo')->getData() != null && $formSuspend->get('timeToHour')->getData() != null && $formSuspend->get('timeToMinute')->getData() != null){
  843.                                         $ticketSuspension->setDatetimeTo(date_create_from_format("d-m-Y H:i", $formSuspend->get('dateTo')->getData()->format('d-m-Y').' '.$formSuspend->get('timeToHour')->getData().':'.$formSuspend->get('timeToMinute')->getData()));
  844.                                     }
  845.                                     $ticketSuspension->setApproved(true);
  846.                                     $ticketSuspension->setManaged(true);
  847.                                     $ticketSuspension->setRefuseMotivation(null);
  848.                                     $em->persist($ticketSuspension);
  849.                     
  850.                                     $settingUnlockSameTech = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'ticket_suspension_unlock_same_technician'));
  851.                                     if($settingUnlockSameTech->getValue() != 1){
  852.                                         TicketService::createTicketLog($em, $this->getUser(), $ticket, "ct", $ticket->getTechnician(), null);
  853.                                         $ticket->setTechnician(null);
  854.                                     }
  855.                                     TicketService::createTicketLog($em, $this->getUser(), $ticket, "cs", $ticket->getStatus(), $statusSuspended->getValue());
  856.                                     $ticket->setStatus($statusSuspended);
  857.                                     $em->flush();
  858.                                 }
  859.                             }
  860.                             $row++;
  861.                         }
  862.                         fclose($handle);
  863.                     }
  864.                     $em->flush();
  866.                     $this->addFlash('notice_success', 'Ticket sospesi!');
  867.                     return $this->redirectToRoute('user_ticket_list');
  868.                 }
  869.             }
  871.             // SBLOCCA SOSPENSIONE TICKET
  872.             $ticketsSusUnlock = new ImportTicketsSusUnlock();
  873.             $formSusUnlock = $formFactory->createNamed("form_import_tickets_sus_unlock", ImportTicketsSusUnlockType::class, $ticketsSusUnlock);
  874.             $formSusUnlock->handleRequest($request);
  876.             if($formSusUnlock->isSubmitted()){
  877.                 
  878.                 $valid = true;
  879.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $formSusUnlock->get('unlockCausal'));
  880.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $formSusUnlock->get('date'));
  881.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $formSusUnlock->get('hour'));
  882.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $formSusUnlock->get('minute'));
  883.                 if($valid) $valid = $this->importCheckFile($em, $validator, $formSusUnlock);
  885.                 if($valid && $formSusUnlock->isValid()){
  886.                     $row = 0;
  887.                     if(($handle = fopen($formSusUnlock->get('file')->getData(), "r")) !== FALSE) {
  888.                         while(($data = fgetcsv($handle, 2000, $formSusUnlock->get('separator')->getData())) !== FALSE) {
  889.                             $data = array_map("utf8_encode", $data);
  890.                             if($row > 0){
  891.                                 $ticket = $em->getRepository('App\Entity\Slave\Ticket')->findOneByNumberAndTermid($data[0], $data[1]);
  892.                                 if($ticket != null){
  893.                                     $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());
  894.                                     $unlockCausal = $formSusUnlock->get('unlockCausal')->getData();
  895.                                     $ticketSuspension = $ticket->getActualSuspension();
  896.                                     $ticketSuspension->unlock($em, $this->getUser(), $unlockCausal, $datetimeTo);
  897.                                 }
  898.                             }
  899.                             $row++;
  900.                         }
  901.                         fclose($handle);
  902.                     }
  903.                     $em->flush();
  905.                     $this->addFlash('notice_success', 'Sospensioni sbloccate!');
  906.                     return $this->redirectToRoute('user_ticket_list');
  907.                 }
  908.             }
  910.             return $this->render('role/user/ticket/import.html.twig', array(
  911.                 'formTicket' => $formTicket->createView(),
  912.                 'formIntervention' => $formIntervention->createView(),
  913.                 'formClosures' => $formClosures->createView(),
  914.                 'formCancels' => $formCancels->createView(),
  915.                 'formSuspend' => $formSuspend->createView(),
  916.                 'formSusUnlock' => $formSusUnlock->createView()
  917.             ));
  918.         }
  919.     //
  921.     /**
  922.      * @Route("/", name="user_tickets")
  923.      * @Security("is_granted('view', 'ticket')")
  924.      */
  925.     public function userTickets(Request $request)
  926.     {    
  927.         return $this->render('role/user/ticket/index.html.twig');
  928.     }
  930.     /**
  931.      * @Route("/ricerca", name="user_ticket_search")
  932.      * @Security("is_granted('view', 'ticket')")
  933.      */
  934.     public function userTicketSearch(Request $request, PaginatorInterface $paginator)
  935.     {    
  936.         $em = $this->mr->getManager('slave');
  937.         $tags = $em->getRepository("App\Entity\Slave\TicketTag")->findAllOrdered();
  938.         $suppliers = $em->getRepository("App\Entity\Slave\Supplier")->findAllActiveOrdered();
  939.         $operationGroups = $em->getRepository("App\Entity\Slave\OperationGroup")->findAllOrdered();
  940.         $ticketStatuses = $em->getRepository('App\Entity\Slave\TicketStatus')->findAll();
  941.         $settingProcessedActive = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'ticket_processed_active'));
  943.         if($this->getUser()->getAccountTypology() == 'technician'){
  944.             $filters = FilterService::ticket3Filter($request);
  945.             $ticketsQuery = $em->getRepository("App\Entity\Slave\Ticket")->findByTechnicianFiltered(true, $filters, $this->getUser()->getId());
  946.             $tickets = $paginator->paginate($ticketsQuery, $request->getSession()->get($request->get("_route")."_page"), 100);
  947.         }
  948.         else{
  949.             $filters = FilterService::ticket2Filter($request);
  950.             $ticketsQuery = $em->getRepository("App\Entity\Slave\Ticket")->findFiltered(true, $filters);
  951.             $tickets = $paginator->paginate($ticketsQuery, $request->getSession()->get($request->get("_route")."_page"), 100);
  952.         }
  953.         
  954.         return $this->render('role/user/ticket/search.html.twig', array(
  955.             'tickets' => $tickets,
  956.             'tags' => $tags,
  957.             'suppliers' => $suppliers,
  958.             'operations' => $operationGroups,
  959.             'filters' => $filters,
  960.             'settingProcessedActive' => $settingProcessedActive->getValue(),
  961.             'ticketStatuses' => $ticketStatuses
  962.         ));
  963.     }
  964.     
  965.     /**
  966.      * @Route("/ricerca/esporta-csv", name="user_ticket_search_filter_export")
  967.      * @Security("is_granted('view', 'ticket')")
  968.      */
  969.     public function userTicketSearchFilterExport(Request $request)
  970.     {    
  971.         $em = $this->mr->getManager('slave');
  972.         $emMaster = $this->mr->getManager('master');
  973.         $session = $request->getSession();
  974.         $filters = $session->get('user_ticket_search_filters');
  976.         if($this->getUser()->getAccountTypology() == 'technician')
  977.             $tickets = $em->getRepository("App\Entity\Slave\Ticket")->findByTechnicianFiltered(false, $filters, $this->getUser()->getId());
  978.         else
  979.             $tickets = $em->getRepository("App\Entity\Slave\Ticket")->findFiltered(false, $filters);
  981.         $response = new StreamedResponse();
  982.         $response->setCallback(function() use($emMaster, $tickets) {
  983.             $handle = fopen('php://output', 'w+');
  984.             fputcsv($handle, array('Stato','Numero','Termid','Tag','Cliente','Operazione','Fornitore','Tariffa','Provincia','Città','Indirizzo','Tecnico','Data/Ora ricezione','Data/Ora chiusura','Data/Ora scadenza','Fatturabile','Lettera di vettura'), ";", '"', "\\");
  986.             foreach($tickets as $t){
  987.                 $status = null;
  988.                 $number = null;
  989.                 $termid = null;
  990.                 $tags = null;
  991.                 $client = null;
  992.                 $operation = null;
  993.                 $supplier = null;
  994.                 $tariff = null;
  995.                 $province = null;
  996.                 $city = null;
  997.                 $address = null;
  998.                 $technician = null;
  999.                 $datetimeStart = null;
  1000.                 $datetimeEnd = null;
  1001.                 $datetimeExpiration = null;
  1002.                 $billable = 'No';
  1003.                 $waybill = null;
  1004.                 
  1005.                 if($t->getStatus() != null) $status = $t->getStatus()->getValue();
  1006.                 if($t->getNumber() != null) $number = $t->getNumber();
  1007.                 if($t->getTermid() != null) $termid = $t->getTermid()->getCode();
  1008.                 if(count($t->getTicketTags()) > 0) $tags = $t->displayTags('string');
  1009.                 if($t->getClient() != null) $client = $t->getClient()->__toString();
  1010.                 if($t->getOperation() != null) $operation = $t->getOperation()->__toString();
  1011.                 if($t->getOperationTariffAmount() != null) $tariff = $t->getOperationTariffAmount()->getValue();
  1012.                 if($t->getSupplier() != null) $supplier = $t->getSupplier()->__toString();
  1013.                 if($t->getIdProvince() != null) { $provinceObj = $emMaster->getRepository("App\Entity\Master\Province")->find($t->getIdProvince()); if($provinceObj) $province = $provinceObj->getSign(); }
  1014.                 if($t->getIdCity() != null) { $cityObj = $emMaster->getRepository("App\Entity\Master\City")->find($t->getIdCity()); if($cityObj) $city = $cityObj->getName(); }
  1015.                 if($t->getAddress() != null) $address = $t->getAddress();
  1016.                 if($t->getTechnician() != null) $technician = $t->getTechnician()->__toString();
  1017.                 if($t->getDatetimeStart() != null) $datetimeStart = $t->getDatetimeStart()->format('d-m-Y H:i');
  1018.                 if($t->getDatetimeEnd() != null) $datetimeEnd = $t->getDatetimeEnd()->format('d-m-Y H:i');
  1019.                 if($t->getDatetimeExpiration() != null) $datetimeExpiration = $t->getDatetimeExpiration()->format('d-m-Y H:i');
  1020.                 if($t->isBillable()) $billable = 'Sì';
  1021.                 if($t->getWaybill() != null) $waybill = $t->getWaybill();
  1023.                 
  1024.                 fputcsv($handle, array($status, $number, $termid, $tags, $client, $operation, $supplier, $tariff, $province, $city, $address, $technician, $datetimeStart, $datetimeEnd, $datetimeExpiration, $billable, $waybill), ";", '"', "\\");
  1025.             }
  1027.             fclose($handle);
  1028.         });    
  1029.         $response->setStatusCode(200);
  1030.         $dispositionHeader = $response->headers->makeDisposition(ResponseHeaderBag::DISPOSITION_ATTACHMENT, 'Ticket filtrati.csv');
  1031.         $response->headers->set('Content-Type', 'text/csv; charset=UTF-8');
  1032.         $response->headers->set('Content-Disposition', $dispositionHeader);
  1033.         return $response;
  1034.     }
  1036.     /**
  1037.      * @Route("/lista-tab", name="user_ticket_list_tab")
  1038.      * @Security("is_granted('view', 'ticket')")
  1039.      */
  1040.     public function userTicketListTab(Request $request)
  1041.     {    
  1042.         $request->getSession()->set('user_ticket_list_tab', $request->request->get('ticketTabOpen'));
  1043.         $request->getSession()->set('tab_operation_group', $request->request->get('ticketOperationGroup'));
  1044.         $request->getSession()->set('tab_technician', $request->request->get('ticketTechnician'));
  1045.         return $this->redirectToRoute('user_ticket_list');
  1046.     }
  1047.     
  1048.     /**
  1049.      * @Route("/lista", name="user_ticket_list")
  1050.      * @Security("is_granted('view', 'ticket')")
  1051.      */
  1052.     public function userTicketList(Request $request, PaginatorInterface $paginator, ValidatorInterface $validator, FormFactoryInterface $formFactory, FileSystem $fs, MailerInterface $mailer)
  1053.     {    
  1054.         $em = $this->mr->getManager('slave');
  1055.         $emMaster = $this->mr->getManager('master');
  1056.         $session = $request->getSession();
  1057.         $cities = $emMaster->getRepository("App\Entity\Master\City")->findByName('');
  1058.         $settingBackOffice = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'ticket_backoffice_manage'));
  1059.         $settingProcessedActive = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'ticket_processed_active'));
  1060.         $settingTechnicianSendAssignEmail = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'ticket_technician_send_assign_email'));
  1061.         $tags = $em->getRepository("App\Entity\Slave\TicketTag")->findAllOrdered();
  1062.         $suppliers = $em->getRepository("App\Entity\Slave\Supplier")->findAllActiveOrdered();
  1063.         $operationGroups = $em->getRepository("App\Entity\Slave\OperationGroup")->findAllOrdered();
  1065.         if($this->getUser()->getAccountTypology() == 'agency' || $this->getUser()->getAccountTypology() == 'warehouse'){
  1066.             # Agenzia
  1067.             $filters = FilterService::ticketFilter($request);
  1068.             if($session->get('tab_operation_group') != null){
  1069.                 $filters['operation'] = $session->get('tab_operation_group');
  1070.             }
  1071.             if($session->get('tab_technician') != null){
  1072.                 $filters['technician'] = $session->get('tab_technician');
  1073.             }
  1074.             
  1075.             $errorTicketsQuery = $em->getRepository("App\Entity\Slave\Ticket")->findTicketsErrorFiltered(true, $filters);
  1076.             $errorTickets = $paginator->paginate($errorTicketsQuery, $request->getSession()->get($request->get("_route")."_page"), 100);
  1078.             $toAssignTicketsQuery = $em->getRepository("App\Entity\Slave\Ticket")->findTicketsByStatusFiltered(true, 'to_assign', $filters);
  1079.             $toAssignTickets = $paginator->paginate($toAssignTicketsQuery, $request->getSession()->get($request->get("_route")."_page"), 100);
  1080.             
  1081.             $assignedTicketsQuery = $em->getRepository("App\Entity\Slave\Ticket")->findTicketsByStatusFiltered(true, 'assigned', $filters);
  1082.             $assignedTickets = $paginator->paginate($assignedTicketsQuery, $request->getSession()->get($request->get("_route")."_page"), 100);
  1083.             
  1084.             $takenChargeTicketsQuery = $em->getRepository("App\Entity\Slave\Ticket")->findTicketsByStatusFiltered(true, 'taken_charge', $filters);
  1085.             $takenChargeTickets = $paginator->paginate($takenChargeTicketsQuery, $request->getSession()->get($request->get("_route")."_page"), 100);
  1086.             
  1087.             $suspensionRequestTicketsQuery = $em->getRepository("App\Entity\Slave\Ticket")->findTicketsByStatusFiltered(true, 'suspension_request', $filters);
  1088.             $suspensionRequestTickets = $paginator->paginate($suspensionRequestTicketsQuery, $request->getSession()->get($request->get("_route")."_page"), 100);
  1090.             $suspendedTicketsQuery = $em->getRepository("App\Entity\Slave\Ticket")->findTicketsByStatusFiltered(true, 'suspended', $filters);
  1091.             $suspendedTickets = $paginator->paginate($suspendedTicketsQuery, $request->getSession()->get($request->get("_route")."_page"), 100);
  1092.             
  1093.             $closedTicketsQuery = $em->getRepository("App\Entity\Slave\Ticket")->findTicketsByStatusFiltered(true, 'closed', $filters);
  1094.             $closedTickets = $paginator->paginate($closedTicketsQuery, $request->getSession()->get($request->get("_route")."_page"), 100);
  1095.             
  1096.             $closedPortalTicketsQuery = $em->getRepository("App\Entity\Slave\Ticket")->findTicketsByStatusFiltered(true, 'closed_portal', $filters);
  1097.             $closedPortalTickets = $paginator->paginate($closedPortalTicketsQuery, $request->getSession()->get($request->get("_route")."_page"), 100);
  1098.             
  1099.             $canceledTicketsQuery = $em->getRepository("App\Entity\Slave\Ticket")->findTicketsByStatusFiltered(true, 'canceled', $filters);
  1100.             $canceledTickets = $paginator->paginate($canceledTicketsQuery, $request->getSession()->get($request->get("_route")."_page"), 100);
  1101.             
  1102.             $wrongTicketsQuery = $em->getRepository("App\Entity\Slave\Ticket")->findTicketsByStatusFiltered(true, 'wrong', $filters);
  1103.             $wrongTickets = $paginator->paginate($wrongTicketsQuery, $request->getSession()->get($request->get("_route")."_page"), 100);
  1105.             // Assegna ticket
  1106.             $ticketsError = "Ticket assegnati! Ticket non spostati perché hanno un intervento in corso: ";
  1107.             $error = false;
  1108.             $first = true;
  1109.             $assignTechnician = new AssignTechnician();
  1110.             $formAssignTechnician = $formFactory->createNamed("form_assign_technician", AssignTechnicianType::class, $assignTechnician);
  1111.             $formAssignTechnician->handleRequest($request);
  1113.             if($formAssignTechnician->isSubmitted()){
  1114.                 
  1115.                 $valid = ValidationService::validateNotBlank($validator, $formAssignTechnician->get("technician"));
  1117.                 if($valid && $formAssignTechnician->isValid()){
  1119.                     $statusAssigned = $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'assigned'));
  1120.                     $ids = $request->request->get('ids');
  1121.                     $ticketIds = explode(',', $ids);
  1122.                     $tickets = [];
  1123.                     foreach($ticketIds as $ticketId){
  1125.                         $ticket = $em->getRepository('App\Entity\Slave\Ticket')->findOneById($ticketId);
  1126.                         $interventionId = null;
  1127.                         foreach($ticket->getInterventions() as $int){
  1128.                             if($int->getOutcome() == null){
  1129.                                 $interventionId = $int->getId();
  1130.                                 break;
  1131.                             }
  1132.                         }
  1134.                         if($interventionId == null){
  1135.                             TicketService::createTicketLog($em, $this->getUser(), $ticket, "ct", $ticket->getTechnician(), $formAssignTechnician->get("technician")->getData());
  1136.                             $ticket->setTechnician($formAssignTechnician->get("technician")->getData());
  1137.                             TicketService::createTicketLog($em, $this->getUser(), $ticket, "cs", $ticket->getStatus(), $statusAssigned->getValue());
  1138.                             $ticket->setStatus($statusAssigned);
  1139.                             array_push($tickets, $ticket);
  1140.                         }
  1141.                         else{
  1142.                             $error = true;
  1143.                             if($first) $first = false; else $ticketsError .= ', ';
  1144.                             $ticketsError .= $ticket->getNumber();
  1145.                         }
  1146.                     }
  1148.                     $em->flush();
  1150.                     // Invio messaggio di notifica al tecnico
  1151.                     if($settingTechnicianSendAssignEmail->getValue() == 1 && sizeof($tickets) > 0 && $ticket->getTechnician()->isAssignEmailActive()){
  1152.                         $message = (new TemplatedEmail())
  1153.                             ->subject($this->params->get('subject_ticket_take_charge'))
  1154.                             ->from($this->params->get('email_noreply'))
  1155.                             ->to($ticket->getTechnician()->getEmail())
  1156.                             ->htmlTemplate('email/technician/tickets_assigned.html.twig')
  1157.                             ->context(['user' => $ticket->getTechnician(), 'tickets' => $tickets]);
  1158.                         $mailer->send($message);
  1159.                     }
  1161.                     if(!$error)
  1162.                         $this->addFlash('notice_success', "Tecnico assegnato ai ticket!");
  1163.                     else
  1164.                         $this->addFlash('notice_success', $ticketsError);
  1165.                     return $this->redirectToRoute('user_ticket_list');
  1166.                 }
  1167.             }
  1168.             
  1169.             // Sospendi ticket
  1170.             $intervention = new Intervention();
  1171.             $formSuspension = $formFactory->createNamed("form_suspension", InterventionType::class, $intervention, array('typeSlug' => 'suspended'));
  1172.             $formSuspension->handleRequest($request);
  1173.     
  1174.             if($formSuspension->isSubmitted()){
  1175.     
  1176.                 $ids = $request->request->get('ids');
  1177.                 [$valid, $interventionOutcome] = FormValidatorService::validateIntervention($em, $validator, $formSuspension, 'suspended');
  1178.     
  1179.                 if($valid && $formSuspension->isValid()){
  1181.                     $tickets = [];
  1182.                     $ticketIds = explode(',', $ids);
  1183.                     $today = new \Datetime();
  1185.                     foreach($ticketIds as $ticketId){
  1186.                         $ticket = $em->getRepository('App\Entity\Slave\Ticket')->findOneById($ticketId);
  1188.                         $suspensionDatetimeFrom = date_create_from_format("d-m-Y H:i", $formSuspension->get('dateFrom')->getData()->format('d-m-Y').' '.$formSuspension->get('timeFromHour')->getData().':'.$formSuspension->get('timeFromMinute')->getData());
  1189.                     
  1190.                         $intervention = new Intervention();
  1191.                         $intervention->setTicket($ticket);
  1192.                         $intervention->setDatetime($suspensionDatetimeFrom);
  1193.                         $intervention->setMotivation($formSuspension->get("motivation")->getData());
  1194.                         $intervention->setOutcomeType($em->getRepository('App\Entity\Slave\InterventionOutcomeType')->findOneBySlug('suspended'));
  1195.                         $intervention->setOutcome($interventionOutcome);
  1196.                         $intervention->setDatetimeBilling(date_create_from_format('d-m-Y H:i:s', '01-'.$today->format('m').'-'.$today->format('Y').' 00:00:00'));
  1197.                         $intervention->setBillable(false);
  1198.                         $intervention->setOperator($this->getUser());
  1199.                         if($interventionOutcome->isReferentRequired()) $intervention->setReferent($formSuspension->get("referent")->getData());
  1200.                         if($interventionOutcome->isPhoneRequired()) $intervention->setPhone($formSuspension->get("phone")->getData());
  1201.                         if($interventionOutcome->isPhotoRequired()) {
  1202.                             $uploadDir = $this->params->get('kernel.project_dir').'/'.$this->params->get('web_path').'/companies/'.$company->getDirectoryPath().'/tickets/'.$ticket->getDirectoryPath().'/';
  1203.                             MediaService::uploadImage($fs, $formSuspension->get('file')->getData(), null, $uploadDir, $intervention, 'photo', 100, 1000, 200, true);
  1204.                         }
  1205.                         $em->persist($intervention);
  1206.         
  1207.                         // Inserisco la sospensione del ticket
  1208.                         $suspension = new TicketSuspension();
  1209.                         $suspension->setTicket($ticket);
  1210.                         $suspension->setIntervention($intervention);
  1211.                         $suspension->setDatetimeFrom($suspensionDatetimeFrom);
  1212.                         if($formSuspension->get('dateTo')->getData() != null && $formSuspension->get('timeToHour')->getData() != null && $formSuspension->get('timeToMinute')->getData() != null){
  1213.                             $suspension->setDatetimeTo(date_create_from_format("d-m-Y H:i", $formSuspension->get('dateTo')->getData()->format('d-m-Y').' '.$formSuspension->get('timeToHour')->getData().':'.$formSuspension->get('timeToMinute')->getData()));
  1214.                         }
  1215.                         $suspension->setApproved(true);
  1216.                         $suspension->setManaged(true);
  1217.                         $em->persist($suspension);
  1219.                         $settingUnlockSameTech = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'ticket_suspension_unlock_same_technician'));
  1220.                         if($settingUnlockSameTech->getValue() != 1){
  1221.                             TicketService::createTicketLog($em, $this->getUser(), $ticket, "ct", $ticket->getTechnician(), null);
  1222.                             $ticket->setTechnician(null);
  1223.                         }
  1224.                         $statusSuspended = $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'suspended'));
  1225.                         TicketService::createTicketLog($em, $this->getUser(), $ticket, "cs", $ticket->getStatus(), $statusSuspended->getValue());
  1226.                         $ticket->setStatus($statusSuspended);
  1227.     
  1228.                         $em->flush();
  1230.                         if($ticket->getTechnician() != null)
  1231.                             $tickets[$ticket->getTechnician()->getId()][] = $ticketId;
  1232.                     }
  1233.                     
  1234.                     // Invio messaggio di notifica ai tecnici
  1235.                     foreach($tickets as $techId => $ticketIds){
  1236.                         $technician = $em->getRepository('App\Entity\Slave\User')->findOneById($techId);
  1237.                         if($technician && $settingTechnicianSendAssignEmail->getValue() == 1 && count($ticketIds) > 0 && $technician->isAssignEmailActive()){
  1238.                             $ticketsToSend = [];
  1239.                             foreach($ticketIds as $tId){
  1240.                                 $tObj = $em->getRepository('App\Entity\Slave\Ticket')->findOneById($tId);
  1241.                                 if($tObj) $ticketsToSend[] = $tObj;
  1242.                             }
  1243.                             if(count($ticketsToSend) > 0){
  1244.                                 $message = (new TemplatedEmail())
  1245.                                     ->subject($this->params->get('subject_ticket_suspended'))
  1246.                                     ->from($this->params->get('email_noreply'))
  1247.                                     ->to($technician->getEmail())
  1248.                                     ->htmlTemplate('email/technician/tickets_suspended.html.twig')
  1249.                                     ->context(['technician' => $technician, 'tickets' => $ticketsToSend]);
  1250.                                 $mailer->send($message);
  1251.                             }
  1252.                         }
  1253.                     }
  1254.                         
  1255.                     $this->addFlash('notice_success', 'Ticket sospesi');
  1256.                     return $this->redirectToRoute('user_ticket_list');
  1257.                 }
  1258.                 else{
  1259.                     $session->set('openSuspensionModal', true);
  1260.                     $session->set('openSuspensionModalIds', $ids);
  1261.                 }
  1262.             }
  1264.             return $this->render('role/user/ticket/list.html.twig', array(
  1265.                 'cities' => $cities,
  1266.                 'settingBackOffice' => $settingBackOffice != null ? $settingBackOffice->getValue() : false,
  1267.                 'settingProcessedActive' => $settingProcessedActive != null ? $settingProcessedActive->getValue() : false,
  1268.                 'errorTickets' => $errorTickets,
  1269.                 'toAssignTickets' => $toAssignTickets,
  1270.                 'assignedTickets' => $assignedTickets,
  1271.                 'takenChargeTickets' => $takenChargeTickets,
  1272.                 'suspensionRequestTickets' => $suspensionRequestTickets,
  1273.                 'suspendedTickets' => $suspendedTickets,
  1274.                 'closedTickets' => $closedTickets,
  1275.                 'closedPortalTickets' => $closedPortalTickets,
  1276.                 'canceledTickets' => $canceledTickets,
  1277.                 'wrongTickets' => $wrongTickets,
  1278.                 'suppliers' => $suppliers,
  1279.                 'operations' => $operationGroups,
  1280.                 'tags' => $tags,
  1281.                 'filters' => $filters,
  1282.                 'formAssignTechnician' => $formAssignTechnician->createView(),
  1283.                 'formSuspension' => $formSuspension->createView()
  1284.             ));
  1285.         }
  1287.         if($this->getUser()->getAccountTypology() == 'technician'){
  1289.             # Tecnico
  1290.             $settingTechUnlockSuspension = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'ticket_suspension_unlock_by_technician'));
  1291.             $filters = FilterService::ticketTechnicianFilter($request);
  1292.             if($session->get('tab_operation_group') != null){
  1293.                 $filters['all'] = $session->get('tab_operation_group');
  1294.             }
  1295.             if($session->get('numberOrTermid') != null){
  1296.                 $filters['all'] = $session->get('numberOrTermid');
  1297.                 $session->remove('numberOrTermid');
  1298.             }
  1300.             $assignedTicketsQuery = $em->getRepository("App\Entity\Slave\Ticket")->findTicketsByUserAndStatusFiltered(true, $this->getUser()->getId(), 'assigned', $filters);
  1301.             $assignedTickets = $paginator->paginate($assignedTicketsQuery, $request->getSession()->get($request->get("_route")."_page"), 100);
  1302.             
  1303.             $takenChargeTicketsQuery = $em->getRepository("App\Entity\Slave\Ticket")->findTicketsByUserAndStatusFiltered(true, $this->getUser()->getId(), 'taken_charge', $filters);
  1304.             $takenChargeTickets = $paginator->paginate($takenChargeTicketsQuery, $request->getSession()->get($request->get("_route")."_page"), 100);
  1305.             
  1306.             $suspensionRequestTicketsQuery = $em->getRepository("App\Entity\Slave\Ticket")->findTicketsByUserAndStatusFiltered(true, $this->getUser()->getId(), 'suspension_request', $filters);
  1307.             $suspensionRequestTickets = $paginator->paginate($suspensionRequestTicketsQuery, $request->getSession()->get($request->get("_route")."_page"), 100);
  1309.             $suspendedTicketsQuery = $em->getRepository("App\Entity\Slave\Ticket")->findTicketsByUserAndStatusFiltered(true, $this->getUser()->getId(), 'suspended', $filters);
  1310.             $suspendedTickets = $paginator->paginate($suspendedTicketsQuery, $request->getSession()->get($request->get("_route")."_page"), 100);
  1311.             
  1312.             $closedTicketsQuery = $em->getRepository("App\Entity\Slave\Ticket")->findTicketsByUserAndStatusFiltered(true, $this->getUser()->getId(), 'closed', $filters);
  1313.             $closedTickets = $paginator->paginate($closedTicketsQuery, $request->getSession()->get($request->get("_route")."_page"), 100);
  1314.             
  1315.             $closedPortalTicketsQuery = $em->getRepository("App\Entity\Slave\Ticket")->findTicketsByUserAndStatusFiltered(true, $this->getUser()->getId(), 'closed_portal', $filters);
  1316.             $closedPortalTickets = $paginator->paginate($closedPortalTicketsQuery, $request->getSession()->get($request->get("_route")."_page"), 100);
  1317.             
  1318.             $canceledTicketsQuery = $em->getRepository("App\Entity\Slave\Ticket")->findTicketsByUserAndStatusFiltered(true, $this->getUser()->getId(), 'canceled', $filters);
  1319.             $canceledTickets = $paginator->paginate($canceledTicketsQuery, $request->getSession()->get($request->get("_route")."_page"), 100);
  1320.             
  1321.             return $this->render('role/user/ticket/list.html.twig', array(
  1322.                 'settingProcessedActive' => $settingProcessedActive->getValue(),
  1323.                 'settingTechUnlockSuspension' => $settingTechUnlockSuspension,
  1324.                 'assignedTickets' => $assignedTickets,
  1325.                 'takenChargeTickets' => $takenChargeTickets,
  1326.                 'suspensionRequestTickets' => $suspensionRequestTickets,
  1327.                 'suspendedTickets' => $suspendedTickets,
  1328.                 'closedTickets' => $closedTickets,
  1329.                 'closedPortalTickets' => $closedPortalTickets,
  1330.                 'canceledTickets' => $canceledTickets,
  1331.                 'tags' => $tags,
  1332.                 'suppliers' => $suppliers,
  1333.                 'operations' => $operationGroups,
  1334.                 'filters' => $filters
  1335.             ));
  1336.         }    
  1337.     }
  1338.     
  1339.     // AZIONI LISTA
  1340.         // MULTIPLE
  1341.             /**
  1342.              * @Route("/selezione-multipla-azione", name="user_ticket_multiple_select_action")
  1343.              * @Security("is_granted('edit', 'ticket')")
  1344.              */
  1345.             public function userTicketMultipleSelectAction(Request $request, MailerInterface $mailer)
  1346.             {    
  1347.                 $em = $this->mr->getManager('slave');
  1348.                 $session = $request->getSession();
  1349.                 $tab = $request->request->get('tab');
  1350.                 $action = $request->request->get('action');
  1351.                 $ids = $request->request->get('ids');
  1352.                 $causal = $request->request->get('causal');
  1354.                 $session->set('ticketsIds', $ids);
  1355.                 $session->set('ticketsAction', $action);
  1357.                 $valid = true;
  1358.                 switch($action){
  1359.                     case 'suspend_end': 
  1360.                         if($causal == null || $causal == ''){
  1361.                             $valid = false;
  1362.                             $session->set('ticketsError', 'causal');
  1363.                         }
  1364.                         break;
  1365.                     default: break;
  1366.                 }
  1368.                 if($valid){
  1369.                     $tickets = array();
  1370.                     $ticketsIds = explode(',', $ids);
  1371.                     foreach($ticketsIds as $id){
  1372.                         $t = $em->getRepository("App\Entity\Slave\Ticket")->findOneById($id);
  1373.                         array_push($tickets, $t);
  1374.                     }
  1376.                     switch($action){
  1377.                         case 'wrong':
  1378.                             $wrongStatus = $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBySlug('wrong');
  1379.                             foreach($tickets as $ticket){
  1380.                                 $ticket->setSystemError(false);
  1381.                                 $ticket->setSystemErrorSlug(null);
  1382.                                 $ticket->setSystemErrorDetails(null);
  1383.                                 TicketService::createTicketLog($em, $this->getUser(), $ticket, "cs", $ticket->getStatus(), $wrongStatus->getValue());
  1384.                                 $ticket->setStatus($wrongStatus);
  1385.                             }
  1386.                             $em->flush();
  1387.                             $this->addFlash('notice_success', 'Ticket spostati in errati!');
  1388.                             break;
  1389.                         case 'print': 
  1390.                             return $this->redirectToRoute('user_ticket_reports_print');
  1391.                             break;
  1392.                         case 'suspend_end':
  1393.                             foreach($tickets as $ticket){
  1394.                                 $ticketSuspension = $ticket->getActualSuspension();
  1395.                                 $ticketSuspension->unlock($em, $this->getUser(), $causal, new \Datetime());
  1396.                             }
  1397.                             $em->flush();
  1398.                             $this->addFlash('notice_success', 'Sospensioni sbloccate!');
  1399.                             break;
  1400.                         case 'approve':
  1401.                             $suspendedStatus = $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'suspended'));
  1402.                             foreach($tickets as $ticket){
  1403.                                 $ticketSuspension = $ticket->getActualSuspension();
  1404.                                 $ticketSuspension->setApproved(true);
  1405.                                 $ticketSuspension->setManaged(true);
  1406.                     
  1407.                                 $settingUnlockSameTech = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'ticket_suspension_unlock_same_technician'));
  1408.                                 if($settingUnlockSameTech->getValue() != 1){
  1409.                                     TicketService::createTicketLog($em, $this->getUser(), $ticket, "ct", $ticket->getTechnician(), null);
  1410.                                     $ticket->setTechnician(null);
  1411.                                 }
  1412.                                 TicketService::createTicketLog($em, $this->getUser(), $ticket, "cs", $ticket->getStatus(), $suspendedStatus->getValue());
  1413.                                 $ticket->setStatus($suspendedStatus);
  1414.                             }
  1416.                             // TODO inviare una email con l'elenco delle sospensioni approvate per ogni tecnico
  1418.                             $em->flush();
  1419.                             $this->addFlash('notice_success', 'Sospensioni approvate!');
  1420.                             break;
  1421.                         case 'closed_portal':
  1422.                             $closedPortalStatus = $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'closed_portal'));
  1423.                             foreach($tickets as $ticket){
  1424.                                 TicketService::createTicketLog($em, $this->getUser(), $ticket, "cs", $ticket->getStatus(), $closedPortalStatus->getValue());
  1425.                                 $ticket->setStatus($closedPortalStatus);
  1426.                                 $ticket->setClosedOnPortal(1);
  1427.                             }
  1428.                             $em->flush();
  1429.                             $this->addFlash('notice_success', 'Ticket chiusi su portal fornitore!');
  1430.                             break;
  1431.                         case 'cancel': 
  1432.                             $canceledStatus = $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'canceled'));
  1433.                             foreach($tickets as $ticket){
  1434.                                 TicketService::createTicketLog($em, $this->getUser(), $ticket, "cs", $ticket->getStatus(), $canceledStatus->getValue());
  1435.                                 $ticket->setStatus($canceledStatus);
  1436.                             }
  1438.                             // TODO inviare una email con l'elenco dei ticket annullati per ogni tecnico
  1440.                             $em->flush();
  1441.                             $this->addFlash('notice_success', 'Ticket annullati!');
  1442.                             break;
  1443.                         case 'delete': 
  1444.                             $countDeleted = 0;
  1445.                             $countIgnored = 0;
  1446.                             foreach($tickets as $ticket){
  1447.                                 if($ticket->canDelete('all')){
  1448.                                     $this->deleteTicketAndConnectedValues($em, $ticket);
  1449.                                     $countDeleted++;
  1450.                                 }
  1451.                                 else
  1452.                                     $countIgnored++;
  1453.                             }
  1454.                             $em->flush();
  1455.                             $this->addFlash('notice_success', 'Rimossi '.$countDeleted.' ticket e ignorati '.$countIgnored.' ticket non eliminabili!');
  1456.                             break;
  1457.                         case 'urge':
  1458.                             $now = new \Datetime();
  1459.                             $settingSunday = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'script_sunday_active'));
  1460.                             $techniciansIds = array();
  1461.                             $users = array();
  1462.                             foreach($tickets as $ticket){
  1463.                                 if(!in_array($ticket->getTechnician()->getId(), $techniciansIds))
  1464.                                     array_push($techniciansIds, $ticket->getTechnician()->getId());
  1465.                             }
  1466.                             if($settingSunday->getValue() == 1 || ($settingSunday->getValue() == 0 && $today->format('N') != 7)){
  1467.                                 foreach($techniciansIds as $tId){
  1468.                                     $tmp = array();
  1469.                                     $tmp2 = array();
  1470.                                     $technician = $em->getRepository('App\Entity\Slave\User')->findOneById($tId);
  1472.                                     if(!$technician->isInHolidayAtDate($now)){
  1473.                                         foreach($tickets as $ticket){
  1474.                                             if($ticket->getTechnician()->getId() == $technician->getId())
  1475.                                                 array_push($tmp2, $ticket);
  1476.                                         }
  1477.                                     }
  1479.                                     array_push($tmp, $technician, $tmp2);
  1480.                                     array_push($users, $tmp);
  1481.                                 }
  1482.                                 
  1483.                                 foreach($users as $u){
  1484.                                     $message = (new TemplatedEmail())
  1485.                                         ->subject($this->params->get('subject_ticket_urge'))
  1486.                                         ->from($this->params->get('email_urgent'))
  1487.                                         ->to($u[0]->getEmail())
  1488.                                         ->htmlTemplate('email/technician/urge_tickets.html.twig')
  1489.                                         ->context(['user' => $u[0], 'tickets' => $u[1]]);
  1490.                                     $mailer->send($message);
  1491.                                 }
  1493.                                 $this->addFlash('notice_success', 'Email di notifica urgenza inviate!');
  1494.                             }
  1495.                             else{
  1496.                                 $this->addFlash('notice_warning', 'Notifiche disabilitate la Domenica! Attivale dalle impostazioni');
  1497.                             }
  1498.                             break;
  1499.                         default: break;
  1500.                     }
  1501.                 }
  1502.                 return $this->redirectToRoute('user_ticket_list');
  1503.             }
  1505.             /**
  1506.              * @Route("/verbali-stampa", name="user_ticket_reports_print")
  1507.              * @Security("is_granted('view', 'ticket')")
  1508.              */
  1509.             public function userTicketReportsPrint(Request $request)
  1510.             {    
  1511.                 $em = $this->mr->getManager('slave');
  1512.                 $session = $request->getSession();
  1513.                 $matrixTickets = array();
  1514.                 $ticketsIds = explode(',', $session->get('ticketsIds'));
  1515.                 foreach($ticketsIds as $id){
  1516.                     $t = $em->getRepository("App\Entity\Slave\Ticket")->findOneById($id);
  1517.                     $jsonReportValues = array();
  1518.                     $tmp = array();
  1519.                     if($t->getJsonReport() != '[]'){
  1520.                         $matrix = json_decode($t->getJsonReport(), true);
  1521.                         foreach($matrix as $array)
  1522.                             foreach($array as $a){
  1523.                                 $tcv = $em->getRepository('App\Entity\Slave\TicketColumnValue')->findOneBySupplierTicketColumnAndNeedle($t->getSupplier()->getId(), array_keys($array)[0], $a);
  1524.                                 $htmlToAdd = '';
  1525.                                 if($tcv != null)
  1526.                                     $htmlToAdd = ' ('.$tcv->getValue().')';
  1527.                                 $jsonReportValues[array_keys($array)[0]] = $a.$htmlToAdd;
  1528.                             }
  1529.                     }
  1530.                     array_push($tmp, $t, $jsonReportValues);
  1531.                     array_push($matrixTickets, $tmp);
  1532.                 }
  1533.                 
  1534.                 return $this->render('role/user/print/report.html.twig', array(
  1535.                     'matrixTickets' => $matrixTickets,
  1536.                     'backRoute' => 'list',
  1537.                     'continueRoute' => 'list'
  1538.                 ));
  1539.             }
  1541.             /**
  1542.              * @Route("/verbali-stampati", name="user_ticket_report_printed")
  1543.              * @Security("is_granted('view', 'ticket')")
  1544.              */
  1545.             public function userTicketReportPrinted(Request $request)
  1546.             {    
  1547.                 $em = $this->mr->getManager('slave');
  1548.                 $session = $request->getSession();
  1549.                 $ticketsIds = explode(',', $session->get('ticketsIds'));
  1550.                 foreach($ticketsIds as $id){
  1551.                     $t = $em->getRepository("App\Entity\Slave\Ticket")->findOneById($id);
  1552.                     $t->setReportPrinted(true);
  1553.                 }
  1554.                 $em->flush();
  1555.                 return $this->redirectToRoute('user_ticket_list');                
  1556.             }
  1557.             
  1558.             /**
  1559.              * @Route("/lista/esporta", name="user_ticket_list_export")
  1560.              * @Security("is_granted('view', 'ticket')")
  1561.              */
  1562.             public function userTicketListExport(Request $request)
  1563.             {    
  1564.                 $em = $this->mr->getManager('slave');
  1565.                 $emMaster = $this->mr->getManager('master');
  1566.                 $session = $request->getSession();
  1567.                 $ids = $request->request->get('ids');
  1568.                 $ticketsIds = explode(',', $ids);
  1570.                 $company = $emMaster->getRepository('App\Entity\Master\Company')->findOneById($session->get('companyId'));
  1571.                 $settingProcessedActive = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'ticket_processed_active'));
  1572.                 
  1573.                 $response = new StreamedResponse();
  1574.                 $response->setCallback(function() use($em, $emMaster, $company, $ticketsIds, $settingProcessedActive){
  1575.                     $handle = fopen('php://output', 'w+');
  1577.                     if($company->isTagTicketActive())
  1578.                         fputcsv($handle, array('Stato', 'Numero', 'Termid', 'Tag', 'Cliente', 'Operazione (Dettagli)', 'Fornitore (SLOT)', 'Tariffa', 'Città (Indirizzo)', 'Provincia', 'Tecnico', 'Data/Ora ricezione', 'Data/Ora scadenza', 'Note'), ";", '"', '\\');
  1579.                     else
  1580.                         fputcsv($handle, array('Stato', 'Numero', 'Termid', 'Cliente', 'Operazione (Dettagli)', 'Fornitore (SLOT)', 'Tariffa', 'Città (Indirizzo)', 'Provincia', 'Tecnico', 'Data/Ora ricezione', 'Data/Ora scadenza', 'Note'), ";", '"', '\\');
  1581.                     foreach($ticketsIds as $id){
  1582.                         $status = null;
  1583.                         $number = null;
  1584.                         $termid = null;
  1585.                         $tags = null;
  1586.                         $client = null;
  1587.                         $operation = null;
  1588.                         $key = null;
  1589.                         $supplier = null;
  1590.                         $slot = null;
  1591.                         $tariff = null;
  1592.                         $city = null;
  1593.                         $province = null;
  1594.                         $technician = null;
  1595.                         $datetimeStart = null;
  1596.                         $datetimeExpiration = null;
  1597.                         $notes = null;
  1598.                         $t = $em->getRepository("App\Entity\Slave\Ticket")->findOneById($id);
  1599.                         $status = $t->displayStatus('text', $settingProcessedActive->getValue());
  1600.                         $number = $t->getNumber();
  1601.                         $termid = $t->getTermid()->__toString();
  1602.                         if($company->isTagTicketActive()) $tags = $t->displayTags('string');
  1603.                         $client = $t->getClient()->__toString();
  1604.                         if($t->getOperation() !== null){
  1605.                             $operation = $t->getOperation()->getValue();
  1606.                             $key = $t->getOperation()->getKeyValueByValue('Dettagli operazione');
  1607.                             if($key && $t->displayJsonValueByColumn($key) !== null)
  1608.                                 $operation .= ' (' . $t->displayJsonValueByColumn($key) . ')';
  1609.                         }
  1610.                         else $operation = 'Operazione non riconosciuta';
  1611.                         if($t->getSupplier() !== null){
  1612.                             $supplier = $t->getSupplier()->__toString();
  1613.                             $slot = $t->displayJsonValueByColumn('SLOT');
  1614.                             if($slot !== null && $slot !== '')
  1615.                                 $supplier .= ' ('.$slot.')';
  1616.                         }
  1617.                         else $supplier = 'Fornitore non riconosciuto';
  1618.                         if($t->getOperationTariffAmount() !== null) $tariff = $t->getOperationTariffAmount()->getValue();
  1619.                         if($t->getIdCity() !== null){
  1620.                             $cityEntity = $emMaster->getRepository('App\Entity\Master\City')->findOneById($t->getIdCity());
  1621.                             $city = $cityEntity->getName().' ('.$t->getAddress().')';
  1622.                         }
  1623.                         if($t->getIdProvince() !== null){   
  1624.                             $provinceEntity = $emMaster->getRepository('App\Entity\Master\Province')->findOneById($t->getIdProvince());
  1625.                             $province = $provinceEntity->getSign();
  1626.                         }
  1627.                         if($t->getStatus()->getSlug() !== 'to_assign') $technician = $t->getTechnician();
  1628.                         $datetimeStart = $t->getDatetimeStart() !== null ? $t->getDatetimeStart()->format('d-m-Y H:i') : '---';
  1629.                         if($t->getStatus()->getSlug() !== 'closed' && $t->getStatus()->getSlug() !== 'closed_portal') $datetimeExpiration = $t->getDatetimeExpiration() !== null ? $t->getDatetimeExpiration()->format('d-m-Y H:i') : '---'; else $datetimeExpiration = $t->getDatetimeEnd() !== null ? $t->getDatetimeEnd()->format('d-m-Y H:i') : '---';
  1630.                         $notes = $t->getNotes();
  1631.                         if($company->isTagTicketActive())
  1632.                             fputcsv($handle, array($status, $number, $termid, $tags, $client, $operation, $supplier, $tariff, $city, $province, $technician, $datetimeStart, $datetimeExpiration, $notes), ";", '"', "\\");
  1633.                         else
  1634.                             fputcsv($handle, array($status, $number, $termid, $client, $operation, $supplier, $tariff, $city, $province, $technician, $datetimeStart, $datetimeExpiration, $notes), ";", '"', "\\");
  1635.                     }
  1636.                     fclose($handle);
  1637.                 });
  1638.                 
  1639.                 $response->setStatusCode(200);
  1640.                 $dispositionHeader = $response->headers->makeDisposition(ResponseHeaderBag::DISPOSITION_ATTACHMENT, 'Ticket selezionati.csv');
  1641.                 $response->headers->set('Content-Type', 'text/csv; charset=ISO-8859-15');
  1642.                 $response->headers->set('Content-Disposition', $dispositionHeader);
  1643.                 return $response;
  1644.             }
  1645.         //
  1646.         
  1647.         // SINGOLE
  1648.             /**
  1649.              * @Route("/invia-email-prendi-in-carico", name="user_ticket_send_email_take_charge")
  1650.              * @Security("is_granted('edit', 'ticket')")
  1651.              */
  1652.             public function userTicketSendEmailTakeCharge(Request $request, MailerInterface $mailer)
  1653.             {    
  1654.                 $em = $this->mr->getManager('slave');
  1655.                 $emMaster = $this->mr->getManager('master');
  1656.                 $session = $request->getSession();
  1657.                 $company = $emMaster->getRepository('App\Entity\Master\Company')->findOneById($session->get('companyId'));
  1658.                 $now = new \Datetime();
  1659.                 $users = array();
  1660.                 $technicians = $em->getRepository("App\Entity\Slave\User")->findTechniciansActive();
  1661.                 $settingSunday = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'script_sunday_active'));
  1663.                 if($settingSunday->getValue() == 1 || ($settingSunday->getValue() == 0 && $today->format('N') != 7)){
  1664.                     foreach($technicians as $t){
  1665.                         $onHoliday = false;
  1666.                         foreach($t->getHolidays() as $h){
  1667.                             if($now->format('Ymd') >= $h->getDateFrom()->format('Ymd') && $now->format('Ymd') <= $h->getDateTo()->format('Ymd')){
  1668.                                 $onHoliday = true;
  1669.                                 break;
  1670.                             }
  1671.                         }
  1672.                         if(!$onHoliday){
  1673.                             $tickets = $em->getRepository('App\Entity\Slave\Ticket')->findByUserAndStatus($t->getId(), 'assigned');
  1674.                             if(sizeof($tickets) > 0)
  1675.                                 array_push($users, array($t, $tickets));
  1676.                         }
  1677.                     }
  1678.                     
  1679.                     foreach($users as $u){
  1680.                         $message = (new TemplatedEmail())
  1681.                             ->subject($this->params->get('subject_ticket_take_charge'))
  1682.                             ->from($this->params->get('email_noreply'))
  1683.                             ->to($u[0]->getEmail())
  1684.                             ->htmlTemplate('email/technician/tickets_assigned.html.twig')
  1685.                             ->context(['user' => $u[0], 'tickets' => $u[1]]);
  1686.                         $mailer->send($message);
  1687.                     }
  1689.                     $message = (new TemplatedEmail())
  1690.                         ->subject($this->params->get('subject_event_clicked'))
  1691.                         ->from($this->params->get('email_noreply'))
  1692.                         ->to($this->params->get('email_domini'))
  1693.                         ->htmlTemplate('email/event_clicked.html.twig')
  1694.                         ->context(['user' => $this->getUser(), 'company' => $company, 'event' => 'Invia email prendi in carico']);
  1695.                     $mailer->send($message);
  1696.                     
  1697.                     $this->addFlash('notice_success', 'Notifiche email inviate!');
  1698.                 }
  1699.                 else{
  1700.                     $this->addFlash('notice_warning', 'Notifiche disabilitate la Domenica! Attivale dalle impostazioni');
  1701.                 }
  1703.                 return $this->redirect($request->server->get('HTTP_REFERER'));
  1704.             }
  1705.         
  1706.             /**
  1707.              * @Route("/prendi-in-carico", name="user_ticket_take_charge")
  1708.              * @Security("is_granted('edit', 'ticket')")
  1709.              */
  1710.             public function userTicketTakeCharge(Request $request)
  1711.             {    
  1712.                 $em = $this->mr->getManager('slave');
  1713.                 $session = $request->getSession();
  1714.                 $tickets = $em->getRepository('App\Entity\Slave\Ticket')->findByUserAndStatus($this->getUser()->getId(), 'assigned');
  1716.                 $statusTakenCharge = $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBySlug('taken_charge');
  1717.                 foreach($tickets as $ticket){
  1718.                     TicketService::createTicketLog($em, $this->getUser(), $ticket, "cs", $ticket->getStatus(), $statusTakenCharge->getValue());
  1719.                     $ticket->setStatus($statusTakenCharge);
  1720.                 }
  1721.                 $em->flush();
  1723.                 $this->addFlash('notice_success', 'Stato aggiornato!');
  1724.                 return $this->redirect($request->server->get('HTTP_REFERER'));
  1725.             }
  1726.         //
  1727.     //
  1728.     
  1729.     // AGGIUNGI MANUALMENTE
  1730.         /**
  1731.          * @Route("/nuovo", name="user_ticket_new")
  1732.          * @Security("is_granted('view', 'ticket')")
  1733.          */
  1734.         public function userTicketNew(Request $request, ValidatorInterface $validator, FormFactoryInterface $formFactory)
  1735.         {    
  1736.             $em = $this->mr->getManager('slave');
  1737.             $emMaster = $this->mr->getManager('master');
  1738.             $session = $request->getSession();
  1739.             $company = $emMaster->getRepository('App\Entity\Master\Company')->findOneById($session->get('companyId'));
  1740.             $cities = $emMaster->getRepository("App\Entity\Master\City")->findByName('');
  1741.             $today = new \DateTime();
  1743.             $ticket = new Ticket();
  1744.             $form = $formFactory->createNamed("form_ticket_new", TicketType::class, $ticket);
  1745.             $form->handleRequest($request);
  1747.             if($form->isSubmitted()){
  1749.                 $valid = true;
  1750.                 if($form->get("termidsCode")->getData() == null){
  1751.                     $valid = false;
  1752.                     $form->get("termidsCode")->addError(new FormError("Campo obbligatorio"));
  1753.                 }
  1754.                 if($valid){
  1755.                     $termids = explode(',', $form->get("termidsCode")->getData());
  1756.                     foreach($termids as $termid){
  1757.                         $alreadyExist = $em->getRepository('App\Entity\Slave\Ticket')->findOneByNumberAndTermid($ticket->getNumber(), $termid);
  1758.                         if($alreadyExist){
  1759.                             $valid = false;
  1760.                             $form->get("number")->addError(new FormError("Esiste già un ticket con questo numero e con uno di questi termid!"));
  1761.                             $form->get("termidsCode")->addError(new FormError("Esiste già un ticket con questo numero e con uno di questi termid!"));
  1762.                             break;
  1763.                         }
  1764.                     }
  1765.                 }
  1766.                 
  1767.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get("datetimeStart_date"));
  1768.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get("datetimeStart_hour"));
  1769.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get("datetimeStart_minute"));
  1770.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get("datetimeExpiration_date"));
  1771.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get("datetimeExpiration_hour"));
  1772.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get("datetimeExpiration_minute"));
  1773.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get("anomaly"));
  1775.                 if($form->get('cityId')->getData() == null && $form->get("otherCity")->getData() == null){
  1776.                     $valid = false;
  1777.                     $form->get("cityName")->addError(new FormError("Campo obbligatorio"));
  1778.                 }
  1780.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get("clientCode"));
  1781.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get("clientName"));
  1782.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get("clientNickname"));
  1783.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get("clientAddress"));
  1784.                 if($form->get('client_cityId')->getData() == null){
  1785.                     $valid = false;
  1786.                     $form->get("client_cityName")->addError(new FormError("Campo obbligatorio"));
  1787.                 }
  1788.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get("client_zip"));
  1790.                 $zip = $emMaster->getRepository('App\Entity\Master\Zip')->findOneById($form->get('zip')->getData());
  1791.                 if($zip == null){
  1792.                     $zip = $emMaster->getRepository('App\Entity\Master\Zip')->findOneByCode($request->request->get('other_zip'));
  1793.                     if($zip == null){
  1794.                         $form->get('zip')->addError(new FormError('CAP inesistente! Controlla il valore inserito!'));
  1795.                         $valid = false;
  1796.                     }
  1797.                 }
  1798.                 
  1799.                 if($valid && $form->isValid()){
  1800.                     
  1801.                     $jsonReport = '[{"ABI":'.json_encode($form->get('abi')->getData()).'},{"Anomalia":'.json_encode($form->get('anomaly')->getData()).'}]';
  1802.                     $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());
  1803.                     $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());
  1805.                     // Client
  1806.                     $client = $em->getRepository('App\Entity\Slave\Client')->findOneById($form->get('clientId')->getData());
  1807.                     if($client == null){
  1808.                         $client = new Client();
  1809.                         $client->setDirectoryPath(md5(uniqid()));
  1810.                         $em->persist($client);
  1811.             
  1812.                         $warehouse = new Warehouse();
  1813.                         $warehouse->setClient($client);
  1814.                         $warehouse->setMovable(false);
  1815.                         $warehouse->setNickname('Magazzino cliente - '.$client->getNickname());
  1816.                         $client->setWarehouse($warehouse);
  1817.                         $em->persist($warehouse);
  1818.                         $em->flush();
  1820.                         $clientPhone = new ClientPhone();
  1821.                         $clientPhone->setClient($client);
  1822.                         $clientPhone->setName('Telefono 1');
  1823.                         $em->persist($clientPhone);
  1824.                     }
  1825.                     else{
  1826.                         foreach($client->getPhones() as $phone){
  1827.                             if($phone->getName() == 'Telefono 1'){
  1828.                                 $clientPhone = $phone;
  1829.                                 break;
  1830.                             }
  1831.                         }
  1832.                     }
  1834.                     $clientCity = $emMaster->getRepository('App\Entity\Master\City')->findOneById($form->get('client_cityId')->getData());
  1835.                     $clientZip = $emMaster->getRepository('App\Entity\Master\Zip')->findOneById($form->get('client_zip')->getData());
  1836.                     $client->setCode($form->get('clientCode')->getData());
  1837.                     $client->setName($form->get('clientName')->getData());
  1838.                     $client->setNickname($form->get('clientNickname')->getData());
  1839.                     $client->setReferent($form->get('clientReferent')->getData());
  1840.                     $client->setFiscalCode($form->get('clientFiscalCode')->getData());
  1841.                     $client->setVat($form->get('clientVat')->getData());
  1842.                     $client->setSdi($form->get('clientSdi')->getData());
  1843.                     $client->setClosures($form->get('clientClosures')->getData());
  1844.                     $client->setOpenings($form->get('clientOpenings')->getData());
  1845.                     $client->setAddress($form->get('address')->getData());
  1846.                     $client->setLocality($form->get('locality')->getData());
  1847.                     $client->setIdCity($clientCity->getId());
  1848.                     $client->setZip($clientZip->getCode());
  1849.                     $client->setIdProvince($clientCity->getProvince()->getId());
  1850.                     $client->setNotes($form->get('clientNotes')->getData());
  1851.                     $clientPhone->setNumber($form->get('clientPhone')->getData());
  1852.     
  1853.                     // Termid
  1854.                     $termids = explode(',', $form->get("termidsCode")->getData());
  1855.                     foreach($termids as $termidCode){
  1857.                         if($form->get('cityId')->getData() != null)
  1858.                             $city = $emMaster->getRepository('App\Entity\Master\City')->findOneById($form->get('cityId')->getData());
  1859.                         
  1860.                         $zip = $emMaster->getRepository('App\Entity\Master\Zip')->findOneById($form->get('zip')->getData());
  1861.                         $assignStatus = $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBySlug('to_assign');
  1863.                         $ticket = new Ticket();
  1864.                         $ticket->setNumber($form->get('number')->getData());
  1865.                         $ticket->setAddress($form->get('address')->getData());
  1866.                         $ticket->setLocality($form->get('locality')->getData());
  1867.                         $ticket->setSupplier($form->get('supplier')->getData());
  1868.                         $ticket->setOperation($form->get('operation')->getData());
  1869.                         $ticket->setZip($zip->getCode());
  1870.                         if($city != null){
  1871.                             $ticket->setIdCity($city->getId());
  1872.                             $ticket->setIdProvince($city->getProvince()->getId());
  1873.                             $ticket->setOtherCity(null);
  1874.                         }
  1875.                         else{
  1876.                             $ticket->setOtherCity($form->get('otherCity')->getData());
  1877.                             $ticket->setIdProvince($zip->getCities()[0]->getProvince()->getId());
  1878.                         }
  1879.                         $ticket->setStatus($assignStatus);
  1880.                         $ticket->setDirectoryPath($today->format("Y").'/'.$today->format("m").'/'.md5(uniqid()));
  1881.                         $ticket->setDatetimeImport(new \DateTime());
  1882.                         $ticket->setClosedOnPortal(false);
  1883.                         $ticket->setSystemError(false);
  1884.                         $ticket->setJson('[{}]');
  1885.                         $ticket->setJsonReport($jsonReport);
  1886.                         $ticket->setDatetimeStart($datetimeStart);
  1887.                         $ticket->setDatetimeExpiration($datetimeExpiration);                        
  1888.                         $ticket->setClient($client);
  1889.                         $em->persist($ticket);
  1891.                         $termid = $em->getRepository('App\Entity\Slave\Termid')->findOneByCode($termidCode);
  1892.                         if($termid == null){
  1893.                             $termid = new Termid();
  1894.                             $termid->setClient($client);
  1895.                             $termid->setCode($termidCode);
  1896.                             $em->persist($termid);
  1897.                             $em->flush();
  1898.                         }
  1899.                         $ticket->setTermid($termid);
  1900.                         $em->persist($ticket);
  1901.                         $em->flush();
  1902.                         TicketService::createTicketLog($em, $this->getUser(), $ticket, "cs", null, $assignStatus->getValue());
  1903.                         $error = TicketService::ticketAssignOperationTariffAmount($em, $emMaster, $ticket);
  1904.                     }
  1905.                     $em->flush();
  1907.                     $this->addFlash('notice_success', "Ticket inserito!");
  1908.                     return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  1909.                 }
  1910.             }
  1912.             return $this->render('role/user/ticket/new.html.twig', array(
  1913.                 'company' => $company,
  1914.                 'cities' => $cities,
  1915.                 'form' => $form->createView()
  1916.             ));
  1917.         }
  1918.     //
  1919.         
  1920.     /**
  1921.      * @Route("/{ticketId}/scheda", name="user_ticket_sheet")
  1922.      * @Security("is_granted('ticket_view', ticketId)")
  1923.      */
  1924.     public function userTicketSheet($ticketId, Request $request, ValidatorInterface $validator, FormFactoryInterface $formFactory, FileSystem $fs, UserPasswordHasherInterface $passwordHasher, MailerInterface $mailer)
  1925.     {    
  1926.         $em = $this->mr->getManager('slave');
  1927.         $emMaster = $this->mr->getManager('master');
  1928.         $session = $request->getSession();
  1929.         $company = $emMaster->getRepository('App\Entity\Master\Company')->findOneById($session->get('companyId'));
  1930.         $settingBackOffice = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'ticket_backoffice_manage'));
  1931.         $settingTechUnlockSuspension = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'ticket_suspension_unlock_by_technician'));
  1932.         $settingProcessedActive = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'ticket_processed_active'));
  1933.         $settingTechnicianExchangeTickets = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'technician_exchange_tickets'));
  1934.         $cities = $emMaster->getRepository("App\Entity\Master\City")->findByName('');
  1936.         $ticket = $em->getRepository("App\Entity\Slave\Ticket")->findOneById($ticketId);
  1937.         $displayJsonReport = '';
  1938.         if($ticket->getJsonReport() != '[]'){
  1939.             $matrix = json_decode($ticket->getJsonReport(), true);
  1940.             foreach($matrix as $array)
  1941.                 foreach($array as $a){
  1942.                     $tcv = $em->getRepository('App\Entity\Slave\TicketColumnValue')->findOneBySupplierTicketColumnAndNeedle($ticket->getSupplier()->getId(), array_keys($array)[0], $a);
  1943.                     $htmlToAdd = '';
  1944.                     if($tcv != null)
  1945.                         $htmlToAdd = ' <i>('.$tcv->getValue().')</i>';
  1946.                     $displayJsonReport.= '<tr><th>'.array_keys($array)[0].'</th><td colspan="2">'.$a.$htmlToAdd.'</td></tr>';
  1947.                 }
  1948.         }
  1950.         // TICKET - MODIFICA INDIRIZZO
  1951.         $formAddressEdit = $formFactory->createNamed("form_address", TicketAddressType::class, $ticket);
  1952.         $formAddressEdit->handleRequest($request);
  1954.         if($formAddressEdit->isSubmitted()){
  1955.             $valid = true;
  1956.             $zip = $emMaster->getRepository('App\Entity\Master\Zip')->findOneById($formAddressEdit->get('zip')->getData());
  1957.             if($zip == null){
  1958.                 $zip = $emMaster->getRepository('App\Entity\Master\Zip')->findOneByCode($request->request->get('other_zip'));
  1959.                 if($zip == null){
  1960.                     $formAddressEdit->get('zip')->addError(new FormError('CAP inesistente! Controlla il valore inserito!'));
  1961.                     $valid = false;
  1962.                 }
  1963.             }
  1965.             if($valid && $formAddressEdit->isValid()){
  1967.                 if($formAddressEdit->get('cityId')->getData() != null)
  1968.                     $city = $emMaster->getRepository('App\Entity\Master\City')->findOneById($formAddressEdit->get('cityId')->getData());
  1970.                 $ticket->setZip($zip->getCode());
  1971.                 if($city != null){
  1972.                     $ticket->setIdCity($city->getId());
  1973.                     $ticket->setIdProvince($city->getProvince()->getId());
  1974.                     $ticket->setOtherCity(null);
  1975.                 }
  1976.                 else{
  1977.                     $ticket->setOtherCity($formAddressEdit->get('otherCity')->getData());
  1978.                     $ticket->setIdProvince($zip->getCities()[0]->getProvince()->getId());
  1979.                 }
  1980.                 // SE SCELTO AGGIORNA CLIENTE
  1981.                 if($formAddressEdit->get('updateClient')->getData()){
  1982.                     $ticket->getClient()->setAddress($formAddressEdit->get('address')->getData());
  1983.                     $ticket->getClient()->setZip($zip->getCode());
  1984.                     $ticket->getClient()->setLocality($formAddressEdit->get('locality')->getData());
  1985.                     if($city != null){
  1986.                         $ticket->getClient()->setIdCity($city->getId());
  1987.                         $ticket->getClient()->setIdProvince($city->getProvince()->getId());
  1988.                     }
  1989.                     else{
  1990.                         $ticket->getClient()->setOtherCity($formAddressEdit->get('otherCity')->getData());
  1991.                         $ticket->getClient()->setIdProvince($zip->getCities()[0]->getProvince()->getId());
  1992.                     }
  1993.                 }
  1994.                 
  1995.                 $error = TicketService::ticketAssignOperationTariffAmount($em, $emMaster, $ticket);
  1996.                 if($error){
  1997.                     $this->addFlash('notice_warning', "Nessuna tariffa trovata per questo indirizzo!");
  1998.                     return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  1999.                 }
  2000.                 $em->flush();
  2002.                 $this->addFlash('notice_success', "Indirizzo ticket aggiornato!");
  2003.                 return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2004.             }
  2005.             else{
  2006.                 $session->set('openModalAddressEdit', true);
  2007.             }
  2008.         }
  2010.         // TICKET - CLIENTE - MODIFICA 
  2011.         $numOfPhones = 0;
  2012.         if($ticket->getClient() != null)
  2013.             $numOfPhones = sizeof($ticket->getClient()->getPhones());
  2014.         $formClientEdit = $formFactory->createNamed("form_client_edit", ClientEditType::class, $ticket->getClient(), array('phoneNumber' => $numOfPhones));
  2015.         $formClientEdit->handleRequest($request);
  2017.         if($formClientEdit->isSubmitted()){
  2018.             if($formClientEdit->isValid()){
  2019.                 
  2020.                 foreach($ticket->getClient()->getPhones() as $phone){
  2021.                     if($phone->getName() == 'Telefono 1') $phone->setNumber($formClientEdit->get('phone1')->getData());
  2022.                     if(sizeof($ticket->getClient()->getPhones()) > 1 && $phone->getName() == 'Telefono 2') $phone->setNumber($formClientEdit->get('phone2')->getData());
  2023.                     if(sizeof($ticket->getClient()->getPhones()) > 2 && $phone->getName() == 'Telefono cellulare') $phone->setNumber($formClientEdit->get('phone3')->getData());
  2024.                 }
  2026.                 if(sizeof($ticket->getClient()->getPhones()) == 0){
  2027.                     $clientPhone = new ClientPhone();
  2028.                     $clientPhone->setClient($ticket->getClient());
  2029.                     $clientPhone->setName('Telefono 1');
  2030.                     $clientPhone->setNumber('');
  2031.                     $em->persist($clientPhone);
  2032.                 }
  2034.                 $em->flush();
  2035.                 $this->addFlash('notice_success', "Dati aggiornati");
  2036.                 return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2037.             }
  2038.             else{
  2039.                 $session->set('openEditModal', true);
  2040.                 $session->set('openEditModalId', $request->request->get('clientNotesEditId'));
  2041.             }
  2042.         }
  2043.     
  2044.         // TICKET - SOSPENSIONE - SBLOCCA
  2045.         $suspension = new TicketSuspension();
  2046.         $formSusUnlock = $formFactory->createNamed("form_suspension_unlock", TicketSuspensionUnlockType::class, $suspension);
  2047.         $formSusUnlock->handleRequest($request);
  2049.         if($formSusUnlock->isSubmitted()){
  2051.             $valid = ValidationService::validateNotBlank($validator, $formSusUnlock->get("unlockCausal"));
  2053.             if($valid && $formSusUnlock->isValid()){
  2054.                 $suspension = $em->getRepository('App\Entity\Slave\TicketSuspension')->findOneById($formSusUnlock->get('id')->getData());
  2055.                 $unlockCausal = $formSusUnlock->get("unlockCausal")->getData();
  2057.                 $suspension->unlock($em, $this->getUser(), $unlockCausal, new \DateTime());
  2058.                 $em->flush();
  2060.                 $this->addFlash('notice_success', "Sospensione sbloccata!");
  2061.                 return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2062.             }
  2063.             else{
  2064.                 $session->set('openModalSuspensionUnlock', true);
  2065.                 $session->set('openModalSuspensionUnlockId', $formSusUnlock->get('id')->getData());
  2066.             }
  2067.         }
  2068.         
  2069.         // TICKET - EXTRA
  2070.         if($this->getUser()->getAccountTypology() == 'agency' || $this->getUser()->getAccountTypology() == 'warehouse'){
  2071.             if($company->getCode() == "3RC419" && ($ticket->getSupplier()->getSlug() == 'nexi-book-monetica' || $ticket->getSupplier()->getSlug() == 'nexi-book-meps'))
  2072.                 $choiceTypes = array('Ore' => 'hours', 'Spesa' => 'cost', 'Integrazione tariffa' => 'tariff_extra', 'Tariffa fuori copertura' => 'tariff_out', 'App. Nexi Business' => 'nexi_business', 'Softpos' => 'softpos', 'Installazioni NBD' => 'nbd_installation', 'Release sbagliata' => 'wrong_release', 'Reperibilità domenicale' => 'sunday_on_call');
  2073.             else
  2074.                 $choiceTypes = array('Ore' => 'hours', 'Spesa' => 'cost', 'Integrazione tariffa' => 'tariff_extra', 'Tariffa fuori copertura' => 'tariff_out');
  2075.         }
  2076.         else{
  2077.             if($company->getCode() == "3RC419" && ($ticket->getSupplier()->getSlug() == 'nexi-book-monetica' || $ticket->getSupplier()->getSlug() == 'nexi-book-meps'))
  2078.                 $choiceTypes = array('Ore' => 'hours', 'Spesa' => 'cost', 'Integrazione tariffa' => 'tariff_extra', 'App. Nexi Business' => 'nexi_business', 'Softpos' => 'softpos', 'Installazioni NBD' => 'nbd_installation', 'Release sbagliata' => 'wrong_release');
  2079.             else
  2080.                 $choiceTypes = array('Ore' => 'hours', 'Spesa' => 'cost', 'Integrazione tariffa' => 'tariff_extra');
  2081.         }
  2083.         $uploadDir = $this->params->get('kernel.project_dir').'/'.$this->params->get('web_path').'/companies/'.$company->getDirectoryPath().'/tickets/'.$ticket->getDirectoryPath().'/';
  2084.         $interventionExtra = new InterventionExtra();
  2085.         $formExtraNew = $formFactory->createNamed("form_intervention_extra_new", InterventionExtraType::class, $interventionExtra, array('ticketId' => $ticket->getId(), 'choice_types' => $choiceTypes));
  2086.         $formExtraNew->handleRequest($request);
  2088.         if($formExtraNew->isSubmitted()){
  2090.             $valid = FormValidatorService::validateInterventionExtra($validator, $formExtraNew, false, $this->getUser());
  2092.             if($valid && $formExtraNew->isValid()){
  2094.                 switch($formExtraNew->get('type')->getData()){
  2095.                     case 'cost':
  2096.                         if($formExtraNew->get('file')->getData()->guessExtension() == 'pdf')
  2097.                             MediaService::uploadDocument($formExtraNew->get('file')->getData(), $uploadDir, $interventionExtra, 'file');
  2098.                         else
  2099.                             MediaService::uploadImage($fs, $formExtraNew->get('file')->getData(), null, $uploadDir, $interventionExtra, 'file', 100, 1000, 200, true);
  2100.                         break;
  2101.                     case 'tariff_out':
  2102.                         $interventionExtra->setTariffOut(true);
  2103.                         break;
  2104.                     case 'nexi_business':
  2105.                         $interventionExtra->setHours(null);
  2106.                         $interventionExtra->setCost(2);
  2107.                         $interventionExtra->setRevenue(4);
  2108.                         $interventionExtra->setTariffOut(false);
  2109.                         break;
  2110.                     case 'softpos':
  2111.                         $interventionExtra->setHours(null);
  2112.                         $interventionExtra->setCost(4);
  2113.                         $interventionExtra->setRevenue(8);
  2114.                         $interventionExtra->setTariffOut(false);
  2115.                         break;
  2116.                     case 'nbd_installation':
  2117.                         $interventionExtra->setHours(null);
  2118.                         $interventionExtra->setCost(5);
  2119.                         $interventionExtra->setRevenue(8);
  2120.                         $interventionExtra->setTariffOut(false);
  2121.                         break;
  2122.                     case 'wrong_release':
  2123.                         $interventionExtra->setHours(null);
  2124.                         $interventionExtra->setCost(-5);
  2125.                         $interventionExtra->setRevenue(-5);
  2126.                         $interventionExtra->setTariffOut(false);
  2127.                         break;
  2128.                     case 'sunday_on_call':
  2129.                         $interventionExtra->setHours(null);
  2130.                         $interventionExtra->setCost(70);
  2131.                         $interventionExtra->setRevenue(120);
  2132.                         $interventionExtra->setTariffOut(false);
  2133.                         break;
  2134.                     default: break;
  2135.                 }
  2136.                 
  2137.                 if($this->getUser()->getAccountTypology() == 'agency' || $this->getUser()->getAccountTypology() == 'warehouse'){
  2138.                     $interventionExtra->setManaged(true);
  2139.                     $interventionExtra->setApproved(true);
  2140.                 }
  2141.                 else{
  2142.                     $interventionExtra->setManaged(false);
  2143.                     $interventionExtra->setApproved(null);
  2144.                 }
  2145.                 $em->persist($interventionExtra);
  2146.                 $em->flush();
  2148.                 $this->addFlash('notice_success', "Nuovo extra inserito!");
  2149.                 return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2150.             }
  2151.             else{
  2152.                 $session->set('openModalExtraNew', true);
  2153.             }
  2154.         }
  2155.         
  2156.         $formExtraEdit = $formFactory->createNamed("form_intervention_extra_edit", InterventionExtraType::class, $interventionExtra, array('ticketId' => $ticket->getId(), 'choice_types' => $choiceTypes));
  2157.         $formExtraEdit->handleRequest($request);
  2159.         if($formExtraEdit->isSubmitted()){
  2161.             $valid = FormValidatorService::validateInterventionExtra($validator, $formExtraEdit, true, $this->getUser());
  2162.             if($valid && $formExtraEdit->isValid()){
  2164.                 $interventionExtraEdit = $em->getRepository('App\Entity\Slave\InterventionExtra')->findOneById($request->request->get('extraEditId'));
  2165.                 $oldFilePath = $interventionExtraEdit->getFilePath();
  2167.                 $interventionExtraEdit->setIntervention($formExtraEdit->get('intervention')->getData());
  2168.                 $interventionExtraEdit->setType($formExtraEdit->get('type')->getData());
  2169.                 $interventionExtraEdit->setNotes($formExtraEdit->get('notes')->getData());
  2170.                 switch($formExtraEdit->get('type')->getData()){
  2171.                     case 'cost':
  2172.                         $interventionExtraEdit->setTariffOut(false);
  2173.                         $interventionExtraEdit->setCost($formExtraEdit->get('cost')->getData());
  2174.                         if($formExtraEdit->get('file')->getData() != null){
  2175.                             // METTO IL NUOVO
  2176.                             if($formExtraEdit->get('file')->getData()->guessExtension() == 'pdf')
  2177.                                 MediaService::uploadDocument($formExtraEdit->get('file')->getData(), $uploadDir, $interventionExtra, 'file');
  2178.                             else
  2179.                                 MediaService::uploadImage($fs, $formExtraEdit->get('file')->getData(), null, $uploadDir, $interventionExtraEdit, 'file', 100, 1000, 200, true);
  2181.                             // RIMUOVO IL VECCHIO FILE
  2182.                             if(str_contains($oldFilePath, '.pdf'))
  2183.                                 MediaService::removeDocument($fs, $oldFilePath, $uploadDir);
  2184.                             else
  2185.                                 MediaService::removeImage($fs, $oldFilePath, $uploadDir);
  2186.                         }
  2187.                         break;
  2188.                     case 'hours':
  2189.                         $interventionExtraEdit->setTariffOut(false);
  2190.                         $interventionExtraEdit->setCost($formExtraEdit->get('cost')->getData());
  2191.                         $interventionExtraEdit->setHours($formExtraEdit->get('hours')->getData());
  2192.                         break;
  2193.                     case 'tariff_extra':
  2194.                         $interventionExtraEdit->setHours(null);
  2195.                         $interventionExtraEdit->setCost($formExtraEdit->get('cost')->getData());
  2196.                         $interventionExtraEdit->setTariffOut(false);
  2197.                         break;
  2198.                     case 'tariff_out':
  2199.                         $interventionExtraEdit->setHours(null);
  2200.                         $interventionExtraEdit->setCost($formExtraEdit->get('cost')->getData());
  2201.                         $interventionExtraEdit->setTariffOut(true);
  2202.                         break;
  2203.                     case 'nexi_business':
  2204.                         $interventionExtraEdit->setHours(null);
  2205.                         $interventionExtraEdit->setCost(2);
  2206.                         $interventionExtraEdit->setRevenue(4);
  2207.                         $interventionExtraEdit->setTariffOut(false);
  2208.                         break;
  2210.                     case 'softpos':
  2211.                         $interventionExtraEdit->setHours(null);
  2212.                         $interventionExtraEdit->setCost(4);
  2213.                         $interventionExtraEdit->setRevenue(8);
  2214.                         $interventionExtraEdit->setTariffOut(false);
  2215.                         break;
  2217.                     case 'nbd_installation':
  2218.                         $interventionExtraEdit->setHours(null);
  2219.                         $interventionExtraEdit->setCost(5);
  2220.                         $interventionExtraEdit->setRevenue(8);
  2221.                         $interventionExtraEdit->setTariffOut(false);
  2222.                         break;
  2224.                     case 'wrong_release':
  2225.                         $interventionExtra->setHours(null);
  2226.                         $interventionExtra->setCost(-5);
  2227.                         $interventionExtra->setRevenue(-5);
  2228.                         $interventionExtra->setTariffOut(false);
  2229.                         break;
  2230.                     case 'sunday_on_call':
  2231.                         $interventionExtra->setHours(null);
  2232.                         $interventionExtra->setCost(70);
  2233.                         $interventionExtra->setRevenue(120);
  2234.                         $interventionExtra->setTariffOut(false);
  2235.                         break;
  2236.                     default: break;
  2237.                 }
  2238.                 $em->flush();
  2240.                 $this->addFlash('notice_success', "Modifiche salvate!");
  2241.                 return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2242.             }
  2243.             else{
  2244.                 $session->set('openModalExtraEdit', true);
  2245.                 $session->set('openModalExtraEditId', $request->request->get('extraEditId'));
  2246.             }
  2247.         }
  2248.         
  2249.         // TICKET - REMINDER
  2250.         $ticketReminder = new TicketReminder();
  2251.         $formReminderNew = $formFactory->createNamed("form_reminder_new", TicketReminderType::class, $ticketReminder);
  2252.         $formReminderNew->handleRequest($request);
  2254.         if($formReminderNew->isSubmitted()){
  2256.             $valid = true;
  2257.             if($valid) $valid = ValidationService::validateNotBlank($validator, $formReminderNew->get("date"));
  2258.             if($valid) $valid = ValidationService::validateNotBlank($validator, $formReminderNew->get("hour"));
  2259.             if($valid) $valid = ValidationService::validateNotBlank($validator, $formReminderNew->get("minute"));
  2261.             if($valid && $formReminderNew->isValid()){
  2262.                 
  2263.                 $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());
  2264.                 $ticketReminder->setDatetime($datetime);
  2265.                 $ticketReminder->setTicket($ticket);
  2266.                 $ticketReminder->setTechnician($this->getUser());
  2267.                 $em->persist($ticketReminder);
  2268.                 $em->flush();
  2270.                 $this->addFlash('notice_success', "Reminder ticket inserito!");
  2271.                 return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2272.             }
  2273.             else{
  2274.                 $session->set('openModalReminderNew', true);
  2275.             }
  2276.         }
  2277.         
  2278.         $formReminderEdit = $formFactory->createNamed("form_reminder_edit", TicketReminderType::class, $ticketReminder);
  2279.         $formReminderEdit->handleRequest($request);
  2281.         if($formReminderEdit->isSubmitted()){
  2283.             $valid = true;
  2284.             if($valid) $valid = ValidationService::validateNotBlank($validator, $formReminderEdit->get("date"));
  2285.             if($valid) $valid = ValidationService::validateNotBlank($validator, $formReminderEdit->get("hour"));
  2286.             if($valid) $valid = ValidationService::validateNotBlank($validator, $formReminderEdit->get("minute"));
  2288.             if($valid && $formReminderEdit->isValid()){
  2289.                 
  2290.                 $reminder = $em->getRepository('App\Entity\Slave\TicketReminder')->findOneById($formReminderEdit->get('id')->getData());
  2291.                 $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());
  2292.                 $reminder->setDatetime($datetime);
  2293.                 $reminder->setDetails($formReminderEdit->get('details')->getData());
  2294.                 $em->flush();
  2296.                 $this->addFlash('notice_success', "Modifiche salvate!");
  2297.                 return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2298.             }
  2299.             else{
  2300.                 $session->set('openModalReminderEdit', true);
  2301.                 $session->set('openModalReminderEditId', $formReminderEdit->get('id')->getData());
  2302.             }
  2303.         }
  2305.         $technicians = array();
  2306.         if($ticket->getZip() != null){
  2307.             $zip = $emMaster->getRepository('App\Entity\Master\Zip')->findOneBy(array('code' => $ticket->getClient()->getZip()));
  2308.             $allTechs = $em->getRepository('App\Entity\Slave\User')->findTechniciansActive();
  2309.             foreach($allTechs as $t){
  2310.                 $supplier = false;
  2311.                 $area = false;
  2313.                 $tmp = array();
  2314.                 $autoAssignSuppliersIds = array();
  2315.                 foreach($t->getAutoAssignSuppliers() as $supplier)
  2316.                     array_push($autoAssignSuppliersIds, $supplier->getId());
  2317.                         
  2318.                 if(in_array($ticket->getOperation()->getSupplier()->getId(), $autoAssignSuppliersIds))
  2319.                     $supplier = true;
  2321.                 foreach($t->getTechnicianAreas() as $ta){
  2323.                     $zips = array();
  2324.                     foreach($ta->getZips() as $arrayZip){
  2325.                         array_push($zips, $arrayZip[1]);
  2326.                     }
  2327.                     if($ticket->getClient()->getIdProvince() == $ta->getIdProvince() && ($ta->isAllZip() || in_array($ticket->getClient()->getZip(), $zips)))
  2328.                         $area = true;
  2329.                 }
  2330.                 
  2331.                 array_push($tmp, $t, $supplier, $area);
  2332.                 array_push($technicians, $tmp);
  2333.             }
  2334.         }
  2336.         if($this->getUser()->getAccountTypology() == 'agency' || $this->getUser()->getAccountTypology() == 'warehouse'){
  2337.             
  2338.             // TICKET - MODIFICA OPERAZIONE
  2339.             $formOperationEdit = $formFactory->createNamed("form_operation", TicketOperationType::class, $ticket, array('supplierId' => $ticket->getSupplier()->getId()));
  2340.             $formOperationEdit->handleRequest($request);
  2342.             if($formOperationEdit->isSubmitted()){
  2344.                 $valid = ValidationService::validateNotBlank($validator, $formOperationEdit->get("operation"));
  2346.                 if($valid && $formOperationEdit->isValid()){
  2347.                    
  2348.                     $error = TicketService::ticketAssignOperationTariffAmount($em, $emMaster, $ticket);
  2349.                     if($error){
  2350.                         $this->addFlash('notice_warning', "Nessuna tariffa trovata per questa operazione!");
  2351.                         return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2352.                     }
  2353.                     $em->flush();
  2355.                     $this->addFlash('notice_success', "Operazione aggiornata!");
  2356.                     return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2357.                 }
  2358.                 else{
  2359.                     $session->set('openModalOperationEdit', true);
  2360.                 }
  2361.             }
  2363.             // TICKET - MODIFICA TARIFFE ASSEGNATA
  2364.             $operationTariffId = null;
  2365.             if($ticket->getOperationTariffAmount() != null)
  2366.                 $operationTariffId = $ticket->getOperationTariffAmount()->getTariff()->getId();
  2367.             else{
  2368.                 foreach($ticket->getOperation()->getTariffs() as $tar){
  2369.                     $zips = array();
  2370.                     foreach($tar->getZips() as $arrayZip)
  2371.                         array_push($zips, $arrayZip[1]);
  2373.                     if($tar->getIdProvince() == $ticket->getIdProvince() && ($tar->isAllZip() || in_array($ticket->getZip(), $zips))){
  2374.                         $operationTariffId = $tar->getId();
  2375.                         break;
  2376.                     }
  2377.                 }
  2378.             }
  2380.             $uavOperationTariffId = null;
  2381.             if($ticket->getUAVOperationTariffAmount() != null)
  2382.                 $uavOperationTariffId = $ticket->getUAVOperationTariffAmount()->getTariff()->getId();
  2383.             else{
  2384.                 foreach($ticket->getSupplier()->getUavOperation()->getTariffs() as $tar){
  2385.                     $zips = array();
  2386.                     foreach($tar->getZips() as $arrayZip)
  2387.                         array_push($zips, $arrayZip[1]);
  2389.                     if($tar->getIdProvince() == $ticket->getIdProvince() && ($tar->isAllZip() || in_array($ticket->getZip(), $zips))){
  2390.                         $uavOperationTariffId = $tar->getId();
  2391.                         break;
  2392.                     }
  2393.                 }
  2394.             }
  2396.             $formOperationTariffAmount = $formFactory->createNamed("form_operation_tariff_amount", TicketOperationTariffAmountType::class, $ticket, array('operationTariffId' => $operationTariffId, 'uavOperationTariffId' => $uavOperationTariffId));
  2397.             $formOperationTariffAmount->handleRequest($request);
  2399.             if($formOperationTariffAmount->isSubmitted()){
  2400.                 $valid = true;
  2401.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $formOperationTariffAmount->get('operationTariffAmount'));
  2402.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $formOperationTariffAmount->get('uavOperationTariffAmount'));
  2403.                 
  2404.                 if($valid && $formOperationTariffAmount->isValid()){
  2405.                     $amountTechnician = "0.00";
  2406.                     $uavAmountTechnician = "0.00";
  2407.                     $ota = $em->getRepository('App\Entity\Slave\OperationTariffAmount')->findOneById($formOperationTariffAmount->get('operationTariffAmount')->getData());
  2408.                     $uavOta = $em->getRepository('App\Entity\Slave\OperationTariffAmount')->findOneById($formOperationTariffAmount->get('uavOperationTariffAmount')->getData());
  2409.                     $ticket->setOperationTariffAmount($ota);
  2410.                     $ticket->setUavOperationTariffAmount($uavOta);
  2412.                     // Cerco i prezzi tecnico delle nuove tariffe
  2413.                     foreach($ota->getTechnicianAreas() as $jttaota){
  2414.                         if($jttaota->getTechnicianArea()->getUser()->getId() == $ticket->getTechnician()->getId()){
  2415.                             $amountTechnician = $jttaota->getAmount();
  2416.                             break;
  2417.                         }
  2418.                     }
  2419.                     foreach($uavOta->getTechnicianAreas() as $uavJttaota){
  2420.                         if($uavJttaota->getTechnicianArea()->getUser()->getId() == $ticket->getTechnician()->getId()){
  2421.                             $uavAmountTechnician = $uavJttaota->getAmount();
  2422.                             break;
  2423.                         }
  2424.                     }
  2426.                     // Aggiorno i prezzi
  2427.                     foreach($ticket->getInterventions() as $i){
  2428.                         switch($i->getOutcomeType()->getSlug()){
  2429.                             case 'completed':
  2430.                                 $i->setAmount($ota->getAmount());
  2431.                                 $i->setAmountTechnician($amountTechnician);
  2432.                                 break;
  2433.                             case 'empty':
  2434.                                 $i->setAmount($uavOta->getAmount());
  2435.                                 $i->setAmountTechnician($uavAmountTechnician);
  2436.                                 break;
  2437.                             default: break;
  2438.                         }
  2439.                     }
  2440.     
  2441.                     $em->flush();
  2442.                     $this->addFlash('notice_success', "Tariffa aggiornata!");
  2443.                     return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2444.                 }
  2445.                 else{
  2446.                     $ticket = $em->getRepository("App\Entity\Slave\Ticket")->findOneById($ticketId);
  2447.                     $session->set('openModalTariff', true);
  2448.                 }
  2449.             }
  2451.             // TICKET - ERRORI - FORNITORE
  2452.             $formErrorSupplier = $formFactory->createNamed("form_error_supplier", TicketErrorSupplierType::class, $ticket);
  2453.             $formErrorSupplier->handleRequest($request);
  2455.             if($formErrorSupplier->isSubmitted()){
  2456.                 
  2457.                 $valid = ValidationService::validateNotBlank($validator, $formErrorSupplier->get("supplier"));
  2459.                 if($valid && $formErrorSupplier->isValid()){
  2461.                     $ticket->setOperation($formErrorSupplier->get("supplier")->getData()->getOperationMaintenance());
  2462.                     $em->flush();
  2464.                     $error = true;
  2465.                     if($ticket->getClient()) $error = TicketService::ticketMapClient($em, $ticket);
  2466.                     if(!$error) $error = TicketService::ticketMapColumns($em, $emMaster, $company, $ticket);
  2467.                     if(!$error) TicketService::ticketAutoAssign($em, $emMaster, $this->getUser(), $ticket, $mailer);
  2468.                     if(!$error){
  2469.                         $ticket->setSystemError(false);
  2470.                         $ticket->setSystemErrorDetails(null);
  2471.                     }
  2472.                     $em->flush();
  2474.                     $this->addFlash('notice_success', "Ticket aggiornato!");
  2475.                     return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2476.                 }
  2477.             }
  2479.             // TICKET - ERRORI - OPERAZIONE
  2480.             $supplierId = 0;
  2481.             if($ticket->getSupplier() != null)
  2482.                 $supplierId = $ticket->getSupplier()->getId();
  2483.             
  2484.             $formErrorOperation = $formFactory->createNamed("form_error_operation", TicketErrorOperationType::class, $ticket, array('supplierId' => $supplierId));
  2485.             $formErrorOperation->handleRequest($request);
  2487.             if($formErrorOperation->isSubmitted()){
  2488.                 
  2489.                 $valid = ValidationService::validateNotBlank($validator, $formErrorOperation->get("operation"));
  2491.                 if($valid && $formErrorOperation->isValid()){
  2493.                     $em->flush();
  2494.                     if($ticket->getClient())
  2495.                         $error = TicketService::ticketMapClient($em, $ticket);
  2496.                     if(!$error) $error = TicketService::ticketMapColumns($em, $emMaster, $company, $ticket);
  2497.                     if(!$error) TicketService::ticketAutoAssign($em, $emMaster, $this->getUser(), $ticket, $mailer);
  2498.                     if(!$error){
  2499.                         $ticket->setSystemError(false);
  2500.                         $ticket->setSystemErrorDetails(null);
  2501.                     }
  2502.                     $em->flush();
  2504.                     $this->addFlash('notice_success', "Ticket aggiornato!");
  2505.                     return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2506.                 }
  2507.             }
  2508.                         
  2509.             // TICKET - ERRORI - CHIAVI COLONNE
  2510.             $formErrorKeyMapping = $formFactory->createNamed("form_operation_keys_mapping", OperationKeysMappingType::class, $ticket->getOperation());
  2511.             $formErrorKeyMapping->handleRequest($request);
  2513.             if($formErrorKeyMapping->isSubmitted()){
  2515.                 $valid = true;
  2516.                 foreach($formErrorKeyMapping->get('keyMappings') as $keyMapping){
  2517.                     if($valid && $keyMapping->get('keyRequired')->getData()) $valid = ValidationService::validateNotBlank($validator, $keyMapping->get('mappingValue'));
  2518.                 }
  2520.                 if($valid && $formErrorKeyMapping->isValid()){
  2522.                     $em->flush();
  2523.                     $operationTickets = $em->getRepository('App\Entity\Slave\Ticket')->findByOperationAndSystemError($ticket->getOperation(), true);
  2524.                     foreach($operationTickets as $ot){
  2525.                         $error = TicketService::ticketMapColumns($em, $emMaster, $company, $ot);
  2526.                         if(!$error) $error = TicketService::ticketAssignOperationTariffAmount($em, $emMaster, $ot);
  2527.                         if(!$error) TicketService::ticketAutoAssign($em, $emMaster, $this->getUser(), $ot, $mailer);
  2528.                         if(!$error){
  2529.                             $ot->setSystemError(false);
  2530.                             $ot->setSystemErrorDetails(null);
  2531.                         }
  2532.                     }
  2533.                     $em->flush();
  2535.                     $this->addFlash('notice_success', "Mappatura campi ticket aggiornata!");
  2536.                     return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2537.                 }
  2538.             }
  2540.             // TICKET - ERRORI - MODIFICA PROVINCIA
  2541.             $formErrorProvince = $formFactory->createNamed("form_error_province", TicketErrorProvinceType::class, $ticket);
  2542.             $formErrorProvince->handleRequest($request);
  2544.             if($formErrorProvince->isSubmitted()){
  2546.                 $valid = ValidationService::validateNotBlank($validator, $formErrorProvince->get('idProvince'));
  2548.                 if($formErrorProvince->isValid() && $valid){
  2550.                     $ticket->setIdProvince($formErrorProvince->get('idProvince')->getData()->getId());
  2551.                     $error = TicketService::ticketAssignOperationTariffAmount($em, $emMaster, $ticket);
  2552.                     if(!$error) TicketService::ticketAutoAssign($em, $emMaster, $this->getUser(), $ticket, $mailer);
  2553.                     if(!$error){
  2554.                         $ticket->setSystemError(false);
  2555.                         $ticket->setSystemErrorSlug(null);
  2556.                     }
  2557.                     $em->flush();
  2559.                     $this->addFlash('notice_success', "Provincia ticket aggiornata!");
  2560.                     return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2561.                 }
  2562.             }
  2564.             // TICKET - ERRORI - MODIFICA INDIRIZZO
  2565.             $formErrorAddress = $formFactory->createNamed("form_error_address", TicketErrorAddressType::class, $ticket);
  2566.             $formErrorAddress->handleRequest($request);
  2568.             if($formErrorAddress->isSubmitted()){
  2570.                 if($formErrorAddress->isValid()){
  2572.                     $city = $emMaster->getRepository('App\Entity\Master\City')->findOneById($formErrorAddress->get('cityId')->getData());
  2573.                     $zip = $emMaster->getRepository('App\Entity\Master\Zip')->findOneById($formErrorAddress->get('zip')->getData());
  2574.                     $ticket->setIdCity($city->getId());
  2575.                     $ticket->setIdProvince($city->getProvince()->getId());
  2576.                     $ticket->setZip($zip->getCode());
  2577.                     $ticket->setSystemError(false);
  2578.                     $ticket->setSystemErrorDetails(null);
  2579.                     
  2580.                     $error = TicketService::ticketAssignOperationTariffAmount($em, $emMaster, $ticket);
  2581.                     if(!$error) TicketService::ticketAutoAssign($em, $emMaster, $this->getUser(), $ticket, $mailer);
  2582.                     if(!$error){
  2583.                         $ticket->setSystemError(false);
  2584.                         $ticket->setSystemErrorSlug(null);
  2585.                     }
  2586.                     $em->flush();
  2588.                     $this->addFlash('notice_success', "Indirizzo ticket aggiornato!");
  2589.                     return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2590.                 }
  2591.             }
  2593.             // TICKET - DATA SCADENZA - MODIFICA
  2594.             $formExpirationDatetimeEdit = $formFactory->createNamed("form_expiration_edit", TicketExpirationEditType::class, $ticket);
  2595.             $formExpirationDatetimeEdit->handleRequest($request);
  2597.             if($formExpirationDatetimeEdit->isSubmitted()){
  2599.                 $valid = true;
  2600.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $formExpirationDatetimeEdit->get("date"));
  2601.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $formExpirationDatetimeEdit->get("timeHour"));
  2602.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $formExpirationDatetimeEdit->get("timeMinute"));
  2604.                 if($valid && $formExpirationDatetimeEdit->isValid()){
  2606.                     $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());
  2607.                     $ticket->setDatetimeExpiration($datetime);
  2608.                     $em->flush();
  2610.                     $this->addFlash('notice_success', "Data scadenza aggiornata!");
  2611.                     return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2612.                 }
  2613.             }
  2614.             
  2615.             // TICKET - LETTERA DI VETTURA - MODIFICA
  2616.             $formWaybillEdit = $formFactory->createNamed("form_waybill_edit", TicketWaybillEditType::class, $ticket);
  2617.             $formWaybillEdit->handleRequest($request);
  2619.             if($formWaybillEdit->isSubmitted()){
  2621.                 if($formWaybillEdit->isValid()){
  2623.                     $em->flush();
  2625.                     $this->addFlash('notice_success', "Lettera di vettura aggiornata!");
  2626.                     return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2627.                 }
  2628.             }
  2630.             // TICKET - NOTE - MODIFICA
  2631.             $formNotesEdit = $formFactory->createNamed("form_notes_edit", TicketNotesEditType::class, $ticket);
  2632.             $formNotesEdit->handleRequest($request);
  2634.             if($formNotesEdit->isSubmitted()){
  2636.                 if($formNotesEdit->isValid()){
  2638.                     $em->flush();
  2640.                     $this->addFlash('notice_success', "Note aggiornate!");
  2641.                     return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2642.                 }
  2643.             }
  2645.             // TICKET - SOSPENSIONE - MODIFICA
  2646.             $formSusEdit = $formFactory->createNamed("form_suspension_edit", TicketSuspensionEditType::class, $suspension);
  2647.             $formSusEdit->handleRequest($request);
  2649.             if($formSusEdit->isSubmitted()){
  2651.                 $valid = true;
  2652.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $formSusEdit->get("dateFrom"));
  2653.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $formSusEdit->get("timeFromHour"));
  2654.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $formSusEdit->get("timeFromMinute"));
  2655.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $formSusEdit->get("dateTo"));
  2656.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $formSusEdit->get("timeToHour"));
  2657.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $formSusEdit->get("timeToMinute"));
  2659.                 if($valid && $formSusEdit->isValid()){
  2661.                     $sus = $em->getRepository('App\Entity\Slave\TicketSuspension')->findOneById($formSusEdit->get('id')->getData());
  2662.                     $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());
  2663.                     $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());
  2664.                     $sus->setDatetimeFrom($datetimeFrom);
  2665.                     $sus->setDatetimeTo($datetimeTo);
  2666.                     $em->flush();
  2668.                     $this->addFlash('notice_success', "Date sospensione aggiornate!");
  2669.                     return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2670.                 }
  2671.             }
  2672.             
  2673.             // TICKET - SOSPENSIONE - APPROVARE/NON APPROVARE
  2674.             $formSusApprove = $formFactory->createNamed("form_suspension_approve", TicketSuspensionApproveType::class, $suspension);
  2675.             $formSusApprove->handleRequest($request);
  2677.             if($formSusApprove->isSubmitted()){
  2679.                 $valid = true;
  2680.                 if($formSusApprove->get("isApproved")->getData() == false) $valid = ValidationService::validateNotBlank($validator, $formSusApprove->get("refuseMotivation"));
  2682.                 if($valid && $formSusApprove->isValid()){
  2684.                     $sus = $em->getRepository('App\Entity\Slave\TicketSuspension')->findOneById($formSusApprove->get('id')->getData());
  2685.                     $sus->setManaged(true);
  2686.                     $sus->setApproved($formSusApprove->get("isApproved")->getData());
  2688.                     if($sus->isApproved()){
  2689.                         $suspendedStatus = $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBySlug('suspended');
  2690.                         TicketService::createTicketLog($em, $this->getUser(), $ticket, "cs", $ticket->getStatus(), $suspendedStatus->getValue());
  2691.                         $ticket->setStatus($suspendedStatus);
  2692.                         if($sus->getIntervention()->getOutcomeType()->getSlug() == 'suspended'){
  2693.                             $subject = $this->params->get('subject_ticket_suspension_approved');
  2694.                             $template = "email/ticket/suspension_approved.html.twig";
  2695.                         }
  2696.                         else{
  2697.                             $subject = $this->params->get('subject_ticket_uav_approved');
  2698.                             $template = "email/ticket/uav_approved.html.twig";
  2699.                         }
  2700.                         $settingUnlockSameTech = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'ticket_suspension_unlock_same_technician'));
  2701.                         if($settingUnlockSameTech->getValue() != 1){
  2702.                             TicketService::createTicketLog($em, $this->getUser(), $ticket, "ct", $ticket->getTechnician(), null);
  2703.                             $ticket->setTechnician(null);
  2704.                         }
  2705.                     }
  2706.                     else{
  2707.                         $assignedStatus = $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBySlug('assigned');
  2708.                         TicketService::createTicketLog($em, $this->getUser(), $ticket, "cs", $ticket->getStatus(), $assignedStatus->getValue());
  2709.                         $ticket->setStatus($assignedStatus);
  2710.                         $sus->setRefuseMotivation($formSusApprove->get("refuseMotivation")->getData());
  2711.                         $sus->setUnlocked(1);
  2712.                         $sus->setDatetimeTo(new \Datetime());
  2713.                         $sus->getIntervention()->setBillable(false);
  2715.                         if($sus->getIntervention()->getOutcomeType()->getSlug() == 'suspended'){
  2716.                             $subject = $this->params->get('subject_ticket_suspension_not_approved');
  2717.                             $template = "email/ticket/suspension_not_approved.html.twig";
  2718.                         }
  2719.                         else{
  2720.                             $subject = $this->params->get('subject_ticket_uav_not_approved');
  2721.                             $template = "email/ticket/uav_not_approved.html.twig";
  2722.                         }
  2723.                     }
  2724.                     $em->flush();
  2725.                     
  2726.                     $message = (new TemplatedEmail())
  2727.                         ->subject($subject.' '.$ticket->getNumber())
  2728.                         ->from($this->params->get('email_noreply'))
  2729.                         ->to($sus->getIntervention()->getTechnician()->getEmail())
  2730.                         ->htmlTemplate($template)
  2731.                         ->context(['company' => $company, 'ticket' => $ticket, 'suspension' => $sus]);
  2732.                     $mailer->send($message);
  2734.                     $this->addFlash('notice_success', "Stato sospensione aggiornato!");
  2735.                     return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2736.                 }
  2737.                 else{                    
  2738.                     $session->set('openModalSuspensionApprove', true);
  2739.                     $session->set('openModalSuspensionApproveId', $formSusApprove->get('id')->getData());
  2740.                     $session->set('openModalSuspensionApproveIs', $formSusApprove->get('isApproved')->getData());
  2741.                 }
  2742.             }
  2743.                         
  2744.             // INTERVENTO - MODIFICA % FUORI SLA E MESE DI FATTURAZIONE
  2745.             $intervention = new Intervention();
  2746.             $formInterventionSla = $formFactory->createNamed("form_intervention_sla", InterventionSlaType::class, $intervention);
  2747.             $formInterventionSla->handleRequest($request);
  2749.             if($formInterventionSla->isSubmitted()){
  2751.                 if($formInterventionSla->isValid()){
  2753.                     $editIntervention = $em->getRepository('App\Entity\Slave\Intervention')->findOneById($formInterventionSla->get('id')->getData());
  2754.                     if($formInterventionSla->get('slaOutboundPercentage')->getData() != null)
  2755.                         $editIntervention->setSlaOutboundPercentage($formInterventionSla->get('slaOutboundPercentage')->getData());
  2756.                     
  2757.                     $datetimeBilling = date_create_from_format('d-m-Y H:i:s', $formInterventionSla->get('dateBilling')->getData()->format('d-m-Y').' 00:00:00');
  2758.                     $editIntervention->setDatetimeBilling($datetimeBilling);
  2759.                     
  2760.                     $em->flush();
  2761.                     $this->addFlash('notice_success', "Dati aggiornati!");
  2762.                     return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2763.                 }
  2764.                 else{
  2765.                     $session->set('openModalInterventionSla', true);
  2766.                     $session->set('openModalInterventionSlaId', $formInterventionSla->get('id')->getData());
  2767.                 }
  2768.             }
  2770.             // TICKET - ELIMINA
  2771.             $formDelete = $formFactory->createNamed("form_ticket_delete", TicketDeleteType::class, $ticket);
  2772.             $formDelete->handleRequest($request);
  2774.             if($formDelete->isSubmitted()){
  2776.                 $valid = ValidationService::validateNotBlank($validator, $formDelete->get('password'));
  2778.                 if($valid && !($passwordHasher->isPasswordValid($this->getUser(), $formDelete->get('password')->getData()))){
  2779.                     $valid = false;
  2780.                     $formDelete->get('password')->addError(new FormError('Password errata!'));
  2781.                 }
  2783.                 if($valid && $formDelete->isValid()){
  2784.                     
  2785.                     foreach($ticket->getInterventions() as $intervention){
  2786.                         if($intervention->getSuspension() != null)
  2787.                             $em->remove($intervention->getSuspension());
  2788.                         $em->remove($intervention);
  2789.                     }
  2790.                     
  2791.                     $this->deleteTicketAndConnectedValues($em, $ticket);
  2792.                     $em->flush();
  2794.                     $this->addFlash('notice_success', "Ticket eliminato correttamente!");
  2795.                     return $this->redirectToRoute('user_ticket_list');
  2796.                 }
  2797.                 else
  2798.                     $session->set('openDeleteModal', true);
  2799.             }
  2800.             
  2801.             return $this->render('role/user/ticket/sheet.html.twig', array(
  2802.                 'company' => $company,
  2803.                 'ticket' => $ticket,
  2804.                 'cities' => $cities,
  2805.                 'technicians' => $technicians,
  2806.                 'displayJsonReport' => $displayJsonReport,
  2807.                 'settingTechUnlockSuspension' => $settingTechUnlockSuspension,
  2808.                 'settingBackOffice' => $settingBackOffice->getValue(),
  2809.                 'settingProcessedActive' => $settingProcessedActive->getValue(),
  2810.                 'settingTechnicianExchangeTickets' => $settingTechnicianExchangeTickets->getValue(),
  2811.                 'formAddressEdit' => $formAddressEdit->createView(),
  2812.                 'formClientEdit' => $formClientEdit->createView(),
  2813.                 'formDelete' => $formDelete->createView(),
  2814.                 'formErrorAddress' => $formErrorAddress->createView(),
  2815.                 'formErrorKeyMapping' => $formErrorKeyMapping->createView(),
  2816.                 'formErrorOperation' => $formErrorOperation->createView(),
  2817.                 'formErrorProvince' => $formErrorProvince->createView(),
  2818.                 'formErrorSupplier' => $formErrorSupplier->createView(),
  2819.                 'formExpirationDatetimeEdit' => $formExpirationDatetimeEdit->createView(),
  2820.                 'formNotesEdit' => $formNotesEdit->createView(),
  2821.                 'formWaybillEdit' => $formWaybillEdit->createView(),
  2822.                 'formExtraEdit' => $formExtraEdit->createView(),
  2823.                 'formExtraNew' => $formExtraNew->createView(),
  2824.                 'formInterventionSla' => $formInterventionSla->createView(),
  2825.                 'formOperationEdit' => $formOperationEdit->createView(),
  2826.                 'formOperationTariffAmount' => $formOperationTariffAmount->createView(),
  2827.                 'formSusApprove' => $formSusApprove->createView(),
  2828.                 'formSusEdit' => $formSusEdit->createView(),
  2829.                 'formSusUnlock' => $formSusUnlock->createView(),
  2830.                 'formReminderNew' => $formReminderNew->createView(),
  2831.                 'formReminderEdit' => $formReminderEdit->createView()
  2832.             ));
  2833.         }
  2834.         else{
  2835.             return $this->render('role/user/ticket/sheet.html.twig', array(
  2836.                 'company' => $company,
  2837.                 'ticket' => $ticket,
  2838.                 'cities' => $cities,
  2839.                 'technicians' => $technicians,
  2840.                 'displayJsonReport' => $displayJsonReport,
  2841.                 'settingTechUnlockSuspension' => $settingTechUnlockSuspension,
  2842.                 'settingProcessedActive' => $settingProcessedActive->getValue(),
  2843.                 'settingTechnicianExchangeTickets' => $settingTechnicianExchangeTickets->getValue(),
  2844.                 'formClientEdit' => $formClientEdit->createView(),
  2845.                 'settingBackOffice' => $settingBackOffice->getValue(),
  2846.                 'formAddressEdit' => $formAddressEdit->createView(),
  2847.                 'formSusUnlock' => $formSusUnlock->createView(),
  2848.                 'formExtraNew' => $formExtraNew->createView(),
  2849.                 'formExtraEdit' => $formExtraEdit->createView(),
  2850.                 'formReminderNew' => $formReminderNew->createView(),
  2851.                 'formReminderEdit' => $formReminderEdit->createView()
  2852.             ));
  2853.         }
  2854.     }
  2856.     /**
  2857.      * @Route("/{ticketId}/scheda/aggiorna-dati", name="user_ticket_sheet_update_data")
  2858.      * @Security("is_granted('edit', 'ticket')")
  2859.      */
  2860.     public function userTicketSheetUpdateData($ticketId, Request $request, MailerInterface $mailer)
  2861.     {
  2862.         $em = $this->mr->getManager('slave');
  2863.         $emMaster = $this->mr->getManager('master');
  2864.         $session = $request->getSession();
  2865.         $session->remove('ticket_id_city_alias');
  2866.         $company = $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get('companyId'));
  2867.         $ticket = $em->getRepository('App\Entity\Slave\Ticket')->findOneById($ticketId);
  2868.         $operationTickets = $em->getRepository('App\Entity\Slave\Ticket')->findByOperationAndSystemError($ticket->getOperation(), true);
  2869.         $toAssignStatus = $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBySlug('to_assign');
  2870.         foreach($operationTickets as $ot){
  2871.             if($ot->getClient() == null)
  2872.                 $error = TicketService::ticketMapClient($em, $ot);
  2873.             $error = TicketService::ticketMapColumns($em, $emMaster, $company, $ot);
  2874.             if(!$error) $error = TicketService::ticketAssignOperationTariffAmount($em, $emMaster, $ot);
  2875.             if(!$error) TicketService::ticketAutoAssign($em, $emMaster, $this->getUser(), $ot, $mailer);
  2876.             if(!$error){
  2877.                 $ot->setSystemError(false);
  2878.                 $ot->setSystemErrorDetails(null);
  2879.                 TicketService::createTicketLog($em, $this->getUser(), $ticket, "cs", $ticket->getStatus(), $toAssignStatus->getValue());
  2880.                 $ot->setStatus($toAssignStatus);
  2881.             }
  2882.         }
  2883.         $em->flush();
  2884.         $this->addFlash('notice_success', "Dati aggiornati");
  2885.         return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2886.     }
  2888.     /**
  2889.      * @Route("/{ticketId}/reindirizza-configurazione-alias-citta", name="user_ticket_redirect_alias_city")
  2890.      * @Security("is_granted('edit', 'ticket')")
  2891.      */
  2892.     public function userTicketRedirectAliasCity($ticketId, Request $request)
  2893.     {    
  2894.         $em = $this->mr->getManager('slave');
  2895.         $session = $request->getSession();
  2896.         $ticket = $em->getRepository('App\Entity\Slave\Ticket')->findOneById($ticketId);
  2897.         $keysRequired = $em->getRepository('App\Entity\Slave\OperationKeyMapping')->findByOperationAndRequired($ticket->getOperation()->getId(), true);
  2898.         foreach($keysRequired as $k){
  2899.             foreach(json_decode($ticket->getJson(), true) as $val){
  2900.                 if(array_key_exists($k->getMappingValue(), $val)){
  2901.                     switch($k->getTicketColumn()){
  2902.                         case 'Città': $cityName = $val[$k->getMappingValue()]; break;
  2903.                         default: break;
  2904.                     }
  2905.                 }
  2906.                 else{
  2907.                     $altKey = $k->displayMappingExtraValue("alt_key");
  2908.                     if(array_key_exists($altKey, $val)){
  2909.                         switch($k->getTicketColumn()){
  2910.                             case 'Città': $cityName = $val[$altKey]; break;
  2911.                             default: break;
  2912.                         }
  2913.                     }
  2914.                 }
  2915.             }
  2916.         }
  2917.                         
  2918.         $session->set('city_alias_value', $cityName);
  2919.         $session->set('ticket_id_city_alias', $ticket->getId());
  2920.         return $this->redirectToRoute('user_configuration_city_aliases');
  2921.     }
  2922.     
  2923.     /**
  2924.      * @Route("/{ticketId}/reindirizza-fornitore-operazione", name="user_ticket_redirect_supplier_operation")
  2925.      * @Security("is_granted('edit', 'ticket')")
  2926.      */
  2927.     public function userTicketRedirectSupplierOperation($ticketId, Request $request)
  2928.     {    
  2929.         $em = $this->mr->getManager('slave');
  2930.         $session = $request->getSession();
  2931.         $ticket = $em->getRepository('App\Entity\Slave\Ticket')->findOneById($ticketId);
  2932.         $session->set('supplierId', $ticket->getSupplier()->getId());
  2933.         $session->set('operationId', $ticket->getOperation()->getId());
  2934.         return $this->redirectToRoute('user_anagraphic_supplier_operation_sheet', array('operationId' => $ticket->getOperation()->getId()));
  2935.     }
  2937.     /**
  2938.      * @Route("/fatturabile", name="user_ticket_billable")
  2939.      * @Security("is_granted('edit', 'ticket')")
  2940.      */
  2941.     public function userTicketBillable(Request $request)
  2942.     {    
  2943.         $em = $this->mr->getManager('slave');
  2944.         $ticket = $em->getRepository("App\Entity\Slave\Ticket")->findOneById($request->request->get("ticketId"));
  2945.         $ticket->setBillable(!$ticket->isBillable());
  2946.         $em->flush();
  2948.         $text = 'non fatturabile';
  2949.         if($ticket->isBillable())
  2950.             $text = 'da fatturare';
  2952.         $this->addFlash('notice_success', "Ticket reso ".$text."!");
  2953.         return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2954.     }
  2956.     /**
  2957.      * @Route("/processato", name="user_ticket_processed")
  2958.      * @Security("is_granted('edit', 'ticket')")
  2959.      */
  2960.     public function userTicketProcessed(Request $request)
  2961.     {    
  2962.         $em = $this->mr->getManager('slave');
  2963.         $ticket = $em->getRepository("App\Entity\Slave\Ticket")->findOneById($request->request->get("ticketId"));
  2964.         $ticket->setProcessed(!$ticket->isProcessed());
  2965.         $em->flush();
  2967.         $text = 'normale';
  2968.         if($ticket->isProcessed())
  2969.             $text = 'processato';
  2971.         $this->addFlash('notice_success', "Ticket reso ".$text."!");
  2972.         return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  2973.     }    
  2974.     
  2975.     /**
  2976.      * @Route("/intervento/non-fatturabile", name="user_ticket_intervention_not_billable")
  2977.      * @Security("is_granted('edit', 'ticket')")
  2978.      */
  2979.     public function userTicketInterventionNotBillable(Request $request)
  2980.     {    
  2981.         $em = $this->mr->getManager('slave');
  2982.         $intervention = $em->getRepository("App\Entity\Slave\Intervention")->findOneById($request->request->get("interventionId"));
  2983.         $intervention->setBillable(!$intervention->isBillable());
  2984.         $em->flush();
  2986.         $text = 'non fatturabile';
  2987.         if($intervention->isBillable())
  2988.             $text = 'da fatturare';
  2990.         $this->addFlash('notice_success', "Intervento reso ".$text."!");
  2991.         return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $intervention->getTicket()->getId()));
  2992.     }
  2993.     
  2994.     /**
  2995.      * @Route("/intervento-extra/elimina", name="user_ticket_intervention_extra_delete")
  2996.      * @Security("is_granted('edit', 'ticket')")
  2997.      */
  2998.     public function userTicketInterventionExtraDelete(Request $request)
  2999.     {    
  3000.         $em = $this->mr->getManager('slave');
  3001.         $interventionExtra = $em->getRepository("App\Entity\Slave\InterventionExtra")->findOneById($request->request->get("interventionExtraDelId"));
  3002.         $ticketId = $interventionExtra->getIntervention()->getTicket()->getId();
  3003.         $em->remove($interventionExtra);
  3004.         $em->flush();
  3006.         $this->addFlash('notice_success', "Extra ticket eliminato");
  3007.         return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticketId));
  3008.     }
  3009.     
  3010.     /**
  3011.      * @Route("/promemoria/elimina", name="user_ticket_reminder_delete")
  3012.      * @Security("is_granted('edit', 'ticket')")
  3013.      */
  3014.     public function userTicketReminderDelete(Request $request)
  3015.     {    
  3016.         $em = $this->mr->getManager('slave');
  3017.         $ticketReminder = $em->getRepository("App\Entity\Slave\TicketReminder")->findOneById($request->request->get("reminderDelId"));
  3018.         $ticketId = $ticketReminder->getTicket()->getId();
  3019.         $em->remove($ticketReminder);
  3020.         $em->flush();
  3022.         $this->addFlash('notice_success', "Reminder ticket eliminato");
  3023.         return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticketId));
  3024.     }
  3025.     
  3026.     /**
  3027.      * @Route("/intervento-extra/invia-approva", name="user_ticket_intervention_extra_send_approve")
  3028.      * @Security("is_granted('edit', 'ticket')")
  3029.      */
  3030.     public function userTicketInterventionExtraSendApprove(Request $request)
  3031.     {    
  3032.         $em = $this->mr->getManager('slave');
  3033.         $interventionExtra = $em->getRepository("App\Entity\Slave\InterventionExtra")->findOneById($request->request->get("interventionExtraId"));
  3034.         $interventionExtra->setManaged(true);
  3035.         if($request->request->get('interventionExtraStatus') == 'approve')
  3036.             $interventionExtra->setApproved(true);
  3037.         else
  3038.             $interventionExtra->setApproved(false);
  3039.         $em->flush();
  3040.         $this->addFlash('notice_success', "Extra ticket aggiornato");
  3041.         return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $interventionExtra->getIntervention()->getTicket()->getId()));
  3042.     }
  3044.     // AZIONI AGENZIA
  3045.     /**
  3046.      * @Route("/scheda/tecnico-assegna", name="user_ticket_technician_assign")
  3047.      * @Security("is_granted('edit', 'ticket')")
  3048.      */
  3049.     public function userTicketTechnicianAssign(Request $request, MailerInterface $mailer)
  3050.     {    
  3051.         $em = $this->mr->getManager('slave');
  3052.         $technician = $em->getRepository("App\Entity\Slave\User")->findOneById($request->request->get('technicianId'));
  3054.         $ticket = $em->getRepository("App\Entity\Slave\Ticket")->findOneById($request->request->get('ticketId'));
  3055.         $statusAssigned = $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'assigned'));
  3056.         $settingTechnicianSendAssignEmail = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'ticket_technician_send_assign_email'));
  3057.         
  3058.         // Notifico il vecchio tecnico se impostazione attiva
  3059.         $oldTechnician = $ticket->getTechnician();
  3060.         $settingSendEmail = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'ticket_technician_send_cancel_email'));
  3061.         if($oldTechnician != null && $settingSendEmail->getValue() == 1){
  3062.             $message = (new TemplatedEmail())
  3063.                 ->subject($this->params->get('subject_ticket_canceled').' '.$ticket->getNumber())
  3064.                 ->from($this->params->get('email_noreply'))
  3065.                 ->to($oldTechnician->getEmail())
  3066.                 ->htmlTemplate('email/ticket/canceled.html.twig')
  3067.                 ->context(['technician' => $oldTechnician, 'ticket' => $ticket]);
  3068.             $mailer->send($message);
  3069.         }
  3071.         TicketService::createTicketLog($em, $this->getUser(), $ticket, "ct", $ticket->getTechnician(), $technician);
  3072.         $ticket->setTechnician($technician);
  3073.         $statusAssigned = $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBySlug('assigned');
  3074.         TicketService::createTicketLog($em, $this->getUser(), $ticket, "cs", $ticket->getStatus(), $statusAssigned->getValue());
  3075.         $ticket->setStatus($statusAssigned);
  3076.         $em->flush();
  3078.         // Invio messaggio di notifica al tecnico
  3079.         if($settingTechnicianSendAssignEmail->getValue() == 1 && $ticket->getTechnician()->isAssignEmailActive()){
  3080.             $tickets = [];
  3081.             array_push($tickets, $ticket);
  3082.             $message = (new TemplatedEmail())
  3083.                 ->subject($this->params->get('subject_ticket_take_charge'))
  3084.                 ->from($this->params->get('email_noreply'))
  3085.                 ->to($ticket->getTechnician()->getEmail())
  3086.                 ->htmlTemplate('email/technician/tickets_assigned.html.twig')
  3087.                 ->context(['user' => $ticket->getTechnician(), 'tickets' => $tickets]);
  3088.             $mailer->send($message);
  3089.         }
  3091.         $this->addFlash('notice_success', "Ticket assegnato");
  3092.         if($this->getUser()->getAccountTypology() == "technician")
  3093.             return $this->redirectToRoute('user_ticket_list');
  3094.         else
  3095.             return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  3096.     }
  3098.     /**
  3099.      * @Route("/scheda/cancella", name="user_ticket_cancel")
  3100.      * @Security("is_granted('edit', 'ticket')")
  3101.      */
  3102.     public function userTicketCancel(Request $request, MailerInterface $mailer)
  3103.     {    
  3104.         $em = $this->mr->getManager('slave');
  3105.         $ticket = $em->getRepository("App\Entity\Slave\Ticket")->findOneById($request->request->get('ticketId'));
  3106.         $statusCanceled = $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'canceled'));
  3108.         // Notifico il tecnico se impostazione attiva
  3109.         $settingSendEmail = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'ticket_technician_send_cancel_email'));
  3110.         if($settingSendEmail->getValue() == 1 && $ticket->getTechnician() != null && ($ticket->getStatus()->getSlug() != 'closed' && $ticket->getStatus()->getSlug() != 'closed_portal')){
  3111.             $message = (new TemplatedEmail())
  3112.                 ->subject($this->params->get('subject_ticket_canceled').' '.$ticket->getNumber())
  3113.                 ->from($this->params->get('email_noreply'))
  3114.                 ->to($ticket->getTechnician()->getEmail())
  3115.                 ->htmlTemplate('email/ticket/canceled.html.twig')
  3116.                 ->context(['technician' => $ticket->getTechnician(), 'ticket' => $ticket]);
  3117.             $mailer->send($message);
  3118.         }
  3119.         TicketService::createTicketLog($em, $this->getUser(), $ticket, "cs", $ticket->getStatus(), $statusCanceled->getValue());
  3120.         $ticket->setStatus($statusCanceled);
  3121.         $em->flush();
  3123.         $this->addFlash('notice_success', "Ticket annullato");
  3124.         return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  3125.     }
  3126.     
  3127.     /**
  3128.      * @Route("/scheda/errato", name="user_ticket_wrong")
  3129.      * @Security("is_granted('edit', 'ticket')")
  3130.      */
  3131.     public function userTicketWrong(Request $request)
  3132.     {    
  3133.         $em = $this->mr->getManager('slave');
  3134.         $ticket = $em->getRepository("App\Entity\Slave\Ticket")->findOneById($request->request->get('ticketId'));
  3135.         $statusWrong = $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'wrong'));
  3136.         
  3137.         $ticket->setSystemError(false);
  3138.         $ticket->setSystemErrorSlug(null);
  3139.         $ticket->setSystemErrorDetails(null);
  3140.         TicketService::createTicketLog($em, $this->getUser(), $ticket, "cs", $ticket->getStatus(), $statusWrong->getValue());
  3141.         $ticket->setStatus($statusWrong);
  3142.         $em->flush();
  3144.         $this->addFlash('notice_success', "Ticket spostato in errati");
  3145.         return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  3146.     }
  3147.     
  3148.     /**
  3149.      * @Route("/scheda/ripristina", name="user_ticket_restore")
  3150.      * @Security("is_granted('edit', 'ticket')")
  3151.      */
  3152.     public function userTicketRestore(Request $request)
  3153.     {    
  3154.         $em = $this->mr->getManager('slave');
  3155.         $ticket = $em->getRepository("App\Entity\Slave\Ticket")->findOneById($request->request->get('ticketId'));
  3156.         $statusToAssign = $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'to_assign'));
  3157.         $statusAssigned = $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'assigned'));
  3158.         if($ticket->getTechnician() != null){
  3159.             TicketService::createTicketLog($em, $this->getUser(), $ticket, "cs", $ticket->getStatus(), $statusAssigned->getValue());
  3160.             $ticket->setStatus($statusAssigned);
  3161.         }
  3162.         else{
  3163.             TicketService::createTicketLog($em, $this->getUser(), $ticket, "cs", $ticket->getStatus(), $statusToAssign->getValue());  
  3164.             $ticket->setStatus($statusToAssign);
  3165.         }
  3166.         $em->flush();
  3168.         $this->addFlash('notice_success', "Ticket ripristinato");
  3169.         return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  3170.     }
  3171.     
  3172.     /**
  3173.      * @Route("/scheda/prendi-in-carico", name="user_ticket_taken_charge")
  3174.      * @Security("is_granted('edit', 'ticket')")
  3175.      */
  3176.     public function userTicketTakenCharge(Request $request)
  3177.     {    
  3178.         $em = $this->mr->getManager('slave');
  3179.         $session = $request->getSession();
  3180.         $ticket = $em->getRepository("App\Entity\Slave\Ticket")->findOneById($request->request->get('ticketId'));
  3181.         $statusTakenCharge = $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'taken_charge'));
  3182.         TicketService::createTicketLog($em, $this->getUser(), $ticket, "cs", $ticket->getStatus(), $statusTakenCharge->getValue());
  3183.         $ticket->setStatus($statusTakenCharge);
  3184.         $em->flush();
  3185.         $this->addFlash('notice_success', "Ticket ripreso in carico");
  3186.         return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  3187.     }
  3188.     
  3189.     /**
  3190.      * @Route("/scheda/completa", name="user_ticket_close")
  3191.      * @Security("is_granted('edit', 'ticket')")
  3192.      */
  3193.     public function userTicketClose(Request $request)
  3194.     {    
  3195.         $em = $this->mr->getManager('slave');
  3196.         $ticket = $em->getRepository("App\Entity\Slave\Ticket")->findOneById($request->request->get('ticketClosedId'));
  3197.         $statusClosed = $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'closed'));
  3198.         TicketService::createTicketLog($em, $this->getUser(), $ticket, "cs", $ticket->getStatus(), $statusClosed->getValue());
  3199.         $ticket->setStatus($statusClosed);
  3200.         $ticket->setClosedOnPortal(0);
  3201.         if ($request->request->get('origin') === 'portal') {
  3202.             $ticket->setDatetimeEnd(new \DateTime());
  3203.         }
  3204.         $em->flush();
  3205.         $this->addFlash('notice_success', "Ticket chiuso");
  3206.         return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  3207.     }
  3209.     /**
  3210.      * @Route("/scheda/chiuso-su-portale-fornitore", name="user_ticket_closed_on_portal")
  3211.      * @Security("is_granted('edit', 'ticket')")
  3212.      */
  3213.     public function userTicketCloseOnPortal(Request $request)
  3214.     {    
  3215.         $em = $this->mr->getManager('slave');
  3216.         $ticket = $em->getRepository("App\Entity\Slave\Ticket")->findOneById($request->request->get('ticketClosedPortalId'));
  3217.         $statusClosedOnPortal = $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'closed_portal'));
  3218.         TicketService::createTicketLog($em, $this->getUser(), $ticket, "cs", $ticket->getStatus(), $statusClosedOnPortal->getValue());
  3219.         $ticket->setStatus($statusClosedOnPortal);
  3220.         $ticket->setClosedOnPortal(1);
  3221.         $em->flush();
  3223.         $this->addFlash('notice_success', "Ticket contrassegnato come chiuso su portale cliente");
  3224.         return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  3225.     }
  3227.     // AZIONI TECNICO / AGENZIA SE SETTING TICKET_MANAGE == 1
  3228.     /**
  3229.      * @Route("/{ticketId}/scheda/prendi-in-carico", name="user_ticket_take_charge_single")
  3230.      * @Security("is_granted('edit', 'ticket')")
  3231.      */
  3232.     public function userTicketTakeChargeSingle($ticketId, Request $request)
  3233.     {    
  3234.         $em = $this->mr->getManager('slave');
  3235.         $session = $request->getSession();
  3236.         $ticket = $em->getRepository("App\Entity\Slave\Ticket")->findOneById($ticketId);
  3237.         $statusTakeCharge = $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'taken_charge'));
  3238.         TicketService::createTicketLog($em, $this->getUser(), $ticket, "cs", $ticket->getStatus(), $statusTakeCharge->getValue());
  3239.         $ticket->setStatus($statusTakeCharge);
  3240.         $em->flush();
  3242.         $this->addFlash('notice_success', "Ticket preso in carico");
  3243.         return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  3244.     }
  3245.     
  3246.     /**
  3247.      * @Route("/{ticketId}/scheda/verbale-stampa", name="user_ticket_report_print_single")
  3248.      * @Security("is_granted('view', 'ticket')")
  3249.      */
  3250.     public function userTicketReportPrintSingle($ticketId, Request $request)
  3251.     {    
  3252.         $em = $this->mr->getManager('slave');
  3253.         $ticket = $em->getRepository("App\Entity\Slave\Ticket")->findOneById($ticketId);
  3254.         $matrixTickets = array();
  3255.         $jsonReportValues = array();
  3256.         $tmp = array();
  3258.         if($ticket->getJsonReport() != '[]'){
  3259.             $matrix = json_decode($ticket->getJsonReport(), true);
  3260.             foreach($matrix as $array)
  3261.                 foreach($array as $a){
  3262.                     $tcv = $em->getRepository('App\Entity\Slave\TicketColumnValue')->findOneBySupplierTicketColumnAndNeedle($ticket->getSupplier()->getId(), array_keys($array)[0], $a);
  3263.                     $htmlToAdd = '';
  3264.                     if($tcv != null)
  3265.                         $htmlToAdd = ' ('.$tcv->getValue().')';
  3266.                     $jsonReportValues[array_keys($array)[0]] = $a.$htmlToAdd;
  3267.                 }
  3268.         }
  3269.         array_push($tmp, $ticket, $jsonReportValues);
  3270.         array_push($matrixTickets, $tmp);
  3272.         return $this->render('role/user/print/report.html.twig', array(
  3273.             'matrixTickets' => $matrixTickets,
  3274.             'backRoute' => 'sheet',
  3275.             'continueRoute' => 'sheet'
  3276.         ));
  3277.     }
  3279.     /**
  3280.      * @Route("/{ticketId}/scheda/verbali-stampati", name="user_ticket_report_printed_single")
  3281.      * @Security("is_granted('view', 'ticket')")
  3282.      */
  3283.     public function userTicketReportPrintedSingle(Request $request, $ticketId)
  3284.     {    
  3285.         $em = $this->mr->getManager('slave');
  3286.         $ticket = $em->getRepository("App\Entity\Slave\Ticket")->findOneById($ticketId);
  3287.         $ticket->setReportPrinted(true);
  3288.         $em->flush();
  3289.         return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticketId));             
  3290.     }
  3292.     /**
  3293.      * @Route("/scheda/intervento/seleziona", name="user_ticket_intervention_select")
  3294.      * @Security("is_granted('edit', 'ticket')")
  3295.      */
  3296.     public function userTicketInterventionSelect(Request $request)
  3297.     {    
  3298.         $em = $this->mr->getManager('slave');
  3299.         $ticket = $em->getRepository('App\Entity\Slave\Ticket')->findOneById($request->request->get('ticketId'));
  3300.         $outcomeType = $em->getRepository('App\Entity\Slave\InterventionOutcomeType')->findOneBy(array('slug' => $request->request->get('interventionOutcomeTypeSlug')));
  3301.         $today = new \Datetime();
  3303.         $intervention = new Intervention();
  3304.         $intervention->setTicket($ticket);
  3305.         $intervention->setOutcomeType($outcomeType);
  3306.         $intervention->setDatetime($today);
  3307.         $intervention->setDatetimeBilling(date_create_from_format('d-m-Y H:i:s', '01-'.$today->format('m').'-'.$today->format('Y').' 00:00:00'));
  3308.         $em->persist($intervention);
  3309.         $em->flush();
  3311.         if($intervention->getOutcomeType()->getSlug() == 'completed'){
  3312.             // Completato --- Vado al seleziona attivita
  3313.             $warehouse = $em->getRepository('App\Entity\Slave\Warehouse')->findOneById($request->request->get('interventionWarehouseId'));
  3314.             $intervention->setWarehouse($warehouse);
  3315.             $em->flush();
  3316.             return $this->redirectToRoute('user_ticket_intervention_activity_summary', array('interventionId' => $intervention->getId()));
  3317.         }
  3318.         else{
  3319.             // A vuoto/Sospeso --- Vado direttamente ai dettagli intervento
  3320.             return $this->redirectToRoute("user_ticket_intervention", array('interventionId' => $intervention->getId()));
  3321.         }
  3322.     }
  3324.     /**
  3325.      * @Route("/intervento-incompleto/elimina", name="user_ticket_intervention_delete")
  3326.      * @Security("is_granted('edit', 'ticket')")
  3327.      */
  3328.     public function userTicketInterventionDelete(Request $request)
  3329.     {    
  3330.         $em = $this->mr->getManager('slave');
  3331.         $intervention = $em->getRepository("App\Entity\Slave\Intervention")->findOneById($request->request->get("interventionDelId"));
  3332.         $ticket = $intervention->getTicket();
  3333.         $ticketId = $intervention->getTicket()->getId();
  3335.         foreach($intervention->getActivities() as $activity){
  3336.             // Withdraw
  3337.             if($activity->getProductWithdraw() != null){
  3338.                 // Controllo: se l'ho inserita adesso elimino il prodotto altrimenti lo ritrasferisco indietro
  3339.                 if($activity->getProductWithdraw()->getIsAlreadyInserted('withdraw')){
  3340.                     $productToDelete = $activity->getProductWithdraw();
  3341.                     $activity->setProductWithdraw(null);
  3342.                     $this->deleteProductAlreadyInserted($em, $productToDelete);
  3343.                 }
  3344.                 else{
  3345.                     $oldStatus = $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'in_use'));
  3346.                     $oldCondition = $em->getRepository('App\Entity\Slave\ProductCondition')->findOneById($intervention->getLastProductLog('condition')->getOldDataId());
  3347.                     ProductService::createProductLog($em, $activity->getProductWithdraw(), $this->getUser(), null, 'status', $activity->getProductWithdraw()->getStatus()->getValue(), $oldStatus->getValue());
  3348.                     ProductService::createProductLog($em, $activity->getProductWithdraw(), $this->getUser(), null, 'condition', $activity->getProductWithdraw()->getCondition()->getValue(), $oldCondition->getValue());
  3349.                     $activity->getProductWithdraw()->setStatus($oldStatus);
  3350.                     $activity->getProductWithdraw()->setCondition($oldCondition);
  3351.                     $activity->getProductWithdraw()->setTermid($ticket->getTermid());
  3352.                     ProductService::moveProductClient($em, $activity->getProductWithdraw(), $ticket->getClient()->getWarehouse());
  3353.                     ProductService::createProductTransferLogClient($em, $activity->getProductWithdraw(), $this->getUser(), $intervention->getWarehouse(), $ticket->getClient()->getWarehouse(), new \Datetime(), 'scan');
  3354.                 }
  3355.             }
  3356.             // Actual
  3357.             if($activity->getProductActual() != null){
  3358.                 // Controllo: se l'ho inserita adesso elimino il prodotto altrimenti lo ritrasferisco indietro
  3359.                 if($activity->getProductActual()->getIsAlreadyInserted('actual')){
  3360.                     $productToDelete = $activity->getProductActual();
  3361.                     $activity->setProductActual(null);
  3362.                     $this->deleteProductAlreadyInserted($em, $productToDelete);
  3363.                 }
  3364.                 else{
  3365.                     $activity->getProductActual()->setTermid($ticket->getTermid());
  3366.                     ProductService::moveProductClient($em, $activity->getProductActual(), $ticket->getClient()->getWarehouse());
  3367.                 }
  3368.             }
  3369.             // Installation
  3370.             if($activity->getProductInstallation() != null){
  3371.                 $oldStatus = $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'available'));
  3372.                 ProductService::createProductLog($em, $activity->getProductInstallation(), $this->getUser(), $intervention, 'status', $activity->getProductInstallation()->getStatus()->getValue(), $oldStatus->getValue());
  3373.                 $activity->getProductInstallation()->setStatus($oldStatus);
  3374.                 $activity->getProductInstallation()->setTermid(null);
  3375.                 ProductService::moveProductClient($em, $activity->getProductInstallation(), $intervention->getWarehouse());
  3376.                 ProductService::createProductTransferLogClient($em, $activity->getProductInstallation(), $this->getUser(), $ticket->getClient()->getWarehouse(), $intervention->getWarehouse(), new \Datetime(), 'scan');
  3377.             }
  3379.             $em->remove($activity);
  3380.         }
  3381.         foreach($intervention->getProductLogs() as $log){
  3382.             $log->setIntervention(null);
  3383.         }
  3384.         $em->flush();
  3386.         $em->remove($intervention);
  3387.         $em->flush();
  3389.         if($ticket->getInterventionCompleted() == null){
  3390.             $ticket->setDatetimeEnd(null);
  3391.             if($ticket->getStatus()->getSlug() == "closed" || $ticket->getStatus()->getSlug() == "closed_portal"){
  3392.                 $statusAssigned = $em->getRepository("App\Entity\Slave\TicketStatus")->findOneBySlug("assigned");
  3393.                 TicketService::createTicketLog($em, $this->getUser(), $ticket, "cs", $ticket->getStatus(), $statusAssigned->getValue());
  3394.                 $ticket->setStatus($statusAssigned);
  3395.             }
  3396.             $em->flush();
  3397.         }
  3399.         $this->addFlash('notice_success', "Intervento eliminato correttamente");
  3400.         return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticketId));
  3401.     }
  3402.     
  3403.     /**
  3404.      * @Route("/{interventionId}/scheda/intervento/modifica", name="user_ticket_intervention_edit")
  3405.      * @Security("is_granted('edit', 'ticket')")
  3406.      */
  3407.     public function userTicketInterventionEdit($interventionId, Request $request)
  3408.     {    
  3409.         $em = $this->mr->getManager('slave');
  3410.         $intervention = $em->getRepository('App\Entity\Slave\Intervention')->findOneById($interventionId);
  3411.         if($intervention->getOutcomeType()->getSlug() == 'completed')
  3412.             return $this->redirectToRoute('user_ticket_intervention_activity_summary', array('interventionId' => $intervention->getId()));
  3413.         else
  3414.             return $this->redirectToRoute("user_ticket_intervention", array('interventionId' => $intervention->getId()));
  3415.     }
  3417.     /**
  3418.      * @Route("/{interventionId}/scheda/intervento/attivita-riassunto", name="user_ticket_intervention_activity_summary")
  3419.      * @Security("is_granted('edit', 'ticket')")
  3420.      */
  3421.     public function userTicketInterventionActivitySelect($interventionId, Request $request)
  3422.     {    
  3423.         $em = $this->mr->getManager('slave');
  3424.         $session = $request->getSession();
  3425.         $intervention = $em->getRepository("App\Entity\Slave\Intervention")->findOneById($interventionId);
  3426.         $ticket = $intervention->getTicket();
  3427.         $components = $em->getRepository("App\Entity\Slave\ProductComponent")->findAll();
  3428.         // Se tecnico -> Escludo i tipi attività solo backoffice
  3429.         if($this->getUser()->getAccountTypology() == 'technician')
  3430.             $interventionActivityTypes = $em->getRepository('App\Entity\Slave\InterventionActivityType')->findVisibleByOperationGroupAndOnlyBackoffice($ticket->getOperation()->getGroup()->getSlug(), false);
  3431.         else
  3432.             $interventionActivityTypes = $em->getRepository('App\Entity\Slave\InterventionActivityType')->findVisibleByOperationGroupAndOnlyBackoffice($ticket->getOperation()->getGroup()->getSlug(), true);
  3434.         return $this->render('role/user/ticket/intervention/activity/summary.html.twig', array(
  3435.             'ticket' => $ticket,
  3436.             'components' => $components,
  3437.             'intervention' => $intervention,
  3438.             'interventionActivityTypes' => $interventionActivityTypes
  3439.         ));
  3440.     }
  3442.     /**
  3443.      * @Route("/scheda/intervento/attivita-cancella", name="user_ticket_intervention_activity_delete")
  3444.      * @Security("is_granted('edit', 'ticket')")
  3445.      */
  3446.     public function userTicketInterventionActivityDelete(Request $request)
  3447.     {    
  3448.         $em = $this->mr->getManager('slave');
  3449.         $session = $request->getSession();
  3450.         $activity = $em->getRepository("App\Entity\Slave\InterventionActivity")->findOneById($request->request->get('activityId'));
  3451.         $intervention = $activity->getIntervention();
  3452.         $ticket = $intervention->getTicket();
  3454.         // Withdraw
  3455.         if($activity->getProductWithdraw() != null){
  3456.             // Controllo: se l'ho inserita adesso elimino il prodotto altrimenti lo ritrasferisco indietro
  3457.             if($activity->getProductWithdraw()->getIsAlreadyInserted('withdraw')){
  3458.                 $productToDelete = $activity->getProductWithdraw();
  3459.                 $activity->setProductWithdraw(null);
  3460.                 $this->deleteProductAlreadyInserted($em, $productToDelete);
  3461.             }
  3462.             else{
  3463.                 $oldStatus = $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'in_use'));
  3464.                 $oldCondition = $em->getRepository('App\Entity\Slave\ProductCondition')->findOneById($intervention->getLastProductLog('condition')->getOldDataId());
  3465.                 ProductService::createProductLog($em, $activity->getProductWithdraw(), $this->getUser(), null, 'status', $activity->getProductWithdraw()->getStatus()->getValue(), $oldStatus->getValue());
  3466.                 $activity->getProductWithdraw()->setStatus($oldStatus);
  3467.                 if($oldCondition != null){
  3468.                     ProductService::createProductLog($em, $activity->getProductWithdraw(), $this->getUser(), null, 'condition', $activity->getProductWithdraw()->getCondition()->getValue(), $oldCondition->getValue());
  3469.                     $activity->getProductWithdraw()->setCondition($oldCondition);
  3470.                 }
  3471.                 else{
  3472.                     $activity->getProductWithdraw()->setCondition($em->getRepository('App\Entity\Slave\ProductCondition')->findOneBy(['slug' => 'free']));
  3473.                 }
  3474.                 $activity->getProductWithdraw()->setTermid($ticket->getTermid());
  3475.                 ProductService::moveProductClient($em, $activity->getProductWithdraw(), $ticket->getClient()->getWarehouse());
  3476.                 ProductService::createProductTransferLogClient($em, $activity->getProductWithdraw(), $this->getUser(), $intervention->getWarehouse(), $ticket->getClient()->getWarehouse(), new \Datetime(), 'scan');
  3477.             }
  3478.         }
  3479.         // Actual
  3480.         if($activity->getProductActual() != null){
  3481.             // Controllo: se l'ho inserita adesso elimino il prodotto altrimenti lo ritrasferisco indietro
  3482.             if($activity->getProductActual()->getIsAlreadyInserted('actual')){
  3483.                 $productToDelete = $activity->getProductActual();
  3484.                 $activity->setProductActual(null);
  3485.                 $this->deleteProductAlreadyInserted($em, $productToDelete);
  3486.             }
  3487.             else{
  3488.                 $activity->getProductActual()->setTermid($ticket->getTermid());
  3489.                 ProductService::moveProductClient($em, $activity->getProductActual(), $ticket->getClient()->getWarehouse());
  3490.             }
  3491.         }
  3492.         // Installation
  3493.         if($activity->getProductInstallation() != null){
  3494.             $oldStatus = $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'available'));
  3495.             ProductService::createProductLog($em, $activity->getProductInstallation(), $this->getUser(), $intervention, 'status', $activity->getProductInstallation()->getStatus()->getValue(), $oldStatus->getValue());
  3496.             $activity->getProductInstallation()->setStatus($oldStatus);
  3497.             $activity->getProductInstallation()->setTermid(null);
  3498.             ProductService::moveProductClient($em, $activity->getProductInstallation(), $intervention->getWarehouse());
  3499.             ProductService::createProductTransferLogClient($em, $activity->getProductInstallation(), $this->getUser(), $ticket->getClient()->getWarehouse(), $intervention->getWarehouse(), new \Datetime(), 'scan');
  3500.         }
  3502.         $em->remove($activity);
  3503.         $em->flush();
  3505.         $this->addFlash('notice_success', 'Attivita eliminata correttamente!');
  3506.         return $this->redirectToRoute('user_ticket_intervention_activity_summary', array('interventionId' => $intervention->getId()));
  3507.     }
  3509.     /**
  3510.      * @Route("/scheda/intervento/{interventionId}/attivita/{activityTypeId}", name="user_ticket_intervention_activity")
  3511.      * @Security("is_granted('edit', 'ticket')")
  3512.      */
  3513.     public function userTicketInterventionActivity($interventionId, $activityTypeId, Request $request, ValidatorInterface $validator, FormFactoryInterface $formFactory)
  3514.     {    
  3515.         $em = $this->mr->getManager('slave');
  3516.         $emMaster = $this->mr->getManager('master');
  3517.         $session = $request->getSession();
  3518.         $company = $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get('companyId'));
  3519.         $activityType = $em->getRepository("App\Entity\Slave\InterventionActivityType")->findOneById($activityTypeId);
  3520.         $intervention = $em->getRepository("App\Entity\Slave\Intervention")->findOneById($interventionId);
  3521.         $ticket = $intervention->getTicket();
  3523.         $activity = new InterventionActivity();
  3524.         $form = $formFactory->createNamed("form_intervention_activity", InterventionActivityType::class, $activity);
  3525.         $form->handleRequest($request);
  3527.         if($form->isSubmitted()){
  3528.             
  3529.             $valid = FormValidatorService::validateInterventionActivity($validator, $form, $activityType, $ticket, $intervention, $em);
  3531.             if($valid && $form->isValid()){
  3532.             
  3533.                 $activity->setIntervention($intervention);
  3534.                 $activity->setType($activityType);
  3535.                 // Withdraw
  3536.                 if($activityType->isProducerWithdrawMandatory() || $activityType->isSupplierWithdrawMandatory()){
  3537.                     $withdrawProduct = $this->activityProductByType($em, $form, 'Withdraw', array($ticket->getSupplier()));
  3538.                     // Se cambia il modello lo aggiorno al prodotto che ho disinstallato
  3539.                     $withdrawModel = $em->getRepository('App\Entity\Slave\ProductModel')->findOneById($form->get('modelWithdrawId')->getData());
  3540.                     if($withdrawModel != null)
  3541.                         $withdrawProduct->setModel($withdrawModel);
  3542.                     $activity->setProductWithdraw($withdrawProduct);
  3543.                     if($activityType->isSupplierWithdrawMandatory()){
  3544.                         $activity->setSupplierWithdraw($form->get('supplierWithdraw')->getData());
  3545.                         $transferLogType = $form->get('scanOrManualSupplierWithdraw')->getData();
  3546.                     }
  3547.                     if($activityType->isProducerWithdrawMandatory()){
  3548.                         $activity->setProducerWithdraw($form->get('producerWithdraw')->getData());
  3549.                         $transferLogType = $form->get('scanOrManualProducerWithdraw')->getData();
  3550.                     }
  3551.                     $components = $em->getRepository('App\Entity\Slave\ProductComponent')->findAll();
  3552.                     $arrayComponents = array();
  3553.                     foreach($components as $c){
  3554.                         $cp = $request->request->get('component_'.$c->getId());
  3555.                         if($cp == 'on')
  3556.                             array_push($arrayComponents, $c->getId());
  3557.                     }
  3558.                     $activity->setComponents($arrayComponents);
  3559.                     $newStatus = $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'not_available'));
  3560.                     $newCondition = $em->getRepository('App\Entity\Slave\ProductCondition')->findOneBy(array('slug' => 'retired'));
  3561.                     ProductService::createProductLog($em, $activity->getProductWithdraw(), $this->getUser(), $intervention, 'status', $activity->getProductWithdraw()->getStatus()->getValue(), $newStatus->getValue());
  3562.                     if($activity->getProductWithdraw()->getCondition() != null) ProductService::createProductLog($em, $activity->getProductWithdraw(), $this->getUser(), $intervention, 'condition', $activity->getProductWithdraw()->getCondition()->getValue(), $newCondition->getValue());
  3563.                     $activity->getProductWithdraw()->setStatus($newStatus);
  3564.                     $activity->getProductWithdraw()->setCondition($newCondition);
  3565.                     $activity->getProductWithdraw()->setTermid(null);
  3566.                     ProductService::createProductTransferLogClient($em, $activity->getProductWithdraw(), $this->getUser(), $ticket->getClient()->getWarehouse(), $intervention->getWarehouse(), new \Datetime(), $transferLogType);
  3567.                     ProductService::moveProductClient($em, $activity->getProductWithdraw(), $intervention->getWarehouse());
  3568.                 }
  3569.                 // Actual
  3570.                 if($activityType->isProducerActualMandatory() || $activityType->isSupplierActualMandatory()){
  3571.                     $actualProduct = $this->activityProductByType($em, $form, 'Actual', array($ticket->getSupplier()));
  3572.                     // Se cambia il modello lo aggiorno al prodotto che c'è installato 
  3573.                     // 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.
  3574.                     // In ogni caso, quando poi la merce torna in magazzino, viene sistemato il tutto, quindi non è un reale problema.
  3575.                     $actualModel = $em->getRepository('App\Entity\Slave\ProductModel')->findOneById($form->get('modelActualId')->getData());
  3576.                     if($actualModel != null)
  3577.                         $actualProduct->setModel($actualModel);
  3578.                     $activity->setProductActual($actualProduct);
  3579.                     if($activityType->isProducerActualMandatory()){
  3580.                         $activity->setProducerActual($form->get('producerActual')->getData());
  3581.                         $transferLogType = $form->get('scanOrManualProducerActual')->getData();
  3582.                     }
  3583.                     if($activityType->isSupplierActualMandatory()){
  3584.                         $activity->setSupplierActual($form->get('supplierActual')->getData());
  3585.                         $transferLogType = $form->get('scanOrManualSupplierActual')->getData();
  3586.                     }
  3587.                     $activity->getProductActual()->setTermid($ticket->getTermid());
  3588.                     ProductService::moveProductClient($em, $activity->getProductActual(), $ticket->getClient()->getWarehouse());
  3589.                 }
  3590.                 // Installation
  3591.                 if($activityType->isProducerInstallationMandatory() || $activityType->isSupplierInstallationMandatory()){
  3592.                     $installationProduct = $this->activityProductByType($em, $form, 'Installation', array($ticket->getSupplier()));
  3593.                     // Il modello non cambia mai, perché viene dettato dal magazzino, quindi non consento la modifica
  3594.                     $activity->setProductInstallation($installationProduct);
  3595.                     if($activityType->isProducerInstallationMandatory()){
  3596.                         $activity->setProducerInstallation($form->get('producerInstallation')->getData());
  3597.                         $transferLogType = $form->get('scanOrManualProducerInstallation')->getData();
  3598.                     }
  3599.                     if($activityType->isSupplierInstallationMandatory()){
  3600.                         $activity->setSupplierInstallation($form->get('supplierInstallation')->getData());
  3601.                         $transferLogType = $form->get('scanOrManualSupplierInstallation')->getData();
  3602.                     }
  3603.                     $newStatus = $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'in_use'));
  3604.                     ProductService::createProductLog($em, $activity->getProductInstallation(), $this->getUser(), $intervention, 'status', $activity->getProductInstallation()->getStatus()->getValue(), $newStatus->getValue());
  3605.                     $activity->getProductInstallation()->setStatus($newStatus);
  3606.                     $activity->getProductInstallation()->setTermid($ticket->getTermid());
  3607.                     ProductService::createProductTransferLogClient($em, $activity->getProductInstallation(), $this->getUser(), $intervention->getWarehouse(), $ticket->getClient()->getWarehouse(), new \Datetime(), $transferLogType);
  3608.                     ProductService::moveProductClient($em, $activity->getProductInstallation(), $ticket->getClient()->getWarehouse());
  3609.                 }
  3610.                 $em->persist($activity);
  3611.                 $em->flush();
  3612.                 return $this->redirectToRoute('user_ticket_intervention_activity_summary', array('interventionId' => $intervention->getId()));
  3613.             }
  3614.         }
  3616.         return $this->render('role/user/ticket/intervention/activity/single.html.twig', array(
  3617.             'company' => $company,
  3618.             'ticket' => $ticket,
  3619.             'intervention' => $intervention,
  3620.             'activityType' => $activityType,
  3621.             'isPos' => $activityType->isPos(),
  3622.             'form' => $form->createView()
  3623.         ));
  3624.     }
  3626.     /**
  3627.      * @Route("/scheda/intervento/attivita-prodotti-cerca-codice", name="user_ticket_intervention_activity_product_search_code")
  3628.      * @Security("is_granted('edit', 'ticket')")
  3629.      */
  3630.     public function userTicketInterventionActivityProductSearchCode(Request $request)
  3631.     {
  3632.         $em = $this->mr->getManager('slave');
  3633.         $session = $request->getSession();
  3634.         $ticket = $em->getRepository('App\Entity\Slave\Ticket')->findOneById($request->request->get('ticketId'));
  3635.         $intervention = $em->getRepository('App\Entity\Slave\Intervention')->findOneById($request->request->get('interventionId'));
  3636.         $interventionActivityType = $em->getRepository('App\Entity\Slave\InterventionActivityType')->findOneById($request->request->get('activityTypeId'));
  3638.         $product = null;
  3639.         // Controllo se esiste il prodotto
  3640.         switch($request->request->get('type')){
  3641.             case 'producer_withdraw':
  3642.             case 'producer_installation':
  3643.             case 'producer_actual':
  3644.                 $product = $em->getRepository('App\Entity\Slave\Product')->findOneBy(array('codeProducer' => $request->request->get('code')));
  3645.                 break;
  3646.             case 'supplier_withdraw':
  3647.             case 'supplier_installation':
  3648.             case 'supplier_actual':
  3649.                 $product = $em->getRepository('App\Entity\Slave\Product')->findOneBy(array('codeSupplier' => $request->request->get('code')));
  3650.                 break;
  3651.             default: break;
  3652.         }
  3654.         $found = false;
  3655.         $json = '{';
  3657.         if($product != null){
  3658.             $found = true;
  3659.             $posAccessoryOk = false;
  3660.             $supplierOk = false;    
  3661.             $canMove = true;
  3662.             $editSuppliers = false;
  3664.             if($product->getModel()->isPos() == $interventionActivityType->isPos())
  3665.                 $posAccessoryOk = true;
  3667.             // Controllo se il fornitore del ticket è tra quelli del prodotto
  3668.             foreach($product->getSuppliers() as $supplier){
  3669.                 if($ticket->getSupplier()->getId() == $supplier->getId()){
  3670.                     $supplierOk = true;
  3671.                     break;
  3672.                 }
  3673.             }
  3674.             if(!$supplierOk){
  3675.                 foreach($product->getSuppliers() as $supplier){
  3676.                     if(!$supplier->isInterventionActive()){
  3677.                         $editSuppliers = true;
  3678.                         break;
  3679.                     }
  3680.                 }
  3681.             }
  3683.             // Controllo se posso spostare il prodotto
  3684.             switch($request->request->get('type')){
  3685.                 case 'producer_withdraw':
  3686.                 case 'supplier_withdraw':
  3687.                 case 'producer_actual':
  3688.                 case 'supplier_actual':
  3689.                     $warehouse = $ticket->getClient()->getWarehouse();
  3690.                     break;
  3691.                 case 'producer_installation':
  3692.                 case 'supplier_installation':
  3693.                     $warehouse = $intervention->getWarehouse();
  3694.                     if($product->getStatus()->getSlug() != 'available')
  3695.                         $canMove = false;
  3696.                     break;
  3697.                 default: break;
  3698.             }
  3700.             $json.= '"id":"'.$product->getId().'", "model":'.json_encode($product->getModel()->getName()).', "codeProducer":"'.$product->getCodeProducer().'", "codeSupplier":"'.$product->getCodeSupplier().'", "supplierOk":"'.$supplierOk.'", "editSuppliers":"'.$editSuppliers.'", "posAccessoryOk":"'.$posAccessoryOk.'",';
  3701.         
  3702.             if($product->getActualWarehouse()->getId() == $warehouse->getId())
  3703.                 $json.= '"otherWarehouse":"0", "type":"", "warehouse":"", "otherWarehouseId":"", "otherWarehouseNickname":"", "canMove":"'.$canMove.'"';
  3704.             else
  3705.                 $json.= '"otherWarehouse":"1","type":"'.$request->request->get('type').'","warehouse":"'.$warehouse->getId().'", "otherWarehouseId":"'.$product->getActualWarehouse()->getId().'", "otherWarehouseNickname":"'.$product->getActualWarehouse()->getNickname().'", "canMove":"'.$canMove.'"';
  3706.             
  3707.         }
  3708.         $json.= '}';
  3710.         return new Response(json_encode(array("code" => 200, "success" => true, "found" => $found, "product" => $json)));
  3711.     }
  3713.     /**
  3714.      * @Route("/scheda/intervento/attivita-prodotto-cerca", name="user_ticket_intervention_activity_product_search")
  3715.      * @Security("is_granted('edit', 'ticket')")
  3716.      */
  3717.     public function userTicketInterventionActivityProductSearch(Request $request)
  3718.     {    
  3719.         $em = $this->mr->getManager('slave');
  3720.         $session = $request->getSession();
  3721.         $activityType = $em->getRepository("App\Entity\Slave\InterventionActivityType")->findOneById($request->request->get('activityTypeId'));
  3722.         $ticket = $em->getRepository("App\Entity\Slave\Ticket")->findOneById($request->request->get('ticketId'));
  3723.         $intervention = $em->getRepository("App\Entity\Slave\Intervention")->findOneById($request->request->get('interventionId'));
  3725.         $type = $request->request->get('type');
  3726.         $filter = $request->request->get('filter');
  3727.         $isPos = $request->request->get('isPos');
  3728.         $products = array();
  3730.         if($type == 'installation')
  3731.             $products = $em->getRepository('App\Entity\Slave\Product')->findByWarehouseSupplierAndIsPosWithFilter($intervention->getWarehouse()->getId(), $ticket->getSupplier()->getId(), $isPos, $filter);
  3732.         
  3733.         if($type == 'actual' || $type == 'withdraw')
  3734.             $products = $em->getRepository('App\Entity\Slave\Product')->findByWarehouseSupplierAndIsPosWithFilter($ticket->getClient()->getWarehouse()->getId(), $ticket->getSupplier()->getId(), $isPos, $filter);
  3736.         $first = true;
  3737.         $json = "[";
  3738.         foreach($products as $p){
  3739.             if($first) $first = false; else $json.= ',';
  3740.             $codeProducer = '"---"'; if($p->getCodeProducer() != null && $p->getCodeProducer() != '') $codeProducer = json_encode($p->getCodeProducer());
  3741.             $codeSupplier = '"---"'; if($p->getCodeSupplier() != null && $p->getCodeSupplier() != '') $codeSupplier = json_encode($p->getCodeSupplier());
  3742.             $json.= '{"id":'.$p->getId().', "modelName":'.json_encode($p->getModel()->getName()).', "codeProducer":'.$codeProducer.', "codeSupplier":'.$codeSupplier.'}';
  3743.         }
  3744.         $json.= "]";
  3745.         
  3746.         return new Response(json_encode(array("code" => 200, "success" => true, "products" => $json)));
  3747.     }
  3748.     
  3749.     /**
  3750.      * @Route("/scheda/intervento/attivita-modello-cerca", name="user_ticket_intervention_activity_model_search")
  3751.      * @Security("is_granted('edit', 'ticket')")
  3752.      */
  3753.     public function userTicketInterventionActivityModelSearch(Request $request)
  3754.     {    
  3755.         $em = $this->mr->getManager('slave');
  3756.         $session = $request->getSession();
  3757.         $activityType = $em->getRepository("App\Entity\Slave\InterventionActivityType")->findOneById($request->request->get('activityTypeId'));
  3758.         $isPos = $request->request->get('isPos');
  3759.         $filter = $request->request->get('filter');
  3760.         $interventionId = $request->request->get('interventionId');
  3761.         $intervention = $em->getRepository("App\Entity\Slave\Intervention")->findOneById($interventionId);
  3762.         
  3763.         $supplier = $intervention->getTicket()->getSupplier();
  3764.         $models = $em->getRepository('App\Entity\Slave\ProductModel')->findAllowedPosModel($isPos, $filter, $supplier);
  3765.                 
  3766.         $first = true;
  3767.         $json = "[";
  3768.         foreach($models as $m){
  3769.             if($first) $first = false; else $json.= ',';
  3770.             $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()).'}';
  3771.         }
  3772.         $json.= "]";
  3773.       
  3774.         return new Response(json_encode(array("code" => 200, "success" => true, "models" => $json)));
  3775.     }
  3777.     /**
  3778.      * @Route("/scheda/intervento/attivita-modello-componenti", name="user_ticket_intervention_activity_model_components")
  3779.      * @Security("is_granted('edit', 'ticket')")
  3780.      */
  3781.     public function userTicketInterventionActivityModelComponents(Request $request)
  3782.     {    
  3783.         $em = $this->mr->getManager('slave');
  3784.         $session = $request->getSession();
  3785.         $activityType = $em->getRepository("App\Entity\Slave\InterventionActivityType")->findOneById($request->request->get('activityTypeId'));
  3786.         $model = $em->getRepository('App\Entity\Slave\ProductModel')->findOneById($request->request->get('modelId'));
  3787.                 
  3788.         $first = true;
  3789.         $json = "[";
  3790.         if($model != null){
  3791.             foreach($model->getComponents() as $c){
  3792.                 if($first) $first = false; else $json.= ',';
  3793.                 $json.= '{"id":"'.$c->getId().'", "name":"'.$c->getName().'"}';
  3794.             }
  3795.         }
  3796.         $json.= "]";
  3797.       
  3798.         return new Response(json_encode(array("code" => 200, "success" => true, "components" => $json)));
  3799.     }
  3801.     /**
  3802.      * @Route("/scheda/intervento/{interventionId}/attivita-sposta-prodotto", name="user_ticket_intervention_activity_move_product")
  3803.      * @Security("is_granted('edit', 'ticket')")
  3804.      */
  3805.     public function userTicketInterventionActivityMoveProduct(Request $request, $interventionId)
  3806.     {
  3807.         $em = $this->mr->getManager('slave');
  3808.         $session = $request->getSession();
  3809.         $type = $request->request->get('type');
  3810.         $product = $em->getRepository('App\Entity\Slave\Product')->findOneById($request->request->get('productId'));
  3811.         $oldStatus = $product->getStatus();
  3812.         $intervention = $em->getRepository('App\Entity\Slave\Intervention')->findOneById($interventionId);
  3813.         if($type == "installation"){
  3814.             $statusNew = $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'available'));
  3815.             $warehouse = $intervention->getWarehouse();
  3816.             $product->setTermid(null);
  3817.             $product->setStatus($statusNew);
  3818.         }
  3819.         else{
  3820.             $statusNew = $em->getRepository('App\Entity\Slave\ProductStatus')->findOneBy(array('slug' => 'in_use'));
  3821.             $warehouse = $intervention->getTicket()->getClient()->getWarehouse();
  3822.             $product->setTermid($intervention->getTicket()->getTermid());
  3823.             $product->setStatus($statusNew);
  3824.         }
  3825.         
  3826.         if($oldStatus->getId() != $statusNew->getId())
  3827.             ProductService::createProductLog($em, $product, $this->getUser(), null, 'status', $statusNew->getValue(), $oldStatus->getValue());
  3829.         ProductService::createProductTransferLog($em, $product, null, $this->getUser(), $warehouse, new \Datetime(), 'forced');
  3830.         $product->setActualWarehouse($warehouse);
  3831.         $product->setDateLastTransfer(new \Datetime());
  3832.         $product->isToManage(false);
  3833.         $product->setToManagePriority(0);
  3834.         $em->flush();
  3835.         return new Response(json_encode(array("code" => 200, "success" => true)));
  3836.     }
  3838.     /**
  3839.      * @Route("/{ticketId}/scheda/intervento/attivita-aggiorna-fornitori", name="user_ticket_intervention_activity_update_suppliers")
  3840.      * @Security("is_granted('edit', 'ticket')")
  3841.      */
  3842.     public function userTicketInterventionActivityUpdateSuppliers(Request $request, $ticketId)
  3843.     {
  3844.         $em = $this->mr->getManager('slave');
  3845.         $ticket = $em->getRepository('App\Entity\Slave\Ticket')->findOneById($ticketId);
  3846.         $product = $em->getRepository('App\Entity\Slave\Product')->findOneById($request->request->get('productId'));
  3847.         foreach($product->getSuppliers() as $supplier){
  3848.             if(!$supplier->isInterventionActive()){
  3849.                 $product->removeSupplier($supplier);
  3850.                 $supplier->removeProduct($product);
  3851.             }
  3852.         }
  3854.         $supplierNew = $ticket->getSupplier();
  3855.         $product->addSupplier($supplierNew);
  3856.         $supplierNew->addProduct($product);
  3857.         $em->flush();
  3858.         $json = '{"id":"'.$product->getId().'", "model":'.json_encode($product->getModel()->getName()).', "modelId":'.$product->getModel()->getId().', "codeProducer":"'.$product->getCodeProducer().'", "codeSupplier":"'.$product->getCodeSupplier().'"}';
  3859.         return new Response(json_encode(array("code" => 200, "success" => true, "json" => $json)));
  3860.     }
  3861.     
  3862.     /**
  3863.      * @Route("/{interventionId}/scheda/intervento/dettagli", name="user_ticket_intervention")
  3864.      * @Security("is_granted('edit', 'ticket')")
  3865.      */
  3866.     public function userTicketIntervention($interventionId, Request $request, ValidatorInterface $validator, FormFactoryInterface $formFactory, FileSystem $fs, MailerInterface $mailer)
  3867.     {    
  3868.         $em = $this->mr->getManager('slave');
  3869.         $emMaster = $this->mr->getManager('master');
  3870.         $session = $request->getSession();
  3871.         $company = $emMaster->getRepository('App\Entity\Master\Company')->findOneById($session->get('companyId'));
  3872.         $intervention = $em->getRepository("App\Entity\Slave\Intervention")->findOneById($interventionId);
  3873.         $ticket = $intervention->getTicket();
  3875.         $settingBillingMonthDefault = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'ticket_intervention_billing_month_default'));
  3876.         $settingCompletedDefault = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'outcome_completed_default'));
  3877.         $outcomeCompletedDefault = $em->getRepository('App\Entity\Slave\InterventionOutcome')->findOneById($settingCompletedDefault->getValue());
  3879.         $form = $formFactory->createNamed("form_intervention", InterventionType::class, $intervention, array('typeSlug' => $intervention->getOutcomeType()->getSlug()));
  3880.         $form->handleRequest($request);
  3882.         if($form->isSubmitted()){
  3884.             [$valid, $interventionOutcome] = FormValidatorService::validateIntervention($em, $validator, $form, $intervention->getOutcomeType()->getSlug());
  3886.             if($valid && $form->isValid()){
  3888.                 $intervention->setTechnician($ticket->getTechnician());
  3889.                 $intervention->setOperator($this->getUser());
  3890.                 if($intervention->getOutcomeType()->getSlug() == "completed"){
  3891.                     $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());
  3892.                     switch($settingBillingMonthDefault->getValue()){
  3893.                         case 'intervention': $datetimeBilling = clone($datetime); break;
  3894.                         case 'epos': $datetimeBilling = new Datetime(); break;
  3895.                         default: break;
  3896.                     }
  3897.                     $intervention->setDatetimeBilling($datetimeBilling);
  3898.                 }
  3899.                 else
  3900.                     $datetime = new \Datetime();
  3901.                
  3902.                 $intervention->setDatetime($datetime);
  3903.                 $intervention->setMotivation($form->get("motivation")->getData());
  3904.                 $em->persist($intervention);
  3906.                 switch($intervention->getOutcomeType()->getSlug()){
  3907.                     case 'suspended':
  3908.                     case 'empty':
  3909.                         // Inserisco la sospensione del ticket
  3910.                         $suspension = new TicketSuspension();
  3911.                         $suspension->setTicket($ticket);
  3912.                         $suspension->setIntervention($intervention);
  3913.                         $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()));
  3914.                         if($form->get('dateTo')->getData() != null && $form->get('timeToHour')->getData() != null && $form->get('timeToMinute')->getData() != null){
  3915.                             $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()));
  3916.                         }
  3917.                         $em->persist($suspension);
  3918.                         // Aggiorno dati intervento
  3919.                         if($interventionOutcome->isReferentRequired()) $intervention->setReferent($form->get("referent")->getData());
  3920.                         if($interventionOutcome->isPhoneRequired()) $intervention->setPhone($form->get("phone")->getData());
  3921.                         if($interventionOutcome->isPhotoRequired()) {
  3922.                             $uploadDir = $this->params->get('kernel.project_dir').'/'.$this->params->get('web_path').'/companies/'.$company->getDirectoryPath().'/tickets/'.$ticket->getDirectoryPath().'/';
  3923.                             MediaService::uploadImage($fs, $form->get('file')->getData(), null, $uploadDir, $intervention, 'photo', 100, 1000, 200, true);
  3924.                         }
  3925.                         // SE empty -> Aggiungo costo UAV
  3926.                         if($intervention->getOutcomeType()->getSlug() == 'empty'){
  3927.                             $amountTechnician = null;
  3928.                             // Cerco tra gli UAV di quella provincia e di quell'utente
  3929.                             if($ticket->getUAVOperationTariffAmount() != null){
  3930.                                 foreach($ticket->getUAVOperationTariffAmount()->getTechnicianAreas() as $jttaota){
  3931.                                     if($jttaota->getTechnicianArea()->getUser()->getId() == $ticket->getTechnician()->getId()){
  3932.                                         $amountTechnician = $jttaota->getAmount();
  3933.                                         break;
  3934.                                     }
  3935.                                 }
  3936.                             }
  3937.                             // SE non ho risultati -> Fuori zona metto 0.00
  3938.                             if($amountTechnician == null){
  3939.                                 $amountTechnician = '0.00';
  3940.                             }
  3941.                             $intervention->setAmount($ticket->getUAVOperationTariffAmount()->getAmount());
  3942.                             $intervention->setAmountTechnician($amountTechnician);
  3943.                         }
  3944.                         // Se account agenzia che gestisce -> approvo automaticamente sospensione --- Altrimenti metto in richiesta sospensione
  3945.                         if($this->getUser()->getAccountTypology() == 'agency' || $this->getUser()->getAccountTypology() == 'warehouse'){
  3946.                             $suspension->setApproved(true);
  3947.                             $suspension->setManaged(true);
  3948.                     
  3949.                             $settingUnlockSameTech = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'ticket_suspension_unlock_same_technician'));
  3950.                             if($settingUnlockSameTech->getValue() != 1){
  3951.                                 TicketService::createTicketLog($em, $this->getUser(), $ticket, "ct", $ticket->getTechnician(), null);
  3952.                                 $ticket->setTechnician(null);
  3953.                             }
  3954.                             $ticketStatus = $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'suspended'));
  3955.                         }
  3956.                         else{
  3957.                             $ticketStatus = $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'suspension_request'));
  3958.                             if($intervention->getOutcomeType()->getSlug() == "suspended"){
  3959.                                 $settingAgencyEmail = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'ticket_suspension_agency_email'));
  3960.                                 $subject = $this->params->get('subject_ticket_suspension_request');
  3961.                                 $template = "email/ticket/suspension_request.html.twig";
  3962.                             }
  3963.                             else{
  3964.                                 $settingAgencyEmail = $em->getRepository('App\Entity\Slave\Setting')->findOneBy(array('slug' => 'ticket_uav_agency_email'));
  3965.                                 $subject = $this->params->get('subject_ticket_uav_request');
  3966.                                 $template = "email/ticket/uav_request.html.twig";
  3967.                             }
  3968.                             if($settingAgencyEmail->getValue() != null){
  3969.                                 $emails = preg_split('/\,/', $settingAgencyEmail->getValue());
  3970.                                 foreach($emails as $email){
  3971.                                     $message = (new TemplatedEmail())
  3972.                                         ->subject($subject.' '.$ticket->getNumber())
  3973.                                         ->from($this->params->get('email_noreply'))
  3974.                                         ->to(rtrim(ltrim($email, " ")," "))
  3975.                                         ->htmlTemplate($template)
  3976.                                         ->context(['company' => $company, 'ticket' => $ticket, 'suspension' => $suspension]);
  3977.                                     $mailer->send($message);
  3978.                                 }
  3979.                             }
  3980.                         }
  3981.                         // Aggiorno stato ticket
  3982.                         TicketService::createTicketLog($em, $this->getUser(), $ticket, "cs", $ticket->getStatus(), $ticketStatus->getValue());
  3983.                         $ticket->setStatus($ticketStatus);
  3984.                         break;
  3985.                     case 'completed': 
  3986.                         // Chiudo il ticket
  3987.                         $statusClosed = $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBy(array('slug' => 'closed'));
  3988.                         TicketService::createTicketLog($em, $this->getUser(), $ticket, "cs", $ticket->getStatus(), $statusClosed->getValue());
  3989.                         $ticket->setStatus($statusClosed);
  3990.                         $ticket->setDatetimeEnd($intervention->getDatetime());
  3992.                         // Cerco la jt del tecnico-operazione nell'area e setto l'amount
  3993.                         $amountTechnician = null;
  3994.                         foreach($ticket->getOperationTariffAmount()->getTechnicianAreas() as $jttaota){
  3995.                             if($jttaota->getTechnicianArea()->getUser()->getId() == $ticket->getTechnician()->getId()){
  3996.                                 $amountTechnician = $jttaota->getAmount();
  3997.                                 break;
  3998.                             }
  3999.                         }
  4000.                         // Se non la trovo -> Fuori zona metto 0.00
  4001.                         if($amountTechnician == null){
  4002.                             $amountTechnician = '0.00';
  4003.                         }
  4004.                         $intervention->setAmount($ticket->getOperationTariffAmount()->getAmount());
  4005.                         $intervention->setAmountTechnician($amountTechnician);
  4006.                 
  4007.                         $this->addFlash('notice_success', 'Ticket completato!');
  4008.                         break;
  4009.                     default: break;
  4010.                 }
  4011.                 $em->flush();
  4013.                 $session->set('interventionId', $intervention->getId());
  4014.                 return $this->redirectToRoute('user_ticket_sheet', array('ticketId' => $ticket->getId()));
  4015.             }
  4016.         }
  4018.         return $this->render('role/user/ticket/intervention/intervention.html.twig', array(
  4019.             'ticket' => $ticket,
  4020.             'intervention' => $intervention,
  4021.             'outcomeCompletedDefault' => $outcomeCompletedDefault,
  4022.             'form' => $form->createView()
  4023.         ));
  4024.     }
  4026.     /**
  4027.      * @Route("/scheda/intervento/esito-aggiorna", name="user_ticket_intervention_outcome_update")
  4028.      * @Security("is_granted('edit', 'ticket')")
  4029.      */
  4030.     public function userTicketInterventionOutcomeUpdate(Request $request)
  4031.     {    
  4032.         $em = $this->mr->getManager('slave');
  4033.         $interventionOutcome = $em->getRepository('App\Entity\Slave\InterventionOutcome')->findOneById($request->request->get("outcomeId"));
  4034.         return new Response(json_encode(array(
  4035.             "code" => 200,
  4036.             "success" => true,
  4037.             "suspensionTo" => $interventionOutcome->isSuspensionToRequired(),
  4038.             "referent" => $interventionOutcome->isReferentRequired(),
  4039.             "motivation" => $interventionOutcome->isMotivationRequired(),
  4040.             "phone" => $interventionOutcome->isPhoneRequired(),
  4041.             "photo" => $interventionOutcome->isPhotoRequired()
  4042.         ))); 
  4043.     }
  4045.     /**
  4046.      * @Route("/sistema-duplicati", name="user_ticket_duplicate_to_wrong")
  4047.      */        
  4048.     public function userTicketDuplicateToWrong(Request $request)
  4049.     {    
  4050.         $em = $this->mr->getManager('slave');
  4052.         $wrongStatus = $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBySlug("wrong");
  4053.         $tickets = $em->getRepository('App\Entity\Slave\Ticket')->findAll();
  4054.         $ticketId = null;
  4055.         $skipId = array();
  4056.         $wrongTicketArray = array();
  4057.         foreach($tickets as $ticket){
  4058.             $ticketId = $ticket->getId();
  4059.             if(!in_array($ticketId, $skipId)){
  4060.                 foreach($tickets as $innerTicket){
  4061.                     if($ticketId != $innerTicket->getId() && $ticket->getNumber() == $innerTicket->getNumber() && $ticket->getTermid()->getCode() == $innerTicket->getTermid()->getCode() && $innerTicket->getStatus()->getId() < 4){
  4062.                         array_push($skipId, $innerTicket->getId());
  4063.                         array_push($wrongTicketArray, $ticket);
  4064.                     }
  4065.                 }
  4066.             }
  4067.         }
  4069.         foreach($wrongTicketArray as $wt){
  4070.             TicketService::createTicketLog($em, $this->getUser(), $ticket, "cs", $wt->getStatus(), $wrongStatus->getValue());
  4071.             $wt->setStatus($wrongStatus);
  4072.         }
  4073.         $em->flush();
  4075.         return $this->redirectToRoute("user_ticket_list");
  4076.     }
  4078.     /**
  4079.      * @Route("/sposta-temp", name="user_ticket_move_to_temp")
  4080.      */
  4081.     public function userTicketmoveToTemp(Request $request)
  4082.     {    
  4083.         $em = $this->mr->getManager('slave');
  4084.         $tempStatus = $em->getRepository('App\Entity\Slave\TicketStatus')->findOneBySlug("temp");
  4085.         $ticketArray = [];
  4087.         foreach($ticketArray as $array){
  4088.             $ts = $em->getRepository('App\Entity\Slave\Ticket')->findAllByNumber($array[0]);
  4089.             foreach($ts as $t){
  4090.                 if($t->getTermid()->getCode() == $array[1] && $t->getStatus()->getId() < 4){
  4091.                     TicketService::createTicketLog($em, $this->getUser(), $ticket, "cs", $t->getStatus(), $tempStatus->getValue());
  4092.                     $t->setStatus($tempStatus);
  4093.                 }
  4094.             }
  4095.         }
  4097.         $em->flush();
  4098.         return $this->redirectToRoute("user_ticket_list");
  4099.     }
  4100. }