src/MDS/ApiBundle/Controller/ApiProposalsClientController.php line 424

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace App\MDS\ApiBundle\Controller;
  7. use App\Entity\ClientContact;
  8. use App\MDS\VenuesBundle\Entity\Reservation;
  9. use App\MDS\VenuesBundle\Entity\ReservationLoungeDetails;
  10. use App\MDS\VenuesBundle\Entity\ReservationLoungeDescription;
  11. use App\MDS\VenuesBundle\Entity\ReservationLoungeSimple;
  12. use App\MDS\VenuesBundle\Entity\ReservationLoungePicture;
  13. use App\MDS\VenuesBundle\Entity\ReservationService;
  14. use App\MDS\AvexpressBundle\Entity\AveProduct;
  15. use App\MDS\AvexpressBundle\Entity\AvePackageTemplate;
  16. use App\MDS\AvexpressBundle\Entity\AvePackageTemplateItems;
  17. use Doctrine\ORM\EntityManagerInterface;
  18. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  19. use Symfony\Component\HttpFoundation\JsonResponse;
  20. use Symfony\Component\HttpFoundation\Request;
  21. use Symfony\Component\HttpFoundation\Response;
  22. use Symfony\Component\Routing\Annotation\Route;
  24. class ApiProposalsClientController extends AbstractController
  25. {
  26.     public function __construct(
  27.         private readonly EntityManagerInterface $em
  28.     ) {}
  30.     
  32. /**
  33.      * @Route("/api/client/proposal/{token}/recommended/avproducts", name="api_proposal_recommended_products", methods={"GET", "POST"})
  34.      * Recoger la selección de productos y packs enviados por el cliente desde la web y asociarlos a la reserva general por Opción
  35.      */
  36.     public function processRecommendedProductsAction(string $token, Request $request): JsonResponse
  37.     {
  38.         /** @var Reservation|null $reservation */
  39.         $reservation = $this->em->getRepository(Reservation::class)->findOneBy(['token' => $token]);
  40.         
  41.         if (!$reservation) {
  42.             return new JsonResponse([
  43.                 'success' => false, 
  44.                 'error' => 'No se encontró ninguna reserva asociada al token proporcionado.'
  45.             ], Response::HTTP_NOT_FOUND);
  46.         }
  48.         $content = $request->getContent();
  49.         if (empty($content)) {
  50.             return new JsonResponse(['success' => false, 'error' => 'El cuerpo de la petición está vacío.'], Response::HTTP_BAD_REQUEST);
  51.         }
  53.         $payload = json_decode($content, true);
  54.         if (json_last_error() !== JSON_ERROR_NONE) {
  55.             return new JsonResponse(['success' => false, 'error' => 'Formato JSON inválido.'], Response::HTTP_BAD_REQUEST);
  56.         }
  58.         // Aceptamos tanto la clave "products" como "avProducts" enviada desde la web
  59.         $rawProducts = $payload['products'] ?? $payload['avProducts'] ?? null;
  60.         if (!is_array($rawProducts)) {
  61.             return new JsonResponse(['success' => false, 'error' => 'Estructura JSON incorrecta (se esperaba array de productos).'], Response::HTTP_BAD_REQUEST);
  62.         }
  64.         $processedItems = [];
  65.         $errors = [];
  66.         $ahora = new \DateTime("now");
  67.         
  68.         $userId = $this->getUser() && method_exists($this->getUser(), 'getId') ? $this->getUser()->getId() : 1;
  70.         $this->em->beginTransaction();
  72.         try {
  73.             // Actualización de ajustes de Lounges si se envían
  74.             if (isset($payload['loungeSettings']) && is_array($payload['loungeSettings'])) {
  75.                 foreach ($payload['loungeSettings'] as $setting) {
  76.                     $loungeId = filter_var($setting['loungeId'] ?? null, FILTER_VALIDATE_INT);
  77.                     if ($loungeId) {
  78.                         $loungeEntity = $this->em->getRepository(ReservationLoungeSimple::class)->find($loungeId);
  79.                         if ($loungeEntity && (int)$loungeEntity->getIdReservation() === (int)$reservation->getId()) {
  80.                             if (isset($setting['showAudiovisualPrice'])) {
  81.                                 $loungeEntity->setShowAudiovisualPrice((bool)$setting['showAudiovisualPrice']);
  82.                             }
  83.                             if (isset($setting['showAudiovisualPackage'])) {
  84.                                 $loungeEntity->setShowAudiovisualPackage((bool)$setting['showAudiovisualPackage']);
  85.                             }
  86.                             $this->em->persist($loungeEntity);
  87.                         }
  88.                     }
  89.                 }
  90.             }
  92.             $individualProducts = [];
  93.             $packagesToConsolidate = [];
  94.             $receivedKeys = [];
  95.             $activeRanksInPayload = [];
  96.             
  97.             // MAPA PARA CONTROLAR Y DESDUPLICAR ELEMENTOS REPETIDOS EN EL MISMO PAYLOAD
  98.             $seenProductByOptionAndDate = [];
  100.             foreach ($rawProducts as $index => $item) {
  101.                 $sourceType = filter_var($item['sourceType'] ?? null, FILTER_UNSAFE_RAW);
  102.                 $packId     = filter_var($item['packId'] ?? null, FILTER_VALIDATE_INT);
  103.                 $productId  = filter_var($item['productId'] ?? null, FILTER_VALIDATE_INT);
  104.                 $dateStr    = !empty($item['date']) ? trim((string)$item['date']) : null;
  105.                 $quantity   = isset($item['quantity']) ? (float)$item['quantity'] : 0.0;
  106.                 
  107.                 $optionKey  = filter_var($item['optionKey'] ?? null, FILTER_VALIDATE_INT);
  108.                 $rankQuote  = null;
  110.                 if ($optionKey) {
  111.                     /** @var ReservationLoungeSimple|null $loungeRef */
  112.                     $loungeRef = $this->em->getRepository(ReservationLoungeSimple::class)->find($optionKey);
  113.                     if ($loungeRef) {
  114.                         $rankQuote = $loungeRef->getRankQuote();
  115.                     }
  116.                 }
  118.                 if ($rankQuote !== null) {
  119.                     $activeRanksInPayload[$rankQuote] = true;
  120.                 }
  122.                 if ($sourceType === 'avPackage' && $packId && !$productId) {
  123.                     $key = sprintf('%d-%s-%s', $packId, $rankQuote ?? 'no-rank', $dateStr ?? 'no-date');
  124.                     if (!isset($packagesToConsolidate[$key])) {
  125.                         $packagesToConsolidate[$key] = [
  126.                             'packId' => $packId,
  127.                             'rankQuote' => $rankQuote,
  128.                             'date' => $dateStr,
  129.                             'index' => $index
  130.                         ];
  131.                     }
  132.                 } 
  133.                 elseif ($productId && $quantity > 0) {
  134.                     // Prevenimos la duplicación si el frontend envía el mismo productId para la misma Opción y Fecha
  135.                     $dedupKey = sprintf('%d_%s_%s', $productId, $rankQuote ?? 'norank', $dateStr ?? 'nodate');
  137.                     if (isset($seenProductByOptionAndDate[$dedupKey])) {
  138.                         continue;
  139.                     }
  141.                     $seenProductByOptionAndDate[$dedupKey] = true;
  143.                     $individualProducts[] = [
  144.                         'item' => $item,
  145.                         'index' => $index
  146.                     ];
  148.                     $key = sprintf('%d_%s', $productId, $rankQuote ?? 'norank');
  149.                     $receivedKeys[$key] = true;
  150.                 }
  151.             }
  153.             // --- RECONCILIACIÓN POR AUSENCIA (Acotada a los ranks recibidos) ---
  154.             $ranksToProcess = array_keys($activeRanksInPayload);
  156.             if (!empty($ranksToProcess)) {
  157.                 $qbExisting = $this->em->createQueryBuilder()
  158.                     ->select('s')
  159.                     ->from(ReservationService::class, 's')
  160.                     ->where('s.reservationId = :resId')
  161.                     ->andWhere('s.toinvoice = true')
  162.                     ->andWhere('s.rank IN (:ranks)')
  163.                     ->setParameter('resId', $reservation->getId())
  164.                     ->setParameter('ranks', $ranksToProcess);
  166.                 /** @var ReservationService[] $existingServicesForRanks */
  167.                 $existingServicesForRanks = $qbExisting->getQuery()->getResult();
  169.                 foreach ($existingServicesForRanks as $dbService) {
  170.                     $dbServiceName = $dbService->getName() ?? '';
  172.                     if (str_contains($dbServiceName, '[Recomendado]')) {
  173.                         $dbProductId = (int) $dbService->getServiceId();
  174.                         $dbRank      = $dbService->getRank() ?? 'norank';
  176.                         $dbKey = sprintf('%d_%s', $dbProductId, $dbRank);
  178.                         if (!isset($receivedKeys[$dbKey])) {
  179.                             $this->em->remove($dbService);
  180.                         }
  181.                     }
  182.                 }
  183.             }
  185.             // --- PROCESAR PRODUCTOS INDIVIDUALES (SOLO FECHA, SIN HORA) ---
  186.             foreach ($individualProducts as $wrapped) {
  187.                 $item  = $wrapped['item'];
  188.                 $index = $wrapped['index'];
  190.                 $productId = filter_var($item['productId'] ?? null, FILTER_VALIDATE_INT);
  191.                 $quantity  = (float) $item['quantity'];
  192.                 $dateStr   = !empty($item['date']) ? trim((string)$item['date']) : null;
  193.                 
  194.                 $optionKey = filter_var($item['optionKey'] ?? null, FILTER_VALIDATE_INT);
  195.                 $rankQuote = null;
  197.                 if ($optionKey) {
  198.                     /** @var ReservationLoungeSimple|null $loungeRef */
  199.                     $loungeRef = $this->em->getRepository(ReservationLoungeSimple::class)->find($optionKey);
  200.                     if ($loungeRef) {
  201.                         $rankQuote = $loungeRef->getRankQuote();
  202.                     }
  203.                 }
  205.                 /** @var AveProduct|null $product */
  206.                 $product = $this->em->getRepository(AveProduct::class)->find($productId);
  207.                 if (!$product) {
  208.                     continue;
  209.                 }
  211.                 $targetDate = $dateStr ? \DateTime::createFromFormat('d/m/Y', $dateStr) : null;
  212.                 if (!$targetDate) {
  213.                     $targetDate = $reservation->getDateStart();
  214.                 }
  215.                 
  216.                 // Normalizamos siempre a las 00:00:00
  217.                 $dateIn   = (clone $targetDate)->setTime(0, 0, 0);
  218.                 $dateOut  = (clone $targetDate)->setTime(23, 59, 59);
  220.                 $dayStart = (clone $targetDate)->setTime(0, 0, 0);
  221.                 $dayEnd   = (clone $targetDate)->setTime(23, 59, 59);
  223.                 $cleanProductName = trim($product->getName());
  224.                 $expectedName     = $cleanProductName . " [Recomendado]";
  226.                 // BÚSQUEDA DQL DENTRO DEL RANGO DEL DÍA DE LA OPCIÓN
  227.                 $qb = $this->em->createQueryBuilder()
  228.                     ->select('s')
  229.                     ->from(ReservationService::class, 's')
  230.                     ->where('s.reservationId = :resId')
  231.                     ->andWhere('s.serviceId = :prodId')
  232.                     ->andWhere('s.name = :expectedName')
  233.                     ->andWhere('s.dateInAt >= :dayStart AND s.dateInAt <= :dayEnd')
  234.                     ->setParameter('resId', $reservation->getId())
  235.                     ->setParameter('prodId', $product->getId())
  236.                     ->setParameter('expectedName', $expectedName)
  237.                     ->setParameter('dayStart', $dayStart)
  238.                     ->setParameter('dayEnd', $dayEnd);
  240.                 if ($rankQuote !== null) {
  241.                     $qb->andWhere('s.rank = :rankQuote')
  242.                        ->setParameter('rankQuote', $rankQuote);
  243.                 } else {
  244.                     $qb->andWhere('s.rank IS NULL');
  245.                 }
  247.                 /** @var ReservationService|null $reservationService */
  248.                 $reservationService = $qb->setMaxResults(1)->getQuery()->getOneOrNullResult();
  250.                 if ($reservationService && (float)$reservationService->getUnits() === $quantity) {
  251.                     $processedItems[] = [
  252.                         'productId' => $productId,
  253.                         'name' => $expectedName,
  254.                         'quantity' => $quantity,
  255.                         'rank' => $rankQuote,
  256.                         'date' => $dateIn->format('d/m/Y')
  257.                     ];
  258.                     continue;
  259.                 }
  261.                 if (!$reservationService) {
  262.                     $reservationService = new ReservationService();
  263.                     $reservationService->setReservationId($reservation->getId());
  264.                     $reservationService->setServiceId($product->getId());
  265.                     $reservationService->setSupplierId(0);
  266.                     $reservationService->setServiceCatId(0);
  267.                     $reservationService->setCommission('0');
  268.                     $reservationService->setContcolor('#32aaf0');
  269.                     $reservationService->setViewInfo(true);
  270.                     $reservationService->setCreatedAt($ahora);
  271.                     $reservationService->setCreatedId($userId);
  272.                     $reservationService->setToinvoice(true); 
  273.                 }
  275.                 $reservationService->setRank($rankQuote);
  276.                 $reservationService->setDateInAt($dateIn);
  277.                 $reservationService->setDateOutAt($dateOut);
  278.                 $reservationService->setPrice((string) $product->getPrice());
  279.                 $reservationService->setUnits((string) $quantity);
  280.                 $reservationService->setServiceCatName(!empty($product->getType()) ? $product->getType() : 'Audiovisuales');
  281.                 $reservationService->setName($expectedName);
  282.                 $reservationService->setUpdatedAt($ahora);
  283.                 $reservationService->setUpdatedId($userId);
  285.                 $this->em->persist($reservationService);
  287.                 $processedItems[] = [
  288.                     'productId' => $productId,
  289.                     'name' => $expectedName,
  290.                     'quantity' => $quantity,
  291.                     'rank' => $rankQuote,
  292.                     'date' => $dateIn->format('d/m/Y')
  293.                 ];
  294.             }
  296.             // --- PROCESAR PAQUETES CONSOLIDADOS ---
  297.             foreach ($packagesToConsolidate as $packData) {
  298.                 $packId    = $packData['packId'];
  299.                 $rankQuote = $packData['rankQuote'];
  300.                 $dateStr   = $packData['date'];
  301.                 $index     = $packData['index'];
  303.                 /** @var AvePackageTemplate|null $package */
  304.                 $package = $this->em->getRepository(AvePackageTemplate::class)->find($packId);
  305.                 if (!$package) {
  306.                     $errors[] = "Fila {$index}: El paquete con ID {$packId} no existe.";
  307.                     continue;
  308.                 }
  310.                 $expectedPackName = sprintf("[Pack: %s]", trim($package->getName()));
  312.                 $packagePrice = $package->getPricePackage() !== null 
  313.                     ? (float) $package->getPricePackage() 
  314.                     : (float) $package->getTotalNetPrice();
  316.                 $targetDate = $dateStr ? \DateTime::createFromFormat('d/m/Y', $dateStr) : null;
  317.                 if (!$targetDate) {
  318.                     $targetDate = $reservation->getDateStart();
  319.                 }
  320.                 
  321.                 $dateIn   = (clone $targetDate)->setTime(0, 0, 0);
  322.                 $dateOut  = (clone $targetDate)->setTime(23, 59, 59);
  324.                 $dayStart = (clone $targetDate)->setTime(0, 0, 0);
  325.                 $dayEnd   = (clone $targetDate)->setTime(23, 59, 59);
  327.                 $qb = $this->em->createQueryBuilder()
  328.                     ->select('s')
  329.                     ->from(ReservationService::class, 's')
  330.                     ->where('s.reservationId = :resId')
  331.                     ->andWhere('s.name = :packName')
  332.                     ->andWhere('s.toinvoice = true')
  333.                     ->andWhere('s.dateInAt >= :dayStart AND s.dateInAt <= :dayEnd')
  334.                     ->setParameter('resId', $reservation->getId())
  335.                     ->setParameter('packName', $expectedPackName)
  336.                     ->setParameter('dayStart', $dayStart)
  337.                     ->setParameter('dayEnd', $dayEnd);
  339.                 if ($rankQuote !== null) {
  340.                     $qb->andWhere('s.rank = :rankQuote')
  341.                        ->setParameter('rankQuote', $rankQuote);
  342.                 } else {
  343.                     $qb->andWhere('s.rank IS NULL');
  344.                 }
  346.                 /** @var ReservationService|null $reservationService */
  347.                 $reservationService = $qb->setMaxResults(1)->getQuery()->getOneOrNullResult();
  349.                 if ($reservationService && (float)$reservationService->getUnits() === 1.0) {
  350.                     $processedItems[] = [
  351.                         'packageId' => $packId,
  352.                         'name' => $expectedPackName,
  353.                         'quantity' => 1.0,
  354.                         'rank' => $rankQuote,
  355.                         'date' => $dateIn->format('d/m/Y')
  356.                     ];
  357.                     continue;
  358.                 }
  360.                 if (!$reservationService) {
  361.                     $reservationService = new ReservationService();
  362.                     $reservationService->setReservationId($reservation->getId());
  363.                     $reservationService->setServiceId(0);
  364.                     $reservationService->setSupplierId(0);
  365.                     $reservationService->setServiceCatId(0);
  366.                     $reservationService->setCommission('0');
  367.                     $reservationService->setContcolor('#32aaf0');
  368.                     $reservationService->setViewInfo(true);
  369.                     $reservationService->setCreatedAt($ahora);
  370.                     $reservationService->setCreatedId($userId);
  371.                     $reservationService->setToinvoice(true);
  372.                 }
  374.                 $reservationService->setRank($rankQuote);
  375.                 $reservationService->setDateInAt($dateIn);
  376.                 $reservationService->setDateOutAt($dateOut);
  377.                 $reservationService->setPrice((string) $packagePrice);
  378.                 $reservationService->setUnits('1.0');
  379.                 $reservationService->setServiceCatName('Audiovisuales');
  380.                 $reservationService->setName($expectedPackName);
  381.                 $reservationService->setUpdatedAt($ahora);
  382.                 $reservationService->setUpdatedId($userId);
  384.                 $this->em->persist($reservationService);
  386.                 $processedItems[] = [
  387.                     'packageId' => $packId,
  388.                     'name' => $expectedPackName,
  389.                     'quantity' => 1.0,
  390.                     'rank' => $rankQuote,
  391.                     'date' => $dateIn->format('d/m/Y')
  392.                 ];
  393.             }
  395.             if (!empty($errors)) {
  396.                 $this->em->rollback();
  397.                 return new JsonResponse(['success' => false, 'errors' => $errors], Response::HTTP_UNPROCESSABLE_ENTITY);
  398.             }
  400.             $this->em->flush();
  401.             $this->em->commit();
  403.             return new JsonResponse([
  404.                 'success' => true,
  405.                 'message' => 'Selección guardada y asociada a la reserva correctamente.',
  406.                 'processedItems' => $processedItems
  407.             ], Response::HTTP_OK);
  409.         } catch (\Exception $e) {
  410.             $this->em->rollback();
  411.             return new JsonResponse([
  412.                 'success' => false,
  413.                 'error' => 'Error interno al procesar e insertar la solicitud.',
  414.                 'details' => $e->getMessage()
  415.             ], Response::HTTP_INTERNAL_SERVER_ERROR);
  416.         }
  417.     }
  421.     /**
  422.      * @Route("/api/client/proposal/{token}", name="generate_token", methods={"GET"})
  423.      */
  424.     public function generateToken(Request $request, string $token): JsonResponse
  425.     {
  426.         /** @var Reservation|null $reservation */
  427.         $reservation = $this->em->getRepository(Reservation::class)->findOneBy(['token' => $token]);
  428.         if (!$reservation) {
  429.             throw $this->createNotFoundException('No se encontró ninguna reserva para el token proporcionado.');
  430.         }
  432.         $formattedReservation = $this->formatReservation($reservation);
  433.         $formattedReservation['breakdownPackages'] = $reservation->isBreakdownPackages();
  435.         $data = [
  436.             'reservation' => $formattedReservation,
  437.             'options' => [],
  438.             'reservationService' => [], 
  439.             'filteredServices' => [],
  440.         ];
  442.         // 1. Obtener plantillas de paquetes e ítems maestros
  443.         $avPackages = $this->em->getRepository(AvePackageTemplate::class)->findAll();
  444.         $allPackageItems = $this->em->getRepository(AvePackageTemplateItems::class)->findBy([], ['rankAvPack' => 'ASC']);
  445.         
  446.         $itemsByPackageId = [];
  447.         $packageItemPricesMap = [];
  448.         foreach ($allPackageItems as $item) {
  449.             $itemsByPackageId[(int) $item->getPackId()][] = $item;
  450.             $packageItemPricesMap[(int) $item->getPackId()][(int) $item->getProductId()] = (float) $item->getServicePrice();
  451.         }
  453.         $packagesByLoungeDetail = [];
  454.         $packNamesToDetailIdsMap = []; 
  455.         $packNameToIdMap = [];
  457.         foreach ($avPackages as $pkg) {
  458.             if (!$pkg->getLounges()->isInitialized()) {
  459.                 $pkg->getLounges()->initialize();
  460.             }
  462.             $packageItems = $itemsByPackageId[(int) $pkg->getId()] ?? [];
  463.             $formattedPackage = $this->formatPackageTemplate($pkg, $packageItems);
  464.             $packNameTrimmed = trim($pkg->getName());
  465.             $packNameToIdMap[$packNameTrimmed] = $pkg->getId();
  467.             foreach ($pkg->getLounges() as $lounge) {
  468.                 $packagesByLoungeDetail[$lounge->getId()][] = $formattedPackage;
  469.                 $packNamesToDetailIdsMap[$packNameTrimmed][] = $lounge->getId();
  470.             }
  471.         }
  473.         // Obtener las salas contratadas
  474.         $loungeItems = $this->em->getRepository(ReservationLoungeSimple::class)->findBy(
  475.             ['idReservation' => $reservation->getId()],
  476.             ['dateStart' => 'ASC']
  477.         );
  479.         // Obtener todas las líneas de servicio reales de la reserva
  480.         $allReservationServices = $this->em->getRepository(ReservationService::class)->findBy([
  481.             'reservationId' => $reservation->getId(),
  482.             'toinvoice' => true 
  483.         ]);
  485.         // MAPEAR LOS SERVICIOS FILTRANDO STRICTAMENTE POR FECHA Y OPCIÓN (rankQuote)
  486.         $selectionsByLoungeId = [];        
  487.         $packageSelectionsByLoungeId = []; 
  489.         foreach ($allReservationServices as $service) {
  490.             $serviceDate = $service->getDateInAt();
  491.             if (!$serviceDate) {
  492.                 continue;
  493.             }
  494.             
  495.             $dateKey     = $serviceDate->format('Y-m-d');
  496.             $serviceId   = (int)$service->getServiceId();
  497.             $units       = (float)$service->getUnits();
  498.             $serviceName = $service->getName() ?? '';
  499.             $serviceRank = $service->getRank();
  501.             foreach ($loungeItems as $loungeItem) {
  502.                 $loungeDate = $loungeItem->getDateStart();
  503.                 $loungeRank = $loungeItem->getRankQuote();
  505.                 if ($loungeDate && $loungeDate->format('Y-m-d') === $dateKey) {
  506.                     
  507.                     if ($serviceRank !== null && (int)$serviceRank !== (int)$loungeRank) {
  508.                         continue;
  509.                     }
  511.                     $loungeSimpleId = $loungeItem->getId();
  513.                     if ($serviceId > 0 && str_contains($serviceName, '[Recomendado]')) {
  514.                         $selectionsByLoungeId[$loungeSimpleId][$serviceId] = $units;
  515.                     }
  517.                     if (str_contains($serviceName, '[Pack:')) {
  518.                         if (preg_match('/\[Pack:\s*(.*?)\]/', $serviceName, $matches)) {
  519.                             $extractedPackName = trim($matches[1]);
  520.                             $packageSelectionsByLoungeId[$loungeSimpleId][$extractedPackName] = $units;
  521.                         }
  522.                     }
  523.                 }
  524.             }
  525.         }
  527.         $servicesGroupedByLoungeDetailId = [];
  528.         $globalRecommendedServices = [];
  529.         $specialServices = [];
  530.         $allowedCategories = ['limpieza', 'seguridad', 'parking', 'mobiliario'];
  532.         foreach ($allReservationServices as $service) {
  533.             $units = ($service->getUnits() > 0) ? (float) $service->getUnits() : 1.0;
  534.             $pax = ($service->getPax() > 0) ? (float) $service->getPax() : 1.0;
  536.             $priceOver = (float) $service->getOver();
  537.             $price = (float) $service->getPrice();
  538.             $commission = (float) $service->getCommission();
  539.             $iva = $service->getSageIva()?->getIva() ?? 0;
  541.             $totalPrice = ($price * $pax * $units);
  542.             $priceCommission = $totalPrice * ($commission / 100);
  543.             $totalConComision = $totalPrice + $priceCommission;
  545.             $dateInAt = $service->getDateInAt() ?? $reservation->getDateStart();
  546.             $dateOutAt = $service->getDateOutAt() ?? $reservation->getDateEnd();
  548.             $days = 1;
  549.             if ($dateInAt && $dateOutAt) {
  550.                 $interval = $dateInAt->diff($dateOutAt);
  551.                 $days = max(1, (int) $interval->days + 1);
  552.             }
  553.             
  554.             $totalConDays = $totalConComision * $days;
  555.             $totalConOver = $totalConDays + $priceOver;
  556.             $priceIva = $totalConOver * ($iva / 100);
  557.             $totalPriceCalculated = $totalConOver + $priceIva;
  559.             $pricePackage = null;
  560.             $serviceName = $service->getName() ?? '';
  561.             $assigned = false;
  563.             $formattedService = [
  564.                 'id' => $service->getId(),
  565.                 'reservationId' => $service->getReservationId(),
  566.                 'supplierId' => $service->getSupplierId(),
  567.                 'serviceId' => $service->getServiceId(),
  568.                 'serviceCatId' => $service->getServiceCatId(),
  569.                 'serviceCatName' => $service->getServiceCatName(),
  570.                 'name' => $service->getName(),
  571.                 'price' => $service->getPrice(),
  572.                 'pricePackage' => $pricePackage,
  573.                 'currency' => $service->getCurrency(),
  574.                 'units' => $units,
  575.                 'opCommission' => $service->getOpCommission(),
  576.                 'commission' => $service->getCommission(),
  577.                 'opOver' => $service->getOpOver(),
  578.                 'priceOver' => $priceOver,
  579.                 'opIva' => $service->getOpIva(),
  580.                 'iva' => $service->getSageIva(),
  581.                 'pax' => $pax,
  582.                 'hour' => $service->getHour(),
  583.                 'dateInAt' => $dateInAt?->format('Y-m-d H:i:s'),
  584.                 'dateOutAt' => $dateOutAt?->format('Y-m-d H:i:s'),
  585.                 'contcolor' => $service->getContcolor(),
  586.                 'rank' => $service->getRank(),
  587.                 'assistantId' => $service->getAssistantId(),
  588.                 'activityId' => $service->getActivityId(),
  589.                 'pay' => $service->getPay(),
  590.                 'createdAt' => $service->getCreatedAt()?->format('Y-m-d H:i:s'),
  591.                 'createdId' => $service->getCreatedId(),
  592.                 'updatedAt' => $service->getUpdatedAt()?->format('Y-m-d H:i:s'),
  593.                 'updatedId' => $service->getUpdatedId(),
  594.                 'toInvoice' => $service->getToinvoice(),
  595.                 'totalSinIva' => $totalConOver,
  596.                 'totalIva' => $priceIva,
  597.                 'totalPrice' => $totalPriceCalculated,
  598.                 'viewInfo' => $service->getViewInfo()
  599.             ];
  601.             if (str_contains($serviceName, '[Pack:')) {
  602.                 if (preg_match('/\[Pack:\s*(.*?)\]/', $serviceName, $matches)) {
  603.                     $extractedPackName = trim($matches[1]);
  604.                     
  605.                     if (isset($packNamesToDetailIdsMap[$extractedPackName])) {
  606.                         $associatedPackId = $packNameToIdMap[$extractedPackName] ?? null;
  607.                         $productId = (int) $service->getServiceId();
  608.                         if ($associatedPackId !== null && isset($packageItemPricesMap[$associatedPackId][$productId])) {
  609.                             $formattedService['pricePackage'] = $packageItemPricesMap[$associatedPackId][$productId];
  610.                         }
  612.                         $servicesGroupedByLoungeDetailId[$extractedPackName][] = $formattedService;
  613.                         $assigned = true;
  614.                     }
  615.                 }
  616.             }
  618.             if (!$assigned) {
  619.                 $globalRecommendedServices[] = $formattedService;
  620.             }
  622.             $catNameNormalized = mb_strtolower(trim($service->getServiceCatName() ?? ''));
  623.             if (in_array($catNameNormalized, $allowedCategories, true)) {
  624.                 $specialServices[] = $formattedService;
  625.             }
  626.         }
  628.         // CONSTRUCCIÓN DE OPCIONES CON FECHAS E ÍTEMS INYECTADOS
  629.         foreach ($loungeItems as $item) {
  630.             $data['reservation']['idWebLanguage'] = $item->getLanguage() ?: 1;
  631.             $data['reservation']['showPackagePrice'] = $reservation->getShowPackagePrice() ?: 1;
  633.             $uniqueId = $item->getId();
  634.             $rankQuote = $item->getRankQuote();
  635.             $loungeIva = $item->getSageIva() ?? 21;
  637.             $loungeDateFormatted = $item->getDateStart() ? $item->getDateStart()->format('d/m/Y') : '';
  639.             $loungeData = $this->formatLoungeData($item, $uniqueId, $loungeIva);
  640.             $loungeDetailId = $loungeData['loungeId'] ? (int) $loungeData['loungeId'] : null;
  642.             $rawPackages = ($loungeDetailId && isset($packagesByLoungeDetail[$loungeDetailId])) 
  643.                 ? $packagesByLoungeDetail[$loungeDetailId] 
  644.                 : [];
  646.             $formattedPackagesForThisLounge = [];
  647.             foreach ($rawPackages as $pkg) {
  648.                 $packNameTrimmed = trim($pkg['name']);
  649.                 
  650.                 $pkg['date'] = $loungeDateFormatted;
  652.                 if (isset($packageSelectionsByLoungeId[$uniqueId][$packNameTrimmed])) {
  653.                     $pkg['isChecked'] = true;
  654.                     $pkg['quantity'] = $packageSelectionsByLoungeId[$uniqueId][$packNameTrimmed];
  655.                 } else {
  656.                     $pkg['isChecked'] = false;
  657.                     $pkg['quantity'] = 0;
  658.                 }
  660.                 foreach ($pkg['items'] as &$subItem) {
  661.                     $productId = (int)$subItem['productId'];
  662.                     
  663.                     $subItem['date'] = $loungeDateFormatted;
  665.                     if (isset($selectionsByLoungeId[$uniqueId][$productId])) {
  666.                         $subItem['isChecked'] = true;
  667.                         $subItem['quantity'] = $selectionsByLoungeId[$uniqueId][$productId];
  668.                     } else {
  669.                         $subItem['isChecked'] = false;
  670.                         $subItem['quantity'] = 0;
  671.                     }
  672.                 }
  673.                 unset($subItem);
  674.                 
  675.                 $formattedPackagesForThisLounge[] = $pkg;
  676.             }
  678.             $loungeData['avPackages'] = $formattedPackagesForThisLounge;
  679.             $loungeData['loungeServices'] = [];
  681.             if ($loungeDetailId && isset($packagesByLoungeDetail[$loungeDetailId])) {
  682.                 foreach ($packagesByLoungeDetail[$loungeDetailId] as $allowedPack) {
  683.                     $allowedPackName = trim($allowedPack['name']);
  684.                     
  685.                     if (isset($servicesGroupedByLoungeDetailId[$allowedPackName])) {
  686.                         foreach ($servicesGroupedByLoungeDetailId[$allowedPackName] as $purchasedService) {
  687.                             $loungeData['loungeServices'][] = $purchasedService;
  688.                         }
  689.                     }
  690.                 }
  691.             }
  693.             if (!isset($data['options'][$rankQuote])) {
  694.                 $data['options'][$rankQuote] = [];
  695.             }
  696.             $data['options'][$rankQuote][] = $loungeData;
  697.         }
  699.         $data['reservationService'] = $globalRecommendedServices;
  700.         $data['filteredServices'] = $specialServices; 
  702.         return new JsonResponse($data);
  703.     }
  705.     private function formatPackageTemplate(AvePackageTemplate $template, array $items): array
  706.     {
  707.         $totalPrice = $template->getPricePackage() !== null 
  708.             ? (float) $template->getPricePackage() 
  709.             : (float) $template->getTotalNetPrice();
  711.         return [
  712.             'id'          => $template->getId(),
  713.             'name'        => $template->getName(),
  714.             'description' => $template->getDescription(),
  715.             'totalPrice'  => $totalPrice, 
  716.             'isFeatured'  => $template->isFeatured(), 
  717.             'lounges'     => array_map(fn($lounge) => [
  718.                 'id'   => $lounge->getId(),
  719.                 'name' => $lounge->getName()
  720.             ], $template->getLounges()->toArray()),
  721.             'items'       => array_map(fn(AvePackageTemplateItems $item) => [
  722.                 'id' => $item->getId(),
  723.                 'productName' => $item->getProductName(),
  724.                 'productId' => $item->getProductId(),
  725.                 'percProductPrice' => $item->getPercProductPrice(),
  726.                 'servicePrice' => $item->getServicePrice(),
  727.                 'priceWithoutPack' => $item->getPriceWithoutPack(),
  728.                 'rankAvPack' => $item->getRankAvPack(),
  729.                 'description' => $item->getDescription(),
  730.             ], $items),
  731.         ];
  732.     }
  734.     private function formatReservation(Reservation $reservation): array
  735.     {
  736.         $contactEmail = null;
  737.         $clientContact = $reservation->getClientContact();
  739.         if ($clientContact instanceof ClientContact) {
  740.             $contactEmail = $clientContact->getEmail();
  741.             $clientContactId = $clientContact->getId();
  742.         } elseif (is_numeric($clientContact)) {
  743.             $contact = $this->em->getRepository(ClientContact::class)->find((int) $clientContact);
  744.             $contactEmail = $contact ? $contact->getEmail() : null;
  745.             $clientContactId = $contact ? $contact->getId() : null;
  746.         } else {
  747.             $contactEmail = $reservation->getContactUnregistered();
  748.             $clientContactId = $clientContact;
  749.         }
  751.         $client = $reservation->getClient();
  752.         $clientBlock = $client ? [
  753.             'id'   => method_exists($client, 'getId') ? $client->getId() : null,
  754.             'name' => method_exists($client, 'getName') ? $client->getName() : null,
  755.         ] : null;
  757.         $idProposal = $this->resolveProposalId($reservation) ?? $reservation->getId();
  759.         return [
  760.             'id' => $reservation->getId(),
  761.             'title' => $reservation->getTitle(),
  762.             'client' => $clientBlock,
  763.             'createdAt' => $reservation->getCreatedAt()?->format('Y-m-d H:i:s'),
  764.             'priority' => $reservation->getPriority(),
  765.             'dateStart' => $reservation->getDateStart()?->format('Y-m-d H:i:s'),
  766.             'dateEnd' => $reservation->getDateEnd()?->format('Y-m-d H:i:s'),
  767.             'createdBy' => $reservation->getCreatedBy(),
  768.             'supplier' => $reservation->getSupplier(),
  769.             'status' => $reservation->getStatus(),
  770.             'updatedAt' => $reservation->getUpdatedAt()?->format('Y-m-d H:i:s'),
  771.             'updatedBy' => $reservation->getUpdatedBy(),
  772.             'daysBlock' => $reservation->getDaysBlock(),
  773.             'idProposal' => $idProposal,
  774.             'pax' => $reservation->getPax(),
  775.             'accessKey' => $reservation->getAccessKey(),
  776.             'description' => $reservation->getDescription(),
  777.             'clientContact' => $clientContactId,
  778.             'contactUnregistered' => $reservation->getContactUnregistered(),
  779.             'days' => $reservation->getDays(),
  780.             'contract' => $reservation->getContract(),
  781.             'nameContactUnregistered' => $reservation->getNameContactUnregistered(),
  782.             'phoneContactUnregistered' => $reservation->getPhoneContactUnregistered(),
  783.             'token' => $reservation->getToken(),
  784.             'contactEmail' => $contactEmail,
  785.         ];
  786.     }
  788.     private function formatLoungeData(ReservationLoungeSimple $item, $uniqueId, $loungeIva): array
  789.     {
  790.         $loungeName = $item->getLoungeName();
  791.         /** @var ReservationLoungeDetails|null $detail */
  792.         $detail = $this->em->getRepository(ReservationLoungeDetails::class)->findOneBy(['name' => $loungeName]);
  793.         
  794.         if (!$detail) {
  795.             $dateEnd = $item->getDateEnd();
  796.             $xdateEnd = $dateEnd
  797.                 ? ($dateEnd->format('H:i') === '23:59' ? $dateEnd->format('Y-m-d 00:00:00') : $dateEnd->format('Y-m-d H:i:s'))
  798.                 : null;
  800.             return [
  801.                 'id' => $uniqueId,
  802.                 'loungeId' => null,
  803.                 'loungeName' => $loungeName,
  804.                 'type' => $item->getType(),
  805.                 'rankQuote' => $item->getRankQuote(),
  806.                 'dateStart' => $item->getDateStart()?->format('Y-m-d H:i:s'),
  807.                 'dateEnd' => $xdateEnd,
  808.                 'pax' => $item->getPax(),
  809.                 'price' => $item->getServicePrice(),
  810.                 'loungeIva' => 0,
  811.                 'combo' => null,
  812.                 'isCombo' => 0,
  813.                 'descriptions' => [],
  814.                 'loungeDescription' => $item->getLoungeDescription(),
  815.                 'importantDescription' => empty($item->getType()) ? $item->getImportantDescription() : '',
  816.                 'importantDescGeneralText' => $item->getImportantDescGeneralText(),
  817.                 'importantDescSchedules' => $item->getImportantDescSchedules(),
  818.                 'importantDescParking' => $item->getImportantDescParking(),
  819.                 'showAudiovisualPrice' => $item->isShowAudiovisualPrice(),
  820.                 'showAudiovisualPackage' => $item->isShowAudiovisualPackage(),
  821.                 'pictures' => [],
  822.                 'comboDetails' => [],
  823.                 'loungeDetails' => null,
  824.                 'totalPrice' => $item->getServicePrice()
  825.             ];
  826.         }
  828.         $ivaPct = is_numeric($loungeIva) ? (float) $loungeIva : 21.0;
  829.         $ivaImporte = $item->getServicePrice() * ($ivaPct / 100);
  830.         $comboIds = $detail->getCombo();
  832.         return [
  833.             'id' => $uniqueId,
  834.             'loungeId' => $detail->getId(),
  835.             'loungeName' => $detail->getName(),
  836.             'type' => $item->getType(),
  837.             'rankQuote' => $item->getRankQuote(),
  838.             'dateStart' => $item->getDateStart()?->format('Y-m-d H:i:s'),
  839.             'dateEnd' => $item->getDateEnd()?->format('Y-m-d H:i:s'),
  840.             'pax' => $item->getPax(),
  841.             'price' => $item->getServicePrice(),
  842.             'loungeIva' => $ivaImporte,
  843.             'combo' => $comboIds,
  844.             'isCombo' => $comboIds ? 1 : 0,
  845.             'descriptions' => $this->getDescriptions($detail),
  846.             'loungeDescription' => $item->getLoungeDescription(),
  847.             'importantDescription' => empty($item->getType()) ? $item->getImportantDescription() : '',
  848.             'importantDescGeneralText' => $item->getImportantDescGeneralText(),
  849.             'importantDescSchedules' => $item->getImportantDescSchedules(),
  850.             'importantDescParking' => $item->getImportantDescParking(),
  851.             'showAudiovisualPrice' => $item->isShowAudiovisualPrice(),
  852.             'showAudiovisualPackage' => $item->isShowAudiovisualPackage(),
  853.             'pictures' => $this->getPictures($detail),
  854.             'comboDetails' => $comboIds ? $this->getComboDetails($comboIds) : [],
  855.             'loungeDetails' => $this->getLoungeDetails($detail->getId()),
  856.             'totalPrice' => $item->getServicePrice() + $ivaImporte
  857.         ];
  858.     }
  860.     private function getDescriptions(ReservationLoungeDetails $loungeDetail): array
  861.     {
  862.         $descriptions = [];
  863.         $result = $this->em->getRepository(ReservationLoungeDescription::class)->findBy(['loungeId' => $loungeDetail->getId()]);
  864.         foreach ($result as $description) {
  865.             $descriptions[] = [
  866.                 'language' => $description->getLanguage(),
  867.                 'description' => $description->getDescription(),
  868.                 'createdAt' => $description->getCreatedAt()?->format('Y-m-d H:i:s'),
  869.                 'updatedAt' => $description->getUpdatedAt()?->format('Y-m-d H:i:s'),
  870.             ];
  871.         }
  872.         return $descriptions;
  873.     }
  875.     private function getPictures(ReservationLoungeDetails $loungeDetail): array
  876.     {
  877.         $pictures = [];
  878.         $result = $this->em->getRepository(ReservationLoungePicture::class)->findBy(['loungeId' => $loungeDetail->getId()]);
  879.         foreach ($result as $picture) {
  880.             $pictures[] = [
  881.                 'id' => $picture->getId(),
  882.                 'title' => $picture->getTitle(),
  883.                 'imageLarge' => $picture->getImageLarge(),
  884.                 'imageMedium' => $picture->getImageMedium(),
  885.                 'imageSmall' => $picture->getImageSmall(),
  886.                 'createdAt' => $picture->getCreatedAt()?->format('Y-m-d H:i:s'),
  887.                 'updatedAt' => $picture->getUpdatedAt()?->format('Y-m-d H:i:s'),
  888.             ];
  889.         }
  890.         return $pictures;
  891.     }
  893.     private function getComboDetails(string $comboIds): array
  894.     {
  895.         $comboDetails = [];
  896.         $comboIdArray = explode(',', $comboIds);
  897.         foreach ($comboIdArray as $comboId) {
  898.             $comboDetail = $this->em->getRepository(ReservationLoungeDetails::class)->find($comboId);
  899.             if ($comboDetail) {
  900.                 $comboDetails[] = [
  901.                     'id' => $comboDetail->getId(),
  902.                     'loungeName' => $comboDetail->getName(),
  903.                     'meters' => $comboDetail->getMeters(),
  904.                     'length' => $comboDetail->getLength(),
  905.                     'width' => $comboDetail->getWidth(),
  906.                     'height' => $comboDetail->getHeight(),
  907.                     'capSchool' => $comboDetail->getCapSchool(),
  908.                     'capTheater' => $comboDetail->getCapTheater(),
  909.                     'capCocktail' => $comboDetail->getCapCocktail(),
  910.                     'capBanquet' => $comboDetail->getCapBanquet(),
  911.                     'capImperial' => $comboDetail->getCapImperial(),
  912.                     'rankLounge' => $comboDetail->getRankLounge(),
  913.                     'descriptions' => $this->getDescriptions($comboDetail),
  914.                     'pictures' => $this->getPictures($comboDetail),
  915.                 ];
  916.             }
  917.         }
  918.         return $comboDetails;
  919.     }
  921.     private function getLoungeDetails(int $id): ?array
  922.     {
  923.         $loungeDetail = $this->em->getRepository(ReservationLoungeDetails::class)->findOneBy(['id' => $id]);
  925.         if (!$loungeDetail) {
  926.             return null;
  927.         }
  929.         return [
  930.             'id' => $loungeDetail->getId(),
  931.             'name' => $loungeDetail->getName(),
  932.             'meters' => $loungeDetail->getMeters(),
  933.             'length' => $loungeDetail->getLength(),
  934.             'width' => $loungeDetail->getWidth(),
  935.             'height' => $loungeDetail->getHeight(),
  936.             'capSchool' => $loungeDetail->getCapSchool(),
  937.             'capTheater' => $loungeDetail->getCapTheater(),
  938.             'capCocktail' => $loungeDetail->getCapCocktail(),
  939.             'capBanquet' => $loungeDetail->getCapBanquet(),
  940.             'capImperial' => $loungeDetail->getCapImperial(),
  941.             'rankLounge' => $loungeDetail->getRankLounge(),
  942.             'createdAt' => $loungeDetail->getCreatedAt()?->format('Y-m-d H:i:s'),
  943.             'updatedAt' => $loungeDetail->getUpdatedAt()?->format('Y-m-d H:i:s'),
  944.         ];
  945.     }
  947.     private function resolveProposalId(Reservation $reservation): ?int
  948.     {
  949.         if (method_exists($reservation, 'getProposal')) {
  950.             $proposal = $reservation->getProposal();
  951.             if (is_object($proposal) && method_exists($proposal, 'getId')) {
  952.                 return $proposal->getId();
  953.             }
  954.         }
  956.         foreach (['getIdProposal', 'getProposalId'] as $m) {
  957.             if (method_exists($reservation, $m)) {
  958.                 $val = $reservation->$m();
  959.                 return is_numeric($val) ? (int) $val : null;
  960.             }
  961.         }
  963.         return null;
  964.     }
  965. }