CN117494689A - Payroll template generation method, device, apparatus, storage medium and program product - Google Patents
Payroll template generation method, device, apparatus, storage medium and program product Download PDFInfo
- Publication number
- CN117494689A CN117494689A CN202311154196.5A CN202311154196A CN117494689A CN 117494689 A CN117494689 A CN 117494689A CN 202311154196 A CN202311154196 A CN 202311154196A CN 117494689 A CN117494689 A CN 117494689A
- Authority
- CN
- China
- Prior art keywords
- item
- payroll
- instruction
- selectable
- template
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 50
- 238000004590 computer program Methods 0.000 claims abstract description 40
- 230000007246 mechanism Effects 0.000 claims abstract description 38
- 238000012163 sequencing technique Methods 0.000 claims abstract description 9
- 238000004364 calculation method Methods 0.000 claims description 8
- 230000004044 response Effects 0.000 claims description 7
- 238000012217 deletion Methods 0.000 claims description 6
- 230000037430 deletion Effects 0.000 claims description 6
- 230000000875 corresponding effect Effects 0.000 description 90
- 230000008520 organization Effects 0.000 description 18
- 238000010586 diagram Methods 0.000 description 9
- 238000004891 communication Methods 0.000 description 5
- 238000012545 processing Methods 0.000 description 5
- 230000008859 change Effects 0.000 description 2
- 238000013500 data storage Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 239000000203 mixture Substances 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 230000003068 static effect Effects 0.000 description 2
- OKTJSMMVPCPJKN-UHFFFAOYSA-N Carbon Chemical compound [C] OKTJSMMVPCPJKN-UHFFFAOYSA-N 0.000 description 1
- 238000004458 analytical method Methods 0.000 description 1
- 230000001413 cellular effect Effects 0.000 description 1
- 230000002596 correlated effect Effects 0.000 description 1
- 239000000284 extract Substances 0.000 description 1
- 229910021389 graphene Inorganic materials 0.000 description 1
- 238000003384 imaging method Methods 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 239000000463 material Substances 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000000630 rising effect Effects 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/125—Finance or payroll
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- General Health & Medical Sciences (AREA)
- General Engineering & Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Computational Linguistics (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Artificial Intelligence (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The present application relates to a payroll template generation method, apparatus, computer device, storage medium and computer program product. The method comprises the following steps: receiving a payroll template configuration instruction, wherein the configuration instruction carries a mechanism identifier; determining a preference based on the configuration instruction; displaying optional matters corresponding to the mechanism identifications, wherein the optional matters are obtained by sequencing the occurrence times of the optional matters in a historical payroll template of the mechanism corresponding to the mechanism identifications; receiving a selectable item selection instruction, and determining a selectable item based on the selectable item selection instruction; when the options determined by the option selection instruction have parent-level options, acquiring parent-level options corresponding to the options; adding the selectable item under a corresponding parent level selectable item; a payroll template is generated based on the requisite, parent level and optional items. By adopting the method, the intelligent level of the payroll template can be improved.
Description
Technical Field
The present application relates to the field of computer technology, and in particular, to a payroll template generation method, apparatus, computer device, storage medium, and computer program product.
Background
At present, two main modes of payroll issuing in enterprises are as follows: paper payroll and electronic payroll. The paper payroll is very complicated to manufacture, consumes manpower and material resources and is extremely low in efficiency. Along with the rising of employee cost, many enterprises have begun to reform HR office modes through technological means, and the use of software products to process transactional work is one of them by using electronic payroll to replace traditional paper payroll. The electronic payroll is simple to manufacture, low in cost, efficient and safe.
However, the electronic payroll is often created by requiring the enterprise to first fill in the elements of the template file, the fixed header, the fixed payroll name, etc. The current fixed form of gauge outfit and payroll is not intelligent enough in the use.
Disclosure of Invention
In view of the foregoing, it is desirable to provide a payroll template generation method, apparatus, computer device, computer-readable storage medium, and computer program product that can improve the level of intelligence of a payroll template.
In a first aspect, the present application provides a payroll template generation method, the method comprising:
receiving a payroll template configuration instruction, wherein the configuration instruction carries a mechanism identifier;
determining a preference based on the configuration instruction;
displaying optional matters corresponding to the mechanism identifications, wherein the optional matters are obtained by sequencing the occurrence times of the optional matters in a historical payroll template of the mechanism corresponding to the mechanism identifications;
receiving a selectable item selection instruction, and determining a selectable item based on the selectable item selection instruction;
when the options determined by the option selection instruction have parent-level options, acquiring parent-level options corresponding to the options; adding the selectable item under a corresponding parent level selectable item;
a payroll template is generated based on the requisite items, the parent level options, and the options.
In one embodiment, before receiving the payroll template configuration instruction, the method includes:
receiving a payroll template query instruction, wherein the query instruction carries selectable query items and query logic of the selectable query items;
querying each stored payroll template based on the selectable query item and query logic of the selectable query item, wherein the stored payroll templates are stored with the selectable item as an index;
Outputting the matched payroll templates, and marking the matched types corresponding to the output payroll templates;
and receiving a payroll template selection instruction based on the matching type, and acquiring a selected payroll template based on the payroll template selection instruction.
In one embodiment, after the step of acquiring the selected payroll template based on the payroll template selection instruction, the method further comprises:
displaying the obtained payroll template and receiving a matter adjusting instruction aiming at the payroll template;
adjusting the payroll template based on the item adjustment instruction;
and storing the payroll template with the item adjusted by taking the item adjusted as an index.
In one embodiment, after the determining the selectable item based on the selectable item selection instruction, the method further includes:
when the selectable item determined by the selectable item selection instruction is a sub-level selectable item, the sub-level selectable item is displayed, and the sub-level selectable item is adjusted in response to a sub-level selectable item adjustment instruction.
In one embodiment, the method further comprises:
receiving a matter editing instruction;
When the item editing instruction is a deletion instruction, deleting the item corresponding to the item editing instruction;
when the item editing instruction is an addition instruction, inquiring whether the name of the new item corresponding to the addition instruction is stored or not;
when the name of the added item is not stored, an item identification is generated based on the added item name, a hierarchy item of the added item is configured, and the added item is stored based on the item identification and the hierarchy item.
In one embodiment, after the generating payroll templates based on the preferences and the selectable items, the generating comprises:
receiving a data source configuration instruction, and determining a data source corresponding to the work order template based on the data source configuration instruction;
when a wage calculation instruction is received, corresponding wage bill data is obtained from the data source;
and calculating parameter values of all matters in the payroll template based on the payroll data.
In a second aspect, the present application further provides a payroll template generating device, the device including:
the configuration instruction receiving module is used for receiving a payroll template configuration instruction, and the configuration instruction carries a mechanism identifier;
A necessity determining module for determining a necessity based on the configuration instruction;
the selectable item display module is used for displaying selectable items corresponding to the mechanism identifications, wherein the selectable items are obtained by sequencing the occurrence times of the selectable items in the historical payroll templates of the mechanisms corresponding to the mechanism identifications;
a selectable item determination module for receiving a selectable item selection instruction and determining a selectable item based on the selectable item selection instruction;
the classifying module is used for acquiring the father-level selectable item corresponding to the selectable item when the selectable item determined by the selectable item selecting instruction has the father-level selectable item; adding the selectable item under a corresponding parent level selectable item;
and the payroll template generation module is used for generating payroll templates based on the requisite items, the father-level optional items and the optional items.
In a third aspect, the present application also provides a computer device comprising a memory storing a computer program and a processor implementing the steps of the method of any one of the embodiments described above when the computer program is executed by the processor.
In a fourth aspect, the present application also provides a computer readable storage medium having stored thereon a computer program which, when executed by a processor, implements the steps of the method of any of the embodiments described above.
In a fifth aspect, the present application also provides a computer program product comprising a computer program which, when executed by a processor, implements the steps of the method of any of the embodiments described above.
The payroll template generation method, the device, the computer equipment, the storage medium and the computer program product can be used for configuring the payroll template according to requirements, when a payroll template configuration instruction is received, the necessary items are firstly determined, the selectable items are acquired based on the institutions, the selectable items are obtained by ordering the occurrence times of the selectable items in the historical payroll templates of the institutions corresponding to the identification of the institutions, so that the earlier items are easier to select, the configuration efficiency of users on the selectable items can be improved, the selectable items of each institution are possibly different in ordering, the selectable items are ordered based on the identification of the institutions, the intelligent level is higher, finally, when the selectable items exist in the parent level, the selectable items are automatically added to the corresponding parent level selectable items, the manual setting is not needed again, the payroll template is generated based on the necessary items and the selectable items, the fixed payroll templates are not only, and the intelligent level of the payroll template is improved.
Drawings
FIG. 1 is an application environment diagram of a method for generating a payroll template in one embodiment;
FIG. 2 is a flow chart of a method of generating a payroll template in one embodiment;
FIG. 3 is a schematic diagram of a payroll template creation interface in one embodiment;
FIG. 4 is a schematic diagram of an alternative selection interface in one embodiment;
FIG. 5 is a schematic diagram of a payroll template in one embodiment;
FIG. 6 is a schematic diagram of an item level in one embodiment;
FIG. 7 is a block diagram of an exemplary job ticket template generator;
fig. 8 is an internal structural diagram of a computer device in one embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application will be further described in detail with reference to the accompanying drawings and examples. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the present application.
The payroll template generation method provided by the embodiment of the application can be applied to an application environment shown in fig. 1. Wherein the terminal 102 communicates with the server 104 via a network. The data storage system may store data that the server 104 needs to process. The data storage system may be integrated on the server 104 or may be located on a cloud or other network server.
The terminal 102 is used for configuring the payroll templates, and sends the configured payroll templates to the server 104 for storage, firstly, the terminal 102 receives a payroll template configuration instruction, and the configuration instruction carries a mechanism identifier; determining a preference based on the configuration instructions; displaying optional matters corresponding to the mechanism identifications, wherein the optional matters are obtained by sequencing the occurrence times of the optional matters in the historical payroll templates of the mechanisms corresponding to the mechanism identifications; receiving a selectable item selection instruction, and determining a selectable item based on the selectable item selection instruction; a payroll template is generated based on the preferences and the selectable items.
The payroll templates can be configured according to requirements, when a payroll template configuration instruction is received, the necessary items are determined first, the optional items are obtained based on the institutions, the optional items are obtained by sorting the occurrence times of the optional items in the historical payroll templates of the institutions corresponding to the institutions, so that the more front items are easier to select, the configuration efficiency of the optional items by users can be improved, the optional items of each institution are possibly different in sorting, the optional items are sorted based on the institutions, the intelligent level is higher, finally, the payroll templates are generated based on the necessary items and the optional items, and the intelligent level of the payroll templates is improved.
The terminal 102 may be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers, internet of things devices, and portable wearable devices, where the internet of things devices may be smart speakers, smart televisions, smart air conditioners, smart vehicle devices, and the like. The portable wearable device may be a smart watch, smart bracelet, headset, or the like. The server 104 may be implemented as a stand-alone server or as a server cluster of multiple servers.
In one embodiment, as shown in fig. 2, a payroll template generating method is provided, and the method is applied to the terminal in fig. 1 for illustration, and includes the following steps:
s202: and receiving a payroll template configuration instruction, wherein the configuration instruction carries an organization identifier.
Specifically, the payroll template configuration instruction is an instruction to newly create a payroll template for newly configuring a payroll template. The organization identifier is an identifier of an organization corresponding to the payroll template to be established, for example, it may be various branch companies, sub-companies, departments, etc. corresponding to the enterprise, which is not limited herein. In one alternative embodiment, the organization identification may be an identification corresponding to the organization architecture displayed in the payroll template configuration interface. Specifically, as shown in connection with fig. 3, when the payroll template is created in fig. 3, the terminal responds to the selection instruction of the corresponding organization identifier, and then the terminal responds to the creation instruction, thereby creating a new payroll template of the organization corresponding to the organization identifier.
S204: the preferences are determined based on the configuration instructions.
Specifically, the payroll template includes the necessary items and optional items, wherein the necessary items are necessary information in the payroll template, which is indispensable. The selectable items in the payroll template, which may be determined based on the permissions, are selectable, e.g., the permissions corresponding to the persons of the different organizational structures are different, and the information displayed in the payroll template is different. In other embodiments, the selectable items are different payroll compositions based on personnel of different organizational architectures, or different payroll compositions at different times. For example, there are high temperature patches in summer, holiday welfare in holidays, etc.
In one alternative embodiment, the preferences include name, year and month of payroll, and payroll account, among others. The essential item system is directly defaulted, does not need user configuration, reduces operation and improves efficiency.
S206: and displaying optional matters corresponding to the organization identification, wherein the optional matters are obtained by sorting the occurrence times of the optional matters in the historical payroll templates of the organizations corresponding to the organization identification.
Specifically, the selectable matters are obtained by sorting the occurrence times of the selectable matters in the historical payroll templates of the mechanism corresponding to the mechanism identifications, the terminal sends the payroll templates to the server for storage after generating the payroll templates, the server extracts the mechanism identifications corresponding to the payroll templates, then queries the historical payroll templates corresponding to the mechanism identifications, reads the selectable matters in the historical payroll templates and the newly generated selectable matters of the payroll templates, counts the occurrence times of the selectable matters, sorts the selectable matters according to the order of more or less, and finally stores the selectable matters arranged according to the order. When the terminal creates a payroll template, the necessary items are acquired from the server through the first thread, and are directly displayed, the sequentially arranged selectable items corresponding to the organization identification are queried from the server through the second thread parallel to the first thread, and are displayed on the terminal, wherein the terminal optionally only displays the front preset number of selectable items, such as front 20.
S208: a selectable item selection instruction is received and a selectable item is determined based on the selectable item selection instruction.
Specifically, the option selection instruction is a selection of a displayed option, and specifically, as shown in conjunction with fig. 4, the terminal displays a plurality of options and receives the option selection instruction, so that the terminal obtains a corresponding option based on the selection of the user.
In one alternative embodiment, the displayed terminal selectable items are of the categorical type, wherein the first type is present in the institution's historical payroll template and ordered by number of occurrences. The second type is that the historical payroll templates of the institution are not presented, and the selectable items are ranked according to the number of times the selectable items appear in the historical payroll templates of the institution of the organization at the higher level of the institution. So that the user can select the corresponding option from among the different types of options as desired.
In other alternative embodiments, the terminal may also receive a new instruction for the option, such that after the option is added, the new option is added to the payroll template.
S210: a payroll template is generated based on the preferences and the selectable items.
Specifically, in conjunction with FIG. 5, FIG. 5 is a schematic illustration of a payroll template in one embodiment including a must-be name, issue year and month, and payroll account, including optional revenue and payout items, where the revenue items include basic payroll, performance payroll. The payouts include individual tax deductions, endowment insurance, and the like.
According to the payroll template generation method, the payroll templates can be configured according to requirements, when the payroll template configuration instruction is received, the necessary items are determined firstly, the optional items are acquired based on the institutions, the optional items are obtained by sorting the occurrence times of the optional items in the historical payroll templates of the institutions corresponding to the identification of the institutions, so that the earlier optional items are easier to select, the configuration efficiency of users on the optional items can be improved, the sorting of the optional items of each institution may be different, the optional items are sorted based on the identification of the institutions, the intelligentization level is higher, finally, the payroll templates are generated based on the necessary items and the optional items, and therefore, the intelligentization level of the payroll templates is improved instead of only fixed payroll templates.
In one alternative embodiment, prior to receiving the payroll template configuration instruction, the method comprises: receiving a payroll template query instruction, wherein the query instruction carries selectable query items and query logic of the selectable query items; querying each stored payroll template based on the selectable query item and query logic of the selectable query item, wherein the stored payroll templates are stored with the selectable item as an index; outputting the matched payroll templates, and marking the matched types corresponding to the output payroll templates; and receiving a payroll template selection instruction based on the matching type, and acquiring the selected payroll template based on the payroll template selection instruction.
Specifically, in this embodiment, the historically generated payroll templates are stored, so that the payroll templates can be directly used by the user. Wherein the payroll templates store, when stored, selectable items in the payroll templates as an index to the payroll templates. When a payroll template query instruction is received, the index is searched based on the selectable query matters carried by the query instruction and the query logic of the selectable query matters, so that a search result is rapidly determined. Specifically, the selectable query items are items carried in the query instruction. The query logic of the selectable query terms may be boolean operation-based query logic including and, or and, and the like. The terminal matches the index of each payroll template based on the query logic and the optional query matters, thereby obtaining the successfully matched payroll templates.
The matching type is obtained based on a matching result of the payroll template, and comprises complete matching and no other optional matters, complete matching and other optional matters and incomplete matching, and when the payroll template obtained by the query is output, the terminal displays the corresponding payroll templates according to the sequence of complete matching and no other optional matters, complete matching and other optional matters and incomplete matching.
The user can determine whether to create a payroll template or adjust based on the queried payroll template according to the matching type. Therefore, after the matched payroll template is output and inquired, the command of newly-built payroll template, namely the configuration command of the payroll template above can be received so as to open a new payroll template. In other embodiments, the terminal may further receive a payroll template selection instruction, and obtain the selected payroll template based on the payroll template selection instruction, for example, when there is a complete match and no redundant selectable item, the payroll template may be directly obtained, and if a corresponding selectable item is required to be added subsequently, the corresponding selectable item may be directly added, or a payroll template that is complete match and has other selectable items may be selected, where the number of other selectable items in the payroll template that is complete match and has other selectable items may be displayed in the matching type, and the payroll template may be sorted according to the number, and the user may obtain the corresponding payroll template according to the requirement.
In the above embodiment, before the payroll template is newly created, whether the existing payroll template exists or not may be first queried, and if so, the existing payroll template is directly selected for direct use by the user, thereby improving efficiency.
In one alternative embodiment, after the selected payroll template is obtained based on the payroll template selection instruction, the method further comprises: displaying the obtained payroll template and receiving a matter adjusting instruction aiming at the payroll template; adjusting the payroll template based on the item adjustment instruction; and storing the payroll template with the item adjusted by taking the item adjusted as an index.
After the payroll template is selected, the terminal displays the payroll template, so that a user can adjust the existing payroll template to obtain the payroll template meeting the requirements of the user. For example, some items may be deleted, or new items may be added, some items may be adjusted, and so on. And after the matters in the payroll template are adjusted, the required payroll template is obtained, and the payroll template is stored, wherein the storing method is to store the matters-adjusted payroll template and the matters-adjusted payroll template in a correlated way, so that selectable matters in the payroll template are stored as indexes of the payroll template, and the subsequent query of the payroll template is facilitated.
In the above embodiment, before the payroll template is newly created, whether the existing payroll template exists or not may be first queried, and if so, the existing payroll template is directly selected for direct use by the user, thereby improving efficiency. And when the payroll templates are stored, selectable matters in the payroll templates are used as indexes of the payroll templates to be stored, so that the follow-up query of the payroll templates is facilitated.
In one embodiment, the selectable items include different levels of selectable items; after determining the selectable item based on the selectable item selection instruction, further comprising: displaying the sub-level options when the options determined by the option selection instruction are sub-level options, and adjusting the sub-level options in response to a sub-level option adjustment instruction; when the options determined by the option selection instruction have parent-level options, acquiring parent-level options corresponding to the options; the selectable item is added under the corresponding parent level selectable item.
Specifically, in conjunction with fig. 6, fig. 6 is a schematic diagram of two levels of transactions in one embodiment, where in this embodiment, the transactions may include a parent level and a child level, and in other embodiments, the transactions may also be three or four levels, where the transactions of each level need to include a transaction number, a transaction name, a level value, and whether there is a primary transaction or a secondary transaction, and the corresponding database is designed to:
Table one-level Item table item_lv1_tbl
| English field name | Chinese field name | Meaning of field |
| item_Lv1_no | First level item numbering | |
| item_Lv1_name | First level item name | |
| item_Lv1_val | First order term value | |
| is_inc_Lv2 | Whether or not to contain secondary items | 1-containing; 0-not containing |
Table II two level Item table Item Lv2 Tbl
When the selectable item is determined, if the selectable item determined by the selectable item selection instruction is a first-level selectable item, displaying a sub-level selectable item corresponding to the first-level selectable item, and the terminal can receive an adjustment instruction for the sub-level selectable item.
In addition, when the selectable item has a parent level selectable item, the parent level selectable item is acquired, whether the selected selectable item has the parent level selectable item or not is judged, if not, the parent level selectable item is added, and otherwise, the selectable item is directly added to the corresponding parent level selectable item.
In the above embodiment, since the selectable items have different levels, after selecting the selectable items, automatic processing is required according to the levels of the selectable items, so that the processing efficiency is improved.
In one of the alternative embodiments, the method further comprises: receiving a matter editing instruction; when the item editing instruction is a deletion instruction, deleting the item corresponding to the item editing instruction; when the item editing instruction is a new instruction, inquiring whether the name of a new item corresponding to the new instruction is stored; when the name of the new item is not stored, an item identification is generated based on the name of the new item, a hierarchy item of the new item is configured, and the new item is stored based on the item identification and the hierarchy item.
In particular, the item editing instructions may be delete instructions, such as deleting corresponding items in a payroll template. The item newly-added instruction is a corresponding item newly-added in the payroll template, wherein when the item is newly added, if the item is newly-added, the item is directly added into the payroll template, if the item is not newly-added, the name of the item is input, a new item identification is obtained based on a historical item identification, for example, the item identification is obtained in an incremental mode, the hierarchy item of the item is configured, and the item is stored based on the item identification and the hierarchy item. Specifically, in connection with fig. 6, each item of the hierarchy needs to include an item number, an item name, a hierarchy value, and whether there is a primary item or a secondary item, and when an item is newly added, the values need to be arranged one by one.
In one of the alternative embodiments, after generating the payroll template based on the preferences and the options, it includes: receiving a data source configuration instruction, and determining a data source corresponding to the work order template based on the data source configuration instruction; when a wage calculation instruction is received, corresponding wage bill data is obtained from a data source; and calculating and obtaining parameter values of all matters in the payroll template based on the payroll data.
In this embodiment, mainly, payroll generation is performed, in which, because data related to payroll is more secret, a certain authority needs to be set, and therefore, a data source corresponding to a work sheet template is determined based on a data source configuration instruction, so that a corresponding data source is set. When a calculation instruction is received, corresponding payroll data is acquired from a data source, and thus parameter values of all matters in the payroll template are calculated based on the payroll data.
In the above embodiment, the data authority in the payroll template is configured in advance, so that the corresponding payroll data is obtained, and thus the parameter values of all matters in the payroll template are calculated based on the payroll data.
It should be understood that, although the steps in the flowcharts related to the above embodiments are sequentially shown as indicated by arrows, these steps are not necessarily sequentially performed in the order indicated by the arrows. The steps are not strictly limited to the order of execution unless explicitly recited herein, and the steps may be executed in other orders. Moreover, at least some of the steps in the flowcharts described in the above embodiments may include a plurality of steps or a plurality of stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of the steps or stages is not necessarily performed sequentially, but may be performed alternately or alternately with at least some of the other steps or stages.
Based on the same inventive concept, the embodiment of the application also provides a payroll template generating device for realizing the payroll template generating method. The implementation of the solution provided by the device is similar to the implementation described in the above method, so the specific limitation in the embodiments of the payroll template generating device or devices provided below may be referred to the limitation of the payroll template generating method hereinabove, and will not be repeated here.
In one embodiment, as shown in fig. 7, there is provided a payroll template generating apparatus comprising: a configuration instruction receiving module 701, a necessity item determining module 702, a selectable item displaying module 703, a selectable item determining module 704, a categorizing module 705, and a payroll template generating module 706, wherein:
a configuration instruction receiving module 701, configured to receive a payroll template configuration instruction, where the configuration instruction carries a mechanism identifier;
a preferences determination module 702 for determining preferences based on the configuration instructions;
a selectable item display module 703, configured to display selectable items corresponding to the organization identifier, where the selectable items are obtained by sorting the occurrence times of the selectable items in the historical payroll template of the organization corresponding to the organization identifier;
A selectable item determination module 704 for receiving a selectable item selection instruction and determining a selectable item based on the selectable item selection instruction;
the classifying module 705 is configured to obtain a parent-level option corresponding to the option when the option determined by the option selection instruction has the parent-level option; adding the selectable item under a corresponding parent level selectable item;
payroll template generation module 706 for generating payroll templates based on the preferences, parent level preferences, and preferences.
In one embodiment, the apparatus further includes:
the inquiry command receiving module is used for receiving a payroll template inquiry command, wherein the inquiry command carries selectable inquiry matters and inquiry logic of the selectable inquiry matters;
the query module is used for querying each stored payroll template based on the selectable query items and the query logic of the selectable query items, wherein the stored payroll templates are stored by taking the selectable items as indexes;
the output module is used for outputting the matched payroll template and marking the matched type corresponding to the output payroll template;
the template selection module is used for receiving the payroll template selection instruction based on the matching type and acquiring the selected payroll template based on the payroll template selection instruction.
In one embodiment, the apparatus further includes:
the adjustment instruction receiving module is used for displaying the obtained payroll template and receiving a transaction adjustment instruction aiming at the payroll template;
the adjusting module is used for adjusting the payroll template based on the item adjusting instruction;
and the storage module is used for storing the transaction bill template after the transaction adjustment by taking the adjusted transaction as an index.
In one embodiment, the apparatus further includes:
and the optional item adjustment module is used for displaying the sub-level optional item when the optional item determined by the optional item selection instruction is the sub-level optional item, and adjusting the sub-level optional item in response to the sub-level optional item adjustment instruction.
In one embodiment, the apparatus further includes:
the editing instruction receiving module is used for receiving the item editing instruction;
the deleting module is used for deleting the item corresponding to the item editing instruction when the item editing instruction is the deleting instruction;
the new adding module is used for inquiring whether the name of the new item corresponding to the new adding instruction is stored or not when the item editing instruction is the new adding instruction; when the name of the new item is not stored, an item identification is generated based on the name of the new item, a hierarchy item of the new item is configured, and the new item is stored based on the item identification and the hierarchy item.
In one embodiment, the apparatus further includes:
the data source configuration instruction receiving module 701 is configured to receive a data source configuration instruction, and determine a data source corresponding to the work order template based on the data source configuration instruction;
the wage generation module is used for acquiring corresponding wage data from a data source when receiving a wage calculation instruction; and calculating and obtaining parameter values of all matters in the payroll template based on the payroll data.
The various modules in the payroll template generation apparatus described above may be implemented in whole or in part by software, hardware, and combinations thereof. The above modules may be embedded in hardware or may be independent of a processor in the computer device, or may be stored in software in a memory in the computer device, so that the processor may call and execute operations corresponding to the above modules.
In one embodiment, a computer device is provided, which may be a terminal, and the internal structure thereof may be as shown in fig. 8. The computer device includes a processor, a memory, an input/output interface, a communication interface, a display unit, and an input means. The processor, the memory and the input/output interface are connected through a system bus, and the communication interface, the display unit and the input device are connected to the system bus through the input/output interface. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The input/output interface of the computer device is used to exchange information between the processor and the external device. The communication interface of the computer device is used for carrying out wired or wireless communication with an external terminal, and the wireless mode can be realized through WIFI, a mobile cellular network, NFC (near field communication) or other technologies. The computer program when executed by a processor implements a payroll template generation method. The display unit of the computer device is used for forming a visual picture, and can be a display screen, a projection device or a virtual reality imaging device. The display screen can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, can also be a key, a track ball or a touch pad arranged on the shell of the computer equipment, and can also be an external keyboard, a touch pad or a mouse and the like.
It will be appreciated by those skilled in the art that the structure shown in fig. 8 is merely a block diagram of some of the structures associated with the present application and is not limiting of the computer device to which the present application may be applied, and that a particular computer device may include more or fewer components than shown, or may combine certain components, or have a different arrangement of components.
In one embodiment, a computer device is provided comprising a memory and a processor, the memory having stored therein a computer program, the processor when executing the computer program performing the steps of: receiving a payroll template configuration instruction, wherein the configuration instruction carries an organization identifier; determining a preference based on the configuration instructions; displaying optional matters corresponding to the mechanism identifications, wherein the optional matters are obtained by sequencing the occurrence times of the optional matters in the historical payroll templates of the mechanisms corresponding to the mechanism identifications; receiving a selectable item selection instruction, and determining a selectable item based on the selectable item selection instruction; when the options determined by the option selection instruction have parent-level options, acquiring parent-level options corresponding to the options; adding the selectable item under a corresponding parent level selectable item; payroll templates are generated based on the preferences, parent level preferences, and preferences.
In one embodiment, prior to receiving payroll template configuration instructions implemented when the processor executes the computer program, the method comprises: receiving a payroll template query instruction, wherein the query instruction carries selectable query items and query logic of the selectable query items; querying each stored payroll template based on the selectable query item and query logic of the selectable query item, wherein the stored payroll templates are stored with the selectable item as an index; outputting the matched payroll templates, and marking the matched types corresponding to the output payroll templates; and receiving a payroll template selection instruction based on the matching type, and acquiring the selected payroll template based on the payroll template selection instruction.
In one embodiment, after the processor executes the computer program to obtain the selected payroll template based on the payroll template selection instruction, the method further comprises: displaying the obtained payroll template and receiving a matter adjusting instruction aiming at the payroll template; adjusting the payroll template based on the item adjustment instruction; and storing the payroll template with the item adjusted by taking the item adjusted as an index.
In one embodiment, after determining the selectable item based on the selectable item selection instruction implemented when the processor executes the computer program, further comprises: when the selectable item determined by the selectable item selection instruction is a sub-level selectable item, the sub-level selectable item is displayed, and the sub-level selectable item is adjusted in response to a sub-level selectable item adjustment instruction.
In one embodiment, the processor when executing the computer program further performs the steps of: receiving a matter editing instruction; when the item editing instruction is a deletion instruction, deleting the item corresponding to the item editing instruction; when the item editing instruction is a new instruction, inquiring whether the name of a new item corresponding to the new instruction is stored; when the name of the new item is not stored, an item identification is generated based on the name of the new item, a hierarchy item of the new item is configured, and the new item is stored based on the item identification and the hierarchy item.
In one embodiment, after generating the payroll template based on the mandatory and optional items implemented when the processor executes the computer program, comprises: receiving a data source configuration instruction, and determining a data source corresponding to the work order template based on the data source configuration instruction; when a wage calculation instruction is received, corresponding wage bill data is obtained from a data source; and calculating and obtaining parameter values of all matters in the payroll template based on the payroll data.
In one embodiment, a computer readable storage medium is provided having a computer program stored thereon, which when executed by a processor, performs the steps of: receiving a payroll template configuration instruction, wherein the configuration instruction carries an organization identifier; determining a preference based on the configuration instructions; displaying optional matters corresponding to the mechanism identifications, wherein the optional matters are obtained by sequencing the occurrence times of the optional matters in the historical payroll templates of the mechanisms corresponding to the mechanism identifications; receiving a selectable item selection instruction, and determining a selectable item based on the selectable item selection instruction; when the options determined by the option selection instruction have parent-level options, acquiring parent-level options corresponding to the options; adding the selectable item under a corresponding parent level selectable item; payroll templates are generated based on the preferences, parent level preferences, and preferences.
In one embodiment, prior to receiving payroll template configuration instructions, which are implemented when the computer program is executed by the processor, comprises: receiving a payroll template query instruction, wherein the query instruction carries selectable query items and query logic of the selectable query items; querying each stored payroll template based on the selectable query item and query logic of the selectable query item, wherein the stored payroll templates are stored with the selectable item as an index; outputting the matched payroll templates, and marking the matched types corresponding to the output payroll templates; and receiving a payroll template selection instruction based on the matching type, and acquiring the selected payroll template based on the payroll template selection instruction.
In one embodiment, after the computer program is executed by the processor to obtain the selected payroll template based on the payroll template selection instruction, the method further comprises: displaying the obtained payroll template and receiving a matter adjusting instruction aiming at the payroll template; adjusting the payroll template based on the item adjustment instruction; and storing the payroll template with the item adjusted by taking the item adjusted as an index.
In one embodiment, after determining the selectable items based on the selectable item selection instructions, which is implemented when the computer program is executed by the processor, further comprises: when the selectable item determined by the selectable item selection instruction is a sub-level selectable item, the sub-level selectable item is displayed, and the sub-level selectable item is adjusted in response to a sub-level selectable item adjustment instruction.
In one embodiment, the computer program when executed by the processor further performs the steps of: receiving a matter editing instruction; when the item editing instruction is a deletion instruction, deleting the item corresponding to the item editing instruction; when the item editing instruction is a new instruction, inquiring whether the name of a new item corresponding to the new instruction is stored; when the name of the new item is not stored, an item identification is generated based on the name of the new item, a hierarchy item of the new item is configured, and the new item is stored based on the item identification and the hierarchy item.
In one embodiment, after generating the payroll template based on the mandatory and optional items, as implemented when the computer program is executed by the processor, comprises: receiving a data source configuration instruction, and determining a data source corresponding to the work order template based on the data source configuration instruction; when a wage calculation instruction is received, corresponding wage bill data is obtained from a data source; and calculating and obtaining parameter values of all matters in the payroll template based on the payroll data.
In one embodiment, a computer program product is provided comprising a computer program which, when executed by a processor, performs the steps of: receiving a payroll template configuration instruction, wherein the configuration instruction carries an organization identifier; determining a preference based on the configuration instructions; displaying optional matters corresponding to the mechanism identifications, wherein the optional matters are obtained by sequencing the occurrence times of the optional matters in the historical payroll templates of the mechanisms corresponding to the mechanism identifications; receiving a selectable item selection instruction, and determining a selectable item based on the selectable item selection instruction; when the options determined by the option selection instruction have parent-level options, acquiring parent-level options corresponding to the options; adding the selectable item under a corresponding parent level selectable item; payroll templates are generated based on the preferences, parent level preferences, and preferences.
In one embodiment, prior to receiving payroll template configuration instructions, which are implemented when the computer program is executed by the processor, comprises: receiving a payroll template query instruction, wherein the query instruction carries selectable query items and query logic of the selectable query items; querying each stored payroll template based on the selectable query item and query logic of the selectable query item, wherein the stored payroll templates are stored with the selectable item as an index; outputting the matched payroll templates, and marking the matched types corresponding to the output payroll templates; and receiving a payroll template selection instruction based on the matching type, and acquiring the selected payroll template based on the payroll template selection instruction.
In one embodiment, after the computer program is executed by the processor to obtain the selected payroll template based on the payroll template selection instruction, the method further comprises: displaying the obtained payroll template and receiving a matter adjusting instruction aiming at the payroll template; adjusting the payroll template based on the item adjustment instruction; and storing the payroll template with the item adjusted by taking the item adjusted as an index.
In one embodiment, after determining the selectable items based on the selectable item selection instructions, which is implemented when the computer program is executed by the processor, further comprises: when the selectable item determined by the selectable item selection instruction is a sub-level selectable item, the sub-level selectable item is displayed, and the sub-level selectable item is adjusted in response to a sub-level selectable item adjustment instruction.
In one embodiment, the computer program when executed by the processor further performs the steps of: receiving a matter editing instruction; when the item editing instruction is a deletion instruction, deleting the item corresponding to the item editing instruction; when the item editing instruction is a new instruction, inquiring whether the name of a new item corresponding to the new instruction is stored; when the name of the new item is not stored, an item identification is generated based on the name of the new item, a hierarchy item of the new item is configured, and the new item is stored based on the item identification and the hierarchy item.
In one embodiment, after generating the payroll template based on the mandatory and optional items, as implemented when the computer program is executed by the processor, comprises: receiving a data source configuration instruction, and determining a data source corresponding to the work order template based on the data source configuration instruction; when a wage calculation instruction is received, corresponding wage bill data is obtained from a data source; and calculating and obtaining parameter values of all matters in the payroll template based on the payroll data.
It should be noted that, the user information (including, but not limited to, user equipment information, user personal information, etc.) and the data (including, but not limited to, data for analysis, stored data, presented data, etc.) referred to in the present application are information and data authorized by the user or sufficiently authorized by each party, and the collection, use and processing of the related data are required to comply with the related laws and regulations and standards of the related countries and regions.
Those skilled in the art will appreciate that implementing all or part of the above described methods may be accomplished by way of a computer program stored on a non-transitory computer readable storage medium, which when executed, may comprise the steps of the embodiments of the methods described above. Any reference to memory, database, or other medium used in the various embodiments provided herein may include at least one of non-volatile and volatile memory. The nonvolatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical Memory, high density embedded nonvolatile Memory, resistive random access Memory (ReRAM), magnetic random access Memory (Magnetoresistive Random Access Memory, MRAM), ferroelectric Memory (Ferroelectric Random Access Memory, FRAM), phase change Memory (Phase Change Memory, PCM), graphene Memory, and the like. Volatile memory can include random access memory (Random Access Memory, RAM) or external cache memory, and the like. By way of illustration, and not limitation, RAM can be in the form of a variety of forms, such as static random access memory (Static Random Access Memory, SRAM) or dynamic random access memory (Dynamic Random Access Memory, DRAM), and the like. The databases referred to in the various embodiments provided herein may include at least one of relational databases and non-relational databases. The non-relational database may include, but is not limited to, a blockchain-based distributed database, and the like. The processors referred to in the embodiments provided herein may be general purpose processors, central processing units, graphics processors, digital signal processors, programmable logic units, quantum computing-based data processing logic units, etc., without being limited thereto.
The technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.
The above examples only represent a few embodiments of the present application, which are described in more detail and are not to be construed as limiting the scope of the present application. It should be noted that it would be apparent to those skilled in the art that various modifications and improvements could be made without departing from the spirit of the present application, which would be within the scope of the present application. Accordingly, the scope of protection of the present application shall be subject to the appended claims.
Claims (10)
1. A payroll template generation method, the method comprising:
receiving a payroll template configuration instruction, wherein the configuration instruction carries a mechanism identifier;
determining a preference based on the configuration instruction;
displaying optional matters corresponding to the mechanism identifications, wherein the optional matters are obtained by sequencing the occurrence times of the optional matters in a historical payroll template of the mechanism corresponding to the mechanism identifications;
Receiving a selectable item selection instruction, and determining a selectable item based on the selectable item selection instruction;
when the options determined by the option selection instruction have parent-level options, acquiring parent-level options corresponding to the options; adding the selectable item under a corresponding parent level selectable item;
a payroll template is generated based on the requisite items, the parent level options, and the options.
2. The method of claim 1, wherein prior to receiving payroll template configuration instructions, comprising:
receiving a payroll template query instruction, wherein the query instruction carries selectable query items and query logic of the selectable query items;
querying each stored payroll template based on the selectable query item and query logic of the selectable query item, wherein the stored payroll templates are stored with the selectable item as an index;
outputting the matched payroll templates, and marking the matched types corresponding to the output payroll templates;
and receiving a payroll template selection instruction based on the matching type, and acquiring a selected payroll template based on the payroll template selection instruction.
3. The method of claim 2, wherein after the obtaining the selected payroll template based on the payroll template selection instruction, further comprising:
displaying the obtained payroll template and receiving a matter adjusting instruction aiming at the payroll template;
adjusting the payroll template based on the item adjustment instruction;
and storing the payroll template with the item adjusted by taking the item adjusted as an index.
4. A method according to any one of claims 1 to 3, wherein after determining a selectable item based on the selectable item selection instruction, further comprising:
when the selectable item determined by the selectable item selection instruction is a sub-level selectable item, the sub-level selectable item is displayed, and the sub-level selectable item is adjusted in response to a sub-level selectable item adjustment instruction.
5. The method according to claim 4, wherein the method further comprises:
receiving a matter editing instruction;
when the item editing instruction is a deletion instruction, deleting the item corresponding to the item editing instruction;
when the item editing instruction is an addition instruction, inquiring whether the name of the new item corresponding to the addition instruction is stored or not;
When the name of the added item is not stored, an item identification is generated based on the added item name, a hierarchy item of the added item is configured, and the added item is stored based on the item identification and the hierarchy item.
6. A method according to any one of claims 1 to 3, wherein after said generating a payroll template based on said preferences, said parent level preferences and said preferences, comprising:
receiving a data source configuration instruction, and determining a data source corresponding to the work order template based on the data source configuration instruction;
when a wage calculation instruction is received, corresponding wage bill data is obtained from the data source;
and calculating parameter values of all matters in the payroll template based on the payroll data.
7. A payroll template generation apparatus, the apparatus comprising:
the configuration instruction receiving module is used for receiving a payroll template configuration instruction, and the configuration instruction carries a mechanism identifier;
a necessity determining module for determining a necessity based on the configuration instruction;
the selectable item display module is used for displaying selectable items corresponding to the mechanism identifications, wherein the selectable items are obtained by sequencing the occurrence times of the selectable items in the historical payroll templates of the mechanisms corresponding to the mechanism identifications;
A selectable item determination module for receiving a selectable item selection instruction and determining a selectable item based on the selectable item selection instruction;
the classifying module is used for acquiring the father-level selectable item corresponding to the selectable item when the selectable item determined by the selectable item selecting instruction has the father-level selectable item; adding the selectable item under a corresponding parent level selectable item;
and the payroll template generation module is used for generating payroll templates based on the requisite items, the father-level optional items and the optional items.
8. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor implements the steps of the method of any of claims 1 to 6 when the computer program is executed.
9. A computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any of claims 1 to 6.
10. A computer program product comprising a computer program, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311154196.5A CN117494689A (en) | 2023-09-07 | 2023-09-07 | Payroll template generation method, device, apparatus, storage medium and program product |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311154196.5A CN117494689A (en) | 2023-09-07 | 2023-09-07 | Payroll template generation method, device, apparatus, storage medium and program product |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117494689A true CN117494689A (en) | 2024-02-02 |
Family
ID=89671447
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311154196.5A Pending CN117494689A (en) | 2023-09-07 | 2023-09-07 | Payroll template generation method, device, apparatus, storage medium and program product |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117494689A (en) |
-
2023
- 2023-09-07 CN CN202311154196.5A patent/CN117494689A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102999561B (en) | The context trend of data set and data, services | |
| US10824758B2 (en) | System and method for managing enterprise data | |
| US20170161323A1 (en) | Automatic generation of sub-queries | |
| JP2006228229A (en) | Intellectual property management system | |
| CN114115844A (en) | Page generation method and device, computer equipment and storage medium | |
| US20190073599A1 (en) | Systems and methods for expediting rule-based data processing | |
| US10956408B2 (en) | Data transformation tool | |
| CN116305895A (en) | Product model generation method, device, computer equipment and storage medium | |
| US8856126B2 (en) | Simplifying grouping of data items stored in a database | |
| CN117494689A (en) | Payroll template generation method, device, apparatus, storage medium and program product | |
| GB2526910A (en) | Report generation system and method | |
| CN114926019A (en) | Resource object information configuration method and device, computer equipment and storage medium | |
| WO2018206819A1 (en) | Data storage method and apparatus | |
| CN114239525A (en) | Contract template editing method and device, computer equipment and storage medium | |
| US11238108B1 (en) | Custom data filtering systems and methods | |
| CN115408396B (en) | Method, device, computer equipment and storage medium for storing business data | |
| US20230297622A1 (en) | Custom data filtering systems and methods | |
| CN117669528A (en) | Document generation method, device, computer equipment and storage medium | |
| CN115878746A (en) | Policy text determination method and device | |
| CN115495184A (en) | Document control processing method, device, equipment, medium and computer program product | |
| WO2023133622A1 (en) | Computer-implemented visual query matching methods, and systems for implementing thereof | |
| CN114663207A (en) | Receipt generation method and device, computer equipment and storage medium | |
| CN114547066A (en) | Nuclear power business data standardization method and device and computer equipment | |
| CN117171193A (en) | Data generation method, device, computer equipment and storage medium | |
| CN114519062A (en) | Basic data updating method and device, computer equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |