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

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