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

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