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

Open in your IDE?
  1. <?php
  3. namespace App\MDS\GreenPatioBundle\Controller;
  5. use App\Entity\ReservationLoungeWebDescription;
  6. use App\Entity\WidgetNotes;
  7. use App\Form\WidgetNotesType;
  8. use App\MDS\AvexpressBundle\Entity\AveFiles;
  9. use App\MDS\GreenPatioBundle\Entity\Reservation;
  10. use App\MDS\GreenPatioBundle\Entity\ReservationLoungeSimple;
  11. use App\MDS\GreenPatioBundle\Entity\ReservationService;
  12. use App\MDS\GreenPatioBundle\Entity\ReservationGpPrice;
  13. use App\MDS\GreenPatioBundle\Entity\ReservationLounge;
  14. use App\MDS\GreenPatioBundle\Entity\ReservationLoungeDetails;
  15. use App\MDS\GreenPatioBundle\Entity\ReservationLoungeProfile;
  16. use App\MDS\GreenPatioBundle\Entity\ReservationPeriod;
  17. use App\MDS\GreenPatioBundle\Form\ReservationGpPriceType;
  18. use App\MDS\GreenPatioBundle\Form\ReservationLoungeDetailsType;
  19. use App\MDS\GreenPatioBundle\Form\ReservationLoungeProfileType;
  20. use App\MDS\GreenPatioBundle\Form\ReservationPeriodType;
  21. use App\MDS\GreenPatioBundle\Form\ReservationType;
  22. use App\Service\SincGpHtAvService;
  23. use Doctrine\ORM\EntityManagerInterface;
  24. use Symfony\Component\Routing\Annotation\Route;
  25. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  26. use Symfony\Component\HttpFoundation\Request;
  27. use DateTime;
  28. use DatePeriod;
  29. use DateInterval;
  30. use Google_Client;
  31. use Google_Service_Calendar;
  32. use Symfony\Contracts\Translation\TranslatorInterface;
  33. use Symfony\Component\HttpFoundation\JsonResponse;
  36. class ReservationsQuoteController extends AbstractController
  37. {
  38.     public function __construct(TranslatorInterface $translator,  SincGpHtAvService $sincGpHtAvService)
  39.     {
  40.         $redirect_uri = 'https://' . $_SERVER['HTTP_HOST']. '/calendar/token';
  41.         $googleCalendar = new Google_Client();
  42.         $googleCalendar->setApplicationName('Google Calendar API PHP Quickstart');
  43.         //campos a extraer de la base de datos User
  44.         $googleCalendar->setClientId('2790497987-57qc3vu4pr7vb0s8phpub2me58pe34lb.apps.googleusercontent.com');
  45.         $googleCalendar->setClientSecret('nj2C7unaTO68DRhyORsyipSj');
  46.         //fin campos user
  47. //        $api_key = "AIzaSyBR84cS1IU2BPvk5V3VnbqdkJESlv440Ac";
  48. //        $client->setDeveloperKey($api_key);
  49.         $googleCalendar->setRedirectUri($redirect_uri);
  50.         $googleCalendar->addScope(Google_Service_Calendar::CALENDAR);
  51.         $guzzleClient = new \GuzzleHttp\Client(array('curl' => array(CURLOPT_SSL_VERIFYPEER => false)));
  52.         $googleCalendar->setHttpClient($guzzleClient);
  53.         $this->googleCalendar = $googleCalendar;
  54.         $this->translator = $translator;
  55.         $this->sincGpHtAvService = $sincGpHtAvService;
  56.     }
  58.     private $sincGpHtAvService;
  60.     /**
  61.      * @Route("/createsimplelounge/{id}", name="reservations_greenpatio_create_simple_lounge")
  62.      * Crea un Reservation Lounge Simple en la cotizacion
  63.      */
  64.     public function createSimpleLoungeAction($id, EntityManagerInterface $em, Request $request)
  65.     {
  66.         $simpleLounge = $request->request->get('reservation_sala');
  67.         $loungeProfile = $em->getRepository(ReservationLoungeDetails::class)->findOneById($simpleLounge['salaPrecargadas']);
  68.         $loungeId = $loungeProfile->getId();
  69.         $loungeDetails = $em->getRepository(ReservationLoungeDetails::class)->findOneById($loungeId);
  70.         $previusLoungeSimple = $em->getRepository(ReservationLoungeSimple::class)->findOneBy(array('idLounge' => $loungeId, 'idReservation' => $id, 'rankQuote' => $simpleLounge['idQuote']));
  72.         //Buscamos si hay ya alguna sala en la reserva
  73.         $anyLoungeSimple = $em->getRepository(ReservationLoungeSimple::class)->findOneBy(array('idLounge' => $loungeId, 'idReservation' => $id));
  74.         $idioma = 1;
  75.         if($anyLoungeSimple){
  76.             $idioma = $anyLoungeSimple->getLanguage();
  77.         }
  78.         $loungeWebDescription = $em->getRepository(ReservationLoungeWebDescription::class)->findOneBy(array('lounge' => $loungeProfile, 'language' => $idioma));
  79.         $loungeName = $loungeDetails->getName();
  80.         $hourMinStart = $simpleLounge['hourStart'];
  81.         $hourMinEnd = $simpleLounge['hourEnd'];
  82.         $loungeSummaryDescription = array_key_exists('importantDescription', $simpleLounge) ? $simpleLounge['importantDescription'] : null;
  83.         if (empty($previusLoungeSimple)) {
  84.             if (empty($loungeSummaryDescription)) { $loungeSummaryDescription = $loungeWebDescription->getImportantDescription(); }
  85.             $loungeImportantDescGeneralText = $loungeWebDescription->getImportantDescGeneralText();
  86.             $loungeImportantDescSchedules = $loungeWebDescription->getImportantDescSchedules();
  87.             $loungeImportantDescParking = $loungeWebDescription->getImportantDescParking();
  88.         } else {
  89.             $loungeSummaryDescription = $previusLoungeSimple->getImportantDescription();
  90.             $loungeImportantDescGeneralText = $previusLoungeSimple->getImportantDescGeneralText();
  91.             $loungeImportantDescSchedules = $previusLoungeSimple->getImportantDescSchedules();
  92.             $loungeImportantDescParking = $previusLoungeSimple->getImportantDescParking();
  93.         }
  94.         
  95.         $iva = 21;
  96.         if (array_key_exists('iva', $simpleLounge)) {
  97.             if (empty($simpleLounge['iva']) && !is_numeric($simpleLounge['iva'])) {
  98.                 $iva = 21;
  99.             } else {
  100.                 $iva = $simpleLounge['iva'];
  101.             }
  102.         }
  104.         $qb = $em->getRepository(ReservationLoungeSimple::class)->createQueryBuilder('r');
  105.         $reservationAll = $qb->where('r.idReservation = :idReservation')
  106.             ->setParameter('idReservation', $id)
  107.             ->orderBy('r.rankQuote', 'ASC')
  108.             ->getQuery()
  109.             ->getResult();
  111.         $newRankId = (!empty($reservationAll)) ? (end($reservationAll)->getRankQuote() + 1) : 1;
  112.         if (!empty($simpleLounge['idQuote'])){ if (is_numeric($simpleLounge['idQuote'])){ $newRankId = $simpleLounge['idQuote']; } }
  114.         // Autocompletacion HH:mm en Start
  115.         switch (strlen($hourMinStart)) {
  116.             case 0:
  117.                 // Vacio
  118.                 $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  119.                 break;
  120.             case 1:
  121.                 // H  -> 0H:00
  122.                 if (is_numeric($hourMinStart)){
  123.                     $hourStart = '0'.$hourMinStart; $minStart = '00'; $hourMinStart = $hourStart.':'.$minStart;
  124.                 } else {
  125.                     $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  126.                 }
  127.                 break;
  128.             case 2:
  129.                 // HH  -> HH:00
  130.                 if (is_numeric($hourMinStart)){
  131.                     $hourStart = $hourMinStart; $minStart = '00'; $hourMinStart = $hourStart.':'.$minStart;
  132.                 } else {
  133.                     $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  134.                 }
  135.                 break;
  136.             case 3:
  137.                 // Hmm  -> 0H:mm
  138.                 if (is_numeric($hourMinStart)){
  139.                     $hourStart = '0'.substr($hourMinStart,0,1); $minStart = substr($hourMinStart,1,2); $hourMinStart = $hourStart.':'.$minStart;
  140.                 } else {
  141.                     $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  142.                 }
  143.                 break;
  144.             case 4:
  145.                 // HHmm  -> HH:mm
  146.                 if (is_numeric($hourMinStart)){
  147.                     $hourStart = substr($hourMinStart,0,2); $minStart = substr($hourMinStart,2,2); $hourMinStart = $hourStart.':'.$minStart;
  148.                 } else {
  149.                     $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  150.                 }
  151.                 break;
  152.             case 5:
  153.                 // HH:mm
  154.                 if (is_numeric(substr($hourMinStart,0,2)) and (substr($hourMinStart,2,1)==':') and is_numeric(substr($hourMinStart,0,2))){
  155.                     $hourStart = substr($hourMinStart,0,2); $minStart = substr($hourMinStart,3,2); $hourMinStart = $hourStart.':'.$minStart;
  156.                 } else {
  157.                     $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  158.                 }
  159.                 break;
  161.             default:
  162.                 // XXXXyyy
  163.                 $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  164.                 break;
  165.         }
  167.         // Autocompletacion HH:mm en End
  168.         switch (strlen($hourMinEnd)) {
  169.             case 0:
  170.                 // Vacio
  171.                 $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  172.                 break;
  173.             case 1:
  174.                 // H  -> 0H:00
  175.                 if (is_numeric($hourMinEnd)){
  176.                     $hourEnd = '0'.$hourMinEnd; $minEnd = '00'; $hourMinEnd = $hourEnd.':'.$minEnd;
  177.                 } else {
  178.                     $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  179.                 }
  180.                 break;
  181.             case 2:
  182.                 // HH  -> HH:00
  183.                 if (is_numeric($hourMinEnd)){
  184.                     $hourEnd = $hourMinEnd; $minEnd = '00'; $hourMinEnd = $hourEnd.':'.$minEnd;
  185.                 } else {
  186.                     $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  187.                 }
  188.                 break;
  189.             case 3:
  190.                 // Hmm  -> 0H:mm
  191.                 if (is_numeric($hourMinEnd)){
  192.                     $hourEnd = '0'.substr($hourMinEnd,0,1); $minEnd = substr($hourMinEnd,1,2); $hourMinEnd = $hourEnd.':'.$minEnd;
  193.                 } else {
  194.                     $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  195.                 }
  196.                 break;
  197.             case 4:
  198.                 // HHmm  -> HH:mm
  199.                 if (is_numeric($hourMinEnd)){
  200.                     $hourEnd = substr($hourMinEnd,0,2); $minEnd = substr($hourMinEnd,2,2); $hourMinEnd = $hourEnd.':'.$minEnd;
  201.                 } else {
  202.                     $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  203.                 }
  204.                 break;
  205.             case 5:
  206.                 // HH:mm
  207.                 if (is_numeric(substr($hourMinEnd,0,2)) and (substr($hourMinEnd,2,1)==':') and is_numeric(substr($hourMinEnd,0,2))){
  208.                     $hourEnd = substr($hourMinEnd,0,2); $minEnd = substr($hourMinEnd,3,2); $hourMinEnd = $hourEnd.':'.$minEnd;
  209.                 } else {
  210.                     $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  211.                 }
  212.                 break;
  214.             default:
  215.                 // XXXXyyy
  216.                 $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  217.                 break;
  218.         }
  220.         $dateStart = new DateTime($simpleLounge['dateStart'] . ' '. $hourMinStart);
  221.         $dateEnd = new DateTime($simpleLounge['dateStart'] . ' '. $hourMinEnd);   // Se usa DateStart por que solo hay un dia en el formulario
  222.         $idService = 0;
  223.         $serviceName = '';
  224.         $servicePrice = (empty($simpleLounge['servicePrice'])) ? 0 :$simpleLounge['servicePrice'];
  225.         $idReservation = $id;
  226.         /* Obtengo usuario logueado */
  227.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  228.         $user_id = $user_logueado->getId();
  229.         $createdAt = new DateTime('now');
  230.         $createdBy = $user_id;
  231.         $updatedAt = new DateTime('now');
  232.         $updatedBy = $user_id;
  233.         $pax = $simpleLounge['pax']; if (empty($pax)){$pax = 0;}
  235.         $lounge = new ReservationLoungeSimple();
  236.         $lounge->setIdLounge ($loungeId);
  237.         $lounge->setHourStart ($hourStart);
  238.         $lounge->setMinStart ($minStart);
  239.         $lounge->setHourEnd ($hourEnd);
  240.         $lounge->setMinEnd ($minEnd);
  241.         $lounge->setLoungeName ($loungeName);
  242.         $lounge->setDateStart ($dateStart);
  243.         $lounge->setDateEnd ($dateEnd);
  244.         $lounge->setRankQuote(1);
  245.         $lounge->setIdReservation ($idReservation);
  246.         $lounge->setIva($iva);
  247.         $lounge->setOpIva(1);
  248.         $lounge->setCreatedAt ($createdAt);
  249.         $lounge->setCreatedBy ($createdBy);
  250.         $lounge->setUpdatedAt ($updatedAt);
  251.         $lounge->setUpdatedBy ($updatedBy);
  252.         $lounge->setPax ($pax);
  253.         $lounge->setRankQuote($newRankId);
  254.         $lounge->setImportantDescription($loungeSummaryDescription);
  255.         $lounge->setImportantDescGeneralText($loungeImportantDescGeneralText);
  256.         $lounge->setImportantDescSchedules($loungeImportantDescSchedules);
  257.         $lounge->setImportantDescParking($loungeImportantDescParking);
  259.         $price = $this->precioTarifario($dateStart, $loungeId, $servicePrice);
  261.         $lounge->setServicePrice($price);
  263.         try{
  264.             $em->persist($lounge);
  265.             $em->flush();
  266.             $event = 'The Reservation has been updated.';
  267.             $successMessage = $this->translator->trans($event);
  268.             $this->addFlash('mensajereservation', $successMessage);
  269.         } catch (\Exception $e){
  270.             $event = 'An error occurred: '.$e->getMessage();
  271.             $errorMessage = $this->translator->trans($event);
  272.             $this->addFlash('mensajereservationerror', $errorMessage);
  273.         }
  275.         // INICIO: Actualizacion de fecha de inicio y fin del evento, a partir de la info de la sala
  276.         $boolSincGpAv = false;
  277.         $reserva = $em->getRepository(Reservation::class)->findOneById($idReservation);
  279.         if ($reserva->getDateStart() > $dateStart){ $reserva->setDateStart($dateStart); $boolSincGpAv = true; }
  280.         if ($reserva->getDateStart()->format('Y') == '2078' ){ $reserva->setDateStart($dateStart); $boolSincGpAv = true; }
  281.         if ($reserva->getDateEnd() < $dateEnd){ $reserva->setDateEnd($dateEnd); $boolSincGpAv = true; }
  282.         if ($reserva->getDateEnd()->format('Y') == '2000' ){ $reserva->setDateEnd($dateEnd); $boolSincGpAv = true; }
  284.         try{
  285.             $em->persist($reserva);
  286.             $em->flush();
  287.             $event = '';
  288.             $successMessage = $this->translator->trans($event);
  289.             $this->addFlash('mensajereservation', $successMessage);
  291.         } catch (\Exception $e){}
  293.         // Sincronización global de todos los campos
  294.         if ($boolSincGpAv){
  295.             $data = $this->sincGpHtAvService->sincGlobalGpHtAv($id);
  296.         }
  298.         // Sincronización con Av Express
  299.         if ($boolSincGpAv) {
  300.             $AveFile = $em->getRepository(AveFiles::class)->findByReservation($reserva);
  301.             if (($reserva->getStatus() == 'Confirmed') or ($reserva->getStatus() == 'Cotizado') or ($reserva->getStatus() == 'Invoiced') or ($reserva->getStatus() == 'Bloqueo')) {
  302.                 if (empty($AveFile)) {
  303.                     // Si no se ha creado aun el expediente de Av Express debemos crearlo
  304.                     return $this->redirectToRoute('sinc_gp_ave', array('id' => $id,));
  305.                 }
  306.             }
  307.         }
  308.         // FIN: Actualizacion de fecha de inicio y fin del evento, a partir de la info de la sala
  310.         // Se debe redirigir para agregar el Servicio de limpieza
  312.         return $this->redirectToRoute('reservations_white_addservices_cleaning',
  313.             array(
  314.                 'resid' => $id,
  315.                 'loungesimpleid' => $lounge->getId(),
  316.             ));
  317.     }
  320.     /**
  321.      * @Route("/api/get-price", name="get_reservations_price_to_view", methods={"GET"})
  322.      */
  323.     public function getPrice(Request $request)
  324.     {
  325.         $loungeId = $request->query->get('sala');
  326.         $dateStart = $request->query->get('date');
  328.         if (!$loungeId || !$dateStart) {
  329.             return new JsonResponse(['error' => 'Missing parameters'], 400);
  330.         }
  332.         try {
  333.             $dateStartObj = new \DateTime($dateStart);
  334.         } catch (\Exception $e) {
  335.             return new JsonResponse(['error' => 'Invalid date'], 400);
  336.         }
  338.         $price = $this->precioTarifario($dateStartObj, $loungeId, 0);
  340.         return new JsonResponse(['price' => $price]);
  341.     }
  344.     /**
  345.      * @Route("/createsimpleloungemondes/{id}", name="reservations_greenpatio_create_simple_lounge_mondes")
  346.      * Se crea un dia de montaje o desmontaje
  347.      */
  348.     public function createSimpleLoungeMonDesAction($id, EntityManagerInterface $em, Request $request)
  349.     {
  350.         $simpleLounge = $request->request->get('reservation_sala_mondes');
  351.         $loungeId = $simpleLounge['idLounge'];
  352.         $loungeDetails = $em->getRepository(ReservationLoungeDetails::class)->findOneById($loungeId);
  353.         $previusLoungeSimple = $em->getRepository(ReservationLoungeSimple::class)->findOneBy(array('idLounge' => $loungeId, 'idReservation' => $id, 'rankQuote' => $simpleLounge['idQuote']));
  354.         $loungeName = $loungeDetails->getName();
  355.         $hourMinStart = $simpleLounge['hourStart'];
  356.         $hourMinEnd = $simpleLounge['hourEnd'];
  357.         $ivaNew = empty($simpleLounge['iva']) ? 21 : $simpleLounge['iva'];
  358.         if (empty($previusLoungeSimple)) {
  359.             $loungeSummaryDescription = $loungeDetails->getImportantDescription();
  360.             $loungeImportantDescGeneralText = $loungeDetails->getImportantDescGeneralText();
  361.             $loungeImportantDescSchedules = $loungeDetails->getImportantDescSchedules();
  362.             $loungeImportantDescParking = $loungeDetails->getImportantDescParking();
  363.         } else {
  364.             $loungeSummaryDescription = $previusLoungeSimple->getImportantDescription();
  365.             $loungeImportantDescGeneralText = $previusLoungeSimple->getImportantDescGeneralText();
  366.             $loungeImportantDescSchedules = $previusLoungeSimple->getImportantDescSchedules();
  367.             $loungeImportantDescParking = $previusLoungeSimple->getImportantDescParking();
  368.         }
  370.         $qb = $em->getRepository(ReservationLoungeSimple::class)->createQueryBuilder('r');
  371.         $reservationAll = $qb->where('r.idReservation = :idReservation')
  372.             ->setParameter('idReservation', $id)
  373.             ->orderBy('r.rankQuote', 'ASC')
  374.             ->getQuery()
  375.             ->getResult();
  377.         $newRankId = (!empty($reservationAll)) ? (end($reservationAll)->getRankQuote() + 1) : 1;
  378.         if (!empty($simpleLounge['idQuote'])){ if (is_numeric($simpleLounge['idQuote'])){ $newRankId = $simpleLounge['idQuote']; } }
  380.         // Autocompletacion HH:mm en Start
  381.         switch (strlen($hourMinStart)) {
  382.             case 0:
  383.                 // Vacio
  384.                 $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  385.                 break;
  386.             case 1:
  387.                 // H  -> 0H:00
  388.                 if (is_numeric($hourMinStart)){
  389.                     $hourStart = '0'.$hourMinStart; $minStart = '00'; $hourMinStart = $hourStart.':'.$minStart;
  390.                 } else {
  391.                     $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  392.                 }
  393.                 break;
  394.             case 2:
  395.                 // HH  -> HH:00
  396.                 if (is_numeric($hourMinStart)){
  397.                     $hourStart = $hourMinStart; $minStart = '00'; $hourMinStart = $hourStart.':'.$minStart;
  398.                 } else {
  399.                     $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  400.                 }
  401.                 break;
  402.             case 3:
  403.                 // Hmm  -> 0H:mm
  404.                 if (is_numeric($hourMinStart)){
  405.                     $hourStart = '0'.substr($hourMinStart,0,1); $minStart = substr($hourMinStart,1,2); $hourMinStart = $hourStart.':'.$minStart;
  406.                 } else {
  407.                     $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  408.                 }
  409.                 break;
  410.             case 4:
  411.                 // HHmm  -> HH:mm
  412.                 if (is_numeric($hourMinStart)){
  413.                     $hourStart = substr($hourMinStart,0,2); $minStart = substr($hourMinStart,2,2); $hourMinStart = $hourStart.':'.$minStart;
  414.                 } else {
  415.                     $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  416.                 }
  417.                 break;
  418.             case 5:
  419.                 // HH:mm
  420.                 if (is_numeric(substr($hourMinStart,0,2)) and (substr($hourMinStart,2,1)==':') and is_numeric(substr($hourMinStart,0,2))){
  421.                     $hourStart = substr($hourMinStart,0,2); $minStart = substr($hourMinStart,3,2); $hourMinStart = $hourStart.':'.$minStart;
  422.                 } else {
  423.                     $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  424.                 }
  425.                 break;
  427.             default:
  428.                 // XXXXyyy
  429.                 $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  430.                 break;
  431.         }
  433.         // Autocompletacion HH:mm en End
  434.         switch (strlen($hourMinEnd)) {
  435.             case 0:
  436.                 // Vacio
  437.                 $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  438.                 break;
  439.             case 1:
  440.                 // H  -> 0H:00
  441.                 if (is_numeric($hourMinEnd)){
  442.                     $hourEnd = '0'.$hourMinEnd; $minEnd = '00'; $hourMinEnd = $hourEnd.':'.$minEnd;
  443.                 } else {
  444.                     $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  445.                 }
  446.                 break;
  447.             case 2:
  448.                 // HH  -> HH:00
  449.                 if (is_numeric($hourMinEnd)){
  450.                     $hourEnd = $hourMinEnd; $minEnd = '00'; $hourMinEnd = $hourEnd.':'.$minEnd;
  451.                 } else {
  452.                     $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  453.                 }
  454.                 break;
  455.             case 3:
  456.                 // Hmm  -> 0H:mm
  457.                 if (is_numeric($hourMinEnd)){
  458.                     $hourEnd = '0'.substr($hourMinEnd,0,1); $minEnd = substr($hourMinEnd,1,2); $hourMinEnd = $hourEnd.':'.$minEnd;
  459.                 } else {
  460.                     $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  461.                 }
  462.                 break;
  463.             case 4:
  464.                 // HHmm  -> HH:mm
  465.                 if (is_numeric($hourMinEnd)){
  466.                     $hourEnd = substr($hourMinEnd,0,2); $minEnd = substr($hourMinEnd,2,2); $hourMinEnd = $hourEnd.':'.$minEnd;
  467.                 } else {
  468.                     $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  469.                 }
  470.                 break;
  471.             case 5:
  472.                 // HH:mm
  473.                 if (is_numeric(substr($hourMinEnd,0,2)) and (substr($hourMinEnd,2,1)==':') and is_numeric(substr($hourMinEnd,0,2))){
  474.                     $hourEnd = substr($hourMinEnd,0,2); $minEnd = substr($hourMinEnd,3,2); $hourMinEnd = $hourEnd.':'.$minEnd;
  475.                 } else {
  476.                     $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  477.                 }
  478.                 break;
  480.             default:
  481.                 // XXXXyyy
  482.                 $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  483.                 break;
  484.         }
  486.         $dateStart = new DateTime($simpleLounge['dateStart'] . ' '. $hourMinStart);
  487.         $dateEnd = new DateTime($simpleLounge['dateStart'] . ' '. $hourMinEnd);   // Se usa DateStart por que solo hay un dia en el formulario
  488.         $servicePrice = empty($simpleLounge['servicePrice']) ? 0 :$simpleLounge['servicePrice'];
  489.         $idReservation = $id;
  490.         /* Obtengo usuario logueado */
  491.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  492.         $user_id = $user_logueado->getId();
  493.         $createdAt = new DateTime('now');
  494.         $createdBy = $user_id;
  495.         $updatedAt = new DateTime('now');
  496.         $updatedBy = $user_id;
  497.         $lounge = new ReservationLoungeSimple();
  499.         if ($simpleLounge['type'] == 'Montaje'){ $lounge->setType ('Montaje'); } else {  $lounge->setType ('Desmontaje'); }
  500.         $pax = null;
  501.         $lounge->setIdLounge ($loungeId);
  502.         $lounge->setHourStart ($hourStart);
  503.         $lounge->setMinStart ($minStart);
  504.         $lounge->setHourEnd ($hourEnd);
  505.         $lounge->setMinEnd ($minEnd);
  506.         $lounge->setLoungeName ($loungeName);
  507.         $lounge->setDateStart ($dateStart);
  508.         $lounge->setDateEnd ($dateEnd);
  509.         $lounge->setRankQuote(1);
  510.         $lounge->setIva($ivaNew);
  511.         $lounge->setOpIva(1);
  512.         $lounge->setIdReservation ($idReservation);
  513.         $lounge->setCreatedAt ($createdAt);
  514.         $lounge->setCreatedBy ($createdBy);
  515.         $lounge->setUpdatedAt ($updatedAt);
  516.         $lounge->setUpdatedBy ($updatedBy);
  517.         $lounge->setPax ($pax);
  518.         $lounge->setRankQuote($newRankId);
  519.         $lounge->setImportantDescription($loungeSummaryDescription);
  520.         $lounge->setImportantDescGeneralText($loungeImportantDescGeneralText);
  521.         $lounge->setImportantDescSchedules($loungeImportantDescSchedules);
  522.         $lounge->setImportantDescParking($loungeImportantDescParking);
  524.         $price = $this->precioPorFecha($dateStart, $loungeId);
  525.         $servicePrice = ($price['price'] == 0) ? $servicePrice : $price;
  526.         $lounge->setServicePrice($servicePrice);
  528.         try{
  529.             $em->persist($lounge);
  530.             $em->flush();
  531.             $event = 'The Reservation has been updated.';
  532.             $successMessage = $this->translator->trans($event);
  533.             $this->addFlash('mensajereservation', $successMessage);
  535.         } catch (\Exception $e){
  537.             $event = 'An error occurred: '.$e->getMessage();
  538.             $errorMessage = $this->translator->trans($event);
  539.             $this->addFlash('mensajereservationerror', $errorMessage);
  540.         }
  542.         $reservax = $em->getRepository(Reservation::class)->findOneById($idReservation);
  544.         // INICIO: Verificamos si es necesario actualizar las fechas de la reserva
  545.         $boolReserva = false;
  546.         if ($lounge->getDateStart() < $reservax->getDateStart()){
  547.             $reservax->setDateStart($lounge->getDateStart());
  548.             $boolReserva = true;
  549.         }
  551.         if ($reservax->getDateEnd() < $lounge->getDateEnd()){
  552.             $reservax->setDateEnd($lounge->getDateEnd());
  553.             $boolReserva = true;
  554.         }
  555.         if ($boolReserva){
  556.             $em->persist($reservax);
  557.             $em->flush();
  559.             // Sincronización global de todos los campos
  560.             $data = $this->sincGpHtAvService->sincGlobalGpHtAv($id);
  561.         }
  562.         $boolSincGpAv = $boolReserva;
  563.         // Sincronización con Av Express
  564.         if ($boolSincGpAv) {
  565.             $AveFile = $em->getRepository(AveFiles::class)->findByReservation($reservax);
  566.             if (($reservax->getStatus() == 'Confirmed') or ($reservax->getStatus() == 'Cotizado') or ($reservax->getStatus() == 'Invoiced') or ($reservax->getStatus() == 'Bloqueo')) {
  567.                 if (empty($AveFile)) {
  568.                     // Si no se ha creado aun el expediente de Av Express debemos crearlo
  569.                     return $this->redirectToRoute('sinc_gp_ave', array('id' => $id,));
  570.                 }
  571.             }
  572.         }
  573.         // FIN: Verificamos si es necesario actualizar las fechas de la reserva
  575.         return $this->redirectToRoute('reservations_greenpatio_edit_simple',
  576.             array(
  577.                 'id' => $id,
  578.                 'token' => null,
  579.                 '_fragment' => 'btn_quotes'
  580.             ));
  581.     }
  584.     /**
  585.      * @Route("/duplicateday/{id}/{dayduplicate}/{idRankQuote}", name="reservations_greenpatio_duplicate_day")
  586.      * Duplica un elemento de la cotizacion para el dia siguiente
  587.      */
  588.     public function duplicateDayAction($id, $dayduplicate, $idRankQuote, EntityManagerInterface $em, Request $request)
  589.     {
  590.         $loungeSimples = $em->getRepository(ReservationLoungeSimple::class)->findByIdReservation($id);
  591.         $reservax = $em->getRepository(Reservation::class)->findOneById($id);
  593.         /* Obtengo usuario logueado */
  594.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  595.         $user_id = $user_logueado->getId();
  596.         $createdAt = new DateTime('now');
  597.         $createdBy = $user_id;
  598.         $updatedAt = new DateTime('now');
  599.         $updatedBy = $user_id;
  601.         if (!empty($loungeSimples)){
  602.             foreach ($loungeSimples as $item){
  603.                 if (($item->getDateStart()->format('d-m-Y') == $dayduplicate) and ($item->getRankQuote() == $idRankQuote)){
  604.                     // Se duplica y suma un dia
  605.                     $newLoungeSimple = new ReservationLoungeSimple();
  606.                     $newLoungeSimple->setDateStart($item->getDateStart()->modify('+1 day'));
  607.                     $newLoungeSimple->setDateEnd($item->getDateEnd()->modify('+1 day'));
  608.                     $newLoungeSimple->setHourStart($item->getHourStart());
  609.                     $newLoungeSimple->setHourEnd($item->getHourEnd());
  610.                     $newLoungeSimple->setMinStart($item->getMinStart());
  611.                     $newLoungeSimple->setMinEnd($item->getMinEnd());
  612.                     $newLoungeSimple->setIdLounge($item->getIdLounge());
  613.                     $newLoungeSimple->setIdReservation($item->getIdReservation());
  614.                     $newLoungeSimple->setLoungeName($item->getLoungeName());
  615.                     $newLoungeSimple->setPax($item->getPax());
  616.                     $newLoungeSimple->setServicePrice($item->getServicePrice());
  617.                     $newLoungeSimple->setIva($item->getIva());
  618.                     $newLoungeSimple->setOpIva($item->getOpIva());
  619.                     $newLoungeSimple->setType($item->getType());
  620.                     $newLoungeSimple->setLoungeDescription($item->getLoungeDescription());
  621.                     $newLoungeSimple->setImportantDescription($item->getImportantDescription());
  622.                     $newLoungeSimple->setImportantDescGeneralText($item->getImportantDescGeneralText());
  623.                     $newLoungeSimple->setImportantDescSchedules($item->getImportantDescSchedules());
  624.                     $newLoungeSimple->setImportantDescParking($item->getImportantDescParking());
  625.                     $newLoungeSimple->setRankQuote($idRankQuote);
  626.                     $newLoungeSimple->setCreatedAt($createdAt);
  627.                     $newLoungeSimple->setCreatedBy($createdBy);
  628.                     $newLoungeSimple->setUpdatedAt($updatedAt);
  629.                     $newLoungeSimple->setUpdatedBy($updatedBy);
  631.                     try{
  632.                         $em->persist($newLoungeSimple);
  633.                         $em->flush();
  634.                         $event = 'The Item has been duplicated.';
  635.                         $successMessage = $this->translator->trans($event);
  636.                         $this->addFlash('mensajereservation', $successMessage);
  638.                     } catch (\Exception $e){
  640.                         $event = 'An error occurred: '.$e->getMessage();
  641.                         $errorMessage = $this->translator->trans($event);
  642.                         $this->addFlash('mensajereservationerror', $errorMessage);
  643.                     }
  645.                     // INICIO: Verificamos si es necesario actualizar las fechas de la reserva
  646.                     $boolReserva = false;
  647.                     if ($newLoungeSimple->getDateStart() < $reservax->getDateStart()){
  648.                         $reservax->setDateStart($newLoungeSimple->getDateStart());
  649.                         $boolReserva = true;
  650.                     }
  652.                     if ($reservax->getDateEnd() < $newLoungeSimple->getDateEnd()){
  653.                         $reservax->setDateEnd($newLoungeSimple->getDateEnd());
  654.                         $boolReserva = true;
  655.                     }
  656.                     if ($boolReserva){
  657.                         $em->persist($reservax);
  658.                         $em->flush();
  660.                         // Sincronización global de todos los campos
  661.                         $data = $this->sincGpHtAvService->sincGlobalGpHtAv($id);
  662.                     }
  663.                     // FIN: Verificamos si es necesario actualizar las fechas de la reserva
  664.                 }
  665.             }
  666.         } else {
  667.             // registro antiguo, se pasara a los nuevos registros y luego duplicara
  668.             $loungeOld = $em->getRepository(ReservationLounge::class)->findByIdReservation($id);
  669.             foreach ($loungeOld as $item){
  670.                 if ($item->getDateStart()->format('Y-m-d') == $item->getDateEnd()->format('Y-m-d')){
  671.                     // Es el mismo dia, se crea un registro simple
  672.                     $newLoungeSimple = new ReservationLoungeSimple();
  673.                     $newLoungeSimple->setDateStart($item->getDateStart());
  674.                     $newLoungeSimple->setDateEnd($item->getDateEnd());
  675.                     $newLoungeSimple->setHourStart($item->getHourStart());
  676.                     $newLoungeSimple->setHourEnd($item->getHourEnd());
  677.                     $newLoungeSimple->setMinStart($item->getMinStart());
  678.                     $newLoungeSimple->setMinEnd($item->getMinEnd());
  679.                     $newLoungeSimple->setIdLounge($item->getIdLounge());
  680.                     $newLoungeSimple->setIdReservation($item->getIdReservation());
  681.                     $newLoungeSimple->setLoungeName($item->getLoungeName());
  682.                     $newLoungeSimple->setPax($item->getPax());
  683.                     $newLoungeSimple->setServicePrice($item->getServicePrice());
  684.                     $newLoungeSimple->setIva($item->getIva());
  685.                     $newLoungeSimple->setOpIva($item->getOpIva());
  686.                     $newLoungeSimple->setType($item->getType());
  687.                     $newLoungeSimple->setRankQuote($item->getRankQuote());
  688.                     $newLoungeSimple->setLoungeDescription($item->getLoungeDescription());
  689.                     $newLoungeSimple->setImportantDescription($item->getImportantDescription());
  690.                     $newLoungeSimple->setCreatedAt($createdAt);
  691.                     $newLoungeSimple->setCreatedBy($createdBy);
  692.                     $newLoungeSimple->setUpdatedAt($updatedAt);
  693.                     $newLoungeSimple->setUpdatedBy($updatedBy);
  695.                     try{
  696.                         $em->persist($newLoungeSimple);
  697.                         $em->flush();
  698.                         $event = 'The Item has been duplicated.';
  699.                         $successMessage = $this->translator->trans($event);
  700.                         $this->addFlash('mensajereservation', $successMessage);
  702.                     } catch (\Exception $e){
  704.                         $event = 'An error occurred: '.$e->getMessage();
  705.                         $errorMessage = $this->translator->trans($event);
  706.                         $this->addFlash('mensajereservationerror', $errorMessage);
  707.                     }
  709.                     // INICIO: Verificamos si es necesario actualizar las fechas de la reserva
  710.                     $boolReserva = false;
  711.                     if ($newLoungeSimple->getDateStart() < $reservax->getDateStart()){
  712.                         $reservax->setDateStart($newLoungeSimple->getDateStart());
  713.                         $boolReserva = true;
  714.                     }
  716.                     if ($reservax->getDateEnd() < $newLoungeSimple->getDateEnd()){
  717.                         $reservax->setDateEnd($newLoungeSimple->getDateEnd());
  718.                         $boolReserva = true;
  719.                     }
  720.                     if ($boolReserva){
  721.                         $em->persist($reservax);
  722.                         $em->flush();
  723.                     }
  724.                     // FIN: Verificamos si es necesario actualizar las fechas de la reserva
  726.                 } else {
  727.                     // Registro con varios dias, se calcula el numero de dias y se crean ese numero de registros nuevos
  728.                     $firstDay = $item->getDateStart();
  729.                     $firstDay = new DateTime($firstDay->format('Y-m-d'));
  730.                     $lastDay = $item->getDateEnd();
  731.                     $lastDay = new DateTime($lastDay->format('Y-m-d'));
  732.                     $numDays = ((($lastDay)->diff($firstDay))->days) +1;
  733.                     $actualDay = $item->getDateStart();
  734.                     $actualStartDay = $item->getDateStart();
  735.                     $actualEndDay = $item->getDateEnd();
  737.                     for ($i=0; $i<sizeof($numDays); $i++){
  738.                         // Se crea un registro por cada dia
  739.                         $newLoungeSimple = new ReservationLoungeSimple();
  740.                         if ($i == 0){
  741.                             // Primer dia
  742.                             $newLoungeSimple->setDateStart($actualStartDay);
  743.                             $actualStartDayEnd = new DateTime($actualStartDay->format('Y-m-d').' 23:59');
  744.                             $newLoungeSimple->setDateEnd($actualStartDayEnd);
  745.                             $newLoungeSimple->setHourStart($item->getHourStart());
  746.                             $newLoungeSimple->setHourEnd('23');
  747.                             $newLoungeSimple->setMinStart($item->getMinStart());
  748.                             $newLoungeSimple->setMinEnd('59');
  750.                         } else {
  751.                             if (($i + 1) == sizeof($numDays)){
  752.                                 // Ultimo dia
  753.                                 $actualEndDayStart = new DateTime($actualEndDay->format('Y-m-d').' 00:00');
  754.                                 $newLoungeSimple->setDateStart($actualEndDayStart);
  755.                                 $newLoungeSimple->setDateEnd($actualEndDay);
  756.                                 $newLoungeSimple->setHourStart('00');
  757.                                 $newLoungeSimple->setHourEnd($item->getHourEnd());
  758.                                 $newLoungeSimple->setMinStart('00');
  759.                                 $newLoungeSimple->setMinEnd($item->getMinEnd());
  761.                             } else {
  762.                                 // Dia intermedio
  763.                                 $actualMidDayStart = new DateTime($actualDay->format('Y-m-d').' 00:00');
  764.                                 $actualMidDayEnd = new DateTime($actualDay->format('Y-m-d').' 23:59');
  765.                                 $newLoungeSimple->setDateStart($actualMidDayStart);
  766.                                 $newLoungeSimple->setDateEnd($actualMidDayEnd);
  767.                                 $newLoungeSimple->setHourStart('00');
  768.                                 $newLoungeSimple->setHourEnd('23');
  769.                                 $newLoungeSimple->setMinStart('00');
  770.                                 $newLoungeSimple->setMinEnd('59');
  771.                             }
  772.                         }
  773.                         $newLoungeSimple->setIdLounge($item->getIdLounge());
  774.                         $newLoungeSimple->setIdReservation($item->getIdReservation());
  775.                         $newLoungeSimple->setLoungeName($item->getLoungeName());
  776.                         $newLoungeSimple->setPax($item->getPax());
  777.                         $newLoungeSimple->setServicePrice($item->getServicePrice());
  778.                         $newLoungeSimple->setIva($item->getIva());
  779.                         $newLoungeSimple->setOpIva($item->getOpIva());
  780.                         $newLoungeSimple->setType($item->getType());
  781.                         $newLoungeSimple->setRankQuote($item->getRankQuote());
  782.                         $newLoungeSimple->setLoungeDescription($item->getLoungeDescription());
  783.                         $newLoungeSimple->setImportantDescription($item->getImportantDescription());
  784.                         $newLoungeSimple->setCreatedAt($createdAt);
  785.                         $newLoungeSimple->setCreatedBy($createdBy);
  786.                         $newLoungeSimple->setUpdatedAt($updatedAt);
  787.                         $newLoungeSimple->setUpdatedBy($updatedBy);
  788.                         $actualDay = $actualDay->modify('+1 day');
  790.                         try{
  791.                             $em->persist($newLoungeSimple);
  792.                             $em->flush();
  793.                             $event = 'The Item has been updated.';
  794.                             $successMessage = $this->translator->trans($event);
  795.                             $this->addFlash('mensajereservation', $successMessage);
  797.                         } catch (\Exception $e){
  799.                             $event = 'An error occurred: '.$e->getMessage();
  800.                             $errorMessage = $this->translator->trans($event);
  801.                             $this->addFlash('mensajereservationerror', $errorMessage);
  802.                         }
  804.                         // INICIO: Verificamos si es necesario actualizar las fechas de la reserva
  805.                         $boolReserva = false;
  806.                         if ($newLoungeSimple->getDateStart() < $reservax->getDateStart()){
  807.                             $reservax->setDateStart($newLoungeSimple->getDateStart());
  808.                             $boolReserva = true;
  809.                         }
  811.                         if ($reservax->getDateEnd() < $newLoungeSimple->getDateEnd()){
  812.                             $reservax->setDateEnd($newLoungeSimple->getDateEnd());
  813.                             $boolReserva = true;
  814.                         }
  815.                         if ($boolReserva){
  816.                             $em->persist($reservax);
  817.                             $em->flush();
  818.                         }
  819.                         // FIN: Verificamos si es necesario actualizar las fechas de la reserva
  820.                     }
  821.                 }
  822.             }
  824.             // Se vuelve a llamar a este mismo controlador ahora con los registros en la nueva tabla
  825.             return $this->redirectToRoute('reservations_greenpatio_duplicate_day', array( 'id' => $id, 'dayduplicate' => $dayduplicate, ));
  826.         }
  828.         // Se debe redirigir para agregar el Servicio de limpieza
  829.         return $this->redirectToRoute('reservations_white_addservices_cleaning',
  830.             array(
  831.                 'resid' => $id,
  832.                 'loungesimpleid' => $newLoungeSimple->getId(),
  833.             ));
  834.     }
  837.     /**
  838.      * @Route("/deleteitemsimple/{id}/{daydelete}", name="reservations_greenpatio_delete_simple_lounge")
  839.      * Elimina un Reservation Simple Lounge de la cotizacion
  840.      */
  841.     public function deleteSimpleLoungeAction($id, $daydelete, EntityManagerInterface $em, Request $request)
  842.     {
  843.         $loungeSimple = $em->getRepository(ReservationLoungeSimple::class)->findOneById($id);
  844.         $id = $loungeSimple->getIdReservation();
  845.         $reserva = $em->getRepository(Reservation::class)->findOneById($loungeSimple->getIdReservation());
  847.         try{
  848.             $em->remove($loungeSimple);
  849.             $em->flush();
  850.             $event = 'The item has been deleted.';
  851.             $successMessage = $this->translator->trans($event);
  852.             $this->addFlash('mensajereservation', $successMessage);
  853.         } catch (\Exception $e){
  854.             $event = 'An error occurred: '.$e->getMessage();
  855.             $errorMessage = $this->translator->trans($event);
  856.             $this->addFlash('mensajereservationerror', $errorMessage);
  857.         }
  859.         // Si se elimina el primer dia o el ultimo, se debe modificar las fechas de la reserva
  860.         if(($reserva->getDateStart()->format('Ymd') == $loungeSimple->getDateStart()->format('Ymd')) or ($reserva->getDateEnd()->format('Ymd') == $loungeSimple->getDateEnd()->format('Ymd'))){
  861.             $allLoungeSimples = $em->getRepository(ReservationLoungeSimple::class)->findByIdReservation($reserva->getId());
  862.             if (!empty($allLoungeSimples)){
  863.                 $reserva->setDateStart(new DateTime('2078-01-01'));
  864.                 $reserva->setDateEnd(new DateTime('2000-01-01'));
  866.                 foreach ($allLoungeSimples as $newLoungeSimple){
  867.                     // INICIO: Verificamos si es necesario actualizar las fechas de la reserva
  868.                     $boolReserva = false;
  869.                     if ($newLoungeSimple->getDateStart() < $reserva->getDateStart()){
  870.                         $reserva->setDateStart($newLoungeSimple->getDateStart());
  871.                         $boolReserva = true;
  872.                     }
  874.                     if ($reserva->getDateEnd() < $newLoungeSimple->getDateEnd()){
  875.                         $reserva->setDateEnd($newLoungeSimple->getDateEnd());
  876.                         $boolReserva = true;
  877.                     }
  878.                     if ($boolReserva){
  879.                         $em->persist($reserva);
  880.                         $em->flush();
  881.                     }
  882.                     // FIN: Verificamos si es necesario actualizar las fechas de la reserva
  883.                 }
  884.             } else {
  885.                 // Se elimino la ultima sala y la reserva queda vacia
  886.                 $reserva->setDateStart(new DateTime('2078-01-01'));
  887.                 $reserva->setDateEnd(new DateTime('2000-01-01'));
  889.                 $em->persist($reserva);
  890.                 $em->flush();
  891.             }
  893.             // Sincronización global de todos los campos
  894.             $data = $this->sincGpHtAvService->sincGlobalGpHtAv($reserva->getId());
  895.         }
  897.         // Se elimina el servicio de horas de limpieza de la sala
  898.         return $this->redirectToRoute('reservations_greenpatio_delete_simple_lounge_cleaning',
  899.             array(
  900.                 'idRes' => $id,
  901.                 'idLng' => $loungeSimple->getIdLounge(),
  902.                 'dateInAt' => $loungeSimple->getDateStart()->format('Y-m-d\TH:i'),
  903.                 'dateOutAt' => $loungeSimple->getDateEnd()->format('Y-m-d\TH:i'),
  904.             ));
  905.     }
  908.     /**
  909.      * @Route("/deletequote/{idRes}/{idQuote}", name="reservations_delete_quote")
  910.      * Eliminar una cotizancion
  911.      */
  912.     public function deleteQuoteAction( $idRes, $idQuote, EntityManagerInterface $em, Request $request)
  913.     {
  914.         $qb = $em->getRepository(ReservationLoungeSimple::class)->createQueryBuilder('r');
  915.         $reservation = $qb->where('r.rankQuote = :rankQuote')
  916.             ->andWhere('r.idReservation = :idReservation')
  917.             ->setParameter('idReservation', $idRes)
  918.             ->setParameter('rankQuote', $idQuote)
  919.             ->getQuery()
  920.             ->getResult();
  922.         foreach ($reservation as $item){
  923.             try{
  924.                 $em->remove($item);
  925.                 $em->flush();
  926.                 $event = 'Se ha eliminado la cotización';
  927.                 $successMessage = $this->translator->trans($event);
  928.                 $this->addFlash('mensajereservation', $successMessage);
  929.             } catch (\Exception $e){
  930.                 $event = 'An error occurred: '.$e->getMessage();
  931.                 $errorMessage = $this->translator->trans($event);
  932.                 $this->addFlash('mensajereservationerror', $errorMessage);
  933.             }
  935.             //Se deben eliminar todas las horas de limpieza asociadas a las salas de la cotización
  936.             $loungeDetails = $em->getRepository(ReservationLoungeDetails::class)->findOneById($item->getIdLounge());
  937.             $stringName = 'HORAS ( '.$loungeDetails->getName().' )';
  938.             $serviceCatIdClean = 21;
  939.             $dateInAt = new \DateTime($item->getDateStart()->format('Y-m-d\TH:i'));
  940.             $dateOutAt = new \DateTime($item->getDateEnd()->format('Y-m-d\TH:i'));
  942.             $qb = $em->getRepository(ReservationService::class)->createQueryBuilder('rs');
  944.             $serviceClean = $qb->where('rs.reservationId = :id')
  945.                 ->andWhere('rs.name = :name')
  946.                 ->andWhere('rs.dateInAt = :dateInAt')
  947.                 ->andWhere('rs.dateOutAt = :dateOutAt')
  948.                 ->andWhere('rs.serviceCatId = :serviceCatId')
  949.                 ->setParameter('id', $idRes)
  950.                 ->setParameter('name', $stringName)
  951.                 ->setParameter('dateInAt', $dateInAt)
  952.                 ->setParameter('dateOutAt', $dateOutAt)
  953.                 ->setParameter('serviceCatId', $serviceCatIdClean)
  954.                 ->getQuery()
  955.                 ->getResult();
  957.             if (!empty($serviceClean)) {
  958.                 // Se elimina el servicio de horas de limpieza de la sala
  959.                 $em->remove($serviceClean[0]);
  960.                 $em->flush();
  961.             }
  962.         }
  964.         // Recalculo de fechas del expediente
  965.         $data = $this->recalculoFechas($idRes);
  967.         // Sincronización global de todos los campos
  968.         $data = $this->sincGpHtAvService->sincGlobalGpHtAv($idRes);
  970.         return $this->redirectToRoute('reservations_greenpatio_edit_simple',
  971.             array(
  972.                 'id' => $idRes,
  973.                 'token' => null,
  974.                 '_fragment' => 'btn_quotes'
  975.             ));
  976.     }
  979.     /**
  980.      * @Route("/checkquote/{idRes}/{idQuote}", name="reservations_check_quote")
  981.      * Confirmación de que se ha aceptado la cotizancion, se eliminaran las otras cotizaciones del expediente
  982.      */
  983.     public function checkQuoteAction( $idRes, $idQuote, EntityManagerInterface $em, Request $request)
  984.     {
  985.         $qb = $em->getRepository(ReservationLoungeSimple::class)->createQueryBuilder('r');
  986.         $reservation = $qb->where('r.rankQuote <> :rankQuote')
  987.             ->andWhere('r.idReservation = :idReservation')
  988.             ->setParameter('idReservation', $idRes)
  989.             ->setParameter('rankQuote', $idQuote)
  990.             ->getQuery()
  991.             ->getResult();
  993.         foreach ($reservation as $item){
  994.             try{
  995.                 $em->remove($item);
  996.                 $em->flush();
  997.                 $event = 'Se han eliminado las otras cotizaciones';
  998.                 $successMessage = $this->translator->trans($event);
  999.                 $this->addFlash('mensajereservation', $successMessage);
  1000.             } catch (\Exception $e){
  1001.                 $event = 'An error occurred: '.$e->getMessage();
  1002.                 $errorMessage = $this->translator->trans($event);
  1003.                 $this->addFlash('mensajereservationerror', $errorMessage);
  1004.             }
  1005.         }
  1007.         return $this->redirectToRoute('reservations_greenpatio_edit_simple',
  1008.             array(
  1009.                 'id' => $idRes,
  1010.                 'token' => null,
  1011.                 '_fragment' => 'btn_quotes'
  1012.             ));
  1013.     }
  1016.     /**
  1017.      * @Route("/duplicatequote", name="reservations_duplicate_quote")
  1018.      * Duplicar una cotizacion
  1019.      */
  1020.     public function duplicateQuoteAction( EntityManagerInterface $em, Request $request) {
  1022.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1023.         $user_id = $user_logueado->getId();
  1024.         $hoy = new \DateTime("now", NULL);
  1025.         $reqDuplicateQuote = $request->request->get('addquote');
  1026.         $newLounge = $em->getRepository(ReservationLoungeDetails::class)->findOneById($reqDuplicateQuote['salaPrecargadas']);
  1028.         $qb = $em->getRepository(ReservationLoungeSimple::class)->createQueryBuilder('r');
  1029.         $reservationAll = $qb->where('r.idReservation = :idReservation')
  1030.             ->setParameter('idReservation', $reqDuplicateQuote['reservationId'])
  1031.             ->orderBy('r.rankQuote', 'ASC')
  1032.             ->getQuery()
  1033.             ->getResult();
  1035.         $newRankId = (!empty($reservationAll)) ? (end($reservationAll)->getRankQuote() + 1) : 1;
  1036.         if (empty($reqDuplicateQuote['idQuote'])) { $reqDuplicateQuote['idQuote'] = reset($reservationAll)->getRankQuote(); }   //Si no elige cotización se duplica la primera
  1038.         $qb = $em->getRepository(ReservationLoungeSimple::class)->createQueryBuilder('r');
  1039.         $reservation = $qb->where('r.rankQuote = :rankQuote')
  1040.             ->andWhere('r.idReservation = :idReservation')
  1041.             ->setParameter('idReservation', $reqDuplicateQuote['reservationId'])
  1042.             ->setParameter('rankQuote', $reqDuplicateQuote['idQuote'])
  1043.             ->getQuery()
  1044.             ->getResult();
  1046.         $loungeWebDetail = $em->getRepository(ReservationLoungeWebDescription::class)->findOneBy(array('lounge' => $newLounge->getId(), 'language' => 1));
  1047.         $loungeWebDetail = empty($loungeWebDetail) ? $newLounge : $loungeWebDetail;
  1049.         foreach ($reservation as $item){
  1050.             $newLoungeSimple = new ReservationLoungeSimple();
  1051.             $newLoungeSimple->setDateStart($item->getDateStart());
  1052.             $newLoungeSimple->setDateEnd($item->getDateEnd());
  1053.             $newLoungeSimple->setIdReservation($reqDuplicateQuote['reservationId']);
  1054.             $newLoungeSimple->setPax($item->getPax());
  1055.             $newLoungeSimple->setType($item->getType());
  1056.             $newLoungeSimple->setCreatedAt($hoy);
  1057.             $newLoungeSimple->setCreatedBy($user_id);
  1058.             $newLoungeSimple->setUpdatedAt($hoy);
  1059.             $newLoungeSimple->setUpdatedBy($user_id);
  1060.             $newLoungeSimple->setHourStart($item->getHourStart());
  1061.             $newLoungeSimple->setMinStart($item->getMinStart());
  1062.             $newLoungeSimple->setHourEnd($item->getHourEnd());
  1063.             $newLoungeSimple->setMinEnd($item->getMinEnd());
  1064.             $newLoungeSimple->setRankQuote($newRankId);
  1065.             $newLoungeSimple->setIva($item->getIva());
  1066.             $newLoungeSimple->setOpIva($item->getOpIva());
  1067.             $newLoungeSimple->setIdLounge($newLounge->getId());
  1068.             $newLoungeSimple->setLoungename($newLounge->getName());
  1069. //            $newLoungeSimple->setLoungeDescription($item->getLoungeDescription());
  1070.             $newLoungeSimple->setImportantDescription($loungeWebDetail->getImportantDescription());
  1071.             $newLoungeSimple->setImportantDescGeneralText($loungeWebDetail->getImportantDescGeneralText());
  1072.             $newLoungeSimple->setImportantDescSchedules($loungeWebDetail->getImportantDescSchedules());
  1073.             $newLoungeSimple->setImportantDescParking($loungeWebDetail->getImportantDescParking());
  1075.             if (!empty($reqDuplicateQuote['salaPrice'])){ $newLoungeSimple->setServicePrice($reqDuplicateQuote['salaPrice']); }  else { $newLoungeSimple->setServicePrice($item->getServicePrice());}
  1077.             try{
  1078.                 $em->persist($newLoungeSimple);
  1079.                 $em->flush();
  1080.                 $event = 'Se ha agregado la nueva cotización';
  1081.                 $successMessage = $this->translator->trans($event);
  1082.                 $this->addFlash('mensajereservation', $successMessage);
  1083.             } catch (\Exception $e){
  1084.                 $event = 'An error occurred: '.$e->getMessage();
  1085.                 $errorMessage = $this->translator->trans($event);
  1086.                 $this->addFlash('mensajereservationerror', $errorMessage);
  1087.             }
  1089.             // Rafa indica que se debe quitar esta asignación, mas adelante eliminaremos el codigo, despues de que prueben el sistema sin esta funcionalidad
  1090.             if (false) {
  1091.                 // Se debe agregar el servicio de limpieza por cada sala que se agregue
  1092.                 $resLoungeSimple = $newLoungeSimple;
  1093.                 $service = new ReservationService();
  1094.                 $service->setReservationId($reqDuplicateQuote['reservationId']);
  1095.                 $service->setSupplierId(0);
  1096.                 $service->setDateInAt($resLoungeSimple->getDateStart());
  1097.                 $service->setDateOutAt($resLoungeSimple->getDateEnd());
  1099.                 /* Obtengo usuario logueado */
  1100.                 $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1101.                 $user_id = $user_logueado->getId();
  1103.                 $service->setCreatedId($user_id);
  1104.                 $service->setUpdatedId($user_id);
  1105.                 $service->setCreatedAt(new \DateTime("now"));
  1106.                 $service->setUpdatedAt(new \DateTime("now"));
  1108.                 $service->setServiceCatId('21');
  1109.                 $service->setServiceCatName('Limpieza');
  1110.                 $service->setContcolor('green-300');
  1111.                 $service->setName('HORAS ( ' . $resLoungeSimple->getLoungeName() . ' )');
  1112.                 $service->setPrice('14');
  1113.                 $service->setCurrency('Euro');
  1114.                 $service->setUnits('8');
  1115.                 $service->setCommission('0');
  1116.                 $service->setIva('0');
  1117.                 $service->setPax('0');
  1118.                 $service->setOver('0');
  1119.                 $service->setIva('21');
  1120.                 $service->setOpIva('1');
  1121.                 $service->setOpCommission('1');
  1122.                 $service->setCommission('57.14');
  1123.                 $service->setViewInfo(0);
  1124.                 $service->setToinvoice(0);
  1125.                 $service->setServiceId(0);
  1127.                 $em->persist($service);
  1128.                 $em->flush();
  1129.             }
  1130.         }
  1132.         return $this->redirectToRoute('reservations_greenpatio_edit_simple',
  1133.             array(
  1134.                 'id' => $reqDuplicateQuote['reservationId'],
  1135.                 'token' => null,
  1136.                 '_fragment' => 'btn_quotes'
  1137.             ));
  1138.     }
  1142.     private function precioPorFecha($date, $loungeId){
  1144.         return array( 'price' => 0, );
  1146.         $em = $this->getDoctrine()->getManager();
  1147.         $price0 = null;
  1149.         // Buscamos por año
  1150.         $parameters = array( 'dateYear' => $date->format('Y'), 'loungeId' => $loungeId, 'priceIsActive' => true, );
  1151.         $dql = 'SELECT i
  1152.                 FROM GreenPatioBundle:ReservationLoungeProfile i
  1153.                 WHERE  ((i.year1 <= :dateYear and i.year2 >= :dateYear) ) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive';
  1155.         $query = $em->createQuery($dql)->setParameters($parameters);
  1156.         $price1 = $query->getResult();
  1158.         // Buscamos por año y mes
  1159.         $parameters = array( 'dateYear' => $date->format('Y'), 'month' => true, 'loungeId' => $loungeId, 'priceIsActive' => true, );
  1161.         switch ($date->format('m')) {
  1162.             case '01': //Enero
  1163.                 $dql = 'SELECT i
  1164.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1165.                     WHERE (
  1166.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1167.                           AND (i.month1 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1168.                       ';
  1169.                 break;
  1171.             case '02': //Febrero
  1172.                 $dql = 'SELECT i
  1173.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1174.                     WHERE (
  1175.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1176.                           AND (i.month2 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1177.                       ';
  1178.                 break;
  1180.             case '03': //Marzo
  1181.                 $dql = 'SELECT i
  1182.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1183.                     WHERE (
  1184.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1185.                           AND (i.month3 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1186.                       ';
  1187.                 break;
  1189.             case '04': //Abril
  1190.                 $dql = 'SELECT i
  1191.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1192.                     WHERE (
  1193.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1194.                           AND (i.month4 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1195.                       ';
  1196.                 break;
  1198.             case '05': //Mayo
  1199.                 $dql = 'SELECT i
  1200.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1201.                     WHERE (
  1202.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1203.                           AND (i.month5 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1204.                       ';
  1205.                 break;
  1207.             case '06': //Junio
  1208.                 $dql = 'SELECT i
  1209.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1210.                     WHERE (
  1211.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1212.                           AND (i.month6 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1213.                       ';
  1214.                 break;
  1216.             case '07': //Julio
  1217.                 $dql = 'SELECT i
  1218.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1219.                     WHERE (
  1220.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1221.                           AND (i.month7 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1222.                       ';
  1223.                 break;
  1225.             case '08': //Agosto
  1226.                 $dql = 'SELECT i
  1227.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1228.                     WHERE (
  1229.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1230.                           AND (i.month8 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1231.                       ';
  1232.                 break;
  1234.             case '09': //Septiembre
  1235.                 $dql = 'SELECT i
  1236.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1237.                     WHERE (
  1238.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1239.                           AND (i.month9 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1240.                       ';
  1241.                 break;
  1243.             case '10': //Octubre
  1244.                 $dql = 'SELECT i
  1245.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1246.                     WHERE (
  1247.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1248.                           AND (i.month10 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1249.                       ';
  1250.                 break;
  1252.             case '11': //Noviembre
  1253.                 $dql = 'SELECT i
  1254.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1255.                     WHERE (
  1256.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1257.                           AND (i.month11 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1258.                       ';
  1259.                 break;
  1261.             case '12': //Diciembre
  1262.                 $dql = 'SELECT i
  1263.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1264.                     WHERE (
  1265.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1266.                           AND (i.month12 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1267.                       ';
  1268.                 break;
  1270.             default:
  1271.                 break;
  1272.         }
  1274.         $query = $em->createQuery($dql)->setParameters($parameters);
  1275.         $price2 = $query->getResult();
  1277.         // Buscamos por año, mes y dia de la semana
  1278.         $parameters = array( 'dateYear' => $date->format('Y'), 'month' => true, 'day' => true, 'loungeId' => $loungeId, 'priceIsActive' => true, );
  1280.         switch ($date->format('m')) {
  1281.             case '01': //Enero
  1282.                 switch ($date->format('l')) {
  1283.                     case 'Monday': //Lunes
  1284.                         $dql = 'SELECT i
  1285.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1286.                                     WHERE (
  1287.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1288.                                           AND (i.month1 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1289.                                       ';
  1290.                         break;
  1292.                     case 'Tuesday': //Martes
  1293.                         $dql = 'SELECT i
  1294.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1295.                                     WHERE (
  1296.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1297.                                           AND (i.month1 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1298.                                       ';
  1299.                         break;
  1301.                     case 'Wednesday': //Miercoles
  1302.                         $dql = 'SELECT i
  1303.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1304.                                     WHERE (
  1305.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1306.                                           AND (i.month1 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1307.                                       ';
  1308.                         break;
  1310.                     case 'Thursday': //Jueves
  1311.                         $dql = 'SELECT i
  1312.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1313.                                     WHERE (
  1314.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1315.                                           AND (i.month1 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1316.                                       ';
  1317.                         break;
  1319.                     case 'Friday': //Viernes
  1320.                         $dql = 'SELECT i
  1321.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1322.                                     WHERE (
  1323.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1324.                                           AND (i.month1 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1325.                                       ';
  1326.                         break;
  1328.                     case 'Saturday': //Sabado
  1329.                         $dql = 'SELECT i
  1330.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1331.                                     WHERE (
  1332.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1333.                                           AND (i.month1 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1334.                                       ';
  1335.                         break;
  1337.                     case 'Sunday': //Domingo
  1338.                         $dql = 'SELECT i
  1339.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1340.                                     WHERE (
  1341.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1342.                                           AND (i.month1 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1343.                                       ';
  1344.                         break;
  1345.                     default: break;
  1346.                 }
  1347.                 break;
  1349.             case '02': //Febrero
  1351.                 switch ($date->format('l')) {
  1352.                     case 'Monday': //Lunes
  1353.                         $dql = 'SELECT i
  1354.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1355.                                     WHERE (
  1356.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1357.                                           AND (i.month2 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1358.                                       ';
  1359.                         break;
  1361.                     case 'Tuesday': //Martes
  1362.                         $dql = 'SELECT i
  1363.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1364.                                     WHERE (
  1365.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1366.                                           AND (i.month2 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1367.                                       ';
  1368.                         break;
  1370.                     case 'Wednesday': //Miercoles
  1371.                         $dql = 'SELECT i
  1372.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1373.                                     WHERE (
  1374.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1375.                                           AND (i.month2 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1376.                                       ';
  1377.                         break;
  1379.                     case 'Thursday': //Jueves
  1380.                         $dql = 'SELECT i
  1381.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1382.                                     WHERE (
  1383.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1384.                                           AND (i.month2 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1385.                                       ';
  1386.                         break;
  1388.                     case 'Friday': //Viernes
  1389.                         $dql = 'SELECT i
  1390.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1391.                                     WHERE (
  1392.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1393.                                           AND (i.month2 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1394.                                       ';
  1395.                         break;
  1397.                     case 'Saturday': //Sabado
  1398.                         $dql = 'SELECT i
  1399.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1400.                                     WHERE (
  1401.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1402.                                           AND (i.month2 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1403.                                       ';
  1404.                         break;
  1406.                     case 'Sunday': //Domingo
  1407.                         $dql = 'SELECT i
  1408.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1409.                                     WHERE (
  1410.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1411.                                           AND (i.month2 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1412.                                       ';
  1413.                         break;
  1415.                     default: break;
  1416.                 }
  1418.                 break;
  1420.             case '03': //Marzo
  1422.                 switch ($date->format('l')) {
  1423.                     case 'Monday': //Lunes
  1424.                         $dql = 'SELECT i
  1425.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1426.                                     WHERE (
  1427.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1428.                                           AND (i.month3 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1429.                                       ';
  1430.                         break;
  1432.                     case 'Tuesday': //Martes
  1433.                         $dql = 'SELECT i
  1434.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1435.                                     WHERE (
  1436.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1437.                                           AND (i.month3 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1438.                                       ';
  1439.                         break;
  1441.                     case 'Wednesday': //Miercoles
  1442.                         $dql = 'SELECT i
  1443.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1444.                                     WHERE (
  1445.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1446.                                           AND (i.month3 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1447.                                       ';
  1448.                         break;
  1450.                     case 'Thursday': //Jueves
  1451.                         $dql = 'SELECT i
  1452.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1453.                                     WHERE (
  1454.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1455.                                           AND (i.month3 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1456.                                       ';
  1457.                         break;
  1459.                     case 'Friday': //Viernes
  1460.                         $dql = 'SELECT i
  1461.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1462.                                     WHERE (
  1463.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1464.                                           AND (i.month3 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1465.                                       ';
  1466.                         break;
  1468.                     case 'Saturday': //Sabado
  1469.                         $dql = 'SELECT i
  1470.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1471.                                     WHERE (
  1472.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1473.                                           AND (i.month3 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1474.                                       ';
  1475.                         break;
  1477.                     case 'Sunday': //Domingo
  1478.                         $dql = 'SELECT i
  1479.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1480.                                     WHERE (
  1481.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1482.                                           AND (i.month3 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1483.                                       ';
  1484.                         break;
  1486.                     default: break;
  1487.                 }
  1489.                 break;
  1491.             case '04': //Abril
  1493.                 switch ($date->format('l')) {
  1494.                     case 'Monday': //Lunes
  1495.                         $dql = 'SELECT i
  1496.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1497.                                     WHERE (
  1498.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1499.                                           AND (i.month4 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1500.                                       ';
  1501.                         break;
  1503.                     case 'Tuesday': //Martes
  1504.                         $dql = 'SELECT i
  1505.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1506.                                     WHERE (
  1507.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1508.                                           AND (i.month4 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1509.                                       ';
  1510.                         break;
  1512.                     case 'Wednesday': //Miercoles
  1513.                         $dql = 'SELECT i
  1514.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1515.                                     WHERE (
  1516.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1517.                                           AND (i.month4 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1518.                                       ';
  1519.                         break;
  1521.                     case 'Thursday': //Jueves
  1522.                         $dql = 'SELECT i
  1523.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1524.                                     WHERE (
  1525.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1526.                                           AND (i.month4 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1527.                                       ';
  1528.                         break;
  1530.                     case 'Friday': //Viernes
  1531.                         $dql = 'SELECT i
  1532.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1533.                                     WHERE (
  1534.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1535.                                           AND (i.month4 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1536.                                       ';
  1537.                         break;
  1539.                     case 'Saturday': //Sabado
  1540.                         $dql = 'SELECT i
  1541.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1542.                                     WHERE (
  1543.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1544.                                           AND (i.month4 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1545.                                       ';
  1546.                         break;
  1548.                     case 'Sunday': //Domingo
  1549.                         $dql = 'SELECT i
  1550.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1551.                                     WHERE (
  1552.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1553.                                           AND (i.month4 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1554.                                       ';
  1555.                         break;
  1557.                     default: break;
  1558.                 }
  1560.                 break;
  1562.             case '05': //Mayo
  1564.                 switch ($date->format('l')) {
  1565.                     case 'Monday': //Lunes
  1566.                         $dql = 'SELECT i
  1567.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1568.                                     WHERE (
  1569.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1570.                                           AND (i.month5 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1571.                                       ';
  1572.                         break;
  1574.                     case 'Tuesday': //Martes
  1575.                         $dql = 'SELECT i
  1576.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1577.                                     WHERE (
  1578.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1579.                                           AND (i.month5 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1580.                                       ';
  1581.                         break;
  1583.                     case 'Wednesday': //Miercoles
  1584.                         $dql = 'SELECT i
  1585.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1586.                                     WHERE (
  1587.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1588.                                           AND (i.month5 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1589.                                       ';
  1590.                         break;
  1592.                     case 'Thursday': //Jueves
  1593.                         $dql = 'SELECT i
  1594.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1595.                                     WHERE (
  1596.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1597.                                           AND (i.month5 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1598.                                       ';
  1599.                         break;
  1601.                     case 'Friday': //Viernes
  1602.                         $dql = 'SELECT i
  1603.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1604.                                     WHERE (
  1605.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1606.                                           AND (i.month5 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1607.                                       ';
  1608.                         break;
  1610.                     case 'Saturday': //Sabado
  1611.                         $dql = 'SELECT i
  1612.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1613.                                     WHERE (
  1614.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1615.                                           AND (i.month5 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1616.                                       ';
  1617.                         break;
  1619.                     case 'Sunday': //Domingo
  1620.                         $dql = 'SELECT i
  1621.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1622.                                     WHERE (
  1623.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1624.                                           AND (i.month5 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1625.                                       ';
  1626.                         break;
  1628.                     default: break;
  1629.                 }
  1631.                 break;
  1633.             case '06': //Junio
  1635.                 switch ($date->format('l')) {
  1636.                     case 'Monday': //Lunes
  1637.                         $dql = 'SELECT i
  1638.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1639.                                     WHERE (
  1640.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1641.                                           AND (i.month6 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1642.                                       ';
  1643.                         break;
  1645.                     case 'Tuesday': //Martes
  1646.                         $dql = 'SELECT i
  1647.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1648.                                     WHERE (
  1649.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1650.                                           AND (i.month6 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1651.                                       ';
  1652.                         break;
  1654.                     case 'Wednesday': //Miercoles
  1655.                         $dql = 'SELECT i
  1656.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1657.                                     WHERE (
  1658.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1659.                                           AND (i.month6 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1660.                                       ';
  1661.                         break;
  1663.                     case 'Thursday': //Jueves
  1664.                         $dql = 'SELECT i
  1665.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1666.                                     WHERE (
  1667.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1668.                                           AND (i.month6 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1669.                                       ';
  1670.                         break;
  1672.                     case 'Friday': //Viernes
  1673.                         $dql = 'SELECT i
  1674.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1675.                                     WHERE (
  1676.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1677.                                           AND (i.month6 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1678.                                       ';
  1679.                         break;
  1681.                     case 'Saturday': //Sabado
  1682.                         $dql = 'SELECT i
  1683.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1684.                                     WHERE (
  1685.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1686.                                           AND (i.month6 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1687.                                       ';
  1688.                         break;
  1690.                     case 'Sunday': //Domingo
  1691.                         $dql = 'SELECT i
  1692.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1693.                                     WHERE (
  1694.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1695.                                           AND (i.month6 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1696.                                       ';
  1697.                         break;
  1699.                     default: break;
  1700.                 }
  1702.                 break;
  1704.             case '07': //Julio
  1706.                 switch ($date->format('l')) {
  1707.                     case 'Monday': //Lunes
  1708.                         $dql = 'SELECT i
  1709.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1710.                                     WHERE (
  1711.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1712.                                           AND (i.month7 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1713.                                       ';
  1714.                         break;
  1716.                     case 'Tuesday': //Martes
  1717.                         $dql = 'SELECT i
  1718.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1719.                                     WHERE (
  1720.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1721.                                           AND (i.month7 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1722.                                       ';
  1723.                         break;
  1725.                     case 'Wednesday': //Miercoles
  1726.                         $dql = 'SELECT i
  1727.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1728.                                     WHERE (
  1729.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1730.                                           AND (i.month7 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1731.                                       ';
  1732.                         break;
  1734.                     case 'Thursday': //Jueves
  1735.                         $dql = 'SELECT i
  1736.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1737.                                     WHERE (
  1738.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1739.                                           AND (i.month7 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1740.                                       ';
  1741.                         break;
  1743.                     case 'Friday': //Viernes
  1744.                         $dql = 'SELECT i
  1745.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1746.                                     WHERE (
  1747.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1748.                                           AND (i.month7 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1749.                                       ';
  1750.                         break;
  1752.                     case 'Saturday': //Sabado
  1753.                         $dql = 'SELECT i
  1754.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1755.                                     WHERE (
  1756.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1757.                                           AND (i.month7 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1758.                                       ';
  1759.                         break;
  1761.                     case 'Sunday': //Domingo
  1762.                         $dql = 'SELECT i
  1763.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1764.                                     WHERE (
  1765.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1766.                                           AND (i.month7 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1767.                                       ';
  1768.                         break;
  1770.                     default: break;
  1771.                 }
  1773.                 break;
  1775.             case '08': //Agosto
  1777.                 switch ($date->format('l')) {
  1778.                     case 'Monday': //Lunes
  1779.                         $dql = 'SELECT i
  1780.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1781.                                     WHERE (
  1782.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1783.                                           AND (i.month8 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1784.                                       ';
  1785.                         break;
  1787.                     case 'Tuesday': //Martes
  1788.                         $dql = 'SELECT i
  1789.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1790.                                     WHERE (
  1791.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1792.                                           AND (i.month8 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1793.                                       ';
  1794.                         break;
  1796.                     case 'Wednesday': //Miercoles
  1797.                         $dql = 'SELECT i
  1798.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1799.                                     WHERE (
  1800.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1801.                                           AND (i.month8 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1802.                                       ';
  1803.                         break;
  1805.                     case 'Thursday': //Jueves
  1806.                         $dql = 'SELECT i
  1807.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1808.                                     WHERE (
  1809.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1810.                                           AND (i.month8 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1811.                                       ';
  1812.                         break;
  1814.                     case 'Friday': //Viernes
  1815.                         $dql = 'SELECT i
  1816.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1817.                                     WHERE (
  1818.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1819.                                           AND (i.month8 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1820.                                       ';
  1821.                         break;
  1823.                     case 'Saturday': //Sabado
  1824.                         $dql = 'SELECT i
  1825.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1826.                                     WHERE (
  1827.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1828.                                           AND (i.month8 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1829.                                       ';
  1830.                         break;
  1832.                     case 'Sunday': //Domingo
  1833.                         $dql = 'SELECT i
  1834.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1835.                                     WHERE (
  1836.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1837.                                           AND (i.month8 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1838.                                       ';
  1839.                         break;
  1841.                     default: break;
  1842.                 }
  1844.                 break;
  1846.             case '09': //Septiembre
  1848.                 switch ($date->format('l')) {
  1849.                     case 'Monday': //Lunes
  1850.                         $dql = 'SELECT i
  1851.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1852.                                     WHERE (
  1853.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1854.                                           AND (i.month9 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1855.                                       ';
  1856.                         break;
  1858.                     case 'Tuesday': //Martes
  1859.                         $dql = 'SELECT i
  1860.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1861.                                     WHERE (
  1862.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1863.                                           AND (i.month9 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1864.                                       ';
  1865.                         break;
  1867.                     case 'Wednesday': //Miercoles
  1868.                         $dql = 'SELECT i
  1869.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1870.                                     WHERE (
  1871.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1872.                                           AND (i.month9 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1873.                                       ';
  1874.                         break;
  1876.                     case 'Thursday': //Jueves
  1877.                         $dql = 'SELECT i
  1878.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1879.                                     WHERE (
  1880.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1881.                                           AND (i.month9 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1882.                                       ';
  1883.                         break;
  1885.                     case 'Friday': //Viernes
  1886.                         $dql = 'SELECT i
  1887.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1888.                                     WHERE (
  1889.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1890.                                           AND (i.month9 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1891.                                       ';
  1892.                         break;
  1894.                     case 'Saturday': //Sabado
  1895.                         $dql = 'SELECT i
  1896.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1897.                                     WHERE (
  1898.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1899.                                           AND (i.month9 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1900.                                       ';
  1901.                         break;
  1903.                     case 'Sunday': //Domingo
  1904.                         $dql = 'SELECT i
  1905.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1906.                                     WHERE (
  1907.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1908.                                           AND (i.month9 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1909.                                       ';
  1910.                         break;
  1912.                     default: break;
  1913.                 }
  1915.                 break;
  1917.             case '10': //Octubre
  1919.                 switch ($date->format('l')) {
  1920.                     case 'Monday': //Lunes
  1921.                         $dql = 'SELECT i
  1922.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1923.                                     WHERE (
  1924.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1925.                                           AND (i.month10 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1926.                                       ';
  1927.                         break;
  1929.                     case 'Tuesday': //Martes
  1930.                         $dql = 'SELECT i
  1931.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1932.                                     WHERE (
  1933.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1934.                                           AND (i.month10 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1935.                                       ';
  1936.                         break;
  1938.                     case 'Wednesday': //Miercoles
  1939.                         $dql = 'SELECT i
  1940.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1941.                                     WHERE (
  1942.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1943.                                           AND (i.month10 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1944.                                       ';
  1945.                         break;
  1947.                     case 'Thursday': //Jueves
  1948.                         $dql = 'SELECT i
  1949.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1950.                                     WHERE (
  1951.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1952.                                           AND (i.month10 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1953.                                       ';
  1954.                         break;
  1956.                     case 'Friday': //Viernes
  1957.                         $dql = 'SELECT i
  1958.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1959.                                     WHERE (
  1960.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1961.                                           AND (i.month10 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1962.                                       ';
  1963.                         break;
  1965.                     case 'Saturday': //Sabado
  1966.                         $dql = 'SELECT i
  1967.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1968.                                     WHERE (
  1969.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1970.                                           AND (i.month10 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1971.                                       ';
  1972.                         break;
  1974.                     case 'Sunday': //Domingo
  1975.                         $dql = 'SELECT i
  1976.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1977.                                     WHERE (
  1978.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1979.                                           AND (i.month10 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1980.                                       ';
  1981.                         break;
  1983.                     default: break;
  1984.                 }
  1986.                 break;
  1988.             case '11': //Noviembre
  1990.                 switch ($date->format('l')) {
  1991.                     case 'Monday': //Lunes
  1992.                         $dql = 'SELECT i
  1993.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1994.                                     WHERE (
  1995.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1996.                                           AND (i.month11 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1997.                                       ';
  1998.                         break;
  2000.                     case 'Tuesday': //Martes
  2001.                         $dql = 'SELECT i
  2002.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2003.                                     WHERE (
  2004.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2005.                                           AND (i.month11 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2006.                                       ';
  2007.                         break;
  2009.                     case 'Wednesday': //Miercoles
  2010.                         $dql = 'SELECT i
  2011.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2012.                                     WHERE (
  2013.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2014.                                           AND (i.month11 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2015.                                       ';
  2016.                         break;
  2018.                     case 'Thursday': //Jueves
  2019.                         $dql = 'SELECT i
  2020.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2021.                                     WHERE (
  2022.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2023.                                           AND (i.month11 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2024.                                       ';
  2025.                         break;
  2027.                     case 'Friday': //Viernes
  2028.                         $dql = 'SELECT i
  2029.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2030.                                     WHERE (
  2031.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2032.                                           AND (i.month11 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2033.                                       ';
  2034.                         break;
  2036.                     case 'Saturday': //Sabado
  2037.                         $dql = 'SELECT i
  2038.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2039.                                     WHERE (
  2040.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2041.                                           AND (i.month11 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2042.                                       ';
  2043.                         break;
  2045.                     case 'Sunday': //Domingo
  2046.                         $dql = 'SELECT i
  2047.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2048.                                     WHERE (
  2049.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2050.                                           AND (i.month11 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2051.                                       ';
  2052.                         break;
  2054.                     default: break;
  2055.                 }
  2057.                 break;
  2059.             case '12': //Diciembre
  2061.                 switch ($date->format('l')) {
  2062.                     case 'Monday': //Lunes
  2063.                         $dql = 'SELECT i
  2064.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2065.                                     WHERE (
  2066.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2067.                                           AND (i.month12 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2068.                                       ';
  2069.                         break;
  2071.                     case 'Tuesday': //Martes
  2072.                         $dql = 'SELECT i
  2073.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2074.                                     WHERE (
  2075.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2076.                                           AND (i.month12 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2077.                                       ';
  2078.                         break;
  2080.                     case 'Wednesday': //Miercoles
  2081.                         $dql = 'SELECT i
  2082.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2083.                                     WHERE (
  2084.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2085.                                           AND (i.month12 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2086.                                       ';
  2087.                         break;
  2089.                     case 'Thursday': //Jueves
  2090.                         $dql = 'SELECT i
  2091.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2092.                                     WHERE (
  2093.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2094.                                           AND (i.month12 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2095.                                       ';
  2096.                         break;
  2098.                     case 'Friday': //Viernes
  2099.                         $dql = 'SELECT i
  2100.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2101.                                     WHERE (
  2102.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2103.                                           AND (i.month12 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2104.                                       ';
  2105.                         break;
  2107.                     case 'Saturday': //Sabado
  2108.                         $dql = 'SELECT i
  2109.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2110.                                     WHERE (
  2111.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2112.                                           AND (i.month12 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2113.                                       ';
  2114.                         break;
  2116.                     case 'Sunday': //Domingo
  2117.                         $dql = 'SELECT i
  2118.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2119.                                     WHERE (
  2120.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2121.                                           AND (i.month12 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2122.                                       ';
  2123.                         break;
  2125.                     default: break;
  2126.                 }
  2128.                 break;
  2130.             default:
  2131.                 break;
  2132.         }
  2134.         $query = $em->createQuery($dql)->setParameters($parameters);
  2135.         $price3 = $query->getResult();
  2137.         foreach ($price3 as $item){
  2138.             if (empty($price0)){
  2139.                 $price0 = $item;
  2140.             } else {
  2141.                 //Si los precios coinciden en fechas se tomara el que se haya cargado mas reciente en el sistema
  2142.                 if ($item->getCreatedAt() > $price0->getCreatedAt()){ $price0 = $item; }
  2143.             }
  2144.         }
  2145.         if(empty($price0)){ $price = 0; } else { $price = $price0->getPrice(); }
  2147.         return array( 'price' => $price, );
  2148.     }
  2151.     private function precioTarifario($dateStart, $loungeId, $servicePrice){
  2152.         /*
  2153.          * Se busca el precio a Sugerir
  2154.          * $dateStart Fecha
  2155.          * $loungeId Id de  la sala
  2156.          * $servicePrice Preciointroducido por elusuario
  2157.          * */
  2159.         $em = $this->getDoctrine()->getManager();
  2161.         $dateToFind = clone $dateStart;
  2162.         $dateToFind->setTime(0, 0, 0);
  2163.         $parameters = array(
  2164.             'loungeId' => $loungeId,
  2165.             'typePrice' => 'DIARIA',
  2166.             'dateToFind' => $dateToFind,
  2167.         );
  2168.         $dql = 'SELECT p
  2169.                 FROM GreenPatioBundle:ReservationLoungeProfile p
  2170.                 WHERE p.typePrice = :typePrice AND p.dateStart = :dateToFind AND p.loungeId = :loungeId
  2171.                 ORDER BY p.levelPrice DESC';
  2173.         $query = $em->createQuery($dql)->setParameters($parameters);
  2174.         $loungesPeriodsDaily = $query->getResult();
  2176.         $priceTarifa = empty($loungesPeriodsDaily) ? 0 : $loungesPeriodsDaily[0]->getPrice();
  2178.         $price = ($servicePrice == 0) ? $priceTarifa : $servicePrice;
  2180.         return $price;
  2181.     }
  2184.     private function recalculoFechas($id){
  2185.         /*
  2186.          * Se busca recalculan las fechas de incio y fin de la reserva
  2187.          * $id es el identificador de la reserva
  2188.          * */
  2190.         $em = $this->getDoctrine()->getManager();
  2192.         $reserva = $em->getRepository(Reservation::class)->findOneById($id);
  2193.         $allLoungeSimples = $em->getRepository(ReservationLoungeSimple::class)->findByIdReservation($id);
  2195.         $dateStart = new DateTime('2078-01-01');
  2196.         $dateEnd = new DateTime('2000-01-01');
  2198.         if (!empty($allLoungeSimples)){
  2199.             foreach ($allLoungeSimples as $loungeSimple){
  2200.                 $dateStart = ($loungeSimple->getDateStart() < $dateStart) ? $loungeSimple->getDateStart() : $dateStart;
  2201.                 $dateEnd = ($loungeSimple->getDateEnd() > $dateEnd) ? $loungeSimple->getDateStart() : $dateEnd;
  2202.             }
  2203.         }
  2205.         $reserva->setDateStart($dateStart);
  2206.         $reserva->setDateEnd($dateEnd);
  2208.         try{
  2209.             $em->persist($reserva);
  2210.             $em->flush();
  2211.             $event = 'The Reservation has been updated.';
  2212.             $successMessage = $this->translator->trans($event);
  2213.             $this->addFlash('mensajereservation', $successMessage);
  2214.         } catch (\Exception $e){
  2215.             $event = 'An error occurred: '.$e->getMessage();
  2216.             $errorMessage = $this->translator->trans($event);
  2217.             $this->addFlash('mensajereservationerror', $errorMessage);
  2218.         }
  2220.         return true;
  2221.     }
  2222. }