src/Controller/CalendarController.php line 94

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Repository\CalendarRepository;
  6. use App\Repository\BookedActivityRepository;
  7. use App\Entity\Main\Calendar;
  8. use App\Entity\Main\Formule;
  9. use App\Entity\Main\Activity;
  10. use App\Entity\Main\BookedActivity;
  11. use App\Entity\Main\ActivityUnavailableSlot;
  12. use App\Entity\Main\OperatorBooking;
  13. use App\Entity\Main\Promos;
  14. use App\Entity\Main\Reservation;
  15. use App\Service\SessionService;
  16. use App\Service\Tools;
  18. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  19. use Symfony\Component\HttpFoundation\Request;
  20. use Symfony\Component\HttpFoundation\Response;
  21. use Symfony\Component\Routing\Annotation\Route;
  22. use Symfony\Component\HttpFoundation\JsonResponse;
  24. use ICal\ICal;
  26. class CalendarController extends AbstractController {
  28.     private $pk = 'hTgvcDsdkl5492Pifd4z8eMMLjds44z8d24dfsqsqHGzrdf5f'; //Private Key (56f491261413b1f05ddfb33623c96b99)
  30.     public function __construct( SessionService $ss) {
  31.         $this->ss = $ss;
  32.     }
  34.     /**
  35.      * @Route("/fermetures", methods={"POST"}, name="booking_fermetures")
  36.      * Cette fonction permet de récupérer les fermetures annuelles
  37.      */
  38.     public function getFermetures(Request $request) {
  39.         /* POST Method */
  40.         // if(md5($this->pk) != $request->request->get('key'))    exit();
  41.         
  42.         $em = $this->getDoctrine()->getManager();
  43.         $error = '';
  44.         $today = new \DateTime($request->request->get('date'));
  45.     
  46.         /* on récupère les infos Calendar */
  47.         $disabledDates = $em->getRepository(Calendar::class)->findDisabledDates($today);
  48.         $arrayDates = array();
  49.         $arrayHours = array();
  50.         
  51.         if (!$disabledDates) {
  52.             return new JsonResponse($arrayDates, JsonResponse::HTTP_CREATED);
  53.         } else {
  54.             foreach($disabledDates as $disabledDate)
  55.             {
  56.                 if(!$disabledDate[0]->getActivityClosed()) {
  57.                     if($disabledDate['to'] >= $today && $disabledDate['from']->diff($disabledDate['to'], true)->format('%a') > 1 ) {
  58.                         $date = new \stdClass();
  59.                         $date->from = $disabledDate['from']->format('Y-m-d');
  60.                         $date->to = $disabledDate['to']->format('Y-m-d');
  61.                         $date->msg = $disabledDate['msg'];
  62.                         $arrayDates[] = $date;
  63.                     }
  64.                     if($disabledDate['to'] >= $today && $disabledDate['from']->diff($disabledDate['to'], true)->format('%a') == 1
  65.                         || $disabledDate['to'] == $disabledDate['from'] && $disabledDate['to'] >= $today) {
  66.                         $date = new \stdClass();
  67.                         $date->from = $disabledDate['from']->format('Y-m-d');
  68.                         $date->to = $disabledDate['from']->format('Y-m-d');
  69.                         $date->msg = $disabledDate['msg'];
  70.                         $arrayDates[] = $date;
  71.                     }
  72.                     if($disabledDate['to'] >= $today && $disabledDate['from']->diff($disabledDate['to'], true)->format('%a') < 1
  73.                         || $disabledDate['to'] == $disabledDate['from'] && $disabledDate['to'] <= $today && $disabledDate['from'] >= $today) {
  74.                         $date = new \stdClass();
  75.                         $date->from = $disabledDate['from']->format('Y-m-d H:i');
  76.                         $date->to = $disabledDate['to']->format('Y-m-d H:i');
  77.                         $date->msg = $disabledDate['msg'];
  78.                         $arrayHours[] = $date;
  79.                     }
  80.                 }
  81.             }
  82.         }
  83.         if ($error != '') {
  84.             return new JsonResponse(['error' => $error], JsonResponse::HTTP_CREATED);
  85.         } else {
  86.             return new JsonResponse(['dates' => $arrayDates, 'hours' => $arrayHours], JsonResponse::HTTP_CREATED);        
  87.         }
  88.     }
  90.     /**
  91.      * @Route("/creneaux", methods={"POST"}, name="booking_creneaux")
  92.      * Cette fonction permet de récupérer tous les créneaux d'une activité
  93.      */
  94.     public function getCreneaux(Request $request) {
  95.         /* POST Method */
  96.         $data = json_decode($request->request->get('data'));
  97.         // if(md5($this->pk) != $request->request->get('key'))    exit();
  98.         
  99.         $em = $this->getDoctrine()->getManager();
  100.         $error = '';
  101.         $dateTimeZone = new \DateTimeZone('Europe/Paris'); 
  102.         // $dateTimeZone = new \DateTimeZone('UTC'); 
  103.         $today = new \DateTime('now', $dateTimeZone);
  105.         $cart = $this->ss->get();
  106.         $date = $cart['date'];
  107.         $bookingDate = new \DateTime($date, $dateTimeZone);
  108.         $formatter = new \IntlDateFormatter('fr_FR', NULL, NULL, $dateTimeZone, NULL, 'EEEE');
  109.         $dayName = $formatter->format($bookingDate);
  110.         $dayTrueName = $formatter->format($bookingDate);
  111.         
  112.         /* on récupère les infos Calendar du créneau */
  113.         $dateType = $em->getRepository(Calendar::class)->findTypeByDate($bookingDate);
  114.         $dateTrueType = "";
  115.         if ($dateType) {
  116.             $dayName = $dateType[0]['type'];
  117.             $dateTrueType = $dateType[0]['type'];
  118.         }
  119.         
  120.         $activity_id = $data->activity;
  121.         $forfait_id = $data->forfait;
  122.         $nbreparticipants = $data->nbreparticipants;
  123.         
  124.         /*** Récupération des forfaits déjà réservés ***/
  125.         // if(isset($cart['forfaits']) && !empty($cart['forfaits'])) $forfaits = $cart['forfaits'];
  126.         if(isset($data->reservation->forfaits) && !empty($data->reservation->forfaits)) $forfaits = $data->reservation->forfaits;
  127.         else $forfaits = null;
  129.         if($forfaits) {
  131.             $creneauxBooked = array();
  132.             $quantityBooked = 0;
  133.             foreach($forfaits as $forfait) {
  135.                 if($forfait) {
  137.                     $activites = $forfait->activites;
  139.                     foreach($activites as $activity) {
  141.                         /*** Pour chaque forfait, on compile les créneaux réservés pour d'autres activités ***/
  142.                         if($activity->id != $activity_id) {
  144.                             $activityDatas = new \stdClass();
  145.                             if($activity->creneau) {
  146.                                 $activityDatas->creneau = $bookingDate->format('Y-m-d').' '.$activity->creneau;
  147.                             } else {
  148.                                 $activityDatas->creneau = null;
  149.                             }
  151.                             $activityBooked = $em->getRepository(Activity::class)->find($activity->id);
  152.                             if($activityBooked instanceof Activity) {
  153.                                 $activityDatas->temps_activite = $activityBooked->getTempsActivite();
  154.                             }
  155.                             $creneauxBooked[$activity->id] = $activityDatas;
  157.                         }
  159.                         /*** Pour chaque forfait, on vérifie le nombre de participants déjà réservés pour cette activité ***/
  160.                         if($activity->id == $activity_id) $quantityBooked += $activity->quantity;
  162.                     }
  164.                 }
  166.             }
  168.         } else {
  170.             $creneauxBooked = array();
  171.             $quantityBooked = 0;
  173.         }
  174.         
  175.         // On récupère les infos de l'activité pour créer les créneaux
  176.         $activityToBook = $em->getRepository(Activity::class)->find($activity_id);
  178.         $unavailableSlot = $em->getRepository(ActivityUnavailableSlot::class)->findOneBy(['date' => $bookingDate,'code_activity' => $activityToBook->getCode()]);
  179.         
  180.         if (!$activityToBook) {
  181.             $error = 'no activity found : '. $code;
  182.             return new JsonResponse(['error' => $error], JsonResponse::HTTP_CREATED);
  183.         }
  185.         if($activityToBook instanceof Activity) {
  187.             $code = $activityToBook->getCode();    
  188.             $data->is_creneau_activity = $activityToBook->getIsCreneauActivity();
  189.             $data->block_room = $activityToBook->getBlockRoom();
  190.             $data->temps_limite_resa = $activityToBook->getTempsLimiteResa();
  191.             $data->jauge_mini = $activityToBook->getJaugeMini();
  192.             $data->jauge_max_by_room = $activityToBook->getJaugeMaxi();
  193.             $data->presence_avant = $activityToBook->getPresenceAvant();
  194.             $data->espaces_jeu = $activityToBook->getEspacesJeu();
  195.             $data->nbreparticipants = $nbreparticipants;
  196.             $data->is_tarification_multiple = $activityToBook->getIsTarificationMultiple();
  198.             $openingDays = false;
  199.             $dayExceptionInfo = false;
  201.             if( !empty($activityToBook->getOpeningDays()->toArray()) ) {
  202.                 $openingDays = $activityToBook->getOpeningDays()->toArray();
  203.                 $dayExceptionInfo = $this->checkDayOpening($openingDays,$dayTrueName,$dateTrueType);
  204.             }
  206.             if($activityToBook->getIsCreneauActivity()) {
  208.                 $data->jauge_maxi = $activityToBook->getJaugeMaxi() * $activityToBook->getEspacesJeu();
  209.                 $data->temps_creneau = $activityToBook->getTempsCreneau();
  211.                 if($activityToBook->getTempsActiviteJoueur() && $activityToBook->getTempsActiviteJoueur() > 0) {
  212.                     // $data->temps_de_jeu = $activityToBook->getTempsActiviteJoueur() * $nbreparticipants;
  213.                     $data->temps_de_jeu = $activityToBook->getTempsActiviteJoueur();
  214.                 } else {
  215.                     $data->temps_de_jeu = $activityToBook->getTempsActivite();
  216.                 }
  217.                 
  218.                 if($dayExceptionInfo) {
  219.                     $debutCreneau = new \DateTime($date . ' ' . $dayExceptionInfo->getOpeningTime()->format('H:i:s'), $dateTimeZone);
  220.                 } else {
  221.                     $debutCreneau = new \DateTime($date . ' ' . $activityToBook->getHeureOuvertureCreneau()->format('H:i:s'), $dateTimeZone);
  222.                 } 
  224.                 if($dayExceptionInfo) {
  225.                     $heureFermetureCreneau = $dayExceptionInfo->getClosingTime();
  226.                 } else {
  227.                     $heureFermetureCreneau = $activityToBook->getHeureFermetureCreneau();
  228.                 }
  230.                 if(!empty($activityToBook->getOpeningDays()->toArray()) && !$dayExceptionInfo) {
  231.                     $heureFermetureCreneau = $debutCreneau;
  232.                 }
  234.                 if($heureFermetureCreneau->format('H') >= 0 && $heureFermetureCreneau->format('H') <= 2) {
  235.                     $dv = new \DateInterval('P1D');
  236.                     $finCreneau = new \DateTime($date . ' ' . $heureFermetureCreneau->format('H:i:s'), $dateTimeZone);
  237.                     $finCreneau->add($dv);                    
  238.                 } else {
  239.                     $finCreneau = new \DateTime($date . ' ' . $heureFermetureCreneau->format('H:i:s'), $dateTimeZone);
  240.                 }
  241.                 
  242.                 $dv2 = new \DateInterval('PT'.$activityToBook->getTempsCreneau().'M');
  243.                 $finCreneau->add($dv2); // On ajoute en min le temps du jeu
  244.                 $tempsTotalCreneaux = $debutCreneau->diff($finCreneau);
  245.                 $nbreCreneaux = $tempsTotalCreneaux->h * 60 / $activityToBook->getTempsCreneau();
  247.                 $data->heure_debut = $debutCreneau;
  248.                 $data->heure_fin = $finCreneau;
  249.                 $data->temps_dispo = $tempsTotalCreneaux->h * 60;
  250.                 $data->nbre_creneaux = $nbreCreneaux;
  251.                 
  252.                 $i = 0;
  253.                 $data->creneaux = array();
  254.                 $sumQty = array();
  255.                                 
  256.                 // for($i = 0; $i < $nbreCreneaux; $i++) {
  257.                 //     $data->creneaux[$i] = array();
  258.                 //     $data->creneaux[$i]['places_dispo'] = $data->jauge_maxi;
  259.                 // }
  260.                                 
  261.                 for($i = 0; $i < $nbreCreneaux; $i++) {
  263.                     $data->creneaux[$i] = array();
  264.                     $dv4 = new \DateInterval('PT'.$activityToBook->getTempsCreneau() * $i.'M');
  265.                     $data->creneaux[$i]['heure_debut_utc'] = new \DateTime($data->heure_debut->format('Y-m-d H:i:s'), $dateTimeZone);
  266.                     $data->creneaux[$i]['heure_debut_utc']->add($dv4);
  268.                     if($today > $data->creneaux[$i]['heure_debut_utc']) {
  269.                         unset($data->creneaux[$i]);
  270.                         continue; // Si résa le jour même, on ne charge pas les créneaux si la date et l'heure ont dépassé les créneaux de la journée
  271.                     }
  273.                     $data->creneaux[$i]['heure_debut'] = $data->creneaux[$i]['heure_debut_utc']->format('H\hi');
  274.                     $data->creneaux[$i]['reservable'] = true;
  276.                     /* on vérifie si le délai est suffisant pour réserver le créneau  */
  277.                     if($activityToBook->getTempsLimiteResa()) {
  278.                         $dv3 = new \DateInterval('PT'.$activityToBook->getTempsLimiteResa().'M');
  279.                     } else {
  280.                         $dv3 = new \DateInterval('PT'.($activityToBook->getTempsCreneau()*2).'M');
  281.                     }
  282.                     $bookingDelay = new \DateTime('now', $dateTimeZone);
  283.                     $bookingDelay->add($dv3); // On ajoute en min la limite de résa
  284.                     
  285.                     if($bookingDelay > $data->creneaux[$i]['heure_debut_utc']) {
  286.                         $data->creneaux[$i]['reservable'] = false;                        
  287.                     }
  288.                     
  289.                     /* on bloque le créneau s'il est déjà réservé par le client pour une autre activité */
  290.                     if(is_array($creneauxBooked)) {
  292.                         foreach($creneauxBooked as $creneauReserve) {
  294.                             $delai1 = new \DateInterval('PT15M'); // On enlève 15min pour permettre aux clients d'arriver
  295.                             $creneauNonReservable = new \DateTime($creneauReserve->creneau, $dateTimeZone);
  296.                             $creneauNonReservable->sub($delai1); 
  297.                             // dump($creneauReserve->temps_activite);
  298.                             if($creneauReserve->temps_activite) {
  299.                                 $temps = intval(intval($creneauReserve->temps_activite) * 1.5);
  300.                                 $delai2 = new \DateInterval('PT'.$temps.'M'); // On ajoute 50% de temps en plus du temps d'activité pour le temps minimum avant de pouvoir réserver un autre créneau    
  301.                             } else {
  302.                                 $delai2 = new \DateInterval('PT75M'); // On ajoute 75 min pour le temps minimum avant de pouvoir réserver un autre créneau
  303.                             }
  304.                             // dump($delai2);
  305.                             
  306.                             
  307.                             $finCreneauNonReservable = new \DateTime($creneauReserve->creneau, $dateTimeZone);
  308.                             $finCreneauNonReservable->add($delai2); 
  309.                             
  310.                             if( $data->creneaux[$i]['heure_debut_utc'] >= $creneauNonReservable && $data->creneaux[$i]['heure_debut_utc'] <= $finCreneauNonReservable ) {
  311.                                 $data->creneaux[$i]['reservable'] = false;                        
  312.                             }            
  314.                         }
  316.                     }
  317.                     /* on vérifie les places déjà réservées pour ce créneau */
  318.                     if($i < ($nbreCreneaux-1)) {
  319.                         $next_creneau = new \DateTime($data->creneaux[$i]['heure_debut_utc']->format('H:i:s'));
  320.                         $next_creneau->add(new \DateInterval('PT'.$data->temps_creneau.'M')); 
  321.                     }
  322.                     else $next_creneau = new \DateTime('23:59:00'); 
  324.                     $bookedActivity = $em->getRepository(BookedActivity::class)
  325.                                             ->findSumQuantityBooked( $code, 
  326.                                                                     $data->creneaux[$i]['heure_debut_utc']->format('Y-m-d'), 
  327.                                                                     $data->creneaux[$i]['heure_debut_utc']->format('H:i:s'));
  329.                     $operatorBooked = $em->getRepository(OperatorBooking::class)
  330.                                             ->findSumQuantityBooked( $code, 
  331.                                                                     $data->creneaux[$i]['heure_debut_utc']->format('Y-m-d'), 
  332.                                                                     $next_creneau, 
  333.                                                                     $data->creneaux[$i]['heure_debut_utc']);
  334.                     $sumQty[$i] = !isset($sumQty[$i]) ? 0 : $sumQty[$i];
  335.                     $sumActivityBooked = 0;
  337.                     $ignoredCreneau = false;
  338.                     if($activityToBook->getTempsCreneau() != $activityToBook->getTempsCreneauReel()
  339.                         && $activityToBook->getIgnoredCreneau()
  340.                     ) {
  341.                         $ignoredCreneau = new \DateTime($activityToBook->getIgnoredCreneau()->format('H:i:s'));
  342.                     }
  345.                     $activitiesBooked = array_merge($bookedActivity,$operatorBooked);
  346.                     foreach($activitiesBooked as $activityBooked) {
  347.                         if( $activityBooked instanceof OperatorBooking && !$activityBooked->isDeleted() && ( $ignoredCreneau && $activityBooked->getCreneau()->format('i') != $ignoredCreneau->format('i') || !$ignoredCreneau)
  348.                             || $activityBooked instanceof BookedActivity && $activityBooked->getReservation()->getActive()) 
  349.                         {
  352.                             if($activityBooked instanceof OperatorBooking) 
  353.                                 $qtyActivityBooked = $activityBooked->getQuantity();
  354.                             else 
  355.                                 $qtyActivityBooked = $activityBooked->getQuantity() / $activityBooked->getNbreParties();
  358.                             for ($j=0; $j < $activityBooked->getNbreParties(); $j++) { 
  361.                                 if( $data->block_room ) {
  363.                                     $qtyRoom = intval(ceil($qtyActivityBooked / intval($data->jauge_max_by_room)));
  364.                                     $sumActivityBooked += $qtyRoom;
  366.                                     // if($i + (1*$j) == 2) dd($data->temps_de_jeu, $data->temps_creneau);
  368.                                     if( ($data->temps_de_jeu * $qtyActivityBooked) > $data->temps_creneau && $activityToBook->getTempsActiviteJoueur()) {
  370.                                         if( !isset($sumQty[$i + (2*$j)]) ) $sumQty[$i + (2*$j)] = 0;
  371.                                         $sumQty[$i + (2*$j)] += ( $qtyRoom * intval($data->jauge_max_by_room) );
  373.                                         if( !isset($sumQty[$i + (2*$j) + 1]) ) $sumQty[$i + (2*$j) + 1] = 0;
  374.                                         $sumQty[$i + (2*$j) + 1] += ( $qtyRoom * intval($data->jauge_max_by_room) );
  376.                                     } elseif( $data->temps_de_jeu > $data->temps_creneau) {
  378.                                         if( !isset($sumQty[$i + (2*$j)]) ) $sumQty[$i + (2*$j)] = 0;
  379.                                         $sumQty[$i + (2*$j)] += ( $qtyRoom * intval($data->jauge_max_by_room) );
  381.                                         if( !isset($sumQty[$i + (2*$j) + 1]) ) $sumQty[$i + (2*$j) + 1] = 0;
  382.                                         $sumQty[$i + (2*$j) + 1] += ( $qtyRoom * intval($data->jauge_max_by_room) );
  384.                                     } else {
  386.                                         if( !isset($sumQty[$i + (1*$j)]) ) $sumQty[$i + (1*$j)] = 0;
  387.                                         $sumQty[$i + (1*$j)] += ( $qtyRoom * intval($data->jauge_max_by_room) );
  388.                                     }
  389.                                     // $data->temps_de_jeu
  391.                                 } else {
  393.                                     $sumActivityBooked += 1;
  394.                                     if( !isset($sumQty[$i + (1*$j)]) ) $sumQty[$i + (1*$j)] = 0;
  395.                                     $sumQty[$i + (1*$j)] += $qtyActivityBooked;
  397.                                 }
  399.                             }
  401.                         }
  403.                     }
  405.                     // foreach($operatorBooked as $activityBooked) {
  406.                     //     if(!$activityBooked->isDeleted() && ( $ignoredCreneau && $activityBooked->getCreneau()->format('i') != $ignoredCreneau->format('i') || !$ignoredCreneau)) {
  407.                     //         $sumActivityBooked += 1;
  408.                     //         $sumQty[$i] += $activityBooked->getQuantity();
  409.                     //     } elseif(!$activityBooked->isDeleted()) {
  410.                     //         $sumActivityBooked += 1;
  411.                     //         $sumQty[$i] += $activityBooked->getQuantity();
  412.                     //     }
  413.                     // }
  415.                     // if($data->creneaux[$i]['heure_debut_utc']->format('H:i') == '13:00') dd($sumQty[$i],$operatorBooked);
  417.                     // ################################################################################################
  418.                     // ################################################################################################
  419.                     // TO-DO /!\ WARNING 
  420.                     // ################################################################################################
  421.                     // ################################################################################################
  422.                     
  423.                     if($unavailableSlot) {
  424.                         $unavailableSlotNb = $unavailableSlot->getSlotUnavailable();
  425.                         $sumActivityBooked += 1;
  427.                         if ($activityToBook->getBlockRoom()) {
  429.                             if($activityToBook->getEspacesJeuReel() && $activityToBook->getEspacesJeuReel() != $activityToBook->getEspacesJeu()) {
  431.                                 $espacesJeu = $activityToBook->getEspacesJeu();
  432.                                 $espacesJeuReel = $activityToBook->getEspacesJeuReel();
  433.                                 $jaugeMaxi = $activityToBook->getJaugeMaxi();
  434.                                 $jaugeMaxiReel = $jaugeMaxi;
  435.                                 // $jaugeMaxiReel = $activityToBook->getJaugeMaxiReel() ? $activityToBook->getJaugeMaxiReel() : $jaugeMaxi;
  436.                                 if($activityToBook->getJaugeMaxiReel())
  438.                                 $sumQty[$i] += ($unavailableSlotNb * $jaugeMaxi - (($jaugeMaxiReel * $espacesJeuReel) - ($jaugeMaxi * $espacesJeu)));
  440.                             } else {
  441.                                 $sumQty[$i] += $unavailableSlotNb * $activityToBook->getJaugeMaxi();
  442.                             }
  444.                         } else {
  446.                             if($activityToBook->getJaugeMaxiReel() && $activityToBook->getJaugeMaxiReel() != $activityToBook->getJaugeMaxi()) {
  448.                                 $jaugeMaxi = $activityToBook->getJaugeMaxi();
  449.                                 $jaugeMaxiReel = $activityToBook->getJaugeMaxiReel();
  450.                                 $sumQty[$i] += $unavailableSlotNb - ($jaugeMaxiReel - $jaugeMaxi);
  452.                             } else {
  453.                                 $sumQty[$i] += $unavailableSlotNb;
  454.                             }
  456.                         }
  457.                     }
  459.                     // ################################################################################################
  460.                     // ################################################################################################
  461.                     // ################################################################################################
  463.                     if($data->block_room && intval($sumQty[$i]) > 0) {
  464.                         if($data->espaces_jeu > $sumActivityBooked) {
  465.                             $data->creneaux[$i]['places_dispo'] = (intval($data->jauge_maxi) - intval($sumQty[$i])) - ((intval($data->jauge_maxi) - intval($sumQty[$i])) % intval($data->jauge_max_by_room));
  466.                             // if($i == 3 ) dd($sumQty[$i], $data->espaces_jeu, $sumActivityBooked );
  467.                         } else {
  468.                             $data->creneaux[$i]['places_dispo'] = 0;
  469.                         }
  470.                         // $data->creneaux[$i]['places_dispo'] = intval($data->jauge_maxi);
  471.                     } else {
  472.                         $data->creneaux[$i]['places_dispo'] = intval($data->jauge_maxi) - intval($sumQty[$i]);
  473.                     }
  474.                     
  475.                     //TO-DO : à vérifier sur les pass Journée
  476.                     if($data->creneaux[$i]['places_dispo'] < $data->nbreparticipants + $quantityBooked) {
  477.                         $data->creneaux[$i]['reservable'] = false;                        
  478.                     }
  480.                     /* on récupère les infos Calendar pour les dates et créneaux de fermetures */
  481.                     $disabledDates = $em->getRepository(Calendar::class)->findDisabledDates($today);
  482.                     
  483.                     if($disabledDates) {
  485.                         foreach($disabledDates as $disabledDate) {
  487.                             if($disabledDate[0]->getActivityClosed()) $activityClosed = $disabledDate[0]->getActivityClosed();
  488.                             else $activityClosed = '';
  489.                             
  490.                             if($data->creneaux[$i]['heure_debut_utc'] >= $disabledDate['from'] && $data->creneaux[$i]['heure_debut_utc'] < $disabledDate['to'] && $activityClosed == '') {
  491.                                 $data->creneaux[$i]['reservable'] = false;
  492.                             } else if($data->creneaux[$i]['heure_debut_utc'] >= $disabledDate['from'] && $data->creneaux[$i]['heure_debut_utc'] < $disabledDate['to'] && $activityClosed == $code) {
  493.                                 $data->creneaux[$i]['reservable'] = false;
  494.                             }
  496.                         }
  498.                     }                
  500.                     /* on récupère les infos Calendar du créneau */
  501.                     $dateType = $em->getRepository(Calendar::class)->findTypeByDate($data->creneaux[$i]['heure_debut_utc']->format('Y-m-d'));
  502.                     
  503.                     if($dateType) {
  504.                         $data->creneaux[$i]['type'] = $dateType[0]['type'];
  505.                     } else {
  506.                         $data->creneaux[$i]['type'] = null;
  507.                     }
  508.                     
  509.                     /* on récupère le tarif pour ce créneau */
  510.                     $day = new \DateTime($data->creneaux[$i]['heure_debut_utc']->format('Y-m-d'), $dateTimeZone);
  511.                     $formatter = new \IntlDateFormatter('fr_FR', NULL, NULL, $dateTimeZone, NULL, 'EEEE');
  512.                     $dayName = $formatter->format($day);
  513.                     
  514.                     if($data->creneaux[$i]['type'] != null) {
  515.                         $dayName = $dateType[0]['type'];
  516.                     } else {
  517.                         $data->creneaux[$i]['type'] = $dayName;
  518.                     }
  520.                     /******** PROMOS *********/
  521.                     /* On récupère les conditions de la promotion si elle existe */
  522.                     $promo = $em->getRepository(Promos::class)
  523.                                 ->findPromosByCreneau(    $data->creneaux[$i]['heure_debut_utc']->format('H:i:s'),
  524.                                                         $bookingDate,
  525.                                                         $dayName, 
  526.                                                         $forfait_id
  527.                                                     );
  529.                     if($promo) {
  530.                         $data->creneaux[$i]['promo'] = true;
  531.                     } else {
  532.                         $data->creneaux[$i]['promo'] = false;                        
  533.                     }
  534.                     
  535.                 }
  537.             } else {
  539.                 /* on récupère les infos Calendar du créneau */
  540.                 $dateType = $em->getRepository(Calendar::class)->findTypeByDate($bookingDate->format('Y-m-d'));
  541.                             
  542.                 /* on récupère le tarif pour ce créneau */
  543.                 $day = new \DateTime($bookingDate->format('Y-m-d'), $dateTimeZone);
  544.                 $formatter = new \IntlDateFormatter('fr_FR', NULL, NULL, $dateTimeZone, NULL, 'EEEE');
  545.                 $dayName = $formatter->format($day);
  546.                 
  547.                 if($dateType) {
  548.                     $dayName = $dateType[0]['type'];
  549.                 } 
  550.                 
  551.                 $data->type = $dayName;    
  553.             }
  554.         }
  556.         if ($error != '') {
  557.             return new JsonResponse(['error' => $error], JsonResponse::HTTP_CREATED);
  558.         } else {
  559.             return new JsonResponse($data, JsonResponse::HTTP_CREATED);            
  560.         }
  561.     }
  563.     /**
  564.      * @Route("/creneaux_formules", methods={"POST"}, name="booking_creneauxformules")
  565.      * Cette fonction permet de récupérer tous les créneaux d'une activité
  566.      */
  567.     public function getCreneauxFormules(Request $request)
  568.     {
  569.         /* POST Method */
  570.         $data = json_decode($request->request->get('data'));
  571.         // if(md5($this->pk) != $request->request->get('key'))    exit();
  572.         
  573.         $em = $this->getDoctrine()->getManager();
  574.         $error = '';
  575.         $dateTimeZone = new \DateTimeZone('Europe/Paris'); 
  576.         $today = new \DateTime('now', $dateTimeZone);
  578.         $date = $data->date;
  579.         if(strpos($date, '/') !== false) {
  580.             $date_temp = explode('/',$date);
  581.             $date = $date_temp[2].'-'.$date_temp[1].'-'.$date_temp[0];
  582.         }
  583.         $bookingDate = new \DateTime($date, $dateTimeZone);
  584.         $formatter = new \IntlDateFormatter('fr_FR', NULL, NULL, $dateTimeZone, NULL, 'EEEE');
  585.         $dayName = $formatter->format($bookingDate);
  586.         
  587.         /* on récupère les infos Calendar du créneau */
  588.         $dateType = $em->getRepository(Calendar::class)->findTypeByDate($bookingDate);
  589.         
  590.         if ($dateType) {
  591.             $dayName = $dateType[0]['type'];
  592.         }
  594.         $formule_id = $data->formule_id;
  595.         $formule_code = $data->formule_code;    
  597.         /*** On récupère les infos de la formule pour créer les créneaux ***/
  598.         $formuleToBook = $em->getRepository(Formule::class)->find($formule_id);
  599.         
  600.         if (!$formuleToBook) {
  601.             $error = 'no formule found : '. $formule_id;
  602.             return new JsonResponse(['error' => $error], JsonResponse::HTTP_CREATED);
  603.         }
  605.         if($formuleToBook instanceof Formule)
  606.         {        
  607.             $code = $formuleToBook->getCode();    
  608.             $data->is_creneau_activity = $formuleToBook->getIsCreneauActivity();
  610.             if($data->is_creneau_activity)
  611.             {
  612.                 $data->nbre_maxi = $formuleToBook->getNbreMaxi();
  613.                 $data->temps_creneau = $formuleToBook->getTempsCreneau();
  614.                 
  615.                 $debutCreneau = new \DateTime($date . ' ' . $formuleToBook->getHeureOuvertureCreneau()->format('H:i:s'), $dateTimeZone);
  617.                 if($formuleToBook->getHeureFermetureCreneau()->format('H') >= 0 && $formuleToBook->getHeureFermetureCreneau()->format('H') <= 2) 
  618.                 {
  619.                     $dv = new \DateInterval('P1D');
  620.                     $finCreneau = new \DateTime($date . ' ' . $formuleToBook->getHeureFermetureCreneau()->format('H:i:s'), $dateTimeZone);
  621.                     $finCreneau->add($dv);
  622.                 } else {
  623.                     $finCreneau = new \DateTime($date . ' ' . $formuleToBook->getHeureFermetureCreneau()->format('H:i:s'), $dateTimeZone);
  624.                 }
  625.                 
  626.                 $dv2 = new \DateInterval('PT'.$data->temps_creneau.'M');
  627.                 $finCreneau->add($dv2); // On ajoute en min le temps du jeu
  628.                 $tempsTotalCreneaux = $debutCreneau->diff($finCreneau);
  629.                 $nbreCreneaux = $tempsTotalCreneaux->h * 60 / $data->temps_creneau;
  631.                 $data->heure_debut = $debutCreneau;
  632.                 $data->heure_fin = $finCreneau;
  633.                 $data->temps_dispo = $tempsTotalCreneaux->h * 60;
  634.                 $data->nbre_creneaux = $nbreCreneaux;
  635.                 
  636.                 $i = 0;
  637.                 $data->creneaux = array();
  638.                                 
  639.                 for($i = 0; $i <= $nbreCreneaux; $i++) {
  640.                     $data->creneaux[$i] = array();
  641.                     $dv4 = new \DateInterval('PT'.$data->temps_creneau * $i.'M');
  642.                     $data->creneaux[$i]['heure_debut_utc'] = new \DateTime($data->heure_debut->format('Y-m-d H:i:s'), $dateTimeZone);
  643.                     $data->creneaux[$i]['heure_debut_utc']->add($dv4);
  645.                     if($today > $data->creneaux[$i]['heure_debut_utc']) {
  646.                         unset($data->creneaux[$i]);
  647.                         continue; // Si résa le jour même, on ne charge pas les créneaux si la date et l'heure ont dépassé les créneaux de la journée
  648.                     }
  650.                     $data->creneaux[$i]['heure_debut'] = $data->creneaux[$i]['heure_debut_utc']->format('H\hi');
  651.                     $data->creneaux[$i]['reservable'] = true;
  653.                     /* on vérifie si le délai est suffisant pour réserver le créneau  */
  654.                     $dv3 = new \DateInterval('PT'.$formuleToBook->getTempsLimiteResa().'M');
  655.                     $bookingDelay = new \DateTime('now', $dateTimeZone);
  656.                     $bookingDelay->add($dv3); // On ajoute en min la limite de résa
  657.                     
  658.                     if($bookingDelay > $data->creneaux[$i]['heure_debut_utc']) {
  659.                         $data->creneaux[$i]['reservable'] = false;
  660.                     }
  661.                     
  662.                     /* on vérifie les places déjà réservées pour ce créneau */
  663.                     $nbre_resa = count($em->getRepository(Reservation::class)->findByCodeAndDate($formule_code, $data->creneaux[$i]['heure_debut_utc']));
  664.                 
  665.                     $data->creneaux[$i]['places_dispo'] = intval($data->nbre_maxi) - intval($nbre_resa);
  666.                     if($data->creneaux[$i]['places_dispo'] <= 0) {
  667.                         $data->creneaux[$i]['reservable'] = false;
  668.                     }                    
  670.                     /* on récupère les infos Calendar du créneau */
  671.                     $dateType = $em->getRepository(Calendar::class)->findTypeByDate($data->creneaux[$i]['heure_debut_utc']->format('Y-m-d'));
  672.                     
  673.                     if($dateType) {
  674.                         $data->creneaux[$i]['type'] = $dateType[0]['type'];
  675.                     } else $data->creneaux[$i]['type'] = null;
  676.                     
  677.                     /* on récupère le tarif pour ce créneau */
  678.                     $day = new \DateTime($data->creneaux[$i]['heure_debut_utc']->format('Y-m-d'), $dateTimeZone);
  679.                     $formatter = new \IntlDateFormatter('fr_FR', NULL, NULL, $dateTimeZone, NULL, 'EEEE');
  680.                     $dayName = $formatter->format($day);
  681.                     
  682.                     if($data->creneaux[$i]['type'] != null) {
  683.                         $dayName = $dateType[0]['type'];
  684.                     } else {
  685.                         $data->creneaux[$i]['type'] = $dayName;
  686.                     }
  688.                     // /******** PROMOS *********/
  689.                     //TO-DO : vérifier si un forfait anniversaire est en promo sur le créneau
  690.                     // /* On récupère les conditions de la promotion si elle existe */
  691.                     // $promo = $em->getRepository(Promos::class)->findPromosByCreneau(    $data->creneaux[$i]['heure_debut_utc']->format('H:i:s'),
  692.                                                                                     // $bookingDate,
  693.                                                                                     // $dayName, 
  694.                                                                                     // $forfait_id
  695.                                                                                     // );
  696.                     // if($promo) {
  697.                         // $data->creneaux[$i]['promo'] = true;
  698.                     // } else {
  699.                         // $data->creneaux[$i]['promo'] = false;                        
  700.                     // }
  701.                 }
  702.             } else {
  703.                 /* on récupère les infos Calendar du créneau */
  704.                 $dateType = $em->getRepository(Calendar::class)->findTypeByDate($bookingDate->format('Y-m-d'));
  705.                             
  706.                 /* on récupère le tarif pour ce créneau */
  707.                 $day = new \DateTime($bookingDate->format('Y-m-d'), $dateTimeZone);
  708.                 $formatter = new \IntlDateFormatter('fr_FR', NULL, NULL, $dateTimeZone, NULL, 'EEEE');
  709.                 $dayName = $formatter->format($day);
  710.                 
  711.                 if($dateType) {
  712.                     $dayName = $dateType[0]['type'];
  713.                 } 
  714.                 $data->type = $dayName;                
  715.             }
  716.         }
  719.         if ($error != '') {
  720.             return new JsonResponse(['error' => $error], JsonResponse::HTTP_CREATED);
  721.         } else {
  722.             return new JsonResponse($data, JsonResponse::HTTP_CREATED);            
  723.         }
  724.     }
  727.     /**
  728.      * @Route("/cron_calendar", name="calendar_cron", methods={"GET"})
  729.      */
  730.     public function cron(Request $request, CalendarRepository $calendarRepository): Response
  731.     {
  732.         $url = array();
  733.         $url['vacances'] = 'https://fr.ftp.opendatasoft.com/openscol/fr-en-calendrier-scolaire/Zone-A.ics'; //Abonnement aux périodes de vacances N+1
  734.         // $url['feries'] = 'https://www.thunderbird.net/media/caldata/FrenchHolidays.ics'; //Fichier ICS jours fériés jusqu'en 2030
  735.         $url['feries'] = 'https://ical-holidays.com/fr/jour-ferie/france/2024/calendar'; //Fichier ICS jours fériés jusqu'en 2030
  737.         
  738.         $dateTimeZone = new \DateTimeZone('Europe/Paris'); 
  739.         $today = new \DateTime('now', $dateTimeZone);
  740.         $year = intval($today->format("Y"));
  741.         $em = $this->getDoctrine()->getManager();
  742.         // var_dump('plop');
  743.         /* POST Method */
  744.         // if(md5($this->pk) == $request->query->get('key')) {
  745.             
  746.             /* Suppression de tous les enregistrements */
  747.             $results = $calendarRepository->findBy(['type' => 'vacances']);
  748.             foreach($results as $calendar) {
  749.                 $em->remove($calendar);
  750.             }
  752.             $results = $calendarRepository->findBy(['type' => 'veille']);
  753.             foreach($results as $calendar) {
  754.                 $em->remove($calendar);
  755.             }            
  757.             $results = $calendarRepository->findBy(['type' => 'feries']);
  758.             foreach($results as $calendar) {
  759.                 $em->remove($calendar);
  760.             }            
  761.             
  762.             /**************************************/            
  763.             /* récupération des dates de vacances */
  764.             /**************************************/
  765.             $ical = new ICal();
  766.             $ical->initUrl($url['vacances']);
  768.             $fromDateSummer = array(); //Vacances d'été
  769.             $toDateSummer = array(); //Vacances d'été
  770.             
  771.             foreach($ical->events() as $event) {
  772.                 
  773.                 $fromDate = new \DateTime($event->dtstart, $dateTimeZone);
  774.                 $annee = $fromDate->format("Y");
  775.                 
  776.                 if(isset($event->dtend) && $event->dtend != "")
  777.                     $toDate = new \DateTime($event->dtend, $dateTimeZone);
  778.                 else
  779.                     $toDate = $fromDate;
  780.                 
  781.                 if ($fromDate >= $today && Tools::str2url($event->description) != "prerentree-des-enseignants")
  782.                 {
  783.                     if(Tools::str2url($event->description) != "vacances-d-ete" && Tools::str2url($event->description) != "rentree-scolaire-des-eleves")
  784.                     {
  785.                         $calendar = new Calendar;
  786.                         $calendar->setDesignation(Tools::str2url($event->description));
  787.                         $calendar->setType('vacances');
  788.                         $calendar->setFromDate($fromDate);
  789.                         $calendar->setToDate($toDate);
  790.                         $calendar->setPriority(1); // Vacances en priorité 1 pour l'application des tarifs
  791.                         
  792.                         if(!$calendarRepository->findOneBy(['from_date' => $fromDate, 'to_date' => $toDate, 'type' => 'vacances'])) { 
  793.                             $em->persist($calendar);
  794.                             $em->flush();
  795.                         }
  796.                         
  797.                         /* ajout de la veille */
  798.                         $dv = new \DateInterval('P1D');
  799.                         $veilleDate = new \DateTime($event->dtstart, $dateTimeZone);
  800.                         $veilleDate->sub($dv); // On enlève un jour
  801.                         $toDateVeille = new \DateTime($event->dtstart, $dateTimeZone);
  802.                         
  803.                         $veille = new Calendar;
  804.                         $veille->setDesignation("Veille : ".$event->description);
  805.                         $veille->setType('veille');
  806.                         $veille->setFromDate($veilleDate);
  807.                         $veille->setToDate($toDateVeille);
  808.                         $veille->setPriority(3); // Veilles de vacances en priorité 3 pour l'application des tarifs
  809.                         
  810.                         $em->persist($veille);
  811.                         $em->flush();
  812.                         
  813.                     }
  814.                 }
  815.                 
  816.                 if(Tools::str2url($event->description) == "vacances-d-ete") $fromDateSummer[$annee] = $event->dtstart;
  817.                 if(Tools::str2url($event->description) == "rentree-scolaire-des-eleves") $toDateSummer[$annee] = $event->dtstart;
  819.             }
  820.             
  821.             /* Vacances d'été */
  822.             for($i = $year; $i <= $year + 1; $i++) {
  823.                 if(isset($fromDateSummer[$i]) && $fromDateSummer[$i] != "")
  824.                 {
  825.                     $fromDate = new \DateTime($fromDateSummer[$i], $dateTimeZone);
  826.                     
  827.                     $calendar = new Calendar;
  828.                     $calendar->setDesignation("Vacances d'été");
  829.                     $calendar->setType('vacances');
  830.                     $calendar->setFromDate($fromDate);
  831.                     $calendar->setPriority(1); // Vacances en priorité 1 pour l'application des tarifs
  833.                     if(isset($toDateSummer[$i]) && $toDateSummer[$i] != "") {
  834.                         $toDate = new \DateTime($toDateSummer[$i], $dateTimeZone);
  835.                         $calendar->setToDate($toDate);
  836.                     } else {
  837.                         $calendar->setToDate(new \DateTime($i.'-08-31', $dateTimeZone));
  838.                     }
  839.                     
  840.                     $em->persist($calendar);
  841.                     $em->flush();
  842.                     
  843.                     /* ajout de la veille */                
  844.                     $dv = new \DateInterval('P1D');
  845.                     $veilleDate = new \DateTime($fromDateSummer[$i], $dateTimeZone);
  846.                     $veilleDate->sub($dv); // On enlève un jour
  847.                     $toDateVeille = new \DateTime($fromDateSummer[$i], $dateTimeZone);
  848.                     
  849.                     $veille = new Calendar;
  850.                     $veille->setDesignation("Veille : Vacances d'été");
  851.                     $veille->setType('veille');
  852.                     $veille->setFromDate($veilleDate);
  853.                     $veille->setToDate($toDateVeille);
  854.                     $veille->setPriority(3); // Veilles de vacances en priorité 3 pour l'application des tarifs
  855.                     
  856.                     $em->persist($veille);
  857.                     $em->flush();            
  858.                 } else {
  859.                     $calendar = new Calendar;
  860.                     $calendar->setDesignation("Vacances d'été");
  861.                     $calendar->setType('vacances');
  862.                     $calendar->setFromDate(new \DateTime($i.'-07-01', $dateTimeZone));
  863.                     $calendar->setToDate(new \DateTime($i.'-08-31', $dateTimeZone));
  864.                     $calendar->setPriority(1); // Vacances en priorité 1 pour l'application des tarifs
  865.                     
  866.                     $em->persist($calendar);
  867.                     $em->flush();
  868.                     
  869.                     /* ajout de la veille */
  870.                     $dv = new \DateInterval('P1D');
  871.                     $veilleDate = new \DateTime($i.'-07-01', $dateTimeZone);
  872.                     $veilleDate->sub($dv); // On enlève un jour
  873.                     
  874.                     $veille = new Calendar;
  875.                     $veille->setDesignation("Veille : Vacances d'été");
  876.                     $veille->setType('veille');
  877.                     $veille->setFromDate($veilleDate);
  878.                     $veille->setToDate(new \DateTime($i.'-07-01', $dateTimeZone));
  879.                     $veille->setPriority(3); // Veilles de vacances en priorité 3 pour l'application des tarifs
  880.                     
  881.                     $em->persist($veille);
  882.                     $em->flush();                    
  883.                 }            
  884.             }
  885.             
  886.             /******************************************/
  887.             /* récupération des dates de jours fériés */
  888.             /******************************************/
  889.             $ical = new ICal();
  890.             $ical->initUrl($url['feries']);
  892.             // dd($ical->events()[0]->dtstart, $ical->events()[0]->dtend);
  894.             foreach($ical->events() as $event) {
  895.                 
  896.                 $fromDate = new \DateTime($event->dtstart, $dateTimeZone);
  897.                 
  898.                 if(isset($event->dtend) && $event->dtend != "") {
  899.                     $toDate = new \DateTime($event->dtend, $dateTimeZone);
  900.                     if($event->dtstart == $event->dtend) {
  901.                         $dv = new \DateInterval('P1D');
  902.                         $toDate->add($dv);
  903.                     }
  905.                 } else {
  906.                     $toDate = $fromDate;
  907.                 }
  908.                 
  909.                 if ($fromDate >= $today)
  910.                 {
  911.                     $calendar = new Calendar;
  912.                     $calendar->setDesignation($event->summary);
  913.                     $calendar->setType('feries');
  914.                     $calendar->setFromDate($fromDate);
  915.                     $calendar->setToDate($toDate);
  916.                     $calendar->setPriority(2); // Fériés en priorité 2 pour l'application des tarifs
  917.                     
  918.                     $em->persist($calendar);
  919.                     $em->flush();
  920.                     
  921.                     /* ajout de la veille */
  922.                     $dv = new \DateInterval('P1D');
  923.                     $veilleDate = new \DateTime($event->dtstart, $dateTimeZone);
  924.                     $veilleDate->sub($dv); // On enlève un jour
  925.                     
  926.                     $veille = new Calendar;
  927.                     $veille->setDesignation("Veille : ".$event->summary);
  928.                     $veille->setType('veille');
  929.                     $veille->setFromDate($veilleDate);
  930.                     $veille->setToDate($fromDate);
  931.                     $veille->setPriority(3); // Veilles de vacances en priorité 3 pour l'application des tarifs
  932.                     
  933.                     $em->persist($veille);
  934.                     $em->flush();
  935.                 }
  936.             }
  937.         // }
  938.         
  939.         return $this->redirectToRoute('admin');
  940.     }
  942.     public function checkDayOpening($openingDays, $dayName, $specialDayName) 
  943.     {
  945.            $return_data = false;
  946.         foreach ($openingDays as $key => $day) {
  947.             if($day->getDay() == $dayName) {
  948.                 if($specialDayName == "vacances" && $day->isIsHolidays()) $return_data = $day;
  949.                 if($specialDayName == "feries" && $day->isIsPublicHoliday()) $return_data = $day;
  950.                 if(!$day->isIsPublicHoliday() && !$day->isIsHolidays()) $return_data = $day;
  951.             }
  952.         }
  954.         return $return_data;
  955.     }
  956.     
  957. }