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): Response
  27.     {
  28.         $localisations = $doctrine->getRepository(GroupAncestorDetails::class)->findBy(['groupTypeName' => 'Localisation'], ['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.         foreach (Json_decode($serializer->serialize($localisations, 'json'), true) as $item) {
  37.             if ($item['ancestorGroupId'] == $item['groupId']) {
  38.                 $localisationsTree[] = array(
  39.                     'text' => $item['groupName'],
  40.                     'type' => 'localisation',
  41.                     'checked' => false,
  42.                     'id' => $item['ancestorGroupId'],
  43.                     'children' => array()
  44.                 );
  45.             } else {
  46.                 $this->buildTree($localisationsTree,$item,'localisation');
  47.             }
  48.         }
  49.         $typeResourcesTree = [];
  50.         foreach (Json_decode($serializer->serialize($typeResources, 'json'), true) as $item) {
  51.             if ($item['ancestorGroupId'] == $item['groupId']) {
  52.                 $typeResourcesTree[] = array(
  53.                     'text' => $item['groupName'],
  54.                     'type' => 'resourceType',
  55.                     'checked' => true,
  56.                     'id' => $item['ancestorGroupId'],
  57.                     'children' => array()
  58.                 );
  59.             } else {
  60.                 $this->buildTree($typeResourcesTree,$item,'resourceType',true);
  61.             }
  62.         }
  63.         return $this->render('statistiques/resources.html.twig', [
  64.             'localisationsTree' => $localisationsTree,
  65.             'typeResourcesTree' => $typeResourcesTree,
  66.             'resources' => $resources,
  67.             'users' => $users,
  68.             'status' => $status,
  69.             'general' => $general,
  70.         ]);
  71.     }
  72.         
  73.     // Fonction récursive pour construire l'arbre
  74.     function buildTree(&$parents, $item, $type, $checked = false)
  75.     {
  76.         foreach ($parents as &$parent) {
  77.             if ($parent['id'] == $item['groupId']) {
  78.                 // Ajouter l'objet enfant au tableau children de l'objet principal correspondant
  79.                 $parent['children'][] = array(
  80.                     'text' => $item['groupName'],
  81.                     'type' => $type,
  82.                     'checked' => $checked,
  83.                     'id' => $item['ancestorGroupId'],
  84.                     'children' => array()
  85.                 );
  86.             } else {
  87.                 $this->buildTree($parent['children'],$item,$type);
  88.             }
  89.         }
  90.     }
  91.     
  92.     #[Route('/get-reservation', name: 'getReservation')]
  93.     public function getReservation(ManagerRegistry $doctrine, Request $request, TranslatorInterface $translator): Response
  94.     {
  95.         $reservation = $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());
  96.         return new JsonResponse([
  97.             'totalReservations' => $reservation[0]['count'],
  98.         ]);
  99.     } 
  100.     #[Route('/get-status', name: 'getStatus')]
  101.     public function getStatus(ManagerRegistry $doctrine, Request $request, TranslatorInterface $translator): Response
  102.     {
  103.         $status = $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(),'status');
  104.         return new JsonResponse([
  105.             'reservationStatus' => $status,
  106.         ]);
  107.     }
  108.     #[Route('/get-origin', name: 'getOrigin')]
  109.     public function getOrigin(ManagerRegistry $doctrine, Request $request, TranslatorInterface $translator): Response
  110.     {
  111.         $origins = $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(),'origin');
  112.         return new JsonResponse([
  113.             'reservationOrigin' => $origins,
  114.         ]);
  115.     }
  116.     #[Route('/get-immediate', name: 'getImmediate')]
  117.     public function getImmediate(ManagerRegistry $doctrine, Request $request, TranslatorInterface $translator): Response
  118.     {
  119.         $immediate = $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(),'immediat_use');
  120.         //Translate immadiateUse
  121.         foreach ($immediate as $key => $value) {
  122.             $immediate[$key]['item'] =  $translator->trans($value['item']);
  123.         }
  124.         return new JsonResponse([
  125.             'immediateReservation' => $immediate,
  126.         ]);
  127.     }
  128.     #[Route('/get-type-site', name: 'getTypeSite')]
  129.     public function getTypeSite(ManagerRegistry $doctrine, Request $request, TranslatorInterface $translator): Response
  130.     {
  132.         $resourceByType = $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(),'resourceByType');
  133.         $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');
  134.         $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');
  135.         $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');
  136.         $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');
  137.         $resourceByStackingType=[];
  138.         $resourceWithoutSite=[];
  139.         foreach ($resourceByStackingDiagram as $item) {
  140.             $site = $item['site'];
  141.             $value = $item['value'];
  142.             $itemName = $item['item'];
  143.             if(!isset($resourceByStackingType[$site])){
  144.                 $resourceByStackingType[$site]['site'] = $site;
  145.             }
  146.             $resourceByStackingType[$site][$itemName] = $value;
  147.             $resourceWithoutSite[$itemName] = $value;
  148.         }
  150.         $resourceByStackingType = array_values($resourceByStackingType);
  151.        // $resourceByBuilding = $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'),'resourceByBuilding');
  152.       //  $resourceHasNotChildren = $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'),'hasNotChildren');
  153.         return new JsonResponse([
  154.             'resourceByType' => $resourceByType,
  155.             'resourceBySite' => $resourceBySite,
  156.             'resourceByStage' => $resourceByStage,
  157.             'resourceByStackingDiagram' => $resourceByStackingType,
  158.             'resourceWithoutSite' => $resourceWithoutSite,
  159.             'resourceByZone' => $resourceByZone
  160.         ]);
  161.     }
  163.     #[Route('/get-creneau', name: 'getCreneau')]
  164.     public function getCreneau(ManagerRegistry $doctrine, Request $request): Response
  165.     {
  166.         $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);
  167.         $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'));
  168.         $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'));
  169.         $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'));
  171.         $tauxOccupation = [];
  172.         $resourceDispoTotal = 0;
  173.         $totalReservation = 0;
  175.         $interval = new \DateInterval('PT30M');
  176.         foreach ($findResourceByDates as $item) {
  177.             
  178.             $currentHour = new \DateTime($item['open']);
  179.             $endHour = new \DateTime($item['close']);
  181.             while ($currentHour < $endHour) {
  182.                 if (in_array($currentHour->format('H:i'),array_column($tauxOccupation,'hour'))) {
  183.                     $index = array_search($currentHour->format('H:i'),array_column($tauxOccupation,'hour'));
  184.                     $tauxOccupation[$index]['resourceDispo'] += $item['count'];
  185.                 }else {
  186.                     $tauxOccupation[] = [
  187.                         'hour' => $currentHour->format('H:i'),
  188.                         'reservation' => 0,
  189.                         'reservation_reel' => 0,
  190.                         'resourceDispo' => $item['count'],
  191.                         'tauxOccupation' => 0,
  192.                         'tauxOccupationReal' => 0
  193.                     ];
  194.                 }
  195.                 $resourceDispoTotal += $item['count'];
  197.                 $currentHour->add($interval);
  198.             }
  199.         }
  200.         foreach ($creneau as $item) {
  201.             $index = array_search($item['hour'],array_column($tauxOccupation,'hour'));
  202.             
  203.             $tauxOccupation[$index]['reservation'] += $item['value'];
  204.             $tauxOccupation[$index]['reservation_reel'] += $item['value_reel'];
  205.             $tauxOccupation[$index]['tauxOccupation'] =  round(($tauxOccupation[$index]['reservation'] * 100) / $tauxOccupation[$index]['resourceDispo'],2);
  206.             $tauxOccupation[$index]['tauxOccupationReal'] =  round(($tauxOccupation[$index]['reservation_reel'] * 100) / $tauxOccupation[$index]['resourceDispo'],2);
  208.             $totalReservation += $item['value'];
  209.         }
  211.         $tauxOccupationTotal = 0;
  212.         if ($resourceDispoTotal > 0)
  213.             $tauxOccupationTotal = round(($totalReservation * 100) / $resourceDispoTotal,2);
  215.         array_multisort(array_column($tauxOccupation, 'hour'), SORT_ASC, $tauxOccupation);
  217.         return new JsonResponse([
  218.             'reservationByDay' => $reservationByDay,
  219.             'topResources' => $topResources,
  220.             'tauxOccupation' => $tauxOccupation,
  221.             'tauxOccupationTotal' => round($tauxOccupationTotal, 2)
  222.         ]);
  223.     }
  225.     public function getBlock() {
  226.         
  227.         //Blocages
  228.         $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'));
  229.         $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');
  230.         $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');
  231.         $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());
  232.         $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'));
  233.         return new JsonResponse([
  234.             'totalBlocks' => sizeof($blocages),
  235.             'blockBySite' => $blockBySite,
  236.             'blockByTypeResource' => $blockByTypeResource,
  237.             'blockByType' => $blockByType,
  238.             'blockByDates' => $blockByDates
  239.         ]);
  240.     }
  241.     #[Route('/getResourcesByFilters', name: 'getResourcesByFilters')]
  242.     public function getResourcesByFilters(ManagerRegistry $doctrine, Request $request): Response
  243.     {
  244.         $resources = $doctrine->getRepository(Resource::class)->findGroupped($request->request->get('localisation'),$request->request->get('resourceType'));
  245.         return $this->render('components/resources-options.html.twig', [
  246.             'resources' => $resources,
  247.         ]);
  248.     }
  249.     #[Route('/getResourceByDates', name: 'getResourceByDates')]
  250.     public function getResourceByDates(ManagerRegistry $doctrine, Request $request): Response
  251.     {
  252.         $resources = $doctrine->getRepository(Resource::class)->getResourceByDates($request->request->get('localisation'),$request->request->get('resourceType'));
  253.         return $this->render('components/resources-options.html.twig', [
  254.             'resources' => $resources,
  255.         ]);
  256.     }
  257. }