src/Aviatur/GeneralBundle/Controller/GeneralController.php line 26

Open in your IDE?
  1. <?php
  3. namespace Aviatur\GeneralBundle\Controller;
  5. use Aviatur\FlightBundle\Entity\AdminFeeWhitemark;
  6. use Aviatur\FlightBundle\Services\SearchFlightCookie;
  7. use Aviatur\FormBundle\Entity\Newsletter;
  8. use Aviatur\GeneralBundle\Entity\Alerts;
  9. use Aviatur\GeneralBundle\Entity\Whitemark;
  10. use Aviatur\GeneralBundle\Services\AviaturErrorHandler;
  11. use Aviatur\GeneralBundle\Services\AviaturPixeles;
  12. use Aviatur\GeneralBundle\Services\AviaturUpdatePromoProduct;
  13. use Aviatur\TwigBundle\Services\TwigFolder;
  14. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  15. use Symfony\Component\DependencyInjection\ParameterBag\ParameterBagInterface;
  16. use Symfony\Component\HttpFoundation\BinaryFileResponse;
  17. use Symfony\Component\HttpFoundation\File\Exception\FileException;
  18. use Symfony\Component\HttpFoundation\Request;
  19. use Symfony\Component\HttpFoundation\Response;
  20. use Symfony\Component\HttpFoundation\Session\SessionInterface;
  21. use Doctrine\Persistence\ManagerRegistry;
  22. use Aviatur\GeneralBundle\Services\AviaturLogSave;
  24. class GeneralController extends AbstractController
  25. {
  26.     public function indexAction(Request $request, ManagerRegistry $registry, SessionInterface $session, SearchFlightCookie $searchFlightCookie, AviaturUpdatePromoProduct $aviaturUpdatePromoProduct, TwigFolder $twigFolder, AviaturPixeles $aviaturPixeles)
  27.     {
  28.         $cookieLastSearch = $searchFlightCookie->searchFlightCookie();
  29.         $agencyId = $session->get('agencyId');
  30.         $em = $registry->getManager();
  31.         $agency = $em->getRepository(\Aviatur\AgencyBundle\Entity\Agency::class)->find($agencyId);
  32.         $refererWhitemark = $request->request->get('referer');
  33.         // Agregar link de redireccion para iniciar sesión en portal de aval
  34.         $link_portal_aval = $em->getRepository(\Aviatur\GeneralBundle\Entity\Parameter::class)->findOneByName('aviatur_aval_redirection');
  35.         $config_links_aval = json_decode($link_portal_aval->getValue());
  36.         $redirect_to_aval = !empty($link_portal_aval) ? $config_links_aval->Config->links->logo : '' ;
  37.         $login_aval = !empty($link_portal_aval) ? $config_links_aval->Config->links->login : '' ;
  38.         $session->set('link_portal_aval', $redirect_to_aval);
  39.         $session->set('login_portal_aval', $login_aval);
  41.         $promoType = 'main';
  42.         $promoTypeBanners = 'main-banners';
  43.         $promoTypeEscapadas = 'main-escapadas';
  44.         $promoTypeExperiencias = 'main-experiencias';
  45.         $promoTypeRecommendations = 'main-recommendations';
  46.         $blackFridayDate = $em->createQuery('SELECT a,b FROM AviaturEditionBundle:HomePromoTime a  JOIN a.homePromoList b WHERE b.type = :promo');
  47.         $blackFridayDateInfo = $blackFridayDate->setParameter('promo', 'black-friday-col')->getResult();
  48.         $activeBlackFriday = false;
  49.         if ((is_countable($blackFridayDateInfo) ? count($blackFridayDateInfo) : 0) > 0) {
  50.             $date_start = strtotime(date($blackFridayDateInfo[0]->getStartDate()->format('Y-m-d H:i:s')));
  51.             $date_end = strtotime(date($blackFridayDateInfo[0]->getEndDate()->format('Y-m-d H:i:s')));
  52.             $date_now = strtotime(date('Y-m-d H:i:s'));
  53.             if ($date_start <= $date_now && $date_end >= $date_now) {
  54.                 $activeBlackFriday = true;
  55.             }
  56.         }
  57.         $active_background_home = ['active' => false];
  58.         $parametername = 'aviatur_background_home_image';
  59.         $background_home_query = $em->getRepository(\Aviatur\GeneralBundle\Entity\Parameter::class)->findOneByName($parametername);
  60.         if ((is_countable($background_home_query) ? count($background_home_query) : 0) > 0) {
  61.             $backgroundinfo = json_decode($background_home_query->getDescription());
  62.             $arrayinfo = [];
  63.             foreach ($backgroundinfo as $key => $info) {
  64.                 if ((int) $key == (int) $agencyId) {
  65.                     foreach ($info as $i) {
  66.                         if ('' == $i->date_end) {
  67.                             if (strtotime(date($i->date_start)) <= $date_now && 'true' == $i->active) {
  68.                                 $arrayinfo = $i;
  69.                             }
  70.                         } else {
  71.                             if (strtotime(date($i->date_start)) <= $date_now && strtotime(date($i->date_end)) >= $date_now && 'true' == $i->active) {
  72.                                 $active_background_home = ['active' => true, 'name' => $i->img, 'type' => $i->type];
  73.                             }
  74.                         }
  75.                     }
  76.                 }
  77.             }
  78.             if (false == $active_background_home['active']) {
  79.                 if ((is_countable($arrayinfo) ? count($arrayinfo) : 0) > 0) {
  80.                     $active_background_home = ['active' => true, 'name' => $arrayinfo->img, 'type' => $arrayinfo->type];
  81.                 }
  82.             }
  83.         }
  85.         $promoSearchAgency = $aviaturUpdatePromoProduct->promoSearchAgency($agencyId);
  87.         if (true === $session->has('whitemark')) {
  88.             $promoType = $promoType.'_'.$session->get('whitemark');
  89.         }
  91.         $info = $this->getOS($request);
  93.         $em = $registry->getManager();
  95.         $parameter = $em->getRepository(\Aviatur\GeneralBundle\Entity\Parameter::class)->findOneBy(['name' => 'agency_excluded_list_promotional_cards']);
  97.         if ($parameter) {
  98.             // Decodificar el JSON a un array PHP
  99.             $agenciesExcluded = json_decode($parameter->getValue(), true);
  101.             // Verificar si la decodificación fue exitosa
  102.             if (!is_array($agenciesExcluded)) {
  103.                 // Manejar el error si la decodificación no es un array
  104.                 throw new \Exception('La lista de agencias excluidas no es válida.');
  105.             }
  106.         } else {
  107.             // Si no existe el parámetro, usar la lista estática como fallback
  108.             $agenciesExcluded = [
  109.                 'Aviatur S.A.S.', 'Aviatur S.A.S. Metasearch', 'QA Aval', 'Aval', 'Aviacaribbean', 'Aviatur - WorldPay', 'Aviatur Carnaval BAQ MB', 'Aviatur Colombia', 'Aviatur Colombia EN',
  110.                 'Aviatur Colombia ES', 'Aviatur Ecoturismo', 'Aviatur Kioskos', 'Aviatur Metasearch Mexico', 'Aviatur Mexico', 'Aviatur Mexico QA', 'Aviatur Mobile', 'Aviatur PinBus',
  111.                 'Aviatur - Pruebas', 'BabyMarket', 'Buceo Colombia', 'Cielos Abiertos', 'Corona Aviatur', 'Directo a la Playa', 'Experiencias Jet-Set', 'Great Vibes', 'Landing visa',
  112.                 'Lufthansa City Center', 'Megatours', 'Octopus Agents', 'Octopus Marcas Blancas', 'Octopus Travel QA', 'Panturismo Marcas Blancas', 'Parque Tayrona', 'Representaciones Pasabordo WM',
  113.                 'Rokatur Marcas Blancas', 'RollingTrips', 'Star World', 'Swissandina', 'Takentours', 'TerraNet Marcas Blancas', 'Turiscol Ltda.', 'Aviatur S.A.', 'Union de Representaciones',
  114.                 'Union de Representaciones - Whitemark', 'Virtuoso', 'Claro', 'WeCare', 'Octopus Travel Ltda.', 'Aviatur Site', 'Aviatur S.A.S. - BBVA', 'Aviatur Welcome Beds', 'JTR Aviatur', 'QA.pruebaAviatur S.A.S.',
  115.             ];
  116.         }
  118.         $agencyPromoId = 172;
  119.         $validationAgencyFolder = false;
  121.         foreach ($agenciesExcluded as $agencyExcluded) {
  122.             if ($agencyExcluded === $agency->getName()) {
  123.                 $agencyPromoId = $agency->getId();
  124.                 $validationAgencyFolder = true;
  125.             }
  126.         }
  127.         $homePromoList = $em->getRepository(\Aviatur\EditionBundle\Entity\HomePromoList::class)->findOneBy(['type' => $promoType, 'agency' => $agencyPromoId]);
  128.         if (null != $homePromoList) {
  129.             $homePromoTitle = $homePromoList->getTitle();
  130.             $homePromoSubtitle = $homePromoList->getSubtitle();
  131.             $homePromos = $em->getRepository(\Aviatur\EditionBundle\Entity\HomePromo::class)->findByHomePromoList($homePromoList, ['date' => 'DESC']);
  132.         } else {
  133.             $homePromoTitle = null;
  134.             $homePromoSubtitle = null;
  135.             $homePromos = [];
  136.         }
  137.         if (null != $homePromos) {
  138.             $linkSwitchPromos = [];
  139.             foreach ($homePromos as $homePromo) {
  140.                 if ('banner' == $homePromo->getSize() && $homePromo->getSwitch()) {
  141.                     $linkSwitchPromos[] = $homePromo;
  142.                 }
  143.             }
  144.         } else {
  145.             $linkSwitchPromos = [];
  146.         }
  148.         $homePromoListBanners = $em->getRepository(\Aviatur\EditionBundle\Entity\HomePromoList::class)->findOneBy(['type' => $promoTypeBanners, 'agency' => $agencyPromoId]);
  149.         if (null != $homePromoListBanners) {
  150.             $homePromoBannersTitle = $homePromoListBanners->getTitle();
  151.             $homePromoBannersSubtitle = $homePromoListBanners->getSubtitle();
  152.             $homePromosBanners = $em->getRepository(\Aviatur\EditionBundle\Entity\HomePromo::class)->findByHomePromoList($homePromoListBanners, ['date' => 'DESC']);
  153.         } else {
  154.             $homePromoBannersTitle = null;
  155.             $homePromoBannersSubtitle = null;
  156.             $homePromosBanners = [];
  157.         }
  159.         $homePromoListEscapadas = $em->getRepository(\Aviatur\EditionBundle\Entity\HomePromoList::class)->findOneBy(['type' => $promoTypeEscapadas, 'agency' => $agencyPromoId]);
  160.         if (null != $homePromoListEscapadas) {
  161.             $homePromoEscapadasTitle = $homePromoListEscapadas->getTitle();
  162.             $homePromoEscapadasSubtitle = $homePromoListEscapadas->getSubtitle();
  163.             $homePromosEscapadas = $em->getRepository(\Aviatur\EditionBundle\Entity\HomePromo::class)->findByHomePromoList($homePromoListEscapadas, ['date' => 'DESC']);
  164.         } else {
  165.             $homePromoEscapadasTitle = null;
  166.             $homePromoEscapadasSubtitle = null;
  167.             $homePromosEscapadas = [];
  168.         }
  170.         $homePromoListExperiencias = $em->getRepository(\Aviatur\EditionBundle\Entity\HomePromoList::class)->findOneBy(['type' => $promoTypeExperiencias, 'agency' => $agencyPromoId]);
  171.         if (null != $homePromoListExperiencias) {
  172.             $homePromoExperienciasTitle = $homePromoListExperiencias->getTitle();
  173.             $homePromoExperienciasSubtitle = $homePromoListExperiencias->getSubtitle();
  174.             $homePromosExperiencias = $em->getRepository(\Aviatur\EditionBundle\Entity\HomePromo::class)->findByHomePromoList($homePromoListExperiencias, ['date' => 'DESC']);
  175.         } else {
  176.             $homePromoExperienciasTitle = null;
  177.             $homePromoExperienciasSubtitle = null;
  178.             $homePromosExperiencias = [];
  179.         }
  181.         $homePromoListRecommendations = $em->getRepository(\Aviatur\EditionBundle\Entity\HomePromoList::class)->findOneBy(['type' => $promoTypeRecommendations, 'agency' => $agencyPromoId]);
  182.         if (null != $homePromoListRecommendations) {
  183.             $homePromoRecommendationsTitle = $homePromoListRecommendations->getTitle();
  184.             $homePromoRecommendationsSubtitle = $homePromoListRecommendations->getSubtitle();
  185.             $homePromosRecommendations = $em->getRepository(\Aviatur\EditionBundle\Entity\HomePromo::class)->findByHomePromoList($homePromoListRecommendations, ['date' => 'DESC']);
  186.         } else {
  187.             $homePromoRecommendationsTitle = null;
  188.             $homePromoRecommendationsSubtitle = null;
  189.             $homePromosRecommendations = [];
  190.         }
  192.         $configsFlightCalendarAgency = $em->getRepository(\Aviatur\FlightBundle\Entity\ConfigFlightCalendarAgency::class)->findProviderForFlightsWithAgency($agency);
  193.         $providerInfo = true;
  194.         $providers = [];
  195.         foreach ($configsFlightCalendarAgency as $configFlightCalendarAgency) {
  196.             $provider = $configFlightCalendarAgency->getProvider()->getProvideridentifier();
  197.             if (!in_array($provider, $providers)) {
  198.                 $providers[] = $provider;
  199.             }
  200.         }
  202.         $providerIds = implode(';', $providers);
  204.         if (empty($providerIds)) {
  205.             $providerInfo = false;
  206.         }
  208.         $newsletter = new Newsletter();
  209.         $newsletterForm = $this->createForm(\Aviatur\FormBundle\Form\NewsletterAsyncType::class, $newsletter);
  211.         $isFront = $session->has('operatorId');
  212.         $pixelInfo = [];
  213.         //        if (!$isFront) {
  214.         //            $pixel['dataxpand'] = true;
  215.         //            $pixelInfo = $aviaturPixeles->verifyPixeles($pixel, "home", "isActive", $agency->getAssetsFolder(), false);
  216.         //        }
  218.         $parameters = json_decode($session->get($request->getHost().'[parameters]'));
  220.         if (isset($parameters->switch_redirect) && $parameters->switch_redirect == 1 && 5 == $agencyId) {
  221.             header('Location: https://vuelos.aviatur.com/');
  222.             exit;
  223.         }
  224.         $currentDate = date('Y-m-d');
  225.         $endDateCensocud = $parameters->date_end_cencosud;
  226.         $activeCheckCencosud = (strtotime($endDateCensocud) >= strtotime($currentDate));
  227.         $bannerHome = $parameters->aviatur_banner_home ?? false;
  228.         $safeUrlWhiteMark = $session->get('homeWhitemark');
  229.         $agency = $em->getRepository(\Aviatur\AgencyBundle\Entity\Agency::class)->find($session->get('agencyId'));
  230.         if ($agency->getDomainsecure() == $agency->getDomain() && '443' != $agency->getCustomport()) {
  231.             $safeUrl = 'https://'.$agency->getDomain();
  232.         } else {
  233.             $safeUrl = 'https://'.$agency->getDomainsecure();
  234.         }
  235.         $agencyFolder = $twigFolder->twigFlux();
  236.         $socialmedia = json_decode($agency->getSocialmedia(), true);
  238.         if ($socialmedia) {
  239.             $facebook = $socialmedia['Facebook'] ?? null;
  240.             $instagram = $socialmedia['Instagram'] ?? null;
  241.             $linkedin = $socialmedia['Linkedin'] ?? null;
  242.         }
  243.         $parameter = $em->getRepository(\Aviatur\GeneralBundle\Entity\Parameter::class)->findOneBy(['name' => 'aviatur_search_explore', 'value' => 1]);
  244.         $validateExplore = null === $parameter ? 0 : 1;
  245.         $props = [
  246.             'validateExplore' => $validateExplore,
  247.             'promoSearchAgency' => $promoSearchAgency,
  248.             'blackFriday' => $activeBlackFriday,
  249.             'background_home' => $active_background_home,
  250.             'banner_home' => $bannerHome,
  251.             'pixel_info' => $pixelInfo,
  252.             'providerInfo' => $providerInfo,
  253.             'browser' => $info,
  254.             'agencyId' => $agencyId,
  255.             'cookieLastSearch' => $cookieLastSearch,
  256.             'homePromos' => $homePromos,
  257.             'titlePromo' => $homePromoTitle,
  258.             'subtitlePromo' => $homePromoSubtitle,
  259.             'promoType' => $promoType,
  260.             'homePromosRecommendations' => $homePromosRecommendations,
  261.             'titlePromoRecommendations' => $homePromoRecommendationsTitle,
  262.             'subtitlePromoRecommendations' => $homePromoRecommendationsSubtitle,
  263.             'promoTypeRecommendations' => $promoTypeRecommendations,
  264.             'homePromosBanner' => $homePromosBanners,
  265.             'titlePromoBanner' => $homePromoBannersTitle,
  266.             'subtitlePromoBanner' => $homePromoBannersSubtitle,
  267.             'promoTypeBanner' => $promoTypeBanners,
  268.             'homePromosEscapadas' => $homePromosEscapadas,
  269.             'titlePromoEscapadas' => $homePromoEscapadasTitle,
  270.             'subtitlePromoEscapadas' => $homePromoEscapadasSubtitle,
  271.             'promoTypeEscapadas' => $promoTypeEscapadas,
  272.             'homePromosExperiencias' => $homePromosExperiencias,
  273.             'titlePromoExperiencias' => $homePromoExperienciasTitle,
  274.             'subtitlePromoExperiencias' => $homePromoExperienciasSubtitle,
  275.             'promoTypeExperiencias' => $promoTypeExperiencias,
  276.             'newsletter_form' => $newsletterForm->createView(),
  277.             'activeCheckCencosud' => $activeCheckCencosud,
  278.             'safeUrl' => $safeUrl,
  279.             'validationAgencyFolder' => $validationAgencyFolder,
  280.             'linkSwitchPromos' => $linkSwitchPromos,
  281.             'socialmedia' => $socialmedia,
  282.             'safeUrlWhiteMark' => $safeUrlWhiteMark
  283.         ];
  285.             $response = $this->render($twigFolder->twigExists('@AviaturTwig/' . $agencyFolder . '/Search/General/mainSearch_index.html.twig'), $props);
  287.         $response->setSharedMaxAge(720);
  288.         $response->headers->addCacheControlDirective('must-revalidate', true);
  290.         return $response;
  291.     }
  293.     public function loginDataAction(Request $request, ManagerRegistry $registry, SessionInterface $session)
  294.     {
  295.         header('Access-Control-Allow-Origin: *');
  296.         $em = $registry->getManager();
  297.         $refererWhitemark = $request->request->get('referer');
  298.         $whitemarkAgency = $em->getRepository(\Aviatur\GeneralBundle\Entity\Whitemark::class)->findOneBy(['referer' => $refererWhitemark]);
  299.         $data = [
  300.             'status' => 'error',
  301.         ];
  302.         if (null != $whitemarkAgency) {
  303.             $whitemarkAgencyDataInfo = [
  304.                 'whitemark_id' => $whitemarkAgency->getId(),
  305.                 'whitemark_name' => $whitemarkAgency->getName(),
  306.                 'whitemark_phone' => $whitemarkAgency->getPhone(),
  307.                 'whitemark_email' => $whitemarkAgency->getEmail(),
  308.                 'whitemark_address' => $whitemarkAgency->getAddress(),
  309.                 'whitemark_phones' => json_decode($whitemarkAgency->getPhonesContact(), true),
  310.             ];
  311.             if (count($whitemarkAgencyDataInfo) > 0) {
  312.                 $session->set('whitemarkDataInfo', $whitemarkAgencyDataInfo);
  313.                 $session->set('whitemark', $refererWhitemark);
  314.                 $data = [
  315.                     'status' => 'success',
  316.                     'data' => $whitemarkAgencyDataInfo,
  317.                 ];
  319.                 return $this->json($data);
  320.             }
  321.         } else {
  322.             return $this->json($data);
  323.         }
  324.     }
  326.     public function blankCloseAction(SessionInterface $session, ManagerRegistry $registry, TwigFolder $twigFolder)
  327.     {
  328.         $em = $registry->getManager();
  329.         $agencyId = $session->get('agencyId');
  330.         $agencyFolder = $twigFolder->twigFlux();
  332.         return $this->render($twigFolder->twigExists('@AviaturTwig/'.$agencyFolder.'/General/Templates/_blankClose.html.twig'));
  333.     }
  335.     public function getOS(Request $request)
  336.     {
  337.         $user_agent = $request->server->get('HTTP_USER_AGENT');
  338.         $os_platform = 'unknown';
  339.         $actual_url = $request->server->get('HTTP_HOST');
  341.         $os_array = [
  342.             '/windows/i' => 'windows',
  343.             '/Windows Phone/i' => 'windows',
  344.             '/MSIE/i' => 'windows',
  345.             '/macintosh|mac os x/i' => 'iphone',
  346.             '/mac_powerpc/i' => 'iphone',
  347.             '/iphone/i' => 'iphone',
  348.             '/ipod/i' => 'iphone',
  349.             '/ipad/i' => 'iphone',
  350.             '/android/i' => 'android',
  351.             '/webos/i' => 'mobile',
  352.         ];
  353.         if (false === strripos($actual_url, 'mobile.')) {
  354.             foreach ($os_array as $regex => $value) {
  355.                 if (preg_match($regex, $user_agent)) {
  356.                     $os_platform = $value;
  357.                 }
  358.             }
  359.         }
  361.         return $os_platform;
  362.     }
  364.     public function archiveAction(ParameterBagInterface $parameterBag, AviaturErrorHandler $aviaturErrorHandler, $id)
  365.     {
  366.         $projectDir = $parameterBag->get('kernel.project_dir');
  368.         if (!file_exists($projectDir.'/app/serviceLogs/CashTransaction/'.$id)) {
  369.             return $this->redirect($aviaturErrorHandler->errorRedirect($this->generateUrl('homepage'), '', 'Hubo algún problema al descargar el archivo, por favor comuníquese con nosotros a los teléfonos 57-1-5879640 o 57-1-3821616, o vía e-mail al correo soportepagoelectronico@aviatur.com.co, o revise su correo electrónico.'));
  370.         }
  372.         return new BinaryFileResponse($projectDir.'/app/serviceLogs/CashTransaction/'.$id);
  373.     }
  375.     public function changeCoinAction(Request $request, AviaturLogSave $aviaturLogSave, SessionInterface $session)
  376.     {
  377.         header('Access-Control-Allow-Origin: *');
  379.         if (false !== strpos($request->query->get('typeCountry'), '||')) {
  380.             $selectionArray = explode('||', $request->query->get('typeCountry'));
  381.             $transactionId = base64_decode($selectionArray[1]);
  382.             $session->set($transactionId.'[typeCoin]', $session->get('typeCoin'));
  383.             $session->set($transactionId.'[RateChange]', $session->get('RateChange'));
  384.             $session->set($transactionId.'[financialValue]', $session->get('financialValue'));
  385.             $session->set($transactionId.'[trmValue]', $session->get('trmValue'));
  386.             $aviaturLogSave->logSave(print_r([
  387.                 'typeCoin' => $session->get('typeCoin'),
  388.                 'RateChange' => $session->get('RateChange'),
  389.                 'financialValue' => $session->get('financialValue'),
  390.                 'trmValue' => $session->get('trmValue'),
  391.             ], true), 'ChangeCoinDetail', 'RQ', $transactionId);
  392.         }
  394.         return new Response(
  395.             json_encode(
  396.                 [
  397.                     'typeCoin' => $session->get('typeCoin'),
  398.                     'typeCountry' => $session->get('typeCountry'),
  399.                     'CoinValue' => $session->get('CoinValue'),
  400.                     'RateDiff' => $session->get('RateDiff'),
  401.                 ]
  402.             )
  403.         );
  404.     }
  406.     public function promoSearchAgencyAction(AviaturUpdatePromoProduct $aviaturUpdatePromoProduct)
  407.     {
  408.         header('Access-Control-Allow-Origin: *');
  409.         $promosAgencySearch = $aviaturUpdatePromoProduct->promoSearchAgency();
  411.         return new Response($promosAgencySearch);
  412.     }
  414.     public function alertAction(Request $request, ManagerRegistry $registry, SessionInterface $session)
  415.     {
  416.         $alert = new Alerts();
  417.         $form = $this->createForm(\Aviatur\GeneralBundle\Form\AlertsType::class, $alert);
  418.         $em = $registry->getManager();
  419.         $agencyId = $session->get('agencyId');
  420.         if ('POST' == $request->getMethod()) {
  421.             $form->handleRequest($request);
  422.             if ($form->isValid()) {
  423.                 if ($request->isXmlHttpRequest()) {
  424.                     $findAlert = $em->getRepository(\Aviatur\GeneralBundle\Entity\Alerts::class)->findBy(['email' => $alert->getEmail(), 'url' => $alert->getUrl(), 'agency' => $agencyId]);
  425.                     if (empty($findAlert)) {
  426.                         $alert->setEntrydate(new \DateTime());
  427.                         $alert->setSearchUrl(new \DateTime());
  428.                         $bestPrice = $em->getRepository(\Aviatur\GeneralBundle\Entity\BestPrices::class)->findByBestPriceUrl($alert->getUrl());
  429.                         if (!empty($bestPrice)) {
  430.                             $agency = $em->getRepository(\Aviatur\AgencyBundle\Entity\Agency::class)->find($agencyId);
  431.                             if (!empty($agency)) {
  432.                                 $alert->setPrice($bestPrice[0]->getBestPrice());
  433.                                 $alert->setUpdatePrice(0);
  434.                                 $alert->setTrip($bestPrice[0]->getTrip());
  435.                                 $alert->setDeparture($bestPrice[0]->getDeparture());
  436.                                 $alert->setRound($bestPrice[0]->getRound());
  437.                                 $alert->setAgency($agency);
  438.                                 $em->persist($alert);
  439.                                 $em->flush();
  440.                                 $response = new Response();
  441.                                 $output = ['success' => true];
  442.                                 $response->headers->set('Content-Type', 'application/json');
  443.                                 $response->setContent(json_encode($output));
  445.                                 return $response;
  446.                             } else {
  447.                                 $response = new Response();
  448.                                 $output = ['failToken' => true];
  449.                                 $response->headers->set('Content-Type', 'application/json');
  450.                                 $response->setContent(json_encode($output));
  452.                                 return $response;
  453.                             }
  454.                         } else {
  455.                             $response = new Response();
  456.                             $output = ['failToken' => true];
  457.                             $response->headers->set('Content-Type', 'application/json');
  458.                             $response->setContent(json_encode($output));
  460.                             return $response;
  461.                         }
  462.                     } else {
  463.                         $response = new Response();
  464.                         $output = ['error' => true];
  465.                         $response->headers->set('Content-Type', 'application/json');
  466.                         $response->setContent(json_encode($output));
  468.                         return $response;
  469.                     }
  470.                 } else {
  471.                     $response = new Response();
  472.                     $output = ['failToken' => true];
  473.                     $response->headers->set('Content-Type', 'application/json');
  474.                     $response->setContent(json_encode($output));
  476.                     return $response;
  477.                 }
  478.             } else {
  479.                 $response = new Response();
  480.                 $output = ['failToken' => true];
  481.                 $response->headers->set('Content-Type', 'application/json');
  482.                 $response->setContent(json_encode($output));
  484.                 return $response;
  485.             }
  486.         } else {
  487.             $response = new Response();
  488.             $output = ['failToken' => true];
  489.             $response->headers->set('Content-Type', 'application/json');
  490.             $response->setContent(json_encode($output));
  492.             return $response;
  493.         }
  494.     }
  496.     public function searchBestPricesAction(Request $request, ManagerRegistry $registry)
  497.     {
  498.         $em = $registry->getManager();
  499.         if ($request->isXmlHttpRequest()) {
  500.             $url = $request->request->get('url');
  501.             $price = $request->request->get('price');
  502.             $bestPrice = $em->getRepository(\Aviatur\GeneralBundle\Entity\BestPrices::class)->findByBestPriceUrl($url);
  503.             if (!empty($bestPrice)) {
  504.                 $priceBP = $bestPrice[0]->getBestprice();
  505.                 if ($price == $priceBP || $price > $priceBP) {
  506.                     $response = new Response();
  507.                     $output = ['response' => 'fail'];
  508.                     $response->setContent(json_encode($output));
  510.                     return $response;
  511.                 } else {
  512.                     $response = new Response();
  513.                     $output = ['response' => 'success'];
  514.                     $response->setContent(json_encode($output));
  516.                     return $response;
  517.                 }
  518.             } else {
  519.                 $ch = curl_init('http://www.aviatursym.com'.$url);
  520.                 curl_setopt($ch, CURLOPT_HEADER, true);
  521.                 curl_setopt($ch, CURLOPT_HTTPHEADER, ['X-Requested-With: XMLHttpRequest']);
  522.                 curl_setopt($ch, CURLOPT_CUSTOMREQUEST, 'GET');
  523.                 curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);
  524.                 curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  525.                 $result = curl_exec($ch);
  526.                 curl_close($ch);
  527.                 $posError = strpos($result, '66002');
  528.                 $posDisponibilidad = strpos($result, 'No encontramos');
  529.                 $posFechas = strpos($result, 'búsqueda incorrectas');
  530.                 if (false != $posError || false != $posDisponibilidad || false != $posFechas) {
  531.                     $response = new Response();
  532.                     $output = ['response' => 'fail'];
  533.                     $response->setContent(json_encode($output));
  535.                     return $response;
  536.                 } else {
  537.                     $bestPriceCURL = $em->getRepository(\Aviatur\GeneralBundle\Entity\BestPrices::class)->findByBestPriceUrl($url);
  538.                     if (!empty($bestPriceCURL)) {
  539.                         $priceBP = $bestPriceCURL[0]->getBestprice();
  540.                         if ($price == $priceBP || $price > $priceBP) {
  541.                             $response = new Response();
  542.                             $output = ['response' => 'fail'];
  543.                             $response->setContent(json_encode($output));
  545.                             return $response;
  546.                         } else {
  547.                             $response = new Response();
  548.                             $output = ['response' => 'success'];
  549.                             $response->setContent(json_encode($output));
  551.                             return $response;
  552.                         }
  553.                     } else {
  554.                         $response = new Response();
  555.                         $output = ['response' => 'fail'];
  556.                         $response->setContent(json_encode($output));
  558.                         return $response;
  559.                     }
  560.                 }
  561.             }
  562.         } else {
  563.             $response = new Response();
  564.             $output = ['response' => 'fail'];
  565.             $response->setContent(json_encode($output));
  567.             return $response;
  568.         }
  569.     }
  571.     public function detenerAlertaAction(AviaturErrorHandler $aviaturErrorHandler, ManagerRegistry $registry, $id)
  572.     {
  573.         $em = $registry->getManager();
  574.         $alert = $em->getRepository(\Aviatur\GeneralBundle\Entity\Alerts::class)->find($id);
  575.         if (!empty($alert)) {
  576.             $em->remove($alert);
  577.             $em->flush();
  579.             return $this->redirect($aviaturErrorHandler->errorRedirectNoEmail($this->generateUrl('homepage'), 'Detener alerta', 'La alerta ha sido eliminada de manera exitosa. Gracias por preferirnos.'));
  580.         } else {
  581.             return $this->redirect($aviaturErrorHandler->errorRedirectNoEmail($this->generateUrl('homepage'), 'Detener alerta', 'La alerta ha sido eliminada de manera exitosa. Gracias por preferirnos.'));
  582.         }
  583.     }
  585.     public function searchBestPriceXtremeAction(Request $request, ManagerRegistry $registry)
  586.     {
  587.         $baseFare = null;
  588.         $compareValue = null;
  589.         $bestPrice = null;
  590.         $airlineName = null;
  591.         $em = $registry->getManager();
  592.         if ($request->isXmlHttpRequest()) {
  593.             $trip = $request->request->get('trip');
  594.             $dateI = $request->request->get('dateInicial');
  595.             $dateF = $request->request->get('dateFinal');
  596.             $flightDestination = $request->request->get('destination');
  597.             $flightType = $request->request->get('flightType');
  598.             $bestPrices = $em->getRepository(\Aviatur\GeneralBundle\Entity\BestPrices::class)->findByBestPriceXtremeRange($trip, $dateI, $dateF);
  599.             if (!empty($bestPrices)) {
  600.                 $arrayLength = is_countable($bestPrices) ? count($bestPrices) : 0;
  601.                 $bestP = [];
  602.                 if ('D' == $flightType) {
  603.                     for ($i = 0; $i < $arrayLength; ++$i) {
  604.                         $prices = json_decode($bestPrices[$i]->getPrices(), true);
  605.                         foreach ($prices as $price) {
  606.                             $baseFare = $price['baseFare'];
  607.                             $compareValue = $price['compareValue'];
  608.                             $bestPrice = $price['flightPrice'];
  609.                             $airlineName = $price['airlineName'];
  610.                             break;
  611.                         }
  612.                         $dateBP = strtotime($bestPrices[$i]->getDeparture());
  613.                         $dateBPFormat = date('dmy', $dateBP);
  614.                         $bestP[$dateBPFormat] = $bestPrice;
  615.                         $BPta = $this->searchAdminFeeAction($baseFare, $compareValue, $bestPrice, $trip, $flightDestination, $airlineName);
  616.                         $bestP[$dateBPFormat] = $BPta;
  617.                     }
  618.                 } elseif ('R' == $flightType) {
  619.                     for ($i = 0; $i < $arrayLength; ++$i) {
  620.                         if ('' != $bestPrices[$i]->getRound()) {
  621.                             $prices = json_decode($bestPrices[$i]->getPrices(), true);
  622.                             foreach ($prices as $price) {
  623.                                 $baseFare = $price['baseFare'];
  624.                                 $compareValue = $price['compareValue'];
  625.                                 $bestPrice = $price['flightPrice'];
  626.                                 $airlineName = $price['airlineName'];
  627.                                 break;
  628.                             }
  629.                             $dateBP = strtotime($bestPrices[$i]->getRound());
  630.                             $dateBPFormat = date('dmy', $dateBP);
  631.                             $bestP[$dateBPFormat] = $bestPrice;
  632.                             $BPta = $this->searchAdminFeeAction($baseFare, $compareValue, $bestPrice, $trip, $flightDestination, $airlineName);
  633.                             $bestP[$dateBPFormat] = $BPta;
  634.                         }
  635.                     }
  636.                 }
  637.                 $response = new Response();
  638.                 $output = ['response' => 'success', 'bestPrices' => $bestP];
  639.                 $response->setContent(json_encode($output));
  641.                 return $response;
  642.             } else {
  643.                 $response = new Response();
  644.                 $output = ['response' => 'fail empty'];
  645.                 $response->setContent(json_encode($output));
  647.                 return $response;
  648.             }
  649.         } else {
  650.             $response = new Response();
  651.             $output = ['response' => 'fail'];
  652.             $response->setContent(json_encode($output));
  654.             return $response;
  655.         }
  656.     }
  658.     public function searchAdminFeeAction(ManagerRegistry $registry, SessionInterface $session, $baseFare, $compare, $price, $trip, $destination, $airline)
  659.     {
  660.         $iatas = [];
  661.         $fee = [];
  662.         $adminFe = [];
  663.         $em = $registry->getManager();
  664.         $agencyR = $em->getRepository(\Aviatur\AgencyBundle\Entity\Agency::class)->find($session->get('agencyId'));
  665.         $destinationCity = $em->getRepository(\Aviatur\GeneralBundle\Entity\City::class)->findOneByIatacode($destination);
  666.         $airlineCode = $em->getRepository(\Aviatur\FlightBundle\Entity\Airline::class)->findOneByName($airline);
  667.         $adminFees = $em->getRepository(\Aviatur\FlightBundle\Entity\AdminFee::class)->getAdminFeebyAgency($agencyR, $destinationCity);
  668.         $fromCurrency = $em->getRepository(\Aviatur\TrmBundle\Entity\Currency::class)->findOneByIata('USD');
  669.         $toCurrency = $em->getRepository(\Aviatur\TrmBundle\Entity\Currency::class)->findOneByIata('COP');
  670.         $TRM = $em->getRepository(\Aviatur\TrmBundle\Entity\Trm::class)->findOneBy(['fromCurrency' => $fromCurrency, 'toCurrency' => $toCurrency], ['id' => 'DESC']);
  672.         $claves = preg_split('/[-|]+/', $trip);
  673.         $typeFlight = $claves[2];
  674.         if ('R' == $typeFlight) {
  675.             $iatas[0] = $claves[0];
  676.             $iatas[1] = $claves[1];
  677.             $iatas[2] = $claves[1];
  678.             $iatas[3] = $claves[0];
  679.         } elseif ('O' == $typeFlight) {
  680.             $iatas[0] = $claves[0];
  681.             $iatas[1] = $claves[1];
  682.         }
  684.         $cityCountries = $em->getRepository(\Aviatur\SearchBundle\Entity\SearchCities::class)->findCountryCodes($iatas);
  685.         $airportCountries = $em->getRepository(\Aviatur\SearchBundle\Entity\SearchAirports::class)->findCountryCodes($iatas);
  686.         $countries = array_unique(array_merge($cityCountries, $airportCountries), SORT_REGULAR);
  687.         $type = '';
  688.         //VALIDACION SI ES INTERNACIONAL
  689.         if (sizeof($countries) > 1 || (sizeof($countries) > 0 && !in_array('CO', $countries))) {
  690.             $international = true;
  691.             $isINNS = 1;
  692.             $fromCurrency = $em->getRepository(\Aviatur\TrmBundle\Entity\Currency::class)->findOneByIata('USD');
  693.             $toCurrency = $em->getRepository(\Aviatur\TrmBundle\Entity\Currency::class)->findOneByIata('COP');
  694.             $TRM = $em->getRepository(\Aviatur\TrmBundle\Entity\Trm::class)->findOneBy(['fromCurrency' => $fromCurrency, 'toCurrency' => $toCurrency], ['id' => 'DESC']);
  695.         } else {
  696.             $international = false;
  697.             $isINNS = 0;
  698.         }
  699.         if (!in_array('CO', $countries)) {
  700.             $type = 'NNS';
  701.             ++$isINNS;
  702.         }
  703.         foreach ($adminFees as $key => $adminFee) {
  704.             $airline = $adminFee['airline_id'];
  705.             $agency = $adminFee['agency_id'];
  706.             $nnsFare = (1 == $adminFee['noNationalStop']) ? 'NNS' : '';
  707.             $itFare = (1 == $adminFee['isItFare']) ? 'IT' : '';
  708.             if (null != $airline) {
  709.                 $agencyFee = (null != $agency) ? 'Agency' : '';
  710.                 ${'airlines'.$agencyFee.'Iata'.$nnsFare.$itFare}[] = $adminFee['iata'];
  711.                 ${'airlines'.$agencyFee.'Key'.$nnsFare.$itFare}[] = $key;
  712.             } elseif (null != $agency) {
  713.                 ${'agencyKey'.$nnsFare.$itFare} = $key;
  714.             } else {
  715.                 ${'generalKey'.$nnsFare.$itFare} = $key;
  716.             }
  717.         }
  718.         $itFare = '';
  719.         $vendorCodes = !empty($airlineCode) ? [$airlineCode->getIata()] : [];
  720.         if ((isset(${'airlinesAgencyIata'.$type.$itFare}) && ((bool) array_intersect(${'airlinesAgencyIata'.$type.$itFare}, $vendorCodes))) || (isset(${'airlinesIata'.$type.$itFare}) && ((bool) array_intersect(${'airlinesIata'.$type.$itFare}, $vendorCodes)))) {
  721.             $agencyFee = (isset(${'airlinesAgencyIata'.$type.$itFare}) && ((bool) array_intersect(${'airlinesAgencyIata'.$type.$itFare}, $vendorCodes))) ? 'Agency' : '';
  722.             $purgeAirlinesIata = array_unique(array_intersect(${'airlines'.$agencyFee.'Iata'.$type.$itFare}, $vendorCodes));
  723.             foreach ($purgeAirlinesIata as $airlineIata) {
  724.                 $airlineIatasToFee = array_keys(${'airlines'.$agencyFee.'Iata'.$type.$itFare}, $airlineIata);
  725.                 $fee = null;
  726.                 foreach ($airlineIatasToFee as $indexFee) {
  727.                     $optionalFee = $adminFees[${'airlines'.$agencyFee.'Key'.$type.$itFare}[$indexFee]];
  728.                     if (null != $optionalFee['city_id'] && $optionalFee['city_id'] == (string) $destinationCity->getId()) {
  729.                         $fee = $optionalFee;
  730.                     }
  731.                 }
  732.                 if (null == $fee) {
  733.                     $fee = $adminFees[${'airlines'.$agencyFee.'Key'.$type.$itFare}[array_search($airlineIata, ${'airlines'.$agencyFee.'Iata'.$type.$itFare})]];
  734.                 }
  735.             }
  736.         } elseif (isset(${'agencyKey'.$type.$itFare})) {
  737.             $fee = $adminFees[${'agencyKey'.$type.$itFare}];
  738.         } elseif (isset(${'generalKey'.$type.$itFare})) {
  739.             $fee = $adminFees[${'generalKey'.$type.$itFare}];
  740.         } else {
  741.             $fee = null;
  742.             //                            echo "ERROR: tarifa " . $type . " no encontrada para la aerolinea: " . $airlineIata . " y la agencia con id: " . $agency;
  743.             $administrativeCost = 0;
  744.         }
  745.         $administrativeCost = 0;
  746.         if (1 == $fee['rangeType']) {
  747.             if ($international) {
  748.                 $compareValue = $compare / $TRM->getRate()->getFinantialrate();
  749.                 if (($fee['rangeInternational1Start'] <= $compareValue) && ($compareValue <= $fee['rangeInternational1End'])) {
  750.                     $administrativeCostRange = $fee['valueInternational1'];
  751.                 } elseif (($fee['rangeInternational2Start'] <= $compareValue) && ($compareValue <= $fee['rangeInternational2End'])) {
  752.                     $administrativeCostRange = $fee['valueInternational2'];
  753.                 } elseif (($fee['rangeInternational3Start'] <= $compareValue) && ($compareValue <= $fee['rangeInternational3End'])) {
  754.                     $administrativeCostRange = $fee['valueInternational3'];
  755.                 } elseif (($fee['rangeInternational4Start'] <= $compareValue) && ($compareValue <= $fee['rangeInternational4End'])) {
  756.                     $administrativeCostRange = $fee['valueInternational4'];
  757.                 } elseif (($fee['rangeInternational4Start'] <= $compareValue) && 0 == $fee['rangeInternational4End']) {
  758.                     $administrativeCostRange = $adminFe['valueInternational4'];
  759.                 } else {
  760.                     $administrativeCostRange = 0;
  761.                 }
  762.                 if (0 == $fee['valueType']) {
  763.                     $administrativeCost += round($administrativeCostRange * $TRM->getRate()->getFinantialrate() * 1);
  764.                 } else {
  765.                     $administrativeCost += round(($baseFare /* + ${'tax' . $infoPassenger['Code']} */) * $administrativeCostRange);
  766.                 }
  767.             } else {
  768.                 if (0 == $fee['valueType']) {
  769.                     if ('R' == $typeFlight) {
  770.                         $administrativeCost = $fee['roundtripNational'];
  771.                     } else {
  772.                         $administrativeCost = $fee['onewayNational'];
  773.                     }
  774.                     $administrativeCost = $administrativeCost * 1;
  775.                 } else {
  776.                     if ('R' == $typeFlight) {
  777.                         $administrativeCost = $fee['roundtripNational'];
  778.                     } else {
  779.                         $administrativeCost = $fee['onewayNational'];
  780.                     }
  781.                     $administrativeCost = $baseFare * $administrativeCost;
  782.                 }
  783.             }
  784.         } else {
  785.             if ($international) {
  786.                 $administrativeCost = $fee['internationalFixed'];
  787.                 if (0 == $fee['valueType']) {
  788.                     $administrativeCost = round($administrativeCost * $TRM->getRate()->getFinantialrate());
  789.                 }
  790.             } else {
  791.                 $administrativeCost = $fee['nationalFixed'];
  792.             }
  793.             if ($fee['valueType']) {
  794.                 $administrativeCost = $price * $administrativeCost;
  795.             } else {
  796.                 $administrativeCost = $administrativeCost * 1;
  797.             }
  798.         }
  799.         $fare = (int) $price + (int) $administrativeCost.'.00';
  801.         return (string) $fare;
  802.     }
  804.     public function filesRssAction(ManagerRegistry $registry, SessionInterface $session, TwigFolder $twigFolder)
  805.     {
  806.         $em = $registry->getManager();
  807.         $agencyId = $session->get('agencyId');
  808.         $agencyFolder = $twigFolder->twigFlux();
  810.         return $this->render($twigFolder->twigExists('@AviaturTwig/'.$agencyFolder.'/General/Templates/filesRss.html.twig'));
  811.     }
  813.     public function daviviendaLoginAction(Request $request, ManagerRegistry $registry, SessionInterface $session, ParameterBagInterface $parameterBag, TwigFolder $twigFolder)
  814.     {
  815.         $env = $parameterBag->get('kernel.environment');
  816.         $response = [];
  817.         $environment = $env;
  818.         $em = $registry->getManager();
  819.         $parameters = json_decode($em->getRepository(\Aviatur\GeneralBundle\Entity\Parameter::class)->findOneByName('aviatur_davivienda')->getDescription(), true);
  820.         $urlAuthentication = $parameters['endPoints']['authentication'][$environment].'?client_id='.$parameters['idCliente'].'&response_type='.$parameters['responsetype'].'&scope='.$parameters['scope'];
  821.         $agencyFolder = $twigFolder->twigFlux();
  822.         $urlReturn = '@AviaturTwig/'.$agencyFolder.'/Payment/Davivienda/loginReturn.html.twig';
  824.         if ($request->isXmlHttpRequest()) {
  825.             if (!empty(json_decode($request->getContent(), true))) {
  826.                 $parametersAsArray = [];
  827.                 if ($content = $request->getContent()) {
  828.                     $parametersAsArray = json_decode($content, true);
  829.                 }
  831.                 if (empty($parametersAsArray)) {
  832.                     $response = $this->returnResult('error', 500, '1. Error con los parametros de entrada.');
  833.                 }
  835.                 if (isset($parametersAsArray['authentication'])) {
  836.                     $url = $parameters['endPointsApi']['authentication'][$environment];
  837.                     $response = $this->CallAPI($url, false, false, 'authentication');
  838.                     if (isset($response['message']) && isset($response['message']['text']['token'])) {
  839.                         $response['message']['text']['session'] = true;
  840.                         $session->set('[davivienda][token]', $response['message']['text']['token']);
  841.                     }
  842.                 } elseif (isset($parametersAsArray['token'])) {
  843.                     $url = $parameters['endPointsApi']['logindavivienda'][$environment];
  844.                     $response = $this->CallAPI($url, ['token' => $parametersAsArray['token']], false, 'login-davivienda');
  845.                 }
  846.             } else {
  847.                 $response = $this->returnResult('error', 500, '1. Error con los parametros de entrada.');
  848.             }
  849.         } elseif (!empty($request->query->get('rstate'))) {
  850.             $infos = ['rstate', 'confirmation', 'username'];
  851.             foreach ($infos as $info) {
  852.                 if (!$request->query->has($info) || empty($request->query->has($info))) {
  853.                     $response = $this->returnResult('error', 500, 'Error en parametro = '.$info);
  854.                 }
  855.             }
  857.             $redirect_uri = $parameters['redirect_uri'];
  858.             $rstate = $request->query->get('rstate');
  859.             $confirmation = $request->query->get('confirmation');
  860.             $username = $request->query->get('username');
  862.             $url = $urlAuthentication.'&redirect_uri='.$redirect_uri.'&rstate='.$rstate.'&confirmation='.$confirmation.'&username='.$username;
  864.             $response = $this->CallAPI($url, false, false, 'authentication_redirect');
  866.             if (isset($response['message']) && isset($response['message']['text']['access_token'])) {
  867.                 if ($session->has('[davivienda][token]')) {
  868.                     $token = $session->get('[davivienda][token]');
  869.                     $accesToken = $em->getRepository(\Aviatur\RestBundle\Entity\OauthAccesstokenDavivienda::class)->findOneByToken($token);
  870.                     $response['message']['text']['token'] = $token;
  871.                     $externalLogin = [
  872.                         'login' => true,
  873.                         'access_token' => $response['message']['text']['access_token'],
  874.                         'token_type' => $response['message']['text']['token_type'],
  875.                         'token' => $token,
  876.                     ];
  878.                     $accesToken->setExternalLogin(json_encode($externalLogin));
  880.                     $em->persist($accesToken);
  881.                     $em->flush();
  882.                 } else {
  883.                     $response = $this->returnResult('error', 500, '2. No existe token.');
  884.                 }
  885.             } else {
  886.                 $response = $this->returnResult('error', 500, '1. No existe Token.');
  887.             }
  889.             return $this->render($twigFolder->twigExists($urlReturn), ['response' => $response]);
  890.         } else {
  891.             $response = $this->returnResult('error', 500, 'No existe Informacion.');
  893.             return $this->render($twigFolder->twigExists($urlReturn), ['response' => $response]);
  894.         }
  896.         return $this->json($response);
  897.     }
  899.     public function validCaptchaAction(Request $request)
  900.     {
  901.         if ($request->isXmlHttpRequest()) {
  902.             $token = $request->request->get('g-recaptcha-response');
  903.             $secretKey = '6LfsqrgZAAAAAEuDXSOrdZloUv_T5qC6uu7qdXQE';
  904.             $request = 'https://www.google.com/recaptcha/api/siteverify?secret='.$secretKey.'&response='.$token;
  905.             $arrContextOptions = [
  906.                 'ssl' => [
  907.                     'verify_peer' => false,
  908.                     'verify_peer_name' => false,
  909.                 ],
  910.             ];
  911.             $verifydata = file_get_contents($request, false, stream_context_create($arrContextOptions));
  912.             $response = json_decode($verifydata);
  913.             if ($response->success) {
  914.                 return $this->json(['status' => 'success', 'message' => 'Captcha valido']);
  915.             } else {
  916.                 return $this->json(['status' => 'error', 'message' => 'Captcha inválido']);
  917.             }
  918.         }
  919.     }
  921.     // Poner siempre la palabra Action al final de la funcion
  922.     public function UserApiAction(Request $request, ManagerRegistry $registry)
  923.     {
  924.         $em = $registry->getManager();
  925.         $registros = $request->request->get('registros');
  926.         $pagina = $request->request->get('pagina');
  927.         $pagina = ($pagina * 10) - 10;
  928.         $totalRegistros = $em->createQuery('SELECT count(:total) FROM AviaturCustomerBundle:Customer')->setParameter('total', '*');
  929.         $total = $totalRegistros->getResult();
  930.         $numPaginas = (int) $total[0]['1'] / $registros;
  931.         $allUsers = $em->createQuery('SELECT c.firstname, c.id FROM AviaturCustomerBundle:Customer c ORDER BY c.id DESC')->setMaxResults($registros)->setFirstResult($pagina);
  932.         $users = $allUsers->getResult();
  934.         return $this->json(['status' => 'success', 'code' => 200, 'totalPages' => $numPaginas, 'data' => $users]);
  935.     }
  937.     public function getAllAdmiFeeWmAction(ManagerRegistry $registry)
  938.     {
  939.         $em = $registry->getManager();
  940.         //$token = $request->request->get('g-recaptcha-response');
  941.         $info = $em->getRepository(\Aviatur\FlightBundle\Entity\AdminFeeWhitemark::class)->findAll();
  942.         if (!$info) {
  943.             return $this->json(['status' => 'error', 'code' => 200, 'message' => 'No hay registros']);
  944.         }
  945.         $data = [];
  946.         foreach ($info as $item) {
  947.             $arrayTemp = [
  948.                 'id' => $item->getId(),
  949.                 'whitemarkId' => (null == $item->getWhitemark()) ? null : (int) $item->getWhitemark()->getId(),
  950.                 'airlineId' => (null == $item->getAirline()) ? null : (int) $item->getAirline()->getId(),
  951.                 'cityId' => (null == $item->getCity()) ? null : (int) $item->getCity()->getId(),
  952.                 'valueType' => (int) $item->getValuetype(),
  953.                 'rangeType' => (int) $item->getRangetype(),
  954.                 'isActive' => (int) $item->getIsactive(),
  955.                 'noNationalStop' => (int) $item->getNonationalstop(),
  956.                 'isItFare' => (int) $item->getIsitfare(),
  957.                 'nationalFixed' => $item->getNationalfixed(),
  958.                 'internationalFixed' => $item->getInternationalfixed(),
  959.                 'roundtripNational' => $item->getRoundtripnational(),
  960.                 'onewayNational' => $item->getOnewaynational(),
  961.                 'rangeInternational1Start' => $item->getRangeinternational1start(),
  962.                 'rangeInternational1End' => $item->getRangeinternational1end(),
  963.                 'rangeInternational2Start' => $item->getRangeinternational2start(),
  964.                 'rangeInternational2End' => $item->getRangeinternational2end(),
  965.                 'rangeInternational3Start' => $item->getRangeinternational3start(),
  966.                 'rangeInternational3End' => $item->getRangeinternational3end(),
  967.                 'rangeInternational4Start' => $item->getRangeinternational4start(),
  968.                 'rangeInternational4End' => $item->getRangeinternational4end(),
  969.                 'valueInternational1' => $item->getValueinternational1(),
  970.                 'valueInternational2' => $item->getValueinternational2(),
  971.                 'valueInternational3' => $item->getValueinternational3(),
  972.                 'valueInternational4' => $item->getValueinternational4(),
  973.             ];
  974.             array_push($data, $arrayTemp);
  975.         }
  977.         return $this->json(['status' => 'success', 'code' => 200, 'data' => $data]);
  978.     }
  980.     public function addNewAdmiFeeWmAction(Request $request, ManagerRegistry $registry)
  981.     {
  982.         $em = $registry->getManager();
  983.         if ($request->request->get('cityId') && '' != $request->request->get('cityId') && null != $request->request->get('cityId')) {
  984.             $dataCity = $em->getRepository(\Aviatur\GeneralBundle\Entity\City::class)->findOneBy(['id' => (int) $request->request->get('cityId')]);
  985.             if (!$dataCity) {
  986.                 return $this->json(['status' => 'error', 'code' => 200, 'message' => 'No existe registro para la ciudad indicada']);
  987.             }
  988.         }
  989.         if ($request->request->get('airlineId') && '' != $request->request->get('airlineId') && null != $request->request->get('airlineId')) {
  990.             $airline = $em->getRepository(\Aviatur\FlightBundle\Entity\Airline::class)->findOneBy(['id' => (int) $request->request->get('airlineId')]);
  991.             if (!$airline) {
  992.                 return $this->json(['status' => 'error', 'code' => 200, 'message' => 'No existe registro para la aerolinea indicada']);
  993.             }
  994.         }
  995.         if ($request->request->get('whitemarkId') && '' != $request->request->get('whitemarkId') && null != $request->request->get('whitemarkId')) {
  996.             $whitemark = $em->getRepository(\Aviatur\GeneralBundle\Entity\Whitemark::class)->findOneBy(['id' => (int) $request->request->get('whitemarkId')]);
  997.             if (!$whitemark) {
  998.                 return $this->json(['status' => 'error', 'code' => 200, 'message' => 'No existe registro para la Whitemark indicada']);
  999.             }
  1000.         }
  1001.         $data = new AdminFeeWhitemark();
  1002.         $data->setWhitemark($whitemark ?? null);
  1003.         $data->setAirline($airline ?? null);
  1004.         $data->setCity($dataCity ?? null);
  1005.         $data->setValuetype(($request->request->get('valuetype') && '' != $request->request->get('valuetype') && null != $request->request->get('valuetype')) ? (int) $request->request->get('valuetype') : null);
  1006.         $data->setRangetype(($request->request->get('rangetype') && '' != $request->request->get('rangetype') && null != $request->request->get('rangetype')) ? (int) $request->request->get('rangetype') : null);
  1007.         $data->setIsactive(($request->request->get('isactive') && '' != $request->request->get('isactive') && null != $request->request->get('isactive')) ? (int) $request->request->get('isactive') : null);
  1008.         $data->setNonationalstop(($request->request->get('nonationalstop') && '' != $request->request->get('nonationalstop') && null != $request->request->get('nonationalstop')) ? (int) $request->request->get('nonationalstop') : null);
  1009.         $data->setIsitfare(($request->request->get('isitfare') && '' != $request->request->get('isitfare') && null != $request->request->get('isitfare')) ? (int) $request->request->get('isitfare') : null);
  1010.         $data->setNationalfixed(($request->request->get('nationalfixed') && '' != $request->request->get('nationalfixed') && null != $request->request->get('nationalfixed')) ? (float) $request->request->get('nationalfixed') : 0);
  1011.         $data->setInternationalfixed(($request->request->get('internationalfixed') && '' != $request->request->get('internationalfixed') && null != $request->request->get('internationalfixed')) ? (float) $request->request->get('internationalfixed') : 0);
  1012.         $data->setRoundtripnational(($request->request->get('roundtripnational') && '' != $request->request->get('roundtripnational') && null != $request->request->get('roundtripnational')) ? (float) $request->request->get('roundtripnational') : 0);
  1013.         $data->setOnewaynational(($request->request->get('onewaynational') && '' != $request->request->get('onewaynational') && null != $request->request->get('onewaynational')) ? (float) $request->request->get('onewaynational') : 0);
  1014.         $data->setRangeinternational1start(($request->request->get('rangeinternational1start') && '' != $request->request->get('rangeinternational1start') && null != $request->request->get('rangeinternational1start')) ? (int) $request->request->get('rangeinternational1start') : 0);
  1015.         $data->setRangeinternational1end(($request->request->get('rangeinternational1end') && '' != $request->request->get('rangeinternational1end') && null != $request->request->get('rangeinternational1end')) ? (int) $request->request->get('rangeinternational1end') : 0);
  1016.         $data->setRangeinternational2start(($request->request->get('rangeinternational2start') && '' != $request->request->get('rangeinternational2start') && null != $request->request->get('rangeinternational2start')) ? (int) $request->request->get('rangeinternational2start') : 0);
  1017.         $data->setRangeinternational2end(($request->request->get('rangeinternational2end') && '' != $request->request->get('rangeinternational2end') && null != $request->request->get('rangeinternational2end')) ? (int) $request->request->get('rangeinternational2end') : 0);
  1018.         $data->setRangeinternational3start(($request->request->get('rangeinternational3start') && '' != $request->request->get('rangeinternational3start') && null != $request->request->get('rangeinternational3start')) ? (int) $request->request->get('rangeinternational3start') : 0);
  1019.         $data->setRangeinternational3end(($request->request->get('rangeinternational3end') && '' != $request->request->get('rangeinternational3end') && null != $request->request->get('rangeinternational3end')) ? (int) $request->request->get('rangeinternational3end') : 0);
  1020.         $data->setRangeinternational4start(($request->request->get('rangeinternational4start') && '' != $request->request->get('rangeinternational4start') && null != $request->request->get('rangeinternational4start')) ? (int) $request->request->get('rangeinternational4start') : 0);
  1021.         $data->setRangeinternational4end(($request->request->get('rangeinternational4end') && '' != $request->request->get('rangeinternational4end') && null != $request->request->get('rangeinternational4end')) ? (int) $request->request->get('rangeinternational4end') : 0);
  1022.         $data->setValueinternational1(($request->request->get('valueinternational1') && '' != $request->request->get('valueinternational1') && null != $request->request->get('valueinternational1')) ? (float) $request->request->get('valueinternational1') : 0);
  1023.         $data->setValueinternational2(($request->request->get('valueinternational2') && '' != $request->request->get('valueinternational2') && null != $request->request->get('valueinternational2')) ? (float) $request->request->get('valueinternational2') : 0);
  1024.         $data->setValueinternational3(($request->request->get('valueinternational3') && '' != $request->request->get('valueinternational3') && null != $request->request->get('valueinternational3')) ? (float) $request->request->get('valueinternational3') : 0);
  1025.         $data->setValueinternational4(($request->request->get('valueinternational4') && '' != $request->request->get('valueinternational4') && null != $request->request->get('valueinternational4')) ? (float) $request->request->get('valueinternational4') : 0);
  1026.         $em->persist($data);
  1027.         $em->flush();
  1029.         return $this->json(['status' => 'success', 'code' => 200, 'message' => 'Registro creado']);
  1030.     }
  1032.     public function getAllCityAction(ManagerRegistry $registry)
  1033.     {
  1034.         $em = $registry->getManager();
  1035.         $cities = $em->getRepository(\Aviatur\GeneralBundle\Entity\City::class)->findAll();
  1036.         $data = [];
  1037.         foreach ($cities as $item) {
  1038.             $arrayTemp = [
  1039.                 'id' => $item->getId(),
  1040.                 'iataCode' => $item->getIataCode(),
  1041.                 'description' => ucfirst(strtolower($item->getDescription())),
  1042.             ];
  1043.             array_push($data, $arrayTemp);
  1044.         }
  1046.         return $this->json(['status' => 'success', 'code' => 200, 'data' => $data]);
  1047.     }
  1049.     public function getAllAirlinesAction(ManagerRegistry $registry)
  1050.     {
  1051.         $em = $registry->getManager();
  1052.         $airlines = $em->getRepository(\Aviatur\FlightBundle\Entity\Airline::class)->findAll();
  1053.         $data = [];
  1054.         foreach ($airlines as $item) {
  1055.             $arrayTemp = [
  1056.                 'id' => $item->getId(),
  1057.                 'iataCode' => $item->getIata(),
  1058.                 'description' => ucfirst(strtolower($item->getName())),
  1059.             ];
  1060.             array_push($data, $arrayTemp);
  1061.         }
  1063.         return $this->json(['status' => 'success', 'code' => 200, 'data' => $data]);
  1064.     }
  1066.     public function CallAPI($url, $data = false, $bearer = false, $method = false)
  1067.     {
  1068.         $curl = curl_init();
  1070.         $curlSet = [
  1071.             CURLOPT_URL => $url,
  1072.             CURLOPT_SSL_VERIFYPEER => false,
  1073.             CURLOPT_RETURNTRANSFER => true,
  1074.             CURLOPT_HEADER => true,
  1075.             CURLOPT_ENCODING => '',
  1076.             CURLOPT_MAXREDIRS => 10,
  1077.             CURLOPT_TIMEOUT => 30,
  1078.             CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  1079.         ];
  1081.         switch ($method) {
  1082.             case 'authentication':
  1083.                 $curlSet[CURLOPT_SSLCERT] = 'C:/davivienda/BancoDavivienda.cer';
  1084.                 $curlSet[CURLOPT_SSLKEY] = 'C:/davivienda/bancodavivienda.key';
  1085.                 $curlSet[CURLOPT_SSLCERTPASSWD] = 'davivienda';
  1086.                 $curlSet[CURLOPT_SSL_VERIFYHOST] = false;
  1087.                 $curlSet[CURLOPT_CUSTOMREQUEST] = 'POST';
  1088.                 break;
  1089.             case 'login-davivienda':
  1090.                 $curlSet[CURLOPT_SSL_VERIFYHOST] = false;
  1091.                 $curlSet[CURLOPT_CUSTOMREQUEST] = 'POST';
  1092.                 $curlSet[CURLOPT_POSTFIELDS] = json_encode(['token' => $data['token']]);
  1093.                 break;
  1094.             case 'authentication_redirect':
  1095.                 $curlSet[CURLOPT_SSLCERT] = 'C:/davivienda/BancoDavivienda.cer';
  1096.                 $curlSet[CURLOPT_SSLKEY] = 'C:/davivienda/bancodavivienda.key';
  1097.                 $curlSet[CURLOPT_SSLCERTPASSWD] = 'davivienda';
  1098.                 $curlSet[CURLOPT_CUSTOMREQUEST] = 'GET';
  1099.                 break;
  1100.         }
  1102.         curl_setopt_array($curl, $curlSet);
  1104.         $execute = curl_exec($curl);
  1105.         $err = curl_error($curl);
  1106.         $curl_info = curl_getinfo($curl);
  1107.         $http_code = $curl_info['http_code'];
  1108.         $header_size = curl_getinfo($curl, CURLINFO_HEADER_SIZE);
  1109.         $body = json_decode(str_replace('/', '\\\\', substr($execute, $header_size)), true);
  1110.         $response = $body;
  1112.         if (isset($body['httpCode'])) {
  1113.             $http_code = $body['httpCode'];
  1114.         } elseif (isset($body['errorCode'])) {
  1115.             $http_code = $body['errorCode'];
  1116.         }
  1117.         curl_close($curl);
  1118.         if ($err) {
  1119.             $response['error'] = 'cURL Error #: '.$err;
  1120.             $type = 'error';
  1121.         } else {
  1122.             $type = (302 == $http_code || 200 == $http_code) ? 'message' : 'error';
  1124.             switch ($method) {
  1125.                 case 'authentication_redirect':
  1126.                     //$urlreturn = 'https://www.aviatur.com/openapi/davivienda/login#access_token=AAIkNDg1MGRiOTQtODFmMC00ZThmLTk3NmUtM2JiZjM5NjEzMTM035hlZ6nqeCVMkZNldW_hgQO6XAsZJ2WenNmi6s73jqr4Ychp1sRck_eg8Up4_P3TqPcqkhtrW94KB3Gv0y0WWi3CoRvHbdM_66cupUUOpdTC1u_yLoORqCBt36scZtZu75tbRs1Ir51vsL36XU7ngA&expires_in=900&scope=review&token_type=bearer';
  1127.                     $urlreturn = $curl_info['redirect_url'];
  1128.                     $url_parts = parse_url($urlreturn);
  1129.                     if (isset(parse_url($urlreturn)['fragment']) && false !== strpos(parse_url($urlreturn)['fragment'], '=')) {
  1130.                         $fragment = explode('&', parse_url($urlreturn)['fragment']);
  1131.                         foreach ($fragment as $url) {
  1132.                             $parameter = explode('=', $url);
  1133.                             $response[$parameter[0]] = $parameter[1];
  1134.                         }
  1135.                     }
  1136.                     break;
  1137.                 default:
  1138.                     return $response;
  1139.                     break;
  1140.             }
  1141.         }
  1143.         return $this->returnResult($type, $http_code, $response);
  1144.     }
  1146.     private function returnResult($type, $code, $text)
  1147.     {
  1148.         return [
  1149.             $type => [
  1150.                 'code' => $code,
  1151.                 'text' => $text,
  1152.             ],
  1153.         ];
  1154.     }
  1156.     public function pSliderAction(SessionInterface $session, ManagerRegistry $registry, TwigFolder $twigFolder)
  1157.     {
  1158.         $em = $registry->getManager();
  1159.         $agencyId = $session->get('agencyId');
  1160.         $agencyFolder = $twigFolder->twigFlux();
  1162.         return $this->render($twigFolder->twigExists('@AviaturTwig/'.$agencyFolder.'/Content/Content/pSlider.html.twig'));
  1163.     }
  1165.     public function wmNewAction(Request $request, ManagerRegistry $registry)
  1166.     {
  1167.         $em = $registry->getManager();
  1168.         $data = json_decode($request->getContent());
  1169.         $agency = $em->getRepository(\Aviatur\AgencyBundle\Entity\Agency::class)->findOneByName($data->agency);
  1170.         if (is_object($agency)) {
  1171.             $data->agency = $agency;
  1172.             $whitemark = new Whitemark();
  1173.             foreach ($data as $key => $value) {
  1174.                 $setter = 'set'.ucfirst($key);
  1175.                 $whitemark->$setter($value);
  1176.             }
  1177.             $em->persist($whitemark);
  1178.             $em->flush();
  1180.             return $this->json(['status' => 'success', 'message' => 'Marca blanca creada correctamente.']);
  1181.         } else {
  1182.             return $this->json(['status' => 'error', 'message' => 'La agencia relacionada no existe']);
  1183.         }
  1184.     }
  1186.     public function wmUploadImageAction(Request $request, ParameterBagInterface $parameterBag)
  1187.     {
  1188.         $projectDir = $parameterBag->get('kernel.project_dir');
  1190.         if ($request && $request->isMethod('POST')) {
  1191.             $baseDir = $projectDir.'/web/assets/whitemark_assets/img/header';
  1192.             /** @var Symfony\Component\HttpFoundation\File\UploadedFile $file */
  1193.             $file = $request->files->get('image');
  1194.             if ($file) {
  1195.                 if ('image/png' == $file->getClientMimeType() || 'image/jpeg' == $file->getClientMimeType()) {
  1196.                     try {
  1197.                         $file->move(
  1198.                             $baseDir,
  1199.                             $file->getClientOriginalName()
  1200.                         );
  1202.                         return $this->json(['status' => 'success', 'message' => 'Imagen cargada correctamente.']);
  1203.                     } catch (FileException $e) {
  1204.                         return $this->json(['status' => 'error', 'message' => $e]);
  1205.                     }
  1206.                 } else {
  1207.                     return $this->json(['status' => 'error', 'message' => 'Archivo no permitido [03]']);
  1208.                 }
  1209.             } else {
  1210.                 return $this->json(['status' => 'error', 'message' => 'Ha ocurrido un error [01]']);
  1211.             }
  1212.         } else {
  1213.             return $this->json(['status' => 'error', 'message' => 'Datos invalidos [02]']);
  1214.         }
  1215.     }
  1217.     //
  1218.     //    public function talentosAction() {
  1219.     //        $request = $this->get('request_stack')->getCurrentRequest()->request;
  1220.     //        $postData = $request->all();
  1221.     //        $body = "Votación talentos aviatur: <br>"
  1222.     //                . "Nombre: " . $postData['Nombre'] . "<br>"
  1223.     //                . "Cedula: " . $postData['Cedula'] . "<br>"
  1224.     //                . "Oficina: " . $postData['Oficina'] . "<br>"
  1225.     //                . "Voto: " . $postData['Voto'];
  1226.     //        $message = (new \Swift_Message())
  1227.     //                ->setContentType("text/html")
  1228.     //                ->setFrom(array('noreply@aviatur.com.co' => 'Talentos Aviatur'))
  1229.     //                ->setTo(array('talentosaviatur@aviatur.com'))
  1230.     //                ->setBcc(array('gustavo.hincapie@aviatur.com'))
  1231.     //                ->setSubject('Votación Talentos')
  1232.     //                ->setBody($body);
  1233.     //        $this->container->get('mailer')->send($message);
  1234.     //        return $this->redirect('http://talentosaviatur.com/index.php/votacion-exitosa');
  1235.     //    }
  1236.     //
  1237.     //    public function votacionHappyAction() {
  1238.     //        $request = $this->get('request_stack')->getCurrentRequest()->request;
  1239.     //        $postData = $request->all();
  1240.     //        $body = "Votación Video Happy Aviatur: <br>"
  1241.     //                . "Nombre: " . $postData['Nombre'] . "<br>"
  1242.     //                . "Cedula: " . $postData['Cedula'] . "<br>"
  1243.     //                . "Oficina: " . $postData['Oficina'] . "<br>"
  1244.     //                . "Voto: " . $postData['Voto'];
  1245.     //        $message = (new \Swift_Message())
  1246.     //                ->setContentType("text/html")
  1247.     //                ->setFrom(array('noreply@aviatur.com.co' => 'Votación Video Happy Aviatur'))
  1248.     //                ->setTo(array('talentosaviatur@aviatur.com'))
  1249.     //                ->setBcc(array('gustavo.hincapie@aviatur.com'))
  1250.     //                ->setSubject('Votación Talentos')
  1251.     //                ->setBody($body);
  1252.     //        $this->container->get('mailer')->send($message);
  1253.     //        return $this->redirect('http://talentosaviatur.com/index.php/votacion-exitosa');
  1254.     //    }
  1255. }