CN112000660B

CN112000660B - Multi-report data processing method and device, computer equipment and storage medium

Info

Publication number: CN112000660B
Application number: CN202010635501.2A
Authority: CN
Inventors: 王君涛; 余永道
Original assignee: Suning Cloud Computing Co Ltd
Current assignee: Suning Cloud Computing Co Ltd
Priority date: 2020-07-03
Filing date: 2020-07-03
Publication date: 2022-11-15
Anticipated expiration: 2040-07-03
Also published as: CN112000660A

Abstract

The application relates to a multi-report data processing method, a multi-report data processing device, computer equipment and a storage medium, wherein the method comprises the following steps: acquiring a table sample of a service to be checked and data mapping information of the table sample, wherein the data mapping information is used for representing position information of each cell in the table sample; acquiring structured data of a plurality of reports to be checked of the service to be checked; acquiring position rendering information of each report to be checked, wherein the position rendering information is used for indicating the position of a table sample cell rendered by the structured data of the report to be checked; rendering the structured data of each report to be accounted into each cell of the sample according to the data mapping information and the rendering position information of each report to be accounted so as to obtain a business report of the business to be accounted, wherein the business report comprises the rendered form data of each report to be accounted; and calculating the form data of each report to be checked in the business report according to a preset operation rule. The method can improve the operation efficiency of the data of the plurality of reports.

Description

Multi-report data processing method and device, computer equipment and storage medium

Technical Field

The present application relates to the field of data processing technologies, and in particular, to a method and an apparatus for processing multi-report data, a computer device, and a storage medium.

Background

As the company industry continues to increase, the number of corresponding subsidiaries also continues to increase. In the process of step-by-step service summarization, the services of the companies needing to participate in accounting are filled in more or less manually, so that on one hand, the efficiency is low, and on the other hand, the error rate is high.

The reasons for the low efficiency of manual operation are mainly: data in the report to be checked submitted by each company are uneven and are mostly borne in an Excel form, and the accuracy of the data is difficult to guarantee. Meanwhile, in the process of combining and calculating the data of the multiple to-be-calculated reports, the multiple to-be-calculated reports need to be manually opened on computer equipment, and the operation is very complicated in the process of calculating the data of the multiple to-be-calculated reports. In addition, because the number of cells in each report to be checked is large, when the data of a plurality of cells of a plurality of reports to be checked are calculated by using the calculation formula carried by the report, the data calculation efficiency is low, and the calculation process is complex and is easy to make mistakes.

Disclosure of Invention

In view of the above, it is necessary to provide a multi-report data processing method, apparatus, computer device, and storage medium capable of improving the operation efficiency of data of a plurality of reports.

A multi-report data processing method comprises the following steps: acquiring a table sample of a service to be accounted and data mapping information of the table sample, wherein the data mapping information is used for representing position information of each cell in the table sample; acquiring structured data of a plurality of reports to be checked of the service to be checked, wherein the structured data is used for representing form data of each cell in the reports to be checked; acquiring position rendering information of each report to be checked, wherein the position rendering information is used for indicating the position of a table sample cell rendered by the structured data of the report to be checked; rendering the structured data of each report to be checked into each cell of the sample according to the data mapping information and the rendering position information of each report to be checked to obtain a service report of the service to be checked, wherein the service report comprises the rendered form data of each report to be checked; and calculating the form data of each report to be checked in the business report according to a preset operation rule.

In one embodiment, obtaining a table sample of a service to be accounted includes: and determining the service attribute of the service to be accounted, and acquiring a table sample of the service to be accounted according to the service attribute.

In one embodiment, the obtaining of the structured data of the multiple reports to be accounted for of the business to be accounted includes: acquiring a first quantity of data query processes in a process pool, wherein the data query processes are used for acquiring structured data of a report to be checked; acquiring a second quantity of the plurality of reports to be checked; determining the distribution mode of the first quantity of data query processes according to the first quantity and the second quantity; and controlling a first number of data query processes according to the distribution mode to acquire the structured data of the multiple reports to be checked in a parallel query mode.

In one embodiment, determining the allocation of the first number of data query processes according to the first number and the second number includes: if the first quantity is larger than or equal to the second quantity, determining that the distribution mode is a first mode, wherein the first mode is used for indicating each data query process in the second quantity of data query processes in the first quantity of data query processes to respectively obtain the structured data of each report form to be checked; and if the first quantity is smaller than the second quantity, determining that the distribution mode is a second mode, wherein the second mode is used for indicating that each data query process in the data query processes of the first quantity is controlled to acquire the structured data of the multiple reports to be checked according to the ratio of the second quantity to the first quantity.

In one embodiment, the data mapping information is determined according to the first identification information of the form sample and the second identification information of each cell in the form, and the structured data of each report to be checked is rendered to each cell of the form sample according to the data mapping information and the rendering position information of each report to be checked, including: acquiring information of a region to be rendered of a table sample; determining the position information of the target cell in the corresponding table sample of the information of the area to be rendered according to the first identification information and the second identification information in the data mapping information; and rendering the structured data of each report to be checked into the target cell of the sample according to the position information of the target cell and the rendering position information of each report to be checked.

In one embodiment, the target cells are multiple, and the second identification information of each cell in the form is determined according to the position offset information of each cell relative to the initial cell; determining the position information of the target cell in the corresponding table sample of the information of the area to be rendered according to the first identification information and the second identification information in the data mapping information, wherein the position information comprises the following steps: acquiring position offset information in the second identification information of each target cell; and determining the position information of each target cell of the to-be-rendered area information according to the first identification information and the position offset information in the second identification information of each target cell.

In one embodiment, the multi-report data processing method further includes: receiving a report acquisition instruction, wherein the report acquisition instruction comprises identification information of each report to be checked; acquiring a plurality of to-be-accounted reports of the to-be-accounted service according to the identification information of each to-be-accounted report; preferably, the operation is performed on the form data of each report to be checked in the business report according to a preset operation rule, and the operation includes: storing intermediate operation result data of the operation process; when operation interruption occurs in the operation process and operation is started again, acquiring intermediate operation result data during the operation interruption; and calculating the form data of each report to be checked in the business report according to a preset operation rule and the intermediate operation result data when the operation is interrupted.

A multi-report data processing device comprises: the system comprises a first acquisition module, a second acquisition module and a calculation module, wherein the first acquisition module is used for acquiring a table sample of a service to be accounted and data mapping information of the table sample, and the data mapping information is used for representing position information of each cell in the table sample; the second acquisition module is used for acquiring the structured data of the multiple to-be-accounted reports of the to-be-accounted service, wherein the structured data is used for representing the form data of each cell in the to-be-accounted report; the third acquisition module is used for acquiring position rendering information of each report to be accounted, and the position rendering information is used for indicating the position of the table sample cell rendered by the structured data of the report to be accounted; the rendering module is used for rendering the structured data of each report to be checked into each cell of the sample according to the data mapping information and the rendering position information of each report to be checked so as to obtain a service report of the service to be checked, wherein the service report comprises the rendered form data of each report to be checked; and the operation module is used for operating the form data of each report to be checked in the business report according to the preset operation rule.

A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the steps of the method of any of the above embodiments when executing the computer program.

A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the steps of the method of any one of the embodiments described above.

According to the multi-report data processing method, the multi-report data processing device, the computer equipment and the storage medium, the structured data of the multiple to-be-checked reports of the to-be-checked business are rendered into each cell of the samples through the data mapping information of the samples and the position rendering information of each to-be-checked report, so that the business report of the to-be-checked business is obtained. Therefore, when the data operation is carried out on the plurality of to-be-checked reports of the to-be-checked business, the plurality of to-be-checked reports do not need to be opened, and the operation amount is reduced. Further, when data operation is performed on a plurality of reports to be checked of the service to be checked, only the form data in a single report, namely the service report of the service to be checked, needs to be operated according to the preset operation rule, and the operation is not performed on the plurality of reports to be checked of the service to be checked respectively, so that the operation efficiency of the data of the plurality of reports can be improved.

Drawings

FIG. 1 is a diagram of an application environment of a method for processing multi-report data in an embodiment;

FIG. 2 is a flowchart illustrating a multi-report data processing method according to an embodiment;

FIG. 3 is a schematic flow chart of S104 in one embodiment;

FIG. 4 is a schematic illustration of a manner in which structured data for multiple companies is obtained in one embodiment;

FIG. 5 is a diagram that illustrates parallel processing of structured data for multiple to-be-accounted reports by processes, under an embodiment;

FIG. 6 is a diagram of a mapping relationship in data mapping information for a table-like form, under an embodiment;

fig. 7 is a schematic diagram of data interaction in a process in which a terminal executes a data operation of a service to be checked in an embodiment;

FIG. 8 is a flow diagram illustrating an exemplary process for accounting transactions of a single company;

FIG. 9 is a diagram illustrating assignment of Range ranges in one embodiment;

FIG. 10 is a diagram illustrating the distribution of parallel operations, according to one embodiment;

FIG. 11 is a schematic flow chart diagram illustrating operations on data of companies at upper and lower levels in one embodiment;

FIG. 12 is a block diagram of a multi-report data processing apparatus in an embodiment;

FIG. 13 is an internal block diagram of a computer device in one embodiment.

Detailed Description

In order to make the objects, technical solutions and advantages of the present application more clearly understood, the present application is further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.

The method for processing the multi-report data is applied to the application environment shown in figure 1. The user 200 operates the terminal 100 to implement the multi-report data processing method of the present application. Specifically, a data storage module 102 is disposed in the terminal 100, and the data storage module 102 is configured to store report data information of each service. For example, the data storage module 102 contains a tabular library 1022 of business reports, a structured data set 1024, and a data mapping file 1026. The table sample library 1022 of the business report stores the table samples of the business report corresponding to each business to be checked, such as the table sample of the business report 1 \8230, the table sample of the business report 8230and the table sample of the business report N. The structured data set 1024 contains structured data of each report to be checked, such as the structured data of the report to be checked 1, 82308230, and the structured data of the report to be checked N. The data mapping file 1026 stores data mapping information of samples of each business report and position rendering information of each report to be accounted of each business report. For example, the data mapping information of the table sample of the business report 1 and the position rendering information of each report to be checked of the business report 1 \8230, the data mapping information of the table sample of the business report N and the position rendering information of each report to be checked of the business report N are included in the table sample mapping information of the business report 1 and the position rendering information of each report to be checked of the business report N. When the terminal 100 receives an instruction operated by the user 200 to generate data operation of a service to be accounted, the terminal 100 obtains a table sample of the service to be accounted from the table sample library 1022 of the service report, obtains the structured data of a plurality of reports to be accounted of the service to be accounted from the structured data set 1024, and obtains data mapping information of the table sample and position rendering information of each report to be accounted from the data mapping file 1026. Further, the structured data of each report to be checked is rendered into each cell of the table sample according to the data mapping information of the table sample and the rendering position information of each report to be checked, so as to obtain a business report of the business to be checked, wherein the business report contains the form data of each report to be checked obtained after rendering. And finally, calculating the form data of each report to be checked in the business report according to a preset calculation rule. Therefore, the user 200 can realize the automatic operation of the plurality of to-be-accounted reports of the to-be-accounted service without opening the plurality of to-be-accounted reports of the to-be-accounted service for manual operation, and the efficiency of the data operation of the plurality of to-be-accounted reports of the to-be-accounted service is improved.

In an embodiment, as shown in fig. 2, the present application provides a multi-report data processing method, which is applied to the terminal 200 shown in fig. 1. Specifically, the multi-report data processing method comprises the following steps:

s102, a table sample of the service to be accounted and data mapping information of the table sample are obtained, and the data mapping information is used for representing position information of each cell in the table sample.

In this embodiment, the terminal stores table samples of a plurality of services. Wherein, each table sample is determined according to the accounting content of the corresponding service. For example, the accounting content related to the business to be accounted may include the content in multiple reports uploaded by multiple enterprises, or the content of multiple reports of a single enterprise. The accounting content related to the business to be accounted is contained in the report A, the report B and the report C, and the sample of the business to be accounted is set according to the content in the report A, the report B and the report C, so that the content of each related report can be stored according to the sample. Further, the terminal obtains data mapping information of the table sample, and the data mapping information is used for representing position information of each cell in the table sample. That is, the positions of the cells in the table samples are defined in the data mapping information, and the cells in the table samples can be positioned accurately by the data mapping information.

In a specific implementation, a business side specifies the business content of a business to be checked, generates a corresponding business report, and provides the business report to developers. And a developer adds positioning and marking to a specific area in the business report through the VBA script to generate a corresponding sample file of the business to be checked. The added positioning and labeling can be used as data mapping information of the table sample. The specific area in the table sample can be restored by the data mapping information.

S104, obtaining the structured data of the plurality of reports to be checked of the service to be checked, wherein the structured data is used for representing the form data of each cell in the reports to be checked.

In this embodiment, the terminal further obtains the structured data of the multiple to-be-accounted reports of the to-be-accounted service. Specifically, when business accounting is performed on the business to be accounted, the business data of the business to be accounted is dispersed in a plurality of reports to be accounted. Each report to be checked corresponds to structured data. The structured data represents form data of each cell in the report to be checked. The structured data can be represented by a two-dimensional array, and two dimensions of the two-dimensional array respectively represent the position information of each cell of the report to be checked and the corresponding form data of each cell. The structured data can be stored in the terminal or stored in a corresponding server to be downloaded from the server by the terminal. The method for the terminal to obtain the structured data of the multiple reports to be accounted for in the business to be accounted for may be as follows: the terminal obtains the structured data of the multiple to-be-checked reports of the to-be-checked business from the local storage, or the terminal sends a request to the server to request the structured data of the corresponding to-be-checked reports and receives the structured data of the to-be-checked reports sent by the server.

And S106, obtaining position rendering information of each report to be checked, wherein the position rendering information is used for indicating the position of the table sample cell rendered by the structured data of the report to be checked.

In this embodiment, the terminal further needs to obtain position rendering information of each report to be accounted. And the position rendering information of each report to be checked is used for indicating the position of the table sample cell rendered by the structured data of each report to be checked. That is, the position rendering information of each report to be checked can be exactly positioned at the position where the structured data of each report to be checked is rendered to the table-like cells. For example, the position rendering information of the report to be accounted A indicates that the structured data a of the report to be accounted A needs to be rendered to the cell b of the table sample, and the position rendering information gives the position information of the cell b. Therefore, the structured data a of the report to be checked can be accurately rendered into the table sample cells according to the position rendering information of the report to be checked A.

And S108, rendering the structured data of each to-be-computed report to each cell of the sample according to the data mapping information and the rendering position information of each to-be-computed report to obtain a service report of the to-be-computed service, wherein the service report comprises the rendered form data of each to-be-computed report.

In this embodiment, the positions of the cells of the table sample can be accurately located according to the data mapping information of the table sample, and the positions of the cells of the table sample, to which the structured data of each report to be accounted needs to be rendered, can be determined according to the rendering position information of each report to be accounted, so that the structured data of each report to be accounted can be rendered into the cells of the table sample according to the data mapping information and the rendering position information of each report to be accounted. For example, the rendering position information of the report to be accounted indicates that the structured data of the report to be accounted is rendered into the cells 21, 22 and 23 of the table sample, and the data mapping information of the table sample indicates the position information of the cells 21, 22 and 23 of the table sample, so that the structured data of the report to be accounted can be directly rendered into the cells 21, 22 and 23 of the table sample. Therefore, according to the method, the structured data of each report to be checked can be rendered into each cell of the table sample, so as to obtain the business report of the business to be checked. And the business report comprises the form data of each report to be checked obtained after rendering. Therefore, the form data of the plurality of to-be-accounted reports of the to-be-accounted service can be mapped into the same report, and when the data operation is performed on the form data of the plurality of to-be-accounted reports of the to-be-accounted service, the plurality of to-be-accounted reports do not need to be opened, so that the operation amount in the operation process is reduced. Meanwhile, the multiple reports to be checked are opened, the excessive capacity and the calculation resources of the terminal are occupied, and the form data of the multiple reports to be checked of the business to be checked are mapped into the same report, so that the operation pressure of the terminal can be relieved.

And S110, calculating the form data of each report to be calculated in the business report according to a preset operation rule.

In this embodiment, after mapping the form data of the multiple to-be-accounted reports of the to-be-accounted service to the service report, the terminal performs an operation on the form data of each to-be-accounted report in the service report according to a preset operation rule. It should be noted that, after the form data of the multiple reports to be checked of the service to be checked are mapped to the service report, the form data in the service report can be calculated by using the existing report calculation method. That is, the preset operation rule may be determined according to an operation manner in the existing report. For example, the preset operation rule may be implemented by using a self-contained operation function of an application program supporting the business report. Suppose that the business report is a report in an Excel format, and the tool supporting the business report is an Excel application. The Excel application provides a series of operational formulas. When a user selects a corresponding operation formula from the Excel application program according to the service accounting requirement of the service to be accounted, a preset operation rule can be determined according to the corresponding operation formula, so that the corresponding operation formula is adopted to operate the form data of each report to be accounted in the service report in the Excel application program. Therefore, the form data of each report to be checked in the service report can be automatically calculated through a set of table formula in the Excel application program, so that the data operation of a plurality of reports to be checked of the service to be checked can be solved by adopting the terminal without using the server side for operation, and the problems that the traditional server side has overlarge operation amount and complicated design and is difficult to realize are solved.

According to the multi-report data processing method, the structured data of the multiple reports to be checked of the business to be checked are rendered into each cell of the table sample through the data mapping information of the table sample and the position rendering information of each report to be checked, so that the business report of the business to be checked is obtained. Therefore, when the data operation is carried out on the plurality of reports to be checked of the business to be checked, the plurality of reports to be checked do not need to be opened, and the operation amount is reduced. Further, when data operation is performed on a plurality of reports to be checked of the service to be checked, only the form data in a single report of the service to be checked is required to be operated according to the preset operation rule, and the plurality of reports to be checked of the service to be checked are not required to be operated respectively.

In one embodiment, S102 includes: and determining the service attribute of the service to be accounted, and acquiring a table sample of the service to be accounted according to the service attribute.

In this embodiment, the terminal sets different samples for different services according to different service attributes. For example, the business to be accounted is a company business. The attributes of different companies are different, and the properties of their corresponding company services are also different. For example, the company attributes of the single company and the company attributes of the merger are different, and the corresponding company businesses are also different. That is, the terminal needs to dynamically determine the table sample of the service to be accounted. Specifically, the terminal determines a table sample of the service to be accounted according to the service attribute of the service to be accounted. Meanwhile, the terminal can abstract the common operation logic of different table samples and use the same code logic to adapt to different table samples. Therefore, the accuracy of obtaining the table sample of the service to be accounted can be improved.

In one embodiment, as shown in fig. 3, S104 includes:

s1042, a first number of data query processes in the process pool is obtained, and the data query processes are used for obtaining the structured data of the report to be checked.

S1044, acquiring a second quantity of the plurality of reports to be accounted.

S1046, determining the distribution mode of the first quantity of data query processes according to the first quantity and the second quantity.

And S1048, controlling a first number of data query processes according to the distribution mode, and acquiring the structured data of the multiple to-be-checked statements in a parallel query mode.

In this embodiment, the terminal creates a process pool, which includes a plurality of data query processes. And the data query process is used for acquiring the structured data of the report to be checked. The terminal can create a data query process in the process pool and also can delete the data query process in the process pool. When the process in the process pool is used for obtaining the structured data of the report forms to be checked, the terminal firstly determines the first number of data query processes in the process pool, simultaneously determines the second number of a plurality of report forms to be checked, and determines the distribution mode of the data query processes of the first number according to the first number and the second number. The distribution mode is used for indicating the acquisition mode of acquiring the structured data of each report to be checked by each data inquiry process in the first number of data inquiry processes. For example, the distribution mode may indicate that any one data query process of the first number of data query processes is only used for obtaining the structured data of any report to be checked. And finally, the terminal controls the first number of data query processes according to the distribution mode and obtains the structured data of the multiple reports to be checked in a parallel query mode. Therefore, the efficiency of acquiring the structured data of the multiple reports to be accounted can be improved.

In an embodiment, S1046 includes: if the first quantity is larger than or equal to the second quantity, determining that the distribution mode is a first mode, wherein the first mode is used for indicating each data query process in the second quantity of data query processes in the first quantity of data query processes to respectively obtain the structured data of each report form to be checked; and if the first quantity is smaller than the second quantity, determining that the distribution mode is a second mode, wherein the second mode is used for indicating that each data query process in the data query processes of the first quantity is controlled to acquire the structured data of the multiple reports to be checked according to the ratio of the second quantity to the first quantity.

In this embodiment, the distribution manner of the first number of data query processes includes a first manner and a second manner. When the first number is greater than or equal to the second number, the allocation mode is the first mode. When the terminal controls a first number of data query processes in a first mode and obtains the structured data of a plurality of reports to be checked and calculated in a parallel query mode, the method specifically comprises the following steps: and acquiring a second number of data query processes from the first number of data query processes, and controlling each data query process in the second number of data query processes to be used for acquiring the structured data of one report to be checked, so that the structured data of a plurality of reports to be checked can be quickly acquired without process waiting, and the efficiency of acquiring the structured data of the plurality of reports to be checked is improved.

And when the first number is smaller than the second number, determining that the distribution mode is the second mode. When the terminal controls the data query process of the first quantity in the second mode to acquire the structured data of the multiple reports to be checked in the parallel query mode, the method specifically comprises the following steps: and acquiring the ratio of the second quantity to the first quantity, and further controlling each data query process in the first quantity of data query processes to acquire the structured data of the multiple reports to be checked according to the ratio. The third number of the data query processes used for acquiring the structured data of the two or more reports to be checked in the first number of data query processes is determined according to the ratio of the second number to the first number, and the structured data of the multiple reports to be checked are controlled in the third number of data query processes and the other number of data query processes in a parallel query manner. For example, as shown in fig. 4, a plurality of reports to be accounted are N reports of N companies at the same level, an APP (Application) process pool is set at the terminal, and X processes are configured in the process pool. The X processes are respectively used for acquiring N reports of N companies. At this time, the terminal requests the server interface to acquire the structured data of the N companies. Specifically, data acquisition is performed by using X processes in a process pool. The terminal calculates a process of assigning structured data of Z companies to each process, where Z = N/X. The way in which each process processes the structured data of multiple reports to be accounted in parallel can be seen in fig. 5. The Z companies include parallel companies of the same hierarchy, such as parallel company A, parallel company B, parallel company C, and parallel company M. And the terminal applies processes to the APP process pool for each parallel company, and the applied processes are used for operation so as to obtain the structured data corresponding to the parallel companies. And releasing the process back to the APP process pool after the applied process completes the operation. The release back to the APP process pool can be used again to obtain structured data of other parallel companies. Therefore, the efficiency of acquiring the structured data of the multiple reports to be accounted can be improved.

In one embodiment, the data mapping information is determined according to first identification information of the table-like form and second identification information of each cell in the form. S108 comprises the following steps: acquiring information of a region to be rendered of a table sample; determining the position information of the target cell in the corresponding table sample of the information of the area to be rendered according to the first identification information and the second identification information in the data mapping information; and rendering the structured data of each report form to be checked into the target cell of the sample according to the position information of the target cell and the rendering position information of each report form to be checked.

In the embodiment, the terminal sets first identification information for a form of a form sample of a service to be accounted, and sets second identification information for cells in the form. In this case, the data mapping information of the table sample may be determined based on the first identification information of the table sample table and the second identification information of each cell in the table sample. The first identification information is used for identifying a form of a form sample of the service to be accounted, and the second identification information is used for identifying the position of each cell in the form. As shown in fig. 6, the first identification information may be a unique code of the form, the second identification information may be a unique code of the cell, and a unique key value of the cell may be obtained according to the first identification information and the second identification information. The unique key value can uniquely locate the corresponding cell. Specifically, as shown in fig. 6, H01, H02, and H03 each represent a unique ID of a corresponding sheet page in the form. R01 and R02 respectively represent corresponding row numbers in the form, and C01 and C02 respectively represent corresponding column numbers in the form. P01 represents that the data of the cell is filled in by formula operation, P02 represents that the data of the cell is filled in manually, and P03 represents that the data of the cell is filled in by server operation. The line number can be represented by a two-digit number, the front of the two-digit number is not automatically supplemented with 0, and the front of the three-digit number is not supplemented with 0. Therefore, when the to-be-rendered area information of the table sample is obtained, the position information of the target cell in the table sample corresponding to the to-be-rendered area information can be determined according to the first identification information and the second identification information in the data mapping information.

For example, when the terminal is setting the form sample, the form of the form sample of the service to be accounted is set with first identification information for identifying the form of the form sample of the service to be accounted. Meanwhile, the developer adds positioning and labeling to a specific area in the form through the VBA script. The specific area is the area containing the target cell in the form determined according to the information of the area to be rendered of the form sample. And generating data mapping information according to the added positioning and labeling, wherein the positioning and labeling can be the second identification information of each cell in the form. Further, the data mapping information may be encapsulated in a JSON file. The main program of the terminal can restore the information of the table sample by loading the JSON file, particularly, the position of the cell of the specific area in the table sample can be restored according to the positioning and marking in the JSON file. Therefore, the structured data of each report to be checked can be rendered into the target cell of the sample table according to the position information of the target cell and the rendering position information of each report to be checked, and therefore the structured data of each report to be checked can be quickly and accurately rendered into the target cell of the sample table.

In one embodiment, the target cell is multiple, and the second identification information of each cell in the form is determined according to the position offset information of each cell relative to the initial cell. Determining the position information of the target cell in the corresponding table sample of the information of the area to be rendered according to the first identification information and the second identification information in the data mapping information, wherein the position information comprises the following steps: acquiring position offset information in the second identification information of each target cell; and determining the position information of each target cell of the to-be-rendered area information according to the first identification information and the position offset information in the second identification information of each target cell.

In this embodiment, the terminal may set the reference number of the initial cell in the form, and may determine the position of each cell in the form according to the position offset information of each cell with respect to the initial cell. For example, the unique key value of each cell can be determined according to the unique key value of the initial cell and the position offset information of each cell relative to the initial cell, so that the unique key value of each target cell of the to-be-rendered area information can be quickly acquired. The unit cell assignment operation of each target unit cell can be accelerated through the unique key value of each target unit cell of the information of the region to be rendered, and the traditional cyclic unit cell assignment operation is replaced, so that the assignment efficiency of the unit cell is greatly improved, and the efficiency improvement of 100% -200% can be expected.

In an embodiment, before S104, the method further includes: receiving a report acquisition instruction, wherein the report acquisition instruction comprises identification information of each report to be checked; and acquiring a plurality of to-be-accounted reports of the to-be-accounted service according to the identification information of each to-be-accounted report.

In this embodiment, the terminal may set a UI interface. And a control used for triggering and selecting each report to be accounted for by a user is provided in the UI. And triggering the control of the UI by the user to generate a corresponding report acquisition instruction. The report acquisition instruction comprises identification information of each report to be checked. And the terminal receives the report acquisition instruction and acquires a plurality of reports to be accounted of the corresponding services to be accounted. Therefore, incremental or full-quantized data operation of the service to be accounted can be realized.

Specifically, if the information acquisition is abnormal in the process of acquiring the multiple to-be-accounted reports of the to-be-accounted service according to the identification information of each to-be-accounted report, for example, a request caused by network fluctuation is not returned, and the like, the program may be set to acquire the multiple to-be-accounted reports of the to-be-accounted service again.

In one embodiment, S110 includes: storing intermediate operation result data of the operation process; when operation interruption occurs in the operation process and operation is started again, acquiring intermediate operation result data when operation is interrupted; and calculating the form data of each report to be checked in the business report according to a preset operation rule and the intermediate operation result data when the operation is interrupted.

In the embodiment, when the terminal calculates the form data of each report to be checked in the business report, the terminal stores the intermediate calculation result data in the calculation process. When the operation process is interrupted and the operation is started again, for example, when the program is abnormal and cannot be recovered, the terminal uses the watchdog program to automatically restart the data operation of the service report after detecting the program abnormality. At this time, because the intermediate operation result data in the operation process is stored, the terminal can acquire the intermediate operation result data when the operation is interrupted and operate the form data of each report to be checked in the business report according to the preset operation rule and the intermediate operation result data when the operation is interrupted. Therefore, the time for the whole re-full operation caused by the interruption of the operation process is greatly shortened.

In an embodiment, after S104, the method further includes: generating a plurality of forms of the report to be checked according to the structured data of the report to be checked, wherein the form data corresponding to the structured data is stored in the form of each report to be checked; and backing up and storing the forms of the multiple reports to be checked.

Specifically, each time the terminal operates, the forms of the multiple reports to be checked are additionally stored in the formulated folder for data backup, and therefore a user can conveniently check the data.

Some specific embodiments are given below to describe the above-mentioned multi-report data processing method in detail.

Example 1:

the business to be accounted is the business to be accounted only related to the single company, and the terminal stores the table sample of the business to be accounted and the data mapping information of the table sample. The structured data of the multiple to-be-accounted reports of the to-be-accounted service can be obtained by performing data processing on the form data of the multiple to-be-accounted reports in advance to obtain corresponding structured data, and the corresponding structured data is stored in the terminal or the corresponding server. When the structured data of the multiple reports to be accounted are stored in the server, the terminal executes the data operation process of the service to be accounted as shown in fig. 7.

And the terminal is provided with a client. When the business to be checked of company A is executed, the client loads the JSON mapping resource on the terminal, wherein the JSON mapping resource comprises a table sample of the business to be checked, data mapping information of the table sample, position rendering information of each report to be checked of the business to be checked and the like. Meanwhile, the client requests the server for inquiring the data of company A, specifically the structured data of a plurality of reports to be checked of the business to be checked of company A. The server side inquires DB (Data Base) according to the request to obtain the Data of the company A and returns the Data of the company A to the client side. The client renders the structured data of the multiple reports to be accounted of the business to be accounted of the company A into the cells, specifically the cells in the form of the form sample, according to the mapping relation in the data mapping information, so as to generate the business report corresponding to the form sample. The business report is an Excel report. And performing data operation on the form data of the multiple reports to be checked of the service to be checked through self-operation of the Excel formula of the Excel report. Furthermore, the operation structure is obtained and analyzed into structured data, and then the structured data is sent to the server side. And the server stores the structured data so as to facilitate the inquiry of the client at the next time. The operation process of the business to be checked of the single company can also be seen in fig. 8. The JOSN file comprises the JOSN mapping resources, and the Range refers to the Range of table-like cells required to render the structured data of each report to be checked. A diagram of Range assignments is shown in figure 9. Here, the Range is a Cell Range shown by an N row M list, and Cell1, cell2, cell3, cell4, cell5, cell6, cell7, cell8, and Cell9 respectively represent cells in the sample. Range ranges in a sample are assigned by the Var data = object [ M, N ] function. In the manner expressed in fig. 7, fig. 8 and fig. 9, the client implements data operation of the service to be accounted.

Example 2:

the business to be accounted is a business report related to a plurality of companies, and the terminal stores the data mapping information of the table samples and the table samples of the business to be accounted. And storing the plurality of to-be-accounted reports of the to-be-accounted service, namely the structured data of the service reports of the plurality of companies at the corresponding service terminals. The terminal needs to request the server for the structured data of the multiple reports to be accounted so as to perform operation on the form data of the business reports of the multiple companies. When the operation of the form data of a plurality of companies has a hierarchical relationship, that is, the operation result of a certain company is used as the operation basis of the form data operation of another company, the form data of the same-level company can be operated in parallel, and the form data of the non-same-level company can wait for the operation result of the company of the previous level and then execute the operation. The parallel operation manner of the form data of the companies at the same level can be seen in fig. 10. An Excel Application (Excel Application program) is arranged in the client, and an Excel Application process pool is provided with N processes. In the parallel operation process, a plurality of companies include parallel company A, parallel company B, parallel company C \8230, parallel company 8230and parallel company N. The client performs operations for each parallel company application process, as shown in fig. 10. The N processes are applied and acquired by N companies, and the parallel company A operates to finish the (N + 1) th parallel company application and acquisition process of the release process. For data operation of companies at upper and lower levels, see fig. 11. The company at level 1 is operated to obtain an operation result 1. The operation result 1 is input to the company of the level 2, and the operation is performed on the company of the level 2 to obtain an operation result 2. And repeating the steps in sequence, and finally executing the operation of the merging company. For example, the company 11, the company 12, and the company 13 \8230 \ 8230;, and the company 1N at the level 1 can be executed by the parallel operation method described above when performing data operation. Therefore, the data operation can be accelerated, and the efficiency of the data operation can be improved.

It should be understood that, although the steps in the flowchart are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least some of the steps in the figures may include multiple sub-steps or multiple stages that are not necessarily performed at the same time, but may be performed at different times, and the order of performance of the sub-steps or stages is not necessarily sequential, but may be performed in turn or alternately with other steps or at least some of the sub-steps or stages of other steps.

The present application further provides a multi-report data processing apparatus, as shown in fig. 12, the apparatus includes a first obtaining module 10, a second obtaining module 20, a third obtaining module 30, a rendering module 40, and an operation module 50. The first obtaining module 10 is configured to obtain a table sample of a service to be accounted and data mapping information of the table sample, where the data mapping information is used to represent location information of each cell in the table sample; the second obtaining module 20 is configured to obtain structured data of a plurality of reports to be checked of the service to be checked, where the structured data is used to represent form data of each cell in the report to be checked; the third obtaining module 30 is configured to obtain position rendering information of each report to be accounted, where the position rendering information is used to indicate a position at which the structured data of the report to be accounted is rendered to a cell of the table sample; the rendering module 40 is configured to render the structured data of each to-be-computed report into each cell of the sample according to the data mapping information and the rendering position information of each to-be-computed report, so as to obtain a service report of the to-be-computed service, where the service report includes the rendered form data of each to-be-computed report; the operation module 50 is configured to perform operation on the form data of each report to be checked in the business report according to a preset operation rule.

In one embodiment, the first obtaining module 10 is specifically configured to determine a service attribute of a service to be accounted, and obtain a table sample of the service to be accounted according to the service attribute.

In one embodiment, the second obtaining module 20 is specifically configured to obtain a first number of data query processes in the process pool, where the data query processes are used to obtain structured data of a report to be checked; acquiring a second quantity of the plurality of reports to be checked; determining the distribution mode of the data query processes of the first quantity according to the first quantity and the second quantity; and controlling a first quantity of data query processes according to the distribution mode to acquire the structured data of the multiple reports to be checked and calculated in a parallel query mode.

In one embodiment, the second obtaining module 20 is further specifically configured to determine that the allocation manner is the first manner if the first number is greater than or equal to the second number, where the first manner is used to indicate each data query process in the second number of data query processes in the first number of data query processes to obtain the structured data of each report to be accounted; and if the first quantity is smaller than the second quantity, determining that the distribution mode is a second mode, wherein the second mode is used for indicating that each data query process in the data query processes of the first quantity is controlled to acquire the structured data of the multiple reports to be checked according to the ratio of the second quantity to the first quantity.

In one embodiment, the data mapping information is determined according to first identification information of the table-like form and second identification information of each cell in the form; the rendering module 40 is specifically configured to obtain information of a region to be rendered of the table sample; determining the position information of the target cell in the corresponding table sample of the information of the area to be rendered according to the first identification information and the second identification information in the data mapping information; and rendering the structured data of each report form to be checked into the target cell of the sample according to the position information of the target cell and the rendering position information of each report form to be checked.

In one embodiment, the target cells are multiple, and the second identification information of each cell in the form is determined according to the position offset information of each cell relative to the initial cell; the rendering module 40 is further specifically configured to obtain position offset information in the second identification information of each target cell; and determining the position information of each target cell of the to-be-rendered area information according to the first identification information and the position offset information in the second identification information of each target cell.

In one embodiment, the multi-report data processing apparatus further includes a fourth obtaining module (not shown), where the fourth obtaining module is configured to receive a report obtaining instruction, and the report obtaining instruction includes identification information of each report to be accounted; and acquiring a plurality of reports to be checked of the service to be checked according to the identification information of each report to be checked.

In one embodiment, the operation module 50 is specifically configured to store intermediate operation result data of the operation process; when operation interruption occurs in the operation process and operation is started again, acquiring intermediate operation result data during the operation interruption; and calculating the form data of each report to be checked in the business report according to a preset operation rule and the intermediate operation result data when the operation is interrupted.

For specific limitations of the multi-report data processing apparatus, reference may be made to the above limitations of the multi-report data processing method, which are not described herein again. All or part of each module in the multi-report data processing device can be realized by software, hardware and a combination thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.

In one embodiment, a computer device is provided, which may be a terminal, and its internal structure diagram may be as shown in fig. 13. The computer device comprises a processor, a memory, a network interface, a display screen and an input device which are connected through a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operating system and the computer program to run on the non-volatile storage medium. The network interface of the computer equipment is used for connecting and communicating with an external server through a network. The computer program is executed by a processor to implement a multi-report data processing method. The display screen of the computer equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, a key, a track ball or a touch pad arranged on a shell of the computer equipment, an external keyboard, a touch pad or a mouse and the like.

Those skilled in the art will appreciate that the architecture shown in fig. 13 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.

In one embodiment, a computer device is provided, comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, the processor implementing the following steps when executing the computer program: acquiring a table sample of a service to be accounted and data mapping information of the table sample, wherein the data mapping information is used for representing position information of each cell in the table sample; acquiring structured data of a plurality of reports to be checked of the service to be checked, wherein the structured data is used for representing form data of each cell in the reports to be checked; acquiring position rendering information of each report to be checked, wherein the position rendering information is used for indicating the position of a table sample cell rendered by the structured data of the report to be checked; rendering the structured data of each report to be checked into each cell of the sample according to the data mapping information and the rendering position information of each report to be checked to obtain a service report of the service to be checked, wherein the service report comprises the rendered form data of each report to be checked; and calculating the form data of each report to be checked in the business report according to a preset operation rule.

In one embodiment, when the processor executes the computer program to implement the step of obtaining the table sample of the service to be accounted, the following steps are specifically implemented: and determining the service attribute of the service to be accounted, and acquiring a table sample of the service to be accounted according to the service attribute.

In one embodiment, when the processor executes the computer program to implement the step of obtaining the structured data of the multiple to-be-checked reports of the to-be-checked service, the following steps are specifically implemented: acquiring a first quantity of data query processes in a process pool, wherein the data query processes are used for acquiring structured data of a report to be checked; acquiring a second quantity of the plurality of reports to be checked; determining the distribution mode of the data query processes of the first quantity according to the first quantity and the second quantity; and controlling a first number of data query processes according to the distribution mode to acquire the structured data of the multiple reports to be checked in a parallel query mode.

In one embodiment, when the processor executes the computer program to implement the step of determining the allocation manner of the first number of data query processes according to the first number and the second number, the following steps are specifically implemented: if the first quantity is larger than or equal to the second quantity, determining that the distribution mode is a first mode, wherein the first mode is used for indicating each data query progress in the second quantity of data query progresses in the first quantity of data query progresses to respectively obtain the structured data of each report to be checked; and if the first quantity is smaller than the second quantity, determining that the distribution mode is a second mode, wherein the second mode is used for indicating that each data query process in the data query processes of the first quantity is controlled to acquire the structured data of the multiple reports to be checked according to the ratio of the second quantity to the first quantity.

In one embodiment, the data mapping information is determined according to first identification information of the form sample and second identification information of each cell in the form; when the processor executes the computer program to realize the step of rendering the structured data of each report to be checked to each cell of the table sample according to the data mapping information and the rendering position information of each report to be checked, the following steps are specifically realized: acquiring information of a region to be rendered of a table sample; determining the position information of the target cell in the corresponding table sample of the information of the area to be rendered according to the first identification information and the second identification information in the data mapping information; and rendering the structured data of each report form to be checked into the target cell of the sample according to the position information of the target cell and the rendering position information of each report form to be checked.

In one embodiment, the target cells are multiple, and the second identification information of each cell in the form is determined according to the position offset information of each cell relative to the initial cell; when the processor executes the computer program to realize the step of determining the position information of the target cell in the corresponding table sample of the to-be-rendered area information according to the first identification information and the second identification information in the data mapping information, the following steps are specifically realized: acquiring position offset information in the second identification information of each target cell; and determining the position information of each target cell of the to-be-rendered area information according to the first identification information and the position offset information in the second identification information of each target cell.

In one embodiment, the processor, when executing the computer program, performs the steps of: receiving a report acquisition instruction, wherein the report acquisition instruction comprises identification information of each report to be checked; and acquiring a plurality of to-be-accounted reports of the to-be-accounted service according to the identification information of each to-be-accounted report.

In one embodiment, when the processor executes the computer program to implement the step of performing the operation on the form data of each report to be checked in the business report according to the preset operation rule, the following steps are specifically implemented: storing intermediate operation result data of the operation process; when operation interruption occurs in the operation process and operation is started again, acquiring intermediate operation result data when operation is interrupted; and calculating the form data of each report to be checked in the business report according to a preset operation rule and the intermediate operation result data when the operation is interrupted.

In one embodiment, a computer-readable storage medium is provided, having a computer program stored thereon, which when executed by a processor, performs the steps of: acquiring a table sample of a service to be accounted and data mapping information of the table sample, wherein the data mapping information is used for representing position information of each cell in the table sample; acquiring structured data of a plurality of reports to be checked of the service to be checked, wherein the structured data is used for representing form data of each cell in the reports to be checked; acquiring position rendering information of each report to be accounted, wherein the position rendering information is used for indicating the position of the table sample cell rendered by the structured data of the report to be accounted; rendering the structured data of each report to be checked into each cell of the sample according to the data mapping information and the rendering position information of each report to be checked to obtain a service report of the service to be checked, wherein the service report comprises the rendered form data of each report to be checked; and calculating the form data of each report to be checked in the business report according to a preset operation rule.

In one embodiment, when the computer program is executed by the processor to implement the step of obtaining the table sample of the service to be accounted, the following steps are specifically implemented: and determining the service attribute of the service to be accounted, and acquiring a table sample of the service to be accounted according to the service attribute.

In one embodiment, when the computer program is executed by the processor to implement the step of obtaining the structured data of the multiple to-be-checked reports of the to-be-checked service, the following steps are specifically implemented: acquiring a first quantity of data query processes in a process pool, wherein the data query processes are used for acquiring structured data of a report to be checked; acquiring a second quantity of the plurality of reports to be checked; determining the distribution mode of the first quantity of data query processes according to the first quantity and the second quantity; and controlling a first number of data query processes according to the distribution mode to acquire the structured data of the multiple reports to be checked in a parallel query mode.

In one embodiment, when the computer program is executed by the processor to implement the step of determining the allocation manner of the first number of data query processes according to the first number and the second number, the following steps are specifically implemented: if the first quantity is larger than or equal to the second quantity, determining that the distribution mode is a first mode, wherein the first mode is used for indicating each data query progress in the second quantity of data query progresses in the first quantity of data query progresses to respectively obtain the structured data of each report to be checked; and if the first quantity is smaller than the second quantity, determining that the distribution mode is a second mode, wherein the second mode is used for indicating that each data query process in the data query processes of the first quantity is controlled to acquire the structured data of the multiple reports to be checked according to the ratio of the second quantity to the first quantity.

In one embodiment, the data mapping information is determined according to first identification information of the table-like form and second identification information of each cell in the form; when the computer program is executed by the processor to realize the step of rendering the structured data of each report to be accounted to each cell of the table sample according to the data mapping information and the rendering position information of each report to be accounted, the following steps are specifically realized: acquiring information of a region to be rendered of a table sample; determining the position information of the target cell in the corresponding table sample of the information of the area to be rendered according to the first identification information and the second identification information in the data mapping information; and rendering the structured data of each report form to be checked into the target cell of the sample according to the position information of the target cell and the rendering position information of each report form to be checked.

In one embodiment, the target cells are multiple, and the second identification information of each cell in the form is determined according to the position offset information of each cell relative to the initial cell; when the computer program is executed by the processor to realize the step of determining the position information of the target cell in the corresponding table sample of the area information to be rendered according to the first identification information and the second identification information in the data mapping information, the following steps are specifically realized: acquiring position offset information in the second identification information of each target cell; and determining the position information of each target cell of the to-be-rendered area information according to the first identification information and the position offset information in the second identification information of each target cell.

In one embodiment, the computer program when executed by the processor performs the steps of: receiving a report acquisition instruction, wherein the report acquisition instruction comprises identification information of each report to be checked; and acquiring a plurality of reports to be checked of the service to be checked according to the identification information of each report to be checked.

In one embodiment, when the computer program is executed by the processor to implement the step of performing the operation on the form data of each report to be checked in the business report according to the preset operation rule, the following steps are specifically implemented: storing intermediate operation result data of the operation process; when operation interruption occurs in the operation process and operation is started again, acquiring intermediate operation result data during the operation interruption; and calculating the form data of each report to be checked in the business report according to a preset operation rule and the intermediate operation result data when the operation is interrupted.

It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above may be implemented by hardware instructions of a computer program, which may be stored in a non-volatile computer-readable storage medium, and when executed, may include the processes of the embodiments of the methods described above. Any reference to memory, storage, database or other medium used in the embodiments provided herein can include non-volatile and/or volatile memory. Non-volatile memory can include read-only memory (ROM), programmable ROM (PROM), electrically Programmable ROM (EPROM), electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double Data Rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous Link DRAM (SLDRAM), rambus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).

The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.

The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present patent shall be subject to the appended claims.

Claims

1. A multi-report data processing method, the method comprising:

acquiring a table sample of a service to be accounted and data mapping information of the table sample, wherein the data mapping information is used for representing position information of each cell in the table sample;

acquiring structured data of a plurality of reports to be checked of the service to be checked, wherein the structured data is used for representing form data of each cell in the reports to be checked;

acquiring position rendering information of each report to be checked, wherein the position rendering information is used for indicating the position of the structured data of the report to be checked, which is rendered to the cells of the table sample;

rendering the structured data of each report to be accounted into each cell of the sample according to the data mapping information and the rendering position information of each report to be accounted so as to obtain a business report of the business to be accounted, wherein the business report comprises the form data of each report to be accounted obtained after rendering;

calculating the form data of each report to be checked in the business report according to a preset calculation rule;

the obtaining of the structured data of the multiple to-be-accounted reports of the to-be-accounted service includes:

acquiring a first quantity of data query processes in a process pool, wherein the data query processes are used for acquiring structured data of the report to be checked;

acquiring a second quantity of the plurality of reports to be checked;

determining the distribution mode of the data query processes of the first quantity according to the first quantity and the second quantity, wherein the distribution mode comprises the following steps:

if the first quantity is larger than or equal to the second quantity, determining that the distribution mode is a first mode, wherein the first mode is used for indicating that each data query process in the second quantity of data query processes in the first quantity of data query processes respectively obtains the structured data of each report form to be accounted;

and if the first quantity is smaller than the second quantity, determining that the distribution mode is a second mode, wherein the second mode is used for indicating that each data query process in the first quantity of data query processes is controlled to acquire the structured data of the multiple reports to be accounted according to the ratio of the second quantity to the first quantity.

2. The method of claim 1, wherein the obtaining the table sample of the service to be accounted comprises:

determining the service attribute of the service to be accounted, and acquiring the table sample of the service to be accounted according to the service attribute.

3. The method according to claim 1, wherein the data mapping information is determined according to first identification information of a form of the form sample and second identification information of each cell in the form, and the rendering the structured data of each report to be accounted to each cell of the form sample according to the data mapping information and rendering position information of each report to be accounted comprises:

acquiring information of a region to be rendered of the table sample;

determining the position information of the target cell in the table sample corresponding to the information of the area to be rendered according to the first identification information and the second identification information in the data mapping information;

and rendering the structured data of each report form to be accounted into the target cell of the sample according to the position information of the target cell and the rendering position information of each report form to be accounted.

4. The method according to claim 3, wherein the target cell is plural, and the second identification information of each cell in the form is determined according to the position offset information of each cell relative to the initial cell;

the determining, according to the first identification information and the second identification information in the data mapping information, the position information of the target cell in the table sample corresponding to the to-be-rendered area information includes:

acquiring the position offset information in the second identification information of each target cell;

and determining the position information of each target cell of the to-be-rendered area information according to the first identification information and the position offset information in the second identification information of each target cell.

5. The method of claim 1, further comprising:

receiving a report acquisition instruction, wherein the report acquisition instruction comprises identification information of each report to be checked;

acquiring a plurality of reports to be checked of the service to be checked according to the identification information of each report to be checked;

the calculating the form data of each report to be checked in the business report according to the preset calculation rule includes:

storing intermediate operation result data of the operation process;

when operation interruption occurs in the operation process and operation is started again, acquiring intermediate operation result data when the operation is interrupted;

and calculating the form data of each report to be checked in the business report according to a preset operation rule and the intermediate operation result data when the operation is interrupted.

6. An apparatus for implementing the multi-report data processing method according to claim 1, the apparatus comprising:

the system comprises a first acquisition module, a second acquisition module and a calculation module, wherein the first acquisition module is used for acquiring a table sample of a service to be accounted and data mapping information of the table sample, and the data mapping information is used for representing position information of each cell in the table sample;

the second acquisition module is used for acquiring the structured data of the multiple to-be-accounted reports of the to-be-accounted service, wherein the structured data is used for representing the form data of each cell in the to-be-accounted reports;

a third obtaining module, configured to obtain position rendering information of each report to be accounted, where the position rendering information is used to indicate a position at which the structured data of the report to be accounted is rendered to a cell of the form sample;

the rendering module is used for rendering the structured data of each report to be accounted into each cell of the sample according to the data mapping information and the rendering position information of each report to be accounted so as to obtain a business report of the business to be accounted, wherein the business report comprises the form data of each report to be accounted obtained after rendering;

and the operation module is used for operating the form data of each report to be checked in the business report according to a preset operation rule.

7. A computer arrangement comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the steps of the method according to any of claims 1 to 5 when executing the computer program.

8. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 5.