Civil aviation passenger-ticket combined transport auditing method and device

Abstract

The invention discloses a civil aviation passenger ticket combined transport auditing method and device, and the method comprises the steps: obtaining combined transport settlement message data when internal billing data or external billing data is received; the combined transport settlement message data comprises real-time passenger ticket state information and historical information; screening the combined transport settlement message data to obtain a plurality of settlement message data related to inward billing and outward billing; performing ticket information analysis on the plurality of settlement message data to obtain a plurality of pieces of ticket information; performing internal billing auditing and external billing auditing by using the multiple pieces of ticket information and the combined transport auditing data; and during auditing, performing ticket level matching on the multiple pieces of ticket information and the intermodal auditing data, replacing the intermodal auditing data with the ticket information when the matching is inconsistent, and performing intermodal auditing by using the replaced intermodal auditing data. According to the invention, the real-time performance, accuracy and efficiency of combined transport auditing can be improved.

Description

Technical Field

[0001] The present invention relates to the technical field of aviation data processing, and in particular to a method and device for verifying intermodal civil aviation tickets. Background Art

[0002] This section is intended to provide a background or context to the embodiments of the invention that are recited in the claims. No statement herein is admitted to be prior art by virtue of its inclusion in this section.

[0003] The issuing airline refers to the airline that sells tickets through its own ticket offices or agencies, and the operating airline refers to the airline that actually undertakes the air transport mission and is responsible for transporting passengers or cargo from the departure point to the destination. Interline billing refers to the business process in which Airline A issues a ticket, Airline B operates a certain segment, Airline B requests the revenue for that segment from Airline A through an interline bill, and Airline A reviews and confirms the bill before paying Airline B. An airline can act as the issuing airline in some tickets and the operating airline in others. Outward Billing (OWB) refers to the settlement business process in which the operating airline bills the issuing airline and requests interline revenue. Inward Billing (IWB) refers to the settlement business process in which the issuing airline reviews the interline revenue data requested by the operating airline and confirms the amount payable. LK (Lift Data) refers to the status of used e-ticket coupons, including statuses such as carried, exchanged, and refunded. This data is shared between the operating and selling airlines. LKTCN (Transmission Control Number) data is the e-ticket sales data obtained by the operating airline through exchange after the carriage.

[0004] In the existing technology, the operating airline and the selling airline use different settlement data for settlement processing. The operating airline uses LK data and LKTCN data as settlement data, while the selling airline uses its own sales data and LK data for intermodal audit. There are natural differences in the data between the two parties. The carrier receives data at the time of carriage, while the seller receives data at the time of sale. According to the existing intermodal settlement rules, freight rate information should be based on the data at the time of sale, and carrier information should be based on the data at the time of carriage. Therefore, the current intermodal audit has the following defects:

[0005] 1. Data is transmitted daily and only once per intermodal transport, resulting in poor real-time performance.

[0006] 2. The data transmitted is final status data. LK data only includes the status data of the used e-ticket coupons, and LKTCN data only includes the e-ticket sales data obtained by the operating airline through exchange after the operation. The flight data used for settlement between the two parties is not aligned and is incomplete.

[0007] 3. When conducting intermodal transport audits, manual intervention is required, resulting in a large waste of manpower. Summary of the Invention

[0008] An embodiment of the present invention provides a method for intermodal review of civil aviation passenger tickets, which is used to improve the real-time performance of intermodal review, enhance the accuracy and efficiency of intermodal review by carrier airlines and selling airlines, and reduce labor costs. The method includes:

[0009] When intermodal review data is received, intermodal settlement message data is obtained; intermodal review data includes internal billing data or external billing data; intermodal settlement message data includes real-time ticket status information and historical information;

[0010] Filter intermodal settlement message data to obtain multiple settlement message data related to internal and external billing;

[0011] Parsing the plurality of settlement message data for ticket information to obtain a plurality of ticket information; the ticket information includes information reflecting the ticket status;

[0012] Use multiple ticket information and intermodal audit data to conduct intermodal audit and obtain intermodal audit results; intermodal audit includes internal account opening audit and external account opening audit; during intermodal audit: multiple ticket information and intermodal audit data are matched at the ticket level. When the match is inconsistent, the intermodal audit data is replaced by the ticket information, and the intermodal audit is performed using the replaced intermodal audit data.

[0013] The embodiment of the present invention further provides a civil aviation passenger ticket intermodal review device for improving the real-time performance of intermodal review, enhancing the accuracy and efficiency of intermodal review by carrier airlines and selling airlines, and reducing labor costs. The device includes:

[0014] The settlement message acquisition module is used to obtain intermodal settlement message data upon receiving intermodal review data; the intermodal review data includes internal account opening data or external account opening data; the intermodal settlement message data includes real-time ticket status information and historical information;

[0015] Batch data screening module, used to screen intermodal settlement message data and obtain multiple settlement message data related to internal and external billing;

[0016] A batch data parsing module is used to parse the ticket information of multiple settlement message data to obtain multiple ticket information; the ticket information includes information reflecting the ticket status;

[0017] The intermodal audit processing module is used to perform intermodal audits using multiple ticket information and intermodal audit data to obtain intermodal audit results. Intermodal audits include internal account opening audits and external account opening audits. During intermodal audits: multiple ticket information and intermodal audit data are matched at the ticket level. When the matches are inconsistent, the intermodal audit data is replaced with the ticket information, and the intermodal audit is performed using the replaced intermodal audit data.

[0018] An embodiment of the present invention also provides a computer device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the above-mentioned civil aviation passenger ticket intermodal review method when executing the computer program.

[0019] An embodiment of the present invention further provides a computer-readable storage medium storing a computer program, which implements the above-mentioned civil aviation passenger ticket intermodal review method when executed by a processor.

[0020] An embodiment of the present invention further provides a computer program product, which includes a computer program. When the computer program is executed by a processor, it implements the above-mentioned civil aviation passenger ticket intermodal review method.

[0021] The embodiment of the present invention utilizes intermodal settlement message data to assist in the intermodal review of civil aviation passenger tickets. The intermodal settlement message data includes real-time passenger ticket status information and historical information. Compared with the existing daily frequency data, the embodiment of the present invention can rely on quasi-real-time data to quickly perform intermodal review. The embodiment of the present invention utilizes multiple ticket information and intermodal review data to perform intermodal review, and automatically matches multiple ticket information and intermodal review data at the ticket level, thereby realizing accurate identification of potential risk points in intermodal review, improving the accuracy and automation rate of intermodal review of carrier airlines and sales airlines, avoiding manual processing, reducing labor costs, and improving intermodal review efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0022] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the following briefly introduces the drawings required for the embodiments or the description of the prior art. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative work. In the drawings:

[0023] Figure 1 Schematic diagram of the process of the civil aviation passenger ticket intermodal transport review method according to an embodiment of the present invention;

[0024] Figure 2 This is a diagram showing a specific example of a method for verifying intermodal civil aviation tickets according to an embodiment of the present invention;

[0025] Figure 3 This is a diagram showing a specific example of a method for verifying intermodal civil aviation tickets according to an embodiment of the present invention;

[0026] Figure 4 FIG. 2 is another specific example of the method for verifying intermodal civil aviation tickets according to an embodiment of the present invention;

[0027] Figure 5 Schematic diagram of a civil aviation passenger ticket intermodal transport verification device in an embodiment of the present invention. DETAILED DESCRIPTION

[0028] To make the purpose, technical solutions and advantages of the embodiments of the present invention more clear, the embodiments of the present invention are further described in detail below with reference to the accompanying drawings. Here, the exemplary embodiments of the present invention and their descriptions are used to explain the present invention, but are not intended to limit the present invention.

[0029] The acquisition, transmission, storage, use, and processing of data in the technical solution of this application comply with the relevant provisions of national laws and regulations.

[0030] Civil aviation passenger interline settlement review refers to the settlement process between two or more airlines to confirm the rules and amounts for interline ticket revenue. This process requires information such as ticket coupon status, exchange or endorsement information, and irregular flight handling. The data held by the issuing and operating airlines is often misaligned, incomplete, or out-of-date, resulting in unequal access to this information between the two parties involved in interline settlement, leading to disputes and repeated adjustments regarding interline ticket revenue.

[0031] The embodiment of the present invention introduces quasi-real-time electronic ticket change data and automatically compares it with existing settlement data. It describes a method of using ticket status change information in intermodal settlement messages to assist in the review of civil aviation passenger intermodal settlements. The intermodal settlement messages are quasi-real-time electronic ticket status and historical information provided by the airline's electronic ticket system.

[0032] Figure 1 FIG. 1 is a flow chart of a method for verifying intermodal civil aviation tickets according to an embodiment of the present invention. Figure 1 As shown, the method includes:

[0033] Step 101: Upon receiving intermodal review data, obtain intermodal settlement message data; the intermodal review data includes internal billing data or external billing data; the intermodal settlement message data includes real-time ticket status information and historical information;

[0034] Step 102: Filter the intermodal settlement message data to obtain multiple settlement message data related to internal billing and external billing;

[0035] Step 103: parsing the multiple settlement message data for ticket information to obtain multiple ticket information; the ticket information includes information reflecting the ticket status;

[0036] Step 104: Perform intermodal audit using multiple ticket information and intermodal audit data to obtain intermodal audit results. Intermodal audit includes internal account opening audit and external account opening audit. During intermodal audit: perform ticket-level matching on multiple ticket information and intermodal audit data. If the matching is inconsistent, replace the intermodal audit data with the ticket information, and perform intermodal audit using the replaced intermodal audit data.

[0037] The following is a detailed explanation of the civil aviation passenger ticket intermodal review method according to an embodiment of the present invention.

[0038] An intermodal settlement system is constructed based on the civil aviation passenger ticket intermodal review method in an embodiment of the present invention. The intermodal settlement system provides an airline with the function of simultaneously processing external and internal billing businesses. Both of these businesses will use the intermodal calculation engine to calculate the settlement price to achieve the purpose of intermodal settlement review. The existing system uses daily frequency data such as LK and LKTCN for intermodal settlement. In the embodiment of the present invention, intermodal settlement message data is used to partially replace daily frequency data to complete the existing intermodal billing business, and a new intermodal receivables and payables trial calculation function is added for user reference.

[0039] During specific implementation, the airline, as the ticket issuer, receives and processes internal billing data, and as the carrier, receives and processes external billing data as the trigger time point of the plan. This serves as a prerequisite for determining whether it is necessary to process intermodal settlement message data.

[0040] In step 101, upon receiving intermodal audit data, intermodal settlement message data is obtained. The intermodal audit data includes internal billing data or external billing data, such as external billing data.

[0041] When acquiring intermodal settlement message data, the upstream intermodal settlement message data is obtained by calling the upstream interface in real time. This data is transmitted in JSON format. The JSON format for intermodal settlement message data uses a text format of key-value pairs, with a simple data structure and small size. The lightweight JSON format can reduce data transmission bandwidth usage and improve data transmission speed.

[0042] During data reception, the primary task is to ensure complete data is received. Due to the relatively large volume of settlement message data, this can easily impact the correct use of other functions within the intermodal settlement system, leading to performance issues. Therefore, the intermodal settlement system employs a data batch processing mechanism that limits the number of upstream interface calls per unit time. For example, the maximum number of calls per unit time is equal to the number of CPU cores on the physical server multiplied by 2. This ensures that all data is correctly stored on the storage medium. Furthermore, to facilitate subsequent data query and management, the intermodal settlement system generates a unique identifier for each piece of raw data and records information such as the data's receipt time and source.

[0043] In step 102, the intermodal settlement message data is screened to obtain a plurality of settlement message data related to internal billing and external billing.

[0044] For example, after receiving intermodal settlement message data and saving the original records, batch processing begins. First, batch data is queried / filtered from the storage medium. Query / filter criteria can include the data's time range, data type, and data source.

[0045] In one embodiment, the intermodal review data and the intermodal settlement message data both include a ticket identifier; the intermodal settlement message data is filtered to obtain multiple settlement message data related to internal account opening and external account opening, which may include using the ticket identifier and the time information of receiving the intermodal review data to filter the intermodal settlement message data to obtain multiple settlement message data related to internal account opening and external account opening.

[0046] For example, after the foreign airline data opened for internal accounting enters the intermodal settlement system, the settlement message information records are matched at the time of system review. If multiple results are matched, the record with the latest creation time is used.

[0047] In order to improve the query / filtering efficiency, a business primary key index is established in the storage medium so that the query / filtering operation can quickly locate the required data. Especially when the data volume is large, the query speed is significantly improved.

[0048] In step 103, the ticket information of the plurality of settlement message data is parsed to obtain a plurality of ticket information; the ticket information includes information reflecting the ticket status.

[0049] For example, the settlement message data is parsed into ticket information according to a standard format to extract key information such as ticket number, ticket coupon, ticket type, coupon ID, electronic ticket status, ticket type code, ticket coupon status, passenger type, voluntary or involuntary upgrade ID, etc. The information reflecting the ticket status includes but is not limited to the carrier status, whether it is upgraded, whether it is rescheduled, etc. The information is split into two parts: historical change records and image information, and stored separately.

[0050] Taking the voluntary or involuntary upgrade identification as an example, text recognition is used to identify whether there are designated characters for upgrade or involuntary interruption in the settlement message data, and the key field values before and after the change are recorded.

[0051] To further improve the response speed and processing efficiency of the system, in one embodiment, ticket information is parsed for multiple settlement message data to obtain multiple ticket information, which may include:

[0052] Send multiple settlement message data to the message queue so that different server nodes can obtain and process the settlement message data; the server node performs ticket information analysis on the settlement message data to obtain ticket information, and stores the ticket information in the database.

[0053] Message queues enable loosely coupled communication between services. Using asynchronous communication, the sender can send a message to the queue and continue with other tasks without waiting for the receiver to process it. This improves system responsiveness and processing efficiency while also reducing coupling between services, making it easier to scale and maintain the system.

[0054] In settlement message data processing scenarios, data traffic often experiences sudden peaks. Message queues can smooth out sudden traffic spikes through a message accumulation mechanism, ensuring system stability. For example, when receiving upstream data, system traffic can surge. Message queues can temporarily store this data in the queue and then gradually process it based on the system's processing capacity, preventing system crashes caused by sudden traffic surges.

[0055] Message queues support message persistence and retry mechanisms to ensure critical data is not lost. During data transmission, network failures, server outages, and other issues may cause message loss. Message queues can persist messages to disk, allowing them to be reprocessed after recovery even in the event of a failure. Furthermore, message queues can retry failed messages to ensure they are ultimately processed successfully.

[0056] The message queue supports a horizontally scalable architecture, allowing performance requirements in high-concurrency scenarios to be met by adding queue nodes. When processing large amounts of settlement message data, a single queue node may not be able to meet the system's processing capacity. Distributed expansion allows data to be spread across multiple queue nodes for processing, improving overall system performance.

[0057] In one embodiment, sending the multiple settlement message data to the message queue may include: encapsulating the multiple settlement message data into a message and then sending the message to the message queue; the message is in JSON format.

[0058] During implementation, these settlement message data are encapsulated into messages and sent to a message queue. During this message encapsulation process, this solution converts the message sequence into JSON format to facilitate network transmission and storage. Furthermore, to ensure message sequence and integrity, each message is uniquely identified. The messages are then stored in a cache for subsequent message compensation and exception handling.

[0059] Furthermore, after sending the plurality of settlement message data to the message queue, the method may further include: before the message is subscribed to in the message queue, deserializing the message into a JAVAPOJO object.

[0060] The intermodal settlement system monitors the message queue service in real time and calls the message queue service API to query for new messages. Before subscribing to a message queue, the message is deserialized into a Java POJO object. Based on the data structure of the settlement message and the mapping relationship, a corresponding Java object is constructed. During data reception, multiple server nodes utilize asynchronous decoupling using a thread pool, sending message data directly to the thread pool for parallel processing. The thread pool dynamically adjusts the number of thread pool threads based on the number of CPU cores on the physical server. The intermodal settlement system utilizes a unified processing and consumption procedure for message queue data, standardizing the message consumption process and ensuring stable message reception and proper communication between applications and the message queue server.

[0061] In one embodiment, the method may further include the following message post-processing: after the message data is sent to the thread pool, the system manually / automatically ACKs the message queue server to confirm that the message has been successfully received, while preventing the message from being processed overtime.

[0062] When processing message data within a thread, if there is no problem with the subsequent processing of the message, the intermodal settlement system will connect to the cache server and delete the cached data of the message.

[0063] When an exception occurs in message processing, such as message timeout or message rollback, the intermodal settlement system will connect to the cache server, obtain the cache information of the message, update the exception information to the cache, and place it in different cache queues according to the different exception situations. Subsequently, data will be pulled from the exception cache queue at regular intervals and reprocessed.

[0064] In this embodiment of the present invention, the intermodal settlement system primarily comprises an intermodal settlement server, a message queue server, and a cache server. The intermodal settlement server is primarily responsible for data reception and intermodal audit processing. The message queue server is responsible for sending and receiving messages, serializing messages, and persisting messages. The cache server is responsible for caching message queue messages and adding distributed locks to message queue processing.

[0065] The embodiments of the present invention utilize a multi-level cache architecture, combining memory cache and disk cache to achieve hierarchical data storage and rapid access. Memory cache offers the advantages of fast read and write speeds, but limited capacity; disk cache offers large capacity but relatively slow read and write speeds. This multi-level cache architecture allows frequently accessed data to be stored in the memory cache, while less frequently used data is stored in the disk cache, improving data access speed and cache utilization.

[0066] The present invention employs an intelligent caching strategy, employing algorithms such as LRU (Least Recently Used) to dynamically manage cache content. When cache space is insufficient, the least recently used data is automatically eliminated to make room for new data. This ensures that the most frequently used data is always stored in the cache, improving the cache hit rate.

[0067] The embodiments of the present invention support a real-time synchronization mechanism between the cache and the data source to ensure data accuracy. When data is updated, the system promptly updates the cached data to avoid data inconsistencies. Dynamic node expansion is supported, and large-scale data processing needs can be met by adding cache nodes. When processing massive amounts of settlement message data, a single cache node may not be able to meet the system's cache requirements. A distributed cache cluster can distribute data across multiple cache nodes for storage and management, improving the overall performance and scalability of the cache system.

[0068] When parsing message data, the message data is finely split, special characters are replaced, and other operations are performed, and then saved to the corresponding database to prepare for the next step of data splitting.

[0069] Data splitting is mainly to split it into historical node data and image node data. After splitting the data, the above two node data are filtered out, and the missing field content in the two nodes is added and improved.

[0070] Finally, in step 104, a multi-operation audit is performed using the multiple ticket information and the multi-operation audit data to obtain the multi-operation audit results. The multi-operation audit includes internal account opening audit and external account opening audit. During the multi-operation audit, the multiple ticket information and the multi-operation audit data are matched at the ticket level. If the match is inconsistent, the multi-operation audit data is replaced with the ticket information, and the multi-operation audit is performed using the replaced multi-operation audit data.

[0071] Internal billing review refers to the settlement process in which the issuing airline reviews the billing data of the carrier airline requested for interline revenue and confirms the payable amount. The issuing airline reviews the billing amount information of each ticket under the bill issued by the carrier airline (including the freight rate allocation amount and the interline tax amount) to confirm whether the billing amount is correct. If it is incorrect, the internal billing review will make adjustments and transfer back the amount overbilled by the carrier airline.

[0072] External account opening audit refers to the calculation of revenue for the carried segment by the actual carrier airline based on the intermodal agreement between the two airlines after the actual carriage occurs. It is initiated by the carrier and the revenue is confirmed to the seller. If it is incorrect, the external account opening audit will automatically adjust it.

[0073] During specific implementation, this airline can act as both an operating airline and a ticketing airline. When receiving external billing data as an operating airline and internal billing data as a ticketing airline, it obtains the latest intermodal settlement message data, filters, parses, and processes the intermodal settlement message data, and then uses the processed settlement message data to match and compare with external billing data or internal billing data. If inconsistent data is found, it will be marked and replaced, and the apportionment calculation and tax calculation will be performed to obtain the final intermodal audit results.

[0074] In one embodiment, performing intermodal audit using the replaced intermodal audit data may include: using the replaced intermodal audit data to match different bilateral SPA (Special Proration Agreement) agreements; and calculating the allocation results, such as the allocated price, taxes, etc., based on the bilateral SPA agreements.

[0075] For example, parameters are constructed based on the replaced intermodal audit data to match different agreement terms. For example, the involuntary identifiers V and I represent different business meanings respectively. Based on the new ticket information, different agreement terms are traversed to finally obtain the appropriate SPA agreement, obtain different agreement amount types and discount rates and other information, and calculate different apportionment prices and taxes.

[0076] Furthermore, the intermodal audit result may also include: matching inconsistent project information, and suggested information for adjusting intermodal audit data; after obtaining the intermodal audit result in step 104, the method may further include: displaying the intermodal audit result in an editable form on the user interface.

[0077] When performing ticket-level matching, it is possible to configure a focus on reviewing some special scenarios that were previously prone to errors, in order to reduce the error rate of intermodal review. In one embodiment, ticket-level matching of multiple ticket information and intermodal review data may include:

[0078] Perform ticket-level matching on multiple ticket information and intermodal audit data in one or any combination of the following scenarios:

[0079] Whether the upgrade is voluntary, changes in ticket coupon usage status, passenger type, changes in endorsement identification, and flight changes.

[0080] The following examples illustrate the overall process of internal account opening review and external account opening review.

[0081] (1) Internal account opening and review.

[0082] Step 1: After the foreign airline data for internal billing enters the intermodal settlement system, the settlement message information record is matched during the system review. If multiple matches are found, the record with the latest creation time is used;

[0083] Step 2: Parse the obtained settlement message data according to the standard format, extract key information such as ticket number, ticket coupon, ticket type, and voluntary or involuntary upgrade flags, and split the information into two parts: historical change records and image information, which are stored separately;

[0084] Step 3: Replace the daily frequency information with the above key information in the settlement message data and transmit it to the allocation engine and tax engine;

[0085] It should be noted that the aforementioned intermodal calculation engine is a key component of the intermodal settlement system, consisting of two main parts: the allocation engine and the tax engine. The engine is used to calculate the freight settlement price and tax settlement price for the intermodal segments based on rules. The calculation rules are defined based on the intermodal settlement agreement maintained by the user in the engine.

[0086] Step 4: The apportionment engine and tax engine identify and match different agreement terms based on the transmitted information. For example, different values for passenger type (adult or child) and voluntary or involuntary flags correspond to different bilateral SPA agreements between airlines. They obtain different agreement amount types and discount rates, and calculate different apportionment reference prices and tax reference prices.

[0087] Step 5: Obtain the reference price calculation results of the relevant allocations and taxes calculated for the ticket from the allocation and tax engines and store them in the corresponding fields of the intermodal settlement system for review. This serves as the basis for manual or automatic review of the amount. Key information extracted from the settlement message data is displayed on the review page as the intermodal settlement system review reason, providing users with key information for reviewing the correctness of the amount.

[0088] According to the functional configuration of the intermodal settlement system, it is possible to automatically conduct an audit based on the system's audit reasons and system reference prices, and use the system's reference allocation and tax information as the basis for the issuing airline to accept the operating airline's billing data.

[0089] During internal account opening and review, complex business scenarios are judged, such as the voluntary or involuntary nature of the upgrade, ticket coupon status, passenger type, and other key information. Intermodal settlement message data is automatically matched with the account opening invoice data. The daily frequency data results are replaced with the key information results of the settlement message data, and the erroneous information in the daily frequency data is corrected to obtain the correct allocation results. The following scenario data is the focus of review and submitted to the user for confirmation. The automatic review function is supported through the configuration items of the intermodal settlement system.

[0090] Scenario 1: Voluntary or involuntary upgrade: Retrieve ticket information with a specified ticket type (e.g., P), extract records with a non-null voluntary upgrade flag in the settlement message data, and display them on the review screen with a specific system review reason. The system review reason is the basis for the system's review of the ticket, and users use the system review reason as important reference information for ticket review.

[0091] Scenario 2: Abnormal ticket coupon status: Retrieve the ticket coupon corresponding to the billing invoice, extract the ticket coupon usage status in the settlement message data, and display the records marked as abnormal on the review screen with specific system review reasons.

[0092] Scenario 3: Differences in passenger types: The passenger type in the settlement message data is extracted and compared with the passenger type in the daily frequency data. If there is any inconsistency, a specific system review reason will be displayed on the review screen.

[0093] Figure 2 FIG is a specific example of a method for verifying intermodal civil aviation tickets according to an embodiment of the present invention, with reference to FIG. Figure 2 The user interface displays information about inconsistent matching items. For example, the code for involuntary upgrade is 5ZK, and the code for inconsistent coupon usage status is 5ZL. Each item has corresponding suggestion information, allowing users to make adjustments by selection.

[0094] Figure 3 FIG is a specific example of a method for verifying intermodal civil aviation tickets according to an embodiment of the present invention, with reference to FIG. Figure 3 For each entry with inconsistent matching information, there is a text box (supports editing) that displays the reason for the adjustment, as well as annotation information.

[0095] (2) Audit of external accounts.

[0096] Step 1: As the carrier, based on the daily data received from foreign airlines selling their own flights, call the interface to obtain settlement message data;

[0097] Step 2: Parse the settlement message and store it in the database;

[0098] Step 3: Based on the external account opening review rules, determine the changes in settlement message data and daily frequency data from the following scenarios, and mark the differences: ① Change in coupon usage status ② Change in cabin space ③ Change in involuntary indicator ④ Change in flight ⑤ Change in endorsement indicator ⑥ Change in interrupted exchange indicator;

[0099] Step 4: System configuration: You can configure single or multiple fields to automatically replace and update daily data, rebuild parameters, and send them to the allocation engine and tax engine. The engines will match different agreement terms based on the new parameter information. For example, the involuntary identifiers V and I represent different business meanings. The allocation engine traverses different agreement terms based on the new ticket information and ultimately obtains the appropriate SPA agreement. The tax engine will re-determine whether it is an intermodal tax and whether there are exemption clauses for the tax based on different field information.

[0100] Step 5: The calculation results of the daily frequency data after the initial daily frequency data and the settlement message data are stored separately and provided to the user for difference comparison. The user can select the calculation result that is favorable to either party, and the one-click replacement function is supported.

[0101] The above introduces the overall process of internal account opening review and external account opening review.

[0102] In the embodiment of the present invention, in addition to the intermodal audit link, the user can use the entire process of ticket coupon usage changes completed by splicing settlement message data to assist the user in the external account opening audit of the ticket.

[0103] In one embodiment, after parsing the ticket information of multiple settlement message data to obtain multiple ticket information, the method may further include: performing an intermodal settlement trial calculation using the multiple ticket information to obtain an intermodal settlement trial calculation result; the intermodal settlement trial calculation result includes a trial calculation result of the carrier's accounts receivable or a trial calculation result of the issuer's accounts payable.

[0104] Figure 4 FIG is another specific example of the method for verifying intermodal civil aviation tickets in an embodiment of the present invention, with reference to FIG. Figure 4 This demonstrates the overall process of the intermodal review method for civil aviation passenger tickets in an embodiment of the present invention, as well as the overall functionality of the intermodal settlement system. Specifically, the reservation host system acquires near-real-time intermodal settlement messages, performs simple processing and format conversion, and transmits them to the message queue. The message queue server, in the data service, converts the format, parses, splits, compares, and performs intermodal review. Finally, the settlement service outputs the results of the automatic review of external and internal billing. Trial calculations of accounts receivable and accounts payable are also performed.

[0105] The following examples illustrate the overall process of trial calculation of accounts receivable and trial calculation of accounts payable.

[0106] (1) Trial balance of accounts receivable.

[0107] This method focuses on the real-time revenue calculation of foreign airlines' sales of their own carrier data. Compared with daily data, interline settlement report data has a higher frequency and can provide real-time revenue trial calculation data for users to use as a reference for accounting processing and data analysis, timely update and improve data quality, and enhance the accuracy of external account data.

[0108] Step 1: As the carrier, the intermodal settlement system obtains settlement message data of our carrier tickets in real time, records changes in ticket usage status, builds parameter-sending allocation engines and tax engines, and calculates ticket revenue and tax revenue in real time;

[0109] Step 2: The above results are used as the trial calculation results of accounts receivable. The report query function is provided for users to review and confirm in advance and understand the preliminary situation of accounts receivable.

[0110] Step 3: After receiving the daily data, rebuild the parameters and send them to the allocation engine and tax engine to obtain the daily allocation income and tax income, and perform accounting processing based on the actual business;

[0111] Step 4: The user checks and compares the accounts receivable trial calculation results with the daily revenue results, analyzes the data quality of the daily and real-time settlement messages, and makes timely adjustments to update and improve data quality.

[0112] (2) Trial balance of accounts payable.

[0113] This method provides real-time insights into the amounts billed to foreign airlines for internal operations. Combining historical data with current variables, such as fuel prices and agreement changes, it calculates accounts payable, conducts marketing analysis, and assists management in making decisions, such as adjusting interline agreements, optimizing routes, and reducing fuel consumption. This improves overall operational flexibility and drives client airlines toward intelligent, global, and sustainable development.

[0114] Step 1: Parse the ticket information from the settlement message according to the standard format and filter out tickets where the actual carrier is a foreign airline;

[0115] Step 2: All filtered data is simulated with the actual billing scenario of foreign airlines. The process is the same as the daily data transmission process. The key settlement message information, such as the actual carrier, involuntary flag, ticket coupon status, ticket exchange and endorsement information, is transmitted to the allocation engine and tax engine. This step is consistent with the daily data transmission process, but it is more timely. There is no need to wait for the carrier's billing data to enter the system.

[0116] Step 3: The apportionment and tax engines identify and match different agreement terms based on the information transmitted by the intermodal settlement system. For example, different values for passenger type (adult or child) and voluntary or involuntary identification correspond to different SPA agreements. These engines then obtain different agreement amount types and discount rates, resulting in different apportionment and tax amounts.

[0117] Step 4: Receive the return of the allocation and tax calculation results for the ticket from the allocation engine and tax engine and store them separately as the basis for the trial calculation of accounts payable. This report also provides multi-dimensional report extraction methods such as time range, route, segment, and flight, so that users can have a preliminary understanding of the trial calculation results and plan ahead. It can also provide a reference to assist management in decision-making, adjusting intermodal agreements, and optimizing routes.

[0118] In summary, the civil aviation passenger ticket intermodal review method according to the present invention has the advantages of being "fast," "accurate," and "economical." "Fast" refers to the ability to rapidly obtain historical change information for intermodal passenger tickets based on near-real-time data. "Accurate" refers to the ability to automatically and accurately identify intermodal risk points and notify the user by automatically matching intermodal settlement message data with existing settlement data. "Economical" refers to the ability to help users reduce the need for manual screening of massive amounts of data, shortening operational steps and review time. It focuses on risk point data, reducing user worry, and thus reducing the number of intermodal adjustments and review costs.

[0119] The present invention also provides a device for verifying intermodal civil aviation tickets, as described in the following embodiments. Since the principle of the device is similar to that of the method for verifying intermodal civil aviation tickets, the implementation of the device can refer to the implementation of the method for verifying intermodal civil aviation tickets, and the repeated parts will not be repeated.

[0120] Figure 5 FIG. 1 is a schematic diagram of a device for verifying intermodal civil aviation tickets according to an embodiment of the present invention. Figure 5 As shown, the device 500 includes:

[0121] The settlement message acquisition module 501 is used to acquire intermodal settlement message data upon receiving intermodal review data; the intermodal review data includes internal account opening data or external account opening data; the intermodal settlement message data includes real-time ticket status information and historical information;

[0122] Batch data screening module 502, for screening intermodal settlement message data to obtain multiple settlement message data related to internal and external billing;

[0123] Batch data parsing module 503, used to parse ticket information of multiple settlement message data to obtain multiple ticket information; the ticket information includes information reflecting the ticket status;

[0124] The intermodal audit processing module 504 is used to use multiple ticket information and intermodal audit data to perform intermodal audit and obtain intermodal audit results; intermodal audit includes internal account opening audit and external account opening audit; during intermodal audit: multiple ticket information and intermodal audit data are matched at the ticket level. When the match is inconsistent, the intermodal audit data is replaced by the ticket information, and the intermodal audit is performed using the replaced intermodal audit data.

[0125] In one embodiment, the settlement message acquisition module 501 is specifically configured to:

[0126] The upstream intermodal settlement message data is obtained by calling the upstream interface; wherein, the number of calls to the upstream interface per unit time is limited.

[0127] In one embodiment, the intermodal transport review data and the intermodal transport settlement message data both include a ticket identifier;

[0128] The batch data screening module 502 is specifically used for:

[0129] The intermodal settlement message data is filtered using the ticket identifier and the time information of receiving the intermodal review data to obtain multiple settlement message data related to internal account opening and external account opening.

[0130] In one embodiment, the batch data parsing module 503 is specifically configured to:

[0131] Send multiple settlement message data to the message queue so that different server nodes can obtain and process the settlement message data; the server node performs ticket information analysis on the settlement message data to obtain ticket information, and stores the ticket information in the database.

[0132] In one embodiment, the batch data parsing module 503 is specifically configured to:

[0133] Encapsulate multiple settlement message data into a message and send it to the message queue; the message is in JSON format.

[0134] In one embodiment, the apparatus 500 may further include:

[0135] The message deserialization processing module is used to deserialize the messages into JAVAPOJO objects after the batch data parsing module 503 sends multiple settlement message data to the message queue and before the messages are subscribed in the message queue.

[0136] In one embodiment, the intermodal transport review processing module 504 is specifically configured to:

[0137] Use the replaced intermodal audit data to match different bilateral SPA agreements;

[0138] The apportionment results are calculated based on the replaced intermodal audit data according to the bilateral SPA agreement.

[0139] In one embodiment, the intermodal transport review processing module 504 is specifically configured to:

[0140] Perform ticket-level matching on multiple ticket information and intermodal audit data in one or any combination of the following scenarios:

[0141] Whether the upgrade is voluntary, changes in ticket coupon usage status, passenger type, changes in endorsement identification, and flight changes.

[0142] In one embodiment, the intermodal audit result includes: information on inconsistent items and recommended information on adjustments to the intermodal audit data; the apparatus 500 further includes:

[0143] The result display module is used to display the intermodal audit result in an editable form on the user interface after the intermodal audit processing module 504 obtains the intermodal audit result.

[0144] In one embodiment, the device 500 may also include: an intermodal settlement trial calculation module, which is used for the batch data parsing module 503 to parse the ticket information of multiple settlement message data, and after obtaining multiple ticket information, use the multiple ticket information to perform an intermodal settlement trial calculation to obtain an intermodal settlement trial calculation result; the intermodal settlement trial calculation result includes the carrier's accounts receivable trial calculation result or the issuer's accounts payable trial calculation result.

[0145] An embodiment of the present invention also provides a computer device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the above-mentioned civil aviation passenger ticket intermodal review method when executing the computer program.

[0146] An embodiment of the present invention further provides a computer-readable storage medium storing a computer program, which implements the above-mentioned civil aviation passenger ticket intermodal review method when executed by a processor.

[0147] An embodiment of the present invention further provides a computer program product, which includes a computer program. When the computer program is executed by a processor, it implements the above-mentioned civil aviation passenger ticket intermodal review method.

[0148] The embodiment of the present invention utilizes intermodal settlement message data to assist in the intermodal review of civil aviation passenger tickets. The intermodal settlement message data includes real-time passenger ticket status information and historical information. Compared with the existing daily frequency data, the embodiment of the present invention can rely on quasi-real-time data to quickly perform intermodal review. The embodiment of the present invention utilizes multiple ticket information and intermodal review data to perform intermodal review, and automatically matches multiple ticket information and intermodal review data at the ticket level, thereby realizing accurate identification of potential risk points in intermodal review, improving the accuracy and automation rate of intermodal review of carrier airlines and sales airlines, avoiding manual processing, reducing labor costs, and improving intermodal review efficiency.

[0149] It will be understood by those skilled in the art that embodiments of the present invention may be provided as methods, systems, or computer program products. Thus, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment, or an embodiment combining software and hardware. Furthermore, the present invention may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to magnetic disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0150] The present invention is described with reference to flowcharts and / or block diagrams of methods, devices (systems), and computer program products according to embodiments of the present invention. It should be understood that each process and / or block in the flowcharts and / or block diagrams, as well as combinations of processes and / or blocks in the flowcharts and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to produce a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowcharts and / or block diagrams. Figure 1 a process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0151] These computer program instructions may also be stored in a computer readable memory that can direct a computer or other programmable data processing device to work in a specific manner, so that the instructions stored in the computer readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 a process or multiple processes and / or boxes Figure 1 The function specified in one or more boxes.

[0152] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operational steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing the instructions executed on the computer or other programmable device for implementing the process. Figure 1a process or multiple processes and / or boxes Figure 1 A step that specifies a function in one or more boxes.

[0153] The specific embodiments described above further illustrate the objectives, technical solutions and beneficial effects of the present invention in detail. It should be understood that the above description is only a specific embodiment of the present invention and is not intended to limit the scope of protection of the present invention. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the present invention should be included in the scope of protection of the present invention.

Claims

1. A method for verifying intermodal civil aviation tickets, characterized in that: include: When receiving intermodal audit data, obtain intermodal settlement message data; intermodal audit data includes internal billing data or external billing data; Intermodal settlement message data includes real-time ticket status information and historical information; Filter intermodal settlement message data to obtain multiple settlement message data related to internal and external billing; Parsing the plurality of settlement message data for ticket information to obtain a plurality of ticket information; the ticket information includes information reflecting the ticket status; Use multiple ticket information and intermodal audit data to conduct intermodal audit and obtain intermodal audit results; intermodal audit includes internal account opening audit and external account opening audit; during intermodal audit: multiple ticket information and intermodal audit data are matched at the ticket level. When the match is inconsistent, the intermodal audit data is replaced by the ticket information, and the intermodal audit is performed using the replaced intermodal audit data.

2. The method according to claim 1, wherein Obtain intermodal settlement message data, including: The upstream intermodal settlement message data is obtained by calling the upstream interface; wherein, the number of calls to the upstream interface per unit time is limited.

3. The method according to claim 1, wherein The intermodal transport review data and intermodal transport settlement message data both include ticket identification; Filter the intermodal settlement message data to obtain multiple settlement message data related to internal and external billing, including: The intermodal settlement message data is filtered using the ticket identifier and the time information of receiving the intermodal review data to obtain multiple settlement message data related to internal account opening and external account opening.

4. The method according to claim 1, wherein Parse the ticket information of multiple settlement message data to obtain multiple ticket information, including: Send multiple settlement message data to the message queue so that different server nodes can obtain and process the settlement message data; the server node performs ticket information analysis on the settlement message data to obtain ticket information, and stores the ticket information in the database.

5. The method according to claim 4, wherein Send multiple settlement message data to the message queue, including: Encapsulate multiple settlement message data into a message and send it to the message queue; the message is in JSON format.

6. The method according to claim 5, wherein After sending multiple settlement message data to the message queue, it also includes: Before the message is subscribed to in the message queue, the message is deserialized into a JAVA POJO object.

7. The method according to claim 1, wherein Conduct intermodal audits using the replaced intermodal audit data, including: Use the replaced intermodal audit data to match different bilateral special proportion sharing agreements (SPAs); The apportionment results are calculated based on the replaced intermodal audit data according to the bilateral SPA agreement.

8. The method according to claim 1, wherein Match multiple ticket information and intermodal audit data at the ticket level, including: Perform ticket-level matching on multiple ticket information and intermodal audit data in one or any combination of the following scenarios: Whether the upgrade is voluntary, changes in ticket coupon usage status, passenger type, changes in endorsement identification, and flight changes.

9. The method according to claim 1, wherein The intermodal audit results include: matching inconsistent project information and recommendations for intermodal audit data adjustments; After obtaining the intermodal audit results, it also includes: The intermodal audit results are displayed in an editable form on the user interface.

10. The method according to claim 1, wherein After parsing multiple settlement message data for ticket information and obtaining multiple ticket information, it also includes: The intermodal settlement trial calculation is performed using multiple ticket information to obtain the intermodal settlement trial calculation result; the intermodal settlement trial calculation result includes the carrier's receivables trial calculation result or the billing party's payables trial calculation result.

11. A civil aviation passenger ticket intermodal transport verification device, characterized in that: include: The settlement message acquisition module is used to obtain intermodal settlement message data upon receiving intermodal review data; the intermodal review data includes internal account opening data or external account opening data; the intermodal settlement message data includes real-time ticket status information and historical information; Batch data screening module, used to screen intermodal settlement message data and obtain multiple settlement message data related to internal and external billing; A batch data parsing module is used to parse the ticket information of multiple settlement message data to obtain multiple ticket information; the ticket information includes information reflecting the ticket status; The intermodal audit processing module is used to perform intermodal audits using multiple ticket information and intermodal audit data to obtain intermodal audit results. Intermodal audits include internal account opening audits and external account opening audits. During intermodal audits: multiple ticket information and intermodal audit data are matched at the ticket level. When the matches are inconsistent, the intermodal audit data is replaced with the ticket information, and the intermodal audit is performed using the replaced intermodal audit data.

12. A computer device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein: When the processor executes the computer program, the method according to any one of claims 1 to 10 is implemented.

13. A computer-readable storage medium, characterized in that The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the method according to any one of claims 1 to 10 is implemented.

14. A computer program product, characterized in that The computer program product comprises a computer program, and when the computer program is executed by a processor, the method according to any one of claims 1 to 10 is implemented.

Images