CN105843821B - A kind of data processing method and system of configurable report - Google Patents
A kind of data processing method and system of configurable report Download PDFInfo
- Publication number
- CN105843821B CN105843821B CN201510023315.2A CN201510023315A CN105843821B CN 105843821 B CN105843821 B CN 105843821B CN 201510023315 A CN201510023315 A CN 201510023315A CN 105843821 B CN105843821 B CN 105843821B
- Authority
- CN
- China
- Prior art keywords
- report
- configurable
- data
- index
- page
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides the data processing method and system of a kind of configurable report, and the data processing method of the configurable report is the following steps are included: creation reports model, the reports model is using the page of data filled with the source data to be showed as data source；Index is converted by the calculating of the service logic of the reports model, carries out configurationization management；The dimension that shows of report template is converted, the page that user can configure is formed, carries out report form showing.The present invention realizes that user flexibly modifies the calculating logic of index according to the service logic of oneself and report shows dimension, improves the reusability of code, saves the development time of developer.
Description
Technical field
The present invention relates to the technical field in report form processing field, in particular to a kind of data processing method of configurable report
And system.
Background technique
It needs to input in WEB application system and handles a large amount of data, and the report of processing result in a variety of manners is defeated
Out, so that managers preferably carry out analysis and decision.It is influenced by factors such as economy and society environment, WEB system business
Process can be adjusted accordingly or be changed, and the data and format of involved report also need to adjust accordingly.Therefore, WEB application system
Unite there is an urgent need to it is a can mount existing database system, support dynamic data source, with powerful data-handling capacity and
Expressive ability, can used in users, low cost report form showing and make a report on tool.
In the realization of Information-based Item, many systems are tended to buy life of the business report generation system to realize report
At, for example Crystal Report, Formula One, Cognos etc., the development process of these softwares are all centered on pattern
It carries out, report data and the report style degree of coupling are excessively high, are there is the situation that a large amount of report styles are lack of standardization and pattern is various
Under, it is unfavorable for modification maintenance and reusability is poor, wastes man power and material significantly.
Although domestic report software market has already appeared a few money business report softwares, such as FineReport and the dry public affairs of profit
The RAQ of department solves the problems, such as that user does not have to programming and can produce Chinese style complex report forms, both supports multi-data source, also prop up
The association for holding multi-data source has won favorable comment in report software market.But they all use Java Swing technological development, tool
There are natural deployment, scaling difficulty, and is to need the commercial product bought of paying, higher operating costs.
Currently, when encountering the requirement for needing to carry out data exhibiting, needing the rule according to service logic from technical rootstocks
Surely pass through various calculating (obtaining index value), then various dimensions as required are shown.General processing method be by
Corresponding template progress report displaying is developed respectively according to the logic of different calculation and different dimensions.For example, middle promulgated by the State Council
A kind of report form statistics method and device based on various dimensions is disclosed in bright patent CN103679320, this method is by statistically
Grade work organization matching or membership carry out time and organization dimensionality matching to obtain business datum, matching are obtained
Data are summarized and are shown.Wherein, this method needs carry out code development to every kind of calculation and various dimensions respectively, i.e.,
The increase of every kind of index or the increase for showing dimension will carry out the exploitation of code, this can undoubtedly become the daily of platform maintenance
Work, takes a substantial amount of time and energy.
Summary of the invention
To overcome existing defect, the embodiment of the present invention proposes the data processing method and system of a kind of configurable report,
It can realize that user flexibly modifies the calculating logic of index according to oneself service logic and report shows dimension, mention
The high reusability of code, saves the development time of developer.
According to an aspect of an embodiment of the present invention, a kind of data processing method of configurable report is proposed, comprising: wound
Reports model is built, the reports model is to fill the page of data that need to show source data as data source；By the reports model
The calculating of service logic be converted into index, carry out configurationization management；The dimension that shows of report template is converted, is formed and is used
The configurable page in family, carries out report form showing.
According to another aspect of an embodiment of the present invention, a kind of data processing system of configurable report is proposed comprising:
Reports model creating unit, for creating reports model, the reports model is to be filled with the source data to be showed
Page of data be data source；
Index conversion configuration unit is matched for converting index for the calculating of the service logic of the reports model
Setting management；
Dimension converts configuration unit, converts for the dimension that shows to report template, forms the page that user can configure
Face；
Display unit, for according to the index of configuration and showing dimension and carrying out report form showing.
After the data processing method and system of the configurable report of the embodiment of the present invention are converted by the calculating to service logic,
Visualized management is carried out to the index and dimension to be showed by configuring, the reusability of code is improved, saves exploit person
The development time of member.User can flexibly modify the calculating logic of index and the exhibition of report according to the service logic of oneself
Existing dimension develops waiting without the demand dependent on developer.
Detailed description of the invention
Fig. 1 is the flow diagram of the data processing method preferred embodiment of the configurable report of the present invention；
Fig. 2 is the structural schematic diagram of the data processing system of the configurable report of the present invention.
In order to clearly realize the structure of the embodiment of the present invention, certain size, structure and device are labelled in figure,
But signal needs are only for, are not intended to limit the invention in the specific dimensions, structure, device and environment, according to specific
Need, these devices and environment can be adjusted or be modified by those skilled in the art, the adjustment that is carried out or
Person's modification still includes in the range of appended claims.
Specific embodiment
In the following with reference to the drawings and specific embodiments the data processing method to a kind of configurable report provided by the invention and
System is described in detail.
In the following description, multiple and different aspects of the invention will be described, however, for common skill in the art
For art personnel, the present invention can be implemented just with some or all structures or process of the invention.In order to explain
Definition for, specific number, configuration and sequence are elaborated, however, it will be apparent that these specific details the case where
Under the present invention also can be implemented.It in other cases, will no longer for some well-known features in order not to obscure the present invention
It is described in detail.
The present invention provides a kind of data processing methods of configurable report comprising following steps: creation reports model,
The reports model is to fill the page of data that need to show source data as data source；By the service logic of the reports model
Calculating is converted into index, carries out configurationization management；The dimension that shows of report template is converted, the page that user can configure is formed
Face carries out report form showing.
In this way, after the present invention is converted by calculating to service logic, by configure to the index and dimension to be showed into
Row visualized management improves the reusability of code, saves the development time of developer.
Referring to Fig. 1, Fig. 1 is the flow diagram of the data processing method preferred embodiment of the configurable report of the present invention.
The data processing method of the configurable report specifically includes the following steps:
Step S101: the data type of certified sheets；
In specific implementation, can certified sheets according to the needs of practical application data type, this step further includes definition
Source data, i.e., the data source of specified reports model may specify acquisition data object in the present embodiment, and it is specified return field with
And return to the data type etc. of field.
Step S102: the uniform data table for generating page of data is created；
In the embodiment of the present invention, the uniform data table is for generating page of data, and page of data is for showing source number
It is according to the data for executing specified return field acquired in specified acquisition data object, i.e., original needed for reports model for showing
Data.
Uniform data table described in this step is used to provide finding i.e. institute for creation reports model or self-defined report template
The source data obtained, i.e., so that developer is when creating reports model or end user is in self-defined report template, Neng Gougen
According to content shown by page of data, determine which data for needing that page of data is used in reports model, and how
The data in the page of data are used in reports model.Developer and end user's ratio can be used in the uniform data table
The mode being readily understood by is named.
Step S103: the page of data is filled into according to the source data that the uniform data table will show；
In specific implementation, the variable for first parsing the uniform data table determines taking for variable further according to the source data
Value, and the value of the determination is filled into corresponding field in the page of data.
Step S104: creation reports model, the reports model is using the page of data as data source；
In specific implementation, the file comprising page of data has been obtained by above-mentioned steps, this step is in this document
In can at least create a reports model, and service logic is created in the reports model, such as project name, version etc.；
When creating service logic, using the page of data as data source.
Step S105: being converted to configurable atom for the calculating of the service logic in the reports model, generates calculating and refers to
Mark, calculates index value according to Index Logic；
In specific implementation, the calculating of the service logic by the reports model is converted to the step of configurable atom
Suddenly it specifically includes:
Service logic is converted to query sentence of database；
The query sentence of database is converted to form configurable atom.
It should be noted that being converted to corresponding query sentence of database according to specific service logic in this step, later
Query statement is divided to obtain configurable atom (atom that can be configured) according to configuration rule, then in configuration page
Face is configured.
The configurable atom includes visualized data, to carry out visualized management to the index and dimension to be showed.
In addition, further including providing this not converting for the service logic that cannot be converted in the reports model, in this step
Pair service logic api interface (Application Programming Interface, application programming interface), with
It enables a user to voluntarily call the service logic by platform, achievees the purpose that free configuration service logic.
Step S106: the index of the reports model is configured according to the configurable atom and shows dimension；
In specific implementation, after conversion obtains configurable atom, developer or end user can be to the report moulds
The index calculation of version, the dimension showed and/or querying condition are configured, wherein querying condition is non-essential configuration
Condition is determined according to specific service logic；Judge whether report has setting querying condition by background logic, such as
It is then to carry out the assembling of querying condition, if otherwise skipping over this step, if configuration querying condition is patrolled according to specific business
It collects to determine.
Step S107: it is calculated according to the reports model and generates report, the report is according to the index and shows dimension
Showed.
In specific implementation, developer or end user can set index in the reports model as needed and calculate
Mode and show dimension, according to the index calculation of the setting and shows dimension from the background and calculate and generate report, i.e., the described report
The index value of table is calculated according to the index calculation of setting, and the report is showed according to the dimension that shows of setting
Report data.
Illustrate the technical solution of the embodiment of the present invention below by a specific embodiment, it is in this example, described to match
Set report show the following steps are included:
Step 1: the data type of source data and certified sheets is defined, it is assumed that the data of specified field name and field
Type is as shown in table 1:
| Field name | Field type |
| Project | String |
| Version | Integer |
| Department | String |
| Original point | Integer |
| Grey positive or negative points small for the first time | Integer |
| Collaborate positive or negative points | Integer |
Table 1
Step 2: creating the uniform data table for generating page of data, and will be showed according to the uniform data table
Source data is filled into the page of data；
Assuming that above-mentioned report needs version of display, department and original point, the source number that reporting system will will will show automatically
According to the page of data is filled into, as shown in table 2:
Table 2
Step 3: the service logic in the reports model is converted to configurable atom by creation reports model；
In the reports model, such as the entitled marking statistics of reports model, wherein grey positive or negative points small for the first time close
Stream positive or negative points etc. need to carry out logical operation to source data to obtain, as the service logic, and this step transports the logic
Calculation is converted to the configurable atom for being available for voluntarily option and installment, and the configurable atom after converting can be small ash for the first time
Positive or negative points, interflow positive or negative points, original point etc., service logic field here is voluntarily to configure, and backstage carries out query statement assembling
When can be converted to corresponding Database field.Furthermore it is also possible to be configured querying condition for user, querying condition here is
It allows user to fill in or select when generating report, specific variable in index can be replaced, for example to select some version
There are the marking data at interflow in this certain time, as shown in table 3:
| Template title: | Marking statistics | ||
| Show index: | Mouth grey positive or negative points small for the first time | Mouth interflow positive or negative points | Original point of mouth |
| Show dimension: | Project | ||
| Version | |||
| Querying condition: | Project | ||
| Collaborate the time |
Table 3
Step 4: configuring the index of the reports model according to the configurable atom and shows dimension and calculates generation report
Table, the report is according to the index and shows dimension and is showed.
In the present embodiment, user obtains the reports model index to be showed after selecting configurable atom, for example,
User selects to show index as original point, grey positive or negative points small for the first time, bug score and interflow positive or negative points in the present embodiment, wherein
Project and version are to show dimension, and querying condition is project: xxx；The interflow time is 2014/9/1--2014/9/30,
The report that it is generated is as shown in table 4:
Table 4
Referring to Fig. 2, the present invention also provides a kind of data processing systems of configurable report comprising:
Reports model creating unit 10, for creating reports model, the reports model is to be filled with the source number to be showed
According to page of data be data source；
Index converts configuration unit 20, for converting index for the calculating of service logic, carries out configurationization management；
Dimension converts configuration unit 30, converts for the dimension that shows to report template, forms what user can configure
The page；
Display unit 40, for according to the index of configuration and showing dimension and carrying out report form showing.
Wherein, the index conversion configuration unit 20 further comprises:
Index transforming subunit 201, for the calculating of the service logic to be converted to configurable atom；
Index value computation subunit 202 calculates index value for generating parameter, and according to Index Logic；
Index allocation subelement 203, for the index according to the configurable atom configuration reports model.
The index transforming subunit 201 specifically includes:
First transforming subunit 2011, for service logic in the reports model to be converted to query sentence of database；
And
Second transforming subunit 2012, for converting the query sentence of database to form configurable atom.
It is described to show system further include:
Querying condition configuration unit 50, for the querying condition according to the configurable atom configuration reports model.
Compared with the prior art, the present invention can configure the data processing method of report and system passes through the meter to service logic
After calculating conversion, visualized management is carried out to the index and dimension to be showed by configuring, improves the reusability of code, is saved
Development time of developer.User can flexibly modify the calculating logic of index according to the service logic of oneself, and
Report shows dimension, develops waiting without the demand dependent on developer.
Finally it should be noted that above embodiments are only to describe technical solution of the present invention rather than to this technology method
It is limited, the present invention can above extend to other modifications, variation, application and embodiment, and therefore, it is considered that institute in application
There are such modification, variation, application, embodiment all within the scope of spirit or teaching of the invention.
Claims (9)
1. a kind of data processing method of configurable report, comprising:
Reports model is created, the reports model is to fill the page of data that need to show source data as data source；
The service logic of the report template is converted to query sentence of database；
The query sentence of database is converted to form configurable atom, and according to the configurable atom configuration reports model
Index carries out configurationization management；
The dimension that shows of report template is converted, the page that user can configure is formed, carries out report form showing.
2. the data processing method of configurable report according to claim 1, which is characterized in that described by the data
Library inquiry sentence converts to be formed after configurable atom, the method further includes:
Parameter is generated, calculates index value according to Index Logic.
3. the data processing method of configurable report according to claim 1, which is characterized in that described to report template
The step of showing dimension to be converted, forming the page that can configure of user, carry out report form showing include:
The index for showing dimension and being showed for configuring the report template is configured；
It is calculated to generate according to the reports model of configuration and shows report, it is described to show report according to the index and described show
Dimension is showed.
4. the data processing method of configurable report according to claim 1, which is characterized in that described by the report mould
The service logic of plate is converted to query sentence of database:
The api interface for being applied to the service logic that can not be converted is provided.
5. the data processing method of configurable report according to claim 1, which is characterized in that described to report template
The step of showing dimension to be converted, forming the page that user can configure, carry out report form showing further include:
According to the querying condition of the configurable atom configuration reports model.
6. the data processing method of configurable report according to claim 1, which is characterized in that the creation reports model
The step of before further include:
The data type of certified sheets；
The uniform data table for generating page of data is created, is filled into according to the source data that the uniform data table will show
The page of data.
7. a kind of data processing system of configurable report, characterized in that it comprises:
Reports model creating unit, for creating reports model, the reports model is with the number filled with the source data to be showed
It is data source according to the page；
Index converts configuration unit, including index transforming subunit, for the service logic of the report template to be converted to number
It converts to form configurable atom according to library inquiry sentence, and by the query sentence of database；
The index converts configuration unit, further includes index allocation subelement, for configuring report according to the configurable atom
The index of template carries out configurationization management；
Dimension converts configuration unit, converts for the dimension that shows to report template, forms the page that user can configure；
Display unit, for according to the index of configuration and showing dimension and carrying out report form showing.
8. the data processing system of configurable report according to claim 7, which is characterized in that the index conversion configuration
Unit further comprises:
Index value computation subunit calculates index value for generating parameter, and according to Index Logic.
9. the data processing system of configurable report according to claim 7, which is characterized in that the system that shows also is wrapped
It includes:
Querying condition configuration unit, for the querying condition according to the configurable atom configuration reports model.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510023315.2A CN105843821B (en) | 2015-01-16 | 2015-01-16 | A kind of data processing method and system of configurable report |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510023315.2A CN105843821B (en) | 2015-01-16 | 2015-01-16 | A kind of data processing method and system of configurable report |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105843821A CN105843821A (en) | 2016-08-10 |
| CN105843821B true CN105843821B (en) | 2019-09-06 |
Family
ID=56580831
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510023315.2A Active CN105843821B (en) | 2015-01-16 | 2015-01-16 | A kind of data processing method and system of configurable report |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105843821B (en) |
Families Citing this family (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108132951B (en) * | 2016-12-01 | 2021-09-24 | 腾讯科技（深圳）有限公司 | Data access method and data access device |
| CN108228548B (en) * | 2016-12-21 | 2019-08-13 | 腾讯科技（深圳）有限公司 | A kind of report display method, apparatus, terminal and system |
| CN108255533B (en) * | 2016-12-28 | 2021-12-17 | 平安科技（深圳）有限公司 | System configuration changing method and device |
| CN107861926A (en) * | 2016-12-28 | 2018-03-30 | 平安科技（深圳）有限公司 | Document template configuration method and device |
| CN108984567B (en) * | 2017-06-02 | 2021-04-09 | 华为技术有限公司 | Service data management system and method |
| CN108074033A (en) * | 2017-10-30 | 2018-05-25 | 链家网（北京）科技有限公司 | Processing method, system, electronic equipment and the storage medium of achievement data |
| CN107967137A (en) * | 2017-12-08 | 2018-04-27 | 浪潮软件集团有限公司 | Data management method and device |
| CN110399410A (en) * | 2018-04-16 | 2019-11-01 | 北京嘀嘀无限科技发展有限公司 | Data processing method, device, equipment and computer readable storage medium |
| CN109117467A (en) * | 2018-07-27 | 2019-01-01 | 广东讯飞启明科技发展有限公司 | Generation method, system, equipment and the medium of configurable dynamic data report |
| CN109255065A (en) * | 2018-09-18 | 2019-01-22 | 郑州云海信息技术有限公司 | A kind of method and reporting system of report form processing |
| CN110413614A (en) * | 2019-07-09 | 2019-11-05 | 北京三快在线科技有限公司 | A kind of method and device that tables of data generates |
| CN110941654A (en) * | 2019-11-25 | 2020-03-31 | 杭州晨鹰军泰科技有限公司 | Data query display system, method, device and medium based on configuration template |
| CN112256744A (en) * | 2020-10-27 | 2021-01-22 | 武汉市钱鲸科技有限公司 | Retail data statistics flow |
| CN112580319A (en) * | 2020-12-14 | 2021-03-30 | 京东数字科技控股股份有限公司 | Data processing method, device, equipment and computer readable storage medium |
| CN112256731A (en) * | 2020-12-21 | 2021-01-22 | 长沙树根互联技术有限公司 | Data display method and device and electronic equipment |
| CN112949269A (en) * | 2021-04-06 | 2021-06-11 | 携程旅游信息技术（上海）有限公司 | Method, system, equipment and storage medium for generating visual data analysis report |
| CN113642301A (en) * | 2021-08-09 | 2021-11-12 | 京东科技控股股份有限公司 | Report generation method, device and system |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102117296A (en) * | 2009-12-31 | 2011-07-06 | 青岛海尔软件有限公司 | Method for generating dynamic configuration report |
| CN102663209A (en) * | 2012-04-28 | 2012-09-12 | 楚天科技股份有限公司 | Application of configurable statement on rubber plug or aluminium cap cleaning device |
| CN103984557A (en) * | 2014-05-29 | 2014-08-13 | 中国银行股份有限公司 | Report generation method and device |
| CN104200402A (en) * | 2014-09-11 | 2014-12-10 | 国家电网公司 | Publishing method and system of source data of multiple data sources in power grid |
-
2015
- 2015-01-16 CN CN201510023315.2A patent/CN105843821B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102117296A (en) * | 2009-12-31 | 2011-07-06 | 青岛海尔软件有限公司 | Method for generating dynamic configuration report |
| CN102663209A (en) * | 2012-04-28 | 2012-09-12 | 楚天科技股份有限公司 | Application of configurable statement on rubber plug or aluminium cap cleaning device |
| CN103984557A (en) * | 2014-05-29 | 2014-08-13 | 中国银行股份有限公司 | Report generation method and device |
| CN104200402A (en) * | 2014-09-11 | 2014-12-10 | 国家电网公司 | Publishing method and system of source data of multiple data sources in power grid |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105843821A (en) | 2016-08-10 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105843821B (en) | A kind of data processing method and system of configurable report | |
| US7548542B2 (en) | Methods and apparatus for transferring data | |
| CN102810057B (en) | A kind of method of log | |
| CN101388904B (en) | GIS service aggregating method, device and system | |
| CN103092890A (en) | System and method for automatic generation and sending of reports | |
| JP2006155591A (en) | Business modelling with efficiency and flexibility based on structured business capability | |
| CN106250164A (en) | A kind of code generating method based on requirement documents and device | |
| CN105637478A (en) | Computer-aided development of native mobile application code | |
| CN103473108A (en) | Java code generating method | |
| CN101714078A (en) | Code generation method and device | |
| CN103927385A (en) | Unifying method and device of data model | |
| US20110179397A1 (en) | Systems and methods for metamodel transformation | |
| CN109976803A (en) | A kind of generation method and device of file | |
| CN108446262A (en) | A kind of list generates, analysis method and device | |
| CN114707474A (en) | Report generation method and device, electronic equipment and computer readable storage medium | |
| CN114840531B (en) | Data model reconstruction method, device, equipment and medium based on blood edge relation | |
| CN105786925A (en) | Reference model based dynamic data modeling method and apparatus | |
| CN104166546A (en) | Implementation method and system used for data distribution service (DDS) application software and based on model driven architecture (MDA) | |
| CN112214602B (en) | Humor-based text classification method and device, electronic equipment and storage medium | |
| CN103927168A (en) | Object-oriented data model persistence method and device | |
| CN103699746B (en) | CADDS5 piping three-dimensional design method based on data base and system | |
| CN103092982A (en) | Information service system based on multiple-view business model | |
| CN101576969A (en) | Hierarchy analysis method for service granularity partition of SOA-based system | |
| CN105373385A (en) | Multi-resolution UI (User Interface) adaption scripting development method of Android application | |
| CN103279901A (en) | Method and device for converting CIM (Common Information Model) into logic model |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20211227 Address after: 650034 19F, Kungang science and technology building, No. 777, Huancheng South Road, Xishan District, Kunming City, Yunnan Province Patentee after: Yunnan Tengyun Information Industry Co.,Ltd. Address before: 2, 518000, East 403 room, SEG science and Technology Park, Zhenxing Road, Shenzhen, Guangdong, Futian District Patentee before: TENCENT TECHNOLOGY (SHENZHEN) Co.,Ltd. |
|
| TR01 | Transfer of patent right |