A method for quickly and automatically constructing multi-dimensional reports using interception technology

Abstract

The present invention relates to the field of information technology, and more specifically, relates to a method for quickly and automatically constructing a multi-dimensional report by using an interception technology. Including the following steps: S1. Obtain the report statistics request, monitor the Ajax request at the front end and configure the Mybatis interceptor plug-in at the back end, obtain the business request parameters and executed SQL, and write them into the Redis cache and database; S2. Intercept and obtain the business SQL, and judge Redis Whether there is a business SQL in the cache, if it does not exist, simulate a business request through the acquired business request parameters, get the executed business SQL, and write it into the Redis cache; if it exists, read the business SQL from the Redis cache; S3. Combine the report statistics request parameters to assemble the statistical SQL, execute the statistical SQL and return the result, the front end obtains the returned data set for group calculation, and calls the report component for display. The invention is easy to use and easy to integrate, and developers do not need to fill in statistical SQL or change the logic of back-end codes.

Description

technical field [0001] The present invention relates to the field of information technology, and more specifically, relates to a method for quickly and automatically constructing a multi-dimensional report by using an interception technology. Background technique [0002] At present, each report module [defect management] data statistics display contains multiple fields: defect number, voltage level, defect level, location, function, location, device name, defect appearance, defect status, discovery time, discovery team, defect elimination time, Defect elimination team, inspection time, acceptance department, defect source and other fields. Based on the existing data list, users cannot generate, customize, and modify the reports they want. According to the traditional approach, each module in the project needs to develop a separate table for data summary. This traditional method has the following problems: 1. Developers need to write statistical SQL; 2. The back-end code lo...

AI Technical Summary

Problems solved by technology

Based on the existing data list, users cannot generate, customize, and modify the reports they want

According to the traditional approach, each module in the project needs to develop a separate table for data summary. This traditional method has the following problems: 1. Developers need to write statistical SQL; 2. The back-end code logic needs to be changed; 3 .Front-end page display workload increased; 4. Multiple modules developed multiple times; 5. Project development costs increased

Images