Airline order generation method, system and device, and medium

Abstract

The invention belongs to the technical field of order generation, and provides an air order generation method, system and device and a medium, and the method comprises the steps: obtaining flight information needed by a conventional air ticket sales system and an NDC sales system; determining table structures and table contents of an order table, an order item table, an aviation product table, an aviation product item table, a leg table and a ticket table based on the acquired flight information; when an air ticket is reserved, flight information is obtained through an AirShopping interface and displayed to a user; after the user selects a flight, payment price verification is carried out on the selected flight by using an OfferPrice interface; after the payment price verification is passed, generating an order table, an order item table, an aviation product table, an aviation product item table and a leg table based on the acquired flight information; and performing order amount payment by using an OrderChannel interface, and after payment is completed, generating a ticket table based on the air ticket information, thereby realizing generation of the air order. According to the invention, the order collaboration problem of the NDC sales system and the traditional sales system can be solved.

Description

Technical Field

[0001] The present invention belongs to the technical field of order generation, and in particular, relates to an aviation order generation method, system, device and medium. Background Art

[0002] When building the NDC sales system and NDC interface platform, there are differences in the storage of orders between the NDC sales system and the NDC interface platform.

[0003] For example, the fields that require attention in the NDC sales system are different from the fields that require attention in the NDC interface, which results in the data of the two systems being unable to communicate with each other. It then becomes difficult for users to reuse the orders they created in the sales system on the interface platform.

[0004] At the same time, different airlines have different processes for flight sales, and there is no unified general process. For example, in Airline A, flight changes require two calls to the OrderReshop interface, while in Airline B, only one call to the OrderReshop interface is required. Such differences lead to the lack of a standard process for changing orders.

[0005] Furthermore, different airlines have different understandings of standard agreements. For example, in Airline A, one order item includes all people, and the prices of different types of people are grouped in FareComponent, while in Airline B, one order item only includes one passenger type, and multiple passenger types are divided into multiple order items.

[0006] The above-mentioned problems that exist in the NDC sales system and the NDC interface platform when storing orders also exist in the traditional air ticket system. In the traditional air ticket sales system, user groups are mainly distinguished by cabin class division. The cabin class division is divided into three layers. The first layer is based on first class (F), business class (C) and economy class (Y). The second layer is divided into sub-cabins based on the first layer. For example, the economy class is divided into sub-cabins J and K according to different refund and change rights.

[0007] However, in the NDC scenario, the sub-cabins are further divided, for example, different branded freight rates are published under the J cabin due to different baggage policies.

[0008] Due to the above differences, order-based collaboration is difficult to achieve in traditional ticket sales systems and NDC sales systems. Summary of the invention

[0009] To solve the above problems, the present disclosure provides an aviation order generation method, system, device and medium, which adopts a unified information acquisition and processing and standardized process approach, can integrate different sales systems, solve compatibility issues, and standardize order generation, change and additional service processes.

[0010] The following is the technology of the present invention:

[0011] A method for generating an air ticket order, used for generating an air ticket order by a ticket sales system, characterized by comprising:

[0012] Obtain the flight information required by the traditional ticket sales system and the NDC sales system; determine the table structure and table content of the order table, order item table, aviation product table, aviation product item table, flight segment table, and ticket table based on the obtained flight information;

[0013] When booking air tickets, obtain flight information through the AirShopping interface and display it to the user;

[0014] After the user selects a flight, the OfferPrice interface is used to verify the payment price of the selected flight. After the payment price verification is passed, the order table, order item table, aviation product table, aviation product item table, and flight segment table are generated based on the obtained flight information.

[0015] The OrderChange interface is used to pay the order amount. After the payment is completed, the ticket information is obtained from the external airline, and a ticket table is generated based on the ticket information to realize the generation of the airline order.

[0016] Further,

[0017] The information in the order table includes: order number, order source, tracking identifier TraceId, total price, total tax, currency unit, payment status, cancellation status, and reservation person;

[0018] The information of the order item table includes: order number, person, purchased product ID, total price, total tax, currency unit, status, order item ID;

[0019] The information of the aviation product table includes: aviation product identification, PNR, and airline code;

[0020] The information of the aviation product item list includes: flight segment identification, flight distance, cabin space, brand fare, and flight number;

[0021] The information of the flight segment table includes: flight segment identification, flight distance, cabin space, brand fare, and flight number;

[0022] The information of the ticket list includes: ticket number, main ticket number, multiple flight segment identifiers, ticket issuance time, and change status.

[0023] Further,

[0024] After the air order is generated, if the user needs to change the ticket, perform the following steps:

[0025] Select the flight you want to rebook and fill in the departure and arrival information and date;

[0026] Based on the departure and arrival information and dates, query the flight change information through the OrderReshop interface;

[0027] After the user chooses to change the flight, the OrderChange interface is called to confirm the change and generate a change record table.

[0028] Further,

[0029] The query of flight change information through the OrderReshop interface includes:

[0030] The first OrderReshop returns the flight information that the user can change;

[0031] The second OrderReshop returns to select whether the flight can be changed and how much the change fee is.

[0032] Further,

[0033] The information in the ticket change record table includes: old order item ID, new order item ID, reason for ticket change, ticket change fee, and ticket change time.

[0034] Further,

[0035] After the air order is generated, if the user needs to purchase additional services, perform the following steps:

[0036] Get the information of additional services that the current air order is authorized to purchase through the ServiceList interface;

[0037] After the user selects the additional service, he / she pays the purchase fee of the additional service through the OrderChange interface and updates the flight order.

[0038] Further,

[0039] The additional service information includes: additional service product identification, additional service content description, and product code.

[0040] An aviation order generation system, characterized by comprising:

[0041] The information acquisition module is used to obtain the flight information required by the traditional ticket sales system and the NDC sales system; based on the obtained flight information, the table structure and table content of the order table, order item table, aviation product table, aviation product item table, flight segment table, and ticket table are determined;

[0042] The flight selection module is used to obtain flight information through the AirShopping interface and display it to users when booking air tickets;

[0043] The verification module is used to verify the payment price of the selected flight using the OfferPrice interface after the user selects the flight; after the payment price verification is passed, the order table, order item table, aviation product table, aviation product item table, and flight segment table are generated based on the obtained flight information;

[0044] The payment module is used to pay the order amount using the OrderChange interface. After the payment is completed, the ticket information is obtained from the external airline, and a ticket table is generated based on the ticket information to realize the generation of the air order.

[0045] Compared with the prior art, the present invention has the following advantages:

[0046] By obtaining the flight information required by the traditional ticket sales system and the NDC sales system, and determining the unified order table, order item table, aviation product table, aviation product item table, flight segment table, and ticket table structure and content based on this information, it is possible to store and manage orders in a unified format regardless of whether they come from the traditional sales system or the NDC sales system, solving the problem of data incommunicability between the two systems and difficulty in reusing orders.

[0047] At the same time, in the entire process from booking air tickets to generating orders, the use of each step and interface is clarified, such as obtaining flight information through the AirShopping interface, verifying prices through the OfferPrice interface, and paying the order amount through the OrderChange interface, etc., ensuring the standardization and normalization of the order generation process under different systems, so that data can be accurately transmitted and understood between different systems, thereby solving the problem of order coordination.

[0048] Other features and advantages of the present disclosure will be described in the following description, and partly become apparent from the description, or be understood by implementing the present disclosure. The purpose and other advantages of the present disclosure can be realized and obtained by the structures pointed out in the description, claims and drawings. BRIEF DESCRIPTION OF THE DRAWINGS

[0049] In order to more clearly illustrate the embodiments of the present disclosure or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are some embodiments of the present disclosure. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0050] Figure 1 A schematic diagram of the method of the present invention is shown;

[0051] Figure 2 A schematic diagram of the order placement process of the present invention is shown;

[0052] Figure 3 The schematic diagram of the ticket change process of the present invention is shown;

[0053] Figure 4 A schematic diagram of the process of purchasing additional services according to the present invention is shown. DETAILED DESCRIPTION

[0054] In order to make the purpose, technical solution and advantages of the embodiments of the present disclosure clearer, the technical solution in the embodiments of the present disclosure will be clearly and completely described below in conjunction with the drawings in the embodiments of the present disclosure. Obviously, the described embodiments are part of the embodiments of the present disclosure, not all of the embodiments. Based on the embodiments in the present disclosure, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present disclosure.

[0055] Figure 1 A schematic diagram of the method according to the present invention is shown, and the specific implementation details of the present invention include:

[0056] Ticketing (such as Figure 2 shown):

[0057] Step 1: Obtain the flight information required by the traditional ticket sales system and the NDC sales system; determine the table structure and table content of the order table, order item table, aviation product table, aviation product item table, flight segment table, and ticket table based on the obtained flight information;

[0058] Step 2: When booking a flight, the order processing system obtains flight information through the AirShopping interface and displays it to the user. After the user selects a flight, the order processing system uses the OfferPrice interface to verify the payment price of the selected flight;

[0059] After the payment price is verified, the order table, order item table, aviation product table, aviation product item table, and flight segment table are generated based on the obtained flight information;

[0060] Step 3: The order processing system uses the OrderChange interface to pay the order amount. After the payment is completed, the order processing system obtains the ticket information from the external airline and generates a ticket table based on the ticket information to realize the generation of the airline order.

[0061] Change of ticket (such as Figure 3 shown):

[0062] Step 1: Query the flight information that can be changed through the OrderReshop interface: The first OrderReshop returns the flight information that the user can change, and the second OrderReshop returns whether the selected flight can be changed and the change fee.

[0063] Step 2: Call the OrderChange interface to confirm the change.

[0064] Purchase additional services (such as Figure 4 shown):

[0065] Get the additional services that can be purchased for the order through the ServiceList interface, and pay for the service purchase through the OrderChange interface.

[0066] In summary, the present invention combines the characteristics of NDC products and the characteristics of traditional air ticket sales systems to integrate orders, and the unified definition of standard ordering processes based on NDC processes and traditional airline processes can realize the sales of all categories of products.

[0067] The following is the specific implementation principle of the present invention:

[0068] 1. System composition

[0069] The components involved in the system include:

[0070] AirShopping: For flight searches.

[0071] OfferPrice: used to verify the price and confirm whether the flight price in the AirShopping result has expired.

[0072] OrderCreate: used to generate orders.

[0073] OrderReshop: It is divided into two OrderReshops. The first OrderReshop returns the flight information that the user can change. The second OrderReshop returns whether the selected flight can be changed and the change fee.

[0074] OrderChange: Used to execute the ticket change interface and confirm the ticket change behavior.

[0075] OrderCancel: Flight cancellation interface.

[0076] ServiceList: Provides additional aviation product inquiries, such as baggage, WIFI services, etc.

[0077] 2. Implementation principle

[0078] Ticketing:

[0079] Step 1: Get flight information through the AirShopping interface and provide it for users to choose from. After the user selects the flight information to be booked, the payment price is verified through OfferPrice.

[0080] Step 2: Create an order through OrderCreate for traditional and NDC, and extract the following required data from AirShopping.

[0081] After the following order is generated, the page queries the following table to obtain the order display information. Specifically, it includes:

[0082] 1) First, generate the order in Table 1 according to the information;

[0083] 2) Then, the aviation product information generated according to the flight information mainly includes the contents in Table 2, Table 3, and Table 4;

[0084] 3) Add an order item containing the flight product information to the order.

[0085] Table 1 Order table

[0086]

[0087] Table 2 Order Item Table

[0088]

[0089]

[0090] Table 3 Aviation Products

[0091] Fields Notes Remark Aviation Product Labeling For use in line items PNR Passenger booking record Airline two-letter code Airlines

[0092] Table 4 Aviation Product Items

[0093]

[0094] Table 5 Flight segment table

[0095]

[0096] Step 3: Traditional and NDC use OrderChange to pay the order amount. After payment, the external airline will return the ticket information, which will be stored in the following table:

[0097] Table 6 Ticket List

[0098]

[0099]

[0100] Rebooking:

[0101] 1) User selection and information filling: The user selects the flight to be rescheduled on the page and fills in the relevant OD information (departure and arrival place) and date.

[0102] 2) Query rebookable flights: Query rebookable flight information through the first OrderReshop interface.

[0103] 3) Flight change selection and confirmation: The user selects a suitable flight change from the query results, then calls the OrderChange interface to confirm the change, and records the information in the following table:

[0104] Table 7 Change of Ticket Record

[0105]

[0106] The recording process is: record the old order item ID that needs to be deleted and the newly generated order ID; record the reason for the change; record the change fee.

[0107] After the change, the logic for generating the new order ID and the new aviation product refers to the above method for generating aviation products and order items.

[0108] Purchase additional services:

[0109] The user first obtains the order for additional services from the table, then obtains the additional services that can be purchased through the ServiceList interface, then pays the service purchase fee through OrderChange, and then stores the following data:

[0110] Create a new additional service product based on the information. The product content is shown in Table 8.

[0111] Create a new line item;

[0112] Place the line items into the order.

[0113] Table 8 Additional service products

[0114]

[0115] The following are specific examples of the present invention:

[0116] (1) Create an order:

[0117] Wang Wu purchased a flight from Chongqing (CKG) to Shanghai (SHA) on 2024-11-02 for two users (Zhang San and Li Si), flight number (CA1234), the unit price for each ticket is 1,050 yuan, and the tax is 50 yuan.

[0118] Order table:

[0119]

[0120] Line item:

[0121]

[0122] Aviation products:

[0123] Aviation Product Labeling PNR Airline two-letter code Pdc-1 PND123 CA

[0124] Aviation products:

[0125] people Segment ID ticket Zhang San Seg-1 none Li Si Seg-1 none

[0126] Flight Segment:

[0127] Segment ID voyage Cabin Brand freight rate Flight number Seg-1 CKG-SHA Economy Class Premium Economy Class CA1234

[0128] (2) Payment order:

[0129] Pay the order. After payment is completed, the ticket numbers of Zhang San and Li Si are (123-0001, 123-0002) respectively. After payment is completed, the order table is changed to:

[0130] Order table:

[0131]

[0132] Modify the aviation product item to:

[0133] people Segment ID ticket Zhang San Seg-1 123-0001 Li Si Seg-1 123-0002

[0134] (3) Change the order:

[0135] Change Zhang San's CKG-SHA itinerary to CKG-BJS flight (CA6789), with a change fee of 100 yuan. After paying the change fee, a new ticket 123-0003 for Zhang San is generated.

[0136] Do the following:

[0137] 1) Record the change information in the change record table:

[0138] Old order item ID New line item ID Reason for change Change Fees Item-1 Item-3 Voluntary Rebooking 100

[0139] 2) Add a new order item:

[0140]

[0141] 3) Add new aviation products:

[0142] Aviation Product Labeling PNR Airline two-letter code Pdc-1 PND123 CA Pdc-2 PND124 CA

[0143] 4) Add new aviation product items

[0144]

[0145]

[0146] 5) Add new flight segments

[0147] Segment ID voyage Cabin Brand freight rate Flight number Seg-1 CKG-SHA Economy Class Premium Economy Class CA1234 Seg-2 CKG-BJS Economy Class Premium Economy Class CA6789

[0148] (4) Purchase additional services:

[0149] To purchase a WIFI service for Li Si at a price of 150 yuan, perform the following operations:

[0150] 1) Add new additional service products

[0151] Additional service logo Service Description Service Product Code Service Release Code Service Issue Subcode EMD-1 WIFI SERVICE WIFI WIFI-S WIFI-SM

[0152] 2) Add new order items

[0153]

[0154] Based on the method of the present invention, the embodiment of the present disclosure also provides a system corresponding to the above method, which includes:

[0155] The information acquisition module is used to obtain the flight information required by the traditional ticket sales system and the NDC sales system; based on the obtained flight information, the table structure and table content of the order table, order item table, aviation product table, aviation product item table, flight segment table, and ticket table are determined;

[0156] The flight selection module is used to obtain flight information through the AirShopping interface and display it to users when booking air tickets;

[0157] The verification module is used to verify the payment price of the selected flight using the OfferPrice interface after the user selects the flight; after the payment price verification is passed, the order table, order item table, aviation product table, aviation product item table, and flight segment table are generated based on the obtained flight information;

[0158] The payment module is used to pay the order amount using the OrderChange interface. After the payment is completed, the ticket information is obtained from the external airline, and a ticket table is generated based on the ticket information to realize the generation of the air order.

[0159] Based on the same inventive concept as the above disclosed content, an embodiment of the present disclosure also provides a device corresponding to the above method, which includes at least one processor; and a memory communicatively connected to the at least one processor; wherein the memory stores instructions that can be executed by the at least one processor, and the instructions are executed by the at least one processor to enable the at least one processor to execute the above method.

[0160] It should be noted that the electrical connection between the above-mentioned units does not necessarily mean the connection between lines. An indirect connection method can be applied to the embodiments of the present disclosure as long as the purpose of the present disclosure is achieved.

[0161] Based on the same inventive concept, the present disclosure also provides a computer storage medium on which executable instructions are stored, and the instructions are executed by a processor to execute the above method.

[0162] Although the present disclosure has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or make equivalent replacements for some of the technical features therein; and these modifications or replacements do not make the essence of the corresponding technical solutions deviate from the spirit and scope of the technical solutions of the embodiments of the present disclosure.

Claims

1. A method for generating an air ticket order, used for generating an air ticket order by a ticket sales system, characterized in that: include: Obtain flight information required by traditional ticket sales systems and NDC sales systems; Determine the table structure and table content of the order table, order item table, aviation product table, aviation product item table, flight segment table, and ticket table based on the obtained flight information; When booking air tickets, obtain flight information through the AirShopping interface and display it to the user; After the user selects a flight, the OfferPrice interface is used to verify the payment price of the selected flight. After the payment price verification is passed, the order table, order item table, aviation product table, aviation product item table, and flight segment table are generated based on the obtained flight information. The OrderChange interface is used to pay the order amount. After the payment is completed, the ticket information is obtained from the external airline, and a ticket table is generated based on the ticket information to realize the generation of the airline order.

2. The method for generating an aviation order according to claim 1, characterized in that: The information in the order table includes: order number, order source, tracking identifier TraceId, total price, total tax, currency unit, payment status, cancellation status, and reservation person; The information of the order item table includes: order number, person, purchased product ID, total price, total tax, currency unit, status, order item ID; The information of the aviation product table includes: aviation product identification, PNR, and airline code; The information of the aviation product item list includes: flight segment identification, flight distance, cabin space, brand fare, and flight number; The information of the flight segment table includes: flight segment identification, flight distance, cabin space, brand fare, and flight number; The information of the ticket list includes: ticket number, main ticket number, multiple flight segment identifiers, ticket issuance time, and change status.

3. The method for generating an aviation order according to claim 1, characterized in that: After the air order is generated, if the user needs to change the ticket, perform the following steps: Select the flight you want to rebook and fill in the departure and arrival information and date; Based on the departure and arrival information and dates, query the flight change information through the OrderReshop interface; After the user chooses to change the flight, the OrderChange interface is called to confirm the change and generate a change record table.

4. The method for generating an aviation order according to claim 3, characterized in that: The query of flight change information through the OrderReshop interface includes: The first OrderReshop returns the flight information that the user can change; The second OrderReshop returns to select whether the flight can be changed and how much the change fee is.

5. The method for generating an aviation order according to claim 3, characterized in that: The information in the ticket change record table includes: old order item ID, new order item ID, reason for ticket change, ticket change fee, and ticket change time.

6. The method for generating an aviation order according to claim 1, characterized in that: After the air order is generated, if the user needs to purchase additional services, perform the following steps: Get the information of additional services that the current air order is authorized to purchase through the ServiceList interface; After the user selects the additional service, he / she pays the purchase fee of the additional service through the OrderChange interface and updates the flight order.

7. The method for generating an aviation order according to claim 6, characterized in that: The additional service information includes: additional service product identification, additional service content description, and product code.

8. An aviation order generation system, characterized in that: include: Information acquisition module, used to obtain flight information required by traditional ticket sales system and NDC sales system; Determine the table structure and table content of the order table, order item table, aviation product table, aviation product item table, flight segment table, and ticket table based on the obtained flight information; The flight selection module is used to obtain flight information through the AirShopping interface and display it to users when booking air tickets; The verification module is used to verify the payment price of the selected flight using the OfferPrice interface after the user selects the flight; after the payment price verification is passed, the order table, order item table, aviation product table, aviation product item table, and flight segment table are generated based on the obtained flight information; The payment module is used to pay the order amount using the OrderChange interface. After the payment is completed, the ticket information is obtained from the external airline, and a ticket table is generated based on the ticket information to realize the generation of the air order.

9. An aviation order generating device, comprising: at least one processor; And a memory communicatively connected to the at least one processor; wherein the memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor so that the at least one processor can execute the aviation order generation method described in any one of claims 1 to 7.

10. A computer storage medium having executable instructions stored thereon, wherein when the instructions are executed by a processor, the processor is enabled to implement the method according to any one of claims 1 to 7.

Images