WO2018161401A1 - Data obtaining method and system for associated report - Google Patents

Data obtaining method and system for associated report Download PDF

Info

Publication number
WO2018161401A1
WO2018161401A1 PCT/CN2017/080122 CN2017080122W WO2018161401A1 WO 2018161401 A1 WO2018161401 A1 WO 2018161401A1 CN 2017080122 W CN2017080122 W CN 2017080122W WO 2018161401 A1 WO2018161401 A1 WO 2018161401A1
Authority
WO
WIPO (PCT)
Prior art keywords
data
report
query
association
condition
Prior art date
Application number
PCT/CN2017/080122
Other languages
French (fr)
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 WO2018161401A1 publication Critical patent/WO2018161401A1/en

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
    • G06F16/2453—Query optimisation
    • 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/245—Query processing
    • G06F16/2457—Query processing with adaptation to user needs

Definitions

  • the present invention relates to the field of data processing technologies, and in particular, to a data acquisition method and system for an associated report.
  • the information management system controls and manages the resources, services and generated data of enterprises, which can reduce the management cost of enterprises. And it brings great convenience to the coordination work within the enterprise.
  • data query is inevitably involved. Therefore, the efficiency and complexity of data query greatly affect work efficiency and user experience.
  • each report has its own corresponding query conditions.
  • you need to compare some data for comparison first manually find the appropriate comparison report, and then define the query conditions in the comparison report to get the required data.
  • the operation is cumbersome and inefficient, and the manual input method is difficult to ensure the accuracy of the data query.
  • the object of the present invention is to provide a data acquisition method and system for an associated report to improve the efficiency and accuracy of data query.
  • an embodiment of the present invention provides a data acquisition method for an associated report, where the application to the server includes the following steps:
  • the embodiment of the present invention provides the first possible implementation manner of the first aspect, wherein the switching instruction includes a cell switching instruction, and the original data includes row or column data, according to the The step of the switching instruction parsing the original data of the original report to obtain the first query condition and saving the first query condition as a session object includes:
  • the embodiment of the present invention provides the second possible implementation manner of the first aspect, wherein the switching instruction further includes a query bar switching instruction, where the original data further includes query column data, where the The step of the switching instruction parsing the original data of the original report to obtain the first query condition and saving the first query condition as a session object further includes:
  • the embodiment of the present invention provides the third possible implementation manner of the first aspect, wherein the step of obtaining the target association report according to the switching instruction and the association information includes:
  • the embodiment of the present invention provides a fourth possible implementation manner of the first aspect, wherein the step of performing data filtering on the target association report according to the second query condition to obtain target association data includes: :
  • the embodiment of the present invention further provides a data acquisition system for an associated report, which includes:
  • the server is configured to receive the association information that is sent by the terminal and associate the multiple reports according to the association instruction, send the association information to the database, and receive a switching instruction of the original report sent by the terminal, according to the switching instruction
  • the original data of the report is parsed, the first query condition is obtained, and the first query condition is saved as a session object, and the target association report is obtained according to the switching instruction and the associated information, where the target association report includes a condition object, the session object is matched with the condition object, the condition data of the matching is associated, the second query condition is obtained, and the target association report is filtered according to the second query condition, and the object is obtained.
  • Target associated data includes a condition object, the session object is matched with the condition object, the condition data of the matching is associated, the second query condition is obtained, and the target association report is filtered according to the second query condition, and the object is obtained.
  • the database is configured to save the associated information
  • the terminal is configured to associate multiple reports according to an association instruction to obtain related information.
  • the embodiment of the present invention provides the first possible implementation manner of the second aspect, wherein the switching instruction includes a cell switching instruction, the original data includes row or column data, and the server is further configured to make:
  • the embodiment of the present invention provides the second possible implementation manner of the second aspect, wherein the switching instruction further includes a query bar switching instruction, the original data further includes query column data, and the server further Configured as:
  • the embodiment of the present invention provides a third possible implementation manner of the second aspect, wherein the server is further configured to:
  • the embodiment of the present invention provides a fourth possible implementation manner of the second aspect, wherein the server is further configured to:
  • the server receives the associated information sent by the terminal and associates the multiple reports according to the associated instruction, and sends the related information to the database, so that the database saves and receives the related information.
  • the switching instruction of the original report sent by the terminal parses the original data of the original report according to the switching instruction, obtains the first query condition, and saves the first query condition as a session object, and obtains the target association report according to the switching instruction and the associated information.
  • the target association report includes a condition object, the session object is matched with the condition object, the matching condition data is associated, the second query condition is obtained, and the target association report is filtered according to the second query condition to obtain the target association. data.
  • the invention can improve the efficiency and accuracy of data query.
  • FIG. 1 is a signaling diagram of an association method of a query condition according to Embodiment 1 of the present invention
  • FIG. 2 is a schematic diagram of a first related report page according to Embodiment 1 of the present invention.
  • FIG. 3 is a schematic diagram of a second associated report page according to Embodiment 1 of the present invention.
  • FIG. 4 is a schematic diagram of a third associated report page according to Embodiment 1 of the present invention.
  • FIG. 5 is a schematic diagram of a fourth associated report page according to Embodiment 1 of the present invention.
  • FIG. 6 is a schematic diagram of a fifth related report page according to Embodiment 1 of the present invention.
  • FIG. 7 is a schematic diagram of a sixth related report page according to Embodiment 1 of the present invention.
  • FIG. 8 is a flowchart of a method for associating query conditions according to Embodiment 2 of the present invention.
  • FIG. 9 is a flowchart of a method in step S150 in the method for associating query conditions according to Embodiment 2 of the present invention.
  • step S170 is a flowchart of a method in step S170 in the method for associating query conditions according to Embodiment 2 of the present invention
  • FIG. 11 is a schematic diagram of an association system for query conditions according to Embodiment 3 of the present invention.
  • each report has its own corresponding query conditions.
  • you need to compare some data for comparison first manually find the appropriate comparison report, and then define the query conditions in the comparison report to get the required data.
  • the operation is cumbersome and inefficient, and the manual input method is difficult to ensure the accuracy of the data query.
  • the data acquisition method and system of the associated report provided by the embodiment of the present invention can improve the efficiency and accuracy of the data query.
  • Embodiment 1 is a diagrammatic representation of Embodiment 1:
  • FIG. 1 is a signaling diagram of an association method for query conditions according to Embodiment 1 of the present invention
  • the association method of the query conditions between the associated reports is implemented by the following steps:
  • Step S01 the terminal associates multiple reports according to the association instruction to obtain related information.
  • Step S02 the terminal sends the association information to the database through the server;
  • Step S03 the database saves the associated information
  • each report is configured with its own unique primary key information.
  • different reports are freely associated with each other through the primary key information, and the associated information is obtained, and the related information includes corresponding reports between different reports.
  • the user can also click to edit the associated report to pop up the edit related report page.
  • the page will list all the reports in the system. Users can select other reports to associate with each other according to the actual situation.
  • the related information is saved in the database, which is convenient for future data query.
  • the report with certain association with the current report can be selected for quick access.
  • the terminal can be a computer, but is not limited to this.
  • Step S04 the server receives a switching instruction of the original report sent by the terminal
  • the sales flow report is taken as an example of the original report.
  • the sales flow report the cell data obtained under the limitation of specific query conditions; wherein the data in the query column and the data in the cell together constitute the original data of the original report.
  • the switching instruction is obtained by operating the "Associated Report” interactive button, and the switching instruction is an instruction of the associated report, and the server reads the current original report association relationship from the database, thereby displaying the associated report of the original report for the user at the terminal, for example,
  • the drop-down menu shows all associated reports for the current report. Once the user clicks on the associated report in the drop-down menu, the associated report can be opened.
  • On the page of the sales flow report shown in Figure 3 after operating the "Associated Reports" button, display the "Payment Flow", "Product Sales Summary” and “Cashier Sales Summary” associated with it, and select "Payment Flow” You can switch to the payment flow report page associated with the sales flow report.
  • the display page of the sales flow report is shown in Figure 4.
  • Step S05 the server parses the original data of the original report according to the switching instruction, obtains the first query condition information, and saves the first query condition information as a session object;
  • Step S06 the server acquires target primary key information according to the switching instruction
  • Step S07 the server sends the target primary key information to the database
  • Step S08 The database acquires a target association report according to the association information and the primary key information.
  • Step S09 the database sends the target association report to the server
  • Step S10 The server parses the target association report to obtain a condition object.
  • Step S11 The server matches the session object with the condition object, and associates the successfully matched condition data to obtain the second query condition.
  • Step S12 the server sends the second query condition to the database
  • Step S13 The database performs data filtering on the target association report according to the second query condition, and acquires target association data.
  • Step S14 the database sends the target association data to the terminal through the server;
  • step S15 the terminal displays the target association data.
  • the server parses the original data of the “sales flow” report, and uses the specific value in the parsed column as the first query condition, and saves the session as the session object; meanwhile, the server also According to the target primary key information included in the switching instruction, the "payment flow" report is loaded, and the query column of the parsed "payment flow” report is saved in the condition object, because the query conditions used by different reports are different, in the query condition
  • the query conditions in both the payment flow report and the sales flow report have a date.
  • the first query condition in the sales flow report is the start date is 2016-12-18, and the end date is 2017. -01-16, then the second query condition after the query condition is given to the payment flow report is the query date 2016-12-18 ⁇ 2017-01-16.
  • the row and column data in the current report can also be assigned to the associated report as a query condition.
  • the user selects the corresponding row or column cell and switches to the associated report.
  • the server will parse the data in the row or column cell to use the cell data as The query condition is the same as that described in the previous paragraph.
  • the query condition of the associated report is automatically assigned.
  • the data displayed by the opened related report is automatically determined by the query condition. Referring to Figure 6, the sixth row of data in the cell is selected and switched to the associated Payment Flow report.
  • the document number, organization code, and organization name in the sixth line of data and their respective specific values are parsed into the first query condition and saved in the session object.
  • FIG. 7 for the data of the "payment flow" report displayed by the terminal, it can be seen that the data is obtained by assigning the first query condition to the "payment flow" report.
  • the specific implementation method of automatically assigning the first query condition to the target report and obtaining the second query condition is as follows:
  • the query condition is saved in the database in the configuration mode.
  • Each query condition in each report has name information in addition to its own primary key information.
  • the server When jumping to the associated report, the server will put the current original report. All the query conditions are saved in the session object.
  • the server When the associated report is loaded, the server will match the loaded condition object with the condition in the session object according to the name information. After the matching is successful, the matching condition will be assigned the value of the condition.
  • the event that triggered the query At the same time, for the data in the table row, you can also operate the right button and bring the data related to the current table row to the query condition of the new report.
  • the display column of the table is also saved in the database by configuration, in each report. Each column has its own primary key information, as well as name information.
  • the associated report When selecting a row of data in the report, and getting the right When the key command is used, the associated report will be listed.
  • the server When the associated report is selected, the server will save the data and column information of the row in the session object.
  • the system When the associated report is loaded, the system will load the condition object and the column in the session object. The information is matched according to the name information, and the matching succeeds to match the corresponding row data of the column information on the matching, and the event of the query is triggered after the loading is completed.
  • Embodiment 2 is a diagrammatic representation of Embodiment 1:
  • FIG. 8 is a flowchart of a method for associating query conditions according to Embodiment 2 of the present invention.
  • the server is used as the execution subject, and the association method of the query conditions between the associated reports is implemented by the following steps:
  • Step S110 Receive association information that is sent by the terminal and associates multiple reports according to the association instruction.
  • Step S120 Send the association information to the database, so that the database saves the associated information.
  • Step S130 receiving a switching instruction of the original report sent by the terminal
  • Step S140 parsing the original data of the original report according to the switching instruction, obtaining the first query condition, and saving the first query condition as a session object;
  • Step S150 Obtain a target association report according to the switching instruction and the association information, where the target association report includes a condition object;
  • Step S160 Matching the session object with the condition object, associating the successfully matched condition data, and acquiring the second query condition;
  • Step S170 Perform data filtering on the target association report according to the second query condition, and obtain target association data.
  • the switching instruction includes a cell switching instruction
  • the original data includes row or column data
  • parsing the original data of the original report according to the switching instruction obtaining the first query condition
  • For session objects include:
  • the row or column data is parsed to obtain the first query condition, and the first query condition is saved as a session object.
  • the switching instruction further includes a query bar switching instruction
  • the original data further includes query column data, parsing the original data of the original report according to the switching instruction, obtaining the first query condition, and the first query condition Saving as a session object also includes:
  • the query column data is parsed, the first query condition is obtained, and the first query condition is saved as a session object.
  • obtaining the target association report includes:
  • Step S210 acquiring target primary key information according to the switching instruction
  • Step S220 Send the target primary key information to the database, so that the database obtains the target association report according to the association information and the primary key information;
  • Step S230 Receive a target association report sent by the database, parse the target association report, and obtain a condition object.
  • data filtering is performed on the target association report, and obtaining the target association data includes the following steps:
  • Step S310 Send the second query condition to the database, so that the database performs data filtering on the target association report according to the second query condition, and obtains target association data.
  • Step S320 Receive target association data sent by the database, and send the target association data to the terminal, so that the terminal displays the target association report data.
  • Embodiment 3 is a diagrammatic representation of Embodiment 3
  • FIG. 11 is a schematic diagram of an association system for query conditions according to Embodiment 3 of the present invention.
  • the association system for querying conditions includes a database 100, a server 200, and a terminal 300:
  • the server 200 is configured to receive the association information that is sent by the terminal 300 and associate the multiple reports according to the association instruction, send the association information to the database 100, and receive the switching instruction of the original report sent by the terminal 300, and use the switching instruction to the original report according to the switching instruction.
  • the original data is parsed, the first query condition is obtained, and the first query condition is saved as a session object, and the target association report is obtained according to the switching instruction and the associated information, wherein the target association report includes the condition object, and the session object and the condition object are performed.
  • Matching correlating the successfully matched condition data, obtaining the second query condition, and performing data filtering on the target related report according to the second query condition to obtain the target associated data;
  • the database 100 is configured to save related information
  • the terminal 300 is configured to associate multiple reports according to the association instruction to obtain related information.
  • the switching instruction includes a cell switching instruction
  • the original data includes row or column data
  • the server 200 is further configured to:
  • the row or column data is parsed to obtain the first query condition, and the first query condition is saved as a session object.
  • the switching instruction further includes a query bar switching instruction
  • the original data further includes query column data
  • the server 200 is further configured to:
  • the query column data is parsed, the first query condition is obtained, and the first query condition is saved as a session object.
  • the server 200 is further configured to:
  • the target association report sent by the database 100 is received, and the target association report is parsed to obtain a condition object.
  • the server 200 is further configured to:
  • the target associated data sent by the database 100 is received, and the target associated data is sent to the terminal 300 to cause the terminal 300 to display the target associated report data.
  • the server 200 receives the association information sent by the terminal 300 and associates the plurality of reports according to the association instruction, and sends the association information to the database 100, so that the database 100 pairs the related information.
  • Performing the saving receiving the switching instruction of the original report sent by the terminal 300, parsing the original data of the original report according to the switching instruction, obtaining the first query condition, and saving the first query condition as a session object, according to the switching instruction and the associated information, Obtaining a target association report, wherein the target association report includes a condition object, matching the session object with the condition object, associating the successfully matched condition data, obtaining the second query condition, and performing data on the target association report according to the second query condition Filter to get target association data.
  • the invention can improve the efficiency and accuracy of data query.
  • the computer program product of the data acquisition method and system of the associated report 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 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, which can store program codes.

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)
  • Information Transfer Between Computers (AREA)

Abstract

A data obtaining method and system for an associated report, relating to the technical field of data processing. The method comprises: receiving, by a server, association information sent by a terminal and obtained after establishing an association among multiple reports according to an association instruction (S01); sending the association information to a database (S02) so that the database saves the association information (S03); receiving a switch instruction of an original report sent by a terminal (S04); parsing original data of the original report according to the switch instruction to obtain a first query condition, and saving the first query condition as a session object (S05); obtaining a target associated report according to the switch instruction and the association information (S06-S08), the target associated report comprising a condition object (S10); matching the session object with the condition object, and associating successfully matched condition data to obtain a second query condition (S11); and performing data screening on the target associated report according to the second query condition to obtain target associated data (S13). The method can improve data query efficiency and accuracy.

Description

关联报表的数据获取方法及***Data acquisition method and system for associated report
本申请要求于2017年03月10日提交中国专利局的申请号为CN201710144699.2、名称为“关联报表的数据获取方法及***”的中国专利申请的优先权，其全部内容通过引用结合在本申请中。This application claims priority to the Chinese Patent Application No. CN201710144699.2, entitled "Data Acquisition Method and System for Related Reports" submitted by the Chinese Patent Office on March 10, 2017, the entire contents of which are incorporated herein by reference. In the application.
技术领域Technical field
本发明涉及数据处理技术领域，尤其是涉及一种关联报表的数据获取方法及***。The present invention relates to the field of data processing technologies, and in particular, to a data acquisition method and system for an associated report.
背景技术Background technique
随着信息处理技术的不断发展和完善，数据管理***在企业中的应用越来越普遍，通过信息管理***对企业的资源、业务以及产生的数据进行控制和管理，进而可以降低企业管理成本，而且给企业内部的协调工作带来了极大的便利。在采用数据管理***对企业的资源、业务以及产生的数据进行控制和管理的过程中，不可避免的涉及到数据查询。因此数据查询的效率和复杂度极大的影响着工作效率和用户体验。With the continuous development and improvement of information processing technology, the application of data management system in enterprises is more and more common. The information management system controls and manages the resources, services and generated data of enterprises, which can reduce the management cost of enterprises. And it brings great convenience to the coordination work within the enterprise. In the process of using the data management system to control and manage the resources, services and generated data of the enterprise, data query is inevitably involved. Therefore, the efficiency and complexity of data query greatly affect work efficiency and user experience.
现有的数据管理***中，报表之间的关系不够明朗，使得数据查询，尤其是对于报表中数据的筛选查询的效率较低。一般是在每个报表中都有自己对应的查询条件。当需要讲某些数据进行对比时，首先人工查找用于适合的对比报表，再在对比报表中限定查询条件，得到所需数据。每进行一次数据查询，都要重复上述步骤，操作繁琐效率低，而且手动输入的方式难以保证数据查询的准确性。In the existing data management system, the relationship between the reports is not clear enough, so that the data query, especially for the filtering query of the data in the report, is inefficient. Generally, each report has its own corresponding query conditions. When you need to compare some data for comparison, first manually find the appropriate comparison report, and then define the query conditions in the comparison report to get the required data. Each time a data query is performed, the above steps are repeated, the operation is cumbersome and inefficient, and the manual input method is difficult to ensure the accuracy of the data query.
发明内容Summary of the invention
有鉴于此，本发明的目的在于提供关联报表的数据获取方法及***，以提高数据查询的效率和准确率。In view of this, the object of the present invention is to provide a data acquisition method and system for an associated report to improve the efficiency and accuracy of data query.
第一方面，本发明实施例提供了一种关联报表的数据获取方法，其中，应用于服务器，包括如下步骤：In a first aspect, an embodiment of the present invention provides a data acquisition method for an associated report, where the application to the server includes the following steps:
接收终端发送的根据关联指令将多个报表建立关联得到的关联信息；Receiving, by the terminal, association information obtained by associating a plurality of reports according to an association instruction;
将所述关联信息发送给数据库，以使所述数据库对所述关联信息进行保存；Sending the association information to a database, so that the database saves the associated information;
接收所述终端发送的原始报表的切换指令；Receiving a switching instruction of the original report sent by the terminal;
根据所述切换指令对原始报表的原始数据进行解析，获得第一查询条件，并将所述第一查询条件保存为会话对象； Parsing the original data of the original report according to the switching instruction, obtaining a first query condition, and saving the first query condition as a session object;
根据所述切换指令和所述关联信息，获得目标关联报表，其中，所述目标关联报表包括条件对象；Obtaining a target association report according to the switching instruction and the association information, where the target association report includes a condition object;
将所述会话对象与所述条件对象进行匹配，将匹配成功的条件数据进行关联，获取第二查询条件；Matching the session object with the condition object, associating the successfully matched condition data, and acquiring the second query condition;
根据所述第二查询条件，对所述目标关联报表进行数据筛选，获取目标关联数据。And performing data filtering on the target association report according to the second query condition to obtain target association data.
结合第一方面，本发明实施例提供了第一方面的第一种可能的实施方式，其中，所述切换指令包括单元格切换指令，所述原始数据包括行或列数据，所述根据所述切换指令对原始报表的原始数据进行解析获得第一查询条件并将所述第一查询条件保存为会话对象的步骤包括：With reference to the first aspect, the embodiment of the present invention provides the first possible implementation manner of the first aspect, wherein the switching instruction includes a cell switching instruction, and the original data includes row or column data, according to the The step of the switching instruction parsing the original data of the original report to obtain the first query condition and saving the first query condition as a session object includes:
根据所述单元格切换指令，对所述行或列数据进行解析，获得所述第一查询条件，并将所述第一查询条件保存为所述会话对象。And parsing the row or column data according to the cell switching instruction to obtain the first query condition, and saving the first query condition as the session object.
结合第一方面，本发明实施例提供了第一方面的第二种可能的实施方式，其中，所述切换指令还包括查询栏切换指令，所述原始数据还包括查询栏数据，所述根据所述切换指令对原始报表的原始数据进行解析获得第一查询条件并将所述第一查询条件保存为会话对象的步骤还包括：With reference to the first aspect, the embodiment of the present invention provides the second possible implementation manner of the first aspect, wherein the switching instruction further includes a query bar switching instruction, where the original data further includes query column data, where the The step of the switching instruction parsing the original data of the original report to obtain the first query condition and saving the first query condition as a session object further includes:
根据所述查询栏切换指令，对所述查询栏数据进行解析，获得所述第一查询条件，并将所述第一查询条件保存为所述会话对象。And parsing the query column data according to the query bar switching instruction, obtaining the first query condition, and saving the first query condition as the session object.
结合第一方面，本发明实施例提供了第一方面的第三种可能的实施方式，其中，所述根据所述切换指令和所述关联信息获得目标关联报表的步骤包括：With reference to the first aspect, the embodiment of the present invention provides the third possible implementation manner of the first aspect, wherein the step of obtaining the target association report according to the switching instruction and the association information includes:
根据所述切换指令，获取目标主键信息；Obtaining target primary key information according to the switching instruction;
将所述目标主键信息发送给所述数据库，以使所述数据库根据所述关联信息和所述主键信息获取所述目标关联报表；Sending the target primary key information to the database, so that the database acquires the target association report according to the association information and the primary key information;
接收所述数据库发送的所述目标关联报表，对所述目标关联报表进行解析，获取所述条件对象。Receiving the target association report sent by the database, parsing the target association report, and acquiring the condition object.
结合第一方面，本发明实施例提供了第一方面的第四种可能的实施方式，其中，所述根据所述第二查询条件对所述目标关联报表进行数据筛选获取目标关联数据的步骤包括：With reference to the first aspect, the embodiment of the present invention provides a fourth possible implementation manner of the first aspect, wherein the step of performing data filtering on the target association report according to the second query condition to obtain target association data includes: :
将所述第二查询条件发送给所述数据库，以使所述数据库根据所述第二查询条件对所述目标关联报表进行数据筛选，获取目标关联数据；Sending the second query condition to the database, so that the database performs data filtering on the target association report according to the second query condition, and acquires target association data;
接收所述数据库发送的所述目标关联数据，并将所述目标关联数据发送给所述终端，以使所述终端显示所述目标关联报表数据。Receiving the target association data sent by the database, and sending the target association data to the terminal, so that the terminal displays the target association report data.
第二方面，本发明实施例还提供一种关联报表的数据获取***，其中，包括： In a second aspect, the embodiment of the present invention further provides a data acquisition system for an associated report, which includes:
服务器，配置成接收终端发送的根据关联指令将多个报表建立关联得到的关联信息，将所述关联信息发送给数据库，接收所述终端发送的原始报表的切换指令，根据所述切换指令对原始报表的原始数据进行解析，获得第一查询条件，并将所述第一查询条件保存为会话对象，根据所述切换指令和所述关联信息，获得目标关联报表，其中，所述目标关联报表包括条件对象，将所述会话对象与所述条件对象进行匹配，将匹配成功的条件数据进行关联，获取第二查询条件，根据所述第二查询条件，对所述目标关联报表进行数据筛选，获取目标关联数据；The server is configured to receive the association information that is sent by the terminal and associate the multiple reports according to the association instruction, send the association information to the database, and receive a switching instruction of the original report sent by the terminal, according to the switching instruction The original data of the report is parsed, the first query condition is obtained, and the first query condition is saved as a session object, and the target association report is obtained according to the switching instruction and the associated information, where the target association report includes a condition object, the session object is matched with the condition object, the condition data of the matching is associated, the second query condition is obtained, and the target association report is filtered according to the second query condition, and the object is obtained. Target associated data;
所述数据库，配置成对所述关联信息进行保存；The database is configured to save the associated information;
所述终端，配置成根据关联指令将多个报表建立关联得到关联信息。The terminal is configured to associate multiple reports according to an association instruction to obtain related information.
结合第二方面，本发明实施例提供了第二方面的第一种可能的实施方式，其中，所述切换指令包括单元格切换指令，所述原始数据包括行或列数据，所述服务器还配置成：With reference to the second aspect, the embodiment of the present invention provides the first possible implementation manner of the second aspect, wherein the switching instruction includes a cell switching instruction, the original data includes row or column data, and the server is further configured to make:
根据所述单元格切换指令，对所述行或列数据进行解析，获得所述第一查询条件，并将所述第一查询条件保存为所述会话对象。And parsing the row or column data according to the cell switching instruction to obtain the first query condition, and saving the first query condition as the session object.
结合第二方面，本发明实施例提供了第二方面的第二种可能的实施方式，其中，所述切换指令还包括查询栏切换指令，所述原始数据还包括查询栏数据，所述服务器还配置成：With reference to the second aspect, the embodiment of the present invention provides the second possible implementation manner of the second aspect, wherein the switching instruction further includes a query bar switching instruction, the original data further includes query column data, and the server further Configured as:
根据所述查询栏切换指令，对所述查询栏数据进行解析，获得所述第一查询条件，并将所述第一查询条件保存为所述会话对象。And parsing the query column data according to the query bar switching instruction, obtaining the first query condition, and saving the first query condition as the session object.
结合第二方面，本发明实施例提供了第二方面的第三种可能的实施方式，其中，所述服务器还配置成：With reference to the second aspect, the embodiment of the present invention provides a third possible implementation manner of the second aspect, wherein the server is further configured to:
根据所述切换指令，获取目标主键信息；Obtaining target primary key information according to the switching instruction;
将所述目标主键信息发送给所述数据库，以使所述数据库根据所述关联信息和所述主键信息获取所述目标关联报表；Sending the target primary key information to the database, so that the database acquires the target association report according to the association information and the primary key information;
接收所述数据库发送的所述目标关联报表，对所述目标关联报表进行解析，获取所述条件对象。Receiving the target association report sent by the database, parsing the target association report, and acquiring the condition object.
结合第二方面，本发明实施例提供了第二方面的第四种可能的实施方式，其中，所述服务器还配置成：With reference to the second aspect, the embodiment of the present invention provides a fourth possible implementation manner of the second aspect, wherein the server is further configured to:
将所述第二查询条件发送给所述数据库，以使所述数据库根据所述第二查询条件对所述目标关联报表进行数据筛选，获取目标关联数据；Sending the second query condition to the database, so that the database performs data filtering on the target association report according to the second query condition, and acquires target association data;
接收所述数据库发送的所述目标关联数据，并将所述目标关联数据发送给所述终端，以使所述终端显示所述目标关联报表数据。 Receiving the target association data sent by the database, and sending the target association data to the terminal, so that the terminal displays the target association report data.
本发明提供的关联报表的数据获取方法及***，通过服务器接收终端发送的根据关联指令将多个报表建立关联得到的关联信息，将关联信息发送给数据库，以使数据库对关联信息进行保存，接收终端发送的原始报表的切换指令，根据切换指令对原始报表的原始数据进行解析，获得第一查询条件，并将第一查询条件保存为会话对象，根据切换指令和关联信息，获得目标关联报表，其中，目标关联报表包括条件对象，将会话对象与条件对象进行匹配，将匹配成功的条件数据进行关联，获取第二查询条件，根据第二查询条件，对目标关联报表进行数据筛选，获取目标关联数据。本发明可以提高数据查询的效率和准确率。The data acquisition method and system for the associated report provided by the present invention, the server receives the associated information sent by the terminal and associates the multiple reports according to the associated instruction, and sends the related information to the database, so that the database saves and receives the related information. The switching instruction of the original report sent by the terminal parses the original data of the original report according to the switching instruction, obtains the first query condition, and saves the first query condition as a session object, and obtains the target association report according to the switching instruction and the associated information. The target association report includes a condition object, the session object is matched with the condition object, the matching condition data is associated, the second query condition is obtained, and the target association report is filtered according to the second query condition to obtain the target association. data. The invention can improve the efficiency and accuracy of data query.
本发明的其他特征和优点将在随后的说明书中阐述，并且，部分地从说明书中变得显而易见，或者通过实施本发明而了解。本发明的目的和其他优点在说明书、权利要求书以及附图中所特别指出的结构来实现和获得。Other features and advantages of the invention will be set forth in the description which follows, and The objectives and other advantages of the invention are realized and attained by the invention particularly pointed in
为使本发明的上述目的、特征和优点能更明显易懂，下文特举较佳实施例，并配合所附附图，作详细说明如下。The above described objects, features and advantages of the present invention will become more apparent from the aspects of the appended claims.
附图说明DRAWINGS
为了更清楚地说明本发明具体实施方式或现有技术中的技术方案，下面将对具体实施方式或现有技术描述中所需要使用的附图作简单地介绍，显而易见地，下面描述中的附图是本发明的一些实施方式，对于本领域普通技术人员来讲，在不付出创造性劳动的前提下，还可以根据这些附图获得其他的附图。In order to more clearly illustrate the specific embodiments of the present invention or the technical solutions in the prior art, the drawings to be used in the specific embodiments or the description of the prior art will be briefly described below, and obviously, the attached in the following description The drawings are some embodiments of the present invention, and those skilled in the art can obtain other drawings based on these drawings without any creative work.
图1为本发明实施例一提供的查询条件的关联方法信令图；1 is a signaling diagram of an association method of a query condition according to Embodiment 1 of the present invention;
图2为本发明实施例一提供的第一种关联报表页面示意图；2 is a schematic diagram of a first related report page according to Embodiment 1 of the present invention;
图3为本发明实施例一提供的第二种关联报表页面示意图；FIG. 3 is a schematic diagram of a second associated report page according to Embodiment 1 of the present invention; FIG.
图4为本发明实施例一提供的第三种关联报表页面示意图；4 is a schematic diagram of a third associated report page according to Embodiment 1 of the present invention;
图5为本发明实施例一提供的第四种关联报表页面示意图；FIG. 5 is a schematic diagram of a fourth associated report page according to Embodiment 1 of the present invention; FIG.
图6为本发明实施例一提供的第五种关联报表页面示意图；FIG. 6 is a schematic diagram of a fifth related report page according to Embodiment 1 of the present invention; FIG.
图7为本发明实施例一提供的第六种关联报表页面示意图；FIG. 7 is a schematic diagram of a sixth related report page according to Embodiment 1 of the present invention; FIG.
图8为本发明实施例二提供的查询条件的关联方法流程图；FIG. 8 is a flowchart of a method for associating query conditions according to Embodiment 2 of the present invention;
图9为本发明实施例二提供的查询条件的关联方法中步骤S150的方法流程图；FIG. 9 is a flowchart of a method in step S150 in the method for associating query conditions according to Embodiment 2 of the present invention;
图10为本发明实施例二提供的查询条件的关联方法中步骤S170的方法流程图；10 is a flowchart of a method in step S170 in the method for associating query conditions according to Embodiment 2 of the present invention;
图11为本发明实施例三提供的查询条件的关联***示意图。FIG. 11 is a schematic diagram of an association system for query conditions according to Embodiment 3 of the present invention.
图标： Icon:
100-数据库；200-服务器；300-终端。100-database; 200-server; 300-terminal.
具体实施方式detailed description
为使本发明实施例的目的、技术方案和优点更加清楚，下面将结合附图对本发明的技术方案进行清楚、完整地描述，显然，所描述的实施例是本发明一部分实施例，而不是全部的实施例。基于本发明中的实施例，本领域普通技术人员在没有做出创造性劳动前提下所获得的所有其他实施例，都属于本发明保护的范围。The embodiments of the present invention will be clearly and completely described in detail with reference to the accompanying drawings. An embodiment. All other embodiments obtained by those skilled in the art based on the embodiments of the present invention without creative efforts are within the scope of the present invention.
现有的数据管理***中，报表之间的关系不够明朗，使得数据查询，尤其是对于报表中数据的筛选查询的效率较低。一般是在每个报表中都有自己对应的查询条件。当需要讲某些数据进行对比时，首先人工查找用于适合的对比报表，再在对比报表中限定查询条件，得到所需数据。每进行一次数据查询，都要重复上述步骤，操作繁琐效率低，而且手动输入的方式难以保证数据查询的准确性。In the existing data management system, the relationship between the reports is not clear enough, so that the data query, especially for the filtering query of the data in the report, is inefficient. Generally, each report has its own corresponding query conditions. When you need to compare some data for comparison, first manually find the appropriate comparison report, and then define the query conditions in the comparison report to get the required data. Each time a data query is performed, the above steps are repeated, the operation is cumbersome and inefficient, and the manual input method is difficult to ensure the accuracy of the data query.
基于此，本发明实施例提供的关联报表的数据获取方法及***，可以提高数据查询的效率和准确率。Based on this, the data acquisition method and system of the associated report provided by the embodiment of the present invention can improve the efficiency and accuracy of the data query.
为便于对本实施例进行理解，首先对本发明实施例所公开的查询条件的关联方法进行详细介绍，In order to facilitate the understanding of the embodiment, the method for associating the query conditions disclosed in the embodiments of the present invention is first introduced in detail.
实施例一：Embodiment 1:
图1为本发明实施例一提供的查询条件的关联方法信令图FIG. 1 is a signaling diagram of an association method for query conditions according to Embodiment 1 of the present invention;
参照图1，关联报表之间查询条件的关联方法通过如下步骤实现：Referring to FIG. 1, the association method of the query conditions between the associated reports is implemented by the following steps:
步骤S01，终端根据关联指令将多个报表建立关联得到关联信息；Step S01, the terminal associates multiple reports according to the association instruction to obtain related information.
步骤S02，终端将关联信息通过服务器发送给数据库；Step S02, the terminal sends the association information to the database through the server;
步骤S03，数据库将关联信息进行保存；Step S03, the database saves the associated information;
具体的，每一个报表在创建的时候，都配置有自己的唯一主键信息，根据用户的实际需求，通过主键信息将不同报表自由建立关联关系，得到关联信息，关联信息包括不同报表之间对应的关联关系和报表本身。用户也可以在选中某个报表后，通过点击编辑关联报表弹出编辑关联报表页面，该页面会分类列出本***中所有的报表，用户可以根据实际情况去选择其他报表进行关联，得到关联信息。关联信息保存在数据库中，便于以后数据查询使用，与当前报表建立有一定关联的报表，可以选择快速进入。终端可以是电脑，但并不限于此。Specifically, each report is configured with its own unique primary key information. According to the actual needs of the user, different reports are freely associated with each other through the primary key information, and the associated information is obtained, and the related information includes corresponding reports between different reports. The relationship and the report itself. After selecting a report, the user can also click to edit the associated report to pop up the edit related report page. The page will list all the reports in the system. Users can select other reports to associate with each other according to the actual situation. The related information is saved in the database, which is convenient for future data query. The report with certain association with the current report can be selected for quick access. The terminal can be a computer, but is not limited to this.
步骤S04，服务器接收终端发送的原始报表的切换指令； Step S04, the server receives a switching instruction of the original report sent by the terminal;
具体的，参照图2，以销售流水报表作为原始报表为例进行说明。在终端当前所展示的销售流水报表的页面上，有与切换指令对应的“关联报表”操作按钮；还有输入查询条件具体数值的查询栏，包括开始日期、结束日期、商品类别和商品品牌等等，以及最重要的销售流水报表在特定查询条件的限制下得到的单元格数据；其中，查询栏内的数据和单元格内的数据共同构成了原始报表的原始数据。Specifically, referring to FIG. 2, the sales flow report is taken as an example of the original report. On the page of the sales flow report currently displayed by the terminal, there is an "Associated Report" operation button corresponding to the switching instruction; and a query column for inputting the specific value of the query condition, including the start date, the end date, the product category, the product brand, and the like. And, in the most important, the sales flow report, the cell data obtained under the limitation of specific query conditions; wherein the data in the query column and the data in the cell together constitute the original data of the original report.
切换指令是通过操作“关联报表”交互按键获得的，切换指令即关联报表的指令，服务器从数据库中读取当前的原始报表的关联关系，从而在终端为用户展示原始报表的关联报表，例如通过下拉菜单的方式显示出当前报表的所有关联报表。用户在下拉菜单中点击相应关联报表后，即可打开关联报表。在图3所示的销售流水报表的页面上，对“关联报表”按键进行操作后，展示与其关联的“付款流水”、“商品销售汇总”和“收银员销售汇总”，选择“付款流水”即可切换到与销售流水报表相关联的付款流水报表页面，销售流水报表的展示页面如图4所示。The switching instruction is obtained by operating the "Associated Report" interactive button, and the switching instruction is an instruction of the associated report, and the server reads the current original report association relationship from the database, thereby displaying the associated report of the original report for the user at the terminal, for example, The drop-down menu shows all associated reports for the current report. Once the user clicks on the associated report in the drop-down menu, the associated report can be opened. On the page of the sales flow report shown in Figure 3, after operating the "Associated Reports" button, display the "Payment Flow", "Product Sales Summary" and "Cashier Sales Summary" associated with it, and select "Payment Flow" You can switch to the payment flow report page associated with the sales flow report. The display page of the sales flow report is shown in Figure 4.
另外，在图3中可以看到“编辑关联报表”操作按钮，执行该“编辑关联报表”操作按钮，则获得了关联指令。执行“编辑关联报表”操作按钮的页面如照图5所示，点击编辑关联报表弹出编辑关联报表页面，该页面将分类列出***所有的报表，用户可以根据实际情况去选择报表进行关联。当前报表有一定关联的报表，可以选择后快速进入，且当前报表的查询条件会自动赋予到关联报表中。以销售流水报表为例说明，根据编辑操作可以获取“设置关联报表”页面，该页面分类列出包括档案、采购、促销、零售、礼券管理、礼券查询、销售查询、付款流水和现金查询等全部报表，在其中可以选择付款流水报表进行关联，并将关联信息保存。In addition, in Figure 3, you can see the "Edit Correlation Report" operation button. When you execute the "Edit Correlation Report" operation button, you get the associated instruction. The page for executing the “Edit Association Report” operation button is as shown in Figure 5. Click Edit Association Report to pop up the Edit Association Report page. This page will list all the reports in the system. Users can select the report to associate according to the actual situation. The current report has a certain associated report, you can choose to enter quickly, and the current report query conditions will be automatically assigned to the associated report. Take the sales flow report as an example. According to the editing operation, you can get the “Set Related Report” page, which lists all the files including file, purchase, promotion, retail, gift certificate management, gift certificate inquiry, sales inquiry, payment flow and cash inquiry. A report in which you can select a payment flow report to associate and save the associated information.
步骤S05，服务器根据切换指令对原始报表的原始数据进行解析，获得第一查询条件信息，并将第一查询条件信息保存为会话对象；Step S05, the server parses the original data of the original report according to the switching instruction, obtains the first query condition information, and saves the first query condition information as a session object;
步骤S06，服务器根据切换指令获取目标主键信息；Step S06, the server acquires target primary key information according to the switching instruction;
步骤S07，服务器将目标主键信息发送给数据库；Step S07, the server sends the target primary key information to the database;
步骤S08，数据库根据关联信息和主键信息，获取目标关联报表；Step S08: The database acquires a target association report according to the association information and the primary key information.
步骤S09，数据库将目标关联报表发送给服务器；Step S09, the database sends the target association report to the server;
步骤S10，服务器对目标关联报表进行解析，获取条件对象；Step S10: The server parses the target association report to obtain a condition object.
步骤S11，服务器将会话对象与条件对象进行匹配，将匹配成功的条件数据进行关联，获取第二查询条件；Step S11: The server matches the session object with the condition object, and associates the successfully matched condition data to obtain the second query condition.
步骤S12，服务器将第二查询条件发送给数据库； Step S12, the server sends the second query condition to the database;
步骤S13，数据库根据第二查询条件对目标关联报表进行数据筛选，获取目标关联数据；Step S13: The database performs data filtering on the target association report according to the second query condition, and acquires target association data.
步骤S14，数据库将目标关联数据通过服务器发送给终端；Step S14, the database sends the target association data to the terminal through the server;
步骤S15，终端显示目标关联数据。In step S15, the terminal displays the target association data.
具体的，服务器在接收到切换指令后，将对“销售流水”报表的原始数据进行解析，将解析得到的查询栏内的具体数值作为第一查询条件，并保存为会话对象；同时，服务器还根据切换指令中包括的目标主键信息，加载“付款流水”报表，并将解析得到的“付款流水”报表的查询栏保存在条件对象，由于不同报表所使用的查询条件有所区别，在查询条件自动赋予关联报表中时，只会赋予两个报表都具备的查询条件格式，也就是将会话对象与条件对象进行匹配。从图2和图4中可以看到，付款流水报表与销售流水报表中都具备的查询条件有日期，销售流水报表中的第一查询条件是开始日期为2016-12-18，结束日期为2017-01-16，那么将该查询条件赋予付款流水报表后的第二查询条件就是查询日期2016-12-18～2017-01-16。Specifically, after receiving the switching instruction, the server parses the original data of the “sales flow” report, and uses the specific value in the parsed column as the first query condition, and saves the session as the session object; meanwhile, the server also According to the target primary key information included in the switching instruction, the "payment flow" report is loaded, and the query column of the parsed "payment flow" report is saved in the condition object, because the query conditions used by different reports are different, in the query condition When automatically assigned to an associated report, only the query condition format that both reports have is given, that is, the session object is matched with the condition object. As can be seen from Figure 2 and Figure 4, the query conditions in both the payment flow report and the sales flow report have a date. The first query condition in the sales flow report is the start date is 2016-12-18, and the end date is 2017. -01-16, then the second query condition after the query condition is given to the payment flow report is the query date 2016-12-18~2017-01-16.
另外，对于当前报表中的行和列数据，也可以作为查询条件赋予关联报表中。用户选择相应行或列单元格并切换到关联报表，只要该单元格的数据属于关联报表的第一查询条件，则服务器将对该行或列单元格内的数据进行解析将该单元格数据作为查询条件，同上段所描述的，通过将会话对象与条件对象进行匹配，实现关联报表的查询条件自动赋予功能，打开后的关联报表展示的数据自动由该查询条件限定得到。参照图6，选中了单元格中的第六行数据，并切换到关联的“付款流水”报表。第六行数据中的单据编号、机构编码和机构名称及它们各自的具体数值被解析为第一查询条件，并保存在会话对象中。参照图7，为终端所展示的“付款流水”报表的数据，可以看出，这些数据是将第一查询条件赋予到“付款流水”报表后得到的。In addition, the row and column data in the current report can also be assigned to the associated report as a query condition. The user selects the corresponding row or column cell and switches to the associated report. As long as the data of the cell belongs to the first query condition of the associated report, the server will parse the data in the row or column cell to use the cell data as The query condition is the same as that described in the previous paragraph. By matching the session object with the condition object, the query condition of the associated report is automatically assigned. The data displayed by the opened related report is automatically determined by the query condition. Referring to Figure 6, the sixth row of data in the cell is selected and switched to the associated Payment Flow report. The document number, organization code, and organization name in the sixth line of data and their respective specific values are parsed into the first query condition and saved in the session object. Referring to FIG. 7, for the data of the "payment flow" report displayed by the terminal, it can be seen that the data is obtained by assigning the first query condition to the "payment flow" report.
综上所述，将第一查询条件的自动赋予到目标报表，得到第二查询条件的具体实现方法如下：In summary, the specific implementation method of automatically assigning the first query condition to the target report and obtaining the second query condition is as follows:
查询条件是采用配置方式保存在数据库中的，每个报表中的每个查询条件除了有自己的主键信息，还会有名称信息，当跳转到关联报表时，服务器会把当前的原始报表的所有查询条件保存在会话对象中，在关联报表加载时，服务器会将加载的条件对象与会话对象中的条件根据名称信息做匹配，匹配成功后会赋匹配上的条件的数值，加载完成以后会触发查询的事件。同时，对于表格行中的数据，也可以操作右键，把当前表格行相关的数据，带到新报表的查询条件中去，表格的显示列也是采用配置方式保存在数据库中的，每个报表中的每个列除了有自己的主键信息，还有名称信息，当选择报表的一行数据，并获取右 键指令时会列出关联报表，选择进入的关联报表，服务器会把该行的数据和列信息保存在会话对象中，在关联报表加载时，***会将加载的条件对象与会话对象中的列信息根据名称信息做匹配，匹配成功会赋匹配上的列信息的对应的行数据，加载完成以后会触发查询的事件。The query condition is saved in the database in the configuration mode. Each query condition in each report has name information in addition to its own primary key information. When jumping to the associated report, the server will put the current original report. All the query conditions are saved in the session object. When the associated report is loaded, the server will match the loaded condition object with the condition in the session object according to the name information. After the matching is successful, the matching condition will be assigned the value of the condition. The event that triggered the query. At the same time, for the data in the table row, you can also operate the right button and bring the data related to the current table row to the query condition of the new report. The display column of the table is also saved in the database by configuration, in each report. Each column has its own primary key information, as well as name information. When selecting a row of data in the report, and getting the right When the key command is used, the associated report will be listed. When the associated report is selected, the server will save the data and column information of the row in the session object. When the associated report is loaded, the system will load the condition object and the column in the session object. The information is matched according to the name information, and the matching succeeds to match the corresponding row data of the column information on the matching, and the event of the query is triggered after the loading is completed.
实施例二：Embodiment 2:
图8为本发明实施例二提供的查询条件的关联方法流程图。FIG. 8 is a flowchart of a method for associating query conditions according to Embodiment 2 of the present invention.
参照图8，以服务器为执行主体，关联报表之间查询条件的关联方法通过如下步骤实现：Referring to FIG. 8, the server is used as the execution subject, and the association method of the query conditions between the associated reports is implemented by the following steps:
步骤S110，接收终端发送的根据关联指令将多个报表建立关联得到的关联信息；Step S110: Receive association information that is sent by the terminal and associates multiple reports according to the association instruction.
步骤S120，将关联信息发送给数据库，以使数据库对关联信息进行保存；Step S120: Send the association information to the database, so that the database saves the associated information.
步骤S130，接收终端发送的原始报表的切换指令；Step S130, receiving a switching instruction of the original report sent by the terminal;
步骤S140，根据切换指令对原始报表的原始数据进行解析，获得第一查询条件，并将第一查询条件保存为会话对象；Step S140, parsing the original data of the original report according to the switching instruction, obtaining the first query condition, and saving the first query condition as a session object;
步骤S150，根据切换指令和关联信息，获得目标关联报表，其中，目标关联报表包括条件对象；Step S150: Obtain a target association report according to the switching instruction and the association information, where the target association report includes a condition object;
步骤S160，将会话对象与条件对象进行匹配，将匹配成功的条件数据进行关联，获取第二查询条件；Step S160: Matching the session object with the condition object, associating the successfully matched condition data, and acquiring the second query condition;
步骤S170，根据第二查询条件，对目标关联报表进行数据筛选，获取目标关联数据。Step S170: Perform data filtering on the target association report according to the second query condition, and obtain target association data.
根据本发明的示例性实施例，切换指令包括单元格切换指令，原始数据包括行或列数据，根据切换指令对原始报表的原始数据进行解析，获得第一查询条件，并将第一查询条件保存为会话对象包括：According to an exemplary embodiment of the present invention, the switching instruction includes a cell switching instruction, the original data includes row or column data, parsing the original data of the original report according to the switching instruction, obtaining the first query condition, and saving the first query condition For session objects include:
根据单元格切换指令，对行或列数据进行解析，获得第一查询条件，并将第一查询条件保存为会话对象。According to the cell switching instruction, the row or column data is parsed to obtain the first query condition, and the first query condition is saved as a session object.
根据本发明的示例性实施例，切换指令还包括查询栏切换指令，原始数据还包括查询栏数据，根据切换指令对原始报表的原始数据进行解析，获得第一查询条件，并将第一查询条件保存为会话对象还包括：According to an exemplary embodiment of the present invention, the switching instruction further includes a query bar switching instruction, the original data further includes query column data, parsing the original data of the original report according to the switching instruction, obtaining the first query condition, and the first query condition Saving as a session object also includes:
根据查询栏切换指令，对查询栏数据进行解析，获得第一查询条件，并将第一查询条件保存为会话对象。According to the query bar switching instruction, the query column data is parsed, the first query condition is obtained, and the first query condition is saved as a session object.
根据本发明的示例性实施例，参照图9，根据切换指令和关联信息，获得目标关联报表包括：According to an exemplary embodiment of the present invention, referring to FIG. 9, according to the switching instruction and the associated information, obtaining the target association report includes:
步骤S210，根据切换指令，获取目标主键信息； Step S210, acquiring target primary key information according to the switching instruction;
步骤S220，将目标主键信息发送给数据库，以使数据库根据关联信息和主键信息获取目标关联报表；Step S220: Send the target primary key information to the database, so that the database obtains the target association report according to the association information and the primary key information;
步骤S230，接收数据库发送的目标关联报表，对目标关联报表进行解析，获取条件对象。Step S230: Receive a target association report sent by the database, parse the target association report, and obtain a condition object.
根据本发明的示例性实施例，参照图10，根据第二查询条件，对目标关联报表进行数据筛选，获取目标关联数据包括如下步骤：According to an exemplary embodiment of the present invention, referring to FIG. 10, according to the second query condition, data filtering is performed on the target association report, and obtaining the target association data includes the following steps:
步骤S310，将第二查询条件发送给数据库，以使数据库根据第二查询条件对目标关联报表进行数据筛选，获取目标关联数据；Step S310: Send the second query condition to the database, so that the database performs data filtering on the target association report according to the second query condition, and obtains target association data.
步骤S320，接收数据库发送的目标关联数据，并将目标关联数据发送给终端，以使终端显示目标关联报表数据。Step S320: Receive target association data sent by the database, and send the target association data to the terminal, so that the terminal displays the target association report data.
实施例三：Embodiment 3:
图11为本发明实施例三提供的查询条件的关联***示意图。FIG. 11 is a schematic diagram of an association system for query conditions according to Embodiment 3 of the present invention.
参照图11，查询条件的关联***包括数据库100、服务器200和终端300：Referring to FIG. 11, the association system for querying conditions includes a database 100, a server 200, and a terminal 300:
服务器200，用于接收终端300发送的根据关联指令将多个报表建立关联得到的关联信息，将关联信息发送给数据库100，接收终端300发送的原始报表的切换指令，根据切换指令对原始报表的原始数据进行解析，获得第一查询条件，并将第一查询条件保存为会话对象，根据切换指令和关联信息，获得目标关联报表，其中，目标关联报表包括条件对象，将会话对象与条件对象进行匹配，将匹配成功的条件数据进行关联，获取第二查询条件，根据第二查询条件，对目标关联报表进行数据筛选，获取目标关联数据；The server 200 is configured to receive the association information that is sent by the terminal 300 and associate the multiple reports according to the association instruction, send the association information to the database 100, and receive the switching instruction of the original report sent by the terminal 300, and use the switching instruction to the original report according to the switching instruction. The original data is parsed, the first query condition is obtained, and the first query condition is saved as a session object, and the target association report is obtained according to the switching instruction and the associated information, wherein the target association report includes the condition object, and the session object and the condition object are performed. Matching, correlating the successfully matched condition data, obtaining the second query condition, and performing data filtering on the target related report according to the second query condition to obtain the target associated data;
数据库100，用于对关联信息进行保存；The database 100 is configured to save related information;
终端300，用于根据关联指令将多个报表建立关联得到关联信息。The terminal 300 is configured to associate multiple reports according to the association instruction to obtain related information.
根据本发明的示例性实施例，切换指令包括单元格切换指令，原始数据包括行或列数据，服务器200还用于：According to an exemplary embodiment of the present invention, the switching instruction includes a cell switching instruction, the original data includes row or column data, and the server 200 is further configured to:
根据单元格切换指令，对行或列数据进行解析，获得第一查询条件，并将第一查询条件保存为会话对象。According to the cell switching instruction, the row or column data is parsed to obtain the first query condition, and the first query condition is saved as a session object.
根据本发明的示例性实施例，切换指令还包括查询栏切换指令，原始数据还包括查询栏数据，服务器200还用于：According to an exemplary embodiment of the present invention, the switching instruction further includes a query bar switching instruction, the original data further includes query column data, and the server 200 is further configured to:
根据查询栏切换指令，对查询栏数据进行解析，获得第一查询条件，并将第一查询条件保存为会话对象。According to the query bar switching instruction, the query column data is parsed, the first query condition is obtained, and the first query condition is saved as a session object.
根据本发明的示例性实施例，服务器200还用于：According to an exemplary embodiment of the present invention, the server 200 is further configured to:
根据切换指令，获取目标主键信息； Obtaining target primary key information according to the switching instruction;
将目标主键信息发送给数据库100，以使数据库100根据关联信息和主键信息获取目标关联报表；Sending the target primary key information to the database 100, so that the database 100 obtains the target association report according to the associated information and the primary key information;
接收数据库100发送的目标关联报表，对目标关联报表进行解析，获取条件对象。The target association report sent by the database 100 is received, and the target association report is parsed to obtain a condition object.
根据本发明的示例性实施例，服务器200还用于：According to an exemplary embodiment of the present invention, the server 200 is further configured to:
将第二查询条件发送给数据库100，以使数据库100根据第二查询条件对目标关联报表进行数据筛选，获取目标关联数据；Sending the second query condition to the database 100, so that the database 100 performs data filtering on the target association report according to the second query condition, and acquires target association data;
接收数据库100发送的目标关联数据，并将目标关联数据发送给终端300，以使终端300显示目标关联报表数据。The target associated data sent by the database 100 is received, and the target associated data is sent to the terminal 300 to cause the terminal 300 to display the target associated report data.
本发明提供的关联报表的数据获取方法及***，通过服务器200接收终端300发送的根据关联指令将多个报表建立关联得到的关联信息，将关联信息发送给数据库100，以使数据库100对关联信息进行保存，接收终端300发送的原始报表的切换指令，根据切换指令对原始报表的原始数据进行解析，获得第一查询条件，并将第一查询条件保存为会话对象，根据切换指令和关联信息，获得目标关联报表，其中，目标关联报表包括条件对象，将会话对象与条件对象进行匹配，将匹配成功的条件数据进行关联，获取第二查询条件，根据第二查询条件，对目标关联报表进行数据筛选，获取目标关联数据。本发明可以提高数据查询的效率和准确率。The data acquisition method and system for the associated report provided by the present invention, the server 200 receives the association information sent by the terminal 300 and associates the plurality of reports according to the association instruction, and sends the association information to the database 100, so that the database 100 pairs the related information. Performing the saving, receiving the switching instruction of the original report sent by the terminal 300, parsing the original data of the original report according to the switching instruction, obtaining the first query condition, and saving the first query condition as a session object, according to the switching instruction and the associated information, Obtaining a target association report, wherein the target association report includes a condition object, matching the session object with the condition object, associating the successfully matched condition data, obtaining the second query condition, and performing data on the target association report according to the second query condition Filter to get target association data. The invention can improve the efficiency and accuracy of data query.
本发明实施例所提供的关联报表的数据获取方法及***的计算机程序产品，包括存储了程序代码的计算机可读存储介质，所述程序代码包括的指令可用于执行前面方法实施例中所述的方法，具体实现可参见方法实施例，在此不再赘述。The computer program product of the data acquisition method and system of the associated report 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. For the specific implementation, refer to the method embodiment, and details are not described herein again.
所属领域的技术人员可以清楚地了解到，为描述的方便和简洁，上述描述的***和装置的具体工作过程，可以参考前述方法实施例中的对应过程，在此不再赘述。A person skilled in the art can clearly understand that for the convenience and brevity of the description, the specific working process of the system and the device described above can refer to the corresponding process in the foregoing method embodiments, and details are not described herein again.
另外，在本发明实施例的描述中，除非另有明确的规定和限定，术语“安装”、“相连”、“连接”应做广义理解，例如，可以是固定连接，也可以是可拆卸连接，或一体地连接；可以是机械连接，也可以是电连接；可以是直接相连，也可以通过中间媒介间接相连，可以是两个元件内部的连通。对于本领域的普通技术人员而言，可以具体情况理解上述术语在本发明中的具体含义。In addition, in the description of the embodiments of the present invention, 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. The specific meaning of the above terms in the present invention can be understood in a specific case by those skilled in the art.
所述功能如果以软件功能单元的形式实现并作为独立的产品销售或使用时，可以存储在一个计算机可读取存储介质中。基于这样的理解，本发明的技术方案本质上或者说对现有技术做出贡献的部分或者该技术方案的部分可以以软件产品的形式体现出来，该计算机软件产品存储在一个存储介质中，包括若干指令用以使得一台计算机设备(可以是个人计算机，服务器，或者网络设备等)执行本发明各个实施例所述方法的全部或部分步骤。而 前述的存储介质包括：U盘、移动硬盘、只读存储器(ROM，Read-Only Memory)、随机存取存储器(RAM，Random Access Memory)、磁碟或者光盘等各种可以存储程序代码的介质。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. Based on such understanding, 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. And 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, which can store program codes.
在本发明的描述中，需要说明的是，术语“中心”、“上”、“下”、“左”、“右”、“竖直”、“水平”、“内”、“外”等指示的方位或位置关系为基于附图所示的方位或位置关系，仅是为了便于描述本发明和简化描述，而不是指示或暗示所指的装置或元件必须具有特定的方位、以特定的方位构造和操作，因此不能理解为对本发明的限制。此外，术语“第一”、“第二”、“第三”仅用于描述目的，而不能理解为指示或暗示相对重要性。In the description of the present invention, it is to be noted that the terms "center", "upper", "lower", "left", "right", "vertical", "horizontal", "inside", "outside", etc. The orientation or positional relationship of the indications is based on the orientation or positional relationship shown in the drawings, and is merely for the convenience of the description of the invention and the simplified description, rather than indicating or implying that the device or component referred to has a specific orientation, in a specific orientation. The construction and operation are therefore not to be construed as limiting the invention. Moreover, the terms "first," "second," and "third" are used for descriptive purposes only and are not to be construed as indicating or implying relative importance.
最后应说明的是：以上所述实施例，仅为本发明的具体实施方式，用以说明本发明的技术方案，而非对其限制，本发明的保护范围并不局限于此，尽管参照前述实施例对本发明进行了详细的说明，本领域的普通技术人员应当理解：任何熟悉本技术领域的技术人员在本发明揭露的技术范围内，其依然可以对前述实施例所记载的技术方案进行修改或可轻易想到变化，或者对其中部分技术特征进行等同替换；而这些修改、变化或者替换，并不使相应技术方案的本质脱离本发明实施例技术方案的精神和范围，都应涵盖在本发明的保护范围之内。因此，本发明的保护范围应所述以权利要求的保护范围为准。 Finally, it should be noted that the above-mentioned embodiments are merely specific embodiments of the present invention, and are used to explain the technical solutions of the present invention, and are not limited thereto, and the scope of protection of the present invention is not limited thereto, although reference is made to the foregoing. The present invention has been described in detail, and those skilled in the art should understand that any one skilled in the art can still modify the technical solutions described in the foregoing embodiments within the technical scope disclosed by the present invention. The changes may be easily conceived, or equivalents may be substituted for some of the technical features. The modifications, variations, or substitutions of the present invention are not intended to depart from the spirit and scope of the technical solutions of the embodiments of the present invention. Within the scope of protection. Therefore, the scope of the invention should be determined by the scope of the claims.

Claims (10)

  1. 一种关联报表的数据获取方法，其特征在于，应用于服务器，包括如下步骤：A data acquisition method for an association report, which is characterized in that, the application to the server includes the following steps:
    接收终端发送的根据关联指令将多个报表建立关联得到的关联信息；Receiving, by the terminal, association information obtained by associating a plurality of reports according to an association instruction;
    将所述关联信息发送给数据库，以使所述数据库对所述关联信息进行保存；Sending the association information to a database, so that the database saves the associated information;
    接收所述终端发送的原始报表的切换指令；Receiving a switching instruction of the original report sent by the terminal;
    根据所述切换指令对原始报表的原始数据进行解析，获得第一查询条件，并将所述第一查询条件保存为会话对象；Parsing the original data of the original report according to the switching instruction, obtaining a first query condition, and saving the first query condition as a session object;
    根据所述切换指令和所述关联信息，获得目标关联报表，其中，所述目标关联报表包括条件对象；Obtaining a target association report according to the switching instruction and the association information, where the target association report includes a condition object;
    将所述会话对象与所述条件对象进行匹配，将匹配成功的条件数据进行关联，获取第二查询条件；Matching the session object with the condition object, associating the successfully matched condition data, and acquiring the second query condition;
    根据所述第二查询条件，对所述目标关联报表进行数据筛选，获取目标关联数据。And performing data filtering on the target association report according to the second query condition to obtain target association data.
  2. 根据权利要求1所述的关联报表的数据获取方法，其特征在于，所述切换指令包括单元格切换指令，所述原始数据包括行或列数据，所述根据所述切换指令对原始报表的原始数据进行解析获得第一查询条件并将所述第一查询条件保存为会话对象的步骤包括：The data acquisition method of the associated report according to claim 1, wherein the switching instruction comprises a cell switching instruction, the original data comprises row or column data, and the original report is original according to the switching instruction. The step of parsing the data to obtain the first query condition and saving the first query condition as a session object includes:
    根据所述单元格切换指令，对所述行或列数据进行解析，获得所述第一查询条件，并将所述第一查询条件保存为所述会话对象。And parsing the row or column data according to the cell switching instruction to obtain the first query condition, and saving the first query condition as the session object.
  3. 根据权利要求1所述的关联报表的数据获取方法，其特征在于，所述切换指令还包括查询栏切换指令，所述原始数据还包括查询栏数据，所述根据所述切换指令对原始报表的原始数据进行解析获得第一查询条件并将所述第一查询条件保存为会话对象的步骤还包括：The data acquisition method of the associated report according to claim 1, wherein the switching instruction further includes a query bar switching instruction, the original data further includes query column data, and the switching report is based on the original report The step of parsing the original data to obtain the first query condition and saving the first query condition as a session object further includes:
    根据所述查询栏切换指令，对所述查询栏数据进行解析，获得所述第一查询条件，并将所述第一查询条件保存为所述会话对象。And parsing the query column data according to the query bar switching instruction, obtaining the first query condition, and saving the first query condition as the session object.
  4. 根据权利要求1所述的关联报表的数据获取方法，其特征在于，所述根据所述切换指令和所述关联信息获得目标关联报表的步骤包括：The data acquisition method of the associated report according to claim 1, wherein the step of obtaining the target association report according to the switching instruction and the associated information comprises:
    根据所述切换指令，获取目标主键信息；Obtaining target primary key information according to the switching instruction;
    将所述目标主键信息发送给所述数据库，以使所述数据库根据所述关联信息和所述主键信息获取所述目标关联报表；Sending the target primary key information to the database, so that the database acquires the target association report according to the association information and the primary key information;
    接收所述数据库发送的所述目标关联报表，对所述目标关联报表进行解析，获取所述条件对象。 Receiving the target association report sent by the database, parsing the target association report, and acquiring the condition object.
  5. 根据权利要求1所述的关联报表的数据获取方法，其特征在于，所述根据所述第二查询条件对所述目标关联报表进行数据筛选获取目标关联数据的步骤包括：The data acquisition method of the associated report according to claim 1, wherein the step of performing data filtering on the target association report according to the second query condition to obtain target association data includes:
    将所述第二查询条件发送给所述数据库，以使所述数据库根据所述第二查询条件对所述目标关联报表进行数据筛选，获取目标关联数据；Sending the second query condition to the database, so that the database performs data filtering on the target association report according to the second query condition, and acquires target association data;
    接收所述数据库发送的所述目标关联数据，并将所述目标关联数据发送给所述终端，以使所述终端显示所述目标关联报表数据。Receiving the target association data sent by the database, and sending the target association data to the terminal, so that the terminal displays the target association report data.
  6. 一种关联报表的数据获取***，其特征在于，包括：A data acquisition system for an associated report, comprising:
    服务器，配置成接收终端发送的根据关联指令将多个报表建立关联得到的关联信息，将所述关联信息发送给数据库，接收所述终端发送的原始报表的切换指令，根据所述切换指令对原始报表的原始数据进行解析，获得第一查询条件，并将所述第一查询条件保存为会话对象，根据所述切换指令和所述关联信息，获得目标关联报表，其中，所述目标关联报表包括条件对象，将所述会话对象与所述条件对象进行匹配，将匹配成功的条件数据进行关联，获取第二查询条件，根据所述第二查询条件，对所述目标关联报表进行数据筛选，获取目标关联数据；The server is configured to receive the association information that is sent by the terminal and associate the multiple reports according to the association instruction, send the association information to the database, and receive a switching instruction of the original report sent by the terminal, according to the switching instruction The original data of the report is parsed, the first query condition is obtained, and the first query condition is saved as a session object, and the target association report is obtained according to the switching instruction and the associated information, where the target association report includes a condition object, the session object is matched with the condition object, the condition data of the matching is associated, the second query condition is obtained, and the target association report is filtered according to the second query condition, and the object is obtained. Target associated data;
    所述数据库，配置成对所述关联信息进行保存；The database is configured to save the associated information;
    所述终端，配置成根据关联指令将多个报表建立关联得到关联信息。The terminal is configured to associate multiple reports according to an association instruction to obtain related information.
  7. 根据权利要求6所述的关联报表的数据获取***，其特征在于，所述切换指令包括单元格切换指令，所述原始数据包括行或列数据，所述服务器还配置成：The data acquisition system of the associated report according to claim 6, wherein the switching instruction comprises a cell switching instruction, the original data comprises row or column data, and the server is further configured to:
    根据所述单元格切换指令，对所述行或列数据进行解析，获得所述第一查询条件，并将所述第一查询条件保存为所述会话对象。And parsing the row or column data according to the cell switching instruction to obtain the first query condition, and saving the first query condition as the session object.
  8. 根据权利要求6所述的关联报表的数据获取***，其特征在于，所述切换指令还包括查询栏切换指令，所述原始数据还包括查询栏数据，所述服务器还配置成：The data acquisition system of the associated report according to claim 6, wherein the switching instruction further comprises a query bar switching instruction, the original data further includes query column data, and the server is further configured to:
    根据所述查询栏切换指令，对所述查询栏数据进行解析，获得所述第一查询条件，并将所述第一查询条件保存为所述会话对象。And parsing the query column data according to the query bar switching instruction, obtaining the first query condition, and saving the first query condition as the session object.
  9. 根据权利要求6所述的关联报表的数据获取***，其特征在于，所述服务器还配置成：The data acquisition system of the associated report according to claim 6, wherein the server is further configured to:
    根据所述切换指令，获取目标主键信息；Obtaining target primary key information according to the switching instruction;
    将所述目标主键信息发送给所述数据库，以使所述数据库根据所述关联信息和所述主键信息获取所述目标关联报表；Sending the target primary key information to the database, so that the database acquires the target association report according to the association information and the primary key information;
    接收所述数据库发送的所述目标关联报表，对所述目标关联报表进行解析，获取所述条件对象。 Receiving the target association report sent by the database, parsing the target association report, and acquiring the condition object.
  10. 根据权利要求6所述的关联报表的数据获取***，其特征在于，所述服务器还配置成：The data acquisition system of the associated report according to claim 6, wherein the server is further configured to:
    将所述第二查询条件发送给所述数据库，以使所述数据库根据所述第二查询条件对所述目标关联报表进行数据筛选，获取目标关联数据；Sending the second query condition to the database, so that the database performs data filtering on the target association report according to the second query condition, and acquires target association data;
    接收所述数据库发送的所述目标关联数据，并将所述目标关联数据发送给所述终端，以使所述终端显示所述目标关联报表数据。 Receiving the target association data sent by the database, and sending the target association data to the terminal, so that the terminal displays the target association report data.
PCT/CN2017/080122 2017-03-10 2017-04-11 Data obtaining method and system for associated report WO2018161401A1 (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201710144699.2A CN106919709A (en) 2017-03-10 2017-03-10 Associate the data capture method and system of form
CN201710144699.2 2017-03-10

Publications (1)

Publication Number Publication Date
WO2018161401A1 true WO2018161401A1 (en) 2018-09-13

Family

ID=59461624

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2017/080122 WO2018161401A1 (en) 2017-03-10 2017-04-11 Data obtaining method and system for associated report

Country Status (2)

Country Link
CN (1) CN106919709A (en)
WO (1) WO2018161401A1 (en)

Families Citing this family (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108959495B (en) 2018-06-25 2019-12-06 百度在线网络技术（北京）有限公司 page display method, device, equipment and computer storage medium of H5 webpage
CN109102088A (en) * 2018-08-09 2018-12-28 北京智行者科技有限公司 A kind of processing method of report data
CN109325063B (en) * 2018-09-25 2022-03-15 奇瑞汽车股份有限公司 Data management method and device
CN109471840B (en) * 2018-10-15 2021-10-26 北京海数宝科技有限公司 File viewing method and device, computer equipment and storage medium
CN110889268B (en) * 2019-10-30 2024-04-23 中盈优创资讯科技有限公司 Report generation method and device
CN111078784A (en) * 2019-11-25 2020-04-28 苏宁云计算有限公司 Report automatic recommendation system, method and computer system

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101639855A (en) * 2009-09-02 2010-02-03 华为技术有限公司 Report inquiry method and device thereof
CN101876984A (en) * 2009-12-07 2010-11-03 金蝶软件（中国）有限公司 Data management system and data relation query method and device thereof
US8024650B2 (en) * 2006-03-31 2011-09-20 Microsoft Corporation Drilling on elements in arbitrary ad-hoc reports
CN104050181A (en) * 2013-03-13 2014-09-17 金蝶软件（中国）有限公司 Electronic form penetrating inquiring method and device

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8024650B2 (en) * 2006-03-31 2011-09-20 Microsoft Corporation Drilling on elements in arbitrary ad-hoc reports
CN101639855A (en) * 2009-09-02 2010-02-03 华为技术有限公司 Report inquiry method and device thereof
CN101876984A (en) * 2009-12-07 2010-11-03 金蝶软件（中国）有限公司 Data management system and data relation query method and device thereof
CN104050181A (en) * 2013-03-13 2014-09-17 金蝶软件（中国）有限公司 Electronic form penetrating inquiring method and device

Also Published As

Publication number Publication date
CN106919709A (en) 2017-07-04

Similar Documents

Publication Publication Date Title
WO2018161401A1 (en) Data obtaining method and system for associated report
EP2696551B1 (en) Contact photo providing method, management platform and user terminal
CN111176590B (en) Printing method, device, apparatus and computer readable storage medium based on adaptation
CN106789596B (en) Information attention method, related equipment and system
US20220206994A1 (en) Method and Apparatus for Generating Multimedia File
CN107423070B (en) Page generation method and device
CN102982049B (en) Methods and systems for implementing email recipient templates
CN111340447A (en) Configuration-based business process management method and device
CN102932521B (en) Method and terminal for displaying interaction records of contacts in mobile equipment
CN108353018B (en) Method, device and system for sending message
KR102464240B1 (en) Method for providing information of product brands and electronic apparatus therefor
EP2983346B1 (en) A telecommunication method for controlling communication in a telecommunication system
KR101567138B1 (en) Ordering system and method
CN102111292A (en) Quick configuration method and system of E-mail client-side
WO2019056501A1 (en) Personalized wifi hotspot pushing method, device, and storage medium
KR20120138252A (en) System and method for managing counsel code in automatic response system
US20170310751A1 (en) System and method for cloud storage device detection
JP2002169822A (en) Input support device and recording medium with recorded input support program
CN114500426B (en) Message reminding method, device, computer equipment and storage medium
CN114125139A (en) Information processing method and electronic device
EP3244333B1 (en) Method and device for concealing personal information on calling interface
CN109992179B (en) Session record searching method and device
JP2012198863A (en) Information communication terminal, communication system, and predictive conversion display method
CN112613932A (en) Billing method and device, storage medium and electronic equipment
CN111369349A (en) Transaction node navigation method, device and system

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: 17899859

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: 17899859

Country of ref document: EP

Kind code of ref document: A1