WO2018161402A1 - Procédé et système de traitement de rapports groupés modulaires - Google Patents

Procédé et système de traitement de rapports groupés modulaires Download PDF

Info

Publication number
WO2018161402A1
WO2018161402A1 PCT/CN2017/080125 CN2017080125W WO2018161402A1 WO 2018161402 A1 WO2018161402 A1 WO 2018161402A1 CN 2017080125 W CN2017080125 W CN 2017080125W WO 2018161402 A1 WO2018161402 A1 WO 2018161402A1
Authority
WO
WIPO (PCT)
Prior art keywords
report
information
database
data
format
Prior art date
Application number
PCT/CN2017/080125
Other languages
English (en)
Chinese (zh)
Inventor
黄驰
熊娅娟
袁也
刘新奇
曾昭志
Original Assignee
深圳市科脉技术股份有限公司
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by 深圳市科脉技术股份有限公司 filed Critical 深圳市科脉技术股份有限公司
Publication of WO2018161402A1 publication Critical patent/WO2018161402A1/fr

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/245—Query processing
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22—Indexing; Data structures therefor; Storage structures
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/248—Presentation of query results

Definitions

  • the present invention relates to the field of report technology, and in particular, to a method and system for processing a modular package report.
  • Each report has a section of the query for filling in the query criteria and a table section for loading the data. Between different reports, the entries in the query part are not the same as the format, and the entries in the table part are not the same as the format (such as the width of the cell). Therefore, each report needs to be pre-designed with a separate template. In the system, a separate template file needs to be generated, which is not conducive to the introduction of a new reporting system for different systems. It is also difficult to develop and upgrade.
  • the object of the present invention is to provide a processing method and system for a modular package report. For a developer, it is no longer necessary to design a separate report file, and only one display page is needed to display the report, so that it is convenient to add a new report. Make it easy to introduce different systems into the reporting system, and at the same time facilitate the development and upgrade of the reporting system.
  • an embodiment of the present invention provides a method for processing a modular package report, where the method includes the following steps:
  • the database has a corresponding report identifier ID (Identity, identifier);
  • the embodiment of the present invention provides a first possible implementation manner of the first aspect, wherein the method further includes the following steps:
  • first operation instruction information of the user where the first operation instruction information includes switching information
  • the embodiment of the present invention provides a second possible implementation manner of the first aspect, wherein the method further includes the following steps:
  • the embodiment of the present invention provides a third possible implementation manner of the first aspect, wherein the method further includes the following steps:
  • Modifying format information of the report according to the modification information and saving the modified format information in the database.
  • the embodiment of the present invention provides the fourth possible implementation manner of the first aspect, wherein the format information includes query information and form information,
  • the query information includes a query entry and a query format, the form information including a form entry and Form format.
  • the embodiment of the present invention further provides a processing system for a modular package report, including:
  • the saving unit is configured to obtain format information and data storage information of the report, and save the data in the database, where the report has a corresponding report identifier ID in the database;
  • the first searching unit is configured to search, according to the report ID corresponding to the report, the format information and the data storage information of the report corresponding to the report ID from the database;
  • the processing unit is configured to query the report data according to the data storage information, and process the report data to obtain a data processing result;
  • a loading unit configured to load format information of the report and the data processing result into a display page.
  • the embodiment of the present invention provides the first possible implementation manner of the second aspect, further including:
  • a first acquiring unit configured to acquire first operation instruction information of the user, where the first operation instruction information includes switching information
  • the identification unit is configured to identify the report ID according to the switching information
  • a second searching unit configured to look up the report from the database according to the report ID.
  • the embodiment of the present invention provides a second possible implementation manner of the second aspect, further including:
  • a second acquiring unit configured to acquire second operation instruction information of the user, where the second operation instruction information includes adding information
  • Adding a unit configured to add a new report based on the added information and save in the database.
  • the embodiment of the present invention provides a third possible implementation manner of the second aspect, Among them, it also includes:
  • a third acquiring unit configured to acquire third operation instruction information of the user, where the third operation instruction information includes modification information
  • a modifying unit configured to modify the format information of the report according to the modification information, and save the modified format information in the database.
  • the embodiment of the present invention provides the fourth possible implementation manner of the second aspect, wherein the format information includes query information and form information,
  • the query information includes a query entry and a query format, the form information including a form entry and a table format.
  • the invention provides a processing method and system for a modular package report, the method comprising: obtaining format information and data storage information of a report, and storing the information in a database, wherein the report has a corresponding report identifier ID in the database;
  • the report ID searches the database for the format information and data storage information of the report corresponding to the report ID; queries the report data according to the data storage information, and processes the report data to obtain the data processing result; and loads the format information and the data processing result of the report. Go to the display page.
  • FIG. 1 is a flowchart of a method for processing a modular package report according to Embodiment 1 of the present invention
  • FIG. 2 is another flowchart of a method for processing a modular package report according to Embodiment 1 of the present invention
  • FIG. 3 is a schematic structural diagram of a processing system of a modular package report according to Embodiment 2 of the present invention.
  • FIG. 4 is another schematic structural diagram of a processing system for a modular package report according to Embodiment 2 of the present invention.
  • 10-save unit 20-first search unit; 30-processing unit; 40-load unit; 50-first acquisition unit; 60-identification unit; 70-second search unit.
  • Each report has a section of the query for filling in the query criteria and a table section for loading the data.
  • the entries in the query part are not the same as the format, and the entries in the table part are not the same as the format (such as the width of the cell). Therefore, each report needs to be pre-designed with a separate template.
  • a separate template file needs to be generated, which is not conducive to the introduction of a new reporting system for different systems. It is also difficult to develop and upgrade.
  • the present invention provides a processing party for modular package reports. Law and system, for developers, no longer need to design a separate report file, only need a display page to display the report, easy to add new reports, can make different systems easy to introduce the report system, at the same time, facilitate the development of the report system And upgrades.
  • the modular package report of the embodiment of the invention is modularly packaged for the basic class library of the report, and all the data operation information related to the report is encapsulated in the module, and the data operation information includes reading data, processing data, displaying data, and the like. It is easy to introduce new reporting systems for different systems.
  • Embodiment 1 is a diagrammatic representation of Embodiment 1:
  • FIG. 1 is a flowchart of a method for processing a modular package report according to Embodiment 1 of the present invention.
  • the processing method of the modular package report includes:
  • Step S101 Obtain format information and data storage information of the report, and save the data in the database, where the report has a corresponding report identifier ID in the database;
  • the report includes a query part and a form part
  • the format information of the report includes query information and form information
  • the query information includes a query item and a query format
  • the form information includes a form entry and a table format.
  • the query part of the report can be set by the user, and any one of the query results can be used as a query condition to satisfy the user's differentiation of the analysis dimension of the report.
  • the data storage information is a storage process of the report data, and the report data can be queried according to the data storage information.
  • the format information and the data storage information of the report are stored in the database according to a predetermined rule, and are in one-to-one correspondence with the report ID.
  • Step S102 Searching, according to the report ID corresponding to the report, the format information and the data storage information of the report corresponding to the report ID from the database;
  • Step S103 querying report data according to the data storage information, and processing the report data to obtain a data processing result
  • the queried report data is loaded into the server where the package file is located for data processing, and the report data is automatically processed according to the encapsulated data operation function, and the processed data result is obtained.
  • step S104 the format information and the data processing result of the report are loaded into the display page.
  • the display page may be a main page, such as AutoQuery.aspx, or other pages, such as an application interface.
  • all reports can be displayed through the same body page (such as AutoQuery.aspx), which inherits from data processing classes, such as the AutoQueryPage class, and the AutoQueryPage class is encapsulated in a separate pure class library project that can be compiled.
  • a separate dynamic link library file that is, the package file, all query information, table information and data storage process of the report are stored in the database, and the library mainly processes the assembly work of the information. If the report system is referenced in a new project, simply reference the dynamic link library file, and then add the main page AutoQuery.aspx or other display page, and the database fills the report related data according to the agreed specifications.
  • the method further includes:
  • Step S201 acquiring first operation instruction information of the user, where the first operation instruction information includes switching information;
  • Step S202 identifying the report ID according to the switching information
  • Step S203 searching for a report corresponding to the report ID from the database according to the report ID.
  • each report corresponds to a report ID.
  • the system first identifies the ID of the report that the user needs to switch to, and then finds the corresponding report from the database according to the ID of the report.
  • the query information and form information are loaded into the display interface.
  • the method further includes:
  • the new report is the associated report of the original report.
  • the data in the new report comes from the original report, but the statistics items and query conditions in the table are re-set to get different.
  • the report, the name of the new report, and access rights can be set by the user.
  • the method further includes:
  • Modifying format information of the report according to the modification information and saving the modified format information in the database.
  • the query information and the form information of the report may be modified.
  • the name of the item in the form information, the column width, the order in which the items are displayed, and the like may be modified, and the query condition in the query information may be modified according to the query result.
  • Any one of the query results can be used as a query condition, and the query format can also be modified.
  • the query date is XXX ⁇ XXX, or the start date is XXX, and the end date is XXX.
  • the format information includes query information and form information, the query information including a query entry and a query format, the form information including a form entry and a table format.
  • Embodiment 2 is a diagrammatic representation of Embodiment 1:
  • FIG. 3 is a schematic structural diagram of a processing system of a modular package report according to Embodiment 2 of the present invention.
  • the processing system of the modular package report includes:
  • the saving unit 10 is configured to obtain format information and data storage information of the report, and save the data in the database, where the report has a corresponding report identifier ID in the database;
  • the first searching unit 20 is configured to search, according to the report ID corresponding to the report, the format information and the data storage information of the report corresponding to the report ID from the database;
  • the processing unit 30 is configured to query the report data according to the data storage information, and process the report data according to the package information to obtain a data processing result;
  • the loading unit 40 is configured to load the format information of the report and the data processing result into the display page.
  • the system further includes:
  • the first obtaining unit 50 is configured to acquire first operation instruction information of the user, where the first operation instruction information includes switching information;
  • the identifying unit 60 is configured to identify the report ID according to the switching information
  • the second searching unit 70 is configured to search the database from the database according to the report ID.
  • the method further includes:
  • a second obtaining unit (not shown), configured to acquire second operation instruction information of the user, where the second operation instruction information includes adding information;
  • An adding unit (not shown) is provided for adding a new report based on the added information and saving in the database.
  • the method further includes:
  • a third acquiring unit (not shown), configured to acquire third operation instruction information of the user, where the third operation instruction information includes modification information;
  • a modifying unit (not shown), configured to modify the format information of the report according to the modification information, and save the modified format information in the database.
  • the format information includes query information and form information, the query information including a query entry and a query format, the form information including a form entry and a table format.
  • the processing system of the modular package report provided by the embodiment of the present invention has the same technical features as the processing method of the modular package report provided by the foregoing embodiment, so that the same technical problem can be solved and the same technical effect can be achieved.
  • the invention provides a processing method and system for a modular package report, the method comprising: obtaining format information and data storage information of a report, and storing the information in a database, wherein the report has a corresponding report identifier ID in the database;
  • the report ID searches the database for the format information and data storage information of the report corresponding to the report ID; queries the report data according to the data storage information, and processes the report data to obtain the data processing result; and loads the format information and the data processing result of the report.
  • the computer program product provided by the embodiment of the present invention includes a computer readable storage medium storing the program code, and the program code includes instructions for executing the method described in the foregoing method embodiment.
  • the program code includes instructions for executing the method described in the foregoing method embodiment.
  • the specific implementation refer to the method embodiment. , will not repeat them here.
  • the terms “installation”, “connected”, and “connected” are to be understood broadly, and may be a fixed connection or a detachable connection, unless otherwise explicitly defined and defined. , or connected integrally; may be mechanical connection or electrical connection; may be directly connected, or may be indirectly connected through an intermediate medium, and may be internal communication between the two elements.
  • installation may be a fixed connection or a detachable connection, unless otherwise explicitly defined and defined.
  • connected integrally may be mechanical connection or electrical connection; may be directly connected, or may be indirectly connected through an intermediate medium, and may be internal communication between the two elements.
  • the specific meaning of the above terms in the present invention can be understood in a specific case by those skilled in the art.
  • the functions may be stored in a computer readable storage medium if implemented in the form of a software functional unit and sold or used as a standalone product.
  • the technical solution of the present invention which is essential or contributes to the prior art, or a part of the technical solution, may be embodied in the form of a software product, which is stored in a storage medium, including
  • the instructions are used to cause a computer device (which may be a personal computer, server, or network device, etc.) to perform all or part of the steps of the methods described in various embodiments of the present invention.
  • the foregoing storage medium includes: a U disk, a mobile hard disk, a read-only memory (ROM), a random access memory (RAM), a magnetic disk, or an optical disk, and the like. .

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Software Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

L'invention concerne un procédé et un système pour le groupage et le stockage de données de rapports, et se rapporte au domaine technique du compte rendu, ledit procédé consistant : à acquérir des informations de format et des informations de stockage de données pour un rapport, à sauvegarder lesdites informations dans une base de données, le rapport ayant un identifiant (ID) correspondant dans la base de données (S101) ; à rechercher des informations de format de rapport et des informations de stockage de données correspondant à l'identifiant de rapport dans la base de données selon l'identifiant de rapport correspondant au rapport (S102) ; à interroger les données de rapport selon les informations de stockage de données et à effectuer un traitement sur les données de rapport pour obtenir un résultat de traitement de données (S103) ; à charger les informations de format de rapport et le résultat de traitement de données sur une page d'affichage (S104). Le procédé de la présente invention peut faciliter l'ajout de nouveaux rapports et est avantageux pour introduire un système de compte rendu à différents systèmes, tout en facilitant également le développement et la mise à niveau de systèmes de compte rendu.
PCT/CN2017/080125 2017-03-10 2017-04-11 Procédé et système de traitement de rapports groupés modulaires WO2018161402A1 (fr)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201710144782.XA CN106934021B (zh) 2017-03-10 2017-03-10 模块化封装报表的处理方法和***
CN201710144782.X 2017-03-10

Publications (1)

Publication Number Publication Date
WO2018161402A1 true WO2018161402A1 (fr) 2018-09-13

Family

ID=59433152

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2017/080125 WO2018161402A1 (fr) 2017-03-10 2017-04-11 Procédé et système de traitement de rapports groupés modulaires

Country Status (2)

Country Link
CN (1) CN106934021B (fr)
WO (1) WO2018161402A1 (fr)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109446507A (zh) * 2018-11-13 2019-03-08 浙江中智达科技有限公司 一种报表的构建方法及装置

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113051219A (zh) * 2019-12-26 2021-06-29 贵州白山云科技股份有限公司 一种数据库管理方法、装置、设备及存储介质

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101751436A (zh) * 2008-12-19 2010-06-23 ***通信集团山东有限公司 一种生成报表的方法及装置
CN102682126A (zh) * 2012-05-16 2012-09-19 深圳市凯立德科技股份有限公司 一种表单数据的存取方法及装置
CN103345484A (zh) * 2013-06-21 2013-10-09 中国工商银行股份有限公司 基于动态域的报表处理***及方法
CN104516864A (zh) * 2013-09-30 2015-04-15 北大方正集团有限公司 一种报表生成方法及装置

Family Cites Families (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7188100B2 (en) * 2000-02-25 2007-03-06 Joseph De Bellis Search-on-the-fly report generator
US20050114308A1 (en) * 2003-11-24 2005-05-26 International Business Machines Corporation User customizable reporting
CN101140562A (zh) * 2007-02-14 2008-03-12 中兴通讯股份有限公司 自定义报表的实现方法
US20080250054A1 (en) * 2007-02-20 2008-10-09 Donald Bert Nickel Object based heuristics database platform
CN104317839B (zh) * 2014-10-10 2017-11-14 北京国双科技有限公司 生成报表模板的方法和装置
CN104572813B (zh) * 2014-11-26 2019-02-26 国家电网公司 一种报表生成方法及装置

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101751436A (zh) * 2008-12-19 2010-06-23 ***通信集团山东有限公司 一种生成报表的方法及装置
CN102682126A (zh) * 2012-05-16 2012-09-19 深圳市凯立德科技股份有限公司 一种表单数据的存取方法及装置
CN103345484A (zh) * 2013-06-21 2013-10-09 中国工商银行股份有限公司 基于动态域的报表处理***及方法
CN104516864A (zh) * 2013-09-30 2015-04-15 北大方正集团有限公司 一种报表生成方法及装置

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109446507A (zh) * 2018-11-13 2019-03-08 浙江中智达科技有限公司 一种报表的构建方法及装置

Also Published As

Publication number Publication date
CN106934021B (zh) 2020-06-23
CN106934021A (zh) 2017-07-07

Similar Documents

Publication Publication Date Title
CN111596965B (zh) 项目工程初始化方法、装置、计算机设备和存储介质
US8959106B2 (en) Class loading using java data cartridges
CN109933571B (zh) 数据库设计文档生成方法、装置及计算机可读存储介质
US20190138498A1 (en) Resolving in-memory foreign keys in transmitted data packets from single-parent hierarchies
CN109284261B (zh) 应用查找方法、装置、存储介质及电子设备
US20240143904A1 (en) Human-Computer Interaction Method And Apparatus Thereof
CN109710220B (zh) 关系型数据库查询方法、装置、设备及存储介质
WO2021217846A1 (fr) Procédé et appareil de traitement de données d'interface, et dispositif informatique et support de stockage
CN104268472B (zh) 还原被第三方动态库修改函数地址的方法和装置
CN111158741A (zh) 监控业务模块对第三方类库依赖关系变化的方法及装置
JP2014130547A (ja) ファイル管理プログラム、ファイル管理装置およびファイル管理方法
WO2018161402A1 (fr) Procédé et système de traitement de rapports groupés modulaires
US20120159515A1 (en) Sharing object representations
US20190197123A1 (en) Metadata storage method, device and server
CN107908679B (zh) 脚本语句转换方法、装置及计算机可读存储介质
US8190661B2 (en) Using virtual repository items for customized display
WO2018001041A1 (fr) Procédé et dispositif de mise en œuvre d'interface, boîtier adaptateur et support de stockage
CN114676133A (zh) 索引创建方法、装置、设备及存储介质
US20140298316A1 (en) Managing method for application program installation and electronic device
TW201324347A (zh) 功能模組命令管理系統及方法
JP6110139B2 (ja) ファイル管理プログラム、ファイル管理装置およびファイル管理方法
CN111158777B (zh) 组件调用方法、装置及计算机可读存储介质
CN111488144A (zh) 一种数据处理方法以及设备
CN113849524B (zh) 一种数据处理方法及装置
CN115033592A (zh) 基于数据库的sql语句处理方法、装置、设备及存储介质

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 17899455

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 17899455

Country of ref document: EP

Kind code of ref document: A1