src/Controller/ResourcesController.php line 26

  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 = $doctrine->getRepository(GroupAncestorDetails::class)->findBy(['groupTypeName' => 'Place'], ['groupLevelId' => 'ASC']);
  29.         $typeResources = $doctrine->getRepository(GroupAncestorDetails::class)->findBy(['groupTypeName' => 'Type'], ['groupLevelId' => 'ASC']);
  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.             'groupName' => $translator->trans("All sites"),
  38.             "groupId" => -999,
  39.             "ancestorGroupId" => -999,
  40.             "groupLevelId" => 0,
  41.             "groupLevelName" => "Site",
  42.             "groupTypeName" => "Localisation"
  43.         ];
  44.         array_push($allSites,...array_map(function($item) {
  45.             if ($item['ancestorGroupId'] == $item['groupId']) {
  46.                 $item['groupId'] = -999;
  47.             }
  48.             return $item;
  49.         },Json_decode($serializer->serialize($localisations, 'json'), true)));
  51.         foreach ($allSites as $item) {
  52.             if ($item['ancestorGroupId'] == $item['groupId']) {
  53.                 $localisationsTree[] = array(
  54.                     'name' => $item['groupName'],
  55.                     'value' => $item['ancestorGroupId'],
  56.                     'children' => array(),
  57.                 );
  58.             } else {
  59.                 $this->buildTree($localisationsTree,$item,'localisation');
  60.             }
  61.         }
  62.         $typeResourcesTree = [];
  63.         $allTypeResources[] = [
  64.             'groupName' => $translator->trans("All resources"),
  65.             "groupId" => -999,
  66.             "ancestorGroupId" => -999,
  67.             "groupLevelId" => 0,
  68.             "groupLevelName" => "Site",
  69.             "groupTypeName" => "Localisation"
  70.         ];
  71.         
  72.         array_push($allTypeResources,...array_map(function($item) {
  73.             if ($item['ancestorGroupId'] == $item['groupId']) {
  74.                 $item['groupId'] = -999;
  75.             }
  76.             return $item;
  77.         },Json_decode($serializer->serialize($typeResources, 'json'), true)));
  79.         foreach ($allTypeResources as $item) {
  80.             if ($item['ancestorGroupId'] == $item['groupId']) {
  81.                 $typeResourcesTree[] = array(
  82.                     'name' => $item['groupName'],
  83.                     'value' => $item['ancestorGroupId'],
  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.         
  102.     // Fonction récursive pour construire l'arbre
  103.     function buildTree(&$parents, $item, $type, $checked = false)
  104.     {
  105.         foreach ($parents as &$parent) {
  106.             if (isset($parent['value']) && $parent['value'] == $item['groupId']) {
  107.                 // Ajouter l'objet enfant au tableau children de l'objet principal correspondant
  108.                 $parent['children'][] = array(
  109.                     'name' => $item['groupName'],
  110.                     'value' => $item['ancestorGroupId'],
  111.                     'children' => array(),
  112.                 );
  113.             } else {
  114.                 $this->buildTree($parent['children'],$item,$type);
  115.             }
  116.         }
  117.     }
  118.     
  119.     #[Route('/get-reservation', name: 'getReservation')]
  120.     public function getReservation(ManagerRegistry $doctrine, Request $request, TranslatorInterface $translator): Response
  121.     {
  122.         $reservation = $doctrine->getRepository(OccupationPerHour::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'));
  123.         return new JsonResponse([
  124.             'totalReservations' => $reservation[0]['value'],
  125.         ]);
  126.     } 
  127.     #[Route('/get-status', name: 'getStatus')]
  128.     public function getStatus(ManagerRegistry $doctrine, Request $request, TranslatorInterface $translator): Response
  129.     {
  130.         $status = $doctrine->getRepository(OccupationPerHour::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');
  131.         foreach ($status as $key => $value) {
  132.             $status[$key]['item'] =  $translator->trans($value['item']);
  133.         }
  134.         return new JsonResponse([
  135.             'reservationStatus' => $status,
  136.         ]);
  137.     }
  138.     #[Route('/get-origin', name: 'getOrigin')]
  139.     public function getOrigin(ManagerRegistry $doctrine, Request $request, TranslatorInterface $translator): Response
  140.     {
  141.         $origins = $doctrine->getRepository(OccupationPerHour::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');
  142.         foreach ($origins as $key => $value) {
  143.             $origins[$key]['item'] =  $translator->trans($value['item']);
  144.         }
  145.         return new JsonResponse([
  146.             'reservationOrigin' => $origins,
  147.         ]);
  148.     }
  149.     #[Route('/get-immediate', name: 'getImmediate')]
  150.     public function getImmediate(ManagerRegistry $doctrine, Request $request, TranslatorInterface $translator): Response
  151.     {
  152.         $immediate = $doctrine->getRepository(OccupationPerHour::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');
  153.         //Translate immadiateUse
  154.         foreach ($immediate as $key => $value) {
  155.             $immediate[$key]['item'] =  $translator->trans($value['item']);
  156.         }
  157.         return new JsonResponse([
  158.             'immediateReservation' => $immediate,
  159.         ]);
  160.     }
  161.     #[Route('/get-type-site', name: 'getTypeSite')]
  162.     public function getTypeSite(ManagerRegistry $doctrine, Request $request, TranslatorInterface $translator): Response
  163.     {
  164.         $resourceBySite = $doctrine->getRepository(OccupationPerHour::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');
  165.         return new JsonResponse([
  166.             'resourceBySite' => $resourceBySite,
  167.         ]);
  168.     }
  169.     #[Route('/get-by-stage', name: 'getByStage')]
  170.     public function getByStage(ManagerRegistry $doctrine, Request $request, TranslatorInterface $translator): Response
  171.     {
  172.         $resourceByStage = $doctrine->getRepository(OccupationPerHour::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');
  173.         return new JsonResponse([
  174.             'resourceByStage' => $resourceByStage,
  175.         ]);
  176.     }
  177.     #[Route('/get-without-site', name: 'getWithoutSite')]
  178.     public function getWithoutSite(ManagerRegistry $doctrine, Request $request, TranslatorInterface $translator): Response
  179.     {
  180.         $resourceByStackingDiagram = $doctrine->getRepository(OccupationPerHour::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');
  181.         $resourceByStackingType=[];
  182.         $resourceWithoutSite=[];
  183.         foreach ($resourceByStackingDiagram as $item) {
  184.             $site = $item['site'];
  185.             $value = $item['value'];
  186.             $itemName = $item['item'];
  187.             if(!isset($resourceByStackingType[$site])){
  188.                 $resourceByStackingType[$site]['site'] = $site;
  189.             }
  190.             $resourceByStackingType[$site][$itemName] = $value;
  191.             $resourceWithoutSite[$itemName] = $value;
  192.         }
  193.         $resourceByStackingType = array_values($resourceByStackingType);
  194.         return new JsonResponse([
  195.             'resourceByStackingDiagram' => $resourceByStackingType,
  196.             'resourceWithoutSite' => $resourceWithoutSite,
  197.         ]);
  198.     }
  199.     #[Route('/get-type-zone', name: 'getByZone')]
  200.     public function getTypeZone(ManagerRegistry $doctrine, Request $request, TranslatorInterface $translator): Response
  201.     {
  202.         $resourceByZone = $doctrine->getRepository(OccupationPerHour::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');
  203.         return new JsonResponse([
  204.             'resourceByZone' => $resourceByZone,
  205.         ]);
  206.     }
  207.     #[Route('/get-by-type', name: 'getByType')]
  208.     public function getByType(ManagerRegistry $doctrine, Request $request, TranslatorInterface $translator): Response
  209.     {
  210.         $resourceByType = $doctrine->getRepository(OccupationPerHour::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');
  211.         return new JsonResponse([
  212.             'resourceByType' => $resourceByType,
  213.         ]);
  214.     }
  216.     #[Route('/get-creneau', name: 'getCreneau')]
  217.     public function getCreneau(ManagerRegistry $doctrine, Request $request): Response
  218.     {
  219.         $topResources = $doctrine->getRepository(Reservation::class)->findReservationByFilters($request->request->get('resource'),$request->request->get('resourceType'), $request->request->get('localisation'), $request->request->get('user'), $request->request->get('startDate'), $request->request->get('endDate'),$request->request->get('status'), $request->getLocale(),'ressource',5);
  220.         $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'),$request->request->get('status'));
  221.         $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'),$request->request->get('status'));
  222.         $findResourceByDates = $doctrine->getRepository(Resource::class)->findResourceByDates($request->request->get('startDate'), $request->request->get('endDate'),$request->request->get('localisation'), $request->request->get('resourceType'),$request->request->get('resource'));
  224.         $tauxOccupation = [];
  225.         $resourceDispoTotal = 0;
  226.         $totalReservation = 0;
  228.         $interval = new \DateInterval('PT30M');
  229.         foreach ($findResourceByDates as $item) {
  230.             
  231.             $currentHour = new \DateTime($item['open']);
  232.             $endHour = new \DateTime($item['close']);
  234.             while ($currentHour < $endHour) {
  235.                 if (in_array($currentHour->format('H:i'),array_column($tauxOccupation,'hour'))) {
  236.                     $index = array_search($currentHour->format('H:i'),array_column($tauxOccupation,'hour'));
  237.                     $tauxOccupation[$index]['resourceDispo'] += $item['count'];
  238.                 }else {
  239.                     $tauxOccupation[] = [
  240.                         'hour' => $currentHour->format('H:i'),
  241.                         'reservation' => 0,
  242.                         'reservation_reel' => 0,
  243.                         'resourceDispo' => $item['count'],
  244.                         'tauxOccupation' => 0,
  245.                         'tauxOccupationReal' => 0
  246.                     ];
  247.                 }
  248.                 $resourceDispoTotal += $item['count'];
  250.                 $currentHour->add($interval);
  251.             }
  252.         }
  253.         foreach ($creneau as $item) {
  254.             $index = array_search($item['hour'],array_column($tauxOccupation,'hour'));
  255.             
  256.             $tauxOccupation[$index]['reservation'] += $item['value'];
  257.             $tauxOccupation[$index]['reservation_reel'] += $item['value_reel'];
  258.             $tauxOccupation[$index]['tauxOccupation'] =  round(($tauxOccupation[$index]['reservation'] * 100) / $tauxOccupation[$index]['resourceDispo'],2);
  259.             $tauxOccupation[$index]['tauxOccupationReal'] =  round(($tauxOccupation[$index]['reservation_reel'] * 100) / $tauxOccupation[$index]['resourceDispo'],2);
  261.             $totalReservation += $item['value'];
  262.         }
  264.         $tauxOccupationTotal = 0;
  265.         if ($resourceDispoTotal > 0)
  266.             $tauxOccupationTotal = round(($totalReservation * 100) / $resourceDispoTotal,2);
  268.         array_multisort(array_column($tauxOccupation, 'hour'), SORT_ASC, $tauxOccupation);
  270.         return new JsonResponse([
  271.             'reservationByDay' => $reservationByDay,
  272.             'topResources' => $topResources,
  273.             'tauxOccupation' => $tauxOccupation,
  274.             'tauxOccupationTotal' => round($tauxOccupationTotal, 2)
  275.         ]);
  276.     }
  278.     public function getBlock() {
  279.         
  280.         //Blocages
  281.         $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'));
  282.         $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');
  283.         $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');
  284.         $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());
  285.         $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'));
  286.         return new JsonResponse([
  287.             'totalBlocks' => sizeof($blocages),
  288.             'blockBySite' => $blockBySite,
  289.             'blockByTypeResource' => $blockByTypeResource,
  290.             'blockByType' => $blockByType,
  291.             'blockByDates' => $blockByDates
  292.         ]);
  293.     }
  294.     #[Route('/getResourcesByFilters', name: 'getResourcesByFilters')]
  295.     public function getResourcesByFilters(ManagerRegistry $doctrine, Request $request): Response
  296.     {
  297.         $resources = $doctrine->getRepository(Resource::class)->findGroupped($request->request->get('localisation'),$request->request->get('resourceType'));
  298.         return $this->render('components/resources-options.html.twig', [
  299.             'resources' => $resources,
  300.         ]);
  301.     }
  302.     #[Route('/getResourceByDates', name: 'getResourceByDates')]
  303.     public function getResourceByDates(ManagerRegistry $doctrine, Request $request): Response
  304.     {
  305.         $resources = $doctrine->getRepository(Resource::class)->getResourceByDates($request->request->get('localisation'),$request->request->get('resourceType'));
  306.         return $this->render('components/resources-options.html.twig', [
  307.             'resources' => $resources,
  308.         ]);
  309.     }
  310. }