src/Aviatur/HelicopterBundle/Controller/HelicopterAvailabilityController.php line 25

Open in your IDE?
  1. <?php
  3. namespace Aviatur\HelicopterBundle\Controller;
  5. use Aviatur\HelicopterBundle\Models\HelicopterModel;
  6. use Aviatur\SearchBundle\Entity\SearchHeliports;
  7. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  8. use Symfony\Component\DependencyInjection\ParameterBag\ParameterBagInterface;
  9. use Symfony\Component\HttpFoundation\Cookie;
  10. use Symfony\Component\HttpFoundation\Response;
  11. use Aviatur\GeneralBundle\Services\AviaturErrorHandler;
  12. use Aviatur\TwigBundle\Services\TwigFolder;
  13. use Doctrine\Persistence\ManagerRegistry;
  14. use Symfony\Component\HttpFoundation\Request;
  15. use Symfony\Component\HttpFoundation\Session\SessionInterface;
  16. use Symfony\Component\Routing\RouterInterface;
  17. use Aviatur\GeneralBundle\Services\AviaturWebService;
  18. use Aviatur\GeneralBundle\Services\AviaturLogSave;
  19. use Aviatur\HelicopterBundle\Services\SearchHelicopterCookie;
  20. use Aviatur\GeneralBundle\Services\AviaturXsltRender;
  21. use Aviatur\FlightBundle\Services\GenerateFlightResumeEmail;
  23. class HelicopterAvailabilityController extends AbstractController
  24. {
  25.     public function searchAction()
  26.     {
  27.         return $this->redirect(
  28.             $this->generateUrl(
  29.                             'aviatur_search_helicopters',
  30.                             []
  31.                         )
  32.         );
  33.     }
  35.     public function availabilityAction(Request $request, AviaturLogSave $aviaturLogSave, SearchHelicopterCookie $helicopterSearchCookie, AviaturErrorHandler $aviaturErrorHandler, TwigFolder $twigFolder, SessionInterface $session, ManagerRegistry $registry, $origin1, $destination1, $date1, $adults, $children, $origin2 = null, $destination2 = null, $date2 = null, $helicopters)
  36.     {
  37.         $origins = [];
  38.         $destinations = [];
  39.         $urlDescription = [];
  40.         $infants = null;
  41.         $transactionId = null;
  42.         $em = $registry->getManager();
  43.         $fullRequest = $request;
  44.         $requestUrl = $this->generateUrl($fullRequest->attributes->get('_route'), $fullRequest->attributes->get('_route_params'));
  45.         $agency = $em->getRepository(\Aviatur\AgencyBundle\Entity\Agency::class)->find($session->get('agencyId'));
  46.         if ((2 == $helicopters) && !isset($origin2) && !isset($destination2)) {
  47.             $origin2 = $destination1;
  48.             $destination2 = $origin1;
  49.         }
  50.         $repositorySearchHeliports = $em->getRepository(SearchHeliports::class);
  51.         $route = $request->get('_route');
  52.         if (!$request->isXmlHttpRequest()) {
  53.             if ($adults + $children <= 9) {
  54.                 $AvailabilityArray = [
  55.                     'adults' => $adults,
  56.                     'children' => $children, ];
  57.                 $condition = '';
  58.                 $dateError = [];
  59.                 for ($i = 1; $i <= $helicopters; ++$i) {
  60.                     $AvailabilityArray['date'.$i] = false !== strpos(${'date'.$i}, 'T') ? date('Y-m-d\TH:i:s', strtotime(substr(${'date'.$i}, 0, 10).sprintf('+%d hours', substr(${'date'.$i}, -2)))) : date('Y-m-d\TH:i:s', strtotime(substr(${'date'.$i}, 0, 10)));
  61.                     $condition .= ' p.iata = :origin'.$i.' or p.iata = :destination'.$i.' or';
  62.                     if ($i > 1) {
  63.                         if (($AvailabilityArray['date'.$i] < $AvailabilityArray['date'.($i - 1)]) || ((date('Y-m-d\TH:i:s', strtotime($AvailabilityArray['date'.$i])) < date('Y-m-d\TH:i:s', strtotime('today +12 hour'))) && ((date('H', strtotime('now')) >= 12) || (date('Y-m-d', strtotime('today')) > date('Y-m-d', strtotime($AvailabilityArray['date1']))))) || ($AvailabilityArray['date'.$i] > date('Y-m-d\TH:i:s', strtotime('+11 month')))) {
  64.                             $dateError[$i] = $AvailabilityArray['date'.$i];
  65.                         }
  66.                     } else {
  67.                         if (((date('Y-m-d\TH:i:s', strtotime($AvailabilityArray['date'.$i])) < date('Y-m-d\TH:i:s', strtotime('today +12 hour'))) && ((date('H', strtotime('now')) >= 12) || (date('Y-m-d', strtotime('today')) > date('Y-m-d', strtotime($AvailabilityArray['date'.$i]))))) || ($AvailabilityArray['date'.$i] > date('Y-m-d\TH:i:s', strtotime('+11 month')))) {
  68.                             $dateError[$i] = $AvailabilityArray['date'.$i];
  69.                         }
  70.                     }
  71.                 }
  72.                 if (0 == sizeof($dateError)) {
  73.                     $condition = \rtrim($condition, 'or');
  74.                     $querySeachHeliports = $repositorySearchHeliports->createQueryBuilder('p')->where($condition);
  75.                     for ($i = 1; $i <= $helicopters; ++$i) {
  76.                         $querySeachHeliports->setParameter('origin'.$i, ${'origin'.$i})
  77.                                 ->setParameter('destination'.$i, ${'destination'.$i});
  78.                         $AvailabilityArray['origin'.$i] = ${'origin'.$i};
  79.                         $origins[] = ${'origin'.$i};
  80.                         $AvailabilityArray['destination'.$i] = ${'destination'.$i};
  81.                         $destinations[] = ${'destination'.$i};
  82.                     }
  83.                     $intersect = array_intersect_assoc($origins, $destinations);
  84.                     if (0 == sizeof($intersect)) {
  85.                         $heliportInfo = $querySeachHeliports->getQuery()->getResult();
  86.                         for ($i = 1; $i <= $helicopters; ++$i) {
  87.                             $tempOriginCheck = 0;
  88.                             $tempDestinationCheck = 0;
  89.                             for ($j = 0; $j < sizeof($heliportInfo); ++$j) {
  90.                                 if (($AvailabilityArray['origin'.$i] == $heliportInfo[$j]->getIata()) && (!$tempOriginCheck)) {
  91.                                     $tempOriginCheck = 1;
  92.                                     $AvailabilityArray['originLabel'.$i] = $heliportInfo[$j]->getName().', '.$heliportInfo[$j]->getCity().', '.$heliportInfo[$j]->getCountry().'('.$heliportInfo[$j]->getIata().')';
  93.                                     $cityOriginName = $heliportInfo[$j]->getCity();
  94.                                 }
  95.                                 if (($AvailabilityArray['destination'.$i] == $heliportInfo[$j]->getIata()) && (!$tempDestinationCheck)) {
  96.                                     $tempDestinationCheck = 1;
  97.                                     $AvailabilityArray['destinationLabel'.$i] = $heliportInfo[$j]->getName().', '.$heliportInfo[$j]->getCity().', '.$heliportInfo[$j]->getCountry().'('.$heliportInfo[$j]->getIata().')';
  98.                                     $cityDestinationName = $heliportInfo[$j]->getCity();
  99.                                 }
  100.                                 if ($tempDestinationCheck && $tempOriginCheck) {
  101.                                     $j = sizeof($heliportInfo);
  102.                                 }
  103.                             }
  104.                         }
  105.                         $response = new Response();
  106.                         if ($agency->getDomainsecure() == $agency->getDomain() && '443' != $agency->getCustomport()) {
  107.                             $safeUrl = 'https://'.$agency->getDomain();
  108.                         } else {
  109.                             $safeUrl = 'https://'.$agency->getDomainsecure();
  110.                         }
  111.                         $cookieLastSearch = $helicopterSearchCookie->searchHelicopterCookie(['helicopter' => base64_encode(json_encode($AvailabilityArray))]);
  112.                         if ($session->has('operatorId')) {
  113.                             $urlDescription['long'] = null;
  114.                             $urlDescription['short'] = null;
  115.                             $agencyFolder = $twigFolder->twigFlux();
  116.                             $response = $this->render($twigFolder->twigExists('@AviaturTwig/'.$agencyFolder.'/Helicopter/Default/availability.html.twig'), [
  117.                                 'ajaxUrl' => $requestUrl,
  118.                                 'AvailabilityArray' => $AvailabilityArray,
  119.                                 'cityOriginName' => $cityOriginName,
  120.                                 'cityDestinationName' => $cityDestinationName,
  121.                                 'helicopters' => $helicopters,
  122.                                 'inlineEngine' => true,
  123.                                 'safeUrl' => $safeUrl,
  124.                                 'cookieLastSearch' => $cookieLastSearch,
  125.                                 'urlDescription' => $urlDescription,
  126.                                 'availabilityFront' => true,
  127.                             ]);
  128.                         } else {
  129.                             $seoUrl = $em->getRepository(\Aviatur\GeneralBundle\Entity\SeoUrl::class)->findByUrlorMaskedUrl($requestUrl);
  130.                             $urlDescription['long'] = null != $seoUrl ? $seoUrl[0]->getDescription() : '';
  131.                             $urlDescription['short'] = null != $seoUrl ? $seoUrl[0]->getShortdescription() : '';
  132.                             $agencyFolder = $twigFolder->twigFlux();
  133.                             $response = $this->render($twigFolder->twigExists('@AviaturTwig/'.$agencyFolder.'/Helicopter/Default/availability.html.twig'), [
  134.                                 'ajaxUrl' => $requestUrl,
  135.                                 'AvailabilityArray' => $AvailabilityArray,
  136.                                 'cityOriginName' => $cityOriginName,
  137.                                 'cityDestinationName' => $cityDestinationName,
  138.                                 'helicopters' => $helicopters,
  139.                                 'inlineEngine' => true,
  140.                                 'safeUrl' => $safeUrl,
  141.                                 'cookieLastSearch' => $cookieLastSearch,
  142.                                 'urlDescription' => $urlDescription,
  143.                                 'availabilityFront' => false,
  144.                             ]);
  145.                         }
  146.                         $response->headers->setCookie(new Cookie('_availability_array[helicopter]', base64_encode(json_encode($AvailabilityArray)), (time() + 3600 * 24 * 7), '/'));
  148.                         return $response;
  149.                     } else {
  150.                         //test: /vuelos/BAQ-BAQ/2014-12-18/BAQ-BAQ/2014-12-23/BAQ-BAQ/2015-01-07/1-0-0
  151.                         foreach ($intersect as $helicopter => $destination) {
  152.                             if (($helicopter + 1) < $helicopters) {
  153.                                 if (('BOG' != ${'origin'.($helicopter + 2)}) && (${'origin'.($helicopter + 2)} != ${'origin'.($helicopter + 1)})) {
  154.                                     ${'destination'.($helicopter + 1)} = ${'origin'.($helicopter + 2)};
  155.                                 } elseif ('BOG' != $destination) {
  156.                                     if ($helicopter > 0) {
  157.                                         if ('BOG' != ${'destination'.$helicopter}) {
  158.                                             ${'destination'.($helicopter + 1)} = 'BOG';
  159.                                         } else {
  160.                                             ${'origin'.($helicopter + 1)} = 'BOG';
  161.                                         }
  162.                                     } else {
  163.                                         ${'destination'.($helicopter + 1)} = 'BOG';
  164.                                     }
  165.                                 } else {
  166.                                     ${'destination'.($helicopter + 1)} = 'CTG';
  167.                                 }
  168.                             } else {
  169.                                 if ('BOG' != $destination) {
  170.                                     ${'destination'.($helicopter + 1)} = 'BOG';
  171.                                 } else {
  172.                                     ${'destination'.($helicopter + 1)} = 'CTG';
  173.                                 }
  174.                             }
  175.                         }
  176.                     }
  177.                 } else {
  178.                     //test: /vuelos/BAQ-BOG/2014-12-18+2014-12-15/1-0-0
  179.                     foreach ($dateError as $key => $date) {
  180.                         if ($date < date('Y-m-d\TH:i:s', strtotime('today +12 hour'))) {
  181.                             ${'date'.$key} = date('Y-m-d', strtotime('+1 day'));
  182.                         } elseif ($date > date('Y-m-d\TH:i:s', strtotime('+11 month'))) {
  183.                             if (isset($AvailabilityArray['date'.($key - 1)])) {
  184.                                 ${'date'.$key} = date('Y-m-d', strtotime($AvailabilityArray['date'.($key - 1)].'+1 week'));
  185.                                 if (${'date'.$key} > date('Y-m-d\TH:i:s', strtotime('+11 month'))) {
  186.                                     ${'date'.$key} = date('Y-m-d', strtotime('-1 day +11 month'));
  187.                                 }
  188.                             } else {
  189.                                 ${'date'.$key} = date('Y-m-d', strtotime(${'date'.$key}.'-12 month'));
  190.                             }
  191.                         } else {
  192.                             ${'date'.$key} = date('Y-m-d', strtotime($AvailabilityArray['date'.($key - 1)].'+1 week'));
  193.                         }
  194.                     }
  195.                 }
  196.             } else {
  197.                 //test: /vuelos/BAQ-BAQ/2014-12-18/5-3-2
  198.                 if ($adults > 9) {
  199.                     $adults = 9;
  200.                     $children = 0;
  201.                     $infants = 0;
  202.                 } elseif ($adults + $children > 9) {
  203.                     $children = 9 - $adults;
  204.                     $infants = 0;
  205.                 } elseif ($adults + $children + $infants > 9) {
  206.                     $infants = 9 - $adults - $children;
  207.                 } elseif ($infants > $adults) {
  208.                     $infants = $adults;
  209.                 }
  210.             }
  211.             if ('aviatur_helicopter_round' == $route) {
  212.                 $origin2 = null;
  213.                 $destination2 = null;
  214.             }
  215.             $url = $this->generateUrl(
  216.                 $request->get('_route'),
  217.                 [
  218.                 'date1' => $date1,
  219.                 'date2' => $date2,
  220.                 'origin1' => $origin1,
  221.                 'origin2' => $origin2,
  222.                 'destination1' => $destination1,
  223.                 'destination2' => $destination2,
  224.                 'adults' => $adults,
  225.                 'children' => $children,
  226.                 'infants' => $infants,
  227.                     ]
  228.             );
  230.             return $this->redirect($aviaturErrorHandler->errorRedirectNoEmail($url, 'Recomendación Automática', 'La consulta que realizaste no era válida, hemos analizado tu búsqueda y esta es nuestra recomendación'));
  231.         } else {
  232.             $session->remove($session->get($transactionIdSessionName).'[helicopter][availability_file]');
  233.             $helicopterModel = new HelicopterModel();
  234.             if ($session->has('maxResults')) {
  235.                 $maxResults = $session->get('maxResults');
  236.                 $session->remove('maxResults');
  237.             } else {
  238.                 $maxResults = $request->query->get('maxResults');
  239.             }
  240.             $xmlTemplate = $helicopterModel->getXmlAvailability();
  241.             $xmlRequest = $xmlTemplate[0];
  242.             for ($i = 1; $i <= $helicopters; ++$i) {
  243.                 $xmlTempOriginDestination = str_replace(['{templateDate}', '{templateOrigin}', '{templateDestination}'], ['{date'.$i.'}', '{origin'.$i.'}', '{destination'.$i.'}'], $xmlTemplate[1]);
  244.                 $xmlTempOriginDestination = str_replace(' CrossDateAllowedIndicator="true"', '', $xmlTempOriginDestination);
  245.                 if (false !== strpos(${'date'.$i}, 'T')) {
  246.                     ${'date'.$i} = date('Y-m-d\TH:i:s', strtotime(substr(${'date'.$i}, 0, 10).sprintf('+%d hours', substr(${'date'.$i}, -2))));
  247.                 } else {
  248.                     ${'date'.$i} = date('Y-m-d\TH:i:s', strtotime(substr(${'date'.$i}, 0, 10)));
  249.                 }
  250.                 $xmlRequest .= $xmlTempOriginDestination;
  251.             }
  252.             $xmlRequest .= $xmlTemplate[2];
  253.             $domain = str_replace('www.', '', $request->getHost());
  254.             $productType = $em->getRepository(\Aviatur\MpaBundle\Entity\ProductType::class)->findByCode('HELICOPTER');
  255.             $providers = [];
  256.             if ($session->has('helicopterAdapterId')) {
  257.                 $providers = explode(';', $session->get('helicopterAdapterId'));
  258.                 $configsHelicopterAgency = $em->getRepository(\Aviatur\MpaBundle\Entity\Provider::class)->findByProvideridentifier($providers);
  259.                 foreach ($configsHelicopterAgency as $configHelicopterAgency) {
  260.                     $provider = $configHelicopterAgency->getProvideridentifier();
  261.                     if (!in_array($provider, $providers)) {
  262.                         $providers[] = $provider;
  263.                     }
  264.                 }
  265.             } else {
  266.                 $configsHelicopterAgency = $em->getRepository(\Aviatur\HelicopterBundle\Entity\ConfigHelicopterAgency::class)->findProviderForHelicopters($productType, $domain);
  267.                 foreach ($configsHelicopterAgency as $configHelicopterAgency) {
  268.                     $provider = $configHelicopterAgency->getProvider()->getProvideridentifier();
  269.                     if (!in_array($provider, $providers)) {
  270.                         $providers[] = $provider;
  271.                     }
  272.                 }
  273.             }
  274.             $providerIds = implode(';', $providers);
  275.             $xmlRequest .= $xmlTemplate['class'];
  276.             $date1 = strtotime($date1) < strtotime('now') ? date('Y-m-d\Th:i:s') : $date1;
  277.             $date2 = strtotime($date2) < strtotime('now') ? date('Y-m-d\Th:i:s') : $date2;
  278.             $variable = [
  279.                 'ProviderId' => $providerIds,
  280.                 'date1' => $date1,
  281.                 'date2' => $date2,
  282.                 'origin1' => $origin1,
  283.                 'origin2' => $origin2,
  284.                 'destination1' => $destination1,
  285.                 'destination2' => $destination2,
  286.                 'adults' => $adults,
  287.                 'children' => $children,
  288.                 'infants' => 0,
  289.                 'cabin' => 'Economy',
  290.                 'MaxResponses' => $maxResults,
  291.             ];
  292.             $variable['ProviderId'] = $providerIds;
  293.             $variable['externalId'] = $agency->getExternalid();
  294.             $variable['officeId'] = $agency->getOfficeid();
  295.             if ($session->has('officeId')) {
  296.                 $variable['externalId'] = $session->get('externalId');
  297.                 $variable['officeId'] = $session->get('officeId');
  298.             }
  299.             $xmlRequest .= $xmlTemplate[3];
  300.             // AVAILABILITY XML
  301.             $makeLogin = true;
  302.             if ($session->has($transactionIdSessionName.'Multi')) {
  303.                 $transactionDatetime = $session->get($transactionIdSessionName.'MultiTime');
  304.                 if ((strtotime(date('Y-m-d H:i:s')) - strtotime($transactionDatetime)) < 60) {
  305.                     $transactionId = $session->get($transactionIdSessionName.'Multi');
  306.                     $session->set($transactionIdSessionName, $transactionId);
  307.                     $variable['transaction'] = $transactionId;
  308.                     $makeLogin = false;
  309.                 } else {
  310.                     $session->remove($transactionIdSessionName.'Multi');
  311.                 }
  312.             }
  313.             if ($makeLogin) {
  314.                 $transactionIdResponse = $aviaturWebService->loginService('SERVICIO_MPT', 'dummy|http://www.aviatur.com.co/dummy/', []);
  315.                 if ('error' == $transactionIdResponse || is_array($transactionIdResponse)) {
  316.                     $aviaturErrorHandler->errorRedirect('', 'Error MPA', 'No se creó Login!');
  318.                     return new Response('Estamos experimentando dificultades técnicas en este momento.');
  319.                 }
  320.                 $transactionId = (string) $transactionIdResponse;
  321.                 $variable['transaction'] = $transactionId;
  322.                 $session->set($transactionIdSessionName, $transactionId);
  323.             }
  324.             $xmlResponse = $this->combinationGeneration($xmlRequest, $variable, $route);
  325.             if (isset($xmlResponse['error'])) {
  326.                 $transactionId = (string) $aviaturWebService->loginService('SERVICIO_MPT', 'dummy|http://www.aviatur.com.co/dummy/', []);
  327.                 if ('error' == $transactionId) {
  328.                     $aviaturErrorHandler->errorRedirect('', 'Error MPA', 'No se creó Login!');
  330.                     return new Response('Estamos experimentando dificultades técnicas en este momento.');
  331.                 }
  332.                 $variable['transaction'] = $transactionId;
  333.                 $session->set($transactionIdSessionName, $transactionId);
  334.                 $xmlResponse = $this->combinationGeneration($xmlRequest, $variable, $route);
  335.                 if (isset($xmlResponse['error'])) {
  336.                     if (false === strpos($xmlResponse['error'], '66002')) {
  337.                         $aviaturErrorHandler->errorRedirect($requestUrl, 'Error Disponibilidad Helicopteros', $xmlResponse['error']);
  338.                     }
  340.                     return new Response($xmlResponse['error']);
  341.                 }
  342.             }
  343.             if (!is_object($xmlResponse)) {
  344.                 return new Response('Ocurrió un error inesperado en tu consulta, inténtalo nuevamente.');
  345.             }
  346.             $xmlResponse->Message->OTA_AirLowFareSearchRS['TransactionID'] = $transactionId;
  347.             $fileName = $aviaturLogSave->logSave($xmlResponse->asXML(), 'HelicopterAvailResponse', 'RS');
  348.             $session->set($transactionId.'[helicopter][availability_file]', $fileName);
  350.             return $this->generateAjaxResponse($xmlResponse);
  351.         }
  352.     }
  354.     public function getAvailabilityResultsAction(SessionInterface $session, ParameterBagInterface $parameterBag)
  355.     {
  356.         $transactionIdSessionName = $parameterBag->get('transaction_id_session_name');
  358.         if ($session->has($transactionIdSessionName)) {
  359.             $transactionId = $session->get($transactionIdSessionName);
  360.             if (true === $session->has($transactionId.'[helicopter][availability_file]')) {
  361.                 $availFile = $session->get($transactionId.'[helicopter][availability_file]');
  362.                 $response = \simplexml_load_file($availFile);
  364.                 return $this->generateAjaxResponse($response);
  365.             } else {
  366.                 if ($session->has($transactionId.'[availability_results_retry]')) {
  367.                     $retry = $session->get($transactionId.'[availability_results_retry]');
  368.                     if ($retry < 8) {
  369.                         $session->set($transactionId.'[availability_results_retry]', $retry + 1);
  371.                         return new Response('retry');
  372.                     } else {
  373.                         return new Response('error');
  374.                     }
  375.                 } else {
  376.                     $session->set($transactionId.'[availability_results_retry]', 1);
  378.                     return new Response('retry');
  379.                 }
  380.             }
  381.         } else {
  382.             return new Response('error');
  383.         }
  384.     }
  386.     private function generateAjaxResponse(TwigFolder $twigFolder, GenerateFlightResumeEmail $generateFlightResumeEmail, $response)
  387.     {
  388.         $attributes = [
  389.             'Version' => $response->Message->OTA_AirLowFareSearchRS['Version'],
  390.             'SequenceNmbr' => $response->Message->OTA_AirLowFareSearchRS['SequenceNmbr'],
  391.             'CorrelationID' => $response->Message->OTA_AirLowFareSearchRS['CorrelationID'],
  392.             'TransactionID' => $response->Message->OTA_AirLowFareSearchRS['TransactionID'],
  393.         ];
  394.         $transactionId = $response->Message->OTA_AirLowFareSearchRS['TransactionID'];
  395.         $response->Message->OTA_AirLowFareSearchRS['TransactionID'] = $transactionId;
  396.         $pricedItineraries = $response->Message->OTA_AirLowFareSearchRS->PricedItineraries;
  397.         $bestPrices = [];
  398.         foreach ($pricedItineraries->PricedItinerary as $pricedItinerary) {
  399.             $correlationID = str_replace('CorrelationID=', '', current(explode(';', (string) $pricedItinerary->Notes)));
  400.             $pricedItinerary->AirItineraryPricingInfo->ItinTotalFare->TPA_Extensions->Secure['Check'] = crypt($correlationID.'/'.$transactionId, 'OneFlewOvertheCuckoosNest');
  401.             $providerIdArray = explode('ProviderId=', (string) $pricedItinerary->Notes);
  402.             $providerIdArray = explode(';', $providerIdArray[1]);
  403.             $providerSegment = $providerIdArray[0];
  404.             foreach ($pricedItinerary->AirItinerary->OriginDestinationOptions->OriginDestinationOption as $originDestinationOption) {
  405.                 $arrivalEscala = null;
  406.                 $totalDuration = 0;
  407.                 foreach ($originDestinationOption->FlightSegment as $flightSegment) {
  408.                     $airlineCode = (string) $flightSegment->OperatingAirline['Code'];
  409.                     if (!array_key_exists($airlineCode, $bestPrices)) {
  410.                         $airlineName = (string) $flightSegment->OperatingAirline['CompanyShortName'];
  411.                         $helicopterPrice = (string) $pricedItinerary->AirItineraryPricingInfo->ItinTotalFare->TotalFare['Amount'];
  412.                         $helicopterCurrency = (string) $pricedItinerary->AirItineraryPricingInfo->ItinTotalFare->TotalFare['CurrencyCode'];
  413.                         $bestPrices[$airlineCode] = [
  414.                             'helicopterPrice' => $helicopterPrice,
  415.                             'helicopterCurrency' => $helicopterCurrency,
  416.                             'airlineName' => $airlineName, ];
  417.                     }
  418.                     $comments = (array) $flightSegment->Comment;
  419.                     if (9 != $providerSegment) {
  420.                         if (null != $arrivalEscala) {
  421.                             $totalDuration += (int) abs(strtotime($flightSegment['DepartureDateTime']) - strtotime($arrivalEscala)) / 60;
  422.                         }
  423.                         $totalDuration += (int) substr($comments[12], strpos($comments[12], ':') + 2, 100);
  424.                         $arrivalEscala = $flightSegment['ArrivalDateTime'];
  425.                     } else {
  426.                         $totalDuration = (string) $generateFlightResumeEmail->convertToHoursMins(substr($comments[12], strpos($comments[12], ':') + 2, 100));
  427.                     }
  428.                 }
  429.                 if (is_int($totalDuration)) {
  430.                     $totalDuration = (string) $generateFlightResumeEmail->convertToHoursMins($totalDuration);
  431.                 }
  432.                 $originDestinationOption['totalDuration'] = $totalDuration;
  433.             }
  434.         }
  435.         $helicopters = $pricedItineraries->PricedItinerary;
  436.         $agencyFolder = $twigFolder->twigFlux();
  438.         return $this->render($twigFolder->twigExists('@AviaturTwig/'.$agencyFolder.'/Helicopter/Default/availability_ajaxResults.html.twig'), [
  439.                     'attributes' => $attributes,
  440.                     'bestPrices' => $bestPrices,
  441.                     'helicopters' => $helicopters, ]);
  442.     }
  444.     private function multiRequest(Request $request, AviaturLogSave $aviaturLogSave, SessionInterface $session, array $requests, $method = null, $transactionId = null)
  445.     {
  446.         $domain = $request->getHost();
  447.         $parametersJson = $session->get($domain.'[parameters]', '');
  448.         $parameters = json_decode($parametersJson);
  449.         $url = $parameters->aviatur_service_web_url_mpa;
  450.         $handles = [];
  451.         $timeout = 100;
  452.         $defaultOptions = [
  453.             CURLOPT_USERAGENT => 'Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.0)',
  454.             CURLOPT_URL => $url,
  455.             CURLOPT_RETURNTRANSFER => true,
  456.             CURLOPT_SSL_VERIFYHOST => false,
  457.             CURLOPT_SSL_VERIFYPEER => false,
  458.             CURLOPT_MAXREDIRS => 10,
  459.             CURLOPT_FOLLOWLOCATION => true,
  460.             CURLOPT_CONNECTTIMEOUT => $timeout,
  461.             CURLOPT_POST => true,
  462.         ];
  463.         // add curl options to each handle
  464.         foreach ($requests as $k => $request) {
  465.             $headers = [
  466.                 'POST /AmadeusLATAM.Aviatur.Services/services/mpaservice.asmx HTTP/1.1',
  467.                 'Content-Type: text/xml; charset=utf-8',
  468.                 'Content-Length: '.strlen($request),
  469.                 'SOAPAction: "http://tempuri.org/Execute"',
  470.             ];
  471.             $options = $defaultOptions;
  472.             $options += [
  473.                 CURLOPT_HTTPHEADER => $headers,
  474.                 CURLOPT_POSTFIELDS => $request,
  475.             ];
  476.             $ch[$k] = curl_init();
  477.             $opt = curl_setopt_array($ch[$k], $options);
  478.             $handles[$k] = $ch[$k];
  479.             $aviaturLogSave->logSave($request, $method, 'RQ', $transactionId);
  480.         }
  481.         $mh = curl_multi_init();
  482.         // add handles
  483.         foreach ($handles as $k => $handle) {
  484.             $err = curl_multi_add_handle($mh, $handle);
  485.         }
  486.         $running_handles = null;
  487.         do {
  488.             curl_multi_exec($mh, $running_handles);
  489.             curl_multi_select($mh);
  490.         } while ($running_handles > 0);
  492.         $response = [];
  493.         foreach ($requests as $k => $request) {
  494.             $response[$k]['error'] = curl_error($handles[$k]);
  495.             if (!empty($response[$k]['error'])) {
  496.                 $response[$k]['data'] = '';
  497.                 $aviaturLogSave->logSave($response[$k]['error'], $method, 'RS', $transactionId);
  498.             } else {
  499.                 $response[$k]['data'] = curl_multi_getcontent($handles[$k]);  // get results
  500.                 $aviaturLogSave->logSave($response[$k]['data'], $method, 'RS', $transactionId);
  501.             }
  502.             // close current handler
  503.             curl_multi_remove_handle($mh, $handles[$k]);
  504.         }
  505.         curl_multi_close($mh);
  507.         return $response;
  508.     }
  510.     private function combinationGeneration(ManagerRegistry $registry, AviaturWebService $aviaturWebService, $xmlRequest, $variable, $route)
  511.     {
  512.         $em = $registry->getManager();
  513.         $providers = explode(';', $variable['ProviderId']);
  514.         $providerObjects = $em->getRepository(\Aviatur\MpaBundle\Entity\Provider::class)->findByProvideridentifier($providers);
  515.         $hasCombination = true;
  516.         foreach ($providerObjects as $providerObject) {
  517.             $configHelicopterAgency = $em->getRepository(\Aviatur\HelicopterBundle\Entity\ConfigHelicopterAgency::class)->findOneByProvider($providerObject);
  518.             if (0 == $configHelicopterAgency->getHascombination()) {
  519.                 $hasCombination = false;
  520.             }
  521.         }
  522.         $variable['correlationId'] = '';
  523.         $xmlResponse = $aviaturWebService->callWebServiceAmadeus('SERVICIO_MPT', 'AirLowFareSearch', 'dummy|http://www.aviatur.com.co/dummy/', $xmlRequest, $variable, false);
  525.         return $xmlResponse;
  526.     }
  528.     private function orderCombinationResponse($xmlResponseSegment1)
  529.     {
  530.         $key = 0;
  531.         $options = [];
  532.         foreach ($xmlResponseSegment1->Message->OTA_AirLowFareSearchRS->PricedItineraries->PricedItinerary as $pricedItinerary) {
  533.             $options[$key]['amount'] = (float) $pricedItinerary->AirItineraryPricingInfo->ItinTotalFare->TotalFare['Amount'];
  534.             $options[$key]['xml'] = $pricedItinerary->asXml();
  535.             ++$key;
  536.         }
  537.         usort($options, fn($a, $b) => $a['amount'] - $b['amount']);
  538.         $responseXml = explode('<PricedItinerary>', str_replace('</PricedItinerary>', '<PricedItinerary>', $xmlResponseSegment1->asXml()));
  539.         $orderedResponse = $responseXml[0];
  540.         $key = 0;
  541.         foreach ($options as $option) {
  542.             if ($key < 10) {
  543.                 $orderedResponse .= $option['xml'];
  544.                 ++$key;
  545.             }
  546.         }
  547.         $orderedResponse .= $responseXml[sizeof($responseXml) - 1];
  549.         return \simplexml_load_string($orderedResponse);
  550.     }
  552.     private function specialDiscount(Request $request, SessionInterface $session, $xmlResponse, $specialDiscountHelicopter, $isNational, $specialDiscountWithIva)
  553.     {
  554.         $parameters = json_decode($session->get($request->getHost().'[parameters]'));
  555.         if (null != $specialDiscountHelicopter) {
  556.             if ((1 == $specialDiscountHelicopter[0]->getHelicoptertype()) || ((null == $specialDiscountHelicopter[0]->getHelicoptertype())) && ($isNational)) {
  557.                 $specialDiscountAirline = $specialDiscountHelicopter[0]->getAirline()->getIata();
  558.                 $specialDiscountMaxStops = $specialDiscountHelicopter[0]->getMaxstops();
  559.                 foreach ($xmlResponse->Message->OTA_AirLowFareSearchRS->PricedItineraries->PricedItinerary as $pricedItinerary) {
  560.                     if (isset($pricedItinerary->AirItineraryPricingInfo->ItinTotalFare->EquivFare['Amount']) && ($pricedItinerary->AirItineraryPricingInfo->ItinTotalFare->EquivFare['Amount'] != $pricedItinerary->AirItineraryPricingInfo->ItinTotalFare->BaseFare['Amount'])) {
  561.                         if (((string) $pricedItinerary->TicketingInfo->TicketingVendor['Code'] == $specialDiscountAirline) && (sizeof($pricedItinerary->AirItinerary->OriginDestinationOptions->OriginDestinationOption->FlightSegment) <= $specialDiscountMaxStops)) {
  562.                             $passangerCount = 0;
  563.                             foreach ($pricedItinerary->AirItineraryPricingInfo->PTC_FareBreakdowns->PTC_FareBreakdown as $passangers) {
  564.                                 if ('0' != (string) $passangers->PassengerFare->BaseFare['Amount']) {
  565.                                     $passangerCount += (string) $passangers->PassengerTypeQuantity['Quantity'];
  566.                                 }
  567.                             }
  568.                             $fuelFee = (int) $pricedItinerary->AirItineraryPricingInfo->ItinTotalFare->EquivFare['Amount'];
  569.                             $totalBaseFare = 0;
  570.                             $totalTaxes = 0;
  571.                             $totalTotalFare = 0;
  572.                             foreach ($pricedItinerary->AirItineraryPricingInfo->PTC_FareBreakdowns->PTC_FareBreakdown as $fareBreakDown) {
  573.                                 $baseFare = (int) $fareBreakDown->PassengerFare->BaseFare['Amount'];
  574.                                 $taxes = (int) $fareBreakDown->PassengerFare->Taxes['Amount'];
  575.                                 $totalFare = (int) $fareBreakDown->PassengerFare->TotalFare['Amount'];
  576.                                 if (0 != $baseFare) {
  577.                                     $fuelFeePax = $fuelFee / $passangerCount;
  578.                                     $netFare = $baseFare - $fuelFeePax;
  579.                                     $extraFee = 100;
  580.                                     $ivaTaxBefore = $netFare * $parameters->aviatur_payment_iva;
  581.                                     if (1 == $specialDiscountHelicopter[0]->getDiscounttype()) {
  582.                                         $netFare = $netFare * (1 - ($specialDiscountHelicopter[0]->getDiscountamount() / 100)) + $extraFee;
  583.                                         $baseFare = $netFare + $fuelFeePax;
  584.                                     } else {
  585.                                         $baseFare = $baseFare - ($specialDiscountHelicopter[0]->getDiscountamount() / $passangerCount);
  586.                                     }
  587.                                     if ($specialDiscountWithIva) {
  588.                                         $taxes = ceil(($taxes - ($ivaTaxBefore - ($netFare * $parameters->aviatur_payment_iva))) / 10) * 10;
  589.                                     }
  590.                                     $baseFare = ceil($baseFare / 100) * 100;
  591.                                     $totalFare = $baseFare + $taxes;
  592.                                     $fareBreakDown->PassengerFare->BaseFare['Amount'] = $baseFare;
  593.                                     $fareBreakDown->PassengerFare->Taxes['Amount'] = $taxes;
  594.                                     $fareBreakDown->PassengerFare->TotalFare['Amount'] = $totalFare;
  595.                                     $paxQuantity = (int) $fareBreakDown->PassengerTypeQuantity['Quantity'];
  596.                                     $totalBaseFare += ($baseFare * $paxQuantity);
  597.                                     $totalTaxes += ($taxes * $paxQuantity);
  598.                                     $totalTotalFare += ($totalFare * $paxQuantity);
  599.                                 }
  600.                             }
  601.                             $pricedItinerary->AirItineraryPricingInfo->ItinTotalFare->BaseFare['Amount'] = $totalBaseFare;
  602.                             $pricedItinerary->AirItineraryPricingInfo->ItinTotalFare->BaseFare['SpecialDiscount'] = true;
  603.                             $pricedItinerary->AirItineraryPricingInfo->ItinTotalFare->Taxes['Amount'] = $totalTaxes;
  604.                             $pricedItinerary->AirItineraryPricingInfo->ItinTotalFare->TotalFare['Amount'] = $totalTotalFare;
  605.                         }
  606.                     }
  607.                 }
  608.             }
  609.         }
  611.         return $xmlResponse;
  612.     }
  614.     public function availabilityDetailAction(Request $request, TwigFolder $twigFolder, SessionInterface $session, $transactionId = null, $quoteId = null, $refNbr = null, $rph = null)
  615.     {
  616.         if ($request->isXmlHttpRequest()) {
  617.             if (null != $transactionId) {
  618.                 if (true === $session->has($transactionId.'[helicopter][availability_file]')) {
  619.                     $availFile = $session->get($transactionId.'[helicopter][availability_file]');
  620.                     $availObj = \simplexml_load_file($availFile);
  621.                     foreach ($availObj->Message->OTA_AirLowFareSearchRS->PricedItineraries->PricedItinerary as $PricedItinary) {
  622.                         if ($PricedItinary->AirItineraryPricingInfo['QuoteID'] == $quoteId) {
  623.                             $providerIdArray = explode('ProviderId=', (string) $PricedItinary->Notes);
  624.                             $providerIdArray = explode(';', $providerIdArray[1]);
  625.                             $providerSegment = $providerIdArray[0];
  626.                             foreach ($PricedItinary->AirItinerary->OriginDestinationOptions->OriginDestinationOption as $originDestination) {
  627.                                 if (($originDestination['RefNumber'] == $refNbr) && ($originDestination->FlightSegment['RPH'] == $rph)) {
  628.                                     $helicopters = [];
  629.                                     $arrivalEscala = null;
  630.                                     $totalDuration = 0;
  631.                                     foreach ($originDestination->FlightSegment as $flightSegment) {
  632.                                         if (null != $arrivalEscala) {
  633.                                             $totalDuration += (int) abs(strtotime($flightSegment['DepartureDateTime']) - strtotime($arrivalEscala)) / 60;
  634.                                             $flightSegment->EscalaLength = $this->get('generate_helicopter_resume_email')->convertToHoursMins(abs(strtotime($flightSegment['DepartureDateTime']) - strtotime($arrivalEscala)) / 60);
  635.                                         }
  636.                                         $comments = (array) $flightSegment->Comment;
  637.                                         $flightSegment->departureAirport = (string) substr($comments[0], strpos($comments[0], ':') + 2, 100);
  638.                                         $flightSegment->arrivalAirport = (string) substr($comments[6], strpos($comments[6], ':') + 2, 100);
  639.                                         if (9 != $providerSegment) {
  640.                                             $flightSegment->HelicopterLength = (string) $this->get('generate_helicopter_resume_email')->convertToHoursMins(substr($comments[12], strpos($comments[12], ':') + 2, 100));
  641.                                             $totalDuration += (int) substr($comments[12], strpos($comments[12], ':') + 2, 100);
  642.                                         } else {
  643.                                             $totalDuration = (string) $this->get('generate_helicopter_resume_email')->convertToHoursMins(substr($comments[12], strpos($comments[12], ':') + 2, 100));
  644.                                             $flightSegment->HelicopterLength = $this->get('generate_helicopter_resume_email')->convertToHoursMins(abs(strtotime($flightSegment['DepartureDateTime']) - strtotime($flightSegment['ArrivalDateTime'])) / 60);
  645.                                         }
  646.                                         $arrivalEscala = $flightSegment['ArrivalDateTime'];
  647.                                         $helicopters[] = $flightSegment;
  648.                                     }
  649.                                     if (is_int($totalDuration)) {
  650.                                         $totalDuration = (string) $this->get('generate_helicopter_resume_email')->convertToHoursMins($totalDuration);
  651.                                     }
  652.                                     $agencyFolder = $twigFolder->twigFlux();
  654.                                     return $this->render($twigFolder->twigExists('@AviaturTwig/'.$agencyFolder.'/Helicopter/Default/availability_ajaxHelicopterDetail.html.twig'), ['helicopters' => $helicopters, 'totalDuration' => $totalDuration]);
  655.                                 }
  656.                             }
  657.                         }
  658.                     }
  660.                     return $this->json(['error' => 'no info found']);
  661.                 } else {
  662.                     return $this->json(['error' => 'no session found']);
  663.                 }
  664.             } else {
  665.                 return $this->json(['error' => 'no autorized access']);
  666.             }
  667.         } else {
  668.             return $this->json(['error' => 'no autorized access']);
  669.         }
  670.     }
  672.     public function availabilitySeoAction(Request $request, RouterInterface $router, SessionInterface $session, ManagerRegistry $registry, $url)
  673.     {
  674.         $em = $registry->getManager();
  675.         $seoUrl = $em->getRepository(\Aviatur\GeneralBundle\Entity\SeoUrl::class)->findOneByUrl('helicopteros/'.$url);
  676.         if (null != $seoUrl) {
  677.             $maskedUrl = $seoUrl->getMaskedurl();
  678.             $session->set('maxResults', $request->query->get('maxResults'));
  679.             if (false !== strpos($maskedUrl, '?')) {
  680.                 $parameters = explode('&', substr($maskedUrl, strpos($maskedUrl, '?') + 1));
  681.                 foreach ($parameters as $parameter) {
  682.                     $sessionInfo = explode('=', $parameter);
  683.                     if (2 == sizeof($sessionInfo)) {
  684.                         $session->set($sessionInfo[0], $sessionInfo[1]);
  685.                     }
  686.                 }
  687.                 $maskedUrl = substr($maskedUrl, 0, strpos($maskedUrl, '?'));
  688.             }
  689.             if (null != $seoUrl) {
  690.                 $route = $router->match($maskedUrl);
  691.                 $route['_route_params'] = [];
  692.                 foreach ($route as $param => $val) {
  693.                     // set route params without defaults
  694.                     if ('_' !== \substr($param, 0, 1)) {
  695.                         $route['_route_params'][$param] = $val;
  696.                     }
  697.                 }
  699.                 return $this->forward($route['_controller'], $route);
  700.             } else {
  701.                 throw $this->createNotFoundException('La página que solicitaste no existe o se ha movido permanentemente');
  702.             }
  703.         } else {
  704.             throw $this->createNotFoundException('La página que solicitaste no existe o se ha movido permanentemente');
  705.         }
  706.     }
  708.     public function detailAction(Request $request, GenerateFlightResumeEmail $generateFlightResumeEmail, AviaturErrorHandler $aviaturErrorHandler, TwigFolder $twigFolder, AviaturXsltRender $renderXslt, RouterInterface $router, AviaturWebService $aviaturWebService, SessionInterface $session, ManagerRegistry $registry, ParameterBagInterface $parameterBag)
  709.     {
  710.         $transactionIdSessionName = $parameterBag->get('transaction_id_session_name');
  711.         $correlationIdSessionName = $parameterBag->get('correlation_id_session_name');
  713.         $response = [];
  714.         $origin = [];
  715.         $destination = [];
  716.         $passangerTypes = [];
  717.         $provider = null;
  718.         $fullRequest = $request;
  719.         $request = $fullRequest->request;
  720.         // Generate Helicopter Detail
  721.         $em = $registry->getManager();
  722.         $server = $fullRequest->server;
  723.         $agency = $em->getRepository(\Aviatur\AgencyBundle\Entity\Agency::class)->find($session->get('agencyId'));
  724.         $returnUrl = $twigFolder->pathWithLocale('aviatur_general_homepage');
  725.         if (true === $request->has('referer')) {
  726.             $returnUrl = $request->get('http_referer');
  727.         }
  728.         if (true === $request->has('helicopterTransactionID')) {
  729.             $transactionId = $request->get('helicopterTransactionID');
  730.             if (false !== strpos($transactionId, '||')) {
  731.                 $explodedTransaction = explode('||', $transactionId);
  732.                 $transactionId = $explodedTransaction[0];
  733.                 $request->set('helicopterTransactionID', $transactionId);
  734.                 $metaseachId = $explodedTransaction[1];
  735.                 $session->set('generals[metasearch]', $metaseachId);
  736.                 $metatransaction = $em->getRepository(\Aviatur\HelicopterBundle\Entity\Metatransaction::class)->findOneByTransactionId($transactionId);
  738.                 $d1 = $metatransaction->getDatetime();
  739.                 $d2 = new \DateTime(date('Y-m-d H:i:s', time() - (15 * 60)));
  740.                 if (false == $metatransaction->getIsactive()) {
  741.                     $response['error'] = 'Por favor selecciona nuevamente tu itinerario de viaje';
  743.                     return $this->redirect($aviaturErrorHandler->errorRedirectNoEmail($returnUrl, '', $response['error']));
  744.                 } elseif ($d1 < $d2) {
  745.                     $response['error'] = 'Por favor selecciona nuevamente tu itinerario de viaje';
  747.                     return $this->redirect($aviaturErrorHandler->errorRedirectNoEmail($returnUrl, 'Tu consulta fue realizada hace más de 15 minutos', $response['error']));
  748.                 } else {
  749.                     $metatransaction->setIsactive(false);
  750.                     $em->persist($metatransaction);
  751.                     $em->flush();
  752.                 }
  753.             }
  754.         } elseif ((true === $session->has('redirectedRetry')) && (true === $session->get('redirectedRetry'))) {
  755.             $session->set('redirectedRetry', false);
  756.             $transactionId = $session->get($transactionIdSessionName);
  757.         } else {
  758.             $response['error'] = 'No se encontró información de la transacción';
  760.             return $this->redirect($aviaturErrorHandler->errorRedirect($returnUrl, '', $response['error']));
  761.         }
  762.         $destinationsArray = null;
  764.         if ((true === $session->has($transactionId.'[helicopter][retry]')) || (true === $session->has($transactionId.'[helicopter][retry0]')) || (true === $session->has($transactionId.'[helicopter][retry1]'))) {
  765.             $response = \simplexml_load_string($session->get($transactionId.'[helicopter][detail]'));
  766.             $providerId = '';
  767.             foreach ($response->ProviderResults->ProviderResult as $providerIds) {
  768.                 $providerId = (string) $providerIds['Provider'];
  769.             }
  770.             $provider = $em->getRepository(\Aviatur\MpaBundle\Entity\Provider::class)->findOneByProvideridentifier($providerId);
  771.             if ($session->get($transactionId.'[helicopter][prepayment0]')) {
  772.                 $allDetails = \simplexml_load_string($session->get($transactionId.'[helicopter][prepayment0]'));
  773.             } else {
  774.                 $allDetails = \simplexml_load_string($session->get($transactionId.'[helicopter][prepayment]'));
  775.             }
  776.             foreach ($allDetails->Message->OTA_AirBookRS->AirReservation->TravelerInfo->AirTraveler as $traveler) {
  777.                 $travelers[] = [
  778.                     'DocType' => $traveler->Document['DocType'],
  779.                     'DocId' => $traveler->Document['DocID'],
  780.                     'Nationality' => $traveler->Document['DocHolderNationality'],
  781.                     'PassportExp' => $traveler->Document['ExpireDate'],
  782.                     'GivenName' => $traveler->PersonName->GivenName,
  783.                     'Surname' => $traveler->PersonName->Surname,
  784.                     'typeCode' => $traveler['PassengerTypeCode'],
  785.                     'BirthDate' => $traveler['BirthDate'],
  786.                     'Gender' => $traveler['Gender'],
  787.                     'Address' => $traveler->Address->AddressLine.'-'.$traveler->Address->CityName.'-'.$traveler->Address->CountryName,
  788.                     'Email' => $traveler->Email,
  789.                     'Telephone' => $traveler->Telephone['PhoneNumber'],
  790.                 ];
  791.             }
  792.             $postData = json_decode($session->get($transactionId.'[helicopter][detail_data_helicopter]'));
  793.             $passangerInfo = $postData->PI;
  794.             $billingData = $postData->BD;
  795.             $contactData = $postData->CD;
  796.             $baggageData = $postData->BI ?? null;
  797.             $twig_readonly = true;
  798.             $shortStopOver = false;
  799.         } else {
  800.             $RPHArray = $request->get('RPH');
  801.             $security = $request->get('helicopterSessionID');
  802.             $correlationID = $request->get('helicopterCorrelationID');
  803.             $session->set($transactionId.'[helicopter]['.$correlationIdSessionName.']', $correlationID);
  804.             $tempPF = explode('*', $request->get('helicopterPricedID'));
  805.             $pricedID = $tempPF[0];
  806.             $feeId = '';
  807.             if ($security == crypt($correlationID.'/'.$transactionId, 'OneFlewOvertheCuckoosNest')) {
  808.                 $providersId = explode('|', $request->get('helicopterProviderID'));
  809.                 if (true === $session->has($transactionId.'[helicopter][detail]')) {
  810.                     $reloaded = 1;
  811.                     if (sizeof($providersId) > 1) {
  812.                         $providers = [];
  813.                         $providerIdentifiers = [];
  814.                         foreach ($providersId as $providerId) {
  815.                             $providers[] = $em->getRepository(\Aviatur\MpaBundle\Entity\Provider::class)->findOneByProvideridentifier($providerId);
  816.                             $providerIdentifiers[] = $providers[array_key_last($providers)]->getProvideridentifier();
  817.                         }
  818.                     } else {
  819.                         $provider = $em->getRepository(\Aviatur\MpaBundle\Entity\Provider::class)->findOneByProvideridentifier($session->get($transactionId.'[helicopter][provider]'));
  820.                     }
  821.                     $response = \simplexml_load_string($session->get($transactionId.'[helicopter][detail]'));
  822.                 } else {
  823.                     $reloaded = 0;
  824.                     if (sizeof($providersId) > 1) {
  825.                         $providers = [];
  826.                         $providerIdentifiers = [];
  827.                         foreach ($providersId as $providerId) {
  828.                             $providers[] = $em->getRepository(\Aviatur\MpaBundle\Entity\Provider::class)->findOneByProvideridentifier($providerId);
  829.                             $providerIdentifiers[] = $providers[array_key_last($providers)]->getProvideridentifier();
  830.                         }
  831.                         $session->set($transactionId.'[helicopter][provider]', json_encode($providerIdentifiers));
  832.                         $pricedIDs = explode('|', $pricedID);
  833.                         $correlationIDs = explode('||', $correlationID);
  834.                         foreach ($providerIdentifiers as $key => $providerIdentifier) {
  835.                             $variable = [
  836.                                 'ProviderId' => $providerIdentifier,
  837.                                 'correlationID' => $correlationIDs[$key],
  838.                                 'pricedID' => $pricedIDs[$key],
  839.                                 'RPH' => $RPHArray[$key],
  840.                                 'timeStamp' => date('c'),
  841.                             ];
  842.                             $helicopterModel = new HelicopterModel();
  843.                             $xmlRequest = $helicopterModel->getXmlDetail();
  844.                             $tempResponse = $aviaturWebService->callWebServiceAmadeus('SERVICIO_MPT', 'AirDetail', 'dummy|http://www.aviatur.com.co/dummy/', $xmlRequest, $variable, false, $transactionId);
  845.                             if (!isset($tempResponse['error']) && ('error' != $tempResponse)) {
  846.                                 $responses[] = $tempResponse;
  847.                             } else {
  848.                                 $response['error'] = 'Error en la respuesta de nuestro proveedor de servicios, inténtalo nuevamente';
  850.                                 return $this->redirect($aviaturErrorHandler->errorRedirect($returnUrl, '', $response['error']));
  851.                             }
  852.                         }
  853.                         $baseFareCombination = 0;
  854.                         $equivFareCombination = 0;
  855.                         $taxesCombination = 0;
  856.                         $totalFareCombination = 0;
  857.                         $notesInfoCombination = '';
  858.                         $ptcFareBreakdownCombination = $responses[0]->Message->OTA_AirLowFareSearchRS->PricedItineraries->PricedItinerary->AirItineraryPricingInfo->PTC_FareBreakdowns;
  859.                         $ticketingVendorCombination = '';
  860.                         foreach ($responses as $key => $response) {
  861.                             $pricedItinerary = $response->Message->OTA_AirLowFareSearchRS->PricedItineraries->PricedItinerary;
  862.                             $xmlOrigin = (string) $pricedItinerary->AirItinerary->OriginDestinationOptions->OriginDestinationOption->FlightSegment->DepartureAirport['LocationCode'];
  863.                             $xmlDestination = (string) $pricedItinerary->AirItinerary->OriginDestinationOptions->OriginDestinationOption->FlightSegment->ArrivalAirport['LocationCode'];
  864.                             $xmlDate = (string) $pricedItinerary->AirItinerary->OriginDestinationOptions->OriginDestinationOption->FlightSegment['DepartureDateTime'];
  865.                             $cities = $em->getRepository(\Aviatur\GeneralBundle\Entity\City::class)->findByIatacode([$xmlOrigin, $xmlDestination]);
  866.                             if ((2 == sizeof($cities)) && (1 == sizeof($pricedItinerary->AirItinerary->OriginDestinationOptions->OriginDestinationOption))) {
  867.                                 $isNational = true;
  868.                                 $specialDiscountWithIva = false;
  869.                                 $noIvaCities = ['PVA', 'ADZ'];
  870.                                 foreach ($cities as $city) {
  871.                                     if ('CO' != $city->getCountry()->getIatacode()) {
  872.                                         $isNational = false;
  873.                                     }
  874.                                     if ((($city->getIatacode() == $xmlOrigin)) && (!in_array($xmlOrigin, $noIvaCities)) && (!in_array($xmlDestination, $noIvaCities))) {
  875.                                         $specialDiscountWithIva = true;
  876.                                     }
  877.                                 }
  878.                                 $originCity = $em->getRepository(\Aviatur\GeneralBundle\Entity\City::class)->findByIatacode([$xmlOrigin]);
  879.                                 $originCountry = $originCity[0]->getCountry()->getIatacode();
  880.                                 $specialDiscountHelicopter = $em->getRepository(\Aviatur\HelicopterBundle\Entity\SpecialDiscount::class)->findWithCities($xmlOrigin, $xmlDestination, $xmlDate, $agency);
  881.                                 if (null != $specialDiscountHelicopter) {
  882.                                     if (((1 == $specialDiscountHelicopter[0]->getHelicoptertype()) && ('CO' == $originCountry)) || ((null == $specialDiscountHelicopter[0]->getHelicoptertype())) && ($isNational)) {
  883.                                         $response = $this->specialDiscount($response, $specialDiscountHelicopter, $isNational, $specialDiscountWithIva);
  884.                                     }
  885.                                 }
  886.                             }
  887.                             $session->set($transactionId.'[helicopter][detail'.$key.']', $response->asXML());
  888.                             $providerIdArray = explode('ProviderId=', (string) $pricedItinerary->Notes);
  889.                             $providerIdArray = explode(';', $providerIdArray[1]);
  890.                             $providerSegment = $providerIdArray[0];
  891.                             foreach ($pricedItinerary->AirItinerary->OriginDestinationOptions->OriginDestinationOption as $originDestination) {
  892.                                 $arrivalEscala = null;
  893.                                 $totalDuration = 0;
  894.                                 foreach ($originDestination->FlightSegment as $flightSegment) {
  895.                                     $comments = (array) $flightSegment->Comment;
  896.                                     if (null != $arrivalEscala) {
  897.                                         $totalDuration += (int) abs(strtotime($flightSegment['DepartureDateTime']) - strtotime($arrivalEscala)) / 60;
  898.                                     }
  899.                                     if (9 != $providerSegment) {
  900.                                         $totalDuration += (int) substr($comments[12], strpos($comments[12], ':') + 2, 100);
  901.                                     } else {
  902.                                         $totalDuration = (string) $this->get('generate_helicopter_resume_email')->convertToHoursMins(substr($comments[14], strpos($comments[14], ':') + 2, 100));
  903.                                     }
  904.                                     $arrivalEscala = $flightSegment['ArrivalDateTime'];
  905.                                 }
  906.                                 if (is_int($totalDuration)) {
  907.                                     $totalDuration = (string) $this->get('generate_helicopter_resume_email')->convertToHoursMins($totalDuration);
  908.                                 }
  909.                                 $originDestination['totalDuration'] = $totalDuration;
  910.                             }
  911.                             ${'originDestinationSegment'.($key + 1)} = str_replace(['<OriginDestinationOptions>', '</OriginDestinationOptions>', 'RefNumber="0"'], ['', '', 'RefNumber="'.$key.'"'], $pricedItinerary->AirItinerary->OriginDestinationOptions->asXml());
  912.                             $baseFareCombination += (int) $pricedItinerary->AirItineraryPricingInfo->ItinTotalFare->BaseFare['Amount'];
  913.                             $equivFareCombination += (int) $pricedItinerary->AirItineraryPricingInfo->ItinTotalFare->EquivFare['Amount'];
  914.                             $taxesCombination += (int) $pricedItinerary->AirItineraryPricingInfo->ItinTotalFare->Taxes['Amount'];
  915.                             $totalFareCombination += (int) $pricedItinerary->AirItineraryPricingInfo->ItinTotalFare->TotalFare['Amount'];
  916.                             $notesInfoCombination .= (string) $pricedItinerary->Notes;
  917.                             if ($key > 0) {
  918.                                 $i = 0;
  919.                                 foreach ($pricedItinerary->AirItineraryPricingInfo->PTC_FareBreakdowns->PTC_FareBreakdown as $fareBreakDown) {
  920.                                     $ptcFareBreakdownCombination->PTC_FareBreakdown[$i]->PassengerFare->BaseFare['Amount'] += (int) $fareBreakDown->PassengerFare->BaseFare['Amount'];
  921.                                     $ptcFareBreakdownCombination->PTC_FareBreakdown[$i]->PassengerFare->EquivFare['Amount'] += (int) $fareBreakDown->PassengerFare->EquivFare['Amount'];
  922.                                     $ptcFareBreakdownCombination->PTC_FareBreakdown[$i]->PassengerFare->Taxes['Amount'] += (int) $fareBreakDown->PassengerFare->Taxes['Amount'];
  923.                                     $ptcFareBreakdownCombination->PTC_FareBreakdown[$i]->PassengerFare->TotalFare['Amount'] += (int) $fareBreakDown->PassengerFare->TotalFare['Amount'];
  924.                                     ++$i;
  925.                                 }
  926.                             }
  927.                             $ticketingVendorCombination .= $pricedItinerary->TicketingInfo->TicketingVendor->asXml();
  928.                         }
  929.                         $xmlCombinationTemplate = $helicopterModel->getXmlCombinations();
  930.                         $searches = [
  931.                             '{OriginDestinationOptionSegment1}',
  932.                             '{OriginDestinationOptionSegment2}',
  933.                             '{QuoteID}',
  934.                             '{BaseFare}',
  935.                             '{EquivFare}',
  936.                             '{Taxes}',
  937.                             '{TotalFare}',
  938.                             '{PTC_FareBreakdowns}',
  939.                             '{Notes}',
  940.                             '{TicketingVendor}',
  941.                         ];
  942.                         $replaces = [
  943.                             $originDestinationSegment1,
  944.                             $originDestinationSegment2,
  945.                             '',
  946.                             $baseFareCombination,
  947.                             $equivFareCombination,
  948.                             $taxesCombination,
  949.                             $totalFareCombination,
  950.                             $ptcFareBreakdownCombination->asXml(),
  951.                             $notesInfoCombination,
  952.                             $ticketingVendorCombination,
  953.                         ];
  954.                         $xmlCombination = str_replace($searches, $replaces, $xmlCombinationTemplate);
  955.                         unset($response->Message->OTA_AirLowFareSearchRS->PricedItineraries->PricedItinerary);
  956.                         $response = \simplexml_load_string(str_replace('<PricedItineraries>', '<PricedItineraries>'.$xmlCombination, $response->asXml()));
  957.                     } else {
  958.                         $provider = $em->getRepository(\Aviatur\MpaBundle\Entity\Provider::class)->findOneByProvideridentifier($request->get('helicopterProviderID'));
  959.                         $session->set($transactionId.'[helicopter][provider]', $provider->getProvideridentifier());
  960.                         ksort($RPHArray);
  961.                         $RPH = implode(' ', $RPHArray);
  962.                         $variable = [
  963.                             'ProviderId' => $provider->getProvideridentifier(),
  964.                             'correlationID' => $correlationID,
  965.                             'pricedID' => $pricedID,
  966.                             'RPH' => $RPH,
  967.                             'timeStamp' => date('c'),
  968.                         ];
  969.                         $helicopterModel = new HelicopterModel();
  970.                         $xmlRequest = $helicopterModel->getXmlDetail();
  971.                         $response = $aviaturWebService->callWebServiceAmadeus('SERVICIO_MPT', 'AirDetail', 'dummy|http://www.aviatur.com.co/dummy/', $xmlRequest, $variable, false, $transactionId);
  972.                         if (isset($response['error']) || ('error' == $response)) {
  973.                             $referer = $router->match(parse_url($server->get('HTTP_REFERER'), PHP_URL_PATH));
  974.                             if (isset($referer['_controller']) && (false !== strpos($referer['_controller'], 'availabilityAction'))) {
  975.                                 $response['error'] ??= 'Error en la respuesta de nuestro proveedor de servicios, inténtalo nuevamente';
  977.                                 return $this->redirect($aviaturErrorHandler->errorRedirect($server->get('HTTP_REFERER'), '', $response['error']));
  978.                             } else {
  979.                                 $response['error'] ??= 'Error en la respuesta de nuestro proveedor de servicios, inténtalo nuevamente';
  981.                                 return $this->redirect($aviaturErrorHandler->errorRedirect($returnUrl, '', $response['error']));
  982.                             }
  983.                         }
  984.                         $pricedItinerary = $response->Message->OTA_AirLowFareSearchRS->PricedItineraries->PricedItinerary;
  985.                         $xmlOrigin = (string) $pricedItinerary->AirItinerary->OriginDestinationOptions->OriginDestinationOption->FlightSegment->DepartureAirport['LocationCode'];
  986.                         $xmlDestination = (string) $pricedItinerary->AirItinerary->OriginDestinationOptions->OriginDestinationOption->FlightSegment->ArrivalAirport['LocationCode'];
  987.                         $xmlDate = (string) $pricedItinerary->AirItinerary->OriginDestinationOptions->OriginDestinationOption->FlightSegment['DepartureDateTime'];
  988.                         $cities = $em->getRepository(\Aviatur\GeneralBundle\Entity\City::class)->findByIatacode([$xmlOrigin, $xmlDestination]);
  989.                         if ((2 == sizeof($cities)) && (1 == sizeof($pricedItinerary->AirItinerary->OriginDestinationOptions->OriginDestinationOption))) {
  990.                             $isNational = true;
  991.                             $specialDiscountWithIva = false;
  992.                             $noIvaCities = ['PVA', 'ADZ'];
  993.                             foreach ($cities as $city) {
  994.                                 if ('CO' != $city->getCountry()->getIatacode()) {
  995.                                     $isNational = false;
  996.                                 }
  997.                                 if ((($city->getIatacode() == $xmlOrigin)) && (!in_array($xmlOrigin, $noIvaCities)) && (!in_array($xmlDestination, $noIvaCities))) {
  998.                                     $specialDiscountWithIva = true;
  999.                                 }
  1000.                             }
  1001.                             $originCity = $em->getRepository(\Aviatur\GeneralBundle\Entity\City::class)->findByIatacode([$xmlOrigin]);
  1002.                             $originCountry = $originCity[0]->getCountry()->getIatacode();
  1003.                             $specialDiscountHelicopter = $em->getRepository(\Aviatur\HelicopterBundle\Entity\SpecialDiscount::class)->findWithCities($xmlOrigin, $xmlDestination, $xmlDate, $agency);
  1004.                             if (null != $specialDiscountHelicopter) {
  1005.                                 if (((1 == $specialDiscountHelicopter[0]->getHelicoptertype()) && ('CO' == $originCountry)) || ((null == $specialDiscountHelicopter[0]->getHelicoptertype())) && ($isNational)) {
  1006.                                     $response = $this->specialDiscount($response, $specialDiscountHelicopter, $isNational, $specialDiscountWithIva);
  1007.                                 }
  1008.                             }
  1009.                         }
  1010.                     }
  1011.                 }
  1012.                 if (isset($response->Message->OTA_AirLowFareSearchRS->PricedItineraries->PricedItinerary->AirItineraryPricingInfo->ItinTotalFare->BaseFare['Amount'])) {
  1013.                     if ($reloaded) {
  1014.                         $userHelicopters = 0;
  1015.                         $destinationsArray = [];
  1016.                         $shortStopOver = false;
  1017.                         foreach ($response->Message->OTA_AirLowFareSearchRS->PricedItineraries->PricedItinerary->AirItinerary->OriginDestinationOptions->OriginDestinationOption as $originDestination) {
  1018.                             foreach ($originDestination->FlightSegment as $flightSegment) {
  1019.                                 $origin[] = (string) $flightSegment->DepartureAirport['LocationCode'];
  1020.                                 $destination[] = (string) $flightSegment->ArrivalAirport['LocationCode'];
  1021.                                 $destinationsArray[$userHelicopters]['DateTime'] = substr((string) $flightSegment['DepartureDateTime'], 0, 10);
  1022.                                 if (((int) $flightSegment['WaitingTime'] < 120) && ((int) $flightSegment['WaitingTime'] > 0)) {
  1023.                                     $shortStopOver = true;
  1024.                                 }
  1025.                             }
  1026.                             $firstHelicopter = $originDestination->FlightSegment[0];
  1027.                             $lastHelicopter = $originDestination->FlightSegment[sizeof($originDestination->FlightSegment) - 1];
  1028.                             $destinationsArray[$userHelicopters]['OriginCityCode'] = (string) $originDestination['OriginCityCode'];
  1029.                             $destinationsArray[$userHelicopters]['DestinationCityCode'] = (string) $originDestination['DestinationCityCode'];
  1030.                             $destinationsArray[$userHelicopters]['OriginCityName'] = (string) $originDestination['OriginCityName'];
  1031.                             $destinationsArray[$userHelicopters]['DestinationCityName'] = (string) $originDestination['DestinationCityName'];
  1032.                             ++$userHelicopters;
  1033.                         }
  1034.                     } else {
  1035.                         $baseAmount = (string) $response->Message->OTA_AirLowFareSearchRS->PricedItineraries->PricedItinerary->AirItineraryPricingInfo->ItinTotalFare->BaseFare['Amount'];
  1036.                         $helicopters = 0;
  1037.                         $userHelicopters = 0;
  1038.                         $description = 'Helicopteros - '.(string) $response->ProviderResults->ProviderResult['Provider'].' - ';
  1039.                         $destinationsArray = [];
  1040.                         $shortStopOver = false;
  1041.                         $providerIdArray = explode('ProviderId=', (string) $response->Message->OTA_AirLowFareSearchRS->PricedItineraries->PricedItinerary->Notes);
  1042.                         $providerIdArray = explode(';', $providerIdArray[1]);
  1043.                         $providerSegment = $providerIdArray[0];
  1044.                         foreach ($response->Message->OTA_AirLowFareSearchRS->PricedItineraries->PricedItinerary->AirItinerary->OriginDestinationOptions->OriginDestinationOption as $originDestination) {
  1045.                             if (!isset($originDestination['totalDuration'])) {
  1046.                                 $arrivalEscala = null;
  1047.                                 $totalDuration = 0;
  1048.                                 foreach ($originDestination->FlightSegment as $flightSegment) {
  1049.                                     $comments = (array) $flightSegment->Comment;
  1050.                                     if (null != $arrivalEscala) {
  1051.                                         $totalDuration += (int) abs(strtotime($flightSegment['DepartureDateTime']) - strtotime($arrivalEscala)) / 60;
  1052.                                     }
  1053.                                     if (9 != $providerSegment) {
  1054.                                         $totalDuration += (int) substr($comments[12], strpos($comments[12], ':') + 2, 100);
  1055.                                     } else {
  1056.                                         $totalDuration = (string) $generateFlightResumeEmail->convertToHoursMins(substr($comments[14], strpos($comments[14], ':') + 2, 100));
  1057.                                     }
  1058.                                     $arrivalEscala = $flightSegment['ArrivalDateTime'];
  1059.                                 }
  1060.                                 if (is_int($totalDuration)) {
  1061.                                     $totalDuration = (string) $generateFlightResumeEmail->convertToHoursMins($totalDuration);
  1062.                                 }
  1063.                                 $originDestination['totalDuration'] = $totalDuration;
  1064.                             }
  1065.                             $flightSegmentNumber = 0;
  1066.                             $combinationDescription = '';
  1067.                             $origin[] = (string) $originDestination->FlightSegment[0]->DepartureAirport['LocationCode'];
  1068.                             $destination[] = (string) $originDestination->FlightSegment[sizeof($originDestination->FlightSegment) - 1]->ArrivalAirport['LocationCode'];
  1069.                             foreach ($originDestination->FlightSegment as $flightSegment) {
  1070.                                 $description .= substr((string) $flightSegment['DepartureDateTime'], 0, 10).'('.(string) $flightSegment->DepartureAirport['LocationCode'].' a '.(string) $flightSegment->ArrivalAirport['LocationCode'].') ';
  1071.                                 $combinationDescription .= substr((string) $flightSegment['DepartureDateTime'], 0, 10).'('.(string) $flightSegment->DepartureAirport['LocationCode'].' a '.(string) $flightSegment->ArrivalAirport['LocationCode'].') ';
  1072.                                 $comments = (array) $flightSegment->Comment;
  1073.                                 if (9 != $providerSegment) {
  1074.                                     $flightSegment->HelicopterLength = (string) $generateFlightResumeEmail->convertToHoursMins(substr($comments[12], strpos($comments[12], ':') + 2, 100));
  1075.                                 } else {
  1076.                                     $flightSegment->HelicopterLength = $generateFlightResumeEmail->convertToHoursMins(abs(strtotime($flightSegment['DepartureDateTime']) - strtotime($flightSegment['ArrivalDateTime'])) / 60);
  1077.                                 }
  1078.                                 $flightSegment->Comment[14] = (string) $flightSegment->HelicopterLength;
  1079.                                 if ($flightSegmentNumber > 0) {
  1080.                                     $previousFlightSegment = $originDestination->FlightSegment[$flightSegmentNumber - 1];
  1081.                                     $flightSegment['WaitingTime'] = abs(strtotime($flightSegment['DepartureDateTime']) - strtotime($previousFlightSegment['ArrivalDateTime'])) / 60;
  1082.                                     if ((int) $flightSegment['WaitingTime'] < 120) {
  1083.                                         $flightSegment['ShortStopOver'] = true;
  1084.                                         $shortStopOver = true;
  1085.                                     } else {
  1086.                                         $flightSegment['ShortStopOver'] = false;
  1087.                                     }
  1088.                                 } else {
  1089.                                     $flightSegment['WaitingTime'] = 0;
  1090.                                     $flightSegment['ShortStopOver'] = false;
  1091.                                 }
  1092.                                 ++$helicopters;
  1093.                                 ++$flightSegmentNumber;
  1094.                                 $destinationsArray[$userHelicopters]['DateTime'] = substr((string) $flightSegment['DepartureDateTime'], 0, 10);
  1095.                             }
  1096.                             if (isset($responses)) {
  1097.                                 $combinationResponse = \simplexml_load_string($session->get($transactionId.'[helicopter][detail'.$userHelicopters.']'));
  1098.                                 $combinationResponse->Message->OTA_AirLowFareSearchRS['Description'] = 'Helicopteros - '.(string) $combinationResponse->ProviderResults->ProviderResult['Provider'].' - '.$combinationDescription;
  1099.                                 $session->set($transactionId.'[helicopter][detail'.$userHelicopters.']', $combinationResponse->asXML());
  1100.                             }
  1101.                             $firstHelicopter = $originDestination->FlightSegment[0];
  1102.                             $lastHelicopter = $originDestination->FlightSegment[sizeof($originDestination->FlightSegment) - 1];
  1103.                             $originDestination['OriginCityCode'] = $firstHelicopter->DepartureAirport['LocationCode'];
  1104.                             $originDestination['DestinationCityCode'] = $lastHelicopter->ArrivalAirport['LocationCode'];
  1105.                             $originDestination['OriginCityName'] = $firstHelicopter->DepartureAirport['CodeContext'];
  1106.                             $originDestination['DestinationCityName'] = $lastHelicopter->ArrivalAirport['CodeContext'];
  1107.                             $destinationsArray[$userHelicopters]['OriginCityCode'] = (string) $originDestination['OriginCityCode'];
  1108.                             $destinationsArray[$userHelicopters]['DestinationCityCode'] = (string) $originDestination['DestinationCityCode'];
  1109.                             $destinationsArray[$userHelicopters]['OriginCityName'] = (string) $originDestination['OriginCityName'];
  1110.                             $destinationsArray[$userHelicopters]['DestinationCityName'] = (string) $originDestination['DestinationCityName'];
  1111.                             ++$userHelicopters;
  1112.                         }
  1113.                         $response->Message->OTA_AirLowFareSearchRS['Description'] = $description;
  1114.                         $conditionIsInternational = '';
  1115.                         $repositorySearchCities = $em->getRepository(\Aviatur\SearchBundle\Entity\SearchCities::class);
  1116.                         $repositorySearchAirports = $em->getRepository(\Aviatur\SearchBundle\Entity\SearchAirports::class);
  1117.                         $querySeachCities = $repositorySearchCities->createQueryBuilder('p')
  1118.                                 ->where('p.countrycode != :countrycode')
  1119.                                 ->setParameter('countrycode', 'CO');
  1120.                         $querySeachAirports = $repositorySearchAirports->createQueryBuilder('p')
  1121.                                 ->where('p.countrycode != :countrycode')
  1122.                                 ->setParameter('countrycode', 'CO');
  1123.                         $querySeachCitiesNNS = $repositorySearchCities->createQueryBuilder('p')
  1124.                                 ->where('p.countrycode = :countrycode')
  1125.                                 ->setParameter('countrycode', 'CO');
  1126.                         $querySeachAirportsNNS = $repositorySearchAirports->createQueryBuilder('p')
  1127.                                 ->where('p.countrycode = :countrycode')
  1128.                                 ->setParameter('countrycode', 'CO');
  1129.                         for ($i = 0; $i < $userHelicopters; ++$i) {
  1130.                             $conditionIsInternational .= ' p.iata = :origin'.$i.' or p.iata = :destination'.$i.' or';
  1131.                         }
  1132.                         $conditionIsInternational = \rtrim($conditionIsInternational, 'or');
  1133.                         $querySeachCities->andWhere($conditionIsInternational);
  1134.                         $querySeachAirports->andWhere($conditionIsInternational);
  1135.                         $querySeachCitiesNNS->andWhere($conditionIsInternational);
  1136.                         $querySeachAirportsNNS->andWhere($conditionIsInternational);
  1137.                         for ($i = 0; $i < $userHelicopters; ++$i) {
  1138.                             $querySeachCities->setParameter('origin'.$i, $origin[$i])
  1139.                                     ->setParameter('destination'.$i, $destination[$i]);
  1140.                             $querySeachAirports->setParameter('origin'.$i, $origin[$i])
  1141.                                     ->setParameter('destination'.$i, $destination[$i]);
  1142.                             $querySeachCitiesNNS->setParameter('origin'.$i, $origin[$i])
  1143.                                     ->setParameter('destination'.$i, $destination[$i]);
  1144.                             $querySeachAirportsNNS->setParameter('origin'.$i, $origin[$i])
  1145.                                     ->setParameter('destination'.$i, $destination[$i]);
  1146.                         }
  1147.                         $internationalCity = $querySeachCities->getQuery()->getResult();
  1148.                         $internationalAirport = $querySeachAirports->getQuery()->getResult();
  1149.                         $CityNNS = $querySeachCitiesNNS->getQuery()->getResult();
  1150.                         $AirportNNS = $querySeachAirportsNNS->getQuery()->getResult();
  1151.                         $isINNS = 0;
  1152.                         if (sizeof($internationalCity) or sizeof($internationalAirport)) {
  1153.                             ++$isINNS;
  1154.                         }
  1155.                         if (!sizeof($CityNNS) and !sizeof($AirportNNS)) {
  1156.                             ++$isINNS;
  1157.                         }
  1158.                         $session->set($transactionId.'[isINNS]', $isINNS);
  1159.                         if ('' == $feeId) {
  1160.                             $administrativeCost = 0;
  1161.                             $passangerCount = 0;
  1162.                             foreach ($response->Message->OTA_AirLowFareSearchRS->PricedItineraries->PricedItinerary->AirItineraryPricingInfo->PTC_FareBreakdowns->PTC_FareBreakdown as $passangers) {
  1163.                                 if ('0' != (string) $passangers->PassengerFare->BaseFare['Amount']) {
  1164.                                     $passangerCount += (string) $passangers->PassengerTypeQuantity['Quantity'];
  1165.                                 }
  1166.                             }
  1167.                         }
  1168.                         if ($request->has('optionals')) {
  1169.                             $optionals = $request->get('optionals');
  1170.                             $i = 0;
  1171.                             foreach ($optionals as $optional) {
  1172.                                 $optionalInfo = explode('-', $optional);
  1173.                                 $response->Message->OTA_AirLowFareSearchRS->PricedItineraries->PricedItinerary->AirItineraryPricingInfo->ItinTotalFare->TotalFare['Amount'] += $optionalInfo[0];
  1174.                                 $response->Message->OTA_AirLowFareSearchRS->PricedItineraries->PricedItinerary->AirItineraryPricingInfo->ItinTotalFare->TPA_Extensions->Optionals[$i]['Amount'] = $optionalInfo[0];
  1175.                                 $response->Message->OTA_AirLowFareSearchRS->PricedItineraries->PricedItinerary->AirItineraryPricingInfo->ItinTotalFare->TPA_Extensions->Optionals[$i]['Name'] = $optionalInfo[1];
  1176.                                 ++$i;
  1177.                             }
  1178.                         }
  1179.                         $passangerTypes[1]['ADT'] = 0;
  1180.                         $passangerTypes[1]['CHD'] = 0;
  1181.                         $passangerTypes[1]['INF'] = 0;
  1182.                         foreach ($response->Message->OTA_AirLowFareSearchRS->PricedItineraries->PricedItinerary->AirItineraryPricingInfo->PTC_FareBreakdowns->PTC_FareBreakdown as $passangers) {
  1183.                             $passangerTypes[1][(string) $passangers->PassengerTypeQuantity['Code']] += (string) $passangers->PassengerTypeQuantity['Quantity'];
  1184.                             $passangers->PassengerFare->AdminCost['Amount'] = 0;
  1185.                             if ('0' != (string) $passangers->PassengerFare->BaseFare['Amount']) {
  1186.                                 $passangers->PassengerFare->AdminCost['Amount'] = $administrativeCost;
  1187.                             }
  1188.                             if ($request->has('optionals')) {
  1189.                                 $optionals = $request->get('optionals');
  1190.                                 $i = 0;
  1191.                                 foreach ($optionals as $optional) {
  1192.                                     $optionalInfo = explode('-', $optional);
  1193.                                     $passangers->PassengerFare->TPA_Extensions->Optionals[$i]['Amount'] = 0;
  1194.                                     $passangers->PassengerFare->TPA_Extensions->Optionals[$i]['Name'] = $optionalInfo[1];
  1195.                                     if ('0' != (string) $passangers->PassengerFare->BaseFare['Amount']) {
  1196.                                         $passangers->PassengerFare->TPA_Extensions->Optionals[$i]['Amount'] = $optionalInfo[0] / $passangerCount;
  1197.                                     }
  1198.                                     ++$i;
  1199.                                 }
  1200.                             }
  1201.                         }
  1202.                         $response->Message->OTA_AirLowFareSearchRS->PricedItineraries->
  1203.                                 PricedItinerary->AirItinerary->
  1204.                                 OriginDestinationOptions['AdtQuantity'] = $passangerTypes[1]['ADT'];
  1205.                         $response->Message->OTA_AirLowFareSearchRS->PricedItineraries->
  1206.                                 PricedItinerary->AirItinerary->
  1207.                                 OriginDestinationOptions['ChdQuantity'] = $passangerTypes[1]['CHD'];
  1208.                         $response->Message->OTA_AirLowFareSearchRS->PricedItineraries->
  1209.                                 PricedItinerary->AirItinerary->
  1210.                                 OriginDestinationOptions['InfQuantity'] = $passangerTypes[1]['INF'];
  1211.                         $administrativeCost = $administrativeCost * $passangerCount;
  1212.                         $response->Message->OTA_AirLowFareSearchRS->PricedItineraries->PricedItinerary->AirItineraryPricingInfo->ItinTotalFare->TPA_Extensions->AdministrativeCost['Amount'] = $administrativeCost;
  1213.                         $response->Message->OTA_AirLowFareSearchRS->PricedItineraries->PricedItinerary->AirItineraryPricingInfo->ItinTotalFare->TotalFare['Amount'] += $administrativeCost;
  1214.                         $response->Message->OTA_AirLowFareSearchRS['TransactionID'] = base64_encode($transactionId);
  1215.                         $operatingAirlineCode = $response->Message->OTA_AirLowFareSearchRS->PricedItineraries->PricedItinerary->TicketingInfo->TicketingVendor['Code'];
  1216.                         $response->Message->OTA_AirLowFareSearchRS->PricedItineraries->PricedItinerary->TicketingInfo->TicketingVendor['Description'] = $operatingAirlineCode;
  1217.                         $session->set($transactionId.'[helicopter][detail]', $response->asXML());
  1218.                         if (true === $request->has('referer')) {
  1219.                             if (true === $request->has('http_referer')) {
  1220.                                 $session->set($transactionId.'[availability_url]', $request->get('http_referer'));
  1221.                             } else {
  1222.                                 $session->set($transactionId.'[availability_url]', $this->generateUrl('homepage', [], true));
  1223.                             }
  1224.                             $session->set($transactionId.'[referer]', $request->get('referer'));
  1225.                         } else {
  1226.                             $session->set($transactionId.'[availability_url]', $server->get('HTTP_REFERER'));
  1227.                         }
  1228.                         $request->get('helicopterSessionID');
  1229.                     }
  1230.                     $twig_readonly = false;
  1231.                 } else {
  1232.                     $referer = $router->match(parse_url($server->get('HTTP_REFERER'), PHP_URL_PATH));
  1233.                     if (false !== strpos($referer['_controller'], 'availabilityAction')) {
  1234.                         $response['error'] ??= 'Error en la respuesta de nuestro proveedor de servicios, inténtalo nuevamente';
  1236.                         return $this->redirect($aviaturErrorHandler->errorRedirect($returnUrl, '', $response['error']));
  1237.                     } else {
  1238.                         $response['error'] ??= 'Error en la respuesta de nuestro proveedor de servicios, inténtalo nuevamente';
  1240.                         return $this->redirect($aviaturErrorHandler->errorRedirect($returnUrl, '', $response['error']));
  1241.                     }
  1242.                 }
  1243.             } else {
  1244.                 $response['error'] = 'La información ha sido alterada';
  1246.                 return $this->redirect($aviaturErrorHandler->errorRedirect($returnUrl, '', $response['error']));
  1247.             }
  1248.         }
  1249.         $passangerCount = 0;
  1250.         $passangerTypes[1]['ADT'] = 0;
  1251.         $passangerTypes[1]['CHD'] = 0;
  1252.         $passangerTypes[1]['INF'] = 0;
  1253.         foreach ($response->Message->OTA_AirLowFareSearchRS->PricedItineraries->PricedItinerary->AirItineraryPricingInfo->PTC_FareBreakdowns->PTC_FareBreakdown as $passangers) {
  1254.             $passangerTypes[1][(string) $passangers->PassengerTypeQuantity['Code']] += (string) $passangers->PassengerTypeQuantity['Quantity'];
  1255.             if ('0' != (string) $passangers->PassengerFare->BaseFare['Amount']) {
  1256.                 $passangerCount += (string) $passangers->PassengerTypeQuantity['Quantity'];
  1257.             }
  1258.         }
  1259.         $plantilla = $renderXslt->render($response->Message->OTA_AirLowFareSearchRS->asXML(), 'Helicopter', 'Detail');
  1260.         $documentType = $em->getRepository(\Aviatur\CustomerBundle\Entity\DocumentType::class)->findAll();
  1261.         $genderType = $em->getRepository(\Aviatur\CustomerBundle\Entity\Gender::class)->findAll();
  1263.         $repositoryDocumentType = $em->getRepository(\Aviatur\CustomerBundle\Entity\DocumentType::class);
  1264.         $queryDocumentType = $repositoryDocumentType
  1265.                 ->createQueryBuilder('p')
  1266.                 ->where('p.paymentcode != :paymentcode')
  1267.                 ->setParameter('paymentcode', '')
  1268.                 ->getQuery();
  1269.         $documentPaymentType = $queryDocumentType->getResult();
  1270.         $resumeInfo = [
  1271.             'passanger_count' => $passangerCount,
  1272.             'passanger_type_fares' => $response->Message->OTA_AirLowFareSearchRS->PricedItineraries->PricedItinerary->AirItineraryPricingInfo->PTC_FareBreakdowns,
  1273.             'admin_amount' => (int) $response->Message->OTA_AirLowFareSearchRS->PricedItineraries->PricedItinerary->AirItineraryPricingInfo->ItinTotalFare->TPA_Extensions->AdministrativeCost['Amount'],
  1274.             'base_amount' => (int) $response->Message->OTA_AirLowFareSearchRS->PricedItineraries->PricedItinerary->AirItineraryPricingInfo->ItinTotalFare->BaseFare['Amount'],
  1275.             'fares_amount' => (int) $response->Message->OTA_AirLowFareSearchRS->PricedItineraries->PricedItinerary->AirItineraryPricingInfo->ItinTotalFare->Taxes['Amount'],
  1276.             'total_amount' => (int) $response->Message->OTA_AirLowFareSearchRS->PricedItineraries->PricedItinerary->AirItineraryPricingInfo->ItinTotalFare->TotalFare['Amount'],
  1277.             'currency_code' => (string) $response->Message->OTA_AirLowFareSearchRS->PricedItineraries->PricedItinerary->AirItineraryPricingInfo->ItinTotalFare->TotalFare['CurrencyCode'],
  1278.         ];
  1280.         if (isset($response->Message->OTA_AirLowFareSearchRS->PricedItineraries->PricedItinerary->AirItineraryPricingInfo->ItinTotalFare->TPA_Extensions->Optionals)) {
  1281.             $optionals = $response->Message->OTA_AirLowFareSearchRS->PricedItineraries->PricedItinerary->AirItineraryPricingInfo->ItinTotalFare->TPA_Extensions->Optionals;
  1282.             $i = 0;
  1283.             $tempOptionals = [];
  1284.             foreach ($optionals as $optional) {
  1285.                 $tempOptionals[$i]['Amount'] = (string) $optional['Amount'];
  1286.                 $tempOptionals[$i]['Name'] = (string) $optional['Name'];
  1287.                 ++$i;
  1288.             }
  1289.             $resumeInfo['optionals'] = $tempOptionals;
  1290.         }
  1291.         $paymentMethodAgency = $em->getRepository(\Aviatur\GeneralBundle\Entity\PaymentMethodAgency::class)->findBy(['agency' => $agency, 'isactive' => 1]);
  1292.         $paymentOptions = [];
  1293.         foreach ($paymentMethodAgency as $payMethod) {
  1294.             $paymentCode = $payMethod->getPaymentMethod()->getCode();
  1295.             if (!in_array($paymentCode, $paymentOptions)) {
  1296.                 $paymentOptions[] = $paymentCode;
  1297.             }
  1298.         }
  1300.         $banks = [];
  1301.         if (in_array('pse', $paymentOptions)) {
  1302.             $banks = $em->getRepository(\Aviatur\PaymentBundle\Entity\PseBank::class)->findAll();
  1303.         }
  1305.         $cybersource = [];
  1306.         if (in_array('cybersource', $paymentOptions)) {
  1307.             $cybersource['merchant_id'] = $paymentMethodAgency[array_search('cybersource', $paymentOptions)]->getSitecode();
  1308.             $cybersource['org_id'] = $paymentMethodAgency[array_search('cybersource', $paymentOptions)]->getTrankey();
  1309.         }
  1310.         foreach ($paymentOptions as $key => $paymentOption) {
  1311.             if ('cybersource' == $paymentOption) {
  1312.                 unset($paymentOptions[$key]); // strip from other renderizable payment methods
  1313.             }
  1314.         }
  1316.         $conditions = $em->getRepository(\Aviatur\GeneralBundle\Entity\HistoricalInfo::class)->findMessageByAgencyOrNull($agency, 'reservation_conditions');
  1318.         if (isset($providers)) {
  1319.             foreach ($providers as $provider) {
  1320.                 $payment_type_form_name = $provider->getPaymentType()->getTwig();
  1321.             }
  1322.         } else {
  1323.             $payment_type_form_name = $provider->getPaymentType()->getTwig();
  1324.         }
  1325.         $notes = ucfirst(mb_strtolower(htmlentities((string) $response->Message->OTA_AirLowFareSearchRS->PricedItineraries->PricedItinerary->Notes)));
  1326.         $responseHelicopterDetail = [
  1327.             'twig_readonly' => $twig_readonly,
  1328.             'plantilla' => $plantilla,
  1329.             'services' => $passangerTypes,
  1330.             'payment_doc_type' => $documentPaymentType,
  1331.             'payment_type_form_name' => $payment_type_form_name,
  1332.             'doc_type' => $documentType,
  1333.             'gender' => $genderType,
  1334.             'additional' => base64_encode($transactionId.'/'.$session->get($transactionId.'[helicopter]['.$correlationIdSessionName.']').'/'.$session->get($transactionId.'[isINNS]')),
  1335.             'referer' => $session->get($transactionId.'[availability_url]'),
  1336.             'resume_info' => $resumeInfo,
  1337.             'destination_array' => $destinationsArray,
  1338.             'cards' => $em->getRepository(\Aviatur\GeneralBundle\Entity\Card::class)->findAll(),
  1339.             'paymentOptions' => $paymentOptions,
  1340.             'banks' => $banks,
  1341.             'cybersource' => $cybersource,
  1342.             'conditions' => $conditions,
  1343.             'airlineCondition' => $notes,
  1344.             'travelers' => $travelers ?? null,
  1345.             'passengers' => $passangerInfo ?? null,
  1346.             'billingData' => $billingData ?? null,
  1347.             'contactData' => $contactData ?? null,
  1348.             'baggageData' => $baggageData ?? null,
  1349.             'internationalHelicopter' => $session->get($transactionId.'[isINNS]'),
  1350.             'shortStopOver' => $shortStopOver,
  1351.         ];
  1353.         $route = $router->match(str_replace($fullRequest->getSchemeAndHttpHost(), '', $fullRequest->getUri()));
  1354.         $isMulti = false !== strpos($route['_route'], 'multi') ? true : false;
  1356.         if ($isMulti) {
  1357.             return $this->json($responseHelicopterDetail);
  1358.         }
  1359.         if (('error' == $responseHelicopterDetail) || (isset($responseHelicopterDetail['error']))) {
  1360.             $message = $responseHelicopterDetail['error'] ?? 'Ha ocurrido un error inesperado';
  1361.             $returnUrl = $twigFolder->pathWithLocale('aviatur_general_homepage');
  1362.             if (true === $request->has('referer') && true === $request->has('http_referer')) {
  1363.                 $returnUrl = $request->get('http_referer');
  1364.             }
  1365.             if (isset($responseHelicopterDetail['no_message']) && (true == $responseHelicopterDetail['no_message'])) {
  1366.                 return $this->redirect($aviaturErrorHandler->errorRedirectNoEmail($returnUrl, '', $message));
  1367.             } else {
  1368.                 return $this->redirect($aviaturErrorHandler->errorRedirect($returnUrl, '', $message));
  1369.             }
  1370.         } else {
  1371.             // NNS0 eg. Bogota->Medellin, NNS1 eg. Bogota->Miami, NNS2 eg. Miami->New York
  1372.             $agencyFolder = $twigFolder->twigFlux();
  1373.             $view = $twigFolder->twigExists('@AviaturTwig/'.$agencyFolder.'/Helicopter/Default/detail.html.twig');
  1374.             $response = $this->render($view, $responseHelicopterDetail);
  1375.             if ($session->has('generals[metasearch]')) {
  1376.                 $response->headers->setCookie(new Cookie('_referer[helicopter]', base64_encode($session->get('generals[metasearch]')), (time() + 3600 * 24 * 3), '/'));
  1377.             }
  1378.             if ($fullRequest->cookies->has('_referer')) {
  1379.                 $cookie = $fullRequest->cookies->get('_referer');
  1380.                 $session->set('generals[metasearch]', base64_decode($cookie['helicopter']));
  1381.             }
  1383.             return $response;
  1384.         }
  1385.     }
  1387.     public function detailInvalidAction(Request $request, AviaturErrorHandler $aviaturErrorHandler, TwigFolder $twigFolder, RouterInterface $router, SessionInterface $session, ParameterBagInterface $parameterBag)
  1388.     {
  1389.         $transactionIdSessionName = $parameterBag->get('transaction_id_session_name');
  1391.         $server = $request->server;
  1392.         if (true === $session->has($transactionIdSessionName)) {
  1393.             $transactionId = $session->get($transactionIdSessionName);
  1394.             $referer = $router->match(parse_url($server->get('HTTP_REFERER'), PHP_URL_PATH));
  1395.             if (true === $session->has($transactionId.'[availability_url]')) {
  1396.                 return $this->redirect($aviaturErrorHandler->errorRedirect($session->get($transactionId.'[availability_url]'), 'Página no accesible', 'No puedes acceder al detalle sin disponibilidad'));
  1397.             } elseif (false !== strpos($referer['_controller'], 'availabilityAction')) {
  1398.                 return $this->redirect($aviaturErrorHandler->errorRedirect($server->get('HTTP_REFERER'), '', 'Error en la respuesta de nuestro proveedor de servicios, inténtalo nuevamente'));
  1399.             } else {
  1400.                 return $this->redirect($aviaturErrorHandler->errorRedirect($twigFolder->pathWithLocale('aviatur_general_homepage'), 'Página no accesible', 'No puedes acceder al detalle sin disponibilidad'));
  1401.             }
  1402.         } else {
  1403.             return $this->redirect($aviaturErrorHandler->errorRedirect($twigFolder->pathWithLocale('aviatur_general_homepage'), 'Página no accesible', 'No puedes acceder al detalle sin disponibilidad'));
  1404.         }
  1405.     }
  1407.     public function detailUpdateSessionAction(Request $request, AviaturWebService $aviaturWebService, SessionInterface $session, ParameterBagInterface $parameterBag)
  1408.     {
  1409.         $correlationIdSessionName = $parameterBag->get('correlation_id_session_name');
  1411.         if ($request->isXmlHttpRequest()) {
  1412.             $invalidHour = 1000;
  1413.             $currentTime = (int) date('Gis');
  1414.             if ($currentTime > $invalidHour) {
  1415.                 $request = $request->request;
  1416.                 $selectionData = $request->get('SD');
  1417.                 $transactionId = base64_decode($selectionData['selection']);
  1418.                 $correlationIds = explode('||', $session->get($transactionId.'[helicopter]['.$correlationIdSessionName.']'));
  1419.                 $combination = false;
  1420.                 if (sizeof($correlationIds) > 1) {
  1421.                     $combination = true;
  1422.                 }
  1423.                 $key = 0;
  1424.                 foreach ($correlationIds as $correlationId) {
  1425.                     if ($combination) {
  1426.                         $providers = json_decode($session->get($transactionId.'[helicopter][provider]'));
  1427.                         $provider = $providers[$key];
  1428.                     } else {
  1429.                         $provider = $session->get($transactionId.'[helicopter][provider]');
  1430.                     }
  1431.                     $variable = [
  1432.                         'correlationId' => $correlationId,
  1433.                         'ProviderId' => $provider,
  1434.                     ];
  1435.                     $helicopterModel = new HelicopterModel();
  1436.                     $xmlRequest = $helicopterModel->getXmlExecute();
  1437.                     $response = $aviaturWebService->callWebServiceAmadeus('SERVICIO_MPT', 'AirCommandExecute', 'dummy|http://www.aviatur.com.co/dummy/', $xmlRequest, $variable, false);
  1438.                     ++$key;
  1439.                 }
  1441.                 return $this->json($response);
  1442.             } else {
  1443.                 return $this->json(['error' => 'day_change']);
  1444.             }
  1445.         } else {
  1446.             return $this->json(['error' => 'Acceso no autorizado']);
  1447.         }
  1448.     }
  1449. }