CN104317943A - Graphical report displaying method and system for assessment system - Google Patents
Graphical report displaying method and system for assessment system Download PDFInfo
- Publication number
- CN104317943A CN104317943A CN201410602813.8A CN201410602813A CN104317943A CN 104317943 A CN104317943 A CN 104317943A CN 201410602813 A CN201410602813 A CN 201410602813A CN 104317943 A CN104317943 A CN 104317943A
- Authority
- CN
- China
- Prior art keywords
- data
- graphical
- list structure
- report
- xml format
- 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
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/80—Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
- G06F16/83—Querying
- G06F16/838—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/80—Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
- G06F16/83—Querying
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a graphical report displaying method and system for an assessment system. The graphical report displaying method includes the steps of 1, extracting assessment data and storing the assessment data in a table structure form; 2, searching the table structure in which the assessment data is stored, for data to be subjected to graphical report displaying, and packaging the searched data into XML-formatted (extensive markup language formatted) data; 3, setting graphical report styles on a JSP (java server page), selecting one graphical report style, calling FusionCharts plugins to analyze the XML-formatted data to generate a report, and displaying the generated report on the JSP. The graphical report displaying method and system has the advantages that assessment data comparison can be displayed visually and attractively, changes of the assessment data in a continuous period can also be displayed visually and attractively, the report and service tables are more readable, FusionCharts support displaying of various charts, data displaying in various scenarios is flexibly achieved, and the personal needs of users are greatly met.
Description
Technical field
The present invention relates to data drawing list field, particularly relate to a kind of graphical form methods of exhibiting and system of checking system.
Background technology
Along with the quickening of UNICOM's business development speed, excavate to improve and run potential 3G mobile network service, 4G mobile network service, make the transition good service provider, to delegate power a line, realize responsibility management and control, realize the fine management management acted freely, now all kinds of Developing channel and personnel are carried out to the examination of business aspect, thus the management and control realized operation cost, transfer relevant speciality line person works enthusiasm, therefore propose the concept of checking system.
Existing evaluation method, by examination responsible official, in monthly fixed time, in corresponding system, extract the detailed data of all kinds of income and development, manually carry out the calculating of achievement according to rule, then calculating and statistics are supplied to leader, the data so not only calculating, add up time-consuming but also reflect neither be very directly perceived, and now because there has been the existence of checking system, the extraction problem of all kinds of income development dataset can be solved, realize the examination to personnel and unit in systems in which.But for large enterprise, the data that checking system will relate to are a lot, thus make the graphical representation of data become a large difficult point.How intuitively the graphical representation of checking system directly affects accuracy and the Consumer's Experience of examination data, carry out attractive in appearancely the graphical representation of checking system, more and more important to relevant enterprise.
FusionCharts plug-in unit is the chart components of a Flash, may be used for making data animation chart, and it relies on good performance, a large amount of subtypes, plays the function of chart production in increasing web application.
Therefore, based on FusionCharts plug-in unit, the present invention proposes a kind of graphical form methods of exhibiting and system of checking system.
Summary of the invention
Technical matters to be solved by this invention is to provide a kind of graphical form methods of exhibiting of checking system, for solving the problem that examination data is not easily shown.
The technical scheme that the present invention solves the problems of the technologies described above is as follows: a kind of graphical form methods of exhibiting of checking system, comprising:
Step 1, extracts examination data, and is stored with the form of list structure by examination data;
Step 2, inquires the data need carrying out graphical form displaying, and the data encapsulation that inquiry obtains is become the data of XML format from the list structure storing examination data;
Step 3, arranges graphical report style in JSP, selects a kind of graphical report style, and calls FusionCharts plug-in unit the Data Analysis of XML format is generated as form, and shows the form generated in JSP.
Technical scheme of the present invention also comprises the graphical form display systems of checking system, comprising:
Data acquisition module, for extracting examination data, and stores examination data with the form of list structure;
Data conversion module, for inquiring the data need carrying out graphical form displaying in the list structure from storage examination data, and becomes the data of XML format by the data encapsulation that inquiry obtains;
Report generation module, for arranging graphical report style in JSP, selects a kind of graphical report style, and calls FusionCharts plug-in unit the Data Analysis of XML format is generated as form, and shows the form generated in JSP.
The invention has the beneficial effects as follows: pass through the present invention, comparison and the continuously change of examination data in a period of time of examination data can be represented directly perceived, attractive in appearancely, improve the readability of form and traffic table, FusionCharts supports representing of multiple pattern chart, solve representing of data under various scene flexibly, greatly meet the individual demand of user.
Accompanying drawing explanation
Fig. 1 is the schematic flow sheet of the graphical form methods of exhibiting of a kind of checking system of the present invention;
Fig. 2 is the structural representation of the graphical form display systems of a kind of checking system of the present invention;
Fig. 3 is the schematic flow sheet that in the embodiment of the present invention, basic data obtains;
Fig. 4 is the schematic flow sheet of graphical report generation in the embodiment of the present invention.
Embodiment
Be described principle of the present invention and feature below in conjunction with accompanying drawing, example, only for explaining the present invention, is not intended to limit scope of the present invention.
As shown in Figure 1, this gives a kind of graphical form methods of exhibiting of checking system, comprising:
Step 1, extracts examination data, and is stored with the form of list structure by examination data;
Step 2, inquires the data need carrying out graphical form displaying, and the data encapsulation that inquiry obtains is become the data of XML format from the list structure storing examination data;
Step 3, arranges graphical report style in JSP, selects a kind of graphical report style, and calls FusionCharts plug-in unit the Data Analysis of XML format is generated as form, and shows the form generated in JSP.
The major function of FusionCharts plug-in unit be the data encapsulation that will represent in xml file, then according to the figure presentation parameter selected, graphically reflect situation of change, the distribution situation of data intuitively with pie chart, histogram, broken line graph etc.
Wherein, described step 1 extracts examination data by writing SQL statement; Described step 2 inquires the data need carrying out graphical form displaying by writing SQL statement from the list structure storing examination data.
It is noted that the row title of described list structure is identical with the row title of the form will generated after the Data Analysis of XML format, to make when diagrammatic representation, without the need to secondary processing or few secondary processing, the efficiency that graphical form is shown can be ensured.
As shown in Figure 2, the present embodiment is the corresponding graphical form display systems giving a kind of checking system also, comprising:
Data acquisition module, for extracting examination data, and stores examination data with the form of list structure;
Data conversion module, for inquiring the data need carrying out graphical form displaying in the list structure from storage examination data, and becomes the data of XML format by the data encapsulation that inquiry obtains;
Report generation module, for arranging graphical report style in JSP, selects a kind of graphical report style, and calls FusionCharts plug-in unit the Data Analysis of XML format is generated as form, and shows the form generated in JSP.
This graphical form display systems is identical, as described below with the specific implementation process of above-mentioned graphical form methods of exhibiting.
One, the acquisition of basic data
The present embodiment needs the support of basic data (i.e. examination data), therefore needs special data acquisition platform.As shown in Figure 3, the acquisition process of basic data is: checking system writes sql statement by database, from gridding marketing system, through subsystem and BSS system, extract basic data, carry out achievement calculating based on basic data and dependency rule simultaneously, and basic data data and result of calculation all gather, and store with the form of list structure.The row title of this list structure should be tried one's best consistent with the form finally will shown, when displaying without the need to secondary processing or few secondary processing, just can ensure the efficiency of graphical report form showing.
Two, data conversion
FusionCharts receives only the data of xml form, so need the data first data encapsulation being become xml form before using.Namely, under the prerequisite possessed in basic data, need to write data query that SQL statement will represent graphical form out, be then packaged into the data of XML format.
1) write the SQL of inquiry report data, concrete example is as follows:
2) data encapsulation that sql inquires is become the data of xml form, example is as follows:
Three, form is shown
FusionCharts does not support self-defining graphical report style, therefore need to arrange graphical report style in JSP, the graphical report style that can arrange comprises histogram, district figure, 3D/2D pie chart, 3D/2D ring figure, areal map, storehouse figure, combines figure, candlestick chart, crater blasting and Gantt chart etc.
As shown in Figure 4, the Data Analysis of XML format is generated as form and shows and specifically comprise: JSP initiates request, call with the data of the XML format of list structure form storage, and perform initialize order, according to the gauge outfit of the acquisition request list structure of initiating, and transmit Metre variables to beforeFactory order, perform beforeFactory order, obtain the respective column of list structure, according to the related column of list structure, generating report forms, and the form generated is shown in JSP.Initialize initialization event, whether Flash and JS file that prompting user FusionCharts chart components is relevant etc. is ready, can create FusionCharts graph object, beforeFactory, be used for carrying out encapsulation xml file and data.
The example carrying out form displaying is as follows:
Above-mentioned example gives the gauge outfit, pattern, configuration parameter etc. of encapsulation image report form showing.
To sum up, the function of FusionCharts is described simply relative to document a lot of in prior art, and the present embodiment be by project under battle conditions in show to use FusionCharts can solve which problem and the chart that how better to support form represents simultaneously, meet the vision of user and actual business demand better.
The foregoing is only preferred embodiment of the present invention, not in order to limit the present invention, within the spirit and principles in the present invention all, any amendment done, equivalent replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (10)
1. a graphical form methods of exhibiting for checking system, is characterized in that, comprising:
Step 1, extracts examination data, and is stored with the form of list structure by examination data;
Step 2, inquires the data need carrying out graphical form displaying, and the data encapsulation that inquiry obtains is become the data of XML format from the list structure storing examination data;
Step 3, arranges graphical report style in JSP, selects a kind of graphical report style, and calls FusionCharts plug-in unit the Data Analysis of XML format is generated as form, and shows the form generated in JSP.
2. graphical form methods of exhibiting according to claim 1, is characterized in that, in described step 1, extracts examination data by writing SQL statement.
3. graphical form methods of exhibiting according to claim 1, is characterized in that, in described step 2, inquires the data need carrying out graphical form displaying by writing SQL statement from the list structure storing examination data.
4. graphical form methods of exhibiting according to claim 1, is characterized in that, described graphical report style comprises histogram, district figure, 3D/2D pie chart, 3D/2D ring figure, areal map, storehouse figure, combines figure, candlestick chart, crater blasting and Gantt chart.
5. graphical form methods of exhibiting according to claim 1, it is characterized in that, in described step 3, the Data Analysis of XML format is generated as form, specifically comprise: JSP initiates request, call with the data of the XML format of list structure form storage, and perform initialize order, according to the gauge outfit of the acquisition request list structure of initiating, and transmit Metre variables to beforeFactory order, perform beforeFactory order, obtain the respective column of list structure, according to the related column of list structure, generating report forms.
6. graphical form methods of exhibiting according to claim 5, is characterized in that, the row title of described list structure is identical with the row title of the form will generated after the Data Analysis of XML format.
7. a graphical form display systems for checking system, is characterized in that, comprising:
Data acquisition module, for extracting examination data, and stores examination data with the form of list structure;
Data conversion module, for inquiring the data need carrying out graphical form displaying in the list structure from storage examination data, and becomes the data of XML format by the data encapsulation that inquiry obtains;
Report generation module, for arranging graphical report style in JSP, selects a kind of graphical report style, and calls FusionCharts plug-in unit the Data Analysis of XML format is generated as form, and shows the form generated in JSP.
8. graphical form display systems according to claim 7, is characterized in that, described data acquisition module, and it extracts examination data by writing SQL statement;
Described data conversion module, it inquires the data need carrying out graphical form displaying by writing SQL statement from the list structure storing examination data.
9. graphical form display systems according to claim 7, is characterized in that, described graphical report style comprises histogram, district figure, 3D/2D pie chart, 3D/2D ring figure, areal map, storehouse figure, combines figure, candlestick chart, crater blasting and Gantt chart.
10. graphical form display systems according to claim 7, it is characterized in that, in described data conversion module, the Data Analysis of XML format is generated as form, specifically comprise: JSP initiates request, call with the data of the XML format of list structure form storage, and perform initialize order, according to the gauge outfit of the acquisition request list structure of initiating, and transmit Metre variables to beforeFactory order, perform beforeFactory order, obtain the respective column of list structure, according to the related column of list structure, generating report forms;
The row title of described list structure is identical with the row title of the form will generated after the Data Analysis of XML format.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410602813.8A CN104317943A (en) | 2014-10-31 | 2014-10-31 | Graphical report displaying method and system for assessment system |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410602813.8A CN104317943A (en) | 2014-10-31 | 2014-10-31 | Graphical report displaying method and system for assessment system |
Publications (1)
Publication Number | Publication Date |
---|---|
CN104317943A true CN104317943A (en) | 2015-01-28 |
Family
ID=52373175
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201410602813.8A Pending CN104317943A (en) | 2014-10-31 | 2014-10-31 | Graphical report displaying method and system for assessment system |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN104317943A (en) |
Cited By (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104657452A (en) * | 2015-02-06 | 2015-05-27 | 重庆师范大学 | Spatial switching system for pre-pregnancy eugenic archive data |
CN106484783A (en) * | 2016-09-19 | 2017-03-08 | 济南浪潮高新科技投资发展有限公司 | A kind of graphical representation method of report data |
CN107133203A (en) * | 2016-02-29 | 2017-09-05 | 阿里巴巴集团控股有限公司 | A kind of chart generation method and device |
CN107643970A (en) * | 2017-09-13 | 2018-01-30 | 曙光信息产业(北京)有限公司 | What thermal map configured shows method and shows system |
CN108172269A (en) * | 2017-12-15 | 2018-06-15 | 广州市康软信息科技有限公司 | The Visual Report Forms generation method and system of medical data |
CN109284251A (en) * | 2018-08-14 | 2019-01-29 | 平安普惠企业管理有限公司 | Blog management method, device, computer equipment and storage medium |
CN113127523A (en) * | 2021-03-11 | 2021-07-16 | 思百达物联网科技(北京)有限公司 | Multi-dimensional attendance checking analysis method and device based on big data and candle picture |
CN113837578A (en) * | 2021-09-15 | 2021-12-24 | 江苏兴力工程管理有限公司 | Gridding supervision and management evaluation method for power supervision enterprise |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102609256A (en) * | 2012-01-19 | 2012-07-25 | 北京神州数码思特奇信息技术股份有限公司 | Motion chart generating method based on webpages |
CN102902533A (en) * | 2012-09-17 | 2013-01-30 | 乐视网信息技术(北京)股份有限公司 | Frame revealing system and method of generating diagram by combining Java and HTML5 (Hypertxt Markup Language) |
CN103473316A (en) * | 2013-09-11 | 2013-12-25 | 北京思特奇信息技术股份有限公司 | Data column dynamically displaying method and device |
CN104063468A (en) * | 2014-06-27 | 2014-09-24 | 北京思特奇信息技术股份有限公司 | Data report automatic generating and extracting method and device |
-
2014
- 2014-10-31 CN CN201410602813.8A patent/CN104317943A/en active Pending
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102609256A (en) * | 2012-01-19 | 2012-07-25 | 北京神州数码思特奇信息技术股份有限公司 | Motion chart generating method based on webpages |
CN102902533A (en) * | 2012-09-17 | 2013-01-30 | 乐视网信息技术(北京)股份有限公司 | Frame revealing system and method of generating diagram by combining Java and HTML5 (Hypertxt Markup Language) |
CN103473316A (en) * | 2013-09-11 | 2013-12-25 | 北京思特奇信息技术股份有限公司 | Data column dynamically displaying method and device |
CN104063468A (en) * | 2014-06-27 | 2014-09-24 | 北京思特奇信息技术股份有限公司 | Data report automatic generating and extracting method and device |
Non-Patent Citations (2)
Title |
---|
杨志: "风光储发电单元管控一体化系统的研究与实现", 《中国优秀硕士学位论文全文数据库信息科技辑》 * |
许鸿飞: "FusionCharts的使用方法", 《博客园,HTTP://WWW.CNBLOGS.COM/XUHONGFEI/ARCHIVE/2013/04/12/3016882.HTML》 * |
Cited By (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104657452A (en) * | 2015-02-06 | 2015-05-27 | 重庆师范大学 | Spatial switching system for pre-pregnancy eugenic archive data |
CN107133203A (en) * | 2016-02-29 | 2017-09-05 | 阿里巴巴集团控股有限公司 | A kind of chart generation method and device |
CN106484783A (en) * | 2016-09-19 | 2017-03-08 | 济南浪潮高新科技投资发展有限公司 | A kind of graphical representation method of report data |
CN107643970A (en) * | 2017-09-13 | 2018-01-30 | 曙光信息产业(北京)有限公司 | What thermal map configured shows method and shows system |
CN108172269A (en) * | 2017-12-15 | 2018-06-15 | 广州市康软信息科技有限公司 | The Visual Report Forms generation method and system of medical data |
CN109284251A (en) * | 2018-08-14 | 2019-01-29 | 平安普惠企业管理有限公司 | Blog management method, device, computer equipment and storage medium |
CN113127523A (en) * | 2021-03-11 | 2021-07-16 | 思百达物联网科技(北京)有限公司 | Multi-dimensional attendance checking analysis method and device based on big data and candle picture |
CN113837578A (en) * | 2021-09-15 | 2021-12-24 | 江苏兴力工程管理有限公司 | Gridding supervision and management evaluation method for power supervision enterprise |
CN113837578B (en) * | 2021-09-15 | 2024-02-06 | 江苏兴力工程管理有限公司 | Grid supervision, management and evaluation method for power supervision enterprise |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN104317943A (en) | Graphical report displaying method and system for assessment system | |
CN107315824B (en) | Method and device for generating thermodynamic diagram | |
CN105574730A (en) | Internet of Things big data platform-based intelligent user portrait method and device | |
KR20140093974A (en) | Image annotation method and system | |
CN106055316A (en) | Supply chain finance engine system, system establishment method and server | |
CN106407540A (en) | Underground pipeline auxiliary planning verification method based on three-dimensional GIS technology | |
CN106354519A (en) | Method and device for generating label for user portrait | |
CN110675728A (en) | Generation method, device and equipment of thermodynamic diagram and computer readable storage medium | |
CN105488177A (en) | Visual presentation method and system of data | |
CN102521403A (en) | Refined meteorological information service system | |
CN102708587A (en) | Method and system for acquiring three-dimensional building information rapidly | |
CN105160707A (en) | Three-dimensional model fast visualization method based on viewpoint indexes | |
CN106933887A (en) | A kind of data visualization method and device | |
KR20210063828A (en) | 3d modeling file conversion system | |
CN104537459A (en) | BIM-based micro field system and method | |
CN105610487B (en) | Cross-domain coordinated scheduling method for satellite observation resources | |
CN103699641A (en) | Method for accessing different raster map services | |
CN103425490B (en) | Based on the management method running object data in crm system | |
CN104407783A (en) | Interface information modularization display method and system | |
CN106155754A (en) | A kind of processing method and processing device of indicating template | |
CN109325015A (en) | A kind of extracting method and device of the feature field of domain model | |
CN111209329B (en) | Dynamic analysis method, device and system based on full-traffic price and cost transaction path | |
CN105354326A (en) | Spatial position indexing method and system | |
Mooney et al. | Citizen generated spatial data and information: risks and opportunities | |
CN105023089A (en) | Urban management data monitoring system based on GIS platform and method thereof |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
RJ01 | Rejection of invention patent application after publication | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20150128 |