CN115658720A - Method and system for processing custom report - Google Patents
Method and system for processing custom report Download PDFInfo
- Publication number
- CN115658720A CN115658720A CN202211225061.9A CN202211225061A CN115658720A CN 115658720 A CN115658720 A CN 115658720A CN 202211225061 A CN202211225061 A CN 202211225061A CN 115658720 A CN115658720 A CN 115658720A
- Authority
- CN
- China
- Prior art keywords
- report
- self
- configuration information
- user
- server
- 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.)
- Pending
Links
Images
Abstract
The invention discloses a processing method and a system of a user-defined report, wherein the method is executed by a server and comprises the following steps: acquiring a report to be processed and a self-defined configuration from a browser; and analyzing according to the self-defined configuration to obtain configuration information, and processing the report to be processed based on the configuration information to generate a self-defined report. The invention can generate the self-defined report according to the requirement of the client, so that the report is not limited to a specific type any more, the types and the generation modes of the report are enriched, and the invention has better universality.
Description
Technical Field
The invention relates to a processing method and a processing system of a self-defined report, and belongs to the technical field of self-defined reports.
Background
The early-start report tool software is basically characterized in that a data source and a strip type grouping statistical model are used for drawing a report in a control dragging mode, a simple form report and a single-chip cross report can be completed under the condition of no coding, and data are concentrated in a database and can be shared. The report tool takes SQL/OLAP as a theoretical basis and can automatically make reports based on a database. The report tool is characterized in that the main editing interface is in a strip shape, and the whole editing interface is formed by a plurality of horizontal strip areas. The report made by the traditional report tool has weak display capability and cannot meet the requirements of users.
In general, the report forms need customized development and have the problems of difficult development, difficult maintenance, complex modification, high cost and the like.
Disclosure of Invention
The invention aims to overcome the defects in the prior art and provide a processing method of a self-defined report, which can generate the self-defined report according to the needs of a client, so that the report is not limited to a specific type any more, the types and the generation modes of the report are enriched, and the method has better universality. In order to achieve the purpose, the invention is realized by adopting the following technical scheme:
in a first aspect, the present invention provides a method for processing a custom report, including:
acquiring a report to be processed and a self-defined configuration from a browser;
and analyzing according to the self-defined configuration to obtain configuration information, processing the report to be processed based on the configuration information, and generating the self-defined report.
With reference to the first aspect, further, the customized configuration includes: self-defining a report name, self-defining an Excel report template, self-defining SQL, self-defining query conditions and self-defining a report list page.
With reference to the first aspect, further, the generating a self-defined report includes:
generating a self-defined report list page;
matching and displaying the configuration information of the user-defined SQL with a user-defined report list page to generate a user-defined query list;
and matching the user-defined query list with the user-defined Excel report template to generate a user-defined Excel report.
With reference to the first aspect, further, the generating a self-defined report list page includes the following steps:
the server maps a self-defined report list page of the database according to the browser menu ID to obtain configuration information of the self-defined report list page;
and the server assembles the list page of the report to be processed according to the configuration information of the self-defined report list page to obtain page configuration information, and returns the page configuration information to the browser.
With reference to the first aspect, further, the generating a custom report list page further includes:
and the browser constructs and displays according to the page configuration information, generates a self-defined report list page, and displays the page field and the query field of the self-defined report list page.
With reference to the first aspect, further, the generating a custom query list includes the following steps:
the server maps the user-defined query conditions of the database according to the query conditions to obtain configuration information of the user-defined query conditions;
the server constructs a new SQL according to the SOL and the configuration information of the user-defined query condition;
the server obtains configuration information of the user-defined SQL according to the user-defined SQL of the new SQL mapping database, and returns the configuration information of the user-defined SQL to the browser;
and the server matches the configuration information of the user-defined SQL with the page configuration information to generate a user-defined query list and returns the user-defined query list to the browser.
With reference to the first aspect, further, the generating a custom Excel report includes the following steps:
the server maps the user-defined query conditions of the database according to the query conditions to acquire configuration information of the user-defined query conditions;
the server constructs a new SQL according to the SOL and the configuration information of the user-defined query condition;
the server acquires configuration information of the custom SQL according to the custom SQL of the new SQL mapping database;
the server root query condition maps a related self-defined Excel report template in the file server to obtain a self-defined export template;
and the server combines the configuration information of the user-defined SQL with the user-defined export template, constructs a user-defined Excel report and returns the report to the browser.
In a second aspect, the present invention provides a system for processing a self-defined report, including:
an acquisition module: the system comprises a browser, a report form generation module and a configuration generation module, wherein the browser is used for acquiring a report form to be processed and a self-defined configuration from the browser;
a generation module: the self-defined report form generation device is used for analyzing according to the self-defined configuration to obtain configuration information, processing the report form to be processed based on the configuration information and generating the self-defined report form.
In a third aspect, the present invention provides a computing device comprising a processor and a storage medium;
the storage medium is used for storing instructions;
the processor is configured to operate in accordance with the instructions to perform the steps of the method of the first aspect.
In a fourth aspect, the invention provides a computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, performs the steps of the method of the first aspect.
Compared with the prior art, the processing method and the system for the user-defined report provided by the embodiment of the invention have the beneficial effects that:
the method comprises the steps of obtaining a report to be processed and self-defined configuration from a browser; the method and the system can facilitate the flexible addition of the report forms required by the client to process and the flexible addition of the self-defined configuration by the client;
the method comprises the steps of analyzing according to self-defined configuration to obtain configuration information, processing a report to be processed based on the configuration information, and generating a self-defined report; the method and the device can generate the self-defined report according to the client requirements, so that the report is not limited to a specific type any more, the types and the generation modes of the report are enriched, and the method and the device have better universality.
Drawings
Fig. 1 is a flowchart of a method for processing a custom report in embodiment 1 of the present invention;
fig. 2 is a schematic diagram of a customized configuration of a method for processing a customized report according to embodiment 1 of the present invention.
Detailed Description
The invention is further described below with reference to the accompanying drawings. The following examples are only for illustrating the technical solutions of the present invention more clearly, and the protection scope of the present invention is not limited thereby.
The first embodiment is as follows:
as shown in fig. 1, an embodiment of the present invention provides a method for processing a custom report, which is executed by a server, and includes:
acquiring a report to be processed and a self-defined configuration from a browser;
and analyzing according to the self-defined configuration to obtain configuration information, and processing the report to be processed based on the configuration information to generate a self-defined report.
The method comprises the following specific steps:
step 1: and acquiring the report to be processed from the browser.
The invention can facilitate the clients to flexibly add and process the reports required by the clients through the browser.
Step 2: and acquiring the customized configuration from the browser.
As shown in FIG. 2, the custom configuration includes: self-defining report names, self-defining Excel report templates, self-defining SQL, self-defining query conditions and self-defining report list pages.
The user-defined Excel report template comprises Excel styles and field corresponding relations.
The browser provided by the invention can facilitate the flexible addition of user-defined configuration by a client.
And step 3: and analyzing according to the self-defined configuration to obtain configuration information, and processing the report to be processed based on the configuration information to generate a self-defined report.
Step 3.1: and generating a self-defined report list page.
And the server maps the self-defined report list page of the database according to the browser menu ID to obtain the configuration information of the self-defined report list page.
And the server assembles the list page of the report to be processed according to the configuration information of the self-defined report list page to obtain page configuration information, and returns the page configuration information to the browser.
And the browser constructs and displays according to the page configuration information, generates a self-defined report list page, and displays the page field and the query field of the self-defined report list page.
Step 3.2: and matching and displaying the configuration information of the user-defined SQL with a user-defined report list page to generate a user-defined query list.
And the server maps the user-defined query conditions of the database according to the query conditions to obtain the configuration information of the user-defined query conditions.
And the server constructs a new SQL according to the SOL and the configuration information of the user-defined query condition.
And the server obtains the configuration information of the user-defined SQL according to the user-defined SQL of the new SQL mapping database, and returns the configuration information of the user-defined SQL to the browser.
And the server matches the configuration information of the user-defined SQL with the page configuration information to generate a user-defined query list and returns the user-defined query list to the browser.
Step 3.3: and matching the user-defined query list with the user-defined Excel report template to generate a user-defined Excel report.
And the server maps the user-defined query conditions of the database according to the query conditions to acquire the configuration information of the user-defined query conditions.
And the server constructs a new SQL according to the SOL and the configuration information of the user-defined query condition.
And the server acquires the configuration information of the custom SQL according to the custom SQL of the new SQL mapping database.
And the server root inquires the condition mapping file server related self-defined Excel report templates to obtain self-defined export templates.
And the server combines the configuration information of the user-defined SQL with the user-defined export template, constructs a user-defined Excel report and returns the report to the browser.
The invention can generate the self-defined report according to the client requirement, so that the report is not limited to a specific type any more, the types and the generation modes of the report are enriched, and the method has better universality.
Example two:
the embodiment of the invention provides a processing system for a user-defined report, which comprises:
an acquisition module: the system comprises a browser, a report form generation module and a configuration generation module, wherein the browser is used for acquiring a report form to be processed and a self-defined configuration from the browser;
a generation module: the self-defined report form generation device is used for analyzing according to the self-defined configuration to obtain configuration information, processing the report form to be processed based on the configuration information and generating the self-defined report form.
Example three:
the embodiment of the invention provides a computing device, which comprises a processor and a storage medium;
the storage medium is to store instructions;
the processor is configured to operate in accordance with the instructions to perform the steps of the method of embodiment one.
Example four:
embodiments of the present invention also provide a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the steps of the method according to one embodiment.
As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
The above description is only a preferred embodiment of the present invention, and it should be noted that, for those skilled in the art, several modifications and variations can be made without departing from the technical principle of the present invention, and these modifications and variations should also be regarded as the protection scope of the present invention.
Claims (10)
1. A processing method of a self-defined report is characterized in that the processing method is executed by a server and comprises the following steps:
acquiring a report to be processed and a self-defined configuration from a browser;
and analyzing according to the self-defined configuration to obtain configuration information, and processing the report to be processed based on the configuration information to generate a self-defined report.
2. The method for processing the customized report according to the claim 1, wherein the customized configuration comprises: self-defining report names, self-defining Excel report templates, self-defining SQL, self-defining query conditions and self-defining report list pages.
3. The method for processing the self-defined report according to claim 2, wherein the generating the self-defined report comprises:
generating a self-defined report list page;
matching and displaying the configuration information of the user-defined SQL with a user-defined report list page to generate a user-defined query list;
and matching the user-defined query list with the user-defined Excel report template to generate a user-defined Excel report.
4. The method for processing the self-defined report according to the claim 3, wherein the step of generating the self-defined report list page comprises the following steps:
the server maps a self-defined report list page of the database according to the browser menu ID to obtain configuration information of the self-defined report list page;
and the server assembles the list page of the report to be processed according to the configuration information of the self-defined report list page to obtain page configuration information, and returns the page configuration information to the browser.
5. The method for processing the custom report according to claim 4, wherein the generating a custom report list page further comprises:
and the browser constructs and displays according to the page configuration information, generates a self-defined report list page, and displays the page field and the query field of the self-defined report list page.
6. The method for processing the custom report according to claim 3, wherein the step of generating the custom query list comprises the following steps:
the server maps the user-defined query conditions of the database according to the query conditions to obtain configuration information of the user-defined query conditions;
the server constructs a new SQL according to the SOL and the configuration information of the user-defined query condition;
the server obtains configuration information of the user-defined SQL according to the user-defined SQL of the new SQL mapping database, and returns the configuration information of the user-defined SQL to the browser;
and the server matches the configuration information of the custom SQL with the page configuration information to generate a custom query list and returns the custom query list to the browser.
7. The method for processing the custom report according to claim 3, wherein the step of generating the custom Excel report comprises the following steps:
the server maps the user-defined query conditions of the database according to the query conditions to acquire configuration information of the user-defined query conditions;
the server constructs a new SQL according to the SOL and the configuration information of the user-defined query condition;
the server acquires configuration information of the custom SQL according to the custom SQL of the new SQL mapping database;
the server root query condition maps a related self-defined Excel report template in the file server to obtain a self-defined export template;
and the server combines the configuration information of the user-defined SQL with the user-defined export template, constructs a user-defined Excel report and returns the report to the browser.
8. A system for processing a custom report, comprising:
an acquisition module: the system comprises a browser, a report form processing module, a report form configuration module and a configuration module, wherein the report form processing module is used for acquiring a report form to be processed and a self-defined configuration from the browser;
a generation module: the self-defined report form generation device is used for analyzing according to the self-defined configuration to obtain configuration information, processing the report form to be processed based on the configuration information and generating the self-defined report form.
9. A computer device comprising a processor and a storage medium;
the storage medium is used for storing instructions;
the processor is configured to operate in accordance with the instructions to perform the steps of the method of any of claims 1~7.
10. A computer readable storage medium, having stored thereon a computer program, characterized in that the program, when executed by a processor, performs the steps of the method of any of claims 1~7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211225061.9A CN115658720A (en) | 2022-10-09 | 2022-10-09 | Method and system for processing custom report |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211225061.9A CN115658720A (en) | 2022-10-09 | 2022-10-09 | Method and system for processing custom report |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115658720A true CN115658720A (en) | 2023-01-31 |
Family
ID=84984901
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211225061.9A Pending CN115658720A (en) | 2022-10-09 | 2022-10-09 | Method and system for processing custom report |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115658720A (en) |
-
2022
- 2022-10-09 CN CN202211225061.9A patent/CN115658720A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| WO2019095424A1 (en) | Data acquisition method and device, storage medium and terminal | |
| CN102426609B (en) | Index generation method and index generation device based on MapReduce programming architecture | |
| CN108052635A (en) | A kind of heterogeneous data source unifies conjunctive query method | |
| CN109299074B (en) | Data verification method and system based on templated database view | |
| CN113378011B (en) | Construction method and system of complex product assembly digital twin body | |
| CN105279269A (en) | SQL generating method and system for supporting table free association | |
| CN111078094A (en) | Distributed machine learning visualization device | |
| CN109274742A (en) | A kind of internet of things data acquisition and supervisor control | |
| CN115576950A (en) | Report generation method based on JSON configuration file | |
| CN111401023B (en) | Report generation method, report generation device, server and storage medium | |
| CN108984156A (en) | A kind of software auto generating method and system for exempting from code development based on template | |
| CN112667598A (en) | Data model rapid construction system based on business demand change | |
| CN115658720A (en) | Method and system for processing custom report | |
| CN116303777A (en) | Real-time synchronous replication method and system between heterogeneous databases | |
| CN111190587A (en) | Method and system for automatically generating engineering front-end code based on JDBC | |
| CN110334001A (en) | A kind of method and apparatus that batch automatically generates echo test | |
| CN115098567A (en) | Low code platform data transmission method based on BI platform | |
| CN112115694A (en) | Simulation report generation method and device based on multi-element data structure | |
| CN111144755A (en) | Scientific research instrument experiment result traceability management system and method | |
| CN110866005A (en) | Internet of things data acquisition management method and system, storage medium and terminal | |
| CN116911642B (en) | Multi-dimensional multi-state oriented hydroelectric generating set equipment index calculation system and method | |
| CN112767516B (en) | Method and device for determining dot diagram of nuclear power test procedure and computer equipment | |
| CN111126015B (en) | Report form compiling method and equipment | |
| CN114385738A (en) | Report data set visualization construction method, device and system based on hydropower information model | |
| CN117234503A (en) | Method, device, equipment and medium for generating command large screen |
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 |