src/Controller/bilanControllers/AnalyseSSTController.php line 97

Open in your IDE?
  1. <?php
  3. namespace App\Controller\bilanControllers;
  5. use App\Entity\bilan\Job;
  6. use App\Entity\bilan\Location;
  7. use App\Entity\bilan\Mission;
  8. use App\Entity\bilan\Task;
  9. use App\Entity\bilan\Zone;
  10. use App\Entity\Processus;
  11. use App\Entity\User;
  12. use App\Repository\bilan\SituationRisqueRepository;
  13. use App\Repository\bilan\JobRepository;
  14. use App\Repository\Configuration\CompanyEntityRepository;
  15. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  16. use Symfony\Component\HttpFoundation\JsonResponse;
  17. use Symfony\Component\HttpFoundation\Request;
  18. use Symfony\Component\HttpFoundation\Response;
  19. use Symfony\Component\Routing\Annotation\Route;
  20. use App\Repository\ProcessusRepository;
  22. /**
  23.  * @Route("/analyseSST")
  24.  */
  25. class AnalyseSSTController extends AbstractController
  26. {
  27.     private ProcessusRepository $processusRepository;
  28.     private JobRepository $jobRepository;
  29.     private CompanyEntityRepository $companyEntityRepository;
  31.     public function __construct(ProcessusRepository $processusRepository, JobRepository $jobRepository, CompanyEntityRepository $companyEntityRepository)
  32.     {
  33.         $this->processusRepository = $processusRepository;
  34.         $this->jobRepository = $jobRepository;
  35.         $this->companyEntityRepository = $companyEntityRepository;
  36.     }
  38.     private function getYearsList(): array
  39.     {
  40.         $currentYear = (int)date('Y');
  41.         $years = [];
  42.         for ($year = $currentYear; $year >= 2020; $year--) {
  43.             $years[] = $year;
  44.         }
  45.         return $years;
  46.     }
  48.     /**
  49.      * @Route("/", name="analyseSST")
  50.      */
  51.     public function index(): Response
  52.     {
  53.         $entities = $this->companyEntityRepository->findBy([], ['nom' => 'ASC']);
  54.         $processus = $this->processusRepository->findProcessusInternal();
  55.         $jobs = $this->jobRepository->findByUserEntity();
  56.         $missions = $this->getDoctrine()->getRepository(Mission::class)->findAll();
  57.         $locations = $this->getDoctrine()->getRepository(Location::class)->findAll();
  58.         $zones = $this->getDoctrine()->getRepository(Zone::class)->findAll();
  59.         $years = $this->getYearsList();
  60.         $users = $this->getDoctrine()->getRepository(User::class)->findBy([], ['lastname' => 'ASC']);
  62. // Filter users with 'evrp' in their modules
  63.         $usersWithEvrp = array_filter($users, function(User $user) {
  64.             $modules = $user->getModules() ?? [];
  65.             return in_array('Bilan SST', $modules);
  66.         });
  67. //        $users= $this->getDoctrine()->getRepository(User::class)->findAll();
  68. ////        foreach($processus as $proc)
  69. ////        {
  70. ////            $user = $proc->getPilote();
  71. ////            if(!in_array($user,$users) && (!is_null($user))){
  72. ////                $users[]=$user;
  73. ////            }
  74. ////        }
  75. //        usort($users, function($a, $b) {
  76. //            return strcmp($a->getLastname(), $b->getLastname());
  77. //        });
  78.         $menu="evaluate";
  79.         $left_menu="analyseSST";
  80.         return $this->render('bilanTemplates/analyse_sst/index.html.twig', [
  81.             'menu' => $menu,
  82.             'left_menu' => $left_menu,
  83.             'processus' => $processus,
  84.             'users' => $usersWithEvrp,
  85.             'jobs' => $jobs,
  86.             'missions' => $missions,
  87.             'locations' => $locations,
  88.             'zones' => $zones,
  89.             'years' => $years,
  90.             'entities' => $entities,
  91.         ]);
  92.     }
  94.     /**
  95.      * @Route("/analyseSSTData", name="analyseSSTData", methods={"GET"})
  96.      */
  97.     public function analyseSSTData(Request $request, SituationRisqueRepository $situationRisqueRepository): Response
  98.     {
  100.         $field = $request->query->get('field');
  102.         $situationRisqueData = $situationRisqueRepository->transformAll($field);
  103.         return new JsonResponse($situationRisqueData);
  104.     }
  106.     // /**
  107.     //  * @Route("/datatableJobFilter", name="datatableJobFilter", methods={"GET"})
  108.     //  */
  109.     // public function datatableJobFilter(Request $request): Response
  110.     // {
  111.         
  112.     //     $em=$this->getDoctrine();
  113.     //     $processus_id= intval($request->query->get('processus_id'));
  114.     //     $job_id= intval($request->query->get('job_id'));
  115.     //     $mission_id= intval($request->query->get('mission_id'));
  116.     //     $user_id= intval($request->query->get('user_id'));
  120.         
  121.         
  122.     //     $user_data='';
  123.     //     $processus_list=[];
  124.     //     $processus_data=[];
  125.     //     $jobs_list=[];
  126.     //     $jobs_data=[];
  127.     //     $missions_list=[];
  128.     //     $missions_data=[];
  130.     //     /*
  131.     //     if($user_id){
  132.     //         $user_data = $user_id;
  133.     //         $user=$em->getRepository(User::class)->find($user_id);
  134.     //         $processus_list=$em->getRepository(Processus::class)->findBy(['pilote'=>$user]);
  135.     //         foreach($processus_list as $processus) {
  137.     //         }
  138.     //     }*/
  141.     //     if($user_id){
  142.     //         $user_data = $user_id;
  143.     //         $user=$em->getRepository(User::class)->find($user_id);
  144.     //         $processus_list=$em->getRepository(Processus::class)->findBy(['pilote'=>$user]);
  145.     //         foreach($processus_list as $proc){
  146.                 
  148.     //             if($proc->getPilote()==$user){
  149.     //                 $selected_processus = false;
  150.     //                 if($proc->getId()==$processus_id){
  151.     //                     $selected_processus=true;
  152.     //                 }
  153.     //                 $processus_data[][$proc->getId()]=[
  154.     //                     "id"=>$proc->getId(),
  155.     //                     "title"=>$proc->getTitle(),
  156.     //                     "selected"=>$selected_processus
  157.     //                 ];
  158.     //             }
  159.     //         }
  160.     //     }else {
  161.     //         $processus_list=$em->getRepository(Processus::class)->findAll();
  162.     //         foreach($processus_list as $proc){
  163.     //             $selected_processus = false;
  164.     //             if($proc->getId()==$processus_id){
  165.     //                 $selected_processus=true;
  166.     //             }
  167.     //             $processus_data[][$proc->getId()]=[
  168.     //                 "id"=>$proc->getId(),
  169.     //                 "title"=>$proc->getTitle(),
  170.     //                 "selected"=>$selected_processus
  171.     //             ];
  172.     //         }
  173.     //     }
  175.         
  177.     //     if($processus_id){
  178.             
  179.     //         $processus=$em->getRepository(Processus::class)->find($processus_id);
  180.     //         $user_data = $processus->getPilote()->getId();
  181.     //         $jobs_list=$em->getRepository(Job::class)->findBy(['processus'=>$processus]);
  182.     //         foreach($jobs_list as $job){
  183.     //             if($job->getProcessus()==$processus){
  184.     //                 $selected_job = false;
  185.     //                 if($job->getId()==$job_id){
  186.     //                     $selected_job=true;
  187.     //                 }
  188.     //                 $jobs_data[][$job->getId()]=[
  189.     //                     "id"=>$job->getId(),
  190.     //                     'title'=>$job->getTitle(),
  191.     //                     'selected'=>$selected_job
  192.     //                 ];
  193.     //             }
  194.     //         }
  195.     //     }else if($user_id){
  196.     //         foreach($processus_list as $processus) {
  197.     //             $jobs_list=$em->getRepository(Job::class)->findBy(['processus'=>$processus]);
  198.     //             foreach($jobs_list as $job){
  199.     //                 if($job->getProcessus()==$processus){
  200.     //                     $selected_job = false;
  201.     //                     if($job->getId()==$job_id){
  202.     //                         $selected_job=true;
  203.     //                     }
  204.     //                     $jobs_data[][$job->getId()]=[
  205.     //                         "id"=>$job->getId(),
  206.     //                         'title'=>$job->getTitle(),
  207.     //                         'selected'=>$selected_job
  208.     //                     ];
  209.     //                 }
  210.     //             }
  211.     //         }
  212.     //     }
  213.     //     else {
  214.     //         $jobs_list=$em->getRepository(Job::class)->findAll();
  215.     //         foreach($jobs_list as $job){
  216.     //             $selected_job = false;
  217.     //             if($job->getId()==$job_id){
  218.     //                 $selected_job=true;
  219.     //             }
  220.     //             $jobs_data[][$job->getId()]=[
  221.     //                 "id"=>$job->getId(),
  222.     //                 'title'=>$job->getTitle(),
  223.     //                 'selected'=>$selected_job
  224.     //             ];
  225.     //         }
  226.     //     }
  227.         
  228.     //     if($job_id){
  229.             
  230.     //         $job=$em->getRepository(Job::class)->find($job_id);
  231.     //         $user_data = $job->getProcessus()->getPilote()->getId();
  232.     //         if(!$processus_id)
  233.     //         {
  234.     //             $processus_id=$job->getProcessus()->getId();
  235.     //             foreach($processus_data as $key=>$proc_data){
  236.     //                 if(array_key_exists($processus_id,$proc_data)){
  237.                         
  238.     //                     $proc_data[$processus_id]['selected']=true;
  239.     //                     $processus_data[$key] = $proc_data;
  240.     //                 }
  241.     //             }
  242.     //         }
  243.     //         $missions_list=$em->getRepository(Mission::class)->findBy(['job'=>$job]);
  244.     //         foreach($missions_list as $mission){
  245.                 
  246.     //             if($mission->getJob()==$job){
  247.     //                 $selected_mission = false;
  248.     //                 if($mission->getId()==$mission_id){
  249.     //                     $selected_mission=true;
  250.     //                 }
  251.     //                 $missions_data[][$mission->getId()]=[
  252.     //                     "id"=>$mission->getId(),
  253.     //                     'title'=>$mission->getTitle(),
  254.     //                     'selected'=>$selected_mission
  255.     //                 ];
  256.     //             }
  257.     //         }
  258.     //     }else {
  259.             
  260.     //         foreach($jobs_list as $job)
  261.     //         {
  262.     //             $missions_list=$em->getRepository(Mission::class)->findBy(['job'=>$job]);
  263.     //             foreach($missions_list as $mission){
  264.     //                 if($mission->getJob()==$job){
  265.     //                     $selected_mission = false;
  266.     //                     if($mission->getId()==$mission_id){
  267.     //                         $selected_mission=true;
  268.     //                     }
  269.     //                     $missions_data[][$mission->getId()]=[
  270.     //                         "id"=>$mission->getId(),
  271.     //                         'title'=>$mission->getTitle(),
  272.     //                         'selected'=>$selected_mission
  273.     //                     ];
  274.     //                 }
  275.     //             }
  276.     //         }
  277.             
  278.     //     }
  280.     //     if($mission_id && !$job_id && !$processus_id && !$user_id){
  281.     //         $mission = $em->getRepository(Mission::class)->find($mission_id);
  282.     //         $job = $mission->getJob();
  283.     //         $processus = $job->getProcessus();
  284.     //         $user = $processus->getPilote();
  286.     //         $user_data = $user->getId();
  287.             
  288.     //         foreach($processus_data as $key=>$proc_data){
  289.     //             if(array_key_exists($processus->getId(),$proc_data)){
  290.     //                 $proc_data[$processus->getId()]['selected']=true;
  291.     //                 $processus_data[$key] = $proc_data;
  292.     //             }
  293.     //         }
  295.     //         foreach($jobs_data as $key=>$job_data){
  296.     //             if(array_key_exists($job->getId(),$job_data)){
  297.     //                 $job_data[$job->getId()]['selected']=true;
  298.     //                 $jobs_data[$key] = $job_data;
  299.     //             }
  300.     //         }
  301.             
  302.     //     }
  304.         
  305.         
  306.     //     $filters=[
  307.     //         'user_data'=>$user_data,
  308.     //         'processus_data'=>$processus_data,
  309.     //         'jobs_data'=>$jobs_data,
  310.     //         'missions_data'=>$missions_data,
  312.     //     ];
  314.         
  315.     //     return new JsonResponse($filters);
  316.     // }
  319.     // /**
  320.     //  * @Route("/datatableLocationFilter", name="datatableLocationFilter", methods={"POST"})
  321.     //  */
  322.     // public function datatableLocationFilter(Request $request): Response
  323.     // {
  324.         
  325.     //     $em=$this->getDoctrine();
  326.     //     $processus_id= intval($request->request->get('processus_id'));
  327.     //     $location_id= intval($request->request->get('location_id'));
  328.     //     $zone_id= intval($request->request->get('zone_id'));
  329.     //     $user_id= intval($request->request->get('user_id'));
  330.         
  331.     //     $user_data='';
  332.     //     $processus_list=[];
  333.     //     $processus_data=[];
  334.     //     $locations_list=[];
  335.     //     $locations_data=[];
  336.     //     $zones_list=[];
  337.     //     $zones_data=[];
  338.     //     if($user_id){
  339.     //         $user_data = $user_id;
  340.     //         $user=$em->getRepository(User::class)->find($user_id);
  341.     //         $processus_list=$em->getRepository(Processus::class)->findBy(['pilote'=>$user]);
  342.     //         foreach($processus_list as $proc){
  343.                 
  345.     //             if($proc->getPilote()==$user){
  346.     //                 $selected_processus = false;
  347.     //                 if($proc->getId()==$processus_id){
  348.     //                     $selected_processus=true;
  349.     //                 }
  350.     //                 $processus_data[][$proc->getId()]=[
  351.     //                     "id"=>$proc->getId(),
  352.     //                     "title"=>$proc->getTitle(),
  353.     //                     "selected"=>$selected_processus
  354.     //                 ];
  355.     //             }
  356.     //         }
  357.     //     }else {
  358.     //         $processus_list=$em->getRepository(Processus::class)->findAll();
  359.     //         foreach($processus_list as $proc){
  360.     //             $selected_processus = false;
  361.     //             if($proc->getId()==$processus_id){
  362.     //                 $selected_processus=true;
  363.     //             }
  364.     //             $processus_data[][$proc->getId()]=[
  365.     //                 "id"=>$proc->getId(),
  366.     //                 "title"=>$proc->getTitle(),
  367.     //                 "selected"=>$selected_processus
  368.     //             ];
  369.     //         }
  370.     //     }
  372.         
  374.     //     if($processus_id){
  375.             
  376.     //         $processus=$em->getRepository(Processus::class)->find($processus_id);
  377.     //         $user_data = $processus->getPilote()->getId();
  378.     //         $locations_list=$em->getRepository(Location::class)->findBy(['processus'=>$processus]);
  379.     //         foreach($locations_list as $location){
  380.     //             if($location->getProcessus()==$processus){
  381.     //                 $selected_location = false;
  382.     //                 if($location->getId()==$location_id){
  383.     //                     $selected_location=true;
  384.     //                 }
  385.     //                 $locations_data[][$location->getId()]=[
  386.     //                     "id"=>$location->getId(),
  387.     //                     'title'=>$location->getName(),
  388.     //                     'selected'=>$selected_location
  389.     //                 ];
  390.     //             }
  391.     //         }
  392.     //     }else if($user_id){
  393.     //         foreach($processus_list as $processus) {
  394.     //             $locations_list=$em->getRepository(Location::class)->findBy(['processus'=>$processus]);
  395.     //             foreach($locations_list as $location){
  396.     //                 if($location->getProcessus()==$processus){
  397.     //                     $selected_location = false;
  398.     //                     if($location->getId()==$location_id){
  399.     //                         $selected_location=true;
  400.     //                     }
  401.     //                     $locations_data[][$location->getId()]=[
  402.     //                         "id"=>$location->getId(),
  403.     //                         'title'=>$location->getName(),
  404.     //                         'selected'=>$selected_location
  405.     //                     ];
  406.     //                 }
  407.     //             }
  408.     //         }
  409.     //     }
  410.     //     else {
  411.     //         $locations_list=$em->getRepository(Location::class)->findAll();
  412.     //         foreach($locations_list as $location){
  413.     //             $selected_location = false;
  414.     //             if($location->getId()==$location_id){
  415.     //                 $selected_location=true;
  416.     //             }
  417.     //             $locations_data[][$location->getId()]=[
  418.     //                 "id"=>$location->getId(),
  419.     //                 'title'=>$location->getName(),
  420.     //                 'selected'=>$selected_location
  421.     //             ];
  422.     //         }
  423.     //     }
  424.         
  425.     //     if($location_id){
  426.             
  427.     //         $location=$em->getRepository(Location::class)->find($location_id);
  428.     //         $user_data = $location->getProcessus()->getPilote()->getId();
  429.     //         if(!$processus_id)
  430.     //         {
  431.     //             $processus_id=$location->getProcessus()->getId();
  432.     //             foreach($processus_data as $key=>$proc_data){
  433.     //                 if(array_key_exists($processus_id,$proc_data)){
  434.                         
  435.     //                     $proc_data[$processus_id]['selected']=true;
  436.     //                     $processus_data[$key] = $proc_data;
  437.     //                 }
  438.     //             }
  439.     //         }
  440.     //         $zones_list=$em->getRepository(Zone::class)->findBy(['location'=>$location]);
  441.     //         foreach($zones_list as $zone){
  442.                 
  443.     //             if($zone->getLocation()==$location){
  444.     //                 $selected_zone = false;
  445.     //                 if($zone->getId()==$zone_id){
  446.     //                     $selected_zone=true;
  447.     //                 }
  448.     //                 $zones_data[][$zone->getId()]=[
  449.     //                     "id"=>$zone->getId(),
  450.     //                     'title'=>$zone->getName(),
  451.     //                     'selected'=>$selected_zone
  452.     //                 ];
  453.     //             }
  454.     //         }
  455.     //     }else {
  456.             
  457.     //         foreach($locations_list as $location)
  458.     //         {
  459.     //             $zones_list=$em->getRepository(Zone::class)->findBy(['location'=>$location]);
  460.     //             foreach($zones_list as $zone){
  461.     //                 if($zone->getLocation()==$location){
  462.     //                     $selected_zone = false;
  463.     //                     if($zone->getId()==$zone_id){
  464.     //                         $selected_zone=true;
  465.     //                     }
  466.     //                     $zones_data[][$zone->getId()]=[
  467.     //                         "id"=>$zone->getId(),
  468.     //                         'title'=>$zone->getName(),
  469.     //                         'selected'=>$selected_zone
  470.     //                     ];
  471.     //                 }
  472.     //             }
  473.     //         }
  474.             
  475.     //     }
  477.     //     if($zone_id && !$location_id && !$processus_id && !$user_id){
  478.     //         $zone = $em->getRepository(Zone::class)->find($zone_id);
  479.     //         $location = $zone->getLocation();
  480.     //         $processus = $location->getProcessus();
  481.     //         $user = $processus->getPilote();
  483.     //         $user_data = $user->getId();
  484.             
  485.     //         foreach($processus_data as $key=>$proc_data){
  486.     //             if(array_key_exists($processus->getId(),$proc_data)){
  487.     //                 $proc_data[$processus->getId()]['selected']=true;
  488.     //                 $processus_data[$key] = $proc_data;
  489.     //             }
  490.     //         }
  492.     //         foreach($locations_data as $key=>$location_data){
  493.     //             if(array_key_exists($location->getId(),$location_data)){
  494.     //                 $location_data[$location->getId()]['selected']=true;
  495.     //                 $locations_data[$key] = $location_data;
  496.     //             }
  497.     //         }
  498.             
  499.     //     }
  501.         
  502.         
  503.     //     $filters=[
  504.     //         'user_data'=>$user_data,
  505.     //         'processus_data'=>$processus_data,
  506.     //         'locations_data'=>$locations_data,
  507.     //         'zones_data'=>$zones_data,
  509.     //     ];
  511.         
  512.     //     return new JsonResponse($filters);
  513.     // }
  516. }