Data query method and device, storage medium and electronic equipment

Abstract

The invention discloses a data query method and device, a storage medium and electronic equipment, the method is applied to the technical field of aviation, and the method comprises the following steps: receiving a query request; performing permission verification on the query request to obtain a first verification result; when the first verification result is that verification is passed, querying in a target database according to a query condition to obtain first order data; and filtering the first order data according to the airline information to obtain target order data, and displaying the target order data in the target device. According to the method and the device, the problem that other systems asynchronous with the airline data cannot query the order data of the passengers in the airline in the related technology is solved.

Description

Technical Field

[0001] The present application relates to the field of aviation technology, and in particular to a data query method, device, storage medium and electronic device. Background Art

[0002] Civil aviation passenger order data (Passenger Name Record, hereinafter referred to as PNR data) is the core data of the civil aviation information system and the basis of civil aviation business operations. In the civil aviation passenger reservation system, passenger reservation records will exist in the form of PNR. Each PNR corresponds to a unique six-digit code. Airline sales personnel and airline agent sales personnel can index the PNR record through the PNR code and view the detailed passenger sales information in the record (for example, name, itinerary, contact information and operation history, etc.). Civil aviation passenger agent order data (hereinafter referred to as CRS PNR data) is the PNR data in the civil aviation passenger reservation system by airlines through agents.

[0003] In the prior art, the civil aviation global distribution system (GDS) provides foreign airlines (non-host airlines) with functions such as flight information and fare information, but does not allow foreign airlines to extract agent booking record information from the civil aviation system, making it impossible for passengers to view their booking information after booking a trip or purchasing other service products with foreign airlines, reducing the convenience of passengers in querying information. If the query function is directly opened to foreign airlines, it may lead to the leakage of civil aviation data and reduce the security of civil aviation data.

[0004] With regard to the problem in the related art that other systems that are not synchronized with the airline data cannot query the order data of passengers in the airline, no effective solution has been proposed yet. Summary of the invention

[0005] The main purpose of the present application is to provide a data query method, device, storage medium and electronic device to solve the problem in the related art that other systems that are not synchronized with the airline data cannot query the order data of passengers in the airline.

[0006] In order to achieve the above-mentioned purpose, according to one aspect of the present application, a data query method is provided, the method comprising: receiving a query request, wherein the query request comprises at least: airline information, agent information, and query conditions, the airline information is the information of the airline initiating the query request, and the agent information is the information of the agent querying the data; performing an authority check on the query request to obtain a first check result; when the first check result is that the check passes, querying in a target database according to the query condition to obtain first order data, wherein the target database is a database determined according to the agent information; filtering the first order data according to the airline information to obtain target order data, and displaying the target order data in a target device.

[0007] Furthermore, the query request is subjected to an authority check to obtain a first check result, including: obtaining a configuration file, wherein the configuration file contains information of airlines with query authority; parsing the airline information, and matching the parsed airline identification information with the airline information in the configuration file to obtain a matching result; if the matching result is empty, creating a first prompt box, and displaying first preset information in the first prompt box; if the matching result is not empty, determining that the check has passed as the first check result.

[0008] Furthermore, the query request also includes: order identification information, querying in the target database according to the query conditions to obtain first order data, including: querying in the target database according to the order identification information to obtain second order data; if the second order data is empty, creating a second prompt box and displaying second preset information in the second prompt box; if the second order data is not empty, filtering the second order data according to the query conditions to obtain the first order data.

[0009] Furthermore, the first order data is filtered according to the airline information to obtain target order data, including: parsing each order data in the first order data; for each order data in the first order data, filtering order data in the order data that has no correlation with the airline information to obtain filtered order data; processing the filtered order data according to a preset arrangement order and a preset data format to obtain the target order data.

[0010] Further, when the matching result is not empty, determining the verification pass as the first verification result includes: when the matching result is not empty, parsing the query request to obtain each request content of the query request; performing format verification on each request content of the query request according to preset rules to obtain a second verification result; when the second verification result is a verification failure, creating a third prompt box and displaying third preset information in the third prompt box; when the second verification result is a verification pass, determining the verification pass as the first verification result.

[0011] Furthermore, the first order data includes at least one of the following: valid data and invalid data, wherein the valid data is order data that currently exists and is valid, and the invalid data is data that currently exists but has been canceled by the passenger.

[0012] Furthermore, the target order data includes at least one of the following: passenger information, agent information, flight segment information, service information, creation information, and the flight segment information includes flight segment information of at least one airline.

[0013] In order to achieve the above-mentioned purpose, according to another aspect of the present application, a data query device is provided, the device comprising: a receiving unit, used to receive a query request, wherein the query request at least comprises: airline information, agent information, and query conditions, the airline information is the information of the airline initiating the query request, and the agent information is the information of the agent querying the data; a verification unit, used to perform an authority verification on the query request to obtain a first verification result; a query unit, used to query in a target database according to the query condition to obtain first order data when the first verification result is a verification pass, wherein the target database is a database determined according to the agent information; a processing unit, used to filter the first order data according to the airline information to obtain target order data, and display the target order data in a target device.

[0014] Furthermore, the verification unit includes: an acquisition subunit, used to acquire a configuration file, wherein the configuration file contains airline information with query authority; a first parsing subunit, used to parse the airline information, and match the parsed airline identification information with the airline information in the configuration file to obtain a matching result; a first creation subunit, used to create a first prompt box and display first preset information in the first prompt box if the matching result is empty; and a determination subunit, used to determine the verification pass as the first verification result if the matching result is not empty.

[0015] Furthermore, the query request also includes: order identification information, and the query unit includes: a query subunit, used to query the target database according to the order identification information to obtain second order data; a second creation subunit, used to create a second prompt box if the second order data is empty, and display second preset information in the second prompt box; a first filtering subunit, used to filter the second order data according to the query condition to obtain the first order data if the second order data is not empty.

[0016] Furthermore, the query request also includes: order identification information, and the query unit includes: a query subunit, used to query the target database according to the order identification information to obtain second order data; a second creation subunit, used to create a second prompt box if the second order data is empty, and display second preset information in the second prompt box; a first filtering subunit, used to filter the second order data according to the query condition to obtain the first order data if the second order data is not empty.

[0017] Furthermore, the query request also includes: order identification information, and the query unit includes: a query subunit, used to query the target database according to the order identification information to obtain second order data; a second creation subunit, used to create a second prompt box if the second order data is empty, and display second preset information in the second prompt box; a first filtering subunit, used to filter the second order data according to the query condition to obtain the first order data if the second order data is not empty.

[0018] Furthermore, the determination subunit includes: a parsing module, which is used to parse the query request when the matching result is not empty, and obtain each request content of the query request; a verification module, which is used to perform format verification on each request content of the query request according to preset rules to obtain a second verification result; a creation module, which is used to create a third prompt box and display third preset information in the third prompt box when the second verification result is a verification failure; and a determination module, which is used to determine the verification pass as the first verification result when the second verification result is a verification pass.

[0019] Furthermore, the first order data includes at least one of the following: valid data and invalid data, wherein the valid data is order data that currently exists and is valid, and the invalid data is data that currently exists but has been canceled by the passenger.

[0020] Furthermore, the target order data includes at least one of the following: passenger information, agent information, flight segment information, service information, creation information, and the flight segment information includes flight segment information of at least one airline.

[0021] In order to achieve the above-mentioned purpose, according to one aspect of the present application, a computer program product is provided, including a computer program, which, when executed by a processor, implements the data query method described in any one of the above items, and which, when executed by a processor, implements the steps of the data query method described in each embodiment of the present application.

[0022] In order to achieve the above-mentioned purpose, according to one aspect of the present application, a computer-readable storage medium is provided, wherein the computer-readable storage medium includes stored computer instructions, wherein when the computer instructions are executed by a processor, any one of the above-mentioned data query methods is implemented.

[0023] In order to achieve the above-mentioned purpose, according to one aspect of the present application, an electronic device is provided, including one or more processors and a memory, the memory being used to store one or more programs, wherein when the one or more programs are executed by one or more processors, the one or more processors implement any of the data query methods described above.

[0024] Through this application, the following steps are adopted: receiving a query request, wherein the query request at least includes: airline information, agent information, and query conditions, wherein the airline information is the information of the airline that initiated the query request, and the agent information is the information of the agent that queries the data; performing authority verification on the query request to obtain a first verification result; when the first verification result is a verification pass, querying in the target database according to the query condition to obtain first order data, wherein the target database is a database determined according to the agent information; filtering the first order data according to the airline information to obtain target order data, and displaying the target order data in the target device, solving the problem that other systems that are not synchronized with the airline data in the related technology cannot query the order data of passengers in the airline. By establishing a new query instruction, it is possible to receive the query request of a foreign airline user, and perform authority verification on the query request of the foreign airline user, and obtain the query result corresponding to the query request when the verification passes, which can meet the needs of the foreign airline user to extract the passenger order data, improve the user's experience of using civil aviation functions or services, and at the same time, by filtering the query result data, it is possible to display the passenger order data related to the airline to the foreign airline user, avoid data leakage, and achieve the effect of improving the data security of civil aviation data. BRIEF DESCRIPTION OF THE DRAWINGS

[0025] The drawings constituting a part of the present application are used to provide a further understanding of the present application. The illustrative embodiments and descriptions of the present application are used to explain the present application and do not constitute an improper limitation on the present application. In the drawings:

[0026] Figure 1 is a flow chart of a method for querying data provided in Embodiment 1 of the present application;

[0027] Figure 2 This is a schematic diagram of an optional data query method provided in Example 1 of the present application. Figure 1 ;

[0028] Figure 3 This is a schematic diagram of an optional data query method provided in Example 1 of the present application. Figure 2 ;

[0029] Figure 4 This is a schematic diagram of an optional data query method provided in Example 1 of the present application. Figure 3 ;

[0030] Figure 5 is a schematic diagram of a data query device provided according to Embodiment 2 of the present application;

[0031] Figure 6 It is a schematic diagram of an electronic device for querying data provided in Embodiment 5 of the present application. DETAILED DESCRIPTION

[0032] It should be noted that, in the absence of conflict, the embodiments and features in the embodiments of the present application can be combined with each other. The present application will be described in detail below with reference to the accompanying drawings and in combination with the embodiments.

[0033] It should be noted that the user information (including but not limited to user device information, user personal information, collected data, used data, generated data, processed data, etc.) and data (including but not limited to data used for analysis, stored data, displayed data, collected information, used information, generated information, processed information, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties, and the collection, storage, use, processing, transmission, provision, disclosure and application of relevant data are in compliance with the relevant laws, regulations and standards of relevant countries and regions, necessary confidentiality measures are taken, and public order and good morals are not violated, and corresponding operation portals are provided for users to choose to authorize or refuse. For example, an interface is set between this system and relevant users or organizations. Before obtaining relevant information, it is necessary to send an acquisition request to the aforementioned user or organization through the interface, and obtain relevant information after receiving the consent information fed back by the aforementioned user or organization.

[0034] It should be noted that this application provides users with corresponding operation entrances for them to choose to agree or reject the automated decision-making results; if the user chooses to reject, the expert decision-making process will be entered.

[0035] In order to enable those skilled in the art to better understand the solution of the present application, the technical solution in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of the present application.

[0036] It should be noted that the terms "first", "second", etc. in the specification and claims of the present application and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequential order. It should be understood that the data used in this way can be interchanged where appropriate, so that the embodiments of the present application described here. In addition, the terms "including" and "having" and any of their variations are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device comprising a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0037] Embodiment 1

[0038] The present invention is described below in conjunction with preferred implementation steps. Figure 1 is a flow chart of a method for querying data provided in Embodiment 1 of the present application. Figure 1 As shown, the method comprises the following steps:

[0039] Step S101, receiving a query request, wherein the query request at least includes: airline information, agent information, and query conditions, the airline information is the information of the airline initiating the query request, and the agent information is the information of the agent querying the data.

[0040] The data query method provided in the first embodiment of the present application can be applied to the query system of civil aviation, which is used to query passenger order data. In order to solve the problem that the current civil aviation passenger query system cannot support foreign airlines to extract passenger order data booked by agents, the query system builds a new extraction channel for passenger order data booked by agents, creates a new virtual instruction, and realizes the function of foreign airlines to query passenger order data booked by agents.

[0041] In the first embodiment, the civil aviation data is accessed through the query instruction of the newly created query system (i.e., the query request mentioned above) to obtain the passenger order data of foreign airlines booked through agents, so that foreign airline users can query the complete passenger order data booked by agents.

[0042] The query request includes the airline information used by the foreign airline user when logging into the civil aviation query system, the agent information related to the foreign airline user's intended query data (that is, the above-mentioned agent information. It should be noted that in this embodiment 1, the agent information can also be related information of other channels for users to query data, which is not specifically limited in this embodiment 1) and query conditions and other information.

[0043] Step S102: perform authority verification on the query request to obtain a first verification result.

[0044] In the first embodiment, in order to improve the data security of civil aviation data, it is necessary to perform a rights check on the received query request to determine whether the airline company that queries the data in the query request has the authority to query the data. If the airline company corresponding to the airline company information in the query request does not have the authority to query the data, it is prohibited to return any data to the airline company; if the airline company corresponding to the airline company information in the query request has the authority to query the data, the query result corresponding to the query request is obtained from the civil aviation, and the query result is returned to the airline company.

[0045] Step S103, when the first verification result is verification passed, query is performed in the target database according to the query condition to obtain the first order data, wherein the target database is a database determined according to the agent information.

[0046] In the first embodiment of the present invention, in order to meet the query needs of foreign airline query data, it is necessary to query in the target database corresponding to the agent information after determining that the airline has the authority to query the data, and obtain complete passenger order data, that is, the first order data mentioned above, so as to determine the query results returned to the foreign airline user based on the first order data.

[0047] Step S104, filtering the first order data according to the airline information to obtain target order data, and displaying the target order data in the target device.

[0048] In the first embodiment of the present invention, in order to ensure the security of civil aviation data, it is necessary to filter the complete passenger order data according to the relevant information of the airline, screen the passenger order data that can be browsed or viewed by foreign airline users, that is, the above-mentioned target order data, and display the target order data on the screen of the civil aviation query system (that is, the above-mentioned target device) for foreign airline users to view.

[0049] Optionally, in the first embodiment, the process of a foreign airline user querying the passenger order data of civil aviation can be as follows: Figure 2 As shown, first, the foreign airline user logs in to the eterm terminal system (i.e., the above-mentioned civil aviation query system), enters the request instruction and related query conditions, i.e., the above-mentioned query request, and obtains the request information of the foreign airline user (e.g., Figure 2 ); then, the request information of the foreign airline user in the query request is subjected to permission verification and format verification; secondly, if the verification passes, the passenger order data (such as Figure 2 Finally, according to the authority of the foreign airline user, the order data that can be viewed within the authority of the foreign airline user is merged to obtain the above-mentioned target order data (such as Figure 2 ), and returns the target order data to the foreign airline user.

[0050] It should be noted that the passenger order data extracted by foreign airline users and the passenger order data booked by agents are only available for viewing by foreign airline users, and foreign airline users cannot modify or delete them. Foreign airline users can use the queried data to count the number of passengers who have booked their airline's flights, meal services, special passengers and other information, so as to provide targeted services to foreign airline users, improve passengers' flight experience, and help improve the convenience of civil aviation services. At the same time, the data query method provided in Example 1 of the present application fills the gap in civil aviation query system instructions and provides convenient instructions for foreign airline users, so that they can quickly extract information that foreign airline users are concerned about, and improve the satisfaction of other users using the civil aviation system.

[0051] In summary, the data query method provided in the first embodiment of the present application receives a query request, wherein the query request at least includes: airline information, agent information, query conditions, airline information is information of the airline that initiates the query request, and agent information is information of the agent that queries the data; performs permission verification on the query request to obtain a first verification result; when the first verification result is a verification pass, performs a query in the target database according to the query condition to obtain first order data, wherein the target database is a database determined according to the agent information; filters the first order data according to the airline information to obtain target order data, and displays the target order data in the target device, which solves the problem that other systems that are not synchronized with the airline data in the related technology cannot query the order data of passengers in the airline. By establishing a new query instruction, it is possible to receive the query request of a foreign airline user, and perform permission verification on the query request of the foreign airline user, and obtain the query result corresponding to the query request when the verification passes, which can meet the needs of the foreign airline user to extract the passenger order data, improve the user's experience of using civil aviation functions or services, and at the same time, by filtering the query result data, it is possible to display the passenger order data related to the airline to the foreign airline user, avoid data leakage, and achieve the effect of improving the data security of civil aviation data.

[0052] Optionally, in the data query method provided in Example 1 of the present application, a permission check is performed on the query request to obtain a first verification result, including: obtaining a configuration file, wherein the configuration file contains airline information with query permission; parsing the airline information, and matching the parsed airline identification information with the airline information in the configuration file to obtain a matching result; when the matching result is empty, creating a first prompt box, and displaying first preset information in the first prompt box; when the matching result is not empty, determining that the verification has passed as the first verification result.

[0053] In the first embodiment, in order to improve the data security of civil aviation data, it is necessary to determine whether the foreign airline (ie, the airline corresponding to the above-mentioned airline information) has the authority to query the data based on the pre-created configuration file.

[0054] In an optional embodiment, the query request is parsed to obtain the airline company information of the airline, which includes the airline company PID (i.e., the identification information mentioned above). The civil aviation system identifies each airline according to the PID, where the PID is the identification information assigned to each agent by the civil aviation system. There is a one-to-many relationship between the PID and the airline, that is, each PID corresponds to a unique agent system, and each airline can have multiple PIDs. The agent system that has been configured with the PID can extract the passenger order data related to the agent system.

[0055] Then, the identification information of the airline contained in the configuration file is matched with the identification information in the airline information to obtain the above-mentioned matching result. If the configuration file contains the identification information in the airline information, it is determined that the matching result is not empty, and the verification is determined to be the above-mentioned first verification result; if the configuration file does not contain the identification information in the airline information, it is determined that the matching result is empty, a first prompt box is created, and a prompt message that there is no right to view the passenger order data (i.e., the above-mentioned first preset information) is displayed in the first prompt box.

[0056] Optionally, in the data query method provided in Example 1 of the present application, the above-mentioned query request also includes: order identification information, querying in the target database according to the query conditions to obtain first order data, including: querying in the target database according to the order identification information to obtain second order data; if the second order data is empty, creating a second prompt box and displaying second preset information in the second prompt box; if the second order data is not empty, filtering the second order data according to the query conditions to obtain the first order data.

[0057] In this first embodiment, in order to improve query efficiency, the order identification information in the query request can be used for query, thereby avoiding invalid queries in the target database when the user enters incorrect information, saving user time, and reducing the query burden of the civil aviation database.

[0058] In an optional embodiment, the order identification information is the identification information of the passenger order data, and each order data has its unique identification information. A query is performed in the target database according to the order identification information. If the query result is empty, a second prompt box is created to prompt the user that the order data does not exist and to enter the correct order identification information; if the query result is not empty, it is determined that the order data queried by the user exists, and a query is performed in the target database according to the query conditions in the query request to obtain the above-mentioned first order data.

[0059] Optionally, in the data query method provided in Example 1 of the present application, the first order data is filtered according to the airline information to obtain target order data, including: parsing each order data in the first order data; for each order data in the first order data, filtering the order data that has no correlation with the airline information in the order data to obtain filtered order data; processing the filtered order data according to a preset arrangement order and a preset data format, respectively, to obtain target order data.

[0060] In the first embodiment, in order to ensure the security of civil aviation data, it is necessary to filter and perform other processing on the queried data to avoid leakage of civil aviation data.

[0061] In an optional embodiment, the first order data can be parsed to obtain all order data of the passenger. For each order data of the passenger in the first order data, the order data that has no association with the airline (i.e., the foreign airline mentioned above) is filtered in the order data to obtain the filtered order data. Then, the filtered order data is processed to convert the filtered order data into a preset data format, and the converted order data is sorted according to a preset arrangement order to obtain the above-mentioned target order data. A return message is constructed based on the target order data and provided to the foreign airline user. When one page on the target device screen cannot display all the order data, the foreign airline user is supported to turn pages to view the information.

[0062] Optionally, in the data query method provided in Example 1 of the present application, when the matching result is not empty, the verification pass is determined as the first verification result, including: when the matching result is not empty, parsing the query request to obtain each request content of the query request; performing format verification on each request content of the query request according to preset rules to obtain a second verification result; when the second verification result is a verification failure, creating a third prompt box and displaying third preset information in the third prompt box; when the second verification result is a verification pass, determining the verification pass as the first verification result.

[0063] In the first embodiment, in order to improve the query efficiency, it is necessary to verify the query request before querying the target database, so as to ensure that invalid data or erroneous data will not be used for querying the target database.

[0064] In an optional embodiment, whether to perform format verification on the specific content of the query request can be configured in the configuration file. If the configuration file has been configured that the specific content of the query request does not need to be format verified, then after the permission verification of the query request passes, the verification pass is directly determined as the above-mentioned first verification result. If the configuration file has been configured that the specific content of the query request needs to be format verified, then after the permission verification of the query request passes, verify whether the request information in the query request conforms to the preset request format. If the request information in the query request conforms to the preset request format, the verification pass is determined as the above-mentioned first verification result; if the request information in the query request does not conform to the preset request format, a third prompt box is created, and the format error of the query request is displayed, please re-enter, that is, the above-mentioned third preset information.

[0065] Exemplarily, it is possible to verify whether the airline information and agent information in the query request are accurate, whether the order identification information in the query request complies with preset rules, whether the query request contains historical information, and whether the query conditions or other strings in the query request of the foreign airline user are spelled accurately.

[0066] Optionally, in the data query method provided in Example 1 of the present application, the above-mentioned first order data includes at least one of the following: valid data and invalid data, the valid data is the order data that currently exists and is valid, and the invalid data is the data that currently exists but has been canceled by the passenger.

[0067] In the first embodiment, the first order data queried by the target database may include current data (i.e. the effective data mentioned above) and historical data (i.e. the invalid data mentioned above). The effective data refers to the passenger order data that is currently effective, and the invalid data refers to the passenger order data generated after the passenger transaction was completed in the past, but the data has been canceled or revoked by the current passenger.

[0068] Optionally, in the data query method provided in Example 1 of the present application, the above-mentioned target order data includes at least one of the following: passenger information, agent information, flight segment information, service information, creation information, and the flight segment information includes flight segment information of at least one airline.

[0069] In the first embodiment of the present invention, the query results returned by the civil aviation query system may include passenger information of the passenger being queried in the query request, agent information who completes the order, booked flight segment information or existing flight segment information, service information of various services purchased by the passenger (for example, the flight service from the departure place to the destination, additional service products purchased by the passenger), creation information, and flight segment information at least includes the flight segment information of the airline.

[0070] Optionally, in the first embodiment, the system structure of the civil aviation query system for completing the foreign airline query request in the present application can be as follows: Figure 3 The technical architecture of the civil aviation query system is divided into four layers, including the control layer, model layer, DAO layer and business layer.

[0071] The control layer is the first checkpoint for entering the civil aviation query system. The configured files are read at the control layer to obtain the airline information of the requested PID configuration. The airline information in the query request is verified to determine whether the foreign airline user has configured the corresponding permissions.

[0072] The model layer is the rule verification layer of the civil aviation query system. It verifies the request conditions according to the established model. Only when the model requirements are met can the system be entered to retrieve passenger order data. For example, whether the query conditions, airline information, agent information, record number, etc. in the query request meet the model requirements.

[0073] The DAO layer is the underlying database layer of the civil aviation query system. At the DAO layer, it is necessary to extract the complete passenger order data, including all information in the order, according to the identification information (also called record number) of the passenger order data in the query request of the foreign airline user.

[0074] The core of the business layer is to complete the integration of query results. According to the permission information of foreign airline users, the passenger order data that can be viewed by foreign airline users is extracted, and the target order data mentioned above is combined and returned to the foreign airline users.

[0075] Optionally, in the first embodiment, the process of obtaining the query result of the query request of the foreign airline user in the present application can be as follows: Figure 4 As shown. Get the user request information (i.e. the query request mentioned above), parse the data, and get the airline information, agent information, airline PID and other information in the query request; check whether the configuration file contains the authority information of the airline and the airline's PID. If the configuration is complete, continue with the logical processing. If the airline is not configured or the authority information of the airline's PID is not configured, it will prompt the foreign airline user that he / she has no authority to query; after the foreign airline user's authority verification is passed, it is necessary to verify whether the query request content meets the preset format requirements. If the format meets the requirements, continue with the logical verification. If the format verification fails, it will prompt the user that the request format is incorrect and the query can only be made after entering the correct format; after the user authority and request information verification are passed, The order information is queried from the open database of the airline (i.e. the target database mentioned above). The record number in the query request (i.e. the order identification information mentioned above) needs to be matched with the record number stored in the target database; if the order identification information in the query request is not found, the user is prompted that the order information is not found. If the order identification information in the query request is matched, the passenger order data corresponding to the order identification information is processed; the passenger order data corresponding to the order identification information in the query request is filtered according to the query conditions of the query request to obtain the first order data mentioned above; the passenger order data that can be viewed by foreign airline users is integrated according to the airline information in the query request, and the passenger order data that can be viewed by users is integrated and returned to the foreign airline users, ending the query process.

[0076] It should be noted that the steps shown in the flowcharts of the accompanying drawings can be executed in a computer system such as a set of computer executable instructions, and that, although a logical order is shown in the flowcharts, in some cases, the steps shown or described can be executed in an order different from that shown here.

[0077] Embodiment 2

[0078] The second embodiment of the present application also provides a data query device. It should be noted that the data query device of the second embodiment of the present application can be used to execute the data query method provided in the first embodiment of the present application. The data query device provided in the second embodiment of the present application is introduced below.

[0079] Figure 5 Schematic diagram of a data query device according to the second embodiment of the present application. Figure 5As shown, the device includes: a receiving unit 501, a checking unit 502, a query unit 503 and a processing unit 504.

[0080] Specifically, the receiving unit 501 is used to receive a query request, wherein the query request at least includes: airline information, agent information, and query conditions. The airline information is the information of the airline that initiates the query request, and the agent information is the information of the agent that queries the data.

[0081] The verification unit 502 is used to perform an authority verification on the query request to obtain a first verification result.

[0082] The query unit 503 is used to query the target database according to the query condition to obtain the first order data when the first verification result is verification passed, wherein the target database is a database determined according to the agent information.

[0083] The processing unit 504 is used to filter the first order data according to the airline information, obtain target order data, and display the target order data in the target device.

[0084] The data query device provided in the second embodiment of the present application receives a query request through a receiving unit 501, wherein the query request includes at least: airline information, agent information, and query conditions, the airline information is the information of the airline that initiates the query request, and the agent information is the information of the agent that queries the data; the verification unit 502 performs an authority verification on the query request to obtain a first verification result; the query unit 503, when the first verification result is a verification pass, queries the target database according to the query condition to obtain first order data, wherein the target database is a database determined according to the agent information; the processing unit 504 filters the first order data according to the airline information to obtain target order data, and displays the target order data in the target device, thereby solving the problem in the related art that other systems that are not synchronized with the airline data cannot query the order data of passengers in the airline. By establishing new query instructions, it is possible to receive query requests from foreign airline users and perform permission checks on the query requests from foreign airline users. When the check is passed, the query results corresponding to the query requests can be obtained, which can meet the needs of foreign airline users to extract passenger order data and improve the user experience of using civil aviation functions or services. At the same time, by filtering the query result data, the passenger order data related to the airline can be displayed to foreign airline users, thus avoiding data leakage and achieving the effect of improving the data security of civil aviation data.

[0085] Optionally, in the data query device provided in Example 2 of the present application, the above-mentioned verification unit 502 includes: an acquisition subunit, used to obtain a configuration file, wherein the configuration file contains airline information with query authority; a first parsing subunit, used to parse the airline information, and match the parsed airline identification information with the airline information in the configuration file to obtain a matching result; a first creation subunit, used to create a first prompt box and display first preset information in the first prompt box when the matching result is empty; a determination subunit, used to determine the verification pass as the first verification result when the matching result is not empty.

[0086] Optionally, in the data query device provided in Example 2 of the present application, the above-mentioned query request also includes: order identification information, and the above-mentioned query unit 503 includes: a query subunit, used to query in the target database according to the order identification information to obtain second order data; a second creation subunit, used to create a second prompt box if the second order data is empty, and display second preset information in the second prompt box; a first filtering subunit, used to filter the second order data according to the query conditions to obtain the first order data if the second order data is not empty.

[0087] Optionally, in the data query device provided in Example 2 of the present application, the above-mentioned processing unit 504 includes: a second parsing sub-unit, used to parse each order data in the first order data; a second filtering sub-unit, used to filter the order data that has no correlation with the airline information in the order data for each order data in the first order data, to obtain filtered order data; a processing sub-unit, used to process the filtered order data according to a preset arrangement order and a preset data format, respectively, to obtain target order data.

[0088] Optionally, in the data query device provided in Example 2 of the present application, the above-mentioned determination subunit includes: a parsing module, which is used to parse the query request when the matching result is not empty, and obtain each request content of the query request; a verification module, which is used to perform format verification on each request content of the query request according to preset rules to obtain a second verification result; a creation module, which is used to create a third prompt box and display third preset information in the third prompt box when the second verification result is a verification failure; and a determination module, which is used to determine the verification pass as the first verification result when the second verification result is a verification pass.

[0089] Optionally, in the data query device provided in Example 2 of the present application, the above-mentioned first order data includes at least one of the following: valid data and invalid data, the valid data is the order data that currently exists and is valid, and the invalid data is the data that currently exists but has been canceled by the passenger.

[0090] Optionally, in the data query device provided in Example 2 of the present application, the above-mentioned target order data includes at least one of the following: passenger information, agent information, flight segment information, service information, creation information, and the flight segment information includes flight segment information of at least one airline.

[0091] The data query device includes a processor and a memory. The above-mentioned receiving unit 501, verification unit 502, query unit 503 and processing unit 504 are all stored in the memory as program units, and the processor executes the above-mentioned program units stored in the memory to realize corresponding functions.

[0092] The processor includes a kernel, which retrieves the corresponding program unit from the memory. One or more kernels can be set, and the convenience of querying passenger order data can be improved by adjusting kernel parameters.

[0093] The memory may include non-permanent memory in a computer-readable medium, random access memory (RAM) and / or non-volatile memory, such as read-only memory (ROM) or flash RAM, and the memory includes at least one memory chip.

[0094] Embodiment 3 of the present invention provides a computer-readable storage medium on which a program is stored. When the program is executed by a processor, a method for querying data is implemented.

[0095] A fourth embodiment of the present invention provides a processor, which is used to run a program, wherein a method for querying data is executed when the program is running.

[0096] like Figure 6 As shown, embodiment 5 of the present invention provides an electronic device, the device includes a processor, a memory, and a program stored in the memory and executable on the processor, and the processor implements the following steps when executing the program: receiving a query request, wherein the query request includes at least: airline information, agent information, and query conditions, the airline information is the information of the airline initiating the query request, and the agent information is the information of the agent querying the data; performing an authority check on the query request to obtain a first check result; when the first check result is that the check passes, querying in a target database according to the query conditions to obtain first order data, wherein the target database is a database determined according to the agent information; filtering the first order data according to the airline information to obtain target order data, and displaying the target order data in the target device.

[0097] When the processor executes the program, the following steps are also implemented: performing an authority check on the query request to obtain a first verification result, including: obtaining a configuration file, wherein the configuration file contains airline information with query authority; parsing the airline information, and matching the parsed airline identification information with the airline information in the configuration file to obtain a matching result; when the matching result is empty, creating a first prompt box, and displaying first preset information in the first prompt box; when the matching result is not empty, determining that the verification has passed as the first verification result.

[0098] When the processor executes the program, the following steps are also implemented: the above-mentioned query request also includes: order identification information, querying in the target database according to the query conditions to obtain the first order data, including: querying in the target database according to the order identification information to obtain the second order data; if the second order data is empty, creating a second prompt box, and displaying the second preset information in the second prompt box; if the second order data is not empty, filtering the second order data according to the query conditions to obtain the first order data.

[0099] When the processor executes the program, the following steps are also implemented: filtering the first order data according to the airline information to obtain target order data, including: parsing each order data in the first order data; for each order data in the first order data, filtering the order data that has no correlation with the airline information in the order data to obtain filtered order data; processing the filtered order data according to a preset arrangement order and a preset data format to obtain target order data.

[0100] When the processor executes the program, the following steps are also implemented: when the matching result is not empty, the verification is determined to be passed as the first verification result, including: when the matching result is not empty, the query request is parsed to obtain each request content of the query request; each request content of the query request is formatted according to a preset rule to obtain a second verification result; when the second verification result is a verification failure, a third prompt box is created, and third preset information is displayed in the third prompt box; when the second verification result is a verification pass, the verification pass is determined to be the first verification result.

[0101] When the processor executes the program, the following steps are also implemented: the above-mentioned first order data includes at least one of the following: effective data and invalid data, the effective data is the order data that currently exists and is effective, and the invalid data is the data that currently exists but has been canceled by the passenger.

[0102] When the processor executes the program, the following steps are also implemented: the above-mentioned target order data includes at least one of the following: passenger information, agent information, flight segment information, service information, creation information, and the flight segment information includes the flight segment information of at least one airline.

[0103] The devices in this article can be servers, PCs, PADs, mobile phones, etc.

[0104] The present application also provides a computer program product, which, when executed on a data processing device, is suitable for executing a program that initializes the following method steps: receiving a query request, wherein the query request includes at least: airline information, agent information, and query conditions, the airline information is the information of the airline that initiates the query request, and the agent information is the information of the agent who queries the data; performing an authority check on the query request to obtain a first check result; when the first check result is that the check passes, querying in a target database according to the query conditions to obtain first order data, wherein the target database is a database determined according to the agent information; filtering the first order data according to the airline information to obtain target order data, and displaying the target order data in a target device.

[0105] When executed on a data processing device, it is also suitable for executing an initialization program having the following method steps: performing an authority check on a query request to obtain a first verification result, including: obtaining a configuration file, wherein the configuration file contains information on airlines with query authority; parsing the airline information, and matching the parsed airline identification information with the airline information in the configuration file to obtain a matching result; when the matching result is empty, creating a first prompt box, and displaying first preset information in the first prompt box; when the matching result is not empty, determining that the verification has passed as the first verification result.

[0106] When executed on a data processing device, it is also suitable for executing an initialized program having the following method steps: the above-mentioned query request also includes: order identification information, querying in the target database according to the query conditions to obtain the first order data, including: querying in the target database according to the order identification information to obtain the second order data; if the second order data is empty, creating a second prompt box, and displaying the second preset information in the second prompt box; if the second order data is not empty, filtering the second order data according to the query conditions to obtain the first order data.

[0107] When executed on a data processing device, it is also suitable for executing an initialization program having the following method steps: filtering the first order data according to the airline information to obtain target order data, including: parsing each order data in the first order data; for each order data in the first order data, filtering the order data that has no correlation with the airline information in the order data to obtain filtered order data; processing the filtered order data according to a preset arrangement order and a preset data format respectively to obtain target order data.

[0108] When executed on a data processing device, it is also suitable for executing an initialized program having the following method steps: when the matching result is not empty, determining the verification pass as the first verification result, including: when the matching result is not empty, parsing the query request to obtain each request content of the query request; performing format verification on each request content of the query request according to preset rules to obtain a second verification result; when the second verification result is a verification failure, creating a third prompt box and displaying third preset information in the third prompt box; when the second verification result is a verification pass, determining the verification pass as the first verification result.

[0109] When executed on a data processing device, it is also suitable for executing an initialization program with the following method steps: the above-mentioned first order data includes at least one of the following: effective data and invalid data, the effective data is the currently existing and effective order data, and the invalid data is the currently existing data but has been canceled by the passenger.

[0110] When executed on a data processing device, it is also suitable for executing an initialization program with the following method steps: the above-mentioned target order data includes at least one of the following: passenger information, agent information, flight segment information, service information, creation information, and the flight segment information includes the flight segment information of at least one airline.

[0111] Those skilled in the art will appreciate that the embodiments of the present application may be provided as methods, systems, or computer program products. Therefore, the present application may adopt the form of a complete hardware embodiment, a complete software embodiment, or an embodiment in combination with software and hardware. Moreover, the present application may adopt the form of a computer program product implemented in one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) that include computer-usable program code.

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

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

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

[0115] In a typical configuration, a computing device includes one or more processors (CPU), input / output interfaces, network interfaces, and memory.

[0116] The memory may include non-permanent memory in a computer-readable medium, random access memory (RAM) and / or non-volatile memory in the form of read-only memory (ROM) or flash RAM. The memory is an example of a computer-readable medium.

[0117] Computer readable media include permanent and non-permanent, removable and non-removable media that can be implemented by any method or technology to store information. Information can be computer readable instructions, data structures, program modules or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technology, compact disk read-only memory (CD-ROM), digital versatile disk (DVD) or other optical storage, magnetic cassettes, magnetic tape disk storage or other magnetic storage devices or any other non-transmission media that can be used to store information that can be accessed by a computing device. As defined herein, computer readable media does not include temporary computer readable media (transitory media), such as modulated data signals and carrier waves.

[0118] It should also be noted that the terms "include", "comprises" or any other variations thereof are intended to cover non-exclusive inclusion, so that a process, method, commodity or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, commodity or device. In the absence of more restrictions, the elements defined by the sentence "comprises a ..." do not exclude the existence of other identical elements in the process, method, commodity or device including the elements.

[0119] Those skilled in the art will appreciate that the embodiments of the present application may be provided as methods, systems or computer program products. Therefore, the present application may adopt the form of a complete hardware embodiment, a complete software embodiment or an embodiment in combination with software and hardware. Moreover, the present application may adopt the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) that contain computer-usable program code.

[0120] The above are only embodiments of the present application and are not intended to limit the present application. For those skilled in the art, the present application may have various changes and variations. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included within the scope of the claims of the present application.

Claims

1. A data query method, characterized in that: include: Receive a query request, wherein the query request at least includes: airline information, agent information, and query conditions, the airline information is information of the airline that initiates the query request, and the agent information is information of the agent that queries the data; Performing an authority check on the query request to obtain a first check result; When the first verification result is that the verification is passed, querying in the target database according to the query condition to obtain the first order data, wherein the target database is a database determined according to the agent information; The first order data is filtered according to the airline information to obtain target order data, and the target order data is displayed on a target device.

2. The method according to claim 1, characterized in that Performing an authority check on the query request to obtain a first check result includes: Obtaining a configuration file, wherein the configuration file contains information of airline companies with query permissions; Parsing the airline information, and matching the parsed airline identification information with the airline information in the configuration file to obtain a matching result; When the matching result is empty, creating a first prompt box, and displaying first preset information in the first prompt box; When the matching result is not empty, the verification is passed and determined as the first verification result.

3. The method according to claim 1, characterized in that: The query request also includes: order identification information, Searching the target database according to the query condition to obtain the first order data includes: Searching the target database according to the order identification information to obtain second order data; If the second order data is empty, create a second prompt box, and display the second preset information in the second prompt box; If the second order data is not empty, the second order data is filtered according to the query condition to obtain the first order data.

4. The method according to claim 1, characterized in that: The first order data is filtered according to the airline information to obtain target order data, including: Parsing each piece of order data in the first order data; For each piece of order data in the first order data, filter out order data that has no association relationship with the airline information in the order data to obtain filtered order data; The filtered order data are processed according to a preset arrangement order and a preset data format to obtain the target order data.

5. The method according to claim 2, characterized in that: When the matching result is not empty, determining that the verification is passed as the first verification result includes: If the matching result is not empty, the query request is parsed to obtain each request content of the query request; Performing format verification on each request content of the query request according to a preset rule to obtain a second verification result; When the second verification result is a verification failure, creating a third prompt box, and displaying third preset information in the third prompt box; When the second verification result is verification passed, verification passed is determined as the first verification result.

6. The method according to claim 3, characterized in that The first order data includes at least one of the following: effective data and invalid data, wherein the effective data is order data that currently exists and is effective, and the invalid data is data that currently exists but has been canceled by the passenger.

7. The method according to claim 1, characterized in that The target order data includes at least one of the following: passenger information, agent information, flight segment information, service information, and creation information. The flight segment information includes flight segment information of at least one airline.

8. A data query device, characterized in that: include: A receiving unit, configured to receive a query request, wherein the query request at least includes: airline information, agent information, and query conditions, wherein the airline information is information of the airline that initiates the query request, and the agent information is information of the agent that queries the data; A verification unit, configured to perform an authority verification on the query request to obtain a first verification result; a query unit, configured to query a target database according to the query condition to obtain first order data when the first verification result is a verification pass, wherein the target database is a database determined according to the agent information; A processing unit is used to filter the first order data according to the airline information to obtain target order data, and display the target order data in a target device.

9. A computer-readable storage medium, characterized in that: The computer-readable storage medium includes stored computer instructions, wherein when the computer instructions are executed by a processor, the data query method according to any one of claims 1 to 7 is implemented.

10. An electronic device, characterized in that: It includes one or more processors and a memory, wherein the memory is used to store one or more programs, wherein when the one or more programs are executed by the one or more processors, the one or more processors implement the data query method described in any one of claims 1 to 7.

Images