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

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