CN112286997B - Salary data query method based on distributed deployment and related equipment - Google Patents
Salary data query method based on distributed deployment and related equipment Download PDFInfo
- Publication number
- CN112286997B CN112286997B CN202011339644.5A CN202011339644A CN112286997B CN 112286997 B CN112286997 B CN 112286997B CN 202011339644 A CN202011339644 A CN 202011339644A CN 112286997 B CN112286997 B CN 112286997B
- Authority
- CN
- China
- Prior art keywords
- query
- path
- user
- data
- salary
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 36
- 230000006870 function Effects 0.000 claims description 19
- 238000013507 mapping Methods 0.000 claims description 9
- 238000012545 processing Methods 0.000 claims description 5
- 238000012546 transfer Methods 0.000 claims description 5
- 238000005516 engineering process Methods 0.000 abstract description 3
- 238000007726 management method Methods 0.000 description 6
- 230000008859 change Effects 0.000 description 4
- 238000004891 communication Methods 0.000 description 4
- 230000008520 organization Effects 0.000 description 4
- 238000013523 data management Methods 0.000 description 3
- 238000010586 diagram Methods 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 238000006467 substitution reaction Methods 0.000 description 3
- 230000006835 compression Effects 0.000 description 2
- 238000007906 compression Methods 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 230000001360 synchronised effect Effects 0.000 description 2
- 230000005540 biological transmission Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 239000000835 fiber Substances 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 230000005055 memory storage Effects 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
- 238000000926 separation method Methods 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2471—Distributed queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
- G06F21/6218—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database
- G06F21/6227—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database where protection concerns the structure of data, e.g. records, types, queries
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Probability & Statistics with Applications (AREA)
- Computational Linguistics (AREA)
- Mathematical Physics (AREA)
- Fuzzy Systems (AREA)
- Health & Medical Sciences (AREA)
- Bioethics (AREA)
- General Health & Medical Sciences (AREA)
- Computer Hardware Design (AREA)
- Computer Security & Cryptography (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The embodiment of the application belongs to the technical field of big data, is applied to the technical field of intelligent enterprises, and relates to a payroll data query method based on distributed deployment, which comprises the steps of receiving a payroll query request sent by a query user, wherein the payroll query request comprises a user identifier, query time and at least one target query object; obtaining an object identifier of a target query object; generating a compensation query path corresponding to the user identifier, the query time and the object identifier based on a path generation policy; and connecting a storage server where the target query object is based on the compensation query path to obtain a query result. The application further relates to a blockchain technology, and the compensation data is also stored in the blockchain. By adopting the method, fragmented salary inquiry is realized on the basis of ensuring the privacy of salary data.
Description
Technical Field
The present application relates to the field of data query technologies, and in particular, to a payroll data query method and apparatus based on distributed deployment, a computer device, and a storage medium.
Background
When the data is searched and inquired, the method is indispensable in daily life and information system operation, and can help us to accurately locate the content to be understood in a large amount of data. The conventional query function is generally displayed on a page after the matched content is positioned by keywords or query conditions, or a standard interface is provided for a peripheral system or a module to call, so that the query is realized. Besides the conventional payroll and payroll on the page, the payroll inquiry scene has more fragmented inquiry scenes, such as payroll of staff in the same post or current payroll of staff when the payroll post is paid and adjusted, and a linear manager needs to check the historical payroll and the current payroll of staff when the payroll adjustment and approval are checked; when the salary is maintained, the salary post needs to quickly look up the staff's salary file. Accurate and complete staff compensation data is required in all of these scenarios.
However, the departments and posts where the staff is located and even the salary of the staff can change in a period of time, which causes confusion in salary data management. For example, staff's job position and salary information at different times, including different dimensional data such as design salary, real salary, etc. are different, for example staff a is a first department product manager when entering work in month 1 in 2020, wages are 2 tens of thousands, 1.8 tens of thousands are sent in the first month, and 1.9 tens of thousands are sent in the second month; in the third month, the second department was adjusted to make a demand analyst, the wages were adjusted to 3 ten thousand, and in the third month, 2.8 ten thousand were sent. The employee's data is combined into an employee-based payroll file for storing employee's payroll information at different times.
In such a scenario, it is often impossible to realize fragmented salary query on the basis of ensuring the privacy of salary data.
Disclosure of Invention
Based on the above technical problems, the application provides a payroll data query method, device, computer equipment and storage medium based on distributed deployment, which are used for solving the technical problems that payroll data are numerous and complex in the prior art, and fragmented query cannot be realized on the basis of guaranteeing user data privacy.
A payroll data query method based on distributed deployment is applied to a payroll management system with payroll data transfer, and the method comprises the following steps:
Receiving a salary query request sent by a query user, wherein the salary query request comprises a user identifier, query time and at least one target query object;
Obtaining an object identifier of a target query object;
Generating a compensation query path corresponding to the user identifier, the query time and the object identifier based on a path generation policy;
and connecting a storage server where the target query object is based on the compensation query path to obtain a query result.
A payroll data query device based on distributed deployment is applied to a payroll management system with payroll data transfer, and comprises:
The system comprises a receiving module, a processing module and a processing module, wherein the receiving module is used for receiving a compensation inquiry request sent by an inquiring user, and the compensation inquiry request comprises a user identification, inquiry time and at least one target inquiry object;
The identification module is used for acquiring the object identification of the target query object;
The path module is used for generating a compensation query path corresponding to the user identifier, the query time and the object identifier based on a path generation strategy;
And the query module is used for connecting the storage server where the target query object is located based on the compensation query path to obtain a query result.
A computer device comprising a memory and a processor, and computer readable instructions stored in the memory and executable on the processor, which when executed by the processor implement the steps of the distributed deployment-based payroll data query method described above.
A computer readable storage medium storing computer readable instructions which when executed by a processor implement the steps of the distributed deployment-based payroll data query method described above.
According to the salary data query method, device, computer equipment and storage medium based on distributed deployment, the user identification, query time and target query object in the user query request are directly acquired, the salary query path is generated based on the path generation strategy, and the position of salary data to be queried on the storage server can be rapidly located. In addition, the application also limits whether specific pay data can be obtained or not by inquiring the preset authority of the user according to the user identification, otherwise only the storage position of the pay data to be inquired can be obtained instead of the specific pay data, the security of privacy data is ensured to a certain extent, and the fragmented data inquiry is realized by directly obtaining the user-defined input multidimensional information to generate an inquiry path. In addition, the proposal also determines the group information of the target user object queried by the querying user according to the object identification of the querying user, and then determines the data information of the target user object under different group information according to the group information, and the group authority can realize the independent control of the historical salary data, thereby increasing the privacy protection capability.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings that are needed in the description of the embodiments of the present invention will be briefly described below, it being obvious that the drawings in the following description are only some embodiments of the present invention, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a schematic diagram of an application environment for a payroll data query method based on distributed deployment;
FIG. 2 is a flow chart of a distributed deployment-based salary data query method;
FIG. 3 is a schematic diagram of a distributed deployment-based payroll data querying device;
FIG. 4 is a schematic diagram of a computer device in one embodiment.
Detailed Description
Unless defined otherwise, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this application belongs; the terminology used in the description of the applications herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the application; the terms "comprising" and "having" and any variations thereof in the description of the application and the claims and the description of the drawings above are intended to cover a non-exclusive inclusion. The terms first, second and the like in the description and in the claims or in the above-described figures, are used for distinguishing between different objects and not necessarily for describing a sequential or chronological order.
Reference herein to "an embodiment" means that a particular feature, structure, or characteristic described in connection with the embodiment may be included in at least one embodiment of the application. The appearances of such phrases in various places in the specification are not necessarily all referring to the same embodiment, nor are separate or alternative embodiments mutually exclusive of other embodiments. Those of skill in the art will explicitly and implicitly appreciate that the embodiments described herein may be combined with other embodiments.
The present application will be described in further detail with reference to the drawings and examples, in order to make the objects, technical solutions and advantages of the present application more apparent. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the application. All other embodiments, which can be made by those skilled in the art based on the embodiments of the application without making any inventive effort, are intended to be within the scope of the application.
The salary data query method based on distributed deployment provided by the embodiment of the invention can be applied to an application environment shown in figure 1. The application environment may include, among other things, a terminal 102, a network for providing a communication link medium between the terminal 102 and the server 104, and a server 104, which may include various connection types, such as wired, wireless communication links, or fiber optic cables, etc.
A user may interact with the server 104 through a network using the terminal 102 to receive or send messages, etc. The terminal 102 may have installed thereon various communication client applications such as web browser applications, shopping class applications, search class applications, instant messaging tools, mailbox clients, social platform software, and the like.
The terminal 102 may be a variety of electronic devices having a display screen and supporting web browsing, including but not limited to smartphones, tablet computers, electronic book readers, MP3 players (Moving Picture Experts Group Audio Layer III, dynamic video expert compression standard audio plane 3), MP4 (Moving Picture Experts Group Audio Layer IV, dynamic video expert compression standard audio plane 4) players, laptop and desktop computers, and the like.
The server 104 may be a server that provides various services, such as a background server that provides support for pages displayed on the terminal 102.
It should be noted that, the payroll data query method based on distributed deployment provided by the embodiment of the present application is generally executed by a server/terminal, and accordingly, the payroll data query device based on distributed deployment is generally set in the server/terminal device.
The application is operational with numerous general purpose or special purpose computer system environments or configurations. For example: personal computers, server computers, hand-held or portable devices, tablet devices, multiprocessor systems, microprocessor-based systems, set top boxes, programmable consumer electronics, network PCs, minicomputers, mainframe computers, distributed computing environments that include any of the above systems or devices, and the like. The application may be described in the general context of computer-executable instructions, such as program modules, being executed by a computer. Generally, program modules include routines, programs, objects, components, data structures, etc. that perform particular tasks or implement particular abstract data types. The application may also be practiced in distributed computing environments where tasks are performed by remote processing devices that are linked through a communications network. In a distributed computing environment, program modules may be located in both local and remote computer storage media including memory storage devices.
The method and the system can be applied to the field of intelligent enterprises so as to promote the construction of intelligent cities, for example, the technical scheme of the application is applied to a salary data query platform or a salary data management system of the enterprises.
It should be understood that the number of terminals, networks and servers in fig. 1 is merely illustrative. There may be any number of terminal devices, networks, and servers, as desired for implementation.
Wherein the terminal 102 communicates with the server 104 through a network. The server 104 receives a salary query request sent by a query user through the terminal 102, generates a salary query path according to a user identifier, a query time and at least one target query object in the salary query request, queries on a storage server based on the salary query path to obtain salary data of the target query object, and returns a query result to the terminal 102. The terminal 102 and the server 104 are connected through a network, which may be a wired network or a wireless network, where the terminal 102 may be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers, and portable wearable devices, and the server 104 may be implemented by an independent server or a server cluster formed by a plurality of servers.
In one embodiment, as shown in fig. 2, a payroll data query method based on distributed deployment is provided, and the method is applied to the server in fig. 1 for illustration, and includes the following steps:
step 202, receiving a salary query request sent by a query user, wherein the salary query request comprises a user identifier, a query time and at least one target query object.
The technical scheme of the application can be applied to a salary management system or a salary management platform with salary data stored and transferred, in particular to a salary data management platform in which the salary data of staff can change in storage position due to work mobilization and the inquiry authority of an inquiring user can be limited.
The salary query request refers to a request that a user sends salary data query to a server through a terminal, where the terminal may be a PC terminal, a mobile terminal, etc. with an operating system installed. The salary query request includes a user identification of the querying user, i.e., a code or label for identifying the unique identity of the querying user; the query time is a time range of the queried data set by a user according to the needs; the target query object is salary data of the object to be queried.
For example, the query user is an enterprise HR, and the enterprise HR sets salary data of staff in a department between 2019/7 month and 2020 month according to needs, then the target query object may be input, and the terminal may automatically package the query time input by the query user and the obtained user identifier of the query user, where the user identifier may be an account number of the user logged in to the system by the query user, and the login account number may be one of an identity card, a staff number, or a user mailbox of the query user.
Step 204, obtaining the object identification of the target query object.
The target query object can be a certain department, a certain staff under a certain department, various choices of different staff under different departments and the like, and an operation interface for querying the user can be arranged on the terminal, so that the input of the user is queried. The object identifier is a unique identifier of a department corresponding to the server or staff under the department. When the target query object is a door, then the object is identified as one type, and when the target query object is an employee, the object is identified as another type. Specifically, the object identification representing the department may be: dept001, dept002 … … the object identifiers of the staff members are Dept001user001, dept001user002 … … the object identifiers of the present embodiment are for illustration only and not for limitation.
Specifically, when the target query object is all employee objects under any department, the department number of the department is obtained and used as an object identifier; when the target query object is a different employee object under a different department, acquiring one of employee numbers or employee identity cards of all employee objects as an object identifier; when the target query object is a certain employee object under a certain department, the employee number or the employee identification card of the employee object is obtained and used as the object identification.
Further, the object identification of the target query object is stored in the storage server, and can also be stored in the user server in a backup way.
Step 206, generating a compensation query path corresponding to the user identification, the query time and the object identification based on the path generation policy.
The payroll query path is a mapped path for querying payroll data on a user's connection to a storage server, and may be generated based on a path generation policy. Specifically: positioning a query user resource library of a query user on a storage server according to the user identification; acquiring authority information from a query user resource library according to the user identification so as to determine whether the query user has query authority; and generating a compensation query path according to the query time and the object identification based on the query authority.
The identity information and the authority information of the inquiring user are stored in the inquiring user resource library, whether the inquiring user has the right to acquire certain appointed salary data can be confirmed, and then a salary inquiring path is generated according to the inquiring time and the object identification based on the inquiring authority. Wherein determining rights information of the querying user includes:
Determining the identity information of the inquiring user according to the user identification; acquiring the function authority and the data authority of the inquiring user according to the identity information; judging whether the salary inquiry request is valid or not based on the function authority; if so, determining whether a first affiliated relationship exists between the inquiring user and the object identifier according to the data authority; if yes, determining that the inquiring user has inquiring authority; if not, determining that the inquiring user does not have the inquiring authority; if not, determining that the inquiring user does not have the inquiring authority.
The function authority is realized by associating a user role with a function or page of a salary query platform or a salary management system; a querying user may have multiple roles, each containing different functions, and the scope of available functions for the querying user is made up of a union of the functions of the roles.
When inquiring, the inquiring user sends a salary inquiring request to the salary inquiring system through the user terminal, the salary inquiring system can acquire the login account number of the inquiring user automatically as a user identifier, and after receiving the salary inquiring request comprising the user identifier, the server receives the salary inquiring request, and then acquires the user identifier from the salary inquiring request, and acquires the corresponding inquiring user resource library from the storage server, so as to acquire the corresponding authority information.
When judging the authority, if the function authority possessed by the inquiring user does not correspond to the salary inquiry request, the inquiring user is not capable of inquiring salary data of staff, namely the inquiring user does not possess inquiry authority for inquiring salary data, the salary inquiry data sent by the user is invalid, if the salary inquiry data is invalid, the user is directly sent to the inquiring user to be provided with no inquiry authority, and prompt of inquiry is carried out after acquiring the authority; if the query user has the function authority of the salary query, the salary query request is effective, and whether the first belonged relationship exists between the user and the object identifier is determined according to the data authority of the query user. Wherein the first affiliation is generally comprised of an organization assigned to the querying user and a timeline of data generation. A querying user may have the authority of multiple organizations, and the querying user may view the data of these organizations, for example, a querying user enterprise HR may view all salary data from the entering position to all the present day of all the common staff members of the subsidiary to which it belongs, or may view salary data of the subordinate staff members of the department to which it belongs. It should be noted that, when one query user belongs to an organization for management, other query users having the authority of the organization can also view salary data or other privacy data generated by the current query user under the organization.
If the first affiliated relation exists or the query user is endowed with the first affiliated relation, the query user is provided with query authority, if the first affiliated relation does not exist, the query user can use a salary query function, and salary data of a target query object to be queried cannot be obtained, namely the target query object does not have query authority.
In some embodiments, the application realizes the data authority separation in the authority limiting mode, and ensures the security and privacy of the data.
Further, in some embodiments, generating a payroll query path according to the query time and the object identification based on the query authority specifically includes:
When the object identification is a department number and the inquiring user has the inquiring right, determining a main storage path of salary data of the target inquiring object on the storage server according to the department number; and splicing the query time and at least one department number to the back of the main storage path as a mapping path of the salary data of the target query object to obtain a salary query path. The main storage path is a storage position of salary data on a storage server, the storage server stores salary data of a target query object, personal information of a user query object related to the salary data and the like, and different salary data may be stored in different databases on the storage server, so that the main storage path of the salary data to be queried on the storage server needs to be acquired for data positioning. This may improve the efficiency of data querying. In general, the salary data of all employees of a department are stored in the same position on the storage server, so that only the main storage path of the whole department is required to be acquired, the salary data is screened according to the inquiry time, and then the inquiry time and the department number are spliced to the rear of the main storage path to be used as a mapping path. Wherein the mapping path may change according to a query time of the querying user and a change in object identification of the target query object.
When the object identifier is one of an employee number or an employee identification card and the inquiring user has the inquiring right, determining at least one main storage path of salary data of the target inquiring object on the storage server according to the employee number or the employee identification card; obtaining preview compensation data of the target query object from each main storage path, storing the preview compensation data in a cache server, and generating a preview storage path of the preview compensation data; and splicing the query time and at least one employee number or one employee identification card to the rear of the preview storage path as a mapping path of preview salary data of the target query object to obtain a salary query path.
When inquiring a person or a plurality of persons inputted by a user and serving as different departments, because the main storage paths of the inquired salary data on the storage server are different, the positions of the salary data on the storage server are required to be positioned according to the object identification, the salary data stored in the different positions are cached in the cache server, a preview storage path is generated, and then the inquiring time and at least one employee number or one employee identification card are spliced behind the preview storage path to be used as the mapping path of the preview salary data of the target inquiring object, so as to obtain a salary inquiring path.
Furthermore, the generation of the salary query path is not only limited to the query time and the object identification, but also supports a plurality of parameters such as the data caliber, the data open source and the like, and can be correspondingly realized as long as the user inputs the parameters as a salary query request. By the method, various fragmented queries can be realized, and the data query efficiency can be greatly improved.
Further, because there may be a store transfer of salary data for the same employee, to further ensure efficiency and privacy of salary data queries, in some embodiments, it may also be possible to: determining group information of a target query object according to the object identification, wherein the group information comprises current group information and historical group information;
When the inquiring user has the inquiring right, judging whether the inquiring right and the group information are matched or not, and obtaining a matching result; if the matching result is that the query authority corresponds to the current group information, acquiring a first storage path of salary data of the target query user under the current group information on a storage server; obtaining a second storage path of salary data under the history group information of the target query path on the storage server; splicing the query time and the object identification to the back of the first storage path to be used as a first query path; the query time and object identification are spliced to the second storage path back as a second query path.
If the matching result is that the query authority corresponds to the history group information, a second storage path of salary data under the history group information of the target query user on the storage server is obtained; and concatenating the query time and the object identification to the second storage path back as a second query path.
The first query path and the second query path are query paths respectively connected to different salary data of the target user object. Specifically, because the salary data of the target user object is stored in a classified manner, salary of different time periods may be stored in different databases, and when the salary data is queried, it is impossible to acquire all the salary data. The group information of the target user object can be determined according to the user identification, wherein the group information is the current group and the historical group of the user object. Specifically, an employee is in the department a in 2019, but in the department B in 2020, the data generated by each department is automatically stored under the classification of the department, so that salary data of the overall target user object cannot be obtained only according to information input by the querying user. Therefore, a plurality of inquiry paths can be respectively generated according to the current group and the historical group of the target user object, and the inquiry paths are linked to salary data of a plurality of dimensions, so that the technical problems are solved.
Wherein, whether the query authority corresponds to the group information or not means that when the query authority of the query user is: when the system has the function of inquiring the salary data of all staff members under the department B, the current group information of a staff member, namely the current department can be the department B, and the historical department is the department A, but the corresponding relation between the inquiry authority and the current group information is not influenced; in this case, it is explained that the inquiring user can acquire the salary data under the current group information of the target inquiring user and the salary data under the history group information thereof.
If the current group information of the staff member is the A department and the historical department is the B department, the inquiry authority is not corresponding to the current group information, and the inquiry user cannot acquire the salary data of the user under the current A department, but still can acquire the salary data generated by the user under the historical department B department. In this embodiment, just in this case, the salary query path is divided into the first query path and the second query path, so that the risk of leakage of the private information of the staff member can be avoided.
And step 208, connecting a storage server where the target query object is located based on the compensation query path to obtain a query result.
After obtaining the salary query path, the terminal can be connected to a storage server to directly obtain corresponding salary data, and the obtained query result is returned to the terminal. It is emphasized that to further ensure the privacy and security of the payroll data, the payroll data may also be stored in a node of a blockchain.
In the salary data query method based on distributed deployment, the salary query path is generated based on the path generation strategy by directly acquiring the user identification, the query time and the target query object in the user query request, so that the position of the salary data to be queried on the storage server can be rapidly positioned. In addition, the application also limits whether specific pay data can be obtained or not by inquiring the preset authority of the user according to the user identification, otherwise only the storage position of the pay data to be inquired can be obtained instead of the specific pay data, the security of privacy data is ensured to a certain extent, and the fragmented data inquiry is realized by directly obtaining the user-defined input multidimensional information to generate an inquiry path. In addition, the proposal also determines the group information of the target user object queried by the querying user according to the object identification of the querying user, and then determines the data information of the target user object under different group information according to the group information, and the group authority can realize the independent control of the historical salary data, thereby increasing the privacy protection capability.
It should be understood that, although the steps in the flowchart of fig. 2 are shown in sequence as indicated by the arrows, the steps are not necessarily performed in sequence as indicated by the arrows. The steps are not strictly limited to the order of execution unless explicitly recited herein, and the steps may be executed in other orders. Moreover, at least some of the steps in FIG. 2 may include multiple sub-steps or stages that are not necessarily performed at the same time, but may be performed at different times, nor do the order in which the sub-steps or stages are performed need to be sequential, but may be performed in turn or alternately with at least some of the other steps or sub-steps of other steps.
In one embodiment, as shown in fig. 3, a payroll data query device based on distributed deployment is provided, where the payroll data query device based on distributed deployment corresponds to the payroll data query method based on distributed deployment in the above embodiment one by one. The salary data query device based on distributed deployment comprises:
a receiving module 302, configured to receive a salary query request sent by a querying user, where the salary query request includes a user identifier, a query time, and at least one target query object;
an identification module 304, configured to obtain an object identification of the target query object;
A path module 306, configured to generate a compensation query path corresponding to the user identifier, the query time, and the object identifier based on the path generation policy;
And a query module 308, configured to connect to a storage server where the target query object is located based on the payroll query path, to obtain a query result.
Further, the identification module 304 includes:
the first identification sub-module is used for acquiring department numbers of departments as object identifications when the target query object is all employee objects under any department;
the second identification sub-module is used for acquiring one of employee numbers or employee identity cards of all employee objects as an object identification when the target query object is different employee objects in different departments;
and the third identification sub-module is used for acquiring the employee number or the employee identification card of the employee object as the object identification when the target query object is a certain employee object under a certain department.
Further, the path module 306 includes:
the resource sub-module is used for positioning a query user resource library of a query user on the storage server according to the user identification;
The permission sub-module is used for acquiring permission information from the inquiring user resource library according to the user identification so as to determine whether the inquiring user has inquiring permission;
and the path sub-module is used for generating a compensation query path according to the query time and the object identification based on the query authority.
Further, the authority sub-module includes:
the identity unit is used for determining the identity information of the inquiring user according to the user identification;
The authority unit is used for acquiring the function authority and the data authority of the inquiring user according to the identity information;
a judging unit for judging whether the salary inquiry request is valid or not based on the function authority;
The relation unit is used for determining whether a first affiliated relation exists between the inquiring user and the object identifier according to the data authority if the relation unit is effective;
the first right confirming unit is used for confirming that the inquiring user has inquiring right if the first right confirming unit exists;
The second right determining unit is used for determining that the inquiring user does not have the inquiring right if the second right determining unit does not exist;
And the third right determining unit is used for determining that the inquiring user does not have the inquiring right if the inquiring user is invalid.
Further, the path submodule includes:
the first query unit is used for determining a main storage path of the salary data of the target query object on the storage server according to the department number when the object identifier is the department number and the query user has the query right;
The first path unit is used for splicing the query time and at least one department number to the back of the main storage path and taking the query time and the at least one department number as a mapping path of salary data of a target query object to obtain a salary query path;
The second query unit is used for determining at least one main storage path of salary data of the target query object on the storage server according to the employee number or the employee identification card when the object identification is one of the employee number or the employee identification card and the query user has the query right; and is combined with
The third query unit is used for acquiring preview salary data of the target query object from each main storage path, storing the preview salary data into the cache server and generating a preview storage path of the preview salary data; and is combined with
And the second path unit is used for splicing the query time and at least one employee number or one employee identification card to the rear of the preview storage path and taking the query time and the at least one employee number or one employee identification card as a mapping path of preview salary data of the target query object to obtain a salary query path.
Further, the path module 306 includes:
The group sub-module is used for determining group information of the target query object according to the object identification, wherein the group information comprises current group information and historical group information;
the first matching sub-module is used for judging whether the query authority and the group information are matched or not when the query user has the query authority, so as to obtain a matching result;
The first storage sub-module is used for acquiring a first storage path of salary data of the target query user under the current group information on the storage server if the matching result is that the query authority corresponds to the current group information; and is combined with
The second storage sub-module is used for acquiring a second storage path of salary data on the storage server under the history group information of the target query path;
the first path submodule is used for splicing the query time and the object identifier to the back of the first storage path to be used as a first query path;
the second path submodule is used for splicing the query time and the object identification to the rear of the second storage path to be used as a second query path;
The second matching sub-module is used for acquiring a second storage path of the salary data under the history group information of the target query user on the storage server if the matching result is that the query authority corresponds to the history group information; and is combined with
And the third path submodule is used for splicing the query time and the object identification to the rear of the second storage path to be used as a second query path.
It is emphasized that to further ensure the privacy and security of the payroll data, the payroll data may also be stored in a node of a blockchain.
According to the salary data query device based on distributed deployment, the user identification, the query time and the target query object in the user query request are directly acquired, the salary query path is generated based on the path generation strategy, and the position of salary data to be queried on the storage server can be rapidly located. In addition, the application also limits whether specific pay data can be obtained or not by inquiring the preset authority of the user according to the user identification, otherwise only the storage position of the pay data to be inquired can be obtained instead of the specific pay data, the security of privacy data is ensured to a certain extent, and the fragmented data inquiry is realized by directly obtaining the user-defined input multidimensional information to generate an inquiry path. In addition, the proposal also determines the group information of the target user object queried by the querying user according to the object identification of the querying user, and then determines the data information of the target user object under different group information according to the group information, and the group authority can realize the independent control of the historical salary data, thereby increasing the privacy protection capability.
In one embodiment, a computer device is provided, which may be a server, the internal structure of which may be as shown in fig. 4. The computer device includes a processor, a memory, a network interface, and a database connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, computer readable instructions, and a database. The internal memory provides an environment for the execution of an operating system and computer-readable instructions in a non-volatile storage medium. The database of the computer device is for storing compensation data. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer readable instructions, when executed by a processor, implement a payroll data query method based on a distributed deployment. By directly acquiring the user identification, the query time and the target query object in the user query request, generating a payroll query path based on the path generation strategy, the position of payroll data to be queried on the storage server can be rapidly positioned. In addition, the application also limits whether specific pay data can be obtained or not by inquiring the preset authority of the user according to the user identification, otherwise only the storage position of the pay data to be inquired can be obtained instead of the specific pay data, the security of privacy data is ensured to a certain extent, and the fragmented data inquiry is realized by directly obtaining the user-defined input multidimensional information to generate an inquiry path. In addition, the proposal also determines the group information of the target user object queried by the querying user according to the object identification of the querying user, and then determines the data information of the target user object under different group information according to the group information, and the group authority can realize the independent control of the historical salary data, thereby increasing the privacy protection capability.
It will be appreciated by those skilled in the art that the computer device herein is a device capable of automatically performing numerical calculation and/or information processing according to a preset or stored instruction, and its hardware includes, but is not limited to, a microprocessor, an Application SPECIFIC INTEGRATED Circuit (ASIC), a Programmable gate array (Field-Programmable GATE ARRAY, FPGA), a digital Processor (DIGITAL SIGNAL Processor, DSP), an embedded device, and the like.
In one embodiment, a computer readable storage medium is provided, on which computer readable instructions are stored, which when executed by a processor, implement the steps of the distributed deployment based payroll data querying method in the above embodiment, such as steps 202 to 208 shown in fig. 2, or the processor, when executing the computer readable instructions, implement the functions of the modules/units of the distributed deployment based payroll data querying device in the above embodiment, such as the functions of modules 302 to 308 shown in fig. 3.
According to the embodiment, the user identification, the query time and the target query object in the user query request are directly acquired, the payroll query path is generated based on the path generation strategy, and the position of payroll data to be queried on the storage server can be rapidly located. In addition, the application also limits whether specific pay data can be obtained or not by inquiring the preset authority of the user according to the user identification, otherwise only the storage position of the pay data to be inquired can be obtained instead of the specific pay data, the security of privacy data is ensured to a certain extent, and the fragmented data inquiry is realized by directly obtaining the user-defined input multidimensional information to generate an inquiry path. In addition, the proposal also determines the group information of the target user object queried by the querying user according to the object identification of the querying user, and then determines the data information of the target user object under different group information according to the group information, and the group authority can realize the independent control of the historical salary data, thereby increasing the privacy protection capability.
Those skilled in the art will appreciate that implementing all or part of the processes of the methods of the embodiments described above may be accomplished by instructing the associated hardware by computer readable instructions stored on a non-transitory computer readable storage medium, which when executed may comprise processes of embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in embodiments provided herein may include non-volatile and/or volatile memory. The nonvolatile memory can include Read Only Memory (ROM), programmable ROM (PROM), electrically Programmable ROM (EPROM), electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double Data Rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous link (SYNCHLINK) DRAM (SLDRAM), memory bus (rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), among others.
The blockchain is a novel application mode of computer technologies such as distributed data storage, point-to-point transmission, consensus mechanism, encryption algorithm and the like. The blockchain (Blockchain), essentially a de-centralized database, is a string of data blocks that are generated in association using cryptographic methods, each of which contains information from a batch of network transactions for verifying the validity (anti-counterfeit) of its information and generating the next block. The blockchain may include a blockchain underlying platform, a platform product services layer, an application services layer, and the like.
It will be apparent to those skilled in the art that, for convenience and brevity of description, only the above-described division of the functional units and modules is illustrated, and in practical application, the above-described functional distribution may be performed by different functional units and modules according to needs, i.e. the internal structure of the apparatus is divided into different functional units or modules to perform all or part of the above-described functions.
The technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.
The above examples illustrate only a few embodiments of the application, which are described in detail and are not to be construed as limiting the scope of the application. It should be noted that, for those skilled in the art, it is possible to make several modifications, improvements or equivalent substitutions for some technical features without departing from the concept of the present application, and these modifications or substitutions do not make the essence of the same technical solution deviate from the spirit and scope of the technical solution of the embodiments of the present application, and all the modifications or substitutions fall within the protection scope of the present application. Accordingly, the scope of protection of the present application is to be determined by the appended claims.
Claims (6)
1. A payroll data query method based on distributed deployment, applied to a payroll management system with payroll data transfer, characterized in that the method comprises the following steps:
Receiving a salary query request sent by a query user, wherein the salary query request comprises a user identifier, query time and at least one target query object;
Obtaining an object identifier of a target query object;
Generating a compensation query path corresponding to the user identifier, the query time and the object identifier based on a path generation policy;
Connecting a storage server where the target query object is located based on the compensation query path to obtain a query result;
the target query object is all employee objects under any department, different employee objects under different departments, or a certain employee object under a certain department, and the obtaining the object identifier of the target query object includes:
when the target query object is all employee objects under any department, acquiring department numbers of the departments as the object identifiers;
When the target query object is a different employee object under a different department, acquiring one of employee numbers or employee identity cards of all employee objects as the object identification;
When the target query object is a certain employee object under a certain department, acquiring an employee number or an employee identification card of the employee object as the object identifier;
the generating a payroll query path corresponding to the user identification, the query time and the object identification based on the path generation policy comprises:
Positioning a query user resource library of the query user on a storage server according to the user identification;
acquiring authority information from the inquiring user resource library according to the user identification so as to determine whether the inquiring user has inquiring authority;
generating the salary query path according to the query time and the object identifier based on the query authority;
The obtaining authority information from the inquiring user resource library according to the user identification to determine whether the inquiring user has the inquiring authority comprises the following steps:
Determining the identity information of the inquiring user according to the user identification;
Acquiring the function authority and the data authority of the inquiring user according to the identity information;
judging whether the salary inquiry request is valid or not based on the function authority;
if so, determining whether a first affiliated relationship exists between the inquiring user and the object identifier according to the data authority;
if yes, determining that the inquiring user has the inquiring authority;
If not, determining that the inquiring user does not have the inquiring authority;
if not, determining that the inquiring user does not have the inquiring authority;
The generating the salary query path according to the query time and the object identifier based on the query authority includes:
when the object identification is a department number and the query user has the query right, determining a main storage path of salary data of the target query object on the storage server according to the department number;
splicing the query time and at least one department number to the back of the main storage path to be used as a mapping path of salary data of the target query object, so as to obtain the salary query path;
when the object identifier is one of an employee number or an employee identification card and the inquiring user has the inquiring right, determining at least one main storage path of salary data of the target inquiring object on the storage server according to the employee number or the employee identification card; and is combined with
Obtaining preview compensation data of the target query object from each main storage path, storing the preview compensation data in a cache server, and generating a preview storage path of the preview compensation data; and is combined with
And splicing the query time and at least one of the employee numbers or employee identity cards to the rear of the preview storage path to serve as a mapping path of preview salary data of the target query object, so as to obtain the salary query path.
2. The method of claim 1, wherein the payroll query path comprises a first query path and a second query path, wherein the generating payroll query paths corresponding to the user identification, the query time, and the object identification based on a path generation policy comprises:
Determining group information of the target query object according to the object identification, wherein the group information comprises current group information and historical group information;
When the inquiring user has the inquiring right, judging whether the inquiring right and the group information are matched or not, and obtaining a matching result;
If the matching result is that the query authority corresponds to the current group information, a first storage path of salary data of the target query object under the current group information on a storage server is obtained; and is combined with
Acquiring a second storage path of salary data under the history group information of the target query object on a storage server;
splicing the query time and the object identification to the back of a first storage path to be used as the first query path;
Splicing the query time and the object identification to the rear of a second storage path to be used as the second query path;
If the matching result is that the query authority corresponds to the history group information, a second storage path of salary data of the target query object under the history group information on a storage server is obtained; and is combined with
And splicing the query time and the object identification to the rear of a second storage path to serve as the second query path.
3. The method of claim 1, wherein the compensation data is stored in a blockchain.
4. A payroll data query device based on distributed deployment, applied to a payroll management system with payroll data transfer, wherein the payroll data query device is capable of realizing the method of any one of claims 1 to 3 when running, and the payroll data query device comprises:
The system comprises a receiving module, a processing module and a processing module, wherein the receiving module is used for receiving a compensation inquiry request sent by an inquiring user, and the compensation inquiry request comprises a user identification, inquiry time and at least one target inquiry object;
The identification module is used for acquiring the object identification of the target query object;
The path module is used for generating a compensation query path corresponding to the user identifier, the query time and the object identifier based on a path generation strategy;
And the query module is used for connecting the storage server where the target query object is located based on the compensation query path to obtain a query result.
5. A computer device comprising a memory storing computer readable instructions and a processor, wherein the processor when executing the computer readable instructions performs the steps of the method of any one of claims 1 to 3.
6. A computer readable storage medium having stored thereon computer readable instructions, which when executed by a processor, implement the steps of the method of any of claims 1 to 3.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202011339644.5A CN112286997B (en) | 2020-11-25 | 2020-11-25 | Salary data query method based on distributed deployment and related equipment |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202011339644.5A CN112286997B (en) | 2020-11-25 | 2020-11-25 | Salary data query method based on distributed deployment and related equipment |
Publications (2)
Publication Number | Publication Date |
---|---|
CN112286997A CN112286997A (en) | 2021-01-29 |
CN112286997B true CN112286997B (en) | 2024-04-16 |
Family
ID=74426736
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202011339644.5A Active CN112286997B (en) | 2020-11-25 | 2020-11-25 | Salary data query method based on distributed deployment and related equipment |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN112286997B (en) |
Families Citing this family (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN113743807B (en) * | 2021-09-09 | 2024-03-05 | 多点(深圳)数字科技有限公司 | Scheduling information generation method, device, electronic equipment and computer readable medium |
CN114490781B (en) * | 2022-04-01 | 2022-07-22 | 中国信息通信研究院 | Block chain data processing method and device |
CN116308225B (en) * | 2023-01-16 | 2024-04-16 | 深圳市润迅数智科技有限公司 | Human resource management system and method with intelligent accounting salary |
CN115858885B (en) * | 2023-02-28 | 2023-06-30 | 美云智数科技有限公司 | Account book data query method, device, computer equipment and storage medium |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN106339415A (en) * | 2016-08-12 | 2017-01-18 | 北京奇虎科技有限公司 | Data checking method, device and system |
CN108563788A (en) * | 2018-04-27 | 2018-09-21 | 腾讯科技(深圳)有限公司 | Data query method, apparatus, server and storage medium based on block chain |
CN109658050A (en) * | 2018-11-12 | 2019-04-19 | 深圳壹账通智能科技有限公司 | A kind of management method and equipment of wage report |
CN110580414A (en) * | 2019-11-08 | 2019-12-17 | 支付宝(杭州)信息技术有限公司 | private data query method and device based on block chain account |
-
2020
- 2020-11-25 CN CN202011339644.5A patent/CN112286997B/en active Active
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN106339415A (en) * | 2016-08-12 | 2017-01-18 | 北京奇虎科技有限公司 | Data checking method, device and system |
CN108563788A (en) * | 2018-04-27 | 2018-09-21 | 腾讯科技(深圳)有限公司 | Data query method, apparatus, server and storage medium based on block chain |
CN109658050A (en) * | 2018-11-12 | 2019-04-19 | 深圳壹账通智能科技有限公司 | A kind of management method and equipment of wage report |
CN110580414A (en) * | 2019-11-08 | 2019-12-17 | 支付宝(杭州)信息技术有限公司 | private data query method and device based on block chain account |
Also Published As
Publication number | Publication date |
---|---|
CN112286997A (en) | 2021-01-29 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN112286997B (en) | Salary data query method based on distributed deployment and related equipment | |
US11363028B2 (en) | Systems and methods for delegating access to a protected resource | |
CN112306687B (en) | Knowledge graph-based resource allocation method and device, computer equipment and medium | |
US11386224B2 (en) | Method and system for managing personal digital identifiers of a user in a plurality of data elements | |
CN111814179A (en) | User authority management and data control method and related equipment thereof | |
CN112163207B (en) | Service data query method based on dynamic permission and related equipment | |
CN109522751B (en) | Access right control method and device, electronic equipment and computer readable medium | |
US20200104521A1 (en) | Systems and methods for delegating access to a protected resource | |
CN112182004B (en) | Method, device, computer equipment and storage medium for checking data in real time | |
CN109255587B (en) | Collaborative processing method and device for working data | |
CN112328486A (en) | Interface automation test method and device, computer equipment and storage medium | |
US20200233907A1 (en) | Location-based file recommendations for managed devices | |
CN112860662A (en) | Data blood relationship establishing method and device, computer equipment and storage medium | |
US7693185B1 (en) | Method and apparatus for creation and management of intelligent packets | |
KR20120039397A (en) | Business information providing system and method for providing business information using the same | |
CN111427972A (en) | Method and device for searching service data, service searching system and storage medium | |
CN116738482A (en) | Sensitive data processing method, system, computer equipment and storage medium | |
CN113283759B (en) | Account risk portrait updating method, device, equipment and storage medium | |
KR20200092590A (en) | Real-time Intermediary System Between Work Seeking Driver And Driver Seeking Firm | |
Selvi et al. | Implementation of fingerprint-based biometric system and its integration with HRMS application at RDCIS, SAIL | |
CN110008346B (en) | Blacklist conduction map construction method, device, computer equipment and storage medium | |
Pfister et al. | The landscape of electronic data safes and their adoption in E-Government and E-Business | |
CN112199350B (en) | Function verification method and device based on data screening, computer equipment and medium | |
US20230177528A1 (en) | Systems and methods for data insights from consumer accessible data | |
KR20180120536A (en) | Method for providing online insurance transaction service |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
TA01 | Transfer of patent application right | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20210204 Address after: 518000 room 64, 3 / F, building 364B, Jingui building, 68 Puti Road, Fubao community, Fubao street, Futian District, Shenzhen City, Guangdong Province Applicant after: Shenzhen Pingan Zhihui Enterprise Information Management Co.,Ltd. Address before: No.1411-14158, main tower of shipping center, No.59 Linhai Avenue, Nanshan street, Qianhai Shenzhen Hong Kong cooperation zone, Shenzhen, Guangdong 518000 Applicant before: Ping An digital information technology (Shenzhen) Co.,Ltd. |
|
GR01 | Patent grant | ||
GR01 | Patent grant |