Dynamic report generation method and system

Abstract

The present application relates to the field of data processing, and in particular to a configurable dynamic report generation method and system, wherein the method comprises: obtaining configuration data of a dynamic report; generating a dynamic report template and a FORM form according to the configuration data; editing the FORM form to generate report data; obtaining the report data and synchronizing the report data to the dynamic report template to generate an editable dynamic report. The present application has the effect of facilitating the improvement of the efficiency of displaying statistical data in reports.

Description

Technical Field

[0001] The present application relates to the field of data processing, and in particular to a configurable dynamic report generation method and system. Background Art

[0002] In today's big data era, statistical data can not only intuitively reflect the numerical characteristics of events, but also reflect the changing trends of events.

[0003] At present, when performing statistics on event data, the data are often first counted in a database, and then the data in the database are imported into a report by type for display.

[0004] In the process of implementing this application, the inventors found that the above technology has at least the following problems: reports are mainly used to display some comprehensive data. The current general system creates reports through steps such as demand analysis, code writing, application testing, and system deployment; each time a report is created, it is necessary to simultaneously create a corresponding report page and add corresponding data processing logic such as addition, deletion, modification, and query, which is a large workload; it can be seen that the use of reports to display statistical data is inefficient under the current technology. Summary of the invention

[0005] In order to improve the efficiency of displaying statistical data in reports, the present application provides a configurable dynamic report generation method.

[0006] In a first aspect, the present application provides a configurable dynamic report generation method, which adopts the following technical solution:

[0007] A configurable dynamic report generation method includes: obtaining configuration data of the dynamic report;

[0008] Generate dynamic report templates and FORM forms according to the configuration data;

[0009] Edit the FORM form to generate report data;

[0010] The report data is obtained and synchronized with the dynamic report template to generate an editable dynamic report.

[0011] By adopting the above technical solution, users can define the configuration data of dynamic reports. The user-defined dynamic report configuration data can facilitate the system to automatically generate dynamic report templates and FORM form pages. Users can write report data into the database by editing on the FORM form page, and further import the report data written in the database into the dynamic report template to generate a dynamic report based on the configuration data of the dynamic report in the database. When it is necessary to add or modify dynamic report data, it can be edited directly on the dynamic report. The edited new table data can be directly synchronized to the database, so there is no need to create a new dynamic report for the new table data, which facilitates improving the efficiency of displaying statistical data in the report.

[0012] In a specific implementation scheme, the configuration data includes the table name, operator information and table header configuration information of the dynamic report.

[0013] By adopting the above technical solution, the user defines the table name, operator information and header configuration information of the dynamic report, so that the system can generate the corresponding dynamic report template and FORM form based on the user-defined table name, operator information and header configuration information.

[0014] In a specific implementation scheme, the header configuration information includes: a header name and a data type.

[0015] By adopting the above technical solution, the user can easily determine the table name of the dynamic report and the data type of the data in the dynamic report by defining the table header configuration information.

[0016] In a specific implementation scheme, the generating of a dynamic report template and FORM form according to the configuration data includes:

[0017] Compile the configuration data to generate corresponding DOM elements;

[0018] Combining the DOM elements to generate the dynamic report template;

[0019] The data type is compiled to generate a corresponding FORM form page.

[0020] By adopting the above technical solution, the configuration data is compiled into corresponding DOM elements, and the compiled DOM elements are combined together to generate a dynamic report template that has not yet been edited. The report data can be easily written into the database through the FORM form page.

[0021] In a specific implementation scheme, the dynamic report supports editing operations of adding data, deleting data, and modifying data.

[0022] By adopting the above technical solution, if there is a need to add, delete or modify report data, the user can directly add, delete or modify data on the generated dynamic report without creating a new report, which helps improve the efficiency of displaying statistical data in the report.

[0023] In a specific implementation scheme, the dynamic report supports import and export operations of report data.

[0024] By adopting the above technical solution, dynamic reports support the import and export of data, which makes it easier to improve the display and utilization efficiency of dynamic report data.

[0025] In a specific implementation scheme, the operation of importing the report data into the dynamic report includes:

[0026] Acquire the configuration data of the dynamic report and the table data of the preset import data table;

[0027] Matching the configuration data with the table data to obtain a matching result;

[0028] The table data is imported into the dynamic report according to the matching result.

[0029] By adopting the above technical solution, the table data is imported into the dynamic report according to the matching results, which makes it easy to improve the accuracy of the imported data.

[0030] In a second aspect, the present application provides a dynamic report generation system, which adopts the following technical solution:

[0031] A dynamic report generation system, comprising:

[0032] Configuration data acquisition module, used to obtain configuration data of dynamic reports;

[0033] A dynamic report template and FORM form generation module, used to generate a dynamic report template and FORM form according to the configuration data;

[0034] A report data generation module, used to edit the FORM form and generate report data;

[0035] The dynamic report generation module is used to obtain the report data and synchronize the report data to the dynamic report template to generate a configurable dynamic report.

[0036] By adopting the above technical solution, users can define the configuration data of dynamic reports. The user-defined dynamic report configuration data can facilitate the system to automatically generate dynamic report templates and FORM form pages. Users can write report data into the database by editing on the FORM form page, and further import the report data written in the database into the dynamic report template to generate a dynamic report based on the configuration data of the dynamic report in the database. When it is necessary to add or modify dynamic report data, it can be edited directly on the dynamic report. The edited new table data can be directly synchronized to the database, so there is no need to create a new dynamic report for the new table data, which facilitates improving the efficiency of displaying statistical data in the report.

[0037] In a third aspect, the present application provides a computer device, which adopts the following technical solution: it includes a memory and a processor, and the memory stores a computer program that can be loaded by the processor and execute any one of the dynamic report generation methods described above.

[0038] By adopting the above technical solution, users can define the configuration data of dynamic reports. The user-defined dynamic report configuration data can facilitate the system to automatically generate dynamic report templates and FORM form pages. Users can write report data into the database by editing on the FORM form page, and further import the report data written in the database into the dynamic report template to generate a dynamic report based on the configuration data of the dynamic report in the database. When it is necessary to add or modify dynamic report data, it can be edited directly on the dynamic report. The edited new table data can be directly synchronized to the database, so there is no need to create a new dynamic report for the new table data, which facilitates improving the efficiency of displaying statistical data in the report.

[0039] In a fourth aspect, the present application provides a computer-readable storage medium, which adopts the following technical solution: storing a computer program that can be loaded by a processor and execute any one of the above-mentioned dynamic report generation methods.

[0040] By adopting the above technical solution, users can define the configuration data of dynamic reports. The user-defined dynamic report configuration data can facilitate the system to automatically generate dynamic report templates and FORM form pages. Users can write report data into the database by editing on the FORM form page, and further import the report data written in the database into the dynamic report template to generate a dynamic report based on the configuration data of the dynamic report in the database. When it is necessary to add or modify dynamic report data, it can be edited directly on the dynamic report. The edited new table data can be directly synchronized to the database, so there is no need to create a new dynamic report for the new table data, which facilitates improving the efficiency of displaying statistical data in the report.

[0041] In summary, the present application includes at least one of the following beneficial technical effects:

[0042] 1. Users can define the configuration data of dynamic reports. The user-defined dynamic report configuration data can facilitate the system to automatically generate dynamic report templates and FORM form pages. Users can write report data into the database by editing on the FORM form page, and further import the report data written in the database into the dynamic report template to generate a dynamic report based on the configuration data of the dynamic report in the database. When dynamic report data needs to be added or modified, it can be edited directly on the dynamic report. The edited new table data can be directly synchronized to the database, so there is no need to create a new dynamic report for the new table data, which is convenient for improving the efficiency of displaying statistical data in the report.

[0043] 2. Users define the table name, operator information and header configuration information of the dynamic report, so that the system can generate corresponding dynamic report templates and FORM forms based on the table name, operator information and header configuration information defined by the user.

[0044] 3. Compile the configuration data into corresponding DOM elements, and then combine the compiled DOM elements together to generate a dynamic report template that has not yet been edited. The FORM form page can be used to easily write the report data into the database. BRIEF DESCRIPTION OF THE DRAWINGS

[0045] Figure 1 It is a flowchart of a configurable dynamic report generation method in Example 1 of the present application.

[0046] Figure 2 It is a structural block diagram of a configurable dynamic report generation system in Example 2 of the present application.

[0047] Description of reference numerals: 100, configuration data acquisition module; 200, dynamic report template and FORM form generation module; 300, report data generation module; 400, dynamic report generation module. DETAILED DESCRIPTION

[0048] The following is combined with Figure 1-2 This application is described in further detail.

[0049] Example 1

[0050] Embodiment 1 of the present application discloses a method for generating a dynamic report. Figure 1 , dynamic report generation methods include:

[0051] S100: Obtain configuration data of a dynamic report.

[0052] In order to facilitate users to edit reports according to their own needs, a report editing system based on a database is preset in the implementation. The report editing system is provided with a table information editing page. Users can edit the table name of the dynamic report in the table name column on the table information editing page, and can also select the operator information in the operator information column on the table information editing page. Specifically, the operator information includes the reporting department and the person who reports. In the implementation, users can select the reporting department in the reporting department column on the table information editing page, and can also select the person who reports in the reporting person column on the table information editing page.

[0053] Furthermore, there is a button for adding a first-level header on the table information editing page, and the user can configure the header information of the dynamic report by clicking this button. It should be noted that a dynamic report includes several headers. For example, a personnel information statistics report can set multiple headers including gender, age, ID number, contact information, and department.

[0054] Specifically, the header information includes the header name, sorting, data type, etc.; the header name is the name of a configured header, such as "gender" in the above personnel information statistics report; the sorting is the way to sort the data under a header, such as sorting in chronological order or sorting by the size of the value, etc.; the data type is the data type of the data under a header displayed in the dynamic report. Specifically, the optional data types of the dynamic report include: text, value, date, selection, attachment, system value and geographic coordinates, etc.

[0055] In implementation, after the report operator completes editing of the table name, operator information and header information, the report editing system stores the filled-in table name, operator information and header information in a database corresponding to the report editing system. Specifically, the database corresponding to the report editing system uses MongoDB.

[0056] S200: Generate a dynamic report template and FORM form according to the configuration data.

[0057] Specifically, S200 includes the following steps:

[0058] S201. Obtain configuration data from a database.

[0059] The above-mentioned report editing system can parse the configuration data of the dynamic report, and parsing the configuration data means generating the corresponding dynamic report template and FORM form page according to the configuration data. Specifically, taking the service area inspection record report as an example, the dynamic report template generated by parsing includes a filling column for the reporting date, a filling column for the inspection date, a filling column for the service area, a filling column for the number of people entering the area every day, a filling column for the number of people with daily body temperature checks, a filling column for the number of people found to have a fever, and a filling column for remarks.

[0060] In implementation, the report editing system first obtains configuration data stored in MongoDB, including table name, operator information, and table header information.

[0061] S202: Compile the configuration data to generate corresponding DOM elements.

[0062] After the report editing system obtains the configuration data of the report through step S201, the user further uses JavaScript language to compile the configuration data including the table name, operator information and header information, thereby obtaining a first DOM element corresponding to the reporting date filling column, a second DOM element corresponding to the inspection date filling column, a third DOM element corresponding to the service area filling column, a fourth DOM element corresponding to the daily number of people entering the area filling column, a fifth DOM element corresponding to the daily body temperature detection number filling column, a sixth DOM element corresponding to the number of people found to have a fever filling column, and a seventh DOM element corresponding to the remarks filling column, etc.

[0063] S203: Combine the DOM elements to generate the dynamic report template.

[0064] In implementation, the first DOM element, the second DOM element, the third DOM element, the fourth DOM element, the fifth DOM element, the sixth DOM element and the seventh DOM element are combined to generate a dynamic report template. It should be noted that at this time, there is no report data edited by the report operator on the dynamic report template.

[0065] S204: Compile the data type to generate a corresponding FORM form page.

[0066] After obtaining the configuration data of the report through step S201, the data type data in the configuration data is compiled by using JavaScript language to generate a FORM form page. Specifically, the corresponding FORM form page generated includes: a reporting date filling box, an inspection date filling box, a service area filling box, a daily number of people entering the area filling box, a daily body temperature detection number filling box, a fever number filling box, and a remarks filling box, etc.

[0067] And during implementation, when the FORM form page is completed, the report operator can enter corresponding data according to the actual situation in the reporting date filling box, inspection date filling box, service area filling box, daily number of people entering the area filling box, daily temperature detection number filling box, number of people found to have a fever filling box, and remarks filling box on the FORM form page.

[0068] S300: Edit the FORM to generate report data.

[0069] During implementation, the report operator can enter the reporting date in the reporting date fill-in box on the FORM form page, the report operator can enter the reporting date in the reporting date fill-in box on the FORM form page, the inspection date can be entered in the inspection date fill-in box on the FORM form page, the name of the service area can be entered in the service area fill-in box, the daily number of people entering the area can be entered in the daily number of people entering the area fill-in box, the number of people with fever found in the service area can be entered in the number of people with fever fill-in box, and notes on related situations can be entered in the notes fill-in box.

[0070] When the report operator enters the reporting date in the reporting date box, enters the inspection date in the inspection date box, enters the name of the service area in the service area box, enters the summarized daily number of people entering the area in the daily number of people entering the area box, enters the number of people with fever found in the service area in the number of people with fever found box, and enters the remarks of the relevant situation in the remarks box, the report editing system can store the input reporting date, inspection date, name of the service area, the summarized daily number of people entering the area, the number of people with fever found in the service area, and remarks of the relevant situation in MongoDB.

[0071] S400: Acquire the report data and synchronize the report data to the dynamic report template to generate an editable dynamic report.

[0072] In order to facilitate the display and editing of reports with report data, it is necessary to first obtain the report data from MongoDB through the report editing system, and then match the reporting date data in the report data to the reporting date filling column on the dynamic report template, match the inspection date data in the report data to the inspection date filling column, match the service area name data to the service area filling column, match the daily number of people entering the area in the report data to the daily number of people entering the area filling column, match the daily temperature detection number data in the report data to the daily temperature detection number filling column, match the number of people found with fever in the report data to the number of people found with fever filling column, and match the remarks data in the report data to the remarks filling column; in summary, by matching the report data to the corresponding position of the dynamic report template.

[0073] It should be noted that, in addition to the above-mentioned operations of adding new data, the above-mentioned dynamic reports also support the modification, import and export functions of report data.

[0074] Specifically, when the report operator modifies the report data of a dynamic report, the report operator can modify the report data directly on the dynamic report. Then, the report editing system synchronizes the modified report data to MongoDB by collating and summarizing the VUE logic code, so as to maintain the consistency of the report data on the dynamic report and the report data in MongoDB.

[0075] Specifically, when the report operator imports the table data in the preset import data table into the dynamic data table, the following steps are specifically included:

[0076] S1. Obtain configuration data of the report in the database and table data of the preset import data table.

[0077] The configuration data of the dynamic report template is obtained from MongoDB through the report parsing module 300, and the table data in the imported data table is also obtained.

[0078] S2. Match the configuration data and the table data to obtain a matching result.

[0079] The table data in the imported data table are matched with the configuration data of the dynamic report template in turn through the report parsing module 300. The type of each table data in the imported data table can be known through the matching. Specifically, it can be known which type of data each table data in the imported data table belongs to, namely, the reporting date, the inspection date, the name of the service area, the summarized number of people entering the area every day, the number of people with fever found in the service area, and the remarks of the relevant situation.

[0080] After matching the configuration data and the table data, a matching result can be obtained. The matching result includes two cases: 0 and 1. When the matching result is 1, it indicates that the type of the corresponding table data in the imported data table is determined through matching, and the table data is eligible to be imported into the dynamic report. When the matching result is 0, it indicates that the type of the corresponding table data in the imported data table is not determined through matching, and the table data is not eligible to be imported into the dynamic report.

[0081] S3. Import the table data into the dynamic table based on the matching results.

[0082] When the matching result is 1, the table data is imported into the dynamic report template according to the type of the table data through the report parsing module 300, and then the corresponding dynamic report is generated; in implementation, the table data can also be imported into the dynamic report. It should be noted that after the table data is imported into the dynamic report, the table data will replace the original report data in the dynamic report. The report data imported into the dynamic report is further synchronized to MongoDB through the report parsing module.

[0083] Specifically, when the report operator exports the data in the dynamic report, the dynamic report is exported into an EXCEL table using VUE code through the report parsing module.

[0084] Figure 1 FIG. 1 is a flow chart of a method for generating a dynamic report in one embodiment. It should be understood that although Figure 1 The steps in the flowchart are shown in sequence as indicated by the arrows, but the steps are not necessarily executed in the order indicated by the arrows; unless otherwise specified in this document, there is no strict order restriction for the execution of the steps, and the steps may be executed in other orders; and Figure 1 At least part of the steps may include multiple sub-steps or multiple stages. These sub-steps or stages are not necessarily executed at the same time, but can be executed at different times. The execution order of these sub-steps or stages is not necessarily sequential, but can be executed in turn or alternately with other steps or at least part of the sub-steps or stages of other steps.

[0085] Example 2

[0086] Embodiment 2 of the present application discloses a dynamic report generation system. Figure 2 , the dynamic report generation system includes:

[0087] Configuration data acquisition module 100, used to acquire configuration data of dynamic reports;

[0088] A dynamic report template and FORM form generating module 200, used to generate a dynamic report template and FORM form according to the configuration data;

[0089] The report data generating module 300 is used to edit the FORM form and generate report data;

[0090] The dynamic report generation module 400 is used to obtain the report data and synchronize the report data to the dynamic report template to generate a configurable dynamic report.

[0091] Example 3

[0092] In this embodiment 3, a computer device is disclosed, including a memory and a processor, wherein the memory stores a computer program, and when the computer program is executed by the processor, the processor executes the steps of the above-mentioned method for generating a dynamic report. The steps of the method for generating a dynamic report here can be the steps of the method for generating a dynamic report in each of the above-mentioned embodiments.

[0093] Example 4

[0094] In this embodiment 4, a computer-readable storage medium is disclosed, which stores a computer program that can be loaded by a processor and execute a dynamic report generation method such as the above-mentioned method. The computer-readable storage medium includes, for example: a USB flash drive, a mobile hard disk, a read-only memory (ROM), a random access memory (RAM), a magnetic disk or an optical disk, and other media that can store program codes.

[0095] This specific embodiment is merely an explanation of the present invention and is not a limitation of the present invention. After reading this specification, those skilled in the art may make non-creative modifications to the present embodiment as needed. However, as long as they are within the scope of the claims of the present invention, they are protected by the patent law.

Claims

1. A dynamic report generation method, characterized in that: include: Get the configuration data of dynamic reports; Editing the configuration data based on the table information editing page in the report editing system; Generate dynamic report templates and FORM forms according to the configuration data; Edit the FORM form to generate report data; Acquire the report data and synchronize the report data to the dynamic report template to generate an editable dynamic report; The configuration data includes the table name, operator information and table header configuration information of the dynamic report; The header configuration information includes: header name, sorting and data type; Generating a dynamic report template and FORM form according to the configuration data includes: Compile the configuration data to generate corresponding DOM elements; Combining the DOM elements to generate the dynamic report template; Compile the data type to generate a corresponding FORM form page; The dynamic report supports import and export operations of report data; The operation of importing the report data into the dynamic report includes: Acquire the configuration data of the dynamic report and the table data of the preset import data table; Matching the configuration data with the table data to obtain a matching result; Importing the table data into the dynamic report according to the matching result; When the report operator exports the data in the dynamic report, the VUE code is used to export the dynamic report into an EXCEL table; The dynamic report supports editing operations of adding data, deleting data, and modifying data; When the report operator modifies the report data of a dynamic report, the report operator modifies the report data directly on the dynamic report. Then, the report editing system synchronizes the modified report data to MongoDB by collating and summarizing the VUE logic code, so as to maintain the consistency between the report data on the dynamic report and the report data in MongoDB.

2. The dynamic report generation method according to claim 1, characterized in that: The dynamic report supports editing operations of adding data, deleting data, and modifying data.

3. A dynamic report generation system, characterized in that: include: A configuration data acquisition module (100), used to acquire configuration data of a dynamic report, and edit the configuration data based on a table information editing page in a report editing system; A dynamic report template and FORM form generation module (200), used to generate a dynamic report template and FORM form according to the configuration data; A report data generating module (300), used for editing the FORM form to generate report data; A dynamic report generation module (400), used to obtain the report data and synchronize the report data to the dynamic report template to generate a configurable dynamic report; The configuration data includes the table name, operator information and table header configuration information of the dynamic report; The header configuration information includes: header name, sorting and data type; Generating a dynamic report template and FORM form according to the configuration data includes: Compile the configuration data to generate corresponding DOM elements; Combining the DOM elements to generate the dynamic report template; Compile the data type to generate a corresponding FORM form page; The dynamic report supports import and export operations of report data; The operation of importing the report data into the dynamic report includes: Acquire the configuration data of the dynamic report and the table data of the preset import data table; Matching the configuration data with the table data to obtain a matching result; Importing the table data into the dynamic report according to the matching result; When the report operator exports the data in the dynamic report, the VUE code is used to export the dynamic report into an EXCEL table; The dynamic report supports editing operations of adding data, deleting data, and modifying data; When the report operator modifies the report data of a dynamic report, the report operator modifies the report data directly on the dynamic report. Then, the report editing system synchronizes the modified report data to MongoDB by collating and summarizing the VUE logic code, so as to maintain the consistency between the report data on the dynamic report and the report data in MongoDB.

4. A computer device, characterized in that: The computer device includes a memory and a processor, the memory stores a computer program, and when the computer program is executed by the processor, the processor executes the dynamic report generation method according to any one of claims 1 to 2.

5. A computer-readable storage medium storing a computer program, wherein when the computer program is executed by a processor, the processor executes the dynamic report generation method according to any one of claims 1 to 2.

Images