src/Controller/User/UserUserController.php line 88

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