Method, editor and medium for designing dynamic detection report template online

Abstract

The present invention discloses a method, editor and medium for designing a dynamic test report template online, the method comprising: providing an editing interface, the editing interface comprising a gridded editing area, the gridded editing area being a row-column layout and comprising a plurality of cells; obtaining fields in a test data table of a database according to a data source selected by a user, and encapsulating the fields as controls; generating report template configuration information according to the editing information of the editing interface; saving the report template configuration information and generating a test report. The present invention can complete the design and editing code of the test report template without writing a complex program, and automatically design and complete the development work; the system associated with the database can call the edited test report, and the test report template of the entire system can realize personalized customization of the test report without writing a program.

Description

Technical Field

[0001] The present invention relates to the technical field of computer information processing, and in particular to a method, an editor and a medium for designing a dynamic detection report template online. Background Art

[0002] In recent years, we have entered the era of Internet intelligence. Operation and maintenance personnel who are not computer professionals need a dynamic detection report template that can be edited with simple settings without the need for program development.

[0003] Many reports, statements, certificates, licenses and other official documents have fixed layout structures and styles, usually based on a unified template or base, and then change the dynamic content inside, such as name, parameters, signature, etc. The traditional way is to write dynamic content on the paper base, but it is too cumbersome and complicated, and the workload is too large.

[0004] Traditionally, technical personnel develop report templates in two ways: front-end development and back-end development. Front-end development mainly involves HTML layout design, while back-end development mainly involves program code insertion and writing. In this way, dynamic data can be retrieved and dynamic report templates can be displayed.

[0005] The traditional method requires professional plug-ins, but it requires professionals to type command codes and develop in depth to produce test report templates. This mode requires professional training to become a professional developer, and the time cycle from learning to development is very long. After each programming, it needs to be run once, which is cumbersome. It is easy to make mistakes and the debugging is complicated. If there are a large number of personalized templates, it will take a lot of time to develop, which is inefficient. The layout is complicated, and the position, size, increase and decrease of rows and columns all require the writing of debugging codes, which makes development difficult. Summary of the invention

[0006] The present invention aims to solve at least one of the technical problems existing in the prior art. To this end, the present invention proposes a method for designing a dynamic test report template online, which can intelligently edit a prepared test report template program through simple configuration and drag-and-drop layout.

[0007] The present invention also provides an editor for designing dynamic detection report templates online.

[0008] The present invention also provides a computer-readable storage medium for implementing the above method.

[0009] According to the first aspect of the present invention, the method for online designing a dynamic detection report template includes: S100, providing an editing interface, the editing interface including a grid editing area, the grid editing area is a row-column layout, and includes a plurality of cells; S200, according to the data source selected by the user, obtaining the fields in the detection data table of the database, and encapsulating the fields as controls; S300, generating report template configuration information according to the editing information of the editing interface, including: in response to the control being dragged to one of the cells, binding the field corresponding to the control to the cell; S400, saving the report template configuration information and generating a detection report.

[0010] According to some embodiments of the present invention, step S300 includes: setting properties and paging of the grid editing area, including the following sub-steps: S310, setting the type of the current page, the types including ordinary page, loop page, loop sub-page and dynamic loop page; S320, if a loop page or loop sub-page or dynamic loop page is selected, setting the loop area.

[0011] According to some embodiments of the present invention, the step S320 includes: S321, determining the loop area format according to the number of rows and columns of the loop area and the fields bound to the internal cells, and marking the loop area as the first loop area; S322, determining the primary key in the detection data table according to the fields of the loop area, traversing the detection data table according to the primary key, and determining that the data volume is N, where N is greater than 1; S323, binding the corresponding fields of the detection data table according to the loop area format below the first loop area to form a new loop area, marking the first loop area as the second loop area, and marking the new loop area as the first loop area; S324, if the number of generated loop areas is less than N, return to step S323.

[0012] According to some embodiments of the present invention, the step S300 also includes: S330, determining the page type of the current page; S331, if the current page is set as a loop page, continuously outputting loop data in the current page; if the current page cannot display all the loop data, continuously adding the current page until all the loop data are output; S332, if the current page is set as a loop sub-page, continuously outputting loop data in the current page; if the current page cannot display all the loop data, continuously adding loop sub-pages until all the loop data are output; S333, if the current page is set as a dynamic loop page, the current page includes a first current page and a second current page, the first current page is configured to output the first loop data, and the second current page is configured to output the second loop data, then determining whether the first loop data and the second loop data are empty; if the first loop data is not empty and the second loop data is empty, then outputting the first current page and not outputting the second current page; wherein the current page includes fixed information and loop data, and the loop sub-page includes loop data.

[0013] According to some embodiments of the present invention, the method also includes: S010, setting the report template type, the report template type includes a master and a report; S020, if the report type is selected as a master, then creating a new master in the master database, the master is used to save the same parts of multiple detection report templates; S030, if the report type is selected as a report, then creating a new report in the report database, and importing the master, the same parts are configured according to the master; S040, updating the master, and the report is updated according to the master.

[0014] According to some embodiments of the present invention, step S300 further includes: performing style editing operations on the editing interface, including: adding and deleting rows and columns, copying and pasting rows and columns, and merging and splitting cells.

[0015] According to some embodiments of the present invention, step S300 further includes: inserting an electronic signature, and setting a position and size of the electronic signature.

[0016] According to the second aspect of the embodiment of the present invention, the editor for online design of dynamic detection report templates includes: an editing interface module, which is used to provide an editing interface, and the editing interface includes a grid editing area, and the grid editing area is in a row-column layout, including a number of cells; a data field import module, which is used to obtain fields in a detection data table of a database according to a data source selected by a user, and encapsulate the fields as controls; a report template configuration module, which is used to generate report template configuration information according to the editing information of the editing interface, including: in response to the control being dragged to one of the cells, the field corresponding to the control is bound to the cell; a detection report generation module, which is used to save the report template configuration information and generate a detection report.

[0017] According to some embodiments of the present invention, the report template configuration module includes a paging setting submodule, and the paging setting submodule is used to set the type of the current page, and the types include ordinary page, loop page, loop subpage and dynamic loop page.

[0018] According to a computer-readable storage medium of an embodiment of the third aspect of the present invention, a computer program is stored thereon, and when the computer program is executed by a processor, the method of any one of the embodiments of the first aspect of the present invention is implemented.

[0019] The embodiments of the present invention have at least the following beneficial effects: the embodiments of the present invention can complete the design and editing code of the test report template without writing complex programs, and automatically complete the development work by design; the system associated with the database can call the edited test report, and the test report template of the entire system can realize personalized customization of the test report without writing programs.

[0020] Additional aspects and advantages of the present invention will be given in part in the following description and in part will be obvious from the following description, or will be learned through practice of the present invention. BRIEF DESCRIPTION OF THE DRAWINGS

[0021] The above and / or additional aspects and advantages of the present invention will become apparent and easily understood from the description of the embodiments in conjunction with the following drawings, in which:

[0022] Figure 1 The figure is a flowchart of a method according to an embodiment of the present invention.

[0023] Figure 2 The figure is a schematic diagram of a process of setting the current page according to an embodiment of the present invention.

[0024] Figure 3 The figure is a flow chart of a method for setting a loop area according to an embodiment of the present invention.

[0025] Figure 4A schematic diagram of a process of outputting cyclic data for different page types according to an embodiment of the present invention.

[0026] Figure 5 The figure is a schematic diagram of a process of creating a new report template according to an embodiment of the present invention.

[0027] Figure 6 Schematic diagram of an editing interface according to an embodiment of the present invention.

[0028] Figure 7 This is a sample diagram of a normal page.

[0029] Figure 8 The following is an example diagram of a loop page.

[0030] Fig. 9 The following is an example diagram of a loop subpage.

[0031] Fig.10 The following is an example diagram of a dynamic loop page.

[0032] Fig.11 Schematic diagram of the fly ash performance test report in the editing state.

[0033] Fig.12 Example diagram set up for a loop region.

[0034] Fig.13 The figure is a schematic block diagram of modules of an editor according to an embodiment of the present invention. DETAILED DESCRIPTION

[0035] Embodiments of the present invention are described in detail below, examples of which are shown in the accompanying drawings, wherein the same or similar reference numerals throughout represent the same or similar elements or elements having the same or similar functions. The embodiments described below with reference to the accompanying drawings are exemplary and are only used to explain the present invention, and cannot be understood as limiting the present invention.

[0036] In the description of the present invention, "several" means one or more, "more" means two or more, "greater than", "less than", "exceed" etc. are understood as not including the number itself, and "above", "below", "within" etc. are understood as including the number itself. If there is a description of "first" or "second", it is only used for the purpose of distinguishing the technical features, and cannot be understood as indicating or implying the relative importance or implicitly indicating the number of the indicated technical features or implicitly indicating the order of the indicated technical features.

[0037] Terminology explanation:

[0038] Controls are encapsulation of data and methods. Controls can have their own properties and methods, where properties are simple accessors to control data, and methods are some simple and visible functions of controls. The control creation process includes design, development, debugging (the so-called 3Ds development process, i.e. Design, Develop, Debug), and then the use of controls.

[0039] Designing controls is a tedious task. There is a huge difference between developing controls by yourself and using controls to develop visual programs, which requires programmers to be proficient in object-oriented programming. The greatest significance of creating controls is to encapsulate repetitive work, and secondly, it can expand the functions of existing controls.

[0040] Survey Report, also known as "Cargo Damage Survey Report", is an objective written certificate issued by the inspection agency after inspecting the damaged goods at the request of the applicant. The inspection and appraisal of the degree of damage to the goods are often entrusted to independent surveyors (Independent Surveyors) with credibility, authority and detachment in international trade. The quality inspection before the sale of the product and the statistics of the number of qualified products of the company are written certificates to identify that the product quality meets the standards. It is obtained through the quality inspection of products and equipment and is the standard to ensure the product quality system.

[0041] Template: One or more files that contain the structure and tools that form the style and page layout elements of a finished document.

[0042] Master: A master is a part of a template that stores information including the placement of text and objects in a fixed layout, the size of text and object placeholders, text styles, backgrounds, color themes, effects, and animations.

[0043] The editor is an online visual editing and typesetting tool that provides a preview function, making it more convenient for users to edit graphics, codes, content layout, text, and materials.

[0044] The embodiment of the present invention is based on the detection report template development technology of the database, takes the platform system as the carrier, associates the field with the control, and drags and drops the control layout to make the page development simple and fast, and truly realizes the purpose of all-round editing and customized dynamic detection report template.

[0045] Reference Figure 1 The method of the embodiment of the present invention mainly includes the following steps:

[0046] S100, providing an editing interface, wherein the editing interface includes a grid editing area, the grid editing area is a row-column layout, and includes a plurality of cells;

[0047] S200, according to the data source selected by the user, obtaining the fields in the detection data table of the database, and encapsulating the fields as controls;

[0048] S300, generating report template configuration information according to the editing information of the editing interface, including: in response to the control being dragged to one of the cells, binding the field corresponding to the control to the cell;

[0049] S400: Save report template configuration information and generate a test report.

[0050] In this embodiment, the editing of the test report template is simply realized by the field drag and drop function. When the user operates, the mouse first selects the data field in the test report template and drags it to the grid editing interface. After releasing it, the field is automatically fixed at the position where it is dragged and dropped to the editing interface. The field realizes the binding of the field and the control in the editing interface, and realizes the display of the corresponding dynamic data when the test report certificate is finally generated.

[0051] The visual grid interface of this embodiment realizes convenient typesetting. When the user uses it, the number of initialized rows and columns is displayed, and the user can edit them freely according to needs. The right-click menu function includes but is not limited to: insert / delete a row (column); copy and paste rows (columns). The purpose of the above-mentioned row and column editing function is to facilitate users to flexibly operate grid typesetting.

[0052] Reference Figure 2 The property setting and paging setting of the embodiment of the present invention include the following steps:

[0053] S310, setting the type of the current page, which includes a normal page, a loop page, a loop subpage, and a dynamic loop page;

[0054] S320: If a loop page, loop subpage or dynamic loop page is selected, set the loop area.

[0055] We know that in the test report, due to different factors such as the test number, many test data of the same type need to be displayed. This embodiment regards these test data as loop data. Since different repeated drag and drop data fields cause waste of time and energy and inconvenience, this embodiment designs a loop area function. This function can be implemented in loop pages, loop subpages, and dynamic loop pages.

[0056] Further references Figure 3 , the method for setting the loop area includes the following steps:

[0057] S321, determining the loop region format according to the number of rows and columns in the loop region and the fields bound to the internal cells, and marking the loop region as the first loop region;

[0058] S322, determining the primary key in the detection data table according to the field of the loop area, traversing the detection data table according to the primary key, and determining that the amount of data is N, where N is greater than 1;

[0059] S323, set the counting variable i, initialize i=1, bind the fields of the corresponding detection data table under the first loop area according to the loop area format to form a new loop area, mark the first loop area as the second loop area, mark the new loop area as the first loop area, and add 1 to i;

[0060] S324. If the number of generated loop regions is less than N, return to step S323.

[0061] Further references Figure 4 In some embodiments, the method for outputting cyclic data of different types of pages includes the following steps:

[0062] S330, determining the page type of the current page;

[0063] S331, if the current page is set as a loop page, then the loop data is continuously output in the current page; if one current page cannot display all the loop data, then the current page is continuously added until all the loop data is output;

[0064] S332, if the current page is set as a loop subpage, then the loop data is continuously output in the current page; if the current page cannot display all the loop data, then the loop subpage is continuously added until all the loop data is output;

[0065] S333: If the current page is set as a dynamic loop page, the current page includes a first current page and a second current page, the first current page is configured to output first loop data, and the second current page is configured to output second loop data, then determine whether the first loop data and the second loop data are empty; if the first loop data is not empty and the second loop data is empty, then output the first current page and do not output the second current page;

[0066] The current page includes fixed information and cyclic data, and the cyclic subpage includes cyclic data.

[0067] Reference Figure 7 , 8 , 9 and 10, this embodiment sets 4 page types, including ordinary pages ( Figure 7 As shown), loop page ( Figure 8 As shown), loop subpages ( Fig. 9 shown) and the dynamic loop page ( Fig.10Take company personnel information as an example. The normal page displays basic fixed information of the company and multiple personnel information. If there are 100 personnel information, only 10 personnel information that can be displayed on the current page are displayed, and the remaining personnel information is not displayed. The loop page includes several current pages, each of which includes the basic fixed information of the company, such as Figure 8 The two loop pages can display 20 personnel information, if ten current pages are generated. The loop subpage includes a current page. When the current page cannot display all personnel information, one or more loop subpages are generated. The loop subpage only displays the personnel information that has not been displayed on the previous page. If there are 100 personnel information, one current page and 8 loop subpages are generated. Fig.10 The dynamic loop page shown includes two current pages. The first current page displays personnel information, and the second current page displays department information. If there is no personnel information, the first current page will not be displayed, and only the second current page will be displayed; if there are 100 personnel information, 10 first current pages displaying personnel information will be generated.

[0068] Further references Fig.12 Taking the inspection report of a certain steel as an example, the part in the thick-bordered box is set as a loop area. The area contains bound fields and is displayed as loop data. Different inspection numbers are used to distinguish the furnace (batch) number, brand level, yield strength, tensile strength, elongation after fracture and other inspection data and corresponding indicators are displayed in a loop. Multiple loop areas of the same format are formed below the thick border and the data is displayed, so that the data can be displayed infinitely, the display mode of a single row of data is changed, and a new page is automatically generated when it exceeds the A4 page until the data is displayed.

[0069] Reference Figure 5 In some embodiments, creating a new test report template requires setting the report template type, which specifically includes the following steps:

[0070] S010. Set the report template type, which includes master and report;

[0071] S020. If the selected report type is a master, a new master is created in the master database, and the master is used to store the same parts of multiple test report templates;

[0072] S030. If the report type is selected as report, a new report is created in the report database and imported into the master template. The same parts are configured according to the master template.

[0073] S040, Update the master, and the report is updated according to the master.

[0074] This embodiment sets a master template to uniformly edit and save the same parts of multiple test report templates, effectively saving the time of editing the test report templates. Users only need to import the master template when creating a new test report, and there is no need to repeatedly set the text, style, color, etc. of the same parts.

[0075] Reference Fig.11 Taking the fly ash performance test report as an example, the test report template being edited is shown in the figure. The format and text of the basic information table of the test report, such as title, commissioning unit, address, project name, etc., can be saved as a master template. The test items and results can be obtained from the test data table of the database, and bound to the corresponding cells by dragging and dropping the fields, and finally the data results are automatically displayed in the corresponding table.

[0076] Reference Figure 6 The editing interface of this embodiment includes a function menu bar area, a data field area, a grid editing area (grid visualization HTML layout) and a property and paging setting area. Among them, the function menu bar includes an import test report button, a master import button, a data source selection button, a save button, a preview button and various buttons for HTML style editing operations.

[0077] In some embodiments, an electronic signature may be inserted into the test report template, and the position and size of the electronic signature may be set.

[0078] In some embodiments, if the report consists of multiple pages, new pages can be added, and the pages can be dragged and rearranged at will.

[0079] In some embodiments, reports can automatically generate dynamic page numbers to show the order of the pages.

[0080] Reference Fig.13 The editor of the embodiment of the present invention includes an editing interface module, which is used to provide an editing interface, wherein the editing interface includes a grid editing area, the grid editing area is a row-column layout, and includes a plurality of cells; a data field import module, which is used to obtain the fields in the detection data table of the database according to the data source selected by the user, and encapsulate the fields as controls; a report template configuration module, which is used to generate report template configuration information according to the editing information of the editing interface, including: in response to the control being dragged to one of the cells, the field corresponding to the control is bound to the cell; a detection report generation module, which is used to save the report template configuration information and generate a detection report.

[0081] In some embodiments, the report template configuration module includes a paging setting submodule, and the paging setting submodule is used to set the type of the current page, including a normal page, a loop page, a loop subpage, and a dynamic loop page.

[0082] In some embodiments, the paging setting submodule includes a loop area setting unit for setting the loop area to display the loop data.

[0083] The embodiment of the present invention realizes that the design and editing code of the test report template can be completed without writing complex programs, and the development work is completed by automatic design; after the user sets the data source, the field can be dragged to bind with the control, and the drag-and-drop operation can be quickly configured, and multiple tables are supported; because the database field is bound to the control, the program editing of the test report can be realized without writing a program; the embodiment of the present invention is associated with the database, so the system associated with the database can call the edited test report, and the test report template of the entire system can realize personalized customization of the test report without writing a program; the test reports of the entire system can be managed uniformly. The embodiment of the present invention adopts a grid editing interface, which is a grid layout with flexible typesetting, and the row and column spacing in the vertical and horizontal directions can be designed; for cyclic data, the cyclic area list of the same data can be repeated and automatically edited without editing each line content one by one. If more than 1 page, it will automatically continue to the next page; the test report certificate generated by the embodiment of the present invention is traceable and anti-counterfeiting; the test data is transmitted in real time, cannot be tampered with, and can be traced, achieving the anti-counterfeiting function of the test report.

[0084] Although specific embodiments are described herein, those of ordinary skill in the art will recognize that many other modifications or alternative embodiments are also within the scope of the present disclosure. For example, any of the functions and / or processing capabilities described in conjunction with a particular device or component may be performed by any other device or component. In addition, although various exemplary implementations and architectures have been described according to embodiments of the present disclosure, those of ordinary skill in the art will recognize that many other modifications to the exemplary implementations and architectures described herein are also within the scope of the present disclosure.

[0085] Some aspects of the present disclosure are described above with reference to the block diagram and flow chart of the system, method, system and / or computer program product according to the exemplary embodiments.It should be understood that the combination of one or more blocks in the block diagram and the flow chart and the blocks in the block diagram and the flow chart can be realized by executing computer executable program instructions respectively.Equally, according to some embodiments, some blocks in the block diagram and the flow chart may not need to be executed in the order shown, or may not need to be executed in full.In addition, additional components and / or operations beyond those components and / or operations shown in the blocks in the block diagram and the flow chart may be present in certain embodiments.

[0086] Therefore, the blocks in the block diagrams and flow charts support the combination of devices for performing the specified functions, the combination of elements or steps for performing the specified functions, and the program instruction devices for performing the specified functions. It should also be understood that each block in the block diagrams and flow charts and the combination of blocks in the block diagrams and flow charts can be implemented by a special-purpose hardware computer system or a combination of special-purpose hardware and computer instructions that performs a specific function, element or step.

[0087] The program modules, applications, etc. described herein may include one or more software components, including, for example, software objects, methods, data structures, etc. Each such software component may include computer-executable instructions that, in response to execution, cause at least a portion of the functionality described herein (e.g., one or more operations of the illustrative methods described herein) to be performed.

[0088] Software components can be encoded with any of various programming languages. An exemplary programming language can be a low-level programming language, such as an assembly language associated with a specific hardware architecture and / or an operating system platform. The software component comprising assembly language instructions may need to be converted to executable machine code by an assembler before being executed by hardware architecture and / or platform. Another exemplary programming language can be a higher-level programming language, which can be transplanted across multiple architectures. The software component comprising a higher-level programming language may need to be converted to an intermediate representation by an interpreter or a compiler before execution. Other examples of programming languages ​​include but are not limited to macro languages, shells or command languages, job control languages, scripting languages, database queries or search languages ​​or report writing languages. In one or more exemplary embodiments, the software component comprising the instruction of one of the above-mentioned programming language examples can be directly executed by an operating system or other software components, without first being converted into another form.

[0089] Software components may be stored as files or other data storage structures. Software components of similar type or related functions may be stored together, such as in a specific directory, folder, or library. Software components may be static (e.g., preset or fixed) or dynamic (e.g., created or modified at execution time).

[0090] The embodiments of the present invention are described in detail above with reference to the accompanying drawings, but the present invention is not limited to the above embodiments, and various changes can be made within the knowledge scope of ordinary technicians in the relevant technical field without departing from the purpose of the present invention.

Claims

1. A method for designing a dynamic detection report template online, characterized in that: include: S100, providing an editing interface, wherein the editing interface includes a grid editing area, wherein the grid editing area is in a row-column layout and includes a plurality of cells; S200, acquiring fields in a detection data table of a database according to a data source selected by a user, and encapsulating the fields as controls; S300, generating report template configuration information according to the editing information of the editing interface, including: in response to the control being dragged to one of the cells, binding a field corresponding to the control to the cell; S400, saving report template configuration information and generating a test report; The step S300 includes: The properties and pages of the grid editing area are set, including the following sub-steps: S310, setting the type of the current page, the types including normal page, loop page, loop sub-page and dynamic loop page; S320, if a loop page, a loop subpage or a dynamic loop page is selected, set the loop area; The step S300 further includes: S330, determining the page type of the current page; S331, if the current page is set as a loop page, then the loop data is continuously output in the current page; if the current page cannot display all the loop data, then the current page is continuously added until all the loop data is output; S332, if the current page is set as a loop subpage, then the loop data is continuously output in the current page; if the current page cannot display all the loop data, then loop subpages are continuously added until all the loop data are output; S333: If the current page is set as a dynamic loop page, the current page includes a first current page and a second current page, the first current page is configured to output first loop data, and the second current page is configured to output second loop data, then determine whether the first loop data and the second loop data are empty; if the first loop data is not empty and the second loop data is empty, then output the first current page and do not output the second current page; Wherein, the current page includes fixed information and cyclic data, and the cyclic subpage includes cyclic data; The step S320 includes: S321, determining a loop region format according to the number of rows and columns of the loop region and the fields bound to the internal cells, and marking the loop region as a first loop region; S322, determining a primary key in the detection data table according to the field of the loop area, traversing the detection data table according to the primary key, and determining that the amount of data is N, where N is greater than 1; S323, binding the corresponding fields of the detection data table according to the circulation area format below the first circulation area to form a new circulation area, marking the first circulation area as the second circulation area, and marking the new circulation area as the first circulation area; S324. If the number of generated loop regions is less than N, return to step S323.

2. The method for designing a dynamic detection report template online according to claim 1, characterized in that: The method further comprises: S010. Setting a report template type, wherein the report template type includes a master template and a report; S020. If the selected report type is a master, a new master is created in the master database, and the master is used to store the same parts of multiple test report templates; S030. If the selected report type is report, a new report is created in the report database, and a master is imported, and the same parts are configured according to the master; S040: Update the master, and update the report according to the master.

3. The method for designing a dynamic detection report template online according to claim 1, characterized in that: The step S300 also includes: performing style editing operations on the editing interface, including: adding and deleting rows and columns, copying and pasting rows and columns, and merging and splitting cells.

4. The method for designing a dynamic detection report template online according to claim 1, characterized in that: The step S300 also includes: inserting an electronic signature, and setting the position and size of the electronic signature.

5. An editor for designing dynamic detection report templates online, characterized in that: include: An editing interface module, used to provide an editing interface, wherein the editing interface includes a grid editing area, wherein the grid editing area is in a row-column layout and includes a plurality of cells; The data field import module is used to obtain the fields in the detection data table of the database according to the data source selected by the user, and encapsulate the fields as controls; A report template configuration module, used to generate report template configuration information according to the editing information of the editing interface, including: in response to the control being dragged to one of the cells, binding the field corresponding to the control to the cell; A test report generation module is used to save report template configuration information and generate a test report; The report template configuration module includes a paging setting submodule, and the paging setting submodule is used to set the type of the current page, which includes a normal page, a loop page, a loop subpage, and a dynamic loop page; if a loop page, a loop subpage, or a dynamic loop page is selected, the loop area is set; The report template configuration module is also used to: determine the page type of the current page; if the current page is set as a loop page, the loop data is continuously output in the current page; if the current page cannot display all the loop data, the current page is continuously added until the loop data is completely output; if the current page is set as a loop sub-page, the loop data is continuously output in the current page; if the current page cannot display all the loop data, the loop sub-page is continuously added until the loop data is completely output; if the current page is set as a dynamic loop page, the current page includes a first current page and a second current page, the first current page is configured to output the first loop data, and the second current page is configured to output the second loop data, then determine whether the first loop data and the second loop data are empty; if the first loop data is not empty and the second loop data is empty, the first current page is output and the second current page is not output; wherein, the current page includes fixed information and loop data, and the loop sub-page includes loop data; If you select a loop page, loop subpage, or dynamic loop page, set the loop area, including: S321, determining a loop region format according to the number of rows and columns of the loop region and the fields bound to the internal cells, and marking the loop region as a first loop region; S322, determining a primary key in the detection data table according to the field of the loop area, traversing the detection data table according to the primary key, and determining that the amount of data is N, where N is greater than 1; S323, binding the corresponding fields of the detection data table according to the circulation area format below the first circulation area to form a new circulation area, marking the first circulation area as the second circulation area, and marking the new circulation area as the first circulation area; S324. If the number of generated loop regions is less than N, return to step S323.

6. A computer-readable storage medium having a computer program stored thereon, wherein the computer program implements the method according to any one of claims 1 to 4 when executed by a processor.

Images