Processing Method, Device, Equipment and Medium of Payroll Template

Abstract

The present disclosure provides a method for processing a payslip template, which relates to the field of financial technology or other fields. The processing method includes: dividing the payslip template into at least one payslip level according to the attribute information of the payslip content to be filled, wherein each payslip level includes at least one itemized entry; marking each itemized entry to generate the corresponding relationship and positional relationship between the itemized entries; wherein the corresponding relationship is the relationship between the first-level item in the itemized entry and the n-level item corresponding to the first-level item, where n is an integer greater than 2; adding or deleting itemized entries according to the corresponding relationship and positional relationship; and according to the corresponding relationship and positional relationship, reading the first-level items of the payslip template one by one, using the same first-level item as the key, and reading all the n-level items under the first-level item as the value to integrate the same first-level items. The present disclosure also provides a device for processing a payslip template, an electronic device, a medium, and a program product.

Description

Technical Field

[0001] The present disclosure relates to the field of fintech or other fields, and particularly to a method, apparatus, device and medium for processing a payslip template. Background Art

[0002] The payslip function is a display in which an enterprise online banking user fills in the salary details of employees according to a unified template (such as a form) and uploads them through the online banking. After being parsed and processed by the bank system, the detailed results are presented to individual employees. Employees can query the list, detailed information, summary information, etc. of the payslip through personal online banking, mobile banking, etc.

[0003] However, in the existing payslip template, the number of payslip items is mostly fixed, and the number of income and expenditure items is fixed. For example, the income figures must be filled in columns 11 - 85, and the expenditure figures must be filled in columns 86 - 160. The requirements for the number of items, filling positions, etc. are immutable. If the number of income items exceeds 75, this template is no longer applicable. In addition, the existing payslip template does not support multi-level custom names, does not support disordered input, and for payslip items with an amount of "0" or empty when an enterprise fills in the payslip, different enterprises cannot flexibly customize whether not to show them to employees. Moreover, the existing payslip template only supports employees holding bank cards of this bank to view through personal mobile banking, online banking, etc. If an employee has not opened a bank card of this bank, there is no channel to view their payslip information.

[0004] Disclosure Content

[0005] In view of this, on the one hand, the present disclosure provides a method for processing a payslip template, including: dividing the payslip template into at least one payslip level according to the attribute information of the salary content to be filled, where each payslip level includes at least one detail item; marking each detail item to generate the corresponding relationship and position relationship between the detail items; where the corresponding relationship is the relationship between the first-level item in the detail item and the n-level item corresponding to the first-level item, where n is an integer greater than 2; adding or deleting the detail items according to the corresponding relationship and position relationship; and according to the corresponding relationship and position relationship, reading the first-level items of the payslip template one by one, using the same first-level item as the key, and reading all the n-level items under the first-level item as the value to integrate the same first-level items.

[0006] According to an embodiment of the present disclosure, the processing method further includes: setting batch numbers for payroll templates of different forms of the same enterprise; constructing a hierarchical relationship table to store the corresponding relationship and positional relationship; setting a primary key of the hierarchical relationship table according to the enterprise number and the batch number, where the primary key is used to represent payroll templates of different forms of the same enterprise; calling the hierarchical relationship table to add, delete, or read the detail items.

[0007] According to an embodiment of the present disclosure, the processing method further includes: setting optional configuration fields in the payroll template, where the optional configuration fields are used to control whether to display items with an amount of zero or empty items.

[0008] According to an embodiment of the present disclosure, the marking of each detail item includes: marking each detail item through an oracle table auto-increment sequence.

[0009] According to an embodiment of the present disclosure, the step of sequentially reading the first-level items of the payroll template according to the corresponding relationship and the positional relationship includes: sequentially reading the first-level items of the payroll template in the data structure of HashMap.

[0010] According to an embodiment of the present disclosure, the processing method further includes: constructing an employee information table to store the basic information of the employees included in the payroll template, where the employee information table uses the employee number, the type of identity document, and the document number as the primary key.

[0011] According to an embodiment of the present disclosure, the processing method further includes: uploading the employee number, the type of identity document, and the document number through the client; verifying whether there is matching employee information in the employee information table through the online banking interface, and if so, sending a random verification code to the matching employee for verification; after the verification is passed, querying the payroll information of the employee in the payroll template through the online banking interface, and displaying the payroll information in the form of a list on the client; when the user clicks on a piece of payroll information in the list, performing secondary identity verification, and after the verification is passed, displaying the detailed information.

[0012] On the other hand, the present disclosure provides a method for processing a payslip template, including: a dividing module for dividing the payslip template into at least one payslip level according to the attribute information of the payslip content to be filled, where each payslip level includes at least one detail item; a marking module for marking each detail item to generate the corresponding relationship and positional relationship between the detail items; where the corresponding relationship is the relationship between the first-level item and the n-level item corresponding to the first-level item in the detail item, where n is an integer greater than 2; a modification module for adding or deleting the detail items according to the corresponding relationship and positional relationship; and a reading module for reading the first-level items of the payslip template one by one according to the corresponding relationship and positional relationship, using the same first-level item as the key and reading all the n-level items under the same first-level item as the value to integrate the same first-level items.

[0013] According to an embodiment of the present disclosure, the processing device further includes: a first setting module for setting a batch number for different forms of payslip templates of the same enterprise; a first building module for building a hierarchical relationship table to store the corresponding relationship and positional relationship; a second setting module for setting the primary key of the hierarchical relationship table according to the number of the enterprise and the batch number, where the primary key is used to represent different forms of payslip templates of the same enterprise; a calling module for calling the hierarchical relationship table to add, delete, or read the detail items.

[0014] According to an embodiment of the present disclosure, the processing device further includes: a third setting module for setting an optional configuration field in the payslip template, where the optional configuration field is used to control whether to display items with an amount of zero or empty items.

[0015] Another aspect of the present disclosure provides an electronic device, including: one or more processors; a memory for storing one or more programs, where when the one or more programs are executed by the one or more processors, the one or more processors are caused to implement the method as described above.

[0016] Another aspect of the present disclosure provides a computer-readable storage medium storing computer-executable instructions, where the instructions are used to implement the method as described above when executed.

[0017] Another aspect of the present disclosure provides a computer program, where the computer program includes computer-executable instructions, and the instructions are used to implement the method as described above when executed. BRIEF DESCRIPTION OF THE DRAWINGS

[0018] Figure 1 Schematically shows a system architecture 100 of a method and system for processing a payslip template according to an embodiment of the present disclosure;

[0019] Figure 2 Schematically shows a flowchart of a method for processing a payslip template according to an embodiment of the present disclosure;

[0020] Figure 3 Schematically shows a hierarchical structure diagram of a payslip template provided by an embodiment of the present disclosure;

[0021] Figure 4 Schematically shows a block diagram of out-of-order input of a payslip template according to an embodiment of the present disclosure;

[0022] Figure 5 Schematically shows a processing method diagram of a payslip template according to another embodiment of the present disclosure;

[0023] Figure 6 Schematically shows a processing method diagram of a payslip template according to another embodiment of the present disclosure;

[0024] Figure 7 Schematically shows a payslip template diagram provided with optional configuration fields according to an embodiment of the present disclosure;

[0025] Figure 8 Schematically shows a flowchart of a method for processing a payslip template according to another embodiment of the present disclosure;

[0026] Figure 9 Schematically shows a flowchart of a method for processing a payslip template according to another embodiment of the present disclosure;

[0027] Figure 10 Schematically shows an application scenario diagram of a method for processing a payslip template according to an embodiment of the present disclosure;

[0028] Figure 11 Schematically shows a block diagram of a processing device for a payslip template according to an embodiment of the present disclosure;

[0029] Figure 12 Schematically shows a block diagram of a processing device for a payslip template according to another embodiment of the present disclosure;

[0030] Figure 13 Schematically shows a block diagram of a processing device for a payslip template according to another embodiment of the present disclosure;

[0031] Figure 14 Schematically shows a block diagram of an electronic device suitable for implementing the method described above according to an embodiment of the present disclosure. Detailed implementation manners

[0032] Hereinafter, embodiments of the present disclosure will be described with reference to the accompanying drawings. However, it should be understood that these descriptions are merely exemplary and are not intended to limit the scope of the present disclosure. In the following detailed description, for the sake of explanation, numerous specific details are set forth to provide a thorough understanding of the embodiments of the present disclosure. However, it is obvious that one or more embodiments can be implemented without these specific details. In addition, in the following description, descriptions of well-known structures and technologies are omitted to avoid unnecessarily confusing the concepts of the present disclosure.

[0033] The terms used herein are merely for describing specific embodiments and are not intended to limit the present disclosure. The terms "including", "comprising", etc. used herein indicate the presence of the described features, steps, operations, and / or components, but do not exclude the presence or addition of one or more other features, steps, operations, or components.

[0034] All terms used herein (including technical and scientific terms) have the meanings commonly understood by those of ordinary skill in the art, unless otherwise defined. It should be noted that the terms used herein should be interpreted as having a meaning consistent with the context of this specification and should not be interpreted in an idealized or overly rigid manner.

[0035] In cases where expressions such as "at least one of A, B, and C, etc." are used, generally, it should be interpreted according to the meaning commonly understood by those of ordinary skill in the art (for example, "a system having at least one of A, B, and C" should include, but not be limited to, a system having only A, only B, only C, having A and B, having A and C, having B and C, and / or having A, B, and C, etc.). In cases where expressions such as "at least one of A, B, or C, etc." are used, generally, it should be interpreted according to the meaning commonly understood by those of ordinary skill in the art (for example, "a system having at least one of A, B, or C" should include, but not be limited to, a system having only A, only B, only C, having A and B, having A and C, having B and C, and / or having A, B, and C, etc.).

[0036] Some block diagrams and / or flowcharts are shown in the accompanying drawings. It should be understood that some blocks or combinations of blocks in the block diagrams and / or flowcharts can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, or other programmable data processing device, so that when executed by the processor, these instructions can create a device for implementing the functions / operations illustrated in these block diagrams and / or flowcharts. The technology of the present disclosure can be implemented in the form of hardware and / or software (including firmware, microcode, etc.). In addition, the technology of the present disclosure can take the form of a computer program product on a computer-readable storage medium storing instructions, which can be used by or in conjunction with an instruction execution system.

[0037] In the technical solution of the present disclosure, the collection, storage, use, processing, transmission, provision, disclosure, and application of the user's personal information comply with the provisions of relevant laws and regulations, necessary confidentiality measures are taken, and public order and good customs are not violated.

[0038] In the technical solution of the present disclosure, the authorization or consent of the user is obtained before obtaining or collecting the user's personal information.

[0039] An embodiment of the present disclosure provides a method for processing a payslip template, including: dividing the payslip template into at least one payslip level according to the attribute information of the payslip content to be filled, where each payslip level includes at least one detail item. Mark each detail item to generate the corresponding relationship and positional relationship between the detail items; where the corresponding relationship is the relationship between the first-level item in the detail item and the n-level item corresponding to the first-level item, where n is an integer greater than 2. Add or delete detail items according to the corresponding relationship and positional relationship. According to the corresponding relationship and positional relationship, read the first-level items of the payslip template one by one, use the same first-level item as the key, and read all the n-level items under the first-level item as the value to integrate the same first-level item.

[0040] Figure 1 The system architecture 100 of the method and system for processing a payslip template according to an embodiment of the present disclosure is schematically shown. It should be noted that Figure 1 The figure shown is only an example of the system architecture to which the embodiments of the present disclosure can be applied to help those skilled in the art understand the technical content of the present disclosure, but it does not mean that the embodiments of the present disclosure cannot be used in other devices, systems, environments or scenarios.

[0041] As Figure 1 shown, the system architecture 100 according to this embodiment may include clients 101, 102, a network 103, and a server 104. The network 103 is used to provide a communication link between the clients 101, 102 and the server 104.

[0042] The client devices 101 and 102 can be various electronic devices with a display screen and accessible input devices for information input, including but not limited to smartphones, tablets, desktop PCs, laptop PCs, netbook computers, workstations, servers, game consoles, etc. The electronic devices can be used by enterprise human resources personnel to log in to the enterprise online banking through personnel permissions to enter the payroll submission page of the server, download the latest payroll template, and fill it in according to the template instructions. The electronic devices can also be used for employees to input identity information during the payroll information query process. The network 103 can include various connection types, such as wired, wireless communication links, or fiber optic cables, etc. Among them, the wired method can be connected using any one of the following multiple interfaces with a cable: Fibre Channel, infrared interface, D-type data interface, serial interface, USB interface, USB Type-C interface, or Dock interface. The wireless method can be connected using wireless communication, and the wireless communication can adopt any one of multiple wireless technology standards such as Bluetooth, Wi-Fi, Infrared, ZigBee, etc. The server 104 can obtain the payroll content to be filled through the network 103, divide the payroll template into at least one payroll level according to the attribute information of the payroll content to be filled, where each payroll level includes at least one item; mark each item to generate the corresponding relationship and position relationship between the items. Add or delete items according to the corresponding relationship and position relationship. The server 104 can also obtain the basic information of the employee through the network 103, query the payroll information of the employee according to the basic information, and send it to the client devices 101 and 102 through the network 103 for display. Among them, during the process of reading the payroll template, the server 104 is also used to read the first-level items of the payroll template one by one in the data structure of HashMap, use the same first-level items as the key, and read all the second-level items under the first-level items as the value to integrate the same first-level items.

[0043] It should be noted that the method for processing the payslip template provided by the embodiments of the present disclosure can be executed by the server 104. Correspondingly, the device for processing the payslip template provided by the embodiments of the present disclosure can be disposed in the server 104. Alternatively, the method for processing the payslip template provided by the embodiments of the present disclosure can also be executed by a server or a server cluster different from the server 104 and capable of communicating with the clients 101, 102, and / or the server 104. Correspondingly, the device for processing the payslip template provided by the embodiments of the present disclosure can also be disposed in a server or a server cluster different from the server 104 and capable of communicating with the clients 101, 102, and / or the server 104. Alternatively, the method for processing the payslip template provided by the embodiments of the present disclosure can also be partially executed by the server 104 and partially executed by the clients 101, 102. Correspondingly, the device for processing the payslip template provided by the embodiments of the present disclosure can also be partially disposed in the server 104 and partially disposed in the clients 101, 102.

[0044] It should be understood that Figure 1 the numbers of clients, networks, and servers in

[0045] The method for processing the payslip template provided by the embodiments of the present disclosure can be applied to the field of fintech. For example, in order to meet the personalized customization requirements of the payslip templates of various enterprises, a bank can adopt the method for processing the payslip template provided by the embodiments of the present disclosure to process the payslip templates. It should be understood that the method for processing the payslip template provided by the embodiments of the present disclosure is not limited to being applied to the field of fintech. The above description is only exemplary. For other fields that require processing of payslip templates, such as other non-financial product sales fields, e-commerce fields, logistics fields, etc., enterprises can apply the method for processing the payslip template provided by the embodiments of the present disclosure to process the payslip templates.

[0046] Figure 2 Schematically shows a flowchart of a method for processing a payslip template according to an embodiment of the present disclosure.

[0047] As Figure 2 shown, the method for processing the payslip template can, for example, include operations S201 to S204.

[0048] In operation S201, according to the attribute information of the salary content to be filled, the payslip template is divided into multiple payslip levels, where each payslip level includes at least one detail item.

[0049] In an embodiment of the present disclosure, the detailed items may include first-level items, second-level items, third-level items, …, n-level items, where n is an integer greater than 1. When the detailed items include multiple levels of items, each first-level item may correspond to second-level items, each second-level item may correspond to third-level items, and so on. Each (n - 1)-level item corresponds to at least one n-level item.

[0050] Figure 3 Schematically shows the hierarchical structure diagram of the payslip template provided by an embodiment of the present disclosure.

[0051] As Figure 3 shown, Figure 3 in the payslip, the salary and the five social insurances and one housing fund in the first row are the first-level items of the payslip, and at least one second-level item may be included under the first-level item. For example, the basic salary, attendance salary, and bonus salary are the second-level items under the first-level item of salary, and the old-age insurance, medical insurance, work-related injury insurance, and unemployment insurance are the second-level items under the first-level item of the five social insurances and one housing fund. The amount “10,000” and “-5,000” are the third-level items corresponding to the second-level items of the basic salary, attendance salary, bonus salary, old-age insurance, medical insurance, work-related injury insurance, and unemployment insurance. It should be understood that the specific division of the first-level items, second-level items, third-level items, etc. depends on actual needs. For example, if an enterprise only needs to display the total salary and the total amount of the five social insurances and one housing fund, then only one first-level item of salary and one corresponding second-level item of amount, and one first-level item of the five social insurances and one housing fund and one corresponding second-level item of amount are required in the payslip template. Another example is that if the payslip template of an enterprise needs to display the details of the salary and the five social insurances and one housing fund, it can be divided according to the Figure 3 shown payslip template. Thus, by adopting the multi-level division method for the payslip template, the customization of the name and quantity in the salary content can be realized.

[0052] In operation S202, each detailed item is marked to generate the corresponding relationship and positional relationship between the detailed items.

[0053] In an embodiment of the present disclosure, the corresponding relationship is the relationship between the first-level item and the n-level item corresponding to the first-level item in the detailed item, and the positional relationship is the position of each detailed item in the payslip template.

[0054] Specifically, the corresponding relationship and positional relationship of multiple payslip levels can be marked through the self-incrementing sequence of the oracle table. Specifically, when storing in the table, the self-incrementing sequence of the oracle table can be used to mark the position of each field. The self-incrementing sequence is the connection of the one-to-one corresponding relationships between the first-level item and the second-level item, the second-level item and the third-level item, etc. This connection relationship ensures that the data is stored completely in the order filled in by the customer.

[0055] In operation S203, the detailed items are added or deleted according to the corresponding relationship and positional relationship.

[0056] In the embodiments of the present disclosure, the auto-increment sequence serves as a position marker, reflecting the one-to-one correspondence and position relationship between first-level items and second-level items, second-level items and third-level items, etc. It allows the number of second-level items under each first-level item to be flexibly added or deleted. Regardless of the number of second-level items, there is a position number corresponding to the first-level item one by one. Therefore, the number of second-level items to n-level items can be added or deleted according to the auto-increment sequence marker of the oracle table, where n is an integer greater than or equal to 2.

[0057] In operation S204, according to the corresponding relationship and position relationship, read the first-level items of the payslip template one by one, use the same first-level items as keys, and read the n-level items under all first-level items as values to integrate the same first-level items.

[0058] In the embodiments of the present disclosure, during the process of reading the payslip template, read the first-level items of the payslip template one by one in the data structure of HashMap, use the same first-level items as keys, and read the second-level items under all first-level items as values to integrate the same first-level items.

[0059] Based on this reading method, the payslip template supports out-of-order input. Specifically, although the payslip information is stored in the oracle table in the same format and field order as the form filled in, when reading the data and presenting it to the customer, the data is read in the data structure of HashMap, that is, read the first-level items one by one, use the same first-level items as keys, and read the second-level items and amounts under all first-level items as values. The key-value form allows the payslip to be inserted out of order when filled in and submitted, which provides convenience for the personnel staff when submitting. Each time a new second-level item can be directly added after the last column without changing the order of the filled form each time, while ensuring the intuitiveness and readability when the employee queries. The personnel staff submits it out of order, and the customer views it in an integrated and classified manner on the mobile phone.

[0060] Figure 4 A block diagram showing the out-of-order input of the payslip template according to the embodiments of the present disclosure is schematically illustrated.

[0061] As Figure 4As shown, when the human resources specialist is inputting the salary, in the first two columns, the content of "salary" is input, columns 3 - 5 are "five social insurances and one housing fund", and in the 6th column, "salary" can also be filled in. Although the input is in a disordered order, during the reading process, according to the corresponding relationship and positional relationship, the data is read in the data structure of HashMap, that is, the first-level item "salary" in the first two columns and the first-level item "salary" in the 6th column are read one by one. Taking the first-level item "salary" as the key, then the second-level items "basic salary", "attendance salary", and "bonus salary" under the first-level item "salary" are read, and then they are integrated. When displaying, it can be shown that the first three columns are all "salary", and the last three columns are "five social insurances and one housing fund".

[0062] According to the method for processing the payslip template provided by the embodiments of the present disclosure, since the payslip template is hierarchically divided according to the attribute information of the salary content to be filled, and then each detailed item is marked to generate the corresponding relationship and positional relationship between the detailed items. Subsequently, the detailed items of the payslip template can be directly added or deleted according to the corresponding relationship and positional relationship, and different forms of payslip templates can be obtained. Compared with the traditional fixed-format payslip template, the format of the payslip is flexible and changeable. Different enterprises can use different formats of payslip templates, which improves the flexibility of the payslip template. Moreover, since the corresponding relationship and positional relationship record the corresponding relationship between the first-level item and the n-level item of the payslip template, for any order of payslip input, during the reading process, the data can be read in the data structure of HashMap, that is, the first-level items are read one by one, taking the same first-level item as the key, and reading all the second-level items and amounts under the first-level item as the value, and quickly integrating the same first-level item in the form of key-value. Furthermore, it allows disordered insertion when the payslip is filled and submitted, which provides convenience for the human resources personnel when submitting.

[0063] Figure 5 Schematically shows a processing method diagram of a payslip template according to another embodiment of the present disclosure.

[0064] As Figure 5 shown, the method may include operations S501 - S504 for example.

[0065] In operation S501, set batch numbers for different forms of payslip templates of the same enterprise.

[0066] In the embodiments of the present disclosure, for the same enterprise, different formats of payslip templates may also be required. For example, a certain enterprise uploaded the first salary of 6 employees in the morning of January 1st, and then uploaded the second salary of these 6 employees in the afternoon of January 1st. The details and amounts of the two salaries are very different, that is, two completely different forms of payslip data (different forms of payslip templates can be based on Figure 2The method shown is implemented). To support payroll details with different numbers and names uploaded by the same company at different times, a batch number can be set for each payroll. As shown in Table 1:

[0067] Table 1

[0068]

[0069] Among them, the batch number GONGZI001 represents the payroll data uploaded in the morning, and GONGZI002 represents the payroll data uploaded in the afternoon. Each identical batch number corresponds to two records, one at level 1 and one at level 2. Level 2 is a sub-item of level 1. Each payroll file corresponds to a batch number, and based on the batch number, the details corresponding to each payroll can be found out.

[0070] In operation S502, construct a hierarchical relationship table to store the corresponding relationship and the positional relationship.

[0071] In the embodiment of the present disclosure, the corresponding relationship and the positional relationship are stored in the form of a table for convenient subsequent invocation.

[0072] In operation S503, set the primary key of the hierarchical relationship table according to the enterprise number and the batch number, where the primary key is used to represent different forms of payroll templates of the same enterprise.

[0073] In the embodiment of the present disclosure, the setting of the primary key allows the content of the payroll template uploaded by the same enterprise each time to be different, that is, the primary key is used to represent different forms of payroll templates of the same enterprise. For example, an enterprise generally sends holiday benefits to employees during legal holidays, and these benefits are also recorded in the payroll. Since there are no legal holidays in August and there are legal holidays in September, the payrolls to be uploaded in the two months are different. At this time, different primary keys can be set to distinguish different payrolls. Another example is for a certain group with four enterprises A, B, C, and D under it. Every quarter, the headquarters of the group needs to summarize and audit the payroll data of the employees of the four enterprises A, B, C, and D. For the convenience of the operation and distinction of the headquarters, for enterprise A, according to the enterprise number of enterprise A plus the batch number of the uploaded payroll, set the primary key of the hierarchical relationship table.

[0074] In operation S504, call the hierarchical relationship table to add, delete, or read the details.

[0075] According to the payroll template processing method provided by the embodiment of the present disclosure, set the primary key of the hierarchical relationship table according to the enterprise number and the batch number, so that different batches of payroll data of the same enterprise can use different formats of payroll templates. Since the corresponding relationship and the positional relationship are stored in the form of a table, the hierarchical relationship can be quickly called to add, delete, or read the details.

[0076] Figure 6 Schematically shows a diagram of a method for processing a payslip template according to another embodiment of the present disclosure.

[0077] As Figure 6 shown, the method for processing the payslip template may include, for example, operation S601.

[0078] In operation S205, an optional configuration field is set in the payslip template, where the optional configuration field is used to control whether to display items with an amount of zero or empty items.

[0079] In the embodiments of the present disclosure, for salary items with an amount of "0" or empty when an enterprise fills out a payslip, different enterprises can flexibly customize whether not to display them to employees.

[0080] Figure 7 Schematically shows a diagram of a payslip template provided with an optional configuration field according to an embodiment of the present disclosure.

[0081] As Figure 7 shown, there is an optional configuration field "whether to display salary items with an amount of 0 or empty" in the payslip template. If filled with "no", then for those with an empty or 0 amount in the original payslip template, they will not be displayed to the customer during query. Specifically, when the payslip is submitted, the configuration information of this batch will be stored after generating a unique batch number. This field is an attribute at the batch dimension. When an employee queries payslip information and clicks on a certain entry in the list to view the details, first judge the attribute of "whether to display salary items with an amount of 0 or empty" in the batch table. If it is "no", then when querying data from the table in the SQL statement, null or 0 will be filtered out. Here, for query efficiency, it is not filtered in the Java program.

[0082] According to the method for processing a payslip template provided by the embodiments of the present disclosure, since an optional configuration field is added to the payslip template, it is possible to flexibly select "whether to display salary items with an amount of 0 or empty", further improving the flexibility of the payslip template.

[0083] Figure 8 Schematically shows a flowchart of a method for processing a payslip template according to another embodiment of the present disclosure.

[0084] As Figure 8 shown, the method for processing the payslip template may include, for example, operation S205.

[0085] In operation S206, an employee information table is constructed to store the basic information of employees, where the employee information table uses the employee number, identity document type, and document number as the primary key.

[0086] The construction of this employee information table facilitates subsequent retrieval when employees query payslips.

[0087] Figure 9 Schematically shows a flowchart of a payroll template processing method according to another embodiment of the present disclosure.

[0088] As Figure 9 shown, the payroll template processing method may include operations S901 to S904, for example.

[0089] In operation S901, the employee number, ID type, and ID number are uploaded through the client.

[0090] The user can send "employee number + ID type + ID number" through the WeChat terminal.

[0091] In operation S902, through the online banking interface, check whether there is matching employee information in the employee information table. If there is, send a random verification code to the matching employee for verification.

[0092] After receiving the uploaded message, the online banking interface parses it and checks whether there is matching employee information in the oracle employee information table. If there is matching employee information, in order to prevent replay attacks, a verification code needs to be received on the mobile phone. The risk control system needs to verify the number of times this mobile phone has requested this transaction today. If the number of times exceeds the upper limit within a certain period of time, obtaining the verification code again is not allowed.

[0093] In operation S903, after the verification is passed, query the payroll information of the employee in the payroll template through the online banking interface, and display the payroll information in the form of a list on the client.

[0094] In operation S904, when the user clicks on a certain payroll information in the list, perform secondary identity verification. After the verification is passed, display the detailed information.

[0095] When the customer clicks on a certain one in the list and requests the detailed data again through the online banking interface and presents it to the customer in the way of providing an interface by the online banking, the data in the online banking database is shared. However, before sharing, there is another layer of identity verification. After the identity verification is passed, control of malicious access is added. This query method greatly facilitates non-bank customers to use the payroll function. At the same time, the multiple verification functions of the online banking interface also ensure the security of customer data.

[0096] Based on the payroll template processing method provided by the embodiments of the present disclosure, non-bank customers can also query the payroll through the WeChat terminal, enabling the online banking function to not only serve its own customers but also be extended to everyone. Further, it provides great help for the bank's business personnel to explore and expand customers, thereby improving the usability of the payroll template. Figure 10 Schematically shows an application scenario diagram of the payroll template processing method according to the embodiments of the present disclosure.

[0097] As shown in Figure 10 the figure, enterprise human resources personnel can log in to the enterprise online banking through the human resources authority USB key, enter the payslip submission page, download the latest payslip template, and fill it in according to the template instructions, supporting the personalized filling of payslip information for different enterprises. The background parsing thread parses and stores the data. Employees can send "employee number + ID type + ID number" through the WeChat terminal to query the corresponding payslip information.

[0098] Figure 11 A block diagram of a payslip template processing device according to an embodiment of the present disclosure is schematically shown.

[0099] As shown in Figure 11 the figure, the payslip template processing device 1100 may include, for example, a division module 1110, a marking module 1120, a modification module 1130, and a reading module 1140.

[0100] The division module 1110 is configured to divide the payslip template into at least one payslip level according to the attribute information of the payslip content to be filled, where each payslip level includes at least one detail item;

[0101] The marking module 1120 is configured to mark each detail item to generate a corresponding relationship and a positional relationship between the detail items; where the corresponding relationship is the relationship between the first-level item in the detail item and the n-level item corresponding to the first-level item, where n is an integer greater than 2.

[0102] The modification module 1130 is configured to add or delete detail items according to the corresponding relationship and the positional relationship.

[0103] The reading module 1140 is configured to sequentially read the first-level items of the payslip template according to the corresponding relationship and the positional relationship, use the same first-level item as the key, and read all the n-level items under the first-level item as the value to integrate the same first-level item.

[0104] According to the method for processing a payslip template provided by an embodiment of the present disclosure, since the payslip template is hierarchically divided according to the attribute information of the payslip content to be filled, and each detail item is marked to generate the corresponding relationship and positional relationship between the detail items, the detail items of the payslip template can be directly added or deleted according to the corresponding relationship and positional relationship in the subsequent process, and different forms of payslip templates can be obtained. Compared with the traditional fixed-format payslip template, the format of the payslip is flexible and changeable, and different enterprises can use different formats of payslip templates, improving the flexibility of the payslip template. Moreover, since the corresponding relationship and positional relationship record the corresponding relationship between the first-level items and the n-level items of the payslip template, for any order of payslip input, the data can be read in the data structure of HashMap during the reading process, that is, the first-level items are read one by one, the same first-level items are used as keys, and all the second-level items and amounts under the same first-level items are used as values, and the same first-level items are quickly integrated in the form of key-value, thereby allowing disordered insertion when the payslip is filled and submitted, providing convenience for the personnel staff when submitting.

[0105] Figure 12 Schematically shows a block diagram of a processing device for a payslip template according to another embodiment of the present disclosure.

[0106] As Figure 12 shown, the processing device 1100 for the payslip template may further include, for example, a first setting module 1150, a first building module 1160, a second setting module 1170, and a calling module 1180.

[0107] The first setting module 1150 is configured to set batch numbers for different forms of payslip templates of the same enterprise.

[0108] The first building module 1160 is configured to build a hierarchical relationship table to store the corresponding relationship and the positional relationship.

[0109] The second setting module 1170 is configured to set the primary key of the hierarchical relationship table according to the enterprise number and the batch number, where the primary key is used to represent different forms of payslip templates of the same enterprise.

[0110] The calling module 1180 is configured to call the hierarchical relationship table to add, delete, or read detail items.

[0111] According to the method for processing a payslip template provided by an embodiment of the present disclosure, the primary key of the hierarchical relationship table is set according to the enterprise number and the batch number, so that different batches of salary data of the same enterprise can use different formats of payslip templates. Since the corresponding relationship and the positional relationship are stored in the form of a table, the hierarchical relationship can be quickly called to add, delete, or read detail items.

[0112] Figure 13 A block diagram of a payroll template processing apparatus according to another embodiment of the present disclosure is schematically shown.

[0113] As Figure 13 shown, the payroll template processing apparatus 1100 may include, for example, a third setting module 1190.

[0114] The third setting module 1190 is configured to set optional configuration fields in the payroll template, where the optional configuration fields are used to control whether to display items with an amount of zero or empty items.

[0115] According to the payroll template processing method provided by the embodiments of the present disclosure, since optional configuration fields are added to the payroll template, it is possible to flexibly select "whether to display salary items with an amount of 0 or empty", further improving the flexibility of the payroll template.

[0116] Any one or more of the modules, sub-modules, units, and sub-units according to the embodiments of the present disclosure, or at least part of the functions of any one or more of them, may be implemented in one module. Any one or more of the modules, sub-modules, units, and sub-units according to the embodiments of the present disclosure may be split into multiple modules for implementation. Any one or more of the modules, sub-modules, units, and sub-units according to the embodiments of the present disclosure may be at least partially implemented as a hardware circuit, such as a field programmable gate array (FPGA), a programmable logic array (PLA), a system on chip, a system on a substrate, a system on a package, an application specific integrated circuit (ASIC), or may be implemented by any other reasonable way of integrating or packaging circuits in hardware or firmware, or implemented in any one of the three implementation manners of software, hardware, and firmware, or in an appropriate combination of any several of them. Alternatively, one or more of the modules, sub-modules, units, and sub-units according to the embodiments of the present disclosure may be at least partially implemented as a computer program module, and when the computer program module is run, the corresponding functions may be executed.

[0117] For example, any combination of the partitioning module 1110, the marking module 1120, the modifying module 1130, the reading module 1140, the first setting module 1150, the first constructing module 1160, the second setting module 1170, the calling module 1180, and the third setting module 1190 can be combined and implemented in one module / unit / sub-unit, or any one of the modules / units / sub-units can be split into multiple modules / units / sub-units. Alternatively, at least part of the functions of one or more of these modules / units / sub-units can be combined with at least part of the functions of other modules / units / sub-units and implemented in one module / unit / sub-unit. According to an embodiment of the present disclosure, at least one of the partitioning module 1110, the marking module 1120, the modifying module 1130, the reading module 1140, the first setting module 1150, the first constructing module 1160, the second setting module 1170, the calling module 1180, and the third setting module 1190 can be at least partially implemented as a hardware circuit, such as a field programmable gate array (FPGA), a programmable logic array (PLA), a system on chip, a system on substrate, a system on package, an application specific integrated circuit (ASIC), or can be implemented by any other reasonable means of integrating or packaging circuits, etc., in hardware or firmware, or can be implemented in any one of the three implementation manners of software, hardware, and firmware, or in an appropriate combination of any several of them. Alternatively, at least one of the partitioning module 1110, the marking module 1120, the modifying module 1130, the reading module 1140, the first setting module 1150, the first constructing module 1160, the second setting module 1170, the calling module 1180, and the third setting module 1190 can be at least partially implemented as a computer program module, and when the computer program module is run, it can execute the corresponding functions.

[0118] It should be noted that the processing device part of the payslip template in the embodiments of the present disclosure corresponds to the processing method part of the payslip template in the embodiments of the present disclosure, and their specific implementation details are also the same, which will not be elaborated here.

[0119] Figure 14 A block diagram of an electronic device suitable for implementing the method described above according to an embodiment of the present disclosure is schematically shown. Figure 14 The electronic device shown is only an example and should not impose any limitation on the functions and usage scope of the embodiments of the present disclosure.

[0120] As Figure 14As shown, the electronic device 1400 according to an embodiment of the present disclosure includes a processor 1401, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 1402 or a program loaded from a storage section 1408 into a random access memory (RAM) 1403. The processor 1401 can include, for example, a general-purpose microprocessor (such as a CPU), an instruction set processor, and / or a related chipset, and / or a dedicated microprocessor (such as an application-specific integrated circuit (ASIC)), and so on. The processor 1401 can also include on-board memory for caching purposes. The processor 1401 can include a single processing unit or multiple processing units for performing different actions of the method flow according to an embodiment of the present disclosure.

[0121] In the RAM 1403, various programs and data required for the operation of the electronic device 1400 are stored. The processor 1401, the ROM 1402, and the RAM 1403 are connected to each other via a bus 1404. The processor 1401 performs various operations of the method flow according to an embodiment of the present disclosure by executing the program in the ROM 1402 and / or the RAM 1403. It should be noted that the program can also be stored in one or more memories other than the ROM 1402 and the RAM 1403. The processor 1401 can also perform various operations of the method flow according to an embodiment of the present disclosure by executing the program stored in the one or more memories.

[0122] According to an embodiment of the present disclosure, the electronic device 1400 can also include an input / output (I / O) interface 1405, and the input / output (I / O) interface 1405 is also connected to the bus 1404. The electronic device 1400 can also include one or more of the following components connected to the I / O interface 1405: an input section 1406 including a keyboard, a mouse, etc.; an output section 1407 including a cathode ray tube (CRT), a liquid crystal display (LCD), etc., and a speaker, etc.; a storage section 1408 including a hard disk, etc.; and a communication section 1409 including a network interface card such as a LAN card, a modem, etc. The communication section 1409 performs communication processing via a network such as the Internet. A drive 1410 is also connected to the I / O interface 1405 as needed. A removable medium 1411, such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, etc., is installed on the drive 1410 as needed so that a computer program read from it can be installed into the storage section 1408 as needed.

[0123] According to an embodiment of the present disclosure, the method flow according to the embodiments of the present disclosure can be implemented as a computer software program. For example, an embodiment of the present disclosure includes a computer program product, which includes a computer program carried on a computer-readable storage medium, and the computer program includes program code for executing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from a network through the communication part 1409, and / or installed from the removable medium 1411. When the computer program is executed by the processor 1401, the above functions defined in the system of the embodiments of the present disclosure are executed. According to an embodiment of the present disclosure, the above-described systems, devices, apparatuses, modules, units, etc. can be implemented by computer program modules.

[0124] The present disclosure also provides a computer-readable storage medium, which may be included in the device / device / system described in the above embodiments; or may exist alone without being assembled into the device / device / system. The above computer-readable storage medium carries one or more programs, and when the above one or more programs are executed, the method according to the embodiments of the present disclosure is implemented.

[0125] According to an embodiment of the present disclosure, the computer-readable storage medium may be a non-volatile computer-readable storage medium. For example, it may include but is not limited to: portable computer disks, hard disks, random access memories (RAMs), read-only memories (ROMs), erasable programmable read-only memories (EPROMs or flash memories), portable compact disk read-only memories (CD-ROMs), optical storage devices, magnetic storage devices, or any suitable combination of the above. In the present disclosure, the computer-readable storage medium may be any tangible medium that contains or stores a program, and the program can be used by or in combination with an instruction execution system, device, or device.

[0126] For example, according to an embodiment of the present disclosure, the computer-readable storage medium may include one or more memories other than the above-described ROM 1402 and / or RAM 1403 and / or ROM 1402 and RAM 1403.

[0127] The flowcharts and block diagrams in the accompanying drawings illustrate the architecture, functionality, and operation of possible implementations of systems, methods, and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagram may represent a module, a segment of a program, or a portion of code, which contains one or more executable instructions for implementing a specified logical function. It should also be noted that in some alternative implementations, the functions noted in the blocks may occur in a different order than noted in the accompanying drawings. For example, two consecutive blocks shown may actually be executed substantially in parallel, or they may sometimes be executed in the reverse order, depending on the functions involved. It should also be noted that each block in the block diagram or flowchart, and combinations of blocks in the block diagram or flowchart, can be implemented by a dedicated hardware-based system that performs the specified functions or operations, or by a combination of dedicated hardware and computer instructions. Those skilled in the art will appreciate that the features recited in the various embodiments and / or claims of the present disclosure may be combined and / or combined in various ways, even if such combinations or combinations are not explicitly recited in the present disclosure. In particular, without departing from the spirit and teachings of the present disclosure, the features recited in the various embodiments and / or claims of the present disclosure may be combined and / or combined in various ways. All such combinations and / or combinations fall within the scope of the present disclosure.

Claims

1. A method for processing a payslip template, comprising: Dividing the payslip template into at least one payslip level according to the attribute information of the payslip content to be filled, wherein each payslip level includes at least one detail item; Marking each detail item to generate the corresponding relationship and positional relationship between the detail items; wherein, the corresponding relationship is the relationship between the first-level item and the n-level item corresponding to the first-level item in the detail item, and the positional relationship is the position of each detail item in the payslip template, wherein n is an integer greater than 2; Adding or deleting the detail items according to the corresponding relationship and positional relationship; and According to the corresponding relationship and positional relationship, reading the first-level items of the payslip template one by one, using the same first-level item as the key, and reading all the n-level items under the same first-level item as the value to integrate the same first-level items.

2. The method for processing a payslip template according to claim 1, wherein the processing method further comprises: Setting batch numbers for different forms of payslip templates of the same enterprise; Constructing a hierarchical relationship table to store the corresponding relationship and positional relationship; Setting the primary key of the hierarchical relationship table according to the enterprise number and the batch number, wherein the primary key is used to represent different forms of payslip templates of the same enterprise; Invoking the hierarchical relationship table to add, delete or read the detail items.

3. The method for processing a payslip template according to claim 1, wherein the processing method further comprises: Setting optional configuration fields in the payslip template, wherein the optional configuration fields are used to control whether to display items with an amount of zero or empty items.

4. The processing method of the payslip template according to any one of claims 1-3, wherein, The marking of each detail item includes: Marking each detail item through the self-incrementing sequence of the oracle table.

5. The method for processing a payslip template according to any one of claims 1-3, wherein the step of reading the first-level items of the payslip template one by one according to the corresponding relationship and positional relationship includes: Reading the first-level items of the payslip template one by one in the data structure of HashMap.

6. The method for processing a payslip template according to any one of claims 1-3, wherein the processing method further comprises: Constructing an employee information table to store the basic information of the employees included in the payslip template, wherein the employee information table uses the employee number, the type of identity document and the document number as the primary key.

7. The method for processing a payslip template according to claim 6, wherein the processing method further comprises: Uploading the employee number, the type of identity document and the document number through the client; Verifying whether there is matching employee information in the employee information table through the online banking interface. If so, sending a random verification code to the matching employee for verification; After the verification is passed, querying the payslip information of the employee in the payslip template through the online banking interface, and displaying the payslip information in the form of a list on the client; When the user clicks on a certain payslip information in the list, performing secondary identity verification, and after the verification is passed, displaying the detailed information.

8. A processing device for a payslip template, comprising: A division module, configured to divide a payslip template into at least one payslip level according to the attribute information of the salary content to be filled, wherein each payslip level includes at least one detail item; A marking module, configured to mark each detail item to generate the corresponding relationship and positional relationship between the detail items; wherein, the corresponding relationship is the relationship between the first-level item in the detail item and the n-level item corresponding to the first-level item, and the positional relationship is the position of each detail item in the payslip template, where n is an integer greater than 2; A modification module, configured to add or delete the detail items according to the corresponding relationship and the positional relationship; and A reading module, configured to sequentially read the first-level items of the payslip template according to the corresponding relationship and the positional relationship, use the same first-level item as the key, and read all the n-level items under the same first-level item as the value, so as to integrate the same first-level items.

9. The processing device for a payslip template according to claim 8, wherein the processing device further comprises: A first setting module, configured to set a batch number for different forms of payslip templates of the same enterprise; A first construction module, configured to construct a hierarchical relationship table to store the corresponding relationship and the positional relationship; A second setting module, configured to set a primary key of the hierarchical relationship table according to the number of the enterprise and the batch number, wherein the primary key is used to represent different forms of payslip templates of the same enterprise; An invocation module, configured to invoke the hierarchical relationship table to add, delete or read the detail items.

10. The processing device for a payslip template according to claim 8, wherein the processing device further comprises: A third setting module, configured to set an optional configuration field in the payslip template, wherein the optional configuration field is used to control whether to display an item with an amount of zero or an empty item.

11. An electronic device, comprising: One or more processors; A memory, configured to store one or more programs, wherein, when the one or more programs are executed by the one or more processors, the one or more processors are caused to implement the method according to any one of claims 1 to 7.

12. A computer-readable storage medium, on which executable instructions are stored, and when the instructions are executed by a processor, the processor is caused to implement the method according to any one of claims 1 to 7.

13. A computer program product, comprising a computer program, and when the computer program is executed by a processor, the method according to any one of claims 1 to 7 is implemented.

Images