src/MDS/VenuesBundle/Controller/ReservationsQuoteController.php line 86

Open in your IDE?
  1. <?php
  3. namespace App\MDS\VenuesBundle\Controller;
  5. use App\Entity\HtFile;
  6. use App\Entity\ReservationLoungeWebDescription;
  7. use App\Entity\SageArticle;
  8. use App\Entity\SageVatRates;
  9. use App\Entity\WidgetNotes;
  10. use App\Form\WidgetNotesType;
  11. use App\MDS\AvexpressBundle\Entity\AveFiles;
  12. use App\MDS\VenuesBundle\Entity\Reservation;
  13. use App\MDS\VenuesBundle\Entity\ReservationInvoiceItems;
  14. use App\MDS\VenuesBundle\Entity\ReservationLoungeSimple;
  15. use App\MDS\VenuesBundle\Entity\ReservationLoungeSimpleServiceLog;
  16. use App\MDS\VenuesBundle\Entity\ReservationService;
  17. use App\MDS\VenuesBundle\Entity\ReservationGpPrice;
  18. use App\MDS\VenuesBundle\Entity\ReservationLounge;
  19. use App\MDS\VenuesBundle\Entity\ReservationLoungeDetails;
  20. use App\MDS\VenuesBundle\Entity\ReservationLoungeProfile;
  21. use App\MDS\VenuesBundle\Entity\ReservationPeriod;
  22. use App\MDS\VenuesBundle\Form\ReservationGpPriceType;
  23. use App\MDS\VenuesBundle\Form\ReservationLoungeDetailsType;
  24. use App\MDS\VenuesBundle\Form\ReservationLoungeProfileType;
  25. use App\MDS\VenuesBundle\Form\ReservationPeriodType;
  26. use App\MDS\VenuesBundle\Form\ReservationType;
  27. use Doctrine\ORM\EntityManagerInterface;
  28. use Symfony\Component\Routing\Annotation\Route;
  29. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  30. use Symfony\Component\HttpFoundation\Request;
  31. use DateTime;
  32. use DatePeriod;
  33. use DateInterval;
  34. use Google_Client;
  35. use Google_Service_Calendar;
  36. use Symfony\Component\HttpFoundation\JsonResponse;
  37. use Symfony\Contracts\Translation\TranslatorInterface;
  38. use App\Service\AgendaService;
  39. use App\Service\VenueService;
  40. use Symfony\Component\HttpFoundation\Session\SessionInterface;
  42. class ReservationsQuoteController extends AbstractController
  43. {
  44.     private Google_Client $googleCalendar;
  45.     private TranslatorInterface $translator;
  46.     private AgendaService $agendaService;
  47.     private SessionInterface $session;
  48.     private VenueService $venueService;
  49.     private \App\Service\ReservationService $reservationService;
  50.     private \App\Service\DocContractService $docContractService;
  52.     public function __construct(
  53.         TranslatorInterface $translator,
  54.         AgendaService $agendaService,
  55.         VenueService $venueService,
  56.         SessionInterface $session,
  57.         \App\Service\ReservationService $reservationService,
  58.         \App\Service\DocContractService $docContractService
  59.     ) {
  60.         $redirect_uri = 'https://' . $_SERVER['HTTP_HOST'] . '/calendar/token';
  61.         $googleCalendar = new Google_Client();
  62.         $googleCalendar->setApplicationName('Google Calendar API PHP Quickstart');
  63.         //campos a extraer de la base de datos User
  64.         $googleCalendar->setClientId('2790497987-57qc3vu4pr7vb0s8phpub2me58pe34lb.apps.googleusercontent.com');
  65.         $googleCalendar->setClientSecret('nj2C7unaTO68DRhyORsyipSj');
  66.         //fin campos user
  67. //        $api_key = "AIzaSyBR84cS1IU2BPvk5V3VnbqdkJESlv440Ac";
  68. //        $client->setDeveloperKey($api_key);
  69.         $googleCalendar->setRedirectUri($redirect_uri);
  70.         $googleCalendar->addScope(Google_Service_Calendar::CALENDAR);
  71.         $guzzleClient = new \GuzzleHttp\Client(array('curl' => array(CURLOPT_SSL_VERIFYPEER => false)));
  72.         $googleCalendar->setHttpClient($guzzleClient);
  73.         $this->googleCalendar = $googleCalendar;
  74.         $this->translator = $translator;
  75.         $this->agendaService = $agendaService;
  76.         $this->venueService = $venueService;
  77.         $this->session = $session;
  78.         $this->reservationService = $reservationService;
  79.         $this->docContractService = $docContractService;
  80.     }
  82.     /**
  83.      * @Route("/createsimplelounge/{id}", name="reservations_venues_create_simple_lounge")
  84.      * Crea un Reservation Lounge Simple en la cotizacion
  85.      */
  86.     public function createSimpleLoungeAction($id, EntityManagerInterface $em, Request $request)
  87.     {
  88.         $simpleLounge = $request->request->all()['reservation_sala'] ?? [];
  90.         // Sala precargada
  91.         $loungeProfile = $em->getRepository(ReservationLoungeDetails::class)
  92.             ->findOneById($simpleLounge['salaPrecargadas'] ?? null);
  94.         if (!$loungeProfile) {
  95.             $this->addFlash('mensajereservationerror', 'La sala seleccionada no existe.');
  96.             return $this->redirectToRoute('reservations_venues_edit', ['id' => $id]);
  97.         }
  99.         $loungeId = $loungeProfile->getId();
  100.         $loungeDetails = $em->getRepository(ReservationLoungeDetails::class)->findOneById($loungeId);
  102.         // Nombre de sala, necesario para Sage
  103.         $loungeName = '';
  104.         if ($loungeDetails && method_exists($loungeDetails, 'getName')) {
  105.             $loungeName = (string) $loungeDetails->getName();
  106.         } elseif (!empty($simpleLounge['loungeName'])) {
  107.             $loungeName = (string) $simpleLounge['loungeName'];
  108.         }
  109.         if ($loungeName === '') {
  110.             $this->addFlash('mensajereservationerror', 'No se pudo determinar el nombre de la sala.');
  111.             return $this->redirectToRoute('reservations_venues_edit', ['id' => $id]);
  112.         }
  114.         // ¿Existe ya esta sala en la misma reserva y rank?
  115.         $previusLoungeSimple = $em->getRepository(ReservationLoungeSimple::class)->findOneBy([
  116.             'idLounge' => $loungeId,
  117.             'idReservation' => $id,
  118.             'rankQuote' => $simpleLounge['idQuote'] ?? null
  119.         ]);
  121.         // Heredar idioma si existe alguna sala previa en la reserva
  122.         $anyLoungeSimple = $em->getRepository(ReservationLoungeSimple::class)->findOneBy([
  123.             'idLounge' => $loungeId,
  124.             'idReservation' => $id
  125.         ]);
  126.         $idioma = $anyLoungeSimple ? (int) $anyLoungeSimple->getLanguage() : 1;
  128.         // Descripciones web por sala/idioma con fallbacks
  129.         $loungeWebDescriptionRepo = $em->getRepository(ReservationLoungeWebDescription::class);
  130.         $loungeWebDescription = $loungeWebDescriptionRepo->findOneBy([
  131.             'lounge' => $loungeProfile,
  132.             'language' => $idioma
  133.         ]) ?? ($idioma !== 1 ? $loungeWebDescriptionRepo->findOneBy([
  134.                 'lounge' => $loungeProfile,
  135.                 'language' => 1
  136.             ]) : null) ?? $loungeWebDescriptionRepo->findOneBy(['lounge' => $loungeProfile]);
  138.         // Summary recibido del formulario (opcional)
  139.         $loungeSummaryDescription = is_array($simpleLounge) && array_key_exists('importantDescription', $simpleLounge)
  140.             ? (string) $simpleLounge['importantDescription']
  141.             : null;
  143.         if (empty($previusLoungeSimple)) {
  144.             // Sin anterior, tiramos de WebDescription si existe
  145.             $loungeImportantDescGeneralText = $loungeWebDescription ? $loungeWebDescription->getImportantDescGeneralText() : '';
  146.             $loungeImportantDescSchedules = $loungeWebDescription ? $loungeWebDescription->getImportantDescSchedules() : '';
  147.             $loungeImportantDescParking = $loungeWebDescription ? $loungeWebDescription->getImportantDescParking() : '';
  148.             if (empty($loungeSummaryDescription)) {
  149.                 $loungeSummaryDescription = $loungeWebDescription ? $loungeWebDescription->getImportantDescription() : '';
  150.             }
  151.         } else {
  152.             // Heredamos de la simple existente
  153.             $loungeSummaryDescription = $previusLoungeSimple->getImportantDescription();
  154.             $loungeImportantDescGeneralText = $previusLoungeSimple->getImportantDescGeneralText();
  155.             $loungeImportantDescSchedules = $previusLoungeSimple->getImportantDescSchedules();
  156.             $loungeImportantDescParking = $previusLoungeSimple->getImportantDescParking();
  157.         }
  159.         // Reserva para calcular sucoe e IVA
  160.         $reservation = $em->getRepository(Reservation::class)->findOneById($id);
  161.         if (!$reservation) {
  162.             $this->addFlash('mensajereservationerror', 'No se encontró la reserva.');
  163.             return $this->redirectToRoute('reservations_venues_edit', ['id' => $id]);
  164.         }
  166.         $sucoe = (bool) $reservation->isSucoe();
  167.         $sageVatRate = $em->getRepository(SageVatRates::class)->findOneBy([
  168.             'sageCode' => $sucoe ? '00' : '03'
  169.         ]);
  171.         // Artículo Sage por nombre de sala + tipo IVA
  172.         $sageArticle = $em->getRepository(SageArticle::class)->findOneBy([
  173.             'vatType' => $sageVatRate,
  174.             'name' => $loungeName
  175.         ]);
  177.         // Solo salta el error si no se ha encontrado el artículo y está el modulo de Sage activo
  178.         if (!$sageArticle && $this->session->get('_config')['msage']) {
  179.             $this->addFlash('mensajereservationerror', 'No se ha encontrado el artículo de Sage para la sala: ' . $loungeName);
  180.             return $this->redirectToRoute('reservations_venues_edit', ['id' => $id]);
  181.         }
  183.         // Normalización horas desde POST
  184.         $hourMinStart = (string) ($simpleLounge['hourStart'] ?? '');
  185.         $hourMinEnd = (string) ($simpleLounge['hourEnd'] ?? '');
  187.         // Normalización horas desde POST usando el servicio
  188.         $startData = $this->reservationService->formatTimeInput((string) ($simpleLounge['hourStart'] ?? ''));
  189.         $endData = $this->reservationService->formatTimeInput((string) ($simpleLounge['hourEnd'] ?? ''));
  191.         $hourStart = $startData['hour'];
  192.         $minStart = $startData['min'];
  193.         $hourEnd = $endData['hour'];
  194.         $minEnd = $endData['min'];
  196.         $dateStart = new \DateTime(($simpleLounge['dateStart'] ?? date('Y-m-d')) . ' ' . $startData['formatted']);
  197.         $dateEnd = new \DateTime(($simpleLounge['dateStart'] ?? date('Y-m-d')) . ' ' . $endData['formatted']); // un solo día
  198.         $servicePrice = (float) ($simpleLounge['servicePrice'] ?? 0);
  199.         $idReservation = (int) $id;
  201.         // Usuario
  202.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  203.         $user_id = $user_logueado ? $user_logueado->getId() : null;
  204.         $createdAt = new \DateTime('now');
  205.         $updatedAt = new \DateTime('now');
  206.         $pax = (int) ($simpleLounge['pax'] ?? 0);
  208.         // Rank de cotización
  209.         $qb = $em->getRepository(ReservationLoungeSimple::class)->createQueryBuilder('r');
  210.         $reservationAll = $qb->where('r.idReservation = :idReservation')
  211.             ->setParameter('idReservation', $id)
  212.             ->orderBy('r.rankQuote', 'ASC')
  213.             ->getQuery()
  214.             ->getResult();
  215.         $newRankId = (!empty($reservationAll)) ? (end($reservationAll)->getRankQuote() + 1) : 1;
  216.         if (!empty($simpleLounge['idQuote']) && is_numeric($simpleLounge['idQuote'])) {
  217.             $newRankId = (int) $simpleLounge['idQuote'];
  218.         }
  220.         // Tipo: Dia de evento (null), Montaje o Desmontaje
  221.         $typeXLounge = empty($simpleLounge['type']) ? null : $simpleLounge['type'];
  223.         // Crear la entidad
  224.         $lounge = new ReservationLoungeSimple();
  225.         $lounge->setIdLounge($loungeId);
  226.         $lounge->setHourStart($hourStart);
  227.         $lounge->setMinStart($minStart);
  228.         $lounge->setHourEnd($hourEnd);
  229.         $lounge->setMinEnd($minEnd);
  230.         $lounge->setLoungeName($loungeName);
  231.         $lounge->setDateStart($dateStart);
  232.         $lounge->setDateEnd($dateEnd);
  233.         $lounge->setRankQuote($newRankId);
  234.         $lounge->setIdReservation($idReservation);
  235.         $lounge->setType($typeXLounge);
  236.         $lounge->setSageIva($sageVatRate);
  237.         $lounge->setOpIva(1);
  238.         $lounge->setCreatedAt($createdAt);
  239.         $lounge->setCreatedBy($user_id);
  240.         $lounge->setUpdatedAt($updatedAt);
  241.         $lounge->setUpdatedBy($user_id);
  242.         $lounge->setPax($pax);
  243.         $lounge->setImportantDescription($loungeSummaryDescription ?? '');
  244.         $lounge->setImportantDescGeneralText($loungeImportantDescGeneralText ?? '');
  245.         $lounge->setImportantDescSchedules($loungeImportantDescSchedules ?? '');
  246.         $lounge->setImportantDescParking($loungeImportantDescParking ?? '');
  248.         // Precio tarifario
  249.         $price = $this->reservationService->getTariffPrice($dateStart, $loungeId, $servicePrice);
  250.         $lounge->setServicePrice($price);
  252.         // Vincular la sala al artículo
  253.         $lounge->setSageArticle($sageArticle);
  255.         try {
  256.             $em->persist($lounge);
  257.             $em->flush();
  258.             $event = 'The Reservation has been updated.';
  259.             $successMessage = $this->translator->trans($event);
  260.             $this->addFlash('mensajereservation', $successMessage);
  261.         } catch (\Exception $e) {
  262.             $event = 'An error occurred: ' . $e->getMessage();
  263.             $errorMessage = $this->translator->trans($event);
  264.             $this->addFlash('mensajereservationerror', $errorMessage);
  265.         }
  267.         //Se llama al servicio para crear la entrada en la agenda y actualizar el Pax de la agenda
  268.         $loungeNameAgenda = empty($typeXLounge) ? $loungeName : $loungeName . ' ( ' . $typeXLounge . ' ) ';
  269.         $agenda = $this->agendaService->createAgendaFromSource($idReservation, 'SALAS A UTILIZAR', null, null, $dateStart, $dateEnd, $loungeNameAgenda, $lounge->getId(), 'ReservationLoungeSimple', $user_id);
  270.         $paxAge = $this->agendaService->calculatePaxForReservation($idReservation);
  271.         $agenda = $this->agendaService->updatePaxLine($idReservation, $paxAge, $user_id);
  273.         // Actualizar fechas de la reserva usando el servicio
  274.         if ($reservation) {
  275.             $this->reservationService->updateReservationDates($reservation);
  276.             //Se llama al servicio para crear la entrada en la agenda de las fechas
  277.             $this->agendaService->updateDatesLine($idReservation, $user_id);
  278.         }
  280.         // Creamos la Snapshot de las salas y servicios del sistema (LOG)
  281.         $version = $this->venueService->createSnapshot($reservation);
  283.         // Sincronizar contratos si está confirmado
  284.         if ($reservation->getStatus() === 'Confirmed') {
  285.             $this->docContractService->autoAssignContracts($reservation, $user_logueado);
  286.         }
  288.         // Redirección para agregar servicio de limpieza
  289.         return $this->redirectToRoute('reservations_white_addservices_cleaning', [
  290.             'resid' => $id,
  291.             'loungesimpleid' => $lounge->getId(),
  292.         ]);
  293.     }
  296.     /**
  297.      * @Route("/api/get-price", name="get_reservations_price_to_view", methods={"GET"})
  298.      */
  299.     public function getPrice(Request $request)
  300.     {
  301.         $loungeId = $request->query->get('sala');
  302.         $dateStart = $request->query->get('date');
  304.         if (!$loungeId || !$dateStart) {
  305.             return new JsonResponse(['error' => 'Missing parameters'], 400);
  306.         }
  308.         try {
  309.             $dateStartObj = new \DateTime($dateStart);
  310.         } catch (\Exception $e) {
  311.             return new JsonResponse(['error' => 'Invalid date'], 400);
  312.         }
  314.         $price = $this->reservationService->getTariffPrice($dateStartObj, $loungeId, 0);
  316.         return new JsonResponse(['price' => $price]);
  317.     }
  320.     /**
  321.      * @Route("/createsimpleloungemondes/{id}", name="reservations_venues_create_simple_lounge_mondes")
  322.      * Se crea un dia de montaje o desmontaje
  323.      */
  324.     public function createSimpleLoungeMonDesAction($id, EntityManagerInterface $em, Request $request)
  325.     {
  326.         $simpleLounge = $request->request->get('reservation_sala_mondes');
  327.         $loungeId = $simpleLounge['idLounge'];
  328.         $loungeDetails = $em->getRepository(ReservationLoungeDetails::class)->findOneById($loungeId);
  329.         $previusLoungeSimple = $em->getRepository(ReservationLoungeSimple::class)->findOneBy(array('idLounge' => $loungeId, 'idReservation' => $id, 'rankQuote' => $simpleLounge['idQuote']));
  330.         $loungeName = $loungeDetails->getName();
  331.         $hourMinStart = $simpleLounge['hourStart'];
  332.         $hourMinEnd = $simpleLounge['hourEnd'];
  334.         // Buscamos la reserva que es para saber si es sucoe o no
  335.         $reservation = $em->getRepository(Reservation::class)->findOneById($id);
  336.         $sucoe = $reservation->isSucoe();
  337.         // Si no es sucoe, cogemos el IVA del 21% y si lo es, entonces el del 0%
  338.         if (!$sucoe) {
  339.             $sageVatRate = $em->getRepository(SageVatRates::class)->findOneBy(['sageCode' => '03']);
  340.         } else {
  341.             $sageVatRate = $em->getRepository(SageVatRates::class)->findOneBy(['sageCode' => '00']);
  342.         }
  343.         $sageArticle = $em->getRepository(SageArticle::class)->findOneBy(['vatType' => $sageVatRate, 'name' => $loungeName]);
  345.         // Si no se ha encontrado el artículo de Sage.
  346.         if (empty($sageArticle)) {
  347.             $this->addFlash('mensajereservationerror', 'No se ha encontrado el artículo de Sage para la sala: ' . $loungeName);
  348.             return $this->redirectToRoute('reservations_venues_edit', array(
  349.                 'id' => $id,
  350.             ));
  351.         }
  353.         if (empty($previusLoungeSimple)) {
  354.             $loungeSummaryDescription = $loungeDetails->getImportantDescription();
  355.             $loungeImportantDescGeneralText = $loungeDetails->getImportantDescGeneralText();
  356.             $loungeImportantDescSchedules = $loungeDetails->getImportantDescSchedules();
  357.             $loungeImportantDescParking = $loungeDetails->getImportantDescParking();
  358.         } else {
  359.             $loungeSummaryDescription = $previusLoungeSimple->getImportantDescription();
  360.             $loungeImportantDescGeneralText = $previusLoungeSimple->getImportantDescGeneralText();
  361.             $loungeImportantDescSchedules = $previusLoungeSimple->getImportantDescSchedules();
  362.             $loungeImportantDescParking = $previusLoungeSimple->getImportantDescParking();
  363.         }
  365.         $qb = $em->getRepository(ReservationLoungeSimple::class)->createQueryBuilder('r');
  366.         $reservationAll = $qb->where('r.idReservation = :idReservation')
  367.             ->setParameter('idReservation', $id)
  368.             ->orderBy('r.rankQuote', 'ASC')
  369.             ->getQuery()
  370.             ->getResult();
  372.         $newRankId = (!empty($reservationAll)) ? (end($reservationAll)->getRankQuote() + 1) : 1;
  373.         if (!empty($simpleLounge['idQuote'])) {
  374.             if (is_numeric($simpleLounge['idQuote'])) {
  375.                 $newRankId = $simpleLounge['idQuote'];
  376.             }
  377.         }
  379.         // Normalización horas desde POST usando el servicio
  380.         $startData = $this->reservationService->formatTimeInput((string) ($simpleLounge['hourStart'] ?? ''));
  381.         $endData = $this->reservationService->formatTimeInput((string) ($simpleLounge['hourEnd'] ?? ''));
  383.         $hourStart = $startData['hour'];
  384.         $minStart = $startData['min'];
  385.         $hourEnd = $endData['hour'];
  386.         $minEnd = $endData['min'];
  388.         $hourMinStart = $startData['formatted'];
  389.         $hourMinEnd = $endData['formatted'];
  391.         $dateStart = new DateTime($simpleLounge['dateStart'] . ' ' . $hourMinStart);
  392.         $dateEnd = new DateTime($simpleLounge['dateStart'] . ' ' . $hourMinEnd);   // Se usa DateStart por que solo hay un dia en el formulario
  393.         $servicePrice = empty($simpleLounge['servicePrice']) ? 0 : $simpleLounge['servicePrice'];
  394.         $idReservation = $id;
  395.         /* Obtengo usuario logueado */
  396.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  397.         $user_id = $user_logueado->getId();
  398.         $createdAt = new DateTime('now');
  399.         $createdBy = $user_id;
  400.         $updatedAt = new DateTime('now');
  401.         $updatedBy = $user_id;
  402.         $lounge = new ReservationLoungeSimple();
  404.         if ($simpleLounge['type'] == 'Montaje') {
  405.             $lounge->setType('Montaje');
  406.         } else {
  407.             $lounge->setType('Desmontaje');
  408.         }
  409.         $pax = 0;
  410.         $lounge->setIdLounge($loungeId);
  411.         $lounge->setHourStart($hourStart);
  412.         $lounge->setMinStart($minStart);
  413.         $lounge->setHourEnd($hourEnd);
  414.         $lounge->setMinEnd($minEnd);
  415.         $lounge->setLoungeName($loungeName);
  416.         $lounge->setDateStart($dateStart);
  417.         $lounge->setDateEnd($dateEnd);
  418.         $lounge->setRankQuote(1);
  419.         $lounge->setSageIva($sageArticle->getVatType());
  420.         $lounge->setOpIva(1);
  421.         $lounge->setIdReservation($idReservation);
  422.         $lounge->setCreatedAt($createdAt);
  423.         $lounge->setCreatedBy($createdBy);
  424.         $lounge->setUpdatedAt($updatedAt);
  425.         $lounge->setUpdatedBy($updatedBy);
  426.         $lounge->setPax($pax);
  427.         $lounge->setRankQuote($newRankId);
  428.         $lounge->setImportantDescription($loungeSummaryDescription);
  429.         $lounge->setImportantDescGeneralText($loungeImportantDescGeneralText);
  430.         $lounge->setImportantDescSchedules($loungeImportantDescSchedules);
  431.         $lounge->setImportantDescParking($loungeImportantDescParking);
  433.         $price = 0; // Se asume 0 según lógica de precioPorFecha original que era inalcanzable
  434.         $servicePrice = ($price == 0) ? $servicePrice : $price;
  435.         $lounge->setServicePrice($servicePrice);
  437.         // Vincular la sala al artículo
  438.         $lounge->setSageArticle($sageArticle);
  440.         try {
  441.             $em->persist($lounge);
  442.             $em->flush();
  443.             $event = 'The Reservation has been updated.';
  444.             $successMessage = $this->translator->trans($event);
  445.             $this->addFlash('mensajereservation', $successMessage);
  447.         } catch (\Exception $e) {
  449.             $event = 'An error occurred: ' . $e->getMessage();
  450.             $errorMessage = $this->translator->trans($event);
  451.             $this->addFlash('mensajereservationerror', $errorMessage);
  452.         }
  454.         $reservax = $em->getRepository(Reservation::class)->findOneById($idReservation);
  456.         if ($reservax) {
  457.             $this->reservationService->updateReservationDates($reservax);
  458.             
  459.             // Sincronizar contratos si está confirmado
  460.             if ($reservax->getStatus() === 'Confirmed') {
  461.                 $this->docContractService->autoAssignContracts($reservax, $user_logueado);
  462.             }
  463.         }
  465.         // FIN: Verificamos si es necesario actualizar las fechas de la reserva
  467.         return $this->redirectToRoute(
  468.             'reservations_venues_edit_simple',
  469.             array(
  470.                 'id' => $id,
  471.                 'token' => null,
  472.                 '_fragment' => 'btn_quotes'
  473.             )
  474.         );
  475.     }
  478.     /**
  479.      * @Route("/duplicateday/{id}/{dayduplicate}/{idRankQuote}", name="reservations_venues_duplicate_day")
  480.      * Duplica un elemento de la cotizacion para el dia siguiente
  481.      */
  482.     public function duplicateDayAction($id, $dayduplicate, $idRankQuote, EntityManagerInterface $em, Request $request)
  483.     {
  484.         $loungeSimples = $em->getRepository(ReservationLoungeSimple::class)->findByIdReservation($id);
  485.         $reservax = $em->getRepository(Reservation::class)->findOneById($id);
  486.         $vatRepo = $em->getRepository(SageVatRates::class);
  488.         /* Usuario logueado */
  489.         $user = $this->get('security.token_storage')->getToken()->getUser();
  490.         $user_id = $user ? $user->getId() : null;
  491.         $createdAt = new \DateTime('now');
  492.         $updatedAt = new \DateTime('now');
  493.         $createdBy = $user_id;
  494.         $updatedBy = $user_id;
  496.         if (!empty($loungeSimples)) {
  497.             foreach ($loungeSimples as $item) {
  498.                 if (
  499.                     $item->getDateStart() &&
  500.                     $item->getDateStart()->format('d-m-Y') == $dayduplicate &&
  501.                     $item->getRankQuote() == $idRankQuote
  502.                 ) {
  503.                     // Se duplica y suma un día (sin mutar el original)
  504.                     $newLoungeSimple = new ReservationLoungeSimple();
  505.                     $newLoungeSimple->setDateStart((clone $item->getDateStart())->modify('+1 day'));
  506.                     $newLoungeSimple->setDateEnd((clone $item->getDateEnd())->modify('+1 day'));
  507.                     $newLoungeSimple->setHourStart($item->getHourStart());
  508.                     $newLoungeSimple->setHourEnd($item->getHourEnd());
  509.                     $newLoungeSimple->setMinStart($item->getMinStart());
  510.                     $newLoungeSimple->setMinEnd($item->getMinEnd());
  511.                     $newLoungeSimple->setIdLounge($item->getIdLounge());
  512.                     $newLoungeSimple->setIdReservation($item->getIdReservation());
  513.                     $newLoungeSimple->setLoungeName($item->getLoungeName());
  514.                     $newLoungeSimple->setPax($item->getPax());
  515.                     $newLoungeSimple->setServicePrice($item->getServicePrice());
  517.                     // IVA (string)
  518.                     $newLoungeSimple->setIva($item->getIva());
  520.                     // Relación SageVatRates (entidad)
  521.                     $vatEntity = method_exists($item, 'getSageIva') ? $item->getSageIva() : null;
  522.                     if (!$vatEntity) {
  523.                         $rawRate = $item->getIva();
  524.                         if ($rawRate !== null && $rawRate !== '') {
  525.                             $rate = (float) $rawRate;
  526.                             // Normaliza si en BD está como fracción (0.21)
  527.                             if ($rate > 1) {
  528.                                 $rate = $rate / 100;
  529.                             }
  530.                             // Ajusta 'rate' si tu campo en SageVatRates tiene otro nombre
  531.                             $vatEntity = $vatRepo->findOneBy(['rate' => $rate]);
  532.                         }
  533.                     }
  534.                     $newLoungeSimple->setSageIva($vatEntity);
  536.                     $newLoungeSimple->setOpIva($item->getOpIva());
  537.                     $newLoungeSimple->setType($item->getType());
  538.                     $newLoungeSimple->setLoungeDescription($item->getLoungeDescription());
  539.                     $newLoungeSimple->setImportantDescription($item->getImportantDescription());
  540.                     $newLoungeSimple->setImportantDescGeneralText($item->getImportantDescGeneralText());
  541.                     $newLoungeSimple->setImportantDescSchedules($item->getImportantDescSchedules());
  542.                     $newLoungeSimple->setImportantDescParking($item->getImportantDescParking());
  543.                     $newLoungeSimple->setRankQuote($idRankQuote);
  544.                     $newLoungeSimple->setCreatedAt($createdAt);
  545.                     $newLoungeSimple->setCreatedBy($createdBy);
  546.                     $newLoungeSimple->setUpdatedAt($updatedAt);
  547.                     $newLoungeSimple->setUpdatedBy($updatedBy);
  549.                     try {
  550.                         $em->persist($newLoungeSimple);
  551.                         $em->flush();
  552.                         $event = 'The Item has been duplicated.';
  553.                         $successMessage = $this->translator->trans($event);
  554.                         $this->addFlash('mensajereservation', $successMessage);
  555.                     } catch (\Exception $e) {
  556.                         $event = 'An error occurred: ' . $e->getMessage();
  557.                         $errorMessage = $this->translator->trans($event);
  558.                         $this->addFlash('mensajereservationerror', $errorMessage);
  559.                     }
  561.                     // Actualiza fechas de la reserva si procede
  562.                     $boolReserva = false;
  563.                     if ($newLoungeSimple->getDateStart() < $reservax->getDateStart()) {
  564.                         $reservax->setDateStart($newLoungeSimple->getDateStart());
  565.                         $boolReserva = true;
  566.                     }
  567.                     if ($reservax->getDateEnd() < $newLoungeSimple->getDateEnd()) {
  568.                         $reservax->setDateEnd($newLoungeSimple->getDateEnd());
  569.                         $boolReserva = true;
  570.                     }
  571.                     if ($boolReserva) {
  572.                         $em->persist($reservax);
  573.                         $em->flush();
  574.                     }
  575.                 }
  576.             }
  577.         } else {
  578.             // Registro antiguo: transformar a los nuevos y luego duplicar
  579.             $loungeOld = $em->getRepository(ReservationLounge::class)->findByIdReservation($id);
  580.             foreach ($loungeOld as $item) {
  581.                 if ($item->getDateStart()->format('Y-m-d') == $item->getDateEnd()->format('Y-m-d')) {
  582.                     // Mismo día → simple
  583.                     $newLoungeSimple = new ReservationLoungeSimple();
  584.                     $newLoungeSimple->setDateStart(clone $item->getDateStart());
  585.                     $newLoungeSimple->setDateEnd(clone $item->getDateEnd());
  586.                     $newLoungeSimple->setHourStart($item->getHourStart());
  587.                     $newLoungeSimple->setHourEnd($item->getHourEnd());
  588.                     $newLoungeSimple->setMinStart($item->getMinStart());
  589.                     $newLoungeSimple->setMinEnd($item->getMinEnd());
  590.                     $newLoungeSimple->setIdLounge($item->getIdLounge());
  591.                     $newLoungeSimple->setIdReservation($item->getIdReservation());
  592.                     $newLoungeSimple->setLoungeName($item->getLoungeName());
  593.                     $newLoungeSimple->setPax($item->getPax());
  594.                     $newLoungeSimple->setServicePrice($item->getServicePrice());
  596.                     // IVA (string)
  597.                     $newLoungeSimple->setIva($item->getIva());
  598.                     // Resolver SageVatRates desde el string
  599.                     $rawRate = $item->getIva();
  600.                     $vatEnt = null;
  601.                     if ($rawRate !== null && $rawRate !== '') {
  602.                         $rate = (float) $rawRate;
  603.                         if ($rate > 1) {
  604.                             $rate = $rate / 100;
  605.                         }
  606.                         $vatEnt = $vatRepo->findOneBy(['rate' => $rate]);
  607.                     }
  608.                     $newLoungeSimple->setSageIva($vatEnt);
  610.                     $newLoungeSimple->setOpIva($item->getOpIva());
  611.                     $newLoungeSimple->setType($item->getType());
  612.                     $newLoungeSimple->setRankQuote($item->getRankQuote());
  613.                     $newLoungeSimple->setLoungeDescription($item->getLoungeDescription());
  614.                     $newLoungeSimple->setImportantDescription($item->getImportantDescription());
  615.                     $newLoungeSimple->setCreatedAt($createdAt);
  616.                     $newLoungeSimple->setCreatedBy($createdBy);
  617.                     $newLoungeSimple->setUpdatedAt($updatedAt);
  618.                     $newLoungeSimple->setUpdatedBy($updatedBy);
  620.                     try {
  621.                         $em->persist($newLoungeSimple);
  622.                         $em->flush();
  623.                         $event = 'The Item has been duplicated.';
  624.                         $successMessage = $this->translator->trans($event);
  625.                         $this->addFlash('mensajereservation', $successMessage);
  626.                     } catch (\Exception $e) {
  627.                         $event = 'An error occurred: ' . $e->getMessage();
  628.                         $errorMessage = $this->translator->trans($event);
  629.                         $this->addFlash('mensajereservationerror', $errorMessage);
  630.                     }
  632.                     // Actualiza fechas de la reserva si procede
  633.                     $boolReserva = false;
  634.                     if ($newLoungeSimple->getDateStart() < $reservax->getDateStart()) {
  635.                         $reservax->setDateStart($newLoungeSimple->getDateStart());
  636.                         $boolReserva = true;
  637.                     }
  638.                     if ($reservax->getDateEnd() < $newLoungeSimple->getDateEnd()) {
  639.                         $reservax->setDateEnd($newLoungeSimple->getDateEnd());
  640.                         $boolReserva = true;
  641.                     }
  642.                     if ($boolReserva) {
  643.                         $em->persist($reservax);
  644.                         $em->flush();
  645.                     }
  646.                 } else {
  647.                     // Varios días → trocear en simples
  648.                     $firstDay = new \DateTime($item->getDateStart()->format('Y-m-d'));
  649.                     $lastDay = new \DateTime($item->getDateEnd()->format('Y-m-d'));
  650.                     $numDays = ($lastDay->diff($firstDay))->days + 1;
  652.                     $actualDay = clone $item->getDateStart();
  653.                     $actualStartDay = clone $item->getDateStart();
  654.                     $actualEndDay = clone $item->getDateEnd();
  656.                     for ($i = 0; $i < $numDays; $i++) {
  657.                         $newLoungeSimple = new ReservationLoungeSimple();
  659.                         if ($i === 0) {
  660.                             // Primer día
  661.                             $newLoungeSimple->setDateStart(clone $actualStartDay);
  662.                             $newLoungeSimple->setDateEnd(new \DateTime($actualStartDay->format('Y-m-d') . ' 23:59'));
  663.                             $newLoungeSimple->setHourStart($item->getHourStart());
  664.                             $newLoungeSimple->setHourEnd('23');
  665.                             $newLoungeSimple->setMinStart($item->getMinStart());
  666.                             $newLoungeSimple->setMinEnd('59');
  667.                         } elseif (($i + 1) === $numDays) {
  668.                             // Último día
  669.                             $newLoungeSimple->setDateStart(new \DateTime($actualEndDay->format('Y-m-d') . ' 00:00'));
  670.                             $newLoungeSimple->setDateEnd(clone $actualEndDay);
  671.                             $newLoungeSimple->setHourStart('00');
  672.                             $newLoungeSimple->setHourEnd($item->getHourEnd());
  673.                             $newLoungeSimple->setMinStart('00');
  674.                             $newLoungeSimple->setMinEnd($item->getMinEnd());
  675.                         } else {
  676.                             // Día intermedio
  677.                             $newLoungeSimple->setDateStart(new \DateTime($actualDay->format('Y-m-d') . ' 00:00'));
  678.                             $newLoungeSimple->setDateEnd(new \DateTime($actualDay->format('Y-m-d') . ' 23:59'));
  679.                             $newLoungeSimple->setHourStart('00');
  680.                             $newLoungeSimple->setHourEnd('23');
  681.                             $newLoungeSimple->setMinStart('00');
  682.                             $newLoungeSimple->setMinEnd('59');
  683.                         }
  685.                         $newLoungeSimple->setIdLounge($item->getIdLounge());
  686.                         $newLoungeSimple->setIdReservation($item->getIdReservation());
  687.                         $newLoungeSimple->setLoungeName($item->getLoungeName());
  688.                         $newLoungeSimple->setPax($item->getPax());
  689.                         $newLoungeSimple->setServicePrice($item->getServicePrice());
  691.                         // IVA (string) + entidad
  692.                         $newLoungeSimple->setIva($item->getIva());
  693.                         $rawRate = $item->getIva();
  694.                         $vatEnt = null;
  695.                         if ($rawRate !== null && $rawRate !== '') {
  696.                             $rate = (float) $rawRate;
  697.                             if ($rate > 1) {
  698.                                 $rate = $rate / 100;
  699.                             }
  700.                             $vatEnt = $vatRepo->findOneBy(['rate' => $rate]);
  701.                         }
  702.                         $newLoungeSimple->setSageIva($vatEnt);
  704.                         $newLoungeSimple->setOpIva($item->getOpIva());
  705.                         $newLoungeSimple->setType($item->getType());
  706.                         $newLoungeSimple->setRankQuote($item->getRankQuote());
  707.                         $newLoungeSimple->setLoungeDescription($item->getLoungeDescription());
  708.                         $newLoungeSimple->setImportantDescription($item->getImportantDescription());
  709.                         $newLoungeSimple->setCreatedAt($createdAt);
  710.                         $newLoungeSimple->setCreatedBy($createdBy);
  711.                         $newLoungeSimple->setUpdatedAt($updatedAt);
  712.                         $newLoungeSimple->setUpdatedBy($updatedBy);
  714.                         // Avanza el día (sin perder la referencia)
  715.                         $actualDay = (clone $actualDay)->modify('+1 day');
  717.                         try {
  718.                             $em->persist($newLoungeSimple);
  719.                             $em->flush();
  720.                             $event = 'The Item has been updated.';
  721.                             $successMessage = $this->translator->trans($event);
  722.                             $this->addFlash('mensajereservation', $successMessage);
  723.                         } catch (\Exception $e) {
  724.                             $event = 'An error occurred: ' . $e->getMessage();
  725.                             $errorMessage = $this->translator->trans($event);
  726.                             $this->addFlash('mensajereservationerror', $errorMessage);
  727.                         }
  729.                         // Actualiza fechas de la reserva si procede
  730.                         $boolReserva = false;
  731.                         if ($newLoungeSimple->getDateStart() < $reservax->getDateStart()) {
  732.                             $reservax->setDateStart($newLoungeSimple->getDateStart());
  733.                             $boolReserva = true;
  734.                         }
  735.                         if ($reservax->getDateEnd() < $newLoungeSimple->getDateEnd()) {
  736.                             $reservax->setDateEnd($newLoungeSimple->getDateEnd());
  737.                             $boolReserva = true;
  738.                         }
  739.                         if ($boolReserva) {
  740.                             $em->persist($reservax);
  741.                             $em->flush();
  742.                         }
  743.                     }
  744.                 }
  746.                 // Re-llama al mismo controlador ahora con la nueva tabla poblada
  747.                 return $this->redirectToRoute('reservations_venues_duplicate_day', [
  748.                     'id' => $id,
  749.                     'dayduplicate' => $dayduplicate,
  750.                 ]);
  751.             }
  752.         }
  754.         //Se llama al servicio para crear la entrada en la agenda y actualizar el Pax de la agenda
  755.         $agenda = $this->agendaService->createAgendaFromSource($newLoungeSimple->getIdReservation(), 'SALAS A UTILIZAR', null, null, $newLoungeSimple->getDateStart(), $newLoungeSimple->getDateEnd(), $newLoungeSimple->getLoungeName(), $newLoungeSimple->getId(), 'ReservationLoungeSimple', $updatedBy);
  757.         $reserva = $em->getRepository(Reservation::class)->findOneById($newLoungeSimple->getIdReservation());
  759.         //Se llama al servicio para crear la entrada en la agenda de las fechas
  760.         $agenda = $this->agendaService->updateDatesLine($reserva->getId(), $updatedBy);
  762.         // Creamos la Snapshot de las salas y servicios del sistema (LOG)
  763.         $version = $this->venueService->createSnapshot($reservax);
  765.         /* Obtengo usuario logueado */
  766.         $user = $this->get('security.token_storage')->getToken()->getUser();
  768.         // Sincronizar contratos si está confirmado
  769.         if ($reservax->getStatus() === 'Confirmed') {
  770.             $this->docContractService->autoAssignContracts($reservax, $user);
  771.         }
  773.         // Redirige para agregar Servicio de limpieza
  774.         return $this->redirectToRoute('reservations_white_addservices_cleaning', [
  775.             'resid' => $id,
  776.             'loungesimpleid' => isset($newLoungeSimple) ? $newLoungeSimple->getId() : null,
  777.         ]);
  778.     }
  781.     /**
  782.      * @Route("/deleteitemsimple/{id}/{daydelete}", name="reservations_venues_delete_simple_lounge")
  783.      * Elimina un Reservation Simple Lounge de la cotizacion
  784.      */
  785.     public function deleteSimpleLoungeAction($id, $daydelete, EntityManagerInterface $em, Request $request)
  786.     {
  787.         $loungeSimple = $em->getRepository(ReservationLoungeSimple::class)->findOneById($id);
  789.         if (!empty($loungeSimple)) {
  790.             //Se llama al servicio para eliminar la entrada en la agenda
  791.             $agenda = $this->agendaService->deleteAgendaBySource($loungeSimple->getId(), 'ReservationLoungeSimple');
  792.         }
  794.         $id = $loungeSimple->getIdReservation();
  795.         $reserva = $em->getRepository(Reservation::class)->findOneById($loungeSimple->getIdReservation());
  797.         try {
  798.             $em->remove($loungeSimple);
  799.             $em->flush();
  800.             $event = 'The item has been deleted.';
  801.             $successMessage = $this->translator->trans($event);
  802.             $this->addFlash('mensajereservation', $successMessage);
  803.         } catch (\Exception $e) {
  804.             $event = 'An error occurred: ' . $e->getMessage();
  805.             $errorMessage = $this->translator->trans($event);
  806.             $this->addFlash('mensajereservationerror', $errorMessage);
  807.         }
  809.         /* Obtengo usuario logueado */
  810.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  812.         // Recalcular fechas de la reserva usando el servicio
  813.         if ($reserva) {
  814.             $this->reservationService->updateReservationDates($reserva);
  815.             
  816.             // Sincronizar contratos si está confirmado
  817.             if ($reserva->getStatus() === 'Confirmed') {
  818.                 $this->docContractService->autoAssignContracts($reserva, $user_logueado);
  819.             }
  820.         }
  821.         $user_id = $user_logueado->getId();
  823.         //Se llama al servicio para crear la entrada en la agenda de las fechas
  824.         $agenda = $this->agendaService->updateDatesLine($reserva->getId(), $user_id);
  826.         //Se llama al servicio para actualizar Pax en la agenda
  827.         $paxAge = $this->agendaService->calculatePaxForReservation($reserva->getId());
  828.         $agenda = $this->agendaService->updatePaxLine($reserva->getId(), $paxAge, $user_id);
  830.         // Se elimina el servicio de horas de limpieza de la sala
  831.         return $this->redirectToRoute(
  832.             'reservations_venues_delete_simple_lounge_cleaning',
  833.             array(
  834.                 'idRes' => $id,
  835.                 'idLng' => $loungeSimple->getIdLounge(),
  836.                 'dateInAt' => $loungeSimple->getDateStart()->format('Y-m-d\TH:i'),
  837.                 'dateOutAt' => $loungeSimple->getDateEnd()->format('Y-m-d\TH:i'),
  838.             )
  839.         );
  840.     }
  843.     /**
  844.      * @Route("/deletequote/{idRes}/{idQuote}", name="reservations_delete_quote")
  845.      * Eliminar una cotizancion
  846.      */
  847.     public function deleteQuoteAction($idRes, $idQuote, EntityManagerInterface $em, Request $request)
  848.     {
  849.         $qb = $em->getRepository(ReservationLoungeSimple::class)->createQueryBuilder('r');
  850.         $reservation = $qb->where('r.rankQuote = :rankQuote')
  851.             ->andWhere('r.idReservation = :idReservation')
  852.             ->setParameter('idReservation', $idRes)
  853.             ->setParameter('rankQuote', $idQuote)
  854.             ->getQuery()
  855.             ->getResult();
  857.         foreach ($reservation as $item) {
  858.             try {
  859.                 if (!empty($item)) {
  860.                     //Se llama al servicio para eliminar la entrada en la agenda
  861.                     $agenda = $this->agendaService->deleteAgendaBySource($item->getId(), 'ReservationLoungeSimple');
  862.                 }
  864.                 $em->remove($item);
  865.                 $em->flush();
  866.                 $event = 'Se ha eliminado la cotización';
  867.                 $successMessage = $this->translator->trans($event);
  868.                 $this->addFlash('mensajereservation', $successMessage);
  869.             } catch (\Exception $e) {
  870.                 $event = 'An error occurred: ' . $e->getMessage();
  871.                 $errorMessage = $this->translator->trans($event);
  872.                 $this->addFlash('mensajereservationerror', $errorMessage);
  873.             }
  875.             //Se deben eliminar todas las horas de limpieza asociadas a las salas de la cotización
  876.             $loungeDetails = $em->getRepository(ReservationLoungeDetails::class)->findOneById($item->getIdLounge());
  877.             $stringName = 'HORAS ( ' . $loungeDetails->getName() . ' )';
  878.             $serviceCatIdClean = 21;
  879.             $dateInAt = new \DateTime($item->getDateStart()->format('Y-m-d\TH:i'));
  880.             $dateOutAt = new \DateTime($item->getDateEnd()->format('Y-m-d\TH:i'));
  882.             $qb = $em->getRepository(ReservationService::class)->createQueryBuilder('rs');
  884.             $serviceClean = $qb->where('rs.reservationId = :id')
  885.                 ->andWhere('rs.name = :name')
  886.                 ->andWhere('rs.dateInAt = :dateInAt')
  887.                 ->andWhere('rs.dateOutAt = :dateOutAt')
  888.                 ->andWhere('rs.serviceCatId = :serviceCatId')
  889.                 ->setParameter('id', $idRes)
  890.                 ->setParameter('name', $stringName)
  891.                 ->setParameter('dateInAt', $dateInAt)
  892.                 ->setParameter('dateOutAt', $dateOutAt)
  893.                 ->setParameter('serviceCatId', $serviceCatIdClean)
  894.                 ->getQuery()
  895.                 ->getResult();
  897.             if (!empty($serviceClean)) {
  898.                 // Se elimina el servicio de horas de limpieza de la sala
  899.                 $em->remove($serviceClean[0]);
  900.                 $em->flush();
  901.             }
  902.         }
  904.         /* Obtengo usuario logueado */
  905.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  906.         $user_id = $user_logueado->getId();
  908.         //Se llama al servicio para actualizar Pax en la agenda
  909.         $paxAge = $this->agendaService->calculatePaxForReservation($idRes);
  910.         $agenda = $this->agendaService->updatePaxLine($idRes, $paxAge, $user_id);
  912.         //Se llama al servicio para actualizar Fechas en la agenda
  913.         $agenda = $this->agendaService->updateDatesLine($idRes, $user_id);
  915.         // Recalcular fechas de la reserva
  916.         $reservaEntity = $em->getRepository(Reservation::class)->find($idRes);
  917.         if ($reservaEntity) {
  918.             $this->reservationService->updateReservationDates($reservaEntity);
  919.         }
  921.         return $this->redirectToRoute(
  922.             'reservations_venues_edit_simple',
  923.             array(
  924.                 'id' => $idRes,
  925.                 'token' => null,
  926.                 '_fragment' => 'btn_quotes'
  927.             )
  928.         );
  929.     }
  932.     /**
  933.      * @Route("/checkquote/{idRes}/{idQuote}", name="reservations_check_quote")
  934.      * Confirmación de que se ha aceptado la cotizancion, se eliminaran las otras cotizaciones del expediente
  935.      */
  936.     public function checkQuoteAction($idRes, $idQuote, EntityManagerInterface $em, Request $request)
  937.     {
  938.         $qb = $em->getRepository(ReservationLoungeSimple::class)->createQueryBuilder('r');
  939.         $reservation = $qb->where('r.rankQuote <> :rankQuote')
  940.             ->andWhere('r.idReservation = :idReservation')
  941.             ->setParameter('idReservation', $idRes)
  942.             ->setParameter('rankQuote', $idQuote)
  943.             ->getQuery()
  944.             ->getResult();
  946.         foreach ($reservation as $item) {
  947.             try {
  948.                 if (!empty($item)) {
  949.                     //Se llama al servicio para eliminar la entrada en la agenda
  950.                     $agenda = $this->agendaService->deleteAgendaBySource($item->getId(), 'ReservationLoungeSimple');
  951.                 }
  952.                 $em->remove($item);
  953.                 $em->flush();
  954.                 $event = 'Se han eliminado las otras cotizaciones';
  955.                 $successMessage = $this->translator->trans($event);
  956.                 $this->addFlash('mensajereservation', $successMessage);
  957.             } catch (\Exception $e) {
  958.                 $event = 'An error occurred: ' . $e->getMessage();
  959.                 $errorMessage = $this->translator->trans($event);
  960.                 $this->addFlash('mensajereservationerror', $errorMessage);
  961.             }
  962.         }
  964.         // Actualizar fechas de la reserva usando el servicio
  965.         $reservation = $em->getRepository(Reservation::class)->findOneById($idRes);
  966.         $this->reservationService->updateReservationDates($reservation);
  968.         /* Obtengo usuario logueado */
  969.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  970.         $user_id = $user_logueado->getId();
  972.         //Se llama al servicio para actualizar Pax en la agenda
  973.         $paxAge = $this->agendaService->calculatePaxForReservation($idRes);
  974.         $agenda = $this->agendaService->updatePaxLine($idRes, $paxAge, $user_id);
  976.         //Se llama al servicio para actualizar Fechas en la agenda
  977.         $agenda = $this->agendaService->updateDatesLine($idRes, $user_id);
  979.         return $this->redirectToRoute(
  980.             'reservations_venues_edit_simple',
  981.             array(
  982.                 'id' => $idRes,
  983.                 'token' => null,
  984.                 '_fragment' => 'btn_quotes'
  985.             )
  986.         );
  987.     }
  990.     /**
  991.      * @Route("/duplicatequote", name="reservations_duplicate_quote")
  992.      * Duplicar una cotizacion
  993.      */
  994.     public function duplicateQuoteAction(EntityManagerInterface $em, Request $request)
  995.     {
  997.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  998.         $user_id = $user_logueado->getId();
  999.         $hoy = new \DateTime("now", NULL);
  1000.         $reqDuplicateQuote = $request->request->get('addquote');
  1001.         $newLounge = $em->getRepository(ReservationLoungeDetails::class)->findOneById($reqDuplicateQuote['salaPrecargadas']);
  1003.         $qb = $em->getRepository(ReservationLoungeSimple::class)->createQueryBuilder('r');
  1004.         $reservationAll = $qb->where('r.idReservation = :idReservation')
  1005.             ->setParameter('idReservation', $reqDuplicateQuote['reservationId'])
  1006.             ->orderBy('r.rankQuote', 'ASC')
  1007.             ->getQuery()
  1008.             ->getResult();
  1010.         $newRankId = (!empty($reservationAll)) ? (end($reservationAll)->getRankQuote() + 1) : 1;
  1011.         if (empty($reqDuplicateQuote['idQuote'])) {
  1012.             $reqDuplicateQuote['idQuote'] = reset($reservationAll)->getRankQuote();
  1013.         }   //Si no elige cotización se duplica la primera
  1015.         $qb = $em->getRepository(ReservationLoungeSimple::class)->createQueryBuilder('r');
  1016.         $reservation = $qb->where('r.rankQuote = :rankQuote')
  1017.             ->andWhere('r.idReservation = :idReservation')
  1018.             ->setParameter('idReservation', $reqDuplicateQuote['reservationId'])
  1019.             ->setParameter('rankQuote', $reqDuplicateQuote['idQuote'])
  1020.             ->getQuery()
  1021.             ->getResult();
  1023.         // Descripciones web por sala/idioma con fallbacks
  1024.         $loungeProfile = $newLounge;
  1025.         // Heredar idioma si existe alguna sala previa en la reserva
  1026.         $idioma = empty($reservationAll) ? 1: $reservationAll[0]->getLanguage();
  1028.         $loungeWebDescriptionRepo = $em->getRepository(ReservationLoungeWebDescription::class);
  1029.         $loungeWebDescription = $loungeWebDescriptionRepo->findOneBy([
  1030.                 'lounge' => $loungeProfile,
  1031.                 'language' => $idioma
  1032.             ]) ?? ($idioma !== 1 ? $loungeWebDescriptionRepo->findOneBy([
  1033.                 'lounge' => $loungeProfile,
  1034.                 'language' => 1
  1035.             ]) : null) ?? $loungeWebDescriptionRepo->findOneBy(['lounge' => $loungeProfile]);
  1037.         $loungeImportantDescGeneralText = $loungeWebDescription ? $loungeWebDescription->getImportantDescGeneralText() : '';
  1038.         $loungeImportantDescSchedules = $loungeWebDescription ? $loungeWebDescription->getImportantDescSchedules() : '';
  1039.         $loungeImportantDescParking = $loungeWebDescription ? $loungeWebDescription->getImportantDescParking() : '';
  1040.         $loungeSummaryDescription = $loungeWebDescription ? $loungeWebDescription->getImportantDescription() : '';
  1042.         foreach ($reservation as $item) {
  1043.             $newLoungeSimple = new ReservationLoungeSimple();
  1044.             $newLoungeSimple->setDateStart($item->getDateStart());
  1045.             $newLoungeSimple->setDateEnd($item->getDateEnd());
  1046.             $newLoungeSimple->setIdReservation($reqDuplicateQuote['reservationId']);
  1047.             $newLoungeSimple->setPax($item->getPax());
  1048.             $newLoungeSimple->setType($item->getType());
  1049.             $newLoungeSimple->setCreatedAt($hoy);
  1050.             $newLoungeSimple->setCreatedBy($user_id);
  1051.             $newLoungeSimple->setUpdatedAt($hoy);
  1052.             $newLoungeSimple->setUpdatedBy($user_id);
  1053.             $newLoungeSimple->setHourStart($item->getHourStart());
  1054.             $newLoungeSimple->setMinStart($item->getMinStart());
  1055.             $newLoungeSimple->setHourEnd($item->getHourEnd());
  1056.             $newLoungeSimple->setMinEnd($item->getMinEnd());
  1057.             $newLoungeSimple->setRankQuote($newRankId);
  1058.             $newLoungeSimple->setIva($item->getIva());
  1059.             $newLoungeSimple->setOpIva($item->getOpIva());
  1060.             $newLoungeSimple->setIdLounge($newLounge->getId());
  1061.             $newLoungeSimple->setLoungename($newLounge->getName());
  1062.             //            $newLoungeSimple->setLoungeDescription($item->getLoungeDescription());
  1063.             $newLoungeSimple->setImportantDescription($loungeSummaryDescription);
  1064.             $newLoungeSimple->setImportantDescGeneralText($loungeImportantDescGeneralText);
  1065.             $newLoungeSimple->setImportantDescSchedules($loungeImportantDescSchedules);
  1066.             $newLoungeSimple->setImportantDescParking($loungeImportantDescParking);
  1067.             $newLoungeSimple->setLanguage($item->getLanguage());
  1068.             $newLoungeSimple->setSageArticle($item->getSageArticle());
  1069.             $newLoungeSimple->setSentToSage($item->isSentToSage());
  1070.             $newLoungeSimple->setSageIva($item->getSageIva());
  1072.             if (!empty($reqDuplicateQuote['salaPrice'])) {
  1073.                 $newLoungeSimple->setServicePrice($reqDuplicateQuote['salaPrice']);
  1074.             } else {
  1075.                 $newLoungeSimple->setServicePrice($item->getServicePrice());
  1076.             }
  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.             //Se llama al servicio para crear la entrada en la agenda
  1091.             $agenda = $this->agendaService->createAgendaFromSource(
  1092.                 $newLoungeSimple->getIdReservation(),
  1093.                 'SALAS A UTILIZAR',
  1094.                 null,
  1095.                 null,
  1096.                 $newLoungeSimple->getDateStart(),
  1097.                 $newLoungeSimple->getDateEnd(),
  1098.                 $newLoungeSimple->getLoungename(),
  1099.                 $newLoungeSimple->getId(),
  1100.                 'ReservationLoungeSimple',
  1101.                 $newLoungeSimple->getUpdatedBy()
  1102.             );
  1104.             // Se debe agregar el servicio de limpieza por cada sala que se agregue
  1105.             $resLoungeSimple = $newLoungeSimple;
  1106.             $service = new ReservationService();
  1107.             $service->setReservationId($reqDuplicateQuote['reservationId']);
  1108.             $service->setSupplierId(0);
  1109.             $service->setDateInAt($resLoungeSimple->getDateStart());
  1110.             $service->setDateOutAt($resLoungeSimple->getDateEnd());
  1112.             /* Obtengo usuario logueado */
  1113.             $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1114.             $user_id = $user_logueado->getId();
  1116.             $service->setCreatedId($user_id);
  1117.             $service->setUpdatedId($user_id);
  1118.             $service->setCreatedAt(new \DateTime("now"));
  1119.             $service->setUpdatedAt(new \DateTime("now"));
  1121.             $service->setServiceCatId('21');
  1122.             $service->setServiceCatName('Limpieza');
  1123.             $service->setContcolor('green-300');
  1124.             $service->setName('HORAS ( ' . $resLoungeSimple->getLoungeName() . ' )');
  1125.             $service->setPrice('14');
  1126.             $service->setCurrency('Euro');
  1127.             $service->setUnits('8');
  1128.             $service->setCommission('0');
  1129.             $service->setPax('0');
  1130.             $service->setOver('0');
  1131.             $service->setIva('21');
  1132.             $service->setOpIva('1');
  1133.             $service->setOpCommission('1');
  1134.             $service->setCommission('57.14');
  1135.             $service->setViewInfo(0);
  1136.             $service->setToinvoice(0);
  1137.             $service->setServiceId(0);
  1139. //            $em->persist($service);
  1140. //            $em->flush();
  1141.         }
  1143.         $reserva = $em->getRepository(Reservation::class)->findOneById($reqDuplicateQuote['reservationId']);
  1145.         // Creamos la Snapshot de las salas y servicios del sistema (LOG)
  1146.         $version = $this->venueService->createSnapshot($reserva);
  1148.         return $this->redirectToRoute(
  1149.             'reservations_venues_edit_simple',
  1150.             array(
  1151.                 'id' => $reqDuplicateQuote['reservationId'],
  1152.                 'token' => null,
  1153.                 '_fragment' => 'btn_quotes'
  1154.             )
  1155.         );
  1156.     }
  1159.     /**
  1160.      * @Route("/loghistoric/{id}", name="reservations_log_historic")
  1161.      * Log del historico de la cotizacion de la reserva id
  1162.      */
  1163.     public function logHistoricQuoteAction($id, EntityManagerInterface $em, Request $request){
  1164.         $reservaLogs = $em->getRepository(ReservationLoungeSimpleServiceLog::class)->findByReservaId($id);
  1166.         return $this->render(
  1167.             'MDS/VenuesBundle/reservations/list-reservations-log-historic.html.twig',
  1168.             array(
  1169.                 'id' => $id,
  1170.                 'reservaLogs' => $reservaLogs,
  1171.             )
  1172.         );
  1173.     }
  1175.     /**
  1176.      * @Route("/logrecover/{reservationId}/{versionId}", name="reservations_log_recover")
  1177.      * Recuperar desde Log de historico una versión de una reserva. Se eliminaran salas y servicios del expediente no facturados
  1178.      */
  1179.     public function logRecoverQuoteAction($reservationId, $versionId, EntityManagerInterface $em, Request $request){
  1180.         $reservaLogs = $em->getRepository(ReservationLoungeSimpleServiceLog::class)->findBy(array('reservaId' => $reservationId, 'version' => $versionId));
  1181.         $reservationsLounges = $em->getRepository(ReservationLoungeSimple::class)->findBy(array('idReservation' => $reservationId));
  1182.         $reservationsLoungesInvoiced = $em->getRepository(ReservationInvoiceItems::class)->findBy(array('reservationId' => $reservationId, 'itemType' => 'LOUNGE'));
  1183.         $reservationsServices = $em->getRepository(ReservationService::class)->findBy(array('reservationId' => $reservationId));
  1184.         $reservationsServicesInvoiced = $em->getRepository(ReservationInvoiceItems::class)->findBy(array('reservationId' => $reservationId, 'itemType' => 'SERVICE'));
  1185.         $sageIva = $em->getRepository(SageVatRates::class)->findOneBySageCode('03');
  1187.         /* Obtengo usuario logueado */
  1188.         $user = $this->get('security.token_storage')->getToken()->getUser();
  1190.         // 1. Obtener los IDs de los items que SÍ están facturados
  1191.         $invoicedLoungeIds = [];
  1192.         foreach ($reservationsLoungesInvoiced as $invoiceLounge) {
  1193.             $invoicedLoungeIds[] = $invoiceLounge->getLngControlId();
  1194.         }
  1196.         $invoicedServiceIds = [];
  1197.         foreach ($reservationsServicesInvoiced as $invoiceService) {
  1198.             $invoicedServiceIds[] = $invoiceService->getSrvControlId();
  1199.         }
  1201.         // 2. Eliminar los Lounges (Salas) que NO están facturados
  1202.         foreach ($reservationsLounges as $lounge) {
  1203.             if (!in_array($lounge->getId(), $invoicedLoungeIds)) {
  1204.                 $em->remove($lounge);
  1205.             }
  1206.         }
  1208.         // 2.1 Eliminar los Servicios que NO están facturados
  1209.         foreach ($reservationsServices as $service) {
  1210.             if (!in_array($service->getId(), $invoicedServiceIds)) {
  1211.                 $em->remove($service);
  1212.             }
  1213.         }
  1215.         // 3. Generar las nuevas entidades a partir del Log
  1216.         foreach ($reservaLogs as $log) {
  1217.             if ($log->getItemType() === 'lounge') {
  1218.                 $newLounge = new ReservationLoungeSimple();
  1219.                 $newLounge->setIdReservation($log->getReservaId());
  1220.                 $newLounge->setIdLounge($log->getIdLounge());
  1221.                 $newLounge->setLoungeName($log->getItemName());
  1222.                 $newLounge->setDateStart($log->getDateStart());
  1223.                 $newLounge->setDateEnd($log->getDateEnd());
  1224.                 $newLounge->setPax($log->getPax());
  1225.                 $newLounge->setRankQuote($log->getRankQuote());
  1226.                 $newLounge->setServicePrice((string)$log->getPrice());
  1227.                 $newLounge->setSageIva($sageIva);
  1228.                 $newLounge->setCreatedBy($log->getAgentId());
  1229.                 $newLounge->setUpdatedBy($log->getAgentId());
  1231.                 // Mapear el desglose de horas para la sala
  1232.                 if ($log->getDateStart()) {
  1233.                     $newLounge->setHourStart($log->getDateStart()->format('H'));
  1234.                     $newLounge->setMinStart($log->getDateStart()->format('i'));
  1235.                 }
  1237.                 if ($log->getDateEnd()) {
  1238.                     $newLounge->setHourEnd($log->getDateEnd()->format('H'));
  1239.                     $newLounge->setMinEnd($log->getDateEnd()->format('i'));
  1240.                 }
  1242.                 $loungeProfile = $em->getRepository(ReservationLoungeDetails::class)->findOneById($log->getIdLounge());
  1244.                 $idioma = 1;
  1246.                 // Descripciones web por sala/idioma con fallbacks
  1247.                 $loungeWebDescriptionRepo = $em->getRepository(ReservationLoungeWebDescription::class);
  1248.                 $loungeWebDescription = $loungeWebDescriptionRepo->findOneBy([
  1249.                         'lounge' => $loungeProfile,
  1250.                         'language' => $idioma
  1251.                     ]) ?? ($idioma !== 1 ? $loungeWebDescriptionRepo->findOneBy([
  1252.                         'lounge' => $loungeProfile,
  1253.                         'language' => 1
  1254.                     ]) : null) ?? $loungeWebDescriptionRepo->findOneBy(['lounge' => $loungeProfile]);
  1256.                 $loungeSummaryDescription = null;
  1258.                 $loungeImportantDescGeneralText = $loungeWebDescription ? $loungeWebDescription->getImportantDescGeneralText() : '';
  1259.                 $loungeImportantDescSchedules = $loungeWebDescription ? $loungeWebDescription->getImportantDescSchedules() : '';
  1260.                 $loungeImportantDescParking = $loungeWebDescription ? $loungeWebDescription->getImportantDescParking() : '';
  1261.                 $loungeSummaryDescription = $loungeWebDescription ? $loungeWebDescription->getImportantDescription() : '';
  1263.                 $newLounge->setImportantDescription($loungeSummaryDescription ?? '');
  1264.                 $newLounge->setImportantDescGeneralText($loungeImportantDescGeneralText ?? '');
  1265.                 $newLounge->setImportantDescSchedules($loungeImportantDescSchedules ?? '');
  1266.                 $newLounge->setImportantDescParking($loungeImportantDescParking ?? '');
  1268.                 $em->persist($newLounge);
  1270.             } elseif ($log->getItemType() === 'service') {
  1271.                 $newService = new ReservationService();
  1272.                 $newService->setReservationId($log->getReservaId());
  1273.                 $newService->setServiceId($log->getItemId());
  1274.                 $newService->setName($log->getItemName());
  1275.                 $newService->setPrice((string)$log->getPrice());
  1276.                 $newService->setPax((string)$log->getPax());
  1277.                 $newService->setDateInAt($log->getDateStart());
  1278.                 $newService->setDateOutAt($log->getDateEnd());
  1280.                 // Mapeo específico de servicios
  1281.                 $newService->setUnits($log->getUnits() ?? '1');
  1282.                 $newService->setOpCommission($log->getOpCommission());
  1283.                 $newService->setCommission($log->getCommission() ?? '0');
  1284.                 $newService->setOver($log->getPriceOver());
  1285.                 $newService->setToinvoice($log->getToinvoice());
  1286.                 $newService->setViewInfo($log->getViewInfo() ?? false);
  1287.                 $newService->setServiceCatId($log->getServiceCatId());
  1288.                 $newService->setServiceCatName($log->getServiceCatName());
  1289.                 $newService->setCreatedId($user->getId());
  1290.                 $newService->setUpdatedId($user->getId());
  1291.                 $newService->setSageIva($sageIva);
  1292.                 $newService->setIva(21);
  1294.                 if ($log->getDateStart()) {
  1295.                     $newService->setHour($log->getDateStart()->format('H:i'));
  1296.                 }
  1298.                 // VALORES POR DEFECTO REQUERIDOS
  1299.                 $newService->setSupplierId(0);
  1300.                 $newService->setContcolor('#000000');
  1302.                 $em->persist($newService);
  1303.             }
  1304.         }
  1306.         // 4. Ejecutar todas las eliminaciones e inserciones en la BBDD
  1307.         $em->flush();
  1309.         return $this->redirectToRoute(
  1310.             'reservations_venues_edit_simple',
  1311.             array(
  1312.                 'id' => $reservationId,
  1313.                 'token' => null,
  1314.                 '_fragment' => 'btn_quotes'
  1315.             )
  1316.         );
  1317.     }
  1320.     /**
  1321.      * @Route("/productfileavlist/{id}",  name="reservations_list_multiple_productfile_av")
  1322.      * Listar productos de Av para agregar en el servicio id
  1323.      */
  1324.     public function listMultipleProductAvAction( $id, Request $request){
  1325.         $em = $this->getDoctrine()->getManager();
  1327.         $parameters = [];
  1328.         $dql = 'SELECT i
  1329.                 FROM AvexpressBundle:AveProduct i
  1330.                 ORDER BY i.name ASC';
  1331.         $query = $em->createQuery($dql)->setParameters($parameters);
  1332.         $avs = $query->getResult();
  1334.         $dql = 'SELECT i
  1335.                 FROM AvexpressBundle:AvePackageTemplate i
  1336.                 ORDER BY i.name ASC';
  1337.         $query = $em->createQuery($dql)->setParameters($parameters);
  1338.         $avsPack = $query->getResult();
  1340.         $data_av = [];
  1342.         foreach ($avsPack as $item) {
  1343.             $productNames = [];
  1345.             $parameters = ['packId' => $item->getId()];
  1346.             $dql = 'SELECT i
  1347.                 FROM AvexpressBundle:AvePackageTemplateItems i
  1348.                 WHERE i.packId = :packId
  1349.                 ORDER BY i.rankAvPack ASC';
  1350.             $query = $em->createQuery($dql)->setParameters($parameters);
  1351.             $avsPackProducts = $query->getResult();
  1353.             foreach ($avsPackProducts as $product) { $productNames[] = $product->getProductName(); }
  1355.             $packageName = $item->getName();
  1357.             if (!empty($productNames)) { $packageName .= ' (' . implode(', ', $productNames) . ')'; }
  1359.             $data_av[] = array(
  1360.                 'id'    => $item->getId(),
  1361.                 'name'  => $packageName,
  1362.                 'type'  => 'Paquete',
  1363.                 'price' => $item->getPricePackage(),
  1364.             );
  1365.         }
  1367.         foreach($avs as $av){
  1368.             $data_av[] = array(
  1369.                 'id' => $av->getId(),
  1370.                 'name' => $av->getName(),
  1371.                 'type' => $av->getType(),
  1372.                 'price' => $av->getPrice(),
  1373.             );
  1374.         }
  1376.         $resService = $em->getRepository(ReservationService::class)->findOneById($id);
  1378.         return $this->render('MDS/VenuesBundle/reservations/add-services-avs.html.twig',
  1379.             array(
  1380.                 'id' => $id,
  1381.                 'idRes' => empty($resService) ? 0 : $resService->getReservationId(),
  1382.                 'avs' => $data_av,
  1383.             ));
  1384.     }
  1386.     /**
  1387.      * @Route("/productfileavadd/{id}",  name="reservations_add_multiple_productfile_av")
  1388.      * Agregar productos de Av para agregar en el servicio id
  1389.      */
  1390.     public function addMultipleProductAvAction( $id, Request $request){
  1392.         $em = $this->getDoctrine()->getManager();
  1393.         $resService = $em->getRepository(ReservationService::class)->findOneById($id);
  1395.         $prodSelected = $request->request->get('details');
  1397.         $serviceName = '';
  1398.         $servicePrice = 0;
  1400.         foreach ($prodSelected as $item){
  1402.             if(empty($serviceName)){
  1403.                 $serviceName .= $item['name'];
  1404.             } else {
  1405.                 $serviceName .= ' + '. $item['name'];
  1406.             }
  1407.             $servicePrice += $item['total_price'];
  1408.         }
  1410.         $resService->setName($serviceName);
  1411.         $resService->setPrice($servicePrice);
  1412.         $resService->setToInvoice(1);
  1413.         $resService->setOpIva(1);
  1414.         $resService->setIva(21);
  1416.         try {
  1417.             $em->persist($resService);
  1418.             $em->flush();
  1419.             $event = 'The Reservation has been updated.';
  1420.             $successMessage = $this->translator->trans($event);
  1421.             $this->addFlash('mensajereservation', $successMessage);
  1422.         } catch (\Exception $e) {
  1423.             $event = 'An error occurred: ' . $e->getMessage();
  1424.             $errorMessage = $this->translator->trans($event);
  1425.             $this->addFlash('mensajereservationerror', $errorMessage);
  1426.         }
  1428.         return $this->redirectToRoute('reservations_venues_edit_simple', [
  1429.             'id' => $resService->getReservationId(),
  1430.             'token' => null,
  1431.             '_fragment' => 'btn_srv'
  1432.         ]);
  1434.     }
  1437.     /**
  1438.      * @Route("/reschedule/{reservationId}/{newDate}", name="reservations_reschedule", methods={"POST"})
  1439.      * Reprogramar todas las fechas del evento, incluido reservations, reservationLoungeSimple y reservationService
  1440.      */
  1441.     public function rescheduleQuoteAction($reservationId, $newDate, EntityManagerInterface $em, Request $request)
  1442.     {
  1443.         try {
  1444.             $reservation = $em->getRepository(Reservation::class)->find($reservationId);
  1446.             if (!$reservation) {
  1447.                 return new JsonResponse(['status' => 'error', 'message' => 'Reserva no encontrada.'], 404);
  1448.             }
  1450.             $oldStartDate = $reservation->getDateStart();
  1451.             if (!$oldStartDate) {
  1452.                 return new JsonResponse(['status' => 'error', 'message' => 'La reserva actual no tiene una fecha de inicio configurada.'], 400);
  1453.             }
  1455.             // Establecemos las horas a las 00:00:00 para calcular los días exactos sin afectar los husos horarios
  1456.             $oldStartMidnight = clone $oldStartDate;
  1457.             $oldStartMidnight->setTime(0, 0, 0);
  1459.             $newStartMidnight = new \DateTime($newDate);
  1460.             $newStartMidnight->setTime(0, 0, 0);
  1462.             // Calculamos la diferencia en días
  1463.             $interval = $oldStartMidnight->diff($newStartMidnight);
  1464.             $daysDiff = $interval->days;
  1465.             $invert = $interval->invert; // 1 si la fecha nueva es pasada, 0 si es futura
  1467.             if ($daysDiff === 0) {
  1468.                 return new JsonResponse(['status' => 'error', 'message' => 'La fecha seleccionada es igual a la actual.'], 400);
  1469.             }
  1471.             // Función anónima para aplicar la suma/resta de días a una fecha conservando su hora original
  1472.             $applyInterval = function(?\DateTime $date) use ($daysDiff, $invert) {
  1473.                 if (!$date) return null;
  1474.                 $clonedDate = clone $date;
  1475.                 $intervalStr = 'P' . $daysDiff . 'D'; // P[N]D = Period N Days
  1477.                 if ($invert) {
  1478.                     $clonedDate->sub(new \DateInterval($intervalStr));
  1479.                 } else {
  1480.                     $clonedDate->add(new \DateInterval($intervalStr));
  1481.                 }
  1482.                 return $clonedDate;
  1483.             };
  1485.             // 1. Reprogramar la Reserva
  1486.             // Asignamos la nueva fecha (preservando la hora del inicio antiguo, si tuviera alguna)
  1487.             $reservation->setDateStart($applyInterval($reservation->getDateStart()));
  1488.             if ($reservation->getDateEnd()) {
  1489.                 $reservation->setDateEnd($applyInterval($reservation->getDateEnd()));
  1490.             }
  1492.             // 2. Reprogramar las Salas (ReservationLoungeSimple)
  1493.             $lounges = $em->getRepository(ReservationLoungeSimple::class)->findBy(['idReservation' => $reservationId]);
  1494.             foreach ($lounges as $lounge) {
  1495.                 $lounge->setDateStart($applyInterval($lounge->getDateStart()));
  1496.                 $lounge->setDateEnd($applyInterval($lounge->getDateEnd()));
  1497.             }
  1499.             // 3. Reprogramar los Servicios (ReservationService)
  1500.             $services = $em->getRepository(ReservationService::class)->findBy(['reservationId' => $reservationId]);
  1501.             foreach ($services as $service) {
  1502.                 $service->setDateInAt($applyInterval($service->getDateInAt()));
  1503.                 $service->setDateOutAt($applyInterval($service->getDateOutAt()));
  1504.             }
  1506.             $em->flush();
  1508.             // Creamos la Snapshot de las salas y servicios del sistema (LOG)
  1509.             $version = $this->venueService->createSnapshot($reservation);
  1511.             return new JsonResponse([
  1512.                 'status' => 'success',
  1513.                 'message' => 'Las fechas del evento han sido reprogramadas correctamente.'
  1514.             ]);
  1516.         } catch (\Exception $e) {
  1517.             return new JsonResponse([
  1518.                 'status' => 'error',
  1519.                 'message' => 'Ocurrió un error en el servidor: ' . $e->getMessage()
  1520.             ], 500);
  1521.         }
  1522.     }
  1525.     /**
  1526.      * @Route("/registerFormGpWeb/{token}", name="registerformgpweb", defaults={"token"=null})
  1527.      * Crear una reserva con la información que llega desde la web
  1528.      * Crear la sala segun los datos ingresados
  1529.      * Generar un modelo de correo electronico para enviar la propuesta de cotización al cliente
  1530.      */
  1531.     public function registerFormWebApiAction($token, Request $request, EntityManagerInterface $em)
  1532.     {
  1533.         // ==========================================
  1534.         // 0. VALIDACIONES DE USUARIO Y RESERVA
  1535.         // ==========================================
  1536.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1537.         if (!($user_logueado)){
  1538.             return $this->redirectToRoute('login');
  1539.         } else {
  1540.             $user_id = $user_logueado->getId();
  1541.         }
  1543.         $reservaPrevia = $em->getRepository(Reservation::class)->findOneByToken($token);
  1544.         if (!empty($reservaPrevia)){
  1545.             // Ya se ha creado la reserva previamente
  1546.             return $this->redirectToRoute('reservations_venues_edit_simple', array(
  1547.                 'id' => $reservaPrevia->getId(),
  1548.                 'token' => null,
  1549.                 '_fragment' => null
  1550.             ));
  1551.         }
  1553.         // ==========================================
  1554.         // 1. DESCIFRAR Y VALIDAR EL TOKEN
  1555.         // ==========================================
  1556.         if (empty($token)) {
  1557.             $this->addFlash('mensajereservationerror', 'No se ha proporcionado ningún token en la URL.');
  1558.             // Ajusta la ruta de retorno en caso de error
  1559.             return $this->redirectToRoute('reservations_greenpatio_index');
  1560.         }
  1562.         $base64Key = 'x4BMAcZUEQLNWgLB4NRHprTyySUZtcs4F1FCn9EKwJ4=';
  1563.         $key = base64_decode($base64Key);
  1565.         $parts = explode('.', $token);
  1566.         if (count($parts) !== 4 || $parts[0] !== 'v1') {
  1567.             $this->addFlash('mensajereservationerror', 'El formato del token no es válido.');
  1568.             return $this->redirectToRoute('reservations_greenpatio_index');
  1569.         }
  1571.         // Función auxiliar para decodificar Base64 URL-safe
  1572.         $base64UrlDecode = function($data) {
  1573.             $remainder = strlen($data) % 4;
  1574.             if ($remainder) {
  1575.                 $data .= str_repeat('=', 4 - $remainder);
  1576.             }
  1577.             return base64_decode(strtr($data, '-_', '+/'));
  1578.         };
  1580.         $iv         = $base64UrlDecode($parts[1]);
  1581.         $tag        = $base64UrlDecode($parts[2]);
  1582.         $ciphertext = $base64UrlDecode($parts[3]);
  1583.         $aad        = 'greenpatio-register-v1';
  1585.         // Descifrar usando AES-256-GCM
  1586.         $decrypted = openssl_decrypt(
  1587.             $ciphertext,
  1588.             'aes-256-gcm',
  1589.             $key,
  1590.             OPENSSL_RAW_DATA,
  1591.             $iv,
  1592.             $tag,
  1593.             $aad
  1594.         );
  1596.         if ($decrypted === false) {
  1597.             $this->addFlash('mensajereservationerror', 'No se pudo descifrar la información del token.');
  1598.             return $this->redirectToRoute('reservations_greenpatio_index');
  1599.         }
  1601.         $data = json_decode($decrypted, true);
  1603.         if (json_last_error() !== JSON_ERROR_NONE) {
  1604.             $this->addFlash('mensajereservationerror', 'El token no contiene datos válidos.');
  1605.             return $this->redirectToRoute('reservations_greenpatio_index');
  1606.         }
  1608.         // Opcional: Validar fecha de expiración si viene en el token
  1609.         if (isset($data['expiresAt']) && time() > $data['expiresAt']) {
  1610.             $this->addFlash('mensajereservationerror', 'El enlace de reserva ha expirado.');
  1611.             return $this->redirectToRoute('reservations_greenpatio_index');
  1612.         }
  1614.         // ==========================================
  1615.         // 2. EXTRAER LAS VARIABLES DEL TOKEN
  1616.         // ==========================================
  1617.         $yourName         = $data['name'] ?? '';
  1618.         $yourPhone        = $data['phone'] ?? '';
  1619.         $yourEmail        = $data['email'] ?? '';
  1620.         $yourReferral     = $data['referral'] ?? '';
  1621.         $eventDateString  = $data['eventDate'] ?? 'now';
  1622.         $yourEventDate    = \DateTime::createFromFormat('d/m/Y', trim($eventDateString));
  1623.         $yourAttendees    = $data['attendees'] ?? null;
  1624.         $eventSpace       = $data['eventSpace'] ?? '';
  1625.         $yourEventDetails = $data['eventDetails'] ?? '';
  1627.         // ==========================================
  1628.         // 3. CREAMOS LA RESERVA
  1629.         // ==========================================
  1630.         $hoy = new \DateTime("now", NULL);
  1631.         $reserva = new Reservation();
  1632.         $reserva->setTitle('Reserva ingresada en la web para el día: '. $yourEventDate->format('d/m/Y'));
  1633.         $reserva->setClient(null);
  1634.         $reserva->setCreatedAt($hoy);
  1635.         $reserva->setPriority(1);
  1636. //        $reserva->setDateStart(new \DateTime('2078-01-01'));
  1637.         $reserva->setDateStart($yourEventDate);
  1638. //        $reserva->setDateEnd(new \DateTime('2000-01-01'));
  1639.         $reserva->setDateEnd($yourEventDate);
  1640.         $reserva->setCreatedBy($user_id);
  1641.         $reserva->setSupplier(4765);        // Higo&Trigo
  1642.         $reserva->setStatus('Iniciado');
  1643.         $reserva->setUpdatedAt($hoy);
  1644.         $reserva->setUpdatedBy($user_id);
  1645.         $reserva->setDaysBlock(7);
  1646.         if (!empty($yourAttendees) and is_numeric($yourAttendees)){ $reserva->setPax($yourAttendees); } else { $reserva->setPax(null); }
  1647.         $reserva->setAccessKey(null);
  1648.         $reserva->setClientContact(null);
  1649.         $reserva->setContactUnregistered($yourEmail);       // Desde la web es requerido
  1650.         $reserva->setDays(null);
  1651.         $reserva->setContract(null);
  1652.         if (!empty($yourName)){ $reserva->setNameContactUnregistered($yourName); } else { $reserva->setNameContactUnregistered(null); }
  1653.         if (!empty($yourPhone)){ $reserva->setPhoneContactUnregistered($yourPhone); } else { $reserva->setPhoneContactUnregistered(null); }
  1654.         $reserva->setToken($token);
  1655.         $reserva->setComAvGp(null);
  1656.         $reserva->setComHtGp(null);
  1657.         $reserva->setInfoFormWeb($yourEmail .' || '. $yourReferral .' || '. $yourEventDate->format('d/m/Y') .' || '. $yourName .' || '. $yourPhone .' || '. $yourAttendees .' || '. $eventSpace);
  1658.         if (!empty($yourEventDetails)){ $reserva->setDescription($yourEventDetails); } else { $reserva->setDescription(null); }
  1660.         // --- Generamos la info del correo electronico y la agregamos a la descripción para que el agente copie y pegue
  1661.         $nombreArray = explode(' ', trim($yourName));
  1662.         $primerNombre = $nombreArray[0];
  1664.         // Definimos las URLs de los enlaces
  1665. //        $urlProposal = "https://cotizacion.greenpatio.es/index.php?token=" . $reserva->getToken();
  1666.         $urlProposal = "https://develup.solutions/cotizacion/?token=" . $reserva->getToken();
  1667.         $urlLegends = "https://drive.google.com/file/d/1_zc43gcvyajig-VRJyNXfe-0E8bhhQGZ/view";
  1668.         $urlCatering = "https://drive.google.com/drive/folders/1ihGR2yGWGgdtJeRsAI5LoUuEqkApAcXU";
  1670.         // Construimos el HTML en la variable $xMail
  1671.         $xMail = <<<HTML
  1672. <div style="font-family: Arial, Helvetica, sans-serif; font-size: 14px; color: #222222; line-height: 1.6;">
  1673.     <p style="margin: 0;">{$yourEmail}</p>
  1674.     <p style="margin: 0; margin-bottom: 20px;">PÁGINA WEB GREEN PATIO - Espacios</p>
  1675.     <p>Hola {$primerNombre}, ¡un placer de saludarte!</p>
  1676.     <p><em>A continuación te dejo el link con las opciones disponibles para la fecha solicitada:</em></p>
  1677.     
  1678.     <p style="padding-left: 40px; margin-bottom: 20px;">
  1679.         <strong><em style="color: #5b9e43; font-size: 16px;">CLICK AQUÍ --&gt;:</em></strong> 
  1680.         <a href="{$urlProposal}" style="color: #1155cc; font-size: 18px; text-decoration: underline;">PROPOSAL</a>
  1681.     </p>
  1682.     
  1683.     <p><strong style="text-decoration: underline;"><em>HACER CLICK para ver los <span style="color: #5b9e43;">"DOSSIERES"</span> de los espacios:</em></strong></p>
  1684.     <ul style="margin-top: 5px; margin-bottom: 20px;">
  1685.         <li><a href="{$urlLegends}" style="color: #1155cc; font-weight: bold; text-decoration: underline;">LEGENDS BY GREEN PATIO</a></li>
  1686.     </ul>
  1687.     
  1688.     <p><strong style="text-decoration: underline;"><em>PROVEEDORES EN EXCLUSIVA:</em></strong></p>
  1689.     <ul style="margin-top: 5px; margin-bottom: 20px;">
  1690.         <li><a href="{$urlCatering}" style="color: #1155cc; font-weight: bold; text-decoration: underline;">Catering Higo &amp; Trigo</a> - Te lo cotizamos desde Green Patio</li>
  1691.         <li><strong>AV EXPRESS</strong> - Te lo cotiza directamente: Salvador Guerrero: <a href="tel:620956367" style="color: #222222; text-decoration: none;">620956367</a> // <a href="mailto:salvador@avexpress.tv" style="color: #222222; text-decoration: none;">salvador@avexpress.tv</a></li>
  1692.     </ul>
  1693.     
  1694.     <p><strong><span style="color: #5b9e43; text-decoration: underline;">IMPORTANTE:</span></strong></p>
  1695.     <ul style="margin-top: 5px; margin-bottom: 25px;">
  1696.         <li>Todas nuestras condiciones, horarios, y demás información están en la parte de <strong><span style="color: #5b9e43;">"IMPORTANTE"</span></strong> en el link enviado (justo debajo del precio de cada sala).</li>
  1697.         <li>Dada la demanda de dicha fecha, en caso de desear bloqueo de la sala, será bloqueo en opción compartida, es decir: para el primer cliente que reserve en firme.</li>
  1698.     </ul>
  1699.     
  1700.     <p>Cualquier cosita no dudes en decirme,</p>
  1701.     <p>Quedo atenta y mil gracias nuevamente!</p>
  1702. </div>
  1703. HTML;
  1705.         $reserva->setMailToClient($xMail);
  1707.         try{
  1708.             $em->persist($reserva);
  1709.             $em->flush();
  1710.             $event = 'The Reservation has been updated.';
  1711.             $successMessage = $this->translator->trans($event);
  1712.             $this->addFlash('mensajereservation', $successMessage);
  1713.         } catch (\Exception $e){
  1714.             $event = 'An error occurred: '.$e->getMessage();
  1715.             $errorMessage = $this->translator->trans($event);
  1716.             $this->addFlash('mensajereservationerror', $errorMessage);
  1717.         }
  1719.         $id = $reserva->getId();
  1721.         // Normalizamos el texto antes del switc para el caso del guión largo
  1722.         $eventSpace = str_replace('–', '-', $eventSpace);
  1724.         switch ($eventSpace) {
  1725.             case 'La Imprenta - Sala Plenaria': $simpleLounge = 2; break;
  1726.             case 'La Imprenta - Invernadero': $simpleLounge = 39; break;
  1727.             case 'La Imprenta - Escenario': $simpleLounge = 40; break;
  1728.             case 'La Imprenta - Sala Cristal': $simpleLounge = 13; break;
  1729.             case "La Imprenta - L'Atelier": $simpleLounge = 14; break;
  1730.             case 'Covarrubias The One - Sala White': $simpleLounge = 24; break;
  1731.             case 'Covarrubias The One - Sala Black': $simpleLounge = 25; break;
  1732.             case 'Sala 25': $simpleLounge = 19; break;
  1733.             case 'Lima Rooms': $simpleLounge = 3; break;
  1734.             case 'Espacio Legends': $simpleLounge = 42; break;
  1735.             default: $simpleLounge = 0; break;
  1736.         }
  1738.         $loungeDetails = $em->getRepository(ReservationLoungeDetails::class)->findOneById($simpleLounge);
  1739.         $loungeId = $loungeDetails->getId();
  1740.         $previusLoungeSimple = null;
  1742.         $anyLoungeSimple = null;
  1743.         $idioma = 1;
  1744.         if($anyLoungeSimple){
  1745.             $idioma = $anyLoungeSimple->getLanguage();
  1746.         }
  1748.         $loungeWebDescription = $em->getRepository(ReservationLoungeWebDescription::class)->findOneBy(array('lounge' => $simpleLounge, 'language' => $idioma));
  1749.         $loungeName = $loungeDetails->getName();
  1750.         $loungeSummaryDescription = null;
  1752.         if (empty($previusLoungeSimple)) {
  1753.             if (empty($loungeSummaryDescription)) { $loungeSummaryDescription = empty($loungeWebDescription) ? null : $loungeWebDescription->getImportantDescription(); }
  1754.             $loungeImportantDescGeneralText = empty($loungeWebDescription) ? null : $loungeWebDescription->getImportantDescGeneralText();
  1755.             $loungeImportantDescSchedules = empty($loungeWebDescription) ? null : $loungeWebDescription->getImportantDescSchedules();
  1756.             $loungeImportantDescParking = empty($loungeWebDescription) ? null : $loungeWebDescription->getImportantDescParking();
  1757.         }
  1759.         $iva = 21;
  1760.         $newRankId = 1;
  1761.         $hourStart = '12'; $minStart = '00'; $hourMinStart = '12:00';
  1762.         $hourEnd = '20'; $minEnd = '00'; $hourMinEnd = '20:00';
  1764.         $dateStart = clone $yourEventDate; [$hour, $minute] = explode(':', $hourMinStart); $dateStart->setTime((int)$hour, (int)$minute);
  1765.         $dateEnd = clone $yourEventDate; [$hour, $minute] = explode(':', $hourMinEnd); $dateEnd->setTime((int)$hour, (int)$minute);
  1767.         $servicePrice = 0;
  1768.         $idReservation = $id;
  1769.         $createdAt = new DateTime('now');
  1770.         $createdBy = $user_id;
  1771.         $updatedAt = new DateTime('now');
  1772.         $updatedBy = $user_id;
  1773.         $pax = empty($yourAttendees) ? 0 : $yourAttendees;
  1775.         $lounge = new ReservationLoungeSimple();
  1776.         $lounge->setIdLounge ($loungeId);
  1777.         $lounge->setHourStart ($hourStart);
  1778.         $lounge->setMinStart ($minStart);
  1779.         $lounge->setHourEnd ($hourEnd);
  1780.         $lounge->setMinEnd ($minEnd);
  1781.         $lounge->setLoungeName ($loungeName);
  1782.         $lounge->setDateStart ($dateStart);
  1783.         $lounge->setDateEnd ($dateEnd);
  1784.         $lounge->setRankQuote(1);
  1785.         $lounge->setIdReservation ($idReservation);
  1786.         $lounge->setIva($iva);
  1787.         $lounge->setOpIva(1);
  1788.         $lounge->setCreatedAt ($createdAt);
  1789.         $lounge->setCreatedBy ($createdBy);
  1790.         $lounge->setUpdatedAt ($updatedAt);
  1791.         $lounge->setUpdatedBy ($updatedBy);
  1792.         $lounge->setPax ($pax);
  1793.         $lounge->setRankQuote($newRankId);
  1794.         $sageVatRate = $em->getRepository(SageVatRates::class)->findOneBy([ 'sageCode' => '03' ]);
  1795.         $lounge->setSageIva($sageVatRate);         // Iva de Sage al 21%
  1796.         $lounge->setImportantDescription($loungeSummaryDescription);
  1797.         $lounge->setImportantDescGeneralText($loungeImportantDescGeneralText);
  1798.         $lounge->setImportantDescSchedules($loungeImportantDescSchedules);
  1799.         $lounge->setImportantDescParking($loungeImportantDescParking);
  1801.         $price = $this->precioTarifario($dateStart, $loungeId, $servicePrice);
  1802.         $lounge->setServicePrice($price);
  1804.         try{
  1805.             $em->persist($lounge);
  1806.             $em->flush();
  1807.             $event = 'The Reservation has been updated.';
  1808.             $successMessage = $this->translator->trans($event);
  1809.             $this->addFlash('mensajereservation', $successMessage);
  1810.         } catch (\Exception $e){
  1811.             $event = 'An error occurred: '.$e->getMessage();
  1812.             $errorMessage = $this->translator->trans($event);
  1813.             $this->addFlash('mensajereservationerror', $errorMessage);
  1814.         }
  1816.         // Agregar el servicio de limpieza
  1817.         $service = new ReservationService();
  1818.         $service->setReservationId($idReservation);
  1819.         $service->setSupplierId(0);
  1820.         $service->setDateInAt($lounge->getDateStart());
  1821.         $service->setDateOutAt($lounge->getDateEnd());
  1822.         $service->setCreatedId($user_id);
  1823.         $service->setUpdatedId($user_id);
  1824.         $service->setCreatedAt(new \DateTime("now"));
  1825.         $service->setUpdatedAt(new \DateTime("now"));
  1826.         $service->setServiceCatId('21');
  1827.         $service->setServiceCatName('Limpieza');
  1828.         $service->setContcolor('green-300');
  1829.         $service->setName('HORAS ( '.$lounge->getLoungeName().' )');
  1830.         $service->setPrice('14');
  1831.         $service->setCurrency('Euro');
  1832.         $service->setUnits('8');
  1833.         $service->setCommission('0');
  1834.         $service->setPax('0');
  1835.         $service->setOver('0');
  1837.         // Busco la reserva para saber si es sucoe o no
  1838.         // $sucoe = $reserva->isSucoe();
  1839.         // Sino es sucoe, cogemos el IVA del 21
  1840.         // if(! $sucoe) {
  1841.         //      $sageVatRate = $em->getRepository(SageVatRates::class)->findOneBy(['sageCode' => '03']);
  1842.         // } else {
  1843.         //      $sageVatRate = $em->getRepository(SageVatRates::class)->findOneBy(['sageCode' => '00']);
  1844.         // }
  1846.         $sageArticle = null;
  1847.         // Si el módulo de Sage está activo, buscamos el artículo. Si no, lo dejamos en null y se mostrará un error en la vista.
  1848.         // if ($this->session->get('_config')['msage']) {
  1849.         //      $sageArticle = $em->getRepository(SageArticle::class)->findOneBy(['vatType' => $sageVatRate, 'name' => $service->getServiceCatName()]);
  1850.         //      Si no se ha encontrado el artículo de Sage.
  1851.         //      if (empty($sageArticle)) {
  1852.         //          $this->addFlash('mensajereservationerror', 'No se ha encontrado el artículo de Sage para el servicio: ' . $service->getServiceCatName() . '. No se ha podido crear el servicio para la sala.');
  1853.         //      }
  1854.         // }
  1856.         // $service->setSageIva($sageVatRate);
  1857.         $service->setOpIva('1');
  1858.         $service->setOpCommission('1');
  1859.         $service->setCommission('57.14');
  1860.         $service->setViewInfo(0);
  1861.         $service->setToinvoice(0);
  1862.         $service->setServiceId(0);
  1864.         // Vincular el artículo de Sage al servicio
  1865.         // $service->setSageArticle($sageArticle);
  1867.         $em->persist($service);
  1868.         $em->flush();
  1870.         // Sincronización con HT
  1871.         if (!empty($reserva)) {
  1872.             if (in_array($reserva->getStatus(), [null, '', 'Confirmed', 'Invoiced', 'Iniciado', 'Cotizado', 'Bloqueo'])) {
  1873. //                if ($reserva->getCateringName() == 'HIGO & TRIGO, S.L.') {
  1874.                     $htFile = $em->getRepository(HtFile::class)->findByReservation($reserva);
  1875.                     if (empty($htFile)) { return $this->redirectToRoute('sinc_gp_ht', array('id' => $id,)); }
  1876. //                }
  1877.             }
  1878.         }
  1880.         // Sincronización con AV
  1881.         if (!empty($reserva)) {
  1882.             if (in_array($reserva->getStatus(), [null, '', 'Confirmed', 'Invoiced', 'Iniciado', 'Cotizado', 'Bloqueo'])) {
  1883.                 $aveFile = $em->getRepository(AveFiles::class)->findByReservation($reserva);
  1884.                 if (empty($aveFile)) { return $this->redirectToRoute('sinc_gp_ave', array('id' => $id,)); }
  1885.             }
  1886.         }
  1888.         return $this->redirectToRoute('reservations_venues_edit_simple', array(
  1889.             'id' => $id,
  1890.             'token' => null,
  1891.             '_fragment' => 'btn_quotes'
  1892.         ));
  1893.     }
  1896.     private function precioPorFecha($date, $loungeId)
  1897.     {
  1899.         return array('price' => 0, );
  1901.         $em = $this->getDoctrine()->getManager();
  1902.         $price0 = null;
  1904.         // Buscamos por año
  1905.         $parameters = array('dateYear' => $date->format('Y'), 'loungeId' => $loungeId, 'priceIsActive' => true, );
  1906.         $dql = 'SELECT i
  1907.                 FROM VenuesBundle:ReservationLoungeProfile i
  1908.                 WHERE  ((i.year1 <= :dateYear and i.year2 >= :dateYear) ) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive';
  1910.         $query = $em->createQuery($dql)->setParameters($parameters);
  1911.         $price1 = $query->getResult();
  1913.         // Buscamos por año y mes
  1914.         $parameters = array('dateYear' => $date->format('Y'), 'month' => true, 'loungeId' => $loungeId, 'priceIsActive' => true, );
  1916.         switch ($date->format('m')) {
  1917.             case '01': //Enero
  1918.                 $dql = 'SELECT i
  1919.                     FROM VenuesBundle:ReservationLoungeProfile i
  1920.                     WHERE (
  1921.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1922.                           AND (i.month1 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1923.                       ';
  1924.                 break;
  1926.             case '02': //Febrero
  1927.                 $dql = 'SELECT i
  1928.                     FROM VenuesBundle:ReservationLoungeProfile i
  1929.                     WHERE (
  1930.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1931.                           AND (i.month2 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1932.                       ';
  1933.                 break;
  1935.             case '03': //Marzo
  1936.                 $dql = 'SELECT i
  1937.                     FROM VenuesBundle:ReservationLoungeProfile i
  1938.                     WHERE (
  1939.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1940.                           AND (i.month3 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1941.                       ';
  1942.                 break;
  1944.             case '04': //Abril
  1945.                 $dql = 'SELECT i
  1946.                     FROM VenuesBundle:ReservationLoungeProfile i
  1947.                     WHERE (
  1948.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1949.                           AND (i.month4 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1950.                       ';
  1951.                 break;
  1953.             case '05': //Mayo
  1954.                 $dql = 'SELECT i
  1955.                     FROM VenuesBundle:ReservationLoungeProfile i
  1956.                     WHERE (
  1957.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1958.                           AND (i.month5 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1959.                       ';
  1960.                 break;
  1962.             case '06': //Junio
  1963.                 $dql = 'SELECT i
  1964.                     FROM VenuesBundle:ReservationLoungeProfile i
  1965.                     WHERE (
  1966.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1967.                           AND (i.month6 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1968.                       ';
  1969.                 break;
  1971.             case '07': //Julio
  1972.                 $dql = 'SELECT i
  1973.                     FROM VenuesBundle:ReservationLoungeProfile i
  1974.                     WHERE (
  1975.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1976.                           AND (i.month7 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1977.                       ';
  1978.                 break;
  1980.             case '08': //Agosto
  1981.                 $dql = 'SELECT i
  1982.                     FROM VenuesBundle:ReservationLoungeProfile i
  1983.                     WHERE (
  1984.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1985.                           AND (i.month8 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1986.                       ';
  1987.                 break;
  1989.             case '09': //Septiembre
  1990.                 $dql = 'SELECT i
  1991.                     FROM VenuesBundle:ReservationLoungeProfile i
  1992.                     WHERE (
  1993.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1994.                           AND (i.month9 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1995.                       ';
  1996.                 break;
  1998.             case '10': //Octubre
  1999.                 $dql = 'SELECT i
  2000.                     FROM VenuesBundle:ReservationLoungeProfile i
  2001.                     WHERE (
  2002.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2003.                           AND (i.month10 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2004.                       ';
  2005.                 break;
  2007.             case '11': //Noviembre
  2008.                 $dql = 'SELECT i
  2009.                     FROM VenuesBundle:ReservationLoungeProfile i
  2010.                     WHERE (
  2011.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2012.                           AND (i.month11 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2013.                       ';
  2014.                 break;
  2016.             case '12': //Diciembre
  2017.                 $dql = 'SELECT i
  2018.                     FROM VenuesBundle:ReservationLoungeProfile i
  2019.                     WHERE (
  2020.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2021.                           AND (i.month12 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2022.                       ';
  2023.                 break;
  2025.             default:
  2026.                 break;
  2027.         }
  2029.         $query = $em->createQuery($dql)->setParameters($parameters);
  2030.         $price2 = $query->getResult();
  2032.         // Buscamos por año, mes y dia de la semana
  2033.         $parameters = array('dateYear' => $date->format('Y'), 'month' => true, 'day' => true, 'loungeId' => $loungeId, 'priceIsActive' => true, );
  2035.         switch ($date->format('m')) {
  2036.             case '01': //Enero
  2037.                 switch ($date->format('l')) {
  2038.                     case 'Monday': //Lunes
  2039.                         $dql = 'SELECT i
  2040.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2041.                                     WHERE (
  2042.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2043.                                           AND (i.month1 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2044.                                       ';
  2045.                         break;
  2047.                     case 'Tuesday': //Martes
  2048.                         $dql = 'SELECT i
  2049.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2050.                                     WHERE (
  2051.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2052.                                           AND (i.month1 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2053.                                       ';
  2054.                         break;
  2056.                     case 'Wednesday': //Miercoles
  2057.                         $dql = 'SELECT i
  2058.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2059.                                     WHERE (
  2060.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2061.                                           AND (i.month1 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2062.                                       ';
  2063.                         break;
  2065.                     case 'Thursday': //Jueves
  2066.                         $dql = 'SELECT i
  2067.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2068.                                     WHERE (
  2069.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2070.                                           AND (i.month1 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2071.                                       ';
  2072.                         break;
  2074.                     case 'Friday': //Viernes
  2075.                         $dql = 'SELECT i
  2076.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2077.                                     WHERE (
  2078.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2079.                                           AND (i.month1 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2080.                                       ';
  2081.                         break;
  2083.                     case 'Saturday': //Sabado
  2084.                         $dql = 'SELECT i
  2085.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2086.                                     WHERE (
  2087.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2088.                                           AND (i.month1 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2089.                                       ';
  2090.                         break;
  2092.                     case 'Sunday': //Domingo
  2093.                         $dql = 'SELECT i
  2094.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2095.                                     WHERE (
  2096.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2097.                                           AND (i.month1 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2098.                                       ';
  2099.                         break;
  2100.                     default:
  2101.                         break;
  2102.                 }
  2103.                 break;
  2105.             case '02': //Febrero
  2107.                 switch ($date->format('l')) {
  2108.                     case 'Monday': //Lunes
  2109.                         $dql = 'SELECT i
  2110.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2111.                                     WHERE (
  2112.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2113.                                           AND (i.month2 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2114.                                       ';
  2115.                         break;
  2117.                     case 'Tuesday': //Martes
  2118.                         $dql = 'SELECT i
  2119.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2120.                                     WHERE (
  2121.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2122.                                           AND (i.month2 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2123.                                       ';
  2124.                         break;
  2126.                     case 'Wednesday': //Miercoles
  2127.                         $dql = 'SELECT i
  2128.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2129.                                     WHERE (
  2130.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2131.                                           AND (i.month2 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2132.                                       ';
  2133.                         break;
  2135.                     case 'Thursday': //Jueves
  2136.                         $dql = 'SELECT i
  2137.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2138.                                     WHERE (
  2139.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2140.                                           AND (i.month2 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2141.                                       ';
  2142.                         break;
  2144.                     case 'Friday': //Viernes
  2145.                         $dql = 'SELECT i
  2146.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2147.                                     WHERE (
  2148.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2149.                                           AND (i.month2 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2150.                                       ';
  2151.                         break;
  2153.                     case 'Saturday': //Sabado
  2154.                         $dql = 'SELECT i
  2155.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2156.                                     WHERE (
  2157.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2158.                                           AND (i.month2 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2159.                                       ';
  2160.                         break;
  2162.                     case 'Sunday': //Domingo
  2163.                         $dql = 'SELECT i
  2164.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2165.                                     WHERE (
  2166.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2167.                                           AND (i.month2 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2168.                                       ';
  2169.                         break;
  2171.                     default:
  2172.                         break;
  2173.                 }
  2175.                 break;
  2177.             case '03': //Marzo
  2179.                 switch ($date->format('l')) {
  2180.                     case 'Monday': //Lunes
  2181.                         $dql = 'SELECT i
  2182.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2183.                                     WHERE (
  2184.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2185.                                           AND (i.month3 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2186.                                       ';
  2187.                         break;
  2189.                     case 'Tuesday': //Martes
  2190.                         $dql = 'SELECT i
  2191.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2192.                                     WHERE (
  2193.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2194.                                           AND (i.month3 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2195.                                       ';
  2196.                         break;
  2198.                     case 'Wednesday': //Miercoles
  2199.                         $dql = 'SELECT i
  2200.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2201.                                     WHERE (
  2202.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2203.                                           AND (i.month3 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2204.                                       ';
  2205.                         break;
  2207.                     case 'Thursday': //Jueves
  2208.                         $dql = 'SELECT i
  2209.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2210.                                     WHERE (
  2211.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2212.                                           AND (i.month3 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2213.                                       ';
  2214.                         break;
  2216.                     case 'Friday': //Viernes
  2217.                         $dql = 'SELECT i
  2218.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2219.                                     WHERE (
  2220.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2221.                                           AND (i.month3 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2222.                                       ';
  2223.                         break;
  2225.                     case 'Saturday': //Sabado
  2226.                         $dql = 'SELECT i
  2227.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2228.                                     WHERE (
  2229.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2230.                                           AND (i.month3 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2231.                                       ';
  2232.                         break;
  2234.                     case 'Sunday': //Domingo
  2235.                         $dql = 'SELECT i
  2236.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2237.                                     WHERE (
  2238.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2239.                                           AND (i.month3 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2240.                                       ';
  2241.                         break;
  2243.                     default:
  2244.                         break;
  2245.                 }
  2247.                 break;
  2249.             case '04': //Abril
  2251.                 switch ($date->format('l')) {
  2252.                     case 'Monday': //Lunes
  2253.                         $dql = 'SELECT i
  2254.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2255.                                     WHERE (
  2256.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2257.                                           AND (i.month4 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2258.                                       ';
  2259.                         break;
  2261.                     case 'Tuesday': //Martes
  2262.                         $dql = 'SELECT i
  2263.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2264.                                     WHERE (
  2265.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2266.                                           AND (i.month4 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2267.                                       ';
  2268.                         break;
  2270.                     case 'Wednesday': //Miercoles
  2271.                         $dql = 'SELECT i
  2272.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2273.                                     WHERE (
  2274.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2275.                                           AND (i.month4 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2276.                                       ';
  2277.                         break;
  2279.                     case 'Thursday': //Jueves
  2280.                         $dql = 'SELECT i
  2281.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2282.                                     WHERE (
  2283.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2284.                                           AND (i.month4 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2285.                                       ';
  2286.                         break;
  2288.                     case 'Friday': //Viernes
  2289.                         $dql = 'SELECT i
  2290.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2291.                                     WHERE (
  2292.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2293.                                           AND (i.month4 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2294.                                       ';
  2295.                         break;
  2297.                     case 'Saturday': //Sabado
  2298.                         $dql = 'SELECT i
  2299.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2300.                                     WHERE (
  2301.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2302.                                           AND (i.month4 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2303.                                       ';
  2304.                         break;
  2306.                     case 'Sunday': //Domingo
  2307.                         $dql = 'SELECT i
  2308.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2309.                                     WHERE (
  2310.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2311.                                           AND (i.month4 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2312.                                       ';
  2313.                         break;
  2315.                     default:
  2316.                         break;
  2317.                 }
  2319.                 break;
  2321.             case '05': //Mayo
  2323.                 switch ($date->format('l')) {
  2324.                     case 'Monday': //Lunes
  2325.                         $dql = 'SELECT i
  2326.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2327.                                     WHERE (
  2328.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2329.                                           AND (i.month5 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2330.                                       ';
  2331.                         break;
  2333.                     case 'Tuesday': //Martes
  2334.                         $dql = 'SELECT i
  2335.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2336.                                     WHERE (
  2337.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2338.                                           AND (i.month5 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2339.                                       ';
  2340.                         break;
  2342.                     case 'Wednesday': //Miercoles
  2343.                         $dql = 'SELECT i
  2344.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2345.                                     WHERE (
  2346.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2347.                                           AND (i.month5 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2348.                                       ';
  2349.                         break;
  2351.                     case 'Thursday': //Jueves
  2352.                         $dql = 'SELECT i
  2353.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2354.                                     WHERE (
  2355.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2356.                                           AND (i.month5 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2357.                                       ';
  2358.                         break;
  2360.                     case 'Friday': //Viernes
  2361.                         $dql = 'SELECT i
  2362.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2363.                                     WHERE (
  2364.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2365.                                           AND (i.month5 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2366.                                       ';
  2367.                         break;
  2369.                     case 'Saturday': //Sabado
  2370.                         $dql = 'SELECT i
  2371.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2372.                                     WHERE (
  2373.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2374.                                           AND (i.month5 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2375.                                       ';
  2376.                         break;
  2378.                     case 'Sunday': //Domingo
  2379.                         $dql = 'SELECT i
  2380.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2381.                                     WHERE (
  2382.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2383.                                           AND (i.month5 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2384.                                       ';
  2385.                         break;
  2387.                     default:
  2388.                         break;
  2389.                 }
  2391.                 break;
  2393.             case '06': //Junio
  2395.                 switch ($date->format('l')) {
  2396.                     case 'Monday': //Lunes
  2397.                         $dql = 'SELECT i
  2398.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2399.                                     WHERE (
  2400.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2401.                                           AND (i.month6 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2402.                                       ';
  2403.                         break;
  2405.                     case 'Tuesday': //Martes
  2406.                         $dql = 'SELECT i
  2407.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2408.                                     WHERE (
  2409.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2410.                                           AND (i.month6 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2411.                                       ';
  2412.                         break;
  2414.                     case 'Wednesday': //Miercoles
  2415.                         $dql = 'SELECT i
  2416.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2417.                                     WHERE (
  2418.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2419.                                           AND (i.month6 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2420.                                       ';
  2421.                         break;
  2423.                     case 'Thursday': //Jueves
  2424.                         $dql = 'SELECT i
  2425.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2426.                                     WHERE (
  2427.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2428.                                           AND (i.month6 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2429.                                       ';
  2430.                         break;
  2432.                     case 'Friday': //Viernes
  2433.                         $dql = 'SELECT i
  2434.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2435.                                     WHERE (
  2436.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2437.                                           AND (i.month6 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2438.                                       ';
  2439.                         break;
  2441.                     case 'Saturday': //Sabado
  2442.                         $dql = 'SELECT i
  2443.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2444.                                     WHERE (
  2445.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2446.                                           AND (i.month6 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2447.                                       ';
  2448.                         break;
  2450.                     case 'Sunday': //Domingo
  2451.                         $dql = 'SELECT i
  2452.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2453.                                     WHERE (
  2454.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2455.                                           AND (i.month6 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2456.                                       ';
  2457.                         break;
  2459.                     default:
  2460.                         break;
  2461.                 }
  2463.                 break;
  2465.             case '07': //Julio
  2467.                 switch ($date->format('l')) {
  2468.                     case 'Monday': //Lunes
  2469.                         $dql = 'SELECT i
  2470.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2471.                                     WHERE (
  2472.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2473.                                           AND (i.month7 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2474.                                       ';
  2475.                         break;
  2477.                     case 'Tuesday': //Martes
  2478.                         $dql = 'SELECT i
  2479.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2480.                                     WHERE (
  2481.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2482.                                           AND (i.month7 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2483.                                       ';
  2484.                         break;
  2486.                     case 'Wednesday': //Miercoles
  2487.                         $dql = 'SELECT i
  2488.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2489.                                     WHERE (
  2490.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2491.                                           AND (i.month7 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2492.                                       ';
  2493.                         break;
  2495.                     case 'Thursday': //Jueves
  2496.                         $dql = 'SELECT i
  2497.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2498.                                     WHERE (
  2499.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2500.                                           AND (i.month7 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2501.                                       ';
  2502.                         break;
  2504.                     case 'Friday': //Viernes
  2505.                         $dql = 'SELECT i
  2506.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2507.                                     WHERE (
  2508.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2509.                                           AND (i.month7 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2510.                                       ';
  2511.                         break;
  2513.                     case 'Saturday': //Sabado
  2514.                         $dql = 'SELECT i
  2515.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2516.                                     WHERE (
  2517.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2518.                                           AND (i.month7 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2519.                                       ';
  2520.                         break;
  2522.                     case 'Sunday': //Domingo
  2523.                         $dql = 'SELECT i
  2524.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2525.                                     WHERE (
  2526.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2527.                                           AND (i.month7 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2528.                                       ';
  2529.                         break;
  2531.                     default:
  2532.                         break;
  2533.                 }
  2535.                 break;
  2537.             case '08': //Agosto
  2539.                 switch ($date->format('l')) {
  2540.                     case 'Monday': //Lunes
  2541.                         $dql = 'SELECT i
  2542.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2543.                                     WHERE (
  2544.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2545.                                           AND (i.month8 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2546.                                       ';
  2547.                         break;
  2549.                     case 'Tuesday': //Martes
  2550.                         $dql = 'SELECT i
  2551.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2552.                                     WHERE (
  2553.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2554.                                           AND (i.month8 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2555.                                       ';
  2556.                         break;
  2558.                     case 'Wednesday': //Miercoles
  2559.                         $dql = 'SELECT i
  2560.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2561.                                     WHERE (
  2562.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2563.                                           AND (i.month8 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2564.                                       ';
  2565.                         break;
  2567.                     case 'Thursday': //Jueves
  2568.                         $dql = 'SELECT i
  2569.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2570.                                     WHERE (
  2571.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2572.                                           AND (i.month8 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2573.                                       ';
  2574.                         break;
  2576.                     case 'Friday': //Viernes
  2577.                         $dql = 'SELECT i
  2578.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2579.                                     WHERE (
  2580.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2581.                                           AND (i.month8 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2582.                                       ';
  2583.                         break;
  2585.                     case 'Saturday': //Sabado
  2586.                         $dql = 'SELECT i
  2587.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2588.                                     WHERE (
  2589.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2590.                                           AND (i.month8 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2591.                                       ';
  2592.                         break;
  2594.                     case 'Sunday': //Domingo
  2595.                         $dql = 'SELECT i
  2596.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2597.                                     WHERE (
  2598.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2599.                                           AND (i.month8 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2600.                                       ';
  2601.                         break;
  2603.                     default:
  2604.                         break;
  2605.                 }
  2607.                 break;
  2609.             case '09': //Septiembre
  2611.                 switch ($date->format('l')) {
  2612.                     case 'Monday': //Lunes
  2613.                         $dql = 'SELECT i
  2614.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2615.                                     WHERE (
  2616.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2617.                                           AND (i.month9 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2618.                                       ';
  2619.                         break;
  2621.                     case 'Tuesday': //Martes
  2622.                         $dql = 'SELECT i
  2623.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2624.                                     WHERE (
  2625.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2626.                                           AND (i.month9 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2627.                                       ';
  2628.                         break;
  2630.                     case 'Wednesday': //Miercoles
  2631.                         $dql = 'SELECT i
  2632.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2633.                                     WHERE (
  2634.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2635.                                           AND (i.month9 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2636.                                       ';
  2637.                         break;
  2639.                     case 'Thursday': //Jueves
  2640.                         $dql = 'SELECT i
  2641.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2642.                                     WHERE (
  2643.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2644.                                           AND (i.month9 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2645.                                       ';
  2646.                         break;
  2648.                     case 'Friday': //Viernes
  2649.                         $dql = 'SELECT i
  2650.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2651.                                     WHERE (
  2652.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2653.                                           AND (i.month9 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2654.                                       ';
  2655.                         break;
  2657.                     case 'Saturday': //Sabado
  2658.                         $dql = 'SELECT i
  2659.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2660.                                     WHERE (
  2661.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2662.                                           AND (i.month9 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2663.                                       ';
  2664.                         break;
  2666.                     case 'Sunday': //Domingo
  2667.                         $dql = 'SELECT i
  2668.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2669.                                     WHERE (
  2670.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2671.                                           AND (i.month9 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2672.                                       ';
  2673.                         break;
  2675.                     default:
  2676.                         break;
  2677.                 }
  2679.                 break;
  2681.             case '10': //Octubre
  2683.                 switch ($date->format('l')) {
  2684.                     case 'Monday': //Lunes
  2685.                         $dql = 'SELECT i
  2686.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2687.                                     WHERE (
  2688.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2689.                                           AND (i.month10 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2690.                                       ';
  2691.                         break;
  2693.                     case 'Tuesday': //Martes
  2694.                         $dql = 'SELECT i
  2695.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2696.                                     WHERE (
  2697.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2698.                                           AND (i.month10 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2699.                                       ';
  2700.                         break;
  2702.                     case 'Wednesday': //Miercoles
  2703.                         $dql = 'SELECT i
  2704.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2705.                                     WHERE (
  2706.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2707.                                           AND (i.month10 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2708.                                       ';
  2709.                         break;
  2711.                     case 'Thursday': //Jueves
  2712.                         $dql = 'SELECT i
  2713.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2714.                                     WHERE (
  2715.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2716.                                           AND (i.month10 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2717.                                       ';
  2718.                         break;
  2720.                     case 'Friday': //Viernes
  2721.                         $dql = 'SELECT i
  2722.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2723.                                     WHERE (
  2724.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2725.                                           AND (i.month10 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2726.                                       ';
  2727.                         break;
  2729.                     case 'Saturday': //Sabado
  2730.                         $dql = 'SELECT i
  2731.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2732.                                     WHERE (
  2733.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2734.                                           AND (i.month10 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2735.                                       ';
  2736.                         break;
  2738.                     case 'Sunday': //Domingo
  2739.                         $dql = 'SELECT i
  2740.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2741.                                     WHERE (
  2742.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2743.                                           AND (i.month10 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2744.                                       ';
  2745.                         break;
  2747.                     default:
  2748.                         break;
  2749.                 }
  2751.                 break;
  2753.             case '11': //Noviembre
  2755.                 switch ($date->format('l')) {
  2756.                     case 'Monday': //Lunes
  2757.                         $dql = 'SELECT i
  2758.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2759.                                     WHERE (
  2760.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2761.                                           AND (i.month11 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2762.                                       ';
  2763.                         break;
  2765.                     case 'Tuesday': //Martes
  2766.                         $dql = 'SELECT i
  2767.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2768.                                     WHERE (
  2769.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2770.                                           AND (i.month11 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2771.                                       ';
  2772.                         break;
  2774.                     case 'Wednesday': //Miercoles
  2775.                         $dql = 'SELECT i
  2776.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2777.                                     WHERE (
  2778.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2779.                                           AND (i.month11 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2780.                                       ';
  2781.                         break;
  2783.                     case 'Thursday': //Jueves
  2784.                         $dql = 'SELECT i
  2785.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2786.                                     WHERE (
  2787.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2788.                                           AND (i.month11 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2789.                                       ';
  2790.                         break;
  2792.                     case 'Friday': //Viernes
  2793.                         $dql = 'SELECT i
  2794.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2795.                                     WHERE (
  2796.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2797.                                           AND (i.month11 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2798.                                       ';
  2799.                         break;
  2801.                     case 'Saturday': //Sabado
  2802.                         $dql = 'SELECT i
  2803.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2804.                                     WHERE (
  2805.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2806.                                           AND (i.month11 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2807.                                       ';
  2808.                         break;
  2810.                     case 'Sunday': //Domingo
  2811.                         $dql = 'SELECT i
  2812.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2813.                                     WHERE (
  2814.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2815.                                           AND (i.month11 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2816.                                       ';
  2817.                         break;
  2819.                     default:
  2820.                         break;
  2821.                 }
  2823.                 break;
  2825.             case '12': //Diciembre
  2827.                 switch ($date->format('l')) {
  2828.                     case 'Monday': //Lunes
  2829.                         $dql = 'SELECT i
  2830.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2831.                                     WHERE (
  2832.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2833.                                           AND (i.month12 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2834.                                       ';
  2835.                         break;
  2837.                     case 'Tuesday': //Martes
  2838.                         $dql = 'SELECT i
  2839.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2840.                                     WHERE (
  2841.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2842.                                           AND (i.month12 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2843.                                       ';
  2844.                         break;
  2846.                     case 'Wednesday': //Miercoles
  2847.                         $dql = 'SELECT i
  2848.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2849.                                     WHERE (
  2850.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2851.                                           AND (i.month12 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2852.                                       ';
  2853.                         break;
  2855.                     case 'Thursday': //Jueves
  2856.                         $dql = 'SELECT i
  2857.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2858.                                     WHERE (
  2859.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2860.                                           AND (i.month12 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2861.                                       ';
  2862.                         break;
  2864.                     case 'Friday': //Viernes
  2865.                         $dql = 'SELECT i
  2866.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2867.                                     WHERE (
  2868.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2869.                                           AND (i.month12 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2870.                                       ';
  2871.                         break;
  2873.                     case 'Saturday': //Sabado
  2874.                         $dql = 'SELECT i
  2875.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2876.                                     WHERE (
  2877.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2878.                                           AND (i.month12 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2879.                                       ';
  2880.                         break;
  2882.                     case 'Sunday': //Domingo
  2883.                         $dql = 'SELECT i
  2884.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2885.                                     WHERE (
  2886.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2887.                                           AND (i.month12 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2888.                                       ';
  2889.                         break;
  2891.                     default:
  2892.                         break;
  2893.                 }
  2895.                 break;
  2897.             default:
  2898.                 break;
  2899.         }
  2901.         $query = $em->createQuery($dql)->setParameters($parameters);
  2902.         $price3 = $query->getResult();
  2904.         foreach ($price3 as $item) {
  2905.             if (empty($price0)) {
  2906.                 $price0 = $item;
  2907.             } else {
  2908.                 //Si los precios coinciden en fechas se tomara el que se haya cargado mas reciente en el sistema
  2909.                 if ($item->getCreatedAt() > $price0->getCreatedAt()) {
  2910.                     $price0 = $item;
  2911.                 }
  2912.             }
  2913.         }
  2914.         if (empty($price0)) {
  2915.             $price = 0;
  2916.         } else {
  2917.             $price = $price0->getPrice();
  2918.         }
  2920.         return array('price' => $price, );
  2921.     }
  2923.     /*
  2924.      * Se busca el precio a Sugerir
  2925.      * $dateStart Fecha
  2926.      * $loungeId Id de  la sala
  2927.      * $servicePrice Preciointroducido por elusuario
  2928.      * */
  2929.     private function precioTarifario($dateStart, $loungeId, $servicePrice)
  2930.     {
  2932.         $em = $this->getDoctrine()->getManager();
  2934.         $dateToFind = clone $dateStart;
  2935.         $dateToFind->setTime(0, 0, 0);
  2936.         $parameters = array(
  2937.             'loungeId' => $loungeId,
  2938.             'typePrice' => 'DIARIA',
  2939.             'dateToFind' => $dateToFind,
  2940.         );
  2941.         $dql = 'SELECT p
  2942.                 FROM VenuesBundle:ReservationLoungeProfile p
  2943.                 WHERE p.typePrice = :typePrice AND p.dateStart = :dateToFind AND p.loungeId = :loungeId
  2944.                 ORDER BY p.levelPrice DESC';
  2946.         $query = $em->createQuery($dql)->setParameters($parameters);
  2947.         $loungesPeriodsDaily = $query->getResult();
  2949.         $priceTarifa = empty($loungesPeriodsDaily) ? 0 : $loungesPeriodsDaily[0]->getPrice();
  2951.         $price = ($servicePrice == 0) ? $priceTarifa : $servicePrice;
  2953.         return $price;
  2954.     }
  2955. }