CN118170810A

CN118170810A - Method and device for generating associated report of aviation published freight rate and electronic equipment

Info

Publication number: CN118170810A
Application number: CN202410323460.1A
Authority: CN
Inventors: 李颖; 蒋晓莲; 陈丽君; 文雯; 李人杰; 刘杰; 杨程; 李柯
Original assignee: China Travelsky Technology Co Ltd
Current assignee: China Travelsky Technology Co Ltd
Priority date: 2024-03-20
Filing date: 2024-03-20
Publication date: 2024-06-11

Abstract

The application discloses a method, a device and electronic equipment for generating an associated report of aviation public freight rate, wherein the method comprises the following steps: responding to a first operation of a user in a report content selection interface of aviation publishing freight rate to generate an associated report generation request of the aviation publishing freight rate, wherein the associated report generation request comprises a query object and a query condition, if the query object is the publishing freight rate, the associated data of the publishing freight rate are queried in a plurality of aviation data tables of a database by using the query condition, the queried associated data are combined and put into a newly-built associated report of the aviation publishing freight rate, at least part of the associated data in the associated report is calculated to obtain the publishing freight rate, and the publishing freight rate is written into the associated report. According to the application, all the associated data can be automatically acquired at one time according to the query condition, the published freight rate is automatically calculated and written into the associated report, and the associated report of the aviation published freight rate is more rapid and convenient to acquire without repeated manual query and secondary summarization calculation.

Description

Method and device for generating associated report of aviation published freight rate and electronic equipment

Technical Field

The application relates to the field of domestic freight rate release, in particular to a method and a device for generating an associated report of aviation freight rate release and electronic equipment.

Background

The aviation public freight rate multi-content report is a summary report containing various data related to the public freight rate, and an airline company can know the overall situation of the public freight rate and the overall information of the data related to the public freight rate through the table, can timely adjust the subsequent public freight rate amount through the table, and can also be used as a reference for the policy management department to analyze the data.

At present, an airline company can inquire the published freight rate information of the airlines or other information related to the published freight rates for many times by manpower, and then summarize and calculate the information of the airlines so as to obtain an aviation published freight rate multi-content report.

Therefore, the aviation publishing freight rate multi-content report cannot be obtained in time currently.

Disclosure of Invention

In view of the above, the application provides a method, a device and electronic equipment for generating an associated report of aviation public freight rate, which are used for solving the problem that an aviation public freight rate multi-content report cannot be obtained in time.

In order to achieve the above object, the following solutions have been proposed:

an associated report generation method for aviation publishing freight rate, the method comprising:

Responding to a first operation of a user in a report content selection interface of aviation publication freight rate to generate an associated report generation request of aviation publication freight rate, wherein the associated report generation request comprises a query object and a query condition;

If the query object is the published freight rate, the query condition is used for querying the associated data of the published freight rate in a plurality of aviation data tables of a database, and the queried associated data are combined and put into a newly built associated report of aviation published freight rate;

And calculating at least part of the associated data in the associated report, obtaining the published freight rate, and writing the published freight rate into the associated report.

The application discloses a method and a device for generating an associated report of an aviation public freight rate and electronic equipment. The method can output the data required by the user at one time according to the query object and the query condition in the associated report generation request of the user. Aiming at the related report with the query object being the published freight rate, all the related data can be automatically acquired at one time according to the query condition in the related report generation request, further, the published freight rate is automatically calculated according to the related data and written into the related report, and the related report of the aviation published freight rate is more rapid and convenient to acquire without manual repeated query information and secondary summarization calculation.

Drawings

In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings that are required to be used in the embodiments or the description of the prior art will be briefly described below, and it is obvious that the drawings in the following description are only embodiments of the present application, and that other drawings can be obtained according to the provided drawings without inventive effort for a person skilled in the art.

The above and other features, advantages, and aspects of embodiments of the present disclosure will become more apparent by reference to the following detailed description when taken in conjunction with the accompanying drawings. The same or similar reference numbers will be used throughout the drawings to refer to the same or like elements. It should be understood that the figures are schematic and that elements and components are not necessarily drawn to scale.

FIG. 1 is a flowchart of a method for generating an associated report of an aviation published freight rate provided by an embodiment of the application;

FIG. 2 is a schematic diagram of a report content selection interface according to an embodiment of the present application;

Fig. 3 is a schematic structural diagram of an associated report generating device for aviation publishing freight rate according to an embodiment of the present application;

Fig. 4 is a block diagram of a hardware structure of an electronic device according to an embodiment of the present application.

Detailed Description

The following description of the embodiments of the present application will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present application, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the application without making any inventive effort, are intended to be within the scope of the application.

The term "including" and variations thereof as used herein are intended to be open-ended, i.e., including, but not limited to. The term "based on" is based at least in part on. The term "one embodiment" means "at least one embodiment"; the term "another embodiment" means "at least one additional embodiment"; the term "some embodiments" means "at least some embodiments. Related definitions of other terms will be given in the description below.

It should be noted that the terms "first," "second," and the like in this disclosure are merely used to distinguish between different devices, modules, or units and are not used to define an order or interdependence of functions performed by the devices, modules, or units.

It should be noted that references to "one", "a plurality" and "a plurality" in this disclosure are intended to be illustrative rather than limiting, and those of ordinary skill in the art will appreciate that "one or more" is intended to be understood as "one or more" unless the context clearly indicates otherwise.

The current aviation publishing freight rate multi-content report obtaining process comprises the following steps:

The staff inquires each data of a specific route in the navigation right list, the route type list, the reference freight rate list, the normal freight rate list and the fuel tax list respectively, and integrates each data into a list according to the route. And selecting a corresponding air price calculation mode according to the type of the air route and the special air price, and respectively calculating the published air price of each air route to obtain a summary table with the published air price.

Therefore, the current aviation publishing freight rate multi-content report forms have more time cost due to multiple times of inquiry and secondary integration, and the aviation publishing freight rate report forms containing the multi-content cannot be obtained in time.

As shown in fig. 1, an embodiment of the present application provides a method for generating an associated report of an aviation published freight rate, where the method may include:

s10, generating an associated report generation request of the aviation public freight rate in response to a first operation of a user in a report content selection interface of the aviation public freight rate, wherein the associated report generation request comprises a query object and a query condition;

if the query object is a published freight rate, executing step S11;

S11, inquiring and publishing the related data of the freight rate in a plurality of aviation data tables of the database by using the inquiring condition, combining the inquired related data, and putting the combined data into a newly built related report of aviation freight rate;

S12, calculating at least part of the associated data in the associated report, obtaining a published freight rate, and writing the published freight rate into the associated report.

The embodiment of the application discloses a method for generating an associated report of aviation public freight rate. The method can output the data required by the user at one time according to the query object and the query condition in the associated report generation request of the user. Aiming at the related report with the query object of the published freight rate, all related data can be automatically acquired at one time only according to the query condition in the related report generation request, further, the published freight rate is automatically calculated according to the related data and written into the related report, and the related report of the aviation published freight rate is more rapid and convenient to acquire without manual repeated query information and secondary summarization calculation. In addition, the embodiment can write the space distance, the Chinese description of the origin and the Chinese description of the destination into the final associated report, so that the user can conveniently review.

The report content selection interface shown in fig. 2 may include eight parts, namely date, service level and cabin level, designated route, non-designated route, airline, export result selection, confirm export and close. Wherein the date includes a start sales date and a forbidden sales date; the service class and the bunk include the service class (first class, business and economy) and the designated bunk; designating an airline to include an origin and a destination; unspecified routes include route categories (travel, single flight, release and supervision), specific range intervals and price ranges (with reference freight rates, with special freight rates and specific price intervals); the airlines comprise three parts including report (code, description and selection), all selected and all cancelled, wherein the code is IATA two-word code of the airlines, such as 3U, and the description is Chinese description of the airlines, such as A airlines; the derived result selection comprises fuel additional charge, freight rate, aviation right, route category and aviation distance, wherein the fuel additional charge, freight rate and aviation right are main three business reports, the route category and aviation distance are used as auxiliary information, and a user selects whether to write in the final associated report; after the user clicks to confirm and export, the application can generate a related report generation request and finally output a report; after the user clicks to close, the report content selection interface is closed. The first operation of the user is an operation performed by the user on the report content selection interface, and optionally, the first operation may be a click operation or a sliding operation. The query object is a report object which needs to be queried by a user, and optionally, the query object obtained by the query can be output in the form of a report. Specifically, the output may be a single report, such as a right-of-way list or a fuel additional fee list, or may be a combination of multiple reports, such as a right-of-way list and a fuel additional list, and a published freight rate list and a fuel additional list.

The query condition is a condition for screening report contents, and a user selects the report contents according to the requirements of the user on a report contents selection interface. The query criteria may include at least one of an airline screening criteria, a date screening criteria, a service level screening criteria, a booking cabin screening criteria, and a price range screening criteria. The user can select the query object and the query condition according to the own requirement, the system automatically obtains the report after content integration according to the query object and the query condition, and the report is more quickly obtained without manually and repeatedly querying the data for reintegration. The user may perform a first operation in the report content selection interface as shown in fig. 2 to generate a query object and a query condition in the associated report generation request. For example, the user selects a start sales date of 20220520 in the date section, a forbidden sales date of 20220819 (the date can be directly input for the date selection or can be directly selected in the drop-down menu), selects a designated route, selects an origin city of a, a destination city of B (the place can be directly input for the place selection or can be directly selected in the drop-down menu), and derives a result to select a freight rate and an distance, and selects "confirm export". At this time, the system generates a related report generation request, wherein the query conditions include a date screening condition (20220520, 20220819), an air route screening condition (city a, city B), the query object is a freight rate, and the air distance information is additionally selected and put into the final related report. The user can finally obtain a freight rate report meeting the date and the route and attached with the range information.

Further, when the query object is a published freight rate, various data associated with the published freight rate are acquired from a plurality of aviation data tables of the database by using the query condition. The public freight rate is an air ticket sales type, and refers to a domestic airline passenger direct fare issued to the public after the civil aviation office is declared and documented, and the public freight rate can comprise a reference freight rate table, a special freight rate table and a normal freight rate table. The aviation data table is a table for recording relevant aviation data, and in this embodiment, the aviation data table may include at least one of an aviation weight table, an aviation route type table, a reference freight rate table, a special freight rate table, a normal freight rate table and a fuel tax table. The air right, the air route, the reference freight rate, the special freight rate, the normal freight rate and the fuel tax are all of an air ticket sales service type. The right of flight indicates that the airline has the right to fly the route; the reference freight rate is a price uniformly formulated by a management department, has a certain guiding significance, but cannot be actually sold; the special freight rate is a published freight rate issued by an airline company and has a discounted price, and the special freight rate is an actual selling price; the normal freight rate is the full price of the economy class, and the fuel tax can also be called fuel additional charge, which refers to the additional charge of fuel which is collected by the airlines to passengers according to the specified tax rate. The associated data is data which is acquired from a plurality of aviation data tables and is associated with the published freight rate, and the associated data can comprise aviation right, an air route, a reference freight rate, a special freight rate, a normal freight rate and fuel additional fees. The combination of the associated data can be to split the plurality of groups of associated data according to the common identification pair of the plurality of groups of data to obtain at least one piece of data corresponding to the common identification, and the common identification can be the data common to the plurality of groups of aviation data, such as the route and the date, and can also be the identification of the plurality of groups of aviation data. For example, if the common identifier is a route, multiple sets of data of the same route are obtained from multiple sets of associated data to form a piece of data corresponding to the route. In this embodiment, the published freight rate can be automatically calculated by using part of data of the associated data, and the part of associated data can include the route, the reference freight rate, the special freight rate and the normal freight rate, and the calculated published freight rate is automatically written into the newly-built associated report of the aviation published freight rate, so that manual secondary calculation and integration are not needed, and the method is more convenient and quick.

The above-described flowchart in fig. 1 illustrates the functions and operations that may be implemented by the methods according to embodiments of the present disclosure. In this regard, each block in the flowchart may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that in some alternative implementations, the functions noted in the block may occur out of the order noted in FIG. 1. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the flowchart, and combinations of blocks in the flowchart, can be implemented by special purpose hardware-based systems which perform the specified functions or operations, or combinations of special purpose hardware and computer instructions.

In another method for generating an associated report of an aviation published freight rate according to an embodiment of the present application, an aviation data table includes an airline type table, a reference freight rate table, a special freight rate table and a normal freight rate table, and in step S11 shown in fig. 1, querying associated data of published freight rates in a plurality of aviation data tables of a database using a query condition may include a first step and a second step;

step one: inquiring route data which meets the inquiry conditions and is associated with the published freight rate in a route type table;

Step two: and inquiring the freight rate data which meet the inquiry conditions and are associated with the published freight rate in the reference freight rate table, the special freight rate table and the normal freight rate table.

The query condition may include an airline screening condition, and the airline type table may include three types of aviation data including an origin, a destination and an airline type, so that the airline data of the target airline in the query condition may be obtained from the airline type table. For example, there are A, B, C and D pieces of route data in the route type table, each piece of route data includes an origin, a destination and a route type, the route screening condition in the query condition indicates that the route with the origin being a and the destination being b is required, and by querying in the route type table that the origin of the route a is a and the destination is b, the data of the route a including the origin, the destination and the route type of the route a is extracted from the route type table. Five aviation data of an origin, a destination, an effective date, an expiration date and an freight rate amount can be included in the reference freight rate table, and twelve aviation data of an airline company, an origin, a destination, a freight rate foundation, a cabin code, a range category, a rule number, a travel effective date, a travel expiration date, a sales effective date, a sales expiration date and an freight rate amount can be included in the special freight rate table; twelve aviation data may be included in the normal freight rate table, including an airline, origin, destination, freight rate base, bilge code, course category, rule number, travel validation date, travel expiration date, sales validation date, sales expiration date, and freight rate amount. In the embodiment, when the freight rate data is queried, the reference freight rate, the special freight rate and the normal freight rate of the same route can be queried and obtained in three aviation data tables through route screening conditions. And if the corresponding standard freight rate, special freight rate or normal freight rate does not exist, the corresponding freight rate is determined to be empty, and the corresponding cell content in the associated report of the subsequent newly-built aviation published freight rate is empty.

In another related report generation method of aviation published freight rates provided by the embodiment of the application, related data includes an airline type, a reference freight rate, a special freight rate and a normal freight rate, and step S12 shown in fig. 1 may include steps three to five:

Step three: determining a calculation mode of the published freight rate of the related data according to the route type of the related data and the special freight rate of the related data;

step four: acquiring a published freight rate of the related data based on the reference freight rate of the related data, the special freight rate of the related data, the normal freight rate of the related data and the calculation mode;

step five: and writing the published freight rate into an associated report.

The published freight rate can be obtained through real-time calculation of reference freight rate, special freight rate and normal freight rate. Since the calculation modes of the published freight rates corresponding to different route types are different and the storage mode of the special freight rates in the database also affects the calculation mode of the published freight rates, the calculation mode of the published freight rates of the related data needs to be determined according to the route type of the related data and the storage mode of the special freight rates, and of course, other route data can be processed in the same way. In the calculation process of the published freight rate of the present embodiment, the special freight rate and the normal freight rate may be used to calculate the published freight rate, and the reference freight rate may be used to limit the published freight rate. According to the embodiment, the published freight rate can be automatically calculated and written into the last associated report, so that the method is faster, and the published freight rate does not need to be manually calculated for the second time after data are tidied. Of course, in the final associated report of this embodiment, the reference freight rate, the special freight rate and the normal freight rate may be deleted or reserved according to the needs of the user.

According to another method for generating an associated report of an aviation published freight rate provided by the embodiment of the application, the type of an air route of an associated data is divided into an unreleased air route and a unreleased air route, and the data storage form of a special freight rate of the associated data is divided into a number form and a discount form, and the third step specifically comprises the following steps:

if the route type is the released route and the data storage form of the special freight rate is the discount form, the calculation mode of the published freight rate is as follows: multiplying the discount with the normal freight rate to obtain a published freight rate;

If the route type is the released route and the data storage form of the special freight rate is the number form, the calculation mode of the published freight rate is as follows: determining the special freight rate as a published freight rate;

If the route type is a non-released route and the data storage form of the special freight rate is a discount form, the calculation mode of the published freight rate is as follows: multiplying the discount with the normal freight rate and judging whether the multiplied result is not more than the preset percentage of the reference freight rate, if so, determining the multiplied result as the published freight rate;

If the route type is a non-released route and the data storage form of the special freight rate is a digital form, the calculation mode of the published freight rate is as follows: judging whether the special freight rate is not greater than the preset percentage of the reference freight rate, if so, determining the special freight rate as the published freight rate.

The main difference between the types of the airlines is that the special freight rate of the non-released airlines is limited by the reference freight rate, and optionally, the special freight rate is not more than 125% of the reference freight rate, and the special freight rate of the released airlines is not limited by the reference freight rate. The data storage form of the special freight rate can be directly connected with the calculation of the published freight rate, different data storage forms can correspond to different calculation modes, and in particular, when the data storage form of the special freight rate is an amount form, the published freight rate is the special freight rate; when the data storage form of the special freight rate is a discount form, the published freight rate=special freight rate=discount×normal freight rate, the discount is represented in the report form as a number, for example, the discount is represented as 90 in the report unit, and the discount is represented as 90%. Further, when the data storage form of the special freight rate is a discount form, the special freight rate can be calculated according to the voyage type of the special freight rate. Specifically, when the voyage category of the special freight rate is [ OW, double RT ] =0/[ OW ] =1, then the freight rate is published=special freight rate=discount×normal freight rate (rounded to ten bits); when the voyage category of special freight rate [ RT ], then freight rate = special freight rate = discount x normal freight rate (round to ten and multiply the result by two times). Where [ OW ] indicates that the price is applicable only to one pass, [ OW ], double RT ] indicates that the price is applicable to one pass, and if multiplied by twice, to the coming and going backhauls, [ RT ] indicates that the price is applicable to the coming and going backhauls, and not to the one pass.

In another method for generating an associated report of aviation published freight rate provided by the embodiment of the application, the method further comprises the following steps:

if the query object is fuel additional charge, querying a fuel tax table in a database, obtaining at least part of fuel data meeting the query condition from the fuel tax table, and forming a new fuel additional charge report by using at least part of fuel data, wherein the fuel data comprises an airline company, an origin, a destination, a sales effective date, a sales expiration date and a fuel amount;

And acquiring the space distance, the Chinese description of the origin and the Chinese description of the destination from the database and writing in a newly built fuel additional charge report.

The fuel tax form may include, among other things, an airline, origin, destination, date of effective sales, date of expiration sales, and fuel amount. According to the embodiment, a part of fuel data can be obtained from the fuel tax table according to the query condition, and the part of fuel data meets the query condition. In the embodiment, the final newly-built fuel additional charge report is additionally added with the space distance, the Chinese description of the origin and the Chinese description of the destination, so that the user can conveniently review.

If the query object is the right of flight, querying a right of flight table in a database, obtaining at least part of right of flight data meeting the query condition from the right of flight table, and forming a new right of flight report by using at least part of right of flight data, wherein the right of flight data comprises an airline company, an origin, a destination, an effective date and an expiration date;

And acquiring the Chinese description of the origin and the Chinese description of the destination from the database and writing the Chinese description and the Chinese description into the newly built navigation right report.

The contents of the flight table may include, among other things, the airline, origin, destination, effective date, and expiration date. According to the embodiment, a part of the navigation right data can be obtained from the navigation right table according to the query condition, and the part of the navigation right data meets the query condition. In the embodiment, the Chinese description of the space distance and the origin and the Chinese description of the destination are additionally added in the final newly-built space right report, so that the user can conveniently review.

In another method for generating an associated report of aviation published freight rate provided by the embodiment of the application, the method can further comprise the following steps:

Judging the authority role of the user;

If the authority role of the user is the user of the airline company, determining that the user has the authority for acquiring the data of the airline company;

if the authority role of the user is the management user, determining that the user has the authority for acquiring the data of all airlines.

The authority of the user is default in the system, the system can determine the authority of the user according to the unique identification of the user or determine the report form according to the roles in the database to perform authority control, and optionally, the unique identification can be a login account of the user in the system. For the airline company user, the data of the user can be queried in the system, and the data of other airline companies are not authorized to be acquired; for management users, the data of all airlines can be queried in the system, and in particular, the airlines which want to be checked can be selected according to a total selection report (each line in the report is a standard airlines IATA two-word code and an airlines specific description) provided by the system.

It should be understood that the various steps recited in the method embodiments of the present disclosure may be performed in a different order and/or performed in parallel. Furthermore, method embodiments may include additional steps and/or omit performing the illustrated steps. The scope of the present disclosure is not limited in this respect.

Computer program code for carrying out operations of the present disclosure may be written in one or more programming languages, including, but not limited to, an object oriented programming language such as Java, smalltalk, C ++ and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computer (for example, through the Internet using an Internet service provider).

Corresponding to the method for generating the associated report of the aviation publishing freight rate provided by the embodiment of the application, the embodiment of the application also provides a device for generating the associated report of the aviation publishing freight rate.

The embodiment of the application provides a device for generating an associated report of aviation publishing freight rate, which can comprise the following steps as shown in fig. 3:

a request obtaining unit 100, configured to generate an associated report generation request of the aviation published freight rate in response to a first operation of a user in a report content selection interface of the aviation published freight rate, where the associated report generation request includes a query object and a query condition;

If the query object is a published freight rate, triggering the associated data processing unit 110;

The associated data processing unit 110 is configured to query a plurality of aviation data tables of the database for associated data of published freight rates using a query condition, and combine the queried associated data to place the combined data into a newly built associated report of aviation published freight rates;

And the freight rate calculation unit 120 is configured to calculate at least part of the associated data in the associated report, obtain a published freight rate, and write the published freight rate into the associated report.

In another related report generating device for aviation public freight rate provided by the embodiment of the application, the query condition in the request obtaining unit 100 comprises at least one of an airline screening condition, a date screening condition, a service level screening condition, a seat reservation screening condition and a price range screening condition;

And/or the number of the groups of groups,

The aviation data table comprises at least one of an aviation weight table, an air route type table, a reference freight rate table, a special freight rate table, a normal freight rate table and a fuel tax table.

In another related report generating device for aviation published freight rate provided in accordance with an embodiment of the present application, the aviation data table includes an airline type table, a reference freight rate table, a special freight rate table and a normal freight rate table, and the related data processing unit 110 uses a query condition to query related data of published freight rates in a plurality of aviation data tables in a database, and may include:

the route data query subunit is used for querying route data which meet the query conditions and are associated with the published freight rate in the route type table;

And the freight rate data query subunit is used for querying freight rate data which meets the query conditions and is associated with the published freight rate in the reference freight rate table, the special freight rate table and the normal freight rate table.

In another related report generating device for aviation published freight rate provided according to an embodiment of the present application, related data includes an airline type, a reference freight rate, a special freight rate and a normal freight rate, and the freight rate calculating unit 120 may include:

The calculating mode determining subunit is used for determining the calculating mode of the published freight rate of the related data through the route type of the related data and the special freight rate of the related data;

The published freight rate determining subunit is used for obtaining the published freight rate of one piece of associated data based on the reference freight rate of the one piece of associated data, the special freight rate of the one piece of associated data, the normal freight rate of the one piece of associated data and the calculation mode;

and the freight rate data writing subunit is used for writing the published freight rate into the associated report.

In another related report generating device for aviation published freight rates provided by the embodiment of the application, the route type of a piece of related data is divided into a released route and a non-released route, the data storage form of a special freight rate of a piece of related data is divided into a number form and a discount form, and the calculating mode determining subunit can be specifically configured to:

The other related report generating device for aviation publishing freight rate provided by the embodiment of the application further comprises:

If the query object is fuel additional charge, triggering a fuel tax query subunit;

The fuel tax inquiring subunit is used for inquiring the fuel tax table in the database, obtaining at least part of fuel data meeting the inquiring conditions from the fuel tax table, and forming a newly-built fuel additional fee report by using at least part of fuel data, wherein the fuel data comprises an airline company, an origin, a destination, a sales effective date, a sales expiration date and a fuel amount;

And the fuel data writing subunit is used for acquiring the space distance, the Chinese description of the origin and the Chinese description of the destination from the database and writing in a newly built fuel additional charge report.

If the query object is the navigation right, triggering a navigation right query subunit;

The navigation right inquiring subunit is used for inquiring the navigation right table in the database, obtaining at least part of navigation right data meeting the inquiring condition from the navigation right table, and forming a new navigation right report by using at least part of navigation right data, wherein the navigation right data comprises an airline company, an origin, a destination, an effective date and an expiration date;

and the navigation right data writing subunit is used for acquiring the Chinese description of the origin and the Chinese description of the destination from the database and writing the Chinese description into the newly-built navigation right report.

In another related report generating device for aviation publishing freight rate provided by the embodiment of the application, the device may further include:

the permission judging subunit is used for judging the permission roles of the users;

if the authority role of the user is the airline company user, triggering an airline company user authority determination subunit; if the authority role of the user is the management user, triggering the management user authority determining subunit;

an airline subscriber permission determination subunit, configured to determine that a subscriber has permission to acquire data of the present airline company;

And the management user permission determination subunit is used for determining that the user has permission to acquire the data of all airlines.

The functions described above herein may be performed, at least in part, by one or more hardware logic components. For example, without limitation, exemplary types of hardware logic components that may be used include: a Field Programmable Gate Array (FPGA), an Application Specific Integrated Circuit (ASIC), an Application Specific Standard Product (ASSP), a system on a chip (SOC), a Complex Programmable Logic Device (CPLD), and the like.

The device for generating the associated report of the aviation public freight rate provided by the embodiment of the application can be applied to associated report generating equipment of the aviation public freight rate. Fig. 4 shows a hardware block diagram of an associated report generating device 600 of an aviation public transport price, which in embodiments of the present disclosure may include, but is not limited to, mobile terminals such as mobile phones, notebook computers, digital broadcast receivers, PDAs (personal digital assistants), PADs (tablet computers), PMPs (portable multimedia players), vehicle-mounted terminals (e.g., car navigation terminals), and the like, and fixed terminals such as digital TVs, desktop computers, and the like. The associated report generating device of the aviation published freight rate shown in fig. 4 is only one example and should not impose any limitation on the functionality and scope of use of the embodiments of the present disclosure.

As shown in fig. 4, the associated report generating device 600 of the aviation publication freight rate may include a processing means (e.g., a central processor, a graphic processor, etc.) 601, which may perform various appropriate actions and processes according to a program stored in a Read Only Memory (ROM) 602 or a program loaded from a storage means 606 into a Random Access Memory (RAM) 603. In the RAM 603, various programs and data required for the operation of the associated report generating apparatus 600 of the aviation publication freight rate are also stored. The processing device 601, the ROM 602, and the RAM 603 are connected to each other through a bus 604. An input/output (I/O) interface 605 is also connected to bus 604.

In general, the following devices may be connected to the I/O interface 605: input devices 606 including, for example, a touch screen, touchpad, keyboard, mouse, camera, microphone, accelerometer, gyroscope, and the like; an output device 607 including, for example, a Liquid Crystal Display (LCD), a speaker, a vibrator, and the like; storage 608 including, for example, magnetic tape, hard disk, etc.; and a communication device 609. The communication means 609 may allow the associated report generating device 600 of the airliner publication freight rate to communicate with other devices wirelessly or by wire to exchange data. While FIG. 4 illustrates an associated report generating device 600 having an aeronautical published freight rate of various devices, it should be understood that not all illustrated devices are required to be implemented or provided. More or fewer devices may be implemented or provided instead.

The embodiment of the application also provides a computer readable medium carrying one or more programs which, when executed by the related report generating device of aviation publication freight rate, cause the related report generating device of aviation publication freight rate to: responding to a first operation of a user in a report content selection interface of aviation publishing freight rate to generate an associated report generation request of the aviation publishing freight rate, wherein the associated report generation request comprises a query object and a query condition, if the query object is the publishing freight rate, the query condition is used for querying associated data of the publishing freight rate in a plurality of aviation data tables of a database, the queried associated data are combined and put into an associated report of new aviation publishing freight rate, at least part of the associated data in the associated report are calculated to obtain the publishing freight rate, and the publishing freight rate is written into the associated report.

It should be noted that the computer readable medium described in the present disclosure may be a computer readable signal medium or a computer readable storage medium, or any combination of the two. The computer readable storage medium can be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or a combination of any of the foregoing. More specific examples of the computer-readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this disclosure, a computer-readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In the present disclosure, however, the computer-readable signal medium may include a data signal propagated in baseband or as part of a carrier wave, with the computer-readable program code embodied therein. Such a propagated data signal may take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination of the foregoing. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: electrical wires, fiber optic cables, RF (radio frequency), and the like, or any suitable combination of the foregoing.

The computer readable medium may be contained in the associated report generating device of the aviation published freight rate; or may exist alone without being assembled into the associated report generating device of the aviation published freight rate.

In particular, according to embodiments of the present disclosure, the processes described in the associated report generation method embodiments of the aviation published freight rates above may be implemented as computer software programs. For example, embodiments of the present disclosure include a computer program product comprising a computer program embodied on a non-transitory computer readable medium, the computer program containing program code for performing the associated report generation method of the above aeronautical published freight rates. In such an embodiment, the computer program may be downloaded and installed from a network via communication means 609 in fig. 4, or from storage means 608, or from ROM 602. When executed by the processing device 601, performs the functions defined above in the associated report generation method of aviation publication freight rates of the embodiments of the present disclosure.

According to one or more embodiments of the present disclosure, example 1 provides a method for generating an associated report of an aviation published freight rate, including:

According to one or more embodiments of the present disclosure, example 2 provides the method of example 1, wherein the query criteria includes at least one of an airline screening criteria, a date screening criteria, a service level screening criteria, a booking class screening criteria, a price range screening criteria;

And/or the number of the groups of groups,

The aviation data table comprises at least one of an aviation right table, an air route type table, a reference freight rate table, a special freight rate table, a normal freight rate table and a fuel tax table.

According to one or more embodiments of the present disclosure, the aviation data sheet includes an airline type sheet, a reference freight rate sheet, a special freight rate sheet, and a normal freight rate sheet, and example 3 provides the method of example 1,

The querying, using the query condition, the association data of the published freight rate in a plurality of aviation data tables of a database, including:

inquiring route data which meets the inquiry conditions and is associated with the published freight rate in the route type table;

And inquiring the freight rate data which meets the inquiry conditions and is associated with the published freight rate in the reference freight rate table, the special freight rate table and the normal freight rate table.

In accordance with one or more embodiments of the present disclosure, the associated data includes an airline type, a reference freight rate, a special freight rate, and a normal freight rate, example 4 provides the method of example 1,

Calculating at least part of the associated data in the associated report to obtain the published freight rate, and writing the published freight rate into the associated report, wherein the calculating comprises the following steps:

Determining a calculation mode of the published freight rate of one piece of associated data according to the route type of the one piece of associated data and the special freight rate of the one piece of associated data;

Acquiring a published freight rate of the piece of associated data based on the reference freight rate of the piece of associated data, the special freight rate of the piece of associated data, the normal freight rate of the piece of associated data and the calculation mode;

And writing the published freight rate into the associated report.

According to one or more embodiments of the present disclosure, the route type of the one piece of associated data is divided into a released route and a non-released route, the data storage form of the special freight rate of the one piece of associated data is divided into a number form and a discount form, and in the method of example 4,

The calculating method for determining the published freight rate of one piece of associated data through the route type of the one piece of associated data and the special freight rate of the one piece of associated data comprises the following steps:

If the route type is a released route and the data storage form of the special freight rate is a discount form, the calculation mode of the published freight rate is as follows: multiplying a discount by the normal freight rate to obtain the published freight rate;

If the route type is a released route and the data storage form of the special freight rate is a number form, the calculation mode of the published freight rate is as follows: determining the special freight rate as the published freight rate;

If the route type is a non-release route and the data storage form of the special freight rate is a discount form, the calculation mode of the published freight rate is as follows: multiplying the discount with the normal freight rate and judging whether the multiplied result is not more than the preset percentage of the reference freight rate, if so, determining the multiplied result as the published freight rate;

If the route type is a non-release route and the data storage form of the special freight rate is a number form, the calculation mode of the published freight rate is as follows: judging whether the special freight rate is not larger than the preset percentage of the reference freight rate, if so, determining the special freight rate as the published freight rate.

In accordance with one or more embodiments of the present disclosure, example 6 provides the method of example 1, further comprising:

If the query object is fuel additional charge, querying a fuel tax table in the database, obtaining at least part of fuel data meeting the query condition from the fuel tax table, and using the at least part of fuel data to form a newly-built fuel additional charge report, wherein the fuel data comprises an airline company, an origin, a destination, a sales effective date, a sales expiration date and a fuel amount;

and acquiring the space distance, the Chinese description of the origin and the Chinese description of the destination from the database, and writing the new fuel additional charge report.

In accordance with one or more embodiments of the present disclosure, example 7 provides the method of example 1, further comprising:

If the query object is the navigation right, querying a navigation right table in the database, obtaining at least part of navigation right data meeting the query condition from the navigation right table, and using the at least part of navigation right data to form a new navigation right report, wherein the navigation right data comprises an airline company, an origin, a destination, an effective date and an expiration date;

And acquiring the Chinese description of the origin and the Chinese description of the destination from the database and writing the Chinese description of the origin and the Chinese description of the destination into the newly-built navigation right report.

In accordance with one or more embodiments of the present disclosure, example 8 provides the method of example 1, further comprising:

Judging the authority role of the user;

if the authority role of the user is an airline company user, determining that the user has the authority for acquiring the data of the airline company;

And if the authority role of the user is the management user, determining that the user has the authority for acquiring the data of all airlines.

According to one or more embodiments of the present disclosure, example 9 provides an associated report generating apparatus for aviation publication freight rate, including:

the request acquisition unit is used for responding to a first operation of a user in a report content selection interface of the aviation publication freight rate to generate an associated report generation request of the aviation publication freight rate, wherein the associated report generation request comprises a query object and a query condition;

If the query object is a published freight rate, triggering an associated data processing unit;

the associated data processing unit is used for inquiring the associated data of the published freight rate in a plurality of aviation data tables of the database by using the inquiry conditions, combining the inquired associated data and putting the combined associated data into a newly-built aviation published freight rate associated report;

And the freight rate calculation unit is used for calculating at least part of the associated data in the associated report, obtaining the published freight rate and writing the published freight rate into the associated report.

According to one or more embodiments of the present disclosure, example 10 provides an electronic device including a memory for storing a program and a processor for executing the program to implement the steps of the associated report generation method of aviation publication freight rates as in any of the examples above.

Although the subject matter has been described in language specific to structural features and/or methodological acts, it is to be understood that the subject matter defined in the appended claims is not necessarily limited to the specific features or acts described above. Rather, the specific features and acts described above are example forms of implementing the claims.

While several specific implementation details are included in the above discussion, these should not be construed as limiting the scope of the disclosure. Certain features that are described in the context of separate embodiments can also be implemented in combination in a single embodiment. Conversely, various features that are described in the context of a single embodiment can also be implemented in multiple embodiments separately or in any suitable subcombination.

The foregoing description is only of the preferred embodiments of the present disclosure and description of the principles of the technology being employed. It will be appreciated by persons skilled in the art that the scope of the disclosure referred to in this disclosure is not limited to the specific combinations of features described above, but also covers other embodiments which may be formed by any combination of features described above or equivalents thereof without departing from the spirit of the disclosure. Such as those described above, are mutually substituted with the technical features having similar functions disclosed in the present disclosure (but not limited thereto).

Claims

1. An associated report generation method for aviation publicizing freight rate is characterized by comprising the following steps:

2. The method of claim 1, wherein the query criteria comprises at least one of an airline screening criteria, a date screening criteria, a service level screening criteria, a booking class screening criteria, a price range screening criteria;

And/or the number of the groups of groups,

3. The method of claim 1, wherein the aviation data table comprises an airline type table, a reference freight rate table, a special freight rate table, and a normal freight rate table, wherein using the query condition to query a plurality of aviation data tables of a database for associated data of the published freight rate comprises:

4. The method of claim 1, wherein the associated data includes a route type, a reference freight rate, a special freight rate, and a normal freight rate, wherein the calculating at least a portion of the associated data in the associated report to obtain the published freight rate, and writing the published freight rate into the associated report comprises:

And writing the published freight rate into the associated report.

5. The method of claim 4, wherein the route type of the one piece of associated data is divided into a released route and a non-released route, the data storage form of the special freight rate of the one piece of associated data is divided into a number form and a discount form, and the calculating manner of determining the published freight rate of the one piece of associated data by the route type of the one piece of associated data and the special freight rate of the one piece of associated data includes:

If the route type is the released route and the data storage form of the special freight rate is the discount form, the calculation mode of the published freight rate is as follows: multiplying a discount by the normal freight rate to obtain the published freight rate;

If the route type is the released route and the data storage form of the special freight rate is the amount form, the calculation mode of the published freight rate is as follows: determining the special freight rate as the published freight rate;

If the route type is the non-release route and the data storage form of the special freight rate is the discount form, the calculation mode of the published freight rate is as follows: multiplying the discount with the normal freight rate and judging whether the multiplied result is not more than the preset percentage of the reference freight rate, if so, determining the multiplied result as the published freight rate;

If the route type is the non-release route and the data storage form of the special freight rate is the amount form, the calculation mode of the published freight rate is as follows: judging whether the special freight rate is not larger than the preset percentage of the reference freight rate, if so, determining the special freight rate as the published freight rate.

6. The method as recited in claim 1, further comprising:

7. The method as recited in claim 1, further comprising:

8. The method according to claim 1, wherein the method further comprises:

Judging the authority role of the user;

9. An associated report generation device for aviation publicizing freight rate, which is characterized by comprising:

10. An electronic device comprising a memory and a processor;

The memory is used for storing programs;

the processor is configured to execute the program to implement the steps of the method for generating an associated report of an aviation published freight rate according to any of claims 1-8.