WO2018161401A1 - 关联报表的数据获取方法及*** - Google Patents
关联报表的数据获取方法及*** Download PDFInfo
- 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
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
一种关联报表的数据获取方法及***,涉及数据处理技术领域,通过服务器接收终端发送的根据关联指令将多个报表建立关联得到的关联信息(S01),将关联信息发送给数据库(S02),以使数据库对关联信息进行保存(S03),接收终端发送的原始报表的切换指令(S04),根据切换指令对原始报表的原始数据进行解析,获得第一查询条件,并将第一查询条件保存为会话对象(S05),根据切换指令和关联信息,获得目标关联报表(S06-S08),其中,目标关联报表包括条件对象(S10),将会话对象与条件对象进行匹配,将匹配成功的条件数据进行关联,获取第二查询条件(S11),根据第二查询条件,对目标关联报表进行数据筛选,获取目标关联数据(S13)。可以提高数据查询的效率和准确率。
Description
本申请要求于2017年03月10日提交中国专利局的申请号为CN201710144699.2、名称为“关联报表的数据获取方法及***”的中国专利申请的优先权,其全部内容通过引用结合在本申请中。
本发明涉及数据处理技术领域,尤其是涉及一种关联报表的数据获取方法及***。
随着信息处理技术的不断发展和完善,数据管理***在企业中的应用越来越普遍,通过信息管理***对企业的资源、业务以及产生的数据进行控制和管理,进而可以降低企业管理成本,而且给企业内部的协调工作带来了极大的便利。在采用数据管理***对企业的资源、业务以及产生的数据进行控制和管理的过程中,不可避免的涉及到数据查询。因此数据查询的效率和复杂度极大的影响着工作效率和用户体验。
现有的数据管理***中,报表之间的关系不够明朗,使得数据查询,尤其是对于报表中数据的筛选查询的效率较低。一般是在每个报表中都有自己对应的查询条件。当需要讲某些数据进行对比时,首先人工查找用于适合的对比报表,再在对比报表中限定查询条件,得到所需数据。每进行一次数据查询,都要重复上述步骤,操作繁琐效率低,而且手动输入的方式难以保证数据查询的准确性。
发明内容
有鉴于此,本发明的目的在于提供关联报表的数据获取方法及***,以提高数据查询的效率和准确率。
第一方面,本发明实施例提供了一种关联报表的数据获取方法,其中,应用于服务器,包括如下步骤:
接收终端发送的根据关联指令将多个报表建立关联得到的关联信息;
将所述关联信息发送给数据库,以使所述数据库对所述关联信息进行保存;
接收所述终端发送的原始报表的切换指令;
根据所述切换指令对原始报表的原始数据进行解析,获得第一查询条件,并将所述第一查询条件保存为会话对象;
根据所述切换指令和所述关联信息,获得目标关联报表,其中,所述目标关联报表包括条件对象;
将所述会话对象与所述条件对象进行匹配,将匹配成功的条件数据进行关联,获取第二查询条件;
根据所述第二查询条件,对所述目标关联报表进行数据筛选,获取目标关联数据。
结合第一方面,本发明实施例提供了第一方面的第一种可能的实施方式,其中,所述切换指令包括单元格切换指令,所述原始数据包括行或列数据,所述根据所述切换指令对原始报表的原始数据进行解析获得第一查询条件并将所述第一查询条件保存为会话对象的步骤包括:
根据所述单元格切换指令,对所述行或列数据进行解析,获得所述第一查询条件,并将所述第一查询条件保存为所述会话对象。
结合第一方面,本发明实施例提供了第一方面的第二种可能的实施方式,其中,所述切换指令还包括查询栏切换指令,所述原始数据还包括查询栏数据,所述根据所述切换指令对原始报表的原始数据进行解析获得第一查询条件并将所述第一查询条件保存为会话对象的步骤还包括:
根据所述查询栏切换指令,对所述查询栏数据进行解析,获得所述第一查询条件,并将所述第一查询条件保存为所述会话对象。
结合第一方面,本发明实施例提供了第一方面的第三种可能的实施方式,其中,所述根据所述切换指令和所述关联信息获得目标关联报表的步骤包括:
根据所述切换指令,获取目标主键信息;
将所述目标主键信息发送给所述数据库,以使所述数据库根据所述关联信息和所述主键信息获取所述目标关联报表;
接收所述数据库发送的所述目标关联报表,对所述目标关联报表进行解析,获取所述条件对象。
结合第一方面,本发明实施例提供了第一方面的第四种可能的实施方式,其中,所述根据所述第二查询条件对所述目标关联报表进行数据筛选获取目标关联数据的步骤包括:
将所述第二查询条件发送给所述数据库,以使所述数据库根据所述第二查询条件对所述目标关联报表进行数据筛选,获取目标关联数据;
接收所述数据库发送的所述目标关联数据,并将所述目标关联数据发送给所述终端,以使所述终端显示所述目标关联报表数据。
第二方面,本发明实施例还提供一种关联报表的数据获取***,其中,包括:
服务器,配置成接收终端发送的根据关联指令将多个报表建立关联得到的关联信息,将所述关联信息发送给数据库,接收所述终端发送的原始报表的切换指令,根据所述切换指令对原始报表的原始数据进行解析,获得第一查询条件,并将所述第一查询条件保存为会话对象,根据所述切换指令和所述关联信息,获得目标关联报表,其中,所述目标关联报表包括条件对象,将所述会话对象与所述条件对象进行匹配,将匹配成功的条件数据进行关联,获取第二查询条件,根据所述第二查询条件,对所述目标关联报表进行数据筛选,获取目标关联数据;
所述数据库,配置成对所述关联信息进行保存;
所述终端,配置成根据关联指令将多个报表建立关联得到关联信息。
结合第二方面,本发明实施例提供了第二方面的第一种可能的实施方式,其中,所述切换指令包括单元格切换指令,所述原始数据包括行或列数据,所述服务器还配置成:
根据所述单元格切换指令,对所述行或列数据进行解析,获得所述第一查询条件,并将所述第一查询条件保存为所述会话对象。
结合第二方面,本发明实施例提供了第二方面的第二种可能的实施方式,其中,所述切换指令还包括查询栏切换指令,所述原始数据还包括查询栏数据,所述服务器还配置成:
根据所述查询栏切换指令,对所述查询栏数据进行解析,获得所述第一查询条件,并将所述第一查询条件保存为所述会话对象。
结合第二方面,本发明实施例提供了第二方面的第三种可能的实施方式,其中,所述服务器还配置成:
根据所述切换指令,获取目标主键信息;
将所述目标主键信息发送给所述数据库,以使所述数据库根据所述关联信息和所述主键信息获取所述目标关联报表;
接收所述数据库发送的所述目标关联报表,对所述目标关联报表进行解析,获取所述条件对象。
结合第二方面,本发明实施例提供了第二方面的第四种可能的实施方式,其中,所述服务器还配置成:
将所述第二查询条件发送给所述数据库,以使所述数据库根据所述第二查询条件对所述目标关联报表进行数据筛选,获取目标关联数据;
接收所述数据库发送的所述目标关联数据,并将所述目标关联数据发送给所述终端,以使所述终端显示所述目标关联报表数据。
本发明提供的关联报表的数据获取方法及***,通过服务器接收终端发送的根据关联指令将多个报表建立关联得到的关联信息,将关联信息发送给数据库,以使数据库对关联信息进行保存,接收终端发送的原始报表的切换指令,根据切换指令对原始报表的原始数据进行解析,获得第一查询条件,并将第一查询条件保存为会话对象,根据切换指令和关联信息,获得目标关联报表,其中,目标关联报表包括条件对象,将会话对象与条件对象进行匹配,将匹配成功的条件数据进行关联,获取第二查询条件,根据第二查询条件,对目标关联报表进行数据筛选,获取目标关联数据。本发明可以提高数据查询的效率和准确率。
本发明的其他特征和优点将在随后的说明书中阐述,并且,部分地从说明书中变得显而易见,或者通过实施本发明而了解。本发明的目的和其他优点在说明书、权利要求书以及附图中所特别指出的结构来实现和获得。
为使本发明的上述目的、特征和优点能更明显易懂,下文特举较佳实施例,并配合所附附图,作详细说明如下。
为了更清楚地说明本发明具体实施方式或现有技术中的技术方案,下面将对具体实施方式或现有技术描述中所需要使用的附图作简单地介绍,显而易见地,下面描述中的附图是本发明的一些实施方式,对于本领域普通技术人员来讲,在不付出创造性劳动的前提下,还可以根据这些附图获得其他的附图。
图1为本发明实施例一提供的查询条件的关联方法信令图;
图2为本发明实施例一提供的第一种关联报表页面示意图;
图3为本发明实施例一提供的第二种关联报表页面示意图;
图4为本发明实施例一提供的第三种关联报表页面示意图;
图5为本发明实施例一提供的第四种关联报表页面示意图;
图6为本发明实施例一提供的第五种关联报表页面示意图;
图7为本发明实施例一提供的第六种关联报表页面示意图;
图8为本发明实施例二提供的查询条件的关联方法流程图;
图9为本发明实施例二提供的查询条件的关联方法中步骤S150的方法流程图;
图10为本发明实施例二提供的查询条件的关联方法中步骤S170的方法流程图;
图11为本发明实施例三提供的查询条件的关联***示意图。
图标:
100-数据库;200-服务器;300-终端。
为使本发明实施例的目的、技术方案和优点更加清楚,下面将结合附图对本发明的技术方案进行清楚、完整地描述,显然,所描述的实施例是本发明一部分实施例,而不是全部的实施例。基于本发明中的实施例,本领域普通技术人员在没有做出创造性劳动前提下所获得的所有其他实施例,都属于本发明保护的范围。
现有的数据管理***中,报表之间的关系不够明朗,使得数据查询,尤其是对于报表中数据的筛选查询的效率较低。一般是在每个报表中都有自己对应的查询条件。当需要讲某些数据进行对比时,首先人工查找用于适合的对比报表,再在对比报表中限定查询条件,得到所需数据。每进行一次数据查询,都要重复上述步骤,操作繁琐效率低,而且手动输入的方式难以保证数据查询的准确性。
基于此,本发明实施例提供的关联报表的数据获取方法及***,可以提高数据查询的效率和准确率。
为便于对本实施例进行理解,首先对本发明实施例所公开的查询条件的关联方法进行详细介绍,
实施例一:
图1为本发明实施例一提供的查询条件的关联方法信令图
参照图1,关联报表之间查询条件的关联方法通过如下步骤实现:
步骤S01,终端根据关联指令将多个报表建立关联得到关联信息;
步骤S02,终端将关联信息通过服务器发送给数据库;
步骤S03,数据库将关联信息进行保存;
具体的,每一个报表在创建的时候,都配置有自己的唯一主键信息,根据用户的实际需求,通过主键信息将不同报表自由建立关联关系,得到关联信息,关联信息包括不同报表之间对应的关联关系和报表本身。用户也可以在选中某个报表后,通过点击编辑关联报表弹出编辑关联报表页面,该页面会分类列出本***中所有的报表,用户可以根据实际情况去选择其他报表进行关联,得到关联信息。关联信息保存在数据库中,便于以后数据查询使用,与当前报表建立有一定关联的报表,可以选择快速进入。终端可以是电脑,但并不限于此。
步骤S04,服务器接收终端发送的原始报表的切换指令;
具体的,参照图2,以销售流水报表作为原始报表为例进行说明。在终端当前所展示的销售流水报表的页面上,有与切换指令对应的“关联报表”操作按钮;还有输入查询条件具体数值的查询栏,包括开始日期、结束日期、商品类别和商品品牌等等,以及最重要的销售流水报表在特定查询条件的限制下得到的单元格数据;其中,查询栏内的数据和单元格内的数据共同构成了原始报表的原始数据。
切换指令是通过操作“关联报表”交互按键获得的,切换指令即关联报表的指令,服务器从数据库中读取当前的原始报表的关联关系,从而在终端为用户展示原始报表的关联报表,例如通过下拉菜单的方式显示出当前报表的所有关联报表。用户在下拉菜单中点击相应关联报表后,即可打开关联报表。在图3所示的销售流水报表的页面上,对“关联报表”按键进行操作后,展示与其关联的“付款流水”、“商品销售汇总”和“收银员销售汇总”,选择“付款流水”即可切换到与销售流水报表相关联的付款流水报表页面,销售流水报表的展示页面如图4所示。
另外,在图3中可以看到“编辑关联报表”操作按钮,执行该“编辑关联报表”操作按钮,则获得了关联指令。执行“编辑关联报表”操作按钮的页面如照图5所示,点击编辑关联报表弹出编辑关联报表页面,该页面将分类列出***所有的报表,用户可以根据实际情况去选择报表进行关联。当前报表有一定关联的报表,可以选择后快速进入,且当前报表的查询条件会自动赋予到关联报表中。以销售流水报表为例说明,根据编辑操作可以获取“设置关联报表”页面,该页面分类列出包括档案、采购、促销、零售、礼券管理、礼券查询、销售查询、付款流水和现金查询等全部报表,在其中可以选择付款流水报表进行关联,并将关联信息保存。
步骤S05,服务器根据切换指令对原始报表的原始数据进行解析,获得第一查询条件信息,并将第一查询条件信息保存为会话对象;
步骤S06,服务器根据切换指令获取目标主键信息;
步骤S07,服务器将目标主键信息发送给数据库;
步骤S08,数据库根据关联信息和主键信息,获取目标关联报表;
步骤S09,数据库将目标关联报表发送给服务器;
步骤S10,服务器对目标关联报表进行解析,获取条件对象;
步骤S11,服务器将会话对象与条件对象进行匹配,将匹配成功的条件数据进行关联,获取第二查询条件;
步骤S12,服务器将第二查询条件发送给数据库;
步骤S13,数据库根据第二查询条件对目标关联报表进行数据筛选,获取目标关联数据;
步骤S14,数据库将目标关联数据通过服务器发送给终端;
步骤S15,终端显示目标关联数据。
具体的,服务器在接收到切换指令后,将对“销售流水”报表的原始数据进行解析,将解析得到的查询栏内的具体数值作为第一查询条件,并保存为会话对象;同时,服务器还根据切换指令中包括的目标主键信息,加载“付款流水”报表,并将解析得到的“付款流水”报表的查询栏保存在条件对象,由于不同报表所使用的查询条件有所区别,在查询条件自动赋予关联报表中时,只会赋予两个报表都具备的查询条件格式,也就是将会话对象与条件对象进行匹配。从图2和图4中可以看到,付款流水报表与销售流水报表中都具备的查询条件有日期,销售流水报表中的第一查询条件是开始日期为2016-12-18,结束日期为2017-01-16,那么将该查询条件赋予付款流水报表后的第二查询条件就是查询日期2016-12-18~2017-01-16。
另外,对于当前报表中的行和列数据,也可以作为查询条件赋予关联报表中。用户选择相应行或列单元格并切换到关联报表,只要该单元格的数据属于关联报表的第一查询条件,则服务器将对该行或列单元格内的数据进行解析将该单元格数据作为查询条件,同上段所描述的,通过将会话对象与条件对象进行匹配,实现关联报表的查询条件自动赋予功能,打开后的关联报表展示的数据自动由该查询条件限定得到。参照图6,选中了单元格中的第六行数据,并切换到关联的“付款流水”报表。第六行数据中的单据编号、机构编码和机构名称及它们各自的具体数值被解析为第一查询条件,并保存在会话对象中。参照图7,为终端所展示的“付款流水”报表的数据,可以看出,这些数据是将第一查询条件赋予到“付款流水”报表后得到的。
综上所述,将第一查询条件的自动赋予到目标报表,得到第二查询条件的具体实现方法如下:
查询条件是采用配置方式保存在数据库中的,每个报表中的每个查询条件除了有自己的主键信息,还会有名称信息,当跳转到关联报表时,服务器会把当前的原始报表的所有查询条件保存在会话对象中,在关联报表加载时,服务器会将加载的条件对象与会话对象中的条件根据名称信息做匹配,匹配成功后会赋匹配上的条件的数值,加载完成以后会触发查询的事件。同时,对于表格行中的数据,也可以操作右键,把当前表格行相关的数据,带到新报表的查询条件中去,表格的显示列也是采用配置方式保存在数据库中的,每个报表中的每个列除了有自己的主键信息,还有名称信息,当选择报表的一行数据,并获取右
键指令时会列出关联报表,选择进入的关联报表,服务器会把该行的数据和列信息保存在会话对象中,在关联报表加载时,***会将加载的条件对象与会话对象中的列信息根据名称信息做匹配,匹配成功会赋匹配上的列信息的对应的行数据,加载完成以后会触发查询的事件。
实施例二:
图8为本发明实施例二提供的查询条件的关联方法流程图。
参照图8,以服务器为执行主体,关联报表之间查询条件的关联方法通过如下步骤实现:
步骤S110,接收终端发送的根据关联指令将多个报表建立关联得到的关联信息;
步骤S120,将关联信息发送给数据库,以使数据库对关联信息进行保存;
步骤S130,接收终端发送的原始报表的切换指令;
步骤S140,根据切换指令对原始报表的原始数据进行解析,获得第一查询条件,并将第一查询条件保存为会话对象;
步骤S150,根据切换指令和关联信息,获得目标关联报表,其中,目标关联报表包括条件对象;
步骤S160,将会话对象与条件对象进行匹配,将匹配成功的条件数据进行关联,获取第二查询条件;
步骤S170,根据第二查询条件,对目标关联报表进行数据筛选,获取目标关联数据。
根据本发明的示例性实施例,切换指令包括单元格切换指令,原始数据包括行或列数据,根据切换指令对原始报表的原始数据进行解析,获得第一查询条件,并将第一查询条件保存为会话对象包括:
根据单元格切换指令,对行或列数据进行解析,获得第一查询条件,并将第一查询条件保存为会话对象。
根据本发明的示例性实施例,切换指令还包括查询栏切换指令,原始数据还包括查询栏数据,根据切换指令对原始报表的原始数据进行解析,获得第一查询条件,并将第一查询条件保存为会话对象还包括:
根据查询栏切换指令,对查询栏数据进行解析,获得第一查询条件,并将第一查询条件保存为会话对象。
根据本发明的示例性实施例,参照图9,根据切换指令和关联信息,获得目标关联报表包括:
步骤S210,根据切换指令,获取目标主键信息;
步骤S220,将目标主键信息发送给数据库,以使数据库根据关联信息和主键信息获取目标关联报表;
步骤S230,接收数据库发送的目标关联报表,对目标关联报表进行解析,获取条件对象。
根据本发明的示例性实施例,参照图10,根据第二查询条件,对目标关联报表进行数据筛选,获取目标关联数据包括如下步骤:
步骤S310,将第二查询条件发送给数据库,以使数据库根据第二查询条件对目标关联报表进行数据筛选,获取目标关联数据;
步骤S320,接收数据库发送的目标关联数据,并将目标关联数据发送给终端,以使终端显示目标关联报表数据。
实施例三:
图11为本发明实施例三提供的查询条件的关联***示意图。
参照图11,查询条件的关联***包括数据库100、服务器200和终端300:
服务器200,用于接收终端300发送的根据关联指令将多个报表建立关联得到的关联信息,将关联信息发送给数据库100,接收终端300发送的原始报表的切换指令,根据切换指令对原始报表的原始数据进行解析,获得第一查询条件,并将第一查询条件保存为会话对象,根据切换指令和关联信息,获得目标关联报表,其中,目标关联报表包括条件对象,将会话对象与条件对象进行匹配,将匹配成功的条件数据进行关联,获取第二查询条件,根据第二查询条件,对目标关联报表进行数据筛选,获取目标关联数据;
数据库100,用于对关联信息进行保存;
终端300,用于根据关联指令将多个报表建立关联得到关联信息。
根据本发明的示例性实施例,切换指令包括单元格切换指令,原始数据包括行或列数据,服务器200还用于:
根据单元格切换指令,对行或列数据进行解析,获得第一查询条件,并将第一查询条件保存为会话对象。
根据本发明的示例性实施例,切换指令还包括查询栏切换指令,原始数据还包括查询栏数据,服务器200还用于:
根据查询栏切换指令,对查询栏数据进行解析,获得第一查询条件,并将第一查询条件保存为会话对象。
根据本发明的示例性实施例,服务器200还用于:
根据切换指令,获取目标主键信息;
将目标主键信息发送给数据库100,以使数据库100根据关联信息和主键信息获取目标关联报表;
接收数据库100发送的目标关联报表,对目标关联报表进行解析,获取条件对象。
根据本发明的示例性实施例,服务器200还用于:
将第二查询条件发送给数据库100,以使数据库100根据第二查询条件对目标关联报表进行数据筛选,获取目标关联数据;
接收数据库100发送的目标关联数据,并将目标关联数据发送给终端300,以使终端300显示目标关联报表数据。
本发明提供的关联报表的数据获取方法及***,通过服务器200接收终端300发送的根据关联指令将多个报表建立关联得到的关联信息,将关联信息发送给数据库100,以使数据库100对关联信息进行保存,接收终端300发送的原始报表的切换指令,根据切换指令对原始报表的原始数据进行解析,获得第一查询条件,并将第一查询条件保存为会话对象,根据切换指令和关联信息,获得目标关联报表,其中,目标关联报表包括条件对象,将会话对象与条件对象进行匹配,将匹配成功的条件数据进行关联,获取第二查询条件,根据第二查询条件,对目标关联报表进行数据筛选,获取目标关联数据。本发明可以提高数据查询的效率和准确率。
本发明实施例所提供的关联报表的数据获取方法及***的计算机程序产品,包括存储了程序代码的计算机可读存储介质,所述程序代码包括的指令可用于执行前面方法实施例中所述的方法,具体实现可参见方法实施例,在此不再赘述。
所属领域的技术人员可以清楚地了解到,为描述的方便和简洁,上述描述的***和装置的具体工作过程,可以参考前述方法实施例中的对应过程,在此不再赘述。
另外,在本发明实施例的描述中,除非另有明确的规定和限定,术语“安装”、“相连”、“连接”应做广义理解,例如,可以是固定连接,也可以是可拆卸连接,或一体地连接;可以是机械连接,也可以是电连接;可以是直接相连,也可以通过中间媒介间接相连,可以是两个元件内部的连通。对于本领域的普通技术人员而言,可以具体情况理解上述术语在本发明中的具体含义。
所述功能如果以软件功能单元的形式实现并作为独立的产品销售或使用时,可以存储在一个计算机可读取存储介质中。基于这样的理解,本发明的技术方案本质上或者说对现有技术做出贡献的部分或者该技术方案的部分可以以软件产品的形式体现出来,该计算机软件产品存储在一个存储介质中,包括若干指令用以使得一台计算机设备(可以是个人计算机,服务器,或者网络设备等)执行本发明各个实施例所述方法的全部或部分步骤。而
前述的存储介质包括:U盘、移动硬盘、只读存储器(ROM,Read-Only Memory)、随机存取存储器(RAM,Random Access Memory)、磁碟或者光盘等各种可以存储程序代码的介质。
在本发明的描述中,需要说明的是,术语“中心”、“上”、“下”、“左”、“右”、“竖直”、“水平”、“内”、“外”等指示的方位或位置关系为基于附图所示的方位或位置关系,仅是为了便于描述本发明和简化描述,而不是指示或暗示所指的装置或元件必须具有特定的方位、以特定的方位构造和操作,因此不能理解为对本发明的限制。此外,术语“第一”、“第二”、“第三”仅用于描述目的,而不能理解为指示或暗示相对重要性。
最后应说明的是:以上所述实施例,仅为本发明的具体实施方式,用以说明本发明的技术方案,而非对其限制,本发明的保护范围并不局限于此,尽管参照前述实施例对本发明进行了详细的说明,本领域的普通技术人员应当理解:任何熟悉本技术领域的技术人员在本发明揭露的技术范围内,其依然可以对前述实施例所记载的技术方案进行修改或可轻易想到变化,或者对其中部分技术特征进行等同替换;而这些修改、变化或者替换,并不使相应技术方案的本质脱离本发明实施例技术方案的精神和范围,都应涵盖在本发明的保护范围之内。因此,本发明的保护范围应所述以权利要求的保护范围为准。
Claims (10)
- 一种关联报表的数据获取方法,其特征在于,应用于服务器,包括如下步骤:接收终端发送的根据关联指令将多个报表建立关联得到的关联信息;将所述关联信息发送给数据库,以使所述数据库对所述关联信息进行保存;接收所述终端发送的原始报表的切换指令;根据所述切换指令对原始报表的原始数据进行解析,获得第一查询条件,并将所述第一查询条件保存为会话对象;根据所述切换指令和所述关联信息,获得目标关联报表,其中,所述目标关联报表包括条件对象;将所述会话对象与所述条件对象进行匹配,将匹配成功的条件数据进行关联,获取第二查询条件;根据所述第二查询条件,对所述目标关联报表进行数据筛选,获取目标关联数据。
- 根据权利要求1所述的关联报表的数据获取方法,其特征在于,所述切换指令包括单元格切换指令,所述原始数据包括行或列数据,所述根据所述切换指令对原始报表的原始数据进行解析获得第一查询条件并将所述第一查询条件保存为会话对象的步骤包括:根据所述单元格切换指令,对所述行或列数据进行解析,获得所述第一查询条件,并将所述第一查询条件保存为所述会话对象。
- 根据权利要求1所述的关联报表的数据获取方法,其特征在于,所述切换指令还包括查询栏切换指令,所述原始数据还包括查询栏数据,所述根据所述切换指令对原始报表的原始数据进行解析获得第一查询条件并将所述第一查询条件保存为会话对象的步骤还包括:根据所述查询栏切换指令,对所述查询栏数据进行解析,获得所述第一查询条件,并将所述第一查询条件保存为所述会话对象。
- 根据权利要求1所述的关联报表的数据获取方法,其特征在于,所述根据所述切换指令和所述关联信息获得目标关联报表的步骤包括:根据所述切换指令,获取目标主键信息;将所述目标主键信息发送给所述数据库,以使所述数据库根据所述关联信息和所述主键信息获取所述目标关联报表;接收所述数据库发送的所述目标关联报表,对所述目标关联报表进行解析,获取所述条件对象。
- 根据权利要求1所述的关联报表的数据获取方法,其特征在于,所述根据所述第二查询条件对所述目标关联报表进行数据筛选获取目标关联数据的步骤包括:将所述第二查询条件发送给所述数据库,以使所述数据库根据所述第二查询条件对所述目标关联报表进行数据筛选,获取目标关联数据;接收所述数据库发送的所述目标关联数据,并将所述目标关联数据发送给所述终端,以使所述终端显示所述目标关联报表数据。
- 一种关联报表的数据获取***,其特征在于,包括:服务器,配置成接收终端发送的根据关联指令将多个报表建立关联得到的关联信息,将所述关联信息发送给数据库,接收所述终端发送的原始报表的切换指令,根据所述切换指令对原始报表的原始数据进行解析,获得第一查询条件,并将所述第一查询条件保存为会话对象,根据所述切换指令和所述关联信息,获得目标关联报表,其中,所述目标关联报表包括条件对象,将所述会话对象与所述条件对象进行匹配,将匹配成功的条件数据进行关联,获取第二查询条件,根据所述第二查询条件,对所述目标关联报表进行数据筛选,获取目标关联数据;所述数据库,配置成对所述关联信息进行保存;所述终端,配置成根据关联指令将多个报表建立关联得到关联信息。
- 根据权利要求6所述的关联报表的数据获取***,其特征在于,所述切换指令包括单元格切换指令,所述原始数据包括行或列数据,所述服务器还配置成:根据所述单元格切换指令,对所述行或列数据进行解析,获得所述第一查询条件,并将所述第一查询条件保存为所述会话对象。
- 根据权利要求6所述的关联报表的数据获取***,其特征在于,所述切换指令还包括查询栏切换指令,所述原始数据还包括查询栏数据,所述服务器还配置成:根据所述查询栏切换指令,对所述查询栏数据进行解析,获得所述第一查询条件,并将所述第一查询条件保存为所述会话对象。
- 根据权利要求6所述的关联报表的数据获取***,其特征在于,所述服务器还配置成:根据所述切换指令,获取目标主键信息;将所述目标主键信息发送给所述数据库,以使所述数据库根据所述关联信息和所述主键信息获取所述目标关联报表;接收所述数据库发送的所述目标关联报表,对所述目标关联报表进行解析,获取所述条件对象。
- 根据权利要求6所述的关联报表的数据获取***,其特征在于,所述服务器还配置成:将所述第二查询条件发送给所述数据库,以使所述数据库根据所述第二查询条件对所述目标关联报表进行数据筛选,获取目标关联数据;接收所述数据库发送的所述目标关联数据,并将所述目标关联数据发送给所述终端,以使所述终端显示所述目标关联报表数据。
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710144699.2A CN106919709A (zh) | 2017-03-10 | 2017-03-10 | 关联报表的数据获取方法及*** |
CN201710144699.2 | 2017-03-10 |
Publications (1)
Publication Number | Publication Date |
---|---|
WO2018161401A1 true WO2018161401A1 (zh) | 2018-09-13 |
Family
ID=59461624
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
PCT/CN2017/080122 WO2018161401A1 (zh) | 2017-03-10 | 2017-04-11 | 关联报表的数据获取方法及*** |
Country Status (2)
Country | Link |
---|---|
CN (1) | CN106919709A (zh) |
WO (1) | WO2018161401A1 (zh) |
Families Citing this family (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN108959495B (zh) | 2018-06-25 | 2019-12-06 | 百度在线网络技术(北京)有限公司 | H5网页的页面显示方法、装置、设备和计算机存储介质 |
CN109102088A (zh) * | 2018-08-09 | 2018-12-28 | 北京智行者科技有限公司 | 一种报表数据的处理方法 |
CN109325063B (zh) * | 2018-09-25 | 2022-03-15 | 奇瑞汽车股份有限公司 | 数据管理方法及装置 |
CN109471840B (zh) * | 2018-10-15 | 2021-10-26 | 北京海数宝科技有限公司 | 文件查看方法、装置、计算机设备和存储介质 |
CN110889268B (zh) * | 2019-10-30 | 2024-04-23 | 中盈优创资讯科技有限公司 | 报表生成方法及装置 |
CN111078784A (zh) * | 2019-11-25 | 2020-04-28 | 苏宁云计算有限公司 | 报表自动推荐***、方法及计算机*** |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101639855A (zh) * | 2009-09-02 | 2010-02-03 | 华为技术有限公司 | 报表查询方法和装置 |
CN101876984A (zh) * | 2009-12-07 | 2010-11-03 | 金蝶软件(中国)有限公司 | 一种数据管理***及其数据关联查询方法和装置 |
US8024650B2 (en) * | 2006-03-31 | 2011-09-20 | Microsoft Corporation | Drilling on elements in arbitrary ad-hoc reports |
CN104050181A (zh) * | 2013-03-13 | 2014-09-17 | 金蝶软件(中国)有限公司 | 一种电子表单穿透查询方法和装置 |
-
2017
- 2017-03-10 CN CN201710144699.2A patent/CN106919709A/zh active Pending
- 2017-04-11 WO PCT/CN2017/080122 patent/WO2018161401A1/zh active Application Filing
Patent Citations (4)
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 (zh) * | 2009-09-02 | 2010-02-03 | 华为技术有限公司 | 报表查询方法和装置 |
CN101876984A (zh) * | 2009-12-07 | 2010-11-03 | 金蝶软件(中国)有限公司 | 一种数据管理***及其数据关联查询方法和装置 |
CN104050181A (zh) * | 2013-03-13 | 2014-09-17 | 金蝶软件(中国)有限公司 | 一种电子表单穿透查询方法和装置 |
Also Published As
Publication number | Publication date |
---|---|
CN106919709A (zh) | 2017-07-04 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
WO2018161401A1 (zh) | 关联报表的数据获取方法及*** | |
EP2696551B1 (en) | Contact photo providing method, management platform and user terminal | |
CN111176590B (zh) | 基于适配的打印方法、设备、装置及计算机可读存储介质 | |
CN106789596B (zh) | 一种信息关注方法、相关设备及*** | |
US20220206994A1 (en) | Method and Apparatus for Generating Multimedia File | |
CN107423070B (zh) | 一种页面生成方法及装置 | |
CN111340447A (zh) | 基于配置式的业务流程管理方法及装置 | |
CN102932521B (zh) | 移动设备中联系人的交互记录显示方法和终端 | |
CN108353018B (zh) | 发送消息的方法、设备和*** | |
CN105546724B (zh) | 语音控制方法及***、客户端、控制装置 | |
KR102464240B1 (ko) | 상품의 브랜드 정보를 제공하는 방법 및 이를 위한 전자 장치 | |
EP2983346B1 (en) | A telecommunication method for controlling communication in a telecommunication system | |
KR101567138B1 (ko) | 주문 시스템 및 방법 | |
CN102111292A (zh) | 电子邮件客户端的快速配置方法及*** | |
WO2019056501A1 (zh) | 个性化Wi-Fi热点推送方法、装置及存储介质 | |
KR20120138252A (ko) | 자동응답시스템의 상담 관리 시스템 및 방법 | |
US20170310751A1 (en) | System and method for cloud storage device detection | |
JP2002169822A (ja) | 入力支援装置及び入力支援プログラムを記録した記録媒体 | |
CN109542357A (zh) | 一种命令参数组装方法、***、设备及计算机存储介质 | |
CN114500426B (zh) | 消息提醒方法、装置、计算机设备和存储介质 | |
CN114125139A (zh) | 信息处理方法和电子设备 | |
EP3244333B1 (en) | Method and device for concealing personal information on calling interface | |
CN109992179B (zh) | 会话记录查找方法以及装置 | |
JP2012198863A (ja) | 情報通信端末、通信システム及び予測変換表示方法 | |
CN111126997B (zh) | 基于识别码的信息处理方法、设备以及存储介质 |
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 |