src/MDS/GreenPatioBundle/Controller/ReservationsQuoteController.php line 595

Open in your IDE?
  1. <?php
  3. namespace App\MDS\GreenPatioBundle\Controller;
  5. use App\Entity\HtFile;
  6. use App\Entity\ReservationLoungeWebDescription;
  7. use App\Entity\WidgetNotes;
  8. use App\Form\WidgetNotesType;
  9. use App\MDS\AvexpressBundle\Entity\AveFiles;
  10. use App\MDS\GreenPatioBundle\Entity\Reservation;
  11. use App\MDS\GreenPatioBundle\Entity\ReservationLoungeSimple;
  12. use App\MDS\GreenPatioBundle\Entity\ReservationService;
  13. use App\MDS\GreenPatioBundle\Entity\ReservationGpPrice;
  14. use App\MDS\GreenPatioBundle\Entity\ReservationLounge;
  15. use App\MDS\GreenPatioBundle\Entity\ReservationLoungeDetails;
  16. use App\MDS\GreenPatioBundle\Entity\ReservationLoungeProfile;
  17. use App\MDS\GreenPatioBundle\Entity\ReservationPeriod;
  18. use App\MDS\GreenPatioBundle\Form\ReservationGpPriceType;
  19. use App\MDS\GreenPatioBundle\Form\ReservationLoungeDetailsType;
  20. use App\MDS\GreenPatioBundle\Form\ReservationLoungeProfileType;
  21. use App\MDS\GreenPatioBundle\Form\ReservationPeriodType;
  22. use App\MDS\GreenPatioBundle\Form\ReservationType;
  23. use App\Service\SincGpHtAvService;
  24. use Doctrine\ORM\EntityManagerInterface;
  25. use Symfony\Component\Routing\Annotation\Route;
  26. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  27. use Symfony\Component\HttpFoundation\Request;
  28. use DateTime;
  29. use DatePeriod;
  30. use DateInterval;
  31. use Google_Client;
  32. use Google_Service_Calendar;
  33. use Symfony\Contracts\Translation\TranslatorInterface;
  34. use Symfony\Component\HttpFoundation\JsonResponse;
  37. class ReservationsQuoteController extends AbstractController
  38. {
  39.     public function __construct(TranslatorInterface $translator,  SincGpHtAvService $sincGpHtAvService)
  40.     {
  41.         $redirect_uri = 'https://' . $_SERVER['HTTP_HOST']. '/calendar/token';
  42.         $googleCalendar = new Google_Client();
  43.         $googleCalendar->setApplicationName('Google Calendar API PHP Quickstart');
  44.         //campos a extraer de la base de datos User
  45.         $googleCalendar->setClientId('2790497987-57qc3vu4pr7vb0s8phpub2me58pe34lb.apps.googleusercontent.com');
  46.         $googleCalendar->setClientSecret('nj2C7unaTO68DRhyORsyipSj');
  47.         //fin campos user
  48. //        $api_key = "AIzaSyBR84cS1IU2BPvk5V3VnbqdkJESlv440Ac";
  49. //        $client->setDeveloperKey($api_key);
  50.         $googleCalendar->setRedirectUri($redirect_uri);
  51.         $googleCalendar->addScope(Google_Service_Calendar::CALENDAR);
  52.         $guzzleClient = new \GuzzleHttp\Client(array('curl' => array(CURLOPT_SSL_VERIFYPEER => false)));
  53.         $googleCalendar->setHttpClient($guzzleClient);
  54.         $this->googleCalendar = $googleCalendar;
  55.         $this->translator = $translator;
  56.         $this->sincGpHtAvService = $sincGpHtAvService;
  57.     }
  59.     private $sincGpHtAvService;
  61.     /**
  62.      * @Route("/createsimplelounge/{id}", name="reservations_greenpatio_create_simple_lounge")
  63.      * Crea un Reservation Lounge Simple en la cotizacion
  64.      */
  65.     public function createSimpleLoungeAction($id, EntityManagerInterface $em, Request $request)
  66.     {
  67.         $simpleLounge = $request->request->get('reservation_sala');
  68.         $loungeProfile = $em->getRepository(ReservationLoungeDetails::class)->findOneById($simpleLounge['salaPrecargadas']);
  69.         $loungeId = $loungeProfile->getId();
  70.         $loungeDetails = $em->getRepository(ReservationLoungeDetails::class)->findOneById($loungeId);
  71.         $previusLoungeSimple = $em->getRepository(ReservationLoungeSimple::class)->findOneBy(array('idLounge' => $loungeId, 'idReservation' => $id, 'rankQuote' => $simpleLounge['idQuote']));
  73.         //Buscamos si hay ya alguna sala en la reserva
  74.         $anyLoungeSimple = $em->getRepository(ReservationLoungeSimple::class)->findOneBy(array('idLounge' => $loungeId, 'idReservation' => $id));
  75.         $idioma = 1;
  76.         if($anyLoungeSimple){
  77.             $idioma = $anyLoungeSimple->getLanguage();
  78.         }
  79.         $loungeWebDescription = $em->getRepository(ReservationLoungeWebDescription::class)->findOneBy(array('lounge' => $loungeProfile, 'language' => $idioma));
  80.         $loungeName = $loungeDetails->getName();
  81.         $hourMinStart = $simpleLounge['hourStart'];
  82.         $hourMinEnd = $simpleLounge['hourEnd'];
  83.         $loungeSummaryDescription = array_key_exists('importantDescription', $simpleLounge) ? $simpleLounge['importantDescription'] : null;
  84.         if (empty($previusLoungeSimple)) {
  85.             if (empty($loungeSummaryDescription)) { $loungeSummaryDescription = $loungeWebDescription->getImportantDescription(); }
  86.             $loungeImportantDescGeneralText = $loungeWebDescription->getImportantDescGeneralText();
  87.             $loungeImportantDescSchedules = $loungeWebDescription->getImportantDescSchedules();
  88.             $loungeImportantDescParking = $loungeWebDescription->getImportantDescParking();
  89.         } else {
  90.             $loungeSummaryDescription = $previusLoungeSimple->getImportantDescription();
  91.             $loungeImportantDescGeneralText = $previusLoungeSimple->getImportantDescGeneralText();
  92.             $loungeImportantDescSchedules = $previusLoungeSimple->getImportantDescSchedules();
  93.             $loungeImportantDescParking = $previusLoungeSimple->getImportantDescParking();
  94.         }
  95.         
  96.         $iva = 21;
  97.         if (array_key_exists('iva', $simpleLounge)) {
  98.             if (empty($simpleLounge['iva']) && !is_numeric($simpleLounge['iva'])) {
  99.                 $iva = 21;
  100.             } else {
  101.                 $iva = $simpleLounge['iva'];
  102.             }
  103.         }
  105.         $qb = $em->getRepository(ReservationLoungeSimple::class)->createQueryBuilder('r');
  106.         $reservationAll = $qb->where('r.idReservation = :idReservation')
  107.             ->setParameter('idReservation', $id)
  108.             ->orderBy('r.rankQuote', 'ASC')
  109.             ->getQuery()
  110.             ->getResult();
  112.         $newRankId = (!empty($reservationAll)) ? (end($reservationAll)->getRankQuote() + 1) : 1;
  113.         if (!empty($simpleLounge['idQuote'])){ if (is_numeric($simpleLounge['idQuote'])){ $newRankId = $simpleLounge['idQuote']; } }
  115.         // Autocompletacion HH:mm en Start
  116.         switch (strlen($hourMinStart)) {
  117.             case 0:
  118.                 // Vacio
  119.                 $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  120.                 break;
  121.             case 1:
  122.                 // H  -> 0H:00
  123.                 if (is_numeric($hourMinStart)){
  124.                     $hourStart = '0'.$hourMinStart; $minStart = '00'; $hourMinStart = $hourStart.':'.$minStart;
  125.                 } else {
  126.                     $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  127.                 }
  128.                 break;
  129.             case 2:
  130.                 // HH  -> HH:00
  131.                 if (is_numeric($hourMinStart)){
  132.                     $hourStart = $hourMinStart; $minStart = '00'; $hourMinStart = $hourStart.':'.$minStart;
  133.                 } else {
  134.                     $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  135.                 }
  136.                 break;
  137.             case 3:
  138.                 // Hmm  -> 0H:mm
  139.                 if (is_numeric($hourMinStart)){
  140.                     $hourStart = '0'.substr($hourMinStart,0,1); $minStart = substr($hourMinStart,1,2); $hourMinStart = $hourStart.':'.$minStart;
  141.                 } else {
  142.                     $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  143.                 }
  144.                 break;
  145.             case 4:
  146.                 // HHmm  -> HH:mm
  147.                 if (is_numeric($hourMinStart)){
  148.                     $hourStart = substr($hourMinStart,0,2); $minStart = substr($hourMinStart,2,2); $hourMinStart = $hourStart.':'.$minStart;
  149.                 } else {
  150.                     $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  151.                 }
  152.                 break;
  153.             case 5:
  154.                 // HH:mm
  155.                 if (is_numeric(substr($hourMinStart,0,2)) and (substr($hourMinStart,2,1)==':') and is_numeric(substr($hourMinStart,0,2))){
  156.                     $hourStart = substr($hourMinStart,0,2); $minStart = substr($hourMinStart,3,2); $hourMinStart = $hourStart.':'.$minStart;
  157.                 } else {
  158.                     $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  159.                 }
  160.                 break;
  162.             default:
  163.                 // XXXXyyy
  164.                 $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  165.                 break;
  166.         }
  168.         // Autocompletacion HH:mm en End
  169.         switch (strlen($hourMinEnd)) {
  170.             case 0:
  171.                 // Vacio
  172.                 $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  173.                 break;
  174.             case 1:
  175.                 // H  -> 0H:00
  176.                 if (is_numeric($hourMinEnd)){
  177.                     $hourEnd = '0'.$hourMinEnd; $minEnd = '00'; $hourMinEnd = $hourEnd.':'.$minEnd;
  178.                 } else {
  179.                     $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  180.                 }
  181.                 break;
  182.             case 2:
  183.                 // HH  -> HH:00
  184.                 if (is_numeric($hourMinEnd)){
  185.                     $hourEnd = $hourMinEnd; $minEnd = '00'; $hourMinEnd = $hourEnd.':'.$minEnd;
  186.                 } else {
  187.                     $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  188.                 }
  189.                 break;
  190.             case 3:
  191.                 // Hmm  -> 0H:mm
  192.                 if (is_numeric($hourMinEnd)){
  193.                     $hourEnd = '0'.substr($hourMinEnd,0,1); $minEnd = substr($hourMinEnd,1,2); $hourMinEnd = $hourEnd.':'.$minEnd;
  194.                 } else {
  195.                     $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  196.                 }
  197.                 break;
  198.             case 4:
  199.                 // HHmm  -> HH:mm
  200.                 if (is_numeric($hourMinEnd)){
  201.                     $hourEnd = substr($hourMinEnd,0,2); $minEnd = substr($hourMinEnd,2,2); $hourMinEnd = $hourEnd.':'.$minEnd;
  202.                 } else {
  203.                     $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  204.                 }
  205.                 break;
  206.             case 5:
  207.                 // HH:mm
  208.                 if (is_numeric(substr($hourMinEnd,0,2)) and (substr($hourMinEnd,2,1)==':') and is_numeric(substr($hourMinEnd,0,2))){
  209.                     $hourEnd = substr($hourMinEnd,0,2); $minEnd = substr($hourMinEnd,3,2); $hourMinEnd = $hourEnd.':'.$minEnd;
  210.                 } else {
  211.                     $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  212.                 }
  213.                 break;
  215.             default:
  216.                 // XXXXyyy
  217.                 $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  218.                 break;
  219.         }
  221.         $dateStart = new DateTime($simpleLounge['dateStart'] . ' '. $hourMinStart);
  222.         $dateEnd = new DateTime($simpleLounge['dateStart'] . ' '. $hourMinEnd);   // Se usa DateStart por que solo hay un dia en el formulario
  223.         $idService = 0;
  224.         $serviceName = '';
  225.         $servicePrice = (empty($simpleLounge['servicePrice'])) ? 0 :$simpleLounge['servicePrice'];
  226.         $idReservation = $id;
  227.         /* Obtengo usuario logueado */
  228.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  229.         $user_id = $user_logueado->getId();
  230.         $createdAt = new DateTime('now');
  231.         $createdBy = $user_id;
  232.         $updatedAt = new DateTime('now');
  233.         $updatedBy = $user_id;
  234.         $pax = $simpleLounge['pax']; if (empty($pax)){$pax = 0;}
  236.         $lounge = new ReservationLoungeSimple();
  237.         $lounge->setIdLounge ($loungeId);
  238.         $lounge->setHourStart ($hourStart);
  239.         $lounge->setMinStart ($minStart);
  240.         $lounge->setHourEnd ($hourEnd);
  241.         $lounge->setMinEnd ($minEnd);
  242.         $lounge->setLoungeName ($loungeName);
  243.         $lounge->setDateStart ($dateStart);
  244.         $lounge->setDateEnd ($dateEnd);
  245.         $lounge->setRankQuote(1);
  246.         $lounge->setIdReservation ($idReservation);
  247.         $lounge->setIva($iva);
  248.         $lounge->setOpIva(1);
  249.         $lounge->setCreatedAt ($createdAt);
  250.         $lounge->setCreatedBy ($createdBy);
  251.         $lounge->setUpdatedAt ($updatedAt);
  252.         $lounge->setUpdatedBy ($updatedBy);
  253.         $lounge->setPax ($pax);
  254.         $lounge->setRankQuote($newRankId);
  255.         $lounge->setImportantDescription($loungeSummaryDescription);
  256.         $lounge->setImportantDescGeneralText($loungeImportantDescGeneralText);
  257.         $lounge->setImportantDescSchedules($loungeImportantDescSchedules);
  258.         $lounge->setImportantDescParking($loungeImportantDescParking);
  260.         $price = $this->precioTarifario($dateStart, $loungeId, $servicePrice);
  262.         $lounge->setServicePrice($price);
  263. //    *-+*-+*-+*-+ agregar mensajereservationerror si choca con alguna sala en confirmado o facturado
  264.         try{
  265.             $em->persist($lounge);
  266.             $em->flush();
  267.             $event = 'The Reservation has been updated.';
  268.             $successMessage = $this->translator->trans($event);
  269.             $this->addFlash('mensajereservation', $successMessage);
  270.         } catch (\Exception $e){
  271.             $event = 'An error occurred: '.$e->getMessage();
  272.             $errorMessage = $this->translator->trans($event);
  273.             $this->addFlash('mensajereservationerror', $errorMessage);
  274.         }
  276.         // INICIO: Actualizacion de fecha de inicio y fin del evento, a partir de la info de la sala
  277.         $boolSincGpAv = false;
  278.         $reserva = $em->getRepository(Reservation::class)->findOneById($idReservation);
  280.         if ($reserva->getDateStart() > $dateStart){ $reserva->setDateStart($dateStart); $boolSincGpAv = true; }
  281.         if ($reserva->getDateStart()->format('Y') == '2078' ){ $reserva->setDateStart($dateStart); $boolSincGpAv = true; }
  282.         if ($reserva->getDateEnd() < $dateEnd){ $reserva->setDateEnd($dateEnd); $boolSincGpAv = true; }
  283.         if ($reserva->getDateEnd()->format('Y') == '2000' ){ $reserva->setDateEnd($dateEnd); $boolSincGpAv = true; }
  285.         try{
  286.             $em->persist($reserva);
  287.             $em->flush();
  288.             $event = '';
  289.             $successMessage = $this->translator->trans($event);
  290.             $this->addFlash('mensajereservation', $successMessage);
  292.         } catch (\Exception $e){}
  294.         // Sincronización global de todos los campos
  295.         if ($boolSincGpAv){
  296.             $data = $this->sincGpHtAvService->sincGlobalGpHtAv($id);
  297.         }
  299.         // Sincronización con Av Express
  300.         if ($boolSincGpAv) {
  301.             $AveFile = $em->getRepository(AveFiles::class)->findByReservation($reserva);
  302.             if (($reserva->getStatus() == 'Confirmed') or ($reserva->getStatus() == 'Cotizado') or ($reserva->getStatus() == 'Invoiced') or ($reserva->getStatus() == 'Bloqueo')) {
  303.                 if (empty($AveFile)) {
  304.                     // Si no se ha creado aun el expediente de Av Express debemos crearlo
  305.                     return $this->redirectToRoute('sinc_gp_ave', array('id' => $id,));
  306.                 }
  307.             }
  308.         }
  309.         // FIN: Actualizacion de fecha de inicio y fin del evento, a partir de la info de la sala
  311.         // Se debe redirigir para agregar el Servicio de limpieza
  313.         return $this->redirectToRoute('reservations_white_addservices_cleaning',
  314.             array(
  315.                 'resid' => $id,
  316.                 'loungesimpleid' => $lounge->getId(),
  317.             ));
  318.     }
  321.     /**
  322.      * @Route("/api/get-price", name="get_reservations_price_to_view", methods={"GET"})
  323.      */
  324.     public function getPrice(Request $request)
  325.     {
  326.         $loungeId = $request->query->get('sala');
  327.         $dateStart = $request->query->get('date');
  329.         if (!$loungeId || !$dateStart) {
  330.             return new JsonResponse(['error' => 'Missing parameters'], 400);
  331.         }
  333.         try {
  334.             $dateStartObj = new \DateTime($dateStart);
  335.         } catch (\Exception $e) {
  336.             return new JsonResponse(['error' => 'Invalid date'], 400);
  337.         }
  339.         $price = $this->precioTarifario($dateStartObj, $loungeId, 0);
  341.         return new JsonResponse(['price' => $price]);
  342.     }
  345.     /**
  346.      * @Route("/createsimpleloungemondes/{id}", name="reservations_greenpatio_create_simple_lounge_mondes")
  347.      * Se crea un dia de montaje o desmontaje
  348.      */
  349.     public function createSimpleLoungeMonDesAction($id, EntityManagerInterface $em, Request $request)
  350.     {
  351.         $simpleLounge = $request->request->get('reservation_sala_mondes');
  352.         $loungeId = $simpleLounge['idLounge'];
  353.         $loungeDetails = $em->getRepository(ReservationLoungeDetails::class)->findOneById($loungeId);
  354.         $previusLoungeSimple = $em->getRepository(ReservationLoungeSimple::class)->findOneBy(array('idLounge' => $loungeId, 'idReservation' => $id, 'rankQuote' => $simpleLounge['idQuote']));
  355.         $loungeName = $loungeDetails->getName();
  356.         $hourMinStart = $simpleLounge['hourStart'];
  357.         $hourMinEnd = $simpleLounge['hourEnd'];
  358.         $ivaNew = empty($simpleLounge['iva']) ? 21 : $simpleLounge['iva'];
  359.         if (empty($previusLoungeSimple)) {
  360.             $loungeSummaryDescription = $loungeDetails->getImportantDescription();
  361.             $loungeImportantDescGeneralText = $loungeDetails->getImportantDescGeneralText();
  362.             $loungeImportantDescSchedules = $loungeDetails->getImportantDescSchedules();
  363.             $loungeImportantDescParking = $loungeDetails->getImportantDescParking();
  364.         } else {
  365.             $loungeSummaryDescription = $previusLoungeSimple->getImportantDescription();
  366.             $loungeImportantDescGeneralText = $previusLoungeSimple->getImportantDescGeneralText();
  367.             $loungeImportantDescSchedules = $previusLoungeSimple->getImportantDescSchedules();
  368.             $loungeImportantDescParking = $previusLoungeSimple->getImportantDescParking();
  369.         }
  371.         $qb = $em->getRepository(ReservationLoungeSimple::class)->createQueryBuilder('r');
  372.         $reservationAll = $qb->where('r.idReservation = :idReservation')
  373.             ->setParameter('idReservation', $id)
  374.             ->orderBy('r.rankQuote', 'ASC')
  375.             ->getQuery()
  376.             ->getResult();
  378.         $newRankId = (!empty($reservationAll)) ? (end($reservationAll)->getRankQuote() + 1) : 1;
  379.         if (!empty($simpleLounge['idQuote'])){ if (is_numeric($simpleLounge['idQuote'])){ $newRankId = $simpleLounge['idQuote']; } }
  381.         // Autocompletacion HH:mm en Start
  382.         switch (strlen($hourMinStart)) {
  383.             case 0:
  384.                 // Vacio
  385.                 $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  386.                 break;
  387.             case 1:
  388.                 // H  -> 0H:00
  389.                 if (is_numeric($hourMinStart)){
  390.                     $hourStart = '0'.$hourMinStart; $minStart = '00'; $hourMinStart = $hourStart.':'.$minStart;
  391.                 } else {
  392.                     $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  393.                 }
  394.                 break;
  395.             case 2:
  396.                 // HH  -> HH:00
  397.                 if (is_numeric($hourMinStart)){
  398.                     $hourStart = $hourMinStart; $minStart = '00'; $hourMinStart = $hourStart.':'.$minStart;
  399.                 } else {
  400.                     $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  401.                 }
  402.                 break;
  403.             case 3:
  404.                 // Hmm  -> 0H:mm
  405.                 if (is_numeric($hourMinStart)){
  406.                     $hourStart = '0'.substr($hourMinStart,0,1); $minStart = substr($hourMinStart,1,2); $hourMinStart = $hourStart.':'.$minStart;
  407.                 } else {
  408.                     $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  409.                 }
  410.                 break;
  411.             case 4:
  412.                 // HHmm  -> HH:mm
  413.                 if (is_numeric($hourMinStart)){
  414.                     $hourStart = substr($hourMinStart,0,2); $minStart = substr($hourMinStart,2,2); $hourMinStart = $hourStart.':'.$minStart;
  415.                 } else {
  416.                     $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  417.                 }
  418.                 break;
  419.             case 5:
  420.                 // HH:mm
  421.                 if (is_numeric(substr($hourMinStart,0,2)) and (substr($hourMinStart,2,1)==':') and is_numeric(substr($hourMinStart,0,2))){
  422.                     $hourStart = substr($hourMinStart,0,2); $minStart = substr($hourMinStart,3,2); $hourMinStart = $hourStart.':'.$minStart;
  423.                 } else {
  424.                     $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  425.                 }
  426.                 break;
  428.             default:
  429.                 // XXXXyyy
  430.                 $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  431.                 break;
  432.         }
  434.         // Autocompletacion HH:mm en End
  435.         switch (strlen($hourMinEnd)) {
  436.             case 0:
  437.                 // Vacio
  438.                 $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  439.                 break;
  440.             case 1:
  441.                 // H  -> 0H:00
  442.                 if (is_numeric($hourMinEnd)){
  443.                     $hourEnd = '0'.$hourMinEnd; $minEnd = '00'; $hourMinEnd = $hourEnd.':'.$minEnd;
  444.                 } else {
  445.                     $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  446.                 }
  447.                 break;
  448.             case 2:
  449.                 // HH  -> HH:00
  450.                 if (is_numeric($hourMinEnd)){
  451.                     $hourEnd = $hourMinEnd; $minEnd = '00'; $hourMinEnd = $hourEnd.':'.$minEnd;
  452.                 } else {
  453.                     $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  454.                 }
  455.                 break;
  456.             case 3:
  457.                 // Hmm  -> 0H:mm
  458.                 if (is_numeric($hourMinEnd)){
  459.                     $hourEnd = '0'.substr($hourMinEnd,0,1); $minEnd = substr($hourMinEnd,1,2); $hourMinEnd = $hourEnd.':'.$minEnd;
  460.                 } else {
  461.                     $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  462.                 }
  463.                 break;
  464.             case 4:
  465.                 // HHmm  -> HH:mm
  466.                 if (is_numeric($hourMinEnd)){
  467.                     $hourEnd = substr($hourMinEnd,0,2); $minEnd = substr($hourMinEnd,2,2); $hourMinEnd = $hourEnd.':'.$minEnd;
  468.                 } else {
  469.                     $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  470.                 }
  471.                 break;
  472.             case 5:
  473.                 // HH:mm
  474.                 if (is_numeric(substr($hourMinEnd,0,2)) and (substr($hourMinEnd,2,1)==':') and is_numeric(substr($hourMinEnd,0,2))){
  475.                     $hourEnd = substr($hourMinEnd,0,2); $minEnd = substr($hourMinEnd,3,2); $hourMinEnd = $hourEnd.':'.$minEnd;
  476.                 } else {
  477.                     $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  478.                 }
  479.                 break;
  481.             default:
  482.                 // XXXXyyy
  483.                 $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  484.                 break;
  485.         }
  487.         $dateStart = new DateTime($simpleLounge['dateStart'] . ' '. $hourMinStart);
  488.         $dateEnd = new DateTime($simpleLounge['dateStart'] . ' '. $hourMinEnd);   // Se usa DateStart por que solo hay un dia en el formulario
  489.         $servicePrice = empty($simpleLounge['servicePrice']) ? 0 :$simpleLounge['servicePrice'];
  490.         $idReservation = $id;
  491.         /* Obtengo usuario logueado */
  492.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  493.         $user_id = $user_logueado->getId();
  494.         $createdAt = new DateTime('now');
  495.         $createdBy = $user_id;
  496.         $updatedAt = new DateTime('now');
  497.         $updatedBy = $user_id;
  498.         $lounge = new ReservationLoungeSimple();
  500.         if ($simpleLounge['type'] == 'Montaje'){ $lounge->setType ('Montaje'); } else {  $lounge->setType ('Desmontaje'); }
  501.         $pax = null;
  502.         $lounge->setIdLounge ($loungeId);
  503.         $lounge->setHourStart ($hourStart);
  504.         $lounge->setMinStart ($minStart);
  505.         $lounge->setHourEnd ($hourEnd);
  506.         $lounge->setMinEnd ($minEnd);
  507.         $lounge->setLoungeName ($loungeName);
  508.         $lounge->setDateStart ($dateStart);
  509.         $lounge->setDateEnd ($dateEnd);
  510.         $lounge->setRankQuote(1);
  511.         $lounge->setIva($ivaNew);
  512.         $lounge->setOpIva(1);
  513.         $lounge->setIdReservation ($idReservation);
  514.         $lounge->setCreatedAt ($createdAt);
  515.         $lounge->setCreatedBy ($createdBy);
  516.         $lounge->setUpdatedAt ($updatedAt);
  517.         $lounge->setUpdatedBy ($updatedBy);
  518.         $lounge->setPax ($pax);
  519.         $lounge->setRankQuote($newRankId);
  520.         $lounge->setImportantDescription($loungeSummaryDescription);
  521.         $lounge->setImportantDescGeneralText($loungeImportantDescGeneralText);
  522.         $lounge->setImportantDescSchedules($loungeImportantDescSchedules);
  523.         $lounge->setImportantDescParking($loungeImportantDescParking);
  525.         $price = $this->precioPorFecha($dateStart, $loungeId);
  526.         $servicePrice = ($price['price'] == 0) ? $servicePrice : $price;
  527.         $lounge->setServicePrice($servicePrice);
  529.         try{
  530.             $em->persist($lounge);
  531.             $em->flush();
  532.             $event = 'The Reservation has been updated.';
  533.             $successMessage = $this->translator->trans($event);
  534.             $this->addFlash('mensajereservation', $successMessage);
  536.         } catch (\Exception $e){
  538.             $event = 'An error occurred: '.$e->getMessage();
  539.             $errorMessage = $this->translator->trans($event);
  540.             $this->addFlash('mensajereservationerror', $errorMessage);
  541.         }
  543.         $reservax = $em->getRepository(Reservation::class)->findOneById($idReservation);
  545.         // INICIO: Verificamos si es necesario actualizar las fechas de la reserva
  546.         $boolReserva = false;
  547.         if ($lounge->getDateStart() < $reservax->getDateStart()){
  548.             $reservax->setDateStart($lounge->getDateStart());
  549.             $boolReserva = true;
  550.         }
  552.         if ($reservax->getDateEnd() < $lounge->getDateEnd()){
  553.             $reservax->setDateEnd($lounge->getDateEnd());
  554.             $boolReserva = true;
  555.         }
  556.         if ($boolReserva){
  557.             $em->persist($reservax);
  558.             $em->flush();
  560.             // Sincronización global de todos los campos
  561.             $data = $this->sincGpHtAvService->sincGlobalGpHtAv($id);
  562.         }
  563.         $boolSincGpAv = $boolReserva;
  564.         // Sincronización con Av Express
  565.         if ($boolSincGpAv) {
  566.             $AveFile = $em->getRepository(AveFiles::class)->findByReservation($reservax);
  567.             if (($reservax->getStatus() == 'Confirmed') or ($reservax->getStatus() == 'Cotizado') or ($reservax->getStatus() == 'Invoiced') or ($reservax->getStatus() == 'Bloqueo')) {
  568.                 if (empty($AveFile)) {
  569.                     // Si no se ha creado aun el expediente de Av Express debemos crearlo
  570.                     return $this->redirectToRoute('sinc_gp_ave', array('id' => $id,));
  571.                 }
  572.             }
  573.         }
  574.         // FIN: Verificamos si es necesario actualizar las fechas de la reserva
  576.         return $this->redirectToRoute('reservations_greenpatio_edit_simple',
  577.             array(
  578.                 'id' => $id,
  579.                 'token' => null,
  580.                 '_fragment' => 'btn_quotes'
  581.             ));
  582.     }
  585.     /**
  586.      * @Route("/duplicateday/{id}/{dayduplicate}/{idRankQuote}", name="reservations_greenpatio_duplicate_day")
  587.      * Duplica un elemento de la cotizacion para el dia siguiente
  588.      */
  589.     public function duplicateDayAction($id, $dayduplicate, $idRankQuote, EntityManagerInterface $em, Request $request)
  590.     {
  591.         $loungeSimples = $em->getRepository(ReservationLoungeSimple::class)->findByIdReservation($id);
  592.         $reservax = $em->getRepository(Reservation::class)->findOneById($id);
  594.         /* Obtengo usuario logueado */
  595.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  596.         $user_id = $user_logueado->getId();
  597.         $createdAt = new DateTime('now');
  598.         $createdBy = $user_id;
  599.         $updatedAt = new DateTime('now');
  600.         $updatedBy = $user_id;
  602.         if (!empty($loungeSimples)){
  603.             foreach ($loungeSimples as $item){
  604.                 if (($item->getDateStart()->format('d-m-Y') == $dayduplicate) and ($item->getRankQuote() == $idRankQuote)){
  605.                     // Se duplica y suma un dia
  606.                     $newLoungeSimple = new ReservationLoungeSimple();
  607.                     $newLoungeSimple->setDateStart($item->getDateStart()->modify('+1 day'));
  608.                     $newLoungeSimple->setDateEnd($item->getDateEnd()->modify('+1 day'));
  609.                     $newLoungeSimple->setHourStart($item->getHourStart());
  610.                     $newLoungeSimple->setHourEnd($item->getHourEnd());
  611.                     $newLoungeSimple->setMinStart($item->getMinStart());
  612.                     $newLoungeSimple->setMinEnd($item->getMinEnd());
  613.                     $newLoungeSimple->setIdLounge($item->getIdLounge());
  614.                     $newLoungeSimple->setIdReservation($item->getIdReservation());
  615.                     $newLoungeSimple->setLoungeName($item->getLoungeName());
  616.                     $newLoungeSimple->setPax($item->getPax());
  617.                     $newLoungeSimple->setServicePrice($item->getServicePrice());
  618.                     $newLoungeSimple->setIva($item->getIva());
  619.                     $newLoungeSimple->setOpIva($item->getOpIva());
  620.                     $newLoungeSimple->setType($item->getType());
  621.                     $newLoungeSimple->setLoungeDescription($item->getLoungeDescription());
  622.                     $newLoungeSimple->setImportantDescription($item->getImportantDescription());
  623.                     $newLoungeSimple->setImportantDescGeneralText($item->getImportantDescGeneralText());
  624.                     $newLoungeSimple->setImportantDescSchedules($item->getImportantDescSchedules());
  625.                     $newLoungeSimple->setImportantDescParking($item->getImportantDescParking());
  626.                     $newLoungeSimple->setRankQuote($idRankQuote);
  627.                     $newLoungeSimple->setCreatedAt($createdAt);
  628.                     $newLoungeSimple->setCreatedBy($createdBy);
  629.                     $newLoungeSimple->setUpdatedAt($updatedAt);
  630.                     $newLoungeSimple->setUpdatedBy($updatedBy);
  632.                     try{
  633.                         $em->persist($newLoungeSimple);
  634.                         $em->flush();
  635.                         $event = 'The Item has been duplicated.';
  636.                         $successMessage = $this->translator->trans($event);
  637.                         $this->addFlash('mensajereservation', $successMessage);
  639.                     } catch (\Exception $e){
  641.                         $event = 'An error occurred: '.$e->getMessage();
  642.                         $errorMessage = $this->translator->trans($event);
  643.                         $this->addFlash('mensajereservationerror', $errorMessage);
  644.                     }
  646.                     // INICIO: Verificamos si es necesario actualizar las fechas de la reserva
  647.                     $boolReserva = false;
  648.                     if ($newLoungeSimple->getDateStart() < $reservax->getDateStart()){
  649.                         $reservax->setDateStart($newLoungeSimple->getDateStart());
  650.                         $boolReserva = true;
  651.                     }
  653.                     if ($reservax->getDateEnd() < $newLoungeSimple->getDateEnd()){
  654.                         $reservax->setDateEnd($newLoungeSimple->getDateEnd());
  655.                         $boolReserva = true;
  656.                     }
  657.                     if ($boolReserva){
  658.                         $em->persist($reservax);
  659.                         $em->flush();
  661.                         // Sincronización global de todos los campos
  662.                         $data = $this->sincGpHtAvService->sincGlobalGpHtAv($id);
  663.                     }
  664.                     // FIN: Verificamos si es necesario actualizar las fechas de la reserva
  665.                 }
  666.             }
  667.         } else {
  668.             // registro antiguo, se pasara a los nuevos registros y luego duplicara
  669.             $loungeOld = $em->getRepository(ReservationLounge::class)->findByIdReservation($id);
  670.             foreach ($loungeOld as $item){
  671.                 if ($item->getDateStart()->format('Y-m-d') == $item->getDateEnd()->format('Y-m-d')){
  672.                     // Es el mismo dia, se crea un registro simple
  673.                     $newLoungeSimple = new ReservationLoungeSimple();
  674.                     $newLoungeSimple->setDateStart($item->getDateStart());
  675.                     $newLoungeSimple->setDateEnd($item->getDateEnd());
  676.                     $newLoungeSimple->setHourStart($item->getHourStart());
  677.                     $newLoungeSimple->setHourEnd($item->getHourEnd());
  678.                     $newLoungeSimple->setMinStart($item->getMinStart());
  679.                     $newLoungeSimple->setMinEnd($item->getMinEnd());
  680.                     $newLoungeSimple->setIdLounge($item->getIdLounge());
  681.                     $newLoungeSimple->setIdReservation($item->getIdReservation());
  682.                     $newLoungeSimple->setLoungeName($item->getLoungeName());
  683.                     $newLoungeSimple->setPax($item->getPax());
  684.                     $newLoungeSimple->setServicePrice($item->getServicePrice());
  685.                     $newLoungeSimple->setIva($item->getIva());
  686.                     $newLoungeSimple->setOpIva($item->getOpIva());
  687.                     $newLoungeSimple->setType($item->getType());
  688.                     $newLoungeSimple->setRankQuote($item->getRankQuote());
  689.                     $newLoungeSimple->setLoungeDescription($item->getLoungeDescription());
  690.                     $newLoungeSimple->setImportantDescription($item->getImportantDescription());
  691.                     $newLoungeSimple->setCreatedAt($createdAt);
  692.                     $newLoungeSimple->setCreatedBy($createdBy);
  693.                     $newLoungeSimple->setUpdatedAt($updatedAt);
  694.                     $newLoungeSimple->setUpdatedBy($updatedBy);
  696.                     try{
  697.                         $em->persist($newLoungeSimple);
  698.                         $em->flush();
  699.                         $event = 'The Item has been duplicated.';
  700.                         $successMessage = $this->translator->trans($event);
  701.                         $this->addFlash('mensajereservation', $successMessage);
  703.                     } catch (\Exception $e){
  705.                         $event = 'An error occurred: '.$e->getMessage();
  706.                         $errorMessage = $this->translator->trans($event);
  707.                         $this->addFlash('mensajereservationerror', $errorMessage);
  708.                     }
  710.                     // INICIO: Verificamos si es necesario actualizar las fechas de la reserva
  711.                     $boolReserva = false;
  712.                     if ($newLoungeSimple->getDateStart() < $reservax->getDateStart()){
  713.                         $reservax->setDateStart($newLoungeSimple->getDateStart());
  714.                         $boolReserva = true;
  715.                     }
  717.                     if ($reservax->getDateEnd() < $newLoungeSimple->getDateEnd()){
  718.                         $reservax->setDateEnd($newLoungeSimple->getDateEnd());
  719.                         $boolReserva = true;
  720.                     }
  721.                     if ($boolReserva){
  722.                         $em->persist($reservax);
  723.                         $em->flush();
  724.                     }
  725.                     // FIN: Verificamos si es necesario actualizar las fechas de la reserva
  727.                 } else {
  728.                     // Registro con varios dias, se calcula el numero de dias y se crean ese numero de registros nuevos
  729.                     $firstDay = $item->getDateStart();
  730.                     $firstDay = new DateTime($firstDay->format('Y-m-d'));
  731.                     $lastDay = $item->getDateEnd();
  732.                     $lastDay = new DateTime($lastDay->format('Y-m-d'));
  733.                     $numDays = ((($lastDay)->diff($firstDay))->days) +1;
  734.                     $actualDay = $item->getDateStart();
  735.                     $actualStartDay = $item->getDateStart();
  736.                     $actualEndDay = $item->getDateEnd();
  738.                     for ($i=0; $i<sizeof($numDays); $i++){
  739.                         // Se crea un registro por cada dia
  740.                         $newLoungeSimple = new ReservationLoungeSimple();
  741.                         if ($i == 0){
  742.                             // Primer dia
  743.                             $newLoungeSimple->setDateStart($actualStartDay);
  744.                             $actualStartDayEnd = new DateTime($actualStartDay->format('Y-m-d').' 23:59');
  745.                             $newLoungeSimple->setDateEnd($actualStartDayEnd);
  746.                             $newLoungeSimple->setHourStart($item->getHourStart());
  747.                             $newLoungeSimple->setHourEnd('23');
  748.                             $newLoungeSimple->setMinStart($item->getMinStart());
  749.                             $newLoungeSimple->setMinEnd('59');
  751.                         } else {
  752.                             if (($i + 1) == sizeof($numDays)){
  753.                                 // Ultimo dia
  754.                                 $actualEndDayStart = new DateTime($actualEndDay->format('Y-m-d').' 00:00');
  755.                                 $newLoungeSimple->setDateStart($actualEndDayStart);
  756.                                 $newLoungeSimple->setDateEnd($actualEndDay);
  757.                                 $newLoungeSimple->setHourStart('00');
  758.                                 $newLoungeSimple->setHourEnd($item->getHourEnd());
  759.                                 $newLoungeSimple->setMinStart('00');
  760.                                 $newLoungeSimple->setMinEnd($item->getMinEnd());
  762.                             } else {
  763.                                 // Dia intermedio
  764.                                 $actualMidDayStart = new DateTime($actualDay->format('Y-m-d').' 00:00');
  765.                                 $actualMidDayEnd = new DateTime($actualDay->format('Y-m-d').' 23:59');
  766.                                 $newLoungeSimple->setDateStart($actualMidDayStart);
  767.                                 $newLoungeSimple->setDateEnd($actualMidDayEnd);
  768.                                 $newLoungeSimple->setHourStart('00');
  769.                                 $newLoungeSimple->setHourEnd('23');
  770.                                 $newLoungeSimple->setMinStart('00');
  771.                                 $newLoungeSimple->setMinEnd('59');
  772.                             }
  773.                         }
  774.                         $newLoungeSimple->setIdLounge($item->getIdLounge());
  775.                         $newLoungeSimple->setIdReservation($item->getIdReservation());
  776.                         $newLoungeSimple->setLoungeName($item->getLoungeName());
  777.                         $newLoungeSimple->setPax($item->getPax());
  778.                         $newLoungeSimple->setServicePrice($item->getServicePrice());
  779.                         $newLoungeSimple->setIva($item->getIva());
  780.                         $newLoungeSimple->setOpIva($item->getOpIva());
  781.                         $newLoungeSimple->setType($item->getType());
  782.                         $newLoungeSimple->setRankQuote($item->getRankQuote());
  783.                         $newLoungeSimple->setLoungeDescription($item->getLoungeDescription());
  784.                         $newLoungeSimple->setImportantDescription($item->getImportantDescription());
  785.                         $newLoungeSimple->setCreatedAt($createdAt);
  786.                         $newLoungeSimple->setCreatedBy($createdBy);
  787.                         $newLoungeSimple->setUpdatedAt($updatedAt);
  788.                         $newLoungeSimple->setUpdatedBy($updatedBy);
  789.                         $actualDay = $actualDay->modify('+1 day');
  791.                         try{
  792.                             $em->persist($newLoungeSimple);
  793.                             $em->flush();
  794.                             $event = 'The Item has been updated.';
  795.                             $successMessage = $this->translator->trans($event);
  796.                             $this->addFlash('mensajereservation', $successMessage);
  798.                         } catch (\Exception $e){
  800.                             $event = 'An error occurred: '.$e->getMessage();
  801.                             $errorMessage = $this->translator->trans($event);
  802.                             $this->addFlash('mensajereservationerror', $errorMessage);
  803.                         }
  805.                         // INICIO: Verificamos si es necesario actualizar las fechas de la reserva
  806.                         $boolReserva = false;
  807.                         if ($newLoungeSimple->getDateStart() < $reservax->getDateStart()){
  808.                             $reservax->setDateStart($newLoungeSimple->getDateStart());
  809.                             $boolReserva = true;
  810.                         }
  812.                         if ($reservax->getDateEnd() < $newLoungeSimple->getDateEnd()){
  813.                             $reservax->setDateEnd($newLoungeSimple->getDateEnd());
  814.                             $boolReserva = true;
  815.                         }
  816.                         if ($boolReserva){
  817.                             $em->persist($reservax);
  818.                             $em->flush();
  819.                         }
  820.                         // FIN: Verificamos si es necesario actualizar las fechas de la reserva
  821.                     }
  822.                 }
  823.             }
  825.             // Se vuelve a llamar a este mismo controlador ahora con los registros en la nueva tabla
  826.             return $this->redirectToRoute('reservations_greenpatio_duplicate_day', array( 'id' => $id, 'dayduplicate' => $dayduplicate, ));
  827.         }
  829.         // Se debe redirigir para agregar el Servicio de limpieza
  830.         return $this->redirectToRoute('reservations_white_addservices_cleaning',
  831.             array(
  832.                 'resid' => $id,
  833.                 'loungesimpleid' => $newLoungeSimple->getId(),
  834.             ));
  835.     }
  838.     /**
  839.      * @Route("/deleteitemsimple/{id}/{daydelete}", name="reservations_greenpatio_delete_simple_lounge")
  840.      * Elimina un Reservation Simple Lounge de la cotizacion
  841.      */
  842.     public function deleteSimpleLoungeAction($id, $daydelete, EntityManagerInterface $em, Request $request)
  843.     {
  844.         $loungeSimple = $em->getRepository(ReservationLoungeSimple::class)->findOneById($id);
  845.         $id = $loungeSimple->getIdReservation();
  846.         $reserva = $em->getRepository(Reservation::class)->findOneById($loungeSimple->getIdReservation());
  848.         try{
  849.             $em->remove($loungeSimple);
  850.             $em->flush();
  851.             $event = 'The item has been deleted.';
  852.             $successMessage = $this->translator->trans($event);
  853.             $this->addFlash('mensajereservation', $successMessage);
  854.         } catch (\Exception $e){
  855.             $event = 'An error occurred: '.$e->getMessage();
  856.             $errorMessage = $this->translator->trans($event);
  857.             $this->addFlash('mensajereservationerror', $errorMessage);
  858.         }
  860.         // Si se elimina el primer dia o el ultimo, se debe modificar las fechas de la reserva
  861.         if(($reserva->getDateStart()->format('Ymd') == $loungeSimple->getDateStart()->format('Ymd')) or ($reserva->getDateEnd()->format('Ymd') == $loungeSimple->getDateEnd()->format('Ymd'))){
  862.             $allLoungeSimples = $em->getRepository(ReservationLoungeSimple::class)->findByIdReservation($reserva->getId());
  863.             if (!empty($allLoungeSimples)){
  864.                 $reserva->setDateStart(new DateTime('2078-01-01'));
  865.                 $reserva->setDateEnd(new DateTime('2000-01-01'));
  867.                 foreach ($allLoungeSimples as $newLoungeSimple){
  868.                     // INICIO: Verificamos si es necesario actualizar las fechas de la reserva
  869.                     $boolReserva = false;
  870.                     if ($newLoungeSimple->getDateStart() < $reserva->getDateStart()){
  871.                         $reserva->setDateStart($newLoungeSimple->getDateStart());
  872.                         $boolReserva = true;
  873.                     }
  875.                     if ($reserva->getDateEnd() < $newLoungeSimple->getDateEnd()){
  876.                         $reserva->setDateEnd($newLoungeSimple->getDateEnd());
  877.                         $boolReserva = true;
  878.                     }
  879.                     if ($boolReserva){
  880.                         $em->persist($reserva);
  881.                         $em->flush();
  882.                     }
  883.                     // FIN: Verificamos si es necesario actualizar las fechas de la reserva
  884.                 }
  885.             } else {
  886.                 // Se elimino la ultima sala y la reserva queda vacia
  887.                 $reserva->setDateStart(new DateTime('2078-01-01'));
  888.                 $reserva->setDateEnd(new DateTime('2000-01-01'));
  890.                 $em->persist($reserva);
  891.                 $em->flush();
  892.             }
  894.             // Sincronización global de todos los campos
  895.             $data = $this->sincGpHtAvService->sincGlobalGpHtAv($reserva->getId());
  896.         }
  898.         // Se elimina el servicio de horas de limpieza de la sala
  899.         return $this->redirectToRoute('reservations_greenpatio_delete_simple_lounge_cleaning',
  900.             array(
  901.                 'idRes' => $id,
  902.                 'idLng' => $loungeSimple->getIdLounge(),
  903.                 'dateInAt' => $loungeSimple->getDateStart()->format('Y-m-d\TH:i'),
  904.                 'dateOutAt' => $loungeSimple->getDateEnd()->format('Y-m-d\TH:i'),
  905.             ));
  906.     }
  909.     /**
  910.      * @Route("/deletequote/{idRes}/{idQuote}", name="reservations_delete_quote")
  911.      * Eliminar una cotizancion
  912.      */
  913.     public function deleteQuoteAction( $idRes, $idQuote, EntityManagerInterface $em, Request $request)
  914.     {
  915.         $qb = $em->getRepository(ReservationLoungeSimple::class)->createQueryBuilder('r');
  916.         $reservation = $qb->where('r.rankQuote = :rankQuote')
  917.             ->andWhere('r.idReservation = :idReservation')
  918.             ->setParameter('idReservation', $idRes)
  919.             ->setParameter('rankQuote', $idQuote)
  920.             ->getQuery()
  921.             ->getResult();
  923.         foreach ($reservation as $item){
  924.             try{
  925.                 $em->remove($item);
  926.                 $em->flush();
  927.                 $event = 'Se ha eliminado la cotización';
  928.                 $successMessage = $this->translator->trans($event);
  929.                 $this->addFlash('mensajereservation', $successMessage);
  930.             } catch (\Exception $e){
  931.                 $event = 'An error occurred: '.$e->getMessage();
  932.                 $errorMessage = $this->translator->trans($event);
  933.                 $this->addFlash('mensajereservationerror', $errorMessage);
  934.             }
  936.             //Se deben eliminar todas las horas de limpieza asociadas a las salas de la cotización
  937.             $loungeDetails = $em->getRepository(ReservationLoungeDetails::class)->findOneById($item->getIdLounge());
  938.             $stringName = 'HORAS ( '.$loungeDetails->getName().' )';
  939.             $serviceCatIdClean = 21;
  940.             $dateInAt = new \DateTime($item->getDateStart()->format('Y-m-d\TH:i'));
  941.             $dateOutAt = new \DateTime($item->getDateEnd()->format('Y-m-d\TH:i'));
  943.             $qb = $em->getRepository(ReservationService::class)->createQueryBuilder('rs');
  945.             $serviceClean = $qb->where('rs.reservationId = :id')
  946.                 ->andWhere('rs.name = :name')
  947.                 ->andWhere('rs.dateInAt = :dateInAt')
  948.                 ->andWhere('rs.dateOutAt = :dateOutAt')
  949.                 ->andWhere('rs.serviceCatId = :serviceCatId')
  950.                 ->setParameter('id', $idRes)
  951.                 ->setParameter('name', $stringName)
  952.                 ->setParameter('dateInAt', $dateInAt)
  953.                 ->setParameter('dateOutAt', $dateOutAt)
  954.                 ->setParameter('serviceCatId', $serviceCatIdClean)
  955.                 ->getQuery()
  956.                 ->getResult();
  958.             if (!empty($serviceClean)) {
  959.                 // Se elimina el servicio de horas de limpieza de la sala
  960.                 $em->remove($serviceClean[0]);
  961.                 $em->flush();
  962.             }
  963.         }
  965.         // Recalculo de fechas del expediente
  966.         $data = $this->recalculoFechas($idRes);
  968.         // Sincronización global de todos los campos
  969.         $data = $this->sincGpHtAvService->sincGlobalGpHtAv($idRes);
  971.         return $this->redirectToRoute('reservations_greenpatio_edit_simple',
  972.             array(
  973.                 'id' => $idRes,
  974.                 'token' => null,
  975.                 '_fragment' => 'btn_quotes'
  976.             ));
  977.     }
  980.     /**
  981.      * @Route("/checkquote/{idRes}/{idQuote}", name="reservations_check_quote")
  982.      * Confirmación de que se ha aceptado la cotizancion, se eliminaran las otras cotizaciones del expediente
  983.      */
  984.     public function checkQuoteAction( $idRes, $idQuote, EntityManagerInterface $em, Request $request)
  985.     {
  986.         $qb = $em->getRepository(ReservationLoungeSimple::class)->createQueryBuilder('r');
  987.         $reservation = $qb->where('r.rankQuote <> :rankQuote')
  988.             ->andWhere('r.idReservation = :idReservation')
  989.             ->setParameter('idReservation', $idRes)
  990.             ->setParameter('rankQuote', $idQuote)
  991.             ->getQuery()
  992.             ->getResult();
  994.         foreach ($reservation as $item){
  995.             try{
  996.                 $em->remove($item);
  997.                 $em->flush();
  998.                 $event = 'Se han eliminado las otras cotizaciones';
  999.                 $successMessage = $this->translator->trans($event);
  1000.                 $this->addFlash('mensajereservation', $successMessage);
  1001.             } catch (\Exception $e){
  1002.                 $event = 'An error occurred: '.$e->getMessage();
  1003.                 $errorMessage = $this->translator->trans($event);
  1004.                 $this->addFlash('mensajereservationerror', $errorMessage);
  1005.             }
  1006.         }
  1008.         return $this->redirectToRoute('reservations_greenpatio_edit_simple',
  1009.             array(
  1010.                 'id' => $idRes,
  1011.                 'token' => null,
  1012.                 '_fragment' => 'btn_quotes'
  1013.             ));
  1014.     }
  1017.     /**
  1018.      * @Route("/duplicatequote", name="reservations_duplicate_quote")
  1019.      * Duplicar una cotizacion
  1020.      */
  1021.     public function duplicateQuoteAction( EntityManagerInterface $em, Request $request) {
  1023.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1024.         $user_id = $user_logueado->getId();
  1025.         $hoy = new \DateTime("now", NULL);
  1026.         $reqDuplicateQuote = $request->request->get('addquote');
  1027.         $newLounge = $em->getRepository(ReservationLoungeDetails::class)->findOneById($reqDuplicateQuote['salaPrecargadas']);
  1029.         $qb = $em->getRepository(ReservationLoungeSimple::class)->createQueryBuilder('r');
  1030.         $reservationAll = $qb->where('r.idReservation = :idReservation')
  1031.             ->setParameter('idReservation', $reqDuplicateQuote['reservationId'])
  1032.             ->orderBy('r.rankQuote', 'ASC')
  1033.             ->getQuery()
  1034.             ->getResult();
  1036.         $newRankId = (!empty($reservationAll)) ? (end($reservationAll)->getRankQuote() + 1) : 1;
  1037.         if (empty($reqDuplicateQuote['idQuote'])) { $reqDuplicateQuote['idQuote'] = reset($reservationAll)->getRankQuote(); }   //Si no elige cotización se duplica la primera
  1039.         $qb = $em->getRepository(ReservationLoungeSimple::class)->createQueryBuilder('r');
  1040.         $reservation = $qb->where('r.rankQuote = :rankQuote')
  1041.             ->andWhere('r.idReservation = :idReservation')
  1042.             ->setParameter('idReservation', $reqDuplicateQuote['reservationId'])
  1043.             ->setParameter('rankQuote', $reqDuplicateQuote['idQuote'])
  1044.             ->getQuery()
  1045.             ->getResult();
  1047.         $loungeWebDetail = $em->getRepository(ReservationLoungeWebDescription::class)->findOneBy(array('lounge' => $newLounge->getId(), 'language' => 1));
  1048.         $loungeWebDetail = empty($loungeWebDetail) ? $newLounge : $loungeWebDetail;
  1050.         foreach ($reservation as $item){
  1051.             $newLoungeSimple = new ReservationLoungeSimple();
  1052.             $newLoungeSimple->setDateStart($item->getDateStart());
  1053.             $newLoungeSimple->setDateEnd($item->getDateEnd());
  1054.             $newLoungeSimple->setIdReservation($reqDuplicateQuote['reservationId']);
  1055.             $newLoungeSimple->setPax($item->getPax());
  1056.             $newLoungeSimple->setType($item->getType());
  1057.             $newLoungeSimple->setCreatedAt($hoy);
  1058.             $newLoungeSimple->setCreatedBy($user_id);
  1059.             $newLoungeSimple->setUpdatedAt($hoy);
  1060.             $newLoungeSimple->setUpdatedBy($user_id);
  1061.             $newLoungeSimple->setHourStart($item->getHourStart());
  1062.             $newLoungeSimple->setMinStart($item->getMinStart());
  1063.             $newLoungeSimple->setHourEnd($item->getHourEnd());
  1064.             $newLoungeSimple->setMinEnd($item->getMinEnd());
  1065.             $newLoungeSimple->setRankQuote($newRankId);
  1066.             $newLoungeSimple->setIva($item->getIva());
  1067.             $newLoungeSimple->setOpIva($item->getOpIva());
  1068.             $newLoungeSimple->setIdLounge($newLounge->getId());
  1069.             $newLoungeSimple->setLoungename($newLounge->getName());
  1070. //            $newLoungeSimple->setLoungeDescription($item->getLoungeDescription());
  1071.             $newLoungeSimple->setImportantDescription($loungeWebDetail->getImportantDescription());
  1072.             $newLoungeSimple->setImportantDescGeneralText($loungeWebDetail->getImportantDescGeneralText());
  1073.             $newLoungeSimple->setImportantDescSchedules($loungeWebDetail->getImportantDescSchedules());
  1074.             $newLoungeSimple->setImportantDescParking($loungeWebDetail->getImportantDescParking());
  1076.             if (!empty($reqDuplicateQuote['salaPrice'])){ $newLoungeSimple->setServicePrice($reqDuplicateQuote['salaPrice']); }  else { $newLoungeSimple->setServicePrice($item->getServicePrice());}
  1078.             try{
  1079.                 $em->persist($newLoungeSimple);
  1080.                 $em->flush();
  1081.                 $event = 'Se ha agregado la nueva cotización';
  1082.                 $successMessage = $this->translator->trans($event);
  1083.                 $this->addFlash('mensajereservation', $successMessage);
  1084.             } catch (\Exception $e){
  1085.                 $event = 'An error occurred: '.$e->getMessage();
  1086.                 $errorMessage = $this->translator->trans($event);
  1087.                 $this->addFlash('mensajereservationerror', $errorMessage);
  1088.             }
  1090.             // Rafa indica que se debe quitar esta asignación, mas adelante eliminaremos el codigo, despues de que prueben el sistema sin esta funcionalidad
  1091.             if (false) {
  1092.                 // Se debe agregar el servicio de limpieza por cada sala que se agregue
  1093.                 $resLoungeSimple = $newLoungeSimple;
  1094.                 $service = new ReservationService();
  1095.                 $service->setReservationId($reqDuplicateQuote['reservationId']);
  1096.                 $service->setSupplierId(0);
  1097.                 $service->setDateInAt($resLoungeSimple->getDateStart());
  1098.                 $service->setDateOutAt($resLoungeSimple->getDateEnd());
  1100.                 /* Obtengo usuario logueado */
  1101.                 $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1102.                 $user_id = $user_logueado->getId();
  1104.                 $service->setCreatedId($user_id);
  1105.                 $service->setUpdatedId($user_id);
  1106.                 $service->setCreatedAt(new \DateTime("now"));
  1107.                 $service->setUpdatedAt(new \DateTime("now"));
  1109.                 $service->setServiceCatId('21');
  1110.                 $service->setServiceCatName('Limpieza');
  1111.                 $service->setContcolor('green-300');
  1112.                 $service->setName('HORAS ( ' . $resLoungeSimple->getLoungeName() . ' )');
  1113.                 $service->setPrice('14');
  1114.                 $service->setCurrency('Euro');
  1115.                 $service->setUnits('8');
  1116.                 $service->setCommission('0');
  1117.                 $service->setIva('0');
  1118.                 $service->setPax('0');
  1119.                 $service->setOver('0');
  1120.                 $service->setIva('21');
  1121.                 $service->setOpIva('1');
  1122.                 $service->setOpCommission('1');
  1123.                 $service->setCommission('57.14');
  1124.                 $service->setViewInfo(0);
  1125.                 $service->setToinvoice(0);
  1126.                 $service->setServiceId(0);
  1128.                 $em->persist($service);
  1129.                 $em->flush();
  1130.             }
  1131.         }
  1133.         return $this->redirectToRoute('reservations_greenpatio_edit_simple',
  1134.             array(
  1135.                 'id' => $reqDuplicateQuote['reservationId'],
  1136.                 'token' => null,
  1137.                 '_fragment' => 'btn_quotes'
  1138.             ));
  1139.     }
  1142.     /**
  1143.      * @Route("/registerFormGpWeb/{yourEmail}/{yourReferral}/{yourEventDateDay}/{yourEventDateMonth}/{yourEventDateYear}/{yourName}/{yourPhone}/{yourAttendees}/{eventSpace}/{yourEventDetails}",
  1144.      *     name="registerformgpweb",
  1145.      *     defaults={"yourName"=null, "yourPhone"=null,"yourAttendees"=null,"eventSpace"=null,"yourEventDetails"=null,}
  1146.      * )
  1147.      * Crear una reserva con la información que llega desde la web
  1148.      */
  1149.     public function testGpWebAction( $yourEmail, $yourReferral, $yourEventDateDay, $yourEventDateMonth, $yourEventDateYear, $yourName, $yourPhone, $yourAttendees, $eventSpace, $yourEventDetails, EntityManagerInterface $em, Request $request) {
  1151.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1152.         $user_id = $user_logueado->getId();
  1153.         $hoy = new \DateTime("now", NULL);
  1154.         $yourEventDate = new DateTime($yourEventDateDay. '/'.$yourEventDateMonth.'/'.$yourEventDateYear);
  1155.         // Genera un token único utilizando la función uniqid() de PHP
  1156.         $token = uniqid();
  1158.         $reserva = new Reservation();
  1159.         $reserva->setTitle('Reserva ingresada en la web para el día: '. $yourEventDate->format('d/m/Y'));
  1160.         $reserva->setClient(null);
  1161.         $reserva->setCreatedAt($hoy);
  1162.         $reserva->setPriority(1);
  1163. //        $reserva->setDateStart($yourEventDate);
  1164.         $reserva->setDateStart(new \DateTime('2078-01-01'));
  1165. //        $reserva->setDateEnd($yourEventDate);
  1166.         $reserva->setDateEnd(new \DateTime('2000-01-01'));
  1167.         $reserva->setCreatedBy($user_id);
  1168.         $reserva->setSupplier(4765);        // Higo&Trigo
  1169.         $reserva->setStatus('Cotizado');
  1170.         $reserva->setUpdatedAt($hoy);
  1171.         $reserva->setUpdatedBy($user_id);
  1172.         $reserva->setDaysBlock(7);
  1173.         $reserva->setAdvancePayment(null);
  1174.         $reserva->setIdProposal(null);
  1175.         $reserva->setCateringName('HIGO & TRIGO, S.L.');
  1176.         $reserva->setBoolCatering(null);
  1177.         if (!empty($yourAttendees) and is_numeric($yourAttendees)){ $reserva->setPax($yourAttendees); } else { $reserva->setPax(null); }
  1178.         $reserva->setDeposit(null);
  1179.         $reserva->setAccessKey(null);
  1180.         if (!empty($yourEventDetails)){ $reserva->setDescription($yourEventDetails); } else { $reserva->setDescription(null); }
  1181.         $reserva->setClientContact(null);
  1182.         $reserva->setContactUnregistered($yourEmail);       // Desde la web es requerido
  1183.         $reserva->setDays(null);
  1184.         $reserva->setContract(null);
  1185.         if (!empty($yourName)){ $reserva->setNameContactUnregistered($yourName); } else { $reserva->setNameContactUnregistered(null); }
  1186.         if (!empty($yourPhone)){ $reserva->setPhoneContactUnregistered($yourPhone); } else { $reserva->setPhoneContactUnregistered(null); }
  1187.         $reserva->setToken($token);
  1188.         $reserva->setComAvGp(null);
  1189.         $reserva->setComHtGp(null);
  1190.         $reserva->setInfoFormWeb($yourEmail .' || '. $yourReferral .' || '. $yourEventDate->format('d/m/Y') .' || '. $yourName .' || '. $yourPhone .' || '. $yourAttendees .' || '. $eventSpace);
  1192.         try{
  1193.             $em->persist($reserva);
  1194.             $em->flush();
  1195.             $event = 'The Reservation has been updated.';
  1196.             $successMessage = $this->translator->trans($event);
  1197.             $this->addFlash('mensajereservation', $successMessage);
  1198.         } catch (\Exception $e){
  1199.             $event = 'An error occurred: '.$e->getMessage();
  1200.             $errorMessage = $this->translator->trans($event);
  1201.             $this->addFlash('mensajereservationerror', $errorMessage);
  1202.         }
  1204.         $id = $reserva->getId();
  1206.         // Sincronización con HT
  1207.         if (!empty($reserva)) {
  1208.             // Rafa indico que siempre se sincronice al abrir un expediente de GP
  1209.             if (in_array($reserva->getStatus(), [null, '', 'Confirmed', 'Invoiced', 'Iniciado', 'Cotizado', 'Bloqueo'])) {
  1210.                 if ($reserva->getCateringName() == 'HIGO & TRIGO, S.L.') {
  1211.                     // Si no se ha creado aun el expediente de HT debemos crearlo
  1212.                     $htFile = $em->getRepository(HtFile::class)->findByReservation($reserva);
  1213.                     if (empty($htFile)) { return $this->redirectToRoute('sinc_gp_ht', array('id' => $id,)); }
  1214.                 }
  1215.             }
  1216.         }
  1218.         return $this->redirectToRoute('reservations_greenpatio_edit_simple',
  1219.             array(
  1220.                 'id' => $id,
  1221.                 'token' => null,
  1222.                 '_fragment' => 'btn_quotes'
  1223.             ));
  1224.     }
  1226.     private function precioPorFecha($date, $loungeId){
  1228.         return array( 'price' => 0, );
  1230.         $em = $this->getDoctrine()->getManager();
  1231.         $price0 = null;
  1233.         // Buscamos por año
  1234.         $parameters = array( 'dateYear' => $date->format('Y'), 'loungeId' => $loungeId, 'priceIsActive' => true, );
  1235.         $dql = 'SELECT i
  1236.                 FROM GreenPatioBundle:ReservationLoungeProfile i
  1237.                 WHERE  ((i.year1 <= :dateYear and i.year2 >= :dateYear) ) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive';
  1239.         $query = $em->createQuery($dql)->setParameters($parameters);
  1240.         $price1 = $query->getResult();
  1242.         // Buscamos por año y mes
  1243.         $parameters = array( 'dateYear' => $date->format('Y'), 'month' => true, 'loungeId' => $loungeId, 'priceIsActive' => true, );
  1245.         switch ($date->format('m')) {
  1246.             case '01': //Enero
  1247.                 $dql = 'SELECT i
  1248.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1249.                     WHERE (
  1250.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1251.                           AND (i.month1 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1252.                       ';
  1253.                 break;
  1255.             case '02': //Febrero
  1256.                 $dql = 'SELECT i
  1257.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1258.                     WHERE (
  1259.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1260.                           AND (i.month2 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1261.                       ';
  1262.                 break;
  1264.             case '03': //Marzo
  1265.                 $dql = 'SELECT i
  1266.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1267.                     WHERE (
  1268.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1269.                           AND (i.month3 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1270.                       ';
  1271.                 break;
  1273.             case '04': //Abril
  1274.                 $dql = 'SELECT i
  1275.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1276.                     WHERE (
  1277.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1278.                           AND (i.month4 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1279.                       ';
  1280.                 break;
  1282.             case '05': //Mayo
  1283.                 $dql = 'SELECT i
  1284.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1285.                     WHERE (
  1286.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1287.                           AND (i.month5 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1288.                       ';
  1289.                 break;
  1291.             case '06': //Junio
  1292.                 $dql = 'SELECT i
  1293.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1294.                     WHERE (
  1295.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1296.                           AND (i.month6 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1297.                       ';
  1298.                 break;
  1300.             case '07': //Julio
  1301.                 $dql = 'SELECT i
  1302.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1303.                     WHERE (
  1304.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1305.                           AND (i.month7 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1306.                       ';
  1307.                 break;
  1309.             case '08': //Agosto
  1310.                 $dql = 'SELECT i
  1311.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1312.                     WHERE (
  1313.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1314.                           AND (i.month8 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1315.                       ';
  1316.                 break;
  1318.             case '09': //Septiembre
  1319.                 $dql = 'SELECT i
  1320.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1321.                     WHERE (
  1322.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1323.                           AND (i.month9 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1324.                       ';
  1325.                 break;
  1327.             case '10': //Octubre
  1328.                 $dql = 'SELECT i
  1329.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1330.                     WHERE (
  1331.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1332.                           AND (i.month10 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1333.                       ';
  1334.                 break;
  1336.             case '11': //Noviembre
  1337.                 $dql = 'SELECT i
  1338.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1339.                     WHERE (
  1340.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1341.                           AND (i.month11 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1342.                       ';
  1343.                 break;
  1345.             case '12': //Diciembre
  1346.                 $dql = 'SELECT i
  1347.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1348.                     WHERE (
  1349.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1350.                           AND (i.month12 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1351.                       ';
  1352.                 break;
  1354.             default:
  1355.                 break;
  1356.         }
  1358.         $query = $em->createQuery($dql)->setParameters($parameters);
  1359.         $price2 = $query->getResult();
  1361.         // Buscamos por año, mes y dia de la semana
  1362.         $parameters = array( 'dateYear' => $date->format('Y'), 'month' => true, 'day' => true, 'loungeId' => $loungeId, 'priceIsActive' => true, );
  1364.         switch ($date->format('m')) {
  1365.             case '01': //Enero
  1366.                 switch ($date->format('l')) {
  1367.                     case 'Monday': //Lunes
  1368.                         $dql = 'SELECT i
  1369.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1370.                                     WHERE (
  1371.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1372.                                           AND (i.month1 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1373.                                       ';
  1374.                         break;
  1376.                     case 'Tuesday': //Martes
  1377.                         $dql = 'SELECT i
  1378.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1379.                                     WHERE (
  1380.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1381.                                           AND (i.month1 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1382.                                       ';
  1383.                         break;
  1385.                     case 'Wednesday': //Miercoles
  1386.                         $dql = 'SELECT i
  1387.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1388.                                     WHERE (
  1389.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1390.                                           AND (i.month1 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1391.                                       ';
  1392.                         break;
  1394.                     case 'Thursday': //Jueves
  1395.                         $dql = 'SELECT i
  1396.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1397.                                     WHERE (
  1398.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1399.                                           AND (i.month1 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1400.                                       ';
  1401.                         break;
  1403.                     case 'Friday': //Viernes
  1404.                         $dql = 'SELECT i
  1405.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1406.                                     WHERE (
  1407.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1408.                                           AND (i.month1 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1409.                                       ';
  1410.                         break;
  1412.                     case 'Saturday': //Sabado
  1413.                         $dql = 'SELECT i
  1414.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1415.                                     WHERE (
  1416.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1417.                                           AND (i.month1 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1418.                                       ';
  1419.                         break;
  1421.                     case 'Sunday': //Domingo
  1422.                         $dql = 'SELECT i
  1423.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1424.                                     WHERE (
  1425.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1426.                                           AND (i.month1 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1427.                                       ';
  1428.                         break;
  1429.                     default: break;
  1430.                 }
  1431.                 break;
  1433.             case '02': //Febrero
  1435.                 switch ($date->format('l')) {
  1436.                     case 'Monday': //Lunes
  1437.                         $dql = 'SELECT i
  1438.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1439.                                     WHERE (
  1440.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1441.                                           AND (i.month2 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1442.                                       ';
  1443.                         break;
  1445.                     case 'Tuesday': //Martes
  1446.                         $dql = 'SELECT i
  1447.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1448.                                     WHERE (
  1449.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1450.                                           AND (i.month2 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1451.                                       ';
  1452.                         break;
  1454.                     case 'Wednesday': //Miercoles
  1455.                         $dql = 'SELECT i
  1456.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1457.                                     WHERE (
  1458.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1459.                                           AND (i.month2 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1460.                                       ';
  1461.                         break;
  1463.                     case 'Thursday': //Jueves
  1464.                         $dql = 'SELECT i
  1465.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1466.                                     WHERE (
  1467.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1468.                                           AND (i.month2 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1469.                                       ';
  1470.                         break;
  1472.                     case 'Friday': //Viernes
  1473.                         $dql = 'SELECT i
  1474.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1475.                                     WHERE (
  1476.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1477.                                           AND (i.month2 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1478.                                       ';
  1479.                         break;
  1481.                     case 'Saturday': //Sabado
  1482.                         $dql = 'SELECT i
  1483.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1484.                                     WHERE (
  1485.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1486.                                           AND (i.month2 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1487.                                       ';
  1488.                         break;
  1490.                     case 'Sunday': //Domingo
  1491.                         $dql = 'SELECT i
  1492.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1493.                                     WHERE (
  1494.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1495.                                           AND (i.month2 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1496.                                       ';
  1497.                         break;
  1499.                     default: break;
  1500.                 }
  1502.                 break;
  1504.             case '03': //Marzo
  1506.                 switch ($date->format('l')) {
  1507.                     case 'Monday': //Lunes
  1508.                         $dql = 'SELECT i
  1509.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1510.                                     WHERE (
  1511.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1512.                                           AND (i.month3 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1513.                                       ';
  1514.                         break;
  1516.                     case 'Tuesday': //Martes
  1517.                         $dql = 'SELECT i
  1518.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1519.                                     WHERE (
  1520.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1521.                                           AND (i.month3 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1522.                                       ';
  1523.                         break;
  1525.                     case 'Wednesday': //Miercoles
  1526.                         $dql = 'SELECT i
  1527.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1528.                                     WHERE (
  1529.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1530.                                           AND (i.month3 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1531.                                       ';
  1532.                         break;
  1534.                     case 'Thursday': //Jueves
  1535.                         $dql = 'SELECT i
  1536.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1537.                                     WHERE (
  1538.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1539.                                           AND (i.month3 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1540.                                       ';
  1541.                         break;
  1543.                     case 'Friday': //Viernes
  1544.                         $dql = 'SELECT i
  1545.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1546.                                     WHERE (
  1547.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1548.                                           AND (i.month3 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1549.                                       ';
  1550.                         break;
  1552.                     case 'Saturday': //Sabado
  1553.                         $dql = 'SELECT i
  1554.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1555.                                     WHERE (
  1556.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1557.                                           AND (i.month3 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1558.                                       ';
  1559.                         break;
  1561.                     case 'Sunday': //Domingo
  1562.                         $dql = 'SELECT i
  1563.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1564.                                     WHERE (
  1565.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1566.                                           AND (i.month3 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1567.                                       ';
  1568.                         break;
  1570.                     default: break;
  1571.                 }
  1573.                 break;
  1575.             case '04': //Abril
  1577.                 switch ($date->format('l')) {
  1578.                     case 'Monday': //Lunes
  1579.                         $dql = 'SELECT i
  1580.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1581.                                     WHERE (
  1582.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1583.                                           AND (i.month4 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1584.                                       ';
  1585.                         break;
  1587.                     case 'Tuesday': //Martes
  1588.                         $dql = 'SELECT i
  1589.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1590.                                     WHERE (
  1591.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1592.                                           AND (i.month4 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1593.                                       ';
  1594.                         break;
  1596.                     case 'Wednesday': //Miercoles
  1597.                         $dql = 'SELECT i
  1598.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1599.                                     WHERE (
  1600.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1601.                                           AND (i.month4 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1602.                                       ';
  1603.                         break;
  1605.                     case 'Thursday': //Jueves
  1606.                         $dql = 'SELECT i
  1607.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1608.                                     WHERE (
  1609.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1610.                                           AND (i.month4 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1611.                                       ';
  1612.                         break;
  1614.                     case 'Friday': //Viernes
  1615.                         $dql = 'SELECT i
  1616.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1617.                                     WHERE (
  1618.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1619.                                           AND (i.month4 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1620.                                       ';
  1621.                         break;
  1623.                     case 'Saturday': //Sabado
  1624.                         $dql = 'SELECT i
  1625.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1626.                                     WHERE (
  1627.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1628.                                           AND (i.month4 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1629.                                       ';
  1630.                         break;
  1632.                     case 'Sunday': //Domingo
  1633.                         $dql = 'SELECT i
  1634.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1635.                                     WHERE (
  1636.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1637.                                           AND (i.month4 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1638.                                       ';
  1639.                         break;
  1641.                     default: break;
  1642.                 }
  1644.                 break;
  1646.             case '05': //Mayo
  1648.                 switch ($date->format('l')) {
  1649.                     case 'Monday': //Lunes
  1650.                         $dql = 'SELECT i
  1651.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1652.                                     WHERE (
  1653.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1654.                                           AND (i.month5 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1655.                                       ';
  1656.                         break;
  1658.                     case 'Tuesday': //Martes
  1659.                         $dql = 'SELECT i
  1660.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1661.                                     WHERE (
  1662.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1663.                                           AND (i.month5 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1664.                                       ';
  1665.                         break;
  1667.                     case 'Wednesday': //Miercoles
  1668.                         $dql = 'SELECT i
  1669.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1670.                                     WHERE (
  1671.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1672.                                           AND (i.month5 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1673.                                       ';
  1674.                         break;
  1676.                     case 'Thursday': //Jueves
  1677.                         $dql = 'SELECT i
  1678.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1679.                                     WHERE (
  1680.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1681.                                           AND (i.month5 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1682.                                       ';
  1683.                         break;
  1685.                     case 'Friday': //Viernes
  1686.                         $dql = 'SELECT i
  1687.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1688.                                     WHERE (
  1689.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1690.                                           AND (i.month5 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1691.                                       ';
  1692.                         break;
  1694.                     case 'Saturday': //Sabado
  1695.                         $dql = 'SELECT i
  1696.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1697.                                     WHERE (
  1698.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1699.                                           AND (i.month5 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1700.                                       ';
  1701.                         break;
  1703.                     case 'Sunday': //Domingo
  1704.                         $dql = 'SELECT i
  1705.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1706.                                     WHERE (
  1707.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1708.                                           AND (i.month5 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1709.                                       ';
  1710.                         break;
  1712.                     default: break;
  1713.                 }
  1715.                 break;
  1717.             case '06': //Junio
  1719.                 switch ($date->format('l')) {
  1720.                     case 'Monday': //Lunes
  1721.                         $dql = 'SELECT i
  1722.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1723.                                     WHERE (
  1724.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1725.                                           AND (i.month6 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1726.                                       ';
  1727.                         break;
  1729.                     case 'Tuesday': //Martes
  1730.                         $dql = 'SELECT i
  1731.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1732.                                     WHERE (
  1733.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1734.                                           AND (i.month6 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1735.                                       ';
  1736.                         break;
  1738.                     case 'Wednesday': //Miercoles
  1739.                         $dql = 'SELECT i
  1740.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1741.                                     WHERE (
  1742.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1743.                                           AND (i.month6 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1744.                                       ';
  1745.                         break;
  1747.                     case 'Thursday': //Jueves
  1748.                         $dql = 'SELECT i
  1749.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1750.                                     WHERE (
  1751.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1752.                                           AND (i.month6 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1753.                                       ';
  1754.                         break;
  1756.                     case 'Friday': //Viernes
  1757.                         $dql = 'SELECT i
  1758.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1759.                                     WHERE (
  1760.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1761.                                           AND (i.month6 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1762.                                       ';
  1763.                         break;
  1765.                     case 'Saturday': //Sabado
  1766.                         $dql = 'SELECT i
  1767.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1768.                                     WHERE (
  1769.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1770.                                           AND (i.month6 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1771.                                       ';
  1772.                         break;
  1774.                     case 'Sunday': //Domingo
  1775.                         $dql = 'SELECT i
  1776.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1777.                                     WHERE (
  1778.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1779.                                           AND (i.month6 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1780.                                       ';
  1781.                         break;
  1783.                     default: break;
  1784.                 }
  1786.                 break;
  1788.             case '07': //Julio
  1790.                 switch ($date->format('l')) {
  1791.                     case 'Monday': //Lunes
  1792.                         $dql = 'SELECT i
  1793.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1794.                                     WHERE (
  1795.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1796.                                           AND (i.month7 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1797.                                       ';
  1798.                         break;
  1800.                     case 'Tuesday': //Martes
  1801.                         $dql = 'SELECT i
  1802.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1803.                                     WHERE (
  1804.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1805.                                           AND (i.month7 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1806.                                       ';
  1807.                         break;
  1809.                     case 'Wednesday': //Miercoles
  1810.                         $dql = 'SELECT i
  1811.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1812.                                     WHERE (
  1813.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1814.                                           AND (i.month7 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1815.                                       ';
  1816.                         break;
  1818.                     case 'Thursday': //Jueves
  1819.                         $dql = 'SELECT i
  1820.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1821.                                     WHERE (
  1822.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1823.                                           AND (i.month7 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1824.                                       ';
  1825.                         break;
  1827.                     case 'Friday': //Viernes
  1828.                         $dql = 'SELECT i
  1829.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1830.                                     WHERE (
  1831.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1832.                                           AND (i.month7 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1833.                                       ';
  1834.                         break;
  1836.                     case 'Saturday': //Sabado
  1837.                         $dql = 'SELECT i
  1838.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1839.                                     WHERE (
  1840.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1841.                                           AND (i.month7 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1842.                                       ';
  1843.                         break;
  1845.                     case 'Sunday': //Domingo
  1846.                         $dql = 'SELECT i
  1847.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1848.                                     WHERE (
  1849.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1850.                                           AND (i.month7 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1851.                                       ';
  1852.                         break;
  1854.                     default: break;
  1855.                 }
  1857.                 break;
  1859.             case '08': //Agosto
  1861.                 switch ($date->format('l')) {
  1862.                     case 'Monday': //Lunes
  1863.                         $dql = 'SELECT i
  1864.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1865.                                     WHERE (
  1866.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1867.                                           AND (i.month8 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1868.                                       ';
  1869.                         break;
  1871.                     case 'Tuesday': //Martes
  1872.                         $dql = 'SELECT i
  1873.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1874.                                     WHERE (
  1875.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1876.                                           AND (i.month8 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1877.                                       ';
  1878.                         break;
  1880.                     case 'Wednesday': //Miercoles
  1881.                         $dql = 'SELECT i
  1882.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1883.                                     WHERE (
  1884.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1885.                                           AND (i.month8 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1886.                                       ';
  1887.                         break;
  1889.                     case 'Thursday': //Jueves
  1890.                         $dql = 'SELECT i
  1891.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1892.                                     WHERE (
  1893.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1894.                                           AND (i.month8 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1895.                                       ';
  1896.                         break;
  1898.                     case 'Friday': //Viernes
  1899.                         $dql = 'SELECT i
  1900.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1901.                                     WHERE (
  1902.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1903.                                           AND (i.month8 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1904.                                       ';
  1905.                         break;
  1907.                     case 'Saturday': //Sabado
  1908.                         $dql = 'SELECT i
  1909.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1910.                                     WHERE (
  1911.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1912.                                           AND (i.month8 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1913.                                       ';
  1914.                         break;
  1916.                     case 'Sunday': //Domingo
  1917.                         $dql = 'SELECT i
  1918.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1919.                                     WHERE (
  1920.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1921.                                           AND (i.month8 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1922.                                       ';
  1923.                         break;
  1925.                     default: break;
  1926.                 }
  1928.                 break;
  1930.             case '09': //Septiembre
  1932.                 switch ($date->format('l')) {
  1933.                     case 'Monday': //Lunes
  1934.                         $dql = 'SELECT i
  1935.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1936.                                     WHERE (
  1937.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1938.                                           AND (i.month9 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1939.                                       ';
  1940.                         break;
  1942.                     case 'Tuesday': //Martes
  1943.                         $dql = 'SELECT i
  1944.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1945.                                     WHERE (
  1946.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1947.                                           AND (i.month9 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1948.                                       ';
  1949.                         break;
  1951.                     case 'Wednesday': //Miercoles
  1952.                         $dql = 'SELECT i
  1953.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1954.                                     WHERE (
  1955.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1956.                                           AND (i.month9 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1957.                                       ';
  1958.                         break;
  1960.                     case 'Thursday': //Jueves
  1961.                         $dql = 'SELECT i
  1962.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1963.                                     WHERE (
  1964.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1965.                                           AND (i.month9 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1966.                                       ';
  1967.                         break;
  1969.                     case 'Friday': //Viernes
  1970.                         $dql = 'SELECT i
  1971.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1972.                                     WHERE (
  1973.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1974.                                           AND (i.month9 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1975.                                       ';
  1976.                         break;
  1978.                     case 'Saturday': //Sabado
  1979.                         $dql = 'SELECT i
  1980.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1981.                                     WHERE (
  1982.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1983.                                           AND (i.month9 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1984.                                       ';
  1985.                         break;
  1987.                     case 'Sunday': //Domingo
  1988.                         $dql = 'SELECT i
  1989.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1990.                                     WHERE (
  1991.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1992.                                           AND (i.month9 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1993.                                       ';
  1994.                         break;
  1996.                     default: break;
  1997.                 }
  1999.                 break;
  2001.             case '10': //Octubre
  2003.                 switch ($date->format('l')) {
  2004.                     case 'Monday': //Lunes
  2005.                         $dql = 'SELECT i
  2006.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2007.                                     WHERE (
  2008.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2009.                                           AND (i.month10 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2010.                                       ';
  2011.                         break;
  2013.                     case 'Tuesday': //Martes
  2014.                         $dql = 'SELECT i
  2015.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2016.                                     WHERE (
  2017.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2018.                                           AND (i.month10 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2019.                                       ';
  2020.                         break;
  2022.                     case 'Wednesday': //Miercoles
  2023.                         $dql = 'SELECT i
  2024.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2025.                                     WHERE (
  2026.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2027.                                           AND (i.month10 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2028.                                       ';
  2029.                         break;
  2031.                     case 'Thursday': //Jueves
  2032.                         $dql = 'SELECT i
  2033.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2034.                                     WHERE (
  2035.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2036.                                           AND (i.month10 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2037.                                       ';
  2038.                         break;
  2040.                     case 'Friday': //Viernes
  2041.                         $dql = 'SELECT i
  2042.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2043.                                     WHERE (
  2044.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2045.                                           AND (i.month10 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2046.                                       ';
  2047.                         break;
  2049.                     case 'Saturday': //Sabado
  2050.                         $dql = 'SELECT i
  2051.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2052.                                     WHERE (
  2053.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2054.                                           AND (i.month10 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2055.                                       ';
  2056.                         break;
  2058.                     case 'Sunday': //Domingo
  2059.                         $dql = 'SELECT i
  2060.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2061.                                     WHERE (
  2062.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2063.                                           AND (i.month10 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2064.                                       ';
  2065.                         break;
  2067.                     default: break;
  2068.                 }
  2070.                 break;
  2072.             case '11': //Noviembre
  2074.                 switch ($date->format('l')) {
  2075.                     case 'Monday': //Lunes
  2076.                         $dql = 'SELECT i
  2077.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2078.                                     WHERE (
  2079.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2080.                                           AND (i.month11 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2081.                                       ';
  2082.                         break;
  2084.                     case 'Tuesday': //Martes
  2085.                         $dql = 'SELECT i
  2086.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2087.                                     WHERE (
  2088.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2089.                                           AND (i.month11 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2090.                                       ';
  2091.                         break;
  2093.                     case 'Wednesday': //Miercoles
  2094.                         $dql = 'SELECT i
  2095.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2096.                                     WHERE (
  2097.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2098.                                           AND (i.month11 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2099.                                       ';
  2100.                         break;
  2102.                     case 'Thursday': //Jueves
  2103.                         $dql = 'SELECT i
  2104.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2105.                                     WHERE (
  2106.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2107.                                           AND (i.month11 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2108.                                       ';
  2109.                         break;
  2111.                     case 'Friday': //Viernes
  2112.                         $dql = 'SELECT i
  2113.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2114.                                     WHERE (
  2115.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2116.                                           AND (i.month11 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2117.                                       ';
  2118.                         break;
  2120.                     case 'Saturday': //Sabado
  2121.                         $dql = 'SELECT i
  2122.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2123.                                     WHERE (
  2124.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2125.                                           AND (i.month11 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2126.                                       ';
  2127.                         break;
  2129.                     case 'Sunday': //Domingo
  2130.                         $dql = 'SELECT i
  2131.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2132.                                     WHERE (
  2133.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2134.                                           AND (i.month11 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2135.                                       ';
  2136.                         break;
  2138.                     default: break;
  2139.                 }
  2141.                 break;
  2143.             case '12': //Diciembre
  2145.                 switch ($date->format('l')) {
  2146.                     case 'Monday': //Lunes
  2147.                         $dql = 'SELECT i
  2148.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2149.                                     WHERE (
  2150.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2151.                                           AND (i.month12 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2152.                                       ';
  2153.                         break;
  2155.                     case 'Tuesday': //Martes
  2156.                         $dql = 'SELECT i
  2157.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2158.                                     WHERE (
  2159.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2160.                                           AND (i.month12 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2161.                                       ';
  2162.                         break;
  2164.                     case 'Wednesday': //Miercoles
  2165.                         $dql = 'SELECT i
  2166.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2167.                                     WHERE (
  2168.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2169.                                           AND (i.month12 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2170.                                       ';
  2171.                         break;
  2173.                     case 'Thursday': //Jueves
  2174.                         $dql = 'SELECT i
  2175.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2176.                                     WHERE (
  2177.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2178.                                           AND (i.month12 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2179.                                       ';
  2180.                         break;
  2182.                     case 'Friday': //Viernes
  2183.                         $dql = 'SELECT i
  2184.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2185.                                     WHERE (
  2186.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2187.                                           AND (i.month12 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2188.                                       ';
  2189.                         break;
  2191.                     case 'Saturday': //Sabado
  2192.                         $dql = 'SELECT i
  2193.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2194.                                     WHERE (
  2195.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2196.                                           AND (i.month12 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2197.                                       ';
  2198.                         break;
  2200.                     case 'Sunday': //Domingo
  2201.                         $dql = 'SELECT i
  2202.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2203.                                     WHERE (
  2204.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2205.                                           AND (i.month12 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2206.                                       ';
  2207.                         break;
  2209.                     default: break;
  2210.                 }
  2212.                 break;
  2214.             default:
  2215.                 break;
  2216.         }
  2218.         $query = $em->createQuery($dql)->setParameters($parameters);
  2219.         $price3 = $query->getResult();
  2221.         foreach ($price3 as $item){
  2222.             if (empty($price0)){
  2223.                 $price0 = $item;
  2224.             } else {
  2225.                 //Si los precios coinciden en fechas se tomara el que se haya cargado mas reciente en el sistema
  2226.                 if ($item->getCreatedAt() > $price0->getCreatedAt()){ $price0 = $item; }
  2227.             }
  2228.         }
  2229.         if(empty($price0)){ $price = 0; } else { $price = $price0->getPrice(); }
  2231.         return array( 'price' => $price, );
  2232.     }
  2235.     private function precioTarifario($dateStart, $loungeId, $servicePrice){
  2236.         /*
  2237.          * Se busca el precio a Sugerir
  2238.          * $dateStart Fecha
  2239.          * $loungeId Id de  la sala
  2240.          * $servicePrice Preciointroducido por elusuario
  2241.          * */
  2243.         $em = $this->getDoctrine()->getManager();
  2245.         $dateToFind = clone $dateStart;
  2246.         $dateToFind->setTime(0, 0, 0);
  2247.         $parameters = array(
  2248.             'loungeId' => $loungeId,
  2249.             'typePrice' => 'DIARIA',
  2250.             'dateToFind' => $dateToFind,
  2251.         );
  2252.         $dql = 'SELECT p
  2253.                 FROM GreenPatioBundle:ReservationLoungeProfile p
  2254.                 WHERE p.typePrice = :typePrice AND p.dateStart = :dateToFind AND p.loungeId = :loungeId
  2255.                 ORDER BY p.levelPrice DESC';
  2257.         $query = $em->createQuery($dql)->setParameters($parameters);
  2258.         $loungesPeriodsDaily = $query->getResult();
  2260.         $priceTarifa = empty($loungesPeriodsDaily) ? 0 : $loungesPeriodsDaily[0]->getPrice();
  2262.         $price = ($servicePrice == 0) ? $priceTarifa : $servicePrice;
  2264.         return $price;
  2265.     }
  2268.     private function recalculoFechas($id){
  2269.         /*
  2270.          * Se busca recalculan las fechas de incio y fin de la reserva
  2271.          * $id es el identificador de la reserva
  2272.          * */
  2274.         $em = $this->getDoctrine()->getManager();
  2276.         $reserva = $em->getRepository(Reservation::class)->findOneById($id);
  2277.         $allLoungeSimples = $em->getRepository(ReservationLoungeSimple::class)->findByIdReservation($id);
  2279.         $dateStart = new DateTime('2078-01-01');
  2280.         $dateEnd = new DateTime('2000-01-01');
  2282.         if (!empty($allLoungeSimples)){
  2283.             foreach ($allLoungeSimples as $loungeSimple){
  2284.                 $dateStart = ($loungeSimple->getDateStart() < $dateStart) ? $loungeSimple->getDateStart() : $dateStart;
  2285.                 $dateEnd = ($loungeSimple->getDateEnd() > $dateEnd) ? $loungeSimple->getDateStart() : $dateEnd;
  2286.             }
  2287.         }
  2289.         $reserva->setDateStart($dateStart);
  2290.         $reserva->setDateEnd($dateEnd);
  2292.         try{
  2293.             $em->persist($reserva);
  2294.             $em->flush();
  2295.             $event = 'The Reservation has been updated.';
  2296.             $successMessage = $this->translator->trans($event);
  2297.             $this->addFlash('mensajereservation', $successMessage);
  2298.         } catch (\Exception $e){
  2299.             $event = 'An error occurred: '.$e->getMessage();
  2300.             $errorMessage = $this->translator->trans($event);
  2301.             $this->addFlash('mensajereservationerror', $errorMessage);
  2302.         }
  2304.         return true;
  2305.     }
  2306. }