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

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