CN115099856A - Data processing method, device and system - Google Patents
Data processing method, device and system Download PDFInfo
- Publication number
- CN115099856A CN115099856A CN202210726413.2A CN202210726413A CN115099856A CN 115099856 A CN115099856 A CN 115099856A CN 202210726413 A CN202210726413 A CN 202210726413A CN 115099856 A CN115099856 A CN 115099856A
- Authority
- CN
- China
- Prior art keywords
- air ticket
- target
- freight rate
- agent fee
- agent
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 19
- 238000004364 calculation method Methods 0.000 claims abstract description 236
- 238000000034 method Methods 0.000 claims abstract description 19
- 238000012545 processing Methods 0.000 claims description 24
- 238000012795 verification Methods 0.000 description 9
- 238000007726 management method Methods 0.000 description 7
- 230000007246 mechanism Effects 0.000 description 5
- 238000010586 diagram Methods 0.000 description 4
- 230000008569 process Effects 0.000 description 4
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000012550 audit Methods 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 238000013459 approach Methods 0.000 description 1
- 238000004590 computer program Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000014509 gene expression Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/02—Marketing; Price estimation or determination; Fundraising
- G06Q30/0283—Price estimation or determination
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24564—Applying rules; Deductive queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/40—Business processes related to the transportation industry
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Strategic Management (AREA)
- Development Economics (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Finance (AREA)
- Economics (AREA)
- General Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Marketing (AREA)
- Data Mining & Analysis (AREA)
- Game Theory and Decision Science (AREA)
- Computational Linguistics (AREA)
- General Engineering & Computer Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Databases & Information Systems (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Human Resources & Organizations (AREA)
- Primary Health Care (AREA)
- Tourism & Hospitality (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The embodiment of the application discloses a data processing method, a device and a system, wherein the method comprises the following steps: receiving an air ticket freight rate calculation request sent by an agent sales end, wherein the air ticket freight rate calculation request comprises related air ticket information corresponding to a target air ticket; matching the related air ticket information corresponding to the target air ticket with the air ticket freight rate calculation rule stored in the freight rate database, and determining the air ticket price information corresponding to the target air ticket; and matching the air ticket price information and the related air ticket information corresponding to the target air ticket with a proxy fee calculation rule stored in a proxy fee database, and determining the proxy fee information corresponding to the target air ticket. The method can reduce the time-consuming workload of the settlement agent of the agent, and reduce the complexity of the settlement auditing work of the airline company.
Description
Technical Field
The present application relates to the field of internet technologies, and in particular, to a data processing method, apparatus, and system.
Background
The ticket agency fee is an extra commission provided by the airline to the agent in the distribution channel to help the agent sell airline tickets. Generally, the higher the sales of tickets that an agent helps an airline sell, the more ticket agents it can reach.
The mechanism of the commission fee of the air ticket agency fee is bound with the price of the air ticket, and an airline company provides the air ticket agency fee for an agent according to a certain proportion of the price of the air ticket sold by the agent. The commission mechanism for the ticket agent fee is then adjusted to require payment of the agent fee per ticket quota. At present, the commission mechanism suitable for the air ticket agency fee is adjusted, an agent is generally required to manually calculate the air ticket agency fee and pay the air ticket agency fee for auditing by an airline company, and the agent is paid with the corresponding air ticket agency fee after the airline company audits; this approach is cumbersome for the agent and increases the associated workload, as well as the complexity of the airline settlement auditing for the airline.
Disclosure of Invention
The embodiment of the application provides a data processing method, device and system, which can reduce the time-consuming workload of agent settlement agents and reduce the complexity of the settlement auditing work of airlines.
In view of this, a first aspect of the present application provides a data processing method, including:
receiving an air ticket freight rate calculation request sent by an agent sales end; the air ticket freight rate calculation request comprises related air ticket information corresponding to a target air ticket;
matching relevant air ticket information corresponding to the target air ticket with air ticket freight rate calculation rules stored in a freight rate database, and determining air ticket price information corresponding to the target air ticket; the freight rate database comprises air ticket freight rate calculation rules set by an airline company, and the air ticket freight rate calculation rules are used for representing the corresponding relation between the related air ticket information and the air ticket price information;
matching the air ticket price information and the related air ticket information corresponding to the target air ticket with an agent fee calculation rule stored in an agent fee database, and determining agent fee information corresponding to the target air ticket; the agent fee database comprises agent fee calculation rules set by an airline company, and the agent fee calculation rules are used for representing the corresponding relation among air ticket price information, related air ticket information and agent fee information.
Optionally, the matching the relevant air ticket information corresponding to the target air ticket with the air ticket freight rate calculation rule stored in the freight rate database to determine the air ticket price information corresponding to the target air ticket includes:
aiming at the target air ticket, determining that an airline company to which the target air ticket belongs is a target airline company;
and searching a target air ticket freight rate calculation rule which is set by the target airline company and comprises related air ticket information corresponding to the target air ticket in the freight rate database, and determining at least one air ticket price information corresponding to the target air ticket based on the target air ticket freight rate calculation rule.
Optionally, the matching the air ticket price information and the related air ticket information corresponding to the target air ticket with the agent fee calculation rule stored in the agent fee database to determine the agent fee information corresponding to the target air ticket includes:
and searching a target agent fee calculation rule which is set by the target airline company and comprises air ticket price information corresponding to the target air ticket and related air ticket information in the agent fee database aiming at each air ticket price information corresponding to the target air ticket, and determining the agent fee information corresponding to the air ticket price information based on the target agent fee calculation rule.
Optionally, the configuration of the agent fee calculation rule included in the agent fee database with a corresponding priority, and when a plurality of target agent fee calculation rules are found in the agent fee database for an air ticket price information corresponding to the target air ticket, determining the agent fee information corresponding to the air ticket price information based on the target agent fee calculation rules includes:
selecting a target agent fee calculation rule with the highest priority from the plurality of target agent fee calculation rules; and determining agent fee information corresponding to the air ticket price information based on the target agent fee calculation rule with the highest priority.
Optionally, the method further includes:
and sending the air ticket price information and the agent fee information corresponding to the target air ticket to the agent sales end.
A second aspect of the present application provides a data processing apparatus, the apparatus comprising:
the request receiving module is used for receiving an air ticket freight rate calculation request sent by the agent sales end; the air ticket freight rate calculation request comprises related air ticket information corresponding to a target air ticket;
the freight rate calculation module is used for matching the related air ticket information corresponding to the target air ticket with air ticket freight rate calculation rules stored in a freight rate database and determining the air ticket price information corresponding to the target air ticket; the freight rate database comprises air ticket freight rate calculation rules set by an airline company, and the air ticket freight rate calculation rules are used for representing the corresponding relation between the related air ticket information and the air ticket price information;
the agent fee calculation module is used for matching the air ticket price information and the related air ticket information corresponding to the target air ticket with an agent fee calculation rule stored in an agent fee database and determining the agent fee information corresponding to the target air ticket; the agent fee database comprises agent fee calculation rules set by an airline company, and the agent fee calculation rules are used for representing the corresponding relation among air ticket price information, related air ticket information and agent fee information.
Optionally, the freight rate calculation module is specifically configured to:
aiming at the target air ticket, determining that an airline company to which the target air ticket belongs is a target airline company;
and searching a target air ticket freight rate calculation rule which is set by the target airline company and comprises related air ticket information corresponding to the target air ticket in the freight rate database, and determining at least one air ticket price information corresponding to the target air ticket based on the target air ticket freight rate calculation rule.
Optionally, the agent fee calculating module is specifically configured to:
and searching a target agent fee calculation rule which is set by the target airline company and comprises air ticket price information corresponding to the target air ticket and related air ticket information in the agent fee database aiming at each air ticket price information corresponding to the target air ticket, and determining the agent fee information corresponding to the air ticket price information based on the target agent fee calculation rule.
Optionally, the agent fee calculation rule included in the agent fee database is configured with a corresponding priority, and the agent fee calculation module is specifically configured to:
when a plurality of target agent fee calculation rules are found in the agent fee database aiming at the ticket price information corresponding to the target ticket, selecting a target agent fee calculation rule with the highest priority from the plurality of target agent fee calculation rules; and determining agent fee information corresponding to the air ticket price information based on the target agent fee calculation rule with the highest priority.
A third aspect of the present application provides a data processing system, the system comprising:
the air ticket freight rate management component is used for managing the related information of the air ticket freight rate set by the airline company;
the air ticket freight rate calculation rule is used for representing the corresponding relation between the related air ticket information and the air ticket price information;
the agent fee database is used for storing agent fee calculation rules set by an airline company, and the agent fee calculation rules are used for representing the corresponding relation among air ticket price information, related air ticket information and agent fee information;
and the air ticket freight rate calculation component is used for executing the data processing method of the first aspect.
According to the technical scheme, the embodiment of the application has the following advantages:
the embodiment of the application provides a data processing method, which comprises the following steps: receiving an air ticket freight rate calculation request sent by an agent sales end, wherein the air ticket freight rate calculation request comprises related air ticket information corresponding to a target air ticket; then, matching relevant air ticket information corresponding to the target air ticket with air ticket freight rate calculation rules stored in a freight rate database, and determining the air ticket price information corresponding to the target air ticket, wherein the freight rate database comprises air ticket freight rate calculation rules set by an airline company, and the air ticket freight rate calculation rules are used for representing the corresponding relation between the relevant air ticket information and the air ticket price information; further, matching the air ticket price information and the related air ticket information corresponding to the target air ticket with a proxy fee calculation rule stored in a proxy fee database, and determining proxy fee information corresponding to the target air ticket; the agent fee database comprises agent fee calculation rules set by an airline company, and the agent fee calculation rules are used for representing the corresponding relation among air ticket price information, related air ticket information and agent fee information. Therefore, through the mechanism, when the agent calculates the freight rate and the agent fee, the agent can automatically calculate the price information and the agent fee information of the air ticket without manually calculating the agent, so that the workload of accounting and agent fee-consuming by the agent can be reduced, and the complexity of accounting and auditing work of an airline company is reduced.
Drawings
FIG. 1 is a block diagram of a data processing system according to an embodiment of the present application;
fig. 2 is a schematic flowchart of a data processing method according to an embodiment of the present application;
fig. 3 is a schematic structural diagram of a data processing apparatus according to an embodiment of the present application.
Detailed Description
In order to make those skilled in the art better understand the technical solutions of the present application, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
The terms "first," "second," "third," "fourth," and the like in the description and in the claims of the present application and in the drawings described above, if any, are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It should be understood that the data so used may be interchanged under appropriate circumstances such that embodiments of the application described herein may be implemented in sequences other than those illustrated or described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
The data processing system provided in the embodiment of the present application is described below, and the data processing system is used to support implementation of the data processing method provided in the embodiment of the present application, so as to calculate the price information and the agent fee information of the air ticket. Referring to fig. 1, fig. 1 is a schematic structural diagram of a data processing system according to an embodiment of the present application. As shown in fig. 1, the system includes a ticket fare management component, a ticket fare calculation component, a fare database, and a proxy fee database.
The air ticket freight rate management component is used for managing the related information of the air ticket freight rate set by the airline company. Specifically, the air ticket freight rate management component can provide an air ticket freight rate product issuing tool for each airline company, and can maintain air ticket freight rate product information, air ticket freight rate rule information, agency fee information, tax information and the like.
The air ticket freight rate calculating component is used for executing the data processing method provided by the embodiment of the application, responding to an air ticket freight rate calculating request sent by the agent sales end, determining air ticket price information and agent fee information corresponding to the target air ticket, and feeding back the calculated air ticket price information and agent fee information corresponding to the target air ticket to the agent sales end.
The air ticket freight rate database is used for storing air ticket freight rate calculation rules set by each airline company, and the air ticket freight rate calculation rules are used for representing the corresponding relation between the related air ticket information and the air ticket price information.
The agent fee database is used for storing agent fee calculation rules set by each airline company, and the agent fee calculation rules are used for representing the corresponding relation among air ticket price information, related air ticket information and agent fee information, namely representing the corresponding relation between the combination of the air ticket price information and the related air ticket information and the agent fee information.
The data processing system provided by the embodiment of the application is used for interacting with the agent selling end component, and the agent selling end component is used for sending the air ticket freight rate calculation request to the air ticket freight rate calculation component, receiving the air ticket price information and the agent fee information returned by the air ticket freight rate calculation component, and displaying the returned air ticket price information and the agent fee information for subsequent air ticket drawing.
The following describes the data processing method provided in the present application in detail by way of a method embodiment.
Referring to fig. 2, fig. 2 is a schematic flowchart of a data processing method according to an embodiment of the present disclosure. The data processing method is executed by the air ticket freight rate calculating component in the data processing system shown in fig. 1, and as shown in fig. 2, the data processing method comprises the following steps:
step 201: receiving an air ticket freight rate calculation request sent by an agent sales end; and the air ticket freight rate calculation request comprises related air ticket information corresponding to the target air ticket.
In practical applications, the agent can send a ticket freight rate calculation request to the ticket freight rate calculation component through the agent sales end component, wherein the ticket freight rate calculation request includes relevant ticket information corresponding to a target ticket currently sold by the agent. In the embodiment of the present application, the relevant air ticket information in the air ticket freight rate calculation request may include, but is not limited to: passenger information, the origin of the target ticket, the destination, travel time, cabin space, etc. After receiving the air ticket freight rate calculation request, the air ticket freight rate calculation component can trigger the calculation of the air ticket price information according to the related air ticket information carried in the air ticket freight rate calculation request.
Step 202: matching relevant air ticket information corresponding to the target air ticket with air ticket freight rate calculation rules stored in a freight rate database, and determining air ticket price information corresponding to the target air ticket; the freight rate database comprises air ticket freight rate calculation rules set by an airline company, and the air ticket freight rate calculation rules are used for representing the corresponding relation between the related air ticket information and the air ticket price information.
After receiving the air ticket freight rate calculation request, the air ticket freight rate calculation component can calculate the air ticket price information corresponding to the target air ticket according to the relevant air ticket information corresponding to the target air ticket carried in the air ticket freight rate calculation request. Specifically, the air ticket freight rate calculation component may match the relevant air ticket information carried in the air ticket freight rate calculation request with the air ticket freight rate calculation rule stored in the freight rate database, for example, according to the information of the passenger, the origin, the destination, the travel time, the cabin space, and the like carried in the air ticket freight rate calculation request, the air ticket freight rate information matched with the information may be searched in the freight rate database, and the searched air ticket freight rate information may be used as the air ticket freight rate information corresponding to the target air ticket.
It should be noted that the freight rate database includes air ticket freight rate calculation rules set by the airline company, and the air ticket freight rate calculation rules are used for representing the corresponding relationship between the relevant air ticket information and the air ticket price information. In the embodiment of the application, an airline company can log in an air ticket freight rate management system by using a company account, input information such as the travel type, the origin, the destination, the freight rate basis and the like of the air ticket freight rate according to needs, edit freight rate rule information such as discount codes, sellable start and stop time, flight travel time, ticket drawing time, flight slots, rule numbers and the like, create group information such as OFFICE, PID and the like, and add pricing information such as prices according to different passenger types; the information entered by the airline company is essentially an air ticket freight rate calculation rule, and the entered information has corresponding air ticket price information. And after the data validity is checked, storing the air ticket freight rate calculation rule to a freight rate database to finish issuing.
In the embodiment of the application, when the air ticket freight rate calculation component specifically determines the air ticket price information corresponding to the target air ticket, the airline company to which the target air ticket belongs can be determined as the target airline company for the target air ticket; then, searching a target air ticket freight rate calculation rule which is set by a target airline company and comprises related air ticket information corresponding to the target air ticket in a freight rate database, and further determining at least one air ticket price information corresponding to the target air ticket based on the target air ticket freight rate calculation rule.
Specifically, for a target ticket, the ticket fare calculation component needs to determine an airline company to which the target ticket belongs first, and consider the airline company as the target airline company. Then, searching a ticket freight rate calculation rule which is issued by the target airline company and comprises relevant ticket information corresponding to the target ticket in a freight rate database, and taking the ticket freight rate calculation rule as the target ticket freight rate calculation rule; it should be noted that, in general, each air ticket freight rate calculation rule in the freight rate database includes a large amount of relevant air ticket information and air ticket price information corresponding to the relevant air ticket information, the relevant ticket information carried in the ticket fare calculation request is typically only a subset of the relevant ticket information included in the ticket fare calculation rules, and, therefore, searching a target air ticket freight rate calculation rule in a freight rate database, substantially searching an air ticket freight rate calculation rule comprising each piece of relevant air ticket information carried in an air ticket freight rate calculation request in the freight rate database, namely, the related air ticket information included in the searching completely covers the air ticket freight rate calculation rule of the related air ticket information carried in the air ticket freight rate calculation request, in this case, the ticket fare calculation component can find a plurality of target ticket fare calculation rules for the target ticket. Further, the air ticket freight rate calculation component can use the air ticket price information in each searched target air ticket freight rate calculation rule as the air ticket price information corresponding to the target air ticket.
Step 203: matching the air ticket price information and the related air ticket information corresponding to the target air ticket with a proxy fee calculation rule stored in a proxy fee database, and determining proxy fee information corresponding to the target air ticket; the agent fee database comprises agent fee calculation rules set by an airline company, and the agent fee calculation rules are used for representing the corresponding relation among air ticket price information, related air ticket information and agent fee information.
After the air ticket price information corresponding to the target air ticket is determined by the air ticket freight price calculating component, the agent fee information corresponding to the target air ticket can be further determined according to the target air ticket price information and the related air ticket information carried in the air ticket freight price calculating request. Specifically, the air ticket freight rate calculation component may match the determined air ticket price information corresponding to the target air ticket and the relevant air ticket information carried in the air ticket freight rate calculation request with the agent fee calculation rule stored in the agent fee database, for example, according to the air ticket price information and the passenger information, the origin, the destination, the travel time, the cabin space and other information carried in the air ticket freight rate calculation request, the agent fee information matched with the information may be searched in the agent fee database, and the searched agent fee information may be used as the agent fee information corresponding to the target air ticket.
It should be noted that the agent fee database includes an agent fee calculation rule set by the airline company, and the agent fee calculation rule is used to represent the corresponding relationship between the air ticket price information, the related air ticket information, and the agent fee information, that is, to represent the corresponding relationship between the combination of the air ticket price information and the related air ticket information, and the agent fee information. In the embodiment of the application, an airline company can log in an air ticket freight rate management system by using a company account, and input information such as an agent fee control name and a priority number according to needs, edit agent fee rule information such as an origin, a destination, a cabin space, a service level, a team identification, a discount code, a large client code, a system, a release channel, a code sharing identification, a carrier airline company, a saleable start-stop time, a flight travel time, a freight rate base (namely air ticket price information), a flight number, a ticket face price interval and a ticket price discount interval, create group information such as a number, and add pricing information such as a rated agent fee amount; the information entered by the airline company is essentially an agent fee calculation rule, and the entered information has corresponding air ticket price information. And after the data validity is checked, storing the agent fee calculation rule to a freight rate database to finish the release.
In this embodiment of the application, when the air ticket freight rate calculation component specifically determines the agent fee information corresponding to the target air ticket, a target agent fee calculation rule set by the target airline company and including the air ticket price information corresponding to the target air ticket and the related air ticket information may be searched in the agent fee database for each air ticket price information corresponding to the target air ticket, and then, the agent fee information corresponding to the air ticket price information is determined based on the target agent fee calculation rule.
Specifically, as described above, the air ticket freight calculation component may find multiple target air ticket freight calculation rules for a target air ticket, and determine multiple corresponding air ticket price information according to the multiple target air ticket freight calculation rules, in this case, for each air ticket price information, the air ticket freight calculation component may search, in the agent fee database, an agent fee calculation rule set by a target airline that sells the target air ticket, the agent fee calculation rule including the air ticket price information and relevant air ticket information carried in an air ticket freight calculation request, as a target agent fee calculation rule, and use agent fee information included in the target agent fee calculation rule as agent fee information corresponding to the air ticket price information.
In addition, considering that each kind of air ticket price information only corresponds to one kind of agent fee information, and the agent fee calculation rule usually includes a large amount of related air ticket information, the air ticket freight price calculation component may match a plurality of target agent fee calculation rules in the agent fee database according to the air ticket price information and the related air ticket information carried in the air ticket freight price calculation request, that is, determine a plurality of kinds of agent fee information for one kind of air ticket price information, in order to avoid this, the airline company may also configure corresponding priorities for the agent fee calculation rules entered therein, when a plurality of target agent fee calculation rules are found in the agent fee database for one kind of air ticket price information corresponding to a target air ticket, the air ticket freight price calculation component may select a target agent fee calculation rule with the highest priority from the plurality of target agent fee calculation rules, and the agent fee information in the target agent fee calculation rule is used as the agent fee information corresponding to the price information of the ticket.
After the air ticket freight rate calculation component obtains the air ticket price information and the agent fee information corresponding to the target air ticket through the steps, the air ticket price information and the agent fee information can be integrated, and the integrated result is fed back to the agent sales end, so that the air ticket price information and the agent fee information corresponding to the target air ticket are displayed to an agent at the front end.
The data processing method provided by the embodiment of the application comprises the following steps: receiving an air ticket freight rate calculation request sent by an agent sales end, wherein the air ticket freight rate calculation request comprises related air ticket information corresponding to a target air ticket; then, matching relevant air ticket information corresponding to the target air ticket with air ticket freight rate calculation rules stored in a freight rate database, and determining the air ticket price information corresponding to the target air ticket, wherein the freight rate database comprises air ticket freight rate calculation rules set by an airline company, and the air ticket freight rate calculation rules are used for representing the corresponding relation between the relevant air ticket information and the air ticket price information; further, matching the air ticket price information and the related air ticket information corresponding to the target air ticket with a proxy fee calculation rule stored in a proxy fee database, and determining proxy fee information corresponding to the target air ticket; the agent fee database comprises agent fee calculation rules set by an airline company, and the agent fee calculation rules are used for representing the corresponding relation among air ticket price information, related air ticket information and agent fee information. Therefore, through the mechanism, when the agent calculates the freight rate and the agent fee of the computer ticket, the price information and the agent fee information of the computer ticket can be automatically calculated without manual calculation of the agent, the workload of the agent for settling the agent fee can be reduced, and the complexity of the settlement and audit work of an airline company can be reduced.
In order to further understand the data processing method provided in the embodiments of the present application, a whole data processing method provided in the embodiments of the present application is described below by way of example.
First, the airline company can issue the ticket fare calculation rule in the following manner: newly building a domestic air ticket freight rate, inquiring an air ticket freight rate interface, clicking a newly-built button, entering the air ticket freight rate newly-built interface, setting rule use ranges of a flight range type, a cabin space code, a freight rate base, a sales effective date, a sales expiration date, a travel effective date, a travel expiration date, a ticket output effective date, a ticket output expiration date, a discount code, an origin, a destination, a sales week, a flight number and the like, and storing configuration information of an airline company, a builder position, building time, a last updater, a last updated position, last updated time and the like. And adding the air ticket freight rate price, and setting air ticket freight rate information including but not limited to passenger types, prices and the like.
Checking the validity of the fare calculation rule of the air ticket, wherein the checking contents include but are not limited to: and verifying that the sale effective date is later than the current date, the verification freight rate base cannot be null, the verification sale effective date cannot be null, the latest travel date is later than the earliest travel date, and storing the data after successful verification.
Then, the airline company can perform the issuance of the agent fee calculation rule by: in a rated agent fee control management interface, rated agent fee rule data is newly established, information including agent fee control names, priority serial numbers, cabin positions, origins, destinations, team identifications, discount codes, large customer codes, systems, release channels, code sharing identifications, carrier airlines, sales effective dates, sales expiration dates, earliest travel dates, latest travel dates, freight rate bases, flight numbers, fare price intervals, fare discount intervals, group numbers and the like is set, and configuration information such as airlines, establishment time and the like is stored. Quota agent fee amount information is added.
And checking the legality of the rated proxy fee data, wherein the checking contents include but are not limited to: the verification effective date is later than the current date, the verification priority number cannot be null, the verification quota agent fee amount cannot be null, the verification agent fee control name cannot be null, the verification effective date cannot be null, and the data are stored after successful verification.
When receiving an air ticket freight rate calculation request from an agent sales end, the air ticket freight rate calculation component analyzes front-end identity information, flight segment information, flight information, passenger information and the like in the request, sends the information to the air ticket freight rate calculation processing module, and inquires available air ticket freight rates on the journey. For example, the inquiry request journey is PEK-SHA-CAN-CTU, and the result returned by the air ticket freight rate calculation processing module is as follows: 01. freight rate basis YOW, price 3800 CNY; 02. freight rate basis Y/CCNOW97, price 3500 CNY; 03. freight rate base Y/NRT95, price 3400 CNY. The available air ticket price information includes the above three.
And triggering the air ticket freight rate calculation component to initiate a rated agent charge calculation request to the rated agent charge processing module by taking the air ticket freight rate information as a unit according to a result returned by the air ticket freight rate calculation processing module. As the above example, 3 calculation requests are initiated to the rated proxy fee processing module, and the calculation of the rated proxy fees corresponding to three freight rates of which the freight rate bases are YOW, Y/CCNOW97 and Y/NRT95 respectively is required. And after receiving the calculation request, the rating agent fee processing module queries an agent fee database according to the passenger information, the travel information, the flight information and the freight rate information, matches with a proper rating agent fee calculation rule, determines the rating agent fee of each freight rate and returns the rating agent fee to the air ticket freight rate calculation component. For example, the query finds: 01. freight rate base YOW, agent fee 30 CNY; 02. freight rate base Y/CCNOW97, agent fee 25 CNY; 03. freight rate base Y/NRT95, proxy fee 25 CNY. All three proxy fee information is returned.
And the air ticket freight rate calculation component integrates the processing results of the air ticket freight rate calculation processing module and the rated agent fee processing module, and outputs the information to the agent sales end for displaying to an agent. As in the above example, the final return result itinerary PEK-SHA-CAN-CTU has the following available fare: 01. freight rate base YOW, price 3800CNY, agent fee 30 CNY; 02. freight rate basis Y/CCNOW97, price 3500CNY, agency fee 25 CNY; 03. freight rate base Y/NRT95, price 3400CNY, agent fee 25 CNY.
An embodiment of the present application further provides a data processing apparatus, referring to fig. 3, fig. 3 is a schematic structural diagram of the data processing apparatus provided in the embodiment of the present application, and as shown in fig. 3, the apparatus includes:
the request receiving module 301 is configured to receive an air ticket freight rate calculation request sent by an agent sales end; the air ticket freight rate calculation request comprises related air ticket information corresponding to a target air ticket;
a freight rate calculation module 302, configured to match relevant air ticket information corresponding to the target air ticket with air ticket freight rate calculation rules stored in a freight rate database, and determine air ticket price information corresponding to the target air ticket; the freight rate database comprises air ticket freight rate calculation rules set by an airline company, and the air ticket freight rate calculation rules are used for representing the corresponding relation between the related air ticket information and the air ticket price information;
the agent fee calculation module 303 is configured to match the air ticket price information and the related air ticket information corresponding to the target air ticket with an agent fee calculation rule stored in an agent fee database, and determine agent fee information corresponding to the target air ticket; the agent fee database comprises agent fee calculation rules set by an airline company, and the agent fee calculation rules are used for representing the corresponding relation among air ticket price information, related air ticket information and agent fee information.
Optionally, the freight rate calculation module 302 is specifically configured to:
aiming at the target air ticket, determining that an airline company to which the target air ticket belongs is a target airline company;
and searching a target air ticket freight rate calculation rule which is set by the target airline company and comprises related air ticket information corresponding to the target air ticket in the freight rate database, and determining at least one air ticket price information corresponding to the target air ticket based on the target air ticket freight rate calculation rule.
Optionally, the agent fee calculating module 303 is specifically configured to:
and searching a target agent fee calculation rule which is set by the target airline company and comprises air ticket price information corresponding to the target air ticket and related air ticket information in the agent fee database aiming at each air ticket price information corresponding to the target air ticket, and determining the agent fee information corresponding to the air ticket price information based on the target agent fee calculation rule.
Optionally, the agent fee calculation rule included in the agent fee database is configured with a corresponding priority, and the agent fee calculation module 303 is specifically configured to:
when a plurality of target agent fee calculation rules are found in the agent fee database aiming at the ticket price information corresponding to the target ticket, selecting a target agent fee calculation rule with the highest priority from the plurality of target agent fee calculation rules; and determining agent fee information corresponding to the air ticket price information based on the target agent fee calculation rule with the highest priority.
Optionally, the apparatus further comprises:
and the sending module is used for sending the air ticket price information and the agent fee information corresponding to the target air ticket to the agent sales end.
By the device, the agent can automatically calculate the price information and the agent fee information of the computer ticket at the freight rate and the agent fee of the computer ticket without manual calculation of the agent, so that the workload of the agent for settling the agent fee and the checking work of the airline company can be reduced.
It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described systems, apparatuses and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
In the several embodiments provided in the present application, it should be understood that the disclosed system, apparatus and method may be implemented in other manners. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the units is only one logical division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application may be substantially implemented or contributed to by the prior art, or all or part of the technical solution may be embodied in a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present application. And the aforementioned storage medium includes: a U disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing computer programs.
It should be understood that, in this application, "at least one" means one or more, "a plurality" means two or more. "and/or" is used to describe the association relationship of the associated object, indicating that there may be three relationships, for example, "a and/or B" may indicate: only A, only B and both A and B are present, wherein A and B may be singular or plural. The character "/" generally indicates that the former and latter associated objects are in an "or" relationship. "at least one of the following" or similar expressions refer to any combination of these items, including any combination of the singular or plural items. For example, at least one (one) of a, b, or c, may represent: a, b, c, "a and b", "a and c", "b and c", or "a and b and c", wherein a, b, c may be single or plural.
The above embodiments are only used to illustrate the technical solutions of the present application, and not to limit the same; although the present application has been described in detail with reference to the foregoing embodiments, it should be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present application.
Claims (10)
1. A method of data processing, the method comprising:
receiving an air ticket freight rate calculation request sent by an agent sales end; the air ticket freight rate calculation request comprises related air ticket information corresponding to a target air ticket;
matching relevant air ticket information corresponding to the target air ticket with air ticket freight rate calculation rules stored in a freight rate database, and determining air ticket price information corresponding to the target air ticket; the freight rate database comprises air ticket freight rate calculation rules set by an airline company, and the air ticket freight rate calculation rules are used for representing the corresponding relation between the related air ticket information and the air ticket price information;
matching the air ticket price information and the related air ticket information corresponding to the target air ticket with a proxy fee calculation rule stored in a proxy fee database, and determining proxy fee information corresponding to the target air ticket; the agent fee database comprises agent fee calculation rules set by an airline company, and the agent fee calculation rules are used for representing the corresponding relation among air ticket price information, related air ticket information and agent fee information.
2. The method of claim 1, wherein the matching of the relevant air ticket information corresponding to the target air ticket with the air ticket freight rate calculation rule stored in the freight rate database to determine the air ticket price information corresponding to the target air ticket comprises:
aiming at the target air ticket, determining that an airline to which the target air ticket belongs is a target airline;
and searching a target air ticket freight rate calculation rule which is set by the target airline company and comprises related air ticket information corresponding to the target air ticket in the freight rate database, and determining at least one air ticket price information corresponding to the target air ticket based on the target air ticket freight rate calculation rule.
3. The method of claim 2, wherein the matching of the ticket price information and the related ticket information corresponding to the target ticket with the agent fee calculation rule stored in the agent fee database to determine the agent fee information corresponding to the target ticket comprises:
and aiming at each air ticket price information corresponding to the target air ticket, searching a target agent fee calculation rule which is set by the target airline company and comprises the air ticket price information corresponding to the target air ticket and related air ticket information in the agent fee database, and determining the agent fee information corresponding to the air ticket price information based on the target agent fee calculation rule.
4. The method according to claim 3, wherein the agent fee calculation rules included in the agent fee database are configured with corresponding priorities, and when a plurality of target agent fee calculation rules are found in the agent fee database for a type of ticket price information corresponding to the target ticket, the determining the agent fee information corresponding to the ticket price information based on the target agent fee calculation rules comprises:
selecting a target agent fee calculation rule with the highest priority from the plurality of target agent fee calculation rules; and determining agent fee information corresponding to the air ticket price information based on the target agent fee calculation rule with the highest priority.
5. The method of claim 1, further comprising:
and sending the air ticket price information and the agent fee information corresponding to the target air ticket to the agent sales end.
6. A data processing apparatus, characterized in that the apparatus comprises:
the request receiving module is used for receiving an air ticket freight rate calculation request sent by the agent sales end; the air ticket freight rate calculation request comprises related air ticket information corresponding to a target air ticket;
the freight rate calculation module is used for matching the related air ticket information corresponding to the target air ticket with air ticket freight rate calculation rules stored in a freight rate database and determining the air ticket price information corresponding to the target air ticket; the freight rate database comprises air ticket freight rate calculation rules set by an airline company, and the air ticket freight rate calculation rules are used for representing the corresponding relation between the related air ticket information and the air ticket price information;
the agent fee calculation module is used for matching the air ticket price information and the related air ticket information corresponding to the target air ticket with an agent fee calculation rule stored in an agent fee database and determining the agent fee information corresponding to the target air ticket; the agent fee database comprises agent fee calculation rules set by an airline company, and the agent fee calculation rules are used for representing the corresponding relation among air ticket price information, related air ticket information and agent fee information.
7. The apparatus of claim 6, wherein the rate calculation module is specifically configured to:
aiming at the target air ticket, determining that an airline company to which the target air ticket belongs is a target airline company;
and searching a target air ticket freight rate calculation rule which is set by the target airline company and comprises related air ticket information corresponding to the target air ticket in the freight rate database, and determining at least one air ticket price information corresponding to the target air ticket based on the target air ticket freight rate calculation rule.
8. The apparatus of claim 7, wherein the proxy fee calculation module is specifically configured to:
and searching a target agent fee calculation rule which is set by the target airline company and comprises air ticket price information corresponding to the target air ticket and related air ticket information in the agent fee database aiming at each air ticket price information corresponding to the target air ticket, and determining the agent fee information corresponding to the air ticket price information based on the target agent fee calculation rule.
9. The apparatus according to claim 8, wherein the agent fee calculation rule included in the agent fee database is configured with a corresponding priority, and the agent fee calculation module is specifically configured to:
when a plurality of target agent fee calculation rules are searched in the agent fee database for the corresponding ticket price information of the target ticket, selecting a target agent fee calculation rule with the highest priority from the plurality of target agent fee calculation rules; and determining agent fee information corresponding to the air ticket price information based on the target agent fee calculation rule with the highest priority.
10. A data processing system, characterized in that the system comprises:
the air ticket freight rate management component is used for managing the air ticket freight rate related information set by an airline company;
the air ticket freight rate calculation rule is used for representing the corresponding relation between the related air ticket information and the air ticket price information;
the agent fee database is used for storing agent fee calculation rules set by an airline company, and the agent fee calculation rules are used for representing the corresponding relation among air ticket price information, related air ticket information and agent fee information;
an air ticket fare calculation component for performing the data processing method of any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210726413.2A CN115099856A (en) | 2022-06-24 | 2022-06-24 | Data processing method, device and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210726413.2A CN115099856A (en) | 2022-06-24 | 2022-06-24 | Data processing method, device and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115099856A true CN115099856A (en) | 2022-09-23 |
Family
ID=83292846
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210726413.2A Pending CN115099856A (en) | 2022-06-24 | 2022-06-24 | Data processing method, device and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115099856A (en) |
-
2022
- 2022-06-24 CN CN202210726413.2A patent/CN115099856A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6959287B2 (en) | Method and system for conducting a target audit in a high volume transaction environment | |
| US8214075B2 (en) | System and method for modelling a flight | |
| JP2004070612A (en) | Inventory control system, inventory control method, charging method in inventory control system, inventory control program and storage medium | |
| CN110930224B (en) | Code sharing freight rate publishing method and device for airline company | |
| CN103493076A (en) | Method and system for an improved reservation system optimizing repeated search requests | |
| CN111882386A (en) | Freight quotation method and device | |
| CN111784293A (en) | Freight rate secondary release system and method | |
| CN115099856A (en) | Data processing method, device and system | |
| JP2004139237A (en) | Name matching method, name matching system, accounting method and accounting system | |
| CN114331528A (en) | Accounting method and device, electronic equipment and computer storage medium | |
| CN110704702B (en) | Method and device for searching fallback rule | |
| JP4908412B2 (en) | Method and system for billing and matching for improved travel transactions | |
| US20180075497A1 (en) | Database management system | |
| CN111832999A (en) | Project enterprise management system | |
| CN110705734B (en) | Reservation service system, method and equipment for online lodging products | |
| EP2911103A1 (en) | Auditing system with increased accuracy | |
| CN116468466A (en) | Method and device for acquiring ticket selling price information, storage medium and electronic equipment | |
| KR102189658B1 (en) | Auditing system with historic sale deviation database | |
| US20150242960A1 (en) | Auditing system with increased accuracy | |
| US20120330742A1 (en) | System and method to combine redemption and converted commercial fares | |
| CN112365210A (en) | Method and device for determining available inventory of products | |
| CN116128599A (en) | Bill processing method and device, storage medium and electronic equipment | |
| CN115222398A (en) | Internal transaction data processing system and implementation method thereof | |
| CN113362002A (en) | Logistics charging information generation method and device, electronic equipment and storage medium | |
| JP2003303288A (en) | Method and system for cooperative sale of digital contents |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |