src/Controller/ManagerController.php line 1555

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\Account;
  6. use App\Entity\ActionStd;
  7. use App\Entity\ActionStdDocument;
  8. use App\Entity\Credit;
  9. use App\Entity\Document;
  10. use App\Entity\DocumentType;
  11. use App\Entity\Info;
  12. use App\Entity\LoginLog;
  13. use App\Entity\Manager;
  14. use App\Entity\Partner;
  15. use App\Entity\Subcontractor;
  16. use App\Entity\SubcontractorStd;
  17. use App\Entity\SubcontractorStdDocument;
  18. use App\Entity\Subscription;
  19. use App\Entity\System;
  20. use App\Entity\SystemStd;
  21. use App\Entity\Training;
  22. use App\Entity\TrainingRequest;
  23. use App\Entity\TrainingRequestHistory;
  24. use App\Entity\Treatment;
  25. use App\Entity\TreatmentStd;
  26. use App\Entity\User;
  27. use App\Entity\UserDocument;
  28. use App\Form\ActionStdTranslateType;
  29. use App\Form\ActionStdType;
  30. use App\Form\InfoType;
  31. use App\Form\ManagerType;
  32. use App\Form\PartnerType;
  33. use App\Form\SubcontractorStdTranslateType;
  34. use App\Form\SubcontractorStdType;
  35. use App\Form\SubcontractorType;
  36. use App\Form\SubscriptionType;
  37. use App\Form\SubscriptionUserType;
  38. use App\Form\SystemStdTranslateType;
  39. use App\Form\SystemStdType;
  40. use App\Form\SystemType;
  41. use App\Form\TrainingTranslateType;
  42. use App\Form\TrainingType;
  43. use App\Form\TreatmentStdTranslateType;
  44. use App\Form\TreatmentStdType;
  45. use App\Form\TreatmentType;
  46. use App\Form\UserType;
  47. use App\Pdf\MyPdf;
  48. use Doctrine\ORM\EntityRepository;
  49. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  50. use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;
  51. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  52. use Symfony\Bridge\Doctrine\Form\Type\EntityType;
  53. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  54. use Symfony\Component\Form\Extension\Core\Type\CheckboxType;
  55. use Symfony\Component\Form\Extension\Core\Type\ChoiceType;
  56. use Symfony\Component\Form\Extension\Core\Type\EmailType;
  57. use Symfony\Component\Form\Extension\Core\Type\FileType;
  58. use Symfony\Component\Form\Extension\Core\Type\IntegerType;
  59. use Symfony\Component\Form\Extension\Core\Type\NumberType;
  60. use Symfony\Component\Form\Extension\Core\Type\PasswordType;
  61. use Symfony\Component\Form\Extension\Core\Type\RepeatedType;
  62. use Symfony\Component\Form\Extension\Core\Type\TextareaType;
  63. use Symfony\Component\Form\Extension\Core\Type\TextType;
  64. use Symfony\Component\HttpFoundation\File\UploadedFile;
  65. use Symfony\Component\HttpFoundation\JsonResponse;
  66. use Symfony\Component\HttpFoundation\Request;
  67. use Symfony\Component\HttpFoundation\StreamedResponse;
  68. use Symfony\Component\HttpKernel\Exception\NotFoundHttpException;
  69. use Symfony\Component\Routing\Annotation\Route;
  70. use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
  71. use Symfony\Component\Security\Core\Authentication\Token\PreAuthenticatedToken;
  72. use Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken;
  73. use Symfony\Component\Security\Http\Event\InteractiveLoginEvent;
  74. use Symfony\Component\Serializer\Encoder\JsonEncoder;
  75. use Symfony\Component\Serializer\Normalizer\ObjectNormalizer;
  76. use Symfony\Component\Serializer\Serializer;
  77. use App\Security\PasswordEncoder;
  78. use Symfony\Component\Validator\Constraints as Assert;
  79. use function Doctrine\ORM\QueryBuilder;
  80. use Qipsius\TCPDFBundle\Controller\TCPDFController;
  82. /**
  83.  * @Route("/manager", name="manager_")
  84.  */
  85. class ManagerController extends AbstractController
  86. {
  87.     /**
  88.      * @Route("/", name="homepage")
  89.      */
  90.     public function indexAction(Request $request)
  91.     {
  92.         return $this->redirectToRoute("manager_users");
  93.     }
  95.     /**
  96.      * @Route("/account", name="account")
  97.      */
  98.     public function accountAction(Request $request)
  99.     {
  100.         $em = $this->getDoctrine()->getManager();
  102.         $account = $this->getUser();
  104.         $r_email = $account->getEmail();
  106.         $form = $this->createForm(ManagerType::class, $account->getManager());
  108.         $form['email']->setData($account->getEmail());
  110.         $form2 = $this->createFormBuilder()
  111.             ->add('password', RepeatedType::class, array(
  112.                 'type' => PasswordType::class,
  113.                 'invalid_message' => 'Les mot de passe ne sont pas identiques',
  114.                 'first_options'  => array(
  115.                     'attr' => array(
  116.                         'placeholder' => 'Changer mot de passe'
  117.                     ),
  118.                     'constraints' =>[
  119.                         new Assert\NotBlank([
  120.                             'message' => 'Merci de saisir un mot de passe'
  121.                         ]),
  122.                         new Assert\Regex([
  123.                             'pattern' => '/^(?:(?=(\S*?[A-Z]){1})(?=(\S*?[a-z]){1})(?=(\S*?[0-9]){1})(?=\S*?[~!^(){}<>%@#&*+=_\-$`,.\/\\\;:\'"|\[\]]){1}.{12,})$/m',
  124.                             'message' => "Votre mot de passe doit respecter les recommandations de l'ANSSI : au moins 12 caractères de types différents (majuscules, minuscules, chiffres, caractères spéciaux)"
  125.                         ])
  126.                     ],
  127.                     'label' => "Nouveau mot de passe"
  128.                 ),
  129.                 'second_options' => array(
  130.                     'attr' => array(
  131.                         'placeholder' => 'Confirmation mot de passe'
  132.                     ),
  133.                     'label' => "Confirmez le mot de passe"
  134.                 ),
  135.                 'mapped' => false
  136.             ))->getForm();
  138.         $form->handleRequest($request);
  139.         $form2->handleRequest($request);
  141.         if ($form->isSubmitted() && $form->isValid()) {
  142.             $em->flush();
  143.             $this->get('session')->getFlashBag()->add('success', 'Profil mis à jour');
  145.             if ($r_email != $form['email']->getData()) {
  146.                 if (filter_var($form['email']->getData(), FILTER_VALIDATE_EMAIL)) {
  147.                     $other_account = $em->getRepository(Account::class)->findOneBy(['email' => $form['email']->getData()]);
  148.                     if ($other_account && $other_account->getId() != $account->getId()) {
  149.                         $this->get('session')->getFlashBag()->add('danger', 'Cette adresse mail est déjà utilisée par un autre utilisateur');
  150.                     } else {
  151.                         $account->setEmail($form['email']->getData());
  152.                         $account->getManager()->setEmail($form['email']->getData());
  154.                         $em->flush();
  156.                         $oldToken = $this->get('security.token_storage')->getToken();
  158.                         $token = new UsernamePasswordToken(
  159.                             $account, //user object with updated username
  160.                             $oldToken->getFirewallName());
  161.                         $this->get('security.token_storage')->setToken($token);
  163.                         $this->get('session')->getFlashBag()->add('success', 'Identifiant de connexion modifié');
  164.                     }
  165.                 } else {
  166.                     $this->get('session')->getFlashBag()->add('danger', 'Cette adresse mail n\'est pas valide');
  167.                 }
  168.             }
  170.             return $this->redirectToRoute('manager_account');
  171.         }
  172.         if ($form2->isSubmitted() && $form2->isValid()) {
  173.             $salt = md5(uniqid());
  174.             $pwd = $form2['password']->getData();
  175.             $account->setSalt($salt);
  176.             $PasswordEncoder = new PasswordEncoder;
  177.             $enc_pwd = $PasswordEncoder->encodePassword($pwd, $salt);
  178.             $account->setPassword($enc_pwd);
  180.             $em->flush();
  182.             $this->get('session')->getFlashBag()->add('success', 'Mot de passe mis à jour');
  184.             return $this->redirectToRoute('manager_account');
  185.         }
  187.         return $this->render('manager/account.html.twig', [
  188.             'form' => $form->createView(),
  189.             'form2' => $form2->createView(),
  190.         ]);
  191.     }
  193.     /**
  194.      * @Route("/managers", name="managers")
  195.      */
  196.     public function managersAction(Request $request)
  197.     {
  198.         if (!$this->isGranted("ROLE_DPO")) {
  199.             throw new NotFoundHttpException();
  200.         }
  202.         $managers = $this->getDoctrine()->getRepository(Manager::class)->findAll();
  204.         return $this->render('manager/managers.html.twig', [
  205.             "managers" => $managers
  206.         ]);
  207.     }
  209.     /**
  210.      * @Route("/managers/add", name="managers_add")
  211.      */
  212.     public function managersAddAction(Request $request)
  213.     {
  214.         if (!$this->isGranted("ROLE_DPO")) {
  215.             throw new NotFoundHttpException();
  216.         }
  218.         $manager = new Manager();
  220.         $form = $this->createForm(ManagerType::class, $manager)
  221.             ->add('role', ChoiceType::class, [
  222.                 'attr' => [
  223.                     'placeholder' => 'Type de compte'
  224.                 ],
  225.                 'label' => 'Type de compte',
  226.                 'choices' => [
  227.                     "A définir" => "ROLE_MANAGER",
  228.                     "Administrateur" => "ROLE_ADMIN",
  229.                     "DPO" => "ROLE_DPO",
  230.                     "Juriste" => "ROLE_JURISTE",
  231.                     "Commerce" => "ROLE_COMMERCE",
  232.                 ],
  233.                 'required' => true,
  234.                 'mapped' => false
  235.             ])
  236.         ;
  238.         $form->handleRequest($request);
  240.         if ($form->isSubmitted() && $form->isValid()) {
  241.             $em = $this->getDoctrine()->getManager();
  243.             if ($form['email']->getData()) {
  244.                 if (filter_var($form['email']->getData(), FILTER_VALIDATE_EMAIL)) {
  245.                     $other_account = $em->getRepository(Account::class)->findOneBy(['email' => $form['email']->getData()]);
  246.                     if ($other_account) {
  247.                         $this->get('session')->getFlashBag()->add('danger', 'Cette adresse mail est déjà utilisée par un autre utilisateur');
  248.                     } else {
  249.                         $manager->setEmail($form['email']->getData());
  250.                     }
  251.                 } else {
  252.                     $this->get('session')->getFlashBag()->add('danger', 'Cette adresse mail n\'est pas valide');
  253.                 }
  254.             }
  256.             if ($manager->getEmail()) {
  257.                 $now = new \DateTime("now");
  259.                 $em->persist($manager);
  261.                 $account = new Account();
  262.                 $account->setEmail($manager->getEmail());
  263.                 $account->setEnabled(true);
  264.                 $account->setManager($manager);
  265.                 $account->setRegistrationDate($now);
  266.                 $account->setRoles([$form['role']->getData()]);
  268.                 $salt = md5(uniqid());
  269.                 $pwd = "";
  270.                 $characters = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
  271.                 $charactersLength = strlen($characters);
  272.                 for ($i = 0; $i < 12; $i++) {
  273.                     $pwd .= $characters[rand(0, $charactersLength - 1)];
  274.                 }
  275.                 $account->setSalt($salt);
  276.                 $PasswordEncoder = new PasswordEncoder;
  277.                 $enc_pwd = $PasswordEncoder->encodePassword($pwd, $salt);
  278.                 $account->setPassword($enc_pwd);
  280.                 $em->persist($account);
  282.                 $em->flush();
  284.                 $this->get('session')->getFlashBag()->add('success', 'Nouveau délégué ajouté');
  285.                 return $this->redirectToRoute("manager_managers");
  286.             }
  287.         }
  289.         return $this->render('manager/managers_add.html.twig', [
  290.             "form" => $form->createView(),
  291.         ]);
  292.     }
  294.     /**
  295.      * @Route("/managers/{id}/edit", name="managers_edit")
  296.      */
  297.     public function managersEditAction(Request $request, Manager $manager)
  298.     {
  299.         if (!$this->isGranted("ROLE_DPO")) {
  300.             throw new NotFoundHttpException();
  301.         }
  302.         if ($manager->getAccount()->getId() == $this->getUser()->getId()) {
  303.             return $this->redirectToRoute("manager_account");
  304.         }
  306.         $r_email = $manager->getEmail();
  308.         $form = $this->createForm(ManagerType::class, $manager)
  309.             ->add('role', ChoiceType::class, [
  310.                 'attr' => [
  311.                     'placeholder' => 'Type de compte'
  312.                 ],
  313.                 'label' => 'Type de compte',
  314.                 'choices' => [
  315.                     "A définir" => "ROLE_MANAGER",
  316.                     "Administrateur" => "ROLE_ADMIN",
  317.                     "DPO" => "ROLE_DPO",
  318.                     "Juriste" => "ROLE_JURISTE",
  319.                     "Commerce" => "ROLE_COMMERCE",
  320.                 ],
  321.                 'required' => true,
  322.                 'mapped' => false
  323.             ])
  324.             ->add('enabled', CheckboxType::class, [
  325.                 'label' => "Compte actif",
  326.                 'required' => false,
  327.                 'mapped' => false
  328.             ])
  329.         ;
  331.         $form['email']->setData($manager->getEmail());
  332.         $form['enabled']->setData($manager->getAccount()->isEnabled());
  333.         $form['role']->setData($manager->getAccount()->getRoles()[0]);
  335.         $form->handleRequest($request);
  337.         if ($form->isSubmitted() && $form->isValid()) {
  338.             $em = $this->getDoctrine()->getManager();
  340.             $manager->getAccount()->setEnabled($form['enabled']->getData());
  341.             $manager->getAccount()->setRoles([$form['role']->getData()]);
  343.             $this->get('session')->getFlashBag()->add('success', 'Compte mis à jour');
  345.             $em->flush();
  347.             if ($r_email != $form['email']->getData()) {
  348.                 if (filter_var($form['email']->getData(), FILTER_VALIDATE_EMAIL)) {
  349.                     $other_account = $em->getRepository(Account::class)->findOneBy(['email' => $form['email']->getData()]);
  350.                     if ($other_account && $other_account->getId() != $manager->getAccount()->getId()) {
  351.                         $this->get('session')->getFlashBag()->add('danger', 'Cette adresse mail est déjà utilisée par un autre utilisateur');
  352.                     } else {
  353.                         $manager->getAccount()->setEmail($form['email']->getData());
  354.                         $manager->setEmail($form['email']->getData());
  356.                         $em->flush();
  358.                         $this->get('session')->getFlashBag()->add('success', 'Identifiant de connexion modifié');
  359.                     }
  360.                 } else {
  361.                     $this->get('session')->getFlashBag()->add('danger', 'Cette adresse mail n\'est pas valide');
  362.                 }
  363.             }
  365.             return $this->redirectToRoute("manager_managers");
  366.         }
  368.         return $this->render('manager/managers_edit.html.twig', [
  369.             "form" => $form->createView(),
  370.         ]);
  371.     }
  373.     /**
  374.      * @Route("/managers/{id}/delete", name="managers_delete")
  375.      */
  376.     public function managersDeleteAction(Request $request, Manager $manager)
  377.     {
  378.         if (!$this->isGranted("ROLE_DPO")) {
  379.             throw new NotFoundHttpException();
  380.         }
  382.         $em = $this->getDoctrine()->getManager();
  384.         $users = $em->getRepository(User::class)->findBy(['manager' => $manager]);
  385.         $documents = $em->getRepository(Document::class)->findBy(['manager' => $manager]);
  387.         if (count($users) == 0 && count($documents) == 0) {
  388.             $em->remove($manager);
  389.             $em->flush();
  391.             $this->get('session')->getFlashBag()->add('success', 'Compte délégué supprimé');
  392.         } else {
  393.             $form = $this->createFormBuilder()
  394.                 ->add('changeUsers', ChoiceType::class, [
  395.                     'choices' => [
  396.                         "Supprimer les clients" => "0",
  397.                         "Associer à un autre délégué" => "1",
  398.                     ],
  399.                     'data' => '1',
  400.                     'expanded' => true,
  401.                     'multiple' => false,
  402.                 ])
  403.                 ->add('managerUsers', EntityType::class, [
  404.                     'attr' => array(
  405.                         'placeholder' => 'Délégué à la Protection des Données',
  406.                     ),
  407.                     'label' => 'Délégué à la Protection des Données',
  408.                     'expanded' => false,
  409.                     'multiple' => false,
  410.                     'required' => true,
  411.                     'class' => Manager::class,
  412.                     'query_builder' => function (EntityRepository $er) use ( $manager ) {
  413.                         $qb = $er->createQueryBuilder('m');
  414.                         return $qb->where('m.id != :managerId')
  415.                             ->setParameter("managerId", $manager->getId())
  416.                             ->orderBy('m.lastName', 'ASC');
  417.                     },
  418.                     'choice_label' => function(Manager $manager) {
  419.                         return $manager->getFirstName().' '.$manager->getLastName().' ('.$manager->getCompanyName().')';
  420.                     },
  421.                 ])
  422.                 ->add('changeDocuments', ChoiceType::class, [
  423.                     'choices' => [
  424.                         "Supprimer les documents" => "0",
  425.                         "Associer à un autre délégué" => "1",
  426.                     ],
  427.                     'data' => '1',
  428.                     'expanded' => true,
  429.                     'multiple' => false,
  430.                 ])
  431.                 ->add('managerDocuments', EntityType::class, [
  432.                     'attr' => array(
  433.                         'placeholder' => 'Délégué à la Protection des Données',
  434.                     ),
  435.                     'label' => 'Délégué à la Protection des Données',
  436.                     'expanded' => false,
  437.                     'multiple' => false,
  438.                     'required' => true,
  439.                     'class' => Manager::class,
  440.                     'query_builder' => function (EntityRepository $er) use ( $manager ) {
  441.                         $qb = $er->createQueryBuilder('m');
  442.                         return $qb->where('m.id != :managerId')
  443.                             ->setParameter("managerId", $manager->getId())
  444.                             ->orderBy('m.lastName', 'ASC');
  445.                     },
  446.                     'choice_label' => function(Manager $manager) {
  447.                         return $manager->getFirstName().' '.$manager->getLastName().' ('.$manager->getCompanyName().')';
  448.                     },
  449.                 ])
  450.                 ->getForm();
  452.             $form->handleRequest($request);
  454.             if ($form->isSubmitted() && $form->isValid()) {
  455.                 $error = false;
  456.                 if ($form['changeDocuments']->getData() && $form['changeDocuments']->getData() == "1") {
  457.                     if (!$form['managerDocuments']->getData()) {
  458.                         $error = true;
  459.                     }
  460.                 }
  461.                 if ($form['changeUsers']->getData() && $form['changeUsers']->getData() == "1") {
  462.                     if (!$form['managerUsers']->getData()) {
  463.                         $error = true;
  464.                     }
  465.                 }
  466.                 if (!$error) {
  467.                     if ($form['changeDocuments']->getData() && $form['changeDocuments']->getData() == "1") {
  468.                         foreach ($documents as $document) {
  469.                             $document->setManager($form['managerDocuments']->getData());
  470.                             $em->flush();
  471.                         }
  472.                     } else {
  473.                         foreach ($documents as $document) {
  474.                             $em->remove($document);
  475.                             $em->flush();
  476.                         }
  477.                     }
  478.                     if ($form['changeUsers']->getData() && $form['changeUsers']->getData() == "1") {
  479.                         foreach ($users as $user) {
  480.                             $user->setManager($form['managerUsers']->getData());
  481.                         }
  482.                     } else {
  483.                         foreach ($users as $user) {
  484.                             $em->remove($user);
  485.                             $em->flush();
  486.                         }
  487.                     }
  489.                     $em->remove($manager);
  490.                     $em->flush();
  492.                     $this->get('session')->getFlashBag()->add('success', 'Compte délégué supprimé');
  494.                     return $this->redirectToRoute("manager_managers");
  495.                 }
  496.             }
  498.             return $this->render('manager/managers_delete.html.twig', [
  499.                 "form" => $form->createView(),
  500.             ]);
  501.         }
  503.         return $this->redirectToRoute("manager_managers");
  504.     }
  506.     /**
  507.      * @Route("/currentsubscriptions", name="current_subscriptions")
  508.      */
  509.     public function currentSubscriptionsAction(Request $request)
  510.     {
  511.         if ($this->isGranted("ROLE_DPO")) {
  512.             $users = $this->getDoctrine()->getRepository(User::class)->findAll();
  513.         } elseif ($this->isGranted("ROLE_JURISTE")) {
  514.             $users = $this->getDoctrine()->getRepository(User::class)->findForManager($this->getUser()->getManager());
  515.         } else {
  516.             $users = $this->getDoctrine()->getRepository(User::class)->findBy(['demo' => true]);
  517.         }
  519.         return $this->render('manager/current_subscriptions.html.twig', [
  520.             "users" => $users,
  521.             "now" => new \DateTime("now"),
  522.         ]);
  523.     }
  525.     /**
  526.      * @Route("/users", name="users")
  527.      */
  528.     public function usersAction(Request $request)
  529.     {
  530.         if ($this->isGranted("ROLE_DPO")) {
  531.             $users = $this->getDoctrine()->getRepository(User::class)->findAll();
  532.         } elseif ($this->isGranted("ROLE_JURISTE")) {
  533.             $users = $this->getDoctrine()->getRepository(User::class)->findForManager($this->getUser()->getManager());
  534.         } else {
  535.             $users = $this->getDoctrine()->getRepository(User::class)->findBy(['demo' => true]);
  536.         }
  538.         return $this->render('manager/users.html.twig', [
  539.             "users" => $users
  540.         ]);
  541.     }
  543.     /**
  544.      * @Route("/users/add", name="users_add")
  545.      */
  546.     public function usersAddAction(Request $request)
  547.     {
  548.         $user = new User();
  550.         $form = $this->createForm(UserType::class, $user);
  552.         if ($this->isGranted("ROLE_DPO")) {
  553.             $isAdmin = true;
  554.         } else {
  555.             $isAdmin = false;
  556.         }
  557.         $manager = $this->getUser()->getManager();
  559.         $form->add('parentUser', EntityType::class, [
  560.                 'attr' => array(
  561.                     'placeholder' => 'Compte client principal',
  562.                 ),
  563.                 'label' => 'Compte client principal',
  564.                 'placeholder' => 'Compte client principal',
  565.                 'expanded' => false,
  566.                 'multiple' => false,
  567.                 'required' => false,
  568.                 'class' => User::class,
  569.                 'query_builder' => function (EntityRepository $er) use ( $user, $manager, $isAdmin ) {
  570.                     $qb = $er->createQueryBuilder('u');
  571.                     if (!$isAdmin) {
  572.                         $qb->andWhere("u.manager = :manager")
  573.                         ->setParameter("manager", $manager);
  574.                     }
  575.                     return $qb->orderBy('u.companyName', 'ASC');
  576.                 },
  577.                 'choice_label' => function(User $queryUser) {
  578.                     return $queryUser->getCompanyName();
  579.                 },
  580.             ])
  581.             ->add('childrenUsers', EntityType::class, [
  582.                 'attr' => array(
  583.                     'placeholder' => 'Comptes clients rattachés',
  584.                 ),
  585.                 'label' => 'Comptes clients rattachés',
  586.                 'placeholder' => 'Comptes clients rattachés',
  587.                 'expanded' => false,
  588.                 'multiple' => true,
  589.                 'required' => false,
  590.                 'class' => User::class,
  591.                 'query_builder' => function (EntityRepository $er) use ( $user, $manager, $isAdmin ) {
  592.                     $qb = $er->createQueryBuilder('u');
  593.                     if (!$isAdmin) {
  594.                         $qb->andWhere("u.manager = :manager")
  595.                             ->setParameter("manager", $manager);
  596.                     }
  597.                     return $qb->orderBy('u.companyName', 'ASC');
  598.                 },
  599.                 'choice_label' => function(User $queryUser) {
  600.                     return $queryUser->getCompanyName();
  601.                 },
  602.             ])
  603.             ;
  605.         if ($this->isGranted("ROLE_DPO")) {
  606.             $form->add('manager', EntityType::class, [
  607.                 'attr' => array(
  608.                     'placeholder' => 'Délégué à la Protection des Données',
  609.                 ),
  610.                 'label' => 'Délégué à la Protection des Données',
  611.                 'expanded' => false,
  612.                 'multiple' => false,
  613.                 'required' => true,
  614.                 'data' => $this->getUser()->getManager(),
  615.                 'class' => Manager::class,
  616.                 'choice_label' => function(Manager $manager) {
  617.                     return $manager->getFirstName().' '.$manager->getLastName().' ('.$manager->getCompanyName().')';
  618.                 },
  619.             ])
  620.                 ->add('managerDpo', CheckboxType::class, [
  621.                 'label' => "Délégué à la Protection des Données",
  622.                 'required' => false
  623.             ])
  624.                 ->add('lawyer', EntityType::class, [
  625.                     'attr' => array(
  626.                         'placeholder' => 'Juriste',
  627.                     ),
  628.                     'label' => 'Juriste',
  629.                     'expanded' => false,
  630.                     'multiple' => false,
  631.                     'required' => false,
  632.                     'class' => Manager::class,
  633.                     'choice_label' => function(Manager $manager) {
  634.                         return $manager->getFirstName().' '.$manager->getLastName().' ('.$manager->getCompanyName().')';
  635.                     },
  636.                 ]);
  637.         } else {
  638.             $form->add('managerDpo', CheckboxType::class, [
  639.                 'label' => "Vous êtes DPO pour ce client",
  640.                 'required' => false
  641.             ]);
  642.         }
  644.         $form->add('demo', CheckboxType::class, [
  645.             'label' => "Compte de démo pour les commerciaux",
  646.             'required' => false
  647.         ]);
  649.         $form->handleRequest($request);
  651.         if ($form->isSubmitted() && $form->isValid()) {
  652.             $em = $this->getDoctrine()->getManager();
  654.             if ($form['email']->getData()) {
  655.                 if (filter_var($form['email']->getData(), FILTER_VALIDATE_EMAIL)) {
  656.                     $other_account = $em->getRepository(Account::class)->findOneBy(['email' => $form['email']->getData()]);
  657.                     if ($other_account) {
  658.                         $this->get('session')->getFlashBag()->add('danger', 'Cette adresse mail est déjà utilisée par un autre utilisateur');
  659.                     } else {
  660.                         $user->setEmail($form['email']->getData());
  661.                     }
  662.                 } else {
  663.                     $this->get('session')->getFlashBag()->add('danger', 'Cette adresse mail n\'est pas valide');
  664.                 }
  665.             }
  667.             if ($user->getEmail()) {
  668.                 $now = new \DateTime("now");
  670.                 if (!$this->isGranted("ROLE_DPO")) {
  671.                     $user->setManager($this->getUser()->getManager());
  672.                 }
  674.                 $em->persist($user);
  676.                 $account = new Account();
  677.                 $account->setEmail($user->getEmail());
  678.                 $account->setEnabled(true);
  679.                 $account->setUser($user);
  680.                 $account->setRegistrationDate($now);
  681.                 $account->setRoles(["ROLE_USER"]);
  683.                 $salt = md5(uniqid());
  684.                 $pwd = "";
  685.                 $characters = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
  686.                 $charactersLength = strlen($characters);
  687.                 for ($i = 0; $i < 12; $i++) {
  688.                     $pwd .= $characters[rand(0, $charactersLength - 1)];
  689.                 }
  690.                 $account->setSalt($salt);
  691.                 $PasswordEncoder = new PasswordEncoder;
  692.                 $enc_pwd = $PasswordEncoder->encodePassword($pwd, $salt);
  693.                 $account->setPassword($enc_pwd);
  695.                 $em->persist($account);
  697.                 $em->flush();
  699.                 if ($form['childrenUsers']->getData()) {
  700.                     foreach ($form['childrenUsers']->getData() as $childUser) {
  701.                         $tmpChildUser = $em->getRepository(User::class)->find($childUser->getId());
  702.                         if ($tmpChildUser) {
  703.                             $tmpChildUser->setParentUser($user);
  704.                             $em->flush();
  705.                         }
  706.                     }
  707.                 }
  709.                 $beginDate = new \DateTime("now");
  710.                 $beginDate->setTime(0, 0, 0);
  711.                 $endDate = clone $beginDate;
  712.                 $endDate->sub(new \DateInterval("P1D"));
  713.                 $endDate->add(new \DateInterval("P30D"));
  715.                 $defaultSubscriptionType = $em->getRepository(\App\Entity\SubscriptionType::class)->findOneBy(["code" => "FREE30D"]);
  716.                 $defaultSubcription = new Subscription();
  717.                 $defaultSubcription->setCreationDate($beginDate);
  718.                 $defaultSubcription->setBeginDate($beginDate);
  719.                 $defaultSubcription->setEndDate($endDate);
  720.                 $defaultSubcription->setPaymentUntil($endDate);
  721.                 $defaultSubcription->setInvolvementMonths(0);
  722.                 $defaultSubcription->setBillingMonths(0);
  723.                 $defaultSubcription->setUnitBillingPrice(0);
  724.                 $defaultSubcription->setActive(true);
  725.                 $defaultSubcription->setUser($user);
  726.                 $defaultSubcription->setType($defaultSubscriptionType);
  728.                 $em->persist($defaultSubcription);
  729.                 $em->flush();
  731.                 $user->setCurrentSubscription($defaultSubcription);
  733.                 $em->flush();
  735.                 if ($user->getParentUser()) {
  736.                     $parentTreatments = $em->getRepository(Treatment::class)->findBy(["user" => $user->getParentUser(), "group" => true]);
  737.                     foreach ($parentTreatments as $parentTreatment) {
  738.                         $user->getGroupTreatments()->add($parentTreatment);
  739.                     }
  740.                     $em->flush();
  741.                 }
  742.                 if ($user->getChildrenUsers()) {
  743.                     $parentTreatments = $em->getRepository(Treatment::class)->findBy(["user" => $user, "group" => true]);
  744.                     foreach ($user->getChildrenUsers() as $childUser) {
  745.                         foreach ($parentTreatments as $parentTreatment) {
  746.                             if (!$childUser->getGroupTreatments()->contains($parentTreatment)) {
  747.                                 $childUser->getGroupTreatments()->add($parentTreatment);
  748.                             }
  749.                         }
  750.                     }
  751.                     $em->flush();
  752.                 }
  754.                 $this->get('session')->getFlashBag()->add('success', 'Nouveau client ajouté');
  755.                 $this->get('session')->getFlashBag()->add('success', 'Abonnement attribué au nouveau client : '.$defaultSubscriptionType->getLibelle());
  757.                 if ($this->isGranted("ROLE_ADMIN")) {
  758.                     return $this->redirectToRoute("manager_subscriptions_user", ["id" => $user->getId()]);
  759.                 } else {
  760.                     return $this->redirectToRoute("manager_users");
  761.                 }
  762.             }
  763.         }
  765.         return $this->render('manager/users_add.html.twig', [
  766.             "form" => $form->createView(),
  767.         ]);
  768.     }
  770.     /**
  771.      * @Route("/users/{id}/edit", name="users_edit")
  772.      */
  773.     public function usersEditAction(Request $request, User $user)
  774.     {
  775.         if (!$this->isGranted("ROLE_DPO")) {
  776.             if ($user->getManager()->getId() != $this->getUser()->getManager()->getId()) {
  777.                 throw new NotFoundHttpException();
  778.             }
  779.         }
  781.         if ($this->isGranted("ROLE_DPO")) {
  782.             $isAdmin = true;
  783.         } else {
  784.             $isAdmin = false;
  785.         }
  786.         $manager = $this->getUser()->getManager();
  788.         $r_email = $user->getEmail();
  790.         $hasParentUser = ($user->getParentUser() != null);
  792.         $childUsersIds = [];
  793.         foreach ($user->getChildrenUsers() as $childUser) {
  794.             $childUsersIds[] = $childUser->getId();
  795.         }
  797.         $form = $this->createForm(UserType::class, $user)
  798.             ->add('enabled', CheckboxType::class, [
  799.                 'label' => "Compte actif",
  800.                 'required' => false,
  801.                 'mapped' => false
  802.             ])
  803.         ;
  805.         $form->add('parentUser', EntityType::class, [
  806.             'attr' => array(
  807.                 'placeholder' => 'Compte client principal',
  808.             ),
  809.             'label' => 'Compte client principal',
  810.             'placeholder' => 'Compte client principal',
  811.             'expanded' => false,
  812.             'multiple' => false,
  813.             'required' => false,
  814.             'class' => User::class,
  815.             'query_builder' => function (EntityRepository $er) use ( $user, $manager, $isAdmin ) {
  816.                 $qb = $er->createQueryBuilder('u');
  818.                 $qb->where('u.id != :userId')
  819.                     ->setParameter("userId", $user->getId());
  821.                 if (!$isAdmin) {
  822.                     $qb->andWhere("u.manager = :manager")
  823.                         ->setParameter("manager", $manager);
  824.                 }
  826.                 return $qb->orderBy('u.companyName', 'ASC');
  827.             },
  828.             'choice_label' => function(User $queryUser) {
  829.                 return $queryUser->getCompanyName();
  830.             },
  831.         ])
  832.             ->add('childrenUsers', EntityType::class, [
  833.                 'attr' => array(
  834.                     'placeholder' => 'Comptes clients rattachés',
  835.                 ),
  836.                 'label' => 'Comptes clients rattachés',
  837.                 'placeholder' => 'Comptes clients rattachés',
  838.                 'expanded' => false,
  839.                 'multiple' => true,
  840.                 'required' => false,
  841.                 'class' => User::class,
  842.                 'query_builder' => function (EntityRepository $er) use ( $user, $manager, $isAdmin ) {
  843.                     $qb = $er->createQueryBuilder('u');
  845.                     $qb->where('u.id != :userId')
  846.                         ->setParameter("userId", $user->getId());
  848.                     if (!$isAdmin) {
  849.                         $qb->andWhere("u.manager = :manager")
  850.                             ->setParameter("manager", $manager);
  851.                     }
  853.                     return $qb->orderBy('u.companyName', 'ASC');
  854.                 },
  855.                 'choice_label' => function(User $queryUser) {
  856.                     return $queryUser->getCompanyName();
  857.                 },
  858.             ])
  859.             ;
  861.         if ($this->isGranted("ROLE_DPO")) {
  862.             $form->add('manager', EntityType::class, [
  863.                 'attr' => array(
  864.                     'placeholder' => 'Délégué à la Protection des Données',
  865.                 ),
  866.                 'label' => 'Délégué à la Protection des Données',
  867.                 'expanded' => false,
  868.                 'multiple' => false,
  869.                 'required' => true,
  870.                 'class' => Manager::class,
  871.                 'choice_label' => function(Manager $manager) {
  872.                     return $manager->getFirstName().' '.$manager->getLastName().' ('.$manager->getCompanyName().')';
  873.                 },
  874.             ])
  875.                 ->add('managerDpo', CheckboxType::class, [
  876.                 'label' => "Délégué à la Protection des Données",
  877.                 'required' => false
  878.             ])
  879.                 ->add('lawyer', EntityType::class, [
  880.                     'attr' => array(
  881.                         'placeholder' => 'Juriste',
  882.                     ),
  883.                     'label' => 'Juriste',
  884.                     'expanded' => false,
  885.                     'multiple' => false,
  886.                     'required' => false,
  887.                     'class' => Manager::class,
  888.                     'choice_label' => function(Manager $manager) {
  889.                         return $manager->getFirstName().' '.$manager->getLastName().' ('.$manager->getCompanyName().')';
  890.                     },
  891.                 ]);
  892.         } else {
  893.             $form->add('managerDpo', CheckboxType::class, [
  894.                 'label' => "Vous êtes DPO pour ce client",
  895.                 'required' => false
  896.             ]);
  897.         }
  899.         $form['email']->setData($user->getEmail());
  900.         $form['enabled']->setData($user->getAccount()->isEnabled());
  902.         $form->handleRequest($request);
  904.         if ($form->isSubmitted() && $form->isValid()) {
  905.             $em = $this->getDoctrine()->getManager();
  907.             $user->getAccount()->setEnabled($form['enabled']->getData());
  909.             /**
  910.              * @var UploadedFile $file
  911.              */
  912.             $file = $form->get('pictureFile')->getData();
  913.             if ($file != NULL) {
  914.                 $fileName = $user->getId()."_".md5(uniqid()) . '.' . $file->guessExtension();
  916.                 $file->move(
  917.                     $this->getParameter('pictures_directory'), $fileName
  918.                 );
  920.                 $user->setPicture($fileName);
  921.             }
  923.             $this->get('session')->getFlashBag()->add('success', 'Compte mis à jour');
  925.             $em->flush();
  927.             if (!$hasParentUser && $user->getParentUser()) {
  928.                 $parentTreatments = $em->getRepository(Treatment::class)->findBy(["user" => $user->getParentUser(), "group" => true]);
  929.                 foreach ($parentTreatments as $parentTreatment) {
  930.                     $user->getGroupTreatments()->add($parentTreatment);
  931.                 }
  932.                 $em->flush();
  933.             } elseif ($hasParentUser && !$user->getParentUser()) {
  934.                 $user->getGroupTreatments()->clear();
  935.                 $em->flush();
  936.             }
  938.             $parentTreatments = $em->getRepository(Treatment::class)->findBy(["user" => $user, "group" => true]);
  940.             if ($form['childrenUsers']->getData()) {
  941.                 foreach ($form['childrenUsers']->getData() as $childUser) {
  942.                     $keyExistingChildUser = array_search($childUser->getId(), $childUsersIds);
  943.                     if ($keyExistingChildUser !== FALSE) {
  944.                         unset($childUsersIds[$keyExistingChildUser]);
  945.                     } else {
  946.                         $tmpChildUser = $em->getRepository(User::class)->find($childUser->getId());
  947.                         if ($tmpChildUser) {
  948.                             $tmpChildUser->setParentUser($user);
  949.                             $em->flush();
  951.                             foreach ($parentTreatments as $parentTreatment) {
  952.                                 if (!$tmpChildUser->getGroupTreatments()->contains($parentTreatment)) {
  953.                                     $tmpChildUser->getGroupTreatments()->add($parentTreatment);
  954.                                 }
  955.                             }
  956.                             $em->flush();
  957.                         }
  958.                     }
  959.                 }
  960.             }
  961.             foreach ($childUsersIds as $childUserId) {
  962.                 $tmpChildUser = $em->getRepository(User::class)->find($childUserId);
  963.                 if ($tmpChildUser) {
  964.                     $tmpChildUser->setParentUser(null);
  965.                     $em->flush();
  967.                     foreach ($parentTreatments as $parentTreatment) {
  968.                         if ($tmpChildUser->getGroupTreatments()->contains($parentTreatment)) {
  969.                             $tmpChildUser->getGroupTreatments()->removeElement($parentTreatment);
  970.                         }
  971.                     }
  972.                     $em->flush();
  973.                 }
  974.             }
  976.             if ($r_email != $form['email']->getData()) {
  977.                 if (filter_var($form['email']->getData(), FILTER_VALIDATE_EMAIL)) {
  978.                     $other_account = $em->getRepository(Account::class)->findOneBy(['email' => $form['email']->getData()]);
  979.                     if ($other_account && $other_account->getId() != $user->getAccount()->getId()) {
  980.                         $this->get('session')->getFlashBag()->add('danger', 'Cette adresse mail est déjà utilisée par un autre utilisateur');
  981.                     } else {
  982.                         $user->getAccount()->setEmail($form['email']->getData());
  983.                         $user->setEmail($form['email']->getData());
  985.                         $em->flush();
  987.                         $this->get('session')->getFlashBag()->add('success', 'Identifiant de connexion modifié');
  988.                     }
  989.                 } else {
  990.                     $this->get('session')->getFlashBag()->add('danger', 'Cette adresse mail n\'est pas valide');
  991.                 }
  992.             }
  994.             return $this->redirectToRoute("manager_users");
  995.         }
  997.         return $this->render('manager/users_edit.html.twig', [
  998.             "form" => $form->createView(),
  999.             "user" => $user
  1000.         ]);
  1001.     }
  1003.     /**
  1004.      * @Route("/users/{id}/delete", name="users_delete")
  1005.      */
  1006.     public function usersDeleteAction(Request $request, User $user)
  1007.     {
  1008.         if (!$this->isGranted("ROLE_DPO")) {
  1009.             //if ($user->getManager()->getId() != $this->getUser()->getManager()->getId()) {
  1010.                 throw new NotFoundHttpException();
  1011.             //}
  1012.         }
  1014.         $em = $this->getDoctrine()->getManager();
  1016.         $em->remove($user);
  1017.         $em->flush();
  1019.         $this->get('session')->getFlashBag()->add('success', 'Compte client supprimé');
  1020.         return $this->redirectToRoute("manager_users");
  1021.     }
  1023.     /**
  1024.      * @Route("/users/{id}/print", name="users_print")
  1025.      */
  1026.     public function usersPrintAction(Request $request, User $user)
  1027.     {
  1028.         $tcpdf = new TCPDFController('TCPDF');
  1029.         $pdf = $tcpdf->create('vertical', PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
  1030.         $pdf->SetPrintHeader(false);
  1031.         $pdf->SetAuthor('myDigitplace');
  1032.         $pdf->SetTitle("Fiche société");
  1033.         $pdf->AddPage('P', 'A4');
  1035.         $html = $this->renderView('manager/pdf/user.html.twig', [
  1036.             "user" => $user
  1037.         ]);
  1039.         $filename = 'fiche_societe';
  1041.         $pdf->writeHTMLCell($w = 0, $h = 0, $x = '', $y = '', $html, $border = 0, $ln = 1, $fill = 0, $reseth = true, $align = '', $autopadding = true);
  1042.         return $pdf->Output($filename.".pdf",'I');
  1043.     }
  1045.     /**
  1046.      * @Route("/documents", name="documents")
  1047.      */
  1048.     public function documentsAction(Request $request)
  1049.     {
  1050.         $documentsTypes = $this->getDoctrine()->getRepository(DocumentType::class)->findBy(["parent" => null]);
  1052.         $typesChoices = [];
  1054.         $types = $this->getDoctrine()->getRepository(DocumentType::class)->findBy(["parent" => null]);
  1055.         foreach ($types as $type) {
  1056.             $typesChoices[] = (object) ['value' => $type->getId(), 'label' => $type->getLibelle()];
  1057.             foreach ($type->getChildren() as $child) {
  1058.                 $typesChoices[] = (object) ['value' => $child->getId(), 'label' => "|----".$child->getLibelle()];
  1059.             }
  1060.         }
  1062.         $form = $this->createFormBuilder()
  1063.             ->add('file', FileType::class, [
  1064.                 'attr' => [
  1065.                     'placeholder' => 'Fichier'
  1066.                 ],
  1067.                 'label' => 'Fichier',
  1068.                 'required' => true,
  1069.                 'mapped' => false
  1070.             ])
  1071.             ->add('name', TextType::class, [
  1072.                 'attr' => [
  1073.                     'placeholder' => 'Nom'
  1074.                 ],
  1075.                 'label' => 'Nom',
  1076.                 'required' => false,
  1077.                 'mapped' => false
  1078.             ])
  1079.             ->add('type', ChoiceType::class, [
  1080.                 'attr' => array(
  1081.                     'placeholder' => 'Type',
  1082.                 ),
  1083.                 'label' => 'Type',
  1084.                 'expanded' => false,
  1085.                 'multiple' => false,
  1086.                 'required' => true,
  1087.                 'mapped' => false,
  1088.                 'choices' => $typesChoices,
  1089.                 'choice_label' => function($entry) { return $entry!=null ? $entry->label : ""; },
  1090.                 'choice_value' => function($entry) { return $entry!=null ? $entry->value : 0; },
  1091.             ])->getForm();
  1093.         $form->handleRequest($request);
  1095.         if ($form->isSubmitted() && $form->isValid()) {
  1096.             $em = $this->getDoctrine()->getManager();
  1098.             /**
  1099.              * @var UploadedFile $file
  1100.              */
  1101.             $file = $form->get('file')->getData();
  1102.             if ($file != NULL) {
  1103.                 $fileName = $this->getUser()->getManager()->getId()."_".md5(uniqid()) . '.' . $file->guessExtension();
  1105.                 $file->move(
  1106.                     $this->getParameter('documents_directory'), $fileName
  1107.                 );
  1109.                 $docTitle = $form['name']->getData()??$file->getClientOriginalName();
  1110.                 $document = new Document();
  1111.                 $document->setName($docTitle);
  1112.                 $document->setFilename($fileName);
  1113.                 $document->setManager($this->getUser()->getManager());
  1115.                 if ($form['type']->getData()) {
  1116.                     $type = $em->getRepository(DocumentType::class)->find($form['type']->getData()->value);
  1117.                     if ($type) {
  1118.                         $document->setType($type);
  1119.                     }
  1120.                 }
  1122.                 $em->persist($document);
  1123.                 $em->flush();
  1125.                 $this->get('session')->getFlashBag()->add('success', 'Nouveau document téléversé');
  1126.             }
  1129.             return $this->redirectToRoute("manager_documents");
  1130.         }
  1132.         return $this->render('manager/documents.html.twig', [
  1133.             "documentsTypes" => $documentsTypes,
  1134.             "form" => $form->createView(),
  1135.         ]);
  1136.     }
  1138.     /**
  1139.      * @Route("/documentstypes", name="documents_types")
  1140.      */
  1141.     public function documentsTypesAction(Request $request)
  1142.     {
  1143.         $documentsTypes = $this->getDoctrine()->getRepository(DocumentType::class)->findAll();
  1145.         return $this->render('manager/documents_types.html.twig', [
  1146.             "documentsTypes" => $documentsTypes,
  1147.         ]);
  1148.     }
  1150.     /**
  1151.      * @Route("/documentstypes/add", name="documents_types_add")
  1152.      */
  1153.     public function documentsTypesAddAction(Request $request)
  1154.     {
  1155.         $documentType = new DocumentType();
  1157.         $form = $this->createFormBuilder($documentType)
  1158.             ->add("parent", EntityType::class, [
  1159.                 'attr' => array(
  1160.                     'placeholder' => 'Catégorie principale',
  1161.                 ),
  1162.                 'label' => 'Catégorie principale',
  1163.                 'expanded' => false,
  1164.                 'multiple' => false,
  1165.                 'required' => true,
  1166.                 'class' => DocumentType::class,
  1167.                 'query_builder' => function (EntityRepository $er) {
  1168.                     $qb = $er->createQueryBuilder('dt');
  1169.                     return $qb->where($qb->expr()->isNull("dt.parent"))
  1170.                         ->orderBy('dt.libelle', 'ASC');
  1171.                 },
  1172.                 'choice_label' => function(DocumentType $documentType) {
  1173.                     return $documentType->getLibelle();
  1174.                 },
  1175.             ])
  1176.             ->add("libelle", TextType::class, [
  1177.                 "attr" => [
  1178.                     "placeholder" => "Nom"
  1179.                 ],
  1180.                 "label" => "Nom",
  1181.             ])
  1182.             ->add("libelle_en", TextType::class, [
  1183.                 "attr" => [
  1184.                     "placeholder" => "Nom EN (traduction)"
  1185.                 ],
  1186.                 "label" => "Nom EN (traduction)",
  1187.                 "mapped" => false,
  1188.             ])
  1189.             ->getForm();
  1191.         $form->handleRequest($request);
  1193.         if ($form->isSubmitted() && $form->isValid()) {
  1194.             $em = $this->getDoctrine()->getManager();
  1196.             $em->persist($documentType);
  1197.             $em->flush();
  1199.             $repository = $em->getRepository('Gedmo\Translatable\Entity\Translation');
  1201.             $repository
  1202.                 ->translate($documentType, 'libelle', 'en', $form["libelle_en"]->getData())
  1203.             ;
  1205.             $em->flush();
  1207.             return $this->redirectToRoute("manager_documents_types");
  1208.         }
  1210.         return $this->render('manager/documents_types_add.html.twig', [
  1211.             "form" => $form->createView(),
  1212.         ]);
  1213.     }
  1215.     /**
  1216.      * @Route("/documentstypes/{id}/edit", name="documents_types_edit")
  1217.      */
  1218.     public function documentsTypesEditAction(Request $request, DocumentType $documentType)
  1219.     {
  1220.         $em = $this->getDoctrine()->getManager();
  1222.         $repository = $em->getRepository('Gedmo\Translatable\Entity\Translation');
  1224.         $translations = $repository->findTranslations($documentType);
  1226.         $form = $this->createFormBuilder($documentType)
  1227.             ->add("parent", EntityType::class, [
  1228.                 'attr' => array(
  1229.                     'placeholder' => 'Catégorie principale',
  1230.                 ),
  1231.                 'label' => 'Catégorie principale',
  1232.                 'expanded' => false,
  1233.                 'multiple' => false,
  1234.                 'required' => true,
  1235.                 'class' => DocumentType::class,
  1236.                 'query_builder' => function (EntityRepository $er) {
  1237.                     $qb = $er->createQueryBuilder('dt');
  1238.                     return $qb->where($qb->expr()->isNull("dt.parent"))
  1239.                         ->orderBy('dt.libelle', 'ASC');
  1240.                 },
  1241.                 'choice_label' => function(DocumentType $documentType) {
  1242.                     return $documentType->getLibelle();
  1243.                 },
  1244.             ])
  1245.             ->add("libelle", TextType::class, [
  1246.                 "attr" => [
  1247.                     "placeholder" => "Nom"
  1248.                 ],
  1249.                 "label" => "Nom",
  1250.             ])
  1251.             ->add("libelle_en", TextType::class, [
  1252.                 "attr" => [
  1253.                     "placeholder" => "Nom EN (traduction)"
  1254.                 ],
  1255.                 "label" => "Nom EN (traduction)",
  1256.                 "mapped" => false,
  1257.                 "data" => $translations["en"]["libelle"],
  1258.             ])
  1259.             ->getForm();
  1261.         $form->handleRequest($request);
  1263.         if ($form->isSubmitted() && $form->isValid()) {
  1264.             $em->persist($documentType);
  1265.             $em->flush();
  1267.             $repository
  1268.                 ->translate($documentType, 'libelle', 'en', $form["libelle_en"]->getData())
  1269.             ;
  1271.             $em->flush();
  1273.             return $this->redirectToRoute("manager_documents_types");
  1274.         }
  1276.         return $this->render('manager/documents_types_edit.html.twig', [
  1277.             "form" => $form->createView(),
  1278.         ]);
  1279.     }
  1281.     /**
  1282.      * @Route("/documentstypes/{id}/delete", name="documents_types_delete")
  1283.      */
  1284.     public function documentsTypesDeleteAction(Request $request, DocumentType $documentType)
  1285.     {
  1286.         $em = $this->getDoctrine()->getManager();
  1288.         $parentId = $documentType->getParent()->getId();
  1290.         $parentType = $em->getRepository(DocumentType::class)->find($parentId);
  1292.         $documents = $em->getRepository(Document::class)->findBy(["type" => $documentType]);
  1294.         foreach ($documents as $document) {
  1295.             $document->setType($parentType);
  1297.             $em->flush();
  1298.         }
  1300.         $em->remove($documentType);
  1301.         $em->flush();
  1303.         return $this->redirectToRoute("manager_documents_types");
  1304.     }
  1306.     /**
  1307.      * @Route("/documents/{id}/edit", name="documents_edit")
  1308.      */
  1309.     public function documentsEditAction(Request $request, Document $document)
  1310.     {
  1311.         $em = $this->getDoctrine()->getManager();
  1313.         $repository = $em->getRepository('Gedmo\Translatable\Entity\Translation');
  1315.         $translations = $repository->findTranslations($document);
  1317.         $name = $document->getName();
  1318.         $filename = $document->getFilename();
  1320.         $name_en = "";
  1321.         $filename_en = "";
  1323.         if (isset($translations["en"])) {
  1324.             $name_en = $translations["en"]["name"];
  1325.             $filename_en = $translations["en"]["filename"];
  1326.         }
  1328.         $typesChoices = [];
  1330.         $types = $this->getDoctrine()->getRepository(DocumentType::class)->findBy(["parent" => null]);
  1331.         foreach ($types as $type) {
  1332.             $typesChoices[] = (object) ['value' => $type->getId(), 'label' => $type->getLibelle()];
  1333.             foreach ($type->getChildren() as $child) {
  1334.                 $typesChoices[] = (object) ['value' => $child->getId(), 'label' => "|----".$child->getLibelle()];
  1335.             }
  1336.         }
  1338.         $form = $this->createFormBuilder()
  1339.             ->add('name', TextType::class, [
  1340.                 'attr' => [
  1341.                     'placeholder' => 'Nom'
  1342.                 ],
  1343.                 'label' => 'Nom',
  1344.                 'required' => false,
  1345.                 'mapped' => false,
  1346.                 "data" => $name,
  1347.             ])
  1348.             ->add('file', FileType::class, [
  1349.                 'attr' => [
  1350.                     'placeholder' => 'Fichier'
  1351.                 ],
  1352.                 'label' => 'Remplacer le fichier',
  1353.                 'required' => false,
  1354.                 'mapped' => false
  1355.             ])
  1356.             ->add('type', ChoiceType::class, [
  1357.                 'attr' => array(
  1358.                     'placeholder' => 'Type',
  1359.                 ),
  1360.                 'label' => 'Type',
  1361.                 'expanded' => false,
  1362.                 'multiple' => false,
  1363.                 'required' => true,
  1364.                 'mapped' => false,
  1365.                 'choices' => $typesChoices,
  1366.                 'choice_label' => function($entry) { return $entry!=null ? $entry->label : ""; },
  1367.                 'choice_value' => function($entry) { return $entry!=null ? $entry->value : 0; },
  1368.                 "data" => (object) ['value' => $document->getType()->getId()],
  1369.             ]);
  1371.         if ($document->isTranslatedEn()) {
  1372.             $form->add('name_en', TextType::class, [
  1373.                 'attr' => [
  1374.                     'placeholder' => ' EN (traduction)'
  1375.                 ],
  1376.                 'label' => ' EN (traduction)',
  1377.                 'required' => false,
  1378.                 'mapped' => false,
  1379.                 "data" => $name_en,
  1380.             ])
  1381.                 ->add('file_en', FileType::class, [
  1382.                     'attr' => [
  1383.                         'placeholder' => 'Fichier'
  1384.                     ],
  1385.                     'label' => 'Remplacer le fichier EN (traduction)',
  1386.                     'required' => false,
  1387.                     'mapped' => false
  1388.                 ]);
  1389.         }
  1391.         $form = $form->getForm();
  1393.         $form->handleRequest($request);
  1395.         if ($form->isSubmitted() && $form->isValid()) {
  1396.             if ($form['type']->getData()) {
  1397.                 $type = $em->getRepository(DocumentType::class)->find($form['type']->getData()->value);
  1398.                 if ($type) {
  1399.                     $document->setType($type);
  1400.                 }
  1401.             }
  1403.             $docTitle = $form['name']->getData()??$filename;
  1404.             $document->setName($docTitle);
  1406.             $em->flush();
  1408.             /**
  1409.              * @var UploadedFile $file
  1410.              */
  1411.             $file = $form->get('file')->getData();
  1412.             if ($file != NULL) {
  1413.                 $fileName = $this->getUser()->getManager()->getId()."_".md5(uniqid()) . '.' . $file->guessExtension();
  1415.                 $file->move(
  1416.                     $this->getParameter('documents_directory'), $fileName
  1417.                 );
  1419.                 $docTitle = $form["name"]->getData()??$file->getClientOriginalName();
  1420.                 $document->setName($docTitle);
  1421.                 $document->setFilename($fileName);
  1422.                 $document->setManager($this->getUser()->getManager());
  1424.                 $em->flush();
  1425.             }
  1427.             if ($document->isTranslatedEn()) {
  1428.                 $repository
  1429.                     ->translate($document, 'name', 'en', $form["name_en"]->getData())
  1430.                 ;
  1432.                 $em->flush();
  1434.                 /**
  1435.                  * @var UploadedFile $file_en
  1436.                  */
  1437.                 $file_en = $form->get('file_en')->getData();
  1438.                 if ($file_en != NULL) {
  1439.                     $fileName = $this->getUser()->getManager()->getId()."_".md5(uniqid()) . '.' . $file_en->guessExtension();
  1441.                     $file_en->move(
  1442.                         $this->getParameter('documents_directory'), $fileName
  1443.                     );
  1445.                     $docTitle = $form["name_en"]->getData()??$file_en->getClientOriginalName();
  1446.                     $document->setName($docTitle);
  1447.                     $document->setFilename($fileName);
  1449.                     $repository
  1450.                         ->translate($document, 'name', 'en', $docTitle)
  1451.                         ->translate($document, 'filename', 'en', $fileName)
  1452.                     ;
  1454.                     $document->setManager($this->getUser()->getManager());
  1456.                     $em->flush();
  1457.                 }
  1458.             }
  1460.             return $this->redirectToRoute("manager_documents");
  1461.         }
  1463.         return $this->render('manager/documents_edit.html.twig', [
  1464.             "document" => $document,
  1465.             "form" => $form->createView(),
  1466.             "filename" => $filename,
  1467.             "filename_en" => $filename_en,
  1468.         ]);
  1469.     }
  1471.     /**
  1472.      * @Route("/documents/{id}/translate", name="documents_translate")
  1473.      */
  1474.     public function documentsTranslateAction(Request $request, Document $document)
  1475.     {
  1476.         $form = $this->createFormBuilder()
  1477.             ->add('documentFile', FileType::class, [
  1478.                 'attr' => [
  1479.                     'placeholder' => 'Document EN (traduction)'
  1480.                 ],
  1481.                 'label' => 'Document EN (traduction)',
  1482.                 'required' => true,
  1483.                 'mapped' => false
  1484.             ])
  1485.             ->add("libelle_en", TextType::class, [
  1486.                 "attr" => [
  1487.                     "placeholder" => "Nom EN (traduction)"
  1488.                 ],
  1489.                 "label" => "Nom EN (traduction)",
  1490.                 "mapped" => false,
  1491.             ])
  1492.             ->getForm();
  1494.         $form->handleRequest($request);
  1496.         $em = $this->getDoctrine()->getManager();
  1498.         if ($form->isSubmitted() && $form->isValid()) {
  1499.             /**
  1500.              * @var UploadedFile $file
  1501.              */
  1502.             $file = $form->get('documentFile')->getData();
  1503.             if ($file != NULL) {
  1504.                 $fileName = $this->getUser()->getManager()->getId()."_".md5(uniqid()) . '.' . $file->guessExtension();
  1506.                 $file->move(
  1507.                     $this->getParameter('documents_directory'), $fileName
  1508.                 );
  1510.                 $docTitle = $form['libelle_en']->getData()??$file->getClientOriginalName();
  1512.                 $repository = $em->getRepository('Gedmo\Translatable\Entity\Translation');
  1514.                 $repository
  1515.                     ->translate($document, 'name', 'en', $docTitle)
  1516.                     ->translate($document, 'filename', 'en', $fileName)
  1517.                 ;
  1519.                 $document->setTranslatedEn(true);
  1521.                 $em->flush();
  1523.                 $this->get('session')->getFlashBag()->add('success', 'Nouveau document traduit');
  1524.             }
  1526.             return $this->redirectToRoute("manager_documents");
  1527.         }
  1529.         return $this->render('manager/documents_translate.html.twig', [
  1530.             "form" => $form->createView(),
  1531.         ]);
  1532.     }
  1534.     /**
  1535.      * @Route("/documents/{id}/delete", name="documents_delete")
  1536.      */
  1537.     public function documentsDeleteAction(Request $request, Document $document)
  1538.     {
  1539.         $filePath = $this->getParameter('documents_directory') . $document->getFilename();
  1541.         $em = $this->getDoctrine()->getManager();
  1542.         $em->remove($document);
  1543.         $em->flush();
  1545.         unlink($filePath);
  1547.         $this->get('session')->getFlashBag()->add('success', 'Document supprimé');
  1549.         return $this->redirectToRoute("manager_documents");
  1550.     }
  1552.     /**
  1553.      * @Route("/switch/{id}", name="user_switch")
  1554.      */
  1555.     public function userSwitchAction(Request $request, User $user)
  1556.     {
  1557.         if (!$this->isGranted("ROLE_DPO")) {
  1558.             if ($this->isGranted("ROLE_JURISTE") || $this->isGranted("ROLE_COMMERCE")) {
  1559.                 if ($this->isGranted("ROLE_JURISTE")) {
  1560.                     if ($user->getManager()->getId() != $this->getUser()->getManager()->getId()
  1561.                         && ($user->getLawyer() && $user->getLawyer()->getId() != $this->getUser()->getManager()->getId())) {
  1562.                         throw new NotFoundHttpException();
  1563.                     }
  1564.                 } else {
  1565.                     if (!$user->isDemo()) {
  1566.                         throw new NotFoundHttpException();
  1567.                     }
  1568.                 }
  1569.             } else {
  1570.                 throw new NotFoundHttpException();
  1571.             }
  1572.         }
  1574.         return $this->redirectToRoute("default_homepage", ['_switch_user' =>  $user->getAccount()->getEmail()]);
  1575.     }
  1577.     /**
  1578.      * @Route("/partners", name="partners")
  1579.      */
  1580.     public function partnersAction(Request $request)
  1581.     {
  1582.         if (!$this->isGranted("ROLE_DPO")) {
  1583.             throw new NotFoundHttpException();
  1584.         }
  1586.         $partners = $this->getDoctrine()->getRepository(Partner::class)->findAll();
  1588.         return $this->render('manager/partners.html.twig', [
  1589.             "partners" => $partners
  1590.         ]);
  1591.     }
  1593.     /**
  1594.      * @Route("/partners/add", name="partners_add")
  1595.      */
  1596.     public function partnersAddAction(Request $request)
  1597.     {
  1598.         if (!$this->isGranted("ROLE_DPO")) {
  1599.             throw new NotFoundHttpException();
  1600.         }
  1602.         $partner = new Partner();
  1604.         $form = $this->createForm(PartnerType::class, $partner);
  1606.         $form->handleRequest($request);
  1608.         if ($form->isSubmitted() && $form->isValid()) {
  1609.             $em = $this->getDoctrine()->getManager();
  1611.             $em->persist($partner);
  1613.             $em->flush();
  1615.             /**
  1616.              * @var UploadedFile $file
  1617.              */
  1618.             $file = $form->get('pictureFile')->getData();
  1619.             if ($file != NULL) {
  1620.                 $fileName = $partner->getId()."_".md5(uniqid()) . '.' . $file->guessExtension();
  1622.                 $file->move(
  1623.                     $this->getParameter('pictures_directory'), $fileName
  1624.                 );
  1626.                 $partner->setPicture($fileName);
  1628.                 $em->flush();
  1629.             }
  1631.             $this->get('session')->getFlashBag()->add('success', 'Nouveau partenaire ajouté');
  1632.             return $this->redirectToRoute("manager_partners");
  1633.         }
  1635.         return $this->render('manager/partners_add.html.twig', [
  1636.             "form" => $form->createView(),
  1637.         ]);
  1638.     }
  1640.     /**
  1641.      * @Route("/partners/{id}/edit", name="partners_edit")
  1642.      */
  1643.     public function partnersEditAction(Request $request, Partner $partner)
  1644.     {
  1645.         if (!$this->isGranted("ROLE_DPO")) {
  1646.             throw new NotFoundHttpException();
  1647.         }
  1649.         $form = $this->createForm(PartnerType::class, $partner);
  1651.         $form->handleRequest($request);
  1653.         if ($form->isSubmitted() && $form->isValid()) {
  1654.             $em = $this->getDoctrine()->getManager();
  1656.             $em->flush();
  1658.             /**
  1659.              * @var UploadedFile $file
  1660.              */
  1661.             $file = $form->get('pictureFile')->getData();
  1662.             if ($file != NULL) {
  1663.                 $fileName = $partner->getId()."_".md5(uniqid()) . '.' . $file->guessExtension();
  1665.                 $file->move(
  1666.                     $this->getParameter('pictures_directory'), $fileName
  1667.                 );
  1669.                 $partner->setPicture($fileName);
  1671.                 $em->flush();
  1672.             }
  1674.             $this->get('session')->getFlashBag()->add('success', 'Partenaire mis à jour');
  1676.             return $this->redirectToRoute("manager_partners");
  1677.         }
  1679.         return $this->render('manager/partners_edit.html.twig', [
  1680.             "form" => $form->createView(),
  1681.             "partner" => $partner
  1682.         ]);
  1683.     }
  1685.     /**
  1686.      * @Route("/partners/{id}/delete", name="partners_delete")
  1687.      */
  1688.     public function partnersDeleteAction(Request $request, Partner $partner)
  1689.     {
  1690.         if (!$this->isGranted("ROLE_DPO")) {
  1691.             throw new NotFoundHttpException();
  1692.         }
  1694.         $em = $this->getDoctrine()->getManager();
  1696.         $em->remove($partner);
  1697.         $em->flush();
  1699.         $this->get('session')->getFlashBag()->add('success', 'Partenaire supprimé');
  1700.         return $this->redirectToRoute("manager_partners");
  1701.     }
  1703.     /**
  1704.      * @Route("/systems", name="systems")
  1705.      */
  1706.     public function systemsAction(Request $request)
  1707.     {
  1708.         $systemsQuery = $this->getDoctrine()->getRepository(SystemStd::class)->findAll();
  1710.         $systems = [
  1711.             "computing" => [
  1712.                 "network" => [],
  1713.                 "security" => [],
  1714.                 "administration" => [],
  1715.                 "device" => [],
  1716.                 "software" => [],
  1717.                 "server" => [],
  1718.             ],
  1719.             "physical" => [
  1720.                 "partitioning" => [],
  1721.                 "information" => [],
  1722.             ],
  1723.             "action" => [
  1724.                 "minimization" => [],
  1725.                 "anonymization" => [],
  1726.                 "pseudonymization" => [],
  1727.                 "sensitization" => [],
  1728.                 "supervision" => [],
  1729.                 "destruction" => [],
  1730.             ],
  1731.             "supplier" => [
  1732.                 "supplier" => []
  1733.             ]
  1734.         ];
  1736.         $systemsJs = [];
  1738.         $encoders = [new JsonEncoder()];
  1739.         $normalizer = new ObjectNormalizer();
  1740.         // $normalizer->setCircularReferenceLimit(1);
  1741.         // $normalizer->setCircularReferenceHandler(function ($object) {
  1742.         //     return $object->getId();
  1743.         // });
  1744.         $normalizers = [$normalizer];
  1745.         $serializer = new Serializer($normalizers, $encoders);
  1746.         
  1747.         foreach ($systemsQuery as $system) {
  1748.             $systems[$system->getType()][$system->getSubtype()][] = $system;
  1749.             $systemsJs[$system->getId()] = json_decode($serializer->serialize($system, 'json', ["attributes" => ['id', 'name', 'data', 'type', 'subtype'], "circular_reference_handler" => function ($object) {return $object->getId();}]), true);
  1750.         }
  1752.         $systemsStd = [
  1753.             "computing" => [
  1754.                 "network" => [
  1755.                     "label" => "Réseau",
  1756.                     "items" => [],
  1757.                     "icon" => "mdi-ip-network"
  1758.                 ],
  1759.                 "security" => [
  1760.                     "label" => "Sécurité",
  1761.                     "items" => [],
  1762.                     "icon" => "mdi-security"
  1763.                 ],
  1764.                 "administration" => [
  1765.                     "label" => "Administration",
  1766.                     "items" => [],
  1767.                     "icon" => "mdi-account-multiple"
  1768.                 ],
  1769.                 "device" => [
  1770.                     "label" => "Périphérique",
  1771.                     "items" => [],
  1772.                     "icon" => "mdi-responsive"
  1773.                 ],
  1774.                 "software" => [
  1775.                     "label" => "Logiciel",
  1776.                     "items" => [],
  1777.                     "icon" => "mdi-console"
  1778.                 ],
  1779.                 "server" => [
  1780.                     "label" => "Serveur",
  1781.                     "items" => [],
  1782.                     "icon" => "mdi-server"
  1783.                 ],
  1784.             ],
  1785.             "physical" => [
  1786.                 "partitioning" => [
  1787.                     "label" => "Cloisonnement",
  1788.                     "items" => [],
  1789.                     "icon" => "mdi-view-module"
  1790.                 ],
  1791.                 "information" => [
  1792.                     "label" => "Information",
  1793.                     "items" => [],
  1794.                     "icon" => "mdi-lightbulb-on"
  1795.                 ],
  1796.             ],
  1797.             "action" => [
  1798.                 "minimization" => [
  1799.                     "label" => "Minimisation",
  1800.                     "items" => [],
  1801.                     "icon" => "mdi-tab-minus"
  1802.                 ],
  1803.                 "anonymization" => [
  1804.                     "label" => "Anonymisation",
  1805.                     "items" => [],
  1806.                     "icon" => "mdi-incognito"
  1807.                 ],
  1808.                 "pseudonymization" => [
  1809.                     "label" => "Pseudonymisation",
  1810.                     "items" => [],
  1811.                     "icon" => "mdi-account-question"
  1812.                 ],
  1813.                 "sensitization" => [
  1814.                     "label" => "Sensibilisation et formation",
  1815.                     "items" => [],
  1816.                     "icon" => "mdi-account-alert"
  1817.                 ],
  1818.                 "supervision" => [
  1819.                     "label" => "Contrôle",
  1820.                     "items" => [],
  1821.                     "icon" => "mdi-table-search"
  1822.                 ],
  1823.                 "destruction" => [
  1824.                     "label" => "Destruction et suppression",
  1825.                     "items" => [],
  1826.                     "icon" => "mdi-trash-can"
  1827.                 ],
  1828.             ],
  1829.             "supplier" => [
  1830.                 "supplier" => [
  1831.                     "label" => "Prestataires du SI",
  1832.                     "items" => [],
  1833.                     "icon" => "mdi-contacts"
  1834.                 ],
  1835.             ]
  1836.         ];
  1838.         $mindMapHeight = 0;
  1840.         $mindMap = [
  1841.             "id" => "root",
  1842.             "topic" => "<div class='node-level-0'><div class='jmnode-icon'><i class='mdi mdi-sitemap mdi-36px'></i></div><i>Système d'information</i><span class='node-0-actions'><a href=\"".$this->generateUrl("manager_systems_export")."\" target='_blank' class=\"btn btn-sm btn-rounded-circle btn-primary\"><i class=\"mdi mdi-printer\"></i></a></span></div>",
  1843.             "children" => [
  1844.                 [
  1845.                     "id" => "computing",
  1846.                     "topic" => "<div class='node-level-1'><div class='jmnode-icon'><i class='mdi mdi-desktop-classic mdi-36px'></i></div><i>Informatique</i><span class='node-1-actions'><a href=\"".$this->generateUrl("manager_systems_export_excel", ["type" => "computing"])."\" target='_blank' class=\"btn btn-sm btn-rounded-circle btn-primary\"><i class=\"mdi mdi-download\"></i></a></span></div>",
  1847.                     "direction" => "right",
  1848.                     "expanded" => false,
  1849.                     "attr" => [
  1850.                         "class" => "jmnode-level-1",
  1851.                     ],
  1852.                     "children" => []
  1853.                 ],
  1854.                 [
  1855.                     "id" => "physical",
  1856.                     "topic" => "<div class='node-level-1'><div class='jmnode-icon'><i class='mdi mdi-office-building mdi-36px'></i></div><i>Physique</i><span class='node-1-actions'><a href=\"".$this->generateUrl("manager_systems_export_excel", ["type" => "physical"])."\" target='_blank' class=\"btn btn-sm btn-rounded-circle btn-primary\"><i class=\"mdi mdi-download\"></i></a></span></div>",
  1857.                     "direction" => "right",
  1858.                     "expanded" => false,
  1859.                     "attr" => [
  1860.                         "class" => "jmnode-level-1",
  1861.                     ],
  1862.                     "children" => []
  1863.                 ],
  1864.                 [
  1865.                     "id" => "action",
  1866.                     "topic" => "<div class='node-level-1'><div class='jmnode-icon'><i class='mdi mdi-account-arrow-right mdi-36px'></i></div><i>Action</i><span class='node-1-actions'><a href=\"".$this->generateUrl("manager_systems_export_excel", ["type" => "action"])."\" target='_blank' class=\"btn btn-sm btn-rounded-circle btn-primary\"><i class=\"mdi mdi-download\"></i></a></span></div>",
  1867.                     "direction" => "right",
  1868.                     "expanded" => false,
  1869.                     "attr" => [
  1870.                         "class" => "jmnode-level-1",
  1871.                     ],
  1872.                     "children" => []
  1873.                 ],
  1874.                 [
  1875.                     "id" => "supplier",
  1876.                     "topic" => "<div class='node-level-1'><div class='jmnode-icon'><i class='mdi mdi-contacts mdi-36px'></i></div><i>Prestataires du SI</i><span class='node-1-actions'><a href=\"".$this->generateUrl("manager_systems_export_excel", ["type" => "supplier"])."\" target='_blank' class=\"btn btn-sm btn-rounded-circle btn-primary\"><i class=\"mdi mdi-download\"></i></a></span></div>",
  1877.                     "direction" => "right",
  1878.                     "expanded" => false,
  1879.                     "attr" => [
  1880.                         "class" => "jmnode-level-1",
  1881.                     ],
  1882.                     "children" => []
  1883.                 ],
  1884.             ]
  1885.         ];
  1887.         $key1 = 0;
  1888.         foreach ($systemsStd as $systemStd) {
  1889.             foreach ($systemStd as $key2 => $value2) {
  1890.                 $data = [
  1891.                     "id" => $mindMap["children"][$key1]["id"]."_".$key2,
  1892.                     "topic" => "<div class='node-level-2'><div class='jmnode-icon'><i class='mdi ".$value2["icon"]." mdi-36px'></i></div><i>".$value2["label"]."</i><span class='node-2-actions'><a href=\"".$this->generateUrl("manager_systems_add")."?type=".$mindMap["children"][$key1]["id"]."&subtype=".$key2."\" class=\"btn btn-sm btn-rounded-circle btn-primary\"><i class=\"mdi mdi-plus\"></i></a></span></div>",
  1893.                     "direction" => "right",
  1894.                     "expanded" => false,
  1895.                     "attr" => [
  1896.                         "class" => "jmnode-level-2",
  1897.                     ],
  1898.                     "children" => []
  1899.                 ];
  1901.                 $itemsLenght = count($systems[$mindMap["children"][$key1]["id"]][$key2]);
  1902.                 if ($itemsLenght > 2) {
  1903.                     $mindMapHeight += $itemsLenght;
  1904.                 } else {
  1905.                     $mindMapHeight += 2;
  1906.                 }
  1908.                 foreach ($systems[$mindMap["children"][$key1]["id"]][$key2] as $item) {
  1909.                     $data["children"][] = [
  1910.                         "id" => $item->getId(),
  1911.                         "topic" => "<div class='node-level-3'><span class='node-topic' onclick='openModalInfo(".$item->getId().")'>".$item->getName()."</span><span class='node-3-actions'><a href=\"".$this->generateUrl("manager_systems_edit", ["id" => $item->getId()])."\" class=\"btn btn-light my-1 mr-1\"><i class=\"mdi mdi-circle-edit-outline\"></i></a><a href=\"".$this->generateUrl("manager_systems_delete", ["id" => $item->getId()])."\" class=\"btn btn-danger my-1\"  onclick=\"return confirm('Confirmer la suppression de cet élément ?');\"><i class=\"mdi mdi-close\"></i></a></span></div>",
  1912.                         "attr" => [
  1913.                             "class" => "jmnode-level-3",
  1914.                             "onclick" => "openModalInfo(".$item->getId().")",
  1915.                         ]
  1916.                     ];
  1917.                 }
  1919.                 $mindMap["children"][$key1]["children"][] = $data;
  1920.             }
  1921.             $key1++;
  1922.         }
  1924.         return $this->render('manager/systems.html.twig', [
  1925.             "systems" => $systems,
  1926.             "mindMap" => $mindMap,
  1927.             "mindMapHeight" => 12 * (38 * 1.5),
  1928.             "systemsJs" => $systemsJs,
  1929.         ]);
  1930.     }
  1932.     /**
  1933.      * @Route("/systems/{id}/translate/{_locale}", name="systems_translate")
  1934.      */
  1935.     public function systemsTranslateAction(Request $request, SystemStd $system)
  1936.     {
  1937.         $em = $this->getDoctrine()->getManager();
  1939.         $repository = $em->getRepository('Gedmo\Translatable\Entity\Translation');
  1940.         $translations = $repository->findTranslations($system);
  1942.         if (!isset($translations[$request->get("_locale")])) {
  1943.             return $this->redirectToRoute("manager_systems_gen_translate", ["id" => $system->getId(), "_locale" => "fr", "locale" => $request->get("_locale")]);
  1944.         }
  1946.         $system = $em->find(SystemStd::class, $request->get("id"));
  1948.         $types = [
  1949.             "computing" => [
  1950.                 "network" => 4,
  1951.                 "security" => 4,
  1952.                 "administration" => 4,
  1953.                 "device" => 4,
  1954.                 "software" => 4,
  1955.                 "server" => 4,
  1956.             ],
  1957.             "physical" => [
  1958.                 "partitioning" => 2,
  1959.                 "information" => 2,
  1960.             ],
  1961.             "action" => [
  1962.                 "minimization" => 2,
  1963.                 "anonymization" => 2,
  1964.                 "pseudonymization" => 2,
  1965.                 "sensitization" => 2,
  1966.                 "supervision" => 2,
  1967.                 "destruction" => 2,
  1968.             ],
  1969.             "supplier" => [
  1970.                 "supplier" => 1
  1971.             ]
  1972.         ];
  1974.         $form = $this->createForm(SystemStdTranslateType::class, $system);
  1976.         switch ($system->getSubtype()) {
  1977.             case "network":
  1978.                 $form->add('field1', ChoiceType::class, [
  1979.                     'attr' => [
  1980.                         'placeholder' => 'Type'
  1981.                     ],
  1982.                     'placeholder' => 'Type',
  1983.                     'label' => 'Type',
  1984.                     'choices' => [
  1985.                         "Filaire" => "Filaire",
  1986.                         "Sans-fil" => "Sans-fil",
  1987.                     ],
  1988.                     'data' => isset($system->getData()[0])?$system->getData()[0]["value"]:null,
  1989.                     'required' => false,
  1990.                     'mapped' => false
  1991.                 ])
  1992.                     ->add('field2', TextareaType::class, [
  1993.                         'attr' => [
  1994.                             'placeholder' => 'Informations complémentaires'
  1995.                         ],
  1996.                         'label' => 'Informations complémentaires',
  1997.                         'data' => isset($system->getData()[1])?$system->getData()[1]["value"]:null,
  1998.                         'required' => false,
  1999.                         'mapped' => false
  2000.                     ])
  2001.                     ->add('field3', ChoiceType::class, [
  2002.                         'attr' => [
  2003.                             'placeholder' => 'Type'
  2004.                         ],
  2005.                         'placeholder' => 'Type',
  2006.                         'label' => 'Si Wifi, sélectionnez le type',
  2007.                         'choices' => [
  2008.                             "Privé" => "Privé",
  2009.                             "Public" => "Public",
  2010.                         ],
  2011.                         'data' => isset($system->getData()[2])?$system->getData()[2]["value"]:null,
  2012.                         'required' => false,
  2013.                         'mapped' => false
  2014.                     ])
  2015.                     ->add('field4', TextType::class, [
  2016.                         'attr' => [
  2017.                             'placeholder' => 'Protocole'
  2018.                         ],
  2019.                         'label' => 'Si Wifi, quel protocole ?',
  2020.                         'data' => isset($system->getData()[3])?$system->getData()[3]["value"]:null,
  2021.                         'required' => false,
  2022.                         'mapped' => false
  2023.                     ])
  2024.                 ;
  2025.                 break;
  2026.             case "security":
  2027.             case "administration":
  2028.             case "device":
  2029.             case "software":
  2030.             case "server":
  2031.                 $form->add('field1', TextType::class, [
  2032.                     'attr' => [
  2033.                         'placeholder' => 'Type'
  2034.                     ],
  2035.                     'label' => 'Type',
  2036.                     'data' => isset($system->getData()[0])?$system->getData()[0]["value"]:null,
  2037.                     'required' => false,
  2038.                     'mapped' => false
  2039.                 ])
  2040.                     ->add('field2', TextareaType::class, [
  2041.                         'attr' => [
  2042.                             'placeholder' => 'Informations complémentaires'
  2043.                         ],
  2044.                         'label' => 'Informations complémentaires',
  2045.                         'data' => isset($system->getData()[1])?$system->getData()[1]["value"]:null,
  2046.                         'required' => false,
  2047.                         'mapped' => false
  2048.                     ])
  2049.                     ->add('field3', TextType::class, [
  2050.                         'attr' => [
  2051.                             'placeholder' => '__/__/____',
  2052.                             'data-mask' => '00/00/0000',
  2053.                             'data-mask-clearifnotmatch' => 'true'
  2054.                         ],
  2055.                         'label' => 'Date d\'achat',
  2056.                         'data' => isset($system->getData()[2])?$system->getData()[2]["value"]:null,
  2057.                         'required' => false,
  2058.                         'mapped' => false
  2059.                     ])
  2060.                     ->add('field4', TextType::class, [
  2061.                         'attr' => [
  2062.                             'placeholder' => 'N° d’identification'
  2063.                         ],
  2064.                         'label' => 'N° d’identification',
  2065.                         'data' => isset($system->getData()[3])?$system->getData()[3]["value"]:null,
  2066.                         'required' => false,
  2067.                         'mapped' => false
  2068.                     ]);
  2069.                 break;
  2070.             case "partitioning":
  2071.             case "minimization":
  2072.             case "anonymization":
  2073.             case "pseudonymization":
  2074.             case "sensitization":
  2075.             case "information":
  2076.             case "supervision":
  2077.             case "destruction":
  2078.                 $form->add('field1', TextareaType::class, [
  2079.                     'attr' => [
  2080.                         'placeholder' => 'Description'
  2081.                     ],
  2082.                     'label' => 'Description',
  2083.                     'data' => isset($system->getData()[0])?$system->getData()[0]["value"]:null,
  2084.                     'required' => false,
  2085.                     'mapped' => false
  2086.                 ])
  2087.                     ->add('field2', TextareaType::class, [
  2088.                         'attr' => [
  2089.                             'placeholder' => 'Informations complémentaires'
  2090.                         ],
  2091.                         'label' => 'Informations complémentaires',
  2092.                         'data' => isset($system->getData()[1])?$system->getData()[1]["value"]:null,
  2093.                         'required' => false,
  2094.                         'mapped' => false
  2095.                     ]);
  2096.                 break;
  2097.             case "supplier":
  2098.                 $form->add('field1', TextType::class, [
  2099.                     'attr' => [
  2100.                         'placeholder' => 'Type'
  2101.                     ],
  2102.                     'label' => 'Type',
  2103.                     'data' => isset($system->getData()[0])?$system->getData()[0]["value"]:null,
  2104.                     'required' => false,
  2105.                     'mapped' => false
  2106.                 ]);
  2107.                 break;
  2108.             default:
  2109.                 throw new NotFoundHttpException();
  2110.         }
  2112.         $form->handleRequest($request);
  2114.         if ($form->isSubmitted() && $form->isValid()) {
  2115.             $data = [];
  2117.             switch ($system->getSubtype()) {
  2118.                 case "network":
  2119.                     $data[] = [
  2120.                         "title" => 'Type',
  2121.                         "value" => $form['field1']->getData()
  2122.                     ];
  2123.                     $data[] = [
  2124.                         "title" => 'Informations complémentaires',
  2125.                         "value" => $form['field2']->getData()
  2126.                     ];
  2127.                     $data[] = [
  2128.                         "title" => 'Type de Wifi',
  2129.                         "value" => $form['field3']->getData()
  2130.                     ];
  2131.                     $data[] = [
  2132.                         "title" => 'Protocole Wifi',
  2133.                         "value" => $form['field4']->getData()
  2134.                     ];
  2135.                     ;
  2136.                     break;
  2137.                 case "security":
  2138.                 case "administration":
  2139.                 case "device":
  2140.                 case "software":
  2141.                 case "server":
  2142.                     $data[] = [
  2143.                         "title" => 'Type',
  2144.                         "value" => $form['field1']->getData()
  2145.                     ];
  2146.                     $data[] = [
  2147.                         "title" => 'Informations complémentaires',
  2148.                         "value" => $form['field2']->getData()
  2149.                     ];
  2150.                     $data[] = [
  2151.                         "title" => 'Date d\'achat',
  2152.                         "value" => $form['field3']->getData()
  2153.                     ];
  2154.                     $data[] = [
  2155.                         "title" => 'N° d’identification',
  2156.                         "value" => $form['field4']->getData()
  2157.                     ];
  2158.                     break;
  2159.                 case "partitioning":
  2160.                 case "minimization":
  2161.                 case "anonymization":
  2162.                 case "pseudonymization":
  2163.                 case "sensitization":
  2164.                 case "information":
  2165.                 case "supervision":
  2166.                 case "destruction":
  2167.                     $data[] = [
  2168.                         "title" => 'Description',
  2169.                         "value" => $form['field1']->getData()
  2170.                     ];
  2171.                     $data[] = [
  2172.                         "title" => 'Informations complémentaires',
  2173.                         "value" => $form['field2']->getData()
  2174.                     ];
  2175.                     break;
  2176.                 case "supplier":
  2177.                     $data[] = [
  2178.                         "title" => 'Type',
  2179.                         "value" => $form['field1']->getData()
  2180.                     ];
  2181.                     break;
  2182.                 default:
  2183.                     throw new NotFoundHttpException();
  2184.             }
  2186.             $system->setData($data);
  2188.             $em->persist($system);
  2189.             $em->flush();
  2191.             $this->get('session')->getFlashBag()->add('success', 'Traduction de l\'élément de cartographie mis à jour');
  2192.             return $this->redirectToRoute("manager_systems");
  2193.         }
  2195.         return $this->render('manager/systems_translate.html.twig', [
  2196.             "form" => $form->createView(),
  2197.             "system" => $system,
  2198.             "fields" => $types[$system->getType()][$system->getSubtype()]
  2199.         ]);
  2200.     }
  2202.     /**
  2203.      * @Route("/systems/{id}/gentranslate/{locale}_{_locale}", name="systems_gen_translate")
  2204.      */
  2205.     public function systemsGanTranslateAction(Request $request, SystemStd $system, $locale, $_locale)
  2206.     {
  2207.         $em = $this->getDoctrine()->getManager();
  2209.         $repository = $em->getRepository('Gedmo\Translatable\Entity\Translation');
  2210.         $translations = $repository->findTranslations($system);
  2212.         if (!isset($translations[$locale])) {
  2213.             $repository
  2214.                 ->translate($system, 'name', $locale, $system->getName())
  2215.                 ->translate($system, 'data', $locale, $system->getData())
  2216.             ;
  2218.             $em->persist($system);
  2219.             $em->flush();
  2221.             return $this->redirectToRoute("manager_systems_translate", ["id" => $system->getId(), "_locale" => $locale]);
  2222.         }
  2224.         return $this->redirectToRoute("manager_systems");
  2225.     }
  2227.     /**
  2228.      * @Route("/systems/export", name="systems_export")
  2229.      */
  2230.     public function systemsExportAction(Request $request)
  2231.     {
  2232.         $systemsQuery = $this->getDoctrine()->getRepository(SystemStd::class)->findAll();
  2234.         $systems = [
  2235.             "computing" => [
  2236.                 "network" => [],
  2237.                 "security" => [],
  2238.                 "administration" => [],
  2239.                 "device" => [],
  2240.                 "software" => [],
  2241.                 "server" => [],
  2242.             ],
  2243.             "physical" => [
  2244.                 "partitioning" => [],
  2245.                 "information" => [],
  2246.             ],
  2247.             "action" => [
  2248.                 "minimization" => [],
  2249.                 "anonymization" => [],
  2250.                 "pseudonymization" => [],
  2251.                 "sensitization" => [],
  2252.                 "supervision" => [],
  2253.                 "destruction" => [],
  2254.             ],
  2255.             "supplier" => [
  2256.                 "supplier" => []
  2257.             ]
  2258.         ];
  2260.         foreach ($systemsQuery as $system) {
  2261.             $systems[$system->getType()][$system->getSubtype()][] = $system;
  2262.         }
  2264.         $pdf = new MyPdf('vertical', PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
  2265.         $pdf->SetAuthor('myDigitplace');
  2266.         $pdf->SetTitle("Cartographie du SI");
  2267.         $pdf->SetMargins(10,22,10, true);
  2268.         $pdf->SetAutoPageBreak(TRUE, 35);
  2269.         $pdf->AddPage('L', 'A4');
  2271.         $html = $this->renderView('manager/pdf/systems.html.twig', [
  2272.             "systems" => $systems
  2273.         ]);
  2275.         $filename = 'Cartographie_du_SI';
  2277.         $pdf->writeHTMLCell($w = 0, $h = 0, $x = '', $y = '', $html, $border = 0, $ln = 1, $fill = 0, $reseth = true, $align = '', $autopadding = true);
  2278.         return $pdf->Output($filename.".pdf",'I');
  2279.     }
  2281.     /**
  2282.      * @Route("/systems/export/{type}", name="systems_export_excel")
  2283.      */
  2284.     public function systemsExportExcelAction(Request $request, $type)
  2285.     {
  2286.         $systemsQuery = $this->getDoctrine()->getRepository(SystemStd::class)->findAll();
  2288.         $systems = [
  2289.             "computing" => [
  2290.                 "network" => [],
  2291.                 "security" => [],
  2292.                 "administration" => [],
  2293.                 "device" => [],
  2294.                 "software" => [],
  2295.                 "server" => [],
  2296.             ],
  2297.             "physical" => [
  2298.                 "partitioning" => [],
  2299.                 "information" => [],
  2300.             ],
  2301.             "action" => [
  2302.                 "minimization" => [],
  2303.                 "anonymization" => [],
  2304.                 "pseudonymization" => [],
  2305.                 "sensitization" => [],
  2306.                 "supervision" => [],
  2307.                 "destruction" => [],
  2308.             ],
  2309.             "supplier" => [
  2310.                 "supplier" => []
  2311.             ]
  2312.         ];
  2314.         foreach ($systemsQuery as $system) {
  2315.             $systems[$system->getType()][$system->getSubtype()][] = $system;
  2316.         }
  2318.         $spreadsheet = new Spreadsheet();
  2320.         $translateSubtypes = [
  2321.             "network" => "Réseau",
  2322.             "security" => "Sécurité",
  2323.             "administration" => "Administration",
  2324.             "device" => "Périphérique",
  2325.             "software" => "Logiciel",
  2326.             "server" => "Serveur",
  2327.             "partitioning" => "Cloisonnement",
  2328.             "minimization" => "Minimisation",
  2329.             "anonymization" => "Anonymisation",
  2330.             "pseudonymization" => "Pseudonymisation",
  2331.             "sensitization" => "Sensibilisation et formation",
  2332.             "information" => "Information",
  2333.             "supervision" => "Contrôle et qualité",
  2334.             "destruction" => "Destruction et suppression",
  2335.             "supplier" => "Prestataires du SI"
  2336.         ];
  2338.         $i = 0;
  2339.         foreach ($systems[$type] as $subtype => $systems) {
  2340.             $i++;
  2342.             $roomsWorkSheet = new Worksheet($spreadsheet, $translateSubtypes[$subtype]);
  2343.             $spreadsheet->addSheet($roomsWorkSheet, $i);
  2345.             $spreadsheet->setActiveSheetIndex($i);
  2346.             $sheet = $spreadsheet->getActiveSheet();
  2348.             $sheet->setCellValue('A1', 'ID');
  2349.             $sheet->setCellValue('B1', 'Nom');
  2351.             switch ($subtype) {
  2352.                 case "network":
  2353.                     $sheet->setCellValue('C1', 'Type');
  2354.                     $sheet->setCellValue('D1', 'Informations complémentaires');
  2355.                     $sheet->setCellValue('E1', 'Type de Wifi');
  2356.                     $sheet->setCellValue('F1', 'Protocole Wifi');
  2357.                     break;
  2358.                 case "security":
  2359.                 case "administration":
  2360.                 case "device":
  2361.                 case "software":
  2362.                 case "server":
  2363.                     $sheet->setCellValue('C1', 'Type');
  2364.                     $sheet->setCellValue('D1', 'Informations complémentaires');
  2365.                     $sheet->setCellValue('E1', 'Date d\'achat');
  2366.                     $sheet->setCellValue('F1', 'N° d\'identification');
  2367.                     break;
  2368.                 case "partitioning":
  2369.                 case "minimization":
  2370.                 case "anonymization":
  2371.                 case "pseudonymization":
  2372.                 case "sensitization":
  2373.                 case "information":
  2374.                 case "supervision":
  2375.                 case "destruction":
  2376.                     $sheet->setCellValue('C1', 'Description');
  2377.                     $sheet->setCellValue('D1', 'Informations complémentaires');
  2378.                     break;
  2379.                 case "supplier":
  2380.                     $sheet->setCellValue('C1', 'Type');
  2381.                     break;
  2382.                 default:
  2383.                     throw new NotFoundHttpException();
  2384.             }
  2386.             $j = 1;
  2387.             foreach ($systems as $system) {
  2388.                 $j++;
  2389.                 $sheet->setCellValue('A'.$j, $system->getId());
  2390.                 $sheet->setCellValue('B'.$j, $system->getName());
  2391.                 switch ($subtype) {
  2392.                     case "network":
  2393.                         $sheet->setCellValue('C'.$j, isset($system->getData()[0])?$system->getData()[0]["value"]:null);
  2394.                         $sheet->setCellValue('D'.$j, isset($system->getData()[1])?$system->getData()[1]["value"]:null);
  2395.                         $sheet->setCellValue('E'.$j, isset($system->getData()[2])?$system->getData()[2]["value"]:null);
  2396.                         $sheet->setCellValue('F'.$j, isset($system->getData()[3])?$system->getData()[3]["value"]:null);
  2397.                         break;
  2398.                     case "security":
  2399.                     case "administration":
  2400.                     case "device":
  2401.                     case "software":
  2402.                     case "server":
  2403.                         $sheet->setCellValue('C'.$j, isset($system->getData()[0])?$system->getData()[0]["value"]:null);
  2404.                         $sheet->setCellValue('D'.$j, isset($system->getData()[1])?$system->getData()[1]["value"]:null);
  2405.                         $sheet->setCellValue('E'.$j, isset($system->getData()[2])?$system->getData()[2]["value"]:null);
  2406.                         $sheet->setCellValue('F'.$j, isset($system->getData()[3])?$system->getData()[3]["value"]:null);
  2407.                         break;
  2408.                     case "partitioning":
  2409.                     case "minimization":
  2410.                     case "anonymization":
  2411.                     case "pseudonymization":
  2412.                     case "sensitization":
  2413.                     case "information":
  2414.                     case "supervision":
  2415.                     case "destruction":
  2416.                         $sheet->setCellValue('C'.$j, isset($system->getData()[0])?$system->getData()[0]["value"]:null);
  2417.                         $sheet->setCellValue('D'.$j, isset($system->getData()[1])?$system->getData()[1]["value"]:null);
  2418.                         break;
  2419.                     case "supplier":
  2420.                         $sheet->setCellValue('C'.$j, isset($system->getData()[0])?$system->getData()[0]["value"]:null);
  2421.                         break;
  2422.                     default:
  2423.                         throw new NotFoundHttpException();
  2424.                 }
  2425.             }
  2426.         }
  2428.         $spreadsheet->removeSheetByIndex(0);
  2430.         $writer = new Xlsx($spreadsheet);
  2432.         $response = new StreamedResponse();
  2433.         $response->setCallback(function () use ($writer) {
  2434.             $writer->save('php://output');
  2435.         });
  2437.         $response->setStatusCode(200);
  2438.         $response->headers->set('Content-Type', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
  2439.         $response->headers->set('Content-Disposition', 'attachment;filename="export_cartographie.xlsx"');
  2440.         $response->headers->set('Cache-Control','max-age=0');
  2441.         return $response;
  2442.     }
  2444.     /**
  2445.      * @Route("/systems/add", name="systems_add")
  2446.      */
  2447.     public function systemsAddAction(Request $request)
  2448.     {
  2449.         $types = [
  2450.             "computing" => [
  2451.                 "network" => 4,
  2452.                 "security" => 4,
  2453.                 "administration" => 4,
  2454.                 "device" => 4,
  2455.                 "software" => 4,
  2456.                 "server" => 4,
  2457.             ],
  2458.             "physical" => [
  2459.                 "partitioning" => 2,
  2460.                 "information" => 2,
  2461.             ],
  2462.             "action" => [
  2463.                 "minimization" => 2,
  2464.                 "anonymization" => 2,
  2465.                 "pseudonymization" => 2,
  2466.                 "sensitization" => 2,
  2467.                 "supervision" => 2,
  2468.                 "destruction" => 2,
  2469.             ],
  2470.             "supplier" => [
  2471.                 "supplier" => 1
  2472.             ]
  2473.         ];
  2475.         if (!$_GET['type'] || !$_GET['subtype']) {
  2476.             throw new NotFoundHttpException();
  2477.         }
  2479.         if (!key_exists($_GET['type'], $types)) {
  2480.             throw new NotFoundHttpException();
  2481.         }
  2483.         if (!key_exists($_GET['subtype'], $types[$_GET['type']])) {
  2484.             throw new NotFoundHttpException();
  2485.         }
  2487.         $system = new SystemStd();
  2489.         $form = $this->createForm(SystemStdType::class, $system);
  2491.         switch ($_GET['subtype']) {
  2492.             case "network":
  2493.                 $form->add('field1', ChoiceType::class, [
  2494.                     'attr' => [
  2495.                         'placeholder' => 'Type'
  2496.                     ],
  2497.                     'placeholder' => 'Type',
  2498.                     'label' => 'Type',
  2499.                     'choices' => [
  2500.                         "Filaire" => "Filaire",
  2501.                         "Sans-fil" => "Sans-fil",
  2502.                     ],
  2503.                     'required' => false,
  2504.                     'mapped' => false
  2505.                 ])
  2506.                     ->add('field2', TextareaType::class, [
  2507.                         'attr' => [
  2508.                             'placeholder' => 'Informations complémentaires'
  2509.                         ],
  2510.                         'label' => 'Informations complémentaires',
  2511.                         'required' => false,
  2512.                         'mapped' => false
  2513.                     ])
  2514.                     ->add('field3', ChoiceType::class, [
  2515.                         'attr' => [
  2516.                             'placeholder' => 'Type'
  2517.                         ],
  2518.                         'placeholder' => 'Type',
  2519.                         'label' => 'Si Wifi, sélectionnez le type',
  2520.                         'choices' => [
  2521.                             "Privé" => "Privé",
  2522.                             "Public" => "Public",
  2523.                         ],
  2524.                         'required' => false,
  2525.                         'mapped' => false
  2526.                     ])
  2527.                     ->add('field4', TextType::class, [
  2528.                         'attr' => [
  2529.                             'placeholder' => 'Protocole'
  2530.                         ],
  2531.                         'label' => 'Si Wifi, quel protocole ?',
  2532.                         'required' => false,
  2533.                         'mapped' => false
  2534.                     ])
  2535.                 ;
  2536.                 break;
  2537.             case "security":
  2538.             case "administration":
  2539.             case "device":
  2540.             case "software":
  2541.             case "server":
  2542.                 $form->add('field1', TextType::class, [
  2543.                     'attr' => [
  2544.                         'placeholder' => 'Type'
  2545.                     ],
  2546.                     'label' => 'Type',
  2547.                     'required' => false,
  2548.                     'mapped' => false
  2549.                 ])
  2550.                     ->add('field2', TextareaType::class, [
  2551.                         'attr' => [
  2552.                             'placeholder' => 'Informations complémentaires'
  2553.                         ],
  2554.                         'label' => 'Informations complémentaires',
  2555.                         'required' => false,
  2556.                         'mapped' => false
  2557.                     ])
  2558.                     ->add('field3', TextType::class, [
  2559.                         'attr' => [
  2560.                             'placeholder' => '__/__/____',
  2561.                             'data-mask' => '00/00/0000',
  2562.                             'data-mask-clearifnotmatch' => 'true'
  2563.                         ],
  2564.                         'label' => 'Date d\'achat',
  2565.                         'required' => false,
  2566.                         'mapped' => false
  2567.                     ])
  2568.                     ->add('field4', TextType::class, [
  2569.                         'attr' => [
  2570.                             'placeholder' => 'N° d’identification'
  2571.                         ],
  2572.                         'label' => 'N° d’identification',
  2573.                         'required' => false,
  2574.                         'mapped' => false
  2575.                     ]);
  2576.                 break;
  2577.             case "partitioning":
  2578.             case "minimization":
  2579.             case "anonymization":
  2580.             case "pseudonymization":
  2581.             case "sensitization":
  2582.             case "information":
  2583.             case "supervision":
  2584.             case "destruction":
  2585.                 $form->add('field1', TextareaType::class, [
  2586.                     'attr' => [
  2587.                         'placeholder' => 'Description'
  2588.                     ],
  2589.                     'label' => 'Description',
  2590.                     'required' => false,
  2591.                     'mapped' => false
  2592.                 ])
  2593.                     ->add('field2', TextareaType::class, [
  2594.                         'attr' => [
  2595.                             'placeholder' => 'Informations complémentaires'
  2596.                         ],
  2597.                         'label' => 'Informations complémentaires',
  2598.                         'required' => false,
  2599.                         'mapped' => false
  2600.                     ]);
  2601.                 break;
  2602.             case "supplier":
  2603.                 $form->add('field1', TextType::class, [
  2604.                     'attr' => [
  2605.                         'placeholder' => 'Type'
  2606.                     ],
  2607.                     'label' => 'Type',
  2608.                     'required' => false,
  2609.                     'mapped' => false
  2610.                 ]);
  2611.                 break;
  2612.             default:
  2613.                 throw new NotFoundHttpException();
  2614.         }
  2616.         $form->handleRequest($request);
  2618.         if ($form->isSubmitted() && $form->isValid()) {
  2619.             $em = $this->getDoctrine()->getManager();
  2621.             $data = [];
  2623.             switch ($_GET['subtype']) {
  2624.                 case "network":
  2625.                     $data[] = [
  2626.                         "title" => 'Type',
  2627.                         "value" => $form['field1']->getData()
  2628.                     ];
  2629.                     $data[] = [
  2630.                         "title" => 'Informations complémentaires',
  2631.                         "value" => $form['field2']->getData()
  2632.                     ];
  2633.                     $data[] = [
  2634.                         "title" => 'Type de Wifi',
  2635.                         "value" => $form['field3']->getData()
  2636.                     ];
  2637.                     $data[] = [
  2638.                         "title" => 'Protocole Wifi',
  2639.                         "value" => $form['field4']->getData()
  2640.                     ];
  2641.                     ;
  2642.                     break;
  2643.                 case "security":
  2644.                 case "administration":
  2645.                 case "device":
  2646.                 case "software":
  2647.                 case "server":
  2648.                     $data[] = [
  2649.                         "title" => 'Type',
  2650.                         "value" => $form['field1']->getData()
  2651.                     ];
  2652.                     $data[] = [
  2653.                         "title" => 'Informations complémentaires',
  2654.                         "value" => $form['field2']->getData()
  2655.                     ];
  2656.                     $data[] = [
  2657.                         "title" => 'Date d\'achat',
  2658.                         "value" => $form['field3']->getData()
  2659.                     ];
  2660.                     $data[] = [
  2661.                         "title" => 'N° d’identification',
  2662.                         "value" => $form['field4']->getData()
  2663.                     ];
  2664.                     break;
  2665.                 case "partitioning":
  2666.                 case "minimization":
  2667.                 case "anonymization":
  2668.                 case "pseudonymization":
  2669.                 case "sensitization":
  2670.                 case "information":
  2671.                 case "supervision":
  2672.                 case "destruction":
  2673.                     $data[] = [
  2674.                         "title" => 'Description',
  2675.                         "value" => $form['field1']->getData()
  2676.                     ];
  2677.                     $data[] = [
  2678.                         "title" => 'Informations complémentaires',
  2679.                         "value" => $form['field2']->getData()
  2680.                     ];
  2681.                     break;
  2682.                 case "supplier":
  2683.                     $data[] = [
  2684.                         "title" => 'Type',
  2685.                         "value" => $form['field1']->getData()
  2686.                     ];
  2687.                     break;
  2688.                 default:
  2689.                     throw new NotFoundHttpException();
  2690.             }
  2692.             $system->setData($data);
  2693.             $system->setType($_GET['type']);
  2694.             $system->setSubtype($_GET['subtype']);
  2695.             $system->setManager($this->getUser()->getManager());
  2697.             $em->persist($system);
  2698.             $em->flush();
  2700.             $this->get('session')->getFlashBag()->add('success', 'Nouvelle mesure technique standard créée');
  2701.             return $this->redirectToRoute("manager_systems");
  2702.         }
  2704.         return $this->render('manager/systems_add.html.twig', [
  2705.             "form" => $form->createView(),
  2706.             "fields" => $types[$_GET['type']][$_GET['subtype']]
  2707.         ]);
  2708.     }
  2710.     /**
  2711.      * @Route("/systems/{id}/edit", name="systems_edit")
  2712.      */
  2713.     public function systemsEditAction(Request $request, SystemStd $system)
  2714.     {
  2715.         $types = [
  2716.             "computing" => [
  2717.                 "network" => 4,
  2718.                 "security" => 4,
  2719.                 "administration" => 4,
  2720.                 "device" => 4,
  2721.                 "software" => 4,
  2722.                 "server" => 4,
  2723.             ],
  2724.             "physical" => [
  2725.                 "partitioning" => 2,
  2726.                 "information" => 2,
  2727.             ],
  2728.             "action" => [
  2729.                 "minimization" => 2,
  2730.                 "anonymization" => 2,
  2731.                 "pseudonymization" => 2,
  2732.                 "sensitization" => 2,
  2733.                 "supervision" => 2,
  2734.                 "destruction" => 2,
  2735.             ],
  2736.             "supplier" => [
  2737.                 "supplier" => 1
  2738.             ]
  2739.         ];
  2741.         $form = $this->createForm(SystemStdType::class, $system);
  2743.         switch ($system->getSubtype()) {
  2744.             case "network":
  2745.                 $form->add('field1', ChoiceType::class, [
  2746.                     'attr' => [
  2747.                         'placeholder' => 'Type'
  2748.                     ],
  2749.                     'placeholder' => 'Type',
  2750.                     'label' => 'Type',
  2751.                     'choices' => [
  2752.                         "Filaire" => "Filaire",
  2753.                         "Sans-fil" => "Sans-fil",
  2754.                     ],
  2755.                     'data' => isset($system->getData()[0])?$system->getData()[0]["value"]:null,
  2756.                     'required' => false,
  2757.                     'mapped' => false
  2758.                 ])
  2759.                     ->add('field2', TextareaType::class, [
  2760.                         'attr' => [
  2761.                             'placeholder' => 'Informations complémentaires'
  2762.                         ],
  2763.                         'label' => 'Informations complémentaires',
  2764.                         'data' => isset($system->getData()[1])?$system->getData()[1]["value"]:null,
  2765.                         'required' => false,
  2766.                         'mapped' => false
  2767.                     ])
  2768.                     ->add('field3', ChoiceType::class, [
  2769.                         'attr' => [
  2770.                             'placeholder' => 'Type'
  2771.                         ],
  2772.                         'placeholder' => 'Type',
  2773.                         'label' => 'Si Wifi, sélectionnez le type',
  2774.                         'choices' => [
  2775.                             "Privé" => "Privé",
  2776.                             "Public" => "Public",
  2777.                         ],
  2778.                         'data' => isset($system->getData()[2])?$system->getData()[2]["value"]:null,
  2779.                         'required' => false,
  2780.                         'mapped' => false
  2781.                     ])
  2782.                     ->add('field4', TextType::class, [
  2783.                         'attr' => [
  2784.                             'placeholder' => 'Protocole'
  2785.                         ],
  2786.                         'label' => 'Si Wifi, quel protocole ?',
  2787.                         'data' => isset($system->getData()[3])?$system->getData()[3]["value"]:null,
  2788.                         'required' => false,
  2789.                         'mapped' => false
  2790.                     ])
  2791.                 ;
  2792.                 break;
  2793.             case "security":
  2794.             case "administration":
  2795.             case "device":
  2796.             case "software":
  2797.             case "server":
  2798.                 $form->add('field1', TextType::class, [
  2799.                     'attr' => [
  2800.                         'placeholder' => 'Type'
  2801.                     ],
  2802.                     'label' => 'Type',
  2803.                     'data' => isset($system->getData()[0])?$system->getData()[0]["value"]:null,
  2804.                     'required' => false,
  2805.                     'mapped' => false
  2806.                 ])
  2807.                     ->add('field2', TextareaType::class, [
  2808.                         'attr' => [
  2809.                             'placeholder' => 'Informations complémentaires'
  2810.                         ],
  2811.                         'label' => 'Informations complémentaires',
  2812.                         'data' => isset($system->getData()[1])?$system->getData()[1]["value"]:null,
  2813.                         'required' => false,
  2814.                         'mapped' => false
  2815.                     ])
  2816.                     ->add('field3', TextType::class, [
  2817.                         'attr' => [
  2818.                             'placeholder' => '__/__/____',
  2819.                             'data-mask' => '00/00/0000',
  2820.                             'data-mask-clearifnotmatch' => 'true'
  2821.                         ],
  2822.                         'label' => 'Date d\'achat',
  2823.                         'data' => isset($system->getData()[2])?$system->getData()[2]["value"]:null,
  2824.                         'required' => false,
  2825.                         'mapped' => false
  2826.                     ])
  2827.                     ->add('field4', TextType::class, [
  2828.                         'attr' => [
  2829.                             'placeholder' => 'N° d’identification'
  2830.                         ],
  2831.                         'label' => 'N° d’identification',
  2832.                         'data' => isset($system->getData()[3])?$system->getData()[3]["value"]:null,
  2833.                         'required' => false,
  2834.                         'mapped' => false
  2835.                     ]);
  2836.                 break;
  2837.             case "partitioning":
  2838.             case "minimization":
  2839.             case "anonymization":
  2840.             case "pseudonymization":
  2841.             case "sensitization":
  2842.             case "information":
  2843.             case "supervision":
  2844.             case "destruction":
  2845.                 $form->add('field1', TextareaType::class, [
  2846.                     'attr' => [
  2847.                         'placeholder' => 'Description'
  2848.                     ],
  2849.                     'label' => 'Description',
  2850.                     'data' => isset($system->getData()[0])?$system->getData()[0]["value"]:null,
  2851.                     'required' => false,
  2852.                     'mapped' => false
  2853.                 ])
  2854.                     ->add('field2', TextareaType::class, [
  2855.                         'attr' => [
  2856.                             'placeholder' => 'Informations complémentaires'
  2857.                         ],
  2858.                         'label' => 'Informations complémentaires',
  2859.                         'data' => isset($system->getData()[1])?$system->getData()[1]["value"]:null,
  2860.                         'required' => false,
  2861.                         'mapped' => false
  2862.                     ]);
  2863.                 break;
  2864.             case "supplier":
  2865.                 $form->add('field1', TextType::class, [
  2866.                     'attr' => [
  2867.                         'placeholder' => 'Type'
  2868.                     ],
  2869.                     'label' => 'Type',
  2870.                     'data' => isset($system->getData()[0])?$system->getData()[0]["value"]:null,
  2871.                     'required' => false,
  2872.                     'mapped' => false
  2873.                 ]);
  2874.                 break;
  2875.             default:
  2876.                 throw new NotFoundHttpException();
  2877.         }
  2879.         $form->handleRequest($request);
  2881.         if ($form->isSubmitted() && $form->isValid()) {
  2882.             $em = $this->getDoctrine()->getManager();
  2884.             $data = [];
  2886.             switch ($system->getSubtype()) {
  2887.                 case "network":
  2888.                     $data[] = [
  2889.                         "title" => 'Type',
  2890.                         "value" => $form['field1']->getData()
  2891.                     ];
  2892.                     $data[] = [
  2893.                         "title" => 'Informations complémentaires',
  2894.                         "value" => $form['field2']->getData()
  2895.                     ];
  2896.                     $data[] = [
  2897.                         "title" => 'Type de Wifi',
  2898.                         "value" => $form['field3']->getData()
  2899.                     ];
  2900.                     $data[] = [
  2901.                         "title" => 'Protocole Wifi',
  2902.                         "value" => $form['field4']->getData()
  2903.                     ];
  2904.                     ;
  2905.                     break;
  2906.                 case "security":
  2907.                 case "administration":
  2908.                 case "device":
  2909.                 case "software":
  2910.                 case "server":
  2911.                     $data[] = [
  2912.                         "title" => 'Type',
  2913.                         "value" => $form['field1']->getData()
  2914.                     ];
  2915.                     $data[] = [
  2916.                         "title" => 'Informations complémentaires',
  2917.                         "value" => $form['field2']->getData()
  2918.                     ];
  2919.                     $data[] = [
  2920.                         "title" => 'Date d\'achat',
  2921.                         "value" => $form['field3']->getData()
  2922.                     ];
  2923.                     $data[] = [
  2924.                         "title" => 'N° d’identification',
  2925.                         "value" => $form['field4']->getData()
  2926.                     ];
  2927.                     break;
  2928.                 case "partitioning":
  2929.                 case "minimization":
  2930.                 case "anonymization":
  2931.                 case "pseudonymization":
  2932.                 case "sensitization":
  2933.                 case "information":
  2934.                 case "supervision":
  2935.                 case "destruction":
  2936.                     $data[] = [
  2937.                         "title" => 'Description',
  2938.                         "value" => $form['field1']->getData()
  2939.                     ];
  2940.                     $data[] = [
  2941.                         "title" => 'Informations complémentaires',
  2942.                         "value" => $form['field2']->getData()
  2943.                     ];
  2944.                     break;
  2945.                 case "supplier":
  2946.                     $data[] = [
  2947.                         "title" => 'Type',
  2948.                         "value" => $form['field1']->getData()
  2949.                     ];
  2950.                     break;
  2951.                 default:
  2952.                     throw new NotFoundHttpException();
  2953.             }
  2955.             $system->setData($data);
  2957.             $em->flush();
  2959.             $this->get('session')->getFlashBag()->add('success', 'Mise à jour de la mesure technique standard');
  2960.             return $this->redirectToRoute("manager_systems");
  2961.         }
  2963.         return $this->render('manager/systems_edit.html.twig', [
  2964.             "form" => $form->createView(),
  2965.             "fields" => $types[$system->getType()][$system->getSubtype()]
  2966.         ]);
  2967.     }
  2969.     /**
  2970.      * @Route("/systems/{id}/delete", name="systems_delete")
  2971.      */
  2972.     public function systemsDeleteAction(Request $request, SystemStd $system)
  2973.     {
  2974.         $em = $this->getDoctrine()->getManager();
  2976.         $em->remove($system);
  2977.         $em->flush();
  2979.         $this->get('session')->getFlashBag()->add('success', 'Suppression de la mesure technique standard');
  2980.         return $this->redirectToRoute("manager_systems");
  2981.     }
  2983.     /**
  2984.      * @Route("/treatments", name="treatments")
  2985.      */
  2986.     public function treatmentsAction(Request $request)
  2987.     {
  2988.         $treatments = $this->getDoctrine()->getRepository(TreatmentStd::class)->findBy(["user" => null]);
  2989.         
  2990.         return $this->render('manager/treatments.html.twig', [
  2991.             "treatments" => $treatments
  2992.         ]);
  2993.     }
  2995.     /**
  2996.      * @Route("/treatments/add", name="treatments_add")
  2997.      */
  2998.     public function treatmentsAddAction(Request $request)
  2999.     {
  3000.         $treatment = new TreatmentStd();
  3002.         $form = $this->createForm(TreatmentStdType::class, $treatment);
  3004.         $personalDataFields = [
  3005.             [
  3006.                 "title" => "État civil, identité, données d'identification, images...",
  3007.                 "level" => 1,
  3008.             ],
  3009.             [
  3010.                 "title" => "Vie personnelle (habitudes de vie, situation familiale, etc.)",
  3011.                 "level" => 1,
  3012.             ],
  3013.             [
  3014.                 "title" => "Infos d'ordre économique et financier (revenus, situation financière, situation fiscale, etc.)",
  3015.                 "level" => 1,
  3016.             ],
  3017.             [
  3018.                 "title" => "Données de connexion (adress IP, logs, etc.)",
  3019.                 "level" => 1,
  3020.             ],
  3021.             [
  3022.                 "title" => "Données de localisation (déplacements, données GPS, GSM, etc.)",
  3023.                 "level" => 1,
  3024.             ],
  3025.             [
  3026.                 "title" => "Données Bancaires (données courantes « non sensible » mais classifié comme tel au vu des risques financiers)",
  3027.                 "level" => 2,
  3028.             ],
  3029.             [
  3030.                 "title" => "Numéro de Sécurité Sociale (ou NIR)",
  3031.                 "level" => 2,
  3032.             ],
  3033.             [
  3034.                 "title" => "Données révélant l'origine raciale ou ethnique",
  3035.                 "level" => 3,
  3036.             ],
  3037.             [
  3038.                 "title" => "Données révélant les opinions politiques",
  3039.                 "level" => 3,
  3040.             ],
  3041.             [
  3042.                 "title" => "Données révélant les convictions religieuses ou philosophiques",
  3043.                 "level" => 3,
  3044.             ],
  3045.             [
  3046.                 "title" => "Données révélant l'appartenance syndicale",
  3047.                 "level" => 3,
  3048.             ],
  3049.             [
  3050.                 "title" => "Données génétiques",
  3051.                 "level" => 3,
  3052.             ],
  3053.             [
  3054.                 "title" => "Données biométriques aux fins d'identifier une personne physique de manière unique",
  3055.                 "level" => 3,
  3056.             ],
  3057.             [
  3058.                 "title" => "Données concernant la santé",
  3059.                 "level" => 3,
  3060.             ],
  3061.             [
  3062.                 "title" => "Données concernant la vie sexuelle ou l'orientation sexuelle",
  3063.                 "level" => 3,
  3064.             ],
  3065.             [
  3066.                 "title" => "Données relatives à des condamnations pénales ou infractions",
  3067.                 "level" => 3,
  3068.             ],
  3069.         ];
  3071.         foreach ($personalDataFields as $key => $field) {
  3072.             $form->add("field_text_".$key, TextType::class, [
  3073.                 'attr' => [
  3074.                     'placeholder' => 'Zone de saisie'
  3075.                 ],
  3076.                 'label' => 'Zone de saisie',
  3077.                 'required' => false,
  3078.                 'mapped' => false
  3079.             ]);
  3080.             /*    ->add("field_duration_".$key, TextType::class, [
  3081.                 'attr' => [
  3082.                     'placeholder' => 'Durée de conservation'
  3083.                 ],
  3084.                 'label' => 'Durée de conservation',
  3085.                 'required' => false,
  3086.                 'mapped' => false
  3087.             ])*/
  3088.         }
  3090.         $form->handleRequest($request);
  3092.         if ($form->isSubmitted() && $form->isValid()) {
  3093.             $em = $this->getDoctrine()->getManager();
  3095.             $now = new \DateTime("now");
  3097.             $personalData = [];
  3099.             $sensitiveData = false;
  3101.             foreach ($personalDataFields as $key => $field) {
  3102.                 $personalData[] = [
  3103.                     "title" => $field['title'],
  3104.                     "level" => $field['level'],
  3105.                     "text" => $form["field_text_".$key]->getData(),
  3106.                     //"duration" => $form["field_duration_".$key]->getData(),
  3107.                 ];
  3109.                 if (($field['level'] == 2 || $field['level'] == 3) && ($form["field_text_".$key]->getData()/* || $form["field_duration_".$key]->getData()*/)) {
  3110.                     $sensitiveData = true;
  3111.                 }
  3112.             }
  3114.             $treatment->setPersonalData($personalData);
  3115.             $treatment->setSensitiveData($sensitiveData);
  3117.             $treatment->setCreationDate($now);
  3118.             $treatment->setEditDate($now);
  3119.             $treatment->setManager($this->getUser()->getManager());
  3121.             if ($treatment->isSensitiveData()) {
  3122.                 if (!in_array(1, $treatment->getPiaCriteria())) {
  3123.                     $treatment->addPiaCriteria(1);
  3124.                 }
  3125.             } else {
  3126.                 $treatment->setInsufficientCriteria(true);
  3127.             }
  3129.             if (count($treatment->getPiaCriteria()) >= 2) {
  3130.                 $treatment->setPiaNeeded(true);
  3131.             } else {
  3132.                 $treatment->setPiaNeeded(false);
  3133.             }
  3135.             $em->persist($treatment);
  3136.             $em->flush();
  3138.             $this->get('session')->getFlashBag()->add('success', 'Nouveau traitement standard ajouté');
  3139.             return $this->redirectToRoute("manager_treatments");
  3140.         }
  3142.         return $this->render('manager/treatments_add.html.twig', [
  3143.             "form" => $form->createView(),
  3144.             "personalDataFields" => $personalDataFields
  3145.         ]);
  3146.     }
  3148.     /**
  3149.      * @Route("/treatments/{id}/edit", name="treatments_edit")
  3150.      */
  3151.     public function treatmentsEditAction(Request $request, TreatmentStd $treatment)
  3152.     {
  3153.         if (count($treatment->getPiaCriteria()) == 0) {
  3154.             if ($treatment->isAutomatedDecision()) {
  3155.                 $em = $this->getDoctrine()->getManager();
  3157.                 $treatment->setPiaCriteria([4]);
  3158.                 $treatment->setAutomatedDecision(false);
  3160.                 $em->flush();
  3161.                 return $this->redirectToRoute("manager_treatments_edit", ["id" => $treatment->getId()]);
  3162.             }
  3163.         }
  3165.         $form = $this->createForm(TreatmentStdType::class, $treatment);
  3167.         foreach ($treatment->getPersonalData() as $key => $field) {
  3168.             $form->add("field_text_".$key, TextType::class, [
  3169.                 'attr' => [
  3170.                     'placeholder' => 'Zone de saisie'
  3171.                 ],
  3172.                 'label' => 'Zone de saisie',
  3173.                 'data' => $field['text'],
  3174.                 'required' => false,
  3175.                 'mapped' => false
  3176.             ]);
  3177.             /*    ->add("field_duration_".$key, TextType::class, [
  3178.                 'attr' => [
  3179.                     'placeholder' => 'Durée de conservation'
  3180.                 ],
  3181.                 'label' => 'Durée de conservation',
  3182.                 'data' => $field['duration'],
  3183.                 'required' => false,
  3184.                 'mapped' => false
  3185.             ]);*/
  3186.         }
  3188.         $form->handleRequest($request);
  3190.         if ($form->isSubmitted() && $form->isValid()) {
  3191.             $em = $this->getDoctrine()->getManager();
  3193.             $now = new \DateTime("now");
  3195.             $personalData = [];
  3197.             $sensitiveData = false;
  3199.             foreach ($treatment->getPersonalData() as $key => $field) {
  3200.                 $personalData[] = [
  3201.                     "title" => $field['title'],
  3202.                     "level" => $field['level'],
  3203.                     "text" => $form["field_text_".$key]->getData(),
  3204.                     //"duration" => $form["field_duration_".$key]->getData(),
  3205.                 ];
  3207.                 if (($field['level'] == 2 || $field['level'] == 3) && ($form["field_text_".$key]->getData()/* || $form["field_duration_".$key]->getData()*/)) {
  3208.                     $sensitiveData = true;
  3209.                 }
  3210.             }
  3212.             $treatment->setPersonalData($personalData);
  3213.             $treatment->setSensitiveData($sensitiveData);
  3215.             if ($treatment->isSensitiveData()) {
  3216.                 if (!in_array(1, $treatment->getPiaCriteria())) {
  3217.                     $treatment->addPiaCriteria(1);
  3218.                 }
  3219.             } else {
  3220.                 $treatment->setInsufficientCriteria(true);
  3221.             }
  3223.             $treatment->setEditDate($now);
  3225.             if (count($treatment->getPiaCriteria()) >= 2) {
  3226.                 $treatment->setPiaNeeded(true);
  3227.             } else {
  3228.                 $treatment->setPiaNeeded(false);
  3229.             }
  3231.             $em->flush();
  3233.             $this->get('session')->getFlashBag()->add('success', 'Traitement standard mis à jour');
  3234.             return $this->redirectToRoute("manager_treatments");
  3235.         }
  3237.         return $this->render('manager/treatments_edit.html.twig', [
  3238.             "form" => $form->createView(),
  3239.             "treatment" => $treatment,
  3240.             "personalDataFields" => $treatment->getPersonalData()
  3241.         ]);
  3242.     }
  3244.     /**
  3245.      * @Route("/treatments/{id}/translate/{_locale}", name="treatments_translate")
  3246.      */
  3247.     public function treatmentsTranslateAction(Request $request, TreatmentStd $treatment)
  3248.     {
  3249.         $em = $this->getDoctrine()->getManager();
  3251.         $repository = $em->getRepository('Gedmo\Translatable\Entity\Translation');
  3252.         $translations = $repository->findTranslations($treatment);
  3254.         if (!isset($translations[$request->get("_locale")])) {
  3255.             return $this->redirectToRoute("manager_treatments_gen_translate", ["id" => $treatment->getId(), "locale" => 'en']);
  3256.         }
  3258.         $treatment = $em->find(TreatmentStd::class, $request->get("id"));
  3260.         $form = $this->createForm(TreatmentStdTranslateType::class, $treatment);
  3262.         foreach ($treatment->getPersonalData() as $key => $field) {
  3263.             $form->add("field_text_".$key, TextType::class, [
  3264.                 'attr' => [
  3265.                     'placeholder' => 'Zone de saisie'
  3266.                 ],
  3267.                 'label' => 'Zone de saisie',
  3268.                 'data' => $field['text'],
  3269.                 'required' => false,
  3270.                 'mapped' => false
  3271.             ]);
  3272.         }
  3274.         $form->handleRequest($request);
  3276.         if ($form->isSubmitted() && $form->isValid()) {
  3277.             $personalData = [];
  3279.             foreach ($treatment->getPersonalData() as $key => $field) {
  3280.                 $personalData[] = [
  3281.                     "title" => $field['title'],
  3282.                     "level" => $field['level'],
  3283.                     "text" => $form["field_text_".$key]->getData(),
  3284.                 ];
  3285.             }
  3287.             $treatment->setPersonalData($personalData);
  3289.             $em->persist($treatment);
  3290.             $em->flush();
  3292.             $this->get('session')->getFlashBag()->add('success', 'Traduction du traitement standard mise à jour');
  3293.             return $this->redirectToRoute("manager_treatments");
  3294.         }
  3296.         return $this->render('manager/treatments_edit.html.twig', [
  3297.             "form" => $form->createView(),
  3298.             "treatment" => $treatment,
  3299.             "personalDataFields" => $treatment->getPersonalData()
  3300.         ]);
  3301.     }
  3303.     /**
  3304.      * @Route("/treatments/{id}/gentranslate/{locale}", name="treatments_gen_translate")
  3305.      */
  3306.     public function treatmentsGanTranslateAction(Request $request, TreatmentStd $treatment, $locale)
  3307.     {
  3308.         $em = $this->getDoctrine()->getManager();
  3310.         $repository = $em->getRepository('Gedmo\Translatable\Entity\Translation');
  3311.         $translations = $repository->findTranslations($treatment);
  3313.         if (!isset($translations[$locale])) {
  3314.             $repository
  3315.                 ->translate($treatment, 'name', 'en', $treatment->getName())
  3316.                 ->translate($treatment, 'mainPurpose', 'en', $treatment->getMainPurpose())
  3317.                 ->translate($treatment, 'purpose1', 'en', $treatment->getPurpose1())
  3318.                 ->translate($treatment, 'purpose2', 'en', $treatment->getPurpose2())
  3319.                 ->translate($treatment, 'purpose3', 'en', $treatment->getPurpose3())
  3320.                 ->translate($treatment, 'purpose4', 'en', $treatment->getPurpose4())
  3321.                 ->translate($treatment, 'purpose5', 'en', $treatment->getPurpose5())
  3322.                 ->translate($treatment, 'othersPurpose', 'en', $treatment->getOthersPurpose())
  3323.                 ->translate($treatment, 'description', 'en', $treatment->getDescription())
  3324.                 ->translate($treatment, 'personalData', 'en', $treatment->getPersonalData())
  3325.                 ->translate($treatment, 'peopleData', 'en', $treatment->getPeopleData())
  3326.                 ->translate($treatment, 'transferOutsideUeCountries', 'en', $treatment->getTransferOutsideUeCountries())
  3327.                 ->translate($treatment, 'consentHow', 'en', $treatment->getConsentHow())
  3328.                 ->translate($treatment, 'legalBasis', 'en', $treatment->getLegalBasis())
  3329.                 ->translate($treatment, 'dataSource', 'en', $treatment->getDataSource())
  3330.             ;
  3332.             $em->persist($treatment);
  3333.             $em->flush();
  3335.             return $this->redirectToRoute("manager_treatments_translate", ["id" => $treatment->getId(), "_locale" => 'en']);
  3336.         }
  3338.         return $this->redirectToRoute("manager_treatments_translate", ["id" => $treatment->getId(), "_locale" => 'en']);
  3339.     }
  3341.     /**
  3342.      * @Route("/treatments/{id}/delete", name="treatments_delete")
  3343.      */
  3344.     public function treatmentsDeleteAction(Request $request, TreatmentStd $treatment)
  3345.     {
  3346.         $em = $this->getDoctrine()->getManager();
  3348.         $em->remove($treatment);
  3349.         $em->flush();
  3351.         $this->get('session')->getFlashBag()->add('success', 'Traitement standard supprimé');
  3352.         return $this->redirectToRoute("manager_treatments");
  3353.     }
  3355.     /**
  3356.      * @Route("/subcontractors", name="subcontractors")
  3357.      */
  3358.     public function subcontractorsAction(Request $request)
  3359.     {
  3360.         $subcontractors = $this->getDoctrine()->getRepository(SubcontractorStd::class)->findBy([], ["name" => "ASC"]);
  3362.         return $this->render('manager/subcontractors.html.twig', [
  3363.             "subcontractors" => $subcontractors
  3364.         ]);
  3365.     }
  3367.     /**
  3368.      * @Route("/subcontractors/add", name="subcontractors_add")
  3369.      */
  3370.     public function subcontractorsAddAction(Request $request)
  3371.     {
  3372.         $subcontractor = new SubcontractorStd();
  3374.         $form = $this->createForm(SubcontractorStdType::class, $subcontractor);
  3376.         $form->handleRequest($request);
  3378.         if ($form->isSubmitted() && $form->isValid()) {
  3379.             $em = $this->getDoctrine()->getManager();
  3381.             $now = new \DateTime("now");
  3383.             $subcontractor->setDate($now);
  3384.             $subcontractor->setEditDate($now);
  3385.             $subcontractor->setManager($this->getUser()->getManager());
  3387.             $em->persist($subcontractor);
  3388.             $em->flush();
  3390.             if (isset($_FILES['appbundle_subcontractor_documents'])) {
  3391.                 $files = $_FILES['appbundle_subcontractor_documents'];
  3392.                 $fileNames = $_POST['appbundle_subcontractor_documents_names'];
  3393.                 for ($i=0;$i<count($files['name']);$i++) {
  3394.                     if ( is_uploaded_file( $files["tmp_name"][$i] ) && file_exists($files["tmp_name"][$i]) && $files["error"][$i] === 0) {
  3395.                         $name = $files["name"][$i];
  3396.                         $parts = explode(".", $name);
  3397.                         $extension = end($parts);
  3399.                         $fileName = $subcontractor->getId()."_".md5(uniqid()) . '.' . $extension;
  3401.                         move_uploaded_file($files["tmp_name"][$i], $this->getParameter('documents_directory') . $fileName);
  3403.                         $docTitle = (isset($fileNames[$i]) && !empty($fileNames[$i]))?$fileNames[$i]:$files["name"][$i];
  3404.                         $document = new SubcontractorStdDocument();
  3405.                         $document->setName($docTitle);
  3406.                         $document->setFilename($fileName);
  3407.                         $document->setUserFilename($files["name"][$i]);
  3408.                         $document->setManager($this->getUser()->getManager());
  3409.                         $document->setSubcontractorStd($subcontractor);
  3410.                         $em->persist($document);
  3411.                         $em->flush();
  3412.                     }
  3413.                 }
  3414.             }
  3416.             $this->get('session')->getFlashBag()->add('success', 'Nouveau sous-traitant standard ajouté');
  3417.             return $this->redirectToRoute("manager_subcontractors");
  3418.         }
  3420.         return $this->render('manager/subcontractors_add.html.twig', [
  3421.             "form" => $form->createView()
  3422.         ]);
  3423.     }
  3425.     /**
  3426.      * @Route("/subcontractors/{id}/edit", name="subcontractors_edit")
  3427.      */
  3428.     public function subcontractorsEditAction(Request $request, SubcontractorStd $subcontractor)
  3429.     {
  3430.         $form = $this->createForm(SubcontractorStdType::class, $subcontractor);
  3432.         $form->handleRequest($request);
  3434.         if ($form->isSubmitted() && $form->isValid()) {
  3435.             $em = $this->getDoctrine()->getManager();
  3437.             $subcontractor->setEditDate(new \DateTime("now"));
  3439.             $em->flush();
  3441.             foreach ($subcontractor->getDocuments() as $document) {
  3442.                 if (isset($_POST["appbundle_subcontractor_documents_".$document->getId()]) && !empty($_POST["appbundle_subcontractor_documents_".$document->getId()])) {
  3443.                     if ($document->getName() != $_POST["appbundle_subcontractor_documents_".$document->getId()]) {
  3444.                         $document->setTitle($_POST["appbundle_subcontractor_documents_".$document->getId()]);
  3445.                         $em->flush();
  3446.                     }
  3447.                 }
  3448.             }
  3450.             if (isset($_FILES['appbundle_subcontractor_documents'])) {
  3451.                 $files = $_FILES['appbundle_subcontractor_documents'];
  3452.                 $fileNames = $_POST['appbundle_subcontractor_documents_names'];
  3453.                 for ($i=0;$i<count($files['name']);$i++) {
  3454.                     if ( is_uploaded_file( $files["tmp_name"][$i] ) && file_exists($files["tmp_name"][$i]) && $files["error"][$i] === 0) {
  3455.                         $name = $files["name"][$i];
  3456.                         $parts = explode(".", $name);
  3457.                         $extension = end($parts);
  3459.                         $fileName = $subcontractor->getId()."_".md5(uniqid()) . '.' . $extension;
  3461.                         move_uploaded_file($files["tmp_name"][$i], $this->getParameter('documents_directory') . $fileName);
  3463.                         $docTitle = (isset($fileNames[$i]) && !empty($fileNames[$i]))?$fileNames[$i]:$files["name"][$i];
  3464.                         $document = new SubcontractorStdDocument();
  3465.                         $document->setName($docTitle);
  3466.                         $document->setFilename($fileName);
  3467.                         $document->setUserFilename($files["name"][$i]);
  3468.                         $document->setManager($this->getUser()->getManager());
  3469.                         $document->setSubcontractorStd($subcontractor);
  3470.                         $em->persist($document);
  3471.                         $em->flush();
  3472.                     }
  3473.                 }
  3474.             }
  3476.             $this->get('session')->getFlashBag()->add('success', 'Sous-traitant standard mis à jour');
  3477.             return $this->redirectToRoute("manager_subcontractors");
  3478.         }
  3480.         return $this->render('manager/subcontractors_edit.html.twig', [
  3481.             "subcontractor" => $subcontractor,
  3482.             "form" => $form->createView()
  3483.         ]);
  3484.     }
  3486.     /**
  3487.      * @Route("/subcontractors/{id}/translate/{_locale}", name="subcontractors_translate")
  3488.      */
  3489.     public function subcontractorsTranslateAction(Request $request, SubcontractorStd $subcontractor)
  3490.     {
  3491.         $em = $this->getDoctrine()->getManager();
  3493.         $repository = $em->getRepository('Gedmo\Translatable\Entity\Translation');
  3494.         $translations = $repository->findTranslations($subcontractor);
  3496.         if (!isset($translations[$request->get("_locale")])) {
  3497.             return $this->redirectToRoute("manager_subcontractors_gen_translate", ["id" => $subcontractor->getId(), "_locale" => "fr", "locale" => $request->get("_locale")]);
  3498.         }
  3500.         $subcontractor = $em->find(SubcontractorStd::class, $request->get("id"));
  3502.         $form = $this->createForm(SubcontractorStdTranslateType::class, $subcontractor);
  3504.         $form->handleRequest($request);
  3506.         if ($form->isSubmitted() && $form->isValid()) {
  3507.             $em->persist($subcontractor);
  3508.             $em->flush();
  3510.             $this->get('session')->getFlashBag()->add('success', 'Traduction du sous-traitant standard mis à jour');
  3511.             return $this->redirectToRoute("manager_subcontractors");
  3512.         }
  3514.         return $this->render('manager/subcontractors_translate.html.twig', [
  3515.             "form" => $form->createView(),
  3516.             "subcontractor" => $subcontractor,
  3517.         ]);
  3518.     }
  3520.     /**
  3521.      * @Route("/subcontractors/{id}/gentranslate/{locale}_{_locale}", name="subcontractors_gen_translate")
  3522.      */
  3523.     public function subcontractorsGanTranslateAction(Request $request, SubcontractorStd $subcontractor, $locale, $_locale)
  3524.     {
  3525.         $em = $this->getDoctrine()->getManager();
  3527.         $repository = $em->getRepository('Gedmo\Translatable\Entity\Translation');
  3528.         $translations = $repository->findTranslations($subcontractor);
  3530.         if (!isset($translations[$locale])) {
  3531.             $repository
  3532.                 ->translate($subcontractor, 'type', $locale, $subcontractor->getType())
  3533.             ;
  3535.             $em->persist($subcontractor);
  3536.             $em->flush();
  3538.             return $this->redirectToRoute("manager_subcontractors_translate", ["id" => $subcontractor->getId(), "_locale" => $locale]);
  3539.         }
  3541.         return $this->redirectToRoute("manager_subcontractors");
  3542.     }
  3544.     /**
  3545.      * @Route("/subcontractors/{id}/delete", name="subcontractors_delete")
  3546.      */
  3547.     public function subcontractorsDeleteAction(Request $request, SubcontractorStd $subcontractor)
  3548.     {
  3549.         $em = $this->getDoctrine()->getManager();
  3551.         $em->remove($subcontractor);
  3552.         $em->flush();
  3554.         $this->get('session')->getFlashBag()->add('success', 'Sous-traitant standard supprimé');
  3555.         return $this->redirectToRoute("manager_subcontractors");
  3556.     }
  3558.     /**
  3559.      * @Route("/subcontractors/deletedoc/{subcontractor}/{document}", name="subcontractor_deletedoc")
  3560.      */
  3561.     public function subcontractorsDeleteDocAction(Request $request, SubcontractorStd $subcontractor, SubcontractorStdDocument $subcontractorStdDocument)
  3562.     {
  3563.         $em = $this->getDoctrine()->getManager();
  3565.         $em->remove($subcontractorStdDocument);
  3566.         $em->flush();
  3568.         $this->get('session')->getFlashBag()->add('success', 'Document supprimé');
  3570.         return $this->redirectToRoute('manager_subcontractors_edit', ['id' => $subcontractor->getId()]);
  3571.     }
  3573.     /**
  3574.      * @Route("/actions", name="actions")
  3575.      */
  3576.     public function actionsAction(Request $request)
  3577.     {
  3578.         $actions = $this->getDoctrine()->getRepository(ActionStd::class)->findBy([], ["name" => "ASC"]);
  3580.         return $this->render('manager/actions.html.twig', [
  3581.             "actions" => $actions
  3582.         ]);
  3583.     }
  3585.     /**
  3586.      * @Route("/actions/add", name="actions_add")
  3587.      */
  3588.     public function actionsAddAction(Request $request)
  3589.     {
  3590.         $action = new ActionStd();
  3592.         $form = $this->createForm(ActionStdType::class, $action)
  3593.             ->add('sheets', EntityType::class, [
  3594.                 'attr' => array(
  3595.                     'placeholder' => 'Annexer des fiches pratiques',
  3596.                 ),
  3597.                 'placeholder' => 'Annexer des fiches pratiques',
  3598.                 'label' => 'Annexer des fiches pratiques',
  3599.                 'expanded' => false,
  3600.                 'multiple' => true,
  3601.                 'required' => false,
  3602.                 'class' => Document::class,
  3603.                 'query_builder' => function (EntityRepository $er) {
  3604.                     return $er->createQueryBuilder('d')
  3605.                         ->leftJoin("d.type", "t")
  3606.                         ->leftJoin("t.parent", "pt")
  3607.                         ->where('t.id = 2')
  3608.                         ->orWhere('pt.id = 2')
  3609.                         ->addOrderBy("d.name", "ASC")
  3610.                         ->addOrderBy("d.filename", "ASC");
  3611.                 }
  3612.             ]);
  3614.         $form->handleRequest($request);
  3616.         if ($form->isSubmitted() && $form->isValid()) {
  3617.             $em = $this->getDoctrine()->getManager();
  3619.             $now = new \DateTime("now");
  3621.             $action->setDate($now);
  3622.             $action->setEditDate($now);
  3623.             $action->setManager($this->getUser()->getManager());
  3625.             $em->persist($action);
  3626.             $em->flush();
  3628.             if (isset($_FILES['appbundle_action_documents'])) {
  3629.                 $files = $_FILES['appbundle_action_documents'];
  3630.                 $fileNames = $_POST['appbundle_action_documents_names'];
  3631.                 for ($i=0;$i<count($files['name']);$i++) {
  3632.                     if ( is_uploaded_file( $files["tmp_name"][$i] ) && file_exists($files["tmp_name"][$i]) && $files["error"][$i] === 0) {
  3633.                         $name = $files["name"][$i];
  3634.                         $parts = explode(".", $name);
  3635.                         $extension = end($parts);
  3637.                         $fileName = $action->getId()."_".md5(uniqid()) . '.' . $extension;
  3639.                         move_uploaded_file($files["tmp_name"][$i], $this->getParameter('documents_directory') . $fileName);
  3641.                         $docTitle = (isset($fileNames[$i]) && !empty($fileNames[$i]))?$fileNames[$i]:$files["name"][$i];
  3642.                         $document = new ActionStdDocument();
  3643.                         $document->setName($docTitle);
  3644.                         $document->setFilename($fileName);
  3645.                         $document->setUserFilename($files["name"][$i]);
  3646.                         $document->setManager($this->getUser()->getManager());
  3647.                         $document->setActionStd($action);
  3648.                         $em->persist($document);
  3649.                         $em->flush();
  3650.                     }
  3651.                 }
  3652.             }
  3654.             $this->get('session')->getFlashBag()->add('success', 'Nouvelle action standard ajoutée');
  3655.             return $this->redirectToRoute("manager_actions");
  3656.         }
  3658.         return $this->render('manager/actions_add.html.twig', [
  3659.             "form" => $form->createView()
  3660.         ]);
  3661.     }
  3663.     /**
  3664.      * @Route("/actions/{id}/edit", name="actions_edit")
  3665.      */
  3666.     public function actionsEditAction(Request $request, ActionStd $action)
  3667.     {
  3668.         $form = $this->createForm(ActionStdType::class, $action)
  3669.             ->add('sheets', EntityType::class, [
  3670.                 'attr' => array(
  3671.                     'placeholder' => 'Annexer des fiches pratiques',
  3672.                 ),
  3673.                 'placeholder' => 'Annexer des fiches pratiques',
  3674.                 'label' => 'Annexer des fiches pratiques',
  3675.                 'expanded' => false,
  3676.                 'multiple' => true,
  3677.                 'required' => false,
  3678.                 'class' => Document::class,
  3679.                 'query_builder' => function (EntityRepository $er) {
  3680.                     return $er->createQueryBuilder('d')
  3681.                         ->leftJoin("d.type", "t")
  3682.                         ->leftJoin("t.parent", "pt")
  3683.                         ->where('t.id = 2')
  3684.                         ->orWhere('pt.id = 2')
  3685.                         ->addOrderBy("d.name", "ASC")
  3686.                         ->addOrderBy("d.filename", "ASC");
  3687.                 }
  3688.             ]);
  3690.         $form->handleRequest($request);
  3692.         if ($form->isSubmitted() && $form->isValid()) {
  3693.             $em = $this->getDoctrine()->getManager();
  3695.             $action->setEditDate(new \DateTime("now"));
  3697.             $em->flush();
  3699.             foreach ($action->getDocuments() as $document) {
  3700.                 if (isset($_POST["appbundle_action_documents_".$document->getId()]) && !empty($_POST["appbundle_action_documents_".$document->getId()])) {
  3701.                     if ($document->getName() != $_POST["appbundle_action_documents_".$document->getId()]) {
  3702.                         $document->setTitle($_POST["appbundle_action_documents_".$document->getId()]);
  3703.                         $em->flush();
  3704.                     }
  3705.                 }
  3706.             }
  3708.             if (isset($_FILES['appbundle_action_documents'])) {
  3709.                 $files = $_FILES['appbundle_action_documents'];
  3710.                 $fileNames = $_POST['appbundle_action_documents_names'];
  3711.                 for ($i=0;$i<count($files['name']);$i++) {
  3712.                     if ( is_uploaded_file( $files["tmp_name"][$i] ) && file_exists($files["tmp_name"][$i]) && $files["error"][$i] === 0) {
  3713.                         $name = $files["name"][$i];
  3714.                         $parts = explode(".", $name);
  3715.                         $extension = end($parts);
  3717.                         $fileName = $action->getId()."_".md5(uniqid()) . '.' . $extension;
  3719.                         move_uploaded_file($files["tmp_name"][$i], $this->getParameter('documents_directory') . $fileName);
  3721.                         $docTitle = (isset($fileNames[$i]) && !empty($fileNames[$i]))?$fileNames[$i]:$files["name"][$i];
  3722.                         $document = new ActionStdDocument();
  3723.                         $document->setName($docTitle);
  3724.                         $document->setFilename($fileName);
  3725.                         $document->setUserFilename($files["name"][$i]);
  3726.                         $document->setManager($this->getUser()->getManager());
  3727.                         $document->setActionStd($action);
  3728.                         $em->persist($document);
  3729.                         $em->flush();
  3730.                     }
  3731.                 }
  3732.             }
  3734.             $this->get('session')->getFlashBag()->add('success', 'Action standard mise à jour');
  3735.             return $this->redirectToRoute("manager_actions");
  3736.         }
  3738.         return $this->render('manager/actions_edit.html.twig', [
  3739.             "action" => $action,
  3740.             "form" => $form->createView()
  3741.         ]);
  3742.     }
  3744.     /**
  3745.      * @Route("/actions/{id}/translate/{_locale}", name="actions_translate")
  3746.      */
  3747.     public function actionsTranslateAction(Request $request, ActionStd $action)
  3748.     {
  3749.         $em = $this->getDoctrine()->getManager();
  3751.         $repository = $em->getRepository('Gedmo\Translatable\Entity\Translation');
  3752.         $translations = $repository->findTranslations($action);
  3754.         if (!isset($translations[$request->get("_locale")])) {
  3755.             return $this->redirectToRoute("manager_actions_gen_translate", ["id" => $action->getId(), "_locale" => "fr", "locale" => $request->get("_locale")]);
  3756.         }
  3758.         $action = $em->find(ActionStd::class, $request->get("id"));
  3760.         $form = $this->createForm(ActionStdTranslateType::class, $action);
  3762.         $form->handleRequest($request);
  3764.         if ($form->isSubmitted() && $form->isValid()) {
  3765.             $em->persist($action);
  3766.             $em->flush();
  3768.             $this->get('session')->getFlashBag()->add('success', 'Traduction de l\'action standard mise à jour');
  3769.             return $this->redirectToRoute("manager_actions");
  3770.         }
  3772.         return $this->render('manager/actions_translate.html.twig', [
  3773.             "form" => $form->createView(),
  3774.             "action" => $action,
  3775.         ]);
  3776.     }
  3778.     /**
  3779.      * @Route("/actions/{id}/gentranslate/{locale}_{_locale}", name="actions_gen_translate")
  3780.      */
  3781.     public function actionsGanTranslateAction(Request $request, ActionStd $action, $locale, $_locale)
  3782.     {
  3783.         $em = $this->getDoctrine()->getManager();
  3785.         $repository = $em->getRepository('Gedmo\Translatable\Entity\Translation');
  3786.         $translations = $repository->findTranslations($action);
  3788.         if (!isset($translations[$locale])) {
  3789.             $repository
  3790.                 ->translate($action, 'name', $locale, $action->getName())
  3791.                 ->translate($action, 'goal', $locale, $action->getGoal())
  3792.                 ->translate($action, 'information', $locale, $action->getInformation())
  3793.             ;
  3795.             $em->persist($action);
  3796.             $em->flush();
  3798.             return $this->redirectToRoute("manager_actions_translate", ["id" => $action->getId(), "_locale" => $locale]);
  3799.         }
  3801.         return $this->redirectToRoute("manager_actions");
  3802.     }
  3804.     /**
  3805.      * @Route("/actions/{id}/delete", name="actions_delete")
  3806.      */
  3807.     public function actionsDeleteAction(Request $request, ActionStd $action)
  3808.     {
  3809.         $em = $this->getDoctrine()->getManager();
  3811.         $em->remove($action);
  3812.         $em->flush();
  3814.         $this->get('session')->getFlashBag()->add('success', 'Action standard supprimée');
  3815.         return $this->redirectToRoute("manager_actions");
  3816.     }
  3818.     /**
  3819.      * @Route("/actions/deletedoc/{action}/{document}", name="actions_deletedoc")
  3820.      */
  3821.     public function actionsDeleteDocAction(Request $request, ActionStd $action, ActionStdDocument $actionStdDocument)
  3822.     {
  3823.         $em = $this->getDoctrine()->getManager();
  3825.         $em->remove($actionStdDocument);
  3826.         $em->flush();
  3828.         $this->get('session')->getFlashBag()->add('success', 'Document supprimé');
  3830.         return $this->redirectToRoute('manager_actions_edit', ['id' => $action->getId()]);
  3831.     }
  3833.     /**
  3834.      * @Route("/infos", name="infos")
  3835.      */
  3836.     public function infosAction(Request $request)
  3837.     {
  3838.         if (!$this->isGranted("ROLE_DPO")) {
  3839.             throw new NotFoundHttpException();
  3840.         }
  3842.         $infos = $this->getDoctrine()->getRepository(Info::class)->findAll();
  3844.         return $this->render('manager/infos.html.twig', [
  3845.             "infos" => $infos
  3846.         ]);
  3847.     }
  3849.     /**
  3850.      * @Route("/infos/add", name="infos_add")
  3851.      */
  3852.     public function infosAddAction(Request $request)
  3853.     {
  3854.         if (!$this->isGranted("ROLE_DPO")) {
  3855.             throw new NotFoundHttpException();
  3856.         }
  3858.         $info = new Info();
  3860.         $form = $this->createForm(InfoType::class, $info);
  3862.         $form->handleRequest($request);
  3864.         if ($form->isSubmitted() && $form->isValid()) {
  3865.             $em = $this->getDoctrine()->getManager();
  3867.             $em->persist($info);
  3869.             $em->flush();
  3871.             /**
  3872.              * @var UploadedFile $file
  3873.              */
  3874.             $file = $form->get('filePicture')->getData();
  3875.             if ($file != NULL) {
  3876.                 $fileName = $info->getId()."_".md5(uniqid()) . '.' . $file->guessExtension();
  3878.                 $file->move(
  3879.                     $this->getParameter('pictures_directory'), $fileName
  3880.                 );
  3882.                 $info->setPicture($fileName);
  3884.                 $em->flush();
  3885.             }
  3887.             $this->get('session')->getFlashBag()->add('success', 'Nouvelle info ajoutée');
  3888.             return $this->redirectToRoute("manager_infos");
  3889.         }
  3891.         return $this->render('manager/infos_add.html.twig', [
  3892.             "form" => $form->createView(),
  3893.         ]);
  3894.     }
  3896.     /**
  3897.      * @Route("/infos/{id}/edit", name="infos_edit")
  3898.      */
  3899.     public function infosEditAction(Request $request, Info $info)
  3900.     {
  3901.         if (!$this->isGranted("ROLE_DPO")) {
  3902.             throw new NotFoundHttpException();
  3903.         }
  3905.         $form = $this->createForm(InfoType::class, $info);
  3907.         $form->handleRequest($request);
  3909.         if ($form->isSubmitted() && $form->isValid()) {
  3910.             $em = $this->getDoctrine()->getManager();
  3912.             $em->flush();
  3914.             /**
  3915.              * @var UploadedFile $file
  3916.              */
  3917.             $file = $form->get('filePicture')->getData();
  3918.             if ($file != NULL) {
  3919.                 $fileName = $info->getId()."_".md5(uniqid()) . '.' . $file->guessExtension();
  3921.                 $file->move(
  3922.                     $this->getParameter('pictures_directory'), $fileName
  3923.                 );
  3925.                 $info->setPicture($fileName);
  3927.                 $em->flush();
  3928.             }
  3930.             $this->get('session')->getFlashBag()->add('success', 'Info mise à jour');
  3932.             return $this->redirectToRoute("manager_infos");
  3933.         }
  3935.         return $this->render('manager/infos_edit.html.twig', [
  3936.             "form" => $form->createView(),
  3937.             "info" => $info
  3938.         ]);
  3939.     }
  3941.     /**
  3942.      * @Route("/infos/{id}/delete", name="infos_delete")
  3943.      */
  3944.     public function infosDeleteAction(Request $request, Info $info)
  3945.     {
  3946.         if (!$this->isGranted("ROLE_DPO")) {
  3947.             throw new NotFoundHttpException();
  3948.         }
  3950.         $em = $this->getDoctrine()->getManager();
  3952.         $em->remove($info);
  3953.         $em->flush();
  3955.         $this->get('session')->getFlashBag()->add('success', 'Info supprimée');
  3956.         return $this->redirectToRoute("manager_infos");
  3957.     }
  3959.     /**
  3960.      * @Route("/loginlogs/{user}", name="login_logs")
  3961.      */
  3962.     public function loginLogsAction(Request $request, User $user)
  3963.     {
  3964.         $loginLogs = $this->getDoctrine()->getRepository(LoginLog::class)->findLast3Months($user);
  3966.         return $this->render('manager/login_logs.html.twig', [
  3967.             "loginLogs" => $loginLogs
  3968.         ]);
  3969.     }
  3971.     /**
  3972.      * @Route("/subscriptions", name="subscriptions")
  3973.      */
  3974.     public function subscriptionsAction(Request $request)
  3975.     {
  3976.         if (!$this->isGranted("ROLE_DPO")) {
  3977.             throw new NotFoundHttpException();
  3978.         }
  3980.         $subscriptions = $this->getDoctrine()->getRepository(Subscription::class)->findAll();
  3982.         return $this->render('manager/subscriptions.html.twig', [
  3983.             "subscriptions" => $subscriptions
  3984.         ]);
  3985.     }
  3987.     /**
  3988.      * @Route("/subscriptions/export", name="subscriptions_export")
  3989.      */
  3990.     public function subscriptionsExportAction(Request $request)
  3991.     {
  3992.         if (!$this->isGranted("ROLE_DPO")) {
  3993.             throw new NotFoundHttpException();
  3994.         }
  3996.         $now = new \DateTime("now");
  3998.         $users = $this->getDoctrine()->getRepository(User::class)->findBy([], ["companyName" => "ASC"]);
  4000.         $spreadsheet = new Spreadsheet();
  4001.         $spreadsheet->setActiveSheetIndex(0);
  4002.         $sheet = $spreadsheet->getActiveSheet();
  4004.         $sheet->setCellValue('A1', 'Société');
  4005.         $sheet->setCellValue('B1', 'Abonnement');
  4006.         $sheet->setCellValue('C1', 'Début');
  4007.         $sheet->setCellValue('D1', 'Fin');
  4008.         $sheet->setCellValue('E1', 'A facturer');
  4009.         $sheet->setCellValue('F1', 'Informations abonnement');
  4010.         $sheet->setCellValue('G1', 'Informations facturation');
  4011.         $sheet->setCellValue('H1', 'Echéance');
  4012.         $sheet->setCellValue('I1', 'Tarif');
  4014.         $i = 2;
  4015.         foreach ($users as $user) {
  4016.             $sheet->setCellValue('A'.$i, $user->getCompanyName());
  4017.             if ($user->getCurrentSubscription()) {
  4018.                 $subscription = $user->getCurrentSubscription();
  4019.                 $sheet->setCellValue('B'.$i, $subscription->getType()?$subscription->getType()->getLibelle():"-");
  4020.                 $sheet->setCellValue('C'.$i, $subscription->getBeginDate()?$subscription->getBeginDate()->format("d/m/Y"):"-");
  4021.                 $sheet->setCellValue('D'.$i, $subscription->getEndDate()?$subscription->getEndDate()->format("d/m/Y"):"-");
  4022.                 if ($subscription->isActive() && ($subscription->getPaymentUntil() == null || $subscription->getPaymentUntil() < $now)) {
  4023.                     $sheet->setCellValue('E'.$i, 'OUI');
  4024.                 } else {
  4025.                     $sheet->setCellValue('E'.$i, 'NON');
  4026.                 }
  4027.                 $sheet->setCellValue('F'.$i, $subscription->getOffer());
  4028.                 $sheet->setCellValue('G'.$i, $subscription->getBilling());
  4029.                 if ($subscription->getBillingMonths() == 12) {
  4030.                     $sheet->setCellValue('H'.$i, 'Annuelle');
  4031.                 } elseif ($subscription->getBillingMonths() == 3) {
  4032.                     $sheet->setCellValue('H'.$i, 'Trimestrielle');
  4033.                 } elseif ($subscription->getBillingMonths() == 1) {
  4034.                     $sheet->setCellValue('H'.$i, 'Mensuelle');
  4035.                 }
  4036.                 $sheet->setCellValue('I'.$i, $subscription->getUnitBillingPrice());
  4037.             }
  4039.             $i++;
  4040.         }
  4042.         $writer = new Xlsx($spreadsheet);
  4044.         $response = new StreamedResponse();
  4045.         $response->setCallback(function () use ($writer) {
  4046.             $writer->save('php://output');
  4047.         });
  4049.         $response->setStatusCode(200);
  4050.         $response->headers->set('Content-Type', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
  4051.         $response->headers->set('Content-Disposition', 'attachment;filename="export_abonnements.xlsx"');
  4052.         $response->headers->set('Cache-Control','max-age=0');
  4053.         return $response;
  4054.     }
  4056.     /**
  4057.      * @Route("/subscriptions/{id}", name="subscriptions_user")
  4058.      */
  4059.     public function subscriptionsUserAction(Request $request, User $user)
  4060.     {
  4061.         if (!$this->isGranted("ROLE_DPO")) {
  4062.             throw new NotFoundHttpException();
  4063.         }
  4065.         $form = $this->createFormBuilder()
  4066.             ->add("type", EntityType::class, [
  4067.                 'class' => \App\Entity\SubscriptionType::class,
  4068.                 'attr' => array(
  4069.                     'placeholder' => 'Type d\'abonnement',
  4070.                 ),
  4071.                 'label' => 'Type d\'abonnement',
  4072.                 'expanded' => false,
  4073.                 'multiple' => false,
  4074.                 'required' => true,
  4075.             ])
  4076.             ->getForm();
  4078.         $form->handleRequest($request);
  4080.         if ($form->isSubmitted() && $form->isValid()) {
  4081.             return $this->redirectToRoute("manager_subscriptions_user_add", ["user" => $user->getId(), "subscriptionType" => $form["type"]->getData()->getId()]);
  4082.         }
  4084.         $subscriptions = $this->getDoctrine()->getRepository(Subscription::class)->findBy(["user" => $user]);
  4086.         return $this->render('manager/subscriptions_user.html.twig', [
  4087.             "user" => $user,
  4088.             "subscriptions" => $subscriptions,
  4089.             "form" => $form->createView(),
  4090.             "now" => new \DateTime("now")
  4091.         ]);
  4092.     }
  4094.     /**
  4095.      * @Route("/subscriptions/{user}/add/{subscriptionType}", name="subscriptions_user_add")
  4096.      */
  4097.     public function subscriptionsUserAddAction(Request $request, User $user, \App\Entity\SubscriptionType $subscriptionType)
  4098.     {
  4099.         if (!$this->isGranted("ROLE_DPO")) {
  4100.             throw new NotFoundHttpException();
  4101.         }
  4103.         $hasBillingType = false;
  4104.         $hasBillingPrice = false;
  4106.         $subscription = new Subscription();
  4108.         $subscription->setUser($user);
  4109.         $subscription->setType($subscriptionType);
  4111.         $form = $this->createForm(SubscriptionUserType::class, $subscription);
  4113.         $form["subscriptionType"]->setData($subscriptionType->getLibelle());
  4115.         switch ($subscriptionType->getCode()) {
  4116.             case "ABOPLS":
  4117.             case "ABOSTD":
  4118.                 $form->add('billingType', ChoiceType::class, [
  4119.                         'attr' => [
  4120.                             'placeholder' => 'Type de facturation'
  4121.                         ],
  4122.                         'label' => 'Type de facturation',
  4123.                         'choices' => [
  4124.                             "Au mois" => "m",
  4125.                             "Au trimestre" => "t",
  4126.                             "A l'année" => "y",
  4127.                         ],
  4128.                         "data" => "y",
  4129.                         'required' => true,
  4130.                         'mapped' => false
  4131.                     ])
  4132.                     ->add('unitBillingPrice', NumberType::class, [
  4133.                         'attr' => [
  4134.                             'placeholder' => 'Montant HT facturé'
  4135.                         ],
  4136.                         'label' => 'Montant HT facturé (selon type de facturation)',
  4137.                         'data' => 0
  4138.                     ]);
  4139.                 $hasBillingType = true;
  4140.                 $hasBillingPrice = true;
  4141.                 break;
  4142.             case "ABOLIB":
  4143.                 $form->add('unitBillingPrice', NumberType::class, [
  4144.                         'attr' => [
  4145.                             'placeholder' => 'Montant HT facturé'
  4146.                         ],
  4147.                         'label' => 'Montant HT facturé au mois',
  4148.                         'data' => 0
  4149.                     ]);
  4150.                 $hasBillingPrice = true;
  4151.                 break;
  4152.         }
  4154.         $form->handleRequest($request);
  4156.         if ($form->isSubmitted() && $form->isValid()) {
  4157.             $em = $this->getDoctrine()->getManager();
  4159.             $now = new \DateTime("now");
  4161.             $subscription->setCreationDate($now);
  4163.             if ($form['beginDate']->getData()) {
  4164.                 $beginDate = \DateTime::createFromFormat("d/m/Y", $form['beginDate']->getData());
  4165.                 if ($beginDate) {
  4166.                     $beginDate->setTime(0, 0, 0);
  4167.                     $subscription->setBeginDate($beginDate);
  4168.                     $endDate = clone $subscription->getBeginDate();
  4169.                     $endDate->sub(new \DateInterval("P1D"));
  4171.                     switch ($subscriptionType->getCode()) {
  4172.                         case "ABOPLS":
  4173.                         case "ABOSTD":
  4174.                             $subscription->setInvolvementMonths(12);
  4175.                             $endDate->add(new \DateInterval("P1Y"));
  4176.                             break;
  4177.                         case "PARTEN":
  4178.                             $subscription->setInvolvementMonths(12);
  4179.                             $endDate->add(new \DateInterval("P1Y"));
  4180.                             break;
  4181.                         case "ABOLIB":
  4182.                             $subscription->setInvolvementMonths(1);
  4183.                             $endDate->add(new \DateInterval("P1M"));
  4184.                             break;
  4185.                         case "FREE30D":
  4186.                         case "DEMO":
  4187.                             $subscription->setInvolvementMonths(0);
  4188.                             $endDate->add(new \DateInterval("P30D"));
  4189.                             break;
  4190.                     }
  4192.                     $subscription->setEndDate($endDate);
  4194.                     if ($hasBillingType) {
  4195.                         if ($form['billingType']->getData() == "m") {
  4196.                             $subscription->setBillingMonths(1);
  4197.                         } elseif ($form['billingType']->getData() == "t") {
  4198.                             $subscription->setBillingMonths(3);
  4199.                         } else {
  4200.                             $subscription->setBillingMonths(12);
  4201.                         }
  4202.                     } else {
  4203.                         $subscription->setBillingMonths(0);
  4204.                     }
  4206.                     if (!$hasBillingPrice) {
  4207.                         $subscription->setUnitBillingPrice(0);
  4208.                     }
  4210.                     $subscription->setActive(true);
  4212.                     $em->persist($subscription);
  4213.                     $em->flush();
  4215.                     if ($user->getCurrentSubscription()) {
  4216.                         $user->getCurrentSubscription()->setActive(false);
  4217.                         $em->flush();
  4218.                     }
  4219.                     $user->setCurrentSubscription($subscription);
  4220.                     $em->flush();
  4222.                     if ($user->getCurrentSubscription()->getUnitBillingPrice() == 0) {
  4223.                         switch ($user->getCurrentSubscription()->getType()->getCode()) {
  4224.                             case "ABOPLS":
  4225.                             case "ABOSTD":
  4226.                             case "PARTEN":
  4227.                             case "ABOLIB":
  4228.                                 $paymentUntil = clone $user->getCurrentSubscription()->getBeginDate();
  4229.                                 $paymentUntil->sub(new \DateInterval("P1D"));
  4231.                                 if ($user->getCurrentSubscription()->getBillingMonths()) {
  4232.                                     $paymentUntil->add(new \DateInterval("P".$user->getCurrentSubscription()->getBillingMonths()."M"));
  4233.                                 } else {
  4234.                                     $paymentUntil->add(new \DateInterval("P".$user->getCurrentSubscription()->getInvolvementMonths()."M"));
  4235.                                 }
  4237.                                 $user->getCurrentSubscription()->setPaymentUntil($paymentUntil);
  4238.                                 $em->flush();
  4240.                                 break;
  4241.                         }
  4242.                     }
  4244.                     $this->get('session')->getFlashBag()->add('success', 'Nouvel abonnement ajouté');
  4245.                     return $this->redirectToRoute("manager_subscriptions_user", ["id" => $user->getId()]);
  4246.                 }
  4247.             }
  4248.         }
  4250.         return $this->render('manager/subscriptions_user_add.html.twig', [
  4251.             "form" => $form->createView(),
  4252.             "hasBillingType" => $hasBillingType,
  4253.             "hasBillingPrice" => $hasBillingPrice,
  4254.         ]);
  4255.     }
  4257.     /**
  4258.      * @Route("/subscriptions/{user}/disable/{subscription}", name="subscriptions_user_disable")
  4259.      */
  4260.     public function subscriptionsUserDisableAction(Request $request, User $user, Subscription $subscription)
  4261.     {
  4262.         if (!$this->isGranted("ROLE_DPO")) {
  4263.             throw new NotFoundHttpException();
  4264.         }
  4266.         $em = $this->getDoctrine()->getManager();
  4268.         $subscription->setActive(false);
  4269.         $subscription->setEndDate(new \DateTime("now"));
  4271.         $em->flush();
  4273.         return $this->redirectToRoute("manager_subscriptions_user", ["id" => $user->getId()]);
  4274.     }
  4276.     /**
  4277.      * @Route("/subscriptions/{user}/payment/{subscription}", name="subscriptions_user_payment")
  4278.      */
  4279.     public function subscriptionsUserPaymentAction(Request $request, User $user, Subscription $subscription)
  4280.     {
  4281.         if (!$this->isGranted("ROLE_DPO")) {
  4282.             throw new NotFoundHttpException();
  4283.         }
  4285.         $em = $this->getDoctrine()->getManager();
  4287.         if ($subscription->getPaymentUntil() == null) {
  4288.             $subscription->setPaymentUntil($subscription->getEndDate());
  4289.             switch ($subscription->getType()->getCode()) {
  4290.                 case "ABOPLS":
  4291.                 case "ABOSTD":
  4292.                 case "PARTEN":
  4293.                     $subscription->getPaymentUntil()->sub(new \DateInterval("P1Y"));
  4294.                     break;
  4295.                 case "ABOLIB":
  4296.                     $subscription->getPaymentUntil()->sub(new \DateInterval("P1M"));
  4297.                     break;
  4298.             }
  4299.         }
  4301.         $paymentUntil = clone $subscription->getPaymentUntil();
  4303.         if ($subscription->getBillingMonths()) {
  4304.             $paymentUntil->add(new \DateInterval("P".$subscription->getBillingMonths()."M"));
  4305.         } else {
  4306.             $paymentUntil->add(new \DateInterval("P".$subscription->getInvolvementMonths()."M"));
  4307.         }
  4309.         $subscription->setPaymentUntil($paymentUntil);
  4310.         //$subscription->setEndDate($paymentUntil);
  4312.         $em->flush();
  4314.         return $this->redirectToRoute("manager_subscriptions_user", ["id" => $user->getId()]);
  4315.     }
  4317.     /**
  4318.      * @Route("/subscriptions/add", name="subscriptions_add")
  4319.      */
  4320.     public function subscriptionsAddAction(Request $request)
  4321.     {
  4322.         if (!$this->isGranted("ROLE_DPO")) {
  4323.             throw new NotFoundHttpException();
  4324.         }
  4326.         $subscription = new Subscription();
  4328.         $form = $this->createForm(SubscriptionType::class, $subscription);
  4330.         $form->handleRequest($request);
  4332.         if ($form->isSubmitted() && $form->isValid()) {
  4333.             $em = $this->getDoctrine()->getManager();
  4335.             $now = new \DateTime("now");
  4337.             $subscription->setCreationDate($now);
  4338.             $endDate = clone $subscription->getBeginDate();
  4339.             $endDate->sub(new \DateInterval("P1D"));
  4340.             if ($form['billingType']->getData() == "m") {
  4341.                 $endDate->add(new \DateInterval("P1M"));
  4342.             } else {
  4343.                 $endDate->add(new \DateInterval("P12M"));
  4344.             }
  4345.             $subscription->setEndDate($endDate);
  4347.             $em->persist($subscription);
  4348.             $em->flush();
  4350.             $this->get('session')->getFlashBag()->add('success', 'Nouvel abonnement ajouté');
  4351.             return $this->redirectToRoute("manager_subscriptions");
  4352.         }
  4354.         return $this->render('manager/subscriptions_add.html.twig', [
  4355.             "form" => $form->createView(),
  4356.         ]);
  4357.     }
  4359.     /**
  4360.      * @Route("/subscriptions/{id}/edit", name="subscriptions_edit")
  4361.      */
  4362.     public function subscriptionsEditAction(Request $request, Subscription $subscription)
  4363.     {
  4364.         if (!$this->isGranted("ROLE_DPO")) {
  4365.             throw new NotFoundHttpException();
  4366.         }
  4368.         $form = $this->createForm(SubscriptionType::class, $subscription);
  4370.         if ($subscription->getBeginDate()->format('Y') != $subscription->getEndDate()->format('Y')) {
  4371.             $form['billingType']->setData('y');
  4372.         } else {
  4373.             $form['billingType']->setData('m');
  4374.         }
  4376.         $form->handleRequest($request);
  4378.         if ($form->isSubmitted() && $form->isValid()) {
  4379.             $em = $this->getDoctrine()->getManager();
  4381.             $endDate = clone $subscription->getBeginDate();
  4382.             $endDate->sub(new \DateInterval("P1D"));
  4383.             if ($form['billingType']->getData() == "m") {
  4384.                 $endDate->add(new \DateInterval("P1M"));
  4385.             } else {
  4386.                 $endDate->add(new \DateInterval("P12M"));
  4387.             }
  4388.             $subscription->setEndDate($endDate);
  4390.             $em->flush();
  4392.             $this->get('session')->getFlashBag()->add('success', 'Abonnement modifié');
  4393.             return $this->redirectToRoute("manager_subscriptions");
  4394.         }
  4396.         return $this->render('manager/subscriptions_edit.html.twig', [
  4397.             "form" => $form->createView(),
  4398.         ]);
  4399.     }
  4401.     /**
  4402.      * @Route("/subscriptions/{id}/delete", name="subscriptions_delete")
  4403.      */
  4404.     public function subscriptionsDeleteAction(Request $request, Subscription $subscription)
  4405.     {
  4406.         if (!$this->isGranted("ROLE_DPO")) {
  4407.             throw new NotFoundHttpException();
  4408.         }
  4410.         $em = $this->getDoctrine()->getManager();
  4412.         $em->remove($subscription);
  4413.         $em->flush();
  4415.         return $this->redirectToRoute("manager_subscriptions");
  4416.     }
  4418.     /**
  4419.      * @Route("/credits/{id}", name="credits_user")
  4420.      */
  4421.     public function creditsUserAction(Request $request, User $user)
  4422.     {
  4423.         if (!$this->isGranted("ROLE_MANAGER")) {
  4424.             throw new NotFoundHttpException();
  4425.         }
  4427.         $credit = new Credit();
  4429.         $form = $this->createFormBuilder($credit)
  4430.             ->add("title", TextType::class, [
  4431.                 'attr' => array(
  4432.                     'placeholder' => 'Action',
  4433.                 ),
  4434.                 'label' => 'Action',
  4435.                 'required' => true,
  4436.             ])
  4437.             ->add("stock", NumberType::class, [
  4438.                 'attr' => array(
  4439.                     'placeholder' => 'Stock',
  4440.                 ),
  4441.                 'label' => 'Stock',
  4442.                 'required' => true,
  4443.             ])
  4444.             ->getForm();
  4446.         $form->handleRequest($request);
  4448.         if ($form->isSubmitted() && $form->isValid()) {
  4449.             $em = $this->getDoctrine()->getManager();
  4451.             $credit->convertToDecimal(true);
  4453.             $credit->setUser($user);
  4454.             $credit->setManager($this->getUser()->getManager());
  4455.             $credit->setCreationDate(new \DateTime("now"));
  4457.             $em->persist($credit);
  4458.             $em->flush();
  4460.             $user->setCredit($user->getCredit() + $credit->getStock());
  4462.             $em->flush();
  4464.             $this->get('session')->getFlashBag()->add('success', 'Crédits modifiés');
  4466.             return $this->redirectToRoute("manager_credits_user", ["id" => $user->getId()]);
  4467.         }
  4469.         $credits = $this->getDoctrine()->getRepository(Credit::class)->findBy(["user" => $user]);
  4471.         return $this->render('manager/credits_user.html.twig', [
  4472.             "user" => $user,
  4473.             "credits" => $credits,
  4474.             "form" => $form->createView()
  4475.         ]);
  4476.     }
  4478.     /**
  4479.      * @Route("/trainings", name="trainings")
  4480.      */
  4481.     public function trainingsAction(Request $request)
  4482.     {
  4483.         $trainings = $this->getDoctrine()->getRepository(Training::class)->findAll();
  4485.         return $this->render('manager/trainings.html.twig', [
  4486.             "trainings" => $trainings
  4487.         ]);
  4488.     }
  4490.     /**
  4491.      * @Route("/trainings/stats", name="trainings_requests_stats")
  4492.      */
  4493.     public function trainingsStatsAction(Request $request)
  4494.     {
  4495.         $training = $this->getDoctrine()->getRepository(Training::class)->findOneBy(["id" => $request->get("training")]);
  4497.         if (!$training) {
  4498.             return new JsonResponse([
  4499.                 "success" => false
  4500.             ]);
  4501.         }
  4503.         $questionsChoices = [];
  4504.         $questionsChoicesTotal = [];
  4505.         $questionsCount = [];
  4507.         foreach ($training->getQuestions() as $questionKey => $question) {
  4508.             $questionsChoices[$questionKey] = $question["choices"];
  4509.             $questionsCount[$questionKey] = 0;
  4511.             $questionsChoicesTotal[$questionKey] = [];
  4512.             foreach ($question["choices"] as $choiceKey => $choice) {
  4513.                 $questionsChoicesTotal[$questionKey][$choiceKey] = 0;
  4514.             }
  4515.         }
  4517.         $trainingRequests = $this->getDoctrine()->getRepository(TrainingRequest::class)->findForTraining($training);
  4519.         foreach ($trainingRequests as $trainingRequest) {
  4520.             if ($trainingRequest->getAnswerDate()) {
  4521.                 foreach ($training->getQuestions() as $key => $item) {
  4522.                     if (isset($questionsChoices[$key])) {
  4523.                         if ($item["choices"] == $questionsChoices[$key]) {
  4524.                             if (isset($trainingRequest->getUserAnswers()[$key])) {
  4525.                                 $questionsCount[$key] = $questionsCount[$key]+1;
  4526.                                 foreach ($item["choices"] as $choiceKey => $choice) {
  4527.                                     if ($item["multiple"]) {
  4528.                                         if (in_array($choiceKey, $trainingRequest->getUserAnswers()[$key])) {
  4529.                                             $questionsChoicesTotal[$key][$choiceKey] = $questionsChoicesTotal[$key][$choiceKey]+1;
  4530.                                         }
  4531.                                     } else {
  4532.                                         if ($choiceKey == $trainingRequest->getUserAnswers()[$key]) {
  4533.                                             $questionsChoicesTotal[$key][$choiceKey] = $questionsChoicesTotal[$key][$choiceKey]+1;
  4534.                                         }
  4535.                                     }
  4536.                                 }
  4537.                             }
  4538.                         }
  4539.                     }
  4540.                 }
  4541.             }
  4542.         }
  4544.         return new JsonResponse([
  4545.             "success" => true,
  4546.             "html" => $this->renderView('manager/includes/training_stats.html.twig', [
  4547.                 "training" => $training,
  4548.                 "questionsChoices" => $questionsChoices,
  4549.                 "questionsChoicesTotal" => $questionsChoicesTotal,
  4550.                 "questionsCount" => $questionsCount,
  4551.             ])
  4552.         ]);
  4553.     }
  4555.     /**
  4556.      * @Route("/trainings/add", name="trainings_add")
  4557.      */
  4558.     public function trainingsAddAction(Request $request)
  4559.     {
  4560.         $training = new Training();
  4562.         $form = $this->createForm(TrainingType::class, $training)
  4563.             ->add('users', EntityType::class, [
  4564.                 'attr' => array(
  4565.                     'placeholder' => 'Clients',
  4566.                 ),
  4567.                 'placeholder' => 'Clients',
  4568.                 'label' => 'Clients',
  4569.                 'expanded' => true,
  4570.                 'multiple' => true,
  4571.                 'required' => false,
  4572.                 'class' => User::class,
  4573.                 'query_builder' => function (EntityRepository $er) {
  4574.                     return $er->createQueryBuilder('u')
  4575.                         ->addOrderBy('u.companyName', "ASC");
  4576.                 },
  4577.                 'choice_label' => function(User $user) {
  4578.                     return $user->getCompanyName();
  4579.                 },
  4580.             ]);
  4582.         $form->handleRequest($request);
  4584.         if ($form->isSubmitted() && $form->isValid()) {
  4585.             $em = $this->getDoctrine()->getManager();
  4587.             $em->persist($training);
  4589.             $training->setAnswered(false);
  4591.             $content = [];
  4593.             $questions = $_POST['form_items']??[];
  4594.             $questions = array_values($questions);
  4596.             if (count($questions)) {
  4597.                 foreach ($questions as $question) {
  4598.                     $content[] = [
  4599.                         'title' => $question[0]??null,
  4600.                         'choices' => explode("\n", str_replace("\r", "", $question[1]??null)),
  4601.                         'multiple' => $question[2]==1?true:false,
  4602.                         'links' => explode("\n", str_replace("\r", "", $question[3]??null)),
  4603.                         'explanations' => $question[4]??null,
  4604.                     ];
  4605.                 }
  4606.             }
  4608.             $training->setQuestions($content);
  4610.             $em->flush();
  4612.             /**
  4613.              * @var UploadedFile $file
  4614.              */
  4615.             $file = $form->get('pictureFile')->getData();
  4616.             if ($file != NULL) {
  4617.                 $fileName = "t".$training->getId()."_".md5(uniqid()) . '.' . $file->guessExtension();
  4619.                 $file->move(
  4620.                     $this->getParameter('pictures_directory'), $fileName
  4621.                 );
  4623.                 $training->setPicture($fileName);
  4625.                 $em->flush();
  4626.             }
  4628.             $this->get('session')->getFlashBag()->add('success', 'Nouveau questionnaire créé');
  4629.             return $this->redirectToRoute("manager_trainings");
  4630.         }
  4632.         $users = [];
  4633.         $usersStr = [];
  4635.         foreach ($training->getUsers() as $user) {
  4636.             $users[] = $user->getId();
  4637.             $usersStr[] = $user->getCompanyName();
  4638.         }
  4640.         sort($usersStr);
  4642.         return $this->render('manager/trainings_add.html.twig', [
  4643.             "form" => $form->createView(),
  4644.             "users" => $users,
  4645.             "usersStr" => $usersStr,
  4646.         ]);
  4647.     }
  4649.     /**
  4650.      * @Route("/trainings/{id}/edit", name="trainings_edit")
  4651.      */
  4652.     public function trainingsEditAction(Request $request, Training $training)
  4653.     {
  4654.         $form = $this->createForm(TrainingType::class, $training)
  4655.             ->add('users', EntityType::class, [
  4656.                 'attr' => array(
  4657.                     'placeholder' => 'Clients',
  4658.                 ),
  4659.                 'placeholder' => 'Clients',
  4660.                 'label' => 'Clients',
  4661.                 'expanded' => true,
  4662.                 'multiple' => true,
  4663.                 'required' => false,
  4664.                 'class' => User::class,
  4665.                 'query_builder' => function (EntityRepository $er) {
  4666.                     return $er->createQueryBuilder('u')
  4667.                         ->addOrderBy('u.companyName', "ASC");
  4668.                 },
  4669.                 'choice_label' => function(User $user) {
  4670.                     return $user->getCompanyName();
  4671.                 },
  4672.             ]);
  4674.         $form->handleRequest($request);
  4676.         if ($form->isSubmitted() && $form->isValid()) {
  4677.             $em = $this->getDoctrine()->getManager();
  4679.             $content = $training->getQuestions();
  4681.             $questions_edit = $_POST['form_e_items']??[];
  4682.             $questions_edit = array_values($questions_edit);
  4684.             foreach ($content as $keyItem => $question) {
  4685.                 $toRemove = true;
  4686.                 if (count($questions_edit)) {
  4687.                     if (isset($questions_edit[$keyItem])) {
  4688.                         $content[$keyItem]['title'] = $questions_edit[$keyItem][0]??null;
  4689.                         $content[$keyItem]['choices'] = explode("\n", str_replace("\r", "", $questions_edit[$keyItem][1]??null));
  4690.                         $content[$keyItem]['multiple'] = $questions_edit[$keyItem][2]==1?true:false;
  4691.                         $content[$keyItem]['links'] = explode("\n", str_replace("\r", "", $questions_edit[$keyItem][3]??null));
  4692.                         $content[$keyItem]['explanations'] = $questions_edit[$keyItem][4]??null;
  4694.                         if (count($content[$keyItem]['links']) == 1) {
  4695.                             if ($content[$keyItem]['links'][0] == "") {
  4696.                                 $content[$keyItem]['links'] = [];
  4697.                             }
  4698.                         }
  4700.                         $toRemove = false;
  4701.                     }
  4702.                 }
  4704.                 if ($toRemove) {
  4705.                     unset($content[$keyItem]);
  4706.                 }
  4707.             }
  4709.             $questions = $_POST['form_items']??[];
  4710.             $questions = array_values($questions);
  4712.             if (count($questions)) {
  4713.                 foreach ($questions as $question) {
  4714.                     $content[] = [
  4715.                         'title' => $question[0]??null,
  4716.                         'choices' => explode("\n", str_replace("\r", "", $question[1]??null)),
  4717.                         'multiple' => $question[2]==1?true:false,
  4718.                         'links' => explode("\n", str_replace("\r", "", $question[3]??null)),
  4719.                         'explanations' => $question[4]??null,
  4720.                     ];
  4721.                 }
  4722.             }
  4724.             if ($training->getQuestions() != $content) {
  4725.                 $training->setAnswered(false);
  4726.             }
  4728.             $training->setQuestions($content);
  4730.             $em->flush();
  4732.             /**
  4733.              * @var UploadedFile $file
  4734.              */
  4735.             $file = $form->get('pictureFile')->getData();
  4736.             if ($file != NULL) {
  4737.                 $fileName = "t".$training->getId()."_".md5(uniqid()) . '.' . $file->guessExtension();
  4739.                 $file->move(
  4740.                     $this->getParameter('pictures_directory'), $fileName
  4741.                 );
  4743.                 $training->setPicture($fileName);
  4745.                 $em->flush();
  4746.             }
  4748.             $this->get('session')->getFlashBag()->add('success', 'Questionnaire mis à jour');
  4749.             return $this->redirectToRoute("manager_trainings");
  4750.         }
  4752.         $users = [];
  4753.         $usersStr = [];
  4755.         foreach ($training->getUsers() as $user) {
  4756.             $users[] = $user->getId();
  4757.             $usersStr[] = $user->getCompanyName();
  4758.         }
  4760.         sort($usersStr);
  4762.         return $this->render('manager/trainings_edit.html.twig', [
  4763.             "form" => $form->createView(),
  4764.             "training" => $training,
  4765.             "users" => $users,
  4766.             "usersStr" => $usersStr,
  4767.         ]);
  4768.     }
  4770.     /**
  4771.      * @Route("/trainings/{id}/answer", name="trainings_answer")
  4772.      */
  4773.     public function trainingsAnswerAction(Request $request, Training $training)
  4774.     {
  4775.         $form = $this->createFormBuilder();
  4777.         foreach ($training->getQuestions() as $key => $question) {
  4778.             $choices = [];
  4779.             foreach ($question["choices"] as $choiceKey => $choiceValue) {
  4780.                 $choices[$choiceValue] = $choiceKey;
  4781.             }
  4783.             $answerData = $training->getAnswers()[$key]??null;
  4784.             if ($question["multiple"]) {
  4785.                 if ($answerData != null) {
  4786.                     if (!is_array($answerData)) {
  4787.                         $answerData = [$answerData];
  4788.                     }
  4789.                 } else {
  4790.                     $answerData = [];
  4791.                 }
  4792.             } else {
  4793.                 if (is_array($answerData)) {
  4794.                     $answerData = $answerData[0];
  4795.                 }
  4796.             }
  4798.             $form->add("question_".$key, ChoiceType::class, [
  4799.                 "choices" => $choices,
  4800.                 "expanded" => true,
  4801.                 "multiple" => $question["multiple"],
  4802.                 "data" => $answerData
  4803.             ]);
  4804.         }
  4806.         $form = $form->getForm();
  4808.         $form->handleRequest($request);
  4810.         if ($form->isSubmitted() && $form->isValid()) {
  4811.             $em = $this->getDoctrine()->getManager();
  4813.             $training->setAnswered(true);
  4815.             $answers = [];
  4817.             foreach ($training->getQuestions() as $key => $question) {
  4818.                 $answers[$key] = $form["question_".$key]->getData();
  4819.             }
  4821.             $training->setAnswers($answers);
  4823.             $em->flush();
  4825.             $this->get('session')->getFlashBag()->add('success', 'Questionnaire répondu');
  4826.             return $this->redirectToRoute("manager_trainings");
  4827.         }
  4829.         return $this->render('manager/trainings_answer.html.twig', [
  4830.             "form" => $form->createView(),
  4831.             "training" => $training
  4832.         ]);
  4833.     }
  4835.     /**
  4836.      * @Route("/trainings/{id}/translate/{_locale}", name="trainings_translate")
  4837.      */
  4838.     public function trainingsTranslateAction(Request $request, Training $training)
  4839.     {
  4840.         $em = $this->getDoctrine()->getManager();
  4842.         $repository = $em->getRepository('Gedmo\Translatable\Entity\Translation');
  4843.         $translations = $repository->findTranslations($training);
  4845.         if (!isset($translations[$request->get("_locale")])) {
  4846.             return $this->redirectToRoute("manager_trainings_gen_translate", ["id" => $training->getId(), "_locale" => "fr", "locale" => $request->get("_locale")]);
  4847.         }
  4849.         $training = $em->find(Training::class, $request->get("id"));
  4851.         $form = $this->createForm(TrainingTranslateType::class, $training);
  4853.         $form->handleRequest($request);
  4855.         if ($form->isSubmitted() && $form->isValid()) {
  4856.             $content = $training->getQuestions();
  4858.             $questions_edit = $_POST['form_e_items']??[];
  4859.             $questions_edit = array_values($questions_edit);
  4861.             foreach ($content as $keyItem => $question) {
  4862.                 if (count($questions_edit)) {
  4863.                     if (isset($questions_edit[$keyItem])) {
  4864.                         $content[$keyItem]['title'] = $questions_edit[$keyItem][0]??null;
  4865.                         $content[$keyItem]['choices'] = explode("\n", str_replace("\r", "", $questions_edit[$keyItem][1]??null));
  4866.                         $content[$keyItem]['links'] = explode("\n", str_replace("\r", "", $questions_edit[$keyItem][3]??null));
  4867.                         $content[$keyItem]['explanations'] = $questions_edit[$keyItem][4]??null;
  4869.                         if (count($content[$keyItem]['links']) == 1) {
  4870.                             if ($content[$keyItem]['links'][0] == "") {
  4871.                                 $content[$keyItem]['links'] = [];
  4872.                             }
  4873.                         }
  4874.                     }
  4875.                 }
  4876.             }
  4878.             $training->setQuestions($content);
  4880.             $em->persist($training);
  4881.             $em->flush();
  4883.             $this->get('session')->getFlashBag()->add('success', 'Traduction du questionnaire mis à jour');
  4884.             return $this->redirectToRoute("manager_trainings");
  4885.         }
  4887.         return $this->render('manager/trainings_translate.html.twig', [
  4888.             "form" => $form->createView(),
  4889.             "training" => $training,
  4890.         ]);
  4891.     }
  4893.     /**
  4894.      * @Route("/trainings/{id}/gentranslate/{locale}_{_locale}", name="trainings_gen_translate")
  4895.      */
  4896.     public function trainingsGanTranslateAction(Request $request, Training $training, $locale, $_locale)
  4897.     {
  4898.         $em = $this->getDoctrine()->getManager();
  4900.         $repository = $em->getRepository('Gedmo\Translatable\Entity\Translation');
  4901.         $translations = $repository->findTranslations($training);
  4903.         if (!isset($translations[$locale])) {
  4904.             $repository
  4905.                 ->translate($training, 'title', $locale, $training->getTitle())
  4906.                 ->translate($training, 'questions', $locale, $training->getQuestions())
  4907.             ;
  4909.             $em->persist($training);
  4910.             $em->flush();
  4912.             return $this->redirectToRoute("manager_trainings_translate", ["id" => $training->getId(), "_locale" => $locale]);
  4913.         }
  4915.         return $this->redirectToRoute("manager_trainings");
  4916.     }
  4918.     /**
  4919.      * @Route("/trainings/{id}/delete", name="trainings_delete")
  4920.      */
  4921.     public function trainingsDeleteAction(Request $request, Training $training)
  4922.     {
  4923.         $em = $this->getDoctrine()->getManager();
  4925.         $em->remove($training);
  4926.         $em->flush();
  4928.         $this->get('session')->getFlashBag()->add('success', 'Questionnaire supprimé');
  4929.         return $this->redirectToRoute("manager_trainings");
  4930.     }
  4932.     /**
  4933.      * @Route("/treatments/gentranslations/{locale}", name="treatments_gen_translations")
  4934.      */
  4935.     public function treatmentsGanTranslationsAction(Request $request, $locale)
  4936.     {
  4937.         $em = $this->getDoctrine()->getManager();
  4939.         $treatments = $em->getRepository(TreatmentStd::class)->findBy(["user" => null]);
  4941.         foreach ($treatments as $treatment) {
  4942.             $repository = $em->getRepository('Gedmo\Translatable\Entity\Translation');
  4943.             $translations = $repository->findTranslations($treatment);
  4945.             if (!isset($translations[$locale])) {
  4946.                 $repository
  4947.                     ->translate($treatment, 'name', 'en', $treatment->getName())
  4948.                     ->translate($treatment, 'mainPurpose', 'en', $treatment->getMainPurpose())
  4949.                     ->translate($treatment, 'purpose1', 'en', $treatment->getPurpose1())
  4950.                     ->translate($treatment, 'purpose2', 'en', $treatment->getPurpose2())
  4951.                     ->translate($treatment, 'purpose3', 'en', $treatment->getPurpose3())
  4952.                     ->translate($treatment, 'purpose4', 'en', $treatment->getPurpose4())
  4953.                     ->translate($treatment, 'purpose5', 'en', $treatment->getPurpose5())
  4954.                     ->translate($treatment, 'othersPurpose', 'en', $treatment->getOthersPurpose())
  4955.                     ->translate($treatment, 'description', 'en', $treatment->getDescription())
  4956.                     ->translate($treatment, 'personalData', 'en', $treatment->getPersonalData())
  4957.                     ->translate($treatment, 'peopleData', 'en', $treatment->getPeopleData())
  4958.                     ->translate($treatment, 'transferOutsideUeCountries', 'en', $treatment->getTransferOutsideUeCountries())
  4959.                     ->translate($treatment, 'consentHow', 'en', $treatment->getConsentHow())
  4960.                     ->translate($treatment, 'legalBasis', 'en', $treatment->getLegalBasis())
  4961.                     ->translate($treatment, 'dataSource', 'en', $treatment->getDataSource())
  4962.                 ;
  4964.                 $em->persist($treatment);
  4965.                 $em->flush();
  4966.             }
  4967.         }
  4969.         return $this->redirectToRoute("manager_treatments");
  4970.     }
  4972.     /**
  4973.      * @Route("/substitute/{account}", name="substitute")
  4974.      */
  4975.     public function substituteAction(Request $request, Account $account)
  4976.     {
  4977.         if ($this->getUser()->getId() == 1) {
  4978.             $session = $this->get('session');
  4979.             $firewall = 'main';
  4980.             $token = new UsernamePasswordToken($account, null, $firewall, $account->getRoles());
  4981.             $this->get('security.token_storage')->setToken($token);
  4982.             $session->set('_security_'.$firewall, serialize($token));
  4984.             $event = new InteractiveLoginEvent($request, $token);
  4985.             $this->get("event_dispatcher")->dispatch("security.interactive_login", $event);
  4987.             return $this->redirectToRoute("default_homepage");
  4988.         }
  4990.         throw new NotFoundHttpException();
  4991.     }
  4993.     /**
  4994.      * @Route("/json/users", name="json_users")
  4995.      */
  4996.     public function jsonUsersAction(Request $request)
  4997.     {
  4998.         $users = $this->getDoctrine()->getRepository(User::class)->findBy([], ["companyName" => "ASC"]);
  5000.         $returnResponse = [];
  5002.         foreach ($users as $user) {
  5003.             $returnResponse[] = [
  5004.                 "id" => $user->getId(),
  5005.                 "text" => $user->getCompanyName(),
  5006.             ];
  5007.         }
  5009.         return new JsonResponse($returnResponse);
  5010.     }
  5011. }