Data accounting method, device, electronic equipment and storage medium
By responding to the data accounting instructions on the front-end page, the data processing template and pending data are determined, and the data is processed based on the target calculation template engine, the problems of low efficiency and high error rate in the existing technology are solved, and automated efficient data accounting and reduced work costs are realized.
Patent Information
- Application Number
- CN202111165342.5
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2021-09-30
- Publication Date
- 2025-03-14
- Estimated Expiration
- 2041-09-30
AI Technical Summary
In the prior art, the accounting efficiency of business bill data is low and the error rate is high. The use of Excel for accounting requires staff to always pay attention to the rationality of the calculation formula, which increases work costs and cannot be automatically compared with the original data.
By responding to the data accounting instructions sent by the front-end page, the data processing template and the data to be processed corresponding to the service processing system to be accounted for is determined, the target calculation template engine is determined based on the data processing template, the data to be processed, the target calculation data is obtained, and the calculation result is determined based on the target calculation data and the data to be accounted for.
It realizes automated data accounting while taking into account both accounting efficiency and accuracy, which reduces work costs. By introducing a computing template engine, it can intuitively call the calculation formulas and data corresponding to the current accounting scenario, reducing staff attention and error rates.
Smart Images

Figure CN113901773B_ABST
Abstract
Description
Technical Field
[0001] Embodiments of the present invention relate to the field of data processing technology, and in particular, to a data accounting method, device, electronic device and storage medium. Background Art
[0002] With the development of Internet finance, the logical complexity of various businesses has continued to deepen, and the amount of data involved has also increased. Therefore, a lot of billing data generated during the operation of the business needs to be accounted for.
[0003] In the prior art, there are usually two ways to calculate business bill data. The first way is that the staff calculates the bill data manually. However, the manual calculation method is not only inefficient, but also has a high error rate when the calculation details of the business are complex and numerous. The second way is to use Excel to calculate the bill data, that is, to obtain the user's calculation results by filling in the calculation formula and calculated values in the table. The disadvantage of this method is that the staff needs to spend more energy to pay attention to whether the calculation formula in the table is suitable for the current scenario, which invisibly increases the work cost of the staff.
[0004] Therefore, in the solutions provided by relevant technologies, manual calculation methods are inefficient and have a certain calculation error rate. Calculation using tables requires staff to always pay attention to the calculation scenario, and the calculation process is not intuitive enough. At the same time, both methods cannot automatically compare with the original calculation data. Summary of the invention
[0005] The present invention provides a data accounting method, device, electronic device and storage medium, which realize data accounting in an automated manner while taking into account accounting efficiency and accuracy, thereby reducing work costs.
[0006] In a first aspect, an embodiment of the present invention provides a data accounting method, the method comprising:
[0007] In response to the data accounting instruction sent by the front-end page, determine the data processing template corresponding to the business processing system to be accounted for and the data to be processed; wherein the data accounting instruction corresponds to the business processing system to be accounted for;
[0008] Determining a target calculation template engine based on the data processing template, and processing the data to be processed based on the target calculation template engine to obtain target calculation data;
[0009] The calculation result is determined according to the target calculation data and the data to be calculated; wherein the data to be calculated is calculated by the business processing system to be calculated.
[0010] In a second aspect, an embodiment of the present invention further provides a data accounting device, the device comprising:
[0011] A data accounting instruction response module, used to respond to the data accounting instruction sent by the front-end page, determine the data processing template corresponding to the business processing system to be accounted for and the data to be processed; wherein the data accounting instruction corresponds to the business processing system to be accounted for;
[0012] A target calculation data determination module, used to determine a target calculation template engine based on the data processing template, and process the data to be processed based on the target calculation template engine to obtain target calculation data;
[0013] The calculation result determination module is used to determine the calculation result according to the target calculation data and the data to be calculated; wherein the data to be calculated is calculated by the business processing system to be calculated.
[0014] In a third aspect, an embodiment of the present invention further provides an electronic device, the electronic device comprising:
[0015] one or more processors;
[0016] a storage device for storing one or more programs,
[0017] When the one or more programs are executed by the one or more processors, the one or more processors implement the data accounting method as described in any one of the embodiments of the present invention.
[0018] In a fourth aspect, an embodiment of the present invention further provides a storage medium comprising computer executable instructions, wherein the computer executable instructions, when executed by a computer processor, are used to execute a data accounting method as described in any one of the embodiments of the present invention.
[0019] The technical solution of the embodiment of the present invention responds to the data accounting instruction sent by the front-end page, determines the data processing template corresponding to the business processing system to be accounted and the data to be processed, that is, determines the calculation formula and data channel of the specific business; determines the target calculation template engine based on the data processing template, and processes the data to be processed based on the target calculation template engine to obtain the target calculation data, and further determines the accounting result according to the target calculation data and the data to be accounted. While taking into account the accounting efficiency and accuracy, data accounting is realized in an automated manner. At the same time, the calculation template engine is introduced into the accounting process to call the calculation formula and the data to be processed corresponding to the current accounting scenario in an intuitive manner. The staff no longer needs to pay attention to the correlation between the scenarios, formulas, and data at all times, thereby reducing the work cost. BRIEF DESCRIPTION OF THE DRAWINGS
[0020] In order to more clearly illustrate the technical solutions of the exemplary embodiments of the present invention, the following briefly introduces the drawings required to describe the embodiments. Obviously, the drawings introduced are only drawings of a part of the embodiments to be described in the present invention, rather than all the drawings. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work.
[0021] Figure 1 A schematic diagram of a flow chart of a data calculation method provided in the first embodiment of the present invention;
[0022] Figure 2 A schematic diagram of a flow chart of a data calculation method provided in the second embodiment of the present invention;
[0023] Figure 3 A flowchart of a data calculation method provided in Embodiment 3 of the present invention;
[0024] Figure 4 This is a structural block diagram of a data accounting device provided by Embodiment 4 of the present invention;
[0025] Figure 5 This is a schematic diagram of the structure of an electronic device provided in Embodiment 5 of the present invention. DETAILED DESCRIPTION
[0026] The present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It is to be understood that the specific embodiments described herein are only used to explain the present invention, rather than to limit the present invention. It should also be noted that, for ease of description, only parts related to the present invention, rather than all structures, are shown in the accompanying drawings.
[0027] Embodiment 1
[0028] Figure 1 This is a flow chart of a data accounting method provided in Example 1 of the present invention. This embodiment is applicable to the situation where existing billing data is calculated using a calculation template engine. The method can be executed by a data accounting device, which can be implemented in the form of software and / or hardware. The hardware can be an electronic device, such as a mobile terminal, PC or server.
[0029] like Figure 1 As shown, the method specifically comprises the following steps:
[0030] S110. In response to the data accounting instruction sent by the front-end page, determine the data processing template corresponding to the business processing system to be accounted for and the data to be processed.
[0031] With the development of Internet business, many billing data generated by various businesses during the operation process need to be calculated. For example, for Internet financial business, staff often need to calculate the billing data related to the business, so as to realize the monitoring of the business. On this basis, the data accounting instruction can be a request sent by the staff to the system through a specific control on the front-end page, at least for triggering the accounting work of the billing data corresponding to each business system. For example, a corresponding "data accounting" control can be developed for each business in the system, and the staff can start the corresponding accounting work by clicking the control. It should be noted that in the scheme of this embodiment, the accounting work of each business can also be triggered by a timed polling method, for example, a data accounting instruction is automatically generated at the front end based on a preset time interval, and the instruction is sent to the system to start the corresponding accounting work. It should be understood by those skilled in the art that the specific way of triggering the accounting work can be selected according to the actual situation, and the embodiment of the present disclosure is not specifically limited here.
[0032] In this embodiment, the system used to process the data involved in the business operation process and obtain the original data to be calculated is the business processing system. Specifically, the business processing system needs to call the calculation formula related to its own business, and based on these formulas, it processes various constants and variables related to its own business before obtaining the original data to be calculated. Based on this, it can be seen that the data processing template can be one or more calculation formulas called by the business processing system. It can be understood that these calculation formulas can at least reflect the settlement rules of the business. Correspondingly, the various constants and variables processed by the settlement rules are the data to be processed. Exemplarily, for the business processing system that processes loan business, the annualized interest rate as a constant and the loan date, loan period, loan amount, etc. as variables together constitute the data to be processed, and the relevant calculation formulas involved in calculating interest and other parameters are the data processing template.
[0033] It should be noted that the system can be associated with multiple types of businesses, and according to the requirements of the accounting tasks, it may be necessary to only calculate the data of some of the businesses. Therefore, based on the data accounting instructions, at least the businesses that need to calculate the original data can be determined. It can be understood that the data accounting instructions correspond to the business processing system to be accounted for. When the data accounting instructions are received, the data processing template used to process the business and the data to be processed as the basis for calculating the data to be accounted can be obtained at the same time through the determined business processing system to be accounted for.
[0034] S120: Determine a target computing template engine based on the data processing template, and process the data to be processed based on the target computing template engine to obtain target computing data.
[0035] Among them, the template engine can be a program code written in a specific programming language. During the operation of the template engine, it can at least integrate specific templates and data, reconstruct the statements in the template in the engine, and then perform related data processing operations. As a cross-platform concept, the template engine not only has multiple implementation methods, but also includes multiple types. For example, in Node.js, common template engines include ejs, handlerbars, jad, etc. Based on this engine, specific tags in the template content can be replaced to generate corresponding business data. Therefore, this engine is also called a replacement template engine. Those skilled in the art should understand that in addition to the above-mentioned types of template engines, there are also interpreted template engines and compiled template engines, which will not be elaborated in the embodiments of the present disclosure.
[0036] In this embodiment, the template engine used to perform data accounting for the business to be accounted is the target calculation template engine. It can be understood that in order to ensure consistency in the business data accounting process, the settlement rules used in the target template engine are the same as the settlement rules used by the business processing system to be accounted, that is, when the business processing system to be accounted and the data processing template (one or more calculation formulas) corresponding to the system are determined in response to the data accounting instruction, the corresponding target calculation template engine can be determined based on the data processing template. In the actual application process, there are at least two ways to determine the target calculation template. The first way is to generate the corresponding target calculation template engine in real time based on the data processing template. The second way is to generate the target calculation template engine for each data processing template in advance, and store a mapping table representing the corresponding relationship between the target calculation template engine and the specific data processing template. When the corresponding data accounting instruction is issued and the business processing system to be accounted and its data processing template are determined, the target calculation template engine corresponding to the data processing template can be determined by looking up the table.
[0037] Further, after determining the target calculation template engine corresponding to the data processing template, the program in the template engine can be executed to process the data to be processed, thereby obtaining a new processing result. It can be understood that the processing result output by the target calculation template engine is the target calculation data. Exemplarily, when the relevant business processing system for processing loan business is determined as the business processing system to be accounted for, and the corresponding loan settlement rules are obtained, based on the settlement rules, a target calculation template engine containing one or more calculation formulas in the settlement rules can be obtained. After the constants and variables involved in the loan business are processed using the target calculation template engine, the target calculation data for comparison with the data to be accounted for can be obtained.
[0038] It should be noted that the settlement rules in the target calculation template engine only correspond to specific businesses to be accounted for. Therefore, when accounting for the data to be accounted for of different businesses, the target calculation template engines executed are also different. Specifically, different target calculation template engines contain different calculation formulas and process different data to be processed.
[0039] S130. Determine a calculation result according to the target calculation data and the data to be calculated.
[0040] In this embodiment, after the target calculation data is determined based on the target calculation template engine, the target calculation data needs to be compared with the data to be calculated in order to realize data accounting. It can be understood that the data to be calculated is the data to be compared obtained after the data to be processed is processed by the business processing system to be calculated. There are many ways to compare the target calculation data with the data to be calculated. In the actual application process, the above two types of data can be imported into a specific comparison table at the same time, and the staff can determine the accounting result through the table.
[0041] For example, after determining the target calculation data and the data to be calculated related to a certain loan business, the two types of data can be imported into a comparison table. Based on the total amount payable as the target calculation data output to the table and the total settlement amount as the data to be calculated, it can be determined whether the user who used the loan business has repaid the corresponding amount as agreed.
[0042] For other business processing systems to be accounted for, based on the technical solution provided in this embodiment, the corresponding target calculation template engine can also be determined, and the final accounting result can be determined based on the target calculation data and the data to be accounted for. That is to say, although there are differences in the target calculation template engines, settlement rules and data channels corresponding to different businesses, based on the solution of this embodiment, when a data accounting instruction is received, the corresponding data accounting operation can be executed.
[0043] The technical solution of this embodiment responds to the data accounting instruction sent by the front-end page, determines the data processing template corresponding to the business processing system to be accounted and the data to be processed, that is, determines the calculation formula and data channel of the specific business; determines the target calculation template engine based on the data processing template, and processes the data to be processed based on the target calculation template engine to obtain the target calculation data; further, determines the accounting result according to the target calculation data and the data to be accounted, and realizes data accounting in an automated manner while taking into account the accounting efficiency and accuracy. At the same time, the calculation template engine is introduced into the accounting process to call the calculation formula and the data to be processed corresponding to the current accounting scenario in an intuitive manner. The staff no longer needs to pay attention to the correlation between the scenarios, formulas, and data at all times, thereby reducing the work cost.
[0044] Embodiment 2
[0045] Figure 2 A flow chart of a data accounting method provided in the second embodiment of the present invention. On the basis of the above-mentioned embodiment, the calculation template engine is processed according to the accounting function in the data processing template to obtain the target calculation template engine. Furthermore, the generated target calculation template engine is cached to realize the reuse of existing functions and save CPU computing resources. When the business modifies the settlement rules, the corresponding target calculation template engine is automatically updated according to the modified accounting function, which enhances the adaptability of the calculation template engine to different data processing templates and provides an effective way to solve the data accounting problems involving diversified settlement rule scenarios. The accounting table is loaded and displayed on the target page to realize the visualization of the data accounting results. The specific implementation method can refer to the technical solution of this embodiment. Among them, the technical terms that are the same as or corresponding to the above-mentioned embodiments are not repeated here.
[0046] like Figure 2 As shown, the method specifically comprises the following steps:
[0047] S210, obtaining a data processing template and a table to be filled corresponding to at least one business processing system; importing business data in at least one business processing system into the corresponding table to be filled, and obtaining data to be processed corresponding to each business to be accounted for.
[0048] In this embodiment, in order to respond to the data accounting instruction sent by the front-end page, a data processing template and a table to be filled corresponding to at least one business processing system may be acquired in advance.
[0049] Among them, the business processing system corresponds to the business to be accounted for, and the table to be filled is bound to the data processing template and is used to fill in the table of business data. It can be understood that the parameters of each row and column of the table to be filled are the parameters in at least one calculation formula in the data processing template, and the business data imported into the table to be filled is the data to be processed for determining the data to be accounted for. It should be noted that in the actual application process, the data processing template and the table to be filled can be bound based on a specific identifier, that is, the same identifier is marked on the data processing template and the table to be filled, so as to realize the binding of the calculation formula and the data channel.
[0050] Exemplarily, for the business processing system corresponding to the loan business, multiple calculation formulas in the loan settlement rules and the table to be filled can be obtained in advance, and the loan data of at least one user can be filled in the table to be filled, such as the specific loan amount, number of loan terms, annualized interest rate and billing date, etc. Correspondingly, the calculation formula of the loan settlement rules includes the row and column parameters corresponding to the loan data in the table (such as A1, B2). For example, the calculation formula corresponding to the principal is ROUND(A1-B2).
[0051] S220. In response to the data accounting instruction sent by the front-end page, extract the business identifier to be accounted carried by the data accounting instruction; determine the business processing system to be accounted in at least one business processing system according to the business identifier to be accounted, and determine the data processing template and the data to be processed corresponding to the business processing system to be accounted.
[0052] In this embodiment, the identification of the business to be accounted for can be carried in the data accounting instruction in various forms, at least to reflect the business that needs to account for billing data, for example, it can be a specific string such as "mortgage business" or "car loan business". After parsing the data accounting instruction and extracting the accounting business identification therein, the system can determine the business processing system to be accounted for corresponding to the identification in at least one business processing system. At the same time, since different businesses are associated with corresponding settlement rules and data channels, based on the determined business system to be processed, the data processing template and the data to be processed corresponding to the system can be determined at the same time.
[0053] S230: Determine a target computing template engine based on the data processing template, and process the data to be processed based on the target computing template engine to obtain target computing data.
[0054] In this embodiment, there are multiple ways to determine the target calculation template engine based on the data processing template, which are described in detail below.
[0055] Optionally, parse and extract the calculation function in the data processing template; determine the target variable in the pre-built calculation template engine according to the calculation function, and replace the data value of the target variable according to the field corresponding to the calculation function to obtain the target calculation template engine.
[0056] In this embodiment, different data processing templates reflect the settlement rules of different businesses, and various calculation formulas in the settlement rules are embodied in the accounting functions in the data processing template. Based on this, after determining the data processing template, one or more accounting functions in the template can be parsed and extracted. Further, based on the parsed and extracted accounting functions, multiple target variables can be determined in the pre-built calculation template engine. Specifically, the target variable corresponds to a specific accounting function and a constant or variable in the accounting function. The process of replacing the default data value (such as a string) of the target variable based on the accounting function can be understood as a process of compiling the preset syntax in the calculation template engine, and then reconstructing each accounting function in the data processing template in the engine. In this embodiment, the new calculation template engine obtained by replacing the data value in the target variable according to the accounting function is the target calculation template engine. It should be noted that when compiling the preset syntax in the calculation template engine, if the Function function is used to reconstruct the accounting function, the relevant parameters involved in the process need to be set to a string type.
[0057] It should also be noted that after the pre-built calculation template engine is processed according to the accounting function and the corresponding target calculation template engine is obtained, the target calculation template engine can also be stored in a specific repository. At the same time, a mapping table representing the correspondence between the data processing template and the target calculation template engine is established. When a data accounting request is received again and the corresponding data processing template is determined, the corresponding target calculation template engine can be determined by looking up the table. The generated target calculation template engine is cached to achieve the reuse of existing functions, avoid the process of compiling the preset syntax in the calculation template engine multiple times, and save CPU computing resources.
[0058] Optionally, the calculation function in the data processing template is parsed and extracted, the target variable in each cached calculation template engine is verified based on the calculation function, and the calculation template engine corresponding to the successfully verified target variable is used as the target calculation template engine.
[0059] In this embodiment, after parsing and extracting the calculation function in the data processing template, the target variables in each cached calculation template engine can also be verified based on the calculation function. Specifically, the calculation function can be matched with the target variables in each calculation template engine one by one. When the match is successful, it means that the target calculation template engine corresponding to the data processing template already exists in the cache space. At this time, the successfully matched calculation target engine can be directly used as the target calculation template engine without calling the pre-built calculation template engine and wasting computing resources to reconstruct the calculation function in the data processing template.
[0060] It should be noted that after determining the target calculation template engine, it also includes:
[0061] When a change in the calculation function is detected, the target calculation template engine is recompiled according to the new calculation function, so as to perform parsing and calculation on the data to be processed based on the recompiled target calculation template engine.
[0062] In this embodiment, the business in the operation process may modify the settlement rules according to the needs. Specifically, it can be manually or automatically modifying the accounting function in the corresponding data processing template. Therefore, when the system detects that the accounting function in the data processing template has changed, it is necessary to recompile the existing target calculation template engine according to the new accounting function in accordance with the technical solution provided in this embodiment, that is, modify the syntax in the existing target calculation template engine, reconstruct the updated accounting function, and obtain a new target calculation template engine. It can be understood that when the data accounting instruction is received in the subsequent process, the system will parse and calculate the corresponding data to be processed based on the new target calculation template engine.
[0063] When the business modifies the settlement rules, the corresponding target calculation template engine is automatically updated according to the modified accounting function. Staff no longer need to manually modify related functions, which enhances the adaptability of the calculation template engine to different data processing templates and provides an effective way to solve data accounting problems involving diversified settlement rule scenarios.
[0064] In this embodiment, after the target calculation template engine is determined, the engine can be used to process the corresponding data to be processed, thereby obtaining the target calculation data.
[0065] S240: Compare the target calculation data with the data to be calculated, and determine the calculation result based on pre-set judgment rules and keywords.
[0066] In this embodiment, the judgment rules and corresponding keywords of the target calculation data and the data to be calculated can be preset. Exemplarily, for the loan business, the data to be calculated can be the principal to be repaid, the interest to be repaid, the total amount to be repaid, and the principal not repaid. Correspondingly, the target calculation data can be the settled principal, the settled interest, the settled total amount, and the settled principal not repaid. At the same time, the comparison of the specific size of the data value is used as a preset judgment rule. When the data value of the data to be calculated is equal to the data value of the corresponding target calculation data, the corresponding keyword "data calculation is correct" can be determined according to the judgment rule; when the data value of the data to be calculated is not equal to the data value of the corresponding target calculation data, the corresponding keyword "data is not uniform" can be determined according to the judgment rule. It should be noted that when the target calculation data is not uniform with the data to be calculated, the calculation result can also display the specific parameters of the difference, such as "unpaid principal is not uniform", "total amount to be repaid is not uniform", etc. Those skilled in the art should understand that the specific judgment rules and keywords can be set according to business needs, and the embodiments of the present disclosure are not specifically limited here.
[0067] By presetting the judgment rules and keywords between the target calculation data and the data to be calculated, the calculation results can be determined in a simple and intuitive way, which improves the usability of the data calculation solution and further reduces the related workload of data calculation.
[0068] S250, importing the target calculation data, the data to be calculated, and the calculation results into a calculation table corresponding to the business to be calculated, so as to load and display the calculation table on the target page.
[0069] In this embodiment, in order to realize the visualization of data accounting results, after the accounting results are determined based on the target calculation data and the data to be accounted for, the above information can also be imported into the accounting table corresponding to the current business to be accounted for. Furthermore, the accounting table is loaded and displayed in a specific area of the target page to facilitate the staff to view and thereby determine the items with data problems in the business to be accounted for.
[0070] Furthermore, the accounting table with imported data can also use the plug-in to generate a file in a specific format and store the file in the target server. At the same time, a call link is generated according to the corresponding program code and the file storage address. For example, a link in the form of a Uniform Resource Locator (URL) is generated. After the call link is returned to the corresponding port of the staff, the staff can download the accounting table.
[0071] The technical solution of this embodiment processes the calculation template engine according to the accounting function in the data processing template to obtain the target calculation template engine. Furthermore, the generated target calculation template engine is cached to realize the reuse of existing functions and save CPU computing resources. When the business modifies the settlement rules, the corresponding target calculation template engine is automatically updated according to the modified accounting function, which enhances the adaptability of the calculation template engine to different data processing templates and provides an effective way to solve data accounting problems involving diversified settlement rule scenarios. The accounting table is loaded and displayed on the target page to realize the visualization of data accounting results.
[0072] Embodiment 3
[0073] As an alternative embodiment of the above embodiment, Figure 3 This is a flow chart of a data accounting method provided in Embodiment 3 of the present invention. In order to clearly introduce the technical solution of this embodiment, the application scenario can be introduced as an example of a situation where a calculation template engine is pre-built to perform data accounting tasks for a specific business, but it is not limited to the above scenario and can be applied to various scenarios that require data accounting.
[0074] See also Figure 3 When a pre-developed calculation template engine is introduced to calculate business data, the calculation template engine at least has the characteristic of being highly customizable. It can be understood that the calculation template engine can at least determine the relevant settlement rules and data channels according to the settlement scenario of a specific business during the data calculation process. The following divides the specific data calculation process into three stages: filling, calculation, and verification, and explains each stage.
[0075] Continue to see Figure 3 When the system responds to a data accounting instruction, it first needs to obtain the executor corresponding to the specific business. Specifically, the system can parse and extract the business identifier carried by the data accounting instruction, and then determine the business processing system that handles the specific business based on the business identifier. It can be understood that the business processing system determined as the executor is the business processing system to be accounted for. Since each business processing system is associated with a specific calculation template (data processing template) and filled data (data to be processed), after determining the business processing system to be accounted for, it is also necessary to obtain one or more calculation templates associated with the system and the filled data. Furthermore, after filling the acquired data into the table corresponding to the calculation template, the filling stage in the data accounting task is completed.
[0076] Continue to see Figure 3In the calculation stage, you first need to obtain the pre-built calculation template engine, then parse and extract the calculation formula in the determined calculation template, and load the extracted calculation formula into the calculation template engine. It can be understood that for the calculation template engine, the calculation formulas corresponding to the settlement rules of the business to be accounted for obtained by these parsing and extraction are custom functions. Furthermore, the calculation template engine compiles its own syntax related to the custom function through a preprocessing process, thereby realizing the reconstruction of the calculation formula in the engine. After the preprocessing is completed, the data corresponding to the specific business that has been filled in the specific table can be called to perform data accounting operations.
[0077] Continue to see Figure 3 When the calculation template engine outputs the target calculation data, these data can be imported into the accounting table corresponding to the business to be calculated, so as to realize the collection of the engine calculation results. Furthermore, the existing data to be calculated (system results) of the business processing system to be calculated are obtained, the data to be calculated is imported into the accounting table corresponding to the accounting business, and the target calculation data is compared with the data to be calculated to complete the data accounting task.
[0078] The beneficial effects of the above technical solution are: while taking into account accounting efficiency and accuracy, data accounting is realized in an automated manner. At the same time, a calculation template engine is introduced in the accounting process to call the calculation formulas and data to be processed corresponding to the current accounting scenario in an intuitive manner. Staff no longer need to pay attention to the correlation between scenarios, formulas, and data at all times, thereby reducing work costs.
[0079] Embodiment 4
[0080] Figure 4 This is a structural block diagram of a data accounting device provided in the fourth embodiment of the present invention, which can execute the data accounting method provided in any embodiment of the present invention and has the corresponding functional modules and beneficial effects of the execution method. Figure 4 As shown, the device specifically includes: a data calculation instruction response module 310, a target calculation data determination module 320 and a calculation result determination module 330.
[0081] The data accounting instruction response module 310 is used to respond to the data accounting instruction sent by the front-end page and determine the data processing template and the data to be processed corresponding to the business processing system to be accounted for; wherein the data accounting instruction corresponds to the business processing system to be accounted for.
[0082] The target calculation data determination module 320 is used to determine a target calculation template engine based on the data processing template, and process the data to be processed based on the target calculation template engine to obtain target calculation data.
[0083] The calculation result determination module 330 is used to determine the calculation result according to the target calculation data and the data to be calculated; wherein the data to be calculated is calculated by the business processing system to be calculated.
[0084] Based on the above technical solutions, the data accounting device also includes a module for determining data to be processed.
[0085] A module for determining data to be processed is used to obtain a data processing template and a table to be filled corresponding to at least one business processing system; wherein the business processing system corresponds to the business to be accounted for; the business data in at least one business processing system is imported into the corresponding table to be filled to obtain the data to be processed corresponding to each business to be accounted for.
[0086] On the basis of the above-mentioned technical solutions, the data accounting instruction response module 310 includes a to-be-accounted business identifier extraction unit and a to-be-accounted business processing system determination unit.
[0087] The to-be-accounted business identifier extraction unit is used to extract the to-be-accounted business identifier carried in the data accounting instruction in response to the data accounting instruction sent by the front-end page.
[0088] The to-be-accounted business processing system determining unit is used to determine a to-be-accounted business processing system in at least one business processing system according to the to-be-accounted business identifier, and determine a data processing template and to-be-processed data corresponding to the to-be-accounted business processing system.
[0089] Optionally, the target calculation data determination module 320 is also used to parse and extract the accounting function in the data processing template, wherein the accounting function corresponds to the business to be accounted for; determine the target variable in the pre-built calculation template engine according to the accounting function, and replace the data value of the target variable according to the field corresponding to the accounting function to obtain the target calculation template engine.
[0090] Optionally, the target calculation data determination module 320 is also used to parse and extract the calculation function in the data processing template, verify the target variables in each cached calculation template engine based on the calculation function, and use the calculation template engine corresponding to the successfully verified target variable as the target calculation template engine.
[0091] Based on the above technical solutions, the data accounting device also includes a compilation module.
[0092] The compiling module is used to recompile the target calculation template engine according to the new calculation function when it is detected that the calculation function has changed, so as to parse and calculate the data to be processed based on the recompiled target calculation template engine.
[0093] Optionally, the calculation result determination module 330 is further used to compare the target calculation data with the data to be calculated, and determine the calculation result based on pre-set judgment rules and keywords.
[0094] Based on the above technical solutions, the data accounting device also includes a data import module.
[0095] The data import module is used to import the target calculation data, the data to be calculated and the calculation results into the calculation table corresponding to the business to be calculated, so as to load and display the calculation table on the target page.
[0096] The technical solution provided in this embodiment responds to the data accounting instruction sent by the front-end page, determines the data processing template corresponding to the business processing system to be accounted and the data to be processed, that is, determines the calculation formula and data channel of the specific business; determines the target calculation template engine based on the data processing template, and processes the data to be processed based on the target calculation template engine to obtain the target calculation data, and further determines the accounting result according to the target calculation data and the data to be accounted. While taking into account the accounting efficiency and accuracy, data accounting is realized in an automated manner. At the same time, the calculation template engine is introduced into the accounting process to call the calculation formula and the data to be processed corresponding to the current accounting scenario in an intuitive manner. The staff no longer needs to pay attention to the correlation between the scenarios, formulas, and data at all times, thereby reducing the work cost.
[0097] The data accounting device provided in the embodiment of the present invention can execute the data accounting method provided in any embodiment of the present invention, and has the corresponding functional modules and beneficial effects of the execution method.
[0098] It is worth noting that the various units and modules included in the above-mentioned device are only divided according to functional logic, but are not limited to the above-mentioned division, as long as the corresponding functions can be achieved; in addition, the specific names of the functional units are only for the convenience of distinguishing each other, and are not used to limit the protection scope of the embodiments of the present invention.
[0099] Embodiment 5
[0100] Figure 5 This is a schematic diagram of the structure of an electronic device provided in Embodiment 5 of the present invention. Figure 5 A block diagram of an exemplary electronic device 40 suitable for implementing exemplary embodiments of the present invention is shown. Figure 5 The electronic device 40 shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present invention.
[0101] like Figure 5As shown, the electronic device 40 is in the form of a general computing device. The components of the electronic device 40 may include but are not limited to: one or more processors or processing units 401, a system memory 402, and a bus 403 connecting different system components (including the system memory 402 and the processing unit 401).
[0102] Bus 403 represents one or more of several types of bus structures, including a memory bus or memory controller, a peripheral bus, an accelerated graphics port, a processor or a local bus using any of a variety of bus structures. For example, these architectures include but are not limited to Industry Standard Architecture (ISA) bus, Micro Channel Architecture (MAC) bus, Enhanced ISA bus, Video Electronics Standards Association (VESA) local bus and Peripheral Component Interconnect (PCI) bus.
[0103] The electronic device 40 typically includes a variety of computer system readable media. These media can be any available media that can be accessed by the electronic device 40, including volatile and non-volatile media, removable and non-removable media.
[0104] System memory 402 may include computer system readable media in the form of volatile memory, such as random access memory (RAM) 404 and / or cache memory 405. Electronic device 40 may further include other removable / non-removable, volatile / non-volatile computer system storage media. By way of example only, storage system 406 may be used to read and write non-removable, non-volatile magnetic media ( Figure 5 not shown, usually called a "hard drive"). Although Figure 5 Not shown in the figure, a disk drive for reading and writing to a removable non-volatile disk (e.g., a "floppy disk"), and an optical disk drive for reading and writing to a removable non-volatile optical disk (e.g., a CD-ROM, a DVD-ROM, or other optical media) may be provided. In these cases, each drive may be connected to bus 403 via one or more data medium interfaces. Memory 402 may include at least one program product having a set (e.g., at least one) of program modules that are configured to perform the functions of various embodiments of the present invention.
[0105] A program / utility 408 having a set (at least one) of program modules 407 may be stored, for example, in memory 402, such program modules 407 including, but not limited to, an operating system, one or more application programs, other program modules, and program data, each of which or some combination may include an implementation of a network environment. Program modules 407 generally perform the functions and / or methods of the embodiments described herein.
[0106] The electronic device 40 may also communicate with one or more external devices 409 (e.g., keyboards, pointing devices, displays 410, etc.), may communicate with one or more devices that enable a user to interact with the electronic device 40, and / or may communicate with any device that enables the electronic device 40 to communicate with one or more other computing devices (e.g., a network card, a modem, etc.). Such communication may be performed via an input / output (I / O) interface 411. Furthermore, the electronic device 40 may also communicate with one or more networks (e.g., a local area network (LAN), a wide area network (WAN), and / or a public network, such as the Internet) via a network adapter 412. As shown, the network adapter 412 communicates with other modules of the electronic device 40 via the bus 403. It should be understood that although Figure 5 Not shown, other hardware and / or software modules may be used in conjunction with the electronic device 40, including but not limited to microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems.
[0107] The processing unit 401 executes various functional applications and data processing by running the programs stored in the system memory 402, such as implementing the data accounting method provided in the embodiment of the present invention.
[0108] Embodiment 6
[0109] Embodiment 6 of the present invention further provides a storage medium comprising computer executable instructions, wherein the computer executable instructions are used to execute a data accounting method when executed by a computer processor.
[0110] The method includes:
[0111] In response to the data accounting instruction sent by the front-end page, determine the data processing template corresponding to the business processing system to be accounted for and the data to be processed; wherein the data accounting instruction corresponds to the business processing system to be accounted for;
[0112] Determining a target calculation template engine based on the data processing template, and processing the data to be processed based on the target calculation template engine to obtain target calculation data;
[0113] The calculation result is determined according to the target calculation data and the data to be calculated; wherein the data to be calculated is calculated by the business processing system to be calculated.
[0114] The computer storage medium of the embodiment of the present invention can adopt any combination of one or more computer-readable media. The computer-readable medium can be a computer-readable signal medium or a computer-readable storage medium. The computer-readable storage medium can be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or device, or any combination of the above. More specific examples (non-exhaustive list) of computer-readable storage media include: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In this document, a computer-readable storage medium can be any tangible medium containing or storing a program, which can be used by an instruction execution system, device or device or used in combination with it.
[0115] Computer-readable signal media may include a data signal propagated in baseband or as part of a carrier wave, in which computer-readable project code is carried. Such propagated data signals may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the above. Computer-readable signal media may also be any computer-readable medium other than a computer-readable storage medium, which may send, propagate, or transmit a program for use by or in conjunction with an instruction execution system, apparatus, or device.
[0116] Project code embodied on a computer-readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
[0117] Computer project code for performing the operation of embodiments of the present invention may be written in one or more programming languages or a combination thereof, including object-oriented programming languages, such as Java, Smalltalk, C++, and conventional procedural programming languages, such as "C" or similar programming languages. The project code may be executed entirely on the user's computer, partially on the user's computer, as a separate software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer via any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (e.g., via the Internet using an Internet service provider).
[0118] Note that the above are only preferred embodiments of the present invention and the technical principles used. Those skilled in the art will understand that the present invention is not limited to the specific embodiments described herein, and that various obvious changes, readjustments and substitutions can be made by those skilled in the art without departing from the scope of protection of the present invention. Therefore, although the present invention has been described in more detail through the above embodiments, the present invention is not limited to the above embodiments, and may include more other equivalent embodiments without departing from the concept of the present invention, and the scope of the present invention is determined by the scope of the appended claims.
Claims
1. A data calculation method, characterized in that: include: In response to the data accounting instruction sent by the front-end page, determine the data processing template corresponding to the business processing system to be accounted for and the data to be processed; wherein the data accounting instruction corresponds to the business processing system to be accounted for; Determining a target calculation template engine based on the data processing template, and processing the data to be processed based on the target calculation template engine to obtain target calculation data; Determining a calculation result according to the target calculation data and the data to be calculated; wherein the data to be calculated is calculated by the business processing system to be calculated; Wherein, determining a target computing template engine based on the data processing template includes: Parsing and extracting the accounting function in the data processing template, wherein the accounting function corresponds to the business to be accounted for; The target variable in the pre-built calculation template engine is determined according to the calculation function, and the data value of the target variable is replaced according to the field corresponding to the calculation function to obtain the target calculation template engine.
2. The method according to claim 1, characterized in that Also includes: Acquire a data processing template and a table to be filled corresponding to at least one business processing system; wherein the business processing system corresponds to the business to be accounted for; Import the business data in at least one business processing system into the corresponding table to be filled, and obtain the data to be processed corresponding to each business to be accounted for.
3. The method according to claim 1, characterized in that: The step of responding to the data accounting instruction sent by the front-end page and determining the data processing template corresponding to the business processing system to be accounted for and the data to be processed includes: In response to the data accounting instruction sent by the front-end page, extract the to-be-accounted business identifier carried in the data accounting instruction; According to the to-be-accounted business identifier, a to-be-accounted business processing system is determined in at least one business processing system, and a data processing template and to-be-processed data corresponding to the to-be-accounted business processing system are determined.
4. The method according to claim 1, characterized in that: The step of determining a target computing template engine based on the data processing template includes: Parse and extract the calculation function in the data processing template, verify the target variable in each cached calculation template engine based on the calculation function, and use the calculation template engine corresponding to the target variable that has successfully been verified as the target calculation template engine; After determining the target computing template engine, the method further includes: When it is detected that the calculation function has changed, the target calculation template engine is recompiled according to the new calculation function, so as to parse and calculate the data to be processed based on the recompiled target calculation template engine.
5. The method according to claim 1, characterized in that The determining of the calculation result according to the target calculation data and the data to be calculated includes: The target calculation data is compared with the data to be calculated, and the calculation result is determined based on the preset judgment rules and keywords.
6. The method according to any one of claims 1 to 5, characterized in that: Also includes: The target calculation data, the data to be calculated and the calculation result are imported into a calculation table corresponding to the business to be calculated, so as to load and display the calculation table on the target page.
7. A data calculation device, characterized in that: include: A data accounting instruction response module, used to respond to the data accounting instruction sent by the front-end page, determine the data processing template corresponding to the business processing system to be accounted for and the data to be processed; wherein the data accounting instruction corresponds to the business processing system to be accounted for; A target calculation data determination module, used to determine a target calculation template engine based on the data processing template, and process the data to be processed based on the target calculation template engine to obtain target calculation data; A calculation result determination module, used to determine the calculation result according to the target calculation data and the data to be calculated; wherein the data to be calculated is calculated by the business processing system to be calculated; Wherein, the target calculation data determination module includes: The target calculation template engine determination unit is used to parse and extract the accounting function in the data processing template, wherein the accounting function corresponds to the business to be accounted for; determine the target variable in the pre-built calculation template engine according to the accounting function, and replace the data value of the target variable according to the field corresponding to the accounting function to obtain the target calculation template engine.
8. An electronic device, characterized in that: The electronic device comprises: one or more processors; a storage device for storing one or more programs, When the one or more programs are executed by the one or more processors, the one or more processors implement the data accounting method as described in any one of claims 1-6.
9. A storage medium comprising computer executable instructions, wherein the computer executable instructions are used to execute the data accounting method as described in any one of claims 1 to 6 when executed by a computer processor.
Citation Information
Patent Citations
Data check script generation method, device and equipment
CN110018819A
Transaction data accounting method, apparatus and device, and storage medium
CN111062813A
Data processing method, device and equipment and storage medium
CN112668303A