src/Controller/StudioController.php line 37

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Model\DataObject\User;
  6. use App\Service\HourBooked;
  7. use App\Service\PriceCalculator;
  8. use Carbon\Carbon;
  9. use Doctrine\DBAL\Query\QueryBuilder;
  10. use phpDocumentor\Reflection\DocBlock\Tags\Var_;
  11. use Pimcore\Controller\FrontendController;
  12. use Symfony\Component\HttpFoundation\Request;
  13. use Symfony\Contracts\Translation\TranslatorInterface;
  14. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Template;
  15. use Symfony\Component\Routing\Annotation\Route;
  16. use Pimcore\Model\WebsiteSetting;
  17. use Pimcore\Model\DataObject;
  18. use Pimcore\Model\DataObject\Booking;
  19. use Pimcore\Model\DataObject\EquipmentCategory;
  20. use Pimcore\Model\DataObject\Order;
  21. use Pimcore\Model\DataObject\Place;
  22. use Pimcore\Model\DataObject\Studio;
  23. use Pimcore\Model\Document\PageSnippet;
  24. use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
  25. use ValueError;
  26. use Symfony\Component\Security\Core\Security as FrontSecurity;
  28. class StudioController extends FrontendController
  29. {
  31.     /**
  32.      * @Template
  33.      * @param Request $request
  34.      * @route("/{_locale}/studios", name="studioList",methods={"GET", "POST"})
  35.      * @return array
  36.      */
  37.     public function listAction(Request $request, FrontSecurity $security)
  38.     {
  39.         if($request->get("reset") && $request->get("reset") == 1){
  40.             $session = $request->getSession();
  41.             $session->set("searchparams", []);
  42.         }
  44.         $studiosCateg = new DataObject\StudioSuperCategory\Listing();
  45.         $studiosCateg->setOrderKey('order');
  46.         $studiosCateg->setOrder('asc');
  47.         $studiosCateg->load();
  49.         $studios = new DataObject\Studio\Listing();
  50.         //$studios->setOrderKey('');
  51.         //$studios->setKey('');
  52.         $studios->load();
  54.         $locations = new Place\Listing();
  55.         $locations->load();
  57.         $orders = [];
  58.         $securityUser = $security->getUser();
  59.         if ($securityUser) {
  60.             $user = User::getByUsername($securityUser->getUserIdentifier())->load()[0];
  61.             if($user){
  62.                 if($user->getStatus() == "rejected"){
  63.                     return $this->redirectToRoute("suspendedRoute");
  64.                 }
  65.                 $orders = new Order\Listing();
  66.                 $orders->setCondition("linkedUser__id = ".$user->getId()." AND (status like 'new')");
  67.                 $orders->load();
  68.             }
  69.         }
  71.         $displayCalendar = 0;
  73.         return  [
  74.             'studios' => $studios,
  75.             'studioCategories' => $studiosCateg,
  76.             'locations' => $locations,
  77.             'orders' => $orders,
  78.             'displayCalendar' => $displayCalendar,
  79.             'detailstudio' => 0,
  80.             'language' => $request->getLocale()
  81.         ];
  82.     }
  84.     /**
  85.      * @route("/{_locale}/api/studios", name="studiosapi", methods={"GET"})
  86.      */
  87.     public function getStudioListAction(Request $request)
  88.     {
  89.         $session = $request->getSession();
  90.         $allParams = $request->query->all();
  91.         $session->set("searchparams", $allParams);
  92.         $checkDate = Carbon::parse($allParams['sDate']);
  93.         $checkDate->setHour(intval($allParams['sHour']));
  94.         $checkNow = Carbon::now()->subHour();
  95.         if($checkDate->timestamp >= $checkNow->timestamp){
  96.             $availabilities = true;
  97.             $studioList = new Studio\Listing();
  98.             $studioList->onCreateQueryBuilder(function (QueryBuilder $queryBuilder) use ($allParams) {
  99.                 $queryBuilder->andWhere("(maintenance IS NULL OR maintenance = 0)");
  100.                 $originalTable = $queryBuilder->getQueryParts()['from'][0]['table'];
  101.                 $tabStudCats = array();
  102.                 try {
  103.                     if (array_key_exists('studTypes', $allParams)) {
  104.                         if ($allParams['studTypes'] != '') {
  105.                             $tabStudCats = explode(",", $allParams['studTypes']);
  106.                         }
  107.                     }
  108.                 } catch (ValueError $e) {
  109.                 }
  111.                 if (array_key_exists('souscategories', $allParams) && $allParams['souscategories']) {
  112.                     $studCatSQL = '(categorie__id = ' . $allParams['souscategories'] . ')';
  113.                     $queryBuilder->andWhere($studCatSQL);
  114.                 }else{
  115.                     if (count($tabStudCats)) {
  116.                         $studCatSQL = '';
  117.                         foreach ($tabStudCats as $key => $studcat) {
  118.                             $supCat = DataObject\StudioSuperCategory::getById($studcat);
  119.                             if($supCat){
  120.                                 if ($key != 0) {
  121.                                     $studCatSQL .= ' OR ';
  122.                                 }
  123.                                 if(count($supCat->getCategories()) > 1){
  124.                                     $studCatSQL .= "(";
  125.                                     foreach($supCat->getCategories() as $key2 => $sCateg){
  126.                                         if ($key2 != 0) {
  127.                                             $studCatSQL .= ' OR ';
  128.                                         }
  129.                                         $sCategId = $sCateg->getId();
  130.                                         $studCatSQL .= '(categorie__id = ' . $sCategId . ')';
  131.                                     }
  132.                                     $studCatSQL .= ")";
  133.                                 }else{
  134.                                     $sCategId = $supCat->getCategories()[0]->getId();
  135.                                     $studCatSQL .= '(categorie__id = ' . $sCategId . ')';
  136.                                 }
  137.                             }
  138.                         }
  139.                         if($studCatSQL){
  140.                             $queryBuilder->andWhere($studCatSQL);
  141.                         }
  142.                     }
  143.                 }
  144.                 if (array_key_exists('sDate', $allParams)) {
  145.                     $startDate = Carbon::parse($allParams['sDate']);
  146.                     $endDate = Carbon::parse($allParams['sDate']);
  147.                     $startDate->setHour(intval($allParams['sHour']));
  148.                     $endDate->setHour(intval($allParams['sHour']));
  149.                     $endDate->addHours(intval($allParams['sDuration']));
  151.                     $sqlOrder = "SELECT count(booking.o_id)
  152.                     FROM object_" . Booking::classId() . " booking
  153.                     JOIN object_" . Order::classId() . " ord ON ord.o_id = booking.order__id
  154.                     WHERE booking.bookedStudio__id = " . $originalTable . ".o_id AND ord.status NOT IN ('abandonned', 'canceled', 'temporary')
  155.                     AND ((booking.bookedStart BETWEEN " . $startDate->timestamp+1 . " AND " . $endDate->timestamp-1 . "
  156.                         OR booking.bookedEnd BETWEEN " . $startDate->timestamp+1 . " AND " . $endDate->timestamp-1 . ") OR (booking.bookedStart <= " . $startDate->timestamp . " AND booking.bookedEnd >= " . $endDate->timestamp . "))";
  157.                     //@TODO : Pour studios ayant des réservations pour l'heure dispo choisie : $queryBuilder->andWhere("(" . $sqlOrder . ") > 0");
  158.                     // Recopier le reste
  159.                     // Ajouter le paramètre $tabStud['availability'] = $infos;
  160.                     // Array merger en resetant les ID
  161.                     $queryBuilder->andWhere("(" . $sqlOrder . ") = 0");
  163.                     if($startDate->day != $endDate->day){
  164.                         $endDateQuery = 24+$endDate->hour;
  165.                     }else{
  166.                         $endDateQuery = $endDate->hour;
  167.                     }
  169.                     $hoursWhere = "(".$startDate->hour . " BETWEEN " . $originalTable . ".openingHour AND " . $originalTable . ".closingHour";
  170.                     $hoursWhere .= " AND ".$endDateQuery . " BETWEEN " . $originalTable . ".openingHour AND " . $originalTable . ".closingHour)";
  171.                     $hoursWhere .= " OR (".$originalTable . ".openingHour = 0 AND " . $originalTable . ".closingHour = 24)";
  173.                     $queryBuilder->andWhere($hoursWhere);
  174.                     /*if ($startDate->day != $endDate->day) {
  175.                         $queryBuilder->andWhere($originalTable . ".openingHour = 0");
  176.                         $queryBuilder->andWhere($originalTable . ".closingHour = 23");
  177.                     }*/
  178.                     $sqlClosedHours = "SELECT count(clHour.o_id) FROM object_collection_closedHours_" . Studio::classId() . " clHour"
  179.                         . " WHERE " . $originalTable . ".o_id = clHour.o_id"
  180.                         . " AND (" . $startDate->timestamp . " BETWEEN clHour.closedStart AND clHour.closedEnd"
  181.                         . " OR " . $endDate->timestamp . " BETWEEN clHour.closedStart AND clHour.closedEnd"
  182.                         . " OR clHour.closedStart BETWEEN " . $startDate->timestamp . " AND " . $endDate->timestamp
  183.                         . " OR clHour.closedEnd BETWEEN " . $startDate->timestamp . " AND " . $endDate->timestamp . ")";
  184.                     $queryBuilder->andWhere("(" . $sqlClosedHours . ") = 0");
  185.                     $queryBuilder->andWhere("place__id = " . $allParams['sLocation']);
  186.                 }
  187.             });
  188.             $studioList->setOrderKey("OrderPlace");
  189.             $studioList->setOrder("ASC");
  190.             //Limite de studios
  191.             //$studioList->setLimit(2);
  192.             $studioList->setLocale($request->getLocale());
  193.             $studioList->load();
  194.             $tabStudios = array();
  195.             foreach ($studioList as $studio) {
  196.                 $tabStud = array();
  197.                 $tabStud['id'] = $studio->getId();
  198.                 //$tabStud['detailURL'] = $this->generateUrl("studioDetail", ["slug" => $studio->getSlug()], UrlGeneratorInterface::ABSOLUTE_URL);
  199.                 $gear = "";
  200.                 if ($studio->getEquipments()) {
  201.                     foreach ($studio->getEquipments() as $equipment) {
  202.                         if($equipment->getEquipment()):
  203.                             $gear .= $equipment->getQty() . "&nbsp;x&nbsp; " . $equipment->getEquipment()->getName() . "<br/>";
  204.                         endif;
  205.                     }
  206.                 }
  207.                 $tabStud['gear'] = $gear;
  208.                 $tabStud['infos'] = $studio->getInfos();
  209.                 $tabStud['shortInfos'] = $studio->getShortInfos();
  210.                 $tabStud['maxPersons'] = $studio->getMaxPersons();
  211.                 $tabStud['title'] = $studio->getTitle();
  212.                 $tabStud['titleTranslated'] = $studio->getTitleTranslated();
  213.                 $tabStud['image'] = $studio->getImage()->getThumbnail("studio-thumb")->getHtml(['imgAttributes' => ['uk-cover' => null]]);
  214.                 $tabStud['defaultPrice'] = $studio->getDefaultPrice()->getAmount() * 100;
  215.                 $tabStud['availability'] = 1;
  216.                 $tabStud['language'] = $request->getLocale();
  218.                 //CSS
  219.                 $tabStud['cssFontSizeTitle'] = $studio->getCssFontSizeTitle();
  220.                 $tabStud['cssFontSizeTitleDetail'] = $studio->getCssFontSizeTitleDetail();
  222.                 // Ajout des promoLeft et right en haut du studio
  223.                 $pricingRule = $studio->getCategorie()->getPricingGrid();
  224.                 $tabStud['promoLeft'] = $pricingRule->getPromoLeft();
  225.                 $tabStud['promoRight'] = $pricingRule->getPromoRight();
  227.                 $promoLeftSize = "apk-f-13";
  228.                 if($pricingRule->getPromoLeftSize()) {
  229.                     $promoLeftSize = $pricingRule->getPromoLeftSize();
  230.                 }
  231.                 $tabStud['promoLeftSize'] = $promoLeftSize;
  233.                 $promoRightSize = "apk-f-13";
  234.                 if($pricingRule->getPromoRightSize()) {
  235.                     $promoRightSize = $pricingRule->getPromoRightSize();
  236.                 }
  237.                 $tabStud['promoRightSize'] = $promoRightSize;
  239.                 $tabStud['placeLock'] = $studio->getPlace()->getLockReservation() ? 1 : 0;
  240.                 $tabStud['lockText'] = $studio->getPlace()->getLockText($request->getLocale());
  242.                 array_push($tabStudios, $tabStud);
  244.             }
  245.         }else{
  246.             $tabStudios = array();
  247.         }
  249.         if(!$tabStudios){
  250.             // Ajouter le paramètre $tabStud['availability'] = $infos;
  251.             // Array merger en resetant les ID
  252.             //////// AFFICHAGE DES STUDIOS NON DISPONIBLES /////////
  253.             $availabilities = false;
  254.             $studioListUnavailable = new Studio\Listing();
  255.             $studioListUnavailable->onCreateQueryBuilder(function (QueryBuilder $queryBuilder) use ($allParams) {
  256.                 $queryBuilder->andWhere("(maintenance IS NULL OR maintenance = 0)");
  257.                 $originalTable = $queryBuilder->getQueryParts()['from'][0]['table'];
  258.                 $tabStudCats = array();
  259.                 try {
  260.                     if (array_key_exists('studTypes', $allParams)) {
  261.                         if ($allParams['studTypes'] != '') {
  262.                             $tabStudCats = explode(",", $allParams['studTypes']);
  263.                         }
  264.                     }
  265.                 } catch (ValueError $e) {
  266.                 }
  267.                 if (array_key_exists('souscategories', $allParams) && $allParams['souscategories']) {
  268.                     $studCatSQL = '(categorie__id = ' . $allParams['souscategories'] . ')';
  269.                     $queryBuilder->andWhere($studCatSQL);
  270.                 }else{
  271.                     if (count($tabStudCats)) {
  272.                         $studCatSQL = '';
  273.                         foreach ($tabStudCats as $key => $studcat) {
  274.                             $supCat = DataObject\StudioSuperCategory::getById($studcat);
  275.                             if ($key != 0) {
  276.                                 $studCatSQL .= ' OR ';
  277.                             }
  278.                             if(count($supCat->getCategories()) > 1){
  279.                                 $studCatSQL .= "(";
  280.                                 foreach($supCat->getCategories() as $key2 => $sCateg){
  281.                                     if ($key2 != 0) {
  282.                                         $studCatSQL .= ' OR ';
  283.                                     }
  284.                                     $sCategId = $sCateg->getId();
  285.                                     $studCatSQL .= '(categorie__id = ' . $sCategId . ')';
  286.                                 }
  287.                                 $studCatSQL .= ")";
  288.                             }else{
  289.                                 $sCategId = $supCat->getCategories()[0]->getId();
  290.                                 $studCatSQL .= '(categorie__id = ' . $sCategId . ')';
  291.                             }
  292.                         }
  293.                         $queryBuilder->andWhere($studCatSQL);
  294.                     }
  295.                 }
  296.                 if (array_key_exists('sDate', $allParams)) {
  297.                     $startDate = Carbon::parse($allParams['sDate']);
  298.                     $endDate = Carbon::parse($allParams['sDate']);
  299.                     $startDate->setHour(intval($allParams['sHour']));
  300.                     $endDate->setHour(intval($allParams['sHour']));
  301.                     $endDate->addHours(intval($allParams['sDuration']));
  302.                     $sqlOrder = "SELECT count(booking.o_id)
  303.                     FROM object_" . Booking::classId() . " booking
  304.                     JOIN object_" . Order::classId() . " ord ON ord.o_id = booking.order__id
  305.                     WHERE booking.bookedStudio__id = " . $originalTable . ".o_id AND ord.status NOT IN ('abandonned', 'canceled', 'temporary')
  306.                     AND ((booking.bookedStart NOT BETWEEN " . $startDate->timestamp+1 . " AND " . $endDate->timestamp-1 . "
  307.                         OR booking.bookedEnd NOT BETWEEN " . $startDate->timestamp+1 . " AND " . $endDate->timestamp-1 . ") OR (booking.bookedStart <= " . $startDate->timestamp . " AND booking.bookedEnd >= " . $endDate->timestamp . "))";
  308.                     $open = $startDate->hour . " NOT BETWEEN " . $originalTable . ".openingHour AND " . $originalTable . ".closingHour";
  309.                     $close = $endDate->hour . " NOT BETWEEN " . $originalTable . ".openingHour AND " . $originalTable . ".closingHour";
  311.                     $sqlClosedHours = "SELECT count(clHour.o_id) FROM object_collection_closedHours_" . Studio::classId() . " clHour"
  312.                         . " WHERE " . $originalTable . ".o_id = clHour.o_id"
  313.                         . " AND (" . $startDate->timestamp . " NOT BETWEEN clHour.closedStart AND clHour.closedEnd"
  314.                         . " OR " . $endDate->timestamp . " NOT BETWEEN clHour.closedStart AND clHour.closedEnd"
  315.                         . " OR clHour.closedStart NOT BETWEEN " . $startDate->timestamp . " AND " . $endDate->timestamp
  316.                         . " OR clHour.closedEnd NOT BETWEEN " . $startDate->timestamp . " AND " . $endDate->timestamp . ")";
  317.                     $queryBuilder->andWhere("(($sqlOrder) > 0) OR ($open OR $close) OR (($sqlClosedHours) > 0)");
  318.                     $queryBuilder->andWhere("place__id = " . $allParams['sLocation']);
  319.                 }
  320.             });
  321.             $studioListUnavailable->setOrderKey("OrderPlace");
  322.             $studioListUnavailable->setOrder("ASC");
  323.             $studioListUnavailable->setLocale($request->getLocale());
  324.             $studioListUnavailable = $studioListUnavailable->load();
  326.             //On ne réinitialise pas l'array
  327.             //$tabStudios = array();
  328.             foreach ($studioListUnavailable as $studio) {
  329.                 $tabStud = array();
  330.                 $tabStud['id'] = $studio->getId();
  331.                 //$tabStud['detailURL'] = $this->generateUrl("studioDetail", ["slug" => $studio->getSlug()], UrlGeneratorInterface::ABSOLUTE_URL);
  332.                 $gear = "";
  333.                 if ($studio->getEquipments()) {
  334.                     foreach ($studio->getEquipments() as $equipment) {
  335.                         if($equipment->getEquipment()):
  336.                             $gear .= $equipment->getQty() . "&nbsp;x&nbsp; " . $equipment->getEquipment()->getName() . "<br/>";
  337.                         endif;
  338.                     }
  339.                 }
  340.                 $tabStud['gear'] = $gear;
  341.                 $tabStud['infos'] = $studio->getInfos();
  342.                 $tabStud['shortInfos'] = $studio->getShortInfos();
  343.                 $tabStud['maxPersons'] = $studio->getMaxPersons();
  344.                 $tabStud['title'] = $studio->getTitle();
  345.                 $tabStud['titleTranslated'] = $studio->getTitleTranslated();
  346.                 $tabStud['image'] = $studio->getImage()->getThumbnail("studio-thumb")->getHtml(['imgAttributes' => ['uk-cover' => null]]);
  347.                 $tabStud['defaultPrice'] = $studio->getDefaultPrice()->getAmount() * 100;
  348.                 $tabStud['availability'] = 0;
  349.                 $tabStud['language'] = $request->getLocale();
  351.                 //CSS
  352.                 $tabStud['cssFontSizeTitle'] = $studio->getCssFontSizeTitle();
  353.                 $tabStud['cssFontSizeTitleDetail'] = $studio->getCssFontSizeTitleDetail();
  355.                 // Ajout des promoLeft et right en haut du studio
  356.                 $pricingRule = $studio->getCategorie()->getPricingGrid();
  357.                 $tabStud['promoLeft'] = $pricingRule->getPromoLeft();
  358.                 $tabStud['promoRight'] = $pricingRule->getPromoRight();
  360.                 $promoLeftSize = "apk-f-13";
  361.                 if($pricingRule->getPromoLeftSize()) {
  362.                     $promoLeftSize = $pricingRule->getPromoLeftSize();
  363.                 }
  364.                 $tabStud['promoLeftSize'] = $promoLeftSize;
  366.                 $promoRightSize = "apk-f-13";
  367.                 if($pricingRule->getPromoRightSize()) {
  368.                     $promoRightSize = $pricingRule->getPromoRightSize();
  369.                 }
  370.                 $tabStud['promoRightSize'] = $promoRightSize;
  372.                 array_push($tabStudios, $tabStud);
  373.             }
  374.         }
  376.         return $this->json(array("status" => "OK", "studios" => $tabStudios, 'available' => $availabilities));
  377.     }
  379.     /**
  380.      *  @route("/{_locale}/supercategory/{id}/subcategs", name="getSubCategories", methods={"GET"})
  381.      */
  382.     public function getSubCategories(Request $request)
  383.     {
  384.         $categ = DataObject\StudioSuperCategory::getById($request->get("id"));
  386.         if(!$categ){
  387.             return $this->json(array("status" => "OK", "scateg" => [], "count" => 0));
  388.         }
  390.         $scategs = $categ->getCategories();
  392.         $returnArray = [];
  393.         foreach ($scategs as $scateg){
  394.             $returnArray[] = [
  395.               "id" => $scateg->getId(),
  396.               "title" => $scateg->getTitle($request->getLocale()),
  397.             ];
  398.         }
  400.         return $this->json(array("status" => "OK", "scateg" => $returnArray, "count" => count($returnArray)));
  401.     }
  403.     /**
  404.      *  @route("/studio/{studio}/daysofweek/{day}", name="getDaysOfWeek", methods={"GET"})
  405.      */
  406.     public function getDaysOfWeek(Request $request)
  407.     {
  408.         $days = [];
  409.         $today = Carbon::now();
  410.         $today->setHours(1);
  411.         $currentDay = Carbon::parse($request->get("day"))->startOfWeek();
  412.         $currentDay->setHours(4);
  413.         $studio = Studio::getById($request->get('studio'));
  414.         for ($i = 0; $i < 7; $i++) {
  415.             $dayIso = $currentDay->format('Y-m-d');
  416.             $isAv = $currentDay->gte($today);
  418.             if ($isAv) {
  419.                 $totalHourOpened = ($studio->getClosingHour() - $studio->getOpeningHour()) + 1;
  420.                 $nbBookHours = 0;
  421.                 for ($h = $studio->getOpeningHour(); $h <= $studio->getClosingHour(); $h++) {
  422.                     if (HourBooked::check($studio, $currentDay, $h)) {
  423.                         $nbBookHours++;
  424.                     }
  425.                 }
  426.                 if ($nbBookHours == $totalHourOpened) {
  427.                     $isAv = false;
  428.                 }
  429.             }
  431.             $tab = ["timestamp" => $dayIso, "available" => $isAv];
  432.             array_push($days, $tab);
  433.             $currentDay->addDays(1);
  434.         }
  435.         return $this->json($days);
  436.     }
  438.     /**
  439.      * @route("/{_locale}/studio/{studio}/date/{date}/hours/{hour}/{duration}", name="availableHoursOfDaysByStudio", methods={"GET"})
  440.      */
  441.     public function availableHoursOfDaysByStudio(Request $request, $hour = null, $duration = null)
  442.     {
  443.         $studio = Studio::getById($request->get("studio"));
  444.         $rawDate = $request->get('date');
  445.         $date = Carbon::parse($rawDate);
  446.         if(!$hour){
  447.             $hour = 0;
  448.         }else{
  449.             $hour = (int) $request->get('hour');
  450.         }
  451.         if(!$duration){
  452.             $duration = 1;
  453.         }else{
  454.             $duration = (int) $request->get('duration');
  455.         }
  456.         $now = Carbon::now();
  457.         $tabAvailableHours = array();
  458.         for ($i = 0; $i < 24; $i++) {
  459.             $tmpDate = Carbon::parse($rawDate);
  460.             $tmpDate->setHour($hour);
  461.             $math = $hour+$i;
  462.             if($i){
  463.                 $tmpDate->addHours($i);
  464.             }
  465.             $tabHour = array();
  466.             $hourStatus = 'closed';
  467.             if($math >= $studio->getClosingHour() && $math >= 24){
  468.                 $math = $math - 24;
  469.             }
  470.             if ($math >= $studio->getOpeningHour() && $math < $studio->getClosingHour()) {
  471.                 $isClosed = false;
  472.                 if ($studio->getClosedHours()) {
  473.                     foreach ($studio->getClosedHours() as $clHour) {
  474.                         if ($tmpDate->gte($clHour->getClosedStart()) && $tmpDate->lte($clHour->getClosedEnd())) {
  475.                             $hourStatus = 'specialclosed';
  476.                             $isClosed = true;
  477.                         }
  478.                     }
  479.                 }
  481.                 if (!$isClosed) {
  482.                     if (($now->diffInDays($date) == 0) && ($now->day == $tmpDate->day)) {
  483.                         if ($math >= $now->hour) {
  484.                             $hourStatus = (HourBooked::check($studio, $tmpDate, $i)) ? 'booked' : 'available';
  485.                         } else {
  486.                             $hourStatus = 'past';
  487.                         }
  488.                     } else {
  489.                         $hourStatus = (HourBooked::check($studio, $tmpDate, $i)) ? 'booked' : 'available';
  490.                     }
  491.                 }
  492.             }
  493.             $tabHour['status'] = $hourStatus;
  494.             // Send price as x100
  495.             // TODO check for 'pack price of hours' in PriceCalculator
  496.             //$tabHour['price'] = PriceCalculator::getPriceForHour($studio, $date, $i) * 100;
  497.             //$date->setHour($i);
  498.             $tabHour['display'] = $tmpDate->clone()->format("G");
  499.             $tabHour['timestamp'] = $tmpDate->toIso8601String();
  500.             array_push($tabAvailableHours, $tabHour);
  501.         }
  503.         $originalGrid = [
  504.             array_values($studio->getCategorie()->getPricingGrid()->getLundiPricingGrid()->getData()),
  505.             array_values($studio->getCategorie()->getPricingGrid()->getMardiPricingGrid()->getData()),
  506.             array_values($studio->getCategorie()->getPricingGrid()->getMercrediPricingGrid()->getData()),
  507.             array_values($studio->getCategorie()->getPricingGrid()->getJeudiPricingGrid()->getData()),
  508.             array_values($studio->getCategorie()->getPricingGrid()->getVendrediPricingGrid()->getData()),
  509.             array_values($studio->getCategorie()->getPricingGrid()->getSamediPricingGrid()->getData()),
  510.             array_values($studio->getCategorie()->getPricingGrid()->getDimanchePricingGrid()->getData())
  511.         ];
  513.         $object = $studio->getCategorie()->getPricingGrid();
  514.         $pHcClean = (float)str_replace(",", ".", $object->getPrixHC());
  515.         $hcPrix = $pHcClean*100;
  516.         $hpPrix = array_values($object->getGeneralPriceGrid()->getData());
  517.         $gridHp = [];
  518.         foreach ($hpPrix as $price){
  519.             $key = (int) $price["hour"];
  520.             $pHpClean = (float)str_replace(",", ".", $price["price"]);
  521.             $gridHp[$key] = $pHpClean*100;
  522.         }
  524.         $grid = [];
  525.         foreach ($originalGrid as $key => $dayGrid){
  526.             $grid["$key"] = array();
  527.             foreach($dayGrid as $key2 => $prices){
  528.                 $grid["$key"]["$key2"] = [
  529.                     "full" => (int) $prices["full"]
  530.                 ];
  531.             }
  532.         }
  534.         $promoLeftSize = "apk-f-13";
  535.         if($object->getPromoLeftSize()) {
  536.             $promoLeftSize = $object->getPromoLeftSize();
  537.         }
  538.         $promoRightSize = "apk-f-13";
  539.         if($object->getPromoRightSize()) {
  540.             $promoRightSize = $object->getPromoRightSize();
  541.         }
  543.         $count = 0;
  544.         $checkedHours = [];
  545.         $unavailability = 0;
  546.         $price = 0.0;
  547.         $fullCount = 0;
  548.         $hollowCount = 0;
  549.         while ($count < $duration){
  550.             if($count == 12){
  551.                 break;
  552.             }
  553.             $setHour = $hour+$count;
  554.             $tmpDate = Carbon::parse($rawDate)->setHour($setHour);
  556.             $checkedHours[] = $tmpDate->toIso8601String();
  557.             $h = $tmpDate->clone()->format("H");
  558.             foreach ($tabAvailableHours as $availableH){
  559.                 $checkH = (int) $availableH["display"];
  560.                 if(($checkH == $h) && $availableH["status"] != "available"){
  561.                     $unavailability = 1;
  562.                     break;
  563.                 }
  564.             }
  566.             $d = ((int) $tmpDate->clone()->format("N"))-1;
  567.             $pHoursGrid = $grid[$d];
  568.             $status = $pHoursGrid[((int) $h)]["full"];
  569.             if($status){
  570.                 $fullCount++;
  571.             }else{
  572.                 $hollowCount++;
  573.             }
  574.             $count++;
  575.         }
  577.         if($count < $object->getPromoThreshold()){
  578.             $lowPrice = (float)$hollowCount*$hcPrix;
  579.             $highPrice = 0.0;
  580.             if($fullCount > 0){
  581.                 $hpPrice = $gridHp[$fullCount];
  582.                 $highPrice = (float)$fullCount*$hpPrice;
  583.             }
  584.             $totalPrice = (float)$highPrice+$lowPrice;
  585.             $totalIfFullHours = $gridHp[$count]*$count;
  586.             if($totalPrice > $totalIfFullHours){
  587.                 $totalPrice = (float)$totalIfFullHours;
  588.             }
  589.             $price = round($totalPrice, 1);
  590.         }else{
  591.             $promClean = (float) str_replace(",", ".", $object->getPromoPrice());
  592.             $price = $promClean*100;
  593.         }
  595.         return $this->json(array(
  596.             "status" => "OK",
  597.             "hours" => $tabAvailableHours,
  598.             "grid" => $grid,
  599.             "prixHc" => $hcPrix,
  600.             "prixHp" => $gridHp,
  601.             "promoLeft" => $object->getPromoLeft(),
  602.             "promoRight" => $object->getPromoRight(),
  603.             "promoLeftSize" => $promoLeftSize,
  604.             "promoRightSize" => $promoRightSize,
  605.             "promoThreshold" => $object->getPromoThreshold(),
  606.             "promoPrice" => (float) $object->getPromoPrice()*100,
  607.             "hourUnavailable" => $unavailability,
  608.             "price" => $price,
  609.             "countHours" => $count,
  610.             "checkedHours" => $checkedHours
  611.         ));
  612.     }
  614.     /**
  615.      * @route("/studio/{studio}/pricegrid", name="priceGridByStudio", methods={"GET"})
  616.      */
  617.     public function priceGridByStudio(Request $request)
  618.     {
  619.         $studio = Studio::getById($request->get("studio"));
  620.         $pricegrid = array_values($studio->getCategorie()->getPricingGrid()->getPricingGrid()->getData());
  621.         $object = $studio->getCategorie()->getPricingGrid();
  622.         $grid = [];
  623.         foreach ($pricegrid as $key => $prices){
  624.             $grid["$key"] = [
  625.                 "price" => (float) $prices["price"]*100,
  626.                 "full" => (int) $prices["full"]
  627.             ];
  628.         }
  629.         return $this->json(array("status" => "OK", "grid" => $grid, "promoLeft" => $object->getPromoLeft(), "promoRight" => $object->getPromoRight() ));
  630.     }
  632.     /**
  633.      * @route("/categories/matching", name="matchingCategories", methods={"GET"})
  634.      */
  635.     public function matchingCategoriesAction(Request $request)
  636.     {
  637.         $categories = DataObject\StudioSuperCategory::getList();
  638.         $matchArray = [];
  639.         foreach($categories as $category){
  640.             if(!isset($matchArray[$category->getId()])){
  641.                 $matchArray[$category->getId()] = [];
  642.             }
  643.             $similars = $category->getMatchedCategories();
  644.             foreach ($similars as $similar){
  645.                 $place = $similar->getPlace();
  646.                 $matchArray[$category->getId()][$place->getId()] = $similar->getId();
  647.             }
  648.         }
  649.         return $this->json(array("status" => "OK", "match" => $matchArray));
  650.     }
  651. }