CN112329410A - Graphical report batch generation tool - Google Patents
Graphical report batch generation tool Download PDFInfo
- Publication number
- CN112329410A CN112329410A CN202011190829.4A CN202011190829A CN112329410A CN 112329410 A CN112329410 A CN 112329410A CN 202011190829 A CN202011190829 A CN 202011190829A CN 112329410 A CN112329410 A CN 112329410A
- Authority
- CN
- China
- Prior art keywords
- report
- flow
- echarts
- service unit
- graphical
- 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
- 238000000034 method Methods 0.000 claims description 5
- 238000007619 statistical method Methods 0.000 claims description 2
- 238000004806 packaging method and process Methods 0.000 abstract 1
- 238000004458 analytical method Methods 0.000 description 3
- 238000009795 derivation Methods 0.000 description 3
- 238000012423 maintenance Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 241001272720 Medialuna californiensis Species 0.000 description 1
- 230000002776 aggregation Effects 0.000 description 1
- 238000004220 aggregation Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000013079 data visualisation Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000012447 hatching Effects 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
Images
Classifications
-
- 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/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Tourism & Hospitality (AREA)
- Health & Medical Sciences (AREA)
- Operations Research (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Economics (AREA)
- Data Mining & Analysis (AREA)
- Quality & Reliability (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- General Engineering & Computer Science (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The invention provides a tool for generating graphical reports in batches. Mainly through a report request unit of the tool, a user can independently input condition parameters to generate a report request; analyzing and integrating the report request of the user through a report micro-service unit of the tool, reading the Echarts style configuration of the report, and sending data to an Echarts service; and generating a flow chart through an Echarts service unit, packaging all files into a tar.gz format, returning the flow chart to the front end in a file flow mode, and downloading the flow chart through a browser. The technical scheme is realized by a program in a unified way by arranging the charging modes of various dimensions of the circuit flow, so that the workload of report maintainers is simplified; the report can visually show the conditions of the peak value, the utilization rate and the like of the flow data in a chart form; one-key batch report generation is not needed, the same type of report is not needed to be generated repeatedly, and repeated work is reduced.
Description
Technical Field
The invention relates to the technical field of computers, in particular to a tool for generating graphical reports in batches.
Background
The circuit flow data is one of the cores of network management data, the circuit state can be effectively monitored by collecting, storing and analyzing the circuit flow data in real time, and simultaneously, data such as user bandwidth use intensive time, bandwidth overall utilization rate, flow loop ratio and the like can be obtained through analyzing and calculating the flow.
Because the part of work needs to summarize, analyze and calculate the flow data in different dimensions, the technical requirements on users are high, and the work is difficult to be completed by people without a certain database foundation; meanwhile, at present, data directly inquired needs to be manually exported to excel, time and labor are consumed, but the generated report is often not attractive, and the readability is not high.
In view of the above problems, no effective solution has been proposed.
Disclosure of Invention
The invention aims to provide a tool for generating a user flow multi-dimensional graphical report in batches, through which network management maintenance personnel can customize an individual report according to self requirements, visually display the network utilization rate and the charging condition through chart data, and can export the report in batches for later use.
In order to realize the purpose, the following scheme is provided:
a graphical report batch generation tool, comprising:
the report request unit, the report micro-service unit and the Echarts service unit;
the report request unit can enable a user to independently input the condition parameters and generate a report request; the report micro-service unit is used for analyzing and integrating the report request of the user, reading the Echarts style configuration of the report and sending data to the Echarts service unit; and the Echarts service unit generates a flow chart, packs all files into a tar.gz format, returns the files to the front end in a file flow mode, and downloads the files through a browser.
Optionally, the flow graph generated by the Echarts service unit may be stored in a local directory, and the flow graph may be inserted into the sheet page corresponding to the excel according to different conditional ways.
Optionally, the report request is input through a browser page entering the report requesting unit.
Optionally, the flow chart integrated by the report micro-service unit analysis may be customized by modifying the picture style control file.
Optionally, the flow chart analyzed and integrated by the report micro-service unit may be displayed as a bar chart and a line chart, and after the mouse is moved to the graphical interface, the statistical result is displayed in a floating manner.
Alternatively, the tool may be used for statistical analysis of circuit flow.
Optionally, the tool may count the specified billing methods for the specified circuit groups.
The embodiment of the invention is realized by a program in a unified way by arranging the charging modes of various dimensions of the circuit, thereby simplifying the workload of report maintainers; the report can visually show the conditions of the peak value, the utilization rate and the like of the flow data in a chart form; one-key batch report generation is not needed, the same type of report is not needed to be generated repeatedly, and repeated work is reduced.
Drawings
In order to make the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the embodiments of the present invention are further described in detail below with reference to the accompanying drawings. The exemplary embodiments and descriptions of the present invention are provided to explain the present invention, but not to limit the present invention.
FIG. 1 is a schematic flow chart of a batch generation tool for graphical reports according to an embodiment of the present invention;
FIG. 2 is a browser page parameter input interface of a report requesting unit of the graphical report batch generation tool in the embodiment of the present invention.
FIG. 3 is a node name of the province to which the circuit of the graphical report batch generation tool belongs in the embodiment of the present invention.
FIG. 4 is a circuit billing method of the batch generation tool for graphical reports in the embodiment of the present invention.
FIG. 5 is a circuit query type of a graphical report batch generation tool in an embodiment of the present invention.
FIG. 6 is a graph illustrating single-circuit group traffic statistics for a batch generation tool for graphical reports in an embodiment of the present invention.
FIG. 7 is a floating index display of the batch generation tool for graphical reports in an embodiment of the present invention.
FIG. 8 is a graph illustrating single-circuit group traffic statistics for a batch generation tool for graphical reports in an embodiment of the present invention.
FIG. 9 is a total circuit group traffic statistics graph of a graphical report batch generation tool in an embodiment of the present invention.
FIG. 10 is a total circuit group traffic statistics chart of the batch generation tool for graphical reports in an embodiment of the present invention.
FIG. 11 is a single circuit group export graph of a batch generation tool for graphical reports in accordance with an embodiment of the present invention.
Fig. 12 is a graph illustrating a single circuit group traffic statistic viewed in an excel graphical report batch generation tool according to an embodiment of the present invention.
FIG. 13 is a general circuit derivation diagram of the batch generation tool for graphical reports in an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the embodiments of the present invention are further described in detail below with reference to the accompanying drawings. The exemplary embodiments and descriptions of the present invention are provided to explain the present invention, but not to limit the present invention.
The tool comprises a report request unit 101, a report micro-service unit 102 and an Echarts service unit 103; the method mainly comprises the following steps:
a report request unit 101, which is used for a user to independently input condition parameters and generate a report request;
the report micro-service unit 102 analyzes and integrates the report request of the user, reads the report Echarts style configuration, and sends data to the Echarts service unit 103;
the Echarts service unit 103 generates a flow chart, packages all files into a tar.gz format, returns the flow chart to the front end in a file flow mode, and downloads the flow chart through a browser.
In the following, taking a scheme of a tool for generating circuit traffic graphical reports in batches as an example, terms such as traffic, node circuit group, charging mode, Echarts and the like in the scheme have meanings as follows:
1) flow rate: the flow data referred to in this patent is primarily indicative of circuit flow
2) And (3) node: a circuit is usually connected from an A-terminal to a B-terminal, the A-terminal node being the relative start node of the circuit and the B-terminal node being the relative end node of the circuit
3) And (3) charging mode: a way of charging the operator for circuit traffic, e.g.
b1 monthly 95 billing: the 95 billing is to count the flow in a settlement time (usually one month) every 5 minutes, and take the highest value of the flow as a point. Such a month will result in many flow peaks. The 5% point of high flow in the graph is then removed and the cost calculated as the remaining (100-5)% of the flow.
b2 Peak billing
b3 mean value billing
b4 aggregated Single Circuit monthly 95 billing
b5 daily 95 charge
b6 aggregation single circuit half-moon peak charging
b1-b6 is an id set by the tool for billing mode, used for code inquiry and processing.
4) A circuit group: a circuit group comprises a plurality of circuits, the circuit group and the circuits are in one-to-many relationship, and the circuit group has uniqueness.
5)Echarts
Apache ECharts, an open source project donated by hundredths to the Apache open source fund, is currently hatching. ECharts is a Javascript-based database of data visualization charts.
Firstly, a report request unit:
the user can jump to a user flow multi-dimensional data analysis page by logging in a network management system, and the authority verification of the user is completed through the network management system.
In the page, a user can independently select report generation conditions, the A end node defaults to a necessary option and has a necessary deadline, and if the A end node does not select the report, a prompt box pops up when a query button is clicked. As shown in figure 2.
1. A/B-end node
The a/B end node is the node name under the province to which the circuit belongs, and the circuit scope can be limited through the A, B end node. As shown in fig. 3.
2. Charging mode
By clicking the charging mode drop-down box, the circuit flow charging mode can be selected, the currently provided charging enumeration values are six charging types shown in figure 4, and if not, the flow indexes of all six charging modes of the specified circuit are inquired by default.
3. Type of query
The query type drop-down box can specify the report statistic type, and if the report statistic type is a single circuit group, the specified charging mode of the specified circuit group is queried; if the total expense circuit group is the total expense circuit group, the specified charging mode of all the circuit groups is inquired. (note: the circuit group includes a plurality of circuits, the circuits of a circuit group may belong to the same type on the node, or may belong to the same type on the circuit charging mode, and the specific classification mode is divided according to the operator specified standard), see fig. 5.
4. Expiration date
The expiration date comprises a start input box and an end input box, the corresponding time end is selected through the calendar, the date validity check is carried out, and if the end date cannot be smaller than the start date, the date validity check is carried out.
The date currently supports a minimum granularity of months.
Report form micro-service unit
And clicking the query button to analyze and integrate, and displaying the flow statistical results of all the circuit groups meeting the query conditions on a page.
1. Single circuit group flow statistical pattern
And presenting a flow histogram, a flow-to-peak ratio and a bandwidth utilization rate of each circuit group according to different charging modes. And the month 95 charging is selected by default, other charging modes such as peak charging are clicked, and a flow histogram and a line graph counted according to peak charging dimensions can be checked. See figure 6.
1) Floating index display
When the mouse moves to the histogram, the indexes such as the charging value, the peak value, the utilization rate and the like are displayed in a floating mode. See fig. 7.
2) Statistical chart
And displaying the charging value and the peak value of the circuit group summarized according to the month dimension, namely the utilization rate index, below the histogram. And counting according to the dimension of the charging type as the flow statistical histogram, clicking different charging modes on the page, and displaying a corresponding flow statistical table. See figure 8.
2. Total circuit group flow statistics graph
After the query condition is filled in, clicking the query, and displaying the flow statistical result of the total circuit group on the interface. And displaying monthly 95 charging by default, clicking other charging modes, and checking a flow statistics histogram and a utilization rate line chart under corresponding dimensions. And after the mouse is moved to the graphical interface, floating and displaying the flow index statistical result. See fig. 9.
And displaying a flow report under the corresponding charging mode dimension in a form of a chart under the flow statistical histogram, wherein the report of the total circuit group has little difference with the single circuit group on a statistical field, but basically performs summary statistics on the single circuit group under the query condition. As shown in fig. 10.
Triple, Echarts service unit
And the generated data in the specified format is sent to an Echarts service unit for data export, and the user exports the report statistical result to an excel table, so that the maintenance and other content analysis are facilitated.
1) Single circuit group export
And a derivation button is arranged at the upper right part of the single circuit group flow statistical chart of the page, and after clicking, a report statistical result of the circuit group can be derived. As shown in fig. 11.
Different sheet pages are switched, and the statistical results of the flow reports with different charging mode dimensions can be checked. As shown in fig. 12.
2) Total circuit group derivation
Clicking the export button next to the query button can export the whole amount of circuits within the range defined by the query condition.
And the derived tar.gz packet contains all circuit group flow statistical forms meeting the query conditions. As shown in fig. 13.
Each excel corresponds to a flow statistical report of a single circuit group, and the report style and format are consistent with the report style derived from the single circuit group.
Fourth, flow graph generation configuration
And generating a picture style of the graphical flow statistic result in the excel, and supporting personalized customization. Only the picture style control file needs to be modified.
The file is located under an option directory of the report micro-service unit, the file name is option.
color: color of the pattern
title: title is a style
Legend: illustration of the drawings
xAxis/yAxis: scale, name, etc. of the horizontal and vertical axes
series: echarts chart styles including color, designated bar chart, line chart, pie chart, etc.; specifying data variables to store generated charts
The method includes the steps that a series part in option. ftl of a configuration file needs to be matched with a code for use, data in the series needs to be processed through a program to generate data in a designated json format, so if the series part needs to be modified, for example, fields are added, the code needs to be modified at the same time, but if a field needs to be removed, the code can be directly deleted in the option. ftl file, and the program does not need to be modified. The configuration of the chart styles in the configuration file, such as tile and color, is modified, and the configuration analysis is carried out in the Echarts service part, so that java codes do not need to be modified, and the service is restarted and the flow report is regenerated.
The technical scheme provided by the embodiment of the invention has the following beneficial technical effects: through the interface operation mode, a report is generated, so that the report is convenient to check and the operation is simplified. And a report generation scheme with multiple dimensions is provided, and different requirements are met. The function of displaying the report on the page is available, and the report can be exported to excel. And moreover, the report of excel is exported, and the picture format is added, so that the functions of the report are richer. The report style is controlled through the configuration file, and the report modification workload is simplified.
The above examples are only intended to illustrate the technical solution of the present invention, but not to limit it; although the present 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 solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.
Claims (7)
1. A graphical report batch generation tool, comprising:
the report request unit, the report micro-service unit and the Echarts service unit;
the report request unit can enable a user to independently input the condition parameters and generate a report request; the report micro-service unit is used for analyzing and integrating the report request of the user, reading the Echarts style configuration of the report and sending data to the Echarts service unit; and the Echarts service unit generates a flow chart, packs all files into a tar.gz format, returns the files to the front end in a file flow mode, and downloads the files through a browser.
2. The graphical report batch generation tool according to claim 1, further comprising:
the flow chart generated by the Echarts service unit can be stored in a local directory, and the flow chart can be inserted into a sheet page corresponding to the excel according to different conditional modes.
3. The graphical report batch generation tool according to claim 1, wherein:
the report request is input through a browser page entering the report request unit.
4. The graphical report batch generation tool according to claim 1, wherein:
the report micro-service unit analyzes the integrated flow chart and can carry out personalized customization by modifying the picture style control file.
5. The graphical report batch generation tool according to claim 1, wherein:
the flow chart analyzed and integrated by the report micro-service unit can be displayed by a bar chart and a line chart, and after the mouse is moved to the graphical interface, the statistical result is displayed in a floating mode.
6. The graphical report batch generation tool according to claim 1, wherein:
the tool may be used for statistical analysis of circuit flow.
7. The graphical report batch generation tool according to claim 1, wherein:
the tool may account for a specified billing method for a specified circuit group.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011190829.4A CN112329410A (en) | 2020-10-30 | 2020-10-30 | Graphical report batch generation tool |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011190829.4A CN112329410A (en) | 2020-10-30 | 2020-10-30 | Graphical report batch generation tool |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112329410A true CN112329410A (en) | 2021-02-05 |
Family
ID=74297502
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011190829.4A Pending CN112329410A (en) | 2020-10-30 | 2020-10-30 | Graphical report batch generation tool |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112329410A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115328486A (en) * | 2022-10-17 | 2022-11-11 | 北京安盟信息技术股份有限公司 | Echarts calling and packaging method, device, medium and equipment based on dynamic incoming data |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO1999015976A1 (en) * | 1997-09-26 | 1999-04-01 | Devine Carol Y | Integrated proxy interface for web based report requester tool set |
| US20060112123A1 (en) * | 2004-11-24 | 2006-05-25 | Macnica, Inc. | Spreadsheet user-interfaced business data visualization and publishing system |
| CN106682218A (en) * | 2016-12-30 | 2017-05-17 | 冶金自动化研究设计院 | Industrial enterprise Web data graphical system and generation method |
| CN111259643A (en) * | 2019-12-10 | 2020-06-09 | 深圳市远行科技股份有限公司 | Method and equipment for generating graphical report |
-
2020
- 2020-10-30 CN CN202011190829.4A patent/CN112329410A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO1999015976A1 (en) * | 1997-09-26 | 1999-04-01 | Devine Carol Y | Integrated proxy interface for web based report requester tool set |
| US20060112123A1 (en) * | 2004-11-24 | 2006-05-25 | Macnica, Inc. | Spreadsheet user-interfaced business data visualization and publishing system |
| CN106682218A (en) * | 2016-12-30 | 2017-05-17 | 冶金自动化研究设计院 | Industrial enterprise Web data graphical system and generation method |
| CN111259643A (en) * | 2019-12-10 | 2020-06-09 | 深圳市远行科技股份有限公司 | Method and equipment for generating graphical report |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115328486A (en) * | 2022-10-17 | 2022-11-11 | 北京安盟信息技术股份有限公司 | Echarts calling and packaging method, device, medium and equipment based on dynamic incoming data |
| CN115328486B (en) * | 2022-10-17 | 2023-02-03 | 北京安盟信息技术股份有限公司 | Echarts calling and packaging method, device, medium and equipment based on dynamic incoming data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111538731B (en) | Automatic report generation system for industrial data | |
| CN109254901B (en) | A kind of Monitoring Indexes method and system | |
| CN102279848A (en) | Method and device for generating report template | |
| CN113362024B (en) | Application program development multi-module collaboration system based on block chain | |
| CN110851667A (en) | Integrated analysis method and tool for multi-source large data | |
| CN113642299A (en) | One-key generation method based on power grid statistical form | |
| CN112162980A (en) | Data quality control method and system, storage medium and electronic equipment | |
| CN113590607A (en) | Electric power marketing report realization method and system based on report factor | |
| CN112329410A (en) | Graphical report batch generation tool | |
| CN112527857A (en) | Multi-angle line loss visual data analysis platform based on intelligent electric meter | |
| CN112163017A (en) | Knowledge mining system and method | |
| CN115329728A (en) | Working data low-acquisition high-multiplexing cooperative office report communication system and method | |
| CN113255307A (en) | Intelligent reporting method and system for power system | |
| CN111209329B (en) | Dynamic analysis method, device and system based on full-traffic price and cost transaction path | |
| CN111401023B (en) | Report generation method, report generation device, server and storage medium | |
| CN116389486B (en) | Method and system for realizing operation analysis of multiple cloud resources | |
| CN117009610A (en) | K line graph visualization system and method based on power data | |
| CN103793519A (en) | Automatic tool supporting exportation of mass data | |
| CN117035532A (en) | Electric power marketing management system and method based on marketing index multidimensional linkage analysis | |
| CN115409471A (en) | Automatic generation method and device for distribution network automation terminal machine account | |
| CN109669972A (en) | Generation method, device and the intelligent terminal of distribution load report | |
| CN114428813A (en) | Data statistics method, device, equipment and storage medium based on report platform | |
| CN113392290A (en) | Data monitoring method and device and server | |
| TW202326574A (en) | Method for planning production capacity allocation and planning apparatus | |
| CN110941608B (en) | Method, device and equipment for generating buried point analysis and funnel analysis report |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210205 |
|
| RJ01 | Rejection of invention patent application after publication |