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

Open in your IDE?
  1. <?php
  3. namespace App\MDS\VenuesBundle\Controller;
  5. use App\Entity\ReservationLoungeWebDescription;
  6. use App\Entity\SageArticle;
  7. use App\Entity\SageVatRates;
  8. use App\Entity\WidgetNotes;
  9. use App\Form\WidgetNotesType;
  10. use App\MDS\VenuesBundle\Entity\Reservation;
  11. use App\MDS\VenuesBundle\Entity\ReservationLoungeSimple;
  12. use App\MDS\VenuesBundle\Entity\ReservationLoungeSimpleServiceLog;
  13. use App\MDS\VenuesBundle\Entity\ReservationService;
  14. use App\MDS\VenuesBundle\Entity\ReservationGpPrice;
  15. use App\MDS\VenuesBundle\Entity\ReservationLounge;
  16. use App\MDS\VenuesBundle\Entity\ReservationLoungeDetails;
  17. use App\MDS\VenuesBundle\Entity\ReservationLoungeProfile;
  18. use App\MDS\VenuesBundle\Entity\ReservationPeriod;
  19. use App\MDS\VenuesBundle\Form\ReservationGpPriceType;
  20. use App\MDS\VenuesBundle\Form\ReservationLoungeDetailsType;
  21. use App\MDS\VenuesBundle\Form\ReservationLoungeProfileType;
  22. use App\MDS\VenuesBundle\Form\ReservationPeriodType;
  23. use App\MDS\VenuesBundle\Form\ReservationType;
  24. use Doctrine\ORM\EntityManagerInterface;
  25. use Symfony\Component\Routing\Annotation\Route;
  26. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  27. use Symfony\Component\HttpFoundation\Request;
  28. use DateTime;
  29. use DatePeriod;
  30. use DateInterval;
  31. use Google_Client;
  32. use Google_Service_Calendar;
  33. use Symfony\Component\HttpFoundation\JsonResponse;
  34. use Symfony\Contracts\Translation\TranslatorInterface;
  35. use App\Service\AgendaService;
  36. use App\Service\VenueService;
  37. use Symfony\Component\HttpFoundation\Session\SessionInterface;
  39. class ReservationsQuoteController extends AbstractController
  40. {
  41.     private Google_Client $googleCalendar;
  42.     private TranslatorInterface $translator;
  43.     private AgendaService $agendaService;
  44.     private SessionInterface $session;
  45.     private VenueService $venueService;
  46.     private \App\Service\ReservationService $reservationService;
  47.     private \App\Service\DocContractService $docContractService;
  49.     public function __construct(
  50.         TranslatorInterface $translator,
  51.         AgendaService $agendaService,
  52.         VenueService $venueService,
  53.         SessionInterface $session,
  54.         \App\Service\ReservationService $reservationService,
  55.         \App\Service\DocContractService $docContractService
  56.     ) {
  57.         $redirect_uri = 'https://' . $_SERVER['HTTP_HOST'] . '/calendar/token';
  58.         $googleCalendar = new Google_Client();
  59.         $googleCalendar->setApplicationName('Google Calendar API PHP Quickstart');
  60.         //campos a extraer de la base de datos User
  61.         $googleCalendar->setClientId('2790497987-57qc3vu4pr7vb0s8phpub2me58pe34lb.apps.googleusercontent.com');
  62.         $googleCalendar->setClientSecret('nj2C7unaTO68DRhyORsyipSj');
  63.         //fin campos user
  64. //        $api_key = "AIzaSyBR84cS1IU2BPvk5V3VnbqdkJESlv440Ac";
  65. //        $client->setDeveloperKey($api_key);
  66.         $googleCalendar->setRedirectUri($redirect_uri);
  67.         $googleCalendar->addScope(Google_Service_Calendar::CALENDAR);
  68.         $guzzleClient = new \GuzzleHttp\Client(array('curl' => array(CURLOPT_SSL_VERIFYPEER => false)));
  69.         $googleCalendar->setHttpClient($guzzleClient);
  70.         $this->googleCalendar = $googleCalendar;
  71.         $this->translator = $translator;
  72.         $this->agendaService = $agendaService;
  73.         $this->venueService = $venueService;
  74.         $this->session = $session;
  75.         $this->reservationService = $reservationService;
  76.         $this->docContractService = $docContractService;
  77.     }
  79.     /**
  80.      * @Route("/createsimplelounge/{id}", name="reservations_venues_create_simple_lounge")
  81.      * Crea un Reservation Lounge Simple en la cotizacion
  82.      */
  83.     public function createSimpleLoungeAction($id, EntityManagerInterface $em, Request $request)
  84.     {
  85.         $simpleLounge = $request->request->all()['reservation_sala'] ?? [];
  87.         // Sala precargada
  88.         $loungeProfile = $em->getRepository(ReservationLoungeDetails::class)
  89.             ->findOneById($simpleLounge['salaPrecargadas'] ?? null);
  91.         if (!$loungeProfile) {
  92.             $this->addFlash('mensajereservationerror', 'La sala seleccionada no existe.');
  93.             return $this->redirectToRoute('reservations_venues_edit', ['id' => $id]);
  94.         }
  96.         $loungeId = $loungeProfile->getId();
  97.         $loungeDetails = $em->getRepository(ReservationLoungeDetails::class)->findOneById($loungeId);
  99.         // Nombre de sala, necesario para Sage
  100.         $loungeName = '';
  101.         if ($loungeDetails && method_exists($loungeDetails, 'getName')) {
  102.             $loungeName = (string) $loungeDetails->getName();
  103.         } elseif (!empty($simpleLounge['loungeName'])) {
  104.             $loungeName = (string) $simpleLounge['loungeName'];
  105.         }
  106.         if ($loungeName === '') {
  107.             $this->addFlash('mensajereservationerror', 'No se pudo determinar el nombre de la sala.');
  108.             return $this->redirectToRoute('reservations_venues_edit', ['id' => $id]);
  109.         }
  111.         // ¿Existe ya esta sala en la misma reserva y rank?
  112.         $previusLoungeSimple = $em->getRepository(ReservationLoungeSimple::class)->findOneBy([
  113.             'idLounge' => $loungeId,
  114.             'idReservation' => $id,
  115.             'rankQuote' => $simpleLounge['idQuote'] ?? null
  116.         ]);
  118.         // Heredar idioma si existe alguna sala previa en la reserva
  119.         $anyLoungeSimple = $em->getRepository(ReservationLoungeSimple::class)->findOneBy([
  120.             'idLounge' => $loungeId,
  121.             'idReservation' => $id
  122.         ]);
  123.         $idioma = $anyLoungeSimple ? (int) $anyLoungeSimple->getLanguage() : 1;
  125.         // Descripciones web por sala/idioma con fallbacks
  126.         $loungeWebDescriptionRepo = $em->getRepository(ReservationLoungeWebDescription::class);
  127.         $loungeWebDescription = $loungeWebDescriptionRepo->findOneBy([
  128.             'lounge' => $loungeProfile,
  129.             'language' => $idioma
  130.         ]) ?? ($idioma !== 1 ? $loungeWebDescriptionRepo->findOneBy([
  131.                 'lounge' => $loungeProfile,
  132.                 'language' => 1
  133.             ]) : null) ?? $loungeWebDescriptionRepo->findOneBy(['lounge' => $loungeProfile]);
  135.         // Summary recibido del formulario (opcional)
  136.         $loungeSummaryDescription = is_array($simpleLounge) && array_key_exists('importantDescription', $simpleLounge)
  137.             ? (string) $simpleLounge['importantDescription']
  138.             : null;
  140.         if (empty($previusLoungeSimple)) {
  141.             // Sin anterior, tiramos de WebDescription si existe
  142.             $loungeImportantDescGeneralText = $loungeWebDescription ? $loungeWebDescription->getImportantDescGeneralText() : '';
  143.             $loungeImportantDescSchedules = $loungeWebDescription ? $loungeWebDescription->getImportantDescSchedules() : '';
  144.             $loungeImportantDescParking = $loungeWebDescription ? $loungeWebDescription->getImportantDescParking() : '';
  145.             if (empty($loungeSummaryDescription)) {
  146.                 $loungeSummaryDescription = $loungeWebDescription ? $loungeWebDescription->getImportantDescription() : '';
  147.             }
  148.         } else {
  149.             // Heredamos de la simple existente
  150.             $loungeSummaryDescription = $previusLoungeSimple->getImportantDescription();
  151.             $loungeImportantDescGeneralText = $previusLoungeSimple->getImportantDescGeneralText();
  152.             $loungeImportantDescSchedules = $previusLoungeSimple->getImportantDescSchedules();
  153.             $loungeImportantDescParking = $previusLoungeSimple->getImportantDescParking();
  154.         }
  156.         // Reserva para calcular sucoe e IVA
  157.         $reservation = $em->getRepository(Reservation::class)->findOneById($id);
  158.         if (!$reservation) {
  159.             $this->addFlash('mensajereservationerror', 'No se encontró la reserva.');
  160.             return $this->redirectToRoute('reservations_venues_edit', ['id' => $id]);
  161.         }
  163.         $sucoe = (bool) $reservation->isSucoe();
  164.         $sageVatRate = $em->getRepository(SageVatRates::class)->findOneBy([
  165.             'sageCode' => $sucoe ? '00' : '03'
  166.         ]);
  168.         // Artículo Sage por nombre de sala + tipo IVA
  169.         $sageArticle = $em->getRepository(SageArticle::class)->findOneBy([
  170.             'vatType' => $sageVatRate,
  171.             'name' => $loungeName
  172.         ]);
  174.         // Solo salta el error si no se ha encontrado el artículo y está el modulo de Sage activo
  175.         if (!$sageArticle && $this->session->get('_config')['msage']) {
  176.             $this->addFlash('mensajereservationerror', 'No se ha encontrado el artículo de Sage para la sala: ' . $loungeName);
  177.             return $this->redirectToRoute('reservations_venues_edit', ['id' => $id]);
  178.         }
  180.         // Normalización horas desde POST
  181.         $hourMinStart = (string) ($simpleLounge['hourStart'] ?? '');
  182.         $hourMinEnd = (string) ($simpleLounge['hourEnd'] ?? '');
  184.         // Normalización horas desde POST usando el servicio
  185.         $startData = $this->reservationService->formatTimeInput((string) ($simpleLounge['hourStart'] ?? ''));
  186.         $endData = $this->reservationService->formatTimeInput((string) ($simpleLounge['hourEnd'] ?? ''));
  188.         $hourStart = $startData['hour'];
  189.         $minStart = $startData['min'];
  190.         $hourEnd = $endData['hour'];
  191.         $minEnd = $endData['min'];
  193.         $dateStart = new \DateTime(($simpleLounge['dateStart'] ?? date('Y-m-d')) . ' ' . $startData['formatted']);
  194.         $dateEnd = new \DateTime(($simpleLounge['dateStart'] ?? date('Y-m-d')) . ' ' . $endData['formatted']); // un solo día
  195.         $servicePrice = (float) ($simpleLounge['servicePrice'] ?? 0);
  196.         $idReservation = (int) $id;
  198.         // Usuario
  199.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  200.         $user_id = $user_logueado ? $user_logueado->getId() : null;
  201.         $createdAt = new \DateTime('now');
  202.         $updatedAt = new \DateTime('now');
  203.         $pax = (int) ($simpleLounge['pax'] ?? 0);
  205.         // Rank de cotización
  206.         $qb = $em->getRepository(ReservationLoungeSimple::class)->createQueryBuilder('r');
  207.         $reservationAll = $qb->where('r.idReservation = :idReservation')
  208.             ->setParameter('idReservation', $id)
  209.             ->orderBy('r.rankQuote', 'ASC')
  210.             ->getQuery()
  211.             ->getResult();
  212.         $newRankId = (!empty($reservationAll)) ? (end($reservationAll)->getRankQuote() + 1) : 1;
  213.         if (!empty($simpleLounge['idQuote']) && is_numeric($simpleLounge['idQuote'])) {
  214.             $newRankId = (int) $simpleLounge['idQuote'];
  215.         }
  217.         // Tipo: Dia de evento (null), Montaje o Desmontaje
  218.         $typeXLounge = empty($simpleLounge['type']) ? null : $simpleLounge['type'];
  220.         // Crear la entidad
  221.         $lounge = new ReservationLoungeSimple();
  222.         $lounge->setIdLounge($loungeId);
  223.         $lounge->setHourStart($hourStart);
  224.         $lounge->setMinStart($minStart);
  225.         $lounge->setHourEnd($hourEnd);
  226.         $lounge->setMinEnd($minEnd);
  227.         $lounge->setLoungeName($loungeName);
  228.         $lounge->setDateStart($dateStart);
  229.         $lounge->setDateEnd($dateEnd);
  230.         $lounge->setRankQuote($newRankId);
  231.         $lounge->setIdReservation($idReservation);
  232.         $lounge->setType($typeXLounge);
  233.         $lounge->setSageIva($sageVatRate);
  234.         $lounge->setOpIva(1);
  235.         $lounge->setCreatedAt($createdAt);
  236.         $lounge->setCreatedBy($user_id);
  237.         $lounge->setUpdatedAt($updatedAt);
  238.         $lounge->setUpdatedBy($user_id);
  239.         $lounge->setPax($pax);
  240.         $lounge->setImportantDescription($loungeSummaryDescription ?? '');
  241.         $lounge->setImportantDescGeneralText($loungeImportantDescGeneralText ?? '');
  242.         $lounge->setImportantDescSchedules($loungeImportantDescSchedules ?? '');
  243.         $lounge->setImportantDescParking($loungeImportantDescParking ?? '');
  245.         // Precio tarifario
  246.         $price = $this->reservationService->getTariffPrice($dateStart, $loungeId, $servicePrice);
  247.         $lounge->setServicePrice($price);
  249.         // Vincular la sala al artículo
  250.         $lounge->setSageArticle($sageArticle);
  252.         try {
  253.             $em->persist($lounge);
  254.             $em->flush();
  255.             $event = 'The Reservation has been updated.';
  256.             $successMessage = $this->translator->trans($event);
  257.             $this->addFlash('mensajereservation', $successMessage);
  258.         } catch (\Exception $e) {
  259.             $event = 'An error occurred: ' . $e->getMessage();
  260.             $errorMessage = $this->translator->trans($event);
  261.             $this->addFlash('mensajereservationerror', $errorMessage);
  262.         }
  264.         //Se llama al servicio para crear la entrada en la agenda y actualizar el Pax de la agenda
  265.         $loungeNameAgenda = empty($typeXLounge) ? $loungeName : $loungeName . ' ( ' . $typeXLounge . ' ) ';
  266.         $agenda = $this->agendaService->createAgendaFromSource($idReservation, 'SALAS A UTILIZAR', null, null, $dateStart, $dateEnd, $loungeNameAgenda, $lounge->getId(), 'ReservationLoungeSimple', $user_id);
  267.         $paxAge = $this->agendaService->calculatePaxForReservation($idReservation);
  268.         $agenda = $this->agendaService->updatePaxLine($idReservation, $paxAge, $user_id);
  270.         // Actualizar fechas de la reserva usando el servicio
  271.         if ($reservation) {
  272.             $this->reservationService->updateReservationDates($reservation);
  273.             //Se llama al servicio para crear la entrada en la agenda de las fechas
  274.             $this->agendaService->updateDatesLine($idReservation, $user_id);
  275.         }
  277.         // Creamos la Snapshot de las salas y servicios del sistema (LOG)
  278.         $version = $this->venueService->createSnapshot($reservation);
  280.         // Sincronizar contratos si está confirmado
  281.         if ($reservation->getStatus() === 'Confirmed') {
  282.             $this->docContractService->autoAssignContracts($reservation, $user_logueado);
  283.         }
  285.         // Redirección para agregar servicio de limpieza
  286.         return $this->redirectToRoute('reservations_white_addservices_cleaning', [
  287.             'resid' => $id,
  288.             'loungesimpleid' => $lounge->getId(),
  289.         ]);
  290.     }
  293.     /**
  294.      * @Route("/api/get-price", name="get_reservations_price_to_view", methods={"GET"})
  295.      */
  296.     public function getPrice(Request $request)
  297.     {
  298.         $loungeId = $request->query->get('sala');
  299.         $dateStart = $request->query->get('date');
  301.         if (!$loungeId || !$dateStart) {
  302.             return new JsonResponse(['error' => 'Missing parameters'], 400);
  303.         }
  305.         try {
  306.             $dateStartObj = new \DateTime($dateStart);
  307.         } catch (\Exception $e) {
  308.             return new JsonResponse(['error' => 'Invalid date'], 400);
  309.         }
  311.         $price = $this->reservationService->getTariffPrice($dateStartObj, $loungeId, 0);
  313.         return new JsonResponse(['price' => $price]);
  314.     }
  317.     /**
  318.      * @Route("/createsimpleloungemondes/{id}", name="reservations_venues_create_simple_lounge_mondes")
  319.      * Se crea un dia de montaje o desmontaje
  320.      */
  321.     public function createSimpleLoungeMonDesAction($id, EntityManagerInterface $em, Request $request)
  322.     {
  323.         $simpleLounge = $request->request->get('reservation_sala_mondes');
  324.         $loungeId = $simpleLounge['idLounge'];
  325.         $loungeDetails = $em->getRepository(ReservationLoungeDetails::class)->findOneById($loungeId);
  326.         $previusLoungeSimple = $em->getRepository(ReservationLoungeSimple::class)->findOneBy(array('idLounge' => $loungeId, 'idReservation' => $id, 'rankQuote' => $simpleLounge['idQuote']));
  327.         $loungeName = $loungeDetails->getName();
  328.         $hourMinStart = $simpleLounge['hourStart'];
  329.         $hourMinEnd = $simpleLounge['hourEnd'];
  331.         // Buscamos la reserva que es para saber si es sucoe o no
  332.         $reservation = $em->getRepository(Reservation::class)->findOneById($id);
  333.         $sucoe = $reservation->isSucoe();
  334.         // Si no es sucoe, cogemos el IVA del 21% y si lo es, entonces el del 0%
  335.         if (!$sucoe) {
  336.             $sageVatRate = $em->getRepository(SageVatRates::class)->findOneBy(['sageCode' => '03']);
  337.         } else {
  338.             $sageVatRate = $em->getRepository(SageVatRates::class)->findOneBy(['sageCode' => '00']);
  339.         }
  340.         $sageArticle = $em->getRepository(SageArticle::class)->findOneBy(['vatType' => $sageVatRate, 'name' => $loungeName]);
  342.         // Si no se ha encontrado el artículo de Sage.
  343.         if (empty($sageArticle)) {
  344.             $this->addFlash('mensajereservationerror', 'No se ha encontrado el artículo de Sage para la sala: ' . $loungeName);
  345.             return $this->redirectToRoute('reservations_venues_edit', array(
  346.                 'id' => $id,
  347.             ));
  348.         }
  350.         if (empty($previusLoungeSimple)) {
  351.             $loungeSummaryDescription = $loungeDetails->getImportantDescription();
  352.             $loungeImportantDescGeneralText = $loungeDetails->getImportantDescGeneralText();
  353.             $loungeImportantDescSchedules = $loungeDetails->getImportantDescSchedules();
  354.             $loungeImportantDescParking = $loungeDetails->getImportantDescParking();
  355.         } else {
  356.             $loungeSummaryDescription = $previusLoungeSimple->getImportantDescription();
  357.             $loungeImportantDescGeneralText = $previusLoungeSimple->getImportantDescGeneralText();
  358.             $loungeImportantDescSchedules = $previusLoungeSimple->getImportantDescSchedules();
  359.             $loungeImportantDescParking = $previusLoungeSimple->getImportantDescParking();
  360.         }
  362.         $qb = $em->getRepository(ReservationLoungeSimple::class)->createQueryBuilder('r');
  363.         $reservationAll = $qb->where('r.idReservation = :idReservation')
  364.             ->setParameter('idReservation', $id)
  365.             ->orderBy('r.rankQuote', 'ASC')
  366.             ->getQuery()
  367.             ->getResult();
  369.         $newRankId = (!empty($reservationAll)) ? (end($reservationAll)->getRankQuote() + 1) : 1;
  370.         if (!empty($simpleLounge['idQuote'])) {
  371.             if (is_numeric($simpleLounge['idQuote'])) {
  372.                 $newRankId = $simpleLounge['idQuote'];
  373.             }
  374.         }
  376.         // Normalización horas desde POST usando el servicio
  377.         $startData = $this->reservationService->formatTimeInput((string) ($simpleLounge['hourStart'] ?? ''));
  378.         $endData = $this->reservationService->formatTimeInput((string) ($simpleLounge['hourEnd'] ?? ''));
  380.         $hourStart = $startData['hour'];
  381.         $minStart = $startData['min'];
  382.         $hourEnd = $endData['hour'];
  383.         $minEnd = $endData['min'];
  385.         $hourMinStart = $startData['formatted'];
  386.         $hourMinEnd = $endData['formatted'];
  388.         $dateStart = new DateTime($simpleLounge['dateStart'] . ' ' . $hourMinStart);
  389.         $dateEnd = new DateTime($simpleLounge['dateStart'] . ' ' . $hourMinEnd);   // Se usa DateStart por que solo hay un dia en el formulario
  390.         $servicePrice = empty($simpleLounge['servicePrice']) ? 0 : $simpleLounge['servicePrice'];
  391.         $idReservation = $id;
  392.         /* Obtengo usuario logueado */
  393.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  394.         $user_id = $user_logueado->getId();
  395.         $createdAt = new DateTime('now');
  396.         $createdBy = $user_id;
  397.         $updatedAt = new DateTime('now');
  398.         $updatedBy = $user_id;
  399.         $lounge = new ReservationLoungeSimple();
  401.         if ($simpleLounge['type'] == 'Montaje') {
  402.             $lounge->setType('Montaje');
  403.         } else {
  404.             $lounge->setType('Desmontaje');
  405.         }
  406.         $pax = 0;
  407.         $lounge->setIdLounge($loungeId);
  408.         $lounge->setHourStart($hourStart);
  409.         $lounge->setMinStart($minStart);
  410.         $lounge->setHourEnd($hourEnd);
  411.         $lounge->setMinEnd($minEnd);
  412.         $lounge->setLoungeName($loungeName);
  413.         $lounge->setDateStart($dateStart);
  414.         $lounge->setDateEnd($dateEnd);
  415.         $lounge->setRankQuote(1);
  416.         $lounge->setSageIva($sageArticle->getVatType());
  417.         $lounge->setOpIva(1);
  418.         $lounge->setIdReservation($idReservation);
  419.         $lounge->setCreatedAt($createdAt);
  420.         $lounge->setCreatedBy($createdBy);
  421.         $lounge->setUpdatedAt($updatedAt);
  422.         $lounge->setUpdatedBy($updatedBy);
  423.         $lounge->setPax($pax);
  424.         $lounge->setRankQuote($newRankId);
  425.         $lounge->setImportantDescription($loungeSummaryDescription);
  426.         $lounge->setImportantDescGeneralText($loungeImportantDescGeneralText);
  427.         $lounge->setImportantDescSchedules($loungeImportantDescSchedules);
  428.         $lounge->setImportantDescParking($loungeImportantDescParking);
  430.         $price = 0; // Se asume 0 según lógica de precioPorFecha original que era inalcanzable
  431.         $servicePrice = ($price == 0) ? $servicePrice : $price;
  432.         $lounge->setServicePrice($servicePrice);
  434.         // Vincular la sala al artículo
  435.         $lounge->setSageArticle($sageArticle);
  437.         try {
  438.             $em->persist($lounge);
  439.             $em->flush();
  440.             $event = 'The Reservation has been updated.';
  441.             $successMessage = $this->translator->trans($event);
  442.             $this->addFlash('mensajereservation', $successMessage);
  444.         } catch (\Exception $e) {
  446.             $event = 'An error occurred: ' . $e->getMessage();
  447.             $errorMessage = $this->translator->trans($event);
  448.             $this->addFlash('mensajereservationerror', $errorMessage);
  449.         }
  451.         $reservax = $em->getRepository(Reservation::class)->findOneById($idReservation);
  453.         if ($reservax) {
  454.             $this->reservationService->updateReservationDates($reservax);
  455.             
  456.             // Sincronizar contratos si está confirmado
  457.             if ($reservax->getStatus() === 'Confirmed') {
  458.                 $this->docContractService->autoAssignContracts($reservax, $user_logueado);
  459.             }
  460.         }
  462.         // FIN: Verificamos si es necesario actualizar las fechas de la reserva
  464.         return $this->redirectToRoute(
  465.             'reservations_venues_edit_simple',
  466.             array(
  467.                 'id' => $id,
  468.                 'token' => null,
  469.                 '_fragment' => 'btn_quotes'
  470.             )
  471.         );
  472.     }
  475.     /**
  476.      * @Route("/duplicateday/{id}/{dayduplicate}/{idRankQuote}", name="reservations_venues_duplicate_day")
  477.      * Duplica un elemento de la cotizacion para el dia siguiente
  478.      */
  479.     public function duplicateDayAction($id, $dayduplicate, $idRankQuote, EntityManagerInterface $em, Request $request)
  480.     {
  481.         $loungeSimples = $em->getRepository(ReservationLoungeSimple::class)->findByIdReservation($id);
  482.         $reservax = $em->getRepository(Reservation::class)->findOneById($id);
  483.         $vatRepo = $em->getRepository(SageVatRates::class);
  485.         /* Usuario logueado */
  486.         $user = $this->get('security.token_storage')->getToken()->getUser();
  487.         $user_id = $user ? $user->getId() : null;
  488.         $createdAt = new \DateTime('now');
  489.         $updatedAt = new \DateTime('now');
  490.         $createdBy = $user_id;
  491.         $updatedBy = $user_id;
  493.         if (!empty($loungeSimples)) {
  494.             foreach ($loungeSimples as $item) {
  495.                 if (
  496.                     $item->getDateStart() &&
  497.                     $item->getDateStart()->format('d-m-Y') == $dayduplicate &&
  498.                     $item->getRankQuote() == $idRankQuote
  499.                 ) {
  500.                     // Se duplica y suma un día (sin mutar el original)
  501.                     $newLoungeSimple = new ReservationLoungeSimple();
  502.                     $newLoungeSimple->setDateStart((clone $item->getDateStart())->modify('+1 day'));
  503.                     $newLoungeSimple->setDateEnd((clone $item->getDateEnd())->modify('+1 day'));
  504.                     $newLoungeSimple->setHourStart($item->getHourStart());
  505.                     $newLoungeSimple->setHourEnd($item->getHourEnd());
  506.                     $newLoungeSimple->setMinStart($item->getMinStart());
  507.                     $newLoungeSimple->setMinEnd($item->getMinEnd());
  508.                     $newLoungeSimple->setIdLounge($item->getIdLounge());
  509.                     $newLoungeSimple->setIdReservation($item->getIdReservation());
  510.                     $newLoungeSimple->setLoungeName($item->getLoungeName());
  511.                     $newLoungeSimple->setPax($item->getPax());
  512.                     $newLoungeSimple->setServicePrice($item->getServicePrice());
  514.                     // IVA (string)
  515.                     $newLoungeSimple->setIva($item->getIva());
  517.                     // Relación SageVatRates (entidad)
  518.                     $vatEntity = method_exists($item, 'getSageIva') ? $item->getSageIva() : null;
  519.                     if (!$vatEntity) {
  520.                         $rawRate = $item->getIva();
  521.                         if ($rawRate !== null && $rawRate !== '') {
  522.                             $rate = (float) $rawRate;
  523.                             // Normaliza si en BD está como fracción (0.21)
  524.                             if ($rate > 1) {
  525.                                 $rate = $rate / 100;
  526.                             }
  527.                             // Ajusta 'rate' si tu campo en SageVatRates tiene otro nombre
  528.                             $vatEntity = $vatRepo->findOneBy(['rate' => $rate]);
  529.                         }
  530.                     }
  531.                     $newLoungeSimple->setSageIva($vatEntity);
  533.                     $newLoungeSimple->setOpIva($item->getOpIva());
  534.                     $newLoungeSimple->setType($item->getType());
  535.                     $newLoungeSimple->setLoungeDescription($item->getLoungeDescription());
  536.                     $newLoungeSimple->setImportantDescription($item->getImportantDescription());
  537.                     $newLoungeSimple->setImportantDescGeneralText($item->getImportantDescGeneralText());
  538.                     $newLoungeSimple->setImportantDescSchedules($item->getImportantDescSchedules());
  539.                     $newLoungeSimple->setImportantDescParking($item->getImportantDescParking());
  540.                     $newLoungeSimple->setRankQuote($idRankQuote);
  541.                     $newLoungeSimple->setCreatedAt($createdAt);
  542.                     $newLoungeSimple->setCreatedBy($createdBy);
  543.                     $newLoungeSimple->setUpdatedAt($updatedAt);
  544.                     $newLoungeSimple->setUpdatedBy($updatedBy);
  546.                     try {
  547.                         $em->persist($newLoungeSimple);
  548.                         $em->flush();
  549.                         $event = 'The Item has been duplicated.';
  550.                         $successMessage = $this->translator->trans($event);
  551.                         $this->addFlash('mensajereservation', $successMessage);
  552.                     } catch (\Exception $e) {
  553.                         $event = 'An error occurred: ' . $e->getMessage();
  554.                         $errorMessage = $this->translator->trans($event);
  555.                         $this->addFlash('mensajereservationerror', $errorMessage);
  556.                     }
  558.                     // Actualiza fechas de la reserva si procede
  559.                     $boolReserva = false;
  560.                     if ($newLoungeSimple->getDateStart() < $reservax->getDateStart()) {
  561.                         $reservax->setDateStart($newLoungeSimple->getDateStart());
  562.                         $boolReserva = true;
  563.                     }
  564.                     if ($reservax->getDateEnd() < $newLoungeSimple->getDateEnd()) {
  565.                         $reservax->setDateEnd($newLoungeSimple->getDateEnd());
  566.                         $boolReserva = true;
  567.                     }
  568.                     if ($boolReserva) {
  569.                         $em->persist($reservax);
  570.                         $em->flush();
  571.                     }
  572.                 }
  573.             }
  574.         } else {
  575.             // Registro antiguo: transformar a los nuevos y luego duplicar
  576.             $loungeOld = $em->getRepository(ReservationLounge::class)->findByIdReservation($id);
  577.             foreach ($loungeOld as $item) {
  578.                 if ($item->getDateStart()->format('Y-m-d') == $item->getDateEnd()->format('Y-m-d')) {
  579.                     // Mismo día → simple
  580.                     $newLoungeSimple = new ReservationLoungeSimple();
  581.                     $newLoungeSimple->setDateStart(clone $item->getDateStart());
  582.                     $newLoungeSimple->setDateEnd(clone $item->getDateEnd());
  583.                     $newLoungeSimple->setHourStart($item->getHourStart());
  584.                     $newLoungeSimple->setHourEnd($item->getHourEnd());
  585.                     $newLoungeSimple->setMinStart($item->getMinStart());
  586.                     $newLoungeSimple->setMinEnd($item->getMinEnd());
  587.                     $newLoungeSimple->setIdLounge($item->getIdLounge());
  588.                     $newLoungeSimple->setIdReservation($item->getIdReservation());
  589.                     $newLoungeSimple->setLoungeName($item->getLoungeName());
  590.                     $newLoungeSimple->setPax($item->getPax());
  591.                     $newLoungeSimple->setServicePrice($item->getServicePrice());
  593.                     // IVA (string)
  594.                     $newLoungeSimple->setIva($item->getIva());
  595.                     // Resolver SageVatRates desde el string
  596.                     $rawRate = $item->getIva();
  597.                     $vatEnt = null;
  598.                     if ($rawRate !== null && $rawRate !== '') {
  599.                         $rate = (float) $rawRate;
  600.                         if ($rate > 1) {
  601.                             $rate = $rate / 100;
  602.                         }
  603.                         $vatEnt = $vatRepo->findOneBy(['rate' => $rate]);
  604.                     }
  605.                     $newLoungeSimple->setSageIva($vatEnt);
  607.                     $newLoungeSimple->setOpIva($item->getOpIva());
  608.                     $newLoungeSimple->setType($item->getType());
  609.                     $newLoungeSimple->setRankQuote($item->getRankQuote());
  610.                     $newLoungeSimple->setLoungeDescription($item->getLoungeDescription());
  611.                     $newLoungeSimple->setImportantDescription($item->getImportantDescription());
  612.                     $newLoungeSimple->setCreatedAt($createdAt);
  613.                     $newLoungeSimple->setCreatedBy($createdBy);
  614.                     $newLoungeSimple->setUpdatedAt($updatedAt);
  615.                     $newLoungeSimple->setUpdatedBy($updatedBy);
  617.                     try {
  618.                         $em->persist($newLoungeSimple);
  619.                         $em->flush();
  620.                         $event = 'The Item has been duplicated.';
  621.                         $successMessage = $this->translator->trans($event);
  622.                         $this->addFlash('mensajereservation', $successMessage);
  623.                     } catch (\Exception $e) {
  624.                         $event = 'An error occurred: ' . $e->getMessage();
  625.                         $errorMessage = $this->translator->trans($event);
  626.                         $this->addFlash('mensajereservationerror', $errorMessage);
  627.                     }
  629.                     // Actualiza fechas de la reserva si procede
  630.                     $boolReserva = false;
  631.                     if ($newLoungeSimple->getDateStart() < $reservax->getDateStart()) {
  632.                         $reservax->setDateStart($newLoungeSimple->getDateStart());
  633.                         $boolReserva = true;
  634.                     }
  635.                     if ($reservax->getDateEnd() < $newLoungeSimple->getDateEnd()) {
  636.                         $reservax->setDateEnd($newLoungeSimple->getDateEnd());
  637.                         $boolReserva = true;
  638.                     }
  639.                     if ($boolReserva) {
  640.                         $em->persist($reservax);
  641.                         $em->flush();
  642.                     }
  643.                 } else {
  644.                     // Varios días → trocear en simples
  645.                     $firstDay = new \DateTime($item->getDateStart()->format('Y-m-d'));
  646.                     $lastDay = new \DateTime($item->getDateEnd()->format('Y-m-d'));
  647.                     $numDays = ($lastDay->diff($firstDay))->days + 1;
  649.                     $actualDay = clone $item->getDateStart();
  650.                     $actualStartDay = clone $item->getDateStart();
  651.                     $actualEndDay = clone $item->getDateEnd();
  653.                     for ($i = 0; $i < $numDays; $i++) {
  654.                         $newLoungeSimple = new ReservationLoungeSimple();
  656.                         if ($i === 0) {
  657.                             // Primer día
  658.                             $newLoungeSimple->setDateStart(clone $actualStartDay);
  659.                             $newLoungeSimple->setDateEnd(new \DateTime($actualStartDay->format('Y-m-d') . ' 23:59'));
  660.                             $newLoungeSimple->setHourStart($item->getHourStart());
  661.                             $newLoungeSimple->setHourEnd('23');
  662.                             $newLoungeSimple->setMinStart($item->getMinStart());
  663.                             $newLoungeSimple->setMinEnd('59');
  664.                         } elseif (($i + 1) === $numDays) {
  665.                             // Último día
  666.                             $newLoungeSimple->setDateStart(new \DateTime($actualEndDay->format('Y-m-d') . ' 00:00'));
  667.                             $newLoungeSimple->setDateEnd(clone $actualEndDay);
  668.                             $newLoungeSimple->setHourStart('00');
  669.                             $newLoungeSimple->setHourEnd($item->getHourEnd());
  670.                             $newLoungeSimple->setMinStart('00');
  671.                             $newLoungeSimple->setMinEnd($item->getMinEnd());
  672.                         } else {
  673.                             // Día intermedio
  674.                             $newLoungeSimple->setDateStart(new \DateTime($actualDay->format('Y-m-d') . ' 00:00'));
  675.                             $newLoungeSimple->setDateEnd(new \DateTime($actualDay->format('Y-m-d') . ' 23:59'));
  676.                             $newLoungeSimple->setHourStart('00');
  677.                             $newLoungeSimple->setHourEnd('23');
  678.                             $newLoungeSimple->setMinStart('00');
  679.                             $newLoungeSimple->setMinEnd('59');
  680.                         }
  682.                         $newLoungeSimple->setIdLounge($item->getIdLounge());
  683.                         $newLoungeSimple->setIdReservation($item->getIdReservation());
  684.                         $newLoungeSimple->setLoungeName($item->getLoungeName());
  685.                         $newLoungeSimple->setPax($item->getPax());
  686.                         $newLoungeSimple->setServicePrice($item->getServicePrice());
  688.                         // IVA (string) + entidad
  689.                         $newLoungeSimple->setIva($item->getIva());
  690.                         $rawRate = $item->getIva();
  691.                         $vatEnt = null;
  692.                         if ($rawRate !== null && $rawRate !== '') {
  693.                             $rate = (float) $rawRate;
  694.                             if ($rate > 1) {
  695.                                 $rate = $rate / 100;
  696.                             }
  697.                             $vatEnt = $vatRepo->findOneBy(['rate' => $rate]);
  698.                         }
  699.                         $newLoungeSimple->setSageIva($vatEnt);
  701.                         $newLoungeSimple->setOpIva($item->getOpIva());
  702.                         $newLoungeSimple->setType($item->getType());
  703.                         $newLoungeSimple->setRankQuote($item->getRankQuote());
  704.                         $newLoungeSimple->setLoungeDescription($item->getLoungeDescription());
  705.                         $newLoungeSimple->setImportantDescription($item->getImportantDescription());
  706.                         $newLoungeSimple->setCreatedAt($createdAt);
  707.                         $newLoungeSimple->setCreatedBy($createdBy);
  708.                         $newLoungeSimple->setUpdatedAt($updatedAt);
  709.                         $newLoungeSimple->setUpdatedBy($updatedBy);
  711.                         // Avanza el día (sin perder la referencia)
  712.                         $actualDay = (clone $actualDay)->modify('+1 day');
  714.                         try {
  715.                             $em->persist($newLoungeSimple);
  716.                             $em->flush();
  717.                             $event = 'The Item has been updated.';
  718.                             $successMessage = $this->translator->trans($event);
  719.                             $this->addFlash('mensajereservation', $successMessage);
  720.                         } catch (\Exception $e) {
  721.                             $event = 'An error occurred: ' . $e->getMessage();
  722.                             $errorMessage = $this->translator->trans($event);
  723.                             $this->addFlash('mensajereservationerror', $errorMessage);
  724.                         }
  726.                         // Actualiza fechas de la reserva si procede
  727.                         $boolReserva = false;
  728.                         if ($newLoungeSimple->getDateStart() < $reservax->getDateStart()) {
  729.                             $reservax->setDateStart($newLoungeSimple->getDateStart());
  730.                             $boolReserva = true;
  731.                         }
  732.                         if ($reservax->getDateEnd() < $newLoungeSimple->getDateEnd()) {
  733.                             $reservax->setDateEnd($newLoungeSimple->getDateEnd());
  734.                             $boolReserva = true;
  735.                         }
  736.                         if ($boolReserva) {
  737.                             $em->persist($reservax);
  738.                             $em->flush();
  739.                         }
  740.                     }
  741.                 }
  743.                 // Re-llama al mismo controlador ahora con la nueva tabla poblada
  744.                 return $this->redirectToRoute('reservations_venues_duplicate_day', [
  745.                     'id' => $id,
  746.                     'dayduplicate' => $dayduplicate,
  747.                 ]);
  748.             }
  749.         }
  751.         //Se llama al servicio para crear la entrada en la agenda y actualizar el Pax de la agenda
  752.         $agenda = $this->agendaService->createAgendaFromSource($newLoungeSimple->getIdReservation(), 'SALAS A UTILIZAR', null, null, $newLoungeSimple->getDateStart(), $newLoungeSimple->getDateEnd(), $newLoungeSimple->getLoungeName(), $newLoungeSimple->getId(), 'ReservationLoungeSimple', $updatedBy);
  754.         $reserva = $em->getRepository(Reservation::class)->findOneById($newLoungeSimple->getIdReservation());
  756.         //Se llama al servicio para crear la entrada en la agenda de las fechas
  757.         $agenda = $this->agendaService->updateDatesLine($reserva->getId(), $updatedBy);
  759.         // Creamos la Snapshot de las salas y servicios del sistema (LOG)
  760.         $version = $this->venueService->createSnapshot($reservax);
  762.         /* Obtengo usuario logueado */
  763.         $user = $this->get('security.token_storage')->getToken()->getUser();
  765.         // Sincronizar contratos si está confirmado
  766.         if ($reservax->getStatus() === 'Confirmed') {
  767.             $this->docContractService->autoAssignContracts($reservax, $user);
  768.         }
  770.         // Redirige para agregar Servicio de limpieza
  771.         return $this->redirectToRoute('reservations_white_addservices_cleaning', [
  772.             'resid' => $id,
  773.             'loungesimpleid' => isset($newLoungeSimple) ? $newLoungeSimple->getId() : null,
  774.         ]);
  775.     }
  778.     /**
  779.      * @Route("/deleteitemsimple/{id}/{daydelete}", name="reservations_venues_delete_simple_lounge")
  780.      * Elimina un Reservation Simple Lounge de la cotizacion
  781.      */
  782.     public function deleteSimpleLoungeAction($id, $daydelete, EntityManagerInterface $em, Request $request)
  783.     {
  784.         $loungeSimple = $em->getRepository(ReservationLoungeSimple::class)->findOneById($id);
  786.         if (!empty($loungeSimple)) {
  787.             //Se llama al servicio para eliminar la entrada en la agenda
  788.             $agenda = $this->agendaService->deleteAgendaBySource($loungeSimple->getId(), 'ReservationLoungeSimple');
  789.         }
  791.         $id = $loungeSimple->getIdReservation();
  792.         $reserva = $em->getRepository(Reservation::class)->findOneById($loungeSimple->getIdReservation());
  794.         try {
  795.             $em->remove($loungeSimple);
  796.             $em->flush();
  797.             $event = 'The item has been deleted.';
  798.             $successMessage = $this->translator->trans($event);
  799.             $this->addFlash('mensajereservation', $successMessage);
  800.         } catch (\Exception $e) {
  801.             $event = 'An error occurred: ' . $e->getMessage();
  802.             $errorMessage = $this->translator->trans($event);
  803.             $this->addFlash('mensajereservationerror', $errorMessage);
  804.         }
  806.         /* Obtengo usuario logueado */
  807.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  809.         // Recalcular fechas de la reserva usando el servicio
  810.         if ($reserva) {
  811.             $this->reservationService->updateReservationDates($reserva);
  812.             
  813.             // Sincronizar contratos si está confirmado
  814.             if ($reserva->getStatus() === 'Confirmed') {
  815.                 $this->docContractService->autoAssignContracts($reserva, $user_logueado);
  816.             }
  817.         }
  818.         $user_id = $user_logueado->getId();
  820.         //Se llama al servicio para crear la entrada en la agenda de las fechas
  821.         $agenda = $this->agendaService->updateDatesLine($reserva->getId(), $user_id);
  823.         //Se llama al servicio para actualizar Pax en la agenda
  824.         $paxAge = $this->agendaService->calculatePaxForReservation($reserva->getId());
  825.         $agenda = $this->agendaService->updatePaxLine($reserva->getId(), $paxAge, $user_id);
  827.         // Se elimina el servicio de horas de limpieza de la sala
  828.         return $this->redirectToRoute(
  829.             'reservations_venues_delete_simple_lounge_cleaning',
  830.             array(
  831.                 'idRes' => $id,
  832.                 'idLng' => $loungeSimple->getIdLounge(),
  833.                 'dateInAt' => $loungeSimple->getDateStart()->format('Y-m-d\TH:i'),
  834.                 'dateOutAt' => $loungeSimple->getDateEnd()->format('Y-m-d\TH:i'),
  835.             )
  836.         );
  837.     }
  840.     /**
  841.      * @Route("/deletequote/{idRes}/{idQuote}", name="reservations_delete_quote")
  842.      * Eliminar una cotizancion
  843.      */
  844.     public function deleteQuoteAction($idRes, $idQuote, EntityManagerInterface $em, Request $request)
  845.     {
  846.         $qb = $em->getRepository(ReservationLoungeSimple::class)->createQueryBuilder('r');
  847.         $reservation = $qb->where('r.rankQuote = :rankQuote')
  848.             ->andWhere('r.idReservation = :idReservation')
  849.             ->setParameter('idReservation', $idRes)
  850.             ->setParameter('rankQuote', $idQuote)
  851.             ->getQuery()
  852.             ->getResult();
  854.         foreach ($reservation as $item) {
  855.             try {
  856.                 if (!empty($item)) {
  857.                     //Se llama al servicio para eliminar la entrada en la agenda
  858.                     $agenda = $this->agendaService->deleteAgendaBySource($item->getId(), 'ReservationLoungeSimple');
  859.                 }
  861.                 $em->remove($item);
  862.                 $em->flush();
  863.                 $event = 'Se ha eliminado la cotización';
  864.                 $successMessage = $this->translator->trans($event);
  865.                 $this->addFlash('mensajereservation', $successMessage);
  866.             } catch (\Exception $e) {
  867.                 $event = 'An error occurred: ' . $e->getMessage();
  868.                 $errorMessage = $this->translator->trans($event);
  869.                 $this->addFlash('mensajereservationerror', $errorMessage);
  870.             }
  872.             //Se deben eliminar todas las horas de limpieza asociadas a las salas de la cotización
  873.             $loungeDetails = $em->getRepository(ReservationLoungeDetails::class)->findOneById($item->getIdLounge());
  874.             $stringName = 'HORAS ( ' . $loungeDetails->getName() . ' )';
  875.             $serviceCatIdClean = 21;
  876.             $dateInAt = new \DateTime($item->getDateStart()->format('Y-m-d\TH:i'));
  877.             $dateOutAt = new \DateTime($item->getDateEnd()->format('Y-m-d\TH:i'));
  879.             $qb = $em->getRepository(ReservationService::class)->createQueryBuilder('rs');
  881.             $serviceClean = $qb->where('rs.reservationId = :id')
  882.                 ->andWhere('rs.name = :name')
  883.                 ->andWhere('rs.dateInAt = :dateInAt')
  884.                 ->andWhere('rs.dateOutAt = :dateOutAt')
  885.                 ->andWhere('rs.serviceCatId = :serviceCatId')
  886.                 ->setParameter('id', $idRes)
  887.                 ->setParameter('name', $stringName)
  888.                 ->setParameter('dateInAt', $dateInAt)
  889.                 ->setParameter('dateOutAt', $dateOutAt)
  890.                 ->setParameter('serviceCatId', $serviceCatIdClean)
  891.                 ->getQuery()
  892.                 ->getResult();
  894.             if (!empty($serviceClean)) {
  895.                 // Se elimina el servicio de horas de limpieza de la sala
  896.                 $em->remove($serviceClean[0]);
  897.                 $em->flush();
  898.             }
  899.         }
  901.         /* Obtengo usuario logueado */
  902.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  903.         $user_id = $user_logueado->getId();
  905.         //Se llama al servicio para actualizar Pax en la agenda
  906.         $paxAge = $this->agendaService->calculatePaxForReservation($idRes);
  907.         $agenda = $this->agendaService->updatePaxLine($idRes, $paxAge, $user_id);
  909.         //Se llama al servicio para actualizar Fechas en la agenda
  910.         $agenda = $this->agendaService->updateDatesLine($idRes, $user_id);
  912.         // Recalcular fechas de la reserva
  913.         $reservaEntity = $em->getRepository(Reservation::class)->find($idRes);
  914.         if ($reservaEntity) {
  915.             $this->reservationService->updateReservationDates($reservaEntity);
  916.         }
  918.         return $this->redirectToRoute(
  919.             'reservations_venues_edit_simple',
  920.             array(
  921.                 'id' => $idRes,
  922.                 'token' => null,
  923.                 '_fragment' => 'btn_quotes'
  924.             )
  925.         );
  926.     }
  929.     /**
  930.      * @Route("/checkquote/{idRes}/{idQuote}", name="reservations_check_quote")
  931.      * Confirmación de que se ha aceptado la cotizancion, se eliminaran las otras cotizaciones del expediente
  932.      */
  933.     public function checkQuoteAction($idRes, $idQuote, EntityManagerInterface $em, Request $request)
  934.     {
  935.         $qb = $em->getRepository(ReservationLoungeSimple::class)->createQueryBuilder('r');
  936.         $reservation = $qb->where('r.rankQuote <> :rankQuote')
  937.             ->andWhere('r.idReservation = :idReservation')
  938.             ->setParameter('idReservation', $idRes)
  939.             ->setParameter('rankQuote', $idQuote)
  940.             ->getQuery()
  941.             ->getResult();
  943.         foreach ($reservation as $item) {
  944.             try {
  945.                 if (!empty($item)) {
  946.                     //Se llama al servicio para eliminar la entrada en la agenda
  947.                     $agenda = $this->agendaService->deleteAgendaBySource($item->getId(), 'ReservationLoungeSimple');
  948.                 }
  949.                 $em->remove($item);
  950.                 $em->flush();
  951.                 $event = 'Se han eliminado las otras cotizaciones';
  952.                 $successMessage = $this->translator->trans($event);
  953.                 $this->addFlash('mensajereservation', $successMessage);
  954.             } catch (\Exception $e) {
  955.                 $event = 'An error occurred: ' . $e->getMessage();
  956.                 $errorMessage = $this->translator->trans($event);
  957.                 $this->addFlash('mensajereservationerror', $errorMessage);
  958.             }
  959.         }
  961.         // Actualizar fechas de la reserva usando el servicio
  962.         $reservation = $em->getRepository(Reservation::class)->findOneById($idRes);
  963.         $this->reservationService->updateReservationDates($reservation);
  965.         /* Obtengo usuario logueado */
  966.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  967.         $user_id = $user_logueado->getId();
  969.         //Se llama al servicio para actualizar Pax en la agenda
  970.         $paxAge = $this->agendaService->calculatePaxForReservation($idRes);
  971.         $agenda = $this->agendaService->updatePaxLine($idRes, $paxAge, $user_id);
  973.         //Se llama al servicio para actualizar Fechas en la agenda
  974.         $agenda = $this->agendaService->updateDatesLine($idRes, $user_id);
  976.         return $this->redirectToRoute(
  977.             'reservations_venues_edit_simple',
  978.             array(
  979.                 'id' => $idRes,
  980.                 'token' => null,
  981.                 '_fragment' => 'btn_quotes'
  982.             )
  983.         );
  984.     }
  987.     /**
  988.      * @Route("/duplicatequote", name="reservations_duplicate_quote")
  989.      * Duplicar una cotizacion
  990.      */
  991.     public function duplicateQuoteAction(EntityManagerInterface $em, Request $request)
  992.     {
  994.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  995.         $user_id = $user_logueado->getId();
  996.         $hoy = new \DateTime("now", NULL);
  997.         $reqDuplicateQuote = $request->request->get('addquote');
  998.         $newLounge = $em->getRepository(ReservationLoungeDetails::class)->findOneById($reqDuplicateQuote['salaPrecargadas']);
  1000.         $qb = $em->getRepository(ReservationLoungeSimple::class)->createQueryBuilder('r');
  1001.         $reservationAll = $qb->where('r.idReservation = :idReservation')
  1002.             ->setParameter('idReservation', $reqDuplicateQuote['reservationId'])
  1003.             ->orderBy('r.rankQuote', 'ASC')
  1004.             ->getQuery()
  1005.             ->getResult();
  1007.         $newRankId = (!empty($reservationAll)) ? (end($reservationAll)->getRankQuote() + 1) : 1;
  1008.         if (empty($reqDuplicateQuote['idQuote'])) {
  1009.             $reqDuplicateQuote['idQuote'] = reset($reservationAll)->getRankQuote();
  1010.         }   //Si no elige cotización se duplica la primera
  1012.         $qb = $em->getRepository(ReservationLoungeSimple::class)->createQueryBuilder('r');
  1013.         $reservation = $qb->where('r.rankQuote = :rankQuote')
  1014.             ->andWhere('r.idReservation = :idReservation')
  1015.             ->setParameter('idReservation', $reqDuplicateQuote['reservationId'])
  1016.             ->setParameter('rankQuote', $reqDuplicateQuote['idQuote'])
  1017.             ->getQuery()
  1018.             ->getResult();
  1020.         // Descripciones web por sala/idioma con fallbacks
  1021.         $loungeProfile = $newLounge;
  1022.         // Heredar idioma si existe alguna sala previa en la reserva
  1023.         $idioma = empty($reservationAll) ? 1: $reservationAll[0]->getLanguage();
  1025.         $loungeWebDescriptionRepo = $em->getRepository(ReservationLoungeWebDescription::class);
  1026.         $loungeWebDescription = $loungeWebDescriptionRepo->findOneBy([
  1027.                 'lounge' => $loungeProfile,
  1028.                 'language' => $idioma
  1029.             ]) ?? ($idioma !== 1 ? $loungeWebDescriptionRepo->findOneBy([
  1030.                 'lounge' => $loungeProfile,
  1031.                 'language' => 1
  1032.             ]) : null) ?? $loungeWebDescriptionRepo->findOneBy(['lounge' => $loungeProfile]);
  1034.         $loungeImportantDescGeneralText = $loungeWebDescription ? $loungeWebDescription->getImportantDescGeneralText() : '';
  1035.         $loungeImportantDescSchedules = $loungeWebDescription ? $loungeWebDescription->getImportantDescSchedules() : '';
  1036.         $loungeImportantDescParking = $loungeWebDescription ? $loungeWebDescription->getImportantDescParking() : '';
  1037.         $loungeSummaryDescription = $loungeWebDescription ? $loungeWebDescription->getImportantDescription() : '';
  1039.         foreach ($reservation as $item) {
  1040.             $newLoungeSimple = new ReservationLoungeSimple();
  1041.             $newLoungeSimple->setDateStart($item->getDateStart());
  1042.             $newLoungeSimple->setDateEnd($item->getDateEnd());
  1043.             $newLoungeSimple->setIdReservation($reqDuplicateQuote['reservationId']);
  1044.             $newLoungeSimple->setPax($item->getPax());
  1045.             $newLoungeSimple->setType($item->getType());
  1046.             $newLoungeSimple->setCreatedAt($hoy);
  1047.             $newLoungeSimple->setCreatedBy($user_id);
  1048.             $newLoungeSimple->setUpdatedAt($hoy);
  1049.             $newLoungeSimple->setUpdatedBy($user_id);
  1050.             $newLoungeSimple->setHourStart($item->getHourStart());
  1051.             $newLoungeSimple->setMinStart($item->getMinStart());
  1052.             $newLoungeSimple->setHourEnd($item->getHourEnd());
  1053.             $newLoungeSimple->setMinEnd($item->getMinEnd());
  1054.             $newLoungeSimple->setRankQuote($newRankId);
  1055.             $newLoungeSimple->setIva($item->getIva());
  1056.             $newLoungeSimple->setOpIva($item->getOpIva());
  1057.             $newLoungeSimple->setIdLounge($newLounge->getId());
  1058.             $newLoungeSimple->setLoungename($newLounge->getName());
  1059.             //            $newLoungeSimple->setLoungeDescription($item->getLoungeDescription());
  1060.             $newLoungeSimple->setImportantDescription($loungeSummaryDescription);
  1061.             $newLoungeSimple->setImportantDescGeneralText($loungeImportantDescGeneralText);
  1062.             $newLoungeSimple->setImportantDescSchedules($loungeImportantDescSchedules);
  1063.             $newLoungeSimple->setImportantDescParking($loungeImportantDescParking);
  1064.             $newLoungeSimple->setLanguage($item->getLanguage());
  1065.             $newLoungeSimple->setSageArticle($item->getSageArticle());
  1066.             $newLoungeSimple->setSentToSage($item->isSentToSage());
  1067.             $newLoungeSimple->setSageIva($item->getSageIva());
  1069.             if (!empty($reqDuplicateQuote['salaPrice'])) {
  1070.                 $newLoungeSimple->setServicePrice($reqDuplicateQuote['salaPrice']);
  1071.             } else {
  1072.                 $newLoungeSimple->setServicePrice($item->getServicePrice());
  1073.             }
  1075.             try {
  1076.                 $em->persist($newLoungeSimple);
  1077.                 $em->flush();
  1078.                 $event = 'Se ha agregado la nueva cotización';
  1079.                 $successMessage = $this->translator->trans($event);
  1080.                 $this->addFlash('mensajereservation', $successMessage);
  1081.             } catch (\Exception $e) {
  1082.                 $event = 'An error occurred: ' . $e->getMessage();
  1083.                 $errorMessage = $this->translator->trans($event);
  1084.                 $this->addFlash('mensajereservationerror', $errorMessage);
  1085.             }
  1087.             //Se llama al servicio para crear la entrada en la agenda
  1088.             $agenda = $this->agendaService->createAgendaFromSource(
  1089.                 $newLoungeSimple->getIdReservation(),
  1090.                 'SALAS A UTILIZAR',
  1091.                 null,
  1092.                 null,
  1093.                 $newLoungeSimple->getDateStart(),
  1094.                 $newLoungeSimple->getDateEnd(),
  1095.                 $newLoungeSimple->getLoungename(),
  1096.                 $newLoungeSimple->getId(),
  1097.                 'ReservationLoungeSimple',
  1098.                 $newLoungeSimple->getUpdatedBy()
  1099.             );
  1101.             // Se debe agregar el servicio de limpieza por cada sala que se agregue
  1102.             $resLoungeSimple = $newLoungeSimple;
  1103.             $service = new ReservationService();
  1104.             $service->setReservationId($reqDuplicateQuote['reservationId']);
  1105.             $service->setSupplierId(0);
  1106.             $service->setDateInAt($resLoungeSimple->getDateStart());
  1107.             $service->setDateOutAt($resLoungeSimple->getDateEnd());
  1109.             /* Obtengo usuario logueado */
  1110.             $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1111.             $user_id = $user_logueado->getId();
  1113.             $service->setCreatedId($user_id);
  1114.             $service->setUpdatedId($user_id);
  1115.             $service->setCreatedAt(new \DateTime("now"));
  1116.             $service->setUpdatedAt(new \DateTime("now"));
  1118.             $service->setServiceCatId('21');
  1119.             $service->setServiceCatName('Limpieza');
  1120.             $service->setContcolor('green-300');
  1121.             $service->setName('HORAS ( ' . $resLoungeSimple->getLoungeName() . ' )');
  1122.             $service->setPrice('14');
  1123.             $service->setCurrency('Euro');
  1124.             $service->setUnits('8');
  1125.             $service->setCommission('0');
  1126.             $service->setPax('0');
  1127.             $service->setOver('0');
  1128.             $service->setIva('21');
  1129.             $service->setOpIva('1');
  1130.             $service->setOpCommission('1');
  1131.             $service->setCommission('57.14');
  1132.             $service->setViewInfo(0);
  1133.             $service->setToinvoice(0);
  1134.             $service->setServiceId(0);
  1136. //            $em->persist($service);
  1137. //            $em->flush();
  1138.         }
  1140.         $reserva = $em->getRepository(Reservation::class)->findOneById($reqDuplicateQuote['reservationId']);
  1142.         // Creamos la Snapshot de las salas y servicios del sistema (LOG)
  1143.         $version = $this->venueService->createSnapshot($reserva);
  1145.         return $this->redirectToRoute(
  1146.             'reservations_venues_edit_simple',
  1147.             array(
  1148.                 'id' => $reqDuplicateQuote['reservationId'],
  1149.                 'token' => null,
  1150.                 '_fragment' => 'btn_quotes'
  1151.             )
  1152.         );
  1153.     }
  1156.     /**
  1157.      * @Route("/loghistoric/{id}", name="reservations_log_historic")
  1158.      * Log del historico de la cotizacion de la reserva id
  1159.      */
  1160.     public function logHistoricQuoteAction($id, EntityManagerInterface $em, Request $request){
  1161.         $reservaLogs = $em->getRepository(ReservationLoungeSimpleServiceLog::class)->findByReservaId($id);
  1163.         return $this->render(
  1164.             'MDS/VenuesBundle/reservations/list-reservations-log-historic.html.twig',
  1165.             array(
  1166.                 'id' => $id,
  1167.                 'reservaLogs' => $reservaLogs,
  1168.             )
  1169.         );
  1170.     }
  1173.     /**
  1174.      * @Route("/productfileavlist/{id}",  name="reservations_list_multiple_productfile_av")
  1175.      * Listar productos de Av para agregar en el servicio id
  1176.      */
  1177.     public function listMultipleProductAvAction( $id, Request $request){
  1178.         $em = $this->getDoctrine()->getManager();
  1180.         $parameters = [];
  1181.         $dql = 'SELECT i
  1182.                 FROM AvexpressBundle:AveProduct i
  1183.                 ORDER BY i.name ASC';
  1184.         $query = $em->createQuery($dql)->setParameters($parameters);
  1185.         $avs = $query->getResult();
  1187.         $data_av = [];
  1189.         $data_av[] = array( 'id' => -6, 'name' => 'Paquete de técnicos 8h + 1 (Técnico video y sonido, dietas no incluidas)', 'type' => 'Paquete', 'price' => '600');
  1190.         $data_av[] = array( 'id' => -5, 'name' => 'Paquete de Sala 25 (Pantalla 112" Led  4k 3x2 x 1.8, mesa de sonido 6 altavoces, micrófono de mano, tarima)', 'type' => 'Paquete', 'price' => '1600');
  1191.         $data_av[] = array( 'id' => -4, 'name' => 'Paquete de Sala White (Pantalla 112" Led  4k 3x2 x 1.8, mesa de sonido 6 altavoces, micrófono de mano, tarima)', 'type' => 'Paquete', 'price' => '1600');
  1192.         $data_av[] = array( 'id' => -3, 'name' => 'Paquete de Sala Black (Pantalla 112" Led  4k 3x2 x 1.8, mesa de sonido 6 altavoces, micrófono de mano, tarima)', 'type' => 'Paquete', 'price' => '1300');
  1193.         $data_av[] = array( 'id' => -2, 'name' => 'Paquete de Promoción Sala Legends (Pantalla de 112", micrófono de mano, ordenador, altavoz, cable auxiliar HDMI, pasa diapositivas)', 'type' => 'Paquete', 'price' => '750');
  1194.         $data_av[] = array( 'id' => -1, 'name' => 'Paquete de Sala Art Legends (Proyectores de sala inmersiva bajo cotización)', 'type' => 'Paquete', 'price' => '1000');
  1196.         foreach($avs as $av){
  1197.             $data_av[] = array(
  1198.                 'id' => $av->getId(),
  1199.                 'name' => $av->getName(),
  1200.                 'type' => $av->getType(),
  1201.                 'price' => $av->getPrice(),
  1202.             );
  1203.         }
  1205.         $resService = $em->getRepository(ReservationService::class)->findOneById($id);
  1207.         return $this->render('MDS/VenuesBundle/reservations/add-services-avs.html.twig',
  1208.             array(
  1209.                 'id' => $id,
  1210.                 'idRes' => empty($resService) ? 0 : $resService->getReservationId(),
  1211.                 'avs' => $data_av,
  1212.             ));
  1213.     }
  1215.     /**
  1216.      * @Route("/productfileavadd/{id}",  name="reservations_add_multiple_productfile_av")
  1217.      * Agregar productos de Av para agregar en el servicio id
  1218.      */
  1219.     public function addMultipleProductAvAction( $id, Request $request){
  1221.         $em = $this->getDoctrine()->getManager();
  1222.         $resService = $em->getRepository(ReservationService::class)->findOneById($id);
  1224.         $prodSelected = $request->request->get('details');
  1226.         $serviceName = '';
  1227.         $servicePrice = 0;
  1229.         foreach ($prodSelected as $item){
  1231.             if(empty($serviceName)){
  1232.                 $serviceName .= $item['name'];
  1233.             } else {
  1234.                 $serviceName .= ' + '. $item['name'];
  1235.             }
  1236.             $servicePrice += $item['total_price'];
  1237.         }
  1239.         $resService->setName($serviceName);
  1240.         $resService->setPrice($servicePrice);
  1241.         $resService->setToInvoice(1);
  1242.         $resService->setOpIva(1);
  1243.         $resService->setIva(21);
  1245.         try {
  1246.             $em->persist($resService);
  1247.             $em->flush();
  1248.             $event = 'The Reservation has been updated.';
  1249.             $successMessage = $this->translator->trans($event);
  1250.             $this->addFlash('mensajereservation', $successMessage);
  1251.         } catch (\Exception $e) {
  1252.             $event = 'An error occurred: ' . $e->getMessage();
  1253.             $errorMessage = $this->translator->trans($event);
  1254.             $this->addFlash('mensajereservationerror', $errorMessage);
  1255.         }
  1257.         return $this->redirectToRoute('reservations_venues_edit_simple', [
  1258.             'id' => $resService->getReservationId(),
  1259.             'token' => null,
  1260.             '_fragment' => 'btn_srv'
  1261.         ]);
  1263.     }
  1267.     private function precioPorFecha($date, $loungeId)
  1268.     {
  1270.         return array('price' => 0, );
  1272.         $em = $this->getDoctrine()->getManager();
  1273.         $price0 = null;
  1275.         // Buscamos por año
  1276.         $parameters = array('dateYear' => $date->format('Y'), 'loungeId' => $loungeId, 'priceIsActive' => true, );
  1277.         $dql = 'SELECT i
  1278.                 FROM VenuesBundle:ReservationLoungeProfile i
  1279.                 WHERE  ((i.year1 <= :dateYear and i.year2 >= :dateYear) ) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive';
  1281.         $query = $em->createQuery($dql)->setParameters($parameters);
  1282.         $price1 = $query->getResult();
  1284.         // Buscamos por año y mes
  1285.         $parameters = array('dateYear' => $date->format('Y'), 'month' => true, 'loungeId' => $loungeId, 'priceIsActive' => true, );
  1287.         switch ($date->format('m')) {
  1288.             case '01': //Enero
  1289.                 $dql = 'SELECT i
  1290.                     FROM VenuesBundle:ReservationLoungeProfile i
  1291.                     WHERE (
  1292.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1293.                           AND (i.month1 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1294.                       ';
  1295.                 break;
  1297.             case '02': //Febrero
  1298.                 $dql = 'SELECT i
  1299.                     FROM VenuesBundle:ReservationLoungeProfile i
  1300.                     WHERE (
  1301.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1302.                           AND (i.month2 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1303.                       ';
  1304.                 break;
  1306.             case '03': //Marzo
  1307.                 $dql = 'SELECT i
  1308.                     FROM VenuesBundle:ReservationLoungeProfile i
  1309.                     WHERE (
  1310.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1311.                           AND (i.month3 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1312.                       ';
  1313.                 break;
  1315.             case '04': //Abril
  1316.                 $dql = 'SELECT i
  1317.                     FROM VenuesBundle:ReservationLoungeProfile i
  1318.                     WHERE (
  1319.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1320.                           AND (i.month4 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1321.                       ';
  1322.                 break;
  1324.             case '05': //Mayo
  1325.                 $dql = 'SELECT i
  1326.                     FROM VenuesBundle:ReservationLoungeProfile i
  1327.                     WHERE (
  1328.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1329.                           AND (i.month5 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1330.                       ';
  1331.                 break;
  1333.             case '06': //Junio
  1334.                 $dql = 'SELECT i
  1335.                     FROM VenuesBundle:ReservationLoungeProfile i
  1336.                     WHERE (
  1337.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1338.                           AND (i.month6 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1339.                       ';
  1340.                 break;
  1342.             case '07': //Julio
  1343.                 $dql = 'SELECT i
  1344.                     FROM VenuesBundle:ReservationLoungeProfile i
  1345.                     WHERE (
  1346.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1347.                           AND (i.month7 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1348.                       ';
  1349.                 break;
  1351.             case '08': //Agosto
  1352.                 $dql = 'SELECT i
  1353.                     FROM VenuesBundle:ReservationLoungeProfile i
  1354.                     WHERE (
  1355.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1356.                           AND (i.month8 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1357.                       ';
  1358.                 break;
  1360.             case '09': //Septiembre
  1361.                 $dql = 'SELECT i
  1362.                     FROM VenuesBundle:ReservationLoungeProfile i
  1363.                     WHERE (
  1364.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1365.                           AND (i.month9 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1366.                       ';
  1367.                 break;
  1369.             case '10': //Octubre
  1370.                 $dql = 'SELECT i
  1371.                     FROM VenuesBundle:ReservationLoungeProfile i
  1372.                     WHERE (
  1373.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1374.                           AND (i.month10 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1375.                       ';
  1376.                 break;
  1378.             case '11': //Noviembre
  1379.                 $dql = 'SELECT i
  1380.                     FROM VenuesBundle:ReservationLoungeProfile i
  1381.                     WHERE (
  1382.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1383.                           AND (i.month11 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1384.                       ';
  1385.                 break;
  1387.             case '12': //Diciembre
  1388.                 $dql = 'SELECT i
  1389.                     FROM VenuesBundle:ReservationLoungeProfile i
  1390.                     WHERE (
  1391.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1392.                           AND (i.month12 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1393.                       ';
  1394.                 break;
  1396.             default:
  1397.                 break;
  1398.         }
  1400.         $query = $em->createQuery($dql)->setParameters($parameters);
  1401.         $price2 = $query->getResult();
  1403.         // Buscamos por año, mes y dia de la semana
  1404.         $parameters = array('dateYear' => $date->format('Y'), 'month' => true, 'day' => true, 'loungeId' => $loungeId, 'priceIsActive' => true, );
  1406.         switch ($date->format('m')) {
  1407.             case '01': //Enero
  1408.                 switch ($date->format('l')) {
  1409.                     case 'Monday': //Lunes
  1410.                         $dql = 'SELECT i
  1411.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1412.                                     WHERE (
  1413.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1414.                                           AND (i.month1 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1415.                                       ';
  1416.                         break;
  1418.                     case 'Tuesday': //Martes
  1419.                         $dql = 'SELECT i
  1420.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1421.                                     WHERE (
  1422.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1423.                                           AND (i.month1 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1424.                                       ';
  1425.                         break;
  1427.                     case 'Wednesday': //Miercoles
  1428.                         $dql = 'SELECT i
  1429.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1430.                                     WHERE (
  1431.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1432.                                           AND (i.month1 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1433.                                       ';
  1434.                         break;
  1436.                     case 'Thursday': //Jueves
  1437.                         $dql = 'SELECT i
  1438.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1439.                                     WHERE (
  1440.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1441.                                           AND (i.month1 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1442.                                       ';
  1443.                         break;
  1445.                     case 'Friday': //Viernes
  1446.                         $dql = 'SELECT i
  1447.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1448.                                     WHERE (
  1449.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1450.                                           AND (i.month1 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1451.                                       ';
  1452.                         break;
  1454.                     case 'Saturday': //Sabado
  1455.                         $dql = 'SELECT i
  1456.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1457.                                     WHERE (
  1458.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1459.                                           AND (i.month1 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1460.                                       ';
  1461.                         break;
  1463.                     case 'Sunday': //Domingo
  1464.                         $dql = 'SELECT i
  1465.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1466.                                     WHERE (
  1467.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1468.                                           AND (i.month1 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1469.                                       ';
  1470.                         break;
  1471.                     default:
  1472.                         break;
  1473.                 }
  1474.                 break;
  1476.             case '02': //Febrero
  1478.                 switch ($date->format('l')) {
  1479.                     case 'Monday': //Lunes
  1480.                         $dql = 'SELECT i
  1481.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1482.                                     WHERE (
  1483.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1484.                                           AND (i.month2 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1485.                                       ';
  1486.                         break;
  1488.                     case 'Tuesday': //Martes
  1489.                         $dql = 'SELECT i
  1490.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1491.                                     WHERE (
  1492.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1493.                                           AND (i.month2 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1494.                                       ';
  1495.                         break;
  1497.                     case 'Wednesday': //Miercoles
  1498.                         $dql = 'SELECT i
  1499.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1500.                                     WHERE (
  1501.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1502.                                           AND (i.month2 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1503.                                       ';
  1504.                         break;
  1506.                     case 'Thursday': //Jueves
  1507.                         $dql = 'SELECT i
  1508.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1509.                                     WHERE (
  1510.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1511.                                           AND (i.month2 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1512.                                       ';
  1513.                         break;
  1515.                     case 'Friday': //Viernes
  1516.                         $dql = 'SELECT i
  1517.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1518.                                     WHERE (
  1519.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1520.                                           AND (i.month2 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1521.                                       ';
  1522.                         break;
  1524.                     case 'Saturday': //Sabado
  1525.                         $dql = 'SELECT i
  1526.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1527.                                     WHERE (
  1528.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1529.                                           AND (i.month2 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1530.                                       ';
  1531.                         break;
  1533.                     case 'Sunday': //Domingo
  1534.                         $dql = 'SELECT i
  1535.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1536.                                     WHERE (
  1537.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1538.                                           AND (i.month2 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1539.                                       ';
  1540.                         break;
  1542.                     default:
  1543.                         break;
  1544.                 }
  1546.                 break;
  1548.             case '03': //Marzo
  1550.                 switch ($date->format('l')) {
  1551.                     case 'Monday': //Lunes
  1552.                         $dql = 'SELECT i
  1553.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1554.                                     WHERE (
  1555.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1556.                                           AND (i.month3 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1557.                                       ';
  1558.                         break;
  1560.                     case 'Tuesday': //Martes
  1561.                         $dql = 'SELECT i
  1562.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1563.                                     WHERE (
  1564.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1565.                                           AND (i.month3 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1566.                                       ';
  1567.                         break;
  1569.                     case 'Wednesday': //Miercoles
  1570.                         $dql = 'SELECT i
  1571.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1572.                                     WHERE (
  1573.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1574.                                           AND (i.month3 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1575.                                       ';
  1576.                         break;
  1578.                     case 'Thursday': //Jueves
  1579.                         $dql = 'SELECT i
  1580.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1581.                                     WHERE (
  1582.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1583.                                           AND (i.month3 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1584.                                       ';
  1585.                         break;
  1587.                     case 'Friday': //Viernes
  1588.                         $dql = 'SELECT i
  1589.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1590.                                     WHERE (
  1591.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1592.                                           AND (i.month3 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1593.                                       ';
  1594.                         break;
  1596.                     case 'Saturday': //Sabado
  1597.                         $dql = 'SELECT i
  1598.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1599.                                     WHERE (
  1600.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1601.                                           AND (i.month3 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1602.                                       ';
  1603.                         break;
  1605.                     case 'Sunday': //Domingo
  1606.                         $dql = 'SELECT i
  1607.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1608.                                     WHERE (
  1609.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1610.                                           AND (i.month3 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1611.                                       ';
  1612.                         break;
  1614.                     default:
  1615.                         break;
  1616.                 }
  1618.                 break;
  1620.             case '04': //Abril
  1622.                 switch ($date->format('l')) {
  1623.                     case 'Monday': //Lunes
  1624.                         $dql = 'SELECT i
  1625.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1626.                                     WHERE (
  1627.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1628.                                           AND (i.month4 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1629.                                       ';
  1630.                         break;
  1632.                     case 'Tuesday': //Martes
  1633.                         $dql = 'SELECT i
  1634.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1635.                                     WHERE (
  1636.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1637.                                           AND (i.month4 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1638.                                       ';
  1639.                         break;
  1641.                     case 'Wednesday': //Miercoles
  1642.                         $dql = 'SELECT i
  1643.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1644.                                     WHERE (
  1645.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1646.                                           AND (i.month4 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1647.                                       ';
  1648.                         break;
  1650.                     case 'Thursday': //Jueves
  1651.                         $dql = 'SELECT i
  1652.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1653.                                     WHERE (
  1654.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1655.                                           AND (i.month4 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1656.                                       ';
  1657.                         break;
  1659.                     case 'Friday': //Viernes
  1660.                         $dql = 'SELECT i
  1661.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1662.                                     WHERE (
  1663.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1664.                                           AND (i.month4 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1665.                                       ';
  1666.                         break;
  1668.                     case 'Saturday': //Sabado
  1669.                         $dql = 'SELECT i
  1670.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1671.                                     WHERE (
  1672.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1673.                                           AND (i.month4 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1674.                                       ';
  1675.                         break;
  1677.                     case 'Sunday': //Domingo
  1678.                         $dql = 'SELECT i
  1679.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1680.                                     WHERE (
  1681.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1682.                                           AND (i.month4 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1683.                                       ';
  1684.                         break;
  1686.                     default:
  1687.                         break;
  1688.                 }
  1690.                 break;
  1692.             case '05': //Mayo
  1694.                 switch ($date->format('l')) {
  1695.                     case 'Monday': //Lunes
  1696.                         $dql = 'SELECT i
  1697.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1698.                                     WHERE (
  1699.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1700.                                           AND (i.month5 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1701.                                       ';
  1702.                         break;
  1704.                     case 'Tuesday': //Martes
  1705.                         $dql = 'SELECT i
  1706.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1707.                                     WHERE (
  1708.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1709.                                           AND (i.month5 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1710.                                       ';
  1711.                         break;
  1713.                     case 'Wednesday': //Miercoles
  1714.                         $dql = 'SELECT i
  1715.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1716.                                     WHERE (
  1717.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1718.                                           AND (i.month5 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1719.                                       ';
  1720.                         break;
  1722.                     case 'Thursday': //Jueves
  1723.                         $dql = 'SELECT i
  1724.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1725.                                     WHERE (
  1726.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1727.                                           AND (i.month5 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1728.                                       ';
  1729.                         break;
  1731.                     case 'Friday': //Viernes
  1732.                         $dql = 'SELECT i
  1733.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1734.                                     WHERE (
  1735.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1736.                                           AND (i.month5 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1737.                                       ';
  1738.                         break;
  1740.                     case 'Saturday': //Sabado
  1741.                         $dql = 'SELECT i
  1742.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1743.                                     WHERE (
  1744.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1745.                                           AND (i.month5 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1746.                                       ';
  1747.                         break;
  1749.                     case 'Sunday': //Domingo
  1750.                         $dql = 'SELECT i
  1751.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1752.                                     WHERE (
  1753.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1754.                                           AND (i.month5 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1755.                                       ';
  1756.                         break;
  1758.                     default:
  1759.                         break;
  1760.                 }
  1762.                 break;
  1764.             case '06': //Junio
  1766.                 switch ($date->format('l')) {
  1767.                     case 'Monday': //Lunes
  1768.                         $dql = 'SELECT i
  1769.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1770.                                     WHERE (
  1771.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1772.                                           AND (i.month6 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1773.                                       ';
  1774.                         break;
  1776.                     case 'Tuesday': //Martes
  1777.                         $dql = 'SELECT i
  1778.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1779.                                     WHERE (
  1780.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1781.                                           AND (i.month6 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1782.                                       ';
  1783.                         break;
  1785.                     case 'Wednesday': //Miercoles
  1786.                         $dql = 'SELECT i
  1787.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1788.                                     WHERE (
  1789.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1790.                                           AND (i.month6 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1791.                                       ';
  1792.                         break;
  1794.                     case 'Thursday': //Jueves
  1795.                         $dql = 'SELECT i
  1796.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1797.                                     WHERE (
  1798.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1799.                                           AND (i.month6 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1800.                                       ';
  1801.                         break;
  1803.                     case 'Friday': //Viernes
  1804.                         $dql = 'SELECT i
  1805.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1806.                                     WHERE (
  1807.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1808.                                           AND (i.month6 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1809.                                       ';
  1810.                         break;
  1812.                     case 'Saturday': //Sabado
  1813.                         $dql = 'SELECT i
  1814.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1815.                                     WHERE (
  1816.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1817.                                           AND (i.month6 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1818.                                       ';
  1819.                         break;
  1821.                     case 'Sunday': //Domingo
  1822.                         $dql = 'SELECT i
  1823.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1824.                                     WHERE (
  1825.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1826.                                           AND (i.month6 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1827.                                       ';
  1828.                         break;
  1830.                     default:
  1831.                         break;
  1832.                 }
  1834.                 break;
  1836.             case '07': //Julio
  1838.                 switch ($date->format('l')) {
  1839.                     case 'Monday': //Lunes
  1840.                         $dql = 'SELECT i
  1841.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1842.                                     WHERE (
  1843.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1844.                                           AND (i.month7 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1845.                                       ';
  1846.                         break;
  1848.                     case 'Tuesday': //Martes
  1849.                         $dql = 'SELECT i
  1850.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1851.                                     WHERE (
  1852.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1853.                                           AND (i.month7 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1854.                                       ';
  1855.                         break;
  1857.                     case 'Wednesday': //Miercoles
  1858.                         $dql = 'SELECT i
  1859.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1860.                                     WHERE (
  1861.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1862.                                           AND (i.month7 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1863.                                       ';
  1864.                         break;
  1866.                     case 'Thursday': //Jueves
  1867.                         $dql = 'SELECT i
  1868.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1869.                                     WHERE (
  1870.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1871.                                           AND (i.month7 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1872.                                       ';
  1873.                         break;
  1875.                     case 'Friday': //Viernes
  1876.                         $dql = 'SELECT i
  1877.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1878.                                     WHERE (
  1879.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1880.                                           AND (i.month7 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1881.                                       ';
  1882.                         break;
  1884.                     case 'Saturday': //Sabado
  1885.                         $dql = 'SELECT i
  1886.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1887.                                     WHERE (
  1888.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1889.                                           AND (i.month7 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1890.                                       ';
  1891.                         break;
  1893.                     case 'Sunday': //Domingo
  1894.                         $dql = 'SELECT i
  1895.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1896.                                     WHERE (
  1897.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1898.                                           AND (i.month7 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1899.                                       ';
  1900.                         break;
  1902.                     default:
  1903.                         break;
  1904.                 }
  1906.                 break;
  1908.             case '08': //Agosto
  1910.                 switch ($date->format('l')) {
  1911.                     case 'Monday': //Lunes
  1912.                         $dql = 'SELECT i
  1913.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1914.                                     WHERE (
  1915.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1916.                                           AND (i.month8 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1917.                                       ';
  1918.                         break;
  1920.                     case 'Tuesday': //Martes
  1921.                         $dql = 'SELECT i
  1922.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1923.                                     WHERE (
  1924.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1925.                                           AND (i.month8 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1926.                                       ';
  1927.                         break;
  1929.                     case 'Wednesday': //Miercoles
  1930.                         $dql = 'SELECT i
  1931.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1932.                                     WHERE (
  1933.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1934.                                           AND (i.month8 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1935.                                       ';
  1936.                         break;
  1938.                     case 'Thursday': //Jueves
  1939.                         $dql = 'SELECT i
  1940.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1941.                                     WHERE (
  1942.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1943.                                           AND (i.month8 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1944.                                       ';
  1945.                         break;
  1947.                     case 'Friday': //Viernes
  1948.                         $dql = 'SELECT i
  1949.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1950.                                     WHERE (
  1951.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1952.                                           AND (i.month8 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1953.                                       ';
  1954.                         break;
  1956.                     case 'Saturday': //Sabado
  1957.                         $dql = 'SELECT i
  1958.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1959.                                     WHERE (
  1960.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1961.                                           AND (i.month8 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1962.                                       ';
  1963.                         break;
  1965.                     case 'Sunday': //Domingo
  1966.                         $dql = 'SELECT i
  1967.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1968.                                     WHERE (
  1969.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1970.                                           AND (i.month8 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1971.                                       ';
  1972.                         break;
  1974.                     default:
  1975.                         break;
  1976.                 }
  1978.                 break;
  1980.             case '09': //Septiembre
  1982.                 switch ($date->format('l')) {
  1983.                     case 'Monday': //Lunes
  1984.                         $dql = 'SELECT i
  1985.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1986.                                     WHERE (
  1987.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1988.                                           AND (i.month9 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1989.                                       ';
  1990.                         break;
  1992.                     case 'Tuesday': //Martes
  1993.                         $dql = 'SELECT i
  1994.                                     FROM VenuesBundle:ReservationLoungeProfile i
  1995.                                     WHERE (
  1996.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1997.                                           AND (i.month9 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1998.                                       ';
  1999.                         break;
  2001.                     case 'Wednesday': //Miercoles
  2002.                         $dql = 'SELECT i
  2003.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2004.                                     WHERE (
  2005.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2006.                                           AND (i.month9 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2007.                                       ';
  2008.                         break;
  2010.                     case 'Thursday': //Jueves
  2011.                         $dql = 'SELECT i
  2012.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2013.                                     WHERE (
  2014.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2015.                                           AND (i.month9 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2016.                                       ';
  2017.                         break;
  2019.                     case 'Friday': //Viernes
  2020.                         $dql = 'SELECT i
  2021.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2022.                                     WHERE (
  2023.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2024.                                           AND (i.month9 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2025.                                       ';
  2026.                         break;
  2028.                     case 'Saturday': //Sabado
  2029.                         $dql = 'SELECT i
  2030.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2031.                                     WHERE (
  2032.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2033.                                           AND (i.month9 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2034.                                       ';
  2035.                         break;
  2037.                     case 'Sunday': //Domingo
  2038.                         $dql = 'SELECT i
  2039.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2040.                                     WHERE (
  2041.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2042.                                           AND (i.month9 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2043.                                       ';
  2044.                         break;
  2046.                     default:
  2047.                         break;
  2048.                 }
  2050.                 break;
  2052.             case '10': //Octubre
  2054.                 switch ($date->format('l')) {
  2055.                     case 'Monday': //Lunes
  2056.                         $dql = 'SELECT i
  2057.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2058.                                     WHERE (
  2059.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2060.                                           AND (i.month10 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2061.                                       ';
  2062.                         break;
  2064.                     case 'Tuesday': //Martes
  2065.                         $dql = 'SELECT i
  2066.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2067.                                     WHERE (
  2068.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2069.                                           AND (i.month10 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2070.                                       ';
  2071.                         break;
  2073.                     case 'Wednesday': //Miercoles
  2074.                         $dql = 'SELECT i
  2075.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2076.                                     WHERE (
  2077.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2078.                                           AND (i.month10 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2079.                                       ';
  2080.                         break;
  2082.                     case 'Thursday': //Jueves
  2083.                         $dql = 'SELECT i
  2084.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2085.                                     WHERE (
  2086.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2087.                                           AND (i.month10 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2088.                                       ';
  2089.                         break;
  2091.                     case 'Friday': //Viernes
  2092.                         $dql = 'SELECT i
  2093.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2094.                                     WHERE (
  2095.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2096.                                           AND (i.month10 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2097.                                       ';
  2098.                         break;
  2100.                     case 'Saturday': //Sabado
  2101.                         $dql = 'SELECT i
  2102.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2103.                                     WHERE (
  2104.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2105.                                           AND (i.month10 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2106.                                       ';
  2107.                         break;
  2109.                     case 'Sunday': //Domingo
  2110.                         $dql = 'SELECT i
  2111.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2112.                                     WHERE (
  2113.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2114.                                           AND (i.month10 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2115.                                       ';
  2116.                         break;
  2118.                     default:
  2119.                         break;
  2120.                 }
  2122.                 break;
  2124.             case '11': //Noviembre
  2126.                 switch ($date->format('l')) {
  2127.                     case 'Monday': //Lunes
  2128.                         $dql = 'SELECT i
  2129.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2130.                                     WHERE (
  2131.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2132.                                           AND (i.month11 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2133.                                       ';
  2134.                         break;
  2136.                     case 'Tuesday': //Martes
  2137.                         $dql = 'SELECT i
  2138.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2139.                                     WHERE (
  2140.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2141.                                           AND (i.month11 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2142.                                       ';
  2143.                         break;
  2145.                     case 'Wednesday': //Miercoles
  2146.                         $dql = 'SELECT i
  2147.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2148.                                     WHERE (
  2149.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2150.                                           AND (i.month11 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2151.                                       ';
  2152.                         break;
  2154.                     case 'Thursday': //Jueves
  2155.                         $dql = 'SELECT i
  2156.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2157.                                     WHERE (
  2158.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2159.                                           AND (i.month11 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2160.                                       ';
  2161.                         break;
  2163.                     case 'Friday': //Viernes
  2164.                         $dql = 'SELECT i
  2165.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2166.                                     WHERE (
  2167.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2168.                                           AND (i.month11 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2169.                                       ';
  2170.                         break;
  2172.                     case 'Saturday': //Sabado
  2173.                         $dql = 'SELECT i
  2174.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2175.                                     WHERE (
  2176.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2177.                                           AND (i.month11 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2178.                                       ';
  2179.                         break;
  2181.                     case 'Sunday': //Domingo
  2182.                         $dql = 'SELECT i
  2183.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2184.                                     WHERE (
  2185.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2186.                                           AND (i.month11 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2187.                                       ';
  2188.                         break;
  2190.                     default:
  2191.                         break;
  2192.                 }
  2194.                 break;
  2196.             case '12': //Diciembre
  2198.                 switch ($date->format('l')) {
  2199.                     case 'Monday': //Lunes
  2200.                         $dql = 'SELECT i
  2201.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2202.                                     WHERE (
  2203.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2204.                                           AND (i.month12 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2205.                                       ';
  2206.                         break;
  2208.                     case 'Tuesday': //Martes
  2209.                         $dql = 'SELECT i
  2210.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2211.                                     WHERE (
  2212.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2213.                                           AND (i.month12 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2214.                                       ';
  2215.                         break;
  2217.                     case 'Wednesday': //Miercoles
  2218.                         $dql = 'SELECT i
  2219.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2220.                                     WHERE (
  2221.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2222.                                           AND (i.month12 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2223.                                       ';
  2224.                         break;
  2226.                     case 'Thursday': //Jueves
  2227.                         $dql = 'SELECT i
  2228.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2229.                                     WHERE (
  2230.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2231.                                           AND (i.month12 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2232.                                       ';
  2233.                         break;
  2235.                     case 'Friday': //Viernes
  2236.                         $dql = 'SELECT i
  2237.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2238.                                     WHERE (
  2239.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2240.                                           AND (i.month12 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2241.                                       ';
  2242.                         break;
  2244.                     case 'Saturday': //Sabado
  2245.                         $dql = 'SELECT i
  2246.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2247.                                     WHERE (
  2248.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2249.                                           AND (i.month12 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2250.                                       ';
  2251.                         break;
  2253.                     case 'Sunday': //Domingo
  2254.                         $dql = 'SELECT i
  2255.                                     FROM VenuesBundle:ReservationLoungeProfile i
  2256.                                     WHERE (
  2257.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2258.                                           AND (i.month12 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2259.                                       ';
  2260.                         break;
  2262.                     default:
  2263.                         break;
  2264.                 }
  2266.                 break;
  2268.             default:
  2269.                 break;
  2270.         }
  2272.         $query = $em->createQuery($dql)->setParameters($parameters);
  2273.         $price3 = $query->getResult();
  2275.         foreach ($price3 as $item) {
  2276.             if (empty($price0)) {
  2277.                 $price0 = $item;
  2278.             } else {
  2279.                 //Si los precios coinciden en fechas se tomara el que se haya cargado mas reciente en el sistema
  2280.                 if ($item->getCreatedAt() > $price0->getCreatedAt()) {
  2281.                     $price0 = $item;
  2282.                 }
  2283.             }
  2284.         }
  2285.         if (empty($price0)) {
  2286.             $price = 0;
  2287.         } else {
  2288.             $price = $price0->getPrice();
  2289.         }
  2291.         return array('price' => $price, );
  2292.     }
  2294.     /*
  2295.      * Se busca el precio a Sugerir
  2296.      * $dateStart Fecha
  2297.      * $loungeId Id de  la sala
  2298.      * $servicePrice Preciointroducido por elusuario
  2299.      * */
  2300.     private function precioTarifario($dateStart, $loungeId, $servicePrice)
  2301.     {
  2303.         $em = $this->getDoctrine()->getManager();
  2305.         $dateToFind = clone $dateStart;
  2306.         $dateToFind->setTime(0, 0, 0);
  2307.         $parameters = array(
  2308.             'loungeId' => $loungeId,
  2309.             'typePrice' => 'DIARIA',
  2310.             'dateToFind' => $dateToFind,
  2311.         );
  2312.         $dql = 'SELECT p
  2313.                 FROM VenuesBundle:ReservationLoungeProfile p
  2314.                 WHERE p.typePrice = :typePrice AND p.dateStart = :dateToFind AND p.loungeId = :loungeId
  2315.                 ORDER BY p.levelPrice DESC';
  2317.         $query = $em->createQuery($dql)->setParameters($parameters);
  2318.         $loungesPeriodsDaily = $query->getResult();
  2320.         $priceTarifa = empty($loungesPeriodsDaily) ? 0 : $loungesPeriodsDaily[0]->getPrice();
  2322.         $price = ($servicePrice == 0) ? $priceTarifa : $servicePrice;
  2324.         return $price;
  2325.     }
  2326. }