src/Aviatur/GiftVoucherBundle/Controller/GiftVoucherController.php line 115

Open in your IDE?
  1. <?php
  3. namespace Aviatur\GiftVoucherBundle\Controller;
  5. use Doctrine\Persistence\ManagerRegistry;
  6. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  7. use Symfony\Component\DependencyInjection\ParameterBag\ParameterBagInterface;
  8. use Symfony\Component\HttpFoundation\JsonResponse;
  9. use Symfony\Component\HttpFoundation\Request;
  10. use Symfony\Component\HttpFoundation\Response;
  11. use Symfony\Component\Routing\RouterInterface;
  12. use Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorageInterface;
  13. use Symfony\Component\HttpFoundation\Session\SessionInterface;
  14. use Aviatur\GeneralBundle\Services\AviaturErrorHandler;
  15. use Aviatur\TwigBundle\Services\TwigFolder;
  16. use Aviatur\GeneralBundle\Services\AviaturWebService;
  17. use Aviatur\GeneralBundle\Controller\OrderController;
  18. use Aviatur\GeneralBundle\Entity\FormUserInfo;
  19. use Aviatur\CustomerBundle\Services\ValidateSanctionsRenewal;
  20. use Aviatur\CustomerBundle\Services\PhoneNumberService;
  21. use Aviatur\GeneralBundle\Services\AviaturChangeCoin;
  22. use Aviatur\GeneralBundle\Services\AviaturEncoder;
  23. use Aviatur\GeneralBundle\Services\AviaturLogSave;
  24. use Aviatur\GeneralBundle\Services\AviaturMailer;
  25. use Aviatur\GeneralBundle\Services\AviaturRestService;
  26. use Aviatur\GeneralBundle\Services\ExceptionLog;
  27. use Aviatur\GiftVoucherBundle\Services\EmissionWebservice;
  28. use Aviatur\PaymentBundle\Controller\P2PController;
  29. use Aviatur\PaymentBundle\Controller\WorldPayController;
  30. use Aviatur\PaymentBundle\Controller\CashController;
  31. use Aviatur\PaymentBundle\Controller\PSEController;
  32. use Aviatur\PaymentBundle\Controller\PSERestController;
  33. use Aviatur\PaymentBundle\Services\CustomerMethodPaymentService;
  34. use Aviatur\PaymentBundle\Services\TokenizerService;
  36. use Knp\Snappy\Pdf;
  38. class GiftVoucherController extends AbstractController
  39. {
  40.     /**
  41.     * @var ManagerRegistry
  42.     */
  43.     protected ManagerRegistry $managerRegistry;
  45.     private \Swift_Mailer $mailer;
  47.     /**
  48.     * @var SessionInterface
  49.     */
  50.     protected $session;
  52.     protected $paymentMethod;
  54.     public function __construct(ManagerRegistry $managerRegistry, \Swift_Mailer $mailer, SessionInterface $session)
  55.     {
  57.         $em = $managerRegistry->getManager();
  58.         $this->mailer = $mailer;
  59.         $paymentMethods = $em->getRepository(\Aviatur\GeneralBundle\Entity\PaymentMethod::class)->findByCode(['pse', 'pseRest']);
  60.         $agencyId = $session->has('agencyId') ? $session->get('agencyId') : 1;
  61.         $agency = $em->getRepository(\Aviatur\AgencyBundle\Entity\Agency::class)->find($agencyId);
  62.         $activePayments = array_filter($paymentMethods, function($payment) use ($agency, $em) {
  63.             $paymentMethodAgency = $em->getRepository(\Aviatur\GeneralBundle\Entity\PaymentMethodAgency::class)
  64.                 ->findOneBy(['agency' => $agency->getId(), 'paymentMethod' => $payment->getId()]);
  65.             return $payment->getIsactive() && $paymentMethodAgency && $paymentMethodAgency->getIsactive();
  66.         });
  68.         switch (count($activePayments)) {
  69.             case 0:
  70.                 $this->paymentMethod = null;
  71.                 break;
  72.             case 1:
  73.                 $this->paymentMethod = reset($activePayments);
  74.                 break;
  75.             default:
  76.                 $paymentMethod = $em->getRepository(\Aviatur\GeneralBundle\Entity\PaymentMethod::class)->findOneByCode('pseRest');
  77.                 $this->paymentMethod = $paymentMethod;
  78.                 break;
  79.         }
  80.     }
  82.     public function searchAction()
  83.     {
  84.         return $this->redirect(
  85.             $this->generateUrl(
  86.                 'aviatur_gift_voucher_home',
  87.                 []
  88.             )
  89.         );
  90.     }
  92.     // Vista Home
  93.     public function indexAction(Request $request, TwigFolder $twigFolder, AviaturErrorHandler $aviaturErrorHandler,ManagerRegistry $registry, SessionInterface $session)
  94.     {
  95.         $em = $registry->getManager();
  96.         // $agencyFolder = $twigFolder->twigFlux();
  97.         // $template = '@AviaturTwig/'.$agencyFolder.'/GiftVoucher/Default/Landing/detail.html.twig';
  98.         $template = '@AviaturTwig/default/Flux/GiftVoucher/Default/Landing/detail.html.twig';
  100.         // Valida la existencia y configuración de tarjeta regalo en la agencia
  101.         $validateAgencyRequest = $this->validateAgencyRequest($session->get('agencyId'), $request, $em, $aviaturErrorHandler, false);
  102.         if(!isset($validateAgencyRequest["agency"])){
  103.             return $this->redirect($validateAgencyRequest);
  104.         }
  106.         if ($twigFolder->twigExists($template)) {
  107.             return $this->render($template, []);
  108.         }
  110.         // optional: handle case where template doesn't exist
  111.         throw $this->createNotFoundException("Template not found: $template");
  112.     }
  114.     // Vista de personalización
  115.     public function personalizeAction(Request $request, TwigFolder $twigFolder, AviaturWebService $aviaturWebService, AviaturErrorHandler $aviaturErrorHandler, ManagerRegistry $registry, SessionInterface $session)
  116.     {
  117.         // Información de agencia
  118.         $em = $registry->getManager();
  120.         // Valida la existencia y configuración de tarjeta regalo en la agencia
  121.         $validateAgencyRequest = $this->validateAgencyRequest($session->get('agencyId'), $request, $em, $aviaturErrorHandler, false);
  122.         if(!isset($validateAgencyRequest["agency"])){
  123.             return $this->redirect($validateAgencyRequest);
  124.         }
  125.         $agency =$validateAgencyRequest["agency"];
  127.         // Array configuración bono de regalo
  128.         $giftVoucherConfigObject = $validateAgencyRequest["giftVoucherConfigObject"];
  129.         $giftVoucherConfigArray = json_decode($giftVoucherConfigObject[0]['params'], true);
  131.         try {
  132.             // Organizar de menor a mayor precio
  133.             usort($giftVoucherConfigArray['fares'], function($a, $b) {
  134.                 return intval($a['value']) <=> intval($b['value']);
  135.             });
  137.             // Crear transactionId
  138.             $transactionIdResponse = $aviaturWebService->loginService('SERVICIO_MPT', 'dummy|http://www.aviatur.com.co/dummy/', []);
  139.             if ('error' == $transactionIdResponse || is_array($transactionIdResponse)) {
  140.                 return $this->redirect($aviaturErrorHandler->errorRedirect($this->generateUrl('aviatur_gift_voucher_home'), '', 'Lo sentimos, estamos experimentando dificultades técnicas en este momento.'));
  141.             }
  142.             $transactionId = (string) $transactionIdResponse;
  144.             // Información a enviar
  145.             $detailData = [
  146.                 'currency' => 'COP',
  147.                 'giftValue' => $giftVoucherConfigArray['minValue'],
  148.                 'arrayImage' => $giftVoucherConfigArray["images"],
  149.                 'giftVoucherFares' => $giftVoucherConfigArray['fares'],
  150.                 'giftVoucherParams' => [
  151.                     'minValue' => $giftVoucherConfigArray['minValue'],
  152.                     'maxValue' => $giftVoucherConfigArray['maxValue'],
  153.                 ],
  154.                 'transactionId' => $transactionId,
  155.                 'safeUrl' => 'https://' . $agency->getDomain(),
  156.             ];
  157.         } catch (\Exception $e) {
  158.             return $this->redirect($aviaturErrorHandler->errorRedirect($this->generateUrl('aviatur_gift_voucher_home'), '', 'Lo sentimos, estamos experimentando dificultades técnicas en este momento. Error en la configuración.'));
  159.         }
  161.         $agencyFolder = $twigFolder->twigFlux();
  162.         return $this->render($twigFolder->twigExists('@AviaturTwig/'.$agencyFolder.'/GiftVoucher/Default/personalize.html.twig'), $detailData);
  163.     }
  165.     // Vista de checkOut
  166.     public function checkoutAction(Request $request, TwigFolder $twigFolder, AviaturWebService $aviaturWebService, AviaturErrorHandler $aviaturErrorHandler, ManagerRegistry $registry, SessionInterface $session, AviaturEncoder $aviaturEncoder)
  167.     {
  168.         $em = $registry->getManager();
  169.         $whitemarkAgency = $em->getRepository(\Aviatur\GeneralBundle\Entity\Whitemark::class)->findOneBy(['referer' => $session->get('whitemark')]);
  170.         // Valida la existencia y configuración de tarjeta regalo en la agencia
  171.         $validateAgencyRequest = $this->validateAgencyRequest($session->get('agencyId'), $request, $em, $aviaturErrorHandler, true);
  172.         if(!isset($validateAgencyRequest["agency"])){
  173.             return $this->redirect($validateAgencyRequest);
  174.         }
  176.          if (null !== $whitemarkAgency) {
  178.             $phonesContact = json_decode($whitemarkAgency->getPhonesContact(), true);
  180.             $whitemarkAgencyDataInfo = [
  181.                 'id'        => $whitemarkAgency->getId(),
  182.                 'name'      => $whitemarkAgency->getName(),
  183.                 'phone'     => $whitemarkAgency->getPhone(),
  184.                 'email'     => $whitemarkAgency->getEmail(),
  185.                 'address'   => $whitemarkAgency->getAddress(),
  186.                 'whatsapp'  => $phonesContact['whatsapp'] ?? null,
  187.             ];
  189.     $session->set('whitemarkData', $whitemarkAgencyDataInfo);
  190. }
  191.         //Información de agencia
  192.         $agency = $validateAgencyRequest["agency"];
  193.         if ($agency->getDomainsecure() == $agency->getDomain() && '443' != $agency->getCustomport()) {
  194.             $safeUrl = 'https://'.$agency->getDomain();
  195.         } else {
  196.             $safeUrl = 'https://'.$agency->getDomainsecure();
  197.         }
  199.         // Información del bono escogido
  200.         $request = !empty($request->request->all()) ? $request->request : $request->query;
  201.         $bonoInfo = $request->all();
  203.         // Obtener el transactionId
  204.         $transactionId = (string) ($bonoInfo["bonoTransactionId"] ?? $bonoInfo['transactionRetryId']);
  206.         // Validar si es reintento de pago
  207.         $isretry = !empty($bonoInfo['transactionRetryId']);
  208.         if($isretry){
  209.             // Si ya no quedan intentos de compra, redirigir al home de bono regalo
  210.             $retryCount = $session->get($transactionId . '[bono][retry]');
  211.             if($retryCount <= 0){
  212.                 $titleError = "Acceso no autorizado";
  213.                 $textError = "Ha sido redirigido al home para que pueda seguir explorando opciones.";
  214.                 return $this->redirect($aviaturErrorHandler->errorRedirectNoEmail($this->generateUrl("aviatur_gift_voucher_home", []), $titleError, $textError));
  215.             }
  217.             // Información de bono regalo seleccionado
  218.             $bonoInfo = json_decode(base64_decode($session->get($transactionId . "[bono][bonoInfo]")), true);
  220.             // Información de formularios de usuario
  221.             $formUserInfo = $em->getRepository(\Aviatur\GeneralBundle\Entity\FormUserInfo::class)->find($session->get($transactionId . '[bono][userInfo]'));
  222.             $decodedResponseInfoUser = json_decode($aviaturEncoder->AviaturDecode($formUserInfo->getInfo(), $formUserInfo->getPublicKey()), true);
  223.             $passangerInfo = $decodedResponseInfoUser["PI"];
  224.             $billingData = $decodedResponseInfoUser["BD"];
  225.         }
  227.         // Validación del precio del bono
  228.         $giftVoucherConfigObject = $validateAgencyRequest["giftVoucherConfigObject"];
  229.         $validatePriceBono = $this->validatePriceBono($giftVoucherConfigObject, $bonoInfo, $aviaturErrorHandler);
  230.         if(!isset($validatePriceBono["giftFarePrice"])){
  231.             return $this->redirect($validatePriceBono);
  232.         }
  234.         // Guardar información de bono regalo, encodeada en session
  235.         $session->set($transactionId . '[bono][bonoInfo]', base64_encode(json_encode($validatePriceBono)));
  237.         // Datos formularios
  238.         $typeGender = $em->getRepository(\Aviatur\CustomerBundle\Entity\Gender::class)->findAll();
  239.         $documentType = $em->getRepository(\Aviatur\CustomerBundle\Entity\DocumentType::class)->findAll();
  240.         $documentPassengerType = $em->getRepository(\Aviatur\CustomerBundle\Entity\DocumentType::class)->findAllActiveConfigured();
  241.         $repositoryDocumentType = $em->getRepository(\Aviatur\CustomerBundle\Entity\DocumentType::class);
  242.         $queryDocumentType = $repositoryDocumentType
  243.                 ->createQueryBuilder('p')
  244.                 ->where('p.paymentcode != :paymentcode')
  245.                 ->setParameter('paymentcode', '')
  246.                 ->getQuery();
  247.         $documentPaymentType = $queryDocumentType->getResult();
  249.         $paymentMethodAgency = $em->getRepository(\Aviatur\GeneralBundle\Entity\PaymentMethodAgency::class)->findBy(['agency' => $agency, 'isactive' => 1]);
  250.         $paymentOptions = [];
  251.         foreach ($paymentMethodAgency as $payMethod) {
  252.             $paymentCode = $payMethod->getPaymentMethod()->getCode();
  253.             if (!in_array($paymentCode, $paymentOptions) && 'safety' != $paymentCode) {
  254.                 $paymentOptions[] = $paymentCode;
  255.             }
  256.         }
  258.         $banks = [];
  259.         if (in_array('pse', $paymentOptions)) {
  260.             $banks = $em->getRepository(\Aviatur\PaymentBundle\Entity\PseBank::class)->findAll();
  261.         }
  263.         $cybersource = [];
  264.         if (in_array('cybersource', $paymentOptions)) {
  265.             $cybersource['merchant_id'] = $paymentMethodAgency[array_search('cybersource', $paymentOptions)]->getSitecode();
  266.             $cybersource['org_id'] = $paymentMethodAgency[array_search('cybersource', $paymentOptions)]->getTrankey();
  267.         }
  268.         foreach ($paymentOptions as $key => $paymentOption) {
  269.             if ('cybersource' == $paymentOption) {
  270.                 unset($paymentOptions[$key]); // strip from other renderizable payment methods
  271.             }
  272.         }
  274.         $conditions = $em->getRepository(\Aviatur\GeneralBundle\Entity\HistoricalInfo::class)->findMessageByAgencyOrNull($agency, 'reservation_conditions');
  275.         $passangerTypes = [];
  276.         $passangerTypes[1]['ADT'] = 1;
  277.         $passangerTypes[1]['CHD'] = 0;
  278.         $passangerTypes[1]['INF'] = 0;
  280.         /* Aplicando para vuelo, pero teniendo cuidado con los otros productos */
  281.         /* Necesitamos crear un arreglo que tenga todos los rangos de IIN asociados a su franquicia y a sus límites de número de tarjeta */
  282.         $iinRecordsArray = $aviaturWebService->getIINRanges($em);
  284.         // prefijos
  285.         $phoneService = new PhoneNumberService($em);
  286.         $phonePrefixes = $phoneService->getActivePrefixes();
  288.         // Respuesta para el checkout
  289.         $detailData = [
  290.             'safeUrl' => $safeUrl,
  291.             'twig_readonly' => $isretry,
  292.             'bonoInfo' => $validatePriceBono,
  293.             'passengers' => $passangerInfo ?? null,
  294.             'billingData' => $billingData ?? null,
  295.             'contactData' => $contactData ?? null,
  296.             'gender' => $typeGender,
  297.             'payment_doc_type' => $documentPaymentType,
  298.             'doc_type' => $documentType,
  299.             'documentPassengerType' => $documentPassengerType,
  300.             'conditions' => $conditions,
  301.             'paymentOptions' => $paymentOptions,
  302.             'cybersource' => $cybersource,
  303.             'ccfranchises' => $iinRecordsArray["ccfranchises"],
  304.             'ccranges' => $iinRecordsArray["ccranges"],
  305.             'banks' => $banks,
  306.             'cards' => $em->getRepository(\Aviatur\GeneralBundle\Entity\Card::class)->findAll(),
  307.             'payment_type_form_name' => 'paymentForm',
  308.             'services' => $passangerTypes,
  309.             'phone_prefixes' => $phonePrefixes,
  310.             'default_country' => 'CO',
  311.             'pse' => 1,
  312.             'isBono' => true
  313.         ];
  315.         // $whatsapp = $session->get('whitemarkDataInfo')['telefono'] ?? $session->get('agencyDataInfo')['agency_phones']['what']['whatsApp'] ?? null;
  317.         $agencyFolder = $twigFolder->twigFlux();
  319.         return $this->render($twigFolder->twigExists('@AviaturTwig/'.$agencyFolder.'/GiftVoucher/Default/checkout.html.twig'), $detailData);
  320.     }
  322.     // Inicio proceso de pago y facturación
  323.     public function prePaymentStep1Action(Request $request, TokenizerService $tokenizer, CustomerMethodPaymentService $customerMethodPaymentService, TokenStorageInterface $tokenStorage, AviaturEncoder $aviaturEncoder, AviaturErrorHandler $aviaturErrorHandler, ManagerRegistry $registry, SessionInterface $session, ParameterBagInterface $parameterBag)
  324.     {
  325.         $em = $registry->getManager();
  327.         // Valida la existencia y configuración de tarjeta regalo en la agencia
  328.         $validateAgencyRequest = $this->validateAgencyRequest($session->get('agencyId'), $request, $em, $aviaturErrorHandler, true);
  329.         if(!isset($validateAgencyRequest["agency"])){
  330.             return $this->json(['error' => true, 'message' => $validateAgencyRequest]);
  331.         }
  333.         // Traer el RQ enviado desde el front
  334.         $request = !empty($request->request->all()) ? $request->request : $request->query;
  335.         $checkoutInfo = $request->all();
  337.         // Obtener el transactionId y guardarlo
  338.         $transactionId = (string) $checkoutInfo["giftCardTransactionId"];
  339.         $transactionIdSessionName = $parameterBag->get('transaction_id_session_name');
  340.         $session->set($transactionIdSessionName, $transactionId);
  342.         // Guardar intentos de compra
  343.         $aviaturPaymentRetryTimes = $parameterBag->get('aviatur_payment_retry_times');
  344.         $retryCount = $session->get($transactionId . '[bono][retry]');
  345.         if($retryCount == null){
  346.             $session->set($transactionId . '[bono][retry]', $aviaturPaymentRetryTimes);
  347.         }
  349.         // Validar si ya hay userInfo en la sesión
  350.         $userInfoBono = $session->get($transactionId . '[bono][userInfo]');
  351.         $isFront = $session->has('operatorId');
  352.         if($userInfoBono != null){
  353.             // Información de formularios de usuario
  354.             $formUserInfo = $em->getRepository(\Aviatur\GeneralBundle\Entity\FormUserInfo::class)->find($userInfoBono);
  355.             $decodedResponseInfoUser = json_decode($aviaturEncoder->AviaturDecode($formUserInfo->getInfo(), $formUserInfo->getPublicKey()), true);
  356.             if (!$isFront) {
  357.                 $decodedResponseInfoUser["PD"] = $checkoutInfo["PD"];
  358.             }
  359.             $checkoutInfo = $decodedResponseInfoUser;
  360.         }else{
  361.             $formUserInfo = new FormUserInfo();
  362.         }
  364.         // Token de la tarjeta, en caso que exista
  365.         $publicKey = $aviaturEncoder->aviaturRandomKey();
  366.         if (isset($checkoutInfo["PD"]["card_num"])) {
  367.             $postDataInfo = $checkoutInfo;
  368.             if (isset($postDataInfo["PD"]["cusPOptSelected"])) {
  369.                 $customerLogin = $tokenStorage->getToken()->getUser();
  370.                 $infoMethodPaymentByClient = $customerMethodPaymentService->getMethodsByCustomer($customerLogin, true);
  371.                 $cardToken = $infoMethodPaymentByClient["info"][$postDataInfo["PD"]["cusPOptSelected"]]["token"];
  372.                 $postDataInfo["PD"]["card_num"] = $cardToken;
  373.             } else {
  374.                 $postDataInfo["PD"]["card_num"] = $tokenizer->getToken($checkoutInfo["PD"]["card_num"]);
  375.             }
  376.             $checkoutInfo["PD"]["card_values"] = ["card_num_token" => $postDataInfo["PD"]["card_num"], "card_num" => $checkoutInfo["PD"]["card_num"]];
  377.         }
  379.         // Encodear y guardar la info de los formularios en la tabla form_user_info
  380.         $postDataInfo = $postDataInfo ?? $checkoutInfo;
  381.         $encodedInfo = $aviaturEncoder->AviaturEncode(json_encode($postDataInfo), $publicKey);
  382.         $formUserInfo->setInfo($encodedInfo);
  383.         $formUserInfo->setPublicKey($publicKey);
  384.         $em->persist($formUserInfo);
  385.         $em->flush();
  387.         // Guardar en session el id de la tabla
  388.         $session->set($transactionId . "[bono][userInfo]", $formUserInfo->getId());
  390.         // Guardar en session el id proveedor de bono regalo
  391.         $provider = $em->getRepository(\Aviatur\MpaBundle\Entity\Provider::class)->findBy(['name' => 'Bono de regalo']);
  392.         $session->set($transactionId.'[bono][provider]', $provider[0]->getProvideridentifier());
  394.         // Información facturador
  395.         $billingData = $checkoutInfo["BD"];
  396.         $customer = null;
  397.         $ordersProduct = null;
  398.         if (!$isFront) {
  399.             $customer = $em->getRepository(\Aviatur\CustomerBundle\Entity\Customer::class)->find($billingData['id']);
  400.             $ordersProduct = $em->getRepository(\Aviatur\GeneralBundle\Entity\OrderProduct::class)->getOrderProductsPending($customer);
  401.         }
  403.         if (null == $ordersProduct) {
  404.             $session->set($transactionId . '[bono][detailDataBono]', json_encode($postDataInfo));
  406.             // Información pasajeros
  407.             $passangersData = $postDataInfo["PI"];
  408.             $passangerNames = [];
  409.             for ($i = 1; $i <= $passangersData['person_count_1']; ++$i) {
  410.                 $passangerNames[] = mb_strtolower($passangersData['first_name_1_'.$i]);
  411.                 $passangerNames[] = mb_strtolower($passangersData['last_name_1_'.$i]);
  412.             }
  414.             $nameWhitelist = $em->getRepository(\Aviatur\GeneralBundle\Entity\NameWhitelist::class)->findLikeWhitelist($passangerNames);
  415.             if (0 == sizeof($nameWhitelist)) {
  416.                 $nameBlacklist = $em->getRepository(\Aviatur\GeneralBundle\Entity\NameBlacklist::class)->findLikeBlacklist($passangerNames);
  417.                 if ((sizeof(preg_grep("/^[a-z- *\.]+$/", $passangerNames)) != (sizeof($passangerNames))) ||
  418.                         (sizeof($nameBlacklist)) ||
  419.                         (sizeof(preg_grep('/(([b-df-hj-np-tv-xz])(?!\2)){4}/', $passangerNames)))) {
  420.                     return $this->json(['error' => 'error', 'message' => 'nombre inválido']);
  421.                 }
  422.             }
  424.             $ajaxUrl = $this->generateUrl('aviatur_gift_voucher_prepayment_step_2_secure');
  425.             return $this->json(['ajax_url' => $ajaxUrl]);
  426.         } else {
  427.             $booking = [];
  428.             $cus = [];
  429.             foreach ($ordersProduct as $orderProduct) {
  430.                 $productResponse = $aviaturEncoder->AviaturDecode($orderProduct->getPayResponse(), $orderProduct->getPublicKey());
  431.                 $paymentResponse = json_decode($productResponse);
  432.                 array_push($booking, "ON" . $orderProduct->getOrder()->getId() . "-PN" . $orderProduct->getId());
  433.                 if (isset($paymentResponse->x_approval_code)) {
  434.                     array_push($cus, $paymentResponse->x_approval_code);
  435.                 } elseif (isset($paymentResponse->createTransactionResult->trazabilityCode)) {
  436.                     array_push($cus, $paymentResponse->createTransactionResult->trazabilityCode);
  437.                 }
  438.             }
  440.             $return = [
  441.                 "error" => "pending_payments",
  442.                 "message" => "pending_payments",
  443.                 "booking" => $booking,
  444.                 // "domain" => $domain ?? null,
  445.                 // "agencyId" => $this->agency ?? null,
  446.                 // "operatorId" => $operatorId ?? null,
  447.                 "cus" => $cus,
  448.             ];
  450.             return new JsonResponse($return);
  451.         }
  452.     }
  454.     // Creación de orden - addProductData
  455.     public function prePaymentStep2Action(Request $request, OrderController $orderController, AviaturErrorHandler $aviaturErrorHandler, ManagerRegistry $registry, SessionInterface $session, ParameterBagInterface $parameterBag, AviaturEncoder $aviaturEncoder)
  456.     {
  457.         $em = $registry->getManager();
  459.         // Valida la existencia y configuración de tarjeta regalo en la agencia
  460.         $validateAgencyRequest = $this->validateAgencyRequest($session->get('agencyId'), $request, $em, $aviaturErrorHandler, true);
  461.         if(!isset($validateAgencyRequest["agency"])){
  462.             return $this->json(['error' => true, 'message' => $validateAgencyRequest]);
  463.         }
  465.         //Información de agencia
  466.         $agency = $validateAgencyRequest["agency"];
  468.         // Traer el RQ enviado desde el front
  469.         $request = !empty($request->request->all()) ? $request->request : $request->query;
  470.         $checkoutInfo = $request->all();
  472.         // Obtener el transactionId
  473.         $transactionIdSessionName = $parameterBag->get('transaction_id_session_name');
  474.         $transactionId = (string) ($checkoutInfo["giftCardTransactionId"] ?? $session->get($transactionIdSessionName));
  476.         // Validar si ya hay userInfo en la sesión
  477.         $userInfoBono = $session->get($transactionId . '[bono][userInfo]');
  478.         $isFront = $session->has('operatorId');
  479.         if($userInfoBono != null){
  480.             // Información de formularios de usuario
  481.             $formUserInfo = $em->getRepository(\Aviatur\GeneralBundle\Entity\FormUserInfo::class)->find($userInfoBono);
  482.             $decodedResponseInfoUser = json_decode($aviaturEncoder->AviaturDecode($formUserInfo->getInfo(), $formUserInfo->getPublicKey()), true);
  483.             if (!$isFront) {
  484.                 $decodedResponseInfoUser["PD"] = $checkoutInfo["PD"];
  485.             }
  486.             $checkoutInfo = $decodedResponseInfoUser;
  487.         }
  489.         // Información facturador
  490.         $billingData = $checkoutInfo['BD'];
  491.         $isFront = $session->has('operatorId');
  492.         if ($isFront) {
  493.             $customer = $billingData;
  494.             $customer['isFront'] = true;
  495.             $status = 'B2T';
  496.         } else {
  497.             $customer = $em->getRepository(\Aviatur\CustomerBundle\Entity\Customer::class)->find($billingData['id']);
  498.             $status = 'waiting';
  499.         }
  501.         $order = [];
  502.         if (true !== $session->has($transactionId.'[bono][order]')) {
  503.             // Crear Order y order product, con add_productData
  504.             $productType = $em->getRepository(\Aviatur\MpaBundle\Entity\ProductType::class)->findByCode('BONO');
  505.             $orderIdentifier = '{booking_id}';
  506.             $order = $orderController->createAction($agency, $customer, $productType, $orderIdentifier, $status);
  507.             $orderId = str_replace('ON', '', $order['order']);
  509.             $orderEntity = $em->getRepository(\Aviatur\GeneralBundle\Entity\Order::class)->find($orderId);
  510.             $formUserInfo = $em->getRepository(\Aviatur\GeneralBundle\Entity\FormUserInfo::class)->find($session->get($transactionId.'[bono][userInfo]'));
  512.             $formUserInfo->setOrder($orderEntity);
  513.             $em->persist($formUserInfo);
  514.             $em->flush();
  515.         }
  517.         // Preparando información para Resume
  518.         $this->prepareInfoResume($session, $registry, $parameterBag, $aviaturEncoder);
  520.         if ($isFront) {
  521.             // Ir a generar bono
  522.             $order['url'] = $this->generateUrl('aviatur_gift_voucher_generar_bono');
  523.         } else {
  524.             // Ir a pago
  525.             $order['url'] = $this->generateUrl('aviatur_gift_voucher_payment_secure');
  526.         }
  528.         return $this->json($order);
  529.     }
  531.     // Proceso de pago
  532.     public function paymentAction(Request $request, OrderController $orderController, \Swift_Mailer $mailer, RouterInterface $router, P2PController $p2pPaymentController, PSEController $psePaymentController, PSERestController $PSERestController, CashController $cashPaymentController, AviaturErrorHandler $aviaturErrorHandler, ManagerRegistry $registry, SessionInterface $session, ParameterBagInterface $parameterBag, TokenizerService $tokenizer, CustomerMethodPaymentService $customerMethodPaymentService, AviaturLogSave $logSave)
  533.     {
  534.         $em = $registry->getManager();
  536.         // Valida la existencia y configuración de tarjeta regalo en la agencia
  537.         $validateAgencyRequest = $this->validateAgencyRequest($session->get('agencyId'), $request, $em, $aviaturErrorHandler, false);
  538.         if(!isset($validateAgencyRequest["agency"])){
  539.             return $this->json(['error' => true, 'message' => $validateAgencyRequest]);
  540.         }
  542.         // Obtener el transactionId
  543.         $transactionIdSessionName = $parameterBag->get('transaction_id_session_name');
  544.         $transactionId = $session->get($transactionIdSessionName);
  546.         // IdOrder y IdOrderProduct
  547.         if (true !== $session->has($transactionId.'[bono][order]')) {
  548.             return $this->redirect($aviaturErrorHandler->errorRedirect($this->generateUrl('aviatur_gift_voucher_home'), '', 'No se encontró orden asociada a este pago.'));
  549.         }
  550.         $orderInfo = json_decode($session->get($transactionId . '[bono][order]'));
  551.         $productId = str_replace('PN', '', $orderInfo->products);
  552.         $orderProduct = $em->getRepository(\Aviatur\GeneralBundle\Entity\OrderProduct::class)->find($productId);
  554.         // Actualizar reintentos de pago
  555.         $retryCount = (int) $session->get($transactionId . '[bono][retry]');
  556.         $session->set($transactionId . '[bono][retry]', $retryCount - 1);
  557.         $arrayResume = json_decode($orderProduct->getResume(), true);
  558.         if (isset($arrayResume["retry_count"])) {
  559.             $arrayResume["retry_count"] = $retryCount - 1;
  560.             $orderProduct->setResume(json_encode($arrayResume));
  561.             $em->persist($orderProduct);
  562.             $em->flush();
  563.         }
  565.         // Obtener la información de la tarjeta regalo desde la sesión
  566.         $bonoInfo = json_decode(base64_decode($session->get($transactionId . "[bono][bonoInfo]")), true);
  568.         // Valores totalizados
  569.         $totalAmountCOP = $bonoInfo["giftFarePrice"];
  570.         $x_amount_tax = number_format(0, 2, '.', '');
  571.         $x_amount_base = number_format(round((float) $totalAmountCOP), 2, '.', '');
  573.         // Descripción del producto
  574.         $description = 'Bono de Regalo - $'.$totalAmountCOP;
  576.         // Id del proveedor
  577.         $providerId = $session->get($transactionId . '[bono][provider]');
  579.         // Obtener información de los formularios del checkOut
  580.         $postData = json_decode($session->get($transactionId . '[bono][detailDataBono]'));
  582.         // Datos de pago y de facturador
  583.         $paymentData = $postData->PD;
  584.         $customer = $em->getRepository(\Aviatur\CustomerBundle\Entity\Customer::class)->find($postData->BD->id);
  585.         $recipientData = $postData->PI;
  587.         // Datos de agencia
  588.         $agency = $validateAgencyRequest["agency"];
  589.         $agencyName = $agency->getName();
  590.         $agencyOfficeId = $agency->getOfficeId();
  592.         // Pago
  593.         if ('p2p' == $paymentData->type) {
  594.             if (false !== strpos($paymentData->address, '***')) {
  595.                 $paymentData->address = $customer->getAddress();
  596.             }
  597.             if (false !== strpos($paymentData->phone, '***')) {
  598.                 $paymentData->phone = $customer->getPhone();
  599.             }
  600.             if (false !== strpos($paymentData->email, '***')) {
  601.                 $paymentData->email = $customer->getEmail();
  602.             }
  604.             $array = [
  605.                 'x_currency_code' => $bonoInfo["currency"],
  606.                 'x_amount' => $totalAmountCOP,
  607.                 'x_tax' => $x_amount_tax,
  608.                 'x_amount_base' => $x_amount_base,
  609.                 'x_invoice_num' => $orderInfo->order . '-' . $orderInfo->products,
  610.                 'x_first_name' => $paymentData->first_name,
  611.                 'x_last_name' => $paymentData->last_name,
  612.                 'x_description' => $description,
  613.                 'x_city' => $customer->getCity()->getIatacode(),
  614.                 'x_country_id' => $customer->getCountry()->getIatacode(),
  615.                 'x_cust_id' => $paymentData->doc_type . ' ' . $paymentData->doc_num,
  616.                 'x_address' => $paymentData->address,
  617.                 'x_phone' => $paymentData->phone,
  618.                 'x_email' => $paymentData->email,
  619.                 'x_card_num' => $paymentData->card_num,
  620.                 'x_exp_date' => $paymentData->exp_month . $paymentData->exp_year,
  621.                 'x_card_code' => $paymentData->card_code,
  622.                 'x_differed' => $paymentData->differed,
  623.                 'x_client_id' => $postData->BD->id,
  624.                 'product_type' => 'bono',
  625.                 'productId' => str_replace('PN', '', $orderInfo->products),
  626.                 'orderId' => str_replace('ON', '', $orderInfo->order),
  627.                 'franchise' => $paymentData->franquise,
  628.                 'worldpay_validate' => true
  629.             ];
  631.             if (isset($paymentData->card_values)) {
  632.                 $array['card_values'] = (array) $paymentData->card_values;
  633.             }
  635.             if (isset($paymentData->cusPOptSelected)) {
  636.                 $array['isToken'] = (string) $paymentData->card_values->card_num_token;
  637.             }
  639.             if (isset($postData->PD->savePaymProc) || (isset($paymentData->cusPOptSelected) && isset($paymentData->cusPOptSelectedStatus) && 'NOTVERIFIED' == $paymentData->cusPOptSelectedStatus)) {
  640.                 $array['x_provider_id'] = 1;
  641.             } elseif (isset($paymentData->cusPOptSelected) && (!isset($paymentData->cusPOptSelectedStatus) || 'NOTVERIFIED' != $paymentData->cusPOptSelectedStatus)) {
  642.                 $array['x_provider_id'] = 2;
  643.             }
  645.             // Servicio de pago (payRequest y PayResponse)
  646.             $paymentResponse = $p2pPaymentController->placetopayAction($parameterBag, $tokenizer, $customerMethodPaymentService, $mailer, $logSave, $array);
  647.             unset($array['x_client_id']);
  648.             if (empty($paymentResponse)) {
  649.                 // No hay respuesta por parte del servicio de pago, estado pendiente
  650.                 $orderProduct->setStatus('pending');
  651.                 $em->persist($orderProduct);
  652.                 $em->flush();
  654.                 $urlRetry = $this->generateUrl('aviatur_gift_voucher_retry_secure', ["transactionRetryId" => $transactionId]);
  655.                 $titleError = "";
  656.                 $textError = "No hay respuesta por parte del servicio de pago, por favor intenta nuevamente o comunícate con nosotros para finalizar tu transacción.";
  657.                 return $this->redirect($aviaturErrorHandler->errorRedirectNoEmail($urlRetry, $titleError, $textError));
  658.             }
  660.             return $this->redirect($this->generateUrl('aviatur_gift_voucher_payment_p2p_secure', [], true));
  662.         } elseif ('pse' == $paymentData->type) {
  663.             $array = [
  664.                 'x_invoice_num' => $orderInfo->order.'-'.$orderInfo->products,
  665.                 'x_doc_num' => $postData->PD->pse_doc_num,
  666.                 'x_doc_type' => $postData->PD->pse_doc_type,
  667.                 //'x_doc_num' => $customer->getDocumentnumber(),
  668.                 //'x_doc_type' => $customer->getDocumentType()->getPaymentcode(),
  669.                 'x_first_name' => $customer->getFirstname(),
  670.                 'x_last_name' => $customer->getLastname(),
  671.                 'x_company' => $agencyName,
  672.                 'x_email' => $customer->getEmail(),
  673.                 'x_address' => $customer->getAddress(),
  674.                 'x_city' => $customer->getCity()->getDescription(),
  675.                 'x_province' => $customer->getCity()->getDescription(),
  676.                 'x_country' => $customer->getCountry()->getDescription(),
  677.                 'x_phone' => $customer->getPhone(),
  678.                 'x_mobile' => $customer->getCellphone(),
  679.                 'x_bank' => $postData->PD->pse_bank,
  680.                 'x_type' => $postData->PD->pse_type,
  681.                 'x_response_url' => $this->generateUrl('aviatur_gift_voucher_payment_pse_return_url_secure', [], true),
  682.                 'x_reference' => $orderInfo->order.'-'.$orderInfo->products,
  683.                 'x_description' => $description,
  684.                 'x_currency' => $bonoInfo["currency"],
  685.                 'x_total_amount' => $totalAmountCOP,
  686.                 'x_tax' => $x_amount_tax,
  687.                 'x_amount_base' => $x_amount_base,
  688.                 'x_devolution_base' => $x_amount_base,
  689.                 'x_tip_amount' => number_format(round(0), 2, '.', ''),
  690.                 'product_type' => 'bono',
  691.                 'x_providerId' => $providerId,
  692.                 'x_transactionId' => $transactionId
  693.             ];
  695.             // Servicio de pago pse - Realizar pago por opcion definida en payment_method
  696.             $paymentCode = $this->paymentMethod->getCode() === 'pse' ? 'pse' : 'pseRest';
  697.             if ($paymentCode === 'pse') {
  698.                 $paymentResponse = $psePaymentController->sendPaymentAction($request, $session, $router, $parameterBag, $mailer, $orderController, $array, [$orderProduct]);
  699.             } else {
  700.                 $paymentResponse = $PSERestController->sendRestPaymentAction($request, $session, $router, $parameterBag, $mailer, $orderController, $array, [$orderProduct], $logSave);
  701.             }
  703.             if (!isset($paymentResponse->error)) {
  704.                 if ($paymentCode === 'pse') {
  705.                     $returnStatusCode = $paymentResponse->createTransactionResult->returnCode;
  706.                     $returnUrl = (string) $paymentResponse->createTransactionResult->bankURL ?? $paymentResponse->createTransactionResult->bankurl;
  707.                 } else {
  708.                     $returnStatusCode = $paymentResponse->status->status;
  709.                     $returnUrl = $paymentResponse->redirection->processURL;
  710.                 }
  712.                 switch ($returnStatusCode) {
  713.                     case 'SUCCESS':
  714.                     case 'PENDING':
  715.                         return $this->redirect($returnUrl);
  716.                     case 'FAIL_EXCEEDEDLIMIT':
  717.                         $textMsg = 'Su reserva fue realizada exitosamente, sin embargo, el monto excede los límites establecidos, comunícate con nosotros a  los teléfonos 57 1 5879640 o 57 1 3821616 o  vía e-mail al correo soportepagoelectronico@aviatur.com.co para completar tu transacción.';
  718.                         return $this->redirect($aviaturErrorHandler->errorRedirect($this->generateUrl('aviatur_gift_voucher_home'), '', $textMsg));
  719.                     case 'FAIL_BANKUNREACHEABLE':
  720.                     case 'FAILED':
  721.                         $textMsg = 'Tu entidad financiera no pudo ser contactada para iniciar la transacción, por favor inténtalo nuevamente.';
  722.                         $urlRetry = $this->generateUrl('aviatur_gift_voucher_retry_secure', ["transactionRetryId" => $transactionId]);
  723.                         return $this->redirect($aviaturErrorHandler->errorRedirect($urlRetry, '', $textMsg));
  724.                     default:
  725.                         $textMsg = 'No se pudo crear la transacción con tu banco, por favor inténtalo nuevamente.';
  726.                         $urlRetry = $this->generateUrl('aviatur_gift_voucher_retry_secure', ["transactionRetryId" => $transactionId]);
  727.                         return $this->redirect($aviaturErrorHandler->errorRedirect($urlRetry, '', $textMsg));
  728.                 }
  729.             } else {
  730.                 $urlRetry = $this->generateUrl('aviatur_gift_voucher_retry_secure', ["transactionRetryId" => $transactionId]);
  731.                 return $this->redirect($aviaturErrorHandler->errorRedirect($urlRetry, 'Error al procesar el pago', 'Ocurrió un problema al intentar crear su transacción, '.$paymentResponse->error));
  732.             }
  733.         } elseif ('cash' == $paymentData->type) {
  734.             // Fecha de creacón de la orden
  735.             $fecha = $orderProduct->getCreationDate()->format('Y-m-d H:i:s');
  736.             $fechalimite = $orderProduct->getCreationDate()->format('Y-m-d 23:40:00');
  737.             $nuevafecha = strtotime('+5 hour', strtotime($fecha));
  738.             $fechavigencia = date('Y-m-d H:i:s', $nuevafecha);
  739.             if (strcmp($fechavigencia, $fechalimite) > 0) {
  740.                 $fechavigencia = $fechalimite;
  741.             }
  743.             // Generar bookingId
  744.             $bookingId = $this->generateRamdonCode();
  746.             $array = [
  747.                 'x_officeId' => $agencyOfficeId,
  748.                 'x_doc_num' => $customer->getDocumentnumber(),
  749.                 'x_doc_type' => $customer->getDocumentType()->getPaymentcode(),
  750.                 'x_first_name' => $customer->getFirstname(),
  751.                 'x_last_name' => $customer->getLastname(),
  752.                 'x_company' => $agencyName,
  753.                 'x_email' => $customer->getEmail(),
  754.                 'x_address' => $customer->getAddress(),
  755.                 'x_city' => $customer->getCity()->getDescription(),
  756.                 'x_province' => $customer->getCity()->getDescription(),
  757.                 'x_country' => $customer->getCountry()->getDescription(),
  758.                 'x_phone' => $customer->getPhone(),
  759.                 'x_mobile' => $customer->getCellphone(),
  760.                 'x_payment_data' => $paymentData->type,
  761.                 'x_booking' => $bookingId,
  762.                 'x_type_description' => $orderProduct->getDescription(),
  763.                 'x_reference' => $orderInfo->products,
  764.                 'x_description' => $description,
  765.                 'x_currency' => $bonoInfo["currency"],
  766.                 'x_total_amount' => $totalAmountCOP,
  767.                 'x_fechavigencia' => $fechavigencia,
  768.                 'x_transactionId' => $transactionId
  769.             ];
  771.             if ($session->has($transactionId.'[bono][detail_cash]')) {
  772.                 $detail_cash = json_decode($session->get($transactionId.'[bono][detail_cash]'));
  773.                 if ('error' == $detail_cash->status) {
  774.                     $cashPay = $cashPaymentController->cashAction($logSave, $array);
  775.                 } else {
  776.                     $cashPay = json_decode($session->get($transactionId.'[bono][detail_cash]'));
  777.                 }
  778.             } else {
  779.                 $cashPay = $cashPaymentController->cashAction($logSave, $array);
  780.                 $session->set($transactionId.'[bono][detail_cash]', json_encode($cashPay));
  781.             }
  783.             if ('ok' == $cashPay->status) {
  784.                 $cashPay->bookingID = $bookingId;
  785.                 $session->set($transactionId.'[bono][cash_result]', json_encode($cashPay));
  786.             } else {
  787.                 $emissionData['x_first_name'] = $array['x_first_name'];
  788.                 $emissionData['x_last_name'] = $array['x_last_name'];
  789.                 $emissionData['x_doc_num'] = $array['x_doc_num'];
  790.                 $emissionData['x_reference'] = $array['x_reference'];
  791.                 $emissionData['x_description'] = $array['x_description'];
  792.                 $emissionData['x_total_amount'] = $array['x_total_amount'];
  793.                 $emissionData['x_email'] = $array['x_email'];
  794.                 $emissionData['x_address'] = $array['x_address'];
  795.                 $emissionData['x_phone'] = $array['x_phone'];
  796.                 $emissionData['x_type_description'] = $array['x_type_description'];
  797.                 $emissionData['x_error'] = $cashPay->status;
  798.                 $mailInfo = print_r($emissionData, true).'<br>'.print_r($cashPay, true);
  799.                 $toEmails = ['soportepagoelectronico@aviatur.com.co', 'soptepagelectronic@aviatur.com', 'errores.prod.web@aviatur.com'];
  800.                 $emailNotification = $parameterBag->get('email_notification');
  801.                 $message = (new \Swift_Message())
  802.                     ->setContentType('text/html')
  803.                     ->setFrom($session->get('emailNoReply'))
  804.                     ->setTo($toEmails)
  805.                     ->setBcc($emailNotification)
  806.                     ->setSubject('Error Creación Transacción Efectivo'.$emissionData['x_reference'])
  807.                     ->setBody($mailInfo);
  808.                 $mailer->send($message);
  810.                 $orderProduct->setEmissiondata('error');
  811.                 $orderProduct->setUpdatingdate(new \DateTime());
  812.                 $em->persist($orderProduct);
  813.                 $em->flush();
  815.                 $urlRetry = $this->generateUrl('aviatur_gift_voucher_retry_secure', ["transactionRetryId" => $transactionId]);
  816.                 return $this->redirect($aviaturErrorHandler->errorRedirect($urlRetry, 'Error al procesar el pago', 'Ocurrió un problema al intentar crear su transacción.'));
  818.             }
  820.             $urlPayment = 'aviatur_gift_voucher_payment_cash_return_url_secure';
  821.             return $this->redirect($this->generateUrl($urlPayment));
  823.         } else {
  824.             $urlRetry = $this->generateUrl('aviatur_gift_voucher_retry_secure', ["transactionRetryId" => $transactionId]);
  825.             return $this->redirect($aviaturErrorHandler->errorRedirect($urlRetry, '', 'El tipo de pago es inválido.'));
  826.         }
  827.     }
  829.     // Creación XML updatePaymentData y Control de estados de pago para P2P
  830.     public function p2pCallbackAction(ManagerRegistry $registry, CustomerMethodPaymentService $customerMethodPaymentService, OrderController $orderController, TokenStorageInterface $tokenStorage, AviaturEncoder $aviaturEncoder, AviaturErrorHandler $aviaturErrorHandler, SessionInterface $session, ParameterBagInterface $parameterBag, EmissionWebservice $emmisionWebService, ValidateSanctionsRenewal $validateSanctions)
  831.     {
  832.         $em = $registry->getManager();
  834.         // Obtener el transactionId
  835.         $transactionIdSessionName = $parameterBag->get('transaction_id_session_name');
  836.         $transactionId = $session->get($transactionIdSessionName);
  838.         // IdOrder y IdOrderProduct
  839.         if (true !== $session->has($transactionId.'[bono][order]')) {
  840.             return $this->redirect($aviaturErrorHandler->errorRedirect($this->generateUrl('aviatur_gift_voucher_home'), '', 'No se encontró orden asociada a este pago.'));
  841.         }
  842.         $orderInfo = json_decode($session->get($transactionId . '[bono][order]'));
  843.         $productId = str_replace('PN', '', $orderInfo->products);
  844.         $orderProduct = $em->getRepository(\Aviatur\GeneralBundle\Entity\OrderProduct::class)->find($productId);
  846.         // Obtener información de los formularios del checkOut
  847.         $detailInfo = json_decode($session->get($transactionId . '[bono][detailDataBono]'));
  849.         // Obtener la información de la tarjeta regalo desde la sesión
  850.         $bonoInfo = json_decode(base64_decode($session->get($transactionId . "[bono][bonoInfo]")), true);
  852.         // Traer información de pago
  853.         $decodedRequest = json_decode($aviaturEncoder->AviaturDecode($orderProduct->getPayrequest(), $orderProduct->getPublicKey()));
  854.         $decodedResponse = json_decode($aviaturEncoder->AviaturDecode($orderProduct->getPayresponse(), $orderProduct->getPublicKey()));
  856.         if (null != $decodedResponse) {
  857.             // Actualizar pago
  858.             $orderController->updatePaymentAction($orderProduct);
  860.             // Generar bookingId
  861.             $bookingId = $this->generateRamdonCode();
  862.             $twig = '';
  864.             // Datos para bono y email
  865.             $agency = $em->getRepository(\Aviatur\AgencyBundle\Entity\Agency::class)->find($session->get('agencyId'));
  866.             $agencyFolder = $agency->getAssetsFolder();
  867.             $voucherData = [
  868.                 'empresaId' => $agencyFolder == "octopus" ? '54' : '10',
  869.                 'productId' => $productId,
  870.                 'bonoId' => $bookingId,
  871.                 'ammount' => $decodedRequest->x_amount,
  872.                 'currency' => $bonoInfo["currency"],
  873.                 'documentNumber' => $orderProduct->getOrder()->getCustomer()->getDocumentnumber(),
  874.                 'status' => 'EMT',
  875.                 'documentType' => $orderProduct->getOrder()->getCustomer()->getDocumentType()->getExternalcode(),
  876.                 'name' => $orderProduct->getOrder()->getCustomer()->getFirstname().' '.$orderProduct->getOrder()->getCustomer()->getLastname(),
  877.                 'email' => $orderProduct->getOrder()->getCustomer()->getEmail(),
  878.                 'phone' => $orderProduct->getOrder()->getCustomer()->getPhone(),
  879.                 'recipient_name' => $detailInfo->PI->first_name_1_1.' '.$detailInfo->PI->last_name_1_1,
  880.                 'recipient_mail' => $detailInfo->PI->email_1_1,
  881.                 'recipient_phone' => $detailInfo->CD->phone,
  882.                 'recipient_document' => $detailInfo->PI->doc_num_1_1,
  883.             ];
  885.             // Twigs y status de acuerdo al estado de pago
  886.             $bonoResult = "";
  887.             switch ($decodedResponse->x_response_code) {
  888.                 case isset($decodedResponse->x_response_code_cyber) && (2 == $decodedResponse->x_response_code_cyber):
  889.                     //rechazado cybersource
  890.                     $parameters = $em->getRepository(\Aviatur\GeneralBundle\Entity\Parameter::class)->findOneByName('aviatur_switch_rechazada_cyber');
  891.                     if ($parameters && 1 == $parameters->getValue() && 1 == $decodedResponse->x_response_code) {
  892.                         if (isset($detailInfo->PD->cusPOptSelected) && isset($detailInfo->PD->cusPOptSelectedStatus) && 'NOTVERIFIED' == $detailInfo->PD->cusPOptSelectedStatus) {
  893.                             $detailInfo->PD->cusPOptSelectedStatus = 'ACTIVE';
  894.                             $customerLogin = $tokenStorage->getToken()->getUser();
  895.                             $customerMethodPaymentService->setMethodsByCustomer($customerLogin, json_decode(json_encode($detailInfo), true));
  896.                         }
  897.                         if (isset($detailInfo->PD->savePaymProc)) {
  898.                             $customerLogin = $tokenStorage->getToken()->getUser();
  899.                             $customerMethodPaymentService->setMethodsByCustomer($customerLogin, json_decode(json_encode($detailInfo), true));
  900.                         }
  901.                     }
  902.                     $twig = 'aviatur_gift_voucher_payment_rejected_secure';
  903.                     $bookingId = 'PN' . $orderProduct->getId();
  904.                     break;
  905.                 case 3:// pendiente p2p
  906.                     $twig = '' != $twig ? $twig : 'aviatur_gift_voucher_payment_pending_secure';
  907.                     $bonoResult = '{booking_id2}';
  908.                     $orderProduct->setEmissiondata($bookingId);
  909.                     $orderProduct->setEmail(json_encode($voucherData));
  910.                     $orderProduct->setUpdatingdate(new \DateTime());
  911.                     break;
  912.                     // no break
  913.                 case 2:// rechazada p2p
  914.                     $twig = '' != $twig ? $twig : 'aviatur_gift_voucher_payment_rejected_secure';
  915.                     $bookingId = 'PN' . $orderProduct->getId();
  916.                     break;
  917.                 case 1:// aprobado p2p
  918.                     if (isset($detailInfo->PD->cusPOptSelected) && isset($detailInfo->PD->cusPOptSelectedStatus) && 'NOTVERIFIED' == $detailInfo->PD->cusPOptSelectedStatus) {
  919.                         $detailInfo->PD->cusPOptSelectedStatus = 'ACTIVE';
  920.                         $customerLogin = $tokenStorage->getToken()->getUser();
  921.                         $customerMethodPaymentService->setMethodsByCustomer($customerLogin, json_decode(json_encode($detailInfo), true));
  922.                     }
  923.                     if (isset($detailInfo->PD->savePaymProc)) {
  924.                         $customerLogin = $tokenStorage->getToken()->getUser();
  925.                         $customerMethodPaymentService->setMethodsByCustomer($customerLogin, json_decode(json_encode($detailInfo), true));
  926.                     }
  928.                     $emitirBono = $this->emitirBono($emmisionWebService, $session, $orderProduct, $voucherData, $productId, $transactionId, $bookingId);
  929.                     $orderProduct = $emitirBono["orderProduct"];
  930.                     $bonoResult = $emitirBono["bonoResult"];
  931.                     $twig = 'aviatur_gift_voucher_payment_success_secure';
  932.                     break;
  933.                 default: //error p2p - case 0, 4, others
  934.                     $twig = 'aviatur_gift_voucher_payment_error_secure';
  935.                     $bookingId = '';
  936.             }
  938.             // Update Payment
  939.             $orderUpdatePayment = str_replace(
  940.                 ['{product_id}', '{booking_id}', '{booking_id2}'],
  941.                 [$orderProduct->getId(), $bookingId, $bonoResult],
  942.                 $orderProduct->getUpdatePaymentData()
  943.             );
  944.             $orderProduct->setUpdatePaymentData($orderUpdatePayment);
  946.             // Update AddProductData
  947.             $orderAddProduct = str_replace(
  948.                 ['{booking_id}', '{booking_id2}', '{reference_number}'],
  949.                 [$bookingId, $bonoResult, $bookingId],
  950.                 $orderProduct->getAddProductData()
  951.             );
  952.             $orderProduct->setAddProductData($orderAddProduct);
  954.             // Ejecución
  955.             $orderProduct->setBooking($bookingId);
  956.             $em->persist($orderProduct);
  957.             $em->flush($orderProduct);
  959.             /* Pero solo si hay condicionados (no bloqueados) y que paguen con Tarjeta */
  960.             if ($session->has('Marked_users')) {
  961.                 $validateSanctions->sendMarkedEmail($orderInfo, $session, $agency, $orderProduct, $transactionId, 'bono');
  962.             }
  964.             return $this->redirect($this->generateUrl($twig));
  965.         } else {
  966.             // No hay respuesta por parte del servicio de pago, estado pendiente
  967.             $orderProduct->setStatus('pending');
  968.             $em->persist($orderProduct);
  969.             $em->flush();
  971.             $urlRetry = $this->generateUrl('aviatur_gift_voucher_retry_secure', ["transactionRetryId" => $transactionId]);
  972.             return $this->redirect($aviaturErrorHandler->errorRedirect($urlRetry, '', 'No hay respuesta por parte del servicio de pago.'));
  973.         }
  974.     }
  976.     // Creación XML updatePaymentData y Control de estados de pago para PSE
  977.     public function pseCallbackAction(ManagerRegistry $registry, PSEController $psePaymentController, PSERestController $PSERestController, OrderController $orderController, AviaturEncoder $aviaturEncoder, AviaturErrorHandler $aviaturErrorHandler, SessionInterface $session, ParameterBagInterface $parameterBag, EmissionWebservice $emmisionWebService, AviaturLogSave $logSave)
  978.     {
  979.         $em = $registry->getManager();
  981.         // Obtener el transactionId
  982.         $transactionIdSessionName = $parameterBag->get('transaction_id_session_name');
  983.         $transactionId = $session->get($transactionIdSessionName);
  985.         // IdOrder y IdOrderProduct
  986.         if (true !== $session->has($transactionId.'[bono][order]')) {
  987.             return $this->redirect($aviaturErrorHandler->errorRedirect($this->generateUrl('aviatur_gift_voucher_home'), '', 'No se encontró orden asociada a este pago.'));
  988.         }
  989.         $orderInfo = json_decode($session->get($transactionId . '[bono][order]'));
  990.         $productId = str_replace('PN', '', $orderInfo->products);
  991.         $orderProduct = $em->getRepository(\Aviatur\GeneralBundle\Entity\OrderProduct::class)->find($productId);
  993.         // Obtener información de los formularios del checkOut
  994.         $detailInfo = json_decode($session->get($transactionId . '[bono][detailDataBono]'));
  996.         // Traer información de pago
  997.         $decodedRequest = json_decode($aviaturEncoder->AviaturDecode($orderProduct->getPayrequest(), $orderProduct->getPublicKey()));
  998.         $decodedResponse = json_decode($aviaturEncoder->AviaturDecode($orderProduct->getPayresponse(), $orderProduct->getPublicKey()));
  1000.         if (!isset($decodedResponse) && !isset($decodedResponse->createTransactionResult) && !isset($decodedResponse->createTransactionPaymentResponseInformation)) {
  1001.             $urlRetry = $this->generateUrl('aviatur_gift_voucher_retry_secure', ["transactionRetryId" => $transactionId]);
  1002.             return $this->redirect($aviaturErrorHandler->errorRedirect($urlRetry, '', 'No se encontró información de la transacción.'));
  1003.         }
  1005.         // Consultar respuesta de pago de acuerdo a la opcion definida en payment_method
  1006.         $paymentCode = $this->paymentMethod->getCode() === 'pse' ? 'pse' : 'pseRest';
  1007.         $pseTransactionId = '';
  1008.         if ($paymentCode === 'pse') {
  1009.             if (isset($decodedResponse->createTransactionResult)) {
  1010.                 $pseTransactionId = $decodedResponse->createTransactionResult->transactionID ?? $decodedResponse->createTransactionResult->trazabilityCode;
  1011.             } elseif (isset($decodedResponse->createTransactionPaymentResponseInformation)) {
  1012.                 $pseTransactionId = $decodedResponse->createTransactionPaymentResponseInformation->transactionID ?? $decodedResponse->createTransactionPaymentResponseInformation->trazabilityCode;
  1013.             }
  1014.             $paymentResponse = json_decode($psePaymentController->pseCallbackAction($orderController, $pseTransactionId, $decodedResponse));
  1015.             $orderController->updatePaymentAction($orderProduct);
  1016.         } else {
  1017.             $pseTransactionId = $decodedResponse->internalReference;
  1018.             $paymentResponse = $PSERestController->getTransactionInfo($pseTransactionId);
  1019.             $logSave->logSave(json_encode($paymentResponse), '_pseRest', $decodedRequest->payment->reference .'_RS', $pseTransactionId);
  1020.             $orderController->updateRestPaymentAction($orderProduct);
  1021.         }
  1023.         // Generar bookingId
  1024.         $bookingId = $this->generateRamdonCode();
  1026.         // Valor total
  1027.         $totalAmount = $decodedRequest->payment->amount->total ?? $decodedRequest->x_total_amount;
  1028.         $currency = $decodedRequest->payment->amount->currency ?? $decodedRequest->x_currency;
  1030.         // Datos para bono y email
  1031.         $agency = $em->getRepository(\Aviatur\AgencyBundle\Entity\Agency::class)->find($session->get('agencyId'));
  1032.         $agencyFolder = $agency->getAssetsFolder();
  1033.         $voucherData = [
  1034.             'empresaId' => $agencyFolder == "octopus" ? '54' : '10',
  1035.             'productId' => $productId,
  1036.             'bonoId' => $bookingId,
  1037.             'ammount' => $totalAmount,
  1038.             'currency' => $currency,
  1039.             'documentNumber' => $orderProduct->getOrder()->getCustomer()->getDocumentnumber(),
  1040.             'status' => 'EMT',
  1041.             'documentType' => $orderProduct->getOrder()->getCustomer()->getDocumentType()->getExternalcode(),
  1042.             'name' => $orderProduct->getOrder()->getCustomer()->getFirstname().' '.$orderProduct->getOrder()->getCustomer()->getLastname(),
  1043.             'email' => $orderProduct->getOrder()->getCustomer()->getEmail(),
  1044.             'phone' => $orderProduct->getOrder()->getCustomer()->getPhone(),
  1045.             'recipient_name' => $detailInfo->PI->first_name_1_1.' '.$detailInfo->PI->last_name_1_1,
  1046.             'recipient_mail' => $detailInfo->PI->email_1_1,
  1047.             'recipient_phone' => $detailInfo->CD->phone,
  1048.             'recipient_document' => $detailInfo->PI->doc_num_1_1,
  1049.         ];
  1051.         if (!isset($paymentResponse->error)) {
  1052.             if ($paymentCode === 'pse') {
  1053.                 if (isset($paymentResponse->getTransactionInformationResponseBody)) {
  1054.                     $decodedResponse->getTransactionInformationResult = $paymentResponse->getTransactionInformationResponseBody;
  1055.                     $paymentResponse->getTransactionInformationResult = $paymentResponse->getTransactionInformationResponseBody;
  1056.                 } else {
  1057.                     $decodedResponse->getTransactionInformationResult = $paymentResponse->getTransactionInformationResult;
  1058.                 }
  1059.             } else {
  1060.                 $decodedResponse->getTransactionInformationResult = $paymentResponse;
  1062.                 // Aplica directamente en pserest, para actualizar la información del update_payment_data
  1063.                 $currentUpdatePaymentData = $orderProduct->getUpdatepaymentdata();
  1064.                 $xmlParcial = substr($currentUpdatePaymentData, strpos($currentUpdatePaymentData, '<FILTRO>') + 8, strpos($currentUpdatePaymentData, '</FILTRO>') - strpos($currentUpdatePaymentData, '<FILTRO>') - 8);
  1065.                 $xmlConvertido = \simplexml_load_string($xmlParcial);
  1067.                 // Asignación de valores para update_payment_data (afectando name y reason_code, no se toca el ID)
  1068.                 $xmlConvertido->products->product->payment_data->state->reason_code = $decodedResponse->getTransactionInformationResult->status->reason;
  1069.                 $decodeMessage = $this->changeAcutes($decodedResponse->getTransactionInformationResult->status->message);
  1070.                 $xmlConvertido->products->product->payment_data->state->name = $decodeMessage;
  1071.                 $xmlDefinitivo = $xmlConvertido->asXML();
  1072.                 $xmlDefinitivo = str_replace('<?xml version="1.0"?>', '', $xmlDefinitivo);
  1073.                 $newUpdatePaymentData = str_replace('<FILTRO>'.$xmlParcial.'</FILTRO>', '<FILTRO>'.$xmlDefinitivo.'</FILTRO>', $currentUpdatePaymentData);
  1074.                 $orderProduct->setUpdatepaymentdata($newUpdatePaymentData);
  1075.             }
  1077.             // Actualizar payResponse con el estado de pago
  1078.             $orderProduct->setPayresponse($aviaturEncoder->AviaturEncode(json_encode($decodedResponse), $orderProduct->getPublicKey()));
  1079.             $orderProduct->setUpdatingdate(new \DateTime());
  1080.             $em->persist($orderProduct);
  1081.             $em->flush();
  1083.             // Obtener el valor de returCode para continuar con logica existente
  1084.             $returnCodeStatus = 'SUCCESS';
  1085.             if ((!isset($paymentResponse->getTransactionInformationResult->returnCode) || 'SUCCESS' != (string) $paymentResponse->getTransactionInformationResult->returnCode) && !isset($paymentResponse->status->status))
  1086.             {
  1087.                 $returnCodeStatus = (string) $paymentResponse->getTransactionInformationResult->returnCode;
  1088.             }
  1090.             // Twigs y status de acuerdo al estado de pago
  1091.             $twig = '';
  1092.             $bonoResult = "";
  1093.             if ('SUCCESS' == (string) $returnCodeStatus) {
  1094.                 $statusResponse = $paymentResponse->getTransactionInformationResult->transactionState ?? $paymentResponse->status->status;
  1095.                 switch ((string) $statusResponse) {
  1096.                     case 'OK':
  1097.                     case 'APPROVED':
  1098.                         $twig = 'aviatur_gift_voucher_payment_success_secure';
  1099.                         $status = 'approved';
  1100.                         $emitirBono = $this->emitirBono($emmisionWebService, $session, $orderProduct, $voucherData, $productId, $transactionId, $bookingId);
  1101.                         $orderProduct = $emitirBono["orderProduct"];
  1102.                         $bonoResult = $emitirBono["bonoResult"];
  1103.                         break;
  1104.                     case 'PENDING':
  1105.                         $twig = 'aviatur_gift_voucher_payment_pending_secure';
  1106.                         $status = 'pending';
  1107.                         $orderProduct->setEmissiondata($bookingId);
  1108.                         $orderProduct->setEmail(json_encode($voucherData));
  1109.                         $orderProduct->setUpdatingdate(new \DateTime());
  1110.                         $bonoResult = '{booking_id2}';
  1111.                         break;
  1112.                     case 'NOT_AUTHORIZED':
  1113.                     case 'REJECTED':
  1114.                         $bookingId = 'PN' . $orderProduct->getId();
  1115.                         $twig = 'aviatur_gift_voucher_payment_rejected_secure';
  1116.                         $status = 'rejected';
  1117.                         break;
  1118.                     case 'FAILED':
  1119.                         $bookingId = '';
  1120.                         $twig = 'aviatur_gift_voucher_payment_error_secure';
  1121.                         $status = 'failed';
  1122.                         break;
  1123.                 }
  1125.                 // Update Payment
  1126.                 $orderUpdatePayment = str_replace(
  1127.                     ['{product_id}', '{booking_id}', '{booking_id2}'],
  1128.                     [$orderProduct->getId(), $bookingId, $bonoResult],
  1129.                     $orderProduct->getUpdatePaymentData()
  1130.                 );
  1131.                 $orderProduct->setUpdatePaymentData($orderUpdatePayment);
  1133.                 // Update AddProductData
  1134.                 $orderAddProduct = str_replace(
  1135.                     ['{booking_id}', '{booking_id2}', '{reference_number}'],
  1136.                     [$bookingId, $bonoResult, $bookingId],
  1137.                     $orderProduct->getAddProductData()
  1138.                 );
  1139.                 $orderProduct->setAddProductData($orderAddProduct);
  1141.                 $orderProduct->setUpdatePaymentData($orderUpdatePayment);// Update Payment
  1142.                 $orderProduct->setStatus($status);
  1143.                 $orderProduct->getOrder()->setStatus($status);
  1144.                 $orderProduct->setUpdatingdate(new \DateTime());
  1145.                 $orderProduct->getOrder()->setUpdatingdate(new \DateTime());
  1146.                 $orderProduct->setBooking($bookingId);
  1147.                 $em->persist($orderProduct);
  1148.                 $em->flush();
  1150.             } elseif ('FAIL_INVALIDTRAZABILITYCODE' == $returnCodeStatus || 'FAIL_ACCESSDENIED' == $returnCodeStatus || 'FAIL_TIMEOUT' == $returnCodeStatus) {
  1151.                 echo 'En este momento su #<referencia de factura> presenta un proceso de pago cuya transacción se encuentra
  1152.                 PENDIENTE de recibir información por parte de su entidad financiera, por favor espere
  1153.                 unos minutos y vuelva a consultar mas tarde para verificar sí su pago fue confirmado de
  1154.                 forma exitosa. Si desea mayor información sobre el estado actual de su operación puede
  1155.                 comunicarse a nuestras líneas de atención al cliente al teléfono XXXXXX o enviar
  1156.                 inquietudes al email mispagos@micomercio.com y pregunte por el estado de la
  1157.                 transacción <#CUS> .';
  1158.                 $orderProduct->setEmissiondata('error');
  1159.                 $orderProduct->setUpdatingdate(new \DateTime());
  1160.                 $em->persist($orderProduct);
  1161.                 $em->flush();
  1162.                 $twig = 'aviatur_gift_voucher_payment_error_secure';
  1163.             }
  1165.             return $this->redirect($this->generateUrl($twig));
  1166.         } else {
  1167.             $decodedResponse->getTransactionInformationResult = $paymentResponse;
  1168.             $orderProduct->setPayresponse($aviaturEncoder->AviaturEncode(json_encode($decodedResponse), $orderProduct->getPublicKey()));
  1169.             $orderProduct->setUpdatingdate(new \DateTime());
  1170.             $em->persist($orderProduct);
  1171.             $em->flush();
  1173.             $urlRetry = $this->generateUrl('aviatur_gift_voucher_retry_secure', ["transactionRetryId" => $transactionId]);
  1174.             return $this->redirect($aviaturErrorHandler->errorRedirect($urlRetry, '', 'Ocurrió un error al consultar el estado de la transacción.'));
  1175.         }
  1176.     }
  1178.     // Creación  para CASH
  1179.     public function cashCallbackAction(ManagerRegistry $registry, OrderController $orderController, AviaturErrorHandler $aviaturErrorHandler, SessionInterface $session, ParameterBagInterface $parameterBag)
  1180.     {
  1181.         $em = $registry->getManager();
  1183.         // Obtener el transactionId
  1184.         $transactionIdSessionName = $parameterBag->get('transaction_id_session_name');
  1185.         $transactionId = $session->get($transactionIdSessionName);
  1187.         // IdOrder y IdOrderProduct
  1188.         if (true !== $session->has($transactionId.'[bono][order]')) {
  1189.             return $this->redirect($aviaturErrorHandler->errorRedirect($this->generateUrl('aviatur_gift_voucher_home'), '', 'No se encontró orden asociada a este pago.'));
  1190.         }
  1191.         $orderInfo = json_decode($session->get($transactionId . '[bono][order]'));
  1192.         $productId = str_replace('PN', '', $orderInfo->products);
  1193.         $orderProduct = $em->getRepository(\Aviatur\GeneralBundle\Entity\OrderProduct::class)->find($productId);
  1195.         // Obtener información de los formularios del checkOut
  1196.         $detailInfo = json_decode($session->get($transactionId . '[bono][detailDataBono]'));
  1198.         // Obtener la información de la tarjeta regalo desde la sesión
  1199.         $bonoInfo = json_decode(base64_decode($session->get($transactionId . "[bono][bonoInfo]")), true);
  1200.         $totalAmountCOP = $bonoInfo["giftFarePrice"];
  1201.         $currencyBono = $bonoInfo["currency"];
  1203.         if ($session->has($transactionId . '[bono][cash_result]')) {
  1204.             // Obtener BookingId
  1205.             $cashPay = json_decode($session->get($transactionId.'[bono][cash_result]'), true);
  1206.             $bookingId = $cashPay["bookingID"];
  1207.             unset($cashPay["bookingID"]);
  1208.             $session->set($transactionId.'[bono][cash_result]', json_encode($cashPay));
  1210.             // Datos para bono y email
  1211.             $agency = $em->getRepository(\Aviatur\AgencyBundle\Entity\Agency::class)->find($session->get('agencyId'));
  1212.             $agencyFolder = $agency->getAssetsFolder();
  1213.             $voucherData = [
  1214.                 'empresaId' => $agencyFolder == "octopus" ? '54' : '10',
  1215.                 'productId' => $productId,
  1216.                 'bonoId' => $bookingId,
  1217.                 'ammount' => $totalAmountCOP,
  1218.                 'currency' => $currencyBono,
  1219.                 'documentNumber' => $orderProduct->getOrder()->getCustomer()->getDocumentnumber(),
  1220.                 'status' => 'EMT',
  1221.                 'documentType' => $orderProduct->getOrder()->getCustomer()->getDocumentType()->getExternalcode(),
  1222.                 'name' => $orderProduct->getOrder()->getCustomer()->getFirstname().' '.$orderProduct->getOrder()->getCustomer()->getLastname(),
  1223.                 'email' => $orderProduct->getOrder()->getCustomer()->getEmail(),
  1224.                 'phone' => $orderProduct->getOrder()->getCustomer()->getPhone(),
  1225.                 'recipient_name' => $detailInfo->PI->first_name_1_1.' '.$detailInfo->PI->last_name_1_1,
  1226.                 'recipient_mail' => $detailInfo->PI->email_1_1,
  1227.                 'recipient_phone' => $detailInfo->CD->phone,
  1228.                 'recipient_document' => $detailInfo->PI->doc_num_1_1,
  1229.             ];
  1231.             // Actualizar pago en cash
  1232.             $orderController->updatePaymentAction($orderProduct);
  1234.             // Update Payment
  1235.             $orderUpdatePayment = str_replace(
  1236.                 ['{product_id}', '{booking_id}'],
  1237.                 [$orderProduct->getId(), $bookingId],
  1238.                 $orderProduct->getUpdatePaymentData()
  1239.             );
  1240.             $orderProduct->setUpdatePaymentData($orderUpdatePayment);
  1242.             // Update AddProductData
  1243.             $orderAddProduct = str_replace(
  1244.                 ['{product_id}', '{booking_id}'],
  1245.                 [$orderProduct->getId(), $bookingId],
  1246.                 $orderProduct->getAddProductData()
  1247.             );
  1248.             $orderProduct->setAddProductData($orderAddProduct);
  1250.             // Ejecución
  1251.             $orderProduct->setBooking($bookingId);
  1252.             $orderProduct->setEmissiondata($bookingId);
  1253.             $orderProduct->setEmail(json_encode($voucherData));
  1254.             $em->persist($orderProduct);
  1255.             $em->flush($orderProduct);
  1257.             return $this->redirect($this->generateUrl('aviatur_gift_voucher_confirmation_success_secure'));
  1258.         } else {
  1259.             // No hay respuesta por parte del servicio de pago, estado pendiente
  1260.             $orderProduct->setStatus('pending');
  1261.             $em->persist($orderProduct);
  1262.             $em->flush();
  1264.             $urlRetry = $this->generateUrl('aviatur_gift_voucher_retry_secure', ["transactionRetryId" => $transactionId]);
  1265.             return $this->redirect($aviaturErrorHandler->errorRedirect($urlRetry, '', 'No hay respuesta por parte del servicio de pago.'));
  1266.         }
  1267.     }
  1269.     // Generar bono en Front
  1270.     public function generarBonofrontAction(Request $request, ManagerRegistry $registry, AviaturErrorHandler $aviaturErrorHandler, SessionInterface $session, ParameterBagInterface $parameterBag, EmissionWebservice $emmisionWebService)
  1271.     {
  1272.         $em = $registry->getManager();
  1274.         // Valida la existencia y configuración de tarjeta regalo en la agencia
  1275.         $validateAgencyRequest = $this->validateAgencyRequest($session->get('agencyId'), $request, $em, $aviaturErrorHandler, false);
  1276.         if(!isset($validateAgencyRequest["agency"])){
  1277.             return $this->json(['error' => true, 'message' => $validateAgencyRequest]);
  1278.         }
  1280.         // Obtener el transactionId
  1281.         $transactionIdSessionName = $parameterBag->get('transaction_id_session_name');
  1282.         $transactionId = $session->get($transactionIdSessionName);
  1284.         // IdOrder y IdOrderProduct
  1285.         if (true !== $session->has($transactionId.'[bono][order]')) {
  1286.             return $this->redirect($aviaturErrorHandler->errorRedirect($this->generateUrl('aviatur_gift_voucher_home'), '', 'No se encontró orden asociada a este pago.'));
  1287.         }
  1288.         $orderInfo = json_decode($session->get($transactionId . '[bono][order]'));
  1289.         $productId = str_replace('PN', '', $orderInfo->products);
  1290.         $orderProduct = $em->getRepository(\Aviatur\GeneralBundle\Entity\OrderProduct::class)->find($productId);
  1292.         // Obtener la información de la tarjeta regalo desde la sesión
  1293.         $bonoInfo = json_decode(base64_decode($session->get($transactionId . "[bono][bonoInfo]")), true);
  1294.         $totalAmountCOP = $bonoInfo["giftFarePrice"];
  1296.         // Obtener información de los formularios del checkOut
  1297.         $detailInfo = json_decode($session->get($transactionId . '[bono][detailDataBono]'));
  1299.         // Generar bookingId
  1300.         $bookingId = $this->generateRamdonCode();
  1302.         // Información de usuario
  1303.         $datosAgente = simplexml_load_string($session->get('front_user'));
  1305.         // Emitir bono
  1306.         $agency = $em->getRepository(\Aviatur\AgencyBundle\Entity\Agency::class)->find($session->get('agencyId'));
  1307.         $agencyFolder = $agency->getAssetsFolder();
  1308.         $voucherData = [
  1309.             'empresaId' => $agencyFolder == "octopus" ? '54' : '10',
  1310.             'productId' => $productId,
  1311.             'bonoId' => $bookingId,
  1312.             'ammount' => $totalAmountCOP,
  1313.             'currency' => $bonoInfo["currency"],
  1314.             'documentNumber' => $detailInfo->BD->doc_num,
  1315.             'status' => 'EMT',
  1316.             'documentType' => $detailInfo->BD->doc_type,
  1317.             'name' => $detailInfo->BD->first_name.' '.$detailInfo->BD->last_name,
  1318.             'email' => $datosAgente->CORREO_ELECTRONICO,
  1319.             'phone' => $detailInfo->BD->phone,
  1320.             'recipient_name' => $detailInfo->PI->first_name_1_1.' '.$detailInfo->PI->last_name_1_1,
  1321.             'recipient_mail' => $detailInfo->PI->email_1_1,
  1322.             'recipient_phone' => $detailInfo->CD->phone,
  1323.             'recipient_document' => $detailInfo->PI->doc_num_1_1,
  1324.         ];
  1325.         $twig = 'aviatur_gift_voucher_payment_success_secure';
  1326.         $emitirBono = $this->emitirBono($emmisionWebService, $session, $orderProduct, $voucherData, $productId, $transactionId, $bookingId);
  1327.         $orderProduct = $emitirBono["orderProduct"];
  1328.         $bonoResult = $emitirBono["bonoResult"];
  1330.         // Update AddProductData
  1331.         $orderAddProduct = str_replace(
  1332.             ['{booking_id}', '{booking_id2}', '{reference_number}'],
  1333.             [$bookingId, $bonoResult, $bookingId],
  1334.             $orderProduct->getAddProductData()
  1335.         );
  1336.         $orderProduct->setAddProductData($orderAddProduct);
  1338.         // Actualizar bookingId
  1339.         $orderProduct->setBooking($bookingId);
  1340.         $orderProduct->setEmail(json_encode($voucherData));
  1341.         $orderProduct->setUpdatingdate(new \DateTime());
  1342.         $em->persist($orderProduct);
  1343.         $em->flush();
  1345.         return $this->redirect($this->generateUrl($twig));
  1346.     }
  1348.     // Modificación en datos resume en BD y envío de correo
  1349.     public function paymentOutputAction(ManagerRegistry $registry, \Swift_Mailer $mailer, TwigFolder $twigFolder, SessionInterface $session, ParameterBagInterface $parameterBag, AviaturEncoder $aviaturEncoder, Pdf $pdf, ExceptionLog $exceptionLog)
  1350.     {
  1351.         $em = $registry->getManager();
  1353.         // Datos guardados en el resumen
  1354.         $this->prepareInfoResume($session, $registry, $parameterBag, $aviaturEncoder);
  1356.         // Obtener el transactionId
  1357.         $transactionIdSessionName = $parameterBag->get('transaction_id_session_name');
  1358.         $transactionId = $session->get($transactionIdSessionName);
  1360.         // IdOrder y IdOrderProduct
  1361.         $orderInfo = json_decode($session->get($transactionId . '[bono][order]'));
  1362.         $productId = str_replace('PN', '', $orderInfo->products);
  1363.         $orderProduct = $em->getRepository(\Aviatur\GeneralBundle\Entity\OrderProduct::class)->find($productId);
  1365.         // Datos de resumen
  1366.         $resumeData = json_decode($orderProduct->getResume(), true);
  1367.         $resumeData['agencyData']['agency_phones'] = $session->get('agencyDataInfo')['agency_phones'];
  1368.         $paymentResume = $resumeData['paymentResume'];
  1369.         $facturationResume = $resumeData['facturationResume'];
  1370.         $travelers = $resumeData['travelers'];
  1371.         // Agencia
  1372.         $agency = $em->getRepository(\Aviatur\AgencyBundle\Entity\Agency::class)->find($session->get('agencyId'));
  1374.         // Correos destinatarios
  1375.         $giftVoucherConfigObject = $em->getRepository(\Aviatur\GiftVoucherBundle\Entity\ConfigGiftVoucherAgency::class)->findBy(['agency' => $orderProduct->getOrder()->getAgency()]);
  1376.         $toAdminMails = explode(';', $giftVoucherConfigObject[0]->getMails());
  1377.         $sendVoucherBcc = $toAdminMails;
  1378.         $sendVoucherBcc[] = 'notificacionessitioweb@aviatur.com';
  1380.         // Alertas y correos, segun status de cyber
  1381.         $paymentResume['transaction_state_cyber'] = $opResponse->x_response_code_cyber ?? '1';
  1382.         if (2 == $paymentResume['transaction_state_cyber']) {
  1383.             //In case Rejected Cybersource send mail to administratos Aviatur
  1384.             $sendTo = $toAdminMails;
  1385.             $sendVoucherBcc = ['notificacionessitioweb@aviatur.com', 'soptepagelectronic@aviatur.com', 'soportepagoelectronico@aviatur.com.co']; // verificar correos....???
  1386.         }
  1388.         // Enviar correo usuario en caso de pago exitoso
  1389.         if (1 == $paymentResume['transaction_state']) {
  1390.             // TODOSG validar las rutas quemadas
  1391.             $emailCustomMessage = $this->renderView($twigFolder->twigExists('@AviaturTwig/default/Flux/GiftVoucher/Default/emailUserGiftCard.html.twig'), ["resumeData" => $resumeData, 'agencyName' => $session->get('agencyShortName')]);
  1392.             $sendVoucherTo = $sendTo ?? mb_strtolower($travelers[0]['Email']);
  1393.             $message = (new \Swift_Message())
  1394.                     ->setContentType('text/html')
  1395.                     ->setFrom($session->get('emailNoReply'))
  1396.                     ->setTo($sendVoucherTo)
  1397.                     ->setBCC('notificacionessitioweb@aviatur.com')
  1398.                     ->setSubject($session->get('agencyShortName').' - Gracias por su compra - Bono de Regalo')
  1399.                     ->setBody($emailCustomMessage);
  1400.             $mailer->send($message);
  1402.             // Actualizar tabla order-product en campo email
  1403.             $orderProduct->setEmail($emailCustomMessage);
  1404.             $em->persist($orderProduct);
  1405.             $em->flush();
  1407.             // Eliminar lo de session
  1408.             $session->remove($transactionId.'[bono][emission][error]');
  1409.             $session->remove($transactionId . '[bono][retry]');
  1410.             $session->remove($transactionId . "[bono][bonoInfo]");
  1411.             $session->remove($transactionId . '[bono][userInfo]');
  1412.             $session->remove($transactionId.'[bono][provider]');
  1413.             $session->remove($transactionId . '[bono][detailDataBono]');
  1414.         } else if (3 == $paymentResume['transaction_state']){
  1415.             // Datos de la agencia
  1416.             $agencyData = [
  1417.                 'agency_name' => $agency->getName(),
  1418.                 'agency_nit' => $agency->getNit(),
  1419.                 'agency_phone' => $agency->getPhone(),
  1420.                 'agency_email' => $agency->getMailContact(),
  1421.                 'agency_phones' =>  $agency->getPhonescontact()
  1422.             ];
  1424.             // Creación del pdf cuando es CASH
  1425.             if ($resumeData["paymentResume"]["paymentData_type"] == "cash" && !$session->has($transactionId . '[emission_baloto_email]')) {
  1426.                 $agencyFolder = $twigFolder->twigFlux();
  1427.                 $projectDir = $parameterBag->get('kernel.project_dir');
  1428.                 $emailNotification = $parameterBag->get('email_notification');
  1429.                 $voucherFile = $projectDir . '/app/serviceLogs/CashTransaction/' . $paymentResume['id_context'] . '_' . $transactionId . '.pdf';
  1431.                 $paymentResume['exportPDF'] = true;
  1432.                 $paymentResume['infos'][0]['agencyData'] = $agencyData;
  1433.                 $paymentResume['infos'][0]['paymentResume']['id'] = $paymentResume['id_context'];
  1434.                 $paymentResume['infos'][0]['paymentResume']['total_amount'] = $paymentResume['total_amount'];
  1435.                 $paymentResume['infos'][0]['paymentResume']['fecha_vigencia'] = $paymentResume['fecha_vigencia'];
  1436.                 $paymentResume['infos'][0]['paymentResume']['description'] = $paymentResume['description'];
  1438.                 // $ruta = '@AviaturTwig/' . $agencyFolder . '/General/Templates/email_cash.html.twig';
  1439.                 $ruta = '@AviaturTwig/default/Flux/GiftVoucher/Default/emailCashGiftCard.html.twig';
  1440.                 if (!file_exists($voucherFile)) {
  1441.                     $pdf->generateFromHtml($this->renderView($twigFolder->twigExists($ruta), $paymentResume), $voucherFile);
  1442.                 }
  1444.                 $clientEmail = $paymentResume['client_email'];
  1445.                 $setTo = ['soportepagoelectronico@aviatur.com.co', 'soptepagelectronic@aviatur.com', $clientEmail];
  1446.                 $paymentResume['exportPDF'] = false;
  1448.                 $message = (new \Swift_Message())
  1449.                     ->setContentType('text/html')
  1450.                     ->setFrom($session->get('emailNoReply'))
  1451.                     ->setTo($setTo)
  1452.                     ->setBcc($emailNotification)
  1453.                     ->setSubject($session->get('agencyShortName').' - '.'Transacción Efectivo Creada '.$paymentResume['id_context'])
  1454.                     ->attach(\Swift_Attachment::fromPath($voucherFile))
  1455.                     ->setBody(
  1456.                         $this->renderView($twigFolder->twigExists($ruta), $paymentResume)
  1457.                 );
  1458.                 try {
  1459.                     $mailer->send($message);
  1460.                     $session->set($transactionId.'[emission_baloto_email]', 'emailed');
  1461.                 } catch (\Exception $ex) {
  1462.                     $exceptionLog->log(var_dump($message), $ex);
  1463.                 }
  1464.             }
  1465.         }
  1467.         // Correo de gracias por su compra
  1468.         if (2 != $paymentResume['transaction_state_cyber'] && $resumeData["paymentResume"]["paymentData_type"] != "cash" ){
  1469.             $emailCustomerBody['admin'] = false;
  1470.             $emailCustomMessage = $this->renderView($twigFolder->twigExists('@AviaturTwig/default/Flux/GiftVoucher/Default/emailThankYouPage.html.twig'), ['emailBodyContent' => $emailCustomerBody, "resumeData" => $resumeData, 'agencyName'=> $session->get('agencyShortName')]);
  1471.             $emailFacturation = $facturationResume["customer_email"];
  1472.             if (false !== strpos($emailFacturation, '***')) {
  1473.                 $detailInfo = json_decode($session->get($transactionId . '[bono][detailDataBono]'));
  1474.                 $customer = $em->getRepository(\Aviatur\CustomerBundle\Entity\Customer::class)->find($detailInfo->BD->id);
  1475.                 $emailFacturation = $customer->getEmail();
  1476.             }
  1477.             $sendThankYouPage = $sendTo ?? $emailFacturation;
  1479.             $message = (new \Swift_Message())
  1480.                     ->setContentType('text/html')
  1481.                     ->setFrom($session->get('emailNoReply'))
  1482.                     ->setTo($sendThankYouPage)
  1483.                     ->setBCC($sendVoucherBcc)
  1484.                     ->setSubject($session->get('agencyShortName').' - Bono de Regalo')
  1485.                     ->setBody($emailCustomMessage);
  1486.             $mailer->send($message);
  1487.         }
  1489.         // Correo a administrador
  1490.         $emailAdminBody['admin'] = true;
  1491.         $emailAdminBody['messageText'] = 'Se ha realizado una compra de un bono de regalo virtual con los siguientes datos,<br> favor hacer las verificaciones correspondientes en sus respectivos departamentos.';
  1492.         if (2 == $paymentResume['transaction_state_cyber'] && 1 == $paymentResume['transaction_state']) {
  1493.             $emailAdminBody['cyberReject'] = '<strong>ATENCIÓN!!!</strong> <br> <p>El Pago fué exitoso pero la transacción fué Rechazada por Cybersource. Por favor confirmar con el Departamento de Control Pago Electrónico la validez de la misma y en caso positivo realizar envío del Bono de Regalo al cliente.</p>';
  1494.             $rejectAlertText = ' - **RECHAZO CYBERSOURCE**';
  1495.         }
  1496.         // TODOSG validar las rutas quemadas
  1497.         $emailAdminMessage = $this->renderView($twigFolder->twigExists('@AviaturTwig/default/Flux/GiftVoucher/Default/emailThankYouPage.html.twig'), ['emailBodyContent' => $emailAdminBody, "resumeData" => $resumeData]);
  1498.         $messageAdmin = (new \Swift_Message())
  1499.                 ->setContentType('text/html')
  1500.                 ->setFrom($session->get('emailNoReply'))
  1501.                 ->setTo($toAdminMails)
  1502.                 ->setBCC(['notificacionessitioweb@aviatur.com', 'soptepagelectronic@aviatur.com', 'soportepagoelectronico@aviatur.com.co'])
  1503.                 ->setSubject($session->get('agencyShortName').' - Se ha generado un Bono de Regalo con pago en estado ' . $orderProduct->getStatus())
  1504.                 ->setBody($emailAdminMessage);
  1505.         $mailer->send($messageAdmin);
  1507.         $urlResume = $this->generateUrl('aviatur_gift_voucher_thank_you_page_secure');
  1508.         return $this->redirect($urlResume);
  1509.     }
  1511.     // Vista de gracias por tu compra
  1512.     public function thankYouPageAction(SessionInterface $session, ManagerRegistry $registry, TwigFolder $twigFolder, ParameterBagInterface $parameterBag, AviaturErrorHandler $aviaturErrorHandler)
  1513.     {
  1514.         $em = $registry->getManager();
  1516.         // Obtener el transactionId
  1517.         $transactionIdSessionName = $parameterBag->get('transaction_id_session_name');
  1518.         $transactionId = $session->get($transactionIdSessionName);
  1520.         // Obtener order_product
  1521.         if (true !== $session->has($transactionId.'[bono][order]')) {
  1522.             return $this->redirect($aviaturErrorHandler->errorRedirect($this->generateUrl('aviatur_gift_voucher_home'), '', 'No se encontró orden asociada a este pago.'));
  1523.         }
  1524.         $orderProductCode = $session->get($transactionId . '[bono][order]');
  1525.         $productId = str_replace('PN', '', json_decode($orderProductCode)->products);
  1526.         $orderProduct = $em->getRepository(\Aviatur\GeneralBundle\Entity\OrderProduct::class)->find($productId);
  1528.         // Datos de resumen
  1529.         $resumeData = json_decode($orderProduct->getResume(), true);
  1531.         // Renderizar vista de thakyou page
  1532.         $agencyFolder = $twigFolder->twigFlux();
  1533.         //$urlResume = $twigFolder->twigExists('@AviaturTwig/'.$agencyFolder.'/GiftVoucher/Default/resume.html.twig');
  1534.         // TODOSG validar las rutas quemadas
  1535.         $urlResume = $twigFolder->twigExists('@AviaturTwig/default/Flux/GiftVoucher/Default/resume.html.twig', ['agencyName' => $session->get('agencyShortName')]);
  1536.         $resumeMessage = $this->render(
  1537.             $urlResume,
  1538.             array_merge(
  1539.                 $resumeData,
  1540.                 ['agencyName' => $session->get('agencyShortName')]
  1541.             )
  1542.         );
  1544.         return $resumeMessage;
  1545.     }
  1547.     // Valida la existencia y configuración de tarjeta regalo en la agencia
  1548.     // Retorna una respuesta de error con redirección si la validación falla
  1549.     private function validateAgencyRequest($idAgency, $request, $em, $aviaturErrorHandler, $validateRQ)
  1550.     {
  1551.         // Si $request NO es null, validamos la petición
  1552.         if ($validateRQ && empty($request->query->all()) && empty($request->request->all())) {
  1553.             $titleError = "Sección no disponible";
  1554.             $textError = "Ha sido dirigido a la página de personalización para continuar explorando opciones sin inconvenientes.";
  1555.             return $aviaturErrorHandler->errorRedirect($this->generateUrl("aviatur_gift_voucher_personalize", []), $titleError, $textError);
  1556.         }
  1558.         // Información de agencia
  1559.         $agency = $em->getRepository(\Aviatur\AgencyBundle\Entity\Agency::class)->find($idAgency);
  1560.         if (!isset($agency)) {
  1561.             $host = ($request !== null) ? $request->getHost() : 'desconocido';
  1562.             $titleError = "No se encontró la agencia con el dominio: " . $host;
  1563.             $textError = "Lo sentimos, ha sido redirigido al home para que pueda seguir explorando opciones.";
  1564.             return $aviaturErrorHandler->errorRedirect($this->generateUrl('aviatur_general_homepage'), $titleError, $textError);
  1565.         }
  1567.         // Configuración de precios y códigos de bono de regalo en BD
  1568.         $giftVoucherConfigObject = $em->getRepository(\Aviatur\GiftVoucherBundle\Entity\ConfigGiftVoucherAgency::class)
  1569.             ->findParamsByAgency($agency);
  1570.             
  1571.         if (empty($giftVoucherConfigObject) || (is_countable($giftVoucherConfigObject) && count($giftVoucherConfigObject) == 0)) {
  1572.             return $aviaturErrorHandler->errorRedirect($this->generateUrl('aviatur_general_homepage'), 'Acceso no autorizado', 'No se encontró configuración para esta Agencia.');
  1573.         }
  1575.         // Validar que se creo bien el objeto
  1576.         $giftVoucherConfigArray = json_decode($giftVoucherConfigObject[0]['params'], true);
  1577.         if (empty($giftVoucherConfigArray)) {
  1578.             return $aviaturErrorHandler->errorRedirect($this->generateUrl('aviatur_general_homepage'), '', 'Lo sentimos, se ha redirigido a la página de inicio para continuar explorando opciones, debido a inconvenientes técnicos en la configuración.');
  1579.         }
  1581.         // Si todo está OK, no hay error
  1582.         return [
  1583.             "agency" => $agency,
  1584.             "giftVoucherConfigObject" => $giftVoucherConfigObject
  1585.         ];
  1586.     }
  1588.     // Validación del precio del bono
  1589.     // Retorna una respuesta de error con redirección si la validación falla
  1590.     private function validatePriceBono($giftVoucherConfigObject, $bonoInfo, $aviaturErrorHandler)
  1591.     {
  1592.         $giftVoucherConfigArray = json_decode($giftVoucherConfigObject[0]['params'], true);
  1593.         if (ctype_digit($bonoInfo["giftFareCode"])) {
  1594.             // Si es un número entero en string, parsear y asignar directamente
  1595.             $bonoInfo["giftFarePrice"] = (int) $bonoInfo["giftFareCode"];
  1596.             $bonoInfo["giftFareCode"] = "";
  1597.         } else {
  1598.             // Si no es numérico, buscar en $giftVoucherConfigArray['fares'] el que coincida en 'code'
  1599.             $matchedFare = array_values(array_filter($giftVoucherConfigArray['fares'], function($fare) use ($bonoInfo) {
  1600.                 return isset($fare['code']) && $fare['code'] === $bonoInfo["giftFareCode"];
  1601.             }));
  1603.             if(empty($matchedFare) || empty($matchedFare[0]['value'])){
  1604.                 $titleError = "El valor de la tarjeta es inválido.";
  1605.                 $textError = "Ha sido redirigido a la personalización de la tarjeta para que pueda seguir explorando opciones.";
  1606.                 return $aviaturErrorHandler->errorRedirect($this->generateUrl("aviatur_gift_voucher_personalize"), $titleError, $textError);
  1607.             }
  1608.             $bonoInfo["giftFarePrice"] = $matchedFare[0]['value'];
  1609.         }
  1611.         // Si el precio no está dentro del rango
  1612.         if($giftVoucherConfigArray['minValue'] > $bonoInfo["giftFarePrice"] || $bonoInfo["giftFarePrice"] > $giftVoucherConfigArray['maxValue']){
  1613.             $titleError = "El valor de la tarjeta no está dentro de los rangos.";
  1614.             $textError = "Ha sido redirigido a la personalización de la tarjeta para que pueda seguir explorando opciones.";
  1615.             return $aviaturErrorHandler->errorRedirect($this->generateUrl("aviatur_gift_voucher_personalize"), $titleError, $textError);
  1616.         }
  1618.         $bonoInfo["currency"] = "COP";
  1619.         return $bonoInfo;
  1620.     }
  1622.     // Generar código para bookingId
  1623.     private function generateRamdonCode($length = 10)
  1624.     {
  1625.         $characters = '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ';
  1626.         $charactersLength = strlen($characters);
  1627.         $randomString = '';
  1628.         for ($i = 0; $i < $length; ++$i) {
  1629.             $randomString .= $characters[random_int(0, $charactersLength - 1)];
  1630.         }
  1631.         $randomCRC = crc32(date('Y-m-d H:i:s'));
  1632.         $randomCode = substr($randomString, 0, 5).substr($randomCRC, 1, 5);
  1634.         return $randomCode;
  1635.     }
  1637.     // Servicio de emissión de la tarjeta regalo
  1638.     private function emitirBono(EmissionWebservice $emissionWebservice, SessionInterface $session, $orderProduct, $voucherData, $productId, $transactionId, $bookingId)
  1639.     {
  1640.         $sendVoucherStatus = $emissionWebservice->callServiceEmission('purchaseBonus', $voucherData, $productId);
  1641.         if (isset($sendVoucherStatus['error'])) {
  1642.             $session->set($transactionId.'[bono][emission][error]', true);
  1643.             $resultBono = 'EmissionError';
  1645.             // Correo de solicitud de generación de bono internamente
  1646.             $ordersIdsString = $orderProduct->getOrder() . '-PN' . $productId;
  1647.             $emailContent = '
  1648.                 <b>Error de emisión: emitir el bono internamente.</b><br/>
  1649.                 Info:<br/>
  1650.                 The booking id is: ' . $bookingId . '<br/>
  1651.                 The reference id is: ' . $ordersIdsString . '<br/>
  1652.                 The data is: ' . json_encode($voucherData)
  1653.             ;
  1655.             $message = (new \Swift_Message())
  1656.                 ->setContentType('text/html')
  1657.                 ->setFrom($session->get('emailNoReply'))
  1658.                 ->setSubject($session->get('agencyShortName').' - Bono with approved payment: Bono NOT issued')
  1659.                 ->setTo(['soptepagelectronic@aviatur.com', 'soportepagoelectronico@aviatur.com.co'])
  1660.                 ->setBcc(['notificacionessitioweb@aviatur.com'])
  1661.                 ->setBody($emailContent)
  1662.             ;
  1663.             $this->mailer->send($message);
  1664.         } else {
  1665.             $resultBono = $sendVoucherStatus->purchaseBonusResult;
  1666.         }
  1667.         $orderProduct->setEmissiondata($bookingId.'-'.$resultBono);
  1669.         return [
  1670.             "orderProduct" => $orderProduct,
  1671.             "bonoResult" => $resultBono
  1672.         ];
  1673.     }
  1675.     // Funcion para guardar info en resume, BD
  1676.     public function prepareInfoResume(SessionInterface $session, ManagerRegistry $registry, ParameterBagInterface $parameterBag, AviaturEncoder $aviaturEncoder)
  1677.     {
  1678.         $em = $registry->getManager();
  1680.         // Obtener el transactionId
  1681.         $transactionIdSessionName = $parameterBag->get('transaction_id_session_name');
  1682.         $transactionId = $session->get($transactionIdSessionName);
  1684.         // IdOrder y IdOrderProduct
  1685.         $orderInfo = json_decode($session->get($transactionId . '[bono][order]'));
  1686.         $productId = str_replace('PN', '', $orderInfo->products);
  1687.         $orderProduct = $em->getRepository(\Aviatur\GeneralBundle\Entity\OrderProduct::class)->find($productId);
  1689.         // Request y response de respuesta de pago
  1690.         $opRequest = json_decode($aviaturEncoder->AviaturDecode($orderProduct->getPayrequest(), $orderProduct->getPublicKey()));
  1691.         $opResponse = json_decode($aviaturEncoder->AviaturDecode($orderProduct->getPayResponse(), $orderProduct->getPublicKey()));
  1693.         // Obtener información de los formularios del checkOut
  1694.         $detailInfo = json_decode($session->get($transactionId . '[bono][detailDataBono]'));
  1696.         // Información de medio de pago
  1697.         $isFront = $session->has('operatorId');
  1698.         if (!$isFront) {
  1699.             $paymentData = $detailInfo->PD;
  1700.         }
  1702.         // Mapeo de información
  1703.         if ((null != $opRequest) && (null != $opResponse)) {
  1704.             $resumeData = json_decode($orderProduct->getResume(), true);
  1705.             if (isset($opResponse->x_franchise) && ('' != $opResponse->x_franchise)) {
  1706.                 $franquiceCode = str_replace(['CR_', 'RM_', 'CDNSA'], ['', '', 'CS'], $opResponse->x_franchise);
  1707.                 $clientFranquice = $em->getRepository(\Aviatur\GeneralBundle\Entity\Card::class)->findOneByPaymentgatewaycode($franquiceCode);
  1708.                 if(empty($clientFranquice)){
  1709.                     $franquiceCode = str_replace(['CR_', 'RM_', 'CDNSA'], ['', '', 'CS'], $opRequest->franchise);
  1710.                     $clientFranquice = $em->getRepository(\Aviatur\GeneralBundle\Entity\Card::class)->findOneByPaymentgatewaycode($franquiceCode);
  1711.                 }
  1712.             } else {
  1713.                 $clientFranquice['description'] = 'error';
  1714.             }
  1716.             // paymentResume de acuerdo a la respuesta del pago
  1717.             if (isset($opResponse->x_description)) {
  1718.                 $paymentResume = [
  1719.                     'transaction_state' => $opResponse->x_response_code,
  1720.                     'ta_transaction_state' => $opResponse->x_ta_response_code,
  1721.                     'id' => $orderProduct->getBooking(),
  1722.                     'id_context' => $opRequest->x_invoice_num,
  1723.                     'total_amount' => $opResponse->x_amount,
  1724.                     'currency' => $opResponse->x_bank_currency,
  1725.                     'amount' => 0 != $opRequest->x_amount_base ? $opRequest->x_amount_base : $opResponse->x_amount,
  1726.                     'iva' => $opRequest->x_tax,
  1727.                     'ip_address' => $opRequest->x_customer_ip,
  1728.                     'bank_name' => $opResponse->x_bank_name,
  1729.                     'client_franquice' => ['description' => (is_object($clientFranquice) ? $clientFranquice->getDescription() : $clientFranquice['description'])],
  1730.                     'cuotas' => $opRequest->x_differed,
  1731.                     'card_num' => '************'.substr($opRequest->x_card_num, strlen($opRequest->x_card_num) - 4),
  1732.                     'reference' => $opResponse->x_transaction_id,
  1733.                     'auth' => $opResponse->x_approval_code,
  1734.                     'transaction_date' => $opResponse->x_transaction_date,
  1735.                     'description' => $opResponse->x_description,
  1736.                     'reason_code' => $opResponse->x_response_reason_code,
  1737.                     'reason_description' => $opResponse->x_response_reason_text,
  1738.                     'client_names' => $opResponse->x_first_name.' '.$opResponse->x_last_name,
  1739.                     'client_email' => $opResponse->x_email,
  1740.                 ];
  1741.             } elseif (isset($opRequest->infoCash)) {
  1742.                 $paymentResume = [
  1743.                     'transaction_state' => 3,
  1744.                     'id' => $orderProduct->getBooking(),
  1745.                     'id_context' => $opRequest->infoCash->x_reference,
  1746.                     'currency' => $opRequest->infoCash->x_currency,
  1747.                     'total_amount' => $opRequest->infoCash->x_total_amount,
  1748.                     'client_franquice' => ['description' => 'Efectivo'],
  1749.                     'amount' => $opRequest->infoCash->x_total_amount,
  1750.                     'iva' => null,
  1751.                     'ip_address' => $opRequest->infoCash->dirIp,
  1752.                     'airport_tax' => null,
  1753.                     'reference' => $opRequest->infoCash->x_reference,
  1754.                     'auth' => null,
  1755.                     'transaction_date' => $opRequest->infoCash->x_fechavigencia,
  1756.                     'description' => $opRequest->infoCash->x_description,
  1757.                     'reason_code' => 101,
  1758.                     'reason_description' => 'Transacción creada',
  1759.                     'client_names' => $opRequest->infoCash->x_first_name.' '.$opRequest->infoCash->x_last_name,
  1760.                     'client_email' => $opRequest->infoCash->x_email,
  1761.                     'fecha_vigencia' => $opRequest->infoCash->x_fechavigencia,
  1762.                 ];
  1764.                 // En caso de error en la emision de cash
  1765.                 $cash_result = json_decode($session->get($transactionId.'[bono][cash_result]'));
  1766.                 if ('' == $cash_result) {
  1767.                     $paymentResume['transaction_state'] = 2;
  1768.                 }
  1769.             } else {
  1770.                 // Obtener codigo de banco por metodo de pago seleccionado
  1771.                 $paymentCode = $this->paymentMethod->getCode() === 'pse' ? 'pse' : 'pseRest';
  1772.                 if ($paymentCode === 'pse') {
  1773.                     $bank_code = isset($opRequest->bankCode) ? (int) $opRequest->bankCode : 0;
  1774.                 } else {
  1775.                     $bank_code = isset($opRequest->instrument->redirection->additional->bankCode) ? (int) $opRequest->instrument->redirection->additional->bankCode : 0;
  1776.                 }
  1778.                 $bank_info = $em->getRepository(\Aviatur\PaymentBundle\Entity\PseBank::class)->findOneByCode($bank_code);
  1779.                 $bank_name = $bank_info->getName();
  1780.                 $devolutionBase = $paymentCode === 'pse' ? $opRequest->devolutionBase ?? $opRequest->x_devolution_base : 0;
  1781.                 $taxAmount = $paymentCode === 'pse' ? $opRequest->taxAmount ?? $opRequest->x_tax_amount : 0;
  1782.                 $totalAmount = $paymentCode === 'pse' ? $opRequest->totalAmount ?? $opRequest->x_total_amount : $opRequest->payment->amount->total;
  1783.                 if ((0 == $devolutionBase) && (0 == $taxAmount)) {
  1784.                     $addProductXml = explode('FILTRO', $orderProduct->getAddproductdata());
  1785.                     $addProductObj = \simplexml_load_string('<FILTRO' . $addProductXml[1] . 'FILTRO>');
  1786.                     $amount = (string) $addProductObj->data->product->fare_data->fare->base_amount;
  1787.                     $airportTax = $totalAmount - $amount;
  1788.                 } else {
  1789.                     $amount = $devolutionBase;
  1790.                     $airportTax = $totalAmount - ($devolutionBase + $taxAmount);
  1791.                 }
  1793.                 if($paymentCode != 'pse' && isset($opResponse->getTransactionInformationResult->status->status)) {
  1794.                     switch ($opResponse->getTransactionInformationResult->status->status) {
  1795.                         case 'OK':
  1796.                         case 'APPROVED':
  1797.                         case 'APPROVED_PARTIAL':
  1798.                         case 1:
  1799.                             $opResponse->getTransactionInformationResult->status->status = "1";
  1800.                             break;
  1801.                         case 'REJECTED':
  1802.                         case 'PARTIAL_EXPIRED':
  1803.                         case 'NOT_AUTHORIZED':
  1804.                         case 2:
  1805.                             $opResponse->getTransactionInformationResult->status->status = "2";
  1806.                             break;
  1807.                         case strpos($opResponse->getTransactionInformationResult->status->status, "PENDING"):
  1808.                         case 'MANUAL':
  1809.                         case 3:
  1810.                             $opResponse->getTransactionInformationResult->status->status = "3";
  1811.                             break;
  1812.                         default:
  1813.                             $opResponse->getTransactionInformationResult->status->status = "0";
  1814.                             break;
  1815.                     }
  1816.                 }
  1818.                 $responseCode = $paymentCode === 'pse' ? $opResponse->getTransactionInformationResult->responseCode ?? $opResponse->getTransactionInformationResult->transactionState
  1819.                     : $opResponse->getTransactionInformationResult->status->status;
  1820.                 $currency = $paymentCode === 'pse' ? $opRequest->currency ?? $opRequest->x_currency
  1821.                     : $opRequest->payment->amount->currency ?? $opRequest->x_currency;
  1822.                 $reference = $paymentCode === 'pse' ? $opRequest->reference ?? $opRequest->x_reference
  1823.                     : $opRequest->payment->reference ?? $opRequest->x_reference;
  1824.                 $transactionID = $paymentCode === 'pse' ? $opResponse->createTransactionResult->transactionID ?? $opResponse->id_transaccion
  1825.                     : $opResponse->getTransactionInformationResult->receipt ?? $opResponse->internalReference ?? $opResponse->id_transaccion;
  1826.                 $responseReasonCode = $paymentCode === 'pse' ? $opResponse->getTransactionInformationResult->responseReasonCode ?? null
  1827.                     : $opResponse->getTransactionInformationResult->status->reason ?? null;
  1828.                 $responseReasonText = $paymentCode === 'pse' ? $opResponse->getTransactionInformationResult->responseReasonText ?? null
  1829.                     : $opResponse->getTransactionInformationResult->status->message ?? null;
  1830.                 $description = $paymentCode === 'pse' ? $opRequest->description ?? $opRequest->x_description
  1831.                     : $opRequest->payment->description ?? $opRequest->x_description;
  1832.                 $emailAddress = $paymentCode === 'pse' ? $opRequest->payer->emailAddress ?? $opRequest->x_email
  1833.                     : $opRequest->payer->email ?? $opRequest->x_email;
  1834.                 $auth = $paymentCode === 'pse' ? $opResponse->getTransactionInformationResult->trazabilityCode : $opResponse->getTransactionInformationResult->authorization ?? $opResponse->getTransactionInformationResult->receipt;
  1835.                 $transactionDate = $paymentCode === 'pse' ? $opResponse->getTransactionInformationResult->bankProcessDate : $opResponse->getTransactionInformationResult->status->date;
  1836.                 $clientNames = $paymentCode === 'pse' ? $opRequest->payer->firstName . ' ' . $opRequest->payer->lastName : $opRequest->payer->name . ' ' . $opRequest->payer->surname;
  1838.                 /* Datos complementarios */
  1839.                 $payerDocumentNumber = ($opRequest->payer->document ?? $opRequest->x_cust_id);
  1840.                 $payerMobile = $opRequest->payer->mobile ?? $opRequest->x_phone ?? '';
  1841.                 $fee_base = $opRequest->feeBase ?? $opRequest->x_service_fee_base ?? 0;
  1842.                 $fee_tax = $opRequest->feeTax ?? $opRequest->x_service_fee_tax ?? 0;
  1844.                 $paymentResume = [
  1845.                     'transaction_state' => $responseCode,
  1846.                     'id' => $orderProduct->getBooking(),
  1847.                     'id_context' => $reference,
  1848.                     'currency' => $currency,
  1849.                     'total_amount' => $totalAmount,
  1850.                     'amount' => $amount,
  1851.                     'base_amount' => number_format(round((float) $totalAmount), 2, '.', ''),
  1852.                     'iva' => $taxAmount,
  1853.                     'airport_tax' => $airportTax,
  1854.                     'ip_address' => $opRequest->ipAddress,
  1855.                     'bank_name' => $bank_name,
  1856.                     'client_franquice' => ['description' => is_object($clientFranquice) ? $clientFranquice->getDescription() : 'PSE'],
  1857.                     'reference' => $transactionID,
  1858.                     'auth' => $auth,
  1859.                     'transaction_date' => $transactionDate,
  1860.                     'description' => $description,
  1861.                     'reason_code' => $responseReasonCode,
  1862.                     'reason_description' => $responseReasonText,
  1863.                     'client_names' => $clientNames,
  1864.                     'client_email' => $emailAddress,
  1865.                     'client_document_number' => $payerDocumentNumber,
  1866.                     'client_phone' => $payerMobile,
  1867.                     'card_num' => '--',
  1868.                     'cuotas' => '--',
  1869.                     'fee_base' => $fee_base,
  1870.                     'fee_tax' => $fee_tax,
  1871.                 ];
  1872.             }
  1874.             // Mapear estado de cyber y tipo de pago
  1875.             $paymentResume['transaction_state_cyber'] = $opResponse->x_response_code_cyber ?? '1';
  1876.             $paymentResume['paymentData_type'] = $paymentData->type ?? null;
  1877.             $resumeData["paymentResume"] = $paymentResume;
  1879.             // Formatear datos de facturador en caso de auto-complete
  1880.             $facturationResume = $resumeData["facturationResume"];
  1881.             if (1 == $paymentResume['transaction_state'] && false !== strpos($facturationResume["customer_names"], '***')) {
  1882.                 $customer = $em->getRepository(\Aviatur\CustomerBundle\Entity\Customer::class)->find($detailInfo->BD->id);
  1883.                 $facturationResume = [
  1884.                     'customer_names' => $customer->getFirstname().' '.$customer->getLastname(),
  1885.                     'customer_address' => $customer->getAddress(),
  1886.                     'customer_doc_num' => $customer->getDocumentnumber(),
  1887.                     'customer_phone' => $customer->getPhone(),
  1888.                     'customer_email' => $customer->getEmail(),
  1889.                 ];
  1890.                 $resumeData["facturationResume"] = $facturationResume;
  1891.             }
  1892.         } else {
  1893.             // Información agencia
  1894.             $agency = $em->getRepository(\Aviatur\AgencyBundle\Entity\Agency::class)->find($session->get("agencyId"));
  1895.             $agencyData = [
  1896.                 "agency_name" => $agency->getName(),
  1897.                 "agency_nit" => $agency->getNit(),
  1898.                 "agency_phone" => $agency->getPhone(),
  1899.                 "agency_email" => $agency->getMailContact(),
  1900.             ];
  1902.             //  Cantidad de intentos
  1903.             $retryCount = (int) $session->get($transactionId . "[bono][retry]");
  1905.             // Obtener la información de la tarjeta regalo desde la sesión
  1906.             $bonoInfo = json_decode(base64_decode($session->get($transactionId . "[bono][bonoInfo]")), true);
  1908.             // Información pasajeros
  1909.             $passenger = $detailInfo->PI;
  1912.             if (false !== strpos($passenger->first_name_1_1, '***')) {
  1913.                 $customer = $em->getRepository(\Aviatur\CustomerBundle\Entity\Customer::class)->find($detailInfo->BD->id);
  1914.                 $passenger->first_name_1_1 = $customer->getFirstname();
  1915.                 $passenger->last_name_1_1 = $customer->getLastname();
  1916.                 $passenger->phone_1_1 = $customer->getPhone();
  1917.                 $passenger->email_1_1 = $customer->getEmail();
  1918.                 $passenger->address_1_1 = $customer->getAddress();
  1919.                 $passenger->doc_num_1_1 = $customer->getDocumentnumber();
  1920.             }
  1922.             $passangersData = json_decode(json_encode($passenger), true);
  1923.             $travelers = [];
  1924.             for ($i = 1; $i <= $passangersData["person_count_1"]; ++$i) {
  1925.                 $travelers[] = [
  1926.                     'typeCode' => $passangersData['passanger_type_1_'.$i],
  1927.                     'GivenName' => $passangersData['first_name_1_'.$i],
  1928.                     'Surname' => $passangersData['last_name_1_'.$i],
  1929.                     'Email' => $passangersData['email_1_'.$i],
  1930.                     'Phone' => $detailInfo->CD->phone,
  1931.                     'Doc_type' => $passangersData['doc_type_1_'.$i],
  1932.                     'Doc_number' => $passangersData['doc_num_1_'.$i],
  1933.                 ];
  1934.             }
  1936.             // Información del facturador
  1937.             $factInfo = $detailInfo->BD;
  1938.             $facturationResume = [
  1939.                 "customer_names" => $factInfo->first_name . " " . $factInfo->last_name,
  1940.                 "customer_address" => $factInfo->address ?? null,
  1941.                 "customer_doc_num" => $factInfo->doc_num,
  1942.                 "customer_phone" => $factInfo->phone,
  1943.                 "customer_email" => $factInfo->email ?? null
  1944.             ];
  1946.             // Valor totalizado
  1947.             $totalAmountCOP = $bonoInfo["giftFarePrice"];
  1948.             $x_amount_tax = number_format(0, 2, '.', '');
  1949.             $x_amount_base = (number_format(round((float) $totalAmountCOP), 2, '.', ''));
  1951.             // Descripción del producto
  1952.             $description = 'Bono de Regalo - $'.$totalAmountCOP;
  1954.             // Información de pago
  1955.             $paymentResume = [
  1956.                 'id' => $orderProduct->getBooking(),
  1957.                 'id_context' => $orderInfo->order . '-' . $orderInfo->products,
  1958.                 'total_amount' => $totalAmountCOP,
  1959.                 'amount' => $x_amount_base,
  1960.                 'iva' => $x_amount_tax,
  1961.                 'currency' => $bonoInfo["currency"],
  1962.                 'ip_address' => $this->get_client_ip(),
  1963.                 'reference' => '',
  1964.                 'auth' => '',
  1965.                 'transaction_date' => $orderProduct->getCreationDate()->format('Y-m-d H:i:s'),
  1966.                 'description' => $description,
  1967.                 'reason_code' => '',
  1968.                 'reason_description' => '',
  1969.                 'paymentData_type' => $paymentData->type ?? null
  1970.             ];
  1972.             // Información a guardar en Resume en BD
  1973.             $resumeData = [
  1974.                 'agencyData' => $agencyData,
  1975.                 'retryCount' => $retryCount,
  1976.                 'facturationResume' => $facturationResume,
  1977.                 'bonoInfo' => $bonoInfo,
  1978.                 'paymentResume' => $paymentResume,
  1979.                 'transactionID' => $transactionId,
  1980.                 'travelers' => $travelers
  1981.             ];
  1982.         }
  1984.         // En caso de cash
  1985.         if ($session->has($transactionId . '[bono][cash_result]')) {
  1986.             $resumeData['paymentResume']['cash_result'] = json_decode($session->get($transactionId . '[bono][cash_result]'));
  1988.             // Fecha de creación de la orden
  1989.             $fecha = $orderProduct->getCreationDate()->format('Y-m-d H:i:s');
  1990.             $fechalimite = $orderProduct->getCreationDate()->format('Y-m-d 23:40:00');
  1991.             $nuevafecha = strtotime('+5 hour', strtotime($fecha));
  1992.             $fechavigencia = date('Y-m-d H:i:s', $nuevafecha);
  1993.             if (strcmp($fechavigencia, $fechalimite) > 0) {
  1994.                 $fechavigencia = $fechalimite;
  1995.             }
  1996.             $resumeData['paymentResume']['fecha_vigencia'] = $fechavigencia;
  1998.             // NameArchive pdf en CASH
  1999.             $resumeData['paymentResume']['NameArchive'] = $paymentResume['id_context'] . '_' . $transactionId . '.pdf';
  2000.         }
  2002.          // En caso de ser front
  2003.         if ($isFront) {
  2004.             $resumeData['paymentResume']['transaction_state'] = 1;
  2005.         }
  2007.         // reintento de pago
  2008.         $resumeData['backDetail'] = $this->generateUrl('aviatur_gift_voucher_retry_secure');
  2010.         // En caso de error en la emision del Bono
  2011.         if ($session->has($transactionId.'[bono][emission][error]')) {
  2012.             $resumeData['emission_error'] = true;
  2013.         }
  2015.         $orderProduct->setResume(json_encode($resumeData));
  2016.         $em->persist($orderProduct);
  2017.         $em->flush();
  2018.     }
  2020.     // Obtener ip del cliente
  2021.     private function get_client_ip()
  2022.     {
  2023.         $ipaddress = '';
  2024.         if (getenv('HTTP_CLIENT_IP')) {
  2025.             $ipaddress = getenv('HTTP_CLIENT_IP');
  2026.         } elseif (getenv('HTTP_X_FORWARDED_FOR')) {
  2027.             $ipaddress = getenv('HTTP_X_FORWARDED_FOR');
  2028.         } elseif (getenv('HTTP_X_FORWARDED')) {
  2029.             $ipaddress = getenv('HTTP_X_FORWARDED');
  2030.         } elseif (getenv('HTTP_FORWARDED_FOR')) {
  2031.             $ipaddress = getenv('HTTP_FORWARDED_FOR');
  2032.         } elseif (getenv('HTTP_FORWARDED')) {
  2033.             $ipaddress = getenv('HTTP_FORWARDED');
  2034.         } elseif (getenv('REMOTE_ADDR')) {
  2035.             $ipaddress = getenv('REMOTE_ADDR');
  2036.         } else {
  2037.             $ipaddress = 'UNKNOWN';
  2038.         }
  2040.         return (strpos($ipaddress, ',') !== false) ? trim(explode(',', $ipaddress)[0]) : (substr_count($ipaddress, ':') > 1 ? $ipaddress : explode(':', $ipaddress)[0]);
  2041.     }
  2043.     /**
  2044.      * changeAcutes()
  2045.      * Cambia los acentos para que no lleguen cadenas dañadas a un XML.
  2046.      * Author: Ing. David Rincon
  2047.      * Email: david.rincon@aviatur.com
  2048.      * Date: 2025/05/08
  2049.      * @param $cadena (Cadena original)
  2050.      * @return $cadena (Cadena sin acentos)
  2051.      */
  2052.     function changeAcutes($cadena){
  2053.         //Reemplazamos la A y a
  2054.         $cadena = str_replace(
  2055.             array('Á', 'À', 'Â', 'Ä', 'á', 'à', 'ä', 'â', 'ª'),
  2056.             array('A', 'A', 'A', 'A', 'a', 'a', 'a', 'a', 'a'),
  2057.             $cadena );
  2059.         //Reemplazamos la E y e
  2060.         $cadena = str_replace(
  2061.             array('É', 'È', 'Ê', 'Ë', 'é', 'è', 'ë', 'ê'),
  2062.             array('E', 'E', 'E', 'E', 'e', 'e', 'e', 'e'),
  2063.             $cadena );
  2065.         //Reemplazamos la I y i
  2066.         $cadena = str_replace(
  2067.             array('Í', 'Ì', 'Ï', 'Î', 'í', 'ì', 'ï', 'î'),
  2068.             array('I', 'I', 'I', 'I', 'i', 'i', 'i', 'i'),
  2069.             $cadena );
  2071.         //Reemplazamos la O y o
  2072.         $cadena = str_replace(
  2073.             array('Ó', 'Ò', 'Ö', 'Ô', 'ó', 'ò', 'ö', 'ô'),
  2074.             array('O', 'O', 'O', 'O', 'o', 'o', 'o', 'o'),
  2075.             $cadena );
  2077.         //Reemplazamos la U y u
  2078.         $cadena = str_replace(
  2079.             array('Ú', 'Ù', 'Û', 'Ü', 'ú', 'ù', 'ü', 'û'),
  2080.             array('U', 'U', 'U', 'U', 'u', 'u', 'u', 'u'),
  2081.             $cadena );
  2083.         //Reemplazamos la N, n, C y c
  2084.         $cadena = str_replace(
  2085.             array('Ñ', 'ñ', 'Ç', 'ç'),
  2086.             array('N', 'n', 'C', 'c'),
  2087.             $cadena );
  2089.         return $cadena;
  2090.     }
  2091. }