CN111881192B - Method, system, electronic equipment and storage medium for generating visual configuration report - Google Patents
Method, system, electronic equipment and storage medium for generating visual configuration report Download PDFInfo
- Publication number
- CN111881192B CN111881192B CN202010765465.1A CN202010765465A CN111881192B CN 111881192 B CN111881192 B CN 111881192B CN 202010765465 A CN202010765465 A CN 202010765465A CN 111881192 B CN111881192 B CN 111881192B
- Authority
- CN
- China
- Prior art keywords
- report
- data
- generating
- configuration
- file
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 230000000007 visual effect Effects 0.000 title claims abstract description 52
- 238000000034 method Methods 0.000 title claims abstract description 42
- 238000003860 storage Methods 0.000 title claims abstract description 21
- 238000012545 processing Methods 0.000 claims abstract description 34
- 238000006243 chemical reaction Methods 0.000 claims abstract description 10
- 230000002452 interceptive effect Effects 0.000 claims abstract description 4
- 230000008569 process Effects 0.000 claims description 19
- 238000012544 monitoring process Methods 0.000 claims description 11
- 230000002159 abnormal effect Effects 0.000 claims description 6
- 238000004364 calculation method Methods 0.000 claims description 6
- 230000009191 jumping Effects 0.000 claims description 3
- 238000011068 loading method Methods 0.000 claims description 3
- 238000011084 recovery Methods 0.000 claims description 3
- 230000001172 regenerating effect Effects 0.000 claims description 3
- 238000012216 screening Methods 0.000 claims description 3
- 239000000725 suspension Substances 0.000 claims description 3
- 238000013461 design Methods 0.000 abstract description 5
- 230000005856 abnormality Effects 0.000 abstract description 2
- 238000011161 development Methods 0.000 description 9
- 230000006870 function Effects 0.000 description 8
- 238000010586 diagram Methods 0.000 description 4
- 230000003993 interaction Effects 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 239000000470 constituent Substances 0.000 description 1
- 230000008713 feedback mechanism Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
- 238000012800 visualization Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- General Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Mathematical Physics (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- General Health & Medical Sciences (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method, a system, electronic equipment and a storage medium for generating a visual configuration report, which belong to the field of report generation, and the technical problem to be solved by the invention is how to automatically generate the report meeting different requirements, and simultaneously realize self-design of appearance, self-definition of business logic and timely feedback of occurrence of abnormality, and the adopted technical scheme is as follows: the method comprises the following steps: s1, processing and format conversion are carried out on basic data in a database through a data processing layer, and then generating a data stream suitable for interface display and file writing, so that report generation is completed; s2, generating interface patterns and configuration information of a data source in a visual configuration mode at a display layer, and completing visual display of a report; and S3, decoupling the display layer and the data processing layer, reserving a fixed interface for interactive processing, and improving user experience of report generation. The system comprises a report requester, a style definer, a data processor, a data output device and an engine monitor.
Description
Technical Field
The invention relates to the field of computer and report generation, in particular to a method, a system, electronic equipment and a storage medium for generating a visual configuration report.
Background
The report forms are an important constituent component of enterprise operation monitoring, result display and reporting as an information organization and analysis means. The whole report development process is divided into a demand stage, a design stage, a development stage, a test stage and an online stage, and the whole process is time-consuming and requires more manpower and time. In actual development, programmers need to write a large amount of codes, the code has poor reusability and is difficult to expand, the requirements of multiple layers such as a user, an upper-level leader and the like are met, the business logic of a report is complex, and the relevance among different reports is poor.
Enterprises generally use report tools of third parties to make reports, but the report tools of the third parties are not strong in specificity, lack abnormal feedback and are difficult to comprehensively adapt to enterprise products in appearance and function.
The existing report development is mainly single-table development, a fixed report structure and fixed business logic, and all are fixed and difficult to maintain and expand in the later period; the self-defined report can only be applied to the situations of few tables, low data volume in the tables, and poor performance when the number of the tables is large and the data volume is large. Therefore, how to automatically generate reports meeting different requirements, and simultaneously realize self-design of appearance, self-definition of business logic and timely feedback of abnormal occurrence is a technical problem to be solved in the present.
Disclosure of Invention
The technical task of the invention is to provide a method, a system, electronic equipment and a storage medium for generating a visual configuration report, so as to solve the problems of how to automatically generate reports meeting different requirements, and simultaneously realize self-design of appearance, custom service logic and timely feedback when abnormality occurs.
The technical task of the invention is realized in the following way, and the method for generating the visual configuration report is as follows:
s1, processing and format conversion are carried out on basic data in a database through a data processing layer, and then generating a data stream suitable for interface display and file writing, so that report generation is completed;
s2, generating interface patterns and configuration information of a data source in a visual configuration mode at a display layer, and completing visual display of a report;
and S3, decoupling the display layer and the data processing layer, reserving a fixed interface for interactive processing, and improving user experience of report generation.
Preferably, the report generation in the step S1 is specifically as follows:
s101, visually configuring report patterns and derived file patterns according to requirements, generating configuration information, and storing the configuration information in a database or a file;
s102, visually configuring data sources according to requirements, and generating a template file of a report;
s103, generating a report definition file and a basic query SQL according to the defined content;
s104, configuring a data processing algorithm, and judging whether the data is real-time data or not:
(1) if yes, directly generating configuration information for the real-time data, and then jumping to step S107;
(2) if not, automatically creating a timing task, splicing time range information according to granularity, and executing step S105;
s105, inquiring SQL splicing time conditions according to the set data granularity, writing configuration, regenerating configuration information, and storing the configuration information in a database or a file;
s106, executing a timing task according to the timing task configuration, and summarizing and warehousing the data;
s107, generating a report.
Preferably, the visual display of the report table in the step S2 is specifically as follows:
s201, receiving a report request submitted by a user, wherein the report request is provided with a report identifier, reading the display style configuration of the report according to the report identifier, and generating a display interface of the report according to the configuration;
s202, a user receives a report query request submitted by the user according to a visual configuration query condition of a display interface, wherein the report query request carries a report identifier and one or more screening conditions set by the user;
s203, converting one or more search conditions into a sphere condition of a report SQL query statement according to the configured search condition information;
s204, inquiring a table name corresponding to the report identifier;
s205, assembling query fields, report names and where conditions of a user into a complete report SQL query statement, and acquiring corresponding data results from a preset report data source according to the query statement;
s206, converting the data result into a chart result according to the chart configuration information, and performing front-end visual display on the data result and the chart result.
More preferably, the report includes a real-time report and a fixed granularity report; the table name related to the real-time report is an SQL query statement for generating the real-time report; the table names related to the fixed granularity report are derived from the real-time report related table and granularity.
A system for generating a visual configuration report, the system comprising,
the report requester is used for centrally controlling, distributing and managing requests;
the style definer is used for configuring report styles, font formats and output file styles in a visual mode, generating configuration information and storing the configuration information into a database or a file;
the data definer is used for defining a data source, managing query SQL, creating and managing timing tasks, receiving data transmitted to the presentation layer by a background, generating a template file and a presentation interface, managing and scheduling an API of the background data processing layer, generating configuration information and storing the configuration information in a database or a file;
the data processor is used for defining the generated configuration query SQL according to the data, acquiring, calculating and summarizing the acquired data, transmitting the processed data to the data output device, and finally generating and storing a report with fixed granularity by periodically executing the SQL query task;
the data output device is used for carrying out format conversion, writing files or generating charts on the data transmitted from the data processor, transmitting the data to the data definition device and displaying the data at the front end or triggering file downloading;
and the engine monitor is used for monitoring the running condition of the whole report engine and feeding back the running condition and the abnormal information.
Preferably, the report style comprises report header content, report display line number, fonts and font sizes, query condition number, query condition title, and derived file format and style;
the data definer is also used for defining the main body information and the calculation strategy of the report engine, and generating a report definition file according to the defined content, wherein the suffix of the report definition file is xml.
Preferably, the data outputter is further configured to convert the data after the calculation summary is completed into a specified output format according to the data definition configuration, where the specified output format includes Html, excel, json, pdf and Csv;
the engine monitor is also used for tracking the execution process from the request definer to the whole system of the data output device, recording the execution process and monitoring the time loss and the resource occupation condition of each step of operation of the report; simultaneously, controlling the existing report forms, and executing operations of suspension, recovery, storage, loading and refreshing; and the user analyzes various performances of the report and adjusts the execution process of the report according to the running condition of the report, so that the performance of the whole system is optimized.
More preferably, the working process of the system is as follows:
(1) Logging in the system, and opening a report interface or an export file;
(2) The strong report ID and the query condition are used as request parameters to be sent to a data definer;
(3) The report requester receives a user request, and splices and inquires SQL according to report ID parameters and inquiry conditions in the request, and the strip data processing layer API;
(4) After the data processor receives the request, query SQL is executed to obtain basic data;
(5) Calculating the data of partial fields according to the algorithm information recorded in the configuration;
(6) Transmitting the calculated data to a data output device;
(7) The data output device performs file creation and format conversion on the data according to the configuration and outputs the data in a specified format;
(8) Judging whether to export the file:
(1) if yes, executing the step (9);
(2) if not, executing the step (10);
(9) Generating a file with a specified format according to the template, and triggering downloading;
(10) And generating data in a specified html format according to the template, and displaying the data in a front-end interface.
An electronic device, comprising: a memory and at least one processor;
wherein the memory stores computer-executable instructions;
the at least one processor executes the computer-executable instructions stored by the memory to cause the at least one processor to perform the method of generating a visual configuration report as described above.
A computer readable storage medium, wherein computer executable instructions are stored in the computer readable storage medium, and when a processor executes the computer executable instructions, the method for generating the visual configuration report is implemented.
The method, the system, the electronic equipment and the storage medium for generating the visual configuration report have the following advantages:
the method adopts a visual configuration mode to generate the configuration information of the interface style and the data source, can adapt to complex business logic, has higher universality and greatly simplifies the report development flow; processing and format converting basic data in a database through an independent data processing engine to generate a data stream suitable for interface display and writing in files; decoupling the display layer and the data processing layer, reserving a fixed interface for interaction, reducing the interaction between the front end and the background, and fully improving the experience of report users;
the system comprises a report requester, a style definer, a data processor, a data output device and an engine monitor, wherein the functions of the report requester, the style definer, the data processor, the data output device and the engine monitor are not interfered with each other, and the engine monitor is integrated with the whole system to monitor the running condition of the whole system;
decoupling front-end display and background data, and outputting source data to the front end after interpretation and processing by a data definer and a data processor, and separating a display layer from a data processing layer;
fourthly, the request received by the invention is controlled and distributed by the report requester, the request sent by the report user call and the opened report are managed and associated in the report requester uniformly, and the operation of the report user on the background can be free;
the method meets the requirement of a user for quickly generating the report, greatly shortens the development period and improves the working efficiency;
the report style and business logic are both realized by visual configuration, so that the threshold of report development is reduced, and the manpower loss is reduced;
the invention realizes decoupling of the display layer and the data processing layer, and the front end displays the change of the content, and only needs to modify the pattern definition configuration and the data definition configuration; the background database is changed, and the user can realize no sense of operation only by modifying the data definition configuration;
the invention can realize real-time report forms and multi-granularity report forms through configuration, thereby meeting different requirements of users on data granularity;
the independent data processing engine is arranged to control and optimize the algorithm flow, so that the performance is higher, and the database pressure is smaller;
and (ten) the invention adopts engine operation monitoring to ensure the dynamic display of the operation state of the whole engine system, is convenient for abnormal feedback and problem tracing in the operation process, can expose the engine short board, provides basis for the optimization of the later engine, and ensures the reliability of the report engine.
Drawings
The invention is further described below with reference to the accompanying drawings.
FIG. 1 is a flow chart diagram of report generation;
FIG. 2 is a diagram of a custom report design;
FIG. 3 is a block diagram of a visual configuration report generation system;
FIG. 4 is a flow chart diagram of the operational process of the visualization configuration report generation system.
Detailed Description
The method, the system, the electronic device and the storage medium for generating the visual configuration report of the present invention are described in detail below with reference to the accompanying drawings and the specific embodiments of the present invention.
Example 1:
the invention relates to a method for generating a visual configuration report, which comprises the following steps:
s1, processing and format conversion are carried out on basic data in a database through a data processing layer, and then generating a data stream suitable for interface display and file writing, so that report generation is completed; as shown in fig. 1, the report production is specifically as follows:
s101, visually configuring report patterns and derived file patterns according to requirements, generating configuration information, and storing the configuration information in a database or a file;
s102, visually configuring data sources according to requirements, and generating a template file of a report;
s103, generating a report definition file and a basic query SQL according to the defined content;
s104, configuring a data processing algorithm, and judging whether the data is real-time data or not:
(1) if yes, directly generating configuration information for the real-time data, and then jumping to step S107;
(2) if not, automatically creating a timing task, splicing time range information according to granularity, and executing step S105;
s105, inquiring SQL splicing time conditions according to the set data granularity, wherein the specific time summary granularity is shown in figure 2, writing configuration, regenerating configuration information, and storing the configuration information in a database or a file;
s106, executing a timing task according to the timing task configuration, and summarizing and warehousing the data;
s107, generating a report.
S2, generating interface patterns and configuration information of a data source in a visual configuration mode at a display layer, and completing visual display of a report; the visual display of the report is specifically as follows:
s201, receiving a report request submitted by a user, wherein the report request is provided with a report identifier, reading the display style configuration of the report according to the report identifier, and generating a display interface of the report according to the configuration;
s202, a user receives a report query request submitted by the user according to a visual configuration query condition of a display interface, wherein the report query request carries a report identifier and one or more screening conditions set by the user;
s203, converting one or more search conditions into a sphere condition of a report SQL query statement according to the configured search condition information;
s204, inquiring a table name corresponding to the report identifier;
s205, assembling query fields, report names and where conditions of a user into a complete report SQL query statement, and acquiring corresponding data results from a preset report data source according to the query statement;
s206, converting the data result into a chart result according to the chart configuration information, and performing front-end visual display on the data result and the chart result.
And S3, decoupling the display layer and the data processing layer, reserving a fixed interface for interactive processing, and improving user experience of report generation.
Wherein the report forms comprise real-time report forms and fixed granularity report forms; the table name related to the real-time report is an SQL query statement for generating the real-time report; the table names related to the fixed granularity report are derived from the real-time report related table and granularity.
Example 2:
as shown in fig. 3, the system for generating a visual configuration report of the present invention, the system includes,
the report requester is used for centrally controlling, distributing and managing requests;
the style definer is used for configuring report styles, font formats and output file styles in a visual mode, generating configuration information and storing the configuration information into a database or a file; the report style comprises report header content, report display line number, fonts and font sizes, query condition number, query condition title and derived file format and style;
the data definer is used for defining a data source, managing query SQL, creating and managing timing tasks, receiving data transmitted to the presentation layer by a background, generating a template file and a presentation interface, managing and scheduling an API of the background data processing layer, generating configuration information and storing the configuration information in a database or a file; the data definer is also used for defining the main body information and the calculation strategy of the report engine, and generating a report definition file according to the defined content, wherein the suffix of the report definition file is xml.
The data processor is used for defining the generated configuration query SQL according to the data, acquiring, calculating and summarizing the acquired data, transmitting the processed data to the data output device, and finally generating and storing a report with fixed granularity by periodically executing the SQL query task;
the data output device is used for carrying out format conversion, writing files or generating charts on the data transmitted from the data processor, transmitting the data to the data definition device and displaying the data at the front end or triggering file downloading; the data output device is also used for converting the data after the calculation summary is completed into a specified output format according to the data definition configuration, wherein the specified output format comprises Html, excel, json, pdf and Csv;
and the engine monitor is used for monitoring the running condition of the whole report engine and feeding back the running condition and the abnormal information. The engine monitor is also used for tracking the execution process of the whole system from the request definer to the data output device, recording the execution process and monitoring the time loss and the resource occupation condition of each step of operation of the report; simultaneously, controlling the existing report forms, and executing operations of suspension, recovery, storage, loading and refreshing; and the user analyzes various performances of the report and adjusts the execution process of the report according to the running condition of the report, so that the performance of the whole system is optimized.
As shown in fig. 4, the working process of the system is as follows:
(1) Logging in the system, and opening a report interface or an export file;
(2) The strong report ID and the query condition are used as request parameters to be sent to a data definer;
(3) The report requester receives a user request, and splices and inquires SQL according to report ID parameters and inquiry conditions in the request, and the strip data processing layer API;
(4) After the data processor receives the request, query SQL is executed to obtain basic data;
(5) Calculating the data of partial fields according to the algorithm information recorded in the configuration;
(6) Transmitting the calculated data to a data output device;
(7) The data output device performs file creation and format conversion on the data according to the configuration and outputs the data in a specified format;
(8) Judging whether to export the file:
(1) if yes, executing the step (9);
(2) if not, executing the step (10);
(9) Generating a file with a specified format according to the template, and triggering downloading;
(10) And generating data in a specified html format according to the template, and displaying the data in a front-end interface.
The traditional report development has the functions of display, inquiry and export, and the implementation of the functions added or enhanced by the invention is as follows:
(1) visual configuration: whether the report style, the derived file style, the data granularity and the data source are obtained through interface visual configuration, configuration information is generated through the visual configuration and is stored in a database or a file, and the report interface, the file and corresponding data can be generated only by reading the configuration information when the report is generated;
(2) decoupling the presentation layer from the data layer, and interacting through a data definer: for a background data processor, only configuration information of the front end can be seen, the data processor acquires, calculates and gathers data according to the configuration, and the front end changes, so that the configuration is only required to be modified when the data source is required to be modified; for the front end, only the API provided by the data processor can be seen, and when the background database information is changed, the template interpretation configuration is only required to be modified, so that the user can be ensured to feel no sense of operation;
(3) special data processing engine: when the general database is subjected to excessive operations, the performance is very low, the data processor independently processes the data, the database inquiry is only used for acquiring basic data, then the data processor processes the data according to the data source information and algorithm information in the configuration, and after the processing is completed, the data is transmitted to the data output device to be converted into a specified format and output to the front end or a file;
(4) operation monitoring and anomaly feedback: the general report forms lack monitoring and feedback mechanisms in the use process, problems can only be checked from the log, and the efficiency is low. The system can set up an independent report monitor to monitor information of various aspects such as logs, interface states, network requests and the like, and the information is timely fed back to a system user through a special monitoring interface.
Example 3:
the embodiment of the invention also provides electronic equipment, which comprises: a memory and at least one processor;
wherein the memory stores computer-executable instructions;
the at least one processor executes the computer-executable instructions stored by the memory, causing the at least one processor to perform the method of generating a visual configuration report as in embodiment 2.
Example 4:
the embodiment of the invention also provides a computer readable storage medium, wherein a plurality of instructions are stored, and the instructions are loaded by a processor to enable the processor to execute the method for generating the visual configuration report in any embodiment of the invention. Specifically, a system or apparatus provided with a storage medium on which a software program code realizing the functions of any of the above embodiments is stored, and a computer (or CPU or MPU) of the system or apparatus may be caused to read out and execute the program code stored in the storage medium.
In this case, the program code itself read from the storage medium may realize the functions of any of the above-described embodiments, and thus the program code and the storage medium storing the program code form part of the present invention.
Examples of the storage medium for providing the program code include a floppy disk, a hard disk, a magneto-optical disk, an optical disk (e.g., CD-ROM, CD-R, CD-RW, DVD-ROM, DVD-R visual configuration report generation method, system, electronic device, and storage medium M, DVD-RW, DVD+RW), a magnetic tape, a nonvolatile memory card, and ROM. Alternatively, the program code may be downloaded from a server computer by a communication network.
Further, it should be apparent that the functions of any of the above-described embodiments may be implemented not only by executing the program code read out by the computer, but also by causing an operating system or the like operating on the computer to perform part or all of the actual operations based on the instructions of the program code.
Further, it is understood that the program code read out by the storage medium is written into a memory provided in an expansion board inserted into a computer or into a memory provided in an expansion unit connected to the computer, and then a CPU or the like mounted on the expansion board or the expansion unit is caused to perform part and all of actual operations based on instructions of the program code, thereby realizing the functions of any of the above embodiments.
Finally, it should be noted that: the above embodiments are only for illustrating the technical solution of the present invention, and not for limiting the same; although the invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some or all of the technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit of the invention.
Claims (9)
1. The method for generating the visual configuration report is characterized by comprising the following steps of:
s1, processing and format conversion are carried out on basic data in a database through a data processing layer, and then generating a data stream suitable for interface display and file writing, so that report generation is completed; the report generation is specifically as follows:
s101, visually configuring report patterns and derived file patterns according to requirements, generating configuration information, and storing the configuration information in a database or a file;
s102, visually configuring data sources according to requirements, and generating a template file of a report;
s103, generating a report definition file and a basic query SQL according to the defined content;
s104, configuring a data processing algorithm, and judging whether the data is real-time data or not:
(1) if yes, directly generating configuration information for the real-time data, and then jumping to step S107;
(2) if not, automatically creating a timing task, splicing time range information according to granularity, and executing step S105;
s105, inquiring SQL splicing time conditions according to the set data granularity, writing configuration, regenerating configuration information, and storing the configuration information in a database or a file;
s106, executing a timing task according to the timing task configuration, and summarizing and warehousing the data;
s107, generating a report;
s2, generating interface patterns and configuration information of a data source in a visual configuration mode at a display layer, and completing visual display of a report;
and S3, decoupling the display layer and the data processing layer, reserving a fixed interface for interactive processing, and improving user experience of report generation.
2. The method for generating a visual configuration report according to claim 1, wherein the visual presentation of the report in step S2 is specifically as follows:
s201, receiving a report request submitted by a user, wherein the report request is provided with a report identifier, reading the display style configuration of the report according to the report identifier, and generating a display interface of the report according to the configuration;
s202, a user receives a report query request submitted by the user according to a visual configuration query condition of a display interface, wherein the report query request carries a report identifier and one or more screening conditions set by the user;
s203, converting one or more search conditions into a sphere condition of a report SQL query statement according to the configured search condition information;
s204, inquiring a table name corresponding to the report identifier;
s205, assembling query fields, report names and where conditions of a user into a complete report SQL query statement, and acquiring corresponding data results from a preset report data source according to the query statement;
s206, converting the data result into a chart result according to the chart configuration information, and performing front-end visual display on the data result and the chart result.
3. The method of generating a visual configuration report according to claim 1 or 2, wherein the report comprises a real-time report and a fixed granularity report; the table name related to the real-time report is an SQL query statement for generating the real-time report; the table names related to the fixed granularity report are derived from the real-time report related table and granularity.
4. A system for generating a visual configuration report, wherein the system is configured to implement the method for generating a visual configuration report according to any one of claims 1 to 3; the system includes a first processor configured to receive a signal,
the report requester is used for centrally controlling, distributing and managing requests;
the style definer is used for configuring report styles, font formats and output file styles in a visual mode, generating configuration information and storing the configuration information into a database or a file;
the data definer is used for defining a data source, managing query SQL, creating and managing timing tasks, receiving data transmitted to the presentation layer by a background, generating a template file and a presentation interface, managing and scheduling an API of the background data processing layer, generating configuration information and storing the configuration information in a database or a file;
the data processor is used for defining the generated configuration query SQL according to the data, acquiring, calculating and summarizing the acquired data, transmitting the processed data to the data output device, and finally generating and storing a report with fixed granularity by periodically executing the SQL query task;
the data output device is used for carrying out format conversion, writing files or generating charts on the data transmitted from the data processor, transmitting the data to the data definition device and displaying the data at the front end or triggering file downloading;
and the engine monitor is used for monitoring the running condition of the whole report engine and feeding back the running condition and the abnormal information.
5. The visual configuration report generating system of claim 4, wherein the report style comprises report header content, report display line number, font and font size, query condition number, query condition title and export file format and style;
the data definer is also used for defining the main body information and the calculation strategy of the report engine, and generating a report definition file according to the defined content, wherein the suffix of the report definition file is xml.
6. The visual configuration report generating system according to claim 4, wherein the data outputter is further configured to convert the data after the calculation summary is completed into a specified output format according to the data definition configuration, and the specified output format includes Html, excel, json, pdf and Csv;
the engine monitor is also used for tracking the execution process from the request definer to the whole system of the data output device, recording the execution process and monitoring the time loss and the resource occupation condition of each step of operation of the report; simultaneously, controlling the existing report forms, and executing operations of suspension, recovery, storage, loading and refreshing; and the user analyzes various performances of the report and adjusts the execution process of the report according to the running condition of the report, so that the performance of the whole system is optimized.
7. The visual configuration report generating system according to any one of claims 4 to 6, wherein the working process of the system is as follows:
(1) Logging in the system, and opening a report interface or an export file;
(2) The strong report ID and the query condition are used as request parameters to be sent to a data definer;
(3) The report requester receives a user request, and splices and inquires SQL according to report ID parameters and inquiry conditions in the request, and the strip data processing layer API;
(4) After the data processor receives the request, query SQL is executed to obtain basic data;
(5) Calculating the data of partial fields according to the algorithm information recorded in the configuration;
(6) Transmitting the calculated data to a data output device;
(7) The data output device performs file creation and format conversion on the data according to the configuration and outputs the data in a specified format;
(8) Judging whether to export the file:
(1) if yes, executing the step (9);
(2) if not, executing the step (10);
(9) Generating a file with a specified format according to the template, and triggering downloading;
(10) And generating data in a specified html format according to the template, and displaying the data in a front-end interface.
8. An electronic device, comprising: a memory and at least one processor;
wherein the memory stores computer-executable instructions;
the at least one processor executing computer-executable instructions stored in the memory causes the at least one processor to perform the method of generating a visual configuration report as claimed in any one of claims 1 to 3.
9. A computer readable storage medium having stored therein computer executable instructions which, when executed by a processor, implement the method of generating a visual configuration report according to any one of claims 1 to 3.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010765465.1A CN111881192B (en) | 2020-08-03 | 2020-08-03 | Method, system, electronic equipment and storage medium for generating visual configuration report |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010765465.1A CN111881192B (en) | 2020-08-03 | 2020-08-03 | Method, system, electronic equipment and storage medium for generating visual configuration report |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111881192A CN111881192A (en) | 2020-11-03 |
| CN111881192B true CN111881192B (en) | 2024-01-30 |
Family
ID=73206031
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010765465.1A Active CN111881192B (en) | 2020-08-03 | 2020-08-03 | Method, system, electronic equipment and storage medium for generating visual configuration report |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111881192B (en) |
Families Citing this family (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112464120A (en) * | 2020-11-26 | 2021-03-09 | 阳光保险集团股份有限公司 | Data visualization display method and device, electronic equipment and storage medium |
| CN112486617B (en) * | 2020-12-01 | 2023-06-02 | 华控清交信息科技(北京)有限公司 | Ciphertext data processing architecture, method, apparatus and machine readable medium |
| CN112256731A (en) * | 2020-12-21 | 2021-01-22 | 长沙树根互联技术有限公司 | Data display method and device and electronic equipment |
| CN112667716A (en) * | 2020-12-30 | 2021-04-16 | 京东数字科技控股股份有限公司 | Data processing method and device, electronic equipment and storage medium |
| CN112905558A (en) * | 2020-12-30 | 2021-06-04 | 银盛通信有限公司 | Report system implementation method and system based on database configuration |
| CN112632108A (en) * | 2020-12-30 | 2021-04-09 | 深圳艾灵网络有限公司 | Rendering method and device of graph and report interface and electronic equipment |
| CN112861496A (en) * | 2021-03-22 | 2021-05-28 | 平安商业保理有限公司 | Report generation display method and device, computer equipment and readable storage medium |
| CN113010591B (en) * | 2021-03-22 | 2024-04-19 | 薪得付信息技术(上海)有限公司 | Report generation method, device and system based on application interface |
| CN113051881A (en) * | 2021-04-02 | 2021-06-29 | 北京神州数字科技有限公司 | Report display method based on parameter configuration |
| CN113703886B (en) * | 2021-07-21 | 2023-06-20 | 青岛海尔科技有限公司 | User system behavior monitoring method, system, electronic equipment and storage medium |
| CN113988005A (en) * | 2021-10-25 | 2022-01-28 | 重庆允成互联网科技有限公司 | Mobile terminal interface rapid configuration method |
| CN116340398B (en) * | 2023-05-25 | 2023-08-18 | 北京六一六信息技术有限公司 | Method and system for deriving online custom report query |
| CN117454862A (en) * | 2023-12-25 | 2024-01-26 | 青岛民航凯亚系统集成有限公司 | Report generation method based on engine mode and self-service BI system |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2014079304A1 (en) * | 2012-11-26 | 2014-05-30 | 中兴通讯股份有限公司 | Report creation method, device and system |
| CN109766529A (en) * | 2018-12-03 | 2019-05-17 | 中国联合网络通信集团有限公司 | A kind of generation method and equipment of report |
| WO2019178979A1 (en) * | 2018-03-21 | 2019-09-26 | 平安科技（深圳）有限公司 | Method for querying report data, apparatus, storage medium and server |
| CN110717319A (en) * | 2019-09-24 | 2020-01-21 | 车智互联（北京）科技有限公司 | Self-service report generation method and device, computing equipment and system |
| CN111178023A (en) * | 2019-12-30 | 2020-05-19 | 广东飞企互联科技股份有限公司 | Visual self-defined report design system |
-
2020
- 2020-08-03 CN CN202010765465.1A patent/CN111881192B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2014079304A1 (en) * | 2012-11-26 | 2014-05-30 | 中兴通讯股份有限公司 | Report creation method, device and system |
| WO2019178979A1 (en) * | 2018-03-21 | 2019-09-26 | 平安科技（深圳）有限公司 | Method for querying report data, apparatus, storage medium and server |
| CN109766529A (en) * | 2018-12-03 | 2019-05-17 | 中国联合网络通信集团有限公司 | A kind of generation method and equipment of report |
| CN110717319A (en) * | 2019-09-24 | 2020-01-21 | 车智互联（北京）科技有限公司 | Self-service report generation method and device, computing equipment and system |
| CN111178023A (en) * | 2019-12-30 | 2020-05-19 | 广东飞企互联科技股份有限公司 | Visual self-defined report design system |
Non-Patent Citations (2)
| Title |
|---|
| 基于Silverlight的柔性生产报表系统的设计;李广;王建林;赵利强;于涛;;计算机工程与设计(第07期);全文 * |
| 大型企业报表引擎的优化设计与实现;何拥军;曾文权;;计算机技术与发展(第08期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111881192A (en) | 2020-11-03 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111881192B (en) | Method, system, electronic equipment and storage medium for generating visual configuration report | |
| US20210240736A1 (en) | Method and Apparatus for Monitoring an In-memory Computer System | |
| US7213233B1 (en) | Modeling standards validation tool for use in enterprise architecture modeling | |
| US7424702B1 (en) | Data integration techniques for use in enterprise architecture modeling | |
| US20080127110A1 (en) | Method and system for generating a common trace data format | |
| CN109299178B (en) | Model application method and data analysis system | |
| CN108540351B (en) | Automatic testing method for distributed big data service | |
| CN112464632B (en) | Dynamic storage and conversion method for table style under excel report | |
| US20120303325A1 (en) | Inferring effects of configuration on performance | |
| CN114090580A (en) | Data processing method, device, equipment, storage medium and product | |
| CN110008104A (en) | A kind of management method of log information, system, equipment and storage medium | |
| CN116226112A (en) | Data cleaning method and device, storage medium and electronic equipment | |
| CN116560626A (en) | Data processing method, system, equipment and storage medium based on custom rules | |
| CN111666344A (en) | Heterogeneous data synchronization method and device | |
| US20140114728A1 (en) | Method and system for database benchmarking | |
| CN113703755A (en) | Code generation method and code generation device | |
| CN110175917B (en) | Device and method for parameter graphical processing | |
| CN111580733A (en) | Task processing method and device, computing equipment and medium | |
| CN114996319B (en) | Data processing method, device and equipment based on rule engine and storage medium | |
| CN114297074A (en) | Method for realizing automatic testing of functions, interfaces and performances based on dynamic configuration | |
| CN114547106A (en) | Data query method and device, storage medium and computer system | |
| CN114443427A (en) | Cloud resource efficiency evaluation method based on big data analysis | |
| CN115599781A (en) | Calling logic display method, service system and electronic equipment | |
| CN112134927A (en) | Power grid data exchange platform and data exchange method based on plug-in mode | |
| CN104040537A (en) | Systems and methods of automatic generation and execution of database queries |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |