Report construction system, method and device, readable storage medium and program product

Abstract

The invention relates to a report construction system, method and device, a readable storage medium and a program product. The system comprises a configuration layer, a data layer and a display layer, and the configuration layer is used for configuring report parameters of a target report according to report construction requirements; the data layer is used for responding to triggering of report generation operation and analyzing the configured report parameters to obtain parameter analysis values; and the display layer is used for generating a target report according to the parameter analysis value and displaying the target report. The system can improve report construction efficiency.

Description

Technical Field

[0001] The present application relates to the field of report computer technology, and in particular to a report building system, method, computer device, computer readable storage medium and computer program product. Background Art

[0002] With the continuous development of Internet technology, the amount of data generated in daily production work is increasing. When faced with a large amount of data in terms of quantity and type, reports have become the preferred way to summarize data information and display data analysis results. Among them, tax reports are reports that enterprises submit to the tax department to report their tax status in accordance with the requirements of the national tax department. The requirements for filling out tax reports are higher than those for filling out ordinary reports.

[0003] In the related art, report styles are directly designed, report data sources and cell associations are configured on a web (World Wide Web)-like Excel (Microsoft Office Excel) tool, and then interactive reports are generated on the web. However, this way of generating reports puts too much pressure on the browser's performance and is prone to performance bottlenecks, resulting in low report generation efficiency. Summary of the invention

[0004] Based on this, it is necessary to provide a report building system, method, computer device, computer readable storage medium and computer program product that can improve report generation efficiency in response to the above technical problems.

[0005] In a first aspect, the present application provides a report building system, the system comprising a configuration layer, a data layer and a presentation layer, wherein:

[0006] The configuration layer is used to configure the report parameters of the target report according to the report building requirements;

[0007] The data layer is used to parse the configured report parameters in response to triggering the report generation operation to obtain parameter parsing values;

[0008] The presentation layer is used to generate and display a target report according to the parameter parsing value.

[0009] In one of the embodiments, the configuration layer is further used to determine a corresponding report configuration template according to the report building requirements, and configure the overall parameters and cell parameters of the target report based on the report configuration template.

[0010] In one of the embodiments, the configuration layer is also used to configure the number of headers, the header level, and the attributes of each header in the report configuration template to obtain header configuration information, configure the attributes of the body cells in the report configuration template to obtain cell configuration information, and configure the association relationship between the header configuration information and the cell configuration information.

[0011] In one of the embodiments, the data layer is also used to obtain the calculation rules of the target cell in the configured report parameters, and based on the address parameters in the configured report parameters, to obtain the candidate cell values ​​involved in the calculation rules, and to obtain the target cell value based on the calculation rules and the candidate cell values.

[0012] In one of the embodiments, the data layer is also used to parse the style parameters in the dynamic row configuration parameters to obtain the style parameter values ​​of the reference dynamic row, copy the style parameter values ​​of the reference dynamic row to obtain the target number of style parameter values ​​in the dynamic row configuration parameters, and associate the target number of style parameter values ​​with the row cell parameter values ​​and the table header in the dynamic row configuration parameters to obtain the dynamic row parameter values.

[0013] In one of the embodiments, the presentation layer is further used to obtain operation data in response to an operation trigger on a target report;

[0014] The data layer is also used to verify the operation data according to preset operation rules to obtain a verification result;

[0015] The display layer is also used to display the operation result corresponding to the operation data if the verification result satisfies the preset operation rule; if the verification result does not satisfy the preset operation rule, generate an operation prompt according to the preset operation rule and display the operation prompt.

[0016] In one of the embodiments, the data layer is further used to compress the parameter resolution value to obtain a compressed parameter resolution value, and send the compressed parameter resolution value to the presentation layer.

[0017] The above-mentioned report building system configures the report parameters of the target report according to the report building requirements through the configuration layer. The data layer responds to the triggering of the report generation operation, parses the configured report parameters, and obtains the parsed parameter values. The display layer generates and displays the target report according to the parameter parsing values. It can realize the separation of various links such as report parameter configuration, parameter parsing and front-end display, which is convenient for optimizing and expanding any link. Each link runs independently, which can improve the system operation efficiency and flexibility, thereby improving the report generation efficiency. At the same time, it can realize personalized expansion of each link and improve the scalability of the system.

[0018] In a second aspect, the present application also provides a report construction method, comprising:

[0019] Configure the report parameters of the target report according to the report building requirements;

[0020] In response to triggering a report generation operation, the configured report parameters are parsed to obtain parameter parsing values;

[0021] Generate and display the target report based on the parameter parsing value.

[0022] In a third aspect, the present application further provides a computer device, including a memory and a processor, wherein the memory stores a computer program, and when the processor executes the computer program, the steps of the report building method provided in the second aspect are implemented.

[0023] In a fourth aspect, the present application further provides a computer-readable storage medium having a computer program stored thereon, and when the computer program is executed by a processor, the steps of the report building method provided in the second aspect are implemented.

[0024] In a fifth aspect, the present application further provides a computer program product, including a computer program, which, when executed by a processor, implements the steps of the report building method provided in the second aspect.

[0025] The above-mentioned report building method, computer device, computer-readable storage medium and computer program product configure the report parameters of the target report according to the report building requirements, parse the configured report parameters in response to the triggering of the report generation operation, obtain the parameter analysis value, generate and display the target report according to the parameter analysis value, and can decouple the report parameter configuration from the parameter analysis and front-end display, reduce the coupling degree of the report parameter configuration from the parameter analysis and display, that is, the report parameter configuration from the parameter analysis and the front-end display can be implemented through different components respectively, thereby improving the report generation efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0026] In order to more clearly illustrate the technical solutions in the embodiments of the present application or related technologies, the drawings required for use in the embodiments of the present application or related technical descriptions will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other related drawings can be obtained based on these drawings without paying creative work.

[0027] Figure 1 A schematic diagram of the structure of a report building system in one embodiment;

[0028] Figure 2 It is a schematic diagram of parsing report parameters by the data layer in one embodiment;

[0029] Figure 3 A schematic diagram of parsing dynamic row configuration parameters at the data layer in one embodiment;

[0030] Figure 4 A schematic diagram of the structure of a report building system in another embodiment;

[0031] Figure 5 A flowchart of a report building method in one embodiment;

[0032] Figure 6 FIG. 4 is a diagram showing the internal structure of a computer device in one embodiment. DETAILED DESCRIPTION

[0033] In order to make the purpose, technical solution and advantages of the present application more clearly understood, the present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.

[0034] In some exemplary embodiments, Figure 1 As shown, the report building system includes a configuration layer 100, a data layer 200 and a presentation layer 300, wherein:

[0035] Configuration layer 100, used to configure report parameters of the target report according to report building requirements;

[0036] The data layer 200 is used to parse the configured report parameters and obtain parameter parsing values ​​in response to triggering the report generation operation;

[0037] The presentation layer 300 is used to generate and display a target report according to the parameter parsing value.

[0038] The configuration layer 100 can achieve data communication with the data layer 200, and the data layer 200 can achieve data communication with the display layer 300. Alternatively, the configuration layer 100 can send the configured report parameters to the data layer 200, the data layer 200 can send the parameter parsing value to the display layer 300, and the display layer 300 can synchronize the data obtained from the display interface to the data layer 200. The configuration layer 100 can include a display interface, and the display interface included in the configuration layer 100 can be used to configure the report parameters. The display layer 300 also includes a display interface, and the display interface included in the display layer 300 can be used to display the generated target report.

[0039] Optionally, report building requirements refer to requirements for building a target report. Report building requirements may include report style requirements and report function requirements. Report style requirements include, for example, the number of sub-tables included in the report, report size, cell format, and cell layout, etc. Report function requirements include, for example, whether to include dynamic rows, whether cells are hidden, hyperlinks, drop-down items, etc. Report building requirements may be compiled by developers or users based on the reports to be built. Report building requirements may include overall report requirements and report cell requirements, etc. Correspondingly, report parameters may include overall report parameters and cell parameters. It should be noted that there is no specific limitation on the method for obtaining report building requirements.

[0040] Report parameters are a general term for the parameters of the report to be constructed. Report parameters are used to characterize the properties of the report to be constructed. The target report refers to the report that needs to be constructed. Report parameters may include, for example, report configuration templates, report style rules, calculation rules, verification rules, dynamic row rules, and cell types. Among them, the report configuration template is a pre-set report template, and the configuration of the corresponding report parameters can be quickly implemented based on the report configuration template. Report style rules refer to rules that characterize the report style, such as cell font color, fill color, or cell line style. Calculation rules refer to the calculation rules for cell values, verification rules refer to the rules for verifying preset conditions, dynamic row rules refer to the rules related to setting dynamic rows, and cell types include, for example, regular cells, hyperlink cells, drop-down boxes, pop-ups, and other different types of cells.

[0041] Optionally, the configuration layer 100 can obtain the report building requirements in response to the triggering of the report configuration request, and configure the report parameters of the target report according to the report building requirements to obtain the configured report parameters, and transmit the configured report parameters to the data layer 200. The data layer 200 parses the configured report parameters in response to the triggering of the report generation operation to obtain the parameter parsing value, and the data layer 200 transmits the parameter parsing value to the display layer 300. The display layer 300 renders and generates the target report according to the parameter parsing value and displays it. Among them, the report generation operation refers to the operation that triggers the parsing of the configured report parameters, such as clicking the report generation control, or importing the configured report parameters, etc. For example, in the tax report filling system, the value-added tax business filling section imports the configured report parameters, which triggers the data layer to parse the report parameters, obtain the parameter parsing value, and send the parameter parsing value to the display layer 300, and the display layer 300 renders the report to generate the target report and display it. That is, the decoupling between the configuration layer 100 and the data layer 200 and the display layer 300 can be achieved.

[0042] Exemplarily, the configuration layer 100 can be implemented through the SpreadJS component or other self-developed platforms, where SpreadJS is a pure front-end table control based on HTML5, which combines grid functions and spreadsheet functions to provide a complete Excel-like experience. Whether it is a table, pivot table, table worksheet, or form controls, charts, floating objects, shapes, etc. for data input forms, SpreadJS can support it well. The data layer 200 can be implemented by a data calculation engine, which is a component or framework used in a computer system to perform data calculation tasks. The presentation layer 300 can be implemented by the React front-end framework, which is a JavaScript developed and maintained by Facebook for building user interfaces (often referred to as a front-end framework, which is actually a library). It enables developers to build component-based, reusable UI components, making the code more modular and maintainable.

[0043] In an optional application scenario, the configuration layer 100 configures the report parameters of the target report according to the report building requirements, such as configuring the cell calculation formula, style rules, verification rules, etc. The configuration layer 100 can associate the configured report parameters with the cells according to the cell identifier, that is, the calculation formula, style rules, verification rules, etc. corresponding to each cell in the target report can be obtained. The report parameters configured by the configuration layer 100 can be saved in the database corresponding to the configuration layer 100. For example, they can be saved based on the identifier of the target report, that is, the database corresponding to the configuration layer 100 can save the configuration parameters of multiple different target reports. In response to the triggering of the report generation operation, the data layer 200 obtains the report parameters configured by the configuration layer 100, and parses the configured report parameters to obtain the parameter parsing values. Among them, the parameter parsed value may include the cell value calculated according to the cell calculation formula and the report parameters after format conversion. The data layer 200 can convert the report parameters of the first format configured by the configuration layer 100 into report parameters of the second format that can be recognized by the display layer 300. The display layer 300 parses the report parameters of the second format, performs report rendering, generates a target report, and displays the target report on the display interface.

[0044] The report building system in the above embodiment configures the report parameters of the target report according to the report building requirements through the configuration layer, and parses the configured report parameters in response to the triggering of the report generation operation through the data layer to obtain the parameter analysis value, and generates and displays the target report according to the parameter analysis value through the display layer. It is possible to realize report parameter configuration, report parameter analysis and report display in different layers respectively, realize the decoupling of report parameter configuration, report parameter analysis and report display, and improve the report generation efficiency; in addition, it is convenient to expand the corresponding functions on the configuration layer, data layer and display layer respectively, so as to improve the scalability of the system. For the two-opening scenario, it is sufficient to directly carry out the corresponding expansion on the reserved interface, thus avoiding the modification of the original code of the system and reducing the maintenance cost.

[0045] In some embodiments, the configuration layer 100 is further used to determine a corresponding report configuration template according to report building requirements, and configure overall parameters and cell parameters of the target report based on the report configuration template.

[0046] Among them, the report configuration template is a pre-set configuration template. Multiple report configuration templates can be pre-set according to common application scenarios, and then the corresponding report configuration template can be selected according to the report building requirements, and the report parameters of the target report can be configured based on the selected report configuration template. Report parameters can include overall parameters and cell parameters. Overall parameters refer to the overall style parameters of the target report, for example, the number of sub-tables and sub-table addresses of the target report. The target report can include multiple sub-tables, and multiple sub-tables are spliced ​​with the main table to form the target report; cell parameters can include cell type, cell style parameters, cell value parameters, etc.

[0047] Optionally, the configuration layer 100 can select a report configuration template that matches the report building requirements from the template library, and then configure the overall parameters and cell parameters of the report based on the report configuration template. In other words, the configuration layer 100 can modify the overall parameters and cell parameters on the report configuration template based on the selected report configuration template according to the report building requirements, for example, the overall parameters and cell parameters in the report configuration template can be changed, added or deleted to obtain the configured report parameters.

[0048] In this embodiment, the configuration layer determines the corresponding report configuration template according to the report building requirements, and configures the overall parameters and cell parameters of the target report based on the report configuration template, that is, the report parameters are configured based on the preset report configuration template, which can improve the configuration efficiency of the report parameters.

[0049] In some embodiments, the configuration layer 100 is also used to configure the number of headers, the header level, and the attributes of each header in the report configuration template to obtain header configuration information, configure the attributes of the body cells in the report configuration template to obtain cell configuration information, and configure the association between the header configuration information and the cell configuration information.

[0050] Among them, the report cell may include a header cell and a body cell, and correspondingly, the cell parameters may include the header configuration information of the header cell and the cell configuration information of the body cell. The header configuration information may include the number of headers, the header level, and the attribute information of each header cell. The attribute information of the header cell may include information such as the header cell identifier, cell style, and cell value. The body cell configuration information of the body cell may include the attribute information of the body cell, and the attribute information of the body cell may include information such as the cell identifier, cell style, cell type, and cell value. It can be understood that the attribute information of the header cell is similar to the attribute information of the body cell, and both can be characterized by the attribute information of the cell. Among them, the number of headers includes the number of main tables and sub-tables, and the header level includes, for example, a first-level header, a second-level header, a third-level header, and the like.

[0051] In actual application scenarios, the configuration layer 100 can associate the header configuration information and the cell configuration information during the process of configuring the header configuration information and the cell configuration information, that is, the header configuration information is made to correspond to the cell configuration information to obtain the corresponding sub-table. Exemplarily, an association relationship can be added to both the header configuration information and the table configuration information, so that when the presentation layer 300 is rendered, the header and body cells corresponding to the same report can be clearly determined.

[0052] For example, Figure 2 As shown, the configuration layer 100 can send report parameters in JSON format to the data layer 200, and the data layer 200 parses the report parameters in JSON format, wherein the header configuration information in the report parameters is parsed to obtain the header configuration information that can be recognized by the display layer 300, that is, it is parsed into a header tree structure that can be recognized by the display layer 300, and the corresponding first-level header information, second-level header information, and third-level header information are obtained. Then, the cell configuration information of the table body cells in the report is parsed to obtain the cell information that can be recognized by the display layer 300. Each row (Row) of the report can include multiple cells, and the cell information of each cell can include cell identification, cell style information, and cell type information. It is easy to understand that the information displayed by the display layer 300 is consistent with the report parameters configured by the configuration layer 100.

[0053] In this embodiment, the number of headers, the header level, and the attributes of each header in the report configuration template are configured through the configuration layer to obtain the header configuration information, the attributes of the body cells in the report configuration template are configured to obtain the cell configuration information, and the association between the header configuration information and the cell configuration information is configured, so as to obtain more accurate report configuration parameters.

[0054] In some embodiments, the data layer 200 is also used to obtain the calculation rules of the target cell in the configured report parameters, and based on the address parameters in the configured report parameters, to obtain the candidate cell values ​​involved in the calculation rules, and to obtain the target cell value based on the calculation rules and the candidate cell values.

[0055] The report parameters configured by the configuration layer 100 include calculation rules for cell values. Any cell in the constructed target report can be used as the target cell. Each cell has a corresponding calculation rule, which is used to calculate the value of the corresponding cell. The address parameter refers to the data access address of the corresponding cell, such as accessing data from a database or memory, and the corresponding data access address is the corresponding database or memory.

[0056] Optionally, when the data layer 200 parses the report parameters corresponding to the target cell, it obtains the calculation rules in the report parameters, and the calculation rules may involve extracting numbers from the candidate cells. Then, based on the address parameters in the report parameters corresponding to the candidate cells, the candidate cells are extracted to obtain the candidate cell values, and the target cell values ​​are calculated according to the calculation rules and all the candidate cell values ​​involved in the calculation rules. Exemplarily, the calculation rule corresponding to the target cell is A+B, where A is the value of candidate cell A and B is the value of candidate cell B. Then, according to the address parameters corresponding to candidate cell A, number A is extracted, and according to the address parameters corresponding to candidate cell B, number B is extracted, and according to the calculation rules and A and B, the target cell values ​​are obtained. It can be understood that the candidate cells can also obtain the candidate cell values ​​based on the corresponding calculation rules, and then participate in the calculation of the target cell values. The implementation process of the candidate cells obtaining the candidate cell values ​​based on the corresponding calculation rules can refer to the implementation process of the target cell obtaining the target cell values ​​according to the corresponding calculation rules.

[0057] Optionally, after obtaining the value of the target cell, the report parameter corresponding to the target cell may be converted into a format to obtain a format recognizable by the presentation layer 300 .

[0058] In this embodiment, the calculation rules of the target cells in the configured report parameters are obtained through the data layer, and based on the address parameters in the configured report parameters, the candidate cells involved in the calculation rules are retrieved to obtain the candidate cell values, and the target cell values ​​are obtained according to the calculation rules and the candidate cell values. This enables the configured calculation rules and number-retrieval rules to be used to calculate the cell values ​​and obtain complete report data, thereby improving the accuracy of report construction.

[0059] In an exemplary embodiment, the data layer 200 is also used to parse the style parameters in the dynamic row configuration parameters to obtain the style parameter values ​​of the reference dynamic row, copy the style parameter values ​​of the reference dynamic row to obtain the target number of style parameter values ​​in the dynamic row configuration parameters, and associate the target number of style parameter values ​​with the row cell parameter values ​​and headers in the dynamic row configuration parameters to obtain the dynamic row parameter values.

[0060] The configured report parameters include dynamic row configuration parameters, which may include style parameters of dynamic rows, row cell parameter values, number of dynamic rows, dynamic row addresses, etc. The row cell parameter values ​​in the dynamic row configuration parameters refer to the values ​​of cells corresponding to the dynamic rows, the dynamic row addresses may include row addresses of the number of dynamic rows, and the reference dynamic rows are reference rows used to characterize the style of the dynamic rows.

[0061] Exemplarily, the data layer 200 parses the style parameters in the dynamic row configuration parameters to obtain the style parameter value of the reference dynamic row, which includes one row. If the style parameter value of the reference dynamic row is rendered through the display layer 300, one dynamic row can be displayed. The data layer 200 copies the style parameter value of the reference dynamic row to obtain the target number of style parameter values, where the target number refers to the number of dynamic rows corresponding to the dynamic row configuration parameters, and then associates the style parameter value of the target number with the row cell parameter value and the table header in the dynamic row configuration parameters to obtain the dynamic row parameter value. The obtained dynamic row parameter value can be regarded as the parameter value of a subtable, and multiple different dynamic row parameter values ​​can correspond to the same table header.

[0062] In an alternative example, Figure 3 As shown, the data layer 200 is used to parse the dynamic row configuration parameters, parse and obtain the style parameter value of the reference dynamic row based on the style parameters in the dynamic row configuration parameters, copy the style parameter value of the reference dynamic row, obtain the style parameter value of the target number in the dynamic row configuration parameters, associate the style parameter value of the target number with the corresponding row cell parameter value and the table header, and obtain the dynamic row parameter value. The dynamic row parameter value can generate a subtable structure, but the table header and the table body may be separated in actual display. In addition, the data layer 200 can also perform other processing on the configured report configuration template based on the business type corresponding to the target report, for example, setting pop-up windows, filter boxes, option drop-down boxes, check boxes, hyperlinks, and assigning default values ​​to cells, or personalizing the extended interface of the data layer 200, such as dynamically hiding rows and columns, highlighting cells, or hiding cells in specific scenarios. The data layer 200 can also generate risk warning information for report parameter parsing.

[0063] In this embodiment, the style parameters in the dynamic row configuration parameters are parsed through the data layer to obtain the style parameter values ​​of the reference dynamic row, the style parameter values ​​of the reference dynamic row are copied to obtain the style parameter values ​​of the target number in the dynamic row configuration parameters, and the style parameter values ​​of the target number are associated with the row cell parameter values ​​and the table header in the dynamic row configuration parameters to obtain the dynamic row parameter values, which can achieve fast parsing of the dynamic row configuration parameters and improve the parsing efficiency of the configuration parameters by the data layer.

[0064] In some embodiments, the display layer 300 is also used to obtain operation data in response to an operation trigger on a target report; the data layer 200 is also used to verify the operation data according to preset operation rules to obtain a verification result; the display layer 300 is also used to display the operation result corresponding to the operation data if the verification result satisfies the preset operation rules; if the verification result does not satisfy the preset operation rules, an operation prompt is generated according to the preset operation rules and the operation prompt is displayed.

[0065] The operation data refers to the data generated by operating the target report, and the operation on the target report usually refers to the operation of filling in the target report.

[0066] In an actual application scenario, the user fills in the numerical value of the constructed target report. The display layer 300 responds to the trigger of filling in the target report, obtains the operation data, and sends the operation data to the data layer 200. The data layer 200 verifies the operation data according to the preset operation rules to obtain the verification result. Among them, the preset operation rules can be configured by the configuration layer 100 when configuring the report parameters. The preset operation rules are used to characterize the report filling requirements. The data layer 200 sends the verification result to the display layer 300. If the verification result meets the preset operation rules, the display layer 300 displays the operation result corresponding to the operation data. If the verification result does not meet the preset operation rules, the display layer 300 generates an operation prompt according to the preset operation rules and displays the operation prompt. For example, if a user fills in text in a cell of a target report, and the preset operation rule corresponding to the cell is that only numerical values ​​can be filled in, the data layer 200 will obtain a verification result that does not meet the preset operation rules, and the display layer 300 will generate and display operation prompts according to the preset operation rules. For example, an operation prompt "Only numerical values ​​can be filled in here" may be displayed near the cell. The operation prompt refers to a prompt used to prompt the user to fill in the report according to the preset operation rules.

[0067] In this embodiment, the data layer responds to the operation trigger of the target report to obtain the operation data, and the data layer verifies according to the preset operation rules to obtain the verification result. If the verification result is that the preset operation rules are met, the display layer displays the operation result corresponding to the operation data. If the verification result is that the preset operation rules are not met, the operation prompt is generated and displayed according to the preset operation rules. This can achieve accurate and fast verification of the operation data, improve the user's reporting experience, and improve the efficiency of report operations.

[0068] In some embodiments, the data layer 200 is further used to compress the parameter resolution value to obtain a compressed parameter resolution value, and send the compressed parameter resolution value to the presentation layer.

[0069] In actual application scenarios, the data layer 200 parses the report parameters configured by the configuration layer 100 to obtain parameter parsed values, and sends the parameter parsed values ​​to the display layer 300 for rendering to generate a target report. The parameter parsed values ​​include style parameters and numerical parameters of each cell in the target report, and the amount of data is large. Therefore, the parameter parsed values ​​are compressed to obtain compressed parameter parsed values, and then the compressed parameter parsed values ​​are sent to the display layer 300.

[0070] In this embodiment, by compressing the parameter resolution value to obtain the compressed parameter resolution value, and sending the compressed parameter resolution value to the display layer, the data transmission pressure between the data layer and the display layer can be reduced, the data transmission speed can be increased, and thus the efficiency of building the target report can be improved.

[0071] In an exemplary embodiment, the structure diagram of the report building system is as follows: Figure 4 As shown, the report building system includes a configuration layer 100, a data layer 200 and a display layer 300. Among them, the configuration layer 100 can be implemented based on the web-side configuration tool SpreadJS. The configuration layer 100 can configure the report parameters offline or offline. The process of configuring the report parameters by the configuration layer 100 can usually be called the design period. The content configured by the configuration layer 100 can include report configuration templates, report style rules, calculation rules, verification rules, dynamic row rules, and cell types. The configuration layer 100 sends the configured report parameters to the data layer 200, and the data layer 200 parses the report parameters to obtain parameter parsing values. Based on the parameter parsing values, the report items can be obtained, and the calculations are performed based on the calculation rules corresponding to the report items to obtain the report item data. Based on the report item data, the personalized style processing can be further performed. The data layer 200 sends the parsed parameter parsing values ​​to the display layer 300, and the display layer 200 identifies and parses the parameter parsing values ​​and renders the target report. The data layer 200 and the presentation layer 300 can be run in an online state, and the corresponding running process of the data layer and the presentation layer can be called the running period. That is, the report parameters are configured in the design period, and the target report is generated in the running period.

[0072] The report building system in the above embodiment realizes corresponding functions through the configuration layer, data layer and display layer respectively. The report parameter configuration and parameter parsing and report rendering generation do not affect each other, which reduces the system coupling and does not cause performance pressure on the browser, and can improve system performance and report building efficiency. In addition, each layer can customize the extension interface to realize personalized processing logic and improve the scalability of the system. Complex report configuration can be realized through the configuration layer, and the data layer is parsed into a unified format that can be recognized by the display layer. The display layer renders the report corresponding to the configuration, which can improve the efficiency and accuracy of report building.

[0073] In an exemplary embodiment, Figure 5 As shown, a report construction method is provided, which includes the following steps 502 to 506. Among them:

[0074] Step 502: configure report parameters of the target report according to report building requirements.

[0075] Step 504: in response to triggering the report generation operation, the configured report parameters are parsed to obtain parameter parsed values.

[0076] Step 506: Generate and display a target report based on the parameter analysis value.

[0077] In the above report building method, by configuring the report parameters of the target report according to the report building requirements, in response to the triggering of the report generation operation, the configured report parameters are parsed to obtain the parameter parsed values, and the target report is generated and displayed according to the parameter parsed values. This can decouple the report parameter configuration from the parameter parsing and front-end display, and reduce the coupling degree of the report parameter configuration from the parameter parsing and display. That is, the report parameter configuration from the parameter parsing and front-end display can be implemented through different components respectively, thereby improving the report generation efficiency.

[0078] In an exemplary embodiment, step 502 of configuring report parameters of a target report according to report building requirements includes:

[0079] A corresponding report configuration template is determined according to the report building requirement, and overall parameters and cell parameters of the target report are configured based on the report configuration template.

[0080] In some embodiments, configuring the cell parameters of the target report based on the report configuration template includes:

[0081] The number of headers, the header level and the attributes of each header in the report configuration template are configured to obtain header configuration information; the attributes of the table body cells in the report configuration template are configured to obtain cell configuration information; and the association relationship between the header configuration information and the cell configuration information is configured.

[0082] In some embodiments, the step 504 of parsing the configured report parameters to obtain the parameter parsing values ​​includes:

[0083] Obtain the calculation rules of the target cell in the configured report parameters; based on the address parameters in the configured report parameters, extract the candidate cells involved in the calculation rules to obtain the candidate cell values; and obtain the target cell value according to the calculation rules and the candidate cell values.

[0084] In some embodiments, the report parameters include dynamic row configuration parameters; the step 504 of parsing the configured report parameters to obtain the parameter parsing values ​​includes:

[0085] The style parameters in the dynamic row configuration parameters are parsed to obtain style parameter values ​​of the reference dynamic row; the style parameter values ​​of the reference dynamic row are copied to obtain style parameter values ​​of a target number in the dynamic row configuration parameters; the style parameter values ​​of the target number are associated with row cell parameter values ​​and table headers in the dynamic row configuration parameters to obtain dynamic row parameter values.

[0086] In some embodiments, the above method further comprises:

[0087] In response to an operation trigger on a target report, operation data is obtained; the operation data is verified according to preset operation rules to obtain a verification result; if the verification result is that the preset operation rules are met, the operation result corresponding to the operation data is displayed; if the verification result is that the preset operation rules are not met, an operation prompt is generated according to the preset operation rules and the operation prompt is displayed.

[0088] It is easy to understand that the meanings of the terms and step descriptions in the above-mentioned report building method embodiments can refer to the explanations and descriptions of the corresponding terms and processing procedures in the aforementioned report building system embodiments, and the beneficial effects can also refer to the beneficial effects of the corresponding processing procedures in the aforementioned report building system embodiments.

[0089] It should be understood that, although the various steps in the flowcharts involved in the above-mentioned embodiments are displayed in sequence according to the indication of the arrows, these steps are not necessarily executed in sequence according to the order indicated by the arrows. Unless there is a clear explanation in this article, the execution of these steps does not have a strict order restriction, and these steps can be executed in other orders. Moreover, at least a part of the steps in the flowcharts involved in the above-mentioned embodiments can include multiple steps or multiple stages, and these steps or stages are not necessarily executed at the same time, but can be executed at different times, and the execution order of these steps or stages is not necessarily to be carried out in sequence, but can be executed in turn or alternately with other steps or at least a part of the steps or stages in other steps.

[0090] In an exemplary embodiment, a computer device is provided. The computer device may be a terminal, and its internal structure diagram may be as shown in FIG. Figure 6As shown. The computer device includes a processor, a memory, an input / output interface, a communication interface, a display unit and an input device. The processor, the memory and the input / output interface are connected through a system bus, and the communication interface, the display unit and the input device are connected to the system bus through the input / output interface. The processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The input / output interface of the computer device is used to exchange information between the processor and an external device. The communication interface of the computer device is used to communicate with an external terminal in a wired or wireless manner, and the wireless manner can be implemented through WIFI, a mobile cellular network, near field communication (NFC) or other technologies. When the computer program is executed by the processor, a report construction method is implemented. The display unit of the computer device is used to form a visually visible picture, which can be a display screen, a projection device or a virtual reality imaging device. The display screen can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer device can be a touch layer covering the display screen, or a button, trackball or touchpad set on the computer device shell, or an external keyboard, touchpad or mouse.

[0091] Those skilled in the art will understand that Figure 6 The structure shown in the figure is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.

[0092] In an exemplary embodiment, a computer device is provided, including a memory and a processor, wherein a computer program is stored in the memory, and the processor implements the steps of the above-mentioned report building method when executing the computer program.

[0093] In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored. When the computer program is executed by a processor, the steps of the above-mentioned report building method are implemented.

[0094] In one embodiment, a computer program product is provided, including a computer program, which implements the steps of the above report building method when executed by a processor.

[0095] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data used for analysis, stored data, displayed data, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties, and the collection, use and processing of relevant data must comply with relevant regulations.

[0096] A person of ordinary skill in the art can understand that all or part of the processes in the above-mentioned embodiment method can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to the memory, database or other medium used in the embodiments provided in the present application can include at least one of non-volatile memory and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive random access memory (ReRAM), magnetic random access memory (MRAM), ferroelectric random access memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. As an illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM). The database involved in each embodiment provided in this application may include at least one of a relational database and a non-relational database. Non-relational databases may include distributed databases based on blockchains, etc., but are not limited to this. The processor involved in each embodiment provided in this application may be a general-purpose processor, a central processing unit, a graphics processor, a digital signal processor, a programmable logic device, a data processing logic device based on quantum computing, an artificial intelligence (AI) processor, etc., but are not limited to this.

[0097] The technical features of the above embodiments may be combined arbitrarily. To make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this application.

[0098] The above-described embodiments only express several implementation methods of the present application, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the scope of the present application. It should be pointed out that, for a person of ordinary skill in the art, several variations and improvements can be made without departing from the concept of the present application, and these all belong to the protection scope of the present application. Therefore, the protection scope of the present application shall be subject to the attached claims.

Claims

1. A report building system, characterized in that: The system includes a configuration layer, a data layer and a presentation layer, wherein: The configuration layer is used to configure the report parameters of the target report according to the report building requirements; The data layer is used to parse the configured report parameters in response to triggering the report generation operation to obtain parameter parsing values; The presentation layer is used to generate and display a target report according to the parameter parsing value.

2. The report construction system according to claim 1, characterized in that: The configuration layer is also used to determine a corresponding report configuration template according to the report building requirements, and configure the overall parameters and cell parameters of the target report based on the report configuration template.

3. The report construction system according to claim 2, characterized in that: The configuration layer is also used to configure the number of headers, the header level and the attributes of each header in the report configuration template to obtain header configuration information, configure the attributes of the body cells in the report configuration template to obtain cell configuration information, and configure the association between the header configuration information and the cell configuration information.

4. The report building system according to claim 1, characterized in that: The data layer is also used to obtain the calculation rules of the target cells in the configured report parameters, and based on the address parameters in the configured report parameters, to obtain the candidate cell values ​​involved in the calculation rules, and to obtain the target cell values ​​based on the calculation rules and the candidate cell values.

5. The report construction system according to claim 1, characterized in that: The data layer is also used to parse the style parameters in the dynamic row configuration parameters to obtain the style parameter values ​​of the reference dynamic row, copy the style parameter values ​​of the reference dynamic row to obtain the target number of style parameter values ​​in the dynamic row configuration parameters, and associate the target number of style parameter values ​​with the row cell parameter values ​​and the table header in the dynamic row configuration parameters to obtain the dynamic row parameter values.

6. The report building system according to any one of claims 1 to 5, characterized in that: The presentation layer is also used to obtain operation data in response to an operation trigger on a target report; The data layer is also used to verify the operation data according to preset operation rules to obtain a verification result; The display layer is further used to display the operation result corresponding to the operation data if the verification result satisfies the preset operation rule; If the verification result is that the preset operation rule is not satisfied, an operation prompt is generated according to the preset operation rule and the operation prompt is displayed.

7. The report construction system according to any one of claims 1 to 5, characterized in that: The data layer is further used to compress the parameter parsing value to obtain a compressed parameter parsing value, and send the compressed parameter parsing value to the presentation layer.

8. A report construction method, characterized in that: The method comprises: Configure the report parameters of the target report according to the report building requirements; In response to triggering a report generation operation, the configured report parameters are parsed to obtain parameter parsing values; Generate and display the target report based on the parameter parsing value.

9. A computer device comprising a memory and a processor, wherein the memory stores a computer program, wherein: When the processor executes the computer program, the steps of the method according to claim 8 are implemented.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method according to claim 8 are implemented.

11. A computer program product, comprising a computer program, characterized in that When the computer program is executed by a processor, the steps of the method according to claim 8 are implemented.

Images