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

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 Doctrine\ORM\EntityManagerInterface;
  23. use Symfony\Component\Routing\Annotation\Route;
  24. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  25. use Symfony\Component\HttpFoundation\Request;
  26. use DateTime;
  27. use DatePeriod;
  28. use DateInterval;
  29. use Google_Client;
  30. use Google_Service_Calendar;
  31. use Symfony\Contracts\Translation\TranslatorInterface;
  34. class ReservationsQuoteController extends AbstractController
  35. {
  36.     public function __construct(TranslatorInterface $translator)
  37.     {
  38.         $redirect_uri = 'https://' . $_SERVER['HTTP_HOST']. '/calendar/token';
  39.         $googleCalendar = new Google_Client();
  40.         $googleCalendar->setApplicationName('Google Calendar API PHP Quickstart');
  41.         //campos a extraer de la base de datos User
  42.         $googleCalendar->setClientId('2790497987-57qc3vu4pr7vb0s8phpub2me58pe34lb.apps.googleusercontent.com');
  43.         $googleCalendar->setClientSecret('nj2C7unaTO68DRhyORsyipSj');
  44.         //fin campos user
  45. //        $api_key = "AIzaSyBR84cS1IU2BPvk5V3VnbqdkJESlv440Ac";
  46. //        $client->setDeveloperKey($api_key);
  47.         $googleCalendar->setRedirectUri($redirect_uri);
  48.         $googleCalendar->addScope(Google_Service_Calendar::CALENDAR);
  49.         $guzzleClient = new \GuzzleHttp\Client(array('curl' => array(CURLOPT_SSL_VERIFYPEER => false)));
  50.         $googleCalendar->setHttpClient($guzzleClient);
  51.         $this->googleCalendar = $googleCalendar;
  52.         $this->translator = $translator;
  53.     }
  55.     /**
  56.      * @Route("/createsimplelounge/{id}", name="reservations_greenpatio_create_simple_lounge")
  57.      * Crea un Reservation Lounge Simple en la cotizacion
  58.      */
  59.     public function createSimpleLoungeAction($id, EntityManagerInterface $em, Request $request)
  60.     {
  61.         $simpleLounge = $request->request->get('reservation_sala');
  62.         $loungeProfile = $em->getRepository(ReservationLoungeDetails::class)->findOneById($simpleLounge['salaPrecargadas']);
  63.         $loungeId = $loungeProfile->getId();
  64.         $loungeDetails = $em->getRepository(ReservationLoungeDetails::class)->findOneById($loungeId);
  65.         $previusLoungeSimple = $em->getRepository(ReservationLoungeSimple::class)->findOneBy(array('idLounge' => $loungeId, 'idReservation' => $id, 'rankQuote' => $simpleLounge['idQuote']));
  67.         //Buscamos si hay ya alguna sala en la reserva
  68.         $anyLoungeSimple = $em->getRepository(ReservationLoungeSimple::class)->findOneBy(array('idLounge' => $loungeId, 'idReservation' => $id));
  69.         $idioma = 1;
  70.         if($anyLoungeSimple){
  71.             $idioma = $anyLoungeSimple->getLanguage();
  72.         }
  73.         $loungeWebDescription = $em->getRepository(ReservationLoungeWebDescription::class)->findOneBy(array('lounge' => $loungeProfile, 'language' => $idioma));
  74.         $loungeName = $loungeDetails->getName();
  75.         $hourMinStart = $simpleLounge['hourStart'];
  76.         $hourMinEnd = $simpleLounge['hourEnd'];
  77.         $loungeSummaryDescription = array_key_exists('importantDescription', $simpleLounge) ? $simpleLounge['importantDescription'] : null;
  78.         if (empty($previusLoungeSimple)) {
  79.             if (empty($loungeSummaryDescription)) { $loungeSummaryDescription = $loungeWebDescription->getImportantDescription(); }
  80.             $loungeImportantDescGeneralText = $loungeWebDescription->getImportantDescGeneralText();
  81.             $loungeImportantDescSchedules = $loungeWebDescription->getImportantDescSchedules();
  82.             $loungeImportantDescParking = $loungeWebDescription->getImportantDescParking();
  83.         } else {
  84.             $loungeSummaryDescription = $previusLoungeSimple->getImportantDescription();
  85.             $loungeImportantDescGeneralText = $previusLoungeSimple->getImportantDescGeneralText();
  86.             $loungeImportantDescSchedules = $previusLoungeSimple->getImportantDescSchedules();
  87.             $loungeImportantDescParking = $previusLoungeSimple->getImportantDescParking();
  88.         }
  89.         
  90.         $iva = 21;
  91.         if (array_key_exists('iva', $simpleLounge)) {
  92.             if (empty($simpleLounge['iva']) && !is_numeric($simpleLounge['iva'])) {
  93.                 $iva = 21;
  94.             } else {
  95.                 $iva = $simpleLounge['iva'];
  96.             }
  97.         }
  99.         $qb = $em->getRepository(ReservationLoungeSimple::class)->createQueryBuilder('r');
  100.         $reservationAll = $qb->where('r.idReservation = :idReservation')
  101.             ->setParameter('idReservation', $id)
  102.             ->orderBy('r.rankQuote', 'ASC')
  103.             ->getQuery()
  104.             ->getResult();
  106.         $newRankId = (!empty($reservationAll)) ? (end($reservationAll)->getRankQuote() + 1) : 1;
  107.         if (!empty($simpleLounge['idQuote'])){ if (is_numeric($simpleLounge['idQuote'])){ $newRankId = $simpleLounge['idQuote']; } }
  109.         // Autocompletacion HH:mm en Start
  110.         switch (strlen($hourMinStart)) {
  111.             case 0:
  112.                 // Vacio
  113.                 $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  114.                 break;
  115.             case 1:
  116.                 // H  -> 0H:00
  117.                 if (is_numeric($hourMinStart)){
  118.                     $hourStart = '0'.$hourMinStart; $minStart = '00'; $hourMinStart = $hourStart.':'.$minStart;
  119.                 } else {
  120.                     $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  121.                 }
  122.                 break;
  123.             case 2:
  124.                 // HH  -> HH:00
  125.                 if (is_numeric($hourMinStart)){
  126.                     $hourStart = $hourMinStart; $minStart = '00'; $hourMinStart = $hourStart.':'.$minStart;
  127.                 } else {
  128.                     $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  129.                 }
  130.                 break;
  131.             case 3:
  132.                 // Hmm  -> 0H:mm
  133.                 if (is_numeric($hourMinStart)){
  134.                     $hourStart = '0'.substr($hourMinStart,0,1); $minStart = substr($hourMinStart,1,2); $hourMinStart = $hourStart.':'.$minStart;
  135.                 } else {
  136.                     $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  137.                 }
  138.                 break;
  139.             case 4:
  140.                 // HHmm  -> HH:mm
  141.                 if (is_numeric($hourMinStart)){
  142.                     $hourStart = substr($hourMinStart,0,2); $minStart = substr($hourMinStart,2,2); $hourMinStart = $hourStart.':'.$minStart;
  143.                 } else {
  144.                     $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  145.                 }
  146.                 break;
  147.             case 5:
  148.                 // HH:mm
  149.                 if (is_numeric(substr($hourMinStart,0,2)) and (substr($hourMinStart,2,1)==':') and is_numeric(substr($hourMinStart,0,2))){
  150.                     $hourStart = substr($hourMinStart,0,2); $minStart = substr($hourMinStart,3,2); $hourMinStart = $hourStart.':'.$minStart;
  151.                 } else {
  152.                     $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  153.                 }
  154.                 break;
  156.             default:
  157.                 // XXXXyyy
  158.                 $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  159.                 break;
  160.         }
  162.         // Autocompletacion HH:mm en End
  163.         switch (strlen($hourMinEnd)) {
  164.             case 0:
  165.                 // Vacio
  166.                 $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  167.                 break;
  168.             case 1:
  169.                 // H  -> 0H:00
  170.                 if (is_numeric($hourMinEnd)){
  171.                     $hourEnd = '0'.$hourMinEnd; $minEnd = '00'; $hourMinEnd = $hourEnd.':'.$minEnd;
  172.                 } else {
  173.                     $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  174.                 }
  175.                 break;
  176.             case 2:
  177.                 // HH  -> HH:00
  178.                 if (is_numeric($hourMinEnd)){
  179.                     $hourEnd = $hourMinEnd; $minEnd = '00'; $hourMinEnd = $hourEnd.':'.$minEnd;
  180.                 } else {
  181.                     $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  182.                 }
  183.                 break;
  184.             case 3:
  185.                 // Hmm  -> 0H:mm
  186.                 if (is_numeric($hourMinEnd)){
  187.                     $hourEnd = '0'.substr($hourMinEnd,0,1); $minEnd = substr($hourMinEnd,1,2); $hourMinEnd = $hourEnd.':'.$minEnd;
  188.                 } else {
  189.                     $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  190.                 }
  191.                 break;
  192.             case 4:
  193.                 // HHmm  -> HH:mm
  194.                 if (is_numeric($hourMinEnd)){
  195.                     $hourEnd = substr($hourMinEnd,0,2); $minEnd = substr($hourMinEnd,2,2); $hourMinEnd = $hourEnd.':'.$minEnd;
  196.                 } else {
  197.                     $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  198.                 }
  199.                 break;
  200.             case 5:
  201.                 // HH:mm
  202.                 if (is_numeric(substr($hourMinEnd,0,2)) and (substr($hourMinEnd,2,1)==':') and is_numeric(substr($hourMinEnd,0,2))){
  203.                     $hourEnd = substr($hourMinEnd,0,2); $minEnd = substr($hourMinEnd,3,2); $hourMinEnd = $hourEnd.':'.$minEnd;
  204.                 } else {
  205.                     $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  206.                 }
  207.                 break;
  209.             default:
  210.                 // XXXXyyy
  211.                 $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  212.                 break;
  213.         }
  215.         $dateStart = new DateTime($simpleLounge['dateStart'] . ' '. $hourMinStart);
  216.         $dateEnd = new DateTime($simpleLounge['dateStart'] . ' '. $hourMinEnd);   // Se usa DateStart por que solo hay un dia en el formulario
  217.         $idService = 0;
  218.         $serviceName = '';
  219.         $servicePrice = (empty($simpleLounge['servicePrice'])) ? 0 :$simpleLounge['servicePrice'];
  220.         $idReservation = $id;
  221.         /* Obtengo usuario logueado */
  222.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  223.         $user_id = $user_logueado->getId();
  224.         $createdAt = new DateTime('now');
  225.         $createdBy = $user_id;
  226.         $updatedAt = new DateTime('now');
  227.         $updatedBy = $user_id;
  228.         $pax = $simpleLounge['pax']; if (empty($pax)){$pax = 0;}
  230.         $lounge = new ReservationLoungeSimple();
  231.         $lounge->setIdLounge ($loungeId);
  232.         $lounge->setHourStart ($hourStart);
  233.         $lounge->setMinStart ($minStart);
  234.         $lounge->setHourEnd ($hourEnd);
  235.         $lounge->setMinEnd ($minEnd);
  236.         $lounge->setLoungeName ($loungeName);
  237.         $lounge->setDateStart ($dateStart);
  238.         $lounge->setDateEnd ($dateEnd);
  239.         $lounge->setRankQuote(1);
  240.         $lounge->setIdReservation ($idReservation);
  241.         $lounge->setIva($iva);
  242.         $lounge->setOpIva(1);
  243.         $lounge->setCreatedAt ($createdAt);
  244.         $lounge->setCreatedBy ($createdBy);
  245.         $lounge->setUpdatedAt ($updatedAt);
  246.         $lounge->setUpdatedBy ($updatedBy);
  247.         $lounge->setPax ($pax);
  248.         $lounge->setRankQuote($newRankId);
  249.         $lounge->setImportantDescription($loungeSummaryDescription);
  250.         $lounge->setImportantDescGeneralText($loungeImportantDescGeneralText);
  251.         $lounge->setImportantDescSchedules($loungeImportantDescSchedules);
  252.         $lounge->setImportantDescParking($loungeImportantDescParking);
  254.         // PRECIO POR TARIFA
  255.         $dateToFind = clone $dateStart;
  256.         $dateToFind->setTime(0, 0, 0);
  257.         $parameters = array(
  258.             'loungeId' => $loungeId,
  259.             'typePrice' => 'DIARIA',
  260.             'dateToFind' => $dateToFind,
  261.             );
  262.         $dql = 'SELECT p
  263.                 FROM GreenPatioBundle:ReservationLoungeProfile p
  264.                 WHERE p.typePrice = :typePrice AND p.dateStart = :dateToFind AND p.loungeId = :loungeId
  265.                 ORDER BY p.levelPrice DESC';
  267.         $query = $em->createQuery($dql)->setParameters($parameters);
  268.         $loungesPeriodsDaily = $query->getResult();
  270.         $priceTarifa = empty($loungesPeriodsDaily) ? 0 : $loungesPeriodsDaily[0]->getPrice();
  272.         $price = ($servicePrice == 0) ? $priceTarifa : $servicePrice;
  274.         $lounge->setServicePrice($price);
  276.         try{
  277.             $em->persist($lounge);
  278.             $em->flush();
  279.             $event = 'The Reservation has been updated.';
  280.             $successMessage = $this->translator->trans($event);
  281.             $this->addFlash('mensajereservation', $successMessage);
  282.         } catch (\Exception $e){
  283.             $event = 'An error occurred: '.$e->getMessage();
  284.             $errorMessage = $this->translator->trans($event);
  285.             $this->addFlash('mensajereservationerror', $errorMessage);
  286.         }
  288.         // INICIO: Actualizacion de fecha de inicio y fin del evento, a partir de la info de la sala
  289.         $boolSincGpAv = false;
  290.         $reserva = $em->getRepository(Reservation::class)->findOneById($idReservation);
  292.         if ($reserva->getDateStart() > $dateStart){ $reserva->setDateStart($dateStart); $boolSincGpAv = true; }
  293.         if ($reserva->getDateStart()->format('Y') == '2078' ){ $reserva->setDateStart($dateStart); $boolSincGpAv = true; }
  294.         if ($reserva->getDateEnd() < $dateEnd){ $reserva->setDateEnd($dateEnd); $boolSincGpAv = true; }
  295.         if ($reserva->getDateEnd()->format('Y') == '2000' ){ $reserva->setDateEnd($dateEnd); $boolSincGpAv = true; }
  297.         try{
  298.             $em->persist($reserva);
  299.             $em->flush();
  300.             $event = '';
  301.             $successMessage = $this->translator->trans($event);
  302.             $this->addFlash('mensajereservation', $successMessage);
  304.         } catch (\Exception $e){}
  306.         // Sincronización con Av Express
  307.         if ($boolSincGpAv) {
  308.             $AveFile = $em->getRepository(AveFiles::class)->findByReservation($reserva);
  309.             if (($reserva->getStatus() == 'Confirmed') or ($reserva->getStatus() == 'Cotizado') or ($reserva->getStatus() == 'Invoiced') or ($reserva->getStatus() == 'Bloqueo')) {
  310.                 if (empty($AveFile)) {
  311.                     // Si no se ha creado aun el expediente de Av Express debemos crearlo
  312.                     return $this->redirectToRoute('sinc_gp_ave', array('id' => $id,));
  313.                 }
  314.             }
  315.         }
  316.         // FIN: Actualizacion de fecha de inicio y fin del evento, a partir de la info de la sala
  318.         // Se debe redirigir para agregar el Servicio de limpieza
  320.         return $this->redirectToRoute('reservations_white_addservices_cleaning',
  321.             array(
  322.                 'resid' => $id,
  323.                 'loungesimpleid' => $lounge->getId(),
  324.             ));
  325.     }
  328.     /**
  329.      * @Route("/createsimpleloungemondes/{id}", name="reservations_greenpatio_create_simple_lounge_mondes")
  330.      * Se crea un dia de montaje o desmontaje
  331.      */
  332.     public function createSimpleLoungeMonDesAction($id, EntityManagerInterface $em, Request $request)
  333.     {
  334.         $simpleLounge = $request->request->get('reservation_sala_mondes');
  335.         $loungeId = $simpleLounge['idLounge'];
  336.         $loungeDetails = $em->getRepository(ReservationLoungeDetails::class)->findOneById($loungeId);
  337.         $previusLoungeSimple = $em->getRepository(ReservationLoungeSimple::class)->findOneBy(array('idLounge' => $loungeId, 'idReservation' => $id, 'rankQuote' => $simpleLounge['idQuote']));
  338.         $loungeName = $loungeDetails->getName();
  339.         $hourMinStart = $simpleLounge['hourStart'];
  340.         $hourMinEnd = $simpleLounge['hourEnd'];
  341.         $ivaNew = empty($simpleLounge['iva']) ? 21 : $simpleLounge['iva'];
  342.         if (empty($previusLoungeSimple)) {
  343.             $loungeSummaryDescription = $loungeDetails->getImportantDescription();
  344.             $loungeImportantDescGeneralText = $loungeDetails->getImportantDescGeneralText();
  345.             $loungeImportantDescSchedules = $loungeDetails->getImportantDescSchedules();
  346.             $loungeImportantDescParking = $loungeDetails->getImportantDescParking();
  347.         } else {
  348.             $loungeSummaryDescription = $previusLoungeSimple->getImportantDescription();
  349.             $loungeImportantDescGeneralText = $previusLoungeSimple->getImportantDescGeneralText();
  350.             $loungeImportantDescSchedules = $previusLoungeSimple->getImportantDescSchedules();
  351.             $loungeImportantDescParking = $previusLoungeSimple->getImportantDescParking();
  352.         }
  354.         $qb = $em->getRepository(ReservationLoungeSimple::class)->createQueryBuilder('r');
  355.         $reservationAll = $qb->where('r.idReservation = :idReservation')
  356.             ->setParameter('idReservation', $id)
  357.             ->orderBy('r.rankQuote', 'ASC')
  358.             ->getQuery()
  359.             ->getResult();
  361.         $newRankId = (!empty($reservationAll)) ? (end($reservationAll)->getRankQuote() + 1) : 1;
  362.         if (!empty($simpleLounge['idQuote'])){ if (is_numeric($simpleLounge['idQuote'])){ $newRankId = $simpleLounge['idQuote']; } }
  364.         // Autocompletacion HH:mm en Start
  365.         switch (strlen($hourMinStart)) {
  366.             case 0:
  367.                 // Vacio
  368.                 $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  369.                 break;
  370.             case 1:
  371.                 // H  -> 0H:00
  372.                 if (is_numeric($hourMinStart)){
  373.                     $hourStart = '0'.$hourMinStart; $minStart = '00'; $hourMinStart = $hourStart.':'.$minStart;
  374.                 } else {
  375.                     $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  376.                 }
  377.                 break;
  378.             case 2:
  379.                 // HH  -> HH:00
  380.                 if (is_numeric($hourMinStart)){
  381.                     $hourStart = $hourMinStart; $minStart = '00'; $hourMinStart = $hourStart.':'.$minStart;
  382.                 } else {
  383.                     $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  384.                 }
  385.                 break;
  386.             case 3:
  387.                 // Hmm  -> 0H:mm
  388.                 if (is_numeric($hourMinStart)){
  389.                     $hourStart = '0'.substr($hourMinStart,0,1); $minStart = substr($hourMinStart,1,2); $hourMinStart = $hourStart.':'.$minStart;
  390.                 } else {
  391.                     $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  392.                 }
  393.                 break;
  394.             case 4:
  395.                 // HHmm  -> HH:mm
  396.                 if (is_numeric($hourMinStart)){
  397.                     $hourStart = substr($hourMinStart,0,2); $minStart = substr($hourMinStart,2,2); $hourMinStart = $hourStart.':'.$minStart;
  398.                 } else {
  399.                     $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  400.                 }
  401.                 break;
  402.             case 5:
  403.                 // HH:mm
  404.                 if (is_numeric(substr($hourMinStart,0,2)) and (substr($hourMinStart,2,1)==':') and is_numeric(substr($hourMinStart,0,2))){
  405.                     $hourStart = substr($hourMinStart,0,2); $minStart = substr($hourMinStart,3,2); $hourMinStart = $hourStart.':'.$minStart;
  406.                 } else {
  407.                     $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  408.                 }
  409.                 break;
  411.             default:
  412.                 // XXXXyyy
  413.                 $hourStart = '00'; $minStart = '00'; $hourMinStart = '00:00';
  414.                 break;
  415.         }
  417.         // Autocompletacion HH:mm en End
  418.         switch (strlen($hourMinEnd)) {
  419.             case 0:
  420.                 // Vacio
  421.                 $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  422.                 break;
  423.             case 1:
  424.                 // H  -> 0H:00
  425.                 if (is_numeric($hourMinEnd)){
  426.                     $hourEnd = '0'.$hourMinEnd; $minEnd = '00'; $hourMinEnd = $hourEnd.':'.$minEnd;
  427.                 } else {
  428.                     $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  429.                 }
  430.                 break;
  431.             case 2:
  432.                 // HH  -> HH:00
  433.                 if (is_numeric($hourMinEnd)){
  434.                     $hourEnd = $hourMinEnd; $minEnd = '00'; $hourMinEnd = $hourEnd.':'.$minEnd;
  435.                 } else {
  436.                     $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  437.                 }
  438.                 break;
  439.             case 3:
  440.                 // Hmm  -> 0H:mm
  441.                 if (is_numeric($hourMinEnd)){
  442.                     $hourEnd = '0'.substr($hourMinEnd,0,1); $minEnd = substr($hourMinEnd,1,2); $hourMinEnd = $hourEnd.':'.$minEnd;
  443.                 } else {
  444.                     $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  445.                 }
  446.                 break;
  447.             case 4:
  448.                 // HHmm  -> HH:mm
  449.                 if (is_numeric($hourMinEnd)){
  450.                     $hourEnd = substr($hourMinEnd,0,2); $minEnd = substr($hourMinEnd,2,2); $hourMinEnd = $hourEnd.':'.$minEnd;
  451.                 } else {
  452.                     $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  453.                 }
  454.                 break;
  455.             case 5:
  456.                 // HH:mm
  457.                 if (is_numeric(substr($hourMinEnd,0,2)) and (substr($hourMinEnd,2,1)==':') and is_numeric(substr($hourMinEnd,0,2))){
  458.                     $hourEnd = substr($hourMinEnd,0,2); $minEnd = substr($hourMinEnd,3,2); $hourMinEnd = $hourEnd.':'.$minEnd;
  459.                 } else {
  460.                     $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  461.                 }
  462.                 break;
  464.             default:
  465.                 // XXXXyyy
  466.                 $hourEnd = '00'; $minEnd = '00'; $hourMinEnd = '00:00';
  467.                 break;
  468.         }
  470.         $dateStart = new DateTime($simpleLounge['dateStart'] . ' '. $hourMinStart);
  471.         $dateEnd = new DateTime($simpleLounge['dateStart'] . ' '. $hourMinEnd);   // Se usa DateStart por que solo hay un dia en el formulario
  472.         $servicePrice = empty($simpleLounge['servicePrice']) ? 0 :$simpleLounge['servicePrice'];
  473.         $idReservation = $id;
  474.         /* Obtengo usuario logueado */
  475.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  476.         $user_id = $user_logueado->getId();
  477.         $createdAt = new DateTime('now');
  478.         $createdBy = $user_id;
  479.         $updatedAt = new DateTime('now');
  480.         $updatedBy = $user_id;
  481.         $lounge = new ReservationLoungeSimple();
  483.         if ($simpleLounge['type'] == 'Montaje'){ $lounge->setType ('Montaje'); } else {  $lounge->setType ('Desmontaje'); }
  484.         $pax = null;
  485.         $lounge->setIdLounge ($loungeId);
  486.         $lounge->setHourStart ($hourStart);
  487.         $lounge->setMinStart ($minStart);
  488.         $lounge->setHourEnd ($hourEnd);
  489.         $lounge->setMinEnd ($minEnd);
  490.         $lounge->setLoungeName ($loungeName);
  491.         $lounge->setDateStart ($dateStart);
  492.         $lounge->setDateEnd ($dateEnd);
  493.         $lounge->setRankQuote(1);
  494.         $lounge->setIva($ivaNew);
  495.         $lounge->setOpIva(1);
  496.         $lounge->setIdReservation ($idReservation);
  497.         $lounge->setCreatedAt ($createdAt);
  498.         $lounge->setCreatedBy ($createdBy);
  499.         $lounge->setUpdatedAt ($updatedAt);
  500.         $lounge->setUpdatedBy ($updatedBy);
  501.         $lounge->setPax ($pax);
  502.         $lounge->setRankQuote($newRankId);
  503.         $lounge->setImportantDescription($loungeSummaryDescription);
  504.         $lounge->setImportantDescGeneralText($loungeImportantDescGeneralText);
  505.         $lounge->setImportantDescSchedules($loungeImportantDescSchedules);
  506.         $lounge->setImportantDescParking($loungeImportantDescParking);
  508.         $price = $this->precioPorFecha($dateStart, $loungeId);
  509.         $servicePrice = ($price['price'] == 0) ? $servicePrice : $price;
  510.         $lounge->setServicePrice($servicePrice);
  512.         try{
  513.             $em->persist($lounge);
  514.             $em->flush();
  515.             $event = 'The Reservation has been updated.';
  516.             $successMessage = $this->translator->trans($event);
  517.             $this->addFlash('mensajereservation', $successMessage);
  519.         } catch (\Exception $e){
  521.             $event = 'An error occurred: '.$e->getMessage();
  522.             $errorMessage = $this->translator->trans($event);
  523.             $this->addFlash('mensajereservationerror', $errorMessage);
  524.         }
  526.         $reservax = $em->getRepository(Reservation::class)->findOneById($idReservation);
  528.         // INICIO: Verificamos si es necesario actualizar las fechas de la reserva
  529.         $boolReserva = false;
  530.         if ($lounge->getDateStart() < $reservax->getDateStart()){
  531.             $reservax->setDateStart($lounge->getDateStart());
  532.             $boolReserva = true;
  533.         }
  535.         if ($reservax->getDateEnd() < $lounge->getDateEnd()){
  536.             $reservax->setDateEnd($lounge->getDateEnd());
  537.             $boolReserva = true;
  538.         }
  539.         if ($boolReserva){
  540.             $em->persist($reservax);
  541.             $em->flush();
  542.         }
  543.         $boolSincGpAv = $boolReserva;
  544.         // Sincronización con Av Express
  545.         if ($boolSincGpAv) {
  546.             $AveFile = $em->getRepository(AveFiles::class)->findByReservation($reservax);
  547.             if (($reservax->getStatus() == 'Confirmed') or ($reservax->getStatus() == 'Cotizado') or ($reservax->getStatus() == 'Invoiced') or ($reservax->getStatus() == 'Bloqueo')) {
  548.                 if (empty($AveFile)) {
  549.                     // Si no se ha creado aun el expediente de Av Express debemos crearlo
  550.                     return $this->redirectToRoute('sinc_gp_ave', array('id' => $id,));
  551.                 }
  552.             }
  553.         }
  554.         // FIN: Verificamos si es necesario actualizar las fechas de la reserva
  556.         return $this->redirectToRoute('reservations_greenpatio_edit_simple',
  557.             array(
  558.                 'id' => $id,
  559.                 'token' => null,
  560.                 '_fragment' => 'btn_quotes'
  561.             ));
  562.     }
  565.     /**
  566.      * @Route("/duplicateday/{id}/{dayduplicate}/{idRankQuote}", name="reservations_greenpatio_duplicate_day")
  567.      * Duplica un elemento de la cotizacion para el dia siguiente
  568.      */
  569.     public function duplicateDayAction($id, $dayduplicate, $idRankQuote, EntityManagerInterface $em, Request $request)
  570.     {
  571.         $loungeSimples = $em->getRepository(ReservationLoungeSimple::class)->findByIdReservation($id);
  572.         $reservax = $em->getRepository(Reservation::class)->findOneById($id);
  574.         /* Obtengo usuario logueado */
  575.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  576.         $user_id = $user_logueado->getId();
  577.         $createdAt = new DateTime('now');
  578.         $createdBy = $user_id;
  579.         $updatedAt = new DateTime('now');
  580.         $updatedBy = $user_id;
  582.         if (!empty($loungeSimples)){
  583.             foreach ($loungeSimples as $item){
  584.                 if (($item->getDateStart()->format('d-m-Y') == $dayduplicate) and ($item->getRankQuote() == $idRankQuote)){
  585.                     // Se duplica y suma un dia
  586.                     $newLoungeSimple = new ReservationLoungeSimple();
  587.                     $newLoungeSimple->setDateStart($item->getDateStart()->modify('+1 day'));
  588.                     $newLoungeSimple->setDateEnd($item->getDateEnd()->modify('+1 day'));
  589.                     $newLoungeSimple->setHourStart($item->getHourStart());
  590.                     $newLoungeSimple->setHourEnd($item->getHourEnd());
  591.                     $newLoungeSimple->setMinStart($item->getMinStart());
  592.                     $newLoungeSimple->setMinEnd($item->getMinEnd());
  593.                     $newLoungeSimple->setIdLounge($item->getIdLounge());
  594.                     $newLoungeSimple->setIdReservation($item->getIdReservation());
  595.                     $newLoungeSimple->setLoungeName($item->getLoungeName());
  596.                     $newLoungeSimple->setPax($item->getPax());
  597.                     $newLoungeSimple->setServicePrice($item->getServicePrice());
  598.                     $newLoungeSimple->setIva($item->getIva());
  599.                     $newLoungeSimple->setOpIva($item->getOpIva());
  600.                     $newLoungeSimple->setType($item->getType());
  601.                     $newLoungeSimple->setLoungeDescription($item->getLoungeDescription());
  602.                     $newLoungeSimple->setImportantDescription($item->getImportantDescription());
  603.                     $newLoungeSimple->setImportantDescGeneralText($item->getImportantDescGeneralText());
  604.                     $newLoungeSimple->setImportantDescSchedules($item->getImportantDescSchedules());
  605.                     $newLoungeSimple->setImportantDescParking($item->getImportantDescParking());
  606.                     $newLoungeSimple->setRankQuote($idRankQuote);
  607.                     $newLoungeSimple->setCreatedAt($createdAt);
  608.                     $newLoungeSimple->setCreatedBy($createdBy);
  609.                     $newLoungeSimple->setUpdatedAt($updatedAt);
  610.                     $newLoungeSimple->setUpdatedBy($updatedBy);
  612.                     try{
  613.                         $em->persist($newLoungeSimple);
  614.                         $em->flush();
  615.                         $event = 'The Item has been duplicated.';
  616.                         $successMessage = $this->translator->trans($event);
  617.                         $this->addFlash('mensajereservation', $successMessage);
  619.                     } catch (\Exception $e){
  621.                         $event = 'An error occurred: '.$e->getMessage();
  622.                         $errorMessage = $this->translator->trans($event);
  623.                         $this->addFlash('mensajereservationerror', $errorMessage);
  624.                     }
  626.                     // INICIO: Verificamos si es necesario actualizar las fechas de la reserva
  627.                     $boolReserva = false;
  628.                     if ($newLoungeSimple->getDateStart() < $reservax->getDateStart()){
  629.                         $reservax->setDateStart($newLoungeSimple->getDateStart());
  630.                         $boolReserva = true;
  631.                     }
  633.                     if ($reservax->getDateEnd() < $newLoungeSimple->getDateEnd()){
  634.                         $reservax->setDateEnd($newLoungeSimple->getDateEnd());
  635.                         $boolReserva = true;
  636.                     }
  637.                     if ($boolReserva){
  638.                         $em->persist($reservax);
  639.                         $em->flush();
  640.                     }
  641.                     // FIN: Verificamos si es necesario actualizar las fechas de la reserva
  642.                 }
  643.             }
  644.         } else {
  645.             // registro antiguo, se pasara a los nuevos registros y luego duplicara
  646.             $loungeOld = $em->getRepository(ReservationLounge::class)->findByIdReservation($id);
  647.             foreach ($loungeOld as $item){
  648.                 if ($item->getDateStart()->format('Y-m-d') == $item->getDateEnd()->format('Y-m-d')){
  649.                     // Es el mismo dia, se crea un registro simple
  650.                     $newLoungeSimple = new ReservationLoungeSimple();
  651.                     $newLoungeSimple->setDateStart($item->getDateStart());
  652.                     $newLoungeSimple->setDateEnd($item->getDateEnd());
  653.                     $newLoungeSimple->setHourStart($item->getHourStart());
  654.                     $newLoungeSimple->setHourEnd($item->getHourEnd());
  655.                     $newLoungeSimple->setMinStart($item->getMinStart());
  656.                     $newLoungeSimple->setMinEnd($item->getMinEnd());
  657.                     $newLoungeSimple->setIdLounge($item->getIdLounge());
  658.                     $newLoungeSimple->setIdReservation($item->getIdReservation());
  659.                     $newLoungeSimple->setLoungeName($item->getLoungeName());
  660.                     $newLoungeSimple->setPax($item->getPax());
  661.                     $newLoungeSimple->setServicePrice($item->getServicePrice());
  662.                     $newLoungeSimple->setIva($item->getIva());
  663.                     $newLoungeSimple->setOpIva($item->getOpIva());
  664.                     $newLoungeSimple->setType($item->getType());
  665.                     $newLoungeSimple->setRankQuote($item->getRankQuote());
  666.                     $newLoungeSimple->setLoungeDescription($item->getLoungeDescription());
  667.                     $newLoungeSimple->setImportantDescription($item->getImportantDescription());
  668.                     $newLoungeSimple->setCreatedAt($createdAt);
  669.                     $newLoungeSimple->setCreatedBy($createdBy);
  670.                     $newLoungeSimple->setUpdatedAt($updatedAt);
  671.                     $newLoungeSimple->setUpdatedBy($updatedBy);
  673.                     try{
  674.                         $em->persist($newLoungeSimple);
  675.                         $em->flush();
  676.                         $event = 'The Item has been duplicated.';
  677.                         $successMessage = $this->translator->trans($event);
  678.                         $this->addFlash('mensajereservation', $successMessage);
  680.                     } catch (\Exception $e){
  682.                         $event = 'An error occurred: '.$e->getMessage();
  683.                         $errorMessage = $this->translator->trans($event);
  684.                         $this->addFlash('mensajereservationerror', $errorMessage);
  685.                     }
  687.                     // INICIO: Verificamos si es necesario actualizar las fechas de la reserva
  688.                     $boolReserva = false;
  689.                     if ($newLoungeSimple->getDateStart() < $reservax->getDateStart()){
  690.                         $reservax->setDateStart($newLoungeSimple->getDateStart());
  691.                         $boolReserva = true;
  692.                     }
  694.                     if ($reservax->getDateEnd() < $newLoungeSimple->getDateEnd()){
  695.                         $reservax->setDateEnd($newLoungeSimple->getDateEnd());
  696.                         $boolReserva = true;
  697.                     }
  698.                     if ($boolReserva){
  699.                         $em->persist($reservax);
  700.                         $em->flush();
  701.                     }
  702.                     // FIN: Verificamos si es necesario actualizar las fechas de la reserva
  704.                 } else {
  705.                     // Registro con varios dias, se calcula el numero de dias y se crean ese numero de registros nuevos
  706.                     $firstDay = $item->getDateStart();
  707.                     $firstDay = new DateTime($firstDay->format('Y-m-d'));
  708.                     $lastDay = $item->getDateEnd();
  709.                     $lastDay = new DateTime($lastDay->format('Y-m-d'));
  710.                     $numDays = ((($lastDay)->diff($firstDay))->days) +1;
  711.                     $actualDay = $item->getDateStart();
  712.                     $actualStartDay = $item->getDateStart();
  713.                     $actualEndDay = $item->getDateEnd();
  715.                     for ($i=0; $i<sizeof($numDays); $i++){
  716.                         // Se crea un registro por cada dia
  717.                         $newLoungeSimple = new ReservationLoungeSimple();
  718.                         if ($i == 0){
  719.                             // Primer dia
  720.                             $newLoungeSimple->setDateStart($actualStartDay);
  721.                             $actualStartDayEnd = new DateTime($actualStartDay->format('Y-m-d').' 23:59');
  722.                             $newLoungeSimple->setDateEnd($actualStartDayEnd);
  723.                             $newLoungeSimple->setHourStart($item->getHourStart());
  724.                             $newLoungeSimple->setHourEnd('23');
  725.                             $newLoungeSimple->setMinStart($item->getMinStart());
  726.                             $newLoungeSimple->setMinEnd('59');
  728.                         } else {
  729.                             if (($i + 1) == sizeof($numDays)){
  730.                                 // Ultimo dia
  731.                                 $actualEndDayStart = new DateTime($actualEndDay->format('Y-m-d').' 00:00');
  732.                                 $newLoungeSimple->setDateStart($actualEndDayStart);
  733.                                 $newLoungeSimple->setDateEnd($actualEndDay);
  734.                                 $newLoungeSimple->setHourStart('00');
  735.                                 $newLoungeSimple->setHourEnd($item->getHourEnd());
  736.                                 $newLoungeSimple->setMinStart('00');
  737.                                 $newLoungeSimple->setMinEnd($item->getMinEnd());
  739.                             } else {
  740.                                 // Dia intermedio
  741.                                 $actualMidDayStart = new DateTime($actualDay->format('Y-m-d').' 00:00');
  742.                                 $actualMidDayEnd = new DateTime($actualDay->format('Y-m-d').' 23:59');
  743.                                 $newLoungeSimple->setDateStart($actualMidDayStart);
  744.                                 $newLoungeSimple->setDateEnd($actualMidDayEnd);
  745.                                 $newLoungeSimple->setHourStart('00');
  746.                                 $newLoungeSimple->setHourEnd('23');
  747.                                 $newLoungeSimple->setMinStart('00');
  748.                                 $newLoungeSimple->setMinEnd('59');
  749.                             }
  750.                         }
  751.                         $newLoungeSimple->setIdLounge($item->getIdLounge());
  752.                         $newLoungeSimple->setIdReservation($item->getIdReservation());
  753.                         $newLoungeSimple->setLoungeName($item->getLoungeName());
  754.                         $newLoungeSimple->setPax($item->getPax());
  755.                         $newLoungeSimple->setServicePrice($item->getServicePrice());
  756.                         $newLoungeSimple->setIva($item->getIva());
  757.                         $newLoungeSimple->setOpIva($item->getOpIva());
  758.                         $newLoungeSimple->setType($item->getType());
  759.                         $newLoungeSimple->setRankQuote($item->getRankQuote());
  760.                         $newLoungeSimple->setLoungeDescription($item->getLoungeDescription());
  761.                         $newLoungeSimple->setImportantDescription($item->getImportantDescription());
  762.                         $newLoungeSimple->setCreatedAt($createdAt);
  763.                         $newLoungeSimple->setCreatedBy($createdBy);
  764.                         $newLoungeSimple->setUpdatedAt($updatedAt);
  765.                         $newLoungeSimple->setUpdatedBy($updatedBy);
  766.                         $actualDay = $actualDay->modify('+1 day');
  768.                         try{
  769.                             $em->persist($newLoungeSimple);
  770.                             $em->flush();
  771.                             $event = 'The Item has been updated.';
  772.                             $successMessage = $this->translator->trans($event);
  773.                             $this->addFlash('mensajereservation', $successMessage);
  775.                         } catch (\Exception $e){
  777.                             $event = 'An error occurred: '.$e->getMessage();
  778.                             $errorMessage = $this->translator->trans($event);
  779.                             $this->addFlash('mensajereservationerror', $errorMessage);
  780.                         }
  782.                         // INICIO: Verificamos si es necesario actualizar las fechas de la reserva
  783.                         $boolReserva = false;
  784.                         if ($newLoungeSimple->getDateStart() < $reservax->getDateStart()){
  785.                             $reservax->setDateStart($newLoungeSimple->getDateStart());
  786.                             $boolReserva = true;
  787.                         }
  789.                         if ($reservax->getDateEnd() < $newLoungeSimple->getDateEnd()){
  790.                             $reservax->setDateEnd($newLoungeSimple->getDateEnd());
  791.                             $boolReserva = true;
  792.                         }
  793.                         if ($boolReserva){
  794.                             $em->persist($reservax);
  795.                             $em->flush();
  796.                         }
  797.                         // FIN: Verificamos si es necesario actualizar las fechas de la reserva
  798.                     }
  799.                 }
  800.             }
  802.             // Se vuelve a llamar a este mismo controlador ahora con los registros en la nueva tabla
  803.             return $this->redirectToRoute('reservations_greenpatio_duplicate_day', array( 'id' => $id, 'dayduplicate' => $dayduplicate, ));
  804.         }
  806.         // Se debe redirigir para agregar el Servicio de limpieza
  807.         return $this->redirectToRoute('reservations_white_addservices_cleaning',
  808.             array(
  809.                 'resid' => $id,
  810.                 'loungesimpleid' => $newLoungeSimple->getId(),
  811.             ));
  812.     }
  815.     /**
  816.      * @Route("/deleteitemsimple/{id}/{daydelete}", name="reservations_greenpatio_delete_simple_lounge")
  817.      * Elimina un Reservation Simple Lounge de la cotizacion
  818.      */
  819.     public function deleteSimpleLoungeAction($id, $daydelete, EntityManagerInterface $em, Request $request)
  820.     {
  821.         $loungeSimple = $em->getRepository(ReservationLoungeSimple::class)->findOneById($id);
  822.         $id = $loungeSimple->getIdReservation();
  823.         $reserva = $em->getRepository(Reservation::class)->findOneById($loungeSimple->getIdReservation());
  825.         try{
  826.             $em->remove($loungeSimple);
  827.             $em->flush();
  828.             $event = 'The item has been deleted.';
  829.             $successMessage = $this->translator->trans($event);
  830.             $this->addFlash('mensajereservation', $successMessage);
  831.         } catch (\Exception $e){
  832.             $event = 'An error occurred: '.$e->getMessage();
  833.             $errorMessage = $this->translator->trans($event);
  834.             $this->addFlash('mensajereservationerror', $errorMessage);
  835.         }
  837.         // Si se elimina el primer dia o el ultimo, se debe modificar las fechas de la reserva
  838.         if(($reserva->getDateStart()->format('Ymd') == $loungeSimple->getDateStart()->format('Ymd')) or ($reserva->getDateEnd()->format('Ymd') == $loungeSimple->getDateEnd()->format('Ymd'))){
  839.             $allLoungeSimples = $em->getRepository(ReservationLoungeSimple::class)->findByIdReservation($reserva->getId());
  840.             if (!empty($allLoungeSimples)){
  841.                 $reserva->setDateStart(new DateTime('2999-01-01'));
  842.                 $reserva->setDateEnd(new DateTime('2000-01-01'));
  844.                 foreach ($allLoungeSimples as $newLoungeSimple){
  845.                     // INICIO: Verificamos si es necesario actualizar las fechas de la reserva
  846.                     $boolReserva = false;
  847.                     if ($newLoungeSimple->getDateStart() < $reserva->getDateStart()){
  848.                         $reserva->setDateStart($newLoungeSimple->getDateStart());
  849.                         $boolReserva = true;
  850.                     }
  852.                     if ($reserva->getDateEnd() < $newLoungeSimple->getDateEnd()){
  853.                         $reserva->setDateEnd($newLoungeSimple->getDateEnd());
  854.                         $boolReserva = true;
  855.                     }
  856.                     if ($boolReserva){
  857.                         $em->persist($reserva);
  858.                         $em->flush();
  859.                     }
  860.                     // FIN: Verificamos si es necesario actualizar las fechas de la reserva
  861.                 }
  862.             } else {
  863.                 // Se elimino la ultima sala y la reserva queda vacia
  864.                 $reserva->setDateStart(new DateTime('2999-01-01'));
  865.                 $reserva->setDateEnd(new DateTime('2000-01-01'));
  867.                 $em->persist($reserva);
  868.                 $em->flush();
  869.             }
  870.         }
  872.         // Se elimina el servicio de horas de limpieza de la sala
  873.         return $this->redirectToRoute('reservations_greenpatio_delete_simple_lounge_cleaning',
  874.             array(
  875.                 'idRes' => $id,
  876.                 'idLng' => $loungeSimple->getIdLounge(),
  877.                 'dateInAt' => $loungeSimple->getDateStart()->format('Y-m-d\TH:i'),
  878.                 'dateOutAt' => $loungeSimple->getDateEnd()->format('Y-m-d\TH:i'),
  879.             ));
  880.     }
  883.     /**
  884.      * @Route("/deletequote/{idRes}/{idQuote}", name="reservations_delete_quote")
  885.      * Eliminar una cotizancion
  886.      */
  887.     public function deleteQuoteAction( $idRes, $idQuote, EntityManagerInterface $em, Request $request)
  888.     {
  889.         $qb = $em->getRepository(ReservationLoungeSimple::class)->createQueryBuilder('r');
  890.         $reservation = $qb->where('r.rankQuote = :rankQuote')
  891.             ->andWhere('r.idReservation = :idReservation')
  892.             ->setParameter('idReservation', $idRes)
  893.             ->setParameter('rankQuote', $idQuote)
  894.             ->getQuery()
  895.             ->getResult();
  897.         foreach ($reservation as $item){
  898.             try{
  899.                 $em->remove($item);
  900.                 $em->flush();
  901.                 $event = 'Se ha eliminado la cotización';
  902.                 $successMessage = $this->translator->trans($event);
  903.                 $this->addFlash('mensajereservation', $successMessage);
  904.             } catch (\Exception $e){
  905.                 $event = 'An error occurred: '.$e->getMessage();
  906.                 $errorMessage = $this->translator->trans($event);
  907.                 $this->addFlash('mensajereservationerror', $errorMessage);
  908.             }
  910.             //Se deben eliminar todas las horas de limpieza asociadas a las salas de la cotización
  911.             $loungeDetails = $em->getRepository(ReservationLoungeDetails::class)->findOneById($item->getIdLounge());
  912.             $stringName = 'HORAS ( '.$loungeDetails->getName().' )';
  913.             $serviceCatIdClean = 21;
  914.             $dateInAt = new \DateTime($item->getDateStart()->format('Y-m-d\TH:i'));
  915.             $dateOutAt = new \DateTime($item->getDateEnd()->format('Y-m-d\TH:i'));
  917.             $qb = $em->getRepository(ReservationService::class)->createQueryBuilder('rs');
  919.             $serviceClean = $qb->where('rs.reservationId = :id')
  920.                 ->andWhere('rs.name = :name')
  921.                 ->andWhere('rs.dateInAt = :dateInAt')
  922.                 ->andWhere('rs.dateOutAt = :dateOutAt')
  923.                 ->andWhere('rs.serviceCatId = :serviceCatId')
  924.                 ->setParameter('id', $idRes)
  925.                 ->setParameter('name', $stringName)
  926.                 ->setParameter('dateInAt', $dateInAt)
  927.                 ->setParameter('dateOutAt', $dateOutAt)
  928.                 ->setParameter('serviceCatId', $serviceCatIdClean)
  929.                 ->getQuery()
  930.                 ->getResult();
  932.             if (!empty($serviceClean)) {
  933.                 // Se elimina el servicio de horas de limpieza de la sala
  934.                 $em->remove($serviceClean[0]);
  935.                 $em->flush();
  936.             }
  937.         }
  939.         return $this->redirectToRoute('reservations_greenpatio_edit_simple',
  940.             array(
  941.                 'id' => $idRes,
  942.                 'token' => null,
  943.                 '_fragment' => 'btn_quotes'
  944.             ));
  945.     }
  948.     /**
  949.      * @Route("/checkquote/{idRes}/{idQuote}", name="reservations_check_quote")
  950.      * Confirmación de que se ha aceptado la cotizancion, se eliminaran las otras cotizaciones del expediente
  951.      */
  952.     public function checkQuoteAction( $idRes, $idQuote, EntityManagerInterface $em, Request $request)
  953.     {
  954.         $qb = $em->getRepository(ReservationLoungeSimple::class)->createQueryBuilder('r');
  955.         $reservation = $qb->where('r.rankQuote <> :rankQuote')
  956.             ->andWhere('r.idReservation = :idReservation')
  957.             ->setParameter('idReservation', $idRes)
  958.             ->setParameter('rankQuote', $idQuote)
  959.             ->getQuery()
  960.             ->getResult();
  962.         foreach ($reservation as $item){
  963.             try{
  964.                 $em->remove($item);
  965.                 $em->flush();
  966.                 $event = 'Se han eliminado las otras cotizaciones';
  967.                 $successMessage = $this->translator->trans($event);
  968.                 $this->addFlash('mensajereservation', $successMessage);
  969.             } catch (\Exception $e){
  970.                 $event = 'An error occurred: '.$e->getMessage();
  971.                 $errorMessage = $this->translator->trans($event);
  972.                 $this->addFlash('mensajereservationerror', $errorMessage);
  973.             }
  974.         }
  976.         return $this->redirectToRoute('reservations_greenpatio_edit_simple',
  977.             array(
  978.                 'id' => $idRes,
  979.                 'token' => null,
  980.                 '_fragment' => 'btn_quotes'
  981.             ));
  982.     }
  985.     /**
  986.      * @Route("/duplicatequote", name="reservations_duplicate_quote")
  987.      * Duplicar una cotizacion
  988.      */
  989.     public function duplicateQuoteAction( EntityManagerInterface $em, Request $request) {
  991.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  992.         $user_id = $user_logueado->getId();
  993.         $hoy = new \DateTime("now", NULL);
  994.         $reqDuplicateQuote = $request->request->get('addquote');
  995.         $newLounge = $em->getRepository(ReservationLoungeDetails::class)->findOneById($reqDuplicateQuote['salaPrecargadas']);
  997.         $qb = $em->getRepository(ReservationLoungeSimple::class)->createQueryBuilder('r');
  998.         $reservationAll = $qb->where('r.idReservation = :idReservation')
  999.             ->setParameter('idReservation', $reqDuplicateQuote['reservationId'])
  1000.             ->orderBy('r.rankQuote', 'ASC')
  1001.             ->getQuery()
  1002.             ->getResult();
  1004.         $newRankId = (!empty($reservationAll)) ? (end($reservationAll)->getRankQuote() + 1) : 1;
  1005.         if (empty($reqDuplicateQuote['idQuote'])) { $reqDuplicateQuote['idQuote'] = reset($reservationAll)->getRankQuote(); }   //Si no elige cotización se duplica la primera
  1007.         $qb = $em->getRepository(ReservationLoungeSimple::class)->createQueryBuilder('r');
  1008.         $reservation = $qb->where('r.rankQuote = :rankQuote')
  1009.             ->andWhere('r.idReservation = :idReservation')
  1010.             ->setParameter('idReservation', $reqDuplicateQuote['reservationId'])
  1011.             ->setParameter('rankQuote', $reqDuplicateQuote['idQuote'])
  1012.             ->getQuery()
  1013.             ->getResult();
  1015.         foreach ($reservation as $item){
  1016.             $newLoungeSimple = new ReservationLoungeSimple();
  1017.             $newLoungeSimple->setDateStart($item->getDateStart());
  1018.             $newLoungeSimple->setDateEnd($item->getDateEnd());
  1019.             $newLoungeSimple->setIdReservation($reqDuplicateQuote['reservationId']);
  1020.             $newLoungeSimple->setPax($item->getPax());
  1021.             $newLoungeSimple->setType($item->getType());
  1022.             $newLoungeSimple->setCreatedAt($hoy);
  1023.             $newLoungeSimple->setCreatedBy($user_id);
  1024.             $newLoungeSimple->setUpdatedAt($hoy);
  1025.             $newLoungeSimple->setUpdatedBy($user_id);
  1026.             $newLoungeSimple->setHourStart($item->getHourStart());
  1027.             $newLoungeSimple->setMinStart($item->getMinStart());
  1028.             $newLoungeSimple->setHourEnd($item->getHourEnd());
  1029.             $newLoungeSimple->setMinEnd($item->getMinEnd());
  1030.             $newLoungeSimple->setRankQuote($newRankId);
  1031.             $newLoungeSimple->setIva($item->getIva());
  1032.             $newLoungeSimple->setOpIva($item->getOpIva());
  1033.             $newLoungeSimple->setIdLounge($newLounge->getId());
  1034.             $newLoungeSimple->setLoungename($newLounge->getName());
  1035. //            $newLoungeSimple->setLoungeDescription($item->getLoungeDescription());
  1036.             $newLoungeSimple->setImportantDescription($newLounge->getImportantDescription());
  1037.             $newLoungeSimple->setImportantDescGeneralText($newLounge->getImportantDescGeneralText());
  1038.             $newLoungeSimple->setImportantDescSchedules($newLounge->getImportantDescSchedules());
  1039.             $newLoungeSimple->setImportantDescParking($newLounge->getImportantDescParking());
  1041.             if (!empty($reqDuplicateQuote['salaPrice'])){ $newLoungeSimple->setServicePrice($reqDuplicateQuote['salaPrice']); }  else { $newLoungeSimple->setServicePrice($item->getServicePrice());}
  1043.             try{
  1044.                 $em->persist($newLoungeSimple);
  1045.                 $em->flush();
  1046.                 $event = 'Se ha agregado la nueva cotización';
  1047.                 $successMessage = $this->translator->trans($event);
  1048.                 $this->addFlash('mensajereservation', $successMessage);
  1049.             } catch (\Exception $e){
  1050.                 $event = 'An error occurred: '.$e->getMessage();
  1051.                 $errorMessage = $this->translator->trans($event);
  1052.                 $this->addFlash('mensajereservationerror', $errorMessage);
  1053.             }
  1055.             // Se debe agregar el servicio de limpieza por cada sala que se agregue
  1056.             $resLoungeSimple = $newLoungeSimple;
  1057.             $service= new ReservationService();
  1058.             $service->setReservationId($reqDuplicateQuote['reservationId']);
  1059.             $service->setSupplierId(0);
  1060.             $service->setDateInAt($resLoungeSimple->getDateStart());
  1061.             $service->setDateOutAt($resLoungeSimple->getDateEnd());
  1063.             /* Obtengo usuario logueado */
  1064.             $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1065.             $user_id = $user_logueado->getId();
  1067.             $service->setCreatedId($user_id);
  1068.             $service->setUpdatedId($user_id);
  1069.             $service->setCreatedAt(new \DateTime("now"));
  1070.             $service->setUpdatedAt(new \DateTime("now"));
  1072.             $service->setServiceCatId('21');
  1073.             $service->setServiceCatName('Limpieza');
  1074.             $service->setContcolor('green-300');
  1075.             $service->setName('HORAS ( '.$resLoungeSimple->getLoungeName().' )');
  1076.             $service->setPrice('14');
  1077.             $service->setCurrency('Euro');
  1078.             $service->setUnits('8');
  1079.             $service->setCommission('0');
  1080.             $service->setIva('0');
  1081.             $service->setPax('0');
  1082.             $service->setOver('0');
  1083.             $service->setIva('21');
  1084.             $service->setOpIva('1');
  1085.             $service->setOpCommission('1');
  1086.             $service->setCommission('57.14');
  1087.             $service->setViewInfo(0);
  1088.             $service->setToinvoice(0);
  1089.             $service->setServiceId(0);
  1091.             $em->persist($service);
  1092.             $em->flush();
  1093.         }
  1095.         return $this->redirectToRoute('reservations_greenpatio_edit_simple',
  1096.             array(
  1097.                 'id' => $reqDuplicateQuote['reservationId'],
  1098.                 'token' => null,
  1099.                 '_fragment' => 'btn_quotes'
  1100.             ));
  1101.     }
  1105.     private function precioPorFecha($date, $loungeId){
  1107.         return array( 'price' => 0, );
  1109.         $em = $this->getDoctrine()->getManager();
  1110.         $price0 = null;
  1112.         // Buscamos por año
  1113.         $parameters = array( 'dateYear' => $date->format('Y'), 'loungeId' => $loungeId, 'priceIsActive' => true, );
  1114.         $dql = 'SELECT i
  1115.                 FROM GreenPatioBundle:ReservationLoungeProfile i
  1116.                 WHERE  ((i.year1 <= :dateYear and i.year2 >= :dateYear) ) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive';
  1118.         $query = $em->createQuery($dql)->setParameters($parameters);
  1119.         $price1 = $query->getResult();
  1121.         // Buscamos por año y mes
  1122.         $parameters = array( 'dateYear' => $date->format('Y'), 'month' => true, 'loungeId' => $loungeId, 'priceIsActive' => true, );
  1124.         switch ($date->format('m')) {
  1125.             case '01': //Enero
  1126.                 $dql = 'SELECT i
  1127.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1128.                     WHERE (
  1129.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1130.                           AND (i.month1 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1131.                       ';
  1132.                 break;
  1134.             case '02': //Febrero
  1135.                 $dql = 'SELECT i
  1136.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1137.                     WHERE (
  1138.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1139.                           AND (i.month2 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1140.                       ';
  1141.                 break;
  1143.             case '03': //Marzo
  1144.                 $dql = 'SELECT i
  1145.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1146.                     WHERE (
  1147.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1148.                           AND (i.month3 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1149.                       ';
  1150.                 break;
  1152.             case '04': //Abril
  1153.                 $dql = 'SELECT i
  1154.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1155.                     WHERE (
  1156.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1157.                           AND (i.month4 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1158.                       ';
  1159.                 break;
  1161.             case '05': //Mayo
  1162.                 $dql = 'SELECT i
  1163.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1164.                     WHERE (
  1165.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1166.                           AND (i.month5 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1167.                       ';
  1168.                 break;
  1170.             case '06': //Junio
  1171.                 $dql = 'SELECT i
  1172.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1173.                     WHERE (
  1174.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1175.                           AND (i.month6 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1176.                       ';
  1177.                 break;
  1179.             case '07': //Julio
  1180.                 $dql = 'SELECT i
  1181.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1182.                     WHERE (
  1183.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1184.                           AND (i.month7 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1185.                       ';
  1186.                 break;
  1188.             case '08': //Agosto
  1189.                 $dql = 'SELECT i
  1190.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1191.                     WHERE (
  1192.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1193.                           AND (i.month8 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1194.                       ';
  1195.                 break;
  1197.             case '09': //Septiembre
  1198.                 $dql = 'SELECT i
  1199.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1200.                     WHERE (
  1201.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1202.                           AND (i.month9 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1203.                       ';
  1204.                 break;
  1206.             case '10': //Octubre
  1207.                 $dql = 'SELECT i
  1208.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1209.                     WHERE (
  1210.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1211.                           AND (i.month10 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1212.                       ';
  1213.                 break;
  1215.             case '11': //Noviembre
  1216.                 $dql = 'SELECT i
  1217.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1218.                     WHERE (
  1219.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1220.                           AND (i.month11 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1221.                       ';
  1222.                 break;
  1224.             case '12': //Diciembre
  1225.                 $dql = 'SELECT i
  1226.                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1227.                     WHERE (
  1228.                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1229.                           AND (i.month12 = :month)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1230.                       ';
  1231.                 break;
  1233.             default:
  1234.                 break;
  1235.         }
  1237.         $query = $em->createQuery($dql)->setParameters($parameters);
  1238.         $price2 = $query->getResult();
  1240.         // Buscamos por año, mes y dia de la semana
  1241.         $parameters = array( 'dateYear' => $date->format('Y'), 'month' => true, 'day' => true, 'loungeId' => $loungeId, 'priceIsActive' => true, );
  1243.         switch ($date->format('m')) {
  1244.             case '01': //Enero
  1245.                 switch ($date->format('l')) {
  1246.                     case 'Monday': //Lunes
  1247.                         $dql = 'SELECT i
  1248.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1249.                                     WHERE (
  1250.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1251.                                           AND (i.month1 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1252.                                       ';
  1253.                         break;
  1255.                     case 'Tuesday': //Martes
  1256.                         $dql = 'SELECT i
  1257.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1258.                                     WHERE (
  1259.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1260.                                           AND (i.month1 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1261.                                       ';
  1262.                         break;
  1264.                     case 'Wednesday': //Miercoles
  1265.                         $dql = 'SELECT i
  1266.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1267.                                     WHERE (
  1268.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1269.                                           AND (i.month1 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1270.                                       ';
  1271.                         break;
  1273.                     case 'Thursday': //Jueves
  1274.                         $dql = 'SELECT i
  1275.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1276.                                     WHERE (
  1277.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1278.                                           AND (i.month1 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1279.                                       ';
  1280.                         break;
  1282.                     case 'Friday': //Viernes
  1283.                         $dql = 'SELECT i
  1284.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1285.                                     WHERE (
  1286.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1287.                                           AND (i.month1 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1288.                                       ';
  1289.                         break;
  1291.                     case 'Saturday': //Sabado
  1292.                         $dql = 'SELECT i
  1293.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1294.                                     WHERE (
  1295.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1296.                                           AND (i.month1 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1297.                                       ';
  1298.                         break;
  1300.                     case 'Sunday': //Domingo
  1301.                         $dql = 'SELECT i
  1302.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1303.                                     WHERE (
  1304.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1305.                                           AND (i.month1 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1306.                                       ';
  1307.                         break;
  1308.                     default: break;
  1309.                 }
  1310.                 break;
  1312.             case '02': //Febrero
  1314.                 switch ($date->format('l')) {
  1315.                     case 'Monday': //Lunes
  1316.                         $dql = 'SELECT i
  1317.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1318.                                     WHERE (
  1319.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1320.                                           AND (i.month2 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1321.                                       ';
  1322.                         break;
  1324.                     case 'Tuesday': //Martes
  1325.                         $dql = 'SELECT i
  1326.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1327.                                     WHERE (
  1328.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1329.                                           AND (i.month2 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1330.                                       ';
  1331.                         break;
  1333.                     case 'Wednesday': //Miercoles
  1334.                         $dql = 'SELECT i
  1335.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1336.                                     WHERE (
  1337.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1338.                                           AND (i.month2 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1339.                                       ';
  1340.                         break;
  1342.                     case 'Thursday': //Jueves
  1343.                         $dql = 'SELECT i
  1344.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1345.                                     WHERE (
  1346.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1347.                                           AND (i.month2 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1348.                                       ';
  1349.                         break;
  1351.                     case 'Friday': //Viernes
  1352.                         $dql = 'SELECT i
  1353.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1354.                                     WHERE (
  1355.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1356.                                           AND (i.month2 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1357.                                       ';
  1358.                         break;
  1360.                     case 'Saturday': //Sabado
  1361.                         $dql = 'SELECT i
  1362.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1363.                                     WHERE (
  1364.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1365.                                           AND (i.month2 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1366.                                       ';
  1367.                         break;
  1369.                     case 'Sunday': //Domingo
  1370.                         $dql = 'SELECT i
  1371.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1372.                                     WHERE (
  1373.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1374.                                           AND (i.month2 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1375.                                       ';
  1376.                         break;
  1378.                     default: break;
  1379.                 }
  1381.                 break;
  1383.             case '03': //Marzo
  1385.                 switch ($date->format('l')) {
  1386.                     case 'Monday': //Lunes
  1387.                         $dql = 'SELECT i
  1388.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1389.                                     WHERE (
  1390.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1391.                                           AND (i.month3 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1392.                                       ';
  1393.                         break;
  1395.                     case 'Tuesday': //Martes
  1396.                         $dql = 'SELECT i
  1397.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1398.                                     WHERE (
  1399.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1400.                                           AND (i.month3 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1401.                                       ';
  1402.                         break;
  1404.                     case 'Wednesday': //Miercoles
  1405.                         $dql = 'SELECT i
  1406.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1407.                                     WHERE (
  1408.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1409.                                           AND (i.month3 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1410.                                       ';
  1411.                         break;
  1413.                     case 'Thursday': //Jueves
  1414.                         $dql = 'SELECT i
  1415.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1416.                                     WHERE (
  1417.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1418.                                           AND (i.month3 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1419.                                       ';
  1420.                         break;
  1422.                     case 'Friday': //Viernes
  1423.                         $dql = 'SELECT i
  1424.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1425.                                     WHERE (
  1426.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1427.                                           AND (i.month3 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1428.                                       ';
  1429.                         break;
  1431.                     case 'Saturday': //Sabado
  1432.                         $dql = 'SELECT i
  1433.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1434.                                     WHERE (
  1435.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1436.                                           AND (i.month3 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1437.                                       ';
  1438.                         break;
  1440.                     case 'Sunday': //Domingo
  1441.                         $dql = 'SELECT i
  1442.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1443.                                     WHERE (
  1444.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1445.                                           AND (i.month3 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1446.                                       ';
  1447.                         break;
  1449.                     default: break;
  1450.                 }
  1452.                 break;
  1454.             case '04': //Abril
  1456.                 switch ($date->format('l')) {
  1457.                     case 'Monday': //Lunes
  1458.                         $dql = 'SELECT i
  1459.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1460.                                     WHERE (
  1461.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1462.                                           AND (i.month4 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1463.                                       ';
  1464.                         break;
  1466.                     case 'Tuesday': //Martes
  1467.                         $dql = 'SELECT i
  1468.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1469.                                     WHERE (
  1470.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1471.                                           AND (i.month4 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1472.                                       ';
  1473.                         break;
  1475.                     case 'Wednesday': //Miercoles
  1476.                         $dql = 'SELECT i
  1477.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1478.                                     WHERE (
  1479.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1480.                                           AND (i.month4 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1481.                                       ';
  1482.                         break;
  1484.                     case 'Thursday': //Jueves
  1485.                         $dql = 'SELECT i
  1486.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1487.                                     WHERE (
  1488.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1489.                                           AND (i.month4 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1490.                                       ';
  1491.                         break;
  1493.                     case 'Friday': //Viernes
  1494.                         $dql = 'SELECT i
  1495.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1496.                                     WHERE (
  1497.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1498.                                           AND (i.month4 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1499.                                       ';
  1500.                         break;
  1502.                     case 'Saturday': //Sabado
  1503.                         $dql = 'SELECT i
  1504.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1505.                                     WHERE (
  1506.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1507.                                           AND (i.month4 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1508.                                       ';
  1509.                         break;
  1511.                     case 'Sunday': //Domingo
  1512.                         $dql = 'SELECT i
  1513.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1514.                                     WHERE (
  1515.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1516.                                           AND (i.month4 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1517.                                       ';
  1518.                         break;
  1520.                     default: break;
  1521.                 }
  1523.                 break;
  1525.             case '05': //Mayo
  1527.                 switch ($date->format('l')) {
  1528.                     case 'Monday': //Lunes
  1529.                         $dql = 'SELECT i
  1530.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1531.                                     WHERE (
  1532.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1533.                                           AND (i.month5 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1534.                                       ';
  1535.                         break;
  1537.                     case 'Tuesday': //Martes
  1538.                         $dql = 'SELECT i
  1539.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1540.                                     WHERE (
  1541.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1542.                                           AND (i.month5 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1543.                                       ';
  1544.                         break;
  1546.                     case 'Wednesday': //Miercoles
  1547.                         $dql = 'SELECT i
  1548.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1549.                                     WHERE (
  1550.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1551.                                           AND (i.month5 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1552.                                       ';
  1553.                         break;
  1555.                     case 'Thursday': //Jueves
  1556.                         $dql = 'SELECT i
  1557.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1558.                                     WHERE (
  1559.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1560.                                           AND (i.month5 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1561.                                       ';
  1562.                         break;
  1564.                     case 'Friday': //Viernes
  1565.                         $dql = 'SELECT i
  1566.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1567.                                     WHERE (
  1568.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1569.                                           AND (i.month5 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1570.                                       ';
  1571.                         break;
  1573.                     case 'Saturday': //Sabado
  1574.                         $dql = 'SELECT i
  1575.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1576.                                     WHERE (
  1577.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1578.                                           AND (i.month5 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1579.                                       ';
  1580.                         break;
  1582.                     case 'Sunday': //Domingo
  1583.                         $dql = 'SELECT i
  1584.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1585.                                     WHERE (
  1586.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1587.                                           AND (i.month5 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1588.                                       ';
  1589.                         break;
  1591.                     default: break;
  1592.                 }
  1594.                 break;
  1596.             case '06': //Junio
  1598.                 switch ($date->format('l')) {
  1599.                     case 'Monday': //Lunes
  1600.                         $dql = 'SELECT i
  1601.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1602.                                     WHERE (
  1603.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1604.                                           AND (i.month6 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1605.                                       ';
  1606.                         break;
  1608.                     case 'Tuesday': //Martes
  1609.                         $dql = 'SELECT i
  1610.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1611.                                     WHERE (
  1612.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1613.                                           AND (i.month6 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1614.                                       ';
  1615.                         break;
  1617.                     case 'Wednesday': //Miercoles
  1618.                         $dql = 'SELECT i
  1619.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1620.                                     WHERE (
  1621.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1622.                                           AND (i.month6 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1623.                                       ';
  1624.                         break;
  1626.                     case 'Thursday': //Jueves
  1627.                         $dql = 'SELECT i
  1628.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1629.                                     WHERE (
  1630.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1631.                                           AND (i.month6 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1632.                                       ';
  1633.                         break;
  1635.                     case 'Friday': //Viernes
  1636.                         $dql = 'SELECT i
  1637.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1638.                                     WHERE (
  1639.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1640.                                           AND (i.month6 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1641.                                       ';
  1642.                         break;
  1644.                     case 'Saturday': //Sabado
  1645.                         $dql = 'SELECT i
  1646.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1647.                                     WHERE (
  1648.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1649.                                           AND (i.month6 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1650.                                       ';
  1651.                         break;
  1653.                     case 'Sunday': //Domingo
  1654.                         $dql = 'SELECT i
  1655.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1656.                                     WHERE (
  1657.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1658.                                           AND (i.month6 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1659.                                       ';
  1660.                         break;
  1662.                     default: break;
  1663.                 }
  1665.                 break;
  1667.             case '07': //Julio
  1669.                 switch ($date->format('l')) {
  1670.                     case 'Monday': //Lunes
  1671.                         $dql = 'SELECT i
  1672.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1673.                                     WHERE (
  1674.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1675.                                           AND (i.month7 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1676.                                       ';
  1677.                         break;
  1679.                     case 'Tuesday': //Martes
  1680.                         $dql = 'SELECT i
  1681.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1682.                                     WHERE (
  1683.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1684.                                           AND (i.month7 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1685.                                       ';
  1686.                         break;
  1688.                     case 'Wednesday': //Miercoles
  1689.                         $dql = 'SELECT i
  1690.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1691.                                     WHERE (
  1692.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1693.                                           AND (i.month7 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1694.                                       ';
  1695.                         break;
  1697.                     case 'Thursday': //Jueves
  1698.                         $dql = 'SELECT i
  1699.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1700.                                     WHERE (
  1701.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1702.                                           AND (i.month7 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1703.                                       ';
  1704.                         break;
  1706.                     case 'Friday': //Viernes
  1707.                         $dql = 'SELECT i
  1708.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1709.                                     WHERE (
  1710.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1711.                                           AND (i.month7 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1712.                                       ';
  1713.                         break;
  1715.                     case 'Saturday': //Sabado
  1716.                         $dql = 'SELECT i
  1717.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1718.                                     WHERE (
  1719.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1720.                                           AND (i.month7 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1721.                                       ';
  1722.                         break;
  1724.                     case 'Sunday': //Domingo
  1725.                         $dql = 'SELECT i
  1726.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1727.                                     WHERE (
  1728.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1729.                                           AND (i.month7 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1730.                                       ';
  1731.                         break;
  1733.                     default: break;
  1734.                 }
  1736.                 break;
  1738.             case '08': //Agosto
  1740.                 switch ($date->format('l')) {
  1741.                     case 'Monday': //Lunes
  1742.                         $dql = 'SELECT i
  1743.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1744.                                     WHERE (
  1745.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1746.                                           AND (i.month8 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1747.                                       ';
  1748.                         break;
  1750.                     case 'Tuesday': //Martes
  1751.                         $dql = 'SELECT i
  1752.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1753.                                     WHERE (
  1754.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1755.                                           AND (i.month8 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1756.                                       ';
  1757.                         break;
  1759.                     case 'Wednesday': //Miercoles
  1760.                         $dql = 'SELECT i
  1761.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1762.                                     WHERE (
  1763.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1764.                                           AND (i.month8 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1765.                                       ';
  1766.                         break;
  1768.                     case 'Thursday': //Jueves
  1769.                         $dql = 'SELECT i
  1770.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1771.                                     WHERE (
  1772.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1773.                                           AND (i.month8 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1774.                                       ';
  1775.                         break;
  1777.                     case 'Friday': //Viernes
  1778.                         $dql = 'SELECT i
  1779.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1780.                                     WHERE (
  1781.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1782.                                           AND (i.month8 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1783.                                       ';
  1784.                         break;
  1786.                     case 'Saturday': //Sabado
  1787.                         $dql = 'SELECT i
  1788.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1789.                                     WHERE (
  1790.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1791.                                           AND (i.month8 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1792.                                       ';
  1793.                         break;
  1795.                     case 'Sunday': //Domingo
  1796.                         $dql = 'SELECT i
  1797.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1798.                                     WHERE (
  1799.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1800.                                           AND (i.month8 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1801.                                       ';
  1802.                         break;
  1804.                     default: break;
  1805.                 }
  1807.                 break;
  1809.             case '09': //Septiembre
  1811.                 switch ($date->format('l')) {
  1812.                     case 'Monday': //Lunes
  1813.                         $dql = 'SELECT i
  1814.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1815.                                     WHERE (
  1816.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1817.                                           AND (i.month9 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1818.                                       ';
  1819.                         break;
  1821.                     case 'Tuesday': //Martes
  1822.                         $dql = 'SELECT i
  1823.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1824.                                     WHERE (
  1825.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1826.                                           AND (i.month9 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1827.                                       ';
  1828.                         break;
  1830.                     case 'Wednesday': //Miercoles
  1831.                         $dql = 'SELECT i
  1832.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1833.                                     WHERE (
  1834.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1835.                                           AND (i.month9 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1836.                                       ';
  1837.                         break;
  1839.                     case 'Thursday': //Jueves
  1840.                         $dql = 'SELECT i
  1841.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1842.                                     WHERE (
  1843.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1844.                                           AND (i.month9 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1845.                                       ';
  1846.                         break;
  1848.                     case 'Friday': //Viernes
  1849.                         $dql = 'SELECT i
  1850.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1851.                                     WHERE (
  1852.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1853.                                           AND (i.month9 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1854.                                       ';
  1855.                         break;
  1857.                     case 'Saturday': //Sabado
  1858.                         $dql = 'SELECT i
  1859.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1860.                                     WHERE (
  1861.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1862.                                           AND (i.month9 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1863.                                       ';
  1864.                         break;
  1866.                     case 'Sunday': //Domingo
  1867.                         $dql = 'SELECT i
  1868.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1869.                                     WHERE (
  1870.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1871.                                           AND (i.month9 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1872.                                       ';
  1873.                         break;
  1875.                     default: break;
  1876.                 }
  1878.                 break;
  1880.             case '10': //Octubre
  1882.                 switch ($date->format('l')) {
  1883.                     case 'Monday': //Lunes
  1884.                         $dql = 'SELECT i
  1885.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1886.                                     WHERE (
  1887.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1888.                                           AND (i.month10 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1889.                                       ';
  1890.                         break;
  1892.                     case 'Tuesday': //Martes
  1893.                         $dql = 'SELECT i
  1894.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1895.                                     WHERE (
  1896.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1897.                                           AND (i.month10 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1898.                                       ';
  1899.                         break;
  1901.                     case 'Wednesday': //Miercoles
  1902.                         $dql = 'SELECT i
  1903.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1904.                                     WHERE (
  1905.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1906.                                           AND (i.month10 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1907.                                       ';
  1908.                         break;
  1910.                     case 'Thursday': //Jueves
  1911.                         $dql = 'SELECT i
  1912.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1913.                                     WHERE (
  1914.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1915.                                           AND (i.month10 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1916.                                       ';
  1917.                         break;
  1919.                     case 'Friday': //Viernes
  1920.                         $dql = 'SELECT i
  1921.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1922.                                     WHERE (
  1923.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1924.                                           AND (i.month10 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1925.                                       ';
  1926.                         break;
  1928.                     case 'Saturday': //Sabado
  1929.                         $dql = 'SELECT i
  1930.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1931.                                     WHERE (
  1932.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1933.                                           AND (i.month10 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1934.                                       ';
  1935.                         break;
  1937.                     case 'Sunday': //Domingo
  1938.                         $dql = 'SELECT i
  1939.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1940.                                     WHERE (
  1941.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1942.                                           AND (i.month10 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1943.                                       ';
  1944.                         break;
  1946.                     default: break;
  1947.                 }
  1949.                 break;
  1951.             case '11': //Noviembre
  1953.                 switch ($date->format('l')) {
  1954.                     case 'Monday': //Lunes
  1955.                         $dql = 'SELECT i
  1956.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1957.                                     WHERE (
  1958.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1959.                                           AND (i.month11 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1960.                                       ';
  1961.                         break;
  1963.                     case 'Tuesday': //Martes
  1964.                         $dql = 'SELECT i
  1965.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1966.                                     WHERE (
  1967.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1968.                                           AND (i.month11 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1969.                                       ';
  1970.                         break;
  1972.                     case 'Wednesday': //Miercoles
  1973.                         $dql = 'SELECT i
  1974.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1975.                                     WHERE (
  1976.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1977.                                           AND (i.month11 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1978.                                       ';
  1979.                         break;
  1981.                     case 'Thursday': //Jueves
  1982.                         $dql = 'SELECT i
  1983.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1984.                                     WHERE (
  1985.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1986.                                           AND (i.month11 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1987.                                       ';
  1988.                         break;
  1990.                     case 'Friday': //Viernes
  1991.                         $dql = 'SELECT i
  1992.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  1993.                                     WHERE (
  1994.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  1995.                                           AND (i.month11 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  1996.                                       ';
  1997.                         break;
  1999.                     case 'Saturday': //Sabado
  2000.                         $dql = 'SELECT i
  2001.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2002.                                     WHERE (
  2003.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2004.                                           AND (i.month11 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2005.                                       ';
  2006.                         break;
  2008.                     case 'Sunday': //Domingo
  2009.                         $dql = 'SELECT i
  2010.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2011.                                     WHERE (
  2012.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2013.                                           AND (i.month11 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2014.                                       ';
  2015.                         break;
  2017.                     default: break;
  2018.                 }
  2020.                 break;
  2022.             case '12': //Diciembre
  2024.                 switch ($date->format('l')) {
  2025.                     case 'Monday': //Lunes
  2026.                         $dql = 'SELECT i
  2027.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2028.                                     WHERE (
  2029.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2030.                                           AND (i.month12 = :month) AND (i.day1 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2031.                                       ';
  2032.                         break;
  2034.                     case 'Tuesday': //Martes
  2035.                         $dql = 'SELECT i
  2036.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2037.                                     WHERE (
  2038.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2039.                                           AND (i.month12 = :month) AND (i.day2 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2040.                                       ';
  2041.                         break;
  2043.                     case 'Wednesday': //Miercoles
  2044.                         $dql = 'SELECT i
  2045.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2046.                                     WHERE (
  2047.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2048.                                           AND (i.month12 = :month) AND (i.day3 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2049.                                       ';
  2050.                         break;
  2052.                     case 'Thursday': //Jueves
  2053.                         $dql = 'SELECT i
  2054.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2055.                                     WHERE (
  2056.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2057.                                           AND (i.month12 = :month) AND (i.day4 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2058.                                       ';
  2059.                         break;
  2061.                     case 'Friday': //Viernes
  2062.                         $dql = 'SELECT i
  2063.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2064.                                     WHERE (
  2065.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2066.                                           AND (i.month12 = :month) AND (i.day5 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2067.                                       ';
  2068.                         break;
  2070.                     case 'Saturday': //Sabado
  2071.                         $dql = 'SELECT i
  2072.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2073.                                     WHERE (
  2074.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2075.                                           AND (i.month12 = :month) AND (i.day6 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2076.                                       ';
  2077.                         break;
  2079.                     case 'Sunday': //Domingo
  2080.                         $dql = 'SELECT i
  2081.                                     FROM GreenPatioBundle:ReservationLoungeProfile i
  2082.                                     WHERE (
  2083.                                     ((i.year1 <= :dateYear and i.year2 >= :dateYear) or (i.year1 = :dateYear) or (i.year2 = :dateYear))
  2084.                                           AND (i.month12 = :month) AND (i.day7 = :day)) and i.loungeId = :loungeId and i.priceIsActive = :priceIsActive
  2085.                                       ';
  2086.                         break;
  2088.                     default: break;
  2089.                 }
  2091.                 break;
  2093.             default:
  2094.                 break;
  2095.         }
  2097.         $query = $em->createQuery($dql)->setParameters($parameters);
  2098.         $price3 = $query->getResult();
  2100.         foreach ($price3 as $item){
  2101.             if (empty($price0)){
  2102.                 $price0 = $item;
  2103.             } else {
  2104.                 //Si los precios coinciden en fechas se tomara el que se haya cargado mas reciente en el sistema
  2105.                 if ($item->getCreatedAt() > $price0->getCreatedAt()){ $price0 = $item; }
  2106.             }
  2107.         }
  2108.         if(empty($price0)){ $price = 0; } else { $price = $price0->getPrice(); }
  2110.         return array( 'price' => $price, );
  2111.     }
  2112. }