src/Controller/ResourcesController.php line 29

  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\Block;
  6. use App\Entity\General;
  7. use App\Entity\User;
  8. use App\Entity\Status;
  9. use App\Entity\Resource;
  10. use App\Entity\Reservation;
  11. use App\Entity\OccupationPerHour;
  12. use App\Entity\GroupAncestorDetails;
  13. use Doctrine\Persistence\ManagerRegistry;
  14. use Symfony\Component\Serializer\Serializer;
  15. use Symfony\Component\HttpFoundation\Request;
  16. use Symfony\Component\HttpFoundation\Response;
  17. use Symfony\Component\Routing\Annotation\Route;
  18. use Symfony\Component\HttpFoundation\JsonResponse;
  19. use Symfony\Component\Serializer\SerializerInterface;
  20. use Symfony\Contracts\Translation\TranslatorInterface;
  21. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  23. class ResourcesController extends AbstractController
  24. {
  25.     #[Route('/', name: 'app_default')]
  26.     public function index(ManagerRegistry $doctrine, SerializerInterface $serializer, Request $request,TranslatorInterface $translator): Response
  27.     {
  28.         $localisations = Json_decode($serializer->serialize($doctrine->getRepository(GroupAncestorDetails::class)->findBy(['groupTypeName' => 'Localisation'], ['groupLevelId' => 'ASC']), 'json',['groups' => 'groupAncestor']),true);
  29.         $typeResources = Json_decode($serializer->serialize($doctrine->getRepository(GroupAncestorDetails::class)->findBy(['groupTypeName' => 'Type'], ['groupLevelId' => 'ASC']), 'json',['groups' => 'groupAncestor']),true);
  30.         $status = $doctrine->getRepository(Status::class)->findAllStatus($request->getLocale());
  31.         $users = $doctrine->getRepository(User::class)->findUsers();
  32.         $general = $doctrine->getRepository(General::class)->find(1);
  33.         $resources = $doctrine->getRepository(Resource::class)->findGroupped();
  35.         $localisationsTree = [];
  36.         $allSites[] = [
  37.             "id" => -999,
  38.             "groupAncestorId" => -999,
  39.             "groupName" => $translator->trans("All sites"),
  40.             "groupLevelId" => 0,
  41.             "groupLevelName" => "Site",
  42.             "groupTypeName" => "Localisation"
  43.         ];
  44.         array_push($allSites,...array_map(function($item) {
  45.             if ($item['id'] == $item['groupAncestorId']) {
  46.                 $item['groupAncestorId'] = -999;
  47.             }
  48.             return $item;
  49.         },$localisations));
  51.         foreach ($allSites as $item) {
  52.             if ($item['id'] == $item['groupAncestorId']) {
  53.                 $localisationsTree[] = array(
  54.                     'name' => $item['groupName'],
  55.                     'value' => $item['id'],
  56.                     'children' => array(),
  57.                 );
  58.             } else {
  59.                 $this->buildTree($localisationsTree,$item,'localisation');
  60.             }
  61.         }
  62.         $typeResourcesTree = [];
  63.         $allTypeResources[] = [
  64.             "id" => -999,
  65.             "groupAncestorId" => -999,
  66.             "groupName" => $translator->trans("All resources"),
  67.             "groupLevelId" => 0,
  68.             "groupLevelName" => "Type",
  69.             "groupTypeName" => "Type"
  70.         ];
  71.         
  72.         array_push($allTypeResources,...array_map(function($item) {
  73.             if ($item['id'] == $item['groupAncestorId']) {
  74.                 $item['groupAncestorId'] = -999;
  75.             }
  76.             return $item;
  77.         },$typeResources));
  79.         foreach ($allTypeResources as $item) {
  80.             if ($item['id'] == $item['groupAncestorId']) {
  81.                 $typeResourcesTree[] = array(
  82.                     'name' => $item['groupName'],
  83.                     'value' => $item['id'],
  84.                     'children' => array(),
  85.                 );
  86.             } else {
  87.                 $this->buildTree($typeResourcesTree,$item,'resourceType',true);
  88.             }
  89.         }
  90.         return $this->render('statistiques/resources.html.twig', [
  91.             'localisationsTree' => $localisationsTree,
  92.             'typeResourcesTree' => $typeResourcesTree,
  93.             'typeResources' => $typeResources,
  94.             'localisations' => $localisations,
  95.             'resources' => $resources,
  96.             'users' => $users,
  97.             'status' => $status,
  98.             'general' => $general,
  99.         ]);
  100.     }
  101.     // Fonction récursive pour construire l'arbre
  102.     function buildTree(&$parents, $item, $type, $checked = false)
  103.     {
  104.         foreach ($parents as &$parent) {
  105.             if (isset($parent['value']) && $parent['value'] == $item['groupAncestorId']) {
  106.                 // Ajouter l'objet enfant au tableau children de l'objet principal correspondant
  107.                 $parent['children'][] = array(
  108.                     'name' => $item['groupName'],
  109.                     'value' => $item['id'],
  110.                     'children' => array(),
  111.                 );
  112.             } else {
  113.                 $this->buildTree($parent['children'],$item,$type);
  114.             }
  115.         }
  116.     }
  117.     #[Route('/get-reservation', name: 'getReservation')]
  118.     public function getReservation(ManagerRegistry $doctrine, Request $request, TranslatorInterface $translator): Response
  119.     {
  120.         $reservation = $doctrine->getRepository(Reservation::class)->findByFilter( $request->request->get('localisation'), $request->request->get('user'), $request->request->get('startDate'), $request->request->get('endDate'),$request->request->get('status'), $request->getLocale(),$request->request->get('resource'),$request->request->get('resourceType'));
  121.         return new JsonResponse([
  122.             'totalReservations' => $reservation[0]['value'],
  123.         ]);
  124.     } 
  125.     #[Route('/get-status', name: 'getStatus')]
  126.     public function getStatus(ManagerRegistry $doctrine, Request $request, TranslatorInterface $translator): Response
  127.     {
  128.         $status = $doctrine->getRepository(Reservation::class)->findByFilter( $request->request->get('localisation'), $request->request->get('user'), $request->request->get('startDate'), $request->request->get('endDate'),$request->request->get('status'), $request->getLocale(),$request->request->get('resource'),$request->request->get('resourceType'),'status');
  129.         foreach ($status as $key => $value) {
  130.             $status[$key]['item'] =  $translator->trans($value['item']);
  131.         }
  132.         return new JsonResponse([
  133.             'reservationStatus' => $status,
  134.         ]);
  135.     }
  136.     #[Route('/get-origin', name: 'getOrigin')]
  137.     public function getOrigin(ManagerRegistry $doctrine, Request $request, TranslatorInterface $translator): Response
  138.     {
  139.         $origins = $doctrine->getRepository(Reservation::class)->findByFilter( $request->request->get('localisation'), $request->request->get('user'), $request->request->get('startDate'), $request->request->get('endDate'),$request->request->get('status'), $request->getLocale(),$request->request->get('resource'),$request->request->get('resourceType'),'origin');
  140.         foreach ($origins as $key => $value) {
  141.             $origins[$key]['item'] =  $translator->trans($value['item']);
  142.         }
  143.         return new JsonResponse([
  144.             'reservationOrigin' => $origins,
  145.         ]);
  146.     }
  147.     #[Route('/get-immediate', name: 'getImmediate')]
  148.     public function getImmediate(ManagerRegistry $doctrine, Request $request, TranslatorInterface $translator): Response
  149.     {
  150.         $immediate = $doctrine->getRepository(Reservation::class)->findByFilter( $request->request->get('localisation'), $request->request->get('user'), $request->request->get('startDate'), $request->request->get('endDate'),$request->request->get('status'), $request->getLocale(),$request->request->get('resource'),$request->request->get('resourceType'),'immediat_use');
  151.         //Translate immadiateUse
  152.         foreach ($immediate as $key => $value) {
  153.             $immediate[$key]['item'] =  $translator->trans($value['item']);
  154.         }
  155.         return new JsonResponse([
  156.             'immediateReservation' => $immediate,
  157.         ]);
  158.     }
  159.     #[Route('/get-type-site', name: 'getTypeSite')]
  160.     public function getTypeSite(ManagerRegistry $doctrine, Request $request, TranslatorInterface $translator): Response
  161.     {
  162.         $resourceBySite = $doctrine->getRepository(Reservation::class)->findByFilter( $request->request->get('localisation'), $request->request->get('user'), $request->request->get('startDate'), $request->request->get('endDate'),$request->request->get('status'), $request->getLocale(),$request->request->get('resource'),$request->request->get('resourceType'),'resourceBySite',10);
  163.         return new JsonResponse([
  164.             'resourceBySite' => $resourceBySite,
  165.         ]);
  166.     }
  167.     #[Route('/get-by-stage', name: 'getByStage')]
  168.     public function getByStage(ManagerRegistry $doctrine, Request $request, TranslatorInterface $translator): Response
  169.     {
  170.         $resourceByStage = $doctrine->getRepository(Reservation::class)->findByFilter( $request->request->get('localisation'), $request->request->get('user'), $request->request->get('startDate'), $request->request->get('endDate'),$request->request->get('status'), $request->getLocale(),$request->request->get('resource'),$request->request->get('resourceType'),'resourceByStage');
  171.         $resourceByStage = array_reduce($resourceByStage, function ($carry, $item) use ($translator) {
  172.             // Vérifiez si l'élément existe déjà dans le tableau de regroupement
  173.             $key = $item["item"];
  174.             if (!array_key_exists($key, $carry)) {
  175.                 $carry[$key] = ["item" => $key, $translator->trans('Refused') => 0, $translator->trans("Cancelled") => 0, $translator->trans("Pending") => 0, $translator->trans("Confirmed") => 0];
  176.             }
  177.             
  178.             // Incrémentez le total du statut correspondant
  179.             if ($item['status'] == -1)
  180.                 $carry[$key][$translator->trans("Refused")] += $item["value"];
  181.             else if ($item['status'] == 0)
  182.                 $carry[$key][$translator->trans("Cancelled")] += $item["value"];
  183.             else if ($item['status'] == 1)
  184.                 $carry[$key][$translator->trans("Pending")] += $item["value"];
  185.             else
  186.                 $carry[$key][$translator->trans("Confirmed")] += $item["value"];
  187.             
  188.             return $carry;
  189.         }, []);
  191.         return new JsonResponse([
  192.             'resourceByStage' => array_values($resourceByStage),
  193.         ]);
  194.     }
  195.     #[Route('/get-without-site', name: 'getWithoutSite')]
  196.     public function getWithoutSite(ManagerRegistry $doctrine, Request $request, TranslatorInterface $translator): Response
  197.     {
  198.         $resourceByStackingDiagram = $doctrine->getRepository(Reservation::class)->findByFilter( $request->request->get('localisation'), $request->request->get('user'), $request->request->get('startDate'), $request->request->get('endDate'),$request->request->get('status'), $request->getLocale(),$request->request->get('resource'),$request->request->get('resourceType'),'resourceByType');
  199.         $resourceByStackingType=[];
  200.         $resourceWithoutSite=[];
  201.         foreach ($resourceByStackingDiagram as $item) {
  202.             $site = $item['site'];
  203.             $value = $item['value'];
  204.             $itemName = $item['item'];
  205.             if(!isset($resourceByStackingType[$site])){
  206.                 $resourceByStackingType[$site]['item'] = $site;
  207.             }
  208.             $resourceByStackingType[$site][$itemName] = $value;
  209.             $resourceWithoutSite[$itemName] = $value;
  210.         }
  211.         $resourceByStackingType = array_values($resourceByStackingType);
  212.         return new JsonResponse([
  213.             'resourceByStackingDiagram' => $resourceByStackingType,
  214.             'resourceWithoutSite' => $resourceWithoutSite,
  215.         ]);
  216.     }
  217.     #[Route('/get-type-zone', name: 'getByZone')]
  218.     public function getTypeZone(ManagerRegistry $doctrine, Request $request, TranslatorInterface $translator): Response
  219.     {
  220.         $resourceByZone = $doctrine->getRepository(Reservation::class)->findByFilter( $request->request->get('localisation'), $request->request->get('user'), $request->request->get('startDate'), $request->request->get('endDate'),$request->request->get('status'), $request->getLocale(),$request->request->get('resource'),$request->request->get('resourceType'),'resourceByZone');
  221.         return new JsonResponse([
  222.             'resourceByZone' => $resourceByZone,
  223.         ]);
  224.     }
  225.     #[Route('/get-by-type', name: 'getByType')]
  226.     public function getByType(ManagerRegistry $doctrine, Request $request, TranslatorInterface $translator): Response
  227.     {
  228.         $resourceByType = $doctrine->getRepository(Reservation::class)->findByFilter( $request->request->get('localisation'), $request->request->get('user'), $request->request->get('startDate'), $request->request->get('endDate'),$request->request->get('status'), $request->getLocale(),$request->request->get('resource'),$request->request->get('resourceType'),'resourceByType');
  229.         return new JsonResponse([
  230.             'resourceByType' => $resourceByType,
  231.         ]);
  232.     }
  234.     #[Route('/get-creneau', name: 'getCreneau')]
  235.     public function getCreneau(ManagerRegistry $doctrine, Request $request,TranslatorInterface $translator): Response
  236.     {
  237.         $weekDays = [
  238.             1 => 'Lundi',
  239.             2 => 'Mardi',
  240.             3 => 'Mercredi',
  241.             4 => 'Jeudi',
  242.             5 => 'Vendredi',
  243.             6 => 'Samedi',
  244.             7 => 'Dimanche',
  245.         ];
  246.         $topResources = $doctrine->getRepository(Reservation::class)->findByFilter( $request->request->get('localisation'), $request->request->get('user'), $request->request->get('startDate'), $request->request->get('endDate'),$request->request->get('status'), $request->getLocale(),$request->request->get('resource'),$request->request->get('resourceType'),'resources',5);
  247.         $topResources = array_reduce($topResources, function ($carry, $item) use ($translator) {
  248.             // Vérifiez si l'élément existe déjà dans le tableau de regroupement
  249.             $key = $item["item"];
  250.             if (!array_key_exists($key, $carry)) {
  251.                 $carry[$key] = ["item" => $key, $translator->trans('Refused') => 0, $translator->trans("Cancelled") => 0, $translator->trans("Pending") => 0, $translator->trans("Confirmed") => 0];
  252.             }
  253.             
  254.             // Incrémentez le total du statut correspondant
  255.             if ($item['status'] == -1)
  256.                 $carry[$key][$translator->trans("Refused")] += $item["value"];
  257.             else if ($item['status'] == 0)
  258.                 $carry[$key][$translator->trans("Cancelled")] += $item["value"];
  259.             else if ($item['status'] == 1)
  260.                 $carry[$key][$translator->trans("Pending")] += $item["value"];
  261.             else
  262.                 $carry[$key][$translator->trans("Confirmed")] += $item["value"];
  263.             
  264.             return $carry;
  265.         }, []);
  266.         asort($topResources);
  268.         $creneau = $doctrine->getRepository(OccupationPerHour::class)->findCreneau($request->request->get('resource'),$request->request->get('resourceType'), $request->request->get('localisation'), $request->request->get('startDate'), $request->request->get('endDate'), $request->request->get('user'),2);
  269.         $reservationByDay = $doctrine->getRepository(OccupationPerHour::class)->findReservationByDay($request->request->get('resource'),$request->request->get('resourceType'), $request->request->get('localisation'), $request->request->get('startDate'), $request->request->get('endDate'), $request->request->get('user'),2);
  270.         $findResourceByDatesTime = $doctrine->getRepository(Resource::class)->findResourceByDatesTimes($request->request->get('startDate'), $request->request->get('endDate'),$request->request->get('localisation'), $request->request->get('resourceType'),$request->request->get('resource'));
  272.         $tauxOccupation = [];
  273.         $tauxOccupationByDate = [];
  274.         $resourceDispoTotal = 0;
  275.         $totalReservation = 0;
  277.         $interval = new \DateInterval('PT30M');
  278.         foreach ($findResourceByDatesTime as $item) {
  279.             
  280.             $currentHour = new \DateTime($item['open']);
  281.             $endHour = new \DateTime($item['close']);
  283.             while ($currentHour < $endHour) {
  284.                 if (in_array($currentHour->format('H:i'),array_column($tauxOccupation,'hour'))) {
  285.                     $index = array_search($currentHour->format('H:i'),array_column($tauxOccupation,'hour'));
  286.                     $tauxOccupation[$index]['resourceDispo'] += $item['count'];
  287.                 }else {
  288.                     $tauxOccupation[] = [
  289.                         'hour' => $currentHour->format('H:i'),
  290.                         'reservation' => 0,
  291.                         'reservation_reel' => 0,
  292.                         'resourceDispo' => $item['count'],
  293.                         'tauxOccupation' => 0,
  294.                         'tauxOccupationReal' => 0
  295.                     ];
  296.                 }
  297.                 
  298.                 $indexDay = null;
  299.                 foreach ($tauxOccupationByDate as $key => $value) {
  300.                     if (
  301.                         $value['date'] === $item['date'] && 
  302.                         $value['hour'] === $currentHour->format('H:i')) {
  303.                         $indexDay = $key;
  304.                         break;
  305.                     }
  306.                 }
  307.                 
  308.                 if ($indexDay) {
  309.                     $tauxOccupationByDate[$indexDay]['resourceDispo'] += $item['count'];
  310.                 }else {
  311.                     $tauxOccupationByDate[] = [
  312.                         'date' => $item['date'],
  313.                         'hour' => $currentHour->format('H:i'),
  314.                         'reservation' => 0,
  315.                         'reservation_reel' => 0,
  316.                         'resourceDispo' => $item['count'],
  317.                         'tauxOccupation' => 0,
  318.                         'tauxOccupationReal' => 0
  319.                     ];
  320.                 }
  322.                 $resourceDispoTotal += $item['count'];
  324.                 $currentHour->add($interval);
  325.             }
  326.         }
  328.         foreach ($creneau as $item) {
  329.             $indexDay = null;
  330.             foreach ($tauxOccupationByDate as $key => $value) {
  331.                 if ($value['date'] === $item['date'] && $value['hour'] === $item['hour']) {
  332.                     $indexDay = $key;
  333.                     break;
  334.                 }
  335.             }
  337.             if ($indexDay != null) {
  338.                 $tauxOccupationByDate[$indexDay]['reservation'] += $item['value'];
  339.                 $tauxOccupationByDate[$indexDay]['reservation_reel'] += $item['value_reel'];
  340.                 $tauxOccupationByDate[$indexDay]['tauxOccupation'] =  round(($tauxOccupationByDate[$indexDay]['reservation'] * 100) / $tauxOccupationByDate[$indexDay]['resourceDispo'],2);
  341.                 $tauxOccupationByDate[$indexDay]['tauxOccupationReal'] =  round(($tauxOccupationByDate[$indexDay]['reservation_reel'] * 100) / $tauxOccupationByDate[$indexDay]['resourceDispo'],2);
  343.             }
  345.             $index = array_search($item['hour'],array_column($tauxOccupation,'hour'));
  346.             $tauxOccupation[$index]['reservation'] += $item['value'];
  347.             $tauxOccupation[$index]['reservation_reel'] += $item['value_reel'];
  348.             $tauxOccupation[$index]['tauxOccupation'] =  round(($tauxOccupation[$index]['reservation'] * 100) / $tauxOccupation[$index]['resourceDispo'],2);
  349.             $tauxOccupation[$index]['tauxOccupationReal'] =  round(($tauxOccupation[$index]['reservation_reel'] * 100) / $tauxOccupation[$index]['resourceDispo'],2);
  352.             $totalReservation += $item['value'];
  353.         }
  356.         $tauxOccupationDesPickByDate = [];
  357.         foreach ($tauxOccupationByDate as $item) {
  358.             $date = (new \DateTime($item['date']))->format('Y-m-d');
  359.             if (in_array($date,array_column($tauxOccupationDesPickByDate,'date'))) {
  360.                 $index = array_search($date,array_column($tauxOccupationDesPickByDate,'date'));
  361.                 if ($tauxOccupationDesPickByDate[$index]['tauxOccupation'] < $item['tauxOccupation']) {
  362.                     $tauxOccupationDesPickByDate[$index]['tauxOccupation'] = $item['tauxOccupation'];
  363.                     $tauxOccupationDesPickByDate[$index]['tauxOccupationReal'] = $item['tauxOccupationReal'];
  364.                 };
  365.             }else {
  366.                 $tauxOccupationDesPickByDate[] = [
  367.                     'date' => $date,
  368.                     'tauxOccupation' => $item['tauxOccupation'],
  369.                     'tauxOccupationReal' => $item['tauxOccupationReal'],
  370.                 ];
  371.             }
  372.         }
  373.         $tauxOccupationDesPickByDateTotal = 0;
  374.         foreach ($tauxOccupationDesPickByDate as $item) {
  375.             $tauxOccupationDesPickByDateTotal += $item['tauxOccupation'];
  376.         }
  377.         $tauxOccupationDesPickByDateTotal = round($tauxOccupationDesPickByDateTotal / sizeof($tauxOccupationDesPickByDate),2);
  380.         
  382.         $tauxOccupationByWeekDay = [];
  383.         foreach ($tauxOccupationByDate as $item) {
  384.             $dayIndex = (new \DateTime($item['date']))->format('N');
  385.             $day = $weekDays[$dayIndex];
  386.             if (in_array($day,array_column($tauxOccupationByWeekDay,'day'))) {
  387.                 $index = array_search($day,array_column($tauxOccupationByWeekDay,'day'));
  388.                 
  389.                 $tauxOccupationByWeekDay[$index]['reservation'] += $item['reservation'];
  390.                 $tauxOccupationByWeekDay[$index]['reservation_reel'] += $item['reservation_reel'];
  391.                 $tauxOccupationByWeekDay[$index]['resourceDispo'] += $item['resourceDispo'];
  392.             }else {
  393.                 $tauxOccupationByWeekDay[] = [
  394.                     'dayIndex' => $dayIndex,
  395.                     'day' => $day,
  396.                     'reservation' => $item['reservation'],
  397.                     'reservation_reel' => $item['reservation_reel'],
  398.                     'resourceDispo' => $item['resourceDispo'],
  399.                     'tauxOccupation' => 0,
  400.                     'tauxOccupationReal' => 0
  401.                 ];
  402.             }
  403.         }
  404.         foreach ($tauxOccupationByWeekDay as $key => $value) {
  405.             $tauxOccupationByWeekDay[$key]['tauxOccupation'] = round(($value['reservation'] * 100) / $value['resourceDispo'],2);
  406.             $tauxOccupationByWeekDay[$key]['tauxOccupationReal'] = round(($value['reservation_reel'] * 100) / $value['resourceDispo'],2);
  407.         }
  409.         $openMatin = new \DateTime('09:00');
  410.         $closeMatin = new \DateTime('12:00');
  411.         $openAprem = new \DateTime('14:00');
  412.         $closeAprem = new \DateTime('17:00');
  414.         $tauxOccupationReal = array_filter($tauxOccupation,function($item) use ($openMatin, $closeMatin, $openAprem, $closeAprem) {
  415.             $hour = new \DateTime($item['hour']);
  416.             return ($hour >= $openMatin && $hour <= $closeMatin) || ($hour >= $openAprem && $hour <= $closeAprem);
  417.         });
  419.         $tauxOccupationTotal = 0;
  421.         $tauxOccupationRealTotal = 0;
  422.         $totalResourceDispo = 0;
  423.         $totalReservationDispo = 0;
  424.         foreach ($tauxOccupationReal as $obj) {
  425.             $totalReservationDispo += $obj['reservation'];
  426.             $totalResourceDispo += $obj['resourceDispo'];
  427.         }
  428.         $tauxOccupationRealTotal = round(($totalReservationDispo * 100) / $totalResourceDispo,2);
  430.         if ($resourceDispoTotal > 0)
  431.             $tauxOccupationTotal = round(($totalReservation * 100) / $resourceDispoTotal,2);
  433.         array_multisort(array_column($tauxOccupation, 'hour'), SORT_ASC, $tauxOccupation);
  434.         array_multisort(array_column($tauxOccupationReal, 'hour'), SORT_ASC, $tauxOccupationReal);
  435.         array_multisort(array_column($tauxOccupationByWeekDay, 'dayIndex'), SORT_ASC, $tauxOccupationByWeekDay);
  436.         array_multisort(array_column($tauxOccupationDesPickByDate, 'date'), SORT_ASC, $tauxOccupationDesPickByDate);
  439.         return new JsonResponse([
  440.             'reservationByDay' => $reservationByDay,
  441.             'topResources' => array_values($topResources),
  442.             'tauxOccupation' => $tauxOccupation,
  443.             'tauxOccupationByWeekDay' => $tauxOccupationByWeekDay,
  444.             'tauxOccupationDesPickByDate' => $tauxOccupationDesPickByDate,
  445.             'tauxOccupationDesPickByDateTotal' => $tauxOccupationDesPickByDateTotal,
  446.             'tauxOccupationReal' => $tauxOccupationReal,
  447.             'tauxOccupationRealTotal' => round($tauxOccupationRealTotal, 2),
  448.             'tauxOccupationTotal' => round($tauxOccupationTotal, 2)
  449.         ]);
  450.     }
  452.     public function getBlock() {
  453.         
  454.         //Blocages
  455.         $blocages = []; // $doctrine->getRepository(Block::class)->getBlockageByFilters($request->request->get('resource'),$request->request->get('resourceType'), $request->request->get('localisation'), $request->request->get('startDate'), $request->request->get('endDate'));
  456.         $blockBySite = []; // $doctrine->getRepository(Block::class)->getBlockagesGroppedByResource($request->request->get('resource'),$request->request->get('resourceType'), $request->request->get('localisation'), $request->request->get('startDate'), $request->request->get('endDate'),'Localisation');
  457.         $blockByTypeResource = []; // $doctrine->getRepository(Block::class)->getBlockagesGroppedByResource($request->request->get('resource'),$request->request->get('resourceType'), $request->request->get('localisation'), $request->request->get('startDate'), $request->request->get('endDate'),'Type');
  458.         $blockByType =  []; //$doctrine->getRepository(Block::class)->getBlockageByType($request->request->get('resource'),$request->request->get('resourceType'), $request->request->get('localisation'), $request->request->get('startDate'), $request->request->get('endDate'), $request->getLocale());
  459.         $blockByDates = []; // $doctrine->getRepository(Block::class)->getBlockByDates($request->request->get('resource'),$request->request->get('resourceType'), $request->request->get('localisation'), $request->request->get('startDate'), $request->request->get('endDate'));
  460.         return new JsonResponse([
  461.             'totalBlocks' => sizeof($blocages),
  462.             'blockBySite' => $blockBySite,
  463.             'blockByTypeResource' => $blockByTypeResource,
  464.             'blockByType' => $blockByType,
  465.             'blockByDates' => $blockByDates
  466.         ]);
  467.     }
  468.     #[Route('/getResourcesByFilters', name: 'getResourcesByFilters')]
  469.     public function getResourcesByFilters(ManagerRegistry $doctrine, Request $request): Response
  470.     {
  471.         $resources = $doctrine->getRepository(Resource::class)->findGroupped($request->request->get('localisation'),$request->request->get('resourceType'));
  472.         return $this->render('components/resources-options.html.twig', [
  473.             'resources' => $resources,
  474.         ]);
  475.     }
  476.     #[Route('/getResourceByDates', name: 'getResourceByDates')]
  477.     public function getResourceByDates(ManagerRegistry $doctrine, Request $request): Response
  478.     {
  479.         $resources = $doctrine->getRepository(Resource::class)->getResourceByDates($request->request->get('localisation'),$request->request->get('resourceType'));
  480.         return $this->render('components/resources-options.html.twig', [
  481.             'resources' => $resources,
  482.         ]);
  483.     }
  484. }