CN103606045B - Report form generation method and report form system - Google Patents
Report form generation method and report form system Download PDFInfo
- Publication number
- CN103606045B CN103606045B CN201310587182.2A CN201310587182A CN103606045B CN 103606045 B CN103606045 B CN 103606045B CN 201310587182 A CN201310587182 A CN 201310587182A CN 103606045 B CN103606045 B CN 103606045B
- Authority
- CN
- China
- Prior art keywords
- report
- data
- item
- organization
- statistics
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 34
- 230000008520 organization Effects 0.000 claims abstract description 106
- 238000012795 verification Methods 0.000 claims description 26
- 238000012550 audit Methods 0.000 claims description 8
- 238000013479 data entry Methods 0.000 claims description 6
- 230000000737 periodic effect Effects 0.000 claims description 6
- 230000008859 change Effects 0.000 abstract description 6
- 238000012545 processing Methods 0.000 abstract description 3
- 238000013475 authorization Methods 0.000 abstract 1
- 238000012986 modification Methods 0.000 description 15
- 230000004048 modification Effects 0.000 description 15
- 230000006870 function Effects 0.000 description 13
- 230000008569 process Effects 0.000 description 12
- PEDCQBHIVMGVHV-UHFFFAOYSA-N Glycerine Chemical compound OCC(O)CO PEDCQBHIVMGVHV-UHFFFAOYSA-N 0.000 description 11
- 238000012217 deletion Methods 0.000 description 11
- 230000037430 deletion Effects 0.000 description 11
- 238000012423 maintenance Methods 0.000 description 8
- 230000003442 weekly effect Effects 0.000 description 7
- 238000011156 evaluation Methods 0.000 description 4
- 238000007726 management method Methods 0.000 description 4
- 238000012508 change request Methods 0.000 description 3
- 230000005611 electricity Effects 0.000 description 3
- 230000010354 integration Effects 0.000 description 3
- 230000007704 transition Effects 0.000 description 3
- 230000006978 adaptation Effects 0.000 description 2
- 230000008901 benefit Effects 0.000 description 2
- 238000013480 data collection Methods 0.000 description 2
- 241000208340 Araliaceae Species 0.000 description 1
- 206010026749 Mania Diseases 0.000 description 1
- 235000005035 Panax pseudoginseng ssp. pseudoginseng Nutrition 0.000 description 1
- 235000003140 Panax quinquefolius Nutrition 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 238000012790 confirmation Methods 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 235000008434 ginseng Nutrition 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000010248 power generation Methods 0.000 description 1
- 230000008439 repair process Effects 0.000 description 1
- 238000012552 review Methods 0.000 description 1
- 238000010200 validation analysis Methods 0.000 description 1
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/80—Management or planning
- Y02P90/82—Energy audits or management systems therefor
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a report form generation method, an automatic report form data statistics method, an automatic report form update method and a report form system. The report form system comprises a data logging unit, a data checking unit and a report form generation unit, wherein the data logging unit is suitable for receiving reporting item data of an organization logged by a data logging part based on authorization according to a reporting scheme, and legality of the logged data is further verified, the data checking unit is suitable for receiving a checking result of the logged reporting scheme of a data checking part, whether data re-logging of the data logging unit is needed is determined according to the checking result; the report form generation unit is suitable for receiving a report form template file and report form generation rules selected by a report form generation part and is further suitable for processing the data in the reporting scheme according to the report form generation rules, a report form is further generated according to the report form template file and is a register report form, and the register report form is stored by the report form generation unit in a register report form database. The report form system flexibly meets electric power data reporting requirements and report form change requirements and is convenient for a user.
Description
Technical field
The present invention relates to technical field of data processing, more particularly, to a kind of report form generation method and reporting system.
Background technology
Company organization of Chinese electricity power group level is generally divided into three-level, such as group company, secondary corporate, power plant, extremely individual
Three-level company is administered, power plant is administered by three-level company below other point of level Four, such as secondary corporate.Five big electricity power groups of China are public
Big companies' tissue such as department and China Resources Power, Guohua Electric Power, state's throwing electric power is all such.The production and operation of company of electricity power group is come
Say, main basic data is all from power plant and unit, how to pass through unit, the day data on the basis in power plant, automatically converges
Assembly three-level company, secondary corporate, the day data of group company, weekly data, moon data, season data, annual data, and finally automatic
Generate the bordereau that each tissue is concerned about, be an extremely complex processing procedure.
General generating data is made a report on system and is all made a report on data item and computing formula using solidifying each, leads to the system can not
Flexible expansion makes a report on item, and system later maintenance workload is very big to be adjusted it is impossible to meet the regular business demand of client.
Content of the invention
The technical problem to be solved in the present invention is, for the deficiencies in the prior art, provides a kind of report form generation method and report
Table system, energy flexible adaptation or extended power data make a report on demand and form change request, facilitate user.
According to one aspect of the invention, provide a kind of report form generation method, including：According to the scheme of making a report on, receiving data is recorded
Item data is made a report on based on this tissue authorizing institute's typing by the side of entering, and verifies the legitimacy of institute's logging data；Wherein, described make a report on
Schema definition is one or more to make a report on item；The auditing result making a report on scheme to typing for the receiving data examination ＆ verification side, and according to careful
Core result decides whether to re-start data inputting；Receive report form template file and the report generation that report generation side selects
Rule；Wherein, described report generation rule is plan target cron expression formula；According to report generation rule, in the scheme of making a report on
Data processed, and according to report form template file generated form, this form is certified sheets.
According to a further aspect of the present invention, a kind of report data method for automatically counting is provided, including：For certified sheets,
Traversal makes a report on item, for making a report on item data, judges that the group organization data of its association whether there is, if group organization data does not exist, continues
Continuous traversal makes a report on item（Execute this step）If group organization data exists, and executes below step；Carry out in time cycle dimension
Statistics：Judge whether parent organization, if there is parent organization, then first the parent organization of statistics current time counts, directly
Item data of making a report on to the current time of all parent organization all counts and completes, then counts and make a report on item institute other cycles organized
Statistics, finally count the statistics in other cycles of all parent organization；Carry out the statistics in space periodic dimension, that is, organize loom
Statistics in structure dimension：The tissue set of the minimal level based on the system that is entered into, obtains the parent organization of this tissue set, system
The parent organization of meter current time period make a report on entry value, the parent organization of current time is made a report on after the completion of entry value all counts, and continues
Continuing calls the parent organization of parent organization to make a report on entry value, and the tissue until having counted all tops makes a report on entry value；If statistics
Complete current time make a report on entry value in a organized way, then enter the statistics currently making a report on other cycles of item；Until all minimal level
After the completion of the value making a report on item in the other times cycle of tissue all counts, finally count the other times cycle of all parent organization
Make a report on entry value.
According to another aspect of the present invention, provide a kind of form automatic update method, including：Traversal certified sheets, reads
Form Cron expression formula, judges whether to meet Cron expression formula；If being unsatisfactory for Cron expression formula, continue traversal certified sheets；
If meeting Cron expression formula, according to current time and report name, reporting period, judge whether accounting logging；If
There is current accounting logging, continue to travel through registered form；If there is no current accounting logging, read form configuration
File, and save as specifying the accounting logging of report name and report time, read the data set of form and joining of report form template
Confidence ceases, and executes data set SQL statement, and data set result is written to current form note according to the configuration information of report form template
Record, finally closes current report file.
According to a further aspect of the present invention, a kind of reporting system is provided, including：Data entry element, is suitable to basis and makes a report on
Scheme, item data is made a report on based on this tissue authorizing institute's typing by receiving data typing side, and verifies the legal of institute's logging data
Property；Data audits unit, is suitable to the auditing result making a report on scheme to typing for the receiving data examination ＆ verification side, and is determined according to auditing result
Determine the need of the data inputting re-starting data entry element；Report generation unit, is suitable to receive the selection of report generation side
Report form template file and report generation rule；It is further adapted for according to report generation rule, at the data in the scheme of making a report on
Reason, and according to report form template file generated form, this form is certified sheets；Certified sheets is saved in note by report generation unit
In volume report database.
According to a further aspect of the present invention, a kind of reporting system is also provided, including：Make a report on administrative unit, be used for making a report on item
Safeguard, scheme of making a report on is safeguarded, data is made a report on, data examination ＆ verification data inquiry；Report Server Management unit, for form registration, form
Authorize, form is issued and report query；And System Management Unit, for organizational protection, post is safeguarded, personnel safeguard, menu dimension
Shield, authority maintenance, unit maintenance, business classification are safeguarded.
With prior art ratio, the present invention provide method and system have the advantage that：
Energy flexible adaptation or extended power data make a report on demand and form change request, facilitate user；
Can customize and make a report on item, make a report on scheme, bordereau, self-defined can make a report on the statistical formula of item simultaneously and store
Journey, the programming count of optimized integration data, collects function；
Programming count, collect function and can carry out on tissue and time dimension, such as unit data summarization becomes power plant's data,
Power plant's data summarization becomes secondary corporate's data, and secondary corporate's data summarization becomes group company's data, and hour data counts number of days
According to day data statisticss go out weekly data, and weekly data counts a moon data, and moon data statisticss go out annual data etc..
Brief description
Fig. 1 be according to one embodiment of the invention provide concept between logical relation schematic diagram；
Fig. 2 is the report form generation method flow chart being provided according to one embodiment of the invention；
Fig. 3 is the report data method for automatically counting flow chart being provided according to one embodiment of the invention；
Fig. 4 is the form automatic update method flow chart being provided according to one embodiment of the invention；
Fig. 5 is the reporting system structural representation being provided according to one embodiment of the invention；
Fig. 6 is the reporting system structural representation providing according to a further embodiment of the invention；
Fig. 7 is the data programming count flow chart providing according to a further embodiment of the invention；
Fig. 8 is that the data sheet providing according to a further embodiment of the invention automatically generates flow chart.
Specific embodiment
In order that the objects, technical solutions and advantages of the present invention become more apparent, below in conjunction with accompanying drawing, the present invention is entered
One step describes in detail.It should be appreciated that specific embodiment described herein, only in order to explain the present invention, is not used to limit this
Invention.Other embodiments can include structure, logic, electric, process, embodiment only represents possible change.
Unless explicitly requested, otherwise individually assembly and function are optional, and the order operating can change.In the feelings do not conflicted
Under condition, the embodiment in the application and the feature in embodiment can be mutually combined.The part of some embodiments and feature can
To be included in or to replace part and the feature of other embodiments.The scope of embodiment of the present invention includes claims
Gamut, and all obtainable equivalent of claims.
Definition and explanation
Make a report on scheme：Be make a report on data represent form, the item of making a report on of some correlations is organized together, is just formed and make a report on
Scheme.Scheme of making a report on is associated with post, and the post personnel of only mandate could use the scheme of making a report on；Make a report on scheme and tissue
Associate, scheme of making a report on only shows the group organization data of association.
According to one embodiment of the invention, as shown in figure 1, the scheme of making a report on comprises the maintenance making a report on item, they are one-to-manies
Relation, make a report on simultaneously scheme and organization, make a report on scheme and unit, make a report on scheme and post be multi-to-multi relation, one
The individual scheme of making a report on can comprise multiple organizations, unit, post, and organization, unit, a post can comprise multiple filling out
Report scheme.Form mandate achieves the many-to-many relationship in post and form, and a post can comprise multiple forms, a form
Multiple posies can be comprised, form mandate simultaneously achieves the priority assignation browsing, edit, issuing to form for the post.Authority
Safeguard the maintenance of the many-to-many relationship achieving post and menu, post and personnel, post can comprise multiple menus and
Multiple personnel, personnel can have multiple posies and multiple menu.
Report form generation method
According to one embodiment of the invention, provide a kind of report form generation method, as shown in Fig. 2 the method includes：
S11, basis make a report on scheme, and item data is made a report on based on this tissue authorizing institute's typing by receiving data typing side, and
The legitimacy of checking institute logging data；Wherein, described make a report on that schema definition is one or more to make a report on item；
S12, the auditing result making a report on scheme to typing for the receiving data examination ＆ verification side, and need are decided whether according to auditing result
Re-start the data inputting of step S11；
S13, the report form template file receiving the selection of report generation side and report generation rule；Wherein, described report generation
Rule is plan target cron expression formula；
S14, according to report generation rule, the data in the scheme of making a report on is processed, and according to report form template file life
Become form, this form is certified sheets.
Wherein, data inputting side described in S11-S13, data examination ＆ verification side and report generation side can be computing device, meter
Data base on calculation equipment or data processing software, sensor circuit or operator.
According to a further embodiment of the invention, provide a kind of report data method for automatically counting, as shown in figure 3, including：
S21, be directed to certified sheets, traversal make a report on item, for making a report on item data, judge its association group organization data whether deposit
If group organization data does not exist, continuing traversal and making a report on item（Execute this step）If group organization data exists, and execution is following
Step；
S22, the statistics carrying out in time cycle dimension：
Judge whether parent organization, if there is parent organization, then first the parent organization of statistics current time counts,
Until the item data of making a report on of the current time of all parent organization all counts and completes, then count and make a report on item institute other weeks organized
The statistics of phase, finally counts the statistics in other cycles of all parent organization；
S23, the statistics carrying out in space periodic dimension, i.e. statistics in organization's dimension：
The tissue set of the minimal level based on the system that is entered into, obtains the parent organization of this tissue set, and statistics is current
The parent organization of time cycle make a report on entry value, the parent organization of current time is made a report on after the completion of entry value all counts, and continues to call
The parent organization of parent organization makes a report on entry value, and the tissue until having counted all tops makes a report on entry value；
If counted current time makes a report on entry value in a organized way, enter the statistics currently making a report on other cycles of item；
After the completion of the value making a report on item in the other times cycle of all minimal level tissue all counts, finally count all higher level's groups
The other times cycle knitted make a report on entry value.
According to a further embodiment of the invention, provide a kind of form automatic update method, as shown in figure 4, including：
S31, the registered form of traversal, read form Cron expression formula, judge whether to meet Cron expression formula；If no
Meet Cron expression formula, continue to travel through registered form；
If S32 meets Cron expression formula, according to current time and report name, reporting period, judge whether to report
Table record；If there is current accounting logging, continue to travel through registered form；
S33, if there is no current accounting logging, read form configuration file, and save as specifying report name and
The accounting logging of report time, reads the data set of form and the configuration information of report form template, executes data set SQL statement, and
Data set result is written to current accounting logging according to the configuration information of report form template, finally closes current report file.
Reporting system
With above method correspondingly, according to one embodiment of the invention, provide a kind of reporting system.As shown in figure 5, this report
Table system 50 includes：
Data entry element 51, is suitable to according to making a report on scheme, receiving data typing side is based on this tissue authorizing institute's typing
Make a report on item data, and verify the legitimacy of institute's logging data；
Data audits unit 52, is suitable to the auditing result making a report on scheme to typing for the receiving data examination ＆ verification side, and according to careful
Core result decides whether to re-start the data inputting of data entry element 51；
Report generation unit 53, is suitable to receive report form template file and the report generation rule that report generation side selects；Also
It is suitable to, according to report generation rule, the data in the scheme of making a report on be processed, and according to report form template file generated form, should
Form is certified sheets.Certified sheets is saved in certified sheets data base 56 report generation unit 53.
According to a further embodiment of the invention, above-mentioned reporting system also includes：
Data programming count unit 54, is suitable to for certified sheets, traversal is made a report on item, for making a report on item data, judged it
The group organization data of association whether there is, if group organization data does not exist, continues traversal and makes a report on item（Execute this step）If, group
Organization data exists, and executes below step；
（1）Carry out the statistics in time cycle dimension：
Judge whether parent organization, if there is parent organization, then first the parent organization of statistics current time counts,
Until the item data of making a report on of the current time of all parent organization all counts and completes, then count and make a report on item institute other weeks organized
The statistics of phase, finally counts the statistics in other cycles of all parent organization；
（2）Carry out the statistics in space periodic dimension, i.e. statistics in organization's dimension：
The tissue set of the minimal level based on the system that is entered into, obtains the parent organization of this tissue set, and statistics is current
The parent organization of time cycle make a report on entry value, the parent organization of current time is made a report on after the completion of entry value all counts, and continues to call
The parent organization of parent organization makes a report on entry value, and the tissue until having counted all tops makes a report on entry value；
If counted current time makes a report on entry value in a organized way, enter the statistics currently making a report on other cycles of item；
After the completion of the value making a report on item in the other times cycle of all minimal level tissue all counts, finally count all higher level's groups
The other times cycle knitted make a report on entry value.
According to a further embodiment of the invention, above-mentioned reporting system also includes：
Form automatically updates unit 55, is suitable to：Travel through registered form, read form Cron expression formula, judge whether
Meet Cron expression formula；If being unsatisfactory for Cron expression formula, continue to travel through registered form；
If meeting Cron expression formula, according to current time and report name, reporting period, judge whether that form is remembered
Record；If there is current accounting logging, continue to travel through registered form；
If there is no current accounting logging, read form configuration file, and save as specifying report name and form
The accounting logging of time, reads the data set of form and the configuration information of report form template, executes data set SQL statement, and by number
It is written to current accounting logging according to collection result according to the configuration information of report form template, finally close current report file.
According to a further embodiment of the invention, a kind of application is provided to make a report in power system, configurable generating data
And reporting system（Abbreviation reporting system）, as shown in fig. 6, including：
Make a report on administrative unit（1）, it is used for making a report on item maintenance（1.1）, make a report on scheme safeguard（1.2）, data makes a report on（1.3）、
Data is audited（1.4）Data is inquired about（1.5）；
Report Server Management unit（2）, for form registration（2.1）, form mandate（2.2）, form issue（2.3）Look into form
Ask（2.4）；With
System Management Unit（3）, for organizational protection（3.1）, post safeguard（3.2）, personnel safeguard（3.3）, menu dimension
Shield（3.4）, authority safeguard（3.5）, unit maintenance（3.6）, business classification safeguard（3.7）.
The classification that system solves the problem generating business datum is made a report on, automatically the collecting of basic data, bordereau automatic
The problems such as generation, it is described in detail below：
Make a report on item to safeguard（1.1）Refer to realize increase, deletion, modification and the inquiry that generating business makes a report on item, make a report on a content
Including business classification, make a report on a title, make a report on item coding, data type（Numerical value, date, character string）, data length, data essence
Degree (just for value type), data unit（Ton, ten thousand kilowatt hours etc.）, attribution data（Unit, power plant, secondary unit, group are public
Department, can multiselect）, Data Source（Make a report on, expression formula, storing process, realize class）, source formula（Expression formula content, storing process
Title, realize class name）, the data cycle（Point, when, sky, week, the moon, season, half a year, year）, the data upper limit, data lower limit, whether must
Fill out, statistical（Expression formula, storing process, realize class）, statistical formula（Expression formula content, storing process title, realize class name
Claim）, sequence.
Wherein, simple Data Source formula and collect upwards, statistical formula available expression directly configures computing formula,
Complicated peek rule and statistic logic can be write storing process or realize class.
Scheme of making a report on is safeguarded（1.2）Refer to realize increase, deletion, modification and the inquiry that generating data makes a report on scheme, content bag
Include Scenario Name, scheme code, data cycle（Day, week, the moon, season, half a year, year）, higher level's scheme, comprise tissue（Comprise power plant
Lower unit）, comprise post.
Data is made a report on（1.3）The classification referring to realize generating business datum is made a report on, and data is made a report on and shown by the scheme of making a report on, point day
Data is made a report on, weekly data is made a report on, moon data is made a report on, season data is made a report on, half annual data is made a report on, annual data is made a report on, and selects to make a report on week
Phase, make a report on scheme, after filling time it is possible to fill in the value making a report on item under current organization.
Data is made a report on realization and is made a report on item data and makes a report on, and data is made a report on and shown by the scheme of making a report on, the condition of making a report on make a report on scheme,
Filling time, reporter（Signature Confirmation）, make a report in have business classification（Read-only）, make a report on a title（Read-only）, data unit
（Read-only）, make a report on entry value（Current organization value）, XX machine class value（Current organization be power plant, and make a report on item data ownership comprise machine
Group）.Selection is made a report on scheme, is respectively made a report on entry value it is possible to fill in after filling time, if power plant personnel make a report on, and makes a report on
The attribution data of item comprises unit, arises that unit makes a report on value, when completing each machine class value making a report on item, makes a report on power plant's number of item
According to just automatically computing.
Manually enter makes a report on entry value, and system can verify legitimacy automatically, and can verify required item content and bound, surpasses
Cross the red display of data mark of bound.Data complete whole after, through validation verification, click reports, and data is put into pending
Link, data is made a report on work and is just completed.
Data is audited（1.4）Refer to realize the examination ＆ verification of generating business datum, data examination ＆ verification show by the scheme of making a report on, divide day data
Examination ＆ verification, weekly data examination ＆ verification, moon data examination ＆ verification, season data examination ＆ verification, half a year datagram, annual data are made a report on, and select Review Cycle, make a report on
Scheme, after audit time it is possible to examination ＆ verification current organization and its subordinate organization the value making a report on item.
Data examination ＆ verification is realized making a report on the examination ＆ verification of item data, and content has pending and audited list, inside pending list
Can show that reported makes a report on scheme, filling time, makes a report on tissue, reporter, audit display and audited making a report on of passing through
Scheme, filling time, make a report on tissue, reporter, person approving.Click on certain a line of examination ＆ verification list, the association of this row will be shown
Scheme of making a report on is corresponding to make a report on item data value.To pending data, examination ＆ verification can be clicked on and pass through or reject modification button, realize
Data audit function, has to fill out rejection suggestion when rejecting modification, in addition can directly change and pending make a report on entry value.All
After subordinate organization's unit examination ＆ verification is passed through, system starts to count superior unit related data.
Data query（1.5）Refer to realize making a report on the inquiry of item data, make a report on similar with data, simply can not carry out increasing,
Delete, modification operation, than data made a report on many one tissue querying condition, can inquire about subordinate tissue makes a report on entry value, write from memory
That recognizes this tissue of display makes a report on entry value.
Form is registered（2.1）Refer to realize increase, deletion, modification and the inquiry of generating bordereau, form registration content has
Form coding, report name, data cycle（Day, week, the moon, season, half a year, year）, report generation path（Road on Web server
Footpath）, report form template file（Support the file format such as WORD, EXCEL, WPS）, report generation rule（Plan target cron is expressed
Formula）, whether effectively, and by report data configuration button, realize the data configuration of each report form template.
Specifically, click on report data configuration button, eject form configuration information window, report data configuration information window
Inside have reception parameter definition, three Shipping Options Pages of DSD data configuration definition.Receive parameter definition to realize receiving ginseng
The increase of number, deletion, modification and display, receive in parameter list and have parameter name, parameter declaration, data type（Numerical value, day
Phase, character string）.DSD realizes the increase of data set, deletion, the inquiry of modification data collection data, has data set name
Claim, data set contents (SQL statement of data query, SQL statement can quote reception parameter, receive parameter use "？" represent), connect
Receive parameter（Input receives parameter name, and multiple reception parameters adopt comma separately）, data set explanation.Data configuration definition is realized
Data in report form template is mated with number of data sets evidence, can increase, delete, changes data configuration defined item.
According to different report form template file types, there are different definition modes：
Excel file adopts sheet [index or title]. and cell indexed mode defines a cell, Word file
One data item is defined using field code mode.Form content expression formula is had in data configuration definition（Excel cell is expressed
Formula or Word domain name）, data set contents expression formula（Dataset name. field name or dataset name .select (' field name
Claim ', ' filtercondition ', ' sort criteria '）Or Java language transition formula evaluation, Java expression formula can use data set. field name）、
Extended mode（Do not extend, extending transversely, Longitudinal Extension）, display format（Numerical value and date format）.Java backstage report form processing
Program, when generating form, first determines whether that the form of current point in time whether there is, if it does not exist, then according to report file
Template duplicating is a, according to report form template file and report data configuration information, reads SQL data and updates current form literary composition
In part, all report data configuration informations of a report form template process and are over, and a report generation just finishes.
Form mandate（2.2）Refer to realize role and priority assignation, the form mandate such as browse, edit, issuing to certified sheets
Inside have role name to claim, report name, browse（Check box, chooses or does not select）, editor（Choose or do not select）, issue（Choosing
In or do not select）.
Specifically, for example, the form authority page left side is permissions list, and the right is Report List, clicks on permissions list
Row data, the Report List on the right lists the Report List that this authority has, and can arrange browsing, compiling of every row form simultaneously
Collect, issue authority.Click on newly-increased button, the list ejecting unauthorized form selects, and list content has selection（Check box）, form
Title, browse right（Check box）, editing authority（Check box）, issue authority（Check box）, chosen form to be authorized and
After authority, click on confirming button, give, the form permission grant newly increasing, the post specified.
Form is issued（2.3）Refer to online editing, stamped signature and the issuing function realizing having generated form, and non-issued state
Form regenerate function, the form after issue can not be edited, deletes and regenerate.Form is issued in list display and is had
Organization unit, report name, report time, report generation time, reporting status.Automatically display login personnel current organization list
Position do not issue Report List.
Report query（2.4）Refer to realize issued the inquiry of form, browsed, download, report query content in a organized way unit,
Report name, report time, reporting status, Report downloading, querying condition unit, report name, report time, form in a organized way
State, can directly open form content by the report name hyperlink in list（Need office online editing software, read-only beat
Open）.
Organizational protection（3.1）The increase of finger realization tissue, deletion, modification, inquiry, organising content encodes in a organized way（Only
One）, organization name, tissue abbreviation, organization type, parent organization, organize director, phone, fax, address, postcode, sequence,
Whether effective.
Post is safeguarded（3.2）Refer to realize the increase in post, deletions, modification, inquire about, post encodes post content in a organized way
（Uniquely）, post title, remarks, user and menu that each post has can be checked simultaneously.
Personnel safeguard（3.3）Refer to realize the increase of personnel, deletions, modification, inquire about, task definition has affiliated tissue, personnel
Coding（Uniquely）, personnel's title, job number, sex, name race, educational background, specialty, phone, mobile phone, mail, address, password, verification close
Code, whether password is never expired, password expiration date, effective.
Menu is safeguarded（3.4）Refer to realize the increase of systemic-function menu, deletions, modification, inquire about, menu content has menu volume
Code（Uniquely）, pad name, feature path, picture path, unfolding mode, Previous Menu, sequence number.By the function road of menu
Footpath and unfolding mode, open the application function of menu association.
Authority is safeguarded（3.5）Refer to realize the mandate of systemic-function, that is, the corresponding menu in post and personnel safeguard.The left side is hilllock
Rank table, top right-hand side is the corresponding lists of persons in post, the corresponding menu list in bottom right Bian Shi post.Can increase, delete, repair
Change, inquire about the corresponding personal information in post and menu information, chosen by way of undelegated personnel and menu by pop-up window
Realize.
Unit maintenance（3.6）Refer to realize the increase of unit, deletions, modification, inquire about, unit content has unit coding（Only
One）, group name, affiliated tissue, unit capacity, machine set type, power generation type, set state.
Business classification is safeguarded（3.7）Refer to realize generating business classification increase, deletions, modification, inquire about, business categorised content
There are operation code, Business Name, higher level's business, remarks, business classification can be one-level or two-stage.
After basic data typing and Authorized operation, data inputting personnel may log into system, enters data and makes a report on
Menu carries out the typing of basic data, select to make a report on scheme and after filling time it is possible to this tissue of typing make a report on item data,
Data can enter data query after having made a report on and form browses menu, and examination ＆ verification situation and the report data feelings of data are made a report in inquiry
Condition.Data auditor's login system, enters data and audits the examination ＆ verification that menu carries out basic data, after the completion of examination ＆ verification, can be clear
Look at the data cases of form, if auditor possesses form and issues authority, can directly audit and change form, examination ＆ verification report
After the completion of table, click on and issue, complete the issue of form.After form post staff's login system, it is directly entered form and issues menu,
Check report generation situation and report data, after report data examination ＆ verification, click on and issue, complete the issue of form.
The automatic statistical function upwards of data item in organization unit and time dimension for the background scheduler.As minute, little
When data programming count to day data, day data programming count to week, moon data, unit data programming count to power plant's data,
Power plant's data programming count is to secondary unit data.Thus optimized integration data collects automatically.
Background scheduler according to bordereau template file, data configuration rule, task scheduling Cron expression formula, regularly
Generate bordereau file.Thus realize bordereau automatically generating.
According to one embodiment of the invention, above-mentioned reporting system passes through a web application system and realizes, and it is by data
Storehouse and application server composition.This system energy flexible expansion generating data makes a report on demand and form change request, can customize and fills out
Report item, make a report on scheme, bordereau, self-defined can make a report on statistical formula and the storing process of item simultaneously, optimized integration data
Programming count, collect function.Programming count, collect function and can carry out on tissue and time dimension, such as unit data summarization
Become power plant's data, power plant's data summarization becomes secondary corporate's data, and secondary corporate's data summarization becomes group company's data, hour data
Count a day data, day data statisticss go out weekly data, weekly data counts a moon data, moon data statisticss go out annual data etc..
As shown in fig. 7, the data programming count stream of this system is as follows：
1st, web application starts programming count scheduler task program, and the circulation of this scheduler program makes a report on item, from making a report on item
Take out the minimum data cycle in the data cycle, and according to current time, obtain and currently make a report on the cycle, inquire about this and make a report on item and currently fill out
The tissue in report cycle whether there is, if it does not, explanation does not also have what any tissue made a report on current time to make a report on item data,
Then do not carry out any statistics, take out the next one and make a report on item.
2nd, if there is the group organization data making a report on item of current time, then the statistics of two dimensions to be carried out, one when being
Between statistics on periods dimension（As hour data counts into a day data）, statistics in a Ge Shi organization dimension（As unit
Data statisticss become power plant's data）.It is first determined whether there is parent organization, if there is parent organization, then preferential statistics is current
The parent organization statistics of time, until the item data of making a report on of the current time of all parent organization all counts and completes, then counts and fills out
Report item other cycles organized statistics, finally count the statistics in other cycles of all parent organization.
3rd, when statistics makes a report on statistics in an organization dimensionality, come at first is the group of the minimal level of the system that is entered into
Knit set, obtain the parent organization of this tissue set, the parent organization of statistics current time period make a report on entry value.During statistics,
Parsing is made a report on the transition formula evaluation of item or is called storing process or calling interface program, and the parameter of storing process and interface routine is to fill out
Report item, tissue, current time period, return value is to make a report on a statistical value.The parent organization of current time is made a report on entry value and is all counted
After the completion of, continue to call the parent organization of parent organization to make a report on entry value, the tissue until having counted all tops makes a report on entry value.
If 4 counted current time make a report on entry value in a organized way, enter the system currently making a report on other cycles of item
Meter.Tissue and other data cycles are made a report in circulation, organize the statistical condition in other cycles, and statistics makes a report on the value in other cycles of item,
Parsing is made a report on the transition formula evaluation of item or is called storing process or calling interface program, and the parameter of storing process and interface routine is to fill out
Report item, tissue, other times cycle, return value is to make a report on a statistical value.If there is no the tissue number making a report on other cycles of item
According to that then inserts this other cycle of tissue makes a report on item data；If there is the group organization data making a report on other cycles of item, then update system
Evaluation.
5th, after the completion of the value making a report on item in the other times cycle of all minimal level tissue all counts, finally count
The other times cycle of all parent organization make a report on entry value, with statistics the 3rd step in statistics all parent organization current when
Between periodic quantity be similar to, simply time range is different.During actual treatment, this function is packaged into function it is only necessary to incoming make a report on
Item, minimal level tissue set, timing statisticses cycle, you can realize making a report on all parent organization within the timing statisticses cycle for the item
Data statisticss.
6th, count all parent organization the other times cycle make a report on entry value after the completion of, be recycled into the next one and make a report on item
Statistics, until all make a report on item statistics after the completion of, exit programming count scheduler task program.
As shown in figure 8, the data sheet of this system automatically generate stream as follows：
1st, web application starts automatic report generation scheduler task program, and this scheduler program travels through registered form,
Read form Cron expression formula, judge whether to meet Cron expression formula.
If 2 are unsatisfactory for Cron expression formula, take out next registered form, judge whether to meet Cron expression
Formula.
If 3 meet Cron expression formula, according to current time and report name, reporting period, judge whether form
Record, if there is current accounting logging, then takes out next registered form, judges whether to meet Cron expression formula.
4th, if there is no current accounting logging, read form configuration file, and save as specifying report name and report
The accounting logging of table time.Read the data set data collection of form and the configuration information of report form template simultaneously, execute data set
SQL statement, and data set result is written to current accounting logging according to the configuration information of report form template, finally close current report
List file.
5th, judge whether previous cycle terminates, if terminating, terminating this task dispatch, if do not terminated, taking
Go out next registered form, judge whether to meet Cron expression formula.
It should be noted that and understanding, in the feelings without departing from the spirit and scope of the present invention required by appended claims
Under condition, various modifications and improvements can be made to the present invention of foregoing detailed description.It is therefore desirable to the model of the technical scheme of protection
Enclose and do not limited by given any specific exemplary teachings.
Claims (3)
1. a kind of report data method for automatically counting, including：
For certified sheets, traversal makes a report on item, for making a report on item data, judges that the group organization data of its association whether there is, if
Group organization data does not exist, and continues traversal and makes a report on item, if group organization data exists, executes below step；
Carry out the statistics in time cycle dimension：Judge whether parent organization, if there is parent organization, then first statistics is worked as
The parent organization statistics of front time, until the item data of making a report on of the current time of all parent organization all counts and completes, then counts
Make a report on item other cycles organized statistics, finally count the statistics in other cycles of all parent organization；
Carry out the statistics in space periodic dimension, i.e. statistics in organization's dimension：Minimal level based on the system that is entered into
Tissue set, obtain the parent organization of this tissue set, the parent organization of statistics current time period make a report on entry value, currently
The parent organization of time is made a report on after the completion of entry value all counts, and continues to call the parent organization of parent organization to make a report on entry value, Zhi Daotong
The tissue counting all tops makes a report on entry value；If counted current time makes a report on entry value in a organized way, enter current
Make a report on the statistics in other cycles of item；Complete until the value making a report on item in the other times cycle of all minimal level tissue all counts
Afterwards, finally count all parent organization the other times cycle make a report on entry value.
2. a kind of reporting system, including：
Data entry element, is suitable to according to making a report on scheme, receiving data typing side is made a report on based on this tissue authorizing institute's typing
Item data, and verify the legitimacy of institute's logging data；
Data audits unit, is suitable to the auditing result making a report on scheme to typing for the receiving data examination ＆ verification side, and according to auditing result
Decide whether to re-start the data inputting of data entry element；
Report generation unit, is suitable to receive report form template file and the report generation rule that report generation side selects；It is further adapted for root
According to report generation rule, the data in the scheme of making a report on is processed, and according to report form template file generated form, this form is
Certified sheets；Certified sheets is saved in certified sheets data base report generation unit；With
Data programming count unit, is coupled with described certified sheets data base, is suitable to for certified sheets, traversal makes a report on item, right
In making a report on item data, judge that the group organization data of its association whether there is, if group organization data does not exist, continue traversal and make a report on item,
If group organization data exists, execute below step；
Carry out the statistics in time cycle dimension：
Judge whether parent organization, if there is parent organization, then first the parent organization of statistics current time counts, until
The item data of making a report on of the current time of all parent organization all counts and completes, then count make a report on item other cycles organized
Statistics, finally counts the statistics in other cycles of all parent organization；
Carry out the statistics in space periodic dimension, i.e. statistics in organization's dimension：
The tissue set of the minimal level based on the system that is entered into, obtains the parent organization of this tissue set, counts current time
The parent organization in cycle make a report on entry value, the parent organization of current time is made a report on after the completion of entry value all counts, and continues to call higher level
The parent organization of tissue makes a report on entry value, and the tissue until having counted all tops makes a report on entry value；
If counted current time makes a report on entry value in a organized way, enter the statistics currently making a report on other cycles of item；Until
After the completion of the value making a report on item in the other times cycle of all minimal level tissues all counts, finally count all parent organization
The other times cycle make a report on entry value.
3. reporting system according to claim 2, also includes：Form automatically updates unit, with described certified sheets data
Storehouse couples, and is suitable to：Travel through registered form, read form Cron expression formula, judge whether to meet Cron expression formula；If no
Meet Cron expression formula, continue to travel through registered form；
If meeting Cron expression formula, according to current time and report name, reporting period, judge whether accounting logging；
If there is current accounting logging, continue to travel through registered form；
If there is no current accounting logging, read form configuration file, and save as specifying report name and report time
Accounting logging, read the data set of form and the configuration information of report form template, execute data set SQL statement, and by data set
Result is written to current accounting logging according to the configuration information of report form template, finally closes current report file.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310587182.2A CN103606045B (en) | 2013-11-20 | 2013-11-20 | Report form generation method and report form system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310587182.2A CN103606045B (en) | 2013-11-20 | 2013-11-20 | Report form generation method and report form system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103606045A CN103606045A (en) | 2014-02-26 |
| CN103606045B true CN103606045B (en) | 2017-02-08 |
Family
ID=50124265
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310587182.2A Active CN103606045B (en) | 2013-11-20 | 2013-11-20 | Report form generation method and report form system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103606045B (en) |
Families Citing this family (26)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104978333A (en) * | 2014-04-08 | 2015-10-14 | 无锡兰霖网络科技有限公司 | Automatic matching method based on Excel statistical form and web technology |
| CN103955497B (en) * | 2014-04-21 | 2017-06-16 | 常州市珠峰网络科技有限公司 | The Data Collection method of summary of self-defined form |
| CN105320690B (en) * | 2014-07-30 | 2018-09-25 | 北京中海纪元数字技术发展股份有限公司 | A kind of statistics list rapid generation and system based on metadata |
| CN105279143A (en) * | 2015-10-17 | 2016-01-27 | 浙江宇视科技有限公司 | Periodic report system |
| CN106682034A (en) * | 2015-11-11 | 2017-05-17 | 北京国双科技有限公司 | Report generation method and device |
| CN106934708B (en) * | 2015-12-30 | 2020-08-18 | 腾讯科技（深圳）有限公司 | Event recording method and device |
| CN105678523A (en) * | 2016-02-17 | 2016-06-15 | 绵阳佳联印染有限责任公司 | TPM information management system proposal method |
| CN106570176A (en) * | 2016-11-10 | 2017-04-19 | 华能澜沧江新能源有限公司 | Power generation enterprise electric quantity statistic reporting method and electric quantity management system |
| CN106651172A (en) * | 2016-12-19 | 2017-05-10 | 四川长虹电器股份有限公司 | Mobile report release and management method |
| CN108446882B (en) * | 2017-02-16 | 2020-10-02 | 平安科技（深圳）有限公司 | Insurance policy processing method and device |
| CN106982251B (en) * | 2017-03-10 | 2018-11-27 | 中国地质大学（武汉） | It is mobile device-based to reconnoitre project field work data reporting method and system |
| CN107357774A (en) * | 2017-07-24 | 2017-11-17 | 郑州云海信息技术有限公司 | A kind of report form generation method and reporting system |
| CN107733880A (en) * | 2017-09-30 | 2018-02-23 | 海南电网有限责任公司定安供电局 | Scheduling disciplines management information system |
| CN107679210A (en) * | 2017-10-17 | 2018-02-09 | 山东浪潮通软信息科技有限公司 | A kind of report data exchange method, apparatus and system |
| CN110019136A (en) * | 2017-12-28 | 2019-07-16 | 中国移动通信集团内蒙古有限公司 | Report generating system and report form generation method |
| CN109446494B (en) * | 2018-10-19 | 2024-03-15 | 国电南瑞科技股份有限公司 | Water affair calculation method based on report engine |
| CN109784833A (en) * | 2018-12-14 | 2019-05-21 | 深圳壹账通智能科技有限公司 | A kind of generation method and equipment of income statement |
| CN110532533B (en) * | 2019-07-10 | 2024-05-07 | 平安科技（深圳）有限公司 | Form precision collocation method, device, computer equipment and storage medium |
| CN110490181B (en) * | 2019-08-14 | 2022-04-22 | 北京思图场景数据科技服务有限公司 | Form filling and auditing method, device and equipment based on OCR (optical character recognition) technology and computer storage medium |
| CN111125385A (en) * | 2019-12-06 | 2020-05-08 | 智慧神州(北京)科技有限公司 | Method and device for generating analysis report, storage medium and processor |
| CN111797178A (en) * | 2020-07-06 | 2020-10-20 | 国网安徽省电力有限公司 | Data acquisition and processing method based on report tool |
| CN112037083B (en) * | 2020-07-15 | 2024-02-23 | 国能信控互联技术有限公司 | Power plant production data reporting system |
| CN112270495B (en) * | 2020-11-13 | 2023-05-02 | 中盈优创资讯科技有限公司 | Charging circuit flow acquisition guarantee and auditing method and device |
| CN113220754A (en) * | 2021-05-21 | 2021-08-06 | 中国农业银行股份有限公司 | Method, device, equipment, storage medium and program product for processing report data |
| CN113360152B (en) * | 2021-06-11 | 2023-11-03 | 软子数字软件(广州)有限公司 | Method and system for realizing parameterized data query webpage display program |
| CN117454862A (en) * | 2023-12-25 | 2024-01-26 | 青岛民航凯亚系统集成有限公司 | Report generation method based on engine mode and self-service BI system |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101719119A (en) * | 2009-11-18 | 2010-06-02 | 上海众恒信息产业有限公司 | Report management system and method |
| CN101754260A (en) * | 2010-01-04 | 2010-06-23 | 浪潮通信信息系统有限公司 | Multi-dimension statistical method of testing objects in communication performance network management system |
| CN101984448A (en) * | 2010-12-24 | 2011-03-09 | 中山大学孙逸仙纪念医院 | Electronic medical record database system |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7912809B2 (en) * | 2007-12-30 | 2011-03-22 | Gregory Shteyngarts | Data management system for manufacturing enterprise and related methods |
-
2013
- 2013-11-20 CN CN201310587182.2A patent/CN103606045B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101719119A (en) * | 2009-11-18 | 2010-06-02 | 上海众恒信息产业有限公司 | Report management system and method |
| CN101754260A (en) * | 2010-01-04 | 2010-06-23 | 浪潮通信信息系统有限公司 | Multi-dimension statistical method of testing objects in communication performance network management system |
| CN101984448A (en) * | 2010-12-24 | 2011-03-09 | 中山大学孙逸仙纪念医院 | Electronic medical record database system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103606045A (en) | 2014-02-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103606045B (en) | Report form generation method and report form system | |
| CN101226573B (en) | Method for controlling access authority of electric document | |
| CN100375971C (en) | System and method for hierarchical layout specialization | |
| CN108388996A (en) | A kind of scientific research service integration management system | |
| CN102436473B (en) | Menu management device and menu managing method | |
| CN108416571A (en) | A kind of application method of scientific research service integration management system | |
| CN112732811A (en) | Data open platform | |
| CN103092631B (en) | A kind of data base application system development platform and development approach | |
| CN110443010A (en) | One kind permission visual configuration control method, device, terminal and storage medium in information system | |
| CN110457891A (en) | A kind of authority configuration interface display method, device, terminal and storage medium | |
| US20060185019A1 (en) | Method and system for observational data collection | |
| CN104392308A (en) | Fishing village informationalized service platform | |
| CN109542967A (en) | Smart city data-sharing systems and method based on XBRL standard | |
| CN102938096B (en) | A kind of implementation method of the power plant registration information declaration system of dynamic configuration | |
| CN106294753A (en) | A kind of system being applicable to government websites group | |
| CN108053127A (en) | A kind of electronic file management system | |
| CN108229921A (en) | National tax land tax combines data collecting system and its operating method | |
| CN103136619A (en) | On-line management method for engineering quality acceptance report form | |
| CN107679708A (en) | A kind of management of housing fund cloud platform system | |
| CN112506892A (en) | Index traceability management system based on metadata technology | |
| CN111143444A (en) | API-based data exchange platform | |
| CN110728567B (en) | Electronic invoice reimbursement management system and method | |
| CN110289087A (en) | The Medical Devices consumable smart media management system of modern hospital | |
| CN109858867A (en) | A kind of Electronic Packaging Technical innova- tion system | |
| CN106600326A (en) | Airport toll administration method and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |