src/Controller/User/UserUserController.php line 85

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