src/Controller/bilanControllers/AnalyseSSTController.php line 178

Open in your IDE?
  1. <?php
  3. namespace App\Controller\bilanControllers;
  5. use App\Entity\bilan\Criticite;
  6. use App\Entity\bilan\Frequence;
  7. use App\Entity\bilan\Gravite;
  8. use App\Entity\bilan\Job;
  9. use App\Entity\bilan\Location;
  10. use App\Entity\bilan\Mission;
  11. use App\Entity\bilan\MOG;
  12. use App\Entity\bilan\SituationRisque;
  13. use App\Entity\bilan\Task;
  14. use App\Entity\bilan\Zone;
  15. use App\Entity\Processus;
  16. use App\Entity\User;
  17. use App\Repository\bilan\SituationRisqueRepository;
  18. use App\Repository\bilan\JobRepository;
  19. use App\Repository\bilan\TaskRepository;
  20. use App\Repository\Configuration\CompanyEntityRepository;
  21. use Doctrine\ORM\EntityManagerInterface;
  22. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  23. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  24. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  25. use Symfony\Component\HttpFoundation\JsonResponse;
  26. use Symfony\Component\HttpFoundation\Request;
  27. use Symfony\Component\HttpFoundation\Response;
  28. use Symfony\Component\HttpFoundation\StreamedResponse;
  29. use Symfony\Component\Routing\Annotation\Route;
  30. use App\Repository\ProcessusRepository;
  32. /**
  33.  * @Route("/analyseSST")
  34.  */
  35. class AnalyseSSTController extends AbstractController
  36. {
  37.     private ProcessusRepository $processusRepository;
  38.     private JobRepository $jobRepository;
  39.     private CompanyEntityRepository $companyEntityRepository;
  41.     public function __construct(ProcessusRepository $processusRepository, JobRepository $jobRepository, CompanyEntityRepository $companyEntityRepository)
  42.     {
  43.         $this->processusRepository = $processusRepository;
  44.         $this->jobRepository = $jobRepository;
  45.         $this->companyEntityRepository = $companyEntityRepository;
  46.     }
  48.     private function getYearsList(): array
  49.     {
  50.         $currentYear = (int)date('Y');
  51.         $years = [];
  52.         for ($year = $currentYear; $year >= 2020; $year--) {
  53.             $years[] = $year;
  54.         }
  55.         return $years;
  56.     }
  58.     /**
  59.      * @Route("/mission/{id}", name="analyseSST_mission_detail", methods={"GET"})
  60.      */
  61.     public function missionDetail(
  62.         Mission $mission,
  63.         TaskRepository $taskRepository,
  64.         EntityManagerInterface $em
  65.     ): Response {
  66.         $data = $taskRepository->transformAllMision($mission);
  68.         // Group flat rows by task for easier template rendering
  69.         $grouped = [];
  70.         foreach ($data['data'] as $row) {
  71.             $taskId = $row['idT'];
  72.             if (!isset($grouped[$taskId])) {
  73.                 $grouped[$taskId] = ['title' => $row['titleT'], 'rows' => []];
  74.             }
  75.             if ($row['idSR'] !== '') {
  76.                 $grouped[$taskId]['rows'][] = $row;
  77.             }
  78.         }
  80.         $frequences = $em->getRepository(Frequence::class)->findBy([], ['note' => 'ASC']);
  81.         $gravites   = $em->getRepository(Gravite::class)->findBy([], ['note' => 'ASC']);
  82.         $mogs       = $em->getRepository(MOG::class)->findBy([], ['note' => 'ASC']);
  84.         return $this->render('bilanTemplates/analyse_sst/mission_detail.html.twig', [
  85.             'mission'   => $mission,
  86.             'grouped'   => $grouped,
  87.             'frequences' => $frequences,
  88.             'gravites'  => $gravites,
  89.             'mogs'      => $mogs,
  90.             'left_menu' => 'analyseSST',
  91.             'menu'      => 'evaluate',
  92.         ]);
  93.     }
  95.     /**
  96.      * @Route("/sr/{id}", name="analyseSST_sr_detail", methods={"GET"})
  97.      */
  98.     public function srDetail(SituationRisque $sr, EntityManagerInterface $em): Response
  99.     {
  100.         $criticite_array = $em->getRepository(Criticite::class)->findBy([], ['valeur' => 'asc']);
  102.         $criticiteValue = $sr->getCriticiteValue();
  103.         $criticite      = '';
  104.         $criticite_color = '#ccc';
  105.         if ($sr->getFrequence() && $sr->getGravite()) {
  106.             foreach ($criticite_array as $el) {
  107.                 if ($el->getType() === 'criticite' && $criticiteValue >= $el->getValeur()) {
  108.                     $criticite       = $el->getLegende();
  109.                     $criticite_color = $el->getCouleur();
  110.                 }
  111.             }
  112.         }
  114.         $rrValue  = $sr->getRisqueResiduelValue();
  115.         $risqueR  = '';
  116.         $rr_color = '#ccc';
  117.         if ($sr->getFrequence() && $sr->getGravite() && $sr->getMog()) {
  118.             foreach ($criticite_array as $el) {
  119.                 if ($el->getType() === 'prevention' && $rrValue >= $el->getValeur()) {
  120.                     $risqueR  = $el->getLegende();
  121.                     $rr_color = $el->getCouleur();
  122.                 }
  123.             }
  124.         }
  126.         return $this->render('bilanTemplates/analyse_sst/sr_detail.html.twig', [
  127.             'sr'              => $sr,
  128.             'criticiteValue'  => $criticiteValue,
  129.             'criticite'       => $criticite,
  130.             'criticite_color' => $criticite_color,
  131.             'rrValue'         => $rrValue,
  132.             'risqueR'         => $risqueR,
  133.             'rr_color'        => $rr_color,
  134.             'left_menu'       => 'analyseSST',
  135.             'menu'            => 'evaluate',
  136.         ]);
  137.     }
  139.     /**
  140.      * @Route("/", name="analyseSST")
  141.      */
  142.     public function index(): Response
  143.     {
  144.         $entities = $this->getUser()->getEntities();
  145.         $processus = $this->processusRepository->findProcessusInternal();
  146.         $jobs = $this->jobRepository->findByUserEntity();
  147.         $missions = $this->getDoctrine()->getRepository(Mission::class)->findAll();
  148.         $locations = $this->getDoctrine()->getRepository(Location::class)->findAll();
  149.         $zones = $this->getDoctrine()->getRepository(Zone::class)->findAll();
  150.         $years = $this->getYearsList();
  151.         $users = $this->getDoctrine()->getRepository(User::class)->findBy([], ['lastname' => 'ASC']);
  153. // Filter users with 'evrp' in their modules
  154.         $usersWithEvrp = array_filter($users, function(User $user) {
  155.             $modules = $user->getModules() ?? [];
  156.             return in_array('Bilan SST', $modules);
  157.         });
  159.         $menu="evaluate";
  160.         $left_menu="analyseSST";
  161.         return $this->render('bilanTemplates/analyse_sst/index.html.twig', [
  162.             'menu' => $menu,
  163.             'left_menu' => $left_menu,
  164.             'processus' => $processus,
  165.             'users' => $usersWithEvrp,
  166.             'jobs' => $jobs,
  167.             'missions' => $missions,
  168.             'locations' => $locations,
  169.             'zones' => $zones,
  170.             'years' => $years,
  171.             'entities' => $entities,
  172.         ]);
  173.     }
  175.     /**
  176.      * @Route("/analyseSSTData", name="analyseSSTData", methods={"GET"})
  177.      */
  178.     public function analyseSSTData(Request $request, SituationRisqueRepository $situationRisqueRepository): Response
  179.     {
  180.         $field = $request->query->get('field', 'job');
  181.         $draw = (int) $request->query->get('draw', 1);
  182.         $start = (int) $request->query->get('start', 0);
  183.         $length = (int) $request->query->get('length', 11);
  184.         $searchValue = $request->query->get('search')['value'] ?? '';
  186.         $filters = [
  187.             'user_entities' => $this->getUser()->getEntities()->toArray(),
  188.             'filter_entity' => $request->query->get('filter_entity', ''),
  189.             'filter_processus' => $request->query->get('filter_processus', ''),
  190.             'filter_responsible' => $request->query->get('filter_responsible', ''),
  191.             'filter_year' => $request->query->get('filter_year', ''),
  192.             'filter_criticite' => $request->query->get('filter_criticite', ''),
  193.             'filter_risqueResiduel' => $request->query->get('filter_risqueResiduel', ''),
  194.         ];
  196.         if ($field === 'job') {
  197.             $filters['filter_job'] = $request->query->get('filter_job', '');
  198.             $filters['filter_mission'] = $request->query->get('filter_mission', '');
  199.             $filters['filter_date'] = $request->query->get('filter_date', '');
  200.             $filters['filter_task'] = $request->query->get('filter_task', '');
  201.             $filters['filter_danger'] = $request->query->get('filter_danger', '');
  202.             $filters['filter_risque'] = $request->query->get('filter_risque', '');
  203.         } elseif ($field === 'location') {
  204.             $filters['filter_location'] = $request->query->get('filter_location', '');
  205.             $filters['filter_zone'] = $request->query->get('filter_zone', '');
  206.         }
  208.         $result = $situationRisqueRepository->getServerSideData($field, $start, $length, $searchValue, $filters);
  210.         return new JsonResponse([
  211.             'draw' => $draw,
  212.             'recordsTotal' => $result['totalCount'],
  213.             'recordsFiltered' => $result['filteredCount'],
  214.             'data' => $result['data'],
  215.         ]);
  216.     }
  218.     /**
  219.      * @Route("/analyseSSTExport", name="analyseSSTExport", methods={"GET"})
  220.      */
  221.     public function analyseSSTExport(Request $request, SituationRisqueRepository $situationRisqueRepository): StreamedResponse
  222.     {
  223.         $field = $request->query->get('field', 'job');
  224.         $searchValue = $request->query->get('search', '');
  226.         $filters = [
  227.             'user_entities' => $this->getUser()->getEntities()->toArray(),
  228.             'filter_entity' => $request->query->get('filter_entity', ''),
  229.             'filter_processus' => $request->query->get('filter_processus', ''),
  230.             'filter_responsible' => $request->query->get('filter_responsible', ''),
  231.             'filter_year' => $request->query->get('filter_year', ''),
  232.             'filter_criticite' => $request->query->get('filter_criticite', ''),
  233.             'filter_risqueResiduel' => $request->query->get('filter_risqueResiduel', ''),
  234.         ];
  236.         if ($field === 'job') {
  237.             $filters['filter_job'] = $request->query->get('filter_job', '');
  238.             $filters['filter_mission'] = $request->query->get('filter_mission', '');
  239.             $filters['filter_date'] = $request->query->get('filter_date', '');
  240.             $filters['filter_task'] = $request->query->get('filter_task', '');
  241.             $filters['filter_danger'] = $request->query->get('filter_danger', '');
  242.             $filters['filter_risque'] = $request->query->get('filter_risque', '');
  243.         } elseif ($field === 'location') {
  244.             $filters['filter_location'] = $request->query->get('filter_location', '');
  245.             $filters['filter_zone'] = $request->query->get('filter_zone', '');
  246.         }
  248.         $data = $situationRisqueRepository->getFilteredDataForExport($field, $searchValue, $filters);
  250.         $response = new StreamedResponse(function () use ($data, $field) {
  251.             ini_set('display_errors', '0');
  252.             $spreadsheet = new Spreadsheet();
  253.             $sheet = $spreadsheet->getActiveSheet();
  255.             if ($field === 'job') {
  256.                 $headers = ['Entité', 'Métier', 'Mission', 'Date', 'Tâche', 'Situation dangereuse', 'Risque', 'Criticité', 'Risque résiduel', 'Fréquence', 'Gravité', 'Maitrise H+O+T', 'Actions'];
  257.             } elseif ($field === 'location') {
  258.                 $headers = ['Entité', 'Lieu', 'Zone', 'Date', 'Tâche', 'Situation dangereuse', 'Risque', 'Criticité', 'Risque résiduel', 'Fréquence', 'Gravité', 'MOP', 'MOG', 'Actions'];
  259.             } else {
  260.                 $headers = ['Entité', 'Date', 'Tâche', 'Situation dangereuse', 'Risque', 'Criticité', 'Risque résiduel', 'Fréquence', 'Gravité', 'MOP', 'MOG', 'Actions'];
  261.             }
  263.             $col = 1;
  264.             foreach ($headers as $header) {
  265.                 $sheet->setCellValueByColumnAndRow($col++, 1, $header);
  266.             }
  268.             $row = 2;
  269.             foreach ($data as $item) {
  270.                 $col = 1;
  271.                 $sheet->setCellValueByColumnAndRow($col++, $row, $item['entity'] ?? '');
  272.                 if ($field === 'job') {
  273.                     $sheet->setCellValueByColumnAndRow($col++, $row, $item['job'] ?? '');
  274.                     $sheet->setCellValueByColumnAndRow($col++, $row, $item['mission'] ?? '');
  275.                 } elseif ($field === 'location') {
  276.                     $sheet->setCellValueByColumnAndRow($col++, $row, $item['location'] ?? '');
  277.                     $sheet->setCellValueByColumnAndRow($col++, $row, $item['zone'] ?? '');
  278.                 }
  279.                 $sheet->setCellValueByColumnAndRow($col++, $row, $item['dateEnregistrement'] ?? '');
  280.                 $sheet->setCellValueByColumnAndRow($col++, $row, $item['task'] ?? '');
  281.                 $sheet->setCellValueByColumnAndRow($col++, $row, $item['danger'] ?? '');
  282.                 $sheet->setCellValueByColumnAndRow($col++, $row, $item['risque'] ?? '');
  283.                 $sheet->setCellValueByColumnAndRow($col++, $row, $item['criticity'] ?? '');
  284.                 $sheet->setCellValueByColumnAndRow($col++, $row, $item['risqueResiduel'] ?? '');
  285.                 $sheet->setCellValueByColumnAndRow($col++, $row, strip_tags($item['frequenceNote'] ?? ''));
  286.                 $sheet->setCellValueByColumnAndRow($col++, $row, strip_tags($item['gravityNote'] ?? ''));
  287. //                $sheet->setCellValueByColumnAndRow($col++, $row, strip_tags($item['mesureOPNote'] ?? ''));
  288.                 $sheet->setCellValueByColumnAndRow($col++, $row, strip_tags($item['mesureORGNote'] ?? ''));
  289.                 $sheet->setCellValueByColumnAndRow($col++, $row, $item['actionsRefs'] ?? '');
  290.                 $row++;
  291.             }
  293.             $writer = new Xlsx($spreadsheet);
  294.             $writer->save('php://output');
  295.         });
  297.         $filename = 'analyse_sst_' . $field . '_' . date('Y-m-d') . '.xlsx';
  298.         $response->headers->set('Content-Type', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
  299.         $response->headers->set('Content-Disposition', 'attachment; filename="' . $filename . '"');
  300.         $response->headers->set('Cache-Control', 'max-age=0');
  302.         return $response;
  303.     }
  305.     // /**
  306.     //  * @Route("/datatableJobFilter", name="datatableJobFilter", methods={"GET"})
  307.     //  */
  308.     // public function datatableJobFilter(Request $request): Response
  309.     // {
  310.         
  311.     //     $em=$this->getDoctrine();
  312.     //     $processus_id= intval($request->query->get('processus_id'));
  313.     //     $job_id= intval($request->query->get('job_id'));
  314.     //     $mission_id= intval($request->query->get('mission_id'));
  315.     //     $user_id= intval($request->query->get('user_id'));
  319.         
  320.         
  321.     //     $user_data='';
  322.     //     $processus_list=[];
  323.     //     $processus_data=[];
  324.     //     $jobs_list=[];
  325.     //     $jobs_data=[];
  326.     //     $missions_list=[];
  327.     //     $missions_data=[];
  329.     //     /*
  330.     //     if($user_id){
  331.     //         $user_data = $user_id;
  332.     //         $user=$em->getRepository(User::class)->find($user_id);
  333.     //         $processus_list=$em->getRepository(Processus::class)->findBy(['pilote'=>$user]);
  334.     //         foreach($processus_list as $processus) {
  336.     //         }
  337.     //     }*/
  340.     //     if($user_id){
  341.     //         $user_data = $user_id;
  342.     //         $user=$em->getRepository(User::class)->find($user_id);
  343.     //         $processus_list=$em->getRepository(Processus::class)->findBy(['pilote'=>$user]);
  344.     //         foreach($processus_list as $proc){
  345.                 
  347.     //             if($proc->getPilote()==$user){
  348.     //                 $selected_processus = false;
  349.     //                 if($proc->getId()==$processus_id){
  350.     //                     $selected_processus=true;
  351.     //                 }
  352.     //                 $processus_data[][$proc->getId()]=[
  353.     //                     "id"=>$proc->getId(),
  354.     //                     "title"=>$proc->getTitle(),
  355.     //                     "selected"=>$selected_processus
  356.     //                 ];
  357.     //             }
  358.     //         }
  359.     //     }else {
  360.     //         $processus_list=$em->getRepository(Processus::class)->findAll();
  361.     //         foreach($processus_list as $proc){
  362.     //             $selected_processus = false;
  363.     //             if($proc->getId()==$processus_id){
  364.     //                 $selected_processus=true;
  365.     //             }
  366.     //             $processus_data[][$proc->getId()]=[
  367.     //                 "id"=>$proc->getId(),
  368.     //                 "title"=>$proc->getTitle(),
  369.     //                 "selected"=>$selected_processus
  370.     //             ];
  371.     //         }
  372.     //     }
  374.         
  376.     //     if($processus_id){
  377.             
  378.     //         $processus=$em->getRepository(Processus::class)->find($processus_id);
  379.     //         $user_data = $processus->getPilote()->getId();
  380.     //         $jobs_list=$em->getRepository(Job::class)->findBy(['processus'=>$processus]);
  381.     //         foreach($jobs_list as $job){
  382.     //             if($job->getProcessus()==$processus){
  383.     //                 $selected_job = false;
  384.     //                 if($job->getId()==$job_id){
  385.     //                     $selected_job=true;
  386.     //                 }
  387.     //                 $jobs_data[][$job->getId()]=[
  388.     //                     "id"=>$job->getId(),
  389.     //                     'title'=>$job->getTitle(),
  390.     //                     'selected'=>$selected_job
  391.     //                 ];
  392.     //             }
  393.     //         }
  394.     //     }else if($user_id){
  395.     //         foreach($processus_list as $processus) {
  396.     //             $jobs_list=$em->getRepository(Job::class)->findBy(['processus'=>$processus]);
  397.     //             foreach($jobs_list as $job){
  398.     //                 if($job->getProcessus()==$processus){
  399.     //                     $selected_job = false;
  400.     //                     if($job->getId()==$job_id){
  401.     //                         $selected_job=true;
  402.     //                     }
  403.     //                     $jobs_data[][$job->getId()]=[
  404.     //                         "id"=>$job->getId(),
  405.     //                         'title'=>$job->getTitle(),
  406.     //                         'selected'=>$selected_job
  407.     //                     ];
  408.     //                 }
  409.     //             }
  410.     //         }
  411.     //     }
  412.     //     else {
  413.     //         $jobs_list=$em->getRepository(Job::class)->findAll();
  414.     //         foreach($jobs_list as $job){
  415.     //             $selected_job = false;
  416.     //             if($job->getId()==$job_id){
  417.     //                 $selected_job=true;
  418.     //             }
  419.     //             $jobs_data[][$job->getId()]=[
  420.     //                 "id"=>$job->getId(),
  421.     //                 'title'=>$job->getTitle(),
  422.     //                 'selected'=>$selected_job
  423.     //             ];
  424.     //         }
  425.     //     }
  426.         
  427.     //     if($job_id){
  428.             
  429.     //         $job=$em->getRepository(Job::class)->find($job_id);
  430.     //         $user_data = $job->getProcessus()->getPilote()->getId();
  431.     //         if(!$processus_id)
  432.     //         {
  433.     //             $processus_id=$job->getProcessus()->getId();
  434.     //             foreach($processus_data as $key=>$proc_data){
  435.     //                 if(array_key_exists($processus_id,$proc_data)){
  436.                         
  437.     //                     $proc_data[$processus_id]['selected']=true;
  438.     //                     $processus_data[$key] = $proc_data;
  439.     //                 }
  440.     //             }
  441.     //         }
  442.     //         $missions_list=$em->getRepository(Mission::class)->findBy(['job'=>$job]);
  443.     //         foreach($missions_list as $mission){
  444.                 
  445.     //             if($mission->getJob()==$job){
  446.     //                 $selected_mission = false;
  447.     //                 if($mission->getId()==$mission_id){
  448.     //                     $selected_mission=true;
  449.     //                 }
  450.     //                 $missions_data[][$mission->getId()]=[
  451.     //                     "id"=>$mission->getId(),
  452.     //                     'title'=>$mission->getTitle(),
  453.     //                     'selected'=>$selected_mission
  454.     //                 ];
  455.     //             }
  456.     //         }
  457.     //     }else {
  458.             
  459.     //         foreach($jobs_list as $job)
  460.     //         {
  461.     //             $missions_list=$em->getRepository(Mission::class)->findBy(['job'=>$job]);
  462.     //             foreach($missions_list as $mission){
  463.     //                 if($mission->getJob()==$job){
  464.     //                     $selected_mission = false;
  465.     //                     if($mission->getId()==$mission_id){
  466.     //                         $selected_mission=true;
  467.     //                     }
  468.     //                     $missions_data[][$mission->getId()]=[
  469.     //                         "id"=>$mission->getId(),
  470.     //                         'title'=>$mission->getTitle(),
  471.     //                         'selected'=>$selected_mission
  472.     //                     ];
  473.     //                 }
  474.     //             }
  475.     //         }
  476.             
  477.     //     }
  479.     //     if($mission_id && !$job_id && !$processus_id && !$user_id){
  480.     //         $mission = $em->getRepository(Mission::class)->find($mission_id);
  481.     //         $job = $mission->getJob();
  482.     //         $processus = $job->getProcessus();
  483.     //         $user = $processus->getPilote();
  485.     //         $user_data = $user->getId();
  486.             
  487.     //         foreach($processus_data as $key=>$proc_data){
  488.     //             if(array_key_exists($processus->getId(),$proc_data)){
  489.     //                 $proc_data[$processus->getId()]['selected']=true;
  490.     //                 $processus_data[$key] = $proc_data;
  491.     //             }
  492.     //         }
  494.     //         foreach($jobs_data as $key=>$job_data){
  495.     //             if(array_key_exists($job->getId(),$job_data)){
  496.     //                 $job_data[$job->getId()]['selected']=true;
  497.     //                 $jobs_data[$key] = $job_data;
  498.     //             }
  499.     //         }
  500.             
  501.     //     }
  503.         
  504.         
  505.     //     $filters=[
  506.     //         'user_data'=>$user_data,
  507.     //         'processus_data'=>$processus_data,
  508.     //         'jobs_data'=>$jobs_data,
  509.     //         'missions_data'=>$missions_data,
  511.     //     ];
  513.         
  514.     //     return new JsonResponse($filters);
  515.     // }
  518.     // /**
  519.     //  * @Route("/datatableLocationFilter", name="datatableLocationFilter", methods={"POST"})
  520.     //  */
  521.     // public function datatableLocationFilter(Request $request): Response
  522.     // {
  523.         
  524.     //     $em=$this->getDoctrine();
  525.     //     $processus_id= intval($request->request->get('processus_id'));
  526.     //     $location_id= intval($request->request->get('location_id'));
  527.     //     $zone_id= intval($request->request->get('zone_id'));
  528.     //     $user_id= intval($request->request->get('user_id'));
  529.         
  530.     //     $user_data='';
  531.     //     $processus_list=[];
  532.     //     $processus_data=[];
  533.     //     $locations_list=[];
  534.     //     $locations_data=[];
  535.     //     $zones_list=[];
  536.     //     $zones_data=[];
  537.     //     if($user_id){
  538.     //         $user_data = $user_id;
  539.     //         $user=$em->getRepository(User::class)->find($user_id);
  540.     //         $processus_list=$em->getRepository(Processus::class)->findBy(['pilote'=>$user]);
  541.     //         foreach($processus_list as $proc){
  542.                 
  544.     //             if($proc->getPilote()==$user){
  545.     //                 $selected_processus = false;
  546.     //                 if($proc->getId()==$processus_id){
  547.     //                     $selected_processus=true;
  548.     //                 }
  549.     //                 $processus_data[][$proc->getId()]=[
  550.     //                     "id"=>$proc->getId(),
  551.     //                     "title"=>$proc->getTitle(),
  552.     //                     "selected"=>$selected_processus
  553.     //                 ];
  554.     //             }
  555.     //         }
  556.     //     }else {
  557.     //         $processus_list=$em->getRepository(Processus::class)->findAll();
  558.     //         foreach($processus_list as $proc){
  559.     //             $selected_processus = false;
  560.     //             if($proc->getId()==$processus_id){
  561.     //                 $selected_processus=true;
  562.     //             }
  563.     //             $processus_data[][$proc->getId()]=[
  564.     //                 "id"=>$proc->getId(),
  565.     //                 "title"=>$proc->getTitle(),
  566.     //                 "selected"=>$selected_processus
  567.     //             ];
  568.     //         }
  569.     //     }
  571.         
  573.     //     if($processus_id){
  574.             
  575.     //         $processus=$em->getRepository(Processus::class)->find($processus_id);
  576.     //         $user_data = $processus->getPilote()->getId();
  577.     //         $locations_list=$em->getRepository(Location::class)->findBy(['processus'=>$processus]);
  578.     //         foreach($locations_list as $location){
  579.     //             if($location->getProcessus()==$processus){
  580.     //                 $selected_location = false;
  581.     //                 if($location->getId()==$location_id){
  582.     //                     $selected_location=true;
  583.     //                 }
  584.     //                 $locations_data[][$location->getId()]=[
  585.     //                     "id"=>$location->getId(),
  586.     //                     'title'=>$location->getName(),
  587.     //                     'selected'=>$selected_location
  588.     //                 ];
  589.     //             }
  590.     //         }
  591.     //     }else if($user_id){
  592.     //         foreach($processus_list as $processus) {
  593.     //             $locations_list=$em->getRepository(Location::class)->findBy(['processus'=>$processus]);
  594.     //             foreach($locations_list as $location){
  595.     //                 if($location->getProcessus()==$processus){
  596.     //                     $selected_location = false;
  597.     //                     if($location->getId()==$location_id){
  598.     //                         $selected_location=true;
  599.     //                     }
  600.     //                     $locations_data[][$location->getId()]=[
  601.     //                         "id"=>$location->getId(),
  602.     //                         'title'=>$location->getName(),
  603.     //                         'selected'=>$selected_location
  604.     //                     ];
  605.     //                 }
  606.     //             }
  607.     //         }
  608.     //     }
  609.     //     else {
  610.     //         $locations_list=$em->getRepository(Location::class)->findAll();
  611.     //         foreach($locations_list as $location){
  612.     //             $selected_location = false;
  613.     //             if($location->getId()==$location_id){
  614.     //                 $selected_location=true;
  615.     //             }
  616.     //             $locations_data[][$location->getId()]=[
  617.     //                 "id"=>$location->getId(),
  618.     //                 'title'=>$location->getName(),
  619.     //                 'selected'=>$selected_location
  620.     //             ];
  621.     //         }
  622.     //     }
  623.         
  624.     //     if($location_id){
  625.             
  626.     //         $location=$em->getRepository(Location::class)->find($location_id);
  627.     //         $user_data = $location->getProcessus()->getPilote()->getId();
  628.     //         if(!$processus_id)
  629.     //         {
  630.     //             $processus_id=$location->getProcessus()->getId();
  631.     //             foreach($processus_data as $key=>$proc_data){
  632.     //                 if(array_key_exists($processus_id,$proc_data)){
  633.                         
  634.     //                     $proc_data[$processus_id]['selected']=true;
  635.     //                     $processus_data[$key] = $proc_data;
  636.     //                 }
  637.     //             }
  638.     //         }
  639.     //         $zones_list=$em->getRepository(Zone::class)->findBy(['location'=>$location]);
  640.     //         foreach($zones_list as $zone){
  641.                 
  642.     //             if($zone->getLocation()==$location){
  643.     //                 $selected_zone = false;
  644.     //                 if($zone->getId()==$zone_id){
  645.     //                     $selected_zone=true;
  646.     //                 }
  647.     //                 $zones_data[][$zone->getId()]=[
  648.     //                     "id"=>$zone->getId(),
  649.     //                     'title'=>$zone->getName(),
  650.     //                     'selected'=>$selected_zone
  651.     //                 ];
  652.     //             }
  653.     //         }
  654.     //     }else {
  655.             
  656.     //         foreach($locations_list as $location)
  657.     //         {
  658.     //             $zones_list=$em->getRepository(Zone::class)->findBy(['location'=>$location]);
  659.     //             foreach($zones_list as $zone){
  660.     //                 if($zone->getLocation()==$location){
  661.     //                     $selected_zone = false;
  662.     //                     if($zone->getId()==$zone_id){
  663.     //                         $selected_zone=true;
  664.     //                     }
  665.     //                     $zones_data[][$zone->getId()]=[
  666.     //                         "id"=>$zone->getId(),
  667.     //                         'title'=>$zone->getName(),
  668.     //                         'selected'=>$selected_zone
  669.     //                     ];
  670.     //                 }
  671.     //             }
  672.     //         }
  673.             
  674.     //     }
  676.     //     if($zone_id && !$location_id && !$processus_id && !$user_id){
  677.     //         $zone = $em->getRepository(Zone::class)->find($zone_id);
  678.     //         $location = $zone->getLocation();
  679.     //         $processus = $location->getProcessus();
  680.     //         $user = $processus->getPilote();
  682.     //         $user_data = $user->getId();
  683.             
  684.     //         foreach($processus_data as $key=>$proc_data){
  685.     //             if(array_key_exists($processus->getId(),$proc_data)){
  686.     //                 $proc_data[$processus->getId()]['selected']=true;
  687.     //                 $processus_data[$key] = $proc_data;
  688.     //             }
  689.     //         }
  691.     //         foreach($locations_data as $key=>$location_data){
  692.     //             if(array_key_exists($location->getId(),$location_data)){
  693.     //                 $location_data[$location->getId()]['selected']=true;
  694.     //                 $locations_data[$key] = $location_data;
  695.     //             }
  696.     //         }
  697.             
  698.     //     }
  700.         
  701.         
  702.     //     $filters=[
  703.     //         'user_data'=>$user_data,
  704.     //         'processus_data'=>$processus_data,
  705.     //         'locations_data'=>$locations_data,
  706.     //         'zones_data'=>$zones_data,
  708.     //     ];
  710.         
  711.     //     return new JsonResponse($filters);
  712.     // }
  715. }