src/Aviatur/CustomerBundle/Controller/DefaultController.php line 648

Open in your IDE?
  1. <?php
  3. namespace Aviatur\CustomerBundle\Controller;
  5. use Aviatur\CustomerBundle\Entity\Customer;
  6. use Aviatur\CustomerBundle\Entity\CustomerBillingList;
  7. use Aviatur\CustomerBundle\Entity\HistoricalCustomer;
  8. use Aviatur\GeneralBundle\Entity\OrderTrace;
  9. use Aviatur\CustomerBundle\Models\CustomerModel;
  10. use Aviatur\CustomerBundle\Services\ValidateSanctionsRenewal;
  11. use Aviatur\FormBundle\Entity\Newsletter;
  12. use Aviatur\GeneralBundle\Services\AviaturAthServices;
  13. use Aviatur\GeneralBundle\Services\AviaturEncoder;
  14. use Aviatur\GeneralBundle\Services\AviaturErrorHandler;
  15. use Aviatur\GeneralBundle\Services\AviaturLoginService;
  16. use Aviatur\GeneralBundle\Services\AviaturWebService;
  17. use Aviatur\PaymentBundle\Entity\PaymentMethodCustomer;
  18. use Aviatur\PaymentBundle\Services\CustomerMethodPaymentService;
  19. use Aviatur\PaymentBundle\Services\TokenizerService;
  20. use Aviatur\TwigBundle\Services\TwigFolder;
  21. use DateTime;
  22. use Doctrine\Persistence\ManagerRegistry;
  23. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  24. use Symfony\Component\DependencyInjection\ParameterBag\ParameterBagInterface;
  25. use Symfony\Component\HttpFoundation\JsonResponse;
  26. use Symfony\Component\HttpFoundation\Request;
  27. use Symfony\Component\HttpFoundation\Response;
  28. use Symfony\Component\HttpFoundation\Session\Session;
  29. use Symfony\Component\HttpFoundation\Session\SessionInterface;
  30. use Symfony\Component\Routing\RouterInterface;
  31. use Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorageInterface;
  32. use Symfony\Component\Security\Core\Encoder\UserPasswordEncoderInterface;
  33. use Symfony\Component\Validator\Validator\ValidatorInterface;
  35. class DefaultController extends AbstractController
  36. {
  38.     /**
  39.      * @var \Doctrine\Persistence\ObjectManager
  40.      */
  41.     protected $em;
  43.     /**
  44.      * @var \Aviatur\AgencyBundle\Entity\Agency|object|null
  45.      */
  46.     protected $agency;
  48.     /**
  49.      * @var AviaturAthServices
  50.      */
  51.     protected $athServices;
  53.     /**
  54.      * @var bool
  55.      */
  56.     protected $isAval;
  58.     public function __construct(ManagerRegistry $managerRegistry, SessionInterface $session, AviaturAthServices $athServices)
  59.     {
  60.         $em = $managerRegistry->getManager();
  61.         $agencyId = $session->has('agencyId') ? $session->get('agencyId') : 1;
  62.         $agency = $em->getRepository(\Aviatur\AgencyBundle\Entity\Agency::class)->find($agencyId);
  64.         $this->em = $em;
  65.         $this->agency = $agency;
  66.         $this->athServices = $athServices;
  68.         // Validación para agencia Aval
  69.         if ($agency->getAssetsFolder() == 'aval') {
  70.             $this->isAval = true;
  71.         } else {
  72.             $this->isAval = false;
  73.         }
  74.     }
  76.     public function getDataAction(Request $request, ManagerRegistry $managerRegistry, AviaturWebService $webService, AviaturErrorHandler $errorHandler, TwigFolder $twigFolder, ParameterBagInterface $parameterBag)
  77.     {
  78.         if ($request->isXmlHttpRequest()) {
  79.             $doc_type = $request->query->get('doc_type');
  80.             $documentNumber = $request->query->get('doc_num');
  81.             $em = $managerRegistry->getManager();
  82.             $documentType = $em->getRepository(\Aviatur\CustomerBundle\Entity\DocumentType::class)->findOneByExternalcode($doc_type);
  83.             $data = $em->getRepository(\Aviatur\CustomerBundle\Entity\Customer::class)->findOneBy(['documentType' => $documentType, 'documentnumber' => $documentNumber]);
  84.             if (empty($data)) {
  85.                 //si no encuentra en la base local busca en el servidor de aviatur
  86.                 $customerModel = new CustomerModel();
  87.                 $xmlRequest = $customerModel->getXmlFindUser($doc_type, $documentNumber, '0926EB', 'BOGVU2900');
  88.                 $response = $webService->busWebServiceAmadeus('GENERALLAVE', $parameterBag->get('provider_service'), $xmlRequest);
  89.                 if ((null != $response) && ('error' != $response)) {
  90.                     if (!isset($response['error']) && is_object($response)) {
  91.                         if (('FALLO' == $response->RESULTADO) && (false !== strpos($response->MENSAJE, 'No se enco'))) {
  92.                             return $this->json(['no_info' => (string) $response->MENSAJE]);
  93.                         } elseif (('FALLO' == $response->RESULTADO)) {
  94.                             $errorHandler->errorRedirect('/vuelos/detalle', '', 'Error usuario: '.(string) $response->MENSAJE);
  96.                             return $this->json(['error' => (string) $response->MENSAJE]);
  97.                         } else {
  98.                             $customer = new Customer();
  99.                             $dataNumber = $em->getRepository(\Aviatur\CustomerBundle\Entity\DocumentType::class)->findOneBy(['code' => $response->document->id]);
  100.                             $dataGender = $em->getRepository(\Aviatur\CustomerBundle\Entity\Gender::class)->findOneBy(['code' => $response->gender->id]);
  101.                             $dataMaritalStatus = $em->getRepository(\Aviatur\CustomerBundle\Entity\CivilStatus::class)->findOneBy(['code' => $response->marital_starus->id]);
  102.                             $dataCity = $em->getRepository(\Aviatur\GeneralBundle\Entity\City::class)->findOneBy(['code' => $response->city->id]);
  103.                             $dataCountry = $em->getRepository(\Aviatur\GeneralBundle\Entity\Country::class)->findOneBy(['code' => $response->country->id]);
  105.                             try {
  106.                                 $customer->setAviaturclientid((int) $response->id);
  107.                                 $customer->setDocumentType($dataNumber);
  108.                                 $customer->setCivilStatus($dataMaritalStatus);
  109.                                 $customer->setGenderAviatur($dataGender);
  110.                                 $customer->setCity($dataCity);
  111.                                 $customer->setCountry($dataCountry);
  112.                                 $customer->setDocumentnumber($documentNumber);
  113.                                 $customer->setFirstname($response->name);
  114.                                 $customer->setLastname($response->last_name);
  115.                                 $customer->setBirthdate(new \DateTime($response->birth_date));
  116.                                 $customer->setAddress($response->address);
  117.                                 $customer->setPhone($response->phone_number);
  118.                                 $customer->setCellphone($response->mobile_phone_number);
  119.                                 $customer->setEmail($response->email);
  120.                                 $customer->setEmailCanonical($response->email);
  121.                                 $customer->setUsername($response->email);
  122.                                 $customer->setUsernameCanonical($response->email);
  123.                                 $customer->setPassword($response->password);
  124.                                 $customer->setAcceptInformation(0);
  125.                                 $customer->setAcceptSms(0);
  126.                                 $customer->setPersonType($response->person_type->id);
  127.                                 $customer->setFrecuencySms(0);
  128.                                 $customer->setCorporateId('');
  129.                                 $customer->setCorporateName('');
  130.                                 $customer->setEnabled(1);
  131.                                 $customer->setRoles([]);
  132.                                 $emo = $managerRegistry->getManager();
  133.                                 $emo->persist($customer);
  134.                                 $emo->flush();
  135.                                 $return = [
  136.                                     'id' => $customer->getId(),
  137.                                     'first_name' => substr_replace($response->name, '********', 3),
  138.                                     'last_name' => substr_replace($response->last_name, '********', 3),
  139.                                     'address' => substr_replace($response->address, '********', 3),
  140.                                     'doc_num' => (string) $response->document->number,
  141.                                     'doc_type' => $dataNumber->getExternalcode(),
  142.                                     'phone' => substr_replace($response->phone_number, '*******', 3),
  143.                                     'email' => substr_replace($response->email, '********', 3),
  144.                                     'gender' => $dataGender->getCode(),
  145.                                     'birthday' => ((null != $response->birth_date) && ('' != $response->birth_date)) ? \date('Y-m-d', \strtotime($response->birth_date)) : null,
  146.                                     'nationality' => ((null != $dataCountry) && ('' != $dataCountry)) ? $dataCountry->getIataCode() : null,
  147.                                     'nationality_label' => ((null != $dataCountry) && ('' != $dataCountry)) ? \ucwords(\mb_strtolower($dataCountry->getDescription())).' ('.$dataCountry->getIataCode().')' : null,
  148.                                 ];
  149.                             } catch (\Doctrine\ORM\ORMException $e) {
  150.                                 $errorHandler->errorRedirect('/vuelos/detalle', '', 'Ha ocurrido un error ingresando el nuevo usuario a la base de datos');
  152.                                 return $this->json(['error' => 'Ha ocurrido un error ingresando el nuevo usuario a la base de datos']);
  153.                             } catch (\Aviatur\CustomerBundle\Exception\ValidateException $e) {
  154.                                 $mensaje = 'Información incompleta o inconsistente: '.$e->getMessage();
  155.                                 $errorHandler->errorRedirect('/vuelos/detalle', '', $mensaje);
  157.                                 return $this->json(['error' => $mensaje]);
  158.                             } catch (\Exception $e) {
  159.                                 $errorHandler->errorRedirect('/vuelos/detalle', '', 'Ha ocurrido un error inesperado en la creación del nuevo usuario');
  161.                                 return $this->json(['error' => 'Ha ocurrido un error inesperado en la creación del nuevo usuario']);
  162.                             }
  163.                         }
  164.                     } else {
  165.                         $errorHandler->errorRedirect('/vuelos/detalle', '', 'Error usuario: '.(string) $response['error']);
  167.                         return $this->json(['error' => (string) $response['error']]);
  168.                     }
  169.                 } else {
  170.                     $errorHandler->errorRedirect('/vuelos/detalle', '', 'Error usuario: Error inesperado en la consulta');
  172.                     return $this->json(['error' => 'Error inesperado en la consulta']);
  173.                 }
  174.             } else {
  175.                 $return = [
  176.                     'id' => $data->getId(),
  177.                     'first_name' => ((null != $data->getFirstname()) && ('' != $data->getFirstname())) ? utf8_encode(substr_replace($data->getFirstname(), '********', 3)) : null,
  178.                     'last_name' => ((null != $data->getLastname()) && ('' != $data->getLastname())) ? utf8_encode(substr_replace($data->getLastname(), '********', 3)) : null,
  179.                     'address' => ((null != $data->getAddress()) && ('' != $data->getAddress())) ? substr_replace($data->getAddress(), '********', 3) : null,
  180.                     'city' => ((null != $data->getCity()) && ('' != $data->getCity())) ? substr_replace($data->getCity()->getDescription(), '********', 3) : null,
  181.                     'doc_num' => ((null != $data->getDocumentnumber()) && ('' != $data->getDocumentnumber())) ? $data->getDocumentnumber() : null,
  182.                     'doc_type' => ((null != $data->getDocumentType()) && ('' != $data->getDocumentType())) ? $data->getDocumentType()->getExternalcode() : null,
  183.                     'phone' => ((null != $data->getPhone()) && ('' != $data->getPhone())) ? substr_replace($data->getPhone(), '*******', 3) : null,
  184.                     'cellphone' => ((null != $data->getCellphone()) && ('' != $data->getCellphone())) ? substr_replace($data->getCellphone(), '*******', 3) : null,
  185.                     'email' => ((null != $data->getEmail()) && ('' != $data->getEmail())) ? substr_replace($data->getEmail(), '********', 3) : null,
  186.                     'gender' => ((null != $data->getGenderAviatur()) && ('' != $data->getGenderAviatur())) ? $data->getGenderAviatur()->getCode() : null,
  187.                     'birthday' => ((null != $data->getBirthdate()) && ('' != $data->getBirthdate())) ? \date('Y-m-d', $data->getBirthdate()->getTimestamp()) : null,
  188.                     'city_id' => ((null != $data->getCity()) && (null != $data->getCity()->getIatacode()) && ('' != $data->getCity()->getIatacode())) ? $data->getCity()->getIatacode() : null,
  189.                     'nationality' => ((null != $data->getCountry()) && ('' != $data->getCountry())) ? $data->getCountry()->getIataCode() : null,
  190.                     'nationality_label' => ((null != $data->getCountry()) && ('' != $data->getCountry())) ? \ucwords(\mb_strtolower($data->getCountry()->getDescription())).' ('.$data->getCountry()->getIataCode().')' : null,
  191.                 ];
  192.             }
  194.             return $this->json($return);
  195.         } else {
  196.             $errorHandler->errorRedirect('/vuelos/detalle', '', 'Acceso no autorizado');
  198.             return $errorHandler->errorRedirect($twigFolder->pathWithLocale('aviatur_general_homepage'), '', 'Acceso no autorizado');
  199.         }
  200.     }
  202.     public function getB2TDataAction(Request $request, AviaturWebService $webService, AviaturErrorHandler $errorHandler, ParameterBagInterface $parameterBag)
  203.     {
  204.         $return = [];
  205.         $doc_type = $request->query->get('doc_type');
  206.         $documentNumber = $request->query->get('doc_num');
  207.         //si no encuentra en la base local busca en el servidor de aviatur
  208.         $customerModel = new CustomerModel();
  209.         $xmlRequest = $customerModel->getXmlFindUserB2T($doc_type, $documentNumber, 'G_ROA', 'BOGVU2900');
  210.         $response = $webService->busWebServiceAmadeus('GENERALLAVE', $parameterBag->get('provider_service'), $xmlRequest);
  211.         if ((('FALLO' == $response->RESULTADO) && (false !== strpos($response->MENSAJE, 'No se enco'))) || (('EXITO' == $response->RESULTADO) && empty($response->CLIENTES))) {
  212.             return $this->json(['no_info' => (string) $response->MENSAJE]);
  213.         } elseif (('FALLO' == $response->RESULTADO)) {
  214.             $errorHandler->errorRedirect('/vuelos/detalle', '', 'Error usuario: '.(string) $response->MENSAJE);
  216.             return $this->json(['error' => (string) $response->MENSAJE]);
  217.         } else {
  218.             foreach ($response->CLIENTES->ELEMENTO_LISTA_CLIENTES as $client) {
  219.                 $return[] = [
  220.                     'id' => (string) $client->IDENTIFICADOR_INTERNO,
  221.                     'first_name' => ucwords($this->sanear_string(mb_strtolower((string) $client->NOMBRE))),
  222.                     'last_name' => ucwords($this->sanear_string(mb_strtolower((string) $client->APELLIDO))),
  223.                     'doc_num' => ucwords(mb_strtolower((string) $client->NUMERO_DE_DOCUMENTO)),
  224.                     'doc_type' => $request->query->get('doc_type'),
  225.                     'phone' => (string) $client->TELEFONO,
  226.                     'consecutive' => (string) $client->CONSECUTIVO,
  227.                 ];
  228.             }
  229.         }
  231.         return $this->json($return);
  232.     }
  234.     public function createAction(Request $request, ManagerRegistry $managerRegistry, AviaturWebService $webService, AviaturErrorHandler $errorHandler, TokenStorageInterface $tokenStorage, SessionInterface $session, ValidateSanctionsRenewal $validateSanctionsRenewal, ParameterBagInterface $parameterBag)
  235.     {
  236.         $customer = null;
  237.         $transactionId = $session->get('transactionId');
  238.         $em = $this->em;
  239.         $billingData = $request->get('BD');
  240.         $paymentMethod = $request->get('PD')['type'] ?? 'other';
  241.         if ($request->request->has('MS')) {
  242.             $passangers = $billingData;
  243.         } else {
  244.             $passangers = array_merge($billingData, $request->get('PI'));
  245.         }
  246.         $isFront = $session->has('operatorId');
  247.         $session->remove('loginFromDetail');
  248.         foreach ($passangers as $prop => $passanger) {
  249.             if (preg_match('/^doc_num/i', $prop) && '' == $passangers[$prop]) {
  250.                 $errorHandler->errorRedirect('/vuelos/detalle', '', 'undefined_doc_num');
  251.                 return $this->json(['error' => 'El número de identificación no puede estar vacío']);
  252.             }
  253.         }
  254.         $server = $request->server;
  255.         $urlDomain = parse_url($server->get('HTTP_REFERER'), PHP_URL_HOST);
  257.         /* Inicio comparación ONU-OFAC */
  258.         $postData = $request->request->all();
  259.         if(!$this->getValidationOnuOfac($postData, $server->get('HTTP_REFERER'), $session, $validateSanctionsRenewal)){
  260.             $errorHandler->errorRedirect('/vuelos/detalle', '', 'sanctions_candidate');
  261.             return $this->json(['error' => 'No se puede continuar con la transacción. Por favor, contáctese con la línea de atención al usuario de AVIATUR']);
  262.         }
  263.         /* Fin comparación ONU-OFAC */
  265.         $parameters = json_decode($session->get($request->getHost().'[parameters]'));
  267.         if (isset($parameters->switch_login_agencies) && '' != $parameters->switch_login_agencies) {
  268.             $login_agencies = json_decode($parameters->switch_login_agencies, true);
  269.             if (isset($login_agencies[$session->get('agencyId')])) {
  270.                 $login_is_on = $login_agencies[$session->get('agencyId')];
  271.             } else {
  272.                 $login_is_on = $login_agencies['all'];
  273.             }
  274.         } else {
  275.             $login_is_on = '0';
  276.         }
  278.         if (!$isFront && false !== strpos($urlDomain, 'bbva') && !$this->validateSpecialConditionPayment($request->get('PD')['card_num'])) {
  279.             $errorHandler->errorRedirectNoEmail('/vuelos/detalle', '', 'no_sppayment_condition');
  281.             return $this->json(['error' => 'no_sppayment_condition']);
  282.         }
  283.         if ((isset($billingData['id'])) && ('' != $billingData['id']) && (null != $billingData['id'])) {
  284.             $customer = $em->getRepository(\Aviatur\CustomerBundle\Entity\Customer::class)->find($billingData['id']);
  285.             /* if ($login_is_on == '1') {
  286.               if ($this->get("aviatur_login_service")->validActiveSession() === false) {
  287.               $session->set('loginFromDetail', true);
  288.               return $this->json(array("error" => "no_granted_session_condition"));
  289.               } else if (!isset($request->get('PD')['methodsRecovered'])) { */
  290. //                $customerLogin = $this->get('security.token_storage')->getToken()->getUser();
  291. //
  292. //                //Verify is client is same logged client
  293.             ////                if ($customerLogin->getEmail() != $customer->getEmail() && !isset($billingData['anotherCustomerCheck'])) {
  294.             ////                    return $this->json(array("error" => "notSamePersonLogged"));
  295.             ////                }
  296. //
  297. //                $infoMethodPaymentByClient = $this->get("aviatur_methods_customer_service")->getMethodsByCustomer($customerLogin, false);
  298. //                if ($infoMethodPaymentByClient['info'] !== 'NoInfo') {
  299. //                    return $this->json(array("error" => "customer_with_methods_saved", "info" => $infoMethodPaymentByClient['info']));
  300. //                }
  301.             /* }
  302.               } */
  303.             if (isset($billingData['address']) && (false === strpos($billingData['address'], '***')) && (('' == $customer->getAddress()) || (null == $customer->getAddress()))) {
  304.                 $customer->setAddress($billingData['address']);
  305.             }
  306.             if (isset($billingData['phone']) && (false === strpos($billingData['phone'], '***')) && (('' == $customer->getPhone()) || (null == $customer->getPhone()))) {
  307.                 $customer->setPhone($billingData['phone']);
  308.             }
  309.             $em->flush();
  310.             /*
  311.             if (!$isFront && !$this->validateSanctions($session, $validateSanctions, ['documentnumber' => $customer->getDocumentnumber(), 'name' => $customer->getFirstname().' '.$customer->getLastname()], $paymentMethod)) {
  312.                 $errorHandler->errorRedirectNoEmail('/vuelos/detalle', '', 'sanctions_candidate');
  314.                 return $this->json(['error' => 'sanctions_candidate']);
  315.             }
  316.             */
  317.             $passengerStructured = [];
  318.             $passengerStructuredGroup = null;
  319.             foreach ($passangers as $passKey => $passengerValue) {
  320.                 if (!preg_match('/.*_\d_\d$/', $passKey) || strstr($passengerValue, '***')) {
  321.                     continue;
  322.                 }
  323.                 $matchArray = [];
  324.                 preg_match('/.*_(\d_\d)$/', $passKey, $matchArray);
  325.                 if (!isset($matchArray[1])) {
  326.                     continue;
  327.                 }
  328.                 $passengerStructuredGroup = !$passengerStructuredGroup ? $matchArray[1] : ($passengerStructuredGroup !== $matchArray[1] ? $matchArray[1] : $passengerStructuredGroup);
  329.                 if (strstr($passKey, 'doc_num')) {
  330.                     $passengerStructured[$passengerStructuredGroup]['document'] = $passengerValue;
  331.                     $passengerStructured[$passengerStructuredGroup]['name'] = '';
  332.                 } elseif (strstr($passKey, 'first_name') || strstr($passKey, 'last_name')) {
  333.                     $passengerStructured[$passengerStructuredGroup]['name'] .= $passengerValue.' ';
  334.                 }
  335.             }
  336.             foreach ($passengerStructured as $pax) {
  337.                 if ('' === trim($pax['name'])) {
  338.                     continue;
  339.                 }
  340.                 /*
  341.                 if (!$isFront && !$this->validateSanctions($session, $validateSanctions, ['documentnumber' => $pax['document'], 'name' => $pax['name']], $paymentMethod)) {
  342.                     $errorHandler->errorRedirectNoEmail('/vuelos/detalle', '', 'sanctions_candidate');
  344.                     return $this->json(['error' => 'sanctions_candidate']);
  345.                 }
  346.                 */
  347.             }
  348.             $return = [
  349.                 'id' => $customer->getId(),
  350.             ];
  352.             $redemptionPoint = $em->getRepository(\Aviatur\GeneralBundle\Entity\PointRedemption::class)->findPointRedemptionWithAgency($this->agency);
  353.             if (isset($redemptionPoint) && isset($postData['PD']['pointRedemptionValue'])) {
  354.                 if ($postData['PD']['pointRedemptionValue'] !== '0' && $postData['PD']['pointRedemptionValue'] != null) {
  355.                     $avalPoints = $postData['PD']['pointRedemptionValue'];
  356.                     if ($avalPoints > 0) {
  357.                         $info = [
  358.                             "token" => NULL,
  359.                             "transactionId" => $transactionId,
  360.                             "totalPoints" => $avalPoints
  361.                         ];
  362.                         $disposablePoints = $this->athServices->disposablePoints($info, true);
  364.                         if (isset($disposablePoints['ok']) && $avalPoints > $disposablePoints['ok']['text']['PointOfService']) {
  365.                             $return += ["error" => "Los puntos que quiere redimir no están disponibles para completar su transacción, por favor intente nuevamente"];
  366.                         } else if (isset($disposablePoints['error'])) {
  367.                             $return += ["error" => "1.Lo sentimos no podemos procesar la transacción, por favor vuelva a intentar más tarde"];
  368.                         } else {
  369.                             $parameters = $em->getRepository(\Aviatur\GeneralBundle\Entity\Parameter::class)->findOneByName('aviatur_ath');
  370.                             if (!isset(json_decode($parameters->getDescription())->NoOtp) || (isset(json_decode($parameters->getDescription())->NoOtp) && !json_decode($parameters->getDescription())->NoOtp)) {
  371.                                 $return += $this->generateOtp($redemptionPoint, $session, $postData);
  372.                             }
  373.                             if (isset($return['StatusCode'])) {
  374.                                 if ($return['StatusCode'] !== '0' && $return['StatusCode'] !== 0) {
  375.                                     $return += ["error" => "Lo sentimos no podemos procesar  a la transacción, por favor vuelva a intentar más tarde"];
  376.                                 }
  377.                             }
  378.                         }
  379.                     }
  380.                 }
  381.             }
  382.             return $this->json($return);
  383.         } else {
  384.             $userLogged = $tokenStorage->getToken()->getUser();
  385.             if ($userLogged && $userLogged = !'anon.') {
  386.                 $billingData['id'] = $userLogged->getId();
  387.                 if (null != $userLogged->getFacebookId() || null != $userLogged->getGoogleId()) {
  388.                     $passangerData = $request->get('PI');
  389.                     /*
  390.                     if (!$isFront && !$this->validateSanctions($session, $validateSanctions, ['documentnumber' => $billingData['doc_num'], 'name' => $billingData['first_name'].' '.$billingData['last_name']], $paymentMethod)) {
  391.                         $errorHandler->errorRedirectNoEmail('/vuelos/detalle', '', 'sanctions_candidate');
  393.                         return $this->json(['error' => 'sanctions_candidate']);
  394.                     }
  395.                     */
  396.                     if ($request->get('same-billing')) {
  397.                         if ('on' == $request->get('same-billing')) {
  398.                             $customer = $em->getRepository(\Aviatur\CustomerBundle\Entity\Customer::class)->find($userLogged->getId());
  399.                             $dataNumberDocType = $em->getRepository(\Aviatur\CustomerBundle\Entity\DocumentType::class)->findOneByExternalcode($passangerData['doc_type_1_1']);
  400.                             $dataCountry = $em->getRepository(\Aviatur\GeneralBundle\Entity\Country::class)->findOneByIatacode($passangerData['nationality_1_1']);
  401.                             $dataCity = $em->getRepository(\Aviatur\GeneralBundle\Entity\City::class)->findOneByIatacode('BOG');
  402.                             $dataGender = $em->getRepository(\Aviatur\CustomerBundle\Entity\Gender::class)->findOneByCode($passangerData['gender_1_1']);
  403.                             $customer->setDocumentType($dataNumberDocType);
  404.                             $customer->setDocumentnumber($passangerData['doc_num_1_1']);
  405.                             $customer->setFirstname($passangerData['first_name_1_1']);
  406.                             $customer->setLastname($passangerData['last_name_1_1']);
  407.                             $customer->setAddress($passangerData['address_1_1']);
  408.                             $customer->setPhone($request->get('CD')['phone']);
  409.                             $customer->setCountry($dataCountry);
  410.                             $customer->setCity($dataCity);
  411.                             $customer->setBirthdate(new \DateTime($passangerData['birthday_1_1']));
  412.                             $customer->setGenderAviatur($dataGender);
  413.                         }
  414.                     } else {
  415.                         $customer = $em->getRepository(\Aviatur\CustomerBundle\Entity\Customer::class)->find($userLogged->getId());
  416.                         $dataNumberDocType = $em->getRepository(\Aviatur\CustomerBundle\Entity\DocumentType::class)->findOneByExternalcode($billingData['doc_type']);
  417.                         if (isset($billingData['nationality']) && '' != $billingData['nationality']) {
  418.                             $dataCountry = $em->getRepository(\Aviatur\GeneralBundle\Entity\Country::class)->findOneByIatacode($billingData['nationality']);
  419.                         } else {
  420.                             $dataCountry = $em->getRepository(\Aviatur\GeneralBundle\Entity\Country::class)->findOneByIatacode('CO');
  421.                         }
  422.                         $dataCity = $em->getRepository(\Aviatur\GeneralBundle\Entity\City::class)->findOneByIatacode('BOG');
  423.                         $dataGender = $em->getRepository(\Aviatur\CustomerBundle\Entity\Gender::class)->findOneByCode($billingData['gender']);
  424.                         $customer->setDocumentType($dataNumberDocType);
  425.                         $customer->setDocumentnumber($billingData['doc_num']);
  426.                         $customer->setFirstname($billingData['first_name']);
  427.                         $customer->setLastname($billingData['last_name']);
  428.                         $customer->setAddress($billingData['address']);
  429.                         $customer->setPhone($billingData['phone']);
  430.                         $customer->setCountry($dataCountry);
  431.                         $customer->setCity($dataCity);
  432.                         $customer->setBirthdate(new \DateTime($billingData['birthday']));
  433.                         $customer->setGenderAviatur($dataGender);
  434.                     }
  435.                     $em->persist($customer);
  436.                     $em->flush();
  437.                     $return = [
  438.                         'id' => $userLogged->getId(),
  439.                     ];
  441.                     return $this->json($return);
  442.                 }
  443.             }
  444.             $documentType = $em->getRepository(\Aviatur\CustomerBundle\Entity\DocumentType::class)->findByExternalcode($billingData['doc_type']);
  445.             $registered = $em->getRepository(\Aviatur\CustomerBundle\Entity\Customer::class)->findBy(['documentnumber' => $billingData['doc_num'], 'documentType' => $documentType]);
  446.             if (0 != sizeof($registered)) {
  447.                 return $this->json(['id' => $registered[0]->getId()]);
  448.             }
  449.             /*$data = $em->getRepository(\Aviatur\CustomerBundle\Entity\Customer::class)->findByEmail($billingData['email']);
  450.             if (0 != sizeof($data)) {
  451.                 $errorHandler->errorRedirectNoEmail('/vuelos/detalle', '', 'email_exist');
  453.                 return $this->json(['error' => 'email_exist']);
  454.             }*/
  456.             $customerModel = new CustomerModel();
  457.             $doc_type = explode('-', $billingData['doc_type']);
  458.             $xmlRequest = $customerModel->getXmlFindUser($doc_type[0] , $billingData['doc_num'], '0926EB', 'BOGVU2900');
  459.             //$xmlRequest = $customerModel->getXmlFindUserByEmail($billingData['email'], 4);
  460.             $response = $webService->busWebServiceAmadeus('GENERALLAVE', $parameterBag->get('provider_service'), $xmlRequest);
  461.             if ((isset($response->RESULTADO) && ('FALLO' != $response->RESULTADO)) || (isset($response->ID))) {
  462.                 $errorHandler->errorRedirectNoEmail('/vuelos/detalle', '', 'Error al crear el usuario');
  464.                 return $this->json(['error' => 'Error al crear el usuario']);
  465.             } elseif (isset($response->MENSAJE) && (false !== strpos($response->MENSAJE, 'No se enco'))) {
  466.                 $doc_type = explode('-', $billingData['doc_type']);
  467.                 $passangerData = $request->get('PI');
  469.                 /* if ($login_is_on == '0') { */
  470.                 $dataNumber = $em->getRepository(\Aviatur\CustomerBundle\Entity\DocumentType::class)->findOneByExternalcode($doc_type[0]);
  471.                 $personType = (3 != $dataNumber->getId()) && (4 != $dataNumber->getId()) && (7 != $dataNumber->getId()) ? 8 : 7;
  472.                 $customer = new Customer();
  473.                 $customer->setAddress('' != $billingData['address'] ? $billingData['address'] : $passangerData['address_1_1']);
  474.                 $dataCity = $em->getRepository(\Aviatur\GeneralBundle\Entity\City::class)->findOneByIatacode('BOG');
  475.                 if (isset($passangerData['nationality_1_1']) && '' != $passangerData['nationality_1_1']) {
  476.                     $dataCountry = $em->getRepository(\Aviatur\GeneralBundle\Entity\Country::class)->findOneByIatacode($passangerData['nationality_1_1']);
  477.                 } else {
  478.                     $dataCountry = $em->getRepository(\Aviatur\GeneralBundle\Entity\Country::class)->findOneByIatacode('CO');
  479.                 }
  480.                 $dataGender = $em->getRepository(\Aviatur\CustomerBundle\Entity\Gender::class)->findOneByCode($passangerData['gender_1_1']);
  481.                 $customer->setGenderAviatur($dataGender);
  482.                 if ($billingData['doc_num'] == $passangerData['doc_num_1_1']) {
  483.                     $customer->setBirthdate(new \DateTime($passangerData['birthday_1_1']));
  484.                 } else {
  485.                     $customer->setBirthdate(new \DateTime(date('Y-m-d', strtotime('-18 year', time()))));
  486.                 }
  487.                 $customer->setDocumentType($dataNumber);
  488.                 $customer->setCity($dataCity);
  489.                 $customer->setCountry($dataCountry);
  490.                 $customer->setDocumentnumber($billingData['doc_num']);
  491.                 $customer->setFirstname($billingData['first_name']);
  492.                 $customer->setLastname($billingData['last_name']);
  493.                 $customer->setPhone($billingData['phone']);
  494.                 $customer->setCellphone($billingData['phone']);
  495.                 $customer->setEmail($billingData['email']);
  496.                 $customer->setEmailCanonical($billingData['email']);
  497.                 $customer->setUsername($billingData['email']);
  498.                 $customer->setUsernameCanonical($billingData['email']);
  499.                 $customer->setAcceptInformation(0);
  500.                 $customer->setAcceptSms(0);
  501.                 $customer->setAviaturclientid(0);
  502.                 $customer->setPersonType($personType);
  503.                 $customer->setPassword(sha1('Default Aviatur'));
  504.                 $customer->setRoles([]);
  505.                 try {
  506.                     $em->persist($customer);
  507.                     $em->flush();
  508.                 } catch (\Aviatur\CustomerBundle\Exception\ValidateException $e) {
  509.                     $mensaje = 'Información incompleta o inconsistente: '.$e->getMessage();
  510.                     $errorHandler->errorRedirectNoEmail('/vuelos/detalle', '', $mensaje);
  512.                     return $this->json(['error' => $mensaje]);
  513.                 }
  514.                 /* } */
  515.                 /*
  516.                 if (!$isFront && !$this->validateSanctions($session, $validateSanctions, ['documentnumber' => $billingData['doc_num'], 'name' => $billingData['first_name'].' '.$billingData['last_name']], $paymentMethod)) {
  517.                     $errorHandler->errorRedirectNoEmail('/vuelos/detalle', '', 'sanctions_candidate');
  519.                     return $this->json(['error' => 'sanctions_candidate']);
  520.                 }
  521.                 */
  523.                 /* if ($login_is_on == '1') {
  524.                   $session->set('register-extra-data', [
  525.                   'email' => $billingData["email"],
  526.                   'documentType' => $doc_type[0],
  527.                   'documentNumber' => $billingData['doc_num'],
  528.                   'firstName' => $billingData["first_name"],
  529.                   'lastName' => $billingData["last_name"],
  530.                   'gender' => $passangerData["gender_1_1"],
  531.                   'birthDate' => $passangerData["birthday_1_1"],
  532.                   'address' => $billingData['address'] != '' ? $billingData['address'] : $passangerData["address_1_1"],
  533.                   'phone' => $billingData["phone"]
  534.                   ]);
  535.                   return $this->json(array("error" => "redirect_to_register"));
  536.                   } */
  538.                 $return = [
  539.                     'id' => $customer->getId(),
  540.                 ];
  542.                 if (isset($redemptionPoint)) {
  543.                     $parameters = $em->getRepository(\Aviatur\GeneralBundle\Entity\Parameter::class)->findOneByName('aviatur_ath');
  544.                     if (!isset(json_decode($parameters->getDescription())->NoOtp) || (isset(json_decode($parameters->getDescription())->NoOtp) && json_decode($parameters->getDescription())->NoOtp == false)) {
  545.                         $return += $this->generateOtp($redemptionPoint, $session, $postData);
  546.                     }
  547.                 }
  549.                 return $this->json($return);
  550.             } else {
  551.                 $errorHandler->errorRedirect('/vuelos/detalle', '', 'Ha ocurrido un error en la consulta de usuarios por email');
  553.                 return $this->json(['error' => 'Ha ocurrido un error en la consulta de usuarios por email']);
  554.             }
  555.         }
  556.     }
  558.     public function loginSelectAction(Request $request, AviaturWebService $webService, RouterInterface $router, ParameterBagInterface $parameterBag)
  559.     {
  560.         $email = $request->request->get('email');
  561.         $em = $this->getDoctrine()->getManager();
  562.         $customer = $em->getRepository(\Aviatur\CustomerBundle\Entity\Customer::class)->findOneBy(['email' => $email]);
  563.         $enabled = false;
  564.         $session = new Session();
  565.         $session->set('AnonymousEmail', $email);
  566.         if (!empty($customer)) {
  567.             if (false == $customer->getEnabled()) {
  568.                 return $this->redirect($this->generateUrl('aviatur_password_create_nocheck'));
  569.             } else {
  570.                 $route = $router->match($this->generateUrl('fos_user_security_login'));
  572.                 return $this->forward($route['_controller'], $route);
  573.             }
  574.         } else {
  575.             $customerModel = new CustomerModel();
  576.             $xmlRequest = $customerModel->getXmlFindUserByEmail($email, 4);
  577.             $response = $webService->busWebServiceAmadeus('GENERALLAVE', $parameterBag->get('provider_service'), $xmlRequest);
  578.             if (!is_object($response)) {
  579.                 return $this->redirect($this->generateUrl('fos_user_registration_register'));
  580.             } elseif (('FALLO' == $response->RESULTADO)) {
  581.                 return $this->redirect($this->generateUrl('fos_user_registration_register'));
  582.             } else {
  583.                 $customer = new Customer();
  584.                 $dataNumber = $em->getRepository(\Aviatur\CustomerBundle\Entity\DocumentType::class)->findOneBy(['code' => $response->document->id]);
  585.                 $dataGender = $em->getRepository(\Aviatur\CustomerBundle\Entity\Gender::class)->findOneBy(['code' => $response->gender->id]);
  586.                 $dataMaritalStatus = $em->getRepository(\Aviatur\CustomerBundle\Entity\CivilStatus::class)->findOneBy(['code' => $response->marital_starus->id]);
  587.                 $dataCity = $em->getRepository(\Aviatur\GeneralBundle\Entity\City::class)->findOneBy(['code' => $response->city->id]);
  588.                 $dataCountry = $em->getRepository(\Aviatur\GeneralBundle\Entity\Country::class)->findOneBy(['code' => $response->country->id]);
  589.                 $customer->setAviaturclientid((int) $response->id);
  590.                 $customer->setDocumentType($dataNumber);
  591.                 $customer->setCivilStatus($dataMaritalStatus);
  592.                 $customer->setGenderAviatur($dataGender);
  593.                 $customer->setCity($dataCity);
  594.                 $customer->setCountry($dataCountry);
  595.                 $customer->setDocumentnumber($response->document->number);
  596.                 $customer->setFirstname($response->name);
  597.                 $customer->setLastname($response->last_name);
  598.                 $customer->setBirthdate(new \DateTime($response->birth_date));
  599.                 $customer->setAddress($response->address);
  600.                 $customer->setPhone($response->phone_number);
  601.                 $customer->setCellphone($response->mobile_phone_number);
  602.                 $customer->setEmail($response->email);
  603.                 $customer->setEmailCanonical($response->email);
  604.                 $customer->setUsername($response->email);
  605.                 $customer->setUsernameCanonical($response->email);
  606.                 $customer->setPassword($response->password);
  607.                 $customer->setAcceptInformation(0);
  608.                 $customer->setAcceptSms(0);
  609.                 $customer->setPersonType(8);
  610.                 $customer->setFrecuencySms(0);
  611.                 $customer->setCorporateId('');
  612.                 $customer->setCorporateName('');
  613.                 $customer->setEnabled(1);
  614.                 $customer->setRoles([]);
  615.                 $emo = $this->getDoctrine()->getManager();
  616.                 $emo->persist($customer);
  617.                 $emo->flush();
  618.                 $route = $router->match($this->generateUrl('fos_user_security_login'));
  620.                 return $this->forward($route['_controller'], $route);
  621.             }
  622.         }
  623.     }
  625.     public function getCustomerCardsAction(Request $request, TokenStorageInterface $tokenStorage, CustomerMethodPaymentService $methodPaymentService)
  626.     {
  627.         if ($request->isXmlHttpRequest()) {
  628.             $customerLogin = $tokenStorage->getToken()->getUser();
  629.             $infoMethodPaymentByClient = $methodPaymentService->getMethodsByCustomer($customerLogin, false);
  630.             if ('NoInfo' !== $infoMethodPaymentByClient['info']) {
  631.                 return $this->json(['info' => 'customer_with_methods_saved', 'info' => $infoMethodPaymentByClient['info']]);
  632.             }
  634.             return $this->json(['error' => 'no-data']);
  635.         }
  637.         return $this->json(['error']);
  638.     }
  640.     public function passwordCreateAction(TwigFolder $twigFolder)
  641.     {
  642.         $agencyFolder = $twigFolder->twigFlux();
  643.         $response = $this->render($twigFolder->twigExists('@AviaturTwig/'.$agencyFolder.'/Customer/Customer/create-password.html.twig'), []);
  645.         return $response;
  646.     }
  648.     public function passwordRessetAction(TwigFolder $twigFolder)
  649.     {
  650.         $agencyFolder = $twigFolder->twigFlux();
  651.         $response = $this->render($twigFolder->twigExists('@AviaturTwig/'.$agencyFolder.'/Customer/Customer/resset-password.html.twig'), []);
  653.         return $response;
  654.     }
  656.     public function customerAccountAction(AviaturErrorHandler $errorHandler, TwigFolder $twigFolder, TokenStorageInterface $tokenStorage, CustomerMethodPaymentService $methodPaymentService, AviaturLoginService $loginService)
  657.     {
  658.         $agencyFolder = $twigFolder->twigFlux();
  659.         $em = $this->getDoctrine()->getManager();
  660.         //var_dump($tokenStorage->getToken()->getUser());die;
  661.         if (is_object($tokenStorage->getToken()->getUser())) {
  662.             $userLogged = $tokenStorage->getToken()->getUser()->getId();
  663.         } else {
  664.             return $this->redirect($errorHandler->errorRedirect($twigFolder->pathWithLocale('aviatur_general_homepage'), '', 'Acceso no autorizado'));
  665.         }
  667.         $customer = $this->getUser();
  668.         $infoMethodPaymentByClient = $methodPaymentService->getMethodsByCustomer($customer, false);
  669.         if ($infoMethodPaymentByClient) {
  670.             $cardSaved = [];
  671.             if (false !== $loginService->validActiveSession()) {
  672.                 if ('NoInfo' !== $infoMethodPaymentByClient['info']) {
  673.                     foreach ($infoMethodPaymentByClient['info'] as $key => $value) {
  674.                         $cardSaved['info'][] = [substr($key, 0, 2), substr($key, 2, 4)];
  675.                     }
  676.                 }
  677.             }
  678.         }
  679.         $billingList = $em->getRepository(\Aviatur\CustomerBundle\Entity\CustomerBillingList::class)->findByCustomer($userLogged);
  680.         if ($billingList) {
  681.             $dataBilling = [];
  682.             $count = 0;
  683.             foreach ($billingList as $billings) {
  684.                 if ('ACTIVE' == $billings->getStatus()) {
  685.                     $dataBilling[$count]['id'] = $billings->getId();
  686.                     $dataBilling[$count]['customerId'] = $userLogged;
  687.                     $dataBilling[$count]['documentType'] = $billings->getDocumentType()->getExternalCode();
  688.                     $dataBilling[$count]['documentNumber'] = $billings->getDocumentnumber();
  689.                     $dataBilling[$count]['firstname'] = $billings->getFirstname();
  690.                     $dataBilling[$count]['lastname'] = $billings->getLastname();
  691.                     $dataBilling[$count]['email'] = $billings->getEmail();
  692.                     $dataBilling[$count]['address'] = $billings->getAddress();
  693.                     $dataBilling[$count]['phone'] = $billings->getPhone();
  694.                     ++$count;
  695.                 }
  696.             }
  697.         }
  699.         $newsletter = new Newsletter();
  700.         $newsletterForm = $this->createForm(\Aviatur\FormBundle\Form\NewsletterAsyncType::class, $newsletter);
  702.         $paylaterParam = $em->getRepository(\Aviatur\GeneralBundle\Entity\Parameter::class)->findOneByName('aviatur_pay_later');
  703.         $data = [
  704.             'cards' => !empty($cardSaved) ? $cardSaved : null,
  705.             'billings' => !empty($dataBilling) ? $dataBilling : null,
  706.             'newsletter_form' => $newsletterForm->createView(),
  707.             'paylater' => $paylaterParam->getValue() == 1 ? true : false,
  708.         ];
  709.         $response = $this->render($twigFolder->twigExists('@AviaturTwig/'.$agencyFolder.'/Customer/Customer/customer-account.html.twig'), $data);
  711.         return $response;
  712.     }
  714.     public function getBillingsAjaxAction(TokenStorageInterface $tokenStorage)
  715.     {
  716.         $userLogged = $tokenStorage->getToken()->getUser()->getId();
  717.         $em = $this->getDoctrine()->getManager();
  718.         $billingList = $em->getRepository(\Aviatur\CustomerBundle\Entity\CustomerBillingList::class)->findByCustomer($userLogged);
  719.         if ($billingList) {
  720.             $dataBilling = [];
  721.             $count = 0;
  722.             foreach ($billingList as $billings) {
  723.                 if ('ACTIVE' == $billings->getStatus()) {
  724.                     $dataBilling[$count]['id'] = $billings->getId();
  725.                     $dataBilling[$count]['customerId'] = $userLogged;
  726.                     $dataBilling[$count]['documentType'] = $billings->getDocumentType()->getExternalCode();
  727.                     $dataBilling[$count]['documentNumber'] = $billings->getDocumentnumber();
  728.                     $dataBilling[$count]['firstname'] = $billings->getFirstname();
  729.                     $dataBilling[$count]['lastname'] = $billings->getLastname();
  730.                     $dataBilling[$count]['email'] = $billings->getEmail();
  731.                     $dataBilling[$count]['address'] = $billings->getAddress();
  732.                     $dataBilling[$count]['phone'] = $billings->getPhone();
  733.                     $dataBilling[$count]['country'] = $billings->getCountry()->getId();
  734.                     $dataBilling[$count]['city'] = $billings->getCity()->getId();
  735.                     ++$count;
  736.                 }
  737.             }
  739.             return $this->json(['status' => 'success', 'data' => ['billings' => !empty($dataBilling) ? $dataBilling : null, 'totalBillings' => $count]]);
  740.         } else {
  741.             return $this->json(['status' => 'error']);
  742.         }
  743.     }
  745.     public function customerBookingAction(SessionInterface $session, AviaturEncoder $aviaturEncoder, TwigFolder $twigFolder, TokenStorageInterface $tokenStorage)
  746.     {
  747.         $customer = $tokenStorage->getToken()->getUser();
  748.         $em = $this->getDoctrine()->getManager();
  749.         $orderProducts = [];
  750.         $agency = $em->getRepository(\Aviatur\AgencyBundle\Entity\Agency::class)->find($session->get('agencyId'));
  751.         $agencyOrderProducts = $em->getRepository(\Aviatur\GeneralBundle\Entity\OrderProduct::class)->getOrderProductsByCustomerAndAgency($customer, $agency);
  752.         $orderProducts = \array_merge($orderProducts, $agencyOrderProducts);
  753.         if ('aviatur.com' == $agency->getDomain()) {
  754.             $metasearch = $em->getRepository(\Aviatur\AgencyBundle\Entity\Agency::class)->find(1); //Metasearch
  755.             $metaOrderProducts = $em->getRepository(\Aviatur\GeneralBundle\Entity\OrderProduct::class)->getOrderProductsByCustomerAndAgency($customer, $metasearch);
  756.             $orderProducts = \array_merge($orderProducts, $metaOrderProducts);
  757.             $mobile = $em->getRepository(\Aviatur\AgencyBundle\Entity\Agency::class)->find(102); //Mobile
  758.             $mobileOrderProducts = $em->getRepository(\Aviatur\GeneralBundle\Entity\OrderProduct::class)->getOrderProductsByCustomerAndAgency($customer, $mobile);
  759.             $orderProducts = \array_merge($orderProducts, $mobileOrderProducts);
  760.         }
  761.         $payRequests = [];
  762.         $orders = [];
  763.         foreach ($orderProducts as $key => $orderProduct) {
  764.             $productRequestString = $aviaturEncoder->AviaturDecode($orderProduct->getPayRequest(), $orderProduct->getPublicKey());
  765.             $productResponseString = $aviaturEncoder->AviaturDecode($orderProduct->getPayResponse(), $orderProduct->getPublicKey());
  767.             $productRequest = json_decode($productRequestString, true);
  768.             $productResponse = json_decode($productResponseString, true);
  769.             if(!is_array($productRequest)){
  770.                 continue;
  771.             }
  772.             $productRequest['orderId'] = 'ON'.$orderProduct->getOrder()->getId();
  773.             if (isset($productRequest['x_amount'])) {
  774.                 $productRequest['x_payment_type'] = 'p2p';
  775.                 $productRequest['x_transaction_date'] = $productResponse['x_transaction_date'] ?? '';
  776.                 $productRequest['x_response_code'] = $productResponse['x_response_code'] ?? '';
  777.                 $productRequest['x_response_reason_code'] = $productResponse['x_response_reason_code'] ?? '';
  778.                 $productRequest['x_response_reason_text'] = isset($productResponse['x_response_reason_text']) ? utf8_decode($productResponse['x_response_reason_text']) : '';
  779.                 $productRequest['x_ta_response_reason_code'] = $productResponse['x_ta_response_reason_code'] ?? '--';
  780.                 $productRequest['x_approval_code'] = $productResponse['x_approval_code'] ?? '';
  781.                 $productRequest['x_ta_approval_code'] = $productResponse['x_ta_approval_code'] ?? '--';
  782.                 $productRequest['x_transaction_id'] = $productResponse['x_transaction_id'] ?? '--';
  783.                 $productRequest['x_ta_transaction_id'] = $productResponse['x_ta_transaction_id'] ?? '--';
  784.                 $payRequests[] = $productRequest;
  785.                 $orders['ON'.$orderProduct->getOrder()->getId()] = null;
  786.             } elseif (isset($productRequest['totalAmount']) && isset($productResponse['getTransactionInformationResult'])) {
  787.                 $productRequest['x_payment_type'] = 'pse';
  788.                 $productRequest['x_invoice_num'] = $productRequest['reference'];
  789.                 $productRequest['x_description'] = $productRequest['description'];
  790.                 $productRequest['x_currency_code'] = $productRequest['currency'];
  791.                 $productRequest['x_amount'] = $productRequest['totalAmount'];
  792.                 $productRequest['x_tax'] = $productRequest['taxAmount'];
  793.                 $productRequest['x_amount_base'] = $productRequest['devolutionBase'];
  794.                 $productRequest['x_transaction_date'] = $productResponse['getTransactionInformationResult']['requestDate'] ?? '';
  795.                 $productRequest['x_response_code'] = $productResponse['getTransactionInformationResult']['responseCode'] ?? '';
  796.                 $productRequest['x_response_reason_code'] = $productResponse['getTransactionInformationResult']['responseReasonCode'] ?? '';
  797.                 $productRequest['x_response_reason_text'] = $productResponse['getTransactionInformationResult']['responseReasonText'] ?? '';
  798.                 $productRequest['x_approval_code'] = $productResponse['getTransactionInformationResult']['trazabilityCode'] ?? '';
  799.                 $productRequest['x_transaction_id'] = $productResponse['getTransactionInformationResult']['transactionID'] ?? '';
  800.                 $payRequests[] = $productRequest;
  801.                 $orders['ON'.$orderProduct->getOrder()->getId()] = null;
  802.             } elseif (isset($productRequest['notificationRequest']) && isset($productResponse['payResponse'])) {
  803.                 $productRequest['x_payment_type'] = 'safetypay';
  804.                 $productRequest['x_invoice_num'] = @$productRequest['tokenRequest']['urn:ExpressTokenRequest']['urn:MerchantSalesID'];
  805.                 $productRequest['x_description'] = @$productRequest['dataTransf']['x_description'];
  806.                 $productRequest['x_currency_code'] = @$productRequest['dataTransf']['x_currency'];
  807.                 $productRequest['x_amount'] = @$productRequest['dataTransf']['x_total_amount'];
  808.                 $productRequest['x_tax'] = @$productRequest['dataTransf']['x_tax_amount'];
  809.                 $productRequest['x_airport_tax'] = 0;
  810.                 $productRequest['x_service_fee_tax'] = 0;
  811.                 $productRequest['x_airport_tax'] = 0;
  812.                 $productRequest['x_airport_tax'] = 0;
  813.                 $productRequest['x_amount_base'] = @$productRequest['dataTransf']['x_devolution_base'];
  814.                 $productRequest['x_transaction_date'] = @$productRequest['tokenRequest']['urn:ExpressTokenRequest']['urn:RequestDateTime'];
  815.                 $productRequest['x_response_reason_code'] = @$productResponse['dataTransf']['x_response_code'];
  816.                 switch ($productRequest['x_response_reason_code']) {
  817.                     case 101:
  818.                         $productRequest['x_response_code'] = 3;
  819.                         break;
  820.                     case 100:
  821.                         $productRequest['x_response_code'] = 2;
  822.                         break;
  823.                     case null:
  824.                         $productRequest['x_response_code'] = 3;
  825.                         break;
  826.                     default:
  827.                         $productRequest['x_response_code'] = 1;
  828.                         break;
  829.                 }
  830.                 $productRequest['x_response_reason_text'] = @$productResponse['dataTransf']['x_response_reason_text'];
  831.                 $productRequest['x_approval_code'] = 'N/A';
  832.                 $productRequest['x_transaction_id'] = 'N/A';
  833.                 $payRequests[] = $productRequest;
  834.                 $orders['ON'.$orderProduct->getOrder()->getId()] = null;
  835.             }
  836.             $historicalOrderProducts = $em->getRepository(\Aviatur\GeneralBundle\Entity\HistoricalOrderProduct::class)->findByOrderProduct($orderProduct);
  837.             if (0 != sizeof($historicalOrderProducts)) {
  838.                 foreach ($historicalOrderProducts as $historicalOrderProduct) {
  839.                     $productRequest = $aviaturEncoder->AviaturDecode($historicalOrderProduct->getPayrequest(), $historicalOrderProduct->getPublickey());
  840.                     $productResponse = $aviaturEncoder->AviaturDecode($historicalOrderProduct->getPayresponse(), $historicalOrderProduct->getPublickey());
  841.                     $productRequest = json_decode($productRequest, true);
  842.                     $productResponse = json_decode($productResponse, true);
  843.                     if (isset($productRequest['x_amount'])) {
  844.                         $productRequest['x_payment_type'] = 'p2p';
  845.                         $productRequest['x_transaction_date'] = $productResponse['x_transaction_date'] ?? '';
  846.                         $productRequest['x_response_code'] = $productResponse['x_response_code'] ?? '';
  847.                         $productRequest['x_response_reason_code'] = $productResponse['x_response_reason_code'] ?? '';
  848.                         $productRequest['x_response_reason_text'] = isset($productResponse['x_response_reason_text']) ? utf8_decode($productResponse['x_response_reason_text']) : '';
  849.                         $productRequest['x_ta_response_reason_code'] = $productResponse['x_ta_response_reason_code'] ?? '';
  850.                         $productRequest['x_approval_code'] = $productResponse['x_approval_code'] ?? '';
  851.                         $productRequest['x_ta_approval_code'] = $productResponse['x_ta_approval_code'] ?? '';
  852.                         $productRequest['x_transaction_id'] = $productResponse['x_transaction_id'] ?? '';
  853.                         $productRequest['x_ta_transaction_id'] = $productResponse['x_ta_transaction_id'] ?? '';
  854.                         $payRequests[sizeof($payRequests) - 1]['history'][] = $productRequest;
  855.                     } elseif (isset($productRequest['totalAmount']) && isset($productResponse['getTransactionInformationResult'])) {
  856.                         $productRequest['x_payment_type'] = 'pse';
  857.                         $productRequest['x_invoice_num'] = $productRequest['reference'];
  858.                         $productRequest['x_description'] = $productRequest['description'];
  859.                         $productRequest['x_currency_code'] = $productRequest['currency'];
  860.                         $productRequest['x_amount'] = $productRequest['totalAmount'];
  861.                         $productRequest['x_tax'] = $productRequest['taxAmount'];
  862.                         $productRequest['x_amount_base'] = $productRequest['devolutionBase'];
  863.                         $productRequest['x_transaction_date'] = $productResponse['getTransactionInformationResult']['requestDate'] ?? '';
  864.                         $productRequest['x_response_code'] = $productResponse['getTransactionInformationResult']['responseCode'];
  865.                         $productRequest['x_response_reason_code'] = $productResponse['getTransactionInformationResult']['responseReasonCode'];
  866.                         $productRequest['x_response_reason_text'] = utf8_decode($productResponse['getTransactionInformationResult']['responseReasonText']);
  867.                         $productRequest['x_approval_code'] = $productResponse['getTransactionInformationResult']['trazabilityCode'] ?? '';
  868.                         $productRequest['x_transaction_id'] = $productResponse['getTransactionInformationResult']['transactionID'] ?? '';
  869.                         $payRequests[sizeof($payRequests) - 1]['history'][] = $productRequest;
  870.                     } elseif (isset($productRequest['notificationRequest']) && isset($productResponse['payResponse'])) {
  871.                         $productRequest['x_payment_type'] = 'safetypay';
  872.                         $productRequest['x_invoice_num'] = @$productRequest['tokenRequest']['urn:ExpressTokenRequest']['urn:MerchantSalesID'];
  873.                         $productRequest['x_description'] = @$productRequest['dataTransf']['x_description'];
  874.                         $productRequest['x_currency_code'] = @$productRequest['dataTransf']['x_currency'];
  875.                         $productRequest['x_amount'] = @$productRequest['dataTransf']['x_total_amount'];
  876.                         $productRequest['x_tax'] = @$productRequest['dataTransf']['x_tax_amount'];
  877.                         $productRequest['x_airport_tax'] = 0;
  878.                         $productRequest['x_service_fee_tax'] = 0;
  879.                         $productRequest['x_amount_base'] = @$productRequest['dataTransf']['x_devolution_base'];
  880.                         $productRequest['x_transaction_date'] = @$productRequest['tokenRequest']['urn:ExpressTokenRequest']['urn:RequestDateTime'];
  881.                         $productRequest['x_response_code'] = 'N/A'; //$productResponse['getTransactionInformationResult']['responseCode'];
  882.                         $productRequest['x_response_reason_code'] = 'N/A'; //$productResponse['getTransactionInformationResult']['responseReasonCode'];
  883.                         $productRequest['x_response_reason_text'] = 'N/A'; //$productResponse['getTransactionInformationResult']['responseReasonText'];
  884.                         $productRequest['x_approval_code'] = 'N/A'; //$productResponse['getTransactionInformationResult']['trazabilityCode'];
  885.                         $productRequest['x_transaction_id'] = 'N/A'; //$productResponse['getTransactionInformationResult']['transactionID'];
  886.                         $payRequests[sizeof($payRequests) - 1]['history'][] = $productRequest;
  887.                     }
  888.                 }
  889.             }
  891. //            var_dump($productResponse);
  892. //            CREATE THE PUBLIC KEY AND ENCODE PayRequest AND PayResponse
  893. //            $encodedRequest = $this->get("aviatur_md5")->AviaturEncode($orderProduct->getPayRequest(), $orderProduct->getPublicKey());
  894. //            $encodedResponse = $this->get("aviatur_md5")->AviaturEncode($orderProduct->getPayResponse(), $orderProduct->getPublicKey());
  895. //            $publicKey = $this->get("aviatur_md5")->aviaturRandomKey();
  896. //            $orderProduct->setPayRequest($encodedRequest);
  897. //            $orderProduct->setPayResponse($encodedResponse);
  898. //            $orderProduct->setPublicKey($publicKey);
  899. //            $em = $this->getDoctrine()->getManager();
  900. //            $em->persist($orderProduct);
  901. //            $em->flush();
  902.         }
  903.         $agencyFolder = $twigFolder->twigFlux();
  904.         $twigView = $twigFolder->twigExists('@AviaturTwig/'.$agencyFolder.'/Customer/Customer/customer-booking.html.twig');
  906.         return $this->render($twigView, ['payRequests' => $payRequests, 'orders' => $orders]);
  907.     }
  908.     
  909.     public function customerBookingCAction(SessionInterface $session, AviaturEncoder $aviaturEncoder, TwigFolder $twigFolder, TokenStorageInterface $tokenStorage)
  910.     {
  911.         $em = $this->getDoctrine()->getManager();
  912.         $paylaterParam = $em->getRepository(\Aviatur\GeneralBundle\Entity\Parameter::class)->findOneByName('aviatur_pay_later');
  913.         if($paylaterParam->getValue() == 1){
  914.         $customer = $tokenStorage->getToken()->getUser();
  915.         $em = $this->getDoctrine()->getManager();
  916.         $orderProducts = [];
  917.         $agency = $em->getRepository(\Aviatur\AgencyBundle\Entity\Agency::class)->find($session->get('agencyId'));
  918.         $agencyOrderProductsPayLater = $em->getRepository(\Aviatur\GeneralBundle\Entity\OrderProduct::class)->getOrderProductsPayLaterWithCustomerAndAgency($customer, $agency);
  919.         $orderProducts = \array_merge($orderProducts, $agencyOrderProductsPayLater);
  920.         if ('aviatur.com' == $agency->getDomain()) {
  921.             $metasearch = $em->getRepository(\Aviatur\AgencyBundle\Entity\Agency::class)->find(1); //Metasearch
  922.             $metaOrderProducts = $em->getRepository(\Aviatur\GeneralBundle\Entity\OrderProduct::class)->getOrderProductsByCustomerAndAgency($customer, $metasearch);
  923.             $orderProducts = \array_merge($orderProducts, $metaOrderProducts);
  924.             $mobile = $em->getRepository(\Aviatur\AgencyBundle\Entity\Agency::class)->find(102); //Mobile
  925.             $mobileOrderProducts = $em->getRepository(\Aviatur\GeneralBundle\Entity\OrderProduct::class)->getOrderProductsByCustomerAndAgency($customer, $mobile);
  926.             $orderProducts = \array_merge($orderProducts, $mobileOrderProducts);
  927.         }
  928.         
  929.         $payRequests = [];
  930.         $orders = [];
  932.         foreach ($orderProducts as $key => $orderProduct) {
  933.             
  934.             
  935.             $xml = simplexml_load_string($orderProduct->getAddproductdata());
  936.             $totalAmount = (string) $xml->xpath('//fare_data//fare//total_amount')[0];
  937.             $transa = (string) $xml->xpath('//transaction_id')[0];
  938.             $data = (string) $xml->xpath('//booking_data')[0];
  939.             $cdata = simplexml_load_string("<root>$data</root>");
  940.             $arrivalAirportCode = (string) $cdata->xpath('//arrival_airport/code')[0];
  941.             $departureAirportCode = (string) $cdata->xpath('//departure_airport/code')[0];
  942.             $departuredate = (string) $cdata->xpath('//departure_datetime')[0];
  943.             $airline = (string) $xml->xpath('//aerolinea/code')[0];
  944.             $orderProduct->Amount = $totalAmount;
  945.             $orderProduct->transaction = $transa;
  946.             $orderProduct->destination = $departureAirportCode." - ".$arrivalAirportCode ;
  947.             $orderProduct->departureDate = $departuredate;
  948.             $orderProduct->airline = $airline;
  949.             
  950.             
  951.             $trace = $em->getRepository(\Aviatur\GeneralBundle\Entity\OrderTrace::class)->findByTransactionId($transa);
  952.             //valida si se generaron ambas reservas en la combinacion
  953.             $hasNullOrder = false;
  954.             foreach ($trace as $item) {
  955.                 if ($item->getOrder() === null) {
  956.                     $hasNullOrder = true;
  957.                     break;
  958.                 }
  959.             }
  961.              if ($hasNullOrder) {
  962.                 unset($orderProducts[$key]);
  963.                 continue; 
  964.             }
  966.             if (isset($orders[$transa])) {
  967.                 $orders[$transa] .=  "|" . $orderProduct->getorder()->getId();
  968.             } else {
  969.                 $orders[$transa] = $orderProduct->getorder()->getId();
  970.             }
  971.         }
  972.     }else{
  973.         $agencyFolder = $twigFolder->twigFlux();
  974.         $twigView = $twigFolder->twigExists('@AviaturTwig/'.$agencyFolder.'/Customer/Customer/customer-booking.html.twig');
  976.         return $this->render($twigView, ['orderProducts' => [], 'orders' => [], 'data' => 'true']);
  977.     }
  979.         $agencyFolder = $twigFolder->twigFlux();
  980.         $twigView = $twigFolder->twigExists('@AviaturTwig/'.$agencyFolder.'/Customer/Customer/customer-booking.html.twig');
  982.         return $this->render($twigView, ['orderProducts' => $orderProducts, 'orders' => $orders, 'data' => 'true']);
  983.     }
  985.     public function editAction(Request $request, SessionInterface $session, AviaturWebService $webService, TwigFolder $twigFolder, UserPasswordEncoderInterface $passwordEncoder, \Swift_Mailer $mailer, AviaturErrorHandler $errorHandler, TokenStorageInterface $tokenStorage, ValidatorInterface $validator, ParameterBagInterface $parameterBag)
  986.     {
  987.         $providerService = $parameterBag->get('provider_service');
  988.         $emailNotification = $parameterBag->get('email_notification');
  990.         $em = $this->getDoctrine()->getManager();
  991.         $agencyFolder = $twigFolder->twigFlux();
  992.         $user = $tokenStorage->getToken()->getUser();
  993.         if (false === is_object($user)) {
  994.             return $this->redirect($errorHandler->errorRedirect($twigFolder->pathWithLocale('aviatur_general_homepage'), '', 'Acceso no autorizado'));
  995.         }
  996.         $id = $user->getId();
  997.         $post = $request->request->get('customer_edit_form');
  998.         $customer = $em->getRepository(\Aviatur\CustomerBundle\Entity\Customer::class)->find($id);
  999.         $city = $em->getRepository(\Aviatur\GeneralBundle\Entity\City::class)->findByCountry($customer->getCountry()->getId(), ['description' => 'ASC']);
  1000.         $email = $customer->getEmail();
  1002.         foreach ($city as $infocities) {
  1003.             $idCity[] = $infocities->getCode();
  1004.             $nameCity[] = $infocities->getDescription();
  1005.         }
  1006.         $info = ['idCity' => $idCity, 'nameCity' => $nameCity];
  1007.         $form = $this->createForm(\Aviatur\CustomerBundle\Form\CustomerEdit::class, $customer);
  1008.         $method = 'edition';
  1009.         $date = new DateTime();
  1011.         $form->handleRequest($request);
  1012.         if ($form->isSubmitted()) {
  1013.             $historical = (object) [
  1014.                         'Firstname' => $customer->getFirstname(),
  1015.                         'Documentnumber' => $customer->getDocumentnumber(),
  1016.                         'DocumentType' => $customer->getDocumentType()->getCode(),
  1017.                         'Lastname' => $customer->getLastname(),
  1018.                         'Birthdate' => $customer->getBirthdate(),
  1019.                         'Address' => $customer->getAddress(),
  1020.                         'Phone' => $customer->getPhone(),
  1021.                         'Cellphone' => $customer->getCellphone(),
  1022.                         'Email' => $customer->getEmail(),
  1023.                         'Password' => $customer->getPassword(),
  1024.                         'Username' => $customer->getUsername(),
  1025.                         'UsernameCanonical' => $customer->getUsernameCanonical(),
  1026.                         'EmailCanonical' => $customer->getEmailCanonical(),
  1027.                         'Enabled' => $customer->getEnabled(),
  1028.                         'Salt' => $customer->getSalt(),
  1029.                         'country_id' => $customer->getCountry()->getCode(),
  1030.                         //'CreatedAt' => $customer->getCreatedAt(),
  1031.                         //'UpdatedAt' => $date,
  1032.                         'CustomerId' => $customer->getId(),
  1033.             ];
  1035.             if ($form->isValid()) {
  1036.                 $userchange = $this->getCustomerInfo($request, $session, $parameterBag, $webService, $twigFolder, $passwordEncoder, $mailer, $customer, $post, $method, $email);
  1037.                 $this->historicalCustomer($historical, $post, $em, null, $customer);
  1039.                 return $this->redirect($errorHandler->errorRedirectNoEmail($twigFolder->pathWithLocale('aviatur_customer_edit_info', ['cityId' => $customer->getCity()->getId(), 'city' => $customer->getCity()->getId(), 'id' => $id]), 'Actualizar Datos', $userchange));
  1040.             } else {
  1041.                 $errors = $validator->validate($customer);
  1042.                 $datos = ['cityId' => $customer->getCity()->getId(), 'city' => $customer->getCity()->getCode(), 'info' => $info, 'form' => $form->createView(), 'errors' => $errors];
  1044.                 return $this->render($twigFolder->twigExists('@AviaturTwig'.$agencyFolder.'/Customer/Customer/customer-edition.html.twig'), $datos);
  1045.             }
  1046.         } else {
  1047.             return $this->render($twigFolder->twigExists('@AviaturTwig/'.$agencyFolder.'/Customer/Customer/customer-edition.html.twig'), ['cityId' => $customer->getCity()->getId(), 'city' => $customer->getCity()->getCode(), 'info' => $info, 'form' => $form->createView()]);
  1048.         }
  1049.     }
  1051.     public function resetPasswordAction(Request $request, SessionInterface $session, AviaturWebService $webService, AviaturErrorHandler $errorHandler, TokenStorageInterface $tokenStorage, TwigFolder $twigFolder, UserPasswordEncoderInterface $passwordEncoder, \Swift_Mailer $mailer, ParameterBagInterface $parameterBag)
  1052.     {
  1053.         $providerService = $parameterBag->get('provider_service');
  1054.         $emailNotification = $parameterBag->get('email_notification');
  1056.         $post = [];
  1057.         $em = $this->getDoctrine()->getManager();
  1058.         $agencyFolder = $twigFolder->twigFlux();
  1059.         $id = $tokenStorage->getToken()->getUser();
  1060.         $customer = $em->getRepository(\Aviatur\CustomerBundle\Entity\Customer::class)->find($id);
  1061.         $post_form = $request->request->get('customer_edit_form');
  1062.         $method = 'password';
  1063.         $CivilStatus = '';
  1064.         if ($customer->getCivilStatus()) {
  1065.             $CivilStatus = $customer->getCivilStatus()->getId();
  1066.         }
  1067.         $date = new DateTime();
  1068.         $historical = (object) [
  1069.                     'Firstname' => $customer->getFirstname(),
  1070.                     'Documentnumber' => $customer->getDocumentnumber(),
  1071.                     'DocumentType' => $customer->getDocumentType()->getCode(),
  1072.                     'Lastname' => $customer->getLastname(),
  1073.                     'Birthdate' => $customer->getBirthdate(),
  1074.                     'Address' => $customer->getAddress(),
  1075.                     'Phone' => $customer->getPhone(),
  1076.                     'Cellphone' => $customer->getCellphone(),
  1077.                     'Email' => $customer->getEmail(),
  1078.                     'Password' => $customer->getPassword(),
  1079.                     'Username' => $customer->getUsername(),
  1080.                     'UsernameCanonical' => $customer->getUsernameCanonical(),
  1081.                     'EmailCanonical' => $customer->getEmailCanonical(),
  1082.                     'Enabled' => $customer->getEnabled(),
  1083.                     'Salt' => $customer->getSalt(),
  1084.                     'country_id' => $customer->getCountry()->getCode(),
  1085.                     //'CreatedAt' => $customer->getCreatedAt(),
  1086.                     //'UpdatedAt' => $date,
  1087.                     'CustomerId' => $customer->getId(),
  1088.         ];
  1089.         if ('POST' == $request->getMethod()) {
  1090.             $post['Firstname'] = $customer->getFirstname();
  1091.             $post['lastname'] = $customer->getLastname();
  1092.             $post['birthdate'] = $customer->getBirthdate()->format('Y-m-d');
  1093.             $post['address'] = $customer->getAddress();
  1094.             $post['phone'] = $customer->getPhone();
  1095.             $post['cellphone'] = $customer->getCellphone();
  1096.             $post['email'] = $customer->getEmail();
  1097.             $post['city'] = $customer->getCity()->getId();
  1098.             $post['country'] = $customer->getCountry()->getId();
  1099.             $post['CivilStatus'] = $CivilStatus;
  1100.             $post['aviaturclientid'] = $customer->getAviaturclientid();
  1101.             $post['DocumentNumber'] = $customer->getDocumentnumber();
  1102.             $post['genderAviatur'] = $customer->getFirstname();
  1103.             $post['acceptInformation'] = $customer->getAcceptInformation();
  1104.             $post['acceptSms'] = $customer->getAcceptSms();
  1105.             $post['password_last'] = $post_form['password_last'];
  1106.             $post['password_new'] = $post_form['password_new'];
  1107.             $post['password_repeat'] = $post_form['password_repeat'];
  1108.             $userchange = $this->getCustomerInfo($request, $session, $parameterBag, $webService, $twigFolder, $passwordEncoder, $mailer, $customer, $post, $method);
  1109.             $this->historicalCustomer($historical, $post, $em, null, $customer);
  1111.             return $this->redirect($errorHandler->errorRedirectNoEmail($twigFolder->pathWithLocale('aviatur_customer_edit_info', ['id' => $id]), 'Actualizar Datos', $userchange));
  1112.         } else {
  1113.             return $this->render($twigFolder->twigExists('@AviaturTwig/'.$agencyFolder.'/Customer/Customer/reset-password-user.html.twig'));
  1114.         }
  1115.     }
  1117.     public function historicalCustomer($customer, $post, $doctrine, $asessor, $newData = null)
  1118.     {
  1119.         $em = !empty($doctrine) ? $doctrine : $this->getDoctrine()->getManager();
  1120.         $country = $em->getRepository(\Aviatur\GeneralBundle\Entity\Country::class)->findOneById($post['country']);
  1121.         $country_id = $country->getCode();
  1122.         $json = '{"fields":[';
  1123.         $json_modfied_fields = null;
  1124.         //Guardamos los datos antiguos en la tabla historical_customer
  1125.         $historicalCustomer = new HistoricalCustomer();
  1126.         //$historicalCustomer->setAviaturclientid($customer->getAviaturclientid());
  1127.         $historicalCustomer->setDocumentnumber($customer->Documentnumber);
  1129.         if ($customer->Documentnumber != $newData->getDocumentnumber()) {
  1130.             if (isset($json_modfied_fields)) {
  1131.                 $json_modfied_fields = $json_modfied_fields.',"Documentnumber"';
  1132.             } else {
  1133.                 $json_modfied_fields = '"Documentnumber"';
  1134.             }
  1135.         }
  1137.         $historicalCustomer->setDocumentTypeId($customer->DocumentType);
  1138.         if ($customer->DocumentType != $newData->getDocumentType()->getCode()) {
  1139.             if (isset($json_modfied_fields)) {
  1140.                 $json_modfied_fields = $json_modfied_fields.',"DocumentType"';
  1141.             } else {
  1142.                 $json_modfied_fields = '"DocumentType"';
  1143.             }
  1144.         }
  1145.         $historicalCustomer->setFirstname($customer->Firstname);
  1146.         if ($customer->Firstname != $newData->getFirstname()) {
  1147.             if (isset($json_modfied_fields)) {
  1148.                 $json_modfied_fields = $json_modfied_fields.',"Firstname"';
  1149.             } else {
  1150.                 $json_modfied_fields = '"Firstname"';
  1151.             }
  1152.         }
  1153.         $historicalCustomer->setLastname($customer->Lastname);
  1154.         if ($customer->Lastname != $newData->getLastname()) {
  1155.             if (isset($json_modfied_fields)) {
  1156.                 $json_modfied_fields = $json_modfied_fields.',"Lastname"';
  1157.             } else {
  1158.                 $json_modfied_fields = '"Lastname"';
  1159.             }
  1160.         }
  1161.         $historicalCustomer->setBirthdate($customer->Birthdate);
  1162.         if ($customer->Birthdate != $newData->getBirthdate()) {
  1163.             if (isset($json_modfied_fields)) {
  1164.                 $json_modfied_fields = $json_modfied_fields.',"Birthdate"';
  1165.             } else {
  1166.                 $json_modfied_fields = '"Birthdate"';
  1167.             }
  1168.         }
  1169.         $historicalCustomer->setAddress($customer->Address);
  1170.         if ($customer->Address != $newData->getAddress()) {
  1171.             if (isset($json_modfied_fields)) {
  1172.                 $json_modfied_fields = $json_modfied_fields.',"Address"';
  1173.             } else {
  1174.                 $json_modfied_fields = '"Address"';
  1175.             }
  1176.         }
  1177.         $historicalCustomer->setPhone($customer->Phone);
  1178.         if ($customer->Phone != $newData->getPhone()) {
  1179.             if (isset($json_modfied_fields)) {
  1180.                 $json_modfied_fields = $json_modfied_fields.',"Phone"';
  1181.             } else {
  1182.                 $json_modfied_fields = '"Phone"';
  1183.             }
  1184.         }
  1185.         $historicalCustomer->setCellphone($customer->Cellphone);
  1186.         if ($customer->Cellphone != $newData->getCellphone()) {
  1187.             if (isset($json_modfied_fields)) {
  1188.                 $json_modfied_fields = $json_modfied_fields.',"Cellphone"';
  1189.             } else {
  1190.                 $json_modfied_fields = '"Cellphone"';
  1191.             }
  1192.         }
  1193.         $historicalCustomer->setEmail($customer->Email);
  1194.         if ($customer->Email != $newData->getEmail()) {
  1195.             if (isset($json_modfied_fields)) {
  1196.                 $json_modfied_fields = $json_modfied_fields.',"Email"';
  1197.             } else {
  1198.                 $json_modfied_fields = '"Email"';
  1199.             }
  1200.         }
  1201.         $historicalCustomer->setPassword($customer->Password);
  1202.         if ($customer->Password != $newData->getPassword()) {
  1203.             if (isset($json_modfied_fields)) {
  1204.                 $json_modfied_fields = $json_modfied_fields.',"Password"';
  1205.             } else {
  1206.                 $json_modfied_fields = '"Password"';
  1207.             }
  1208.         }
  1209.         $historicalCustomer->setUsername($customer->Username);
  1210.         if ($customer->Username != $newData->getUsername()) {
  1211.             if (isset($json_modfied_fields)) {
  1212.                 $json_modfied_fields = $json_modfied_fields.',"Username"';
  1213.             } else {
  1214.                 $json_modfied_fields = '"Username"';
  1215.             }
  1216.         }
  1217.         $historicalCustomer->setUsernameCanonical($customer->UsernameCanonical);
  1218.         if ($customer->UsernameCanonical != $newData->getUsernameCanonical()) {
  1219.             if (isset($json_modfied_fields)) {
  1220.                 $json_modfied_fields = $json_modfied_fields.',"UsernameCanonical"';
  1221.             } else {
  1222.                 $json_modfied_fields = '"UsernameCanonical"';
  1223.             }
  1224.         }
  1225.         $historicalCustomer->setEmailCanonical((string) $customer->EmailCanonical);
  1226.         if ($customer->EmailCanonical != $newData->getEmailCanonical()) {
  1227.             if (isset($json_modfied_fields)) {
  1228.                 $json_modfied_fields = $json_modfied_fields.',"EmailCanonical"';
  1229.             } else {
  1230.                 $json_modfied_fields = '"EmailCanonical"';
  1231.             }
  1232.         }
  1233.         $historicalCustomer->setEnabled($customer->Enabled);
  1234.         $historicalCustomer->setSalt($customer->Salt);
  1235.         if ($customer->Salt != $newData->getSalt()) {
  1236.             if (isset($json_modfied_fields)) {
  1237.                 $json_modfied_fields = $json_modfied_fields.',"Salt"';
  1238.             } else {
  1239.                 $json_modfied_fields = '"Salt"';
  1240.             }
  1241.         }
  1242.         $historicalCustomer->setCityId($customer->country_id);
  1243.         if ($customer->country_id != $country_id) {
  1244.             if (isset($json_modfied_fields)) {
  1245.                 $json_modfied_fields = $json_modfied_fields.',"country_id"';
  1246.             } else {
  1247.                 $json_modfied_fields = '"country_id"';
  1248.             }
  1249.         }
  1250.         //$historicalCustomer->setCreatedAt($customer->CreatedAt);
  1251.         //$historicalCustomer->setUpdatedAt($customer->UpdatedAt);
  1252.         if (isset($asessor) && null != $asessor) {
  1253.             $historicalCustomer->setAsessorID($asessor->getid());
  1254.             $historicalCustomer->setAsessorEmail($asessor->getemail());
  1255.         }
  1257.         //$historicalCustomer->setLocale($customer->getLocale());
  1258.         //$historicalCustomer->setTimezone($customer->getTimezone());
  1260.         $historicalCustomer->setCustomerid($customer->CustomerId);
  1261.         $historicalCustomer->setIpAddres($_SERVER['REMOTE_ADDR']);
  1262.         if (isset($json_modfied_fields)) {
  1263.             $json = $json.$json_modfied_fields.']}';
  1264.             $historicalCustomer->setModifiedfields($json);
  1265. //        var_dump($json);die;
  1266.             try {
  1267. //            var_dump($historicalCustomer);die;
  1268.                 $em->persist($historicalCustomer);
  1269.                 $em->flush();
  1270.             } catch (\Exception $e) {
  1271.             }
  1272.         }
  1273.         //////////////////////////////////////////////////////////////
  1274.     }
  1276.     public function getCustomerInfo(Request $request, SessionInterface $session, ParameterBagInterface $parameterBag, AviaturWebService $webService, TwigFolder $twigFolder, UserPasswordEncoderInterface $passwordEncoder, \Swift_Mailer $mailer, $customer, $post, $method, $email = null, $doctrine = null, $asessor = null)
  1277.     {
  1278.         $em = $this->getDoctrine()->getManager();
  1279.         $agency = $em->getRepository(\Aviatur\AgencyBundle\Entity\Agency::class)->find($session->get('agencyId'));
  1280.         $providerService = $parameterBag->get('provider_service');
  1281.         $emailNotification = $parameterBag->get('email_notification');
  1283.         $passwordEncode = null;
  1284.         $passwordUser = null;
  1285.         $newPassword = null;
  1286.         $repeatPassword = null;
  1287.         $mensaje = null;
  1288.         //var_dump($customer);die();
  1289.         $em = !empty($doctrine) ? $doctrine : $this->getDoctrine()->getManager();
  1290.         $fullRequest = $request;
  1291.         $agencyFolder = $twigFolder->twigFlux();
  1292.         //Get city code in database clientes web
  1293.         $city = $em->getRepository(\Aviatur\GeneralBundle\Entity\City::class)->findOneById($post['city']);
  1294.         $city_id = $city->getCode();
  1296.         $Lastcustomer = $em->getRepository(\Aviatur\CustomerBundle\Entity\Customer::class)->findOneByEmail($post['email']);
  1297.         //Get country code in database clientes web
  1298.         $country = $em->getRepository(\Aviatur\GeneralBundle\Entity\Country::class)->findOneById($post['country']);
  1299.         $country_id = $country->getCode();
  1301.         $customer->setFirstname($post['Firstname']);
  1302.         $customer->setLastname($post['lastname']);
  1303.         $customer->setBirthdate(new \DateTime($post['birthdate']));
  1304.         $customer->setAddress($post['address']);
  1305.         $customer->setPhone($post['phone']);
  1306.         $customer->setCellphone($post['cellphone']);
  1307.         //$customer->setEmail($post['email']);
  1308.         //$customer->setUsername($post['email']);
  1309.         //Get document id code in database clientes web
  1310.         $document = $em->getRepository(\Aviatur\CustomerBundle\Entity\DocumentType::class)->findOneById($customer->getDocumentType()->getId());
  1311.         $document_type_id = $document->getCode();
  1313.         if (4877 == $document_type_id || 11 == $document_type_id) {
  1314.             // if document_type_id == NIT or NIT international
  1315.             $person_type_id = 7;
  1316.         } else {
  1317.             $person_type_id = 8;
  1318.         }
  1320.         //Get civil status code in database clientes web
  1321.         $civilStatus = $em->getRepository(\Aviatur\CustomerBundle\Entity\CivilStatus::class)->findOneById($post['CivilStatus']);
  1322.         if (isset($civilStatus)) {
  1323.             $marital_status_id = $civilStatus->getCode();
  1324.         } else {
  1325.             $marital_status_id = '';
  1326.         }
  1328.         $client_id = $post['aviaturclientid'];
  1329.         $document_number = $post['DocumentNumber'];
  1331.         if ('password' == $method) {
  1332.             $passwordEncode = $passwordEncoder->encodePassword($customer, $post['password_last']);
  1333.             $newPassword = $post['password_new'];
  1334.             $repeatPassword = $post['password_repeat'];
  1335.             $passwordUser = $customer->getPassword();
  1336.             $password = $passwordEncoder->encodePassword($customer, $post['password_new']);
  1337.         } else {
  1338.             $password = $customer->getPassword();
  1339.         }
  1341.         $corporate_name = $customer->getFirstname();
  1342.         $gender = $post['genderAviatur'];
  1343.         if (1 == $gender) {
  1344.             $gender_id = 334;
  1345.         } else {
  1346.             $gender_id = 335;
  1347.         }
  1349.         $state_id = 0;
  1351.         $season_id = 1;
  1352.         $sms_frequency_id = $customer->getFrecuencySms();
  1354.         $info = [
  1355.             'client_id' => $client_id,
  1356.             'person_type_id' => $person_type_id,
  1357.             'corporate_name' => $post['Firstname'],
  1358.             'corporate_id' => $post['DocumentNumber'],
  1359.             'name' => $post['Firstname'],
  1360.             'last_name' => $post['lastname'],
  1361.             'document_type_id' => $document_type_id,
  1362.             'document_number' => $document_number,
  1363.             'gender_id' => $gender_id,
  1364.             'marital_status_id' => $marital_status_id,
  1365.             'birth_date' => $post['birthdate'],
  1366.             'country_id' => $country_id,
  1367.             'state_id' => $state_id,
  1368.             'city_id' => $city_id,
  1369.             'address' => $post['address'],
  1370.             'phone_number' => $post['phone'],
  1371.             'mobile_phone_number' => $post['cellphone'],
  1372.             'password' => $password,
  1373.             'season_id' => '',
  1374.             'class_trip_id' => 0,
  1375.             'accept_information' => $post['acceptInformation'],
  1376.             'accept_sms' => $post['acceptSms'],
  1377.             'status_id' => 1,
  1378.         ];
  1380.         if ($post['email'] != $customer->getUsername()) {
  1381.             $info['email'] = $customer->getUsername();
  1382.         } else {
  1383.             $info['email'] = $post['email'];
  1384.         }
  1386.         //Consulting Id user to modify
  1387.         $customerModel = new CustomerModel();
  1388.         $xmlRequest = $customerModel->getXmlEditUser($info, 2);
  1389.         //Modify User into database
  1390.         if ('password' == $method) {
  1391.             if ($passwordEncode != $passwordUser) {
  1392.                 $mensaje = 'El Campo Contraseña Anterior no corresponse a la asignada al usuario '.$customer->getEmail();
  1393.             } elseif ($newPassword != $repeatPassword) {
  1394.                 $mensaje = 'Los Campos Ingresados No son Iguales, por favor Validar.';
  1395.             } else {
  1396.                 $customer->setPassword($password);
  1397.                 //$em->persist($customer);
  1398.                 $em->flush();
  1399.                 $mensaje = 'La Contraseña del usuario '.$customer->getEmail().' se ha Modificado Correctamente';
  1400.                 $response = $webService->busWebServiceAmadeus('GENERALLAVE', $providerService, $xmlRequest);
  1401.             }
  1402.         } else {
  1403.             if ((is_countable($Lastcustomer) ? count($Lastcustomer) : 0) > 0 && $email != $Lastcustomer->getEmail()) {
  1404.                 $mensaje = 'El Correo '.$customer->getEmail().' ya se encuentra registrado con otro Usuario';
  1405.             } else {
  1406.                 try {
  1407.                     if ($post['email'] != $customer->getUsername()) {
  1408.                         $customer->setEmail($post['email']);
  1409.                         $customer->setUsername($post['email']);
  1410.                         $customer->setEmailCanonical($post['email']);
  1411.                         $tokenTemp = bin2hex(random_bytes(64));
  1412.                         $customer->setTempEmail($post['email']);
  1413.                         $customer->setTempEmailToken($tokenTemp);
  1414.                         $customer->setEmail($email);
  1415.                         $customer->setUsername($email);
  1416.                         if ($agency->getAssetsFolder() == 'octopus') {
  1417.                             $messageEmail = (new \Swift_Message())
  1418.                                 ->setContentType('text/html')
  1419.                                 ->setFrom($session->get('emailNoReply'))
  1420.                                 ->setTo($email)
  1421.                                 ->setSubject('Octopus: Confirmación de Cambios en Tu Correo Electrónico')
  1422.                                 ->setBody($this->renderView($twigFolder->twigExists('@AviaturTwig/' . $agencyFolder . '/Customer/Customer/customer-edition-email.html.twig'), [
  1423.                                     'nameCustomer' => $post['Firstname'],
  1424.                                     'tokenTemp' => $tokenTemp,
  1425.                                     'idCustomer' => $customer->getId(),
  1426.                                 ]), 'text/html');
  1427.                         } else {
  1428.                             $messageEmail = (new \Swift_Message())
  1429.                                 ->setContentType('text/html')
  1430.                                 ->setFrom($session->get('emailNoReply'))
  1431.                                 ->setTo($post['email'])
  1432.                                 ->setSubject('Cambio de email')
  1433.                                 ->setBody($this->renderView($twigFolder->twigExists('@AviaturTwig/' . $agencyFolder . '/Customer/Customer/customer-edition-email.html.twig'), [
  1434.                                     'nameCustomer' => $post['Firstname'],
  1435.                                     'tokenTemp' => $tokenTemp,
  1436.                                     'idCustomer' => $customer->getId(),
  1437.                                 ]), 'text/html');
  1438.                         }
  1439.                         $em->persist($customer);
  1440.                         $em->flush();
  1441.                         $mailer->send($messageEmail);
  1442.                         $mensaje = 'Hemos enviado un mensaje a su correo actual, por favor confírmenos el cambio.';
  1443.                     } elseif ($post['email'] == $customer->getUsername()) {
  1444.                         $customer->setEmail($post['email']);
  1445.                         $customer->setUsername($post['email']);
  1446.                         $customer->setEmailCanonical($post['email']);
  1447.                         $tokenTemp = bin2hex(random_bytes(64));
  1448.                         $customer->setTempEmail($post['email']);
  1449.                         $customer->setTempEmailToken($tokenTemp);
  1450.                         $customer->setEmail($email);
  1451.                         $customer->setUsername($email);
  1452.                         if ($agency->getAssetsFolder() == 'octopus') {
  1453.                             $mensaje = 'Los datos del agente ' . $customer->getFirstname() . ' ' . $customer->getlastname() . ' se modificaron correctamente';
  1454.                             $messageEmail = (new \Swift_Message())
  1455.                                 ->setContentType('text/html')
  1456.                                 ->setFrom($session->get('emailNoReply'))
  1457.                                 ->setTo($email)
  1458.                                 ->setSubject('Notificación de Verificación de Datos en Octopus')
  1459.                                 ->setBody($this->renderView($twigFolder->twigExists('@AviaturTwig/' . $agencyFolder . '/Customer/Customer/customer-edition-data-notification.html.twig'), [
  1460.                                     'nameCustomer' => $post['Firstname'],
  1461.                                     'tokenTemp' => $tokenTemp,
  1462.                                     'idCustomer' => $customer->getId(),
  1463.                                 ]), 'text/html');
  1464.                         } else {
  1465.                             $mensaje = 'Los datos del agente ' . $customer->getFirstname() . ' ' . $customer->getlastname() . ' se modificaron correctamente';
  1466.                             $messageEmail = (new \Swift_Message())
  1467.                                 ->setContentType('text/html')
  1468.                                 ->setFrom($session->get('emailNoReply'))
  1469.                                 ->setTo($post['email'])
  1470.                                 ->setSubject('Notificación')
  1471.                                 ->setBody($this->renderView($twigFolder->twigExists('@AviaturTwig/' . $agencyFolder . '/Customer/Customer/customer-edition-email.html.twig'), [
  1472.                                     'nameCustomer' => $post['Firstname'],
  1473.                                     'tokenTemp' => $tokenTemp,
  1474.                                     'idCustomer' => $customer->getId(),
  1475.                                 ]), 'text/html');
  1476.                         }
  1477.                         $mailer->send($messageEmail);
  1478.                         $em->persist($customer);
  1479.                         $em->flush();
  1480.                     }
  1481.                     if (!isset($doctrine)) {
  1482.                         $response = $webService->busWebServiceAmadeus('GENERALLAVE', $providerService, $xmlRequest);
  1483.                     }
  1484.                 } catch (\Doctrine\DBAL\Exception\UniqueConstraintViolationException $e) {
  1485.                     $mensaje = 'El Correo '.$customer->getEmail().' ya se encuentra registrado con otro Usuario';
  1486.                     //$mensaje = 'El Documento'.$customer->getDocumentType().' :'.$customer->getDocumentnumber().' ya se encuentra registrado con otro Usuario';
  1487.                 } catch (\Aviatur\CustomerBundle\Exception\ValidateException $e) {
  1488.                     $mensaje = 'Información incompleta o inconsistente: '.$e->getMessage();
  1489.                 } catch (\Exception $e) {
  1490.                     $mensaje = 'Se produjo un error al editar los datos, Por favor contactate con nosotros para mejor información.';
  1491.                 }
  1492.             }
  1493.         }
  1494.         if (!isset($response)) {
  1495.             $mensaje = $mensaje;
  1496.         } elseif (('FALLO' == $response->RESULTADO)) {
  1497.             $mailInfo = print_r($info, true).'<br>'.print_r($response, true);
  1498.             $message = (new \Swift_Message())
  1499.                     ->setContentType('text/html')
  1500.                     ->setFrom($session->get('emailNoReply'))
  1501.                     ->setTo('b_botina@aviatur.com', $emailNotification , 'negocioselectronicos@aviatur.com.co')
  1502.                     ->setSubject('Error Al Modificar Usuario en Base de Datos Clientes Web')
  1503.                     ->setBody($mailInfo);
  1504.             $mailer->send($message);
  1505.             $mensaje = 'Se produjo un error al editar los datos, Por Favor Contactate con Nosotros';
  1506.         } /* else {
  1507.           $em->flush();
  1508.           } */
  1510.         return $mensaje;
  1511.     }
  1513.     public function setNewEmailAction(Request $request, SessionInterface $session, ParameterBagInterface $parameterBag, AviaturWebService $webService, AviaturErrorHandler $errorHandler, \Swift_Mailer $mailer, $customerId, $token)
  1514.     {
  1515.         $providerService = $parameterBag->get('provider_service');
  1516.         $emailNotification = $parameterBag->get('email_notification');
  1518.         $em = $this->getDoctrine()->getManager();
  1519.         $fullRequest = $request;
  1520.         $customer = $em->getRepository(\Aviatur\CustomerBundle\Entity\Customer::class)->findOneById($customerId);
  1521.         //var_dump($customer);die();
  1522.         if (!$customer) {
  1523.             return $this->redirect($errorHandler->errorRedirectNoEmail($this->generateUrl('aviatur_general_homepage'), '', 'Ha ocurrido un error'));
  1524.         }
  1525.         if ($customerId && $token) {
  1526.             if (!is_null($customer->getTempEmailToken()) && !is_null($customer->getTempEmail())) {
  1527.                 if ($customerId == $customer->getId() && $token == $customer->getTempEmailToken()) {
  1528.                     $null = null;
  1530.                     $city = $em->getRepository(\Aviatur\GeneralBundle\Entity\City::class)->findOneById($customer->getCity()->getId());
  1531.                     $city_id = $city->getCode();
  1532.                     //Get country code in database clientes web
  1533.                     $country = $em->getRepository(\Aviatur\GeneralBundle\Entity\Country::class)->findOneById($customer->getCountry()->getId());
  1534.                     $country_id = $country->getCode();
  1535.                     $document = $em->getRepository(\Aviatur\CustomerBundle\Entity\DocumentType::class)->findOneById($customer->getDocumentType()->getId());
  1536.                     $document_type_id = $document->getCode();
  1538.                     if (4877 == $document_type_id || 11 == $document_type_id) {
  1539.                         // if document_type_id == NIT or NIT international
  1540.                         $person_type_id = 7;
  1541.                     } else {
  1542.                         $person_type_id = 8;
  1543.                     }
  1545.                     //Get civil status code in database clientes web
  1546.                     $civilStatus = $em->getRepository(\Aviatur\CustomerBundle\Entity\CivilStatus::class)->findOneById($customer->getCivilStatus());
  1547.                     if (isset($civilStatus)) {
  1548.                         $marital_status_id = $civilStatus->getCode();
  1549.                     } else {
  1550.                         $marital_status_id = '';
  1551.                     }
  1553.                     //$document_number = $post['DocumentNumber'];
  1554.                     $password = $customer->getPassword();
  1555.                     $corporate_name = $customer->getFirstname();
  1556.                     $gender = $customer->getGenderAviatur()->getCode();
  1557.                     if (1 == $gender) {
  1558.                         $gender_id = 334;
  1559.                     } else {
  1560.                         $gender_id = 335;
  1561.                     }
  1563.                     $state_id = 0;
  1565.                     $season_id = 1;
  1566.                     $sms_frequency_id = $customer->getFrecuencySms();
  1568.                     $info = [
  1569.                         'client_id' => $customer->getAviaturclientid(),
  1570.                         'person_type_id' => $person_type_id,
  1571.                         'corporate_name' => $customer->getFirstname(),
  1572.                         'corporate_id' => $customer->getDocumentnumber(),
  1573.                         'name' => $customer->getFirstname(),
  1574.                         'last_name' => $customer->getLastname(),
  1575.                         'document_type_id' => $document_type_id,
  1576.                         'document_number' => $customer->getDocumentnumber(),
  1577.                         'gender_id' => $gender_id,
  1578.                         'marital_status_id' => $marital_status_id,
  1579.                         'birth_date' => $customer->getBirthdate()->format('Y-m-d'),
  1580.                         'country_id' => $country_id,
  1581.                         'state_id' => $state_id,
  1582.                         'city_id' => $city_id,
  1583.                         'address' => $customer->getAddress(),
  1584.                         'phone_number' => $customer->getPhone(),
  1585.                         'mobile_phone_number' => $customer->getCellphone(),
  1586.                         'password' => $customer->getPassword(),
  1587.                         'season_id' => '',
  1588.                         'class_trip_id' => 0,
  1589.                         'accept_information' => $customer->getAcceptinformation(),
  1590.                         'accept_sms' => $customer->getAcceptsms(),
  1591.                         'status_id' => 1,
  1592.                         'email' => $customer->getTempEmail(),
  1593.                     ];
  1594.                     $customerModel = new CustomerModel();
  1595.                     $xmlRequest = $customerModel->getXmlEditUser($info, 2);
  1596.                     $response = $webService->busWebServiceAmadeus('GENERALLAVE', $providerService, $xmlRequest);
  1597.                     if (!isset($response)) {
  1598.                         $mensaje = $mensaje;
  1599.                     } elseif (('FALLO' == $response->RESULTADO)) {
  1600.                         $mailInfo = print_r($info, true).'<br>'.print_r($response, true);
  1601.                         $message = (new \Swift_Message())
  1602.                                 ->setContentType('text/html')
  1603.                                 ->setFrom($session->get('emailNoReply'))
  1604.                                 ->setTo('b_botina@aviatur.com', $emailNotification , 'negocioselectronicos@aviatur.com.co')
  1605.                                 ->setSubject('Error Al Modificar Usuario en Base de Datos Clientes Web')
  1606.                                 ->setBody($mailInfo);
  1607.                         $mailer->send($message);
  1608.                         $mensaje = 'Se produjo un error al editar los datos, Por Favor Contactate con Nosotros';
  1609.                     }
  1611.                     $customer->setEmail($customer->getTempEmail());
  1612.                     $customer->setUsername($customer->getTempEmail());
  1613.                     $customer->setEmailCanonical($customer->getTempEmail());
  1614.                     $customer->setTempEmailToken($null);
  1615.                     $customer->setTempEmail($null);
  1616.                     $em->persist($customer);
  1617.                     $em->flush();
  1619.                     return $this->redirect($errorHandler->errorRedirectNoEmail($this->generateUrl('aviatur_general_homepage'), 'Felicidades', 'Cambio satifactorio de email'));
  1620.                 } else {
  1621.                     return $this->redirect($errorHandler->errorRedirectNoEmail($this->generateUrl('aviatur_general_homepage'), 'Error', 'Ha ocurrido un error'));
  1622.                 }
  1623.             } else {
  1624.                 return $this->redirect($errorHandler->errorRedirectNoEmail($this->generateUrl('aviatur_general_homepage'), 'Error', 'Ha ocurrido un error'));
  1625.             }
  1626.         } else {
  1627.             return $this->redirect($errorHandler->errorRedirectNoEmail($this->generateUrl('aviatur_general_homepage'), 'Error', 'Direccion url incorrecta'));
  1628.         }
  1629.     }
  1631.     public function getpaymentMethodsSavedAction(TwigFolder $twigFolder, CustomerMethodPaymentService $methodPaymentService, AviaturLoginService $loginService)
  1632.     {
  1633.         $em = $this->getDoctrine()->getManager();
  1634.         $typeDocument = $em->getRepository(\Aviatur\CustomerBundle\Entity\DocumentType::class)->findAll();
  1635.         $infoSaved = [];
  1636.         if (false !== $loginService->validActiveSession()) {
  1637.             $customer = $this->getUser();
  1638.             $infoMethodPaymentByClient = $methodPaymentService->getMethodsByCustomer($customer, false);
  1639.             if ('NoInfo' !== $infoMethodPaymentByClient['info']) {
  1640.                 foreach ($infoMethodPaymentByClient['info'] as $key => $value) {
  1641.                     $infoSaved['info'][] = [substr($key, 0, 2), substr($key, 2, 4)];
  1642.                 }
  1643.             }
  1644.         }
  1645.         $infoSaved['doc_type'] = $typeDocument;
  1646.         $newsletter = new Newsletter();
  1647.         $newsletterForm = $this->createForm(\Aviatur\FormBundle\Form\NewsletterAsyncType::class, $newsletter);
  1648.         $infoSaved['newsletter_form'] = $newsletterForm->createView();
  1649.         $agencyFolder = $twigFolder->twigFlux();
  1650.         $twigView = $twigFolder->twigExists('@AviaturTwig/'.$agencyFolder.'/Customer/Customer/customer-payments-saved.html.twig');
  1652.         return $this->render($twigView, $infoSaved);
  1653.     }
  1655.     public function saveNewCardAction(Request $request, TokenizerService $tokenizerService, TokenStorageInterface $tokenStorage)
  1656.     {
  1657.         if ($request) {
  1658.             $em = $this->getDoctrine()->getManager();
  1659.             $customer = $tokenStorage->getToken()->getUser();
  1660.             $cardNumToken = $tokenizerService->getToken($request->request->get('cardNum'));
  1661.             $fecha = new \DateTime();
  1662.             $franchise = $request->request->get('franqui');
  1663.             $numcard = \substr($request->request->get('cardNum'), -4, 4);
  1664.             $new_method_payment = [
  1665.                 $franchise.$numcard => [
  1666.                     'token' => $cardNumToken, //['card_num'],
  1667.                     'firstname' => $request->request->get('nombreCard'),
  1668.                     'lastname' => $request->request->get('apellidoCard'),
  1669.                     'datevig' => $request->request->get('cardExp'),
  1670.                     'datecreation' => $fecha->format('Y-m-d H:i:s'),
  1671.                     'typeDocument' => $request->request->get('docType'),
  1672.                     'documentNumber' => $request->request->get('docNum'),
  1673.                     'status' => 'NOTVERIFIED',
  1674.                 ],
  1675.             ];
  1677.             $paymentMethodsCustomer = $em->getRepository(\Aviatur\PaymentBundle\Entity\PaymentMethodCustomer::class)->findBy(['customer' => $customer]);
  1679.             if (count($paymentMethodsCustomer) > 0) {
  1680.                 $actualInfo = json_decode($paymentMethodsCustomer[0]->getInfoPaymentMethod(), true);
  1682.                 $preExist = array_intersect_key($new_method_payment, $actualInfo);
  1684.                 if (count($preExist) > 0) {
  1685.                     foreach ($preExist as $key => $value) {
  1686.                         $actualInfo[$key]['status'] = 'REPLACED';
  1687.                         $actualInfo[$key.'_'.$fecha->format('YmdHis')] = $actualInfo[$key];
  1688.                         unset($actualInfo[$key]);
  1689.                     }
  1690.                 }
  1691.                 $newInfo = array_merge($actualInfo, $new_method_payment);
  1692.                 $paymentMethodsCustomer[0]->setInfoPaymentMethod(json_encode($newInfo));
  1693.             } else {
  1694.                 $newMethodObject = new PaymentMethodCustomer();
  1695.                 $newMethodObject->setCustomer($customer);
  1696.                 $newMethodObject->setInfoPaymentMethod(json_encode($new_method_payment));
  1697.                 $newMethodObject->setIsactive(true);
  1698.                 $em->persist($newMethodObject);
  1699.             }
  1700.             $em->flush();
  1702.             return $this->json(['status' => 'success']);
  1703.         }
  1704.     }
  1706.     public function setMethodsByCustomer($customer, $infoCard)
  1707.     {
  1708.         $fecha = new \DateTime();
  1709.         $franchise = $infoCard['franqui'];
  1710.         $numcard = \substr($infoCard['cardNum'], -4, 4);
  1711.         $new_method_payment = [
  1712.             $franchise.$numcard => [
  1713.                 'token' => $infoCard['cardNum'], //['card_num'],
  1714.                 'firstname' => $infoCard['nombreCard'],
  1715.                 'lastname' => $infoCard['apellidoCard'],
  1716.                 'datevig' => $infoCard['cardExp'],
  1717.                 'datecreation' => $fecha->format('Y-m-d H:i:s'),
  1718.                 'typeDocument' => $infoCard['docType'],
  1719.                 'documentNumber' => $infoCard['docNum'],
  1720.                 'status' => 'NOTVERIFIED',
  1721.             ],
  1722.         ];
  1724.         $paymentMethodsCustomer = $this->em->getRepository(\Aviatur\PaymentBundle\Entity\PaymentMethodCustomer::class)->findBy(['customer' => $customer]);
  1726.         if ((is_countable($paymentMethodsCustomer) ? count($paymentMethodsCustomer) : 0) > 0) {
  1727.             $actualInfo = json_decode($paymentMethodsCustomer[0]->getInfoPaymentMethod(), true);
  1729.             $preExist = array_intersect_key($new_method_payment, $actualInfo);
  1731.             if (count($preExist) > 0) {
  1732.                 foreach ($preExist as $key => $value) {
  1733.                     $actualInfo[$key]['status'] = 'REPLACED';
  1734.                     $actualInfo[$key.'_'.$fecha->format('YmdHis')] = $actualInfo[$key];
  1735.                     unset($actualInfo[$key]);
  1736.                 }
  1737.             }
  1738.             $newInfo = array_merge($actualInfo, $new_method_payment);
  1739.             $paymentMethodsCustomer[0]->setInfoPaymentMethod(json_encode($newInfo));
  1740.         } else {
  1741.             $newMethodObject = new PaymentMethodCustomer();
  1742.             $newMethodObject->setCustomer($customer);
  1743.             $newMethodObject->setInfoPaymentMethod(json_encode($new_method_payment));
  1744.             $newMethodObject->setIsactive(true);
  1745.             $this->em->persist($newMethodObject);
  1746.         }
  1747.         $this->em->flush();
  1748.     }
  1750.     public function deletePaymentsSavedAction(Request $request, CustomerMethodPaymentService $methodPaymentService, AviaturErrorHandler $errorHandler)
  1751.     {
  1752.         $cardKey = $request->request->get('keycardtodelete');
  1753.         $customer = $this->getUser();
  1754.         $methodPaymentService->deleteMethodsByCustomer($customer, $cardKey);
  1755.         $redirectRoute = 'aviatur_customer_show_saved_pay_info';
  1757.         return $this->redirect($errorHandler->errorRedirectNoEmail($this->generateUrl($redirectRoute), 'Información actualizada', 'Se actualizaron los medios de pago almacenados'));
  1758.     }
  1760.     public function deleteCardSavedAjaxAction(Request $request, CustomerMethodPaymentService $methodPaymentService)
  1761.     {
  1762.         $cardKey = $request->request->get('key');
  1763.         $customer = $this->getUser();
  1764.         $methodPaymentService->deleteMethodsByCustomer($customer, $cardKey);
  1766.         return $this->json(['status' => 'success']);
  1767.     }
  1769.     public function billingViewAction(TwigFolder $twigFolder, TokenStorageInterface $tokenStorage)
  1770.     {
  1771.         $agencyFolder = $twigFolder->twigFlux();
  1772.         $em = $this->getDoctrine()->getManager();
  1773.         $userLogged = $tokenStorage->getToken()->getUser()->getId();
  1774.         $billingList = $em->getRepository(\Aviatur\CustomerBundle\Entity\CustomerBillingList::class)->findByCustomer($userLogged);
  1775.         //var_dump($billingList);die();
  1776.         $typeDocument = $em->getRepository(\Aviatur\CustomerBundle\Entity\DocumentType::class)->findAll();
  1777.         if ($billingList) {
  1778.             $data = [];
  1779.             $count = 0;
  1780.             foreach ($billingList as $billings) {
  1781.                 if ('ACTIVE' == $billings->getStatus()) {
  1782.                     $data[$count]['id'] = $billings->getId();
  1783.                     $data[$count]['customerId'] = $userLogged;
  1784.                     $data[$count]['documentType'] = $billings->getDocumentType()->getExternalCode();
  1785.                     $data[$count]['documentNumber'] = $billings->getDocumentnumber();
  1786.                     $data[$count]['firstname'] = $billings->getFirstname();
  1787.                     $data[$count]['lastname'] = $billings->getLastname();
  1788.                     $data[$count]['email'] = $billings->getEmail();
  1789.                     $data[$count]['address'] = $billings->getAddress();
  1790.                     $data[$count]['phone'] = $billings->getPhone();
  1791.                     $data[$count]['country'] = ((null != $billings->getCountry()) && ('' != $billings->getCountry())) ? $billings->getCountry()->getIataCode() : null;
  1792.                     $data[$count]['countryname'] = ((null != $billings->getCountry()) && ('' != $billings->getCountry())) ? \ucwords(\mb_strtolower($billings->getCountry()->getDescription())).' ('.$billings->getCountry()->getIataCode().')' : null;
  1793.                     $data[$count]['city'] = $billings->getCity()->getIataCode();
  1794.                     $data[$count]['cityname'] = ((null != $billings->getCity()) && ('' != $billings->getCity())) ? \ucwords(\mb_strtolower($billings->getCity()->getDescription())).' ('.$billings->getCity()->getIataCode().')' : null;
  1795.                     ++$count;
  1796.                 }
  1797.             }
  1798.         } else {
  1799.             $data = null;
  1800.         }
  1802.         /* $country = $em->getRepository(\Aviatur\GeneralBundle\Entity\Country::class)->createQueryBuilder('u')->where('u.languagecode = :languagecode')->setParameter('languagecode', 'es-ES')->orderBy('u.description', 'ASC')->getQuery()->getResult();
  1803.           var_dump($country);die; */
  1804.         /* $city = $em->getRepository(\Aviatur\GeneralBundle\Entity\City::class)->findByCountry($customer->getCountry()->getId(), array('description' => 'ASC'));
  1805.           foreach ($city as $infocities) {
  1806.           $idCity[] = $infocities->getCode();
  1807.           $nameCity[] = $infocities->getDescription();
  1808.           }
  1809.           $info = array('idCity' => $idCity, 'nameCity' => $nameCity); */
  1810.         $twigView = $twigFolder->twigExists('@AviaturTwig/'.$agencyFolder.'/Customer/Customer/customer-billing-view.html.twig');
  1812.         return $this->render($twigView, ['billings' => $data, 'doc_type' => $typeDocument]);
  1813.     }
  1815.     public function billingListAction(TokenStorageInterface $tokenStorage)
  1816.     {
  1817.         $em = $this->getDoctrine()->getManager();
  1818.         $userLogged = $tokenStorage->getToken()->getUser()->getId();
  1819.         $billingList = $em->getRepository(\Aviatur\CustomerBundle\Entity\CustomerBillingList::class)->findByCustomer($userLogged);
  1820.         if ($billingList) {
  1821.             $data = [];
  1822.             $count = 0;
  1823.             foreach ($billingList as $billings) {
  1824.                 if ('ACTIVE' == $billings->getStatus()) {
  1825.                     $data[$count]['id'] = $billings->getId();
  1826.                     $data[$count]['customerId'] = $userLogged;
  1827.                     $data[$count]['documentType'] = $billings->getDocumentType()->getExternalCode();
  1828.                     $data[$count]['documentNumber'] = $billings->getDocumentnumber();
  1829.                     $data[$count]['firstname'] = $billings->getFirstname();
  1830.                     $data[$count]['lastname'] = $billings->getLastname();
  1831.                     $data[$count]['email'] = $billings->getEmail();
  1832.                     $data[$count]['address'] = $billings->getAddress();
  1833.                     $data[$count]['phone'] = $billings->getPhone();
  1834.                     ++$count;
  1835.                 }
  1836.             }
  1837.         } else {
  1838.             $data = null;
  1839.         }
  1841.         return $this->json($data);
  1842.     }
  1844.     public function billingDeleteAction(Request $request, TokenStorageInterface $tokenStorage)
  1845.     {
  1846.         $idBilling = $request->request->get('idBilling');
  1847.         $em = $this->getDoctrine()->getManager();
  1848.         //$userLogged = $tokenStorage->getToken()->getUser()->getId();
  1849.         $billing = $em->getRepository(\Aviatur\CustomerBundle\Entity\CustomerBillingList::class)->find($idBilling);
  1850.         $billing->setStatus('ERASED');
  1851.         $em->flush();
  1853.         return $this->json(['status' => 'success']);
  1854.     }
  1856.     public function billingAddOrEditAction(Request $request, TokenStorageInterface $tokenStorage)
  1857.     {
  1858.         $em = $this->getDoctrine()->getManager();
  1859.         $documentType = $em->getRepository(\Aviatur\CustomerBundle\Entity\DocumentType::class)->findByExternalcode($request->request->get('doc_type'));
  1860.         $userLogged = $tokenStorage->getToken()->getUser();
  1861.         if ($request) {
  1862.             $fecha = new \DateTime();
  1863.             if ('' != $request->request->get('id')) {
  1864.                 $billing = $em->getRepository(\Aviatur\CustomerBundle\Entity\CustomerBillingList::class)->find($request->request->get('id'));
  1865.                 if (!$billing) {
  1866.                     return $this->json([
  1867.                                 'status' => 'error',
  1868.                                 'message' => 'Usuario no existe',
  1869.                     ]);
  1870.                 }
  1871.                 $dataCountry = $em->getRepository(\Aviatur\GeneralBundle\Entity\Country::class)->findOneByIatacode($request->request->get('country'));
  1872.                 if (!$dataCountry) {
  1873.                     return $this->json([
  1874.                                 'status' => 'error',
  1875.                                 'message' => 'País no existe',
  1876.                     ]);
  1877.                 }
  1878.                 $dataCity = $em->getRepository(\Aviatur\GeneralBundle\Entity\City::class)->findOneByIatacode($request->request->get('city'));
  1879.                 if (!$dataCountry) {
  1880.                     return $this->json([
  1881.                                 'status' => 'error',
  1882.                                 'message' => 'Ciudad no existe',
  1883.                     ]);
  1884.                 }
  1886.                 $billing->setDocumentnumber($request->request->get('doc_num'));
  1887.                 $billing->setDocumentType($documentType[0]);
  1888.                 $billing->setCustomer($userLogged);
  1889.                 $billing->setFirstname($request->request->get('first-name'));
  1890.                 $billing->setLastname($request->request->get('last-name'));
  1891.                 $billing->setEmail($request->request->get('email'));
  1892.                 $billing->setAddress($request->request->get('address'));
  1893.                 $billing->setPhone($request->request->get('phone'));
  1894.                 $billing->setCountry($dataCountry);
  1895.                 $billing->setCity($dataCity);
  1896.                 $billing->setUpdated($fecha->format('Y-m-d H:i:s'));
  1897.             } else {
  1898.                 $dataCountry = $em->getRepository(\Aviatur\GeneralBundle\Entity\Country::class)->findOneByIatacode($request->request->get('country'));
  1899.                 if (!$dataCountry) {
  1900.                     return $this->json([
  1901.                                 'status' => 'error',
  1902.                                 'message' => 'País no existe',
  1903.                     ]);
  1904.                 }
  1905.                 $dataCity = $em->getRepository(\Aviatur\GeneralBundle\Entity\City::class)->findOneByIatacode($request->request->get('city'));
  1906.                 if (!$dataCountry) {
  1907.                     return $this->json([
  1908.                                 'status' => 'error',
  1909.                                 'message' => 'Ciudad no existe',
  1910.                     ]);
  1911.                 }
  1912.                 $billing = new CustomerBillingList();
  1913.                 $billing->setDocumentnumber($request->request->get('doc_num'));
  1914.                 $billing->setDocumentType($documentType[0]);
  1915.                 $billing->setCustomer($userLogged);
  1916.                 $billing->setFirstname($request->request->get('first-name'));
  1917.                 $billing->setLastname($request->request->get('last-name'));
  1918.                 $billing->setEmail($request->request->get('email'));
  1919.                 $billing->setAddress($request->request->get('address'));
  1920.                 $billing->setPhone($request->request->get('phone'));
  1921.                 $billing->setCountry($dataCountry);
  1922.                 $billing->setCity($dataCity);
  1923.                 $billing->setStatus('ACTIVE');
  1924.                 $billing->setCreated($fecha->format('Y-m-d H:i:s'));
  1925.                 $billing->setUpdated($fecha->format('Y-m-d H:i:s'));
  1926.                 $em->persist($billing);
  1927.             }
  1928.             $em->flush();
  1930.             return $this->json([
  1931.                         'status' => 'success',
  1932.                         'message' => 'Registro creado',
  1933.             ]);
  1934.         } else {
  1935.             return $this->json([
  1936.                         'status' => 'error',
  1937.                         'message' => 'Ha ocurrido un error',
  1938.             ]);
  1939.         }
  1940.     }
  1942.     public function getCitiesAjaxAction(Request $request)
  1943.     {
  1944.         $data = [];
  1945.         $em = $this->getDoctrine()->getManager();
  1946.         $term = $request->request->get('term') ?: null;
  1947.         if (!is_null($term)) {
  1948.             $em = $this->getDoctrine()->getManager();
  1949.             $json_template = '<value>:<label>-';
  1950.             $countries = $em->getRepository(\Aviatur\GeneralBundle\Entity\Country::class)->findByOrWithSingleValue(['iatacode', 'description'], $term);
  1951.             $json = [];
  1952.             if ($countries) {
  1953.                 $data = [];
  1954.                 $count = 0;
  1955.                 foreach ($countries as $country) {
  1956.                     $data[$count]['id'] = $count;
  1957.                     $data[$count]['code'] = $country['iata'];
  1958.                     $data[$count]['label'] = ucwords(mb_strtolower($country['description']));
  1959.                     /* $arraytmp = array(
  1960.                       'description' => ucwords(mb_strtolower($country['description'])),
  1961.                       'iata' => $country['iata']
  1962.                       );
  1963.                       array_push($json, $arraytmp); */
  1964.                 }
  1965.             } else {
  1966.                 $json['error'] = 'No hay Resultados';
  1967.             }
  1969.             return $this->json($data);
  1970.         } else {
  1971.             return $this->json(['error' => 'Termino de consulta invalido']);
  1972.         }
  1973.         /* $city = $em->getRepository(\Aviatur\GeneralBundle\Entity\City::class)->findByCountry("165", array('description' => 'ASC'));
  1974.           $data = [];
  1975.           $count = 0;
  1976.           foreach ($city as $infocities) {
  1977.           $data[$count]['id'] = $infocities->getId();
  1978.           $data[$count]['code'] = $infocities->getCode();
  1979.           $data[$count]['name'] = $infocities->getDescription();
  1980.           $count++;
  1981.           }
  1983.           return $this->json(array(
  1984.           "status" => "success",
  1985.           "data" => array($data)
  1986.           )); */
  1987.     }
  1989.     public function searchCountryAction(Request $request)
  1990.     {
  1991.         $data = json_decode($request->getContent());
  1992.         $term = $request->request->get('term') ?: null;
  1993.         if (!is_null($term)) {
  1994.             $em = $this->getDoctrine()->getManager();
  1995.             $json_template = '<value>:<label>-';
  1996.             $countries = $em->getRepository(\Aviatur\GeneralBundle\Entity\Country::class)->findByOrWithSingleValue(['iatacode', 'description'], $term);
  1997.             $json = [];
  1998.             if ($countries) {
  1999.                 foreach ($countries as $country) {
  2000.                     $arraytmp = [
  2001.                         'description' => ucwords(mb_strtolower($country['description'])),
  2002.                         'iata' => $country['iata'],
  2003.                     ];
  2004.                     array_push($json, $arraytmp);
  2005.                 }
  2006.             } else {
  2007.                 $json['error'] = 'No hay Resultados';
  2008.             }
  2010.             return $this->json(['country' => $json]);
  2011.         } else {
  2012.             return $this->json(['error' => 'Termino de consulta invalido']);
  2013.         }
  2014.     }
  2016.     public function getCitiesAction(Request $request, TwigFolder $twigFolder)
  2017.     {
  2018.         $em = $this->getDoctrine()->getManager();
  2019.         $agencyFolder = $twigFolder->twigFlux();
  2020.         $country = $request->request->get('country');
  2021.         $id = $request->request->get('id');
  2022.         $customer = $em->getRepository(\Aviatur\CustomerBundle\Entity\Customer::class)->find($id);
  2023.         $city = $em->getRepository(\Aviatur\GeneralBundle\Entity\City::class)->findByCountry($country, ['description' => 'ASC']);
  2025.         foreach ($city as $infocities) {
  2026.             $idCity[] = $infocities->getId();
  2027.             $iataCity[] = $infocities->getIatacode();
  2028.             $nameCity[] = $infocities->getDescription();
  2029.         }
  2030.         $info = ['idCity' => $idCity, 'iataCity' => $iataCity, 'nameCity' => $nameCity];
  2032.         return $this->json($info);
  2033.     }
  2035.     public function frozenRateAction(TwigFolder $twigFolder, TokenStorageInterface $tokenStorage)
  2036.     {
  2037.         $agencyFolder = $twigFolder->twigFlux();
  2038.         $em = $this->getDoctrine()->getManager();
  2039.         $freezeData = $em->getRepository(\Aviatur\RestBundle\Entity\HopperFreeze::class)->findByCustomerid($tokenStorage->getToken()->getUser()->getId());
  2040.         if (!$freezeData) {
  2041.             return $this->render($twigFolder->twigExists('@AviaturTwig/'.$agencyFolder.'/Customer/Customer/frozen-rate.html.twig'), ['status' => false, 'data' => null, 'message' => 'No tiene tarifas congeladas']);
  2042.         }
  2043.         $arrayFreeze = [];
  2044.         for ($i = 0; $i < (is_countable($freezeData) ? count($freezeData) : 0); ++$i) {
  2045.             // Obtener la informaqción de vuelo en formato JSON
  2046.             $infoFlight = json_decode($freezeData[$i]->getIdRouteFlight()->getInfo());
  2047.             // Obtener la información de ida y regreso en formato JSON
  2048.             $infoIda = json_decode($infoFlight->selection[0]);
  2049.             $infoRegreso = null;
  2050.             $infoRegresoDate = null;
  2051.             $infoRegreso2 = null;
  2052.             setlocale(LC_TIME, 'spanish');
  2053.             if ((is_countable($infoFlight->selection) ? count($infoFlight->selection) : 0) > 1) {
  2054.                 $infoRegreso = json_decode($infoFlight->selection[1]);
  2055.                 $infoRegresoDate = strftime('%d %B del %Y', strtotime(date('d-m-Y', $infoRegreso->S[0]->E)));
  2056.                 $infoRegreso = $infoRegreso->S[0]->O;
  2057.                 $infoRegreso2 = $infoIda->S[0]->O;
  2058.             }
  2059.             //Calcular los días restantes
  2060.             $date1 = new \DateTime('now');
  2061.             $date2 = json_decode(json_encode($freezeData[$i]->getFinishDate()), true);
  2062.             $diff = $date1->diff(new \DateTime($date2['date']));
  2063.             $a = (1 == $diff->invert) ? '-'.$diff->days : $diff->days;
  2065.             $paymentInfo = json_decode($freezeData[$i]->getFlightInfo(), true);
  2066.             $used = 'used' == $freezeData[$i]->getState() ? 'Usado' : 'Activo';
  2068.             array_push($arrayFreeze, [
  2069.                 'FlightInfo' => [
  2070.                     'Going' => [
  2071.                         'Date' => strftime('%d %B del %Y', strtotime(date('d-m-Y', $infoIda->S[0]->E))),
  2072.                         'Origin' => [
  2073.                             'Code' => $infoIda->S[0]->O,
  2074.                         ],
  2075.                         'Destination' => [
  2076.                             'Code' => $infoIda->S[0]->D,
  2077.                         ],
  2078.                     ],
  2079.                     'Return' => [
  2080.                         'Date' => $infoRegresoDate,
  2081.                         'Origin' => [
  2082.                             'Code' => $infoRegreso,
  2083.                         ],
  2084.                         'Destination' => [
  2085.                             'Code' => $infoRegreso2,
  2086.                         ],
  2087.                     ],
  2088.                 ],
  2089.                 'Dates' => [
  2090.                     'DateCreated' => $freezeData[$i]->getCreationDate(),
  2091.                     'DateExpiration' => $freezeData[$i]->getFinishDate(),
  2092.                     'DaysLeft' => (int) $a,
  2093.                 ],
  2094.                 'Url' => $freezeData[$i]->getIdRouteFlight()->getUrl(),
  2095.                 'Prices' => [
  2096.                     'PriceHopper' => $freezeData[$i]->getInfoHopper(),
  2097.                     'PriceFlight' => $paymentInfo['x_total_payment']['x_amount'] + $paymentInfo['x_total_payment']['x_airport_tax'] + $paymentInfo['x_total_payment']['x_service_fee'],
  2098.                     'MaxHopperCover' => $freezeData[$i]->getMaxHopperCover(),
  2099.                 ],
  2100.                 'state' => ((int) $a <= 0) ? 'Expirado' : $used,
  2101.             ]);
  2102.         }
  2103.         //var_dump(json_encode($arrayFreeze));die;
  2104.         //var_dump($arrayFreeze);die;
  2105.         return $this->render($twigFolder->twigExists('@AviaturTwig/'.$agencyFolder.'/Customer/Customer/frozen-rate.html.twig'), ['status' => true, 'data' => $arrayFreeze]);
  2106.     }
  2108.     public function sanear_string($string)
  2109.     {
  2110.         $string = trim($string);
  2111.         $string = str_replace(
  2112.             ['á', 'à', 'ä', 'â', 'ª'],
  2113.             ['a', 'a', 'a', 'a', 'a'],
  2114.             $string
  2115.         );
  2116.         $string = str_replace(
  2117.             ['é', 'è', 'ë', 'ê'],
  2118.             ['e', 'e', 'e', 'e'],
  2119.             $string
  2120.         );
  2121.         $string = str_replace(
  2122.             ['í', 'ì', 'ï', 'î'],
  2123.             ['i', 'i', 'i', 'i'],
  2124.             $string
  2125.         );
  2126.         $string = str_replace(
  2127.             ['ó', 'ò', 'ö', 'ô'],
  2128.             ['o', 'o', 'o', 'o'],
  2129.             $string
  2130.         );
  2131.         $string = str_replace(
  2132.             ['ú', 'ù', 'ü', 'û'],
  2133.             ['u', 'u', 'u', 'u'],
  2134.             $string
  2135.         );
  2136.         $string = str_replace(
  2137.             ['ç'],
  2138.             ['c'],
  2139.             $string
  2140.         );
  2141.         //Esta parte se encarga de eliminar cualquier caracter extraño
  2142.         $string = str_replace(
  2143.             ['\\', '¨', 'º', '-', '~',
  2144.             '#', '|', '!', '"', ':',
  2145.             '·', '$', '%', '&', '/',
  2146.             '(', ')', '?', "'", '¡',
  2147.             '¿', '[', '^', '`', ']',
  2148.             '+', '}', '{', '¨', '´',
  2149.             '>', '< ', ';', ',', ],
  2150.             '',
  2151.             $string
  2152.         );
  2154.         return $string;
  2155.     }
  2157.     /*
  2158.     private function validateSanctions(SessionInterface $session, ValidateSanctionsRenewal $validateSanctions, $info, $paymentMethod)
  2159.     {
  2160.         if ($session->has('Marked_name') && $session->has('Marked_document')) {
  2161.             $session->remove('Marked_name');
  2162.             $session->remove('Marked_document');
  2163.         }
  2164.         if ($validateSanctions->validateSanctions($info['documentnumber'], $info['name'])) {
  2165.             if (!$session->has('Marked_name') && !$session->has('Marked_document')) {
  2166.                 $session->remove('Marked_name');
  2167.                 $session->remove('Marked_document');
  2168.                 $session->set('Marked_name', $info['name']);
  2169.                 $session->set('Marked_document', $info['documentnumber']);
  2170.             }
  2172.             return 'p2p' === $paymentMethod;
  2173.         }
  2175.         return true;
  2176.     }
  2177.     */
  2179.     private function validateSpecialConditionPayment($cardNum)
  2180.     {
  2181.         $validBins = [
  2182.             '421892',
  2183.             '450407',
  2184.             '492488',
  2185.             '455100',
  2186.             '799955',
  2187.             '813001',
  2188.             '518761',
  2189.             '542650',
  2190.             '527564',
  2191.             '540699',
  2192.             '518841',
  2193.             '454094',
  2194.             '454759',
  2195.             '459418',
  2196.             '492489',
  2197.             '450408',
  2198.             '459419',
  2199.             '404280',
  2200.             '548115',
  2201.             '553643',
  2202.             '450418',
  2203.             '456783',
  2204.             '483080',
  2205.             '485995',
  2206.             '547457',
  2207.             '410164',
  2208.             '404279',
  2209.             '418253',
  2210.             '459317',
  2211.             '462550',
  2212.             '491268',
  2213.             '492468',
  2214.             '589515',
  2215.             '799955',
  2216.         ];
  2217.         if (in_array(substr($cardNum, 0, 6), $validBins)) {
  2218.             return true;
  2219.         } else {
  2220.             return false;
  2221.         }
  2222.     }
  2224.     private function getValidationOnuOfac($postData, $urlDomain, SessionInterface $session, ValidateSanctionsRenewal $validateSanctionsRenewal){
  2225.         // Comprobar si la URL contiene "experiencias"
  2226.         $exceptionWords = ['experiencias', 'paquetes'];
  2227.         $isException = false;
  2228.         foreach ($exceptionWords as $eWord) {
  2229.             $isException = (strpos($urlDomain, $eWord) !== false);
  2230.             if($isException){
  2231.                 break;
  2232.             }
  2233.         }
  2234.         $isExperiencia = strpos($urlDomain, 'experiencias') !== false;
  2235.         // Si es una experiencia, omitir la validación de pago
  2236.         if ($isException) {
  2237.             $clientArray = $validateSanctionsRenewal->getClientsArray($postData, $urlDomain);
  2238.             return $validateSanctionsRenewal->validateSanctions($clientArray, $session, null);
  2239.         } else {
  2240.             // Procesar como de costumbre para otros productos
  2241.             $paymentInfo = $postData['PD'];
  2242.             $paymentMethod = $paymentInfo['type'];
  2243.             $clientArray = $validateSanctionsRenewal->getClientsArray($postData, $urlDomain);
  2244.             return $validateSanctionsRenewal->validateSanctions($clientArray, $session, $paymentMethod);
  2245.         }
  2246.     }
  2248.     /**
  2249.      * @param $redemptionPoint
  2250.      * @param $session
  2251.      * @param $postData
  2252.      * @return array[]|string[]
  2253.      */
  2254.     public function generateOtp($redemptionPoint, $session, $postData) {
  2255.         if (isset($redemptionPoint) && $session->has('token')) {
  2256.             $info = ["token" => NULL, "amount" => $postData['PD']['pointRedemptionValue']];
  2257.             if ($postData['PD']['pointRedemptionValue'] !== '0' || (int) $postData['PD']['pointRedemptionValue'] !== 0) {
  2258.                 $response = $this->athServices->addOtp($info);
  2259.             }
  2260.         } else {
  2261.             $response = ["StatusDesc" => 'error en sesion', "StatusCode" => "500"];
  2262.         }
  2263.         return $response;
  2264.     }
  2266. }