A personnel data query method, device, equipment and storage medium

Abstract

The application discloses a personnel data query method and device, equipment and a storage medium. The method comprises the following steps: obtaining a personnel data query request sent by a client, wherein the personnel data query request carries basic information and query index information corresponding to a to-be-queried personnel; detecting whether the identity identification information, the business subject number information and / or the business start time corresponding to the to-be-queried personnel are contained in the query index information; if yes, obtaining the business data associated with the to-be-queried personnel according to the identity identification information, the business subject number information and / or the business start time; if no, obtaining the business data associated with the to-be-queried personnel according to the basic information; and generating a data query result and returning the data query result to the client. In the case that the query index information is partially or completely missing, the application can automatically perform associated data query on the personnel according to the provided information, obtain the business data associated with the personnel, and improve the data query efficiency.

Description

TECHNICAL FIELD

[0001] Embodiments of the present application relate to the technical field of computer, and particularly relate to a personnel data query method and device, equipment and storage medium. BACKGROUND

[0002] At present, large and medium-sized enterprises have large amount of personnel information and need to record and archive a large amount of business data. In related technologies, when a data management system queries data of a target personnel according to the needs of an enterprise, the data management system needs to obtain the business data associated with the target personnel from the personnel data stored in the database according to the identity information, the business subject number information and the business start time of the target personnel provided by the enterprise. The enterprise must provide the identity information, the business subject number information and the business start time of the target personnel at the same time, and any one of the three is indispensable. In the case that any one of the identity information, the business subject number information and the business start time of the target personnel provided by the enterprise is missing, the data management system cannot automatically query the data of the target personnel. Only after the missing information is supplemented by manual operation, the data management system can continue to query the data, and the personnel data query efficiency is low. SUMMARY

[0003] Embodiments of the present application provide a personnel data query method, device, equipment and storage medium, which can automatically query the associated data of a personnel according to the provided personnel information in the case that the personnel information provided by an enterprise is missing, obtain the business data associated with the personnel, and improve the data query efficiency.

[0004] In a first aspect, embodiments of the present application provide a personnel data query method, comprising:

[0005] obtaining a personnel data query request sent by a client, wherein the personnel data query request carries basic information corresponding to a to-be-queried personnel and query index information;

[0006] detecting whether the identity information, the business subject number information and / or the business start time corresponding to the to-be-queried personnel are included in the query index information;

[0007] if the identity information, the business subject number information and / or the business start time corresponding to the to-be-queried personnel are included in the query index information, obtaining the business data associated with the to-be-queried personnel in each data table stored in the database according to the identity information, the business subject number information and / or the business start time corresponding to the to-be-queried personnel;

[0008] if the identity information, the business subject number information and the business start time corresponding to the to-be-queried personnel are not included in the query index information, then according to the basic information, the business data associated with the to-be-queried personnel is acquired from each data table stored in the database;

[0009] a data query result is generated according to the business data associated with the to-be-queried personnel, and the data query result is returned to the client.

[0010] In a second aspect, an embodiment of the present application further provides a personnel data query device, comprising:

[0011] a request acquisition module, configured to acquire a personnel data query request sent by a client, wherein the personnel data query request carries basic information and query index information corresponding to a to-be-queried personnel;

[0012] an information detection module, configured to detect whether the identity information, the business subject number information and / or the business start time corresponding to the to-be-queried personnel are included in the query index information;

[0013] a first data query module, configured to if the identity information, the business subject number information and / or the business start time corresponding to the to-be-queried personnel are included in the query index information, then according to the identity information, the business subject number information and / or the business start time corresponding to the to-be-queried personnel, the business data associated with the to-be-queried personnel is acquired from each data table stored in the database;

[0014] a second data query module, configured to if the identity information, the business subject number information and the business start time corresponding to the to-be-queried personnel are not included in the query index information, then according to the basic information, the business data associated with the to-be-queried personnel is acquired from each data table stored in the database;

[0015] a result return module, configured to generate a data query result according to the business data associated with the to-be-queried personnel, and return the data query result to the client.

[0016] In a third aspect, an embodiment of the present application further provides a computer device, comprising a memory, a processor and a computer program stored in the memory and capable of running on the processor, and characterized by that the processor implements the personnel data query method as described in the embodiments of the present application when executing the computer program.

[0017] In a fourth aspect, an embodiment of the present application further provides a computer readable storage medium, which stores a computer program, and the computer program is executed by a processor to implement the personnel data query method as described in the embodiments of the present application.

[0018] The technical scheme of the embodiment of the present application comprises the following steps: in the case that the identity information corresponding to the to-be-inquired personnel, the business subject number information and / or the business starting time are contained in the query index information, the business data associated with the to-be-inquired personnel is acquired from each data table stored in the database according to the identity information corresponding to the to-be-inquired personnel, the business subject number information and / or the business starting time; in the case that the identity information corresponding to the to-be-inquired personnel, the business subject number information and the business starting time are not contained in the query index information, the business data associated with the to-be-inquired personnel is acquired from each data table stored in the database according to the basic information. In the case that the query index information is partially missing, the business data associated with the to-be-inquired personnel can be acquired from the remaining part of the query index information and each data table stored in the database. In the case that the query index information is completely missing, the business data associated with the to-be-inquired personnel can be acquired from the basic information and each data table stored in the database. The fault tolerance of the query index information is improved, and the query index information can be partially missing or completely missing. In the case that the query index information is partially missing or completely missing, the personnel can be associated and the data can be inquired automatically according to the provided information, the business data associated with the personnel can be acquired, and the data inquiry efficiency is improved. BRIEF DESCRIPTION OF DRAWINGS

[0019] Figure 1 A flow chart of a personnel data inquiry method provided for the first embodiment of the present application.

[0020] Figure 2 A flow chart of a personnel data inquiry method provided for the second embodiment of the present application.

[0021] Figure 3 A structural schematic diagram of a personnel data inquiry device provided for the third embodiment of the present application.

[0022] Figure 4 A structural schematic diagram of a computer device provided for the fourth embodiment of the present application. DETAILED DESCRIPTION

[0023] The present application will be further described below in conjunction with the drawings and embodiments. It can be understood that the specific embodiments described herein are only used to explain the present application, but not to limit the present application.

[0024] It is also important to note that the use of the terms "exemplary" and "example" are intended to refer to one or more embodiments. Moreover, the use of the term "or" is intended to mean an inclusive "or" rather than an exclusive "or". That is, unless specifically indicated otherwise, or as is apparent from the discussion, it is intended that the inclusion of the phrase "and / or" be understood to imply an inclusive operation rather than an exclusive operation. Furthermore, use of the term "about" is intended to allow for variations, such as due to manufacturing tolerances, deviations, measurement inaccuracies, and the like. Additionally, the use of the term "based on" is intended to mean, at least in part, based on. For example, the term "based on" can mean "based at least in part on."

[0025] Embodiment One

[0026] Figure 1 A flow chart of a personnel data query method provided by the embodiment one of the present application is shown. The embodiment can be applied to the case of querying personnel data. The method can be executed by a personnel data query device. The device is executed by software and / or hardware, and can be integrated in a computer device, such as a server. As shown in Figure 1 The method of the embodiment of the present application specifically includes the following steps:

[0027] Step 101: Obtain a personnel data query request sent by a client. The personnel data query request carries basic information corresponding to a to-be-queried personnel and query index information.

[0028] Optionally, the client can be a terminal device used by a user, or an application client installed in a terminal device used by a user. The user sends a personnel data query request to a server through the client. The personnel data query request is used to request the server to query the to-be-queried personnel, and obtain business data associated with the to-be-queried personnel in each data table stored in a database to the client.

[0029] Optionally, the basic information corresponding to the to-be-queried personnel is information used to describe the basic characteristics of the to-be-queried personnel. The basic information corresponding to the to-be-queried personnel can include the name of the to-be-queried personnel, the business subject identifier of a target business subject to which the to-be-queried personnel belongs, and the like. The target business subject is a business subject to which the to-be-queried personnel belongs. The business subject can be an enterprise. The business subject identifier can be the name of the business subject.

[0030] Optionally, the query index information corresponding to the to-be-queried personnel is index information used to query the business data associated with the to-be-queried personnel in each data table stored in the database. The query index information corresponding to the to-be-queried personnel can include identity information corresponding to the to-be-queried personnel, business subject number information, and / or business start time.

[0031] Optionally, the identity information corresponding to the to-be-queried personnel is information used for identifying the identity of the to-be-queried personnel. The identity information can be an ID card number or other identification information that can distinguish different personnel.

[0032] Optionally, the business subject number information corresponding to the to-be-queried personnel is number information set by a target business subject to which the to-be-queried personnel belongs for the to-be-queried personnel, and is used for distinguishing the personnel belonging to the target business subject. The number information can be a number composed of numbers and / or letters.

[0033] Optionally, the business start time corresponding to the to-be-queried personnel is a time at which the to-be-queried personnel starts to process a business in the business subject to which the to-be-queried personnel belongs.

[0034] Step 102, detecting whether the identity information, the business subject number information and / or the business start time corresponding to the to-be-queried personnel are contained in the query index information: if the identity information, the business subject number information and / or the business start time corresponding to the to-be-queried personnel are contained in the query index information, step 103 is executed; if the identity information, the business subject number information and / or the business start time corresponding to the to-be-queried personnel are not contained in the query index information, step 104 is executed.

[0035] Optionally, detecting whether the query index information contains the identity identification information, the business subject number information and / or the business start time corresponding to the to-be-queried personnel comprises: step 1021, detecting whether the query index information contains information with the same information format as the identity identification information according to the information format of the identity identification information; step 10211, if the query index information contains information with the same information format as the identity identification information, it is determined that the query index information contains the identity identification information corresponding to the to-be-queried personnel; step 10212, if the query index information does not contain information with the same information format as the identity identification information, it is determined that the query index information does not contain the identity identification information corresponding to the to-be-queried personnel; step 1022, detecting whether the query index information contains information with the same information format as the business subject number information according to the information format of the business subject number information; step 10221, if the query index information contains information with the same information format as the business subject number information, it is determined that the query index information contains the business subject number information corresponding to the to-be-queried personnel; step 10222, if the query index information does not contain information with the same information format as the business subject number information, it is determined that the query index information does not contain the business subject number information corresponding to the to-be-queried personnel; step 1023, detecting whether the query index information contains information with the same information format as the business start time according to the information format of the business start time; step 10231, if the query index information contains information with the same information format as the business start time, it is determined that the query index information contains the business start time corresponding to the to-be-queried personnel; step 10232, if the query index information does not contain information with the same information format as the business start time, it is determined that the query index information does not contain the business start time corresponding to the to-be-queried personnel.

[0036] Step 103, obtaining the business data associated with the to-be-queried personnel in each data table stored in the database according to the identity identification information, the business subject number information and / or the business start time corresponding to the to-be-queried personnel. After obtaining the business data associated with the to-be-queried personnel, step 105 is performed.

[0037] Optionally, the database stores a plurality of data tables, including a list data table, a business subject number data table, and a business data table; the list data table is configured to store list data corresponding to each person, the list data including basic information, identity information, a business start-up audit time, and a business data identifier corresponding to the person; the business subject number data table is configured to store basic information, identity information, and a business subject number corresponding to each person belonging to a business subject; and the business data table is configured to store a plurality of pieces of business data and a business data identifier corresponding to each piece of business data.

[0038] The plurality of data tables stored in the database have potential data association relationships. For example, the list data table and the business subject number data table both include basic information and identity information corresponding to each person, and the list data table and the business data table both include a business data identifier.

[0039] If the identity information corresponding to the person to be queried can be directly obtained from the query index information, the identity information corresponding to the person to be queried is used to determine a business data identifier corresponding to the person to be queried from among the business data identifiers corresponding to each person included in the list data table. Then, the business data corresponding to the person to be queried is obtained from among the plurality of pieces of business data included in the business data table according to the business data identifier corresponding to the person to be queried.

[0040] If the identity information corresponding to the person to be queried cannot be directly obtained from the query index information, the identity information corresponding to the person to be queried can be obtained from among the identity information corresponding to each person included in the business subject number data table according to the business subject number information corresponding to the person to be queried. Then, the identity information corresponding to the person to be queried is used to determine a business data identifier corresponding to the person to be queried from among the business data identifiers corresponding to each person included in the list data table. Finally, the business data corresponding to the person to be queried is obtained from among the plurality of pieces of business data included in the business data table according to the business data identifier corresponding to the person to be queried.

[0041] If the identity information corresponding to the person to be queried and the business subject number information corresponding to the person to be queried cannot be directly obtained from the query index information, the identity information corresponding to the person to be queried can be obtained from among the identity information corresponding to each person included in the list data table according to the business start-up time and the basic information corresponding to the person to be queried. Then, the identity information corresponding to the person to be queried is used to determine a business data identifier corresponding to the person to be queried from among the business data identifiers corresponding to each person included in the list data table. Finally, the business data corresponding to the person to be queried is obtained from among the plurality of pieces of business data included in the business data table according to the business data identifier corresponding to the person to be queried.

[0042] If the identity information, the business subject number information and the business starting time of the person to be queried cannot be directly obtained from the query index information, the identity information of the person to be queried can be obtained from the identity information of the person in the list data table according to the basic information of the person to be queried. Then, the business data identifier corresponding to the person to be queried is determined from the business data identifiers of each person in the list data table according to the identity information of the person to be queried. Finally, the business data associated with the person to be queried is obtained from the business data in the business data table according to the business data identifier corresponding to the person to be queried.

[0043] Therefore, based on the data association relationship among the list data table, the business subject number data table and the business data table stored in the database, the associated data of the person can be automatically queried according to the provided information in the case of partial or complete absence of the query index information, and the business data associated with the person is obtained, thereby improving the data query efficiency.

[0044] Optionally, the business starting audit time of the person is the time when the person can start processing the business in the business subject to which the person belongs.

[0045] Optionally, the business data identifier of the person is the identifier information of each item of business data associated with the person. Each item of business data has a unique identifier information.

[0046] Optionally, the obtaining, according to the identity information corresponding to the to-be-inquired personnel, the business subject number information and / or the business starting time, the business data associated with the to-be-inquired personnel from each data table stored in the database comprises: if the query index information contains the identity information corresponding to the to-be-inquired personnel and the business starting time, determining, according to the business starting time corresponding to the to-be-inquired personnel, a first business starting audit time interval corresponding to the to-be-inquired personnel; obtaining, according to the first business starting audit time interval, a first list data group corresponding to the to-be-inquired personnel from the list data table; wherein the business starting audit time in each list data in the first list data group is located in the first business starting audit time interval; obtaining, according to the identity information corresponding to the to-be-inquired personnel, a first target list data corresponding to the to-be-inquired personnel from the first list data group; wherein the identity information in the first target list data is the same as the identity information corresponding to the to-be-inquired personnel, and the business starting audit time in the first target list data is located in the first business starting audit time interval; determining, according to the first target list data, the business data identifier corresponding to the to-be-inquired personnel, and querying, from the business data identifiers corresponding to each item of business data in the business data table, a target business data identifier same as the business data identifier corresponding to the to-be-inquired personnel; if the target business data identifier is found, determining the business data corresponding to the target business data identifier as the business data associated with the to-be-inquired personnel.

[0047] Optionally, the first business starting audit time interval corresponding to the to-be-inquired personnel is (the business starting time corresponding to the to-be-inquired personnel - first time difference value, the business starting time corresponding to the to-be-inquired personnel + first time difference value). Optionally, the first time difference value can be 15 days. For example, the business starting time corresponding to the to-be-inquired personnel is March 16, 2021, and the first business starting audit time interval corresponding to the to-be-inquired personnel is (March 1, 2021, March 31, 2021).

[0048] The business start time corresponding to the to-be-queried personnel is the time when the to-be-queried personnel starts to process a business in the business subject to which the to-be-queried personnel belongs. The business start audit time corresponding to the to-be-queried personnel is the time when it is audited whether the to-be-queried personnel can start to process a business in the business subject to which the to-be-queried personnel belongs. In general, the time difference between the business start time corresponding to the to-be-queried personnel and the business start audit time corresponding to the to-be-queried personnel should be within the first time difference value. Thus, according to the business start time corresponding to the to-be-queried personnel and the first time difference value, a business start audit time interval containing the business start audit time corresponding to the to-be-queried personnel can be calculated, which is used for list data matching to screen the list data corresponding to the to-be-queried personnel. The business start time corresponding to the to-be-queried personnel is provided by a user, and there may be data loss or inaccuracy, while the business start audit time in the list data is pre-stored data in the system and is more accurate. According to the business start time corresponding to the to-be-queried personnel, the business start audit time interval is calculated to perform list data matching, thereby narrowing the preliminary screening range of the list data and improving the accuracy of the list data matching result.

[0049] Optionally, if the first list data set does not contain list data with the same identity identification information as the identity identification information corresponding to the to-be-queried personnel, and the query index information contains the business subject number information corresponding to the to-be-queried personnel, then the business data associated with the to-be-queried personnel is obtained from each data table stored in the database according to the business subject number information corresponding to the to-be-queried personnel.

[0050] Optionally, if the first list data set does not contain list data with the same identity identification information as the identity identification information corresponding to the to-be-queried personnel, and the query index information does not contain the business subject number information corresponding to the to-be-queried personnel, then step 104 is performed.

[0051] Optionally, the business data identifier corresponding to the to-be-queried personnel is determined according to the first target list data, including: determining the business data identifier in the first target list data as the business data identifier corresponding to the to-be-queried personnel.

[0052] Optionally, if the target business data identifier is not found, then step 104 is performed.

[0053] Optionally, the obtaining the service data associated with the to-be-queried personnel from the database according to the identity information corresponding to the to-be-queried personnel, the service subject number information and / or the service starting time comprises: if the identity information corresponding to the to-be-queried personnel is contained in the query index information and the service starting time corresponding to the to-be-queried personnel is not contained in the query index information, determining a second service starting audit time interval corresponding to the to-be-queried personnel according to a receiving time of the personnel data query request; obtaining a second list data group corresponding to the to-be-queried personnel from the list data table according to the second service starting audit time interval; wherein the service starting audit time in each list data in the second list data group is located in the second service starting audit time interval; obtaining a second target list data corresponding to the to-be-queried personnel from the second list data group according to the identity information corresponding to the to-be-queried personnel; wherein the identity information in the second target list data is the same as the identity information corresponding to the to-be-queried personnel, and the service starting audit time in the second target list data is located in the second service starting audit time interval; determining the service data identifier corresponding to the to-be-queried personnel according to the second target list data, and querying a target service data identifier same as the service data identifier corresponding to the to-be-queried personnel from the service data identifiers corresponding to the service data in the service data table; and if the target service data identifier is found, determining the service data corresponding to the target service data identifier as the service data associated with the to-be-queried personnel.

[0054] Optionally, the second service starting audit time interval corresponding to the to-be-queried personnel is (the receiving time of the personnel data query request-second time difference value, the receiving time of the personnel data query request), wherein the second time difference value is greater than the first time difference value. Optionally, the second time difference value is 180 days. Because the service starting time corresponding to the to-be-queried personnel is not contained in the query index information, the range of the second service starting audit time interval is wider.

[0055] Generally, the service starting audit time corresponding to the to-be-queried personnel is earlier than the receiving time of the personnel data query request, and the time difference between the service starting audit time corresponding to the to-be-queried personnel and the receiving time of the personnel data query request will not exceed the second time difference value. Thus, in the case that the service starting time corresponding to the to-be-queried personnel cannot be directly obtained, a service starting audit time interval containing the service starting audit time corresponding to the to-be-queried personnel and having a wider range can be calculated according to the receiving time of the personnel data query request and the second time difference value, which is used for list data matching and screening the list data corresponding to the to-be-queried personnel.

[0056] Optionally, if there is no list data in the second list data set whose identity identification information is identical to the identity identification information corresponding to the personnel to be queried, and the query index information contains the business subject number information corresponding to the personnel to be queried, then the business data associated with the personnel to be queried is obtained from each data table stored in the database according to the business subject number information corresponding to the personnel to be queried.

[0057] Optionally, if there is no list data in the second list data set whose identity identification information is identical to the identity identification information corresponding to the personnel to be queried, and the query index information does not contain the business subject number information corresponding to the personnel to be queried, then step 104 is executed.

[0058] Optionally, the business data corresponding to the personnel to be queried is determined according to the second target list data, including: determining the business data identification in the second target list data as the business data identification corresponding to the personnel to be queried.

[0059] Optionally, if the target business data identification is not queried, then step 104 is executed.

[0060] Optionally, the obtaining, according to the identity information corresponding to the to-be-inquired personnel, the service subject number information and / or the service starting time, of the service data associated with the to-be-inquired personnel from each data table stored in the database comprises: if the query index information contains the service subject number information and the service starting time corresponding to the to-be-inquired personnel, and does not contain the identity information corresponding to the to-be-inquired personnel, then according to the service starting time corresponding to the to-be-inquired personnel, a first service starting audit time interval corresponding to the to-be-inquired personnel is determined; according to the first service starting audit time interval, a first list data group corresponding to the to-be-inquired personnel is obtained from the list data table; wherein the service starting audit time in each list data in the first list data group is located in the first service starting audit time interval; according to the service subject identifier in the basic information corresponding to the to-be-inquired personnel, a target service subject to which the to-be-inquired personnel belongs is determined; in the service subject number data table, the identity information and the service subject number information corresponding to the personnel belonging to the target service subject are obtained; according to the service subject number information corresponding to the to-be-inquired personnel, the identity information corresponding to the to-be-inquired personnel is obtained from the identity information corresponding to the personnel belonging to the target service subject; a first target list data corresponding to the to-be-inquired personnel is obtained from the first list data group; wherein the identity information in the first target list data is the same as the identity information corresponding to the to-be-inquired personnel, and the service starting audit time in the first target list data is located in the first service starting audit time interval; according to the first target list data, the service data identifier corresponding to the to-be-inquired personnel is determined, and the same target service data identifier as the service data identifier corresponding to the to-be-inquired personnel is queried from the service data identifiers corresponding to each item of service data in the service data table; if the target service data identifier is queried, then the service data corresponding to the target service data identifier is determined as the service data associated with the to-be-inquired personnel.

[0061] Optionally, the determining, according to the service subject identifier in the basic information corresponding to the to-be-inquired personnel, of the target service subject to which the to-be-inquired personnel belongs comprises: according to a preset corresponding relationship between the service subject identifier and the service subject, the service subject corresponding to the service subject identifier in the basic information is obtained as the target service subject to which the to-be-inquired personnel belongs.

[0062] Optionally, the business subject number data table comprises a plurality of sub-tables. Each sub-table corresponds to a business subject identifier and is used to store basic information, identity information and business subject number information of personnel belonging to a business subject. In the business subject number data table, the identity information and the business subject number information of the personnel belonging to the target business subject are obtained by: according to the business subject identifier of the target business subject, obtaining, in the business subject number data table, a target sub-table used to store the basic information, the identity information and the business subject number information of the personnel belonging to the target business subject, so as to obtain the identity information and the business subject number information of the personnel belonging to the target business subject.

[0063] Optionally, the identity information of the personnel to be queried is obtained from the identity information of the personnel belonging to the target business subject according to the business subject number information of the personnel to be queried by: querying, in the business subject number information of the personnel belonging to the target business subject, the business subject number information identical to the business subject number information of the personnel to be queried; and determining the identity information corresponding to the queried business subject number information as the identity information of the personnel to be queried.

[0064] Optionally, if the business subject number information identical to the business subject number information of the personnel to be queried does not exist in the business subject number information of the personnel belonging to the target business subject, the identity information of the personnel to be queried cannot be obtained from the identity information of the personnel belonging to the target business subject according to the business subject number information of the personnel to be queried, step 104 is performed.

[0065] Optionally, the obtaining the service data associated with the to-be-inquired personnel from each data table stored in the database according to the identity information, the service subject number information and / or the service starting time of the to-be-inquired personnel comprises: if the service subject number information of the to-be-inquired personnel is contained in the query index information, and the identity information and the service starting time of the to-be-inquired personnel are not contained in the query index information, then determining a second service starting audit time interval corresponding to the to-be-inquired personnel according to the receiving time of the personnel data query request; obtaining a second list data group corresponding to the to-be-inquired personnel from the list data table according to the second service starting audit time interval; wherein the service starting audit time in each list data in the second list data group is located in the second service starting audit time interval; determining a target service subject to which the to-be-inquired personnel belongs according to the service subject identifier in the basic information corresponding to the to-be-inquired personnel; obtaining the identity information and the service subject number information corresponding to the personnel belonging to the target service subject from the service subject number data table; obtaining the identity information corresponding to the to-be-inquired personnel from the identity information corresponding to the personnel belonging to the target service subject according to the service subject number information corresponding to the to-be-inquired personnel; obtaining a second target list data corresponding to the to-be-inquired personnel from the second list data group according to the identity information corresponding to the to-be-inquired personnel; wherein the identity information in the second target list data is the same as the identity information corresponding to the to-be-inquired personnel, and the service starting audit time in the second target list data is located in the second service starting audit time interval; determining the service data identifier corresponding to the to-be-inquired personnel according to the second target list data, and querying the target service data identifier which is the same as the service data identifier corresponding to the to-be-inquired personnel from the service data identifier corresponding to each item of service data in the service data table; if the target service data identifier is found, then determining the service data corresponding to the target service data identifier as the service data associated with the to-be-inquired personnel.

[0066] Optionally, if the service subject number information corresponding to the to-be-inquired personnel is not contained in the service subject number information corresponding to the personnel belonging to the target service subject, and the identity information corresponding to the to-be-inquired personnel cannot be obtained from the identity information corresponding to the personnel belonging to the target service subject according to the service subject number information corresponding to the to-be-inquired personnel, then step 104 is executed.

[0067] Optionally, the obtaining, according to the identity information, the business subject number information and / or the business starting time corresponding to the person to be queried, of the business data associated with the person to be queried from each data table stored in the database comprises: if the query index information contains the business starting time corresponding to the person to be queried and does not contain the identity information and the business subject number information corresponding to the person to be queried, determining a first business starting audit time interval corresponding to the person to be queried according to the business starting time corresponding to the person to be queried; obtaining a first list data group corresponding to the person to be queried from the list data table according to the first business starting audit time interval; wherein the business starting audit time in each list data in the first list data group is located in the first business starting audit time interval; obtaining a third target list data corresponding to the person to be queried from the first list data group according to the basic information corresponding to the person to be queried; wherein the basic information in the third target list data is the same as the basic information corresponding to the person to be queried, the business starting audit time in the third target list data is located in the first business starting audit time interval, and the business starting audit time in the third target list data is the latest business starting audit time among the business starting audit times located in the first business starting audit time interval; determining the business data identifier corresponding to the person to be queried according to the third target list data, and querying a target business data identifier same as the business data identifier corresponding to the person to be queried from the business data identifiers corresponding to each item of business data in the business data table; if the target business data identifier is found, determining the business data corresponding to the target business data identifier as the business data associated with the person to be queried.

[0068] Optionally, the determining, according to the third target list data, of the business data identifier corresponding to the person to be queried comprises: determining the business data identifier in the third target list data as the business data identifier corresponding to the person to be queried.

[0069] Step 104, obtaining, according to the basic information, of the business data associated with the person to be queried from each data table stored in the database.

[0070] Optionally, if the identity information, the business subject number information and the business starting time corresponding to the to-be-queried personnel are not included in the query index information, the business data associated with the to-be-queried personnel is obtained from each data table stored in the database according to the basic information, including: if the identity information, the business subject number information and the business starting time corresponding to the to-be-queried personnel are not included in the query index information, a second business starting audit time interval corresponding to the to-be-queried personnel is determined according to the receiving time of the personnel data query request; a second list data group corresponding to the to-be-queried personnel is obtained from the list data table according to the second business starting audit time interval; wherein the business starting audit time in each list data in the second list data group is located in the second business starting audit time interval; a fourth target list data corresponding to the to-be-queried personnel is obtained from the second list data group according to the basic information corresponding to the to-be-queried personnel; wherein the basic information in the fourth target list data is the same as the basic information corresponding to the to-be-queried personnel, the business starting audit time in the fourth target list data is located in the second business starting audit time interval, and the business starting audit time in the fourth target list data is the latest business starting audit time among the business starting audit times located in the second business starting audit time interval; the business data identifier corresponding to the to-be-queried personnel is determined according to the fourth target list data, and a target business data identifier identical to the business data identifier corresponding to the to-be-queried personnel is queried from the business data identifiers corresponding to each item of business data in the business data table; if the target business data identifier is queried, the business data corresponding to the target business data identifier is determined as the business data associated with the to-be-queried personnel.

[0071] Optionally, the business data identifier corresponding to the to-be-queried personnel is determined according to the fourth target list data, including: the business data identifier in the fourth target list data is determined as the business data identifier corresponding to the to-be-queried personnel.

[0072] Optionally, if the target business data identifier cannot be queried, a preset query failure prompt information is returned to the client. The preset query failure prompt information is used to prompt that the personnel data query fails, and the business data associated with the to-be-queried personnel cannot be obtained according to the basic information and the query index information corresponding to the to-be-queried personnel carried by the personnel data query request.

[0073] Optionally, if there is no list data in the first list data set whose identity identification information is the same as the identity identification information corresponding to the to-be-queried personnel, and the query index information does not contain the business subject number information corresponding to the to-be-queried personnel, the business data associated with the to-be-queried personnel is obtained from each data table stored in the database according to the basic information, including: if there is no list data in the first list data set whose identity identification information is the same as the identity identification information corresponding to the to-be-queried personnel, and the query index information does not contain the business subject number information corresponding to the to-be-queried personnel, the fifth target list data corresponding to the to-be-queried personnel is obtained from the first list data set according to the basic information corresponding to the to-be-queried personnel; wherein the basic information in the fifth target list data is the same as the basic information corresponding to the to-be-queried personnel, and the business start audit time in the fifth target list data is located in the first business start audit time interval; if the number of the fifth target list data is one, the business data identifier corresponding to the to-be-queried personnel is determined according to the fifth target list data, and the target business data identifier that is the same as the business data identifier corresponding to the to-be-queried personnel is queried in the business data identifier corresponding to each item of business data in the business data table; if the target business data identifier is queried, the business data corresponding to the target business data identifier is determined as the business data associated with the to-be-queried personnel.

[0074] Optionally, the business data identifier corresponding to the to-be-queried personnel is determined according to the fifth target list data, including: the business data identifier in the fifth target list data is determined as the business data identifier corresponding to the to-be-queried personnel.

[0075] Optionally, if the number of the fifth target list data is greater than or equal to two, the similarity between the identity identification information in each fifth target list data and the identity identification information corresponding to the to-be-queried personnel is calculated; the business data identifier in the fifth target list data with the highest similarity is determined as the business data identifier corresponding to the to-be-queried personnel.

[0076] Optionally, if there is no list data in the second list data set whose identity identification information is the same as the identity identification information corresponding to the to-be-queried personnel, and the query index information does not contain the business subject number information corresponding to the to-be-queried personnel, the business data associated with the to-be-queried personnel is obtained from each data table stored in the database according to the basic information, including: if there is no list data in the second list data set whose identity identification information is the same as the identity identification information corresponding to the to-be-queried personnel, and the query index information does not contain the business subject number information corresponding to the to-be-queried personnel, the sixth target list data corresponding to the to-be-queried personnel is obtained from the second list data set according to the basic information corresponding to the to-be-queried personnel; wherein the basic information in the sixth target list data is the same as the basic information corresponding to the to-be-queried personnel, and the business start audit time in the sixth target list data is located in the second business start audit time interval; if the number of the sixth target list data is one, the business data identifier corresponding to the to-be-queried personnel is determined according to the sixth target list data, and a target business data identifier that is the same as the business data identifier corresponding to the to-be-queried personnel is queried in the business data identifier corresponding to each item of business data in the business data table; if the target business data identifier is queried, the business data corresponding to the target business data identifier is determined as the business data associated with the to-be-queried personnel.

[0077] Optionally, the business data identifier corresponding to the to-be-queried personnel is determined according to the sixth target list data, including: the business data identifier in the sixth target list data is determined as the business data identifier corresponding to the to-be-queried personnel.

[0078] Optionally, if the number of the sixth target list data is greater than or equal to two, the similarity between the identity identification information in each sixth target list data and the identity identification information corresponding to the to-be-queried personnel is calculated respectively; the business data identifier in the sixth target list data with the highest similarity is determined as the business data identifier corresponding to the to-be-queried personnel; a target business data identifier that is the same as the business data identifier corresponding to the to-be-queried personnel is queried in the business data identifier corresponding to each item of business data in the business data table; if the target business data identifier is queried, the business data corresponding to the target business data identifier is determined as the business data associated with the to-be-queried personnel.

[0079] Optionally, if the same business subject number information as the business subject number information corresponding to the to-be-queried personnel does not exist in the business subject number information corresponding to the personnel belonging to the target business subject, and the identity information corresponding to the to-be-queried personnel cannot be obtained from the identity information corresponding to the personnel belonging to the target business subject according to the business subject number information corresponding to the to-be-queried personnel, the business data associated with the to-be-queried personnel is obtained from each data table stored in the database according to the basic information, including: if the same business subject number information as the business subject number information corresponding to the to-be-queried personnel does not exist in the business subject number information corresponding to the personnel belonging to the target business subject, and the identity information corresponding to the to-be-queried personnel cannot be obtained from the identity information corresponding to the personnel belonging to the target business subject according to the business subject number information corresponding to the to-be-queried personnel, the same basic information as the basic information corresponding to the to-be-queried personnel is queried from the basic information corresponding to the personnel belonging to the target business subject according to the basic information corresponding to the to-be-queried personnel; if the number of queried basic information is one, the identity information corresponding to the queried basic information is determined as the identity information corresponding to the to-be-queried personnel; the first target list data corresponding to the to-be-queried personnel is obtained from the first list data set, wherein the identity information in the first target list data is the same as the identity information corresponding to the to-be-queried personnel, and the business start audit time in the first target list data is located in the first business start audit time interval; the business data identifier corresponding to the to-be-queried personnel is determined according to the first target list data, and the target business data identifier that is the same as the business data identifier corresponding to the to-be-queried personnel is queried from the business data identifier corresponding to each item of business data in the business data table; if the target business data identifier is queried, the business data corresponding to the target business data identifier is determined as the business data associated with the to-be-queried personnel.

[0080] Optionally, if the number of queried basic information is greater than or equal to two, the similarity between the business subject number information corresponding to each queried basic information and the business subject number information corresponding to the to-be-queried personnel is calculated respectively; the identity information corresponding to the basic information with the highest similarity is determined as the identity information corresponding to the to-be-queried personnel.

[0081] Optionally, if the same business subject number information as the business subject number information corresponding to the to-be-queried personnel does not exist in the business subject number information corresponding to the personnel belonging to the target business subject, and the identity information corresponding to the to-be-queried personnel cannot be obtained from the identity information corresponding to the personnel belonging to the target business subject according to the business subject number information corresponding to the to-be-queried personnel, the business data associated with the to-be-queried personnel is obtained from each data table stored in the database according to the basic information, including: if the same business subject number information as the business subject number information corresponding to the to-be-queried personnel does not exist in the business subject number information corresponding to the personnel belonging to the target business subject, and the identity information corresponding to the to-be-queried personnel cannot be obtained from the identity information corresponding to the personnel belonging to the target business subject according to the business subject number information corresponding to the to-be-queried personnel, the same basic information as the basic information corresponding to the to-be-queried personnel is queried from the basic information corresponding to the personnel belonging to the target business subject according to the basic information corresponding to the to-be-queried personnel; if the number of queried basic information is one, the identity information corresponding to the queried basic information is determined as the identity information corresponding to the to-be-queried personnel; the second target list data corresponding to the to-be-queried personnel is obtained from the second list data set; the identity information in the second target list data is the same as the identity information corresponding to the to-be-queried personnel, and the business start audit time in the second target list data is located in the second business start audit time interval; the business data identifier corresponding to the to-be-queried personnel is determined according to the second target list data, and the target business data identifier same as the business data identifier corresponding to the to-be-queried personnel is queried from the business data identifier corresponding to each item of business data in the business data table; if the target business data identifier is queried, the business data corresponding to the target business data identifier is determined as the business data associated with the to-be-queried personnel.

[0082] Optionally, if the number of queried basic information is greater than or equal to two, the similarity between the business subject number information corresponding to each queried basic information and the business subject number information corresponding to the to-be-queried personnel is calculated respectively; the identity information corresponding to the basic information with the highest similarity is determined as the identity information corresponding to the to-be-queried personnel.

[0083] Step 105, generating a data query result according to the business data associated with the to-be-queried personnel, and returning the data query result to the client.

[0084] Optionally, the data query result is generated according to the business data associated with the to-be-queried personnel, and the data query result is returned to the client, including: if the business data associated with the to-be-queried personnel is obtained from each data table stored in the database according to the identity information, the business subject number information and / or the business start time corresponding to the to-be-queried personnel, the business data associated with the to-be-queried personnel is determined as the data query result; and the data query result is sent to the client.

[0085] Optionally, the data query result is generated according to the business data associated with the to-be-queried personnel, and the data query result is returned to the client, including: if the business data associated with the to-be-queried personnel is determined according to the basic information corresponding to the to-be-queried personnel, the business data associated with the to-be-queried personnel and the preset basic information matching prompt information are determined as the data query result; wherein the preset basic information matching prompt information is used to prompt that the business data associated with the to-be-queried personnel is determined according to the basic information corresponding to the to-be-queried personnel; and the data query result is sent to the client.

[0086] The embodiment of the application provides a personnel data query method, by including the identity information, the business subject number information and / or the business start time corresponding to the to-be-queried personnel in the query index information, obtaining the business data associated with the to-be-queried personnel from each data table stored in the database according to the identity information, the business subject number information and / or the business start time corresponding to the to-be-queried personnel; in the case that the query index information does not include the identity information, the business subject number information and the business start time corresponding to the to-be-queried personnel, obtaining the business data associated with the to-be-queried personnel from each data table stored in the database according to the basic information, the query index information can be partially missing, and the business data associated with the to-be-queried personnel can be obtained according to the remaining part of the query index information and each data table stored in the database, in the case that the query index information is completely missing, the business data associated with the to-be-queried personnel can be obtained according to the basic information and each data table stored in the database, the fault tolerance of the query index information is improved, the query index information can be partially missing or completely missing, in the case that the query index information is partially missing or completely missing, the personnel can be associated with the data query according to the provided information, the business data associated with the personnel is obtained, and the data query efficiency is improved.

[0087] Embodiment two

[0088] Figure 2A flow chart of a personnel data query method provided by the second embodiment of the present application. The embodiment can be combined with one or more optional schemes of the above embodiments. In the embodiment, after obtaining the business data associated with the to-be-queried personnel, the method further includes: detecting whether the business data meets a preset standard business data condition; if the business data meets the preset standard business data condition, determining the business data associated with the to-be-queried personnel and data standard prompt information as a data query result, and returning the data query result to the client; if the business data does not meet the preset standard business data condition, determining the business data associated with the to-be-queried personnel and data exception prompt information as a data query result, and returning the data query result to the client.

[0089] As shown in Figure 2 , the method of the embodiment specifically includes:

[0090] Step 201: Obtain a personnel data query request sent by a client, wherein the personnel data query request carries basic information corresponding to a to-be-queried personnel and query index information.

[0091] Step 202: Detect whether the query index information contains identity information, business subject number information and / or business start time corresponding to the to-be-queried personnel: if the query index information contains the identity information, the business subject number information and / or the business start time corresponding to the to-be-queried personnel, execute step 203; if the query index information does not contain the identity information, the business subject number information and / or the business start time corresponding to the to-be-queried personnel, execute step 204.

[0092] Step 203: Obtain, according to the identity information, the business subject number information and / or the business start time corresponding to the to-be-queried personnel, business data associated with the to-be-queried personnel in each data table stored in a database. After obtaining the business data, execute step 205.

[0093] Step 204: Obtain, according to the basic information, business data associated with the to-be-queried personnel in each data table stored in a database.

[0094] Step 205: Detect whether the business data meets a preset standard business data condition: if yes, execute step 206; if no, execute step 207.

[0095] Optionally, the preset standard service data condition is a condition for checking the service data to determine whether the service data has an abnormal situation. If the service data meets the preset standard service data condition, it indicates that the service data does not have an abnormal situation. If the service data does not meet the preset standard service data condition, it indicates that the service data has an abnormal situation.

[0096] Optionally, the detection of whether the service data meets the preset standard service data condition comprises: detecting whether, in the process of obtaining the service data, the identity information corresponding to the to-be-queried personnel, the business subject number information, or the business start time carried in the personnel data query request can be obtained from the relevant data stored in each data table in the database; if not, detecting whether the business start audit time corresponding to the service data is later than the business start time corresponding to the to-be-queried personnel carried in the personnel data query request, and whether the time difference between the business start time corresponding to the to-be-queried personnel carried in the personnel data query request and the business start audit time corresponding to the service data is less than or equal to a preset time difference threshold; if the business start audit time corresponding to the service data is not later than the business start time corresponding to the to-be-queried personnel carried in the personnel data query request, and the time difference between the business start time corresponding to the to-be-queried personnel carried in the personnel data query request and the business start audit time corresponding to the service data is less than or equal to the preset time difference threshold, it is determined that the service data meets the preset standard service data condition.

[0097] Optionally, if, in the process of obtaining the service data, the identity information corresponding to the to-be-queried personnel, the business subject number information, or the business start time carried in the personnel data query request cannot be obtained from the relevant data stored in each data table in the database, it is determined that the service data does not meet the preset standard service data condition.

[0098] In the case that, in the process of obtaining the service data, the identity information corresponding to the to-be-queried personnel, the business subject number information, or the business start time carried in the personnel data query request cannot be obtained from the relevant data stored in each data table in the database, the data matching failure can be caused by missing or incorrect information carried in the personnel data query request.

[0099] Optionally, if the business start audit time corresponding to the service data is later than the business start time corresponding to the to-be-queried personnel carried in the personnel data query request, or the time difference between the business start time corresponding to the to-be-queried personnel carried in the personnel data query request and the business start audit time corresponding to the service data is greater than a preset time difference threshold, it is determined that the service data does not meet the preset standard service data condition. The preset time difference threshold can be set according to business requirements.

[0100] Generally, the business start audit time corresponding to the business data is later than the business start time, and the time difference between the business start time and the business start audit time corresponding to the business data is less than or equal to a preset time difference threshold. If the above conditions are not met, it indicates that the business start time corresponding to the to-be-queried personnel carried by the personnel data query request may be incorrect.

[0101] Step 206, determining the business data associated with the to-be-queried personnel and the data standard prompt information as the data query result, and returning the data query result to the client.

[0102] Optionally, the data standard prompt information is information for prompting that the business data associated with the to-be-queried personnel does not exist an abnormal situation.

[0103] Step 207, determining the business data associated with the to-be-queried personnel and the data abnormal prompt information as the data query result, and returning the data query result to the client.

[0104] Optionally, the data abnormal prompt information is information for prompting that the business data associated with the to-be-queried personnel exists an abnormal situation.

[0105] The embodiment of the present application provides a personnel data query method, which comprises the following steps: when the identity information corresponding to the personnel to be queried, the business subject number information and / or the business starting time are contained in the query index information, obtaining the business data associated with the personnel to be queried from each data table stored in the database according to the identity information corresponding to the personnel to be queried, the business subject number information and / or the business starting time; when the identity information corresponding to the personnel to be queried, the business subject number information and the business starting time are not contained in the query index information, obtaining the business data associated with the personnel to be queried from each data table stored in the database according to the basic information, so that the business data associated with the personnel to be queried can be obtained from the remaining part of the query index information and each data table stored in the database when the query index information is partially missing, the business data associated with the personnel to be queried can be obtained from the basic information and each data table stored in the database when the query index information is completely missing, the fault tolerance of the query index information is improved, the query index information can be partially missing or completely missing, the data associated with the personnel can be automatically queried according to the provided information when the query index information is partially missing or completely missing, the business data associated with the personnel is obtained, and the data query efficiency is improved; whether the business data meets the preset standard business data condition is detected; when the business data meets the preset standard business data condition, the business data associated with the personnel to be queried and the data standard prompt information are determined as the data query result, and the data query result is returned to the client; when the business data does not meet the preset standard business data condition, the business data associated with the personnel to be queried and the data exception prompt information are determined as the data query result, and the data query result is returned to the client, the business data associated with the personnel to be queried can be checked according to the preset standard business data condition, whether the business data associated with the personnel to be queried is abnormal is judged, the prompt information corresponding to the detection result and the business data associated with the personnel to be queried are returned to the client at the same time, the user is prompted, the user can be prompted through the data exception prompt information returned at the same time as the business data, the abnormal condition of the business data is prompted, in the next step of processing the business data, the user directly processes the business data with the abnormal condition, the data processing efficiency is improved.

[0106] Embodiment three

[0107] Figure 3 A structural schematic diagram of a personnel data query device provided by the embodiment of the present application is shown in FIG. 3. Figure 3 As shown in FIG. 3, the device comprises a request acquisition module 301, an information detection module 302, a first data query module 303, a second data query module 304 and a result return module 305.

[0108] The personnel data query device comprises a request acquisition module 301, an information detection module 302, a first data query module 303, a second data query module 304 and a result return module 305.

[0109] The personnel data query device provided by the embodiment of the present application can acquire the business data associated with the personnel to be queried according to the remaining part of the query index information and the data tables stored in the database in the case that the query index information is partially missing, and acquire the business data associated with the personnel to be queried according to the basic information and the data tables stored in the database in the case that the query index information is completely missing, thereby improving the fault tolerance of the query index information, allowing the query index information to be partially missing or completely missing, automatically performing the associated data query on the personnel according to the provided information in the case that the query index information is partially missing or completely missing, acquiring the business data associated with the personnel, and improving the data query efficiency.

[0110] In an optional implementation of the embodiment of the present application, optionally, the database stores a plurality of data tables, including a list data table, a business subject number data table, and a business data table; the list data table is configured to store list data corresponding to each person, the list data including basic information, identity information, a business start audit time, and a business data identifier corresponding to the person; the business subject number data table is configured to store basic information, identity information, and a business subject number corresponding to each person belonging to a business subject; and the business data table is configured to store a plurality of pieces of business data and a business data identifier corresponding to each piece of business data.

[0111] In an optional implementation of the embodiment of the present application, optionally, the first data query module 303 is specifically configured to: if the query index information includes the identity information and the business start time corresponding to the person to be queried, determine a first business start audit time interval corresponding to the person to be queried according to the business start time corresponding to the person to be queried; obtain a first set of list data corresponding to the person to be queried from the list data table according to the first business start audit time interval, wherein the business start audit time in each piece of list data in the first set of list data is located in the first business start audit time interval; obtain first target list data corresponding to the person to be queried from the first set of list data according to the identity information corresponding to the person to be queried, wherein the identity information in the first target list data is the same as the identity information corresponding to the person to be queried, and the business start audit time in the first target list data is located in the first business start audit time interval; determine the business data identifier corresponding to the person to be queried according to the first target list data, and query a target business data identifier that is the same as the business data identifier corresponding to the person to be queried from the business data identifiers corresponding to the plurality of pieces of business data in the business data table; and if the target business data identifier is found, determine the business data corresponding to the target business data identifier as the business data associated with the person to be queried.

[0112] In an optional implementation of the embodiment of the present application, the first data query module 303 is specifically configured to: if the query index information contains the identity information corresponding to the to-be-queried personnel and does not contain the service start time corresponding to the to-be-queried personnel, determine a second service start audit time interval corresponding to the to-be-queried personnel according to the receiving time of the personnel data query request; obtain a second list data set corresponding to the to-be-queried personnel in the list data table according to the second service start audit time interval; wherein the service start audit time in each list data in the second list data set is located in the second service start audit time interval; obtain a second target list data corresponding to the to-be-queried personnel in the second list data set according to the identity information corresponding to the to-be-queried personnel; wherein the identity information in the second target list data is the same as the identity information corresponding to the to-be-queried personnel, and the service start audit time in the second target list data is located in the second service start audit time interval; determine the service data identifier corresponding to the to-be-queried personnel according to the second target list data, and query a target service data identifier identical to the service data identifier corresponding to the to-be-queried personnel in the service data identifier corresponding to each item of service data in the service data table; if the target service data identifier is queried, determine the service data corresponding to the target service data identifier as the service data associated with the to-be-queried personnel.

[0113] In an optional implementation of the embodiment of the present application, the first data query module 303 is specifically configured to: if the query index information contains the business subject number information and the business start time corresponding to the to-be-queried personnel, and does not contain the identity information corresponding to the to-be-queried personnel, then determine a first business start audit time interval corresponding to the to-be-queried personnel according to the business start time corresponding to the to-be-queried personnel; obtain a first list data set corresponding to the to-be-queried personnel in the list data table according to the first business start audit time interval; wherein the business start audit time in each list data in the first list data set is located in the first business start audit time interval; determine a target business subject to which the to-be-queried personnel belongs according to the business subject identifier in the basic information corresponding to the to-be-queried personnel; obtain the identity information and the business subject number information corresponding to the personnel belonging to the target business subject in the business subject number data table; obtain the identity information corresponding to the to-be-queried personnel in the identity information corresponding to the personnel belonging to the target business subject according to the business subject number information corresponding to the to-be-queried personnel; obtain a first target list data corresponding to the to-be-queried personnel in the first list data set; wherein the identity information in the first target list data is the same as the identity information corresponding to the to-be-queried personnel, and the business start audit time in the first target list data is located in the first business start audit time interval; determine the business data identifier corresponding to the to-be-queried personnel according to the first target list data, and query a target business data identifier that is the same as the business data identifier corresponding to the to-be-queried personnel in the business data identifier corresponding to each item of business data in the business data table; if the target business data identifier is queried, then determine the business data corresponding to the target business data identifier as the business data associated with the to-be-queried personnel.

[0114] In an optional implementation of the embodiment of the present application, the first data query module 303 is specifically configured to: if the query index information contains the business subject number information corresponding to the to-be-queried personnel and does not contain the identity information and the business start time corresponding to the to-be-queried personnel, determine a second business start audit time interval corresponding to the to-be-queried personnel according to the receiving time of the personnel data query request; obtain a second list data group corresponding to the to-be-queried personnel in the list data table according to the second business start audit time interval; wherein the business start audit time in each list data in the second list data group is located in the second business start audit time interval; determine a target business subject to which the to-be-queried personnel belongs according to the business subject identifier in the basic information corresponding to the to-be-queried personnel; obtain the identity information and the business subject number information corresponding to the personnel belonging to the target business subject in the business subject number data table; obtain the identity information corresponding to the to-be-queried personnel in the identity information corresponding to the personnel belonging to the target business subject according to the business subject number information corresponding to the to-be-queried personnel; obtain a second target list data corresponding to the to-be-queried personnel in the second list data group according to the identity information corresponding to the to-be-queried personnel; wherein the identity information in the second target list data is the same as the identity information corresponding to the to-be-queried personnel, and the business start audit time in the second target list data is located in the second business start audit time interval; determine the business data identifier corresponding to the to-be-queried personnel according to the second target list data, and query a target business data identifier same as the business data identifier corresponding to the to-be-queried personnel in the business data identifier corresponding to each item of business data in the business data table; if the target business data identifier is queried, determine the business data corresponding to the target business data identifier as the business data associated with the to-be-queried personnel.

[0115] In an optional implementation of the embodiment of the present application, the first data query module 303 is specifically configured to: if the query index information contains the business start time corresponding to the to-be-queried personnel, and does not contain the identity information and the business subject number information corresponding to the to-be-queried personnel, determine a first business start audit time interval corresponding to the to-be-queried personnel according to the business start time corresponding to the to-be-queried personnel; obtain a first list data set corresponding to the to-be-queried personnel in the list data table according to the first business start audit time interval; wherein the business start audit time in each list data in the first list data set is located in the first business start audit time interval; obtain third target list data corresponding to the to-be-queried personnel in the first list data set according to the basic information corresponding to the to-be-queried personnel; wherein the basic information in the third target list data is the same as the basic information corresponding to the to-be-queried personnel, the business start audit time in the third target list data is located in the first business start audit time interval, and the business start audit time in the third target list data is the latest business start audit time among the business start audit times located in the first business start audit time interval; determine the business data identifier corresponding to the to-be-queried personnel according to the third target list data, and query a target business data identifier same as the business data identifier corresponding to the to-be-queried personnel among the business data identifiers corresponding to each item of business data in the business data table; if the target business data identifier is queried, determine the business data corresponding to the target business data identifier as the business data associated with the to-be-queried personnel.

[0116] In an optional implementation of the embodiment of the present application, the second data query module 304 is specifically configured to: determine a second business start audit time interval corresponding to the to-be-queried personnel according to a receiving time of the personnel data query request; obtain a second list data set corresponding to the to-be-queried personnel in the list data table according to the second business start audit time interval; wherein the business start audit time in each list data in the second list data set is located in the second business start audit time interval; obtain fourth target list data corresponding to the to-be-queried personnel in the second list data set according to the basic information corresponding to the to-be-queried personnel; wherein the basic information in the fourth target list data is the same as the basic information corresponding to the to-be-queried personnel, the business start audit time in the fourth target list data is located in the second business start audit time interval, and the business start audit time in the fourth target list data is the latest business start audit time among the business start audit times located in the second business start audit time interval; determine the business data identifier corresponding to the to-be-queried personnel according to the fourth target list data, and query a target business data identifier same as the business data identifier corresponding to the to-be-queried personnel among the business data identifiers corresponding to each item of business data in the business data table; if the target business data identifier is queried, the business data corresponding to the target business data identifier is determined as the business data associated with the to-be-queried personnel.

[0117] In an optional implementation of the embodiment of the present application, the personnel data query device further comprises: a condition detection module configured to detect whether the business data meets a preset standard business data condition; a first return module configured to, if the business data meets the preset standard business data condition, determine the business data associated with the to-be-queried personnel and data standard prompt information as a data query result, and return the data query result to the client; and a second return module configured to, if the business data does not meet the preset standard business data condition, determine the business data associated with the to-be-queried personnel and data exception prompt information as a data query result, and return the data query result to the client.

[0118] As to the device in the above embodiment, the specific manners in which various modules perform operations have been described in detail in the embodiments of the method, and will not be described in detail here.

[0119] The personnel data query device described above can perform the personnel data query method provided in any embodiment of the present application, and has the corresponding functional modules and beneficial effects of performing the personnel data query method.

[0120] Embodiment Four

[0121] Figure 4 This is a schematic diagram of the structure of a computer device provided in Embodiment 4 of the present invention. Figure 4 A block diagram of an exemplary computer device 12 suitable for implementing embodiments of the present invention is shown. Figure 4 The computer device 12 shown is merely an example and should not impose any limitation on the functionality and scope of use of the embodiments of the present invention.

[0122] like Figure 4 As shown, the computer device 12 is represented in the form of a general-purpose computing device. The components of the computer device 12 may include, but are not limited to: one or more processors 16, memory 28, and bus 18 connecting different system components (including memory 28 and processor 16).

[0123] Bus 18 represents one or more of several bus architectures, including a memory bus or memory controller, a peripheral bus, a graphics acceleration port, a processor, or a local bus using any of the various bus architectures. For example, these architectures include, but are not limited to, the Industry Standard Architecture (ISA) bus, the Micro Channel Architecture (MAC) bus, the Enhanced ISA bus, the Video Electronics Standards Association (VESA) local bus, and the Peripheral Component Interconnect (PCI) bus.

[0124] Computer device 12 typically includes a variety of computer system readable media. These media can be any available media that can be accessed by computer device 12, including volatile and non-volatile media, removable and non-removable media.

[0125] Memory 28 may include computer system readable media in the form of volatile memory, such as random access memory (RAM) 30 and / or cache memory 32. Computer device 12 may further include other removable / non-removable, volatile / non-volatile computer system storage media. By way of example only, storage system 34 may be used to read and write non-removable, non-volatile magnetic media (…). Figure 4 Not shown; usually referred to as a "hard drive"). Although Figure 4 Not shown, a disk drive for reading and writing to a removable non-volatile disk (e.g., a "floppy disk") and an optical disk drive for reading and writing to a removable non-volatile optical disk (e.g., a CD-ROM, DVD-ROM, or other optical media) may be provided. In these cases, each drive may be connected to bus 18 via one or more data media interfaces. Memory 28 may include at least one program product having a set (e.g., at least one) of program modules configured to perform the functions of the embodiments of the present invention.

[0126] Program / utility 40 having a set of program modules 42 can be stored in memory 28 by way of example, such program modules 42 include an operating system, one or more application programs, other program modules, and program data, each of which or a combination thereof, can include implementation of a networking environment. Program modules 42 generally carry out the functions and / or methodologies of embodiments of the application as described herein.

[0127] Computer device 12 can also communicate with one or more external devices 14 such as a keyboard, a pointing device, a display 24, etc.; one or more devices that enable a user to interact with computer device 12; and / or one or more devices that enable computer device 12 to communicate with one or more other computing devices. Such communication can be via input / output (I / O) interfaces 22. Further, computer device 12 can communicate with one or more networks such as a local area network (LAN), a wide area network (WAN), and / or the Internet through network adapter 20. As depicted, network adapter 20 communicates with the other components of computer device 12 via bus 18. It should be appreciated that although not shown, other hardware and / or software modules could be used in conjunction with computer device 12. Examples, include, but are not limited to, microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data archival storage systems, etc. Figure 4

[0128] Processor 16 performs a variety of functions and data processing by executing program instructions 44 stored in memory 28. For example, processor 16 can implement a method for querying personnel data according to embodiments of the present application. The method can include: obtaining a personnel data query request sent by a client, the personnel data query request carrying basic information and query index information corresponding to a to-be-queried personnel; detecting whether the query index information contains identity information, business subject number information, and / or business start time corresponding to the to-be-queried personnel; if the query index information contains the identity information, the business subject number information, and / or the business start time corresponding to the to-be-queried personnel, obtaining business data associated with the to-be-queried personnel from each data table stored in a database according to the identity information, the business subject number information, and / or the business start time corresponding to the to-be-queried personnel; if the query index information does not contain the identity information, the business subject number information, and / or the business start time corresponding to the to-be-queried personnel, obtaining business data associated with the to-be-queried personnel from each data table stored in the database according to the basic information; generating a data query result according to the business data associated with the to-be-queried personnel, and returning the data query result to the client.

[0129] ​Embodiment five

[0130] Embodiment five of the present application provides a computer readable storage medium, which stores a computer program. The program is executed by a processor to implement a personnel data query method provided by the embodiments of the present application. The method can specifically include: obtaining a personnel data query request sent by a client, the personnel data query request carrying basic information and query index information corresponding to a to-be-queried personnel; detecting whether the query index information contains identity information, business subject number information and / or business start time corresponding to the to-be-queried personnel; if the query index information contains the identity information, the business subject number information and / or the business start time corresponding to the to-be-queried personnel, obtaining business data associated with the to-be-queried personnel in each data table stored in a database according to the identity information, the business subject number information and / or the business start time corresponding to the to-be-queried personnel; if the query index information does not contain the identity information, the business subject number information and / or the business start time corresponding to the to-be-queried personnel, obtaining business data associated with the to-be-queried personnel in each data table stored in the database according to the basic information; generating a data query result according to the business data associated with the to-be-queried personnel, and returning the data query result to the client.

[0131] Any combination of one or more computer readable medium can be employed. The computer readable medium can be a computer readable signal medium or a computer readable storage medium. A 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 any suitable combination of the foregoing. More specific examples (a non-exhaustive list) of the computer readable storage medium include 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 this document, the computer readable storage medium can be any tangible medium that contains or stores a program used by an instruction execution system, apparatus, or device to function or operate.

[0132] A computer readable signal medium can include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated signal can take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium can be any computer readable medium that can be involved in

[0133] The computer readable program code embodied on a computer readable medium can be transmitted using any appropriate medium, including but not limited to wireless, wire line, optical fiber cable, RF, etc., or any suitable combination of the foregoing.

[0134] Computer program code for carrying out operations of the present application can be written in any combination of one or more programming languages, including an object oriented programming language such as Java, Smalltalk, C++ or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code can 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 latter scenario, the remote computer can be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or the connection can be made to an external computer (for example, through the Internet using an Internet Service Provider).

[0135] Note that the foregoing are merely preferred embodiments and the principles of the present application. It will be understood by those skilled in the art that the present application is not limited to the specific embodiments described herein, and that various obvious changes, modifications and substitutions can be made without departing from the scope of the present application. Therefore, although the present application has been described in detail with reference to the above embodiments, the present application is not limited to the above embodiments, and can include other equivalent embodiments without departing from the scope of the present application, and the scope of the present application is determined by the scope of the claims.

Claims

1. A method of querying personnel data, characterized by, The method comprises the following steps: acquiring a personnel data query request sent by a client, the personnel data query request carrying basic information corresponding to a to-be-queried personnel and query index information; wherein the basic information is information used for describing basic characteristics of the to-be-queried personnel, the basic information including a name of the to-be-queried personnel and a business subject identifier of a target business subject to which the to-be-queried personnel belongs, and the query index information is index information used for querying business data associated with the to-be-queried personnel in each data table stored in a database; detecting whether the query index information includes identity identifier information, business subject number information and / or business start time corresponding to the to-be-queried personnel; if the query index information includes the identity identifier information, the business subject number information and / or the business start time corresponding to the to-be-queried personnel, acquiring, according to the identity identifier information, the business subject number information and / or the business start time corresponding to the to-be-queried personnel, the business data associated with the to-be-queried personnel in each data table stored in the database; if the query index information does not include the identity identifier information, the business subject number information and / or the business start time corresponding to the to-be-queried personnel, acquiring, according to the basic information, the business data associated with the to-be-queried personnel in each data table stored in the database; generating a data query result according to the business data associated with the to-be-queried personnel, and returning the data query result to the client.

2. The method of claim 1, wherein, Each data table stored in the database comprises a list data table, a business subject number data table and a business data table; wherein the list data table is used for storing list data corresponding to each personnel, the list data including basic information, identity identifier information, business start audit time and business data identifier corresponding to the personnel; the business subject number data table is used for storing basic information, identity identifier information and business subject number information corresponding to personnel belonging to each business subject; the business data table is used for storing each item of business data and business data identifier corresponding to each item of business data.

3. The method of claim 2, wherein, The acquiring, according to the identity identifier information, the business subject number information and / or the business start time corresponding to the to-be-queried personnel, the business data associated with the to-be-queried personnel in each data table stored in the database comprises: if the query index information includes the identity identifier information and the business start time corresponding to the to-be-queried personnel, determining a first business start audit time interval corresponding to the to-be-queried personnel according to the business start time corresponding to the to-be-queried personnel; acquiring, according to the first business start audit time interval, a first list data group corresponding to the to-be-queried personnel in the list data table; wherein the business start audit time in each list data in the first list data group is located in the first business start audit time interval; According to the identity information corresponding to the to-be-inquired personnel, first target list data corresponding to the to-be-inquired personnel is obtained from the first list data set; wherein the identity information in the first target list data is the same as the identity information corresponding to the to-be-inquired personnel, and the business start audit time in the first target list data is located in the first business start audit time interval; According to the first target list data, the business data identifier corresponding to the to-be-inquired personnel is determined, and the target business data identifier that is the same as the business data identifier corresponding to the to-be-inquired personnel is queried from the business data identifiers corresponding to each item of business data in the business data table; If the target business data identifier is queried, the business data corresponding to the target business data identifier is determined as the business data associated with the to-be-inquired personnel.

4. The method of claim 2, wherein, According to the identity information corresponding to the to-be-inquired personnel, the business subject number information, and / or the business start time, the business data associated with the to-be-inquired personnel is obtained from each data table stored in the database, including: If the query index information contains the identity information corresponding to the to-be-inquired personnel and does not contain the business start time corresponding to the to-be-inquired personnel, a second business start audit time interval corresponding to the to-be-inquired personnel is determined according to the receiving time of the personnel data query request; According to the second business start audit time interval, a second list data set corresponding to the to-be-inquired personnel is obtained from the list data table; wherein the business start audit time in each list data in the second list data set is located in the second business start audit time interval; According to the identity information corresponding to the to-be-inquired personnel, second target list data corresponding to the to-be-inquired personnel is obtained from the second list data set; wherein the identity information in the second target list data is the same as the identity information corresponding to the to-be-inquired personnel, and the business start audit time in the second target list data is located in the second business start audit time interval; According to the second target list data, the business data identifier corresponding to the to-be-inquired personnel is determined, and the target business data identifier that is the same as the business data identifier corresponding to the to-be-inquired personnel is queried from the business data identifiers corresponding to each item of business data in the business data table; If the target business data identifier is queried, the business data corresponding to the target business data identifier is determined as the business data associated with the to-be-inquired personnel.

5. The method of claim 2, wherein, According to the identity information corresponding to the to-be-inquired personnel, the business subject number information, and / or the business start time, the business data associated with the to-be-inquired personnel is obtained from each data table stored in the database, including: If the query index information contains the business subject number information and the business start time corresponding to the to-be-inquired personnel, and does not contain the identity information corresponding to the to-be-inquired personnel, a first business start audit time interval corresponding to the to-be-inquired personnel is determined according to the business start time corresponding to the to-be-inquired personnel; According to the first business start-up audit time interval, a first list data group corresponding to the to-be-inquired personnel is obtained from the list data table; each list data in the first list data group has a business start-up audit time located in the first business start-up audit time interval; According to a business subject identifier in the basic information corresponding to the to-be-inquired personnel, a target business subject to which the to-be-inquired personnel belongs is determined; In the business subject number data table, identity identifier information and business subject number information corresponding to personnel belonging to the target business subject are obtained; according to the business subject number information corresponding to the to-be-inquired personnel, identity identifier information corresponding to the to-be-inquired personnel is obtained from the identity identifier information corresponding to the personnel belonging to the target business subject; In the first list data group, a first target list data corresponding to the to-be-inquired personnel is obtained; the identity identifier information in the first target list data is the same as the identity identifier information corresponding to the to-be-inquired personnel, and the business start-up audit time in the first target list data is located in the first business start-up audit time interval; According to the first target list data, a business data identifier corresponding to the to-be-inquired personnel is determined, and a target business data identifier identical to the business data identifier corresponding to the to-be-inquired personnel is queried from the business data identifiers corresponding to each item of business data in the business data table; If the target business data identifier is queried, the business data corresponding to the target business data identifier is determined as the business data associated with the to-be-inquired personnel.

6. The method of claim 2, wherein, The obtaining of the business data associated with the to-be-inquired personnel from each data table stored in the database according to the identity identifier information, the business subject number information and / or the business start-up time corresponding to the to-be-inquired personnel includes: If the query index information contains the business subject number information corresponding to the to-be-inquired personnel and does not contain the identity identifier information and the business start-up time corresponding to the to-be-inquired personnel, a second business start-up audit time interval corresponding to the to-be-inquired personnel is determined according to the receiving time of the personnel data query request; According to the second business start-up audit time interval, a second list data group corresponding to the to-be-inquired personnel is obtained from the list data table; each list data in the second list data group has a business start-up audit time located in the second business start-up audit time interval; According to a business subject identifier in the basic information corresponding to the to-be-inquired personnel, a target business subject to which the to-be-inquired personnel belongs is determined; In the business subject number data table, identity identifier information and business subject number information corresponding to personnel belonging to the target business subject are obtained; According to the business subject number information corresponding to the to-be-inquired personnel, identity identifier information corresponding to the to-be-inquired personnel is obtained from the identity identifier information corresponding to the personnel belonging to the target business subject; According to the identity information corresponding to the to-be-inquired personnel, second target list data corresponding to the to-be-inquired personnel is obtained from the second list data set; the identity information in the second target list data is the same as the identity information corresponding to the to-be-inquired personnel, and the business start audit time in the second target list data is located in the second business start audit time interval; According to the second target list data, the business data identifier corresponding to the to-be-inquired personnel is determined, and target business data identifiers identical to the business data identifier corresponding to the to-be-inquired personnel are queried from the business data identifiers corresponding to each item of business data in the business data table; If the target business data identifier is queried, the business data corresponding to the target business data identifier is determined as the business data associated with the to-be-inquired personnel.

7. The method of claim 2, wherein, The method comprises the following steps: If the query index information contains the business start time corresponding to the to-be-inquired personnel and does not contain the identity information and the business subject number information corresponding to the to-be-inquired personnel, the business start time corresponding to the to-be-inquired personnel is determined as a first business start audit time interval corresponding to the to-be-inquired personnel; According to the first business start audit time interval, a first list data set corresponding to the to-be-inquired personnel is obtained from the list data table; each list data in the first list data set has a business start audit time located in the first business start audit time interval; According to the basic information corresponding to the to-be-inquired personnel, third target list data corresponding to the to-be-inquired personnel is obtained from the first list data set; the basic information in the third target list data is the same as the basic information corresponding to the to-be-inquired personnel, the business start audit time in the third target list data is located in the first business start audit time interval, and the business start audit time in the third target list data is the latest business start audit time among the business start audit times located in the first business start audit time interval; According to the third target list data, the business data identifier corresponding to the to-be-inquired personnel is determined, and target business data identifiers identical to the business data identifier corresponding to the to-be-inquired personnel are queried from the business data identifiers corresponding to each item of business data in the business data table; If the target business data identifier is queried, the business data corresponding to the target business data identifier is determined as the business data associated with the to-be-inquired personnel.

8. The method of claim 2, wherein, The method comprises the following steps: According to the receiving time of the personnel data query request, a second business start audit time interval corresponding to the to-be-inquired personnel is determined; According to the second business start-up audit time interval, a second list data set corresponding to the to-be-queried personnel is acquired from the list data table; each list data in the second list data set has a business start-up audit time located in the second business start-up audit time interval; According to the basic information corresponding to the to-be-queried personnel, a fourth target list data corresponding to the to-be-queried personnel is acquired from the second list data set; the basic information in the fourth target list data is the same as the basic information corresponding to the to-be-queried personnel, the business start-up audit time in the fourth target list data is located in the second business start-up audit time interval, and the business start-up audit time in the fourth target list data is the latest business start-up audit time among the business start-up audit times located in the second business start-up audit time interval; According to the fourth target list data, a business data identifier corresponding to the to-be-queried personnel is determined, and a target business data identifier same as the business data identifier corresponding to the to-be-queried personnel is queried from the business data identifiers corresponding to the business data in the business data table; If the target business data identifier is queried, the business data corresponding to the target business data identifier is determined as the business data associated with the to-be-queried personnel.

9. The method of claim 1, wherein, After the business data associated with the to-be-queried personnel is acquired, the following steps are further included: It is detected whether the business data satisfies a preset standard business data condition; If the business data satisfies the preset standard business data condition, the business data associated with the to-be-queried personnel and data standard prompt information are determined as a data query result, and the data query result is returned to the client; If the business data does not satisfy the preset standard business data condition, the business data associated with the to-be-queried personnel and data exception prompt information are determined as a data query result, and the data query result is returned to the client.

10. A personnel data query apparatus, characterized by comprising: It includes: A request acquisition module is configured to acquire a personnel data query request sent by a client, the personnel data query request carrying basic information corresponding to a to-be-queried personnel and query index information; the basic information is information used to describe basic characteristics of the to-be-queried personnel, the basic information including a name of the to-be-queried personnel and a business subject identifier of a target business subject to which the to-be-queried personnel belongs, and the query index information is index information used to query business data associated with the to-be-queried personnel in each data table stored in a database; An information detection module is configured to detect whether the query index information includes identity information, business subject number information and / or business start-up time corresponding to the to-be-queried personnel; A first data query module is configured to, if the query index information includes the identity information, the business subject number information and / or the business start-up time corresponding to the to-be-queried personnel, acquire, according to the identity information, the business subject number information and / or the business start-up time corresponding to the to-be-queried personnel, business data associated with the to-be-queried personnel from each data table stored in the database; The second data query module is configured to, if the query index information does not contain the identity information, the business subject number information and the business start time corresponding to the to-be-queried personnel, acquire the business data associated with the to-be-queried personnel from each data table stored in the database according to the basic information. The result returning module is configured to generate a data query result according to the business data associated with the to-be-queried personnel, and return the data query result to the client.

11. A computer device comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, characterized in that, The computer program is executed by the processor to implement the personnel data query method according to any one of claims 1-9.

12. A computer readable storage medium having stored thereon a computer program, characterized in that, The computer program is executed by the processor to implement the personnel data query method according to any one of claims 1-9.

Images