CN105868196A - Method for generating industrial data report in server - Google Patents
Method for generating industrial data report in server Download PDFInfo
- Publication number
- CN105868196A CN105868196A CN201510028548.1A CN201510028548A CN105868196A CN 105868196 A CN105868196 A CN 105868196A CN 201510028548 A CN201510028548 A CN 201510028548A CN 105868196 A CN105868196 A CN 105868196A
- Authority
- CN
- China
- Prior art keywords
- data
- report form
- template
- variable
- rule
- 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
Abstract
The invention discloses a method for generating an industrial data report in a server. The method comprises the steps of designing report templates in the server, wherein each report template contains a uniquely corresponding template identifier and data cells; configuring a rule for each data cell, wherein the rule at least contains data source information, data starting time, data ending time and a statistic function; receiving a parameter instruction of calling the report template from a client by the server, wherein the parameter instruction contains the template identifier of the report template required to be called; and finding a corresponding report template by the server according to the template identifier, generating a data report according to the rule of each data cell in the report template, and returning the generated data report to the client. According to the method, when the industrial data report is dynamically generated, the client does not need to write complicated codes; a function of quick data interaction with other enterprises is realized; and the later upgrading and maintenance are relatively convenient.
Description
Technical field
The present invention relates to a kind of data sheet generation technique, particularly relate to a kind of server end industrial data form raw
One-tenth technology.
Background technology
Data sheet typically has two kinds of implementations at present, and the first is by special Client Design form mould
Plate, has designed and has uploaded onto the server, and template does not encode for data cells itself, but compiles template
Write corresponding script file, when calling on the client, perform the script inside template, obtain number by script
According to, fill report form template, thus reach to be formed the result of data sheet.The second way is by special visitor
Family end design report form template, and template data cell is encoded, design and uploaded onto the server, visitor
Family end is by transmission parameter request to server end, and server returns data block and report form template, in client
Resolve database block information and Template Information by script, reach to be formed the process of form by integration.
The shortcoming of the first technology is that the form of each type is required for exclusively carrying out and writes script, increases or repaiies
Script edit or amendment will be needed needs a large amount of different statement form when when of changing statement form
Take a substantial amount of time and write corresponding script, safeguard the most relatively difficult.
The shortcoming of the second technology is form and the form of data block that client needs to resolve template, although no
Need to carry out separately encoded to different templates, however it is necessary that the design rule understanding whole template, be unfavorable for not
With the data interactive fusion between enterprise.If additionally the template coding rule of form needs change, then client
Code be also required to change, if mutual enterprise is more, can give the later stage upgrading bring the biggest difficulty.
Summary of the invention
The technical problem that present invention mainly solves is to provide a kind of server end industrial data report form generation method,
Make industrial data form when dynamically generating, need not client and write the code of complexity, and possess and other
The function that between enterprise, rapid data is mutual, and more convenient at later stage upgrade maintenance.
In order to solve above-mentioned technical problem, the invention provides a kind of server end industrial data report generation side
Method, comprises the steps of
Designing report form template at server end, each report form template comprises unique corresponding template identifier；
Comprising data cells in described report form template, for each data cells configuration rule, described rule is at least
Comprise data source information, data initial time, ED time, statistical function；
Received server-side is from the parameter instruction calling report form template of client, in described parameter instruction
Comprise the template identifier of report form template to be called；
Server end, according to this template identifier, finds the report form template of correspondence, according in this report form template
The rule of each data cells, generates data sheet, the data sheet generated is returned to client.
As improving further, described data source information generally comprises: data base IP address, data base
Name, table name, device number, row name；
Described server end generates in the step of data sheet, finds notebook data according to described data source information
The Data Source of cell.
As improving further, described data initial time and/or ED time can be fixed value or
For variable；
Data initial time is comprised in the rule of the data cells of the report form template of described client call
And/or during the variable of ED time, also comprise the steps of
This client is indicated to be that described data initial time and/or the variable of ED time are specified concrete
Parameter value；
Described server end generates in the step of data sheet, according to data cell each in described report form template
The rule of lattice, in conjunction with described data initial time and/or the design parameter value of ED time, generates institute
State data sheet.
As improving further, the rule configured for described data cells can also comprise: scope of data
Lower limit, the scope of data upper limit.
As improving further, described scope of data lower limit and/or the scope of data upper limit can be fixed value or
For variable；
Scope of data lower limit is comprised in the rule of the data cells of the report form template of described client call
And/or during the variable of the scope of data upper limit, also comprise the steps of
The variable indicating this client to be described scope of data lower limit and/or the scope of data upper limit is specified concrete
Parameter value；
Described server end generates in the step of data sheet, according to data cell each in described report form template
The rule of lattice, in conjunction with described data initial time and/or the design parameter value of ED time, generates institute
State data sheet.
As improving further, described report form template can also comprise variable cell lattice, described variable list
Unit's lattice comprise at least one variable, or comprises the combination of variable and immobilized substance.
As improving further, when the report form template at described client call comprises variable cell lattice, also
Comprise the steps of
Described client is indicated to specify the design parameter value of variable in described variable cell lattice；
In described server generates the step of data sheet, server end is according to data each in report form template
The design parameter value of variable in the rule of cell, and described variable cell lattice, generates data sheet.
As improving further, described statistical function can be one below:
Accumulated value sum (), meansigma methods avg (), number count (), persistent period duration (), maximum
Max (), minima min (), displacement number of times change ().
As improving further, the method can also comprise the steps of distributes only into each data cells
The identifier of one correspondence；The rule each data cells configured associates storage with its identifier；
In described server generates the step of data sheet, looked for by the identifier of described data cells
To the rule that this data cells is corresponding.
As improving further, described identifier can be made up of line number and row number.
Compared with prior art, the main distinction and effect thereof are embodiment of the present invention: set at server end
Meter report form template, each report form template comprises unique corresponding template identifier；Report form template comprises number
According to cell, for each data cells configuration rule, this rule rises including at least data source information, data
Time beginning, ED time, statistical function；Received server-side calls form mould from client
The parameter instruction of plate, comprises the template identifier of report form template to be called in this parameter instruction；Service
Device end, according to this template identifier, finds the report form template of correspondence, according to data sheet each in this report form template
The rule of unit's lattice, generates data sheet, the data sheet generated is returned to client.Pass through the party
Formula so that industrial data form need not when dynamically generating client write complexity code, and possess with
The function that between other enterprises, rapid data is mutual, and more convenient at later stage upgrade maintenance.
Accompanying drawing explanation
With detailed description of the invention, the present invention is described in further detail below in conjunction with the accompanying drawings.
Fig. 1 is the server end industrial data report form generation method flow chart of first embodiment of the invention.
Detailed description of the invention
For making the object, technical solutions and advantages of the present invention clearer, below in conjunction with accompanying drawing to the present invention's
Embodiment is described in further detail.
First embodiment of the invention relates to a kind of server end industrial data report form generation method, idiographic flow
As shown in Figure 1.
In step 101, design report form template at server end, the unique correspondence of each report form template distribution
Template identifier.Generally, report form template is always made up of the data cells of multiple lines and multiple rows, for often
The unique corresponding identifier of individual data cells distribution, and be each data cells configuration rule.In order to
Template is succinct, can the Rule Extraction of data cells configuration out be placed in data base, with number
Associate according to the identifier of cell and preserve, then search correspondence when needs use by identifier.
Which row the identifier of data cells can utilize, and which arranges as keyword, so that it is guaranteed that it is only
One property and property easy to identify.
The rule arranged for data cells generally comprises data source information, scope of data lower limit, data model
Place limit, data initial time, ED time, statistical function etc..Wherein scope of data lower limit,
The scope of data upper limit can carry out configuring or not configuring according to the demand of user.Scope of data lower limit, data
Range limit according to access data point the need of have scope of data determine whether configuration, as user be concerned about
Certain data segment, then can configure.
The data cells rule schemata not configured is as follows:
{ data source: [not joining], lower limit: [not joining], the upper limit: [not joining], time started: [not joining], end time: [not
Join], function: [not joining] }
Wherein, data source information generally comprise data base IP address, database name, table name, device number,
Row name.For example, can be " data source: data base IP address | 192.168.10.234；Database name
| DIASI basis credential storehouse；Table name | testdat；Device number |@DeviceID@；Row name
| total_activePower [total active power] "
Statistical function may is that accumulated value sum (), meansigma methods avg (), number count (), persistent period
Duration (), maximum max (), minima min (), displacement number of times change ().
It addition, scope of data lower limit, the scope of data upper limit in data cells rule, when data initiate
Between, the ED time can be occurrence, it is also possible to be variable (being determined in use by user).
Present embodiment illustrates as a example by variable.
In step 102, when client needs to call report form template, send parameter instruction to server,
Parameter instruction comprises report form template identifier to be called.If the data cells of this report form template
Rule comprises variable, then parameter instruction also needs to be included as the design parameter value that variable is specified, in full
According to initial time variable, ED time variable, scope of data lower end variables, the scope of data upper limit become
The design parameter value of amount.
In step 103, the report form template identifier that server end sends according to client, finds correspondence
Report form template, according in the rule of data cells in report form template data source (data base IP address,
Database name, table name, device number, row name), find the Data Source of notebook data cell, and according to
Data initial time in parameter instruction, end time, the scope of data upper limit, the design parameter of lower limit
Value, reads qualified data from this Data Source, and calculates according to statistical function, be somebody's turn to do
The concrete data of data cells；This data cells is generated successively according to the rule of each data cells
Concrete data, one data sheet of final synthesis, the data sheet generated is returned to client.
Client just can directly use after receiving form, it is not necessary to carries out any process.
The server end industrial data report form generation method of present embodiment so that industrial data form is dynamic
Need not client during generation and write the code of complexity, only need to select suitable report form template and the transmission must
Parameter is wanted i.e. to can get complete form, convenient and swift.And this report form generation method possesses and other enterprises
Between the mutual function of rapid data, and more convenient at later stage upgrade maintenance.Because inside template
Can arrange data source, a template can be using the data base of differently configured server as data source.Other
If the data base that enterprise has oneself can go to read generating form when over there.By the side of template
Formula, if enterprise data source has influence of change scope to be also only this enterprise, additionally server system upgrading
Also need only to do in template server upgrade, on other no impacts.
Second embodiment of the invention also relates to a kind of server end industrial data report form generation method, with
First embodiment is roughly the same, and its difference is, present embodiment is on the basis of the first embodiment
Add variable cell lattice.
Specifically, report form template i.e. also comprises variable cell lattice, variable cell lattice can only comprise
One or more variablees, it is also possible to comprise variable and combine with immobilized substance.Server end is at client call
Report form template when comprising variable cell lattice, instruction client specifies the concrete of variable in these variable cell lattice
Parameter value；When generating data sheet, in addition to the operation in step 103, herein in connection with variable cell lattice
The design parameter value of middle variable, generates data sheet.
By these variable cell lattice, user can adjust specifically should of form by the form of configuration parameter
Need to change different titles, such as according to different application scenarios by scene, such as title: transformer station is sent out
Electricity and electricity consumption information slip, the such gauge outfit of possible needs when application: the generating of 1# transformer station and electricity consumption feelings
Condition, at this moment can represent referred to as one variable of transformer station's name, and variable regulation two ends are used " % " come
As identifier.As: " %station% generating and electricity consumption situation ".When calling report form template, visitor
The occurrence of family end input variable, such as 1# transformer station, server end is when generating form, by the tool of variable
Body value substitutes into, and forms concrete gauge outfit, such as the generating of 1# transformer station and electricity consumption situation.
Although by referring to some of the preferred embodiment of the invention, the present invention being shown and retouch
State, but it will be understood by those skilled in the art that can to it, various changes can be made in the form and details,
Without departing from the spirit and scope of the present invention.
Claims (8)
1. a server end industrial data report form generation method, it is characterised in that comprise the steps of
Designing report form template at server end, each report form template comprises unique corresponding template identifier；
Described report form template comprises data cells, distributes unique corresponding identifier for each data cells,
For each data cells configuration rule, described rule including at least data source information, data initial time,
ED time, statistical function；The rule each data cells configured associates with its identifier and deposits
Storage；
Received server-side is from the parameter instruction calling report form template of client, in described parameter instruction
Comprise the template identifier of report form template to be called；
Server end, according to this template identifier, finds the report form template of correspondence, by each described data sheet
The identifier of unit's lattice finds the rule that this data cells is corresponding, according to data cell each in this report form template
The rule of lattice, generates data sheet, the data sheet generated is returned to client.
Server end industrial data report form generation method the most according to claim 1, its feature exists
In, described data source information includes at least: data base IP address, database name, table name, device number,
Row name；
Described server end generates in the step of data sheet, finds notebook data according to described data source information
The Data Source of cell.
Server end industrial data report form generation method the most according to claim 1, its feature exists
In, described data initial time and/or ED time are fixed value or are variable；
Data initial time is comprised in the rule of the data cells of the report form template of described client call
And/or during the variable of ED time, also comprise the steps of
This client is indicated to be that described data initial time and/or the variable of ED time are specified concrete
Parameter value；
Described server end generates in the step of data sheet, according to data cell each in described report form template
The rule of lattice, in conjunction with described data initial time and/or the design parameter value of ED time, generates institute
State data sheet.
Server end industrial data report form generation method the most according to claim 1, its feature exists
In, the rule configured for described data cells also comprises: scope of data lower limit, the scope of data upper limit.
Server end industrial data report form generation method the most according to claim 4, its feature exists
In, described scope of data lower limit and/or the scope of data upper limit are fixed value or are variable；
Scope of data lower limit is comprised in the rule of the data cells of the report form template of described client call
And/or during the variable of the scope of data upper limit, also comprise the steps of
The variable indicating this client to be described scope of data lower limit and/or the scope of data upper limit is specified concrete
Parameter value；
Described server end generates in the step of data sheet, according to data cell each in described report form template
The rule of lattice, in conjunction with described data initial time and/or the design parameter value of ED time, generates institute
State data sheet.
Server end industrial data report form generation method the most according to claim 1, its feature exists
In, described report form template also comprises variable cell lattice, described variable cell lattice comprises at least one and becomes
Amount, or comprise the combination of variable and immobilized substance.
Server end industrial data report form generation method the most according to claim 6, its feature exists
In, when the report form template at described client call comprises variable cell lattice, also comprise the steps of
Described client is indicated to specify the design parameter value of variable in described variable cell lattice；
In described server generates the step of data sheet, server end is according to data each in report form template
The design parameter value of variable in the rule of cell, and described variable cell lattice, generates data sheet.
Server end industrial data report form generation method the most according to claim 1, its feature exists
In, described identifier is made up of line number and row number.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510028548.1A CN105868196A (en) | 2015-01-21 | 2015-01-21 | Method for generating industrial data report in server |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510028548.1A CN105868196A (en) | 2015-01-21 | 2015-01-21 | Method for generating industrial data report in server |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105868196A true CN105868196A (en) | 2016-08-17 |
Family
ID=56622991
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510028548.1A Pending CN105868196A (en) | 2015-01-21 | 2015-01-21 | Method for generating industrial data report in server |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105868196A (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106776799A (en) * | 2016-11-23 | 2017-05-31 | 广东小天才科技有限公司 | A kind of quality information record and the method and apparatus of analysis |
| CN107562888A (en) * | 2017-09-05 | 2018-01-09 | 北京瑞凯软件科技开发有限公司 | The data sheet generation method and system of a kind of track traffic synthetic monitoring system |
| CN108536660A (en) * | 2018-04-03 | 2018-09-14 | 福建榕基软件工程有限公司 | A kind of generation method and terminal of self-defined report |
| CN109241514A (en) * | 2018-09-10 | 2019-01-18 | 深圳市泰洲科技有限公司 | Data automatically imported method, device, computer equipment and storage medium |
| CN109446507A (en) * | 2018-11-13 | 2019-03-08 | 浙江中智达科技有限公司 | A kind of construction method and device of report |
| CN110765750A (en) * | 2019-09-16 | 2020-02-07 | 平安科技（深圳）有限公司 | Report data entry method and terminal equipment |
| CN111444171A (en) * | 2018-12-28 | 2020-07-24 | 航天信息股份有限公司 | Method, device and storage medium for generating value-added tax return form |
| CN115392206A (en) * | 2022-10-26 | 2022-11-25 | 深圳迅策科技有限公司 | Method, device and equipment for quickly querying data based on WPS/EXCEL and storage medium |
-
2015
- 2015-01-21 CN CN201510028548.1A patent/CN105868196A/en active Pending
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106776799A (en) * | 2016-11-23 | 2017-05-31 | 广东小天才科技有限公司 | A kind of quality information record and the method and apparatus of analysis |
| CN106776799B (en) * | 2016-11-23 | 2020-02-07 | 广东小天才科技有限公司 | Method and equipment for recording and analyzing quality information |
| CN107562888A (en) * | 2017-09-05 | 2018-01-09 | 北京瑞凯软件科技开发有限公司 | The data sheet generation method and system of a kind of track traffic synthetic monitoring system |
| CN108536660A (en) * | 2018-04-03 | 2018-09-14 | 福建榕基软件工程有限公司 | A kind of generation method and terminal of self-defined report |
| CN108536660B (en) * | 2018-04-03 | 2023-08-04 | 福建榕基软件工程有限公司 | Custom report generation method and terminal |
| CN109241514A (en) * | 2018-09-10 | 2019-01-18 | 深圳市泰洲科技有限公司 | Data automatically imported method, device, computer equipment and storage medium |
| CN109446507A (en) * | 2018-11-13 | 2019-03-08 | 浙江中智达科技有限公司 | A kind of construction method and device of report |
| CN111444171A (en) * | 2018-12-28 | 2020-07-24 | 航天信息股份有限公司 | Method, device and storage medium for generating value-added tax return form |
| CN110765750A (en) * | 2019-09-16 | 2020-02-07 | 平安科技（深圳）有限公司 | Report data entry method and terminal equipment |
| CN110765750B (en) * | 2019-09-16 | 2024-03-15 | 平安科技（深圳）有限公司 | Report data input method and terminal equipment |
| CN115392206A (en) * | 2022-10-26 | 2022-11-25 | 深圳迅策科技有限公司 | Method, device and equipment for quickly querying data based on WPS/EXCEL and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105868196A (en) | Method for generating industrial data report in server | |
| CN110083650B (en) | Metadata self-discovery-based automatic generation method for data query interface | |
| CN105868170A (en) | Method for generating industrial data report in server | |
| CN105224351A (en) | Rapid configuration implementation method and rapid configuration server | |
| CN103020089A (en) | Method and device for importing data in EXCEL file to database | |
| CN105183672B (en) | A kind of adaptive interface call method and system | |
| CN103729742B (en) | A kind of Data Resources Management System based on SOA framework and executing model drive structure | |
| CN110955715A (en) | ERP system, data conversion method and device of target platform and electronic equipment | |
| CN103701817A (en) | Method and device for generating configuration file | |
| US20140095550A1 (en) | Converting source objects to target objects | |
| CN107436785B (en) | Revit software information interaction system and interaction method based on information system | |
| CN102857949A (en) | Method and device for planning data consistency guarantees | |
| CN115688715A (en) | Report generation method and device and computer readable medium | |
| CN103678591A (en) | Device and method for automatically executing multi-service receipt statistical treatment | |
| CN113256163B (en) | Smart city government affair cloud platform off-network operation method and system | |
| CN112035466B (en) | External index development framework for block chain query | |
| CN112395339B (en) | Intersystem data admission verification method, device, computer equipment and storage medium | |
| CN113722345A (en) | Method and device for displaying mapping relation, electronic equipment and storage medium | |
| CN103425793B (en) | Method for utilizing database purchase layer to access data base in instant communicating system | |
| CN111368353B (en) | CAD drawing die turning method, system, device and storage medium | |
| CN110532305A (en) | A kind of business datum method for cutting over and system | |
| CN108984156A (en) | A kind of software auto generating method and system for exempting from code development based on template | |
| CN104333806A (en) | Set top box parameter operation method and device | |
| CN105868198A (en) | Generating method of server-side industrial data report | |
| CN103561113A (en) | Web Service interface generating method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20160817 |
|
| WD01 | Invention patent application deemed withdrawn after publication |