src/Controller/UserController.php line 300

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\User;
  6. use App\Form\UserType;
  7. use App\Entity\Mailling;
  8. use App\Entity\Dashboard;
  9. use App\Form\DashboardType;
  10. use App\Notification\MaillingNotification;
  11. use App\Repository\NoteRepository;
  12. use App\Repository\UserRepository;
  13. use App\Service\Calendar;
  14. use DateTime;
  15. use DateTimeInterface;
  16. use Doctrine\ORM\EntityManagerInterface;
  17. use Dotenv\Dotenv;
  18. use Knp\Component\Pager\PaginatorInterface;
  19. use Symfony\Component\HttpFoundation\Request;
  20. use Symfony\Component\HttpFoundation\Response;
  21. use Symfony\Component\Routing\Annotation\Route;
  22. use Symfony\Component\HttpFoundation\JsonResponse;
  23. use Symfony\Component\Form\Extension\Core\Type\TextType;
  24. use Symfony\Component\Form\Extension\Core\Type\EmailType;
  25. use Symfony\Component\Form\Extension\Core\Type\IntegerType;
  26. use Symfony\Component\Form\Extension\Core\Type\PasswordType;
  27. use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
  28. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  29. use Symfony\Component\PasswordHasher\Hasher\UserPasswordHasherInterface;
  31. /**
  32.  * @Route("/user")
  33.  */
  34. class UserController extends AbstractController
  35. {
  37.     public $passwordHasher;
  38.     public $maillingNotification;
  39.     public $em;
  40.     public function __construct(UserPasswordHasherInterface $passwordHasher, MaillingNotification $maillingNotification, EntityManagerInterface $em)
  41.     {
  42.         $this->passwordHasher = $passwordHasher;
  43.         $this->em = $em;
  44.         $this->maillingNotification = $maillingNotification;
  45.     }
  46.     /**
  47.      *@Route("/", name="user.index", methods={"GET", "POST"})
  48.      */
  49.     public function index(Request $request, UserRepository $userRepository, PaginatorInterface $paginator)
  50.     {
  51.         if (!in_array('ROLE_MASTER', $this->getUser()->getRoles())) {
  52.             return $this->redirectToRoute('dashboard.index', [], Response::HTTP_SEE_OTHER);
  53.         }
  54.         $search = trim($request->query->get('search') ?? '');
  55.         if ($request->request->get('search')) {
  56.             $search = trim($request->request->get('search'));
  57.         }
  58.         $users = $paginator->paginate(
  59.             $userRepository->findAllUsers($search),
  60.             $request->query->getInt('page', 1),
  61.             20
  62.         );
  64.         if ($request->isXmlHttpRequest()) {
  65.             return new JsonResponse([
  66.                 'users' => $this->renderView('user/user_tab.html.twig', ['users' => $users]),
  67.             ]);
  68.         }
  70.         return $this->render('user/index.html.twig', [
  71.             'users' => $users,
  72.             'current_page' => 'user'
  73.         ]);
  74.     }
  77.     /**
  78.      *@Route("/analytics", name="user.analytics")
  79.      */
  80.     public function analytics(Request $request, UserRepository $userRepository)
  81.     {
  82.         $userID = $request->query->get('user') ?? null;
  83.         $users = $userRepository->getStatsInfo($userID);
  84.         $pages = [];
  85.         extract($this->getStats($users, 'all'));
  86.         $pages = [];
  87.         foreach ($users_stats as $stats) {
  88.             $sums = array();
  89.             foreach (array_keys($pages + $stats) as $key) {
  90.                 if (array_key_exists($key, $pages) and $pages[$key] != null) {
  91.                     if (!is_string($pages[$key])) {
  92.                         $sums[$key] = @($pages[$key] + $stats[$key]);
  93.                     }
  94.                 } else {
  95.                     $sums[$key] = $stats[$key];
  96.                 }
  97.             }
  98.             $pages = $sums;
  99.         }
  100.         $name = '';
  101.         if ($userID != null && !empty($pages)) {
  102.             $name = $pages['firstName'] . ' ' . $pages['name'];
  103.         }
  104.         unset($pages['firstName']);
  105.         unset($pages['name']);
  106.         unset($pages['company_name']);
  107.         unset($pages['email']);
  108.         unset($pages['phone']);
  109.         arsort($pages);
  111.         return $this->render('user/analytics.html.twig', [
  112.             'name' => $name,
  113.             'pages' => $pages,
  114.             'current_page' => 'stats'
  115.         ]);
  116.     }
  117.     /**
  118.      *@Route("/analytics-user/", name="user.analytics_user")
  119.      */
  120.     public function analytics_user(Request $request, UserRepository $userRepository)
  121.     {
  122.         $page = $request->query->get('page');
  123.         $users = $userRepository->getStatsInfo();
  124.         $defaultMonth = $request->request->get('periodeSelect') ?? 'all';
  126.         extract($this->getStats($users, $defaultMonth));
  127.         return $this->render('user/analytics-user.html.twig', [
  128.             'users_stats'   => $users_stats,
  129.             'all_mois'      => $all_mois,
  130.             'defaultMonth'  => $defaultMonth,
  131.             'page'          => $page,
  132.             'current_page'  => 'stats'
  133.         ]);
  134.     }
  136.     private function getStats($users, $defaultMonth)
  137.     {
  138.         $users_stats = [];
  139.         $all_mois = [];
  140.         $i = 0;
  141.         foreach ($users as $user) {
  142.             if (array_key_exists('mois', $user['dashboard_info'])) {
  143.                 foreach ($user['dashboard_info']['mois'] as $mois => $value) {
  144.                     $all_mois[$mois] = 1;
  145.                     if ($mois != $defaultMonth && $defaultMonth != 'all') {
  146.                         continue;
  147.                     }
  148.                     $value['firstName'] = $user['firstName'];
  149.                     $value['name'] = $user['name'];
  150.                     $value['company_name'] = $user['company_name'];
  151.                     $value['email'] = $user['email'];
  152.                     $value['phone'] = $user['phone'];
  153.                     if ($defaultMonth == 'all') {
  154.                         $sums = array();
  155.                         if (array_key_exists($i, $users_stats)) {
  156.                             foreach (array_keys($users_stats[$i] + $value) as $key) {
  157.                                 $sums[$key] = @(intval($users_stats[$i][$key]) + intval($value[$key]));
  158.                             }
  159.                             $sums['firstName'] = $user['firstName'];
  160.                             $sums['name'] = $user['name'];
  161.                             $sums['company_name'] = $user['company_name'];
  162.                             $sums['email'] = $user['email'];
  163.                             $sums['phone'] = $user['phone'];
  164.                             $users_stats[$i] = $sums;
  165.                         } else {
  166.                             $users_stats[$i] = $value;
  167.                         }
  168.                     } else {
  169.                         $users_stats[$mois][] = $value;
  170.                     }
  171.                 }
  172.             }
  173.             $i++;
  174.         }
  175.         return ['users_stats' => $users_stats, 'all_mois' => $all_mois, 'defaultMonth' => $defaultMonth];
  176.     }
  177.     /**
  178.      *@Route("/add", name="user.add")
  179.      */
  180.     public function add(Request $request, UserRepository $userRepository)
  181.     {
  182.         if (!in_array('ROLE_MASTER', $this->getUser()->getRoles())) {
  183.             return $this->redirectToRoute('dashboard.index', [], Response::HTTP_SEE_OTHER);
  184.         }
  186.         $user = new User();
  187.         $form = $this->createForm(UserType::class, $user);
  188.         $requestData = $request->request->get('user');
  189.         if ($requestData != null) {
  190.             switch ($requestData['account_type']) {
  191.                 case 0:
  192.                     $user->setParentId(0);
  193.                     $user->setRoles(['ROLE_USER', 'ROLE_SUPER_ADMIN']);
  194.                     $user->setApiKey(base_convert(hash('sha256', time() . mt_rand()), 16, 36));
  195.                     break;
  196.                 case 1:
  197.                     $user->setParentId($requestData['parent']);
  198.                     $user->setRoles(['ROLE_USER']);
  199.                     $user->setApiKey($userRepository->find($requestData['parent'])->getApiKey());
  200.                     break;
  201.                 case 2:
  202.                     $user->setParentId($requestData['parent']);
  203.                     $user->setRoles(['ROLE_USER', 'ROLE_MANDATAIRE']);
  204.                     $user->setApiKey(base_convert(hash('sha256', time() . mt_rand()), 16, 36));
  205.                     break;
  206.             }
  207.             $user->setDashboardInfo(json_decode(
  208.                 '{
  209.                     "rdv": 0,
  210.                     "mandats": 0,
  211.                     "ca_genere": 0,
  212.                     "ca_potentiel": 0,
  213.                     "ca_previsionnel": 0
  214.                 }',
  215.                 true
  216.             ));
  217.             $user->setPlainPassword($this->setPassword())
  218.                 ->setPassword($this->passwordHasher->hashPassword($user, $user->getPlainPassword()));
  219.             $password = $user->getPlainPassword();
  220.         }
  222.         $form->handleRequest($request);
  224.         if ($form->isSubmitted() && $form->isValid()) {
  225.             $this->em->persist($user);
  226.             $this->em->flush();
  227.             if ($user->getParentId() == 0) {
  228.                 $user->setParentId($user->getId());
  229.                 $this->em->flush($user);
  230.             }
  231.             $mailling = new Mailling();
  232.             $mailling->setSubject('Votre compte Integraal');
  233.             $mailling->setMessage('
  234.                 <h3>Bienvenue sur Integraal</h3>
  235.                 <p>Voici vos identifiants pour vous connecter à la plateforme : </p>
  236.                 <p>
  237.                     Adresse email : ' . $user->getEmail() . '<br>
  238.                     Mot de passe : ' . $password . '<br>
  239.                     ' . $this->generateUrl('app.login', [], UrlGeneratorInterface::ABSOLUTE_URL) . '
  240.                 </p>');
  241.             $mailling->setEmailFrom('no-reply@integraal.io');
  242.             $mailling->setEmailTo($user->getEmail());
  243.             $this->maillingNotification->notify($mailling);
  244.             return $this->redirectToRoute('user.index', [], Response::HTTP_SEE_OTHER);
  245.         }
  247.         return $this->render('user/add.html.twig', [
  248.             'form' => $form->createView(),
  249.             'current_page' => 'user'
  250.         ]);
  251.     }
  253.     /**
  254.      *@Route("/{id}/edit", name="user.edit", methods={"GET", "POST"})
  255.      */
  256.     public function edit(User $user, Request $request)
  257.     {
  258.         if (!in_array('ROLE_MASTER', $this->getUser()->getRoles())) {
  259.             return $this->redirectToRoute('dashboard.index', [], Response::HTTP_SEE_OTHER);
  260.         }
  261.         $sendNewId = false;
  262.         if ($request->request->get('user') != null && $user->getEmail() != $request->request->get('user')['email']) {
  263.             $sendNewId = true;
  264.         }
  265.         $form = $this->createForm(UserType::class, $user);
  266.         $form->handleRequest($request);
  268.         if ($form->isSubmitted() && $form->isValid()) {
  269.             $this->em->flush($user);
  270.             if ($sendNewId) $this->sendNewIdentifiant($user, '<i>Le mot de passe que vous avez défini.</i>');
  271.             return $this->redirectToRoute('user.index', [], Response::HTTP_SEE_OTHER);
  272.         }
  273.         return $this->render('user/add.html.twig', [
  274.             'form' => $form->createView(),
  275.             'button_label' => 'Editer l\'utilisateur',
  276.             'edit'  => true,
  277.             'current_page' => 'user'
  278.         ]);
  279.     }
  281.     /**
  282.      *@Route("/{id}/resetpwd", name="user.resetPassword")
  283.      */
  284.     public function resetPassword(User $user, Request $request)
  285.     {
  286.         if ($this->isCsrfTokenValid('reset-password' . $user->getId(), $request->get('_token'))) {
  287.             $user->setPlainPassword($this->setPassword())
  288.                 ->setPassword($this->passwordHasher->hashPassword($user, $user->getPlainPassword()));
  289.             $password = $user->getPlainPassword();
  290.             $this->em->flush($user);
  292.             $this->sendNewIdentifiant($user, $password);
  293.         }
  294.         return $this->redirectToRoute('user.index', [], Response::HTTP_SEE_OTHER);
  295.     }
  297.     /**
  298.      *@Route("/forgotPassword", name="user.forgotPassword", methods={"GET", "POST"})
  299.      */
  300.     public function forgotPassword(Request $request, UserRepository $userRepository)
  301.     {
  303.         if ($request->request->get('email')) {
  304.             if ($this->isCsrfTokenValid('reset-pwd', $request->get('_token'))) {
  305.                 $users = $userRepository->findBy(['email' => $request->request->get('email')]);
  306.                 if ($users) {
  307.                     $user = $users[0];
  308.                     $user->setPlainPassword($this->setPassword())
  309.                         ->setPassword($this->passwordHasher->hashPassword($user, $user->getPlainPassword()));
  310.                     $password = $user->getPlainPassword();
  311.                     $this->em->flush($user);
  313.                     $this->sendNewIdentifiant($user, $password);
  314.                     return $this->render('user/forgot_finish.html.twig');
  315.                 }
  316.             }
  317.         }
  318.         // if($request->request)
  319.         return $this->render('user/forgot.html.twig');
  320.     }
  322.     private function sendNewIdentifiant(User $user, string $password)
  323.     {
  324.         $mailling = new Mailling();
  325.         $mailling->setSubject('Vos identifiants Integraal');
  326.         $mailling->setMessage('
  327.             <h3>Vos identifiant sur Integraal ont changé</h3>
  328.             <p>Voici vos nouveaux identifiant pour vous connecter à la plateforme :</p>
  329.             <p>
  330.                 Adresse email : ' . $user->getEmail() . '<br>
  331.                 Mot de passe : ' . $password . ' <br>
  332.                 ' . $this->generateUrl('app.login', [], UrlGeneratorInterface::ABSOLUTE_URL) . '
  333.             </p>');
  334.         $mailling->setEmailFrom('no-reply@integraal.io');
  335.         $mailling->setEmailTo($user->getEmail());
  336.         $this->maillingNotification->notify($mailling);
  337.     }
  338.     private function setPassword()
  339.     {
  340.         $comb = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890';
  341.         $pass = array();
  342.         $combLen = strlen($comb) - 1;
  343.         for ($i = 0; $i < 8; $i++) {
  344.             $n = rand(0, $combLen);
  345.             $pass[] = $comb[$n];
  346.         }
  347.         return implode($pass);
  348.     }
  351.     private function verifyPassword($data)
  352.     {
  353.         $password = $data['new_password'];
  354.         $uppercase = preg_match('@[A-Z]@', $password);
  355.         $lowercase = preg_match('@[a-z]@', $password);
  356.         $number    = preg_match('@[0-9]@', $password);
  357.         $specialChars = preg_match('@[^a-z^0-9^A-Z]@', $password);
  358.         if (!$uppercase || !$lowercase || !$number || !$specialChars || strlen($password) < 8) {
  359.             return ['<div class="col-12 alert alert-warning">Le mot de passe doit comporter au moins 8 caractères et doit inclure au moins une lettre minuscule, une lettre majuscule, un chiffre et un caractère spécial</div>'];
  360.         }
  361.         return true;
  362.     }
  364.     /**
  365.      *@Route("/settings", name="user.settings")
  366.      */
  367.     public function settingsAccount(Request $request)
  368.     {
  369.         if ($request->query->get('code')) {
  370.             return $this->setAgendaSync($request->query->get('code'));
  371.         }
  372.         $user = $this->getUser();
  373.         $calendar = new Calendar($user, $this->em);
  374.         $form = $this->createFormBuilder($user)
  375.             ->add('email', EmailType::class, ['label' => 'Email'])
  376.             ->add('first_name', TextType::class, ['label' => 'Prénom'])
  377.             ->add('name', TextType::class, ['label' => 'Nom'])
  378.             ->add('new_password', PasswordType::class, ['mapped' => false, 'label' => 'Nouveau mot de passe'])
  379.             ->add('street', TextType::class, ['label' => 'Adresse'])
  380.             ->add('street_number', IntegerType::class, ['label' => 'N°'])
  381.             ->add('zipcode', TextType::class, ['label' => 'Code postal'])
  382.             ->add('city', TextType::class, ['label' => 'Ville'])
  383.             ->add('phone', TextType::class, ['label' => 'Téléphone'])
  384.             ->add('company_name', TextType::class, ['label' => 'Nom de société (Nom affiché en émetteur d\'email)'])
  385.             ->getForm();
  386.         // $form = $this->createForm(UserType::class, $user);
  387.         $form->handleRequest($request);
  388.         $requestData = $request->request->get('form');
  389.         if ($form->isSubmitted() && $form->isValid()) {
  390.             if (strlen($requestData['new_password']) > 0) {
  391.                 if ($this->verifyPassword($requestData) === true) {
  392.                     $user->setPlainPassword($requestData['new_password'])
  393.                         ->setPassword($this->passwordHasher->hashPassword($user, $user->getPlainPassword()));
  394.                     $password = $user->getPlainPassword();
  395.                     $this->sendNewIdentifiant($user, $password);
  396.                 } else {
  397.                     return $this->render('user/settings.html.twig', [
  398.                         'form' => $form->createView(),
  399.                         'current_sub_page' => 'account_settings',
  400.                         'current_page' => 'user',
  401.                         'error' => $this->verifyPassword($requestData) ?? '',
  402.                         'syncLink' => $calendar->getAuthLink($this->generateUrl('user.settings', [], UrlGeneratorInterface::ABSOLUTE_URL))
  403.                     ]);
  404.                 }
  405.                 $this->em->flush($user);
  406.             } else {
  407.                 $this->em->flush($user);
  408.             }
  409.             $this->addFlash(
  410.                 'notice',
  411.                 'Les changements ont été sauvegardé.'
  412.             );
  413.             return $this->redirectToRoute('user.settings', [], Response::HTTP_SEE_OTHER);
  414.         }
  415.         return $this->render('user/settings.html.twig', [
  416.             'form' => $form->createView(),
  417.             'current_sub_page' => 'account_settings',
  418.             'current_page' => 'user',
  419.             'error' => $error ?? '',
  420.             'syncLink' => $calendar->getAuthLink($this->generateUrl('user.settings', [], UrlGeneratorInterface::ABSOLUTE_URL))
  421.         ]);
  422.     }
  424.     private function setAgendaSync($code = '', $reset = false)
  425.     {
  426.         $user = $this->getUser();
  427.         $calendar = new Calendar($this->getUser(), $this->em);
  429.         if ($reset) {
  430.             $user->setAgendaToken(NULL);
  431.             $user->setAgendaRefreshToken(NULL);
  432.             $user->setAgendaExpireIn(NULL);
  433.             $user->setAgendaProfile(NULL);
  434.             $this->em->flush($user);
  435.         }
  436.         if ($code != '') {
  437.             $token = $calendar->getUserToken($this->generateUrl('user.settings', [], UrlGeneratorInterface::ABSOLUTE_URL), $code);
  438.             $user->setAgendaToken($token['access']);
  439.             $user->setAgendaRefreshToken($token['refresh']);
  440.             $user->setAgendaExpireIn(time() + $token['expireIn']);
  441.             $user->setAgendaProfile($token['profile']);
  442.             $this->em->flush($user);
  443.         }
  444.         return $this->redirectToRoute('user.settings', [], Response::HTTP_SEE_OTHER);
  445.     }
  446.     /**
  447.      * @Route("/unsync", name="user.settings.unsync", methods={"GET"})
  448.      */
  449.     public function unsync(UserRepository $userRepository)
  450.     {
  451.         return $this->setAgendaSync('', true);
  452.     }
  453.     /**
  454.      * @Route("/change-user", name="user.changeUser", methods={"POST"})
  455.      */
  456.     public function changeUser(Request $request, UserRepository $userRepository): Response
  457.     {
  458.         if ($request->isXmlHttpRequest()) {
  459.             if ($request->request->get('PossessUser') == 'all') {
  460.                 $request->getSession()->set('userPossess', 'all');
  461.             } else {
  462.                 $request->getSession()->set('userPossess', $userRepository->find($request->request->get('PossessUser')));
  463.             }
  464.             return new JsonResponse([
  465.                 'redirect' => $request->headers->get('referer')
  466.             ]);
  467.         }
  468.     }
  469.     /**
  470.      * @Route("/delete/{id}", name="user.delete", methods={"POST"})
  471.      */
  472.     public function delete(Request $request, User $user, UserRepository $userRepository, NoteRepository $noteRepository): Response
  473.     {
  474.         $remove_id = $user->getId();
  476.         if ($this->isCsrfTokenValid('delete' . $remove_id, $request->request->get('_token'))) {
  477.             $parent = $userRepository->findBy(['id' => $user->getParentId()])[0];
  478.             $notes = $noteRepository->findBy(['user' => $user->getId()]);
  480.             if ($parent == $user) {
  481.                 $users = $userRepository->getAllAgent($parent->getId());
  482.                 foreach ($users as $userRelation) {
  483.                     if ($userRelation != $parent) {
  484.                         $this->removeUserRelation($userRelation, $userRepository, $noteRepository);
  485.                         $this->em->remove($userRelation);
  486.                     }
  487.                 }
  488.                 foreach ($user->getTasksActor() as $item) {
  489.                     $this->em->remove($item);
  490.                     $this->em->flush();
  491.                 }
  492.                 foreach ($user->getTasks() as $item) {
  493.                     $this->em->remove($item);
  494.                     $this->em->flush();
  495.                 }
  496.                 foreach ($user->getMaillings() as $item) {
  497.                     $this->em->remove($item);
  498.                     $this->em->flush();
  499.                 }
  500.                 foreach ($user->getMarkers() as $item) {
  501.                     $this->em->remove($item);
  502.                     $this->em->flush();
  503.                 }
  504.                 foreach ($user->getNotifications() as $item) {
  505.                     $this->em->remove($item);
  506.                     $this->em->flush();
  507.                 }
  508.                 foreach ($notes as $item) {
  509.                     $this->em->remove($item);
  510.                     $this->em->flush();
  511.                 }
  512.                 foreach ($user->getLeadsByPossessor() as $item) {
  513.                     $this->em->remove($item);
  514.                     $this->em->flush();
  515.                 }
  516.             } else {
  517.                 $this->removeUserRelation($user, $userRepository, $noteRepository);
  518.             }
  519.             $this->em->remove($user);
  520.             $this->em->flush();
  521.             if ($request->isXmlHttpRequest()) {
  522.                 return new JsonResponse([
  523.                     'remove' => 'true'
  524.                 ]);
  525.             }
  526.         }
  527.         return $this->redirectToRoute('user.index', [], Response::HTTP_SEE_OTHER);
  528.     }
  530.     private function removeUserRelation(User $user, UserRepository $userRepository, NoteRepository $noteRepository)
  531.     {
  532.         $parent = $userRepository->findBy(['id' => $user->getParentId()])[0];
  533.         $notes = $noteRepository->findBy(['user' => $user->getId()]);
  534.         foreach ($user->getTasksActor() as $item) {
  535.             $item->setUser($parent);
  536.             $item->setUserAction($parent);
  537.             $this->em->flush();
  538.         }
  539.         foreach ($user->getTasks() as $item) {
  540.             $item->setUser($parent);
  541.             $item->setUserAction($parent);
  542.             $this->em->flush();
  543.         }
  544.         foreach ($user->getMaillings() as $item) {
  545.             $item->setUser($parent);
  546.             $this->em->flush();
  547.         }
  548.         foreach ($user->getMarkers() as $item) {
  549.             $item->setUser($parent);
  550.             $this->em->flush();
  551.         }
  552.         foreach ($user->getNotifications() as $item) {
  553.             $item->setUser($parent);
  554.             $item->setIsSeen(0);
  555.             $this->em->flush();
  556.         }
  557.         foreach ($notes as $item) {
  558.             $item->setUser($parent);
  559.             $this->em->flush();
  560.         }
  561.         foreach ($user->getLeads() as $item) {
  562.             $item->setUser($parent);
  563.             $this->em->flush();
  564.         }
  565.     }
  566. }