src/Controller/Parametre/UserController.php line 143

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Parametre;
  5. use App\Entity\Users;
  6. use App\Entity\PDossier;
  7. use App\Entity\UsModule;
  8. use App\Controller\ApiController;
  9. use App\Entity\PCounter;
  10. use App\Entity\PPiece;
  11. use App\Entity\UserOperationDossier;
  12. use App\Entity\UsOperation;
  13. use App\Entity\UsSousModule;
  14. use App\Service\CalculPaieService;
  15. use Doctrine\Persistence\ManagerRegistry;
  16. use Symfony\Component\HttpFoundation\Request;
  17. use Symfony\Component\HttpFoundation\Response;
  18. use Symfony\Component\Routing\Annotation\Route;
  19. use Symfony\Component\HttpFoundation\JsonResponse;
  20. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  22. #[Route('/parametre/user')]
  23. class UserController extends AbstractController
  24. {
  25.     private $em;
  26.     private $calculPaieService;
  27.     private $api;
  28.     public function __construct(ManagerRegistry $doctrine, CalculPaieService $calculPaieService, ApiController $api)
  29.     {
  30.         $this->em = $doctrine->getManager();
  31.         $this->calculPaieService = $calculPaieService; 
  32.         $this->api = $api; 
  33.     }
  34.     #[Route('/', name: 'app_parametre_user')]
  35.     public function index(Request $request): Response
  36.     {
  37.         $operations = $this->api->check($this->getUser(), 'app_parametre_user', $this->em, $request);
  38.         
  39.         if(!is_array($operations)) {
  40.             return $this->redirectToRoute('app_site');  
  41.         }elseif(count($operations) == 0) {
  42.             return $this->render('includes/404.html.twig');
  43.         }
  44.         $modules = $this->em->getRepository(UsModule::class)->findAll();
  45.         $dossiers = $this->em->getRepository(PDossier::class)->findAll();
  47.         return $this->render('parametre/user/index.html.twig', [
  48.             'operations' => $operations,
  49.             'modules' => $modules,
  50.             'dossiers' => $dossiers,
  51.         ]);
  52.     }
  53.     #[Route('/app_parametre_user_list', name: 'app_parametre_user_list', options:['expose' => true])]
  54.     public function app_parametre_user_list(Request $request): Response
  55.     {
  56.         
  57.         $draw = $request->query->get('draw');
  58.         $start = $request->query->get('start') ?? 0;
  59.         $length = $request->query->get('length') ?? 10;
  60.         $search = $request->query->all('search')["value"];
  61.         $orderColumnIndex = $request->query->all('order')[0]['column'];
  62.         $orderColumn = $request->query->all("columns")[$orderColumnIndex]['name'];
  63.         $orderDir = $request->query->all('order')[0]['dir'] ?? 'asc';
  64.         $operations = $this->api->check($this->getUser(), 'app_parametre_user', $this->em, $request);
  67.         $queryBuilderInitital = $this->em->createQueryBuilder()
  68.             ->from(Users::class, 'u')
  69.         ;
  71.         $records = clone $queryBuilderInitital;
  72.         $records->select('u.nom, u.id, u.prenom, u.email, u.roles, u.username, u.enable');
  74.         if (!empty($search)) {
  75.             $records->andWhere('(u.nom LIKE :search OR u.prenom LIKE :search OR u.email LIKE :search OR u.username LIKE :search)')
  76.                 ->setParameter('search', "%$search%");
  77.         }
  79.         if (!empty($orderColumn)) {
  80.             $records->orderBy("$orderColumn", $orderDir);
  81.         }
  83.         $filteredRecords = count($records->getQuery()->getResult());
  85.         // Paginate results
  86.         $records->setFirstResult($start)
  87.             ->setMaxResults($length);
  89.         $results = $records->getQuery()->getResult();
  90.         // dd($results);
  91.         foreach ($results as $key => $user) {
  92.             $results[$key]['actions'] = $this->renderView('parametre/user/pages/access.html.twig', ['operations' => $operations, 'id' => $user['id']]);
  93.             $results[$key]['roles'] = implode(",", $user['roles']);
  94.         }
  95.         
  96.         $totalRecordsQuery = clone $queryBuilderInitital;
  97.         $totalRecords = $totalRecordsQuery->select('COUNT(u.id)')
  98.         ->getQuery()
  99.         ->getSingleScalarResult();
  101.         
  105.         return new JsonResponse([
  106.             'draw' => $draw,
  107.             'recordsTotal' => $totalRecords,
  108.             'recordsFiltered' => $filteredRecords,
  109.             'data' => $results,
  110.         ]);
  111.     }
  112.     #[Route('/app_parametre_user_activer', name: 'app_parametre_user_activer', options: ['expose' => true])]
  113.     public function app_parametre_user_activer(Request $request): Response
  114.     {
  115.         $usersIds = json_decode($request->get('usersIds'));
  116.         // dd($bordereauIds);
  117.         foreach ($usersIds as $key => $usersId) {
  118.             $user = $this->em->getRepository(Users::class)->find($usersId);
  119.             $user->setEnable(true);
  120.         }
  122.         $this->em->flush();
  124.         return new JsonResponse("Bien enregistrer");
  126.     }
  127.     #[Route('/app_parametre_user_desactiver', name: 'app_parametre_user_desactiver', options: ['expose' => true])]
  128.     public function app_parametre_user_desactiver(Request $request): Response
  129.     {
  130.         $usersIds = json_decode($request->get('usersIds'));
  131.         // dd($bordereauIds);
  132.         foreach ($usersIds as $key => $usersId) {
  133.             $user = $this->em->getRepository(Users::class)->find($usersId);
  134.             $user->setEnable(false);
  135.         }
  137.         $this->em->flush();
  139.         return new JsonResponse("Bien enregistrer");
  141.     }
  142.     #[Route('/app_parametre_user_operation/{operation}/{userId}/{dossierId}/{type}', name: 'app_parametre_user_operation', options: ['expose' => true])]
  143.     public function app_parametre_user_operation(Request $request, UsOperation $operation, Users $userId, PDossier $dossierId, $type): Response
  144.     {
  145.         if($type == 'add') {
  146.             $userOperationDossier = new UserOperationDossier();
  147.             $userOperationDossier->setUser($userId);
  148.             $userOperationDossier->setDossier($dossierId);
  149.             $userOperationDossier->setOperation($operation);
  151.             $this->em->persist($userOperationDossier);
  152.         } else {
  153.             $userOperationDossier = $this->em->getRepository(UserOperationDossier::class)->findOneBy(['user' => $userId, 'dossier' => $dossierId, 'operation' => $operation]);
  154.             if($userOperationDossier) {
  155.                 $this->em->remove($userOperationDossier);
  156.             }
  157.         }
  158.         
  159.         $this->em->flush();
  161.         return new JsonResponse("Bien enregistrer");
  163.     }
  164.     #[Route('/app_parametre_user_sousmodule/{sous_module}/{userId}/{dossierId}/{type}', name: 'app_parametre_user_sousmodule', options: ['expose' => true])]
  165.     public function app_parametre_user_sousmodule(Request $request, UsSousModule $sous_module, Users $userId, PDossier $dossierId, $type): Response
  166.     {
  167.         
  168.         if($type == 'add') {
  169.             foreach ($sous_module->getOperations() as $key => $operation) {
  170.                 $userOperationDossier = new UserOperationDossier();
  171.                 $userOperationDossier->setUser($userId);
  172.                 $userOperationDossier->setDossier($dossierId);
  173.                 $userOperationDossier->setOperation($operation);
  174.     
  175.                 $this->em->persist($userOperationDossier);
  176.             }
  177.         } else {
  178.             foreach ($sous_module->getOperations() as $key => $operation) {
  179.                 $userOperationDossier = $this->em->getRepository(UserOperationDossier::class)->findOneBy(['user' => $userId, 'dossier' => $dossierId, 'operation' => $operation]);
  180.                 if($userOperationDossier) {
  181.                     $this->em->remove($userOperationDossier);
  182.                 }
  183.             }
  184.         }
  185.         
  186.         $this->em->flush();
  188.         return new JsonResponse("Bien enregistrer");
  190.     }
  191.     #[Route('/app_parametre_user_module/{module}/{userId}/{dossierId}/{type}', name: 'app_parametre_user_module', options: ['expose' => true])]
  192.     public function app_parametre_user_module(Request $request, UsModule $module, Users $userId, PDossier $dossierId, $type): Response
  193.     {
  194.         if($type == 'add') {
  195.             foreach ($module->getSousModules() as $key => $sous_module) {
  196.                 foreach ($sous_module->getOperations() as $key => $operation) {
  197.                     $userOperationDossier = new UserOperationDossier();
  198.                     $userOperationDossier->setUser($userId);
  199.                     $userOperationDossier->setDossier($dossierId);
  200.                     $userOperationDossier->setOperation($operation);
  201.         
  202.                     $this->em->persist($userOperationDossier);
  203.                 }
  204.             }
  205.         } else {
  206.             foreach ($module->getSousModules() as $key => $sous_module) {
  207.                 foreach ($sous_module->getOperations() as $key => $operation) {
  208.                     $userOperationDossier = $this->em->getRepository(UserOperationDossier::class)->findOneBy(['user' => $userId, 'dossier' => $dossierId, 'operation' => $operation]);
  209.                     if($userOperationDossier) {
  210.                         $this->em->remove($userOperationDossier);
  211.                     }
  212.                 }
  213.             }
  214.         }
  215.         $this->em->flush();
  217.         return new JsonResponse("Bien enregistrer");
  219.     }
  220.     #[Route('/app_parametre_user_all/{userId}/{dossierId}/{type}', name: 'app_parametre_user_all', options: ['expose' => true])]
  221.     public function app_parametre_user_all(Request $request,  Users $userId, PDossier $dossierId, $type): Response
  222.     {
  223.         $modules = $this->em->getRepository(UsModule::class)->findAll();
  224.         if($type == 'add') {
  225.             foreach ($modules as $key => $module) {
  226.                 foreach ($module->getSousModules() as $key => $sous_module) {
  227.                     foreach ($sous_module->getOperations() as $key => $operation) {
  228.                         $userOperationDossier = new UserOperationDossier();
  229.                         $userOperationDossier->setUser($userId);
  230.                         $userOperationDossier->setDossier($dossierId);
  231.                         $userOperationDossier->setOperation($operation);
  232.             
  233.                         $this->em->persist($userOperationDossier);
  234.                     }
  235.                 }
  236.             }
  237.         } else {
  238.             foreach ($modules as $key => $module) {
  239.                 foreach ($module->getSousModules() as $key => $sous_module) {
  240.                     foreach ($sous_module->getOperations() as $key => $operation) {
  241.                         $userOperationDossier = $this->em->getRepository(UserOperationDossier::class)->findOneBy(['user' => $userId, 'dossier' => $dossierId, 'operation' => $operation]);
  242.                         if($userOperationDossier) {
  243.                             $this->em->remove($userOperationDossier);
  244.                         }
  245.                     }
  246.                 }
  247.             }
  248.         }
  249.         $this->em->flush();
  251.         return new JsonResponse("Bien enregistrer");
  253.     }
  255.     #[Route('/getoperations/{user}/{dossier}', name: 'app_parametre_user_operations', options: ['expose' => true])]
  256.     public function operations(Users $user, PDossier $dossier): Response
  257.     {
  258.        $ids = [];
  259.        $userOperationDossiers = $this->em->getRepository(UserOperationDossier::class)->findBy(['user' => $user, 'dossier' => $dossier]);
  260.        foreach ($userOperationDossiers as $userOperationDossier) {
  261.            array_push($ids, ["id" => $userOperationDossier->getOperation()->getId()]);
  262.        }
  264.        return new JsonResponse($ids);
  265.     }
  266.     #[Route('/app_parametre_user_all_user', name: 'app_parametre_user_all_user', options: ['expose' => true])]
  267.     public function app_parametre_user_all_user(Request $request): Response
  268.     {
  269.         $modules = $this->em->getRepository(UsModule::class)->findBy(['id' => [7, 1]]);
  270.         $dossiers = $this->em->getRepository(PDossier::class)->findBy(['active' => true]);
  271.         $users = $this->em->getRepository(Users::class)->findBy(['id' => [10]]);
  272.         // if($type == 'add') {
  273.         foreach ($users as $key => $user) {
  275.             foreach ($dossiers as $key => $dossier) {
  276.                 foreach ($modules as $key => $module) {
  277.                     foreach ($module->getSousModules() as $key => $sous_module) {
  278.                         foreach ($sous_module->getOperations() as $key => $operation) {
  279.                             if($operation->getId() != 22 and $module->getId() == 1) {
  280.                                 continue;
  281.                             }
  282.                             $userOperationDossier = $this->em->getRepository(UserOperationDossier::class)->findBy(['user' => $user, 'dossier' => $dossier, 'operation' => $operation]);
  283.                             if(!$userOperationDossier) {
  284.                                 $userOperationDossier = new UserOperationDossier();
  285.                                 $userOperationDossier->setUser($user);
  286.                                 $userOperationDossier->setDossier($dossier);
  287.                                 $userOperationDossier->setOperation($operation);
  288.                     
  289.                                 $this->em->persist($userOperationDossier);
  290.                             }
  291.                         }
  292.                     }
  293.                 }
  294.                 # code...
  295.             }
  296.         }
  297.        
  298.         $this->em->flush();
  300.         return new JsonResponse("Bien enregistrer");
  302.     }
  303.     #[Route('/app_parametre_generer_piece', name: 'app_parametre_generer_piece', options: ['expose' => true])]
  304.     public function app_parametre_generer_piece(Request $request): Response
  305.     {
  306.        
  307.         $dossiers = $this->em->getRepository(PDossier::class)->findBy(['active' => true]);
  308.         $annees = [24,25,26,27, 28, 29, 30];
  309.         
  310.         foreach ($dossiers as $key => $dossier) {
  311.             $pieces = $this->em->getRepository(PPiece::class)->findAll();
  312.             foreach ($pieces as $key => $piece) {
  313.                 foreach ($annees as $key => $annee) {
  314.                     $counter = $this->em->getRepository(PCounter::class)->findOneBy(['dossier' => $dossier, 'piece' => $piece, 'annee' => $annee]);
  315.                     if(!$counter) {
  316.                         $counter = new PCounter();
  317.                         $counter->setDossier($dossier);
  318.                         $counter->setPiece($piece);
  319.                         $counter->setAnnee($annee);
  320.                         $counter->setCount(0);
  321.                         $counter->setDossierAbreviation($dossier->getAbreviation());
  322.                         $this->em->persist($counter);
  323.                     } else {
  324.                         $counter->setDossierAbreviation($dossier->getAbreviation());
  325.                     }
  326.                 }
  327.             }
  328.         }
  329.     
  330.        
  331.         $this->em->flush();
  333.         return new JsonResponse("Bien enregistrer");
  335.     }
  336.     #[Route('/user_dossier', name: 'user_dossier', options: ['expose' => true])]
  337.     public function user_dossier(Request $request): Response
  338.     {
  339.        
  340.         $dossiers = $this->em->getRepository(PDossier::class)->findBy(['active' => true]);
  341.         $operations = $this->em->getRepository(UsOperation::class)->findBy(['id' => [65, 66]]);
  342.         foreach ($dossiers as $key => $dossier) {
  343.            
  344.             $user = $this->em->getRepository(Users::class)->findOneBy(['dossierResponsable' => $dossier]);
  346.             foreach ($operations as $key => $operation) {
  347.                 $userOperationDossier = $this->em->getRepository(UserOperationDossier::class)->findBy(['user' => $user, 'dossier' => $dossier, 'operation' => $operation]);
  348.                 if(!$userOperationDossier) {
  349.                     $userOperationDossier = new UserOperationDossier();
  350.                     $userOperationDossier->setUser($user);
  351.                     $userOperationDossier->setDossier($dossier);
  352.                     $userOperationDossier->setOperation($operation);
  353.         
  354.                     $this->em->persist($userOperationDossier);
  355.                 }
  356.             }
  357.         }
  358.     
  359.        
  360.         $this->em->flush();
  362.         return new JsonResponse("Bien enregistrer");
  364.     }
  365. }