CN103473234A - Method, device and system for deriving report forms from web inquiring system - Google Patents

Abstract

The invention discloses a method for exporting a report from a web query system, which is applied to a client, including: after detecting that a user has triggered a report export operation on the current query result interface, modifying the original query request, adding an export identifier and sending it to the server , to receive the response containing the report file returned by the server. A corresponding method applied on the server is also disclosed, including: receiving the query request sent by the client and generating a query result page, setting a unified identifier for the table object in the query result page, if the query request contains an export identifier, the query result The page is converted into a document object model, and the form object in the document object model is located according to the identifier, and the form object in the document object model is converted into a report file, which is carried in the response and returned to the client. The invention can achieve no intrusion to the query program at the server end, realizes the export of WYSIWYG report files, and improves the efficiency of system development and maintenance.

Description

A method, device and system for exporting reports from a web query system

technical field

The invention relates to the technical field of computer communication, in particular to a method, device and system for exporting reports from a web query system.

Background technique

Reports in Excel format are the most widely used report formats in our work and life today, and it is generally believed that the data required by users can be queried in the web application system through a browser, and then exported to excel. A convenient way to obtain report data.

There are mainly two types of existing methods for exporting reports from the web query system. The first type is to install the excel plug-in provided by Microsoft on the client side where the browser is located. When the user clicks the export button on the query result interface, the browser directly Convert the tabular data displayed on the current web page into an excel file. The disadvantage of this method is that the client must install the excel plug-in, and currently only supports the Internet Explorer browser, and does not support other types of browsers. The second type is to use a pre-defined template on the server side, and after the user clicks the export button after querying the results, the same query conditions are sent to the server again for query, and the query results are assembled into an excel file according to the predefined template format and then response to the client. This method has obvious disadvantages for development: each query page must pre-define the corresponding template. If you want to make the exported excel file achieve what you see is what you get, this requires background developers to be clear about the structure of the front-end web page , and it is very inefficient to modify the background program as the structure of the foreground web page changes, and it is also easy to cause inconsistencies between the display results of the web page and the excel file.

Therefore, in order to achieve WYSIWYG report export and improve the efficiency of web system development and maintenance, the existing methods still need to be improved.

Contents of the invention

The technical problem to be solved by the present invention is to provide a method, device and system for exporting reports from the web query system, which can make the reports derived from the web query system meet the user's WYSIWYG requirements, and improve the development and maintenance of the web query system. efficiency.

In order to solve the above technical problems, the present invention provides a method for exporting reports from the web query system, which is applied to the client, and the method includes:

After detecting that the user triggers the report export operation on the current query result interface, modify the original query request, the modification includes: adding an export identifier, wherein the original query request is the query submitted before to obtain the current query result ask;

Send the modified query request to the server;

A query response including a report file is received from the server, and the report file records the table objects in the query result page to be exported.

Further, the modification of the original query request also includes: if the report export operation triggered by the user is to export all query results and the current query page is paged data, then setting the current page number in the original query request as the home page, and setting The number of records per page is set to the maximum value allowed by the query system performance.

In order to solve the above technical problems, the present invention also provides a method for exporting reports from the web query system, which is applied to the server, and the method includes:

Receive the query request sent by the client, obtain the query result and generate a query result page, and set a unified identifier for the table objects in the query result page when generating the query result page;

If the query request includes an export identifier, convert the query result page into a document object model, locate the table object in the document object model according to the unified identifier, and convert the table object in the document object model into a report document;

The report file is carried in the query response and returned to the client.

Further, the report file is a report file in EXCEL format.

In order to solve the above-mentioned technical problems, the present invention also provides a method for exporting reports from the web query system, the method comprising:

The client executes the above-mentioned method for exporting reports from the web query system applied to the client;

The server executes the above-mentioned method for exporting reports from the web query system applied to the server.

In order to solve the above technical problems, the present invention also provides a device for exporting reports from the web query system, which is applied to the client, including:

The detection module is used to modify the original query request after detecting that the user triggers the report export operation on the current query result interface, the modification includes: adding an export identifier, wherein the original query request was previously used to obtain the current query result of the submitted query request;

A sending module, configured to send the modified query request to the server;

The receiving module is used to receive the query response returned by the server and includes the report file, and the report file records the table objects in the query result page to be exported.

Further, the modification of the original query request also includes: if the report export operation triggered by the user is to export all query results and the current query page is paged data, then setting the current page number in the original query request as the home page, and setting The number of records per page is set to the maximum value allowed by the query system performance.

In order to solve the above technical problems, the present invention also provides a device for exporting reports from the web query system, which is applied to the server, including:

The receiving module is used to receive the query request sent by the client, obtain the query result and generate a query result page, and set a unified identification for the table object in the query result page when generating the query result page;

The conversion module is configured to convert the query result page into a document object model if the query request includes an export identifier, locate the table object in the document object model according to the unified identifier, and convert the table object in the document object model to Table objects are converted to report files;

A sending module, configured to carry the report file in the query response and return it to the client.

Further, the report file is a report file in EXCEL format.

In order to solve the above technical problems, the present invention also provides a system for exporting reports from the web query system, including:

The above-mentioned device for exporting reports from the web query system applied to the client; and the above-mentioned device for exporting reports from the web query system applied to the server.

Compared with the prior art, the method, device and system for exporting reports from the web query system provided by the present invention, through the filtering process of the query request after the client detects that the user has triggered the export report operation, the server side is judging Intercept the response to the query result page after carrying the export identifier in the query request, convert the response into a document object model, locate the form object in the document object model, convert the form object into a report file and return it to the client as a response. Utilizing the present invention to achieve report export can achieve no intrusion into the server-side query program, is not limited by the type of server-side programming language, and is not limited by the source of background data, allowing the system to realize WYSIWYG report files with minimal changes The export can greatly improve the efficiency of web query system development and maintenance.

Description of drawings

FIG. 1 is a flowchart of a method for exporting a report from a web query system (applied to a client) according to an embodiment of the present invention.

FIG. 2 is a display example of the query result page of the embodiment in FIG. 1 .

Fig. 3 is a flowchart of a method for exporting reports from a web query system (applied to a server) according to an embodiment of the present invention.

FIG. 4 is a DOM structure diagram of tabular data in the query result page of FIG. 2 .

FIG. 5 is a flowchart of a method for exporting a report from a web query system (including a client and a server) according to an embodiment of the present invention.

FIG. 6 is a schematic structural diagram of a device for exporting reports from a web query system (applied to a client) according to an embodiment of the present invention.

FIG. 7 is a schematic structural diagram of a device for exporting reports from a web query system (applied to a server) according to an embodiment of the present invention.

FIG. 8 is a schematic structural diagram of a system (including a client and a server) for exporting reports from a web query system according to an embodiment of the present invention.

Detailed ways

In order to make the purpose, technical solution and advantages of the present invention more clear, the embodiments of the present invention will be described in detail below in conjunction with the accompanying drawings. It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined arbitrarily with each other.

As shown in Figure 1, the embodiment of the present invention provides a method for exporting reports from the web query system, which is applied to the client, and the method includes:

S10, after detecting that the user triggers the report export operation on the current query result interface, modify the original query request, the modification includes: adding an export identifier, wherein the original query request is submitted before to obtain the current query result query request;

S20, sending the modified query request to the server;

S30, receiving the query response returned by the server and including the report file, the report file records the table objects in the query result page to be exported.

Step S10 further includes the following features:

Wherein, the modification of the original query request also includes: if the report export operation triggered by the user is to export all query results and the current query page is paged data, then setting the current page number in the original query request as the home page, and setting each The number of page records is set to the maximum value allowed by the performance of the query system. In actual situations, the total number of records under the specified query conditions will not exceed the maximum value;

When the current query page is paged data, no matter which page the current page is, all query results can be derived by modifying the current page number and the number of records per page in the query request;

For example, the page display sample of the current query results is shown in Figure 2. The user enters "23" in the "Age" text box of the current query interface, clicks the "Query" button to get the list data, and then clicks the "Export Report" button to trigger Report export operation. Preferably, the "Export Report" button may include the sub-option "Export All Reports", if the user does not select the sub-option "Export All Reports", the system will export the list data displayed on the current query result interface by default;

Step S30 further includes the following features:

Wherein, the report file records the table object in the query result page to be exported, that is, the table recorded in the report file is exactly the same as the table in the query result page;

As shown in Figure 3, the embodiment of the present invention provides a method for exporting reports from the web query system, which is applied on the server, and the method includes:

S10, receiving the query request sent by the client, obtaining the query result and generating a query result page, and setting a unified identifier for the table objects in the query result page when generating the query result page;

S20, if the query request includes an export identifier, convert the query result page into a document object model, locate a table object in the document object model according to the unified identifier, and convert the table object in the document object model for the report file;

S30. Carry the report file in the query response and return it to the client.

Step S10 further includes the following features:

Wherein, the server obtains the query result according to the query request, including: the server query program queries the data in the database, file system or third-party system according to the query request, and obtains the query result; for example, the query request submitted by the user is: the query age is 23 years old The name of the person, the query result obtained by the server is: a list of names of people whose age is 23 years old, then the tree document structure of the query result page in html format generated by the name list is as follows:

Among them, "contentTable" is a fixed ID number, which is a unified identifier set for the table objects in the query result page when the query result page is generated; that is, in the tree document structure of all query result pages, the query result table objects have the same fixed identifier.

Wherein, the query program on the server side obtains the corresponding query result according to the indication of the current page number and the number of records per page in the query request, and this processing method belongs to the content of the prior art.

Step S20 further includes the following features:

Wherein, judging whether the query request includes an export identifier, if not, returning the query result page to the client as a response, wherein returning the query result page to the client as a query response is a prior art The normal processing method for the server to respond to the query request of the client;

Wherein, the query result page response information is converted into a Document Object Model (Document ObjectModel, DOM), in which the form object is located according to the unified identification, and the form object is converted into a report file;

Wherein, the table recorded in the report file is exactly the same as the table in the query result page;

Wherein, the report file is a report file in EXCEL format;

For example, as shown in Figure 4, taking the query result page response in HTML format as an example, since the page file in HTML format is a tree-structured document, it can be converted into an object of DOM structure first, and in the DOM object model Find the table object whose ID attribute is "contentTable", create an excel report file object according to the row and column information of the table object, loop through each row and column in the table object, and write the column data into the excel report file Cell.

Step S30 further includes the following features:

Wherein, the server returns the report file to the client in the form of data stream for the client to download the file.

As shown in Figure 5, an embodiment of the present invention provides a method for exporting a report form from a web query system, the method comprising:

S10, after the client detects that the user has triggered the report export operation on the current query result interface, it modifies the original query request, the modification includes: adding an export identifier, wherein the original query request is for obtaining the current query result The submitted query request; sending the modified query request to the server; receiving the query response returned by the server and including the report file, the report file records the form object in the query result page to be exported;

S20, the server receives the query request sent by the client, obtains the query result and generates a query result page, and sets a unified identifier for the table objects in the query result page when generating the query result page; if the query request includes an export identifier, the The query result page is converted into a document object model, and the form object in the document object model is located according to the unified identification, and the form object in the document object model is converted into a report file; the report file is carried in the query The response is returned to the client.

As shown in Figure 6, the embodiment of the present invention provides a device for exporting reports from the web query system, which is applied to the client, and the device includes:

The detection module is used to modify the original query request after detecting that the user triggers the report export operation on the current query result interface, the modification includes: adding an export identifier, wherein the original query request was previously used to obtain the current query result of the submitted query request;

A sending module, configured to send the modified query request to the server;

The receiving module is used to receive the query response returned by the server and includes the report file, and the report file records the table objects in the query result page to be exported.

Wherein, the modification of the original query request also includes: if the report export operation triggered by the user is to export all query results and the current query page is paged data, then setting the current page number in the original query request as the home page, and setting each The number of page records is set to the maximum value allowed by the query system performance.

As shown in Figure 7, the embodiment of the present invention provides a device for exporting reports from the web query system, which is applied to the server, and the device includes:

The receiving module is used to receive the query request sent by the client, obtain the query result and generate a query result page, and set a unified identification for the table object in the query result page;

The conversion module is configured to convert the query result page into a document object model if the query request includes an export identifier, locate the table object in the document object model according to the unified identifier, and convert the table object in the document object model to Table objects are converted to report files;

A sending module, configured to carry the report file in the query response and return it to the client.

Wherein, the report file is a report file in EXCEL format.

As shown in Figure 8, an embodiment of the present invention provides a system for exporting reports from a web query system, the system includes:

The client is used to modify the original query request after detecting that the user has triggered the report export operation on the current query result interface. result submitted query request; send the modified query request to the server; receive the query response returned by the server and include the report file, the report file records the form object in the query result page to be exported;

The server is configured to receive the query request sent by the client, obtain the query result and generate a query result page, and set a unified identifier for the table object in the query result page when generating the query result page; if the query request includes an export identifier, Converting the query result page into a document object model, locating the form object in the document object model according to the unified identification, converting the form object in the document object model into a report file; carrying the report file in returned to the client in the query response.

In the method and device for exporting reports from the web query system provided by the above embodiments, the client filters the query request after detecting that the user triggers the operation of exporting the report, and the server determines that the query request carries an export identifier After intercepting the response to the query result page, convert the response into a document object model, locate the form object in the document object model, convert the form object into a report file and return it to the client as a response. Utilizing the present invention to achieve report export can achieve no intrusion into the server-side query program, is not limited by the type of server-side programming language, and is not limited by the source of background data, allowing the system to realize WYSIWYG report files with minimal changes The export can greatly improve the efficiency of web query system development and maintenance.

Those skilled in the art can understand that all or part of the steps in the above method can be completed by instructing relevant hardware through a program, and the program can be stored in a computer-readable storage medium, such as a read-only memory, a magnetic disk or an optical disk, and the like. Optionally, all or part of the steps in the above embodiments can also be implemented using one or more integrated circuits. Correspondingly, each module/unit in the above embodiments can be implemented in the form of hardware, or can be implemented in the form of software function modules. The form is realized. The present invention is not limited to any specific combination of hardware and software.

It should be noted that the present invention can also have other various embodiments, without departing from the spirit and essence of the present invention, those skilled in the art can make various corresponding changes and deformations according to the present invention, but these Corresponding changes and deformations should belong to the scope of protection of the appended claims of the present invention.

Claims (10)

1. a method that derives form from the web inquiry system, be applied on client, and the method comprises:

After the user being detected and having triggered form derive operation on current Query Result interface, revise original query, described modification comprises: increases therein and derives sign, wherein, the inquiry request that described original query is submitted in order to obtain current Query Result before being;

Amended inquiry request is sent to server;

The inquiry response that comprises report file that the reception server end returns, described report file has recorded the table objects in the Query Result page that will derive.

2. the method for claim 1 is characterized in that:

Described modification original query also comprises:

If it is will derive whole Query Results and current query page is the data of paging that the form that the user triggers is derived operation, the current page number in original query is set to homepage, and every page of record count is set to the maximal value that the inquiry system performance allows.

3. a method that derives form from the web inquiry system, be applied on server, and the method comprises:

Receive the inquiry request that client sends, obtain Query Result generated query results page, be that the table objects in the Query Result page arranges unified sign when the generated query results page;

As described in inquiry request comprise and derive sign, by described Query Result conversion of page, be DOM Document Object Model, to the table objects in DOM Document Object Model, the table objects in described DOM Document Object Model is converted to report file according to described unified mark location;

Described report file is carried in inquiry response and turns back to client.

4. method as claimed in claim 3 is characterized in that:

The report file that described report file is the EXCEL form.

5. a method that derives form from the web inquiry system, the method comprises:

The be applied to method from web inquiry system derivation form client on of client executing described in claim 1 or 2;

Server end is carried out the method from web inquiry system derivation form on server that is applied to described in claim 3 or 4.

6. a device of deriving form from the web inquiry system is applied to, on client, comprising:

Detection module, for detection of triggered form derivation operation on current Query Result interface to the user after, revise original query, described modification comprises: increase therein derivation and identify, wherein, the inquiry request that described original query is submitted in order to obtain current Query Result before being;

Sending module, for sending to server by amended inquiry request;

Receiver module, the inquiry response that comprises report file returned for the reception server end, described report file has recorded the table objects in the Query Result page that will derive.

7. device as claimed in claim 6 is characterized in that:

Described modification original query also comprises:

If it is will derive whole Query Results and current query page is the data of paging that the form that the user triggers is derived operation, the current page number in original query is set to homepage, and every page of record count is set to the maximal value that the inquiry system performance allows.

8. a device of deriving form from the web inquiry system is applied to, on server, comprising:

Receiver module, the inquiry request sent for receiving client, obtain Query Result generated query results page, when the generated query results page, is that the table objects in the Query Result page arranges unified sign;

Modular converter, for as described in inquiry request comprise and derive sign, be DOM Document Object Model by described Query Result conversion of page, according to described unified mark location, to the table objects in DOM Document Object Model, the table objects in described DOM Document Object Model be converted to report file;

Sending module, turn back to client for described report file is carried to inquiry response.

9. device as claimed in claim 8 is characterized in that:

The report file that described report file is the EXCEL form.

10. a system that derives form from the web inquiry system comprises:

The device from web inquiry system derivation form be applied on client as described as claim 6 or 7; Reach the device from web inquiry system derivation form be applied to as claimed in claim 8 or 9 on server.

Images