CN106649225A - JSON self-definition-based report generation system and method - Google Patents
JSON self-definition-based report generation system and method Download PDFInfo
- Publication number
- CN106649225A CN106649225A CN201611263718.5A CN201611263718A CN106649225A CN 106649225 A CN106649225 A CN 106649225A CN 201611263718 A CN201611263718 A CN 201611263718A CN 106649225 A CN106649225 A CN 106649225A
- Authority
- CN
- China
- Prior art keywords
- report
- module
- data
- template
- configuration
- 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
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/12—Use of codes for handling textual entities
- G06F40/14—Tree-structured documents
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/14—Details of searching files based on file metadata
- G06F16/156—Query results presentation
-
- 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
- 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
Abstract
The invention discloses a JSON self-definition-based report generation system and method, and belongs to the field of industrial enterprise data statistics. An industrial enterprise report system comprises a system configuration module, a report template configuration module, a report service module, a report release module, a report browsing module, a permission management module and a report viewing module. All the modules are deployed in a Web server of an enterprise local area network, and a client accesses the server through the local area network. The client is mainly a browser installed in a computer, an IP address of the Web server of the local area network is input through an address bar of the browser, and a system is accessed through an Http protocol. The system and the method have the advantages that an interactive process of report template configuration is simplified, so that the template configuration efficiency is improved; the problems that enterprise complex reports only can be manually filled through Excel and do not have historical data query are solved, so that the working efficiency of enterprise statistical personnel is improved; and report browsing provides query of data point trends in the reports, so that the data observation correctness of business personnel is facilitated.
Description
Technical field
The present invention relates to industrial enterprise's technical field of data processing, more particularly, to a kind of making by oneself based on JSON and Web
The report generating system and method for justice, is industrial enterprise's reporting system and generation method of a kind of simple and efficient
Background technology
Form is a kind of extremely important enterprise management tool in industrial enterprise.With the development of computer technology, in mesh
In front practical application, mainly form is generated using three kinds of methods.The first is generated using Excel modes are manually filled in
Form, this statement form is freer, and mainly based on manually filling in, efficiency comparison is low, does not possess historical data access.The
Two kinds is in various application systems, data in database to be circulated in the form of hard coded, generates the form that can be checked, this
Method can dynamic check historical data, but the display mode of change form that can not be random.The third is by the display of form
Be abstracted into template, template can free structure, data are filled into foreground by template generation by the analysis that foreground and backstage pass through template
Form in.The present invention is provided and improves the third method so as to become a kind of reporting system in hgher efficiency.
The content of the invention
It is an object of the invention to provide a kind of self-defining report generating system and method based on JSON and Web, simplifies
The process for preparation of report form template, improves the service efficiency of report form template, it is adaptable to the business datum of complexity is processed in industrial enterprise
With a kind of form used under B/S frameworks.
Industrial enterprise's reporting system of the present invention includes system configuration module, report form template configuration module, Report Forms Service mould
Block, form release module, form browsing module, authority management module and form check module.
All modules are all deployed in the Web server of intranet in the present invention, and client is visited by LAN
Ask server.Client is mainly the browser installed in computer, by the address field of browser, input LAN Web clothes
Business device IP address, by Http protocol access systems.The present invention also needs to relational database support, and relational database can be installed
In Web server, or in the server of other LANs.
Form configuration module, form release module, form browsing module, authority management module and form are checked in the present invention
Module provides Web api interfaces and is attached with Report Forms Service module by Report Forms Service module respectively.Wherein form checks mould
Block is connected by Ajax requests with authority management module.Form checks that module is browsed template and touched by the event of browser with form
Send out connection.
System configuration module in the present invention, the module is used to configure the data for needing to show in form.To need in form
The data implication of display, with space (referred to as Node or node), material (Material), attribute (Property), is indicated,
Overall implication is expressed as the value of the association attributes of certain certain material of locus, abbreviation NMP models.The model is used for foreground
Form configuration module and Report Forms Service module, form configuration module plans the data model for needing to show in form by NMP models
Enclose, Report Forms Service module generates the data for needing to show in form by NMP models, constructs database query statement.It is
System configuration module is that report form template module and Report Forms Service module provide unified model language.Form configuration module, by form
The row and data area of form carry out the configuration of list formula in title, querying method, function menu and form, finally with JSON words
The form of symbol string submits to Report Forms Service module.It is preserved in the form of the file of JSON Report Forms Service module operating system
In certain file.Form release module, to form configuration module all of template file is generated, then is organized, and is easy to use
Family is navigated, and is preserved in the form of JSON forms and file.Form browsing module, using the result of form release module as
Input, parses JSON, generates form navigation page, facilitates user to navigate to the form for needing to check.Authority management module, uses
The report form template file of form configuration module configuration carries out form authority configuration, authority bag as input to the user of form
Include, application permission, node (Node), the configuration of material authority, and authority is stored in database.Form browsing module, with
The result of report form template configuration module and permission configuration module parses the configuration item in report form template as input, and according to looking into
Inquiry condition, request, the parameter that Report Forms Service module is carried according to request, inquiry report are sent in Ajax forms to Report Forms Service module
Table template, then according to report form template configuration item and NMP models, generates SQL statement, and to relational database SQL statement, report are submitted to
The result that table service module returns database, requires that the data for generating foreground needs are returned according to the configuration format of report form template
Return, form checks that module, according to the result for returning, using front end frame form is rendered to, and front end frame refers to what browser end was used
Display frame, such as ExtJS, jQuery UI.
System configuration module of the present invention, is by Node (node), Material (things by the data of report display
Material), Property (attribute) carries out structured organization, abbreviation NMP models.For example, certain Iron Works gas flow, wherein refining
Ironworks is node, blast furnace gas position material, and flow is attribute.System configuration module offer node, the configuration of material and attribute, and
The interface for reading NMP is externally provided.
Report form template configuration module of the present invention can configure two class templates, and a class is conventional statement template configuration,
One class is free report template configuration；
Conventional statement template configuration includes title, and packet, querying condition, row type flows through filter, button, row definition, association
Resource, the result for configuring is stored with the file of JSON forms；
The querying condition includes time started, end time, year, the moon, week, tree-like form；Time started, at the end of
Between, in year, the moon, representing that form checks in module whether render these controls week, tree-like form represents the pattern of form with tree-like aobvious
Show.
Described row type is abstract for node type, medium and stream type by the every a line in report page.Node type table
Show the statistics of certain information of certain unit in enterprise, for example certain workshop moon cost；Medium represent certain material of enterprise certain
The consumption of coal in the statistics of information, such as enterprise；Stream type represents that certain unit occurs or consume certain medium in enterprise
The statistics of the information of kind, such as statistics of a workshop RECOVERY OF CONVERTER GAS amount.
It is described to flow through filter and include occurring, consume, it is net to consume, reclaim, main product, export, diffuse, outsourcing.By enterprise units with
Relation between medium is abstract to flow, and the species of stream has above-mentioned several.Wherein consume and represent unit and consume certain medium relation,
Occur to represent unit and produce the relation of certain medium, net consumption represents that unit occurs and consume certain medium, wherein pure consumption
This kind of medium relation, reclaims the relation for representing unit with certain original medium being lost in being reclaimed from unit, and main product represents unit
With the relation between generation main technique product.Output represents the unit and turns the relation for certain medium for oneself consuming.Put
Dissipate and represent unit and diffuse the relation between medium.Outsourcing is represented：Relation between the unit and outsourcing medium, outsourcing media table
Show that enterprise is not self-produced, need the medium bought from other enterprises.
The button shows the title of the plug-in process script of form, and with the control of pushbutton type in form browsing module
Part shows.By the script of the button clicking trigger form title.
Described row define configuration item to be included, column name, type, field or function, time format, data type, data
Cycle, side-play amount, offset period number produces consumption, and medium name, attribute, function is read-only, chief series, col width, unit.Wherein column name table
Show that the first place for changing row claims.Type represents that the row are text line, time row, or data row.Field or function, field represents the row
The physical significance in a certain respect of display data, such as workshop title, media name etc..Formula represents operation expression, with it
The name that he arranges is referred to as the computing item of expression formula, and the result for obtaining fills out the row.Time format represents the form that time row show.
Data types to express will obtain what kind of data, and optional type includes difference, and table floors, wherein currency, difference are represented
In certain time range instrument at the end between show value and initial time show value difference；Table floors represents certain time
The show value of instrument；Currency represents instrument currency.The data cycle represents：System by difference, table floors with 3600 seconds,
86400 seconds, 2628000 seconds, the cycle is advanced as storage service within 31536000 seconds, in storing data into database, in form
Need to provide the data for inquiring about that cycle during inquiry.Side-play amount：Expression carries out time migration according to certain data cycle, changes
The query time of the row.Offset period number is represented：The how many cycles of skew.Produce consumption with it is above-mentioned flow through filter description stream it is identical.Medium
Name：Expression changes row to be needed to inquire about the data of that medium, fills in media name.Attribute represents the physical quantity of display information, such as flows
Amount, temperature, quantity of goods produced etc..Function representation inquires about the process function of certain categorical data certain section of time range Nei, such as sues for peace, and asks flat
, maximum, minimum value function etc..Whether it is main row that chief series represents that this is listed in form, and whether the row determine other row
Show, represented with true or false.Col width represents that this is listed in the width rendered in form browsing module.Unit：Represent the row
The unit of data.
Each unit in enterprise is organized into node type tree, node tree and medium tree by the correlated resources, by choosing three
The data source range of data during the node set is planted to determine form.Wherein node type represents abstract type unit in enterprise, such as
Ironmaking is the abstract of 5# blast furnace plants, for counting the data in multiple similar workshops.So node type tree representation node type
Stratification represent.Stratification is represented between solid element in node tree representation enterprise.It is various in media type tree representation enterprise
The stratification of material is represented.
Free report template configuration report form template of the present invention is configured to first generate the form of a m*n, then passes through
Generating form, template is finally stored the attribute of cell with JSON file formats in configuration form.
The cell attribute includes ID, and route, data type, data cycle, side-play amount, offset period number OK, is arranged,
Formula, function.Wherein ID, data index in systems.Route is after the change of data ID, according to routing update data ID.Number
According to type, data cycle, side-play amount, offset period number, function is the same described in conventional statement row configuration.OK, unit is represented
The line index of lattice place form.Row, represent cell column index in the table.Formula, is addition subtraction multiplication and division operation expression, computing
Item is cell ranks index, represents that the cell is calculated by other cells by operation expression.
Form release module of the present invention includes report form template tree, node type tree, node tree, medium tree, column, class
Type, sequence.Wherein node type tree, node tree and medium tree illustrate at common templates correlated resources.Report form template tree,
Report form template is grouped according in report form template configuration item, the structure of a tree-shaped is constituted, the nodename of tree is group names.
Column, represents form zone name in form browsing module.Type is form specific name, for example：Daily paper, monthly magazine etc..Row
Sequence represents the position in form browsing module of column, and report display is in that column.
Form browsing module of the present invention includes report form type button, and report column.Class in form release module
Type represents in report form template in the form of button, clicks on the type button during form is browsed, and switches the report name in column.
Report column is represented to browse form and is cut into m*n regions, and each column represents a region, the list different for representing enterprise
Unit.
Permission configuration module of the present invention, there is provided the authority that form is checked is controlled, authority is by user
Whether whether certain node, certain medium and certain application are had permission.Node refers to user department (space) Node,
Material refers to certain material, and application refers to some menu applications that form is carried, and whether the such as form possesses the function of deriving Excel.
The form checks that module includes：Selection of time control, inquires about button, derives Excel buttons, Graphics Control triggering
Button and the button of other report form processing script triggerings, form.Inquiry button indication, is processed by query time inquiry report data
Script.Derive Excel button indications data in form to be imported in Excel forms.Graphics Control trigger button represents click
Can on a web browser occur the control drawn afterwards, click on the data in form form, can draw on Graphics Control and click on unit
The historical data trend of lattice.Form is represented, according to dispensing unit in the row type and free report template of the configuration of common templates
Trellis into form.
The present invention is to provide such a report form generation method, comprises the steps of：
(1) in system configuration module, the data model for needing to check in form is configured, that is, configures NMP models.
(2) list or form configuration report display item are configured according to report form template, after the completion of, configuration item is literary with JSON
The form of part is stored.
(3) report form template is issued, selects the required parameter of report form template, configuration report form template in a browser join by position
Number, is issued as form JSON files and is stored.
(4) in permission configuration module, the report form template of configuration in step (2) is selected, authority configuration is carried out to it, preserved,
The authority of user is stored in database.
(5) JSON files are issued in form browsing module, browser load step (3), form browser is positioned at into true
In fixed position.
(6) form in browser positioning is clicked on, the parameter of configuration in obtaining step (2), to Report Forms Service module clothes
Ajax requests are initiated in business, and Report Forms Service module loads active user's authority according to required parameter, checks whether active user has the right
Limit accesses data, if without directly return sky, otherwise execution step (7).
(7) asked according to Http in step (6), extract report form template ID, Report Forms Service module obtains form mould according to ID
The JSON files of plate, and JSON files are returned to into browser, JSON files are converted into JavaScript object by browser, report
Table checks module according to JavaScript object, generates report style, and the pattern includes querying condition control, inquiry button and
Excel buttons are derived, Graphics Control initiates button and form form.Report style is generated after finishing and extracted in querying condition control
Current time, JavaScript object interior joint ID, node type ID, media ID and report form template ID, the value that these are extracted
As parameter, Ajax requests, and execution step (8) are initiated again to Report Forms Service module.
(8) asked according to Http in step (7), extract report form template ID, Report Forms Service module utilizes report form template ID, looks into
Report form template configuration JSON files are ask, JSON files are converted into into .NET objects, then extract required parameter interior joint ID, node
ID, media ID and time parameter, generate NMP models, and according to NMP models SQL statement is generated, and submit to database to be inquired about, and
The result of inquiry is returned to into Report Forms Service module, Report Forms Service module generates table objects according to report form template object, returns
Module is checked to form, form is checked that module, according to front end frame, translates into html, browsed to user.
Advantages of the present invention：
1st, the report form template configuration process in the present invention is simple, and not possessing development ability business personnel also can configure, and imitates
Rate is high, and has been truly realized the exploitation of form zero.
2nd, form issues the reuse that can solve report form template in the present invention, only need to change node, node type and section
Point parameter, you can accomplish that report form template service efficiency can be improve to use without modification report form template.
3rd, report form template adopts JSON as the file format of template in the present invention, has unified AM/BAM difference machine word
To template operation between speech, and to provide a kind of implementation method based on the enterprise report of Web.
4th, form browse mode is provided in the present invention, the pattern tiled using block simplifies the process for finding form,
Positioning of the convenient business personnel to form.
5th, the invention provides report data trend checks a kind of new interactive mode, i.e., by clicking on form cell,
Inquire about the function of the historical text of the cell data.
Description of the drawings
Fig. 1 is present system structure chart.
Fig. 2 checks program structure diagram for form of the present invention.
Specific embodiment
Industrial enterprise's reporting system of the present invention includes system configuration module, report form template configuration module, Report Forms Service mould
Block, form release module, form browsing module, authority management module and form check module.
All modules are all deployed in the Web server of intranet in the present invention, and client is visited by LAN
Ask server.Client is mainly the browser installed in computer, by the address field of browser, input LAN Web clothes
Business device IP address, by Http protocol access systems.The present invention also needs to relational database support, and relational database can be installed
In Web server, or in the server of other LANs.
Form configuration module, form release module, form browsing module, authority management module and form are checked in the present invention
Module provides Web api interfaces and is attached with Report Forms Service module by Report Forms Service module respectively.Wherein form checks mould
Block is connected by Ajax requests with authority management module.Form checks that module is browsed template and touched by the event of browser with form
Send out connection.
Below by specific embodiment, the present invention will be further described.
Realize process as the reality of the present invention using domestic certain iron and steel enterprise's iron-smelter energy resources report forms and process energy consumption form
Apply example.
Embodiment 1：Iron-smelter energy resources report forms
(1) conventional statement configuration list is opened, it is iron-smelter energy resources report forms to fill in report name, fills in group names for refining
Ironworks, chooses the time started as querying condition, and the time cycle selects day, selects to collect stream that (expression iron-smelter is every in row type
What kind of energy medium occurred to consume collects), flow through filtering and select generation and consume, button do not select to represent acquiescence (derive Excel and
Draw).In row definition by row stencil-chosen workshop, in row name workshop is filled in；Field is selected in type, in field or
Node.Name is filled in formula；Other are without filling in.Then medium is selected in row template, medium is filled in listing, in class
Type selects Field in selecting, and in field or formula MaterialType.Name is filled in, and other are without filling in.In row template
Select to produce consumption, product consumption is then filled in row name, Field is then selected in type, fill in field or formula
FlowType, other are without filling in or selecting.Then collection value is selected in row template, collection value is filled in row name, in class
Value is filled in type, in the data cycle day is selected, net consumption is selected in consumption is produced, in attribute-name quantity of goods produced (quantity of goods produced is filled in
Represent integrated flow).In read-only middle selection true, col width fills in 80.80 are filled in chief series.Unit is filled in unit row.
Verification value is differed except row name, and other configurations are identical., except row name, function needs to select average for hourly average value and collection value
Value, other are identical.With collection value except row name, function needs to select summation month to date.Blast furnace is chosen in the medium of correlated resources
Coal gas.Then preserve.
(2) template is found in form release module, report form template tree, in node tree iron-smelter, is selected in column
Ironmaking, in type selecting daily paper, clicks on after determining, the form is just deposited in the JSON files of form issue.
(3) open browser and select form browsing module, click on daily paper, select ironmaking region.
(4) double-click in form browsing module, smelt iron column, click on grand iron-smelter, grand ironmaking daily paper.And can click on and paint
, there is Chart Control below form in figure button, and the cell clicked in form shows the unit in Graphics Control
The historical trend of the data of lattice.
Embodiment 2：Process energy consumption form
(1) free report template is opened, generates the form of a 21*9., there is menu in right button table cell, replicates,
Paste, arrange, delete and add other data.Duplication can replicate the cell data to other cells, paste and be used for gluing
The data in other form cells are pasted, the attribute for being used for configuring the cell is set, the cell side-play amount can be configured, partially
Move the attributes such as periodicity, unit, function.Configure successively and preserved after all of cell on the form.
(2) open form to issue, process energy consumption form is selected in report form template tree, coking is selected in node tree,
Coking is selected in column, process energy consumption is selected in type, clicked on and determine, process energy consumption is published in file publishing.
(3) form browsing module is opened, clicks on process energy consumption, process energy consumption is selected in coke-oven plant's column, clicked on
Check the of that month process energy consumption form of coke-oven plant.
Claims (9)
- It is 1. a kind of to be based on the self-defining report generating systems of JSON, it is characterised in that：Including system configuration module, report form template is matched somebody with somebody Module is put, Report Forms Service module, form release module, form browsing module, authority management module and form check module；All modules are all deployed in the Web server of intranet, and client passes through LAN access server；Client End is mainly the browser installed in computer, by the address field of browser, is input into LAN Web server IP address, leads to Cross Http protocol access systems；；Also need to relational database support, relational database；In Web server, Huo Zheqi In the server of his LAN；Form configuration module, form release module, form browsing module, authority management module and form check module respectively with report Table service module provides Web api interfaces and is attached by Report Forms Service module；Wherein form checks that module please by Ajax Ask and be connected with authority management module；Form checks that module is browsed template and is connected by the event triggering of browser with form.
- 2. according to claim 1 based on the self-defining report generating systems of JSON, it is characterised in that：System configuration module The data for showing are needed in for configuring form, the data implication for showing will be needed in form, be Node or node, thing with space Material, attribute, are indicated, and overall implication is expressed as the value of the association attributes of certain certain material of locus, abbreviation NMP moulds Type, the model is used for foreground form configuration module and Report Forms Service module, and form configuration module plans form by NMP models The middle data area for needing to show, Report Forms Service module is generated in form by NMP models, constructs database query statement Need the data for showing；I.e. system configuration module is that report form template module and Report Forms Service module provide unified model language. The row and data area of form in report name, querying method, function menu and form are carried out list formula by form configuration module Configuration, Report Forms Service module is finally submitted in the form of JSON character strings；Report Forms Service module is by it with the file of JSON Form preserve operating system certain file in；Form release module, all of template text is generated to form configuration module Part, then organized, it is easy to user to navigate, and preserved in the form of JSON forms and file；Form browsing module, will report The result of table release module parses JSON as input, generates form navigation page, facilitates user to navigate to the report for needing to check Table；Authority management module, the report form template file configured using form configuration module is carried out as input to the user of form Form authority configuration, authority includes, application permission, node；The configuration of material authority, and authority is stored in database；Report Table browsing module, using the result of report form template configuration module and permission configuration module as input, parses matching somebody with somebody in report form template Item is put, and according to querying condition, request is sent to Report Forms Service module in Ajax forms, Report Forms Service module is carried according to request Parameter, inquire about report form template, then according to report form template configuration item and NMP models, generate SQL statement, to relational database SQL statement, the result that Report Forms Service module returns database is submitted to require to generate foreground according to the configuration format of report form template The data of needs are returned, and form checks that module, according to the result for returning, using front end frame form is rendered to, and front end frame refers to clear Look at the display frame that device end uses, display frame includes ExtJS, jQueryUI；System configuration module passes through the data of report display, node, material, attribute carry out structured organization, abbreviation NMP moulds Type；System configuration module provides node, the configuration of material and attribute, and externally provides the interface for reading NMP.
- 3. according to claim 1 based on the self-defining report generating systems of JSON, it is characterised in that：Described form mould Plate configuration module configures two class templates, and a class is conventional statement template configuration, and a class is free report template configuration；Conventional statement template configuration includes title, and packet, querying condition, row type flows through filter, button, row definition, association money Source, the result for configuring is stored with the file of JSON forms；The querying condition includes time started, end time, year, the moon, week, tree-like form；Time started, the end time, year, Month, representing that form checks in module whether render these controls week, tree-like form represents the pattern of form with tree-like display.Described row type is abstract for node type, medium and stream type by the every a line in report page；Node type represents enterprise The statistics of certain information of certain unit in industry；Medium represents the statistics of certain information of enterprise certain material, and stream type is represented In enterprise there is or consume the statistics of certain information of certain medium in certain unit；It is described to flow through filter and include occurring, consume, it is net to consume, reclaim, main product, export, diffuse, outsourcing；By enterprise units and medium Between relation it is abstract for stream, wherein consume represent unit with consume certain medium relation, occur represent unit with produce certain The relation of medium, net consumption represents that unit occurs and consume certain medium, wherein this kind of medium relation of pure consumption, reclaims and represent single Unit and the relation that certain original medium being lost in is reclaimed from unit, main product represents unit and produces between main technique product Relation；Output represents the unit and turns the relation for certain medium for oneself consuming；Diffuse expression unit and diffuse between medium Relation；Outsourcing is represented：Relation between the unit and outsourcing medium, outsourcing medium represents that enterprise is not self-produced, needs from other The medium bought in enterprise；The button shows the title of the plug-in process script of form, and aobvious with the control of pushbutton type in form browsing module Show, by the script of the button clicking trigger form title；Described row define configuration item to be included, column name, type, field or function, time format, data type, the data cycle, Side-play amount, offset period number produces consumption, and medium name, attribute, function is read-only, chief series, col width, unit；Wherein column name is represented and changed The first place of row claims.Type represents that the row are text line, time row, or data row.Field or function, field represents that the row show The physical significance in a certain respect of data, such as workshop title, media name；Formula represents operation expression, is arranged with other Name is referred to as the computing item of expression formula, and the result for obtaining fills out the row；Time format represents the form that time row show；Data class Type is represented will obtain what kind of data；Optional type includes difference, table floors, currency, when wherein difference represents certain Between in the range of instrument at the end between show value and initial time show value difference；Table floors represents the instrument of certain time Show value；Currency represents instrument currency；The data cycle represents：System by difference, table floors with 3600 seconds, 86400 seconds, 2628000 seconds, advance the cycle as storage service within 31536000 seconds, in storing data into database, need in report query The data for inquiring about that cycle are provided；Side-play amount：Expression carries out time migration according to certain data cycle, changes looking into for the row The inquiry time；Offset period number is represented：The how many cycles of skew.Produce consumption with it is above-mentioned flow through filter description stream it is identical.Medium name：Expression changes Row need the data for inquiring about that medium, fill in media name；Attribute represents the physical quantity of display information：Flow, temperature, it is in kind Amount；Function representation inquires about the process function of certain categorical data certain section of time range Nei：Summation, is averaging, maximum, minimum of a value Function；Whether it is main row that chief series represents that this is listed in form, and the row determine whether other row show, with true or False is represented；Col width represents that this is listed in the width rendered in form browsing module.Unit：Represent the unit of the column data；Each unit in enterprise is organized into node type tree, node tree and medium tree by the correlated resources, by choosing three kinds of trees Node to determine form in data data source range；Wherein node type represents abstract type unit in enterprise, for uniting Count the data in multiple similar workshops；So the stratification of node type tree representation node type is represented；In node tree representation enterprise Stratification between solid element is represented；The stratification of various materials in media type tree representation enterprise is represented.
- 4. according to claim 1 based on the self-defining report generating systems of JSON, it is characterised in that：Described freely reports Table template configuration report form template is configured to first generate the form of a m*n, then by the attribute of cell in configuration form come Form is generated, template is finally stored with JSON file formats；The cell attribute includes ID, and route, data type, data cycle, side-play amount, offset period number OK, is arranged, formula, Function；Wherein ID, data index in systems, route is after the change of data ID, according to routing update data ID；Data class Type, data cycle, side-play amount, offset period number, function is the same described in conventional statement row configuration；OK, cell institute is represented In the line index of form；Row, represent cell column index in the table；Formula, is addition subtraction multiplication and division operation expression, and computing item is Cell ranks are indexed, and represent that the cell is calculated by other cells by operation expression.
- 5. according to claim 1 based on the self-defining report generating systems of JSON, it is characterised in that：The form is issued Module includes report form template tree, node type tree, node tree, medium tree, column, type, sequence；Wherein node type tree, saves Point tree and medium tree illustrate at common templates correlated resources；Report form template tree, report form template is matched somebody with somebody according to report form template Put in item and be grouped, constitute the structure of a tree-shaped, the nodename of tree is group names；Column, represents that form is browsed in form Zone name in module；Type is form specific name：Daily paper, monthly magazine；Sorting representationb column in form browsing module Position, and report display is in that column.
- 6. according to claim 1 based on the self-defining report generating systems of JSON, it is characterised in that：The form is browsed Module includes report form type button, and report column；In form release module type in report form template in the form of button Represent, click on the type button during form is browsed, switch the report name in column.Report column is represented and for form to browse cutting Into m*n regions, each column represents a region, the unit different for representing enterprise.
- 7. according to claim 1 based on the self-defining report generating systems of JSON, it is characterised in that：Described authority is matched somebody with somebody Put module and provide and the authority that form is checked is controlled, authority by user whether to certain node, certain medium and Whether certain application has permission.Node refers to user department space Node, and material refers to certain material, and application refers to what form was carried Whether some menu applications, the such as form possess the function of deriving Excel.
- 8. according to claim 1 based on the self-defining report generating systems of JSON, it is characterised in that：The form is checked Module includes：Selection of time control, inquires about button, derives Excel buttons, Graphics Control trigger button and other report form processing pin The button of this triggering, form.Inquiry button indication, by query time inquiry report data script is processed；Derive Excel button tables Show and data in form are imported in Excel forms.Graphics Control trigger button is represented can be occurred on a web browser painting after click The control of figure, clicks on the data in form form, and the historical data trend for clicking on cell can be drawn on Graphics Control.Form Represent, according to the row type of the configuration of common templates and dispensing unit trellis in free report template into form.
- 9. the report form generation method of the system described in a kind of claim 1, it is characterised in that：Comprise the steps of：(1) in system configuration module, the data model for needing to check in form is configured, that is, configures NMP models；(2) list or form configuration report display item are configured according to report form template, after the completion of, by configuration item with JSON files Form is stored；(3) report form template is issued, selects the required parameter of report form template, configure report form template location parameter in a browser, will Form is issued as JSON files and is stored；(4) in permission configuration module, the report form template of configuration in step (2) is selected, authority configuration is carried out to it, preserved, will be used The authority at family is stored in database；(5) JSON files are issued in form browsing module, browser load step (3), form is positioned at into browser determination In position；(6) form in browser positioning is clicked on, the parameter of configuration in obtaining step (2) is sent out to Report Forms Service module service Ajax requests are played, Report Forms Service module loads active user's authority according to required parameter, checks whether active user has permission visit Data are asked, if without directly return sky, otherwise execution step (7)；(7) asked according to Http in step (6), extract report form template ID, Report Forms Service module obtains report form template according to ID JSON files, and JSON files are returned to into browser, JSON files are converted into JavaScript object by browser, and form is looked into Module is seen according to JavaScript object, report style is generated, the pattern includes querying condition control, inquiry button and derivation Excel buttons, Graphics Control initiates button and form form.Report style is generated and extracts current in querying condition control after finishing Time, JavaScript object interior joint ID, node type ID, media ID and report form template ID, the value that these are extracted as Parameter, to Report Forms Service module Ajax requests, and execution step (8) are initiated again；(8) asked according to Http in step (7), extract report form template ID, Report Forms Service module utilizes report form template ID, inquiry report Table template configuration JSON file, by JSON files .NET objects are converted into, then extraction required parameter interior joint ID, node ID, Media ID and time parameter, generate NMP models, and according to NMP models SQL statement is generated, and submit to database to be inquired about, and will look into The result of inquiry returns to Report Forms Service module, and Report Forms Service module generates table objects according to report form template object, returns to report Table checks module, and form is checked that module, according to front end frame, translates into html, browsed to user.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611263718.5A CN106649225A (en) | 2016-12-30 | 2016-12-30 | JSON self-definition-based report generation system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611263718.5A CN106649225A (en) | 2016-12-30 | 2016-12-30 | JSON self-definition-based report generation system and method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106649225A true CN106649225A (en) | 2017-05-10 |
Family
ID=58837605
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201611263718.5A Pending CN106649225A (en) | 2016-12-30 | 2016-12-30 | JSON self-definition-based report generation system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106649225A (en) |
Cited By (28)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104750866A (en) * | 2015-04-17 | 2015-07-01 | 上海斐讯数据通信技术有限公司 | Embedded WEB server based dynamic menu bar generation method and system |
| CN107832282A (en) * | 2017-11-21 | 2018-03-23 | 苏州正载信息技术有限公司 | A kind of implementation method for defining Visual Report Forms |
| CN108038089A (en) * | 2017-12-01 | 2018-05-15 | 方欣科技有限公司 | A kind of online electronic spreadsheet engine of property tax |
| CN108376176A (en) * | 2018-03-14 | 2018-08-07 | 深圳日彤大数据有限公司 | It can towed big data visualization analysis tools system |
| CN108460007A (en) * | 2018-02-11 | 2018-08-28 | 悦锦软件系统（上海）有限公司 | A kind of automation report logic engine and method |
| CN108768791A (en) * | 2018-07-04 | 2018-11-06 | 山东汇贸电子口岸有限公司 | A kind of information collection configuration management system and method |
| CN108984496A (en) * | 2017-06-02 | 2018-12-11 | 北京京东尚科信息技术有限公司 | The method and apparatus for generating report |
| CN109542975A (en) * | 2018-10-23 | 2019-03-29 | 佛山欧神诺云商科技有限公司 | A kind of intelligent report forms inquiry system |
| CN109614408A (en) * | 2018-10-25 | 2019-04-12 | 南京行者易智能交通科技有限公司 | The implementation method of web terminal self-defined report based on spring and poi |
| CN109766382A (en) * | 2018-11-28 | 2019-05-17 | 四川商通实业有限公司 | A kind of dynamic data column methods of exhibiting |
| CN110046337A (en) * | 2019-04-22 | 2019-07-23 | 厦门商集网络科技有限责任公司 | A kind of financial data acquisition method and its system |
| CN110059121A (en) * | 2019-03-12 | 2019-07-26 | 广州明珞汽车装备有限公司 | A kind of method, system, device and the storage medium of quick export bill of materials |
| CN110096503A (en) * | 2019-03-22 | 2019-08-06 | 重庆长安汽车股份有限公司 | A kind of analysis method and system of three coordinate measuring point data of white body |
| CN110096547A (en) * | 2019-03-21 | 2019-08-06 | 深圳壹账通智能科技有限公司 | Supply synchronous method, device, computer equipment and the computer storage medium of data |
| CN110689149A (en) * | 2019-10-21 | 2020-01-14 | 中国民航信息网络股份有限公司 | Mobile inspection platform for data center |
| CN110717320A (en) * | 2019-10-11 | 2020-01-21 | 上海管和信息科技有限公司 | Form/report designer and method suitable for multiple platforms and information management system |
| CN111367940A (en) * | 2020-03-06 | 2020-07-03 | 中国银行股份有限公司 | Unified development method of bank transaction report, client and server system |
| CN111427973A (en) * | 2020-04-21 | 2020-07-17 | 贵州新致普惠信息技术有限公司 | Planning table data analysis method |
| CN111737539A (en) * | 2020-08-24 | 2020-10-02 | 成都四方伟业软件股份有限公司 | Complex report engine method and device |
| CN112183050A (en) * | 2020-10-12 | 2021-01-05 | 贵州电网有限责任公司 | Method and system for realizing automatic data report design and collection |
| CN112256999A (en) * | 2020-09-11 | 2021-01-22 | 长沙市到家悠享网络科技有限公司 | Page display method, device and equipment |
| CN112261119A (en) * | 2020-10-19 | 2021-01-22 | 四川长虹电器股份有限公司 | Automatic report system |
| CN112632936A (en) * | 2020-12-24 | 2021-04-09 | 山东中创软件工程股份有限公司 | Electronic form generation method, system and related device |
| CN112699652A (en) * | 2021-01-05 | 2021-04-23 | 银盛通信有限公司 | Table generation and operation method and system based on Vue and Element UI |
| CN112818043A (en) * | 2021-01-26 | 2021-05-18 | 四川天翼网络服务有限公司 | Data source report generation method based on JSON self-description |
| CN113127442A (en) * | 2020-01-10 | 2021-07-16 | 马上消费金融股份有限公司 | Visualization method and device of data model and storage medium |
| CN113486269A (en) * | 2021-05-25 | 2021-10-08 | 厦门海迈科技股份有限公司 | WEB-based electronic form data processing method, computing device, and storage medium |
| CN117291156A (en) * | 2023-10-12 | 2023-12-26 | 西安新视窗科技有限公司 | Engineering form data generation system and method based on dynamic interpretation |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104376068A (en) * | 2014-11-07 | 2015-02-25 | 北京思特奇信息技术股份有限公司 | Data representation system and method based on dynamic report template |
| CN105138501A (en) * | 2015-08-10 | 2015-12-09 | 北京思特奇信息技术股份有限公司 | Configurable dynamic report generating method and system |
| CN105183489A (en) * | 2015-10-10 | 2015-12-23 | 南京国电南自轨道交通工程有限公司 | Extjs frame based intelligent data analysis system and method |
-
2016
- 2016-12-30 CN CN201611263718.5A patent/CN106649225A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104376068A (en) * | 2014-11-07 | 2015-02-25 | 北京思特奇信息技术股份有限公司 | Data representation system and method based on dynamic report template |
| CN105138501A (en) * | 2015-08-10 | 2015-12-09 | 北京思特奇信息技术股份有限公司 | Configurable dynamic report generating method and system |
| CN105183489A (en) * | 2015-10-10 | 2015-12-23 | 南京国电南自轨道交通工程有限公司 | Extjs frame based intelligent data analysis system and method |
Cited By (36)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104750866B (en) * | 2015-04-17 | 2019-06-14 | 上海斐讯数据通信技术有限公司 | Method and system based on flush type WEB server dynamic generation menu bar |
| CN104750866A (en) * | 2015-04-17 | 2015-07-01 | 上海斐讯数据通信技术有限公司 | Embedded WEB server based dynamic menu bar generation method and system |
| CN108984496A (en) * | 2017-06-02 | 2018-12-11 | 北京京东尚科信息技术有限公司 | The method and apparatus for generating report |
| CN107832282A (en) * | 2017-11-21 | 2018-03-23 | 苏州正载信息技术有限公司 | A kind of implementation method for defining Visual Report Forms |
| CN108038089A (en) * | 2017-12-01 | 2018-05-15 | 方欣科技有限公司 | A kind of online electronic spreadsheet engine of property tax |
| CN108460007A (en) * | 2018-02-11 | 2018-08-28 | 悦锦软件系统（上海）有限公司 | A kind of automation report logic engine and method |
| CN108376176A (en) * | 2018-03-14 | 2018-08-07 | 深圳日彤大数据有限公司 | It can towed big data visualization analysis tools system |
| CN108768791A (en) * | 2018-07-04 | 2018-11-06 | 山东汇贸电子口岸有限公司 | A kind of information collection configuration management system and method |
| CN108768791B (en) * | 2018-07-04 | 2021-08-10 | 上海浪潮云计算服务有限公司 | Information acquisition configuration management system and method |
| CN109542975A (en) * | 2018-10-23 | 2019-03-29 | 佛山欧神诺云商科技有限公司 | A kind of intelligent report forms inquiry system |
| CN109614408A (en) * | 2018-10-25 | 2019-04-12 | 南京行者易智能交通科技有限公司 | The implementation method of web terminal self-defined report based on spring and poi |
| CN109614408B (en) * | 2018-10-25 | 2019-09-20 | 南京行者易智能交通科技有限公司 | The implementation method of web terminal self-defined report based on spring and poi |
| CN109766382A (en) * | 2018-11-28 | 2019-05-17 | 四川商通实业有限公司 | A kind of dynamic data column methods of exhibiting |
| CN110059121A (en) * | 2019-03-12 | 2019-07-26 | 广州明珞汽车装备有限公司 | A kind of method, system, device and the storage medium of quick export bill of materials |
| CN110096547A (en) * | 2019-03-21 | 2019-08-06 | 深圳壹账通智能科技有限公司 | Supply synchronous method, device, computer equipment and the computer storage medium of data |
| CN110096503B (en) * | 2019-03-22 | 2023-04-18 | 重庆长安汽车股份有限公司 | Analysis method and system for white vehicle body three-coordinate measuring point data |
| CN110096503A (en) * | 2019-03-22 | 2019-08-06 | 重庆长安汽车股份有限公司 | A kind of analysis method and system of three coordinate measuring point data of white body |
| CN110046337A (en) * | 2019-04-22 | 2019-07-23 | 厦门商集网络科技有限责任公司 | A kind of financial data acquisition method and its system |
| CN110046337B (en) * | 2019-04-22 | 2022-10-25 | 厦门商集网络科技有限责任公司 | Financial data acquisition method and system |
| CN110717320A (en) * | 2019-10-11 | 2020-01-21 | 上海管和信息科技有限公司 | Form/report designer and method suitable for multiple platforms and information management system |
| CN110689149B (en) * | 2019-10-21 | 2023-09-01 | 中国民航信息网络股份有限公司 | Movable inspection platform for data center |
| CN110689149A (en) * | 2019-10-21 | 2020-01-14 | 中国民航信息网络股份有限公司 | Mobile inspection platform for data center |
| CN113127442A (en) * | 2020-01-10 | 2021-07-16 | 马上消费金融股份有限公司 | Visualization method and device of data model and storage medium |
| CN113127442B (en) * | 2020-01-10 | 2023-12-22 | 马上消费金融股份有限公司 | Method, device and storage medium for visualizing data model |
| CN111367940A (en) * | 2020-03-06 | 2020-07-03 | 中国银行股份有限公司 | Unified development method of bank transaction report, client and server system |
| CN111427973A (en) * | 2020-04-21 | 2020-07-17 | 贵州新致普惠信息技术有限公司 | Planning table data analysis method |
| CN111427973B (en) * | 2020-04-21 | 2023-05-05 | 上海新致软件股份有限公司 | Planning table data analysis method |
| CN111737539A (en) * | 2020-08-24 | 2020-10-02 | 成都四方伟业软件股份有限公司 | Complex report engine method and device |
| CN112256999A (en) * | 2020-09-11 | 2021-01-22 | 长沙市到家悠享网络科技有限公司 | Page display method, device and equipment |
| CN112183050A (en) * | 2020-10-12 | 2021-01-05 | 贵州电网有限责任公司 | Method and system for realizing automatic data report design and collection |
| CN112261119A (en) * | 2020-10-19 | 2021-01-22 | 四川长虹电器股份有限公司 | Automatic report system |
| CN112632936A (en) * | 2020-12-24 | 2021-04-09 | 山东中创软件工程股份有限公司 | Electronic form generation method, system and related device |
| CN112699652A (en) * | 2021-01-05 | 2021-04-23 | 银盛通信有限公司 | Table generation and operation method and system based on Vue and Element UI |
| CN112818043A (en) * | 2021-01-26 | 2021-05-18 | 四川天翼网络服务有限公司 | Data source report generation method based on JSON self-description |
| CN113486269A (en) * | 2021-05-25 | 2021-10-08 | 厦门海迈科技股份有限公司 | WEB-based electronic form data processing method, computing device, and storage medium |
| CN117291156A (en) * | 2023-10-12 | 2023-12-26 | 西安新视窗科技有限公司 | Engineering form data generation system and method based on dynamic interpretation |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106649225A (en) | JSON self-definition-based report generation system and method | |
| CN110673848B (en) | Enterprise information management system configuration device based on JavaWeb | |
| JP5570608B2 (en) | Excel-based analysis report creation system and method | |
| CN103020158A (en) | Report form creation method, device and system | |
| CN104239073B (en) | Data maintenance system rapid prototyping development system and method | |
| CN101650712A (en) | Generating management method and system of self-defined report | |
| CN103631969A (en) | Generation method and device of report data | |
| CN105488048A (en) | Data query method and device | |
| CA2394514A1 (en) | Method and system for parameterized database drill-through | |
| CN104036040A (en) | Method and device for generating report | |
| US20170193036A1 (en) | Framework for joining datasets | |
| CN108595604A (en) | A kind of data visualisation system and method for intelligent report forms | |
| CN105405069A (en) | Electricity purchase operating decision analysis and data processing method | |
| CN104102670A (en) | Performance indicator analytical framework | |
| CN103116500A (en) | Method and device for structural body definition and structure output | |
| US20230102947A1 (en) | Providing operations in accordance with worksheet relationships and data object relationships | |
| CN108363776A (en) | A kind of self-defined display methods of table field | |
| CN116468010A (en) | Report generation method, device, terminal and storage medium | |
| CN105260300A (en) | Service test method based on CAS (General Classification Standards of China Accounting Standards) application platform | |
| Cecelja | Manufacturing Information and Data Systems: Analysis, Design and Practice | |
| CN113722564A (en) | Visualization method and device for energy and material supply chain based on space map convolution | |
| CN112527918A (en) | Data processing method and device | |
| CN101297290B (en) | Method for controlling relational database system | |
| CN104182226A (en) | General mobile information system adaptation method and device | |
| CN111881126A (en) | Big data management system |
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 | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20170510 |
|
| WD01 | Invention patent application deemed withdrawn after publication |