src/Controller/User/UserUserController.php line 85

Open in your IDE?
  1. <?php
  3. namespace App\Controller\User;
  5. use App\Entity\Slave\JoinTableTechnicianAreaOperationTariffAmount;
  6. use App\Entity\Slave\JoinTableTechnicianOperationDefault;
  7. use App\Entity\Slave\JoinTableUserSupplier;
  8. use App\Entity\Slave\JoinTableUserWarehouse;
  9. use App\Entity\Slave\TechnicianArea;
  10. use App\Entity\Slave\User;
  11. use App\Entity\Slave\UserDocument;
  12. use App\Entity\Slave\UserProfile;
  13. use App\Entity\Slave\UserHoliday;
  14. use App\Form\Default\PasswordChangeType;
  15. use App\Form\Model\PasswordChange;
  16. use App\Form\Master\CompanyAccessType;
  17. use App\Form\Slave\JoinTableUserSupplierType;
  18. use App\Form\Slave\JoinTableUserSupplierAutoAssignType;
  19. use App\Form\Slave\JoinTableUserWarehouseNewType;
  20. use App\Form\Slave\JoinTableUserWarehouseEditType;
  21. use App\Form\Slave\JoinTableTechnicianAreaOperationTariffAmountCloneType;
  22. use App\Form\Slave\TechnicianAreaType;
  23. use App\Form\Slave\TechnicianEconomicType;
  24. use App\Form\Slave\UserProfileEditType;
  25. use App\Form\Slave\UserDocumentNewType;
  26. use App\Form\Slave\UserDocumentEditType;
  27. use App\Form\Slave\UserHolidayType;
  28. use App\Form\Slave\UserProfileType;
  29. use App\Form\Slave\UserStaffType;
  30. use App\Form\Slave\UserTechnicianType;
  31. use App\Service\FilterService;
  32. use App\Service\FormValidatorService;
  33. use App\Service\MediaService;
  34. use App\Service\TechnicianTariffService;
  35. use App\Service\ValidationService;
  36. use Doctrine\Persistence\ManagerRegistry;
  37. use Knp\Component\Pager\PaginatorInterface;
  38. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  39. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  40. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Security;
  41. use Spipu\Html2Pdf\Html2Pdf;
  42. use Symfony\Bridge\Twig\Mime\TemplatedEmail;
  43. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  44. use Symfony\Component\DependencyInjection\ParameterBag\ParameterBagInterface;
  45. use Symfony\Component\Filesystem\Filesystem;
  46. use Symfony\Component\Form\FormError;
  47. use Symfony\Component\Form\FormFactoryInterface;
  48. use Symfony\Component\HttpFoundation\Request;
  49. use Symfony\Component\HttpFoundation\Response;
  50. use Symfony\Component\HttpFoundation\StreamedResponse;
  51. use Symfony\Component\HttpFoundation\ResponseHeaderBag;
  52. use Symfony\Component\Mailer\MailerInterface;
  53. use Symfony\Component\PasswordHasher\Hasher\UserPasswordHasherInterface;
  54. use Symfony\Component\Routing\Annotation\Route;
  55. use Symfony\Component\Validator\Validator\ValidatorInterface;
  56. use Symfony\Component\Validator\Constraints as Assert;
  58. /**
  59.  * @Route("/scrivania/utenti")
  60.  * @Security("is_granted('ROLE_USER') and is_granted('active', user)")
  61.  */
  62. class UserUserController extends AbstractController
  63. {
  64.     private $mr;
  65.     private $params;
  67.     public function __construct(ManagerRegistry $mr, ParameterBagInterface $params)
  68.     {
  69.         $this->mr = $mr;
  70.         $this->params = $params;
  71.     }
  72.     
  73.     /**
  74.      * @Route("/", name="user_users_index")
  75.      * @Security("is_granted('view', 'staff') || is_granted('view', 'technician')")
  76.      */
  77.     public function userUsersIndex(Request $request, FormFactoryInterface $formFactory, ValidatorInterface $validator)
  78.     {           
  79.         return $this->render('role/user/users/index.html.twig');
  80.     }
  82.     /**
  83.      * @Route("/profilo", name="user_user_profile")
  84.      */
  85.     public function userUserProfile(Request $request, UserPasswordHasherInterface $passwordHasher, FormFactoryInterface $formFactory, ValidatorInterface $validator)
  86.     {    
  87.         $em = $this->mr->getManager('slave');
  88.         $emMaster = $this->mr->getManager('master');
  89.         $session = $request->getSession();
  90.         $company = $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get("companyId"));
  91.         $cities = $emMaster->getRepository("App\Entity\Master\City")->findByName('');
  92.         $zip = $emMaster->getRepository('App\Entity\Master\Zip')->findOneByCode($this->getUser()->getProfile()->getZip());
  93.         $operationGroups = $em->getRepository('App\Entity\Slave\OperationGroup')->findAllOrderedByUav();
  94.         $profile = $this->getUser()->getProfile();
  95.         // EDIT DATA
  96.         $formData = $formFactory->createNamed("user_profile", UserProfileEditType::class, $profile);
  97.         $formData->handleRequest($request);
  99.         if($formData->isSubmitted()){
  100.             if($formData->isValid()){
  102.                 $newZip = $emMaster->getRepository('App\Entity\Master\Zip')->findOneById($formData->get('zip')->getData());
  103.                 $profile->setIdCity($formData->get('cityId')->getData());
  104.                 $profile->setZip($newZip->getCode());
  106.                 $this->addFlash('notice_success', 'Modifiche salvate!');
  107.                 $em->flush();
  108.                 return $this->redirectToRoute('user_user_profile');
  109.             }
  110.             else{
  111.                 $session->set('openModalData', true);
  112.             }
  113.         }
  115.         // PASSWORD CHANGE
  116.         $passwordChange = new PasswordChange();
  117.         $formPassword = $this->createForm(PasswordChangeType::class, $passwordChange);
  118.         $formPassword->handleRequest($request);
  120.         if($formPassword->isSubmitted()){
  121.             
  122.             $valid = true;
  124.             $valid = ValidationService::validateNotBlank($validator, $formPassword->get('oldPassword'));
  126.             if($formPassword->get('newPassword')->getData() != null){
  127.                 $psw = $formPassword->get('newPassword')->getData();
  128.                 $count = 0;
  129.                 if(preg_match('/[0-9]/', $psw)) $count++;
  130.                 if(preg_match('/[a-z]/', $psw)) $count++;
  131.                 if(preg_match('/[A-Z]/', $psw)) $count++;
  132.                 if(preg_match('/[\!\#\$\&\(\)\.\+\-_]/', $psw)) $count++;
  133.                 if($count < 3)
  134.                 {
  135.                     $formPassword->get('newPassword')->addError(new FormError("Inserisci una password RESISTENTE."));
  136.                     $valid = false;
  137.                 }
  138.             }
  140.             if($valid && $formPassword->isValid()){
  141.                 if($passwordHasher->isPasswordValid($this->getUser(), $formPassword->get('oldPassword')->getData())){
  142.                     $newPassword = $passwordHasher->hashPassword($this->getUser(), $formPassword->get("newPassword")->getData());
  143.                     $this->getUser()->setPassword($newPassword);
  144.                     $em->flush();
  145.                     
  146.                     $this->addFlash('notice_success', "La password รจ stata modificata con successo");
  147.                     
  148.                     return $this->redirect($request->server->get('HTTP_REFERER'));
  149.                 }
  150.                 else{
  151.                     $formPassword->get('oldPassword')->addError(New FormError('La password non coincide con quella salvata'));
  152.                     $session->set('openModalPassword', true);
  153.                 }
  154.             }
  155.             else{
  156.                 $session->set('openModalPassword', true);
  157.             }
  158.         }
  160.         $jttaotas = array();
  161.         foreach($this->getUser()->getTechnicianAreas() as $ta){
  162.             $jts = $em->getRepository('App\Entity\Slave\JoinTableTechnicianAreaOperationTariffAmount')->findByTechnicianAndProvinceOrderedBySupplierAndOperation($this->getUser()->getId(), $ta->getIdProvince());
  163.             $tmp = array();
  164.             array_push($tmp, $ta->getIdProvince(), $jts);
  165.             array_push($jttaotas, $tmp);
  166.         }
  168.         return $this->render('role/user/users/profile.html.twig', array(
  169.             'company' => $company,
  170.             'zip' => $zip,
  171.             'cities' => $cities,
  172.             'operationGroups' => $operationGroups,
  173.             'jttaotas' => $jttaotas,
  174.             'formData' => $formData->createView(),
  175.             'formPassword' => $formPassword->createView()
  176.         ));
  177.     }
  178.     
  179.     /**
  180.      * @Route("/profilo/imposta-principale", name="user_user_profile_main")
  181.      */
  182.     public function userUserProfileMain(Request $request)
  183.     {
  184.         $em = $this->mr->getManager();
  185.         $jtuw = $em->getRepository('App\Entity\Slave\JoinTableUserWarehouse')->findOneById($request->request->get('jtuwId'));
  186.         foreach($this->getUser()->getWarehouses() as $jt)
  187.             $jt->setMain(false);
  188.         $jtuw->setMain(true);
  189.         $em->flush();
  191.         $this->addFlash('notice_success', "Magazzino principale aggiornato");
  192.         return $this->redirectToRoute('user_user_profile');
  193.     }
  195.     /**
  196.      * @Route("/profilo/economico-esporta", name="user_user_profile_economic_export")
  197.      */
  198.     public function userUserProfileEconomicExport(Request $request)
  199.     {
  200.         $em = $this->mr->getManager('slave');
  201.         $emMaster = $this->mr->getManager('master');
  202.         $session = $request->getSession();
  204.         $year = $request->request->get('year');
  205.         $month = $request->request->get('month');
  206.         $allInterventions = $em->getRepository("App\Entity\Slave\Intervention")->findByTechnicianToPayByYearAndMonth($this->getUser()->getId(), $year, $month);
  208.         // Rimuovo gli interventi che hanno una sospensione -> Gestita e non approvata / Non gestita
  209.         $interventions = array();
  210.         foreach($allInterventions as $int){
  211.             $toCalculate = true;
  212.             if($int->getSuspension() != null && ($int->getSuspension()->isManaged() == false || $int->getSuspension()->isApproved() == false))
  213.                 $toCalculate = false;
  215.             if($toCalculate)
  216.                 array_push($interventions, $int);
  217.         }
  219.         $response = new StreamedResponse();
  220.         $response->setCallback(function() use($emMaster, $interventions) {
  221.             $handle = fopen('php://output', 'w+');
  222.             fputcsv($handle, array('Provincia','Citta','CAP','Operazione','Ticket','Cliente','Term ID','Data/Ora','Esito','Attivita svolte','Paga intervento'), ";", '"', "\\");
  223.             
  224.             $provinceSign = '';
  225.             $cityName = '';
  226.             $zip = '';
  227.             $operation = '';
  228.             $ticket = '';
  229.             $client = '';
  230.             $termid = '';
  231.             $datetime = '';
  232.             $outcome = '';
  233.             $total = 0;
  234.             $totalTotal = 0;
  235.             foreach($interventions as $int){
  236.             
  237.                 $provinceSign = $emMaster->getRepository('App\Entity\Master\Province')->findOneById($int->getTicket()->getIdProvince())->getSign();
  238.                 $cityName = $emMaster->getRepository('App\Entity\Master\City')->findOneById($int->getTicket()->getIdCity())->getName();
  239.                 $zip = $int->getTicket()->getZip();
  240.                 $operation = $int->getTicket()->getOperation();
  241.                 $ticket = $int->getTicket()->getNumber();
  242.                 $client = $int->getTicket()->getClient();
  243.                 $termid = $int->getTicket()->getTermid();
  244.                 $datetime = $int->getDatetime()->format('d-m-Y H:i');
  245.                 $outcome = $int->getOutcomeType().' - '.$int->getOutcome();
  246.                 $activities = '';
  247.                 $first = true;
  248.                 foreach($int->getActivities() as $act){
  249.                     if($first) $first = false; else $activities.= ' --- ';
  250.                     if($act->getProductWithdraw() != null){
  251.                         $pr = $act->getProductWithdraw();
  252.                         $codeProd = $act->getProducerWithdraw();
  253.                         $codeSupp = $act->getSupplierWithdraw();
  254.                     }
  255.                     if($act->getProductActual() != null){
  256.                         $pr = $act->getProductActual();
  257.                         $codeProd = $act->getProducerActual();
  258.                         $codeSupp = $act->getSupplierActual();
  259.                     }
  260.                     if($act->getProductInstallation() != null){
  261.                         $pr = $act->getProductInstallation();
  262.                         $codeProd = $act->getProducerInstallation();
  263.                         $codeSupp = $act->getSupplierInstallation();
  264.                     }
  265.                     $activities.= $act->getType();
  266.                 }
  267.                 $total = $int->calculateTotalTechnicianAmount();
  268.                 $totalTotal = $totalTotal + $total;
  269.                 fputcsv($handle, array($provinceSign, $cityName, $zip, $operation, $ticket, $client, $termid, $datetime, $outcome, $activities, number_format($total, 2, '.', ',')), ";", '"', "\\");
  270.             }
  271.             fputcsv($handle, array('Totale', '', '', '', '', '', '', '', '', '', number_format($totalTotal, 2, '.', ',')), ";", '"', "\\");
  272.             fclose($handle);
  273.         });
  274.     
  275.         $response->setStatusCode(200);
  276.         $dispositionHeader = $response->headers->makeDisposition(ResponseHeaderBag::DISPOSITION_ATTACHMENT, 'Profilo economico '.$this->getUser().' --- '.$year.'-'.$month.'.csv');
  277.         $response->headers->set('Content-Type', 'text/csv; charset=ISO-8859-15');
  278.         $response->headers->set('Content-Disposition', $dispositionHeader);
  279.         return $response;
  280.     }
  282.     /**
  283.      * @Route("/profilo/economico-crea-pdf", name="user_user_profile_economic_pdf")
  284.      */
  285.     public function userUserProfileEconomicPdf(Request $request)
  286.     {
  287.         $em = $this->mr->getManager('slave');
  288.         $emMaster = $this->mr->getManager('master');
  289.         $session = $request->getSession();
  290.         $company = $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get("companyId"));
  292.         $year = $request->request->get('year');
  293.         $month = $request->request->get('month');
  294.         $allInterventions = $em->getRepository("App\Entity\Slave\Intervention")->findByTechnicianToPayByYearAndMonth($this->getUser()->getId(), $year, $month);
  296.         // Rimuovo gli interventi che hanno una sospensione -> Gestita e non approvata / Non gestita
  297.         $interventions = array();
  298.         foreach($allInterventions as $int){
  299.             $toCalculate = true;
  300.             if($int->getSuspension() != null && ($int->getSuspension()->isManaged() == false || $int->getSuspension()->isApproved() == false))
  301.                 $toCalculate = false;
  303.             if($toCalculate)
  304.                 array_push($interventions, $int);
  305.         }
  306.         
  307.         $html2pdf = new Html2Pdf('P', 'A4', 'it', true, 'UTF-8', array(5, 5, 5, 5), false);
  308.         $html2pdf->writeHTML($this->renderView('role/user/print/economic.html.twig', array(
  309.             'company' => $company,
  310.             'interventions' => $interventions,
  311.             'year' => $year,
  312.             'month' => $month
  313.         )));
  314.         ob_end_clean();
  315.         
  316.         $html2pdf->Output('Profilo economico '.$this->getUser().' --- '.$year.'-'.$month.'.pdf', 'D');
  317.     }
  319.     // STAFF
  320.         /**
  321.          * @Route("/staff", name="user_users_staff")
  322.          * @Security("is_granted('view', 'staff')")
  323.          */
  324.         public function userUsersStaff(Request $request, PaginatorInterface $paginator, FormFactoryInterface $formFactory, ValidatorInterface $validator)
  325.         {    
  326.             $em = $this->mr->getManager('slave');
  327.             $emMaster = $this->mr->getManager('master');
  328.             $session = $request->getSession();
  329.             $cities = $emMaster->getRepository("App\Entity\Master\City")->findByName('');
  331.             $filters = FilterService::userFilter($request);
  332.             $usersQuery = $em->getRepository("App\Entity\Slave\User")->queryStaffUsersFiltered($filters, $this->getUser()->getId());
  333.             $users = $paginator->paginate($usersQuery, $request->getSession()->get($request->get("_route")."_page"), 50);
  335.             $user = new User();
  336.             $form = $formFactory->createNamed("user", UserStaffType::class, $user);
  337.             $form->handleRequest($request);
  339.             if($form->isSubmitted()){
  341.                 $valid = true;
  342.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('name'));
  343.                 if($valid) $valid = ValidationService::validateLength($form->get('name'), '191');
  344.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('surname'));
  345.                 if($valid) $valid = ValidationService::validateLength($form->get('surname'), '191');
  346.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('phone'));
  347.                 if($valid) $valid = ValidationService::validateLength($form->get('phone'), '191');
  348.                 if($valid) $valid = ValidationService::validateLength($form->get('address'), '191');
  349.                 if($valid) $valid = ValidationService::validateLength($form->get('civic'), '191');
  350.                 if($valid) $valid = ValidationService::validateLength($form->get('zip'), '5');
  352.                 if($valid && $form->isValid()){
  354.                     $user->setRole('ROLE_USER');
  355.                     $user->setAdminActive(true);
  356.                     $em->persist($user);
  358.                     $userProfile = new UserProfile();
  359.                     $userProfile->setUser($user);
  360.                     $userProfile->setName($form->get('name')->getData());
  361.                     $userProfile->setSurname($form->get('surname')->getData());
  362.                     $userProfile->setPhone($form->get('phone')->getData());
  363.                     if($form->get('address')->getData() != null) $userProfile->setAddress($form->get('address')->getData());
  364.                     if($form->get('civic')->getData() != null) $userProfile->setCivic($form->get('civic')->getData());
  365.                     if($form->get('zip')->getData() != null) $userProfile->setZip($emMaster->getRepository('App\Entity\Master\Zip')->findOneById($form->get('zip')->getData())->getCode());
  366.                     if($form->get('cityId')->getData() != null) $userProfile->setIdCity($form->get('cityId')->getData());
  367.                     $em->persist($userProfile);
  369.                     $em->flush();
  371.                     $this->addFlash('notice_success', "Nuovo membro dello staff inserito");
  372.                     $session->set('userId', $user->getId());
  373.                     return $this->redirectToRoute('user_users_staff');
  374.                 }
  375.                 else
  376.                     $session->set('openModal', true);
  377.             }
  379.             return $this->render('role/user/users/staff/list.html.twig', array(
  380.                 'users' => $users,
  381.                 'cities' => $cities,
  382.                 'filters' => $filters,
  383.                 'form' => $form->createView()
  384.             ));
  385.         }
  386.             
  387.         /**
  388.          * @Route("/staff/invia-credenziali", name="user_users_staff_send_credentials")
  389.          * @Security("is_granted('edit', 'staff')")
  390.          */
  391.         public function userUsersStaffSendCredentials(Request $request, MailerInterface $mailer)
  392.         {
  393.             $em = $this->mr->getManager('slave');
  394.             $emMaster = $this->mr->getManager('master');
  395.             $session = $request->getSession();
  396.             $company = $emMaster->getRepository('App\Entity\Master\Company')->findOneById($session->get('companyId'));
  397.             $user = $em->getRepository('App\Entity\Slave\User')->findOneById($request->request->get('userSendCredentialsId'));
  399.             $user->setOneTimeCode(md5(uniqid()));
  400.             $user->setExpirationOneTimeCode(date_modify(new \DateTime(), '+3 hours'));
  401.             $em->flush();
  403.             // INVIA EMAIL CON LINK PER CREARE NUOVA PASSWORD
  404.             $message = (new TemplatedEmail())
  405.                 ->from($this->params->get('email_noreply'))
  406.                 ->to($user->getEmail())
  407.                 ->subject($this->params->get('subject_create_password'))
  408.                 ->htmlTemplate('email/user_credentials.html.twig')
  409.                 ->context(['user' => $user, 'company' => $company]);
  410.             $mailer->send($message);
  412.             $this->addFlash('notice_success', 'Credenziali inviate!');
  413.             return $this->redirectToRoute('user_users_staff');
  414.         }
  416.         /**
  417.          * @Route("/{userId}/staff/scheda", name="user_users_staff_sheet")
  418.          * @Security("is_granted('view', 'staff')")
  419.          */
  420.         public function userUsersStaffSheet($userId, Request $request, FormFactoryInterface $formFactory, ValidatorInterface $validator, FileSystem $fs)
  421.         {    
  422.             $em = $this->mr->getManager('slave');
  423.             $emMaster = $this->mr->getManager('master');
  424.             $session = $request->getSession();
  425.             $user = $em->getRepository('App\Entity\Slave\User')->findOneById($userId);
  426.             $cities = $emMaster->getRepository("App\Entity\Master\City")->findByName('');
  427.             $company = $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get("companyId"));
  428.             $uploadDir = $this->params->get('kernel.project_dir').'/'.$this->params->get('web_path').'/companies/'.$company->getDirectoryPath().'/users/';
  430.             $oldZipId = null;
  431.             if($user->getProfile()->getZip() != null){
  432.                 $oldZip = $emMaster->getRepository('App\Entity\Master\Zip')->findOneByCode($user->getProfile()->getZip());
  433.                 $oldZipId = $oldZip->getId();
  434.             }
  436.             // Anagrafica
  437.             $form = $formFactory->createNamed("user_profile", UserProfileType::class, $user->getProfile());
  438.             $form->handleRequest($request);
  440.             if($form->isSubmitted()){
  442.                 $valid = true;
  443.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('email'));
  444.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('accountType'));
  445.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('cityId'));
  446.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('zip'));
  448.                 if($valid && $form->isValid()){
  450.                     $user->setAccountType($form->get('accountType')->getData());
  451.                     $user->getProfile()->setIdCity($form->get('cityId')->getData());
  452.                     $zip = $emMaster->getRepository('App\Entity\Master\Zip')->findOneById($form->get('zip')->getData());
  453.                     $user->getProfile()->setZip($zip->getCode());
  454.                     $em->flush();
  456.                     $this->addFlash('notice_success', "Modifiche salvate");
  457.                     return $this->redirectToRoute('user_users_staff_sheet', array('userId' => $user->getId()));
  458.                 }
  459.                 else
  460.                     $session->set('openModal', true);
  461.             }
  463.             // Documenti
  464.             $document = new UserDocument();
  465.             $formDocumentNew = $formFactory->createNamed("document_new", UserDocumentNewType::class, $document);
  466.             $formDocumentNew->handleRequest($request);
  467.             if($formDocumentNew->isSubmitted()){
  468.                 $valid = ValidationService::validateFile($validator, $formDocumentNew->get('path'), true, $formDocumentNew->get('file')->getData(), '5', array('pdf', 'doc', 'docx', 'jpg', 'jpeg', 'png', 'webp'));
  469.                 if($valid && $formDocumentNew->isValid()){
  470.                     $document->setUser($user);
  471.                     switch($formDocumentNew->get('file')->getData()->guessExtension()){
  472.                         case 'pdf':
  473.                         case 'doc':
  474.                         case 'docx':
  475.                             MediaService::uploadDocument($formDocumentNew->get('file')->getData(), $uploadDir, $document, 'document');
  476.                             break;
  477.                         case 'jpg':
  478.                         case 'jpeg':
  479.                         case 'png':
  480.                         case 'webp':
  481.                             MediaService::uploadImage($fs, $formDocumentNew->get('file')->getData(), null, $uploadDir, $document, 'path', 100, 1000, 200, false);
  482.                             break;
  483.                         default: break;
  484.                     }
  485.                     $em->persist($document);
  486.                     $em->flush();
  487.                     $this->addFlash('notice_success', "Documento inserito");
  488.                     return $this->redirectToRoute('user_users_staff_sheet', array('userId' => $user->getId()));
  489.                 }
  490.                 else
  491.                     $session->set('openModalDocumentNew', true);
  492.             }
  493.             
  494.             $formDocumentEdit = $formFactory->createNamed("document_edit", UserDocumentEditType::class, $document);
  495.             $formDocumentEdit->handleRequest($request);
  496.             if($formDocumentEdit->isSubmitted()){
  497.                 if($formDocumentEdit->isValid()){
  498.                     $editDocument = $em->getRepository("App\Entity\Slave\UserDocument")->findOneById($request->request->get('id'));
  499.                     $editDocument->setName($formDocumentEdit->get('name')->getData());
  500.                     $em->flush();
  501.                     $this->addFlash('notice_success', "Documento modificato");
  502.                     return $this->redirectToRoute('user_users_staff_sheet', array('userId' => $user->getId()));
  503.                 }
  504.                 else{
  505.                     $session->set('openModalDocumentEdit', true);
  506.                     $session->set('openModalDocumentEditId', $request->request->get('id'));
  507.                 }
  508.             }
  510.             return $this->render('role/user/users/staff/sheet.html.twig', array(
  511.                 'company' => $company,
  512.                 'user' => $user,
  513.                 'idZip' => $oldZipId,
  514.                 'cities' => $cities,
  515.                 'form' => $form->createView(),
  516.                 'formDocumentNew' => $formDocumentNew->createView(),
  517.                 'formDocumentEdit' => $formDocumentEdit->createView()
  518.             ));
  519.         }
  521.         /**
  522.          * @Route("/staff/scheda/documento-elimina", name="user_users_staff_document_delete")
  523.          * @Security("is_granted('edit', 'staff')")
  524.          */
  525.         public function userUsersStaffDocumentDelete(Request $request, FileSystem $fs)
  526.         {    
  527.             $em = $this->mr->getManager('slave');
  528.             $emMaster = $this->mr->getManager('master');
  529.             $session = $request->getSession();
  530.             $company = $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get("companyId"));
  531.             $uploadDir = $this->params->get('kernel.project_dir').'/'.$this->params->get('web_path').'/companies/'.$company->getDirectoryPath().'/users/';
  533.             $document = $em->getRepository("App\Entity\Slave\UserDocument")->findOneById($request->request->get("documentDelId"));
  534.             $userId = $document->getUser()->getId();
  535.             MediaService::removeDocument($fs, $document->getPath(), $uploadDir);
  536.             $em->remove($document);
  537.             $em->flush();
  538.             
  539.             $this->addFlash('notice_success', "Documento eliminato");
  540.             return $this->redirectToRoute('user_users_staff_sheet', array('userId' => $userId));
  541.         }
  543.         /**
  544.          * @Route("/staff/cambia-stato", name="user_users_staff_change_status")
  545.          * @Security("is_granted('edit', 'staff')")
  546.          */
  547.         public function userUsersStaffChangeStatus(Request $request)
  548.         {    
  549.             $em = $this->mr->getManager('slave');
  550.             $session = $request->getSession();
  551.             $user = $em->getRepository("App\Entity\Slave\User")->findOneById($request->request->get("userChangeId"));
  552.             $user->setCompanyActive(!$user->isCompanyActive());
  553.             $em->flush();
  554.             
  555.             $this->addFlash('notice_success', "Stato aggiornato");
  556.             return $this->redirectToRoute('user_users_staff');
  557.         }
  559.         /**
  560.          * @Route("/staff/elimina", name="user_users_staff_delete")
  561.          * @Security("is_granted('edit', 'staff')")
  562.          */
  563.         public function userUsersStaffDelete(Request $request)
  564.         {    
  565.             $em = $this->mr->getManager('slave');
  566.             $user = $em->getRepository("App\Entity\Slave\User")->findOneById($request->request->get("userDelId"));
  567.             $em->remove($user->getProfile());
  568.             $em->remove($user);
  569.             $em->flush();
  571.             $this->addFlash('notice_success', "Membro dello staff eliminato");
  572.             return $this->redirectToRoute('user_users_staff');
  573.         }
  574.     //
  576.     // TECNICI
  577.         /**
  578.          * @Route("/tecnici", name="user_users_technicians")
  579.          * @Security("is_granted('view', 'technician')")
  580.          */
  581.         public function userUsersTechnicians(Request $request, PaginatorInterface $paginator, FormFactoryInterface $formFactory, ValidatorInterface $validator)
  582.         {    
  583.             $em = $this->mr->getManager('slave');
  584.             $emMaster = $this->mr->getManager('master');
  585.             $session = $request->getSession();
  586.             $cities = $emMaster->getRepository("App\Entity\Master\City")->findByName('');
  588.             $filters = FilterService::userFilter($request);
  589.             $activeTechniciansQuery = $em->getRepository("App\Entity\Slave\User")->queryTechnicianUsersByCompanyActiveFiltered(true, 1, $filters);
  590.             $activeTechnicians = $paginator->paginate($activeTechniciansQuery, $request->getSession()->get($request->get("_route")."_page"), 50);
  591.             
  592.             $deactiveTechniciansQuery = $em->getRepository("App\Entity\Slave\User")->queryTechnicianUsersByCompanyActiveFiltered(true, 0, $filters);
  593.             $deactiveTechnicians = $paginator->paginate($deactiveTechniciansQuery, $request->getSession()->get($request->get("_route")."_page"), 50);
  595.             $countActiveTechnicians = sizeof($activeTechnicians);
  596.             $countTotalTechnicians = sizeof($activeTechnicians) + sizeof($deactiveTechnicians);
  598.             $user = new User();
  599.             $form = $formFactory->createNamed("user", UserTechnicianType::class, $user);
  600.             $form->handleRequest($request);
  602.             if($form->isSubmitted()){
  604.                 $valid = true;
  605.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('name'));
  606.                 if($valid) $valid = ValidationService::validateLength($form->get('name'), '191');
  607.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('surname'));
  608.                 if($valid) $valid = ValidationService::validateLength($form->get('surname'), '191');
  609.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $form->get('phone'));
  610.                 if($valid) $valid = ValidationService::validateLength($form->get('phone'), '191');
  611.                 if($valid) $valid = ValidationService::validateLength($form->get('address'), '191');
  612.                 if($valid) $valid = ValidationService::validateLength($form->get('civic'), '191');
  613.                 if($valid) $valid = ValidationService::validateLength($form->get('zip'), '5');
  615.                 if($valid && $form->isValid()){
  617.                     $user->setRole('ROLE_USER');
  618.                     $user->setAdminActive(true);
  619.                     $em->persist($user);
  621.                     $userProfile = new UserProfile();
  622.                     $userProfile->setUser($user);
  623.                     $userProfile->setName($form->get('name')->getData());
  624.                     $userProfile->setSurname($form->get('surname')->getData());
  625.                     $userProfile->setPhone($form->get('phone')->getData());
  626.                     if($form->get('address')->getData() != null) $userProfile->setAddress($form->get('address')->getData());
  627.                     if($form->get('civic')->getData() != null) $userProfile->setCivic($form->get('civic')->getData());
  628.                     if($form->get('zip')->getData() != null) $userProfile->setZip($emMaster->getRepository('App\Entity\Master\Zip')->findOneById($form->get('zip')->getData())->getCode());
  629.                     if($form->get('cityId')->getData() != null) $userProfile->setIdCity($form->get('cityId')->getData());
  630.                     $em->persist($userProfile);
  632.                     $em->flush();
  634.                     $this->addFlash('notice_success', "Nuovo tecnico inserito");
  635.                     $session->set('userId', $user->getId());
  636.                     return $this->redirectToRoute('user_users_technician_sheet', array('userId' => $user->getId()));
  637.                 }
  638.                 else
  639.                     $session->set('openModal', true);
  640.             }
  642.             return $this->render('role/user/users/technician/list.html.twig', array(
  643.                 'activeTechnicians' => $activeTechnicians,
  644.                 'deactiveTechnicians' => $deactiveTechnicians,
  645.                 'countTotalTechnicians' => $countTotalTechnicians,
  646.                 'countActiveTechnicians' => $countActiveTechnicians,
  647.                 'cities' => $cities,
  648.                 'filters' => $filters,
  649.                 'form' => $form->createView()
  650.             ));
  651.         }
  652.             
  653.         /**
  654.          * @Route("/tecnici/invia-credenziali", name="user_users_technician_send_credentials")
  655.          * @Security("is_granted('edit', 'technician')")
  656.          */
  657.         public function userUsersTechnicianSendCredentials(Request $request, MailerInterface $mailer)
  658.         {
  659.             $em = $this->mr->getManager('slave');
  660.             $emMaster = $this->mr->getManager('master');
  661.             $session = $request->getSession();
  662.             $company = $emMaster->getRepository('App\Entity\Master\Company')->findOneById($session->get('companyId'));
  664.             $user = $em->getRepository('App\Entity\Slave\User')->findOneById($request->request->get('userSendCredentialsId'));
  666.             $user->setOneTimeCode(md5(uniqid()));
  667.             $user->setExpirationOneTimeCode(date_modify(new \DateTime(), '+3 hours'));
  668.             $em->flush();
  670.             // INVIA EMAIL CON LINK PER CREARE NUOVA PASSWORD
  671.             $message = (new TemplatedEmail())
  672.                 ->from($this->params->get('email_noreply'))
  673.                 ->to($user->getEmail())
  674.                 ->subject($this->params->get('subject_create_password'))
  675.                 ->htmlTemplate('email/user_credentials.html.twig')
  676.                 ->context(['user' => $user, 'company' => $company]);
  677.             $mailer->send($message);
  679.             $this->addFlash('notice_success', 'Credenziali inviate!');
  680.             return $this->redirectToRoute('user_users_technicians');
  681.         }
  683.         /**
  684.          * @Route("/tecnici/cambia-stato", name="user_users_technician_change_status")
  685.          * @Security("is_granted('edit', 'technician')")
  686.          */
  687.         public function userUsersTechnicianChangeStatus(Request $request)
  688.         {    
  689.             $em = $this->mr->getManager('slave');
  690.             $session = $request->getSession();
  691.             $user = $em->getRepository("App\Entity\Slave\User")->findOneById($request->request->get("userChangeId"));
  692.             $user->setCompanyActive(!$user->isCompanyActive());
  693.             $em->flush();
  694.             
  695.             $this->addFlash('notice_success', "Stato aggiornato");
  696.             return $this->redirectToRoute('user_users_technicians');
  697.         }
  699.         /**
  700.          * @Route("/tecnici/elimina", name="user_users_technician_delete")
  701.          * @Security("is_granted('edit', 'technician')")
  702.          */
  703.         public function userUsersTechnicianDelete(Request $request)
  704.         {    
  705.             $em = $this->mr->getManager('slave');
  706.             $user = $em->getRepository("App\Entity\Slave\User")->findOneById($request->request->get("userDelId"));
  707.             foreach($user->getTechnicianAreas() as $ta)
  708.                 $em->remove($ta);
  710.             $em->remove($user->getProfile());
  711.             $em->remove($user);
  712.             $em->flush();
  714.             $this->addFlash('notice_success', "Tecnico eliminato");
  715.             return $this->redirectToRoute('user_users_technicians');
  716.         }
  718.         /**
  719.          * @Route("/tecnici/esporta-csv", name="user_users_technician_export")
  720.          * @Security("is_granted('view', 'technician')")
  721.          */
  722.         public function userUsersTechnicianExport(Request $request)
  723.         {    
  724.             $em = $this->mr->getManager('slave');
  725.             $emMaster = $this->mr->getManager('master');
  726.             $session = $request->getSession();
  727.             $filters = $session->get('user_users_technicians_filters');
  728.             $technicians = $em->getRepository("App\Entity\Slave\User")->findTechnicianUsersFiltered($filters);
  730.             $response = new StreamedResponse();
  731.             $response->setCallback(function() use($emMaster, $technicians) {
  732.                 $handle = fopen('php://output', 'w+');
  733.                 fputcsv($handle, array('Attivo', 'Nome','Cognome','Codice fiscale','Partita IVA','Email aziendale','Telefono aziendale','Email personale','Telefono personale','Indirizzo'), ";", '"', "\\");
  734.                 foreach($technicians as $t){
  735.                     $active = 'No'; if($t->isCompanyActive() != null) $active = 'Sรฌ';
  736.                     $name = null; if($t->getProfile()->getName() != null) $name = $t->getProfile()->getName();
  737.                     $surname = null; if($t->getProfile()->getSurname() != null) $surname = $t->getProfile()->getSurname();
  738.                     $fiscalCode = null; if($t->getProfile()->getFiscalCode() != null) $fiscalCode = $t->getProfile()->getFiscalCode();
  739.                     $vat = null; if($t->getProfile()->getVat() != null) $vat = $t->getProfile()->getVat();
  740.                     $companyEmail = null; if($t->getEmail() != null) $companyEmail = $t->getEmail();
  741.                     $companyPhone = null; if($t->getProfile()->getPhone() != null) $companyPhone = $t->getProfile()->getPhone();
  742.                     $personalEmail = null; if($t->getProfile()->getEmailPersonal() != null) $personalEmail = $t->getProfile()->getEmailPersonal();
  743.                     $personalPhone = null; if($t->getProfile()->getPhonePersonal() != null) $personalPhone = $t->getProfile()->getPhonePersonal();
  744.                     $address = null;
  745.                     if($t->getProfile()->getAddress() != null){
  746.                         $city = $emMaster->getRepository('App\Entity\Master\City')->findOneById($t->getProfile()->getIdCity());
  747.                         $address = $t->getProfile()->displayAddress().' '.$city->getName().' ('.$city->getProvince()->getSign().')';
  748.                     }
  749.                     fputcsv($handle, array($active, $name, $surname, $fiscalCode, $vat, $companyEmail, $companyPhone, $personalEmail, $personalPhone, $address), ";", '"', "\\");
  750.                 }
  751.                 fclose($handle);
  752.             });
  753.             
  754.             $response->setStatusCode(200);
  755.             $dispositionHeader = $response->headers->makeDisposition(ResponseHeaderBag::DISPOSITION_ATTACHMENT, 'Elenco tecnici filtrati.csv');
  756.             $response->headers->set('Content-Type', 'text/csv; charset=ISO-8859-15');
  757.             $response->headers->set('Content-Disposition', $dispositionHeader);
  758.             return $response;
  759.         }
  760.         
  761.         /**
  762.          * @Route("/tecnici/{userId}/scheda", name="user_users_technician_sheet")
  763.          * @Security("is_granted('view', 'technician')")
  764.          */
  765.         public function userUsersTechnicianSheet($userId, Request $request, FormFactoryInterface $formFactory, ValidatorInterface $validator, FileSystem $fs)
  766.         {    
  767.             $em = $this->mr->getManager('slave');
  768.             $emMaster = $this->mr->getManager('master');
  769.             $session = $request->getSession();
  770.             $company = $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get("companyId"));
  771.             $uploadDir = $this->params->get('kernel.project_dir').'/'.$this->params->get('web_path').'/companies/'.$company->getDirectoryPath().'/users/';
  772.             $user = $em->getRepository('App\Entity\Slave\User')->findOneById($userId);
  773.             $cities = $emMaster->getRepository("App\Entity\Master\City")->findByName('');
  774.             
  775.             $oldZipId = null;
  776.             if($user->getProfile()->getZip() != null){
  777.                 $oldZip = $emMaster->getRepository('App\Entity\Master\Zip')->findOneByCode($user->getProfile()->getZip());
  778.                 $oldZipId = $oldZip->getId();
  779.             }
  781.             $regionIds = array();
  782.             foreach($company->getRegions() as $r)
  783.                 array_push($regionIds, $r->getId());
  785.             // Anagrafica - Dati tecnico
  786.             $formData = $formFactory->createNamed("user_profile", UserProfileType::class, $user->getProfile());
  787.             $formData->handleRequest($request);
  788.             if($formData->isSubmitted()){
  789.                 
  790.                 $valid = true;
  791.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $formData->get('email'));
  792.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $formData->get('accountType'));
  793.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $formData->get('cityId'));
  794.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $formData->get('zip'));
  796.                 if($valid && $formData->isValid()){
  797.                     $zip = $emMaster->getRepository('App\Entity\Master\Zip')->findOneById($formData->get('zip')->getData());
  798.                     $user->setAccountType($formData->get('accountType')->getData());
  799.                     $user->setEmail($formData->get('email')->getData());
  800.                     $user->getProfile()->setIdCity($formData->get('cityId')->getData());
  801.                     $user->getProfile()->setZip($zip->getCode());
  802.                     $em->flush();
  803.                     $this->addFlash('notice_success', "Modifiche salvate");
  804.                     return $this->redirectToRoute('user_users_technician_sheet', array('userId' => $user->getId()));
  805.                 }
  806.                 else
  807.                     $session->set('openModalData', true);
  808.             }
  809.         
  810.             // Anagrafica - Documenti
  811.             $document = new UserDocument();
  812.             $formDocumentNew = $formFactory->createNamed("document_new", UserDocumentNewType::class, $document);
  813.             $formDocumentNew->handleRequest($request);
  814.             if($formDocumentNew->isSubmitted()){
  815.                 $valid = ValidationService::validateFile($validator, $formDocumentNew->get('path'), true, $formDocumentNew->get('file')->getData(), '5', array('pdf', 'doc', 'docx', 'jpg', 'jpeg', 'png', 'webp'));
  816.                 if($valid && $formDocumentNew->isValid()){
  817.                     $document->setUser($user);
  818.                     switch($formDocumentNew->get('file')->getData()->guessExtension()){
  819.                         case 'pdf':
  820.                         case 'doc':
  821.                         case 'docx':
  822.                             MediaService::uploadDocument($formDocumentNew->get('file')->getData(), $uploadDir, $document, 'document');
  823.                             break;
  824.                         case 'jpg':
  825.                         case 'jpeg':
  826.                         case 'png':
  827.                         case 'webp':
  828.                             MediaService::uploadImage($fs, $formDocumentNew->get('file')->getData(), null, $uploadDir, $document, 'path', 100, 1000, 200, false);
  829.                             break;
  830.                         default: break;
  831.                     }
  832.                     $em->persist($document);
  833.                     $em->flush();
  834.                     $this->addFlash('notice_success', "Documento inserito");
  835.                     return $this->redirectToRoute('user_users_technician_sheet', array('userId' => $user->getId()));
  836.                 }
  837.                 else
  838.                     $session->set('openModalDocumentNew', true);
  839.             }
  840.             
  841.             $formDocumentEdit = $formFactory->createNamed("document_edit", UserDocumentEditType::class, $document);
  842.             $formDocumentEdit->handleRequest($request);
  843.             if($formDocumentEdit->isSubmitted()){
  844.                 if($formDocumentEdit->isValid()){
  845.                     $editDocument = $em->getRepository("App\Entity\Slave\UserDocument")->findOneById($request->request->get('id'));
  846.                     $editDocument->setName($formDocumentEdit->get('name')->getData());
  847.                     $em->flush();
  848.                     $this->addFlash('notice_success', "Documento modificato");
  849.                     return $this->redirectToRoute('user_users_technician_sheet', array('userId' => $user->getId()));
  850.                 }
  851.                 else{
  852.                     $session->set('openModalDocumentEdit', true);
  853.                     $session->set('openModalDocumentEditId', $request->request->get('id'));
  854.                 }
  855.             }
  857.             // Anagrafica - Utenze
  858.             $jtus = new JoinTableUserSupplier();
  859.             $formJtusNew = $formFactory->createNamed("jtus_new", JoinTableUserSupplierType::class, $jtus);
  860.             $formJtusNew->handleRequest($request);
  861.             if($formJtusNew->isSubmitted()){
  862.                 if($formJtusNew->isValid()){
  863.                     $jtus->setUser($user);
  864.                     $em->persist($jtus);
  865.                     $em->flush();
  866.                     $this->addFlash('notice_success', "Utenza inserita");
  867.                     return $this->redirectToRoute('user_users_technician_sheet', array('userId' => $user->getId()));
  868.                 }
  869.                 else
  870.                     $session->set('openModalJtusNew', true);
  871.             }
  872.             
  873.             $formJtusEdit = $formFactory->createNamed("jtus_edit", JoinTableUserSupplierType::class, $jtus);
  874.             $formJtusEdit->handleRequest($request);
  875.             if($formJtusEdit->isSubmitted()){
  876.                 if($formJtusEdit->isValid()){
  877.                     $editJtus = $em->getRepository("App\Entity\Slave\JoinTableUserSupplier")->findOneById($request->request->get('id'));
  878.                     $editJtus->setSupplier($formJtusEdit->get('supplier')->getData());
  879.                     $editJtus->setValue($formJtusEdit->get('value')->getData());
  880.                     $em->flush();
  881.                     $this->addFlash('notice_success', "Modifiche salvate");
  882.                     return $this->redirectToRoute('user_users_technician_sheet', array('userId' => $user->getId()));
  883.                 }
  884.                 else
  885.                     $session->set('openModalJtusEdit', true);
  886.                     $session->set('openModalJtusEditId', $request->request->get('id'));
  887.             }
  889.             // Magazzini
  890.             $jtuw = new JoinTableUserWarehouse();
  891.             $formJtuwNew = $formFactory->createNamed("jtuw_new", JoinTableUserWarehouseNewType::class, $jtuw, ['user' => $user]);
  892.             $formJtuwNew->handleRequest($request);
  893.             if($formJtuwNew->isSubmitted()){
  894.                 if($formJtuwNew->isValid()){
  895.                     $jtuw->setUser($user);
  896.                     $em->persist($jtuw);
  897.                     $em->flush();
  898.                     $this->addFlash('notice_success', "Permesso magazzino-utente inserito");
  899.                     return $this->redirectToRoute('user_users_technician_sheet', array('userId' => $user->getId()));
  900.                 }
  901.                 else
  902.                     $session->set('openJtuwNew', true);
  903.             }
  905.             $jtuwEdit = new JoinTableUserWarehouse();
  906.             $formJtuwEdit = $formFactory->createNamed("jtuw_edit", JoinTableUserWarehouseEditType::class, $jtuwEdit);
  907.             $formJtuwEdit->handleRequest($request);
  908.             if($formJtuwEdit->isSubmitted()){
  909.                 if($formJtuwEdit->isValid()){
  910.                     $jt = $em->getRepository('App\Entity\Slave\JoinTableUserWarehouse')->findOneById($request->request->get('id'));
  911.                     $jt->setPermission($jtuwEdit->getPermission());
  912.                     $em->flush();
  913.                     $this->addFlash('notice_success', "Modifiche salvate");
  914.                     return $this->redirectToRoute('user_users_technician_sheet', array('userId' => $user->getId()));
  915.                 }
  916.                 else{
  917.                     $session->set('openJtuwEdit', true);
  918.                     $session->set('openJtuwEditId', $request->request->get('id'));
  919.                 }
  920.             }
  922.             $provinces = array();
  923.             foreach($company->getRegions() as $r)
  924.                 foreach($r->getProvinces() as $p)
  925.                     array_push($provinces, $p);
  926.                 
  927.             $operationsBySupplier = array();
  928.             $supplier = $em->getRepository('App\Entity\Slave\Supplier')->findAll();
  929.             foreach($supplier as $s){
  930.                 $tmp = array();
  931.                 array_push($tmp, $s, $s->getOperations());
  932.                 array_push($operationsBySupplier, $tmp);
  933.             }
  935.             // Copertura e tariffario
  936.             $jttaotas = array();
  937.             foreach($user->getTechnicianAreas() as $ta){
  938.                 $jts = $em->getRepository('App\Entity\Slave\JoinTableTechnicianAreaOperationTariffAmount')->findByTechnicianAndProvinceOrderedBySupplierAndOperation($user->getId(), $ta->getIdProvince());
  939.                 $tmp = array();
  940.                 array_push($tmp, $ta->getIdProvince(), $jts);
  941.                 array_push($jttaotas, $tmp);
  942.             }
  943.             
  944.             $formSuppliersAutoAssign = $formFactory->createNamed("form_suppliers_auto_assign", JoinTableUserSupplierAutoAssignType::class, $user);
  945.             $formSuppliersAutoAssign->handleRequest($request);
  946.             if($formSuppliersAutoAssign->isSubmitted()){
  947.                 if($formSuppliersAutoAssign->isValid()){
  948.                     $em->flush();
  949.                     $this->addFlash('notice_success', "Fornitori tecnico aggiornati!");
  950.                     return $this->redirectToRoute('user_users_technician_sheet', array('userId' => $user->getId()));
  951.                 }
  952.             }
  954.             // Clona tariffario da altro tecnico
  955.             $jttaota = new JoinTableTechnicianAreaOperationTariffAmount();
  956.             $formCloneJttaota = $formFactory->createNamed("jttaota_clone", JoinTableTechnicianAreaOperationTariffAmountCloneType::class, $jttaota, ['userId' => $user->getId()]);
  957.             $formCloneJttaota->handleRequest($request);
  959.             if($formCloneJttaota->isSubmitted()){
  960.                 $valid = ValidationService::validateNotBlank($validator, $formCloneJttaota->get('userToClone'));
  962.                 if($valid && $formCloneJttaota->isValid()){
  964.                     $userToClone = $em->getRepository('App\Entity\Slave\User')->findOneById($formCloneJttaota->get('userToClone')->getData());
  965.                     foreach($user->getTechnicianAreas() as $ta){
  967.                         $taToClone = null;
  968.                         foreach($userToClone->getTechnicianAreas() as $utcta){
  969.                             if($ta->getIdProvince() == $utcta->getIdProvince()){
  970.                                 $taToClone = $utcta;
  971.                                 break;
  972.                             }
  973.                         }
  974.         
  975.                         if($taToClone != null){
  976.                             foreach($ta->getOperationTariffAmounts() as $jttaota){
  977.                                 $jttaotaToClone = $em->getRepository('App\Entity\Slave\JoinTableTechnicianAreaOperationTariffAmount')->findOneByTechnicianAreaAndOperationTariffAmount($taToClone->getId(), $jttaota->getOperationTariffAmount()->getId());
  978.                                 if($jttaotaToClone != null){
  979.                                     $jttaota->setAmount($jttaotaToClone->getAmount());
  980.                                 }
  981.                             }
  982.                         }
  983.                     }
  984.         
  985.                     $em->flush();
  986.                     $this->addFlash('notice_success', "Tariffe clonate");
  987.                     return $this->redirectToRoute('user_users_technician_sheet', array('userId' => $user->getId()));
  988.                 }
  989.                 else
  990.                     $session->set('openCloneJttaota', true);
  991.             }
  993.             // Ferie
  994.             $holiday = new UserHoliday();
  995.             $formHolidayNew = $formFactory->createNamed("holiday_new", UserHolidayType::class, $holiday, array('userId' => $user->getId()));
  996.             $formHolidayNew->handleRequest($request);
  997.             if($formHolidayNew->isSubmitted()){
  998.                 $valid = true;
  999.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $formHolidayNew->get('substitute'));
  1000.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $formHolidayNew->get('dateFrom'));
  1001.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $formHolidayNew->get('dateTo'));
  1002.                 if($valid) $valid = ValidationService::validateCompareDate($formHolidayNew->get('dateFrom'), $formHolidayNew->get('dateTo'), 'major', 'La data di fine deve essere maggiore o uguale a quella di inizio!');
  1003.                 if($valid && $formHolidayNew->isValid()){
  1004.                     $holiday->setUser($user);
  1005.                     $em->persist($holiday);
  1006.                     $em->flush();
  1007.                     $this->addFlash('notice_success', "Ferie inserite");
  1008.                     return $this->redirectToRoute('user_users_technician_sheet', array('userId' => $user->getId()));
  1009.                 }
  1010.                 else
  1011.                     $session->set('openModalHolidayNew', true);
  1012.             }
  1013.             
  1014.             $formHolidayEdit = $formFactory->createNamed("holiday_edit", UserHolidayType::class, $holiday, array('userId' => $user->getId()));
  1015.             $formHolidayEdit->handleRequest($request);
  1016.             if($formHolidayEdit->isSubmitted()){
  1017.                 $valid = true;
  1018.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $formHolidayEdit->get('substitute'));
  1019.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $formHolidayEdit->get('dateFrom'));
  1020.                 if($valid) $valid = ValidationService::validateNotBlank($validator, $formHolidayEdit->get('dateTo'));
  1021.                 if($valid) $valid = ValidationService::validateCompareDate($formHolidayEdit->get('dateFrom'), $formHolidayEdit->get('dateTo'), 'major', 'La data di fine deve essere maggiore o uguale a quella di inizio!');
  1022.                 if($valid && $formHolidayEdit->isValid()){
  1023.                     $editHoliday = $em->getRepository("App\Entity\Slave\UserHoliday")->findOneById($request->request->get("id"));
  1024.                     $editHoliday->setSubstitute($formHolidayEdit->get('substitute')->getData());
  1025.                     $editHoliday->setDateFrom($formHolidayEdit->get('dateFrom')->getData());
  1026.                     $editHoliday->setDateTo($formHolidayEdit->get('dateTo')->getData());
  1027.                     $em->flush();
  1028.                     $this->addFlash('notice_success', "Ferie modificate");
  1029.                     return $this->redirectToRoute('user_users_technician_sheet', array('userId' => $user->getId()));
  1030.                 }
  1031.                 else{
  1032.                     $session->set('openModalHolidayEdit', true);
  1033.                     $session->set('openModalHolidayEditId', $request->request->get("id"));
  1034.                 }
  1035.             }
  1036.             
  1037.             // Economico e pagamenti
  1038.             $formEconomicVisible = $formFactory->createNamed("economic_visible", TechnicianEconomicType::class, $user);
  1039.             $formEconomicVisible->handleRequest($request);
  1040.             if($formEconomicVisible->isSubmitted()){
  1041.                 if($formEconomicVisible->isValid()){
  1042.                     $em->flush();
  1043.                     $this->addFlash('notice_success', "Dati aggiornati");
  1044.                     return $this->redirectToRoute('user_users_technician_sheet', array('userId' => $user->getId()));
  1045.                 }
  1046.             }
  1048.             $operations = $em->getRepository('App\Entity\Slave\Operation')->findAll();
  1049.             $operationGroups = $em->getRepository('App\Entity\Slave\OperationGroup')->findAllOrderedByUav();
  1050.             $interventions = $em->getRepository('App\Entity\Slave\Intervention')->findByTechnicianToPay($user->getId());
  1052.             return $this->render('role/user/users/technician/sheet.html.twig', array(
  1053.                 'company' => $company,
  1054.                 'user' => $user,
  1055.                 'idZip' => $oldZipId,
  1056.                 'cities' => $cities,
  1057.                 'provinces' => $provinces,
  1058.                 'operationsBySupplier' => $operationsBySupplier,
  1059.                 'operationGroups' => $operationGroups,
  1060.                 'interventions' => $interventions,
  1061.                 'jttaotas' => $jttaotas,
  1062.                 'formData' => $formData->createView(),
  1063.                 'formDocumentNew' => $formDocumentNew->createView(),
  1064.                 'formDocumentEdit' => $formDocumentEdit->createView(),
  1065.                 'formJtusNew' => $formJtusNew->createView(),
  1066.                 'formJtusEdit' => $formJtusEdit->createView(),
  1067.                 'formSuppliersAutoAssign' => $formSuppliersAutoAssign->createView(),
  1068.                 'formJtuwNew' => $formJtuwNew->createView(),
  1069.                 'formJtuwEdit' => $formJtuwEdit->createView(),
  1070.                 'formCloneJttaota' => $formCloneJttaota->createView(),
  1071.                 'formHolidayNew' => $formHolidayNew->createView(),
  1072.                 'formHolidayEdit' => $formHolidayEdit->createView(),
  1073.                 'formEconomicVisible' => $formEconomicVisible->createView()
  1074.             ));
  1075.         }
  1077.         /**
  1078.          * @Route("/tecnici/scheda/documento-elimina", name="user_users_technician_document_delete")
  1079.          * @Security("is_granted('edit', 'technician')")
  1080.          */
  1081.         public function userUsersTechnicianDocumentDelete(Request $request, FileSystem $fs)
  1082.         {    
  1083.             $em = $this->mr->getManager('slave');
  1084.             $emMaster = $this->mr->getManager('master');
  1085.             $session = $request->getSession();
  1086.             $company = $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get("companyId"));
  1087.             $uploadDir = $this->params->get('kernel.project_dir').'/'.$this->params->get('web_path').'/companies/'.$company->getDirectoryPath().'/users/';
  1089.             $document = $em->getRepository("App\Entity\Slave\UserDocument")->findOneById($request->request->get("documentDelId"));
  1090.             $userId = $document->getUser()->getId();
  1091.             MediaService::removeDocument($fs, $document->getPath(), $uploadDir);
  1092.             $em->remove($document);
  1093.             $em->flush();
  1094.             
  1095.             $this->addFlash('notice_success', "Documento eliminato");
  1096.             return $this->redirectToRoute('user_users_technician_sheet', array('userId' => $userId));
  1097.         }
  1099.         /**
  1100.          * @Route("/tecnici/scheda/utenza-elimina", name="user_users_technician_jtus_delete")
  1101.          * @Security("is_granted('edit', 'technician')")
  1102.          */
  1103.         public function userUsersTechnicianJtusDelete(Request $request)
  1104.         {    
  1105.             $em = $this->mr->getManager('slave');
  1106.             $session = $request->getSession();
  1107.             $jtus = $em->getRepository("App\Entity\Slave\JoinTableUserSupplier")->findOneById($request->request->get("jtusDelId"));
  1108.             $userId = $jtus->getUser()->getId();
  1109.             $em->remove($jtus);
  1110.             $em->flush();
  1111.             $this->addFlash('notice_success', "Utenza eliminata");
  1112.             return $this->redirectToRoute('user_users_technician_sheet', array('userId' => $userId));
  1113.         }
  1115.         /**
  1116.          * @Route("/tecnici/scheda/magazzino-elimina", name="user_users_technician_warehouse_delete")
  1117.          * @Security("is_granted('edit', 'technician')")
  1118.          */
  1119.         public function userUsersTechnicianWarehouseDelete(Request $request)
  1120.         {    
  1121.             $em = $this->mr->getManager('slave');
  1122.             $emMaster = $this->mr->getManager('master');
  1123.             $session = $request->getSession();
  1124.             $jtuw = $em->getRepository('App\Entity\Slave\JoinTableUserWarehouse')->findOneById($request->request->get('jtuwDelId'));
  1125.             $userId = $jtuw->getUser()->getId();
  1126.             $em->remove($jtuw);
  1127.             $em->flush();
  1128.             
  1129.             $this->addFlash('notice_success', "Collegamento con il magazzino eliminato");
  1130.             return $this->redirectToRoute('user_users_technician_sheet', array('userId' => $userId));
  1131.         }
  1132.         
  1133.         /**
  1134.          * @Route("/tecnici/{userId}/scheda/area-copertura/nuova", name="user_users_technician_area_new")
  1135.          * @Security("is_granted('edit', 'technician')")
  1136.          */
  1137.         public function userUsersTechnicianAreaNew($userId, Request $request, ValidatorInterface $validator, FormFactoryInterface $formFactory)
  1138.         {
  1139.             $emMaster = $this->mr->getManager('master');
  1140.             $em = $this->mr->getManager('slave');
  1141.             $session = $request->getSession();
  1142.             $company = $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get("companyId"));
  1143.             $user = $em->getRepository('App\Entity\Slave\User')->findOneById($userId);
  1144.         
  1145.             $regionIds = array();
  1146.             foreach($company->getRegions() as $r)
  1147.                 array_push($regionIds, $r->getId());
  1149.             $technicianArea = new TechnicianArea();
  1150.             $form = $formFactory->createNamed("form_technician_area", TechnicianAreaType::class, $technicianArea, array('regionIds' => $regionIds));
  1151.             $form->handleRequest($request);
  1153.             if($form->isSubmitted()){
  1154.                 
  1155.                 $valid = FormValidatorService::validateTechnicianArea($validator, $form, $user->getTechnicianAreas(), 0);
  1156.                 
  1157.                 if($valid && $form->isValid()){
  1158.                     $matrixZips = array();
  1159.                     if(!$form->get('allZip')->getData()){
  1160.                         $zips = explode('-', $form->get('zips')->getData());
  1161.                         foreach($zips as $z){
  1162.                             $arrayTmp = array();
  1163.                             $zip = $emMaster->getRepository('App\Entity\Master\Zip')->findOneById($z);
  1164.                             array_push($arrayTmp, $zip->getId(), $zip->getCode());
  1165.                             array_push($matrixZips, $arrayTmp);
  1166.                         }
  1167.                     }
  1169.                     $technicianArea->setUser($user);
  1170.                     $technicianArea->setIdProvince($form->get('province')->getData()->getId());
  1171.                     $technicianArea->setZips($matrixZips);
  1172.                     $technicianArea->setAllZip($form->get('allZip')->getData());
  1173.                     $em->persist($technicianArea);
  1175.                     $em->flush();
  1176.                     TechnicianTariffService::updateTechnicianTariffs($em, $technicianArea->getId());
  1178.                     $this->addFlash('notice_success', "Area tecnico inserita");
  1179.                     return $this->redirectToRoute('user_users_technician_sheet', array('userId' => $user->getId()));
  1180.                 }
  1181.             }
  1182.             return $this->render('role/user/users/technician/area_new.html.twig', array(
  1183.                 'form' => $form->createView(),
  1184.                 'user' => $user
  1185.             ));
  1186.         }
  1187.         
  1188.         /**
  1189.          * @Route("/tecnici/scheda/area-copertura/{technicianAreaId}/modifica", name="user_users_technician_area_edit")
  1190.          * @Security("is_granted('edit', 'technician')")
  1191.          */
  1192.         public function userUsersTechnicianAreaEdit($technicianAreaId, Request $request, ValidatorInterface $validator, FormFactoryInterface $formFactory)
  1193.         {
  1194.             $emMaster = $this->mr->getManager('master');
  1195.             $em = $this->mr->getManager('slave');
  1196.             $session = $request->getSession();
  1197.             $company = $emMaster->getRepository("App\Entity\Master\Company")->findOneById($session->get("companyId"));
  1198.             $technicianArea = $em->getRepository("App\Entity\Slave\TechnicianArea")->findOneById($technicianAreaId);
  1199.             $user = $technicianArea->getUser();
  1200.         
  1201.             $regionIds = array();
  1202.             foreach($company->getRegions() as $r)
  1203.                 array_push($regionIds, $r->getId());
  1205.             $form = $formFactory->createNamed("form_technician_area", TechnicianAreaType::class, $technicianArea, array('regionIds' => $regionIds));
  1206.             $form->handleRequest($request);
  1208.             if($form->isSubmitted()){
  1210.                 $valid = FormValidatorService::validateTechnicianArea($validator, $form, $user->getTechnicianAreas(), $technicianArea->getId());
  1212.                 if($valid && $form->isValid()){
  1213.                     
  1214.                     $matrixZips = array();
  1215.                     if(!$form->get('allZip')->getData()){
  1216.                         $zips = explode('-', $form->get('zips')->getData());
  1217.                         foreach($zips as $z){
  1218.                             $arrayTmp = array();
  1219.                             $zip = $emMaster->getRepository('App\Entity\Master\Zip')->findOneById($z);
  1220.                             array_push($arrayTmp, $zip->getId(), $zip->getCode());
  1221.                             array_push($matrixZips, $arrayTmp);
  1222.                         }
  1223.                     }
  1225.                     $technicianArea->setUser($user);
  1226.                     $technicianArea->setIdProvince($form->get('province')->getData()->getId());
  1227.                     $technicianArea->setZips($matrixZips);
  1228.                     $technicianArea->setAllZip($form->get('allZip')->getData());
  1229.                     $em->persist($technicianArea);
  1231.                     $em->flush();
  1232.                     TechnicianTariffService::updateTechnicianTariffs($em, $technicianArea->getId());
  1234.                     $this->addFlash('notice_success', "Area tecnico modificata");
  1235.                     return $this->redirectToRoute('user_users_technician_sheet', array('userId' => $user->getId()));
  1236.                 }
  1237.             }
  1238.             return $this->render('role/user/users/technician/area_edit.html.twig', array(
  1239.                 'form' => $form->createView(),
  1240.                 'technicianArea' => $technicianArea
  1241.             ));
  1242.         }
  1244.         /**
  1245.          * @Route("/tecnici/scheda/area-copertura/elimina", name="user_users_technician_area_delete")
  1246.          * @Security("is_granted('edit', 'technician')")
  1247.          */
  1248.         public function userUsersTechnicianAreaDelete(Request $request)
  1249.         {    
  1250.             $em = $this->mr->getManager('slave');
  1251.             $session = $request->getSession();
  1252.             $technicianArea = $em->getRepository("App\Entity\Slave\TechnicianArea")->findOneById($request->request->get("technicianAreaDelId"));
  1253.             $userId = $technicianArea->getUser()->getId();
  1254.             foreach($technicianArea->getOperationTariffAmounts() as $jt)
  1255.                 $em->remove($jt);
  1256.             $em->remove($technicianArea);
  1257.             $em->flush();
  1258.             
  1259.             $this->addFlash('notice_success', "Area copertura eliminata");
  1260.             return $this->redirectToRoute('user_users_technician_sheet', array('userId' => $userId));
  1261.         }
  1262.         
  1263.         /**
  1264.          * @Route("/tecnici/scheda/tariffe-ammontare-aggiorna", name="user_technician_tariff_amount_update")
  1265.          * @Security("is_granted('edit', 'technician')")
  1266.          */
  1267.         public function userUsersTechnicianTariffAmountUpdate(Request $request, ValidatorInterface $validator)
  1268.         {    
  1269.             $em = $this->mr->getManager('slave');
  1270.             $session = $request->getSession();
  1271.             $user = $em->getRepository('App\Entity\Slave\User')->findOneById($request->request->get('userId'));
  1272.             $assert = new Assert\Regex(['pattern' => '/^[-]?[0-9]|^[-]?[0-9]+([.|,][0-9]{2})$/']);
  1273.             $error = false;
  1275.             foreach($user->getTechnicianAreas() as $ta){
  1276.                 foreach($ta->getOperationTariffAmounts() as $jttaota){
  1277.                     // Controllo che sia un numero scritto come 12.34 o 12
  1278.                     $value = $request->request->get('jttaota_'.$jttaota->getId());
  1279.                     $errors = $validator->validate($value, $assert);
  1280.                     if(count($errors) !== 0){
  1281.                         $error = true;
  1282.                         break;
  1283.                     }
  1284.                     if($value != null)
  1285.                         $jttaota->setAmount($value);
  1286.                 }
  1287.             }
  1288.             if($error){
  1289.                 $this->addFlash('notice_warning', 'Errore! Inserire i valori nel formato corretto: "12", "12.34" o "12,34"');
  1290.             }
  1291.             else{
  1292.                 $em->flush();
  1293.                 $this->addFlash('notice_success', "Tariffe aggiornate");
  1294.             }
  1295.             return $this->redirectToRoute('user_users_technician_sheet', array('userId' => $user->getId()));
  1296.         }
  1298.         /**
  1299.          * @Route("/tecnici/scheda/ferie-elimina", name="user_users_technician_holiday_delete")
  1300.          * @Security("is_granted('edit', 'technician')")
  1301.          */
  1302.         public function userUsersTechnicianHolidayDelete(Request $request)
  1303.         {    
  1304.             $em = $this->mr->getManager('slave');
  1305.             $holiday = $em->getRepository("App\Entity\Slave\UserHoliday")->findOneById($request->request->get("holidayDelId"));
  1306.             $userId = $holiday->getUser()->getId();
  1307.             $em->remove($holiday);
  1308.             $em->flush();
  1309.             
  1310.             $session = $request->getSession();
  1311.             $this->addFlash('notice_success', "Ferie eliminate");
  1312.             return $this->redirectToRoute('user_users_technician_sheet', array('userId' => $userId));
  1313.         }
  1314.         
  1315.         /**
  1316.          * @Route("/tecnici/scheda/aggiorna-economico-interventi", name="user_users_technician_economic_recalculate")
  1317.          * @Security("is_granted('edit', 'technician')")
  1318.          */
  1319.         public function userUsersTechnicianEconomicRecalculate(Request $request)
  1320.         {    
  1321.             $em = $this->mr->getManager('slave');
  1322.             $session = $request->getSession();
  1323.             
  1324.             $userId = $request->request->get('userId');
  1325.             $year = $request->request->get('year');
  1326.             $month = $request->request->get('month');
  1327.             $ds = $request->request->get('dateStart');
  1328.             $de = $request->request->get('dateEnd');
  1329.     
  1330.             $periodInterventions = [];
  1331.             $dateStart = date_create_from_format('d-m-Y', $ds);
  1332.             $dateEnd = date_create_from_format('d-m-Y', $de);
  1333.             $interventions = $em->getRepository('App\Entity\Slave\Intervention')->findByTechnicianByYearAndMonth($userId, $year, $month);
  1334.     
  1335.             foreach($interventions as $i){
  1336.                 if($i->getDatetime()->format('Ymd') >= $dateStart->format('Ymd') && $i->getDatetime()->format('Ymd') <= $dateEnd->format('Ymd'))
  1337.                     array_push($periodInterventions, $i);
  1338.             }
  1339.          
  1340.             foreach($periodInterventions as $int){
  1341.                 $amountTechnician = null; 
  1342.                 if($int->getOutcomeType()->getSlug() == 'completed'){
  1343.                     // Se completato -> Prendo ammontare tariffa normale
  1344.                     foreach($int->getTicket()->getOperationTariffAmount()->getTechnicianAreas() as $jttaota){
  1345.                         if($jttaota->getTechnicianArea()->getUser()->getId() == $userId){
  1346.                             $amountTechnician = $jttaota->getAmount();
  1347.                             break;
  1348.                         }
  1349.                     }
  1350.                 }
  1351.                 else{
  1352.                     // Se sospeso/uav -> Prendo ammontare tariffa UAV
  1353.                     if($int->getTicket()->getUAVOperationTariffAmount() != null){
  1354.                         foreach($int->getTicket()->getUAVOperationTariffAmount()->getTechnicianAreas() as $jttaota){
  1355.                             if($jttaota->getTechnicianArea()->getUser()->getId() == $userId){
  1356.                                 $amountTechnician = $jttaota->getAmount();
  1357.                                 break;
  1358.                             }
  1359.                         }
  1360.                     }
  1361.                 }
  1363.                 if($amountTechnician == null)
  1364.                     $amountTechnician = '0.00';
  1365.                 $int->setAmountTechnician($amountTechnician);
  1366.             }
  1367.            
  1368.             $em->flush();
  1369.             $this->addFlash('notice_success', "Ammontare del mese ricalcolati con successo!");
  1370.             return $this->redirectToRoute('user_users_technician_sheet', array('userId' => $userId));
  1371.         }
  1373.         /**
  1374.          * @Route("/tecnici/scheda/economico-esporta", name="user_users_technician_economic_export")
  1375.          * @Security("is_granted('edit', 'technician')")
  1376.          */
  1377.         public function userUsersTechnicianEconomicExport(Request $request)
  1378.         {    
  1379.             $em = $this->mr->getManager('slave');
  1380.             $emMaster = $this->mr->getManager('master');
  1381.             $session = $request->getSession();
  1383.             $userId = $request->request->get('userId');
  1384.             $year = $request->request->get('year');
  1385.             $month = $request->request->get('month');
  1386.             $user = $em->getRepository('App\Entity\Slave\User')->findOneById($userId);
  1387.             $allInterventions = $em->getRepository("App\Entity\Slave\Intervention")->findByTechnicianToPayByYearAndMonth($user->getId(), $year, $month);
  1389.             // Rimuovo gli interventi che hanno una sospensione -> Gestita e non approvata / Non gestita
  1390.             $interventions = array();
  1391.             foreach($allInterventions as $int){
  1392.                 $toCalculate = true;
  1393.                 if($int->getSuspension() != null && ($int->getSuspension()->isManaged() == false || $int->getSuspension()->isApproved() == false))
  1394.                     $toCalculate = false;
  1396.                 if($toCalculate)
  1397.                     array_push($interventions, $int);
  1398.             }
  1400.             $response = new StreamedResponse();
  1401.             $response->setCallback(function() use($emMaster, $interventions) {
  1402.                 $handle = fopen('php://output', 'w+');
  1403.                 fputcsv($handle, array('Provincia','Citta','CAP','Operazione','Ticket','Cliente','Term ID','Data/Ora','Esito','Attivita svolte','Costo','Costo tecnico','Costo extra','Costi non fatturabili','Totale'), ";", '"', "\\");
  1404.                 
  1405.                 $provinceSign = '';
  1406.                 $cityName = '';
  1407.                 $zip = '';
  1408.                 $operation = '';
  1409.                 $ticket = '';
  1410.                 $client = '';
  1411.                 $termid = '';
  1412.                 $datetime = '';
  1413.                 $outcome = '';
  1414.                 $cost = 0;
  1415.                 $amount = 0;
  1416.                 $amountExtra = 0;
  1417.                 $total = 0;
  1418.                 $totalCost = 0;
  1419.                 $totalAmount = 0;
  1420.                 $totalAmountExtra = 0;
  1421.                 $totalAmountNotBillable = 0;
  1422.                 $totalTotal = 0;
  1423.                 foreach($interventions as $int){
  1424.                 
  1425.                     $provinceSign = $emMaster->getRepository('App\Entity\Master\Province')->findOneById($int->getTicket()->getIdProvince())->getSign();
  1426.                     $cityName = $emMaster->getRepository('App\Entity\Master\City')->findOneById($int->getTicket()->getIdCity())->getName();
  1427.                     $zip = $int->getTicket()->getZip();
  1428.                     $operation = $int->getTicket()->getOperation();
  1429.                     $ticket = $int->getTicket()->getNumber();
  1430.                     $client = $int->getTicket()->getClient();
  1431.                     $termid = $int->getTicket()->getTermid();
  1432.                     $datetime = $int->getDatetime()->format('d-m-Y H:i');
  1433.                     $outcome = $int->getOutcomeType().' '.$int->getOutcome();
  1434.                     $first = true;
  1435.                     $activities = '';
  1436.                     foreach($int->getActivities() as $act){
  1437.                         if($first) $first = false; else $activities.= ' --- ';
  1438.                         if($act->getProductWithdraw() != null){
  1439.                             $pr = $act->getProductWithdraw();
  1440.                             $codeProd = $act->getProducerWithdraw();
  1441.                             $codeSupp = $act->getSupplierWithdraw();
  1442.                         }
  1443.                         if($act->getProductActual() != null){
  1444.                             $pr = $act->getProductActual();
  1445.                             $codeProd = $act->getProducerActual();
  1446.                             $codeSupp = $act->getSupplierActual();
  1447.                         }
  1448.                         if($act->getProductInstallation() != null){
  1449.                             $pr = $act->getProductInstallation();
  1450.                             $codeProd = $act->getProducerInstallation();
  1451.                             $codeSupp = $act->getSupplierInstallation();
  1452.                         }
  1453.                         $activities.= $act->getType();
  1454.                     }
  1455.                     $cost = $int->getAmount();
  1456.                     $amount = $int->getAmountTechnician();
  1457.                     $amountExtra = $int->takeAllExtraAmount();
  1458.                     $amountNotBillable = $int->takeAllExtraNotBillableAmount();
  1459.                     $total = $int->calculateTotalTechnicianAmount();
  1461.                     $totalCost = $totalCost + $cost;
  1462.                     $totalAmount = $totalAmount + $amount;
  1463.                     $totalAmountExtra = $totalAmountExtra + $amountExtra;
  1464.                     $totalAmountNotBillable = $totalAmountNotBillable + $amountNotBillable;
  1465.                     $totalTotal = $totalTotal + $total;
  1466.                     fputcsv($handle, array($provinceSign, $cityName, $zip, $operation, $ticket, $client, $termid, $datetime, $outcome, $activities, number_format($cost, 2, '.', ','), number_format($amount, 2, '.', ','), number_format($amountExtra, 2, '.', ','), number_format($amountNotBillable, 2, '.', ','), number_format($total, 2, '.', ',')), ";", '"', "\\");
  1467.                 }
  1468.                 fputcsv($handle, array('Totali', '', '', '', '', '', '', '', '', '', number_format($totalCost, 2, '.', ','), number_format($totalAmount, 2, '.', ','), number_format($totalAmountExtra, 2, '.', ','), number_format($totalAmountNotBillable, 2, '.', ','), number_format($totalTotal, 2, '.', ',')), ";", '"', "\\");
  1469.                 fclose($handle);
  1470.             });
  1471.         
  1472.             $response->setStatusCode(200);
  1473.             $dispositionHeader = $response->headers->makeDisposition(ResponseHeaderBag::DISPOSITION_ATTACHMENT, 'Riassunto economico '.$user.' --- '.$year.'-'.$month.'.csv');
  1474.             $response->headers->set('Content-Type', 'text/csv; charset=ISO-8859-15');
  1475.             $response->headers->set('Content-Disposition', $dispositionHeader);
  1476.             return $response;
  1477.         }
  1478.     //
  1479. }