Remediation salary calculation method and device for dynamically adjusting salary, equipment and medium

Abstract

The invention provides a mediation salary calculation method and device for dynamically adjusting salary, equipment and a medium, relates to the technical field of data processing, and is applied to mediator salary calculation corresponding to a mediation system. The method comprises the following steps: acquiring current month money return data of a mediator user and undertaking item information corresponding to the mediator user; determining a target salary calculator parameter according to the user information corresponding to the mediator user and the undertaking item information, and matching a target salary calculator based on the salary calculator parameter; and calculating the current month salary of the corresponding mediator user through the target salary calculator. According to the method and the device, the accuracy of salary calculation, the calculation efficiency and the universal degree of the salary calculator in different salary structure users are improved.

Description

Technical Field

[0001] The present application relates to the field of data processing technology, and in particular to a method, device, equipment and medium for dynamically adjusting salary. Background Art

[0002] At present, the salary calculation for mediators is usually done by using Excel to compile statistics on each mediator's case information and payment collection information from each mediation department, and then calculating the case amount, payment collection amount, payment collection rate and other information. Then, the heads of each department calculate each person's payment collection commission, bonus, performance, etc. one by one according to the commission rules and incentive rules, and then summarize them to calculate the total salary.

[0003] However, this method is too inefficient and has low accuracy, requiring specialized personnel to organize various information and make calculations. Moreover, this method is not universal, as additional calculations are required for mediators with different salary structures, which consumes a lot of manpower and also has the defects of low efficiency and low accuracy. Summary of the invention

[0004] The purpose of this application is to provide a method, device, equipment and medium for dynamically adjusting salary to alleviate the above-mentioned technical problems existing in the prior art.

[0005] In a first aspect, the present invention provides a mediation salary calculation method for dynamically adjusting salary, the method is applied to the salary calculation of mediators corresponding to the mediation system; the method comprises: Obtain the monthly payment data of the mediator user and the project information corresponding to the mediator user; Determine target salary calculator parameters according to user information and project information corresponding to the mediator user, and match the target salary calculator based on the salary calculator parameters; Calculate the corresponding mediator user's monthly salary through the target salary calculator.

[0006] In an optional implementation, the monthly payment data of the mediator user is obtained, including: When each mediator registers for payment collection, it triggers the acquisition of the mediator's payment collection data for the current month; or, Get the monthly payment data of the mediator user based on the preset timer trigger.

[0007] In an optional implementation, determining target salary calculator parameters according to user information corresponding to the mediator user and information about the undertaken project, and matching the target salary calculator based on the salary calculator parameters includes: Query the calculator association table to obtain all calculators, query the calculator parameter table to obtain the user parameters corresponding to the mediator user and the project parameters corresponding to the undertaken project information, and convert the user parameters and project parameters into calculator context; When the calculator context contains the parameters required for the calculator to execute, the target salary calculator is matched based on the calculator context.

[0008] In an optional embodiment, the method further comprises: Determine whether the calculator context contains the parameters required for calculator execution; If it is not completely included, get the external parameters and wait for the next polling calculation; If included, the target salary calculator is executed immediately for calculation.

[0009] In an optional implementation, matching a target salary calculator based on salary calculator parameters includes: Determine whether the calculation type corresponding to the salary calculator parameter is a salary calculator; If yes, then match the target salary calculator based on the salary calculator parameters.

[0010] In an optional embodiment, the method further comprises: Write the corresponding project QLExpress algorithm based on the salary calculation method corresponding to the mediator user; Extract QLExpress algorithm parameters and build parameter persistence objects; The persistent objects are determined as user parameters corresponding to the mediator user and project parameters corresponding to the undertaken project information.

[0011] In an optional embodiment, the method further comprises: If the department parameters or project parameters corresponding to the first mediator user and the second mediator user are different, extracting the union parameters corresponding to the different mediator users; Determine the user parameters corresponding to the first mediator user or the second mediator user and the project parameters corresponding to the undertaken project information according to the union parameters; When calculating the monthly salary, the parameters in the union parameters that do not belong to the corresponding mediator user will be ignored.

[0012] In a second aspect, the present invention provides a mediation salary calculation device for dynamically adjusting salary, the device is applied to calculate the salary of the mediator corresponding to the mediation system; the device comprises: The acquisition module is used to obtain the monthly payment data of the mediator user and the project information corresponding to the mediator user; A matching module, used to determine target salary calculator parameters according to user information and project information corresponding to the mediator user, and match the target salary calculator based on the salary calculator parameters; The calculation module is used to calculate the monthly salary of the corresponding mediator user through the target salary calculator.

[0013] In a third aspect, the present invention provides an electronic device including a processor and a memory, wherein the memory stores computer executable instructions that can be executed by the processor, and the processor executes the computer executable instructions to implement the method for calculating a salary for dynamically adjusting the salary according to any of the aforementioned implementations.

[0014] In a fourth aspect, the present invention provides a computer-readable storage medium storing computer-executable instructions. When the computer-executable instructions are called and executed by a processor, the computer-executable instructions prompt the processor to implement the method for calculating a salary for dynamically adjusting salary according to any one of the aforementioned implementations.

[0015] The beneficial effects of the salary adjustment calculation method, device, equipment and medium for dynamically adjusting salary provided by the present application are as follows: By using a pre-verified salary calculator, the accuracy of salary calculation is significantly improved; at the same time, the matching of the salary calculator is carried out through matching of user information and project information, so when users with different salary structures use it, they only need to replace the corresponding parameters to perform calculations, which greatly improves the efficiency of calculations and the universality of the salary calculator for users with different salary structures. BRIEF DESCRIPTION OF THE DRAWINGS

[0016] In order to more clearly illustrate the specific implementation methods of the present application or the technical solutions in the prior art, the drawings required for use in the specific implementation methods or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are some implementation methods of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0017] Figure 1 A flowchart of a method for calculating salary for dynamically adjusting salary provided in an embodiment of the present application; Figure 2 A schematic diagram of an entity relationship provided for an embodiment of the present application; Figure 3 A flowchart constructed by a calculator provided in an embodiment of the present application; Figure 4 A flowchart of a specific salary calculation method provided in an embodiment of the present application; Figure 5A structural diagram of a salary calculation device for dynamically adjusting salary provided in an embodiment of the present application; Figure 6 A structural diagram of an electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0018] In order to make the purpose, technical solution and advantages of the embodiments of the present application clearer, the technical solution in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are part of the embodiments of the present application, rather than all the embodiments. The components of the embodiments of the present application described and shown in the drawings here can be arranged and designed in various different configurations.

[0019] Therefore, the following detailed description of the embodiments of the present application provided in the accompanying drawings is not intended to limit the scope of the present application for which protection is sought, but merely represents selected embodiments of the present application. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in the field without creative work are within the scope of protection of the present application.

[0020] It should be noted that similar reference numerals and letters denote similar items in the following drawings, and therefore, once an item is defined in one drawing, further definition and explanation thereof is not required in subsequent drawings.

[0021] The present application embodiment provides a mediation salary calculation method for dynamically adjusting salary, which is applied to the salary calculation of mediators corresponding to the mediation system; see Figure 1 As shown, the method mainly includes the following steps: Step S110, obtaining the mediator user's monthly payment data and the corresponding project information of the mediator user.

[0022] In one embodiment, obtaining the mediator user's monthly payment collection data may be triggered when each mediator registers for payment collection; or, obtaining the mediator user's monthly payment collection data may be triggered based on a preset timer.

[0023] For example, when each mediator registers for payment collection, triggering the acquisition of the mediator user's monthly payment data can disperse the collection of basic data into the system operation process. For example, when each mediator registers for payment collection, it can trigger the calculation of his total payment amount for the month. Through the use of multi-threading, the salary calculation of more than 600 people in the company can be controlled within 30 seconds, thereby greatly improving the efficiency of data acquisition.

[0024] Step S120, determining target salary calculator parameters according to user information corresponding to the mediator user and information about the undertaken project, and matching the target salary calculator based on the salary calculator parameters.

[0025] In one implementation, the calculator association table can be queried to obtain all calculators, the calculator parameter table can be queried to obtain the user parameters corresponding to the mediator user and the project parameters corresponding to the project information, and the user parameters and project parameters can be converted into calculator context; when the calculator context contains the parameters required for the calculator to execute, the target salary calculator is matched based on the calculator context.

[0026] In order to make the target salary calculator universal for users with different salary structures, in one implementation, the corresponding project QLExpress algorithm body can be written based on the salary calculation method corresponding to the mediator user; the QLExpress algorithm body parameters can be extracted to construct a parameter persistence object; the persistence object is determined as the user parameters corresponding to the mediator user and the project parameters corresponding to the project information. By uniformly collecting and saving the QLExpress algorithm body to the database, the calculation rules are clear and easy to call or modify later.

[0027] Optionally, the target salary calculator is matched based on the salary calculator parameters, and it can be pre-determined whether the calculation type corresponding to the salary calculator parameters is a salary calculator; if so, the target salary calculator is matched based on the salary calculator parameters.

[0028] In one implementation, it is possible to pre-determine whether the calculator context contains the parameters required for the calculator to execute; if not, external parameters are obtained and the next polling calculation is waited for; if contained, the target salary calculator is immediately executed for calculation.

[0029] Taking into account the differences in salary calculation methods for mediator users in different departments or with different salary structures, in order to make the salary calculator universal among multiple different mediator users, in one embodiment, if the department parameters or project parameters corresponding to the first mediator user and the second mediator user are different, the union parameters corresponding to the different mediator users are extracted; the user parameters corresponding to the first mediator user or the second mediator user and the project parameters corresponding to the project information are determined based on the union parameters; when calculating the salary for the current month, the parameters in the union parameters that do not belong to the corresponding mediator user are ignored.

[0030] For example, due to different salary algorithms for different salary structures, the calculated commissions can be different, and accordingly, the profit margins will also be different. When selecting parameters, for example, algorithm A requires three parameters a, b, and c, and algorithm B requires three parameters c, d, and e. Then mediator user A belongs to one department, and their department implements algorithm a. Therefore, only parameters a, b, and c will actually be calculated and saved to the database, but in order to support replacement, so that the algorithm can also be used by mediator user B in other departments, so the d and e parameters of mediator user A can be additionally calculated and saved to the database. In fact, there are also a and b parameters in the algorithm body. Although they are not used in the current calculation, their appearance in the union parameters does not affect the execution of the algorithm.

[0031] Step S130, calculating the monthly salary of the corresponding mediator user through the target salary calculator.

[0032] In one embodiment, as long as the mediator user data collected contains the corresponding calculator parameters, the target salary calculator can be used. Through the selection and calculation of the above parameters, the algorithm switching between departments of the same project can be realized, which is convenient for the company to judge the advantages and disadvantages of different department algorithms under the same input.

[0033] Figure 2 An entity relationship diagram among users, departments, projects, calculators, and calculator parameters is shown.

[0034] Figure 3 A flowchart of a calculator construction is shown, comprising the following steps S11 to S1: Step S11, compile the corresponding project QLExpress algorithm body; Step S12, extract the parameters required by the algorithm to construct a parameter persistence object; the parameter persistence object can construct a Java object according to the specific business, and then save it to the parameter table. For example, I can find the cases assigned to this person through the case information uploaded in Excel or the case information entered by the system, and the total case amount is the case amount entrusted by this person. The other parameters are similar.

[0035] Step S13, the calculator entity is saved to the database; Step S14, associating the calculator entities by person, department, and project in the calculator association table; Step S15, register the payment information and upload the case payment data; Step S16, executing the calculator parameter persister; Step S17, obtaining the result of step S12, and outputting a parameter persistence object; Step S18, serialize the data into the database according to the project code, person, year, and month as unique identifiers.

[0036] Furthermore, the present application also provides a specific salary calculation method, see Figure 4 As shown, it mainly includes the following steps: Step S21, the timer triggers salary calculation; Step S22, obtaining all users from the system user table; Step S23, obtaining the department to which the user belongs and the projects undertaken by the department through the user ID; Step S24, query the calculator association table to obtain all calculators, query the calculator parameter table to obtain all parameters of the mediator user and project, and convert the parameters into calculator context. In actual applications, after the user logs in, the user's ID and department ID can be obtained. Through the department, the project code corresponding to the department can be found. Through these two fields, the specific calculator code can be found. Then the corresponding calculator can be obtained through the calculator code. The calculator algorithm body field contains the QLExpress expression, which can be executed to obtain the result after all the parameters are complete.

[0037] Step S25, obtain the unified QLExpress Runner through RunnerFactory, which includes all external functions used by the algorithm; Step S26, call the calculator executor to execute, obtain the required external parameters through the algorithm body, and determine whether the context contains the parameters required by the calculator. If not, execute step S27, if yes, execute step S28. In one implementation method, whether the parameters are complete can be determined by obtaining the algorithm body and then parsing it through the syntax tree. There is a value field in the parameter table, which stores the parameter value, and a name field, which stores the parameter name. Through user_id, year, and month, you can get the parameters of the current user in a certain month, such as the number of commissioned cases in July and the amount of repayments in July.

[0038] Step S27, waiting for the next cycle, the required parameters may be provided by other calculators; Step S28, executing the calculator and saving the execution result into the context; Step S29, determine the type of calculator, if it is a salary calculator, save the calculation result and the return value name configured by the calculator into the salary details table; Step S30, summarizing the salary details table, and the obtained data is the payable salary.

[0039] In summary, by collecting user information in a decentralized manner, the computing efficiency is greatly improved, and the algorithm can be modified and switched online, which can provide managers with specific data that they rely on for decision-making.

[0040] Based on the above method embodiment, the present application embodiment also provides a mediation salary calculation device for dynamically adjusting salary, which is applied to the mediation system corresponding to the mediator salary calculation; see Figure 5 As shown, the device mainly includes the following parts: The acquisition module 510 is used to obtain the monthly payment data of the mediator user and the project information corresponding to the mediator user; A matching module 520, for determining target salary calculator parameters according to user information and project information corresponding to the mediator user, and matching the target salary calculator based on the salary calculator parameters; The calculation module 530 is used to calculate the monthly salary of the corresponding mediator user through the target salary calculator.

[0041] In a feasible implementation manner, the acquisition module 510 is used to: When each mediator registers for payment collection, it triggers the acquisition of the mediator's payment collection data for the current month; or, Get the monthly payment data of the mediator user based on the preset timer trigger.

[0042] In a feasible implementation manner, the matching module 520 is used to: Query the calculator association table to obtain all calculators, query the calculator parameter table to obtain the user parameters corresponding to the mediator user and the project parameters corresponding to the undertaken project information, and convert the user parameters and project parameters into calculator context; When the calculator context contains the parameters required for the calculator to execute, the target salary calculator is matched based on the calculator context.

[0043] In a feasible implementation manner, the device further includes a judgment module, which is used to: Determine whether the calculator context contains the parameters required for calculator execution; If it is not completely included, get the external parameters and wait for the next polling calculation; If included, the target salary calculator is executed immediately for calculation.

[0044] In a feasible implementation manner, the matching module 520 is used to: Determine whether the calculation type corresponding to the salary calculator parameter is a salary calculator; If yes, then match the target salary calculator based on the salary calculator parameters.

[0045] In a feasible implementation manner, the device further includes a writing module, which is used to: Write the corresponding project QLExpress algorithm based on the salary calculation method corresponding to the mediator user; Extract QLExpress algorithm parameters and build parameter persistence objects; The persistent objects are determined as user parameters corresponding to the mediator user and project parameters corresponding to the undertaken project information.

[0046] In a feasible implementation manner, the device further includes a collection calling module, which is used to: If the department parameters or project parameters corresponding to the first mediator user and the second mediator user are different, extracting the union parameters corresponding to the different mediator users; Determine the user parameters corresponding to the first mediator user or the second mediator user and the project parameters corresponding to the undertaken project information according to the union parameters; When calculating the monthly salary, the parameters in the union parameters that do not belong to the corresponding mediator user will be ignored.

[0047] The implementation principle and technical effects of the salary adjustment calculation device for dynamically adjusting salary provided in the embodiment of the present application are the same as those of the aforementioned method embodiment. For the sake of brief description, for parts not mentioned in the embodiment of the salary adjustment calculation device for dynamically adjusting salary, reference may be made to the corresponding contents in the aforementioned embodiment of the salary adjustment calculation method for dynamically adjusting salary.

[0048] The present application also provides an electronic device, such as Figure 6 As shown, it is a structural diagram of the electronic device, wherein the electronic device 100 includes a processor 61 and a memory 60, the memory 60 stores computer executable instructions that can be executed by the processor 61, and the processor 61 executes the computer executable instructions to implement any of the above-mentioned methods for dynamically adjusting salary calculation.

[0049] exist Figure 6 In the illustrated embodiment, the electronic device further includes a bus 62 and a communication interface 63 , wherein the processor 61 , the communication interface 63 and the memory 60 are connected via the bus 62 .

[0050] Among them, the memory 60 may include a high-speed random access memory (RAM), and may also include a non-volatile memory (non-volatile memory), such as at least one disk storage. The communication connection between the system network element and at least one other network element is realized through at least one communication interface 63 (which can be wired or wireless), and the Internet, wide area network, local area network, metropolitan area network, etc. can be used. The bus 62 can be an ISA (Industry Standard Architecture) bus, a PCI (Peripheral Component Interconnect) bus or an EISA (Extended Industry Standard Architecture) bus, etc. The bus 62 can be divided into an address bus, a data bus, a control bus, etc. For ease of representation, Figure 6 Only one bidirectional arrow is used in the diagram, but this does not mean that there is only one bus or only one type of bus.

[0051] The processor 61 may be an integrated circuit chip with signal processing capabilities. In the implementation process, each step of the above method can be completed by the hardware integrated logic circuit or software instructions in the processor 61. The above processor 61 can be a general-purpose processor, including a central processing unit (CPU), a network processor (NP), etc.; it can also be a digital signal processor (DSP), an application-specific integrated circuit (ASIC), a field-programmable gate array (FPGA), or other programmable logic devices, discrete gates or transistor logic devices, discrete hardware components. The general-purpose processor can be a microprocessor or the processor can also be any conventional processor. The steps of the method disclosed in the embodiment of the present application can be directly embodied as a hardware decoding processor to execute, or the hardware and software modules in the decoding processor can be executed. The software module can be located in a mature storage medium in the field such as a random access memory, a flash memory, a read-only memory, a programmable read-only memory, or an electrically erasable programmable memory, a register, etc. The storage medium is located in the memory, and the processor 61 reads the information in the memory and completes the steps of the salary adjustment calculation method for dynamically adjusting the salary in the above-mentioned embodiment in combination with its hardware.

[0052] An embodiment of the present application also provides a computer-readable storage medium, which stores computer-executable instructions. When the computer-executable instructions are called and executed by a processor, the computer-executable instructions prompt the processor to implement the above-mentioned method of dynamically adjusting salary for calculating mediated salary. The specific implementation can be found in the aforementioned method embodiment, which will not be repeated here.

[0053] The computer program product of the method, device, equipment and medium for dynamically adjusting salary provided in the embodiments of the present application includes a computer-readable storage medium storing program code. The instructions included in the program code can be used to execute the method in the previous method embodiment. The specific implementation can be found in the method embodiment, which will not be repeated here.

[0054] Unless otherwise specifically stated, the relative steps, numerical expressions and values ​​of the components and steps set forth in these embodiments do not limit the scope of the present application.

[0055] If the function is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a non-volatile computer-readable storage medium that is executable by a processor. Based on this understanding, the technical solution of the present application, or the part that contributes to the prior art or the part of the technical solution, can be embodied in the form of a software product. The computer software product is stored in a storage medium, including several instructions for a computer device (which can be a personal computer, server, or network device, etc.) to execute all or part of the steps of the various embodiments of the present application. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), disk or optical disk, and other media that can store program codes.

[0056] In the description of the present application, it should be noted that the terms "first", "second", etc. are only used to distinguish the description and cannot be understood as indicating or implying relative importance.

[0057] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present application, rather than to limit it. Although the present application has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or replace some or all of the technical features therein with equivalents. However, these modifications or replacements do not cause the essence of the corresponding technical solutions to deviate from the scope of the technical solutions of the embodiments of the present application.

Claims

1. A method for calculating salary by dynamically adjusting salary, characterized in that: The method is applied to the calculation of the mediator's salary corresponding to the mediation system; the method comprises: Obtain the monthly payment data of the mediator user and the project information corresponding to the mediator user; Determine target salary calculator parameters according to the user information corresponding to the mediator user and the undertaken project information, and match the target salary calculator based on the salary calculator parameters; The target salary calculator calculates the corresponding monthly salary of the mediator user.

2. The method for calculating salary by dynamically adjusting salary according to claim 1, characterized in that: Get the monthly payment data of the mediator user, including: When each mediator registers for payment collection, it triggers the acquisition of the payment collection data of the mediator user for the current month; or, The monthly payment data of the mediator user is obtained based on a preset timer trigger.

3. The method for calculating salary by dynamically adjusting salary according to claim 1, characterized in that: Determining target salary calculator parameters according to the user information corresponding to the mediator user and the undertaken project information, and matching the target salary calculator based on the salary calculator parameters, including: Query the calculator association table to obtain all calculators, query the calculator parameter table to obtain the user parameters corresponding to the mediator user and the project parameters corresponding to the project information, and convert the user parameters and the project parameters into calculator context; When the calculator context contains parameters required for calculator execution, a target salary calculator is matched based on the calculator context.

4. The method for calculating salary by dynamically adjusting salary according to claim 3, characterized in that: The method further comprises: Determining whether the calculator context contains parameters required for calculator execution; If it is not completely included, get the external parameters and wait for the next polling calculation; If included, the target salary calculator is immediately executed for calculation.

5. The method for calculating salary by dynamically adjusting salary according to claim 3, characterized in that: Matching a target salary calculator based on the salary calculator parameters includes: Determine whether the calculation type corresponding to the salary calculator parameter is a salary calculator; If yes, a target salary calculator is matched based on the salary calculator parameters.

6. The method for calculating salary by dynamically adjusting salary according to claim 3, characterized in that: The method further comprises: Write the corresponding project QLExpress algorithm based on the salary calculation method corresponding to the mediator user; Extract the QLExpress algorithm body parameters and construct a parameter persistence object; The persistent object is determined as the user parameters corresponding to the mediator user and the project parameters corresponding to the undertaken project information.

7. The method for calculating salary by dynamically adjusting salary according to claim 6, characterized in that: The method further comprises: If the department parameters or project parameters corresponding to the first mediator user and the second mediator user are different, extracting the union parameters corresponding to the different mediator users; Determine the user parameters corresponding to the first mediator user or the second mediator user and the project parameters corresponding to the undertaken project information according to the union parameters; When calculating the monthly salary, the parameters in the union parameters that do not belong to the corresponding mediator user are ignored.

8. A salary calculation device for dynamically adjusting salary, characterized in that: The device is applied to the calculation of the mediator's salary corresponding to the mediation system; the device comprises: An acquisition module is used to obtain the monthly payment data of the mediator user and the project information corresponding to the mediator user; A matching module, used for determining target salary calculator parameters according to the user information corresponding to the mediator user and the undertaken project information, and matching the target salary calculator based on the salary calculator parameters; A calculation module is used to calculate the corresponding monthly salary of the mediator user through the target salary calculator.

9. An electronic device, characterized in that: It includes a processor and a memory, wherein the memory stores computer executable instructions that can be executed by the processor, and the processor executes the computer executable instructions to implement the salary adjustment calculation method for dynamically adjusting salary as described in any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer-executable instructions. When the computer-executable instructions are called and executed by the processor, the computer-executable instructions prompt the processor to implement the salary adjustment calculation method for dynamically adjusting salary as described in any one of claims 1 to 7.

Images