CN117807977A

CN117807977A - Report processing method and device based on formula engine

Info

Publication number: CN117807977A
Application number: CN202311806086.2A
Authority: CN
Inventors: 贺昌茂; 聂小玉; 聂欣红
Original assignee: Wuhan Haichang Information Technology Co ltd
Current assignee: Wuhan Haichang Information Technology Co ltd
Priority date: 2023-12-26
Filing date: 2023-12-26
Publication date: 2024-04-02

Abstract

The application provides a report processing method and device based on a formula engine, wherein the method comprises the following steps: acquiring editing results of a plurality of report editors on an initial report template to obtain a first report; according to the editing actions of report editors, a plurality of report prompt areas are obtained from a first report, wherein the report prompt areas are report editing areas with error editing risks in the first report; processing the report prompt area to obtain a sub-report to be confirmed; processing report editor information of a report prompt area by adopting a preset formula engine so as to send a sub report to be confirmed to a first editing terminal; and updating the first report according to a first confirmation result of the sub-report to be confirmed, which is sent by the first editing terminal. By the method, the accuracy and reliability of report contents are ensured in the bidirectional feedback process of editing and transferring the report.

Description

Report processing method and device based on formula engine

Technical Field

The present disclosure relates to the technical field of document processing, and in particular, to a report processing method and apparatus based on a formula engine.

Background

The report forms play an important role in daily operation of enterprises, and managers of the enterprises can timely know the current working contents, working results and data analysis results of the operation conditions of the enterprises through report form contents. Meanwhile, staff of the enterprise can timely supplement contents needing to be fed back through the report. In the process, the report forms serve as a communication medium to realize bidirectional feedback, so that the operation efficiency of enterprises is improved. Therefore, how to guarantee the accuracy and reliability of report contents in the process of editing and transferring the report is a problem to be considered urgently.

Based on the actual needs in the above scenario, the present application proposes a report processing method and device based on a formula engine.

Disclosure of Invention

The application provides a report processing method and device based on a formula engine, which are used for guaranteeing the accuracy and reliability of report contents in the bidirectional feedback process of report editing and transferring.

The first aspect of the present application provides a report processing method based on a formula engine, the method comprising: acquiring editing results of a plurality of report editors on an initial report template to obtain a first report; according to the editing actions of report editors, a plurality of report prompt areas are obtained from a first report, wherein the report prompt areas are report editing areas with error editing risks in the first report; processing the report prompt area to obtain a sub-report to be confirmed; processing report editor information of a report prompt area by adopting a preset formula engine so as to send a sub report to be confirmed to a first editing terminal; and updating the first report according to a first confirmation result of the sub-report to be confirmed, which is sent by the first editing terminal.

By adopting the method, a plurality of report prompt areas are acquired from the first report according to the editing actions of report editors, so that the report edit areas with error editing risks in the first report are prompted; generating a sub-report to be confirmed from the multiple report prompting areas, sending the sub-report to editors of the report prompting areas, confirming and modifying contents in the multiple report prompting areas, and updating the first report; the report content is ensured to be accurate and reliable in the bidirectional feedback process of editing and transferring the report.

Optionally, according to an editing action of a report editor, a plurality of report prompt areas are obtained from the first report, and specifically include: acquiring the number of editors in any one first report area from the first report; when the number of editors is greater than or equal to the number of preset editors, determining the first report area as a report prompt area; and simultaneously, acquiring a first association area of the first report area, and determining the first association area as a report prompt area.

By adopting the method, the number of editors in any one first report area is obtained from the first report; when the number of editors is greater than or equal to the number of preset editors, the first report area is determined to be a report prompt area, and an area with error editing risk can be timely found in the editing process and processed, so that the editing quality and accuracy of a report are improved.

Optionally, according to the editing action of the report editor, a plurality of report prompt areas are obtained from the first report, and the method further includes: acquiring first report editor information of a first report area from a first report; when the number of editors is smaller than the number of preset editors, acquiring second report editors information of a second association area, wherein the second association area is a report area of the same row or the same column of the first report area; and when the second report editor information does not accord with the first report editor information, determining the first report area as a report prompt area.

By adopting the method, when the number of editors is smaller than the number of preset editors, second report editors information of a second association area is acquired, wherein the second association area is a report area in the same row or column of the first report area; when the second report editor information is inconsistent with the first report editor information, the first report area is determined to be a report prompt area, and when the number of editors in the first report area is smaller than the number of preset editors, the first report area with the wrong editing risk can be found in time.

Optionally, processing the report prompt area to obtain a sub-report to be confirmed, which specifically includes: respectively obtaining the header names of a plurality of report prompt areas; and generating a plurality of sub-reports to be confirmed according to the names of the table heads of the report prompt areas, wherein the table head names of the report prompt areas in any one sub-report to be confirmed are the same.

By adopting the method, the report prompt area is processed to obtain the sub report to be confirmed, so that the workload of report editors can be reduced, and the problem of inaccurate confirmation content caused by wrong editing operation when the content of the report prompt area is directly confirmed is avoided.

Optionally, the report editor information in the report prompt area is processed by adopting a preset formula engine to send the sub-report to be confirmed to the first editing terminal, which specifically includes: the sub-report to be confirmed comprises any first sub-report to be confirmed, and editing frequency data of each report area in the first sub-report to be confirmed, which is edited by a plurality of report editors, is obtained; processing the editing frequency data to obtain the association degree of any report editor with respect to the first sub-report to be confirmed; sorting the relevance of the report editors from large to small to obtain a first report editor corresponding to the relevance of the first sorting; and sending the first sub report to be confirmed to a first editing terminal, wherein the first editing terminal is an editing terminal corresponding to the first report editor.

By adopting the method, the editing terminal which needs to be transmitted by the sub-report to be confirmed is confirmed according to the association degree of the table editor about the first sub-report to be confirmed, so that the first sub-report to be confirmed can be more accurately generated to the editing terminal of the report editor with error editing operation.

Optionally, updating the first report according to the first confirmation result of the sub-report to be confirmed sent by the first editing terminal specifically includes: when the first editing terminal confirms that the report content of the sub-report to be confirmed has errors, acquiring an updated sub-report sent by the first editing terminal; and updating the corresponding content in the first report according to the updated sub-report.

Optionally, the method further comprises; acquiring a second report editor with abnormal association according to the association of the report editors; the first sub report to be confirmed is sent to a second editing terminal, and the second editing terminal is an editing terminal corresponding to a second report editor; verifying the first confirmation result according to the second confirmation result of the second editing terminal; and when the second confirmation result is identical to the first confirmation result in verification, updating the first report according to the first confirmation result.

By adopting the method, the first sub report to be confirmed is sent to the second editing terminal, so that a multi-level confirmation and feedback mechanism can be realized, and the communication efficiency and quality are improved. And meanwhile, the first confirmation result can be verified and processed according to the second confirmation result of the second editing terminal, so that the editing quality and accuracy of the report can be more accurately ensured.

The second aspect of the application provides a report processing device based on a formula engine, which comprises a report acquisition unit, a risk acquisition unit, a report generation unit, a report sending unit and a report updating unit;

the report acquisition unit is used for acquiring the editing results of a plurality of report editors on the initial report template to obtain a first report;

The risk acquisition unit is used for acquiring a plurality of report prompt areas from the first report according to the editing actions of report editors, wherein the report prompt areas are report editing areas with error editing risks in the first report;

the report generation unit is used for processing the report prompt area to obtain a sub-report to be confirmed;

the report sending unit is used for processing report editor information of a report prompt area by adopting a preset formula engine so as to send the sub-report to be confirmed to the first editing terminal;

and the report updating unit is used for updating the first report according to the first confirmation result of the sub-report to be confirmed, which is sent by the first editing terminal.

A third aspect of the present application provides an electronic device comprising a processor, a memory, a user interface and a network interface, the memory for storing instructions, the user interface and the network interface for communicating to other devices, the processor for executing the instructions stored in the memory to cause the electronic device to perform the method of any one of the above.

A fourth aspect of the present application provides a computer readable storage medium storing instructions that, when executed, perform a method of any one of the above.

Compared with the related art, the beneficial effects of the application are as follows:

1. by adopting the method, a plurality of report prompt areas are acquired from the first report according to the editing actions of report editors, so that the report edit areas with error editing risks in the first report are prompted; generating a sub-report to be confirmed from the multiple report prompting areas, sending the sub-report to editors of the report prompting areas, confirming and modifying contents in the multiple report prompting areas, and updating the first report; the report content is ensured to be accurate and reliable in the bidirectional feedback process of editing and transferring the report.

2. By adopting the method, the number of editors in any one first report area is obtained from the first report; when the number of editors is greater than or equal to the number of preset editors, the first report area is determined to be a report prompt area, and an area with error editing risk can be timely found in the editing process and processed, so that the editing quality and accuracy of a report are improved.

3. By adopting the method, when the number of editors is smaller than the number of preset editors, second report editors information of a second association area is acquired, wherein the second association area is a report area in the same row or column of the first report area; when the second report editor information is inconsistent with the first report editor information, the first report area is determined to be a report prompt area, and when the number of editors in the first report area is smaller than the number of preset editors, the first report area with the wrong editing risk can be found in time.

4. By adopting the method, the report prompt area is processed to obtain the sub report to be confirmed, so that the workload of report editors can be reduced, and the problem of inaccurate confirmation content caused by wrong editing operation when the content of the report prompt area is directly confirmed is avoided.

5. By adopting the method, the editing terminal which needs to be transmitted by the sub-report to be confirmed is confirmed according to the association degree of the table editor about the first sub-report to be confirmed, so that the first sub-report to be confirmed can be more accurately generated to the editing terminal of the report editor with error editing operation.

6. By adopting the method, the first sub report to be confirmed is sent to the second editing terminal, so that a multi-level confirmation and feedback mechanism can be realized, and the communication efficiency and quality are improved. And meanwhile, the first confirmation result can be verified and processed according to the second confirmation result of the second editing terminal, so that the editing quality and accuracy of the report can be more accurately ensured.

Drawings

FIG. 1 is a schematic diagram of a first flow chart of a report processing method based on a formula engine according to an embodiment of the present application;

FIG. 2 is a schematic view of a report processing method based on a formula engine according to an embodiment of the present application;

FIG. 3 is a schematic diagram of a second flow chart of a report processing method based on a formula engine according to an embodiment of the present application;

FIG. 4 is a third flow diagram of a report processing method based on a formula engine according to an embodiment of the present application;

FIG. 5 is a schematic diagram of a report processing device based on a formula engine according to an embodiment of the present application;

fig. 6 is a schematic structural diagram of an electronic device according to an embodiment of the present application.

Reference numerals: 501. a report acquisition unit; 502. a risk acquisition unit; 503. a report generation unit; 504. report sending unit; 505. a report updating unit; 600. an electronic device; 601. a processor; 602. a communication bus; 603. a user interface; 604. a network interface; 605. a memory.

Detailed Description

In order to make the technical solutions in the present specification better understood by those skilled in the art, the technical solutions in the embodiments of the present specification will be clearly and completely described below with reference to the drawings in the embodiments of the present specification, and it is obvious that the described embodiments are only some embodiments of the present application, but not all embodiments.

In the description of embodiments of the present application, words such as "exemplary," "such as" or "for example" are used to mean serving as an example, instance, or illustration. Any embodiment or design described herein as "illustrative," "such as" or "for example" is not necessarily to be construed as preferred or advantageous over other embodiments or designs. Rather, the use of words such as "illustratively," "such as" or "for example," etc., is intended to present related concepts in a concrete fashion.

In the description of the embodiments of the present application, the term "plurality" means two or more unless otherwise indicated. For example, a plurality of systems means two or more systems, and a plurality of screen terminals means two or more screen terminals. Furthermore, the terms "first," "second," and the like, are used for descriptive purposes only and are not to be construed as indicating or implying relative importance or implicitly indicating an indicated technical feature. Thus, a feature defining "a first" or "a second" may explicitly or implicitly include one or more such feature. The terms "comprising," "including," "having," and variations thereof mean "including but not limited to," unless expressly specified otherwise.

The enterprise report mainly comprises a financial report, a sales report and a human resource report. Financial statement: the financial statement is utilized by the enterprise accounting personnel to summarize, analyze and evaluate the financial status and performance of the enterprise to aid in enterprise business decisions. Sales report: sales personnel track sales data using sales reports, and learn sales performance and trends for targeting, strategic planning, and sales strategy optimization. Human resource report form: the human resources department uses human resources report forms to manage staff information, track performance, evaluate staff satisfaction, job departure rate and the like so as to conduct human resources planning and decision. The enterprise can also set specific business reports according to the business types of the enterprise, so that the enterprise is applicable to different business scenes.

In the embodiment of the application, the application scene of the enterprise report covers various aspects of enterprise operation, and enterprises can better understand the financial condition of the enterprises through the report data, improve the sales strategy and optimize the human resource allocation, so that the operation efficiency and the market competitiveness of the enterprises are improved.

The embodiment of the application provides a report processing method based on a formula engine, which is applied to a server, as shown in fig. 1, and comprises steps S1-S5.

S1, obtaining editing results of a plurality of report editors on an initial report template to obtain a first report.

In the embodiment of the application, the editing terminal can comprise mobile equipment such as a personal computer, a tablet personal computer and a smart phone, and the equipment is provided with corresponding editing software and tools, so that the requirements of report editors on report editing, confirmation and feedback can be met. In addition, the editing terminal can also comprise professional report editing software or a system, and the software or the system provides more professional report editing functions and tools and can more efficiently edit and process the report. The application only provides the types and the characteristics of the editing terminal by way of example, and the types used by report editors are not limited.

Specifically, the server issues the initial report template to the editing terminals of a plurality of report editors, and the plurality of report editors fill in each area of the initial report template on line through the editing terminals to obtain a first report. In the embodiment of the application, the initial report template has a plurality of report editing areas, and each area only needs to be filled in by a single report editing personnel in practice. However, because the number of report editing areas of the initial report template is large, errors in filling content or errors in filling quantity and the like are easy to occur in the filling process.

S2, acquiring a plurality of report prompt areas from the first report according to the editing actions of report editors, wherein the report prompt areas are report editing areas with error editing risks in the first report.

In this embodiment of the present application, other data such as editing actions and editing frequency data in this embodiment of the present application may be processed according to a preset formula engine, where the formula engine includes software components such as Microsoft Excel, google texts, apache POI, jexcelApi, and the like, and in this embodiment of the present application, selection of the formula engine is not specifically limited. Specifically, after the first report is acquired by the formula engine through a preset formula, the required data is pulled, including the editing action of report editors, the editing frequency data, the information of the report editors and the like.

For example, when the report editor fills in the initial report template through the editing terminal, for the report editor, by capturing the operation sequence of the cursor, pointer operation, etc. or the operation of revising, deleting, etc. the report editing area, the report editing area with the error editing risk in the first report is judged by pulling the data generated by the editing action through the preset formula engine.

In one possible implementation manner, a plurality of report prompt areas are obtained from the first report according to the editing action of the report editor, and the method specifically includes steps S21-S22.

S21, the number of editors in any one first report area is obtained from the first report.

S22, when the number of editors is greater than or equal to the number of preset editors, determining the first report area as a report prompt area; and simultaneously, acquiring a first association area of the first report area, and determining the first association area as a report prompt area.

In the embodiment of the present application, as shown in fig. 2, in the first report area D3, the number of people who have performed editing operation on the first report area D3 is queried; in this embodiment of the present application, the server may obtain the identifier of each editing terminal that has performed the editing operation on the first report area D3, so as to obtain the number of editors in the first report area. For example, when the number of preset editors is 2, when the number of editors in the first report area is 2, the first report area is determined as a report prompt area.

In the embodiment of the present application, the first association area of the first report area may be set as an adjacent report area of the first report area. Illustratively, the first associated region of the first reporting region D3 includes C2, C3, C4, D2, D4, E2, E3, E4. Through the mode, the report prompt area comprises C2, C3, C4, D2, D3, D4, E2, E3 and E4.

In the embodiment of the application, when the first report area has the error editing operation edited by multiple persons, the possibility that the first association area of the first report area has the error editing operation is greatly improved when the person executes the editing operation of the first report area to have the error, so that the first association area of the first report area can be set as the adjacent report area of the first report area for checking together.

In one possible implementation manner, a plurality of report prompt areas are obtained from the first report according to the editing action of the report editor, and the method further comprises steps S23-S25.

S23, acquiring first report editor information of a first report area from the first report.

S24, when the number of editors is smaller than the number of preset editors, acquiring second report editors information of a second association area, wherein the second association area is a report area of the same row or the same column of the first report area.

In the embodiment of the present application, when the number of editors in the first report area D3 is 1, the number of editors is smaller than the number of preset editors; at this time, second report editor information of the second association area is acquired. In the embodiment of the present application, considering that in the report editing process, there is usually one row or one column edited by the same report editor, if in the D row of the first report, the report editor having a certain report area is different from those having other report areas, the report area is identified as a report prompt area.

And S25, when the second report editor information does not accord with the first report editor information, determining the first report area as a report prompt area.

Illustratively, in D1-D6, all areas except D3 are person A editions, and only the first report area D3 is person B editions, then the first report area D3 is identified as a report prompt area.

In the embodiment of the present application, there is also a case where, in a certain row of the first report, more than 1 report area is different from other report areas in the row. At this time, the plurality of report areas are all identified as report prompt areas.

And S3, processing the report prompt area to obtain the sub-report to be confirmed.

In a possible implementation manner, the report prompt area is processed to obtain the sub-report to be confirmed, which specifically includes steps S31-S32.

S31, respectively acquiring the header names of the report prompt areas.

S32, generating a plurality of sub-reports to be confirmed according to the head names of the report prompt areas, wherein the head names of the report prompt areas in any sub-report to be confirmed are the same.

In the embodiment of the application, the sub-report to be confirmed, in which the report prompt area is located, is determined by the same line name. In other embodiments, the same column names may be used for determining, and the present application is not limited specifically.

In the embodiment of the present application, for all report prompt areas acquired through step S2.

Specifically, header names of the report prompt areas are respectively acquired, namely report prompt areas in the same row or column are reclassified, so that a plurality of sub-reports to be confirmed are generated. In the embodiment of the application, for a single sub-report to be confirmed, the sub-report is generated by uniformly combining report areas of the same header, and is used for being sent to a corresponding editing terminal in a subsequent process.

Illustratively, as shown in fig. 2, the report areas in which the contents are displayed are all report prompt areas. Generating a plurality of sub-reports to be confirmed comprises the following steps: the first sub-report to be confirmed (C2, C3, C4, C6), the second sub-report to be confirmed (D2, D3, D4), the third sub-report to be confirmed (E2, E3, E4) and the fourth sub-report to be confirmed (F2, F3, F4, F6).

In one possible embodiment, the method further comprises: and when the main body editors of the two sub-reports to be confirmed are the same, merging the two sub-reports to be confirmed to obtain a new sub-report to be confirmed. The main body editor is the report editor with the most editing operation for each report area in the sub report to be confirmed.

And S4, processing report editor information of a report prompt area by adopting a preset formula engine so as to send the sub-report to be confirmed to the first editing terminal.

In a possible implementation manner, as shown in fig. 3, the preset formula engine is used to process the report editor information in the report prompt area, so as to send the sub-report to be confirmed to the first editing terminal, and specifically includes steps S41-S44.

S41, the sub-report to be confirmed comprises any first sub-report to be confirmed, and editing frequency data of each report area in the first sub-report to be confirmed, which is edited by a plurality of report editors, is obtained.

Illustratively, in the first sub-report to be confirmed (C2, C3, C4, C6), the report prompt area C2 is edited 1 time by personnel a, C3 is edited 1 time by personnel a and 1 time by personnel b, C4 is edited 1 time by personnel a and 1 time by personnel b, and C6 is edited 1 time by personnel C; the editing frequency data of the first sub report to be confirmed is obtained as follows: the personnel A edit frequency is 3, the personnel B edit frequency is 2, and the personnel C edit frequency is 1.

S42, processing the editing frequency data to obtain the association degree of any report editor with respect to the first sub-report to be confirmed.

S43, sorting the association degrees of the report editors from large to small to obtain a first report editor corresponding to the first association degree of the sorting.

In steps S42-S43, the association degree of each report editor with respect to the first sub-report to be confirmed may be obtained by weighting the total editing times by the editing frequency. In the above embodiment, the first report editor corresponding to the first relevance of the order is obtained as personnel a.

S44, the first sub-report to be confirmed is sent to a first editing terminal, and the first editing terminal is an editing terminal corresponding to the first report editor.

The first to-be-confirmed sub-report is sent to a first editing terminal of the personnel A.

In one possible embodiment, as shown in FIG. 4, the method further includes S45-S47.

S45, acquiring a second report editor with abnormal association according to the association of the report editors.

And S46, the first sub-report to be confirmed is sent to a second editing terminal, and the second editing terminal is an editing terminal corresponding to a second report editor.

In the embodiment of the application, the first person is the report editor with the highest editing frequency in the first sub-report to be confirmed (C2, C3, C4 and C6), and is the person with the highest possibility of correctly editing each report area in the first sub-report to be confirmed, and the correctly edited person is the person with editing authority in each report area in the first sub-report to be confirmed. At this time, the edit frequency of person b is inferior to person a. In order to improve accuracy of the verification result, the first sub report to be confirmed is sent to a second editing terminal corresponding to the person B.

S47, verifying the first confirmation result according to the second confirmation result of the second editing terminal.

S48, when the second confirmation result is identical to the first confirmation result in verification, updating the first report according to the first confirmation result.

Specifically, when the second confirmation result of the second editing terminal is displayed, the person B is not the correct editing person of the first sub-report to be confirmed; meanwhile, the first confirmation result shows that the first person is a correct editor of the first sub-report to be confirmed, and the updated first sub-report to be confirmed is returned to the server; at this time, since the second confirmation result is identical to the first confirmation result in verification, the first report may be updated according to the first confirmation result.

In one possible implementation manner, when the second confirmation result of the second editing terminal is displayed, the second person is the correct editing person of the first sub-report to be confirmed; meanwhile, the first confirmation result shows that the personnel A is not the correct editor of the first sub-report to be confirmed, and the first report can be updated according to the second confirmation result.

In one possible implementation manner, the method for obtaining the second report editor with abnormal association degree specifically includes: and respectively comparing the relevance of the report editors with a preset relevance threshold, and setting the report editors with relevance greater than or equal to the preset relevance threshold as second report editors with abnormal relevance.

And S5, updating the first report according to a first confirmation result of the sub-report to be confirmed, which is sent by the first editing terminal.

In a possible implementation manner, the first report is updated according to the first confirmation result of the sub-report to be confirmed sent by the first editing terminal, and specifically includes steps S51-S52.

S51, when the first editing terminal confirms that the report content of the sub-report to be confirmed has errors, an updated sub-report sent by the first editing terminal is obtained.

In the embodiment of the application, when the second editing terminal confirms that the report content of the sub-report to be confirmed has errors, the updated sub-report sent by the second editing terminal is obtained.

In one possible implementation manner, when the first editing terminal confirms that the report content of the sub-report to be confirmed has no error, the corresponding sub-report to be confirmed is reserved in the first report.

And S52, updating the corresponding content in the first report according to the updated sub-report.

Specifically, the corresponding content in the first report is updated to obtain a first revised report.

In the embodiment of the application, after the corrected report is acquired for a plurality of times, a corrected report database is obtained. And through the historical editing terminal, each corrected report in the corrected report library is associated, so that a server manager can inquire any corrected report in the corrected report library through keywords of report editors.

By adopting the above embodiments, the beneficial effects that can be achieved by the present application include one or more of the following:

The embodiment of the application provides a report processing device based on a formula engine, as shown in fig. 5. The device comprises a report acquisition unit 501, a risk acquisition unit 502, a report generation unit 503, a report transmission unit 504 and a report updating unit 505.

The report obtaining unit 501 is configured to obtain an editing result of the plurality of report editors on the initial report template, so as to obtain a first report.

The risk obtaining unit 502 is configured to obtain, according to an editing action of a report editor, a plurality of report prompt areas from the first report, where the report prompt areas are report editing areas where there is an error editing risk in the first report.

And the report generating unit 503 is configured to process the report prompting area to obtain a sub-report to be confirmed.

The report sending unit 504 is configured to process report editor information in the report prompt area by using a preset formula engine, so as to send the sub-report to be confirmed to the first editing terminal.

The report updating unit 505 is configured to update the first report according to the first confirmation result of the sub-report to be confirmed sent by the first editing terminal.

In one possible implementation manner, the risk obtaining unit 502 specifically includes a first data obtaining module and a first risk confirming module.

The first data acquisition module is used for acquiring the number of editors in any one first report area from the first report.

The first risk confirmation module is used for determining the first report area as a report prompt area when the number of editors is greater than or equal to the number of preset editors; and simultaneously, acquiring a first association area of the first report area, and determining the first association area as a report prompt area.

In one possible implementation, risk obtaining unit 502 further includes a second data obtaining module and a second risk confirmation module.

And the second data acquisition module is used for acquiring the first report editor information of the first report area from the first report.

The second risk confirmation module is used for acquiring second report editor information of a second association area when the number of editors is smaller than the preset number of editors, wherein the second association area is a report area in the same row or the same column of the first report area; and when the second report editor information does not accord with the first report editor information, determining the first report area as a report prompt area.

In one possible implementation manner, the report generating unit 503 is specifically configured to obtain header names of the report prompt areas respectively; and generating a plurality of sub-reports to be confirmed according to the names of the table heads of the report prompt areas, wherein the table head names of the report prompt areas in any one sub-report to be confirmed are the same.

In one possible implementation, the report sending unit 504 specifically includes a third data acquisition module, a data processing module, a first data comparison module, and a first report sending module,

The third data acquisition module is used for acquiring the editing frequency data of each report area in the first sub-report to be confirmed by a plurality of report editors, wherein the sub-report to be confirmed comprises any first sub-report to be confirmed.

And the data processing module is used for processing the editing frequency data to obtain the association degree of any report editor on the first sub-report to be confirmed.

And the first data comparison module is used for sequencing the relevancy of the report editors from large to small to obtain a first report editor corresponding to the relevancy of the first sequencing.

The first report sending module is used for sending the first sub report to be confirmed to the first editing terminal, and the first editing terminal is an editing terminal corresponding to the first report editor.

In one possible implementation, the report updating unit 505 specifically includes a content determining module and a content updating module.

And the content determining module is used for acquiring the updated sub-report sent by the first editing terminal when the first editing terminal confirms that the report content of the sub-report to be confirmed has errors.

And the content updating module is used for updating the corresponding content in the first report according to the updated sub-report.

In one possible implementation, the report sending unit 504 further includes a second data comparing module, a first report sending module, and a result verifying module.

The second data comparison module is used for acquiring second report editors with abnormal association degrees according to the association degrees of the plurality of report editors;

the report sending module is used for sending the first sub-report to be confirmed to a second editing terminal, wherein the second editing terminal is an editing terminal corresponding to a second report editor;

the result verification module is used for verifying the first confirmation result according to the second confirmation result of the second editing terminal; and when the second confirmation result is identical to the first confirmation result in verification, updating the first report according to the first confirmation result.

It should be noted that: in the device provided in the above embodiment, when implementing the functions thereof, only the division of the above functional modules is used as an example, in practical application, the above functional allocation may be implemented by different functional modules according to needs, that is, the internal structure of the device is divided into different functional modules, so as to implement all or part of the functions described above. In addition, the embodiments of the apparatus and the method provided in the foregoing embodiments belong to the same concept, and specific implementation processes of the embodiments of the method are detailed in the method embodiments, which are not repeated herein.

Referring to fig. 6, a schematic structural diagram of an electronic device is provided in an embodiment of the present application. As shown in fig. 6, the electronic device 600 may include: at least one processor 601, at least one network interface 604, a user interface 603, a memory 605, at least one communication bus 602.

Wherein the communication bus 602 is used to enable connected communications between these components.

The user interface 603 may include a Display screen (Display), a Camera (Camera), and the optional user interface 603 may further include a standard wired interface, a wireless interface.

The network interface 604 may optionally include a standard wired interface, a wireless interface (e.g., WI-FI interface), among others.

Wherein the processor 601 may include one or more processing cores. The processor 601 connects various portions of the overall server using various interfaces and lines, performs various functions of the server and processes data by executing or executing instructions, programs, code sets, or instruction sets stored in the memory 605, and invoking data stored in the memory 605. Alternatively, the processor 601 may be implemented in hardware in at least one of digital signal processing (Digital Signal Processing, DSP), field programmable gate array (Field-Programmable Gate Array, FPGA), programmable logic array (Programmable Logic Array, PLA). The processor 601 may integrate one or a combination of several of a central processing unit (Central Processing Unit, CPU), an image processor (Graphics Processing Unit, GPU), and a modem, etc. The CPU mainly processes an operating system, a user interface, an application program and the like; the GPU is used for rendering and drawing the content required to be displayed by the display screen; the modem is used to handle wireless communications. It will be appreciated that the modem may not be integrated into the processor 601 and may be implemented by a single chip.

The Memory 605 may include a random access Memory (Random Access Memory, RAM) or a Read-Only Memory (Read-Only Memory). Optionally, the memory 605 includes a non-transitory computer readable medium (non-transitory computer-readable storage medium). Memory 605 may be used to store instructions, programs, code, sets of codes, or sets of instructions. The memory 605 may include a stored program area and a stored data area, wherein the stored program area may store instructions for implementing an operating system, instructions for at least one function (such as a touch function, a sound playing function, an image playing function, etc.), instructions for implementing the various method embodiments described above, etc.; the storage data area may store data or the like involved in the above respective method embodiments. The memory 605 may also optionally be at least one storage device located remotely from the processor 601. As shown in FIG. 6, an operating system, network communication modules, user interface modules, and applications for enterprise report processing may be included in memory 605, which is a type of computer storage medium.

In the electronic device 600 shown in fig. 6, the user interface 603 is mainly used for providing an input interface for a user, and acquiring data input by the user; and processor 601 may be configured to invoke applications stored in memory 605 for enterprise report processing that, when executed by one or more processors, cause electronic device 600 to perform the methods described in one or more of the embodiments above.

It should be noted that, for simplicity of description, the foregoing method embodiments are all expressed as a series of action combinations, but it should be understood by those skilled in the art that the present application is not limited by the order of actions described, as some steps may be performed in other order or simultaneously in accordance with the present application. Further, those skilled in the art will also appreciate that the embodiments described in the specification are all preferred embodiments, and that the acts and modules referred to are not necessarily required in the present application.

In the foregoing embodiments, the descriptions of the embodiments are emphasized, and for parts of one embodiment that are not described in detail, reference may be made to related descriptions of other embodiments.

In the several embodiments provided herein, it should be understood that the disclosed apparatus may be implemented in other ways. For example, the apparatus embodiments described above are merely illustrative, such as the division of the units, merely a logical function division, and there may be additional manners of dividing the actual implementation, such as multiple units or components may be combined or integrated into another system, or some features may be omitted, or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed with each other may be through some service interface, device or unit indirect coupling or communication connection, electrical or otherwise.

The units described as separate units may or may not be physically separate, and units shown as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

In addition, each functional unit in each embodiment of the present application may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit. The integrated units may be implemented in hardware or in software functional units.

The integrated units, if implemented in the form of software functional units and sold or used as stand-alone products, may be stored in a computer readable memory. Based on such understanding, the technical solution of the present application may be embodied in essence or a part contributing to the prior art or all or part of the technical solution in the form of a software product stored in a memory, including several instructions for causing a computer device (which may be a personal computer, a server or a network device, etc.) to perform all or part of the steps of the method described in the embodiments of the present application. And the aforementioned memory includes: various media capable of storing program codes, such as a U disk, a mobile hard disk, a magnetic disk or an optical disk.

The foregoing is merely exemplary embodiments of the present disclosure and is not intended to limit the scope of the present disclosure. That is, equivalent changes and modifications are contemplated by the teachings of this disclosure, which fall within the scope of the present disclosure. Other embodiments of the disclosure will be apparent to those skilled in the art from consideration of the specification and practice of the disclosure. This application is intended to cover any adaptations, uses, or adaptations of the disclosure following, in general, the principles of the disclosure and including such departures from the present disclosure as come within known or customary practice within the art to which the disclosure pertains.

Claims

1. A report processing method based on a formula engine, the method comprising:

acquiring editing results of a plurality of report editors on an initial report template to obtain a first report;

according to the editing actions of report editors, a plurality of report prompt areas are obtained from the first report, wherein the report prompt areas are report editing areas with error editing risks in the first report;

processing the report prompt area to obtain a sub-report to be confirmed;

processing report editor information of the report prompt area by adopting a preset formula engine so as to send the sub-report to be confirmed to a first editing terminal;

And updating the first report according to a first confirmation result of the sub-report to be confirmed, which is sent by the first editing terminal.

2. The method according to claim 1, wherein the obtaining a plurality of report prompt areas from the first report according to the editing actions of the report editor specifically includes:

acquiring the number of editors in any one first report area from the first report;

when the number of editors is greater than or equal to the number of preset editors, determining the first report area as the report prompting area; and simultaneously, acquiring a first association area of the first report area, and determining the first association area as the report prompting area.

3. The method of claim 2, wherein the obtaining a plurality of report prompt areas from the first report according to the editing actions of the report editor further comprises:

acquiring first report editor information of the first report area from the first report;

when the number of editors is smaller than the number of preset editors, acquiring second report editors information of a second association area, wherein the second association area is a report area in the same row or the same column of the first report area;

And when the second report editor information does not accord with the first report editor information, determining the first report area as the report prompt area.

4. The method of claim 1, wherein the processing the report prompt area to obtain the sub-report to be confirmed specifically includes:

respectively obtaining the header names of a plurality of report prompt areas;

and generating a plurality of sub-reports to be confirmed according to the header names of the report prompt areas, wherein the header names of the report prompt areas in any one of the sub-reports to be confirmed are the same.

5. The method of claim 1, wherein the processing the report editor information in the report prompt area by using a preset formula engine to send the sub-report to be confirmed to a first editing terminal specifically includes:

the sub-report to be confirmed comprises any one first sub-report to be confirmed, and editing frequency data of each report area in the first sub-report to be confirmed, which are edited by a plurality of report editors, is obtained;

processing the editing frequency data to obtain the association degree of any report editor with respect to the first sub-report to be confirmed;

Sorting the association degrees of a plurality of report editors from large to small to obtain a first report editor corresponding to the first association degree of the sorting;

and sending the first sub-report to be confirmed to the first editing terminal, wherein the first editing terminal is an editing terminal corresponding to the first report editor.

6. The method of claim 1, wherein updating the first report according to the first confirmation result of the sub-report to be confirmed sent by the first editing terminal specifically includes:

when the first editing terminal confirms that the report content of the sub-report to be confirmed has errors, acquiring an updated sub-report sent by the first editing terminal;

and updating the corresponding content in the first report according to the updated sub-report.

7. The method of claim 5, further comprising;

acquiring a second report editor with abnormal association according to the association of a plurality of report editors;

the first sub-report to be confirmed is sent to a second editing terminal, and the second editing terminal is an editing terminal corresponding to the second report editing personnel;

Verifying the first confirmation result according to the second confirmation result of the second editing terminal;

and when the second confirmation result is identical to the first confirmation result in verification, updating the first report according to the first confirmation result.

8. The report processing device based on the formula engine is characterized by comprising a report acquisition unit, a risk acquisition unit, a report generation unit, a report sending unit and a report updating unit;

the risk obtaining unit is used for obtaining a plurality of report prompt areas from the first report according to the editing actions of report editors, wherein the report prompt areas are report editing areas with error editing risks in the first report;

the report sending unit is used for sending the sub-report to be confirmed to a first editing terminal according to the report editor information of the report prompt area;

9. An electronic device comprising a processor, a user interface, a network interface, and a memory, the memory for storing instructions, the user interface and the network interface for communicating to other devices, the processor for executing the instructions stored in the memory to cause the electronic device to perform the method of any of claims 1-7.

10. A computer readable storage medium storing instructions which, when executed, perform the method of any one of claims 1-7.