Experiment report generation system and method based on low-code platform

Abstract

This invention discloses an experiment report generation system and method based on a low-code platform. The system includes a layout rendering system and a business logic system. The layout rendering system is used by users to design and generate experiment reports through drag-and-drop components and renders them in real time. It includes a control module, a page rendering module, and a parameter setting module. The control module provides users with draggable visual components, including form controls and multi-dimensional table controls. The page rendering module renders and displays the experiment reports generated by dragging and dropping form controls and / or multi-dimensional table controls in real time within the visual development module of the low-code platform. The parameter setting module includes a parameter configuration unit, a data binding unit, and a formula selection unit. The business logic system includes a data extraction module and a formula calculation module. This invention ensures maximum fidelity to the experiment report template through multi-dimensional table controls and formula calculation controls, greatly shortening development time and reducing development costs.

Description

Technical Field

[0001] This invention belongs to the technical field of software development and application, specifically relating to an experiment report generation system and method based on a low-code platform. Background Technology

[0002] Developing enterprise-level (B2B) software using traditional development models requires multiple stages, including requirements analysis, design, coding, testing, and deployment, each consuming significant time and human resources. Furthermore, uncertainties such as requirement changes and technical challenges during development extend the development cycle and increase costs. Simultaneously, the complex code structure and large codebase make system maintenance and expansion exceptionally difficult. To overcome the inefficiencies of traditional development methods, low-code development platforms have emerged. The development of low-code development platforms stems primarily from the needs of enterprise (B2B) users for improved software development efficiency, cost control, and rapid response to market changes. A low-code development platform is an innovative development tool whose core feature is the ability to quickly generate applications with little or no coding. It employs a visual development method, allowing developers to easily create web and mobile applications through a graphical user interface, using drag-and-drop components and model-driven logic. This development approach significantly reduces the difficulty and barrier to entry, enabling more people to participate in application development.

[0003] While some mature form customization tools exist in the web development field, they are limited to general functional page-level development and are not suitable for laboratory logbooks in the metrology and testing industry. Laboratory logbooks in this industry focus more on the entry of experimental data, and experimental data has different testing parameters and judgment rules for different projects. Therefore, the requirements for dynamic drawing of embedded multi-dimensional tables and formula calculations in form data are extremely high. Existing technologies, such as LowCodeEngine's embedded tables, provide the function of visually configuring editable tables, but they can only configure single-dimensional tables and cannot support formula calculations for forms and embedded tables. If some complex functional requirements cannot be achieved through preset configurations, developers must intervene to modify the existing system to support them. Therefore, there is an urgent need for a low-code platform specifically for the metrology and testing industry to enable the rapid compilation of laboratory logbooks. Summary of the Invention

[0004] The main objective of this invention is to overcome the shortcomings and deficiencies of the prior art and provide an experimental report generation system and method based on a low-code platform. Addressing the issue that existing low-code platforms can only configure single-dimensional tables and cannot support form and embedded table formula calculations, this invention allows for the rapid creation of templates through drag-and-drop functionality and the creation of multi-dimensional tables through control modules. Furthermore, configuring calculation formulas automatically calculates data results and generates experimental reports.

[0005] To achieve the above objectives, the present invention adopts the following technical solution: On the one hand, an experimental report generation system based on a low-code platform is provided, including a layout rendering system and a business logic system; The layout rendering system is used by users to design and generate experimental reports through drag-and-drop components and render them in real time. It includes a control module, a page rendering module, and a parameter setting module. The control module provides users with draggable visual components, including form controls and multi-dimensional table controls. The page rendering module renders and displays the experimental reports generated by dragging and dropping form controls and / or multi-dimensional table controls in real time within the visual development module of a low-code platform. The parameter setting module includes a parameter configuration unit, a data binding unit, and a formula selection unit. The parameter configuration unit displays and configures the parameters of the selected form control or multi-dimensional table control. The data binding unit configures the database and corresponding data identifier to be bound to the selected form control or multi-dimensional table control. The formula selection module provides the calculation formula selected by the user. The business logic system includes a data extraction module and a formula calculation module. The data extraction module is used to obtain the business data corresponding to the selected form control or multidimensional table control based on the database bound by the data binding unit and the corresponding data identifier, and return the corresponding position. The formula calculation module is used to return the calculation result to the corresponding position of the selected form control or multidimensional table control based on the selected calculation formula and calculation data.

[0006] As a preferred technical solution, the form control includes layout components, basic components, advanced components, business components, and custom components; The layout components include a grid layout component and a hierarchical heading component; the grid layout component is used to place other components according to the layout settings; the hierarchical heading component is used to categorize the content of the entire form. The basic component contains multiple unit components within the form element; The advanced component comprises an advanced unit component composed of multiple unit components; The business component comprises a business unit component consisting of multiple unit components and advanced unit components; The custom component includes multiple user-defined custom unit components; The multidimensional table control is used to create basic tables and multidimensional tables, including cell controls and header controls; The cell control includes a cell rendering unit and a cell merging unit; the cell rendering unit is used to render different cell input and output types according to the cell type; the cell merging unit is used to perform two operations: data merging and style merging, or data separation and style separation, according to the cells selected by the user. The header control includes a header visualization editing unit and a header rendering unit; the header visualization editing unit is used to generate header data for a two-dimensional header based on the header data of multiple one-dimensional headers selected by the user; the header rendering unit is used to render the header based on the header data.

[0007] As a preferred technical solution, the multidimensional table control creates multidimensional tables based on a basic table, including creating a multidimensional header table and creating a multidimensional cell table. The creation of the multidimensional header table specifically involves: Based on the created base table, add one-dimensional table column data to the base table; Use header and cell controls to render a one-dimensional table from column data in a one-dimensional table. Configure the table header in the table header visual editing unit, and use the table header rendering unit to render the one-dimensional table column data into a one-dimensional table header display format; In the visual editing unit for table headers, select or click the table header to be edited. Add or delete table header levels according to the table header relationship of the selected table headers, and temporarily store the modified table header level data in the new table header editing data. After determining the new header editing data, the new header editing data is reorganized into a header structure and header according to the header hierarchy in the data, and pushed to the header rendering unit to be rendered into a multi-dimensional header table and the data is updated to the new form structure data; The specific steps for creating a multidimensional cell table are as follows: Store the data of several merged cells in the base table in the merged cell data; When the cell to be edited is selected by box selection or click in the multidimensional table control, the row and column data of the selected cell are combined into one or more data and stored in the cell merge data; When the multidimensional table control is rendered, the merged cell data is obtained. Based on the cell position data, cell row and column data in each data row, the merged cell data and the hidden data of the cells covered by the merged cells are calculated and pushed to the matched cells in the multidimensional table control for merging or hiding.

[0008] As a preferred technical solution, the parameters of the form control or multidimensional table control include the form control or multidimensional table control number, the form control or multidimensional table control name, the form control or multidimensional table control category, and the form control or multidimensional table control data type.

[0009] As a preferred technical solution, the data extraction unit, based on the database and corresponding data identifier bound by the data binding unit, obtains the business data corresponding to the data identifier of the selected form control or multidimensional table control from the database through the data link API interface, and feeds it back to the corresponding position of the selected form control or multidimensional table control. At the same time, it generates a data structure model through the form structure data.

[0010] As a preferred technical solution, the formula calculation module includes a formula editor and a formula calculator; the formula editor is used to edit and configure calculation formulas; the formula calculator is used to obtain calculation results based on the calculation formulas edited and configured by the formula editor.

[0011] As a preferred technical solution, the process of editing and configuring calculation formulas using the formula editor is as follows: Retrieve and display the calculation formulas from the formula library; Select the calculation formula that needs to be edited and configured and render it to the formula editing box, and provide calculation formula prompts; Retrieve the fields of the selected form control and / or multidimensional table control, and select the required fields as formula data to add to the calculation formula to obtain the final calculation formula.

[0012] As a preferred technical solution, the process by which the formula calculator obtains the calculation result is as follows: When a calculation formula is selected, the calculation formula is first matched with the formula library to obtain the actual calculation formula; Then, based on the data identifiers of the forms and / or tables selected by the user, the data extraction module is invoked to extract and calculate the data; Input the calculated data into the actual calculation formula to obtain the calculation result and return it to the corresponding position; When the user selects a table, the data extraction module is invoked based on the table's data identifiers to extract column data from the cells in the table as calculation data; When the user selects a form, the data extraction module is invoked based on the form's data identifier to extract the form data as calculation data. When the user selects a table and a form, the data extraction module is invoked based on the table's data identifier to extract column data from the cells in the table. At the same time, the data extraction module is invoked based on the form's data identifier to extract form data. The column data from the cells and the form data are then used as calculation data.

[0013] As a preferred technical solution, the system further includes an encoding extension module, which is used to configure hook events for form controls or multidimensional table controls using encoding methods, and includes an encoding editor and an encoding execution module; The coding editor is used to add corresponding code blocks in the hook events of form controls or multidimensional table controls; The encoding execution module is used to read and execute code blocks in the hook events of form controls or multidimensional table controls.

[0014] On the other hand, a method for generating experimental reports is provided, applied to the experimental report generation system based on the low-code platform, comprising the following steps: Determine the requirements for the experiment report; Based on the requirements of the experiment report, an experiment report template is designed and generated by dragging and dropping visual components in form controls and / or multidimensional table controls; the experiment report template is based on a combination of form templates and / or table templates; the table template includes a basic table template and a multidimensional table template; Configure the parameters of form controls and / or multi-dimensional table controls in the experiment report template in the parameter settings module; Use the data binding unit to bind the database and corresponding data identifiers of form controls and / or multidimensional table controls in the experiment report template; The formula selection module is used to select formulas for selected form controls and / or multidimensional table controls; The data extraction module and / or formula calculation module are used to obtain business data and calculation data from the experiment report template, fill in the experiment report template, obtain the experiment report, and publish it.

[0015] Compared with the prior art, the present invention has the following advantages and beneficial effects: This invention combines table controls and form controls into a single form. The form controls support editing and merging table headers to create multi-dimensional headers, merging cells to create multi-dimensional cells, and a formula calculation module to perform calculations on the data from the form and / or table. This enables the generation of lab report templates in a low-code manner, significantly reducing development time and costs. This invention ensures maximum fidelity to the lab report template through multi-dimensional table controls and formula calculation controls, greatly shortening development time and costs. Attached Figure Description

[0016] To more clearly illustrate the technical solutions in the embodiments of this application, the accompanying drawings used in the description of the embodiments will be briefly introduced below. Obviously, the accompanying drawings described below are only some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0017] Figure 1 This is a schematic diagram of the framework of the experiment report generation system based on a low-code platform according to an embodiment of the present invention.

[0018] Figure 2 This is a layout diagram of the layout rendering system according to an embodiment of the present invention.

[0019] Figure 3 This is a schematic diagram of the configuration of the formula calculation module in an embodiment of the present invention.

[0020] Figure 4 This is a flowchart illustrating the experimental report generation method according to an embodiment of the present invention. Detailed Implementation

[0021] To enable those skilled in the art to better understand the present application, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are merely some embodiments of the present application, and not all embodiments. All other embodiments obtained by those skilled in the art based on the embodiments of the present application without creative effort are within the scope of protection of the present application.

[0022] In this application, the reference to "embodiment" means that a specific feature, structure, or characteristic described in connection with an embodiment may be included in at least one embodiment of this application. The appearance of this phrase in various places throughout the specification does not necessarily refer to the same embodiment, nor is it a mutually exclusive, independent, or alternative embodiment. It will be explicitly and implicitly understood by those skilled in the art that the embodiments described in this application can be combined with other embodiments.

[0023] Please see Figure 1 In one embodiment of this application, an experiment report generation system based on a low-code platform is provided, including a layout rendering system and a business logic system.

[0024] The layout rendering system is used by users to design and generate experimental reports through drag-and-drop components and render them in real time. It includes a control module, a page rendering module, and a parameter setting module. The control module provides users with draggable visual components, including form controls and multi-dimensional table controls. The page rendering module renders and displays the experimental reports generated by dragging and dropping form controls and / or multi-dimensional table controls in real time within the visual development module of the low-code platform. The parameter setting module includes a parameter configuration unit, a data binding unit, and a formula selection unit. The parameter configuration unit displays and configures the parameters of the selected form control or multi-dimensional table control. The data binding unit configures the database and corresponding data identifier that the selected form control or multi-dimensional table control needs to be bound to. The formula selection module provides the calculation formulas selected by the user.

[0025] The business logic system includes a data extraction module and a formula calculation module. The data extraction module retrieves the business data corresponding to the selected form control or multidimensional table control based on the database bound to the data binding unit and the corresponding data identifier, and returns the data to the corresponding location. The formula calculation module returns the calculation result to the corresponding location of the selected form control or multidimensional table control based on the selected calculation formula and the calculated data.

[0026] Furthermore, form controls are the core of form elements, including layout components, basic components, advanced components, business components, and custom components. Among these, layout components include grid layout components and hierarchical heading components; grid layout components, based on form gridding specifications, are used to place other components in a standardized and aesthetically pleasing manner. Hierarchical heading components are used to categorize the information in the entire form, displaying the form content in blocks and making the form more organized.

[0027] Basic components include multiple unit components within form elements, such as single-line text, dropdown selection boxes, date pickers, and radio buttons. Advanced components include advanced unit components composed of multiple unit components, such as file upload / download components, image upload / preview components, test personnel selection components, and test department selection components. Business components include business unit components composed of multiple unit components and advanced unit components, such as measuring instrument components and test sample components. Custom components include multiple user-defined custom unit components, such as combining radio buttons, single-line text, and dropdown selection boxes, and using code extension to determine the order of appearance of different form elements like single-line text and dropdown selection boxes based on the code extension.

[0028] The multidimensional table control is the core component of table elements, used to create basic tables and multidimensional tables, replicating the table entry functionality in lab reports. It supports multi-level header visualization configuration, cell merging visualization configuration, cell input type configuration, and cell data source configuration. The multidimensional table control includes cell controls and header controls. The cell control contains a cell rendering unit and a cell merging unit; the cell rendering unit renders different cell input / output types based on cell type (e.g., single-line text input cells, dropdown selection cells, image editing cells, etc.); the cell merging unit performs data merging and style merging, or data separation and style separation, based on the user-selected cells. The header control contains a header visualization editing unit and a header rendering unit; the header visualization editing unit generates two-dimensional header data based on the header data of multiple one-dimensional headers selected by the user; the header rendering unit renders the header based on the header data.

[0029] Furthermore, the multidimensional table control creates multidimensional tables based on the basic table, including: creating a multidimensional header table and creating multidimensional cell headers.

[0030] The method for creating a multidimensional header table is as follows: Based on the created base table, one-dimensional table columns are added to the base table to analyze the data and generate several headers and header structures. Then, based on the header structure, header controls and cell controls are used to render the one-dimensional table column data into a one-dimensional table. The headers are configured in the header visualization editing unit, and the header rendering unit is used to render the one-dimensional table column data into a one-dimensional header display. At this point, the headers to be edited are selected or clicked in the header visualization editing unit, and header levels are added or deleted according to the header relationships of the selected headers. The modified header level data is temporarily stored in the new header editing data. After determining the new header editing data, the new header editing data is reorganized into a header structure and headers based on the header hierarchy relationships in the data, pushed to the header rendering unit to be rendered into a multi-dimensional header table, and the data is updated in the new form structure data.

[0031] To create a multidimensional cell table, the method is as follows: The data of several merged cells in the basic table is stored in the cell merge data. When the user selects or clicks the cell to be edited in the multidimensional table control, the selected cell's row and column data are combined into one or more records and stored in the cell merge data. Then, when the multidimensional table control is rendered, the cell merge data is obtained, and the cell merge data and the hidden data of the cells covered by the merged cells are calculated based on the cell position data, cell row and column data in each record. This data is then pushed to the matching cells in the multidimensional table control for merging or hiding. The creation of the multidimensional table is achieved by creating the multidimensional header and multidimensional cells together.

[0032] Furthermore, in the parameter configuration module, the parameters of the configured form control or multi-dimensional table control include the form control or multi-dimensional table control number, the form control or multi-dimensional table control name, the form control or multi-dimensional table control category, and the form control or multi-dimensional table control data type.

[0033] Furthermore, the data extraction unit, based on the database and corresponding data identifier bound by the data binding unit, retrieves the business data corresponding to the data identifier of the selected form control or multidimensional table control from the database through the data link API interface, and feeds it back to the corresponding position of the selected form control or multidimensional table control. At the same time, it generates a data structure model through the form structure data.

[0034] The data extraction module serves as the central data extraction hub for the entire lab report. Based on the layout and control type data within the lab report's structured data, it extracts a data structure model and uses data identifiers from the structure as database field names. Then, it establishes relational tables in the database. When a form is loaded, the module retrieves the corresponding form's data structure based on the form's data identifiers, using this structure for data binding of form elements. When the user fills out the form, the module matches the data identifiers of the manipulated controls to the corresponding field data in the data structure and assigns values. Simultaneously, it generates a data structure model based on the form's structure data. When other modules need to extract form data, the module extracts the data corresponding to the fields matched by the extracted field identifiers and returns it to those modules.

[0035] Furthermore, the formula calculation module includes a formula editor and a formula calculator. The formula editor is used to edit formulas and bind data, while the formula calculator calculates the results based on the data edited in the formula editor.

[0036] Among them, such as Figure 2 As shown, the process of editing and configuring calculation formulas in the formula editor is as follows: Retrieve and display the calculation formulas from the formula library; Select the calculation formula that needs to be edited and configured and render it to the formula editing box, and provide calculation formula prompts; Retrieve the fields of the selected form control and / or multidimensional table control, and select the required fields as formula data to add to the calculation formula to obtain the final calculation formula.

[0037] Furthermore, the formula calculator performs the calculations as follows: When a calculation formula is selected, the calculation formula is first matched with the formula library to obtain the actual calculation formula; Then, based on the data identifiers of the forms and / or tables selected by the user, the data extraction module is invoked to extract and calculate the data; Input the calculated data into the actual calculation formula to obtain the calculation result and return it to the corresponding position.

[0038] Specifically, when a user selects a table, the data extraction module is invoked based on the table's data identifier to extract column data from the table's cells as calculation data; when a user selects a form, the data extraction module is invoked based on the form's data identifier to extract form data as calculation data; when a user selects both a table and a form, the data extraction module is invoked based on both the table's and form's data identifiers to extract column data from the table's cells and form data, using both the cell's column data and the form data as calculation data.

[0039] Furthermore, this system also includes a coding extension module for configuring hook events for form controls or multi-dimensional table controls using coding. This module includes a coding editor and a coding execution module. The coding editor adds corresponding code blocks to the hook events of the form controls or multi-dimensional table controls, and the code block data is inserted into the corresponding hook events. The coding execution module reads the code blocks from the hook events of the form controls or multi-dimensional table controls and then executes the corresponding business logic within those code blocks.

[0040] It should be noted that in the above embodiments of the experiment report generation system based on a low-code platform, the logical division of each program module is only an example. In actual applications, the above functions can be assigned to different program modules as needed, for example, for the sake of corresponding hardware configuration requirements or the convenience of software implementation. That is, the internal structure of the experiment report generation system based on a low-code platform can be divided into different program modules to complete all or part of the functions described above.

[0041] Example 2 Based on the aforementioned experiment report generation system based on a low-code platform, this application also provides an experiment report generation method, comprising the following steps: Determine the requirements for the experiment report; Based on the requirements of the experiment report, an experiment report template is designed and generated by dragging and dropping visual components in form controls and / or multidimensional table controls; the experiment report template is based on a combination of form templates and / or table templates; the table templates include basic table templates and multidimensional table templates; Configure the parameters of form controls and / or multi-dimensional table controls in the experiment report template in the parameter settings module; Use the data binding unit to bind the database and corresponding data identifiers of form controls and / or multidimensional table controls in the experiment report template; The formula selection module is used to select formulas for selected form controls and / or multidimensional table controls; The data extraction module and / or formula calculation module are used to obtain business data and calculation data from the experiment report template, fill in the experiment report template, obtain the experiment report, and publish it.

[0042] The technical features of the above embodiments can be combined in any way. For the sake of brevity, 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 specification.

[0043] The above embodiments are preferred embodiments of the present invention, but the embodiments of the present invention are not limited to the above embodiments. Any changes, modifications, substitutions, combinations, or simplifications made without departing from the spirit and principle of the present invention shall be considered equivalent substitutions and shall be included within the protection scope of the present invention.

Claims

1. An experiment report generation system based on a low-code platform, characterized in that, The system includes a layout rendering system and a business logic system; The layout rendering system is used by users to design and generate experimental reports through drag-and-drop components and render them in real time. It includes a control module, a page rendering module, and a parameter setting module. The control module provides users with draggable visual components, including form controls and multi-dimensional table controls. The page rendering module renders and displays the experimental reports generated by dragging and dropping form controls and / or multi-dimensional table controls in real time within the visual development module of a low-code platform. The parameter setting module includes a parameter configuration unit, a data binding unit, and a formula selection unit. The parameter configuration unit displays and configures the parameters of the selected form control or multi-dimensional table control. The data binding unit configures the database and corresponding data identifier to be bound to the selected form control or multi-dimensional table control. The formula selection module provides the calculation formula selected by the user. The business logic system includes a data extraction module and a formula calculation module; the data extraction module is used to obtain the business data corresponding to the selected form control or multidimensional table control based on the database bound to the data binding unit and the corresponding data identifier, and return the corresponding position; The formula calculation module is used to return the calculation result to the corresponding position of the selected form control or multidimensional table control based on the selected calculation formula and calculation data.

2. The experiment report generation system based on a low-code platform according to claim 1, characterized in that, The form controls include layout components, basic components, advanced components, business components, and custom components; The layout components include a grid layout component and a hierarchical heading component; the grid layout component is used to place other components according to the layout settings; the hierarchical heading component is used to categorize the content of the entire form. The basic component contains multiple unit components within the form element; The advanced component comprises an advanced unit component composed of multiple unit components; The business component comprises a business unit component consisting of multiple unit components and advanced unit components; The custom component includes multiple user-defined custom unit components; The multidimensional table control is used to create basic tables and multidimensional tables, including cell controls and header controls; The cell control includes a cell rendering unit and a cell merging unit; The cell rendering unit is used to render different cell input and output types according to the cell type; the cell merging unit is used to perform two operations: data merging and style merging, or data separation and style separation, according to the cells selected by the user. The header control includes a header visualization editing unit and a header rendering unit; The header visualization editing unit is used to generate header data for a two-dimensional table based on the header data of multiple one-dimensional table headers selected by the user; the header rendering unit is used to render the header based on the header data.

3. The experiment report generation system based on a low-code platform according to claim 2, characterized in that, The multidimensional table control creates multidimensional tables based on a basic table, including creating multidimensional header tables and creating multidimensional cell tables. The creation of the multidimensional header table specifically involves: Based on the created base table, add one-dimensional table columns to the base table and analyze the initial table headers and header structure; Based on the header structure, use header controls and cell controls to render a one-dimensional table from the column data of the one-dimensional table. Configure the table header in the table header visual editing unit, and use the table header rendering unit to render the one-dimensional table column data into a one-dimensional table header display format; In the visual editing unit for table headers, select or click the table header to be edited. Add or delete table header levels according to the table header relationship of the selected table headers, and temporarily store the modified table header level data in the new table header editing data. After determining the new header editing data, the new header editing data is reorganized into a header structure and header according to the header hierarchy in the data, and pushed to the header rendering unit to be rendered into a multi-dimensional header table and the data is updated to the new form structure data; The specific steps for creating a multidimensional cell table are as follows: Store the data of several merged cells in the base table in the merged cell data; When the cell to be edited is selected by box selection or click in the multidimensional table control, the row and column data of the selected cell are combined into one or more data and stored in the cell merge data; When the multidimensional table control is rendered, the merged cell data is obtained. Based on the cell position data, cell row and column data in each data row, the merged cell data and the hidden data of the cells covered by the merged cells are calculated and pushed to the matched cells in the multidimensional table control for merging or hiding.

4. The experiment report generation system based on a low-code platform according to claim 1, characterized in that, The parameters of the form control or multidimensional table control include the form control or multidimensional table control number, the form control or multidimensional table control name, the form control or multidimensional table control category, and the form control or multidimensional table control data type.

5. The experiment report generation system based on a low-code platform according to claim 1, characterized in that, The data extraction unit, based on the database and corresponding data identifier bound by the data binding unit, retrieves the business data corresponding to the data identifier of the selected form control or multidimensional table control from the database through the data link API interface, and feeds it back to the corresponding position of the selected form control or multidimensional table control. At the same time, it generates a data structure model through the form structure data.

6. The experiment report generation system based on a low-code platform according to claim 1, characterized in that, The formula calculation module includes a formula editor and a formula calculator; the formula editor is used to edit and configure calculation formulas; the formula calculator is used to obtain calculation results based on the calculation formulas edited and configured by the formula editor.

7. The experiment report generation system based on a low-code platform according to claim 6, characterized in that, The process of editing and configuring calculation formulas using the formula editor is as follows: Retrieve and display the calculation formulas from the formula library; Select the calculation formula that needs to be edited and configured and render it to the formula editing box, and provide calculation formula prompts; Retrieve the fields of the selected form control and / or multidimensional table control, and select the required fields as formula data to add to the calculation formula to obtain the final calculation formula.

8. The experiment report generation system based on a low-code platform according to claim 6, characterized in that, The process by which the formula calculator obtains the calculation result is as follows: When a calculation formula is selected, the calculation formula is first matched with the formula library to obtain the actual calculation formula; Then, based on the data identifiers of the forms and / or tables selected by the user, the data extraction module is invoked to extract and calculate the data; Input the calculated data into the actual calculation formula to obtain the calculation result and return it to the corresponding position; When the user selects a table, the data extraction module is invoked based on the table's data identifiers to extract column data from the cells in the table as calculation data; When the user selects a form, the data extraction module is invoked based on the form's data identifier to extract the form data as calculation data. When the user selects a table and a form, the data extraction module is invoked based on the table's data identifier to extract column data from the cells in the table. At the same time, the data extraction module is invoked based on the form's data identifier to extract form data. The column data from the cells and the form data are then used as calculation data.

9. The experiment report generation system based on a low-code platform according to claim 1, characterized in that, The system also includes an encoding extension module, which is used to configure hook events for form controls or multidimensional table controls using encoding methods, and includes an encoding editor and an encoding execution module; The coding editor is used to add corresponding code blocks in the hook events of form controls or multidimensional table controls; The encoding execution module is used to read and execute code blocks in the hook events of form controls or multidimensional table controls.

10. A method for generating an experiment report, characterized in that, The method applied to the low-code platform-based experiment report generation system of claims 1-9 includes the following steps: Determine the requirements for the experiment report; Based on the requirements of the experiment report, an experiment report template is designed and generated by dragging and dropping visual components in form controls and / or multidimensional table controls; the experiment report template is based on a combination of form templates and / or table templates; the table template includes a basic table template and a multidimensional table template; Configure the parameters of form controls and / or multi-dimensional table controls in the experiment report template in the parameter settings module; Use the data binding unit to bind the database and corresponding data identifiers of form controls and / or multidimensional table controls in the experiment report template; The formula selection module is used to select formulas for selected form controls and / or multidimensional table controls; The data extraction module and / or formula calculation module are used to obtain business data and calculation data from the experiment report template, fill in the experiment report template, obtain the experiment report, and publish it.

Images