Process salary calculation method and device, equipment, storage medium and product
By establishing a salary group and performing grammatical verification, and performing salary calculations based on salary items and salary items rules, the problem of insufficient computing transparency in the existing technology is solved, the process configuration and data transparency of salary calculations are realized, and the calculation is enhanced accuracy and traceability.
Patent Information
- Application Number
- CN202410999168.1
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-07-24
- Publication Date
- 2024-11-12
AI Technical Summary
The existing salary calculation system has insufficient computing transparency, making it difficult for users to verify the correctness of salary calculations, and lacks process and process data, so they cannot modify the calculation logic errors in time.
By establishing a salary group and determining salary items rules, performing grammatical verification and performing salary calculation based on salary items and salary items rules, providing process-based salary calculation methods to improve calculation accuracy and data transparency.
The process-based configuration of salary calculations is realized, which enhances the transparency and traceability of calculations, enables users to timely view and verify salary calculation results, and improves the accuracy of calculations and user participation.
Smart Images

Figure CN118941402A_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of computer technology, and in particular to a process-based salary calculation method, device, equipment, storage medium and product. Background Art
[0002] With the popularization of smart enterprise concepts and the continuous development of artificial intelligence technology and big data technology, more and more companies are beginning to adopt salary calculation systems to improve the efficiency and accuracy of salary management.
[0003] The existing salary calculation system lacks process and process data, and the calculation transparency is insufficient, making it difficult for users to verify the correctness of the salary calculation. There are also deficiencies in the review of calculation results, analysis and statistics of data, and application.
[0004] The above contents are only used to assist in understanding the technical solution of the present application and do not constitute an admission that the above contents are prior art. Summary of the invention
[0005] The main purpose of this application is to provide a process-based salary calculation method, device, equipment, storage medium and product, aiming to solve the technical problems of insufficient calculation transparency and lack of review of calculation results in the existing salary calculation system.
[0006] To achieve the above purpose, the present application proposes a process-based salary calculation method, which includes:
[0007] Establishing a salary group based on the information of the personnel to be paid, and determining the salary item rules of the salary group;
[0008] Determine the salary item corresponding to the salary item rule;
[0009] Performing syntax checking on the salary item rule according to the salary item;
[0010] When the verification is passed, salary calculation is performed based on the salary items and the salary item rules to determine the salary calculation results of the personnel to be paid.
[0011] In one embodiment, the step of performing salary calculation based on the salary items and the salary item rules to determine the salary calculation result of the personnel to be paid includes:
[0012] Determine the rule type of the salary item rule and the salary calculation formula;
[0013] Dividing the salary items into an ordered calculation set and an unordered calculation set based on the rule type;
[0014] Based on the ordered salary items and the unordered salary items, the salary calculation results of the personnel to be paid are determined by the salary calculation formula.
[0015] In one embodiment, the step of determining the salary calculation result of the personnel to be paid based on the ordered salary items and the unordered salary items and by using the salary calculation formula includes:
[0016] Determining dependent wage items of the unordered wage items in the unordered calculation set;
[0017] Establishing a graph set based on the dependent salary items and the unordered salary items;
[0018] Traversing the graph set to determine whether there is a target dependent salary item that is not an unordered salary item in the unordered calculation set;
[0019] If so, the unordered wage item corresponding to the target dependent wage item is moved as an ordered wage item to the ordered calculation set;
[0020] When the traversal is completed, the salary calculation results of the personnel to be paid are determined based on the unordered salary items and the ordered salary items and through the salary calculation formula.
[0021] In one embodiment, the step of determining the salary calculation result of the personnel to be paid based on the unordered salary items and the ordered salary items and using a salary calculation formula includes:
[0022] The unordered salary items and the ordered salary items are calculated by a calculation engine based on a salary calculation formula to determine the salary calculation result of the personnel to be paid.
[0023] In one embodiment, the step of calculating the unordered salary items and the ordered salary items based on the salary calculation formula by a calculation engine to determine the salary calculation result of the employee to be calculated includes:
[0024] Obtaining unordered wage data of the unordered wage items and ordered wage data of the ordered wage items;
[0025] Based on the order of the ordered salary items, the ordered salary data is calculated by the calculation engine to obtain the ordered salary item calculation results;
[0026] Calculating the unordered wage item data by the calculation engine to obtain unordered wage item calculation results;
[0027] The salary calculation results of the personnel to be paid are determined based on the calculation results of the ordered salary items and the calculation results of the unordered salary items.
[0028] In one embodiment, the step of obtaining the unordered wage data of the unordered wage items and the ordered wage data of the ordered wage items includes:
[0029] If there is a target salary item rule whose rule type is data source mapping, then obtain the data source mapping relationship corresponding to the target salary item rule;
[0030] The unordered wage data corresponding to the unordered wage items and the ordered wage data corresponding to the ordered wage items are acquired based on the data source mapping relationship.
[0031] In addition, to achieve the above purpose, the present application also proposes a process-based salary calculation device, which includes:
[0032] A rule determination module, used to establish a salary group based on the information of the personnel to be paid, and determine the salary item rules of the salary group;
[0033] A salary item determination module, used to determine the salary item corresponding to the salary item rule;
[0034] A grammar checking module, used for performing grammar checking on the salary item rule according to the salary item;
[0035] The result calculation module is used to perform salary calculation based on the salary items and the salary item rules when the verification is passed, and determine the salary calculation results of the personnel to be calculated.
[0036] In addition, to achieve the above-mentioned purpose, the present application also proposes a process-based salary calculation device, which includes: a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the computer program is configured to implement the steps of the process-based salary calculation method as described above.
[0037] In addition, to achieve the above-mentioned purpose, the present application also proposes a storage medium, which is a computer-readable storage medium, and a computer program is stored on the storage medium. When the computer program is executed by a processor, the steps of the process-based salary calculation method described above are implemented.
[0038] In addition, to achieve the above-mentioned purpose, the present application also provides a computer program product, which includes a computer program, and when the computer program is executed by a processor, the steps of the process-based salary calculation method as described above are implemented.
[0039] One or more technical solutions proposed in this application have at least the following technical effects:
[0040] This application establishes a salary group based on the information of the personnel to be paid, and determines the salary item rules of the salary group; determines the salary items corresponding to the salary item rules; performs syntax verification on the salary item rules according to the salary items; when the verification passes, performs salary calculation based on the salary items and salary item rules to determine the salary calculation results of the personnel to be paid. Salary calculation is performed based on the salary item rules in the salary group, and the salary item rules are syntax verified, which improves the calculation accuracy; at the same time, the process-based salary calculation method improves the transparency of data processing, allowing users to view and trace in a timely manner. BRIEF DESCRIPTION OF THE DRAWINGS
[0041] The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present application and, together with the description, serve to explain the principles of the present application.
[0042] In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the following is a brief introduction to the drawings required for use in the embodiments or the description of the prior art. Obviously, for ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative labor.
[0043] Figure 1 A flowchart diagram of the first embodiment of the process-based salary calculation method of this application;
[0044] Figure 2 A flowchart of salary group creation in one implementation of the process-based salary calculation method of this application;
[0045] Figure 3 A flowchart of pre-tax salary calculation in one implementation of this application;
[0046] Figure 4 A flowchart diagram of the second embodiment of the process-based salary calculation method of this application;
[0047] Figure 5 A flowchart diagram of the third embodiment of the process-based salary calculation method of this application;
[0048] Figure 6 This is a schematic diagram of the overall process in one implementation of the process-based salary calculation method for this application;
[0049] Figure 7 This is a schematic diagram of the module structure of the process-based salary calculation device of the embodiment of the present application;
[0050] Figure 8 This is a schematic diagram of the device structure of the hardware operating environment involved in the process-based salary calculation method in the embodiment of the present application.
[0051] The purpose, features and advantages of this application will be further described in conjunction with the embodiments and with reference to the accompanying drawings. DETAILED DESCRIPTION
[0052] It should be understood that the specific embodiments described herein are only used to explain the technical solutions of the present application and are not used to limit the present application.
[0053] In order to better understand the technical solution of the present application, a detailed description will be given below in conjunction with the accompanying drawings and specific implementation methods.
[0054] The main solution of the embodiment of the present application is: establish a salary group based on the information of the personnel to be paid, and determine the salary item rules of the salary group; determine the salary items corresponding to the salary item rules; perform syntax verification on the salary item rules according to the salary items; when the verification passes, perform salary calculation based on the salary items and salary item rules, and determine the salary calculation results of the personnel to be paid.
[0055] At present, most companies use Excel for salary calculation, which lacks systematicity, verifiability and traceability. At the same time, the existing salary calculation system has simple functions and unit configuration, and it is difficult for users to personalize it according to the characteristics of their own company. In addition, the existing salary calculation system lacks process and process data, and the calculation transparency is insufficient. Users cannot verify the correctness of the salary calculation, nor can they modify the errors in the calculation logic in time.
[0056] This application provides a solution, which is to build a process-based salary calculation method, perform syntax verification on the salary item rules in the salary group, and when the verification passes, perform salary calculation based on the salary items and salary item rules. Through the solution of this application, the process configuration of salary calculation is realized, and the results of each salary calculation cycle can be archived so that users can view them in time, which has strong traceability.
[0057] It should be noted that the execution subject of this embodiment can be a computing service device with data processing, network communication and program running functions, such as a computer, a server, a cloud computing device, etc., or an electronic device, a virtual device, etc. that can realize the above functions. The following takes a process-based salary calculation device (referred to as a calculation device) as an example to illustrate this embodiment and the following embodiments.
[0058] Based on this, the present application embodiment provides a process-based salary calculation method, referring to Figure 1 , Figure 1 This is a flow chart of the first embodiment of the process-based salary calculation method of this application.
[0059] In this embodiment, the process-based salary calculation method includes steps S10 to S40:
[0060] Step S10, establishing a salary group based on the information of the personnel to be paid, and determining the salary item rules of the salary group;
[0061] Step S20, determining the salary item corresponding to the salary item rule;
[0062] It should be noted that the above-mentioned personnel to be paid, that is, the employees whose salary is calculated by parameters, can establish a salary group based on the personnel information of the personnel to be paid, thereby realizing salary calculation.
[0063] It is understandable that the salary group may be established from the perspectives of department, position, job, etc., or in other ways, and the embodiments of the present application are not limited thereto.
[0064] In one implementation, the computing device can query the employee configuration of the corresponding personnel to be paid according to the name of the payroll group, and query the employee information contained in different dimensions such as department, position, and job title according to the employee configuration, and store the employee information in the database. Based on the employee information in the database, functions such as employee matching, legality verification, deduplication, and error reporting can be implemented.
[0065] It should be noted that the salary group can contain the salary items corresponding to the employees to be paid. At the same time, for each salary item, there can be different or the same field types, as well as decimal places, default values, payable / deductible / repayable / redeductible, pre-tax / post-tax and other attributes. In addition, through the salary calculation results of each salary item, fixed value comparison and historical data comparison can be achieved, so as to determine the horizontal and vertical comparison of employee salaries.
[0066] It should be explained that the above-mentioned salary item rule may be a rule for obtaining the salary data corresponding to the salary item, and the salary data corresponding to the employee to be paid may be obtained based on the salary item rule.
[0067] Specifically, salary item rules may include rule types such as manual import, data source mapping, and custom formulas.
[0068] Manual import means that during the salary calculation process, the data required for each employee's salary calculation is imported into the salary calculation system through Excel or other forms;
[0069] Data source mapping can support multiple data sources such as personal income tax, social security, attendance, data collection, data aggregation, historical salary data, etc. During the calculation process, the system can provide data synchronization function according to the user's configuration. At the same time, users can obtain data for salary calculation from various data sources in sequence.
[0070] Custom formulas means that users can use natural language to configure formulas based on resources such as the formula editor provided by the system, such as using if / else to make conditional judgments, or / and to make logical judgments; in addition, the system can provide support for various salary calculation functions such as date calculations (such as intervals between natural days, intervals between working days, etc.) and numerical calculations (such as taking maximum values, minimum values, rounding, etc.).
[0071] It should be noted that, for each salary item in a salary group, its salary item rule may select one or more of the above rules according to the requirements of actual application, and the embodiment of the present application is not limited to this.
[0072] It is understandable that the salary calculation function of this application supports multiple data acquisition methods. The data source mapping also supports acquiring data from multiple data sources such as personal income tax, social security, attendance, data collection, data aggregation, historical salary data, etc., so that users can flexibly configure the data acquisition method and salary calculation formula in the salary item rules according to the characteristics of the enterprise.
[0073] At the same time, by linking multiple modules such as personal tax, social security, attendance, data collection, and data aggregation, the original data for salary calculation can be obtained from multiple channels, making the method of this application more complete and improving the systematic nature of the salary calculation process. At the same time, during the calculation process, the verification rules can be queried based on the name of the salary group, and the salary calculation results calculated for each employee can be verified using the verification rules. When the verification is triggered, the salary calculation results of the employee are marked, and the verification rules and the marked salary calculation results are stored. The solution of this application supports online and offline data comparison and has good verification. The calculation results of each salary cycle are archived, and users can view them in a timely manner, with strong traceability.
[0074] In a specific implementation, the computing device of the embodiment of the present application can establish a salary group based on the information of the personnel to be paid, and determine the salary items and salary item rules included in the salary group. Since employees are distinguished by different salary groups and the salary item rules in the salary group are determined, different salary data acquisition methods are determined.
[0075] Step S30, performing syntax check on the salary item rule according to the salary item;
[0076] It should be noted that when a salary group is created, a salary calculation cycle can be set for it. The salary calculation cycle can be monthly salary calculation, weekly salary calculation, hourly salary calculation, etc., which is not limited in this embodiment of the present application.
[0077] It should be explained that when the salary group is created, the salary group and the salary items in the salary group can also be verified to avoid the existence of salary groups or salary items with the same name, so as to prevent errors in formula calculation.
[0078] Furthermore, the QLExpress calculation engine can be used to check whether there are any syntax errors in the salary calculation formula used for salary calculation, that is, to perform syntax checking on the salary calculation formula corresponding to the salary item rule to determine whether there are any syntax errors.
[0079] It is understandable that when there is no syntax error, step S40 can be executed. When the verification is passed, salary calculation is performed based on the salary items and the salary item rules to determine the salary calculation result of the person to be paid.
[0080] It should be noted that when the syntax check passes, it can be said that there is no problem with the salary calculation formula corresponding to the salary item rule. Therefore, the salary calculation data can be obtained based on the salary item rule, and the salary calculation data can be calculated based on the salary calculation formula corresponding to the salary item rule, so as to determine the salary calculation result of the personnel to be calculated. The salary calculation result can also be checked by the preset verification rules, so as to realize the update of the salary item rule and data modification.
[0081] In one implementation of the present application, the process of establishing a salary group can be as follows: Figure 2 shown.
[0082] Reference Figure 2 , the system can create a salary group, synchronize the salary personnel (i.e. the personnel to be paid), and determine whether it is necessary to manually add the personnel to be paid. If so, query the personnel that are not included in the salary group of the enterprise to obtain the unadded personnel; add the unadded personnel based on the unadded personnel, and then select the personnel to be added to the salary group.
[0083] It should be noted that when adding employees to be paid, the system can calculate the employees according to the set default parameters and add these employees to the calculation period of the salary group. If you want to increase or decrease the employees to be paid in the salary group, you can use manual addition, ecxel import, and add data collection personnel from the collection table of the collection module.
[0084] Furthermore, for the position, post and other information of each employee to be paid, you can download an empty template or its corresponding employee template, and then fill in the employee based on the template and import it.
[0085] It is understandable that, for the personnel to be paid in the template, the legitimacy of the employee can be verified, that is, whether the personnel to be paid actually exist in the enterprise; if so, the personnel to be paid can be added to the payroll group.
[0086] Furthermore, it is also possible to query the personnel who need to be included in the data collection, and if so, a collection table containing the data collection personnel (employees) can be obtained. Employees are selected based on the obtained collection table, and the selected employees are included in the salary group.
[0087] It should be noted that the salary calculation process can include pre-tax salary calculation, post-tax salary calculation, etc. For the calculation of pre-tax salary, the original data required for salary calculation can be imported on demand. If the corresponding data source mapping is set when creating the salary item rule, the attendance and social security data can be synchronized, so as to obtain data from other modules to complete the calculation; for the calculation of post-tax salary, it can also be calculated through the personal tax module. If the early warning verification rule is also set in the pre-tax salary calculation or post-tax salary calculation, the early warning verification rule can be triggered, and the relevant data and salary item rules can be checked and modified according to the verification information displayed by the system.
[0088] Specifically, for the process of calculating pre-tax wages, please refer to Figure 3 As shown; for the process of calculating after-tax wages, you can refer to Figure 4 As shown;
[0089] It should be noted that, based on the salary item rules, salary calculation data can be obtained and imported into the salary calculation system, and the data can be floating data. Further, it can be determined whether to use the social security module. If so, social security can be synchronized based on the social security module.
[0090] Further, it can be determined whether the attendance module is used, and if so, synchronous attendance is required;
[0091] Furthermore, the salary calculation system can calculate the pre-tax salary based on the salary calculation rules, the synchronized data, and the salary calculation data. When the calculation is completed, it can be determined whether the early warning check is triggered. If so, the calculated salary data and the salary item rules need to be checked to achieve the modification of the salary item rules or data. Based on the modified salary item rules, it is possible to return to the step of calculating the pre-tax salary to achieve accurate calculation of the pre-tax salary.
[0092] It is understandable that the results of pre-tax wage calculation and post-tax wage calculation can be archived, thereby increasing the traceability of system calculation data. In this application, the salary calculation project is divided into main processes such as personnel selection, pre-tax calculation, and post-tax calculation. The process processing results in each main process can be viewed separately, and the functions of result verification and online modification are provided, which improves data transparency and user participation. At the same time, it can verify the correctness of the calculation in a timely manner and make modifications to erroneous logic. At the same time, when configuring salary item rules, this application supports the configuration of personnel to be paid. During the configuration process, you can choose from multiple angles such as department, position, position, and personnel, which improves the selectivity of the method of this application. During the calculation process, it also supports the manual addition of additional personnel to be paid, which enhances flexibility.
[0093] The embodiment of the present application establishes a salary group based on the information of the personnel to be paid, and determines the salary item rules of the salary group; determines the salary items corresponding to the salary item rules; performs grammatical verification on the salary item rules according to the salary items; when the verification passes, performs salary calculation based on the salary items and the salary item rules, and determines the salary calculation result of the personnel to be paid. Salary calculation is performed based on the salary item rules in the salary group, and the salary item rules are grammatically verified, which improves the calculation accuracy; at the same time, the transparency of data processing is improved through the process-based salary calculation method, so that users can view and trace in time.
[0094] Based on the first embodiment of the present application, in the second embodiment of the present application, the same or similar contents as those in the above-mentioned embodiment 1 can be referred to the above introduction, and will not be repeated in the following. Figure 4 The step of calculating the salary based on the salary items and the salary item rules and determining the salary calculation result of the personnel to be calculated comprises:
[0095] Step S41, determining the rule type of the salary item rule and the salary calculation formula;
[0096] It should be noted that, for a salary item, it may include one or more salary item rules, and for a salary item rule, it may correspond to one or more salary calculation formulas.
[0097] Step S42, dividing the salary items into an ordered calculation set and an unordered calculation set based on the rule type;
[0098] It should be noted that for the rule types of salary item rules, salary items can be divided into two categories.
[0099] Specifically, for salary item rules whose rule types are data source mapping and manual import, the corresponding salary items can be classified into an ordered calculation set; for salary item rules of user-defined formulas, the corresponding salary items can be classified into an unordered calculation set.
[0100] It should be noted that for the wage items in the ordered calculation set, when performing salary calculation, they will be calculated sequentially according to the order and dependency relationship in the set; for the wage items in the unordered calculation set, there is no need to calculate them according to the order in the set.
[0101] Through the above division, we can obtain the ordered calculation set A{WI1,WI2,WI3,······WI n} and the unordered computation set B{FI1,FI2,FI3,······FI m}. Among them, WI is used to represent ordered wage items, and FI is used to represent unordered wage items.
[0102] Step S43, based on the ordered salary items and the unordered salary items, and using the salary calculation formula, determine the salary calculation result of the person to be paid.
[0103] It should be noted that when determining ordered wage items and unordered wage items, the wage calculation results of the employees to be paid can be determined through the wage calculation formula.
[0104] Specifically, the step of determining the salary calculation result of the personnel to be paid based on the ordered salary items and the unordered salary items and by using the salary calculation formula includes:
[0105] Step S431, determining dependent salary items of the unordered salary items in the unordered calculation set;
[0106] Step S432, establishing a graph set based on the dependent salary items and the unordered salary items;
[0107] Step S433, traversing the graph set to determine whether there is a target dependent salary item that is not an unordered salary item in the unordered calculation set;
[0108] Step S434: If it exists, the unordered wage item corresponding to the target dependent wage item is moved as an ordered wage item to the ordered calculation set;
[0109] Step S435, when the traversal is completed, based on the unordered salary items and the ordered salary items, and through the salary calculation formula, the salary calculation result of the person to be paid is determined.
[0110] It should be noted that, for the unordered salary items in the unordered calculation set, their dependencies can be determined, and the dependent salary items of each unordered salary item can be determined based on the dependencies.
[0111] It is understandable that the method of determining the dependency relationship can be determined by the QLExpress calculation engine, or can be determined based on other methods, and the embodiments of the present application are not limited to this.
[0112] Furthermore, when the dependent salary items are determined, the dependent salary items can be stored using a map set (MAP set) ItemMap. Specifically, the data structure of IremMap can be: 11 ,D 12 ,…D 1n ], FI2:[D 21 ,D 22 ,…D 2n ],…FI m :[D m1 ,D m2 ,…D mn ]}; FI represents an unordered wage item, and D is used to represent a dependent wage item corresponding to the unordered wage item, which can be a wage item in an ordered calculation set or an unordered calculation set.
[0113] It should be noted that for the salary calculation formula, if it includes functions corresponding to attributes such as total payable, total deductions, total back payable, and total back deductions, the dependent salary items can also include salary items of all corresponding attributes.
[0114] It should be explained that the graph set can be looped through. For any traversed target salary item FI, if its dependency DI is not an unordered salary item in the unordered calculation set, it can be said that the target salary item has no dependency in ItemMap, that is, its corresponding dependency is in the ordered salary item. Therefore, the target salary item can be put into the ordered calculation set, and the target salary item in the graph set and the unordered calculation set can be deleted. When the quantity in the ordered calculation set does not change or the graph set is empty, the traversal process can be ended.
[0115] In one implementation of the embodiment of the present application, in order to realize salary calculation, the step of determining the salary calculation result of the personnel to be calculated based on the unordered salary items and the ordered salary items and using the salary calculation formula includes:
[0116] The unordered salary items and the ordered salary items are calculated by a calculation engine based on a salary calculation formula to determine the salary calculation result of the personnel to be paid.
[0117] It should be noted that before the present application performs calculations, a calculation engine can be built based on QLExpress, and the built-in functions required for salary calculation can be loaded into the calculation engine. The calculation engine can be used to perform syntax verification on the salary calculation formula to determine whether there are syntax errors in the salary calculation formula.
[0118] When the syntax check passes, the salary calculation formula can be used to calculate the unordered salary items and the ordered salary items based on the salary calculation formula, so as to determine the salary calculation results of the employees to be paid.
[0119] The embodiment of the present application determines the rule type of the salary item rule and the salary calculation formula; divides the salary items into an ordered calculation set and an unordered calculation set based on the rule type; and determines the salary calculation result of the personnel to be calculated based on the ordered salary items and the unordered salary items and the salary calculation formula. Since the salary calculation is performed based on the ordered calculation set and the unordered calculation set by determining the ordered calculation set and the unordered calculation set, the accuracy of the salary calculation is improved, and the transparency of the data is improved.
[0120] Based on the first embodiment and / or the second embodiment of the present application, in the third embodiment of the present application, the same or similar contents as those of the above-mentioned first embodiment and / or the second embodiment can refer to the above introduction, and will not be repeated later. Figure 5 The step of calculating the unordered salary items and the ordered salary items by the calculation engine based on the salary calculation formula to determine the salary calculation result of the personnel to be calculated includes:
[0121] Step S100, obtaining the unordered wage data of the unordered wage items and the ordered wage data of the ordered wage items;
[0122] It should be noted that the data acquisition method for each unordered salary item and ordered salary item can be determined based on the salary item rules. For the manual import method, the value of each salary item is directly obtained from the imported data; for the custom formula method, the formula needs to be loaded into the calculation engine for calculation; for the data source mapping method, it is necessary to first query the mapping data of the employees to be paid according to the data mapping relationship, and build a data source set based on the mapping data. The data structure of the data source set can be as follows:
[0123] {S1:[{ST1:V 11},{ST2:V 12},…{ST n :V 1n}],
[0124] S2:[{ST1:V 21},{ST2:V 22},…{STn :V 2n}],…,
[0125] Sn:[{ST1:V n1},{ST2:V n2},…{ST n :V nn}]}.
[0126] Wherein, S represents a data source, ST represents the employee identification number of the employee to be paid, and V represents the salary data corresponding to each employee under each data source. The data structure of the salary data can be {K1:V1, K2:V2, ...}, which is not limited in the embodiment of the present application.
[0127] Specifically, the step of obtaining the unordered wage data of the unordered wage items and the ordered wage data of the ordered wage items includes:
[0128] If there is a target salary item rule whose rule type is data source mapping, then obtain the data source mapping relationship corresponding to the target salary item rule;
[0129] The unordered wage data corresponding to the unordered wage items and the ordered wage data corresponding to the ordered wage items are acquired based on the data source mapping relationship.
[0130] Step S200, based on the order of the ordered salary items, the ordered salary data is calculated by the calculation engine to obtain the ordered salary item calculation results;
[0131] Step S300, calculating the unordered wage item data by the calculation engine to obtain unordered wage item calculation results;
[0132] It should be noted that, for ordered wage items, the calculation of the wage items can be performed sequentially according to the arrangement order of the wage items in the ordered calculation set; for unordered wage items, the calculation can be performed directly.
[0133] Step S400: determining the salary calculation result of the personnel to be calculated based on the calculation result of the ordered salary items and the calculation result of the unordered salary items.
[0134] It should be noted that the salary calculation result can also be processed according to the preset number of decimal places to obtain the final output salary calculation result, and the data structure of the salary calculation result can be as follows:
[0135] {ST1:{K1:V 11 ,K2:V 12 ,…},
[0136] ST2:{K1:V 21 ,K2:V22 ,…},…,
[0137] ST n :{K1:V n1 ,K2:V n2 ,…}}.
[0138] In one implementation of the present application, the overall flow chart of the process-based salary calculation method can be referred to Figure 6 .
[0139] Specifically, the computing device may create a salary group and determine the salary items to be queried in the salary group. Different salary item rules may correspond to each salary item; if there is a salary item rule that is a data source mapping rule, it is necessary to query the mapping data based on the data source mapping relationship and construct a data source set based on the mapping data.
[0140] Furthermore, the computing device may construct a computing engine and load the built-in functions of the system into the computing engine, so as to implement syntax checking of the salary calculation formula corresponding to the salary item rule.
[0141] Furthermore, salary calculation can be performed based on the employees to be paid in the salary group and their corresponding salary items. For the salary calculation process, different salary item rules correspond to different calculation strategies.
[0142] It should be noted that for manually imported salary item rules, the imported data is used for calculation; for salary item rules mapped by data source, the calculation is based on the created data source set and data source mapping relationship; for salary item rules with custom formulas, the calculation is based on the custom formula.
[0143] It is understandable that when the salary item rule is mapped to the data source, calculations can also be performed based on module data such as the social security module, the personal tax module, and the attendance module, so that the calculated salary data can contain multi-dimensional information.
[0144] Furthermore, the result verification rule corresponding to the salary group can be queried according to the salary group name. The calculation result can be verified based on the result verification rule. When the verification is triggered, the salary item of the employee can be identified, and the identified salary item and the result verification rule can be stored.
[0145] When the salary items of all employees to be paid are calculated, the corresponding salary calculation results of each employee can be stored in the database.
[0146] The embodiment of the present application obtains the disordered wage data of disordered wage items and the ordered wage data of ordered wage items; based on the order of ordered wage items, the ordered wage data is calculated by a calculation engine to obtain the ordered wage item calculation results; the disordered wage item data is calculated by a calculation engine to obtain the disordered wage item calculation results; and the salary calculation results of the personnel to be calculated are determined based on the ordered wage item calculation results and the disordered wage item calculation results. Since the calculation order of the wage items is determined, the problem of inaccurate calculation results caused by an incorrect calculation order is avoided.
[0147] It should be noted that the above examples are only used to understand the present application and do not constitute a limitation on the process-based salary calculation method of the present application. More simple transformations based on this technical concept are all within the scope of protection of the present application.
[0148] This application also provides a process-based salary calculation device, please refer to Figure 7 , the process-based salary calculation device includes:
[0149] A rule determination module 10 is used to establish a salary group based on the information of the personnel to be paid, and determine the salary item rules of the salary group;
[0150] A salary item determination module 20, used to determine the salary item corresponding to the salary item rule;
[0151] A grammar checking module 30, for performing grammar checking on the salary item rule according to the salary item;
[0152] The result calculation module 40 is used to perform salary calculation based on the salary items and the salary item rules when the verification is passed, and determine the salary calculation results of the personnel to be calculated.
[0153] The process-based salary calculation device provided by the present application adopts the process-based salary calculation method in the above embodiment, which can solve the technical problems of insufficient calculation transparency and lack of review of calculation results in the existing salary calculation system. Compared with the prior art, the beneficial effects of the process-based salary calculation device provided by the present application are the same as the beneficial effects of the process-based salary calculation method provided by the above embodiment, and other technical features in the process-based salary calculation device are the same as the features disclosed in the above embodiment method, which will not be repeated here.
[0154] The present application provides a process-based salary calculation device, which includes: at least one processor; and a memory that is communicatively connected to the at least one processor; wherein the memory stores instructions that can be executed by the at least one processor, and the instructions are executed by the at least one processor so that the at least one processor can execute the process-based salary calculation method in the above-mentioned embodiment 1.
[0155] Reference below Figure 8 , which shows a schematic diagram of the structure of a process-based salary calculation device suitable for implementing the embodiment of the present application. The process-based salary calculation device in the embodiment of the present application may include but is not limited to mobile terminals such as mobile phones, laptop computers, digital broadcast receivers, PDAs (Personal Digital Assistants), PADs (Portable Application Descriptions), PMPs (Portable Media Players), vehicle-mounted terminals (such as vehicle-mounted navigation terminals), etc., and fixed terminals such as digital TVs, desktop computers, etc. Figure 8 The process-based salary calculation device shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present application.
[0156] like Figure 8 As shown, the process-based salary calculation device may include a processing device 1001 (e.g., a central processing unit, a graphics processing unit, etc.), which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 1002 or a program loaded from a storage device 1003 to a random access memory (RAM) 1004. Various programs and data required for the operation of the process-based salary calculation device are also stored in the RAM 1004. The processing device 1001, the ROM 1002, and the RAM 1004 are connected to each other via a bus 1005. An input / output (I / O) interface 1006 is also connected to the bus. Typically, the following systems can be connected to the I / O interface 1006: input devices 1007 including, for example, a touch screen, a touchpad, a keyboard, a mouse, an image sensor, a microphone, an accelerometer, a gyroscope, etc.; output devices 1008 including, for example, a liquid crystal display (LCD), a speaker, a vibrator, etc.; storage devices 1003 including, for example, a magnetic tape, a hard disk, etc.; and communication devices 1009. The communication device 1009 can allow the process-based salary calculation device to communicate with other devices wirelessly or by wire to exchange data. Although the figure shows a process-based salary calculation device with various systems, it should be understood that it is not required to implement or have all the systems shown. More or fewer systems may be implemented or have instead.
[0157] In particular, according to the embodiments disclosed in the present application, the process described above with reference to the flowchart can be implemented as a computer software program. For example, the embodiments disclosed in the present application include a computer program product, which includes a computer program carried on a computer-readable medium, and the computer program includes a program code for executing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from a network through a communication device, or installed from a storage device 1003, or installed from a ROM 1002. When the computer program is executed by the processing device 1001, the above-mentioned functions defined in the method of the embodiment disclosed in the present application are executed.
[0158] The process-based salary calculation device provided by the present application adopts the process-based salary calculation method in the above embodiment, which can solve the technical problems of insufficient calculation transparency and lack of review of calculation results in the existing salary calculation system. Compared with the prior art, the beneficial effects of the process-based salary calculation device provided by the present application are the same as the beneficial effects of the process-based salary calculation method provided by the above embodiment, and other technical features in the process-based salary calculation device are the same as the features disclosed in the method of the previous embodiment, which will not be repeated here.
[0159] It should be understood that the various parts disclosed in this application can be implemented by hardware, software, firmware or a combination thereof. In the description of the above embodiments, specific features, structures, materials or characteristics can be combined in any one or more embodiments or examples in a suitable manner.
[0160] The above is only a specific implementation of the present application, but the protection scope of the present application is not limited thereto. Any person skilled in the art who is familiar with the present technical field can easily think of changes or substitutions within the technical scope disclosed in the present application, which should be included in the protection scope of the present application. Therefore, the protection scope of the present application should be based on the protection scope of the claims.
[0161] The present application provides a computer-readable storage medium having computer-readable program instructions (ie, computer programs) stored thereon, and the computer-readable program instructions are used to execute the process-based salary calculation method in the above-mentioned embodiment.
[0162] The computer-readable storage medium provided in the present application may be, for example, a USB flash drive, but is not limited to electrical, magnetic, optical, electromagnetic, infrared, or semiconductor systems, systems or devices, or any combination of the above. More specific examples of computer-readable storage media may include, but are not limited to: an electrical connection with one or more wires, a portable computer disk, 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 disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In this embodiment, the computer-readable storage medium may be any tangible medium containing or storing a program that can be used by or in combination with an instruction execution system, system or device. The program code contained on the computer-readable storage medium may be transmitted using any appropriate medium, including but not limited to: wires, optical cables, RF (Radio Frequency), etc., or any suitable combination of the above.
[0163] The computer-readable storage medium may be included in the process-based salary calculation device; or may exist independently without being assembled into the process-based salary calculation device.
[0164] The computer-readable storage medium carries one or more programs. When the one or more programs are executed by the process-based salary calculation device, the process-based salary calculation device:
[0165] Establishing a salary group based on the information of the personnel to be paid, and determining the salary item rules of the salary group;
[0166] Determine the salary item corresponding to the salary item rule;
[0167] Performing syntax checking on the salary item rule according to the salary item;
[0168] When the verification is passed, salary calculation is performed based on the salary items and the salary item rules to determine the salary calculation results of the personnel to be paid.
[0169] Computer program code for performing the operations of the present application may be written in one or more programming languages or a combination thereof, including object-oriented programming languages such as Java, Smalltalk, C++, and conventional procedural programming languages such as "C" or similar programming languages. The program code may be executed entirely on the user's computer, partially on the user's computer, as a separate software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. 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 may be connected to an external computer (e.g., via the Internet using an Internet service provider).
[0170] The flow chart and block diagram in the accompanying drawings illustrate the possible architecture, function and operation of the system, method and computer program product according to various embodiments of the present application. In this regard, each square box in the flow chart or block diagram can represent a module, a program segment or a part of a code, and the module, the program segment or a part of the code contains one or more executable instructions for realizing the specified logical function. It should also be noted that in some alternative implementations, the functions marked in the square box can also occur in a sequence different from that marked in the accompanying drawings. For example, two square boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each square box in the block diagram and / or flow chart, and the combination of the square boxes in the block diagram and / or flow chart can be implemented with a dedicated hardware-based system that performs a specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.
[0171] The modules involved in the embodiments described in this application may be implemented by software or hardware, wherein the name of the module does not constitute a limitation on the unit itself in some cases.
[0172] The readable storage medium provided in the present application is a computer-readable storage medium, which stores computer-readable program instructions (i.e., computer programs) for executing the above-mentioned process-based salary calculation method, and can solve the technical problems of insufficient calculation transparency and lack of review of calculation results in the existing salary calculation system. Compared with the prior art, the beneficial effects of the computer-readable storage medium provided in the present application are the same as the beneficial effects of the process-based salary calculation method provided in the above-mentioned embodiment, and will not be elaborated here.
[0173] The present application also provides a computer program product, including a computer program, which implements the steps of the above-mentioned process-based salary calculation method when executed by a processor.
[0174] The computer program product provided by the present application can solve the technical problems of insufficient calculation transparency and lack of audit of calculation results in the existing salary calculation system. Compared with the prior art, the beneficial effects of the computer program product provided by the present application are the same as the beneficial effects of the process-based salary calculation method provided by the above embodiment, which will not be elaborated here.
[0175] The above descriptions are only some embodiments of the present application, and are not intended to limit the patent scope of the present application. All equivalent structural changes made using the contents of the present application specification and drawings under the technical concept of the present application, or direct / indirect applications in other related technical fields are included in the patent protection scope of the present application.
Claims
1. A process-based salary calculation method, characterized in that: The method comprises: Establishing a salary group based on the information of the personnel to be paid, and determining the salary item rules of the salary group; Determine the salary item corresponding to the salary item rule; Performing syntax checking on the salary item rule according to the salary item; When the verification is passed, salary calculation is performed based on the salary items and the salary item rules to determine the salary calculation results of the personnel to be paid.
2. The process-based salary calculation method according to claim 1, characterized in that: The step of performing salary calculation based on the salary items and the salary item rules to determine the salary calculation results of the personnel to be paid includes: Determine the rule type of the salary item rule and the salary calculation formula; Dividing the salary items into an ordered calculation set and an unordered calculation set based on the rule type; Based on the ordered salary items and the unordered salary items, the salary calculation results of the personnel to be paid are determined by the salary calculation formula.
3. The process-based salary calculation method according to claim 2, characterized in that: The step of determining the salary calculation result of the personnel to be paid based on the ordered salary items and the unordered salary items and by using the salary calculation formula includes: Determining dependent wage items of the unordered wage items in the unordered calculation set; Establishing a graph set based on the dependent salary items and the unordered salary items; Traversing the graph set to determine whether there is a target dependent salary item that is not an unordered salary item in the unordered calculation set; If so, the unordered wage item corresponding to the target dependent wage item is moved as an ordered wage item to the ordered calculation set; When the traversal is completed, the salary calculation results of the personnel to be paid are determined based on the unordered salary items and the ordered salary items and through the salary calculation formula.
4. The process-based salary calculation method according to claim 3, characterized in that: The step of determining the salary calculation result of the personnel to be paid based on the unordered salary items and the ordered salary items by using a salary calculation formula includes: The unordered salary items and the ordered salary items are calculated by a calculation engine based on a salary calculation formula to determine the salary calculation result of the personnel to be paid.
5. The process-based salary calculation method according to claim 4, characterized in that: The step of calculating the unordered salary items and the ordered salary items by the calculation engine based on the salary calculation formula to determine the salary calculation result of the personnel to be calculated includes: Obtaining unordered wage data of the unordered wage items and ordered wage data of the ordered wage items; Based on the order of the ordered salary items, the ordered salary data is calculated by the calculation engine to obtain the ordered salary item calculation results; Calculating the unordered wage item data by the calculation engine to obtain unordered wage item calculation results; The salary calculation results of the personnel to be paid are determined based on the calculation results of the ordered salary items and the calculation results of the unordered salary items.
6. The process-based salary calculation method according to claim 5, characterized in that: The step of obtaining the unordered wage data of the unordered wage items and the ordered wage data of the ordered wage items comprises: If there is a target salary item rule whose rule type is data source mapping, then obtain the data source mapping relationship corresponding to the target salary item rule; The unordered wage data corresponding to the unordered wage items and the ordered wage data corresponding to the ordered wage items are acquired based on the data source mapping relationship.
7. A process-based salary calculation device, characterized in that: The process-based salary calculation device comprises: A rule determination module, used to establish a salary group based on the information of the personnel to be paid, and determine the salary item rules of the salary group; A salary item determination module, used to determine the salary item corresponding to the salary item rule; A grammar checking module, used for performing grammar checking on the salary item rule according to the salary item; The result calculation module is used to perform salary calculation based on the salary items and the salary item rules when the verification is passed, and determine the salary calculation results of the personnel to be calculated.
8. A process-based salary calculation device, characterized in that: The device comprises: a memory, a processor, and a process-based salary calculation program stored in the memory and executable on the processor, wherein the process-based salary calculation program is configured to implement the steps of the process-based salary calculation method according to any one of claims 1 to 6.
9. A storage medium, characterized in that: The storage medium stores a streamlined salary calculation program, and when the streamlined salary calculation program is executed by the processor, the steps of the streamlined salary calculation method according to any one of claims 1 to 6 are implemented.
10. A computer program product, characterized in that The computer program product comprises a computer program, and when the computer program is executed by a processor, the steps of the process-based salary calculation method according to any one of claims 1 to 6 are implemented.
Citation Information
Cited By
Remediation salary calculation method and device for dynamically adjusting salary, equipment and medium
CN119250775A
