CN113946601A

CN113946601A - Personnel data query method, device, equipment and storage medium

Info

Publication number: CN113946601A
Application number: CN202111241205.5A
Authority: CN
Inventors: 王海志
Original assignee: Suzhou Dajiaying Information Technology Co Ltd
Current assignee: Suzhou Dajiaying Information Technology Co Ltd
Priority date: 2021-10-25
Filing date: 2021-10-25
Publication date: 2022-01-18

Abstract

The invention discloses a personnel data query method, a device, equipment and a storage medium. The method comprises the following steps: acquiring a personnel data query request sent by a client, wherein the personnel data query request carries basic information and query index information corresponding to personnel to be queried; detecting whether the inquiry index information contains identity identification information, service main body number information and/or service starting time corresponding to the person to be inquired; if so, acquiring service data associated with the person to be inquired according to the identity identification information, the service main body number information and/or the service starting time; if not, acquiring business data associated with the person to be inquired according to the basic information; and generating a data query result and returning the data query result to the client. The embodiment of the invention can automatically query the associated data of the personnel according to the provided information under the condition that the query index information is partially or completely lost, thereby obtaining the business data associated with the personnel and improving the data query efficiency.

Description

Personnel data query method, device, equipment and storage medium

Technical Field

The embodiment of the invention relates to the technical field of computers, in particular to a personnel data query method, a device, equipment and a storage medium.

Background

At present, the large and medium-sized enterprises have large personnel information amount and much business data which needs to be recorded and archived. In the related art, when a data management system queries data of a target person according to enterprise requirements, the data management system needs to acquire service data associated with the target person from person data stored in a database according to identity information, service agent number information and service start time corresponding to the target person provided by the enterprise, and provide the service data to the enterprise. The enterprise must provide the identification information, the service agent number information and the service start time corresponding to the target person at the same time, but none of them is enough. Under the condition that any one of identity identification information, service main body number information and service starting time which are provided by an enterprise and correspond to target personnel is missing, the data management system cannot automatically perform data query on the target personnel, and only after missing information is manually supplemented, the data management system can continue to perform data query, so that the personnel data query efficiency is low.

Disclosure of Invention

Embodiments of the present invention provide a method, an apparatus, a device, and a storage medium for querying staff data, which can automatically query related data of staff according to the provided staff information when the staff information provided by an enterprise is missing, obtain business data related to the staff, and improve data query efficiency.

In a first aspect, an embodiment of the present invention provides a method for querying personal data, including:

acquiring a personnel data query request sent by a client, wherein the personnel data query request carries basic information and query index information corresponding to personnel to be queried;

detecting whether the inquiry index information contains identity identification information, service main body number information and/or service starting time corresponding to the personnel to be inquired;

if the query index information contains the identity identification information, the service main body number information and/or the service starting time corresponding to the person to be queried, acquiring service data associated with the person to be queried from each data table stored in a database according to the identity identification information, the service main body number information and/or the service starting time corresponding to the person to be queried;

if the inquiry index information does not contain the identity identification information, the service main body number information and the service starting time corresponding to the person to be inquired, acquiring service data associated with the person to be inquired from each data table stored in a database according to the basic information;

and generating a data query result according to the business data associated with the person to be queried, and returning the data query result to the client.

In a second aspect, an embodiment of the present invention further provides a device for querying personal data, including:

the system comprises a request acquisition module, a query processing module and a query processing module, wherein the request acquisition module is used for acquiring a personnel data query request sent by a client, and the personnel data query request carries basic information and query index information corresponding to personnel to be queried;

the information detection module is used for detecting whether the inquiry index information contains the identity identification information, the service main body number information and/or the service starting time corresponding to the personnel to be inquired;

the first data query module is used for acquiring service data associated with the person to be queried in each data table stored in a database according to the identity identification information, the service body number information and/or the service start time corresponding to the person to be queried if the query index information contains the identity identification information, the service body number information and/or the service start time corresponding to the person to be queried;

the second data query module is used for acquiring service data associated with the personnel to be queried in each data table stored in a database according to the basic information if the query index information does not contain the identity identification information, the service main body number information and the service starting time corresponding to the personnel to be queried;

and the result returning module is used for generating a data query result according to the business data associated with the person to be queried and returning the data query result to the client.

In a third aspect, an embodiment of the present invention further provides a computer device, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, where the processor executes the computer program to implement the method for querying personal data according to the embodiment of the present invention.

In a fourth aspect, an embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the people data query method according to the embodiment of the present invention.

According to the technical scheme of the embodiment of the invention, under the condition that the query index information contains the identity identification information, the service main body number information and/or the service starting time corresponding to the person to be queried, the service data associated with the person to be queried is obtained in each data table stored in the database according to the identity identification information, the service main body number information and/or the service starting time corresponding to the person to be queried; under the condition that the query index information does not contain the identification information, the service main body number information and the service starting time corresponding to the personnel to be queried, the service data associated with the personnel to be queried is obtained in each data table stored in the database according to the basic information, under the condition that the query index information is partially lost, the service data associated with the personnel to be queried is obtained according to the rest part of the query index information and each data table stored in the database, under the condition that the query index information is completely lost, the service data associated with the personnel to be queried is 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 is allowed to be partially or completely lost, and under the condition that the query index information is partially or completely lost, the personnel can be automatically queried according to the provided information, and acquiring business data associated with personnel, and improving the data query efficiency.

Drawings

Fig. 1 is a flowchart of a method for querying personal data according to an embodiment of the present invention.

Fig. 2 is a flowchart of a personnel data query method according to a second embodiment of the present invention.

Fig. 3 is a schematic structural diagram of a personal data query device according to a third embodiment of the present invention.

Fig. 4 is a schematic structural diagram of a computer device according to a fourth embodiment of the present invention.

Detailed Description

The present invention will be described in further detail with reference to the accompanying drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting of the invention.

It should be further noted that, for the convenience of description, only some but not all of the relevant aspects of the present invention are shown in the drawings. Before discussing exemplary embodiments in more detail, it should be noted that some exemplary embodiments are described as processes or methods depicted as flowcharts. Although a flowchart may describe the operations (or steps) as a sequential process, many of the operations can be performed in parallel, concurrently or simultaneously. In addition, the order of the operations may be re-arranged. The process may be terminated when its operations are completed, but may have additional steps not included in the figure. The processes may correspond to methods, functions, procedures, subroutines, and the like.

Example one

Fig. 1 is a flowchart of a method for querying personal data according to an embodiment of the present invention. The embodiment may be applied to the case of performing data query on personnel, and the method may be executed by a personnel data query device, which is executed by software and/or hardware, and can be generally integrated in a computer device. Such as a server. As shown in fig. 1, the method of the embodiment of the present invention specifically includes:

step 101, a personnel data query request sent by a client is obtained, wherein the personnel data query request carries basic information and query index information corresponding to a person to be queried.

Optionally, the client may be a terminal device used by the user, and may also be an application client installed in the terminal device used by the user. The user sends a personnel data query request to the server through the client. The personnel data query request is used for requesting the server to perform data query on personnel to be queried, and acquiring business data associated with the personnel to be queried from each data table stored in the database to the client.

Optionally, the basic information corresponding to the person to be queried is information for describing basic features of the person to be queried. The basic information corresponding to the person to be queried may include information such as a name of the person to be queried, and a business subject identifier of a target business subject to which the person to be queried belongs. The target business body is the business body to which the person to be inquired belongs. The business entity may be an enterprise. The service agent identification may be a name of the service agent.

Optionally, the query index information corresponding to the person to be queried is index information used for querying business data associated with the person to be queried in each data table stored in the database. The query index information corresponding to the person to be queried may include identity information, service agent number information, and/or service start time corresponding to the person to be queried.

Optionally, the identity identification information corresponding to the person to be queried is information for identifying the identity of the person to be queried. The identification information may be an identification number or other identification information that can distinguish different persons.

Optionally, the number information of the service subject corresponding to the person to be queried is number information set for the person to be queried by a target service subject to which the person to be queried belongs, and is used for distinguishing each person belonging to the target service subject. The number information may be a number made up of numbers and/or letters.

Optionally, the service start time corresponding to the person to be queried is a time for the person to be queried to start processing a service in the service body to which the person to be queried belongs.

102, detecting whether the query index information contains the identity information, the service main body number information and/or the service starting time corresponding to the person to be queried: if the query index information includes the identity information, the service agent number information and/or the service start time corresponding to the person to be queried, executing step 103; if the query index information does not include the identification information, the service agent number information and the service start time corresponding to the person to be queried, step 104 is executed.

Optionally, detecting whether the query index information includes the identity information, the service agent number information, and/or the service start time corresponding to the person to be queried includes: step 1021, detecting whether the query index information contains information with the same information format as the identity information according to the information format of the identity information: step 10211, if the query index information includes information with the same information format as that of the identity identification information, determining that the query index information includes the identity identification information corresponding to the person to be queried; step 10212, if the query index information does not include information with the same information format as that of the identity identification information, determining that the query index information does not include the identity identification information corresponding to the person to be queried; step 1022, according to the information format of the service body number information, detecting whether the query index information contains information with the same information format as the information format of the service body number information: step 10221, if the query index information includes information with the same information format as the information format of the service main body number information, determining that the query index information includes the service main body number information corresponding to the person to be queried; step 10222, if the query index information does not include information with the same information format as the information format of the business body number information, determining that the query index information does not include the business body number information corresponding to the person to be queried; step 1023, according to the information format of the service start time, detecting whether the query index information contains information with the same information format as the information format of the service start time: step 10231, if the query index information contains information with the same information format as the information format of the service starting time, determining that the query index information contains the service starting time corresponding to the person to be queried; and 10232, if the query index information does not contain information with the same information format as the information format of the service starting time, determining that the query index information does not contain the service starting time corresponding to the person to be queried.

And 103, acquiring service data associated with the person to be inquired from each data table stored in a database according to the identity identification information, the service main body number information and/or the service starting time corresponding to the person to be inquired. After the business data associated with the person to be queried is obtained, step 105 is executed.

Optionally, each data table stored in the database includes: the system comprises a list data table, a service main body number data table and a service data table; the list data table is used for storing list data corresponding to each person, and the list data comprises basic information, identity identification information, service starting auditing time and service data identification corresponding to the person; the service main body number data table is used for storing basic information, identity identification information and service main body number information corresponding to personnel belonging to each service main body; the service data table is used for storing various service data and service data identifications corresponding to the various service data.

Potential data association relationships exist between data tables stored in the database. For example, both the list data table and the service agent number data table include basic information and identity information corresponding to a person, and both the list data table and the service data table include service data identifiers.

If the identity identification information corresponding to the person to be inquired can be directly obtained from the inquiry index information, the business data identification corresponding to the person to be inquired is determined in the business data identification corresponding to each person contained in the list data table according to the identity identification information corresponding to the person to be inquired. And then acquiring the business data associated with the person to be inquired from all the business data contained in the business data table according to the business data identifier corresponding to the person to be inquired.

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 the identity information corresponding to the person contained in the service main body number data table according to the service main body number information corresponding to the person to be queried. And then determining the business data identification corresponding to the person to be inquired in the business data identification corresponding to each person contained in the list data table according to the identity identification information corresponding to the person to be inquired. And finally, acquiring the business data associated with the person to be inquired from all the business data contained in the business data table according to the business data identifier corresponding to the person to be inquired.

If the identity information and the service main body number information corresponding to the person to be inquired cannot be directly obtained from the inquiry index information, the identity information corresponding to the person to be inquired can be obtained from the identity information corresponding to the person in the list data table according to the service starting time and the basic information corresponding to the person to be inquired. And then determining the business data identification corresponding to the person to be inquired in the business data identification corresponding to each person contained in the list data table according to the identity identification information corresponding to the person to be inquired. And finally, acquiring the business data associated with the person to be inquired from all the business data contained in the business data table according to the business data identifier corresponding to the person to be inquired.

If the identity information, the service agent number information and the service start time 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 the identity information corresponding to the person in the list data table according to the basic information corresponding to the person to be queried. And then determining the business data identification corresponding to the person to be inquired in the business data identification corresponding to each person contained in the list data table according to the identity identification information corresponding to the person to be inquired. And finally, acquiring the business data associated with the person to be inquired from all the business data contained in the business data table according to the business data identifier corresponding to the person to be inquired.

Therefore, based on the list data table, the business main body number data table and the data association relation among the business data tables stored in the database, under the condition that the query index information is partially or completely missing, the associated data query can be automatically carried out on the personnel according to the provided information, the business data associated with the personnel can be obtained, and the data query efficiency is improved.

Optionally, the service start auditing time corresponding to the staff is time for auditing whether the staff can start to process the service in the belonging service subject.

Optionally, the service data identifier corresponding to the person is identification information of each item of service data associated with the person. Each item of service data has unique corresponding identification information.

Optionally, the obtaining, according to the identity information, the service agent number information, and/or the service start time corresponding to the person to be queried, service data associated with the person to be queried from each data table stored in the database includes: if the query index information contains the identity identification information and the service starting time corresponding to the person to be queried, determining a first service starting auditing time interval corresponding to the person to be queried according to the service starting time corresponding to the person to be queried; according to the first business starting auditing time interval, acquiring a first list data group corresponding to the person to be inquired in the list data table; the business starting and auditing time in each list data in the first list data group is positioned in the first business starting and auditing time interval; acquiring first target name list data corresponding to the person to be inquired in the first name list data group according to the identity identification information corresponding to the person to be inquired; the identity identification information in the first target name list data is the same as the identity identification information corresponding to the person to be inquired, and the service starting and auditing time in the first target name list data is located in the first service starting and auditing time interval; determining a business data identifier corresponding to the person to be inquired according to the first target name list data, and inquiring a target business data identifier which is the same as the business data identifier corresponding to the person to be inquired in the business data identifiers corresponding to the business data in the business data table; and if the target business data identifier is inquired, determining the business data corresponding to the target business data identifier as the business data associated with the person to be inquired.

Optionally, the first service start auditing time interval corresponding to the person to be queried is (service start time-first time difference value corresponding to the person to be queried, service start time + first time difference value corresponding to the person to be queried). Alternatively, the first time difference value may be 15 days. Illustratively, the service start time corresponding to the person to be queried is 2021 year 3 month 16 days, and the first service start auditing time interval corresponding to the person to be queried is (2021 year 3 month 1 day, 2021 year 3 month 31 days).

The service starting time corresponding to the person to be queried is the time for the person to be queried to start processing the service in the belonging service main body. The business starting auditing time corresponding to the person to be inquired is the time for auditing whether the person to be inquired can start processing the business in the affiliated business subject. In general, a time difference between the service start time corresponding to the person to be queried and the service start auditing time corresponding to the person to be queried should be within a first time difference. Therefore, according to the service starting time corresponding to the person to be inquired and the first time difference value, a service starting and auditing time interval containing the service starting and auditing time corresponding to the person to be inquired can be calculated, and the service starting and auditing time interval is used for carrying out list data matching and screening the list data corresponding to the person to be inquired. The service starting time corresponding to the person to be inquired is provided for the user, the condition of data loss or inaccurate data may exist, and the service starting auditing time in the list data is the data pre-stored in the system, so that the service starting auditing method is more accurate. And deducing a service starting and checking time interval to match the list data according to the service starting time corresponding to the person to be inquired, so that the preliminary screening range of the list data is narrowed, and the accuracy of the list data matching result is improved.

Optionally, if there is no list data in the first list data group whose identification information is the same as the identification information corresponding to the person to be queried and the query index information includes the service subject number information corresponding to the person to be queried, the service data associated with the person to be queried is obtained in each data table stored in the database according to the service subject number information corresponding to the person to be queried.

Optionally, if there is no list data in the first list data group whose identification information is the same as the identification information corresponding to the person to be queried and the query index information does not include the service subject number information corresponding to the person to be queried, then step 104 is executed.

Optionally, determining the service data identifier corresponding to the person to be queried according to the first target name list data includes: and determining the business data identifier in the first target name list data as the business data identifier corresponding to the person to be inquired.

Optionally, if the target service data identifier is not queried, step 104 is executed.

Optionally, the obtaining, according to the identity information, the service agent number information, and/or the service start time corresponding to the person to be queried, service data associated with the person to be queried from each data table stored in the database includes: if the query index information contains the identity identification information corresponding to the person to be queried and does not contain the service starting time corresponding to the person to be queried, determining a second service starting auditing time interval corresponding to the person to be queried according to the receiving time of the person data query request; acquiring a second list data group corresponding to the person to be inquired in the list data table according to the second service starting auditing time interval; the business starting and auditing time in each list data in the second list data group is positioned in the second business starting and auditing time interval; acquiring second target name list data corresponding to the person to be inquired in the second name list data group according to the identity identification information corresponding to the person to be inquired; the identity identification information in the second target name list data is the same as the identity identification information corresponding to the person to be inquired, and the service starting and auditing time in the second target name list data is located in the second service starting and auditing time interval; determining a business data identifier corresponding to the person to be inquired according to the second target name list data, and inquiring a target business data identifier which is the same as the business data identifier corresponding to the person to be inquired in the business data identifiers corresponding to the business data in the business data table; and if the target business data identifier is inquired, determining the business data corresponding to the target business data identifier as the business data associated with the person to be inquired.

Optionally, the second service start auditing time interval corresponding to the person to be queried is (the receiving time of the person data query request-a second time difference, and the receiving time of the person data query request), where the second time difference is greater than the first time difference. Optionally, the second time difference is 180 days. Because the inquiry index information does not contain the service starting time corresponding to the person to be inquired, the range of the second service starting and checking time interval is wider.

In general, the service start-up auditing time corresponding to the person to be queried is earlier than the receiving time of the person data query request, and the time difference between the service start-up auditing time corresponding to the person to be queried and the receiving time of the person data query request does not exceed the second time difference. Therefore, under the condition that the service starting time corresponding to the person to be inquired cannot be directly obtained, a service starting and auditing time interval which is wider in range and contains the service starting and auditing time corresponding to the person to be inquired can be calculated according to the receiving time of the person data inquiring request and the second time difference value, and is used for carrying out list data matching and screening the list data corresponding to the person to be inquired.

Optionally, if there is no list data in the second list data group whose identification information is the same as the identification information corresponding to the person to be queried and the query index information includes the service subject number information corresponding to the person to be queried, the service data associated with the person to be queried is obtained in each data table stored in the database according to the service subject number information corresponding to the person to be queried.

Optionally, if there is no list data in the second list data group whose identification information is the same as the identification information corresponding to the person to be queried and the query index information does not include the service subject number information corresponding to the person to be queried, then step 104 is executed.

Optionally, determining the service data identifier corresponding to the person to be queried according to the second target name list data includes: and determining the business data identifier in the second target name list data as the business data identifier corresponding to the person to be inquired.

Optionally, the obtaining, according to the identity information, the service agent number information, and/or the service start time corresponding to the person to be queried, service data associated with the person to be queried from each data table stored in the database includes: if the inquiry index information contains the service main body number information and the service starting time corresponding to the to-be-inquired person and does not contain the identity identification information corresponding to the to-be-inquired person, determining a first service starting auditing time interval corresponding to the to-be-inquired person according to the service starting time corresponding to the to-be-inquired person; according to the first business starting auditing time interval, acquiring a first list data group corresponding to the person to be inquired in the list data table; the business starting and auditing time in each list data in the first list data group is positioned in the first business starting and auditing time interval; determining a target business subject to which the person to be inquired belongs according to the business subject identification in the basic information corresponding to the person to be inquired; acquiring identity identification information and service subject number information corresponding to the personnel belonging to the target service subject in the service subject number data table; according to the number information of the business subject corresponding to the person to be inquired, acquiring the identity identification information corresponding to the person to be inquired from the identity identification information corresponding to the person belonging to the target business subject; acquiring first target name list data corresponding to the person to be inquired in the first name list data group; the identity identification information in the first target name list data is the same as the identity identification information corresponding to the person to be inquired, and the service starting and auditing time in the first target name list data is located in the first service starting and auditing time interval; determining a business data identifier corresponding to the person to be inquired according to the first target name list data, and inquiring a target business data identifier which is the same as the business data identifier corresponding to the person to be inquired in the business data identifiers corresponding to the business data in the business data table; and if the target business data identifier is inquired, determining the business data corresponding to the target business data identifier as the business data associated with the person to be inquired.

Optionally, determining a target business subject to which the person to be queried belongs according to the business subject identifier in the basic information corresponding to the person to be queried includes: and acquiring a business main body corresponding to the business main body identifier in the basic information according to the corresponding relation between the preset business main body identifier and the business main body, wherein the business main body is used as a target business main body to which the person to be inquired belongs.

Optionally, the service agent number data table includes a plurality of sub-tables. Each sub-table corresponds to a business subject identification and is used for storing basic information, identity identification information and business subject number information corresponding to personnel belonging to a business subject. In the service agent number data table, acquiring identity information and service agent number information corresponding to the person belonging to the target service agent, including: and according to the service main body identification of the target service main body, acquiring a target sub-table for storing basic information, identity identification information and service main body number information corresponding to the personnel belonging to the target service main body in the service main body number data table, so as to acquire the identity identification information and the service main body number information corresponding to the personnel belonging to the target service main body.

Optionally, obtaining, according to the service agent number information corresponding to the person to be queried, the identity information corresponding to the person to be queried from the identity information corresponding to the person belonging to the target service agent, includes: inquiring the service body number information which is the same as the service body number information corresponding to the person to be inquired in the service body number information corresponding to the person belonging to the target service body; and determining the identity identification information corresponding to the inquired business main body number information as the identity identification information corresponding to the person to be inquired.

Optionally, if there is no service subject number information that is the same as the service subject number information corresponding to the person to be queried in the service subject number information corresponding to the person belonging to the target service subject, the identity information corresponding to the person to be queried cannot be obtained from the identity information corresponding to the person belonging to the target service subject according to the service subject number information corresponding to the person to be queried, then step 104 is executed.

Optionally, the obtaining, according to the identity information, the service agent number information, and/or the service start time corresponding to the person to be queried, service data associated with the person to be queried from each data table stored in the database includes: if the inquiry index information contains the service main body number information corresponding to the person to be inquired and does not contain the identity identification information and the service starting time corresponding to the person to be inquired, determining a second service starting auditing time interval corresponding to the person to be inquired according to the receiving time of the person data inquiry request; acquiring a second list data group corresponding to the person to be inquired in the list data table according to the second service starting auditing time interval; the business starting and auditing time in each list data in the second list data group is positioned in the second business starting and auditing time interval; determining a target business subject to which the person to be inquired belongs according to the business subject identification in the basic information corresponding to the person to be inquired; acquiring identity identification information and service subject number information corresponding to the personnel belonging to the target service subject in the service subject number data table; according to the number information of the business subject corresponding to the person to be inquired, acquiring the identity identification information corresponding to the person to be inquired from the identity identification information corresponding to the person belonging to the target business subject; acquiring second target name list data corresponding to the person to be inquired in the second name list data group according to the identity identification information corresponding to the person to be inquired; the identity identification information in the second target name list data is the same as the identity identification information corresponding to the person to be inquired, and the service starting and auditing time in the second target name list data is located in the second service starting and auditing time interval; determining a business data identifier corresponding to the person to be inquired according to the second target name list data, and inquiring a target business data identifier which is the same as the business data identifier corresponding to the person to be inquired in the business data identifiers corresponding to the business data in the business data table; and if the target business data identifier is inquired, determining the business data corresponding to the target business data identifier as the business data associated with the person to be inquired.

Optionally, the obtaining, according to the identity information, the service agent number information, and/or the service start time corresponding to the person to be queried, service data associated with the person to be queried from each data table stored in the database includes: if the inquiry index information contains the service starting time corresponding to the person to be inquired and does not contain the identity identification information and the service main body number information corresponding to the person to be inquired, determining a first service starting auditing time interval corresponding to the person to be inquired according to the service starting time corresponding to the person to be inquired; according to the first business starting auditing time interval, acquiring a first list data group corresponding to the person to be inquired in the list data table; the business starting and auditing time in each list data in the first list data group is positioned in the first business starting and auditing time interval; acquiring third target name list data corresponding to the person to be inquired in the first name list data group according to the basic information corresponding to the person to be inquired; the basic information in the third target business form data is the same as the basic information corresponding to the person to be inquired, the business starting and auditing time in the third target business form data is located in the first business starting and auditing time interval, and the business starting and auditing time in the third target business form data is the latest business starting and auditing time in each business starting and auditing time in the first business starting and auditing time interval; determining a service data identifier corresponding to the person to be inquired according to the third target name list data, and inquiring a target service data identifier which is the same as the service data identifier corresponding to the person to be inquired in the service data identifiers corresponding to the service data in the service data table; and if the target business data identifier is inquired, determining the business data corresponding to the target business data identifier as the business data associated with the person to be inquired.

Optionally, determining the service data identifier corresponding to the person to be queried according to the third target name list data includes: and determining the business data identifier in the third target name list data as the business data identifier corresponding to the person to be inquired.

And 104, acquiring business data associated with the person to be inquired from each data table stored in a database according to the basic information.

Optionally, if the query index information does not include the identity information, the service agent number information, and the service start time corresponding to the person to be queried, acquiring, according to the basic information, service data associated with the person to be queried from each data table stored in a database, where the method includes: if the inquiry index information does not contain the identity identification information, the service main body number information and the service starting time corresponding to the person to be inquired, determining a second service starting auditing time interval corresponding to the person to be inquired according to the receiving time of the personnel data inquiry request; acquiring a second list data group corresponding to the person to be inquired in the list data table according to the second service starting auditing time interval; the business starting and auditing time in each list data in the second list data group is positioned in the second business starting and auditing time interval; acquiring fourth target name list data corresponding to the person to be inquired in the second name list data group according to the basic information corresponding to the person to be inquired; the basic information in the fourth target business form data is the same as the basic information corresponding to the person to be inquired, the business starting and auditing time in the fourth target business form data is located in the second business starting and auditing time interval, and the business starting and auditing time in the fourth target business form data is the latest business starting and auditing time in each business starting and auditing time in the second business starting and auditing time interval; determining a service data identifier corresponding to the person to be inquired according to the fourth target name list data, and inquiring a target service data identifier which is the same as the service data identifier corresponding to the person to be inquired in the service data identifiers corresponding to the various service data in the service data table; and if the target business data identifier is inquired, determining the business data corresponding to the target business data identifier as the business data associated with the person to be inquired.

Optionally, determining the service data identifier corresponding to the person to be queried according to the fourth target name list data includes: and determining the business data identifier in the fourth target name list data as the business data identifier corresponding to the person to be inquired.

Optionally, if the target service data identifier is not queried, returning preset query failure prompt information to the client. The preset query failure prompt information is used for prompting personnel that data query fails, and business data associated with the personnel to be queried cannot be acquired according to basic information and query index information corresponding to the personnel to be queried, which are carried by the personnel data query request.

Optionally, if there is no list data in the first list data group whose identification information is the same as the identification information corresponding to the person to be queried and the query index information does not include the service subject number information corresponding to the person to be queried, acquiring, according to the basic information, service data associated with the person to be queried from each data table stored in a database, where the method includes: if the first list data group does not contain list data with the identity identification information identical to the identity identification information corresponding to the person to be inquired and the inquiry index information does not contain the business subject number information corresponding to the person to be inquired, acquiring fifth target name list data corresponding to the person to be inquired from the first list data group according to the basic information corresponding to the person to be inquired; basic information in the fifth target business form data is the same as basic information corresponding to the person to be inquired, and business starting and auditing time in the fifth target business form data is located in the first business starting and auditing time interval; if the number of fifth target business data is one, determining a business data identifier corresponding to the person to be inquired according to the fifth target business data, and inquiring a target business data identifier which is the same as the business data identifier corresponding to the person to be inquired in the business data identifiers corresponding to all business data in the business data table; and if the target business data identifier is inquired, determining the business data corresponding to the target business data identifier as the business data associated with the person to be inquired.

Optionally, determining the service data identifier corresponding to the person to be queried according to the fifth target name list data includes: and determining the business data identifier in the fifth target name list data as the business data identifier corresponding to the person to be inquired.

Optionally, if the number of the fifth target list data is greater than or equal to two, respectively calculating similarity between the identity information in each fifth target list data and the identity information corresponding to the person to be queried; and determining the business data identifier in the fifth target name list data with the highest similarity as the business data identifier corresponding to the person to be inquired.

Optionally, if there is no list data in the second list data group whose identification information is the same as the identification information corresponding to the person to be queried and the query index information does not include the service subject number information corresponding to the person to be queried, acquiring, according to the basic information, service data associated with the person to be queried from each data table stored in a database, where the method includes: if the second list data group does not have list data with the identity identification information identical to the identity identification information corresponding to the person to be inquired, and the inquiry index information does not contain the business subject number information corresponding to the person to be inquired, acquiring sixth target name list data corresponding to the person to be inquired in the second list data group according to the basic information corresponding to the person to be inquired; basic information in the sixth target name list data is the same as basic information corresponding to the person to be inquired, and service starting and auditing time in the sixth target name list data is located in the second service starting and auditing time interval; if the number of the sixth target name list data is one, determining a business data identifier corresponding to the person to be inquired according to the sixth target name list data, and inquiring a target business data identifier which is the same as the business data identifier corresponding to the person to be inquired in the business data identifiers corresponding to all business data in the business data table; and if the target business data identifier is inquired, determining the business data corresponding to the target business data identifier as the business data associated with the person to be inquired.

Optionally, determining the service data identifier corresponding to the person to be queried according to the sixth target name list data includes: and determining the business data identifier in the sixth target name list data as the business data identifier corresponding to the person to be inquired.

Optionally, if the number of the sixth target list data is greater than or equal to two, respectively calculating the similarity between the identity information in each sixth target list data and the identity information corresponding to the person to be queried; determining a business data identifier in sixth target name list data with highest similarity as a business data identifier corresponding to the person to be inquired; inquiring a target service data identifier which is the same as the service data identifier corresponding to the person to be inquired in the service data identifiers corresponding to the service data in the service data table; and if the target business data identifier is inquired, determining the business data corresponding to the target business data identifier as the business data associated with the person to be inquired.

Optionally, if there is no service subject number information that is the same as the service subject number information corresponding to the person to be queried in the service subject number information corresponding to the person belonging to the target service subject, the identity information corresponding to the person to be queried cannot be obtained in the identity information corresponding to the person belonging to the target service subject according to the service subject number information corresponding to the person to be queried, and then according to the basic information, obtaining service data associated with the person to be queried in each data table stored in a database, includes: if the service body number information corresponding to the person to be inquired does not exist in the service body number information corresponding to the person to be inquired, the identity identification information corresponding to the person to be inquired cannot be acquired from the identity identification information corresponding to the person to be inquired according to the service body number information corresponding to the person to be inquired, and the basic information corresponding to the person to be inquired is inquired in the basic information corresponding to the person to be inquired according to the basic information corresponding to the person to be inquired; if the number of the inquired basic information is one, determining the identity identification information corresponding to the inquired basic information as the identity identification information corresponding to the person to be inquired; acquiring first target name list data corresponding to the person to be inquired in the first name list data group; the identity identification information in the first target name list data is the same as the identity identification information corresponding to the person to be inquired, and the service starting and auditing time in the first target name list data is located in the first service starting and auditing time interval; determining a business data identifier corresponding to the person to be inquired according to the first target name list data, and inquiring a target business data identifier which is the same as the business data identifier corresponding to the person to be inquired in the business data identifiers corresponding to the business data in the business data table; and if the target business data identifier is inquired, determining the business data corresponding to the target business data identifier as the business data associated with the person to be inquired.

Optionally, if the number of the inquired basic information is greater than or equal to two, calculating similarity between the service body number information corresponding to each inquired basic information and the service body number information corresponding to the person to be inquired respectively; and determining the identity information corresponding to the basic information with the highest similarity as the identity information corresponding to the person to be inquired.

Optionally, if there is no service subject number information that is the same as the service subject number information corresponding to the person to be queried in the service subject number information corresponding to the person belonging to the target service subject, the identity information corresponding to the person to be queried cannot be obtained in the identity information corresponding to the person belonging to the target service subject according to the service subject number information corresponding to the person to be queried, and then according to the basic information, obtaining service data associated with the person to be queried in each data table stored in a database, includes: if the service body number information corresponding to the person to be inquired does not exist in the service body number information corresponding to the person to be inquired, the identity identification information corresponding to the person to be inquired cannot be acquired from the identity identification information corresponding to the person to be inquired according to the service body number information corresponding to the person to be inquired, and the basic information corresponding to the person to be inquired is inquired in the basic information corresponding to the person to be inquired according to the basic information corresponding to the person to be inquired; if the number of the inquired basic information is one, determining the identity identification information corresponding to the inquired basic information as the identity identification information corresponding to the person to be inquired; acquiring second target name list data corresponding to the person to be inquired in the second list data group; the identity identification information in the second target name list data is the same as the identity identification information corresponding to the person to be inquired, and the service starting and auditing time in the second target name list data is located in the second service starting and auditing time interval; determining a business data identifier corresponding to the person to be inquired according to the second target name list data, and inquiring a target business data identifier which is the same as the business data identifier corresponding to the person to be inquired in the business data identifiers corresponding to the business data in the business data table; and if the target business data identifier is inquired, determining the business data corresponding to the target business data identifier as the business data associated with the person to be inquired.

And 105, generating a data query result according to the business data associated with the person to be queried, and returning the data query result to the client.

Optionally, generating a data query result according to the business data associated with the person to be queried, and returning the data query result to the client, including: if the business data associated with the to-be-inquired person is acquired from each data table stored in a database according to the identity identification information, the business subject number information and/or the business starting time corresponding to the to-be-inquired person, determining the business data associated with the to-be-inquired person as a data inquiry result; and sending the data query result to the client.

Optionally, generating a data query result according to the business data associated with the person to be queried, and returning the data query result to the client, including: if the business data associated with the person to be inquired is determined according to the basic information corresponding to the person to be inquired, determining the business data associated with the person to be inquired and the preset basic information matching prompt information as a data inquiry result; the preset basic information matching prompt information is used for prompting that the business data associated with the person to be inquired is determined according to the basic information corresponding to the person to be inquired; and sending the data query result to the client.

The embodiment of the invention provides a personnel data query method, which comprises the steps of acquiring service data associated with personnel to be queried in each data table stored in a database according to identity identification information, service subject number information and/or service starting time corresponding to the personnel to be queried under the condition that query index information contains the identity identification information, the service subject number information and/or the service starting time corresponding to the personnel to be queried; under the condition that the query index information does not contain the identification information, the service main body number information and the service starting time corresponding to the personnel to be queried, the service data associated with the personnel to be queried is obtained in each data table stored in the database according to the basic information, under the condition that the query index information is partially lost, the service data associated with the personnel to be queried is obtained according to the rest part of the query index information and each data table stored in the database, under the condition that the query index information is completely lost, the service data associated with the personnel to be queried is 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 is allowed to be partially or completely lost, and under the condition that the query index information is partially or completely lost, the personnel can be automatically queried according to the provided information, and acquiring business data associated with personnel, and improving the data query efficiency.

Example two

Fig. 2 is a flowchart of a personnel data query method according to a second embodiment of the present invention. In this embodiment, after obtaining the business data associated with the person to be queried, the method may further include: detecting whether the service data meet a preset standard service data condition; if the business data meet the preset standard business data condition, determining the business data and the data standard prompt information associated with the person to be inquired as a data inquiry result, and returning the data inquiry result to the client; and if the service data does not meet the preset standard service data condition, determining the service data and the abnormal data prompt information associated with the person to be inquired as a data inquiry result, and returning the data inquiry result to the client.

As shown in fig. 2, the method of the embodiment of the present invention specifically includes:

step 201, a personnel data query request sent by a client is obtained, wherein the personnel data query request carries basic information and query index information corresponding to a person to be queried.

Step 202, detecting whether the query index information contains the identity information, the service agent number information and/or the service starting time corresponding to the person to be queried: if the query index information includes the identity information, the service agent number information and/or the service start time corresponding to the person to be queried, executing step 203; if the query index information does not include the identification information, the service agent number information and the service start time corresponding to the person to be queried, then step 204 is executed.

Step 203, acquiring service data associated with the person to be queried from each data table stored in a database according to the identity information, the service agent number information and/or the service starting time corresponding to the person to be queried. After the service data is acquired, step 205 is executed.

And 204, acquiring business data associated with the person to be inquired from each data table stored in a database according to the basic information.

Step 205, detecting whether the service data meets a preset standard service data condition: if yes, go to step 206; if not, go to step 207.

Optionally, the preset standard service data condition is a condition for checking the service data and judging whether the service data has an abnormal condition. And if the service data meets the preset standard service data condition, indicating that the service data has no abnormal condition. And if the service data does not meet the preset standard service data condition, indicating that the service data has abnormal conditions.

Optionally, detecting whether the service data meets a preset standard service data condition includes: detecting whether the condition that relevant data cannot be acquired in each data table stored in a database according to identity identification information, service subject number information or service starting time corresponding to a person to be inquired carried by a person data inquiry request exists in the service data acquisition process; if not, detecting whether the service starting and checking time corresponding to the service data is later than the service starting time corresponding to the person to be inquired carried by the person data inquiry request, and whether the time difference between the service starting time corresponding to the person to be inquired carried by the person data inquiry request and the service starting and checking time corresponding to the service data is smaller than or equal to a preset time difference threshold value; and if the service starting and auditing time corresponding to the service data is not later than the service starting time corresponding to the person to be inquired carried by the person data inquiry request, and the time difference between the service starting time corresponding to the person to be inquired carried by the person data inquiry request and the service starting and auditing time corresponding to the service data is less than or equal to a preset time difference threshold value, determining that the service data meets the preset standard service data condition.

Optionally, if there is a situation that related data cannot be acquired in each data table stored in the database according to the identity information, the service subject number information, or the service start time corresponding to the person to be queried, which are carried in the person data query request, in the process of acquiring the service data, it is determined that the service data does not satisfy the preset standard service data condition.

In the process of acquiring the service data, the condition that the relevant data cannot be acquired in each data table stored in the database according to the identification information, the service subject number information or the service start time corresponding to the person to be inquired carried in the person data inquiry request may be that the information carried in the person data inquiry request is missing or wrong, resulting in data matching failure.

Optionally, if the service start auditing time corresponding to the service data is later than the service start time corresponding to the person to be queried carried in the person data query request, or the time difference between the service start time corresponding to the person to be queried carried in the person data query request and the service start auditing time corresponding to the service data is greater than a preset time difference threshold, it is determined that the service data does not satisfy the preset standard service data condition. The preset time difference threshold may be set according to the service requirements.

In general, the service start-up auditing time corresponding to the service data is later than the service start-up time, and the time difference between the service start-up time and the service start-up auditing time corresponding to the service data is less than or equal to a preset time difference threshold. If the condition is not met, it is indicated that the service starting time corresponding to the person to be inquired carried by the person data inquiry request may have an error.

Step 206, determining the business data and the data standard prompt information associated with the person to be queried as a data query result, and returning the data query result to the client.

Optionally, the data standard prompt information is used to prompt that the service data associated with the person to be queried has no abnormal condition.

Step 207, determining the business data and the data exception prompt information associated with the person to be queried as a data query result, and returning the data query result to the client.

Optionally, the data exception prompting information is used for prompting that the business data associated with the person to be queried has an exception condition.

The embodiment of the invention provides a personnel data query method, which comprises the steps of acquiring service data associated with personnel to be queried in each data table stored in a database according to identity identification information, service subject number information and/or service starting time corresponding to the personnel to be queried under the condition that query index information contains the identity identification information, the service subject number information and/or the service starting time corresponding to the personnel to be queried; under the condition that the query index information does not contain the identification information, the service main body number information and the service starting time corresponding to the personnel to be queried, the service data associated with the personnel to be queried is obtained in each data table stored in the database according to the basic information, under the condition that the query index information is partially lost, the service data associated with the personnel to be queried is obtained according to the rest part of the query index information and each data table stored in the database, under the condition that the query index information is completely lost, the service data associated with the personnel to be queried is 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 is allowed to be partially or completely lost, and under the condition that the query index information is partially or completely lost, the personnel can be automatically queried according to the provided information, acquiring business data associated with personnel, and improving data query efficiency; detecting whether the service data meet a preset standard service data condition; under the condition that the service data meet the preset standard service data condition, determining the service data and the data standard prompt information associated with the person to be inquired as a data inquiry result, and returning the data inquiry result to the client; determining the service data and abnormal data prompt information associated with the person to be inquired as a data inquiry result under the condition that the service data does not meet the preset standard service data condition, returning the data inquiry result to the client, checking the service data associated with the person to be inquired according to the preset standard service data condition, judging whether the service data associated with the person to be inquired is abnormal or not, returning the prompt information corresponding to the detection result and the service data associated with the person to be inquired to the client together, prompting the user through the abnormal data prompt information returned simultaneously with the service data, prompting the abnormal condition of the service data, and avoiding that the user directly processes the service data with the abnormal condition in the next processing aiming at the service data, and the data processing efficiency is improved.

EXAMPLE III

Fig. 3 is a schematic structural diagram of a personal data query device according to a third embodiment of the present invention. As shown in fig. 3, the apparatus includes: 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.

The request acquisition module 301 is configured to acquire a personnel data query request sent by a client, where the personnel data query request carries basic information and query index information corresponding to a person to be queried; an information detection module 302, configured to detect whether the query index information includes identity information, service subject number information, and/or service start time corresponding to the person to be queried; a first data query module 303, configured to, if the query index information includes the identity information, the service subject number information, and/or the service start time corresponding to the person to be queried, obtain service data associated with the person to be queried in each data table stored in a database according to the identity information, the service subject number information, and/or the service start time corresponding to the person to be queried; a second data query module 304, configured to, if the query index information does not include the identity information, the service subject number information, and the service start time corresponding to the person to be queried, obtain, according to the basic information, service data associated with the person to be queried in each data table stored in a database; a result returning module 305, configured to generate a data query result according to the service data associated with the person to be queried, and return the data query result to the client.

The embodiment of the invention provides a personnel data query device, which is characterized in that under the condition that query index information contains identity identification information, service subject number information and/or service starting time corresponding to personnel to be queried, service data associated with the personnel to be queried is obtained in each data table stored in a database according to the identity identification information, the service subject number information and/or the service starting time corresponding to the personnel to be queried; under the condition that the query index information does not contain the identification information, the service main body number information and the service starting time corresponding to the personnel to be queried, the service data associated with the personnel to be queried is obtained in each data table stored in the database according to the basic information, under the condition that the query index information is partially lost, the service data associated with the personnel to be queried is obtained according to the rest part of the query index information and each data table stored in the database, under the condition that the query index information is completely lost, the service data associated with the personnel to be queried is 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 is allowed to be partially or completely lost, and under the condition that the query index information is partially or completely lost, the personnel can be automatically queried according to the provided information, and acquiring business data associated with personnel, and improving the data query efficiency.

In an optional implementation manner of the embodiment of the present invention, optionally, each data table stored in the database includes: the system comprises a list data table, a service main body number data table and a service data table; the list data table is used for storing list data corresponding to each person, and the list data comprises basic information, identity identification information, service starting auditing time and service data identification corresponding to the person; the service main body number data table is used for storing basic information, identity identification information and service main body number information corresponding to personnel belonging to each service main body; the service data table is used for storing various service data and service data identifications corresponding to the various service data.

In an optional implementation manner of the embodiment of the present invention, optionally, the first data query module 303 is specifically configured to: if the query index information contains the identity identification information and the service starting time corresponding to the person to be queried, determining a first service starting auditing time interval corresponding to the person to be queried according to the service starting time corresponding to the person to be queried; according to the first business starting auditing time interval, acquiring a first list data group corresponding to the person to be inquired in the list data table; the business starting and auditing time in each list data in the first list data group is positioned in the first business starting and auditing time interval; acquiring first target name list data corresponding to the person to be inquired in the first name list data group according to the identity identification information corresponding to the person to be inquired; the identity identification information in the first target name list data is the same as the identity identification information corresponding to the person to be inquired, and the service starting and auditing time in the first target name list data is located in the first service starting and auditing time interval; determining a business data identifier corresponding to the person to be inquired according to the first target name list data, and inquiring a target business data identifier which is the same as the business data identifier corresponding to the person to be inquired in the business data identifiers corresponding to the business data in the business data table; and if the target business data identifier is inquired, determining the business data corresponding to the target business data identifier as the business data associated with the person to be inquired.

In an optional implementation manner of the embodiment of the present invention, optionally, the first data query module 303 is specifically configured to: if the query index information contains the identity identification information corresponding to the person to be queried and does not contain the service starting time corresponding to the person to be queried, determining a second service starting auditing time interval corresponding to the person to be queried according to the receiving time of the person data query request; acquiring a second list data group corresponding to the person to be inquired in the list data table according to the second service starting auditing time interval; the business starting and auditing time in each list data in the second list data group is positioned in the second business starting and auditing time interval; acquiring second target name list data corresponding to the person to be inquired in the second name list data group according to the identity identification information corresponding to the person to be inquired; the identity identification information in the second target name list data is the same as the identity identification information corresponding to the person to be inquired, and the service starting and auditing time in the second target name list data is located in the second service starting and auditing time interval; determining a business data identifier corresponding to the person to be inquired according to the second target name list data, and inquiring a target business data identifier which is the same as the business data identifier corresponding to the person to be inquired in the business data identifiers corresponding to the business data in the business data table; and if the target business data identifier is inquired, determining the business data corresponding to the target business data identifier as the business data associated with the person to be inquired.

In an optional implementation manner of the embodiment of the present invention, optionally, the first data query module 303 is specifically configured to: if the inquiry index information contains the service main body number information and the service starting time corresponding to the to-be-inquired person and does not contain the identity identification information corresponding to the to-be-inquired person, determining a first service starting auditing time interval corresponding to the to-be-inquired person according to the service starting time corresponding to the to-be-inquired person; according to the first business starting auditing time interval, acquiring a first list data group corresponding to the person to be inquired in the list data table; the business starting and auditing time in each list data in the first list data group is positioned in the first business starting and auditing time interval; determining a target business subject to which the person to be inquired belongs according to the business subject identification in the basic information corresponding to the person to be inquired; acquiring identity identification information and service subject number information corresponding to the personnel belonging to the target service subject in the service subject number data table; according to the number information of the business subject corresponding to the person to be inquired, acquiring the identity identification information corresponding to the person to be inquired from the identity identification information corresponding to the person belonging to the target business subject; acquiring first target name list data corresponding to the person to be inquired in the first name list data group; the identity identification information in the first target name list data is the same as the identity identification information corresponding to the person to be inquired, and the service starting and auditing time in the first target name list data is located in the first service starting and auditing time interval; determining a business data identifier corresponding to the person to be inquired according to the first target name list data, and inquiring a target business data identifier which is the same as the business data identifier corresponding to the person to be inquired in the business data identifiers corresponding to the business data in the business data table; and if the target business data identifier is inquired, determining the business data corresponding to the target business data identifier as the business data associated with the person to be inquired.

In an optional implementation manner of the embodiment of the present invention, optionally, the first data query module 303 is specifically configured to: if the inquiry index information contains the service main body number information corresponding to the person to be inquired and does not contain the identity identification information and the service starting time corresponding to the person to be inquired, determining a second service starting auditing time interval corresponding to the person to be inquired according to the receiving time of the person data inquiry request; acquiring a second list data group corresponding to the person to be inquired in the list data table according to the second service starting auditing time interval; the business starting and auditing time in each list data in the second list data group is positioned in the second business starting and auditing time interval; determining a target business subject to which the person to be inquired belongs according to the business subject identification in the basic information corresponding to the person to be inquired; acquiring identity identification information and service subject number information corresponding to the personnel belonging to the target service subject in the service subject number data table; according to the number information of the business subject corresponding to the person to be inquired, acquiring the identity identification information corresponding to the person to be inquired from the identity identification information corresponding to the person belonging to the target business subject; acquiring second target name list data corresponding to the person to be inquired in the second name list data group according to the identity identification information corresponding to the person to be inquired; the identity identification information in the second target name list data is the same as the identity identification information corresponding to the person to be inquired, and the service starting and auditing time in the second target name list data is located in the second service starting and auditing time interval; determining a business data identifier corresponding to the person to be inquired according to the second target name list data, and inquiring a target business data identifier which is the same as the business data identifier corresponding to the person to be inquired in the business data identifiers corresponding to the business data in the business data table; and if the target business data identifier is inquired, determining the business data corresponding to the target business data identifier as the business data associated with the person to be inquired.

In an optional implementation manner of the embodiment of the present invention, optionally, the first data query module 303 is specifically configured to: if the inquiry index information contains the service starting time corresponding to the person to be inquired and does not contain the identity identification information and the service main body number information corresponding to the person to be inquired, determining a first service starting auditing time interval corresponding to the person to be inquired according to the service starting time corresponding to the person to be inquired; according to the first business starting auditing time interval, acquiring a first list data group corresponding to the person to be inquired in the list data table; the business starting and auditing time in each list data in the first list data group is positioned in the first business starting and auditing time interval; acquiring third target name list data corresponding to the person to be inquired in the first name list data group according to the basic information corresponding to the person to be inquired; the basic information in the third target business form data is the same as the basic information corresponding to the person to be inquired, the business starting and auditing time in the third target business form data is located in the first business starting and auditing time interval, and the business starting and auditing time in the third target business form data is the latest business starting and auditing time in each business starting and auditing time in the first business starting and auditing time interval; determining a service data identifier corresponding to the person to be inquired according to the third target name list data, and inquiring a target service data identifier which is the same as the service data identifier corresponding to the person to be inquired in the service data identifiers corresponding to the service data in the service data table; and if the target business data identifier is inquired, determining the business data corresponding to the target business data identifier as the business data associated with the person to be inquired.

In an optional implementation manner of the embodiment of the present invention, optionally, the second data query module 304 is specifically configured to: determining a second business starting auditing time interval corresponding to the personnel to be inquired according to the receiving time of the personnel data inquiry request; acquiring a second list data group corresponding to the person to be inquired in the list data table according to the second service starting auditing time interval; the business starting and auditing time in each list data in the second list data group is positioned in the second business starting and auditing time interval; acquiring fourth target name list data corresponding to the person to be inquired in the second name list data group according to the basic information corresponding to the person to be inquired; the basic information in the fourth target business form data is the same as the basic information corresponding to the person to be inquired, the business starting and auditing time in the fourth target business form data is located in the second business starting and auditing time interval, and the business starting and auditing time in the fourth target business form data is the latest business starting and auditing time in each business starting and auditing time in the second business starting and auditing time interval; determining a service data identifier corresponding to the person to be inquired according to the fourth target name list data, and inquiring a target service data identifier which is the same as the service data identifier corresponding to the person to be inquired in the service data identifiers corresponding to the various service data in the service data table; and if the target business data identifier is inquired, determining the business data corresponding to the target business data identifier as the business data associated with the person to be inquired.

In an optional implementation manner of the embodiment of the present invention, optionally, the personnel data query apparatus further includes: the condition detection module is used for detecting whether the service data meet the preset standard service data condition; the first returning module is used for determining the business data and the data standard prompt information associated with the to-be-inquired person as a data inquiry result if the business data meets a preset standard business data condition, and returning the data inquiry result to the client; and the second returning module is used for determining the service data and the abnormal data prompt information associated with the to-be-inquired person as a data inquiry result if the service data does not meet the preset standard service data condition, and returning the data inquiry result to the client.

With regard to the apparatus in the above-described embodiment, the specific manner in which each module performs the operation has been described in detail in the embodiment related to the method, and will not be elaborated here.

The personnel data query device can execute the personnel data query method provided by any embodiment of the invention, and has the corresponding functional modules and beneficial effects of the personnel data query method.

Example four

Fig. 4 is a schematic structural diagram of a computer device according to a fourth embodiment of the present invention. FIG. 4 illustrates a block diagram of an exemplary computer device 12 suitable for use in implementing embodiments of the present invention. The computer device 12 shown in FIG. 4 is only one example and should not bring any limitations to the functionality or scope of use of embodiments of the present invention.

As shown in FIG. 4, computer device 12 is in the form of a general purpose computing device. The components of computer device 12 may include, but are not limited to: one or more processors 16, a memory 28, and a bus 18 that connects the various system components (including the memory 28 and the processors 16).

Bus 18 represents one or more of any of several types of bus structures, including a memory bus or memory controller, a peripheral bus, an accelerated graphics port, and a processor or local bus using any of a variety of bus architectures. By way of example, such architectures include, but are not limited to, Industry Standard Architecture (ISA) bus, micro-channel architecture (MAC) bus, enhanced ISA bus, Video Electronics Standards Association (VESA) local bus, and Peripheral Component Interconnect (PCI) bus.

Computer device 12 typically includes a variety of computer system readable media. Such media may be any available media that is accessible by computer device 12 and includes both volatile and nonvolatile media, removable and non-removable media.

The 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/nonvolatile computer system storage media. By way of example only, storage system 34 may be used to read from and write to non-removable, nonvolatile magnetic media (not shown in FIG. 4, and commonly referred to as a "hard drive"). Although not shown in FIG. 4, a magnetic disk drive for reading from and writing to a removable, nonvolatile magnetic disk (e.g., a "floppy disk") and an optical disk drive for reading from or writing to a removable, nonvolatile 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 by 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 that are configured to carry out the functions of embodiments of the invention.

A program/utility 40 having a set (at least one) of program modules 42 may be stored, for example, in memory 28, such program modules 42 including, but not limited to, an operating system, one or more application programs, other program modules, and program data, each of which examples or some combination thereof may comprise an implementation of a network environment. Program modules 42 generally carry out the functions and/or methodologies of the described embodiments of the invention.

Computer device 12 may also communicate with one or more external devices 14 (e.g., keyboard, pointing device, display 24, etc.), with one or more devices that enable a user to interact with computer device 12, and/or with any devices (e.g., network card, modem, etc.) that enable computer device 12 to communicate with one or more other computing devices. Such communication may be through an input/output (I/O) interface 22. Also, computer device 12 may communicate with one or more networks (e.g., a Local Area Network (LAN), a Wide Area Network (WAN), and/or a public network such as the Internet) via network adapter 20. As shown, network adapter 20 communicates with the other modules of computer device 12 via bus 18. It should be appreciated that although not shown in FIG. 4, other hardware and/or software modules may be used in conjunction with computer device 12, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems, among others.

The processor 16 executes various functional applications and data processing, such as implementing a person data query method provided by an embodiment of the present invention, by executing programs stored in the memory 28. The method specifically comprises the following steps: acquiring a personnel data query request sent by a client, wherein the personnel data query request carries basic information and query index information corresponding to personnel to be queried; detecting whether the inquiry index information contains identity identification information, service main body number information and/or service starting time corresponding to the personnel to be inquired; if the query index information contains the identity identification information, the service main body number information and/or the service starting time corresponding to the person to be queried, acquiring service data associated with the person to be queried from each data table stored in a database according to the identity identification information, the service main body number information and/or the service starting time corresponding to the person to be queried; if the inquiry index information does not contain the identity identification information, the service main body number information and the service starting time corresponding to the person to be inquired, acquiring service data associated with the person to be inquired from each data table stored in a database according to the basic information; and generating a data query result according to the business data associated with the person to be queried, and returning the data query result to the client.

EXAMPLE five

Fifth embodiment of the present invention provides a computer-readable storage medium, on which a computer program is stored, where when the computer program is executed by a processor, for example, the method for querying personal data provided in the fifth embodiment of the present invention is implemented. The method specifically comprises the following steps: acquiring a personnel data query request sent by a client, wherein the personnel data query request carries basic information and query index information corresponding to personnel to be queried; detecting whether the inquiry index information contains identity identification information, service main body number information and/or service starting time corresponding to the personnel to be inquired; if the query index information contains the identity identification information, the service main body number information and/or the service starting time corresponding to the person to be queried, acquiring service data associated with the person to be queried from each data table stored in a database according to the identity identification information, the service main body number information and/or the service starting time corresponding to the person to be queried; if the inquiry index information does not contain the identity identification information, the service main body number information and the service starting time corresponding to the person to be inquired, acquiring service data associated with the person to be inquired from each data table stored in a database according to the basic information; and generating a data query result according to the business data associated with the person to be queried, and returning the data query result to the client.

Any combination of one or more computer-readable media may be employed. The computer readable medium may be a computer readable signal medium or a computer readable storage medium. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples (a non-exhaustive list) of the computer readable storage medium would include the following: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.

A computer readable signal medium may 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 data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device.

Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.

Computer program code for carrying out operations for aspects of the present invention may 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 may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or computer device. In the case of a remote computer, the remote computer may 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 may be made to an external computer (for example, through the Internet using an Internet service provider).

It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the present invention has been described in greater detail by the above embodiments, the present invention is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present invention, and the scope of the present invention is determined by the scope of the appended claims.

Claims

1. A personnel data query method is characterized by comprising the following steps:

2. The method of claim 1, wherein each data table stored in the database comprises: the system comprises a list data table, a service main body number data table and a service data table;

the list data table is used for storing list data corresponding to each person, and the list data comprises basic information, identity identification information, service starting auditing time and service data identification corresponding to the person;

the service main body number data table is used for storing basic information, identity identification information and service main body number information corresponding to personnel belonging to each service main body;

the service data table is used for storing various service data and service data identifications corresponding to the various service data.

3. The method according to claim 2, wherein the obtaining, according to the identification information, the service agent number information, and/or the service start time corresponding to the person to be queried, service data associated with the person to be queried from each data table stored in a database comprises:

if the query index information contains the identity identification information and the service starting time corresponding to the person to be queried, determining a first service starting auditing time interval corresponding to the person to be queried according to the service starting time corresponding to the person to be queried;

according to the first business starting auditing time interval, acquiring a first list data group corresponding to the person to be inquired in the list data table; the business starting and auditing time in each list data in the first list data group is positioned in the first business starting and auditing time interval;

acquiring first target name list data corresponding to the person to be inquired in the first name list data group according to the identity identification information corresponding to the person to be inquired; the identity identification information in the first target name list data is the same as the identity identification information corresponding to the person to be inquired, and the service starting and auditing time in the first target name list data is located in the first service starting and auditing time interval;

determining a business data identifier corresponding to the person to be inquired according to the first target name list data, and inquiring a target business data identifier which is the same as the business data identifier corresponding to the person to be inquired in the business data identifiers corresponding to the business data in the business data table;

and if the target business data identifier is inquired, determining the business data corresponding to the target business data identifier as the business data associated with the person to be inquired.

4. The method according to claim 2, wherein the obtaining, according to the identification information, the service agent number information, and/or the service start time corresponding to the person to be queried, service data associated with the person to be queried from each data table stored in a database comprises:

if the query index information contains the identity identification information corresponding to the person to be queried and does not contain the service starting time corresponding to the person to be queried, determining a second service starting auditing time interval corresponding to the person to be queried according to the receiving time of the person data query request;

acquiring a second list data group corresponding to the person to be inquired in the list data table according to the second service starting auditing time interval; the business starting and auditing time in each list data in the second list data group is positioned in the second business starting and auditing time interval;

acquiring second target name list data corresponding to the person to be inquired in the second name list data group according to the identity identification information corresponding to the person to be inquired; the identity identification information in the second target name list data is the same as the identity identification information corresponding to the person to be inquired, and the service starting and auditing time in the second target name list data is located in the second service starting and auditing time interval;

determining a business data identifier corresponding to the person to be inquired according to the second target name list data, and inquiring a target business data identifier which is the same as the business data identifier corresponding to the person to be inquired in the business data identifiers corresponding to the business data in the business data table;

5. The method according to claim 2, wherein the obtaining, according to the identification information, the service agent number information, and/or the service start time corresponding to the person to be queried, service data associated with the person to be queried from each data table stored in a database comprises:

if the inquiry index information contains the service main body number information and the service starting time corresponding to the to-be-inquired person and does not contain the identity identification information corresponding to the to-be-inquired person, determining a first service starting auditing time interval corresponding to the to-be-inquired person according to the service starting time corresponding to the to-be-inquired person;

determining a target business subject to which the person to be inquired belongs according to the business subject identification in the basic information corresponding to the person to be inquired;

acquiring identity identification information and service subject number information corresponding to the personnel belonging to the target service subject in the service subject number data table; according to the number information of the business subject corresponding to the person to be inquired, acquiring the identity identification information corresponding to the person to be inquired from the identity identification information corresponding to the person belonging to the target business subject;

acquiring first target name list data corresponding to the person to be inquired in the first name list data group; the identity identification information in the first target name list data is the same as the identity identification information corresponding to the person to be inquired, and the service starting and auditing time in the first target name list data is located in the first service starting and auditing time interval;

6. The method according to claim 2, wherein the obtaining, according to the identification information, the service agent number information, and/or the service start time corresponding to the person to be queried, service data associated with the person to be queried from each data table stored in a database comprises:

if the inquiry index information contains the service main body number information corresponding to the person to be inquired and does not contain the identity identification information and the service starting time corresponding to the person to be inquired, determining a second service starting auditing time interval corresponding to the person to be inquired according to the receiving time of the person data inquiry request;

acquiring identity identification information and service subject number information corresponding to the personnel belonging to the target service subject in the service subject number data table;

according to the number information of the business subject corresponding to the person to be inquired, acquiring the identity identification information corresponding to the person to be inquired from the identity identification information corresponding to the person belonging to the target business subject;

7. The method according to claim 2, wherein the obtaining, according to the identification information, the service agent number information, and/or the service start time corresponding to the person to be queried, service data associated with the person to be queried from each data table stored in a database comprises:

if the inquiry index information contains the service starting time corresponding to the person to be inquired and does not contain the identity identification information and the service main body number information corresponding to the person to be inquired, determining a first service starting auditing time interval corresponding to the person to be inquired according to the service starting time corresponding to the person to be inquired;

acquiring third target name list data corresponding to the person to be inquired in the first name list data group according to the basic information corresponding to the person to be inquired; the basic information in the third target business form data is the same as the basic information corresponding to the person to be inquired, the business starting and auditing time in the third target business form data is located in the first business starting and auditing time interval, and the business starting and auditing time in the third target business form data is the latest business starting and auditing time in each business starting and auditing time in the first business starting and auditing time interval;

determining a service data identifier corresponding to the person to be inquired according to the third target name list data, and inquiring a target service data identifier which is the same as the service data identifier corresponding to the person to be inquired in the service data identifiers corresponding to the service data in the service data table;

8. The method according to claim 2, wherein the obtaining of the business data associated with the person to be queried from each data table stored in a database according to the basic information comprises:

determining a second business starting auditing time interval corresponding to the personnel to be inquired according to the receiving time of the personnel data inquiry request;

acquiring fourth target name list data corresponding to the person to be inquired in the second name list data group according to the basic information corresponding to the person to be inquired; the basic information in the fourth target business form data is the same as the basic information corresponding to the person to be inquired, the business starting and auditing time in the fourth target business form data is located in the second business starting and auditing time interval, and the business starting and auditing time in the fourth target business form data is the latest business starting and auditing time in each business starting and auditing time in the second business starting and auditing time interval;

determining a service data identifier corresponding to the person to be inquired according to the fourth target name list data, and inquiring a target service data identifier which is the same as the service data identifier corresponding to the person to be inquired in the service data identifiers corresponding to the various service data in the service data table;

9. The method of claim 1, after obtaining the business data associated with the person to be queried, further comprising:

detecting whether the service data meet a preset standard service data condition;

if the business data meet the preset standard business data condition, determining the business data and the data standard prompt information associated with the person to be inquired as a data inquiry result, and returning the data inquiry result to the client;

and if the service data does not meet the preset standard service data condition, determining the service data and the abnormal data prompt information associated with the person to be inquired as a data inquiry result, and returning the data inquiry result to the client.

10. A personal data query device, comprising:

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 processor implements the person data query method according to any one of claims 1 to 9 when executing the computer program.

12. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out a person data query method according to any one of claims 1 to 9.